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

Estadísticas

ASISTENCIAS
R. Lewandowski8
Raphinha8
İ. Gündoğan6
João Félix3
Lamine Yamal3
João Cancelo3
Ferran Torres2
Jules Koundé2
Pedri2
A. Christensen2
Álex Balde1
Gavi1
Héctor Fort1
Oriol Romeu1
Sergi Roberto1
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
SALE
A. Christensen17
João Félix15
Pedri11
Raphinha10
Fermín López10
Oriol Romeu10
Lamine Yamal8
Ferran Torres7
R. Lewandowski7
João Cancelo6
İ. Gündoğan6
Ez Abde5
Sergi Roberto4
Álex Balde3
Pau Cubarsí3
F. De Jong3
Eric García3
Héctor Fort3
Jules Koundé2
Vitor Roque2
Marc Guiu1
Ronald Araujo1
Íñigo Martínez1
Marcos Alonso1
Gavi1

  USO DE MEMORIA  
6,296,888 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0016
Controller Execution Time ( Home / Category )  0.2334
Total Execution Time  0.2350
  CADENA URL  
/estadisticas/barcelona
  GET DATOS  
$_GET['/estadisticas/barcelona']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (7)  
0.0144  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=429 AND type_rel = 2
0.0156  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 429 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0147  SELECT /*35 bs_news_model*/ n.id, n.author_id, n.headline, n.external_headline, n.live_headline, n.creation_date, n.update_date, n.pub_date, n.alias, n.subheadline, n.teaser, n.media, n.tags, n.views, n.screens, n.clicks, n.relations, n.comments, n.power_cover, n.cover_points, u.name as user_name FROM bs_news n INNER JOIN bs_editors u ON u.id = n.author_id AND u.ln = 'es' WHERE n.status = 1 AND n.ln = 'es' AND n.id IN (1312336,1312332,1312325,1312270,1312211) ORDER BY n.cover_points DESC, update_date DESC
0.0174  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.0173  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.0171  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.0169  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