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

Estadísticas

ASISTENCIAS
O. Marmoush6
Farès Chaïbi3
Dina Ebimbe3
N. Nkounkou2
William Pacho2
Philipp Max2
Mario Götze2
Tuta2
Ansgar Knauff1
Jens Grahl1
Hugo Ekitiké1
K. Jakić1
P. Aaronson1
S. Kalajdžić1
Hugo Larsson1
T. Chandler1
Ellyes Skhiri1
Aurélio Buta1
ENTRA
J. Ngankam17
N. Nkounkou14
J. Hauge10
Hrvoje Smolčić8
Aurélio Buta8
Hugo Ekitiké7
Farès Chaïbi7
Mario Götze7
Jean Bahoya6
S. Rode6
P. Aaronson6
T. Chandler6
Nacho Ferri6
Ansgar Knauff6
Philipp Max6
Hugo Larsson5
C. Lenz5
Dina Ebimbe5
Makoto Hasebe5
D. Van De Beek4
Elias Baum4
K. Jakić4
Ellyes Skhiri3
O. Marmoush2
Nnamdi Collins1
M. Mladenovic1
SALE
Dina Ebimbe19
Ansgar Knauff18
Mario Götze14
Philipp Max14
O. Marmoush12
Aurélio Buta12
Farès Chaïbi12
Hugo Larsson8
Tuta6
K. Jakić6
N. Nkounkou5
D. Van De Beek5
S. Kalajdžić4
J. Ngankam4
Hugo Ekitiké4
Ellyes Skhiri3
Robin Koch2
Kolo Muani2
Jean Bahoya1
J. Lindstrøm1
Hrvoje Smolčić1
Nnamdi Collins1
S. Rode1
P. Aaronson1
Makoto Hasebe1

  USO DE MEMORIA  
5,897,008 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.2482
Total Execution Time  0.2495
  CADENA URL  
/estadisticas/Eintracht-Frankfurt
  GET DATOS  
$_GET['/estadisticas/Eintracht-Frankfurt']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (7)  
0.0295  SELECT c.*, l.*, cou.name as namec, ct.table_sufix FROM (leagues l INNER JOIN categories c ON c.id = l.categoryId INNER JOIN categories_types ct ON c.ctype=ct.id LEFT JOIN country cou ON cou.Code2 = c.CountryCode) WHERE l.id = 73886
0.0169  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 = '960' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0147  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 = 72031 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0153  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 = 72031 AND t.round = 31 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0178  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 = 72031 WHERE rp.league_id = 72031 AND rp.teamId = 960 AND (e.action = 22) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0178  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 = 72031 WHERE rp.league_id = 72031 AND rp.teamId = 960 AND (e.action = 19) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0183  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 = 72031 WHERE rp.league_id = 72031 AND rp.teamId = 960 AND (e.action = 18) GROUP BY p.id ORDER BY total DESC LIMIT 30