SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001370s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 399908 LIMIT 1 [ RunTime:0.000391s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 399908 [ RunTime:0.001614s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (613632,1030454,810320,205114,424020,69135,613419,687614,137264,1031864,727875,197905,789516,345789,32854,737285,765499,173684,70599,195160,8822,596696,627209,467882,35209,765160,108102,1025618,271122,144883,383722,653852,87423,637250,364159,569011,793951,514694,968023,326100,112042,429056,937010,962100,780361,470306,405656,117801,484006,119628,877093,595822,178649,804295,139738,659631,458875,937820,175960,1012482) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001164s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 399908 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000368s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 399908 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000519s ]