SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001323s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 201802 LIMIT 1 [ RunTime:0.000395s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 201802 [ RunTime:0.001669s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (712409,285115,486742,1040618,36836,112343,928507,93402,570173,838912,763891,790104,574696,557851,778276,81408,921863,408912,848066,218693,438804,264367,493563,419178,71700,419941,260539,920930,552002,1031899,213283,680243,848831,707449,1034656,572300,546984,539683,325813,263904,677506,433634,284888,3106,292748,519532,233645,770652,271722,506129,178684,806396,610030,1021018,675423,440726,698216,945242,515002,882307) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.006541s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 201802 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000551s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 201802 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000494s ]