All languages services are disabled for this product

Private Motor Boat Experience - De Antonio D28 Yacht in Barcelona 4h

arrow_back

arrow_forward

New Activity

Private Yacht Experience in Barcelona | 4 Hours

Name: Private Yacht Experience in Barcelona | 4 Hours
Brand: Dotravel
Price: 939.00 EUR
Availability: InStock

Duration: 4h

Group: Max 9 people

Feb 07, 2026

Soak up the sun along Barcelona's coastline from the comfort of this private, luxury yacht over the course of four hours.

FROM

€ 939

/pp

About This activity

Fuel costs and taxes

Swim stop in the Mediterranean

Complimentary bottle of cava

Food and snacks

DoTravel

Meeting Point

Moll de Maestral

Experience Barcelona like never before, from the comfort of a luxury, private yacht at sea.

Enjoy stunning views of the Catalan coastline, while sipping on a complimentary bottle of cava with your friends and family. The skipper ensure that you stop off for a swim in the gorgeous waters of the Mediterranean Sea, with the panoramic backdrop of the Barcelona skyline behind you.

When you book a private yacht in Barcelona, your package will include a professional skipper, bottle of cava, fuel costs and taxes - you can simply sit back and enjoy relaxing and taking in the sights.

Book your Barcelona sailing experience today!

Note: Maximum capacity is nine guests.

Fuel costs and taxes

Swim stop in the Mediterranean

Complimentary bottle of cava

Food and snacks

No reviews yet

Professional, experienced skipper
Swim opportunity in the Mediterranean Sea
Panoramic views of the Barcelona skyline

Sunset Sailing Experience Barcelona with Spanish Tapas and Premium Open Bar

New Activity

schedule 2h

Sunset Sailing Experience Barcelona with Spanish Tapas and Premium Open Bar

Set sail on a beautiful Barcelona evening and embrace the stunning sunset views over...

Next available: Feb 07, 2026

activity BOOK IT

FROM

€ 59

/pp

New Activity

schedule 2h 30m

Private - Park Güell Guided Tour

Discover the magic of Gaudí’s Park Güell on a private skip-the-line guided tour....

Next available: Feb 08, 2026

activity BOOK IT

FROM

€ 250

/pp

Sagrada Familia Jamón Iberico Tasting Experience with Cava

New Activity

schedule 1h

Sagrada Familia Jamón Iberico Tasting Experience with Cava

Discover the authentic flavors of Spain and feel like a local, tasting our best...

Next available: Feb 07, 2026

activity BOOK IT

FROM

€ 39

/pp

  DB
  80 queries
  |
  249.53 ms

    Query Log (80 queries, 249.53 ms)
    ×
  

    
    
  
Loading...

          
        #TimeQuery

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

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

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

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

            5
            0.68 ms
            SELECT * FROM `products` p WHERE TRUE AND p.`id` = 4571 ORDER BY `id` DESC
          

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

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

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

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

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

            11
            0.49 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
            0.41 ms
            SELECT * FROM `products` p WHERE TRUE AND p.`id` = 4571 AND p.`status` = '23' ORDER BY `id` DESC
          

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

            14
            0.36 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
            0.54 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.53 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` = 4571 ORDER BY `rating_overall` desc LIMIT 20 , 30
          

            17
            0.31 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.51 ms
            SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 4571 AND `id_language` = 1 ORDER BY `id` DESC LIMIT 0 , 1000
          

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

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

            21
            0.38 ms
            SELECT * FROM `product_system` WHERE TRUE AND `id_product_dotravel` = 4571 ORDER BY `id` DESC
          

            22
            0.49 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
          

            23
            0.49 ms
            SELECT * FROM `sub_product` WHERE TRUE AND `id_product` = 4571 AND `status` = '15' ORDER BY `id` DESC LIMIT 0 , 30
          

            24
            0.38 ms
            SELECT * FROM `product_photos` WHERE TRUE AND `id_product` = 4571 ORDER BY `show_order` asc LIMIT 0 , 30
          

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

            26
            0.32 ms
            SELECT * FROM `sub_product` WHERE TRUE AND `id_product` = 4571 ORDER BY `id` DESC LIMIT 0 , 30
          

            27
            0.4 ms
            SELECT * FROM `product_prices` WHERE TRUE AND `id_subproduct` = 3597 ORDER BY `id` DESC LIMIT 0 , 30
          

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

            29
            0.3 ms
            SELECT * FROM `product_bookingfees` WHERE TRUE AND `id_productprice` = 9880 ORDER BY `id` DESC LIMIT 0 , 30
          

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

            31
            0.37 ms
            SELECT * FROM `sub_product` WHERE TRUE AND `id_product` = 4571 AND `type` = 4 ORDER BY `id_language` ASC LIMIT 0 , 30
          

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

            33
            0.38 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 ='4571'
          

            34
            0.3 ms
            SELECT * FROM `favorites` WHERE TRUE AND `id_product` = 4571 ORDER BY `id` DESC LIMIT 0 , 30
          

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

            36
            0.5 ms
            SELECT pc.id_category as id, cm.name as name, cm.seo_url as seo_url ,(SELECT img_name FROM categories where id = pc.id_category) as img FROM `product_category` AS pc INNER JOIN `category_meta` AS cm ON pc.id_category = cm.id_category WHERE TRUE AND pc.`id_product` = 4571 AND cm.`id_language` = 1...
          

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

            38
            0.33 ms
            SELECT * FROM `languages` WHERE TRUE AND `name` = 'English'
          

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

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

            42
            0.55 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 =...
          

            43
            0.3 ms
            SELECT * FROM `destination_parent` WHERE TRUE AND `id_child` = 1 ORDER BY `id` DESC LIMIT 0 , 30
          

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

            45
            20.41 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 ( 4615,4571 ) AND st.name = 'active' AND st.group = 'suppliers_status' AND p.id IN ( SELECT id_product FROM `product_destination` WHERE id_destination...
          

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

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

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

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

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

            51
            0.37 ms
            SELECT * FROM `product_photos` WHERE TRUE AND `id_product` = 4615 ORDER BY `id` DESC LIMIT 0 , 30
          

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

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

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

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

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

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

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

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

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

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

            62
            0.7 ms
            SELECT * FROM `sub_product` WHERE TRUE AND `id_product` = 4567 AND `type` = 4 ORDER BY `id_language` ASC LIMIT 0 , 30
          

            63
            0.48 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...
          

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

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

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

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

            68
            0.3 ms
            SELECT * FROM `seo` WHERE TRUE AND `id_product` = 4587 AND `id_language` = 1 ORDER BY `id` DESC LIMIT 0 , 30
          

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

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

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

            72
            0.71 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...
          

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

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

            75
            0.33 ms
            SELECT * FROM `subproduct_blockeddates` WHERE TRUE AND `id_subproduct` = 3597 ORDER BY `date` ASC LIMIT 0 , 30
          

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

            77
            0.33 ms
            SELECT * FROM `customer_productlog` WHERE TRUE AND `id` = 711412
          

            78
            2.99 ms
            UPDATE `customer_productlog` SET `id` = 711412 , `content` =...
          

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

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

      

#	Time	Query
1	1.36 ms	SELECT url, namespace, method, content_redirection FROM `redirect` WHERE status = 1
2	3.17 ms	INSERT INTO `log_customer` ( `id` , `id_customer` , `log` , `date` ) VALUES( NULL , NULL ,...
3	0.56 ms	SELECT * FROM `languages` WHERE TRUE AND `short` = 'en'
4	188.3 ms	SELECT * FROM `product_meta` WHERE TRUE AND `id_language` = 1 AND `metaname` = 'redirect_from_id' AND `metavalue` = '4571' ORDER BY `id` DESC LIMIT 0 , 30
5	0.68 ms	SELECT * FROM `products` p WHERE TRUE AND p.`id` = 4571 ORDER BY `id` DESC
6	0.44 ms	SELECT * FROM `type` WHERE TRUE AND `id` = 2 ORDER BY `id` DESC LIMIT 0 , 30
7	0.46 ms	SELECT * FROM `type` WHERE TRUE AND `group` = 'products_product_type' AND `name` = 'activity' ORDER BY `id` DESC LIMIT 0 , 30
8	0.42 ms	SELECT * FROM `sub_product` WHERE TRUE AND `id_product` = 4571 ORDER BY `id_language` DESC LIMIT 0 , 30
9	0.26 ms	SELECT * FROM `languages` WHERE TRUE AND `id` = 1
10	0.26 ms	SELECT * FROM `type` WHERE TRUE AND `id` = 4 ORDER BY `id` DESC LIMIT 0 , 30
11	0.49 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	0.41 ms	SELECT * FROM `products` p WHERE TRUE AND p.`id` = 4571 AND p.`status` = '23' ORDER BY `id` DESC
13	0.32 ms	SELECT * FROM `suppliers` s WHERE TRUE AND s.`id` = 36 ORDER BY `id` DESC
14	0.36 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	0.54 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.53 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` = 4571 ORDER BY `rating_overall` desc LIMIT 20 , 30
17	0.31 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.51 ms	SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 4571 AND `id_language` = 1 ORDER BY `id` DESC LIMIT 0 , 1000
19	0.7 ms	SELECT * FROM `product_system_meta` WHERE TRUE AND `id_product` = 4571 AND `metaname` = 'bookingextranote' ORDER BY `id` DESC LIMIT 0 , 30
20	0.5 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` = 4571 ORDER BY s.`id_language` ASC
21	0.38 ms	SELECT * FROM `product_system` WHERE TRUE AND `id_product_dotravel` = 4571 ORDER BY `id` DESC
22	0.49 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
23	0.49 ms	SELECT * FROM `sub_product` WHERE TRUE AND `id_product` = 4571 AND `status` = '15' ORDER BY `id` DESC LIMIT 0 , 30
24	0.38 ms	SELECT * FROM `product_photos` WHERE TRUE AND `id_product` = 4571 ORDER BY `show_order` asc LIMIT 0 , 30
25	0.39 ms	SELECT * FROM `seo` WHERE TRUE AND `id_product` = 4571 AND `id_language` = 1 ORDER BY `id` DESC LIMIT 0 , 30
26	0.32 ms	SELECT * FROM `sub_product` WHERE TRUE AND `id_product` = 4571 ORDER BY `id` DESC LIMIT 0 , 30
27	0.4 ms	SELECT * FROM `product_prices` WHERE TRUE AND `id_subproduct` = 3597 ORDER BY `id` DESC LIMIT 0 , 30
28	0.28 ms	SELECT * FROM `age_group` WHERE TRUE AND `id` = 1 ORDER BY `id` DESC LIMIT 0 , 30
29	0.3 ms	SELECT * FROM `product_bookingfees` WHERE TRUE AND `id_productprice` = 9880 ORDER BY `id` DESC LIMIT 0 , 30
30	0.32 ms	SELECT * FROM `type` WHERE TRUE AND `group` = 'sub_product_type' AND `name` = 'group' ORDER BY `id` DESC LIMIT 0 , 30
31	0.37 ms	SELECT * FROM `sub_product` WHERE TRUE AND `id_product` = 4571 AND `type` = 4 ORDER BY `id_language` ASC LIMIT 0 , 30
32	0.29 ms	SELECT * FROM `product_advantage` WHERE TRUE AND `id_product` = 4571 ORDER BY `id` DESC LIMIT 0 , 30
33	0.38 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 ='4571'
34	0.3 ms	SELECT * FROM `favorites` WHERE TRUE AND `id_product` = 4571 ORDER BY `id` DESC LIMIT 0 , 30
35	0.42 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
36	0.5 ms	SELECT pc.id_category as id, cm.name as name, cm.seo_url as seo_url ,(SELECT img_name FROM categories where id = pc.id_category) as img FROM `product_category` AS pc INNER JOIN `category_meta` AS cm ON pc.id_category = cm.id_category WHERE TRUE AND pc.`id_product` = 4571 AND cm.`id_language` = 1...
37	0.38 ms	SELECT * FROM `product_photos` WHERE TRUE AND `id_product` = 4571 ORDER BY `show_order` ASC LIMIT 0 , 30
38	0.33 ms	SELECT * FROM `languages` WHERE TRUE AND `name` = 'English'
39	0.41 ms	SELECT * FROM `destination_parent` WHERE TRUE AND `id_child` = 7 ORDER BY `id` DESC LIMIT 0 , 30
40	0.5 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.38 ms	SELECT * FROM `destination_parent` WHERE TRUE AND `id_child` = 3 ORDER BY `id` DESC LIMIT 0 , 30
42	0.55 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 =...
43	0.3 ms	SELECT * FROM `destination_parent` WHERE TRUE AND `id_child` = 1 ORDER BY `id` DESC LIMIT 0 , 30
44	0.59 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` = 4571 AND p.`status` = 23 AND s.`status` = 10 ORDER BY `id` DESC LIMIT 0 , 3
45	20.41 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 ( 4615,4571 ) AND st.name = 'active' AND st.group = 'suppliers_status' AND p.id IN ( SELECT id_product FROM `product_destination` WHERE id_destination...
46	0.71 ms	SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 4615 AND `id_language` = 1 AND `metaname` = 'title' ORDER BY `id` DESC LIMIT 0 , 30
47	0.42 ms	SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 4615 AND `id_language` = 1 AND `metaname` = 'summary' ORDER BY `id` DESC LIMIT 0 , 30
48	0.37 ms	SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 4615 AND `id_language` = 1 AND `metaname` = 'typeHour' ORDER BY `id` DESC LIMIT 0 , 30
49	0.39 ms	SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 4615 AND `id_language` = 1 AND `metaname` = 'currency' ORDER BY `id` DESC LIMIT 0 , 30
50	0.34 ms	SELECT * FROM `seo` WHERE TRUE AND `id_product` = 4615 AND `id_language` = 1 ORDER BY `id` DESC LIMIT 0 , 30
51	0.37 ms	SELECT * FROM `product_photos` WHERE TRUE AND `id_product` = 4615 ORDER BY `id` DESC LIMIT 0 , 30
52	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` = 4615 ORDER BY s.`id_language` ASC
53	0.87 ms	SELECT * FROM `sub_product` WHERE TRUE AND `id_product` = 4615 AND `type` = 4 ORDER BY `id_language` ASC LIMIT 0 , 30
54	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...
55	0.57 ms	SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 4567 AND `id_language` = 1 AND `metaname` = 'title' ORDER BY `id` DESC LIMIT 0 , 30
56	0.45 ms	SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 4567 AND `id_language` = 1 AND `metaname` = 'summary' ORDER BY `id` DESC LIMIT 0 , 30
57	0.47 ms	SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 4567 AND `id_language` = 1 AND `metaname` = 'typeHour' ORDER BY `id` DESC LIMIT 0 , 30
58	0.45 ms	SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 4567 AND `id_language` = 1 AND `metaname` = 'currency' ORDER BY `id` DESC LIMIT 0 , 30
59	0.39 ms	SELECT * FROM `seo` WHERE TRUE AND `id_product` = 4567 AND `id_language` = 1 ORDER BY `id` DESC LIMIT 0 , 30
60	0.38 ms	SELECT * FROM `product_photos` WHERE TRUE AND `id_product` = 4567 ORDER BY `id` DESC LIMIT 0 , 30
61	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` = 4567 ORDER BY s.`id_language` ASC
62	0.7 ms	SELECT * FROM `sub_product` WHERE TRUE AND `id_product` = 4567 AND `type` = 4 ORDER BY `id_language` ASC LIMIT 0 , 30
63	0.48 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...
64	0.47 ms	SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 4587 AND `id_language` = 1 AND `metaname` = 'title' ORDER BY `id` DESC LIMIT 0 , 30
65	0.31 ms	SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 4587 AND `id_language` = 1 AND `metaname` = 'summary' ORDER BY `id` DESC LIMIT 0 , 30
66	0.28 ms	SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 4587 AND `id_language` = 1 AND `metaname` = 'typeHour' ORDER BY `id` DESC LIMIT 0 , 30
67	0.3 ms	SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 4587 AND `id_language` = 1 AND `metaname` = 'currency' ORDER BY `id` DESC LIMIT 0 , 30
68	0.3 ms	SELECT * FROM `seo` WHERE TRUE AND `id_product` = 4587 AND `id_language` = 1 ORDER BY `id` DESC LIMIT 0 , 30
69	0.35 ms	SELECT * FROM `product_photos` WHERE TRUE AND `id_product` = 4587 ORDER BY `id` DESC LIMIT 0 , 30
70	0.4 ms	SELECT pr.price as min FROM `product_prices` as pr INNER JOIN `sub_product` AS s ON s.id = pr.id_subproduct INNER JOIN `age_group` AS a ON a.id = pr.id_agegroup -- WHERE a.show_order = 1 AND s.`id_product` = 4587 ORDER BY s.`id_language` ASC
71	0.75 ms	SELECT * FROM `sub_product` WHERE TRUE AND `id_product` = 4587 AND `type` = 4 ORDER BY `id_language` ASC LIMIT 0 , 30
72	0.71 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...
73	0.75 ms	SELECT id_product, metavalue FROM `product_meta` WHERE id_product IN (?,?,?) AND metaname = ? AND id_language = ?
74	0.4 ms	SELECT * FROM `type` WHERE TRUE AND `group` = 'subproduct_blockeddates_block_type' ORDER BY `id` DESC LIMIT 0 , 30
75	0.33 ms	SELECT * FROM `subproduct_blockeddates` WHERE TRUE AND `id_subproduct` = 3597 ORDER BY `date` ASC LIMIT 0 , 30
76	0.63 ms	SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 4571 AND `id_language` = 1 AND `metaname` = 'availability_next_date' ORDER BY `id` DESC LIMIT 0 , 30
77	0.33 ms	SELECT * FROM `customer_productlog` WHERE TRUE AND `id` = 711412
78	2.99 ms	UPDATE `customer_productlog` SET `id` = 711412 , `content` =...
79	0.4 ms	SELECT * FROM `suppliers` s WHERE TRUE AND s.`id` = 36 ORDER BY `id` DESC
80	0.48 ms	SELECT * FROM `supplier_meta` WHERE TRUE AND `id_supplier` = 36 ORDER BY `id` DESC LIMIT 0 , 1000

Private Yacht Experience in Barcelona | 4 Hours