SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001179s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 546894 LIMIT 1 [ RunTime:0.000312s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 546894 [ RunTime:0.001738s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (513288,726429,297501,906709,879230,489254,151301,671402,237403,615340,308672,706732,64061,589948,572253,543556,185827,17372,588326,16250,864470,1006249,175566,431181,974533,905807,291889,821787,731623,388937,943537,486012,716218,265783,897669,462258,473946,916980,417130,425786,734583,508617,726267,188865,300445,402635,85112,690233,236834,446431,618297,785483,247054,722938,160442,449777,445289,411135,711284,702964) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001263s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 546894 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000429s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 546894 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000515s ]