4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Ver jornada
Jornada 1
15 Feb 24 AméricaAmérica 2 - 0 Real EstelíReal 155
29 Feb 24 CincinnatiCincinnati 4 - 0 CavalierCavalier 80
14 Feb 24 Chivas GuadalajaraChivas 2 - 1 ForgeForge 98
28 Feb 24 Houston DynamoHouston 1 - 0 St. Louis CityLouis City 71
16 Feb 24 MonterreyMonterrey 3 - 0 ComunicacionesComunicacio 115
29 Feb 24 Nashville SCNashville 4 - 0 MocaMoca 38
01 Mar 24 New England RevolutionEngland 3 - 0 Independiente ChorreraIndependien 40
28 Feb 24 Orlando CityOrlando 3 - 1 CavalryCavalry 90
28 Feb 24 Philadelphia UnionPhiladelphi 3 - 3 Deportivo SaprissaDeportivo 148
15 Feb 24 Tigres UANLTigres UANL 3 - 0 Vancouver WhitecapsVancouver 124
16 Feb 24 TolucaToluca 2 - 3 CS HeredianoHerediano 319
23 Feb 24 CavalierCavalier 0 - 2 CincinnatiCincinnati 132
22 Feb 24 CavalryCavalry 0 - 3 Orlando CityOrlando 27
07 Feb 24 ComunicacionesComunicacio 1 - 4 MonterreyMonterrey 284
08 Feb 24 ForgeForge 1 - 3 Chivas GuadalajaraChivas 75
08 Feb 24 CS HeredianoHerediano 1 - 2 TolucaToluca 183
22 Feb 24 Independiente ChorreraIndependien 0 - 1 New England RevolutionEngland 26
23 Feb 24 MocaMoca 0 - 3 Nashville SCNashville 33
07 Feb 24 Real EstelíReal 2 - 1 AméricaAmérica 517
21 Feb 24 Deportivo SaprissaDeportivo 2 - 3 Philadelphia UnionPhiladelphi 102
21 Feb 24 St. Louis CityLouis City 2 - 1 Houston DynamoHouston 84
08 Feb 24 Vancouver WhitecapsVancouver 1 - 1 Tigres UANLTigres UANL 328
Ver jornada
Jornada 2
07 Mar 24 Chivas GuadalajaraChivas 0 - 3 AméricaAmérica 397
14 Mar 24 AméricaAmérica 2 - 3 Chivas GuadalajaraChivas 580
05 Mar 24 CS HeredianoHerediano 2 - 0 SV RobinhoodRobinhood 126
13 Mar 24 SV RobinhoodRobinhood 1 - 1 CS HeredianoHerediano 135
06 Mar 24 Philadelphia UnionPhiladelphi 0 - 0 PachucaPachuca 350
06 Mar 24 Orlando CityOrlando 0 - 0 Tigres UANLTigres UANL 182
07 Mar 24 Houston DynamoHouston 0 - 1 Columbus CrewColumbus 161
12 Mar 24 Columbus CrewColumbus 1 - 1 Houston DynamoHouston 167
13 Mar 24 PachucaPachuca 6 - 0 Philadelphia UnionPhiladelphi 200
13 Mar 24 Tigres UANLTigres UANL 4 - 2 Orlando CityOrlando 280
08 Mar 24 CincinnatiCincinnati 0 - 1 MonterreyMonterrey 327
08 Mar 24 Nashville SCNashville 2 - 2 Inter MiamiInter Miami 757
14 Mar 24 Inter MiamiInter Miami 3 - 1 Nashville SCNashville 515
15 Mar 24 MonterreyMonterrey 2 - 1 CincinnatiCincinnati 389
07 Mar 24 New England RevolutionEngland 4 - 0 LD AlajuelenseAlajuelense 60
15 Mar 24 LD AlajuelenseAlajuelense 1 - 1 New England RevolutionEngland 151
Ver jornada
Jornada 3
03 Abr 24 Columbus CrewColumbus 1 - 1 Tigres UANLTigres UANL 221
10 Abr 24 Tigres UANLTigres UANL 1 - 1 Columbus CrewColumbus 260
11 Abr 24 PachucaPachuca 2 - 1 CS HeredianoHerediano 245
04 Abr 24 CS HeredianoHerediano 0 - 5 PachucaPachuca 165
11 Abr 24 MonterreyMonterrey 3 - 1 Inter MiamiInter Miami 1k
10 Abr 24 AméricaAmérica 5 - 2 New England RevolutionEngland 178
04 Abr 24 Inter MiamiInter Miami 1 - 2 MonterreyMonterrey 624
03 Abr 24 New England RevolutionEngland 0 - 4 AméricaAmérica 132
Ver jornada
Jornada 4
25 Abr 24 Columbus CrewColumbus 2 - 1 MonterreyMonterrey 209
01 May 24 PachucaPachuca
03:15
 		AméricaAmérica 8
24 Abr 24 AméricaAmérica 1 - 1 PachucaPachuca 293
02 May 24 MonterreyMonterrey
04:15
 		Columbus CrewColumbus 9

  USO DE MEMORIA  
4,605,640 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0031
Controller Execution Time ( Home / Category )  0.1055
Total Execution Time  0.1086
  CADENA URL  
/liga-de-campeones-concacaf-grupos2024/grupo0/calendario
  GET DATOS  
$_GET['/liga-de-campeones-concacaf-grupos2024/grupo0/calendario']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (17)  
0.0022  SELECT type FROM routes WHERE alias = 'liga-de-campeones-concacaf-grupos2024'
0.0046  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'liga-de-campeones-concacaf-grupos' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2024 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=706 ORDER BY order_id ASC
0.0024  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 calendars2024 c INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE c.league_id = 74866 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-04-27 16:43:32' 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-27 16:43:32' 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-04-27 16:43:32' 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=3 AND last_update > '2024-04-27 16:43:32' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0023  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 706 AND l.year = 2024
0.0021  SELECT e.action, count(e.action) as total, e.player_id FROM events2024 e WHERE e.league_id IN (74866) 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.0031  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 (74866) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (30713,260746,3357,295581,365507,423365,246863,312192,353709,365327) ORDER BY rp.in_squad = 1 DESC
0.0030  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 706 AND l.year = 2024
0.0022  SELECT e.action, count(e.action) as total, e.player_id FROM events2024 e WHERE e.league_id IN (74866) AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10
0.0031  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 (74866) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (28113,260748,353709,480706,29685,125557,161679,194734,232039,272915) ORDER BY rp.in_squad = 1 DESC
0.0024  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 706 AND l.year = 2024
0.0040  SELECT e.action, count(e.action) as total, e.player_id FROM events2024 e WHERE e.league_id IN (74866) AND (e.action = 3 or e.action = 4) 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 (74866) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (28113,38439,130636,146675,367429,696931,822409,829662,3260468) ORDER BY rp.in_squad = 1 DESC