Book Half Day Dubai City Tour with Dubai Frame Tickets

Half-Day Dubai City Tour with Tickets to Dubai Frame

Duration: 4h-5h

Group: Max 50 people

Jan 10, 2026

About This tour

Hotel Pick-up and Drop-off from selected hotel or location in Dubai

Professional Guide

Visit to the world-renowned luxurious hotel, the Burj Al Arab

Vixsit of Souk Madinat Jumeirah, an ancient market place

Visit of of Atlantis, The Palm, the luxurious hotel located in Palm Jumeirah

Visit to the Blue Mosque

Entrance Ticket to Dubai Frame

Half Day Dubai City Guided Tour

Food and Beverages

Guiding inside the Frame

Your Old and Modern Dubai city tour with Blue Mosque visit and Dubai Frame tickets will begin with a timely pick up from your hotel or the preferred location in Dubai. Enjoy the drive in an air-conditioned vehicle to Palm Jumeirah, the man-made island of Dubai resembling the shape of a Palm Tree.

Get yourselves clicked in the backdrop of Atlantis, The Palm - the luxurious hotel located in Palm Jumeirah. Also, behold the enchanting waterfront views of the Dubai Marina from the island.

Hotel Pick-up and Drop-off from selected hotel or location in Dubai

Professional Guide

Visit to the world-renowned luxurious hotel, the Burj Al Arab

Vixsit of Souk Madinat Jumeirah, an ancient market place

Visit of of Atlantis, The Palm, the luxurious hotel located in Palm Jumeirah

Visit to the Blue Mosque

Entrance Ticket to Dubai Frame

Half Day Dubai City Guided Tour

Food and Beverages

Guiding inside the Frame

Before You Go

The duration of the tour includes the pick-up and drop off times

Pickup will be within 30 minutes of your booked time

This trip is wheelchair inaccessible

The duration of the tour will be around 4 - 5 hours depending upon the traffic

Reviews

Then we will proceed to Souk Madinat Jumeirah, the re-creation of an ancient market place. Stroll through the souk from where you can behold the world-renowned luxurious hotel, the Burj Al Arab. Capture some snapshots in its backdrop before leaving the Souk. Later, we will move on to visit the Blue Mosque, also known as the Al Farooq Omar Bin Al Khattab Mosque. Marvel at its wonderful interiors with chandeliers and a library with a massive collection of religious books. The sightseeing activities in Modern Dubai comes to an end with the Blue Mosque visit.

Now it’s time to explore Old Dubai to embrace the rich culture and tradition. Take a walk along the Dubai Creek, the region where the history of the town lies. Cross the Creek in an Abra water taxi, the ancient means of transportation to experience shopping at the Gold and Spice Souks. Enjoy your time at the Souks amidst the glittering jewellery along with fragrant spices and herbs.

Afterwards, we will visit the landmark destination, the Dubai Frame. Spend your time at the glass-floored walkway that connects two tall towers. You can witness the sights of Old Dubai in the northern part and Modern Dubai in the southern region from the view right from the glass walkway. Soon after the Dubai Frame visit, you will be transferred back to your hotel or the preferred location.

Splendid photo-stop at the man-made isle of Palm Jumeirah
Experience the ambience of an ancient marketplace at the Souk Madinat Jumeirah
From Madinat Jumeirah, get some amazing clicks in the backdrop of Burj Al Arab
Behold the Islamic architecture at the Blue Mosque
Visit Old Dubai and enjoy the shopping experiences at Gold and Spice Souks
Witness the charm of Old and Modern Dubai from the elevations of Dubai Frame

#	Time	Query
1	1.47 ms	SELECT url, namespace, method, content_redirection FROM `redirect` WHERE status = 1
2	6.34 ms	INSERT INTO `log_customer` ( `id` , `id_customer` , `log` , `date` ) VALUES( NULL , NULL ,...
3	0.41 ms	SELECT * FROM `languages` WHERE TRUE AND `short` = 'en'
4	156.17 ms	SELECT * FROM `product_meta` WHERE TRUE AND `id_language` = 1 AND `metaname` = 'redirect_from_id' AND `metavalue` = '3707' ORDER BY `id` DESC LIMIT 0 , 30
5	0.43 ms	SELECT * FROM `products` p WHERE TRUE AND p.`id` = 3707 ORDER BY `id` DESC
6	0.39 ms	SELECT * FROM `type` WHERE TRUE AND `id` = 3 ORDER BY `id` DESC LIMIT 0 , 30
7	0.3 ms	SELECT * FROM `type` WHERE TRUE AND `group` = 'products_product_type' AND `name` = 'tour' ORDER BY `id` DESC LIMIT 0 , 30
8	0.28 ms	SELECT * FROM `sub_product` WHERE TRUE AND `id_product` = 3707 ORDER BY `id_language` DESC LIMIT 0 , 30
9	0.19 ms	SELECT * FROM `languages` WHERE TRUE AND `id` = 1
10	0.2 ms	SELECT * FROM `type` WHERE TRUE AND `id` = 4 ORDER BY `id` DESC LIMIT 0 , 30
11	0.41 ms	SELECT *, CONCAT(UCASE(LEFT(name, 1)), LCASE(SUBSTRING(REPLACE(name,'_',' '), 2))) as title FROM `status` WHERE TRUE AND `name` = 'published' AND `group` = 'products_status' ORDER BY `id` DESC LIMIT 0 , 30
12	0.28 ms	SELECT * FROM `products` p WHERE TRUE AND p.`id` = 3707 AND p.`status` = '23' ORDER BY `id` DESC
13	0.28 ms	SELECT * FROM `suppliers` s WHERE TRUE AND s.`id` = 36 ORDER BY `id` DESC
14	0.26 ms	SELECT *, CONCAT(UCASE(LEFT(name, 1)), LCASE(SUBSTRING(REPLACE(name,'_',' '), 2))) as title FROM `status` WHERE TRUE AND `id` = '10' ORDER BY `id` DESC LIMIT 0 , 30
15	0.61 ms	SELECT SUM(rating_valueformoney) as rating_valueformoney, SUM(rating_convenience) as rating_convenience, SUM(rating_accessibility) as rating_accessibility, SUM(rating_overall) as rating_overall, AVG(rating_overall) as rating_overall_avg, COUNT(*) as review_count FROM `reviews` WHERE status IN...
16	0.58 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` = 3707 ORDER BY `rating_overall` desc LIMIT 20 , 30
17	0.24 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.58 ms	SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 3707 AND `id_language` = 1 ORDER BY `id` DESC LIMIT 0 , 1000
19	0.46 ms	SELECT * FROM `product_system_meta` WHERE TRUE AND `id_product` = 3707 AND `metaname` = 'bookingextranote' ORDER BY `id` DESC LIMIT 0 , 30
20	0.38 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` = 3707 ORDER BY s.`id_language` ASC
21	0.27 ms	SELECT * FROM `product_system` WHERE TRUE AND `id_product_dotravel` = 3707 ORDER BY `id` DESC
22	0.35 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.29 ms	SELECT * FROM `sub_product` WHERE TRUE AND `id_product` = 3707 AND `status` = '15' ORDER BY `id` DESC LIMIT 0 , 30
24	0.27 ms	SELECT * FROM `product_photos` WHERE TRUE AND `id_product` = 3707 ORDER BY `show_order` asc LIMIT 0 , 30
25	0.3 ms	SELECT * FROM `seo` WHERE TRUE AND `id_product` = 3707 AND `id_language` = 1 ORDER BY `id` DESC LIMIT 0 , 30
26	0.27 ms	SELECT * FROM `sub_product` WHERE TRUE AND `id_product` = 3707 ORDER BY `id` DESC LIMIT 0 , 30
27	0.29 ms	SELECT * FROM `product_prices` WHERE TRUE AND `id_subproduct` = 2365 ORDER BY `id` DESC LIMIT 0 , 30
28	0.22 ms	SELECT * FROM `age_group` WHERE TRUE AND `id` = 1 ORDER BY `id` DESC LIMIT 0 , 30
29	0.25 ms	SELECT * FROM `product_bookingfees` WHERE TRUE AND `id_productprice` = 6689 ORDER BY `id` DESC LIMIT 0 , 30
30	0.28 ms	SELECT * FROM `type` WHERE TRUE AND `group` = 'sub_product_type' AND `name` = 'group' ORDER BY `id` DESC LIMIT 0 , 30
31	0.33 ms	SELECT * FROM `sub_product` WHERE TRUE AND `id_product` = 3707 AND `type` = 4 ORDER BY `id_language` ASC LIMIT 0 , 30
32	0.34 ms	SELECT * FROM `product_advantage` WHERE TRUE AND `id_product` = 3707 ORDER BY `id` DESC LIMIT 0 , 30
33	0.36 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.29 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 ='3707'
35	0.27 ms	SELECT * FROM `favorites` WHERE TRUE AND `id_product` = 3707 ORDER BY `id` DESC LIMIT 0 , 30
36	0.32 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.36 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` = 3707 AND cm.`id_language` = 1...
38	0.27 ms	SELECT * FROM `product_photos` WHERE TRUE AND `id_product` = 3707 ORDER BY `show_order` ASC LIMIT 0 , 30
39	0.19 ms	SELECT * FROM `languages` WHERE TRUE AND `name` = 'English'
40	0.3 ms	SELECT * FROM `destination_parent` WHERE TRUE AND `id_child` = 75 ORDER BY `id` DESC LIMIT 0 , 30
41	0.4 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.23 ms	SELECT * FROM `destination_parent` WHERE TRUE AND `id_child` = 71 ORDER BY `id` DESC LIMIT 0 , 30
43	0.37 ms	SELECT destinations.id, destination_meta.name,seo_url FROM `destinations` join destination_meta on destination_meta.id_destination = destinations.id join destination_parent on destination_parent.id_parent = destinations.id where true AND destinations.status = 24 AND destination_meta.id_language =...
44	0.2 ms	SELECT * FROM `destination_parent` WHERE TRUE AND `id_child` = 70 ORDER BY `id` DESC LIMIT 0 , 30
45	0.49 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` = 3707 AND p.`status` = 23 AND s.`status` = 10 ORDER BY `id` DESC LIMIT 0 , 3
46	15.45 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 ( 3707 ) AND st.name = 'active' AND st.group = 'suppliers_status' AND p.id IN ( SELECT id_product FROM `product_destination` WHERE id_destination IN...
47	0.74 ms	SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 3702 AND `id_language` = 1 AND `metaname` = 'title' ORDER BY `id` DESC LIMIT 0 , 30
48	0.56 ms	SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 3702 AND `id_language` = 1 AND `metaname` = 'summary' ORDER BY `id` DESC LIMIT 0 , 30
49	0.48 ms	SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 3702 AND `id_language` = 1 AND `metaname` = 'typeHour' ORDER BY `id` DESC LIMIT 0 , 30
50	0.52 ms	SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 3702 AND `id_language` = 1 AND `metaname` = 'currency' ORDER BY `id` DESC LIMIT 0 , 30
51	0.28 ms	SELECT * FROM `seo` WHERE TRUE AND `id_product` = 3702 AND `id_language` = 1 ORDER BY `id` DESC LIMIT 0 , 30
52	0.21 ms	SELECT * FROM `type` WHERE TRUE AND `id` = 2 ORDER BY `id` DESC LIMIT 0 , 30
53	0.24 ms	SELECT * FROM `product_photos` WHERE TRUE AND `id_product` = 3702 ORDER BY `id` DESC LIMIT 0 , 30
54	0.32 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` = 3702 ORDER BY s.`id_language` ASC
55	0.59 ms	SELECT * FROM `sub_product` WHERE TRUE AND `id_product` = 3702 AND `type` = 4 ORDER BY `id_language` ASC LIMIT 0 , 30
56	0.43 ms	SELECT SUM(rating_valueformoney) as rating_valueformoney, SUM(rating_convenience) as rating_convenience, SUM(rating_accessibility) as rating_accessibility, SUM(rating_overall) as rating_overall, AVG(rating_overall) as rating_overall_avg, COUNT(*) as review_count FROM `reviews` WHERE status IN...
57	0.46 ms	SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 3725 AND `id_language` = 1 AND `metaname` = 'title' ORDER BY `id` DESC LIMIT 0 , 30
58	0.45 ms	SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 3725 AND `id_language` = 1 AND `metaname` = 'summary' ORDER BY `id` DESC LIMIT 0 , 30
59	0.49 ms	SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 3725 AND `id_language` = 1 AND `metaname` = 'typeHour' ORDER BY `id` DESC LIMIT 0 , 30
60	0.35 ms	SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 3725 AND `id_language` = 1 AND `metaname` = 'currency' ORDER BY `id` DESC LIMIT 0 , 30
61	0.25 ms	SELECT * FROM `seo` WHERE TRUE AND `id_product` = 3725 AND `id_language` = 1 ORDER BY `id` DESC LIMIT 0 , 30
62	0.25 ms	SELECT * FROM `product_photos` WHERE TRUE AND `id_product` = 3725 ORDER BY `id` DESC LIMIT 0 , 30
63	0.31 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` = 3725 ORDER BY s.`id_language` ASC
64	0.67 ms	SELECT * FROM `sub_product` WHERE TRUE AND `id_product` = 3725 AND `type` = 4 ORDER BY `id_language` ASC LIMIT 0 , 30
65	0.43 ms	SELECT SUM(rating_valueformoney) as rating_valueformoney, SUM(rating_convenience) as rating_convenience, SUM(rating_accessibility) as rating_accessibility, SUM(rating_overall) as rating_overall, AVG(rating_overall) as rating_overall_avg, COUNT(*) as review_count FROM `reviews` WHERE status IN...
66	0.52 ms	SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 3724 AND `id_language` = 1 AND `metaname` = 'title' ORDER BY `id` DESC LIMIT 0 , 30
67	0.41 ms	SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 3724 AND `id_language` = 1 AND `metaname` = 'summary' ORDER BY `id` DESC LIMIT 0 , 30
68	0.39 ms	SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 3724 AND `id_language` = 1 AND `metaname` = 'typeHour' ORDER BY `id` DESC LIMIT 0 , 30
69	0.36 ms	SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 3724 AND `id_language` = 1 AND `metaname` = 'currency' ORDER BY `id` DESC LIMIT 0 , 30
70	0.28 ms	SELECT * FROM `seo` WHERE TRUE AND `id_product` = 3724 AND `id_language` = 1 ORDER BY `id` DESC LIMIT 0 , 30
71	0.23 ms	SELECT * FROM `product_photos` WHERE TRUE AND `id_product` = 3724 ORDER BY `id` DESC LIMIT 0 , 30
72	0.31 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` = 3724 ORDER BY s.`id_language` ASC
73	0.72 ms	SELECT * FROM `sub_product` WHERE TRUE AND `id_product` = 3724 AND `type` = 4 ORDER BY `id_language` ASC LIMIT 0 , 30
74	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...
75	1.08 ms	SELECT id_product, metavalue FROM `product_meta` WHERE id_product IN (?,?,?) AND metaname = ? AND id_language = ?
76	0.34 ms	SELECT * FROM `type` WHERE TRUE AND `group` = 'subproduct_blockeddates_block_type' ORDER BY `id` DESC LIMIT 0 , 30
77	0.31 ms	SELECT * FROM `subproduct_blockeddates` WHERE TRUE AND `id_subproduct` = 2365 ORDER BY `date` ASC LIMIT 0 , 30
78	0.49 ms	SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 3707 AND `id_language` = 1 AND `metaname` = 'availability_next_date' ORDER BY `id` DESC LIMIT 0 , 30
79	830.47 ms	SELECT * FROM `customer_productlog` WHERE TRUE
80	2.84 ms	INSERT INTO `customer_productlog` ( `id` , `content` ) VALUES( NULL , '{\"id_product\":\"3707\",\"id_user\":\"NULL\",\"dateVisited\":1785173333}' )
81	0.4 ms	SELECT * FROM `suppliers` s WHERE TRUE AND s.`id` = 36 ORDER BY `id` DESC
82	0.34 ms	SELECT * FROM `supplier_meta` WHERE TRUE AND `id_supplier` = 36 ORDER BY `id` DESC LIMIT 0 , 1000

Time

Query

1.47 ms

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

6.34 ms

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

0.41 ms

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

156.17 ms

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

0.43 ms

SELECT * FROM `products` p WHERE TRUE AND p.`id` = 3707 ORDER BY `id` DESC

0.39 ms

SELECT * FROM `type` WHERE TRUE AND `id` = 3 ORDER BY `id` DESC LIMIT 0 , 30

0.3 ms

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

0.28 ms

SELECT * FROM `sub_product` WHERE TRUE AND `id_product` = 3707 ORDER BY `id_language` DESC LIMIT 0 , 30

0.19 ms

SELECT * FROM `languages` WHERE TRUE AND `id` = 1

0.2 ms

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

0.41 ms

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

0.28 ms

SELECT * FROM `products` p WHERE TRUE AND p.`id` = 3707 AND p.`status` = '23' ORDER BY `id` DESC

0.28 ms

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

0.26 ms

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

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

0.58 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` = 3707 ORDER BY `rating_overall` desc LIMIT 20 , 30

0.24 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

0.58 ms

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

0.46 ms

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

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

0.27 ms

SELECT * FROM `product_system` WHERE TRUE AND `id_product_dotravel` = 3707 ORDER BY `id` DESC

0.35 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

0.29 ms

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

0.27 ms

SELECT * FROM `product_photos` WHERE TRUE AND `id_product` = 3707 ORDER BY `show_order` asc LIMIT 0 , 30

0.3 ms

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

0.27 ms

SELECT * FROM `sub_product` WHERE TRUE AND `id_product` = 3707 ORDER BY `id` DESC LIMIT 0 , 30

0.29 ms

SELECT * FROM `product_prices` WHERE TRUE AND `id_subproduct` = 2365 ORDER BY `id` DESC LIMIT 0 , 30

0.22 ms

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

0.25 ms

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

0.28 ms

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

0.33 ms

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

0.34 ms

SELECT * FROM `product_advantage` WHERE TRUE AND `id_product` = 3707 ORDER BY `id` DESC LIMIT 0 , 30

0.36 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

0.29 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 ='3707'

0.27 ms

SELECT * FROM `favorites` WHERE TRUE AND `id_product` = 3707 ORDER BY `id` DESC LIMIT 0 , 30

0.32 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

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

0.27 ms

SELECT * FROM `product_photos` WHERE TRUE AND `id_product` = 3707 ORDER BY `show_order` ASC LIMIT 0 , 30

0.19 ms

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

0.3 ms

SELECT * FROM `destination_parent` WHERE TRUE AND `id_child` = 75 ORDER BY `id` DESC LIMIT 0 , 30

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

0.23 ms

SELECT * FROM `destination_parent` WHERE TRUE AND `id_child` = 71 ORDER BY `id` DESC LIMIT 0 , 30

0.37 ms

0.2 ms

SELECT * FROM `destination_parent` WHERE TRUE AND `id_child` = 70 ORDER BY `id` DESC LIMIT 0 , 30

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

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

0.74 ms

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

0.56 ms

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

0.48 ms

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

0.52 ms

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

0.28 ms

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

0.21 ms

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

0.24 ms

SELECT * FROM `product_photos` WHERE TRUE AND `id_product` = 3702 ORDER BY `id` DESC LIMIT 0 , 30

0.32 ms

0.59 ms

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

0.43 ms

0.46 ms

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

0.45 ms

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

0.49 ms

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

0.35 ms

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

0.25 ms

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

0.25 ms

SELECT * FROM `product_photos` WHERE TRUE AND `id_product` = 3725 ORDER BY `id` DESC LIMIT 0 , 30

0.31 ms

0.67 ms

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

0.43 ms

0.52 ms

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

0.41 ms

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

0.39 ms

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

0.36 ms

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

0.28 ms

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

0.23 ms

SELECT * FROM `product_photos` WHERE TRUE AND `id_product` = 3724 ORDER BY `id` DESC LIMIT 0 , 30

0.31 ms

0.72 ms

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

0.51 ms

1.08 ms

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

0.34 ms

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

0.31 ms

SELECT * FROM `subproduct_blockeddates` WHERE TRUE AND `id_subproduct` = 2365 ORDER BY `date` ASC LIMIT 0 , 30

0.49 ms

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

830.47 ms

SELECT * FROM `customer_productlog` WHERE TRUE

2.84 ms

INSERT INTO `customer_productlog` ( `id` , `content` ) VALUES( NULL , '{\"id_product\":\"3707\",\"id_user\":\"NULL\",\"dateVisited\":1785173333}' )

0.4 ms

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

0.34 ms

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

Half-Day Dubai City Tour with Tickets to Dubai Frame

Half-Day Dubai City Tour with Tickets to Dubai Frame

About This tour

Meeting Point

Reviews

You might also like

Day-Trip from Dubai: Abu Dhabi Tour with Etihad Towers Ticket

Downtown Dubai Architecture Walking Tour

Dubai Walking Tour: Art , Jewels and Chocolate