SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001355s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 201424 LIMIT 1 [ RunTime:0.000384s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 201424 [ RunTime:0.002152s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (214086,706936,155014,12255,786412,602257,421445,809163,748725,219666,1036535,799493,278526,298856,942382,976306,13404,1001177,853476,1020883,259338,21056,136801,567860,8368,223652,631329,471493,437492,935853,903594,786444,513822,641855,659751,167171,945680,670853,247608,586261,34888,671770,383856,619318,220030,341531,586800,41556,729333,57019,57299,541648,229446,562729,1003388,176314,510345,372912,719518,949727) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001253s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 201424 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000467s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 201424 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000629s ]