arrow_back

arrow_forward

New Activity

Barcelona E-Bike Private Tour - Perfect City Experience for Family

Name: Barcelona E-Bike Private Tour - Perfect City Experience for Family
Brand: Dotravel
Price: 150.00 EUR
Availability: InStock

Duration: 4h

Group: Max 20 people

Jan 10, 2026

Enjoy this eBike tour with your family with a personal Private Guide for you to explore Barcelona at your own pace.

FROM

€ 150

/pp

About This activity

Authentic Chocolate and churros

Visit Barcelona beach, the Gaudi arts and the Montjuic Hill

Personal Private Guide

Hotel Pick-up and Drop-off

DoTravel

Meeting Point

montsio 10

Discover the Barcelona Highlights. Enjoy the Beach, the Gaudí arts, the Montjuic Hill or stop in one of the multiple places to have an authentic Chocolate & churros.

Decide on the spot with the help of your guide the best places for you & your family on this amazing experience where you will have the opportunity to see all Barcelona in a half day Taylor made e-bike tour.

Authentic Chocolate and churros

Visit Barcelona beach, the Gaudi arts and the Montjuic Hill

Personal Private Guide

Hotel Pick-up and Drop-off

Before You Go

This tour is free for children under 6 years old

No reviews yet

Enjoy this eBike tour with your family with a personal Private Guide for you to explore Barcelona at your own pace.

3 Hours PRIVATE Sailing Experience Barcelona up to 11 Guests

New Activity

schedule 1h

3 Hours PRIVATE Sailing Experience Barcelona up to 11 Guests

Enjoy this Sailing Experience in Barcelona! A 3 Hours Private Sailing Trip with light...

Next available: Feb 07, 2026

activity BOOK IT

FROM

€ 499

/pp

2 Hours PRIVATE Sailing Experience Barcelona up to 11 Guests

New Activity

schedule 1h

2 Hours PRIVATE Sailing Experience Barcelona up to 11 Guests

Enjoy this Sailing Experience in Barcelona! A 2 Hours Private Sailing Trip with light...

Next available: Feb 07, 2026

activity BOOK IT

FROM

€ 399

/pp

2 Hours PRIVATE SUNSET Sailing Experience Barcelona up to 11 Guests

New Activity

schedule 1h

2 Hours PRIVATE SUNSET Sailing Experience Barcelona up to 11 Guests

Enjoy this Sunset Sailing Experience in Barcelona! A 2 Hours Private Sailing Trip when...

Next available: Feb 07, 2026

activity BOOK IT

FROM

€ 399

/pp

  DB
  81 queries
  |
  1256.88 ms

    Query Log (81 queries, 1256.88 ms)
    ×
  

    
    
  
Loading...

          
        #TimeQuery

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

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

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

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

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

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

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

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

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

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

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

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

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

            16
            1.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` = 2675 ORDER BY `rating_overall` desc LIMIT 20 , 30
          

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

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

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

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

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

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

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

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

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

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

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

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

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

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

            33
            0.34 ms
            SELECT a.*, m.id_language, m.name, m.description FROM `advantages` AS a INNER JOIN `advantage_meta` AS m on a.id=m.id_advantage WHERE TRUE AND a.`id` = 7 AND m.`id_language` = 1 ORDER BY `id` desc LIMIT 0 , 30
          

            34
            0.31 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 ='2675'
          

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

            36
            0.36 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.47 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` = 2675 AND cm.`id_language` = 1...
          

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

            39
            0.22 ms
            SELECT * FROM `languages` WHERE TRUE AND `name` = 'English'
          

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

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

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

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

            46
            22.22 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 ( 2675 ) 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.62 ms
            SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 4608 AND `id_language` = 1 AND `metaname` = 'title' ORDER BY `id` DESC LIMIT 0 , 30
          

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

            68
            0.61 ms
            SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 4607 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` = 4607 AND `id_language` = 1 ORDER BY `id` DESC LIMIT 0 , 30
          

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

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

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

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

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

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

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

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

            78
            982.64 ms
            SELECT * FROM `customer_productlog` WHERE TRUE
          

            79
            3.55 ms
            INSERT INTO `customer_productlog` ( `id` , `content` ) VALUES( NULL , '{\"id_product\":\"2675\",\"id_user\":\"NULL\",\"dateVisited\":1785183869}' )
          

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

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

      

#	Time	Query
1	1.78 ms	SELECT url, namespace, method, content_redirection FROM `redirect` WHERE status = 1
2	4.46 ms	INSERT INTO `log_customer` ( `id` , `id_customer` , `log` , `date` ) VALUES( NULL , NULL ,...
3	0.43 ms	SELECT * FROM `languages` WHERE TRUE AND `short` = 'en'
4	200.7 ms	SELECT * FROM `product_meta` WHERE TRUE AND `id_language` = 1 AND `metaname` = 'redirect_from_id' AND `metavalue` = '2675' ORDER BY `id` DESC LIMIT 0 , 30
5	2.69 ms	SELECT * FROM `products` p WHERE TRUE AND p.`id` = 2675 ORDER BY `id` DESC
6	0.41 ms	SELECT * FROM `type` WHERE TRUE AND `id` = 2 ORDER BY `id` DESC LIMIT 0 , 30
7	0.43 ms	SELECT * FROM `type` WHERE TRUE AND `group` = 'products_product_type' AND `name` = 'activity' ORDER BY `id` DESC LIMIT 0 , 30
8	0.5 ms	SELECT * FROM `sub_product` WHERE TRUE AND `id_product` = 2675 ORDER BY `id_language` DESC LIMIT 0 , 30
9	0.51 ms	SELECT * FROM `languages` WHERE TRUE AND `id` = 1
10	0.24 ms	SELECT * FROM `type` WHERE TRUE AND `id` = 4 ORDER BY `id` DESC LIMIT 0 , 30
11	0.38 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.82 ms	SELECT * FROM `products` p WHERE TRUE AND p.`id` = 2675 AND p.`status` = '23' ORDER BY `id` DESC
13	0.3 ms	SELECT * FROM `suppliers` s WHERE TRUE AND s.`id` = 36 ORDER BY `id` DESC
14	0.34 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.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...
16	1.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` = 2675 ORDER BY `rating_overall` desc LIMIT 20 , 30
17	0.53 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.99 ms	SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 2675 AND `id_language` = 1 ORDER BY `id` DESC LIMIT 0 , 1000
19	0.94 ms	SELECT * FROM `product_system_meta` WHERE TRUE AND `id_product` = 2675 AND `metaname` = 'bookingextranote' ORDER BY `id` DESC LIMIT 0 , 30
20	0.9 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` = 2675 ORDER BY s.`id_language` ASC
21	0.33 ms	SELECT * FROM `product_system` WHERE TRUE AND `id_product_dotravel` = 2675 ORDER BY `id` DESC
22	0.38 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.81 ms	SELECT * FROM `sub_product` WHERE TRUE AND `id_product` = 2675 AND `status` = '15' ORDER BY `id` DESC LIMIT 0 , 30
24	0.4 ms	SELECT * FROM `product_photos` WHERE TRUE AND `id_product` = 2675 ORDER BY `show_order` asc LIMIT 0 , 30
25	0.41 ms	SELECT * FROM `seo` WHERE TRUE AND `id_product` = 2675 AND `id_language` = 1 ORDER BY `id` DESC LIMIT 0 , 30
26	0.27 ms	SELECT * FROM `sub_product` WHERE TRUE AND `id_product` = 2675 ORDER BY `id` DESC LIMIT 0 , 30
27	0.27 ms	SELECT * FROM `product_prices` WHERE TRUE AND `id_subproduct` = 1162 ORDER BY `id` DESC LIMIT 0 , 30
28	0.21 ms	SELECT * FROM `age_group` WHERE TRUE AND `id` = 1 ORDER BY `id` DESC LIMIT 0 , 30
29	0.22 ms	SELECT * FROM `product_bookingfees` WHERE TRUE AND `id_productprice` = 4416 ORDER BY `id` DESC LIMIT 0 , 30
30	0.24 ms	SELECT * FROM `type` WHERE TRUE AND `group` = 'sub_product_type' AND `name` = 'group' ORDER BY `id` DESC LIMIT 0 , 30
31	0.31 ms	SELECT * FROM `sub_product` WHERE TRUE AND `id_product` = 2675 AND `type` = 4 ORDER BY `id_language` ASC LIMIT 0 , 30
32	0.26 ms	SELECT * FROM `product_advantage` WHERE TRUE AND `id_product` = 2675 ORDER BY `id` DESC LIMIT 0 , 30
33	0.34 ms	SELECT a.*, m.id_language, m.name, m.description FROM `advantages` AS a INNER JOIN `advantage_meta` AS m on a.id=m.id_advantage WHERE TRUE AND a.`id` = 7 AND m.`id_language` = 1 ORDER BY `id` desc LIMIT 0 , 30
34	0.31 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 ='2675'
35	0.29 ms	SELECT * FROM `favorites` WHERE TRUE AND `id_product` = 2675 ORDER BY `id` DESC LIMIT 0 , 30
36	0.36 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.47 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` = 2675 AND cm.`id_language` = 1...
38	0.3 ms	SELECT * FROM `product_photos` WHERE TRUE AND `id_product` = 2675 ORDER BY `show_order` ASC LIMIT 0 , 30
39	0.22 ms	SELECT * FROM `languages` WHERE TRUE AND `name` = 'English'
40	0.3 ms	SELECT * FROM `destination_parent` WHERE TRUE AND `id_child` = 7 ORDER BY `id` DESC LIMIT 0 , 30
41	0.56 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.46 ms	SELECT * FROM `destination_parent` WHERE TRUE AND `id_child` = 3 ORDER BY `id` DESC LIMIT 0 , 30
43	0.79 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.34 ms	SELECT * FROM `destination_parent` WHERE TRUE AND `id_child` = 1 ORDER BY `id` DESC LIMIT 0 , 30
45	0.56 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` = 2675 AND p.`status` = 23 AND s.`status` = 10 ORDER BY `id` DESC LIMIT 0 , 3
46	22.22 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 ( 2675 ) 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.62 ms	SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 4608 AND `id_language` = 1 AND `metaname` = 'title' ORDER BY `id` DESC LIMIT 0 , 30
48	0.51 ms	SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 4608 AND `id_language` = 1 AND `metaname` = 'summary' ORDER BY `id` DESC LIMIT 0 , 30
49	0.43 ms	SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 4608 AND `id_language` = 1 AND `metaname` = 'typeHour' ORDER BY `id` DESC LIMIT 0 , 30
50	0.36 ms	SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 4608 AND `id_language` = 1 AND `metaname` = 'currency' ORDER BY `id` DESC LIMIT 0 , 30
51	0.33 ms	SELECT * FROM `seo` WHERE TRUE AND `id_product` = 4608 AND `id_language` = 1 ORDER BY `id` DESC LIMIT 0 , 30
52	0.31 ms	SELECT * FROM `product_photos` WHERE TRUE AND `id_product` = 4608 ORDER BY `id` DESC LIMIT 0 , 30
53	0.96 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` = 4608 ORDER BY s.`id_language` ASC
54	0.87 ms	SELECT * FROM `sub_product` WHERE TRUE AND `id_product` = 4608 AND `type` = 4 ORDER BY `id_language` ASC LIMIT 0 , 30
55	1.03 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.67 ms	SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 4605 AND `id_language` = 1 AND `metaname` = 'title' ORDER BY `id` DESC LIMIT 0 , 30
57	0.42 ms	SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 4605 AND `id_language` = 1 AND `metaname` = 'summary' ORDER BY `id` DESC LIMIT 0 , 30
58	0.46 ms	SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 4605 AND `id_language` = 1 AND `metaname` = 'typeHour' ORDER BY `id` DESC LIMIT 0 , 30
59	0.44 ms	SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 4605 AND `id_language` = 1 AND `metaname` = 'currency' ORDER BY `id` DESC LIMIT 0 , 30
60	0.37 ms	SELECT * FROM `seo` WHERE TRUE AND `id_product` = 4605 AND `id_language` = 1 ORDER BY `id` DESC LIMIT 0 , 30
61	0.3 ms	SELECT * FROM `product_photos` WHERE TRUE AND `id_product` = 4605 ORDER BY `id` DESC LIMIT 0 , 30
62	0.4 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` = 4605 ORDER BY s.`id_language` ASC
63	0.89 ms	SELECT * FROM `sub_product` WHERE TRUE AND `id_product` = 4605 AND `type` = 4 ORDER BY `id_language` ASC LIMIT 0 , 30
64	2.63 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.54 ms	SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 4607 AND `id_language` = 1 AND `metaname` = 'title' ORDER BY `id` DESC LIMIT 0 , 30
66	0.44 ms	SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 4607 AND `id_language` = 1 AND `metaname` = 'summary' ORDER BY `id` DESC LIMIT 0 , 30
67	0.41 ms	SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 4607 AND `id_language` = 1 AND `metaname` = 'typeHour' ORDER BY `id` DESC LIMIT 0 , 30
68	0.61 ms	SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 4607 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` = 4607 AND `id_language` = 1 ORDER BY `id` DESC LIMIT 0 , 30
70	0.81 ms	SELECT * FROM `product_photos` WHERE TRUE AND `id_product` = 4607 ORDER BY `id` DESC LIMIT 0 , 30
71	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` = 4607 ORDER BY s.`id_language` ASC
72	0.7 ms	SELECT * FROM `sub_product` WHERE TRUE AND `id_product` = 4607 AND `type` = 4 ORDER BY `id_language` ASC LIMIT 0 , 30
73	0.56 ms	SELECT SUM(rating_valueformoney) as rating_valueformoney, SUM(rating_convenience) as rating_convenience, SUM(rating_accessibility) as rating_accessibility, SUM(rating_overall) as rating_overall, AVG(rating_overall) as rating_overall_avg, COUNT(*) as review_count FROM `reviews` WHERE status IN...
74	0.72 ms	SELECT id_product, metavalue FROM `product_meta` WHERE id_product IN (?,?,?) AND metaname = ? AND id_language = ?
75	0.35 ms	SELECT * FROM `type` WHERE TRUE AND `group` = 'subproduct_blockeddates_block_type' ORDER BY `id` DESC LIMIT 0 , 30
76	0.32 ms	SELECT * FROM `subproduct_blockeddates` WHERE TRUE AND `id_subproduct` = 1162 ORDER BY `date` ASC LIMIT 0 , 30
77	0.67 ms	SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 2675 AND `id_language` = 1 AND `metaname` = 'availability_next_date' ORDER BY `id` DESC LIMIT 0 , 30
78	982.64 ms	SELECT * FROM `customer_productlog` WHERE TRUE
79	3.55 ms	INSERT INTO `customer_productlog` ( `id` , `content` ) VALUES( NULL , '{\"id_product\":\"2675\",\"id_user\":\"NULL\",\"dateVisited\":1785183869}' )
80	0.38 ms	SELECT * FROM `suppliers` s WHERE TRUE AND s.`id` = 36 ORDER BY `id` DESC
81	0.49 ms	SELECT * FROM `supplier_meta` WHERE TRUE AND `id_supplier` = 36 ORDER BY `id` DESC LIMIT 0 , 1000

Barcelona E-Bike Private Tour - Perfect City Experience for Family