而今天,短视频平台彻底打破了这种壁垒。它赋予了每一个普通球迷“造梦”的能力。一个仅用手机软件剪辑的“二创”视频,可能比官方制作的宣传片更能引发共鸣。因为它承载的,是创作者最真实、最滚烫的情感。我看到一个视频,将1998年法国队夺冠、2014年德国队绝杀、2018年法国队再登巅峰的镜头快速切换,配上《We Are the Champions》的变奏版,评论区里瞬间涌入了数万条“爷青回”和“泪目”。那一刻,我意识到,这不再是简单的流量数字,而是几代人跨越时空的情感共振。
[ DB ] CONNECT:[ UseTime:0.004790s ] mysql:host=rm-3ns41jmtlb1g0zd6v.mysql.rds.aliyuncs.com;port=3306;dbname=daxiong_7000;charset=utf8mb4
[ SQL ] SHOW COLUMNS FROM `cmf_plugin_web` [ RunTime:0.002951s ]
[ SQL ] SELECT `id` FROM `cmf_plugin_web` WHERE `web_url` LIKE '%m.guangzhen.net%' LIMIT 1 [ RunTime:0.003150s ]
[ SQL ] SELECT `id` FROM `cmf_plugin_web` WHERE `erji` = 'm' LIMIT 1 [ RunTime:0.002902s ]
[ SQL ] SELECT `id` FROM `cmf_plugin_web` WHERE `web_url` LIKE '%guangzhen.net%' LIMIT 1 [ RunTime:0.003552s ]
[ SQL ] SHOW COLUMNS FROM `cmf_plugin` [ RunTime:0.003082s ]
[ SQL ] SELECT `config` FROM `cmf_plugin` WHERE `name` = 'Web' LIMIT 1 [ RunTime:0.002463s ]
[ SQL ] SHOW COLUMNS FROM `cmf_option` [ RunTime:0.002789s ]
[ SQL ] SELECT `option_value` FROM `cmf_option` WHERE `option_name` = 'cdn_settings' AND `site_id` = 873 LIMIT 1 [ RunTime:0.002645s ]
[ SQL ] SELECT * FROM `cmf_plugin_web` WHERE `id` = 873 LIMIT 1 [ RunTime:0.002487s ]
[ SQL ] SELECT `option_value` FROM `cmf_option` WHERE `option_name` = 'site_info' AND `site_id` = 873 LIMIT 1 [ RunTime:0.002827s ]
[ SQL ] SHOW COLUMNS FROM `cmf_portal_category` [ RunTime:0.008142s ]
[ SQL ] SELECT `id`,`name` FROM `cmf_portal_category` WHERE `status` = 1 [ RunTime:0.008643s ]
[ SQL ] SELECT * FROM `cmf_plugin_web` WHERE `id` = 873 LIMIT 1 [ RunTime:0.002627s ]
[ SQL ] SHOW COLUMNS FROM `cmf_portal_category_post` [ RunTime:0.003003s ]
[ SQL ] SELECT `id` FROM `cmf_portal_category_post` WHERE `post_id` = 247243 AND `category_id` = 5245 LIMIT 1 [ RunTime:0.002535s ]
[ SQL ] SHOW COLUMNS FROM `cmf_portal_post` [ RunTime:0.002793s ]
[ 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.002733s ]
[ SQL ] SELECT `id` FROM `cmf_portal_category_post` WHERE `post_id` = 247243 AND `category_id` = 5245 LIMIT 1 [ RunTime:0.002720s ]
[ SQL ] SHOW COLUMNS FROM `cmf_portal_news` [ RunTime:0.002898s ]
[ 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.002761s ]
[ 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.002961s ]
[ 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.002915s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `id` = 5245 AND `status` = 1 LIMIT 1 [ RunTime:0.002597s ]
[ SQL ] SHOW COLUMNS FROM `cmf_portal_post_content` [ RunTime:0.002868s ]
[ SQL ] SELECT * FROM `cmf_portal_post_content` WHERE ( id=247243 ) LIMIT 1 [ RunTime:0.002574s ]
[ SQL ] SELECT `option_value` FROM `cmf_option` WHERE `option_name` = 'storage' AND `site_id` = 873 LIMIT 1 [ RunTime:0.002642s ]
[ SQL ] SELECT `config` FROM `cmf_plugin` WHERE `name` = 'Oss' LIMIT 1 [ RunTime:0.002661s ]
[ SQL ] SHOW COLUMNS FROM `cmf_portal_tag_post` [ RunTime:0.002849s ]
[ SQL ] SELECT `tag_id` FROM `cmf_portal_tag_post` WHERE `post_id` = 247243 [ RunTime:0.002740s ]
[ SQL ] SHOW COLUMNS FROM `cmf_portal_tag` [ RunTime:0.002748s ]
[ SQL ] SELECT `name`,`id` FROM `cmf_portal_tag` WHERE `id` IN (448818,448820) [ RunTime:0.002431s ]
[ SQL ] SHOW COLUMNS FROM `cmf_route` [ RunTime:0.002684s ]
[ SQL ] SELECT `url` FROM `cmf_route` WHERE `full_url` = 'portal/List/index?id=5245' AND `site_id` IS NULL LIMIT 1 [ RunTime:0.006950s ]
[ SQL ] SHOW COLUMNS FROM `cmf_theme_file` [ RunTime:0.002673s ]
[ SQL ] SELECT `more` FROM `cmf_theme_file` WHERE `theme` = '24_zhibo_12' AND ( `is_public` = 1 OR `file` = 'portal/article' ) [ RunTime:0.002816s ]
[ SQL ] SHOW COLUMNS FROM `cmf_nav` [ RunTime:0.002683s ]
[ SQL ] SELECT `id` FROM `cmf_nav` WHERE `is_main` = 1 LIMIT 1 [ RunTime:0.002343s ]
[ SQL ] SHOW COLUMNS FROM `cmf_nav_menu` [ RunTime:0.002687s ]
[ SQL ] SELECT * FROM `cmf_nav_menu` WHERE `site_id` = 873 AND `nav_id` = 1 AND `status` = 1 ORDER BY `list_order` ASC [ RunTime:0.003828s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 5263 LIMIT 1 [ RunTime:0.002595s ]
[ SQL ] SELECT `id` FROM `cmf_portal_category` WHERE `parent_id` = 5263 [ RunTime:0.003499s ]
[ SQL ] SELECT * FROM `cmf_portal_news` `post` WHERE ( `category_id` IN (5263,5264,5265) ) ORDER BY `create_time` DESC LIMIT 0,10 [ RunTime:0.003523s ]
[ SQL ] SELECT `id`,`name` FROM `cmf_portal_category` [ RunTime:0.006392s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 5263 LIMIT 1 [ RunTime:0.002737s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 5263 LIMIT 1 [ RunTime:0.002591s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 5263 LIMIT 1 [ RunTime:0.002583s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 5263 LIMIT 1 [ RunTime:0.002504s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 5263 LIMIT 1 [ RunTime:0.002527s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 5263 LIMIT 1 [ RunTime:0.002526s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 5263 LIMIT 1 [ RunTime:0.002544s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 5263 LIMIT 1 [ RunTime:0.002576s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 5263 LIMIT 1 [ RunTime:0.002988s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 5263 LIMIT 1 [ RunTime:0.002607s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = "" LIMIT 1 [ RunTime:0.002582s ]
[ SQL ] SELECT `id` FROM `cmf_portal_category` WHERE `parent_id` = "" [ RunTime:0.003699s ]
[ SQL ] SELECT * FROM `cmf_portal_news` `post` ORDER BY `create_time` DESC LIMIT 0,10 [ RunTime:0.002881s ]
[ SQL ] SELECT `id`,`name` FROM `cmf_portal_category` [ RunTime:0.006289s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 5389 LIMIT 1 [ RunTime:0.002694s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 5383 LIMIT 1 [ RunTime:0.002553s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 5377 LIMIT 1 [ RunTime:0.002660s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 5371 LIMIT 1 [ RunTime:0.002659s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 5365 LIMIT 1 [ RunTime:0.002625s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 5359 LIMIT 1 [ RunTime:0.002498s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 5353 LIMIT 1 [ RunTime:0.002573s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 5347 LIMIT 1 [ RunTime:0.002639s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 5341 LIMIT 1 [ RunTime:0.002758s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 5335 LIMIT 1 [ RunTime:0.002417s ]
[ SQL ] SELECT `competition_id` FROM `cmf_plugin_web` WHERE `id` = 873 LIMIT 1 [ RunTime:0.002580s ]
[ SQL ] SHOW COLUMNS FROM `cmf_nami_teams` [ RunTime:0.002960s ]
[ SQL ] SELECT * FROM `cmf_nami_teams` ORDER BY `id` DESC LIMIT 50 [ RunTime:0.002908s ]
[ 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.004106s ]