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

Pedro López

Jugador del Huesca
Liga
  • Competición
  • Partidos jugados
  • Minutos jugados
  • Asistencia
  • Goles marcados
  • Tarjetas amarillas
  • Tarjetas rojas
  • info
Ficha de Pedro López
Nacionalidad
España
Nombre
Pedro López Muñoz
Edad
40 Años (01-11-1983)
Altura
174
Dorsal
19
Peso
72 kilogramos
Equipo
Huesca
Posición
Defensa
Liga
Primera División 2021
  • Jugador del Huesca desde hace 3 años
    • Compañeros de equipo
    Fotos
    14
    • Foto principal de Pedro López | Huesca
    • Foto principal de Pedro López | Huesca
    • Foto principal de Pedro López | Huesca
    • Foto principal de Pedro López | Levante
    • Foto principal de Pedro López | Levante
    • Foto principal de Pedro López | Levante
    • Foto principal de Pedro López | Levante
    • Foto principal de Pedro López | Levante
    • Foto principal de Pedro López | Levante
    • Pedro López
    • Pedro López
    • Pedro Lopez
    • Pedro López
    • Pedro López
    2 Comentarios
    • rodry94
      Hace 12 años rodry94 dice: crack!crack!
    • moroso77
      Hace 12 años moroso77 dice: que se busque equipo en verano, que ya no da mas de si que se busque equipo en verano, que ya no da mas de si

      USO DE MEMORIA  
    11,552,560 bytes
      BENCHMARKS  
    Loading Time Base Classes  0.0014
    Controller Execution Time ( Player / Index )  2.8987
    Total Execution Time  2.9001
      CADENA URL  
    /jugador/pedro-lopez-27015
      GET DATOS  
    $_GET['/jugador/pedro-lopez-27015']  
      POST DATOS  
    No hay datos POST existentes
      CONSULTAS (237)  
    0.0018   SELECT c.comment_id, 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` = '27015' AND c.comment_id IN (1145689,897156) GROUP BY c.comment_id
    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 = 'pedro-lopez-27015' ORDER BY rp.year DESC, ct.troncal DESC, rp.in_squad DESC
    0.0664  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 = 'pedro-lopez-27015' ORDER BY rp.year DESC, ct.troncal DESC, rp.in_squad DESC
    0.0111  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 = 57041
    0.0112  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 = 43542
    0.0111  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 = 44594
    0.0112  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 = 73284
    0.0110  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 = 38645
    0.0110  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 = 33904
    0.0111  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 = 15373
    0.0113  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 = 73041
    0.0110  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 = 3775
    0.0114  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 = 3992
    0.0113  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 = 73153
    0.0112  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 = 1969
    0.0111  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 = 2160
    0.0112  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 = 2257
    0.0112  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 = 1437
    0.0112  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 = 1312
    0.0133  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 = 2
    0.0133  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 = 81
    0.0112  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 = 11987
    0.0111  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 = 72821
    0.0109  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 = 40
    0.0110  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 = 178
    0.0105  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 = '27015'
    0.0113  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 = 57041 AND rp.teamId = 1339 AND rp.in_squad=1 ORDER BY p.role>0 DESC, p.role ASC, rp.squadNumber ASC
    0.0110  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 = 27015 ORDER BY rp.year DESC
    0.0112  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 = '27015' and rp.type = 3 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
    0.0108  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '27015' and rp.type = 3
    0.0108  SELECT e.* FROM `events2021` e WHERE e.player_id = 27015 AND league_id = 57041 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 = 57041 AND rel.player_id=27015
    0.0111  SELECT action,minute FROM events2021 WHERE player_id = 27015 AND league_id = 57041 AND action = 18
    0.0112  SELECT action,minute FROM events2021 WHERE player_id = 27015 AND league_id = 57041 AND action = 19
    0.0106  SELECT e.* FROM `events2021` e WHERE e.player_id = 27015 AND league_id = 56547 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 = 56547 AND rel.player_id=27015
    0.0106  SELECT action,minute FROM events2021 WHERE player_id = 27015 AND league_id = 56547 AND action = 18
    0.0108  SELECT action,minute FROM events2021 WHERE player_id = 27015 AND league_id = 56547 AND action = 19
    0.0112  SELECT e.* FROM `events2021` e WHERE e.player_id = 27015 AND league_id = 59872 ORDER BY e.date ASC
    0.0372  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 59872 AND rel.player_id=27015
    0.0107  SELECT action,minute FROM events2021 WHERE player_id = 27015 AND league_id = 59872 AND action = 18
    0.0106  SELECT action,minute FROM events2021 WHERE player_id = 27015 AND league_id = 59872 AND action = 19
    0.0106  SELECT e.* FROM `events2020` e WHERE e.player_id = 27015 AND league_id = 50064 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 = 50064 AND rel.player_id=27015
    0.0114  SELECT action,minute FROM events2020 WHERE player_id = 27015 AND league_id = 50064 AND action = 18
    0.0113  SELECT action,minute FROM events2020 WHERE player_id = 27015 AND league_id = 50064 AND action = 19
    0.0106  SELECT e.* FROM `events2020` e WHERE e.player_id = 27015 AND league_id = 49506 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 = 49506 AND rel.player_id=27015
    0.0106  SELECT action,minute FROM events2020 WHERE player_id = 27015 AND league_id = 49506 AND action = 18
    0.0105  SELECT action,minute FROM events2020 WHERE player_id = 27015 AND league_id = 49506 AND action = 19
    0.0106  SELECT e.* FROM `events2020` e WHERE e.player_id = 27015 AND league_id = 51355 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 = 51355 AND rel.player_id=27015
    0.0106  SELECT action,minute FROM events2020 WHERE player_id = 27015 AND league_id = 51355 AND action = 18
    0.0105  SELECT action,minute FROM events2020 WHERE player_id = 27015 AND league_id = 51355 AND action = 19
    0.0106  SELECT e.* FROM `events2019` e WHERE e.player_id = 27015 AND league_id = 43542 ORDER BY e.date ASC
    0.0127  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 43542 AND rel.player_id=27015
    0.0110  SELECT action,minute FROM events2019 WHERE player_id = 27015 AND league_id = 43542 AND action = 18
    0.0110  SELECT action,minute FROM events2019 WHERE player_id = 27015 AND league_id = 43542 AND action = 19
    0.0106  SELECT e.* FROM `events2019` e WHERE e.player_id = 27015 AND league_id = 43475 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 = 43475 AND rel.player_id=27015
    0.0106  SELECT action,minute FROM events2019 WHERE player_id = 27015 AND league_id = 43475 AND action = 18
    0.0106  SELECT action,minute FROM events2019 WHERE player_id = 27015 AND league_id = 43475 AND action = 19
    0.0108  SELECT e.* FROM `events2019` e WHERE e.player_id = 27015 AND league_id = 44594 ORDER BY e.date ASC
    0.0113  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 44594 AND rel.player_id=27015
    0.0105  SELECT action,minute FROM events2019 WHERE player_id = 27015 AND league_id = 44594 AND action = 18
    0.0106  SELECT action,minute FROM events2019 WHERE player_id = 27015 AND league_id = 44594 AND action = 19
    0.0106  SELECT e.* FROM `events2019` e WHERE e.player_id = 27015 AND league_id = 73284 ORDER BY e.date ASC
    0.0106  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 73284 AND rel.player_id=27015
    0.0105  SELECT action,minute FROM events2019 WHERE player_id = 27015 AND league_id = 73284 AND action = 18
    0.0105  SELECT action,minute FROM events2019 WHERE player_id = 27015 AND league_id = 73284 AND action = 19
    0.0107  SELECT e.* FROM `events2018` e WHERE e.player_id = 27015 AND league_id = 38645 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 = 38645 AND rel.player_id=27015
    0.0109  SELECT action,minute FROM events2018 WHERE player_id = 27015 AND league_id = 38645 AND action = 18
    0.0109  SELECT action,minute FROM events2018 WHERE player_id = 27015 AND league_id = 38645 AND action = 19
    0.0106  SELECT e.* FROM `events2018` e WHERE e.player_id = 27015 AND league_id = 38427 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 = 38427 AND rel.player_id=27015
    0.0106  SELECT action,minute FROM events2018 WHERE player_id = 27015 AND league_id = 38427 AND action = 18
    0.0105  SELECT action,minute FROM events2018 WHERE player_id = 27015 AND league_id = 38427 AND action = 19
    0.0105  SELECT e.* FROM `events2018` e WHERE e.player_id = 27015 AND league_id = 39175 ORDER BY e.date ASC
    0.0126  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 39175 AND rel.player_id=27015
    0.0105  SELECT action,minute FROM events2018 WHERE player_id = 27015 AND league_id = 39175 AND action = 18
    0.0106  SELECT action,minute FROM events2018 WHERE player_id = 27015 AND league_id = 39175 AND action = 19
    0.0108  SELECT e.* FROM `events2017` e WHERE e.player_id = 27015 AND league_id = 33377 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 = 33377 AND rel.player_id=27015
    0.0110  SELECT action,minute FROM events2017 WHERE player_id = 27015 AND league_id = 33377 AND action = 18
    0.0110  SELECT action,minute FROM events2017 WHERE player_id = 27015 AND league_id = 33377 AND action = 19
    0.0105  SELECT e.* FROM `events2017` e WHERE e.player_id = 27015 AND league_id = 30386 ORDER BY e.date ASC
    0.0196  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 30386 AND rel.player_id=27015
    0.0105  SELECT action,minute FROM events2017 WHERE player_id = 27015 AND league_id = 30386 AND action = 18
    0.0106  SELECT action,minute FROM events2017 WHERE player_id = 27015 AND league_id = 30386 AND action = 19
    0.0107  SELECT e.* FROM `events2017` e WHERE e.player_id = 27015 AND league_id = 33904 ORDER BY e.date ASC
    0.0115  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 33904 AND rel.player_id=27015
    0.0106  SELECT action,minute FROM events2017 WHERE player_id = 27015 AND league_id = 33904 AND action = 18
    0.0105  SELECT action,minute FROM events2017 WHERE player_id = 27015 AND league_id = 33904 AND action = 19
    0.0107  SELECT e.* FROM `events2016` e WHERE e.player_id = 27015 AND league_id = 15373 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 = 15373 AND rel.player_id=27015
    0.0108  SELECT action,minute FROM events2016 WHERE player_id = 27015 AND league_id = 15373 AND action = 18
    0.0107  SELECT action,minute FROM events2016 WHERE player_id = 27015 AND league_id = 15373 AND action = 19
    0.0107  SELECT e.* FROM `events2016` e WHERE e.player_id = 27015 AND league_id = 16245 ORDER BY e.date ASC
    0.0108  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 16245 AND rel.player_id=27015
    0.0108  SELECT action,minute FROM events2016 WHERE player_id = 27015 AND league_id = 16245 AND action = 18
    0.0107  SELECT action,minute FROM events2016 WHERE player_id = 27015 AND league_id = 16245 AND action = 19
    0.0114  SELECT e.* FROM `events2016` e WHERE e.player_id = 27015 AND league_id = 16597 ORDER BY e.date ASC
    0.0124  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 16597 AND rel.player_id=27015
    0.0107  SELECT action,minute FROM events2016 WHERE player_id = 27015 AND league_id = 16597 AND action = 18
    0.0106  SELECT action,minute FROM events2016 WHERE player_id = 27015 AND league_id = 16597 AND action = 19
    0.0110  SELECT e.* FROM `events2016` e WHERE e.player_id = 27015 AND league_id = 73041 ORDER BY e.date ASC
    0.0106  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 73041 AND rel.player_id=27015
    0.0106  SELECT action,minute FROM events2016 WHERE player_id = 27015 AND league_id = 73041 AND action = 18
    0.0106  SELECT action,minute FROM events2016 WHERE player_id = 27015 AND league_id = 73041 AND action = 19
    0.0106  SELECT e.* FROM `events2015` e WHERE e.player_id = 27015 AND league_id = 3775 ORDER BY e.date ASC
    0.0159  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 3775 AND rel.player_id=27015
    0.0106  SELECT action,minute FROM events2015 WHERE player_id = 27015 AND league_id = 3775 AND action = 18
    0.0106  SELECT action,minute FROM events2015 WHERE player_id = 27015 AND league_id = 3775 AND action = 19
    0.0106  SELECT e.* FROM `events2015` e WHERE e.player_id = 27015 AND league_id = 3804 ORDER BY e.date ASC
    0.0108  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 3804 AND rel.player_id=27015
    0.0107  SELECT action,minute FROM events2015 WHERE player_id = 27015 AND league_id = 3804 AND action = 18
    0.0107  SELECT action,minute FROM events2015 WHERE player_id = 27015 AND league_id = 3804 AND action = 19
    0.0107  SELECT e.* FROM `events2015` e WHERE e.player_id = 27015 AND league_id = 3992 ORDER BY e.date ASC
    0.0145  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 3992 AND rel.player_id=27015
    0.0108  SELECT action,minute FROM events2015 WHERE player_id = 27015 AND league_id = 3992 AND action = 18
    0.0107  SELECT action,minute FROM events2015 WHERE player_id = 27015 AND league_id = 3992 AND action = 19
    0.0112  SELECT e.* FROM `events2014` e WHERE e.player_id = 27015 AND league_id = 2401 ORDER BY e.date ASC
    0.0147  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 2401 AND rel.player_id=27015
    0.0113  SELECT action,minute FROM events2014 WHERE player_id = 27015 AND league_id = 2401 AND action = 18
    0.0112  SELECT action,minute FROM events2014 WHERE player_id = 27015 AND league_id = 2401 AND action = 19
    0.0105  SELECT e.* FROM `events2014` e WHERE e.player_id = 27015 AND league_id = 2399 ORDER BY e.date ASC
    0.0111  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 2399 AND rel.player_id=27015
    0.0106  SELECT action,minute FROM events2014 WHERE player_id = 27015 AND league_id = 2399 AND action = 18
    0.0109  SELECT action,minute FROM events2014 WHERE player_id = 27015 AND league_id = 2399 AND action = 19
    0.0108  SELECT e.* FROM `events2014` e WHERE e.player_id = 27015 AND league_id = 2735 ORDER BY e.date ASC
    0.0116  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 2735 AND rel.player_id=27015
    0.0106  SELECT action,minute FROM events2014 WHERE player_id = 27015 AND league_id = 2735 AND action = 18
    0.0106  SELECT action,minute FROM events2014 WHERE player_id = 27015 AND league_id = 2735 AND action = 19
    0.0106  SELECT e.* FROM `events2014` e WHERE e.player_id = 27015 AND league_id = 73153 ORDER BY e.date ASC
    0.0106  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 73153 AND rel.player_id=27015
    0.0107  SELECT action,minute FROM events2014 WHERE player_id = 27015 AND league_id = 73153 AND action = 18
    0.0107  SELECT action,minute FROM events2014 WHERE player_id = 27015 AND league_id = 73153 AND action = 19
    0.0109  SELECT e.* FROM `events2013` e WHERE e.player_id = 27015 AND league_id = 1907 ORDER BY e.date ASC
    0.0126  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 1907 AND rel.player_id=27015
    0.0106  SELECT action,minute FROM events2013 WHERE player_id = 27015 AND league_id = 1907 AND action = 18
    0.0106  SELECT action,minute FROM events2013 WHERE player_id = 27015 AND league_id = 1907 AND action = 19
    0.0116  SELECT e.* FROM `events2013` e WHERE e.player_id = 27015 AND league_id = 1969 ORDER BY e.date ASC
    0.0171  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 1969 AND rel.player_id=27015
    0.0111  SELECT action,minute FROM events2013 WHERE player_id = 27015 AND league_id = 1969 AND action = 18
    0.0109  SELECT action,minute FROM events2013 WHERE player_id = 27015 AND league_id = 1969 AND action = 19
    0.0107  SELECT e.* FROM `events2013` e WHERE e.player_id = 27015 AND league_id = 2160 ORDER BY e.date ASC
    0.0109  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 2160 AND rel.player_id=27015
    0.0108  SELECT action,minute FROM events2013 WHERE player_id = 27015 AND league_id = 2160 AND action = 18
    0.0118  SELECT action,minute FROM events2013 WHERE player_id = 27015 AND league_id = 2160 AND action = 19
    0.0108  SELECT e.* FROM `events2013` e WHERE e.player_id = 27015 AND league_id = 2257 ORDER BY e.date ASC
    0.0118  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 2257 AND rel.player_id=27015
    0.0106  SELECT action,minute FROM events2013 WHERE player_id = 27015 AND league_id = 2257 AND action = 18
    0.0106  SELECT action,minute FROM events2013 WHERE player_id = 27015 AND league_id = 2257 AND action = 19
    0.0106  SELECT e.* FROM `events2013` e WHERE e.player_id = 27015 AND league_id = 41754 ORDER BY e.date ASC
    0.0137  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 41754 AND rel.player_id=27015
    0.0106  SELECT action,minute FROM events2013 WHERE player_id = 27015 AND league_id = 41754 AND action = 18
    0.0105  SELECT action,minute FROM events2013 WHERE player_id = 27015 AND league_id = 41754 AND action = 19
    0.0106  SELECT e.* FROM `events2012` e WHERE e.player_id = 27015 AND league_id = 1334 ORDER BY e.date ASC
    0.0124  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 1334 AND rel.player_id=27015
    0.0106  SELECT action,minute FROM events2012 WHERE player_id = 27015 AND league_id = 1334 AND action = 18
    0.0106  SELECT action,minute FROM events2012 WHERE player_id = 27015 AND league_id = 1334 AND action = 19
    0.0106  SELECT e.* FROM `events2012` e WHERE e.player_id = 27015 AND league_id = 1437 ORDER BY e.date ASC
    0.0124  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 1437 AND rel.player_id=27015
    0.0107  SELECT action,minute FROM events2012 WHERE player_id = 27015 AND league_id = 1437 AND action = 18
    0.0108  SELECT action,minute FROM events2012 WHERE player_id = 27015 AND league_id = 1437 AND action = 19
    0.0110  SELECT e.* FROM `events2011` e WHERE e.player_id = 27015 AND league_id = 1100 ORDER BY e.date ASC
    0.0109  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 1100 AND rel.player_id=27015
    0.0109  SELECT action,minute FROM events2011 WHERE player_id = 27015 AND league_id = 1100 AND action = 18
    0.0109  SELECT action,minute FROM events2011 WHERE player_id = 27015 AND league_id = 1100 AND action = 19
    0.0108  SELECT e.* FROM `events2011` e WHERE e.player_id = 27015 AND league_id = 1115 ORDER BY e.date ASC
    0.0142  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 1115 AND rel.player_id=27015
    0.0106  SELECT action,minute FROM events2011 WHERE player_id = 27015 AND league_id = 1115 AND action = 18
    0.0105  SELECT action,minute FROM events2011 WHERE player_id = 27015 AND league_id = 1115 AND action = 19
    0.0108  SELECT e.* FROM `events2011` e WHERE e.player_id = 27015 AND league_id = 1312 ORDER BY e.date ASC
    0.0108  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 1312 AND rel.player_id=27015
    0.0106  SELECT action,minute FROM events2011 WHERE player_id = 27015 AND league_id = 1312 AND action = 18
    0.0105  SELECT action,minute FROM events2011 WHERE player_id = 27015 AND league_id = 1312 AND action = 19
    0.0107  SELECT e.* FROM `events2010` e WHERE e.player_id = 27015 AND league_id = 811 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 = 811 AND rel.player_id=27015
    0.0106  SELECT action,minute FROM events2010 WHERE player_id = 27015 AND league_id = 811 AND action = 18
    0.0116  SELECT action,minute FROM events2010 WHERE player_id = 27015 AND league_id = 811 AND action = 19
    0.0106  SELECT e.* FROM `events2009` e WHERE e.player_id = 27015 AND league_id = 104 ORDER BY e.date ASC
    0.0127  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 104 AND rel.player_id=27015
    0.0105  SELECT action,minute FROM events2009 WHERE player_id = 27015 AND league_id = 104 AND action = 18
    0.0106  SELECT action,minute FROM events2009 WHERE player_id = 27015 AND league_id = 104 AND action = 19
    0.0105  SELECT e.* FROM `events2009` e WHERE e.player_id = 27015 AND league_id = 805 ORDER BY e.date ASC
    0.0113  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 805 AND rel.player_id=27015
    0.0105  SELECT action,minute FROM events2009 WHERE player_id = 27015 AND league_id = 805 AND action = 18
    0.0105  SELECT action,minute FROM events2009 WHERE player_id = 27015 AND league_id = 805 AND action = 19
    0.0113  SELECT e.* FROM `events2008` e WHERE e.player_id = 27015 AND league_id = 2 ORDER BY e.date ASC
    0.0172  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 2 AND rel.player_id=27015
    0.0107  SELECT action,minute FROM events2008 WHERE player_id = 27015 AND league_id = 2 AND action = 18
    0.0105  SELECT action,minute FROM events2008 WHERE player_id = 27015 AND league_id = 2 AND action = 19
    0.0106  SELECT e.* FROM `events2007` e WHERE e.player_id = 27015 AND league_id = 81 ORDER BY e.date ASC
    0.0137  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 81 AND rel.player_id=27015
    0.0105  SELECT action,minute FROM events2007 WHERE player_id = 27015 AND league_id = 81 AND action = 18
    0.0105  SELECT action,minute FROM events2007 WHERE player_id = 27015 AND league_id = 81 AND action = 19
    0.0106  SELECT e.* FROM `events2007` e WHERE e.player_id = 27015 AND league_id = 20576 ORDER BY e.date ASC
    0.0127  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 20576 AND rel.player_id=27015
    0.0105  SELECT action,minute FROM events2007 WHERE player_id = 27015 AND league_id = 20576 AND action = 18
    0.0106  SELECT action,minute FROM events2007 WHERE player_id = 27015 AND league_id = 20576 AND action = 19
    0.0107  SELECT e.* FROM `events2006` e WHERE e.player_id = 27015 AND league_id = 534 ORDER BY e.date ASC
    0.0105  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 534 AND rel.player_id=27015
    0.0105  SELECT action,minute FROM events2006 WHERE player_id = 27015 AND league_id = 534 AND action = 18
    0.0105  SELECT action,minute FROM events2006 WHERE player_id = 27015 AND league_id = 534 AND action = 19
    0.0106  SELECT e.* FROM `events2006` e WHERE e.player_id = 27015 AND league_id = 11987 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 = 11987 AND rel.player_id=27015
    0.0105  SELECT action,minute FROM events2006 WHERE player_id = 27015 AND league_id = 11987 AND action = 18
    0.0106  SELECT action,minute FROM events2006 WHERE player_id = 27015 AND league_id = 11987 AND action = 19
    0.0106  SELECT e.* FROM `events2006` e WHERE e.player_id = 27015 AND league_id = 20577 ORDER BY e.date ASC
    0.0113  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 20577 AND rel.player_id=27015
    0.0105  SELECT action,minute FROM events2006 WHERE player_id = 27015 AND league_id = 20577 AND action = 18
    0.0105  SELECT action,minute FROM events2006 WHERE player_id = 27015 AND league_id = 20577 AND action = 19
    0.0106  SELECT e.* FROM `events2006` e WHERE e.player_id = 27015 AND league_id = 44811 ORDER BY e.date ASC
    0.0106  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 44811 AND rel.player_id=27015
    0.0106  SELECT action,minute FROM events2006 WHERE player_id = 27015 AND league_id = 44811 AND action = 18
    0.0105  SELECT action,minute FROM events2006 WHERE player_id = 27015 AND league_id = 44811 AND action = 19
    0.0401  SELECT e.* FROM `events2006` e WHERE e.player_id = 27015 AND league_id = 72821 ORDER BY e.date ASC
    0.0106  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 72821 AND rel.player_id=27015
    0.0105  SELECT action,minute FROM events2006 WHERE player_id = 27015 AND league_id = 72821 AND action = 18
    0.0106  SELECT action,minute FROM events2006 WHERE player_id = 27015 AND league_id = 72821 AND action = 19
    0.0107  SELECT e.* FROM `events2005` e WHERE e.player_id = 27015 AND league_id = 40 ORDER BY e.date ASC
    0.0126  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 40 AND rel.player_id=27015
    0.0105  SELECT action,minute FROM events2005 WHERE player_id = 27015 AND league_id = 40 AND action = 18
    0.0106  SELECT action,minute FROM events2005 WHERE player_id = 27015 AND league_id = 40 AND action = 19
    0.0106  SELECT e.* FROM `events2004` e WHERE e.player_id = 27015 AND league_id = 178 ORDER BY e.date ASC
    0.0105  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 178 AND rel.player_id=27015
    0.0106  SELECT action,minute FROM events2004 WHERE player_id = 27015 AND league_id = 178 AND action = 18
    0.0105  SELECT action,minute FROM events2004 WHERE player_id = 27015 AND league_id = 178 AND action = 19
    0.0108  SELECT e.* FROM `events2003` e WHERE e.player_id = 27015 AND league_id = 5515 ORDER BY e.date ASC
    0.0107  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 5515 AND rel.player_id=27015
    0.0105  SELECT action,minute FROM events2003 WHERE player_id = 27015 AND league_id = 5515 AND action = 18
    0.0105  SELECT action,minute FROM events2003 WHERE player_id = 27015 AND league_id = 5515 AND action = 19
    0.0111   SELECT c.comment,c.id,c.author_id,c.author_name,c.last_update,c.creation_date,c.votes_up, c.device, fau.user_name, fau.adm AS user_adm, fau.role AS user_role, fau.adm_type AS user_adm_type, c.template, NOW() AS difference_time, fau.changeA AS changeA FROM comments AS c LEFT JOIN fa_user_mini AS fau ON fau.id = c.author_id WHERE c.`active` = 1 AND c.device = 'web' AND c.to_review=0 AND c.comment_id=0 AND c.lang = '1' AND c.language = 'es' AND c.`playerId` = '27015' ORDER BY c.last_update DESC, c.creation_date DESC LIMIT 0,15
    0.0107   SELECT c.id, c.author_name, c.comment, c.comment_id, c.author_id, c.creation_date, c.votes_up, c.device, fau.user_name, fau.adm AS user_adm, fau.role AS user_role, fau.adm_type AS user_adm_type, template, NOW() AS difference_time FROM comments AS c LEFT JOIN fa_user_mini AS fau ON fau.id = c.author_id WHERE c.`active`=1 AND c.to_review=0 AND c.device = 'web' AND c.comment_id = '1145689' AND c.lang = '1' ORDER BY creation_date DESC LIMIT 20
    0.0108   SELECT c.id, c.author_name, c.comment, c.comment_id, c.author_id, c.creation_date, c.votes_up, c.device, fau.user_name, fau.adm AS user_adm, fau.role AS user_role, fau.adm_type AS user_adm_type, template, NOW() AS difference_time FROM comments AS c LEFT JOIN fa_user_mini AS fau ON fau.id = c.author_id WHERE c.`active`=1 AND c.to_review=0 AND c.device = 'web' AND c.comment_id = '897156' AND c.lang = '1' ORDER BY creation_date DESC LIMIT 20