4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Ação

Estadísticas

ENTRA
Diego7
David William7
Marquinhos5
Luis Antônio5
Pedro4
Marlon4
Aguion4
Daniel Stefano3
Gabriel Amorim2
Wallisson2
Mateus Alex2
Jonathan2
2
João Pedro2
Guilherme1
Profeta1
L. Santos1
Samuel1
C. Miyahira1
J. D. Mendes1
Guilherme Arruda1
Mackeirrysson1
Daniel1
Dener1
Romário Da Luz1
Índio1
Paulinho Mingau1
Vitinho1

  USO DE MEMORIA  
5,414,016 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0013
Controller Execution Time ( Home / Category )  0.2036
Total Execution Time  0.2049
  CADENA URL  
/estadisticas/Sociedade-Acao-Futebol
  GET DATOS  
$_GET['/estadisticas/Sociedade-Acao-Futebol']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (7)  
0.0255  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 = 66865
0.0130  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=63878 AND type_rel = 2
0.0138  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 = '63878' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0137  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 = '63878' AND ct.ctype=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0139  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 events2022 e ON e.player_id = p.id AND e.league_id = 66865 WHERE rp.league_id = 66865 AND rp.teamId = 63878 AND (e.action = 22) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0133  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 events2022 e ON e.player_id = p.id AND e.league_id = 66865 WHERE rp.league_id = 66865 AND rp.teamId = 63878 AND (e.action = 19) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0134  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 events2022 e ON e.player_id = p.id AND e.league_id = 66865 WHERE rp.league_id = 66865 AND rp.teamId = 63878 AND (e.action = 18) GROUP BY p.id ORDER BY total DESC LIMIT 30