Costa da Caparica Surf and Yoga from Lisbon

arrow_back

arrow_forward

New Activity

Costa da Caparica Surf and Yoga from Lisbon

Name: Costa da Caparica Surf and Yoga from Lisbon
Brand: Dotravel
Price: 81.41 EUR
Availability: InStock

Duration: 5h

Group: Max 10 people

Jun 23, 2026

FROM

€ 81

/pp

About This activity

DoTravel

Meeting Point

Portugal

Get your adrenaline flowing with this unique combo tour, offering a surf lesson and yoga class. Travel from Lisbon to the gorgeous Costa da Caparica region, where the the Tagus River meets the ocean. Meet up with expert surf instructors and Yoga Teacher. Start with a one-hour Yoga Workshop at the beach and after stretching and relaxing, receive a two-hour surf lesson, with all the equipment provided. This active tour offers the perfect opportunity to see a beautiful part of Portugal while learning or practicing two healthy, fun activities.

No reviews yet

Mushrooms & Wild Berries Picking Tour - Small Group

New Activity

schedule 3h

Mushrooms & Wild Berries Picking Tour - Small Group

Next available: Jul 01, 2026

activity BOOK IT

FROM

€ 92

/pp

New Activity

schedule 2h

Food Walk Tour Bangalore

Next available: May 17, 2026

activity BOOK IT

FROM

€ 22

/pp

Whale Watching from Downtown Reykjavik by RIB Speedboat

New Activity

schedule 2h

Whale Watching from Downtown Reykjavik by RIB Speedboat

Experience a thrilling small group whale watching tour by RIB speedboat from Reykjavik,...

Next available: May 17, 2026

activity BOOK IT

FROM

€ 149

/pp

  DB
  78 queries
  |
  2058.9 ms

    Query Log (78 queries, 2058.9 ms)
    ×
  

    
    
  
Loading...

          
        #TimeQuery

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

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

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

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

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

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

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

            8
            0.4 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` = 4784 ORDER BY `id_language` DESC LIMIT 0 , 30
          

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

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

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

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

            15
            0.26 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.43 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.43 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` = 4784 ORDER BY `rating_overall` desc LIMIT 20 , 30
          

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

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

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

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

            23
            0.34 ms
            SELECT *, CONCAT(UCASE(LEFT(name, 1)), LCASE(SUBSTRING(REPLACE(name,'_',' '), 2))) as title FROM `status` WHERE TRUE AND `name` = 'active' AND `group` = 'sub_product_status' ORDER BY `id` DESC LIMIT 0 , 30
          

            24
            0.3 ms
            SELECT * FROM `sub_product` WHERE TRUE AND `id_product` = 4784 AND `status` = '15' ORDER BY `id` DESC LIMIT 0 , 30
          

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

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

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

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

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

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

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

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

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

            34
            0.33 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 ='4784'
          

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

            36
            0.34 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.46 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` = 4784 AND cm.`id_language` = 1...
          

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

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

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

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

            43
            15.97 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 ( 4784 ) 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.57 ms
            SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 4758 AND `id_language` = 1 AND `metaname` = 'title' ORDER BY `id` DESC LIMIT 0 , 30
          

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

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

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

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

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

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

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

            52
            0.53 ms
            SELECT SUM(rating_valueformoney) as rating_valueformoney, SUM(rating_convenience) as rating_convenience, SUM(rating_accessibility) as rating_accessibility, SUM(rating_overall) as rating_overall, AVG(rating_overall) as rating_overall_avg, COUNT(*) as review_count FROM `reviews` WHERE status IN...
          

            53
            0.42 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.4 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.39 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.42 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.33 ms
            SELECT * FROM `seo` WHERE TRUE AND `id_product` = 4785 AND `id_language` = 1 ORDER BY `id` DESC LIMIT 0 , 30
          

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

            59
            0.42 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.43 ms
            SELECT * FROM `sub_product` WHERE TRUE AND `id_product` = 4785 AND `type` = 4 ORDER BY `id_language` ASC LIMIT 0 , 30
          

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

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

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

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

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

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

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

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

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

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

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

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

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

            75
            1733.45 ms
            SELECT * FROM `customer_productlog` WHERE TRUE
          

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

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

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

      

#	Time	Query
1	1.77 ms	SELECT url, namespace, method, content_redirection FROM `redirect` WHERE status = 1
2	5.89 ms	INSERT INTO `log_customer` ( `id` , `id_customer` , `log` , `date` ) VALUES( NULL , NULL ,...
3	0.61 ms	SELECT * FROM `languages` WHERE TRUE AND `short` = 'en'
4	0.59 ms	SELECT * FROM `languages` WHERE TRUE AND `name` = 'English'
5	260.83 ms	SELECT * FROM `product_meta` WHERE TRUE AND `id_language` = 1 AND `metaname` = 'redirect_from_id' AND `metavalue` = '4784' ORDER BY `id` DESC LIMIT 0 , 30
6	3.03 ms	SELECT * FROM `products` p WHERE TRUE AND p.`id` = 4784 ORDER BY `id` DESC
7	0.5 ms	SELECT * FROM `type` WHERE TRUE AND `id` = 2 ORDER BY `id` DESC LIMIT 0 , 30
8	0.4 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` = 4784 ORDER BY `id_language` DESC LIMIT 0 , 30
10	0.24 ms	SELECT * FROM `languages` WHERE TRUE AND `id` = 1
11	0.2 ms	SELECT * FROM `type` WHERE TRUE AND `id` = 4 ORDER BY `id` DESC LIMIT 0 , 30
12	0.36 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` = 4784 AND p.`status` = '23' ORDER BY `id` DESC
14	0.2 ms	SELECT * FROM `suppliers` s WHERE TRUE AND s.`id` = 36 ORDER BY `id` DESC
15	0.26 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.43 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.43 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` = 4784 ORDER BY `rating_overall` desc LIMIT 20 , 30
18	0.26 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.36 ms	SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 4784 AND `id_language` = 1 ORDER BY `id` DESC LIMIT 0 , 1000
20	0.43 ms	SELECT * FROM `product_system_meta` WHERE TRUE AND `id_product` = 4784 AND `metaname` = 'bookingextranote' ORDER BY `id` DESC LIMIT 0 , 30
21	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` = 4784 ORDER BY s.`id_language` ASC
22	0.27 ms	SELECT * FROM `product_system` WHERE TRUE AND `id_product_dotravel` = 4784 ORDER BY `id` DESC
23	0.34 ms	SELECT *, CONCAT(UCASE(LEFT(name, 1)), LCASE(SUBSTRING(REPLACE(name,'_',' '), 2))) as title FROM `status` WHERE TRUE AND `name` = 'active' AND `group` = 'sub_product_status' ORDER BY `id` DESC LIMIT 0 , 30
24	0.3 ms	SELECT * FROM `sub_product` WHERE TRUE AND `id_product` = 4784 AND `status` = '15' ORDER BY `id` DESC LIMIT 0 , 30
25	0.33 ms	SELECT * FROM `product_photos` WHERE TRUE AND `id_product` = 4784 ORDER BY `show_order` asc LIMIT 0 , 30
26	0.29 ms	SELECT * FROM `seo` WHERE TRUE AND `id_product` = 4784 AND `id_language` = 1 ORDER BY `id` DESC LIMIT 0 , 30
27	0.28 ms	SELECT * FROM `sub_product` WHERE TRUE AND `id_product` = 4784 ORDER BY `id` DESC LIMIT 0 , 30
28	0.28 ms	SELECT * FROM `product_prices` WHERE TRUE AND `id_subproduct` = 3810 ORDER BY `id` DESC LIMIT 0 , 30
29	0.23 ms	SELECT * FROM `age_group` WHERE TRUE AND `id` = 1 ORDER BY `id` DESC LIMIT 0 , 30
30	0.23 ms	SELECT * FROM `product_bookingfees` WHERE TRUE AND `id_productprice` = 10074 ORDER BY `id` DESC LIMIT 0 , 30
31	0.25 ms	SELECT * FROM `type` WHERE TRUE AND `group` = 'sub_product_type' AND `name` = 'group' ORDER BY `id` DESC LIMIT 0 , 30
32	0.41 ms	SELECT * FROM `sub_product` WHERE TRUE AND `id_product` = 4784 AND `type` = 4 ORDER BY `id_language` ASC LIMIT 0 , 30
33	0.24 ms	SELECT * FROM `product_advantage` WHERE TRUE AND `id_product` = 4784 ORDER BY `id` DESC LIMIT 0 , 30
34	0.33 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 ='4784'
35	0.23 ms	SELECT * FROM `favorites` WHERE TRUE AND `id_product` = 4784 ORDER BY `id` DESC LIMIT 0 , 30
36	0.34 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.46 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` = 4784 AND cm.`id_language` = 1...
38	0.35 ms	SELECT * FROM `product_photos` WHERE TRUE AND `id_product` = 4784 ORDER BY `show_order` ASC LIMIT 0 , 30
39	0.27 ms	SELECT * FROM `destination_parent` WHERE TRUE AND `id_child` = 106 ORDER BY `id` DESC LIMIT 0 , 30
40	0.37 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.25 ms	SELECT * FROM `destination_parent` WHERE TRUE AND `id_child` = 104 ORDER BY `id` DESC LIMIT 0 , 30
42	0.43 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` = 4784 AND p.`status` = 23 AND s.`status` = 10 ORDER BY `id` DESC LIMIT 0 , 3
43	15.97 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 ( 4784 ) 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.57 ms	SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 4758 AND `id_language` = 1 AND `metaname` = 'title' ORDER BY `id` DESC LIMIT 0 , 30
45	0.45 ms	SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 4758 AND `id_language` = 1 AND `metaname` = 'summary' ORDER BY `id` DESC LIMIT 0 , 30
46	0.42 ms	SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 4758 AND `id_language` = 1 AND `metaname` = 'typeHour' ORDER BY `id` DESC LIMIT 0 , 30
47	0.46 ms	SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 4758 AND `id_language` = 1 AND `metaname` = 'currency' ORDER BY `id` DESC LIMIT 0 , 30
48	0.31 ms	SELECT * FROM `seo` WHERE TRUE AND `id_product` = 4758 AND `id_language` = 1 ORDER BY `id` DESC LIMIT 0 , 30
49	0.29 ms	SELECT * FROM `product_photos` WHERE TRUE AND `id_product` = 4758 ORDER BY `id` DESC LIMIT 0 , 30
50	0.39 ms	SELECT pr.price as min FROM `product_prices` as pr INNER JOIN `sub_product` AS s ON s.id = pr.id_subproduct INNER JOIN `age_group` AS a ON a.id = pr.id_agegroup -- WHERE a.show_order = 1 AND s.`id_product` = 4758 ORDER BY s.`id_language` ASC
51	1.36 ms	SELECT * FROM `sub_product` WHERE TRUE AND `id_product` = 4758 AND `type` = 4 ORDER BY `id_language` ASC LIMIT 0 , 30
52	0.53 ms	SELECT SUM(rating_valueformoney) as rating_valueformoney, SUM(rating_convenience) as rating_convenience, SUM(rating_accessibility) as rating_accessibility, SUM(rating_overall) as rating_overall, AVG(rating_overall) as rating_overall_avg, COUNT(*) as review_count FROM `reviews` WHERE status IN...
53	0.42 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.4 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.39 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.42 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.33 ms	SELECT * FROM `seo` WHERE TRUE AND `id_product` = 4785 AND `id_language` = 1 ORDER BY `id` DESC LIMIT 0 , 30
58	0.34 ms	SELECT * FROM `product_photos` WHERE TRUE AND `id_product` = 4785 ORDER BY `id` DESC LIMIT 0 , 30
59	0.42 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.43 ms	SELECT * FROM `sub_product` WHERE TRUE AND `id_product` = 4785 AND `type` = 4 ORDER BY `id_language` ASC LIMIT 0 , 30
61	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...
62	0.48 ms	SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 4772 AND `id_language` = 1 AND `metaname` = 'title' ORDER BY `id` DESC LIMIT 0 , 30
63	0.44 ms	SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 4772 AND `id_language` = 1 AND `metaname` = 'summary' ORDER BY `id` DESC LIMIT 0 , 30
64	0.46 ms	SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 4772 AND `id_language` = 1 AND `metaname` = 'typeHour' ORDER BY `id` DESC LIMIT 0 , 30
65	0.45 ms	SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 4772 AND `id_language` = 1 AND `metaname` = 'currency' ORDER BY `id` DESC LIMIT 0 , 30
66	0.34 ms	SELECT * FROM `seo` WHERE TRUE AND `id_product` = 4772 AND `id_language` = 1 ORDER BY `id` DESC LIMIT 0 , 30
67	0.4 ms	SELECT * FROM `product_photos` WHERE TRUE AND `id_product` = 4772 ORDER BY `id` DESC LIMIT 0 , 30
68	0.42 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` = 4772 ORDER BY s.`id_language` ASC
69	0.44 ms	SELECT * FROM `sub_product` WHERE TRUE AND `id_product` = 4772 AND `type` = 4 ORDER BY `id_language` ASC LIMIT 0 , 30
70	0.45 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.71 ms	SELECT id_product, metavalue FROM `product_meta` WHERE id_product IN (?,?,?) AND metaname = ? AND id_language = ?
72	0.36 ms	SELECT * FROM `type` WHERE TRUE AND `group` = 'subproduct_blockeddates_block_type' ORDER BY `id` DESC LIMIT 0 , 30
73	0.35 ms	SELECT * FROM `subproduct_blockeddates` WHERE TRUE AND `id_subproduct` = 3810 ORDER BY `date` ASC LIMIT 0 , 30
74	0.45 ms	SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 4784 AND `id_language` = 1 AND `metaname` = 'availability_next_date' ORDER BY `id` DESC LIMIT 0 , 30
75	1733.45 ms	SELECT * FROM `customer_productlog` WHERE TRUE
76	9.19 ms	INSERT INTO `customer_productlog` ( `id` , `content` ) VALUES( NULL , '{\"id_product\":\"4784\",\"id_user\":\"NULL\",\"dateVisited\":1785174599}' )
77	0.95 ms	SELECT * FROM `suppliers` s WHERE TRUE AND s.`id` = 36 ORDER BY `id` DESC
78	0.85 ms	SELECT * FROM `supplier_meta` WHERE TRUE AND `id_supplier` = 36 ORDER BY `id` DESC LIMIT 0 , 1000

Costa da Caparica Surf and Yoga from Lisbon