4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Dulwich Hamlet FC - Harrow Borough
FINALIZADO
00
00
189 Pts. Elo
12º

142 Pts. Elo
18º

1-4
Martes, 27 Septiembre 2016, 20:45
0 - 1
8' D. Taylor
0 - 2
16' L. Driver
N. Clunis 41'
1 - 2
1 - 3
59' L. Driver
1 - 4
62' L. Driver

Eventos del partido

Goles

minuto 8'D. TaylorGol de D. Taylor
minuto 16'L. DriverGol de L. Driver
N. ClunisGol de
N. Clunis
minuto 41'
minuto 59'L. DriverGol de L. Driver
minuto 62'L. DriverGol de L. Driver



  USO DE MEMORIA  
5,581,912 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0010
Controller Execution Time ( Match / Index )  0.1846
Total Execution Time  0.1856
  CADENA URL  
/partido/Dulwich-Hamlet-Fc/Harrow-Borough-Fc/2017
  GET DATOS  
$_GET['/partido/Dulwich-Hamlet-Fc/Harrow-Borough-Fc/2017']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (13)  
0.0019  SELECT data1 FROM stats2017 t WHERE league_id = 33744 AND teamId = 714873 and type = 33
0.0017  SELECT data1 FROM stats2017 t WHERE league_id = 33744 AND teamId = 714878 and type = 33
0.0020  SELECT id,team_id,tactica FROM dreamteam_data_real WHERE league_id = 33744 AND id_match = 145983
0.0020  SELECT p.* FROM `videos` as p INNER JOIN `rel_videos` as rp ON p.id = rp.id_video WHERE rp.id_content = '145983' and rp.type = 2017 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 = 145983 AND year = 2017 AND channel = 'Footters' LIMIT 1
0.0018  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 145983 AND year = 2017 AND channel = 'Footters' LIMIT 1
0.0020  SELECT `id`, `text` FROM `matchs_news_keys` WHERE `match_id`='145983' AND `active` = 1 AND year = 2017
0.0041  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='33744' AND relp.team_id=714873 WHERE relp.in_squad=1 and mp.`match_id` = '145983' AND mp.year='2017' ORDER BY mp.`team` ASC, p.`role` ASC
0.0029  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='33744' AND relp.team_id=714878 WHERE relp.in_squad=1 and mp.`match_id` = '145983' AND mp.year='2017' ORDER BY mp.`team` ASC, p.`role` ASC
0.0021  SELECT id, team_id FROM dreamteam_data_real WHERE league_id = '33744' AND id_match = '145983'
0.0017  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=145983 AND extraId = 33744 AND type_rel = 4
0.0018  SELECT rating1, rating2 FROM calendars_elo WHERE id=145983 AND league_id=33744 AND year=2017
0.0039  SELECT * FROM futbol.calendars_lineups WHERE id = 145983 AND league_id = 33744 AND year = 2017