SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001041s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 343557 LIMIT 1 [ RunTime:0.000326s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 343557 [ RunTime:0.002327s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (128533,430377,1039035,179500,205026,836880,474632,111618,915900,960879,185251,448266,142079,236489,854094,801691,631882,358121,815892,890356,590615,1014105,102807,538759,667793,36401,433910,690196,297722,672640,177915,35339,453004,7565,618437,938668,569979,91375,697221,191598,414089,1017313,38377,31838,68694,251405,874645,603932,685514,265248,868436,89255,228526,794744,453708,888894,155442,803792,726248,679626) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001090s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 343557 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000363s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 343557 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000535s ]