Castello Casole Hotel

Messages Timeline Exceptions Views32 Route Queries48 Models76 Mails Auth Gate Session Request

Request history8.0.301.47s36MBGET hotel/{slug}

Booting (531ms)time
Application (934ms)time
1 x Application (63.76%)
934ms
1 x Booting (36.24%)
531ms

32 templates were rendered

1x Hotel::frontend.detaildetail.blade.php#?blade
1x Layout::parts.bcbc.blade.php#?blade
1x Hotel::frontend.layouts.details.hotel-bannerhotel-banner.blade.php#?blade
1x Hotel::frontend.layouts.details.hotel-detailhotel-detail.blade.php#?blade
1x Hotel::frontend.layouts.details.hotel-roomshotel-rooms.blade.php#?blade
1x Booking::frontend.global.enquiry-formenquiry-form.blade.php#?blade
2x Hotel::frontend.layouts.details.hotel-attributeshotel-attributes.blade.php#?blade
1x Hotel::frontend.layouts.details.hotel-surroundinghotel-surrounding.blade.php#?blade
1x Hotel::frontend.layouts.details.hotel-reviewhotel-review.blade.php#?blade
1x Review::frontend.formform.blade.php#?blade
1x pagination::tailwindtailwind.blade.php#?blade
1x vendor.pagination.defaultdefault.blade.php#?blade
1x Tour::frontend.layouts.details.vendorvendor.blade.php#?blade
1x Hotel::frontend.layouts.details.hotel-form-enquiryhotel-form-enquiry.blade.php#?blade
1x Hotel::frontend.layouts.details.hotel-related-listhotel-related-list.blade.php#?blade
1x Hotel::frontend.layouts.details.hotel-form-enquiry-mobilehotel-form-enquiry-mobile.blade.php#?blade
1x layouts.appapp.blade.php#?blade
1x Layout::appapp.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

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

48 statements were executed (23 duplicates)Show only duplicates43.25ms

HotelController.php#99aarnatours290425_abhi_tNt2.94msselect * from `bravo_hotels` where `slug` = 'castello-casole-hotel' and `bravo_hotels`.`deleted_at` is null limit 1

Bindings	0: castello-casole-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	modules/Hotel/Controllers/HotelController.php:99 vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 modules/Hotel/Controllers/HotelController.php:34 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 vendor/laravel/framework/src/Illuminate/Routing/Route.php:260

HotelController.php#99aarnatours290425_abhi_tNt580μsselect * from `bravo_locations` where `bravo_locations`.`id` in (1) and `bravo_locations`.`deleted_at` is null

Hints	Use `SELECT *` only if you need all columns from table
Backtrace	modules/Hotel/Controllers/HotelController.php:99 vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 modules/Hotel/Controllers/HotelController.php:34 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 vendor/laravel/framework/src/Illuminate/Routing/Route.php:260

HotelController.php#99aarnatours290425_abhi_tNt500μsselect * from `bravo_location_translations` where `locale` = 'en' and `bravo_location_translations`.`origin_id` in (1)

Bindings	0: en
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	modules/Hotel/Controllers/HotelController.php:99 vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 modules/Hotel/Controllers/HotelController.php:34 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 vendor/laravel/framework/src/Illuminate/Routing/Route.php:260

HotelController.php#99aarnatours290425_abhi_tNt500μs

select * from `bravo_hotel_translations` where `locale` = 'en' and `bravo_hotel_translations`.`origin_id` in (3) and `bravo_hotel_translations`.`deleted_at` is null

Bindings	0: en
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	modules/Hotel/Controllers/HotelController.php:99 vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 modules/Hotel/Controllers/HotelController.php:34 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 vendor/laravel/framework/src/Illuminate/Routing/Route.php:260

HotelController.php#99aarnatours290425_abhi_tNt470μsselect * from `user_wishlist` where `object_model` = 'hotel' and `user_id` = 0 and `user_wishlist`.`object_id` in (3)

Bindings	0: hotel 1: 0
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	modules/Hotel/Controllers/HotelController.php:99 vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 modules/Hotel/Controllers/HotelController.php:34 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 vendor/laravel/framework/src/Illuminate/Routing/Route.php:260

HotelController.php#107aarnatours290425_abhi_tNt1.05ms

select * from `bravo_hotels` where `location_id` = 1 and `status` = 'publish' and `id` not in (3) and `bravo_hotels`.`deleted_at` is null limit 4

Bindings	0: 1 1: publish 2: 3
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	modules/Hotel/Controllers/HotelController.php:107 vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 modules/Hotel/Controllers/HotelController.php:34 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 vendor/laravel/framework/src/Illuminate/Routing/Route.php:260

HotelController.php#107aarnatours290425_abhi_tNt510μsselect * from `bravo_locations` where `bravo_locations`.`id` in (1) and `bravo_locations`.`deleted_at` is null

Hints	Use `SELECT *` only if you need all columns from table
Backtrace	modules/Hotel/Controllers/HotelController.php:107 vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 modules/Hotel/Controllers/HotelController.php:34 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 vendor/laravel/framework/src/Illuminate/Routing/Route.php:260

HotelController.php#107aarnatours290425_abhi_tNt430μsselect * from `bravo_location_translations` where `locale` = 'en' and `bravo_location_translations`.`origin_id` in (1)

Bindings	0: en
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	modules/Hotel/Controllers/HotelController.php:107 vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 modules/Hotel/Controllers/HotelController.php:34 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 vendor/laravel/framework/src/Illuminate/Routing/Route.php:260

HotelController.php#107aarnatours290425_abhi_tNt690μs

select * from `bravo_hotel_translations` where `locale` = 'en' and `bravo_hotel_translations`.`origin_id` in (1, 2, 4, 9) and `bravo_hotel_translations`.`deleted_at` is null

Bindings	0: en
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	modules/Hotel/Controllers/HotelController.php:107 vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 modules/Hotel/Controllers/HotelController.php:34 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 vendor/laravel/framework/src/Illuminate/Routing/Route.php:260

HotelController.php#107aarnatours290425_abhi_tNt750μs

select * from `user_wishlist` where `object_model` = 'hotel' and `user_id` = 0 and `user_wishlist`.`object_id` in (1, 2, 4, 9)

Bindings	0: hotel 1: 0
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	modules/Hotel/Controllers/HotelController.php:107 vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 modules/Hotel/Controllers/HotelController.php:34 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 vendor/laravel/framework/src/Illuminate/Routing/Route.php:260

Hotel.php#721aarnatours290425_abhi_tNt680μs

select count(*) as aggregate from `bravo_review` where `object_id` = 3 and `object_model` = 'hotel' and `status` = 'approved' and `bravo_review`.`deleted_at` is null

Bindings	0: 3 1: hotel 2: approved
Backtrace	modules/Hotel/Models/Hotel.php:721 modules/Hotel/Controllers/HotelController.php:109 vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 modules/Hotel/Controllers/HotelController.php:34 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43

Hotel.php#721aarnatours290425_abhi_tNt790μs

select `id`, `title`, `content`, `rate_number`, `author_ip`, `status`, `created_at`, `vendor_id`, `author_id` from `bravo_review` where `object_id` = 3 and `object_model` = 'hotel' and `status` = 'approved' and `bravo_review`.`deleted_at` is null order by `id` desc limit 5 offset 0

Bindings	0: 3 1: hotel 2: approved
Backtrace	modules/Hotel/Models/Hotel.php:721 modules/Hotel/Controllers/HotelController.php:109 vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 modules/Hotel/Controllers/HotelController.php:34 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43

Hotel.php#721aarnatours290425_abhi_tNt650μs

select `id`, `name`, `first_name`, `last_name`, `avatar_id` from `users` where `users`.`id` in (12, 13, 14) and `users`.`deleted_at` is null

Backtrace

modules/Hotel/Models/Hotel.php:721
modules/Hotel/Controllers/HotelController.php:109
vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
modules/Hotel/Controllers/HotelController.php:34
vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43

HotelController.php#114aarnatours290425_abhi_tNt710μsselect * from `location_category` where `status` = 'publish' and `location_category`.`deleted_at` is null

Bindings	0: publish
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	modules/Hotel/Controllers/HotelController.php:114 vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 modules/Hotel/Controllers/HotelController.php:34 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 vendor/laravel/framework/src/Illuminate/Routing/Route.php:260

HotelController.php#114aarnatours290425_abhi_tNt600μs

select * from `location_category_translations` where `locale` = 'en' and `location_category_translations`.`origin_id` in (1, 2, 3)

Bindings	0: en
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	modules/Hotel/Controllers/HotelController.php:114 vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 modules/Hotel/Controllers/HotelController.php:34 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 vendor/laravel/framework/src/Illuminate/Routing/Route.php:260

BaseModel.php#199aarnatours290425_abhi_tNt650μsselect * from `bravo_seo` where `object_id` = 3 and `object_model` = 'hotel' limit 1

Bindings	0: 3 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	app/BaseModel.php:199 app/BaseModel.php:212 modules/Hotel/Controllers/HotelController.php:117 vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 modules/Hotel/Controllers/HotelController.php:34

QueryBuilder.php#165aarnatours290425_abhi_tNt590μs

select * from `bravo_locations` where (2 between `bravo_locations`.`_lft` and `bravo_locations`.`_rgt` and `bravo_locations`.`id` <> 1) and `bravo_locations`.`deleted_at` is null

Bindings	0: 2 1: 1
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	vendor/kalnoy/nestedset/src/QueryBuilder.php:165 modules/Location/Traits/HasLocation.php:21 modules/Hotel/Controllers/HotelController.php:126 vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 modules/Hotel/Controllers/HotelController.php:34

Hotel.php#667aarnatours290425_abhi_tNt650μs

select  AVG(rate_number) as score_total , COUNT(id) as total_review  from `bravo_review` where `object_id` = 3 and `object_model` = 'hotel' and `status` = 'approved' and `bravo_review`.`deleted_at` is null limit 1

Bindings	0: 3 1: hotel 2: approved
Hints	`LIMIT` without `ORDER BY` causes non-deterministic results, depending on the query execution plan
Backtrace	modules/Hotel/Models/Hotel.php:667 view::Hotel::frontend.detail:15 vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110 vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70

Hotel.php#679aarnatours290425_abhi_tNt750μs

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` = 3 and `object_model` = 'hotel' and `status` = 'approved' and `bravo_review`.`deleted_at` is null limit 1

Bindings	0: 3 1: hotel 2: approved
Hints	`LIMIT` without `ORDER BY` causes non-deterministic results, depending on the query execution plan
Backtrace	modules/Hotel/Models/Hotel.php:679 view::Hotel::frontend.detail:15 vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110 vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70

Bookable.php#357aarnatours290425_abhi_tNt700μs

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` = 3 and `object_model` = 'hotel' and `status` = 'approved' and `bravo_review`.`deleted_at` is null limit 1

Bindings	0: 3 1: hotel 2: approved
Hints	`LIMIT` without `ORDER BY` causes non-deterministic results, depending on the query execution plan
Backtrace	modules/Booking/Models/Bookable.php:357 view::Hotel::frontend.layouts.details.hotel-detail:32 vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110 vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70

hotel-attributes.blade.php#2aarnatours290425_abhi_tNt860μsselect * from `bravo_hotel_term` where `bravo_hotel_term`.`target_id` = 3 and `bravo_hotel_term`.`target_id` is not null

Bindings	0: 3
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	view::Hotel::frontend.layouts.details.hotel-attributes:2 vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110 vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70 vendor/laravel/framework/src/Illuminate/View/View.php:195

Terms.php#40aarnatours290425_abhi_tNt870μs

select * from `bravo_terms` where `bravo_terms`.`id` in (32, 33, 37, 38, 39, 40, 41, 42, 44, 45, 46, 47, 48, 49, 51, 52, 53) and `bravo_terms`.`deleted_at` is null

Hints	Use `SELECT *` only if you need all columns from table
Backtrace	modules/Core/Models/Terms.php:40 view::Hotel::frontend.layouts.details.hotel-attributes:3 vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110 vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70

Terms.php#40aarnatours290425_abhi_tNt690μs

select * from `bravo_terms_translations` where `locale` = 'en' and `bravo_terms_translations`.`origin_id` in (32, 33, 37, 38, 39, 40, 41, 42, 44, 45, 46, 47, 48, 49, 51, 52, 53)

Bindings	0: en
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	modules/Core/Models/Terms.php:40 view::Hotel::frontend.layouts.details.hotel-attributes:3 vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110 vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70

Terms.php#40aarnatours290425_abhi_tNt710μsselect * from `bravo_attrs` where `bravo_attrs`.`id` in (5, 6, 7) and `bravo_attrs`.`deleted_at` is null

Bindings	0: 5 1: 6 2: 7
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	modules/Core/Models/Terms.php:40 view::Hotel::frontend.layouts.details.hotel-attributes:3 vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110 vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70

HasTranslations.php#51aarnatours290425_abhi_tNt560μs

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 1

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	app/Traits/HasTranslations.php:51 view::Hotel::frontend.layouts.details.hotel-attributes:7 vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110 vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70

HasTranslations.php#51aarnatours290425_abhi_tNt430μs

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 1

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	app/Traits/HasTranslations.php:51 view::Hotel::frontend.layouts.details.hotel-attributes:7 vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110 vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70

HasTranslations.php#51aarnatours290425_abhi_tNt470μs

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 1

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	app/Traits/HasTranslations.php:51 view::Hotel::frontend.layouts.details.hotel-attributes:7 vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110 vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70

Review.php#75aarnatours290425_abhi_tNt4.3msselect * from `bravo_review_meta` where `review_id` = 105 and `name` = 'upload_picture' limit 1

Bindings	0: 105 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	modules/Review/Models/Review.php:75 view::Review::frontend.form:55 vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110 vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70

User.php#97aarnatours290425_abhi_tNt570μsselect * from `user_meta` where (`user_id` is null and `name` = 'social_meta_avatar') limit 1

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	app/User.php:97 app/User.php:195 view::Review::frontend.form:60 vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110 vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58

Review.php#75aarnatours290425_abhi_tNt4.22msselect * from `bravo_review_meta` where `review_id` = 104 and `name` = 'upload_picture' limit 1

Bindings	0: 104 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	modules/Review/Models/Review.php:75 view::Review::frontend.form:55 vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110 vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70

User.php#97aarnatours290425_abhi_tNt740μsselect * from `user_meta` where (`user_id` is null and `name` = 'social_meta_avatar') limit 1

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	app/User.php:97 app/User.php:195 view::Review::frontend.form:60 vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110 vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58

Review.php#75aarnatours290425_abhi_tNt1.89msselect * from `bravo_review_meta` where `review_id` = 103 and `name` = 'upload_picture' limit 1

Bindings	0: 103 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	modules/Review/Models/Review.php:75 view::Review::frontend.form:55 vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110 vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70

User.php#97aarnatours290425_abhi_tNt390μsselect * from `user_meta` where (`user_id` is null and `name` = 'social_meta_avatar') limit 1

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	app/User.php:97 app/User.php:195 view::Review::frontend.form:60 vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110 vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58

Review.php#75aarnatours290425_abhi_tNt1.89msselect * from `bravo_review_meta` where `review_id` = 102 and `name` = 'upload_picture' limit 1

Bindings	0: 102 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	modules/Review/Models/Review.php:75 view::Review::frontend.form:55 vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110 vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70

User.php#97aarnatours290425_abhi_tNt470μsselect * from `user_meta` where (`user_id` is null and `name` = 'social_meta_avatar') limit 1

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	app/User.php:97 app/User.php:195 view::Review::frontend.form:60 vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110 vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58

Review.php#75aarnatours290425_abhi_tNt1.96msselect * from `bravo_review_meta` where `review_id` = 101 and `name` = 'upload_picture' limit 1

Bindings	0: 101 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	modules/Review/Models/Review.php:75 view::Review::frontend.form:55 vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110 vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70

User.php#97aarnatours290425_abhi_tNt640μsselect * from `user_meta` where (`user_id` is null and `name` = 'social_meta_avatar') limit 1

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	app/User.php:97 app/User.php:195 view::Review::frontend.form:60 vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110 vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58

vendor.blade.php#3aarnatours290425_abhi_tNt670μsselect * from `users` where `users`.`id` = 1 and `users`.`deleted_at` is null limit 1

Bindings	0: 1
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	view::Tour::frontend.layouts.details.vendor:3 vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110 vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70 vendor/laravel/framework/src/Illuminate/View/View.php:195

User.php#97aarnatours290425_abhi_tNt450μsselect * from `user_meta` where (`user_id` = 1 and `name` = 'social_meta_avatar') limit 1

Bindings	0: 1 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	app/User.php:97 app/User.php:195 view::Tour::frontend.layouts.details.vendor:9 vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110 vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58

Terms.php#40aarnatours290425_abhi_tNt820μs

select * from `bravo_terms` where `bravo_terms`.`id` in (32, 33, 37, 38, 39, 40, 41, 42, 44, 45, 46, 47, 48, 49, 51, 52, 53) and `bravo_terms`.`deleted_at` is null

Hints	Use `SELECT *` only if you need all columns from table
Backtrace	modules/Core/Models/Terms.php:40 view::Hotel::frontend.layouts.details.hotel-attributes:3 vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110 vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70

Terms.php#40aarnatours290425_abhi_tNt500μs

select * from `bravo_terms_translations` where `locale` = 'en' and `bravo_terms_translations`.`origin_id` in (32, 33, 37, 38, 39, 40, 41, 42, 44, 45, 46, 47, 48, 49, 51, 52, 53)

Bindings	0: en
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	modules/Core/Models/Terms.php:40 view::Hotel::frontend.layouts.details.hotel-attributes:3 vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110 vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70

Terms.php#40aarnatours290425_abhi_tNt490μsselect * from `bravo_attrs` where `bravo_attrs`.`id` in (5, 6, 7) and `bravo_attrs`.`deleted_at` is null

Bindings	0: 5 1: 6 2: 7
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	modules/Core/Models/Terms.php:40 view::Hotel::frontend.layouts.details.hotel-attributes:3 vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110 vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70

HasTranslations.php#51aarnatours290425_abhi_tNt450μs

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 1

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	app/Traits/HasTranslations.php:51 view::Hotel::frontend.layouts.details.hotel-attributes:7 vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110 vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70

HasTranslations.php#51aarnatours290425_abhi_tNt400μs

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 1

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	app/Traits/HasTranslations.php:51 view::Hotel::frontend.layouts.details.hotel-attributes:7 vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110 vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70

HasTranslations.php#51aarnatours290425_abhi_tNt390μs

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 1

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	app/Traits/HasTranslations.php:51 view::Hotel::frontend.layouts.details.hotel-attributes:7 vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110 vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70

HasTranslations.php#51aarnatours290425_abhi_tNt770μs

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 1

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	app/Traits/HasTranslations.php:51 app/Helpers/AppHelper.php:111 vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110 vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70

HasTranslations.php#51aarnatours290425_abhi_tNt800μs

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 1

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	app/Traits/HasTranslations.php:51 app/Helpers/AppHelper.php:111 vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110 vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70

AppHelper.php#627aarnatours290425_abhi_tNt660μsselect * from `core_pages` where `core_pages`.`id` = '' and `core_pages`.`deleted_at` is null limit 1

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	app/Helpers/AppHelper.php:627 vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110 vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70 vendor/laravel/framework/src/Illuminate/View/View.php:195

Modules\Core\Models\Terms: 34Terms.php#?
Modules\Hotel\Models\HotelTerm: 17HotelTerm.php#?
Modules\Review\Models\Review: 8Review.php#?
Modules\Core\Models\Attributes: 6Attributes.php#?
Modules\Hotel\Models\Hotel: 5Hotel.php#?
Modules\Location\Models\LocationCategory: 3LocationCategory.php#?
Modules\Location\Models\Location: 2Location.php#?
App\User: 1User.php#?

web: null
sanctum: null

_token: XBswfUdnS7xBYtJJMKRMXmxXZOIgBBu6ZoIMaDBe
_previous: array:1 [ "url" => "https://aarnatours.com/hotel/castello-casole-hotel" ]
_flash: array:2 [ "old" => [] "new" => [] ]

path_info

/hotel/castello-casole-hotel

status_code

status_text

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"
  ]
  "content-length" => array:1 [▶
    0 => "0"
  ]
  "host" => array:1 [▶
    0 => "aarnatours.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 => ""Chromium";v="130", "HeadlessChrome";v="130", "Not?A_Brand";v="99""
  ]
  "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

[]

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 => "Wed, 11 Jun 2025 16:03:55 GMT"
  ]
  "set-cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IksxZE5GMzBiZUdocUU4ajBVQVdwMUE9PSIsInZhbHVlIjoiMnJZQ29aTzFIOGpWcFdwd3I5ZW5jNWpJRk44RGxqeDdmYTVCeitDMEk3bVZHYWJHQm04QVIxSlJWQ0JSOTVvQlRMNjZyWEYxWHJ0ZkpwQTRoUFZrdmlHUEZCUlh0TjQ1NDdmUWZtQ3lZWXdNR0hJK1N2bGltREFBOHZZa21sM3oiLCJtYWMiOiI5MWVhOGNkZmIzMjY3ODhjNGRiZmU0ZDQ4YjVmYjc0MWVmYWNhM2FhNWVjYzhhZGMyNmQzMzFmNDBlMmVhMDk2IiwidGFnIjoiIn0%3D; expires=Wed, 11-Jun-2025 18:03:56 GMT; Max-Age=7200; path=/; samesite=lax ◀XSRF-TOKEN=eyJpdiI6IksxZE5GMzBiZUdocUU4ajBVQVdwMUE9PSIsInZhbHVlIjoiMnJZQ29aTzFIOGpWcFdwd3I5ZW5jNWpJRk44RGxqeDdmYTVCeitDMEk3bVZHYWJHQm04QVIxSlJWQ0JSOTVvQlRMNjZyW ▶"
    1 => "booking_core_session=eyJpdiI6ImNhbWE1d3JsMG8zR2lRa2sxN2hoVXc9PSIsInZhbHVlIjoiZ29CWEc2b3Z4UXlNdVo3aCtnM0c2K3Q0dWtuWFBiRytjekIxSytzYkF1QnIvZFhnbENCb2ExY3ZpZTBkd0VqM0VSQzB4T1EwK0ZsSVJtTXNuZnpiVU9OdUV0cjFyWGNwY2gyanFndm16QUtnM2tpNmhYMng4L1NNS202amJIVFoiLCJtYWMiOiJjNzVhOGVlOGRhNzYxYzk5YWNlYWUzMWU0YjQ0OTQ2M2ZmNjg4Njk5NGEyZDkzM2JjMWUwODdiNDk5YjJlNmI4IiwidGFnIjoiIn0%3D; expires=Wed, 11-Jun-2025 18:03:56 GMT; Max-Age=7200; path=/; httponly; samesite=lax ◀booking_core_session=eyJpdiI6ImNhbWE1d3JsMG8zR2lRa2sxN2hoVXc9PSIsInZhbHVlIjoiZ29CWEc2b3Z4UXlNdVo3aCtnM0c2K3Q0dWtuWFBiRytjekIxSytzYkF1QnIvZFhnbENCb2ExY3ZpZTBkd0V ▶"
  ]
  "Set-Cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IksxZE5GMzBiZUdocUU4ajBVQVdwMUE9PSIsInZhbHVlIjoiMnJZQ29aTzFIOGpWcFdwd3I5ZW5jNWpJRk44RGxqeDdmYTVCeitDMEk3bVZHYWJHQm04QVIxSlJWQ0JSOTVvQlRMNjZyWEYxWHJ0ZkpwQTRoUFZrdmlHUEZCUlh0TjQ1NDdmUWZtQ3lZWXdNR0hJK1N2bGltREFBOHZZa21sM3oiLCJtYWMiOiI5MWVhOGNkZmIzMjY3ODhjNGRiZmU0ZDQ4YjVmYjc0MWVmYWNhM2FhNWVjYzhhZGMyNmQzMzFmNDBlMmVhMDk2IiwidGFnIjoiIn0%3D; expires=Wed, 11-Jun-2025 18:03:56 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6IksxZE5GMzBiZUdocUU4ajBVQVdwMUE9PSIsInZhbHVlIjoiMnJZQ29aTzFIOGpWcFdwd3I5ZW5jNWpJRk44RGxqeDdmYTVCeitDMEk3bVZHYWJHQm04QVIxSlJWQ0JSOTVvQlRMNjZyW ▶"
    1 => "booking_core_session=eyJpdiI6ImNhbWE1d3JsMG8zR2lRa2sxN2hoVXc9PSIsInZhbHVlIjoiZ29CWEc2b3Z4UXlNdVo3aCtnM0c2K3Q0dWtuWFBiRytjekIxSytzYkF1QnIvZFhnbENCb2ExY3ZpZTBkd0VqM0VSQzB4T1EwK0ZsSVJtTXNuZnpiVU9OdUV0cjFyWGNwY2gyanFndm16QUtnM2tpNmhYMng4L1NNS202amJIVFoiLCJtYWMiOiJjNzVhOGVlOGRhNzYxYzk5YWNlYWUzMWU0YjQ0OTQ2M2ZmNjg4Njk5NGEyZDkzM2JjMWUwODdiNDk5YjJlNmI4IiwidGFnIjoiIn0%3D; expires=Wed, 11-Jun-2025 18:03:56 GMT; path=/; httponly ◀booking_core_session=eyJpdiI6ImNhbWE1d3JsMG8zR2lRa2sxN2hoVXc9PSIsInZhbHVlIjoiZ29CWEc2b3Z4UXlNdVo3aCtnM0c2K3Q0dWtuWFBiRytjekIxSytzYkF1QnIvZFhnbENCb2ExY3ZpZTBkd0V ▶"
  ]
]

session_attributes

  0 of 0   
array:3 [▼
  "_token" => "XBswfUdnS7xBYtJJMKRMXmxXZOIgBBu6ZoIMaDBe"
  "_previous" => array:1 [▶
    "url" => "https://aarnatours.com/hotel/castello-casole-hotel"
  ]
  "_flash" => array:2 [▶
    "old" => []
    "new" => []
  ]
]

AutoshowClear Show all

	Date ↕	Method	URL	Data
#1	2025-06-11 16:03:56	GET	/hotel/castello-casole-hotel	32 48 76

Reviews

4.8/5

Excellent

Based on 5 reviews

Very Good

Average

Poor

Terrible

04/25/2025 14:38

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

Good location, quality should be better

Beautiful spot with a lovely view

Showing 1 - 5 of 5 total

You must log in to write review

Castello Casole Hotel

Petit-Montrouge

Description

HIGHLIGHTS

Available Rooms

Property type

Facilities

Hotel Service

Rules

Location

Reviews

Easy way to discover the city

Good location, quality should be better

Easy way to discover the city

Easy way to discover the city

Beautiful spot with a lovely view

System Admin

Property type

Facilities

Hotel Service

Get Updates & More

1 x Application (63.76%)	934ms
1 x Booting (36.24%)	531ms

Castello Casole Hotel

Petit-Montrouge

Description

HIGHLIGHTS

Available Rooms

Property type

Facilities

Hotel Service

Rules

Location

Reviews

Easy way to discover the city

Good location, quality should be better

Easy way to discover the city

Easy way to discover the city

Beautiful spot with a lovely view

System Admin

Related Hotel

Hotel Stanford

Hotel WBF Hommachi

Redac Gateway Hotel

Parian Holiday Villas

Property type

Facilities

Hotel Service

Get Updates & More