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

Estadísticas

ASISTENCIAS
N. Castro4
Manu Nieto3
Arnau Puigmal3
Josan2
Tete Morente2
Fidel2
C. Clerc2
Aleix Febas2
Pere Milla2
Sergio León1
P. Bigas1
Mourad1
Sergio Carreira1
Nico Fernández1
ENTRA
Sergio Bermejo25
Borja Garcés20
Sergio León20
Manu Nieto18
C. Salvador15
Rodrigo Mendoza11
J. Salinas10
Mourad10
Óscar Plano10
Fidel9
Aleix Febas9
Pere Milla8
N. Castro7
L. Blanco7
Raúl Guti7
Diego González7
Josan6
Adam Boayar5
Álex Martín5
Arnau Puigmal3
Sergio Carreira3
Tete Morente2
Rafa Nuñez2
Javier Pamies2
Nico Fernández1
John Chetauya1
Lucas Boyé1
David López1
SALE
Pere Milla20
Nico Fernández20
Mourad19
N. Castro15
Aleix Febas14
Fidel13
Óscar Plano12
Josan11
Tete Morente9
P. Bigas7
Mario Gaspar7
Manu Nieto7
Sergio Bermejo6
Sergio León6
Raúl Guti5
Rodrigo Mendoza5
Borja Garcés5
Arnau Puigmal5
Álex Martín4
L. Blanco3
J. Salinas3
Sergio Carreira2
C. Salvador2
Diego González1
Rafa Nuñez1
John Chetauya1
C. Clerc1

  USO DE MEMORIA  
5,614,800 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0017
Controller Execution Time ( Home / Category )  0.0781
Total Execution Time  0.0798
  CADENA URL  
/estadisticas/Elche/2024
  GET DATOS  
$_GET['/estadisticas/Elche/2024']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (7)  
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=975 AND type_rel = 2
0.0141  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 975 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0022  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 (1312875,1312694,1311805,1310966,1309597) ORDER BY n.cover_points DESC, update_date DESC
0.0047  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 = '975' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0041  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 = 72177 WHERE rp.league_id = 72177 AND rp.teamId = 975 AND (e.action = 22) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0045  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 = 72177 WHERE rp.league_id = 72177 AND rp.teamId = 975 AND (e.action = 19) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0038  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 = 72177 WHERE rp.league_id = 72177 AND rp.teamId = 975 AND (e.action = 18) GROUP BY p.id ORDER BY total DESC LIMIT 30