4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias

Ops!

404: El contenido solicitado ya no existe

Uso de cookies: Utilizamos "cookies" propias y de terceros para mejorar nuestros servicios, elaborar información estadística, analizar sus hábitos de navegación e inferir grupos de interés. Esto nos permite personalizar el contenido que ofrecemos y mostrarle publicidad relacionada con sus preferencias. Adicionalmente, compartimos los análisis de navegación y los grupos de interés inferidos con terceros. Si continúa navegando acepta su uso. Más información y cambio de configuración. Aceptar

  USO DE MEMORIA  
3,771,048 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Player / Index )  1.7275
Total Execution Time  1.7287
  CADENA URL  
/jugador/koke-33661/historico
  GET DATOS  
$_GET['/jugador/koke-33661/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (6)  
0.0120  SELECT p.*,rp.*,dt.*,p.id as playerId,c.Name,'' as buy_url, p.twitter AS player_twitter FROM `dataplayers` p INNER JOIN `rel_players` rp ON rp.player_id = p.id AND rp.year = 2024 INNER JOIN `datateams` dt ON dt.id = rp.teamId LEFT JOIN country c ON c.code2 = p.CountryCode INNER JOIN categories AS ct ON rp.category_id=ct.id WHERE p.alias = 'koke-33661' ORDER BY rp.year DESC, ct.troncal DESC, rp.in_squad DESC
0.0116  SELECT p.*,rp.*,dt.*,p.id as playerId,c.Name,'' as buy_url, p.twitter AS player_twitter FROM `dataplayers` p INNER JOIN `rel_players` rp ON rp.player_id = p.id INNER JOIN `datateams` dt ON dt.id = rp.teamId LEFT JOIN country c ON c.code2 = p.CountryCode INNER JOIN categories AS ct ON rp.category_id=ct.id WHERE p.alias = 'koke-33661' ORDER BY rp.year DESC, ct.troncal DESC, rp.in_squad DESC
0.0109  SELECT player_id,table_suffix FROM dataplayers_suffix WHERE alias='koke-33661'
0.0116  SELECT p.*,rp.*,dt.*,p.id as playerId,c.Name,'' as buy_url, p.twitter AS player_twitter FROM `dataplayers` p INNER JOIN `rel_players` rp ON rp.player_id = p.id INNER JOIN `datateams` dt ON dt.id = rp.teamId LEFT JOIN country c ON c.code2 = p.CountryCode INNER JOIN categories AS ct ON rp.category_id=ct.id WHERE p.id = '' ORDER BY rp.year DESC, ct.troncal DESC, rp.in_squad DESC
0.0107   SELECT `alias` FROM `dataplayers` AS dp LEFT JOIN `rel_players` AS rp ON rp.`player_id` = dp.`id` AND rp.in_squad = 1 WHERE `old_alias` = 'koke-33661' AND (`alias` != '' OR `alias` IS NOT NULL) AND rp.`year` = '2024'
1.5992  SELECT dp.id, dp.nick, dp.name, dp.last_name, dp.alias, dt.nameShow, dt.basealias, dt.id AS team_id, rp.year, LOWER(dp.countryCode) AS countryCode, IF(dp.birthdate,YEAR(DATE('2024-01-01 01:01:01'))-YEAR(dp.birthdate),'-') as age, dp.twitter as player_twitter FROM dataplayers AS dp INNER JOIN rel_players AS rp ON dp.id=rp.player_id AND rp.in_squad = 1 INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.nick!='' AND dp.last_name!='' AND dp.valor > 0 AND CONCAT(dp.name, dp.last_name, dp.nick) LIKE '%koke%' GROUP BY dp.id LIMIT 2