SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002321s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 519403 LIMIT 1 [ RunTime:0.007865s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 519403 [ RunTime:0.007211s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (789194,117777,429871,808541,637697,884022,584943,168958,777702,428113,888189,201676,3801,517861,635148,994361,147700,863525,179963,41492,470781,431687,878844,70768,125630,386952,480022,171935,189470,997051,21540,633846,457655,97895,211720,947436,90673,1020320,631486,760337,470891,907949,1024521,80516,408251,306650,716995,1043834,165444,385820,795335,864414,115347,86410,705577,286390,195026,874303,259957,656461) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003665s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 519403 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.004482s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 519403 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000817s ]