我甚至预测,会有专门的“球迷装扮MCN机构”出现——他们为球迷提供设计、材料、甚至“剧情脚本”。比如,一个美国球迷可以扮演“西部牛仔”,但手里牵着一条拴着“足球”的缰绳;一个加拿大球迷可以穿上“枫叶冰球服”,但球衣号码是“2026”,背后印着“Soccer is the new hockey”。这些看似玩笑的设定,其实都是精心设计的“传播钩子”。
[ DB ] CONNECT:[ UseTime:0.004453s ] mysql:host=rm-3ns41jmtlb1g0zd6v.mysql.rds.aliyuncs.com;port=3306;dbname=daxiong_7000;charset=utf8mb4
[ SQL ] SHOW COLUMNS FROM `cmf_plugin_web` [ RunTime:0.002780s ]
[ SQL ] SELECT `id` FROM `cmf_plugin_web` WHERE `web_url` LIKE '%www.sdhykx.cn%' LIMIT 1 [ RunTime:0.004252s ]
[ SQL ] SELECT `id` FROM `cmf_plugin_web` WHERE `erji` = 'www' LIMIT 1 [ RunTime:0.002708s ]
[ SQL ] SELECT `id` FROM `cmf_plugin_web` WHERE `web_url` LIKE '%sdhykx.cn%' LIMIT 1 [ RunTime:0.003090s ]
[ SQL ] SHOW COLUMNS FROM `cmf_plugin` [ RunTime:0.002736s ]
[ SQL ] SELECT `config` FROM `cmf_plugin` WHERE `name` = 'Web' LIMIT 1 [ RunTime:0.002522s ]
[ SQL ] SHOW COLUMNS FROM `cmf_option` [ RunTime:0.002706s ]
[ SQL ] SELECT `option_value` FROM `cmf_option` WHERE `option_name` = 'cdn_settings' AND `site_id` = 848 LIMIT 1 [ RunTime:0.002528s ]
[ SQL ] SELECT * FROM `cmf_plugin_web` WHERE `id` = 848 LIMIT 1 [ RunTime:0.002467s ]
[ SQL ] SELECT `option_value` FROM `cmf_option` WHERE `option_name` = 'site_info' AND `site_id` = 848 LIMIT 1 [ RunTime:0.002764s ]
[ SQL ] SHOW COLUMNS FROM `cmf_portal_category` [ RunTime:0.002600s ]
[ SQL ] SELECT `id`,`name` FROM `cmf_portal_category` WHERE `status` = 1 [ RunTime:0.006394s ]
[ SQL ] SELECT * FROM `cmf_plugin_web` WHERE `id` = 848 LIMIT 1 [ RunTime:0.002577s ]
[ SQL ] SHOW COLUMNS FROM `cmf_nami_competitions` [ RunTime:0.002871s ]
[ SQL ] SELECT `pinyin` FROM `cmf_nami_competitions` WHERE `id` = 1 LIMIT 1 [ RunTime:0.006090s ]
[ SQL ] SELECT `com_type` FROM `cmf_nami_competitions` WHERE `id` = 1 LIMIT 1 [ RunTime:0.003085s ]
[ SQL ] SELECT * FROM `cmf_nami_competitions` WHERE `pinyin` = 'shijiebei' LIMIT 1 [ RunTime:0.003313s ]
[ SQL ] SHOW COLUMNS FROM `cmf_portal_category_post` [ RunTime:0.002923s ]
[ SQL ] SELECT `id` FROM `cmf_portal_category_post` WHERE `post_id` = 251451 AND `category_id` = 2587 LIMIT 1 [ RunTime:0.002519s ]
[ SQL ] SHOW COLUMNS FROM `cmf_portal_post` [ RunTime:0.002604s ]
[ SQL ] SELECT `post`.* FROM `cmf_portal_post` `post` WHERE `post`.`post_type` = 1 AND `post`.`post_status` = 1 AND `post`.`category_id` = 2587 AND `post`.`id` = 251451 LIMIT 1 [ RunTime:0.008721s ]
[ SQL ] SELECT `id` FROM `cmf_portal_category_post` WHERE `post_id` = 251451 AND `category_id` = 2587 LIMIT 1 [ RunTime:0.002768s ]
[ SQL ] SHOW COLUMNS FROM `cmf_portal_news` [ RunTime:0.002834s ]
[ SQL ] SELECT `post`.* FROM `cmf_portal_news` `post` WHERE `post`.`post_type` = 1 AND `post`.`post_status` = 1 AND `post`.`category_id` = 2587 AND `post`.`id` = 251451 LIMIT 1 [ RunTime:0.008573s ]
[ SQL ] SELECT `post`.* FROM `cmf_portal_news` `post` WHERE `post`.`post_status` = 1 AND `post`.`category_id` = 2587 AND `post`.`id` < 251451 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002806s ]
[ SQL ] SELECT `post`.* FROM `cmf_portal_news` `post` WHERE `post`.`post_status` = 1 AND `post`.`category_id` = 2587 AND `post`.`id` > 251451 ORDER BY `id` ASC LIMIT 1 [ RunTime:0.002802s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `id` = 2587 AND `status` = 1 LIMIT 1 [ RunTime:0.002861s ]
[ SQL ] SHOW COLUMNS FROM `cmf_portal_post_content` [ RunTime:0.002690s ]
[ SQL ] SELECT * FROM `cmf_portal_post_content` WHERE ( id=251451 ) LIMIT 1 [ RunTime:0.003416s ]
[ SQL ] SELECT `option_value` FROM `cmf_option` WHERE `option_name` = 'storage' AND `site_id` = 848 LIMIT 1 [ RunTime:0.003797s ]
[ SQL ] SELECT `config` FROM `cmf_plugin` WHERE `name` = 'Oss' LIMIT 1 [ RunTime:0.002568s ]
[ SQL ] SHOW COLUMNS FROM `cmf_portal_tag_post` [ RunTime:0.002659s ]
[ SQL ] SELECT `tag_id` FROM `cmf_portal_tag_post` WHERE `post_id` = 251451 [ RunTime:0.002669s ]
[ SQL ] SHOW COLUMNS FROM `cmf_portal_tag` [ RunTime:0.002773s ]
[ SQL ] SELECT `name`,`id` FROM `cmf_portal_tag` WHERE `id` IN (456551,456553) [ RunTime:0.002552s ]
[ SQL ] SHOW COLUMNS FROM `cmf_route` [ RunTime:0.002608s ]
[ SQL ] SELECT `url` FROM `cmf_route` WHERE `full_url` = 'portal/List/index?id=2587' AND `site_id` IS NULL LIMIT 1 [ RunTime:0.008233s ]
[ SQL ] SHOW COLUMNS FROM `cmf_theme_file` [ RunTime:0.003205s ]
[ SQL ] SELECT `more` FROM `cmf_theme_file` WHERE `theme` = '24_zhibo_3' AND ( `is_public` = 1 OR `file` = 'portal/article' ) [ RunTime:0.002732s ]
[ SQL ] SHOW COLUMNS FROM `cmf_nav` [ RunTime:0.002755s ]
[ SQL ] SELECT `id` FROM `cmf_nav` WHERE `is_main` = 1 LIMIT 1 [ RunTime:0.002495s ]
[ SQL ] SHOW COLUMNS FROM `cmf_nav_menu` [ RunTime:0.002706s ]
[ SQL ] SELECT * FROM `cmf_nav_menu` WHERE `site_id` = 848 AND `nav_id` = 1 AND `status` = 1 ORDER BY `list_order` ASC [ RunTime:0.003871s ]
[ 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.004159s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 2587 LIMIT 1 [ RunTime:0.002792s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 5113 LIMIT 1 [ RunTime:0.004139s ]
[ SQL ] SELECT `id` FROM `cmf_portal_category` WHERE `parent_id` = 5113 [ RunTime:0.003690s ]
[ SQL ] SELECT * FROM `cmf_portal_news` `post` WHERE ( `category_id` IN (5113,5114,5115) ) ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.002930s ]
[ SQL ] SELECT `id`,`name` FROM `cmf_portal_category` [ RunTime:0.004823s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 5113 LIMIT 1 [ RunTime:0.003746s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 5113 LIMIT 1 [ RunTime:0.002575s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 5113 LIMIT 1 [ RunTime:0.002877s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 5113 LIMIT 1 [ RunTime:0.002510s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 5113 LIMIT 1 [ RunTime:0.002485s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 5113 LIMIT 1 [ RunTime:0.002405s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 5113 LIMIT 1 [ RunTime:0.002543s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 5113 LIMIT 1 [ RunTime:0.003283s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 5113 LIMIT 1 [ RunTime:0.002567s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 5113 LIMIT 1 [ RunTime:0.002432s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = "" LIMIT 1 [ RunTime:0.003742s ]
[ SQL ] SELECT `id` FROM `cmf_portal_category` WHERE `parent_id` = "" [ RunTime:0.005164s ]
[ SQL ] SELECT * FROM `cmf_portal_news` `post` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.002704s ]
[ SQL ] SELECT `id`,`name` FROM `cmf_portal_category` [ RunTime:0.004608s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 4843 LIMIT 1 [ RunTime:0.002565s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 4849 LIMIT 1 [ RunTime:0.002780s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 4837 LIMIT 1 [ RunTime:0.002500s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 3241 LIMIT 1 [ RunTime:0.002499s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 3247 LIMIT 1 [ RunTime:0.002467s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 3235 LIMIT 1 [ RunTime:0.002416s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 2821 LIMIT 1 [ RunTime:0.002708s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 2809 LIMIT 1 [ RunTime:0.002552s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 2815 LIMIT 1 [ RunTime:0.004199s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 2803 LIMIT 1 [ RunTime:0.003387s ]