SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001107s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 110678 LIMIT 1 [ RunTime:0.000326s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 110678 [ RunTime:0.003811s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (362116,347669,467881,677414,606488,604949,969741,636601,547996,893845,196097,919319,441282,344997,483910,839886,410946,514746,819404,163043,189088,534515,922877,219304,40980,251947,765100,758428,314898,955550,901460,229442,212888,231243,492255,550892,200282,951452,556328,90897,476001,224190,357354,965717,467151,1020357,501235,128001,493460,440718,123533,429558,5235,928240,544227,790454,893365,131657,870597,532339) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000908s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 110678 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000315s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 110678 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000544s ]