Rouvana Tours
Rouvana Tours
  1. Home
  2. >
  3. Hotel
  4. >
  5. Dubai - United Arab Emiratis
  6. >
  7. Landmark Hotel Riqqa, Deira, Dubai

Landmark Hotel Riqqa, Deira, Dubai

Al Jazira Street, Deira - Al Jazira St - Dubai
From
$154,00

Overview

Nothing’s too much trouble; nothing’s too far away; everything’s just right at Riqqa’s renowned retreat.

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.

Rooms

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.

 

 

 

 

Why this hotel?

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:

  • 1. Nerve-centre location in Dubai.
  • 2. Handpicked staff that leave no need unanswered.
  • 3. Beautiful, luxurious and inviting room and hotel interiors.

Property type

Hotels

Facilities

Flat Tv
Internet – Wifi

Hotel Service

Hotel transport services
Laundry Services

Available Rooms

Guest

1 adults - 0 children

Hotel Rules - Policies

Check In
14:00 pm
Check Out
12:00 pm

Where you’ll be

Dubai - United Arab Emiratis
Leaflet | © OpenStreetMap contributors

Guest reviews

0
Not rated
0 review
Excellent
0
Very Good
0
Average
0
Poor
0
Terrible
0
No Review
You must log in to write review

You might also like

Landmark Hotel Baniyas Dubai

Dubai - United Arab Emiratis

0
Not rated
0 Review
Starting from
$150,00

Landmark Summit Hotel

Dubai - United Arab Emiratis

0
Not rated
0 Review
Starting from
$155,00

Landmark Premier Hotel

Dubai - United Arab Emiratis

0
Not rated
0 Review
Starting from
$0,00

Landmark Plaza Hotel

Dubai - United Arab Emiratis

0
Not rated
0 Review
Starting from
$0,00

Your Travel Journey Starts Here

Sign up and we'll send the best deals to you
8.1.32PHP Version276msRequest Duration7MBMemory UsageGET hotel/{slug}RouteAuth status
    • Booting (37.87ms)
    • Application (238ms)
    • 1 x Application (86.25%)
      237.86ms
      1 x Booting (13.73%)
      37.87ms
      36 templates were rendered
      • Hotel::frontend.detail (themes/GoTrip/Hotel/Views/frontend/detail.blade.php)9blade
        Params
        0
        row
        1
        translation
        2
        hotel_related
        3
        location_category
        4
        booking_data
        5
        review_list
        6
        seo_meta
        7
        body_class
        8
        breadcrumbs
      • Layout::parts.bc (themes/GoTrip/Layout/parts/bc.blade.php)12blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        row
        4
        translation
        5
        hotel_related
        6
        location_category
        7
        booking_data
        8
        review_list
        9
        seo_meta
        10
        body_class
        11
        breadcrumbs
      • Hotel::frontend.layouts.details.hotel-detail (themes/GoTrip/Hotel/Views/frontend/layouts/details/hotel-detail.blade.php)12blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        row
        4
        translation
        5
        hotel_related
        6
        location_category
        7
        booking_data
        8
        review_list
        9
        seo_meta
        10
        body_class
        11
        breadcrumbs
      • Layout::common.detail.gallery2 (themes/GoTrip/Layout/common/detail/gallery2.blade.php)14blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        row
        4
        translation
        5
        hotel_related
        6
        location_category
        7
        booking_data
        8
        review_list
        9
        seo_meta
        10
        body_class
        11
        breadcrumbs
        12
        i
        13
        galleries
      • Hotel::frontend.layouts.details.hotel-attributes (themes/GoTrip/Hotel/Views/frontend/layouts/details/hotel-attributes.blade.php)13blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        row
        4
        translation
        5
        hotel_related
        6
        location_category
        7
        booking_data
        8
        review_list
        9
        seo_meta
        10
        body_class
        11
        breadcrumbs
        12
        i
      • Hotel::frontend.layouts.details.hotel-rooms (themes/GoTrip/Hotel/Views/frontend/layouts/details/hotel-rooms.blade.php)13blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        row
        4
        translation
        5
        hotel_related
        6
        location_category
        7
        booking_data
        8
        review_list
        9
        seo_meta
        10
        body_class
        11
        breadcrumbs
        12
        i
      • Hotel::frontend.layouts.details.hotel-room-list (themes/GoTrip/Hotel/Views/frontend/layouts/details/hotel-room-list.blade.php)14blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        row
        4
        translation
        5
        hotel_related
        6
        location_category
        7
        booking_data
        8
        review_list
        9
        seo_meta
        10
        body_class
        11
        breadcrumbs
        12
        i
        13
        review_score
      • Booking::frontend.global.enquiry-form (themes/GoTrip/Booking/Views/frontend/global/enquiry-form.blade.php)15blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        row
        4
        translation
        5
        hotel_related
        6
        location_category
        7
        booking_data
        8
        review_list
        9
        seo_meta
        10
        body_class
        11
        breadcrumbs
        12
        i
        13
        review_score
        14
        service_type
      • Hotel::frontend.layouts.details.hotel-rules-policy (themes/GoTrip/Hotel/Views/frontend/layouts/details/hotel-rules-policy.blade.php)12blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        row
        4
        translation
        5
        hotel_related
        6
        location_category
        7
        booking_data
        8
        review_list
        9
        seo_meta
        10
        body_class
        11
        breadcrumbs
      • Layout::map.detail.map (themes/GoTrip/Layout/map/detail/map.blade.php)12blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        row
        4
        translation
        5
        hotel_related
        6
        location_category
        7
        booking_data
        8
        review_list
        9
        seo_meta
        10
        body_class
        11
        breadcrumbs
      • Layout::common.detail.review (themes/GoTrip/Layout/common/detail/review.blade.php)12blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        row
        4
        translation
        5
        hotel_related
        6
        location_category
        7
        booking_data
        8
        review_list
        9
        seo_meta
        10
        body_class
        11
        breadcrumbs
      • Hotel::frontend.layouts.details.hotel-related (themes/GoTrip/Hotel/Views/frontend/layouts/details/hotel-related.blade.php)12blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        row
        4
        translation
        5
        hotel_related
        6
        location_category
        7
        booking_data
        8
        review_list
        9
        seo_meta
        10
        body_class
        11
        breadcrumbs
      • Hotel::frontend.layouts.search.loop-grid (themes/GoTrip/Hotel/Views/frontend/layouts/search/loop-grid.blade.php)14blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        row
        4
        translation
        5
        hotel_related
        6
        location_category
        7
        booking_data
        8
        review_list
        9
        seo_meta
        10
        body_class
        11
        breadcrumbs
        12
        __currentLoopData
        13
        loop
      • Hotel::frontend.layouts.search.loop-grid (themes/GoTrip/Hotel/Views/frontend/layouts/search/loop-grid.blade.php)14blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        row
        4
        translation
        5
        hotel_related
        6
        location_category
        7
        booking_data
        8
        review_list
        9
        seo_meta
        10
        body_class
        11
        breadcrumbs
        12
        __currentLoopData
        13
        loop
      • Hotel::frontend.layouts.search.loop-grid (themes/GoTrip/Hotel/Views/frontend/layouts/search/loop-grid.blade.php)14blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        row
        4
        translation
        5
        hotel_related
        6
        location_category
        7
        booking_data
        8
        review_list
        9
        seo_meta
        10
        body_class
        11
        breadcrumbs
        12
        __currentLoopData
        13
        loop
      • Hotel::frontend.layouts.search.loop-grid (themes/GoTrip/Hotel/Views/frontend/layouts/search/loop-grid.blade.php)14blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        row
        4
        translation
        5
        hotel_related
        6
        location_category
        7
        booking_data
        8
        review_list
        9
        seo_meta
        10
        body_class
        11
        breadcrumbs
        12
        __currentLoopData
        13
        loop
      • layouts.app (resources/views/layouts/app.blade.php)12blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        row
        4
        translation
        5
        hotel_related
        6
        location_category
        7
        booking_data
        8
        review_list
        9
        seo_meta
        10
        body_class
        11
        breadcrumbs
      • Layout::app (themes/GoTrip/Layout/app.blade.php)12blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        row
        4
        translation
        5
        hotel_related
        6
        location_category
        7
        booking_data
        8
        review_list
        9
        seo_meta
        10
        body_class
        11
        breadcrumbs
      • Layout::parts.seo-meta (modules/Layout/parts/seo-meta.blade.php)14blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        row
        4
        translation
        5
        hotel_related
        6
        location_category
        7
        booking_data
        8
        review_list
        9
        seo_meta
        10
        body_class
        11
        breadcrumbs
        12
        favicon
        13
        file
      • Layout::parts.global-script (modules/Layout/parts/global-script.blade.php)14blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        row
        4
        translation
        5
        hotel_related
        6
        location_category
        7
        booking_data
        8
        review_list
        9
        seo_meta
        10
        body_class
        11
        breadcrumbs
        12
        favicon
        13
        file
      • Layout::parts.preload (themes/GoTrip/Layout/parts/preload.blade.php)15blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        row
        4
        translation
        5
        hotel_related
        6
        location_category
        7
        booking_data
        8
        review_list
        9
        seo_meta
        10
        body_class
        11
        breadcrumbs
        12
        favicon
        13
        file
        14
        hideHeaderMargin
      • Layout::parts.header (themes/GoTrip/Layout/parts/header.blade.php)15blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        row
        4
        translation
        5
        hotel_related
        6
        location_category
        7
        booking_data
        8
        review_list
        9
        seo_meta
        10
        body_class
        11
        breadcrumbs
        12
        favicon
        13
        file
        14
        hideHeaderMargin
      • Layout::parts.header-style.normal (themes/GoTrip/Layout/parts/header-style/normal.blade.php)21blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        row
        4
        translation
        5
        hotel_related
        6
        location_category
        7
        booking_data
        8
        review_list
        9
        seo_meta
        10
        body_class
        11
        breadcrumbs
        12
        favicon
        13
        file
        14
        hideHeaderMargin
        15
        headerStyle
        16
        dataBg
        17
        navTextStyle
        18
        headerClass
        19
        logo
        20
        logoDark
      • Core::frontend.currency-switcher (themes/GoTrip/Core/Views/frontend/currency-switcher.blade.php)22blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        row
        4
        translation
        5
        hotel_related
        6
        location_category
        7
        booking_data
        8
        review_list
        9
        seo_meta
        10
        body_class
        11
        breadcrumbs
        12
        favicon
        13
        file
        14
        hideHeaderMargin
        15
        headerStyle
        16
        dataBg
        17
        navTextStyle
        18
        headerClass
        19
        logo
        20
        logoDark
        21
        textColor
      • Language::frontend.switcher-dropdown (themes/GoTrip/Language/Views/frontend/switcher-dropdown.blade.php)22blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        row
        4
        translation
        5
        hotel_related
        6
        location_category
        7
        booking_data
        8
        review_list
        9
        seo_meta
        10
        body_class
        11
        breadcrumbs
        12
        favicon
        13
        file
        14
        hideHeaderMargin
        15
        headerStyle
        16
        dataBg
        17
        navTextStyle
        18
        headerClass
        19
        logo
        20
        logoDark
        21
        textColor
      • Core::frontend.currency-switcher (themes/GoTrip/Core/Views/frontend/currency-switcher.blade.php)21blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        row
        4
        translation
        5
        hotel_related
        6
        location_category
        7
        booking_data
        8
        review_list
        9
        seo_meta
        10
        body_class
        11
        breadcrumbs
        12
        favicon
        13
        file
        14
        hideHeaderMargin
        15
        headerStyle
        16
        dataBg
        17
        navTextStyle
        18
        headerClass
        19
        logo
        20
        logoDark
      • Language::frontend.switcher-dropdown (themes/GoTrip/Language/Views/frontend/switcher-dropdown.blade.php)21blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        row
        4
        translation
        5
        hotel_related
        6
        location_category
        7
        booking_data
        8
        review_list
        9
        seo_meta
        10
        body_class
        11
        breadcrumbs
        12
        favicon
        13
        file
        14
        hideHeaderMargin
        15
        headerStyle
        16
        dataBg
        17
        navTextStyle
        18
        headerClass
        19
        logo
        20
        logoDark
      • Layout::parts.footer (themes/GoTrip/Layout/parts/footer.blade.php)15blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        row
        4
        translation
        5
        hotel_related
        6
        location_category
        7
        booking_data
        8
        review_list
        9
        seo_meta
        10
        body_class
        11
        breadcrumbs
        12
        favicon
        13
        file
        14
        hideHeaderMargin
      • Layout::parts.footer-style.index (themes/GoTrip/Layout/parts/footer-style/index.blade.php)18blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        row
        4
        translation
        5
        hotel_related
        6
        location_category
        7
        booking_data
        8
        review_list
        9
        seo_meta
        10
        body_class
        11
        breadcrumbs
        12
        favicon
        13
        file
        14
        hideHeaderMargin
        15
        footerStyle
        16
        mailchimp_classes
        17
        button_classes
      • Layout::parts.footer-style.normal (themes/GoTrip/Layout/parts/footer-style/normal.blade.php)19blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        row
        4
        translation
        5
        hotel_related
        6
        location_category
        7
        booking_data
        8
        review_list
        9
        seo_meta
        10
        body_class
        11
        breadcrumbs
        12
        favicon
        13
        file
        14
        hideHeaderMargin
        15
        footerStyle
        16
        mailchimp_classes
        17
        button_classes
        18
        footer_classes
      • Core::frontend.currency-switcher (themes/GoTrip/Core/Views/frontend/currency-switcher.blade.php)19blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        row
        4
        translation
        5
        hotel_related
        6
        location_category
        7
        booking_data
        8
        review_list
        9
        seo_meta
        10
        body_class
        11
        breadcrumbs
        12
        favicon
        13
        file
        14
        hideHeaderMargin
        15
        footerStyle
        16
        mailchimp_classes
        17
        button_classes
        18
        footer_classes
      • Language::frontend.switcher-dropdown (themes/GoTrip/Language/Views/frontend/switcher-dropdown.blade.php)19blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        row
        4
        translation
        5
        hotel_related
        6
        location_category
        7
        booking_data
        8
        review_list
        9
        seo_meta
        10
        body_class
        11
        breadcrumbs
        12
        favicon
        13
        file
        14
        hideHeaderMargin
        15
        footerStyle
        16
        mailchimp_classes
        17
        button_classes
        18
        footer_classes
      • Layout::parts.login-register-modal (themes/GoTrip/Layout/parts/login-register-modal.blade.php)18blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        row
        4
        translation
        5
        hotel_related
        6
        location_category
        7
        booking_data
        8
        review_list
        9
        seo_meta
        10
        body_class
        11
        breadcrumbs
        12
        favicon
        13
        file
        14
        hideHeaderMargin
        15
        footerStyle
        16
        mailchimp_classes
        17
        button_classes
      • Layout::auth.login-form (themes/GoTrip/Layout/auth/login-form.blade.php)18blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        row
        4
        translation
        5
        hotel_related
        6
        location_category
        7
        booking_data
        8
        review_list
        9
        seo_meta
        10
        body_class
        11
        breadcrumbs
        12
        favicon
        13
        file
        14
        hideHeaderMargin
        15
        footerStyle
        16
        mailchimp_classes
        17
        button_classes
      • Layout::auth.register-form (themes/GoTrip/Layout/auth/register-form.blade.php)18blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        row
        4
        translation
        5
        hotel_related
        6
        location_category
        7
        booking_data
        8
        review_list
        9
        seo_meta
        10
        body_class
        11
        breadcrumbs
        12
        favicon
        13
        file
        14
        hideHeaderMargin
        15
        footerStyle
        16
        mailchimp_classes
        17
        button_classes
      • Popup::frontend.popup (themes/GoTrip/Popup/Views/frontend/popup.blade.php)18blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        row
        4
        translation
        5
        hotel_related
        6
        location_category
        7
        booking_data
        8
        review_list
        9
        seo_meta
        10
        body_class
        11
        breadcrumbs
        12
        favicon
        13
        file
        14
        hideHeaderMargin
        15
        footerStyle
        16
        mailchimp_classes
        17
        button_classes
      uri
      GET hotel/{slug}
      middleware
      web
      controller
      Modules\Hotel\Controllers\HotelController@detail
      namespace
      Modules\Hotel\Controllers
      prefix
      /hotel
      where
      as
      hotel.detail
      file
      modules/Hotel/Controllers/HotelController.php:99-136
      36 statements were executed, 16 of which were duplicated, 20 unique18.54ms
      • select * from `bravo_hotels` where `slug` = 'landmark-hotel-riqqa-deira-dubai' and `bravo_hotels`.`deleted_at` is null limit 13.51ms/modules/Hotel/Controllers/HotelController.php:101u479693165_new
        Metadata
        Bindings
        • 0. landmark-hotel-riqqa-deira-dubai
        Hints
        • Use SELECT * only if you need all columns from table
        • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
        Backtrace
        • 15. /modules/Hotel/Controllers/HotelController.php:101
        • 16. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 17. /modules/Hotel/Controllers/HotelController.php:34
        • 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
        • 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
      • select * from `bravo_locations` where `bravo_locations`.`id` in (15) and `bravo_locations`.`deleted_at` is null690μs/modules/Hotel/Controllers/HotelController.php:101u479693165_new
        Metadata
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 20. /modules/Hotel/Controllers/HotelController.php:101
        • 21. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 22. /modules/Hotel/Controllers/HotelController.php:34
        • 23. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
        • 24. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
      • select * from `bravo_location_translations` where `locale` = 'en' and `bravo_location_translations`.`origin_id` in (15)260μs/modules/Hotel/Controllers/HotelController.php:101u479693165_new
        Metadata
        Bindings
        • 0. en
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 25. /modules/Hotel/Controllers/HotelController.php:101
        • 26. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 27. /modules/Hotel/Controllers/HotelController.php:34
        • 28. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
        • 29. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
      • select * from `bravo_hotel_translations` where `locale` = 'en' and `bravo_hotel_translations`.`origin_id` in (392) and `bravo_hotel_translations`.`deleted_at` is null250μs/modules/Hotel/Controllers/HotelController.php:101u479693165_new
        Metadata
        Bindings
        • 0. en
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 20. /modules/Hotel/Controllers/HotelController.php:101
        • 21. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 22. /modules/Hotel/Controllers/HotelController.php:34
        • 23. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
        • 24. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
      • 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_new
        Metadata
        Bindings
        • 0. hotel
        • 1. 0
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 20. /modules/Hotel/Controllers/HotelController.php:101
        • 21. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 22. /modules/Hotel/Controllers/HotelController.php:34
        • 23. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
        • 24. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
      • select * from `bravo_hotels` where `location_id` = 15 and `status` = 'publish' and `id` not in (392) and `bravo_hotels`.`deleted_at` is null limit 4360μs/modules/Hotel/Controllers/HotelController.php:109u479693165_new
        Metadata
        Bindings
        • 0. 15
        • 1. publish
        • 2. 392
        Hints
        • Use SELECT * only if you need all columns from table
        • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
        Backtrace
        • 14. /modules/Hotel/Controllers/HotelController.php:109
        • 15. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 16. /modules/Hotel/Controllers/HotelController.php:34
        • 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
        • 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
      • select * from `bravo_locations` where `bravo_locations`.`id` in (15) and `bravo_locations`.`deleted_at` is null240μs/modules/Hotel/Controllers/HotelController.php:109u479693165_new
        Metadata
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 19. /modules/Hotel/Controllers/HotelController.php:109
        • 20. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 21. /modules/Hotel/Controllers/HotelController.php:34
        • 22. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
        • 23. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
      • select * from `bravo_location_translations` where `locale` = 'en' and `bravo_location_translations`.`origin_id` in (15)170μs/modules/Hotel/Controllers/HotelController.php:109u479693165_new
        Metadata
        Bindings
        • 0. en
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 24. /modules/Hotel/Controllers/HotelController.php:109
        • 25. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 26. /modules/Hotel/Controllers/HotelController.php:34
        • 27. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
        • 28. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
      • 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 null270μs/modules/Hotel/Controllers/HotelController.php:109u479693165_new
        Metadata
        Bindings
        • 0. en
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 19. /modules/Hotel/Controllers/HotelController.php:109
        • 20. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 21. /modules/Hotel/Controllers/HotelController.php:34
        • 22. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
        • 23. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
      • select * from `user_wishlist` where `object_model` = 'hotel' and `user_id` = 0 and `user_wishlist`.`object_id` in (390, 391, 393, 394)200μs/modules/Hotel/Controllers/HotelController.php:109u479693165_new
        Metadata
        Bindings
        • 0. hotel
        • 1. 0
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 19. /modules/Hotel/Controllers/HotelController.php:109
        • 20. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 21. /modules/Hotel/Controllers/HotelController.php:34
        • 22. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
        • 23. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
      • select count(*) as aggregate from `bravo_review` where `object_id` = 392 and `object_model` = 'hotel' and `status` = 'approved' and `bravo_review`.`deleted_at` is null620μs/modules/Hotel/Models/Hotel.php:721u479693165_new
        Metadata
        Bindings
        • 0. 392
        • 1. hotel
        • 2. approved
        Backtrace
        • 15. /modules/Hotel/Models/Hotel.php:721
        • 16. /modules/Hotel/Controllers/HotelController.php:111
        • 17. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 18. /modules/Hotel/Controllers/HotelController.php:34
        • 19. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • select * from `location_category` where `status` = 'publish' and `location_category`.`deleted_at` is null310μs/modules/Hotel/Controllers/HotelController.php:116u479693165_new
        Metadata
        Bindings
        • 0. publish
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 14. /modules/Hotel/Controllers/HotelController.php:116
        • 15. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 16. /modules/Hotel/Controllers/HotelController.php:34
        • 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
        • 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
      • select * from `location_category_translations` where `locale` = 'en' and `location_category_translations`.`origin_id` in (1, 2, 3)240μs/modules/Hotel/Controllers/HotelController.php:116u479693165_new
        Metadata
        Bindings
        • 0. en
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 19. /modules/Hotel/Controllers/HotelController.php:116
        • 20. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 21. /modules/Hotel/Controllers/HotelController.php:34
        • 22. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
        • 23. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
      • select * from `bravo_seo` where `object_id` = 392 and `object_model` = 'hotel' limit 1290μs/app/BaseModel.php:199u479693165_new
        Metadata
        Bindings
        • 0. 392
        • 1. hotel
        Hints
        • Use SELECT * only if you need all columns from table
        • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
        Backtrace
        • 15. /app/BaseModel.php:199
        • 16. /app/BaseModel.php:212
        • 17. /modules/Hotel/Controllers/HotelController.php:119
        • 18. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 19. /modules/Hotel/Controllers/HotelController.php:34
      • 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 null310μs/vendor/kalnoy/nestedset/src/QueryBuilder.php:159u479693165_new
        Metadata
        Bindings
        • 0. 30
        • 1. 15
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 14. /vendor/kalnoy/nestedset/src/QueryBuilder.php:159
        • 17. /modules/Location/Traits/HasLocation.php:21
        • 18. /modules/Hotel/Controllers/HotelController.php:128
        • 19. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 20. /modules/Hotel/Controllers/HotelController.php:34
      • select * from `media_files` where `media_files`.`id` = '' and `media_files`.`deleted_at` is null limit 11.03ms/app/BaseModel.php:135u479693165_new
        Metadata
        Bindings
        • 0. 
        Hints
        • Use SELECT * only if you need all columns from table
        • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
        Backtrace
        • 18. /app/BaseModel.php:135
        • 19. /vendor/laravel/framework/src/Illuminate/Cache/Repository.php:426
        • 20. /vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:419
        • 22. /app/BaseModel.php:136
        • 23. /modules/Media/Helpers/FileHelper.php:42
      • select * from `media_files` where `media_files`.`id` = '' and `media_files`.`deleted_at` is null limit 1290μs/app/BaseModel.php:135u479693165_new
        Metadata
        Bindings
        • 0. 
        Hints
        • Use SELECT * only if you need all columns from table
        • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
        Backtrace
        • 18. /app/BaseModel.php:135
        • 19. /vendor/laravel/framework/src/Illuminate/Cache/Repository.php:426
        • 20. /vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:419
        • 22. /app/BaseModel.php:136
        • 23. /modules/Media/Helpers/FileHelper.php:42
      • select * from `media_files` where `media_files`.`id` = '' and `media_files`.`deleted_at` is null limit 1210μs/app/BaseModel.php:135u479693165_new
        Metadata
        Bindings
        • 0. 
        Hints
        • Use SELECT * only if you need all columns from table
        • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
        Backtrace
        • 18. /app/BaseModel.php:135
        • 19. /vendor/laravel/framework/src/Illuminate/Cache/Repository.php:426
        • 20. /vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:419
        • 22. /app/BaseModel.php:136
        • 23. /modules/Media/Helpers/FileHelper.php:42
      • select * from `media_files` where `media_files`.`id` = '' and `media_files`.`deleted_at` is null limit 1230μs/app/BaseModel.php:135u479693165_new
        Metadata
        Bindings
        • 0. 
        Hints
        • Use SELECT * only if you need all columns from table
        • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
        Backtrace
        • 18. /app/BaseModel.php:135
        • 19. /vendor/laravel/framework/src/Illuminate/Cache/Repository.php:426
        • 20. /vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:419
        • 22. /app/BaseModel.php:136
        • 23. /modules/Media/Helpers/FileHelper.php:42
      • select * from `media_files` where `media_files`.`id` = '' and `media_files`.`deleted_at` is null limit 1210μs/app/BaseModel.php:135u479693165_new
        Metadata
        Bindings
        • 0. 
        Hints
        • Use SELECT * only if you need all columns from table
        • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
        Backtrace
        • 18. /app/BaseModel.php:135
        • 19. /vendor/laravel/framework/src/Illuminate/Cache/Repository.php:426
        • 20. /vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:419
        • 22. /app/BaseModel.php:136
        • 23. /modules/Media/Helpers/FileHelper.php:42
      • select * from `media_files` where `media_files`.`id` = '' and `media_files`.`deleted_at` is null limit 1170μs/app/BaseModel.php:135u479693165_new
        Metadata
        Bindings
        • 0. 
        Hints
        • Use SELECT * only if you need all columns from table
        • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
        Backtrace
        • 18. /app/BaseModel.php:135
        • 19. /vendor/laravel/framework/src/Illuminate/Cache/Repository.php:426
        • 20. /vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:419
        • 22. /app/BaseModel.php:136
        • 23. /modules/Media/Helpers/FileHelper.php:42
      • select * from `media_files` where `media_files`.`id` = '' and `media_files`.`deleted_at` is null limit 1220μs/app/BaseModel.php:135u479693165_new
        Metadata
        Bindings
        • 0. 
        Hints
        • Use SELECT * only if you need all columns from table
        • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
        Backtrace
        • 18. /app/BaseModel.php:135
        • 19. /vendor/laravel/framework/src/Illuminate/Cache/Repository.php:426
        • 20. /vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:419
        • 22. /app/BaseModel.php:136
        • 23. /modules/Media/Helpers/FileHelper.php:42
      • select * from `media_files` where `media_files`.`id` = '' and `media_files`.`deleted_at` is null limit 1190μs/app/BaseModel.php:135u479693165_new
        Metadata
        Bindings
        • 0. 
        Hints
        • Use SELECT * only if you need all columns from table
        • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
        Backtrace
        • 18. /app/BaseModel.php:135
        • 19. /vendor/laravel/framework/src/Illuminate/Cache/Repository.php:426
        • 20. /vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:419
        • 22. /app/BaseModel.php:136
        • 23. /modules/Media/Helpers/FileHelper.php:42
      • select * from `bravo_hotel_term` where `bravo_hotel_term`.`target_id` = 392 and `bravo_hotel_term`.`target_id` is not null1.28msview::b36dc5b2e9c84fc7bdcf8938d0c10a9a10091678:2u479693165_new
        Metadata
        Bindings
        • 0. 392
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 19. view::b36dc5b2e9c84fc7bdcf8938d0c10a9a10091678:2
        • 21. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
        • 22. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 23. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
        • 24. /vendor/laravel/framework/src/Illuminate/View/View.php:152
      • select * from `bravo_terms` where `bravo_terms`.`id` in (714, 726, 728, 734, 732) and `bravo_terms`.`deleted_at` is null350μs/modules/Core/Models/Terms.php:42u479693165_new
        Metadata
        Bindings
        • 0. 714
        • 1. 726
        • 2. 728
        • 3. 734
        • 4. 732
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 16. /modules/Core/Models/Terms.php:42
        • 17. view::b36dc5b2e9c84fc7bdcf8938d0c10a9a10091678:3
        • 19. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
        • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 21. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
      • 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_new
        Metadata
        Bindings
        • 0. en
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 21. /modules/Core/Models/Terms.php:42
        • 22. view::b36dc5b2e9c84fc7bdcf8938d0c10a9a10091678:3
        • 24. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
        • 25. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 26. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
      • select * from `bravo_attrs` where `bravo_attrs`.`id` in (99, 100, 101) and `bravo_attrs`.`deleted_at` is null270μs/modules/Core/Models/Terms.php:42u479693165_new
        Metadata
        Bindings
        • 0. 99
        • 1. 100
        • 2. 101
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 21. /modules/Core/Models/Terms.php:42
        • 22. view::b36dc5b2e9c84fc7bdcf8938d0c10a9a10091678:3
        • 24. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
        • 25. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 26. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
      • 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 1720μs/app/Traits/HasTranslations.php:51u479693165_new
        Metadata
        Bindings
        • 0. 99
        • 1. en
        Hints
        • Use SELECT * only if you need all columns from table
        • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
        Backtrace
        • 20. /app/Traits/HasTranslations.php:51
        • 21. view::b36dc5b2e9c84fc7bdcf8938d0c10a9a10091678:7
        • 23. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
        • 24. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 25. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
      • 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 1160μs/app/Traits/HasTranslations.php:51u479693165_new
        Metadata
        Bindings
        • 0. 100
        • 1. en
        Hints
        • Use SELECT * only if you need all columns from table
        • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
        Backtrace
        • 20. /app/Traits/HasTranslations.php:51
        • 21. view::b36dc5b2e9c84fc7bdcf8938d0c10a9a10091678:7
        • 23. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
        • 24. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 25. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
      • 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 1190μs/app/Traits/HasTranslations.php:51u479693165_new
        Metadata
        Bindings
        • 0. 101
        • 1. en
        Hints
        • Use SELECT * only if you need all columns from table
        • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
        Backtrace
        • 20. /app/Traits/HasTranslations.php:51
        • 21. view::b36dc5b2e9c84fc7bdcf8938d0c10a9a10091678:7
        • 23. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
        • 24. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 25. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
      • 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 11.1ms/modules/Hotel/Models/Hotel.php:667u479693165_new
        Metadata
        Bindings
        • 0. 392
        • 1. hotel
        • 2. approved
        Hints
        • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
        Backtrace
        • 15. /modules/Hotel/Models/Hotel.php:667
        • 21. view::7e6258acb7482d492fa82d858fb6d37ca2288d16:1
        • 23. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
        • 24. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 25. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
      • 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 11ms/modules/Hotel/Models/Hotel.php:679u479693165_new
        Metadata
        Bindings
        • 0. 392
        • 1. hotel
        • 2. approved
        Hints
        • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
        Backtrace
        • 15. /modules/Hotel/Models/Hotel.php:679
        • 21. view::7e6258acb7482d492fa82d858fb6d37ca2288d16:1
        • 23. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
        • 24. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 25. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
      • 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 11ms/modules/Hotel/Models/Hotel.php:667u479693165_new
        Metadata
        Bindings
        • 0. 392
        • 1. hotel
        • 2. approved
        Hints
        • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
        Backtrace
        • 15. /modules/Hotel/Models/Hotel.php:667
        • 21. view::784718a3927ad714f59a153c1ec7eab2ebcf055b:1
        • 23. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
        • 24. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 25. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
      • 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 1920μs/modules/Hotel/Models/Hotel.php:679u479693165_new
        Metadata
        Bindings
        • 0. 392
        • 1. hotel
        • 2. approved
        Hints
        • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
        Backtrace
        • 15. /modules/Hotel/Models/Hotel.php:679
        • 21. view::784718a3927ad714f59a153c1ec7eab2ebcf055b:1
        • 23. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
        • 24. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 25. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
      • 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 1450μs/app/Traits/HasTranslations.php:51u479693165_new
        Metadata
        Bindings
        • 0. 2
        • 1. en
        Hints
        • Use SELECT * only if you need all columns from table
        • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
        Backtrace
        • 20. /app/Traits/HasTranslations.php:51
        • 21. /app/Helpers/AppHelper.php:111
        • 24. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
        • 25. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 26. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
      • select * from `core_pages` where `core_pages`.`id` = '20' and `core_pages`.`deleted_at` is null limit 1340μs/app/Helpers/AppHelper.php:627u479693165_new
        Metadata
        Bindings
        • 0. 20
        Hints
        • Use SELECT * only if you need all columns from table
        • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
        Backtrace
        • 19. /app/Helpers/AppHelper.php:627
        • 22. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
        • 23. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 24. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
        • 25. /vendor/laravel/framework/src/Illuminate/View/View.php:152
      Modules\Page\Models\Page
      1
      Modules\Core\Models\MenuTranslation
      1
      Modules\Review\Models\Review
      4
      Modules\Core\Models\AttributesTranslation
      1
      Modules\Core\Models\Attributes
      3
      Modules\Core\Models\Terms
      5
      Modules\Hotel\Models\HotelTerm
      5
      Modules\Core\Models\SEO
      1
      Modules\Location\Models\LocationCategory
      3
      Modules\Hotel\Models\HotelTranslation
      5
      Modules\Location\Models\LocationTranslation
      2
      Modules\Location\Models\Location
      2
      Modules\Hotel\Models\Hotel
      5
      web
      null
      sanctum
      null
        _token
        kBN5pGsw8eKMA2xs7spbklhiVpiAcAfUEUWnmrdd
        bc_current_currency
        usd
        _previous
        array:1 [ "url" => "https://rouvanab2b.com/hotel/landmark-hotel-riqqa-deira-dubai" ]
        _flash
        array:2 [ "old" => [] "new" => [] ]
        PHPDEBUGBAR_STACK_DATA
        []
        path_info
        /hotel/landmark-hotel-riqqa-deira-dubai
        status_code
        200
        
        status_text
        OK
        format
        html
        content_type
        text/html; charset=UTF-8
        request_query
        []
        
        request_request
        []
        
        request_headers
        0 of 0
        array: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=eyJpdiI6ImxhNjQ2aDkzMmJqaXpIY2JrU3UxYnc9PSIsInZhbHVlIjoiRklEMitQS3dxL0JpUnU0RHIxRmQrWXlnbFlUNG82QlhDc2NURTV4MlVwbVBERUFiMUp2YUJiMEhNOUNoUUlhV0kvVEFMMkdQMEJmbHZwY09HTEdWRS9kSGZkaXBMWktrRXhDeU1ORXpDVSt4NU5LZEJPWEw2cWYrS1FQTjYxZlYiLCJtYWMiOiIwZTVhNGU0YzBmYzEzNjgwY2U5YzgzNDE0ODM3MzYwNzQ3Yzk3YjM0NDljNDEzYjFlYjAwODM3ZTg3ZDdkZjA5IiwidGFnIjoiIn0%3D; rouvana_session=eyJpdiI6Imx3VklTN1JWa2N4M0NIc2lZWkpRNFE9PSIsInZhbHVlIjoiZnQ4Smh3SEpNeTRpSGlSVlF4V1pVbWVnOXlGNURyVmdtM3NlNGcwdzBONWZhZGM4RWQvSktWMkNIZ1dYNnJtakZ4TlM2Qk5yYTdvSnZBWnpIR3NUc2V1cHkzQmNXQVhYQk9ocW1NWk52TXVTRWFueXVYVmZ0SzM3QWdRbU9uZ3kiLCJtYWMiOiJiMDdhZjFhYjBjNWRiNzM2ZjE4NjcxMjU5ZDA4NzcwZmIxMmYwOTBjNzhmZWM5NmJlNTVlN2IwYjY5OTc1OGE2IiwidGFnIjoiIn0%3DXSRF-TOKEN=eyJpdiI6ImxhNjQ2aDkzMmJqaXpIY2JrU3UxYnc9PSIsInZhbHVlIjoiRklEMitQS3dxL0JpUnU0RHIxRmQrWXlnbFlUNG82QlhDc2NURTV4MlVwbVBERUFiMUp2YUJiMEhNOUNoUUlhV0kvVEFMM" ] "host" => array:1 [ 0 => "rouvanab2b.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 => "13.59.103.64" ] "x-forwarded-proto" => array:1 [ 0 => "https" ] "x-real-ip" => array:1 [ 0 => "13.59.103.64" ] "x-real-port" => array:1 [ 0 => "2715" ] "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" ] ]
        request_server
        0 of 0
        array: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=eyJpdiI6ImxhNjQ2aDkzMmJqaXpIY2JrU3UxYnc9PSIsInZhbHVlIjoiRklEMitQS3dxL0JpUnU0RHIxRmQrWXlnbFlUNG82QlhDc2NURTV4MlVwbVBERUFiMUp2YUJiMEhNOUNoUUlhV0kvVEFMMkdQMEJmbHZwY09HTEdWRS9kSGZkaXBMWktrRXhDeU1ORXpDVSt4NU5LZEJPWEw2cWYrS1FQTjYxZlYiLCJtYWMiOiIwZTVhNGU0YzBmYzEzNjgwY2U5YzgzNDE0ODM3MzYwNzQ3Yzk3YjM0NDljNDEzYjFlYjAwODM3ZTg3ZDdkZjA5IiwidGFnIjoiIn0%3D; rouvana_session=eyJpdiI6Imx3VklTN1JWa2N4M0NIc2lZWkpRNFE9PSIsInZhbHVlIjoiZnQ4Smh3SEpNeTRpSGlSVlF4V1pVbWVnOXlGNURyVmdtM3NlNGcwdzBONWZhZGM4RWQvSktWMkNIZ1dYNnJtakZ4TlM2Qk5yYTdvSnZBWnpIR3NUc2V1cHkzQmNXQVhYQk9ocW1NWk52TXVTRWFueXVYVmZ0SzM3QWdRbU9uZ3kiLCJtYWMiOiJiMDdhZjFhYjBjNWRiNzM2ZjE4NjcxMjU5ZDA4NzcwZmIxMmYwOTBjNzhmZWM5NmJlNTVlN2IwYjY5OTc1OGE2IiwidGFnIjoiIn0%3DXSRF-TOKEN=eyJpdiI6ImxhNjQ2aDkzMmJqaXpIY2JrU3UxYnc9PSIsInZhbHVlIjoiRklEMitQS3dxL0JpUnU0RHIxRmQrWXlnbFlUNG82QlhDc2NURTV4MlVwbVBERUFiMUp2YUJiMEhNOUNoUUlhV0kvVEFMM" "HTTP_HOST" => "rouvanab2b.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" => "13.59.103.64" "HTTP_X_FORWARDED_PROTO" => "https" "HTTP_X_REAL_IP" => "13.59.103.64" "HTTP_X_REAL_PORT" => "2715" "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/rouvanab2b.com/public_html" "REMOTE_ADDR" => "13.59.103.64" "REMOTE_PORT" => "55998" "SERVER_ADDR" => "2a02:4780:11:1654:0:1c97:896d:4" "SERVER_NAME" => "rouvanab2b.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/rouvanab2b.com/public_html/public/index.php" "QUERY_STRING" => "" "SCRIPT_URI" => "https://rouvanab2b.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" => 1745592813.577 "REQUEST_TIME" => 1745592813 ]
        request_cookies
        0 of 0
        array:2 [ "XSRF-TOKEN" => "kBN5pGsw8eKMA2xs7spbklhiVpiAcAfUEUWnmrdd" "rouvana_session" => "2KuPHqO5r8vJjn5bnFbmeZVE0mKMm6JhlqCc10lo" ]
        response_headers
        0 of 0
        array:5 [ "content-type" => array:1 [ 0 => "text/html; charset=UTF-8" ] "cache-control" => array:1 [ 0 => "no-cache, private" ] "date" => array:1 [ 0 => "Fri, 25 Apr 2025 14:53:33 GMT" ] "set-cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6IlJ4Ylg0RDdua3pUd1RYNFE3eTN5Wnc9PSIsInZhbHVlIjoidjVOaGN5czZudnhtc2FkQU1oMHFiZmhIVWlMeVFMWFJhUWUzVXR6Q28rNE80MHJ1WWtXaU1jZXRhdE9tOU5sOFVHVXFCNm9QU0ZTeDh6NzY4ejhIK1RYV1ZtWENnbldLZG9mNlQyNHdXT3JIZFRWRGoxdmhXNW9IbXR2NWhYREIiLCJtYWMiOiI2NzBiYjAzNGYzM2RmYWM3MGYzOWM2OWMwM2E3MmU2ZGIwZjRjZjZiNTgyMmM1MWVlYTQ0NTg3NjM4OTA5OGFkIiwidGFnIjoiIn0%3D; expires=Fri, 25-Apr-2025 16:53:33 GMT; Max-Age=7200; path=/; samesite=laxXSRF-TOKEN=eyJpdiI6IlJ4Ylg0RDdua3pUd1RYNFE3eTN5Wnc9PSIsInZhbHVlIjoidjVOaGN5czZudnhtc2FkQU1oMHFiZmhIVWlMeVFMWFJhUWUzVXR6Q28rNE80MHJ1WWtXaU1jZXRhdE9tOU5sOFVHVXFCN" 1 => "rouvana_session=eyJpdiI6InBwY2ZtU09aU3pSQjlGNHBrVHRmRGc9PSIsInZhbHVlIjoiek1uait5MUlPVmJOYTZ4UGdQU3RoWnFlVThQNUxkYWdXM0tmQU1ZZVpyd2E5MHk0aHhpdjdnd1plZUZXTTErcno0clQ1UThsWTRHdVB0S00xVHlzZnZQNmN5YXlSbDVuMGJrSi96aGNhMGZkZzJKbGEzdHRLM2FJaWpVWXF1b1QiLCJtYWMiOiI2ZjlmZWUyZDI0ZDY4YWRjZDY4NmY3NTI4MDg0YTBkMjczOTc1MGFlYjk4NGI1ZmZkNTIwMDM3MWQzZTJhZTY0IiwidGFnIjoiIn0%3D; expires=Fri, 25-Apr-2025 16:53:33 GMT; Max-Age=7200; path=/; httponly; samesite=laxrouvana_session=eyJpdiI6InBwY2ZtU09aU3pSQjlGNHBrVHRmRGc9PSIsInZhbHVlIjoiek1uait5MUlPVmJOYTZ4UGdQU3RoWnFlVThQNUxkYWdXM0tmQU1ZZVpyd2E5MHk0aHhpdjdnd1plZUZXTTErcno0" ] "Set-Cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6IlJ4Ylg0RDdua3pUd1RYNFE3eTN5Wnc9PSIsInZhbHVlIjoidjVOaGN5czZudnhtc2FkQU1oMHFiZmhIVWlMeVFMWFJhUWUzVXR6Q28rNE80MHJ1WWtXaU1jZXRhdE9tOU5sOFVHVXFCNm9QU0ZTeDh6NzY4ejhIK1RYV1ZtWENnbldLZG9mNlQyNHdXT3JIZFRWRGoxdmhXNW9IbXR2NWhYREIiLCJtYWMiOiI2NzBiYjAzNGYzM2RmYWM3MGYzOWM2OWMwM2E3MmU2ZGIwZjRjZjZiNTgyMmM1MWVlYTQ0NTg3NjM4OTA5OGFkIiwidGFnIjoiIn0%3D; expires=Fri, 25-Apr-2025 16:53:33 GMT; path=/XSRF-TOKEN=eyJpdiI6IlJ4Ylg0RDdua3pUd1RYNFE3eTN5Wnc9PSIsInZhbHVlIjoidjVOaGN5czZudnhtc2FkQU1oMHFiZmhIVWlMeVFMWFJhUWUzVXR6Q28rNE80MHJ1WWtXaU1jZXRhdE9tOU5sOFVHVXFCN" 1 => "rouvana_session=eyJpdiI6InBwY2ZtU09aU3pSQjlGNHBrVHRmRGc9PSIsInZhbHVlIjoiek1uait5MUlPVmJOYTZ4UGdQU3RoWnFlVThQNUxkYWdXM0tmQU1ZZVpyd2E5MHk0aHhpdjdnd1plZUZXTTErcno0clQ1UThsWTRHdVB0S00xVHlzZnZQNmN5YXlSbDVuMGJrSi96aGNhMGZkZzJKbGEzdHRLM2FJaWpVWXF1b1QiLCJtYWMiOiI2ZjlmZWUyZDI0ZDY4YWRjZDY4NmY3NTI4MDg0YTBkMjczOTc1MGFlYjk4NGI1ZmZkNTIwMDM3MWQzZTJhZTY0IiwidGFnIjoiIn0%3D; expires=Fri, 25-Apr-2025 16:53:33 GMT; path=/; httponlyrouvana_session=eyJpdiI6InBwY2ZtU09aU3pSQjlGNHBrVHRmRGc9PSIsInZhbHVlIjoiek1uait5MUlPVmJOYTZ4UGdQU3RoWnFlVThQNUxkYWdXM0tmQU1ZZVpyd2E5MHk0aHhpdjdnd1plZUZXTTErcno0" ] ]
        session_attributes
        0 of 0
        array:5 [ "_token" => "kBN5pGsw8eKMA2xs7spbklhiVpiAcAfUEUWnmrdd" "bc_current_currency" => "usd" "_previous" => array:1 [ "url" => "https://rouvanab2b.com/hotel/landmark-hotel-riqqa-deira-dubai" ] "_flash" => array:2 [ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]