Touristic highlights of Zürich with Cruise & Chocolate (halfday tour with local)

arrow_back

arrow_forward

New Activity

Touristic highlights of Zürich with Cruise & Chocolate (halfday tour with local)

Name: Touristic highlights of Zürich with Cruise & Chocolate (halfday tour with local)
Brand: Dotravel
Price: 66.03 EUR
Availability: InStock

Duration: 5h 30m

Group: Max 10 people

May 18, 2026

FROM

€ 66

/pp

About This activity

DoTravel

Meeting Point

Switzerland

Zurich is home to a bounty of local, must-eat foods and one of the great joys of a holiday abroad is sampling the local cuisine and the food in Zurich is amongst the best in Europe.

Experience fantastic art and architecture, a rich Medieval history and innovative modern additions in Zurich which has the reputation of being the most cosmopolitan, modern and avant-garde city in Switzerland.

Our fun and entertaining guide will make this a memorable experience for you filled with sightseeing, visiting local popular hangout places and trying the local food & drinks. It is one of the best experiences to immerse yourself into the rich Swiss culture.

No reviews yet

Reykjavik Food and Drink Adventure - Local Evening Experience

New Activity

schedule 3h 30m

Reykjavik Food and Drink Adventure - Local Evening Experience

Next available: Apr 25, 2026

activity BOOK IT

FROM

€ 159

/pp

New Activity

schedule 1h

Puffin Express by RIB Speedboat

Next available: Jun 01, 2026

activity BOOK IT

FROM

€ 76

/pp

Costa da Caparica Surf and Yoga from Lisbon

New Activity

schedule 5h

Costa da Caparica Surf and Yoga from Lisbon

Next available: Jun 23, 2026

activity BOOK IT

FROM

€ 81

/pp

  DB
  81 queries
  |
  2017.02 ms

    Query Log (81 queries, 2017.02 ms)
    ×
  

    
    
  
Loading...

          
        #TimeQuery

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

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

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

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

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

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

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

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

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

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

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

            12
            0.3 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.27 ms
            SELECT * FROM `products` p WHERE TRUE AND p.`id` = 4787 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.34 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.43 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.47 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` = 4787 ORDER BY `rating_overall` desc LIMIT 20 , 30
          

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

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

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

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

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

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

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

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

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

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

            30
            0.35 ms
            SELECT * FROM `product_bookingfees` WHERE TRUE AND `id_productprice` = 10077 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.34 ms
            SELECT * FROM `sub_product` WHERE TRUE AND `id_product` = 4787 AND `type` = 4 ORDER BY `id_language` ASC LIMIT 0 , 30
          

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

            34
            0.43 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 ='4787'
          

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

            36
            0.35 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.6 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` = 4787 AND cm.`id_language` = 1...
          

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

            39
            1.16 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
            0.36 ms
            SELECT * FROM `destination_parent` WHERE TRUE AND `id_child` = 69 ORDER BY `id` DESC LIMIT 0 , 30
          

            41
            0.45 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 =...
          

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

            43
            0.44 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 =...
          

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

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

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

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

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

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

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

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

            52
            0.36 ms
            SELECT * FROM `product_photos` WHERE TRUE AND `id_product` = 4764 ORDER BY `id` DESC LIMIT 0 , 30
          

            53
            0.51 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` = 4764 ORDER BY s.`id_language` ASC
          

            54
            0.72 ms
            SELECT * FROM `sub_product` WHERE TRUE AND `id_product` = 4764 AND `type` = 4 ORDER BY `id_language` ASC LIMIT 0 , 30
          

            55
            0.55 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...
          

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

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

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

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

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

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

            62
            0.43 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` = 4760 ORDER BY s.`id_language` ASC
          

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

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

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

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

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

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

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

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

            71
            0.46 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` = 4784 ORDER BY s.`id_language` ASC
          

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

            73
            0.5 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
            0.58 ms
            SELECT id_product, metavalue FROM `product_meta` WHERE id_product IN (?,?,?) AND metaname = ? AND id_language = ?
          

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

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

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

            78
            1736.87 ms
            SELECT * FROM `customer_productlog` WHERE TRUE
          

            79
            4.95 ms
            INSERT INTO `customer_productlog` ( `id` , `content` ) VALUES( NULL , '{\"id_product\":\"4787\",\"id_user\":\"NULL\",\"dateVisited\":1785174599}' )
          

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

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

      

#	Time	Query
1	4.29 ms	SELECT url, namespace, method, content_redirection FROM `redirect` WHERE status = 1
2	3.97 ms	INSERT INTO `log_customer` ( `id` , `id_customer` , `log` , `date` ) VALUES( NULL , NULL ,...
3	0.61 ms	SELECT * FROM `languages` WHERE TRUE AND `short` = 'en'
4	0.95 ms	SELECT * FROM `languages` WHERE TRUE AND `name` = 'English'
5	210.87 ms	SELECT * FROM `product_meta` WHERE TRUE AND `id_language` = 1 AND `metaname` = 'redirect_from_id' AND `metavalue` = '4787' ORDER BY `id` DESC LIMIT 0 , 30
6	0.47 ms	SELECT * FROM `products` p WHERE TRUE AND p.`id` = 4787 ORDER BY `id` DESC
7	0.3 ms	SELECT * FROM `type` WHERE TRUE AND `id` = 2 ORDER BY `id` DESC LIMIT 0 , 30
8	0.41 ms	SELECT * FROM `type` WHERE TRUE AND `group` = 'products_product_type' AND `name` = 'activity' ORDER BY `id` DESC LIMIT 0 , 30
9	0.36 ms	SELECT * FROM `sub_product` WHERE TRUE AND `id_product` = 4787 ORDER BY `id_language` DESC LIMIT 0 , 30
10	0.28 ms	SELECT * FROM `languages` WHERE TRUE AND `id` = 1
11	0.23 ms	SELECT * FROM `type` WHERE TRUE AND `id` = 4 ORDER BY `id` DESC LIMIT 0 , 30
12	0.3 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.27 ms	SELECT * FROM `products` p WHERE TRUE AND p.`id` = 4787 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.34 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.43 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.47 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` = 4787 ORDER BY `rating_overall` desc LIMIT 20 , 30
18	0.3 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.38 ms	SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 4787 AND `id_language` = 1 ORDER BY `id` DESC LIMIT 0 , 1000
20	0.51 ms	SELECT * FROM `product_system_meta` WHERE TRUE AND `id_product` = 4787 AND `metaname` = 'bookingextranote' ORDER BY `id` DESC LIMIT 0 , 30
21	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` = 4787 ORDER BY s.`id_language` ASC
22	0.33 ms	SELECT * FROM `product_system` WHERE TRUE AND `id_product_dotravel` = 4787 ORDER BY `id` DESC
23	0.44 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.35 ms	SELECT * FROM `sub_product` WHERE TRUE AND `id_product` = 4787 AND `status` = '15' ORDER BY `id` DESC LIMIT 0 , 30
25	0.4 ms	SELECT * FROM `product_photos` WHERE TRUE AND `id_product` = 4787 ORDER BY `show_order` asc LIMIT 0 , 30
26	0.43 ms	SELECT * FROM `seo` WHERE TRUE AND `id_product` = 4787 AND `id_language` = 1 ORDER BY `id` DESC LIMIT 0 , 30
27	0.27 ms	SELECT * FROM `sub_product` WHERE TRUE AND `id_product` = 4787 ORDER BY `id` DESC LIMIT 0 , 30
28	0.34 ms	SELECT * FROM `product_prices` WHERE TRUE AND `id_subproduct` = 3813 ORDER BY `id` DESC LIMIT 0 , 30
29	0.3 ms	SELECT * FROM `age_group` WHERE TRUE AND `id` = 1 ORDER BY `id` DESC LIMIT 0 , 30
30	0.35 ms	SELECT * FROM `product_bookingfees` WHERE TRUE AND `id_productprice` = 10077 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.34 ms	SELECT * FROM `sub_product` WHERE TRUE AND `id_product` = 4787 AND `type` = 4 ORDER BY `id_language` ASC LIMIT 0 , 30
33	0.23 ms	SELECT * FROM `product_advantage` WHERE TRUE AND `id_product` = 4787 ORDER BY `id` DESC LIMIT 0 , 30
34	0.43 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 ='4787'
35	0.23 ms	SELECT * FROM `favorites` WHERE TRUE AND `id_product` = 4787 ORDER BY `id` DESC LIMIT 0 , 30
36	0.35 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.6 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` = 4787 AND cm.`id_language` = 1...
38	0.38 ms	SELECT * FROM `product_photos` WHERE TRUE AND `id_product` = 4787 ORDER BY `show_order` ASC LIMIT 0 , 30
39	1.16 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	0.36 ms	SELECT * FROM `destination_parent` WHERE TRUE AND `id_child` = 69 ORDER BY `id` DESC LIMIT 0 , 30
41	0.45 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 =...
42	0.24 ms	SELECT * FROM `destination_parent` WHERE TRUE AND `id_child` = 40 ORDER BY `id` DESC LIMIT 0 , 30
43	0.44 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 =...
44	0.23 ms	SELECT * FROM `destination_parent` WHERE TRUE AND `id_child` = 39 ORDER BY `id` DESC LIMIT 0 , 30
45	0.53 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` = 4787 AND p.`status` = 23 AND s.`status` = 10 ORDER BY `id` DESC LIMIT 0 , 3
46	22.94 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 ( 4787 ) AND st.name = 'active' AND st.group = 'suppliers_status' AND p.id IN ( SELECT id_product FROM `product_destination` WHERE id_destination IN...
47	0.7 ms	SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 4764 AND `id_language` = 1 AND `metaname` = 'title' ORDER BY `id` DESC LIMIT 0 , 30
48	0.56 ms	SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 4764 AND `id_language` = 1 AND `metaname` = 'summary' ORDER BY `id` DESC LIMIT 0 , 30
49	0.45 ms	SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 4764 AND `id_language` = 1 AND `metaname` = 'typeHour' ORDER BY `id` DESC LIMIT 0 , 30
50	0.43 ms	SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 4764 AND `id_language` = 1 AND `metaname` = 'currency' ORDER BY `id` DESC LIMIT 0 , 30
51	0.39 ms	SELECT * FROM `seo` WHERE TRUE AND `id_product` = 4764 AND `id_language` = 1 ORDER BY `id` DESC LIMIT 0 , 30
52	0.36 ms	SELECT * FROM `product_photos` WHERE TRUE AND `id_product` = 4764 ORDER BY `id` DESC LIMIT 0 , 30
53	0.51 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` = 4764 ORDER BY s.`id_language` ASC
54	0.72 ms	SELECT * FROM `sub_product` WHERE TRUE AND `id_product` = 4764 AND `type` = 4 ORDER BY `id_language` ASC LIMIT 0 , 30
55	0.55 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...
56	0.49 ms	SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 4760 AND `id_language` = 1 AND `metaname` = 'title' ORDER BY `id` DESC LIMIT 0 , 30
57	0.39 ms	SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 4760 AND `id_language` = 1 AND `metaname` = 'summary' ORDER BY `id` DESC LIMIT 0 , 30
58	0.45 ms	SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 4760 AND `id_language` = 1 AND `metaname` = 'typeHour' ORDER BY `id` DESC LIMIT 0 , 30
59	0.4 ms	SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 4760 AND `id_language` = 1 AND `metaname` = 'currency' ORDER BY `id` DESC LIMIT 0 , 30
60	0.33 ms	SELECT * FROM `seo` WHERE TRUE AND `id_product` = 4760 AND `id_language` = 1 ORDER BY `id` DESC LIMIT 0 , 30
61	0.31 ms	SELECT * FROM `product_photos` WHERE TRUE AND `id_product` = 4760 ORDER BY `id` DESC LIMIT 0 , 30
62	0.43 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` = 4760 ORDER BY s.`id_language` ASC
63	0.68 ms	SELECT * FROM `sub_product` WHERE TRUE AND `id_product` = 4760 AND `type` = 4 ORDER BY `id_language` ASC LIMIT 0 , 30
64	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...
65	0.49 ms	SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 4784 AND `id_language` = 1 AND `metaname` = 'title' ORDER BY `id` DESC LIMIT 0 , 30
66	0.43 ms	SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 4784 AND `id_language` = 1 AND `metaname` = 'summary' ORDER BY `id` DESC LIMIT 0 , 30
67	0.37 ms	SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 4784 AND `id_language` = 1 AND `metaname` = 'typeHour' ORDER BY `id` DESC LIMIT 0 , 30
68	0.4 ms	SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 4784 AND `id_language` = 1 AND `metaname` = 'currency' ORDER BY `id` DESC LIMIT 0 , 30
69	0.34 ms	SELECT * FROM `seo` WHERE TRUE AND `id_product` = 4784 AND `id_language` = 1 ORDER BY `id` DESC LIMIT 0 , 30
70	0.36 ms	SELECT * FROM `product_photos` WHERE TRUE AND `id_product` = 4784 ORDER BY `id` DESC LIMIT 0 , 30
71	0.46 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` = 4784 ORDER BY s.`id_language` ASC
72	0.65 ms	SELECT * FROM `sub_product` WHERE TRUE AND `id_product` = 4784 AND `type` = 4 ORDER BY `id_language` ASC LIMIT 0 , 30
73	0.5 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	0.58 ms	SELECT id_product, metavalue FROM `product_meta` WHERE id_product IN (?,?,?) AND metaname = ? AND id_language = ?
75	0.35 ms	SELECT * FROM `type` WHERE TRUE AND `group` = 'subproduct_blockeddates_block_type' ORDER BY `id` DESC LIMIT 0 , 30
76	0.31 ms	SELECT * FROM `subproduct_blockeddates` WHERE TRUE AND `id_subproduct` = 3813 ORDER BY `date` ASC LIMIT 0 , 30
77	0.49 ms	SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 4787 AND `id_language` = 1 AND `metaname` = 'availability_next_date' ORDER BY `id` DESC LIMIT 0 , 30
78	1736.87 ms	SELECT * FROM `customer_productlog` WHERE TRUE
79	4.95 ms	INSERT INTO `customer_productlog` ( `id` , `content` ) VALUES( NULL , '{\"id_product\":\"4787\",\"id_user\":\"NULL\",\"dateVisited\":1785174599}' )
80	0.74 ms	SELECT * FROM `suppliers` s WHERE TRUE AND s.`id` = 36 ORDER BY `id` DESC
81	1.06 ms	SELECT * FROM `supplier_meta` WHERE TRUE AND `id_supplier` = 36 ORDER BY `id` DESC LIMIT 0 , 1000

Touristic highlights of Zürich with Cruise & Chocolate (halfday tour with local)