SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002574s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1004640 LIMIT 1 [ RunTime:0.000428s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1004640 [ RunTime:0.002736s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (448111,103351,568891,529546,579305,578613,342672,924950,337509,110882,391746,797201,990019,112161,1013158,91167,782552,206328,733922,772399,564549,332457,160215,965343,358615,328730,161557,305989,120748,610196,798398,551090,189140,629713,1033979,167881,648993,170518,329066,990161,618024,116377,272170,901280,998905,294811,209885,447039,102228,513061,400220,228297,837976,831069,26836,363081,684625,395612,10255,704310) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001162s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1004640 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000490s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1004640 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000570s ]