SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001196s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 280929 LIMIT 1 [ RunTime:0.000367s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 280929 [ RunTime:0.005392s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1040257,216524,290748,294200,584052,154458,829319,536676,580735,731053,603679,214730,222164,551313,642530,29666,589122,740666,1045267,426741,565842,408382,170975,831175,408769,810801,237524,427213,160285,944648,793899,401939,421495,289390,992883,231897,288401,451818,389755,152557,1038727,254544,831016,997223,552821,747484,329260,484222,739536,524126,288823,615886,12784,345784,965249,154683,395512,443139,930373,407196) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004753s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 280929 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000488s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 280929 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000559s ]