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

Jesús Vallejo

Jugador del Granada
Liga
  • Competición
  • Partidos jugados
  • Minutos jugados
  • Asistencia
  • Goles marcados
  • Tarjetas amarillas
  • Tarjetas rojas
  • info
Ficha de Jesús Vallejo
Nacionalidad
España
Nombre
Jesús Vallejo Lázaro
Edad
27 Años (05-01-1997)
Altura
184
Dorsal
20
Peso
79 kilogramos
Equipo
Granada
Posición
Defensa
Liga
Primera División 2020
  • Jugador del Granada desde hace 4 años
    • Compañeros de equipo
    Fotos
    16
    • Foto principal de J. Vallejo | Real Madrid
    • Foto principal de J. Vallejo | Granada
    • Foto principal de J. Vallejo | Granada
    • Foto principal de J. Vallejo | Granada
    • Foto principal de J. Vallejo | Wolves
    • Foto principal de J. Vallejo | Wolves
    • Foto principal de J. Vallejo | Real Madrid
    • Foto principal de J. Vallejo | Real Madrid
    • Foto principal de J. Vallejo | Real Madrid
    • Foto principal de J. Vallejo | Real Madrid
    • Foto principal de J. Vallejo | Real Madrid
    • Foto principal de J. Vallejo | España Sub 21
    • Foto principal de J. Vallejo | Eintracht Frankfurt
    • Foto principal de J. Vallejo | España Sub 19
    • Foto principal de Vallejo | Real Zaragoza
    1 Comentarios
    • caiman1999
      Hace 7 años caiman1999 dice: futuro sergio ramos, es un central completisimo el real madrid lo repescara en enero no se sera buena idea es muy joven todabia aunque podria ocupar el puesto de Pepe de aqui nada

      USO DE MEMORIA  
    5,744,392 bytes
      BENCHMARKS  
    Loading Time Base Classes  0.0011
    Controller Execution Time ( Player / Index )  0.1756
    Total Execution Time  0.1767
      CADENA URL  
    /jugador/2020/Vallejo-Lazaro-Jesus-171872
      GET DATOS  
    $_GET['/jugador/2020/Vallejo-Lazaro-Jesus-171872']  
      POST DATOS  
    No hay datos POST existentes
      CONSULTAS (57)  
    0.0005   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` = '171872' AND c.comment_id IN (12988602) GROUP BY c.comment_id
    0.0070  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 = 2020 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 = 'Vallejo-Lazaro-Jesus-171872' ORDER BY rp.year DESC, ct.troncal DESC, rp.in_squad DESC
    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 = 49844
    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 = 50152
    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 = 62228
    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 = 50579
    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 = '171872'
    0.0030  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 = 49844 AND rp.teamId = 4235 AND rp.in_squad=1 ORDER BY p.role>0 DESC, p.role ASC, rp.squadNumber ASC
    0.0024  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 = 171872 ORDER BY rp.year DESC
    0.0023  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 = '171872' 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 = '171872' and rp.type = 3
    0.0020  SELECT e.* FROM `events2020` e WHERE e.player_id = 171872 AND league_id = 49844 ORDER BY e.date ASC
    0.0035  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 49844 AND rel.player_id=171872
    0.0023  SELECT action,minute FROM events2020 WHERE player_id = 171872 AND league_id = 49844 AND action = 18
    0.0023  SELECT action,minute FROM events2020 WHERE player_id = 171872 AND league_id = 49844 AND action = 19
    0.0019  SELECT e.* FROM `events2020` e WHERE e.player_id = 171872 AND league_id = 49845 ORDER BY e.date ASC
    0.0029  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 49845 AND rel.player_id=171872
    0.0019  SELECT action,minute FROM events2020 WHERE player_id = 171872 AND league_id = 49845 AND action = 18
    0.0018  SELECT action,minute FROM events2020 WHERE player_id = 171872 AND league_id = 49845 AND action = 19
    0.0019  SELECT e.* FROM `events2020` e WHERE e.player_id = 171872 AND league_id = 50152 ORDER BY e.date ASC
    0.0032  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 50152 AND rel.player_id=171872
    0.0019  SELECT action,minute FROM events2020 WHERE player_id = 171872 AND league_id = 50152 AND action = 18
    0.0018  SELECT action,minute FROM events2020 WHERE player_id = 171872 AND league_id = 50152 AND action = 19
    0.0022  SELECT e.* FROM `events2020` e WHERE e.player_id = 171872 AND league_id = 51201 ORDER BY e.date ASC
    0.0030  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 51201 AND rel.player_id=171872
    0.0018  SELECT action,minute FROM events2020 WHERE player_id = 171872 AND league_id = 51201 AND action = 18
    0.0022  SELECT action,minute FROM events2020 WHERE player_id = 171872 AND league_id = 51201 AND action = 19
    0.0019  SELECT e.* FROM `events2020` e WHERE e.player_id = 171872 AND league_id = 51355 ORDER BY e.date ASC
    0.0030  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=171872
    0.0018  SELECT action,minute FROM events2020 WHERE player_id = 171872 AND league_id = 51355 AND action = 18
    0.0019  SELECT action,minute FROM events2020 WHERE player_id = 171872 AND league_id = 51355 AND action = 19
    0.0019  SELECT e.* FROM `events2020` e WHERE e.player_id = 171872 AND league_id = 62228 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 = 62228 AND rel.player_id=171872
    0.0019  SELECT action,minute FROM events2020 WHERE player_id = 171872 AND league_id = 62228 AND action = 18
    0.0019  SELECT action,minute FROM events2020 WHERE player_id = 171872 AND league_id = 62228 AND action = 19
    0.0019  SELECT e.* FROM `events2020` e WHERE e.player_id = 171872 AND league_id = 63612 ORDER BY e.date ASC
    0.0028  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 63612 AND rel.player_id=171872
    0.0019  SELECT action,minute FROM events2020 WHERE player_id = 171872 AND league_id = 63612 AND action = 18
    0.0019  SELECT action,minute FROM events2020 WHERE player_id = 171872 AND league_id = 63612 AND action = 19
    0.0045  SELECT e.* FROM `events2020` e WHERE e.player_id = 171872 AND league_id = 49360 ORDER BY e.date ASC
    0.0032  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 49360 AND rel.player_id=171872
    0.0018  SELECT action,minute FROM events2020 WHERE player_id = 171872 AND league_id = 49360 AND action = 18
    0.0018  SELECT action,minute FROM events2020 WHERE player_id = 171872 AND league_id = 49360 AND action = 19
    0.0019  SELECT e.* FROM `events2020` e WHERE e.player_id = 171872 AND league_id = 50579 ORDER BY e.date ASC
    0.0028  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 50579 AND rel.player_id=171872
    0.0018  SELECT action,minute FROM events2020 WHERE player_id = 171872 AND league_id = 50579 AND action = 18
    0.0019  SELECT action,minute FROM events2020 WHERE player_id = 171872 AND league_id = 50579 AND action = 19
    0.0019  SELECT e.* FROM `events2020` e WHERE e.player_id = 171872 AND league_id = 50670 ORDER BY e.date ASC
    0.0027  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 50670 AND rel.player_id=171872
    0.0018  SELECT action,minute FROM events2020 WHERE player_id = 171872 AND league_id = 50670 AND action = 18
    0.0019  SELECT action,minute FROM events2020 WHERE player_id = 171872 AND league_id = 50670 AND action = 19
    0.0022  SELECT e.* FROM `events2020` e WHERE e.player_id = 171872 AND league_id = 51054 ORDER BY e.date ASC
    0.0027  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 51054 AND rel.player_id=171872
    0.0018  SELECT action,minute FROM events2020 WHERE player_id = 171872 AND league_id = 51054 AND action = 18
    0.0018  SELECT action,minute FROM events2020 WHERE player_id = 171872 AND league_id = 51054 AND action = 19
    0.0020   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` = '171872' ORDER BY c.last_update DESC, c.creation_date DESC LIMIT 0,15
    0.0019   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 = '12988602' AND c.lang = '1' ORDER BY creation_date DESC LIMIT 20