Web
            Analytics
  • Mié 21 Sep 21:00finalizado1
  • 1

GOLES

36
G. Fernández
R. Caroca
Gol

R. Caroca

81

TARJETAS

23
T. Amarilla

J. Zacaria

J. Zacaria
34
T. Amarilla

L. Reyes

L. Reyes
E. Guerrero
T. Amarilla

E. Guerrero

38
R. Naranjo
T. Amarilla

R. Naranjo

44
49
2a Amarilla y Roja

L. Reyes

L. Reyes
T. Charles
T. Amarilla

T. Charles

55
M. Dávila
T. Amarilla

M. Dávila

78

SUSTITUCIONES

F. Reynero
Entra

F. Reynero

46
D. Torres
Sale del partido

D. Torres

46
52
Entra

S. Martínez

S. Martínez
52
Sale del partido

G. Fernández

G. Fernández
Á. Ramos
Entra

Á. Ramos

58
J. Rebolledo
Sale del partido

J. Rebolledo

58
60
Entra

R. Ureña

R. Ureña
60
Sale del partido

Y. Leiva

Y. Leiva
L. Bustamante
70
M. Cubillos
Sale del partido

M. Cubillos

70
79
Entra

F. Schultz

F. Schultz
79
Sale del partido

J. Zacaria

J. Zacaria


  USO DE MEMORIA  
3,582,136 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0050
Controller Execution Time ( Match / Index )  0.0780
Total Execution Time  0.0831
  CADENA URL  
/partido/Deportes-Iquique/Universidad-Chile/2017
  GET DATOS  
$_GET['/partido/Deportes-Iquique/Universidad-Chile/2017']  
$_GET['completed']  
$_GET['clang']  
$_GET['isocode']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (2)  
0.0029   SELECT c.*, 2017 AS year, dt1.id AS dteam1_id, dt1.nameShow as team1_name, dt1.basealias AS team1_basealias, dt1.fullName as team1_fullName, dt1.color1 AS team1_color1, dt1.stadium, dt1.seats, dt1.size, dt1.yearBuilt,dt1.short_name AS local_abbr, dt2.short_name AS visitor_abbr, dt2.id AS dteam2_id, dt2.nameShow as team2_name, dt2.basealias AS team2_basealias, dt2.fullName as team2_fullName, dt2.color1 AS team2_color1, t1.name as team1_Oname, t2.name as team2_Oname, s.id as stadium_id, s.team_id as stadium_team_id, s.name AS stadium_name, s.size AS stadium_size, s.seats AS stadium_seats, s.yearBuilt AS stadium_yearBuilt FROM calendars2017 AS c INNER JOIN teams as t1 ON c.team1=t1.id INNER JOIN datateams AS dt1 ON t1.teamId=dt1.id INNER JOIN teams as t2 ON c.team2=t2.id INNER JOIN datateams AS dt2 ON t2.teamId=dt2.id LEFT JOIN stadiums AS s ON c.stadium=s.id WHERE c.extra != 1 AND dt1.basealias = 'Deportes-Iquique' AND dt2.basealias = 'Universidad-Chile'
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=253384 AND extraId = 33421 AND type_rel = 4