SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002472s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 338014 LIMIT 1 [ RunTime:0.000362s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 338014 [ RunTime:0.004131s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (72167,380719,962804,433133,228586,185657,708956,728931,908411,175275,438205,153135,180088,842230,120439,904298,146600,709453,85667,813649,871626,727889,875073,734198,322333,498664,1001737,836857,330385,845134,239513,366038,391856,859733,742401,60687,827072,558517,520786,270313,490884,554804,940124,931990,688152,265414,776330,544327,1003046,555483,462884,1045131,764134,199031,984356,517585,733388,296568,9192,145466) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001318s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 338014 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000804s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 338014 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001456s ]