Rouvana Tours
Rouvana Tours
>
United Arab Emiratis
United Arab Emiratis

United Arab Emiratis

Explore deals, travel guides and things to do in United Arab Emiratis

What to know before visiting United Arab Emiratis

The United Arab Emirates, or simply the Emirates, is a country in West Asia, in the Middle East. Located at the eastern end of the Arabian Peninsula, it shares borders with Oman and Saudi Arabia; as well as maritime borders in the Arbic Gulf with Qatar and Iran.

Most Popular Hotel

Interdum et malesuada fames ac ante ipsum

Landmark Grand Hotel

United Arab Emiratis

0
Not rated
0 Review
Starting from
220 AED

Most Popular Activities

Interdum et malesuada fames ac ante ipsum

Guided Inside Burj Al Arab Tour
Featured
Start Time: 10:00am-6:30pm - 1 Hour

Guided Inside Burj Al Arab Tour

United Arab Emiratis

0 Review
from 249 AED

Your Travel Journey Starts Here

Sign up and we'll send the best deals to you
8.1.32PHP Version184msRequest Duration6MBMemory UsageGET location/{slug}RouteAuth status
    • Booting (70.19ms)
    • Application (113ms)
    • 1 x Application (61.71%)
      113.31ms
      1 x Booting (38.23%)
      70.19ms
      30 templates were rendered
      • Location::frontend.detail (themes/GoTrip/Location/Views/frontend/detail.blade.php)4blade
        Params
        0
        row
        1
        translation
        2
        seo_meta
        3
        breadcrumbs
      • Location::frontend.layouts.details.location-banner (themes/GoTrip/Location/Views/frontend/layouts/details/location-banner.blade.php)7blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        row
        4
        translation
        5
        seo_meta
        6
        breadcrumbs
      • Location::frontend.layouts.details.location-overview (themes/GoTrip/Location/Views/frontend/layouts/details/location-overview.blade.php)7blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        row
        4
        translation
        5
        seo_meta
        6
        breadcrumbs
      • Location::frontend.layouts.details.location-general-info (themes/GoTrip/Location/Views/frontend/layouts/details/location-general-info.blade.php)7blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        row
        4
        translation
        5
        seo_meta
        6
        breadcrumbs
      • Location::frontend.layouts.details.location-map (themes/GoTrip/Location/Views/frontend/layouts/details/location-map.blade.php)7blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        row
        4
        translation
        5
        seo_meta
        6
        breadcrumbs
      • Location::frontend.layouts.details.location-service (themes/GoTrip/Location/Views/frontend/layouts/details/location-service.blade.php)7blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        row
        4
        translation
        5
        seo_meta
        6
        breadcrumbs
      • Hotel::frontend.layouts.search.loop-grid (themes/GoTrip/Hotel/Views/frontend/layouts/search/loop-grid.blade.php)18blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        row
        4
        translation
        5
        seo_meta
        6
        breadcrumbs
        7
        types
        8
        i
        9
        not_in
        10
        __currentLoopData
        11
        moduleClass
        12
        type
        13
        loop
        14
        moduleInst
        15
        services
        16
        service
        17
        view
      • Event::frontend.layouts.search.loop-grid (themes/GoTrip/Event/Views/frontend/layouts/search/loop-grid.blade.php)18blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        row
        4
        translation
        5
        seo_meta
        6
        breadcrumbs
        7
        types
        8
        i
        9
        not_in
        10
        __currentLoopData
        11
        moduleClass
        12
        type
        13
        loop
        14
        moduleInst
        15
        services
        16
        service
        17
        view
      • Layout::common.rating (themes/GoTrip/Layout/common/rating.blade.php)23blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        row
        4
        translation
        5
        seo_meta
        6
        breadcrumbs
        7
        types
        8
        i
        9
        not_in
        10
        __currentLoopData
        11
        moduleClass
        12
        type
        13
        loop
        14
        moduleInst
        15
        services
        16
        service
        17
        view
        18
        layout_style
        19
        time
        20
        location
        21
        reviewData
        22
        score_total
      • Location::frontend.layouts.details.location-trip-idea (themes/GoTrip/Location/Views/frontend/layouts/details/location-trip-idea.blade.php)7blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        row
        4
        translation
        5
        seo_meta
        6
        breadcrumbs
      • layouts.app (resources/views/layouts/app.blade.php)7blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        row
        4
        translation
        5
        seo_meta
        6
        breadcrumbs
      • Layout::app (themes/GoTrip/Layout/app.blade.php)7blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        row
        4
        translation
        5
        seo_meta
        6
        breadcrumbs
      • Layout::parts.seo-meta (modules/Layout/parts/seo-meta.blade.php)9blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        row
        4
        translation
        5
        seo_meta
        6
        breadcrumbs
        7
        favicon
        8
        file
      • Layout::parts.global-script (modules/Layout/parts/global-script.blade.php)9blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        row
        4
        translation
        5
        seo_meta
        6
        breadcrumbs
        7
        favicon
        8
        file
      • Layout::parts.preload (themes/GoTrip/Layout/parts/preload.blade.php)10blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        row
        4
        translation
        5
        seo_meta
        6
        breadcrumbs
        7
        favicon
        8
        file
        9
        hideHeaderMargin
      • Layout::parts.header (themes/GoTrip/Layout/parts/header.blade.php)10blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        row
        4
        translation
        5
        seo_meta
        6
        breadcrumbs
        7
        favicon
        8
        file
        9
        hideHeaderMargin
      • Layout::parts.header-style.normal (themes/GoTrip/Layout/parts/header-style/normal.blade.php)16blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        row
        4
        translation
        5
        seo_meta
        6
        breadcrumbs
        7
        favicon
        8
        file
        9
        hideHeaderMargin
        10
        headerStyle
        11
        dataBg
        12
        navTextStyle
        13
        headerClass
        14
        logo
        15
        logoDark
      • Core::frontend.currency-switcher (themes/GoTrip/Core/Views/frontend/currency-switcher.blade.php)17blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        row
        4
        translation
        5
        seo_meta
        6
        breadcrumbs
        7
        favicon
        8
        file
        9
        hideHeaderMargin
        10
        headerStyle
        11
        dataBg
        12
        navTextStyle
        13
        headerClass
        14
        logo
        15
        logoDark
        16
        textColor
      • Language::frontend.switcher-dropdown (themes/GoTrip/Language/Views/frontend/switcher-dropdown.blade.php)17blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        row
        4
        translation
        5
        seo_meta
        6
        breadcrumbs
        7
        favicon
        8
        file
        9
        hideHeaderMargin
        10
        headerStyle
        11
        dataBg
        12
        navTextStyle
        13
        headerClass
        14
        logo
        15
        logoDark
        16
        textColor
      • Core::frontend.currency-switcher (themes/GoTrip/Core/Views/frontend/currency-switcher.blade.php)16blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        row
        4
        translation
        5
        seo_meta
        6
        breadcrumbs
        7
        favicon
        8
        file
        9
        hideHeaderMargin
        10
        headerStyle
        11
        dataBg
        12
        navTextStyle
        13
        headerClass
        14
        logo
        15
        logoDark
      • Language::frontend.switcher-dropdown (themes/GoTrip/Language/Views/frontend/switcher-dropdown.blade.php)16blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        row
        4
        translation
        5
        seo_meta
        6
        breadcrumbs
        7
        favicon
        8
        file
        9
        hideHeaderMargin
        10
        headerStyle
        11
        dataBg
        12
        navTextStyle
        13
        headerClass
        14
        logo
        15
        logoDark
      • Layout::parts.footer (themes/GoTrip/Layout/parts/footer.blade.php)10blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        row
        4
        translation
        5
        seo_meta
        6
        breadcrumbs
        7
        favicon
        8
        file
        9
        hideHeaderMargin
      • Layout::parts.footer-style.index (themes/GoTrip/Layout/parts/footer-style/index.blade.php)13blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        row
        4
        translation
        5
        seo_meta
        6
        breadcrumbs
        7
        favicon
        8
        file
        9
        hideHeaderMargin
        10
        footerStyle
        11
        mailchimp_classes
        12
        button_classes
      • Layout::parts.footer-style.normal (themes/GoTrip/Layout/parts/footer-style/normal.blade.php)14blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        row
        4
        translation
        5
        seo_meta
        6
        breadcrumbs
        7
        favicon
        8
        file
        9
        hideHeaderMargin
        10
        footerStyle
        11
        mailchimp_classes
        12
        button_classes
        13
        footer_classes
      • Core::frontend.currency-switcher (themes/GoTrip/Core/Views/frontend/currency-switcher.blade.php)14blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        row
        4
        translation
        5
        seo_meta
        6
        breadcrumbs
        7
        favicon
        8
        file
        9
        hideHeaderMargin
        10
        footerStyle
        11
        mailchimp_classes
        12
        button_classes
        13
        footer_classes
      • Language::frontend.switcher-dropdown (themes/GoTrip/Language/Views/frontend/switcher-dropdown.blade.php)14blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        row
        4
        translation
        5
        seo_meta
        6
        breadcrumbs
        7
        favicon
        8
        file
        9
        hideHeaderMargin
        10
        footerStyle
        11
        mailchimp_classes
        12
        button_classes
        13
        footer_classes
      • Layout::parts.login-register-modal (themes/GoTrip/Layout/parts/login-register-modal.blade.php)13blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        row
        4
        translation
        5
        seo_meta
        6
        breadcrumbs
        7
        favicon
        8
        file
        9
        hideHeaderMargin
        10
        footerStyle
        11
        mailchimp_classes
        12
        button_classes
      • Layout::auth.login-form (themes/GoTrip/Layout/auth/login-form.blade.php)13blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        row
        4
        translation
        5
        seo_meta
        6
        breadcrumbs
        7
        favicon
        8
        file
        9
        hideHeaderMargin
        10
        footerStyle
        11
        mailchimp_classes
        12
        button_classes
      • Layout::auth.register-form (themes/GoTrip/Layout/auth/register-form.blade.php)13blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        row
        4
        translation
        5
        seo_meta
        6
        breadcrumbs
        7
        favicon
        8
        file
        9
        hideHeaderMargin
        10
        footerStyle
        11
        mailchimp_classes
        12
        button_classes
      • Popup::frontend.popup (themes/GoTrip/Popup/Views/frontend/popup.blade.php)13blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        row
        4
        translation
        5
        seo_meta
        6
        breadcrumbs
        7
        favicon
        8
        file
        9
        hideHeaderMargin
        10
        footerStyle
        11
        mailchimp_classes
        12
        button_classes
      uri
      GET location/{slug}
      middleware
      web
      controller
      Modules\Location\Controllers\LocationController@detail
      namespace
      Modules\Location\Controllers
      prefix
      /location
      where
      as
      location.detail
      file
      modules/Location/Controllers/LocationController.php:21-41
      17 statements were executed, 4 of which were duplicated, 13 unique22.11ms
      • select * from `bravo_locations` where `slug` = 'united-arab-emiratis' and `status` = 'publish' and `bravo_locations`.`deleted_at` is null limit 114.19ms/modules/Location/Controllers/LocationController.php:23u479693165_rouvfbqk_travi
        Metadata
        Bindings
        • 0. united-arab-emiratis
        • 1. publish
        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/Location/Controllers/LocationController.php:23
        • 16. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
        • 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
        • 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
      • select * from `bravo_location_translations` where `bravo_location_translations`.`origin_id` = 14 and `bravo_location_translations`.`origin_id` is not null and `locale` = 'en' limit 1710μs/app/Traits/HasTranslations.php:51u479693165_rouvfbqk_travi
        Metadata
        Bindings
        • 0. 14
        • 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. /modules/Location/Controllers/LocationController.php:27
        • 22. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 23. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
        • 24. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
      • select * from `bravo_seo` where `object_id` = 14 and `object_model` = 'location' limit 1490μs/app/BaseModel.php:199u479693165_rouvfbqk_travi
        Metadata
        Bindings
        • 0. 14
        • 1. location
        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/Location/Controllers/LocationController.php:31
        • 18. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 19. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • select `bravo_hotels`.* from `bravo_hotels` inner join `bravo_locations` on `bravo_locations`.`id` = `bravo_hotels`.`location_id` and `bravo_locations`.`_lft` >= 27 and `bravo_locations`.`_rgt` <= 28 where `bravo_hotels`.`status` = 'publish' and `bravo_hotels`.`deleted_at` is null limit 8550μsview::65c8712ee31c488e1ee5933c91343d03dfeefd23:14u479693165_rouvfbqk_travi
        Metadata
        Bindings
        • 0. 27
        • 1. 28
        • 2. publish
        Hints
        • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
        Backtrace
        • 14. view::65c8712ee31c488e1ee5933c91343d03dfeefd23:14
        • 16. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
        • 17. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
        • 19. /vendor/laravel/framework/src/Illuminate/View/View.php:152
      • select * from `bravo_locations` where `bravo_locations`.`id` in (14) and `bravo_locations`.`deleted_at` is null310μsview::65c8712ee31c488e1ee5933c91343d03dfeefd23:14u479693165_rouvfbqk_travi
        Metadata
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 19. view::65c8712ee31c488e1ee5933c91343d03dfeefd23:14
        • 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_location_translations` where `locale` = 'en' and `bravo_location_translations`.`origin_id` in (14)280μsview::65c8712ee31c488e1ee5933c91343d03dfeefd23:14u479693165_rouvfbqk_travi
        Metadata
        Bindings
        • 0. en
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 24. view::65c8712ee31c488e1ee5933c91343d03dfeefd23:14
        • 26. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
        • 27. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 28. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
        • 29. /vendor/laravel/framework/src/Illuminate/View/View.php:152
      • select * from `bravo_hotel_translations` where `bravo_hotel_translations`.`origin_id` = 388 and `bravo_hotel_translations`.`origin_id` is not null and `locale` = 'en' and `bravo_hotel_translations`.`deleted_at` is null limit 1370μs/app/Traits/HasTranslations.php:51u479693165_rouvfbqk_travi
        Metadata
        Bindings
        • 0. 388
        • 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::72edb21de714c4b9625dce69907ad1382cc07b3f:2
        • 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 `bravo_cars`.* from `bravo_cars` inner join `bravo_locations` on `bravo_locations`.`id` = `bravo_cars`.`location_id` and `bravo_locations`.`_lft` >= 27 and `bravo_locations`.`_rgt` <= 28 where `bravo_cars`.`status` = 'publish' and `bravo_cars`.`deleted_at` is null limit 8880μsview::65c8712ee31c488e1ee5933c91343d03dfeefd23:14u479693165_rouvfbqk_travi
        Metadata
        Bindings
        • 0. 27
        • 1. 28
        • 2. publish
        Hints
        • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
        Backtrace
        • 14. view::65c8712ee31c488e1ee5933c91343d03dfeefd23:14
        • 16. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
        • 17. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
        • 19. /vendor/laravel/framework/src/Illuminate/View/View.php:152
      • select `bravo_events`.* from `bravo_events` inner join `bravo_locations` on `bravo_locations`.`id` = `bravo_events`.`location_id` and `bravo_locations`.`_lft` >= 27 and `bravo_locations`.`_rgt` <= 28 where `bravo_events`.`status` = 'publish' and `bravo_events`.`deleted_at` is null limit 8810μsview::65c8712ee31c488e1ee5933c91343d03dfeefd23:14u479693165_rouvfbqk_travi
        Metadata
        Bindings
        • 0. 27
        • 1. 28
        • 2. publish
        Hints
        • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
        Backtrace
        • 14. view::65c8712ee31c488e1ee5933c91343d03dfeefd23:14
        • 16. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
        • 17. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
        • 19. /vendor/laravel/framework/src/Illuminate/View/View.php:152
      • select * from `bravo_locations` where `bravo_locations`.`id` in (14) and `bravo_locations`.`deleted_at` is null230μsview::65c8712ee31c488e1ee5933c91343d03dfeefd23:14u479693165_rouvfbqk_travi
        Metadata
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 19. view::65c8712ee31c488e1ee5933c91343d03dfeefd23:14
        • 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_location_translations` where `locale` = 'en' and `bravo_location_translations`.`origin_id` in (14)260μsview::65c8712ee31c488e1ee5933c91343d03dfeefd23:14u479693165_rouvfbqk_travi
        Metadata
        Bindings
        • 0. en
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 24. view::65c8712ee31c488e1ee5933c91343d03dfeefd23:14
        • 26. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
        • 27. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 28. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
        • 29. /vendor/laravel/framework/src/Illuminate/View/View.php:152
      • select * from `bravo_event_translations` where `bravo_event_translations`.`origin_id` = 119 and `bravo_event_translations`.`origin_id` is not null and `locale` = 'en' and `bravo_event_translations`.`deleted_at` is null limit 1500μs/app/Traits/HasTranslations.php:51u479693165_rouvfbqk_travi
        Metadata
        Bindings
        • 0. 119
        • 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::f562777a69c1f7f998e48a881fb97a65a51ee6be:2
        • 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 `bravo_tours`.* from `bravo_tours` inner join `bravo_locations` on `bravo_locations`.`id` = `bravo_tours`.`location_id` and `bravo_locations`.`_lft` >= 27 and `bravo_locations`.`_rgt` <= 28 where `bravo_tours`.`status` = 'publish' and `bravo_tours`.`deleted_at` is null limit 8850μsview::65c8712ee31c488e1ee5933c91343d03dfeefd23:14u479693165_rouvfbqk_travi
        Metadata
        Bindings
        • 0. 27
        • 1. 28
        • 2. publish
        Hints
        • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
        Backtrace
        • 14. view::65c8712ee31c488e1ee5933c91343d03dfeefd23:14
        • 16. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
        • 17. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
        • 19. /vendor/laravel/framework/src/Illuminate/View/View.php:152
      • select `bravo_boats`.* from `bravo_boats` inner join `bravo_locations` on `bravo_locations`.`id` = `bravo_boats`.`location_id` and `bravo_locations`.`_lft` >= 27 and `bravo_locations`.`_rgt` <= 28 where `bravo_boats`.`status` = 'publish' and `bravo_boats`.`deleted_at` is null limit 8430μsview::65c8712ee31c488e1ee5933c91343d03dfeefd23:14u479693165_rouvfbqk_travi
        Metadata
        Bindings
        • 0. 27
        • 1. 28
        • 2. publish
        Hints
        • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
        Backtrace
        • 14. view::65c8712ee31c488e1ee5933c91343d03dfeefd23:14
        • 16. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
        • 17. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
        • 19. /vendor/laravel/framework/src/Illuminate/View/View.php:152
      • 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 1420μs/app/Traits/HasTranslations.php:51u479693165_rouvfbqk_travi
        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 1380μs/app/Helpers/AppHelper.php:627u479693165_rouvfbqk_travi
        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
      • 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 1450μs/app/Traits/HasTranslations.php:51u479693165_rouvfbqk_travi
        Metadata
        Bindings
        • 0. 1
        • 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::4978f7386665a7ff4af1fc53447fbe93012820c7:4
        • 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
      Modules\Popup\Models\PopupTranslation
      1
      Modules\Page\Models\Page
      1
      Modules\Core\Models\MenuTranslation
      1
      Modules\Event\Models\EventTranslation
      1
      Modules\Event\Models\Event
      1
      Modules\Hotel\Models\HotelTranslation
      1
      Modules\Location\Models\LocationTranslation
      2
      Modules\Location\Models\Location
      2
      Modules\Hotel\Models\Hotel
      1
      Modules\Core\Models\SEO
      1
      Themes\GoTrip\Location\Models\LocationTranslation
      1
      Themes\GoTrip\Location\Models\Location
      1
      web
      null
      sanctum
      null
        _token
        CdMJFE77vl6Wf2YN7WAJwTYJ1vpKLAoHPleeA3jI
        _previous
        array:1 [ "url" => "https://rouvana.com/location/united-arab-emiratis" ]
        _flash
        array:2 [ "old" => [] "new" => [] ]
        PHPDEBUGBAR_STACK_DATA
        []
        path_info
        /location/united-arab-emiratis
        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: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 => "3.21.41.164" ] "x-forwarded-proto" => array:1 [ 0 => "https" ] "x-real-ip" => array:1 [ 0 => "3.21.41.164" ] "x-real-port" => array:1 [ 0 => "50898" ] "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: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" => "3.21.41.164" "HTTP_X_FORWARDED_PROTO" => "https" "HTTP_X_REAL_IP" => "3.21.41.164" "HTTP_X_REAL_PORT" => "50898" "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" => "3.21.41.164" "REMOTE_PORT" => "44194" "SERVER_ADDR" => "2a02:4780:11:1654:0:1c97:896d:3" "SERVER_NAME" => "rouvana.com" "SERVER_ADMIN" => "" "SERVER_PORT" => "443" "REQUEST_SCHEME" => "https" "REQUEST_URI" => "/location/united-arab-emiratis" "REDIRECT_URL" => "/public/location/united-arab-emiratis" "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/location/united-arab-emiratis" "SCRIPT_URL" => "/location/united-arab-emiratis" "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" => 1744035983.5847 "REQUEST_TIME" => 1744035983 ]
        request_cookies
        []
        
        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 => "Mon, 07 Apr 2025 14:26:23 GMT" ] "set-cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6Ijh6WkRIYlEzQW9pWGVOWVVzVm04V1E9PSIsInZhbHVlIjoiN1BEV1AyWkJ4a3dVdTlRNFp2WldpV1FaSHlQNXB6VEtnbXFRVlVYemhJMUE5UHh3ekN5NEMycDN4SWJoelJ5NUdxT0NydmRzRHVhT0Rqc001K0VMRFpDblhwUThha3Yzekh5MCtlVG5wclNaZ2N1YnFMdWpyRlhCa29BWXJwTkUiLCJtYWMiOiI0OWYyYzgwZThmMTg3ZWZiMjk4NzEyM2IxYTEyZWRlOWZhZDM3ZTdmMmRjNGUxNGViOWNhYzQxMjMyYTUwNDNhIiwidGFnIjoiIn0%3D; expires=Mon, 07-Apr-2025 16:26:23 GMT; Max-Age=7200; path=/; samesite=laxXSRF-TOKEN=eyJpdiI6Ijh6WkRIYlEzQW9pWGVOWVVzVm04V1E9PSIsInZhbHVlIjoiN1BEV1AyWkJ4a3dVdTlRNFp2WldpV1FaSHlQNXB6VEtnbXFRVlVYemhJMUE5UHh3ekN5NEMycDN4SWJoelJ5NUdxT0Nyd" 1 => "rouvana_session=eyJpdiI6IkNDSjg4T3l1bG9zdHhiTzN1U2pkcEE9PSIsInZhbHVlIjoiallWUldQSkMwT1BXZE5NV3FZcXVYb2k0Zk1Ld0Q1L0JlcXZaU3ZFVVcwSUtQcWhCVWk1Nkt0bjZKRzJEaHdZYWpsS3BiTWNXalVxcytiRXd1VGNZM09acytiK0lzWnJ5VEVVQXJEbm10R2V4UWpvd2VnaXFUUmRLd29keVZIa2ciLCJtYWMiOiJhMTAwYmUyNDMyMmU4YTVmZGQyNDdlMDRmOTc4ZjcwYjMzZmMxZjYyMjM3ODcyNzM0ZmRiM2IyMTk2Nzk3NDM4IiwidGFnIjoiIn0%3D; expires=Mon, 07-Apr-2025 16:26:23 GMT; Max-Age=7200; path=/; httponly; samesite=laxrouvana_session=eyJpdiI6IkNDSjg4T3l1bG9zdHhiTzN1U2pkcEE9PSIsInZhbHVlIjoiallWUldQSkMwT1BXZE5NV3FZcXVYb2k0Zk1Ld0Q1L0JlcXZaU3ZFVVcwSUtQcWhCVWk1Nkt0bjZKRzJEaHdZYWps" ] "Set-Cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6Ijh6WkRIYlEzQW9pWGVOWVVzVm04V1E9PSIsInZhbHVlIjoiN1BEV1AyWkJ4a3dVdTlRNFp2WldpV1FaSHlQNXB6VEtnbXFRVlVYemhJMUE5UHh3ekN5NEMycDN4SWJoelJ5NUdxT0NydmRzRHVhT0Rqc001K0VMRFpDblhwUThha3Yzekh5MCtlVG5wclNaZ2N1YnFMdWpyRlhCa29BWXJwTkUiLCJtYWMiOiI0OWYyYzgwZThmMTg3ZWZiMjk4NzEyM2IxYTEyZWRlOWZhZDM3ZTdmMmRjNGUxNGViOWNhYzQxMjMyYTUwNDNhIiwidGFnIjoiIn0%3D; expires=Mon, 07-Apr-2025 16:26:23 GMT; path=/XSRF-TOKEN=eyJpdiI6Ijh6WkRIYlEzQW9pWGVOWVVzVm04V1E9PSIsInZhbHVlIjoiN1BEV1AyWkJ4a3dVdTlRNFp2WldpV1FaSHlQNXB6VEtnbXFRVlVYemhJMUE5UHh3ekN5NEMycDN4SWJoelJ5NUdxT0Nyd" 1 => "rouvana_session=eyJpdiI6IkNDSjg4T3l1bG9zdHhiTzN1U2pkcEE9PSIsInZhbHVlIjoiallWUldQSkMwT1BXZE5NV3FZcXVYb2k0Zk1Ld0Q1L0JlcXZaU3ZFVVcwSUtQcWhCVWk1Nkt0bjZKRzJEaHdZYWpsS3BiTWNXalVxcytiRXd1VGNZM09acytiK0lzWnJ5VEVVQXJEbm10R2V4UWpvd2VnaXFUUmRLd29keVZIa2ciLCJtYWMiOiJhMTAwYmUyNDMyMmU4YTVmZGQyNDdlMDRmOTc4ZjcwYjMzZmMxZjYyMjM3ODcyNzM0ZmRiM2IyMTk2Nzk3NDM4IiwidGFnIjoiIn0%3D; expires=Mon, 07-Apr-2025 16:26:23 GMT; path=/; httponlyrouvana_session=eyJpdiI6IkNDSjg4T3l1bG9zdHhiTzN1U2pkcEE9PSIsInZhbHVlIjoiallWUldQSkMwT1BXZE5NV3FZcXVYb2k0Zk1Ld0Q1L0JlcXZaU3ZFVVcwSUtQcWhCVWk1Nkt0bjZKRzJEaHdZYWps" ] ]
        session_attributes
        0 of 0
        array:4 [ "_token" => "CdMJFE77vl6Wf2YN7WAJwTYJ1vpKLAoHPleeA3jI" "_previous" => array:1 [ "url" => "https://rouvana.com/location/united-arab-emiratis" ] "_flash" => array:2 [ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]