Missing h1-71267 in pages/city-category

Missing p-71267 in pages/city-category

Missing h2-83945 in pages/city-category

Missing p-83945 in pages/city-category

Missing Beste in in livewire/partials/top-rated Restaurants

New York Pizza Molenwerf 18

McDonald's Ankersmidplein 141

Febo Gedempte Gracht 90

Missing Beste in in livewire/partials/top-rated Hotels

Hotel Restaurant D... Kerkbuurt 31

Best Western Grenehout 22

Park Inn La Guardiaweg 59

Missing 69245 in livewire/partials/join-us

Missing 69245-p in livewire/partials/join-us

in de buurt van:

Missing div-50914 in livewire/search/search-results

Missing div-35697 in livewire/search/search-results

Map

Menu

Business Owners

Messages1 Timeline Exceptions Views197 Route Queries74 Models437 Livewire48 Mails Gate Session Request

Request history8.2.284.73s8MBGET {route}

warninglog[11:10:32] LOG.warning: strlen(): Passing null to parameter #1 ($string) of type string is deprecate...

Booting (8.99ms)time
Application (4.72s)time
1 x Application (99.81%)
4.72s
1 x Booting (0.19%)
8.99ms

197 templates were rendered

1x pages.city-categorycity-category.blade.php#?blade
1x livewire.topbartopbar.blade.php#?blade
1x components.login-buttonlogin-button.blade.php#?blade
1x components.partials.hero-v2.defaultdefault.blade.php#?blade
1x livewire.partials.top-ratedtop-rated.blade.php#?blade
2x livewire.partials.cards.card-chainratingcard-chainrating.blade.php#?blade
6x livewire.partials.cards.card-chainrating-blockcard-chainrating-block.blade.php#?blade
6x components.common.reviews.starsstars.blade.php#?blade
1x livewire.partials.join-usjoin-us.blade.php#?blade
1x livewire.partials.city-guidescity-guides.blade.php#?blade
1x livewire.breadcrumbsbreadcrumbs.blade.php#?blade
1x components.partials.footerfooter.blade.php#?blade
1x livewire.search.search-resultssearch-results.blade.php#?blade
1x livewire.search.search-aroundsearch-around.blade.php#?blade
9x components.img-responsiveimg-responsive.blade.php#?blade
2x livewire.sidebar.cards.areaarea.blade.php#?blade
10x livewire.sidebar.cards.categorycategory.blade.php#?blade
1x static.template-parts.modal.modal-locationmodal-location.blade.php#?blade
1x components.maps.mapsmaps.blade.php#?blade
1x components.maps.staticstatic.blade.php#?blade
2x livewire.sidebar.blocks.locationslocations.blade.php#?blade
60x components.sidebar.cards.storestore.blade.php#?blade
60x components.partials.location.open-closedopen-closed.blade.php#?blade
1x layouts.mainmain.blade.php#?blade
1x meta.google-analyticsgoogle-analytics.blade.php#?blade
1x components.sidebar.headerheader.blade.php#?blade
2x livewire.search.searchsearch.blade.php#?blade
1x components.sidebar.sidebarsidebar.blade.php#?blade
2x livewire.filter.filterfilter.blade.php#?blade
2x livewire.filter.slide-inslide-in.blade.php#?blade
4x livewire.location.location-autocompletelocation-autocomplete.blade.php#?blade
1x livewire.sidebar.navigationnavigation.blade.php#?blade
1x livewire.modal.locationlocation.blade.php#?blade
1x components.sidebar.locationlocation.blade.php#?blade
1x livewire.common.local-barlocal-bar.blade.php#?blade
1x components.modal.loginlogin.blade.php#?blade
1x livewire.auth.signupsignup.blade.php#?blade
1x livewire.auth.loginlogin.blade.php#?blade
1x livewire.auth.onboardingonboarding.blade.php#?blade
1x livewire.auth.registerregister.blade.php#?blade
1x livewire.auth.forgot-passwordforgot-password.blade.php#?blade
1x livewire.auth.delete-accountdelete-account.blade.php#?blade
1x meta.yext-scriptyext-script.blade.php#?blade

uri: GET {route}
middleware: web
uses: App\Http\Controllers\DynamicRouteControllerDispatcher@__invoke
controller: App\Http\Controllers\DynamicRouteControllerDispatcher
namespace
prefix
where

73 statements were executed (10 duplicates)Show only duplicates4.42s

Connection Establishedhours_frontendDynamicRouteControllerDispatcher.php#39
Backtrace
select * from `routes` where `route` = 'Noord-Holland/Westzaan/Beauty-Spas-Wellness' limit 1
2.51mshours_frontendDynamicRouteControllerDispatcher.php#39
Bindings
Backtrace
update `routes` set `visit_count` = `visit_count` + 1, `routes`.`updated_at` = '2025-04-10 11:10:27' where `id` = 288512
650μshours_frontendDynamicRouteControllerDispatcher.php#43
Bindings
Backtrace
select * from `establishments` where `slug` = 'Noord-Holland/Westzaan/Beauty-Spas-Wellness' and `establishments`.`deleted_at` is null limit 1
890μshours_frontendBuildsGroupLimitQueries.php#38
Bindings
Backtrace
select * from `regions` where `slug` = 'Noord-Holland/Westzaan/Beauty-Spas-Wellness' limit 1
670μshours_frontendDynamicRouteControllerDispatcher.php#111
Bindings
Backtrace
select * from `categories` where `slug` = 'Noord-Holland/Westzaan/Beauty-Spas-Wellness' limit 1
620μshours_frontendBuildsGroupLimitQueries.php#38
Bindings
Backtrace
select * from `businesses` where `slug` = 'Noord-Holland/Westzaan/Beauty-Spas-Wellness' limit 1
580μshours_frontendBuildsGroupLimitQueries.php#38
Bindings
Backtrace
select * from `attributes` where `slug` = 'Noord-Holland/Westzaan/Beauty-Spas-Wellness' limit 1
550μshours_frontendDynamicRouteControllerDispatcher.php#111
Bindings
Backtrace
select * from `categories` where `slug` = 'Beauty-Spas-Wellness' limit 1
490μshours_frontendBuildsGroupLimitQueries.php#38
Bindings
Backtrace
select * from `regions` where `slug` = 'Noord-Holland/Westzaan' and `type` = 'locality' limit 1
700μshours_frontendDynamicRouteControllerDispatcher.php#195
Bindings
Backtrace
select * from `regions` where `regions`.`id` = 101808803 and `type` = 'locality' limit 1
680μshours_frontendTopbar.php#66
Bindings
Backtrace
select count(*) as aggregate from `regions` where `regions`.`locality_id` = 101808803 and `regions`.`locality_id` is not null and `type` = 'neighbourhood'
2.63mshours_frontendTopbar.php#78
Bindings
Backtrace
select count(*) as aggregate from `attributes` where `attributes`.`locality_id` = 101808803 and `attributes`.`locality_id` is not null and `subtype` = 'uk shopping area'
790μshours_frontendTopbar.php#84
Bindings
Backtrace
select count(*) as aggregate from `attributes` where `attributes`.`locality_id` = 101808803 and `attributes`.`locality_id` is not null and `subtype` = 'uk shopping street'
560μshours_frontendTopbar.php#90
Bindings
Backtrace
select * from `regions` where `regions`.`id` = 85687053 and `type` = 'region' limit 1
670μshours_frontendRegion.php#51
Bindings
Backtrace
select * from `regions` where `regions`.`id` = 101808803 and `type` = 'locality' limit 1
510μshours_frontendRegion.php#52
Bindings
Backtrace
select `slug`, `path`, `static_text`, `text` from `lang_slug` left join `lang_text` on `lang_slug_id` = `lang_slug`.`id` order by `lang_slug`.`id` desc
19.48mshours_frontendTranslations.php#17
Backtrace
select `establishments`.*, (select count(*) from `reviews` where `establishments`.`hash` = `reviews`.`reviewable_id` and `reviews`.`reviewable_type` = 'App\\Models\\Establishment' and `reviews`.`deleted_at` is null) as `reviews_count` from `establishments` where `establishments`.`locality_id` = 101808803 and `establishments`.`locality_id` is not null and exists (select * from `businesses` where `establishments`.`business_id` = `businesses`.`id` and exists (select * from `categories` where `businesses`.`category_id` = `categories`.`id` and `name` = 'Beauty, Spas & Wellness')) and `establishments`.`deleted_at` is null limit 3
190mshours_frontendBuildsGroupLimitQueries.php#38
Bindings
Backtrace
select `establishments`.*, (select count(*) from `reviews` where `establishments`.`hash` = `reviews`.`reviewable_id` and `reviews`.`reviewable_type` = 'App\\Models\\Establishment' and `reviews`.`deleted_at` is null) as `reviews_count`, establishments.*, ST_Distance_Sphere(point(establishments.longitude, establishments.latitude), point('4.77326100', '52.45120400')) AS distance from `establishments` where exists (select * from `businesses` where `establishments`.`business_id` = `businesses`.`id` and exists (select * from `categories` where `businesses`.`category_id` = `categories`.`id` and `name` = 'Beauty, Spas & Wellness')) and 1 = 1 and `establishments`.`deleted_at` is null order by `distance` asc limit 3
785mshours_frontendBuildsGroupLimitQueries.php#38
Bindings
Backtrace
select `establishments`.*, (select count(*) from `reviews` where `establishments`.`hash` = `reviews`.`reviewable_id` and `reviews`.`reviewable_type` = 'App\\Models\\Establishment' and `reviews`.`deleted_at` is null) as `reviews_count` from `establishments` where `establishments`.`locality_id` = 101808803 and `establishments`.`locality_id` is not null and exists (select * from `businesses` where `establishments`.`business_id` = `businesses`.`id` and exists (select * from `categories` where `businesses`.`category_id` = `categories`.`id` and `name` = 'Clothing')) and `establishments`.`deleted_at` is null limit 3
157mshours_frontendBuildsGroupLimitQueries.php#38
Bindings
Backtrace
select `establishments`.*, (select count(*) from `reviews` where `establishments`.`hash` = `reviews`.`reviewable_id` and `reviews`.`reviewable_type` = 'App\\Models\\Establishment' and `reviews`.`deleted_at` is null) as `reviews_count`, establishments.*, ST_Distance_Sphere(point(establishments.longitude, establishments.latitude), point('4.77326100', '52.45120400')) AS distance from `establishments` where exists (select * from `businesses` where `establishments`.`business_id` = `businesses`.`id` and exists (select * from `categories` where `businesses`.`category_id` = `categories`.`id` and `name` = 'Clothing')) and 1 = 1 and `establishments`.`deleted_at` is null order by `distance` asc limit 3
755mshours_frontendBuildsGroupLimitQueries.php#38
Bindings
Backtrace
select `establishments`.*, (select count(*) from `reviews` where `establishments`.`hash` = `reviews`.`reviewable_id` and `reviews`.`reviewable_type` = 'App\\Models\\Establishment' and `reviews`.`deleted_at` is null) as `reviews_count` from `establishments` where `establishments`.`locality_id` = 101808803 and `establishments`.`locality_id` is not null and exists (select * from `businesses` where `establishments`.`business_id` = `businesses`.`id` and exists (select * from `categories` where `businesses`.`category_id` = `categories`.`id` and `name` = 'Supermarkets')) and `establishments`.`deleted_at` is null limit 3
155mshours_frontendBuildsGroupLimitQueries.php#38
Bindings
Backtrace
select `establishments`.*, (select count(*) from `reviews` where `establishments`.`hash` = `reviews`.`reviewable_id` and `reviews`.`reviewable_type` = 'App\\Models\\Establishment' and `reviews`.`deleted_at` is null) as `reviews_count`, establishments.*, ST_Distance_Sphere(point(establishments.longitude, establishments.latitude), point('4.77326100', '52.45120400')) AS distance from `establishments` where exists (select * from `businesses` where `establishments`.`business_id` = `businesses`.`id` and exists (select * from `categories` where `businesses`.`category_id` = `categories`.`id` and `name` = 'Supermarkets')) and 1 = 1 and `establishments`.`deleted_at` is null order by `distance` asc limit 3
722mshours_frontendBuildsGroupLimitQueries.php#38
Bindings
Backtrace
select `establishments`.*, (select count(*) from `reviews` where `establishments`.`hash` = `reviews`.`reviewable_id` and `reviews`.`reviewable_type` = 'App\\Models\\Establishment' and `reviews`.`deleted_at` is null) as `reviews_count` from `establishments` where `establishments`.`locality_id` = 101808803 and `establishments`.`locality_id` is not null and exists (select * from `businesses` where `establishments`.`business_id` = `businesses`.`id` and exists (select * from `categories` where `businesses`.`category_id` = `categories`.`id` and `name` = 'Restaurants')) and `establishments`.`deleted_at` is null limit 3
160mshours_frontendBuildsGroupLimitQueries.php#38
Bindings
Backtrace
select `establishments`.*, (select count(*) from `reviews` where `establishments`.`hash` = `reviews`.`reviewable_id` and `reviews`.`reviewable_type` = 'App\\Models\\Establishment' and `reviews`.`deleted_at` is null) as `reviews_count`, establishments.*, ST_Distance_Sphere(point(establishments.longitude, establishments.latitude), point('4.77326100', '52.45120400')) AS distance from `establishments` where exists (select * from `businesses` where `establishments`.`business_id` = `businesses`.`id` and exists (select * from `categories` where `businesses`.`category_id` = `categories`.`id` and `name` = 'Restaurants')) and 1 = 1 and `establishments`.`deleted_at` is null order by `distance` asc limit 3
109mshours_frontendBuildsGroupLimitQueries.php#38
Bindings
Backtrace
select * from `businesses` where `businesses`.`id` in (5777, 6081, 6095)
660μshours_frontendBuildsGroupLimitQueries.php#38
Backtrace
select * from `categories` where `categories`.`id` in (100394)
410μshours_frontendBuildsGroupLimitQueries.php#38
Backtrace
select `establishments`.*, (select count(*) from `reviews` where `establishments`.`hash` = `reviews`.`reviewable_id` and `reviews`.`reviewable_type` = 'App\\Models\\Establishment' and `reviews`.`deleted_at` is null) as `reviews_count` from `establishments` where `establishments`.`locality_id` = 101808803 and `establishments`.`locality_id` is not null and exists (select * from `businesses` where `establishments`.`business_id` = `businesses`.`id` and exists (select * from `categories` where `businesses`.`category_id` = `categories`.`id` and `name` = 'Hotels')) and `establishments`.`deleted_at` is null limit 3
157mshours_frontendBuildsGroupLimitQueries.php#38
Bindings
Backtrace
select * from `businesses` where `businesses`.`id` in (42004)
740μshours_frontendBuildsGroupLimitQueries.php#38
Backtrace
select * from `categories` where `categories`.`id` in (100209)
590μshours_frontendBuildsGroupLimitQueries.php#38
Backtrace
select `establishments`.*, (select count(*) from `reviews` where `establishments`.`hash` = `reviews`.`reviewable_id` and `reviews`.`reviewable_type` = 'App\\Models\\Establishment' and `reviews`.`deleted_at` is null) as `reviews_count`, establishments.*, ST_Distance_Sphere(point(establishments.longitude, establishments.latitude), point('4.77326100', '52.45120400')) AS distance from `establishments` where exists (select * from `businesses` where `establishments`.`business_id` = `businesses`.`id` and exists (select * from `categories` where `businesses`.`category_id` = `categories`.`id` and `name` = 'Hotels')) and `id` not in (417470) and `establishments`.`deleted_at` is null order by `distance` asc limit 2
119mshours_frontendBuildsGroupLimitQueries.php#38
Bindings
Backtrace
select * from `businesses` where `businesses`.`id` in (68706, 82805)
650μshours_frontendBuildsGroupLimitQueries.php#38
Backtrace
select * from `categories` where `categories`.`id` in (100209)
450μshours_frontendBuildsGroupLimitQueries.php#38
Backtrace
select `establishments`.*, (select count(*) from `reviews` where `establishments`.`hash` = `reviews`.`reviewable_id` and `reviews`.`reviewable_type` = 'App\\Models\\Establishment' and `reviews`.`deleted_at` is null) as `reviews_count` from `establishments` where `establishments`.`locality_id` = 101808803 and `establishments`.`locality_id` is not null and exists (select * from `businesses` where `establishments`.`business_id` = `businesses`.`id` and exists (select * from `categories` where `businesses`.`category_id` = `categories`.`id` and `name` = 'DIY Stores')) and `establishments`.`deleted_at` is null limit 3
163mshours_frontendBuildsGroupLimitQueries.php#38
Bindings
Backtrace
select `establishments`.*, (select count(*) from `reviews` where `establishments`.`hash` = `reviews`.`reviewable_id` and `reviews`.`reviewable_type` = 'App\\Models\\Establishment' and `reviews`.`deleted_at` is null) as `reviews_count`, establishments.*, ST_Distance_Sphere(point(establishments.longitude, establishments.latitude), point('4.77326100', '52.45120400')) AS distance from `establishments` where exists (select * from `businesses` where `establishments`.`business_id` = `businesses`.`id` and exists (select * from `categories` where `businesses`.`category_id` = `categories`.`id` and `name` = 'DIY Stores')) and 1 = 1 and `establishments`.`deleted_at` is null order by `distance` asc limit 3
712mshours_frontendBuildsGroupLimitQueries.php#38
Bindings
Backtrace
select establishments.*, ST_Distance_Sphere(point(establishments.longitude, establishments.latitude), point(4.895168, 52.370216)) AS distance, `businesses`.`category_id` as `laravel_through_key` from `establishments` inner join `businesses` on `businesses`.`id` = `establishments`.`business_id` where `businesses`.`category_id` = 1000006 and `establishments`.`deleted_at` is null order by `distance` asc limit 6
1.65mshours_frontendBuildsGroupLimitQueries.php#38
Bindings
Backtrace
select *, ST_Distance_Sphere(point(longitude, latitude), point(4.895168, 52.370216)) AS distance from `regions` where `type` = 'locality' order by `distance` asc limit 1
3.89mshours_frontendUserLocation.php#51
Bindings
Backtrace
select *, ST_Distance_Sphere(point(longitude, latitude), point(4.895168, 52.370216)) AS distance from `regions` where `type` = 'neighbourhood' order by `distance` asc limit 1
6.91mshours_frontendUserLocation.php#65
Bindings
Backtrace
select *, ST_Distance_Sphere(point(longitude, latitude), point(4.895168, 52.370216)) AS distance from `attributes` where `subtype` = 'uk shopping area' order by `distance` asc limit 2
910μshours_frontendUserLocation.php#78
Bindings
Backtrace
select * from `static_maps` where (`longitude` = '4.77326100' and `latitude` = '52.45120400' and `height` = 1200 and `width` = 1200) limit 1
3.57mshours_frontendStaticMap.php#28
Bindings
Backtrace
select `id` from `categories` where `categories`.`parent_id` = 1000006 and `categories`.`parent_id` is not null
1.82mshours_frontendCategory.php#74
Bindings
Backtrace
select establishments.*, ST_Distance_Sphere(point(establishments.longitude, establishments.latitude), point('4.77326100', '52.45120400')) AS distance from `establishments` where exists (select * from `businesses` where `establishments`.`business_id` = `businesses`.`id` and `category_id` in (100010, 100047, 100116, 100195, 100246, 100247, 100302, 100328, 100360, 100407, 100446, 100449, 100457, 100504, 100544, 100580)) and `establishments`.`deleted_at` is null order by `distance` asc limit 90
73.49mshours_frontendBuildsGroupLimitQueries.php#38
Bindings
Backtrace
select * from `businesses` where `businesses`.`id` in (5698, 6162, 6185, 6588, 6664, 9979, 10696, 10806, 10911, 11269, 12364, 17479, 17480, 17888, 17976, 20404, 31084, 31152, 31267, 31895, 32194, 34323, 34663, 35007, 35918, 36297, 37444, 37527, 37794, 37999, 38404, 39375, 39573, 41754, 41777, 46930, 47838, 50336, 51520, 51609, 52275, 53497, 55198, 56638, 57451, 57924, 57969, 58005, 58007, 58020, 58073, 59567, 62217, 62714, 68673, 69319, 71099, 71373, 71584, 73928, 74814, 74828, 74942, 74947, 74951, 75128, 76627, 77156, 77692, 77827, 78324, 80634, 300861, 304437, 907119, 1107814, 1108154, 1108164, 1109576, 1113797, 1114116, 1115100, 1170401, 1170728, 1171249, 1171736, 1894417)
1.78mshours_frontendBuildsGroupLimitQueries.php#38
Backtrace
select * from `establishment_departments` where `establishment_departments`.`establishment_id` = 2115233 and `establishment_departments`.`establishment_id` is not null
780μshours_frontendHasHours.php#36
Bindings
Backtrace
select * from `establishment_departments` where `establishment_departments`.`establishment_id` = 395081 and `establishment_departments`.`establishment_id` is not null
920μshours_frontendHasHours.php#36
Bindings
Backtrace
select * from `establishment_departments` where `establishment_departments`.`establishment_id` = 582542 and `establishment_departments`.`establishment_id` is not null
750μshours_frontendHasHours.php#36
Bindings
Backtrace
select * from `establishment_departments` where `establishment_departments`.`establishment_id` = 644714 and `establishment_departments`.`establishment_id` is not null
590μshours_frontendHasHours.php#36
Bindings
Backtrace
select * from `establishment_departments` where `establishment_departments`.`establishment_id` = 598484 and `establishment_departments`.`establishment_id` is not null
620μshours_frontendHasHours.php#36
Bindings
Backtrace
select * from `establishment_departments` where `establishment_departments`.`establishment_id` = 517631 and `establishment_departments`.`establishment_id` is not null
620μshours_frontendHasHours.php#36
Bindings
Backtrace
select * from `establishment_departments` where `establishment_departments`.`establishment_id` = 552086 and `establishment_departments`.`establishment_id` is not null
530μshours_frontendHasHours.php#36
Bindings
Backtrace
select * from `establishment_departments` where `establishment_departments`.`establishment_id` = 416783 and `establishment_departments`.`establishment_id` is not null
1.03mshours_frontendHasHours.php#36
Bindings
Backtrace
select * from `establishment_departments` where `establishment_departments`.`establishment_id` = 502628 and `establishment_departments`.`establishment_id` is not null
520μshours_frontendHasHours.php#36
Bindings
Backtrace
select * from `establishment_departments` where `establishment_departments`.`establishment_id` = 399002 and `establishment_departments`.`establishment_id` is not null
830μshours_frontendHasHours.php#36
Bindings
Backtrace
select * from `establishment_departments` where `establishment_departments`.`establishment_id` = 408383 and `establishment_departments`.`establishment_id` is not null
630μshours_frontendHasHours.php#36
Bindings
Backtrace
select * from `establishment_departments` where `establishment_departments`.`establishment_id` = 468437 and `establishment_departments`.`establishment_id` is not null
650μshours_frontendHasHours.php#36
Bindings
Backtrace
select * from `establishment_departments` where `establishment_departments`.`establishment_id` = 480533 and `establishment_departments`.`establishment_id` is not null
970μshours_frontendHasHours.php#36
Bindings
Backtrace
select * from `establishment_departments` where `establishment_departments`.`establishment_id` = 2113452 and `establishment_departments`.`establishment_id` is not null
690μshours_frontendHasHours.php#36
Bindings
Backtrace
select * from `establishment_departments` where `establishment_departments`.`establishment_id` = 580946 and `establishment_departments`.`establishment_id` is not null
1.08mshours_frontendHasHours.php#36
Bindings
Backtrace
select * from `establishment_departments` where `establishment_departments`.`establishment_id` = 358829 and `establishment_departments`.`establishment_id` is not null
590μshours_frontendHasHours.php#36
Bindings
Backtrace
select * from `establishment_departments` where `establishment_departments`.`establishment_id` = 622796 and `establishment_departments`.`establishment_id` is not null
590μshours_frontendHasHours.php#36
Bindings
Backtrace
select * from `establishment_departments` where `establishment_departments`.`establishment_id` = 628676 and `establishment_departments`.`establishment_id` is not null
1.47mshours_frontendHasHours.php#36
Bindings
Backtrace
select * from `establishment_departments` where `establishment_departments`.`establishment_id` = 690899 and `establishment_departments`.`establishment_id` is not null
1.7mshours_frontendHasHours.php#36
Bindings
Backtrace
select * from `establishment_departments` where `establishment_departments`.`establishment_id` = 519557 and `establishment_departments`.`establishment_id` is not null
2.82mshours_frontendHasHours.php#36
Bindings
Backtrace
select * from `establishment_departments` where `establishment_departments`.`establishment_id` = 416708 and `establishment_departments`.`establishment_id` is not null
3.36mshours_frontendHasHours.php#36
Bindings
Backtrace
select * from `establishment_departments` where `establishment_departments`.`establishment_id` = 627182 and `establishment_departments`.`establishment_id` is not null
3.8mshours_frontendHasHours.php#36
Bindings
Backtrace
select * from `establishment_departments` where `establishment_departments`.`establishment_id` = 386288 and `establishment_departments`.`establishment_id` is not null
2.89mshours_frontendHasHours.php#36
Bindings
Backtrace
select * from `establishment_departments` where `establishment_departments`.`establishment_id` = 521606 and `establishment_departments`.`establishment_id` is not null
1.31mshours_frontendHasHours.php#36
Bindings
Backtrace
select * from `establishment_departments` where `establishment_departments`.`establishment_id` = 578393 and `establishment_departments`.`establishment_id` is not null
640μshours_frontendHasHours.php#36
Bindings
Backtrace
select * from `establishment_departments` where `establishment_departments`.`establishment_id` = 620480 and `establishment_departments`.`establishment_id` is not null
650μshours_frontendHasHours.php#36
Bindings
Backtrace
select * from `establishment_departments` where `establishment_departments`.`establishment_id` = 623318 and `establishment_departments`.`establishment_id` is not null
560μshours_frontendHasHours.php#36
Bindings
Backtrace
select * from `establishment_departments` where `establishment_departments`.`establishment_id` = 361052 and `establishment_departments`.`establishment_id` is not null
650μshours_frontendHasHours.php#36
Bindings
Backtrace
select `id` from `categories` where `categories`.`parent_id` = 1000006 and `categories`.`parent_id` is not null
520μshours_frontendCategory.php#74
Bindings
Backtrace
select establishments.*, ST_Distance_Sphere(point(establishments.longitude, establishments.latitude), point('4.77326100', '52.45120400')) AS distance from `establishments` where exists (select * from `businesses` where `establishments`.`business_id` = `businesses`.`id` and `category_id` in (100010, 100047, 100116, 100195, 100246, 100247, 100302, 100328, 100360, 100407, 100446, 100449, 100457, 100504, 100544, 100580)) and `establishments`.`deleted_at` is null order by `distance` asc limit 90
72.3mshours_frontendBuildsGroupLimitQueries.php#38
Bindings
Backtrace
select * from `businesses` where `businesses`.`id` in (5698, 6162, 6185, 6588, 6664, 9979, 10696, 10806, 10911, 11269, 12364, 17479, 17480, 17888, 17976, 20404, 31084, 31152, 31267, 31895, 32194, 34323, 34663, 35007, 35918, 36297, 37444, 37527, 37794, 37999, 38404, 39375, 39573, 41754, 41777, 46930, 47838, 50336, 51520, 51609, 52275, 53497, 55198, 56638, 57451, 57924, 57969, 58005, 58007, 58020, 58073, 59567, 62217, 62714, 68673, 69319, 71099, 71373, 71584, 73928, 74814, 74828, 74942, 74947, 74951, 75128, 76627, 77156, 77692, 77827, 78324, 80634, 300861, 304437, 907119, 1107814, 1108154, 1108164, 1109576, 1113797, 1114116, 1115100, 1170401, 1170728, 1171249, 1171736, 1894417)
1.25mshours_frontendBuildsGroupLimitQueries.php#38
Backtrace

App\Models\Establishment: 186Establishment.php#?
App\Models\Business: 180Business.php#?
App\Models\Category: 36Category.php#?
App\Models\EstablishmentDepartment: 27EstablishmentDepartment.php#?
App\Models\Region: 6Region.php#?
App\Models\Route: 1Route.php#?
App\Models\StaticMap: 1StaticMap.php#?

topbar #mzDrs4cvY8JT3UakRXCi: array:4 [ "data" => array:4 [ "user" => null "parent" => App\Models\Region {#1879 #c...
partials.top-rated #1LgCsFPGifw6vbKGtWF3: array:4 [ "data" => array:5 [ "title" => "Missing h2-83945 in pages/city-category" "descri...
partials.cards.card-chainrating #eX12fiIsDyeucZdI6H5d: array:4 [ "data" => array:3 [ "headingText" => "Missing Beste in in livewire/partials/top-rate...
partials.cards.card-chainrating-block #9cBlEG0yM6AaMzaE4E44: array:4 [ "data" => array:4 [ "establishment" => App\Models\Establishment {#4531 #connec...
partials.cards.card-chainrating-block #fiQNZRK6grsSr10kALbv: array:4 [ "data" => array:4 [ "establishment" => App\Models\Establishment {#4534 #connec...
partials.cards.card-chainrating-block #YAPmGqllNIY15vYRUV3s: array:4 [ "data" => array:4 [ "establishment" => App\Models\Establishment {#4535 #connec...
partials.cards.card-chainrating #UVKMbqcTdf4Wifl98N31: array:4 [ "data" => array:3 [ "headingText" => "Missing Beste in in livewire/partials/top-rate...
partials.cards.card-chainrating-block #K8KyOmgFIue4FNjEnRBT: array:4 [ "data" => array:4 [ "establishment" => App\Models\Establishment {#4472 #connec...
partials.cards.card-chainrating-block #TyurGpfmlg2Aof5ymxhd: array:4 [ "data" => array:4 [ "establishment" => App\Models\Establishment {#4416 #connec...
partials.cards.card-chainrating-block #dTe38Rb8eKEWNsP7yxw2: array:4 [ "data" => array:4 [ "establishment" => App\Models\Establishment {#4417 #connec...
partials.join-us #YEVmElw7zxZ1JNXux0gO: array:4 [ "data" => array:1 [ "cityName" => "Westzaan" ] "name" => "partials.join-us" "c...
partials.city-guides #pcvHeHHHSqi1WCd3ThUk: array:4 [ "data" => array:2 [ "scrollable" => null "locations" => Illuminate\Database\Eloq...
breadcrumbs #Pz97zVsHNs0xaLYhjN91: array:4 [ "data" => array:3 [ "parent" => App\Models\Region {#1879 #connection: "mysql" ...
search-results #SP6eXQEX59DSjeEzvNNg: array:4 [ "data" => array:6 [ "search" => "" "results" => [] "searchOverlayActive" => ...
partials.search-around #psZKbFzhW5kEmV20N3uk: array:4 [ "data" => array:1 [ "userLocation" => array:4 [ "longitude" => 4.895168 ...
sidebar.cards.area #ruIL2klPhrHVxXEnFdoh: array:4 [ "data" => array:1 [ "area" => App\Models\Region {#3209 #connection: "mysql" ...
sidebar.cards.area #DyqVflx74sfZvoqvK6oE: array:4 [ "data" => array:1 [ "area" => App\Models\Region {#3213 #connection: "mysql" ...
sidebar.cards.category #HTgtSOcnEN9O6mDDiMWy: array:4 [ "data" => array:2 [ "category" => App\Models\Category {#3623 #connection: "mys...
sidebar.cards.category #el4WI0rUtggAmGsFy3ev: array:4 [ "data" => array:2 [ "category" => App\Models\Category {#3218 #connection: "mys...
sidebar.cards.category #zUfw4QRYQzIlBJG0AhoJ: array:4 [ "data" => array:2 [ "category" => App\Models\Category {#3240 #connection: "mys...
sidebar.cards.category #jFo8XLi23xfw9pJ2jUy4: array:4 [ "data" => array:2 [ "category" => App\Models\Category {#3148 #connection: "mys...
sidebar.cards.category #I30xCoCLNTLnh5jlNaVi: array:4 [ "data" => array:2 [ "category" => App\Models\Category {#3378 #connection: "mys...
sidebar.cards.category #xgrImphtQv7xwahyxjMp: array:4 [ "data" => array:2 [ "category" => App\Models\Category {#3379 #connection: "mys...
sidebar.cards.category #MqiXXdjNGOI583Jen7Ym: array:4 [ "data" => array:2 [ "category" => App\Models\Category {#3380 #connection: "mys...
sidebar.cards.category #O8yjnOCA7WHVkiqdw08j: array:4 [ "data" => array:2 [ "category" => App\Models\Category {#3381 #connection: "mys...
sidebar.cards.category #9VqZwCWYtQnT6Yt9XJLS: array:4 [ "data" => array:2 [ "category" => App\Models\Category {#3382 #connection: "mys...
sidebar.cards.category #CldISmgNnqVydXQMwLIQ: array:4 [ "data" => array:2 [ "category" => App\Models\Category {#3383 #connection: "mys...
sidebar.blocks.locations #FIYjs8oaZnRv5yxTLhxB: array:4 [ "data" => array:16 [ "locations" => null "current_id" => null "heading" => "...
sidebar.blocks.locations #Yd4rxzLhm59WAWmvZeiK: array:4 [ "data" => array:16 [ "locations" => null "current_id" => null "heading" => "...
search #ZkS07oQa63KGvLwHBLNQ: array:4 [ "data" => array:1 [ "search" => "" ] "name" => "search" "component" => "App\Li...
search #9adgVrOjcHADG3KjX8a4: array:4 [ "data" => array:1 [ "search" => "" ] "name" => "search" "component" => "App\Li...
filter.filter #CzOSs6ySp4WdO9eCUlGs: array:4 [ "data" => array:5 [ "hours" => 0 "filtersAreNotEmpty" => false "showFilter" ...
filter.slide-in #iUACaY7V3awqs0VYBUts: array:4 [ "data" => array:8 [ "openFrom" => "" "openTo" => "" "dayRange" => "today" ...
location.location-autocomplete #UnflkEnB9TdX17GuQJkp: array:4 [ "data" => array:5 [ "initialLocation" => "Amsterdam, 1012 JS" "location" => "Ams...
sidebar.navigation #vVQlIjMEZFkB635zwZLY: array:4 [ "data" => [] "name" => "sidebar.navigation" "component" => "App\Livewire\Sidebar\Nav...
modal.location #neqqtriSvjBv1Im2dk9s: array:4 [ "data" => array:2 [ "classes" => [] "showModal" => false ] "name" => "modal....
location.location-autocomplete #irqjUAUcH2Nyp8pmpmml: array:4 [ "data" => array:5 [ "initialLocation" => "Amsterdam, 1012 JS" "location" => "Ams...
filter.filter #pQ6jReaW4wAHkAvdoA5V: array:4 [ "data" => array:5 [ "hours" => 0 "filtersAreNotEmpty" => false "showFilter" ...
filter.slide-in #EJGpQkZYitLBSXQ8XQxp: array:4 [ "data" => array:8 [ "openFrom" => "" "openTo" => "" "dayRange" => "today" ...
location.location-autocomplete #8BzFXq0bvMaXvj8Wqfvo: array:4 [ "data" => array:5 [ "initialLocation" => "Amsterdam, 1012 JS" "location" => "Ams...
common.local-bar #EfR0g1CIlGGZf6N6h4th: array:4 [ "data" => [] "name" => "common.local-bar" "component" => "App\Livewire\Common\LocalB...
auth.signup #3nIftt3p0t24LhuXqoQt: array:4 [ "data" => [] "name" => "auth.signup" "component" => "App\Livewire\Auth\Signup" "id...
auth.login #dU1y4mqXv88qbDVpTd4m: array:4 [ "data" => array:3 [ "email" => null "password" => null "class" => "" ] "...
auth.onboarding #fPbuYOyVBMeUaKFyqW38: array:4 [ "data" => array:6 [ "name" => null "classes" => [] "localities" => null ...
location.location-autocomplete #LFE27ZEn1zi8dxPBDkvE: array:4 [ "data" => array:5 [ "initialLocation" => "Amsterdam, 1012 JS" "location" => "Ams...
auth.register #nTjgtvMBslFszM1l8SN3: array:4 [ "data" => array:3 [ "email" => null "password" => null "class" => "" ] "...
auth.forgot-password #vIMmCTdfSy8HRRilMMAF: array:4 [ "data" => array:3 [ "email" => "" "class" => "" "successMessage" => null ]...
auth.delete-account #L3rkwOxe0rG8lna0a83X: array:4 [ "data" => [] "name" => "auth.delete-account" "component" => "App\Livewire\Auth\Delet...

_token: 1bQl2OePJkQPHbsTPSgW1reDje94o2WrwYxsPFwM
parent_page: pages.city-category
url: array:1 [ "intended" => "https://alpha.hours.com/Noord-Holland/Westzaan/Beauty-Spas-Wellness" ]
_previous: array:1 [ "url" => "https://alpha.hours.com/Noord-Holland/Westzaan/Beauty-Spas-Wellness" ]
_flash: array:2 [ "old" => [] "new" => [] ]

path_info

/Noord-Holland/Westzaan/Beauty-Spas-Wellness

status_code

status_text

OK

format

html

content_type

text/html; charset=UTF-8

request_query

[]

request_request

[]

request_headers

  0 of 0   
array:16 [▼
  "cookie" => array:1 [▶
    0 => "_pk_id.3.58f2=2ff58516a00d8310.1744283423.; _pk_ses.3.58f2=1; XSRF-TOKEN=eyJpdiI6IjMzbWlPTFJIWVFqV1RmMWR4cVB6N3c9PSIsInZhbHVlIjoiVzdsVWEvSzJ3MjBIaUR6TW05aUtXcnovRG9YRVArWGdxMjdrSVVWcW5wb1FuSmh3azhQbS8wSHR1NXVqWVZocEVmaHRZQ1NTMVkrZFNIb1kya3o4VEEzSVIzQlVCMC9obE5taCtEQTJjZzF1TjBMSjZoU05pVXRoUEY1cUUwQ24iLCJtYWMiOiI5MDJmOTE2OTk5M2M3NzAzMGQ0NTBlMzgzNmY0NmY4ZTI5Y2FjZTkxY2JmZDJmMzBhNzVmMzliY2RkZjRjMzM5IiwidGFnIjoiIn0%3D; hours_frontend_session=eyJpdiI6ImpTc3BxZ2lGM29xclFBRURYVWVyZ1E9PSIsInZhbHVlIjoiZzZzb0M4cUZkM1J3RHlrQ0F0bVp2Y3RmRXozSkErdkFMa3BvQk5HRjY5c0QyeGJOQysxLyszcGdNVWgyZjJOR1J2cW5hVjZHdmh6V1hkZkhwWlJoTWcydlIxZzVGM0ZYaGN6MHlmQjJlang0M2NrMWwzTngwSi9yTWVQdVg5WUgiLCJtYWMiOiIxMDZjNWViMzIyNmVkNDIyZTNjYzhjOTZjY2M5NDFiN2ZkZTg1ZjhlOTQ1MGM3ZDkwZDMyNDMyZjEzZjhmMjI2IiwidGFnIjoiIn0%3D ◀_pk_id.3.58f2=2ff58516a00d8310.1744283423.; _pk_ses.3.58f2=1; XSRF-TOKEN=eyJpdiI6IjMzbWlPTFJIWVFqV1RmMWR4cVB6N3c9PSIsInZhbHVlIjoiVzdsVWEvSzJ3MjBIaUR6TW05aUtXcno ▶"
  ]
  "priority" => array:1 [▶
    0 => "u=0, i"
  ]
  "accept-encoding" => array:1 [▶
    0 => "gzip, deflate, br, zstd"
  ]
  "sec-fetch-dest" => array:1 [▶
    0 => "document"
  ]
  "sec-fetch-user" => array:1 [▶
    0 => "?1"
  ]
  "sec-fetch-mode" => array:1 [▶
    0 => "navigate"
  ]
  "sec-fetch-site" => array:1 [▶
    0 => "none"
  ]
  "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"
  ]
  "user-agent" => array:1 [▶
    0 => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)"
  ]
  "upgrade-insecure-requests" => array:1 [▶
    0 => "1"
  ]
  "sec-ch-ua-platform" => array:1 [▶
    0 => ""Windows""
  ]
  "sec-ch-ua-mobile" => array:1 [▶
    0 => "?0"
  ]
  "sec-ch-ua" => array:1 [▶
    0 => ""HeadlessChrome";v="129", "Not=A?Brand";v="8", "Chromium";v="129""
  ]
  "cache-control" => array:1 [▶
    0 => "no-cache"
  ]
  "pragma" => array:1 [▶
    0 => "no-cache"
  ]
  "host" => array:1 [▶
    0 => "alpha.hours.com"
  ]
]

request_cookies

  0 of 0   
array:4 [▼
  "_pk_id_3_58f2" => null
  "_pk_ses_3_58f2" => null
  "XSRF-TOKEN" => "1bQl2OePJkQPHbsTPSgW1reDje94o2WrwYxsPFwM"
  "hours_frontend_session" => "mXm3WOF75UsmvlyvLCy7pEtU6y4ObRNwIGnwKnod"
]

response_headers

  0 of 0   
array:7 [▼
  "content-type" => array:1 [▶
    0 => "text/html; charset=UTF-8"
  ]
  "cache-control" => array:1 [▶
    0 => "max-age=0, must-revalidate, no-cache, no-store, private"
  ]
  "date" => array:1 [▶
    0 => "Thu, 10 Apr 2025 11:10:27 GMT"
  ]
  "pragma" => array:1 [▶
    0 => "no-cache"
  ]
  "expires" => array:1 [▶
    0 => "Fri, 01 Jan 1990 00:00:00 GMT"
  ]
  "set-cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6InFhZXcxWC9ZRk1xNS9XeWI3Y3V3Y0E9PSIsInZhbHVlIjoiVmprbUt3KzVsUmQybHN4dDRZU2VHTGNFSFRoVHBOWUkxa0xzcjR1QmJXb1hNVGFJaW1MRmNIeEpWYW9LTkhqQjJGWmNWaG1oNk1OOHdkKy84TWs5aXRwSWo4YVF6TkZSdFBHWkRCU215WkwySDZHZi9nbjdBZE9IaHZ3Q3pTdFEiLCJtYWMiOiJiZDMxZjg5YzI3YTVmM2NiYTE5MDljZGExNzJjMmZmZmEyYzM1N2Y5OTk1NDEwMWIxZmUzNWU5ZTU3ZTNiZjFlIiwidGFnIjoiIn0%3D; expires=Thu, 10 Apr 2025 13:10:32 GMT; Max-Age=7200; path=/; secure; samesite=lax ◀XSRF-TOKEN=eyJpdiI6InFhZXcxWC9ZRk1xNS9XeWI3Y3V3Y0E9PSIsInZhbHVlIjoiVmprbUt3KzVsUmQybHN4dDRZU2VHTGNFSFRoVHBOWUkxa0xzcjR1QmJXb1hNVGFJaW1MRmNIeEpWYW9LTkhqQjJGWmNWa ▶"
    1 => "hours_frontend_session=eyJpdiI6IjdSbURyai9pTmFnTEVLV29UOHJ2VEE9PSIsInZhbHVlIjoieHFWamFkdEdkTWlQeGdNNy9EYkd0SlRoZ3JjVzNiNDN5bmxLeitOTk05Vlh6MWxpaHErOTdnaVVlN3B5SUtIZmVlQjFBdmExYUNpU3RWTnpraU1GNG9QZnIvTDF5NEJuZ21rZnZJTytMSE1LQk1JMFlETlU5dWd2QmNYTnVIMFMiLCJtYWMiOiI0M2UyM2Q3OWFiMDQxZWUwNTk1NGU1MmZiOTg2YWRlYmM1MDMyZTM5OGI4OTFjZTAzNzJkY2VmNGM1NTRmNmVmIiwidGFnIjoiIn0%3D; expires=Thu, 10 Apr 2025 13:10:32 GMT; Max-Age=7200; path=/; httponly; samesite=lax ◀hours_frontend_session=eyJpdiI6IjdSbURyai9pTmFnTEVLV29UOHJ2VEE9PSIsInZhbHVlIjoieHFWamFkdEdkTWlQeGdNNy9EYkd0SlRoZ3JjVzNiNDN5bmxLeitOTk05Vlh6MWxpaHErOTdnaVVlN3B5S ▶"
  ]
  "Set-Cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6InFhZXcxWC9ZRk1xNS9XeWI3Y3V3Y0E9PSIsInZhbHVlIjoiVmprbUt3KzVsUmQybHN4dDRZU2VHTGNFSFRoVHBOWUkxa0xzcjR1QmJXb1hNVGFJaW1MRmNIeEpWYW9LTkhqQjJGWmNWaG1oNk1OOHdkKy84TWs5aXRwSWo4YVF6TkZSdFBHWkRCU215WkwySDZHZi9nbjdBZE9IaHZ3Q3pTdFEiLCJtYWMiOiJiZDMxZjg5YzI3YTVmM2NiYTE5MDljZGExNzJjMmZmZmEyYzM1N2Y5OTk1NDEwMWIxZmUzNWU5ZTU3ZTNiZjFlIiwidGFnIjoiIn0%3D; expires=Thu, 10-Apr-2025 13:10:32 GMT; path=/; secure ◀XSRF-TOKEN=eyJpdiI6InFhZXcxWC9ZRk1xNS9XeWI3Y3V3Y0E9PSIsInZhbHVlIjoiVmprbUt3KzVsUmQybHN4dDRZU2VHTGNFSFRoVHBOWUkxa0xzcjR1QmJXb1hNVGFJaW1MRmNIeEpWYW9LTkhqQjJGWmNWa ▶"
    1 => "hours_frontend_session=eyJpdiI6IjdSbURyai9pTmFnTEVLV29UOHJ2VEE9PSIsInZhbHVlIjoieHFWamFkdEdkTWlQeGdNNy9EYkd0SlRoZ3JjVzNiNDN5bmxLeitOTk05Vlh6MWxpaHErOTdnaVVlN3B5SUtIZmVlQjFBdmExYUNpU3RWTnpraU1GNG9QZnIvTDF5NEJuZ21rZnZJTytMSE1LQk1JMFlETlU5dWd2QmNYTnVIMFMiLCJtYWMiOiI0M2UyM2Q3OWFiMDQxZWUwNTk1NGU1MmZiOTg2YWRlYmM1MDMyZTM5OGI4OTFjZTAzNzJkY2VmNGM1NTRmNmVmIiwidGFnIjoiIn0%3D; expires=Thu, 10-Apr-2025 13:10:32 GMT; path=/; httponly ◀hours_frontend_session=eyJpdiI6IjdSbURyai9pTmFnTEVLV29UOHJ2VEE9PSIsInZhbHVlIjoieHFWamFkdEdkTWlQeGdNNy9EYkd0SlRoZ3JjVzNiNDN5bmxLeitOTk05Vlh6MWxpaHErOTdnaVVlN3B5S ▶"
  ]
]

session_attributes

  0 of 0   
array:5 [▼
  "_token" => "1bQl2OePJkQPHbsTPSgW1reDje94o2WrwYxsPFwM"
  "parent_page" => "pages.city-category"
  "url" => array:1 [▶
    "intended" => "https://alpha.hours.com/Noord-Holland/Westzaan/Beauty-Spas-Wellness"
  ]
  "_previous" => array:1 [▶
    "url" => "https://alpha.hours.com/Noord-Holland/Westzaan/Beauty-Spas-Wellness"
  ]
  "_flash" => array:2 [▶
    "old" => []
    "new" => []
  ]
]

AutoshowClear Show all

	Date ↕	Method	URL	Data
#1	2025-04-10 11:10:32	GET	/Noord-Holland/Westzaan/Beauty-Spas-Wellness	1 197 74 437 48