4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Unión Molinense

Unión Molinense

Entrenador: Julio Algar

Temporada 2023/2024

Estadísticas

ASISTENCIAS
Miguel Ballesta1
Luismi1
Manu Costa1
ENTRA
Nana16
Miguel Ballesta16
G. Lozano15
A. Serrano14
Nico13
Francisco Barbera12
Renato11
Manu Costa10
I. Quereda6
Samu6
A. Andugar5
Pedro Parra4
Palazon4
Juan Asensio4
Luismi3
Esteban López2
SALE
Palazon20
Manu Costa15
Samu14
Francisco Barbera13
Nico10
Esteban López9
Miguel Ballesta8
Luismi8
M. Gaffoor7
Nana7
A. Serrano6
Renato5
Pedro Parra4
Rubén Primo4
A. Andugar4
Juan Asensio3
Spinman3
G. Lozano2
I. Quereda1
Genis1

  USO DE MEMORIA  
4,898,376 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.2117
Total Execution Time  0.2129
  CADENA URL  
/estadisticas/Cf-Molina-San-Miguel
  GET DATOS  
$_GET['/estadisticas/Cf-Molina-San-Miguel']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (8)  
0.0252  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 = 72273
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=143591 AND type_rel = 2
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2470 AND type_rel = 3
0.0129  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 = '143591' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0130  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 = 72273 AND t.round = 31 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
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 = 72273 WHERE rp.league_id = 72273 AND rp.teamId = 143591 AND (e.action = 22) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0136  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 = 72273 WHERE rp.league_id = 72273 AND rp.teamId = 143591 AND (e.action = 19) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0135  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 = 72273 WHERE rp.league_id = 72273 AND rp.teamId = 143591 AND (e.action = 18) GROUP BY p.id ORDER BY total DESC LIMIT 30