4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Spartak Kostroma - Dnepr Smolensk
Jornada 28
FINALIZADO
30
20
376 Pts. Elo
12º

348 Pts. Elo
13º

2-0
Domingo, 24 Mayo 2015, 16:00
K. Privalov 22'
1 - 0
E. Khudobko 45'
2 - 0

Eventos del partido

Goles

K. PrivalovGol de
K. Privalov
minuto 22'
E. KhudobkoGol de
E. Khudobko
minuto 45'

Tarjetas

minuto 21'E. TsymbalT. Amarilla E. Tsymbal
E. KhudobkoT. Amarilla
E. Khudobko
minuto 29'
A. ArlashinT. Amarilla
A. Arlashin
minuto 35'
K. ZhiltsovT. Amarilla
K. Zhiltsov
minuto 86'
minuto 90'A. PerchenokT. Amarilla A. Perchenok

Cambios

A. ArlashinSale del partido
A. Arlashin
minuto 46'
K. SovetkinEntra en el partido
K. Sovetkin
minuto 46'
minuto 46'S. SemenovEntra en el partido S. Semenov
minuto 46'N. AnokhinSale del partido N. Anokhin
minuto 55'D. MitinEntra en el partido D. Mitin
minuto 55'K. PlotnikovSale del partido K. Plotnikov
minuto 67'N. KolyaevSale del partido N. Kolyaev
minuto 67'I. SapronovEntra en el partido I. Sapronov
I. KostylevEntra en el partido
I. Kostylev
minuto 72'
N. KukoyakaSale del partido
N. Kukoyaka
minuto 72'
minuto 72'Roman StepinEntra en el partido Roman Stepin
minuto 72'M. PetrusevSale del partido M. Petrusev

Alineaciones

Spartak Kostroma

Spartak Kostroma

4-4-2
Alineación Inicial
Suplentes
Dnepr Smolensk

Dnepr Smolensk

4-4-2
Alineación Inicial
Suplentes



  USO DE MEMORIA  
5,860,296 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0016
Controller Execution Time ( Match / Index )  0.2540
Total Execution Time  0.2557
  CADENA URL  
/partido/Spartak-Kostroma/Dnepr-57867/2015
  GET DATOS  
$_GET['/partido/Spartak-Kostroma/Dnepr-57867/2015']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (8)  
0.0128  SELECT p.* FROM `videos` as p INNER JOIN `rel_videos` as rp ON p.id = rp.id_video WHERE rp.id_content = '171963' and rp.type = 2015 and p.revised = 1 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0125  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 171963 AND year = 2015 AND channel = 'Footters' LIMIT 1
0.0127  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 171963 AND year = 2015 AND channel = 'Footters' LIMIT 1
0.0127  SELECT `id`, `text` FROM `matchs_news_keys` WHERE `match_id`='171963' AND `active` = 1 AND year = 2015
0.0172  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='4366' AND relp.team_id=78998 WHERE relp.in_squad=1 and mp.`match_id` = '171963' AND mp.year='2015' ORDER BY mp.`team` ASC, p.`role` ASC
0.0169  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='4366' AND relp.team_id=79003 WHERE relp.in_squad=1 and mp.`match_id` = '171963' AND mp.year='2015' ORDER BY mp.`team` ASC, p.`role` ASC
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=171963 AND extraId = 4366 AND type_rel = 4
0.0125  SELECT * FROM futbol.calendars_lineups WHERE id = 171963 AND league_id = 4366 AND year = 2015