4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Sporting Trestina

Estadísticas

ENTRA
Francesco Soldani20
Filippo Marietti11
M. Giuliani7
Mattia Dottori6
Antonio Montani5
B. Bucci5
S. Cardaioli4
Marzio Pica4
Giovanni Farneti4
G. Coppini3
Francesco Di Nolfo3
E. Menghi3
M. Irione3
P. Morlandi3
Endurance Omohonria2
D. Bartolucci2
Marco Contucci1
A. Conti1
L. Tosti1
Stefano Gramaccia1
L. Belli1
T. Marioli1
F. Lucchetti1

  USO DE MEMORIA  
5,101,488 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0021
Controller Execution Time ( Home / Category )  0.0488
Total Execution Time  0.0510
  CADENA URL  
/estadisticas/Sporting-Trestina/2024
  GET DATOS  
$_GET['/estadisticas/Sporting-Trestina/2024']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (5)  
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=6915 AND type_rel = 2
0.0023  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 = '6915' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0029  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 = 73983 WHERE rp.league_id = 73983 AND rp.teamId = 6915 AND (e.action = 22) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0032  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 = 73983 WHERE rp.league_id = 73983 AND rp.teamId = 6915 AND (e.action = 19) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0029  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 = 73983 WHERE rp.league_id = 73983 AND rp.teamId = 6915 AND (e.action = 18) GROUP BY p.id ORDER BY total DESC LIMIT 30