Twitter by resultados fútbol

Resultados de fútbol

Hércules

Datos del club

Ver detalle de equipo
  • Estadio: José Rico Pérez
  • Entrenador: Rubén Torrecilla
Cargando...
Cargando...

  USO DE MEMORIA  
4,372,560 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0009
Controller Execution Time ( Twitter / Detail )  0.1853
Total Execution Time  0.1863
  CADENA URL  
/twitter/hercules
  GET DATOS  
$_GET['/twitter/hercules']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (7)  
0.0126  SELECT dt.nameShow, dt.basealias, t.id, t.total_twitter,dt.fullName FROM `teams` as t INNER JOIN `datateams` as dt ON dt.id = t.teamId WHERE league_id = 72364 AND t.total_twitter > 0 ORDER BY nameShow
0.0253  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 = 72364
0.0127  SELECT dt.nameShow, dt.basealias, t.id, t.total_twitter,dt.fullName FROM `teams` as t INNER JOIN `datateams` as dt ON dt.id = t.teamId WHERE league_id = 1334 ORDER BY nameShow LIMIT 100
0.0126  SELECT dt.nameShow, dt.basealias, t.id, t.total_twitter,dt.fullName FROM `teams` as t INNER JOIN `datateams` as dt ON dt.id = t.teamId WHERE league_id = 1335 ORDER BY nameShow LIMIT 100
0.0131  SELECT dt.nameShow, dt.basealias, t.id, t.total_twitter,dt.fullName FROM `teams` as t INNER JOIN `datateams` as dt ON dt.id = t.teamId WHERE t.total_twitter > 0 AND league_id != 1334 AND league_id != 1335 ORDER BY nameShow
0.0128  SELECT dp.name,dp.last_name,dp.nick,dp.alias,dp.twitter,dp.valor FROM rel_players rp INNER JOIN dataplayers dp ON rp.player_id = dp.id WHERE rp.in_squad = 1 AND rp.team_id = 6587638 AND dp.twitter is not null ORDER BY dp.valor DESC,dp.id ASC LIMIT 15
0.0125  SELECT dp.name,dp.last_name,dp.nick,dp.alias,dp.twitter,dp.valor FROM rel_players rp INNER JOIN dataplayers dp ON rp.player_id = dp.id INNER JOIN games.manager_players mp ON mp.playerId = dp.id WHERE rp.in_squad = 1 AND rp.league_id = 1334 AND dp.twitter is not null ORDER BY mp.action_value DESC,dp.id ASC LIMIT 15