4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
CD Villacañas - UD Yugo Socuéllamos
Jornada 1
FINALIZADO
20
50
94 Pts. Elo
5º

137 Pts. Elo
15º

1-0
Sábado, 09 Septiembre 2023, 19:00
Carlos 78'
1 - 0

Eventos del partido

Goles

CarlosGol de penalti
Carlos
minuto 78'

Tarjetas

CabezolaT. Amarilla
Cabezola
minuto 31'
CarlosT. Amarilla
Carlos
minuto 43'
minuto 51'ArmentaT. Amarilla Armenta
minuto 61'Octavio FresnedaT. Amarilla Octavio Fresneda
minuto 78'SamuT. Amarilla Samu
minuto 83'EscobarT. Amarilla Escobar
minuto 89'José LaraT. Amarilla José Lara

Cambios

minuto 58'ArmentaSale del partido Armenta
minuto 58'R. CaleroEntra en el partido R. Calero
minuto 65'SilesEntra en el partido Siles
minuto 65'Octavio FresnedaSale del partido Octavio Fresneda
minuto 81'SamuSale del partido Samu
minuto 81'Josema VivancosEntra en el partido Josema Vivancos
minuto 81'Miguel SerranoSale del partido Miguel Serrano
minuto 81'M. RodrigáñezEntra en el partido M. Rodrigáñez
minuto 81'Iván HujoSale del partido Iván Hujo
minuto 81'Álex BriegaEntra en el partido Álex Briega
GonzaloSale del partido
Gonzalo
minuto 89'
Mamadou BahEntra en el partido
Mamadou Bah
minuto 89'

Alineaciones

CD Villacañas

CD Villacañas

4-4-2
Alineación Inicial
Suplentes
UD Yugo Socuéllamos

UD Yugo Socuéllamos

4-4-2
Alineación Inicial
Suplentes



  USO DE MEMORIA  
6,702,048 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0009
Controller Execution Time ( Match / Index )  0.5685
Total Execution Time  0.5694
  CADENA URL  
/partido/Villacanas/Socuellamos
  GET DATOS  
$_GET['/partido/Villacanas/Socuellamos']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (11)  
0.0125  SELECT data1 FROM stats2024 t WHERE league_id = 72278 AND teamId = 6586471 and type = 33
0.0124  SELECT data1 FROM stats2024 t WHERE league_id = 72278 AND teamId = 6586467 and type = 33
0.0126  SELECT p.* FROM `videos` as p INNER JOIN `rel_videos` as rp ON p.id = rp.id_video WHERE rp.id_content = '480771' 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 = 480771 AND year = 2024 AND channel = 'Footters' LIMIT 1
0.0125  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 480771 AND year = 2024 AND channel = 'Footters' LIMIT 1
0.0129  SELECT `id`, `text` FROM `matchs_news_keys` WHERE `match_id`='480771' AND `active` = 1 AND year = 2024
0.0272  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='72278' AND relp.team_id=6586471 WHERE relp.in_squad=1 and mp.`match_id` = '480771' AND mp.year='2024' ORDER BY mp.`team` ASC, p.`role` ASC
0.0263  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='72278' AND relp.team_id=6586467 WHERE relp.in_squad=1 and mp.`match_id` = '480771' 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=480771 AND extraId = 72278 AND type_rel = 4
0.0129  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2470 AND type_rel = 3
0.0128  SELECT * FROM futbol.calendars_lineups WHERE id = 480771 AND league_id = 72278 AND year = 2024