4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
CSKA Sofia - Viktoria Plzeň
Jornada 155
FINALIZADO
00
00
1288 Pts. Elo

1855 Pts. Elo

0-3
Viernes, 31 Enero 2020, 16:00
0 - 1
 39' J. Kovarik
0 - 2
 48' J. Kovarik
0 - 3
 70' M. Alvir

Eventos del partido

Goles

minuto 39'J. KovarikGol de J. Kovarik
minuto 48'J. KovarikGol de J. Kovarik
minuto 70'M. AlvirGol de M. Alvir

Cambios

minuto 62'J. BeauguelSale del partido J. Beauguel
minuto 62'M. AlvirEntra en el partido M. Alvir
minuto 77'A. HlousekSale del partido A. Hlousek
minuto 77'S. GabrielEntra en el partido S. Gabriel
minuto 77'L. HejdaSale del partido L. Hejda
minuto 77'T. ChorýEntra en el partido T. Chorý

Alineaciones

CSKA Sofia

CSKA Sofia

4-4-2
Alineación Inicial
Suplentes
Viktoria Plzeň

Viktoria Plzeň

4-4-2
Alineación Inicial
Suplentes



  USO DE MEMORIA  
6,417,472 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0010
Controller Execution Time ( Match / Index )  0.4526
Total Execution Time  0.4536
  CADENA URL  
/partido/Cska-Sofia/Viktoria-Plze/2020
  GET DATOS  
$_GET['/partido/Cska-Sofia/Viktoria-Plze/2020']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (12)  
0.0147  SELECT data1 FROM stats2020 t WHERE league_id = 49506 AND teamId = 6280718 and type = 33
0.0147  SELECT data1 FROM stats2020 t WHERE league_id = 49506 AND teamId = 6280376 and type = 33
0.0154  SELECT p.* FROM `videos` as p INNER JOIN `rel_videos` as rp ON p.id = rp.id_video WHERE rp.id_content = '362185' and rp.type = 2020 and p.revised = 1 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0149  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 362185 AND year = 2020 AND channel = 'Footters' LIMIT 1
0.0149  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 362185 AND year = 2020 AND channel = 'Footters' LIMIT 1
0.0148  SELECT `id`, `text` FROM `matchs_news_keys` WHERE `match_id`='362185' AND `active` = 1 AND year = 2020
0.0161  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='49506' AND relp.team_id=6280718 WHERE relp.in_squad=1 and mp.`match_id` = '362185' AND mp.year='2020' ORDER BY mp.`team` ASC, p.`role` ASC
0.0161  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='49506' AND relp.team_id=6280376 WHERE relp.in_squad=1 and mp.`match_id` = '362185' AND mp.year='2020' ORDER BY mp.`team` ASC, p.`role` ASC
0.0147  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=362185 AND extraId = 49506 AND type_rel = 4
0.0147  SELECT position FROM tables2020 WHERE team=6280718 AND league_id=49506 AND round=155
0.0147  SELECT position FROM tables2020 WHERE team=6280376 AND league_id=49506 AND round=155
0.0148  SELECT * FROM futbol.calendars_lineups WHERE id = 362185 AND league_id = 49506 AND year = 2020