SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001228s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1018680 LIMIT 1 [ RunTime:0.000377s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1018680 [ RunTime:0.002637s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (551267,409056,744997,541127,595993,225086,744105,1004666,762157,789650,964627,139457,245460,249986,55025,909113,963178,827384,549132,497323,204139,551807,691480,1034552,693414,255385,501200,939165,803786,730911,148394,1029575,432883,31935,953675,930928,631958,949100,765281,293902,718754,94432,816906,626870,309847,538431,93409,42044,794677,853183,629025,915453,310899,738069,277221,132443,505363,464905,54206,919576) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.008118s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1018680 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001116s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1018680 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001160s ]