4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Almudévar - Deportivo Aragón
Jornada 31
FINALIZADO
80
40
283 Pts. Elo

371 Pts. Elo

0-0
Domingo, 08 Marzo 2020, 16:30

Eventos del partido

Tarjetas

S. HernándezT. Amarilla
S. Hernández
minuto 35'
SalcedoT. Amarilla
Salcedo
minuto 54'
IsraelT. Amarilla
Israel
minuto 57'
AinozaT. Amarilla
Ainoza
minuto 61'
D. PaulesT. Amarilla
D. Paules
minuto 73'
minuto 78'Marc AguadoT. Amarilla Marc Aguado
AlexT. Amarilla
Alex
minuto 78'
SiroT. Amarilla
Siro
minuto 78'
minuto 79'MarioT. Amarilla Mario
minuto 81'Iván CastilloT. Amarilla Iván Castillo
minuto 88'J. HernándezT. Amarilla J. Hernández
TrujilloT. Amarilla
Trujillo
minuto 89'

Cambios

minuto 18'David VicenteSale del partido David Vicente
minuto 18'Arnau GaixasEntra en el partido Arnau Gaixas
IsraelSale del partido
Israel
minuto 59'
TrujilloEntra en el partido
Trujillo
minuto 59'
minuto 72'ForcénEntra en el partido Forcén
minuto 72'A. BelhadjiSale del partido A. Belhadji
S. HernándezSale del partido
S. Hernández
minuto 73'
AlexEntra en el partido
Alex
minuto 73'
minuto 83'Carlos VicenteSale del partido Carlos Vicente
minuto 83'Jaime SanchoEntra en el partido Jaime Sancho
GallegoEntra en el partido
Gallego
minuto 84'
J. BenoitSale del partido
J. Benoit
minuto 84'

Alineaciones

Almudévar

Almudévar

4-4-2
Alineación Inicial
Suplentes
Deportivo Aragón

Deportivo Aragón

4-4-2
Alineación Inicial
Suplentes



  USO DE MEMORIA  
6,758,840 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0011
Controller Execution Time ( Match / Index )  0.3401
Total Execution Time  0.3412
  CADENA URL  
/partido/Almudevar/Real-Zaragoza-B/2020
  GET DATOS  
$_GET['/partido/Almudevar/Real-Zaragoza-B/2020']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (10)  
0.0018  SELECT data1 FROM stats2020 t WHERE league_id = 50285 AND teamId = 6294554 and type = 33
0.0017  SELECT data1 FROM stats2020 t WHERE league_id = 50285 AND teamId = 6294566 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 = '115705' and rp.type = 2020 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 = 115705 AND year = 2020 AND channel = 'Footters' LIMIT 1
0.0049  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 115705 AND year = 2020 AND channel = 'Footters' LIMIT 1
0.0018  SELECT `id`, `text` FROM `matchs_news_keys` WHERE `match_id`='115705' AND `active` = 1 AND year = 2020
0.0034  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='50285' AND relp.team_id=6294554 WHERE relp.in_squad=1 and mp.`match_id` = '115705' AND mp.year='2020' ORDER BY mp.`team` ASC, p.`role` ASC
0.0027  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='50285' AND relp.team_id=6294566 WHERE relp.in_squad=1 and mp.`match_id` = '115705' AND mp.year='2020' ORDER BY mp.`team` ASC, p.`role` ASC
0.0019  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=115705 AND extraId = 50285 AND type_rel = 4
0.0018  SELECT * FROM futbol.calendars_lineups WHERE id = 115705 AND league_id = 50285 AND year = 2020