4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Atl. San Luis

Atl. San Luis

Entrenador: Gustavo Leal

Temporada 2023/2024

Estadísticas

ASISTENCIAS
Juan Sanabria4
Vitor Ferreira3
R. Chávez2
F. Boli2
Iker Moreno2
L. Bonatini1
J. Villal1
J. Güemez1
ENTRA
Benjamín Galdames10
J. Villal8
J. Castro7
Jürgen Damm7
Tepa González6
R. Chávez4
M. Klimowicz4
F. Boli4
Yan Philipe4
Vitor Ferreira4
David Rodríguez3
Aldo Cruz3
Eduardo Aguila3
O. Macías3
Iker Moreno2
Sébastien Salles2
L. Bonatini1
U. Bilbao1
SALE
Sébastien Salles13
Vitor Ferreira8
L. Bonatini6
M. Klimowicz5
J. Güemez5
J. Castro4
J. Domínguez4
Aldo Cruz4
J. Silva4
R. Chávez3
Benjamín Galdames3
Iker Moreno3
R. Dourado3
U. Bilbao2
Tepa González2
Jürgen Damm2
Juan Sanabria2
David Rodríguez1
F. Boli1
Yan Philipe1

  USO DE MEMORIA  
5,419,632 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0015
Controller Execution Time ( Home / Category )  0.0871
Total Execution Time  0.0886
  CADENA URL  
/estadisticas/San-Luis
  GET DATOS  
$_GET['/estadisticas/San-Luis']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (15)  
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=9133 AND type_rel = 2
0.0027  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 9133 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0025  SELECT /*35 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 (51817,57844,811417,179362,177946) ORDER BY n.cover_points DESC, update_date DESC
0.0051  SELECT SQL_NO_CACHE res.id as id, res.group_code, res.total_group, res.logo, res.alias FROM (SELECT ct.active_year, ct.id as id, l.year, l.end,l.group_code, l.total_group, ct.logo, ct.alias FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId AND ct.active_year=l.year INNER JOIN teams AS t ON l.id=t.league_id WHERE t.teamId = '9133' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0043  SELECT t.id as team_id, ct.id, l.id as idLeague, l.year, ct.name, l.start_date, l.end_date FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId INNER JOIN teams AS t ON l.id=t.league_id WHERE t.teamId=9133 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0024  SELECT ct.id, ct.alias, ct.name AS name, ct.active_year, ct.coefficient AS coefficient, l.id AS league_id, l.year, l.total_group FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId WHERE l.id IN (75358,74881,74558,71994,71572,71432) ORDER BY ct.ctype != 12 DESC, ct.troncal DESC, ct.coefficient DESC, l.end_date >= NOW() DESC, l.start_date <= NOW() DESC, l.year DESC, ct.coefficient DESC, l.group_code ASC
0.0028  SELECT count(id) as num_players from rel_players WHERE league_id = 74881 AND teamId = 9133
0.0056  SELECT count(id) as num_players from rel_players WHERE league_id = 71994 AND teamId = 9133
0.0027  SELECT count(id) as num_players from rel_players WHERE league_id = 74558 AND teamId = 9133
0.0026  SELECT count(id) as num_players from rel_players WHERE league_id = 71572 AND teamId = 9133
0.0018  SELECT count(id) as num_players from rel_players WHERE league_id = 75358 AND teamId = 9133
0.0032  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 9133
0.0043  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id 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 = 74881 WHERE rp.league_id = 74881 AND rp.teamId = 9133 AND (e.action = 22) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0048  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id 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 = 74881 WHERE rp.league_id = 74881 AND rp.teamId = 9133 AND (e.action = 19) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0050  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id 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 = 74881 WHERE rp.league_id = 74881 AND rp.teamId = 9133 AND (e.action = 18) GROUP BY p.id ORDER BY total DESC LIMIT 30