4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Imagen de Pärnu Jalgpalliklubi

Parn

Liga
  • Competición
  • Partidos jugados
  • Minutos jugados
  • Asistencia
  • Goles marcados
  • Tarjetas amarillas
  • Tarjetas rojas
  • info
Ficha de Parn
Nacionalidad
Estonia
Nombre
Martin Parn
Edad
25 Años (27-11-1998)
Dorsal
14
Equipo
Pärnu Jalgpalliklubi
Posición
Delantero
Liga
Partidos Amistosos 2023
Compañeros de equipo

No hay comentarios


  USO DE MEMORIA  
6,774,880 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0013
Controller Execution Time ( Player / Index )  1.0664
Total Execution Time  1.0677
  CADENA URL  
/jugador/parn-321851
  GET DATOS  
$_GET['/jugador/parn-321851']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (73)  
0.0009   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` = '321851'
0.0136  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 = 'parn-321851' ORDER BY rp.year DESC, ct.troncal DESC, rp.in_squad DESC
0.0209  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 = 'parn-321851' ORDER BY rp.year DESC, ct.troncal DESC, rp.in_squad DESC
0.0148  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 = 66758
0.0148  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 = 61476
0.0148  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 = 55083
0.0142  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 = 60121
0.0142  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 = 49200
0.0142  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 = 42641
0.0142  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 = 37789
0.0147  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 = 20333
0.0142  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 = 9430
0.0145  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 = 9379
0.0126  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 = '321851'
0.0170  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 = 67320 AND rp.teamId = 64770 AND rp.in_squad=1 ORDER BY p.role>0 DESC, p.role ASC, rp.squadNumber ASC
0.0139  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 = 321851 ORDER BY rp.year DESC
0.0126  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 = '321851' and rp.type = 3 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0127  SELECT e.* FROM `events2023` e WHERE e.player_id = 321851 AND league_id = 67320 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 = 67320 AND rel.player_id=321851
0.0126  SELECT action,minute FROM events2023 WHERE player_id = 321851 AND league_id = 67320 AND action = 18
0.0125  SELECT action,minute FROM events2023 WHERE player_id = 321851 AND league_id = 67320 AND action = 19
0.0126  SELECT e.* FROM `events2023` e WHERE e.player_id = 321851 AND league_id = 67740 ORDER BY e.date ASC
0.0140  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 67740 AND rel.player_id=321851
0.0126  SELECT action,minute FROM events2023 WHERE player_id = 321851 AND league_id = 67740 AND action = 18
0.0126  SELECT action,minute FROM events2023 WHERE player_id = 321851 AND league_id = 67740 AND action = 19
0.0125  SELECT e.* FROM `events2022` e WHERE e.player_id = 321851 AND league_id = 66758 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 = 66758 AND rel.player_id=321851
0.0125  SELECT action,minute FROM events2022 WHERE player_id = 321851 AND league_id = 66758 AND action = 18
0.0125  SELECT action,minute FROM events2022 WHERE player_id = 321851 AND league_id = 66758 AND action = 19
0.0125  SELECT e.* FROM `events2021` e WHERE e.player_id = 321851 AND league_id = 61476 ORDER BY e.date ASC
0.0125  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 61476 AND rel.player_id=321851
0.0126  SELECT action,minute FROM events2021 WHERE player_id = 321851 AND league_id = 61476 AND action = 18
0.0125  SELECT action,minute FROM events2021 WHERE player_id = 321851 AND league_id = 61476 AND action = 19
0.0125  SELECT e.* FROM `events2021` e WHERE e.player_id = 321851 AND league_id = 56547 ORDER BY e.date ASC
0.0140  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=321851
0.0126  SELECT action,minute FROM events2021 WHERE player_id = 321851 AND league_id = 56547 AND action = 18
0.0125  SELECT action,minute FROM events2021 WHERE player_id = 321851 AND league_id = 56547 AND action = 19
0.0127  SELECT e.* FROM `events2020` e WHERE e.player_id = 321851 AND league_id = 55083 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 = 55083 AND rel.player_id=321851
0.0127  SELECT action,minute FROM events2020 WHERE player_id = 321851 AND league_id = 55083 AND action = 18
0.0127  SELECT action,minute FROM events2020 WHERE player_id = 321851 AND league_id = 55083 AND action = 19
0.0126  SELECT e.* FROM `events2020` e WHERE e.player_id = 321851 AND league_id = 60121 ORDER BY e.date ASC
0.0125  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 60121 AND rel.player_id=321851
0.0126  SELECT action,minute FROM events2020 WHERE player_id = 321851 AND league_id = 60121 AND action = 18
0.0125  SELECT action,minute FROM events2020 WHERE player_id = 321851 AND league_id = 60121 AND action = 19
0.0128  SELECT e.* FROM `events2019` e WHERE e.player_id = 321851 AND league_id = 48714 ORDER BY e.date ASC
0.0133  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 48714 AND rel.player_id=321851
0.0130  SELECT action,minute FROM events2019 WHERE player_id = 321851 AND league_id = 48714 AND action = 18
0.0128  SELECT action,minute FROM events2019 WHERE player_id = 321851 AND league_id = 48714 AND action = 19
0.0126  SELECT e.* FROM `events2019` e WHERE e.player_id = 321851 AND league_id = 49200 ORDER BY e.date ASC
0.0130  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 49200 AND rel.player_id=321851
0.0126  SELECT action,minute FROM events2019 WHERE player_id = 321851 AND league_id = 49200 AND action = 18
0.0126  SELECT action,minute FROM events2019 WHERE player_id = 321851 AND league_id = 49200 AND action = 19
0.0126  SELECT e.* FROM `events2018` e WHERE e.player_id = 321851 AND league_id = 42641 ORDER BY e.date ASC
0.0135  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 42641 AND rel.player_id=321851
0.0128  SELECT action,minute FROM events2018 WHERE player_id = 321851 AND league_id = 42641 AND action = 18
0.0129  SELECT action,minute FROM events2018 WHERE player_id = 321851 AND league_id = 42641 AND action = 19
0.0127  SELECT e.* FROM `events2017` e WHERE e.player_id = 321851 AND league_id = 37789 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 = 37789 AND rel.player_id=321851
0.0127  SELECT action,minute FROM events2017 WHERE player_id = 321851 AND league_id = 37789 AND action = 18
0.0127  SELECT action,minute FROM events2017 WHERE player_id = 321851 AND league_id = 37789 AND action = 19
0.0128  SELECT e.* FROM `events2016` e WHERE e.player_id = 321851 AND league_id = 20333 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 = 20333 AND rel.player_id=321851
0.0125  SELECT action,minute FROM events2016 WHERE player_id = 321851 AND league_id = 20333 AND action = 18
0.0126  SELECT action,minute FROM events2016 WHERE player_id = 321851 AND league_id = 20333 AND action = 19
0.0129  SELECT e.* FROM `events2015` e WHERE e.player_id = 321851 AND league_id = 9430 ORDER BY e.date ASC
0.0130  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 9430 AND rel.player_id=321851
0.0125  SELECT action,minute FROM events2015 WHERE player_id = 321851 AND league_id = 9430 AND action = 18
0.0125  SELECT action,minute FROM events2015 WHERE player_id = 321851 AND league_id = 9430 AND action = 19
0.0125  SELECT e.* FROM `events2015` e WHERE e.player_id = 321851 AND league_id = 9379 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 = 9379 AND rel.player_id=321851
0.0127  SELECT action,minute FROM events2015 WHERE player_id = 321851 AND league_id = 9379 AND action = 18
0.0126  SELECT action,minute FROM events2015 WHERE player_id = 321851 AND league_id = 9379 AND action = 19