BEST OF WEST VILLAGE

Messages Timeline Exceptions Views30 Route Queries35 Models47 Mails Auth Gate Session Request

Request history8.0.301.62s37MBGET egy/space/{slug}

Booting (524ms)time
Application (1.09s)time
1 x Application (67.57%)
1.09s
1 x Booting (32.43%)
524ms

30 templates were rendered

1x Space::frontend.detaildetail.blade.php#?blade
1x Layout::parts.bcbc.blade.php#?blade
1x Space::frontend.layouts.details.space-bannerspace-banner.blade.php#?blade
1x Space::frontend.layouts.details.space-detailspace-detail.blade.php#?blade
1x Space::frontend.layouts.details.space-attributesspace-attributes.blade.php#?blade
1x Hotel::frontend.layouts.details.hotel-surroundinghotel-surrounding.blade.php#?blade
1x Space::frontend.layouts.details.space-reviewspace-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 Space::frontend.layouts.details.space-form-bookspace-form-book.blade.php#?blade
1x Booking::frontend.global.enquiry-formenquiry-form.blade.php#?blade
1x Space::frontend.layouts.details.space-relatedspace-related.blade.php#?blade
1x Space::frontend.layouts.details.space-form-book-mobilespace-form-book-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 egy/space/{slug}
middleware: web
controller: Modules\Space\Controllers\SpaceController@detail
namespace: Modules\Space\Controllers
prefix: egy/space
where
as: space.detail
file: modules/Space/Controllers/SpaceController.php:96-132

35 statements were executed (6 duplicates)Show only duplicates55.55ms

SpaceController.php#98aarnatours290425_abhi_tNt2.87msselect * from `bravo_spaces` where `slug` = 'best-of-west-village' and `bravo_spaces`.`deleted_at` is null limit 1

Bindings	0: best-of-west-village
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/Space/Controllers/SpaceController.php:98 vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 modules/Space/Controllers/SpaceController.php:35 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 vendor/laravel/framework/src/Illuminate/Routing/Route.php:260

SpaceController.php#98aarnatours290425_abhi_tNt500μsselect * from `bravo_locations` where `bravo_locations`.`id` in (4) and `bravo_locations`.`deleted_at` is null

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

SpaceController.php#98aarnatours290425_abhi_tNt840μsselect * from `bravo_location_translations` where `locale` = 'egy' and `bravo_location_translations`.`origin_id` in (4)

Bindings	0: egy
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	modules/Space/Controllers/SpaceController.php:98 vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 modules/Space/Controllers/SpaceController.php:35 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 vendor/laravel/framework/src/Illuminate/Routing/Route.php:260

SpaceController.php#98aarnatours290425_abhi_tNt600μs

select * from `bravo_space_translations` where `locale` = 'egy' and `bravo_space_translations`.`origin_id` in (4) and `bravo_space_translations`.`deleted_at` is null

Bindings	0: egy
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	modules/Space/Controllers/SpaceController.php:98 vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 modules/Space/Controllers/SpaceController.php:35 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 vendor/laravel/framework/src/Illuminate/Routing/Route.php:260

SpaceController.php#98aarnatours290425_abhi_tNt540μsselect * from `user_wishlist` where `object_model` = 'space' and `user_id` = 0 and `user_wishlist`.`object_id` in (4)

Bindings	0: space 1: 0
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	modules/Space/Controllers/SpaceController.php:98 vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 modules/Space/Controllers/SpaceController.php:35 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 vendor/laravel/framework/src/Illuminate/Routing/Route.php:260

SpaceController.php#106aarnatours290425_abhi_tNt930μs

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

Bindings	0: 4 1: publish 2: 4
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/Space/Controllers/SpaceController.php:106 vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 modules/Space/Controllers/SpaceController.php:35 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 vendor/laravel/framework/src/Illuminate/Routing/Route.php:260

Space.php#711aarnatours290425_abhi_tNt830μs

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

Bindings	0: 4 1: space 2: approved
Backtrace	modules/Space/Models/Space.php:711 modules/Space/Controllers/SpaceController.php:108 vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 modules/Space/Controllers/SpaceController.php:35 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43

Space.php#711aarnatours290425_abhi_tNt1.51ms

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

Bindings	0: 4 1: space 2: approved
Backtrace	modules/Space/Models/Space.php:711 modules/Space/Controllers/SpaceController.php:108 vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 modules/Space/Controllers/SpaceController.php:35 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43

Space.php#711aarnatours290425_abhi_tNt570μs

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

Backtrace

modules/Space/Models/Space.php:711
modules/Space/Controllers/SpaceController.php:108
vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
modules/Space/Controllers/SpaceController.php:35
vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43

SpaceController.php#113aarnatours290425_abhi_tNt1.08msselect * 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/Space/Controllers/SpaceController.php:113 vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 modules/Space/Controllers/SpaceController.php:35 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 vendor/laravel/framework/src/Illuminate/Routing/Route.php:260

SpaceController.php#113aarnatours290425_abhi_tNt750μs

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

Bindings	0: egy
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	modules/Space/Controllers/SpaceController.php:113 vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 modules/Space/Controllers/SpaceController.php:35 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 vendor/laravel/framework/src/Illuminate/Routing/Route.php:260

BaseModel.php#199aarnatours290425_abhi_tNt870μsselect * from `bravo_seo` where `object_id` = 4 and `object_model` = 'space_translation_egy' limit 1

Bindings	0: 4 1: space_translation_egy
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:214 modules/Space/Controllers/SpaceController.php:116 vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 modules/Space/Controllers/SpaceController.php:35

QueryBuilder.php#165aarnatours290425_abhi_tNt800μs

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

Bindings	0: 8 1: 4
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/Space/Controllers/SpaceController.php:125 vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 modules/Space/Controllers/SpaceController.php:35

Space.php#657aarnatours290425_abhi_tNt1.28ms

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

Bindings	0: 4 1: space 2: approved
Hints	`LIMIT` without `ORDER BY` causes non-deterministic results, depending on the query execution plan
Backtrace	modules/Space/Models/Space.php:657 view::Space::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

Space.php#669aarnatours290425_abhi_tNt1.19ms

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

Bindings	0: 4 1: space 2: approved
Hints	`LIMIT` without `ORDER BY` causes non-deterministic results, depending on the query execution plan
Backtrace	modules/Space/Models/Space.php:669 view::Space::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_tNt1.26ms

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

Bindings	0: 4 1: space 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::Space::frontend.layouts.details.space-detail:25 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

space-attributes.blade.php#2aarnatours290425_abhi_tNt1.02msselect * from `bravo_space_term` where `bravo_space_term`.`target_id` = 4 and `bravo_space_term`.`target_id` is not null

Bindings	0: 4
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	view::Space::frontend.layouts.details.space-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_tNt1.18ms

select * from `bravo_terms` where `bravo_terms`.`id` in (15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 26, 27, 29, 30, 31) 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::Space::frontend.layouts.details.space-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_tNt880μs

select * from `bravo_terms_translations` where `locale` = 'egy' and `bravo_terms_translations`.`origin_id` in (15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 26, 27, 29, 30, 31)

Bindings	0: egy
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	modules/Core/Models/Terms.php:40 view::Space::frontend.layouts.details.space-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_tNt6.68msselect * from `bravo_attrs` where `bravo_attrs`.`id` in (3, 4) and `bravo_attrs`.`deleted_at` is null

Bindings	0: 3 1: 4
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	modules/Core/Models/Terms.php:40 view::Space::frontend.layouts.details.space-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_tNt1.15ms

select * from `bravo_attrs_translations` where `bravo_attrs_translations`.`origin_id` = 3 and `bravo_attrs_translations`.`origin_id` is not null and `locale` = 'egy' limit 1

Bindings	0: 3 1: egy
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::Space::frontend.layouts.details.space-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_tNt520μs

select * from `bravo_attrs_translations` where `bravo_attrs_translations`.`origin_id` = 4 and `bravo_attrs_translations`.`origin_id` is not null and `locale` = 'egy' limit 1

Bindings	0: 4 1: egy
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::Space::frontend.layouts.details.space-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_tNt12.63msselect * from `bravo_review_meta` where `review_id` = 65 and `name` = 'upload_picture' limit 1

Bindings	0: 65 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_tNt450μ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.93msselect * from `bravo_review_meta` where `review_id` = 64 and `name` = 'upload_picture' limit 1

Bindings	0: 64 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_tNt510μ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_tNt5.29msselect * from `bravo_review_meta` where `review_id` = 63 and `name` = 'upload_picture' limit 1

Bindings	0: 63 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_tNt2.28msselect * from `bravo_review_meta` where `review_id` = 62 and `name` = 'upload_picture' limit 1

Bindings	0: 62 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_tNt410μ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_tNt630μsselect * from `users` where `users`.`id` = 6 and `users`.`deleted_at` is null limit 1

Bindings	0: 6
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_tNt400μsselect * from `user_meta` where (`user_id` = 6 and `name` = 'social_meta_avatar') limit 1

Bindings	0: 6 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

HasTranslations.php#51aarnatours290425_abhi_tNt820μs

select * from `core_menu_translations` where `core_menu_translations`.`origin_id` = 1 and `core_menu_translations`.`origin_id` is not null and `locale` = 'egy' limit 1

Bindings	0: 1 1: egy
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_tNt790μs

select * from `core_menu_translations` where `core_menu_translations`.`origin_id` = 1 and `core_menu_translations`.`origin_id` is not null and `locale` = 'egy' limit 1

Bindings	0: 1 1: egy
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_tNt820μ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\Space\Models\SpaceTerm: 15SpaceTerm.php#?
Modules\Core\Models\Terms: 15Terms.php#?
Modules\Review\Models\Review: 7Review.php#?
Modules\Location\Models\LocationCategory: 3LocationCategory.php#?
Modules\Core\Models\Attributes: 2Attributes.php#?
Modules\Core\Models\MenuTranslation: 2MenuTranslation.php#?
Modules\Space\Models\Space: 1Space.php#?
Modules\Location\Models\Location: 1Location.php#?
App\User: 1User.php#?

web: null
sanctum: null

_token: rAuZHYs4ZNbaxUs9LicJ9GyyPDociC6aKuZati9J
bc_current_currency: jpy
_previous: array:1 [ "url" => "https://aarnatours.com/egy/space/best-of-west-village" ]
_flash: array:2 [ "old" => [] "new" => [] ]

path_info

/egy/space/best-of-west-village

status_code

status_text

format

html

content_type

text/html; charset=UTF-8

request_query

[]

request_request

[]

request_headers

  0 of 0   
array:17 [▼
  "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"
  ]
  "cookie" => array:1 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IlphUGQxdlM4UW40MSsvZElvRFVaVXc9PSIsInZhbHVlIjoiTVAvLzRHY2VmWE1jZ1A5VnNQT1RHaXI2ejhxUlRubW9rQXZxRHlIVEdTWTZSaFFLcWwrVERrR0dKazFmbzBEdDJhYjUzbDBOOElzSTliQ01DcE5zTlA2NG5OOXVQTlRzYVZkc3FrVzlyVTFDL1lBMi9JUkR5WFI2Ky9pOFZzanYiLCJtYWMiOiI0NjMyOWE5YTkyOTBkY2EzZWVmOTNjZjNlOTQ0MDJiMjdhZjhkNzViYzE5ZjA4ZWI2MTA0Y2Y3Nzc0ZDZkN2E0IiwidGFnIjoiIn0%3D; booking_core_session=eyJpdiI6IksxZ1VDRFFubFM1WkVLb1ZLa291RGc9PSIsInZhbHVlIjoiNHI2U0pQSXEwcHk2MVNDOEJVbkY5Y0w5ZmJCcHhudUszWW9BczhuWGRTWEpzSXZCaGVKWk1VWlFtSnhZbXlTVjVxakhub2hKYWxVRGpjTnpIb0ptMzNhQ1VGYmJRZ3JJVTRPNVBXdnRSWG5LRXJLQzZOVGtIb1FWTGVzeDlCdUsiLCJtYWMiOiI2ZWY3ZWU1N2MyZjhkMjk2NGVlNmEyNDcyMzJhOTI0ZjcxZjc0MWFkODc1NTVjMTJiOGJhNGFkMWU2MWIyM2ZkIiwidGFnIjoiIn0%3D ◀XSRF-TOKEN=eyJpdiI6IlphUGQxdlM4UW40MSsvZElvRFVaVXc9PSIsInZhbHVlIjoiTVAvLzRHY2VmWE1jZ1A5VnNQT1RHaXI2ejhxUlRubW9rQXZxRHlIVEdTWTZSaFFLcWwrVERrR0dKazFmbzBEdDJhYjUzb ▶"
  ]
  "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

  0 of 0   
array:2 [▼
  "XSRF-TOKEN" => "rAuZHYs4ZNbaxUs9LicJ9GyyPDociC6aKuZati9J"
  "booking_core_session" => "wgXRjhDTulUqe7xC9XDSoHSM1nd9PinYl97i8Iql"
]

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 => "Sat, 14 Jun 2025 17:54:31 GMT"
  ]
  "set-cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IkR5NkxDbHg1MDhST0U0c0tOd09tY2c9PSIsInZhbHVlIjoib0NHQVVUd1FrUFdZbUFZdjMvb3ZxZlBxWlI2WENlQVdXbDM4dkJHL1lLRUgxYVV5eUJFdkFkVENWaTB6S0RoOU5WY0ZWVzhHZWdFdG9wVDgxVTVXWGE0ZzBDbnlZZWVVUFlkRTFCWm5YZ1R2SGNaR0pGZE94OHY1c3ZJNmFEdEciLCJtYWMiOiJjZGRkZDlkNzIyMmUwNjJjNWMxMmFiYWEyMzgyNWY5OGEyMzI4NjQ5YWUwYTE4ZjE4MWRkNTJhZThjOWE3N2FmIiwidGFnIjoiIn0%3D; expires=Sat, 14-Jun-2025 19:54:32 GMT; Max-Age=7200; path=/; samesite=lax ◀XSRF-TOKEN=eyJpdiI6IkR5NkxDbHg1MDhST0U0c0tOd09tY2c9PSIsInZhbHVlIjoib0NHQVVUd1FrUFdZbUFZdjMvb3ZxZlBxWlI2WENlQVdXbDM4dkJHL1lLRUgxYVV5eUJFdkFkVENWaTB6S0RoOU5WY0ZWV ▶"
    1 => "booking_core_session=eyJpdiI6InNKZC92U3ByZUsxN001aTBORGt6R2c9PSIsInZhbHVlIjoielpuK1ZCWTRIOHRWQWtuaFZaeDI5ZXVYaGZQbHdjZEQ3QWN1WXVPeDI1UDdXT1I3ZVpXMFpoS3BDYTBOdzY0YUl2UGtYZFh6K2trd3ovY0UzUmZNS0pyeWhzZHNkZjZiMmoraGJwYTk5OC9ldlhuTnd4MC93V3lFa0wrM2ErZG4iLCJtYWMiOiI0NWM1ZGM2NDdjZTI5MTQ2NDcxYmQ2ZmVkZDBjYWI3YTdkZTdjODQ2N2MwZGZkMjNiODIxZWVkNzc4MmRjY2FjIiwidGFnIjoiIn0%3D; expires=Sat, 14-Jun-2025 19:54:32 GMT; Max-Age=7200; path=/; httponly; samesite=lax ◀booking_core_session=eyJpdiI6InNKZC92U3ByZUsxN001aTBORGt6R2c9PSIsInZhbHVlIjoielpuK1ZCWTRIOHRWQWtuaFZaeDI5ZXVYaGZQbHdjZEQ3QWN1WXVPeDI1UDdXT1I3ZVpXMFpoS3BDYTBOdzY ▶"
  ]
  "Set-Cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IkR5NkxDbHg1MDhST0U0c0tOd09tY2c9PSIsInZhbHVlIjoib0NHQVVUd1FrUFdZbUFZdjMvb3ZxZlBxWlI2WENlQVdXbDM4dkJHL1lLRUgxYVV5eUJFdkFkVENWaTB6S0RoOU5WY0ZWVzhHZWdFdG9wVDgxVTVXWGE0ZzBDbnlZZWVVUFlkRTFCWm5YZ1R2SGNaR0pGZE94OHY1c3ZJNmFEdEciLCJtYWMiOiJjZGRkZDlkNzIyMmUwNjJjNWMxMmFiYWEyMzgyNWY5OGEyMzI4NjQ5YWUwYTE4ZjE4MWRkNTJhZThjOWE3N2FmIiwidGFnIjoiIn0%3D; expires=Sat, 14-Jun-2025 19:54:32 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6IkR5NkxDbHg1MDhST0U0c0tOd09tY2c9PSIsInZhbHVlIjoib0NHQVVUd1FrUFdZbUFZdjMvb3ZxZlBxWlI2WENlQVdXbDM4dkJHL1lLRUgxYVV5eUJFdkFkVENWaTB6S0RoOU5WY0ZWV ▶"
    1 => "booking_core_session=eyJpdiI6InNKZC92U3ByZUsxN001aTBORGt6R2c9PSIsInZhbHVlIjoielpuK1ZCWTRIOHRWQWtuaFZaeDI5ZXVYaGZQbHdjZEQ3QWN1WXVPeDI1UDdXT1I3ZVpXMFpoS3BDYTBOdzY0YUl2UGtYZFh6K2trd3ovY0UzUmZNS0pyeWhzZHNkZjZiMmoraGJwYTk5OC9ldlhuTnd4MC93V3lFa0wrM2ErZG4iLCJtYWMiOiI0NWM1ZGM2NDdjZTI5MTQ2NDcxYmQ2ZmVkZDBjYWI3YTdkZTdjODQ2N2MwZGZkMjNiODIxZWVkNzc4MmRjY2FjIiwidGFnIjoiIn0%3D; expires=Sat, 14-Jun-2025 19:54:32 GMT; path=/; httponly ◀booking_core_session=eyJpdiI6InNKZC92U3ByZUsxN001aTBORGt6R2c9PSIsInZhbHVlIjoielpuK1ZCWTRIOHRWQWtuaFZaeDI5ZXVYaGZQbHdjZEQ3QWN1WXVPeDI1UDdXT1I3ZVpXMFpoS3BDYTBOdzY ▶"
  ]
]

session_attributes

  0 of 0   
array:4 [▼
  "_token" => "rAuZHYs4ZNbaxUs9LicJ9GyyPDociC6aKuZati9J"
  "bc_current_currency" => "jpy"
  "_previous" => array:1 [▶
    "url" => "https://aarnatours.com/egy/space/best-of-west-village"
  ]
  "_flash" => array:2 [▶
    "old" => []
    "new" => []
  ]
]

AutoshowClear Show all

	Date ↕	Method	URL	Data
#1	2025-06-14 17:54:32	GET	/egy/space/best-of-west-village	30 35 47

Reviews

4.3/5

Very Good

Based on 4 reviews

Excellent

Average

Poor

Terrible

04/25/2025 14:38

Great Trip

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

Trip was great

Easy way to discover the city

Showing 1 - 4 of 4 total

You must log in to write review

BEST OF WEST VILLAGE

No. Bed

No. Bathroom

Square

Location

Description

HIGHLIGHTS

Space Type

Amenities

FAQs

Check-in time?

Check-out time?

Is Reception open 24 hours?

Which languages are spoken at Reception?

Can I leave my luggage?

Internet connection?

Location

Reviews

Great Trip

Great Trip

Trip was great

Easy way to discover the city

Lynne Victoria

Extra prices:

Get Updates & More

1 x Application (67.57%)	1.09s
1 x Booting (32.43%)	524ms