SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001194s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 541426 LIMIT 1 [ RunTime:0.000415s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 541426 [ RunTime:0.002618s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (514703,811479,1008991,731409,478998,493548,912611,131431,191180,34052,913943,808299,64880,20852,651700,1034317,341794,64874,132428,633441,108032,198886,445465,854302,644254,264000,842588,48781,702696,506270,880837,431848,849504,189852,803603,1124,803554,298445,190824,54789,333527,957580,874129,802872,115387,1028714,696193,68796,970441,234900,958853,718615,732167,270655,638245,451553,392021,82175,678349,876356) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001143s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 541426 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000840s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 541426 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000576s ]