SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001917s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 541422 LIMIT 1 [ RunTime:0.001487s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 541422 [ RunTime:0.003070s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (587684,1008553,662300,451346,67090,76136,513098,420325,553213,419136,1005345,612430,351231,1019630,919256,776605,309516,526314,66246,974999,490947,473210,433844,892021,212542,299737,442712,597181,214951,662549,308251,261426,72002,901168,729181,494020,600465,700839,817796,396272,90867,985175,364720,949297,96186,743695,232831,801495,664210,487701,260009,465263,247724,110356,783712,807025,741967,455855,307595,761156) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002955s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 541422 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000747s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 541422 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000615s ]