4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Imagen de UD Logroñés

David Fernández

Jugador del UD Logroñés
Liga
  • Competición
  • Partidos jugados
  • Minutos jugados
  • Asistencia
  • Goles marcados
  • Tarjetas amarillas
  • Tarjetas rojas
  • info
Ficha de David Fernández
Nacionalidad
España
Nombre
David Fernández Cortázar
Edad
39 Años (06-04-1985)
Altura
186
Dorsal
19
Peso
81 kilogramos
Equipo
UD Logroñés
Posición
Defensa
Liga
Primera Federación 2023 G 2
Compañeros de equipo
Fotos
13
  • Foto principal de David Fernández | Alcorcón
  • Foto principal de David Fernández | Alcorcón
  • Foto principal de David Fernández | Alcorcón
  • Foto principal de David Fernández | Alcorcón
  • Foto principal de David Fernández | Real Oviedo
  • Foto principal de David Fernández | Real Oviedo
  • Foto principal de David Fernández | Real Oviedo
  • David Fernández
  • David Fernández
  • David Fernández
  • David Fernández
  • David Fernández
  • DAVID FERNANDEZ
6 Comentarios
  • Colton
    Hace 8 años Colton dice: ¡Daaaavid Feeernáaaandeeeeeeez! ¡Lolololooolooooo!
  • somiedo
    Hace 10 años somiedo dice: Muy irregular e inseguro. Puede cambiar
  • joseherranzl
    Hace 11 años joseherranzl dice: jugador polivalente jugo en todos los puestos de la defensa y medio centro regular y buenos años en guada
  • philip28
    Hace 12 años philip28 dice: Gran central y polivalente,tambien puede hacerlo de lateral,gran concepto del juego y de la colocacíon siempre esta en su sitio para ir al corte,poderoso en el salto va muy bien por alto,tiene calidad para salir con el balon jugado,siempre elige la opcion mas correcta del juego a la hora de recuperar el balon.En definitiva un gran jugador con calidad para jugar con solvencia en primera y segunda dGran central y polivalente,tambien puede hacerlo de lateral,gran concepto del juego y de la colocacíon siempre esta en su sitio para ir al corte,poderoso en el salto va muy bien por alto,tiene calidad para salir con el balon jugado,siempre elige la opcion mas correcta del juego a la hora de recuperar el balon.En definitiva un gran jugador con calidad para jugar con solvencia en primera y segunda d
  • chupcerrista
    Hace 14 años chupcerrista dice: rnada 1: SENIOR Villanovense 0 - Guadalajara 2 No 11 0 0 0 Jornada 2: SENIOR Guadalajara 2 - Real Oviedo 0 No 14 0 0 0 Jornada 4: SENIOR Guadalajara 3 - Univ. Las Palmas 1 Si 90 0 0 0 Jornada 5: SENIOR Toledo 1 - Guadalajara 2 Si 90 0 0 0 Jornada 6: SENIOR Guadalajara 0 - Vecindario 1 Si 90 0 0 0 Jornada 7: SENIOR Guadalajarrnada 1: SENIOR Villanovense 0 - Guadalajara 2 No 11 0 0 0 Jornada 2: SENIOR Guadalajara 2 - Real Oviedo 0 No 14 0 0 0 Jornada 4: SENIOR Guadalajara 3 - Univ. Las Palmas 1 Si 90 0 0 0 Jornada 5: SENIOR Toledo 1 - Guadalajara 2 Si 90 0 0 0 Jornada 6: SENIOR Guadalajara 0 - Vecindario 1 Si 90 0 0 0 Jornada 7: SENIOR Guadalajar
  • chupcerrista
    Hace 14 años chupcerrista dice: # AÑOS EN EL CLUB: 1 # EQUIPO DE PROCEDENCIA: Linares # TRAYECTORIA COMO SENIOR: Rayo Vallecano juvenil; Rayo Vallecano B (3º); Atlético Madrid B (2ºB); CD Linares (2ºB); Guadalajara (2ºB)# AÑOS EN EL CLUB: 1 # EQUIPO DE PROCEDENCIA: Linares # TRAYECTORIA COMO SENIOR: Rayo Vallecano juvenil; Rayo Vallecano B (3º); Atlético Madrid B (2ºB); CD Linares (2ºB); Guadalajara (2ºB)

  USO DE MEMORIA  
10,523,392 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Player / Index )  4.9064
Total Execution Time  4.9076
  CADENA URL  
/jugador/david-fernandez-34171
  GET DATOS  
$_GET['/jugador/david-fernandez-34171']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (225)  
0.0019   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` = '34171' AND c.comment_id IN (6046388,2265873,1887406,1087022,78198,78197) GROUP BY c.comment_id
0.0152  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 = 'david-fernandez-34171' ORDER BY rp.year DESC, ct.troncal DESC, rp.in_squad DESC
0.0528  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 = 'david-fernandez-34171' ORDER BY rp.year DESC, ct.troncal DESC, rp.in_squad DESC
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 = 67960
0.0149  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 = 69563
0.0149  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 = 57314
0.0149  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 = 43686
0.0149  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.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 = 73044
0.0149  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 = 33377
0.0149  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.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 = 15374
0.0149  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 = 3865
0.0149  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.0149  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.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 = 3804
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 = 2466
0.0149  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 = 2735
0.0149  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 = 1902
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 = 2339
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 = 1335
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 = 1101
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 = 1115
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 = 1307
0.0149  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 = 827
0.0149  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 = 999
0.0149  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.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 = 2
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 = 4
0.0144  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 = '34171'
0.0164  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 = 67960 AND rp.teamId = 1578 AND rp.in_squad=1 ORDER BY p.role>0 DESC, p.role ASC, rp.squadNumber ASC
0.0150  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 = 34171 ORDER BY rp.year DESC
0.0154  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 = '34171' and rp.type = 3 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0144  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '34171' and rp.type = 3
0.0146  SELECT e.* FROM `events2023` e WHERE e.player_id = 34171 AND league_id = 67960 ORDER BY e.date ASC
0.0179  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 67960 AND rel.player_id=34171
0.0151  SELECT action,minute FROM events2023 WHERE player_id = 34171 AND league_id = 67960 AND action = 18
0.0150  SELECT action,minute FROM events2023 WHERE player_id = 34171 AND league_id = 67960 AND action = 19
0.0145  SELECT e.* FROM `events2023` e WHERE e.player_id = 34171 AND league_id = 69563 ORDER BY e.date ASC
0.0167  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 69563 AND rel.player_id=34171
0.0146  SELECT action,minute FROM events2023 WHERE player_id = 34171 AND league_id = 69563 AND action = 18
0.0145  SELECT action,minute FROM events2023 WHERE player_id = 34171 AND league_id = 69563 AND action = 19
0.0146  SELECT e.* FROM `events2022` e WHERE e.player_id = 34171 AND league_id = 62832 ORDER BY e.date ASC
0.0168  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 62832 AND rel.player_id=34171
0.0151  SELECT action,minute FROM events2022 WHERE player_id = 34171 AND league_id = 62832 AND action = 18
0.0151  SELECT action,minute FROM events2022 WHERE player_id = 34171 AND league_id = 62832 AND action = 19
0.0145  SELECT e.* FROM `events2022` e WHERE e.player_id = 34171 AND league_id = 62807 ORDER BY e.date ASC
0.0169  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=34171
0.0146  SELECT action,minute FROM events2022 WHERE player_id = 34171 AND league_id = 62807 AND action = 18
0.0145  SELECT action,minute FROM events2022 WHERE player_id = 34171 AND league_id = 62807 AND action = 19
0.0145  SELECT e.* FROM `events2022` e WHERE e.player_id = 34171 AND league_id = 65506 ORDER BY e.date ASC
0.0168  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 65506 AND rel.player_id=34171
0.0144  SELECT action,minute FROM events2022 WHERE player_id = 34171 AND league_id = 65506 AND action = 18
0.0144  SELECT action,minute FROM events2022 WHERE player_id = 34171 AND league_id = 65506 AND action = 19
0.0145  SELECT e.* FROM `events2021` e WHERE e.player_id = 34171 AND league_id = 57314 ORDER BY e.date ASC
0.0173  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 57314 AND rel.player_id=34171
0.0146  SELECT action,minute FROM events2021 WHERE player_id = 34171 AND league_id = 57314 AND action = 18
0.0145  SELECT action,minute FROM events2021 WHERE player_id = 34171 AND league_id = 57314 AND action = 19
0.0145  SELECT e.* FROM `events2021` e WHERE e.player_id = 34171 AND league_id = 56547 ORDER BY e.date ASC
0.0173  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=34171
0.0145  SELECT action,minute FROM events2021 WHERE player_id = 34171 AND league_id = 56547 AND action = 18
0.0145  SELECT action,minute FROM events2021 WHERE player_id = 34171 AND league_id = 56547 AND action = 19
0.0145  SELECT e.* FROM `events2021` e WHERE e.player_id = 34171 AND league_id = 59872 ORDER BY e.date ASC
0.0163  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=34171
0.0144  SELECT action,minute FROM events2021 WHERE player_id = 34171 AND league_id = 59872 AND action = 18
0.0144  SELECT action,minute FROM events2021 WHERE player_id = 34171 AND league_id = 59872 AND action = 19
0.0145  SELECT e.* FROM `events2020` e WHERE e.player_id = 34171 AND league_id = 50064 ORDER BY e.date ASC
0.0173  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=34171
0.0145  SELECT action,minute FROM events2020 WHERE player_id = 34171 AND league_id = 50064 AND action = 18
0.0145  SELECT action,minute FROM events2020 WHERE player_id = 34171 AND league_id = 50064 AND action = 19
0.0145  SELECT e.* FROM `events2020` e WHERE e.player_id = 34171 AND league_id = 49506 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 = 49506 AND rel.player_id=34171
0.0145  SELECT action,minute FROM events2020 WHERE player_id = 34171 AND league_id = 49506 AND action = 18
0.0144  SELECT action,minute FROM events2020 WHERE player_id = 34171 AND league_id = 49506 AND action = 19
0.0145  SELECT e.* FROM `events2020` e WHERE e.player_id = 34171 AND league_id = 51355 ORDER BY e.date ASC
0.0155  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=34171
0.0144  SELECT action,minute FROM events2020 WHERE player_id = 34171 AND league_id = 51355 AND action = 18
0.0144  SELECT action,minute FROM events2020 WHERE player_id = 34171 AND league_id = 51355 AND action = 19
0.0145  SELECT e.* FROM `events2019` e WHERE e.player_id = 34171 AND league_id = 43686 ORDER BY e.date ASC
0.0173  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 43686 AND rel.player_id=34171
0.0153  SELECT action,minute FROM events2019 WHERE player_id = 34171 AND league_id = 43686 AND action = 18
0.0153  SELECT action,minute FROM events2019 WHERE player_id = 34171 AND league_id = 43686 AND action = 19
0.0145  SELECT e.* FROM `events2019` e WHERE e.player_id = 34171 AND league_id = 43475 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 = 43475 AND rel.player_id=34171
0.0146  SELECT action,minute FROM events2019 WHERE player_id = 34171 AND league_id = 43475 AND action = 18
0.0145  SELECT action,minute FROM events2019 WHERE player_id = 34171 AND league_id = 43475 AND action = 19
0.0145  SELECT e.* FROM `events2019` e WHERE e.player_id = 34171 AND league_id = 44594 ORDER BY e.date ASC
0.0164  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=34171
0.0145  SELECT action,minute FROM events2019 WHERE player_id = 34171 AND league_id = 44594 AND action = 18
0.0145  SELECT action,minute FROM events2019 WHERE player_id = 34171 AND league_id = 44594 AND action = 19
0.0145  SELECT e.* FROM `events2019` e WHERE e.player_id = 34171 AND league_id = 73044 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 = 73044 AND rel.player_id=34171
0.0144  SELECT action,minute FROM events2019 WHERE player_id = 34171 AND league_id = 73044 AND action = 18
0.0144  SELECT action,minute FROM events2019 WHERE player_id = 34171 AND league_id = 73044 AND action = 19
0.0145  SELECT e.* FROM `events2018` e WHERE e.player_id = 34171 AND league_id = 38790 ORDER BY e.date ASC
0.0174  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 38790 AND rel.player_id=34171
0.0153  SELECT action,minute FROM events2018 WHERE player_id = 34171 AND league_id = 38790 AND action = 18
0.0153  SELECT action,minute FROM events2018 WHERE player_id = 34171 AND league_id = 38790 AND action = 19
0.0145  SELECT e.* FROM `events2018` e WHERE e.player_id = 34171 AND league_id = 38427 ORDER BY e.date ASC
0.0173  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=34171
0.0144  SELECT action,minute FROM events2018 WHERE player_id = 34171 AND league_id = 38427 AND action = 18
0.0145  SELECT action,minute FROM events2018 WHERE player_id = 34171 AND league_id = 38427 AND action = 19
0.0145  SELECT e.* FROM `events2018` e WHERE e.player_id = 34171 AND league_id = 39175 ORDER BY e.date ASC
0.0169  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=34171
0.0145  SELECT action,minute FROM events2018 WHERE player_id = 34171 AND league_id = 39175 AND action = 18
0.0144  SELECT action,minute FROM events2018 WHERE player_id = 34171 AND league_id = 39175 AND action = 19
0.0147  SELECT e.* FROM `events2017` e WHERE e.player_id = 34171 AND league_id = 33377 ORDER BY e.date ASC
0.0170  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=34171
0.0153  SELECT action,minute FROM events2017 WHERE player_id = 34171 AND league_id = 33377 AND action = 18
0.0153  SELECT action,minute FROM events2017 WHERE player_id = 34171 AND league_id = 33377 AND action = 19
0.0145  SELECT e.* FROM `events2017` e WHERE e.player_id = 34171 AND league_id = 30386 ORDER BY e.date ASC
0.0175  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=34171
0.0145  SELECT action,minute FROM events2017 WHERE player_id = 34171 AND league_id = 30386 AND action = 18
0.0145  SELECT action,minute FROM events2017 WHERE player_id = 34171 AND league_id = 30386 AND action = 19
0.0145  SELECT e.* FROM `events2017` e WHERE e.player_id = 34171 AND league_id = 33904 ORDER BY e.date ASC
0.0164  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=34171
0.0145  SELECT action,minute FROM events2017 WHERE player_id = 34171 AND league_id = 33904 AND action = 18
0.0144  SELECT action,minute FROM events2017 WHERE player_id = 34171 AND league_id = 33904 AND action = 19
0.0146  SELECT e.* FROM `events2016` e WHERE e.player_id = 34171 AND league_id = 15374 ORDER BY e.date ASC
0.0177  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 15374 AND rel.player_id=34171
0.0145  SELECT action,minute FROM events2016 WHERE player_id = 34171 AND league_id = 15374 AND action = 18
0.0145  SELECT action,minute FROM events2016 WHERE player_id = 34171 AND league_id = 15374 AND action = 19
0.0145  SELECT e.* FROM `events2016` e WHERE e.player_id = 34171 AND league_id = 16245 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 = 16245 AND rel.player_id=34171
0.0145  SELECT action,minute FROM events2016 WHERE player_id = 34171 AND league_id = 16245 AND action = 18
0.0145  SELECT action,minute FROM events2016 WHERE player_id = 34171 AND league_id = 16245 AND action = 19
0.0145  SELECT e.* FROM `events2016` e WHERE e.player_id = 34171 AND league_id = 16597 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 = 16597 AND rel.player_id=34171
0.0146  SELECT action,minute FROM events2016 WHERE player_id = 34171 AND league_id = 16597 AND action = 18
0.0145  SELECT action,minute FROM events2016 WHERE player_id = 34171 AND league_id = 16597 AND action = 19
0.0146  SELECT e.* FROM `events2015` e WHERE e.player_id = 34171 AND league_id = 3865 ORDER BY e.date ASC
0.0169  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 3865 AND rel.player_id=34171
0.0145  SELECT action,minute FROM events2015 WHERE player_id = 34171 AND league_id = 3865 AND action = 18
0.0145  SELECT action,minute FROM events2015 WHERE player_id = 34171 AND league_id = 3865 AND action = 19
0.0145  SELECT e.* FROM `events2015` e WHERE e.player_id = 34171 AND league_id = 3992 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 = 3992 AND rel.player_id=34171
0.0145  SELECT action,minute FROM events2015 WHERE player_id = 34171 AND league_id = 3992 AND action = 18
0.0145  SELECT action,minute FROM events2015 WHERE player_id = 34171 AND league_id = 3992 AND action = 19
0.0145  SELECT e.* FROM `events2015` e WHERE e.player_id = 34171 AND league_id = 14186 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 = 14186 AND rel.player_id=34171
0.0145  SELECT action,minute FROM events2015 WHERE player_id = 34171 AND league_id = 14186 AND action = 18
0.0145  SELECT action,minute FROM events2015 WHERE player_id = 34171 AND league_id = 14186 AND action = 19
0.0145  SELECT e.* FROM `events2015` e WHERE e.player_id = 34171 AND league_id = 3804 ORDER BY e.date ASC
0.0146  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=34171
0.0145  SELECT action,minute FROM events2015 WHERE player_id = 34171 AND league_id = 3804 AND action = 18
0.0145  SELECT action,minute FROM events2015 WHERE player_id = 34171 AND league_id = 3804 AND action = 19
0.0145  SELECT e.* FROM `events2014` e WHERE e.player_id = 34171 AND league_id = 2466 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 = 2466 AND rel.player_id=34171
0.0146  SELECT action,minute FROM events2014 WHERE player_id = 34171 AND league_id = 2466 AND action = 18
0.0146  SELECT action,minute FROM events2014 WHERE player_id = 34171 AND league_id = 2466 AND action = 19
0.0146  SELECT e.* FROM `events2014` e WHERE e.player_id = 34171 AND league_id = 2399 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 = 2399 AND rel.player_id=34171
0.0145  SELECT action,minute FROM events2014 WHERE player_id = 34171 AND league_id = 2399 AND action = 18
0.0145  SELECT action,minute FROM events2014 WHERE player_id = 34171 AND league_id = 2399 AND action = 19
0.0145  SELECT e.* FROM `events2014` e WHERE e.player_id = 34171 AND league_id = 2735 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 = 2735 AND rel.player_id=34171
0.0145  SELECT action,minute FROM events2014 WHERE player_id = 34171 AND league_id = 2735 AND action = 18
0.0145  SELECT action,minute FROM events2014 WHERE player_id = 34171 AND league_id = 2735 AND action = 19
0.0146  SELECT e.* FROM `events2013` e WHERE e.player_id = 34171 AND league_id = 1902 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 = 1902 AND rel.player_id=34171
0.0145  SELECT action,minute FROM events2013 WHERE player_id = 34171 AND league_id = 1902 AND action = 18
0.0146  SELECT action,minute FROM events2013 WHERE player_id = 34171 AND league_id = 1902 AND action = 19
0.0145  SELECT e.* FROM `events2013` e WHERE e.player_id = 34171 AND league_id = 1969 ORDER BY e.date ASC
0.0154  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=34171
0.0144  SELECT action,minute FROM events2013 WHERE player_id = 34171 AND league_id = 1969 AND action = 18
0.0144  SELECT action,minute FROM events2013 WHERE player_id = 34171 AND league_id = 1969 AND action = 19
0.0144  SELECT e.* FROM `events2013` e WHERE e.player_id = 34171 AND league_id = 2339 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 = 2339 AND rel.player_id=34171
0.0144  SELECT action,minute FROM events2013 WHERE player_id = 34171 AND league_id = 2339 AND action = 18
0.0144  SELECT action,minute FROM events2013 WHERE player_id = 34171 AND league_id = 2339 AND action = 19
0.0146  SELECT e.* FROM `events2012` e WHERE e.player_id = 34171 AND league_id = 1335 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 = 1335 AND rel.player_id=34171
0.0145  SELECT action,minute FROM events2012 WHERE player_id = 34171 AND league_id = 1335 AND action = 18
0.0145  SELECT action,minute FROM events2012 WHERE player_id = 34171 AND league_id = 1335 AND action = 19
0.0145  SELECT e.* FROM `events2012` e WHERE e.player_id = 34171 AND league_id = 1437 ORDER BY e.date ASC
0.0154  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=34171
0.0144  SELECT action,minute FROM events2012 WHERE player_id = 34171 AND league_id = 1437 AND action = 18
0.0145  SELECT action,minute FROM events2012 WHERE player_id = 34171 AND league_id = 1437 AND action = 19
0.0146  SELECT e.* FROM `events2011` e WHERE e.player_id = 34171 AND league_id = 1101 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 = 1101 AND rel.player_id=34171
0.0145  SELECT action,minute FROM events2011 WHERE player_id = 34171 AND league_id = 1101 AND action = 18
0.0145  SELECT action,minute FROM events2011 WHERE player_id = 34171 AND league_id = 1101 AND action = 19
0.0146  SELECT e.* FROM `events2011` e WHERE e.player_id = 34171 AND league_id = 1115 ORDER BY e.date ASC
0.0154  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=34171
0.0144  SELECT action,minute FROM events2011 WHERE player_id = 34171 AND league_id = 1115 AND action = 18
0.0145  SELECT action,minute FROM events2011 WHERE player_id = 34171 AND league_id = 1115 AND action = 19
0.0145  SELECT e.* FROM `events2011` e WHERE e.player_id = 34171 AND league_id = 1307 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 = 1307 AND rel.player_id=34171
0.0144  SELECT action,minute FROM events2011 WHERE player_id = 34171 AND league_id = 1307 AND action = 18
0.0145  SELECT action,minute FROM events2011 WHERE player_id = 34171 AND league_id = 1307 AND action = 19
0.0146  SELECT e.* FROM `events2010` e WHERE e.player_id = 34171 AND league_id = 827 ORDER BY e.date ASC
0.0144  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 827 AND rel.player_id=34171
0.0146  SELECT action,minute FROM events2010 WHERE player_id = 34171 AND league_id = 827 AND action = 18
0.0145  SELECT action,minute FROM events2010 WHERE player_id = 34171 AND league_id = 827 AND action = 19
0.0146  SELECT e.* FROM `events2010` e WHERE e.player_id = 34171 AND league_id = 999 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 = 999 AND rel.player_id=34171
0.0144  SELECT action,minute FROM events2010 WHERE player_id = 34171 AND league_id = 999 AND action = 18
0.0144  SELECT action,minute FROM events2010 WHERE player_id = 34171 AND league_id = 999 AND action = 19
0.0145  SELECT e.* FROM `events2009` e WHERE e.player_id = 34171 AND league_id = 130 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 = 130 AND rel.player_id=34171
0.0144  SELECT action,minute FROM events2009 WHERE player_id = 34171 AND league_id = 130 AND action = 18
0.0144  SELECT action,minute FROM events2009 WHERE player_id = 34171 AND league_id = 130 AND action = 19
0.0144  SELECT e.* FROM `events2009` e WHERE e.player_id = 34171 AND league_id = 805 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 = 805 AND rel.player_id=34171
0.0145  SELECT action,minute FROM events2009 WHERE player_id = 34171 AND league_id = 805 AND action = 18
0.0144  SELECT action,minute FROM events2009 WHERE player_id = 34171 AND league_id = 805 AND action = 19
0.0145  SELECT e.* FROM `events2008` e WHERE e.player_id = 34171 AND league_id = 2 ORDER BY e.date ASC
0.0180  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=34171
0.0144  SELECT action,minute FROM events2008 WHERE player_id = 34171 AND league_id = 2 AND action = 18
0.0144  SELECT action,minute FROM events2008 WHERE player_id = 34171 AND league_id = 2 AND action = 19
0.0145  SELECT e.* FROM `events2008` e WHERE e.player_id = 34171 AND league_id = 4 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 = 4 AND rel.player_id=34171
0.0145  SELECT action,minute FROM events2008 WHERE player_id = 34171 AND league_id = 4 AND action = 18
0.0144  SELECT action,minute FROM events2008 WHERE player_id = 34171 AND league_id = 4 AND action = 19
0.0145  SELECT e.* FROM `events2007` e WHERE e.player_id = 34171 AND league_id = 82 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 = 82 AND rel.player_id=34171
0.0144  SELECT action,minute FROM events2007 WHERE player_id = 34171 AND league_id = 82 AND action = 18
0.0144  SELECT action,minute FROM events2007 WHERE player_id = 34171 AND league_id = 82 AND action = 19
1.3304   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` = '34171' ORDER BY c.last_update DESC, c.creation_date DESC LIMIT 0,15
0.0291   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 = '6046388' AND c.lang = '1' ORDER BY creation_date DESC LIMIT 20
0.0153   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 = '2265873' AND c.lang = '1' ORDER BY creation_date DESC LIMIT 20
0.0147   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 = '1887406' AND c.lang = '1' ORDER BY creation_date DESC LIMIT 20
0.0147   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 = '1087022' AND c.lang = '1' ORDER BY creation_date DESC LIMIT 20
0.0164   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 = '78198' AND c.lang = '1' ORDER BY creation_date DESC LIMIT 20
0.0159   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 = '78197' AND c.lang = '1' ORDER BY creation_date DESC LIMIT 20