4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Imagen de Ciudad Nueva Santa Cruz

J. Rodríguez

Jugador del Ciudad Nueva Santa Cruz
Ficha de J. Rodríguez
Nacionalidad
Bolivia
Nombre
José Andres Rodríguez Cortez
Edad
24 Años (05-10-1999)
Equipo
Ciudad Nueva Santa Cruz
Posición
Centrocampista
Liga
Copa Simón Bolívar 2023 G 2
  • Jugador del Ciudad Nueva Santa Cruz desde hace 9 meses
    • Compañeros de equipo
    Fotos
    1
    • Foto principal de J. Rodríguez | Club Destroyers
    0 Comentarios

    No hay comentarios


      USO DE MEMORIA  
    5,803,600 bytes
      BENCHMARKS  
    Loading Time Base Classes  0.0012
    Controller Execution Time ( Player / Index )  0.8815
    Total Execution Time  0.8827
      CADENA URL  
    /jugador/j-rodriguez-570314
      GET DATOS  
    $_GET['/jugador/j-rodriguez-570314']  
      POST DATOS  
    No hay datos POST existentes
      CONSULTAS (67)  
    0.0004   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` = '570314'
    0.0113  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 = 'j-rodriguez-570314' ORDER BY rp.year DESC, ct.troncal DESC, rp.in_squad DESC
    0.0139  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 = 'j-rodriguez-570314' ORDER BY rp.year DESC, ct.troncal DESC, rp.in_squad DESC
    0.0114  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 = 72941
    0.0114  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 = 66450
    0.0115  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 = 67911
    0.0119  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 = 66233
    0.0122  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 = 50059
    0.0128  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 = 42447
    0.0136  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 = 43346
    0.0140  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 = 43736
    0.0133  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 = 48573
    0.0136  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 = 39769
    0.0135  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 = 42040
    0.0108  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 = '570314'
    0.0143  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 = 72941 AND rp.teamId = 144287 AND rp.in_squad=1 ORDER BY p.role>0 DESC, p.role ASC, rp.squadNumber ASC
    0.0117  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 = 570314 ORDER BY rp.year DESC
    0.0117  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 = '570314' and rp.type = 3 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
    0.0111  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '570314' and rp.type = 3
    0.0113  SELECT e.* FROM `events2023` e WHERE e.player_id = 570314 AND league_id = 72941 ORDER BY e.date ASC
    0.0118  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 72941 AND rel.player_id=570314
    0.0111  SELECT action,minute FROM events2023 WHERE player_id = 570314 AND league_id = 72941 AND action = 18
    0.0110  SELECT action,minute FROM events2023 WHERE player_id = 570314 AND league_id = 72941 AND action = 19
    0.0111  SELECT e.* FROM `events2022` e WHERE e.player_id = 570314 AND league_id = 66450 ORDER BY e.date ASC
    0.0130  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 66450 AND rel.player_id=570314
    0.0111  SELECT action,minute FROM events2022 WHERE player_id = 570314 AND league_id = 66450 AND action = 18
    0.0111  SELECT action,minute FROM events2022 WHERE player_id = 570314 AND league_id = 66450 AND action = 19
    0.0111  SELECT e.* FROM `events2022` e WHERE e.player_id = 570314 AND league_id = 67911 ORDER BY e.date ASC
    0.0122  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 67911 AND rel.player_id=570314
    0.0112  SELECT action,minute FROM events2022 WHERE player_id = 570314 AND league_id = 67911 AND action = 18
    0.0111  SELECT action,minute FROM events2022 WHERE player_id = 570314 AND league_id = 67911 AND action = 19
    0.0112  SELECT e.* FROM `events2022` e WHERE e.player_id = 570314 AND league_id = 66233 ORDER BY e.date ASC
    0.0121  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 66233 AND rel.player_id=570314
    0.0114  SELECT action,minute FROM events2022 WHERE player_id = 570314 AND league_id = 66233 AND action = 18
    0.0112  SELECT action,minute FROM events2022 WHERE player_id = 570314 AND league_id = 66233 AND action = 19
    0.0114  SELECT e.* FROM `events2019` e WHERE e.player_id = 570314 AND league_id = 48663 ORDER BY e.date ASC
    0.0123  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 48663 AND rel.player_id=570314
    0.0123  SELECT action,minute FROM events2019 WHERE player_id = 570314 AND league_id = 48663 AND action = 18
    0.0124  SELECT action,minute FROM events2019 WHERE player_id = 570314 AND league_id = 48663 AND action = 19
    0.0113  SELECT e.* FROM `events2019` e WHERE e.player_id = 570314 AND league_id = 50059 ORDER BY e.date ASC
    0.0119  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 50059 AND rel.player_id=570314
    0.0108  SELECT action,minute FROM events2019 WHERE player_id = 570314 AND league_id = 50059 AND action = 18
    0.0123  SELECT action,minute FROM events2019 WHERE player_id = 570314 AND league_id = 50059 AND action = 19
    0.0112  SELECT e.* FROM `events2018` e WHERE e.player_id = 570314 AND league_id = 42447 ORDER BY e.date ASC
    0.0119  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 42447 AND rel.player_id=570314
    0.0116  SELECT action,minute FROM events2018 WHERE player_id = 570314 AND league_id = 42447 AND action = 18
    0.0115  SELECT action,minute FROM events2018 WHERE player_id = 570314 AND league_id = 42447 AND action = 19
    0.0110  SELECT e.* FROM `events2018` e WHERE e.player_id = 570314 AND league_id = 43346 ORDER BY e.date ASC
    0.0116  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 43346 AND rel.player_id=570314
    0.0110  SELECT action,minute FROM events2018 WHERE player_id = 570314 AND league_id = 43346 AND action = 18
    0.0111  SELECT action,minute FROM events2018 WHERE player_id = 570314 AND league_id = 43346 AND action = 19
    0.0113  SELECT e.* FROM `events2018` e WHERE e.player_id = 570314 AND league_id = 43736 ORDER BY e.date ASC
    0.0117  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 43736 AND rel.player_id=570314
    0.0123  SELECT action,minute FROM events2018 WHERE player_id = 570314 AND league_id = 43736 AND action = 18
    0.0123  SELECT action,minute FROM events2018 WHERE player_id = 570314 AND league_id = 43736 AND action = 19
    0.0111  SELECT e.* FROM `events2018` e WHERE e.player_id = 570314 AND league_id = 48573 ORDER BY e.date ASC
    0.0111  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 48573 AND rel.player_id=570314
    0.0113  SELECT action,minute FROM events2018 WHERE player_id = 570314 AND league_id = 48573 AND action = 18
    0.0111  SELECT action,minute FROM events2018 WHERE player_id = 570314 AND league_id = 48573 AND action = 19
    0.0111  SELECT e.* FROM `events2017` e WHERE e.player_id = 570314 AND league_id = 39769 ORDER BY e.date ASC
    0.0111  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 39769 AND rel.player_id=570314
    0.0111  SELECT action,minute FROM events2017 WHERE player_id = 570314 AND league_id = 39769 AND action = 18
    0.0107  SELECT action,minute FROM events2017 WHERE player_id = 570314 AND league_id = 39769 AND action = 19
    0.0106  SELECT e.* FROM `events2017` e WHERE e.player_id = 570314 AND league_id = 42040 ORDER BY e.date ASC
    0.0106  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 42040 AND rel.player_id=570314
    0.0105  SELECT action,minute FROM events2017 WHERE player_id = 570314 AND league_id = 42040 AND action = 18
    0.0105  SELECT action,minute FROM events2017 WHERE player_id = 570314 AND league_id = 42040 AND action = 19