4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
JU Gualeguaychu - Ferro Carril Oeste
FINALIZADO
20
20
766 Pts. Elo
19º

1190 Pts. Elo

0-0
Miércoles, 02 Noviembre 2016, 18:30

Eventos del partido

Tarjetas

minuto 45'E. PérezT. Amarilla E. Pérez
minuto 51'D. MoralesT. Amarilla D. Morales
M. MarchesiniT. Amarilla
M. Marchesini
minuto 65'
C. PomboT. Amarilla
C. Pombo
minuto 70'

Cambios

minuto 26'R. AldereteSale del partido R. Alderete
minuto 26'D. MoralesEntra en el partido D. Morales
minuto 54'G. VernettiEntra en el partido G. Vernetti
minuto 54'E. PérezSale del partido E. Pérez
minuto 64'E. BorregoSale del partido E. Borrego
minuto 64'N. López MacriEntra en el partido N. López Macri
S. VelaEntra en el partido
S. Vela
minuto 74'
R. TesuriSale del partido
R. Tesuri
minuto 74'
G. AdaEntra en el partido
G. Ada
minuto 79'
C. PomboSale del partido
C. Pombo
minuto 79'

Alineaciones




  USO DE MEMORIA  
5,921,816 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0018
Controller Execution Time ( Match / Index )  0.1044
Total Execution Time  0.1062
  CADENA URL  
/partido/Juventud-Unida-Gualeguaychu/Ferro-Carril-Oeste/2017
  GET DATOS  
$_GET['/partido/Juventud-Unida-Gualeguaychu/Ferro-Carril-Oeste/2017']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (11)  
0.0018  SELECT data1 FROM stats2017 t WHERE league_id = 33440 AND teamId = 713291 and type = 33
0.0018  SELECT data1 FROM stats2017 t WHERE league_id = 33440 AND teamId = 713286 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 = '240551' and rp.type = 2017 and p.revised = 1 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0019  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 240551 AND year = 2017 AND channel = 'Footters' LIMIT 1
0.0018  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 240551 AND year = 2017 AND channel = 'Footters' LIMIT 1
0.0042  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2017` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 33440 AND t.round = 46 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0018  SELECT `id`, `text` FROM `matchs_news_keys` WHERE `match_id`='240551' AND `active` = 1 AND year = 2017
0.0066  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='33440' AND relp.team_id=713291 WHERE relp.in_squad=1 and mp.`match_id` = '240551' AND mp.year='2017' ORDER BY mp.`team` ASC, p.`role` ASC
0.0089  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='33440' AND relp.team_id=713286 WHERE relp.in_squad=1 and mp.`match_id` = '240551' AND mp.year='2017' ORDER BY mp.`team` ASC, p.`role` ASC
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=240551 AND extraId = 33440 AND type_rel = 4
0.0020  SELECT * FROM futbol.calendars_lineups WHERE id = 240551 AND league_id = 33440 AND year = 2017