SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001374s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 111506 LIMIT 1 [ RunTime:0.000388s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 111506 [ RunTime:0.001995s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (18209,1014588,861013,498399,22040,510120,983176,548044,305841,953396,950858,520474,366466,429104,934609,563990,925174,49400,995786,403317,137114,1022014,221473,432592,1026783,853793,780244,57433,83691,831111,17184,198643,704025,967549,65755,345166,209242,401726,568844,585641,487206,87160,749786,672063,110675,397078,818011,405582,226891,610522,6405,367125,287616,924820,56033,714319,33059,603050,754381,752425) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001014s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 111506 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000550s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 111506 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000605s ]