4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Casa Pia AC - Torreense
Jornada 27
FINALIZADO
10
10
352 Pts. Elo

582 Pts. Elo

2-0
Domingo, 07 Abril 2013, 17:00
Nuno Almeida 8'
1 - 0
Nuno Almeida 90'
2 - 0

Eventos del partido

Goles

Nuno AlmeidaGol de
Nuno Almeida
minuto 8'
Nuno AlmeidaGol de
Nuno Almeida
minuto 90'

Tarjetas

minuto 53'André MandeiroT. Amarilla André Mandeiro
Vítor SanchesT. Amarilla
Vítor Sanches
minuto 89'

Cambios

minuto 54'Rui JanotaEntra en el partido Rui Janota
minuto 54'F. SantosSale del partido F. Santos
Tiago MendesSale del partido
Tiago Mendes
minuto 65'
MoisésEntra en el partido
Moisés
minuto 65'
Gonçalo ReyesEntra en el partido
Gonçalo Reyes
minuto 87'
Wilson KenidySale del partido
Wilson Kenidy
minuto 87'

Alineaciones

Casa Pia AC

Casa Pia AC

4-4-2
Alineación Inicial
Suplentes
Torreense

Torreense

4-4-2
Alineación Inicial
Suplentes



  USO DE MEMORIA  
5,746,856 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0011
Controller Execution Time ( Match / Index )  1.2237
Total Execution Time  1.2249
  CADENA URL  
/partido/Casa-Pia/Torreense/2013
  GET DATOS  
$_GET['/partido/Casa-Pia/Torreense/2013']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (9)  
0.0078  SELECT data1 FROM stats2013 t WHERE league_id = 2170 AND teamId = 45510 and type = 33
0.0030  SELECT p.* FROM `videos` as p INNER JOIN `rel_videos` as rp ON p.id = rp.id_video WHERE rp.id_content = '330153' and rp.type = 2013 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 = 330153 AND year = 2013 AND channel = 'Footters' LIMIT 1
0.0018  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 330153 AND year = 2013 AND channel = 'Footters' LIMIT 1
0.0131  SELECT `id`, `text` FROM `matchs_news_keys` WHERE `match_id`='330153' AND `active` = 1 AND year = 2013
0.5374  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='2170' AND relp.team_id=45510 WHERE relp.in_squad=1 and mp.`match_id` = '330153' AND mp.year='2013' ORDER BY mp.`team` ASC, p.`role` ASC
0.5821  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='2170' AND relp.team_id=45497 WHERE relp.in_squad=1 and mp.`match_id` = '330153' AND mp.year='2013' ORDER BY mp.`team` ASC, p.`role` ASC
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=330153 AND extraId = 2170 AND type_rel = 4
0.0017  SELECT * FROM futbol.calendars_lineups WHERE id = 330153 AND league_id = 2170 AND year = 2013