1. **体能储备 vs 精神透支**:直通球队拥有更长的休整和备战期,体能充沛,战术演练更充分。而复活球队往往在附加赛消耗了大量体能,但他们的精神凝聚力可能达到顶峰。谁能更快适应世界杯的高强度节奏,是胜负手。
2. **体系足球 vs 结果足球**:直通球队通常有成熟的传控或压迫体系,追求过程的优雅。而复活球队更倾向于“结果导向”,他们能接受丑陋的胜利,擅长利用定位球、反击和身体对抗来打破僵局。这种“非对称战争”,往往会让技术占优的一方感到极度不适。
[ DB ] CONNECT:[ UseTime:0.031345s ] mysql:host=rm-3ns41jmtlb1g0zd6v.mysql.rds.aliyuncs.com;port=3306;dbname=daxiong_6000;charset=utf8mb4
[ SQL ] SHOW COLUMNS FROM `cmf_plugin_web` [ RunTime:0.014353s ]
[ SQL ] SELECT `id` FROM `cmf_plugin_web` WHERE `web_url` LIKE '%yinc8a.com%' LIMIT 1 [ RunTime:0.024223s ]
[ SQL ] SHOW COLUMNS FROM `cmf_plugin` [ RunTime:0.016959s ]
[ SQL ] SELECT `config` FROM `cmf_plugin` WHERE `name` = 'Web' LIMIT 1 [ RunTime:0.018898s ]
[ SQL ] SHOW COLUMNS FROM `cmf_option` [ RunTime:0.007238s ]
[ SQL ] SELECT `option_value` FROM `cmf_option` WHERE `option_name` = 'cdn_settings' AND `site_id` = 886 LIMIT 1 [ RunTime:0.015698s ]
[ SQL ] SELECT * FROM `cmf_plugin_web` WHERE `id` = 886 LIMIT 1 [ RunTime:0.008036s ]
[ SQL ] SELECT `option_value` FROM `cmf_option` WHERE `option_name` = 'site_info' AND `site_id` = 886 LIMIT 1 [ RunTime:0.004013s ]
[ SQL ] SHOW COLUMNS FROM `cmf_portal_category` [ RunTime:0.011943s ]
[ SQL ] SELECT `id`,`name` FROM `cmf_portal_category` WHERE `status` = 1 [ RunTime:0.016046s ]
[ SQL ] SELECT * FROM `cmf_plugin_web` WHERE `id` = 886 LIMIT 1 [ RunTime:0.037961s ]
[ SQL ] SHOW COLUMNS FROM `cmf_nami_competitions` [ RunTime:0.018970s ]
[ SQL ] SELECT `pinyin` FROM `cmf_nami_competitions` WHERE `id` = 2419 LIMIT 1 [ RunTime:0.004522s ]
[ SQL ] SELECT `com_type` FROM `cmf_nami_competitions` WHERE `id` = 2419 LIMIT 1 [ RunTime:0.015431s ]
[ SQL ] SELECT * FROM `cmf_nami_competitions` WHERE `pinyin` = 'nba' LIMIT 1 [ RunTime:0.007670s ]
[ SQL ] SHOW COLUMNS FROM `cmf_portal_category_post` [ RunTime:0.004119s ]
[ SQL ] SELECT `id` FROM `cmf_portal_category_post` WHERE `post_id` = 414648 AND `category_id` = 3253 LIMIT 1 [ RunTime:0.015807s ]
[ SQL ] SHOW COLUMNS FROM `cmf_portal_post` [ RunTime:0.007635s ]
[ SQL ] SELECT `post`.* FROM `cmf_portal_post` `post` WHERE `post`.`post_type` = 1 AND `post`.`post_status` = 1 AND `post`.`category_id` = 3253 AND `post`.`id` = 414648 LIMIT 1 [ RunTime:0.008759s ]
[ SQL ] SELECT `id` FROM `cmf_portal_category_post` WHERE `post_id` = 414648 AND `category_id` = 0 LIMIT 1 [ RunTime:0.005380s ]
[ SQL ] SHOW COLUMNS FROM `cmf_portal_news` [ RunTime:0.019505s ]
[ SQL ] SELECT `post`.* FROM `cmf_portal_news` `post` WHERE `post`.`post_status` = 1 AND `post`.`id` = 414648 LIMIT 1 [ RunTime:0.026373s ]
[ SQL ] SELECT `post`.* FROM `cmf_portal_news` `post` WHERE `post`.`post_status` = 1 AND `post`.`category_id` = 3253 AND `post`.`id` < 414648 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.015245s ]
[ SQL ] SELECT `post`.* FROM `cmf_portal_news` `post` WHERE `post`.`post_status` = 1 AND `post`.`category_id` = 3253 AND `post`.`id` > 414648 ORDER BY `id` ASC LIMIT 1 [ RunTime:0.025357s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `id` = 3253 AND `status` = 1 LIMIT 1 [ RunTime:0.005491s ]
[ SQL ] SHOW COLUMNS FROM `cmf_portal_post_content` [ RunTime:0.027276s ]
[ SQL ] SELECT * FROM `cmf_portal_post_content` WHERE ( id=414648 ) LIMIT 1 [ RunTime:0.025304s ]
[ SQL ] SELECT `option_value` FROM `cmf_option` WHERE `option_name` = 'storage' LIMIT 1 [ RunTime:0.013903s ]
[ SQL ] SELECT `config` FROM `cmf_plugin` WHERE `name` = 'Oss' LIMIT 1 [ RunTime:0.019040s ]
[ SQL ] SHOW COLUMNS FROM `cmf_portal_tag_post` [ RunTime:0.024152s ]
[ SQL ] SELECT `tag_id` FROM `cmf_portal_tag_post` WHERE `post_id` = 414648 [ RunTime:0.020209s ]
[ SQL ] SHOW COLUMNS FROM `cmf_portal_tag` [ RunTime:0.003928s ]
[ SQL ] SELECT `name`,`id` FROM `cmf_portal_tag` WHERE `id` = 692049 [ RunTime:0.005071s ]
[ SQL ] SHOW COLUMNS FROM `cmf_route` [ RunTime:0.016743s ]
[ SQL ] SELECT `url` FROM `cmf_route` WHERE `full_url` = 'portal/List/index?id=3253' AND `site_id` IS NULL LIMIT 1 [ RunTime:0.017223s ]
[ SQL ] SHOW COLUMNS FROM `cmf_theme_file` [ RunTime:0.015067s ]
[ SQL ] SELECT `more` FROM `cmf_theme_file` WHERE `theme` = '24_zhibo_3' AND ( `is_public` = 1 OR `file` = 'portal/article' ) [ RunTime:0.016777s ]
[ SQL ] SHOW COLUMNS FROM `cmf_nav` [ RunTime:0.008825s ]
[ SQL ] SELECT `id` FROM `cmf_nav` WHERE `is_main` = 1 LIMIT 1 [ RunTime:0.014408s ]
[ SQL ] SHOW COLUMNS FROM `cmf_nav_menu` [ RunTime:0.017121s ]
[ SQL ] SELECT * FROM `cmf_nav_menu` WHERE `site_id` = 886 AND `nav_id` = 1 AND `status` = 1 ORDER BY `list_order` ASC [ RunTime:0.006737s ]
[ 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.009767s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 3253 LIMIT 1 [ RunTime:0.006134s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 3253 LIMIT 1 [ RunTime:0.010690s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 5341 LIMIT 1 [ RunTime:0.007008s ]
[ SQL ] SELECT `id` FROM `cmf_portal_category` WHERE `parent_id` = 5341 [ RunTime:0.003581s ]
[ SQL ] SELECT * FROM `cmf_portal_news` `post` WHERE ( `category_id` IN (5341,5342,5343) ) ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.003740s ]
[ SQL ] SELECT `id`,`name` FROM `cmf_portal_category` [ RunTime:0.006739s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 5341 LIMIT 1 [ RunTime:0.016864s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 5341 LIMIT 1 [ RunTime:0.004292s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 5341 LIMIT 1 [ RunTime:0.007451s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 5341 LIMIT 1 [ RunTime:0.006692s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 5341 LIMIT 1 [ RunTime:0.005937s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 5341 LIMIT 1 [ RunTime:0.007770s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 5341 LIMIT 1 [ RunTime:0.004035s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 5341 LIMIT 1 [ RunTime:0.006625s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 5341 LIMIT 1 [ RunTime:0.004339s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 5341 LIMIT 1 [ RunTime:0.002418s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = "" LIMIT 1 [ RunTime:0.005196s ]
[ SQL ] SELECT `id` FROM `cmf_portal_category` WHERE `parent_id` = "" [ RunTime:0.011700s ]
[ SQL ] SELECT * FROM `cmf_portal_news` `post` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.004314s ]
[ SQL ] SELECT `id`,`name` FROM `cmf_portal_category` [ RunTime:0.015954s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 5463 LIMIT 1 [ RunTime:0.007647s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 5451 LIMIT 1 [ RunTime:0.004321s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 5439 LIMIT 1 [ RunTime:0.004130s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 5433 LIMIT 1 [ RunTime:0.019220s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 5427 LIMIT 1 [ RunTime:0.002682s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 5415 LIMIT 1 [ RunTime:0.002484s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 5421 LIMIT 1 [ RunTime:0.004609s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 5409 LIMIT 1 [ RunTime:0.002349s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 5385 LIMIT 1 [ RunTime:0.002903s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 5391 LIMIT 1 [ RunTime:0.002900s ]