SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001316s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 410500 LIMIT 1 [ RunTime:0.000400s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 410500 [ RunTime:0.001571s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1022957,377763,839762,634905,772658,644977,776770,326784,488246,633747,566592,1045110,481568,764036,973375,971009,576475,959848,485356,1012475,108499,898133,684611,387944,883213,978662,793693,683889,832651,665336,427428,984990,1040060,832367,1002797,200395,513725,740279,505246,957030,209432,441918,138907,164427,508554,449627,156905,200966,972292,792351,914370,1017886,396194,44790,817698,236888,445020,357635,952400,42341) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001014s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 410500 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000355s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 410500 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000602s ]