SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001204s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 402390 LIMIT 1 [ RunTime:0.001505s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 402390 [ RunTime:0.002089s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (672104,60223,715633,236947,48182,72008,629035,921789,252270,692530,371746,859586,588440,337208,277390,882353,568130,471129,377366,109537,827887,340252,932271,58580,671892,402911,887009,899943,430690,692752,803883,339892,260500,139049,964461,1039869,120625,660271,285235,832905,910037,268241,381468,974494,433017,1021871,271206,36449,707502,238992,389639,224801,884857,583126,191865,361284,727118,267217,243934,48754) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001235s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 402390 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000481s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 402390 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000424s ]