SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001431s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1016560 LIMIT 1 [ RunTime:0.000346s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1016560 [ RunTime:0.001938s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (159308,246022,351852,761196,91009,44416,479921,80634,810370,214726,411611,932919,380967,755406,409191,383275,786889,875879,667835,44390,438303,958872,407809,204337,1044843,703302,630936,49625,843981,431495,111111,472954,245018,404976,631102,772448,185687,315427,406609,861567,149266,449362,24521,921121,188189,150431,877837,1031107,578473,597959,354262,401818,848333,603191,973418,470087,953569,257244,756853,828111) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001489s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1016560 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000588s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1016560 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000564s ]