4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias

Estadísticas

ASISTENCIAS
Iago Aspas8
Manu Sánchez5
L. De La Torre4
J. Larsen2
J. Bamba2
Ó. Mingueza2
Franco Cervi1
J. Manquillo1
A. Douvikas1
Carles Pérez1
Jaílson1
ENTRA
A. Douvikas21
Miguel Rodríguez12
W. Swedberg11
Franco Cervi10
Hugo Sotelo9
Carlos Dotor9
Carles Pérez8
L. De La Torre7
T. Allende6
Manu Sánchez6
Renato Tapia5
Jaílson5
Fran Beltrán4
Ó. Mingueza4
Hugo Álvarez3
C. Domínguez3
Iago Aspas3
Damián2
Unai Núñez2
Mihailo Ristić2
Kevin Vázquez2
J. Bamba2
Joseph Aidoo2
V. Guaita1
Carl Starfelt1
J. Manquillo1
Gabri Veiga1
SALE
J. Larsen23
J. Bamba13
Iago Aspas11
Fran Beltrán11
L. De La Torre10
Ó. Mingueza7
Manu Sánchez6
Hugo Sotelo6
Carles Pérez6
Kevin Vázquez6
C. Domínguez5
J. Manquillo5
Franco Cervi4
A. Douvikas4
Carl Starfelt4
Carlos Dotor3
Hugo Álvarez3
Unai Núñez3
Renato Tapia3
Mihailo Ristić3
W. Swedberg2
T. Allende2
Jaílson1
Miguel Rodríguez1

  USO DE MEMORIA  
5,616,552 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.2298
Total Execution Time  0.2309
  CADENA URL  
/estadisticas/Celta
  GET DATOS  
$_GET['/estadisticas/Celta']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (9)  
0.0160  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 = 'Celta' 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.0130  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=712 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0134  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=712 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0138  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=712 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0138  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=712 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0144  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 = '712' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0153  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 = 72116 WHERE rp.league_id = 72116 AND rp.teamId = 712 AND (e.action = 22) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0147  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 = 72116 WHERE rp.league_id = 72116 AND rp.teamId = 712 AND (e.action = 19) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0148  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 = 72116 WHERE rp.league_id = 72116 AND rp.teamId = 712 AND (e.action = 18) GROUP BY p.id ORDER BY total DESC LIMIT 30