SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001228s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 399715 LIMIT 1 [ RunTime:0.000412s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 399715 [ RunTime:0.001917s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (806317,297819,389518,148405,917185,1001848,113719,666277,191298,946178,912148,744017,173090,1025138,13993,520531,53875,195658,1022872,678811,336704,821789,546744,157518,569951,97621,448000,619495,195133,124792,505309,861216,665179,612427,743523,240898,507885,196589,417188,795895,303368,1014030,532724,613028,318082,160950,501635,551695,195888,429934,232318,173441,237213,869795,740717,1029254,873576,902860,187155,927939) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001177s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 399715 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000402s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 399715 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000478s ]