SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003611s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 683013 LIMIT 1 [ RunTime:0.002605s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 683013 [ RunTime:0.004635s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (21598,66279,864831,212281,142871,20704,779135,99328,1048529,955299,1013562,800736,842938,94506,345913,20872,488878,254406,882349,887915,231213,23023,261074,153110,271113,991369,610566,895008,390772,198929,860495,55318,554468,267786,525018,970731,189466,1034187,217550,1032210,18361,114912,752505,704453,958633,1036409,462756,674756,391336,301220,811471,424034,220381,1006785,831165,310816,454536,552440,1004544,794167) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003578s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 683013 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001666s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 683013 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001117s ]