SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001155s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 41178 LIMIT 1 [ RunTime:0.000302s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 41178 [ RunTime:0.001456s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (562148,1008756,84770,537368,173524,680440,794462,807713,552693,1029615,547516,585874,607209,687660,647842,364305,152367,835196,313873,903035,142010,524352,726978,594968,580154,993189,969899,688836,987036,136488,205996,580857,700021,702384,636595,332380,321345,175139,582807,669070,683944,97766,14441,669033,615720,983193,861534,604876,921394,656694,329415,648713,769866,1039351,726757,75555,994923,537628,280991,1014748) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000914s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 41178 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000371s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 41178 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001346s ]