Rouvana Tours
Rouvana Tours
>
Ras Al-Khaimah - United Arab Emirates
Ras Al-Khaimah - United Arab Emirates

Ras Al-Khaimah - United Arab Emirates

Explore deals, travel guides and things to do in Ras Al-Khaimah - United Arab Emirates

What to know before visiting Ras Al-Khaimah - United Arab Emirates

Ras Al Khaimah, often referred to its initials RAK and historically known as Julfar, is the largest city and capital of the Emirate of Ras Al Khaimah in the United Arab Emirates. The city had a population of 191,753 in 2022, and is the sixth-most populous city in UAE after Dubai, Abu Dhabi, Sharjah, Al Ain and Ajman.

Location Map

Interdum et malesuada fames ac ante ipsum

Leaflet | © OpenStreetMap contributors

Most Popular Activities

Interdum et malesuada fames ac ante ipsum

Desert Safari Ras Al Khaimah
Sale off 1%
Start Time: 2:30- 9:00pm - 9 Hours

Desert Safari Ras Al Khaimah

Ras Al-Khaimah - United Arab Emirates

0 Review
from 265 AED 260 AED
Yellow Boat Ras Al Khaimah
Sale off 3%
Start Time: 9:30 -

Yellow Boat Ras Al Khaimah

Ras Al-Khaimah - United Arab Emirates

0 Review
from 156 AED 150 AED
Dubai Fountain Show Lake ride from Ras Al Khaimah
Sale off 2%
Start Time: 5:45-11:30pm - 7 Hours

Dubai Fountain Show Lake ride from Ras Al Khaimah

Ras Al-Khaimah - United Arab Emirates

0 Review
from 72 AED 70 AED
Jebel Jais Zipline
Sale off 2%
Start Time: 9:30AM -

Jebel Jais Zipline

Ras Al-Khaimah - United Arab Emirates

0 Review
from 450 AED 440 AED
Dinner in Desert Ras Al Khaimah
Sale off 7%
Start Time: 5:30 pm-9:30 pm - 5 Hours

Dinner in Desert Ras Al Khaimah

Ras Al-Khaimah - United Arab Emirates

0 Review
from 141 AED 131 AED

Your Travel Journey Starts Here

Sign up and we'll send the best deals to you
8.1.32PHP Version219msRequest Duration7MBMemory UsageGET location/{slug}RouteAuth status
    • Booting (66.18ms)
    • Application (152ms)
    • 1 x Application (69.69%)
      152.38ms
      1 x Booting (30.27%)
      66.18ms
      37 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
      • 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
      • 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
      • 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
      • 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
      • 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
      18 statements were executed29.18ms
      • select * from `bravo_locations` where `slug` = 'ras-al-khaimah' and `status` = 'publish' and `bravo_locations`.`deleted_at` is null limit 17.11ms/modules/Location/Controllers/LocationController.php:23u479693165_rouvfbqk_travi
        Metadata
        Bindings
        • 0. ras-al-khaimah
        • 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` = 17 and `bravo_location_translations`.`origin_id` is not null and `locale` = 'en' limit 11.1ms/app/Traits/HasTranslations.php:51u479693165_rouvfbqk_travi
        Metadata
        Bindings
        • 0. 17
        • 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` = 17 and `object_model` = 'location' limit 11.02ms/app/BaseModel.php:199u479693165_rouvfbqk_travi
        Metadata
        Bindings
        • 0. 17
        • 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` >= 33 and `bravo_locations`.`_rgt` <= 34 where `bravo_hotels`.`status` = 'publish' and `bravo_hotels`.`deleted_at` is null limit 8620μsview::65c8712ee31c488e1ee5933c91343d03dfeefd23:14u479693165_rouvfbqk_travi
        Metadata
        Bindings
        • 0. 33
        • 1. 34
        • 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_cars`.* from `bravo_cars` inner join `bravo_locations` on `bravo_locations`.`id` = `bravo_cars`.`location_id` and `bravo_locations`.`_lft` >= 33 and `bravo_locations`.`_rgt` <= 34 where `bravo_cars`.`status` = 'publish' and `bravo_cars`.`deleted_at` is null limit 8660μsview::65c8712ee31c488e1ee5933c91343d03dfeefd23:14u479693165_rouvfbqk_travi
        Metadata
        Bindings
        • 0. 33
        • 1. 34
        • 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` >= 33 and `bravo_locations`.`_rgt` <= 34 where `bravo_events`.`status` = 'publish' and `bravo_events`.`deleted_at` is null limit 81.07msview::65c8712ee31c488e1ee5933c91343d03dfeefd23:14u479693165_rouvfbqk_travi
        Metadata
        Bindings
        • 0. 33
        • 1. 34
        • 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 (17) and `bravo_locations`.`deleted_at` is null480μ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 (17)870μ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` = 109 and `bravo_event_translations`.`origin_id` is not null and `locale` = 'en' and `bravo_event_translations`.`deleted_at` is null limit 1430μs/app/Traits/HasTranslations.php:51u479693165_rouvfbqk_travi
        Metadata
        Bindings
        • 0. 109
        • 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 * from `bravo_event_translations` where `bravo_event_translations`.`origin_id` = 110 and `bravo_event_translations`.`origin_id` is not null and `locale` = 'en' and `bravo_event_translations`.`deleted_at` is null limit 1370μs/app/Traits/HasTranslations.php:51u479693165_rouvfbqk_travi
        Metadata
        Bindings
        • 0. 110
        • 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 * from `bravo_event_translations` where `bravo_event_translations`.`origin_id` = 111 and `bravo_event_translations`.`origin_id` is not null and `locale` = 'en' and `bravo_event_translations`.`deleted_at` is null limit 1370μs/app/Traits/HasTranslations.php:51u479693165_rouvfbqk_travi
        Metadata
        Bindings
        • 0. 111
        • 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 * from `bravo_event_translations` where `bravo_event_translations`.`origin_id` = 112 and `bravo_event_translations`.`origin_id` is not null and `locale` = 'en' and `bravo_event_translations`.`deleted_at` is null limit 1670μs/app/Traits/HasTranslations.php:51u479693165_rouvfbqk_travi
        Metadata
        Bindings
        • 0. 112
        • 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 * from `bravo_event_translations` where `bravo_event_translations`.`origin_id` = 116 and `bravo_event_translations`.`origin_id` is not null and `locale` = 'en' and `bravo_event_translations`.`deleted_at` is null limit 1320μs/app/Traits/HasTranslations.php:51u479693165_rouvfbqk_travi
        Metadata
        Bindings
        • 0. 116
        • 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` >= 33 and `bravo_locations`.`_rgt` <= 34 where `bravo_tours`.`status` = 'publish' and `bravo_tours`.`deleted_at` is null limit 84.26msview::65c8712ee31c488e1ee5933c91343d03dfeefd23:14u479693165_rouvfbqk_travi
        Metadata
        Bindings
        • 0. 33
        • 1. 34
        • 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` >= 33 and `bravo_locations`.`_rgt` <= 34 where `bravo_boats`.`status` = 'publish' and `bravo_boats`.`deleted_at` is null limit 82.03msview::65c8712ee31c488e1ee5933c91343d03dfeefd23:14u479693165_rouvfbqk_travi
        Metadata
        Bindings
        • 0. 33
        • 1. 34
        • 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 16.72ms/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 1570μ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 1510μ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
      5
      Modules\Location\Models\LocationTranslation
      1
      Modules\Location\Models\Location
      1
      Modules\Event\Models\Event
      5
      Modules\Core\Models\SEO
      1
      Themes\GoTrip\Location\Models\LocationTranslation
      1
      Themes\GoTrip\Location\Models\Location
      1
      web
      null
      sanctum
      null
        _token
        H8dnTwlIX5gYgQPk16o31qvCnvCZ3RtZRsnlevE1
        _previous
        array:1 [ "url" => "https://rouvana.com/location/ras-al-khaimah" ]
        _flash
        array:2 [ "old" => [] "new" => [] ]
        PHPDEBUGBAR_STACK_DATA
        []
        path_info
        /location/ras-al-khaimah
        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 => "18.224.15.154" ] "x-forwarded-proto" => array:1 [ 0 => "https" ] "x-real-ip" => array:1 [ 0 => "18.224.15.154" ] "x-real-port" => array:1 [ 0 => "18750" ] "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" => "18.224.15.154" "HTTP_X_FORWARDED_PROTO" => "https" "HTTP_X_REAL_IP" => "18.224.15.154" "HTTP_X_REAL_PORT" => "18750" "HTTP_X_FORWARDED_PORT" => "443" "HTTP_X_PORT" => "443" "HTTP_X_LSCACHE" => "1" "HTTP_SEC_CH_UA" => ""HeadlessChrome";v="129", "Not=A?Brand";v="8", "Chromium";v="129"" "HTTP_SEC_CH_UA_MOBILE" => "?0" "HTTP_SEC_CH_UA_PLATFORM" => ""Windows"" "HTTP_UPGRADE_INSECURE_REQUESTS" => "1" "HTTP_SEC_FETCH_SITE" => "none" "HTTP_SEC_FETCH_MODE" => "navigate" "HTTP_SEC_FETCH_USER" => "?1" "HTTP_SEC_FETCH_DEST" => "document" "HTTP_PRIORITY" => "u=0, i" "DOCUMENT_ROOT" => "/home/u479693165/domains/rouvana.com/public_html" "REMOTE_ADDR" => "18.224.15.154" "REMOTE_PORT" => "40530" "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/ras-al-khaimah" "REDIRECT_URL" => "/public/location/ras-al-khaimah" "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/ras-al-khaimah" "SCRIPT_URL" => "/location/ras-al-khaimah" "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" => 1743932411.8598 "REQUEST_TIME" => 1743932411 ]
        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 => "Sun, 06 Apr 2025 09:40:11 GMT" ] "set-cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6IksrRm41eFdHMlVvdlA4UitPRWJjZXc9PSIsInZhbHVlIjoiOFRiQzRTQjZHT2wyOVQzOWwxT0dVOW9kN2FramNIczJLK1VBc1NOcUZiaDl3UVBGaVBwcWwzWkFoVnR3NlVNRW9wdXlvNXhUZVd5d0tBRk1BTnFWWHJ3NGxLSFZYK2VZalJzTjFubWFRWVFLdE13aFVzcGZyL0g0MG5ZY3R1SGQiLCJtYWMiOiI2MmNhNmVlNDcxY2NiMzMzYjZlOGRmNzhiZmNlOTVmODMxNDk5ODk1NzNkM2FhYjNmOTY5YjczYTJmYWQ0NTU3IiwidGFnIjoiIn0%3D; expires=Sun, 06-Apr-2025 11:40:12 GMT; Max-Age=7200; path=/; samesite=laxXSRF-TOKEN=eyJpdiI6IksrRm41eFdHMlVvdlA4UitPRWJjZXc9PSIsInZhbHVlIjoiOFRiQzRTQjZHT2wyOVQzOWwxT0dVOW9kN2FramNIczJLK1VBc1NOcUZiaDl3UVBGaVBwcWwzWkFoVnR3NlVNRW9wdXlvN" 1 => "rouvana_session=eyJpdiI6ImNSeURaTVh0MENUM1VLcmtkaW8vSmc9PSIsInZhbHVlIjoibWhLSW5od09naDJYT0RoTUNhWnpybXhHbE9aNXozN2M4RnFKL0E5THlSckV0R3ZMZDlrNVhDU0tvcE5OVDliTE1TRHZ0NEtNcnJ4Vld0TG45UnEvb0oxc1BXd2xQOGtBT0lLVXNIeEp3L1JUZmdETFdyNkxOSys1eGd0eWZUSHEiLCJtYWMiOiJkOWIwM2I1YTc0NTg5YmU5OTFkMTg4NGNhNzM5YWQ0YWE5NGU5YTFmNjcyYzEyOTI1MzFlNGYyZTI2ZjNkYWNiIiwidGFnIjoiIn0%3D; expires=Sun, 06-Apr-2025 11:40:12 GMT; Max-Age=7200; path=/; httponly; samesite=laxrouvana_session=eyJpdiI6ImNSeURaTVh0MENUM1VLcmtkaW8vSmc9PSIsInZhbHVlIjoibWhLSW5od09naDJYT0RoTUNhWnpybXhHbE9aNXozN2M4RnFKL0E5THlSckV0R3ZMZDlrNVhDU0tvcE5OVDliTE1T" ] "Set-Cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6IksrRm41eFdHMlVvdlA4UitPRWJjZXc9PSIsInZhbHVlIjoiOFRiQzRTQjZHT2wyOVQzOWwxT0dVOW9kN2FramNIczJLK1VBc1NOcUZiaDl3UVBGaVBwcWwzWkFoVnR3NlVNRW9wdXlvNXhUZVd5d0tBRk1BTnFWWHJ3NGxLSFZYK2VZalJzTjFubWFRWVFLdE13aFVzcGZyL0g0MG5ZY3R1SGQiLCJtYWMiOiI2MmNhNmVlNDcxY2NiMzMzYjZlOGRmNzhiZmNlOTVmODMxNDk5ODk1NzNkM2FhYjNmOTY5YjczYTJmYWQ0NTU3IiwidGFnIjoiIn0%3D; expires=Sun, 06-Apr-2025 11:40:12 GMT; path=/XSRF-TOKEN=eyJpdiI6IksrRm41eFdHMlVvdlA4UitPRWJjZXc9PSIsInZhbHVlIjoiOFRiQzRTQjZHT2wyOVQzOWwxT0dVOW9kN2FramNIczJLK1VBc1NOcUZiaDl3UVBGaVBwcWwzWkFoVnR3NlVNRW9wdXlvN" 1 => "rouvana_session=eyJpdiI6ImNSeURaTVh0MENUM1VLcmtkaW8vSmc9PSIsInZhbHVlIjoibWhLSW5od09naDJYT0RoTUNhWnpybXhHbE9aNXozN2M4RnFKL0E5THlSckV0R3ZMZDlrNVhDU0tvcE5OVDliTE1TRHZ0NEtNcnJ4Vld0TG45UnEvb0oxc1BXd2xQOGtBT0lLVXNIeEp3L1JUZmdETFdyNkxOSys1eGd0eWZUSHEiLCJtYWMiOiJkOWIwM2I1YTc0NTg5YmU5OTFkMTg4NGNhNzM5YWQ0YWE5NGU5YTFmNjcyYzEyOTI1MzFlNGYyZTI2ZjNkYWNiIiwidGFnIjoiIn0%3D; expires=Sun, 06-Apr-2025 11:40:12 GMT; path=/; httponlyrouvana_session=eyJpdiI6ImNSeURaTVh0MENUM1VLcmtkaW8vSmc9PSIsInZhbHVlIjoibWhLSW5od09naDJYT0RoTUNhWnpybXhHbE9aNXozN2M4RnFKL0E5THlSckV0R3ZMZDlrNVhDU0tvcE5OVDliTE1T" ] ]
        session_attributes
        0 of 0
        array:4 [ "_token" => "H8dnTwlIX5gYgQPk16o31qvCnvCZ3RtZRsnlevE1" "_previous" => array:1 [ "url" => "https://rouvana.com/location/ras-al-khaimah" ] "_flash" => array:2 [ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]