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

Snackpoint Zuivelweg 8

Café Cafetaria Zal... Meester Nelissenstra...

Cafetaria Smugrill Oudestraat 54

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

Berkelpalace Hotel... Hambroekweg 8

Hotel Café Restaur... Eibergseweg 13

Avenarius Hampshir... Dorpsstraat 2

Missing 69245 in livewire/partials/join-us

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

in de buurt van:

Keuken Kampioen

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

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

Map

Menu

Business Owners

Messages1 Timeline Exceptions Views193 Route Queries73 Models536 Livewire48 Mails Gate Session Request

Request history8.2.285.1s7MBGET {route}

warninglog[23:01:08] LOG.warning: strlen(): Passing null to parameter #1 ($string) of type string is deprecate...

Booting (8.17ms)time
Application (5.09s)time
1 x Application (99.84%)
5.09s
1 x Booting (0.16%)
8.17ms

193 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
5x 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

72 statements were executed (8 duplicates)Show only duplicates4.65s

Connection Establishedhours_frontendDynamicRouteControllerDispatcher.php#39
Backtrace
select * from `routes` where `route` = 'Gelderland/Borculo/Home-Garden' limit 1
5.38mshours_frontendDynamicRouteControllerDispatcher.php#39
Bindings
Backtrace
update `routes` set `visit_count` = `visit_count` + 1, `routes`.`updated_at` = '2025-04-05 23:01:08' where `id` = 297150
970μshours_frontendDynamicRouteControllerDispatcher.php#43
Bindings
Backtrace
select * from `establishments` where `slug` = 'Gelderland/Borculo/Home-Garden' and `establishments`.`deleted_at` is null limit 1
1.13mshours_frontendBuildsGroupLimitQueries.php#38
Bindings
Backtrace
select * from `regions` where `slug` = 'Gelderland/Borculo/Home-Garden' limit 1
960μshours_frontendDynamicRouteControllerDispatcher.php#111
Bindings
Backtrace
select * from `categories` where `slug` = 'Gelderland/Borculo/Home-Garden' limit 1
810μshours_frontendBuildsGroupLimitQueries.php#38
Bindings
Backtrace
select * from `businesses` where `slug` = 'Gelderland/Borculo/Home-Garden' limit 1
520μshours_frontendBuildsGroupLimitQueries.php#38
Bindings
Backtrace
select * from `attributes` where `slug` = 'Gelderland/Borculo/Home-Garden' limit 1
570μshours_frontendDynamicRouteControllerDispatcher.php#111
Bindings
Backtrace
select * from `categories` where `slug` = 'Home-Garden' limit 1
510μshours_frontendBuildsGroupLimitQueries.php#38
Bindings
Backtrace
select * from `regions` where `slug` = 'Gelderland/Borculo' and `type` = 'locality' limit 1
830μshours_frontendDynamicRouteControllerDispatcher.php#195
Bindings
Backtrace
select * from `regions` where `regions`.`id` = 101807061 and `type` = 'locality' limit 1
1.89mshours_frontendTopbar.php#66
Bindings
Backtrace
select count(*) as aggregate from `regions` where `regions`.`locality_id` = 101807061 and `regions`.`locality_id` is not null and `type` = 'neighbourhood'
4.95mshours_frontendTopbar.php#78
Bindings
Backtrace
select count(*) as aggregate from `attributes` where `attributes`.`locality_id` = 101807061 and `attributes`.`locality_id` is not null and `subtype` = 'uk shopping area'
1.07mshours_frontendTopbar.php#84
Bindings
Backtrace
select count(*) as aggregate from `attributes` where `attributes`.`locality_id` = 101807061 and `attributes`.`locality_id` is not null and `subtype` = 'uk shopping street'
820μshours_frontendTopbar.php#90
Bindings
Backtrace
select * from `regions` where `regions`.`id` = 85687043 and `type` = 'region' limit 1
690μshours_frontendRegion.php#51
Bindings
Backtrace
select * from `regions` where `regions`.`id` = 101807061 and `type` = 'locality' limit 1
720μ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
25.7mshours_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` = 101807061 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` = 'Home & Garden')) and `establishments`.`deleted_at` is null limit 3
192mshours_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('6.51252500', '52.10587700')) 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` = 'Home & Garden')) and 1 = 1 and `establishments`.`deleted_at` is null order by `distance` asc limit 3
751mshours_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` = 101807061 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
168mshours_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('6.51252500', '52.10587700')) 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
684mshours_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` = 101807061 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
174mshours_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('6.51252500', '52.10587700')) 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
695mshours_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` = 101807061 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
179mshours_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('6.51252500', '52.10587700')) 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
122mshours_frontendBuildsGroupLimitQueries.php#38
Bindings
Backtrace
select * from `businesses` where `businesses`.`id` in (6120, 43102, 73286)
2.45mshours_frontendBuildsGroupLimitQueries.php#38
Backtrace
select * from `categories` where `categories`.`id` in (100394)
2.46mshours_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` = 101807061 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
177mshours_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('6.51252500', '52.10587700')) 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 1 = 1 and `establishments`.`deleted_at` is null order by `distance` asc limit 3
139mshours_frontendBuildsGroupLimitQueries.php#38
Bindings
Backtrace
select * from `businesses` where `businesses`.`id` in (42220, 59264, 81055)
14.65mshours_frontendBuildsGroupLimitQueries.php#38
Backtrace
select * from `categories` where `categories`.`id` in (100209)
5.69mshours_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` = 101807061 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
178mshours_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('6.51252500', '52.10587700')) 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
669mshours_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` = 1000008 and `establishments`.`deleted_at` is null order by `distance` asc limit 6
2.87mshours_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
4.4mshours_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
8.46mshours_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
970μshours_frontendUserLocation.php#78
Bindings
Backtrace
select * from `static_maps` where (`longitude` = '6.51252500' and `latitude` = '52.10587700' and `height` = 1200 and `width` = 1200) limit 1
2.71mshours_frontendStaticMap.php#28
Bindings
Backtrace
select `id` from `categories` where `categories`.`parent_id` = 1000008 and `categories`.`parent_id` is not null
3.68mshours_frontendCategory.php#74
Bindings
Backtrace
select establishments.*, ST_Distance_Sphere(point(establishments.longitude, establishments.latitude), point('6.51252500', '52.10587700')) AS distance from `establishments` where exists (select * from `businesses` where `establishments`.`business_id` = `businesses`.`id` and `category_id` in (100011, 100067, 100070, 100072, 100077, 100119, 100146, 100194, 100198, 100199, 100211, 100213, 100225, 100226, 100227, 100249, 100252, 100253, 100261, 100262, 100274, 100280, 100285, 100289, 100308, 100310, 100311, 100315, 100331, 100343, 100354, 100367, 100379, 100385, 100395, 100397, 100401, 100404, 100408, 100409, 100410, 100411, 100416, 100420, 100423, 100425, 100448, 100451, 100460, 100477, 100478, 100479, 100480, 100510, 100511, 100512, 100520, 100539, 100545, 100560, 100561, 100565, 100569, 100570)) and `establishments`.`deleted_at` is null order by `distance` asc limit 90
150mshours_frontendBuildsGroupLimitQueries.php#38
Bindings
Backtrace
select * from `businesses` where `businesses`.`id` in (5660, 5734, 6182, 30568, 31469, 31744, 33742, 35215, 35347, 35903, 36256, 38881, 42195, 42593, 42614, 43333, 43871, 44754, 48713, 50431, 50711, 50918, 51319, 51490, 51565, 51652, 51970, 52360, 53339, 53613, 53843, 53985, 57463, 57533, 58946, 59321, 59328, 59496, 62809, 63942, 64144, 64454, 69750, 69814, 73003, 75019, 75516, 76216, 76359, 78806, 79903, 309369, 1104316, 1105196, 1105244, 1105395, 1105788, 1105873, 1105946, 1107025, 1107217, 1108422, 1108428, 1108439, 1108595, 1108642, 1110953, 1113256, 1113469, 1113579, 1113903, 1113908, 1114016, 1114065, 1114127, 1114654, 1114671, 1115424, 1115563, 1170528, 1171106, 1171270, 1171290, 1171335, 1171412, 1171518, 1171528, 1172084)
3.37mshours_frontendBuildsGroupLimitQueries.php#38
Backtrace
select * from `establishment_departments` where `establishment_departments`.`establishment_id` = 2114166 and `establishment_departments`.`establishment_id` is not null
1.37mshours_frontendHasHours.php#36
Bindings
Backtrace
select * from `establishment_departments` where `establishment_departments`.`establishment_id` = 545294 and `establishment_departments`.`establishment_id` is not null
1.22mshours_frontendHasHours.php#36
Bindings
Backtrace
select * from `establishment_departments` where `establishment_departments`.`establishment_id` = 2113956 and `establishment_departments`.`establishment_id` is not null
2.25mshours_frontendHasHours.php#36
Bindings
Backtrace
select * from `establishment_departments` where `establishment_departments`.`establishment_id` = 2114223 and `establishment_departments`.`establishment_id` is not null
2.86mshours_frontendHasHours.php#36
Bindings
Backtrace
select * from `establishment_departments` where `establishment_departments`.`establishment_id` = 2158221 and `establishment_departments`.`establishment_id` is not null
3.52mshours_frontendHasHours.php#36
Bindings
Backtrace
select * from `establishment_departments` where `establishment_departments`.`establishment_id` = 548954 and `establishment_departments`.`establishment_id` is not null
3mshours_frontendHasHours.php#36
Bindings
Backtrace
select * from `establishment_departments` where `establishment_departments`.`establishment_id` = 384008 and `establishment_departments`.`establishment_id` is not null
2.39mshours_frontendHasHours.php#36
Bindings
Backtrace
select * from `establishment_departments` where `establishment_departments`.`establishment_id` = 2120574 and `establishment_departments`.`establishment_id` is not null
3.63mshours_frontendHasHours.php#36
Bindings
Backtrace
select * from `establishment_departments` where `establishment_departments`.`establishment_id` = 395714 and `establishment_departments`.`establishment_id` is not null
1.31mshours_frontendHasHours.php#36
Bindings
Backtrace
select * from `establishment_departments` where `establishment_departments`.`establishment_id` = 502670 and `establishment_departments`.`establishment_id` is not null
1.73mshours_frontendHasHours.php#36
Bindings
Backtrace
select * from `establishment_departments` where `establishment_departments`.`establishment_id` = 2110336 and `establishment_departments`.`establishment_id` is not null
2.61mshours_frontendHasHours.php#36
Bindings
Backtrace
select * from `establishment_departments` where `establishment_departments`.`establishment_id` = 2120432 and `establishment_departments`.`establishment_id` is not null
2.51mshours_frontendHasHours.php#36
Bindings
Backtrace
select * from `establishment_departments` where `establishment_departments`.`establishment_id` = 427625 and `establishment_departments`.`establishment_id` is not null
2.02mshours_frontendHasHours.php#36
Bindings
Backtrace
select * from `establishment_departments` where `establishment_departments`.`establishment_id` = 2119140 and `establishment_departments`.`establishment_id` is not null
2.89mshours_frontendHasHours.php#36
Bindings
Backtrace
select * from `establishment_departments` where `establishment_departments`.`establishment_id` = 2113970 and `establishment_departments`.`establishment_id` is not null
2.72mshours_frontendHasHours.php#36
Bindings
Backtrace
select * from `establishment_departments` where `establishment_departments`.`establishment_id` = 2119472 and `establishment_departments`.`establishment_id` is not null
3.49mshours_frontendHasHours.php#36
Bindings
Backtrace
select * from `establishment_departments` where `establishment_departments`.`establishment_id` = 2158971 and `establishment_departments`.`establishment_id` is not null
3.86mshours_frontendHasHours.php#36
Bindings
Backtrace
select * from `establishment_departments` where `establishment_departments`.`establishment_id` = 2157329 and `establishment_departments`.`establishment_id` is not null
5.19mshours_frontendHasHours.php#36
Bindings
Backtrace
select * from `establishment_departments` where `establishment_departments`.`establishment_id` = 2121380 and `establishment_departments`.`establishment_id` is not null
4.04mshours_frontendHasHours.php#36
Bindings
Backtrace
select * from `establishment_departments` where `establishment_departments`.`establishment_id` = 419396 and `establishment_departments`.`establishment_id` is not null
5.62mshours_frontendHasHours.php#36
Bindings
Backtrace
select * from `establishment_departments` where `establishment_departments`.`establishment_id` = 2113951 and `establishment_departments`.`establishment_id` is not null
7.53mshours_frontendHasHours.php#36
Bindings
Backtrace
select * from `establishment_departments` where `establishment_departments`.`establishment_id` = 452078 and `establishment_departments`.`establishment_id` is not null
2.33mshours_frontendHasHours.php#36
Bindings
Backtrace
select * from `establishment_departments` where `establishment_departments`.`establishment_id` = 548969 and `establishment_departments`.`establishment_id` is not null
3.76mshours_frontendHasHours.php#36
Bindings
Backtrace
select * from `establishment_departments` where `establishment_departments`.`establishment_id` = 2119965 and `establishment_departments`.`establishment_id` is not null
3.1mshours_frontendHasHours.php#36
Bindings
Backtrace
select * from `establishment_departments` where `establishment_departments`.`establishment_id` = 550790 and `establishment_departments`.`establishment_id` is not null
3.28mshours_frontendHasHours.php#36
Bindings
Backtrace
select * from `establishment_departments` where `establishment_departments`.`establishment_id` = 470219 and `establishment_departments`.`establishment_id` is not null
1.63mshours_frontendHasHours.php#36
Bindings
Backtrace
select * from `establishment_departments` where `establishment_departments`.`establishment_id` = 3282879 and `establishment_departments`.`establishment_id` is not null
4.03mshours_frontendHasHours.php#36
Bindings
Backtrace
select * from `establishment_departments` where `establishment_departments`.`establishment_id` = 453398 and `establishment_departments`.`establishment_id` is not null
4.2mshours_frontendHasHours.php#36
Bindings
Backtrace
select * from `establishment_departments` where `establishment_departments`.`establishment_id` = 457295 and `establishment_departments`.`establishment_id` is not null
3.4mshours_frontendHasHours.php#36
Bindings
Backtrace
select `id` from `categories` where `categories`.`parent_id` = 1000008 and `categories`.`parent_id` is not null
4.03mshours_frontendCategory.php#74
Bindings
Backtrace
select establishments.*, ST_Distance_Sphere(point(establishments.longitude, establishments.latitude), point('6.51252500', '52.10587700')) AS distance from `establishments` where exists (select * from `businesses` where `establishments`.`business_id` = `businesses`.`id` and `category_id` in (100011, 100067, 100070, 100072, 100077, 100119, 100146, 100194, 100198, 100199, 100211, 100213, 100225, 100226, 100227, 100249, 100252, 100253, 100261, 100262, 100274, 100280, 100285, 100289, 100308, 100310, 100311, 100315, 100331, 100343, 100354, 100367, 100379, 100385, 100395, 100397, 100401, 100404, 100408, 100409, 100410, 100411, 100416, 100420, 100423, 100425, 100448, 100451, 100460, 100477, 100478, 100479, 100480, 100510, 100511, 100512, 100520, 100539, 100545, 100560, 100561, 100565, 100569, 100570)) and `establishments`.`deleted_at` is null order by `distance` asc limit 90
169mshours_frontendBuildsGroupLimitQueries.php#38
Bindings
Backtrace
select * from `businesses` where `businesses`.`id` in (5660, 5734, 6182, 30568, 31469, 31744, 33742, 35215, 35347, 35903, 36256, 38881, 42195, 42593, 42614, 43333, 43871, 44754, 48713, 50431, 50711, 50918, 51319, 51490, 51565, 51652, 51970, 52360, 53339, 53613, 53843, 53985, 57463, 57533, 58946, 59321, 59328, 59496, 62809, 63942, 64144, 64454, 69750, 69814, 73003, 75019, 75516, 76216, 76359, 78806, 79903, 309369, 1104316, 1105196, 1105244, 1105395, 1105788, 1105873, 1105946, 1107025, 1107217, 1108422, 1108428, 1108439, 1108595, 1108642, 1110953, 1113256, 1113469, 1113579, 1113903, 1113908, 1114016, 1114065, 1114127, 1114654, 1114671, 1115424, 1115563, 1170528, 1171106, 1171270, 1171290, 1171335, 1171412, 1171518, 1171528, 1172084)
9.35mshours_frontendBuildsGroupLimitQueries.php#38
Backtrace

App\Models\Establishment: 186Establishment.php#?
App\Models\Business: 182Business.php#?
App\Models\Category: 131Category.php#?
App\Models\EstablishmentDepartment: 29EstablishmentDepartment.php#?
App\Models\Region: 6Region.php#?
App\Models\Route: 1Route.php#?
App\Models\StaticMap: 1StaticMap.php#?

topbar #zOd0gOz32NkI4BZuvOse: array:4 [ "data" => array:4 [ "user" => null "parent" => App\Models\Region {#1879 #c...
partials.top-rated #4nVm16zSA4T1n7Z9mfWw: array:4 [ "data" => array:5 [ "title" => "Missing h2-83945 in pages/city-category" "descri...
partials.cards.card-chainrating #IO02W0tnvDWm8TG0Xm5a: array:4 [ "data" => array:3 [ "headingText" => "Missing Beste in in livewire/partials/top-rate...
partials.cards.card-chainrating-block #HnN299GNTOlUZYFf8GJD: array:4 [ "data" => array:4 [ "establishment" => App\Models\Establishment {#4538 #connec...
partials.cards.card-chainrating-block #6BR1XrDllLk1xwXNPDWd: array:4 [ "data" => array:4 [ "establishment" => App\Models\Establishment {#4541 #connec...
partials.cards.card-chainrating-block #odTVVICkR23bmOYwNVG2: array:4 [ "data" => array:4 [ "establishment" => App\Models\Establishment {#4542 #connec...
partials.cards.card-chainrating #KspEstyJDoRLSxS2QXwc: array:4 [ "data" => array:3 [ "headingText" => "Missing Beste in in livewire/partials/top-rate...
partials.cards.card-chainrating-block #KaIg4cs43SjaTa9xByeF: array:4 [ "data" => array:4 [ "establishment" => App\Models\Establishment {#4445 #connec...
partials.cards.card-chainrating-block #tjPNjTu7eDzQqDjlayGz: array:4 [ "data" => array:4 [ "establishment" => App\Models\Establishment {#4446 #connec...
partials.cards.card-chainrating-block #beAcSloasvLcFKB6H4l0: array:4 [ "data" => array:4 [ "establishment" => App\Models\Establishment {#4447 #connec...
partials.join-us #c3rnFCzDuIKvnHZto4w0: array:4 [ "data" => array:1 [ "cityName" => "Borculo" ] "name" => "partials.join-us" "co...
partials.city-guides #c30VzyHramfhpzxiT8mW: array:4 [ "data" => array:2 [ "scrollable" => null "locations" => Illuminate\Database\Eloq...
breadcrumbs #9Z6VrqtTLFP6NfQlV3WQ: array:4 [ "data" => array:3 [ "parent" => App\Models\Region {#1879 #connection: "mysql" ...
search-results #ulvI6iacj30mn8orhhLx: array:4 [ "data" => array:6 [ "search" => "" "results" => [] "searchOverlayActive" => ...
partials.search-around #WT7t1r1ye3uuommwpH6J: array:4 [ "data" => array:1 [ "userLocation" => array:4 [ "longitude" => 4.895168 ...
sidebar.cards.area #8fjhM17eGUShWEurnJxH: array:4 [ "data" => array:1 [ "area" => App\Models\Region {#3497 #connection: "mysql" ...
sidebar.cards.area #Cy88HaIp9TQOFLDbI5AV: array:4 [ "data" => array:1 [ "area" => App\Models\Region {#3501 #connection: "mysql" ...
sidebar.cards.category #TAfYzvLsqdplcQdC3U4p: array:4 [ "data" => array:2 [ "category" => App\Models\Category {#3506 #connection: "mys...
sidebar.cards.category #yykPYRS6d9icZRe2YKeT: array:4 [ "data" => array:2 [ "category" => App\Models\Category {#3413 #connection: "mys...
sidebar.cards.category #ltpfDmFItjyu4nic0Opy: array:4 [ "data" => array:2 [ "category" => App\Models\Category {#3851 #connection: "mys...
sidebar.cards.category #gxeIUZhpVsyEPQ72CxGI: array:4 [ "data" => array:2 [ "category" => App\Models\Category {#3483 #connection: "mys...
sidebar.cards.category #iDiSUSIcfyFj2agpKnLd: array:4 [ "data" => array:2 [ "category" => App\Models\Category {#3356 #connection: "mys...
sidebar.cards.category #KEGSjEpoaErniZ8PKTqe: array:4 [ "data" => array:2 [ "category" => App\Models\Category {#3355 #connection: "mys...
sidebar.cards.category #zpcPC2lChvltJ0aQcraF: array:4 [ "data" => array:2 [ "category" => App\Models\Category {#3354 #connection: "mys...
sidebar.cards.category #QNvBpkbLUcb0tvx3UpxB: array:4 [ "data" => array:2 [ "category" => App\Models\Category {#3353 #connection: "mys...
sidebar.cards.category #BzgsWaauAYXiNsulFFXS: array:4 [ "data" => array:2 [ "category" => App\Models\Category {#3352 #connection: "mys...
sidebar.cards.category #iFypqcX8ByFk6mghXadA: array:4 [ "data" => array:2 [ "category" => App\Models\Category {#3351 #connection: "mys...
sidebar.blocks.locations #X22MuZZePCk3TE4bWoYR: array:4 [ "data" => array:16 [ "locations" => null "current_id" => null "heading" => "...
sidebar.blocks.locations #QrrisyUKdDe23778naXh: array:4 [ "data" => array:16 [ "locations" => null "current_id" => null "heading" => "...
search #m3dybDJ158VXFOKc0pdp: array:4 [ "data" => array:1 [ "search" => "" ] "name" => "search" "component" => "App\Li...
search #DXxodoHNvcRbZepsWqi6: array:4 [ "data" => array:1 [ "search" => "" ] "name" => "search" "component" => "App\Li...
filter.filter #dSIa7oERr5Z6kuFEdpBu: array:4 [ "data" => array:5 [ "hours" => 0 "filtersAreNotEmpty" => false "showFilter" ...
filter.slide-in #lG1Qd0O3FXF4A0oqTvTc: array:4 [ "data" => array:8 [ "openFrom" => "" "openTo" => "" "dayRange" => "today" ...
location.location-autocomplete #iFBWtBSeb6MhobqAajxE: array:4 [ "data" => array:5 [ "initialLocation" => "Amsterdam, 1012 JS" "location" => "Ams...
sidebar.navigation #MeSjvv2c25NvE8pp7KYc: array:4 [ "data" => [] "name" => "sidebar.navigation" "component" => "App\Livewire\Sidebar\Nav...
modal.location #bsWNNbTR78BdsSv4nueQ: array:4 [ "data" => array:2 [ "classes" => [] "showModal" => false ] "name" => "modal....
location.location-autocomplete #OUSzQR1YNYE41aUeAH4p: array:4 [ "data" => array:5 [ "initialLocation" => "Amsterdam, 1012 JS" "location" => "Ams...
filter.filter #sMad6hkmHG6KLSdOEGpj: array:4 [ "data" => array:5 [ "hours" => 0 "filtersAreNotEmpty" => false "showFilter" ...
filter.slide-in #QmXI5OkmOQM7eVCjyQF4: array:4 [ "data" => array:8 [ "openFrom" => "" "openTo" => "" "dayRange" => "today" ...
location.location-autocomplete #0liAtApgdJ97BI8ftMYS: array:4 [ "data" => array:5 [ "initialLocation" => "Amsterdam, 1012 JS" "location" => "Ams...
common.local-bar #Zj5Gv6mVszGCo3VQpapC: array:4 [ "data" => [] "name" => "common.local-bar" "component" => "App\Livewire\Common\LocalB...
auth.signup #wESur96SJAMEdwX2HpFM: array:4 [ "data" => [] "name" => "auth.signup" "component" => "App\Livewire\Auth\Signup" "id...
auth.login #MmAleGWbNCiFqlggTK7g: array:4 [ "data" => array:3 [ "email" => null "password" => null "class" => "" ] "...
auth.onboarding #16l3b3vFfdNd2AjIFSO6: array:4 [ "data" => array:6 [ "name" => null "classes" => [] "localities" => null ...
location.location-autocomplete #F2WIN90Oy3l9eIMsWk5G: array:4 [ "data" => array:5 [ "initialLocation" => "Amsterdam, 1012 JS" "location" => "Ams...
auth.register #PpSMd0f1RqgsFpthQT3C: array:4 [ "data" => array:3 [ "email" => null "password" => null "class" => "" ] "...
auth.forgot-password #4X5quO5NTWgEuxqc5CS9: array:4 [ "data" => array:3 [ "email" => "" "class" => "" "successMessage" => null ]...
auth.delete-account #mI8rntWuuMdG45blHDz6: array:4 [ "data" => [] "name" => "auth.delete-account" "component" => "App\Livewire\Auth\Delet...

_token: riq3zNeDw1BQguu2wgAJbDXuXePrBp9osTvASuPL
parent_page: pages.city-category
url: array:1 [ "intended" => "https://alpha.hours.com/Gelderland/Borculo/Home-Garden" ]
_previous: array:1 [ "url" => "https://alpha.hours.com/Gelderland/Borculo/Home-Garden" ]
_flash: array:2 [ "old" => [] "new" => [] ]

path_info

/Gelderland/Borculo/Home-Garden

status_code

status_text

OK

format

html

content_type

text/html; charset=UTF-8

request_query

[]

request_request

[]

request_headers

  0 of 0   
array:15 [▼
  "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

[]

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 => "Sat, 05 Apr 2025 23:01:08 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=eyJpdiI6IngxWlBjTW92N0ZmdVpJcm9LS1k3VVE9PSIsInZhbHVlIjoiWDFVcDYrT0swVTUwY3VQc05BTUYyOHZ2NEdTWmxiY05DRUM1cDRyaWgxWXlQdzJTYkM5RjEwVXluQmFia3pWZXpSajFQT1hOWE1Wak5qdWRtdGw5clpDNVV0cjdHT0tmU1VmR242NElodmZXZTBLVVNiWTE4Mk85YUQvVlFyL2siLCJtYWMiOiJjODNmOWNiOWY2NTI4NDVlYTdiZTcxYWFiZGI4ZjMyODk5NmZmNTY2NjA4YzE0OGRhNWJjMDY1MDMzNDZjNjQ3IiwidGFnIjoiIn0%3D; expires=Sun, 06 Apr 2025 01:01:13 GMT; Max-Age=7200; path=/; secure; samesite=lax ◀XSRF-TOKEN=eyJpdiI6IngxWlBjTW92N0ZmdVpJcm9LS1k3VVE9PSIsInZhbHVlIjoiWDFVcDYrT0swVTUwY3VQc05BTUYyOHZ2NEdTWmxiY05DRUM1cDRyaWgxWXlQdzJTYkM5RjEwVXluQmFia3pWZXpSajFQT ▶"
    1 => "hours_frontend_session=eyJpdiI6ImhZVmR6MWFaT0pLcFVMVzVFNjUrZnc9PSIsInZhbHVlIjoiY1FRUHBOWDV3dFQ4SnpySlB6RWZ5Mk9PY2xvQ0pNNU5nd2ZwZHA5bGRPcjVFUFRzbHRZMjRNOUl2MW1TOHZVVW1BSDhrQ3RVOUhURTREdC95UHBWcEZZekZCYXhUMWxTak9FS25XR0FVNVlWakx1M2pWbyt5OW1XaXF4eDhEMXoiLCJtYWMiOiI5OGEyYWYwOTVhZDhkZGRmN2M0ZTRjYWQ4ZGI2YTc3YTFjMDU1YzE1ZTJmYTg3ODYxYjU4YzIyM2Y2MTdiZTBkIiwidGFnIjoiIn0%3D; expires=Sun, 06 Apr 2025 01:01:13 GMT; Max-Age=7200; path=/; httponly; samesite=lax ◀hours_frontend_session=eyJpdiI6ImhZVmR6MWFaT0pLcFVMVzVFNjUrZnc9PSIsInZhbHVlIjoiY1FRUHBOWDV3dFQ4SnpySlB6RWZ5Mk9PY2xvQ0pNNU5nd2ZwZHA5bGRPcjVFUFRzbHRZMjRNOUl2MW1TO ▶"
  ]
  "Set-Cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IngxWlBjTW92N0ZmdVpJcm9LS1k3VVE9PSIsInZhbHVlIjoiWDFVcDYrT0swVTUwY3VQc05BTUYyOHZ2NEdTWmxiY05DRUM1cDRyaWgxWXlQdzJTYkM5RjEwVXluQmFia3pWZXpSajFQT1hOWE1Wak5qdWRtdGw5clpDNVV0cjdHT0tmU1VmR242NElodmZXZTBLVVNiWTE4Mk85YUQvVlFyL2siLCJtYWMiOiJjODNmOWNiOWY2NTI4NDVlYTdiZTcxYWFiZGI4ZjMyODk5NmZmNTY2NjA4YzE0OGRhNWJjMDY1MDMzNDZjNjQ3IiwidGFnIjoiIn0%3D; expires=Sun, 06-Apr-2025 01:01:13 GMT; path=/; secure ◀XSRF-TOKEN=eyJpdiI6IngxWlBjTW92N0ZmdVpJcm9LS1k3VVE9PSIsInZhbHVlIjoiWDFVcDYrT0swVTUwY3VQc05BTUYyOHZ2NEdTWmxiY05DRUM1cDRyaWgxWXlQdzJTYkM5RjEwVXluQmFia3pWZXpSajFQT ▶"
    1 => "hours_frontend_session=eyJpdiI6ImhZVmR6MWFaT0pLcFVMVzVFNjUrZnc9PSIsInZhbHVlIjoiY1FRUHBOWDV3dFQ4SnpySlB6RWZ5Mk9PY2xvQ0pNNU5nd2ZwZHA5bGRPcjVFUFRzbHRZMjRNOUl2MW1TOHZVVW1BSDhrQ3RVOUhURTREdC95UHBWcEZZekZCYXhUMWxTak9FS25XR0FVNVlWakx1M2pWbyt5OW1XaXF4eDhEMXoiLCJtYWMiOiI5OGEyYWYwOTVhZDhkZGRmN2M0ZTRjYWQ4ZGI2YTc3YTFjMDU1YzE1ZTJmYTg3ODYxYjU4YzIyM2Y2MTdiZTBkIiwidGFnIjoiIn0%3D; expires=Sun, 06-Apr-2025 01:01:13 GMT; path=/; httponly ◀hours_frontend_session=eyJpdiI6ImhZVmR6MWFaT0pLcFVMVzVFNjUrZnc9PSIsInZhbHVlIjoiY1FRUHBOWDV3dFQ4SnpySlB6RWZ5Mk9PY2xvQ0pNNU5nd2ZwZHA5bGRPcjVFUFRzbHRZMjRNOUl2MW1TO ▶"
  ]
]

session_attributes

  0 of 0   
array:5 [▼
  "_token" => "riq3zNeDw1BQguu2wgAJbDXuXePrBp9osTvASuPL"
  "parent_page" => "pages.city-category"
  "url" => array:1 [▶
    "intended" => "https://alpha.hours.com/Gelderland/Borculo/Home-Garden"
  ]
  "_previous" => array:1 [▶
    "url" => "https://alpha.hours.com/Gelderland/Borculo/Home-Garden"
  ]
  "_flash" => array:2 [▶
    "old" => []
    "new" => []
  ]
]

AutoshowClear Show all

	Date ↕	Method	URL	Data
#1	2025-04-05 23:01:13	GET	/Gelderland/Borculo/Home-Garden	1 193 73 536 48