arrow_back

arrow_forward

New Activity

Arrábida Snorkeling & Wine

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

Duration: 8h

Group: Max 10 people

May 19, 2026

FROM

€ 122

/pp

About This activity

DoTravel

Meeting Point

Portugal

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.

No reviews yet

Golden Circle and Waterfalls, with Friðheimar Farm and Kerið in small group

New Activity

schedule 9h

Golden Circle and Waterfalls, with Friðheimar Farm and Kerið in small group

Discover Iceland's Golden Circle: Thingvellir National Park and Oxararfoss, Geysir...

Next available: May 21, 2026

activity BOOK IT

FROM

€ 125

/pp

Discovery Walk in Porto’s Vila Nova de Gaia - views & Port wines!

New Activity

schedule 2h

Discovery Walk in Porto’s Vila Nova de Gaia - views & Port wines!

Explore Vila Nova de Gaia with a self-guided walk across the Douro, solving riddles to...

Next available: Feb 06, 2026

activity BOOK IT

FROM

€ 26

/pp

Private tour: half day kayak to Moreno Lake

New Activity

schedule 4h

Private tour: half day kayak to Moreno Lake

Next available: Jun 16, 2026

activity BOOK IT

FROM

€ 310

/pp

  DB
  79 queries
  |
  1283.65 ms

    Query Log (79 queries, 1283.65 ms)
    ×
  

    
    
  
Loading...

          
        #TimeQuery

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

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

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

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

            5
            124.01 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.29 ms
            SELECT * FROM `products` p WHERE TRUE AND p.`id` = 4783 ORDER BY `id` DESC
          

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

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

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

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

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

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

            15
            0.21 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.31 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
          

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

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

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

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

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

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

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

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

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

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

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

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

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

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

            34
            0.28 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'
          

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

            36
            0.28 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.39 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...
          

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

            39
            1.04 ms
            SELECT d.*, d.cdn_image_uuid, d.cdn_variants, d.cdn_processing_status, d.use_cdn, m.id_language, m.name, m.description, m.summary, m.seo_title, m.seo_description, m.seo_keywords, m.seo_url, m.img_alt, m.faqs, m.index_content FROM `destinations` AS d INNER JOIN `destination_meta` AS m on d.id =...
          

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

            41
            0.32 ms
            SELECT destinations.id, destination_meta.name,seo_url FROM `destinations` join destination_meta on destination_meta.id_destination = destinations.id join destination_parent on destination_parent.id_parent = destinations.id where true AND destinations.status = 24 AND destination_meta.id_language =...
          

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

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

            44
            14.06 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...
          

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

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

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

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

            49
            0.31 ms
            SELECT * FROM `seo` WHERE TRUE AND `id_product` = 4781 AND `id_language` = 1 ORDER BY `id` DESC LIMIT 0 , 30
          

            50
            0.43 ms
            SELECT * FROM `product_photos` WHERE TRUE AND `id_product` = 4781 ORDER BY `id` DESC LIMIT 0 , 30
          

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

            52
            0.34 ms
            SELECT * FROM `sub_product` WHERE TRUE AND `id_product` = 4781 AND `type` = 4 ORDER BY `id_language` ASC LIMIT 0 , 30
          

            53
            0.36 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...
          

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

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

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

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

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

            59
            0.29 ms
            SELECT * FROM `product_photos` WHERE TRUE AND `id_product` = 4752 ORDER BY `id` DESC LIMIT 0 , 30
          

            60
            0.32 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` = 4752 ORDER BY s.`id_language` ASC
          

            61
            0.71 ms
            SELECT * FROM `sub_product` WHERE TRUE AND `id_product` = 4752 AND `type` = 4 ORDER BY `id_language` ASC LIMIT 0 , 30
          

            62
            1.06 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...
          

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

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

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

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

            67
            0.63 ms
            SELECT * FROM `seo` WHERE TRUE AND `id_product` = 4786 AND `id_language` = 1 ORDER BY `id` DESC LIMIT 0 , 30
          

            68
            0.32 ms
            SELECT * FROM `product_photos` WHERE TRUE AND `id_product` = 4786 ORDER BY `id` DESC LIMIT 0 , 30
          

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

            70
            0.51 ms
            SELECT * FROM `sub_product` WHERE TRUE AND `id_product` = 4786 AND `type` = 4 ORDER BY `id_language` ASC LIMIT 0 , 30
          

            71
            0.51 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...
          

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

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

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

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

            76
            1107.78 ms
            SELECT * FROM `customer_productlog` WHERE TRUE
          

            77
            3.42 ms
            INSERT INTO `customer_productlog` ( `id` , `content` ) VALUES( NULL , '{\"id_product\":\"4783\",\"id_user\":\"NULL\",\"dateVisited\":1785174501}' )
          

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

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

      

#	Time	Query
1	1.07 ms	SELECT url, namespace, method, content_redirection FROM `redirect` WHERE status = 1
2	5.1 ms	INSERT INTO `log_customer` ( `id` , `id_customer` , `log` , `date` ) VALUES( NULL , NULL ,...
3	0.25 ms	SELECT * FROM `languages` WHERE TRUE AND `short` = 'en'
4	0.4 ms	SELECT * FROM `languages` WHERE TRUE AND `name` = 'English'
5	124.01 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.29 ms	SELECT * FROM `products` p WHERE TRUE AND p.`id` = 4783 ORDER BY `id` DESC
7	0.21 ms	SELECT * FROM `type` WHERE TRUE AND `id` = 2 ORDER BY `id` DESC LIMIT 0 , 30
8	0.25 ms	SELECT * FROM `type` WHERE TRUE AND `group` = 'products_product_type' AND `name` = 'activity' ORDER BY `id` DESC LIMIT 0 , 30
9	0.25 ms	SELECT * FROM `sub_product` WHERE TRUE AND `id_product` = 4783 ORDER BY `id_language` DESC LIMIT 0 , 30
10	0.2 ms	SELECT * FROM `languages` WHERE TRUE AND `id` = 1
11	0.18 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.26 ms	SELECT * FROM `products` p WHERE TRUE AND p.`id` = 4783 AND p.`status` = '23' ORDER BY `id` DESC
14	0.19 ms	SELECT * FROM `suppliers` s WHERE TRUE AND s.`id` = 36 ORDER BY `id` DESC
15	0.21 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.31 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
18	0.21 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.28 ms	SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 4783 AND `id_language` = 1 ORDER BY `id` DESC LIMIT 0 , 1000
20	0.4 ms	SELECT * FROM `product_system_meta` WHERE TRUE AND `id_product` = 4783 AND `metaname` = 'bookingextranote' ORDER BY `id` DESC LIMIT 0 , 30
21	0.3 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
22	0.35 ms	SELECT * FROM `product_system` WHERE TRUE AND `id_product_dotravel` = 4783 ORDER BY `id` DESC
23	0.35 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.28 ms	SELECT * FROM `sub_product` WHERE TRUE AND `id_product` = 4783 AND `status` = '15' ORDER BY `id` DESC LIMIT 0 , 30
25	0.55 ms	SELECT * FROM `product_photos` WHERE TRUE AND `id_product` = 4783 ORDER BY `show_order` asc LIMIT 0 , 30
26	0.35 ms	SELECT * FROM `seo` WHERE TRUE AND `id_product` = 4783 AND `id_language` = 1 ORDER BY `id` DESC LIMIT 0 , 30
27	0.24 ms	SELECT * FROM `sub_product` WHERE TRUE AND `id_product` = 4783 ORDER BY `id` DESC LIMIT 0 , 30
28	0.26 ms	SELECT * FROM `product_prices` WHERE TRUE AND `id_subproduct` = 3809 ORDER BY `id` DESC LIMIT 0 , 30
29	0.2 ms	SELECT * FROM `age_group` WHERE TRUE AND `id` = 1 ORDER BY `id` DESC LIMIT 0 , 30
30	0.24 ms	SELECT * FROM `product_bookingfees` WHERE TRUE AND `id_productprice` = 10073 ORDER BY `id` DESC LIMIT 0 , 30
31	0.3 ms	SELECT * FROM `type` WHERE TRUE AND `group` = 'sub_product_type' AND `name` = 'group' ORDER BY `id` DESC LIMIT 0 , 30
32	0.43 ms	SELECT * FROM `sub_product` WHERE TRUE AND `id_product` = 4783 AND `type` = 4 ORDER BY `id_language` ASC LIMIT 0 , 30
33	0.31 ms	SELECT * FROM `product_advantage` WHERE TRUE AND `id_product` = 4783 ORDER BY `id` DESC LIMIT 0 , 30
34	0.28 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'
35	0.21 ms	SELECT * FROM `favorites` WHERE TRUE AND `id_product` = 4783 ORDER BY `id` DESC LIMIT 0 , 30
36	0.28 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.39 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...
38	0.32 ms	SELECT * FROM `product_photos` WHERE TRUE AND `id_product` = 4783 ORDER BY `show_order` ASC LIMIT 0 , 30
39	1.04 ms	SELECT d.*, d.cdn_image_uuid, d.cdn_variants, d.cdn_processing_status, d.use_cdn, m.id_language, m.name, m.description, m.summary, m.seo_title, m.seo_description, m.seo_keywords, m.seo_url, m.img_alt, m.faqs, m.index_content FROM `destinations` AS d INNER JOIN `destination_meta` AS m on d.id =...
40	0.26 ms	SELECT * FROM `destination_parent` WHERE TRUE AND `id_child` = 106 ORDER BY `id` DESC LIMIT 0 , 30
41	0.32 ms	SELECT destinations.id, destination_meta.name,seo_url FROM `destinations` join destination_meta on destination_meta.id_destination = destinations.id join destination_parent on destination_parent.id_parent = destinations.id where true AND destinations.status = 24 AND destination_meta.id_language =...
42	0.19 ms	SELECT * FROM `destination_parent` WHERE TRUE AND `id_child` = 104 ORDER BY `id` DESC LIMIT 0 , 30
43	0.42 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
44	14.06 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...
45	0.64 ms	SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 4781 AND `id_language` = 1 AND `metaname` = 'title' ORDER BY `id` DESC LIMIT 0 , 30
46	0.5 ms	SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 4781 AND `id_language` = 1 AND `metaname` = 'summary' ORDER BY `id` DESC LIMIT 0 , 30
47	0.34 ms	SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 4781 AND `id_language` = 1 AND `metaname` = 'typeHour' ORDER BY `id` DESC LIMIT 0 , 30
48	0.44 ms	SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 4781 AND `id_language` = 1 AND `metaname` = 'currency' ORDER BY `id` DESC LIMIT 0 , 30
49	0.31 ms	SELECT * FROM `seo` WHERE TRUE AND `id_product` = 4781 AND `id_language` = 1 ORDER BY `id` DESC LIMIT 0 , 30
50	0.43 ms	SELECT * FROM `product_photos` WHERE TRUE AND `id_product` = 4781 ORDER BY `id` DESC LIMIT 0 , 30
51	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` = 4781 ORDER BY s.`id_language` ASC
52	0.34 ms	SELECT * FROM `sub_product` WHERE TRUE AND `id_product` = 4781 AND `type` = 4 ORDER BY `id_language` ASC LIMIT 0 , 30
53	0.36 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...
54	0.45 ms	SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 4752 AND `id_language` = 1 AND `metaname` = 'title' ORDER BY `id` DESC LIMIT 0 , 30
55	0.43 ms	SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 4752 AND `id_language` = 1 AND `metaname` = 'summary' ORDER BY `id` DESC LIMIT 0 , 30
56	0.37 ms	SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 4752 AND `id_language` = 1 AND `metaname` = 'typeHour' ORDER BY `id` DESC LIMIT 0 , 30
57	0.37 ms	SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 4752 AND `id_language` = 1 AND `metaname` = 'currency' ORDER BY `id` DESC LIMIT 0 , 30
58	0.27 ms	SELECT * FROM `seo` WHERE TRUE AND `id_product` = 4752 AND `id_language` = 1 ORDER BY `id` DESC LIMIT 0 , 30
59	0.29 ms	SELECT * FROM `product_photos` WHERE TRUE AND `id_product` = 4752 ORDER BY `id` DESC LIMIT 0 , 30
60	0.32 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` = 4752 ORDER BY s.`id_language` ASC
61	0.71 ms	SELECT * FROM `sub_product` WHERE TRUE AND `id_product` = 4752 AND `type` = 4 ORDER BY `id_language` ASC LIMIT 0 , 30
62	1.06 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...
63	0.5 ms	SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 4786 AND `id_language` = 1 AND `metaname` = 'title' ORDER BY `id` DESC LIMIT 0 , 30
64	0.41 ms	SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 4786 AND `id_language` = 1 AND `metaname` = 'summary' ORDER BY `id` DESC LIMIT 0 , 30
65	0.34 ms	SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 4786 AND `id_language` = 1 AND `metaname` = 'typeHour' ORDER BY `id` DESC LIMIT 0 , 30
66	0.37 ms	SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 4786 AND `id_language` = 1 AND `metaname` = 'currency' ORDER BY `id` DESC LIMIT 0 , 30
67	0.63 ms	SELECT * FROM `seo` WHERE TRUE AND `id_product` = 4786 AND `id_language` = 1 ORDER BY `id` DESC LIMIT 0 , 30
68	0.32 ms	SELECT * FROM `product_photos` WHERE TRUE AND `id_product` = 4786 ORDER BY `id` DESC LIMIT 0 , 30
69	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` = 4786 ORDER BY s.`id_language` ASC
70	0.51 ms	SELECT * FROM `sub_product` WHERE TRUE AND `id_product` = 4786 AND `type` = 4 ORDER BY `id_language` ASC LIMIT 0 , 30
71	0.51 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...
72	1.46 ms	SELECT id_product, metavalue FROM `product_meta` WHERE id_product IN (?,?,?) AND metaname = ? AND id_language = ?
73	0.57 ms	SELECT * FROM `type` WHERE TRUE AND `group` = 'subproduct_blockeddates_block_type' ORDER BY `id` DESC LIMIT 0 , 30
74	0.59 ms	SELECT * FROM `subproduct_blockeddates` WHERE TRUE AND `id_subproduct` = 3809 ORDER BY `date` ASC LIMIT 0 , 30
75	0.46 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
76	1107.78 ms	SELECT * FROM `customer_productlog` WHERE TRUE
77	3.42 ms	INSERT INTO `customer_productlog` ( `id` , `content` ) VALUES( NULL , '{\"id_product\":\"4783\",\"id_user\":\"NULL\",\"dateVisited\":1785174501}' )
78	0.3 ms	SELECT * FROM `suppliers` s WHERE TRUE AND s.`id` = 36 ORDER BY `id` DESC
79	0.38 ms	SELECT * FROM `supplier_meta` WHERE TRUE AND `id_supplier` = 36 ORDER BY `id` DESC LIMIT 0 , 1000

Arrábida Snorkeling & Wine