SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001256s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 602518 LIMIT 1 [ RunTime:0.000416s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 602518 [ RunTime:0.004018s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (509107,183900,325310,559370,697089,320660,389041,684716,770702,326407,217869,760258,767184,73361,97532,330734,794772,667724,309857,59360,729408,491341,86004,752265,833781,118700,47915,95937,946540,870175,120792,246379,233250,430352,560674,741981,375562,225357,741873,879515,827418,1006144,708294,683435,895655,951233,332102,549723,1033081,434351,412473,660118,912325,1041715,557511,734881,802476,196546,558596,370406) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004867s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 602518 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000829s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 602518 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001204s ]