Abu Dhabi City Tour Overview
Get to know the UAE’s capital city and its fantastic historical, cultural and thrilling sights with our Abu Dhabi city tour. With transfers arranged to and from Dubai, it allows you to discover Abu Dhabi’s diverse shades and persona.
On an Abu Dhabi city tour with Rayna Tours, know how the capital city of the United Arab Emirates incredibly merges its rich ancient heritage with the most modern contemporary life. We’ve crafted this tour package with cautiously picked highlights of Abu Dhabi in order to ensure that you don’t miss out to take in its significant sights. So be prepared to behold some of the most majestic landmarks of the UAE, as we pick you up from your hotel or preferred location in Dubai for a two-hour drive to Abu Dhabi.
One sight that would for sure command your attention en-route to Abu Dhabi city centre is the astounding and expansive white structure - Sheik Zayed Grand Mosque that has been named to honor the late president, His Highness Sheikh Zayed bin Sultan Al Nahyan.
Abu Dhabi City Tour Highlights
· This tour is the number one choice for those looking to visit Abu Dhabi from Dubai.
· You don’t have to worry about the sights covered in your itinerary or how much time you’ll spend in a place. Every aspect of your tour is immaculately planned!
· The tour comes with transportation means you just have to sit back and take in the sights.
· You’ll visit the imposing Sheik Zayed Mosque, traditional Date Market, quaint Heritage Village, vibrant Corniche area, and the action-packed Yas Island, among others.
· There will be photo stops of the Emirates Palace Hotel, Ferrari World Abu Dhabi etc.
· Flexibility to choose Abu Dhabi City Tour with or without lunch.
Abu Dhabi City Tour Inclusions
· Transfer to Tour Departure Point from your hotel.
· Abu Dhabi City Tour as per the option selected while booking.
Kindly note that the lunch break stopover will be at Marina Mall (Guests are requested to bear the cost of lunch on their own)
Abu Dhabi City Tour Exclusions
· All personal expenses spend for shopping, drinks and dining etc. on-site during the tour.
Abu Dhabi City Tour How to Redeem
· Guests are requested to carry a soft copy of the voucher on the phone. It needs to be verified by the driver at the time of pick-up time.
Abu Dhabi City Tour Important Information
· Transfers are only provided from centrally located hotels and residences in Dubai city. (Deira, Bur Dubai, Sheikh Zayed, Marina and other nearby locations)
· For private transfers, pick-up from Areas other than centrally located Dubai Hotels / Residence will be done on request with an additional surcharge.
· Transfer timings may vary by 30 to 60 minutes, depending on traffic conditions and your location.
· All personal expenses spent for lunch, shopping, drinks, dining etc. on-site during the tour will be borne by the guest.
· Eating, drinking, and smoking in public spaces during daylight hours are restricted during Ramadan period.
· Avoid taking pictures of people without their permission, especially in more conservative areas.
· Note: In sharing transfers, The pickup and drop off timings may vary by 15-20 minutes.
دبى - الامارات العربية المتحدة
دبى - الامارات العربية المتحدة
دبى - الامارات العربية المتحدة
Dear Valued Visitor,
We are currently performing maintenance to enhance your experience on our website. During this time, online bookings may be temporarily unavailable.
However, we’re still here to assist you! You can book with us offline by WhatsApping us at +971 56 524 0107 or emailing us at info@rouvana.com.
We apologize for any inconvenience this may cause and appreciate your understanding. Thank you for your patience, and we look forward to serving you better soon!
Warm regards,
Rouvana Tours
| 1 x Application (89.17%) | 333.23ms |
| 1 x Booting (10.82%) | 40.43ms |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| 12 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| 12 | |
| 13 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| 12 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| 12 | |
| 13 | |
| 14 | |
| 15 | |
| 16 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| 12 | |
| 13 | |
| 14 | |
| 15 | |
| 16 | |
| 17 | |
| 18 | |
| 19 | |
| 20 | |
| 21 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| 12 | |
| 13 | |
| 14 | |
| 15 | |
| 16 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| 12 | |
| 13 | |
| 14 | |
| 15 | |
| 16 | |
| 17 | |
| 18 | |
| 19 | |
| 20 | |
| 21 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| 12 | |
| 13 | |
| 14 | |
| 15 | |
| 16 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| 12 | |
| 13 | |
| 14 | |
| 15 | |
| 16 | |
| 17 | |
| 18 | |
| 19 | |
| 20 | |
| 21 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| 12 | |
| 13 | |
| 14 | |
| 15 | |
| 16 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| 12 | |
| 13 | |
| 14 | |
| 15 | |
| 16 | |
| 17 | |
| 18 | |
| 19 | |
| 20 | |
| 21 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| 12 | |
| 13 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| 12 | |
| 13 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| 12 | |
| 13 | |
| 14 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| 12 | |
| 13 | |
| 14 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| 12 | |
| 13 | |
| 14 | |
| 15 | |
| 16 | |
| 17 | |
| 18 | |
| 19 | |
| 20 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| 12 | |
| 13 | |
| 14 | |
| 15 | |
| 16 | |
| 17 | |
| 18 | |
| 19 | |
| 20 | |
| 21 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| 12 | |
| 13 | |
| 14 | |
| 15 | |
| 16 | |
| 17 | |
| 18 | |
| 19 | |
| 20 | |
| 21 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| 12 | |
| 13 | |
| 14 | |
| 15 | |
| 16 | |
| 17 | |
| 18 | |
| 19 | |
| 20 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| 12 | |
| 13 | |
| 14 | |
| 15 | |
| 16 | |
| 17 | |
| 18 | |
| 19 | |
| 20 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| 12 | |
| 13 | |
| 14 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| 12 | |
| 13 | |
| 14 | |
| 15 | |
| 16 | |
| 17 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| 12 | |
| 13 | |
| 14 | |
| 15 | |
| 16 | |
| 17 | |
| 18 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| 12 | |
| 13 | |
| 14 | |
| 15 | |
| 16 | |
| 17 | |
| 18 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| 12 | |
| 13 | |
| 14 | |
| 15 | |
| 16 | |
| 17 | |
| 18 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| 12 | |
| 13 | |
| 14 | |
| 15 | |
| 16 | |
| 17 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| 12 | |
| 13 | |
| 14 | |
| 15 | |
| 16 | |
| 17 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| 12 | |
| 13 | |
| 14 | |
| 15 | |
| 16 | |
| 17 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| 12 | |
| 13 | |
| 14 | |
| 15 | |
| 16 | |
| 17 | |
select * from `bravo_events` where `slug` = 'abu-dhabi-city-tour' and `bravo_events`.`deleted_at` is null limit 13.23ms/modules/Event/Controllers/EventController.php:101u479693165_rouvfbqk_travi| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `bravo_locations` where `bravo_locations`.`id` in (15) and `bravo_locations`.`deleted_at` is null290μs/modules/Event/Controllers/EventController.php:101u479693165_rouvfbqk_travi| Metadata | |
|---|---|
| Hints |
|
| Backtrace |
|
select * from `bravo_location_translations` where `locale` = 'egy' and `bravo_location_translations`.`origin_id` in (15)520μs/modules/Event/Controllers/EventController.php:101u479693165_rouvfbqk_travi| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `bravo_event_translations` where `locale` = 'egy' and `bravo_event_translations`.`origin_id` in (133) and `bravo_event_translations`.`deleted_at` is null820μs/modules/Event/Controllers/EventController.php:101u479693165_rouvfbqk_travi| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `user_wishlist` where `object_model` = 'event' and `user_id` = 0 and `user_wishlist`.`object_id` in (133)450μs/modules/Event/Controllers/EventController.php:101u479693165_rouvfbqk_travi| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `bravo_events` where `location_id` = 15 and `status` = 'publish' and `id` not in (133) and `bravo_events`.`deleted_at` is null limit 41.08ms/modules/Event/Controllers/EventController.php:109u479693165_rouvfbqk_travi| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `bravo_locations` where `bravo_locations`.`id` in (15) and `bravo_locations`.`deleted_at` is null450μs/modules/Event/Controllers/EventController.php:109u479693165_rouvfbqk_travi| Metadata | |
|---|---|
| Hints |
|
| Backtrace |
|
select * from `bravo_location_translations` where `locale` = 'egy' and `bravo_location_translations`.`origin_id` in (15)330μs/modules/Event/Controllers/EventController.php:109u479693165_rouvfbqk_travi| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `bravo_event_translations` where `locale` = 'egy' and `bravo_event_translations`.`origin_id` in (97, 98, 100, 101) and `bravo_event_translations`.`deleted_at` is null500μs/modules/Event/Controllers/EventController.php:109u479693165_rouvfbqk_travi| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `user_wishlist` where `object_model` = 'event' and `user_id` = 0 and `user_wishlist`.`object_id` in (97, 98, 100, 101)290μs/modules/Event/Controllers/EventController.php:109u479693165_rouvfbqk_travi| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select count(*) as aggregate from `bravo_review` where `object_id` = 133 and `object_model` = 'event' and `status` = 'approved' and `bravo_review`.`deleted_at` is null1.11ms/modules/Event/Models/Event.php:726u479693165_rouvfbqk_travi| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `location_category` where `status` = 'publish' and `location_category`.`deleted_at` is null410μs/modules/Event/Controllers/EventController.php:116u479693165_rouvfbqk_travi| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `location_category_translations` where `locale` = 'egy' and `location_category_translations`.`origin_id` in (1, 2, 3)510μs/modules/Event/Controllers/EventController.php:116u479693165_rouvfbqk_travi| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `bravo_seo` where `object_id` = 133 and `object_model` = 'event_translation_egy' limit 1900μs/app/BaseModel.php:199u479693165_rouvfbqk_travi| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `bravo_locations` where (30 between `bravo_locations`.`_lft` and `bravo_locations`.`_rgt` and `bravo_locations`.`id` <> 15) and `bravo_locations`.`deleted_at` is null520μs/vendor/kalnoy/nestedset/src/QueryBuilder.php:159u479693165_rouvfbqk_travi| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `media_files` where `media_files`.`id` = '' and `media_files`.`deleted_at` is null limit 1410μs/app/BaseModel.php:135u479693165_rouvfbqk_travi| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `media_files` where `media_files`.`id` = '' and `media_files`.`deleted_at` is null limit 1280μs/app/BaseModel.php:135u479693165_rouvfbqk_travi| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `media_files` where `media_files`.`id` = '' and `media_files`.`deleted_at` is null limit 1230μs/app/BaseModel.php:135u479693165_rouvfbqk_travi| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `media_files` where `media_files`.`id` = '' and `media_files`.`deleted_at` is null limit 1310μs/app/BaseModel.php:135u479693165_rouvfbqk_travi| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `media_files` where `media_files`.`id` = '' and `media_files`.`deleted_at` is null limit 1210μs/app/BaseModel.php:135u479693165_rouvfbqk_travi| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `media_files` where `media_files`.`id` = '' and `media_files`.`deleted_at` is null limit 1210μs/app/BaseModel.php:135u479693165_rouvfbqk_travi| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select AVG(rate_number) as score_total , COUNT(id) as total_review from `bravo_review` where `object_id` = 133 and `object_model` = 'event' and `status` = 'approved' and `bravo_review`.`deleted_at` is null limit 11.18ms/modules/Event/Models/Event.php:677u479693165_rouvfbqk_travi| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select COUNT( CASE WHEN rate_number = 5 THEN rate_number ELSE NULL END ) AS rate_5,
COUNT( CASE WHEN rate_number = 4 THEN rate_number ELSE NULL END ) AS rate_4,
COUNT( CASE WHEN rate_number = 3 THEN rate_number ELSE NULL END ) AS rate_3,
COUNT( CASE WHEN rate_number = 2 THEN rate_number ELSE NULL END ) AS rate_2,
COUNT( CASE WHEN rate_number = 1 THEN rate_number ELSE NULL END ) AS rate_1 from `bravo_review` where `object_id` = 133 and `object_model` = 'event' and `status` = 'approved' and `bravo_review`.`deleted_at` is null limit 11.41ms/modules/Event/Models/Event.php:689u479693165_rouvfbqk_travi| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select count(*) as aggregate from `user_wishlist` where `user_wishlist`.`object_id` = 133 and `user_wishlist`.`object_id` is not null and `object_model` = 'event'850μs/modules/Event/Models/Event.php:1037u479693165_rouvfbqk_travi| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select AVG(rate_number) as score_total , COUNT(id) as total_review from `bravo_review` where `object_id` = 133 and `object_model` = 'event' and `status` = 'approved' and `bravo_review`.`deleted_at` is null limit 11.29ms/modules/Event/Models/Event.php:677u479693165_rouvfbqk_travi| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select COUNT( CASE WHEN rate_number = 5 THEN rate_number ELSE NULL END ) AS rate_5,
COUNT( CASE WHEN rate_number = 4 THEN rate_number ELSE NULL END ) AS rate_4,
COUNT( CASE WHEN rate_number = 3 THEN rate_number ELSE NULL END ) AS rate_3,
COUNT( CASE WHEN rate_number = 2 THEN rate_number ELSE NULL END ) AS rate_2,
COUNT( CASE WHEN rate_number = 1 THEN rate_number ELSE NULL END ) AS rate_1 from `bravo_review` where `object_id` = 133 and `object_model` = 'event' and `status` = 'approved' and `bravo_review`.`deleted_at` is null limit 1970μs/modules/Event/Models/Event.php:689u479693165_rouvfbqk_travi| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select COUNT( id ) AS total_review, COUNT( CASE WHEN rate_number >= 4 THEN 1 ELSE null END ) as total_review_recommend from `bravo_review` where `object_id` = 133 and `object_model` = 'event' and `status` = 'approved' and `bravo_review`.`deleted_at` is null limit 11.16ms/modules/Booking/Models/Bookable.php:357u479693165_rouvfbqk_travi| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `bravo_event_term` where `bravo_event_term`.`target_id` = 133 and `bravo_event_term`.`target_id` is not null520μsview::bd460402903718cbc3260af005784b6e9889c686:2u479693165_rouvfbqk_travi| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select AVG(rate_number) as score_total , COUNT(id) as total_review from `bravo_review` where `object_id` = 133 and `object_model` = 'event' and `status` = 'approved' and `bravo_review`.`deleted_at` is null limit 1660μs/modules/Event/Models/Event.php:677u479693165_rouvfbqk_travi| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select COUNT( CASE WHEN rate_number = 5 THEN rate_number ELSE NULL END ) AS rate_5,
COUNT( CASE WHEN rate_number = 4 THEN rate_number ELSE NULL END ) AS rate_4,
COUNT( CASE WHEN rate_number = 3 THEN rate_number ELSE NULL END ) AS rate_3,
COUNT( CASE WHEN rate_number = 2 THEN rate_number ELSE NULL END ) AS rate_2,
COUNT( CASE WHEN rate_number = 1 THEN rate_number ELSE NULL END ) AS rate_1 from `bravo_review` where `object_id` = 133 and `object_model` = 'event' and `status` = 'approved' and `bravo_review`.`deleted_at` is null limit 1640μs/modules/Event/Models/Event.php:689u479693165_rouvfbqk_travi| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `core_menu_translations` where `core_menu_translations`.`origin_id` = 2 and `core_menu_translations`.`origin_id` is not null and `locale` = 'egy' limit 1520μs/app/Traits/HasTranslations.php:51u479693165_rouvfbqk_travi| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `core_pages` where `core_pages`.`id` = '20' and `core_pages`.`deleted_at` is null limit 11.02ms/app/Helpers/AppHelper.php:627u479693165_rouvfbqk_travi| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `bravo_popup_translations` where `bravo_popup_translations`.`origin_id` = 1 and `bravo_popup_translations`.`origin_id` is not null and `locale` = 'egy' limit 1330μs/app/Traits/HasTranslations.php:51u479693165_rouvfbqk_travi| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
200
[]
[]
0 of 0array:23 [▼ "accept" => array:1 [▶ 0 => "text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7" ] "accept-encoding" => array:1 [▶ 0 => "br" ] "cookie" => array:1 [▶ 0 => "XSRF-TOKEN=eyJpdiI6IlVvSkNjQlAvRWg0OHFyczZEL2NuTHc9PSIsInZhbHVlIjoiSy90KzlMWUthUk1MU1ZYbXFLQ1JRUWFBS1J0RG5jRGovNlUreWxCREJQWEFiMmxNS1c0QStNTFk4SjllOWo3WXJUUnJmeDZZZEpvS2R4QzcxdUpxZ05LNExFdE9vaElFeFhNMGpNbTlobkV6YTViUUpVaEg0RzdrZnBheHlIZloiLCJtYWMiOiI5MjZhOGQ4NzE2ODIzOTYyZGIyNjQ2NGRkYjdlMTY3Y2Q4MTY4OWU5MjU5NjcwZWM1ZjkzMmNmYzljNmEyNjBkIiwidGFnIjoiIn0%3D; rouvana_session=eyJpdiI6IjRUYm9KeDgzbXZ0bVZXbEwzYnV3Y1E9PSIsInZhbHVlIjoiRDdIeEtiNHpIZnZxUkpZa1VmRlU5M0tRcEMyV0RtRnR4a2VmaHVQUzNEZVFmazdXdVFJbTZNV1NteVU0UXZDWjBDZVlBRWx4NFJOZTNJT0JibnNvbG5Ldkt4WER3MjFMS2JNRHNGWHQ2WUV1OEthWDhVT0ZFWisvY01icmFIbzkiLCJtYWMiOiJkNGM0YmYyMzBkYTRiYzkyMzYyY2I2YTRjMjJhMmViZjRjYTc0ODhkNGFhOTFkNzU4NjBkODZjYWRjOGQ1YTIyIiwidGFnIjoiIn0%3D ◀XSRF-TOKEN=eyJpdiI6IlVvSkNjQlAvRWg0OHFyczZEL2NuTHc9PSIsInZhbHVlIjoiSy90KzlMWUthUk1MU1ZYbXFLQ1JRUWFBS1J0RG5jRGovNlUreWxCREJQWEFiMmxNS1c0QStNTFk4SjllOWo3WXJUUnJme ▶" ] "host" => array:1 [▶ 0 => "rouvana.com" ] "pragma" => array:1 [▶ 0 => "no-cache" ] "user-agent" => array:1 [▶ 0 => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)" ] "cache-control" => array:1 [▶ 0 => "no-cache" ] "x-forwarded-for" => array:1 [▶ 0 => "18.222.240.84" ] "x-forwarded-proto" => array:1 [▶ 0 => "https" ] "x-real-ip" => array:1 [▶ 0 => "18.222.240.84" ] "x-real-port" => array:1 [▶ 0 => "16513" ] "x-forwarded-port" => array:1 [▶ 0 => "443" ] "x-port" => array:1 [▶ 0 => "443" ] "x-lscache" => array:1 [▶ 0 => "1" ] "sec-ch-ua" => array:1 [▶ 0 => ""HeadlessChrome";v="129", "Not=A?Brand";v="8", "Chromium";v="129"" ] "sec-ch-ua-mobile" => array:1 [▶ 0 => "?0" ] "sec-ch-ua-platform" => array:1 [▶ 0 => ""Windows"" ] "upgrade-insecure-requests" => array:1 [▶ 0 => "1" ] "sec-fetch-site" => array:1 [▶ 0 => "none" ] "sec-fetch-mode" => array:1 [▶ 0 => "navigate" ] "sec-fetch-user" => array:1 [▶ 0 => "?1" ] "sec-fetch-dest" => array:1 [▶ 0 => "document" ] "priority" => array:1 [▶ 0 => "u=0, i" ] ]
0 of 0array:61 [▼ "LSPHP_ProcessGroup" => "on" "PATH" => "/usr/local/bin:/bin:/usr/bin" "HTTP_ACCEPT" => "text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7" "HTTP_ACCEPT_ENCODING" => "br" "HTTP_COOKIE" => "XSRF-TOKEN=eyJpdiI6IlVvSkNjQlAvRWg0OHFyczZEL2NuTHc9PSIsInZhbHVlIjoiSy90KzlMWUthUk1MU1ZYbXFLQ1JRUWFBS1J0RG5jRGovNlUreWxCREJQWEFiMmxNS1c0QStNTFk4SjllOWo3WXJUUnJmeDZZZEpvS2R4QzcxdUpxZ05LNExFdE9vaElFeFhNMGpNbTlobkV6YTViUUpVaEg0RzdrZnBheHlIZloiLCJtYWMiOiI5MjZhOGQ4NzE2ODIzOTYyZGIyNjQ2NGRkYjdlMTY3Y2Q4MTY4OWU5MjU5NjcwZWM1ZjkzMmNmYzljNmEyNjBkIiwidGFnIjoiIn0%3D; rouvana_session=eyJpdiI6IjRUYm9KeDgzbXZ0bVZXbEwzYnV3Y1E9PSIsInZhbHVlIjoiRDdIeEtiNHpIZnZxUkpZa1VmRlU5M0tRcEMyV0RtRnR4a2VmaHVQUzNEZVFmazdXdVFJbTZNV1NteVU0UXZDWjBDZVlBRWx4NFJOZTNJT0JibnNvbG5Ldkt4WER3MjFMS2JNRHNGWHQ2WUV1OEthWDhVT0ZFWisvY01icmFIbzkiLCJtYWMiOiJkNGM0YmYyMzBkYTRiYzkyMzYyY2I2YTRjMjJhMmViZjRjYTc0ODhkNGFhOTFkNzU4NjBkODZjYWRjOGQ1YTIyIiwidGFnIjoiIn0%3D ◀XSRF-TOKEN=eyJpdiI6IlVvSkNjQlAvRWg0OHFyczZEL2NuTHc9PSIsInZhbHVlIjoiSy90KzlMWUthUk1MU1ZYbXFLQ1JRUWFBS1J0RG5jRGovNlUreWxCREJQWEFiMmxNS1c0QStNTFk4SjllOWo3WXJUUnJme ▶" "HTTP_HOST" => "rouvana.com" "HTTP_PRAGMA" => "no-cache" "HTTP_USER_AGENT" => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)" "HTTP_CACHE_CONTROL" => "no-cache" "HTTP_X_FORWARDED_FOR" => "18.222.240.84" "HTTP_X_FORWARDED_PROTO" => "https" "HTTP_X_REAL_IP" => "18.222.240.84" "HTTP_X_REAL_PORT" => "16513" "HTTP_X_FORWARDED_PORT" => "443" "HTTP_X_PORT" => "443" "HTTP_X_LSCACHE" => "1" "HTTP_SEC_CH_UA" => ""HeadlessChrome";v="129", "Not=A?Brand";v="8", "Chromium";v="129"" "HTTP_SEC_CH_UA_MOBILE" => "?0" "HTTP_SEC_CH_UA_PLATFORM" => ""Windows"" "HTTP_UPGRADE_INSECURE_REQUESTS" => "1" "HTTP_SEC_FETCH_SITE" => "none" "HTTP_SEC_FETCH_MODE" => "navigate" "HTTP_SEC_FETCH_USER" => "?1" "HTTP_SEC_FETCH_DEST" => "document" "HTTP_PRIORITY" => "u=0, i" "DOCUMENT_ROOT" => "/home/u479693165/domains/rouvana.com/public_html" "REMOTE_ADDR" => "18.222.240.84" "REMOTE_PORT" => "39810" "SERVER_ADDR" => "2a02:4780:11:1654:0:1c97:896d:3" "SERVER_NAME" => "rouvana.com" "SERVER_ADMIN" => "" "SERVER_PORT" => "443" "REQUEST_SCHEME" => "https" "REQUEST_URI" => "/egy/event/abu-dhabi-city-tour" "REDIRECT_URL" => "/public/egy/event/abu-dhabi-city-tour" "REDIRECT_REQUEST_METHOD" => "GET" "PROXY_REMOTE_ADDR" => "2a02:4780:2c:d::3" "HTTPS" => "on" "CRAWLER_USLEEP" => "1000" "CRAWLER_LOAD_LIMIT_ENFORCE" => "25" "H_PLATFORM" => "Hostinger" "H_TYPE" => "shared" "H_CANARY" => "false" "H_STAGING" => "false" "REDIRECT_STATUS" => "200" "SSL_PROTOCOL" => "TLSv1.3" "SSL_CIPHER" => "TLS_AES_256_GCM_SHA384" "SSL_CIPHER_USEKEYSIZE" => "256" "SSL_CIPHER_ALGKEYSIZE" => "256" "SCRIPT_FILENAME" => "/home/u479693165/domains/rouvana.com/public_html/public/index.php" "QUERY_STRING" => "" "SCRIPT_URI" => "https://rouvana.com/egy/event/abu-dhabi-city-tour" "SCRIPT_URL" => "/egy/event/abu-dhabi-city-tour" "SCRIPT_NAME" => "/public/index.php" "SERVER_PROTOCOL" => "HTTP/1.1" "SERVER_SOFTWARE" => "LiteSpeed" "REQUEST_METHOD" => "GET" "X-LSCACHE" => "on,crawler,esi,combine" "PHP_SELF" => "/public/index.php" "REQUEST_TIME_FLOAT" => 1744428998.0225 "REQUEST_TIME" => 1744428998 ]
0 of 0array:2 [▼ "XSRF-TOKEN" => "LC206pJxMQkP0n1PmgEBToOoXFIF1jOgxKd7lz0L" "rouvana_session" => "i6qX8jEJfK0IHx9JDVYJTvpLtFuAwQejTXmgyDWR" ]
0 of 0array:5 [▼ "content-type" => array:1 [▶ 0 => "text/html; charset=UTF-8" ] "cache-control" => array:1 [▶ 0 => "no-cache, private" ] "date" => array:1 [▶ 0 => "Sat, 12 Apr 2025 03:36:38 GMT" ] "set-cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6Img5a2ErWVNVa25udHJQbGNtRlIvd2c9PSIsInZhbHVlIjoiWlVjcFl2Yk1meVlWQVNJUUFQdlR1WDAwZ2VlWmQxSHBteExJblJIazlrek1tTnRQUkNWQnBsNmt0QVI1MnFueEdyWDBhaDRzRmVUYjkyRFJuam1nMitlMUtTQVFiZmZhaUxhbGMxTTgvRFFzN2hIVXlvNGh5aUJtVTBnNlRTUVAiLCJtYWMiOiIxMjM1OGEzMzhiMWFmMjk0MDBkMWRlNDNiY2Y2NmFhYTYzM2JjOWE5NTNmMGE5MWRiZTAxMjRhNjQwNzNkOWZhIiwidGFnIjoiIn0%3D; expires=Sat, 12-Apr-2025 05:36:38 GMT; Max-Age=7200; path=/; samesite=lax ◀XSRF-TOKEN=eyJpdiI6Img5a2ErWVNVa25udHJQbGNtRlIvd2c9PSIsInZhbHVlIjoiWlVjcFl2Yk1meVlWQVNJUUFQdlR1WDAwZ2VlWmQxSHBteExJblJIazlrek1tTnRQUkNWQnBsNmt0QVI1MnFueEdyWDBha ▶" 1 => "rouvana_session=eyJpdiI6IjVLZVpjeGhheFVTMUFGcFBhQXJIMmc9PSIsInZhbHVlIjoiMS9CU2RBS2JYbnQ1TnU5b0pDbGtqNThDa3RnT3M4RjJQbEg1K2kyZTlBZXpES2F6T3Z6K0EyQUhNcFFVNDNVNHlXWXhuaXo5UVZyMGN4aDUxVWExcm4vM0tNd3pZZFY4aTc5aEtlVW5JRGNWZ2F5aXlJZEE1QURSazdMNTZUVVIiLCJtYWMiOiI4ZTYzODMwMjM4ZDBjMzliM2QyMDRlYzk0YzRlN2Y5ZjgwNWRmZTM1ZTU3MDExMWQ1ZGRkNzQ2MGI2MjQzZGQxIiwidGFnIjoiIn0%3D; expires=Sat, 12-Apr-2025 05:36:38 GMT; Max-Age=7200; path=/; httponly; samesite=lax ◀rouvana_session=eyJpdiI6IjVLZVpjeGhheFVTMUFGcFBhQXJIMmc9PSIsInZhbHVlIjoiMS9CU2RBS2JYbnQ1TnU5b0pDbGtqNThDa3RnT3M4RjJQbEg1K2kyZTlBZXpES2F6T3Z6K0EyQUhNcFFVNDNVNHlX ▶" ] "Set-Cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6Img5a2ErWVNVa25udHJQbGNtRlIvd2c9PSIsInZhbHVlIjoiWlVjcFl2Yk1meVlWQVNJUUFQdlR1WDAwZ2VlWmQxSHBteExJblJIazlrek1tTnRQUkNWQnBsNmt0QVI1MnFueEdyWDBhaDRzRmVUYjkyRFJuam1nMitlMUtTQVFiZmZhaUxhbGMxTTgvRFFzN2hIVXlvNGh5aUJtVTBnNlRTUVAiLCJtYWMiOiIxMjM1OGEzMzhiMWFmMjk0MDBkMWRlNDNiY2Y2NmFhYTYzM2JjOWE5NTNmMGE5MWRiZTAxMjRhNjQwNzNkOWZhIiwidGFnIjoiIn0%3D; expires=Sat, 12-Apr-2025 05:36:38 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6Img5a2ErWVNVa25udHJQbGNtRlIvd2c9PSIsInZhbHVlIjoiWlVjcFl2Yk1meVlWQVNJUUFQdlR1WDAwZ2VlWmQxSHBteExJblJIazlrek1tTnRQUkNWQnBsNmt0QVI1MnFueEdyWDBha ▶" 1 => "rouvana_session=eyJpdiI6IjVLZVpjeGhheFVTMUFGcFBhQXJIMmc9PSIsInZhbHVlIjoiMS9CU2RBS2JYbnQ1TnU5b0pDbGtqNThDa3RnT3M4RjJQbEg1K2kyZTlBZXpES2F6T3Z6K0EyQUhNcFFVNDNVNHlXWXhuaXo5UVZyMGN4aDUxVWExcm4vM0tNd3pZZFY4aTc5aEtlVW5JRGNWZ2F5aXlJZEE1QURSazdMNTZUVVIiLCJtYWMiOiI4ZTYzODMwMjM4ZDBjMzliM2QyMDRlYzk0YzRlN2Y5ZjgwNWRmZTM1ZTU3MDExMWQ1ZGRkNzQ2MGI2MjQzZGQxIiwidGFnIjoiIn0%3D; expires=Sat, 12-Apr-2025 05:36:38 GMT; path=/; httponly ◀rouvana_session=eyJpdiI6IjVLZVpjeGhheFVTMUFGcFBhQXJIMmc9PSIsInZhbHVlIjoiMS9CU2RBS2JYbnQ1TnU5b0pDbGtqNThDa3RnT3M4RjJQbEg1K2kyZTlBZXpES2F6T3Z6K0EyQUhNcFFVNDNVNHlX ▶" ] ]
0 of 0array:4 [▼ "_token" => "LC206pJxMQkP0n1PmgEBToOoXFIF1jOgxKd7lz0L" "_previous" => array:1 [▶ "url" => "https://rouvana.com/egy/event/abu-dhabi-city-tour" ] "_flash" => array:2 [▶ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]