我甚至预测,会有专门的“球迷装扮MCN机构”出现——他们为球迷提供设计、材料、甚至“剧情脚本”。比如,一个美国球迷可以扮演“西部牛仔”,但手里牵着一条拴着“足球”的缰绳;一个加拿大球迷可以穿上“枫叶冰球服”,但球衣号码是“2026”,背后印着“Soccer is the new hockey”。这些看似玩笑的设定,其实都是精心设计的“传播钩子”。
[ DB ] CONNECT:[ UseTime:0.004229s ] mysql:host=rm-3ns41jmtlb1g0zd6v.mysql.rds.aliyuncs.com;port=3306;dbname=daxiong_7000;charset=utf8mb4
[ SQL ] SHOW COLUMNS FROM `cmf_plugin_web` [ RunTime:0.002655s ]
[ SQL ] SELECT `id` FROM `cmf_plugin_web` WHERE `web_url` LIKE '%www.sdhykx.cn%' LIMIT 1 [ RunTime:0.003028s ]
[ SQL ] SELECT `id` FROM `cmf_plugin_web` WHERE `erji` = 'www' LIMIT 1 [ RunTime:0.002552s ]
[ SQL ] SELECT `id` FROM `cmf_plugin_web` WHERE `web_url` LIKE '%sdhykx.cn%' LIMIT 1 [ RunTime:0.003075s ]
[ SQL ] SHOW COLUMNS FROM `cmf_plugin` [ RunTime:0.002568s ]
[ SQL ] SELECT `config` FROM `cmf_plugin` WHERE `name` = 'Web' LIMIT 1 [ RunTime:0.002547s ]
[ SQL ] SHOW COLUMNS FROM `cmf_option` [ RunTime:0.002668s ]
[ SQL ] SELECT `option_value` FROM `cmf_option` WHERE `option_name` = 'cdn_settings' AND `site_id` = 848 LIMIT 1 [ RunTime:0.002463s ]
[ SQL ] SELECT * FROM `cmf_plugin_web` WHERE `id` = 848 LIMIT 1 [ RunTime:0.002500s ]
[ SQL ] SELECT `option_value` FROM `cmf_option` WHERE `option_name` = 'site_info' AND `site_id` = 848 LIMIT 1 [ RunTime:0.002561s ]
[ SQL ] SHOW COLUMNS FROM `cmf_portal_category` [ RunTime:0.002504s ]
[ SQL ] SELECT `id`,`name` FROM `cmf_portal_category` WHERE `status` = 1 [ RunTime:0.006300s ]
[ SQL ] SELECT * FROM `cmf_plugin_web` WHERE `id` = 848 LIMIT 1 [ RunTime:0.002463s ]
[ SQL ] SHOW COLUMNS FROM `cmf_nami_competitions` [ RunTime:0.002760s ]
[ SQL ] SELECT `pinyin` FROM `cmf_nami_competitions` WHERE `id` = 1 LIMIT 1 [ RunTime:0.002510s ]
[ SQL ] SELECT `com_type` FROM `cmf_nami_competitions` WHERE `id` = 1 LIMIT 1 [ RunTime:0.002509s ]
[ SQL ] SELECT * FROM `cmf_nami_competitions` WHERE `pinyin` = 'shijiebei' LIMIT 1 [ RunTime:0.002556s ]
[ SQL ] SHOW COLUMNS FROM `cmf_portal_category_post` [ RunTime:0.002506s ]
[ SQL ] SELECT `id` FROM `cmf_portal_category_post` WHERE `post_id` = 251450 AND `category_id` = 2593 LIMIT 1 [ RunTime:0.002453s ]
[ SQL ] SHOW COLUMNS FROM `cmf_portal_post` [ RunTime:0.002632s ]
[ SQL ] SELECT `post`.* FROM `cmf_portal_post` `post` WHERE `post`.`post_type` = 1 AND `post`.`post_status` = 1 AND `post`.`category_id` = 2593 AND `post`.`id` = 251450 LIMIT 1 [ RunTime:0.002512s ]
[ SQL ] SELECT `id` FROM `cmf_portal_category_post` WHERE `post_id` = 251450 AND `category_id` = 2593 LIMIT 1 [ RunTime:0.002523s ]
[ SQL ] SHOW COLUMNS FROM `cmf_portal_news` [ RunTime:0.002974s ]
[ SQL ] SELECT `post`.* FROM `cmf_portal_news` `post` WHERE `post`.`post_type` = 1 AND `post`.`post_status` = 1 AND `post`.`category_id` = 2593 AND `post`.`id` = 251450 LIMIT 1 [ RunTime:0.002629s ]
[ SQL ] SELECT `post`.* FROM `cmf_portal_news` `post` WHERE `post`.`post_status` = 1 AND `post`.`category_id` = 2593 AND `post`.`id` < 251450 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002733s ]
[ SQL ] SELECT `post`.* FROM `cmf_portal_news` `post` WHERE `post`.`post_status` = 1 AND `post`.`category_id` = 2593 AND `post`.`id` > 251450 ORDER BY `id` ASC LIMIT 1 [ RunTime:0.002648s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `id` = 2593 AND `status` = 1 LIMIT 1 [ RunTime:0.002338s ]
[ SQL ] SHOW COLUMNS FROM `cmf_portal_post_content` [ RunTime:0.002534s ]
[ SQL ] SELECT * FROM `cmf_portal_post_content` WHERE ( id=251450 ) LIMIT 1 [ RunTime:0.002418s ]
[ SQL ] SELECT `option_value` FROM `cmf_option` WHERE `option_name` = 'storage' AND `site_id` = 848 LIMIT 1 [ RunTime:0.002546s ]
[ SQL ] SELECT `config` FROM `cmf_plugin` WHERE `name` = 'Oss' LIMIT 1 [ RunTime:0.002421s ]
[ SQL ] SHOW COLUMNS FROM `cmf_portal_tag_post` [ RunTime:0.002589s ]
[ SQL ] SELECT `tag_id` FROM `cmf_portal_tag_post` WHERE `post_id` = 251450 [ RunTime:0.002381s ]
[ SQL ] SHOW COLUMNS FROM `cmf_portal_tag` [ RunTime:0.002499s ]
[ SQL ] SELECT `name`,`id` FROM `cmf_portal_tag` WHERE `id` IN (456552,456554) [ RunTime:0.002422s ]
[ SQL ] SHOW COLUMNS FROM `cmf_route` [ RunTime:0.002554s ]
[ SQL ] SELECT `url` FROM `cmf_route` WHERE `full_url` = 'portal/List/index?id=2593' AND `site_id` IS NULL LIMIT 1 [ RunTime:0.006831s ]
[ SQL ] SHOW COLUMNS FROM `cmf_theme_file` [ RunTime:0.002684s ]
[ SQL ] SELECT `more` FROM `cmf_theme_file` WHERE `theme` = '24_zhibo_3' AND ( `is_public` = 1 OR `file` = 'portal/article' ) [ RunTime:0.002678s ]
[ SQL ] SHOW COLUMNS FROM `cmf_nav` [ RunTime:0.002666s ]
[ SQL ] SELECT `id` FROM `cmf_nav` WHERE `is_main` = 1 LIMIT 1 [ RunTime:0.002396s ]
[ SQL ] SHOW COLUMNS FROM `cmf_nav_menu` [ RunTime:0.002739s ]
[ SQL ] SELECT * FROM `cmf_nav_menu` WHERE `site_id` = 848 AND `nav_id` = 1 AND `status` = 1 ORDER BY `list_order` ASC [ RunTime:0.003654s ]
[ 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.002857s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 2593 LIMIT 1 [ RunTime:0.002431s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 2593 LIMIT 1 [ RunTime:0.002407s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 5113 LIMIT 1 [ RunTime:0.002647s ]
[ SQL ] SELECT `id` FROM `cmf_portal_category` WHERE `parent_id` = 5113 [ RunTime:0.003505s ]
[ SQL ] SELECT * FROM `cmf_portal_news` `post` WHERE ( `category_id` IN (5113,5114,5115) ) ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.002770s ]
[ SQL ] SELECT `id`,`name` FROM `cmf_portal_category` [ RunTime:0.004351s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 5113 LIMIT 1 [ RunTime:0.002604s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 5113 LIMIT 1 [ RunTime:0.002440s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 5113 LIMIT 1 [ RunTime:0.002387s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 5113 LIMIT 1 [ RunTime:0.002430s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 5113 LIMIT 1 [ RunTime:0.002342s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 5113 LIMIT 1 [ RunTime:0.002378s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 5113 LIMIT 1 [ RunTime:0.002520s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 5113 LIMIT 1 [ RunTime:0.002380s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 5113 LIMIT 1 [ RunTime:0.002618s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 5113 LIMIT 1 [ RunTime:0.002498s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = "" LIMIT 1 [ RunTime:0.002472s ]
[ SQL ] SELECT `id` FROM `cmf_portal_category` WHERE `parent_id` = "" [ RunTime:0.003591s ]
[ SQL ] SELECT * FROM `cmf_portal_news` `post` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.002568s ]
[ SQL ] SELECT `id`,`name` FROM `cmf_portal_category` [ RunTime:0.004007s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 5203 LIMIT 1 [ RunTime:0.002614s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 5389 LIMIT 1 [ RunTime:0.003058s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 5053 LIMIT 1 [ RunTime:0.002312s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 5065 LIMIT 1 [ RunTime:0.002554s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 5059 LIMIT 1 [ RunTime:0.002596s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 5047 LIMIT 1 [ RunTime:0.002448s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 5035 LIMIT 1 [ RunTime:0.002402s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 5041 LIMIT 1 [ RunTime:0.002517s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 5023 LIMIT 1 [ RunTime:0.002420s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 5029 LIMIT 1 [ RunTime:0.002323s ]