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

Rangers FC

Entrenador: Philippe Clement

Temporada 2023/2024

Estadísticas

GOLEADORES
Thomas Lawrence1
Dujon Sterling1
AMARILLAS
Dujon Sterling1
R. Yilmaz1
J. Butland1
C. Goldson1

Estadísticas

ASISTENCIAS
M. Diomandé1
ENTRA
K. Roofe2
N. Raskin2
R. Mccausland1
T. Cantwell1
Ryan Jack1
Rabbi Matondo1
C. Mckinnon1
SALE
Thomas Lawrence2
C. Dessers2
M. Diomandé2
Fábio Silva1
Dujon Sterling1
S. Wright1

  USO DE MEMORIA  
6,480,344 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.1523
Total Execution Time  0.1535
  CADENA URL  
/estadisticas/Glasgow-Rangers-Fc
  GET DATOS  
$_GET['/estadisticas/Glasgow-Rangers-Fc']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (4)  
0.0175  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 = '1241' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0144  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 = 74791 WHERE rp.league_id = 74791 AND rp.teamId = 1241 AND (e.action = 22) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0146  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 = 74791 WHERE rp.league_id = 74791 AND rp.teamId = 1241 AND (e.action = 19) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0145  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 = 74791 WHERE rp.league_id = 74791 AND rp.teamId = 1241 AND (e.action = 18) GROUP BY p.id ORDER BY total DESC LIMIT 30