SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001108s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1024829 LIMIT 1 [ RunTime:0.000297s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1024829 [ RunTime:0.001670s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (890511,536442,645138,994130,367455,191600,482696,881528,601516,786827,613157,721203,240161,737079,16216,145486,559198,200765,252100,135618,680116,409722,170559,397401,357398,616830,303690,1012352,953711,527360,962237,725193,166790,1011986,431300,948841,1005053,295924,375215,456300,415195,494759,760383,324840,137107,367892,666144,994488,495466,164201,787263,383664,713256,646296,642156,946139,898680,366125,231890,282556) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001049s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1024829 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000345s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1024829 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000605s ]