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

Estadísticas

ENTRA
Ez Abde17
Fermín López16
Lamine Yamal15
Ferran Torres13
Oriol Romeu13
Raphinha10
Vitor Roque9
João Félix7
Íñigo Martínez6
Pedri5
Jules Koundé3
Álex Balde3
Ronald Araujo3
Ansu Fati3
R. Lewandowski3
İ. Gündoğan3
João Cancelo2
Sergi Roberto2
Héctor Fort2
Eric García2
Marcos Alonso2
Marc Guiu2
Marc Casadó2
Gavi2
A. Christensen1
Pau Cubarsí1

  USO DE MEMORIA  
6,322,896 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0015
Controller Execution Time ( Home / Category )  0.1962
Total Execution Time  0.1977
  CADENA URL  
/estadisticas/Barcelona
  GET DATOS  
$_GET['/estadisticas/Barcelona']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (4)  
0.0192  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 = '429' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0188  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 = 429 AND (e.action = 22) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0194  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 = 429 AND (e.action = 19) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0192  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 = 429 AND (e.action = 18) GROUP BY p.id ORDER BY total DESC LIMIT 30