4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Pachuca - Cruz Azul
Jornada 5
FINALIZADO
30
40
1887 Pts. Elo
32%
11º

1545 Pts. Elo
68%
18º

1-0
Jueves, 24 Agosto 2023, 03:06
I. Hernandez 63'
1 - 0

Eventos del partido

Goles

I. HernandezGol de
I. Hernandez
minuto 63'

Tarjetas

Carlos MorenoT. Amarilla
Carlos Moreno
minuto 24'
minuto 27'Andrés GudiñoT. Amarilla Andrés Gudiño
G. CabralT. Amarilla
G. Cabral
minuto 43'
minuto 70'Willer DittaT. Amarilla Willer Ditta
I. HernandezT. Amarilla
I. Hernandez
minuto 70'
minuto 98'J. EscobarT. Amarilla J. Escobar
minuto 100'C. SalcedoT. Amarilla C. Salcedo

Cambios

F. FigueroaSale del partido
F. Figueroa
minuto 56'
Owen GonzálezEntra en el partido
Owen González
minuto 56'
minuto 56'MoisesEntra en el partido Moises
minuto 56'A. GutiérrezSale del partido A. Gutiérrez
R. De La RosaSale del partido
R. De La Rosa
minuto 57'
Lucas Di YorioSale del partido
Lucas Di Yorio
minuto 57'
Chofis LopezEntra en el partido
Chofis Lopez
minuto 57'
I. HernandezEntra en el partido
I. Hernandez
minuto 57'
minuto 73'Rodrigo HuescasSale del partido Rodrigo Huescas
minuto 73'C. TabóEntra en el partido C. Tabó
M. HinestrozaSale del partido
M. Hinestroza
minuto 79'
Byron CastilloEntra en el partido
Byron Castillo
minuto 79'
minuto 81'J. DueñasEntra en el partido J. Dueñas
minuto 81'D. CambindoSale del partido D. Cambindo
Erick SánchezSale del partido
Erick Sánchez
minuto 85'
Celso OrtízEntra en el partido
Celso Ortíz
minuto 85'

VAR

G. CabralNo penalti
G. Cabral
minuto 70'

Alineaciones

Pachuca

Pachuca

4-4-2
Alineación Inicial
Suplentes
Cruz Azul

Cruz Azul

3-6-1
Alineación Inicial
Suplentes

Estadísticas del partido

Pachuca Pachuca Cruz Azul Cruz Azul
32%
Posesión del balón
 68%
1
Goles
 0
4
Tiros a puerta
 7
7
Tiros fuera
 9
17
Total tiros
 18
7
Paradas del portero
 3
4
Saques de esquina
 7
0
Fueras de juego
 3
0
Tarjetas Rojas
 0
3
Sustituciones
 3
12
Faltas
 9


  USO DE MEMORIA  
6,821,008 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0010
Controller Execution Time ( Match / Index )  0.4616
Total Execution Time  0.4626
  CADENA URL  
/partido/Pachuca/Cdsc-Cruz-Azul/2014?section=legal
  GET DATOS  
$_GET['/partido/Pachuca/Cdsc-Cruz-Azul/2014']  
$_GET['section']   legal
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (14)  
0.0017  SELECT data1 FROM stats2024 t WHERE league_id = 71994 AND teamId = 6581101 and type = 33
0.0017  SELECT data1 FROM stats2024 t WHERE league_id = 71994 AND teamId = 6581107 and type = 33
0.0021  SELECT p.* FROM `videos` as p INNER JOIN `rel_videos` as rp ON p.id = rp.id_video WHERE rp.id_content = '4469' and rp.type = 2024 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 = 4469 AND year = 2024 AND channel = 'Footters' LIMIT 1
0.0018  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 4469 AND year = 2024 AND channel = 'Footters' LIMIT 1
0.0020  SELECT dt.nameShow,dt.basealias,t.id,t.teamId FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 71994 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0018  SELECT `id`, `text` FROM `matchs_news_keys` WHERE `match_id`='4469' AND `active` = 1 AND year = 2024
0.0093  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='71994' AND relp.team_id=6581101 WHERE relp.in_squad=1 and mp.`match_id` = '4469' AND mp.year='2024' ORDER BY mp.`team` ASC, p.`role` ASC
0.0106  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='71994' AND relp.team_id=6581107 WHERE relp.in_squad=1 and mp.`match_id` = '4469' AND mp.year='2024' ORDER BY mp.`team` ASC, p.`role` ASC
0.0017  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=4469 AND extraId = 71994 AND type_rel = 4
0.0017  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=68 AND type_rel = 3
0.0097  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 68 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0030  SELECT /*53 bs_news_model*/ n.id, n.author_id, n.headline, n.external_headline, n.live_headline, n.creation_date, n.update_date, n.pub_date, n.alias, n.subheadline, n.teaser, n.media, n.tags, n.views, n.screens, n.clicks, n.relations, n.comments, n.power_cover, n.cover_points, u.name as user_name FROM bs_news n INNER JOIN bs_editors u ON u.id = n.author_id AND u.ln = 'es' WHERE n.status = 1 AND n.ln = 'es' AND n.id IN (1317766,1317364,1313669,1304130,1303039) ORDER BY n.cover_points DESC, update_date DESC
0.0018  SELECT * FROM futbol.calendars_lineups WHERE id = 4469 AND league_id = 71994 AND year = 2024