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

Estadísticas

ASISTENCIAS
Cala7
Nabil Touaizi5
Salim El Jebari5
Diego Bri4
Pablo Pérez3
Mario Maroto2
Sergio Guerrero2
Javier Boñar2
Carlos Puga2
Alber Moreno1
Abde Raihani1
Mario Da Costa1
Aitor Gismera1
ENTRA
Cala18
A. Mestanza18
Joel Arumí15
Nabil Touaizi12
Abde Raihani12
Alber Moreno11
Adrián Niño10
Mario Maroto9
Carlos Puga8
Diego Bri7
Javier Boñar7
Sergio Guerrero7
Dani Martínez6
Lalo Aguilar5
Salim El Jebari5
Assane3
David Muñoz3
Rayane Belaid3
Mario Da Costa3
Mariano Gómez2
Gero Spina1
Marco Moreno1
Ilias Kostis1
Jano Monserrate1
Aitor Gismera1
R. Halhal1
SALE
Adrián Niño19
Salim El Jebari19
Diego Bri16
Assane14
Nabil Touaizi13
Alber Moreno11
Javier Boñar10
Sergio Guerrero10
Cala8
Pablo Pérez7
Carlos Puga6
Mario Maroto6
Abde Raihani6
Marco Moreno5
Mario Da Costa5
Joel Arumí5
Dani Martínez3
A. Mestanza3
Aitor Gismera3
Ilias Kostis2
Lalo Aguilar2
Darío Frey1

  USO DE MEMORIA  
5,313,216 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0018
Controller Execution Time ( Home / Category )  0.0499
Total Execution Time  0.0518
  CADENA URL  
/estadisticas/at-madrid-b
  GET DATOS  
$_GET['/estadisticas/at-madrid-b']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (7)  
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=323 AND type_rel = 2
0.0027  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 323 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0023  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 (1232199,719,4857,5025,20263) ORDER BY n.cover_points DESC, update_date DESC
0.0028  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 = '323' 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 = 72359 WHERE rp.league_id = 72359 AND rp.teamId = 323 AND (e.action = 22) GROUP BY p.id ORDER BY total DESC LIMIT 30
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 = 72359 WHERE rp.league_id = 72359 AND rp.teamId = 323 AND (e.action = 19) 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 = 72359 WHERE rp.league_id = 72359 AND rp.teamId = 323 AND (e.action = 18) GROUP BY p.id ORDER BY total DESC LIMIT 30