SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001248s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 460712 LIMIT 1 [ RunTime:0.000444s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 460712 [ RunTime:0.001724s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (892126,183542,879786,95923,526311,839370,407813,448940,211103,90235,880694,535660,977520,889514,986711,75710,641414,357802,533017,226098,439210,401771,563130,225692,803064,828144,771732,364301,621981,267398,881904,890064,148976,256314,471560,663540,109685,373493,117147,22413,948094,532518,436726,731260,756933,404276,1006396,323346,559221,843825,472464,190909,509378,502189,858054,93457,686709,371552,444974,66778) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001269s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 460712 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000429s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 460712 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001395s ]