4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Atl. Astorga - Burgos CF B
Jornada 34
FINALIZADO
10
00
169 Pts. Elo
5º

91 Pts. Elo
13º

0-0
Domingo, 12 Mayo 2024, 18:00

Eventos del partido

Tarjetas

Sergio FernándezT. Amarilla
Sergio Fernández
minuto 68'

Cambios

minuto 46'Samu RodríguezEntra en el partido Samu Rodríguez
minuto 46'A. JuárezSale del partido A. Juárez
Pablo QuintanaSale del partido
Pablo Quintana
minuto 57'
J. MisffutEntra en el partido
J. Misffut
minuto 57'
minuto 62'E. VentosaEntra en el partido E. Ventosa
minuto 62'Pablo ArranzEntra en el partido Pablo Arranz
Mario PresaEntra en el partido
Mario Presa
minuto 62'
minuto 62'Sergio FernándezSale del partido Sergio Fernández
minuto 62'Del MonteSale del partido Del Monte
Javi AmorSale del partido
Javi Amor
minuto 62'
AritzEntra en el partido
Aritz
minuto 71'
LorentoSale del partido
Lorento
minuto 71'

Alineaciones

Atl. Astorga

Atl. Astorga

4-4-2
Alineación Inicial
Suplentes
Burgos CF B

Burgos CF B

4-4-2
Alineación Inicial
Suplentes



  USO DE MEMORIA  
6,622,584 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0010
Controller Execution Time ( Match / Index )  0.2359
Total Execution Time  0.2369
  CADENA URL  
/partido/Atletico-Astorga/Burgos-Promesas/2017?section=legal
  GET DATOS  
$_GET['/partido/Atletico-Astorga/Burgos-Promesas/2017']  
$_GET['section']   legal
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (11)  
0.0018  SELECT data1 FROM stats2024 t WHERE league_id = 72267 AND teamId = 6586237 and type = 33
0.0018  SELECT data1 FROM stats2024 t WHERE league_id = 72267 AND teamId = 6586241 and type = 33
0.0072  SELECT p.* FROM `videos` as p INNER JOIN `rel_videos` as rp ON p.id = rp.id_video WHERE rp.id_content = '442126' 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 = 442126 AND year = 2024 AND channel = 'Footters' LIMIT 1
0.0017  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 442126 AND year = 2024 AND channel = 'Footters' LIMIT 1
0.0018  SELECT `id`, `text` FROM `matchs_news_keys` WHERE `match_id`='442126' AND `active` = 1 AND year = 2024
0.0053  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='72267' AND relp.team_id=6586237 WHERE relp.in_squad=1 and mp.`match_id` = '442126' AND mp.year='2024' ORDER BY mp.`team` ASC, p.`role` ASC
0.0043  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='72267' AND relp.team_id=6586241 WHERE relp.in_squad=1 and mp.`match_id` = '442126' 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=442126 AND extraId = 72267 AND type_rel = 4
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2470 AND type_rel = 3
0.0019  SELECT * FROM futbol.calendars_lineups WHERE id = 442126 AND league_id = 72267 AND year = 2024