SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001378s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 420822 LIMIT 1 [ RunTime:0.000392s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 420822 [ RunTime:0.002281s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (351014,611870,884179,785037,445446,524853,781457,853897,26237,193424,997706,751352,509879,505344,338217,1038688,37471,903635,929637,578600,10659,985022,238893,692535,377600,849509,863769,246947,423493,806790,258700,603924,245436,118167,251446,580773,488305,193435,436752,870442,79593,894808,632139,806822,726787,444325,485769,80748,683352,86088,833033,54075,213970,48920,583335,741667,789136,713914,405818,727271) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.005669s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 420822 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000414s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 420822 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001984s ]