以2018年世界杯为例,H组的日本队和塞内加尔队同积4分,最终日本队凭借“公平竞赛积分”(黄牌少)晋级。但如果把场景换成小组第三名争夺:假设A组第三名积3分,进2球丢3球;B组第三名同样积3分,进2球丢2球——净胜球相同(0),但B组进球数更多?不,这里净胜球是0 vs -1,实际上B组因净胜球优势直接晋级。但若净胜球完全相同呢?比如A组第三名进2球丢3球(净胜球-1),C组第三名进3球丢4球(净胜球-1)——此时进球数(3 vs 2)将决定谁晋级。**多一个进球,可能就是天堂与地狱的差别。**
[ SQL ] SHOW COLUMNS FROM `cmf_portal_luxiang` [ RunTime:0.003644s ]
[ SQL ] SELECT `post`.* FROM `cmf_portal_luxiang` `post` WHERE `post`.`post_status` = 1 AND `post`.`id` = 7488103 LIMIT 1 [ RunTime:0.003517s ]
[ SQL ] SELECT `id` FROM `cmf_portal_category_post` WHERE `post_id` = 7488103 AND `category_id` = 0 LIMIT 1 [ RunTime:0.003259s ]
[ SQL ] SHOW COLUMNS FROM `cmf_portal_news` [ RunTime:0.003231s ]
[ SQL ] SELECT `post`.* FROM `cmf_portal_news` `post` WHERE `post`.`post_status` = 1 AND `post`.`id` = 7488103 LIMIT 1 [ RunTime:0.002781s ]
[ SQL ] SELECT `post`.* FROM `cmf_portal_news` `post` WHERE `post`.`post_status` = 1 AND `post`.`category_id` = 938 AND `post`.`id` < 7488103 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002900s ]
[ SQL ] SELECT `post`.* FROM `cmf_portal_news` `post` WHERE `post`.`post_status` = 1 AND `post`.`category_id` = 938 AND `post`.`id` > 7488103 ORDER BY `id` ASC LIMIT 1 [ RunTime:0.004379s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `id` = 938 AND `status` = 1 LIMIT 1 [ RunTime:0.005374s ]
[ SQL ] SHOW COLUMNS FROM `cmf_portal_post_content` [ RunTime:0.005996s ]
[ SQL ] SELECT * FROM `cmf_portal_post_content` WHERE ( id=7488103 ) LIMIT 1 [ RunTime:0.005409s ]
[ SQL ] SELECT `option_value` FROM `cmf_option` WHERE `option_name` = 'storage' LIMIT 1 [ RunTime:0.002843s ]
[ SQL ] SELECT `config` FROM `cmf_plugin` WHERE `name` = 'Oss' LIMIT 1 [ RunTime:0.004108s ]
[ SQL ] SHOW COLUMNS FROM `cmf_route` [ RunTime:0.006900s ]
[ SQL ] SELECT `url` FROM `cmf_route` WHERE `full_url` = 'portal/List/index?id=938' AND `site_id` IS NULL LIMIT 1 [ RunTime:0.003614s ]
[ SQL ] SHOW COLUMNS FROM `cmf_theme_file` [ RunTime:0.008025s ]
[ SQL ] SELECT `more` FROM `cmf_theme_file` WHERE `theme` = '24_zhibo_3' AND ( `is_public` = 1 OR `file` = 'portal/article' ) [ RunTime:0.006742s ]
[ SQL ] SHOW COLUMNS FROM `cmf_nav` [ RunTime:0.003989s ]
[ SQL ] SELECT `id` FROM `cmf_nav` WHERE `is_main` = 1 LIMIT 1 [ RunTime:0.002842s ]
[ SQL ] SHOW COLUMNS FROM `cmf_nav_menu` [ RunTime:0.003684s ]
[ SQL ] SELECT * FROM `cmf_nav_menu` WHERE `site_id` = 74 AND `nav_id` = 1 AND `status` = 1 ORDER BY `list_order` ASC [ RunTime:0.003140s ]
[ 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.005279s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 469 LIMIT 1 [ RunTime:0.007520s ]
[ SQL ] SELECT `id` FROM `cmf_portal_category` WHERE `parent_id` = 469 [ RunTime:0.003745s ]
[ SQL ] SELECT * FROM `cmf_portal_news` `post` WHERE ( `category_id` IN (469,470,471) ) ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.007979s ]
[ SQL ] SELECT `id`,`name` FROM `cmf_portal_category` [ RunTime:0.003400s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 469 LIMIT 1 [ RunTime:0.005875s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 469 LIMIT 1 [ RunTime:0.004810s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 469 LIMIT 1 [ RunTime:0.002899s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 469 LIMIT 1 [ RunTime:0.004615s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 469 LIMIT 1 [ RunTime:0.003163s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 469 LIMIT 1 [ RunTime:0.005439s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 469 LIMIT 1 [ RunTime:0.002677s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 469 LIMIT 1 [ RunTime:0.002877s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 469 LIMIT 1 [ RunTime:0.002793s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 469 LIMIT 1 [ RunTime:0.002602s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 938 LIMIT 1 [ RunTime:0.004300s ]
[ SQL ] SELECT `id` FROM `cmf_portal_category` WHERE `parent_id` = 938 [ RunTime:0.003544s ]
[ SQL ] SELECT * FROM `cmf_portal_news` `post` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.003547s ]
[ SQL ] SELECT `id`,`name` FROM `cmf_portal_category` [ RunTime:0.004313s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 938 LIMIT 1 [ RunTime:0.002659s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 938 LIMIT 1 [ RunTime:0.003964s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 938 LIMIT 1 [ RunTime:0.004902s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 938 LIMIT 1 [ RunTime:0.004027s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 938 LIMIT 1 [ RunTime:0.003576s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 938 LIMIT 1 [ RunTime:0.003138s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 938 LIMIT 1 [ RunTime:0.002745s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 938 LIMIT 1 [ RunTime:0.003939s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 938 LIMIT 1 [ RunTime:0.003671s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 938 LIMIT 1 [ RunTime:0.004307s ]