而今天,短视频平台彻底打破了这种壁垒。它赋予了每一个普通球迷“造梦”的能力。一个仅用手机软件剪辑的“二创”视频,可能比官方制作的宣传片更能引发共鸣。因为它承载的,是创作者最真实、最滚烫的情感。我看到一个视频,将1998年法国队夺冠、2014年德国队绝杀、2018年法国队再登巅峰的镜头快速切换,配上《We Are the Champions》的变奏版,评论区里瞬间涌入了数万条“爷青回”和“泪目”。那一刻,我意识到,这不再是简单的流量数字,而是几代人跨越时空的情感共振。
[ DB ] CONNECT:[ UseTime:0.006532s ] mysql:host=rm-3ns41jmtlb1g0zd6v.mysql.rds.aliyuncs.com;port=3306;dbname=daxiong_7000;charset=utf8mb4
[ SQL ] SHOW COLUMNS FROM `cmf_plugin_web` [ RunTime:0.030138s ]
[ SQL ] SELECT `id` FROM `cmf_plugin_web` WHERE `web_url` LIKE '%www.ynmrsj.cn%' LIMIT 1 [ RunTime:0.008865s ]
[ SQL ] SELECT `id` FROM `cmf_plugin_web` WHERE `erji` = 'www' LIMIT 1 [ RunTime:0.008998s ]
[ SQL ] SELECT `id` FROM `cmf_plugin_web` WHERE `web_url` LIKE '%ynmrsj.cn%' LIMIT 1 [ RunTime:0.015636s ]
[ SQL ] SHOW COLUMNS FROM `cmf_plugin` [ RunTime:0.017725s ]
[ SQL ] SELECT `config` FROM `cmf_plugin` WHERE `name` = 'Web' LIMIT 1 [ RunTime:0.005449s ]
[ SQL ] SHOW COLUMNS FROM `cmf_option` [ RunTime:0.019397s ]
[ SQL ] SELECT `option_value` FROM `cmf_option` WHERE `option_name` = 'cdn_settings' AND `site_id` = 820 LIMIT 1 [ RunTime:0.007177s ]
[ SQL ] SELECT * FROM `cmf_plugin_web` WHERE `id` = 820 LIMIT 1 [ RunTime:0.005005s ]
[ SQL ] SELECT `option_value` FROM `cmf_option` WHERE `option_name` = 'site_info' AND `site_id` = 820 LIMIT 1 [ RunTime:0.074393s ]
[ SQL ] SHOW COLUMNS FROM `cmf_portal_category` [ RunTime:0.030862s ]
[ SQL ] SELECT `id`,`name` FROM `cmf_portal_category` WHERE `status` = 1 [ RunTime:0.016225s ]
[ SQL ] SELECT * FROM `cmf_plugin_web` WHERE `id` = 820 LIMIT 1 [ RunTime:0.015048s ]
[ SQL ] SHOW COLUMNS FROM `cmf_nami_competitions` [ RunTime:0.010363s ]
[ SQL ] SELECT `pinyin` FROM `cmf_nami_competitions` WHERE `id` = 4540 LIMIT 1 [ RunTime:0.015139s ]
[ SQL ] SELECT `com_type` FROM `cmf_nami_competitions` WHERE `id` = 4540 LIMIT 1 [ RunTime:0.014030s ]
[ SQL ] SELECT * FROM `cmf_nami_competitions` WHERE `pinyin` = 'shijubei' LIMIT 1 [ RunTime:0.007476s ]
[ SQL ] SHOW COLUMNS FROM `cmf_portal_category_post` [ RunTime:0.003452s ]
[ SQL ] SELECT `id` FROM `cmf_portal_category_post` WHERE `post_id` = 247243 AND `category_id` = 5245 LIMIT 1 [ RunTime:0.004529s ]
[ SQL ] SHOW COLUMNS FROM `cmf_portal_post` [ RunTime:0.004399s ]
[ SQL ] SELECT `post`.* FROM `cmf_portal_post` `post` WHERE `post`.`post_type` = 1 AND `post`.`post_status` = 1 AND `post`.`category_id` = 5245 AND `post`.`id` = 247243 LIMIT 1 [ RunTime:0.004755s ]
[ SQL ] SELECT `id` FROM `cmf_portal_category_post` WHERE `post_id` = 247243 AND `category_id` = 5245 LIMIT 1 [ RunTime:0.008900s ]
[ SQL ] SHOW COLUMNS FROM `cmf_portal_news` [ RunTime:0.292085s ]
[ SQL ] SELECT `post`.* FROM `cmf_portal_news` `post` WHERE `post`.`post_type` = 1 AND `post`.`post_status` = 1 AND `post`.`category_id` = 5245 AND `post`.`id` = 247243 LIMIT 1 [ RunTime:0.009658s ]
[ SQL ] SELECT `post`.* FROM `cmf_portal_news` `post` WHERE `post`.`post_status` = 1 AND `post`.`category_id` = 5245 AND `post`.`id` < 247243 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.008594s ]
[ SQL ] SELECT `post`.* FROM `cmf_portal_news` `post` WHERE `post`.`post_status` = 1 AND `post`.`category_id` = 5245 AND `post`.`id` > 247243 ORDER BY `id` ASC LIMIT 1 [ RunTime:0.020929s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `id` = 5245 AND `status` = 1 LIMIT 1 [ RunTime:0.004621s ]
[ SQL ] SHOW COLUMNS FROM `cmf_portal_post_content` [ RunTime:0.006882s ]
[ SQL ] SELECT * FROM `cmf_portal_post_content` WHERE ( id=247243 ) LIMIT 1 [ RunTime:0.005445s ]
[ SQL ] SELECT `option_value` FROM `cmf_option` WHERE `option_name` = 'storage' AND `site_id` = 820 LIMIT 1 [ RunTime:0.006104s ]
[ SQL ] SELECT `config` FROM `cmf_plugin` WHERE `name` = 'Oss' LIMIT 1 [ RunTime:0.018636s ]
[ SQL ] SHOW COLUMNS FROM `cmf_portal_tag_post` [ RunTime:0.028853s ]
[ SQL ] SELECT `tag_id` FROM `cmf_portal_tag_post` WHERE `post_id` = 247243 [ RunTime:0.009703s ]
[ SQL ] SHOW COLUMNS FROM `cmf_portal_tag` [ RunTime:0.015919s ]
[ SQL ] SELECT `name`,`id` FROM `cmf_portal_tag` WHERE `id` IN (448818,448820) [ RunTime:0.006292s ]
[ SQL ] SHOW COLUMNS FROM `cmf_route` [ RunTime:0.012457s ]
[ SQL ] SELECT `url` FROM `cmf_route` WHERE `full_url` = 'portal/List/index?id=5245' AND `site_id` IS NULL LIMIT 1 [ RunTime:0.036656s ]
[ SQL ] SHOW COLUMNS FROM `cmf_theme_file` [ RunTime:0.236743s ]
[ SQL ] SELECT `more` FROM `cmf_theme_file` WHERE `theme` = '24_zhibo_12' AND ( `is_public` = 1 OR `file` = 'portal/article' ) [ RunTime:0.007216s ]
[ SQL ] SHOW COLUMNS FROM `cmf_nav` [ RunTime:0.020063s ]
[ SQL ] SELECT `id` FROM `cmf_nav` WHERE `is_main` = 1 LIMIT 1 [ RunTime:0.004491s ]
[ SQL ] SHOW COLUMNS FROM `cmf_nav_menu` [ RunTime:0.009697s ]
[ SQL ] SELECT * FROM `cmf_nav_menu` WHERE `site_id` = 820 AND `nav_id` = 1 AND `status` = 1 ORDER BY `list_order` ASC [ RunTime:0.004855s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 4945 LIMIT 1 [ RunTime:0.006113s ]
[ SQL ] SELECT `id` FROM `cmf_portal_category` WHERE `parent_id` = 4945 [ RunTime:0.008507s ]
[ SQL ] SELECT * FROM `cmf_portal_news` `post` WHERE ( `category_id` IN (4945,4946,4947) ) ORDER BY `create_time` DESC LIMIT 0,10 [ RunTime:0.033469s ]
[ SQL ] SELECT `id`,`name` FROM `cmf_portal_category` [ RunTime:0.023920s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 4945 LIMIT 1 [ RunTime:0.003523s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 4945 LIMIT 1 [ RunTime:0.006859s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 4945 LIMIT 1 [ RunTime:0.017040s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 4945 LIMIT 1 [ RunTime:0.007976s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 4945 LIMIT 1 [ RunTime:0.033451s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 4945 LIMIT 1 [ RunTime:0.037714s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 4945 LIMIT 1 [ RunTime:0.025878s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 4945 LIMIT 1 [ RunTime:0.011365s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 4945 LIMIT 1 [ RunTime:0.030268s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 4945 LIMIT 1 [ RunTime:0.003165s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = "" LIMIT 1 [ RunTime:0.003667s ]
[ SQL ] SELECT `id` FROM `cmf_portal_category` WHERE `parent_id` = "" [ RunTime:0.003948s ]
[ SQL ] SELECT * FROM `cmf_portal_news` `post` ORDER BY `create_time` DESC LIMIT 0,10 [ RunTime:0.009337s ]
[ SQL ] SELECT `id`,`name` FROM `cmf_portal_category` [ RunTime:0.053091s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 4729 LIMIT 1 [ RunTime:0.022605s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 4189 LIMIT 1 [ RunTime:0.016842s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 4195 LIMIT 1 [ RunTime:0.004297s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 4183 LIMIT 1 [ RunTime:0.003487s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 2857 LIMIT 1 [ RunTime:0.005502s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 2863 LIMIT 1 [ RunTime:0.009116s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 2851 LIMIT 1 [ RunTime:0.005239s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 2845 LIMIT 1 [ RunTime:0.006886s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 2839 LIMIT 1 [ RunTime:0.002896s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 2833 LIMIT 1 [ RunTime:0.015282s ]
[ SQL ] SELECT `competition_id` FROM `cmf_plugin_web` WHERE `id` = 820 LIMIT 1 [ RunTime:0.024855s ]
[ SQL ] SELECT * FROM `cmf_nami_competitions` WHERE `id` = 4540 LIMIT 1 [ RunTime:0.016552s ]
[ SQL ] SHOW COLUMNS FROM `cmf_nami_teams` [ RunTime:0.495395s ]
[ SQL ] SELECT * FROM `cmf_nami_teams` WHERE `com_type` = 0 AND `competition_id` = 7221 ORDER BY `id` DESC LIMIT 50 [ RunTime:0.002989s ]
[ SQL ] SELECT `option_value` FROM `cmf_option` WHERE `option_name` = 'site_info' AND `site_id` = 820 LIMIT 1 [ RunTime:0.010105s ]
[ SQL ] SELECT * FROM cmf_nami_competitions WHERE id IN (70, 2419, 588, 32, 122, 112, 136, 100, 33, 530, 529, 589, 623, 640) ORDER BY FIELD(id, 70, 2419, 588, 32, 122, 112, 136, 100, 33, 530, 529, 589, 623, 640) limit 20 [ RunTime:0.207842s ]