Parian Holiday Villas

Regal Cinemas Battery Park

Excellent from 3 reviews
4.7/5
100% of guests recommend

Description

Built in 1986, Hotel Stanford is a distinct addition to New York (NY) and a smart choice for travelers. The excitement of the city center is only 0 KM away. No less exceptional is the hotel’s easy access to the city’s myriad attractions and landmarks, such as Toto Music Studio, British Virgin Islands Tourist Board, L’Atelier Du Chocolat. Start and end in San Francisco! With the in-depth cultural tour Northern California Summer 2019, you have a 8 day tour package taking you through San Francisco, USA and 9 other destinations in USA. Northern California Summer 2019 includes accommodation as well as an expert guide, meals, transport and more.

HIGHLIGHTS

  • Visit the Museum of Modern Art in Manhattan
  • See amazing works of contemporary art, including Vincent van Gogh's The Starry Night
  • Check out Campbell's Soup Cans by Warhol and The Dance (I) by Matisse
  • Behold masterpieces by Gauguin, Dali, Picasso, and Pollock
  • Enjoy free audio guides available in English, French, German, Italian, Spanish, Portuguese

Available Rooms

Property type

Apartments
Hotels
Homestays
Villas
Boats
Motels
Resorts
Holiday homes
Cruises

Facilities

Wake-up call
Car hire
Bicycle hire
Flat Tv
Laundry and dry cleaning
Internet – Wifi
Coffee and tea

Hotel Service

Havana Lobby bar
Fiesta Restaurant
Hotel transport services
Pets welcome
Tickets

Rules

Check In
12:00AM
Check Out
11:00AM
Hotel Policies
Guarantee Policy
- A valid credit card will be required upon booking; - For credit card reservations, the same card(s) must be presented upon check in at the respective hotels; - Management reserves the right to cancel any reservations without notice if we are notified of any fraud or illegal activities associated with the full payments received.
Children Policy
- Child under 5-year old: free of charge. - Child from 5-year old to under 12-year old: surcharge $10/person/room/night. - Child from 12-year old or extra Adult: surcharge $15/person/room/night.
Cancellation/Amendment Policy
- If cancellation/amendment is made 72 hours prior to your arrival date, no fee will be charged. - If cancellation/amendment is made within 72 hours, including reservations made within 72 hours of your arrival, 1st night’s room rate and tax will be charged - In case of no-show, 100% room rate and tax will be charged. - Early Bird/Long Stay/Last Min/Package Rates are Non - changeable & Non - refundable
Late check-out policy
- Late check-out is subject to room availability - 12:00 to 17:00 check-out: 50% room rate surcharge - After 17:00 check-out: 100% room rate surcharge
Show All

Location

Regal Cinemas Battery Park

Reviews

4.7/5
Excellent
Based on 3 reviews
Excellent
2
Very Good
1
Average
0
Poor
0
Terrible
0

05/28/2023 23:48

Good location, quality should be better

Eum eu sumo albucius perfecto, commodo torquatos consequuntur pro ut, id posse splendide ius. Cu nisl putent omittantur usu, mutat atomorum ex pro, ius nibh nonumy id. Nam at eius dissentias disputando, molestie mnesarchum complectitur per te

05/28/2023 23:48

Easy way to discover the city

Eum eu sumo albucius perfecto, commodo torquatos consequuntur pro ut, id posse splendide ius. Cu nisl putent omittantur usu, mutat atomorum ex pro, ius nibh nonumy id. Nam at eius dissentias disputando, molestie mnesarchum complectitur per te

05/28/2023 23:48

Good location, quality should be better

Eum eu sumo albucius perfecto, commodo torquatos consequuntur pro ut, id posse splendide ius. Cu nisl putent omittantur usu, mutat atomorum ex pro, ius nibh nonumy id. Nam at eius dissentias disputando, molestie mnesarchum complectitur per te
Showing 1 - 3 of 3 total
You must log in to write review

Wanisha Verified

Member Since Jun 2023

Property type

Apartments
Hotels
Homestays
Villas
Boats
Motels
Resorts
Holiday homes
Cruises

Facilities

Wake-up call
Car hire
Bicycle hire
Flat Tv
Laundry and dry cleaning
Internet – Wifi
Coffee and tea

Hotel Service

Havana Lobby bar
Fiesta Restaurant
Hotel transport services
Pets welcome
Tickets
8.3.19PHP Version595msRequest Duration5MBMemory UsageGET hotel/{slug}RouteAuth status
  • warninglog[04:32:33] LOG.warning: Creation of dynamic property Barryvdh\Debugbar\DataFormatter\QueryFormatter:...
  • warninglog[04:32:33] LOG.warning: Creation of dynamic property Barryvdh\Debugbar\DataFormatter\QueryFormatter:...
  • warninglog[04:32:33] LOG.warning: Creation of dynamic property Barryvdh\Debugbar\DataFormatter\SimpleFormatter...
  • warninglog[04:32:33] LOG.warning: Creation of dynamic property Barryvdh\Debugbar\DataFormatter\SimpleFormatter...
  • warninglog[04:32:33] LOG.warning: Creation of dynamic property HTMLPurifier_AttrTransform_NameSync::$idDef is ...
  • warninglog[04:32:33] LOG.warning: Creation of dynamic property HTMLPurifier_AttrTransform_NameSync::$idDef is ...
  • warninglog[04:32:33] LOG.warning: Creation of dynamic property HTMLPurifier_Lexer_DOMLex::$_entity_parser is d...
  • warninglog[04:32:33] LOG.warning: Creation of dynamic property HTMLPurifier_Lexer_DOMLex::$_entity_parser is d...
  • warninglog[04:32:33] LOG.warning: Creation of dynamic property HTMLPurifier_Lexer_DOMLex::$_entity_parser is d...
  • warninglog[04:32:33] LOG.warning: Creation of dynamic property HTMLPurifier_Lexer_DOMLex::$_entity_parser is d...
  • warninglog[04:32:33] LOG.warning: Creation of dynamic property HTMLPurifier_Lexer_DOMLex::$_entity_parser is d...
  • warninglog[04:32:33] LOG.warning: Creation of dynamic property HTMLPurifier_Lexer_DOMLex::$_entity_parser is d...
  • warninglog[04:32:33] LOG.warning: Creation of dynamic property HTMLPurifier_Lexer_DOMLex::$_entity_parser is d...
  • warninglog[04:32:33] LOG.warning: Creation of dynamic property HTMLPurifier_Lexer_DOMLex::$_entity_parser is d...
  • warninglog[04:32:33] LOG.warning: Creation of dynamic property HTMLPurifier_Lexer_DOMLex::$_entity_parser is d...
  • warninglog[04:32:33] LOG.warning: Creation of dynamic property HTMLPurifier_Lexer_DOMLex::$_entity_parser is d...
  • warninglog[04:32:33] LOG.warning: Creation of dynamic property HTMLPurifier_Lexer_DOMLex::$_entity_parser is d...
  • warninglog[04:32:33] LOG.warning: Creation of dynamic property HTMLPurifier_Lexer_DOMLex::$_entity_parser is d...
  • warninglog[04:32:33] LOG.warning: Creation of dynamic property HTMLPurifier_Lexer_DOMLex::$_entity_parser is d...
  • warninglog[04:32:33] LOG.warning: Creation of dynamic property HTMLPurifier_Lexer_DOMLex::$_entity_parser is d...
  • warninglog[04:32:33] LOG.warning: Creation of dynamic property HTMLPurifier_Lexer_DOMLex::$_entity_parser is d...
  • warninglog[04:32:33] LOG.warning: Creation of dynamic property HTMLPurifier_Lexer_DOMLex::$_entity_parser is d...
  • warninglog[04:32:33] LOG.warning: Creation of dynamic property HTMLPurifier_Lexer_DOMLex::$_entity_parser is d...
  • warninglog[04:32:33] LOG.warning: Creation of dynamic property HTMLPurifier_Lexer_DOMLex::$_entity_parser is d...
  • warninglog[04:32:33] LOG.warning: Creation of dynamic property HTMLPurifier_Lexer_DOMLex::$_entity_parser is d...
  • Booting (78.24ms)
  • Application (516ms)
  • 1 x Application (86.76%)
    516.41ms
    1 x Booting (13.14%)
    78.24ms
    32 templates were rendered
    • Hotel::frontend.detail (themes/BC/Hotel/Views/frontend/detail.blade.php)9blade
      Params
      0
      row
      1
      translation
      2
      hotel_related
      3
      location_category
      4
      booking_data
      5
      review_list
      6
      seo_meta
      7
      body_class
      8
      breadcrumbs
    • Layout::parts.bc (modules/Layout/parts/bc.blade.php)12blade
      Params
      0
      __env
      1
      app
      2
      errors
      3
      row
      4
      translation
      5
      hotel_related
      6
      location_category
      7
      booking_data
      8
      review_list
      9
      seo_meta
      10
      body_class
      11
      breadcrumbs
    • Hotel::frontend.layouts.details.hotel-banner (themes/BC/Hotel/Views/frontend/layouts/details/hotel-banner.blade.php)12blade
      Params
      0
      __env
      1
      app
      2
      errors
      3
      row
      4
      translation
      5
      hotel_related
      6
      location_category
      7
      booking_data
      8
      review_list
      9
      seo_meta
      10
      body_class
      11
      breadcrumbs
    • Hotel::frontend.layouts.details.hotel-detail (themes/BC/Hotel/Views/frontend/layouts/details/hotel-detail.blade.php)13blade
      Params
      0
      __env
      1
      app
      2
      errors
      3
      row
      4
      translation
      5
      hotel_related
      6
      location_category
      7
      booking_data
      8
      review_list
      9
      seo_meta
      10
      body_class
      11
      breadcrumbs
      12
      review_score
    • Hotel::frontend.layouts.details.hotel-rooms (themes/BC/Hotel/Views/frontend/layouts/details/hotel-rooms.blade.php)18blade
      Params
      0
      __env
      1
      app
      2
      errors
      3
      row
      4
      translation
      5
      hotel_related
      6
      location_category
      7
      booking_data
      8
      review_list
      9
      seo_meta
      10
      body_class
      11
      breadcrumbs
      12
      review_score
      13
      star
      14
      __currentLoopData
      15
      item
      16
      key
      17
      loop
    • Booking::frontend.global.enquiry-form (themes/BC/Booking/Views/frontend/global/enquiry-form.blade.php)19blade
      Params
      0
      __env
      1
      app
      2
      errors
      3
      row
      4
      translation
      5
      hotel_related
      6
      location_category
      7
      booking_data
      8
      review_list
      9
      seo_meta
      10
      body_class
      11
      breadcrumbs
      12
      review_score
      13
      star
      14
      __currentLoopData
      15
      item
      16
      key
      17
      loop
      18
      service_type
    • Hotel::frontend.layouts.details.hotel-attributes (themes/BC/Hotel/Views/frontend/layouts/details/hotel-attributes.blade.php)18blade
      Params
      0
      __env
      1
      app
      2
      errors
      3
      row
      4
      translation
      5
      hotel_related
      6
      location_category
      7
      booking_data
      8
      review_list
      9
      seo_meta
      10
      body_class
      11
      breadcrumbs
      12
      review_score
      13
      star
      14
      __currentLoopData
      15
      item
      16
      key
      17
      loop
    • Hotel::frontend.layouts.details.hotel-surrounding (themes/BC/Hotel/Views/frontend/layouts/details/hotel-surrounding.blade.php)18blade
      Params
      0
      __env
      1
      app
      2
      errors
      3
      row
      4
      translation
      5
      hotel_related
      6
      location_category
      7
      booking_data
      8
      review_list
      9
      seo_meta
      10
      body_class
      11
      breadcrumbs
      12
      review_score
      13
      star
      14
      __currentLoopData
      15
      item
      16
      key
      17
      loop
    • Hotel::frontend.layouts.details.hotel-review (themes/BC/Hotel/Views/frontend/layouts/details/hotel-review.blade.php)13blade
      Params
      0
      __env
      1
      app
      2
      errors
      3
      row
      4
      translation
      5
      hotel_related
      6
      location_category
      7
      booking_data
      8
      review_list
      9
      seo_meta
      10
      body_class
      11
      breadcrumbs
      12
      review_score
    • Review::frontend.form (themes/BC/Review/Views/frontend/form.blade.php)13blade
      Params
      0
      __env
      1
      app
      2
      errors
      3
      row
      4
      translation
      5
      hotel_related
      6
      location_category
      7
      booking_data
      8
      review_list
      9
      seo_meta
      10
      body_class
      11
      breadcrumbs
      12
      review_score
    • pagination::tailwind (resources/views/vendor/pagination/tailwind.blade.php)2blade
      Params
      0
      paginator
      1
      elements
    • vendor.pagination.default (resources/views/vendor/pagination/default.blade.php)5blade
      Params
      0
      __env
      1
      app
      2
      errors
      3
      paginator
      4
      elements
    • Tour::frontend.layouts.details.vendor (themes/BC/Tour/Views/frontend/layouts/details/vendor.blade.php)13blade
      Params
      0
      __env
      1
      app
      2
      errors
      3
      row
      4
      translation
      5
      hotel_related
      6
      location_category
      7
      booking_data
      8
      review_list
      9
      seo_meta
      10
      body_class
      11
      breadcrumbs
      12
      review_score
    • Hotel::frontend.layouts.details.hotel-form-enquiry (themes/BC/Hotel/Views/frontend/layouts/details/hotel-form-enquiry.blade.php)13blade
      Params
      0
      __env
      1
      app
      2
      errors
      3
      row
      4
      translation
      5
      hotel_related
      6
      location_category
      7
      booking_data
      8
      review_list
      9
      seo_meta
      10
      body_class
      11
      breadcrumbs
      12
      review_score
    • Hotel::frontend.layouts.details.hotel-related-list (themes/BC/Hotel/Views/frontend/layouts/details/hotel-related-list.blade.php)13blade
      Params
      0
      __env
      1
      app
      2
      errors
      3
      row
      4
      translation
      5
      hotel_related
      6
      location_category
      7
      booking_data
      8
      review_list
      9
      seo_meta
      10
      body_class
      11
      breadcrumbs
      12
      review_score
    • Hotel::frontend.layouts.details.hotel-attributes (themes/BC/Hotel/Views/frontend/layouts/details/hotel-attributes.blade.php)13blade
      Params
      0
      __env
      1
      app
      2
      errors
      3
      row
      4
      translation
      5
      hotel_related
      6
      location_category
      7
      booking_data
      8
      review_list
      9
      seo_meta
      10
      body_class
      11
      breadcrumbs
      12
      review_score
    • Hotel::frontend.layouts.details.hotel-form-enquiry-mobile (themes/BC/Hotel/Views/frontend/layouts/details/hotel-form-enquiry-mobile.blade.php)13blade
      Params
      0
      __env
      1
      app
      2
      errors
      3
      row
      4
      translation
      5
      hotel_related
      6
      location_category
      7
      booking_data
      8
      review_list
      9
      seo_meta
      10
      body_class
      11
      breadcrumbs
      12
      review_score
    • layouts.app (resources/views/layouts/app.blade.php)13blade
      Params
      0
      __env
      1
      app
      2
      errors
      3
      row
      4
      translation
      5
      hotel_related
      6
      location_category
      7
      booking_data
      8
      review_list
      9
      seo_meta
      10
      body_class
      11
      breadcrumbs
      12
      review_score
    • Layout::app (modules/Layout/app.blade.php)13blade
      Params
      0
      __env
      1
      app
      2
      errors
      3
      row
      4
      translation
      5
      hotel_related
      6
      location_category
      7
      booking_data
      8
      review_list
      9
      seo_meta
      10
      body_class
      11
      breadcrumbs
      12
      review_score
    • Layout::parts.seo-meta (modules/Layout/parts/seo-meta.blade.php)14blade
      Params
      0
      __env
      1
      app
      2
      errors
      3
      row
      4
      translation
      5
      hotel_related
      6
      location_category
      7
      booking_data
      8
      review_list
      9
      seo_meta
      10
      body_class
      11
      breadcrumbs
      12
      review_score
      13
      favicon
    • Layout::parts.global-script (modules/Layout/parts/global-script.blade.php)14blade
      Params
      0
      __env
      1
      app
      2
      errors
      3
      row
      4
      translation
      5
      hotel_related
      6
      location_category
      7
      booking_data
      8
      review_list
      9
      seo_meta
      10
      body_class
      11
      breadcrumbs
      12
      review_score
      13
      favicon
    • Layout::parts.topbar (modules/Layout/parts/topbar.blade.php)14blade
      Params
      0
      __env
      1
      app
      2
      errors
      3
      row
      4
      translation
      5
      hotel_related
      6
      location_category
      7
      booking_data
      8
      review_list
      9
      seo_meta
      10
      body_class
      11
      breadcrumbs
      12
      review_score
      13
      favicon
    • Core::frontend.currency-switcher (themes/BC/Core/Views/frontend/currency-switcher.blade.php)14blade
      Params
      0
      __env
      1
      app
      2
      errors
      3
      row
      4
      translation
      5
      hotel_related
      6
      location_category
      7
      booking_data
      8
      review_list
      9
      seo_meta
      10
      body_class
      11
      breadcrumbs
      12
      review_score
      13
      favicon
    • Language::frontend.switcher (themes/BC/Language/Views/frontend/switcher.blade.php)14blade
      Params
      0
      __env
      1
      app
      2
      errors
      3
      row
      4
      translation
      5
      hotel_related
      6
      location_category
      7
      booking_data
      8
      review_list
      9
      seo_meta
      10
      body_class
      11
      breadcrumbs
      12
      review_score
      13
      favicon
    • Layout::parts.header (modules/Layout/parts/header.blade.php)14blade
      Params
      0
      __env
      1
      app
      2
      errors
      3
      row
      4
      translation
      5
      hotel_related
      6
      location_category
      7
      booking_data
      8
      review_list
      9
      seo_meta
      10
      body_class
      11
      breadcrumbs
      12
      review_score
      13
      favicon
    • Core::frontend.currency-switcher (themes/BC/Core/Views/frontend/currency-switcher.blade.php)16blade
      Params
      0
      __env
      1
      app
      2
      errors
      3
      row
      4
      translation
      5
      hotel_related
      6
      location_category
      7
      booking_data
      8
      review_list
      9
      seo_meta
      10
      body_class
      11
      breadcrumbs
      12
      review_score
      13
      favicon
      14
      logo_id
      15
      logo
    • Language::frontend.switcher (themes/BC/Language/Views/frontend/switcher.blade.php)16blade
      Params
      0
      __env
      1
      app
      2
      errors
      3
      row
      4
      translation
      5
      hotel_related
      6
      location_category
      7
      booking_data
      8
      review_list
      9
      seo_meta
      10
      body_class
      11
      breadcrumbs
      12
      review_score
      13
      favicon
      14
      logo_id
      15
      logo
    • Layout::parts.footer (modules/Layout/parts/footer.blade.php)14blade
      Params
      0
      __env
      1
      app
      2
      errors
      3
      row
      4
      translation
      5
      hotel_related
      6
      location_category
      7
      booking_data
      8
      review_list
      9
      seo_meta
      10
      body_class
      11
      breadcrumbs
      12
      review_score
      13
      favicon
    • Layout::parts.login-register-modal (modules/Layout/parts/login-register-modal.blade.php)19blade
      Params
      0
      __env
      1
      app
      2
      errors
      3
      row
      4
      translation
      5
      hotel_related
      6
      location_category
      7
      booking_data
      8
      review_list
      9
      seo_meta
      10
      body_class
      11
      breadcrumbs
      12
      review_score
      13
      favicon
      14
      list_widget_footers
      15
      __currentLoopData
      16
      item
      17
      key
      18
      loop
    • Layout::auth.login-form (modules/Layout/auth/login-form.blade.php)19blade
      Params
      0
      __env
      1
      app
      2
      errors
      3
      row
      4
      translation
      5
      hotel_related
      6
      location_category
      7
      booking_data
      8
      review_list
      9
      seo_meta
      10
      body_class
      11
      breadcrumbs
      12
      review_score
      13
      favicon
      14
      list_widget_footers
      15
      __currentLoopData
      16
      item
      17
      key
      18
      loop
    • Layout::auth.register-form (modules/Layout/auth/register-form.blade.php)19blade
      Params
      0
      __env
      1
      app
      2
      errors
      3
      row
      4
      translation
      5
      hotel_related
      6
      location_category
      7
      booking_data
      8
      review_list
      9
      seo_meta
      10
      body_class
      11
      breadcrumbs
      12
      review_score
      13
      favicon
      14
      list_widget_footers
      15
      __currentLoopData
      16
      item
      17
      key
      18
      loop
    • Popup::frontend.popup (themes/Base/Popup/Views/frontend/popup.blade.php)19blade
      Params
      0
      __env
      1
      app
      2
      errors
      3
      row
      4
      translation
      5
      hotel_related
      6
      location_category
      7
      booking_data
      8
      review_list
      9
      seo_meta
      10
      body_class
      11
      breadcrumbs
      12
      review_score
      13
      favicon
      14
      list_widget_footers
      15
      __currentLoopData
      16
      item
      17
      key
      18
      loop
    uri
    GET hotel/{slug}
    middleware
    web
    controller
    Modules\Hotel\Controllers\HotelController@detail
    namespace
    Modules\Hotel\Controllers
    prefix
    /hotel
    where
    as
    hotel.detail
    file
    modules/Hotel/Controllers/HotelController.php:97-134
    37 statements were executed, 17 of which were duplicated, 20 unique121ms
    • select * from `bravo_hotels` where `slug` = 'parian-holiday-villas' and `bravo_hotels`.`deleted_at` is null limit 122.13ms/modules/Hotel/Controllers/HotelController.php:99cafebgnu_suran
      Metadata
      Bindings
      • 0. parian-holiday-villas
      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/Hotel/Controllers/HotelController.php:99
      • 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:259
    • select * from `bravo_locations` where 0 = 1 and `bravo_locations`.`deleted_at` is null5.7ms/modules/Hotel/Controllers/HotelController.php:99cafebgnu_suran
      Metadata
      Hints
      • Use SELECT * only if you need all columns from table
      Backtrace
      • 20. /modules/Hotel/Controllers/HotelController.php:99
      • 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:259
    • select * from `bravo_hotel_translations` where `locale` = 'en' and `bravo_hotel_translations`.`origin_id` in (9) and `bravo_hotel_translations`.`deleted_at` is null1.97ms/modules/Hotel/Controllers/HotelController.php:99cafebgnu_suran
      Metadata
      Bindings
      • 0. en
      Hints
      • Use SELECT * only if you need all columns from table
      Backtrace
      • 20. /modules/Hotel/Controllers/HotelController.php:99
      • 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:259
    • select * from `user_wishlist` where `object_model` = 'hotel' and `user_id` = 0 and `user_wishlist`.`object_id` in (9)3.1ms/modules/Hotel/Controllers/HotelController.php:99cafebgnu_suran
      Metadata
      Bindings
      • 0. hotel
      • 1. 0
      Hints
      • Use SELECT * only if you need all columns from table
      Backtrace
      • 20. /modules/Hotel/Controllers/HotelController.php:99
      • 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:259
    • select count(*) as aggregate from `bravo_review` where `object_id` = 9 and `object_model` = 'hotel' and `status` = 'approved' and `bravo_review`.`deleted_at` is null6.11ms/modules/Hotel/Models/Hotel.php:721cafebgnu_suran
      Metadata
      Bindings
      • 0. 9
      • 1. hotel
      • 2. approved
      Backtrace
      • 15. /modules/Hotel/Models/Hotel.php:721
      • 16. /modules/Hotel/Controllers/HotelController.php:109
      • 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 `id`, `title`, `content`, `rate_number`, `author_ip`, `status`, `created_at`, `vendor_id`, `author_id` from `bravo_review` where `object_id` = 9 and `object_model` = 'hotel' and `status` = 'approved' and `bravo_review`.`deleted_at` is null order by `id` desc limit 5 offset 01.32ms/modules/Hotel/Models/Hotel.php:721cafebgnu_suran
      Metadata
      Bindings
      • 0. 9
      • 1. hotel
      • 2. approved
      Backtrace
      • 15. /modules/Hotel/Models/Hotel.php:721
      • 16. /modules/Hotel/Controllers/HotelController.php:109
      • 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 `id`, `name`, `first_name`, `last_name`, `avatar_id` from `users` where `users`.`id` in (14, 15, 16) and `users`.`deleted_at` is null1.97ms/modules/Hotel/Models/Hotel.php:721cafebgnu_suran
      Metadata
      Backtrace
      • 20. /modules/Hotel/Models/Hotel.php:721
      • 21. /modules/Hotel/Controllers/HotelController.php:109
      • 22. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 23. /modules/Hotel/Controllers/HotelController.php:34
      • 24. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • select * from `location_category` where `status` = 'publish' and `location_category`.`deleted_at` is null10.91ms/modules/Hotel/Controllers/HotelController.php:114cafebgnu_suran
      Metadata
      Bindings
      • 0. publish
      Hints
      • Use SELECT * only if you need all columns from table
      Backtrace
      • 14. /modules/Hotel/Controllers/HotelController.php:114
      • 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:259
    • select * from `location_category_translations` where `locale` = 'en' and `location_category_translations`.`origin_id` in (1, 2, 3)5.12ms/modules/Hotel/Controllers/HotelController.php:114cafebgnu_suran
      Metadata
      Bindings
      • 0. en
      Hints
      • Use SELECT * only if you need all columns from table
      Backtrace
      • 19. /modules/Hotel/Controllers/HotelController.php:114
      • 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:259
    • select * from `bravo_seo` where `object_id` = 9 and `object_model` = 'hotel' limit 12.17ms/app/BaseModel.php:199cafebgnu_suran
      Metadata
      Bindings
      • 0. 9
      • 1. hotel
      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/Hotel/Controllers/HotelController.php:117
      • 18. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 19. /modules/Hotel/Controllers/HotelController.php:34
    • select AVG(rate_number) as score_total , COUNT(id) as total_review from `bravo_review` where `object_id` = 9 and `object_model` = 'hotel' and `status` = 'approved' and `bravo_review`.`deleted_at` is null limit 11.13ms/modules/Hotel/Models/Hotel.php:667cafebgnu_suran
      Metadata
      Bindings
      • 0. 9
      • 1. hotel
      • 2. approved
      Hints
      • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
      Backtrace
      • 15. /modules/Hotel/Models/Hotel.php:667
      • 21. view::27cdf0e953cdf1448398a877cefd11055372e0dc:15
      • 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 COUNT( CASE WHEN rate_number = 5 THEN rate_number ELSE NULL END ) AS rate_5, COUNT( CASE WHEN rate_number = 4 THEN rate_number ELSE NULL END ) AS rate_4, COUNT( CASE WHEN rate_number = 3 THEN rate_number ELSE NULL END ) AS rate_3, COUNT( CASE WHEN rate_number = 2 THEN rate_number ELSE NULL END ) AS rate_2, COUNT( CASE WHEN rate_number = 1 THEN rate_number ELSE NULL END ) AS rate_1 from `bravo_review` where `object_id` = 9 and `object_model` = 'hotel' and `status` = 'approved' and `bravo_review`.`deleted_at` is null limit 12.99ms/modules/Hotel/Models/Hotel.php:679cafebgnu_suran
      Metadata
      Bindings
      • 0. 9
      • 1. hotel
      • 2. approved
      Hints
      • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
      Backtrace
      • 15. /modules/Hotel/Models/Hotel.php:679
      • 21. view::27cdf0e953cdf1448398a877cefd11055372e0dc:15
      • 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 COUNT( id ) AS total_review, COUNT( CASE WHEN rate_number >= 4 THEN 1 ELSE null END ) as total_review_recommend from `bravo_review` where `object_id` = 9 and `object_model` = 'hotel' and `status` = 'approved' and `bravo_review`.`deleted_at` is null limit 11.12ms/modules/Booking/Models/Bookable.php:357cafebgnu_suran
      Metadata
      Bindings
      • 0. 9
      • 1. hotel
      • 2. approved
      Hints
      • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
      Backtrace
      • 15. /modules/Booking/Models/Bookable.php:357
      • 21. view::1310706cd15dade4f16179d523f56564d350c716:32
      • 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_term` where `bravo_hotel_term`.`target_id` = 9 and `bravo_hotel_term`.`target_id` is not null3.12msview::6205fa12da1d754af141231ec0dc0d38cdc2c4d0:2cafebgnu_suran
      Metadata
      Bindings
      • 0. 9
      Hints
      • Use SELECT * only if you need all columns from table
      Backtrace
      • 19. view::6205fa12da1d754af141231ec0dc0d38cdc2c4d0:2
      • 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_terms` where `bravo_terms`.`id` in (32, 33, 34, 35, 36, 37, 38, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 54, 55) and `bravo_terms`.`deleted_at` is null1.95ms/modules/Core/Models/Terms.php:40cafebgnu_suran
      Metadata
      Bindings
      • 0. 32
      • 1. 33
      • 2. 34
      • 3. 35
      • 4. 36
      • 5. 37
      • 6. 38
      • 7. 40
      • 8. 41
      • 9. 42
      • 10. 43
      • 11. 44
      • 12. 45
      • 13. 46
      • 14. 47
      • 15. 48
      • 16. 49
      • 17. 50
      • 18. 51
      • 19. 54
      • 20. 55
      Hints
      • Use SELECT * only if you need all columns from table
      Backtrace
      • 16. /modules/Core/Models/Terms.php:40
      • 17. view::6205fa12da1d754af141231ec0dc0d38cdc2c4d0:3
      • 19. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 21. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
    • select * from `bravo_terms_translations` where `locale` = 'en' and `bravo_terms_translations`.`origin_id` in (32, 33, 34, 35, 36, 37, 38, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 54, 55)1.85ms/modules/Core/Models/Terms.php:40cafebgnu_suran
      Metadata
      Bindings
      • 0. en
      Hints
      • Use SELECT * only if you need all columns from table
      Backtrace
      • 21. /modules/Core/Models/Terms.php:40
      • 22. view::6205fa12da1d754af141231ec0dc0d38cdc2c4d0:3
      • 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 `bravo_attrs` where `bravo_attrs`.`id` in (5, 6, 7) and `bravo_attrs`.`deleted_at` is null3.11ms/modules/Core/Models/Terms.php:40cafebgnu_suran
      Metadata
      Bindings
      • 0. 5
      • 1. 6
      • 2. 7
      Hints
      • Use SELECT * only if you need all columns from table
      Backtrace
      • 21. /modules/Core/Models/Terms.php:40
      • 22. view::6205fa12da1d754af141231ec0dc0d38cdc2c4d0:3
      • 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 `bravo_attrs_translations` where `bravo_attrs_translations`.`origin_id` = 5 and `bravo_attrs_translations`.`origin_id` is not null and `locale` = 'en' limit 11.9ms/app/Traits/HasTranslations.php:51cafebgnu_suran
      Metadata
      Bindings
      • 0. 5
      • 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::6205fa12da1d754af141231ec0dc0d38cdc2c4d0:7
      • 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_attrs_translations` where `bravo_attrs_translations`.`origin_id` = 6 and `bravo_attrs_translations`.`origin_id` is not null and `locale` = 'en' limit 1840μs/app/Traits/HasTranslations.php:51cafebgnu_suran
      Metadata
      Bindings
      • 0. 6
      • 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::6205fa12da1d754af141231ec0dc0d38cdc2c4d0:7
      • 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_attrs_translations` where `bravo_attrs_translations`.`origin_id` = 7 and `bravo_attrs_translations`.`origin_id` is not null and `locale` = 'en' limit 1760μs/app/Traits/HasTranslations.php:51cafebgnu_suran
      Metadata
      Bindings
      • 0. 7
      • 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::6205fa12da1d754af141231ec0dc0d38cdc2c4d0:7
      • 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_review_meta` where `review_id` = 116 and `name` = 'upload_picture' limit 16.49ms/modules/Review/Models/Review.php:75cafebgnu_suran
      Metadata
      Bindings
      • 0. 116
      • 1. upload_picture
      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/Review/Models/Review.php:75
      • 16. view::f9ea200c96e0eaa1eadca21ffa410526eed11a91:55
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
    • select * from `user_meta` where (`user_id` is null and `name` = 'social_meta_avatar') limit 113.29ms/app/User.php:97cafebgnu_suran
      Metadata
      Bindings
      • 0. social_meta_avatar
      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
      • 13. /app/User.php:97
      • 14. /app/User.php:195
      • 15. view::f9ea200c96e0eaa1eadca21ffa410526eed11a91:60
      • 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
      • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
    • select * from `bravo_review_meta` where `review_id` = 115 and `name` = 'upload_picture' limit 12.66ms/modules/Review/Models/Review.php:75cafebgnu_suran
      Metadata
      Bindings
      • 0. 115
      • 1. upload_picture
      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/Review/Models/Review.php:75
      • 16. view::f9ea200c96e0eaa1eadca21ffa410526eed11a91:55
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
    • select * from `user_meta` where (`user_id` is null and `name` = 'social_meta_avatar') limit 11.41ms/app/User.php:97cafebgnu_suran
      Metadata
      Bindings
      • 0. social_meta_avatar
      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
      • 13. /app/User.php:97
      • 14. /app/User.php:195
      • 15. view::f9ea200c96e0eaa1eadca21ffa410526eed11a91:60
      • 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
      • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
    • select * from `bravo_review_meta` where `review_id` = 114 and `name` = 'upload_picture' limit 12.48ms/modules/Review/Models/Review.php:75cafebgnu_suran
      Metadata
      Bindings
      • 0. 114
      • 1. upload_picture
      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/Review/Models/Review.php:75
      • 16. view::f9ea200c96e0eaa1eadca21ffa410526eed11a91:55
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
    • select * from `user_meta` where (`user_id` is null and `name` = 'social_meta_avatar') limit 12.98ms/app/User.php:97cafebgnu_suran
      Metadata
      Bindings
      • 0. social_meta_avatar
      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
      • 13. /app/User.php:97
      • 14. /app/User.php:195
      • 15. view::f9ea200c96e0eaa1eadca21ffa410526eed11a91:60
      • 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
      • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
    • select * from `users` where `users`.`id` = 7 and `users`.`deleted_at` is null limit 11.36msview::4a9489b0aa9a38c730bf1ea95c7fa7dce3cfb74b:3cafebgnu_suran
      Metadata
      Bindings
      • 0. 7
      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. view::4a9489b0aa9a38c730bf1ea95c7fa7dce3cfb74b:3
      • 22. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
      • 23. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 24. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
      • 25. /vendor/laravel/framework/src/Illuminate/View/View.php:152
    • select * from `user_meta` where (`user_id` = 7 and `name` = 'social_meta_avatar') limit 1870μs/app/User.php:97cafebgnu_suran
      Metadata
      Bindings
      • 0. 7
      • 1. social_meta_avatar
      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
      • 13. /app/User.php:97
      • 14. /app/User.php:195
      • 15. view::4a9489b0aa9a38c730bf1ea95c7fa7dce3cfb74b:9
      • 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
      • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
    • select * from `bravo_terms` where `bravo_terms`.`id` in (32, 33, 34, 35, 36, 37, 38, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 54, 55) and `bravo_terms`.`deleted_at` is null1.59ms/modules/Core/Models/Terms.php:40cafebgnu_suran
      Metadata
      Bindings
      • 0. 32
      • 1. 33
      • 2. 34
      • 3. 35
      • 4. 36
      • 5. 37
      • 6. 38
      • 7. 40
      • 8. 41
      • 9. 42
      • 10. 43
      • 11. 44
      • 12. 45
      • 13. 46
      • 14. 47
      • 15. 48
      • 16. 49
      • 17. 50
      • 18. 51
      • 19. 54
      • 20. 55
      Hints
      • Use SELECT * only if you need all columns from table
      Backtrace
      • 16. /modules/Core/Models/Terms.php:40
      • 17. view::6205fa12da1d754af141231ec0dc0d38cdc2c4d0:3
      • 19. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 21. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
    • select * from `bravo_terms_translations` where `locale` = 'en' and `bravo_terms_translations`.`origin_id` in (32, 33, 34, 35, 36, 37, 38, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 54, 55)1.06ms/modules/Core/Models/Terms.php:40cafebgnu_suran
      Metadata
      Bindings
      • 0. en
      Hints
      • Use SELECT * only if you need all columns from table
      Backtrace
      • 21. /modules/Core/Models/Terms.php:40
      • 22. view::6205fa12da1d754af141231ec0dc0d38cdc2c4d0:3
      • 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 `bravo_attrs` where `bravo_attrs`.`id` in (5, 6, 7) and `bravo_attrs`.`deleted_at` is null900μs/modules/Core/Models/Terms.php:40cafebgnu_suran
      Metadata
      Bindings
      • 0. 5
      • 1. 6
      • 2. 7
      Hints
      • Use SELECT * only if you need all columns from table
      Backtrace
      • 21. /modules/Core/Models/Terms.php:40
      • 22. view::6205fa12da1d754af141231ec0dc0d38cdc2c4d0:3
      • 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 `bravo_attrs_translations` where `bravo_attrs_translations`.`origin_id` = 5 and `bravo_attrs_translations`.`origin_id` is not null and `locale` = 'en' limit 1890μs/app/Traits/HasTranslations.php:51cafebgnu_suran
      Metadata
      Bindings
      • 0. 5
      • 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::6205fa12da1d754af141231ec0dc0d38cdc2c4d0:7
      • 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_attrs_translations` where `bravo_attrs_translations`.`origin_id` = 6 and `bravo_attrs_translations`.`origin_id` is not null and `locale` = 'en' limit 1900μs/app/Traits/HasTranslations.php:51cafebgnu_suran
      Metadata
      Bindings
      • 0. 6
      • 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::6205fa12da1d754af141231ec0dc0d38cdc2c4d0:7
      • 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_attrs_translations` where `bravo_attrs_translations`.`origin_id` = 7 and `bravo_attrs_translations`.`origin_id` is not null and `locale` = 'en' limit 1870μs/app/Traits/HasTranslations.php:51cafebgnu_suran
      Metadata
      Bindings
      • 0. 7
      • 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::6205fa12da1d754af141231ec0dc0d38cdc2c4d0:7
      • 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 `core_menu_translations` where `core_menu_translations`.`origin_id` = 1 and `core_menu_translations`.`origin_id` is not null and `locale` = 'en' limit 11.39ms/app/Traits/HasTranslations.php:51cafebgnu_suran
      Metadata
      Bindings
      • 0. 1
      • 1. en
      Hints
      • Use SELECT * only if you need all columns from table
      • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
      Backtrace
      • 20. /app/Traits/HasTranslations.php:51
      • 21. /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` = 'en' limit 11.11ms/app/Traits/HasTranslations.php:51cafebgnu_suran
      Metadata
      Bindings
      • 0. 1
      • 1. en
      Hints
      • Use SELECT * only if you need all columns from table
      • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
      Backtrace
      • 20. /app/Traits/HasTranslations.php:51
      • 21. /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` = '' and `core_pages`.`deleted_at` is null limit 11.4ms/app/Helpers/AppHelper.php:627cafebgnu_suran
      Metadata
      Bindings
      • 0. 
      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\Core\Models\MenuTranslation
    2
    App\User
    1
    Modules\Core\Models\Attributes
    6
    Modules\Core\Models\Terms
    42
    Modules\Hotel\Models\HotelTerm
    21
    Modules\Core\Models\SEO
    1
    Modules\Location\Models\LocationCategory
    3
    Modules\Review\Models\Review
    6
    Modules\Hotel\Models\HotelTranslation
    1
    Modules\Hotel\Models\Hotel
    1
    web
    null
    sanctum
    null
      _token
      7qUcW4zHYLXQ2HsrRZbz3gVgRp9Bq83Bf4Yy0Np2
      bc_current_currency
      usd
      _previous
      array:1 [ "url" => "https://suranadventures.com/hotel/parian-holiday-villas" ]
      _flash
      array:2 [ "old" => [] "new" => [] ]
      PHPDEBUGBAR_STACK_DATA
      []
      path_info
      /hotel/parian-holiday-villas
      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:19 [ "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=eyJpdiI6IlJxdVdZV0duUjE2T0ZZU0kxV2g2WVE9PSIsInZhbHVlIjoiVUdTY05jL1BDWlFqS1N3QXVUdkxpUGU4SG5mRktmdmNCRDRlczB4UzVRSEZjRVFDZUQyU1FoM0k2b1pRaktSWlk2K2RydmJmcG0yZTBTb3lrTUxMcVVxZzcwYU5PL29XUkFmdEY3dlgwZC9ldm0zK0dzeHA3a3BOaDFSN3EvcEUiLCJtYWMiOiIxNTBhN2JlMjJmM2ZhNWQ5YjFjYmEzNWExOGNjNDI3ZWQxZDMyN2I4MDM5NDQxYzFlOGVhOGFkOWMyY2NkYTBlIiwidGFnIjoiIn0%3D; suranadventures_session=eyJpdiI6InNhSzJGbVBkT0MrQnlMajdHTkxhdFE9PSIsInZhbHVlIjoibzZDL2lTbUJZOENzcVdIOUs3cmJQRndBZWduSllBcnlPMG5NdGQ5c0hQUHhQVHNGVjZpMU12K2Y0U0dBOEhBUmlJbW8vUk01bXV4Q2xWdUZsalNleEk1OVd6TXdBNFhJejIrVTNScTBMeVd6NjBWK05VZEYxWWlOaGhnYVZXQTEiLCJtYWMiOiJlMTg3YTAxOTZhYjdmNGVjZjFjNjIzMTFlNDkxOWZmZjgwYjg3YTllOTZjY2IyNDVkNDAxNGRjNGZlZjE5ODg5IiwidGFnIjoiIn0%3DXSRF-TOKEN=eyJpdiI6IlJxdVdZV0duUjE2T0ZZU0kxV2g2WVE9PSIsInZhbHVlIjoiVUdTY05jL1BDWlFqS1N3QXVUdkxpUGU4SG5mRktmdmNCRDRlczB4UzVRSEZjRVFDZUQyU1FoM0k2b1pRaktSWlk2K2Ryd" ] "host" => array:1 [ 0 => "suranadventures.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.118.24.69" ] "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" ] "x-forwarded-proto" => array:1 [ 0 => "https" ] "x-https" => array:1 [ 0 => "on" ] ]
      request_server
      0 of 0
      array:46 [ "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" => "gzip, deflate, br, zstd" "HTTP_COOKIE" => "XSRF-TOKEN=eyJpdiI6IlJxdVdZV0duUjE2T0ZZU0kxV2g2WVE9PSIsInZhbHVlIjoiVUdTY05jL1BDWlFqS1N3QXVUdkxpUGU4SG5mRktmdmNCRDRlczB4UzVRSEZjRVFDZUQyU1FoM0k2b1pRaktSWlk2K2RydmJmcG0yZTBTb3lrTUxMcVVxZzcwYU5PL29XUkFmdEY3dlgwZC9ldm0zK0dzeHA3a3BOaDFSN3EvcEUiLCJtYWMiOiIxNTBhN2JlMjJmM2ZhNWQ5YjFjYmEzNWExOGNjNDI3ZWQxZDMyN2I4MDM5NDQxYzFlOGVhOGFkOWMyY2NkYTBlIiwidGFnIjoiIn0%3D; suranadventures_session=eyJpdiI6InNhSzJGbVBkT0MrQnlMajdHTkxhdFE9PSIsInZhbHVlIjoibzZDL2lTbUJZOENzcVdIOUs3cmJQRndBZWduSllBcnlPMG5NdGQ5c0hQUHhQVHNGVjZpMU12K2Y0U0dBOEhBUmlJbW8vUk01bXV4Q2xWdUZsalNleEk1OVd6TXdBNFhJejIrVTNScTBMeVd6NjBWK05VZEYxWWlOaGhnYVZXQTEiLCJtYWMiOiJlMTg3YTAxOTZhYjdmNGVjZjFjNjIzMTFlNDkxOWZmZjgwYjg3YTllOTZjY2IyNDVkNDAxNGRjNGZlZjE5ODg5IiwidGFnIjoiIn0%3DXSRF-TOKEN=eyJpdiI6IlJxdVdZV0duUjE2T0ZZU0kxV2g2WVE9PSIsInZhbHVlIjoiVUdTY05jL1BDWlFqS1N3QXVUdkxpUGU4SG5mRktmdmNCRDRlczB4UzVRSEZjRVFDZUQyU1FoM0k2b1pRaktSWlk2K2Ryd" "HTTP_HOST" => "suranadventures.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.118.24.69" "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" "HTTP_X_FORWARDED_PROTO" => "https" "HTTP_X_HTTPS" => "on" "DOCUMENT_ROOT" => "/home/cafebgnu/suranadventures.com" "REMOTE_ADDR" => "18.118.24.69" "REMOTE_PORT" => "56388" "SERVER_ADDR" => "162.0.217.113" "SERVER_NAME" => "suranadventures.com" "SERVER_ADMIN" => "webmaster@suranadventurescom.level-up-lounge.vip" "SERVER_PORT" => "443" "REQUEST_SCHEME" => "https" "REQUEST_URI" => "/hotel/parian-holiday-villas" "REDIRECT_URL" => "/public/hotel/parian-holiday-villas" "REDIRECT_REQUEST_METHOD" => "GET" "PROXY_REMOTE_ADDR" => "162.0.217.98" "HTTPS" => "on" "REDIRECT_STATUS" => "200" "SCRIPT_FILENAME" => "/home/cafebgnu/suranadventures.com/public/index.php" "QUERY_STRING" => "" "SCRIPT_URI" => "https://suranadventures.com/hotel/parian-holiday-villas" "SCRIPT_URL" => "/hotel/parian-holiday-villas" "SCRIPT_NAME" => "/public/index.php" "SERVER_PROTOCOL" => "HTTP/1.1" "SERVER_SOFTWARE" => "LiteSpeed" "REQUEST_METHOD" => "GET" "X-LSCACHE" => "on" "PHP_SELF" => "/public/index.php" "REQUEST_TIME_FLOAT" => 1744086753.264 "REQUEST_TIME" => 1744086753 ]
      request_cookies
      0 of 0
      array:2 [ "XSRF-TOKEN" => "7qUcW4zHYLXQ2HsrRZbz3gVgRp9Bq83Bf4Yy0Np2" "suranadventures_session" => "qhB9KSUsCS0Ha1p8wLBb6jUDBlv7VSS3N0NGvhJv" ]
      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 => "Tue, 08 Apr 2025 04:32:33 GMT" ] "set-cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6Imw4bVpHUWw5a0RtbEJNUU1UditGR0E9PSIsInZhbHVlIjoiL1M3VzFVcVp6V3huQ0xDcS9OVGZ5cWVoZTRNWjEvSERCTmtHeWNSVXlFR2Fuc1pQcGROTmhKMW8zQ2RFengwaXpac1htV1VBQkFvcU1pL0Q1bHBwb0RGajJXTzFMVEFUT1QwWlZQUEdEY2RsZmJ5ZC9GZ21YeTV0TkpXRHM5blgiLCJtYWMiOiIyY2YwN2VkOGEwOWJkOWRjYmI5YzA0MWQ4YjM1YTFmYWQ4ZGEyNGJkMmQ4NTM0NThhMGU3ZjU4YWIxMmYzN2U0IiwidGFnIjoiIn0%3D; expires=Tue, 08-Apr-2025 06:32:33 GMT; Max-Age=7200; path=/; samesite=laxXSRF-TOKEN=eyJpdiI6Imw4bVpHUWw5a0RtbEJNUU1UditGR0E9PSIsInZhbHVlIjoiL1M3VzFVcVp6V3huQ0xDcS9OVGZ5cWVoZTRNWjEvSERCTmtHeWNSVXlFR2Fuc1pQcGROTmhKMW8zQ2RFengwaXpac1htV" 1 => "suranadventures_session=eyJpdiI6ImNqUWFUWG8rR1c3cWNHWXRKRnJQV1E9PSIsInZhbHVlIjoieW9VVnRscmJUNnZHV1lxM3M2N1o2eUd2SUZaWXIreHB1dVZBUGEvVFRLZFFrVmlCVlZ3bEhTamNESVpXSU04bWFjaG5FWGlwU1hXeDZsbnNZdU45TitRWnBBakFYME9TdlBrejQ5dG1ZUUhxeWlCcFQwNlQ3ckNuZWdNWXU2aGwiLCJtYWMiOiIxODY4NTFkYjVjMWU2Y2MyZDgyMzQ3MmY4NWFkMWM0ZDZkY2I5MGYwZTJlYzdiY2U0Zjk5ODA1ZmI5NWM1OGQ1IiwidGFnIjoiIn0%3D; expires=Tue, 08-Apr-2025 06:32:33 GMT; Max-Age=7200; path=/; httponly; samesite=laxsuranadventures_session=eyJpdiI6ImNqUWFUWG8rR1c3cWNHWXRKRnJQV1E9PSIsInZhbHVlIjoieW9VVnRscmJUNnZHV1lxM3M2N1o2eUd2SUZaWXIreHB1dVZBUGEvVFRLZFFrVmlCVlZ3bEhTamNESVpX" ] "Set-Cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6Imw4bVpHUWw5a0RtbEJNUU1UditGR0E9PSIsInZhbHVlIjoiL1M3VzFVcVp6V3huQ0xDcS9OVGZ5cWVoZTRNWjEvSERCTmtHeWNSVXlFR2Fuc1pQcGROTmhKMW8zQ2RFengwaXpac1htV1VBQkFvcU1pL0Q1bHBwb0RGajJXTzFMVEFUT1QwWlZQUEdEY2RsZmJ5ZC9GZ21YeTV0TkpXRHM5blgiLCJtYWMiOiIyY2YwN2VkOGEwOWJkOWRjYmI5YzA0MWQ4YjM1YTFmYWQ4ZGEyNGJkMmQ4NTM0NThhMGU3ZjU4YWIxMmYzN2U0IiwidGFnIjoiIn0%3D; expires=Tue, 08-Apr-2025 06:32:33 GMT; path=/XSRF-TOKEN=eyJpdiI6Imw4bVpHUWw5a0RtbEJNUU1UditGR0E9PSIsInZhbHVlIjoiL1M3VzFVcVp6V3huQ0xDcS9OVGZ5cWVoZTRNWjEvSERCTmtHeWNSVXlFR2Fuc1pQcGROTmhKMW8zQ2RFengwaXpac1htV" 1 => "suranadventures_session=eyJpdiI6ImNqUWFUWG8rR1c3cWNHWXRKRnJQV1E9PSIsInZhbHVlIjoieW9VVnRscmJUNnZHV1lxM3M2N1o2eUd2SUZaWXIreHB1dVZBUGEvVFRLZFFrVmlCVlZ3bEhTamNESVpXSU04bWFjaG5FWGlwU1hXeDZsbnNZdU45TitRWnBBakFYME9TdlBrejQ5dG1ZUUhxeWlCcFQwNlQ3ckNuZWdNWXU2aGwiLCJtYWMiOiIxODY4NTFkYjVjMWU2Y2MyZDgyMzQ3MmY4NWFkMWM0ZDZkY2I5MGYwZTJlYzdiY2U0Zjk5ODA1ZmI5NWM1OGQ1IiwidGFnIjoiIn0%3D; expires=Tue, 08-Apr-2025 06:32:33 GMT; path=/; httponlysuranadventures_session=eyJpdiI6ImNqUWFUWG8rR1c3cWNHWXRKRnJQV1E9PSIsInZhbHVlIjoieW9VVnRscmJUNnZHV1lxM3M2N1o2eUd2SUZaWXIreHB1dVZBUGEvVFRLZFFrVmlCVlZ3bEhTamNESVpX" ] ]
      session_attributes
      0 of 0
      array:5 [ "_token" => "7qUcW4zHYLXQ2HsrRZbz3gVgRp9Bq83Bf4Yy0Np2" "bc_current_currency" => "usd" "_previous" => array:1 [ "url" => "https://suranadventures.com/hotel/parian-holiday-villas" ] "_flash" => array:2 [ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]