SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001156s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 801945 LIMIT 1 [ RunTime:0.000413s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 801945 [ RunTime:0.001768s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (2970,8060,814341,833882,144395,105008,357825,866140,46284,288371,33435,684562,1047695,69960,1021616,949712,485056,62092,205683,443294,133227,738350,925451,754397,743651,81507,667509,332384,565321,419290,1020395,385103,832647,532931,448613,500673,18981,1029140,503552,454627,589992,611555,885809,715767,728044,864246,482593,368852,416103,156123,137195,800461,744149,69132,992093,372632,891217,635688,509687,612191) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001214s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 801945 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000628s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 801945 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000546s ]