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

Estadísticas

ASISTENCIAS
Ondrej Duda4
Tomáš Suslov4
D. Faraoni2
T. Noslin2
J. Tchatchoua2
Cyril Ngonge2
Milan Đurić2
L. Montipò1
F. Bonazzoli1
D. Lazović1
M. Folorunsho1
F. Terracciano1
F. Centonze1
Jordi Mboula1
Suat Serdar1
ENTRA
Thomas Henry15
F. Bonazzoli14
D. Lazović10
Milan Đurić10
R. Saponara9
Cyril Ngonge9
K. Świderski9
Rúben Vinagre8
Tomáš Suslov7
Isak Hien7
Dani Silva7
Jordi Mboula6
J. Tchatchoua6
F. Terracciano6
D. Coppola6
Suat Serdar6
D. Faraoni6
S. Mitrović6
J. Cabal5
G. Magnani4
Martin Hongla3
F. Centonze3
B. Amione3
Ondrej Duda3
J. Cruz3
Josh Doig2
E. Tavşan2
P. Dawidowicz2
M. Folorunsho1
R. Belahyane1
SALE
D. Lazović17
Milan Đurić13
M. Folorunsho13
Josh Doig12
Tomáš Suslov12
Ondrej Duda11
Cyril Ngonge11
F. Bonazzoli8
T. Noslin8
Suat Serdar7
D. Faraoni7
J. Tchatchoua6
Jordi Mboula5
F. Terracciano4
D. Coppola4
B. Amione4
P. Dawidowicz4
Martin Hongla3
K. Świderski3
J. Cabal3
R. Saponara3
S. Mitrović3
Dani Silva2
F. Centonze2
Thomas Henry2
G. Magnani1
J. Cruz1

  USO DE MEMORIA  
5,513,280 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0016
Controller Execution Time ( Home / Category )  0.3140
Total Execution Time  0.3155
  CADENA URL  
/estadisticas/Hellas-Verona-Fc
  GET DATOS  
$_GET['/estadisticas/Hellas-Verona-Fc']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (14)  
0.0144  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 = '1305' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0129  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 = 73270 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0145  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=1305 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0128  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 (73270,72044,71936,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.0142  SELECT count(id) as num_players from rel_players WHERE league_id = 72044 AND teamId = 1305
0.0173  SELECT count(id) as num_players from rel_players WHERE league_id = 73270 AND teamId = 1305
0.0152  SELECT count(id) as num_players from rel_players WHERE league_id = 71936 AND teamId = 1305
0.0284  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 1305
0.0147  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 = 72044 WHERE rp.league_id = 72044 AND rp.teamId = 1305 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.0142  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 = 72044 WHERE rp.league_id = 72044 AND rp.teamId = 1305 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0141  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 = 72044 WHERE rp.league_id = 72044 AND rp.teamId = 1305 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0146  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 = 72044 WHERE rp.league_id = 72044 AND rp.teamId = 1305 AND (e.action = 22) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0149  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 = 72044 WHERE rp.league_id = 72044 AND rp.teamId = 1305 AND (e.action = 19) 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 = 72044 WHERE rp.league_id = 72044 AND rp.teamId = 1305 AND (e.action = 18) GROUP BY p.id ORDER BY total DESC LIMIT 30