4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Racing Ferrol - RM Castilla
Jornada 66
FINALIZADO
00
00
807 Pts. Elo

708 Pts. Elo

2-1
Sábado, 05 Agosto 2023, 19:00
Carlos Vicente 9'
1 - 0
1 - 1
 13' Vinicius Tobias
Carlos Vicente 29'
2 - 1

Eventos del partido

Goles

Carlos VicenteGol de
Carlos Vicente
minuto 9'
minuto 13'Vinicius TobiasGol de penalti Vinicius Tobias
Carlos VicenteGol de
Carlos Vicente
minuto 29'

Cambios

minuto 46'Yeray LanchaEntra en el partido Yeray Lancha
minuto 46'César PalaciosEntra en el partido César Palacios
minuto 46'Edgar PujolEntra en el partido Edgar Pujol
minuto 46'Raúl AsencioEntra en el partido Raúl Asencio
minuto 46'Noel LópezSale del partido Noel López
minuto 46'Gonzalo GarcíaSale del partido Gonzalo García
minuto 46'Manuel ÁngelSale del partido Manuel Ángel
minuto 46'Álvaro CarrilloSale del partido Álvaro Carrillo
minuto 60'E. AparicioEntra en el partido E. Aparicio
minuto 60'Borja AlonsoEntra en el partido Borja Alonso
minuto 60'Andrés CamposEntra en el partido Andrés Campos
minuto 60'Jacobo RamónEntra en el partido Jacobo Ramón
minuto 60'David JiménezEntra en el partido David Jiménez
minuto 60'David RuizEntra en el partido David Ruiz
minuto 60'G. SúnicoEntra en el partido G. Súnico
minuto 60'Ángel CarvajalSale del partido Ángel Carvajal
minuto 60'PeterSale del partido Peter
minuto 60'Theo ZidaneSale del partido Theo Zidane
minuto 60'Vinicius TobiasSale del partido Vinicius Tobias
minuto 60'Rafael ObradorSale del partido Rafael Obrador
minuto 60'MarvelSale del partido Marvel
minuto 60'Lucas CañizaresSale del partido Lucas Cañizares

Alineaciones

Racing Ferrol

Racing Ferrol

4-4-2
Alineación Inicial
RM Castilla

RM Castilla

4-4-2
Alineación Inicial
Suplentes



  USO DE MEMORIA  
6,659,064 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0010
Controller Execution Time ( Match / Index )  0.3728
Total Execution Time  0.3738
  CADENA URL  
/partido/Racing-Club-Ferrol/Rm-Castilla
  GET DATOS  
$_GET['/partido/Racing-Club-Ferrol/Rm-Castilla']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (15)  
0.0017  SELECT data1 FROM stats2024 t WHERE league_id = 71432 AND teamId = 6587941 and type = 33
0.0017  SELECT data1 FROM stats2024 t WHERE league_id = 71432 AND teamId = 6589661 and type = 33
0.0020  SELECT p.* FROM `videos` as p INNER JOIN `rel_videos` as rp ON p.id = rp.id_video WHERE rp.id_content = '117422' 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 = 117422 AND year = 2024 AND channel = 'Footters' LIMIT 1
0.0017  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 117422 AND year = 2024 AND channel = 'Footters' LIMIT 1
0.0018  SELECT `id`, `text` FROM `matchs_news_keys` WHERE `match_id`='117422' AND `active` = 1 AND year = 2024
0.0075  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='71432' AND relp.team_id=6587941 WHERE relp.in_squad=1 and mp.`match_id` = '117422' AND mp.year='2024' ORDER BY mp.`team` ASC, p.`role` ASC
0.0069  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='71432' AND relp.team_id=6589661 WHERE relp.in_squad=1 and mp.`match_id` = '117422' 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=117422 AND extraId = 71432 AND type_rel = 4
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=153 AND type_rel = 3
0.0095  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 153 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0021  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 (1312034,1307741,1307681,1307639,1307019) ORDER BY n.cover_points DESC, update_date DESC
0.0017  SELECT position FROM tables2024 WHERE team=6587941 AND league_id=71432 AND round=66
0.0017  SELECT position FROM tables2024 WHERE team=6589661 AND league_id=71432 AND round=66
0.0017  SELECT * FROM futbol.calendars_lineups WHERE id = 117422 AND league_id = 71432 AND year = 2024