SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001137s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 341112 LIMIT 1 [ RunTime:0.000301s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 341112 [ RunTime:0.001706s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (57756,819789,416635,113772,30586,912727,218134,964907,969185,327150,710650,297193,866886,207607,670415,444471,284081,982222,100261,587726,480382,661140,502263,351986,715568,384220,706807,552604,323453,505357,156139,940437,1032686,691661,418320,285453,570411,240411,1004505,746207,5975,535583,269103,642355,938354,150154,649380,879939,465627,263040,479954,148092,707232,1013463,753419,50185,943907,611291,52750,207989) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001052s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 341112 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000397s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 341112 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000583s ]