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 2021
  • Jugador del Granada desde hace 3 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,619,064 bytes
      BENCHMARKS  
    Loading Time Base Classes  0.0013
    Controller Execution Time ( Player / Index )  0.1574
    Total Execution Time  0.1587
      CADENA URL  
    /jugador/2021/Vallejo-Lazaro-Jesus-171872
      GET DATOS  
    $_GET['/jugador/2021/Vallejo-Lazaro-Jesus-171872']  
      POST DATOS  
    No hay datos POST existentes
      CONSULTAS (51)  
    0.0003   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.0065  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 = 2021 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.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 = 57041
    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 = 58599
    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 = 59215
    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 = 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 = 60338
    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 = 61914
    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.0035  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 = 4235 AND rp.in_squad=1 ORDER BY p.role>0 DESC, p.role ASC, rp.squadNumber ASC
    0.0025  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.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 = '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 `events2021` e WHERE e.player_id = 171872 AND league_id = 57041 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 = 57041 AND rel.player_id=171872
    0.0026  SELECT action,minute FROM events2021 WHERE player_id = 171872 AND league_id = 57041 AND action = 18
    0.0023  SELECT action,minute FROM events2021 WHERE player_id = 171872 AND league_id = 57041 AND action = 19
    0.0018  SELECT e.* FROM `events2021` e WHERE e.player_id = 171872 AND league_id = 56547 ORDER BY e.date ASC
    0.0037  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=171872
    0.0018  SELECT action,minute FROM events2021 WHERE player_id = 171872 AND league_id = 56547 AND action = 18
    0.0018  SELECT action,minute FROM events2021 WHERE player_id = 171872 AND league_id = 56547 AND action = 19
    0.0018  SELECT e.* FROM `events2021` e WHERE e.player_id = 171872 AND league_id = 58599 ORDER BY e.date ASC
    0.0036  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 58599 AND rel.player_id=171872
    0.0018  SELECT action,minute FROM events2021 WHERE player_id = 171872 AND league_id = 58599 AND action = 18
    0.0018  SELECT action,minute FROM events2021 WHERE player_id = 171872 AND league_id = 58599 AND action = 19
    0.0018  SELECT e.* FROM `events2021` e WHERE e.player_id = 171872 AND league_id = 58621 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 = 58621 AND rel.player_id=171872
    0.0018  SELECT action,minute FROM events2021 WHERE player_id = 171872 AND league_id = 58621 AND action = 18
    0.0018  SELECT action,minute FROM events2021 WHERE player_id = 171872 AND league_id = 58621 AND action = 19
    0.0018  SELECT e.* FROM `events2021` e WHERE e.player_id = 171872 AND league_id = 58772 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 = 58772 AND rel.player_id=171872
    0.0018  SELECT action,minute FROM events2021 WHERE player_id = 171872 AND league_id = 58772 AND action = 18
    0.0018  SELECT action,minute FROM events2021 WHERE player_id = 171872 AND league_id = 58772 AND action = 19
    0.0019  SELECT e.* FROM `events2021` e WHERE e.player_id = 171872 AND league_id = 59215 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 = 59215 AND rel.player_id=171872
    0.0018  SELECT action,minute FROM events2021 WHERE player_id = 171872 AND league_id = 59215 AND action = 18
    0.0018  SELECT action,minute FROM events2021 WHERE player_id = 171872 AND league_id = 59215 AND action = 19
    0.0019  SELECT e.* FROM `events2021` e WHERE e.player_id = 171872 AND league_id = 59872 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 = 59872 AND rel.player_id=171872
    0.0020  SELECT action,minute FROM events2021 WHERE player_id = 171872 AND league_id = 59872 AND action = 18
    0.0020  SELECT action,minute FROM events2021 WHERE player_id = 171872 AND league_id = 59872 AND action = 19
    0.0019  SELECT e.* FROM `events2021` e WHERE e.player_id = 171872 AND league_id = 60338 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 = 60338 AND rel.player_id=171872
    0.0020  SELECT action,minute FROM events2021 WHERE player_id = 171872 AND league_id = 60338 AND action = 18
    0.0021  SELECT action,minute FROM events2021 WHERE player_id = 171872 AND league_id = 60338 AND action = 19
    0.0021  SELECT e.* FROM `events2021` e WHERE e.player_id = 171872 AND league_id = 61914 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 = 61914 AND rel.player_id=171872
    0.0019  SELECT action,minute FROM events2021 WHERE player_id = 171872 AND league_id = 61914 AND action = 18
    0.0019  SELECT action,minute FROM events2021 WHERE player_id = 171872 AND league_id = 61914 AND action = 19
    0.0022   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.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 = '12988602' AND c.lang = '1' ORDER BY creation_date DESC LIMIT 20