4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias

Estadísticas

ASISTENCIAS
Yan Couto8
Savinho7
Aleix García6
Artem Dovbyk5
Miguel Gutiérrez4
V. Tsygankov4
Portu4
C. Stuani2
Iván Martín2
Pablo Torre2
Daley Blind2
Arnau Martínez2
ENTRA
C. Stuani24
Valery21
Portu20
Pablo Torre18
Jhon Solis14
Juanpe9
Yan Couto7
Arnau Martínez4
Artem Dovbyk4
Iván Martín3
V. Tsygankov3
Y. Herrera2
Eric García2
I. Kébé2
Jastin García2
Bernardo2
Antal1
Silvi Clua1
Daley Blind1
Savinho1
SALE
Artem Dovbyk19
Iván Martín18
V. Tsygankov17
Savinho16
Y. Herrera13
Arnau Martínez8
David López8
Portu8
Yan Couto7
Pablo Torre5
C. Stuani5
Eric García3
Jhon Solis2
Valery2
Aleix García2
Daley Blind1
Miguel Gutiérrez1
Juanpe1

  USO DE MEMORIA  
5,465,952 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.0455
Total Execution Time  0.0468
  CADENA URL  
/estadisticas/girona-fc
  GET DATOS  
$_GET['/estadisticas/girona-fc']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (4)  
0.0046  SELECT SQL_NO_CACHE res.id as id, res.group_code, res.total_group, res.logo, res.alias FROM (SELECT ct.active_year, ct.id as id, l.year, l.end,l.group_code, l.total_group, ct.logo, ct.alias FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId AND ct.active_year=l.year INNER JOIN teams AS t ON l.id=t.league_id WHERE t.teamId = '1236' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0035  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2024 e ON e.player_id = p.id AND e.league_id = 72116 WHERE rp.league_id = 72116 AND rp.teamId = 1236 AND (e.action = 22) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0034  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2024 e ON e.player_id = p.id AND e.league_id = 72116 WHERE rp.league_id = 72116 AND rp.teamId = 1236 AND (e.action = 19) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0032  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2024 e ON e.player_id = p.id AND e.league_id = 72116 WHERE rp.league_id = 72116 AND rp.teamId = 1236 AND (e.action = 18) GROUP BY p.id ORDER BY total DESC LIMIT 30