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

  USO DE MEMORIA  
5,329,648 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.2703
Total Execution Time  0.2715
  CADENA URL  
/estadisticas/At-Madrid-B
  GET DATOS  
$_GET['/estadisticas/At-Madrid-B']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (16)  
0.0106  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=323 AND type_rel = 2
0.0112  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.0108  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.0117  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.0128  SELECT t.id as team_id, ct.id, l.id as idLeague, l.year, ct.name, l.start_date, l.end_date FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId INNER JOIN teams AS t ON l.id=t.league_id WHERE t.teamId=323 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0107  SELECT ct.id, ct.alias, ct.name AS name, ct.active_year, ct.coefficient AS coefficient, l.id AS league_id, l.year, l.total_group FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId WHERE l.id IN (72359,71617,71432,67969) ORDER BY ct.ctype != 12 DESC, ct.troncal DESC, ct.coefficient DESC, l.end_date >= NOW() DESC, l.start_date <= NOW() DESC, l.year DESC, ct.coefficient DESC, l.group_code ASC
0.0111  SELECT count(id) as num_players from rel_players WHERE league_id = 72359 AND teamId = 323
0.0111  SELECT count(id) as num_players from rel_players WHERE league_id = 67969 AND teamId = 323
0.0110  SELECT count(id) as num_players from rel_players WHERE league_id = 71617 AND teamId = 323
0.0116  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 323
0.0121  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 = 1 or e.action = 2 or e.action = 11 or e.action = 12 or e.action = 13) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0119  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 = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0116  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 = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0116  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.0118  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.0119  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