SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001386s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 540740 LIMIT 1 [ RunTime:0.000647s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 540740 [ RunTime:0.007115s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (902613,1023125,80591,36001,56786,530904,394317,97653,347703,931750,310021,628103,799183,21040,870928,769852,725034,104460,603602,1028961,702854,262477,228216,981986,217902,823398,39400,269633,465033,783553,843382,1012649,48399,901637,966991,630431,583621,677305,362397,417871,293212,199695,256808,486886,932188,834565,398652,791181,590263,36992,713409,871525,140247,776864,26523,587014,201050,755162,439014,1030066) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003040s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 540740 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000468s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 540740 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003221s ]