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

Estadísticas

ASISTENCIAS
A. Ömür6
Edin Višća5
Trezeguet4
Enis Bardhi4
Thomas Meunier4
E. Destan4
P. Onuachu3
A. Bakasetas2
Nicolas Pépé1
B. Özdemir1
T. Fountas1
ENTRA
E. Destan17
T. Fountas15
Umut Güneş12
Enis Bardhi9
Umut Bozok8
Tonio Teklic7
Mehmet Aydin7
Nicolas Pépé6
Trezeguet6
G. Gürpüz5
Joaquín Fernández5
Kerem Şen5
D. Kourbelis4
A. Bakasetas4
J. Stryger4
B. Özdemir3
Engin Yildirim2
D. Haspolat2
H. Türkmen2
Mislav Oršić2
A. Ömür2
P. Onuachu2
R. Baniya1
Arif Boşluk1
S. Denswil1
Maxi Gómez1
F. Benković1
SALE
Edin Višća24
Trezeguet12
Enis Bardhi10
A. Ömür10
E. Destan9
P. Onuachu8
T. Fountas8
B. Özdemir8
D. Kourbelis6
Nicolas Pépé5
Tonio Teklic4
Umut Güneş4
Joaquín Fernández4
F. Benković3
Mehmet Aydin3
R. Baniya3
Eren Elmali3
J. Stryger3
Umut Bozok2
Thomas Meunier2
H. Türkmen1
S. Denswil1
D. Haspolat1

  USO DE MEMORIA  
5,361,416 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0011
Controller Execution Time ( Home / Category )  0.5218
Total Execution Time  0.5230
  CADENA URL  
/estadisticas/Trabzonspor
  GET DATOS  
$_GET['/estadisticas/Trabzonspor']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (20)  
0.0147  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2527 AND type_rel = 2
0.0169  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 2527 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0875  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 (2443,5149,5454,7566,8293) ORDER BY n.cover_points DESC, update_date DESC
0.0187  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 = '2527' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0155  SELECT t.id,t.teamId,t.total_players,dt.nameShow,dt.basealias FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 74094 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0184  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=2527 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0147  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 (74094,72225,71432,70410,68864,67912,67752) 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.0153  SELECT count(id) as num_players from rel_players WHERE league_id = 72225 AND teamId = 2527
0.0153  SELECT count(id) as num_players from rel_players WHERE league_id = 68864 AND teamId = 2527
0.0151  SELECT count(id) as num_players from rel_players WHERE league_id = 70410 AND teamId = 2527
0.0152  SELECT count(id) as num_players from rel_players WHERE league_id = 67752 AND teamId = 2527
0.0157  SELECT count(id) as num_players from rel_players WHERE league_id = 74094 AND teamId = 2527
0.0161  SELECT count(id) as num_players from rel_players WHERE league_id = 67912 AND teamId = 2527
0.0251  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 2527
0.0165  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 = 72225 WHERE rp.league_id = 72225 AND rp.teamId = 2527 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.0167  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 = 72225 WHERE rp.league_id = 72225 AND rp.teamId = 2527 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0160  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 = 72225 WHERE rp.league_id = 72225 AND rp.teamId = 2527 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0163  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 = 72225 WHERE rp.league_id = 72225 AND rp.teamId = 2527 AND (e.action = 22) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0165  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 = 72225 WHERE rp.league_id = 72225 AND rp.teamId = 2527 AND (e.action = 19) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0165  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 = 72225 WHERE rp.league_id = 72225 AND rp.teamId = 2527 AND (e.action = 18) GROUP BY p.id ORDER BY total DESC LIMIT 30