arrow_back

arrow_forward

New Activity

ROMANTIC PACK at Icebarcelona

Name: ROMANTIC PACK at Icebarcelona
Brand: Dotravel
Availability: InStock

Duration: 45m

Group: Max 2 people

2 Ice Bar Experiences (Entry + drink) Table at terrace, including 1 Box of Chocolates 1 Bottle of Cava

FROM

€ 0

/pp

About This ticket

1 bottle of cava

1 box of chocolates

Terrace table by the beach

Ice Bar experience for two (entry + drink)

DoTravel

Meeting Point

Ramón Trias Fargas 2

Are you thinking of surprising someone special? Take it to an inimitable and astonishing place for an exclusive evening. The romantic pack is the ideal gift to surprise your partner. The total price of the pack is 64€, and is valid for two people

1 bottle of cava

1 box of chocolates

Terrace table by the beach

Ice Bar experience for two (entry + drink)

No reviews yet

Indulge in a dazzling two-person escape with a glacial bar experience and a serene seaside setting. Enjoy a private terrace table by the shore, toast with cava, and savor chocolates as you celebrate a special moment. This is a thoughtfully curated, romantic night designed to create lasting memories.

Exclusive access to a sculpted ice bar environment
Private beachfront terrace table for two
Toast with chilled cava and sweet chocolates
Perfect gift idea for anniversaries and special occasions

2 Hours PRIVATE CATAMARAN up to 12 Guests Sailing Experience Barcelona

New Activity

schedule 1h

2 Hours PRIVATE CATAMARAN up to 12 Guests Sailing Experience Barcelona

Enjoy two hours on a Catamaran up to 12 persons, an everyday departure from the...

Next available: Feb 07, 2026

activity BOOK IT

FROM

€ 790

/pp

Private Yacht Experience in Barcelona | 1 Hour

New Activity

schedule 1h

Private Yacht Experience in Barcelona | 1 Hour

Experience a yacht trip on the Mediterranean Sea for 1 hour in Barcelona.

Next available: Feb 07, 2026

activity BOOK IT

FROM

€ 339

/pp

2 Hours Private SUNRISE Sailing Experience Barcelona up to 11 Guests

New Activity

schedule 1h

2 Hours Private SUNRISE Sailing Experience Barcelona up to 11 Guests

Sail with us and see the Sun Rising from the Sea! Leaving every day from the renovated...

Next available: Feb 08, 2026

activity BOOK IT

FROM

€ 399

/pp

  DB
  78 queries
  |
  1812.19 ms

    Query Log (78 queries, 1812.19 ms)
    ×
  

    
    
  
Loading...

          
        #TimeQuery

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

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

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

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

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

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

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

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

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

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

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

            12
            1.21 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.48 ms
            SELECT * FROM `products` p WHERE TRUE AND p.`id` = 4726 AND p.`status` = '23' ORDER BY `id` DESC
          

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

            15
            1.16 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.78 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
            1.47 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` = 4726 ORDER BY `rating_overall` desc LIMIT 20 , 30
          

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

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

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

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

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

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

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

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

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

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

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

            31
            0.43 ms
            SELECT * FROM `product_advantage` WHERE TRUE AND `id_product` = 4726 ORDER BY `id` DESC LIMIT 0 , 30
          

            32
            0.44 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 ='4726'
          

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

            34
            0.63 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
          

            35
            0.59 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` = 4726 AND cm.`id_language` = 1...
          

            36
            0.96 ms
            SELECT * FROM `product_photos` WHERE TRUE AND `id_product` = 4726 ORDER BY `show_order` ASC LIMIT 0 , 30
          

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

            53
            3.04 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.92 ms
            SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 4568 AND `id_language` = 1 AND `metaname` = 'title' ORDER BY `id` DESC LIMIT 0 , 30
          

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

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

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

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

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

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

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

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

            63
            0.65 ms
            SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 4606 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` = 4606 AND `id_language` = 1 AND `metaname` = 'summary' ORDER BY `id` DESC LIMIT 0 , 30
          

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

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

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

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

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

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

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

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

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

            75
            1467.7 ms
            SELECT * FROM `customer_productlog` WHERE TRUE
          

            76
            8.25 ms
            INSERT INTO `customer_productlog` ( `id` , `content` ) VALUES( NULL , '{\"id_product\":\"4726\",\"id_user\":\"NULL\",\"dateVisited\":1785177629}' )
          

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

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

      

ROMANTIC PACK at Icebarcelona

Ice Bar Experience for Two

About This ticket

Meeting Point

You might also like

2 Hours PRIVATE CATAMARAN up to 12 Guests Sailing Experience Barcelona

Private Yacht Experience in Barcelona | 1 Hour

2 Hours Private SUNRISE Sailing Experience Barcelona up to 11 Guests

#	Time	Query
1	4.65 ms	SELECT url, namespace, method, content_redirection FROM `redirect` WHERE status = 1
2	7.31 ms	INSERT INTO `log_customer` ( `id` , `id_customer` , `log` , `date` ) VALUES( NULL , NULL ,...
3	0.62 ms	SELECT * FROM `languages` WHERE TRUE AND `short` = 'en'
4	0.38 ms	SELECT * FROM `languages` WHERE TRUE AND `name` = 'English'
5	248.41 ms	SELECT * FROM `product_meta` WHERE TRUE AND `id_language` = 1 AND `metaname` = 'redirect_from_id' AND `metavalue` = '4726' ORDER BY `id` DESC LIMIT 0 , 30
6	0.72 ms	SELECT * FROM `products` p WHERE TRUE AND p.`id` = 4726 ORDER BY `id` DESC
7	0.62 ms	SELECT * FROM `type` WHERE TRUE AND `id` = 1 ORDER BY `id` DESC LIMIT 0 , 30
8	0.5 ms	SELECT * FROM `type` WHERE TRUE AND `group` = 'products_product_type' AND `name` = 'ticket' ORDER BY `id` DESC LIMIT 0 , 30
9	0.63 ms	SELECT * FROM `sub_product` WHERE TRUE AND `id_product` = 4726 ORDER BY `id_language` DESC LIMIT 0 , 30
10	0.47 ms	SELECT * FROM `languages` WHERE TRUE AND `id` = 1
11	1.31 ms	SELECT * FROM `type` WHERE TRUE AND `id` = 4 ORDER BY `id` DESC LIMIT 0 , 30
12	1.21 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.48 ms	SELECT * FROM `products` p WHERE TRUE AND p.`id` = 4726 AND p.`status` = '23' ORDER BY `id` DESC
14	0.51 ms	SELECT * FROM `suppliers` s WHERE TRUE AND s.`id` = 36 ORDER BY `id` DESC
15	1.16 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.78 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	1.47 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` = 4726 ORDER BY `rating_overall` desc LIMIT 20 , 30
18	0.83 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	2.24 ms	SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 4726 AND `id_language` = 1 ORDER BY `id` DESC LIMIT 0 , 1000
20	0.73 ms	SELECT * FROM `product_system_meta` WHERE TRUE AND `id_product` = 4726 AND `metaname` = 'bookingextranote' ORDER BY `id` DESC LIMIT 0 , 30
21	0.8 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` = 4726 ORDER BY s.`id_language` ASC
22	0.62 ms	SELECT * FROM `product_system` WHERE TRUE AND `id_product_dotravel` = 4726 ORDER BY `id` DESC
23	0.74 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.99 ms	SELECT * FROM `sub_product` WHERE TRUE AND `id_product` = 4726 AND `status` = '15' ORDER BY `id` DESC LIMIT 0 , 30
25	1.32 ms	SELECT * FROM `product_photos` WHERE TRUE AND `id_product` = 4726 ORDER BY `show_order` asc LIMIT 0 , 30
26	1.29 ms	SELECT * FROM `seo` WHERE TRUE AND `id_product` = 4726 AND `id_language` = 1 ORDER BY `id` DESC LIMIT 0 , 30
27	0.55 ms	SELECT * FROM `sub_product` WHERE TRUE AND `id_product` = 4726 ORDER BY `id` DESC LIMIT 0 , 30
28	1.65 ms	SELECT * FROM `product_prices` WHERE TRUE AND `id_subproduct` = 3752 ORDER BY `id` DESC LIMIT 0 , 30
29	0.72 ms	SELECT * FROM `type` WHERE TRUE AND `group` = 'sub_product_type' AND `name` = 'group' ORDER BY `id` DESC LIMIT 0 , 30
30	0.56 ms	SELECT * FROM `sub_product` WHERE TRUE AND `id_product` = 4726 AND `type` = 4 ORDER BY `id_language` ASC LIMIT 0 , 30
31	0.43 ms	SELECT * FROM `product_advantage` WHERE TRUE AND `id_product` = 4726 ORDER BY `id` DESC LIMIT 0 , 30
32	0.44 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 ='4726'
33	0.35 ms	SELECT * FROM `favorites` WHERE TRUE AND `id_product` = 4726 ORDER BY `id` DESC LIMIT 0 , 30
34	0.63 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
35	0.59 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` = 4726 AND cm.`id_language` = 1...
36	0.96 ms	SELECT * FROM `product_photos` WHERE TRUE AND `id_product` = 4726 ORDER BY `show_order` ASC LIMIT 0 , 30
37	0.51 ms	SELECT * FROM `destination_parent` WHERE TRUE AND `id_child` = 7 ORDER BY `id` DESC LIMIT 0 , 30
38	0.55 ms	SELECT destinations.id, destination_meta.name,seo_url FROM `destinations` join destination_meta on destination_meta.id_destination = destinations.id join destination_parent on destination_parent.id_parent = destinations.id where true AND destinations.status = 24 AND destination_meta.id_language =...
39	1.46 ms	SELECT * FROM `destination_parent` WHERE TRUE AND `id_child` = 3 ORDER BY `id` DESC LIMIT 0 , 30
40	0.61 ms	SELECT destinations.id, destination_meta.name,seo_url FROM `destinations` join destination_meta on destination_meta.id_destination = destinations.id join destination_parent on destination_parent.id_parent = destinations.id where true AND destinations.status = 24 AND destination_meta.id_language =...
41	0.38 ms	SELECT * FROM `destination_parent` WHERE TRUE AND `id_child` = 1 ORDER BY `id` DESC LIMIT 0 , 30
42	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` = 4726 AND p.`status` = 23 AND s.`status` = 10 ORDER BY `id` DESC LIMIT 0 , 3
43	22.23 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 ( 4726 ) 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.77 ms	SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 4595 AND `id_language` = 1 AND `metaname` = 'title' ORDER BY `id` DESC LIMIT 0 , 30
45	0.67 ms	SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 4595 AND `id_language` = 1 AND `metaname` = 'summary' ORDER BY `id` DESC LIMIT 0 , 30
46	0.51 ms	SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 4595 AND `id_language` = 1 AND `metaname` = 'typeHour' ORDER BY `id` DESC LIMIT 0 , 30
47	0.55 ms	SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 4595 AND `id_language` = 1 AND `metaname` = 'currency' ORDER BY `id` DESC LIMIT 0 , 30
48	1.41 ms	SELECT * FROM `seo` WHERE TRUE AND `id_product` = 4595 AND `id_language` = 1 ORDER BY `id` DESC LIMIT 0 , 30
49	0.32 ms	SELECT * FROM `type` WHERE TRUE AND `id` = 2 ORDER BY `id` DESC LIMIT 0 , 30
50	0.44 ms	SELECT * FROM `product_photos` WHERE TRUE AND `id_product` = 4595 ORDER BY `id` DESC LIMIT 0 , 30
51	0.52 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` = 4595 ORDER BY s.`id_language` ASC
52	1 ms	SELECT * FROM `sub_product` WHERE TRUE AND `id_product` = 4595 AND `type` = 4 ORDER BY `id_language` ASC LIMIT 0 , 30
53	3.04 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.92 ms	SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 4568 AND `id_language` = 1 AND `metaname` = 'title' ORDER BY `id` DESC LIMIT 0 , 30
55	0.82 ms	SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 4568 AND `id_language` = 1 AND `metaname` = 'summary' ORDER BY `id` DESC LIMIT 0 , 30
56	0.61 ms	SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 4568 AND `id_language` = 1 AND `metaname` = 'typeHour' ORDER BY `id` DESC LIMIT 0 , 30
57	0.54 ms	SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 4568 AND `id_language` = 1 AND `metaname` = 'currency' ORDER BY `id` DESC LIMIT 0 , 30
58	0.47 ms	SELECT * FROM `seo` WHERE TRUE AND `id_product` = 4568 AND `id_language` = 1 ORDER BY `id` DESC LIMIT 0 , 30
59	0.58 ms	SELECT * FROM `product_photos` WHERE TRUE AND `id_product` = 4568 ORDER BY `id` DESC LIMIT 0 , 30
60	0.59 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` = 4568 ORDER BY s.`id_language` ASC
61	0.79 ms	SELECT * FROM `sub_product` WHERE TRUE AND `id_product` = 4568 AND `type` = 4 ORDER BY `id_language` ASC LIMIT 0 , 30
62	0.54 ms	SELECT SUM(rating_valueformoney) as rating_valueformoney, SUM(rating_convenience) as rating_convenience, SUM(rating_accessibility) as rating_accessibility, SUM(rating_overall) as rating_overall, AVG(rating_overall) as rating_overall_avg, COUNT(*) as review_count FROM `reviews` WHERE status IN...
63	0.65 ms	SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 4606 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` = 4606 AND `id_language` = 1 AND `metaname` = 'summary' ORDER BY `id` DESC LIMIT 0 , 30
65	0.39 ms	SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 4606 AND `id_language` = 1 AND `metaname` = 'typeHour' ORDER BY `id` DESC LIMIT 0 , 30
66	0.43 ms	SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 4606 AND `id_language` = 1 AND `metaname` = 'currency' ORDER BY `id` DESC LIMIT 0 , 30
67	0.31 ms	SELECT * FROM `seo` WHERE TRUE AND `id_product` = 4606 AND `id_language` = 1 ORDER BY `id` DESC LIMIT 0 , 30
68	0.29 ms	SELECT * FROM `product_photos` WHERE TRUE AND `id_product` = 4606 ORDER BY `id` DESC LIMIT 0 , 30
69	0.37 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` = 4606 ORDER BY s.`id_language` ASC
70	0.86 ms	SELECT * FROM `sub_product` WHERE TRUE AND `id_product` = 4606 AND `type` = 4 ORDER BY `id_language` ASC LIMIT 0 , 30
71	0.82 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	0.76 ms	SELECT id_product, metavalue FROM `product_meta` WHERE id_product IN (?,?,?) AND metaname = ? AND id_language = ?
73	0.46 ms	SELECT * FROM `type` WHERE TRUE AND `group` = 'subproduct_blockeddates_block_type' ORDER BY `id` DESC LIMIT 0 , 30
74	0.41 ms	SELECT * FROM `subproduct_blockeddates` WHERE TRUE AND `id_subproduct` = 3752 ORDER BY `date` ASC LIMIT 0 , 30
75	1467.7 ms	SELECT * FROM `customer_productlog` WHERE TRUE
76	8.25 ms	INSERT INTO `customer_productlog` ( `id` , `content` ) VALUES( NULL , '{\"id_product\":\"4726\",\"id_user\":\"NULL\",\"dateVisited\":1785177629}' )
77	0.55 ms	SELECT * FROM `suppliers` s WHERE TRUE AND s.`id` = 36 ORDER BY `id` DESC
78	0.38 ms	SELECT * FROM `supplier_meta` WHERE TRUE AND `id_supplier` = 36 ORDER BY `id` DESC LIMIT 0 , 1000