[ DB ] CONNECT:[ UseTime:0.004484s ] mysql:host=rm-3nshzqnuo6110gvp4.mysql.rds.aliyuncs.com;port=3306;dbname=daxiong_dxs5000;charset=utf8mb4
[ SQL ] SHOW COLUMNS FROM `cmf_plugin_web` [ RunTime:0.002798s ]
[ SQL ] SELECT `id` FROM `cmf_plugin_web` WHERE `web_url` LIKE '%www.yatc.org.cn%' LIMIT 1 [ RunTime:0.003119s ]
[ SQL ] SELECT `id` FROM `cmf_plugin_web` WHERE `erji` = 'www' LIMIT 1 [ RunTime:0.002580s ]
[ SQL ] SELECT `id` FROM `cmf_plugin_web` WHERE `web_url` LIKE '%yatc.org.cn%' LIMIT 1 [ RunTime:0.002580s ]
[ SQL ] SHOW COLUMNS FROM `cmf_plugin` [ RunTime:0.002776s ]
[ SQL ] SELECT `config` FROM `cmf_plugin` WHERE `name` = 'Web' LIMIT 1 [ RunTime:0.002727s ]
[ SQL ] SHOW COLUMNS FROM `cmf_option` [ RunTime:0.002604s ]
[ SQL ] SELECT `option_value` FROM `cmf_option` WHERE `option_name` = 'cdn_settings' AND `site_id` = 1 LIMIT 1 [ RunTime:0.002544s ]
[ SQL ] SELECT * FROM `cmf_plugin_web` WHERE `id` = 1 LIMIT 1 [ RunTime:0.002498s ]
[ SQL ] SELECT `option_value` FROM `cmf_option` WHERE `option_name` = 'site_info' AND `site_id` = 1 LIMIT 1 [ RunTime:0.002984s ]
[ SQL ] SHOW COLUMNS FROM `cmf_portal_category` [ RunTime:0.002937s ]
[ SQL ] SELECT `id`,`name` FROM `cmf_portal_category` WHERE `status` = 1 [ RunTime:0.004036s ]
[ SQL ] SELECT * FROM `cmf_plugin_web` WHERE `id` = 1 LIMIT 1 [ RunTime:0.002936s ]
[ SQL ] SHOW COLUMNS FROM `cmf_nav_menu` [ RunTime:0.002886s ]
[ SQL ] SELECT `name`,`href` FROM `cmf_nav_menu` WHERE `nav_id` = 1 AND `parent_id` = 0 AND `status` = 1 AND `site_id` = 1 [ RunTime:0.002986s ]
[ SQL ] SHOW COLUMNS FROM `cmf_nami_competition_hot` [ RunTime:0.002732s ]
[ SQL ] SELECT `cid` FROM `cmf_nami_competition_hot` WHERE `site_id` = 1 [ RunTime:0.002628s ]
[ SQL ] SHOW COLUMNS FROM `cmf_theme_file` [ RunTime:0.002952s ]
[ SQL ] SELECT `more` FROM `cmf_theme_file` WHERE `theme` = '24_zhibo_5' AND ( `is_public` = 1 OR `file` = 'portal/index' ) [ RunTime:0.003017s ]
[ SQL ] SELECT `option_value` FROM `cmf_option` WHERE `option_name` = 'storage' LIMIT 1 [ RunTime:0.008399s ]
[ SQL ] SELECT `config` FROM `cmf_plugin` WHERE `name` = 'Oss' LIMIT 1 [ RunTime:0.002487s ]
[ SQL ] SHOW COLUMNS FROM `cmf_nav` [ RunTime:0.005696s ]
[ SQL ] SELECT `id` FROM `cmf_nav` WHERE `is_main` = 1 LIMIT 1 [ RunTime:0.002548s ]
[ SQL ] SELECT * FROM `cmf_nav_menu` WHERE `site_id` = 1 AND `nav_id` = 1 AND `status` = 1 ORDER BY `list_order` ASC [ RunTime:0.004890s ]
[ 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 5 [ RunTime:0.005649s ]
[ SQL ] SHOW COLUMNS FROM `cmf_nami_matches` [ RunTime:0.003479s ]
[ SQL ] SELECT * FROM `cmf_nami_matches` WHERE ( `match_time` > 1779617679 ) ORDER BY `match_time` ASC LIMIT 100 [ RunTime:0.003216s ]
[ SQL ] SHOW COLUMNS FROM `cmf_nami_competitions` [ RunTime:0.003146s ]
[ SQL ] SELECT * FROM `cmf_nami_competitions` WHERE `com_type` = 0 AND `cid` IN (168,3524,7549,362,7283,296,323,1928,197,542,687,543,187,186,203,1746,300,7515,7532,1841,388,260,211,293,301,242,7331,222,227,184,386,258,663,84,1748,298,3319,3394,164,1723,3378,1796) [ RunTime:0.004287s ]
[ SQL ] SELECT * FROM `cmf_nami_competitions` WHERE `com_type` = 1 AND `cid` IN (168,3524,7549,362,7283,296,323,1928,197,542,687,543,187,186,203,1746,300,7515,7532,1841,388,260,211,293,301,242,7331,222,227,184,386,258,663,84,1748,298,3319,3394,164,1723,3378,1796) [ RunTime:0.003737s ]
[ SQL ] SHOW COLUMNS FROM `cmf_nami_teams` [ RunTime:0.003763s ]
[ SQL ] SELECT `cid`,`short_name_zh`,`name_zh`,`logo` FROM `cmf_nami_teams` WHERE `com_type` = 0 AND `cid` IN (10081,10075,80511,80640,19424,19304,33655,86192,50847,20509,10916,33183,11953,12977,85907,23398,44001,69109,69916,44269,85919,40271,40268,51385,17098,12255,70422,53336,34402,33033,15719,26227,14346,74666,55975,10851,19802,36469,51264,13569,34374,19415,12549,56495,23280,25787,92982,41762,11802,28749,34404,12117,58938,76516,32804,37058,11886,30188,92991,92993,92996,92988,92997,92990,92989,92987,92992,92994,74630,53112,60821,23094,93120,93112,93113,93116,93121,93124,93122,93110,24243,47286,10138,50542,10767,34291,53650,26442,36251,71657,78337,45302,33517,15839,45699,14197,40950,18398,12943,13034,30419,22912,29325,20505,22911,20455,33141,26539,10223,45373,54117,69583,81296,60218,88783,88773,20529,61881,21179,10641,10153,10910,12759,11574,21012,20126,21408,26751,27397,44256,64152,26721,61733,24166,41638,81543,11659,12114,10874,12143,10875,15651,10799,10319,25287,21067,10007,10817,85467,77464,56537,74376,46036,86009,39799,41253,47263,86682,59392,90777,81776,82405,81775,92897,87901,30780,30413,50011,26741,30449,29838,30411,29733,19331,80638,93258,36538,35916,36260,44423,17614,36259,17777,89483,89954,22032,58129,48209,37243,21695,77688,47981,76744,60913,51748,37060,57391,37260,14473,20551) [ RunTime:0.004167s ]
[ SQL ] SELECT `cid`,`short_name_zh`,`name_zh`,`logo` FROM `cmf_nami_teams` WHERE `com_type` = 1 AND `cid` IN (10081,10075,80511,80640,19424,19304,33655,86192,50847,20509,10916,33183,11953,12977,85907,23398,44001,69109,69916,44269,85919,40271,40268,51385,17098,12255,70422,53336,34402,33033,15719,26227,14346,74666,55975,10851,19802,36469,51264,13569,34374,19415,12549,56495,23280,25787,92982,41762,11802,28749,34404,12117,58938,76516,32804,37058,11886,30188,92991,92993,92996,92988,92997,92990,92989,92987,92992,92994,74630,53112,60821,23094,93120,93112,93113,93116,93121,93124,93122,93110,24243,47286,10138,50542,10767,34291,53650,26442,36251,71657,78337,45302,33517,15839,45699,14197,40950,18398,12943,13034,30419,22912,29325,20505,22911,20455,33141,26539,10223,45373,54117,69583,81296,60218,88783,88773,20529,61881,21179,10641,10153,10910,12759,11574,21012,20126,21408,26751,27397,44256,64152,26721,61733,24166,41638,81543,11659,12114,10874,12143,10875,15651,10799,10319,25287,21067,10007,10817,85467,77464,56537,74376,46036,86009,39799,41253,47263,86682,59392,90777,81776,82405,81775,92897,87901,30780,30413,50011,26741,30449,29838,30411,29733,19331,80638,93258,36538,35916,36260,44423,17614,36259,17777,89483,89954,22032,58129,48209,37243,21695,77688,47981,76744,60913,51748,37060,57391,37260,14473,20551) [ RunTime:0.005401s ]
[ SQL ] SELECT * FROM `cmf_nami_matches` WHERE ( `match_time` > 1779617679 ) AND ( ( competition_id in (select cid from cmf_nami_competitions where recommend=1) ) ) ORDER BY `match_time` ASC LIMIT 100 [ RunTime:0.015822s ]
[ SQL ] SELECT * FROM `cmf_nami_competitions` WHERE `com_type` = 0 AND `cid` IN (168,542,543,186,293,184,258,84,108,201,121,82,243,316,175,109,429,120,435,457,1,465,202,130,159,544,613) [ RunTime:0.006351s ]
[ SQL ] SELECT * FROM `cmf_nami_competitions` WHERE `com_type` = 1 AND `cid` IN (168,542,543,186,293,184,258,84,108,201,121,82,243,316,175,109,429,120,435,457,1,465,202,130,159,544,613) [ RunTime:0.002982s ]
[ SQL ] SELECT `cid`,`short_name_zh`,`name_zh`,`logo` FROM `cmf_nami_teams` WHERE `com_type` = 0 AND `cid` IN (10081,10075,70422,53336,14346,74666,11802,28749,74630,53112,60821,23094,10138,50542,10767,34291,33141,26539,10223,45373,10153,10910,12759,11574,10874,12143,10875,15651,10799,10319,10007,10817,10907,18581,10597,12865,14272,14994,30960,11472,24236,12458,10236,10269,29434,11440,10120,10852,10012,10135,10010,10226,10244,10215,10018,10136,10249,10118,10181,10411,10020,10115,10024,10180,10183,10250,10176,10175,10682,10592,11343,10297,16383,10490,42290,31775,10031,14481,10292,10809,12187,10390,10035,10048,10466,10690,15735,12097,11260,10531,10743,10221,11441,10044,10252,10219,10049,10212,15323,10293,10294,11627,11076,15775,10753,10167,10420,10456,13403,13402,10421,10811,13075,10467,11848,10906,10493,10251,12150,10756,10208,10816,10112,39883,10496,10757,55196,11071,10211,15756,13194,12210,45111,20491,10858,10488,10522,10695,10696,11577,11578,10631,23373,10273,11564,10632,10523,13078,11722,14101,10491,14018,10237,15874,12217,15141,10521,11311,12663,10489,75354,27993,27727,30028,10123,10964,10122,11393,10633,10187,10913,10046,13407,10965,10126,12154,71374,87560,75181,70468,82384,60823,23697,13160,26591,12173,18137,28313,30448,27663,40399,22719,74787,40074) [ RunTime:0.005058s ]
[ SQL ] SELECT `cid`,`short_name_zh`,`name_zh`,`logo` FROM `cmf_nami_teams` WHERE `com_type` = 0 AND `cid` IN (10137,10219,10127,10115) [ RunTime:0.003200s ]
[ SQL ] SELECT `cid`,`short_name_zh`,`name_zh`,`logo` FROM `cmf_nami_teams` WHERE `com_type` = 1 AND `cid` IN (10081,10075,70422,53336,14346,74666,11802,28749,74630,53112,60821,23094,10138,50542,10767,34291,33141,26539,10223,45373,10153,10910,12759,11574,10874,12143,10875,15651,10799,10319,10007,10817,10907,18581,10597,12865,14272,14994,30960,11472,24236,12458,10236,10269,29434,11440,10120,10852,10012,10135,10010,10226,10244,10215,10018,10136,10249,10118,10181,10411,10020,10115,10024,10180,10183,10250,10176,10175,10682,10592,11343,10297,16383,10490,42290,31775,10031,14481,10292,10809,12187,10390,10035,10048,10466,10690,15735,12097,11260,10531,10743,10221,11441,10044,10252,10219,10049,10212,15323,10293,10294,11627,11076,15775,10753,10167,10420,10456,13403,13402,10421,10811,13075,10467,11848,10906,10493,10251,12150,10756,10208,10816,10112,39883,10496,10757,55196,11071,10211,15756,13194,12210,45111,20491,10858,10488,10522,10695,10696,11577,11578,10631,23373,10273,11564,10632,10523,13078,11722,14101,10491,14018,10237,15874,12217,15141,10521,11311,12663,10489,75354,27993,27727,30028,10123,10964,10122,11393,10633,10187,10913,10046,13407,10965,10126,12154,71374,87560,75181,70468,82384,60823,23697,13160,26591,12173,18137,28313,30448,27663,40399,22719,74787,40074) [ RunTime:0.006927s ]
[ SQL ] SELECT `cid`,`short_name_zh`,`name_zh`,`logo` FROM `cmf_nami_teams` WHERE `com_type` = 1 AND `cid` IN (10137,10219,10127,10115) [ RunTime:0.010187s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = "" LIMIT 1 [ RunTime:0.002830s ]
[ SQL ] SELECT `id` FROM `cmf_portal_category` WHERE `parent_id` = "" [ RunTime:0.007968s ]
[ SQL ] SHOW COLUMNS FROM `cmf_portal_news` [ RunTime:0.005297s ]
[ SQL ] SELECT * FROM `cmf_portal_news` `post` ORDER BY `create_time` DESC LIMIT 0,10 [ RunTime:0.007550s ]
[ SQL ] SELECT `id`,`name` FROM `cmf_portal_category` [ RunTime:0.009616s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 1177 LIMIT 1 [ RunTime:0.003342s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 1171 LIMIT 1 [ RunTime:0.002708s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 1165 LIMIT 1 [ RunTime:0.002465s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 1099 LIMIT 1 [ RunTime:0.002469s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 1093 LIMIT 1 [ RunTime:0.002466s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 1087 LIMIT 1 [ RunTime:0.003480s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 1081 LIMIT 1 [ RunTime:0.003402s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 1075 LIMIT 1 [ RunTime:0.003540s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 1069 LIMIT 1 [ RunTime:0.002503s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 1063 LIMIT 1 [ RunTime:0.004829s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = "" LIMIT 1 [ RunTime:0.008464s ]
[ SQL ] SELECT `id` FROM `cmf_portal_category` WHERE `parent_id` = "" [ RunTime:0.004972s ]
[ SQL ] SELECT * FROM `cmf_portal_news` `post` ORDER BY `create_time` DESC LIMIT 0,10 [ RunTime:0.003124s ]
[ SQL ] SELECT `id`,`name` FROM `cmf_portal_category` [ RunTime:0.005393s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 1177 LIMIT 1 [ RunTime:0.002499s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 1171 LIMIT 1 [ RunTime:0.002936s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 1165 LIMIT 1 [ RunTime:0.002723s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 1099 LIMIT 1 [ RunTime:0.002688s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 1093 LIMIT 1 [ RunTime:0.002585s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 1087 LIMIT 1 [ RunTime:0.002759s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 1081 LIMIT 1 [ RunTime:0.002826s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 1075 LIMIT 1 [ RunTime:0.007894s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 1069 LIMIT 1 [ RunTime:0.004662s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 1063 LIMIT 1 [ RunTime:0.002726s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 1 LIMIT 1 [ RunTime:0.002668s ]
[ SQL ] SELECT `id` FROM `cmf_portal_category` WHERE `parent_id` = 1 [ RunTime:0.002904s ]
[ SQL ] SELECT * FROM `cmf_portal_news` `post` WHERE ( `category_id` IN (1,2,3) ) ORDER BY `create_time` DESC LIMIT 0,10 [ RunTime:0.004706s ]
[ SQL ] SELECT `id`,`name` FROM `cmf_portal_category` [ RunTime:0.005164s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 1 LIMIT 1 [ RunTime:0.002499s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 1 LIMIT 1 [ RunTime:0.002411s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 1 LIMIT 1 [ RunTime:0.002867s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 1 LIMIT 1 [ RunTime:0.002385s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 1 LIMIT 1 [ RunTime:0.002493s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 1 LIMIT 1 [ RunTime:0.003007s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 3 LIMIT 1 [ RunTime:0.002466s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 3 LIMIT 1 [ RunTime:0.002852s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 1 LIMIT 1 [ RunTime:0.002641s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 1 LIMIT 1 [ RunTime:0.002540s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 1 LIMIT 1 [ RunTime:0.002860s ]
[ SQL ] SELECT `id` FROM `cmf_portal_category` WHERE `parent_id` = 1 [ RunTime:0.002796s ]
[ SQL ] SELECT * FROM `cmf_portal_news` `post` WHERE ( `category_id` IN (1,2,3) ) ORDER BY `create_time` DESC LIMIT 0,10 [ RunTime:0.003640s ]
[ SQL ] SELECT `id`,`name` FROM `cmf_portal_category` [ RunTime:0.007191s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 1 LIMIT 1 [ RunTime:0.006664s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 1 LIMIT 1 [ RunTime:0.002672s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 1 LIMIT 1 [ RunTime:0.002933s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 1 LIMIT 1 [ RunTime:0.004037s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 1 LIMIT 1 [ RunTime:0.003926s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 1 LIMIT 1 [ RunTime:0.004428s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 3 LIMIT 1 [ RunTime:0.003566s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 3 LIMIT 1 [ RunTime:0.003218s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 1 LIMIT 1 [ RunTime:0.002929s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 1 LIMIT 1 [ RunTime:0.003104s ]
[ SQL ] SHOW COLUMNS FROM `cmf_portal_tag` [ RunTime:0.006329s ]
[ SQL ] SELECT * FROM `cmf_portal_tag` WHERE `site_id` = 1 AND `status` = 1 LIMIT 20 [ RunTime:0.002810s ]
乌德勒支 
寿洞村足球队 
康斯坦西亚 
维拉诺瓦加图 
维米斯 
图拉兵工厂B队 
鲍里索夫巴特 
特拉布宗体育女足 
费内巴切女足 
阿美德女足 
铭传大学 
台中未来 
爵士 
青岛西海岸 
河内公安 
乂安蓝江 
陕西联合 
瓦斯特拉弗罗伦达 
兰维特IS 
波斯坦纳斯 
哥斯纳斯 
纳卡伊利里亚 
迪沙辛斯克 
苏维埃之翼B队 
卡尔斯塔德 
特罗姆斯达伦 
DB加雷利联 
潘迪普利多 
黑格尔曼 
丽水队 
衢州队 
绍兴队 
嘉兴队 
湖州队 
延边龙鼎 
梅州客家 
塔玛拉赛特 
武汉三镇 
辽宁铁人 
勒奥帕德 
穆兰卡 
肯尼亚警察 
图斯科 
卡云艾夫拉克 
皮斯克 
罗斯基德 
卡勒威 
威克伊勒特 
塔林弗洛拉二队 
超级星 
深圳新鹏城 
斯奥利艾B队 
喀山红宝石女足 
南昌队 
第一维也纳女足 
圣加仑 
索尔纳 
哥德堡盖斯 
贝尔加 
克尔赫提 
泰拉维 
FC阿斯特拉罕 
莫斯科斯巴达B队 
托木斯克 
扑斯 
比尔森 
赫拉德茨 
利贝雷茨 
泰港 
斯托克港 
哥利亚2018女足 
迪尤斯波勒斯女足 
迈克尔奥伦加 
纳瓦萨体育 
蒙巴萨联 
卡巴蒂青年 
吉扎克FA 
艾哈迈多夫 
塞曼茲库瓦索 
帕尔蒂克女足 
格拉斯哥流浪者女足 
哈茨女足 
南定绿钢 
银色射手 
奇蒂帕联合 
卡龙加联 
米格雷森FCII队 
雪兰莪州B队 
JKT坦桑尼亚 
辛巴体育 
海岸联 
马舒贾足球俱乐部 
姆贝亚市 
坦桑尼亚监狱 
阿赞 
萨索洛 
拉霍尔姆斯 
安吉尔霍姆斯 
维萨隆德 
派提亚 
布兰 
休达 
瓦斯特拉斯 
曼联 
狼队 
阿森纳 
纽卡斯尔联 
布伦特福德 
阿斯顿维拉 
伯恩茅斯 
切尔西 
埃弗顿 
利兹联 
克拉斯诺 
乌迪内斯 
维京 
科鲁姆 
皇家社会B队 
莱加内斯 
布尔戈斯 
科尔多瓦 
阿尔梅里亚 
卡斯迪隆 
萨拉戈萨 
桑坦德竞技 
格拉纳达 
拉科鲁尼亚 
根特 
安德莱赫特 
梅赫伦 
蒙扎 
贝尔格拉诺 
卡利亚里 
科莫 
热那亚 
尤文 
罗马 
马竞 
巴拉纳竞技 
沙佩科恩斯 
亚特兰大联 
米内罗竞技 
费城联合 
布拉干蒂诺RB 
雷霆 
蓝十字 
西雅图海湾人 
瓦勒伦加 
莫尔德 
利勒斯特罗姆 
奥勒松 
罗森博格 
诺霍斯 
摩斯 
埃格尔森德 
兰黑姆 
康斯文格 
斯托曼 
布莱尼 
松达尔 
格洛比纳 
图库姆斯 
赫根 
米亚尔比 
腓特烈斯塔 
沃尔夫斯堡 
帕尔蒂克 
巴伊亚 
尼克斯 
大连可为 
兰州陇原竞技 
温州队 
昆士兰狮队 
黄金海岸联 
本特利绿茵 
布琳狮子 
卧龙岗联 
湖北青年星 