4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
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,087,728 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.1752
Total Execution Time  0.1771
  CADENA URL  
/japon1996/grupo1/historico
  GET DATOS  
$_GET['/japon1996/grupo1/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (15)  
0.0021  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=58 AND type_rel = 3
0.0061  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.0045  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.0022  SELECT id,name,alias,stepParent FROM categories WHERE parentId=58 ORDER BY order_id ASC
0.0029  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 = 44548 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0028  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 58 AND group_code = 1 and tables = 1 AND year <= 1996 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
0.0037  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.0023  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-27 10:07:08' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0022  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-27 10:07:08' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0022  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-27 10:07:08' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0022  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-27 10:07:08' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0640  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 events1996 e ON e.player_id = p.id AND e.league_id = 44548 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 44548 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.0311  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 events1996 e ON e.player_id = p.id AND e.league_id = 44548 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 44548 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0133  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 events1996 e ON e.player_id = p.id AND e.league_id = 44548 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 44548 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0047  SELECT *,(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