4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Derby County - Ipswich Town
Jornada 46
FINALIZADO
20
20
1432 Pts. Elo
5º

1270 Pts. Elo
7º

0-1
Sábado, 07 Mayo 2016, 13:30
0 - 1
 34' D. Mcgoldrick
Derby County
Ipswich Town
T. Amarilla
Gol
T. Amarilla
T. Amarilla
Entra en el partido
Sale del partido
Entra en el partido
Sale del partido
Entra en el partido
Sale del partido
T. Amarilla
Sale del partido
Entra en el partido
Entra en el partido
Sale del partido
Entra en el partido
Sale del partido

Eventos del partido

Goles

minuto 34'D. McgoldrickGol de D. Mcgoldrick

Tarjetas

minuto 31'L. ChambersT. Amarilla L. Chambers
minuto 39'A. McdonnellT. Amarilla A. Mcdonnell
R. KeoghT. Amarilla
R. Keogh
minuto 44'
C. MartinT. Amarilla
C. Martin
minuto 65'

Cambios

minuto 46'L. HyamEntra en el partido L. Hyam
minuto 46'C. SkuseSale del partido C. Skuse
J. BuxtonEntra en el partido
J. Buxton
minuto 49'
R. KeoghSale del partido
R. Keogh
minuto 49'
minuto 55'J. DouglasEntra en el partido J. Douglas
minuto 55'A. McdonnellSale del partido A. Mcdonnell
C. MartinSale del partido
C. Martin
minuto 68'
D. BentEntra en el partido
D. Bent
minuto 68'
minuto 69'B. PitmanEntra en el partido B. Pitman
minuto 69'T. BishopSale del partido T. Bishop
N. BlackmanEntra en el partido
N. Blackman
minuto 79'
Will HughesSale del partido
Will Hughes
minuto 79'
1 Comentarios
  • betty03
    Hace 8 años betty03 dice: GANA DERBY COUNTY


  USO DE MEMORIA  
6,166,080 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0009
Controller Execution Time ( Match / Index )  0.1039
Total Execution Time  0.1049
  CADENA URL  
/partido/Derby-County-Fc/Ipswich-Town-Fc/2016
  GET DATOS  
$_GET['/partido/Derby-County-Fc/Ipswich-Town-Fc/2016']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (12)  
0.0007   SELECT c.comment_id, COUNT(DISTINCT c.`id`) AS num FROM comments AS c WHERE c.`active` = 1 AND c.device = 'web' AND c.to_review=0 AND c.comment_id!=0 AND c.lang = '1' AND c.`league_id` = '15148' AND c.`match_id` = '6373' AND c.comment_id IN (10696010) GROUP BY c.comment_id
0.0020  SELECT data1 FROM stats2016 t WHERE league_id = 15148 AND teamId = 211074 and type = 33
0.0017  SELECT data1 FROM stats2016 t WHERE league_id = 15148 AND teamId = 211077 and type = 33
0.0021  SELECT p.* FROM `videos` as p INNER JOIN `rel_videos` as rp ON p.id = rp.id_video WHERE rp.id_content = '6373' and rp.type = 2016 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 = 6373 AND year = 2016 AND channel = 'Footters' LIMIT 1
0.0018  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 6373 AND year = 2016 AND channel = 'Footters' LIMIT 1
0.0019   SELECT c.id, c.author_name, c.comment, c.comment_id, c.author_id, c.creation_date, c.votes_up, c.device, fau.user_name, fau.adm AS user_adm, fau.role AS user_role, fau.adm_type AS user_adm_type, template, NOW() AS difference_time FROM comments AS c LEFT JOIN fa_user_mini AS fau ON fau.id = c.author_id WHERE c.`active`=1 AND c.to_review=0 AND c.device = 'web' AND c.comment_id = '10696010' AND c.lang = '1' ORDER BY creation_date DESC LIMIT 20
0.0018  SELECT `id`, `text` FROM `matchs_news_keys` WHERE `match_id`='6373' AND `active` = 1 AND year = 2016
0.0035  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='15148' AND relp.team_id=211074 WHERE relp.in_squad=1 and mp.`match_id` = '6373' AND mp.year='2016' ORDER BY mp.`team` ASC, p.`role` ASC
0.0030  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='15148' AND relp.team_id=211077 WHERE relp.in_squad=1 and mp.`match_id` = '6373' AND mp.year='2016' ORDER BY mp.`team` ASC, p.`role` ASC
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=6373 AND extraId = 15148 AND type_rel = 4
0.0021  SELECT * FROM futbol.calendars_lineups WHERE id = 6373 AND league_id = 15148 AND year = 2016