SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001477s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 200278 LIMIT 1 [ RunTime:0.000369s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 200278 [ RunTime:0.002859s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (589932,521144,894414,414230,1032165,419415,895558,987967,321588,1047190,879337,964782,89253,462541,366593,140631,211699,1033072,121794,683227,913593,1032041,1022829,431501,124398,321523,317245,109717,669374,105902,662988,300885,205706,1020146,55178,989906,393284,514733,279369,629991,190223,1010494,708758,20148,608305,469693,416230,474056,816384,605947,250785,117666,592383,145733,18093,560220,517208,1044289,1028159,610707) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001173s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 200278 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000386s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 200278 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000740s ]