4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Angers SCO - Chateauroux
Jornada 58
FINALIZADO
00
00
1917 Pts. Elo

1040 Pts. Elo

2-1
Viernes, 01 Septiembre 2017, 16:00
T. Mangani 56'
1 - 0
P. Capelle 77'
2 - 0
2 - 1
 82' K. Goba

Eventos del partido

Goles

T. ManganiGol de
T. Mangani
minuto 56'
P. CapelleGol de
P. Capelle
minuto 77'
minuto 82'K. GobaGol de K. Goba



  USO DE MEMORIA  
5,419,032 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0015
Controller Execution Time ( Match / Index )  0.4360
Total Execution Time  0.4375
  CADENA URL  
/partido/Angers-Sco/Berrichonne-Chateauroux/2018
  GET DATOS  
$_GET['/partido/Angers-Sco/Berrichonne-Chateauroux/2018']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (14)  
0.0145  SELECT data1 FROM stats2018 t WHERE league_id = 38427 AND teamId = 783647 and type = 33
0.0144  SELECT data1 FROM stats2018 t WHERE league_id = 38427 AND teamId = 793222 and type = 33
0.0146  SELECT id,team_id,tactica FROM dreamteam_data_real WHERE league_id = 38427 AND id_match = 592385
0.0146  SELECT p.* FROM `videos` as p INNER JOIN `rel_videos` as rp ON p.id = rp.id_video WHERE rp.id_content = '592385' and rp.type = 2018 and p.revised = 1 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0145  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 592385 AND year = 2018 AND channel = 'Footters' LIMIT 1
0.0145  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 592385 AND year = 2018 AND channel = 'Footters' LIMIT 1
0.0147  SELECT `id`, `text` FROM `matchs_news_keys` WHERE `match_id`='592385' AND `active` = 1 AND year = 2018
0.0149  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='38427' AND relp.team_id=783647 WHERE relp.in_squad=1 and mp.`match_id` = '592385' AND mp.year='2018' ORDER BY mp.`team` ASC, p.`role` ASC
0.0150  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='38427' AND relp.team_id=793222 WHERE relp.in_squad=1 and mp.`match_id` = '592385' AND mp.year='2018' ORDER BY mp.`team` ASC, p.`role` ASC
0.0148  SELECT id, team_id FROM dreamteam_data_real WHERE league_id = '38427' AND id_match = '592385'
0.0145  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=592385 AND extraId = 38427 AND type_rel = 4
0.0145  SELECT position FROM tables2018 WHERE team=783647 AND league_id=38427 AND round=58
0.0145  SELECT position FROM tables2018 WHERE team=793222 AND league_id=38427 AND round=58
0.0148  SELECT * FROM futbol.calendars_lineups WHERE id = 592385 AND league_id = 38427 AND year = 2018