SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001424s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 54538 LIMIT 1 [ RunTime:0.000290s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 54538 [ RunTime:0.002262s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (48485,298637,191418,263022,523692,864943,976183,345247,143161,975171,957041,966489,1024205,29952,88561,737593,223978,7413,8445,863891,3710,647098,315049,546964,352123,916292,389554,358674,505025,378545,580535,423005,78903,317901,48082,432228,224613,1003150,72647,189712,61269,855645,78574,298720,79071,472506,86914,612930,615997,550587,80661,950279,528768,570038,799524,512693,853298,973354,952476,490012) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001152s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 54538 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000398s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 54538 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000654s ]