4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Ginásio Figueirense

Estadísticas

ENTRA
João Gouveia8
João Castelo7
João Pimentel7
Copas5
Fábio Lourenço5
Milton Neri4
K. Owuso-Achau4
Bubacar Sidibé3
Tomás Piedade3
T. Balaev3
Fábio Pina3
C. Pérez3
Claudino3
Rúben Rodrigues2
J. Mavuba2
Rui Varejão1
Miguel Dias1
Lucas Rafael1
Tuga1
SALE
Milton Neri8
Aires6
K. Owuso-Achau5
Fábio Pina5
João Pimentel4
João Amoná4
J. Mavuba4
Copas4
C. Pérez4
João Castelo3
João Gouveia3
Demétrio Carvalho3
Fábio Lourenço3
Bubacar Sidibé2
Rúben Rodrigues2
Marcão1
Lucas Rafael1
Octávio1
Pedras1
Matheus Santos1
Ivan Buha1

  USO DE MEMORIA  
4,939,920 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0013
Controller Execution Time ( Home / Category )  0.0431
Total Execution Time  0.0445
  CADENA URL  
/estadisticas/Ginasio-Figueirense
  GET DATOS  
$_GET['/estadisticas/Ginasio-Figueirense']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (7)  
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=31204 AND type_rel = 2
0.0020  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 = '31204' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0019  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 = '31204' AND ct.ctype=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0022  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff FROM `tables2020` 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 = 50951 AND t.round = 25 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0019  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 events2020 e ON e.player_id = p.id AND e.league_id = 50951 WHERE rp.league_id = 50951 AND rp.teamId = 31204 AND (e.action = 22) 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 events2020 e ON e.player_id = p.id AND e.league_id = 50951 WHERE rp.league_id = 50951 AND rp.teamId = 31204 AND (e.action = 19) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0028  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 events2020 e ON e.player_id = p.id AND e.league_id = 50951 WHERE rp.league_id = 50951 AND rp.teamId = 31204 AND (e.action = 18) GROUP BY p.id ORDER BY total DESC LIMIT 30