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

Urawa Reds

Entrenador: Per-Mathias Högmo

Temporada 2023/2024

Estadísticas

ASISTENCIAS
Ken Iwao2
S. Gustafson2
H. Sakai2
Yota Sato1
S. Nakajima1
N. Maeda1
ENTRA
S. Koroki7
S. Nakajima7
Ken Iwao4
Y. Matsuo4
A. Ohata4
T. Okubo3
Kaito Yasui3
Y. Koizumi2
Yota Sato2
Thiago Santana2
T. Takahashi1
N. Maeda1
H. Ishihara1
SALE
Atsuki Ito7
N. Maeda6
Thiago Santana5
Y. Koizumi4
Y. Matsuo4
T. Okubo2
Ken Iwao2
T. Sekine2
S. Koroki2
A. Scholz2
H. Sakai1
R. Watanabe1
A. Ohata1
S. Gustafson1
S. Nakajima1

  USO DE MEMORIA  
5,523,848 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.1086
Total Execution Time  0.1098
  CADENA URL  
/estadisticas/Urawa-Reds
  GET DATOS  
$_GET['/estadisticas/Urawa-Reds']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (21)  
0.0042  SELECT c.*, l.*, cou.name as namec, ct.table_sufix FROM (leagues l INNER JOIN categories c ON c.id = l.categoryId INNER JOIN categories_types ct ON c.ctype=ct.id LEFT JOIN country cou ON cou.Code2 = c.CountryCode) WHERE l.id = 72218
0.0045  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 = '4522' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0020  SELECT t.id,t.teamId,t.total_players,dt.nameShow,dt.basealias FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 72329 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0018  SELECT t.id,t.teamId,t.total_players,dt.nameShow,dt.basealias FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 73689 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0025  SELECT t.id,t.teamId,t.total_players,dt.nameShow,dt.basealias FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 72218 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0054  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=4522 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0020  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 (75185,74986,73689,72329,72218,71686,67320) 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.0025  SELECT count(id) as num_players from rel_players WHERE league_id = 74986 AND teamId = 4522
0.0023  SELECT count(id) as num_players from rel_players WHERE league_id = 72218 AND teamId = 4522
0.0027  SELECT count(id) as num_players from rel_players WHERE league_id = 75185 AND teamId = 4522
0.0028  SELECT count(id) as num_players from rel_players WHERE league_id = 71686 AND teamId = 4522
0.0024  SELECT count(id) as num_players from rel_players WHERE league_id = 73689 AND teamId = 4522
0.0025  SELECT count(id) as num_players from rel_players WHERE league_id = 72329 AND teamId = 4522
0.0162  SELECT count(id) as num_players from rel_players WHERE league_id = 67320 AND teamId = 4522
0.0035  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 = 74986 WHERE rp.league_id = 74986 AND rp.teamId = 4522 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.0032  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 = 74986 WHERE rp.league_id = 74986 AND rp.teamId = 4522 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0024  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 = 74986 WHERE rp.league_id = 74986 AND rp.teamId = 4522 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0031  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 = 74986 WHERE rp.league_id = 74986 AND rp.teamId = 4522 AND (e.action = 22) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0038  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 = 74986 WHERE rp.league_id = 74986 AND rp.teamId = 4522 AND (e.action = 19) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0034  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 = 74986 WHERE rp.league_id = 74986 AND rp.teamId = 4522 AND (e.action = 18) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0020  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 = 74986 ORDER BY nameShow LIMIT 100