足球-世界-世界杯-数据中心

简体中文

English

最近无赛事

最近对阵
暂无可用数据

表现

日期	比賽	1	X	2	全场	轮

日期	比賽	1	X	2	全场	轮

基本文件流程错误 SQL 调试

/var/www/Gather/index.php ( 1.05 KB )
/var/www/Gather/TP/ThinkPHP.php ( 4.54 KB )
/var/www/Gather/TP/Library/Think/Think.class.php ( 11.97 KB )
/var/www/Gather/TP/Library/Think/Storage.class.php ( 1.34 KB )
/var/www/Gather/TP/Library/Think/Storage/Driver/File.class.php ( 3.42 KB )
/var/www/Gather/TP/Mode/common.php ( 2.75 KB )
/var/www/Gather/TP/Common/functions.php ( 49.85 KB )
/var/www/Gather/Gather/Common/Common/function.php ( 6.41 KB )
/var/www/Gather/TP/Library/Think/Hook.class.php ( 3.91 KB )
/var/www/Gather/TP/Library/Think/App.class.php ( 13.04 KB )
/var/www/Gather/TP/Library/Think/Dispatcher.class.php ( 14.51 KB )
/var/www/Gather/TP/Library/Think/Route.class.php ( 13.06 KB )
/var/www/Gather/TP/Library/Think/Controller.class.php ( 10.54 KB )
/var/www/Gather/TP/Library/Think/View.class.php ( 7.40 KB )
/var/www/Gather/TP/Library/Behavior/BuildLiteBehavior.class.php ( 3.61 KB )
/var/www/Gather/TP/Library/Behavior/ParseTemplateBehavior.class.php ( 3.80 KB )
/var/www/Gather/TP/Library/Behavior/ContentReplaceBehavior.class.php ( 1.87 KB )
/var/www/Gather/TP/Conf/convention.php ( 11.08 KB )
/var/www/Gather/Gather/Common/Conf/config.php ( 0.40 KB )
/var/www/Gather/Gather/Common/Conf/tags.php ( 0.15 KB )
/var/www/Gather/TP/Library/Think/Log.class.php ( 3.78 KB )
/var/www/Gather/TP/Conf/debug.php ( 1.47 KB )
/var/www/Gather/Gather/Home/Conf/config.php ( 0.86 KB )
/var/www/Gather/Gather/Home/Common/function.php ( 3.70 KB )
/var/www/Gather/TP/Library/Behavior/ReadHtmlCacheBehavior.class.php ( 5.51 KB )
/var/www/Gather/TP/Library/Behavior/CheckLangBehavior.class.php ( 2.89 KB )
/var/www/Gather/Gather/Home/Lang/zh.php ( 0.76 KB )
/var/www/Gather/TP/Library/Behavior/GetcodingBehavior.class.php ( 1.71 KB )
/var/www/Gather/Gather/Home/Controller/IndexController.class.php ( 24.02 KB )
/var/www/Gather/TP/Library/Think/Model.class.php ( 58.56 KB )
/var/www/Gather/TP/Library/Think/Db.class.php ( 31.69 KB )
/var/www/Gather/TP/Library/Think/Db/Driver/Mysql.class.php ( 10.47 KB )
/var/www/Gather/TP/Library/Think/Template.class.php ( 27.73 KB )
/var/www/Gather/TP/Library/Think/Template/TagLib/Cx.class.php ( 21.90 KB )
/var/www/Gather/TP/Library/Think/Template/TagLib.class.php ( 8.95 KB )
/var/www/Gather/Gather/Runtime/Cache/Home/737e9713fa8373efd366184185cd2dd6.php ( 38.89 KB )
/var/www/Gather/Gather/Home/Model/MenuModel.class.php ( 3.31 KB )
/var/www/Gather/TP/Library/Behavior/WriteHtmlCacheBehavior.class.php ( 0.95 KB )
/var/www/Gather/TP/Library/Behavior/ShowPageTraceBehavior.class.php ( 5.13 KB )

1064:You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 1 [ SQL语句 ] : SELECT t.rd_id as id,s.id as oid,s.en as en,s.zh as zh,s.en_abbr as abbr,s.iscountry as iscountry FROM ga_datacenter_team_season t LEFT JOIN ga_datacenter_team as s ON t.rd_id = s.rd_id WHERE ( season_id = )
1064:You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'and (m.home_tid= or m.away_tid=) ) GROUP BY m.id ORDER BY StartDate desc LIMIT 7' at line 1 [ SQL语句 ] : SELECT m.id,m.StartDate as StartDate,m.round,m.roundname,m.home_tid,m.away_tid,t1.id as home_id,t1.zh as home_zh,t1.en as home_en,t2.zh as away_zh,t2.en as away_en,t2.id as away_id,m.result,m.matchstatus,m.status_id,m.homeodds,m.drawodds,m.awayodds,s.zh as szh,s.en as sen FROM ga_datacenter_match m LEFT JOIN ga_datacenter_team as t1 ON t1.rd_id = m.home_tid LEFT JOIN ga_datacenter_team as t2 ON t2.rd_id = m.away_tid LEFT JOIN ga_matche_status as s ON s.rd_id = m.status_id WHERE ( m.matchstatus="result" and m.season_id = and (m.home_tid= or m.away_tid=) ) GROUP BY m.id ORDER BY StartDate desc LIMIT 7
1064:You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'and (m.home_tid= or m.away_tid=) ) ORDER BY StartDate asc LIMIT 5' at line 1 [ SQL语句 ] : SELECT m.StartDate as StartDate,m.round,m.roundname,m.home_tid,m.away_tid,t1.id as home_id,t1.zh as home_zh,t1.en as home_en,t2.zh as away_zh,t2.en as away_en,t2.id as away_id,m.result,m.matchstatus,m.status_id,m.homeodds,m.drawodds,m.awayodds FROM ga_datacenter_match m LEFT JOIN ga_datacenter_team as t1 ON t1.rd_id = m.home_tid LEFT JOIN ga_datacenter_team as t2 ON t2.rd_id = m.away_tid WHERE ( m.status_id="0" and m.season_id = and (m.home_tid= or m.away_tid=) ) ORDER BY StartDate asc LIMIT 5
1064:You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'and (m.home_tid= or m.away_tid=) ) GROUP BY m.id ORDER BY StartDate desc LIMIT 7' at line 1 [ SQL语句 ] : SELECT m.id,m.StartDate as StartDate,m.round,m.roundname,m.home_tid,m.away_tid,t1.id as home_id,t1.zh as home_zh,t1.en as home_en,t2.zh as away_zh,t2.en as away_en,t2.id as away_id,m.result,m.matchstatus,m.status_id,m.homeodds,m.drawodds,m.awayodds,s.zh as szh,s.en as sen FROM ga_datacenter_match m LEFT JOIN ga_datacenter_team as t1 ON t1.rd_id = m.home_tid LEFT JOIN ga_datacenter_team as t2 ON t2.rd_id = m.away_tid LEFT JOIN ga_matche_status as s ON s.rd_id = m.status_id WHERE ( m.matchstatus="result" and m.season_id = and (m.home_tid= or m.away_tid=) ) GROUP BY m.id ORDER BY StartDate desc LIMIT 7
1064:You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'and (m.home_tid= or m.away_tid=) ) GROUP BY m.id ORDER BY StartDate asc LIMIT 5' at line 1 [ SQL语句 ] : SELECT m.StartDate as StartDate,m.round,m.roundname,m.home_tid,m.away_tid,t1.id as home_id,t1.zh as home_zh,t1.en as home_en,t2.zh as away_zh,t2.en as away_en,t2.id as away_id,m.result,m.matchstatus,m.status_id,m.homeodds,m.drawodds,m.awayodds FROM ga_datacenter_match m LEFT JOIN ga_datacenter_team as t1 ON t1.rd_id = m.home_tid LEFT JOIN ga_datacenter_team as t2 ON t2.rd_id = m.away_tid WHERE ( m.status_id="0" and m.season_id = and (m.home_tid= or m.away_tid=) ) GROUP BY m.id ORDER BY StartDate asc LIMIT 5
1064:You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'and ((m.home_tid= and m.away_tid=) or (m.home_tid= and m.away_tid=)) ) GROUP BY ' at line 1 [ SQL语句 ] : SELECT m.StartDate as StartDate,m.round,m.roundname,m.home_tid,m.away_tid,t1.id as home_id,t1.zh as home_zh,t1.en as home_en,t2.zh as away_zh,t2.en as away_en,t2.id as away_id,m.result,m.matchstatus,m.status_id,m.homeodds,m.drawodds,m.awayodds FROM ga_datacenter_match m LEFT JOIN ga_datacenter_team as t1 ON t1.rd_id = m.home_tid LEFT JOIN ga_datacenter_team as t2 ON t2.rd_id = m.away_tid WHERE ( m.status_id="0" and m.season_id = and ((m.home_tid= and m.away_tid=) or (m.home_tid= and m.away_tid=)) ) GROUP BY m.id ORDER BY StartDate asc LIMIT 1
1064:You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') and m.matchstatus="result" and ((m.home_tid= and m.away_tid=) or (m.home_tid= ' at line 1 [ SQL语句 ] : SELECT l.id as lid,m.season_id,m.id,m.StartDate as StartDate,m.round,m.roundname,m.home_tid,m.away_tid,t1.id as home_id,t1.zh as home_zh,t1.en as home_en,t2.zh as away_zh,t2.en as away_en,t2.id as away_id,m.result,m.matchstatus,m.status_id,m.homeodds,m.drawodds,m.awayodds,s.zh as szh,s.en as sen,ll.id as sid FROM ga_datacenter_match m LEFT JOIN ga_datacenter_team as t1 ON t1.rd_id = m.home_tid LEFT JOIN ga_datacenter_team as t2 ON t2.rd_id = m.away_tid LEFT JOIN ga_matche_status as s ON s.rd_id = m.status_id LEFT JOIN ga_league as l ON l.rd_id = m.tid LEFT JOIN ga_datacenter_league_season as ll ON ll.rd_id = m.season_id and ll.rd_tid = m.tid WHERE ( (m.tid = 3948 or m.season_id = ) and m.matchstatus="result" and ((m.home_tid= and m.away_tid=) or (m.home_tid= and m.away_tid=)) and l.show_center=1 and ll.show_center=1 ) GROUP BY m.id ORDER BY StartDate desc LIMIT 7
[8] Undefined index: amateur /var/www/Gather/Gather/Runtime/Cache/Home/737e9713fa8373efd366184185cd2dd6.php 第 55 行.
[8] Undefined index: amateur /var/www/Gather/Gather/Runtime/Cache/Home/737e9713fa8373efd366184185cd2dd6.php 第 55 行.
[8] Undefined index: amateur /var/www/Gather/Gather/Runtime/Cache/Home/737e9713fa8373efd366184185cd2dd6.php 第 55 行.
[8] Undefined index: amateur /var/www/Gather/Gather/Runtime/Cache/Home/737e9713fa8373efd366184185cd2dd6.php 第 55 行.
[8] Undefined index: amateur /var/www/Gather/Gather/Runtime/Cache/Home/737e9713fa8373efd366184185cd2dd6.php 第 55 行.
[8] Undefined index: amateur /var/www/Gather/Gather/Runtime/Cache/Home/737e9713fa8373efd366184185cd2dd6.php 第 55 行.
[8] Undefined index: amateur /var/www/Gather/Gather/Runtime/Cache/Home/737e9713fa8373efd366184185cd2dd6.php 第 55 行.
[8] Undefined index: amateur /var/www/Gather/Gather/Runtime/Cache/Home/737e9713fa8373efd366184185cd2dd6.php 第 55 行.
[8] Undefined index: amateur /var/www/Gather/Gather/Runtime/Cache/Home/737e9713fa8373efd366184185cd2dd6.php 第 55 行.
[8] Undefined index: amateur /var/www/Gather/Gather/Runtime/Cache/Home/737e9713fa8373efd366184185cd2dd6.php 第 55 行.
[8] Undefined index: amateur /var/www/Gather/Gather/Runtime/Cache/Home/737e9713fa8373efd366184185cd2dd6.php 第 55 行.
[8] Undefined index: amateur /var/www/Gather/Gather/Runtime/Cache/Home/737e9713fa8373efd366184185cd2dd6.php 第 55 行.
[8] Undefined index: amateur /var/www/Gather/Gather/Runtime/Cache/Home/737e9713fa8373efd366184185cd2dd6.php 第 55 行.
[8] Undefined index: amateur /var/www/Gather/Gather/Runtime/Cache/Home/737e9713fa8373efd366184185cd2dd6.php 第 55 行.
[8] Undefined index: amateur /var/www/Gather/Gather/Runtime/Cache/Home/737e9713fa8373efd366184185cd2dd6.php 第 55 行.
[8] Undefined index: amateur /var/www/Gather/Gather/Runtime/Cache/Home/737e9713fa8373efd366184185cd2dd6.php 第 55 行.
[8] Undefined index: amateur /var/www/Gather/Gather/Runtime/Cache/Home/737e9713fa8373efd366184185cd2dd6.php 第 55 行.
[8] Undefined index: amateur /var/www/Gather/Gather/Runtime/Cache/Home/737e9713fa8373efd366184185cd2dd6.php 第 55 行.
[8] Undefined index: amateur /var/www/Gather/Gather/Runtime/Cache/Home/737e9713fa8373efd366184185cd2dd6.php 第 55 行.
[8] Undefined index: amateur /var/www/Gather/Gather/Runtime/Cache/Home/737e9713fa8373efd366184185cd2dd6.php 第 55 行.
[8] Undefined index: amateur /var/www/Gather/Gather/Runtime/Cache/Home/737e9713fa8373efd366184185cd2dd6.php 第 55 行.
[8] Undefined index: amateur /var/www/Gather/Gather/Runtime/Cache/Home/737e9713fa8373efd366184185cd2dd6.php 第 55 行.
[8] Undefined index: amateur /var/www/Gather/Gather/Runtime/Cache/Home/737e9713fa8373efd366184185cd2dd6.php 第 55 行.
[8] Undefined index: amateur /var/www/Gather/Gather/Runtime/Cache/Home/737e9713fa8373efd366184185cd2dd6.php 第 55 行.
[8] Undefined index: amateur /var/www/Gather/Gather/Runtime/Cache/Home/737e9713fa8373efd366184185cd2dd6.php 第 55 行.
[8] Undefined index: amateur /var/www/Gather/Gather/Runtime/Cache/Home/737e9713fa8373efd366184185cd2dd6.php 第 55 行.
[8] Undefined index: amateur /var/www/Gather/Gather/Runtime/Cache/Home/737e9713fa8373efd366184185cd2dd6.php 第 55 行.
[8] Undefined index: amateur /var/www/Gather/Gather/Runtime/Cache/Home/737e9713fa8373efd366184185cd2dd6.php 第 55 行.
[8] Undefined index: amateur /var/www/Gather/Gather/Runtime/Cache/Home/737e9713fa8373efd366184185cd2dd6.php 第 55 行.
[8] Undefined index: amateur /var/www/Gather/Gather/Runtime/Cache/Home/737e9713fa8373efd366184185cd2dd6.php 第 55 行.
[8] Undefined index: amateur /var/www/Gather/Gather/Runtime/Cache/Home/737e9713fa8373efd366184185cd2dd6.php 第 55 行.
[8] Undefined index: amateur /var/www/Gather/Gather/Runtime/Cache/Home/737e9713fa8373efd366184185cd2dd6.php 第 55 行.
[8] Undefined index: amateur /var/www/Gather/Gather/Runtime/Cache/Home/737e9713fa8373efd366184185cd2dd6.php 第 55 行.
[8] Undefined index: amateur /var/www/Gather/Gather/Runtime/Cache/Home/737e9713fa8373efd366184185cd2dd6.php 第 55 行.
[8] Undefined index: amateur /var/www/Gather/Gather/Runtime/Cache/Home/737e9713fa8373efd366184185cd2dd6.php 第 55 行.
[8] Undefined index: amateur /var/www/Gather/Gather/Runtime/Cache/Home/737e9713fa8373efd366184185cd2dd6.php 第 55 行.
[8] Undefined index: amateur /var/www/Gather/Gather/Runtime/Cache/Home/737e9713fa8373efd366184185cd2dd6.php 第 55 行.
[8] Undefined index: amateur /var/www/Gather/Gather/Runtime/Cache/Home/737e9713fa8373efd366184185cd2dd6.php 第 55 行.
[8] Undefined index: amateur /var/www/Gather/Gather/Runtime/Cache/Home/737e9713fa8373efd366184185cd2dd6.php 第 55 行.
[8] Undefined index: amateur /var/www/Gather/Gather/Runtime/Cache/Home/737e9713fa8373efd366184185cd2dd6.php 第 55 行.
[8] Undefined index: amateur /var/www/Gather/Gather/Runtime/Cache/Home/737e9713fa8373efd366184185cd2dd6.php 第 55 行.
[8] Undefined index: amateur /var/www/Gather/Gather/Runtime/Cache/Home/737e9713fa8373efd366184185cd2dd6.php 第 55 行.
[8] Undefined index: amateur /var/www/Gather/Gather/Runtime/Cache/Home/737e9713fa8373efd366184185cd2dd6.php 第 55 行.
[8] Undefined index: amateur /var/www/Gather/Gather/Runtime/Cache/Home/737e9713fa8373efd366184185cd2dd6.php 第 55 行.
[8] Undefined index: amateur /var/www/Gather/Gather/Runtime/Cache/Home/737e9713fa8373efd366184185cd2dd6.php 第 55 行.
[8] Undefined index: amateur /var/www/Gather/Gather/Runtime/Cache/Home/737e9713fa8373efd366184185cd2dd6.php 第 55 行.
[8] Undefined index: amateur /var/www/Gather/Gather/Runtime/Cache/Home/737e9713fa8373efd366184185cd2dd6.php 第 55 行.
[8] Undefined index: amateur /var/www/Gather/Gather/Runtime/Cache/Home/737e9713fa8373efd366184185cd2dd6.php 第 55 行.
[8] Undefined index: amateur /var/www/Gather/Gather/Runtime/Cache/Home/737e9713fa8373efd366184185cd2dd6.php 第 55 行.
[8] Undefined index: amateur /var/www/Gather/Gather/Runtime/Cache/Home/737e9713fa8373efd366184185cd2dd6.php 第 55 行.
[8] Undefined index: amateur /var/www/Gather/Gather/Runtime/Cache/Home/737e9713fa8373efd366184185cd2dd6.php 第 55 行.
[8] Undefined index: amateur /var/www/Gather/Gather/Runtime/Cache/Home/737e9713fa8373efd366184185cd2dd6.php 第 55 行.
[8] Undefined index: amateur /var/www/Gather/Gather/Runtime/Cache/Home/737e9713fa8373efd366184185cd2dd6.php 第 55 行.
[2] Invalid argument supplied for foreach() /var/www/Gather/Gather/Runtime/Cache/Home/737e9713fa8373efd366184185cd2dd6.php 第 236 行.
[2] Invalid argument supplied for foreach() /var/www/Gather/Gather/Runtime/Cache/Home/737e9713fa8373efd366184185cd2dd6.php 第 265 行.
[2] Invalid argument supplied for foreach() /var/www/Gather/Gather/Runtime/Cache/Home/737e9713fa8373efd366184185cd2dd6.php 第 381 行.
[2] Division by zero /var/www/Gather/Gather/Runtime/Cache/Home/737e9713fa8373efd366184185cd2dd6.php 第 385 行.
[2] Invalid argument supplied for foreach() /var/www/Gather/Gather/Runtime/Cache/Home/737e9713fa8373efd366184185cd2dd6.php 第 420 行.
[2] Division by zero /var/www/Gather/Gather/Runtime/Cache/Home/737e9713fa8373efd366184185cd2dd6.php 第 424 行.
[2] Invalid argument supplied for foreach() /var/www/Gather/Gather/Runtime/Cache/Home/737e9713fa8373efd366184185cd2dd6.php 第 493 行.
[2] Invalid argument supplied for foreach() /var/www/Gather/Gather/Runtime/Cache/Home/737e9713fa8373efd366184185cd2dd6.php 第 518 行.
[2] Invalid argument supplied for foreach() /var/www/Gather/Gather/Runtime/Cache/Home/737e9713fa8373efd366184185cd2dd6.php 第 598 行.
[2] Invalid argument supplied for foreach() /var/www/Gather/Gather/Runtime/Cache/Home/737e9713fa8373efd366184185cd2dd6.php 第 625 行.

SHOW COLUMNS FROM `ga_league` [ RunTime:0.001099s ]
SELECT * FROM `ga_league` WHERE `id` = 1488 LIMIT 1 [ RunTime:0.000255s ]
SHOW COLUMNS FROM `ga_datacenter_league_season` [ RunTime:0.022747s ]
SELECT * FROM `ga_datacenter_league_season` WHERE ( rd_tid = 3948 and rd_id =59630 ) LIMIT 1 [ RunTime:0.000187s ]
SHOW COLUMNS FROM `ga_datacenter_team_season` [ RunTime:0.007812s ]
SELECT t.rd_id as id,s.id as oid,s.en as en,s.zh as zh,s.en_abbr as abbr,s.iscountry as iscountry FROM ga_datacenter_team_season t LEFT JOIN ga_datacenter_team as s ON t.rd_id = s.rd_id WHERE ( season_id = ) [ RunTime:0.000209s ]
SHOW COLUMNS FROM `ga_datacenter_match` [ RunTime:0.008029s ]
SELECT m.id,m.StartDate as StartDate,m.round,m.roundname,m.home_tid,m.away_tid,t1.id as home_id,t1.zh as home_zh,t1.en as home_en,t2.zh as away_zh,t2.en as away_en,t2.id as away_id,m.result,m.matchstatus,m.status_id,m.homeodds,m.drawodds,m.awayodds,s.zh as szh,s.en as sen FROM ga_datacenter_match m LEFT JOIN ga_datacenter_team as t1 ON t1.rd_id = m.home_tid LEFT JOIN ga_datacenter_team as t2 ON t2.rd_id = m.away_tid LEFT JOIN ga_matche_status as s ON s.rd_id = m.status_id WHERE ( m.matchstatus="result" and m.season_id = and (m.home_tid= or m.away_tid=) ) GROUP BY m.id ORDER BY StartDate desc LIMIT 7 [ RunTime:0.000208s ]
SELECT m.StartDate as StartDate,m.round,m.roundname,m.home_tid,m.away_tid,t1.id as home_id,t1.zh as home_zh,t1.en as home_en,t2.zh as away_zh,t2.en as away_en,t2.id as away_id,m.result,m.matchstatus,m.status_id,m.homeodds,m.drawodds,m.awayodds FROM ga_datacenter_match m LEFT JOIN ga_datacenter_team as t1 ON t1.rd_id = m.home_tid LEFT JOIN ga_datacenter_team as t2 ON t2.rd_id = m.away_tid WHERE ( m.status_id="0" and m.season_id = and (m.home_tid= or m.away_tid=) ) ORDER BY StartDate asc LIMIT 5 [ RunTime:0.000194s ]
SELECT m.id,m.StartDate as StartDate,m.round,m.roundname,m.home_tid,m.away_tid,t1.id as home_id,t1.zh as home_zh,t1.en as home_en,t2.zh as away_zh,t2.en as away_en,t2.id as away_id,m.result,m.matchstatus,m.status_id,m.homeodds,m.drawodds,m.awayodds,s.zh as szh,s.en as sen FROM ga_datacenter_match m LEFT JOIN ga_datacenter_team as t1 ON t1.rd_id = m.home_tid LEFT JOIN ga_datacenter_team as t2 ON t2.rd_id = m.away_tid LEFT JOIN ga_matche_status as s ON s.rd_id = m.status_id WHERE ( m.matchstatus="result" and m.season_id = and (m.home_tid= or m.away_tid=) ) GROUP BY m.id ORDER BY StartDate desc LIMIT 7 [ RunTime:0.000192s ]
SELECT m.StartDate as StartDate,m.round,m.roundname,m.home_tid,m.away_tid,t1.id as home_id,t1.zh as home_zh,t1.en as home_en,t2.zh as away_zh,t2.en as away_en,t2.id as away_id,m.result,m.matchstatus,m.status_id,m.homeodds,m.drawodds,m.awayodds FROM ga_datacenter_match m LEFT JOIN ga_datacenter_team as t1 ON t1.rd_id = m.home_tid LEFT JOIN ga_datacenter_team as t2 ON t2.rd_id = m.away_tid WHERE ( m.status_id="0" and m.season_id = and (m.home_tid= or m.away_tid=) ) GROUP BY m.id ORDER BY StartDate asc LIMIT 5 [ RunTime:0.000208s ]
SELECT m.StartDate as StartDate,m.round,m.roundname,m.home_tid,m.away_tid,t1.id as home_id,t1.zh as home_zh,t1.en as home_en,t2.zh as away_zh,t2.en as away_en,t2.id as away_id,m.result,m.matchstatus,m.status_id,m.homeodds,m.drawodds,m.awayodds FROM ga_datacenter_match m LEFT JOIN ga_datacenter_team as t1 ON t1.rd_id = m.home_tid LEFT JOIN ga_datacenter_team as t2 ON t2.rd_id = m.away_tid WHERE ( m.status_id="0" and m.season_id = and ((m.home_tid= and m.away_tid=) or (m.home_tid= and m.away_tid=)) ) GROUP BY m.id ORDER BY StartDate asc LIMIT 1 [ RunTime:0.000208s ]
SELECT l.id as lid,m.season_id,m.id,m.StartDate as StartDate,m.round,m.roundname,m.home_tid,m.away_tid,t1.id as home_id,t1.zh as home_zh,t1.en as home_en,t2.zh as away_zh,t2.en as away_en,t2.id as away_id,m.result,m.matchstatus,m.status_id,m.homeodds,m.drawodds,m.awayodds,s.zh as szh,s.en as sen,ll.id as sid FROM ga_datacenter_match m LEFT JOIN ga_datacenter_team as t1 ON t1.rd_id = m.home_tid LEFT JOIN ga_datacenter_team as t2 ON t2.rd_id = m.away_tid LEFT JOIN ga_matche_status as s ON s.rd_id = m.status_id LEFT JOIN ga_league as l ON l.rd_id = m.tid LEFT JOIN ga_datacenter_league_season as ll ON ll.rd_id = m.season_id and ll.rd_tid = m.tid WHERE ( (m.tid = 3948 or m.season_id = ) and m.matchstatus="result" and ((m.home_tid= and m.away_tid=) or (m.home_tid= and m.away_tid=)) and l.show_center=1 and ll.show_center=1 ) GROUP BY m.id ORDER BY StartDate desc LIMIT 7 [ RunTime:0.000213s ]
SHOW COLUMNS FROM `ga_league` [ RunTime:0.034535s ]
SHOW COLUMNS FROM `ga_sports` [ RunTime:0.007601s ]
SHOW COLUMNS FROM `ga_area` [ RunTime:0.008114s ]
SELECT `rd_id`,`id`,`en`,`zh`,`table_name`,`pr` FROM `ga_sports` [ RunTime:0.000332s ]
SELECT `id`,`en`,`zh`,`pr` FROM `ga_area` [ RunTime:0.000251s ]
SELECT l.zh as zh,l.en as en,r.zh as rzh,r.en as ren,g.zh as gzh,g.en as gen,g.n2 as glogo,g.area_id as area_id,g.pr as gpr,g.id as gid,g.rd_id as grd_id,r.id as rid,r.rd_id as rrd_id,l.sid as sid,l.currentseason as season,l.id as id,s.name as sname FROM ga_league l LEFT JOIN ga_league_real as r ON r.rd_id = l.rc_id LEFT JOIN ga_location as g ON g.rd_id = r.cid LEFT JOIN ga_datacenter_league_season as s ON s.rd_id = l.currentseason WHERE ( l.show_center = 1 and top = 1 ) ORDER BY g.pr asc,l.rd_id asc [ RunTime:0.086438s ]
SELECT `rd_id`,`id`,`en`,`zh`,`table_name`,`pr` FROM `ga_sports` [ RunTime:0.000308s ]
SELECT `id`,`en`,`zh`,`pr` FROM `ga_area` [ RunTime:0.000270s ]

0.2537s