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

Estadísticas

ENTRA
C. Mariano17
Samuele Demichele14
S. Chacón13
M. Coppola11
E. Tedesco10
Gianmarco Alba9
Luca Ciannamea9
G. Mollica9
G. Acampora9
S. Figliolia8
L. Palazzo8
Michele Aprile8
L. Mazzarano7
Tiziano Prinari7
D. Ventola6
N. Ungredda5
F. Fioretti5
K. Obodo5
M. Rotondo4
Luigi Gianfreda4
Luca Stragapede4
Gianluca Stasi4
F. Grumo4
Nicola Anaclerio3
Murilo Gomes3
Dani Espinar2
D. Scardigno2
F. Pizzutelli2
Carlo Clemente2
C. Colaci2

  USO DE MEMORIA  
5,083,824 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0013
Controller Execution Time ( Home / Category )  0.1832
Total Execution Time  0.1846
  CADENA URL  
/estadisticas/Bitonto
  GET DATOS  
$_GET['/estadisticas/Bitonto']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (8)  
0.0212  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 = 73986
0.0105  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=86850 AND type_rel = 2
0.0112  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 = '86850' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0115  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 = 73559 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0107  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 = 73986 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0116  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 = 73986 WHERE rp.league_id = 73986 AND rp.teamId = 86850 AND (e.action = 22) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0118  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 = 73986 WHERE rp.league_id = 73986 AND rp.teamId = 86850 AND (e.action = 19) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0117  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 = 73986 WHERE rp.league_id = 73986 AND rp.teamId = 86850 AND (e.action = 18) GROUP BY p.id ORDER BY total DESC LIMIT 30