Modern, comfortable and ideally located, our Riqqa hotel is midway between the atmospheric souks of Al Ras – the heart of old Deira, Dubai, and the international airport. Just to the south lie the malls of Al Riqqa Road and the glistening waters of Dubai Creek beyond. It couldn’t be more convenient for exploring at leisure, or as a base for business. 84 smart and spacious rooms and suites offer everything you need, including a deeply comfortable bed and a host of entertainment options on the flat screen LCD TV.
After a day’s exploring, you’ll appreciate a cooling dip in the rooftop swimming pool – or perhaps just a refreshing poolside drink. There’s a soothing health club and sauna here, too – a calming oasis in the heart of the city. Dining meanwhile is an all-day affair with everything from authentic Arabic specialities to à la carte international favourites.
Brilliantly located, with exceptional facilities and exemplary service, it’s the very definition of affordable luxury in Dubai.
Superbly equipped with comfortable beds, cool marble floors and complimentary Wi-Fi, and an array of extras in the suites - these are spaces you’ll love to come back to after a day’s exploring.
The Landmark Riqqa hotel, is a manifestation of comfort, exclusivity and finesse all united together. We ensure that nothing stands in between our guests and best services:
Dubai - United Arab Emiratis
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 (71.79%) | 171.92ms |
| 1 x Booting (28.16%) | 67.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 | |
| 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 | |
| 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 | |
| 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 | |
| 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 | |
| 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 | |
| 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 | |
| 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_hotels` where `slug` = 'landmark-hotel-riqqa-deira-dubai' and `bravo_hotels`.`deleted_at` is null limit 12.75ms/modules/Hotel/Controllers/HotelController.php:101u479693165_rouvfbqk_travi| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `bravo_locations` where `bravo_locations`.`id` in (15) and `bravo_locations`.`deleted_at` is null270μs/modules/Hotel/Controllers/HotelController.php:101u479693165_rouvfbqk_travi| Metadata | |
|---|---|
| Hints |
|
| Backtrace |
|
select * from `bravo_location_translations` where `locale` = 'en' and `bravo_location_translations`.`origin_id` in (15)300μs/modules/Hotel/Controllers/HotelController.php:101u479693165_rouvfbqk_travi| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `bravo_hotel_translations` where `locale` = 'en' and `bravo_hotel_translations`.`origin_id` in (392) and `bravo_hotel_translations`.`deleted_at` is null350μs/modules/Hotel/Controllers/HotelController.php:101u479693165_rouvfbqk_travi| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `user_wishlist` where `object_model` = 'hotel' and `user_id` = 0 and `user_wishlist`.`object_id` in (392)220μs/modules/Hotel/Controllers/HotelController.php:101u479693165_rouvfbqk_travi| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `bravo_hotels` where `location_id` = 15 and `status` = 'publish' and `id` not in (392) and `bravo_hotels`.`deleted_at` is null limit 4350μs/modules/Hotel/Controllers/HotelController.php:109u479693165_rouvfbqk_travi| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `bravo_locations` where `bravo_locations`.`id` in (15) and `bravo_locations`.`deleted_at` is null200μs/modules/Hotel/Controllers/HotelController.php:109u479693165_rouvfbqk_travi| Metadata | |
|---|---|
| Hints |
|
| Backtrace |
|
select * from `bravo_location_translations` where `locale` = 'en' and `bravo_location_translations`.`origin_id` in (15)170μs/modules/Hotel/Controllers/HotelController.php:109u479693165_rouvfbqk_travi| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `bravo_hotel_translations` where `locale` = 'en' and `bravo_hotel_translations`.`origin_id` in (390, 391, 393, 394) and `bravo_hotel_translations`.`deleted_at` is null370μs/modules/Hotel/Controllers/HotelController.php:109u479693165_rouvfbqk_travi| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `user_wishlist` where `object_model` = 'hotel' and `user_id` = 0 and `user_wishlist`.`object_id` in (390, 391, 393, 394)280μs/modules/Hotel/Controllers/HotelController.php:109u479693165_rouvfbqk_travi| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select count(*) as aggregate from `bravo_review` where `object_id` = 392 and `object_model` = 'hotel' and `status` = 'approved' and `bravo_review`.`deleted_at` is null650μs/modules/Hotel/Models/Hotel.php:721u479693165_rouvfbqk_travi| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `location_category` where `status` = 'publish' and `location_category`.`deleted_at` is null270μs/modules/Hotel/Controllers/HotelController.php:116u479693165_rouvfbqk_travi| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `location_category_translations` where `locale` = 'en' and `location_category_translations`.`origin_id` in (1, 2, 3)250μs/modules/Hotel/Controllers/HotelController.php:116u479693165_rouvfbqk_travi| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `bravo_seo` where `object_id` = 392 and `object_model` = 'hotel' limit 1400μ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 null270μ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 1380μ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 1190μ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 1190μ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 1150μ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 1190μ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 1170μ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 1190μ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 1160μs/app/BaseModel.php:135u479693165_rouvfbqk_travi| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `bravo_hotel_term` where `bravo_hotel_term`.`target_id` = 392 and `bravo_hotel_term`.`target_id` is not null1.12msview::7a4681f798d2d3fd65f0ae33f5215f802f0159b4:2u479693165_rouvfbqk_travi| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `bravo_terms` where `bravo_terms`.`id` in (714, 726, 728, 734, 732) and `bravo_terms`.`deleted_at` is null290μs/modules/Core/Models/Terms.php:42u479693165_rouvfbqk_travi| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `bravo_terms_translations` where `locale` = 'en' and `bravo_terms_translations`.`origin_id` in (714, 726, 728, 732, 734)270μs/modules/Core/Models/Terms.php:42u479693165_rouvfbqk_travi| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `bravo_attrs` where `bravo_attrs`.`id` in (99, 100, 101) and `bravo_attrs`.`deleted_at` is null250μs/modules/Core/Models/Terms.php:42u479693165_rouvfbqk_travi| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `bravo_attrs_translations` where `bravo_attrs_translations`.`origin_id` = 99 and `bravo_attrs_translations`.`origin_id` is not null and `locale` = 'en' limit 1240μs/app/Traits/HasTranslations.php:51u479693165_rouvfbqk_travi| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `bravo_attrs_translations` where `bravo_attrs_translations`.`origin_id` = 100 and `bravo_attrs_translations`.`origin_id` is not null and `locale` = 'en' limit 1310μs/app/Traits/HasTranslations.php:51u479693165_rouvfbqk_travi| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `bravo_attrs_translations` where `bravo_attrs_translations`.`origin_id` = 101 and `bravo_attrs_translations`.`origin_id` is not null and `locale` = 'en' limit 1140μs/app/Traits/HasTranslations.php:51u479693165_rouvfbqk_travi| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select AVG(rate_number) as score_total , COUNT(id) as total_review from `bravo_review` where `object_id` = 392 and `object_model` = 'hotel' and `status` = 'approved' and `bravo_review`.`deleted_at` is null limit 1970μs/modules/Hotel/Models/Hotel.php:667u479693165_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` = 392 and `object_model` = 'hotel' and `status` = 'approved' and `bravo_review`.`deleted_at` is null limit 1850μs/modules/Hotel/Models/Hotel.php:679u479693165_rouvfbqk_travi| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select AVG(rate_number) as score_total , COUNT(id) as total_review from `bravo_review` where `object_id` = 392 and `object_model` = 'hotel' and `status` = 'approved' and `bravo_review`.`deleted_at` is null limit 1860μs/modules/Hotel/Models/Hotel.php:667u479693165_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` = 392 and `object_model` = 'hotel' and `status` = 'approved' and `bravo_review`.`deleted_at` is null limit 1800μs/modules/Hotel/Models/Hotel.php:679u479693165_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` = 'en' limit 1460μ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 1350μ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` = 'en' limit 1300μ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.190.159.202" ] "x-forwarded-proto" => array:1 [▶ 0 => "https" ] "x-real-ip" => array:1 [▶ 0 => "18.190.159.202" ] "x-real-port" => array:1 [▶ 0 => "8887" ] "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.190.159.202" "HTTP_X_FORWARDED_PROTO" => "https" "HTTP_X_REAL_IP" => "18.190.159.202" "HTTP_X_REAL_PORT" => "8887" "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.190.159.202" "REMOTE_PORT" => "16628" "SERVER_ADDR" => "2a02:4780:11:1654:0:1c97:896d:3" "SERVER_NAME" => "rouvana.com" "SERVER_ADMIN" => "" "SERVER_PORT" => "443" "REQUEST_SCHEME" => "https" "REQUEST_URI" => "/hotel/landmark-hotel-riqqa-deira-dubai" "REDIRECT_URL" => "/public/hotel/landmark-hotel-riqqa-deira-dubai" "REDIRECT_REQUEST_METHOD" => "GET" "PROXY_REMOTE_ADDR" => "2a02:4780:1:22::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/hotel/landmark-hotel-riqqa-deira-dubai" "SCRIPT_URL" => "/hotel/landmark-hotel-riqqa-deira-dubai" "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" => 1744064868.5406 "REQUEST_TIME" => 1744064868 ]
[]
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 => "Mon, 07 Apr 2025 22:27:48 GMT" ] "set-cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6ImJ5OHVZVzVNYzJXVjMvbFVaUm8zU3c9PSIsInZhbHVlIjoicjhRVG9zbUFKSitaNlBuVmdNSlg2NE5paVZjakNJZHZJaW9zbFhCQzFRWFBhQWo0TVBmWGlkOEVuWjFYY2xmN1NhY29ROE9tb2NxSVF0UjFmMFhVWlQzcDRma2R5R3dWcEQ1K2FCbDRqM284TFBtUTV0OGF0ZDg4YVYxaDlJQWkiLCJtYWMiOiIzODNkN2E4NWRiNTdjNTlmMDJmNzA3ODMwN2M2NWI0ZjM1YmE0MjA0NTgzZTNiNjY0Nzg1YjYxMzY2NDczYTRiIiwidGFnIjoiIn0%3D; expires=Tue, 08-Apr-2025 00:27:48 GMT; Max-Age=7200; path=/; samesite=lax ◀XSRF-TOKEN=eyJpdiI6ImJ5OHVZVzVNYzJXVjMvbFVaUm8zU3c9PSIsInZhbHVlIjoicjhRVG9zbUFKSitaNlBuVmdNSlg2NE5paVZjakNJZHZJaW9zbFhCQzFRWFBhQWo0TVBmWGlkOEVuWjFYY2xmN1NhY29RO ▶" 1 => "rouvana_session=eyJpdiI6IlNPbHpOYk05ODhnVG92STlpV1Y2Y0E9PSIsInZhbHVlIjoiNXhDckFBTW5GcmZuQVpjWHlIYldjUzBDK2pJaVNnSUQyVHNZd2VJUEZzWUlaT0YxVFVrVzhMK2ZiSGpkQlRvVU4vZlk4ZkNSb0s3YXo5dkVOb0NKdkhJNXFrZjgrZ1VLNU5ZYVFSOHJPczBTOFMvNnhFUytDSmdtWFN0WGQrcngiLCJtYWMiOiI4NDBhMjU4MDQ4OGRjMmNjYjhjNGQzZThlMWM2NzNiODdmOTYyN2EyY2ZhYjNhMDA0ODc5NTU0MzcxYTdiOGVmIiwidGFnIjoiIn0%3D; expires=Tue, 08-Apr-2025 00:27:48 GMT; Max-Age=7200; path=/; httponly; samesite=lax ◀rouvana_session=eyJpdiI6IlNPbHpOYk05ODhnVG92STlpV1Y2Y0E9PSIsInZhbHVlIjoiNXhDckFBTW5GcmZuQVpjWHlIYldjUzBDK2pJaVNnSUQyVHNZd2VJUEZzWUlaT0YxVFVrVzhMK2ZiSGpkQlRvVU4v ▶" ] "Set-Cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6ImJ5OHVZVzVNYzJXVjMvbFVaUm8zU3c9PSIsInZhbHVlIjoicjhRVG9zbUFKSitaNlBuVmdNSlg2NE5paVZjakNJZHZJaW9zbFhCQzFRWFBhQWo0TVBmWGlkOEVuWjFYY2xmN1NhY29ROE9tb2NxSVF0UjFmMFhVWlQzcDRma2R5R3dWcEQ1K2FCbDRqM284TFBtUTV0OGF0ZDg4YVYxaDlJQWkiLCJtYWMiOiIzODNkN2E4NWRiNTdjNTlmMDJmNzA3ODMwN2M2NWI0ZjM1YmE0MjA0NTgzZTNiNjY0Nzg1YjYxMzY2NDczYTRiIiwidGFnIjoiIn0%3D; expires=Tue, 08-Apr-2025 00:27:48 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6ImJ5OHVZVzVNYzJXVjMvbFVaUm8zU3c9PSIsInZhbHVlIjoicjhRVG9zbUFKSitaNlBuVmdNSlg2NE5paVZjakNJZHZJaW9zbFhCQzFRWFBhQWo0TVBmWGlkOEVuWjFYY2xmN1NhY29RO ▶" 1 => "rouvana_session=eyJpdiI6IlNPbHpOYk05ODhnVG92STlpV1Y2Y0E9PSIsInZhbHVlIjoiNXhDckFBTW5GcmZuQVpjWHlIYldjUzBDK2pJaVNnSUQyVHNZd2VJUEZzWUlaT0YxVFVrVzhMK2ZiSGpkQlRvVU4vZlk4ZkNSb0s3YXo5dkVOb0NKdkhJNXFrZjgrZ1VLNU5ZYVFSOHJPczBTOFMvNnhFUytDSmdtWFN0WGQrcngiLCJtYWMiOiI4NDBhMjU4MDQ4OGRjMmNjYjhjNGQzZThlMWM2NzNiODdmOTYyN2EyY2ZhYjNhMDA0ODc5NTU0MzcxYTdiOGVmIiwidGFnIjoiIn0%3D; expires=Tue, 08-Apr-2025 00:27:48 GMT; path=/; httponly ◀rouvana_session=eyJpdiI6IlNPbHpOYk05ODhnVG92STlpV1Y2Y0E9PSIsInZhbHVlIjoiNXhDckFBTW5GcmZuQVpjWHlIYldjUzBDK2pJaVNnSUQyVHNZd2VJUEZzWUlaT0YxVFVrVzhMK2ZiSGpkQlRvVU4v ▶" ] ]
0 of 0array:4 [▼ "_token" => "1vPOjQBG531QfUJc26WIqKMCEZNwhLkomzQTSTWr" "_previous" => array:1 [▶ "url" => "https://rouvana.com/hotel/landmark-hotel-riqqa-deira-dubai" ] "_flash" => array:2 [▶ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]