SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001262s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 534578 LIMIT 1 [ RunTime:0.000377s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 534578 [ RunTime:0.001554s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (485948,746217,714822,151999,719837,1015665,217297,479812,95868,110814,920369,340179,531900,68351,950557,826200,153021,598116,1004320,610035,939726,786557,837347,697490,895921,412384,882008,626572,212703,98901,781540,1010355,10083,401720,481221,141502,1023903,266306,558570,265891,842007,619166,244477,1044288,205644,648226,912445,299805,263322,236612,912528,552074,241093,682648,927961,202377,603670,629348,329448,655277) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000998s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 534578 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000335s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 534578 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000598s ]