4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
CSKA Moskva - Zenit
FINALIZADO
30
30
1711 Pts. Elo
29%

2062 Pts. Elo
71%

1-1
Domingo, 03 Septiembre 2023, 16:30
A. Zabolotnyi 4'
1 - 0
1 - 1
88' Douglas Santos

Eventos del partido

Goles

A. ZabolotnyiGol de
A. Zabolotnyi
minuto 4'
minuto 88'Douglas SantosGol de Douglas Santos

Tarjetas

Willyan RochaT. Amarilla
Willyan Rocha
minuto 95'
minuto 95'Nuraly AlipT. Amarilla Nuraly Alip
minuto 95'Douglas SantosT. Amarilla Douglas Santos
minuto 95'ClaudinhoT. Amarilla Claudinho
A. ZabolotnyiT. Amarilla
A. Zabolotnyi
minuto 95'
Felipe MéndezT. Amarilla
Felipe Méndez
minuto 96'

Cambios

minuto 71'V. KaravaevSale del partido V. Karavaev
minuto 71'I. SergeevEntra en el partido I. Sergeev
minuto 71'Gustavo MantuanSale del partido Gustavo Mantuan
minuto 71'D. KrugovoiEntra en el partido D. Krugovoi
V. DávilaEntra en el partido
V. Dávila
minuto 74'
M. MukhinEntra en el partido
M. Mukhin
minuto 74'
KhellvenSale del partido
Khellven
minuto 74'
Fedor ChalovSale del partido
Fedor Chalov
minuto 74'
minuto 82'M. FernandesSale del partido M. Fernandes
minuto 82'Mateo CassierraSale del partido Mateo Cassierra
minuto 82'A. MostovoyEntra en el partido A. Mostovoy
minuto 82'A. ErokhinEntra en el partido A. Erokhin

Otros

KhellvenLesionado
Khellven
minuto 73'

Alineaciones


Estadísticas del partido

CSKA Moskva CSKA Moskva Zenit Zenit
29%
Posesión del balón
71%
1
Goles
1
1
Tiros a puerta
4
2
Tiros fuera
5
4
Total tiros
14
3
Paradas del portero
0
3
Saques de esquina
12
4
Fueras de juego
3
0
Tarjetas Rojas
0
1
Lesiones
0
2
Sustituciones
3
15
Faltas
11


  USO DE MEMORIA  
6,707,144 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0010
Controller Execution Time ( Match / Index )  0.3958
Total Execution Time  0.3968
  CADENA URL  
/partido/Cska-Moskva/Zenit-St-Petersburg/2009?section=legal
  GET DATOS  
$_GET['/partido/Cska-Moskva/Zenit-St-Petersburg/2009']  
$_GET['section']   legal
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (11)  
0.0126  SELECT data1 FROM stats2024 t WHERE league_id = 72236 AND teamId = 6585456 and type = 33
0.0125  SELECT data1 FROM stats2024 t WHERE league_id = 72236 AND teamId = 6585471 and type = 33
0.0127  SELECT p.* FROM `videos` as p INNER JOIN `rel_videos` as rp ON p.id = rp.id_video WHERE rp.id_content = '42220' and rp.type = 2024 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 = 42220 AND year = 2024 AND channel = 'Footters' LIMIT 1
0.0126  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 42220 AND year = 2024 AND channel = 'Footters' LIMIT 1
0.0130  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2024` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 72236 AND t.round = 30 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0126  SELECT `id`, `text` FROM `matchs_news_keys` WHERE `match_id`='42220' AND `active` = 1 AND year = 2024
0.0339  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='72236' AND relp.team_id=6585456 WHERE relp.in_squad=1 and mp.`match_id` = '42220' AND mp.year='2024' ORDER BY mp.`team` ASC, p.`role` ASC
0.0344  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='72236' AND relp.team_id=6585471 WHERE relp.in_squad=1 and mp.`match_id` = '42220' AND mp.year='2024' ORDER BY mp.`team` ASC, p.`role` ASC
0.0128  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=42220 AND extraId = 72236 AND type_rel = 4
0.0127  SELECT * FROM futbol.calendars_lineups WHERE id = 42220 AND league_id = 72236 AND year = 2024