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

Navarro

Entrenador: Davo Sánchez Rivas

Temporada 2023/2024

Estadísticas

ENTRA
J. Díaz18
P. Madera16
A. García12
Yonathan12
C. Okoronkwo11
I. Iglesias9
A. Villaverde8
Jorge7
B. Senghore7
Aramo7
David González5
Sergio5
J. Gonzalez4
O. Barro4
J. Alvarez4
L. Roldan3
Polo2
Dani Lamuño2
Fredo Río2
R. Garcia1
Alonso1
A. Gallego1
SALE
Sergio18
A. García14
Aramo12
Yonathan12
Jorge12
A. Villaverde11
Fredo Río9
O. Barro9
B. Senghore7
P. Madera5
Pablo González5
David González4
I. Iglesias4
J. Díaz4
C. Okoronkwo3
J. Alvarez3
Alonso2
Polo2
Adrián2
Dani Lamuño1
Mateo1
L. Roldan1

  USO DE MEMORIA  
4,991,424 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0013
Controller Execution Time ( Home / Category )  0.2092
Total Execution Time  0.2106
  CADENA URL  
/estadisticas/Navarro
  GET DATOS  
$_GET['/estadisticas/Navarro']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (6)  
0.0293  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 = 73524
0.0144  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1784 AND type_rel = 2
0.0148  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 = '1784' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0148  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 = 73524 WHERE rp.league_id = 73524 AND rp.teamId = 1784 AND (e.action = 22) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0155  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 = 73524 WHERE rp.league_id = 73524 AND rp.teamId = 1784 AND (e.action = 19) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0155  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 = 73524 WHERE rp.league_id = 73524 AND rp.teamId = 1784 AND (e.action = 18) GROUP BY p.id ORDER BY total DESC LIMIT 30