Discover Lisbon: Sunset Tagus River Sailing Tour

arrow_back

arrow_forward

New Activity

Discover Lisbon: Sunset Tagus River Sailing Tour

Name: Discover Lisbon: Sunset Tagus River Sailing Tour
Brand: Dotravel
Price: 33.59 EUR
Availability: InStock

Duration: 2h

Group: Max 10 people

Jul 11, 2026

FROM

€ 34

/pp

About This activity

DoTravel

Meeting Point

Portugal

Welcome to Lisbon, where the ocean meets the city! If you're looking for an unforgettable adventure, a sailing tour is the perfect way to explore the stunning coastline of Lisbon.
As you set sail on our comfortable 12-meter sailboat, you'll be greeted with breathtaking views of the city's famous landmarks, such as the Belém Tower and the Monument to the Discoveries, or Comércio Square. Feel the salty breeze in your hair as you cruise along the Tagus River and enjoy the stunning scenery of Lisbon from a unique perspective.

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 2h

Food Walk Tour Bangalore

Next available: May 17, 2026

activity BOOK IT

FROM

€ 22

/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
  78 queries
  |
  1986.38 ms

    Query Log (78 queries, 1986.38 ms)
    ×
  

    
    
  
Loading...

          
        #TimeQuery

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

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

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

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

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

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

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

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

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

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

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

            12
            0.4 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` = 4790 AND p.`status` = '23' ORDER BY `id` DESC
          

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

            15
            0.5 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
            2.13 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.55 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` = 4790 ORDER BY `rating_overall` desc LIMIT 20 , 30
          

            18
            0.32 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.48 ms
            SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 4790 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` = 4790 AND `metaname` = 'bookingextranote' ORDER BY `id` DESC LIMIT 0 , 30
          

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

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

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

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

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

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

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

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

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

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

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

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

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

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

            36
            0.37 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.52 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` = 4790 AND cm.`id_language` = 1...
          

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

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

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

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

            43
            21.02 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 ( 4790 ) 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.77 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
          

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

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

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

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

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

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

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

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

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

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

            56
            0.41 ms
            SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 4785 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` = 4785 AND `id_language` = 1 ORDER BY `id` DESC LIMIT 0 , 30
          

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

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

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

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

            63
            0.42 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
          

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

            65
            0.38 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
          

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

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

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

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

            70
            0.59 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.79 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.34 ms
            SELECT * FROM `subproduct_blockeddates` WHERE TRUE AND `id_subproduct` = 3816 ORDER BY `date` ASC LIMIT 0 , 30
          

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

            75
            1677.11 ms
            SELECT * FROM `customer_productlog` WHERE TRUE
          

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

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

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

      

#	Time	Query
1	2.26 ms	SELECT url, namespace, method, content_redirection FROM `redirect` WHERE status = 1
2	5.77 ms	INSERT INTO `log_customer` ( `id` , `id_customer` , `log` , `date` ) VALUES( NULL , NULL ,...
3	0.43 ms	SELECT * FROM `languages` WHERE TRUE AND `short` = 'en'
4	0.66 ms	SELECT * FROM `languages` WHERE TRUE AND `name` = 'English'
5	219.97 ms	SELECT * FROM `product_meta` WHERE TRUE AND `id_language` = 1 AND `metaname` = 'redirect_from_id' AND `metavalue` = '4790' ORDER BY `id` DESC LIMIT 0 , 30
6	0.55 ms	SELECT * FROM `products` p WHERE TRUE AND p.`id` = 4790 ORDER BY `id` DESC
7	0.29 ms	SELECT * FROM `type` WHERE TRUE AND `id` = 2 ORDER BY `id` DESC LIMIT 0 , 30
8	0.35 ms	SELECT * FROM `type` WHERE TRUE AND `group` = 'products_product_type' AND `name` = 'activity' ORDER BY `id` DESC LIMIT 0 , 30
9	0.37 ms	SELECT * FROM `sub_product` WHERE TRUE AND `id_product` = 4790 ORDER BY `id_language` DESC LIMIT 0 , 30
10	0.21 ms	SELECT * FROM `languages` WHERE TRUE AND `id` = 1
11	0.25 ms	SELECT * FROM `type` WHERE TRUE AND `id` = 4 ORDER BY `id` DESC LIMIT 0 , 30
12	0.4 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` = 4790 AND p.`status` = '23' ORDER BY `id` DESC
14	0.26 ms	SELECT * FROM `suppliers` s WHERE TRUE AND s.`id` = 36 ORDER BY `id` DESC
15	0.5 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	2.13 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.55 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` = 4790 ORDER BY `rating_overall` desc LIMIT 20 , 30
18	0.32 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.48 ms	SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 4790 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` = 4790 AND `metaname` = 'bookingextranote' ORDER BY `id` DESC LIMIT 0 , 30
21	0.48 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
22	0.33 ms	SELECT * FROM `product_system` WHERE TRUE AND `id_product_dotravel` = 4790 ORDER BY `id` DESC
23	0.43 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.34 ms	SELECT * FROM `sub_product` WHERE TRUE AND `id_product` = 4790 AND `status` = '15' ORDER BY `id` DESC LIMIT 0 , 30
25	0.44 ms	SELECT * FROM `product_photos` WHERE TRUE AND `id_product` = 4790 ORDER BY `show_order` asc LIMIT 0 , 30
26	0.39 ms	SELECT * FROM `seo` WHERE TRUE AND `id_product` = 4790 AND `id_language` = 1 ORDER BY `id` DESC LIMIT 0 , 30
27	2.19 ms	SELECT * FROM `sub_product` WHERE TRUE AND `id_product` = 4790 ORDER BY `id` DESC LIMIT 0 , 30
28	0.5 ms	SELECT * FROM `product_prices` WHERE TRUE AND `id_subproduct` = 3816 ORDER BY `id` DESC LIMIT 0 , 30
29	0.35 ms	SELECT * FROM `age_group` WHERE TRUE AND `id` = 1 ORDER BY `id` DESC LIMIT 0 , 30
30	0.34 ms	SELECT * FROM `product_bookingfees` WHERE TRUE AND `id_productprice` = 10080 ORDER BY `id` DESC LIMIT 0 , 30
31	0.37 ms	SELECT * FROM `type` WHERE TRUE AND `group` = 'sub_product_type' AND `name` = 'group' ORDER BY `id` DESC LIMIT 0 , 30
32	0.33 ms	SELECT * FROM `sub_product` WHERE TRUE AND `id_product` = 4790 AND `type` = 4 ORDER BY `id_language` ASC LIMIT 0 , 30
33	0.24 ms	SELECT * FROM `product_advantage` WHERE TRUE AND `id_product` = 4790 ORDER BY `id` DESC LIMIT 0 , 30
34	0.39 ms	SELECT short_description, image_name,image_path, id_language, name FROM `label_products` LEFT JOIN labels lb on lb.id = id_label LEFT JOIN labels_meta lm on lm.id_label = label_products.id_label where id_product ='4790'
35	0.31 ms	SELECT * FROM `favorites` WHERE TRUE AND `id_product` = 4790 ORDER BY `id` DESC LIMIT 0 , 30
36	0.37 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.52 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` = 4790 AND cm.`id_language` = 1...
38	0.39 ms	SELECT * FROM `product_photos` WHERE TRUE AND `id_product` = 4790 ORDER BY `show_order` ASC LIMIT 0 , 30
39	0.37 ms	SELECT * FROM `destination_parent` WHERE TRUE AND `id_child` = 106 ORDER BY `id` DESC LIMIT 0 , 30
40	1.72 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.32 ms	SELECT * FROM `destination_parent` WHERE TRUE AND `id_child` = 104 ORDER BY `id` DESC LIMIT 0 , 30
42	0.48 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` = 4790 AND p.`status` = 23 AND s.`status` = 10 ORDER BY `id` DESC LIMIT 0 , 3
43	21.02 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 ( 4790 ) 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.77 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
45	0.54 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
46	0.46 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
47	0.41 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
48	0.32 ms	SELECT * FROM `seo` WHERE TRUE AND `id_product` = 4764 AND `id_language` = 1 ORDER BY `id` DESC LIMIT 0 , 30
49	0.33 ms	SELECT * FROM `product_photos` WHERE TRUE AND `id_product` = 4764 ORDER BY `id` DESC LIMIT 0 , 30
50	0.41 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
51	0.91 ms	SELECT * FROM `sub_product` WHERE TRUE AND `id_product` = 4764 AND `type` = 4 ORDER BY `id_language` ASC LIMIT 0 , 30
52	0.66 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.57 ms	SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 4785 AND `id_language` = 1 AND `metaname` = 'title' ORDER BY `id` DESC LIMIT 0 , 30
54	0.48 ms	SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 4785 AND `id_language` = 1 AND `metaname` = 'summary' ORDER BY `id` DESC LIMIT 0 , 30
55	0.42 ms	SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 4785 AND `id_language` = 1 AND `metaname` = 'typeHour' ORDER BY `id` DESC LIMIT 0 , 30
56	0.41 ms	SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 4785 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` = 4785 AND `id_language` = 1 ORDER BY `id` DESC LIMIT 0 , 30
58	0.38 ms	SELECT * FROM `product_photos` WHERE TRUE AND `id_product` = 4785 ORDER BY `id` DESC LIMIT 0 , 30
59	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` = 4785 ORDER BY s.`id_language` ASC
60	0.72 ms	SELECT * FROM `sub_product` WHERE TRUE AND `id_product` = 4785 AND `type` = 4 ORDER BY `id_language` ASC LIMIT 0 , 30
61	0.6 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.52 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
63	0.42 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
64	0.42 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
65	0.38 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
66	0.33 ms	SELECT * FROM `seo` WHERE TRUE AND `id_product` = 4784 AND `id_language` = 1 ORDER BY `id` DESC LIMIT 0 , 30
67	0.35 ms	SELECT * FROM `product_photos` WHERE TRUE AND `id_product` = 4784 ORDER BY `id` DESC LIMIT 0 , 30
68	0.45 ms	SELECT pr.price as min FROM `product_prices` as pr INNER JOIN `sub_product` AS s ON s.id = pr.id_subproduct INNER JOIN `age_group` AS a ON a.id = pr.id_agegroup -- WHERE a.show_order = 1 AND s.`id_product` = 4784 ORDER BY s.`id_language` ASC
69	0.75 ms	SELECT * FROM `sub_product` WHERE TRUE AND `id_product` = 4784 AND `type` = 4 ORDER BY `id_language` ASC LIMIT 0 , 30
70	0.59 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.79 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.34 ms	SELECT * FROM `subproduct_blockeddates` WHERE TRUE AND `id_subproduct` = 3816 ORDER BY `date` ASC LIMIT 0 , 30
74	0.47 ms	SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 4790 AND `id_language` = 1 AND `metaname` = 'availability_next_date' ORDER BY `id` DESC LIMIT 0 , 30
75	1677.11 ms	SELECT * FROM `customer_productlog` WHERE TRUE
76	22.72 ms	INSERT INTO `customer_productlog` ( `id` , `content` ) VALUES( NULL , '{\"id_product\":\"4790\",\"id_user\":\"NULL\",\"dateVisited\":1785174599}' )
77	1.41 ms	SELECT * FROM `suppliers` s WHERE TRUE AND s.`id` = 36 ORDER BY `id` DESC
78	0.61 ms	SELECT * FROM `supplier_meta` WHERE TRUE AND `id_supplier` = 36 ORDER BY `id` DESC LIMIT 0 , 1000

Discover Lisbon: Sunset Tagus River Sailing Tour