SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002493s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 955311 LIMIT 1 [ RunTime:0.000349s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 955311 [ RunTime:0.001693s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (504283,77908,64998,826127,914667,670316,720161,983251,433919,778009,787935,413816,401907,485217,791185,389956,7595,180372,442698,89777,1026667,541329,135566,526843,303005,677570,876907,647260,545565,142229,39124,797554,559784,135265,147368,762003,280932,492601,1008178,1027871,456765,506966,378426,991435,320132,223369,748736,29320,1040218,41456,275240,57905,897834,910013,501561,361606,334243,426700,122228,133247) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001101s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 955311 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000353s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 955311 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000548s ]