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

CSD Arzua

Entrenador: Chus Baleato

Temporada 2023/2024

Estadísticas

ENTRA
C. Ponce14
D. Pereiro12
R. De Los Santos11
Mosquera9
Suso Martínez8
A. Rodrigues7
David González7
A. Semedo7
D. García6
A. Seoane6
M. Vilariño5
S. Monterroso5
J. Lewis5
Hugo Chucas3
D. Tyler3
A. Michaylyszyn3
I. Martínez3
M. Scarpari2
Rodri2
L. López1
H. Lautaro1
L. Lareu1
Santi1
B. Fernandez1
M. Iglesias1
L. Rodríguez1
SALE
M. Scarpari14
David González14
Santi9
C. Ponce8
A. Semedo7
Mosquera7
Hugo Chucas6
L. Rodríguez6
M. Vilariño6
H. Lautaro6
A. Michaylyszyn5
D. Pereiro5
Rodri4
Suso Martínez4
Iker4
O. Alonso4
Izan Márquez3
A. Rodrigues3
J. Lewis3
S. Monterroso3
Catú3
R. De Los Santos1

  USO DE MEMORIA  
5,007,552 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.0603
Total Execution Time  0.0615
  CADENA URL  
/estadisticas/Csd-Arzua
  GET DATOS  
$_GET['/estadisticas/Csd-Arzua']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (6)  
0.0020  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=18874 AND type_rel = 2
0.0020  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2470 AND type_rel = 3
0.0028  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 = '18874' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0029  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 = 72260 WHERE rp.league_id = 72260 AND rp.teamId = 18874 AND (e.action = 22) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0059  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 = 72260 WHERE rp.league_id = 72260 AND rp.teamId = 18874 AND (e.action = 19) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0097  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 = 72260 WHERE rp.league_id = 72260 AND rp.teamId = 18874 AND (e.action = 18) GROUP BY p.id ORDER BY total DESC LIMIT 30