4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Ver jornada
Jornada 1
20 Sep 09 Grulla MoriokaGrulla 2 - 4 Meiji Univ.Meiji Univ. ...
20 Sep 09 Nara ClubNara Club 1 - 0 Saurcos FukuiSaurcos ...
20 Sep 09 Arterivo WakayamaArterivo 2 - 3 Saga HigashiSaga ...
20 Sep 09 Okinawa KariyushiOkinawa 4 - 1 Tokushima Vortis ReserveTokushima ...
20 Sep 09 Ryutsu Keizai UniversityRyutsu 5 - 0 Parafrente YonezawaParafrente ...
20 Sep 09 Minebea MitsumiMinebea 4 - 0 Kumamoto Gakuen UniversityKumamoto ...
20 Sep 09 Vertfee NasuVertfee 0 - 0 Hachinohe UniversityHachinohe ...
20 Sep 09 Arte TakasakiArte 3 - 0 FC KounFC Koun ...
19 Sep 09 Matsumoto YamagaMatsumoto 1 - 0 FC KariyaFC Kariya ...
19 Sep 09 Gifu IIGifu II 1 - 3 Japan Soccer CollegeJapan ...
19 Sep 09 Mie Chukyo UniversityChukyo 0 - 7 HondaHonda ...
19 Sep 09 MizushimaMizushima 0 - 0 Renofa YamaguchiRenofa ...
19 Sep 09 Kamatamare SanukiKamatamare 1 - 0 Tottori Dreams FCTottori ...
19 Sep 09 Blaublitz AkitaBlaublitz 1 - 2 Sony SendaiSony Sendai ...
19 Sep 09 Norbritz HokkaidoNorbritz 0 - 4 Fukuoka Univ.Fukuoka ...
21 Sep 09 National Institute of F&SNational 2 - 0 Hamada FC CosmosHamada ...
21 Sep 09 Ehime FC ReservesEhime 0 - 4 Kochi UniversityKochi ...
20 Sep 09 Zweigen KanazawaZweigen 1 - 0 Kwansei GakuinKwansei ...
20 Sep 09 Valiente KoriyamaValiente 0 - 7 Kansai UniversityKansai ...
20 Sep 09 Fukuyama UniversityFukuyama 0 - 1 V-Varen NagasakiV-Varen ...
20 Sep 09 Tokai University KumamotTokai 1 - 0 Juntendo Univ.Juntendo ...
20 Sep 09 Fukushima UnitedFukushima 0 - 0 Shobi UniversityShobi ...
21 Sep 09 Biwako SeikeiBiwako 0 - 1 Sagawa PrintingSagawa ...
20 Sep 09 Nippon Bunri UniversityNippon 1 - 0 Giravanz KitakyushuGiravanz ...
Ver jornada
Jornada 2
11 Oct 09 Júbilo IwataJúbilo 2 - 0 Kochi UniversityKochi ...
11 Oct 09 Vissel KobeVissel Kobe 5 - 0 Tokai University KumamotTokai ...
11 Oct 09 Shimizu S-PulseShimizu 2 - 0 Sagawa PrintingSagawa ...
11 Oct 09 Matsumoto YamagaMatsumoto 2 - 0 Urawa RedsUrawa Reds ...
11 Oct 09 Kawasaki FrontaleKawasaki 6 - 1 Renofa YamaguchiRenofa ...
11 Oct 09 Tokushima VortisTokushima 1 - 3 National Institute of F&SNational ...
11 Oct 09 Kashiwa ReysolKashiwa 0 - 0 JEF United ReservesUnited ...
11 Oct 09 GifuGifu 1 - 0 TochigiTochigi ...
11 Oct 09 Oita TrinitaOita 3 - 3 Yokogawa MusashinoYokogawa ...
11 Oct 09 Kataller ToyamaKataller 0 - 0 Fagiano OkayamaFagiano ...
10 Oct 09 Sagan TosuSagan Tosu 5 - 0 Saga HigashiSaga ...
10 Oct 09 Thespa GunmaThespa 3 - 1 Sagawa ShigaSagawa ...
10 Oct 09 Kyoto SangaKyoto Sanga 4 - 0 Vertfee NasuVertfee ...
10 Oct 09 FC TokyoFC Tokyo 4 - 0 Kamatamare SanukiKamatamare ...
10 Oct 09 Shonan BellmareShonan 0 - 1 Meiji Univ.Meiji Univ. ...
10 Oct 09 Mito HollyhockMito 2 - 3 Fukuoka Univ.Fukuoka ...
10 Oct 09 Nagoya GrampusNagoya 4 - 0 Okinawa KariyushiOkinawa ...
10 Oct 09 Vegalta SendaiVegalta 1 - 0 Zweigen KanazawaZweigen ...
11 Oct 09 Montedio YamagataMontedio 2 - 0 Nippon Bunri UniversityNippon ...
11 Oct 09 Roasso KumamotoRoasso 2 - 2 YokohamaYokohama ...
11 Oct 09 Gamba OsakaGamba Osaka 5 - 2 Ryutsu Keizai UniversityRyutsu ...
11 Oct 09 EhimeEhime 2 - 2 Avispa FukuokaAvispa ...
11 Oct 09 Tokyo VerdyTokyo Verdy 0 - 1 Minebea MitsumiMinebea ...
11 Oct 09 V-Varen NagasakiV-Varen 0 - 4 Yokohama F. MarinosYokohama ...
11 Oct 09 Nara ClubNara Club 0 - 3 Albirex NiigataAlbirex ...
12 Oct 09 JEF UnitedJEF United 3 - 0 HondaHonda ...
11 Oct 09 Sony SendaiSony Sendai 2 - 4 Omiya ArdijaOmiya ...
11 Oct 09 Consadole SapporoConsadole 2 - 1 Gainare TottoriGainare ...
11 Oct 09 Sanfrecce HiroshimaSanfrecce 5 - 0 Japan Soccer CollegeJapan ...
11 Oct 09 Kashima AntlersKashima 1 - 0 Arte TakasakiArte ...
11 Oct 09 Ventforet KofuVentforet 3 - 3 Kansai UniversityKansai ...
11 Oct 09 Cerezo OsakaCerezo 1 - 2 Fukushima UnitedFukushima ...
Ver jornada
Jornada 3
11 Nov 09 Kawasaki FrontaleKawasaki 3 - 1 Kataller ToyamaKataller ...
11 Nov 09 FC TokyoFC Tokyo 3 - 2 Thespa GunmaThespa ...
01 Nov 09 Nagoya GrampusNagoya 2 - 0 Minebea MitsumiMinebea ...
01 Nov 09 Oita TrinitaOita 2 - 3 JEF UnitedJEF United ...
31 Oct 09 Júbilo IwataJúbilo 3 - 1 National Institute of F&SNational ...
31 Oct 09 Kashima AntlersKashima 3 - 0 Avispa FukuokaAvispa ...
31 Oct 09 Montedio YamagataMontedio 0 - 3 Meiji Univ.Meiji Univ. ...
31 Oct 09 Omiya ArdijaOmiya 1 - 2 Vegalta SendaiVegalta ...
31 Oct 09 Kyoto SangaKyoto Sanga 1 - 2 Ventforet KofuVentforet ...
31 Oct 09 Gamba OsakaGamba Osaka 6 - 1 Fukuoka Univ.Fukuoka ...
31 Oct 09 Shimizu S-PulseShimizu 2 - 0 Consadole SapporoConsadole ...
31 Oct 09 Sanfrecce HiroshimaSanfrecce 2 - 3 Sagan TosuSagan Tosu ...
31 Oct 09 Matsumoto YamagaMatsumoto 1 - 4 GifuGifu ...
31 Oct 09 Albirex NiigataAlbirex 3 - 1 YokohamaYokohama ...
31 Oct 09 Vissel KobeVissel Kobe 1 - 0 Kashiwa ReysolKashiwa ...
01 Nov 09 Yokohama F. MarinosYokohama 4 - 1 Fukushima UnitedFukushima ...
Ver jornada
Jornada 4
15 Nov 09 Yokohama F. MarinosYokohama 1 - 2 Kawasaki FrontaleKawasaki ...
15 Nov 09 GifuGifu 1 - 0 JEF UnitedJEF United ...
15 Nov 09 Meiji Univ.Meiji Univ. 1 - 3 Albirex NiigataAlbirex ...
15 Nov 09 FC TokyoFC Tokyo 0 - 3 Vegalta SendaiVegalta ...
14 Nov 09 Kashima AntlersKashima 2 - 1 Vissel KobeVissel Kobe ...
14 Nov 09 Sagan TosuSagan Tosu 1 - 3 Gamba OsakaGamba Osaka ...
14 Nov 09 Shimizu S-PulseShimizu 3 - 0 Ventforet KofuVentforet ...
15 Nov 09 Nagoya GrampusNagoya 3 - 1 Júbilo IwataJúbilo ...
Ver jornada
Jornada 5
12 Dic 09 Shimizu S-PulseShimizu 3 - 2 Albirex NiigataAlbirex ...
12 Dic 09 Vegalta SendaiVegalta 2 - 1 Kawasaki FrontaleKawasaki ...
12 Dic 09 Kashima AntlersKashima 1 - 2 Gamba OsakaGamba Osaka ...
13 Dic 09 Nagoya GrampusNagoya 3 - 0 GifuGifu ...
Ver jornada
Jornada 6
29 Dic 09 Shimizu S-PulseShimizu 1 - 1 Nagoya GrampusNagoya ...
29 Dic 09 Gamba OsakaGamba Osaka 2 - 1 Vegalta SendaiVegalta ...
Ver jornada
Jornada 7
01 Ene 10 Gamba OsakaGamba Osaka 4 - 1 Nagoya GrampusNagoya ...

  USO DE MEMORIA  
4,911,296 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0029
Controller Execution Time ( Home / Category )  0.4746
Total Execution Time  0.4775
  CADENA URL  
/copa_emperador_japon2009/grupo0/calendario
  GET DATOS  
$_GET['/copa_emperador_japon2009/grupo0/calendario']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (21)  
0.0145  SELECT type FROM routes WHERE alias = 'copa_emperador_japon2009'
0.0293  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 = 2009 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0146  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=653 AND type_rel = 3
0.0149  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.0157  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.0150  SELECT id,name,alias,stepParent FROM categories WHERE parentId=653 ORDER BY order_id ASC
0.0166  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 = 24067 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0185  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 calendars2009 c INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE c.league_id = 24067 ORDER BY round ASC
0.0144  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-27 15:35:43' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0145  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-27 15:35:43' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0146  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-27 15:35:43' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0144  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-27 15:35:43' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0148  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 653 AND l.year = 2009
0.0155  SELECT e.action, count(e.action) as total, e.player_id FROM events2009 e WHERE e.league_id IN (24067) 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.0150  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 (24067) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (18086,18629,167926,2241,18068,121277,129630,129967,214838,17343) ORDER BY rp.in_squad = 1 DESC
0.0149  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 653 AND l.year = 2009
0.0157  SELECT e.action, count(e.action) as total, e.player_id FROM events2009 e WHERE e.league_id IN (24067) AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10
0.0149  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 (24067) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (17343,18061,18086,78966,131408,137461,168671,170312,386216,575164) ORDER BY rp.in_squad = 1 DESC
0.0149  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 653 AND l.year = 2009
0.0164  SELECT e.action, count(e.action) as total, e.player_id FROM events2009 e WHERE e.league_id IN (24067) AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10
0.0149  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 (24067) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (10934,17343,129843,575164) ORDER BY rp.in_squad = 1 DESC