SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001186s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 547336 LIMIT 1 [ RunTime:0.000330s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 547336 [ RunTime:0.002120s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (124187,127998,871351,692788,504441,92421,388887,155582,827770,337994,503886,240303,592353,834274,357223,644310,633379,328588,974906,606833,201156,989861,970244,727722,392665,1004117,808013,57297,285423,949580,1002718,476690,25799,204448,80812,767120,566187,563481,157386,1003634,1043022,170847,1045527,569197,314323,357336,184477,82042,135783,500081,468701,327984,634636,102390,902353,381943,742359,683558,402876,98686) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001340s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 547336 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000373s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 547336 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000415s ]