篮球-世界-数据中心

简体中文

English

	推荐赛事

	推荐联赛

	球队

基本文件流程错误 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/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/82b70b0e5243bee92f02f83732dd02ff.php ( 14.11 KB )
/var/www/Gather/Gather/Home/Model/MenuModel.class.php ( 3.31 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/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 '_id = 7 or r.cid is null ) ) GROUP BY m.id ORDER BY m.StartDate asc LIMIT 20' at line 1 [ SQL语句 ] : SELECT t1.zh as home_zh,t1.en as home_en,t2.zh as away_zh,t2.en as away_en,t1.id as home_id,t2.id as away_id,m.home_tid,m.away_tid,l.id as lid,r.rd_id as rid,g.id as gid,g.area_id,m.sid as sportID 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_league as l ON m.tid = l.rd_id 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 WHERE ( m.position = 1 and m.status_id = 0 and m.sid = 2 and (g.area _id = 7 or r.cid is null ) ) GROUP BY m.id ORDER BY m.StartDate asc LIMIT 20
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 '_id = 7 or r.cid is null ) ) GROUP BY l.id ORDER BY m.StartDate asc LIMIT 20' at line 1 [ SQL语句 ] : SELECT m.home_tid,m.away_tid,l.id as lid,r.rd_id as rid,g.id as gid,g.area_id,m.sid as sportID,l.zh,l.en,g.n2 FROM ga_datacenter_match m LEFT JOIN ga_league as l ON m.tid = l.rd_id 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 WHERE ( l.position = 1 and m.status_id = 0 and m.sid = 2 and (g.area _id = 7 or r.cid is null ) ) GROUP BY l.id ORDER BY m.StartDate asc LIMIT 20
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 '_id = 7 or r.cid is null ) ) GROUP BY m.id ORDER BY m.StartDate asc LIMIT 20' at line 1 [ SQL语句 ] : SELECT t1.zh as home_zh,t1.en as home_en,t2.zh as away_zh,t2.en as away_en,t1.id as home_id,t2.id as away_id,m.home_tid,m.away_tid,l.id as lid,r.rd_id as rid,g.id as gid,g.area_id,m.sid as sportID,t1.position t1p,t2.position t2p,g.n2 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_league as l ON m.tid = l.rd_id 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 WHERE ( (t1.position <> 0 or t2.position <> 0) and m.status_id = 0 and m.sid = 2 and (g.area _id = 7 or r.cid is null ) ) GROUP BY m.id ORDER BY m.StartDate asc LIMIT 20
[8] Undefined index: amateur /var/www/Gather/Gather/Runtime/Cache/Home/82b70b0e5243bee92f02f83732dd02ff.php 第 57 行.
[8] Undefined index: amateur /var/www/Gather/Gather/Runtime/Cache/Home/82b70b0e5243bee92f02f83732dd02ff.php 第 57 行.
[8] Undefined index: amateur /var/www/Gather/Gather/Runtime/Cache/Home/82b70b0e5243bee92f02f83732dd02ff.php 第 57 行.
[8] Undefined index: amateur /var/www/Gather/Gather/Runtime/Cache/Home/82b70b0e5243bee92f02f83732dd02ff.php 第 57 行.
[8] Undefined index: amateur /var/www/Gather/Gather/Runtime/Cache/Home/82b70b0e5243bee92f02f83732dd02ff.php 第 57 行.
[8] Undefined index: amateur /var/www/Gather/Gather/Runtime/Cache/Home/82b70b0e5243bee92f02f83732dd02ff.php 第 57 行.
[8] Undefined index: amateur /var/www/Gather/Gather/Runtime/Cache/Home/82b70b0e5243bee92f02f83732dd02ff.php 第 57 行.
[8] Undefined index: amateur /var/www/Gather/Gather/Runtime/Cache/Home/82b70b0e5243bee92f02f83732dd02ff.php 第 57 行.
[8] Undefined index: amateur /var/www/Gather/Gather/Runtime/Cache/Home/82b70b0e5243bee92f02f83732dd02ff.php 第 57 行.
[8] Undefined index: amateur /var/www/Gather/Gather/Runtime/Cache/Home/82b70b0e5243bee92f02f83732dd02ff.php 第 57 行.
[8] Undefined index: amateur /var/www/Gather/Gather/Runtime/Cache/Home/82b70b0e5243bee92f02f83732dd02ff.php 第 57 行.
[8] Undefined index: amateur /var/www/Gather/Gather/Runtime/Cache/Home/82b70b0e5243bee92f02f83732dd02ff.php 第 57 行.
[8] Undefined index: amateur /var/www/Gather/Gather/Runtime/Cache/Home/82b70b0e5243bee92f02f83732dd02ff.php 第 57 行.
[8] Undefined index: amateur /var/www/Gather/Gather/Runtime/Cache/Home/82b70b0e5243bee92f02f83732dd02ff.php 第 57 行.
[8] Undefined index: amateur /var/www/Gather/Gather/Runtime/Cache/Home/82b70b0e5243bee92f02f83732dd02ff.php 第 57 行.
[8] Undefined index: amateur /var/www/Gather/Gather/Runtime/Cache/Home/82b70b0e5243bee92f02f83732dd02ff.php 第 57 行.
[8] Undefined index: amateur /var/www/Gather/Gather/Runtime/Cache/Home/82b70b0e5243bee92f02f83732dd02ff.php 第 57 行.
[8] Undefined index: amateur /var/www/Gather/Gather/Runtime/Cache/Home/82b70b0e5243bee92f02f83732dd02ff.php 第 57 行.
[8] Undefined index: amateur /var/www/Gather/Gather/Runtime/Cache/Home/82b70b0e5243bee92f02f83732dd02ff.php 第 57 行.
[8] Undefined index: amateur /var/www/Gather/Gather/Runtime/Cache/Home/82b70b0e5243bee92f02f83732dd02ff.php 第 57 行.
[8] Undefined index: amateur /var/www/Gather/Gather/Runtime/Cache/Home/82b70b0e5243bee92f02f83732dd02ff.php 第 57 行.
[8] Undefined index: amateur /var/www/Gather/Gather/Runtime/Cache/Home/82b70b0e5243bee92f02f83732dd02ff.php 第 57 行.
[8] Undefined index: amateur /var/www/Gather/Gather/Runtime/Cache/Home/82b70b0e5243bee92f02f83732dd02ff.php 第 57 行.
[8] Undefined index: amateur /var/www/Gather/Gather/Runtime/Cache/Home/82b70b0e5243bee92f02f83732dd02ff.php 第 57 行.
[8] Undefined index: amateur /var/www/Gather/Gather/Runtime/Cache/Home/82b70b0e5243bee92f02f83732dd02ff.php 第 57 行.
[8] Undefined index: amateur /var/www/Gather/Gather/Runtime/Cache/Home/82b70b0e5243bee92f02f83732dd02ff.php 第 57 行.
[8] Undefined index: amateur /var/www/Gather/Gather/Runtime/Cache/Home/82b70b0e5243bee92f02f83732dd02ff.php 第 57 行.
[8] Undefined index: amateur /var/www/Gather/Gather/Runtime/Cache/Home/82b70b0e5243bee92f02f83732dd02ff.php 第 57 行.
[8] Undefined index: amateur /var/www/Gather/Gather/Runtime/Cache/Home/82b70b0e5243bee92f02f83732dd02ff.php 第 57 行.
[8] Undefined index: amateur /var/www/Gather/Gather/Runtime/Cache/Home/82b70b0e5243bee92f02f83732dd02ff.php 第 57 行.
[8] Undefined index: amateur /var/www/Gather/Gather/Runtime/Cache/Home/82b70b0e5243bee92f02f83732dd02ff.php 第 57 行.
[8] Undefined index: amateur /var/www/Gather/Gather/Runtime/Cache/Home/82b70b0e5243bee92f02f83732dd02ff.php 第 57 行.
[8] Undefined index: amateur /var/www/Gather/Gather/Runtime/Cache/Home/82b70b0e5243bee92f02f83732dd02ff.php 第 57 行.
[8] Undefined index: amateur /var/www/Gather/Gather/Runtime/Cache/Home/82b70b0e5243bee92f02f83732dd02ff.php 第 57 行.
[8] Undefined index: amateur /var/www/Gather/Gather/Runtime/Cache/Home/82b70b0e5243bee92f02f83732dd02ff.php 第 57 行.
[8] Undefined index: amateur /var/www/Gather/Gather/Runtime/Cache/Home/82b70b0e5243bee92f02f83732dd02ff.php 第 57 行.
[8] Undefined index: amateur /var/www/Gather/Gather/Runtime/Cache/Home/82b70b0e5243bee92f02f83732dd02ff.php 第 57 行.
[8] Undefined index: amateur /var/www/Gather/Gather/Runtime/Cache/Home/82b70b0e5243bee92f02f83732dd02ff.php 第 57 行.
[8] Undefined index: amateur /var/www/Gather/Gather/Runtime/Cache/Home/82b70b0e5243bee92f02f83732dd02ff.php 第 57 行.
[8] Undefined index: amateur /var/www/Gather/Gather/Runtime/Cache/Home/82b70b0e5243bee92f02f83732dd02ff.php 第 57 行.
[8] Undefined index: amateur /var/www/Gather/Gather/Runtime/Cache/Home/82b70b0e5243bee92f02f83732dd02ff.php 第 57 行.
[8] Undefined index: amateur /var/www/Gather/Gather/Runtime/Cache/Home/82b70b0e5243bee92f02f83732dd02ff.php 第 57 行.
[8] Undefined index: amateur /var/www/Gather/Gather/Runtime/Cache/Home/82b70b0e5243bee92f02f83732dd02ff.php 第 57 行.
[8] Undefined index: amateur /var/www/Gather/Gather/Runtime/Cache/Home/82b70b0e5243bee92f02f83732dd02ff.php 第 57 行.
[8] Undefined index: amateur /var/www/Gather/Gather/Runtime/Cache/Home/82b70b0e5243bee92f02f83732dd02ff.php 第 57 行.
[8] Undefined index: amateur /var/www/Gather/Gather/Runtime/Cache/Home/82b70b0e5243bee92f02f83732dd02ff.php 第 57 行.
[8] Undefined index: amateur /var/www/Gather/Gather/Runtime/Cache/Home/82b70b0e5243bee92f02f83732dd02ff.php 第 57 行.
[8] Undefined index: amateur /var/www/Gather/Gather/Runtime/Cache/Home/82b70b0e5243bee92f02f83732dd02ff.php 第 57 行.
[8] Undefined index: amateur /var/www/Gather/Gather/Runtime/Cache/Home/82b70b0e5243bee92f02f83732dd02ff.php 第 57 行.
[8] Undefined index: amateur /var/www/Gather/Gather/Runtime/Cache/Home/82b70b0e5243bee92f02f83732dd02ff.php 第 57 行.
[8] Undefined index: amateur /var/www/Gather/Gather/Runtime/Cache/Home/82b70b0e5243bee92f02f83732dd02ff.php 第 57 行.
[8] Undefined index: amateur /var/www/Gather/Gather/Runtime/Cache/Home/82b70b0e5243bee92f02f83732dd02ff.php 第 57 行.
[8] Undefined index: amateur /var/www/Gather/Gather/Runtime/Cache/Home/82b70b0e5243bee92f02f83732dd02ff.php 第 57 行.
[8] Undefined index: amateur /var/www/Gather/Gather/Runtime/Cache/Home/82b70b0e5243bee92f02f83732dd02ff.php 第 57 行.
[8] Undefined index: amateur /var/www/Gather/Gather/Runtime/Cache/Home/82b70b0e5243bee92f02f83732dd02ff.php 第 57 行.
[2] Invalid argument supplied for foreach() /var/www/Gather/Gather/Runtime/Cache/Home/82b70b0e5243bee92f02f83732dd02ff.php 第 163 行.
[2] Invalid argument supplied for foreach() /var/www/Gather/Gather/Runtime/Cache/Home/82b70b0e5243bee92f02f83732dd02ff.php 第 202 行.
[2] Invalid argument supplied for foreach() /var/www/Gather/Gather/Runtime/Cache/Home/82b70b0e5243bee92f02f83732dd02ff.php 第 240 行.

SHOW COLUMNS FROM `ga_league` [ RunTime:0.001354s ]
SHOW COLUMNS FROM `ga_sports` [ RunTime:0.021913s ]
SHOW COLUMNS FROM `ga_area` [ RunTime:0.007747s ]
SELECT `rd_id`,`id`,`en`,`zh`,`table_name`,`pr` FROM `ga_sports` [ RunTime:0.000310s ]
SELECT `id`,`en`,`zh`,`pr` FROM `ga_area` [ RunTime:0.000228s ]
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.064858s ]
SELECT `rd_id`,`id`,`en`,`zh`,`table_name`,`pr` FROM `ga_sports` [ RunTime:0.000351s ]
SELECT `id`,`en`,`zh`,`pr` FROM `ga_area` [ RunTime:0.000317s ]
SHOW COLUMNS FROM `ga_datacenter_match` [ RunTime:0.043780s ]
SELECT t1.zh as home_zh,t1.en as home_en,t2.zh as away_zh,t2.en as away_en,t1.id as home_id,t2.id as away_id,m.home_tid,m.away_tid,l.id as lid,r.rd_id as rid,g.id as gid,g.area_id,m.sid as sportID 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_league as l ON m.tid = l.rd_id 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 WHERE ( m.position = 1 and m.status_id = 0 and m.sid = 2 and (g.area _id = 7 or r.cid is null ) ) GROUP BY m.id ORDER BY m.StartDate asc LIMIT 20 [ RunTime:0.000289s ]
SELECT m.home_tid,m.away_tid,l.id as lid,r.rd_id as rid,g.id as gid,g.area_id,m.sid as sportID,l.zh,l.en,g.n2 FROM ga_datacenter_match m LEFT JOIN ga_league as l ON m.tid = l.rd_id 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 WHERE ( l.position = 1 and m.status_id = 0 and m.sid = 2 and (g.area _id = 7 or r.cid is null ) ) GROUP BY l.id ORDER BY m.StartDate asc LIMIT 20 [ RunTime:0.000173s ]
SELECT t1.zh as home_zh,t1.en as home_en,t2.zh as away_zh,t2.en as away_en,t1.id as home_id,t2.id as away_id,m.home_tid,m.away_tid,l.id as lid,r.rd_id as rid,g.id as gid,g.area_id,m.sid as sportID,t1.position t1p,t2.position t2p,g.n2 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_league as l ON m.tid = l.rd_id 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 WHERE ( (t1.position <> 0 or t2.position <> 0) and m.status_id = 0 and m.sid = 2 and (g.area _id = 7 or r.cid is null ) ) GROUP BY m.id ORDER BY m.StartDate asc LIMIT 20 [ RunTime:0.000246s ]

0.1934s