4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Ver jornada
Jornada 1
21 Feb 13 Viktoria PlzeňViktoria 2 - 0 NapoliNapoli 8
21 Feb 13 Olympique LyonnaisOlympique 1 - 1 Tottenham HotspurTottenham 8
21 Feb 13 LazioLazio 2 - 0 B. MönchengladbachMönchengla 9
21 Feb 13 Hannover 96Hannover 1 - 1 AnzhiAnzhi 8
21 Feb 13 ChelseaChelsea 1 - 1 Sparta PrahaSparta 16
21 Feb 13 Dnipro DnipropetrovskDnipro 1 - 1 BaselBasel 1
21 Feb 13 Rubin KazánRubin 0 - 1 AtléticoAtlético 65
21 Feb 13 GenkGenk 0 - 2 StuttgartStuttgart 3
21 Feb 13 LiverpoolLiverpool 3 - 1 ZenitZenit 36
21 Feb 13 Olympiacos PiraeusOlympiacos 0 - 1 LevanteLevante 30
21 Feb 13 CFR ClujCFR Cluj 0 - 3 InterInter 7
21 Feb 13 Metalist KharkivMetalist 0 - 1 NewcastleNewcastle 3
21 Feb 13 BenficaBenfica 2 - 1 B. LeverkusenLeverkusen 10
21 Feb 13 FenerbahçeFenerbahçe 1 - 0 BATE BorisovBATE 5
21 Feb 13 Girondins BordeauxGirondins 1 - 0 Dynamo KyivDynamo Kyiv 4
14 Feb 13 Tottenham HotspurTottenham 2 - 1 Olympique LyonnaisOlympique 17
14 Feb 13 NapoliNapoli 0 - 3 Viktoria PlzeňViktoria 7
14 Feb 13 B. MönchengladbachMönchengla 3 - 3 LazioLazio 16
14 Feb 13 Sparta PrahaSparta 0 - 1 ChelseaChelsea 7
14 Feb 13 AnzhiAnzhi 3 - 1 Hannover 96Hannover 2
14 Feb 13 BaselBasel 2 - 0 Dnipro DnipropetrovskDnipro ...
14 Feb 13 AtléticoAtlético 0 - 2 Rubin KazánRubin 71
14 Feb 13 StuttgartStuttgart 1 - 1 GenkGenk 2
14 Feb 13 ZenitZenit 2 - 0 LiverpoolLiverpool 16
14 Feb 13 LevanteLevante 3 - 0 Olympiacos PiraeusOlympiacos 51
14 Feb 13 InterInter 2 - 0 CFR ClujCFR Cluj 5
14 Feb 13 NewcastleNewcastle 0 - 0 Metalist KharkivMetalist 6
14 Feb 13 B. LeverkusenLeverkusen 0 - 1 BenficaBenfica 3
14 Feb 13 BATE BorisovBATE 0 - 0 FenerbahçeFenerbahçe 2
14 Feb 13 Dynamo KyivDynamo Kyiv 1 - 1 Girondins BordeauxGirondins 2
14 Feb 13 AjaxAjax 2 - 0 FCSBFCSB ...
21 Feb 13 FCSBFCSB 2 - 0 AjaxAjax ...
Ver jornada
Jornada 2
07 Mar 13 StuttgartStuttgart 0 - 2 LazioLazio 14
07 Mar 13 Tottenham HotspurTottenham 3 - 0 InterInter 20
07 Mar 13 Viktoria PlzeňViktoria 0 - 1 FenerbahçeFenerbahçe 3
07 Mar 13 BenficaBenfica 1 - 0 Girondins BordeauxGirondins 5
07 Mar 13 AnzhiAnzhi 0 - 0 NewcastleNewcastle 2
07 Mar 13 LevanteLevante 0 - 0 Rubin KazánRubin 40
07 Mar 13 BaselBasel 2 - 0 ZenitZenit 5
14 Mar 13 LazioLazio 3 - 1 StuttgartStuttgart 18
14 Mar 13 InterInter 4 - 1 Tottenham HotspurTottenham 76
14 Mar 13 FenerbahçeFenerbahçe 1 - 1 Viktoria PlzeňViktoria 6
14 Mar 13 Girondins BordeauxGirondins 2 - 3 BenficaBenfica 9
14 Mar 13 NewcastleNewcastle 1 - 0 AnzhiAnzhi 11
14 Mar 13 Rubin KazánRubin 2 - 0 LevanteLevante 89
14 Mar 13 ZenitZenit 1 - 0 BaselBasel 11
07 Mar 13 FCSBFCSB 1 - 0 ChelseaChelsea ...
14 Mar 13 ChelseaChelsea 3 - 1 FCSBFCSB 49
Ver jornada
Jornada 3
04 Abr 13 ChelseaChelsea 3 - 1 Rubin KazánRubin 60
11 Abr 13 Rubin KazánRubin 3 - 2 ChelseaChelsea 48
04 Abr 13 Tottenham HotspurTottenham 2 - 2 BaselBasel 22
11 Abr 13 BaselBasel 2 - 2 Tottenham HotspurTottenham 45
04 Abr 13 FenerbahçeFenerbahçe 2 - 0 LazioLazio 27
11 Abr 13 LazioLazio 1 - 1 FenerbahçeFenerbahçe 16
04 Abr 13 BenficaBenfica 3 - 1 NewcastleNewcastle 11
11 Abr 13 NewcastleNewcastle 1 - 1 BenficaBenfica 17
Ver jornada
Jornada 4
25 Abr 13 FenerbahçeFenerbahçe 1 - 0 BenficaBenfica 12
25 Abr 13 BaselBasel 1 - 2 ChelseaChelsea 29
02 May 13 ChelseaChelsea 3 - 1 BaselBasel 39
02 May 13 BenficaBenfica 3 - 1 FenerbahçeFenerbahçe 23
Ver jornada
Jornada 5
15 May 13 BenficaBenfica 1 - 2 ChelseaChelsea 133

  USO DE MEMORIA  
4,692,560 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0018
Controller Execution Time ( Home / Category )  0.0821
Total Execution Time  0.0840
  CADENA URL  
/uefa2013/grupo0/calendario
  GET DATOS  
$_GET['/uefa2013/grupo0/calendario']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (17)  
0.0018  SELECT type FROM routes WHERE alias = 'uefa2013'
0.0040  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'uefa' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2013 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0021  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 = 2257 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0023  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 calendars2013 c INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE c.league_id = 2257 ORDER BY round ASC
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-05-03 10:16:52' 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=2 AND last_update > '2024-05-03 10:16:52' 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-05-03 10:16:52' 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=3 AND last_update > '2024-05-03 10:16:52' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0022  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 117 AND l.year = 2013
0.0041  SELECT e.action, count(e.action) as total, e.player_id FROM events2013 e WHERE e.league_id IN (2149,2150,2151,2152,2153,2154,2155,2156,2157,2158,2159,2160,2257) 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.0026  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 (2149,2150,2151,2152,2153,2154,2155,2156,2157,2158,2159,2160,2257) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (27094,1202,21985,16841,29366,30713,58959,524,560,1228) ORDER BY rp.in_squad = 1 DESC
0.0021  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 117 AND l.year = 2013
0.0044  SELECT e.action, count(e.action) as total, e.player_id FROM events2013 e WHERE e.league_id IN (2149,2150,2151,2152,2153,2154,2155,2156,2157,2158,2159,2160,2257) AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10
0.0023  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 (2149,2150,2151,2152,2153,2154,2155,2156,2157,2158,2159,2160,2257) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (29383,67489,1881,7768,8880,14235,21102,21459,21761,22426) ORDER BY rp.in_squad = 1 DESC
0.0021  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 117 AND l.year = 2013
0.0022  SELECT e.action, count(e.action) as total, e.player_id FROM events2013 e WHERE e.league_id IN (2149,2150,2151,2152,2153,2154,2155,2156,2157,2158,2159,2160,2257) AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10
0.0024  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 (2149,2150,2151,2152,2153,2154,2155,2156,2157,2158,2159,2160,2257) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (791,914,1072,1612,1904,7801,17286,21197,21637,22290) ORDER BY rp.in_squad = 1 DESC