Follow in the footsteps of top world leaders and dignitaries as you explore the grounds of Qasr Al Watan, a marvelous epitome of Emirati artistry and royal heritage. Every detail of this architectural landmark in Abu Dhabi is worth admiring, from its granite-limestone façade to its over 5,000 attention-to-detail geometric patterns and enormous doors crafted in 23-carat French gold. Your Qasr Al Watan tickets offer access to its diverse rooms and elaborate gardens with splendid courtyards, hallways, fountains, etc.
WHAT TO EXPECT
Explore the UAE’s Heritage in Royal Surroundings
Qasr Al Watan is more than just a part of Abu Dhabi’s presidential palace; it is a symbol of the UAE’s inspiring journey. Discover its diverse, enlightening facets in an immersive, modern setting. The vast array of displays and experiences that await on each segment ensure a comprehensive overview of Emirati legacy, government, and unrivaled architectural fineness.
Step into the Themed Sections
Marvel at the Great Hall, boasting the country’s biggest central dome. Discover the Presidential Gifts, featuring the most prized gifts, and see the House of Knowledge with the Power of Words, a calligraphic sculpture depicting the inspiring country’s founder, Sheikh Zayed bin Sultan al Nahyan. You can further appreciate the splendor of the Presidential Banquet area and check out a trove of authentic works on Arabian history and culture at the Qasr Al Watan library.
Admire Lush Gardens and Scenic Surroundings
Beyond working your way across its various sections, enriched by delicate and intricate artworks, absorb the verdant landscape that encompasses the sprawling palace. Take a walk under the elegantly tranquil archways and catch the best views of the palace from its lawn.
ابوظبي، الامارات العربية المتحدة
ابوظبي، الامارات العربية المتحدة
ابوظبي، الامارات العربية المتحدة
ابوظبي، الامارات العربية المتحدة
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 (56.55%) | 385.55ms |
| 1 x Booting (43.38%) | 295.75ms |
| 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` = 'qasr-al-watan-abu-dhabi' and `bravo_events`.`deleted_at` is null limit 118.46ms/modules/Event/Controllers/EventController.php:101u479693165_rouvfbqk_travi| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `bravo_locations` where `bravo_locations`.`id` in (18) and `bravo_locations`.`deleted_at` is null1.21ms/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 (18)460μ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 (117) and `bravo_event_translations`.`deleted_at` is null460μ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 (117)400μs/modules/Event/Controllers/EventController.php:101u479693165_rouvfbqk_travi| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `bravo_events` where `location_id` = 18 and `status` = 'publish' and `id` not in (117) and `bravo_events`.`deleted_at` is null limit 4900μs/modules/Event/Controllers/EventController.php:109u479693165_rouvfbqk_travi| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `bravo_locations` where `bravo_locations`.`id` in (18) and `bravo_locations`.`deleted_at` is null540μ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 (18)2.95ms/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 (99, 105, 106, 107) and `bravo_event_translations`.`deleted_at` is null550μ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 (99, 105, 106, 107)2.71ms/modules/Event/Controllers/EventController.php:109u479693165_rouvfbqk_travi| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select count(*) as aggregate from `bravo_review` where `object_id` = 117 and `object_model` = 'event' and `status` = 'approved' and `bravo_review`.`deleted_at` is null3.55ms/modules/Event/Models/Event.php:726u479693165_rouvfbqk_travi| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `location_category` where `status` = 'publish' and `location_category`.`deleted_at` is null570μ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)1.78ms/modules/Event/Controllers/EventController.php:116u479693165_rouvfbqk_travi| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `bravo_seo` where `object_id` = 117 and `object_model` = 'event_translation_egy' limit 1960μs/app/BaseModel.php:199u479693165_rouvfbqk_travi| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `bravo_locations` where (38 between `bravo_locations`.`_lft` and `bravo_locations`.`_rgt` and `bravo_locations`.`id` <> 18) and `bravo_locations`.`deleted_at` is null470μ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 1590μ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 1320μ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 1460μ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 1290μ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 1350μ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` = 117 and `object_model` = 'event' and `status` = 'approved' and `bravo_review`.`deleted_at` is null limit 11.06ms/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` = 117 and `object_model` = 'event' and `status` = 'approved' and `bravo_review`.`deleted_at` is null limit 1600μs/modules/Event/Models/Event.php:689u479693165_rouvfbqk_travi| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select count(*) as aggregate from `user_wishlist` where `user_wishlist`.`object_id` = 117 and `user_wishlist`.`object_id` is not null and `object_model` = 'event'340μ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` = 117 and `object_model` = 'event' and `status` = 'approved' and `bravo_review`.`deleted_at` is null limit 1740μ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` = 117 and `object_model` = 'event' and `status` = 'approved' and `bravo_review`.`deleted_at` is null limit 1630μ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` = 117 and `object_model` = 'event' and `status` = 'approved' and `bravo_review`.`deleted_at` is null limit 110.51ms/modules/Booking/Models/Bookable.php:357u479693165_rouvfbqk_travi| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `bravo_event_term` where `bravo_event_term`.`target_id` = 117 and `bravo_event_term`.`target_id` is not null370μ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` = 117 and `object_model` = 'event' and `status` = 'approved' and `bravo_review`.`deleted_at` is null limit 1650μ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` = 117 and `object_model` = 'event' and `status` = 'approved' and `bravo_review`.`deleted_at` is null limit 1680μ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 1590μ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 1260μs/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 1220μs/app/Traits/HasTranslations.php:51u479693165_rouvfbqk_travi| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
200
[]
[]
0 of 0array:22 [▼ "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" ] "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.220.137.93" ] "x-forwarded-proto" => array:1 [▶ 0 => "https" ] "x-real-ip" => array:1 [▶ 0 => "18.220.137.93" ] "x-real-port" => array:1 [▶ 0 => "46985" ] "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:60 [▼ "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_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.220.137.93" "HTTP_X_FORWARDED_PROTO" => "https" "HTTP_X_REAL_IP" => "18.220.137.93" "HTTP_X_REAL_PORT" => "46985" "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.220.137.93" "REMOTE_PORT" => "14756" "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/qasr-al-watan-abu-dhabi" "REDIRECT_URL" => "/public/egy/event/qasr-al-watan-abu-dhabi" "REDIRECT_REQUEST_METHOD" => "GET" "PROXY_REMOTE_ADDR" => "2a02:4780:1:25::2" "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/qasr-al-watan-abu-dhabi" "SCRIPT_URL" => "/egy/event/qasr-al-watan-abu-dhabi" "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" => 1744333622.6349 "REQUEST_TIME" => 1744333622 ]
[]
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 => "Fri, 11 Apr 2025 01:07:03 GMT" ] "set-cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6ImNoMjlPREJPSHM0M1pHSkI1RXZGeXc9PSIsInZhbHVlIjoiZ0dTdHZKNjJHQmdpYkhueFRoamIrUVhrbDllK2ZRVjFQVytxNFhXWnpEaTRUbnpyM0ZlY3ArZmZyT2ZFaVJXbklmWjFYVjJhbnh2R21KcTVZWFl6ZEIxZ2k3aWthYWpDMVAxdDluNzhVQUVWaXJobFBSTVJNajZuVlFxSGNGbkMiLCJtYWMiOiIzOGM4MDkxZTU3M2Q1ZmRmMjQ2OGQwMWNiMTg5NzBmZjAxYThiYTMzMmFmMzM3NzhiZWU5OGFjZDIyYjkyNmViIiwidGFnIjoiIn0%3D; expires=Fri, 11-Apr-2025 03:07:03 GMT; Max-Age=7200; path=/; samesite=lax ◀XSRF-TOKEN=eyJpdiI6ImNoMjlPREJPSHM0M1pHSkI1RXZGeXc9PSIsInZhbHVlIjoiZ0dTdHZKNjJHQmdpYkhueFRoamIrUVhrbDllK2ZRVjFQVytxNFhXWnpEaTRUbnpyM0ZlY3ArZmZyT2ZFaVJXbklmWjFYV ▶" 1 => "rouvana_session=eyJpdiI6IlFBZURuS25BUGRyVVRLazZzaEgyTGc9PSIsInZhbHVlIjoiWmtLN3k4VFVueHFrWjlLU0hudE9RQkFLZXlKR1BybUJJZThzcmc2eG45bzJaL3U2S2FYWmZsMHJYZHZXaEF4WWxZUlNPTmtiaHNHUjJaWE5vMmRNRjI0b0dNYVJ5Z3BSVld5ZDgxaFp0ekdGVWxaZUNJalFEYm56VjlRRXc2TmwiLCJtYWMiOiJjODVmOWE0OTJjYjhhZjczMTVmN2M0NzFmNTAyZGZlZDViODRhOWNhZTBmZWJlMTcxODcxNDhlOTg3OWNhNzdmIiwidGFnIjoiIn0%3D; expires=Fri, 11-Apr-2025 03:07:03 GMT; Max-Age=7200; path=/; httponly; samesite=lax ◀rouvana_session=eyJpdiI6IlFBZURuS25BUGRyVVRLazZzaEgyTGc9PSIsInZhbHVlIjoiWmtLN3k4VFVueHFrWjlLU0hudE9RQkFLZXlKR1BybUJJZThzcmc2eG45bzJaL3U2S2FYWmZsMHJYZHZXaEF4WWxZ ▶" ] "Set-Cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6ImNoMjlPREJPSHM0M1pHSkI1RXZGeXc9PSIsInZhbHVlIjoiZ0dTdHZKNjJHQmdpYkhueFRoamIrUVhrbDllK2ZRVjFQVytxNFhXWnpEaTRUbnpyM0ZlY3ArZmZyT2ZFaVJXbklmWjFYVjJhbnh2R21KcTVZWFl6ZEIxZ2k3aWthYWpDMVAxdDluNzhVQUVWaXJobFBSTVJNajZuVlFxSGNGbkMiLCJtYWMiOiIzOGM4MDkxZTU3M2Q1ZmRmMjQ2OGQwMWNiMTg5NzBmZjAxYThiYTMzMmFmMzM3NzhiZWU5OGFjZDIyYjkyNmViIiwidGFnIjoiIn0%3D; expires=Fri, 11-Apr-2025 03:07:03 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6ImNoMjlPREJPSHM0M1pHSkI1RXZGeXc9PSIsInZhbHVlIjoiZ0dTdHZKNjJHQmdpYkhueFRoamIrUVhrbDllK2ZRVjFQVytxNFhXWnpEaTRUbnpyM0ZlY3ArZmZyT2ZFaVJXbklmWjFYV ▶" 1 => "rouvana_session=eyJpdiI6IlFBZURuS25BUGRyVVRLazZzaEgyTGc9PSIsInZhbHVlIjoiWmtLN3k4VFVueHFrWjlLU0hudE9RQkFLZXlKR1BybUJJZThzcmc2eG45bzJaL3U2S2FYWmZsMHJYZHZXaEF4WWxZUlNPTmtiaHNHUjJaWE5vMmRNRjI0b0dNYVJ5Z3BSVld5ZDgxaFp0ekdGVWxaZUNJalFEYm56VjlRRXc2TmwiLCJtYWMiOiJjODVmOWE0OTJjYjhhZjczMTVmN2M0NzFmNTAyZGZlZDViODRhOWNhZTBmZWJlMTcxODcxNDhlOTg3OWNhNzdmIiwidGFnIjoiIn0%3D; expires=Fri, 11-Apr-2025 03:07:03 GMT; path=/; httponly ◀rouvana_session=eyJpdiI6IlFBZURuS25BUGRyVVRLazZzaEgyTGc9PSIsInZhbHVlIjoiWmtLN3k4VFVueHFrWjlLU0hudE9RQkFLZXlKR1BybUJJZThzcmc2eG45bzJaL3U2S2FYWmZsMHJYZHZXaEF4WWxZ ▶" ] ]
0 of 0array:4 [▼ "_token" => "WK1IFHhvT0cq2CKnn30ZlcWo7JvjJX3SBmEGtSx5" "_previous" => array:1 [▶ "url" => "https://rouvana.com/egy/event/qasr-al-watan-abu-dhabi" ] "_flash" => array:2 [▶ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]