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

Estadísticas

ASISTENCIAS
Mikel Goti8
Jon Balda3
Ekain Azkune3
Iñaki Rupérez2
Yago Cantero2
Pablo Marín2
Unax Agote1
Peru Rodríguez1
Andoni Arzak1
J. Gorrotxategi1
Bryan Fiabema1
Alberto Dadie1
J. Magunazelaia1
A. Mariezkurrena1
Ander Zoilo1
ENTRA
A. Mariezkurrena16
Eder García15
E. Orobengoa15
Job Ochieng13
Mikel Rodriguez10
Alberto Dadie10
Unax Agote10
Andoni Arzak8
Luken Beitia8
Ander Zoilo7
Alex Lebarbier7
Jon Aramburu5
Peru Rodríguez5
Iñaki Rupérez5
Ekain Azkune4
Jon Balda4
Jon Merino3
Bryan Fiabema3
Ibra Camara3
Mikel Goti2
Darío Ramírez2
Yago Cantero1
E. Astigarraga1
SALE
Bryan Fiabema20
Mikel Goti17
Ekain Azkune15
Alberto Dadie14
Jon Balda9
Unax Agote9
Eder García8
Iñaki Rupérez7
Ander Zoilo7
Mikel Rodriguez6
J. Magunazelaia6
Pablo Marín6
Jon Aramburu5
Peru Rodríguez5
Job Ochieng3
Luken Beitia3
E. Orobengoa3
Ibra Camara3
A. Mariezkurrena2
J. Gorrotxategi2
Jon Martín2
Alex Lebarbier2
Yago Cantero1

  USO DE MEMORIA  
5,302,328 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.1663
Total Execution Time  0.1682
  CADENA URL  
/estadisticas/Real-Sociedad-B
  GET DATOS  
$_GET['/estadisticas/Real-Sociedad-B']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (4)  
0.0133  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 = '2121' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0141  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 = 72358 WHERE rp.league_id = 72358 AND rp.teamId = 2121 AND (e.action = 22) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0139  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 = 72358 WHERE rp.league_id = 72358 AND rp.teamId = 2121 AND (e.action = 19) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0138  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 = 72358 WHERE rp.league_id = 72358 AND rp.teamId = 2121 AND (e.action = 18) GROUP BY p.id ORDER BY total DESC LIMIT 30