SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001172s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 115914 LIMIT 1 [ RunTime:0.000478s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 115914 [ RunTime:0.001666s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (250011,514361,345708,171397,970748,690121,249718,604949,689127,704588,205478,292773,4059,902463,501079,191798,637945,880449,818614,691655,831811,1003770,82762,841902,797593,175030,172971,482183,44217,286741,932112,259239,566489,505685,609332,321004,673409,214678,677605,591588,563611,85841,187349,412747,85454,256198,778004,512409,62397,133770,19383,836790,630598,482379,577437,791828,760542,358353,253672,1045868) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001089s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 115914 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000560s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 115914 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000603s ]