4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Chivas Guadalajara

Chivas Guadalajara

Entrenador: Fernando Gago

Temporada 2023/2024

Estadísticas

ASISTENCIAS
R. Alvarado5
V. Guzmán1
F. Beltrán1
Antonio Briseño1
Armando González1
E. Gutiérrez1
P. Pérez1
A. Mozo1
Yael Padilla1
ENTRA
Yael Padilla7
R. González7
Antonio Briseño6
Cade Cowell6
R. Marín4
Alan Torres4
J. Macías3
José Castillo3
Armando González3
Mateo Chávez3
Leonardo Sepúlveda3
Gael García2
Chicharito2
I. Brizuela2
C. Cisneros2
Ronaldo Cisneros2
F. Beltrán1
A. Mozo1
Raúl Martínez1
E. Gutiérrez1
J. Sánchez1
P. Pérez1
V. Guzmán1
SALE
F. Beltrán9
V. Guzmán8
P. Pérez8
Cade Cowell7
R. Marín6
Mateo Chávez5
R. Alvarado4
J. Macías3
Chicharito3
I. Brizuela3
José Castillo2
Leonardo Sepúlveda2
J. Sánchez1
R. González1
G. Sepúlveda1
A. Mozo1
Jesús Orozco1
E. Gutiérrez1

  USO DE MEMORIA  
5,853,656 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0014
Controller Execution Time ( Home / Category )  0.4007
Total Execution Time  0.4021
  CADENA URL  
/estadisticas/guadalajara
  GET DATOS  
$_GET['/estadisticas/guadalajara']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (18)  
0.0164  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 = '1262' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0158  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=1262 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0146  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 (75359,74881,74866,74558,71994,71572,71432,67829) 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.0157  SELECT count(id) as num_players from rel_players WHERE league_id = 74881 AND teamId = 1262
0.0159  SELECT count(id) as num_players from rel_players WHERE league_id = 71994 AND teamId = 1262
0.0156  SELECT count(id) as num_players from rel_players WHERE league_id = 74558 AND teamId = 1262
0.0151  SELECT count(id) as num_players from rel_players WHERE league_id = 71572 AND teamId = 1262
0.0151  SELECT count(id) as num_players from rel_players WHERE league_id = 74866 AND teamId = 1262
0.0145  SELECT count(id) as num_players from rel_players WHERE league_id = 75359 AND teamId = 1262
0.0155  SELECT count(id) as num_players from rel_players WHERE league_id = 67829 AND teamId = 1262
0.0240  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 1262
0.0169  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 = 1262 AND (e.action = 1 or e.action = 2 or e.action = 11 or e.action = 12 or e.action = 13) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0168  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 = 1262 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0163  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 = 1262 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0164  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 = 1262 AND (e.action = 22) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0167  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 = 1262 AND (e.action = 19) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0166  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 = 1262 AND (e.action = 18) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0147  SELECT dt.nameShow, dt.basealias, t.id, dt.id as dt_id FROM `teams` as t INNER JOIN `datateams` as dt ON dt.id = t.teamId WHERE league_id = 74881 ORDER BY nameShow LIMIT 100