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

Rodellar

Jugador del SCD Durango
Liga
  • Competición
  • Partidos jugados
  • Minutos jugados
  • Asistencia
  • Goles marcados
  • Tarjetas amarillas
  • Tarjetas rojas
  • info
Ficha de Rodellar
Nacionalidad
España
Nombre
Iker Rodellar Fernández
Edad
37 Años (26-03-1987)
Altura
177
Dorsal
16
Peso
72 kilogramos
Equipo
SCD Durango
Posición
Centrocampista
Liga
Tercera Federación 2022 G 4
  • Jugador del SCD Durango desde hace 2 años
  • Compañeros de equipo
    Fotos
    5
    • Foto principal de Rodellar | SD Logroñés
    • Foto principal de Rodellar | SD Logroñés
    • Iker Rodellar
    • Rodellar
    • BIDASOA
      Hace 10 años BIDASOA dice: Bienvenido al Real Unión
    • penches1
      Hace 14 años penches1 dice: Nombre Íker Rodellar Fernández Lugar de nacimiento San Sebastián Fecha de nacimiento 26 de Marzo de 1987 Estatura 1,75 cm. Peso 68 kgs. Procedencia Ciudad Lorquí (2009) Demarcación MediocentroNombre Íker Rodellar Fernández Lugar de nacimiento San Sebastián Fecha de nacimiento 26 de Marzo de 1987 Estatura 1,75 cm. Peso 68 kgs. Procedencia Ciudad Lorquí (2009) Demarcación Mediocentro
    Uso de cookies: Utilizamos "cookies" propias y de terceros para mejorar nuestros servicios, elaborar información estadística, analizar sus hábitos de navegación e inferir grupos de interés. Esto nos permite personalizar el contenido que ofrecemos y mostrarle publicidad relacionada con sus preferencias. Adicionalmente, compartimos los análisis de navegación y los grupos de interés inferidos con terceros. Si continúa navegando acepta su uso. Más información y cambio de configuración. Aceptar

      USO DE MEMORIA  
    10,984,968 bytes
      BENCHMARKS  
    Loading Time Base Classes  0.0021
    Controller Execution Time ( Player / Index )  0.6721
    Total Execution Time  0.6742
      CADENA URL  
    /jugador/rodellar-31215
      GET DATOS  
    $_GET['/jugador/rodellar-31215']  
      POST DATOS  
    No hay datos POST existentes
      CONSULTAS (213)  
    0.0007   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` = '31215' AND c.comment_id IN (2189933,54423) GROUP BY c.comment_id
    0.0025  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 = 'rodellar-31215' ORDER BY rp.year DESC, ct.troncal DESC, rp.in_squad DESC
    0.0148  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 = 'rodellar-31215' ORDER BY rp.year DESC, ct.troncal DESC, rp.in_squad DESC
    0.0067  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 = 58609
    0.0027  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 = 59872
    0.0025  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 = 61719
    0.0026  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 = 44098
    0.0023  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 = 47390
    0.0025  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 = 38807
    0.0022  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 = 39175
    0.0023  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 = 33379
    0.0023  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.0023  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 = 37067
    0.0023  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 = 15376
    0.0024  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 = 16245
    0.0022  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 = 19524
    0.0023  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 = 3863
    0.0022  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 = 4851
    0.0024  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 = 14186
    0.0023  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 = 2469
    0.0024  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 = 3361
    0.0023  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 = 1903
    0.0023  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.0024  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 = 826
    0.0026  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 = 128
    0.0023  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 = 805
    0.0053  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 = 5
    0.0062  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 = 58905
    0.0024  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 = 59985
    0.0018  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 = '31215'
    0.0028  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 = 62388 AND rp.teamId = 576 AND rp.in_squad=1 ORDER BY p.role>0 DESC, p.role ASC, rp.squadNumber ASC
    0.0022  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 = 31215 ORDER BY rp.year DESC
    0.0022  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 = '31215' and rp.type = 3 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
    0.0018  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '31215' and rp.type = 3
    0.0020  SELECT e.* FROM `events2022` e WHERE e.player_id = 31215 AND league_id = 62388 ORDER BY e.date ASC
    0.0072  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 62388 AND rel.player_id=31215
    0.0024  SELECT action,minute FROM events2022 WHERE player_id = 31215 AND league_id = 62388 AND action = 18
    0.0023  SELECT action,minute FROM events2022 WHERE player_id = 31215 AND league_id = 62388 AND action = 19
    0.0018  SELECT e.* FROM `events2022` e WHERE e.player_id = 31215 AND league_id = 62807 ORDER BY e.date ASC
    0.0044  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 62807 AND rel.player_id=31215
    0.0018  SELECT action,minute FROM events2022 WHERE player_id = 31215 AND league_id = 62807 AND action = 18
    0.0018  SELECT action,minute FROM events2022 WHERE player_id = 31215 AND league_id = 62807 AND action = 19
    0.0019  SELECT e.* FROM `events2021` e WHERE e.player_id = 31215 AND league_id = 58609 ORDER BY e.date ASC
    0.0041  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 58609 AND rel.player_id=31215
    0.0021  SELECT action,minute FROM events2021 WHERE player_id = 31215 AND league_id = 58609 AND action = 18
    0.0021  SELECT action,minute FROM events2021 WHERE player_id = 31215 AND league_id = 58609 AND action = 19
    0.0020  SELECT e.* FROM `events2021` e WHERE e.player_id = 31215 AND league_id = 56547 ORDER BY e.date ASC
    0.0038  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=31215
    0.0018  SELECT action,minute FROM events2021 WHERE player_id = 31215 AND league_id = 56547 AND action = 18
    0.0018  SELECT action,minute FROM events2021 WHERE player_id = 31215 AND league_id = 56547 AND action = 19
    0.0018  SELECT e.* FROM `events2021` e WHERE e.player_id = 31215 AND league_id = 59872 ORDER BY e.date ASC
    0.0066  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=31215
    0.0018  SELECT action,minute FROM events2021 WHERE player_id = 31215 AND league_id = 59872 AND action = 18
    0.0018  SELECT action,minute FROM events2021 WHERE player_id = 31215 AND league_id = 59872 AND action = 19
    0.0019  SELECT e.* FROM `events2021` e WHERE e.player_id = 31215 AND league_id = 61719 ORDER BY e.date ASC
    0.0039  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 61719 AND rel.player_id=31215
    0.0020  SELECT action,minute FROM events2021 WHERE player_id = 31215 AND league_id = 61719 AND action = 18
    0.0019  SELECT action,minute FROM events2021 WHERE player_id = 31215 AND league_id = 61719 AND action = 19
    0.0022  SELECT e.* FROM `events2020` e WHERE e.player_id = 31215 AND league_id = 50265 ORDER BY e.date ASC
    0.0056  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 50265 AND rel.player_id=31215
    0.0023  SELECT action,minute FROM events2020 WHERE player_id = 31215 AND league_id = 50265 AND action = 18
    0.0023  SELECT action,minute FROM events2020 WHERE player_id = 31215 AND league_id = 50265 AND action = 19
    0.0019  SELECT e.* FROM `events2020` e WHERE e.player_id = 31215 AND league_id = 49506 ORDER BY e.date ASC
    0.0040  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=31215
    0.0019  SELECT action,minute FROM events2020 WHERE player_id = 31215 AND league_id = 49506 AND action = 18
    0.0019  SELECT action,minute FROM events2020 WHERE player_id = 31215 AND league_id = 49506 AND action = 19
    0.0019  SELECT e.* FROM `events2020` e WHERE e.player_id = 31215 AND league_id = 51355 ORDER BY e.date ASC
    0.0045  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=31215
    0.0019  SELECT action,minute FROM events2020 WHERE player_id = 31215 AND league_id = 51355 AND action = 18
    0.0020  SELECT action,minute FROM events2020 WHERE player_id = 31215 AND league_id = 51355 AND action = 19
    0.0022  SELECT e.* FROM `events2019` e WHERE e.player_id = 31215 AND league_id = 44098 ORDER BY e.date ASC
    0.0067  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 44098 AND rel.player_id=31215
    0.0027  SELECT action,minute FROM events2019 WHERE player_id = 31215 AND league_id = 44098 AND action = 18
    0.0022  SELECT action,minute FROM events2019 WHERE player_id = 31215 AND league_id = 44098 AND action = 19
    0.0019  SELECT e.* FROM `events2019` e WHERE e.player_id = 31215 AND league_id = 43475 ORDER BY e.date ASC
    0.0051  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=31215
    0.0018  SELECT action,minute FROM events2019 WHERE player_id = 31215 AND league_id = 43475 AND action = 18
    0.0018  SELECT action,minute FROM events2019 WHERE player_id = 31215 AND league_id = 43475 AND action = 19
    0.0018  SELECT e.* FROM `events2019` e WHERE e.player_id = 31215 AND league_id = 44594 ORDER BY e.date ASC
    0.0053  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=31215
    0.0018  SELECT action,minute FROM events2019 WHERE player_id = 31215 AND league_id = 44594 AND action = 18
    0.0018  SELECT action,minute FROM events2019 WHERE player_id = 31215 AND league_id = 44594 AND action = 19
    0.0018  SELECT e.* FROM `events2019` e WHERE e.player_id = 31215 AND league_id = 47390 ORDER BY e.date ASC
    0.0071  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 47390 AND rel.player_id=31215
    0.0019  SELECT action,minute FROM events2019 WHERE player_id = 31215 AND league_id = 47390 AND action = 18
    0.0018  SELECT action,minute FROM events2019 WHERE player_id = 31215 AND league_id = 47390 AND action = 19
    0.0020  SELECT e.* FROM `events2018` e WHERE e.player_id = 31215 AND league_id = 38807 ORDER BY e.date ASC
    0.0070  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 38807 AND rel.player_id=31215
    0.0023  SELECT action,minute FROM events2018 WHERE player_id = 31215 AND league_id = 38807 AND action = 18
    0.0023  SELECT action,minute FROM events2018 WHERE player_id = 31215 AND league_id = 38807 AND action = 19
    0.0019  SELECT e.* FROM `events2018` e WHERE e.player_id = 31215 AND league_id = 38427 ORDER BY e.date ASC
    0.0057  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=31215
    0.0018  SELECT action,minute FROM events2018 WHERE player_id = 31215 AND league_id = 38427 AND action = 18
    0.0018  SELECT action,minute FROM events2018 WHERE player_id = 31215 AND league_id = 38427 AND action = 19
    0.0018  SELECT e.* FROM `events2018` e WHERE e.player_id = 31215 AND league_id = 39175 ORDER BY e.date ASC
    0.0095  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=31215
    0.0018  SELECT action,minute FROM events2018 WHERE player_id = 31215 AND league_id = 39175 AND action = 18
    0.0018  SELECT action,minute FROM events2018 WHERE player_id = 31215 AND league_id = 39175 AND action = 19
    0.0019  SELECT e.* FROM `events2017` e WHERE e.player_id = 31215 AND league_id = 33379 ORDER BY e.date ASC
    0.0074  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 33379 AND rel.player_id=31215
    0.0022  SELECT action,minute FROM events2017 WHERE player_id = 31215 AND league_id = 33379 AND action = 18
    0.0022  SELECT action,minute FROM events2017 WHERE player_id = 31215 AND league_id = 33379 AND action = 19
    0.0018  SELECT e.* FROM `events2017` e WHERE e.player_id = 31215 AND league_id = 30386 ORDER BY e.date ASC
    0.0062  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=31215
    0.0018  SELECT action,minute FROM events2017 WHERE player_id = 31215 AND league_id = 30386 AND action = 18
    0.0018  SELECT action,minute FROM events2017 WHERE player_id = 31215 AND league_id = 30386 AND action = 19
    0.0018  SELECT e.* FROM `events2017` e WHERE e.player_id = 31215 AND league_id = 33904 ORDER BY e.date ASC
    0.0064  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=31215
    0.0018  SELECT action,minute FROM events2017 WHERE player_id = 31215 AND league_id = 33904 AND action = 18
    0.0019  SELECT action,minute FROM events2017 WHERE player_id = 31215 AND league_id = 33904 AND action = 19
    0.0018  SELECT e.* FROM `events2017` e WHERE e.player_id = 31215 AND league_id = 37067 ORDER BY e.date ASC
    0.0066  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 37067 AND rel.player_id=31215
    0.0018  SELECT action,minute FROM events2017 WHERE player_id = 31215 AND league_id = 37067 AND action = 18
    0.0018  SELECT action,minute FROM events2017 WHERE player_id = 31215 AND league_id = 37067 AND action = 19
    0.0020  SELECT e.* FROM `events2016` e WHERE e.player_id = 31215 AND league_id = 15376 ORDER BY e.date ASC
    0.0063  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 15376 AND rel.player_id=31215
    0.0020  SELECT action,minute FROM events2016 WHERE player_id = 31215 AND league_id = 15376 AND action = 18
    0.0019  SELECT action,minute FROM events2016 WHERE player_id = 31215 AND league_id = 15376 AND action = 19
    0.0019  SELECT e.* FROM `events2016` e WHERE e.player_id = 31215 AND league_id = 16245 ORDER BY e.date ASC
    0.0065  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=31215
    0.0018  SELECT action,minute FROM events2016 WHERE player_id = 31215 AND league_id = 16245 AND action = 18
    0.0019  SELECT action,minute FROM events2016 WHERE player_id = 31215 AND league_id = 16245 AND action = 19
    0.0020  SELECT e.* FROM `events2016` e WHERE e.player_id = 31215 AND league_id = 16597 ORDER BY e.date ASC
    0.0050  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=31215
    0.0018  SELECT action,minute FROM events2016 WHERE player_id = 31215 AND league_id = 16597 AND action = 18
    0.0018  SELECT action,minute FROM events2016 WHERE player_id = 31215 AND league_id = 16597 AND action = 19
    0.0018  SELECT e.* FROM `events2016` e WHERE e.player_id = 31215 AND league_id = 19524 ORDER BY e.date ASC
    0.0047  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 19524 AND rel.player_id=31215
    0.0019  SELECT action,minute FROM events2016 WHERE player_id = 31215 AND league_id = 19524 AND action = 18
    0.0018  SELECT action,minute FROM events2016 WHERE player_id = 31215 AND league_id = 19524 AND action = 19
    0.0020  SELECT e.* FROM `events2015` e WHERE e.player_id = 31215 AND league_id = 3863 ORDER BY e.date ASC
    0.0066  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 3863 AND rel.player_id=31215
    0.0019  SELECT action,minute FROM events2015 WHERE player_id = 31215 AND league_id = 3863 AND action = 18
    0.0020  SELECT action,minute FROM events2015 WHERE player_id = 31215 AND league_id = 3863 AND action = 19
    0.0020  SELECT e.* FROM `events2015` e WHERE e.player_id = 31215 AND league_id = 3804 ORDER BY e.date ASC
    0.0084  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=31215
    0.0019  SELECT action,minute FROM events2015 WHERE player_id = 31215 AND league_id = 3804 AND action = 18
    0.0021  SELECT action,minute FROM events2015 WHERE player_id = 31215 AND league_id = 3804 AND action = 19
    0.0019  SELECT e.* FROM `events2015` e WHERE e.player_id = 31215 AND league_id = 4851 ORDER BY e.date ASC
    0.0062  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 4851 AND rel.player_id=31215
    0.0019  SELECT action,minute FROM events2015 WHERE player_id = 31215 AND league_id = 4851 AND action = 18
    0.0018  SELECT action,minute FROM events2015 WHERE player_id = 31215 AND league_id = 4851 AND action = 19
    0.0019  SELECT e.* FROM `events2015` e WHERE e.player_id = 31215 AND league_id = 14186 ORDER BY e.date ASC
    0.0065  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 14186 AND rel.player_id=31215
    0.0019  SELECT action,minute FROM events2015 WHERE player_id = 31215 AND league_id = 14186 AND action = 18
    0.0018  SELECT action,minute FROM events2015 WHERE player_id = 31215 AND league_id = 14186 AND action = 19
    0.0020  SELECT e.* FROM `events2014` e WHERE e.player_id = 31215 AND league_id = 2469 ORDER BY e.date ASC
    0.0055  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 2469 AND rel.player_id=31215
    0.0019  SELECT action,minute FROM events2014 WHERE player_id = 31215 AND league_id = 2469 AND action = 18
    0.0019  SELECT action,minute FROM events2014 WHERE player_id = 31215 AND league_id = 2469 AND action = 19
    0.0018  SELECT e.* FROM `events2014` e WHERE e.player_id = 31215 AND league_id = 2399 ORDER BY e.date ASC
    0.0047  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=31215
    0.0018  SELECT action,minute FROM events2014 WHERE player_id = 31215 AND league_id = 2399 AND action = 18
    0.0021  SELECT action,minute FROM events2014 WHERE player_id = 31215 AND league_id = 2399 AND action = 19
    0.0019  SELECT e.* FROM `events2014` e WHERE e.player_id = 31215 AND league_id = 2735 ORDER BY e.date ASC
    0.0046  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=31215
    0.0019  SELECT action,minute FROM events2014 WHERE player_id = 31215 AND league_id = 2735 AND action = 18
    0.0018  SELECT action,minute FROM events2014 WHERE player_id = 31215 AND league_id = 2735 AND action = 19
    0.0018  SELECT e.* FROM `events2014` e WHERE e.player_id = 31215 AND league_id = 3361 ORDER BY e.date ASC
    0.0020  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 3361 AND rel.player_id=31215
    0.0018  SELECT action,minute FROM events2014 WHERE player_id = 31215 AND league_id = 3361 AND action = 18
    0.0018  SELECT action,minute FROM events2014 WHERE player_id = 31215 AND league_id = 3361 AND action = 19
    0.0019  SELECT e.* FROM `events2013` e WHERE e.player_id = 31215 AND league_id = 1903 ORDER BY e.date ASC
    0.0018  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 1903 AND rel.player_id=31215
    0.0019  SELECT action,minute FROM events2013 WHERE player_id = 31215 AND league_id = 1903 AND action = 18
    0.0019  SELECT action,minute FROM events2013 WHERE player_id = 31215 AND league_id = 1903 AND action = 19
    0.0018  SELECT e.* FROM `events2013` e WHERE e.player_id = 31215 AND league_id = 1969 ORDER BY e.date ASC
    0.0059  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=31215
    0.0018  SELECT action,minute FROM events2013 WHERE player_id = 31215 AND league_id = 1969 AND action = 18
    0.0018  SELECT action,minute FROM events2013 WHERE player_id = 31215 AND league_id = 1969 AND action = 19
    0.0020  SELECT e.* FROM `events2012` e WHERE e.player_id = 31215 AND league_id = 1347 ORDER BY e.date ASC
    0.0067  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 1347 AND rel.player_id=31215
    0.0019  SELECT action,minute FROM events2012 WHERE player_id = 31215 AND league_id = 1347 AND action = 18
    0.0019  SELECT action,minute FROM events2012 WHERE player_id = 31215 AND league_id = 1347 AND action = 19
    0.0021  SELECT e.* FROM `events2012` e WHERE e.player_id = 31215 AND league_id = 1437 ORDER BY e.date ASC
    0.0051  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=31215
    0.0018  SELECT action,minute FROM events2012 WHERE player_id = 31215 AND league_id = 1437 AND action = 18
    0.0018  SELECT action,minute FROM events2012 WHERE player_id = 31215 AND league_id = 1437 AND action = 19
    0.0020  SELECT e.* FROM `events2011` e WHERE e.player_id = 31215 AND league_id = 1102 ORDER BY e.date ASC
    0.0048  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 1102 AND rel.player_id=31215
    0.0019  SELECT action,minute FROM events2011 WHERE player_id = 31215 AND league_id = 1102 AND action = 18
    0.0019  SELECT action,minute FROM events2011 WHERE player_id = 31215 AND league_id = 1102 AND action = 19
    0.0020  SELECT e.* FROM `events2010` e WHERE e.player_id = 31215 AND league_id = 826 ORDER BY e.date ASC
    0.0020  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 826 AND rel.player_id=31215
    0.0019  SELECT action,minute FROM events2010 WHERE player_id = 31215 AND league_id = 826 AND action = 18
    0.0019  SELECT action,minute FROM events2010 WHERE player_id = 31215 AND league_id = 826 AND action = 19
    0.0020  SELECT e.* FROM `events2009` e WHERE e.player_id = 31215 AND league_id = 128 ORDER BY e.date ASC
    0.0020  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 128 AND rel.player_id=31215
    0.0018  SELECT action,minute FROM events2009 WHERE player_id = 31215 AND league_id = 128 AND action = 18
    0.0018  SELECT action,minute FROM events2009 WHERE player_id = 31215 AND league_id = 128 AND action = 19
    0.0019  SELECT e.* FROM `events2009` e WHERE e.player_id = 31215 AND league_id = 805 ORDER BY e.date ASC
    0.0060  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=31215
    0.0018  SELECT action,minute FROM events2009 WHERE player_id = 31215 AND league_id = 805 AND action = 18
    0.0018  SELECT action,minute FROM events2009 WHERE player_id = 31215 AND league_id = 805 AND action = 19
    0.0021  SELECT e.* FROM `events2008` e WHERE e.player_id = 31215 AND league_id = 5 ORDER BY e.date ASC
    0.0020  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 5 AND rel.player_id=31215
    0.0018  SELECT action,minute FROM events2008 WHERE player_id = 31215 AND league_id = 5 AND action = 18
    0.0018  SELECT action,minute FROM events2008 WHERE player_id = 31215 AND league_id = 5 AND action = 19
    0.0020  SELECT e.* FROM `events2007` e WHERE e.player_id = 31215 AND league_id = 83 ORDER BY e.date ASC
    0.0019  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 83 AND rel.player_id=31215
    0.0019  SELECT action,minute FROM events2007 WHERE player_id = 31215 AND league_id = 83 AND action = 18
    0.0018  SELECT action,minute FROM events2007 WHERE player_id = 31215 AND league_id = 83 AND action = 19
    0.0019  SELECT e.* FROM `events2004` e WHERE e.player_id = 31215 AND league_id = 58905 ORDER BY e.date ASC
    0.0121  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 58905 AND rel.player_id=31215
    0.0020  SELECT action,minute FROM events2004 WHERE player_id = 31215 AND league_id = 58905 AND action = 18
    0.0019  SELECT action,minute FROM events2004 WHERE player_id = 31215 AND league_id = 58905 AND action = 19
    0.0019  SELECT e.* FROM `events2003` e WHERE e.player_id = 31215 AND league_id = 59985 ORDER BY e.date ASC
    0.0024  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 59985 AND rel.player_id=31215
    0.0018  SELECT action,minute FROM events2003 WHERE player_id = 31215 AND league_id = 59985 AND action = 18
    0.0018  SELECT action,minute FROM events2003 WHERE player_id = 31215 AND league_id = 59985 AND action = 19
    0.0024   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` = '31215' ORDER BY c.last_update DESC, c.creation_date DESC LIMIT 0,15
    0.0020   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 = '2189933' AND c.lang = '1' ORDER BY creation_date DESC LIMIT 20
    0.0020   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 = '54423' AND c.lang = '1' ORDER BY creation_date DESC LIMIT 20