4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Alianza Lima - Barcelona SC
1/32 Final
FINALIZADO
41
10
533 Pts. Elo

682 Pts. Elo

0-0
Jueves, 28 Agosto 2014, 04:00

Eventos del partido

Tarjetas

J. AtocheT. Amarilla
J. Atoche
minuto 12'
minuto 38'A. BolañosT. Amarilla A. Bolaños
M. GuevgeoziánT. Amarilla
M. Guevgeozián
minuto 40'
L. TrujilloT. Amarilla
L. Trujillo
minuto 52'
J. Atoche2a Amarilla y Roja
J. Atoche
minuto 80'

Cambios

minuto 62'M. MartínezSale del partido M. Martínez
minuto 62'F. CaicedoEntra en el partido F. Caicedo
V. CedrónEntra en el partido
V. Cedrón
minuto 64'
P. AlbarracínSale del partido
P. Albarracín
minuto 64'
minuto 65'C. SuárezSale del partido C. Suárez
minuto 65'M. QuiñónezEntra en el partido M. Quiñónez
G. CostaSale del partido
G. Costa
minuto 72'
M. MontesEntra en el partido
M. Montes
minuto 72'
minuto 77'C. PenillaSale del partido C. Penilla
minuto 77'J. DomínguezEntra en el partido J. Domínguez
W. AguirreSale del partido
W. Aguirre
minuto 86'
Jorge MolinaEntra en el partido
Jorge Molina
minuto 86'

Alineaciones

Alianza Lima

Alianza Lima

4-5-1
Alineación Inicial
Suplentes
Barcelona SC

Barcelona SC

4-5-1
Alineación Inicial
Suplentes



  USO DE MEMORIA  
5,883,504 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0010
Controller Execution Time ( Match / Index )  0.1499
Total Execution Time  0.1510
  CADENA URL  
/partido/Alianza-Lima/Barcelona-Guayaquil/2014
  GET DATOS  
$_GET['/partido/Alianza-Lima/Barcelona-Guayaquil/2014']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (12)  
0.0020  SELECT data1 FROM stats2014 t WHERE league_id = 3861 AND teamId = 71109 and type = 33
0.0019  SELECT data1 FROM stats2014 t WHERE league_id = 3861 AND teamId = 74186 and type = 33
0.0022  SELECT p.* FROM `videos` as p INNER JOIN `rel_videos` as rp ON p.id = rp.id_video WHERE rp.id_content = '193543' and rp.type = 2014 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 = 193543 AND year = 2014 AND channel = 'Footters' LIMIT 1
0.0019  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 193543 AND year = 2014 AND channel = 'Footters' LIMIT 1
0.0018  SELECT `id`, `text` FROM `matchs_news_keys` WHERE `match_id`='193543' AND `active` = 1 AND year = 2014
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='3861' AND relp.team_id=71109 WHERE relp.in_squad=1 and mp.`match_id` = '193543' AND mp.year='2014' ORDER BY mp.`team` ASC, p.`role` ASC
0.0029  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='3861' AND relp.team_id=74186 WHERE relp.in_squad=1 and mp.`match_id` = '193543' AND mp.year='2014' ORDER BY mp.`team` ASC, p.`role` ASC
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=193543 AND extraId = 3861 AND type_rel = 4
0.0018  SELECT position FROM tables2014 WHERE team=71109 AND league_id=3861 AND round=1
0.0018  SELECT position FROM tables2014 WHERE team=74186 AND league_id=3861 AND round=1
0.0018  SELECT * FROM futbol.calendars_lineups WHERE id = 193543 AND league_id = 3861 AND year = 2014