SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001507s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 420013 LIMIT 1 [ RunTime:0.000419s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 420013 [ RunTime:0.002237s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (449254,430823,184442,339337,949149,37663,639162,496417,958151,130677,685670,583810,426104,1121,398676,1047693,697789,212760,260134,638495,441135,619735,424102,379627,817441,1043723,512116,704424,91218,1047677,450795,620468,93177,1005678,252776,310788,449624,661402,68041,791294,959158,276726,983273,865138,278185,434204,614405,157971,288262,95028,544363,347091,729352,402533,364018,90448,466554,908105,819477,654239) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001485s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 420013 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000474s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 420013 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000573s ]