Almería

Datos del club

Ver detalle de equipo
  • Estadio: Juegos del Mediter...
  • Entrenador: Pepe Mel
  • Presidente: Al-Sheikh
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,384,344 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0009
Controller Execution Time ( Twitter / Detail )  0.0669
Total Execution Time  0.0678
  CADENA URL  
/twitter/almeria
  GET DATOS  
$_GET['/twitter/almeria']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (9)  
0.0054  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 = 'almeria' 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.0036  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=183 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0035  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=183 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0035  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=183 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0035  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=183 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0036  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 = 72116 AND t.total_twitter > 0 ORDER BY nameShow
0.0044  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.0046  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 = 6583635 AND dp.twitter is not null ORDER BY dp.valor DESC,dp.id ASC LIMIT 15
0.0035  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