Golden Circle and Waterfalls, with Friðheimar Farm and Kerið in small group

arrow_back

arrow_forward

Next available: Apr 14, 2026

New Activity

Golden Circle and Waterfalls, with Friðheimar Farm and Kerið in small group

Name: Golden Circle and Waterfalls, with Friðheimar Farm and Kerið in small group
Brand: Dotravel
Price: 122.68 EUR
Availability: InStock

ACTIVITY

Discover Iceland's Golden Circle: Thingvellir National Park and Oxararfoss, Geysir geothermal area, Gullfoss waterfall, Fridheimar farm and Kerid crater.

Duration: 9h

Hosted in: EN

Golden Circle Small-Group Tour with Fridheimar Farm and Kerid

Next available: Apr 14, 2026

New Activity

€ 122^.68

About This Activity

Non-Refundable

Instant Confirmation

Mobile Voucher

Printed Voucher

Monday - Sunday

Group: Max10 people

DoTravel

What you'll do

Embark on an unforgettable journey along Iceland's celebrated Golden Circle, a compact route that showcases the island's geological drama and rich cultural heritage. Begin at Thingvellir National Park, where the rift between the North American and Eurasian tectonic plates is laid bare and where Iceland's earliest parliamentary assemblies took place. Nearby, the pretty Oxararfoss waterfall offers a photogenic cascade set within striking geology.

Visit Efstidalur Dairy Farm to experience a slice of Icelandic farm life and sample fresh dairy products in a homely setting. Continue to the Geysir geothermal area to witness Strokkur's regular eruptions as steam and boiling water jet into the sky, a vivid reminder of the volcanic forces shaping the country. Then stand before the mighty Gullfoss, whose glacial waters thunder into a deep canyon and create a misty spectacle.

Enjoy a stop at Fridheimar Tomato Farm, set amid warm greenhouses, for a distinctive farm-to-table lunch experience. Complete the route at Kerid, a volcanic crater lake whose vivid blue waters contrast dramatically with red volcanic rock. The Golden Circle offers varied landscapes — rifts, waterfalls, geothermal vents and volcanic craters — making it an essential introduction to Iceland's natural wonders.

Included / Excluded

Visits to Thingvellir National Park, Oxararfoss, Efstidalur Dairy Farm, Geysir, Gullfoss, Fridheimar Tomato Farm and Kerid crater

Comfortable transportation

Local guide

Small-group tour

Lunch at Fridheimar Tomato Farm (payable locally)

Before You Go

Camera and layered clothing for changeable weather

Bring funds for lunch and personal purchases

Warm, waterproof clothing and sturdy walking shoes recommended

Meeting Point

Iceland

Activity

Whales & Sea Angling

New Activity

€ 191^.11

Check Availability

Activity

Puffin Express

New Activity

€ 53^.10

Check Availability

Activity

Iceland Your Way – Fully Customizable Experience

10h

New Activity

€ 1363^.83

Check Availability

Activity Highlights

Experience the best of the Golden Circle in one memorable day:

Unique geology: Stand between continental plates at Thingvellir and gaze into Kerid's vivid crater lake.
Dramatic waterfalls: Feel the power of Gullfoss and enjoy the scenic charm of Oxararfoss.
Geothermal theatre: Watch Strokkur erupt and explore bubbling hot springs at Geysir.
Authentic farm visit: Savour the greenhouse ambience at Fridheimar and meet friendly cows at Efstidalur.

This small-group experience delivers up-close photo opportunities, varied landscapes and local flavours—perfect for first-time visitors seeking a concise, high-impact taste of Iceland.

Home / Spain / Reykjavík / Golden Circle and Waterfalls, with Friðheimar Farm and Kerið in small group

  DB
  79 queries
  |
  1733.41 ms

    Query Log (79 queries, 1733.41 ms)
    ×
  

    
    
  
Loading...

          
        #TimeQuery

            1
            1.88 ms
            SELECT * FROM `setting` WHERE TRUE
          

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

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

            4
            1.37 ms
            SELECT * FROM `setting` WHERE TRUE AND `st_group` = 'fileServices' AND `st_key` = 'currency'
          

            5
            0.54 ms
            SELECT * FROM `languages` WHERE TRUE AND `name` = 'English'
          

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

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

            8
            1.25 ms
            SELECT * FROM `sub_product` WHERE TRUE AND `id_product` = 4781 ORDER BY `id_language` DESC LIMIT 0 , 30
          

            9
            0.35 ms
            SELECT * FROM `languages` WHERE TRUE AND `id` = 1
          

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

            11
            1.16 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
          

            12
            1.77 ms
            SELECT * FROM `products` p WHERE TRUE AND p.`id` = 4781 AND p.`status` = '23' ORDER BY `id` DESC
          

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

            14
            0.41 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
          

            15
            1.33 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...
          

            16
            0.95 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` = 4781 ORDER BY `rating_overall` desc LIMIT 20 , 30
          

            17
            0.78 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
          

            18
            0.66 ms
            SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 4781 AND `id_language` = 1 ORDER BY `id` DESC LIMIT 0 , 1000
          

            19
            4.21 ms
            SELECT * FROM `product_system_meta` WHERE TRUE AND `id_product` = 4781 AND `metaname` = 'bookingextranote' ORDER BY `id` DESC LIMIT 0 , 30
          

            20
            0.7 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` = 4781 ORDER BY s.`id_language` ASC
          

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

            22
            0.31 ms
            SELECT * FROM `product_system` WHERE TRUE AND `id_product_dotravel` = 4781 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
            1.92 ms
            SELECT * FROM `sub_product` WHERE TRUE AND `id_product` = 4781 AND `status` = '15' ORDER BY `id` DESC LIMIT 0 , 30
          

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

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

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

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

            29
            0.93 ms
            SELECT * FROM `age_group` WHERE TRUE ORDER BY `id` DESC LIMIT 0 , 30
          

            30
            31.62 ms
            SELECT * FROM `product_bookingfees` WHERE TRUE ORDER BY `id` DESC LIMIT 0 , 30
          

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

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

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

            34
            7.84 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 ='4781'
          

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

            36
            0.65 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
            3.28 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` = 4781 AND cm.`id_language` = 1...
          

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

            39
            1.36 ms
            SELECT d.*, d.cdn_image_uuid, d.cdn_variants, d.cdn_processing_status, d.use_cdn, m.id_language, m.name, m.description, m.summary, m.seo_title, m.seo_description, m.seo_keywords, m.seo_url, m.img_alt, m.faqs, m.index_content FROM `destinations` AS d INNER JOIN `destination_meta` AS m on d.id =...
          

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

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

            42
            4.34 ms
            SELECT d.*, d.cdn_image_uuid, d.cdn_variants, d.cdn_processing_status, d.use_cdn, m.id_language, m.name, m.description, m.summary, m.seo_title, m.seo_description, m.seo_keywords, m.seo_url, m.img_alt, m.faqs, m.index_content FROM `destinations` AS d INNER JOIN `destination_meta` AS m on d.id =...
          

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

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

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

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

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

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

            49
            0.37 ms
            SELECT * FROM `seo` WHERE TRUE AND `id_product` = 4761 AND `id_language` = 1 ORDER BY `id` DESC LIMIT 0 , 30
          

            50
            0.38 ms
            SELECT * FROM `product_photos` WHERE TRUE AND `id_product` = 4761 ORDER BY `id` DESC LIMIT 0 , 30
          

            51
            0.63 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` = 4761 ORDER BY s.`id_language` ASC
          

            52
            0.79 ms
            SELECT * FROM `sub_product` WHERE TRUE AND `id_product` = 4761 AND `type` = 4 ORDER BY `id_language` ASC LIMIT 0 , 30
          

            53
            0.57 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...
          

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

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

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

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

            58
            0.33 ms
            SELECT * FROM `seo` WHERE TRUE AND `id_product` = 4766 AND `id_language` = 1 ORDER BY `id` DESC LIMIT 0 , 30
          

            59
            0.38 ms
            SELECT * FROM `product_photos` WHERE TRUE AND `id_product` = 4766 ORDER BY `id` DESC LIMIT 0 , 30
          

            60
            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` = 4766 ORDER BY s.`id_language` ASC
          

            61
            0.8 ms
            SELECT * FROM `sub_product` WHERE TRUE AND `id_product` = 4766 AND `type` = 4 ORDER BY `id_language` ASC LIMIT 0 , 30
          

            62
            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...
          

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

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

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

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

            67
            0.39 ms
            SELECT * FROM `seo` WHERE TRUE AND `id_product` = 4780 AND `id_language` = 1 ORDER BY `id` DESC LIMIT 0 , 30
          

            68
            0.3 ms
            SELECT * FROM `product_photos` WHERE TRUE AND `id_product` = 4780 ORDER BY `id` DESC LIMIT 0 , 30
          

            69
            0.39 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` = 4780 ORDER BY s.`id_language` ASC
          

            70
            0.73 ms
            SELECT * FROM `sub_product` WHERE TRUE AND `id_product` = 4780 AND `type` = 4 ORDER BY `id_language` ASC LIMIT 0 , 30
          

            71
            0.58 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...
          

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

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

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

            75
            0.67 ms
            SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 4781 AND `id_language` = 1 AND `metaname` = 'timezone' ORDER BY `id` DESC LIMIT 0 , 30
          

            76
            1405.13 ms
            SELECT * FROM `customer_productlog` WHERE TRUE
          

            77
            2.6 ms
            INSERT INTO `customer_productlog` ( `id` , `content` ) VALUES( NULL , '{\"id_product\":\"4781\",\"id_user\":\"NULL\",\"dateVisited\":1776155680}' )
          

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

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

      

#	Time	Query
1	1.88 ms	SELECT * FROM `setting` WHERE TRUE
2	3.12 ms	INSERT INTO `log_customer` ( `id` , `id_customer` , `log` , `date` ) VALUES( NULL , NULL ,...
3	1.54 ms	SELECT * FROM `languages` WHERE TRUE AND `short` = 'en'
4	1.37 ms	SELECT * FROM `setting` WHERE TRUE AND `st_group` = 'fileServices' AND `st_key` = 'currency'
5	0.54 ms	SELECT * FROM `languages` WHERE TRUE AND `name` = 'English'
6	172.18 ms	SELECT * FROM `product_meta` WHERE TRUE AND `id_language` = 1 AND `metaname` = 'redirect_from_id' AND `metavalue` = '4781' ORDER BY `id` DESC LIMIT 0 , 30
7	1.25 ms	SELECT * FROM `type` WHERE TRUE AND `group` = 'products_product_type' AND `name` = 'activity' ORDER BY `id` DESC LIMIT 0 , 30
8	1.25 ms	SELECT * FROM `sub_product` WHERE TRUE AND `id_product` = 4781 ORDER BY `id_language` DESC LIMIT 0 , 30
9	0.35 ms	SELECT * FROM `languages` WHERE TRUE AND `id` = 1
10	0.24 ms	SELECT * FROM `type` WHERE TRUE AND `id` = 4 ORDER BY `id` DESC LIMIT 0 , 30
11	1.16 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
12	1.77 ms	SELECT * FROM `products` p WHERE TRUE AND p.`id` = 4781 AND p.`status` = '23' ORDER BY `id` DESC
13	0.63 ms	SELECT * FROM `suppliers` s WHERE TRUE AND s.`id` = 36 ORDER BY `id` DESC
14	0.41 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
15	1.33 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...
16	0.95 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` = 4781 ORDER BY `rating_overall` desc LIMIT 20 , 30
17	0.78 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
18	0.66 ms	SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 4781 AND `id_language` = 1 ORDER BY `id` DESC LIMIT 0 , 1000
19	4.21 ms	SELECT * FROM `product_system_meta` WHERE TRUE AND `id_product` = 4781 AND `metaname` = 'bookingextranote' ORDER BY `id` DESC LIMIT 0 , 30
20	0.7 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` = 4781 ORDER BY s.`id_language` ASC
21	0.26 ms	SELECT * FROM `type` WHERE TRUE AND `id` = 2 ORDER BY `id` DESC LIMIT 0 , 30
22	0.31 ms	SELECT * FROM `product_system` WHERE TRUE AND `id_product_dotravel` = 4781 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	1.92 ms	SELECT * FROM `sub_product` WHERE TRUE AND `id_product` = 4781 AND `status` = '15' ORDER BY `id` DESC LIMIT 0 , 30
25	1.3 ms	SELECT * FROM `product_photos` WHERE TRUE AND `id_product` = 4781 ORDER BY `show_order` asc LIMIT 0 , 30
26	0.81 ms	SELECT * FROM `seo` WHERE TRUE AND `id_product` = 4781 AND `id_language` = 1 ORDER BY `id` DESC LIMIT 0 , 30
27	0.27 ms	SELECT * FROM `sub_product` WHERE TRUE AND `id_product` = 4781 ORDER BY `id` DESC LIMIT 0 , 30
28	0.52 ms	SELECT * FROM `product_prices` WHERE TRUE AND `id_subproduct` = 3807 ORDER BY `id` DESC LIMIT 0 , 30
29	0.93 ms	SELECT * FROM `age_group` WHERE TRUE ORDER BY `id` DESC LIMIT 0 , 30
30	31.62 ms	SELECT * FROM `product_bookingfees` WHERE TRUE ORDER BY `id` DESC LIMIT 0 , 30
31	0.45 ms	SELECT * FROM `type` WHERE TRUE AND `group` = 'sub_product_type' AND `name` = 'group' ORDER BY `id` DESC LIMIT 0 , 30
32	0.44 ms	SELECT * FROM `sub_product` WHERE TRUE AND `id_product` = 4781 AND `type` = 4 ORDER BY `id_language` ASC LIMIT 0 , 30
33	8.51 ms	SELECT * FROM `product_advantage` WHERE TRUE AND `id_product` = 4781 ORDER BY `id` DESC LIMIT 0 , 30
34	7.84 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 ='4781'
35	6.89 ms	SELECT * FROM `favorites` WHERE TRUE AND `id_product` = 4781 ORDER BY `id` DESC LIMIT 0 , 30
36	0.65 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	3.28 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` = 4781 AND cm.`id_language` = 1...
38	0.88 ms	SELECT * FROM `product_photos` WHERE TRUE AND `id_product` = 4781 ORDER BY `show_order` ASC LIMIT 0 , 30
39	1.36 ms	SELECT d.*, d.cdn_image_uuid, d.cdn_variants, d.cdn_processing_status, d.use_cdn, m.id_language, m.name, m.description, m.summary, m.seo_title, m.seo_description, m.seo_keywords, m.seo_url, m.img_alt, m.faqs, m.index_content FROM `destinations` AS d INNER JOIN `destination_meta` AS m on d.id =...
40	1.32 ms	SELECT * FROM `destination_parent` WHERE TRUE AND `id_child` = 128 ORDER BY `id` DESC LIMIT 0 , 30
41	0.42 ms	SELECT * FROM `destination_parent` WHERE TRUE AND `id_child` = 101 ORDER BY `id` DESC LIMIT 0 , 30
42	4.34 ms	SELECT d.*, d.cdn_image_uuid, d.cdn_variants, d.cdn_processing_status, d.use_cdn, m.id_language, m.name, m.description, m.summary, m.seo_title, m.seo_description, m.seo_keywords, m.seo_url, m.img_alt, m.faqs, m.index_content FROM `destinations` AS d INNER JOIN `destination_meta` AS m on d.id =...
43	4.96 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` = 4781 AND p.`status` = 23 AND s.`status` = 10 ORDER BY `id` DESC LIMIT 0 , 3
44	20.08 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 ( 4781 ) AND st.name = 'active' AND st.group = 'suppliers_status' AND p.id IN ( SELECT id_product FROM `product_destination` WHERE id_destination IN...
45	0.83 ms	SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 4761 AND `id_language` = 1 AND `metaname` = 'title' ORDER BY `id` DESC LIMIT 0 , 30
46	0.65 ms	SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 4761 AND `id_language` = 1 AND `metaname` = 'summary' ORDER BY `id` DESC LIMIT 0 , 30
47	0.51 ms	SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 4761 AND `id_language` = 1 AND `metaname` = 'typeHour' ORDER BY `id` DESC LIMIT 0 , 30
48	0.44 ms	SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 4761 AND `id_language` = 1 AND `metaname` = 'currency' ORDER BY `id` DESC LIMIT 0 , 30
49	0.37 ms	SELECT * FROM `seo` WHERE TRUE AND `id_product` = 4761 AND `id_language` = 1 ORDER BY `id` DESC LIMIT 0 , 30
50	0.38 ms	SELECT * FROM `product_photos` WHERE TRUE AND `id_product` = 4761 ORDER BY `id` DESC LIMIT 0 , 30
51	0.63 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` = 4761 ORDER BY s.`id_language` ASC
52	0.79 ms	SELECT * FROM `sub_product` WHERE TRUE AND `id_product` = 4761 AND `type` = 4 ORDER BY `id_language` ASC LIMIT 0 , 30
53	0.57 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...
54	0.56 ms	SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 4766 AND `id_language` = 1 AND `metaname` = 'title' ORDER BY `id` DESC LIMIT 0 , 30
55	0.42 ms	SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 4766 AND `id_language` = 1 AND `metaname` = 'summary' ORDER BY `id` DESC LIMIT 0 , 30
56	0.38 ms	SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 4766 AND `id_language` = 1 AND `metaname` = 'typeHour' ORDER BY `id` DESC LIMIT 0 , 30
57	0.4 ms	SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 4766 AND `id_language` = 1 AND `metaname` = 'currency' ORDER BY `id` DESC LIMIT 0 , 30
58	0.33 ms	SELECT * FROM `seo` WHERE TRUE AND `id_product` = 4766 AND `id_language` = 1 ORDER BY `id` DESC LIMIT 0 , 30
59	0.38 ms	SELECT * FROM `product_photos` WHERE TRUE AND `id_product` = 4766 ORDER BY `id` DESC LIMIT 0 , 30
60	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` = 4766 ORDER BY s.`id_language` ASC
61	0.8 ms	SELECT * FROM `sub_product` WHERE TRUE AND `id_product` = 4766 AND `type` = 4 ORDER BY `id_language` ASC LIMIT 0 , 30
62	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...
63	0.63 ms	SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 4780 AND `id_language` = 1 AND `metaname` = 'title' ORDER BY `id` DESC LIMIT 0 , 30
64	0.55 ms	SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 4780 AND `id_language` = 1 AND `metaname` = 'summary' ORDER BY `id` DESC LIMIT 0 , 30
65	0.5 ms	SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 4780 AND `id_language` = 1 AND `metaname` = 'typeHour' ORDER BY `id` DESC LIMIT 0 , 30
66	0.5 ms	SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 4780 AND `id_language` = 1 AND `metaname` = 'currency' ORDER BY `id` DESC LIMIT 0 , 30
67	0.39 ms	SELECT * FROM `seo` WHERE TRUE AND `id_product` = 4780 AND `id_language` = 1 ORDER BY `id` DESC LIMIT 0 , 30
68	0.3 ms	SELECT * FROM `product_photos` WHERE TRUE AND `id_product` = 4780 ORDER BY `id` DESC LIMIT 0 , 30
69	0.39 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` = 4780 ORDER BY s.`id_language` ASC
70	0.73 ms	SELECT * FROM `sub_product` WHERE TRUE AND `id_product` = 4780 AND `type` = 4 ORDER BY `id_language` ASC LIMIT 0 , 30
71	0.58 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...
72	0.37 ms	SELECT * FROM `type` WHERE TRUE AND `group` = 'subproduct_blockeddates_block_type' ORDER BY `id` DESC LIMIT 0 , 30
73	8.6 ms	SELECT * FROM `subproduct_blockeddates` WHERE TRUE AND `id_subproduct` = 3807 ORDER BY `date` ASC LIMIT 0 , 30
74	0.9 ms	SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 4781 AND `id_language` = 1 AND `metaname` = 'availability_next_date' ORDER BY `id` DESC LIMIT 0 , 30
75	0.67 ms	SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 4781 AND `id_language` = 1 AND `metaname` = 'timezone' ORDER BY `id` DESC LIMIT 0 , 30
76	1405.13 ms	SELECT * FROM `customer_productlog` WHERE TRUE
77	2.6 ms	INSERT INTO `customer_productlog` ( `id` , `content` ) VALUES( NULL , '{\"id_product\":\"4781\",\"id_user\":\"NULL\",\"dateVisited\":1776155680}' )
78	0.57 ms	SELECT * FROM `suppliers` s WHERE TRUE AND s.`id` = 36 ORDER BY `id` DESC
79	4.23 ms	SELECT * FROM `supplier_meta` WHERE TRUE AND `id_supplier` = 36 ORDER BY `id` DESC LIMIT 0 , 1000

Golden Circle and Waterfalls, with Friðheimar Farm and Kerið in small group

Golden Circle Small-Group Tour with Fridheimar Farm and Kerid

What you'll do

Meeting Point

You might also like

Activity Highlights