Clasificación

Equipo PJ GF GC Puntos
1 Schalke 04 Schalke 04 34 72 44 65
2 Werder Bremen Werder 34 65 43 63
3 Hamburger SV Hamburger 34 67 35 60
4 Darmstadt 98 Darmstadt 34 71 46 60
5 FC St Pauli FC St Pauli 34 61 46 57
6 Heidenheim Heidenheim 34 43 45 52
7 Paderborn Paderborn 34 56 44 51
8 Nürnberg Nürnberg 34 49 49 51
9 Holstein Kiel Holstein 34 46 54 45
10 Fortuna Düsseldorf Fortuna 34 45 42 44
11 Hannover 96 Hannover 96 34 35 49 42
12 Karlsruher SC Karlsruher 34 54 55 41
13 Hansa Rostock Hansa 34 41 52 41
14 Sandhausen Sandhausen 34 42 54 41
15 Jahn Regensburg Jahn 34 50 51 40
16 Dynamo Dresden Dynamo 34 33 46 32
17 Erzgebirge Aue Erzgebirge 34 32 72 26
18 Ingolstadt 04 Ingolstadt 34 30 65 21

  USO DE MEMORIA  
5,089,480 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0018
Controller Execution Time ( Home / Category )  0.3166
Total Execution Time  0.3185
  CADENA URL  
/bundesliga_22022/grupo1/minutoaminuto
  GET DATOS  
$_GET['/bundesliga_22022/grupo1/minutoaminuto']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (13)  
0.0111  SELECT type FROM routes WHERE alias = 'bundesliga_22022'
0.0223  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'bundesliga_2' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2022 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0117  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 = 62743 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0135  SELECT c.r1,c.r2,e.action,ev.showName as eventName,ev.largeName,ev.main_action,ev.keyname,ev.classf,e.real_date,e.minute, dp.nick,dp.CountryCode,dp.alias,c.datateam1,c.datateam2,dt1.nameShow as nameShow1,dt2.nameShow as nameShow2,dt1.basealias as basealias1,dt2.basealias as basealias2,e.player_id,e.match_id FROM `events2022` e INNER JOIN calendars2022 c ON c.id = e.match_id INNER JOIN events ev ON ev.id = e.action INNER JOIN dataplayers dp ON dp.id = e.player_id INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE ev.show_on = 1 AND e.real_date IS NOT NULL AND e.league_id = 62743 AND e.real_date > NOW() - INTERVAL 1 MONTH ORDER BY e.real_date DESC LIMIT 100
0.0113  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-19 16:06:45' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0113  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-19 16:06:45' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0110  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-19 16:06:45' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0112  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-19 16:06:45' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0124  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'bundesliga_2' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2022 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0641  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 events2022 e ON e.player_id = p.id AND e.league_id = 62743 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 62743 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.0303  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 events2022 e ON e.player_id = p.id AND e.league_id = 62743 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 62743 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0112  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 events2022 e ON e.player_id = p.id AND e.league_id = 62743 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 62743 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0117  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2022` 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 = 62743 AND t.round = 34 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC