4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
CD Futbol Tres Cantos B - CD Electrocor CF
Jornada 20
FINALIZADO
61
50
14 Pts. Elo
10º

23 Pts. Elo
1º

1-3
Domingo, 11 Febrero 2024, 12:00
0 - 1
 44' A. Garcia
O. Alasil 45'
1 - 1
1 - 2
 62' L. Echevarrieta
1 - 3
 64' L. Echevarrieta

Eventos del partido

Goles

minuto 44'A. GarciaGol de A. Garcia
O. AlasilGol de
O. Alasil
minuto 45'
minuto 62'L. EchevarrietaGol de L. Echevarrieta
minuto 64'L. EchevarrietaGol de L. Echevarrieta

Tarjetas

minuto 27'G. LanagranT. Amarilla G. Lanagran
minuto 49'ReviejoT. Amarilla Reviejo
minuto 53'JaimeT. Amarilla Jaime
L. GonzalezT. Amarilla
L. Gonzalez
minuto 53'
M. ManzanoT. Amarilla
M. Manzano
minuto 59'
D. De La FuenteT. Amarilla
D. De La Fuente
minuto 64'
minuto 65'A. GarciaT. Amarilla A. Garcia
A. OñateT. Amarilla
A. Oñate
minuto 70'
JesúsT. Amarilla
Jesús
minuto 71'
minuto 74'ElizagaT. Amarilla Elizaga
JesúsTarjeta Roja a
Jesús
minuto 81'
Adrian RuizT. Amarilla
Adrian Ruiz
minuto 93'

Cambios

minuto 46'Victor SalcedoSale del partido Victor Salcedo
minuto 46'R. PenabellaEntra en el partido R. Penabella
minuto 46'G. LanagranSale del partido G. Lanagran
minuto 46'ArroyoEntra en el partido Arroyo
minuto 60'ReviejoSale del partido Reviejo
minuto 60'J. EscuderoEntra en el partido J. Escudero
Adrian RuizEntra en el partido
Adrian Ruiz
minuto 73'
A. De ApraizSale del partido
A. De Apraiz
minuto 73'
minuto 75'P. SanSale del partido P. San
minuto 75'J. AngelEntra en el partido J. Angel
R. NogueroEntra en el partido
R. Noguero
minuto 79'
JesúsSale del partido
Jesús
minuto 79'
D. De La FuenteSale del partido
D. De La Fuente
minuto 79'
G. UzcateguiEntra en el partido
G. Uzcategui
minuto 79'
minuto 84'J. GonzalezEntra en el partido J. Gonzalez
minuto 84'A. GarciaSale del partido A. Garcia
minuto 84'L. EchevarrietaSale del partido L. Echevarrieta
minuto 84'G. AlvarezEntra en el partido G. Alvarez
R. VarelaEntra en el partido
R. Varela
minuto 87'
O. AlasilSale del partido
O. Alasil
minuto 87'

Alineaciones

CD Futbol Tres Cantos B

CD Futbol Tres Cantos B

4-4-2
Alineación Inicial
Suplentes
CD Electrocor CF

CD Electrocor CF

4-4-2
Alineación Inicial
Suplentes



  USO DE MEMORIA  
7,027,184 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0010
Controller Execution Time ( Match / Index )  0.3577
Total Execution Time  0.3587
  CADENA URL  
/partido/Cd-Futbol-Tres-Cantos-B/Electrocor-Senior/2024
  GET DATOS  
$_GET['/partido/Cd-Futbol-Tres-Cantos-B/Electrocor-Senior/2024']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (14)  
0.0018  SELECT data1 FROM stats2024 t WHERE league_id = 73663 AND teamId = 6606373 and type = 33
0.0018  SELECT data1 FROM stats2024 t WHERE league_id = 73663 AND teamId = 6606374 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 = '518737' 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 = 518737 AND year = 2024 AND channel = 'Footters' LIMIT 1
0.0018  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 518737 AND year = 2024 AND channel = 'Footters' LIMIT 1
0.0019  SELECT `id`, `text` FROM `matchs_news_keys` WHERE `match_id`='518737' AND `active` = 1 AND year = 2024
0.0033  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='73663' AND relp.team_id=6606373 WHERE relp.in_squad=1 and mp.`match_id` = '518737' AND mp.year='2024' ORDER BY mp.`team` ASC, p.`role` ASC
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='73663' AND relp.team_id=6606374 WHERE relp.in_squad=1 and mp.`match_id` = '518737' AND mp.year='2024' ORDER BY mp.`team` ASC, p.`role` ASC
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=518737 AND extraId = 73663 AND type_rel = 4
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=690 AND type_rel = 3
0.0020  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 690 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 (973908,950677,939069,907708,889402) ORDER BY n.cover_points DESC, update_date DESC
0.0018  SELECT rating1, rating2 FROM calendars_elo WHERE id=518737 AND league_id=73663 AND year=2024
0.0018  SELECT * FROM futbol.calendars_lineups WHERE id = 518737 AND league_id = 73663 AND year = 2024