Missing p-85876 in pages/city-neighbourhood
0.1 km
Missing p-98723 in pages/city-neighbourhood
Missing 69245-p in livewire/partials/join-us
Bedankt voor je beoordeling. Na controle wordt deze zo snel mogelijk gepubliceerd.
0.1 km
0.1 km
0.2 km
Als je verdergaat, ga je akkoord met onzeGebruiksvoorwaardenen bevestig je dat je onzePrivacy- en cookieverklaringhebt gelezen.
Meld je aan om het meeste uit Openingstijden.nl te halen.
Inloggenmet Openingstijden.nl account
Als je verdergaat, ga je akkoord met onzeGebruiksvoorwaardenen bevestig je dat je onzePrivacy- en cookieverklaringhebt gelezen.
All your data will be deleted. You will not be able to undo this action.
| 1 x Application (98.17%) | 726ms |
| 1 x Booting (1.83%) | 13.55ms |
| Backtrace |
select * from `routes` where `route` = 'Noord-Holland/Haarlem/Kleverpark-zuid' limit 1| Bindings | |
| Backtrace |
update `routes` set `visit_count` = `visit_count` + 1, `routes`.`updated_at` = '2025-04-05 23:22:36' where `id` = 266887| Bindings | |
| Backtrace |
select * from `establishments` where `slug` = 'Noord-Holland/Haarlem/Kleverpark-zuid' and `establishments`.`deleted_at` is null limit 1| Bindings | |
| Backtrace |
select * from `regions` where `slug` = 'Noord-Holland/Haarlem/Kleverpark-zuid' limit 1| Bindings | |
| Backtrace |
select * from `reviews` where `reviews`.`reviewable_type` = 'App\\Models\\Region' and `reviews`.`reviewable_id` = 1158819087 and `reviews`.`reviewable_id` is not null and `review` is not null and `review` != '' and `reviews`.`deleted_at` is null order by `created_at` desc| Bindings | |
| Backtrace |
select * from `regions` where `regions`.`id` = 101751897 and `type` = 'locality' limit 1| Bindings | |
| Backtrace |
select count(*) as aggregate from `regions` where `regions`.`locality_id` = 101751897 and `regions`.`locality_id` is not null and `type` = 'neighbourhood'| Bindings | |
| Backtrace |
select count(*) as aggregate from `attributes` where `attributes`.`locality_id` = 101751897 and `attributes`.`locality_id` is not null and `subtype` = 'uk shopping area'| Bindings | |
| Backtrace |
select count(*) as aggregate from `attributes` where `attributes`.`locality_id` = 101751897 and `attributes`.`locality_id` is not null and `subtype` = 'uk shopping street'| Bindings | |
| Backtrace |
select * from `regions` where `regions`.`id` = 1158819087 and `type` = 'neighbourhood' limit 1| Bindings | |
| Backtrace |
select * from `regions` where `regions`.`id` = 85687053 and `type` = 'region' limit 1| Bindings | |
| Backtrace |
select * from `regions` where `regions`.`id` = 101751897 and `type` = 'locality' limit 1| 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| Backtrace |
select establishments.*, ST_Distance_Sphere(point(establishments.longitude, establishments.latitude), point('4.62973900', '52.39088600')) AS distance from `establishments` where `establishments`.`neighbourhood_id` = 1158819087 and `establishments`.`neighbourhood_id` is not null and `establishments`.`deleted_at` is null order by `distance` asc limit 4| Bindings | |
| Backtrace |
select establishments.*, ST_Distance_Sphere(point(establishments.longitude, establishments.latitude), point('4.62973900', '52.39088600')) AS distance from `establishments` where `establishments`.`neighbourhood_id` = 1158819087 and `establishments`.`neighbourhood_id` is not null and `establishments`.`deleted_at` is null order by `distance` asc limit 4| Bindings | |
| Backtrace |
select * from `businesses` where `businesses`.`id` = 8015 limit 1| Bindings | |
| Backtrace |
select * from `establishment_departments` where `establishment_departments`.`establishment_id` = 637952 and `establishment_departments`.`establishment_id` is not null| Bindings | |
| Backtrace |
select * from `businesses` where `businesses`.`id` = 32337 limit 1| Bindings | |
| Backtrace |
select * from `businesses` where `businesses`.`id` = 9394 limit 1| Bindings | |
| Backtrace |
select * from `establishment_departments` where `establishment_departments`.`establishment_id` = 680288 and `establishment_departments`.`establishment_id` is not null| Bindings | |
| Backtrace |
select * from `businesses` where `businesses`.`id` = 5778 limit 1| Bindings | |
| Backtrace |
select * from `static_maps` where (`longitude` = '4.62973900' and `latitude` = '52.39088600' and `height` = 1200 and `width` = 1200) limit 1| Bindings | |
| Backtrace |
select * from `regions` where `regions`.`locality_id` = 1158819087 and `regions`.`locality_id` is not null and `type` = 'neighbourhood' order by `location_count` desc limit 6| 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`.`neighbourhood_id` = 1158819087 and `establishments`.`neighbourhood_id` is not null and `establishments`.`deleted_at` is null order by `average_rating` desc limit 9| Bindings | |
| Backtrace |
select * from `businesses` where `businesses`.`id` = 8015 limit 1| Bindings | |
| Backtrace |
select * from `businesses` where `businesses`.`id` = 46709 limit 1| Bindings | |
| Backtrace |
select * from `businesses` where `businesses`.`id` = 5736 limit 1| Bindings | |
| Backtrace |
select * from `businesses` where `businesses`.`id` = 55201 limit 1| Bindings | |
| Backtrace |
select * from `businesses` where `businesses`.`id` = 11758 limit 1| Bindings | |
| Backtrace |
select * from `businesses` where `businesses`.`id` = 55262 limit 1| Bindings | |
| Backtrace |
select * from `businesses` where `businesses`.`id` = 55153 limit 1| Bindings | |
| Backtrace |
select * from `businesses` where `businesses`.`id` = 11775 limit 1| Bindings | |
| Backtrace |
select * from `businesses` where `businesses`.`id` = 9394 limit 1| Bindings | |
| Backtrace |
select * from `regions` where `regions`.`id` = 101751897 and `type` = 'locality' limit 1| Bindings | |
| Backtrace |
select `business_id` from `establishments` where `establishments`.`neighbourhood_id` = 1158819087 and `establishments`.`neighbourhood_id` is not null and `establishments`.`deleted_at` is null| Bindings | |
| Backtrace |
select * from `businesses` where `id` in (11758, 11775, 35801, 36793, 46709, 53316, 55153, 55203, 5736, 5778, 78933, 8015, 9394, 55262, 55201, 65613, 32337) and exists (select * from `files` where `businesses`.`id` = `files`.`fileable_id` and `files`.`fileable_type` = 'App\\Models\\Business' and `type` = 'favicon') and `is_chain` = 1 order by `locations_count` desc limit 3| 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| 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| 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| Bindings | |
| Backtrace |
select * from `regions` where `regions`.`id` = 85687053 limit 1| Bindings | |
| Backtrace |
select * from `reviews` where `reviews`.`reviewable_type` = 'App\\Models\\Region' and `reviews`.`reviewable_id` = 1158819087 and `reviews`.`reviewable_id` is not null and `review` is not null and `review` != '' and `reviews`.`deleted_at` is null order by `created_at` desc| Bindings | |
| Backtrace |
select * from `reviews` where `reviews`.`reviewable_type` = 'App\\Models\\Region' and `reviews`.`reviewable_id` = 1158819087 and `reviews`.`reviewable_id` is not null and `reviews`.`deleted_at` is null| Bindings | |
| Backtrace |
select * from `reviews` where `reviews`.`reviewable_type` = 'App\\Models\\Region' and `reviews`.`reviewable_id` = 1158819087 and `reviews`.`reviewable_id` is not null and `reviews`.`deleted_at` is null| Bindings | |
| Backtrace |
select * from `reviews` where `reviews`.`reviewable_type` = 'App\\Models\\Region' and `reviews`.`reviewable_id` = 1158819087 and `reviews`.`reviewable_id` is not null and `reviews`.`deleted_at` is null| Bindings | |
| Backtrace |
select establishments.*, ST_Distance_Sphere(point(establishments.longitude, establishments.latitude), point('4.62973900', '52.39088600')) AS distance from `establishments` where `establishments`.`neighbourhood_id` = 1158819087 and `establishments`.`neighbourhood_id` is not null and `establishments`.`deleted_at` is null order by `distance` asc limit 90| Bindings | |
| Backtrace |
select * from `businesses` where `businesses`.`id` in (5736, 5778, 8015, 9394, 11758, 11775, 32337, 35801, 36793, 46709, 53316, 55153, 55201, 55203, 55262, 65613, 78933)| Backtrace |
select * from `establishment_departments` where `establishment_departments`.`establishment_id` = 370262 and `establishment_departments`.`establishment_id` is not null| Bindings | |
| Backtrace |
select * from `establishment_departments` where `establishment_departments`.`establishment_id` = 795178 and `establishment_departments`.`establishment_id` is not null| Bindings | |
| Backtrace |
select * from `establishment_departments` where `establishment_departments`.`establishment_id` = 369452 and `establishment_departments`.`establishment_id` is not null| Bindings | |
| Backtrace |
select * from `establishment_departments` where `establishment_departments`.`establishment_id` = 434186 and `establishment_departments`.`establishment_id` is not null| Bindings | |
| Backtrace |
select * from `establishment_departments` where `establishment_departments`.`establishment_id` = 397520 and `establishment_departments`.`establishment_id` is not null| Bindings | |
| Backtrace |
select * from `establishment_departments` where `establishment_departments`.`establishment_id` = 462662 and `establishment_departments`.`establishment_id` is not null| Bindings | |
| Backtrace |
select * from `establishment_departments` where `establishment_departments`.`establishment_id` = 457166 and `establishment_departments`.`establishment_id` is not null| Bindings | |
| Backtrace |
select * from `establishment_departments` where `establishment_departments`.`establishment_id` = 462812 and `establishment_departments`.`establishment_id` is not null| Bindings | |
| Backtrace |
select * from `establishment_departments` where `establishment_departments`.`establishment_id` = 400532 and `establishment_departments`.`establishment_id` is not null| Bindings | |
| Backtrace |
select * from `establishment_departments` where `establishment_departments`.`establishment_id` = 633593 and `establishment_departments`.`establishment_id` is not null| Bindings | |
| Backtrace |
select * from `establishment_departments` where `establishment_departments`.`establishment_id` = 795352 and `establishment_departments`.`establishment_id` is not null| Bindings | |
| Backtrace |
select * from `establishment_departments` where `establishment_departments`.`establishment_id` = 793915 and `establishment_departments`.`establishment_id` is not null| Bindings | |
| Backtrace |
select establishments.*, ST_Distance_Sphere(point(establishments.longitude, establishments.latitude), point('4.62973900', '52.39088600')) AS distance from `establishments` where `establishments`.`neighbourhood_id` = 1158819087 and `establishments`.`neighbourhood_id` is not null and `establishments`.`deleted_at` is null order by `distance` asc limit 90| Bindings | |
| Backtrace |
select * from `businesses` where `businesses`.`id` in (5736, 5778, 8015, 9394, 11758, 11775, 32337, 35801, 36793, 46709, 53316, 55153, 55201, 55203, 55262, 65613, 78933)| Backtrace |
select * from `regions` where `regions`.`id` = 101751897 and `type` = 'locality' limit 1| Bindings | |
| Backtrace |
200
[]
[]
0 of 0array: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" ] ]
[]
0 of 0array: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:22:36 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=eyJpdiI6ImY5T2xCQUd5TUdweHhiVTQyMjA4TVE9PSIsInZhbHVlIjoiWEcrRzRPeXFMekpHa3FnZ1lEaktKOG5uUmw4eTVHNVhzZHQ0R2FSUG9ScHkzcThONVJnL043ckZuVDhoNFhqZjhXT3dCQXhkdVVpY3k3ZWwrQjZZS240OFFrOVQxQU50eUtRSm1RcFR1MUVKZ0RpMEhvRzAySGk3NjFFNXV1TXQiLCJtYWMiOiJjMzU0NDQ3NGY4M2VmZmQ1ZTYxOWYxMmUyZDI5MGZmZTQ2ZDgxMThkYjNiYzVhMGU4NTUzOWU2Njg3ZjA4Yjk1IiwidGFnIjoiIn0%3D; expires=Sun, 06 Apr 2025 01:22:37 GMT; Max-Age=7200; path=/; secure; samesite=lax ◀XSRF-TOKEN=eyJpdiI6ImY5T2xCQUd5TUdweHhiVTQyMjA4TVE9PSIsInZhbHVlIjoiWEcrRzRPeXFMekpHa3FnZ1lEaktKOG5uUmw4eTVHNVhzZHQ0R2FSUG9ScHkzcThONVJnL043ckZuVDhoNFhqZjhXT3dCQ ▶" 1 => "hours_frontend_session=eyJpdiI6ImluUnFrVi9tT2FhakNlbThPSCt3Smc9PSIsInZhbHVlIjoidm5GV2FZOVJCUEc3Um9BU1Q1bWFSd2FiYjVuRFk1WExDVjg1THg5bzl1a3RVU1pTVDNveFQ4Tk9QZzBnSW9wN3pzQVdKZUM0d0h1Q3NHb2JQdzJWUGRBaWREM1RZcU5pTDdGRFJ0UkU2L2hIODJpUzgvR1BvZXFBMVVwaE50SjIiLCJtYWMiOiJkMzMyYWQ4MWE4YWEzOWIyNGM3YzllM2ZjMDVlYTg5MmZlMzgyMzYwMDdjZjY4ZWMwODg3ZDk2MmM2YTRiNjUxIiwidGFnIjoiIn0%3D; expires=Sun, 06 Apr 2025 01:22:37 GMT; Max-Age=7200; path=/; httponly; samesite=lax ◀hours_frontend_session=eyJpdiI6ImluUnFrVi9tT2FhakNlbThPSCt3Smc9PSIsInZhbHVlIjoidm5GV2FZOVJCUEc3Um9BU1Q1bWFSd2FiYjVuRFk1WExDVjg1THg5bzl1a3RVU1pTVDNveFQ4Tk9QZzBnS ▶" ] "Set-Cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6ImY5T2xCQUd5TUdweHhiVTQyMjA4TVE9PSIsInZhbHVlIjoiWEcrRzRPeXFMekpHa3FnZ1lEaktKOG5uUmw4eTVHNVhzZHQ0R2FSUG9ScHkzcThONVJnL043ckZuVDhoNFhqZjhXT3dCQXhkdVVpY3k3ZWwrQjZZS240OFFrOVQxQU50eUtRSm1RcFR1MUVKZ0RpMEhvRzAySGk3NjFFNXV1TXQiLCJtYWMiOiJjMzU0NDQ3NGY4M2VmZmQ1ZTYxOWYxMmUyZDI5MGZmZTQ2ZDgxMThkYjNiYzVhMGU4NTUzOWU2Njg3ZjA4Yjk1IiwidGFnIjoiIn0%3D; expires=Sun, 06-Apr-2025 01:22:37 GMT; path=/; secure ◀XSRF-TOKEN=eyJpdiI6ImY5T2xCQUd5TUdweHhiVTQyMjA4TVE9PSIsInZhbHVlIjoiWEcrRzRPeXFMekpHa3FnZ1lEaktKOG5uUmw4eTVHNVhzZHQ0R2FSUG9ScHkzcThONVJnL043ckZuVDhoNFhqZjhXT3dCQ ▶" 1 => "hours_frontend_session=eyJpdiI6ImluUnFrVi9tT2FhakNlbThPSCt3Smc9PSIsInZhbHVlIjoidm5GV2FZOVJCUEc3Um9BU1Q1bWFSd2FiYjVuRFk1WExDVjg1THg5bzl1a3RVU1pTVDNveFQ4Tk9QZzBnSW9wN3pzQVdKZUM0d0h1Q3NHb2JQdzJWUGRBaWREM1RZcU5pTDdGRFJ0UkU2L2hIODJpUzgvR1BvZXFBMVVwaE50SjIiLCJtYWMiOiJkMzMyYWQ4MWE4YWEzOWIyNGM3YzllM2ZjMDVlYTg5MmZlMzgyMzYwMDdjZjY4ZWMwODg3ZDk2MmM2YTRiNjUxIiwidGFnIjoiIn0%3D; expires=Sun, 06-Apr-2025 01:22:37 GMT; path=/; httponly ◀hours_frontend_session=eyJpdiI6ImluUnFrVi9tT2FhakNlbThPSCt3Smc9PSIsInZhbHVlIjoidm5GV2FZOVJCUEc3Um9BU1Q1bWFSd2FiYjVuRFk1WExDVjg1THg5bzl1a3RVU1pTVDNveFQ4Tk9QZzBnS ▶" ] ]
0 of 0array:5 [▼ "_token" => "AzUrqK2L7B44IzgLU0bfigdCJp2GIlkbPXsp5aTi" "parent_page" => "pages.city-neighbourhood" "url" => array:1 [▶ "intended" => "https://alpha.hours.com/Noord-Holland/Haarlem/Kleverpark-zuid" ] "_previous" => array:1 [▶ "url" => "https://alpha.hours.com/Noord-Holland/Haarlem/Kleverpark-zuid" ] "_flash" => array:2 [▶ "old" => [] "new" => [] ] ]