arrow_back

arrow_forward

Next available: May 19, 2026

New Activity

Arrábida Snorkeling & Wine

Name: Arrábida Snorkeling & Wine
Brand: Dotravel
Price: 119.45 EUR
Availability: InStock

ACTIVITY

Duration: 8h

Hosted in: EN

Arrábida Snorkeling & Wine

Next available: May 19, 2026

New Activity

€ 119^.45

About This Activity

Free Cancellation
Cancel up to 24 hours in advance for a full refund

Instant Confirmation

Mobile Voucher

Printed Voucher

Monday - Sunday

Group: Max10 people

DoTravel

What you'll do

Dive into a world of crystal waters, where you can see the marine life in their untouched and protected habitat, the Arrábida National Reserve Park, and relax after with a wine tasting in a historic cellar on this full-day snorkeling and wine adventure from Lisbon. Read more

Meeting Point

Portugal

Activity

Discovery Walk in Porto’s Old Town: Alleys, Views and Tales

New Activity

€ 26^.00

Check Availability

Activity

Whales & Sea Angling

New Activity

€ 190^.66

Check Availability

Activity

Spiritual Walk Tour (The Krishna Story)

New Activity

€ 11^.61

Check Availability

Categories

Food & Drink

Adventure

Wildlife

Home / Spain / Porto / Arrábida Snorkeling & Wine

  DB
  76 queries
  |
  1319.56 ms

    Query Log (76 queries, 1319.56 ms)
    ×
  

    
    
  
Loading...

          
        #TimeQuery

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

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

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

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

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

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

            7
            0.43 ms
            SELECT * FROM `sub_product` WHERE TRUE AND `id_product` = 4783 ORDER BY `id_language` DESC LIMIT 0 , 30
          

            8
            0.3 ms
            SELECT * FROM `languages` WHERE TRUE AND `id` = 1
          

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

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

            11
            0.39 ms
            SELECT * FROM `products` p WHERE TRUE AND p.`id` = 4783 AND p.`status` = '23' ORDER BY `id` DESC
          

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

            13
            0.32 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
          

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

            15
            0.6 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` = 4783 ORDER BY `rating_overall` desc LIMIT 20 , 30
          

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

            17
            0.58 ms
            SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 4783 AND `id_language` = 1 ORDER BY `id` DESC LIMIT 0 , 1000
          

            18
            0.89 ms
            SELECT * FROM `product_system_meta` WHERE TRUE AND `id_product` = 4783 AND `metaname` = 'bookingextranote' ORDER BY `id` DESC LIMIT 0 , 30
          

            19
            0.72 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` = 4783 ORDER BY s.`id_language` ASC
          

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

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

            22
            0.53 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.45 ms
            SELECT * FROM `sub_product` WHERE TRUE AND `id_product` = 4783 AND `status` = '15' ORDER BY `id` DESC LIMIT 0 , 30
          

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

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

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

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

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

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

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

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

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

            33
            0.49 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 ='4783'
          

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

            35
            0.46 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.57 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` = 4783 AND cm.`id_language` = 1...
          

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

            38
            1.26 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 =...
          

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

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

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

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

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

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

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

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

            47
            1.54 ms
            SELECT * FROM `seo` WHERE TRUE AND `id_product` = 4723 AND `id_language` = 1 ORDER BY `id` DESC LIMIT 0 , 30
          

            48
            0.6 ms
            SELECT * FROM `product_photos` WHERE TRUE AND `id_product` = 4723 ORDER BY `id` DESC LIMIT 0 , 30
          

            49
            0.54 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` = 4723 ORDER BY s.`id_language` ASC
          

            50
            0.6 ms
            SELECT * FROM `sub_product` WHERE TRUE AND `id_product` = 4723 AND `type` = 4 ORDER BY `id_language` ASC LIMIT 0 , 30
          

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

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

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

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

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

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

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

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

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

            60
            0.52 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...
          

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

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

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

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

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

            66
            0.42 ms
            SELECT * FROM `product_photos` WHERE TRUE AND `id_product` = 4789 ORDER BY `id` DESC LIMIT 0 , 30
          

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

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

            69
            0.56 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...
          

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

            71
            0.36 ms
            SELECT * FROM `subproduct_blockeddates` WHERE TRUE AND `id_subproduct` = 3809 ORDER BY `date` ASC LIMIT 0 , 30
          

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

            73
            1046.46 ms
            SELECT * FROM `customer_productlog` WHERE TRUE
          

            74
            4.25 ms
            INSERT INTO `customer_productlog` ( `id` , `content` ) VALUES( NULL , '{\"id_product\":\"4783\",\"id_user\":\"NULL\",\"dateVisited\":1779117972}' )
          

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

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

      

#	Time	Query
1	1.72 ms	SELECT url, namespace, method, content_redirection FROM `redirect` WHERE status = 1
2	5.94 ms	INSERT INTO `log_customer` ( `id` , `id_customer` , `log` , `date` ) VALUES( NULL , NULL ,...
3	0.36 ms	SELECT * FROM `languages` WHERE TRUE AND `short` = 'en'
4	0.85 ms	SELECT * FROM `languages` WHERE TRUE AND `name` = 'English'
5	201.06 ms	SELECT * FROM `product_meta` WHERE TRUE AND `id_language` = 1 AND `metaname` = 'redirect_from_id' AND `metavalue` = '4783' ORDER BY `id` DESC LIMIT 0 , 30
6	0.63 ms	SELECT * FROM `type` WHERE TRUE AND `group` = 'products_product_type' AND `name` = 'activity' ORDER BY `id` DESC LIMIT 0 , 30
7	0.43 ms	SELECT * FROM `sub_product` WHERE TRUE AND `id_product` = 4783 ORDER BY `id_language` DESC LIMIT 0 , 30
8	0.3 ms	SELECT * FROM `languages` WHERE TRUE AND `id` = 1
9	0.23 ms	SELECT * FROM `type` WHERE TRUE AND `id` = 4 ORDER BY `id` DESC LIMIT 0 , 30
10	0.41 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
11	0.39 ms	SELECT * FROM `products` p WHERE TRUE AND p.`id` = 4783 AND p.`status` = '23' ORDER BY `id` DESC
12	0.36 ms	SELECT * FROM `suppliers` s WHERE TRUE AND s.`id` = 36 ORDER BY `id` DESC
13	0.32 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
14	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...
15	0.6 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` = 4783 ORDER BY `rating_overall` desc LIMIT 20 , 30
16	0.41 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
17	0.58 ms	SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 4783 AND `id_language` = 1 ORDER BY `id` DESC LIMIT 0 , 1000
18	0.89 ms	SELECT * FROM `product_system_meta` WHERE TRUE AND `id_product` = 4783 AND `metaname` = 'bookingextranote' ORDER BY `id` DESC LIMIT 0 , 30
19	0.72 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` = 4783 ORDER BY s.`id_language` ASC
20	0.44 ms	SELECT * FROM `type` WHERE TRUE AND `id` = 2 ORDER BY `id` DESC LIMIT 0 , 30
21	0.36 ms	SELECT * FROM `product_system` WHERE TRUE AND `id_product_dotravel` = 4783 ORDER BY `id` DESC
22	0.53 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.45 ms	SELECT * FROM `sub_product` WHERE TRUE AND `id_product` = 4783 AND `status` = '15' ORDER BY `id` DESC LIMIT 0 , 30
24	0.51 ms	SELECT * FROM `product_photos` WHERE TRUE AND `id_product` = 4783 ORDER BY `show_order` asc LIMIT 0 , 30
25	0.43 ms	SELECT * FROM `seo` WHERE TRUE AND `id_product` = 4783 AND `id_language` = 1 ORDER BY `id` DESC LIMIT 0 , 30
26	0.41 ms	SELECT * FROM `sub_product` WHERE TRUE AND `id_product` = 4783 ORDER BY `id` DESC LIMIT 0 , 30
27	0.37 ms	SELECT * FROM `product_prices` WHERE TRUE AND `id_subproduct` = 3809 ORDER BY `id` DESC LIMIT 0 , 30
28	0.47 ms	SELECT * FROM `age_group` WHERE TRUE ORDER BY `id` DESC LIMIT 0 , 30
29	0.32 ms	SELECT * FROM `product_bookingfees` WHERE TRUE ORDER BY `id` DESC LIMIT 0 , 30
30	0.34 ms	SELECT * FROM `type` WHERE TRUE AND `group` = 'sub_product_type' AND `name` = 'group' ORDER BY `id` DESC LIMIT 0 , 30
31	0.7 ms	SELECT * FROM `sub_product` WHERE TRUE AND `id_product` = 4783 AND `type` = 4 ORDER BY `id_language` ASC LIMIT 0 , 30
32	0.39 ms	SELECT * FROM `product_advantage` WHERE TRUE AND `id_product` = 4783 ORDER BY `id` DESC LIMIT 0 , 30
33	0.49 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 ='4783'
34	0.35 ms	SELECT * FROM `favorites` WHERE TRUE AND `id_product` = 4783 ORDER BY `id` DESC LIMIT 0 , 30
35	0.46 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.57 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` = 4783 AND cm.`id_language` = 1...
37	0.71 ms	SELECT * FROM `product_photos` WHERE TRUE AND `id_product` = 4783 ORDER BY `show_order` ASC LIMIT 0 , 30
38	1.26 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 =...
39	0.42 ms	SELECT * FROM `destination_parent` WHERE TRUE AND `id_child` = 106 ORDER BY `id` DESC LIMIT 0 , 30
40	0.33 ms	SELECT * FROM `destination_parent` WHERE TRUE AND `id_child` = 104 ORDER BY `id` DESC LIMIT 0 , 30
41	0.64 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` = 4783 AND p.`status` = 23 AND s.`status` = 10 ORDER BY `id` DESC LIMIT 0 , 3
42	23.4 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 ( 4783 ) AND st.name = 'active' AND st.group = 'suppliers_status' AND p.id IN ( SELECT id_product FROM `product_destination` WHERE id_destination IN...
43	0.73 ms	SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 4723 AND `id_language` = 1 AND `metaname` = 'title' ORDER BY `id` DESC LIMIT 0 , 30
44	1.21 ms	SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 4723 AND `id_language` = 1 AND `metaname` = 'summary' ORDER BY `id` DESC LIMIT 0 , 30
45	0.49 ms	SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 4723 AND `id_language` = 1 AND `metaname` = 'typeHour' ORDER BY `id` DESC LIMIT 0 , 30
46	0.62 ms	SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 4723 AND `id_language` = 1 AND `metaname` = 'currency' ORDER BY `id` DESC LIMIT 0 , 30
47	1.54 ms	SELECT * FROM `seo` WHERE TRUE AND `id_product` = 4723 AND `id_language` = 1 ORDER BY `id` DESC LIMIT 0 , 30
48	0.6 ms	SELECT * FROM `product_photos` WHERE TRUE AND `id_product` = 4723 ORDER BY `id` DESC LIMIT 0 , 30
49	0.54 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` = 4723 ORDER BY s.`id_language` ASC
50	0.6 ms	SELECT * FROM `sub_product` WHERE TRUE AND `id_product` = 4723 AND `type` = 4 ORDER BY `id_language` ASC LIMIT 0 , 30
51	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...
52	0.57 ms	SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 4761 AND `id_language` = 1 AND `metaname` = 'title' ORDER BY `id` DESC LIMIT 0 , 30
53	0.48 ms	SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 4761 AND `id_language` = 1 AND `metaname` = 'summary' ORDER BY `id` DESC LIMIT 0 , 30
54	0.48 ms	SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 4761 AND `id_language` = 1 AND `metaname` = 'typeHour' ORDER BY `id` DESC LIMIT 0 , 30
55	0.42 ms	SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 4761 AND `id_language` = 1 AND `metaname` = 'currency' ORDER BY `id` DESC LIMIT 0 , 30
56	0.48 ms	SELECT * FROM `seo` WHERE TRUE AND `id_product` = 4761 AND `id_language` = 1 ORDER BY `id` DESC LIMIT 0 , 30
57	0.36 ms	SELECT * FROM `product_photos` WHERE TRUE AND `id_product` = 4761 ORDER BY `id` DESC LIMIT 0 , 30
58	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` = 4761 ORDER BY s.`id_language` ASC
59	0.47 ms	SELECT * FROM `sub_product` WHERE TRUE AND `id_product` = 4761 AND `type` = 4 ORDER BY `id_language` ASC LIMIT 0 , 30
60	0.52 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...
61	0.48 ms	SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 4789 AND `id_language` = 1 AND `metaname` = 'title' ORDER BY `id` DESC LIMIT 0 , 30
62	0.52 ms	SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 4789 AND `id_language` = 1 AND `metaname` = 'summary' ORDER BY `id` DESC LIMIT 0 , 30
63	0.39 ms	SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 4789 AND `id_language` = 1 AND `metaname` = 'typeHour' ORDER BY `id` DESC LIMIT 0 , 30
64	0.38 ms	SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 4789 AND `id_language` = 1 AND `metaname` = 'currency' ORDER BY `id` DESC LIMIT 0 , 30
65	0.34 ms	SELECT * FROM `seo` WHERE TRUE AND `id_product` = 4789 AND `id_language` = 1 ORDER BY `id` DESC LIMIT 0 , 30
66	0.42 ms	SELECT * FROM `product_photos` WHERE TRUE AND `id_product` = 4789 ORDER BY `id` DESC LIMIT 0 , 30
67	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` = 4789 ORDER BY s.`id_language` ASC
68	0.55 ms	SELECT * FROM `sub_product` WHERE TRUE AND `id_product` = 4789 AND `type` = 4 ORDER BY `id_language` ASC LIMIT 0 , 30
69	0.56 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...
70	0.37 ms	SELECT * FROM `type` WHERE TRUE AND `group` = 'subproduct_blockeddates_block_type' ORDER BY `id` DESC LIMIT 0 , 30
71	0.36 ms	SELECT * FROM `subproduct_blockeddates` WHERE TRUE AND `id_subproduct` = 3809 ORDER BY `date` ASC LIMIT 0 , 30
72	0.5 ms	SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 4783 AND `id_language` = 1 AND `metaname` = 'availability_next_date' ORDER BY `id` DESC LIMIT 0 , 30
73	1046.46 ms	SELECT * FROM `customer_productlog` WHERE TRUE
74	4.25 ms	INSERT INTO `customer_productlog` ( `id` , `content` ) VALUES( NULL , '{\"id_product\":\"4783\",\"id_user\":\"NULL\",\"dateVisited\":1779117972}' )
75	0.45 ms	SELECT * FROM `suppliers` s WHERE TRUE AND s.`id` = 36 ORDER BY `id` DESC
76	0.86 ms	SELECT * FROM `supplier_meta` WHERE TRUE AND `id_supplier` = 36 ORDER BY `id` DESC LIMIT 0 , 1000

Arrábida Snorkeling & Wine

Arrábida Snorkeling & Wine

What you'll do

Meeting Point

You might also like

Categories