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 Tigres UANL Tigres UANL 17 51 11 44
2 América América 17 65 23 42
3 Guadalajara Guadalajara 17 40 11 40
4 Monterrey Monterrey 17 41 13 38
5 Tijuana Tijuana 17 35 21 34
6 Toluca Toluca 17 28 26 30
7 Pachuca Pachuca 17 42 28 28
8 UNAM UNAM 17 37 27 26
9 FC Juárez FC Juárez 17 28 23 26
10 León León 17 20 30 23
11 Cruz Azul Cruz Azul 17 25 32 22
12 Querétaro Querétaro 17 25 28 21
13 Atlas Atlas 17 20 32 18
14 Puebla Puebla 17 19 42 14
15 Atl. San Luis Atl. Luis 17 17 34 12
16 Necaxa Necaxa 17 10 44 8
17 Santos Laguna Santos 17 12 51 5
18 Mazatlán Mazatlán 17 12 51 2
Ver
TEMPORADA 2022/2023
Equipo PJ GF GC Puntos
1 Guadalajara Guadalajara 17 36 10 43
2 Monterrey Monterrey 17 46 16 42
3 Tigres UANL Tigres UANL 17 48 13 38
4 América América 17 37 16 36
5 Tijuana Tijuana 17 34 25 29
6 Toluca Toluca 17 27 29 26
7 Pachuca Pachuca 17 35 25 25
8 Cruz Azul Cruz Azul 17 16 16 25
9 UNAM UNAM 17 30 36 24
10 Atlas Atlas 17 25 25 23
11 FC Juárez FC Juárez 17 24 28 22
12 León León 17 22 26 21
13 Atl. San Luis Atl. Luis 17 23 36 21
14 Santos Laguna Santos 17 24 36 19
15 Querétaro Querétaro 17 16 31 12
16 Puebla Puebla 17 20 38 11
17 Mazatlán Mazatlán 17 15 49 11
18 Necaxa Necaxa 17 12 35 8
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 MEMORIA  
6,026,864 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0031
Controller Execution Time ( Home / Category )  0.4569
Total Execution Time  0.4601
  CADENA URL  
/liga_mx_femenil_apertura2024/grupo1/historico
  GET DATOS  
$_GET['/liga_mx_femenil_apertura2024/grupo1/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (24)  
0.0126  SELECT type FROM routes WHERE alias = 'liga_mx_femenil_apertura2024'
0.0257  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 = 2024 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2035 AND type_rel = 3
0.0131  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.0132  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.0128  SELECT id,name,alias,stepParent FROM categories WHERE parentId=2035 ORDER BY order_id ASC
0.0133  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 = 72357 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0130  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 2035 AND group_code = 1 and tables = 1 AND year <= 2024 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
0.0143  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 = 72357 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.0143  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 = 67918 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.0145  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.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 `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.0128  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.0129  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.0143  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.0130  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-27 13:39:07' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0130  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-27 13:39:07' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0130  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-27 13:39:07' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0129  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-27 13:39:07' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0132  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 = 2024 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0220  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 = 72357 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 72357 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.0192  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 = 72357 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 72357 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0135  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 = 72357 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 72357 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0136  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 = 72357 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