Rouvana Tours
Rouvana Tours
>
Dubai - United Arab Emiratis
Dubai - United Arab Emiratis

Dubai - United Arab Emiratis

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

What to know before visiting Dubai - United Arab Emiratis

Dubai is a city and emirate in the United Arab Emirates known for luxury shopping, ultramodern architecture and a lively nightlife scene. Burj Khalifa, an 830m-tall tower, dominates the skyscraper-filled skyline. At its foot lies Dubai Fountain, with jets and lights choreographed to music. On artificial islands just offshore is Atlantis, The Palm, a resort with water and marine-animal parks.

Location Map

Interdum et malesuada fames ac ante ipsum

Leaflet | © OpenStreetMap contributors

Most Popular Hotel

Interdum et malesuada fames ac ante ipsum

Landmark Hotel Baniyas Dubai

Dubai - United Arab Emiratis

0
Not rated
0 Review
Starting from
16.356 E£

Landmark Summit Hotel

Dubai - United Arab Emiratis

0
Not rated
0 Review
Starting from
16.901 E£

Landmark Hotel Riqqa, Deira, Dubai

Dubai - United Arab Emiratis

0
Not rated
0 Review
Starting from
16.792 E£

Landmark Premier Hotel

Dubai - United Arab Emiratis

0
Not rated
0 Review
Starting from
0 E£

Landmark Plaza Hotel

Dubai - United Arab Emiratis

0
Not rated
0 Review
Starting from
0 E£

Most Popular Activities

Interdum et malesuada fames ac ante ipsum

Evening Desert Safari
Featured
Sale off 62%
Start Time: 15:30 - 6 Hours

Evening Desert Safari

Dubai - United Arab Emiratis

0 Review
from 43.070 E£ 16.356 E£
Dubai City Tour
Featured
Start Time: 8:30am - 1 Hour

Dubai City Tour

Dubai - United Arab Emiratis

0 Review
from 7.087 E£
Start Time: 12:00PM - 8 Hours

IMG Worlds of Adventure

Dubai - United Arab Emiratis

0 Review
from 5.997 E£
Start Time: 10:00 AM - 7 Hours

Dubai Aquarium and Underwater Zoo

Dubai - United Arab Emiratis

0 Review
from 15.265 E£
Start Time: 11:00 - 3 Hours

Dubai Dolphinarium

Dubai - United Arab Emiratis

0 Review
from 4.907 E£
Evening Desert Safari
Sale off 0%
Start Time: 3:30 -

Evening Desert Safari

Dubai - United Arab Emiratis

0 Review
from 17.337 E£ 17.228 E£
Overnight Safari
Sale off 2%
Start Time: 3:00 pm to 9:00 am - 18 Hours

Overnight Safari

Dubai - United Arab Emiratis

0 Review
from 38.163 E£ 37.073 E£
Dhow Cruise Dinner - Marina
Sale off 0%
Start Time: 8:00pm-9:30pm - 1 Hour

Dhow Cruise Dinner - Marina

Dubai - United Arab Emiratis

0 Review
from 14.175 E£ 14.066 E£

Most Popular Holiday

Interdum et malesuada fames ac ante ipsum

Dubai 03nights 4 days

Dubai - United Arab Emiratis

0 Review
from 0 E£

Your Travel Journey Starts Here

Sign up and we'll send the best deals to you
8.1.32PHP Version213msRequest Duration7MBMemory UsageGET location/{slug}RouteAuth status
    • Booting (32.07ms)
    • Application (180ms)
    • 1 x Application (84.89%)
      180.45ms
      1 x Booting (15.09%)
      32.07ms
      50 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
      • 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
      • 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
      • 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
      • 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
      • 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
      • 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
      • Tour::frontend.layouts.search.loop-grid (themes/GoTrip/Tour/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)22blade
        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
        location
        20
        reviewData
        21
        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
      31 statements were executed, 6 of which were duplicated, 25 unique16.38ms
      • select * from `bravo_locations` where `slug` = 'dubai' and `status` = 'publish' and `bravo_locations`.`deleted_at` is null limit 12.44ms/modules/Location/Controllers/LocationController.php:23u479693165_new
        Metadata
        Bindings
        • 0. dubai
        • 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` = 15 and `bravo_location_translations`.`origin_id` is not null and `locale` = 'en' limit 1390μs/app/Traits/HasTranslations.php:51u479693165_new
        Metadata
        Bindings
        • 0. 15
        • 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` = 15 and `object_model` = 'location' limit 1280μs/app/BaseModel.php:199u479693165_new
        Metadata
        Bindings
        • 0. 15
        • 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` >= 29 and `bravo_locations`.`_rgt` <= 30 where `bravo_hotels`.`status` = 'publish' and `bravo_hotels`.`deleted_at` is null limit 8550μsview::53f8633a31a65471db6d66d3e02b4903f27bba30:14u479693165_new
        Metadata
        Bindings
        • 0. 29
        • 1. 30
        • 2. publish
        Hints
        • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
        Backtrace
        • 14. view::53f8633a31a65471db6d66d3e02b4903f27bba30: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 (15) and `bravo_locations`.`deleted_at` is null270μsview::53f8633a31a65471db6d66d3e02b4903f27bba30:14u479693165_new
        Metadata
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 19. view::53f8633a31a65471db6d66d3e02b4903f27bba30: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 (15)250μsview::53f8633a31a65471db6d66d3e02b4903f27bba30:14u479693165_new
        Metadata
        Bindings
        • 0. en
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 24. view::53f8633a31a65471db6d66d3e02b4903f27bba30: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` = 390 and `bravo_hotel_translations`.`origin_id` is not null and `locale` = 'en' and `bravo_hotel_translations`.`deleted_at` is null limit 1320μs/app/Traits/HasTranslations.php:51u479693165_new
        Metadata
        Bindings
        • 0. 390
        • 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::aaa2d79e001a95631dcc4dbb982ee3b8b88e7de1: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_hotel_translations` where `bravo_hotel_translations`.`origin_id` = 391 and `bravo_hotel_translations`.`origin_id` is not null and `locale` = 'en' and `bravo_hotel_translations`.`deleted_at` is null limit 1380μs/app/Traits/HasTranslations.php:51u479693165_new
        Metadata
        Bindings
        • 0. 391
        • 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::aaa2d79e001a95631dcc4dbb982ee3b8b88e7de1: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_hotel_translations` where `bravo_hotel_translations`.`origin_id` = 392 and `bravo_hotel_translations`.`origin_id` is not null and `locale` = 'en' and `bravo_hotel_translations`.`deleted_at` is null limit 1300μs/app/Traits/HasTranslations.php:51u479693165_new
        Metadata
        Bindings
        • 0. 392
        • 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::aaa2d79e001a95631dcc4dbb982ee3b8b88e7de1: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_hotel_translations` where `bravo_hotel_translations`.`origin_id` = 393 and `bravo_hotel_translations`.`origin_id` is not null and `locale` = 'en' and `bravo_hotel_translations`.`deleted_at` is null limit 1380μs/app/Traits/HasTranslations.php:51u479693165_new
        Metadata
        Bindings
        • 0. 393
        • 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::aaa2d79e001a95631dcc4dbb982ee3b8b88e7de1: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_hotel_translations` where `bravo_hotel_translations`.`origin_id` = 394 and `bravo_hotel_translations`.`origin_id` is not null and `locale` = 'en' and `bravo_hotel_translations`.`deleted_at` is null limit 1260μs/app/Traits/HasTranslations.php:51u479693165_new
        Metadata
        Bindings
        • 0. 394
        • 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::aaa2d79e001a95631dcc4dbb982ee3b8b88e7de1: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` >= 29 and `bravo_locations`.`_rgt` <= 30 where `bravo_cars`.`status` = 'publish' and `bravo_cars`.`deleted_at` is null limit 81.01msview::53f8633a31a65471db6d66d3e02b4903f27bba30:14u479693165_new
        Metadata
        Bindings
        • 0. 29
        • 1. 30
        • 2. publish
        Hints
        • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
        Backtrace
        • 14. view::53f8633a31a65471db6d66d3e02b4903f27bba30: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` >= 29 and `bravo_locations`.`_rgt` <= 30 where `bravo_events`.`status` = 'publish' and `bravo_events`.`deleted_at` is null limit 82.48msview::53f8633a31a65471db6d66d3e02b4903f27bba30:14u479693165_new
        Metadata
        Bindings
        • 0. 29
        • 1. 30
        • 2. publish
        Hints
        • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
        Backtrace
        • 14. view::53f8633a31a65471db6d66d3e02b4903f27bba30: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 (15) and `bravo_locations`.`deleted_at` is null240μsview::53f8633a31a65471db6d66d3e02b4903f27bba30:14u479693165_new
        Metadata
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 19. view::53f8633a31a65471db6d66d3e02b4903f27bba30: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 (15)210μsview::53f8633a31a65471db6d66d3e02b4903f27bba30:14u479693165_new
        Metadata
        Bindings
        • 0. en
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 24. view::53f8633a31a65471db6d66d3e02b4903f27bba30: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` = 97 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_new
        Metadata
        Bindings
        • 0. 97
        • 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::5a0c753d58c591b443ef874af1f17ced374b832e: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` = 98 and `bravo_event_translations`.`origin_id` is not null and `locale` = 'en' and `bravo_event_translations`.`deleted_at` is null limit 11.01ms/app/Traits/HasTranslations.php:51u479693165_new
        Metadata
        Bindings
        • 0. 98
        • 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::5a0c753d58c591b443ef874af1f17ced374b832e: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` = 100 and `bravo_event_translations`.`origin_id` is not null and `locale` = 'en' and `bravo_event_translations`.`deleted_at` is null limit 1300μ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::5a0c753d58c591b443ef874af1f17ced374b832e: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` = 101 and `bravo_event_translations`.`origin_id` is not null and `locale` = 'en' and `bravo_event_translations`.`deleted_at` is null limit 1330μ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::5a0c753d58c591b443ef874af1f17ced374b832e: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` = 102 and `bravo_event_translations`.`origin_id` is not null and `locale` = 'en' and `bravo_event_translations`.`deleted_at` is null limit 1310μs/app/Traits/HasTranslations.php:51u479693165_new
        Metadata
        Bindings
        • 0. 102
        • 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::5a0c753d58c591b443ef874af1f17ced374b832e: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` = 103 and `bravo_event_translations`.`origin_id` is not null and `locale` = 'en' and `bravo_event_translations`.`deleted_at` is null limit 1640μs/app/Traits/HasTranslations.php:51u479693165_new
        Metadata
        Bindings
        • 0. 103
        • 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::5a0c753d58c591b443ef874af1f17ced374b832e: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` = 104 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_new
        Metadata
        Bindings
        • 0. 104
        • 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::5a0c753d58c591b443ef874af1f17ced374b832e: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` = 108 and `bravo_event_translations`.`origin_id` is not null and `locale` = 'en' and `bravo_event_translations`.`deleted_at` is null limit 1460μs/app/Traits/HasTranslations.php:51u479693165_new
        Metadata
        Bindings
        • 0. 108
        • 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::5a0c753d58c591b443ef874af1f17ced374b832e: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` >= 29 and `bravo_locations`.`_rgt` <= 30 where `bravo_tours`.`status` = 'publish' and `bravo_tours`.`deleted_at` is null limit 8680μsview::53f8633a31a65471db6d66d3e02b4903f27bba30:14u479693165_new
        Metadata
        Bindings
        • 0. 29
        • 1. 30
        • 2. publish
        Hints
        • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
        Backtrace
        • 14. view::53f8633a31a65471db6d66d3e02b4903f27bba30: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 (15) and `bravo_locations`.`deleted_at` is null170μsview::53f8633a31a65471db6d66d3e02b4903f27bba30:14u479693165_new
        Metadata
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 19. view::53f8633a31a65471db6d66d3e02b4903f27bba30: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 (15)170μsview::53f8633a31a65471db6d66d3e02b4903f27bba30:14u479693165_new
        Metadata
        Bindings
        • 0. en
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 24. view::53f8633a31a65471db6d66d3e02b4903f27bba30: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_tour_translations` where `bravo_tour_translations`.`origin_id` = 145 and `bravo_tour_translations`.`origin_id` is not null and `locale` = 'en' limit 1300μs/app/Traits/HasTranslations.php:51u479693165_new
        Metadata
        Bindings
        • 0. 145
        • 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::68f062e1ac14b176f8a445e323ef5ef228ffbe66: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 `media_files` where `media_files`.`id` is null and `media_files`.`deleted_at` is null limit 1250μs/app/BaseModel.php:135u479693165_new
        Metadata
        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 `bravo_boats`.* from `bravo_boats` inner join `bravo_locations` on `bravo_locations`.`id` = `bravo_boats`.`location_id` and `bravo_locations`.`_lft` >= 29 and `bravo_locations`.`_rgt` <= 30 where `bravo_boats`.`status` = 'publish' and `bravo_boats`.`deleted_at` is null limit 8450μsview::53f8633a31a65471db6d66d3e02b4903f27bba30:14u479693165_new
        Metadata
        Bindings
        • 0. 29
        • 1. 30
        • 2. publish
        Hints
        • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
        Backtrace
        • 14. view::53f8633a31a65471db6d66d3e02b4903f27bba30: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 1400μ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 1330μ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\Tour\Models\TourTranslation
      1
      Modules\Tour\Models\Tour
      1
      Modules\Event\Models\EventTranslation
      8
      Modules\Event\Models\Event
      8
      Modules\Hotel\Models\HotelTranslation
      5
      Modules\Location\Models\LocationTranslation
      3
      Modules\Location\Models\Location
      3
      Modules\Hotel\Models\Hotel
      5
      Modules\Core\Models\SEO
      1
      Themes\GoTrip\Location\Models\LocationTranslation
      1
      Themes\GoTrip\Location\Models\Location
      1
      web
      null
      sanctum
      null
        _token
        kqThXAX0r9ztl7jffz2Z0AaqK7rsvqny8EZVfn8M
        bc_current_currency
        egp
        _previous
        array:1 [ "url" => "https://rouvanab2b.com/location/dubai" ]
        _flash
        array:2 [ "old" => [] "new" => [] ]
        PHPDEBUGBAR_STACK_DATA
        []
        path_info
        /location/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=eyJpdiI6IkE1OTdLQ3F1TTRDS0pVaTdyMEUzRnc9PSIsInZhbHVlIjoiRlpyODFObWZMaFVpUHlrdlNINjZJcFFMUWY1OXROR1ptVXpGMitXY0xZSEwraUdiVUVjckUrM201NjFndlNRQUhOeGdkOEJmbEE0ejluV204RDhnL0Y1WWNCTUx4YTdSVjU0Q1I3QVp1TlNmQ05ITVJjZ1RxdFNMbmlHQThFZWIiLCJtYWMiOiIyN2Y4NTIzNmI3NWMwYWRjNjE0NDJlNGYwMjYxNTRlNDkzZDg2MTFiZGQ2MDM0NDU2ZjFmODYwYjMxNTQxZDNiIiwidGFnIjoiIn0%3D; rouvana_session=eyJpdiI6IkpYcTA5YXNEdEEzUloxZmE3dE55VXc9PSIsInZhbHVlIjoieWQxUTF2SG5BUEY2RDFTZXEzdDFtZHUxWDg1UVVZTzNzajJxNjM3WlVaR0JjZllFV3ZVYktpSWJteU9rVUVRZEppVDhkai9rTk42cUtkRitGcGxxMHJuR3VFQzNsWDAyZHhmeHdYbHdEM0lXRWdocUpFWGdLR3FZT2htREdqVUsiLCJtYWMiOiJkYjViMDNiODE1NjUxNmE0OWJhM2IwYTA0MWYwNDY3Y2M2OWQ2MmNlMTJhZjEzZmRiMTlhYzRiMTk4MWI4YzRlIiwidGFnIjoiIn0%3DXSRF-TOKEN=eyJpdiI6IkE1OTdLQ3F1TTRDS0pVaTdyMEUzRnc9PSIsInZhbHVlIjoiRlpyODFObWZMaFVpUHlrdlNINjZJcFFMUWY1OXROR1ptVXpGMitXY0xZSEwraUdiVUVjckUrM201NjFndlNRQUhOeGdkO" ] "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 => "18.216.103.219" ] "x-forwarded-proto" => array:1 [ 0 => "https" ] "x-real-ip" => array:1 [ 0 => "18.216.103.219" ] "x-real-port" => array:1 [ 0 => "3105" ] "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=eyJpdiI6IkE1OTdLQ3F1TTRDS0pVaTdyMEUzRnc9PSIsInZhbHVlIjoiRlpyODFObWZMaFVpUHlrdlNINjZJcFFMUWY1OXROR1ptVXpGMitXY0xZSEwraUdiVUVjckUrM201NjFndlNRQUhOeGdkOEJmbEE0ejluV204RDhnL0Y1WWNCTUx4YTdSVjU0Q1I3QVp1TlNmQ05ITVJjZ1RxdFNMbmlHQThFZWIiLCJtYWMiOiIyN2Y4NTIzNmI3NWMwYWRjNjE0NDJlNGYwMjYxNTRlNDkzZDg2MTFiZGQ2MDM0NDU2ZjFmODYwYjMxNTQxZDNiIiwidGFnIjoiIn0%3D; rouvana_session=eyJpdiI6IkpYcTA5YXNEdEEzUloxZmE3dE55VXc9PSIsInZhbHVlIjoieWQxUTF2SG5BUEY2RDFTZXEzdDFtZHUxWDg1UVVZTzNzajJxNjM3WlVaR0JjZllFV3ZVYktpSWJteU9rVUVRZEppVDhkai9rTk42cUtkRitGcGxxMHJuR3VFQzNsWDAyZHhmeHdYbHdEM0lXRWdocUpFWGdLR3FZT2htREdqVUsiLCJtYWMiOiJkYjViMDNiODE1NjUxNmE0OWJhM2IwYTA0MWYwNDY3Y2M2OWQ2MmNlMTJhZjEzZmRiMTlhYzRiMTk4MWI4YzRlIiwidGFnIjoiIn0%3DXSRF-TOKEN=eyJpdiI6IkE1OTdLQ3F1TTRDS0pVaTdyMEUzRnc9PSIsInZhbHVlIjoiRlpyODFObWZMaFVpUHlrdlNINjZJcFFMUWY1OXROR1ptVXpGMitXY0xZSEwraUdiVUVjckUrM201NjFndlNRQUhOeGdkO" "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" => "18.216.103.219" "HTTP_X_FORWARDED_PROTO" => "https" "HTTP_X_REAL_IP" => "18.216.103.219" "HTTP_X_REAL_PORT" => "3105" "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" => "18.216.103.219" "REMOTE_PORT" => "24626" "SERVER_ADDR" => "2a02:4780:11:1654:0:1c97:896d:4" "SERVER_NAME" => "rouvanab2b.com" "SERVER_ADMIN" => "" "SERVER_PORT" => "443" "REQUEST_SCHEME" => "https" "REQUEST_URI" => "/location/dubai" "REDIRECT_URL" => "/public/location/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/location/dubai" "SCRIPT_URL" => "/location/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" => 1745732036.0803 "REQUEST_TIME" => 1745732036 ]
        request_cookies
        0 of 0
        array:2 [ "XSRF-TOKEN" => "kqThXAX0r9ztl7jffz2Z0AaqK7rsvqny8EZVfn8M" "rouvana_session" => "dN3cad4HlSgcUvvxS9EDSo4ssoTye9hsEMAZzBIa" ]
        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, 27 Apr 2025 05:33:56 GMT" ] "set-cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6IjQ3clRiZGhOSC85K1JnRjVmYVRtblE9PSIsInZhbHVlIjoiUUZMUGx0WGdVZVpXc2NJbXpUY3EwL3ZqOHFGajdxODErZWtkaXQxRmJTUzN5QllFb1ZQbFlzV3RiYXlicnM1d01WRnhmNTBza1YxYWUxUlJ2MTF3NmIvazQ2bm15SHNmaVZ4K3QwUElxa2lrdEczbnhyRE4zUGFBT2I5WWNIUXMiLCJtYWMiOiJkZWZmZTZmN2MxNTc1NGY1NTU0MTNkOTdkODIzNDcxODJjZjg1NjdlYzgzYzM1YzIxMGJmMmY3NDFmYWU0NGE0IiwidGFnIjoiIn0%3D; expires=Sun, 27-Apr-2025 07:33:56 GMT; Max-Age=7200; path=/; samesite=laxXSRF-TOKEN=eyJpdiI6IjQ3clRiZGhOSC85K1JnRjVmYVRtblE9PSIsInZhbHVlIjoiUUZMUGx0WGdVZVpXc2NJbXpUY3EwL3ZqOHFGajdxODErZWtkaXQxRmJTUzN5QllFb1ZQbFlzV3RiYXlicnM1d01WRnhmN" 1 => "rouvana_session=eyJpdiI6Ims4QVNmc3VUbGtoRzBhRGh2TnllaXc9PSIsInZhbHVlIjoiV1U4KzV2ZlFkeGU5dGtqNkpQTGVqRG5oWGFnSC9sS2R2a1BZRFFnajJObmNncDRIU2RTaFlva2JuRnQwMjlXMjlkTlMxb1FSZERrbS94UjNtRzZXUURGQWJVaEFuSHlMVDJ2b2NPSnlqM1RQYTF1bFZwRmIxVlI5ZldtU2M2TjkiLCJtYWMiOiJiMDc5YzViNjNlYzgwNDQxMTcxOTBlODg5MTE4Y2JlNjA5YzFiMTczNzMyMjU3Yjk1MGViNzFhZWFhNDA2YzRjIiwidGFnIjoiIn0%3D; expires=Sun, 27-Apr-2025 07:33:56 GMT; Max-Age=7200; path=/; httponly; samesite=laxrouvana_session=eyJpdiI6Ims4QVNmc3VUbGtoRzBhRGh2TnllaXc9PSIsInZhbHVlIjoiV1U4KzV2ZlFkeGU5dGtqNkpQTGVqRG5oWGFnSC9sS2R2a1BZRFFnajJObmNncDRIU2RTaFlva2JuRnQwMjlXMjlk" ] "Set-Cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6IjQ3clRiZGhOSC85K1JnRjVmYVRtblE9PSIsInZhbHVlIjoiUUZMUGx0WGdVZVpXc2NJbXpUY3EwL3ZqOHFGajdxODErZWtkaXQxRmJTUzN5QllFb1ZQbFlzV3RiYXlicnM1d01WRnhmNTBza1YxYWUxUlJ2MTF3NmIvazQ2bm15SHNmaVZ4K3QwUElxa2lrdEczbnhyRE4zUGFBT2I5WWNIUXMiLCJtYWMiOiJkZWZmZTZmN2MxNTc1NGY1NTU0MTNkOTdkODIzNDcxODJjZjg1NjdlYzgzYzM1YzIxMGJmMmY3NDFmYWU0NGE0IiwidGFnIjoiIn0%3D; expires=Sun, 27-Apr-2025 07:33:56 GMT; path=/XSRF-TOKEN=eyJpdiI6IjQ3clRiZGhOSC85K1JnRjVmYVRtblE9PSIsInZhbHVlIjoiUUZMUGx0WGdVZVpXc2NJbXpUY3EwL3ZqOHFGajdxODErZWtkaXQxRmJTUzN5QllFb1ZQbFlzV3RiYXlicnM1d01WRnhmN" 1 => "rouvana_session=eyJpdiI6Ims4QVNmc3VUbGtoRzBhRGh2TnllaXc9PSIsInZhbHVlIjoiV1U4KzV2ZlFkeGU5dGtqNkpQTGVqRG5oWGFnSC9sS2R2a1BZRFFnajJObmNncDRIU2RTaFlva2JuRnQwMjlXMjlkTlMxb1FSZERrbS94UjNtRzZXUURGQWJVaEFuSHlMVDJ2b2NPSnlqM1RQYTF1bFZwRmIxVlI5ZldtU2M2TjkiLCJtYWMiOiJiMDc5YzViNjNlYzgwNDQxMTcxOTBlODg5MTE4Y2JlNjA5YzFiMTczNzMyMjU3Yjk1MGViNzFhZWFhNDA2YzRjIiwidGFnIjoiIn0%3D; expires=Sun, 27-Apr-2025 07:33:56 GMT; path=/; httponlyrouvana_session=eyJpdiI6Ims4QVNmc3VUbGtoRzBhRGh2TnllaXc9PSIsInZhbHVlIjoiV1U4KzV2ZlFkeGU5dGtqNkpQTGVqRG5oWGFnSC9sS2R2a1BZRFFnajJObmNncDRIU2RTaFlva2JuRnQwMjlXMjlk" ] ]
        session_attributes
        0 of 0
        array:5 [ "_token" => "kqThXAX0r9ztl7jffz2Z0AaqK7rsvqny8EZVfn8M" "bc_current_currency" => "egp" "_previous" => array:1 [ "url" => "https://rouvanab2b.com/location/dubai" ] "_flash" => array:2 [ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]