Porto: Boat Tour by the Douro River with Wine and Snacks included

arrow_back

arrow_forward

New Activity

Porto: Boat Tour by the Douro River with Wine and Snacks included

Name: Porto: Boat Tour by the Douro River with Wine and Snacks included
Brand: Dotravel
Price: 43.76 EUR
Availability: InStock

Duration: 2h

Group: Max 10 people

May 18, 2026

FROM

€ 44

/pp

About This activity

DoTravel

Meeting Point

Portugal

In this Porto Boat Tour you will be able to admire the views of Oporto from the Douro River, and make the most of the best sunsets while you get to know the main spots of our coast.
This is an opportunity for you to observe the touristical monuments of the city, avoiding the crowds and queues, while sat on a 52 feet Ocean Star boat.
Besides all the scenic views, you will also have a privileged look at the bridges, one of the main icons of Oporto.
While you enjoy this experience, we will offer you a glass of Tawny Port Wine for you to taste the typical beverage from the city and some Tapas snacks.
You can also find available a fridge, dishes, cups and cutlery in case you wish to bring your own food and drinks!

We invite you to join us on this memorable experience.

No reviews yet

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

Discover Lisbon: Sunset Tagus River Sailing Tour

New Activity

schedule 2h

Discover Lisbon: Sunset Tagus River Sailing Tour

Next available: Jul 11, 2026

activity BOOK IT

FROM

€ 34

/pp

Discovery Walk in Porto’s Jardins do Palacio de Cristal: Fairytale Views and Better Conversations

New Activity

schedule 3h

Discovery Walk in Porto’s Jardins do Palacio de Cristal: Fairytale Views and Better Conversations

Get to know Porto’s most magical gardens playfully and with no guide. Along the way,...

Next available: Feb 06, 2026

activity BOOK IT

FROM

€ 21

/pp

  DB
  78 queries
  |
  2040.31 ms

    Query Log (78 queries, 2040.31 ms)
    ×
  

    
    
  
Loading...

          
        #TimeQuery

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

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

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

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

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

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

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

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

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

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

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

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

            14
            0.25 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.34 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.41 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` = 4782 ORDER BY `rating_overall` desc LIMIT 20 , 30
          

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

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

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

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

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

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

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

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

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

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

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

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

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

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

            34
            0.27 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 ='4782'
          

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

            36
            0.27 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.31 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` = 4782 AND cm.`id_language` = 1...
          

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

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

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

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

            43
            13.23 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 ( 4782 ) 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.55 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
          

            45
            0.44 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
          

            46
            0.48 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
          

            47
            0.39 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
          

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

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

            50
            0.35 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
          

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

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

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

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

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

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

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

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

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

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

            61
            0.46 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.49 ms
            SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 4722 AND `id_language` = 1 AND `metaname` = 'title' ORDER BY `id` DESC LIMIT 0 , 30
          

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

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

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

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

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

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

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

            70
            0.53 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.82 ms
            SELECT id_product, metavalue FROM `product_meta` WHERE id_product IN (?,?,?) AND metaname = ? AND id_language = ?
          

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

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

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

            75
            1720.84 ms
            SELECT * FROM `customer_productlog` WHERE TRUE
          

            76
            6.04 ms
            INSERT INTO `customer_productlog` ( `id` , `content` ) VALUES( NULL , '{\"id_product\":\"4782\",\"id_user\":\"NULL\",\"dateVisited\":1785174599}' )
          

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

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

      

#	Time	Query
1	2.39 ms	SELECT url, namespace, method, content_redirection FROM `redirect` WHERE status = 1
2	5.79 ms	INSERT INTO `log_customer` ( `id` , `id_customer` , `log` , `date` ) VALUES( NULL , NULL ,...
3	0.44 ms	SELECT * FROM `languages` WHERE TRUE AND `short` = 'en'
4	0.6 ms	SELECT * FROM `languages` WHERE TRUE AND `name` = 'English'
5	259.64 ms	SELECT * FROM `product_meta` WHERE TRUE AND `id_language` = 1 AND `metaname` = 'redirect_from_id' AND `metavalue` = '4782' ORDER BY `id` DESC LIMIT 0 , 30
6	0.35 ms	SELECT * FROM `products` p WHERE TRUE AND p.`id` = 4782 ORDER BY `id` DESC
7	0.22 ms	SELECT * FROM `type` WHERE TRUE AND `id` = 2 ORDER BY `id` DESC LIMIT 0 , 30
8	0.29 ms	SELECT * FROM `type` WHERE TRUE AND `group` = 'products_product_type' AND `name` = 'activity' ORDER BY `id` DESC LIMIT 0 , 30
9	0.28 ms	SELECT * FROM `sub_product` WHERE TRUE AND `id_product` = 4782 ORDER BY `id_language` DESC LIMIT 0 , 30
10	0.21 ms	SELECT * FROM `languages` WHERE TRUE AND `id` = 1
11	0.21 ms	SELECT * FROM `type` WHERE TRUE AND `id` = 4 ORDER BY `id` DESC LIMIT 0 , 30
12	0.32 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.25 ms	SELECT * FROM `products` p WHERE TRUE AND p.`id` = 4782 AND p.`status` = '23' ORDER BY `id` DESC
14	0.25 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.34 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.41 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` = 4782 ORDER BY `rating_overall` desc LIMIT 20 , 30
18	0.25 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.37 ms	SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 4782 AND `id_language` = 1 ORDER BY `id` DESC LIMIT 0 , 1000
20	0.52 ms	SELECT * FROM `product_system_meta` WHERE TRUE AND `id_product` = 4782 AND `metaname` = 'bookingextranote' ORDER BY `id` DESC LIMIT 0 , 30
21	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` = 4782 ORDER BY s.`id_language` ASC
22	0.28 ms	SELECT * FROM `product_system` WHERE TRUE AND `id_product_dotravel` = 4782 ORDER BY `id` DESC
23	0.32 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.3 ms	SELECT * FROM `sub_product` WHERE TRUE AND `id_product` = 4782 AND `status` = '15' ORDER BY `id` DESC LIMIT 0 , 30
25	0.43 ms	SELECT * FROM `product_photos` WHERE TRUE AND `id_product` = 4782 ORDER BY `show_order` asc LIMIT 0 , 30
26	0.29 ms	SELECT * FROM `seo` WHERE TRUE AND `id_product` = 4782 AND `id_language` = 1 ORDER BY `id` DESC LIMIT 0 , 30
27	0.3 ms	SELECT * FROM `sub_product` WHERE TRUE AND `id_product` = 4782 ORDER BY `id` DESC LIMIT 0 , 30
28	0.27 ms	SELECT * FROM `product_prices` WHERE TRUE AND `id_subproduct` = 3808 ORDER BY `id` DESC LIMIT 0 , 30
29	0.25 ms	SELECT * FROM `age_group` WHERE TRUE AND `id` = 1 ORDER BY `id` DESC LIMIT 0 , 30
30	0.29 ms	SELECT * FROM `product_bookingfees` WHERE TRUE AND `id_productprice` = 10072 ORDER BY `id` DESC LIMIT 0 , 30
31	0.36 ms	SELECT * FROM `type` WHERE TRUE AND `group` = 'sub_product_type' AND `name` = 'group' ORDER BY `id` DESC LIMIT 0 , 30
32	0.31 ms	SELECT * FROM `sub_product` WHERE TRUE AND `id_product` = 4782 AND `type` = 4 ORDER BY `id_language` ASC LIMIT 0 , 30
33	0.26 ms	SELECT * FROM `product_advantage` WHERE TRUE AND `id_product` = 4782 ORDER BY `id` DESC LIMIT 0 , 30
34	0.27 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 ='4782'
35	0.24 ms	SELECT * FROM `favorites` WHERE TRUE AND `id_product` = 4782 ORDER BY `id` DESC LIMIT 0 , 30
36	0.27 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.31 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` = 4782 AND cm.`id_language` = 1...
38	0.32 ms	SELECT * FROM `product_photos` WHERE TRUE AND `id_product` = 4782 ORDER BY `show_order` ASC LIMIT 0 , 30
39	0.23 ms	SELECT * FROM `destination_parent` WHERE TRUE AND `id_child` = 106 ORDER BY `id` DESC LIMIT 0 , 30
40	0.33 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.21 ms	SELECT * FROM `destination_parent` WHERE TRUE AND `id_child` = 104 ORDER BY `id` DESC LIMIT 0 , 30
42	0.36 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` = 4782 AND p.`status` = 23 AND s.`status` = 10 ORDER BY `id` DESC LIMIT 0 , 3
43	13.23 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 ( 4782 ) 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.55 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
45	0.44 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
46	0.48 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
47	0.39 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
48	0.37 ms	SELECT * FROM `seo` WHERE TRUE AND `id_product` = 4784 AND `id_language` = 1 ORDER BY `id` DESC LIMIT 0 , 30
49	0.46 ms	SELECT * FROM `product_photos` WHERE TRUE AND `id_product` = 4784 ORDER BY `id` DESC LIMIT 0 , 30
50	0.35 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
51	0.5 ms	SELECT * FROM `sub_product` WHERE TRUE AND `id_product` = 4784 AND `type` = 4 ORDER BY `id_language` ASC LIMIT 0 , 30
52	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...
53	0.4 ms	SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 4790 AND `id_language` = 1 AND `metaname` = 'title' ORDER BY `id` DESC LIMIT 0 , 30
54	0.45 ms	SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 4790 AND `id_language` = 1 AND `metaname` = 'summary' ORDER BY `id` DESC LIMIT 0 , 30
55	0.33 ms	SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 4790 AND `id_language` = 1 AND `metaname` = 'typeHour' ORDER BY `id` DESC LIMIT 0 , 30
56	0.38 ms	SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 4790 AND `id_language` = 1 AND `metaname` = 'currency' ORDER BY `id` DESC LIMIT 0 , 30
57	0.34 ms	SELECT * FROM `seo` WHERE TRUE AND `id_product` = 4790 AND `id_language` = 1 ORDER BY `id` DESC LIMIT 0 , 30
58	0.33 ms	SELECT * FROM `product_photos` WHERE TRUE AND `id_product` = 4790 ORDER BY `id` DESC LIMIT 0 , 30
59	0.36 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` = 4790 ORDER BY s.`id_language` ASC
60	0.55 ms	SELECT * FROM `sub_product` WHERE TRUE AND `id_product` = 4790 AND `type` = 4 ORDER BY `id_language` ASC LIMIT 0 , 30
61	0.46 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.49 ms	SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 4722 AND `id_language` = 1 AND `metaname` = 'title' ORDER BY `id` DESC LIMIT 0 , 30
63	0.31 ms	SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 4722 AND `id_language` = 1 AND `metaname` = 'summary' ORDER BY `id` DESC LIMIT 0 , 30
64	0.4 ms	SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 4722 AND `id_language` = 1 AND `metaname` = 'typeHour' ORDER BY `id` DESC LIMIT 0 , 30
65	0.29 ms	SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 4722 AND `id_language` = 1 AND `metaname` = 'currency' ORDER BY `id` DESC LIMIT 0 , 30
66	0.27 ms	SELECT * FROM `seo` WHERE TRUE AND `id_product` = 4722 AND `id_language` = 1 ORDER BY `id` DESC LIMIT 0 , 30
67	0.35 ms	SELECT * FROM `product_photos` WHERE TRUE AND `id_product` = 4722 ORDER BY `id` DESC LIMIT 0 , 30
68	0.36 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` = 4722 ORDER BY s.`id_language` ASC
69	0.39 ms	SELECT * FROM `sub_product` WHERE TRUE AND `id_product` = 4722 AND `type` = 4 ORDER BY `id_language` ASC LIMIT 0 , 30
70	0.53 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.82 ms	SELECT id_product, metavalue FROM `product_meta` WHERE id_product IN (?,?,?) AND metaname = ? AND id_language = ?
72	0.4 ms	SELECT * FROM `type` WHERE TRUE AND `group` = 'subproduct_blockeddates_block_type' ORDER BY `id` DESC LIMIT 0 , 30
73	0.43 ms	SELECT * FROM `subproduct_blockeddates` WHERE TRUE AND `id_subproduct` = 3808 ORDER BY `date` ASC LIMIT 0 , 30
74	0.5 ms	SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 4782 AND `id_language` = 1 AND `metaname` = 'availability_next_date' ORDER BY `id` DESC LIMIT 0 , 30
75	1720.84 ms	SELECT * FROM `customer_productlog` WHERE TRUE
76	6.04 ms	INSERT INTO `customer_productlog` ( `id` , `content` ) VALUES( NULL , '{\"id_product\":\"4782\",\"id_user\":\"NULL\",\"dateVisited\":1785174599}' )
77	3.62 ms	SELECT * FROM `suppliers` s WHERE TRUE AND s.`id` = 36 ORDER BY `id` DESC
78	2.58 ms	SELECT * FROM `supplier_meta` WHERE TRUE AND `id_supplier` = 36 ORDER BY `id` DESC LIMIT 0 , 1000

Porto: Boat Tour by the Douro River with Wine and Snacks included