SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001295s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 109414 LIMIT 1 [ RunTime:0.000365s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 109414 [ RunTime:0.002222s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (583257,443316,895366,407663,379624,981487,85123,247122,972863,628621,882828,31468,256607,384465,958157,684151,630146,583734,983541,606073,457346,1033090,7261,591212,797232,1030727,919480,473638,828547,734060,18714,1019892,197118,581642,295222,885962,310906,318516,965150,476264,16297,314190,872539,150038,349050,25238,235547,667902,452417,943206,488919,942089,15811,648180,134998,928222,791816,629188,237642,704031) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001270s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 109414 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000363s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 109414 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000537s ]