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

K. Shanks

Jugador del Peterhead
Liga
  • Competición
  • Partidos jugados
  • Minutos jugados
  • Asistencia
  • Goles marcados
  • Tarjetas amarillas
  • Tarjetas rojas
  • info
Ficha de K. Shanks
Nacionalidad
Escocia
Nombre
Kieran Shanks
Edad
21 Años (30-04-2002)
Dorsal
10
Peso
71 kilogramos
Equipo
Peterhead
Posición
Delantero
Liga
League Two Escocia
Compañeros de equipo

No hay comentarios


  USO DE MEMORIA  
5,152,608 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0013
Controller Execution Time ( Player / Index )  0.4332
Total Execution Time  0.4345
  CADENA URL  
/jugador/K-Shanks-871961
  GET DATOS  
$_GET['/jugador/K-Shanks-871961']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (26)  
0.0005   SELECT COUNT(DISTINCT c.`id`) AS num FROM comments AS c WHERE c.`active` = 1 AND c.device = 'web' AND c.to_review=0 AND c.comment_id!=0 AND c.lang = '1' AND c.`playerId` = '871961'
0.0270  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 = 'K-Shanks-871961' ORDER BY rp.year DESC, ct.troncal DESC, rp.in_squad DESC
0.0128  SELECT man.action_value, man.stocks, man.sparks, man.points, man.variation, man.valor, man.ini_valor, man.wage FROM games.manager_players man WHERE man.playerId = '871961'
0.0135  SELECT p.id,p.nick,p.role,p.side,p.alias,rp.squadNumber FROM `rel_players` rp INNER JOIN `dataplayers` p ON p.id = rp.player_id WHERE rp.league_id = 72458 AND rp.teamId = 3007 AND rp.in_squad=1 ORDER BY p.role>0 DESC, p.role ASC, rp.squadNumber ASC
0.0127  SELECT t.nameShow,t.basealias,rp.year,c.name FROM `rel_players` rp INNER JOIN `datateams` t ON t.id = rp.teamId INNER JOIN categories c ON c.id = rp.category_id WHERE rp.player_id = 871961 ORDER BY rp.year DESC
0.0125  SELECT p.* FROM `rel_pictures` as rp INNER JOIN `pictures` as p ON p.id = rp.id_picture INNER JOIN fa_user u ON u.id = p.author_id WHERE rp.id_content = '871961' and rp.type = 3 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0127  SELECT e.* FROM `events2024` e WHERE e.player_id = 871961 AND league_id = 72458 ORDER BY e.date ASC
0.0134  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 72458 AND rel.player_id=871961
0.0127  SELECT action,minute FROM events2024 WHERE player_id = 871961 AND league_id = 72458 AND action = 18
0.0127  SELECT action,minute FROM events2024 WHERE player_id = 871961 AND league_id = 72458 AND action = 19
0.0126  SELECT e.* FROM `events2024` e WHERE e.player_id = 871961 AND league_id = 71432 ORDER BY e.date ASC
0.0131  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 71432 AND rel.player_id=871961
0.0125  SELECT action,minute FROM events2024 WHERE player_id = 871961 AND league_id = 71432 AND action = 18
0.0125  SELECT action,minute FROM events2024 WHERE player_id = 871961 AND league_id = 71432 AND action = 19
0.0126  SELECT e.* FROM `events2024` e WHERE e.player_id = 871961 AND league_id = 72126 ORDER BY e.date ASC
0.0129  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 72126 AND rel.player_id=871961
0.0127  SELECT action,minute FROM events2024 WHERE player_id = 871961 AND league_id = 72126 AND action = 18
0.0127  SELECT action,minute FROM events2024 WHERE player_id = 871961 AND league_id = 72126 AND action = 19
0.0127  SELECT e.* FROM `events2024` e WHERE e.player_id = 871961 AND league_id = 72523 ORDER BY e.date ASC
0.0136  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 72523 AND rel.player_id=871961
0.0134  SELECT action,minute FROM events2024 WHERE player_id = 871961 AND league_id = 72523 AND action = 18
0.0138  SELECT action,minute FROM events2024 WHERE player_id = 871961 AND league_id = 72523 AND action = 19
0.0132  SELECT e.* FROM `events2024` e WHERE e.player_id = 871961 AND league_id = 73404 ORDER BY e.date ASC
0.0141  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 73404 AND rel.player_id=871961
0.0128  SELECT action,minute FROM events2024 WHERE player_id = 871961 AND league_id = 73404 AND action = 18
0.0129  SELECT action,minute FROM events2024 WHERE player_id = 871961 AND league_id = 73404 AND action = 19