Montjuïc Sunset eBike Tour: The Perfect Way to End Your Day in BarcelonaMontjuïc twilight eBike tour

arrow_back

arrow_forward

New Activity

Montjuïc Sunset e-Bike Tour in Barcelona

Name: Montjuïc Sunset e-Bike Tour in Barcelona
Brand: Dotravel
Price: 52.00 EUR
Availability: InStock

Duration: 3h

Group: Max 160 people

Feb 10, 2026

Our evening e-bike tour is a unique opportunity to see Barcelona as the sun goes down - ideal for snapping those Instagram-perfect shots.

FROM

€ 52

/pp

About This activity

E-Bike usage

Drinks and snacks

DoTravel

Meeting Point

Plaça de sant agusti vell 16

Discover the vibrant centre of Barcelona from a perspective you've never seen - the city at sunset.

This guided e-bike tour is perfect for fitness enthisiasts and avid cyclists, as well as those who rarely cycle. Taken at an easy pace, this is a great way to explore the city as the lights come on, seeing the spectacular sunsets over the Mediterranean Sea.

E-Bike usage

Drinks and snacks

Before You Go

Wear suitable clothing for the weather and comfortable shoes for cycling.

No reviews yet

Park Guell
Catalan Parliament
Sunset views over one of the world's most iconic cities
Up and coming trendy areas of Barcelona

Discovery Walk: Barcelona’s Ciutat Vella | Secret Alleys & Ruins

New Activity

schedule 2h

Discovery Walk: Barcelona’s Ciutat Vella | Secret Alleys & Ruins

Learn about the hidden gems of Barcelona on this self-guided discovery walk in the...

Next available: Feb 06, 2026

activity BOOK IT

FROM

€ 28

/pp

Alella Wine Tasting eBike Tour: Discover Catalonia Beyond Barcelona

New Activity

schedule 5h

Alella Wine Tasting eBike Tour: Discover Catalonia Beyond Barcelona

Ebike tour from Barcelona to Alella. We will take you to the lovely town of Alella with...

Next available: Feb 08, 2026

activity BOOK IT

FROM

€ 119

/pp

Sunset Spanish Guitar Live & Sailing Experience Barcelona | 2 Hours

New Activity

schedule 2h

Sunset Spanish Guitar Live & Sailing Experience Barcelona | 2 Hours

Set sail on a romantic Barcelona sunset cruise with live Spanish guitar music. Enjoy...

Next available: Feb 07, 2026

activity BOOK IT

FROM

€ 91

/pp

  DB
  79 queries
  |
  1328.4 ms

    Query Log (79 queries, 1328.4 ms)
    ×
  

    
    
  
Loading...

          
        #TimeQuery

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

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

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

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

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

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

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

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

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

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

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

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

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

            15
            0.3 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.51 ms
            SELECT SUM(rating_valueformoney) as rating_valueformoney, SUM(rating_convenience) as rating_convenience, SUM(rating_accessibility) as rating_accessibility, SUM(rating_overall) as rating_overall, AVG(rating_overall) as rating_overall_avg, COUNT(*) as review_count FROM `reviews` WHERE status IN...
          

            17
            0.56 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` = 4717 ORDER BY `rating_overall` desc LIMIT 20 , 30
          

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

            19
            0.43 ms
            SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 4717 AND `id_language` = 1 ORDER BY `id` DESC LIMIT 0 , 1000
          

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

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

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

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

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

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

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

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

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

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

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

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

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

            34
            0.36 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 ='4717'
          

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

            36
            0.42 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.42 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` = 4717 AND cm.`id_language` = 1...
          

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

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

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

            42
            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 =...
          

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

            76
            1102.73 ms
            SELECT * FROM `customer_productlog` WHERE TRUE
          

            77
            3.45 ms
            INSERT INTO `customer_productlog` ( `id` , `content` ) VALUES( NULL , '{\"id_product\":\"4717\",\"id_user\":\"NULL\",\"dateVisited\":1785178917}' )
          

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

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

      

#	Time	Query
1	1.35 ms	SELECT url, namespace, method, content_redirection FROM `redirect` WHERE status = 1
2	5.62 ms	INSERT INTO `log_customer` ( `id` , `id_customer` , `log` , `date` ) VALUES( NULL , NULL ,...
3	0.53 ms	SELECT * FROM `languages` WHERE TRUE AND `short` = 'en'
4	0.43 ms	SELECT * FROM `languages` WHERE TRUE AND `name` = 'English'
5	179.09 ms	SELECT * FROM `product_meta` WHERE TRUE AND `id_language` = 1 AND `metaname` = 'redirect_from_id' AND `metavalue` = '4717' ORDER BY `id` DESC LIMIT 0 , 30
6	0.51 ms	SELECT * FROM `products` p WHERE TRUE AND p.`id` = 4717 ORDER BY `id` DESC
7	0.33 ms	SELECT * FROM `type` WHERE TRUE AND `id` = 2 ORDER BY `id` DESC LIMIT 0 , 30
8	0.5 ms	SELECT * FROM `type` WHERE TRUE AND `group` = 'products_product_type' AND `name` = 'activity' ORDER BY `id` DESC LIMIT 0 , 30
9	0.35 ms	SELECT * FROM `sub_product` WHERE TRUE AND `id_product` = 4717 ORDER BY `id_language` DESC LIMIT 0 , 30
10	0.24 ms	SELECT * FROM `languages` WHERE TRUE AND `id` = 1
11	0.24 ms	SELECT * FROM `type` WHERE TRUE AND `id` = 4 ORDER BY `id` DESC LIMIT 0 , 30
12	0.4 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.31 ms	SELECT * FROM `products` p WHERE TRUE AND p.`id` = 4717 AND p.`status` = '23' ORDER BY `id` DESC
14	0.24 ms	SELECT * FROM `suppliers` s WHERE TRUE AND s.`id` = 36 ORDER BY `id` DESC
15	0.3 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.51 ms	SELECT SUM(rating_valueformoney) as rating_valueformoney, SUM(rating_convenience) as rating_convenience, SUM(rating_accessibility) as rating_accessibility, SUM(rating_overall) as rating_overall, AVG(rating_overall) as rating_overall_avg, COUNT(*) as review_count FROM `reviews` WHERE status IN...
17	0.56 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` = 4717 ORDER BY `rating_overall` desc LIMIT 20 , 30
18	0.31 ms	SELECT *, CONCAT(UCASE(LEFT(name, 1)), LCASE(SUBSTRING(REPLACE(name,'_',' '), 2))) as title FROM `status` WHERE TRUE AND `id` = '9' ORDER BY `id` DESC LIMIT 0 , 30
19	0.43 ms	SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 4717 AND `id_language` = 1 ORDER BY `id` DESC LIMIT 0 , 1000
20	0.57 ms	SELECT * FROM `product_system_meta` WHERE TRUE AND `id_product` = 4717 AND `metaname` = 'bookingextranote' ORDER BY `id` DESC LIMIT 0 , 30
21	0.45 ms	SELECT pr.price as min FROM `product_prices` as pr INNER JOIN `sub_product` AS s ON s.id = pr.id_subproduct INNER JOIN `age_group` AS a ON a.id = pr.id_agegroup -- WHERE a.show_order = 1 AND s.`id_product` = 4717 ORDER BY s.`id_language` ASC
22	0.4 ms	SELECT * FROM `product_system` WHERE TRUE AND `id_product_dotravel` = 4717 ORDER BY `id` DESC
23	0.42 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.52 ms	SELECT * FROM `sub_product` WHERE TRUE AND `id_product` = 4717 AND `status` = '15' ORDER BY `id` DESC LIMIT 0 , 30
25	0.44 ms	SELECT * FROM `product_photos` WHERE TRUE AND `id_product` = 4717 ORDER BY `show_order` asc LIMIT 0 , 30
26	0.42 ms	SELECT * FROM `seo` WHERE TRUE AND `id_product` = 4717 AND `id_language` = 1 ORDER BY `id` DESC LIMIT 0 , 30
27	0.36 ms	SELECT * FROM `sub_product` WHERE TRUE AND `id_product` = 4717 ORDER BY `id` DESC LIMIT 0 , 30
28	0.3 ms	SELECT * FROM `product_prices` WHERE TRUE AND `id_subproduct` = 3743 ORDER BY `id` DESC LIMIT 0 , 30
29	0.32 ms	SELECT * FROM `age_group` WHERE TRUE AND `id` = 1 ORDER BY `id` DESC LIMIT 0 , 30
30	0.32 ms	SELECT * FROM `product_bookingfees` WHERE TRUE AND `id_productprice` = 10026 ORDER BY `id` DESC LIMIT 0 , 30
31	0.35 ms	SELECT * FROM `type` WHERE TRUE AND `group` = 'sub_product_type' AND `name` = 'group' ORDER BY `id` DESC LIMIT 0 , 30
32	0.49 ms	SELECT * FROM `sub_product` WHERE TRUE AND `id_product` = 4717 AND `type` = 4 ORDER BY `id_language` ASC LIMIT 0 , 30
33	0.29 ms	SELECT * FROM `product_advantage` WHERE TRUE AND `id_product` = 4717 ORDER BY `id` DESC LIMIT 0 , 30
34	0.36 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 ='4717'
35	0.26 ms	SELECT * FROM `favorites` WHERE TRUE AND `id_product` = 4717 ORDER BY `id` DESC LIMIT 0 , 30
36	0.42 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.42 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` = 4717 AND cm.`id_language` = 1...
38	0.32 ms	SELECT * FROM `product_photos` WHERE TRUE AND `id_product` = 4717 ORDER BY `show_order` ASC LIMIT 0 , 30
39	0.45 ms	SELECT * FROM `destination_parent` WHERE TRUE AND `id_child` = 7 ORDER BY `id` DESC LIMIT 0 , 30
40	0.5 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.3 ms	SELECT * FROM `destination_parent` WHERE TRUE AND `id_child` = 3 ORDER BY `id` DESC LIMIT 0 , 30
42	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 =...
43	0.22 ms	SELECT * FROM `destination_parent` WHERE TRUE AND `id_child` = 1 ORDER BY `id` DESC LIMIT 0 , 30
44	0.65 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` = 4717 AND p.`status` = 23 AND s.`status` = 10 ORDER BY `id` DESC LIMIT 0 , 3
45	0.44 ms	SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 4716 AND `id_language` = 1 AND `metaname` = 'title' ORDER BY `id` DESC LIMIT 0 , 30
46	0.41 ms	SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 4716 AND `id_language` = 1 AND `metaname` = 'summary' ORDER BY `id` DESC LIMIT 0 , 30
47	0.38 ms	SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 4716 AND `id_language` = 1 AND `metaname` = 'typeHour' ORDER BY `id` DESC LIMIT 0 , 30
48	0.47 ms	SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 4716 AND `id_language` = 1 AND `metaname` = 'currency' ORDER BY `id` DESC LIMIT 0 , 30
49	0.53 ms	SELECT * FROM `seo` WHERE TRUE AND `id_product` = 4716 AND `id_language` = 1 ORDER BY `id` DESC LIMIT 0 , 30
50	0.41 ms	SELECT * FROM `product_photos` WHERE TRUE AND `id_product` = 4716 ORDER BY `id` DESC LIMIT 0 , 30
51	0.43 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` = 4716 ORDER BY s.`id_language` ASC
52	0.78 ms	SELECT * FROM `sub_product` WHERE TRUE AND `id_product` = 4716 AND `type` = 4 ORDER BY `id_language` ASC LIMIT 0 , 30
53	0.58 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.54 ms	SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 4714 AND `id_language` = 1 AND `metaname` = 'title' ORDER BY `id` DESC LIMIT 0 , 30
55	0.48 ms	SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 4714 AND `id_language` = 1 AND `metaname` = 'summary' ORDER BY `id` DESC LIMIT 0 , 30
56	0.46 ms	SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 4714 AND `id_language` = 1 AND `metaname` = 'typeHour' ORDER BY `id` DESC LIMIT 0 , 30
57	0.42 ms	SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 4714 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` = 4714 AND `id_language` = 1 ORDER BY `id` DESC LIMIT 0 , 30
59	0.41 ms	SELECT * FROM `product_photos` WHERE TRUE AND `id_product` = 4714 ORDER BY `id` DESC LIMIT 0 , 30
60	0.53 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` = 4714 ORDER BY s.`id_language` ASC
61	0.81 ms	SELECT * FROM `sub_product` WHERE TRUE AND `id_product` = 4714 AND `type` = 4 ORDER BY `id_language` ASC LIMIT 0 , 30
62	0.64 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.61 ms	SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 4614 AND `id_language` = 1 AND `metaname` = 'title' ORDER BY `id` DESC LIMIT 0 , 30
64	0.52 ms	SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 4614 AND `id_language` = 1 AND `metaname` = 'summary' ORDER BY `id` DESC LIMIT 0 , 30
65	0.43 ms	SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 4614 AND `id_language` = 1 AND `metaname` = 'typeHour' ORDER BY `id` DESC LIMIT 0 , 30
66	0.42 ms	SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 4614 AND `id_language` = 1 AND `metaname` = 'currency' ORDER BY `id` DESC LIMIT 0 , 30
67	0.3 ms	SELECT * FROM `seo` WHERE TRUE AND `id_product` = 4614 AND `id_language` = 1 ORDER BY `id` DESC LIMIT 0 , 30
68	0.42 ms	SELECT * FROM `product_photos` WHERE TRUE AND `id_product` = 4614 ORDER BY `id` DESC LIMIT 0 , 30
69	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` = 4614 ORDER BY s.`id_language` ASC
70	0.84 ms	SELECT * FROM `sub_product` WHERE TRUE AND `id_product` = 4614 AND `type` = 4 ORDER BY `id_language` ASC LIMIT 0 , 30
71	0.55 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.82 ms	SELECT id_product, metavalue FROM `product_meta` WHERE id_product IN (?,?,?) AND metaname = ? AND id_language = ?
73	0.43 ms	SELECT * FROM `type` WHERE TRUE AND `group` = 'subproduct_blockeddates_block_type' ORDER BY `id` DESC LIMIT 0 , 30
74	0.33 ms	SELECT * FROM `subproduct_blockeddates` WHERE TRUE AND `id_subproduct` = 3743 ORDER BY `date` ASC LIMIT 0 , 30
75	0.99 ms	SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 4717 AND `id_language` = 1 AND `metaname` = 'availability_next_date' ORDER BY `id` DESC LIMIT 0 , 30
76	1102.73 ms	SELECT * FROM `customer_productlog` WHERE TRUE
77	3.45 ms	INSERT INTO `customer_productlog` ( `id` , `content` ) VALUES( NULL , '{\"id_product\":\"4717\",\"id_user\":\"NULL\",\"dateVisited\":1785178917}' )
78	0.58 ms	SELECT * FROM `suppliers` s WHERE TRUE AND s.`id` = 36 ORDER BY `id` DESC
79	3.22 ms	SELECT * FROM `supplier_meta` WHERE TRUE AND `id_supplier` = 36 ORDER BY `id` DESC LIMIT 0 , 1000

Montjuïc Sunset e-Bike Tour in Barcelona