SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001312s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 497281 LIMIT 1 [ RunTime:0.000375s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 497281 [ RunTime:0.007104s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (129070,433297,246427,722373,913597,937873,551619,106531,789267,559074,614840,728387,668862,1000447,281253,799568,515865,1042983,214225,701825,676703,524727,987233,613684,1016056,659228,751414,500121,1048621,588634,269260,846111,170915,1036001,550037,375653,181158,629477,370305,100965,607279,514110,190186,280363,541545,251460,315081,529072,37534,776619,92775,722171,148031,808158,880427,688081,705480,140335,748112,966311) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001281s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 497281 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001225s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 497281 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000587s ]