4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Jornada 1
25 May 19 Minebea MitsumiMinebea 5 - 1 FC TokushimaTokushima ...
25 May 19 Tochigi CityTochigi 0 - 2 Vanraure HachinoheVanraure ...
25 May 19 Kagura ShimaneKagura 2 - 2 Kamatamare SanukiKamatamare ...
25 May 19 Fukui UnitedFukui 2 - 4 HondaHonda ...
25 May 19 Iwaki FCIwaki FC 2 - 3 Sendai UniversitySendai ...
25 May 19 Arterivo WakayamaArterivo 3 - 0 Saga LIXIL FCSaga LIXIL ...
25 May 19 Thespa GunmaThespa 1 - 0 Tokyo Int. UniversityTokyo Int. ...
25 May 19 Toin University of YokohamaToin 8 - 0 Yamagata UniversityYamagata ...
25 May 19 Reilac ShigaReilac 0 - 2 OsakaOsaka ...
26 May 19 Blaublitz AkitaBlaublitz 0 - 3 Meiji Univ.Meiji Univ. ...
26 May 19 Parceiro NaganoParceiro 1 - 1 Niigata UniversityNiigata ...
26 May 19 UrayasuUrayasu 0 - 1 Hosei UniversityHosei ...
26 May 19 Veertien KuwanaVeertien 3 - 2 Kwansei GakuinKwansei ...
26 May 19 MD NagasakiNagasaki 0 - 1 Kochi UnitedKochi ...
26 May 19 Hokkaido UniversityHokkaido 0 - 2 Ryutsu Keizai UniversityRyutsu ...
26 May 19 Nara ClubNara Club 1 - 2 Ritsumeikan UniversityRitsumeikan ...
26 May 19 Matsuyama UniversityMatsuyama 0 - 2 Okinawa SVOkinawa SV ...
26 May 19 Gainare TottoriGainare 2 - 2 Pacific UniversityPacific ...
26 May 19 Giravanz KitakyushuGiravanz 6 - 0 Tokuyama UniversityTokuyama ...
26 May 19 Gifu Kyoritsu UniversityGifu 2 - 4 Hokuriku FCHokuriku ...
26 May 19 Roasso KumamotoRoasso 2 - 0 Verspah OitaVerspah ...
26 May 19 Grulla MoriokaGrulla 1 - 0 Yamanashi GakuinYamanashi ...
26 May 19 Kataller ToyamaKataller 2 - 0 FC KariyaFC Kariya ...
26 May 19 SRC HiroshimaHiroshima 1 - 2 Institute of FitnessInstitute ...
Jornada 2
03 Jul 19 Sanfrecce HiroshimaSanfrecce 4 - 0 Okinawa SVOkinawa SV ...
03 Jul 19 Kawasaki FrontaleKawasaki 1 - 0 Meiji Univ.Meiji Univ. 1
03 Jul 19 JEF UnitedJEF United 0 - 3 Fagiano OkayamaFagiano 1
03 Jul 19 Júbilo IwataJúbilo 5 - 2 Minebea MitsumiMinebea ...
03 Jul 19 Matsumoto YamagaMatsumoto 2 - 3 Vanraure HachinoheVanraure ...
03 Jul 19 Shimizu S-PulseShimizu 1 - 0 Parceiro NaganoParceiro 3
03 Jul 19 Avispa FukuokaAvispa 2 - 1 Kagoshima UnitedKagoshima 4
03 Jul 19 Gamba OsakaGamba Osaka 7 - 1 Kamatamare SanukiKamatamare 3
03 Jul 19 Consadole SapporoConsadole 2 - 4 HondaHonda 1
03 Jul 19 Tokushima VortisTokushima 0 - 0 EhimeEhime 1
03 Jul 19 V-Varen NagasakiV-Varen 2 - 1 Kochi UnitedKochi ...
03 Jul 19 Urawa RedsUrawa Reds 2 - 1 Ryutsu Keizai UniversityRyutsu ...
03 Jul 19 Mito HollyhockMito 1 - 0 Kyoto SangaKyoto Sanga 1
03 Jul 19 Yokohama F. MarinosYokohama 2 - 1 Ritsumeikan UniversityRitsumeikan 1
03 Jul 19 Zweigen KanazawaZweigen 1 - 0 Albirex NiigataAlbirex 1
03 Jul 19 Nagoya GrampusNagoya 0 - 3 Institute of FitnessInstitute ...
03 Jul 19 Oita TrinitaOita 4 - 1 Gainare TottoriGainare ...
03 Jul 19 Renofa YamaguchiRenofa 2 - 1 RyūkyūRyūkyū 1
03 Jul 19 Vissel KobeVissel Kobe 4 - 0 Giravanz KitakyushuGiravanz 2
03 Jul 19 Omiya ArdijaOmiya 2 - 1 Thespa GunmaThespa ...
03 Jul 19 Kashima AntlersKashima 3 - 1 Hokuriku FCHokuriku ...
03 Jul 19 Montedio YamagataMontedio 1 - 2 TochigiTochigi 1
03 Jul 19 Sagan TosuSagan Tosu 1 - 1 Roasso KumamotoRoasso 2
03 Jul 19 Kashiwa ReysolKashiwa 4 - 0 Grulla MoriokaGrulla ...
03 Jul 19 FC TokyoFC Tokyo 1 - 0 Toin University of YokohamaToin ...
03 Jul 19 Ventforet KofuVentforet 2 - 2 GifuGifu 2
03 Jul 19 Vegalta SendaiVegalta 4 - 1 OsakaOsaka ...
03 Jul 19 Machida ZelviaMachida 0 - 1 Kataller ToyamaKataller ...
03 Jul 19 Shonan BellmareShonan 0 - 4 Veertien KuwanaVeertien ...
10 Jul 19 Tokyo VerdyTokyo Verdy 0 - 2 Hosei UniversityHosei 4
10 Jul 19 YokohamaYokohama 2 - 1 Sendai UniversitySendai 1
10 Jul 19 Cerezo OsakaCerezo 3 - 1 Arterivo WakayamaArterivo 8
Jornada 3
14 Ago 19 Vegalta SendaiVegalta 1 - 0 Kataller ToyamaKataller 9
14 Ago 19 Kawasaki FrontaleKawasaki 2 - 1 Fagiano OkayamaFagiano 1
14 Ago 19 Júbilo IwataJúbilo 6 - 0 Vanraure HachinoheVanraure ...
14 Ago 19 Shimizu S-PulseShimizu 1 - 0 Avispa FukuokaAvispa 2
14 Ago 19 HondaHonda 2 - 0 Tokushima VortisTokushima 2
14 Ago 19 Veertien KuwanaVeertien 2 - 2 V-Varen NagasakiV-Varen ...
14 Ago 19 Urawa RedsUrawa Reds 2 - 1 Mito HollyhockMito 2
14 Ago 19 Yokohama F. MarinosYokohama 2 - 1 YokohamaYokohama 2
14 Ago 19 Sanfrecce HiroshimaSanfrecce 2 - 1 Zweigen KanazawaZweigen ...
14 Ago 19 Institute of FitnessInstitute 1 - 2 Oita TrinitaOita 2
14 Ago 19 Cerezo OsakaCerezo 3 - 0 Renofa YamaguchiRenofa 1
14 Ago 19 Vissel KobeVissel Kobe 4 - 0 Omiya ArdijaOmiya 10
14 Ago 19 Kashima AntlersKashima 4 - 0 TochigiTochigi 1
14 Ago 19 Sagan TosuSagan Tosu 1 - 0 Kashiwa ReysolKashiwa 4
14 Ago 19 FC TokyoFC Tokyo 0 - 1 Ventforet KofuVentforet 15
14 Ago 19 Gamba OsakaGamba Osaka 0 - 2 Hosei UniversityHosei 3
Jornada 4
18 Sep 19 Vissel KobeVissel Kobe 3 - 2 Kawasaki FrontaleKawasaki 3
18 Sep 19 Sanfrecce HiroshimaSanfrecce 1 - 1 Oita TrinitaOita 4
18 Sep 19 Sagan TosuSagan Tosu 4 - 2 Cerezo OsakaCerezo 3
18 Sep 19 Júbilo IwataJúbilo 1 - 1 Shimizu S-PulseShimizu 2
18 Sep 19 V-Varen NagasakiV-Varen 2 - 1 Vegalta SendaiVegalta 3
18 Sep 19 Ventforet KofuVentforet 2 - 1 Hosei UniversityHosei 4
25 Sep 19 Kashima AntlersKashima 4 - 1 Yokohama F. MarinosYokohama 6
25 Sep 19 Urawa RedsUrawa Reds 0 - 2 HondaHonda 10
Jornada 5
23 Oct 19 Vissel KobeVissel Kobe 1 - 0 Oita TrinitaOita 1
23 Oct 19 Sagan TosuSagan Tosu 0 - 1 Shimizu S-PulseShimizu 1
23 Oct 19 Kashima AntlersKashima 1 - 0 HondaHonda 9
23 Oct 19 V-Varen NagasakiV-Varen 2 - 1 Ventforet KofuVentforet ...
Jornada 6
21 Dic 19 Vissel KobeVissel Kobe 3 - 1 Shimizu S-PulseShimizu 4
21 Dic 19 Kashima AntlersKashima 3 - 2 V-Varen NagasakiV-Varen ...
Jornada 7
01 Ene 20 Vissel KobeVissel Kobe 2 - 0 Kashima AntlersKashima 131

  USO DE MEMORIA  
4,882,016 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0018
Controller Execution Time ( Home / Category )  0.0846
Total Execution Time  0.0865
  CADENA URL  
/copa_emperador_japon2019/grupo0/calendario
  GET DATOS  
$_GET['/copa_emperador_japon2019/grupo0/calendario']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (18)  
0.0017  SELECT type FROM routes WHERE alias = 'copa_emperador_japon2019'
0.0040  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'copa_emperador_japon' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2019 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0018  SELECT id,name,alias,stepParent FROM categories WHERE parentId=653 ORDER BY order_id ASC
0.0023  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 = 49698 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0025  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 calendars2019 c INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE c.league_id = 49698 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-01 20:24:50' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0020  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-05-01 20:24:50' 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-01 20:24:50' 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-01 20:24:50' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0019  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 653 AND l.year = 2019
0.0028  SELECT e.action, count(e.action) as total, e.player_id FROM events2019 e WHERE e.league_id IN (49698) 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.0022  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 (49698) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (318138,125492,101192,129974,137035,382159,448584,18475,21333,70395) ORDER BY rp.in_squad = 1 DESC
0.0019  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 653 AND l.year = 2019
0.0020  SELECT e.action, count(e.action) as total, e.player_id FROM events2019 e WHERE e.league_id IN (49698) AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10
0.0021  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 (49698) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (129630,152997,48809,78956,114467,122265,129710,129759,129993,131399) ORDER BY rp.in_squad = 1 DESC
0.0018  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 653 AND l.year = 2019
0.0018  SELECT e.action, count(e.action) as total, e.player_id FROM events2019 e WHERE e.league_id IN (49698) AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10
0.0020  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 (49698) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (129630) ORDER BY rp.in_squad = 1 DESC