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

Estadísticas

ENTRA
M. El Jylaly17
M. Pastor10
A. Ruiz8
I. Casas7
J. Javega7
Cazares7
D. Lopez6
A. Ramírez5
A. Osuna5
A. Aguilera5
A. Rozin5
J. Sanchez4
A. Hafdaoui4
A. Ribera3
Abarca3
Iker Sebastián3
K. Perez3
E. Alacreu3
A. Codina3
J. Martin3
Manu Gasent2
A. Flores2
J. Garcia2
J. Ricaurte1
Diego1
A. Gimenez1
J. Sanchis1
J. Gutierrez1
C. Rodriguez1
SALE
Manu Gasent15
D. Lopez12
A. Osuna11
A. Aguilera11
I. Casas10
A. Ruiz9
A. Ramírez8
J. Garcia7
C. Rodriguez6
A. Codina6
J. Sanchis6
O. Solera5
A. Rozin5
Iker Sebastián3
K. Perez3
Diego2
J. Javega2
Cazares2
M. Pastor1
Abarca1
J. Sanchez1
A. Hafdaoui1

  USO DE MEMORIA  
4,794,296 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0018
Controller Execution Time ( Home / Category )  0.1725
Total Execution Time  0.1744
  CADENA URL  
/estadisticas/Club-Sporting-Mislata-Union-De-Futbol-Senior
  GET DATOS  
$_GET['/estadisticas/Club-Sporting-Mislata-Union-De-Futbol-Senior']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (6)  
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=46316 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 = '46316' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0127  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 = 73770 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0126  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 = 73770 WHERE rp.league_id = 73770 AND rp.teamId = 46316 AND (e.action = 22) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0134  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 = 73770 WHERE rp.league_id = 73770 AND rp.teamId = 46316 AND (e.action = 19) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0134  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 = 73770 WHERE rp.league_id = 73770 AND rp.teamId = 46316 AND (e.action = 18) GROUP BY p.id ORDER BY total DESC LIMIT 30