4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Tiro Federal Rosario - Unión Mar del Plata
Jornada 5
FINALIZADO
00
00
676 Pts. Elo
4º

409 Pts. Elo
1º

1-1
Viernes, 19 Septiembre 2014, 21:30
0 - 1
 86' W. Albarracín
J. Fernández 90'
1 - 1

Eventos del partido

Goles

minuto 86'W. AlbarracínGol de W. Albarracín
J. FernándezGol de
J. Fernández
minuto 90'

Cambios

minuto 60'N. RamírezEntra en el partido N. Ramírez
minuto 60'N. SantosSale del partido N. Santos
S. BattagliaSale del partido
S. Battaglia
minuto 65'
J. FernándezEntra en el partido
J. Fernández
minuto 65'
minuto 77'L. De FrancescoSale del partido L. De Francesco
minuto 77'M. PlantéEntra en el partido M. Planté
P. CucchiSale del partido
P. Cucchi
minuto 83'
Nicolás IbáñezEntra en el partido
Nicolás Ibáñez
minuto 83'
minuto 87'L. FormaggioniEntra en el partido L. Formaggioni
minuto 87'W. AlbarracínSale del partido W. Albarracín

Alineaciones

Tiro Federal Rosario

Tiro Federal Rosario

4-4-2
Alineación Inicial
Suplentes
Unión Mar del Plata

Unión Mar del Plata

4-4-2
Alineación Inicial
Suplentes



  USO DE MEMORIA  
5,689,136 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0011
Controller Execution Time ( Match / Index )  0.3486
Total Execution Time  0.3497
  CADENA URL  
/partido/Tiro-Federal/Union-Mar/2015
  GET DATOS  
$_GET['/partido/Tiro-Federal/Union-Mar/2015']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (11)  
0.0150  SELECT p.* FROM `videos` as p INNER JOIN `rel_videos` as rp ON p.id = rp.id_video WHERE rp.id_content = '32447' and rp.type = 2015 and p.revised = 1 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0148  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 32447 AND year = 2015 AND channel = 'Footters' LIMIT 1
0.0146  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 32447 AND year = 2015 AND channel = 'Footters' LIMIT 1
0.0149  SELECT `id`, `text` FROM `matchs_news_keys` WHERE `match_id`='32447' AND `active` = 1 AND year = 2015
0.0257  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='3991' AND relp.team_id=73618 WHERE relp.in_squad=1 and mp.`match_id` = '32447' AND mp.year='2015' ORDER BY mp.`team` ASC, p.`role` ASC
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='3991' AND relp.team_id=73615 WHERE relp.in_squad=1 and mp.`match_id` = '32447' AND mp.year='2015' ORDER BY mp.`team` ASC, p.`role` ASC
0.0145  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=32447 AND extraId = 3991 AND type_rel = 4
0.0145  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1724 AND type_rel = 3
0.0147  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 1724 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0147  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 (1062803,1015438,942145,877564,861297) ORDER BY n.cover_points DESC, update_date DESC
0.0144  SELECT * FROM futbol.calendars_lineups WHERE id = 32447 AND league_id = 3991 AND year = 2015