Rojo Tango Show with private transfers in Buenos Aires

arrow_back

arrow_forward

New Activity

Rojo Tango Show with private transfers in Buenos Aires

Name: Rojo Tango Show with private transfers in Buenos Aires
Brand: Dotravel
Price: 281.61 EUR
Availability: InStock

Duration: 4h

Group: Max 10 people

May 18, 2026

FROM

€ 282

/pp

About This activity

DoTravel

Meeting Point

Argentina

There are many tango shows in Buenos Aires, but if you have a taste for luxury, only the Rojo Tango Show will do. This first-class experience takes place inside the cabaret theater of the high-end, designer Faena Hotel. Watch tango dancers in period costume, with vocalists and a live orchestra adding to the powerhouse show, while attentive staff pour Baron B bubbly into your crystal wine glass. Soak up even more Old World opulence with an upgrade to enjoy a 3-course gourmet dinner at a candlelit table. Hotel transport included.

No reviews yet

Costa da Caparica Surf and Yoga from Lisbon

New Activity

schedule 5h

Costa da Caparica Surf and Yoga from Lisbon

Next available: Jun 23, 2026

activity BOOK IT

FROM

€ 81

/pp

Catacombs of Paris: SKIP-THE-LINE + Private Audio Tour on Mobile App

New Activity

schedule 1h 30m

Catacombs of Paris: SKIP-THE-LINE + Private Audio Tour on Mobile App

activity BOOK IT

FROM

€ 58

/pp

Touristic highlights of Zürich with Cruise & Chocolate (halfday tour with local)

New Activity

schedule 5h 30m

Touristic highlights of Zürich with Cruise & Chocolate (halfday tour with local)

Next available: May 18, 2026

activity BOOK IT

FROM

€ 66

/pp

  DB
  81 queries
  |
  1236.3 ms

    Query Log (81 queries, 1236.3 ms)
    ×
  

    
    
  
Loading...

          
        #TimeQuery

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

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

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

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

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

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

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

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

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

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

            11
            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
          

            12
            0.28 ms
            SELECT * FROM `products` p WHERE TRUE AND p.`id` = 4788 AND p.`status` = '23' ORDER BY `id` DESC
          

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

            14
            0.28 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.46 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.51 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` = 4788 ORDER BY `rating_overall` desc LIMIT 20 , 30
          

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

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

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

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

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

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

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

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

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

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

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

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

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

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

            33
            0.25 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 ='4788'
          

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

            35
            0.31 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.54 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` = 4788 AND cm.`id_language` = 1...
          

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

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

            39
            0.95 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.34 ms
            SELECT * FROM `destination_parent` WHERE TRUE AND `id_child` = 28 ORDER BY `id` DESC LIMIT 0 , 30
          

            41
            0.42 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.31 ms
            SELECT * FROM `destination_parent` WHERE TRUE AND `id_child` = 16 ORDER BY `id` DESC LIMIT 0 , 30
          

            43
            0.39 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 =...
          

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

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

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

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

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

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

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

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

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

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

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

            55
            0.67 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...
          

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

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

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

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

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

            61
            0.51 ms
            SELECT * FROM `product_photos` WHERE TRUE AND `id_product` = 4778 ORDER BY `id` DESC LIMIT 0 , 30
          

            62
            0.47 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` = 4778 ORDER BY s.`id_language` ASC
          

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

            64
            0.75 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...
          

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

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

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

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

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

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

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

            72
            0.81 ms
            SELECT * FROM `sub_product` WHERE TRUE AND `id_product` = 4787 AND `type` = 4 ORDER BY `id_language` ASC LIMIT 0 , 30
          

            73
            0.49 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...
          

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

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

            76
            0.49 ms
            SELECT * FROM `subproduct_blockeddates` WHERE TRUE AND `id_subproduct` = 3814 ORDER BY `date` ASC LIMIT 0 , 30
          

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

            78
            1015.04 ms
            SELECT * FROM `customer_productlog` WHERE TRUE
          

            79
            4.63 ms
            INSERT INTO `customer_productlog` ( `id` , `content` ) VALUES( NULL , '{\"id_product\":\"4788\",\"id_user\":\"NULL\",\"dateVisited\":1785177403}' )
          

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

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

      

#	Time	Query
1	1.23 ms	SELECT url, namespace, method, content_redirection FROM `redirect` WHERE status = 1
2	2.89 ms	INSERT INTO `log_customer` ( `id` , `id_customer` , `log` , `date` ) VALUES( NULL , NULL ,...
3	0.46 ms	SELECT * FROM `languages` WHERE TRUE AND `short` = 'en'
4	164.42 ms	SELECT * FROM `product_meta` WHERE TRUE AND `id_language` = 1 AND `metaname` = 'redirect_from_id' AND `metavalue` = '4788' ORDER BY `id` DESC LIMIT 0 , 30
5	0.6 ms	SELECT * FROM `products` p WHERE TRUE AND p.`id` = 4788 ORDER BY `id` DESC
6	0.39 ms	SELECT * FROM `type` WHERE TRUE AND `id` = 2 ORDER BY `id` DESC LIMIT 0 , 30
7	0.49 ms	SELECT * FROM `type` WHERE TRUE AND `group` = 'products_product_type' AND `name` = 'activity' ORDER BY `id` DESC LIMIT 0 , 30
8	0.44 ms	SELECT * FROM `sub_product` WHERE TRUE AND `id_product` = 4788 ORDER BY `id_language` DESC LIMIT 0 , 30
9	0.36 ms	SELECT * FROM `languages` WHERE TRUE AND `id` = 1
10	0.3 ms	SELECT * FROM `type` WHERE TRUE AND `id` = 4 ORDER BY `id` DESC LIMIT 0 , 30
11	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
12	0.28 ms	SELECT * FROM `products` p WHERE TRUE AND p.`id` = 4788 AND p.`status` = '23' ORDER BY `id` DESC
13	0.19 ms	SELECT * FROM `suppliers` s WHERE TRUE AND s.`id` = 36 ORDER BY `id` DESC
14	0.28 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.46 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.51 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` = 4788 ORDER BY `rating_overall` desc LIMIT 20 , 30
17	0.28 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.38 ms	SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 4788 AND `id_language` = 1 ORDER BY `id` DESC LIMIT 0 , 1000
19	0.42 ms	SELECT * FROM `product_system_meta` WHERE TRUE AND `id_product` = 4788 AND `metaname` = 'bookingextranote' ORDER BY `id` DESC LIMIT 0 , 30
20	0.34 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` = 4788 ORDER BY s.`id_language` ASC
21	0.29 ms	SELECT * FROM `product_system` WHERE TRUE AND `id_product_dotravel` = 4788 ORDER BY `id` DESC
22	0.39 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.35 ms	SELECT * FROM `sub_product` WHERE TRUE AND `id_product` = 4788 AND `status` = '15' ORDER BY `id` DESC LIMIT 0 , 30
24	0.29 ms	SELECT * FROM `product_photos` WHERE TRUE AND `id_product` = 4788 ORDER BY `show_order` asc LIMIT 0 , 30
25	0.27 ms	SELECT * FROM `seo` WHERE TRUE AND `id_product` = 4788 AND `id_language` = 1 ORDER BY `id` DESC LIMIT 0 , 30
26	0.22 ms	SELECT * FROM `sub_product` WHERE TRUE AND `id_product` = 4788 ORDER BY `id` DESC LIMIT 0 , 30
27	0.24 ms	SELECT * FROM `product_prices` WHERE TRUE AND `id_subproduct` = 3814 ORDER BY `id` DESC LIMIT 0 , 30
28	0.18 ms	SELECT * FROM `age_group` WHERE TRUE AND `id` = 1 ORDER BY `id` DESC LIMIT 0 , 30
29	0.2 ms	SELECT * FROM `product_bookingfees` WHERE TRUE AND `id_productprice` = 10078 ORDER BY `id` DESC LIMIT 0 , 30
30	0.26 ms	SELECT * FROM `type` WHERE TRUE AND `group` = 'sub_product_type' AND `name` = 'group' ORDER BY `id` DESC LIMIT 0 , 30
31	0.23 ms	SELECT * FROM `sub_product` WHERE TRUE AND `id_product` = 4788 AND `type` = 4 ORDER BY `id_language` ASC LIMIT 0 , 30
32	0.21 ms	SELECT * FROM `product_advantage` WHERE TRUE AND `id_product` = 4788 ORDER BY `id` DESC LIMIT 0 , 30
33	0.25 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 ='4788'
34	0.2 ms	SELECT * FROM `favorites` WHERE TRUE AND `id_product` = 4788 ORDER BY `id` DESC LIMIT 0 , 30
35	0.31 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.54 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` = 4788 AND cm.`id_language` = 1...
37	0.25 ms	SELECT * FROM `product_photos` WHERE TRUE AND `id_product` = 4788 ORDER BY `show_order` ASC LIMIT 0 , 30
38	0.23 ms	SELECT * FROM `languages` WHERE TRUE AND `name` = 'English'
39	0.95 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.34 ms	SELECT * FROM `destination_parent` WHERE TRUE AND `id_child` = 28 ORDER BY `id` DESC LIMIT 0 , 30
41	0.42 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.31 ms	SELECT * FROM `destination_parent` WHERE TRUE AND `id_child` = 16 ORDER BY `id` DESC LIMIT 0 , 30
43	0.39 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 =...
44	0.58 ms	SELECT * FROM `destination_parent` WHERE TRUE AND `id_child` = 1 ORDER BY `id` DESC LIMIT 0 , 30
45	0.55 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` = 4788 AND p.`status` = 23 AND s.`status` = 10 ORDER BY `id` DESC LIMIT 0 , 3
46	15.69 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 ( 4788 ) AND st.name = 'active' AND st.group = 'suppliers_status' AND p.id IN ( SELECT id_product FROM `product_destination` WHERE id_destination IN...
47	0.74 ms	SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 4784 AND `id_language` = 1 AND `metaname` = 'title' ORDER BY `id` DESC LIMIT 0 , 30
48	0.61 ms	SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 4784 AND `id_language` = 1 AND `metaname` = 'summary' ORDER BY `id` DESC LIMIT 0 , 30
49	0.45 ms	SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 4784 AND `id_language` = 1 AND `metaname` = 'typeHour' ORDER BY `id` DESC LIMIT 0 , 30
50	0.49 ms	SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 4784 AND `id_language` = 1 AND `metaname` = 'currency' ORDER BY `id` DESC LIMIT 0 , 30
51	0.39 ms	SELECT * FROM `seo` WHERE TRUE AND `id_product` = 4784 AND `id_language` = 1 ORDER BY `id` DESC LIMIT 0 , 30
52	0.37 ms	SELECT * FROM `product_photos` WHERE TRUE AND `id_product` = 4784 ORDER BY `id` DESC LIMIT 0 , 30
53	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` = 4784 ORDER BY s.`id_language` ASC
54	0.89 ms	SELECT * FROM `sub_product` WHERE TRUE AND `id_product` = 4784 AND `type` = 4 ORDER BY `id_language` ASC LIMIT 0 , 30
55	0.67 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...
56	0.72 ms	SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 4778 AND `id_language` = 1 AND `metaname` = 'title' ORDER BY `id` DESC LIMIT 0 , 30
57	0.5 ms	SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 4778 AND `id_language` = 1 AND `metaname` = 'summary' ORDER BY `id` DESC LIMIT 0 , 30
58	0.44 ms	SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 4778 AND `id_language` = 1 AND `metaname` = 'typeHour' ORDER BY `id` DESC LIMIT 0 , 30
59	0.45 ms	SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 4778 AND `id_language` = 1 AND `metaname` = 'currency' ORDER BY `id` DESC LIMIT 0 , 30
60	0.35 ms	SELECT * FROM `seo` WHERE TRUE AND `id_product` = 4778 AND `id_language` = 1 ORDER BY `id` DESC LIMIT 0 , 30
61	0.51 ms	SELECT * FROM `product_photos` WHERE TRUE AND `id_product` = 4778 ORDER BY `id` DESC LIMIT 0 , 30
62	0.47 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` = 4778 ORDER BY s.`id_language` ASC
63	0.91 ms	SELECT * FROM `sub_product` WHERE TRUE AND `id_product` = 4778 AND `type` = 4 ORDER BY `id_language` ASC LIMIT 0 , 30
64	0.75 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...
65	0.59 ms	SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 4787 AND `id_language` = 1 AND `metaname` = 'title' ORDER BY `id` DESC LIMIT 0 , 30
66	0.5 ms	SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 4787 AND `id_language` = 1 AND `metaname` = 'summary' ORDER BY `id` DESC LIMIT 0 , 30
67	0.38 ms	SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 4787 AND `id_language` = 1 AND `metaname` = 'typeHour' ORDER BY `id` DESC LIMIT 0 , 30
68	0.32 ms	SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 4787 AND `id_language` = 1 AND `metaname` = 'currency' ORDER BY `id` DESC LIMIT 0 , 30
69	0.34 ms	SELECT * FROM `seo` WHERE TRUE AND `id_product` = 4787 AND `id_language` = 1 ORDER BY `id` DESC LIMIT 0 , 30
70	0.29 ms	SELECT * FROM `product_photos` WHERE TRUE AND `id_product` = 4787 ORDER BY `id` DESC LIMIT 0 , 30
71	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` = 4787 ORDER BY s.`id_language` ASC
72	0.81 ms	SELECT * FROM `sub_product` WHERE TRUE AND `id_product` = 4787 AND `type` = 4 ORDER BY `id_language` ASC LIMIT 0 , 30
73	0.49 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...
74	0.63 ms	SELECT id_product, metavalue FROM `product_meta` WHERE id_product IN (?,?,?) AND metaname = ? AND id_language = ?
75	0.36 ms	SELECT * FROM `type` WHERE TRUE AND `group` = 'subproduct_blockeddates_block_type' ORDER BY `id` DESC LIMIT 0 , 30
76	0.49 ms	SELECT * FROM `subproduct_blockeddates` WHERE TRUE AND `id_subproduct` = 3814 ORDER BY `date` ASC LIMIT 0 , 30
77	0.61 ms	SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 4788 AND `id_language` = 1 AND `metaname` = 'availability_next_date' ORDER BY `id` DESC LIMIT 0 , 30
78	1015.04 ms	SELECT * FROM `customer_productlog` WHERE TRUE
79	4.63 ms	INSERT INTO `customer_productlog` ( `id` , `content` ) VALUES( NULL , '{\"id_product\":\"4788\",\"id_user\":\"NULL\",\"dateVisited\":1785177403}' )
80	0.42 ms	SELECT * FROM `suppliers` s WHERE TRUE AND s.`id` = 36 ORDER BY `id` DESC
81	0.48 ms	SELECT * FROM `supplier_meta` WHERE TRUE AND `id_supplier` = 36 ORDER BY `id` DESC LIMIT 0 , 1000

Rojo Tango Show with private transfers in Buenos Aires