No hay productos en el carrito.

Actividad

Avistamiento de fauna

Nivel de dificultad

Baja

Duración

Varios días

Altitud

500 m.s.n.m

Temperatura

18 - 28 ºC

Región

Zona Orinoquía

Precio desde:

$1.940.000

Hato la Aurora

 

Hato La Aurora es una reserva privada en el llano Colombiano. Se puede observar mucha fauna silvestre. La reserva ofrece diferentes actividades durante las cuales el visitante puede encontrar vida salvaje como chigüiros, venado coliblancos, babillas, ganado, caballos salvajes, Garzas, Garzones, Alcaravanes, Mochuelos, guereres, variedad de ibis y muchas especies de aves.

 

Itinerario 

Día 1: Salida de Yopal a las 8:00 am. Traslado en carro 4×4 hacia la reserva Hato La Aurora. El viaje dura 4-5  horas aproximadamente (dependiendo de la condición de la carretera). Instalación en el alojamiento. Almuerzo en la reserva. Actividad de la tarde.

 

Día 2: Todo el día llena de diferentes actividades. En la reserva se puede hacer cabalgatas, caminatas, paseo en lancha, safari, etc., para buscar animales salvajes y realizar avistamiento de aves. Cada día el guía les va a recomendar las mejores actividades de acuerdo con las condiciones climáticas y la temporada.  Alojamiento en la reserva.

 

Día 3: Similar al día 2, se realiza diferentes actividades durante todo el día. Alojamiento en la reserva. Noche de serenata llanera (muestra folclórica).

 

Día 4: En la mañana traslado en carro 4×4 a Yopal. Fin del tour.

 

 

Descripción de algunas de las actividades que se puede realizar durante la estadía en la reserva:

 

  • La majestuosa biodiversidad del llano de Casanare, ofrece la posibilidad a través de un Safarí por parajes de entorno controlado, encontrarse animales en vida salvaje como: chigüiros, venado coliblancos, babillas, anacondas, caballos salvajes, Garzas, Garzones, Alcaravanes, Mochuelos, variedad de ibis y muchas especies de aves. Antes de realizar el recorrido, se realiza una inducción donde se establecen las normas de seguridad para tener un recorrido seguro. Los Guías locales cuentan con años de trayectoria y experiencia.

 

  • Cerca del caño “El Toro”, caño “El Indio”, y del Rio Chire se encuentran sitios de pesca turística. Se debe destinar un día para esta actividad el almuerzo se prepara en las orillas de estos lugares con la producción de la pesca que se logre. Esta aventura permite un delicioso contacto con el entorno es posible ver animales en vida salvaje como guereres.

 

  • Una cabalgata con caballos de la reserva. Esta es una actividad para disfrutar con amigos y familiares de todas las edades. Durante esta aventura se podrá percibir los aromas y colores del paisaje. En esta ocasión es posible observar gran cantidad de aves.

 

Costo POR persona:

Min 2 pax: $ 2.230.000
Min 4 pax: $ 1.940.000

 

  • Descuento de alojamiento múltiple: $ 140.000 por persona
  • Descuento si duermes en hamaca: $ 318.000 por persona
  • Descuento si acampas: $ 388.000 por persona (solo es posible acampar entre 15 de Noviembre y 15 de Abril. Hay que llevar su equipo de camping)
  • Costo adicional acomodación sencilla: $ 142.000 pesos por persona

 

Para poder reservar se realiza el pago de $ 1.000.000 pesos por persona.  El saldo se paga mínimo 7 días hábiles antes del viaje.

 

 

Cuenta de Davivienda y nuestras tiendas aliadas para realizar la inscripcion:

  • Banco Davivienda cuenta de ahorros Nr. 0051 00074649  a nombre de Carlos Avellaneda.
  • Almacenes de montaña 14 Ochomiles:
    • CC Andino: Local 340 Bogotá.
    • Norte: Calle 122 Nr.18-56.
    • Principal: Cra 15 Nr.96-67.
    • CC Gran Estación: Local 1-49 Bogotá.
  • Almacén Gangas Inc:
    • Barrio Galerías:  Cra 17 Nr 52-85 (Local 203).

Incluye

 

  • Transporte terrestre Yopal – Hato La Aurora – Yopal (capacidad maxima 4 pax)
  • Guías locales en la reserva
  • Actividades durante la estadía en la reserva (lanchas, caminatas, safari, fogata llanera, cabalgata)
  • 3 noches en la Casona en acomodación doble
  • Muestra folclorica
  • Alimentación completa desde el almuerzo Día 1 hasta el desayuno día 4

 

No incluye

 

  • Vuelo o transporte terrestre hasta Yopal y regreso
  • Noches adicionales en Yopal (si es el caso)
  • Gastos personales
  • Almuerzo el día 4
  • Propinas

 

Equipo recomendado para llevar

 

  • Morral ergonómico para cargar en la espalda
  • Ropa cómoda impermeable y transpirable. Tenga en cuenta el clima del lugar que va a visitar
  • Utilice ropa que se seque rápido, no utilice jean o fibras totalmente impermeables
  • Botas o calzado con suela de buen agarre y que proteja el tobillo. No estrene calzado en una caminata
  • Sombrero o cachucha, bloqueador solar
  • Lleve sus medicamentos personales
  • Documentos personales (carné de seguro médico y cédula)

 

Cómo llegar

Se puede volar a Yopal en Avianc, Latam  o Easy Fly.

Vuelo recomendado con Easy Fly saliendo a las 5:31 am de Bogotá llegando a las 6:31 a Yopal. Para regresar saliendo a las 18:00 de Yopal llegando a las 19:00 a Bogotá.

Si es vía Avianca recomendamos salir a las 6:03 am llegando a las 07:13 a Yopal. Para volver saliendo a las 18:45 y llegando a las 19:52 a Bogotá.

 

Alojamiento en la reserva

En la reserva NO hay wifi, NO hay agua caliente, NO hay aire acondicionado. Los alojamientos son rústicos.

Llano Colombiano.

Elija la fecha y la cantidad de amigos que viajará con usted:

Valoraciones

No hay valoraciones aún.

Sé el primero en valorar “Hato la Aurora”

Tu dirección de correo electrónico no será publicada. Los campos obligatorios están marcados con *

También te puede interesar

NUEVOS CAMINOS

Togüí – cascadas, cañones y senderos

Un viaje muy especial en el departamento de Boyacá por los cañones de los ríos Pómeca y Ubaza en la región de Togüí. El paisaje se caracteriza por su gran cantidad de bosques, cuevas, cascadas y profundos acantilados. Togüí esta ubicado a 195 km desde Bogotá. Para llegar se toma la via Bogotá – Tunja – Moniquirá.

Ver Destino
Toggle Console (5)
Unknown
wp_enqueue_script was called incorrectly. Scripts and styles should not be registered or enqueued until the wp_enqueue_scripts, admin_enqueue_scripts, or login_enqueue_scripts hooks. Please see Debugging in WordPress for more information. (This message was added in version 3.3.0.) on line 5167 in file /home/retorno/public_html/wp-includes/functions.php
Notice
Constant SHORTINIT already defined on line 927 in file /home/retorno/public_html/wp-content/themes/svhen2/functions.php
Notice
Undefined index: tracking_actid on line 847 in file /home/retorno/public_html/wp-content/plugins/activecampaign-subscription-forms/activecampaign.php
Unknown
get_currentuserinfo ha quedado obsoleto desde la versión 4.5.0. Utiliza wp_get_current_user() en su lugar. on line 4713 in file /home/retorno/public_html/wp-includes/functions.php
Unknown (2)
get_woocommerce_term_meta ha quedado obsoleto desde la versión 3.6. Utiliza get_term_meta en su lugar. on line 4713 in file /home/retorno/public_html/wp-includes/functions.php
Profiler (0 ms)
No entries found.
SQL (166 queries | 21.03 ms)
0.1040
SELECT option_value 
FROM wpfx_options 
WHERE option_name = 'mce_show_notice' 
LIMIT 1
0.0651
SELECT option_value 
FROM wpfx_options 
WHERE option_name = 'mce_show_update_news' 
LIMIT 1
0.0820
SELECT option_value 
FROM wpfx_options 
WHERE option_name = 'uninstall_plugins' 
LIMIT 1
0.1121
SELECT option_value 
FROM wpfx_options 
WHERE option_name = 'can_compress_scripts' 
LIMIT 1
0.1400
SELECT name, val 
FROM wpfx_wfconfig 
WHERE autoload = 'yes'
0.0761
SELECT `name`, `value` 
FROM `wpfx_wfls_settings` 
WHERE `autoload` = 'yes'
0.0720
SELECT name, val, autoload 
FROM wpfx_wfconfig 
WHERE name = 'detectProxyRecommendation'
0.0660
SELECT name, val, autoload 
FROM wpfx_wfconfig 
WHERE name = 'whitelistPresets'
0.5209
SHOW FULL COLUMNS 
FROM `wpfx_wfblocks7`
0.2022
SELECT * 
FROM `wpfx_wfblocks7` 
WHERE `IP` = '\0\0\0\0\0\0\0\0\0\0#p' 
AND `type` = 7 
AND (`expiration` = 0 OR `expiration` > UNIX_TIMESTAMP())
0.0639
SELECT name, val, autoload 
FROM wpfx_wfconfig 
WHERE name = 'wordfenceCentralConnected'
0.1180
SELECT option_value 
FROM wpfx_options 
WHERE option_name = 'fs_storage_logger' 
LIMIT 1
0.0691
SELECT option_value 
FROM wpfx_options 
WHERE option_name = 'fs_cache_3359' 
LIMIT 1
0.0892
SELECT option_value 
FROM wpfx_options 
WHERE option_name = 'as_has_wp_comment_logs' 
LIMIT 1
0.0732
SELECT option_value 
FROM wpfx_options 
WHERE option_name = 'acf_to_rest_api_request_version' 
LIMIT 1
0.1202
SELECT name, val, autoload 
FROM wpfx_wfconfig 
WHERE name = 'needsGeoIPSync'
0.0739
SELECT name, val, autoload 
FROM wpfx_wfconfig 
WHERE name = 'detectProxyRecommendation'
0.0620
SELECT name, val, autoload 
FROM wpfx_wfconfig 
WHERE name = 'serverIP'
0.0651
SELECT MAX(attackLogTime) 
FROM wpfx_wfhits
0.0620
SELECT option_value 
FROM wpfx_options 
WHERE option_name = 'wordfence_lastSyncAttackData' 
LIMIT 1
0.2668
SELECT *, CASE WHEN `type` = 3 THEN 0 WHEN `type` = 4 THEN 1 WHEN `type` = 7 THEN 2 WHEN `type` = 6 THEN 3 WHEN `type` = 5 THEN 4 WHEN `type` = 9 THEN 5 WHEN `type` = 8 THEN 6 WHEN `type` = 2 THEN 7 WHEN `type` = 1 THEN 8 ELSE 9999 END AS `typeSort`, CASE WHEN `type` = 3 THEN `parameters` WHEN `type` = 4 THEN `parameters` WHEN `type` = 1 THEN `IP` WHEN `type` = 9 THEN `IP` WHEN `type` = 5 THEN `IP` WHEN `type` = 6 THEN `IP` WHEN `type` = 7 THEN `IP` WHEN `type` = 2 THEN `IP` WHEN `type` = 8 THEN `IP` ELSE 9999 END AS `detailSort` 
FROM `wpfx_wfblocks7` 
WHERE `type` IN (4) 
AND (`expiration` = 0 OR `expiration` > UNIX_TIMESTAMP()) 
ORDER BY `typeSort` ASC, `id` DESC
0.1740
SELECT *, CASE WHEN `type` = 3 THEN 0 WHEN `type` = 4 THEN 1 WHEN `type` = 7 THEN 2 WHEN `type` = 6 THEN 3 WHEN `type` = 5 THEN 4 WHEN `type` = 9 THEN 5 WHEN `type` = 8 THEN 6 WHEN `type` = 2 THEN 7 WHEN `type` = 1 THEN 8 ELSE 9999 END AS `typeSort`, CASE WHEN `type` = 3 THEN `parameters` WHEN `type` = 4 THEN `parameters` WHEN `type` = 1 THEN `IP` WHEN `type` = 9 THEN `IP` WHEN `type` = 5 THEN `IP` WHEN `type` = 6 THEN `IP` WHEN `type` = 7 THEN `IP` WHEN `type` = 2 THEN `IP` WHEN `type` = 8 THEN `IP` ELSE 9999 END AS `detailSort` 
FROM `wpfx_wfblocks7` 
WHERE `type` IN (3) 
AND (`expiration` = 0 OR `expiration` > UNIX_TIMESTAMP()) 
ORDER BY `typeSort` ASC, `id` DESC
0.1700
SELECT * 
FROM `wpfx_wfblocks7` 
WHERE `type` IN (1, 8, 9, 2, 5, 6) 
AND `IP` = '\0\0\0\0\0\0\0\0\0\0#p' 
AND (`expiration` = 0 OR `expiration` > UNIX_TIMESTAMP()) 
ORDER BY `blockedTime` DESC 
LIMIT 1
0.0911
SELECT option_value 
FROM wpfx_options 
WHERE option_name = 'post_grid_settings' 
LIMIT 1
0.0699
SELECT option_value 
FROM wpfx_options 
WHERE option_name = 'nonce_key' 
LIMIT 1
0.0620
SELECT option_value 
FROM wpfx_options 
WHERE option_name = 'nonce_salt' 
LIMIT 1
0.0880
SELECT option_value 
FROM wpfx_options 
WHERE option_name = 'woocommerce_dismissed_info_banner' 
LIMIT 1
0.0620
SELECT option_value 
FROM wpfx_options 
WHERE option_name = 'woocommerce_ga_id' 
LIMIT 1
0.0632
SELECT option_value 
FROM wpfx_options 
WHERE option_name = 'woocommerce_ga_standard_tracking_enabled' 
LIMIT 1
0.0629
SELECT option_value 
FROM wpfx_options 
WHERE option_name = 'woocommerce_ga_support_display_advertising' 
LIMIT 1
0.0579
SELECT option_value 
FROM wpfx_options 
WHERE option_name = 'woocommerce_ga_support_enhanced_link_attribution' 
LIMIT 1
0.0658
SELECT option_value 
FROM wpfx_options 
WHERE option_name = 'woocommerce_ga_use_universal_analytics' 
LIMIT 1
0.0610
SELECT option_value 
FROM wpfx_options 
WHERE option_name = 'woocommerce_ga_ecommerce_tracking_enabled' 
LIMIT 1
0.0880
SELECT option_value 
FROM wpfx_options 
WHERE option_name = 'mailchimp_woocommerce_db_mailchimp_carts' 
LIMIT 1
0.0710
SELECT option_value 
FROM wpfx_options 
WHERE option_name = '301_redirects_wildcard' 
LIMIT 1
0.1230
SELECT option_value 
FROM wpfx_options 
WHERE option_name = 'woocommerce_onboarding_opt_in' 
LIMIT 1
0.0639
SELECT option_value 
FROM wpfx_options 
WHERE option_name = 'wc_onboarding_opt_in' 
LIMIT 1
0.0620
SELECT option_value 
FROM wpfx_options 
WHERE option_name = 'woocommerce_task_list_hidden' 
LIMIT 1
0.0870
SELECT * 
FROM wpfx_posts 
WHERE ID = -1 
LIMIT 1
0.1180
SELECT option_value 
FROM wpfx_options 
WHERE option_name = 'cptui_taxonomies' 
LIMIT 1
0.5589
SELECT option_value 
FROM wpfx_options 
WHERE option_name = 'image-sizes-docs-json' 
LIMIT 1
0.0701
SELECT option_value 
FROM wpfx_options 
WHERE option_name = 'relevanssi_trim_logs' 
LIMIT 1
0.1409
SELECT option_value 
FROM wpfx_options 
WHERE option_name = 'woocommerce_thumbnail_cropping' 
LIMIT 1
0.0739
SELECT option_value 
FROM wpfx_options 
WHERE option_name = 'woocommerce_google_analytics_pro_notice_shown' 
LIMIT 1
0.0648
SELECT COUNT( * ) 
FROM wpfx_posts 
WHERE post_type = 'shop_order' 
AND post_status = 'wc-completed'
0.6211
SHOW FULL COLUMNS 
FROM `wpfx_wflivetraffichuman`
0.1290
SELECT COUNT(*) 
FROM wpfx_wflivetraffichuman 
WHERE IP = '\0\0\0\0\0\0\0\0\0\0#p' 
AND identifier = 'F	V\nV|!' 
AND expiration >= UNIX_TIMESTAMP()
0.5281
SELECT wpfx_posts.* 
FROM wpfx_posts 
WHERE 1=1 
AND wpfx_posts.post_name = 'hato-la-aurora' 
AND wpfx_posts.post_type = 'product' 
ORDER BY wpfx_posts.post_date DESC
0.0660
SELECT option_value 
FROM wpfx_options 
WHERE option_name = 'relevanssi_index_image_files' 
LIMIT 1
0.9792
SELECT t.*, tt.*, tr.object_id 
FROM wpfx_terms AS t 
INNER JOIN wpfx_term_taxonomy AS tt ON t.term_id = tt.term_id 
INNER JOIN wpfx_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id 
WHERE tt.taxonomy IN ('product_type', 'product_visibility', 'product_cat', 'product_tag', 'product_shipping_class') 
AND tr.object_id IN (201) 
ORDER BY t.name ASC
0.7639
SELECT post_id, meta_key, meta_value 
FROM wpfx_postmeta 
WHERE post_id IN (201) 
ORDER BY meta_id ASC
0.0782
SELECT option_value 
FROM wpfx_options 
WHERE option_name = 'exactmetrics_network_profile' 
LIMIT 1
0.1371
SELECT COUNT(*) 
FROM wpfx_wflivetraffichuman 
WHERE IP = '\0\0\0\0\0\0\0\0\0\0#p' 
AND identifier = 'F	V\nV|!' 
AND expiration >= UNIX_TIMESTAMP()
0.0732
SELECT option_value 
FROM wpfx_options 
WHERE option_name = 'alm_settings' 
LIMIT 1
0.1240
SELECT wpfx_posts.* 
FROM wpfx_posts 
WHERE 1=1 
AND wpfx_posts.post_type = 'wpcf7_contact_form' 
AND (wpfx_posts.post_status = 'publish' OR wpfx_posts.post_status = 'acf-disabled') 
ORDER BY wpfx_posts.post_date DESC
0.1211
SELECT post_id, meta_key, meta_value 
FROM wpfx_postmeta 
WHERE post_id IN (2672,2540,1830,1658,1637,1576,1573,1565,1564,1521,1499,1486,1101,1100,1099,1088,909,281,256,127) 
ORDER BY meta_id ASC
0.0701
SELECT * 
FROM wpfx_users 
WHERE ID = '3' 
LIMIT 1
0.0741
SELECT user_id, meta_key, meta_value 
FROM wpfx_usermeta 
WHERE user_id IN (3) 
ORDER BY umeta_id ASC
0.0720
SELECT * 
FROM wpfx_users 
WHERE ID = '4' 
LIMIT 1
0.0699
SELECT user_id, meta_key, meta_value 
FROM wpfx_usermeta 
WHERE user_id IN (4) 
ORDER BY umeta_id ASC
0.0720
SELECT * 
FROM wpfx_wc_tax_rate_classes 
ORDER BY name;
0.4990
SELECT * 
FROM `wpfx_yoast_indexable` 
WHERE `object_id` = '201' 
AND `object_type` = 'post' 
LIMIT 1
0.1919
SELECT * 
FROM wpfx_posts 
WHERE ID = 2207 
LIMIT 1
0.2329
SELECT post_id, meta_key, meta_value 
FROM wpfx_postmeta 
WHERE post_id IN (2207) 
ORDER BY meta_id ASC
0.0789
SELECT * 
FROM wpfx_posts 
WHERE ID = 745 
LIMIT 1
0.0660
SELECT post_id, meta_key, meta_value 
FROM wpfx_postmeta 
WHERE post_id IN (745) 
ORDER BY meta_id ASC
0.0789
SELECT * 
FROM wpfx_posts 
WHERE ID = 44 
LIMIT 1
0.0679
SELECT option_value 
FROM wpfx_options 
WHERE option_name = 'woocommerce_review_rating_required' 
LIMIT 1
0.0720
SELECT option_value 
FROM wpfx_options 
WHERE option_name = 'psl_fb_login' 
LIMIT 1
0.0889
SELECT * 
FROM wpfx_posts 
WHERE ID = 864 
LIMIT 1
0.0670
SELECT post_id, meta_key, meta_value 
FROM wpfx_postmeta 
WHERE post_id IN (864) 
ORDER BY meta_id ASC
0.0811
SELECT t.*, tt.* 
FROM wpfx_terms AS t 
INNER JOIN wpfx_term_taxonomy AS tt ON t.term_id = tt.term_id 
WHERE tt.taxonomy IN ('nav_menu') 
AND t.slug = 'header' 
LIMIT 1
0.0670
SELECT tr.object_id 
FROM wpfx_term_relationships AS tr 
INNER JOIN wpfx_term_taxonomy AS tt ON tr.term_taxonomy_id = tt.term_taxonomy_id 
WHERE tt.taxonomy IN ('nav_menu') 
AND tt.term_id IN ('3') 
ORDER BY tr.object_id ASC
0.0761
SELECT wpfx_posts.* 
FROM wpfx_posts 
WHERE 1=1 
AND wpfx_posts.ID IN (19,20,21,22,1186,1187,1188,1189,1698,1728,2678) 
AND wpfx_posts.post_type = 'nav_menu_item' 
AND ((wpfx_posts.post_status = 'publish')) 
ORDER BY wpfx_posts.menu_order ASC
0.0720
SELECT post_id, meta_key, meta_value 
FROM wpfx_postmeta 
WHERE post_id IN (22,21,20,19,2678,1698,1728,1189,1187,1188,1186) 
ORDER BY meta_id ASC
0.0789
SELECT wpfx_posts.* 
FROM wpfx_posts 
WHERE 1=1 
AND wpfx_posts.ID IN (5,14,15,16,2668,17,46,8,7,6) 
AND wpfx_posts.post_type = 'page' 
AND ((wpfx_posts.post_status = 'publish')) 
ORDER BY wpfx_posts.post_date DESC
0.1340
SELECT post_id, meta_key, meta_value 
FROM wpfx_postmeta 
WHERE post_id IN (2668,46,17,16,15,14,8,7,6,5) 
ORDER BY meta_id ASC
0.6571
SELECT DISTINCT t.term_id, tt.parent, tt.count, tt.taxonomy 
FROM wpfx_terms AS t LEFT JOIN wpfx_termmeta ON ( t.term_id = wpfx_termmeta.term_id 
AND wpfx_termmeta.meta_key='order') 
INNER JOIN wpfx_term_taxonomy AS tt ON t.term_id = tt.term_id 
INNER JOIN wpfx_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id 
WHERE tt.taxonomy IN ('product_cat') 
AND tr.object_id IN (201) 
AND ( ( wpfx_termmeta.meta_key = 'order' OR wpfx_termmeta.meta_key IS NULL ) ) 
ORDER BY wpfx_termmeta.meta_value+0 ASC, t.name ASC
0.2298
SELECT term_id, meta_key, meta_value 
FROM wpfx_termmeta 
WHERE term_id IN (19) 
ORDER BY meta_id ASC
0.0660
SELECT option_value 
FROM wpfx_options 
WHERE option_name = '_transient_timeout_wc_term_counts' 
LIMIT 1
0.0629
SELECT option_value 
FROM wpfx_options 
WHERE option_name = '_transient_wc_term_counts' 
LIMIT 1
0.0708
SELECT option_value 
FROM wpfx_options 
WHERE option_name = '_options_global_net_social_repeater' 
LIMIT 1
0.0691
SELECT option_value 
FROM wpfx_options 
WHERE option_name = 'options_global_net_social_repeater' 
LIMIT 1
0.0749
SELECT option_value 
FROM wpfx_options 
WHERE option_name = 'options_global_net_social_repeater_0_global_icon' 
LIMIT 1
0.0961
SELECT option_value 
FROM wpfx_options 
WHERE option_name = 'options_global_net_social_repeater_0_global_link' 
LIMIT 1
0.0660
SELECT option_value 
FROM wpfx_options 
WHERE option_name = 'options_global_net_social_repeater_1_global_icon' 
LIMIT 1
0.0620
SELECT option_value 
FROM wpfx_options 
WHERE option_name = 'options_global_net_social_repeater_1_global_link' 
LIMIT 1
0.0629
SELECT option_value 
FROM wpfx_options 
WHERE option_name = 'options_global_net_social_repeater_2_global_icon' 
LIMIT 1
0.0629
SELECT option_value 
FROM wpfx_options 
WHERE option_name = 'options_global_net_social_repeater_2_global_link' 
LIMIT 1
0.0660
SELECT option_value 
FROM wpfx_options 
WHERE option_name = 'options_global_net_social_repeater_3_global_icon' 
LIMIT 1
0.0629
SELECT option_value 
FROM wpfx_options 
WHERE option_name = 'options_global_net_social_repeater_3_global_link' 
LIMIT 1
0.0629
SELECT option_value 
FROM wpfx_options 
WHERE option_name = 'options_global_net_social_repeater_4_global_icon' 
LIMIT 1
0.0620
SELECT option_value 
FROM wpfx_options 
WHERE option_name = 'options_global_net_social_repeater_4_global_link' 
LIMIT 1
0.0620
SELECT option_value 
FROM wpfx_options 
WHERE option_name = 'options_global_net_social_repeater_5_global_icon' 
LIMIT 1
0.0620
SELECT option_value 
FROM wpfx_options 
WHERE option_name = 'options_global_net_social_repeater_5_global_link' 
LIMIT 1
0.0620
SELECT option_value 
FROM wpfx_options 
WHERE option_name = 'options_global_net_social_repeater_6_global_icon' 
LIMIT 1
0.0610
SELECT option_value 
FROM wpfx_options 
WHERE option_name = 'options_global_net_social_repeater_6_global_link' 
LIMIT 1
0.0739
SELECT t.*, tt.* 
FROM wpfx_terms AS t 
INNER JOIN wpfx_term_taxonomy AS tt ON t.term_id = tt.term_id 
WHERE tt.taxonomy IN ('nav_menu') 
AND t.slug = 'header-sticky' 
LIMIT 1
0.0660
SELECT tr.object_id 
FROM wpfx_term_relationships AS tr 
INNER JOIN wpfx_term_taxonomy AS tt ON tr.term_taxonomy_id = tt.term_taxonomy_id 
WHERE tt.taxonomy IN ('nav_menu') 
AND tt.term_id IN ('2') 
ORDER BY tr.object_id ASC
0.0730
SELECT wpfx_posts.* 
FROM wpfx_posts 
WHERE 1=1 
AND wpfx_posts.ID IN (10,12,13,170) 
AND wpfx_posts.post_type = 'nav_menu_item' 
AND ((wpfx_posts.post_status = 'publish')) 
ORDER BY wpfx_posts.menu_order ASC
0.0670
SELECT post_id, meta_key, meta_value 
FROM wpfx_postmeta 
WHERE post_id IN (170,12,13,10) 
ORDER BY meta_id ASC
0.0720
SELECT wpfx_posts.* 
FROM wpfx_posts 
WHERE 1=1 
AND wpfx_posts.ID IN (46,7,8,6) 
AND wpfx_posts.post_type = 'page' 
AND ((wpfx_posts.post_status = 'publish')) 
ORDER BY wpfx_posts.post_date DESC
0.1271
SELECT option_value 
FROM wpfx_options 
WHERE option_name = '_options_header_logo' 
LIMIT 1
0.0660
SELECT option_value 
FROM wpfx_options 
WHERE option_name = 'options_header_logo' 
LIMIT 1
0.0730
SELECT t.*, tt.* 
FROM wpfx_terms AS t 
INNER JOIN wpfx_term_taxonomy AS tt ON t.term_id = tt.term_id 
WHERE tt.taxonomy IN ('nav_menu') 
ORDER BY t.name ASC
0.0648
SELECT term_id, meta_key, meta_value 
FROM wpfx_termmeta 
WHERE term_id IN (23,3,2) 
ORDER BY meta_id ASC
0.0651
SELECT tr.object_id 
FROM wpfx_term_relationships AS tr 
INNER JOIN wpfx_term_taxonomy AS tt ON tr.term_taxonomy_id = tt.term_taxonomy_id 
WHERE tt.taxonomy IN ('nav_menu') 
AND tt.term_id IN ('23') 
ORDER BY tr.object_id ASC
0.0782
SELECT wpfx_posts.* 
FROM wpfx_posts 
WHERE 1=1 
AND wpfx_posts.ID IN (19,20,21,22,1186,1187,1188,1189,1698,1728,2678) 
AND wpfx_posts.post_type = 'nav_menu_item' 
AND ((wpfx_posts.post_status = 'publish')) 
ORDER BY wpfx_posts.menu_order ASC
0.0732
SELECT option_value 
FROM wpfx_options 
WHERE option_name = '_options_global_header_language_spanish_link' 
LIMIT 1
0.0660
SELECT option_value 
FROM wpfx_options 
WHERE option_name = 'options_global_header_language_spanish_link' 
LIMIT 1
0.0741
SELECT option_value 
FROM wpfx_options 
WHERE option_name = '_options_global_header_language_spanish_flag' 
LIMIT 1
0.0648
SELECT option_value 
FROM wpfx_options 
WHERE option_name = 'options_global_header_language_spanish_flag' 
LIMIT 1
0.0682
SELECT * 
FROM wpfx_posts 
WHERE ID = 880 
LIMIT 1
0.0648
SELECT post_id, meta_key, meta_value 
FROM wpfx_postmeta 
WHERE post_id IN (880) 
ORDER BY meta_id ASC
0.0632
SELECT option_value 
FROM wpfx_options 
WHERE option_name = '_options_global_header_language_english_link' 
LIMIT 1
0.0641
SELECT option_value 
FROM wpfx_options 
WHERE option_name = 'options_global_header_language_english_link' 
LIMIT 1
0.0701
SELECT option_value 
FROM wpfx_options 
WHERE option_name = '_options_global_header_language_english_flag' 
LIMIT 1
0.0641
SELECT option_value 
FROM wpfx_options 
WHERE option_name = 'options_global_header_language_english_flag' 
LIMIT 1
0.0670
SELECT * 
FROM wpfx_posts 
WHERE ID = 879 
LIMIT 1
0.0639
SELECT post_id, meta_key, meta_value 
FROM wpfx_postmeta 
WHERE post_id IN (879) 
ORDER BY meta_id ASC
0.2720
SELECT * 
FROM wpfx_posts 
WHERE ID = 2208 
LIMIT 1
0.3569
SELECT post_id, meta_key, meta_value 
FROM wpfx_postmeta 
WHERE post_id IN (2208) 
ORDER BY meta_id ASC
0.2320
SELECT * 
FROM wpfx_posts 
WHERE ID = 595 
LIMIT 1
0.4568
SELECT post_id, meta_key, meta_value 
FROM wpfx_postmeta 
WHERE post_id IN (595) 
ORDER BY meta_id ASC
0.2151
SELECT * 
FROM wpfx_posts 
WHERE ID = 563 
LIMIT 1
0.5369
SELECT post_id, meta_key, meta_value 
FROM wpfx_postmeta 
WHERE post_id IN (563) 
ORDER BY meta_id ASC
0.3121
SELECT * 
FROM wpfx_posts 
WHERE ID = 564 
LIMIT 1
0.3190
SELECT post_id, meta_key, meta_value 
FROM wpfx_postmeta 
WHERE post_id IN (564) 
ORDER BY meta_id ASC
0.0789
SELECT option_value 
FROM wpfx_options 
WHERE option_name = '_options_global_new_ways_bg_image' 
LIMIT 1
0.0660
SELECT option_value 
FROM wpfx_options 
WHERE option_name = 'options_global_new_ways_bg_image' 
LIMIT 1
0.0691
SELECT * 
FROM wpfx_posts 
WHERE ID = 1072 
LIMIT 1
0.0651
SELECT post_id, meta_key, meta_value 
FROM wpfx_postmeta 
WHERE post_id IN (1072) 
ORDER BY meta_id ASC
0.6959
SELECT SQL_CALC_FOUND_ROWS wpfx_comments.comment_ID 
FROM wpfx_comments 
WHERE ( comment_approved = '1' ) 
AND comment_post_ID = 201 
AND comment_parent = 0 
AND comment_type != 'order_note' 
AND comment_type != 'webhook_delivery' 
ORDER BY wpfx_comments.comment_date_gmt ASC, wpfx_comments.comment_ID ASC
0.0701
SELECT option_value 
FROM wpfx_options 
WHERE option_name = 'woocommerce_review_rating_verification_required' 
LIMIT 1
0.0889
SELECT wpfx_posts.* 
FROM wpfx_posts 
WHERE 1=1 
AND wpfx_posts.post_type = 'acf-field-group' 
AND ((wpfx_posts.post_status = 'publish' OR wpfx_posts.post_status = 'acf-disabled')) 
ORDER BY wpfx_posts.menu_order ASC, wpfx_posts.post_title ASC
0.0741
SELECT option_value 
FROM wpfx_options 
WHERE option_name = 'akismet_comment_nonce' 
LIMIT 1
0.0660
SELECT option_value 
FROM wpfx_options 
WHERE option_name = 'woocommerce_catalog_columns' 
LIMIT 1
0.0770
SELECT t.*, tt.* 
FROM wpfx_terms AS t 
INNER JOIN wpfx_term_taxonomy AS tt ON t.term_id = tt.term_id 
WHERE tt.taxonomy IN ('product_cat') 
ORDER BY t.term_id ASC
0.2999
SELECT term_id, meta_key, meta_value 
FROM wpfx_termmeta 
WHERE term_id IN (17,20,21,32,33,34,35,36) 
ORDER BY meta_id ASC
0.0699
SELECT term_id, meta_key, meta_value 
FROM wpfx_termmeta 
WHERE term_id IN (4) 
ORDER BY meta_id ASC
0.0701
SELECT * 
FROM wpfx_posts 
WHERE ID = 797 
LIMIT 1
0.0641
SELECT post_id, meta_key, meta_value 
FROM wpfx_postmeta 
WHERE post_id IN (797) 
ORDER BY meta_id ASC
0.0699
SELECT * 
FROM wpfx_posts 
WHERE ID = 1303 
LIMIT 1
0.0632
SELECT post_id, meta_key, meta_value 
FROM wpfx_postmeta 
WHERE post_id IN (1303) 
ORDER BY meta_id ASC
0.0830
SELECT * 
FROM wpfx_posts 
WHERE ID = 1295 
LIMIT 1
0.0629
SELECT post_id, meta_key, meta_value 
FROM wpfx_postmeta 
WHERE post_id IN (1295) 
ORDER BY meta_id ASC
0.0710
SELECT option_value 
FROM wpfx_options 
WHERE option_name = '_options_global_new_ways_relation_destiny' 
LIMIT 1
0.0660
SELECT option_value 
FROM wpfx_options 
WHERE option_name = 'options_global_new_ways_relation_destiny' 
LIMIT 1
0.0741
SELECT wpfx_posts.* 
FROM wpfx_posts 
WHERE 1=1 
AND wpfx_posts.ID IN (86) 
AND wpfx_posts.post_type = 'product' 
AND ((wpfx_posts.post_status <> 'trash' 
AND wpfx_posts.post_status <> 'auto-draft')) 
ORDER BY FIELD(wpfx_posts.ID,86)
0.0730
SELECT t.*, tt.* 
FROM wpfx_terms AS t 
INNER JOIN wpfx_term_taxonomy AS tt ON t.term_id = tt.term_id 
INNER JOIN wpfx_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id 
WHERE tt.taxonomy IN ('product_type') 
AND tr.object_id IN (86) 
ORDER BY t.name ASC
0.0651
SELECT term_id, meta_key, meta_value 
FROM wpfx_termmeta 
WHERE term_id IN (6) 
ORDER BY meta_id ASC
0.0789
SELECT post_id, meta_key, meta_value 
FROM wpfx_postmeta 
WHERE post_id IN (86) 
ORDER BY meta_id ASC
0.0751
SELECT t.*, tt.* 
FROM wpfx_terms AS t 
INNER JOIN wpfx_term_taxonomy AS tt ON t.term_id = tt.term_id 
INNER JOIN wpfx_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id 
WHERE tt.taxonomy IN ('product_visibility') 
AND tr.object_id IN (86) 
ORDER BY t.name ASC
0.0629
SELECT term_id, meta_key, meta_value 
FROM wpfx_termmeta 
WHERE term_id IN (16) 
ORDER BY meta_id ASC
0.1891
SELECT DISTINCT t.*, tt.* 
FROM wpfx_terms AS t LEFT JOIN wpfx_termmeta ON ( t.term_id = wpfx_termmeta.term_id 
AND wpfx_termmeta.meta_key='order') 
INNER JOIN wpfx_term_taxonomy AS tt ON t.term_id = tt.term_id 
INNER JOIN wpfx_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id 
WHERE tt.taxonomy IN ('product_cat') 
AND tr.object_id IN (86) 
AND ( ( wpfx_termmeta.meta_key = 'order' OR wpfx_termmeta.meta_key IS NULL ) ) 
ORDER BY wpfx_termmeta.meta_value+0 ASC, t.name ASC
0.0720
SELECT t.*, tt.* 
FROM wpfx_terms AS t 
INNER JOIN wpfx_term_taxonomy AS tt ON t.term_id = tt.term_id 
INNER JOIN wpfx_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id 
WHERE tt.taxonomy IN ('product_tag') 
AND tr.object_id IN (86) 
ORDER BY t.name ASC
0.0689
SELECT t.*, tt.* 
FROM wpfx_terms AS t 
INNER JOIN wpfx_term_taxonomy AS tt ON t.term_id = tt.term_id 
INNER JOIN wpfx_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id 
WHERE tt.taxonomy IN ('product_shipping_class') 
AND tr.object_id IN (86) 
ORDER BY t.name ASC
0.0730
SELECT * 
FROM wpfx_posts 
WHERE ID = 702 
LIMIT 1
0.0670
SELECT post_id, meta_key, meta_value 
FROM wpfx_postmeta 
WHERE post_id IN (702) 
ORDER BY meta_id ASC
0.0720
SELECT option_value 
FROM wpfx_options 
WHERE option_name = '_options_footer_repeater' 
LIMIT 1
0.0629
SELECT option_value 
FROM wpfx_options 
WHERE option_name = 'options_footer_repeater' 
LIMIT 1
0.0582
SELECT option_value 
FROM wpfx_options 
WHERE option_name = 'options_footer_repeater_0_footer_content' 
LIMIT 1
0.0570
SELECT option_value 
FROM wpfx_options 
WHERE option_name = 'options_footer_repeater_1_footer_content' 
LIMIT 1
0.0651
SELECT option_value 
FROM wpfx_options 
WHERE option_name = 'options_footer_repeater_2_footer_content' 
LIMIT 1
0.0741
SELECT * 
FROM wpfx_posts 
WHERE ID = 254 
LIMIT 1
0.0708
SELECT option_value 
FROM wpfx_options 
WHERE option_name = 'woocommerce_demo_store' 
LIMIT 1
Templates
[0] => themes/svhen2/template-parts/sv-functions/mini-cart.php
[1] => themes/svhen2/template-parts/sv-functions/ajax-filter.php
[2] => themes/svhen2/template-parts/sv-functions/pagination.php
[3] => themes/svhen2/woocommerce/single-product.php
[4] => themes/svhen2/header.php
[5] => themes/svhen2/share-template.php
[6] => themes/svhen2/woocommerce/single-product-reviews.php
[7] => themes/svhen2/footer.php
Globals
$_GET = array (
);

$_POST = array (
);

$_COOKIE = array (
);

$_SESSION = array (
);

$_SERVER = array (
  'SERVER_SOFTWARE' => 'LiteSpeed',
  'REQUEST_URI' => '/destino/hato-la-aurora/',
  'PATH' => '/usr/local/bin:/bin:/usr/bin',
  'HTTP_ACCEPT' => 'text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8',
  'HTTP_ACCEPT_ENCODING' => 'br,gzip',
  'HTTP_ACCEPT_LANGUAGE' => 'en-US,en;q=0.5',
  'HTTP_CONNECTION' => 'close',
  'HTTP_HOST' => 'caminantesdelretorno.com',
  'HTTP_USER_AGENT' => 'CCBot/2.0 (https://commoncrawl.org/faq/)',
  'HTTP_IF_MODIFIED_SINCE' => 'Wed, 08 Apr 2020 23:04:56 PDT',
  'HTTP_X_FORWARDED_FOR' => '35.168.112.145, 35.168.112.145',
  'HTTP_X_REAL_IP' => '35.168.112.145',
  'HTTP_X_FORWARDED_PROTO' => 'https',
  'HTTP_X_FORWARDED_SSL' => 'off',
  'HTTP_X_FORWARDED_PORT' => '443',
  'HTTP_BN_CLIENT_PORT' => '55110',
  'DOCUMENT_ROOT' => '/home/retorno/public_html',
  'REMOTE_ADDR' => '35.168.112.145',
  'REMOTE_PORT' => '60955',
  'SERVER_ADDR' => '95.217.33.203',
  'SERVER_NAME' => 'caminantesdelretorno.com',
  'SERVER_ADMIN' => 'webmaster@caminantesdelretorno.com',
  'SERVER_PORT' => '443',
  'REQUEST_SCHEME' => 'https',
  'REDIRECT_URL' => '/destino/hato-la-aurora/',
  'PROXY_REMOTE_ADDR' => '95.217.33.203',
  'HTTPS' => 'on',
  'isproxyrequest' => '1',
  'REDIRECT_STATUS' => '200',
  'noabort' => '1',
  'SSL_PROTOCOL' => 'TLSv1.2',
  'SSL_CIPHER' => 'ECDHE-RSA-AES128-GCM-SHA256',
  'SSL_CIPHER_USEKEYSIZE' => '128',
  'SSL_CIPHER_ALGKEYSIZE' => '128',
  'SCRIPT_FILENAME' => '/home/retorno/public_html/index.php',
  'QUERY_STRING' => '',
  'SCRIPT_URI' => 'https://caminantesdelretorno.com/destino/hato-la-aurora/',
  'SCRIPT_URL' => '/destino/hato-la-aurora/',
  'SCRIPT_NAME' => '/index.php',
  'SERVER_PROTOCOL' => 'HTTP/1.1',
  'REQUEST_METHOD' => 'GET',
  'X-LSCACHE' => 'on',
  'PHP_SELF' => '/index.php',
  'REQUEST_TIME_FLOAT' => 1594646270.4161999225616455078125,
  'REQUEST_TIME' => 1594646270,
);

Close

Escoja la manera de viajar con nosotros