4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Ver jornada
Jornada 1
22 May 21 Roasso KumamotoRoasso 3 - 0 Nippon Bunri UniversityNippon 1
22 May 21 EhimeEhime 1 - 2 ImabariImabari ...
22 May 21 Parceiro NaganoParceiro 3 - 1 Niigata UniversityNiigata ...
22 May 21 Arterivo WakayamaArterivo 3 - 3 Ococias KyotoOcocias ...
22 May 21 GifuGifu 0 - 2 HondaHonda ...
22 May 21 Ryutsu Keizai UniversityRyutsu 2 - 3 YSCCYSCC ...
22 May 21 Iwaki FCIwaki FC 2 - 2 Sony SendaiSony Sendai 1
22 May 21 SagamiharaSagamihara 3 - 1 Komazawa UniversityKomazawa ...
22 May 21 MizushimaMizushima 3 - 1 Baleine ShimonosekiBaleine ...
22 May 21 Minebea MitsumiMinebea 5 - 0 Kawasoe ClubKawasoe ...
22 May 21 Renofa YamaguchiRenofa 1 - 1 Verspah OitaVerspah ...
23 May 21 Fukuyama CityFukuyama 2 - 1 Kagura ShimaneKagura ...
23 May 21 Grulla MoriokaGrulla 13 - 0 OyamaOyama ...
23 May 21 Blaublitz AkitaBlaublitz 1 - 1 Hokkaido TokachiHokkaido ...
23 May 21 Gainare TottoriGainare 4 - 1 FC TokushimaTokushima ...
23 May 21 Kagoshima UnitedKagoshima 4 - 0 MD NagasakiNagasaki ...
23 May 21 Fukuoka Univ.Fukuoka 1 - 3 Okinawa SVOkinawa SV ...
23 May 21 Biwako SeikeiBiwako 0 - 2 Kwansei GakuinKwansei ...
23 May 21 Vanraure HachinoheVanraure 13 - 0 Saruta KogyoSaruta 1
23 May 21 Porvenir AsukaPorvenir 0 - 2 OsakaOsaka ...
23 May 21 Kataller ToyamaKataller 8 - 0 Hokuriku FCHokuriku 1
23 May 21 Suzuka Point GettersSuzuka 2 - 1 FC KariyaFC Kariya ...
05 Jun 21 Tonan MaebashiTonan 1 - 6 Juntendo Univ.Juntendo ...
23 May 21 Fukui UnitedFukui 2 - 1 Aventura KawaguchiAventura ...
23 May 21 Kochi UnitedKochi 1 - 0 Kamatamare SanukiKamatamare ...
26 May 21 Tochigi CityTochigi 9 - 0 Nirasaki AstrosNirasaki ...
Ver jornada
Jornada 2
09 Jun 21 Kawasaki FrontaleKawasaki 1 - 1 Parceiro NaganoParceiro 17
09 Jun 21 JEF UnitedJEF United 1 - 0 Omiya ArdijaOmiya ...
09 Jun 21 Yokohama F. MarinosYokohama 2 - 2 HondaHonda 4
09 Jun 21 Avispa FukuokaAvispa 6 - 0 Kagoshima UnitedKagoshima ...
09 Jun 21 Giravanz KitakyushuGiravanz 0 - 1 SagamiharaSagamihara ...
09 Jun 21 Nagoya GrampusNagoya 5 - 0 MizushimaMizushima 2
09 Jun 21 Shimizu S-PulseShimizu 1 - 0 Fukuyama CityFukuyama ...
09 Jun 21 Vegalta SendaiVegalta 0 - 1 Grulla MoriokaGrulla ...
09 Jun 21 Montedio YamagataMontedio 1 - 2 Verspah OitaVerspah 1
09 Jun 21 Júbilo IwataJúbilo 3 - 0 Hokkaido TokachiHokkaido 1
09 Jun 21 Cerezo OsakaCerezo 2 - 0 Gainare TottoriGainare ...
09 Jun 21 Albirex NiigataAlbirex 4 - 1 Zweigen KanazawaZweigen 2
09 Jun 21 Sagan TosuSagan Tosu 1 - 0 Roasso KumamotoRoasso 1
09 Jun 21 TochigiTochigi 2 - 0 Machida ZelviaMachida 1
09 Jun 21 Consadole SapporoConsadole 5 - 3 Sony SendaiSony Sendai 3
09 Jun 21 V-Varen NagasakiV-Varen 2 - 0 Okinawa SVOkinawa SV 1
09 Jun 21 Matsumoto YamagaMatsumoto 1 - 0 RyūkyūRyūkyū 1
09 Jun 21 Shonan BellmareShonan 0 - 0 OsakaOsaka ...
09 Jun 21 Kyoto SangaKyoto Sanga 3 - 1 ImabariImabari 1
09 Jun 21 Urawa RedsUrawa Reds 1 - 0 Kataller ToyamaKataller 1
09 Jun 21 Tokushima VortisTokushima 2 - 1 Kochi UnitedKochi 1
09 Jun 21 Mito HollyhockMito 0 - 3 Thespa GunmaThespa ...
09 Jun 21 Oita TrinitaOita 3 - 2 Minebea MitsumiMinebea 3
09 Jun 21 Ventforet KofuVentforet 1 - 2 Fukui UnitedFukui 1
16 Jun 21 YokohamaYokohama 1 - 2 Vanraure HachinoheVanraure 11
16 Jun 21 Tokyo VerdyTokyo Verdy 0 - 1 Fagiano OkayamaFagiano 2
16 Jun 21 Vissel KobeVissel Kobe 4 - 0 Suzuka Point GettersSuzuka ...
16 Jun 21 Sanfrecce HiroshimaSanfrecce 1 - 5 Ococias KyotoOcocias 4
16 Jun 21 Kashima AntlersKashima 8 - 1 YSCCYSCC 1
16 Jun 21 Gamba OsakaGamba Osaka 3 - 1 Kwansei GakuinKwansei 3
09 Jun 21 FC TokyoFC Tokyo 1 - 2 Juntendo Univ.Juntendo 1
09 Jun 21 Kashiwa ReysolKashiwa 3 - 0 Tochigi CityTochigi 1
Ver jornada
Jornada 3
21 Jul 21 Kawasaki FrontaleKawasaki 1 - 1 JEF UnitedJEF United 15
07 Jul 21 Shimizu S-PulseShimizu 2 - 1 Grulla MoriokaGrulla ...
07 Jul 21 HondaHonda 1 - 4 Júbilo IwataJúbilo ...
04 Ago 21 Cerezo OsakaCerezo 3 - 2 Albirex NiigataAlbirex 14
07 Jul 21 Sagan TosuSagan Tosu 1 - 0 Avispa FukuokaAvispa ...
07 Jul 21 Consadole SapporoConsadole 1 - 2 V-Varen NagasakiV-Varen 12
07 Jul 21 Kashiwa ReysolKashiwa 1 - 2 Kyoto SangaKyoto Sanga 11
07 Jul 21 Urawa RedsUrawa Reds 1 - 0 SagamiharaSagamihara 1
07 Jul 21 Juntendo Univ.Juntendo 2 - 3 Thespa GunmaThespa ...
07 Jul 21 Oita TrinitaOita 2 - 0 Fukui UnitedFukui ...
07 Jul 21 Ococias KyotoOcocias 1 - 3 Verspah OitaVerspah ...
07 Jul 21 Kashima AntlersKashima 3 - 0 TochigiTochigi 1
18 Ago 21 Gamba OsakaGamba Osaka 2 - 0 Matsumoto YamagaMatsumoto 9
07 Jul 21 Vanraure HachinoheVanraure 1 - 2 Shonan BellmareShonan ...
07 Jul 21 Vissel KobeVissel Kobe 1 - 0 Tokushima VortisTokushima 8
02 Ago 21 Nagoya GrampusNagoya 1 - 0 Fagiano OkayamaFagiano 28
Ver jornada
Jornada 4
18 Ago 21 Cerezo OsakaCerezo 1 - 0 Sagan TosuSagan Tosu 2
18 Ago 21 Kyoto SangaKyoto Sanga 0 - 1 Urawa RedsUrawa Reds 1
18 Ago 21 Nagoya GrampusNagoya 1 - 0 Vissel KobeVissel Kobe 14
18 Ago 21 Thespa GunmaThespa 1 - 2 Oita TrinitaOita 4
18 Ago 21 Kawasaki FrontaleKawasaki 2 - 1 Shimizu S-PulseShimizu 26
18 Ago 21 Verspah OitaVerspah 0 - 1 Júbilo IwataJúbilo 2
18 Ago 21 Kashima AntlersKashima 3 - 1 V-Varen NagasakiV-Varen 20
22 Sep 21 Gamba OsakaGamba Osaka 4 - 1 Shonan BellmareShonan 1
Ver jornada
Jornada 5
27 Oct 21 Gamba OsakaGamba Osaka 0 - 2 Urawa RedsUrawa Reds 10
27 Oct 21 Nagoya GrampusNagoya 0 - 3 Cerezo OsakaCerezo 2
27 Oct 21 Kawasaki FrontaleKawasaki 3 - 1 Kashima AntlersKashima 12
27 Oct 21 Júbilo IwataJúbilo 0 - 2 Oita TrinitaOita 18
Ver jornada
Jornada 6
12 Dic 21 Urawa RedsUrawa Reds 2 - 0 Cerezo OsakaCerezo 25
12 Dic 21 Kawasaki FrontaleKawasaki 1 - 1 Oita TrinitaOita 38
Ver jornada
Jornada 7
19 Dic 21 Urawa RedsUrawa Reds 2 - 1 Oita TrinitaOita 17

  USO DE MEMORIA  
4,910,496 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0018
Controller Execution Time ( Home / Category )  0.0929
Total Execution Time  0.0947
  CADENA URL  
/copa_emperador_japon2021/grupo0/calendario
  GET DATOS  
$_GET['/copa_emperador_japon2021/grupo0/calendario']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (21)  
0.0019  SELECT type FROM routes WHERE alias = 'copa_emperador_japon2021'
0.0042  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 = 2021 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0020  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=653 AND type_rel = 3
0.0023  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 653 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0024  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 (1153879,1081995,1081256,1006244,996635) ORDER BY n.cover_points DESC, update_date DESC
0.0019  SELECT id,name,alias,stepParent FROM categories WHERE parentId=653 ORDER BY order_id ASC
0.0027  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 = 62618 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0028  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 calendars2021 c INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE c.league_id = 62618 ORDER BY round ASC
0.0019  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-24 13:20:50' 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-04-24 13:20:50' 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=4 AND last_update > '2024-04-24 13:20: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-04-24 13:20:50' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0020  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 653 AND l.year = 2021
0.0022  SELECT e.action, count(e.action) as total, e.player_id FROM events2021 e WHERE e.league_id IN (62618) 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.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 (62618) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (205871,318431,229679,230747,319813,386282,694588,1027517,18399,78952) ORDER BY rp.in_squad = 1 DESC
0.0019  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 653 AND l.year = 2021
0.0027  SELECT e.action, count(e.action) as total, e.player_id FROM events2021 e WHERE e.league_id IN (62618) AND (e.action = 4 or e.action = 5) 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 (62618) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (18399,79932,198166,257667,277716,288305,314365,329993,695199,843530) ORDER BY rp.in_squad = 1 DESC
0.0018  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 653 AND l.year = 2021
0.0018  SELECT e.action, count(e.action) as total, e.player_id FROM events2021 e WHERE e.league_id IN (62618) AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10
0.0019  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 (62618) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (79932) ORDER BY rp.in_squad = 1 DESC