SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001677s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 517593 LIMIT 1 [ RunTime:0.001971s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 517593 [ RunTime:0.001755s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (648693,148784,440584,329997,286885,546604,630629,27150,718136,511469,578281,376471,117854,166420,919685,65086,448854,341321,66195,411718,343993,585640,367868,259366,324279,1019384,425089,465265,740861,1038944,756726,857151,303035,88840,109280,494180,520876,812518,45229,44084,198109,485965,1007015,550545,163988,292848,595686,558706,371735,801353,269224,335482,167076,890137,109384,572239,743149,820583,935871,702313) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002396s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 517593 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000910s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 517593 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002260s ]