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

Estadísticas

ASISTENCIAS
Cristian Rodríguez9
H. Medunjanin6
Raúl Sánchez6
Jesús De Miguel5
Iago Indias4
Óscar Gil3
Sergio Moyita3
Israel Suero3
Manu Sánchez3
Javi Antón2
D. Villahermosa2
Salva Ruiz2
Douglas Aurelio1
Jeremy De León1
M. Traoré1
N. Iosifov1
Borja Granero1
Gonzalo1
D. Chirino1
ENTRA
Jeremy De León15
D. Villahermosa12
G. Kastaneer12
J. Vertrouwd11
Borja Granero10
Sergio Moyita9
N. Iosifov9
D. Chirino8
Julio Gracia7
Israel Suero7
Raúl Sánchez5
Óscar Gil5
S. Grønning5
Iago Indias5
M. Traoré5
J. Calavera4
Alberto4
Javi Antón4
Cristian Rodríguez4
Manu Sánchez4
Douglas Aurelio4
Salva Ruiz2
Miguel Falé2
A. Lottin2
L. Veldwijk2
H. Medunjanin2
S. Miñana1
Carles Salvador1
Jesús De Miguel1
Iker Punzano1
SALE
Manu Sánchez21
Cristian Rodríguez17
Raúl Sánchez16
H. Medunjanin15
Sergio Moyita12
Julio Gracia11
Iago Indias9
Salva Ruiz9
D. Villahermosa9
Jesús De Miguel7
D. Chirino6
J. Calavera6
Israel Suero5
Alberto5
Óscar Gil4
A. Lottin4
Douglas Aurelio4
Javi Antón3
M. Traoré3
J. Vertrouwd1
S. Grønning1
Borja Granero1
N. Iosifov1

  USO DE MEMORIA  
5,526,704 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0013
Controller Execution Time ( Home / Category )  0.1916
Total Execution Time  0.1929
  CADENA URL  
/estadisticas/Cd-Castellon/2024
  GET DATOS  
$_GET['/estadisticas/Cd-Castellon/2024']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (6)  
0.0138  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 673 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0127  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 (1095874,3254,4331,5525,7135) ORDER BY n.cover_points DESC, update_date DESC
0.0150  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 = '673' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0155  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 = 673 AND (e.action = 22) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0145  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 = 673 AND (e.action = 19) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0144  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 = 673 AND (e.action = 18) GROUP BY p.id ORDER BY total DESC LIMIT 30