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

N. Lodeiro

Jugador del Seattle Sounders
Liga
  • Competición
  • Partidos jugados
  • Minutos jugados
  • Asistencia
  • Goles marcados
  • Tarjetas amarillas
  • Tarjetas rojas
  • info
Ficha de N. Lodeiro
Nacionalidad
Uruguay
Nombre
Marcelo Nicolás Lodeiro Benítez
Edad
35 Años (21-03-1989)
Altura
173
Dorsal
10
Peso
69 kilogramos
Equipo
Seattle Sounders
Posición
Centrocampista
Liga
MLS - Liga USA 2019
  • Jugador del Seattle Sounders desde hace 5 años
    • Compañeros de equipo
    Fotos
    15
    • Foto principal de N. Lodeiro | Seattle Sounders
    • Foto principal de N. Lodeiro | Seattle Sounders
    • Foto principal de N. Lodeiro | Seattle Sounders
    • Foto principal de N. Lodeiro | Seattle Sounders
    • Foto principal de N. Lodeiro | Seattle Sounders
    • Foto principal de N. Lodeiro | Uruguay
    • Foto principal de N. Lodeiro | Uruguay
    • Foto principal de N. Lodeiro | Boca Juniors
    • Foto principal de N. Lodeiro | Boca Juniors
    • Foto principal de M. Lodeiro | Uruguay
    • N. Lodeiro
    • N. Lodeiro
    • N. Lodeiro
    • Nicolas Lodeiro
    • N. Lodeiro
    2 Comentarios
    • Hace 12 años xxmurciaxx dice: es bueno !es bueno !
    • teko
      Hace 13 años teko dice: nico sos mi idolo de cuando jugavas en nacional nico sos mi idolo de cuando jugavas en nacional

      USO DE MEMORIA  
    5,718,680 bytes
      BENCHMARKS  
    Loading Time Base Classes  0.0013
    Controller Execution Time ( Player / Index )  0.8838
    Total Execution Time  0.8851
      CADENA URL  
    /jugador/2019/M-Lodeiro-61852
      GET DATOS  
    $_GET['/jugador/2019/M-Lodeiro-61852']  
      POST DATOS  
    No hay datos POST existentes
      CONSULTAS (49)  
    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` = '61852' AND c.comment_id IN (1258168,744690) GROUP BY c.comment_id
    0.0335  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 = 2019 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 = 'M-Lodeiro-61852' ORDER BY rp.year DESC, ct.troncal DESC, rp.in_squad DESC
    0.0458  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 = 51547
    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 = 48774
    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 = 49164
    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 = 71969
    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 = '61852'
    0.0152  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 = 61852 ORDER BY rp.year DESC
    0.0148  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 = '61852' and rp.type = 3 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
    0.0145  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '61852' and rp.type = 3
    0.0146  SELECT e.* FROM `events2019` e WHERE e.player_id = 61852 AND league_id = 48587 ORDER BY e.date ASC
    0.0192  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 48587 AND rel.player_id=61852
    0.0149  SELECT action,minute FROM events2019 WHERE player_id = 61852 AND league_id = 48587 AND action = 18
    0.0149  SELECT action,minute FROM events2019 WHERE player_id = 61852 AND league_id = 48587 AND action = 19
    0.0146  SELECT e.* FROM `events2019` e WHERE e.player_id = 61852 AND league_id = 51547 ORDER BY e.date ASC
    0.0157  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 51547 AND rel.player_id=61852
    0.0146  SELECT action,minute FROM events2019 WHERE player_id = 61852 AND league_id = 51547 AND action = 18
    0.0145  SELECT action,minute FROM events2019 WHERE player_id = 61852 AND league_id = 51547 AND action = 19
    0.0145  SELECT e.* FROM `events2019` e WHERE e.player_id = 61852 AND league_id = 43333 ORDER BY e.date ASC
    0.0193  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 43333 AND rel.player_id=61852
    0.0145  SELECT action,minute FROM events2019 WHERE player_id = 61852 AND league_id = 43333 AND action = 18
    0.0145  SELECT action,minute FROM events2019 WHERE player_id = 61852 AND league_id = 43333 AND action = 19
    0.0145  SELECT e.* FROM `events2019` e WHERE e.player_id = 61852 AND league_id = 43475 ORDER BY e.date ASC
    0.0191  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=61852
    0.0145  SELECT action,minute FROM events2019 WHERE player_id = 61852 AND league_id = 43475 AND action = 18
    0.0145  SELECT action,minute FROM events2019 WHERE player_id = 61852 AND league_id = 43475 AND action = 19
    0.0145  SELECT e.* FROM `events2019` e WHERE e.player_id = 61852 AND league_id = 48774 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 = 48774 AND rel.player_id=61852
    0.0145  SELECT action,minute FROM events2019 WHERE player_id = 61852 AND league_id = 48774 AND action = 18
    0.0145  SELECT action,minute FROM events2019 WHERE player_id = 61852 AND league_id = 48774 AND action = 19
    0.0145  SELECT e.* FROM `events2019` e WHERE e.player_id = 61852 AND league_id = 49164 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 = 49164 AND rel.player_id=61852
    0.0145  SELECT action,minute FROM events2019 WHERE player_id = 61852 AND league_id = 49164 AND action = 18
    0.0145  SELECT action,minute FROM events2019 WHERE player_id = 61852 AND league_id = 49164 AND action = 19
    0.0145  SELECT e.* FROM `events2019` e WHERE e.player_id = 61852 AND league_id = 49490 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 = 49490 AND rel.player_id=61852
    0.0145  SELECT action,minute FROM events2019 WHERE player_id = 61852 AND league_id = 49490 AND action = 18
    0.0145  SELECT action,minute FROM events2019 WHERE player_id = 61852 AND league_id = 49490 AND action = 19
    0.0145  SELECT e.* FROM `events2019` e WHERE e.player_id = 61852 AND league_id = 50155 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 = 50155 AND rel.player_id=61852
    0.0145  SELECT action,minute FROM events2019 WHERE player_id = 61852 AND league_id = 50155 AND action = 18
    0.0145  SELECT action,minute FROM events2019 WHERE player_id = 61852 AND league_id = 50155 AND action = 19
    0.0145  SELECT e.* FROM `events2019` e WHERE e.player_id = 61852 AND league_id = 71969 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 = 71969 AND rel.player_id=61852
    0.0145  SELECT action,minute FROM events2019 WHERE player_id = 61852 AND league_id = 71969 AND action = 18
    0.0145  SELECT action,minute FROM events2019 WHERE player_id = 61852 AND league_id = 71969 AND action = 19
    0.0147   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` = '61852' ORDER BY c.last_update DESC, c.creation_date DESC LIMIT 0,15
    0.0145   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 = '1258168' AND c.lang = '1' ORDER BY creation_date DESC LIMIT 20
    0.0145   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 = '744690' AND c.lang = '1' ORDER BY creation_date DESC LIMIT 20