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

L. Rodríguez

Jugador del Colón
Liga
  • Competición
  • Partidos jugados
  • Minutos jugados
  • Asistencia
  • Goles marcados
  • Tarjetas amarillas
  • Tarjetas rojas
  • info
Ficha de L. Rodríguez
Nacionalidad
Argentina
Nombre
Luis Miguel Rodríguez
Edad
34 Años
Altura
167
Dorsal
10
Peso
65 kilogramos
Equipo
Colón
Posición
Centrocampista
Liga
Liga Profesional Argentina 2020
Compañeros de equipo
Fotos
8
  • Foto principal de L. Rodríguez | Gimnasia La Plata
  • Foto principal de L. Rodríguez | Gimnasia La Plata
  • Foto principal de L. Rodríguez | Colón
  • Foto principal de L. Rodríguez | Atl.Tucumán
  • Foto principal de L. Rodríguez | Atl.Tucumán
  • L. Rodríguez
  • L. Rodríguez
  • L. Rodriguez
0 Comentarios

No hay comentarios


  USO DE MEMORIA  
4,869,864 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0017
Controller Execution Time ( Player / Index )  0.1080
Total Execution Time  0.1097
  CADENA URL  
/jugador/2020/L-Rodriguez-71790
  GET DATOS  
$_GET['/jugador/2020/L-Rodriguez-71790']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (23)  
0.0005   SELECT 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` = '71790'
0.0124  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 = 'L-Rodriguez-71790' ORDER BY rp.year DESC, ct.troncal DESC, rp.in_squad DESC
0.0020  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 = '71790'
0.0048  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 = 49952 AND rp.teamId = 815 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 = 71790 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 = '71790' 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 = '71790' and rp.type = 3
0.0020  SELECT e.* FROM `events2020` e WHERE e.player_id = 71790 AND league_id = 49952 ORDER BY e.date ASC
0.0061  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 49952 AND rel.player_id=71790
0.0026  SELECT action,minute FROM events2020 WHERE player_id = 71790 AND league_id = 49952 AND action = 18
0.0025  SELECT action,minute FROM events2020 WHERE player_id = 71790 AND league_id = 49952 AND action = 19
0.0019  SELECT e.* FROM `events2020` e WHERE e.player_id = 71790 AND league_id = 49506 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 = 49506 AND rel.player_id=71790
0.0020  SELECT action,minute FROM events2020 WHERE player_id = 71790 AND league_id = 49506 AND action = 18
0.0022  SELECT action,minute FROM events2020 WHERE player_id = 71790 AND league_id = 49506 AND action = 19
0.0019  SELECT e.* FROM `events2020` e WHERE e.player_id = 71790 AND league_id = 53492 ORDER BY e.date ASC
0.0022  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 53492 AND rel.player_id=71790
0.0020  SELECT action,minute FROM events2020 WHERE player_id = 71790 AND league_id = 53492 AND action = 18
0.0019  SELECT action,minute FROM events2020 WHERE player_id = 71790 AND league_id = 53492 AND action = 19
0.0019  SELECT e.* FROM `events2020` e WHERE e.player_id = 71790 AND league_id = 53563 ORDER BY e.date ASC
0.0079  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 53563 AND rel.player_id=71790
0.0019  SELECT action,minute FROM events2020 WHERE player_id = 71790 AND league_id = 53563 AND action = 18
0.0020  SELECT action,minute FROM events2020 WHERE player_id = 71790 AND league_id = 53563 AND action = 19