SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003220s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 506935 LIMIT 1 [ RunTime:0.001082s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 506935 [ RunTime:0.002628s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (355911,47513,748990,10428,1047976,240425,567293,349664,174594,865343,432288,66663,556736,893088,263497,456677,97245,371814,933463,401186,263995,86072,658854,869145,18315,436010,781960,123156,266212,936229,121559,160112,829360,167269,221897,269419,938177,389137,727302,103483,398281,632699,24087,32574,183907,983222,253055,253153,451950,886167,479726,426302,171449,847641,900703,713058,962006,1039885,641785,591837) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 506935 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000640s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 506935 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000574s ]