arrow_back

arrow_forward

New Activity

Midnight Sun Tour

Name: Midnight Sun Tour
Brand: Dotravel
Price: 97.27 EUR
Availability: InStock

Duration: 2h 30m

Group: Max 10 people

Jul 21, 2026

FROM

€ 97

/pp

About This activity

DoTravel

Meeting Point

Iceland

During the summer months we have nearly 24 hours of daylight, which allows us to operate the fantastic Midnight Sun whale watching tour. There's something extra-special about seeing whales in the evening, surrounded by the glow from an evening sun reflecting off the waters of Faxaflói Bay. You set sail at 21:00 and head back just before midnight, giving you plenty of time to search for whales with one of our expert guides. The most common species we see on our tours are humpback whales, minke whales, white-beaked dolphins and harbour porpoises.

No reviews yet

New Activity

schedule 8h

Arrábida Snorkeling & Wine

Next available: May 19, 2026

activity BOOK IT

FROM

€ 122

/pp

Rojo Tango Show with private transfers in Buenos Aires

New Activity

schedule 4h

Rojo Tango Show with private transfers in Buenos Aires

Next available: May 18, 2026

activity BOOK IT

FROM

€ 282

/pp

Golden Circle & Secret Lagoon Small Group Tour

New Activity

schedule 9h

Golden Circle & Secret Lagoon Small Group Tour

Explore Iceland’s Golden Circle on a small group tour from Reykjavik, visiting...

Next available: Feb 07, 2026

activity BOOK IT

FROM

€ 129

/pp

  DB
  78 queries
  |
  1285.11 ms

    Query Log (78 queries, 1285.11 ms)
    ×
  

    
    
  
Loading...

          
        #TimeQuery

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

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

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

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

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

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

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

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

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

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

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

            12
            0.42 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.32 ms
            SELECT * FROM `products` p WHERE TRUE AND p.`id` = 4757 AND p.`status` = '23' ORDER BY `id` DESC
          

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

            15
            0.27 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.4 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.38 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` = 4757 ORDER BY `rating_overall` desc LIMIT 20 , 30
          

            18
            0.24 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.39 ms
            SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 4757 AND `id_language` = 1 ORDER BY `id` DESC LIMIT 0 , 1000
          

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

            21
            0.4 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` = 4757 ORDER BY s.`id_language` ASC
          

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

            23
            0.46 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.38 ms
            SELECT * FROM `sub_product` WHERE TRUE AND `id_product` = 4757 AND `status` = '15' ORDER BY `id` DESC LIMIT 0 , 30
          

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

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

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

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

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

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

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

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

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

            34
            0.37 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 ='4757'
          

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

            36
            0.39 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.5 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` = 4757 AND cm.`id_language` = 1...
          

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

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

            40
            0.39 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.28 ms
            SELECT * FROM `destination_parent` WHERE TRUE AND `id_child` = 101 ORDER BY `id` DESC LIMIT 0 , 30
          

            42
            0.49 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` = 4757 AND p.`status` = 23 AND s.`status` = 10 ORDER BY `id` DESC LIMIT 0 , 3
          

            43
            14.43 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 ( 4757 ) AND st.name = 'active' AND st.group = 'suppliers_status' AND p.id IN ( SELECT id_product FROM `product_destination` WHERE id_destination IN...
          

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

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

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

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

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

            49
            0.46 ms
            SELECT * FROM `product_photos` WHERE TRUE AND `id_product` = 4783 ORDER BY `id` DESC LIMIT 0 , 30
          

            50
            0.44 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` = 4783 ORDER BY s.`id_language` ASC
          

            51
            0.91 ms
            SELECT * FROM `sub_product` WHERE TRUE AND `id_product` = 4783 AND `type` = 4 ORDER BY `id_language` ASC LIMIT 0 , 30
          

            52
            0.78 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...
          

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

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

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

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

            57
            0.36 ms
            SELECT * FROM `seo` WHERE TRUE AND `id_product` = 4788 AND `id_language` = 1 ORDER BY `id` DESC LIMIT 0 , 30
          

            58
            0.35 ms
            SELECT * FROM `product_photos` WHERE TRUE AND `id_product` = 4788 ORDER BY `id` DESC LIMIT 0 , 30
          

            59
            0.47 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` = 4788 ORDER BY s.`id_language` ASC
          

            60
            0.87 ms
            SELECT * FROM `sub_product` WHERE TRUE AND `id_product` = 4788 AND `type` = 4 ORDER BY `id_language` ASC LIMIT 0 , 30
          

            61
            0.64 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...
          

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

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

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

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

            66
            0.36 ms
            SELECT * FROM `seo` WHERE TRUE AND `id_product` = 4775 AND `id_language` = 1 ORDER BY `id` DESC LIMIT 0 , 30
          

            67
            0.4 ms
            SELECT * FROM `product_photos` WHERE TRUE AND `id_product` = 4775 ORDER BY `id` DESC LIMIT 0 , 30
          

            68
            0.45 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` = 4775 ORDER BY s.`id_language` ASC
          

            69
            0.83 ms
            SELECT * FROM `sub_product` WHERE TRUE AND `id_product` = 4775 AND `type` = 4 ORDER BY `id_language` ASC LIMIT 0 , 30
          

            70
            0.77 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...
          

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

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

            73
            0.39 ms
            SELECT * FROM `subproduct_blockeddates` WHERE TRUE AND `id_subproduct` = 3783 ORDER BY `date` ASC LIMIT 0 , 30
          

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

            75
            1046.32 ms
            SELECT * FROM `customer_productlog` WHERE TRUE
          

            76
            6.67 ms
            INSERT INTO `customer_productlog` ( `id` , `content` ) VALUES( NULL , '{\"id_product\":\"4757\",\"id_user\":\"NULL\",\"dateVisited\":1785173272}' )
          

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

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

      

#	Time	Query
1	1.23 ms	SELECT url, namespace, method, content_redirection FROM `redirect` WHERE status = 1
2	4.37 ms	INSERT INTO `log_customer` ( `id` , `id_customer` , `log` , `date` ) VALUES( NULL , NULL ,...
3	0.38 ms	SELECT * FROM `languages` WHERE TRUE AND `short` = 'en'
4	0.53 ms	SELECT * FROM `languages` WHERE TRUE AND `name` = 'English'
5	179.91 ms	SELECT * FROM `product_meta` WHERE TRUE AND `id_language` = 1 AND `metaname` = 'redirect_from_id' AND `metavalue` = '4757' ORDER BY `id` DESC LIMIT 0 , 30
6	0.41 ms	SELECT * FROM `products` p WHERE TRUE AND p.`id` = 4757 ORDER BY `id` DESC
7	0.31 ms	SELECT * FROM `type` WHERE TRUE AND `id` = 2 ORDER BY `id` DESC LIMIT 0 , 30
8	0.32 ms	SELECT * FROM `type` WHERE TRUE AND `group` = 'products_product_type' AND `name` = 'activity' ORDER BY `id` DESC LIMIT 0 , 30
9	0.32 ms	SELECT * FROM `sub_product` WHERE TRUE AND `id_product` = 4757 ORDER BY `id_language` DESC LIMIT 0 , 30
10	0.19 ms	SELECT * FROM `languages` WHERE TRUE AND `id` = 1
11	0.19 ms	SELECT * FROM `type` WHERE TRUE AND `id` = 4 ORDER BY `id` DESC LIMIT 0 , 30
12	0.42 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.32 ms	SELECT * FROM `products` p WHERE TRUE AND p.`id` = 4757 AND p.`status` = '23' ORDER BY `id` DESC
14	0.22 ms	SELECT * FROM `suppliers` s WHERE TRUE AND s.`id` = 36 ORDER BY `id` DESC
15	0.27 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.4 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.38 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` = 4757 ORDER BY `rating_overall` desc LIMIT 20 , 30
18	0.24 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.39 ms	SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 4757 AND `id_language` = 1 ORDER BY `id` DESC LIMIT 0 , 1000
20	0.43 ms	SELECT * FROM `product_system_meta` WHERE TRUE AND `id_product` = 4757 AND `metaname` = 'bookingextranote' ORDER BY `id` DESC LIMIT 0 , 30
21	0.4 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` = 4757 ORDER BY s.`id_language` ASC
22	0.41 ms	SELECT * FROM `product_system` WHERE TRUE AND `id_product_dotravel` = 4757 ORDER BY `id` DESC
23	0.46 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.38 ms	SELECT * FROM `sub_product` WHERE TRUE AND `id_product` = 4757 AND `status` = '15' ORDER BY `id` DESC LIMIT 0 , 30
25	0.41 ms	SELECT * FROM `product_photos` WHERE TRUE AND `id_product` = 4757 ORDER BY `show_order` asc LIMIT 0 , 30
26	0.41 ms	SELECT * FROM `seo` WHERE TRUE AND `id_product` = 4757 AND `id_language` = 1 ORDER BY `id` DESC LIMIT 0 , 30
27	0.34 ms	SELECT * FROM `sub_product` WHERE TRUE AND `id_product` = 4757 ORDER BY `id` DESC LIMIT 0 , 30
28	0.33 ms	SELECT * FROM `product_prices` WHERE TRUE AND `id_subproduct` = 3783 ORDER BY `id` DESC LIMIT 0 , 30
29	0.29 ms	SELECT * FROM `age_group` WHERE TRUE AND `id` = 1 ORDER BY `id` DESC LIMIT 0 , 30
30	0.42 ms	SELECT * FROM `product_bookingfees` WHERE TRUE AND `id_productprice` = 10056 ORDER BY `id` DESC LIMIT 0 , 30
31	0.29 ms	SELECT * FROM `type` WHERE TRUE AND `group` = 'sub_product_type' AND `name` = 'group' ORDER BY `id` DESC LIMIT 0 , 30
32	0.39 ms	SELECT * FROM `sub_product` WHERE TRUE AND `id_product` = 4757 AND `type` = 4 ORDER BY `id_language` ASC LIMIT 0 , 30
33	0.29 ms	SELECT * FROM `product_advantage` WHERE TRUE AND `id_product` = 4757 ORDER BY `id` DESC LIMIT 0 , 30
34	0.37 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 ='4757'
35	0.33 ms	SELECT * FROM `favorites` WHERE TRUE AND `id_product` = 4757 ORDER BY `id` DESC LIMIT 0 , 30
36	0.39 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.5 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` = 4757 AND cm.`id_language` = 1...
38	0.36 ms	SELECT * FROM `product_photos` WHERE TRUE AND `id_product` = 4757 ORDER BY `show_order` ASC LIMIT 0 , 30
39	0.27 ms	SELECT * FROM `destination_parent` WHERE TRUE AND `id_child` = 128 ORDER BY `id` DESC LIMIT 0 , 30
40	0.39 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.28 ms	SELECT * FROM `destination_parent` WHERE TRUE AND `id_child` = 101 ORDER BY `id` DESC LIMIT 0 , 30
42	0.49 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` = 4757 AND p.`status` = 23 AND s.`status` = 10 ORDER BY `id` DESC LIMIT 0 , 3
43	14.43 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 ( 4757 ) AND st.name = 'active' AND st.group = 'suppliers_status' AND p.id IN ( SELECT id_product FROM `product_destination` WHERE id_destination IN...
44	0.64 ms	SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 4783 AND `id_language` = 1 AND `metaname` = 'title' ORDER BY `id` DESC LIMIT 0 , 30
45	0.51 ms	SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 4783 AND `id_language` = 1 AND `metaname` = 'summary' ORDER BY `id` DESC LIMIT 0 , 30
46	0.43 ms	SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 4783 AND `id_language` = 1 AND `metaname` = 'typeHour' ORDER BY `id` DESC LIMIT 0 , 30
47	0.4 ms	SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 4783 AND `id_language` = 1 AND `metaname` = 'currency' ORDER BY `id` DESC LIMIT 0 , 30
48	0.38 ms	SELECT * FROM `seo` WHERE TRUE AND `id_product` = 4783 AND `id_language` = 1 ORDER BY `id` DESC LIMIT 0 , 30
49	0.46 ms	SELECT * FROM `product_photos` WHERE TRUE AND `id_product` = 4783 ORDER BY `id` DESC LIMIT 0 , 30
50	0.44 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` = 4783 ORDER BY s.`id_language` ASC
51	0.91 ms	SELECT * FROM `sub_product` WHERE TRUE AND `id_product` = 4783 AND `type` = 4 ORDER BY `id_language` ASC LIMIT 0 , 30
52	0.78 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...
53	0.68 ms	SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 4788 AND `id_language` = 1 AND `metaname` = 'title' ORDER BY `id` DESC LIMIT 0 , 30
54	0.6 ms	SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 4788 AND `id_language` = 1 AND `metaname` = 'summary' ORDER BY `id` DESC LIMIT 0 , 30
55	0.55 ms	SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 4788 AND `id_language` = 1 AND `metaname` = 'typeHour' ORDER BY `id` DESC LIMIT 0 , 30
56	0.45 ms	SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 4788 AND `id_language` = 1 AND `metaname` = 'currency' ORDER BY `id` DESC LIMIT 0 , 30
57	0.36 ms	SELECT * FROM `seo` WHERE TRUE AND `id_product` = 4788 AND `id_language` = 1 ORDER BY `id` DESC LIMIT 0 , 30
58	0.35 ms	SELECT * FROM `product_photos` WHERE TRUE AND `id_product` = 4788 ORDER BY `id` DESC LIMIT 0 , 30
59	0.47 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` = 4788 ORDER BY s.`id_language` ASC
60	0.87 ms	SELECT * FROM `sub_product` WHERE TRUE AND `id_product` = 4788 AND `type` = 4 ORDER BY `id_language` ASC LIMIT 0 , 30
61	0.64 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...
62	0.71 ms	SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 4775 AND `id_language` = 1 AND `metaname` = 'title' ORDER BY `id` DESC LIMIT 0 , 30
63	0.56 ms	SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 4775 AND `id_language` = 1 AND `metaname` = 'summary' ORDER BY `id` DESC LIMIT 0 , 30
64	0.48 ms	SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 4775 AND `id_language` = 1 AND `metaname` = 'typeHour' ORDER BY `id` DESC LIMIT 0 , 30
65	0.42 ms	SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 4775 AND `id_language` = 1 AND `metaname` = 'currency' ORDER BY `id` DESC LIMIT 0 , 30
66	0.36 ms	SELECT * FROM `seo` WHERE TRUE AND `id_product` = 4775 AND `id_language` = 1 ORDER BY `id` DESC LIMIT 0 , 30
67	0.4 ms	SELECT * FROM `product_photos` WHERE TRUE AND `id_product` = 4775 ORDER BY `id` DESC LIMIT 0 , 30
68	0.45 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` = 4775 ORDER BY s.`id_language` ASC
69	0.83 ms	SELECT * FROM `sub_product` WHERE TRUE AND `id_product` = 4775 AND `type` = 4 ORDER BY `id_language` ASC LIMIT 0 , 30
70	0.77 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...
71	0.88 ms	SELECT id_product, metavalue FROM `product_meta` WHERE id_product IN (?,?,?) AND metaname = ? AND id_language = ?
72	0.54 ms	SELECT * FROM `type` WHERE TRUE AND `group` = 'subproduct_blockeddates_block_type' ORDER BY `id` DESC LIMIT 0 , 30
73	0.39 ms	SELECT * FROM `subproduct_blockeddates` WHERE TRUE AND `id_subproduct` = 3783 ORDER BY `date` ASC LIMIT 0 , 30
74	0.58 ms	SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 4757 AND `id_language` = 1 AND `metaname` = 'availability_next_date' ORDER BY `id` DESC LIMIT 0 , 30
75	1046.32 ms	SELECT * FROM `customer_productlog` WHERE TRUE
76	6.67 ms	INSERT INTO `customer_productlog` ( `id` , `content` ) VALUES( NULL , '{\"id_product\":\"4757\",\"id_user\":\"NULL\",\"dateVisited\":1785173272}' )
77	0.49 ms	SELECT * FROM `suppliers` s WHERE TRUE AND s.`id` = 36 ORDER BY `id` DESC
78	0.49 ms	SELECT * FROM `supplier_meta` WHERE TRUE AND `id_supplier` = 36 ORDER BY `id` DESC LIMIT 0 , 1000

Midnight Sun Tour

About This activity

Meeting Point

You might also like

Arrábida Snorkeling & Wine

Rojo Tango Show with private transfers in Buenos Aires

Golden Circle & Secret Lagoon Small Group Tour