SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001243s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 104344 LIMIT 1 [ RunTime:0.000397s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 104344 [ RunTime:0.001913s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (264808,342030,976621,644219,364794,926401,863174,271241,3084,577556,755599,932681,350216,527402,187131,888880,913401,496529,247764,913852,286801,325639,1041471,699255,390534,596320,901481,667366,252630,74738,400312,536122,781653,974858,979277,915248,127392,618333,571414,528841,435718,166840,965900,250531,787853,78073,82211,856471,802494,419438,888886,121634,737646,793511,247089,267948,66400,125807,904045,723425) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001593s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 104344 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000342s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 104344 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000623s ]