4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Ver
TEMPORADA 2023/2024
Equipo PJ GF GC Puntos
1 Chattanooga Chattanooga 7 14 6 15
2 Philadelphia Union II Philadelphia 6 12 5 14
3 New York RB II York 6 15 11 14
4 Chicago Fire II Chicago Fire 5 11 8 11
5 Inter Miami II Inter Miami 5 12 12 10
6 Orlando City II Orlando City 5 7 6 9
7 New York City II York City 5 11 7 8
8 Cincinnati II Cincinnati 6 10 11 7
9 Columbus Crew II Columbus 5 9 11 7
10 Atlanta United II Atlanta 5 8 12 6
11 Crown Legacy Crown Legacy 5 5 9 5
12 New England Revolution II England 5 7 12 5
13 Toronto II Toronto II 4 5 6 4
14 Huntsville City Huntsville 6 8 11 3
15 Carolina Core Carolina 5 3 10 2
16 LA Galaxy II Galaxy 7 16 10 15
17 Tacoma Defiance Tacoma 7 15 12 14
18 St. Louis II Louis 6 8 5 12
19 Los Angeles FC II Angeles 5 10 7 11
20 North Texas North Texas 5 6 3 11
21 Sporting Kansas City II Sporting 6 14 10 10
22 San Jose Earthquakes II Jose 6 8 7 9
23 Vancouver Whitecaps II Vancouver 5 8 7 7
24 Portland Timbers II Portland 6 9 10 7
25 Austin FC II Austin 5 4 6 5
26 Real Monarchs Real 5 5 9 5
27 Colorado Rapids II Colorado 6 8 15 4
28 Minnesota United II Minnesota 3 6 9 3
29 Houston Dynamo II Houston 4 3 10 0
Ver
TEMPORADA 2022/2023
Equipo PJ GF GC Puntos
1 Crown Legacy Crown Legacy 28 60 34 62
2 Columbus Crew II Columbus 28 58 46 52
3 New England Revolution II England 28 57 41 51
4 New York RB II York 28 53 36 50
5 Orlando City II Orlando City 28 59 61 45
6 Philadelphia Union II Philadelphia 28 54 57 42
7 New York City II York City 28 60 55 40
8 Chicago Fire II Chicago Fire 28 54 46 38
9 Huntsville City Huntsville 28 48 45 37
10 Atlanta United II Atlanta 28 50 52 33
11 Toronto II Toronto II 28 43 57 26
12 Cincinnati II Cincinnati 28 37 65 25
13 Inter Miami II Inter Miami 28 34 68 21
14 Colorado Rapids II Colorado 28 70 37 62
15 Tacoma Defiance Tacoma 28 57 36 53
16 Sporting Kansas City II Sporting 28 60 42 46
17 Austin FC II Austin 28 40 23 46
18 St. Louis II Louis 28 49 39 44
19 San Jose Earthquakes II Jose 28 41 36 41
20 Houston Dynamo II Houston 28 50 44 41
21 Minnesota United II Minnesota 28 50 52 39
22 North Texas North Texas 28 43 45 35
23 Portland Timbers II Portland 28 40 63 34
24 Vancouver Whitecaps II Vancouver 28 36 49 32
25 Real Monarchs Real 28 27 54 29
26 Los Angeles FC II Angeles 28 30 39 25
27 LA Galaxy II Galaxy 28 36 74 22
Ver
TEMPORADA 2021/2022
Equipo PJ GF GC Puntos
1 Columbus Crew II Columbus 24 62 22 55
2 Toronto II Toronto II 24 44 38 41
3 Rochester New York Rochester 24 37 30 40
4 Philadelphia Union II Philadelphia 24 42 39 40
5 New York City II York City 24 49 35 37
6 Inter Miami II Inter Miami 24 40 49 36
7 New England Revolution II England 24 27 42 33
8 Chicago Fire II Chicago Fire 24 41 44 31
9 Orlando City II Orlando City 24 40 53 25
10 Cincinnati II Cincinnati 24 27 65 17
11 St. Louis II Louis 24 51 34 49
12 Houston Dynamo II Houston 24 38 22 47
13 Tacoma Defiance Tacoma 24 57 25 46
14 North Texas North Texas 24 48 31 44
15 San Jose Earthquakes II Jose 24 48 37 40
16 Minnesota United II Minnesota 24 43 39 32
17 Sporting Kansas City II Sporting 24 31 38 30
18 Vancouver Whitecaps II Vancouver 24 40 40 29
19 Colorado Rapids II Colorado 24 33 56 27
20 Real Monarchs Real 24 28 50 22
21 Portland Timbers II Portland 24 29 66 10

  USO DE MEMORIA  
6,024,168 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0027
Controller Execution Time ( Home / Category )  0.3973
Total Execution Time  0.4001
  CADENA URL  
/mls-next-pro2024/grupo1/historico
  GET DATOS  
$_GET['/mls-next-pro2024/grupo1/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (17)  
0.0295  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'mls-next-pro' AND (l.group_code = 1 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=1 DESC LIMIT 1
0.0145  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2602 AND type_rel = 3
0.0145  SELECT id,name,alias,stepParent FROM categories WHERE parentId=2602 ORDER BY order_id ASC
0.0147  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 = 75366 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0146  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 2602 AND group_code = 1 and tables = 1 AND year <= 2024 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
0.0153  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2024` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 75366 AND t.round = 7 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0152  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2023` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 71330 AND t.round = 30 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0150  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2022` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 66829 AND t.round = 25 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0145  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-27 23:48:01' 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 23:48:01' 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=4 AND last_update > '2024-04-27 23:48:01' 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=3 AND last_update > '2024-04-27 23:48:01' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0150  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'mls-next-pro' 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.0188  SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2024 e ON e.player_id = p.id AND e.league_id = 75366 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 75366 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 LIMIT 10
0.0200  SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2024 e ON e.player_id = p.id AND e.league_id = 75366 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 75366 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0149  SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2024 e ON e.player_id = p.id AND e.league_id = 75366 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 75366 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0164  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2024` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 75366 AND t.round = 7 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC