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

A. Kogler

Jugador del Grazer AK
Liga
  • Competición
  • Partidos jugados
  • Minutos jugados
  • Asistencia
  • Goles marcados
  • Tarjetas amarillas
  • Tarjetas rojas
  • info
Ficha de A. Kogler
Nacionalidad
Austria
Nombre
Alexander Kogler
Edad
26 Años (01-02-1998)
Altura
190
Equipo
Grazer AK
Posición
Delantero
Liga
Partidos Amistosos 2021
Compañeros de equipo

No hay comentarios


  USO DE MEMORIA  
7,381,240 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0020
Controller Execution Time ( Player / Index )  1.8164
Total Execution Time  1.8184
  CADENA URL  
/jugador/a-kogler-344130
  GET DATOS  
$_GET['/jugador/a-kogler-344130']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (111)  
0.0015   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` = '344130'
0.0151  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 = 'a-kogler-344130' ORDER BY rp.year DESC, ct.troncal DESC, rp.in_squad DESC
0.0334  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 = 'a-kogler-344130' ORDER BY rp.year DESC, ct.troncal DESC, rp.in_squad DESC
0.0151  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 = 50149
0.0150  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 = 53592
0.0152  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 = 49506
0.0151  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 = 44020
0.0151  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 = 38887
0.0151  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 = 34478
0.0152  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 = 38231
0.0152  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 = 28929
0.0153  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 = 41073
0.0152  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 = 44161
0.0152  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 = 15555
0.0152  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 = 41086
0.0152  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 = 9346
0.0152  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 = 41100
0.0150  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 = 48686
0.0151  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 = 48687
0.0145  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 = '344130'
0.0263  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 = 56547 AND rp.teamId = 1254 AND rp.in_squad=1 ORDER BY p.role>0 DESC, p.role ASC, rp.squadNumber ASC
0.0148  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 = 344130 ORDER BY rp.year DESC
0.0146  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 = '344130' and rp.type = 3 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0145  SELECT e.* FROM `events2021` e WHERE e.player_id = 344130 AND league_id = 56547 ORDER BY e.date ASC
0.0152  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 56547 AND rel.player_id=344130
0.0145  SELECT action,minute FROM events2021 WHERE player_id = 344130 AND league_id = 56547 AND action = 18
0.0145  SELECT action,minute FROM events2021 WHERE player_id = 344130 AND league_id = 56547 AND action = 19
0.0145  SELECT e.* FROM `events2021` e WHERE e.player_id = 344130 AND league_id = 57797 ORDER BY e.date ASC
0.0152  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 57797 AND rel.player_id=344130
0.0145  SELECT action,minute FROM events2021 WHERE player_id = 344130 AND league_id = 57797 AND action = 18
0.0145  SELECT action,minute FROM events2021 WHERE player_id = 344130 AND league_id = 57797 AND action = 19
0.0146  SELECT e.* FROM `events2020` e WHERE e.player_id = 344130 AND league_id = 50149 ORDER BY e.date ASC
0.0150  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 50149 AND rel.player_id=344130
0.0147  SELECT action,minute FROM events2020 WHERE player_id = 344130 AND league_id = 50149 AND action = 18
0.0148  SELECT action,minute FROM events2020 WHERE player_id = 344130 AND league_id = 50149 AND action = 19
0.0146  SELECT e.* FROM `events2020` e WHERE e.player_id = 344130 AND league_id = 53592 ORDER BY e.date ASC
0.0152  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 53592 AND rel.player_id=344130
0.0147  SELECT action,minute FROM events2020 WHERE player_id = 344130 AND league_id = 53592 AND action = 18
0.0146  SELECT action,minute FROM events2020 WHERE player_id = 344130 AND league_id = 53592 AND action = 19
0.0145  SELECT e.* FROM `events2020` e WHERE e.player_id = 344130 AND league_id = 49506 ORDER BY e.date ASC
0.0156  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 49506 AND rel.player_id=344130
0.0145  SELECT action,minute FROM events2020 WHERE player_id = 344130 AND league_id = 49506 AND action = 18
0.0145  SELECT action,minute FROM events2020 WHERE player_id = 344130 AND league_id = 49506 AND action = 19
0.0145  SELECT e.* FROM `events2020` e WHERE e.player_id = 344130 AND league_id = 50221 ORDER BY e.date ASC
0.0153  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 50221 AND rel.player_id=344130
0.0156  SELECT action,minute FROM events2020 WHERE player_id = 344130 AND league_id = 50221 AND action = 18
0.0146  SELECT action,minute FROM events2020 WHERE player_id = 344130 AND league_id = 50221 AND action = 19
0.0146  SELECT e.* FROM `events2020` e WHERE e.player_id = 344130 AND league_id = 56999 ORDER BY e.date ASC
0.0148  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 56999 AND rel.player_id=344130
0.0146  SELECT action,minute FROM events2020 WHERE player_id = 344130 AND league_id = 56999 AND action = 18
0.0146  SELECT action,minute FROM events2020 WHERE player_id = 344130 AND league_id = 56999 AND action = 19
0.0149  SELECT e.* FROM `events2019` e WHERE e.player_id = 344130 AND league_id = 44020 ORDER BY e.date ASC
0.0165  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 44020 AND rel.player_id=344130
0.0147  SELECT action,minute FROM events2019 WHERE player_id = 344130 AND league_id = 44020 AND action = 18
0.0148  SELECT action,minute FROM events2019 WHERE player_id = 344130 AND league_id = 44020 AND action = 19
0.0147  SELECT e.* FROM `events2018` e WHERE e.player_id = 344130 AND league_id = 38887 ORDER BY e.date ASC
0.0150  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 38887 AND rel.player_id=344130
0.0149  SELECT action,minute FROM events2018 WHERE player_id = 344130 AND league_id = 38887 AND action = 18
0.0155  SELECT action,minute FROM events2018 WHERE player_id = 344130 AND league_id = 38887 AND action = 19
0.0145  SELECT e.* FROM `events2018` e WHERE e.player_id = 344130 AND league_id = 38427 ORDER BY e.date ASC
0.0151  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 38427 AND rel.player_id=344130
0.0145  SELECT action,minute FROM events2018 WHERE player_id = 344130 AND league_id = 38427 AND action = 18
0.0145  SELECT action,minute FROM events2018 WHERE player_id = 344130 AND league_id = 38427 AND action = 19
0.0151  SELECT e.* FROM `events2017` e WHERE e.player_id = 344130 AND league_id = 34478 ORDER BY e.date ASC
0.0162  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 34478 AND rel.player_id=344130
0.0150  SELECT action,minute FROM events2017 WHERE player_id = 344130 AND league_id = 34478 AND action = 18
0.0148  SELECT action,minute FROM events2017 WHERE player_id = 344130 AND league_id = 34478 AND action = 19
0.0145  SELECT e.* FROM `events2017` e WHERE e.player_id = 344130 AND league_id = 38231 ORDER BY e.date ASC
0.0166  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 38231 AND rel.player_id=344130
0.0145  SELECT action,minute FROM events2017 WHERE player_id = 344130 AND league_id = 38231 AND action = 18
0.0149  SELECT action,minute FROM events2017 WHERE player_id = 344130 AND league_id = 38231 AND action = 19
0.0146  SELECT e.* FROM `events2017` e WHERE e.player_id = 344130 AND league_id = 28929 ORDER BY e.date ASC
0.0158  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 28929 AND rel.player_id=344130
0.0146  SELECT action,minute FROM events2017 WHERE player_id = 344130 AND league_id = 28929 AND action = 18
0.0146  SELECT action,minute FROM events2017 WHERE player_id = 344130 AND league_id = 28929 AND action = 19
0.0145  SELECT e.* FROM `events2017` e WHERE e.player_id = 344130 AND league_id = 41073 ORDER BY e.date ASC
0.0156  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 41073 AND rel.player_id=344130
0.0145  SELECT action,minute FROM events2017 WHERE player_id = 344130 AND league_id = 41073 AND action = 18
0.0145  SELECT action,minute FROM events2017 WHERE player_id = 344130 AND league_id = 41073 AND action = 19
0.0146  SELECT e.* FROM `events2017` e WHERE e.player_id = 344130 AND league_id = 44161 ORDER BY e.date ASC
0.0149  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 44161 AND rel.player_id=344130
0.0145  SELECT action,minute FROM events2017 WHERE player_id = 344130 AND league_id = 44161 AND action = 18
0.0146  SELECT action,minute FROM events2017 WHERE player_id = 344130 AND league_id = 44161 AND action = 19
0.0165  SELECT e.* FROM `events2016` e WHERE e.player_id = 344130 AND league_id = 15555 ORDER BY e.date ASC
0.0152  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 15555 AND rel.player_id=344130
0.0148  SELECT action,minute FROM events2016 WHERE player_id = 344130 AND league_id = 15555 AND action = 18
0.0145  SELECT action,minute FROM events2016 WHERE player_id = 344130 AND league_id = 15555 AND action = 19
0.0145  SELECT e.* FROM `events2016` e WHERE e.player_id = 344130 AND league_id = 41086 ORDER BY e.date ASC
0.0150  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 41086 AND rel.player_id=344130
0.0171  SELECT action,minute FROM events2016 WHERE player_id = 344130 AND league_id = 41086 AND action = 18
0.0146  SELECT action,minute FROM events2016 WHERE player_id = 344130 AND league_id = 41086 AND action = 19
0.0145  SELECT e.* FROM `events2016` e WHERE e.player_id = 344130 AND league_id = 41087 ORDER BY e.date ASC
0.0152  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 41087 AND rel.player_id=344130
0.0146  SELECT action,minute FROM events2016 WHERE player_id = 344130 AND league_id = 41087 AND action = 18
0.0148  SELECT action,minute FROM events2016 WHERE player_id = 344130 AND league_id = 41087 AND action = 19
0.0148  SELECT e.* FROM `events2015` e WHERE e.player_id = 344130 AND league_id = 9346 ORDER BY e.date ASC
0.0151  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 9346 AND rel.player_id=344130
0.0147  SELECT action,minute FROM events2015 WHERE player_id = 344130 AND league_id = 9346 AND action = 18
0.0145  SELECT action,minute FROM events2015 WHERE player_id = 344130 AND league_id = 9346 AND action = 19
0.0147  SELECT e.* FROM `events2015` e WHERE e.player_id = 344130 AND league_id = 41100 ORDER BY e.date ASC
0.0150  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 41100 AND rel.player_id=344130
0.0146  SELECT action,minute FROM events2015 WHERE player_id = 344130 AND league_id = 41100 AND action = 18
0.0154  SELECT action,minute FROM events2015 WHERE player_id = 344130 AND league_id = 41100 AND action = 19
0.0149  SELECT e.* FROM `events2014` e WHERE e.player_id = 344130 AND league_id = 48686 ORDER BY e.date ASC
0.0161  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 48686 AND rel.player_id=344130
0.0147  SELECT action,minute FROM events2014 WHERE player_id = 344130 AND league_id = 48686 AND action = 18
0.0153  SELECT action,minute FROM events2014 WHERE player_id = 344130 AND league_id = 48686 AND action = 19
0.0146  SELECT e.* FROM `events2013` e WHERE e.player_id = 344130 AND league_id = 48687 ORDER BY e.date ASC
0.0151  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 48687 AND rel.player_id=344130
0.0146  SELECT action,minute FROM events2013 WHERE player_id = 344130 AND league_id = 48687 AND action = 18
0.0145  SELECT action,minute FROM events2013 WHERE player_id = 344130 AND league_id = 48687 AND action = 19