SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001165s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 405031 LIMIT 1 [ RunTime:0.000357s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 405031 [ RunTime:0.001710s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (810155,619966,260848,699133,209035,637041,1011858,573008,688865,997892,980636,70840,490276,772732,248745,591174,566247,47083,657518,73560,334654,848031,41313,279544,303210,55393,943141,643156,44971,610328,671333,541144,316853,30302,819665,836314,328885,220110,658797,904589,822970,673418,79032,45152,187915,296761,729594,107952,443999,1019003,382439,6957,423090,738782,7042,386950,695927,383295,615435,715019) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001071s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 405031 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000324s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 405031 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000623s ]