SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001260s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1004138 LIMIT 1 [ RunTime:0.000393s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1004138 [ RunTime:0.003469s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (208328,988906,641054,912053,472332,559415,981957,594349,1012700,61294,85960,743842,315659,195934,48498,940793,286680,973354,900230,407001,618444,842230,518317,628424,269297,1010504,189573,110504,64360,569313,830310,344489,938308,329300,852260,4844,887819,830188,708728,551160,131650,929037,518151,810835,695231,44801,62879,948483,26077,467639,404167,805646,186882,647118,782420,11898,116031,612231,93569,81542) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001143s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1004138 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000441s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1004138 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000553s ]