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

Estadísticas

ASISTENCIAS
R. Del Castillo8
K. Doumbia4
Martín Satriano4
Steve Mounié2
M. Camara2
Kenny Lala2
B. Locko2
B. Chardonnet1
A. Lebeau1
Jonas Martin1
M. Pereira Lage1
ENTRA
Jonas Martin20
B. Brahimi18
K. Doumbia16
M. Pereira Lage15
Steve Mounié12
Martín Satriano12
J. Le Douaron11
J. Le Cardinal9
A. Camblan7
A. Lebeau6
M. Camara6
Achraf Dari3
H. Magnetti3
H. Mbock2
R. Del Castillo2
A. Cartillier1
C. Hérelle1
Luc Zogbé1
K. Dembélé1
G. Coudert1
SALE
R. Del Castillo25
M. Camara22
H. Magnetti21
J. Le Douaron16
Martín Satriano15
Steve Mounié13
M. Pereira Lage11
K. Doumbia7
Jonas Martin5
P. Lees Melou2
C. Hérelle2
L. Brassier1
J. Le Cardinal1
B. Locko1
B. Brahimi1

  USO DE MEMORIA  
5,170,312 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0011
Controller Execution Time ( Home / Category )  0.0667
Total Execution Time  0.0678
  CADENA URL  
/estadisticas/stade-brestois-29
  GET DATOS  
$_GET['/estadisticas/stade-brestois-29']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (8)  
0.0020  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2420 AND type_rel = 2
0.0032  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 2420 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0030  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 (75351,87276,163924,174245,241940) ORDER BY n.cover_points DESC, update_date DESC
0.0049  SELECT cat.logo,cat.official,cat.location,dt.nameShow,dt.basealias,t.teamId,l.year,t.qod,cat.coefficient,cat.active_year,cat.name,l.group_code,l.total_group,cat.alias,l.categoryId,l.year,l.id as league_id FROM datateams dt INNER JOIN teams t ON t.teamId = dt.id INNER JOIN leagues l ON l.id = t.league_id INNER JOIN categories cat ON cat.id = l.categoryId WHERE dt.id = '2420' ORDER BY l.year DESC,cat.coefficient DESC
0.0043  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 = '2420' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0061  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 = 72046 WHERE rp.league_id = 72046 AND rp.teamId = 2420 AND (e.action = 22) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0067  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 = 72046 WHERE rp.league_id = 72046 AND rp.teamId = 2420 AND (e.action = 19) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0062  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 = 72046 WHERE rp.league_id = 72046 AND rp.teamId = 2420 AND (e.action = 18) GROUP BY p.id ORDER BY total DESC LIMIT 30