Book Dubai Morning Safari:Red Dunes,Sandsurf, Camel Ride|DoTravel

About This activity

Pick-Up and Drop-Off from your location or a hotel

Professional Safari Guide

Brunch at the camp

Welcome drinks

Camel riding

Sandboarding

Dune bashing

4-Hour Morning Desert Safari Dubai

Dune Buggy

Quad Bike

Get ready for your Morning Desert Safari Dubai Tour as our guide picks you from your selected location or hotel. Board our luxurious 4x4 Land Cruiser that will take you to the desert. Once you reach there, take a small break for 20-25 minutes, make use of bathrooms, rest, or even opt for a quad bike drive, while your vehicle readies for the off-road drive with adjusted tyre pressures.

Then, seat comfortably for the thrilling morning dune bashing session. Enjoy the rhythm of the vehicle riding over the sand dunes and feel the adrenaline rush![readmore]After around 35-45 minutes of morning dune bashing in Dubai red dunes, click as many photos you want and relax for some time before you proceed for sand surfing (sandboarding). First, follow the instructions of your guide before you climb up and down the sandbanks on your board. As you surf over the sands, you will find this quite funny and unique!

After that, we will proceed to a typical old-fashioned Al Khayma desert camp. There get a warm welcome with Arabian coffee, sweets (gahwa, gaymat), with dry fruits and all. Thereafter go for a Camel riding Dubai in the camp neighbourhood... ride along the desert dunes and feel like getting absorbed in the desert charm. On return, get refreshed with a brunch (small meal) from the camp. Later on, our guide will drop you off at your preferred location or hotel.

Pick-Up and Drop-Off from your location or a hotel

Professional Safari Guide

Brunch at the camp

Welcome drinks

Camel riding

Sandboarding

Dune bashing

4-Hour Morning Desert Safari Dubai

Dune Buggy

Quad Bike

Before You Go

Your belongings are your own responsibility

We also recommend not to eat 2-3 hours before the safari trip

Sports shoes are recommended so you can be able to practice the sand-boarding safely

It is not recommended to carry jewellery, expensive watches or cell phones as the phone signal is not working in the desert

Pregnant ladies and also those with back pains, neck pains, are not allowed

Reviews

Explore the morning beauty of Arabian red dunes desert
Feel the excitement of morning dune bashing Dubai in a 4x4 Land Cruiser
Ride on a Camel in the desert terrains
Capture nice panoramic photos in the desert
Satisfy your stomach with a brunch from Al Khayma desert camp

#	Time	Query
1	2.32 ms	SELECT url, namespace, method, content_redirection FROM `redirect` WHERE status = 1
2	7.4 ms	INSERT INTO `log_customer` ( `id` , `id_customer` , `log` , `date` ) VALUES( NULL , NULL ,...
3	0.61 ms	SELECT * FROM `languages` WHERE TRUE AND `short` = 'en'
4	0.64 ms	SELECT * FROM `languages` WHERE TRUE AND `name` = 'English'
5	284.08 ms	SELECT * FROM `product_meta` WHERE TRUE AND `id_language` = 1 AND `metaname` = 'redirect_from_id' AND `metavalue` = '3692' ORDER BY `id` DESC LIMIT 0 , 30
6	0.39 ms	SELECT * FROM `products` p WHERE TRUE AND p.`id` = 3692 ORDER BY `id` DESC
7	0.29 ms	SELECT * FROM `type` WHERE TRUE AND `id` = 2 ORDER BY `id` DESC LIMIT 0 , 30
8	0.48 ms	SELECT * FROM `type` WHERE TRUE AND `group` = 'products_product_type' AND `name` = 'activity' ORDER BY `id` DESC LIMIT 0 , 30
9	0.55 ms	SELECT * FROM `sub_product` WHERE TRUE AND `id_product` = 3692 ORDER BY `id_language` DESC LIMIT 0 , 30
10	0.21 ms	SELECT * FROM `languages` WHERE TRUE AND `id` = 1
11	0.2 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.64 ms	SELECT * FROM `products` p WHERE TRUE AND p.`id` = 3692 AND p.`status` = '23' ORDER BY `id` DESC
14	0.26 ms	SELECT * FROM `suppliers` s WHERE TRUE AND s.`id` = 36 ORDER BY `id` DESC
15	1.06 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.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...
17	0.71 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` = 3692 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.93 ms	SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 3692 AND `id_language` = 1 ORDER BY `id` DESC LIMIT 0 , 1000
20	0.68 ms	SELECT * FROM `product_system_meta` WHERE TRUE AND `id_product` = 3692 AND `metaname` = 'bookingextranote' ORDER BY `id` DESC LIMIT 0 , 30
21	0.44 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` = 3692 ORDER BY s.`id_language` ASC
22	0.52 ms	SELECT * FROM `product_system` WHERE TRUE AND `id_product_dotravel` = 3692 ORDER BY `id` DESC
23	1 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.66 ms	SELECT * FROM `sub_product` WHERE TRUE AND `id_product` = 3692 AND `status` = '15' ORDER BY `id` DESC LIMIT 0 , 30
25	0.36 ms	SELECT * FROM `product_photos` WHERE TRUE AND `id_product` = 3692 ORDER BY `show_order` asc LIMIT 0 , 30
26	0.92 ms	SELECT * FROM `seo` WHERE TRUE AND `id_product` = 3692 AND `id_language` = 1 ORDER BY `id` DESC LIMIT 0 , 30
27	0.27 ms	SELECT * FROM `sub_product` WHERE TRUE AND `id_product` = 3692 ORDER BY `id` DESC LIMIT 0 , 30
28	0.66 ms	SELECT * FROM `product_prices` WHERE TRUE AND `id_subproduct` = 2348 ORDER BY `id` DESC LIMIT 0 , 30
29	0.61 ms	SELECT * FROM `age_group` WHERE TRUE AND `id` = 1 ORDER BY `id` DESC LIMIT 0 , 30
30	0.39 ms	SELECT * FROM `product_bookingfees` WHERE TRUE AND `id_productprice` = 6670 ORDER BY `id` DESC LIMIT 0 , 30
31	0.33 ms	SELECT * FROM `type` WHERE TRUE AND `group` = 'sub_product_type' AND `name` = 'group' ORDER BY `id` DESC LIMIT 0 , 30
32	0.38 ms	SELECT * FROM `sub_product` WHERE TRUE AND `id_product` = 3692 AND `type` = 4 ORDER BY `id_language` ASC LIMIT 0 , 30
33	0.87 ms	SELECT * FROM `product_advantage` WHERE TRUE AND `id_product` = 3692 ORDER BY `id` DESC LIMIT 0 , 30
34	0.39 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
35	0.59 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 ='3692'
36	0.39 ms	SELECT * FROM `favorites` WHERE TRUE AND `id_product` = 3692 ORDER BY `id` DESC LIMIT 0 , 30
37	0.94 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
38	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` = 3692 AND cm.`id_language` = 1...
39	0.39 ms	SELECT * FROM `product_photos` WHERE TRUE AND `id_product` = 3692 ORDER BY `show_order` ASC LIMIT 0 , 30
40	0.83 ms	SELECT * FROM `destination_parent` WHERE TRUE AND `id_child` = 75 ORDER BY `id` DESC LIMIT 0 , 30
41	0.81 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	1.73 ms	SELECT * FROM `destination_parent` WHERE TRUE AND `id_child` = 71 ORDER BY `id` DESC LIMIT 0 , 30
43	0.86 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.31 ms	SELECT * FROM `destination_parent` WHERE TRUE AND `id_child` = 70 ORDER BY `id` DESC LIMIT 0 , 30
45	1.41 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` = 3692 AND p.`status` = 23 AND s.`status` = 10 ORDER BY `id` DESC LIMIT 0 , 3
46	21.37 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 ( 3692 ) 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.95 ms	SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 3740 AND `id_language` = 1 AND `metaname` = 'title' ORDER BY `id` DESC LIMIT 0 , 30
48	0.54 ms	SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 3740 AND `id_language` = 1 AND `metaname` = 'summary' ORDER BY `id` DESC LIMIT 0 , 30
49	1.63 ms	SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 3740 AND `id_language` = 1 AND `metaname` = 'typeHour' ORDER BY `id` DESC LIMIT 0 , 30
50	0.44 ms	SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 3740 AND `id_language` = 1 AND `metaname` = 'currency' ORDER BY `id` DESC LIMIT 0 , 30
51	0.37 ms	SELECT * FROM `seo` WHERE TRUE AND `id_product` = 3740 AND `id_language` = 1 ORDER BY `id` DESC LIMIT 0 , 30
52	0.41 ms	SELECT * FROM `product_photos` WHERE TRUE AND `id_product` = 3740 ORDER BY `id` DESC LIMIT 0 , 30
53	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` = 3740 ORDER BY s.`id_language` ASC
54	0.52 ms	SELECT * FROM `sub_product` WHERE TRUE AND `id_product` = 3740 AND `type` = 4 ORDER BY `id_language` ASC LIMIT 0 , 30
55	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...
56	0.76 ms	SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 3699 AND `id_language` = 1 AND `metaname` = 'title' ORDER BY `id` DESC LIMIT 0 , 30
57	1.33 ms	SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 3699 AND `id_language` = 1 AND `metaname` = 'summary' ORDER BY `id` DESC LIMIT 0 , 30
58	1.22 ms	SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 3699 AND `id_language` = 1 AND `metaname` = 'typeHour' ORDER BY `id` DESC LIMIT 0 , 30
59	1.63 ms	SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 3699 AND `id_language` = 1 AND `metaname` = 'currency' ORDER BY `id` DESC LIMIT 0 , 30
60	0.38 ms	SELECT * FROM `seo` WHERE TRUE AND `id_product` = 3699 AND `id_language` = 1 ORDER BY `id` DESC LIMIT 0 , 30
61	0.31 ms	SELECT * FROM `product_photos` WHERE TRUE AND `id_product` = 3699 ORDER BY `id` DESC LIMIT 0 , 30
62	0.55 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` = 3699 ORDER BY s.`id_language` ASC
63	0.57 ms	SELECT * FROM `sub_product` WHERE TRUE AND `id_product` = 3699 AND `type` = 4 ORDER BY `id_language` ASC LIMIT 0 , 30
64	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...
65	0.53 ms	SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 3739 AND `id_language` = 1 AND `metaname` = 'title' ORDER BY `id` DESC LIMIT 0 , 30
66	0.45 ms	SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 3739 AND `id_language` = 1 AND `metaname` = 'summary' ORDER BY `id` DESC LIMIT 0 , 30
67	0.43 ms	SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 3739 AND `id_language` = 1 AND `metaname` = 'typeHour' ORDER BY `id` DESC LIMIT 0 , 30
68	0.53 ms	SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 3739 AND `id_language` = 1 AND `metaname` = 'currency' ORDER BY `id` DESC LIMIT 0 , 30
69	0.53 ms	SELECT * FROM `seo` WHERE TRUE AND `id_product` = 3739 AND `id_language` = 1 ORDER BY `id` DESC LIMIT 0 , 30
70	0.57 ms	SELECT * FROM `product_photos` WHERE TRUE AND `id_product` = 3739 ORDER BY `id` DESC LIMIT 0 , 30
71	0.79 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` = 3739 ORDER BY s.`id_language` ASC
72	0.97 ms	SELECT * FROM `sub_product` WHERE TRUE AND `id_product` = 3739 AND `type` = 4 ORDER BY `id_language` ASC LIMIT 0 , 30
73	1.3 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	1.83 ms	SELECT id_product, metavalue FROM `product_meta` WHERE id_product IN (?,?,?) AND metaname = ? AND id_language = ?
75	1.18 ms	SELECT * FROM `type` WHERE TRUE AND `group` = 'subproduct_blockeddates_block_type' ORDER BY `id` DESC LIMIT 0 , 30
76	0.5 ms	SELECT * FROM `subproduct_blockeddates` WHERE TRUE AND `id_subproduct` = 2348 ORDER BY `date` ASC LIMIT 0 , 30
77	0.83 ms	SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 3692 AND `id_language` = 1 AND `metaname` = 'availability_next_date' ORDER BY `id` DESC LIMIT 0 , 30
78	2109.85 ms	SELECT * FROM `customer_productlog` WHERE TRUE
79	6.75 ms	INSERT INTO `customer_productlog` ( `id` , `content` ) VALUES( NULL , '{\"id_product\":\"3692\",\"id_user\":\"NULL\",\"dateVisited\":1785173415}' )
80	1.75 ms	SELECT * FROM `suppliers` s WHERE TRUE AND s.`id` = 36 ORDER BY `id` DESC
81	0.74 ms	SELECT * FROM `supplier_meta` WHERE TRUE AND `id_supplier` = 36 ORDER BY `id` DESC LIMIT 0 , 1000

Time

Query

2.32 ms

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

7.4 ms

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

0.61 ms

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

0.64 ms

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

284.08 ms

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

0.39 ms

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

0.29 ms

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

0.48 ms

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

0.55 ms

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

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

0.64 ms

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

0.26 ms

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

1.06 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.71 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` = 3692 ORDER BY `rating_overall` desc LIMIT 20 , 30

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

0.93 ms

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

0.68 ms

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

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

0.52 ms

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

1 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.66 ms

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

0.36 ms

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

0.92 ms

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

0.27 ms

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

0.66 ms

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

0.61 ms

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

0.39 ms

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

0.33 ms

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

0.38 ms

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

0.87 ms

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

0.39 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.59 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 ='3692'

0.39 ms

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

0.94 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.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` = 3692 AND cm.`id_language` = 1...

0.39 ms

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

0.83 ms

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

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

1.73 ms

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

0.86 ms

0.31 ms

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

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

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

0.95 ms

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

0.54 ms

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

1.63 ms

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

0.44 ms

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

0.37 ms

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

0.41 ms

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

0.43 ms

0.52 ms

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

0.58 ms

0.76 ms

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

1.33 ms

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

1.22 ms

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

1.63 ms

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

0.38 ms

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

0.31 ms

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

0.55 ms

0.57 ms

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

0.58 ms

0.53 ms

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

0.43 ms

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

0.53 ms

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

0.53 ms

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

0.57 ms

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

0.79 ms

0.97 ms

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

1.3 ms

1.83 ms

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

1.18 ms

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

0.5 ms

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

0.83 ms

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

2109.85 ms

SELECT * FROM `customer_productlog` WHERE TRUE

6.75 ms

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

1.75 ms

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

0.74 ms

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

Dubai Morning Safari: Red Dunes, Sand-Surf, Camel Ride and a Brunch

Dubai Morning Safari: Red Dunes, Sand-Surf, Camel Ride and a Brunch

About This activity

Meeting Point

Reviews

You might also like

Rapid Desert Raid Buggy Tour: 1-Hour

Combo: Dubai Small-Group Tour, Evening Desert Safari and More

Off-Road Motorbike Excursion: 3-Hours