SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001603s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 50405 LIMIT 1 [ RunTime:0.002454s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 50405 [ RunTime:0.002225s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (634180,757909,172651,667275,623704,931983,891690,335969,943969,748428,815820,801864,824508,660568,580018,749618,386826,307498,486166,298477,743573,287013,728922,758205,1048363,120160,304959,998554,61340,868970,780288,110300,693350,572949,877295,154480,1029084,256963,897360,498353,639017,153122,58265,797019,667356,205053,683264,294023,306414,510427,93213,778923,14876,654217,325148,910899,120944,219,853829,908013) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004085s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 50405 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000495s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 50405 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.006323s ]