SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001216s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 386301 LIMIT 1 [ RunTime:0.000346s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 386301 [ RunTime:0.001541s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1030878,283245,142063,865186,603260,599527,560098,86202,870835,350370,50930,289204,279587,198902,1032929,307995,154478,61819,1020967,156822,370923,713514,88473,356659,776134,65027,441188,394448,682828,815413,1015045,361389,863111,217935,283094,613942,200313,739956,24019,710281,236607,11018,452929,651729,133764,798028,97574,742027,974787,609530,590360,553913,82247,274557,201870,631569,839979,324009,490425,872952) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001433s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 386301 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000381s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 386301 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000644s ]