4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Torino - Genoa
Jornada 14
FINALIZADO
10
40
2049 Pts. Elo
12º

1500 Pts. Elo
14º

1-1
Domingo, 02 Diciembre 2007, 20:30
  • Asistencia: 18.404 espectadores
0 - 1
 47' M. Borriello
Lanna 55'
1 - 1

Eventos del partido

Goles

minuto 47'M. BorrielloGol de M. Borriello
LannaGol de
Lanna
minuto 55'

Tarjetas

minuto 46'FabianoT. Amarilla Fabiano
minuto 46'F. BegaT. Amarilla F. Bega
minuto 46'Gleison SantosT. Amarilla Gleison Santos
minuto 46'A. KonkoT. Amarilla A. Konko
Paolo ZanettiT. Amarilla
Paolo Zanetti
minuto 46'

Cambios

minuto 46'J. De LeónEntra en el partido J. De León
minuto 46'P. WaigoSale del partido P. Waigo
N. VentolaEntra en el partido
N. Ventola
minuto 51'
Álvaro RecobaSale del partido
Álvaro Recoba
minuto 51'
minuto 56'M. Di VaioSale del partido M. Di Vaio
minuto 56'G. SculliEntra en el partido G. Sculli
A. RosinaSale del partido
A. Rosina
minuto 81'
D. MalongaEntra en el partido
D. Malonga
minuto 81'
minuto 82'FabianoSale del partido Fabiano
minuto 82'Gleison SantosEntra en el partido Gleison Santos
D. Di MicheleSale del partido
D. Di Michele
minuto 87'
M. MottaEntra en el partido
M. Motta
minuto 87'

Otros

minuto 47'FabianoAsistencia Fabiano

Alineaciones

Torino

Torino

4-4-2
Alineación Inicial
Suplentes
Genoa

Genoa

5-3-2
Alineación Inicial
Suplentes



  USO DE MEMORIA  
5,988,664 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0009
Controller Execution Time ( Match / Index )  0.0878
Total Execution Time  0.0888
  CADENA URL  
/partido/Torino-Fc/Genoa/2008
  GET DATOS  
$_GET['/partido/Torino-Fc/Genoa/2008']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (8)  
0.0020  SELECT p.* FROM `videos` as p INNER JOIN `rel_videos` as rp ON p.id = rp.id_video WHERE rp.id_content = '9423' and rp.type = 2008 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 = 9423 AND year = 2008 AND channel = 'Footters' LIMIT 1
0.0017  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 9423 AND year = 2008 AND channel = 'Footters' LIMIT 1
0.0018  SELECT `id`, `text` FROM `matchs_news_keys` WHERE `match_id`='9423' AND `active` = 1 AND year = 2008
0.0032  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='27' AND relp.team_id=2035 WHERE relp.in_squad=1 and mp.`match_id` = '9423' AND mp.year='2008' ORDER BY mp.`team` ASC, p.`role` ASC
0.0027  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='27' AND relp.team_id=2038 WHERE relp.in_squad=1 and mp.`match_id` = '9423' AND mp.year='2008' ORDER BY mp.`team` ASC, p.`role` ASC
0.0017  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=9423 AND extraId = 27 AND type_rel = 4
0.0017  SELECT * FROM futbol.calendars_lineups WHERE id = 9423 AND league_id = 27 AND year = 2008