Private tour: half day kayak to Moreno Lake

arrow_back

arrow_forward

New Activity

Private tour: half day kayak to Moreno Lake

Name: Private tour: half day kayak to Moreno Lake
Brand: Dotravel
Price: 310.19 EUR
Availability: InStock

Duration: 4h

Group: Max 10 people

Jun 16, 2026

FROM

€ 310

/pp

About This activity

DoTravel

Meeting Point

Argentina

Our half day kayak program is a four hours tour with two hours of paddling, accompanied by a guide and within a private service to guarantee the experience is up to your expectations and level of exigency of your family or friends!

Our goal is to connect you with nature and with yourself, allowing you to enjoy a unique day in Bariloche and take back home sensations, aromas and emotions that cheers your soul. This program is perfect for families, couples or groups of friends.

Our highly experienced guides adapt perfectly to circumstances and surpass the expectations of our tourists, who always leave wishing to return to Patagonia.

No reviews yet

40 Minutes PRIVATE Helicopter Flight Barcelona Coast & Montserrat

New Activity

schedule 1h

40 Minutes PRIVATE Helicopter Flight Barcelona Coast & Montserrat

Enjoy this amazing and memorable experience of flying through the city of Barcelona and...

Next available: Feb 08, 2026

activity BOOK IT

FROM

€ 1659

/pp

schedule 3h

Bike Tour: Gaudi Highlights with Sagrada Familia Admission

We designed the Sagrada Família tour for those who have a special interest in Gaudí's...

Next available: Feb 14, 2026

tour BOOK IT

FROM

€ 69

/pp

Novurania Motor Yacht - Speed Boat in Barcelona 3h

New Activity

schedule 1h

Novurania Motor Yacht - Speed Boat in Barcelona 3h

A world-class yacht tender and a high-performance offshore sport boat. Experience the...

Next available: Feb 07, 2026

activity BOOK IT

FROM

€ 639

/pp

  DB
  81 queries
  |
  1522.73 ms

    Query Log (81 queries, 1522.73 ms)
    ×
  

    
    
  
Loading...

          
        #TimeQuery

            1
            2.17 ms
            SELECT url, namespace, method, content_redirection FROM `redirect` WHERE status = 1
          

            2
            7.05 ms
            INSERT INTO `log_customer` ( `id` , `id_customer` , `log` , `date` ) VALUES( NULL , NULL ,...
          

            3
            0.47 ms
            SELECT * FROM `languages` WHERE TRUE AND `short` = 'en'
          

            4
            0.63 ms
            SELECT * FROM `languages` WHERE TRUE AND `name` = 'English'
          

            5
            246.25 ms
            SELECT * FROM `product_meta` WHERE TRUE AND `id_language` = 1 AND `metaname` = 'redirect_from_id' AND `metavalue` = '4786' ORDER BY `id` DESC LIMIT 0 , 30
          

            6
            0.65 ms
            SELECT * FROM `products` p WHERE TRUE AND p.`id` = 4786 ORDER BY `id` DESC
          

            7
            0.41 ms
            SELECT * FROM `type` WHERE TRUE AND `id` = 2 ORDER BY `id` DESC LIMIT 0 , 30
          

            8
            0.47 ms
            SELECT * FROM `type` WHERE TRUE AND `group` = 'products_product_type' AND `name` = 'activity' ORDER BY `id` DESC LIMIT 0 , 30
          

            9
            0.46 ms
            SELECT * FROM `sub_product` WHERE TRUE AND `id_product` = 4786 ORDER BY `id_language` DESC LIMIT 0 , 30
          

            10
            0.33 ms
            SELECT * FROM `languages` WHERE TRUE AND `id` = 1
          

            11
            0.42 ms
            SELECT * FROM `type` WHERE TRUE AND `id` = 4 ORDER BY `id` DESC LIMIT 0 , 30
          

            12
            0.43 ms
            SELECT *, CONCAT(UCASE(LEFT(name, 1)), LCASE(SUBSTRING(REPLACE(name,'_',' '), 2))) as title FROM `status` WHERE TRUE AND `name` = 'published' AND `group` = 'products_status' ORDER BY `id` DESC LIMIT 0 , 30
          

            13
            0.3 ms
            SELECT * FROM `products` p WHERE TRUE AND p.`id` = 4786 AND p.`status` = '23' ORDER BY `id` DESC
          

            14
            0.27 ms
            SELECT * FROM `suppliers` s WHERE TRUE AND s.`id` = 36 ORDER BY `id` DESC
          

            15
            0.31 ms
            SELECT *, CONCAT(UCASE(LEFT(name, 1)), LCASE(SUBSTRING(REPLACE(name,'_',' '), 2))) as title FROM `status` WHERE TRUE AND `id` = '10' ORDER BY `id` DESC LIMIT 0 , 30
          

            16
            0.51 ms
            SELECT SUM(rating_valueformoney) as rating_valueformoney, SUM(rating_convenience) as rating_convenience, SUM(rating_accessibility) as rating_accessibility, SUM(rating_overall) as rating_overall, AVG(rating_overall) as rating_overall_avg, COUNT(*) as review_count FROM `reviews` WHERE status IN...
          

            17
            0.56 ms
            SELECT * FROM `reviews` WHERE status in (select id from status s where s.name = 'active' and s.group = 'review_status') and title not like '' AND `id_product` = 4786 ORDER BY `rating_overall` desc LIMIT 20 , 30
          

            18
            0.4 ms
            SELECT *, CONCAT(UCASE(LEFT(name, 1)), LCASE(SUBSTRING(REPLACE(name,'_',' '), 2))) as title FROM `status` WHERE TRUE AND `id` = '9' ORDER BY `id` DESC LIMIT 0 , 30
          

            19
            0.5 ms
            SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 4786 AND `id_language` = 1 ORDER BY `id` DESC LIMIT 0 , 1000
          

            20
            0.48 ms
            SELECT * FROM `product_system_meta` WHERE TRUE AND `id_product` = 4786 AND `metaname` = 'bookingextranote' ORDER BY `id` DESC LIMIT 0 , 30
          

            21
            0.42 ms
            SELECT pr.price as min FROM `product_prices` as pr INNER JOIN `sub_product` AS s ON s.id = pr.id_subproduct INNER JOIN `age_group` AS a ON a.id = pr.id_agegroup -- WHERE a.show_order = 1 AND s.`id_product` = 4786 ORDER BY s.`id_language` ASC
          

            22
            0.34 ms
            SELECT * FROM `product_system` WHERE TRUE AND `id_product_dotravel` = 4786 ORDER BY `id` DESC
          

            23
            0.61 ms
            SELECT *, CONCAT(UCASE(LEFT(name, 1)), LCASE(SUBSTRING(REPLACE(name,'_',' '), 2))) as title FROM `status` WHERE TRUE AND `name` = 'active' AND `group` = 'sub_product_status' ORDER BY `id` DESC LIMIT 0 , 30
          

            24
            0.49 ms
            SELECT * FROM `sub_product` WHERE TRUE AND `id_product` = 4786 AND `status` = '15' ORDER BY `id` DESC LIMIT 0 , 30
          

            25
            0.4 ms
            SELECT * FROM `product_photos` WHERE TRUE AND `id_product` = 4786 ORDER BY `show_order` asc LIMIT 0 , 30
          

            26
            0.38 ms
            SELECT * FROM `seo` WHERE TRUE AND `id_product` = 4786 AND `id_language` = 1 ORDER BY `id` DESC LIMIT 0 , 30
          

            27
            0.34 ms
            SELECT * FROM `sub_product` WHERE TRUE AND `id_product` = 4786 ORDER BY `id` DESC LIMIT 0 , 30
          

            28
            0.32 ms
            SELECT * FROM `product_prices` WHERE TRUE AND `id_subproduct` = 3812 ORDER BY `id` DESC LIMIT 0 , 30
          

            29
            0.32 ms
            SELECT * FROM `age_group` WHERE TRUE AND `id` = 1 ORDER BY `id` DESC LIMIT 0 , 30
          

            30
            0.28 ms
            SELECT * FROM `product_bookingfees` WHERE TRUE AND `id_productprice` = 10076 ORDER BY `id` DESC LIMIT 0 , 30
          

            31
            0.32 ms
            SELECT * FROM `type` WHERE TRUE AND `group` = 'sub_product_type' AND `name` = 'group' ORDER BY `id` DESC LIMIT 0 , 30
          

            32
            0.38 ms
            SELECT * FROM `sub_product` WHERE TRUE AND `id_product` = 4786 AND `type` = 4 ORDER BY `id_language` ASC LIMIT 0 , 30
          

            33
            0.33 ms
            SELECT * FROM `product_advantage` WHERE TRUE AND `id_product` = 4786 ORDER BY `id` DESC LIMIT 0 , 30
          

            34
            0.39 ms
            SELECT short_description, image_name,image_path, id_language, name FROM `label_products` LEFT JOIN labels lb on lb.id = id_label LEFT JOIN labels_meta lm on lm.id_label = label_products.id_label where id_product ='4786'
          

            35
            0.3 ms
            SELECT * FROM `favorites` WHERE TRUE AND `id_product` = 4786 ORDER BY `id` DESC LIMIT 0 , 30
          

            36
            0.38 ms
            SELECT *, CONCAT(UCASE(LEFT(name, 1)), LCASE(SUBSTRING(REPLACE(name,'_',' '), 2))) as title FROM `status` WHERE TRUE AND `name` = 'disabled' AND `group` = 'favorites_status' ORDER BY `id` DESC LIMIT 0 , 30
          

            37
            0.53 ms
            SELECT pc.id_category as id, cm.name as name, cm.seo_url as seo_url ,(SELECT img_name FROM categories where id = pc.id_category) as img FROM `product_category` AS pc INNER JOIN `category_meta` AS cm ON pc.id_category = cm.id_category WHERE TRUE AND pc.`id_product` = 4786 AND cm.`id_language` = 1...
          

            38
            0.35 ms
            SELECT * FROM `product_photos` WHERE TRUE AND `id_product` = 4786 ORDER BY `show_order` ASC LIMIT 0 , 30
          

            39
            0.32 ms
            SELECT * FROM `destination_parent` WHERE TRUE AND `id_child` = 7 ORDER BY `id` DESC LIMIT 0 , 30
          

            40
            0.46 ms
            SELECT destinations.id, destination_meta.name,seo_url FROM `destinations` join destination_meta on destination_meta.id_destination = destinations.id join destination_parent on destination_parent.id_parent = destinations.id where true AND destinations.status = 24 AND destination_meta.id_language =...
          

            41
            0.3 ms
            SELECT * FROM `destination_parent` WHERE TRUE AND `id_child` = 3 ORDER BY `id` DESC LIMIT 0 , 30
          

            42
            0.5 ms
            SELECT destinations.id, destination_meta.name,seo_url FROM `destinations` join destination_meta on destination_meta.id_destination = destinations.id join destination_parent on destination_parent.id_parent = destinations.id where true AND destinations.status = 24 AND destination_meta.id_language =...
          

            43
            0.37 ms
            SELECT * FROM `destination_parent` WHERE TRUE AND `id_child` = 1 ORDER BY `id` DESC LIMIT 0 , 30
          

            44
            0.56 ms
            SELECT p.* FROM `related_product` rp inner join products p on rp.id_related = p.id inner join suppliers s on p.id_supplier = s.id WHERE TRUE AND `id_product` = 4786 AND p.`status` = 23 AND s.`status` = 10 ORDER BY `id` DESC LIMIT 0 , 3
          

            45
            20.35 ms
            SELECT p.* FROM `products` p JOIN `suppliers` s ON p.id_supplier = s.id JOIN `status` st ON s.status = st.id WHERE p.`status` = 23 AND p.id not in ( 4786 ) AND st.name = 'active' AND st.group = 'suppliers_status' AND p.id IN ( SELECT id_product FROM `product_destination` WHERE id_destination IN...
          

            46
            1.43 ms
            SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 4590 AND `id_language` = 1 AND `metaname` = 'title' ORDER BY `id` DESC LIMIT 0 , 30
          

            47
            0.85 ms
            SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 4590 AND `id_language` = 1 AND `metaname` = 'summary' ORDER BY `id` DESC LIMIT 0 , 30
          

            48
            0.69 ms
            SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 4590 AND `id_language` = 1 AND `metaname` = 'typeHour' ORDER BY `id` DESC LIMIT 0 , 30
          

            49
            0.54 ms
            SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 4590 AND `id_language` = 1 AND `metaname` = 'currency' ORDER BY `id` DESC LIMIT 0 , 30
          

            50
            0.49 ms
            SELECT * FROM `seo` WHERE TRUE AND `id_product` = 4590 AND `id_language` = 1 ORDER BY `id` DESC LIMIT 0 , 30
          

            51
            0.52 ms
            SELECT * FROM `product_photos` WHERE TRUE AND `id_product` = 4590 ORDER BY `id` DESC LIMIT 0 , 30
          

            52
            0.54 ms
            SELECT pr.price as min FROM `product_prices` as pr INNER JOIN `sub_product` AS s ON s.id = pr.id_subproduct INNER JOIN `age_group` AS a ON a.id = pr.id_agegroup -- WHERE a.show_order = 1 AND s.`id_product` = 4590 ORDER BY s.`id_language` ASC
          

            53
            0.82 ms
            SELECT * FROM `sub_product` WHERE TRUE AND `id_product` = 4590 AND `type` = 4 ORDER BY `id_language` ASC LIMIT 0 , 30
          

            54
            0.67 ms
            SELECT SUM(rating_valueformoney) as rating_valueformoney, SUM(rating_convenience) as rating_convenience, SUM(rating_accessibility) as rating_accessibility, SUM(rating_overall) as rating_overall, AVG(rating_overall) as rating_overall_avg, COUNT(*) as review_count FROM `reviews` WHERE status IN...
          

            55
            0.68 ms
            SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 2672 AND `id_language` = 1 AND `metaname` = 'title' ORDER BY `id` DESC LIMIT 0 , 30
          

            56
            0.68 ms
            SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 2672 AND `id_language` = 1 AND `metaname` = 'summary' ORDER BY `id` DESC LIMIT 0 , 30
          

            57
            0.74 ms
            SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 2672 AND `id_language` = 1 AND `metaname` = 'typeHour' ORDER BY `id` DESC LIMIT 0 , 30
          

            58
            0.72 ms
            SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 2672 AND `id_language` = 1 AND `metaname` = 'currency' ORDER BY `id` DESC LIMIT 0 , 30
          

            59
            0.45 ms
            SELECT * FROM `seo` WHERE TRUE AND `id_product` = 2672 AND `id_language` = 1 ORDER BY `id` DESC LIMIT 0 , 30
          

            60
            0.36 ms
            SELECT * FROM `type` WHERE TRUE AND `id` = 3 ORDER BY `id` DESC LIMIT 0 , 30
          

            61
            0.44 ms
            SELECT * FROM `product_photos` WHERE TRUE AND `id_product` = 2672 ORDER BY `id` DESC LIMIT 0 , 30
          

            62
            0.54 ms
            SELECT pr.price as min FROM `product_prices` as pr INNER JOIN `sub_product` AS s ON s.id = pr.id_subproduct INNER JOIN `age_group` AS a ON a.id = pr.id_agegroup -- WHERE a.show_order = 1 AND s.`id_product` = 2672 ORDER BY s.`id_language` ASC
          

            63
            0.98 ms
            SELECT * FROM `sub_product` WHERE TRUE AND `id_product` = 2672 AND `type` = 4 ORDER BY `id_language` ASC LIMIT 0 , 30
          

            64
            0.85 ms
            SELECT SUM(rating_valueformoney) as rating_valueformoney, SUM(rating_convenience) as rating_convenience, SUM(rating_accessibility) as rating_accessibility, SUM(rating_overall) as rating_overall, AVG(rating_overall) as rating_overall_avg, COUNT(*) as review_count FROM `reviews` WHERE status IN...
          

            65
            1.11 ms
            SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 4582 AND `id_language` = 1 AND `metaname` = 'title' ORDER BY `id` DESC LIMIT 0 , 30
          

            66
            0.64 ms
            SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 4582 AND `id_language` = 1 AND `metaname` = 'summary' ORDER BY `id` DESC LIMIT 0 , 30
          

            67
            0.59 ms
            SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 4582 AND `id_language` = 1 AND `metaname` = 'typeHour' ORDER BY `id` DESC LIMIT 0 , 30
          

            68
            0.51 ms
            SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 4582 AND `id_language` = 1 AND `metaname` = 'currency' ORDER BY `id` DESC LIMIT 0 , 30
          

            69
            0.47 ms
            SELECT * FROM `seo` WHERE TRUE AND `id_product` = 4582 AND `id_language` = 1 ORDER BY `id` DESC LIMIT 0 , 30
          

            70
            0.48 ms
            SELECT * FROM `product_photos` WHERE TRUE AND `id_product` = 4582 ORDER BY `id` DESC LIMIT 0 , 30
          

            71
            0.5 ms
            SELECT pr.price as min FROM `product_prices` as pr INNER JOIN `sub_product` AS s ON s.id = pr.id_subproduct INNER JOIN `age_group` AS a ON a.id = pr.id_agegroup -- WHERE a.show_order = 1 AND s.`id_product` = 4582 ORDER BY s.`id_language` ASC
          

            72
            0.99 ms
            SELECT * FROM `sub_product` WHERE TRUE AND `id_product` = 4582 AND `type` = 4 ORDER BY `id_language` ASC LIMIT 0 , 30
          

            73
            0.7 ms
            SELECT SUM(rating_valueformoney) as rating_valueformoney, SUM(rating_convenience) as rating_convenience, SUM(rating_accessibility) as rating_accessibility, SUM(rating_overall) as rating_overall, AVG(rating_overall) as rating_overall_avg, COUNT(*) as review_count FROM `reviews` WHERE status IN...
          

            74
            1.03 ms
            SELECT id_product, metavalue FROM `product_meta` WHERE id_product IN (?,?,?) AND metaname = ? AND id_language = ?
          

            75
            0.49 ms
            SELECT * FROM `type` WHERE TRUE AND `group` = 'subproduct_blockeddates_block_type' ORDER BY `id` DESC LIMIT 0 , 30
          

            76
            0.51 ms
            SELECT * FROM `subproduct_blockeddates` WHERE TRUE AND `id_subproduct` = 3812 ORDER BY `date` ASC LIMIT 0 , 30
          

            77
            0.58 ms
            SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 4786 AND `id_language` = 1 AND `metaname` = 'availability_next_date' ORDER BY `id` DESC LIMIT 0 , 30
          

            78
            1203.77 ms
            SELECT * FROM `customer_productlog` WHERE TRUE
          

            79
            3.35 ms
            INSERT INTO `customer_productlog` ( `id` , `content` ) VALUES( NULL , '{\"id_product\":\"4786\",\"id_user\":\"NULL\",\"dateVisited\":1785177323}' )
          

            80
            0.63 ms
            SELECT * FROM `suppliers` s WHERE TRUE AND s.`id` = 36 ORDER BY `id` DESC
          

            81
            0.58 ms
            SELECT * FROM `supplier_meta` WHERE TRUE AND `id_supplier` = 36 ORDER BY `id` DESC LIMIT 0 , 1000
          

      

#	Time	Query
1	2.17 ms	SELECT url, namespace, method, content_redirection FROM `redirect` WHERE status = 1
2	7.05 ms	INSERT INTO `log_customer` ( `id` , `id_customer` , `log` , `date` ) VALUES( NULL , NULL ,...
3	0.47 ms	SELECT * FROM `languages` WHERE TRUE AND `short` = 'en'
4	0.63 ms	SELECT * FROM `languages` WHERE TRUE AND `name` = 'English'
5	246.25 ms	SELECT * FROM `product_meta` WHERE TRUE AND `id_language` = 1 AND `metaname` = 'redirect_from_id' AND `metavalue` = '4786' ORDER BY `id` DESC LIMIT 0 , 30
6	0.65 ms	SELECT * FROM `products` p WHERE TRUE AND p.`id` = 4786 ORDER BY `id` DESC
7	0.41 ms	SELECT * FROM `type` WHERE TRUE AND `id` = 2 ORDER BY `id` DESC LIMIT 0 , 30
8	0.47 ms	SELECT * FROM `type` WHERE TRUE AND `group` = 'products_product_type' AND `name` = 'activity' ORDER BY `id` DESC LIMIT 0 , 30
9	0.46 ms	SELECT * FROM `sub_product` WHERE TRUE AND `id_product` = 4786 ORDER BY `id_language` DESC LIMIT 0 , 30
10	0.33 ms	SELECT * FROM `languages` WHERE TRUE AND `id` = 1
11	0.42 ms	SELECT * FROM `type` WHERE TRUE AND `id` = 4 ORDER BY `id` DESC LIMIT 0 , 30
12	0.43 ms	SELECT *, CONCAT(UCASE(LEFT(name, 1)), LCASE(SUBSTRING(REPLACE(name,'_',' '), 2))) as title FROM `status` WHERE TRUE AND `name` = 'published' AND `group` = 'products_status' ORDER BY `id` DESC LIMIT 0 , 30
13	0.3 ms	SELECT * FROM `products` p WHERE TRUE AND p.`id` = 4786 AND p.`status` = '23' ORDER BY `id` DESC
14	0.27 ms	SELECT * FROM `suppliers` s WHERE TRUE AND s.`id` = 36 ORDER BY `id` DESC
15	0.31 ms	SELECT *, CONCAT(UCASE(LEFT(name, 1)), LCASE(SUBSTRING(REPLACE(name,'_',' '), 2))) as title FROM `status` WHERE TRUE AND `id` = '10' ORDER BY `id` DESC LIMIT 0 , 30
16	0.51 ms	SELECT SUM(rating_valueformoney) as rating_valueformoney, SUM(rating_convenience) as rating_convenience, SUM(rating_accessibility) as rating_accessibility, SUM(rating_overall) as rating_overall, AVG(rating_overall) as rating_overall_avg, COUNT(*) as review_count FROM `reviews` WHERE status IN...
17	0.56 ms	SELECT * FROM `reviews` WHERE status in (select id from status s where s.name = 'active' and s.group = 'review_status') and title not like '' AND `id_product` = 4786 ORDER BY `rating_overall` desc LIMIT 20 , 30
18	0.4 ms	SELECT *, CONCAT(UCASE(LEFT(name, 1)), LCASE(SUBSTRING(REPLACE(name,'_',' '), 2))) as title FROM `status` WHERE TRUE AND `id` = '9' ORDER BY `id` DESC LIMIT 0 , 30
19	0.5 ms	SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 4786 AND `id_language` = 1 ORDER BY `id` DESC LIMIT 0 , 1000
20	0.48 ms	SELECT * FROM `product_system_meta` WHERE TRUE AND `id_product` = 4786 AND `metaname` = 'bookingextranote' ORDER BY `id` DESC LIMIT 0 , 30
21	0.42 ms	SELECT pr.price as min FROM `product_prices` as pr INNER JOIN `sub_product` AS s ON s.id = pr.id_subproduct INNER JOIN `age_group` AS a ON a.id = pr.id_agegroup -- WHERE a.show_order = 1 AND s.`id_product` = 4786 ORDER BY s.`id_language` ASC
22	0.34 ms	SELECT * FROM `product_system` WHERE TRUE AND `id_product_dotravel` = 4786 ORDER BY `id` DESC
23	0.61 ms	SELECT *, CONCAT(UCASE(LEFT(name, 1)), LCASE(SUBSTRING(REPLACE(name,'_',' '), 2))) as title FROM `status` WHERE TRUE AND `name` = 'active' AND `group` = 'sub_product_status' ORDER BY `id` DESC LIMIT 0 , 30
24	0.49 ms	SELECT * FROM `sub_product` WHERE TRUE AND `id_product` = 4786 AND `status` = '15' ORDER BY `id` DESC LIMIT 0 , 30
25	0.4 ms	SELECT * FROM `product_photos` WHERE TRUE AND `id_product` = 4786 ORDER BY `show_order` asc LIMIT 0 , 30
26	0.38 ms	SELECT * FROM `seo` WHERE TRUE AND `id_product` = 4786 AND `id_language` = 1 ORDER BY `id` DESC LIMIT 0 , 30
27	0.34 ms	SELECT * FROM `sub_product` WHERE TRUE AND `id_product` = 4786 ORDER BY `id` DESC LIMIT 0 , 30
28	0.32 ms	SELECT * FROM `product_prices` WHERE TRUE AND `id_subproduct` = 3812 ORDER BY `id` DESC LIMIT 0 , 30
29	0.32 ms	SELECT * FROM `age_group` WHERE TRUE AND `id` = 1 ORDER BY `id` DESC LIMIT 0 , 30
30	0.28 ms	SELECT * FROM `product_bookingfees` WHERE TRUE AND `id_productprice` = 10076 ORDER BY `id` DESC LIMIT 0 , 30
31	0.32 ms	SELECT * FROM `type` WHERE TRUE AND `group` = 'sub_product_type' AND `name` = 'group' ORDER BY `id` DESC LIMIT 0 , 30
32	0.38 ms	SELECT * FROM `sub_product` WHERE TRUE AND `id_product` = 4786 AND `type` = 4 ORDER BY `id_language` ASC LIMIT 0 , 30
33	0.33 ms	SELECT * FROM `product_advantage` WHERE TRUE AND `id_product` = 4786 ORDER BY `id` DESC LIMIT 0 , 30
34	0.39 ms	SELECT short_description, image_name,image_path, id_language, name FROM `label_products` LEFT JOIN labels lb on lb.id = id_label LEFT JOIN labels_meta lm on lm.id_label = label_products.id_label where id_product ='4786'
35	0.3 ms	SELECT * FROM `favorites` WHERE TRUE AND `id_product` = 4786 ORDER BY `id` DESC LIMIT 0 , 30
36	0.38 ms	SELECT *, CONCAT(UCASE(LEFT(name, 1)), LCASE(SUBSTRING(REPLACE(name,'_',' '), 2))) as title FROM `status` WHERE TRUE AND `name` = 'disabled' AND `group` = 'favorites_status' ORDER BY `id` DESC LIMIT 0 , 30
37	0.53 ms	SELECT pc.id_category as id, cm.name as name, cm.seo_url as seo_url ,(SELECT img_name FROM categories where id = pc.id_category) as img FROM `product_category` AS pc INNER JOIN `category_meta` AS cm ON pc.id_category = cm.id_category WHERE TRUE AND pc.`id_product` = 4786 AND cm.`id_language` = 1...
38	0.35 ms	SELECT * FROM `product_photos` WHERE TRUE AND `id_product` = 4786 ORDER BY `show_order` ASC LIMIT 0 , 30
39	0.32 ms	SELECT * FROM `destination_parent` WHERE TRUE AND `id_child` = 7 ORDER BY `id` DESC LIMIT 0 , 30
40	0.46 ms	SELECT destinations.id, destination_meta.name,seo_url FROM `destinations` join destination_meta on destination_meta.id_destination = destinations.id join destination_parent on destination_parent.id_parent = destinations.id where true AND destinations.status = 24 AND destination_meta.id_language =...
41	0.3 ms	SELECT * FROM `destination_parent` WHERE TRUE AND `id_child` = 3 ORDER BY `id` DESC LIMIT 0 , 30
42	0.5 ms	SELECT destinations.id, destination_meta.name,seo_url FROM `destinations` join destination_meta on destination_meta.id_destination = destinations.id join destination_parent on destination_parent.id_parent = destinations.id where true AND destinations.status = 24 AND destination_meta.id_language =...
43	0.37 ms	SELECT * FROM `destination_parent` WHERE TRUE AND `id_child` = 1 ORDER BY `id` DESC LIMIT 0 , 30
44	0.56 ms	SELECT p.* FROM `related_product` rp inner join products p on rp.id_related = p.id inner join suppliers s on p.id_supplier = s.id WHERE TRUE AND `id_product` = 4786 AND p.`status` = 23 AND s.`status` = 10 ORDER BY `id` DESC LIMIT 0 , 3
45	20.35 ms	SELECT p.* FROM `products` p JOIN `suppliers` s ON p.id_supplier = s.id JOIN `status` st ON s.status = st.id WHERE p.`status` = 23 AND p.id not in ( 4786 ) AND st.name = 'active' AND st.group = 'suppliers_status' AND p.id IN ( SELECT id_product FROM `product_destination` WHERE id_destination IN...
46	1.43 ms	SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 4590 AND `id_language` = 1 AND `metaname` = 'title' ORDER BY `id` DESC LIMIT 0 , 30
47	0.85 ms	SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 4590 AND `id_language` = 1 AND `metaname` = 'summary' ORDER BY `id` DESC LIMIT 0 , 30
48	0.69 ms	SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 4590 AND `id_language` = 1 AND `metaname` = 'typeHour' ORDER BY `id` DESC LIMIT 0 , 30
49	0.54 ms	SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 4590 AND `id_language` = 1 AND `metaname` = 'currency' ORDER BY `id` DESC LIMIT 0 , 30
50	0.49 ms	SELECT * FROM `seo` WHERE TRUE AND `id_product` = 4590 AND `id_language` = 1 ORDER BY `id` DESC LIMIT 0 , 30
51	0.52 ms	SELECT * FROM `product_photos` WHERE TRUE AND `id_product` = 4590 ORDER BY `id` DESC LIMIT 0 , 30
52	0.54 ms	SELECT pr.price as min FROM `product_prices` as pr INNER JOIN `sub_product` AS s ON s.id = pr.id_subproduct INNER JOIN `age_group` AS a ON a.id = pr.id_agegroup -- WHERE a.show_order = 1 AND s.`id_product` = 4590 ORDER BY s.`id_language` ASC
53	0.82 ms	SELECT * FROM `sub_product` WHERE TRUE AND `id_product` = 4590 AND `type` = 4 ORDER BY `id_language` ASC LIMIT 0 , 30
54	0.67 ms	SELECT SUM(rating_valueformoney) as rating_valueformoney, SUM(rating_convenience) as rating_convenience, SUM(rating_accessibility) as rating_accessibility, SUM(rating_overall) as rating_overall, AVG(rating_overall) as rating_overall_avg, COUNT(*) as review_count FROM `reviews` WHERE status IN...
55	0.68 ms	SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 2672 AND `id_language` = 1 AND `metaname` = 'title' ORDER BY `id` DESC LIMIT 0 , 30
56	0.68 ms	SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 2672 AND `id_language` = 1 AND `metaname` = 'summary' ORDER BY `id` DESC LIMIT 0 , 30
57	0.74 ms	SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 2672 AND `id_language` = 1 AND `metaname` = 'typeHour' ORDER BY `id` DESC LIMIT 0 , 30
58	0.72 ms	SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 2672 AND `id_language` = 1 AND `metaname` = 'currency' ORDER BY `id` DESC LIMIT 0 , 30
59	0.45 ms	SELECT * FROM `seo` WHERE TRUE AND `id_product` = 2672 AND `id_language` = 1 ORDER BY `id` DESC LIMIT 0 , 30
60	0.36 ms	SELECT * FROM `type` WHERE TRUE AND `id` = 3 ORDER BY `id` DESC LIMIT 0 , 30
61	0.44 ms	SELECT * FROM `product_photos` WHERE TRUE AND `id_product` = 2672 ORDER BY `id` DESC LIMIT 0 , 30
62	0.54 ms	SELECT pr.price as min FROM `product_prices` as pr INNER JOIN `sub_product` AS s ON s.id = pr.id_subproduct INNER JOIN `age_group` AS a ON a.id = pr.id_agegroup -- WHERE a.show_order = 1 AND s.`id_product` = 2672 ORDER BY s.`id_language` ASC
63	0.98 ms	SELECT * FROM `sub_product` WHERE TRUE AND `id_product` = 2672 AND `type` = 4 ORDER BY `id_language` ASC LIMIT 0 , 30
64	0.85 ms	SELECT SUM(rating_valueformoney) as rating_valueformoney, SUM(rating_convenience) as rating_convenience, SUM(rating_accessibility) as rating_accessibility, SUM(rating_overall) as rating_overall, AVG(rating_overall) as rating_overall_avg, COUNT(*) as review_count FROM `reviews` WHERE status IN...
65	1.11 ms	SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 4582 AND `id_language` = 1 AND `metaname` = 'title' ORDER BY `id` DESC LIMIT 0 , 30
66	0.64 ms	SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 4582 AND `id_language` = 1 AND `metaname` = 'summary' ORDER BY `id` DESC LIMIT 0 , 30
67	0.59 ms	SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 4582 AND `id_language` = 1 AND `metaname` = 'typeHour' ORDER BY `id` DESC LIMIT 0 , 30
68	0.51 ms	SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 4582 AND `id_language` = 1 AND `metaname` = 'currency' ORDER BY `id` DESC LIMIT 0 , 30
69	0.47 ms	SELECT * FROM `seo` WHERE TRUE AND `id_product` = 4582 AND `id_language` = 1 ORDER BY `id` DESC LIMIT 0 , 30
70	0.48 ms	SELECT * FROM `product_photos` WHERE TRUE AND `id_product` = 4582 ORDER BY `id` DESC LIMIT 0 , 30
71	0.5 ms	SELECT pr.price as min FROM `product_prices` as pr INNER JOIN `sub_product` AS s ON s.id = pr.id_subproduct INNER JOIN `age_group` AS a ON a.id = pr.id_agegroup -- WHERE a.show_order = 1 AND s.`id_product` = 4582 ORDER BY s.`id_language` ASC
72	0.99 ms	SELECT * FROM `sub_product` WHERE TRUE AND `id_product` = 4582 AND `type` = 4 ORDER BY `id_language` ASC LIMIT 0 , 30
73	0.7 ms	SELECT SUM(rating_valueformoney) as rating_valueformoney, SUM(rating_convenience) as rating_convenience, SUM(rating_accessibility) as rating_accessibility, SUM(rating_overall) as rating_overall, AVG(rating_overall) as rating_overall_avg, COUNT(*) as review_count FROM `reviews` WHERE status IN...
74	1.03 ms	SELECT id_product, metavalue FROM `product_meta` WHERE id_product IN (?,?,?) AND metaname = ? AND id_language = ?
75	0.49 ms	SELECT * FROM `type` WHERE TRUE AND `group` = 'subproduct_blockeddates_block_type' ORDER BY `id` DESC LIMIT 0 , 30
76	0.51 ms	SELECT * FROM `subproduct_blockeddates` WHERE TRUE AND `id_subproduct` = 3812 ORDER BY `date` ASC LIMIT 0 , 30
77	0.58 ms	SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 4786 AND `id_language` = 1 AND `metaname` = 'availability_next_date' ORDER BY `id` DESC LIMIT 0 , 30
78	1203.77 ms	SELECT * FROM `customer_productlog` WHERE TRUE
79	3.35 ms	INSERT INTO `customer_productlog` ( `id` , `content` ) VALUES( NULL , '{\"id_product\":\"4786\",\"id_user\":\"NULL\",\"dateVisited\":1785177323}' )
80	0.63 ms	SELECT * FROM `suppliers` s WHERE TRUE AND s.`id` = 36 ORDER BY `id` DESC
81	0.58 ms	SELECT * FROM `supplier_meta` WHERE TRUE AND `id_supplier` = 36 ORDER BY `id` DESC LIMIT 0 , 1000

Private tour: half day kayak to Moreno Lake