Rechercher un hôtel

FILTER BY

Filter Price

$0 $1000255075100

Hotel Star

Review Score

Property type

Facilities

Hotel Service

Hotel not found
Request history8.1.14PHP Version1.29sRequest Duration5MBMemory UsageGET fr/hotelRouteAuth status
    • Booting (785ms)time
    • Application (506ms)time
    • 1 x Booting (60.82%)
      785ms
      1 x Application (39.18%)
      506ms
      29 templates were rendered
      • 1x Hotel::frontend.searchsearch.blade.php#?blade
      • 1x Hotel::frontend.layouts.search.form-searchform-search.blade.php#?blade
      • 1x Hotel::frontend.layouts.search.fields.locationlocation.blade.php#?blade
      • 1x Hotel::frontend.layouts.search.fields.datedate.blade.php#?blade
      • 1x Hotel::frontend.layouts.search.fields.guestsguests.blade.php#?blade
      • 1x Hotel::frontend.layouts.search.list-itemlist-item.blade.php#?blade
      • 1x Hotel::frontend.layouts.search.filter-searchfilter-search.blade.php#?blade
      • 1x Layout::global.search.filters.attrsattrs.blade.php#?blade
      • 1x Layout::global.search.orderbyorderby.blade.php#?blade
      • 1x Hotel::frontend.ajax.search-resultsearch-result.blade.php#?blade
      • 1x pagination::tailwindtailwind.blade.php#?blade
      • 1x vendor.pagination.defaultdefault.blade.php#?blade
      • 1x layouts.appapp.blade.php#?blade
      • 1x Layout::appapp.blade.php#?blade
      • 1x Layout::parts.faviconfavicon.blade.php#?blade
      • 1x Layout::parts.seo-metaseo-meta.blade.php#?blade
      • 1x Layout::parts.global-scriptglobal-script.blade.php#?blade
      • 1x Layout::parts.topbartopbar.blade.php#?blade
      • 2x Core::frontend.currency-switchercurrency-switcher.blade.php#?blade
      • 2x Language::frontend.switcherswitcher.blade.php#?blade
      • 1x Layout::parts.headerheader.blade.php#?blade
      • 1x Layout::parts.footerfooter.blade.php#?blade
      • 1x Layout::parts.login-register-modallogin-register-modal.blade.php#?blade
      • 1x Layout::auth.login-formlogin-form.blade.php#?blade
      • 1x Layout::auth.register-formregister-form.blade.php#?blade
      • 1x Popup::frontend.popuppopup.blade.php#?blade
      • 1x demo_scriptdemo_script.blade.php#?blade
      uri
      GET fr/hotel
      middleware
      web
      controller
      Modules\Hotel\Controllers\HotelController@index
      namespace
      Modules\Hotel\Controllers
      prefix
      fr/hotel
      where
      as
      hotel.search
      file
      modules/Hotel/Controllers/HotelController.php:37-104
      10 statements were executed, 2 of which were duplicates, 8 unique. Show only duplicated59.66ms
      • 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`19.18msraholidayHotelController.php#54
        Bindings
        • 0: publish
        Backtrace
        • 16. modules/Hotel/Controllers/HotelController.php:54
        • 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
        • 20. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
      • select * from `bravo_locations` where `status` = 'publish' and `bravo_locations`.`deleted_at` is null limit 10006.33msraholidayHotelController.php#87
        Bindings
        • 0: publish
        Hints
        • 0: Use SELECT * only if you need all columns from table
        • 1: LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
        Backtrace
        • 15. modules/Hotel/Controllers/HotelController.php:87
        • 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_location_translations` where `locale` = 'fr' and `bravo_location_translations`.`origin_id` in (1, 2, 3, 4, 5, 6)8.12msraholidayHotelController.php#87
        Bindings
        • 0: fr
        Hints
        • 0: Use SELECT * only if you need all columns from table
        Backtrace
        • 20. modules/Hotel/Controllers/HotelController.php:87
        • 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 MIN( price ) AS min_price , MAX( price ) AS max_price from `bravo_hotels` where `status` = 'publish' and `bravo_hotels`.`deleted_at` is null limit 18.37msraholidayHotel.php#606
        Bindings
        • 0: publish
        Hints
        • 0: LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
        Backtrace
        • 16. modules/Hotel/Models/Hotel.php:606
        • 17. modules/Hotel/Controllers/HotelController.php:88
        • 18. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 19. modules/Hotel/Controllers/HotelController.php:34
        • 20. 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` asc2.3msraholidayHotelController.php#95
        Bindings
        • 0: hotel
        Hints
        • 0: Use SELECT * only if you need all columns from table
        Backtrace
        • 15. modules/Hotel/Controllers/HotelController.php:95
        • 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_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 null4.09msraholidayHotelController.php#95
        Backtrace
        • 20. modules/Hotel/Controllers/HotelController.php:95
        • 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_terms_translations` where `locale` = 'fr' and `bravo_terms_translations`.`origin_id` in (32, 33, 34, 35, 36, 37, 38, 39, 40, 41, 42, 45, 46, 47, 48, 51, 53, 55, 93, 94, 95, 97, 98, 99, 100, 101, 102, 103, 104, 105, 106, 107, 108, 109, 110, 111, 112, 113, 114, 115, 116, 117, 118, 119, 120, 121, 122, 123, 124, 125, 146)1.02msraholidayHotelController.php#95
        Bindings
        • 0: fr
        Hints
        • 0: Use SELECT * only if you need all columns from table
        Backtrace
        • 25. modules/Hotel/Controllers/HotelController.php:95
        • 26. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 27. modules/Hotel/Controllers/HotelController.php:34
        • 28. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
        • 29. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
      • select * from `bravo_attrs_translations` where `locale` = 'fr' and `bravo_attrs_translations`.`origin_id` in (5, 6, 7)2.57msraholidayHotelController.php#95
        Bindings
        • 0: fr
        Hints
        • 0: Use SELECT * only if you need all columns from table
        Backtrace
        • 20. modules/Hotel/Controllers/HotelController.php:95
        • 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 `core_menu_translations` where `core_menu_translations`.`origin_id` = 1 and `core_menu_translations`.`origin_id` is not null and `locale` = 'fr' limit 12.58msraholidayHasTranslations.php#51
        Bindings
        • 0: 1
        • 1: fr
        Hints
        • 0: Use SELECT * only if you need all columns from table
        • 1: LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
        Backtrace
        • 21. app/Traits/HasTranslations.php:51
        • 22. app/Helpers/AppHelper.php:112
        • 25. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
        • 26. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 27. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
      • select * from `core_menu_translations` where `core_menu_translations`.`origin_id` = 1 and `core_menu_translations`.`origin_id` is not null and `locale` = 'fr' limit 15.1msraholidayHasTranslations.php#51
        Bindings
        • 0: 1
        • 1: fr
        Hints
        • 0: Use SELECT * only if you need all columns from table
        • 1: LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
        Backtrace
        • 21. app/Traits/HasTranslations.php:51
        • 22. app/Helpers/AppHelper.php:112
        • 25. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
        • 26. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 27. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
      Modules\Core\Models\Terms
      51Terms.php#?
      Modules\Location\Models\Location
      6Location.php#?
      Modules\Location\Models\LocationTranslation
      6LocationTranslation.php#?
      Modules\Core\Models\Attributes
      3Attributes.php#?
      Modules\Core\Models\MenuTranslation
      2MenuTranslation.php#?
      Modules\Hotel\Models\Hotel
      1Hotel.php#?
        web
        null
        sanctum
        null
          _token
          uhgEo6zK3rJQ7D0ZFW0ZjFYfAoUYZujN65J7YQWP
          _previous
          array:1 [ "url" => "https://raholiday.com/fr/hotel" ]
          _flash
          array:2 [ "old" => [] "new" => [] ]
          PHPDEBUGBAR_STACK_DATA
          []
          path_info
          /fr/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:16 [ "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 => "gzip, deflate, br, zstd" ] "cookie" => array:1 [ 0 => "XSRF-TOKEN=eyJpdiI6IjR3L1ZTVEthWDNwcEM4QSt5ZWQ2eGc9PSIsInZhbHVlIjoiMnVQcEFOTk5OcmwvRjVVSXVaMGFYdVRqc2RqVWtvU0J6dCt1ZHcyK3VvYVRkckhTTVhwVUY1RkpKT1AwZThCVTlJSFk4bWJ0MWhZcFlEN2JmRGRnNzJYUWVOSGNvN1YxM2NHb1ZGbFJNQ0pnV05nVXNhaDJiTEhicXNqZUlhWW8iLCJtYWMiOiJjZjZjODRhYjAwODdkNDY3NDc2YWU3MmVlYmY3ZDFiNThkNTE0ODQyYjVjMjU5NzA0NmFlNjE4ZjAwZmUzY2FhIiwidGFnIjoiIn0%3D; ra_holiday_session=eyJpdiI6InJudlIzZmM3blVEaDBpa0FJcERqR1E9PSIsInZhbHVlIjoiWTg3MWtmQjE0WHZwYkJSVk83c1pwZVB6WG5Id0d0Uis4QXphMUFrMTJOb3ZtWXhHbEppak1JU3VBR01raU1aWlpQanVvbVhMdlRKSmpGTU1uMnJqeGU5K3ZYYXlLYmxVeTZGYU90MFMvbU5MellaZ1l3ay80YXk0TXJjb09EekIiLCJtYWMiOiJmNzk1NWM1YmY2MDA1MjVmNmVjZmJiMTUyNTlmNDYwMGQ5NTg2MDk2YzM1YzhhM2Y4NmVhZTc1YWM3NDUwZWNhIiwidGFnIjoiIn0%3DXSRF-TOKEN=eyJpdiI6IjR3L1ZTVEthWDNwcEM4QSt5ZWQ2eGc9PSIsInZhbHVlIjoiMnVQcEFOTk5OcmwvRjVVSXVaMGFYdVRqc2RqVWtvU0J6dCt1ZHcyK3VvYVRkckhTTVhwVUY1RkpKT1AwZThCVTlJSFk4b" ] "host" => array:1 [ 0 => "raholiday.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" ] "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_cookies
          0 of 0
          array:2 [ "XSRF-TOKEN" => "uhgEo6zK3rJQ7D0ZFW0ZjFYfAoUYZujN65J7YQWP" "ra_holiday_session" => "KwNWVPixFyWmOWlX50TCK3nIQuiQ0Ritw9GcCfyX" ]
          response_headers
          0 of 0
          array:5 [ "content-type" => array:1 [ 0 => "text/html; charset=UTF-8" ] "cache-control" => array:1 [ 0 => "no-cache, private" ] "date" => array:1 [ 0 => "Sun, 06 Apr 2025 16:14:15 GMT" ] "set-cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6IllnTlZzaG9wRTd2dndTWlRpZDl6aHc9PSIsInZhbHVlIjoiaTNzVkt5MlJ5eEt2SEdITU9rR0c4cEthTWlXdzlDOG5Tc1VkSGNaZmNuRGNPbFZLd0NuUEVqNCt1UzNSU3V3MmlOMm9UbHF1ZFVkczltR0JCcTlsQkpkWnZRcXFrT3ZEUldONDhWd3JyZ3VsZm85LzBKZTJoWVZ4ckpHOUdJY1AiLCJtYWMiOiI4NmE4MTAzMDdjNjk2ZjcwNzdlOGUyZDE2YzIwNTQzZTU4NzI2YTY5OTk4MzMwOGRlOWFmNGNmNjU2N2Q3MjY0IiwidGFnIjoiIn0%3D; expires=Sun, 06 Apr 2025 18:14:15 GMT; Max-Age=7200; path=/; secure; samesite=laxXSRF-TOKEN=eyJpdiI6IllnTlZzaG9wRTd2dndTWlRpZDl6aHc9PSIsInZhbHVlIjoiaTNzVkt5MlJ5eEt2SEdITU9rR0c4cEthTWlXdzlDOG5Tc1VkSGNaZmNuRGNPbFZLd0NuUEVqNCt1UzNSU3V3MmlOMm9Ub" 1 => "ra_holiday_session=eyJpdiI6InNjUjF3QzdsVzB4RGtnSE15eHlvTGc9PSIsInZhbHVlIjoibU0zdE0yK3pVOGRSZ2E0UlB5WkhHZjhPc1U5Tk9CR05rOEUzQnAyZDE4M2N3b3BuckJrN1F2T0dneGlNWU01Z1d5NmlRMkRXcUdxTU1NMEZ2SVREM0lpYStXeXV5Qm9PYUpYbjA5a2Z1bGRsYWdtSUpnMGJoUzhZeFdvZko5cEsiLCJtYWMiOiJhM2E0MTlmMWY0ZTA2YzFjNGVkZTc2YTllYzZjZDg4YmU0ZjViOTVkNTZlNGM0YmFmZmEzZDAyMmQ5MDY2NThhIiwidGFnIjoiIn0%3D; expires=Sun, 06 Apr 2025 18:14:15 GMT; Max-Age=7200; path=/; httponly; samesite=laxra_holiday_session=eyJpdiI6InNjUjF3QzdsVzB4RGtnSE15eHlvTGc9PSIsInZhbHVlIjoibU0zdE0yK3pVOGRSZ2E0UlB5WkhHZjhPc1U5Tk9CR05rOEUzQnAyZDE4M2N3b3BuckJrN1F2T0dneGlNWU01Z" ] "Set-Cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6IllnTlZzaG9wRTd2dndTWlRpZDl6aHc9PSIsInZhbHVlIjoiaTNzVkt5MlJ5eEt2SEdITU9rR0c4cEthTWlXdzlDOG5Tc1VkSGNaZmNuRGNPbFZLd0NuUEVqNCt1UzNSU3V3MmlOMm9UbHF1ZFVkczltR0JCcTlsQkpkWnZRcXFrT3ZEUldONDhWd3JyZ3VsZm85LzBKZTJoWVZ4ckpHOUdJY1AiLCJtYWMiOiI4NmE4MTAzMDdjNjk2ZjcwNzdlOGUyZDE2YzIwNTQzZTU4NzI2YTY5OTk4MzMwOGRlOWFmNGNmNjU2N2Q3MjY0IiwidGFnIjoiIn0%3D; expires=Sun, 06-Apr-2025 18:14:15 GMT; path=/; secureXSRF-TOKEN=eyJpdiI6IllnTlZzaG9wRTd2dndTWlRpZDl6aHc9PSIsInZhbHVlIjoiaTNzVkt5MlJ5eEt2SEdITU9rR0c4cEthTWlXdzlDOG5Tc1VkSGNaZmNuRGNPbFZLd0NuUEVqNCt1UzNSU3V3MmlOMm9Ub" 1 => "ra_holiday_session=eyJpdiI6InNjUjF3QzdsVzB4RGtnSE15eHlvTGc9PSIsInZhbHVlIjoibU0zdE0yK3pVOGRSZ2E0UlB5WkhHZjhPc1U5Tk9CR05rOEUzQnAyZDE4M2N3b3BuckJrN1F2T0dneGlNWU01Z1d5NmlRMkRXcUdxTU1NMEZ2SVREM0lpYStXeXV5Qm9PYUpYbjA5a2Z1bGRsYWdtSUpnMGJoUzhZeFdvZko5cEsiLCJtYWMiOiJhM2E0MTlmMWY0ZTA2YzFjNGVkZTc2YTllYzZjZDg4YmU0ZjViOTVkNTZlNGM0YmFmZmEzZDAyMmQ5MDY2NThhIiwidGFnIjoiIn0%3D; expires=Sun, 06-Apr-2025 18:14:15 GMT; path=/; httponlyra_holiday_session=eyJpdiI6InNjUjF3QzdsVzB4RGtnSE15eHlvTGc9PSIsInZhbHVlIjoibU0zdE0yK3pVOGRSZ2E0UlB5WkhHZjhPc1U5Tk9CR05rOEUzQnAyZDE4M2N3b3BuckJrN1F2T0dneGlNWU01Z" ] ]
          session_attributes
          0 of 0
          array:4 [ "_token" => "uhgEo6zK3rJQ7D0ZFW0ZjFYfAoUYZujN65J7YQWP" "_previous" => array:1 [ "url" => "https://raholiday.com/fr/hotel" ] "_flash" => array:2 [ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]
          ClearShow all
          Date ↕MethodURLData
          #12025-04-06 16:14:15GET/fr/hotel291069
          2025-04-06 - 2025-04-07