SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001115s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 200478 LIMIT 1 [ RunTime:0.000283s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 200478 [ RunTime:0.001408s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (377283,317190,619981,991394,726577,301122,400278,1020449,455960,876856,22246,92036,94662,478942,615327,447194,247769,340477,782080,757596,483916,49574,273558,861058,129252,679455,342374,115093,356172,973973,429756,592244,338074,361809,939636,814685,1024366,503623,264489,637262,260481,710287,682697,571184,123571,947458,468206,442714,907723,328913,915258,202493,707512,597947,565948,1021396,746407,161838,179101,90487) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001297s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 200478 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000431s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 200478 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000428s ]