SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001223s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1013423 LIMIT 1 [ RunTime:0.000372s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1013423 [ RunTime:0.001771s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (522383,684312,177455,341513,786842,98670,424608,32436,479566,950366,718350,764682,910004,953812,73061,16014,317806,618532,123498,668445,32515,942276,122424,917917,234736,687158,258135,800625,425400,45797,1023333,84656,221789,591508,808136,791067,274511,681792,496305,972375,358983,574026,1001221,896492,853158,804503,310640,1004711,281429,609396,364930,14836,711718,937217,936465,161287,945497,318759,21016,932656) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001100s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1013423 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000417s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1013423 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000501s ]