SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001178s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 546085 LIMIT 1 [ RunTime:0.000399s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 546085 [ RunTime:0.001787s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (309141,508054,214450,806632,584488,404828,53315,756124,740384,408132,815092,1041765,974938,27631,367545,385276,841896,985548,668278,544113,984517,845640,941745,349839,295690,218337,246744,557833,803389,322987,317249,280031,958756,66989,967094,657365,325778,810040,516526,465889,25551,587374,14382,942401,58957,473797,804556,143608,547588,171184,442835,896819,484455,152116,51651,119469,147154,137612,271506,610316) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000939s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 546085 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000340s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 546085 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000566s ]