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

Posibles jugadores que estás buscando:


  USO DE MEMORIA  
3,765,464 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Player / Index )  0.1397
Total Execution Time  0.1408
  CADENA URL  
/jugador/imanol-garcia-277275
  GET DATOS  
$_GET['/jugador/imanol-garcia-277275']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (6)  
0.0109  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 = 'imanol-garcia-277275' ORDER BY rp.year DESC, ct.troncal DESC, rp.in_squad DESC
0.0108  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 = 'imanol-garcia-277275' ORDER BY rp.year DESC, ct.troncal DESC, rp.in_squad DESC
0.0105  SELECT player_id,table_suffix FROM dataplayers_suffix WHERE alias='imanol-garcia-277275'
0.0107  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` = 'imanol-garcia-277275' AND (`alias` != '' OR `alias` IS NOT NULL) AND rp.`year` = '2024'
0.0162  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 '%imanol%' OR CONCAT(dp.name, dp.last_name, dp.nick) LIKE '%garcia%' GROUP BY dp.id LIMIT 2