Search for hotel

FILTER BY

Filter Price

€0 €1 66204168311 2471 662

Hotel Star

Review Score

Property type

Facilities

Hotel Service

مكة
Not rated 0 Review
from
€908,28 /night
مكة
Not rated 0 Review
from
€1.661,48 /night
مكة
Not rated 0 Review
from
€775,36 /night
مكة
Not rated 0 Review
from
€824,10 /night
مكة
Not rated 0 Review
from
€908,28 /night
مكة
Not rated 0 Review
from
€553,83 /night
Showing 1 - 9 of 19 Hotels
8.1.27PHP Version338msRequest Duration6MBMemory UsageGET hotelRouteAuth status
    • Booting (62.23ms)
    • Application (275ms)
    • 1 x Application (81.55%)
      275.41ms
      1 x Booting (18.43%)
      62.23ms
      38 templates were rendered
      • Hotel::frontend.search (themes/BC/Hotel/Views/frontend/search.blade.php)8bladefile
        Params
        0
        rows
        1
        list_location
        2
        hotel_min_max_price
        3
        markers
        4
        blank
        5
        seo_meta
        6
        attributes
        7
        layout
      • Hotel::frontend.layouts.search.form-search (themes/BC/Hotel/Views/frontend/layouts/search/form-search.blade.php)12bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        rows
        4
        list_location
        5
        hotel_min_max_price
        6
        markers
        7
        blank
        8
        seo_meta
        9
        attributes
        10
        layout
        11
        bg
      • Hotel::frontend.layouts.search.fields.location (themes/BC/Hotel/Views/frontend/layouts/search/fields/location.blade.php)16bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        rows
        4
        list_location
        5
        hotel_min_max_price
        6
        markers
        7
        blank
        8
        seo_meta
        9
        attributes
        10
        layout
        11
        bg
        12
        hotel_search_fields
        13
        __currentLoopData
        14
        field
        15
        loop
      • Hotel::frontend.layouts.search.fields.date (themes/BC/Hotel/Views/frontend/layouts/search/fields/date.blade.php)16bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        rows
        4
        list_location
        5
        hotel_min_max_price
        6
        markers
        7
        blank
        8
        seo_meta
        9
        attributes
        10
        layout
        11
        bg
        12
        hotel_search_fields
        13
        __currentLoopData
        14
        field
        15
        loop
      • Hotel::frontend.layouts.search.fields.guests (themes/BC/Hotel/Views/frontend/layouts/search/fields/guests.blade.php)16bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        rows
        4
        list_location
        5
        hotel_min_max_price
        6
        markers
        7
        blank
        8
        seo_meta
        9
        attributes
        10
        layout
        11
        bg
        12
        hotel_search_fields
        13
        __currentLoopData
        14
        field
        15
        loop
      • Hotel::frontend.layouts.search.list-item (themes/BC/Hotel/Views/frontend/layouts/search/list-item.blade.php)12bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        rows
        4
        list_location
        5
        hotel_min_max_price
        6
        markers
        7
        blank
        8
        seo_meta
        9
        attributes
        10
        layout
        11
        bg
      • Hotel::frontend.layouts.search.filter-search (themes/BC/Hotel/Views/frontend/layouts/search/filter-search.blade.php)12bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        rows
        4
        list_location
        5
        hotel_min_max_price
        6
        markers
        7
        blank
        8
        seo_meta
        9
        attributes
        10
        layout
        11
        bg
      • Layout::global.search.filters.attrs (themes/BC/Layout/global/search/filters/attrs.blade.php)21bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        rows
        4
        list_location
        5
        hotel_min_max_price
        6
        markers
        7
        blank
        8
        seo_meta
        9
        attributes
        10
        layout
        11
        bg
        12
        price_min
        13
        pri_from
        14
        price_max
        15
        pri_to
        16
        price_range
        17
        currency
        18
        number
        19
        star
        20
        review_score
      • Layout::global.search.orderby (themes/BC/Layout/global/search/orderby.blade.php)13bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        rows
        4
        list_location
        5
        hotel_min_max_price
        6
        markers
        7
        blank
        8
        seo_meta
        9
        attributes
        10
        layout
        11
        bg
        12
        routeName
      • Hotel::frontend.ajax.search-result (themes/BC/Hotel/Views/frontend/ajax/search-result.blade.php)12bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        rows
        4
        list_location
        5
        hotel_min_max_price
        6
        markers
        7
        blank
        8
        seo_meta
        9
        attributes
        10
        layout
        11
        bg
      • Hotel::frontend.layouts.search.loop-grid (themes/BC/Hotel/Views/frontend/layouts/search/loop-grid.blade.php)15bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        rows
        4
        list_location
        5
        hotel_min_max_price
        6
        markers
        7
        blank
        8
        seo_meta
        9
        attributes
        10
        layout
        11
        bg
        12
        __currentLoopData
        13
        row
        14
        loop
      • Hotel::frontend.layouts.search.loop-grid (themes/BC/Hotel/Views/frontend/layouts/search/loop-grid.blade.php)15bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        rows
        4
        list_location
        5
        hotel_min_max_price
        6
        markers
        7
        blank
        8
        seo_meta
        9
        attributes
        10
        layout
        11
        bg
        12
        __currentLoopData
        13
        row
        14
        loop
      • Hotel::frontend.layouts.search.loop-grid (themes/BC/Hotel/Views/frontend/layouts/search/loop-grid.blade.php)15bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        rows
        4
        list_location
        5
        hotel_min_max_price
        6
        markers
        7
        blank
        8
        seo_meta
        9
        attributes
        10
        layout
        11
        bg
        12
        __currentLoopData
        13
        row
        14
        loop
      • Hotel::frontend.layouts.search.loop-grid (themes/BC/Hotel/Views/frontend/layouts/search/loop-grid.blade.php)15bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        rows
        4
        list_location
        5
        hotel_min_max_price
        6
        markers
        7
        blank
        8
        seo_meta
        9
        attributes
        10
        layout
        11
        bg
        12
        __currentLoopData
        13
        row
        14
        loop
      • Hotel::frontend.layouts.search.loop-grid (themes/BC/Hotel/Views/frontend/layouts/search/loop-grid.blade.php)15bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        rows
        4
        list_location
        5
        hotel_min_max_price
        6
        markers
        7
        blank
        8
        seo_meta
        9
        attributes
        10
        layout
        11
        bg
        12
        __currentLoopData
        13
        row
        14
        loop
      • Hotel::frontend.layouts.search.loop-grid (themes/BC/Hotel/Views/frontend/layouts/search/loop-grid.blade.php)15bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        rows
        4
        list_location
        5
        hotel_min_max_price
        6
        markers
        7
        blank
        8
        seo_meta
        9
        attributes
        10
        layout
        11
        bg
        12
        __currentLoopData
        13
        row
        14
        loop
      • Hotel::frontend.layouts.search.loop-grid (themes/BC/Hotel/Views/frontend/layouts/search/loop-grid.blade.php)15bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        rows
        4
        list_location
        5
        hotel_min_max_price
        6
        markers
        7
        blank
        8
        seo_meta
        9
        attributes
        10
        layout
        11
        bg
        12
        __currentLoopData
        13
        row
        14
        loop
      • Hotel::frontend.layouts.search.loop-grid (themes/BC/Hotel/Views/frontend/layouts/search/loop-grid.blade.php)15bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        rows
        4
        list_location
        5
        hotel_min_max_price
        6
        markers
        7
        blank
        8
        seo_meta
        9
        attributes
        10
        layout
        11
        bg
        12
        __currentLoopData
        13
        row
        14
        loop
      • Hotel::frontend.layouts.search.loop-grid (themes/BC/Hotel/Views/frontend/layouts/search/loop-grid.blade.php)15bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        rows
        4
        list_location
        5
        hotel_min_max_price
        6
        markers
        7
        blank
        8
        seo_meta
        9
        attributes
        10
        layout
        11
        bg
        12
        __currentLoopData
        13
        row
        14
        loop
      • pagination::tailwind (resources/views/vendor/pagination/tailwind.blade.php)2bladefile
        Params
        0
        paginator
        1
        elements
      • vendor.pagination.default (resources/views/vendor/pagination/default.blade.php)5bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        paginator
        4
        elements
      • layouts.app (resources/views/layouts/app.blade.php)12bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        rows
        4
        list_location
        5
        hotel_min_max_price
        6
        markers
        7
        blank
        8
        seo_meta
        9
        attributes
        10
        layout
        11
        bg
      • Layout::app (modules/Layout/app.blade.php)12bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        rows
        4
        list_location
        5
        hotel_min_max_price
        6
        markers
        7
        blank
        8
        seo_meta
        9
        attributes
        10
        layout
        11
        bg
      • Layout::parts.favicon (modules/Layout/parts/favicon.blade.php)12bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        rows
        4
        list_location
        5
        hotel_min_max_price
        6
        markers
        7
        blank
        8
        seo_meta
        9
        attributes
        10
        layout
        11
        bg
      • Layout::parts.seo-meta (modules/Layout/parts/seo-meta.blade.php)12bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        rows
        4
        list_location
        5
        hotel_min_max_price
        6
        markers
        7
        blank
        8
        seo_meta
        9
        attributes
        10
        layout
        11
        bg
      • Layout::parts.global-script (modules/Layout/parts/global-script.blade.php)12bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        rows
        4
        list_location
        5
        hotel_min_max_price
        6
        markers
        7
        blank
        8
        seo_meta
        9
        attributes
        10
        layout
        11
        bg
      • Layout::parts.topbar (modules/Layout/parts/topbar.blade.php)12bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        rows
        4
        list_location
        5
        hotel_min_max_price
        6
        markers
        7
        blank
        8
        seo_meta
        9
        attributes
        10
        layout
        11
        bg
      • Core::frontend.currency-switcher (themes/BC/Core/Views/frontend/currency-switcher.blade.php)12bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        rows
        4
        list_location
        5
        hotel_min_max_price
        6
        markers
        7
        blank
        8
        seo_meta
        9
        attributes
        10
        layout
        11
        bg
      • Language::frontend.switcher (themes/BC/Language/Views/frontend/switcher.blade.php)12bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        rows
        4
        list_location
        5
        hotel_min_max_price
        6
        markers
        7
        blank
        8
        seo_meta
        9
        attributes
        10
        layout
        11
        bg
      • Layout::parts.header (modules/Layout/parts/header.blade.php)12bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        rows
        4
        list_location
        5
        hotel_min_max_price
        6
        markers
        7
        blank
        8
        seo_meta
        9
        attributes
        10
        layout
        11
        bg
      • Core::frontend.currency-switcher (themes/BC/Core/Views/frontend/currency-switcher.blade.php)14bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        rows
        4
        list_location
        5
        hotel_min_max_price
        6
        markers
        7
        blank
        8
        seo_meta
        9
        attributes
        10
        layout
        11
        bg
        12
        logo_id
        13
        logo
      • Language::frontend.switcher (themes/BC/Language/Views/frontend/switcher.blade.php)14bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        rows
        4
        list_location
        5
        hotel_min_max_price
        6
        markers
        7
        blank
        8
        seo_meta
        9
        attributes
        10
        layout
        11
        bg
        12
        logo_id
        13
        logo
      • Layout::parts.footer (modules/Layout/parts/footer.blade.php)12bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        rows
        4
        list_location
        5
        hotel_min_max_price
        6
        markers
        7
        blank
        8
        seo_meta
        9
        attributes
        10
        layout
        11
        bg
      • Layout::parts.login-register-modal (modules/Layout/parts/login-register-modal.blade.php)17bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        rows
        4
        list_location
        5
        hotel_min_max_price
        6
        markers
        7
        blank
        8
        seo_meta
        9
        attributes
        10
        layout
        11
        bg
        12
        list_widget_footers
        13
        __currentLoopData
        14
        item
        15
        key
        16
        loop
      • Layout::auth.login-form (modules/Layout/auth/login-form.blade.php)17bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        rows
        4
        list_location
        5
        hotel_min_max_price
        6
        markers
        7
        blank
        8
        seo_meta
        9
        attributes
        10
        layout
        11
        bg
        12
        list_widget_footers
        13
        __currentLoopData
        14
        item
        15
        key
        16
        loop
      • Layout::auth.register-form (modules/Layout/auth/register-form.blade.php)17bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        rows
        4
        list_location
        5
        hotel_min_max_price
        6
        markers
        7
        blank
        8
        seo_meta
        9
        attributes
        10
        layout
        11
        bg
        12
        list_widget_footers
        13
        __currentLoopData
        14
        item
        15
        key
        16
        loop
      • Popup::frontend.popup (themes/Base/Popup/Views/frontend/popup.blade.php)17bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        rows
        4
        list_location
        5
        hotel_min_max_price
        6
        markers
        7
        blank
        8
        seo_meta
        9
        attributes
        10
        layout
        11
        bg
        12
        list_widget_footers
        13
        __currentLoopData
        14
        item
        15
        key
        16
        loop
      • Layout::parts.cookie-consent-init (modules/Layout/parts/cookie-consent-init.blade.php)17bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        rows
        4
        list_location
        5
        hotel_min_max_price
        6
        markers
        7
        blank
        8
        seo_meta
        9
        attributes
        10
        layout
        11
        bg
        12
        list_widget_footers
        13
        __currentLoopData
        14
        item
        15
        key
        16
        loop
      uri
      GET hotel
      middleware
      web
      controller
      Modules\Hotel\Controllers\HotelController@index
      namespace
      Modules\Hotel\Controllers
      prefix
      /hotel
      where
      as
      hotel.search
      file
      modules/Hotel/Controllers/HotelController.php:37-108
      17 statements were executed, 4 of which were duplicated, 13 unique. Show only duplicated17.71ms
      • select count(*) as aggregate from (select `bravo_hotels`.* from `bravo_hotels` where `bravo_hotels`.`status` = 'publish' and `bravo_hotels`.`deleted_at` is null group by `bravo_hotels`.`id`) as `aggregate_table`4.81ms/modules/Hotel/Controllers/HotelController.php:54u758002481_asfarbayt2
        Metadata
        Bindings
        • 0. publish
        Backtrace
        • 15. /modules/Hotel/Controllers/HotelController.php:54
        • 16. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 17. /modules/Hotel/Controllers/HotelController.php:34
        • 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
        • 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
      • select `bravo_hotels`.* from `bravo_hotels` where `bravo_hotels`.`status` = 'publish' and `bravo_hotels`.`deleted_at` is null group by `bravo_hotels`.`id` order by `is_featured` desc, `id` desc limit 9 offset 0850μs/modules/Hotel/Controllers/HotelController.php:54u758002481_asfarbayt2
        Metadata
        Bindings
        • 0. publish
        Backtrace
        • 15. /modules/Hotel/Controllers/HotelController.php:54
        • 16. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 17. /modules/Hotel/Controllers/HotelController.php:34
        • 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
        • 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
      • select * from `bravo_locations` where `bravo_locations`.`id` in (11) and `bravo_locations`.`deleted_at` is null520μs/modules/Hotel/Controllers/HotelController.php:54u758002481_asfarbayt2
        Metadata
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 20. /modules/Hotel/Controllers/HotelController.php:54
        • 21. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 22. /modules/Hotel/Controllers/HotelController.php:34
        • 23. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
        • 24. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
      • select * from `bravo_location_translations` where `locale` = 'ar' and `bravo_location_translations`.`origin_id` in (11)390μs/modules/Hotel/Controllers/HotelController.php:54u758002481_asfarbayt2
        Metadata
        Bindings
        • 0. ar
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 25. /modules/Hotel/Controllers/HotelController.php:54
        • 26. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 27. /modules/Hotel/Controllers/HotelController.php:34
        • 28. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
        • 29. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
      • select * from `user_wishlist` where `object_model` = 'hotel' and `user_id` = 0 and `user_wishlist`.`object_id` in (22, 23, 24, 25, 26, 27, 28, 29, 30)360μs/modules/Hotel/Controllers/HotelController.php:54u758002481_asfarbayt2
        Metadata
        Bindings
        • 0. hotel
        • 1. 0
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 20. /modules/Hotel/Controllers/HotelController.php:54
        • 21. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 22. /modules/Hotel/Controllers/HotelController.php:34
        • 23. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
        • 24. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
      • select * from `bravo_hotel_translations` where `locale` = 'ar' and `bravo_hotel_translations`.`origin_id` in (22, 23, 24, 25, 26, 27, 28, 29, 30) and `bravo_hotel_translations`.`deleted_at` is null690μs/modules/Hotel/Controllers/HotelController.php:54u758002481_asfarbayt2
        Metadata
        Bindings
        • 0. ar
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 20. /modules/Hotel/Controllers/HotelController.php:54
        • 21. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 22. /modules/Hotel/Controllers/HotelController.php:34
        • 23. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
        • 24. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
      • select `bravo_terms`.*, `bravo_hotel_term`.`target_id` as `laravel_through_key` from `bravo_terms` inner join `bravo_hotel_term` on `bravo_hotel_term`.`term_id` = `bravo_terms`.`id` where `bravo_terms`.`attr_id` = '6' and `bravo_hotel_term`.`target_id` in (22, 23, 24, 25, 26, 27, 28, 29, 30) and `bravo_terms`.`deleted_at` is null950μs/modules/Hotel/Controllers/HotelController.php:54u758002481_asfarbayt2
        Metadata
        Bindings
        • 0. 6
        Backtrace
        • 19. /modules/Hotel/Controllers/HotelController.php:54
        • 20. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 21. /modules/Hotel/Controllers/HotelController.php:34
        • 22. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
        • 23. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
      • select * from `bravo_terms_translations` where `locale` = 'ar' and `bravo_terms_translations`.`origin_id` in (42, 43, 44, 45, 46, 47, 48)400μs/modules/Hotel/Controllers/HotelController.php:54u758002481_asfarbayt2
        Metadata
        Bindings
        • 0. ar
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 24. /modules/Hotel/Controllers/HotelController.php:54
        • 25. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 26. /modules/Hotel/Controllers/HotelController.php:34
        • 27. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
        • 28. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
      • select * from `bravo_locations` where `status` = 'publish' and `bravo_locations`.`deleted_at` is null limit 1000390μs/modules/Hotel/Controllers/HotelController.php:91u758002481_asfarbayt2
        Metadata
        Bindings
        • 0. 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
        • 14. /modules/Hotel/Controllers/HotelController.php:91
        • 15. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 16. /modules/Hotel/Controllers/HotelController.php:34
        • 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
        • 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
      • select * from `bravo_location_translations` where `locale` = 'ar' and `bravo_location_translations`.`origin_id` in (11)360μs/modules/Hotel/Controllers/HotelController.php:91u758002481_asfarbayt2
        Metadata
        Bindings
        • 0. ar
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 19. /modules/Hotel/Controllers/HotelController.php:91
        • 20. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 21. /modules/Hotel/Controllers/HotelController.php:34
        • 22. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
        • 23. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
      • select MIN( price ) AS min_price , MAX( price ) AS max_price from `bravo_hotels` where `status` = 'publish' and `bravo_hotels`.`deleted_at` is null limit 1340μs/modules/Hotel/Models/Hotel.php:606u758002481_asfarbayt2
        Metadata
        Bindings
        • 0. publish
        Hints
        • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
        Backtrace
        • 15. /modules/Hotel/Models/Hotel.php:606
        • 16. /modules/Hotel/Controllers/HotelController.php:92
        • 17. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 18. /modules/Hotel/Controllers/HotelController.php:34
        • 19. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • select * from `bravo_attrs` where `service` = 'hotel' and `bravo_attrs`.`deleted_at` is null order by `position` desc520μs/modules/Hotel/Controllers/HotelController.php:99u758002481_asfarbayt2
        Metadata
        Bindings
        • 0. hotel
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 14. /modules/Hotel/Controllers/HotelController.php:99
        • 15. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 16. /modules/Hotel/Controllers/HotelController.php:34
        • 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
        • 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
      • select `bravo_terms`.*, (select count(*) from `bravo_hotels` inner join `bravo_hotel_term` on `bravo_hotels`.`id` = `bravo_hotel_term`.`target_id` where `bravo_terms`.`id` = `bravo_hotel_term`.`term_id` and `bravo_hotels`.`deleted_at` is null) as `hotel_count` from `bravo_terms` where `bravo_terms`.`attr_id` in (5, 6, 7) and `bravo_terms`.`deleted_at` is null3.92ms/modules/Hotel/Controllers/HotelController.php:99u758002481_asfarbayt2
        Metadata
        Backtrace
        • 19. /modules/Hotel/Controllers/HotelController.php:99
        • 20. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 21. /modules/Hotel/Controllers/HotelController.php:34
        • 22. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
        • 23. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
      • select * from `bravo_terms_translations` where `locale` = 'ar' and `bravo_terms_translations`.`origin_id` in (32, 33, 34, 35, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55)1.78ms/modules/Hotel/Controllers/HotelController.php:99u758002481_asfarbayt2
        Metadata
        Bindings
        • 0. ar
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 24. /modules/Hotel/Controllers/HotelController.php:99
        • 25. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 26. /modules/Hotel/Controllers/HotelController.php:34
        • 27. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
        • 28. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
      • select * from `bravo_attrs_translations` where `locale` = 'ar' and `bravo_attrs_translations`.`origin_id` in (5, 6, 7)400μs/modules/Hotel/Controllers/HotelController.php:99u758002481_asfarbayt2
        Metadata
        Bindings
        • 0. ar
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 19. /modules/Hotel/Controllers/HotelController.php:99
        • 20. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 21. /modules/Hotel/Controllers/HotelController.php:34
        • 22. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
        • 23. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
      • select * from `core_menu_translations` where `core_menu_translations`.`origin_id` = 1 and `core_menu_translations`.`origin_id` is not null and `locale` = 'ar' limit 1590μs/app/Traits/HasTranslations.php:51u758002481_asfarbayt2
        Metadata
        Bindings
        • 0. 1
        • 1. ar
        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_menu_translations` where `core_menu_translations`.`origin_id` = 1 and `core_menu_translations`.`origin_id` is not null and `locale` = 'ar' limit 1440μs/app/Traits/HasTranslations.php:51u758002481_asfarbayt2
        Metadata
        Bindings
        • 0. 1
        • 1. ar
        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
      Modules\Core\Models\MenuTranslation
      2
      Modules\Core\Models\Attributes
      3
      Modules\Core\Models\Terms
      73
      Modules\Hotel\Models\HotelTranslation
      9
      Modules\Location\Models\LocationTranslation
      2
      Modules\Location\Models\Location
      2
      Modules\Hotel\Models\Hotel
      10
      web
      null
      sanctum
      null
        _token
        kQ2Faj5gTP4OpmhqGRAFaXrD2QOa56uqPXRO7629
        bc_current_currency
        eur
        _previous
        array:1 [ "url" => "https://asfarbayt.com/hotel" ]
        _flash
        array:2 [ "old" => [] "new" => [] ]
        PHPDEBUGBAR_STACK_DATA
        []
        path_info
        /hotel
        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=eyJpdiI6IkdkRWJsVmlWUVkycmVGVk5mbDVuRUE9PSIsInZhbHVlIjoialNmMGZOTnZ2SlB0aVpwSE16KzZFSEZNdU5HcGRiSloyRDB6MmRRZk5TNlhGbFRUa2tKcmxzMnZTMTlwV2NMcFJBZzVhNDVpSG5jaXZySWY2bDJHbkpBTjBOM3pHNjg5aFdnOWkyMU5JSkhjRWpkT1NYYmMrRmRTaC8vRWROOVQiLCJtYWMiOiI0MzQyZDFhYTQyZDlkZGU4MGI4MjhkMmFiNjM5ZjkwNWVkNmI5ZTcyMThkNWQzM2ExMjM5Yjg5ZjE4NWFiYmIwIiwidGFnIjoiIn0%3D; asfarbayt_session=eyJpdiI6IlRqVFJrbThWdFo2eERQQy9DMVNjYmc9PSIsInZhbHVlIjoiaFBpd2hhRzNsbmJnTXViUXE0Z25yQzdybDJSMk5MazZMckVEVkNjV2o5Nm9DWG5EMDFqK09ZZksrUzNqY2dxcDE1Vk1Ndk02T1hRRE1UQW1JRy9oOStGeTdlbFMyckp5aTV6c0htUDBuaDlHS1pGOFQ3dGMrc1dKeEVpSlVpY3AiLCJtYWMiOiIxYjQyZTFmYTBjYjA1ZDgzMjVjMWRjMjhlYjg3YjBiNDYxZDc3Nzk3NTdkODE5OTNlNjFiYzhiYTU4MmYxNDQ2IiwidGFnIjoiIn0%3DXSRF-TOKEN=eyJpdiI6IkdkRWJsVmlWUVkycmVGVk5mbDVuRUE9PSIsInZhbHVlIjoialNmMGZOTnZ2SlB0aVpwSE16KzZFSEZNdU5HcGRiSloyRDB6MmRRZk5TNlhGbFRUa2tKcmxzMnZTMTlwV2NMcFJBZzVhN" ] "host" => array:1 [ 0 => "asfarbayt.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.116.80.128" ] "x-forwarded-proto" => array:1 [ 0 => "https" ] "x-real-ip" => array:1 [ 0 => "18.116.80.128" ] "x-real-port" => array:1 [ 0 => "36949" ] "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=eyJpdiI6IkdkRWJsVmlWUVkycmVGVk5mbDVuRUE9PSIsInZhbHVlIjoialNmMGZOTnZ2SlB0aVpwSE16KzZFSEZNdU5HcGRiSloyRDB6MmRRZk5TNlhGbFRUa2tKcmxzMnZTMTlwV2NMcFJBZzVhNDVpSG5jaXZySWY2bDJHbkpBTjBOM3pHNjg5aFdnOWkyMU5JSkhjRWpkT1NYYmMrRmRTaC8vRWROOVQiLCJtYWMiOiI0MzQyZDFhYTQyZDlkZGU4MGI4MjhkMmFiNjM5ZjkwNWVkNmI5ZTcyMThkNWQzM2ExMjM5Yjg5ZjE4NWFiYmIwIiwidGFnIjoiIn0%3D; asfarbayt_session=eyJpdiI6IlRqVFJrbThWdFo2eERQQy9DMVNjYmc9PSIsInZhbHVlIjoiaFBpd2hhRzNsbmJnTXViUXE0Z25yQzdybDJSMk5MazZMckVEVkNjV2o5Nm9DWG5EMDFqK09ZZksrUzNqY2dxcDE1Vk1Ndk02T1hRRE1UQW1JRy9oOStGeTdlbFMyckp5aTV6c0htUDBuaDlHS1pGOFQ3dGMrc1dKeEVpSlVpY3AiLCJtYWMiOiIxYjQyZTFmYTBjYjA1ZDgzMjVjMWRjMjhlYjg3YjBiNDYxZDc3Nzk3NTdkODE5OTNlNjFiYzhiYTU4MmYxNDQ2IiwidGFnIjoiIn0%3DXSRF-TOKEN=eyJpdiI6IkdkRWJsVmlWUVkycmVGVk5mbDVuRUE9PSIsInZhbHVlIjoialNmMGZOTnZ2SlB0aVpwSE16KzZFSEZNdU5HcGRiSloyRDB6MmRRZk5TNlhGbFRUa2tKcmxzMnZTMTlwV2NMcFJBZzVhN" "HTTP_HOST" => "asfarbayt.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.116.80.128" "HTTP_X_FORWARDED_PROTO" => "https" "HTTP_X_REAL_IP" => "18.116.80.128" "HTTP_X_REAL_PORT" => "36949" "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/u758002481/domains/asfarbayt.com/public_html" "REMOTE_ADDR" => "18.116.80.128" "REMOTE_PORT" => "16852" "SERVER_ADDR" => "2a02:4780:b:865:0:2d2e:3331:4" "SERVER_NAME" => "asfarbayt.com" "SERVER_ADMIN" => "" "SERVER_PORT" => "443" "REQUEST_SCHEME" => "https" "REQUEST_URI" => "/hotel" "REDIRECT_URL" => "/public/hotel" "REDIRECT_REQUEST_METHOD" => "GET" "PROXY_REMOTE_ADDR" => "2a02:4780:2c:d::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/u758002481/domains/asfarbayt.com/public_html/public/index.php" "QUERY_STRING" => "" "SCRIPT_URI" => "https://asfarbayt.com/hotel" "SCRIPT_URL" => "/hotel" "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" => 1736750806.7581 "REQUEST_TIME" => 1736750806 ]
        request_cookies
        0 of 0
        array:2 [ "XSRF-TOKEN" => "kQ2Faj5gTP4OpmhqGRAFaXrD2QOa56uqPXRO7629" "asfarbayt_session" => "RXvXfVr8TSo5036mhRKWUWUhHl7HIY9aXxUAjCB7" ]
        response_headers
        0 of 0
        array:5 [ "content-type" => array:1 [ 0 => "text/html; charset=UTF-8" ] "cache-control" => array:1 [ 0 => "no-cache, private" ] "date" => array:1 [ 0 => "Mon, 13 Jan 2025 06:46:46 GMT" ] "set-cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6Ii9OUGlnemxRb1NXaVBVaEJDZ0wyQlE9PSIsInZhbHVlIjoiRGo4TnU4a2RLRjA2V01oWHRxR2dkNFpaM3pCdHFvVTFIMlVZWTRoeExMTlF1NUszRDhaNExwQVEvYWJiNytDeVJPZU8yYThWUld6aVNkVk5MSmc3NENKQXlscFRCOGxYaFV6Z2tyU2FCYkNYNTRRUVRqMXFJTzFHSHNVOWhhNy8iLCJtYWMiOiI0ZDIyZDIzNjk2YTEwYmU4NWIxYjdhNjQwNjE5NDE4Zjk4NTc0NDM4MWYxZGIxMzQxZTkwOTEzNDFhNGI1YWY1IiwidGFnIjoiIn0%3D; expires=Mon, 13 Jan 2025 08:46:47 GMT; Max-Age=7200; path=/; samesite=laxXSRF-TOKEN=eyJpdiI6Ii9OUGlnemxRb1NXaVBVaEJDZ0wyQlE9PSIsInZhbHVlIjoiRGo4TnU4a2RLRjA2V01oWHRxR2dkNFpaM3pCdHFvVTFIMlVZWTRoeExMTlF1NUszRDhaNExwQVEvYWJiNytDeVJPZU8yY" 1 => "asfarbayt_session=eyJpdiI6InZDdDZPMXR4M25lYTUreEJzandNRFE9PSIsInZhbHVlIjoiV01tc25INGZsWnRoNDJwWVJrbWY5d05JeUNwaHNJTHlXM09BOGNUdm8yZ0MxQ0xTK1RaeEl3UFc3THQybWF3RWRaNk5aaEx6RUxLWllCRDZkY0tUZktPcXhBT1pTT1pwUk9RWmZraW41eHZuRzk2RDBDcE41S01BUjRlSG9OaisiLCJtYWMiOiIxM2FlMmQxZjJmMzRiOTY0OWQwODkwNGFiZWI2MzI3ODc3ZWM4MTc4NTg4NTNhMjVjNTFmMWU2NTRmMWFlZDVhIiwidGFnIjoiIn0%3D; expires=Mon, 13 Jan 2025 08:46:47 GMT; Max-Age=7200; path=/; httponly; samesite=laxasfarbayt_session=eyJpdiI6InZDdDZPMXR4M25lYTUreEJzandNRFE9PSIsInZhbHVlIjoiV01tc25INGZsWnRoNDJwWVJrbWY5d05JeUNwaHNJTHlXM09BOGNUdm8yZ0MxQ0xTK1RaeEl3UFc3THQybWF3RW" ] "Set-Cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6Ii9OUGlnemxRb1NXaVBVaEJDZ0wyQlE9PSIsInZhbHVlIjoiRGo4TnU4a2RLRjA2V01oWHRxR2dkNFpaM3pCdHFvVTFIMlVZWTRoeExMTlF1NUszRDhaNExwQVEvYWJiNytDeVJPZU8yYThWUld6aVNkVk5MSmc3NENKQXlscFRCOGxYaFV6Z2tyU2FCYkNYNTRRUVRqMXFJTzFHSHNVOWhhNy8iLCJtYWMiOiI0ZDIyZDIzNjk2YTEwYmU4NWIxYjdhNjQwNjE5NDE4Zjk4NTc0NDM4MWYxZGIxMzQxZTkwOTEzNDFhNGI1YWY1IiwidGFnIjoiIn0%3D; expires=Mon, 13-Jan-2025 08:46:47 GMT; path=/XSRF-TOKEN=eyJpdiI6Ii9OUGlnemxRb1NXaVBVaEJDZ0wyQlE9PSIsInZhbHVlIjoiRGo4TnU4a2RLRjA2V01oWHRxR2dkNFpaM3pCdHFvVTFIMlVZWTRoeExMTlF1NUszRDhaNExwQVEvYWJiNytDeVJPZU8yY" 1 => "asfarbayt_session=eyJpdiI6InZDdDZPMXR4M25lYTUreEJzandNRFE9PSIsInZhbHVlIjoiV01tc25INGZsWnRoNDJwWVJrbWY5d05JeUNwaHNJTHlXM09BOGNUdm8yZ0MxQ0xTK1RaeEl3UFc3THQybWF3RWRaNk5aaEx6RUxLWllCRDZkY0tUZktPcXhBT1pTT1pwUk9RWmZraW41eHZuRzk2RDBDcE41S01BUjRlSG9OaisiLCJtYWMiOiIxM2FlMmQxZjJmMzRiOTY0OWQwODkwNGFiZWI2MzI3ODc3ZWM4MTc4NTg4NTNhMjVjNTFmMWU2NTRmMWFlZDVhIiwidGFnIjoiIn0%3D; expires=Mon, 13-Jan-2025 08:46:47 GMT; path=/; httponlyasfarbayt_session=eyJpdiI6InZDdDZPMXR4M25lYTUreEJzandNRFE9PSIsInZhbHVlIjoiV01tc25INGZsWnRoNDJwWVJrbWY5d05JeUNwaHNJTHlXM09BOGNUdm8yZ0MxQ0xTK1RaeEl3UFc3THQybWF3RW" ] ]
        session_attributes
        0 of 0
        array:5 [ "_token" => "kQ2Faj5gTP4OpmhqGRAFaXrD2QOa56uqPXRO7629" "bc_current_currency" => "eur" "_previous" => array:1 [ "url" => "https://asfarbayt.com/hotel" ] "_flash" => array:2 [ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]
        2025-01-13 - 2025-01-14