Rayo Vallecano B

Datos del club

Ver detalle de equipo
  • Estadio: Ciudad Deportiva F...
  • Entrenador: Jorge Vallejo
Cargando...
Cargando...
Uso de cookies: Utilizamos "cookies" propias y de terceros para mejorar nuestros servicios, elaborar información estadística, analizar sus hábitos de navegación e inferir grupos de interés. Esto nos permite personalizar el contenido que ofrecemos y mostrarle publicidad relacionada con sus preferencias. Adicionalmente, compartimos los análisis de navegación y los grupos de interés inferidos con terceros. Si continúa navegando acepta su uso. Más información y cambio de configuración. Aceptar

  USO DE MEMORIA  
4,345,528 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0015
Controller Execution Time ( Twitter / Detail )  0.1619
Total Execution Time  0.1634
  CADENA URL  
/twitter/rayo-vallecano-b
  GET DATOS  
$_GET['/twitter/rayo-vallecano-b']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (8)  
0.0117  SELECT dt.*,c.active_year,l.year,l.table_suffix, c.ctype, l.id as league_id,t.id as id,t.manager,t.name as nameOriginal,dt.id as teamId,cou.Name as cou_name,cou.Continent,cou.Region FROM `leagues_webci` as l INNER JOIN `teams` as t ON l.id = t.league_id INNER JOIN `datateams` as dt ON dt.id = t.teamId INNER JOIN `categories_webci` as c ON c.id = l.categoryId LEFT JOIN country cou ON LOWER(cou.Code2) = dt.CountryCode WHERE dt.basealias = 'rayo-vallecano-b' AND l.year = 2024 ORDER BY c.top DESC, c.ctype != 12 DESC, c.troncal DESC, l.end_date >= NOW() DESC, l.start_date <= NOW() DESC, l.year DESC, c.coefficient DESC, l.id ASC
0.0106  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=2081 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0106  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=2081 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0106  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=2081 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0107  SELECT dt.nameShow, dt.basealias, t.id, t.total_twitter,dt.fullName FROM `teams` as t INNER JOIN `datateams` as dt ON dt.id = t.teamId WHERE league_id = 72266 AND t.total_twitter > 0 ORDER BY nameShow
0.0113  SELECT dt.nameShow, dt.basealias, t.id, t.total_twitter,dt.fullName FROM `teams` as t INNER JOIN `datateams` as dt ON dt.id = t.teamId WHERE t.total_twitter > 0 AND league_id != 1334 AND league_id != 1335 ORDER BY nameShow
0.0109  SELECT dp.name,dp.last_name,dp.nick,dp.alias,dp.twitter,dp.valor FROM rel_players rp INNER JOIN dataplayers dp ON rp.player_id = dp.id WHERE rp.in_squad = 1 AND rp.team_id = 6586231 AND dp.twitter is not null ORDER BY dp.valor DESC,dp.id ASC LIMIT 15
0.0107  SELECT dp.name,dp.last_name,dp.nick,dp.alias,dp.twitter,dp.valor FROM rel_players rp INNER JOIN dataplayers dp ON rp.player_id = dp.id INNER JOIN games.manager_players mp ON mp.playerId = dp.id WHERE rp.in_squad = 1 AND rp.league_id = 1334 AND dp.twitter is not null ORDER BY mp.action_value DESC,dp.id ASC LIMIT 15