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

Rayo Majadahonda

Entrenador: Armando de la Morena

Temporada 2023/2024

Estadísticas

ASISTENCIAS
Alberto Fernández5
Ro Abajas2
Rubén Enri2
Sergio Navarro2
D. Ceballos2
J. Cortés2
Jorge Casado2
Raúl Tavares1
Rubi1
Álvaro Arnedo1
Kike Hermoso1
S. Camacho1
ENTRA
J. Cortés19
T. Nakai11
Pablo Pérez10
Samu Expósito10
Ro Abajas10
Rubén Enri9
Rubi8
Jeisson Martínez8
Alberto Fernández7
F. Reguera7
Hugo Esteban7
Juanjo7
A. Claverías6
Pablo Hervías6
Markus Anderson5
S. Camacho5
Kike Hermoso4
Raúl Tavares4
G. Rodriguez3
João Dias2
Álvaro Arnedo2
Guille Berzal2
Sergio Navarro2
Pelayo Suárez2
D. Ceballos2
Sergi García1
Jorge Casado1
E. Eto'o1
SALE
Rubén Enri19
Raúl Tavares13
Alberto Fernández12
S. Camacho11
Markus Anderson11
Sergi García10
F. Reguera10
J. Cortés9
Álvaro Arnedo8
Pablo Pérez8
A. Claverías7
Pelayo Suárez7
Sergio Navarro6
Rubi5
D. Ceballos4
T. Nakai4
Hugo Esteban3
Juanjo3
Samu Expósito2
Ro Abajas2
Kike Hermoso2
Guille Berzal1
Jorge Casado1
G. Rodriguez1
Pablo Hervías1
João Dias1

  USO DE MEMORIA  
5,089,384 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0017
Controller Execution Time ( Home / Category )  0.2608
Total Execution Time  0.2625
  CADENA URL  
/estadisticas/Rayo-Majadahonda
  GET DATOS  
$_GET['/estadisticas/Rayo-Majadahonda']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (9)  
0.0145  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2078 AND type_rel = 2
0.0172  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 2078 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0162  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 (2599,2827,3254,7837,9145) ORDER BY n.cover_points DESC, update_date DESC
0.0155  SELECT cat.logo,cat.official,cat.location,dt.nameShow,dt.basealias,t.teamId,l.year,t.qod,cat.coefficient,cat.active_year,cat.name,l.group_code,l.total_group,cat.alias,l.categoryId,l.year,l.id as league_id FROM datateams dt INNER JOIN teams t ON t.teamId = dt.id INNER JOIN leagues l ON l.id = t.league_id INNER JOIN categories cat ON cat.id = l.categoryId WHERE dt.id = '2078' ORDER BY l.year DESC,cat.coefficient DESC
0.0151  SELECT cat.logo,cat.official,cat.location,dt.nameShow,dt.basealias,t.teamId,l.year,t.qod,cat.coefficient,cat.active_year,cat.name,l.group_code,l.total_group,cat.alias,l.categoryId,l.year,l.id as league_id FROM datateams dt INNER JOIN teams t ON t.teamId = dt.id INNER JOIN leagues l ON l.id = t.league_id INNER JOIN categories cat ON cat.id = l.categoryId WHERE dt.id = '2078' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0154  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 = '2078' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0176  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 = 72358 WHERE rp.league_id = 72358 AND rp.teamId = 2078 AND (e.action = 22) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0170  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 = 72358 WHERE rp.league_id = 72358 AND rp.teamId = 2078 AND (e.action = 19) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0160  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 = 72358 WHERE rp.league_id = 72358 AND rp.teamId = 2078 AND (e.action = 18) GROUP BY p.id ORDER BY total DESC LIMIT 30