4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Ver jornada
Jornada 1
10 Ago 19 Würzburger KickersWürzburger 3 - 3 HoffenheimHoffenheim 6
11 Ago 19 SalmrohrSalmrohr 0 - 6 Holstein KielHolstein ...
11 Ago 19 Germania HalberstadtGermania 0 - 6 Union BerlinUnion 2
10 Ago 19 KaiserslauternKaiserslaut 2 - 0 Mainz 05Mainz 05 5
11 Ago 19 RödinghausenRödinghaus 3 - 3 PaderbornPaderborn 4
12 Ago 19 Hallescher FCHallescher 3 - 5 WolfsburgWolfsburg 153
10 Ago 19 Atlas DelmenhorstAtlas 1 - 6 Werder BremenWerder 8
09 Ago 19 KFC Uerdingen 05Uerdingen 0 - 2 B. DortmundDortmund 46
09 Ago 19 SandhausenSandhausen 0 - 1 B. MönchengladbachMönchengla 36
11 Ago 19 ChemnitzerChemnitzer 2 - 2 Hamburger SVHamburger 16
11 Ago 19 Waldhof MannheimWaldhof 3 - 5 Eintracht FrankfurtEintracht 47
10 Ago 19 Alemannia AachenAlemannia 1 - 4 B. LeverkusenLeverkusen 9
10 Ago 19 DassendorfDassendorf 0 - 3 Dynamo DresdenDynamo 4
10 Ago 19 VillingenVillingen 1 - 3 Fortuna DüsseldorfFortuna 5
10 Ago 19 KSV BaunatalBaunatal 2 - 3 VfL BochumVfL Bochum 1
12 Ago 19 Energie CottbusEnergie 1 - 3 Bayern MünchenBayern 148
12 Ago 19 Karlsruher SCKarlsruher 2 - 0 Hannover 96Hannover 52
11 Ago 19 MSV DuisburgDuisburg 2 - 0 Greuther FürthGreuther 5
11 Ago 19 OberneulandOberneuland 1 - 6 Darmstadt 98Darmstadt ...
11 Ago 19 Wehen WiesbadenWehen 3 - 3 KölnKöln 3
12 Ago 19 Hansa RostockHansa 0 - 1 StuttgartStuttgart 59
11 Ago 19 1. FC SaarbrückenSaarbrücke 3 - 2 Jahn RegensburgJahn 2
10 Ago 19 Drochtersen / AsselDrochtersen 0 - 5 Schalke 04Schalke 04 2
10 Ago 19 Viktoria BerlinViktoria 0 - 1 Arminia BielefeldArminia 4
09 Ago 19 Ingolstadt 04Ingolstadt 0 - 1 NürnbergNürnberg 28
10 Ago 19 VerlVerl 2 - 1 FC AugsburgAugsburg 21
11 Ago 19 VfB LübeckLübeck 3 - 3 FC St PauliPauli 8
11 Ago 19 EichstättEichstätt 1 - 5 Hertha BSCHertha BSC 1
10 Ago 19 Wacker NordhausenWacker 1 - 4 Erzgebirge AueErzgebirge 1
11 Ago 19 VfL OsnabrückOsnabrück 2 - 3 RB LeipzigRB Leipzig 5
10 Ago 19 MagdeburgMagdeburg 0 - 1 SC FreiburgFreiburg 14
10 Ago 19 UlmUlm 0 - 2 HeidenheimHeidenheim 2
Ver jornada
Jornada 2
30 Oct 19 KaiserslauternKaiserslaut 2 - 2 NürnbergNürnberg 10
30 Oct 19 VerlVerl 1 - 1 Holstein KielHolstein 7
29 Oct 19 MSV DuisburgDuisburg 0 - 2 HoffenheimHoffenheim 36
29 Oct 19 1. FC SaarbrückenSaarbrücke 3 - 2 KölnKöln 36
29 Oct 19 Darmstadt 98Darmstadt 0 - 1 Karlsruher SCKarlsruher 11
29 Oct 19 B. LeverkusenLeverkusen 1 - 0 PaderbornPaderborn 13
29 Oct 19 SC FreiburgFreiburg 1 - 3 Union BerlinUnion 21
30 Oct 19 Fortuna DüsseldorfFortuna 2 - 1 Erzgebirge AueErzgebirge 10
29 Oct 19 VfL BochumVfL Bochum 1 - 2 Bayern MünchenBayern 90
29 Oct 19 Arminia BielefeldArminia 2 - 3 Schalke 04Schalke 04 14
30 Oct 19 B. DortmundDortmund 2 - 1 B. MönchengladbachMönchengla 44
30 Oct 19 Hertha BSCHertha BSC 3 - 3 Dynamo DresdenDynamo 15
30 Oct 19 WolfsburgWolfsburg 1 - 6 RB LeipzigRB Leipzig 38
30 Oct 19 Werder BremenWerder 4 - 1 HeidenheimHeidenheim 7
29 Oct 19 Hamburger SVHamburger 1 - 2 StuttgartStuttgart 32
30 Oct 19 FC St PauliPauli 1 - 2 Eintracht FrankfurtEintracht 8
Ver jornada
Jornada 3
04 Feb 20 Eintracht FrankfurtEintracht 3 - 1 RB LeipzigRB Leipzig 140
05 Feb 20 B. LeverkusenLeverkusen 2 - 1 StuttgartStuttgart 90
05 Feb 20 Bayern MünchenBayern 4 - 3 HoffenheimHoffenheim 33
04 Feb 20 Schalke 04Schalke 04 3 - 2 Hertha BSCHertha BSC 79
05 Feb 20 1. FC SaarbrückenSaarbrücke 0 - 0 Karlsruher SCKarlsruher 30
04 Feb 20 Werder BremenWerder 3 - 2 B. DortmundDortmund 212
04 Feb 20 KaiserslauternKaiserslaut 2 - 5 Fortuna DüsseldorfFortuna 41
05 Feb 20 VerlVerl 0 - 1 Union BerlinUnion 93
Ver jornada
Jornada 4
04 Mar 20 B. LeverkusenLeverkusen 3 - 1 Union BerlinUnion 173
03 Mar 20 Schalke 04Schalke 04 0 - 1 Bayern MünchenBayern 100
04 Mar 20 Eintracht FrankfurtEintracht 2 - 0 Werder BremenWerder 80
03 Mar 20 1. FC SaarbrückenSaarbrücke 1 - 1 Fortuna DüsseldorfFortuna 158
Ver jornada
Jornada 5
09 Jun 20 1. FC SaarbrückenSaarbrücke 0 - 3 B. LeverkusenLeverkusen 189
10 Jun 20 Bayern MünchenBayern 2 - 1 Eintracht FrankfurtEintracht 168
Ver jornada
Jornada 6
04 Jul 20 B. LeverkusenLeverkusen 2 - 4 Bayern MünchenBayern 121

  USO DE MEMORIA  
4,732,456 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0020
Controller Execution Time ( Home / Category )  0.3596
Total Execution Time  0.3616
  CADENA URL  
/dfb_pokal2020/grupo0/calendario
  GET DATOS  
$_GET['/dfb_pokal2020/grupo0/calendario']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (18)  
0.0126  SELECT type FROM routes WHERE alias = 'dfb_pokal2020'
0.0262  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'dfb_pokal' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2020 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0129  SELECT id,name,alias,stepParent FROM categories WHERE parentId=140 ORDER BY order_id ASC
0.0148  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 = 50066 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0147  SELECT c.team1, c.team2,c.extra,c.datateam1,c.datateam2,c.type, c.shedule, c.r1, c.r2, c.round, c.comments as total_comentarios, dt1.nameShow as team1_name, dt2.nameShow as team2_name, dt1.basealias as basealias1, dt2.basealias as basealias2, dt1.stadium as stadium_name FROM calendars2020 c INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE c.league_id = 50066 ORDER BY round ASC
0.0130  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-05-01 23:18:32' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0129  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-05-01 23:18:32' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0128  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-05-01 23:18:32' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0127  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-05-01 23:18:32' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0132  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 140 AND l.year = 2020
0.0136  SELECT e.action, count(e.action) as total, e.player_id FROM events2020 e WHERE e.league_id IN (50066) 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, e.player_id ASC LIMIT 10
0.0132  SELECT dp.name, dp.last_name, dp.nick,dp.CountryCode,dp.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId,dp.role FROM dataplayers AS dp INNER JOIN rel_players AS rp ON rp.player_id=dp.id AND rp.league_id IN (50066) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (53536,116310,104948,111601,123919,139116,149122,202152,246394,250368) ORDER BY rp.in_squad = 1 DESC
0.0127  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 140 AND l.year = 2020
0.0132  SELECT e.action, count(e.action) as total, e.player_id FROM events2020 e WHERE e.league_id IN (50066) AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10
0.0130  SELECT dp.name, dp.last_name, dp.nick,dp.CountryCode,dp.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId,dp.role FROM dataplayers AS dp INNER JOIN rel_players AS rp ON rp.player_id=dp.id AND rp.league_id IN (50066) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (67242,204460,308095,25463,36319,67844,75690,75800,89152,93221) ORDER BY rp.in_squad = 1 DESC
0.0129  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 140 AND l.year = 2020
0.0130  SELECT e.action, count(e.action) as total, e.player_id FROM events2020 e WHERE e.league_id IN (50066) AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10
0.0138  SELECT dp.name, dp.last_name, dp.nick,dp.CountryCode,dp.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId,dp.role FROM dataplayers AS dp INNER JOIN rel_players AS rp ON rp.player_id=dp.id AND rp.league_id IN (50066) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (75690,138711,139116,185776,199983,282919,292942,308095,559522,622391) ORDER BY rp.in_squad = 1 DESC