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 Mar 23 El FarolitoFarolito 3 - 0 International SFInternation 15
22 Mar 23 West Chester UnitedWest 1 - 3 Ocean City Nor'eastersOcean City 26
23 Mar 23 AppalachianAppalachian 2 - 2 North Carolina Fusion U23North 6
23 Mar 23 ManhattanManhattan 2 - 1 MotownMotown 12
23 Mar 23 Chicago House ACChicago 1 - 0 Bavarian UnitedBavarian 4
23 Mar 23 Beaman United FCBeaman 0 - 3 Des Moines MenaceMoines 1
23 Mar 23 Tulsa AthleticsTulsa 1 - 0 Twin City ToucansTwin City. 3
23 Mar 23 UDA SoccerUDA Soccer 1 - 0 Park City Red WolvesPark City. 1
23 Mar 23 Project 51OProject 0 - 3 Crossfire RedmondCrossfire 5
24 Mar 23 Cleveland SCCleveland 1 - 0 LionsbridgeLionsbridge 27
24 Mar 23 Jacksonville ArmadaJacksonvill 1 - 1 Miami UnitedMiami 14
24 Mar 23 Hartford CityHartford 1 - 2 Lansdowne BhoysLansdowne 8
23 Mar 23 Ventura County FusionVentura 1 - 4 CapoCapo 4
23 Mar 23 Club De Lyon IIClub Lyon 0 - 1 NonaNona 2
Ver jornada
Jornada 2
06 Abr 23 Union OmahaUnion Omaha 2 - 0 El Paso LocomotivePaso ...
06 Abr 23 Fuego FCFuego FC 1 - 3 Monterey BayMonterey ...
05 Abr 23 Detroit CityDetroit 1 - 0 Gold StarGold Star ...
06 Abr 23 Indy ElevenIndy Eleven 3 - 1 Michigan StarsMichigan 7
06 Abr 23 Louisville CityLouisville 1 - 0 LexingtonLexington 3
06 Abr 23 Loudoun UnitedLoudoun 2 - 1 North CarolinaNorth 2
06 Abr 23 Pittsburgh RiverhoundsPittsburgh 1 - 0 Rochester New YorkRochester ...
05 Abr 23 Charleston BatteryCharleston 4 - 1 Savannah CloversSavannah 1
05 Abr 23 San AntonioAntonio 2 - 1 Club De LyonClub Lyon 13
05 Abr 23 One KnoxvilleKnoxville 1 - 2 Memphis 901Memphis 3
06 Abr 23 Chattanooga Red WolvesChattanooga 1 - 4 Birmingham LegionBirmingham ...
06 Abr 23 TormentaTormenta 2 - 1 Rio Grande ValleyGrande 1
06 Abr 23 Colorado Springs SwitchbackColorado 1 - 3 Northern ColoradoNorthern ...
06 Abr 23 Las Vegas LightsVegas 4 - 0 LA ForceLA Force ...
06 Abr 23 San Diego LoyalDiego Loyal 2 - 0 ASC San DiegoDiego 3
06 Abr 23 Phoenix RisingPhoenix 1 - 0 Greenville TriumphGreenville 3
06 Abr 23 Maryland BobcatsMaryland 3 - 2 Ocean City Nor'eastersOcean City 1
12 Abr 23 Forward MadisonForward 2 - 3 Chicago House ACChicago 2
05 Abr 23 Tampa Bay RowdiesTampa 2 - 0 NonaNona 3
05 Abr 23 Flower City UnionFlower City 3 - 1 ManhattanManhattan ...
05 Abr 23 New Mexico UnitedMexico 6 - 0 UDA SoccerUDA Soccer ...
05 Abr 23 Oakland RootsOakland 3 - 1 El FarolitoFarolito 3
06 Abr 23 Charlotte IndependenceCharlotte 2 - 0 AppalachianAppalachian ...
06 Abr 23 Tulsa AthleticsTulsa 1 - 0 FC TulsaFC Tulsa 5
06 Abr 23 Sacramento RepublicSacramento 5 - 4 Crossfire RedmondCrossfire ...
06 Abr 23 Orange County SCOrange 5 - 0 CapoCapo ...
05 Abr 23 Hartford AthleticHartford 3 - 0 Lansdowne BhoysLansdowne ...
05 Abr 23 Miami FCMiami FC 3 - 1 Jacksonville ArmadaJacksonvill 11
07 Abr 23 Richmond KickersRichmond 3 - 2 Cleveland SCCleveland 18
06 Abr 23 Des Moines MenaceMoines 1 - 4 ChattanoogaChattanooga ...
Ver jornada
Jornada 3
26 Abr 23 Charleston BatteryCharleston 1 - 0 Charlotte IndependenceCharlotte 4
26 Abr 23 Pittsburgh RiverhoundsPittsburgh 2 - 0 Maryland BobcatsMaryland 28
27 Abr 23 Birmingham LegionBirmingham 1 - 1 ChattanoogaChattanooga 3
27 Abr 23 Loudoun UnitedLoudoun 5 - 0 Flower City UnionFlower City 3
27 Abr 23 New Mexico UnitedMexico 2 - 1 Phoenix RisingPhoenix 2
27 Abr 23 Sacramento RepublicSacramento 1 - 0 Oakland RootsOakland 2
26 Abr 23 Charlotte FCCharlotte 4 - 1 TormentaTormenta 1
26 Abr 23 Detroit CityDetroit 1 - 3 Minnesota UnitedMinnesota 6
26 Abr 23 Monterey BayMonterey 1 - 0 San Jose EarthquakesJose 89
26 Abr 23 New England RevolutionEngland 2 - 1 Hartford AthleticHartford 12
26 Abr 23 Sporting Kansas CitySporting 3 - 0 Tulsa AthleticsTulsa 1
26 Abr 23 St. Louis CityLouis City 5 - 1 Union OmahaUnion Omaha 3
27 Abr 23 Atlanta UnitedAtlanta 1 - 2 Memphis 901Memphis 17
27 Abr 23 Chicago FireChicago 3 - 0 Chicago House ACChicago 6
27 Abr 23 Colorado RapidsColorado 3 - 1 Northern ColoradoNorthern 2
27 Abr 23 Columbus CrewColumbus 1 - 0 Indy ElevenIndy Eleven 4
27 Abr 23 DC UnitedDC United 1 - 0 Richmond KickersRichmond 18
27 Abr 23 CincinnatiCincinnati 1 - 0 Louisville CityLouisville 77
27 Abr 23 Las Vegas LightsVegas 1 - 3 Real Salt LakeReal Salt. 35
27 Abr 23 Nashville SCNashville 1 - 0 San AntonioAntonio 8
27 Abr 23 Portland TimbersPortland 3 - 1 Orange County SCOrange 20
27 Abr 23 Seattle SoundersSeattle 5 - 4 San Diego LoyalDiego Loyal 25
27 Abr 23 Tampa Bay RowdiesTampa 0 - 1 Houston DynamoHouston 2
27 Abr 23 Miami FCMiami FC 2 - 2 Inter MiamiInter Miami 41
Ver jornada
Jornada 4
11 May 23 Austin FCAustin FC 2 - 0 New Mexico UnitedMexico 3
11 May 23 Houston DynamoHouston 1 - 0 Sporting Kansas CitySporting 9
11 May 23 Birmingham LegionBirmingham 3 - 0 Memphis 901Memphis 6
11 May 23 Nashville SCNashville 2 - 0 FC DallasFC Dallas 8
11 May 23 LA GalaxyLA Galaxy 3 - 1 Seattle SoundersSeattle 64
11 May 23 Portland TimbersPortland 3 - 4 Real Salt LakeReal Salt. 23
10 May 23 Sacramento RepublicSacramento 2 - 4 Colorado RapidsColorado 60
10 May 23 Monterey BayMonterey 2 - 2 Los Angeles FCAngeles 235
11 May 23 Loudoun UnitedLoudoun 1 - 5 Columbus CrewColumbus 8
11 May 23 CincinnatiCincinnati 1 - 0 New York CityYork City 43
10 May 23 New York RBYork 1 - 0 DC UnitedDC United 18
10 May 23 New England RevolutionEngland 0 - 1 Pittsburgh RiverhoundsPittsburgh 50
10 May 23 Charlotte FCCharlotte 1 - 0 Orlando CityOrlando 119
10 May 23 Inter MiamiInter Miami 1 - 0 Charleston BatteryCharleston 39
10 May 23 Chicago FireChicago 2 - 1 St. Louis CityLouis City 37
10 May 23 Minnesota UnitedMinnesota 3 - 3 Philadelphia UnionPhiladelphi 93
Ver jornada
Jornada 5
25 May 23 Austin FCAustin FC 0 - 2 Chicago FireChicago 14
25 May 23 Birmingham LegionBirmingham 1 - 0 Charlotte FCCharlotte 3
25 May 23 Colorado RapidsColorado 0 - 1 Real Salt LakeReal Salt. 15
24 May 23 Inter MiamiInter Miami 2 - 1 Nashville SCNashville 44
24 May 23 Los Angeles FCAngeles 0 - 2 LA GalaxyLA Galaxy 114
24 May 23 New York RBYork 1 - 1 CincinnatiCincinnati 45
25 May 23 Pittsburgh RiverhoundsPittsburgh 1 - 0 Columbus CrewColumbus 20
24 May 23 Houston DynamoHouston 4 - 0 Minnesota UnitedMinnesota 13
Ver jornada
Jornada 6
07 Jun 23 Chicago FireChicago 1 - 4 Houston DynamoHouston 9
07 Jun 23 CincinnatiCincinnati 3 - 1 Pittsburgh RiverhoundsPittsburgh 21
08 Jun 23 Birmingham LegionBirmingham 0 - 1 Inter MiamiInter Miami 62
08 Jun 23 Real Salt LakeReal Salt. 3 - 2 LA GalaxyLA Galaxy 26
Ver jornada
Jornada 7
24 Ago 23 Houston DynamoHouston 3 - 1 Real Salt LakeReal Salt. 92
24 Ago 23 CincinnatiCincinnati 3 - 3 Inter MiamiInter Miami 2k
Ver jornada
Jornada 8
28 Sep 23 Inter MiamiInter Miami 1 - 2 Houston DynamoHouston 844

  USO DE MEMORIA  
4,958,032 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.4163
Total Execution Time  0.4182
  CADENA URL  
/copa_open_usa2023/grupo0/calendario
  GET DATOS  
$_GET['/copa_open_usa2023/grupo0/calendario']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (21)  
0.0125  SELECT type FROM routes WHERE alias = 'copa_open_usa2023'
0.0256  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'copa_open_usa' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2023 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=610 AND type_rel = 3
0.0127  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 610 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0128  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 (1314449,1281610,1281603,1281359,1281329) ORDER BY n.cover_points DESC, update_date DESC
0.0125  SELECT id,name,alias,stepParent FROM categories WHERE parentId=610 ORDER BY order_id ASC
0.0132  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 = 71035 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0137  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 calendars2023 c INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE c.league_id = 71035 ORDER BY round ASC
0.0127  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-05-08 16:46:44' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0127  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-05-08 16:46:44' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0126  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-05-08 16:46:44' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0128  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-05-08 16:46:44' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0133  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 610 AND l.year = 2023
0.0166  SELECT e.action, count(e.action) as total, e.player_id FROM events2023 e WHERE e.league_id IN (71035) 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.0129  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 (71035) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (57918,962273,260742,295581,363440,632550,869380,922893,982205,37933) ORDER BY rp.in_squad = 1 DESC
0.0126  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 610 AND l.year = 2023
0.0132  SELECT e.action, count(e.action) as total, e.player_id FROM events2023 e WHERE e.league_id IN (71035) AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10
0.0128  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 (71035) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (324556,348097,1030311,3132304,3214301,3392153,64748,100455,178732,206011) ORDER BY rp.in_squad = 1 DESC
0.0126  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 610 AND l.year = 2023
0.0126  SELECT e.action, count(e.action) as total, e.player_id FROM events2023 e WHERE e.league_id IN (71035) AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10
0.0128  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 (71035) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (184050,277258,348097,450442,476492,643722,729574,845992,853862,862095) ORDER BY rp.in_squad = 1 DESC