4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Middlesbrough - Leicester
Jornada 16
FINALIZADO
40
30
1664 Pts. Elo
33%
10º

2931 Pts. Elo
67%
1º

1-0
Sábado, 11 Noviembre 2023, 16:00
Sam Greenwood 83'
1 - 0

Eventos del partido

Goles

Sam GreenwoodGol de
Sam Greenwood
minuto 83'

Tarjetas

minuto 12'J. VestergaardT. Amarilla J. Vestergaard
M. CrooksT. Amarilla
M. Crooks
minuto 42'
minuto 43'Harry WinksT. Amarilla Harry Winks
minuto 82'H. ChoudhuryT. Amarilla H. Choudhury
J. HowsonT. Amarilla
J. Howson
minuto 85'
Isaiah JonesT. Amarilla
Isaiah Jones
minuto 88'
Morgan RogersT. Amarilla
Morgan Rogers
minuto 93'

Cambios

minuto 58'Kasey McateerSale del partido Kasey Mcateer
minuto 58'Abdul FatawuEntra en el partido Abdul Fatawu
Morgan RogersEntra en el partido
Morgan Rogers
minuto 68'
M. CrooksSale del partido
M. Crooks
minuto 68'
J. CoburnSale del partido
J. Coburn
minuto 73'
E. Latte LathEntra en el partido
E. Latte Lath
minuto 73'
minuto 85'Jamie VardyEntra en el partido Jamie Vardy
minuto 85'H. ChoudhurySale del partido H. Choudhury
Isaiah JonesSale del partido
Isaiah Jones
minuto 91'
A. DijksteelEntra en el partido
A. Dijksteel
minuto 91'

Alineaciones

Middlesbrough

Middlesbrough

4-5-1
Alineación Inicial
Suplentes
Leicester

Leicester

4-3-3
Alineación Inicial
Suplentes

Estadísticas del partido

Middlesbrough Middlesbroug Leicester Leicester
33%
Posesión del balón
 67%
1
Goles
 0
6
Tiros a puerta
 4
2
Tiros fuera
 6
9
Total tiros
 12
4
Paradas del portero
 5
3
Saques de esquina
 4
0
Fueras de juego
 1
0
Tarjetas Rojas
 0
3
Sustituciones
 2
18
Faltas
 15


  USO DE MEMORIA  
6,860,520 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0010
Controller Execution Time ( Match / Index )  0.4014
Total Execution Time  0.4024
  CADENA URL  
/partido/Middlesbrough-Fc/Leicester-City-Fc/2012?section=legal
  GET DATOS  
$_GET['/partido/Middlesbrough-Fc/Leicester-City-Fc/2012']  
$_GET['section']   legal
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (20)  
0.0018  SELECT data1 FROM stats2024 t WHERE league_id = 72033 AND teamId = 6582236 and type = 33
0.0018  SELECT data1 FROM stats2024 t WHERE league_id = 72033 AND teamId = 6582235 and type = 33
0.0019  SELECT id,team_id,tactica FROM dreamteam_data_real WHERE league_id = 72033 AND id_match = 27797
0.0027  SELECT rel.*,relp.squadNumber as num,dp.alias,dp.role,dp.name,dp.nick,dp.last_name,dp.id as player_id, 0 AS rating FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real drea ON drea.id = rel.team_number INNER JOIN dataplayers dp ON dp.id = rel.player_id INNER JOIN rel_players AS relp ON relp.player_id=dp.id AND relp.league_id='72033' AND relp.team_id = drea.team_id WHERE rel.team_number=5032876 GROUP BY dp.id ORDER BY role ASC, pos ASC
0.0024  SELECT rel.*,relp.squadNumber as num,dp.alias,dp.role,dp.name,dp.nick,dp.last_name,dp.id as player_id, 0 AS rating FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real drea ON drea.id = rel.team_number INNER JOIN dataplayers dp ON dp.id = rel.player_id INNER JOIN rel_players AS relp ON relp.player_id=dp.id AND relp.league_id='72033' AND relp.team_id = drea.team_id WHERE rel.team_number=5032524 GROUP BY dp.id ORDER BY role ASC, pos ASC
0.0126  SELECT mp.`player_id`, p.`nick`, p.`name`, p.`last_name`, mp.`team`, p.role, p.alias, relp.squadNumber as num, p.CountryCode FROM `matchs_players_called` AS mp INNER JOIN `dataplayers` AS p ON mp.`player_id` = p.`id` INNER JOIN rel_players AS relp ON relp.player_id=p.id AND relp.league_id='72033' AND relp.team_id=6582236 WHERE mp.`match_id` = '27797' AND mp.year='2024' AND p.id NOT IN (343352,101922,274710,310623,149127,209890,352775,317209,754371,284633,198078,205082,201125,281418,464547,872136,427849,57057,212463,427773,876640,843490) ORDER BY mp.`team` ASC, p.`role` ASC
0.0126  SELECT mp.`player_id`, p.`nick`, p.`name`, p.`last_name`, mp.`team`, p.role, p.alias, relp.squadNumber as num, p.CountryCode FROM `matchs_players_called` AS mp INNER JOIN `dataplayers` AS p ON mp.`player_id` = p.`id` INNER JOIN rel_players AS relp ON relp.player_id=p.id AND relp.league_id='72033' AND relp.team_id=6582235 WHERE mp.`match_id` = '27797' AND mp.year='2024' AND p.id NOT IN (343352,101922,274710,310623,149127,209890,352775,317209,754371,284633,198078,205082,201125,281418,464547,872136,427849,57057,212463,427773,876640,843490) ORDER BY mp.`team` ASC, p.`role` ASC
0.0020  SELECT p.* FROM `pictures` as p INNER JOIN `rel_pictures` as rp ON p.id = rp.id_picture WHERE rp.id_content = '27797' and rp.type = 2024 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0020  SELECT p.* FROM `videos` as p INNER JOIN `rel_videos` as rp ON p.id = rp.id_video WHERE rp.id_content = '27797' and rp.type = 2024 and p.revised = 1 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0018  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 27797 AND year = 2024 AND channel = 'Footters' LIMIT 1
0.0018  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 27797 AND year = 2024 AND channel = 'Footters' LIMIT 1
0.0018  SELECT points,gf,ga,win_h,win_a,draw_h,draw_a,lose_h,lose_a FROM `tables2024` WHERE league_id = 72033 AND round >= 46 AND round <= 46 AND team = 6582236 ORDER BY round ASC
0.0018  SELECT `id`, `text` FROM `matchs_news_keys` WHERE `match_id`='27797' AND `active` = 1 AND year = 2024
0.0145  SELECT mp.`player_id`, p.`nick`, p.`name`, p.`last_name`, mp.`team`, p.role, p.alias, relp.squadNumber as num, p.CountryCode FROM `matchs_players_called` AS mp INNER JOIN `dataplayers` AS p ON mp.`player_id` = p.`id` INNER JOIN rel_players AS relp ON relp.player_id=p.id AND relp.league_id='72033' AND relp.team_id=6582236 WHERE relp.in_squad=1 and mp.`match_id` = '27797' AND mp.year='2024' ORDER BY mp.`team` ASC, p.`role` ASC
0.0125  SELECT mp.`player_id`, p.`nick`, p.`name`, p.`last_name`, mp.`team`, p.role, p.alias, relp.squadNumber as num, p.CountryCode FROM `matchs_players_called` AS mp INNER JOIN `dataplayers` AS p ON mp.`player_id` = p.`id` INNER JOIN rel_players AS relp ON relp.player_id=p.id AND relp.league_id='72033' AND relp.team_id=6582235 WHERE relp.in_squad=1 and mp.`match_id` = '27797' AND mp.year='2024' ORDER BY mp.`team` ASC, p.`role` ASC
0.0019  SELECT id, team_id FROM dreamteam_data_real WHERE league_id = '72033' AND id_match = '27797'
0.0019   SELECT rel.*, dp.name, dp.nick, dp.last_name, dp.id as player_id, 0 AS rating FROM rel_dreamteam_real rel INNER JOIN dataplayers dp ON dp.id = rel.player_id WHERE rel.team_number = '5032876' ORDER BY rating DESC LIMIT 1
0.0018   SELECT rel.*, dp.name, dp.nick, dp.last_name, dp.id as player_id, 0 AS rating FROM rel_dreamteam_real rel INNER JOIN dataplayers dp ON dp.id = rel.player_id WHERE rel.team_number = '5032524' ORDER BY rating DESC LIMIT 1
0.0017  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=27797 AND extraId = 72033 AND type_rel = 4
0.0018  SELECT * FROM futbol.calendars_lineups WHERE id = 27797 AND league_id = 72033 AND year = 2024