4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Ver
TEMPORADA 2008/2009
Equipo PJ GF GC Puntos
1 Kashima Antlers Kashima 34 51 30 66
2 Kawasaki Frontale Kawasaki 34 64 40 64
3 Gamba Osaka Gamba Osaka 34 62 44 60
4 Sanfrecce Hiroshima Sanfrecce 34 53 44 56
5 FC Tokyo FC Tokyo 34 47 39 53
6 Urawa Reds Urawa Reds 34 43 43 52
7 Shimizu S-Pulse Shimizu 34 44 41 51
8 Albirex Niigata Albirex 34 42 31 50
9 Nagoya Grampus Nagoya 34 46 42 50
10 Yokohama F. Marinos Yokohama 34 43 37 46
11 Júbilo Iwata Júbilo 34 50 60 41
12 Kyoto Sanga Kyoto Sanga 34 35 47 41
13 Omiya Ardija Omiya Ardija 34 40 47 39
14 Vissel Kobe Vissel Kobe 34 40 48 39
15 Montedio Yamagata Montedio 34 32 40 39
16 Kashiwa Reysol Kashiwa 34 41 57 34
17 Oita Trinita Oita Trinita 34 26 45 30
18 JEF United JEF United 34 32 56 27
Ver
TEMPORADA 2007/2008
Equipo PJ GF GC Puntos
1 Kashima Antlers Kashima 33 55 30 60
2 Nagoya Grampus Nagoya 33 48 35 58
3 Kawasaki Frontale Kawasaki 33 63 42 57
4 Oita Trinita Oita Trinita 33 33 24 55
5 FC Tokyo FC Tokyo 33 48 42 55
6 Urawa Reds Urawa Reds 33 49 36 53
7 Shimizu S-Pulse Shimizu 33 47 41 52
8 Gamba Osaka Gamba Osaka 33 44 46 50
9 Vissel Kobe Vissel Kobe 33 39 36 47
10 Yokohama F. Marinos Yokohama 33 37 31 45
11 Kashiwa Reysol Kashiwa 33 46 45 43
12 Kyoto Sanga Kyoto Sanga 33 36 43 41
13 Omiya Ardija Omiya Ardija 33 35 45 40
14 Albirex Niigata Albirex 33 29 44 39
15 Júbilo Iwata Júbilo 33 40 47 37
16 Tokyo Verdy Tokyo Verdy 33 38 48 37
17 JEF United JEF United 33 32 51 35
18 Consadole Sapporo Consadole 33 36 69 18
Ver
TEMPORADA 2006/2007
Equipo PJ GF GC Puntos
1 Kashima Antlers Kashima 34 60 36 72
2 Urawa Reds Urawa Reds 34 55 28 70
3 Gamba Osaka Gamba Osaka 34 71 37 67
4 Shimizu S-Pulse Shimizu 34 53 36 61
5 Kawasaki Frontale Kawasaki 34 66 48 54
6 Albirex Niigata Albirex 34 48 47 51
7 Yokohama F. Marinos Yokohama 34 54 35 50
8 Kashiwa Reysol Kashiwa 34 43 36 50
9 Júbilo Iwata Júbilo 34 54 55 49
10 Vissel Kobe Vissel Kobe 34 58 48 47
11 Nagoya Grampus Nagoya 34 43 45 45
12 FC Tokyo FC Tokyo 34 49 58 45
13 JEF United JEF United 34 51 56 42
14 Oita Trinita Oita Trinita 34 42 60 41
15 Omiya Ardija Omiya Ardija 34 24 40 35
16 Sanfrecce Hiroshima Sanfrecce 34 44 71 32
17 Ventforet Kofu Ventforet 34 33 65 27
18 Yokohama Yokohama 34 19 66 16
Ver
TEMPORADA 2005/2006
Equipo PJ GF GC Puntos
1 Urawa Reds Urawa Reds 34 67 28 72
2 Kawasaki Frontale Kawasaki 34 84 55 67
3 Gamba Osaka Gamba Osaka 34 80 48 66
4 Shimizu S-Pulse Shimizu 34 60 41 60
5 Júbilo Iwata Júbilo 34 68 51 58
6 Kashima Antlers Kashima 34 62 53 58
7 Nagoya Grampus Nagoya 34 51 49 48
8 Oita Trinita Oita Trinita 34 47 45 47
9 Yokohama F. Marinos Yokohama 34 49 43 45
10 Sanfrecce Hiroshima Sanfrecce 34 50 56 45
11 JEF United JEF United 34 57 58 44
12 Omiya Ardija Omiya Ardija 34 43 55 44
13 FC Tokyo FC Tokyo 34 56 65 43
14 Albirex Niigata Albirex 34 46 65 42
15 Ventforet Kofu Ventforet 34 42 64 42
16 Avispa Fukuoka Avispa 34 32 56 27
17 Cerezo Osaka Cerezo Osaka 34 44 70 27
18 Kyoto Sanga Kyoto Sanga 34 38 74 22
Ver
TEMPORADA 2004/2005
Equipo PJ GF GC Puntos
1 Gamba Osaka Gamba Osaka 34 82 58 60
2 Urawa Reds Urawa Reds 34 65 37 59
3 Kashima Antlers Kashima 34 61 39 59
4 JEF United JEF United 34 56 42 59
5 Cerezo Osaka Cerezo Osaka 34 48 40 59
6 Júbilo Iwata Júbilo 34 51 41 51
7 Sanfrecce Hiroshima Sanfrecce 34 50 42 50
8 Kawasaki Frontale Kawasaki 34 54 47 50
9 Yokohama F. Marinos Yokohama 34 41 40 48
10 FC Tokyo FC Tokyo 34 43 40 47
11 Oita Trinita Oita Trinita 34 44 43 43
12 Albirex Niigata Albirex 34 47 62 42
13 Omiya Ardija Omiya Ardija 34 39 50 41
14 Nagoya Grampus Nagoya 34 43 49 39
15 Shimizu S-Pulse Shimizu 34 40 49 39
16 Kashiwa Reysol Kashiwa 34 39 54 35
17 Tokyo Verdy Tokyo Verdy 34 40 73 30
18 Vissel Kobe Vissel Kobe 34 30 67 21
Ver
TEMPORADA 1995/1996
Equipo PJ GF GC Puntos
1 Kashima Antlers Kashima 30 61 34 62
2 Nagoya Grampus Nagoya 30 63 39 61
3 Flugels Flugels 30 58 44 61
4 Kashiwa Reysol Kashiwa 30 67 52 60
5 Júbilo Iwata Júbilo 30 53 38 60
6 Tokyo Verdy Tokyo Verdy 30 68 42 57
7 Urawa Reds Urawa Reds 30 51 31 55
8 Yokohama F. Marinos Yokohama 30 39 40 40
9 JEF United JEF United 30 45 47 40
10 Shimizu S-Pulse Shimizu 30 50 60 37
11 Shonan Bellmare Shonan 30 47 58 36
12 Gamba Osaka Gamba Osaka 30 38 59 31
13 Avispa Fukuoka Avispa 30 42 64 29
14 Cerezo Osaka Cerezo Osaka 30 38 56 28
15 Sanfrecce Hiroshima Sanfrecce 30 36 60 28
16 Kyoto Sanga Kyoto Sanga 30 22 54 24

  USO DE MEMORIA  
5,932,272 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0036
Controller Execution Time ( Home / Category )  0.5882
Total Execution Time  0.5918
  CADENA URL  
/japon2009/grupo1/historico
  GET DATOS  
$_GET['/japon2009/grupo1/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (25)  
0.0144  SELECT type FROM routes WHERE alias = 'japon2009'
0.0292  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'japon' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2009 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0145  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=58 AND type_rel = 3
0.0154  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 58 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0147  SELECT /*53 bs_news_model*/ n.id, n.author_id, n.headline, n.external_headline, n.live_headline, n.creation_date, n.update_date, n.pub_date, n.alias, n.subheadline, n.teaser, n.media, n.tags, n.views, n.screens, n.clicks, n.relations, n.comments, n.power_cover, n.cover_points, u.name as user_name FROM bs_news n INNER JOIN bs_editors u ON u.id = n.author_id AND u.ln = 'es' WHERE n.status = 1 AND n.ln = 'es' AND n.id IN (1302659,1301064,1285113,1277278,1270258) ORDER BY n.cover_points DESC, update_date DESC
0.0145  SELECT id,name,alias,stepParent FROM categories WHERE parentId=58 ORDER BY order_id ASC
0.0145  SELECT max(l.year) as max_year, min(l.year) as min_year FROM leagues l WHERE categoryID = 58 GROUP BY l.categoryId
0.0145  SELECT l.year FROM leagues AS l WHERE (l.group_code =0 OR l.total_num_tablesR>=1 OR l.total_teamsR >=1 OR l.text_mode != 0) AND l.categoryId=58 GROUP BY l.year ORDER BY l.year DESC
0.0146  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 = 888 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0614  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 58 AND group_code = 1 and tables = 1 AND year <= 2009 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
0.0153  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 `tables2009` 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 = 888 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0149  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 `tables2008` 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 = 267 AND t.round = 33 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0150  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 `tables2007` 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 = 425 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0151  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 = 426 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0149  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 = 712 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0149  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 `tables1996` 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 = 44548 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0145  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-05-04 16:13:35' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0145  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-05-04 16:13:35' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0145  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-05-04 16:13:35' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0145  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-05-04 16:13:35' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0149  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'japon' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2009 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0270  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 events2009 e ON e.player_id = p.id AND e.league_id = 888 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 888 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.0265  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 events2009 e ON e.player_id = p.id AND e.league_id = 888 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 888 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0214  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 events2009 e ON e.player_id = p.id AND e.league_id = 888 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 888 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0159  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2009` 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 = 888 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC