Ver
TEMPORADA 2021/2022
Equipo PJ GF GC Puntos
1 Tigres UANL Tigres UANL 17 52 7 47
2 Monterrey Monterrey 17 45 10 44
3 Atlas Atlas 17 30 16 36
4 Guadalajara Guadalajara 17 35 17 33
5 América América 17 33 19 31
6 Santos Laguna Santos 17 37 26 30
7 Tijuana Tijuana 17 30 19 30
8 Cruz Azul Cruz Azul 17 15 28 24
9 Pachuca Pachuca 17 28 24 23
10 UNAM UNAM 17 19 16 21
11 Puebla Puebla 17 18 30 18
12 Toluca Toluca 17 13 27 18
13 Necaxa Necaxa 17 16 34 18
14 Querétaro Querétaro 17 19 23 16
15 León León 17 18 30 14
16 Atl. San Luis Atl. Luis 17 14 32 13
17 Mazatlán Mazatlán 17 6 40 6
18 FC Juárez FC Juárez 17 11 41 5
Ver
TEMPORADA 2020/2021
Equipo PJ GF GC Puntos
1 Tigres UANL Tigres UANL 17 50 11 46
2 Atlas Atlas 17 45 18 41
3 Monterrey Monterrey 17 41 19 41
4 Guadalajara Guadalajara 17 42 17 38
5 América América 17 35 12 37
6 UNAM UNAM 17 25 15 27
7 Querétaro Querétaro 17 24 20 26
8 Pachuca Pachuca 17 24 25 24
9 Santos Laguna Santos 17 17 20 21
10 Mazatlán Mazatlán 17 14 39 21
11 Atl. San Luis Atl. Luis 17 22 30 17
12 Puebla Puebla 17 12 23 17
13 León León 17 21 31 16
14 Cruz Azul Cruz Azul 17 14 24 14
15 Toluca Toluca 17 16 29 13
16 Tijuana Tijuana 17 16 31 12
17 FC Juárez FC Juárez 17 13 44 11
18 Necaxa Necaxa 17 10 33 10
Ver
TEMPORADA 2019/2020
Equipo PJ GF GC Puntos
1 Monterrey Monterrey 18 52 16 48
2 Tigres UANL Tigres UANL 18 41 14 43
3 Pachuca Pachuca 18 42 24 36
4 América América 18 29 17 32
5 Guadalajara Guadalajara 18 30 23 31
6 Toluca Toluca 18 24 20 31
7 Tijuana Tijuana 18 27 21 29
8 Atlas Atlas 18 35 20 28
9 Morelia Morelia 18 30 28 28
10 Cruz Azul Cruz Azul 18 28 25 24
11 León León 18 23 21 23
12 Puebla Puebla 18 16 25 21
13 Querétaro Querétaro 18 15 32 20
14 UNAM UNAM 18 18 16 19
15 Veracruz Veracruz 18 17 29 17
16 Santos Laguna Santos 18 17 28 16
17 Atl. San Luis Atl. Luis 18 11 38 11
18 FC Juárez FC Juárez 18 8 37 7
19 Necaxa Necaxa 18 6 35 6
Ver
TEMPORADA 2018/2019
Equipo PJ GF GC Puntos
1 Pachuca Pachuca 16 31 14 38
2 América América 16 28 12 35
3 Toluca Toluca 16 37 17 30
4 UNAM UNAM 16 17 11 27
5 Puebla Puebla 16 25 12 25
6 Lobos Lobos 16 18 28 14
7 Veracruz Veracruz 16 14 35 13
8 Cruz Azul Cruz Azul 16 13 36 11
9 Tijuana Tijuana 16 10 28 9
10 Tigres UANL Tigres UANL 16 51 19 40
11 Guadalajara Guadalajara 16 30 16 31
12 Monterrey Monterrey 16 38 15 30
13 Atlas Atlas 16 28 13 29
14 León León 16 20 21 22
15 Querétaro Querétaro 16 16 32 17
16 Morelia Morelia 16 15 34 13
17 Santos Laguna Santos 16 14 34 7
18 Necaxa Necaxa 16 5 33 7
Ver
TEMPORADA 2017/2018
Equipo PJ GF GC Puntos
1 América América 14 48 11 35
2 Pachuca Pachuca 14 36 16 30
3 Toluca Toluca 14 26 16 26
4 UNAM UNAM 14 24 15 21
5 Tijuana Tijuana 14 17 19 19
6 Morelia Morelia 14 10 29 16
7 Cruz Azul Cruz Azul 14 9 37 8
8 Veracruz Veracruz 14 8 35 2
9 Tigres UANL Tigres UANL 14 51 7 34
10 Guadalajara Guadalajara 14 33 10 34
11 Monterrey Monterrey 14 38 17 31
12 Atlas Atlas 14 24 29 20
13 Querétaro Querétaro 14 19 29 17
14 Necaxa Necaxa 14 8 22 10
15 León León 14 18 42 10
16 Santos Laguna Santos 14 11 46 5
Uso de cookies: Utilizamos "cookies" propias y de terceros para mejorar nuestros servicios, elaborar información estadística, analizar sus hábitos de navegación e inferir grupos de interés. Esto nos permite personalizar el contenido que ofrecemos y mostrarle publicidad relacionada con sus preferencias. Adicionalmente, compartimos los análisis de navegación y los grupos de interés inferidos con terceros. Si continúa navegando acepta su uso. Más información y cambio de configuración. Aceptar

  USO DE MEMORIA  
5,745,736 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0025
Controller Execution Time ( Home / Category )  0.0942
Total Execution Time  0.0967
  CADENA URL  
/liga_mx_femenil_apertura2022/grupo1/historico
  GET DATOS  
$_GET['/liga_mx_femenil_apertura2022/grupo1/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (22)  
0.0018  SELECT type FROM routes WHERE alias = 'liga_mx_femenil_apertura2022'
0.0041  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'liga_mx_femenil_apertura' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2022 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0020  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2035 AND type_rel = 3
0.0024  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 2035 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0022  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 (1296022,1296054,1295986,1294189,1292881) ORDER BY n.cover_points DESC, update_date DESC
0.0017  SELECT id,name,alias,stepParent FROM categories WHERE parentId=2035 ORDER BY order_id ASC
0.0019  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 = 63293 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0020  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 2035 AND group_code = 1 and tables = 1 AND year <= 2022 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
0.0026  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 = 63293 AND t.round = 17 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0021  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 `tables2021` 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 = 56985 AND t.round = 17 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023  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 `tables2020` 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 = 50220 AND t.round = 19 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  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 `tables2019` 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 = 44173 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023  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 `tables2018` 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 = 43301 AND t.round = 14 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-03-28 12:19:43' 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=2 AND last_update > '2024-03-28 12:19:43' 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-03-28 12:19:43' 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-03-28 12:19:43' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0023  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'liga_mx_femenil_apertura' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2022 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0089  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 events2022 e ON e.player_id = p.id AND e.league_id = 63293 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 63293 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.0076  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 events2022 e ON e.player_id = p.id AND e.league_id = 63293 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 63293 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0024  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 events2022 e ON e.player_id = p.id AND e.league_id = 63293 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 63293 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0047  SELECT *,(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 = 63293 AND t.round = 17 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC