SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001457s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 519823 LIMIT 1 [ RunTime:0.001363s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 519823 [ RunTime:0.002799s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (14973,198143,355709,381560,738357,633579,335071,677849,1379,75735,1001429,245267,1045114,33648,448485,718718,409659,909388,757137,436550,512035,195528,799879,563291,253157,1021112,143915,86509,831269,625174,774093,562153,758003,777813,567118,1009339,385556,1043600,669054,672649,241891,736863,586180,999091,527977,1046599,10505,195321,940861,837637,719568,587390,507819,711964,665608,312262,708972,711566,14651,54692) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001115s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 519823 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000545s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 519823 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000555s ]