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

Leicester

Entrenador: Enzo Maresca

Temporada 2023/2024

Estadísticas

ASISTENCIAS
K. Dewsbury-Hall13
Abdul Fatawu10
W. Ndidi5
S. Mavididi5
Patson Daka5
Ricardo Pereira3
Yunus Akgün2
James Justin2
Callum Doyle1
Jamie Vardy1
Thomas Cannon1
K. Iheanacho1
Dennis Praet1
ENTRA
Jamie Vardy17
H. Choudhury17
C. Casadei14
Yunus Akgün13
K. Iheanacho12
M. Albrighton11
James Justin10
Dennis Praet9
Thomas Cannon9
Kasey Mcateer8
Abdul Fatawu7
W. Ndidi6
Luke Thomas4
Conor Coady3
Patson Daka3
Ben Nelson3
S. Mavididi3
Ricardo Pereira2
K. Dewsbury-Hall2
Callum Doyle2
Harry Souttar2
Arjan Raikhy1
Wanya Marcal1
SALE
W. Ndidi18
Abdul Fatawu16
S. Mavididi14
Patson Daka14
Jamie Vardy13
K. Dewsbury-Hall10
Kasey Mcateer10
Yunus Akgün9
K. Iheanacho8
Ricardo Pereira7
Dennis Praet6
James Justin5
C. Casadei5
H. Choudhury4
Luke Thomas3
Callum Doyle3
J. Vestergaard3
Harry Winks2
Thomas Cannon2
Wanya Marcal2
Ben Nelson1
Conor Coady1
Wout Faes1
Harry Souttar1

  USO DE MEMORIA  
5,687,336 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.2083
Total Execution Time  0.2096
  CADENA URL  
/estadisticas/leicester-city-fc
  GET DATOS  
$_GET['/estadisticas/leicester-city-fc']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (10)  
0.0124  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 = 'leicester-city-fc' 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=1538 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=1538 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=1538 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=1538 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0105  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=1538 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0124  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 = '1538' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0132  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 = 72033 WHERE rp.league_id = 72033 AND rp.teamId = 1538 AND (e.action = 22) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0142  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 = 72033 WHERE rp.league_id = 72033 AND rp.teamId = 1538 AND (e.action = 19) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0188  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 = 72033 WHERE rp.league_id = 72033 AND rp.teamId = 1538 AND (e.action = 18) GROUP BY p.id ORDER BY total DESC LIMIT 30