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

D. Valdivia

Jugador del Oriente Petrolero
Ficha de D. Valdivia
Nacionalidad
Bolivia
Nombre
Diego Valdivia Ascarrunz
Edad
23 Años (14-04-2001)
Dorsal
22
Equipo
Oriente Petrolero
Posición
Portero
Liga
Primera División Bolivia 2023
  • Jugador del Oriente Petrolero desde hace 1 año
  • Compañeros de equipo
    Fotos
    1
    • Foto principal de D. Valdivia | Royal Pari

    No hay comentarios


      USO DE MEMORIA  
    5,649,680 bytes
      BENCHMARKS  
    Loading Time Base Classes  0.0012
    Controller Execution Time ( Player / Index )  0.1796
    Total Execution Time  0.1808
      CADENA URL  
    /jugador/D-Valdivia-776000
      GET DATOS  
    $_GET['/jugador/D-Valdivia-776000']  
      POST DATOS  
    No hay datos POST existentes
      CONSULTAS (68)  
    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` = '776000'
    0.0024  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 = 'D-Valdivia-776000' ORDER BY rp.year DESC, ct.troncal DESC, rp.in_squad DESC
    0.0066  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 = 'D-Valdivia-776000' 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 = 70727
    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 = 70927
    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 = 71368
    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 = 66450
    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 = 67683
    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 = 67911
    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 = 53600
    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 = 50059
    0.0026  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.0019  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 = '776000'
    0.0021  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 = 776000 ORDER BY rp.year DESC
    0.0020  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 = '776000' and rp.type = 3 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
    0.0019  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '776000' and rp.type = 3
    0.0019  SELECT e.* FROM `events2023` e WHERE e.player_id = 776000 AND league_id = 70916 ORDER BY e.date ASC
    0.0019  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 70916 AND rel.player_id=776000
    0.0019  SELECT action,minute FROM events2023 WHERE player_id = 776000 AND league_id = 70916 AND action = 18
    0.0018  SELECT action,minute FROM events2023 WHERE player_id = 776000 AND league_id = 70916 AND action = 19
    0.0018  SELECT e.* FROM `events2023` e WHERE e.player_id = 776000 AND league_id = 70727 ORDER BY e.date ASC
    0.0019  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 70727 AND rel.player_id=776000
    0.0019  SELECT action,minute FROM events2023 WHERE player_id = 776000 AND league_id = 70727 AND action = 18
    0.0018  SELECT action,minute FROM events2023 WHERE player_id = 776000 AND league_id = 70727 AND action = 19
    0.0018  SELECT e.* FROM `events2023` e WHERE e.player_id = 776000 AND league_id = 70925 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 = 70925 AND rel.player_id=776000
    0.0028  SELECT action,minute FROM events2023 WHERE player_id = 776000 AND league_id = 70925 AND action = 18
    0.0019  SELECT action,minute FROM events2023 WHERE player_id = 776000 AND league_id = 70925 AND action = 19
    0.0019  SELECT e.* FROM `events2023` e WHERE e.player_id = 776000 AND league_id = 70927 ORDER BY e.date ASC
    0.0040  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 70927 AND rel.player_id=776000
    0.0018  SELECT action,minute FROM events2023 WHERE player_id = 776000 AND league_id = 70927 AND action = 18
    0.0018  SELECT action,minute FROM events2023 WHERE player_id = 776000 AND league_id = 70927 AND action = 19
    0.0019  SELECT e.* FROM `events2023` e WHERE e.player_id = 776000 AND league_id = 71368 ORDER BY e.date ASC
    0.0019  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 71368 AND rel.player_id=776000
    0.0018  SELECT action,minute FROM events2023 WHERE player_id = 776000 AND league_id = 71368 AND action = 18
    0.0019  SELECT action,minute FROM events2023 WHERE player_id = 776000 AND league_id = 71368 AND action = 19
    0.0018  SELECT e.* FROM `events2022` e WHERE e.player_id = 776000 AND league_id = 66450 ORDER BY e.date ASC
    0.0019  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=776000
    0.0018  SELECT action,minute FROM events2022 WHERE player_id = 776000 AND league_id = 66450 AND action = 18
    0.0018  SELECT action,minute FROM events2022 WHERE player_id = 776000 AND league_id = 66450 AND action = 19
    0.0018  SELECT e.* FROM `events2022` e WHERE e.player_id = 776000 AND league_id = 67683 ORDER BY e.date ASC
    0.0018  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 67683 AND rel.player_id=776000
    0.0019  SELECT action,minute FROM events2022 WHERE player_id = 776000 AND league_id = 67683 AND action = 18
    0.0019  SELECT action,minute FROM events2022 WHERE player_id = 776000 AND league_id = 67683 AND action = 19
    0.0021  SELECT e.* FROM `events2022` e WHERE e.player_id = 776000 AND league_id = 67911 ORDER BY e.date ASC
    0.0019  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=776000
    0.0019  SELECT action,minute FROM events2022 WHERE player_id = 776000 AND league_id = 67911 AND action = 18
    0.0020  SELECT action,minute FROM events2022 WHERE player_id = 776000 AND league_id = 67911 AND action = 19
    0.0019  SELECT e.* FROM `events2021` e WHERE e.player_id = 776000 AND league_id = 61655 ORDER BY e.date ASC
    0.0018  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 61655 AND rel.player_id=776000
    0.0018  SELECT action,minute FROM events2021 WHERE player_id = 776000 AND league_id = 61655 AND action = 18
    0.0019  SELECT action,minute FROM events2021 WHERE player_id = 776000 AND league_id = 61655 AND action = 19
    0.0018  SELECT e.* FROM `events2020` e WHERE e.player_id = 776000 AND league_id = 53600 ORDER BY e.date ASC
    0.0019  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 53600 AND rel.player_id=776000
    0.0022  SELECT action,minute FROM events2020 WHERE player_id = 776000 AND league_id = 53600 AND action = 18
    0.0018  SELECT action,minute FROM events2020 WHERE player_id = 776000 AND league_id = 53600 AND action = 19
    0.0018  SELECT e.* FROM `events2019` e WHERE e.player_id = 776000 AND league_id = 48663 ORDER BY e.date ASC
    0.0019  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=776000
    0.0018  SELECT action,minute FROM events2019 WHERE player_id = 776000 AND league_id = 48663 AND action = 18
    0.0019  SELECT action,minute FROM events2019 WHERE player_id = 776000 AND league_id = 48663 AND action = 19
    0.0018  SELECT e.* FROM `events2019` e WHERE e.player_id = 776000 AND league_id = 50059 ORDER BY e.date ASC
    0.0019  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=776000
    0.0018  SELECT action,minute FROM events2019 WHERE player_id = 776000 AND league_id = 50059 AND action = 18
    0.0018  SELECT action,minute FROM events2019 WHERE player_id = 776000 AND league_id = 50059 AND action = 19
    0.0019  SELECT e.* FROM `events2018` e WHERE e.player_id = 776000 AND league_id = 43736 ORDER BY e.date ASC
    0.0019  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=776000
    0.0020  SELECT action,minute FROM events2018 WHERE player_id = 776000 AND league_id = 43736 AND action = 18
    0.0018  SELECT action,minute FROM events2018 WHERE player_id = 776000 AND league_id = 43736 AND action = 19