4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Ver
TEMPORADA 2005/2006
Equipo PJ GF GC Puntos
1 Henan FC Henan FC 24 38 13 59
2 Zhejiang FC Zhejiang FC 24 41 18 55
3 Guangzhou FC Guangzhou 24 45 25 48
4 Chengdu Blades Chengdu 24 27 18 38
5 Nanjing Yoyo Nanjing Yoyo 24 24 20 35
6 Jiangsu FC Jiangsu FC 24 37 31 33
7 Qingdao Hailifeng Qingdao 24 25 32 31
8 Yanbian Longding Yanbian 24 26 22 29
9 TIbet Huitong TIbet 24 32 41 26
10 Shanghai Kangbo Shanghai 24 15 35 22
11 Shanghai Shenxin Shanghai 24 11 27 20
12 Beijing BSU Beijing BSU 24 18 40 19
13 Hunan Billows FC Hunan 24 16 33 15
Ver
TEMPORADA 2004/2005
Equipo PJ GF GC Puntos
1 Changchun Yatai Changchun 26 71 22 64
2 Xiamen Lanshi Xiamen 26 61 23 64
3 Guangdong Guangdong 26 50 22 52
4 Zhejiang FC Zhejiang FC 26 49 25 52
5 Jiangsu Shuntian Jiangsu 26 43 21 47
6 Qingdao Hisense Qingdao 26 35 32 41
7 Yanbian Longding Yanbian 26 45 40 36
8 Nanjing Yoyo Nanjing Yoyo 26 41 39 34
9 Shanghai 9th City Shanghai 26 46 54 29
10 Henan FC Henan FC 26 27 36 27
11 Chengdu Blades Chengdu 26 40 57 26
12 Hunan Billows FC Hunan 26 24 56 19
13 Dalian Changbo Dalian 26 20 54 16
14 Shaanxi Guoli Shaanxi 26 2 73 4
Ver
TEMPORADA 2003/2004
Equipo PJ GF GC Puntos
1 Wuhan Guanggu Wuhan 32 53 28 65
2 Wuxi Zhongbang Wuxi 32 56 36 62
3 Xiamen Hongshi Xiamen 32 38 26 53
4 Guangdong Guangdong 32 45 29 52
5 Changchun Yatai Changchun 32 53 34 51
6 Jiangsu FC Jiangsu FC 32 35 24 50
7 Henan FC Henan FC 32 29 27 45
8 Zhejiang FC Zhejiang FC 32 38 39 45
9 Nanjing Yoyo Nanjing Yoyo 32 44 46 43
10 Shenzhen Kejian Shenzhen 32 44 40 39
11 Qingdao Hisense Qingdao 32 36 39 39
12 Shaanxi Guoli Shaanxi 32 44 59 39
13 Chengdu Wuniu Chengdu 32 46 57 31
14 Hunan Billows FC Hunan 32 34 51 31
15 Dalian Changbo Dalian 32 22 35 30
16 Guangdong Dongguan Guangdong 32 38 56 30
17 Xian Anxinyuan Xian 32 30 59 22

  USO DE MEMORIA  
5,040,648 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.0643
Total Execution Time  0.0662
  CADENA URL  
/liga_uno_china2006/grupo1/historico
  GET DATOS  
$_GET['/liga_uno_china2006/grupo1/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (17)  
0.0017  SELECT type FROM routes WHERE alias = 'liga_uno_china2006'
0.0039  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'liga_uno_china' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2006 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0018  SELECT id,name,alias,stepParent FROM categories WHERE parentId=239 ORDER BY order_id ASC
0.0019  SELECT dt.nameShow,dt.basealias,t.id,t.teamId FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 16485 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0022  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 239 AND group_code = 1 and tables = 1 AND year <= 2006 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
0.0022  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2006` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 16485 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2005` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 16486 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2004` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 16487 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-28 17:12:14' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-28 17:12:14' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-28 17:12:14' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0019  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-28 17:12:14' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0031  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'liga_uno_china' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2006 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0020  SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2006 e ON e.player_id = p.id AND e.league_id = 16485 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 16485 AND (e.action = 1 or e.action = 2 or e.action = 11 or e.action = 12 or e.action = 13) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0021  SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2006 e ON e.player_id = p.id AND e.league_id = 16485 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 16485 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0018  SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2006 e ON e.player_id = p.id AND e.league_id = 16485 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 16485 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0031  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2006` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 16485 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC