4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Ver jornada
Jornada 1
27 Jul 17 Olympique MarseilleOlympique 4 - 2 KV OostendeOostende 13
03 Ago 17 KV OostendeOostende 0 - 0 Olympique MarseilleOlympique 12
27 Jul 17 Dinamo BucureştiDinamo 1 - 1 AthleticAthletic 528
03 Ago 17 AthleticAthletic 3 - 0 Dinamo BucureştiDinamo 275
27 Jul 17 Olimpik DonetskOlimpik 1 - 1 PAOKPAOK 41
03 Ago 17 PAOKPAOK 2 - 0 Olimpik DonetskOlimpik 9
27 Jul 17 Universitatea CraiovaUniversitat 0 - 1 MilanMilan 186
03 Ago 17 MilanMilan 2 - 0 Universitatea CraiovaUniversitat 124
27 Jul 17 FK KrasnodarKrasnodar 2 - 1 Lyngby BKLyngby BK 34
03 Ago 17 Lyngby BKLyngby BK 1 - 3 FK KrasnodarKrasnodar 7
27 Jul 17 SūduvaSūduva 3 - 0 SionSion 21
02 Ago 17 SionSion 1 - 1 SūduvaSūduva 16
27 Jul 17 KAA GentKAA Gent 1 - 1 SCR AltachSCR Altach 49
03 Ago 17 SCR AltachSCR Altach 3 - 1 KAA GentKAA Gent 19
27 Jul 17 FK RiteriaiRiteriai 2 - 1 KF ShkëndijaShkëndija 13
03 Ago 17 KF ShkëndijaShkëndija 3 - 0 FK RiteriaiRiteriai 21
27 Jul 17 AEK LarnacaLarnaca 2 - 0 Dinamo MinskDinamo 29
03 Ago 17 Dinamo MinskDinamo 1 - 1 AEK LarnacaLarnaca 63
27 Jul 17 AIK SolnaAIK Solna 1 - 1 Sporting BragaSporting 16
03 Ago 17 Sporting BragaSporting 2 - 1 AIK SolnaAIK Solna 52
27 Jul 17 Arka GdyniaArka Gdynia 3 - 2 MidtjyllandMidtjylland 11
03 Ago 17 MidtjyllandMidtjylland 2 - 1 Arka GdyniaArka Gdynia 21
27 Jul 17 FC Astra GiurgiuAstra 0 - 0 OleksandriyaOleksandriy 13
03 Ago 17 OleksandriyaOleksandriy 1 - 0 FC Astra GiurgiuAstra 21
27 Jul 17 Brøndby IFBrøndby 0 - 0 HNK Hajduk SplitHajduk 9
03 Ago 17 HNK Hajduk SplitHajduk 2 - 0 Brøndby IFBrøndby 3
27 Jul 17 Dinamo ZagrebDinamo 2 - 1 OddOdd 10
03 Ago 17 OddOdd 0 - 0 Dinamo ZagrebDinamo 36
27 Jul 17 EvertonEverton 1 - 0 RuzomberokRuzomberok 33
03 Ago 17 RuzomberokRuzomberok 0 - 1 EvertonEverton 36
03 Ago 17 ZenitZenit 0 - 1 Bnei Yehuda Tel AvivBnei Yehuda 61
27 Jul 17 Bnei Yehuda Tel AvivBnei Yehuda 0 - 2 ZenitZenit 18
27 Jul 17 Botev PlovdivBotev 0 - 0 MarítimoMarítimo 17
03 Ago 17 MarítimoMarítimo 2 - 0 Botev PlovdivBotev 14
27 Jul 17 Östersunds FKÖstersunds 1 - 0 Fola EschFola Esch 11
03 Ago 17 Fola EschFola Esch 1 - 2 Östersunds FKÖstersunds 5
27 Jul 17 PSVPSV 0 - 1 NK OsijekNK Osijek 61
03 Ago 17 NK OsijekNK Osijek 1 - 0 PSVPSV 27
27 Jul 17 Austria WienAustria 0 - 0 AEL LimassolLimassol 24
02 Ago 17 AEL LimassolLimassol 1 - 2 Austria WienAustria 42
27 Jul 17 Mladá BoleslavMladá 2 - 1 Skënderbeu KorçëSkënderbeu 42
03 Ago 17 Skënderbeu KorçëSkënderbeu 2 - 1 Mladá BoleslavMladá 12
27 Jul 17 SC FreiburgFreiburg 1 - 0 DomžaleDomžale 8
03 Ago 17 DomžaleDomžale 2 - 0 SC FreiburgFreiburg 7
27 Jul 17 UtrechtUtrecht 0 - 0 Lech PoznańLech 37
03 Ago 17 Lech PoznańLech 2 - 2 UtrechtUtrecht 17
27 Jul 17 Sturm GrazSturm Graz 1 - 2 FenerbahçeFenerbahçe 19
03 Ago 17 FenerbahçeFenerbahçe 1 - 1 Sturm GrazSturm Graz 39
27 Jul 17 PanathinaikosPanathinaik 1 - 0 Gabala FKGabala FK 14
03 Ago 17 Gabala FKGabala FK 1 - 2 PanathinaikosPanathinaik 10
27 Jul 17 Crvena ZvezdaCrvena 2 - 0 Sparta PrahaSparta 15
03 Ago 17 Sparta PrahaSparta 0 - 1 Crvena ZvezdaCrvena 16
27 Jul 17 AberdeenAberdeen 2 - 1 Apollon LimassolApollon 18
03 Ago 17 Apollon LimassolApollon 2 - 0 AberdeenAberdeen 14
27 Jul 17 Girondins BordeauxGirondins 2 - 1 FehérvárFehérvár 5
03 Ago 17 FehérvárFehérvár 1 - 0 Girondins BordeauxGirondins 51
27 Jul 17 Maccabi Tel AvivMaccabi 1 - 0 PanioniosPanionios 31
03 Ago 17 PanioniosPanionios 0 - 1 Maccabi Tel AvivMaccabi 13

  USO DE MEMORIA  
4,718,480 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.1062
Total Execution Time  0.1081
  CADENA URL  
/previa_europa_league2018/grupo3/calendario
  GET DATOS  
$_GET['/previa_europa_league2018/grupo3/calendario']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (19)  
0.0044  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'previa_europa_league' AND (l.group_code = 3 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2018 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=3 DESC LIMIT 1
0.0020  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=674 AND type_rel = 3
0.0054  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 674 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0030  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 (1275465,1275183,1273994,1273871,1272678) ORDER BY n.cover_points DESC, update_date DESC
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 = 38744 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0029  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 calendars2018 c INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE c.league_id = 38744 ORDER BY round ASC
0.0022  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-05-03 05:33:44' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0021  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-05-03 05:33:44' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0021  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-05-03 05:33:44' 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-05-03 05:33:44' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0024  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 674 AND l.year = 2018
0.0047  SELECT e.action, count(e.action) as total, e.player_id FROM events2018 e WHERE e.league_id IN (38742,38743,38744,38745) 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.0035  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 (38742,38743,38744,38745) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (87465,227676,100958,139700,149198,275119,25279,26752,66487,159371) ORDER BY rp.in_squad = 1 DESC
0.0023  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 674 AND l.year = 2018
0.0061  SELECT e.action, count(e.action) as total, e.player_id FROM events2018 e WHERE e.league_id IN (38742,38743,38744,38745) AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10
0.0044  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 (38742,38743,38744,38745) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (4548,66276,173423,214133,231606,15171,29323,58867,66660,69997) ORDER BY rp.in_squad = 1 DESC
0.0022  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 674 AND l.year = 2018
0.0024  SELECT e.action, count(e.action) as total, e.player_id FROM events2018 e WHERE e.league_id IN (38742,38743,38744,38745) AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10
0.0039  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 (38742,38743,38744,38745) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (66276,123199,4548,17727,22390,23400,36339,40831,42175,42248) ORDER BY rp.in_squad = 1 DESC