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

Estadísticas

ASISTENCIAS
Yusuf Sari7
J. Svensson3
Yusuf Barasi2
Y. Erdoğan2
E. Akbaba2
B. Akintola2
Nani2
K. Rodrigues1
Maestro1
T. Aydoğan1
M'baye Niang1
Semih Guler1
A. Zeneli1
C. Ndiaye1
Youcef Atal1
ENTRA
Yusuf Barasi20
Nani18
T. Aydoğan14
D. Toköz13
A. Zeneli10
M. Balotelli6
Y. Erdoğan6
A. Aymbetov5
P. Cissé4
José Rodriguez4
Abdurrahim Dursun4
Édouard Michut4
M'baye Niang3
B. Stambouli3
B. Akintola3
Jovan Manev3
Yusuf Sari3
Vedat Karakus2
İzzet Çelik2
Badou N'diaye2
Andrew Gravillon2
N. Alioui2
A. Burak2
M. Nourani2
E. Akbaba1
O. Demirbağ1
Florent Shehu1
S. Mendoza1
Ş. Mähämmädäliyev1
Ismail Cokcalis1
SALE
M'baye Niang11
Édouard Michut11
Y. Erdoğan11
E. Akbaba11
Yusuf Sari10
Nani10
B. Stambouli9
Y. Belhanda8
B. Akintola7
M. Balotelli7
J. Svensson5
Badou N'diaye5
Abdurrahim Dursun5
K. Rodrigues4
Andrew Gravillon4
Yusuf Barasi4
S. Mendoza4
D. Toköz3
Ismail Cokcalis3
P. Cissé3
Ş. Mähämmädäliyev2
A. Zeneli2
M. Nourani2
A. Aymbetov2
T. Aydoğan2
José Rodriguez1
Semih Guler1
M. Mohammadi1
C. Ndiaye1
N. Alioui1

  USO DE MEMORIA  
5,713,552 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.0927
Total Execution Time  0.0938
  CADENA URL  
/estadisticas/Adana-Demirspor
  GET DATOS  
$_GET['/estadisticas/Adana-Demirspor']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (17)  
0.0020  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=68 AND type_rel = 2
0.0022  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 68 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 (476498,712235,996201,1001918,1008111) ORDER BY n.cover_points DESC, update_date DESC
0.0034  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 = '68' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0032  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=68 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0019  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,72103,71432) 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.0024  SELECT count(id) as num_players from rel_players WHERE league_id = 72225 AND teamId = 68
0.0029  SELECT count(id) as num_players from rel_players WHERE league_id = 74094 AND teamId = 68
0.0023  SELECT count(id) as num_players from rel_players WHERE league_id = 72103 AND teamId = 68
0.0029  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 68
0.0042  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff FROM `tables2024` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 72225 AND t.round = 34 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0048  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 = 68 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.0037  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 = 68 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0030  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 = 68 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0031  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 = 68 AND (e.action = 22) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0033  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 = 68 AND (e.action = 19) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0036  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 = 68 AND (e.action = 18) GROUP BY p.id ORDER BY total DESC LIMIT 30