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

UCAM Murcia

Entrenador: Alberto Monteagudo

Temporada 2023/2024

Estadísticas

ASISTENCIAS
Ramón Blázquez4
J. García4
A. Luque Jr3
Sergio Chinchilla3
Víctor Mena2
Fer Pina2
Toni García1
Fabi1
Josema Raigal1
Navas1
ENTRA
D. Santisteban22
Ródenas21
Fabi21
A. Luque Jr9
J. García9
Javi Ramírez8
Josema Raigal7
Fer Pina6
V. Sánchez6
Ramón Blázquez6
Toni García6
Fran Miranda5
Navas5
Sergio Chinchilla5
Fran Callejón4
Marcos Pérez4
José Alonso4
Yasser3
Víctor Mena3
José Fran3
José Cruz3
Arturo3
Vicente Romero2
Víctor Esquerdo2
Miguel Serna1
SALE
J. García18
Arturo16
A. Luque Jr14
Josema Raigal14
Sergio Chinchilla12
Fer Pina9
Fran Callejón6
Ramón Blázquez6
Navas6
Toni García6
José Alonso6
Ródenas6
Yasser6
Fran Miranda6
Fabi6
Víctor Mena5
Javi Ramírez4
Vicente Romero3
Marcos Pérez2
D. Santisteban2
Zorro1

  USO DE MEMORIA  
5,425,552 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0015
Controller Execution Time ( Home / Category )  0.1647
Total Execution Time  0.1663
  CADENA URL  
/estadisticas/Ucam-Murcia-C-F
  GET DATOS  
$_GET['/estadisticas/Ucam-Murcia-C-F']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (7)  
0.0105  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=6056 AND type_rel = 2
0.0114  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 6056 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0108  SELECT /*35 bs_news_model*/ n.id, n.author_id, n.headline, n.external_headline, n.live_headline, n.creation_date, n.update_date, n.pub_date, n.alias, n.subheadline, n.teaser, n.media, n.tags, n.views, n.screens, n.clicks, n.relations, n.comments, n.power_cover, n.cover_points, u.name as user_name FROM bs_news n INNER JOIN bs_editors u ON u.id = n.author_id AND u.ln = 'es' WHERE n.status = 1 AND n.ln = 'es' AND n.id IN (653,989,1903,2601,2835) ORDER BY n.cover_points DESC, update_date DESC
0.0111  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 = '6056' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0119  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 = 72365 WHERE rp.league_id = 72365 AND rp.teamId = 6056 AND (e.action = 22) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0120  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 = 72365 WHERE rp.league_id = 72365 AND rp.teamId = 6056 AND (e.action = 19) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0124  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 = 72365 WHERE rp.league_id = 72365 AND rp.teamId = 6056 AND (e.action = 18) GROUP BY p.id ORDER BY total DESC LIMIT 30