4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del El Espinar-San Rafael

Estadísticas

ENTRA
Adrián Santos13
Javier Romano8
Manuel Sebastian7
Alejandro Martin6
Óscar Reyes6
Yassin Agzannay5
Hugo García5
Juan Vara4
Alejandro Díez4
Daniel Herranz4
Pablo González3
David Rincón3
Alberto Díez3
Mateo Carmona3
D. Rodríguez2
Javier Muñoz2
Marcos Iglesias2
A. Bartolome2
D. Maria1
Vidal Ruiz1
J. Martin1
O. González1
R. Garcia1
Manuel Gonzalez1
SALE
Juan Vara10
David Rincón10
Pablo González8
Alejandro Díez7
Daniel Herranz7
Manuel Sebastian7
Hugo García7
Óscar Reyes6
Javier Romano5
Alberto Díez4
Yassin Agzannay4
Ismael Garcia3
Marcos Iglesias3
Vidal Ruiz2
Adrián Santos1
A. Bartolome1
José Luis Matute1
Manuel Gonzalez1
Alejandro Martin1

  USO DE MEMORIA  
4,786,632 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.1705
Total Execution Time  0.1718
  CADENA URL  
/estadisticas/Espinar-San-Rafael
  GET DATOS  
$_GET['/estadisticas/Espinar-San-Rafael']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (6)  
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=969 AND type_rel = 2
0.0128  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 = '969' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0129  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff FROM `tables2024` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 73780 AND t.round = 28 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0127  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 = 73780 WHERE rp.league_id = 73780 AND rp.teamId = 969 AND (e.action = 22) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0133  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 = 73780 WHERE rp.league_id = 73780 AND rp.teamId = 969 AND (e.action = 19) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0132  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 = 73780 WHERE rp.league_id = 73780 AND rp.teamId = 969 AND (e.action = 18) GROUP BY p.id ORDER BY total DESC LIMIT 30