Missing p-85876 in pages/city-neighbourhood
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.6 km
0.6 km
0.6 km
0.6 km
0.6 km
0.6 km
0.6 km
0.6 km
0.6 km
0.6 km
0.6 km
0.7 km
0.7 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.84%) | 872ms |
| 1 x Booting (1.15%) | 10.18ms |
| Backtrace |
select * from `routes` where `route` = 'Noord-Holland/Nieuw-Vennep/Getsewoud-Zuid' limit 1| Bindings | |
| Backtrace |
update `routes` set `visit_count` = `visit_count` + 1, `routes`.`updated_at` = '2025-04-06 02:43:03' where `id` = 276983| Bindings | |
| Backtrace |
select * from `establishments` where `slug` = 'Noord-Holland/Nieuw-Vennep/Getsewoud-Zuid' and `establishments`.`deleted_at` is null limit 1| Bindings | |
| Backtrace |
select * from `regions` where `slug` = 'Noord-Holland/Nieuw-Vennep/Getsewoud-Zuid' limit 1| Bindings | |
| Backtrace |
select * from `reviews` where `reviews`.`reviewable_type` = 'App\\Models\\Region' and `reviews`.`reviewable_id` = 1158819279 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` = 101803713 and `type` = 'locality' limit 1| Bindings | |
| Backtrace |
select count(*) as aggregate from `regions` where `regions`.`locality_id` = 101803713 and `regions`.`locality_id` is not null and `type` = 'neighbourhood'| Bindings | |
| Backtrace |
select count(*) as aggregate from `attributes` where `attributes`.`locality_id` = 101803713 and `attributes`.`locality_id` is not null and `subtype` = 'uk shopping area'| Bindings | |
| Backtrace |
select count(*) as aggregate from `attributes` where `attributes`.`locality_id` = 101803713 and `attributes`.`locality_id` is not null and `subtype` = 'uk shopping street'| Bindings | |
| Backtrace |
select * from `regions` where `regions`.`id` = 1158819279 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` = 101803713 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.61130300', '52.26967200')) AS distance from `establishments` where `establishments`.`neighbourhood_id` = 1158819279 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.61130300', '52.26967200')) AS distance from `establishments` where `establishments`.`neighbourhood_id` = 1158819279 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` = 1115508 limit 1| Bindings | |
| Backtrace |
select * from `establishment_departments` where `establishment_departments`.`establishment_id` = 2121467 and `establishment_departments`.`establishment_id` is not null| Bindings | |
| Backtrace |
select * from `businesses` where `businesses`.`id` = 1149315 limit 1| Bindings | |
| Backtrace |
select * from `establishment_departments` where `establishment_departments`.`establishment_id` = 2150269 and `establishment_departments`.`establishment_id` is not null| Bindings | |
| Backtrace |
select * from `businesses` where `businesses`.`id` = 49393 limit 1| Bindings | |
| Backtrace |
select * from `establishment_departments` where `establishment_departments`.`establishment_id` = 443468 and `establishment_departments`.`establishment_id` is not null| Bindings | |
| Backtrace |
select * from `businesses` where `businesses`.`id` = 50081 limit 1| Bindings | |
| Backtrace |
select * from `establishment_departments` where `establishment_departments`.`establishment_id` = 445655 and `establishment_departments`.`establishment_id` is not null| Bindings | |
| Backtrace |
select * from `static_maps` where (`longitude` = '4.61130300' and `latitude` = '52.26967200' and `height` = 1200 and `width` = 1200) limit 1| Bindings | |
| Backtrace |
select * from `regions` where `regions`.`locality_id` = 1158819279 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` = 1158819279 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` = 5773 limit 1| Bindings | |
| Backtrace |
select * from `businesses` where `businesses`.`id` = 6068 limit 1| Bindings | |
| Backtrace |
select * from `businesses` where `businesses`.`id` = 1111876 limit 1| Bindings | |
| Backtrace |
select * from `businesses` where `businesses`.`id` = 5889 limit 1| Bindings | |
| Backtrace |
select * from `businesses` where `businesses`.`id` = 49393 limit 1| Bindings | |
| Backtrace |
select * from `businesses` where `businesses`.`id` = 69080 limit 1| Bindings | |
| Backtrace |
select * from `businesses` where `businesses`.`id` = 5814 limit 1| Bindings | |
| Backtrace |
select * from `businesses` where `businesses`.`id` = 5743 limit 1| Bindings | |
| Backtrace |
select * from `businesses` where `businesses`.`id` = 5688 limit 1| Bindings | |
| Backtrace |
select * from `regions` where `regions`.`id` = 101803713 and `type` = 'locality' limit 1| Bindings | |
| Backtrace |
select `business_id` from `establishments` where `establishments`.`neighbourhood_id` = 1158819279 and `establishments`.`neighbourhood_id` is not null and `establishments`.`deleted_at` is null| Bindings | |
| Backtrace |
select * from `businesses` where `id` in (11509, 49393, 50081, 5688, 5706, 57349, 5743, 5744, 5773, 5778, 5813, 5814, 5823, 5889, 6068, 6081, 6087, 6107, 71567, 1111876, 1115508, 1149315, 1170407, 69080) 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` = 1158819279 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` = 1158819279 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` = 1158819279 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` = 1158819279 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.61130300', '52.26967200')) AS distance from `establishments` where `establishments`.`neighbourhood_id` = 1158819279 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 (5688, 5706, 5743, 5744, 5773, 5778, 5813, 5814, 5823, 5889, 6068, 6081, 6087, 6107, 11509, 49393, 50081, 57349, 69080, 71567, 1111876, 1115508, 1149315, 1170407)| Backtrace |
select * from `establishment_departments` where `establishment_departments`.`establishment_id` = 2117689 and `establishment_departments`.`establishment_id` is not null| Bindings | |
| Backtrace |
select * from `establishment_departments` where `establishment_departments`.`establishment_id` = 500699 and `establishment_departments`.`establishment_id` is not null| Bindings | |
| Backtrace |
select * from `establishment_departments` where `establishment_departments`.`establishment_id` = 529841 and `establishment_departments`.`establishment_id` is not null| Bindings | |
| Backtrace |
select * from `establishment_departments` where `establishment_departments`.`establishment_id` = 569270 and `establishment_departments`.`establishment_id` is not null| Bindings | |
| Backtrace |
select * from `establishment_departments` where `establishment_departments`.`establishment_id` = 510995 and `establishment_departments`.`establishment_id` is not null| Bindings | |
| Backtrace |
select * from `establishment_departments` where `establishment_departments`.`establishment_id` = 524378 and `establishment_departments`.`establishment_id` is not null| Bindings | |
| Backtrace |
select * from `establishment_departments` where `establishment_departments`.`establishment_id` = 613325 and `establishment_departments`.`establishment_id` is not null| Bindings | |
| Backtrace |
select * from `establishment_departments` where `establishment_departments`.`establishment_id` = 481676 and `establishment_departments`.`establishment_id` is not null| Bindings | |
| Backtrace |
select * from `establishment_departments` where `establishment_departments`.`establishment_id` = 2875986 and `establishment_departments`.`establishment_id` is not null| Bindings | |
| Backtrace |
select * from `establishment_departments` where `establishment_departments`.`establishment_id` = 544316 and `establishment_departments`.`establishment_id` is not null| Bindings | |
| Backtrace |
select * from `establishment_departments` where `establishment_departments`.`establishment_id` = 565535 and `establishment_departments`.`establishment_id` is not null| Bindings | |
| Backtrace |
select * from `establishment_departments` where `establishment_departments`.`establishment_id` = 572048 and `establishment_departments`.`establishment_id` is not null| Bindings | |
| Backtrace |
select * from `establishment_departments` where `establishment_departments`.`establishment_id` = 522707 and `establishment_departments`.`establishment_id` is not null| Bindings | |
| Backtrace |
select * from `establishment_departments` where `establishment_departments`.`establishment_id` = 362642 and `establishment_departments`.`establishment_id` is not null| Bindings | |
| Backtrace |
select * from `establishment_departments` where `establishment_departments`.`establishment_id` = 513185 and `establishment_departments`.`establishment_id` is not null| Bindings | |
| Backtrace |
select * from `establishment_departments` where `establishment_departments`.`establishment_id` = 567923 and `establishment_departments`.`establishment_id` is not null| Bindings | |
| Backtrace |
select establishments.*, ST_Distance_Sphere(point(establishments.longitude, establishments.latitude), point('4.61130300', '52.26967200')) AS distance from `establishments` where `establishments`.`neighbourhood_id` = 1158819279 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 (5688, 5706, 5743, 5744, 5773, 5778, 5813, 5814, 5823, 5889, 6068, 6081, 6087, 6107, 11509, 49393, 50081, 57349, 69080, 71567, 1111876, 1115508, 1149315, 1170407)| Backtrace |
select * from `regions` where `regions`.`id` = 101803713 and `type` = 'locality' limit 1| Bindings | |
| Backtrace |
200
[]
[]
0 of 0array:16 [▼ "cookie" => array:1 [▶ 0 => "_pk_id.3.58f2=2dbb7cb73916716d.1743907381.; _pk_ses.3.58f2=1; XSRF-TOKEN=eyJpdiI6IlZCL25qbStDUm5XZm1TUCtHbDFWR2c9PSIsInZhbHVlIjoiWVRhRDRWYmwwYXB0L0RTeHRzaXcySmlTd2dZU3hVQm8zUmJ6L3VXL1FrZHhFZEJUOWdsS0wzaGs4SEtoVHg5RVJPamJtVkFxeGRtdndSci9UckxQbmZ6VVFsaWZDdzNORm1odm9ORnpGWGVqaXN3ZWNKbnVYOHovbGpnVlNlVDYiLCJtYWMiOiI0YTNhZjdmZWE1ZGNhMzUwZmM5ZTM3ZTJhM2FiYzc3ZjYyYzM5NGQ5ZGIyNDBiMDhiZmNjZWRjNGE2ZTMyM2IzIiwidGFnIjoiIn0%3D; hours_frontend_session=eyJpdiI6IkdVTm92NjZGUzVzazhVdHVNeWlvbWc9PSIsInZhbHVlIjoiYW1QM3dWRlNVVDlSWEk3dmYwaUZuN29HbFFjOUVnalF2ZlNXM2RvVjBWMmxNc1FmYmczczZtU2gvQVNidkMvRm84NXNKU3J0Q2ZsNHh2WHI5RlJ1cnhQYWtWaGNoL0lkMm5HMVVpRVF5YzFxcTJ1eEhBaWRyc3NPUlZ5bmF0ZkMiLCJtYWMiOiI2MmMxYmUzYzRiODI3NTQwNGUxZWM4MjA2MGViNzE4ODQ5ZDgxN2FmNWMwZjQ3NGIxMThmZTExMzljZDM5NjZiIiwidGFnIjoiIn0%3D ◀_pk_id.3.58f2=2dbb7cb73916716d.1743907381.; _pk_ses.3.58f2=1; XSRF-TOKEN=eyJpdiI6IlZCL25qbStDUm5XZm1TUCtHbDFWR2c9PSIsInZhbHVlIjoiWVRhRDRWYmwwYXB0L0RTeHRzaXcySml ▶" ] "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:4 [▼ "_pk_id_3_58f2" => null "_pk_ses_3_58f2" => null "XSRF-TOKEN" => "A4e7b7YBEwc3ZBG0UXaeNMWR7Ra4wVzIqZAtgTpg" "hours_frontend_session" => "XlXyq91svswZmC4JgZkPFk9ocJHoOhHOUVAfzfrY" ]
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 => "Sun, 06 Apr 2025 02:43:03 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=eyJpdiI6ImtmSHJNNHJSdTFjTGdnOXJyK1NXbEE9PSIsInZhbHVlIjoiNFJQQUJSOEY2a1QrQ0pOQitrd3NEUElrZUY2eFNzL1FXRnBnelJKejAzWHpKNEg4WTBhbEh1SU1MSktYVzA3eWxqd08xdFZOZ1lxN0hNZDJKekRKUWRqY1hHeUlEbW9PazdDdTdMZGM3SURIYWd6Wm0xNzRpWkxYQjFTeUU2M3MiLCJtYWMiOiIyNjhlNDliZTg3ZjExYTgwNDE2YzI3NDlhZjY4YTI5ZGVlNGQ0NjcxNDY4ZThhMTJlOTdiYjZiZDhmZTUyNDQyIiwidGFnIjoiIn0%3D; expires=Sun, 06 Apr 2025 04:43:04 GMT; Max-Age=7200; path=/; secure; samesite=lax ◀XSRF-TOKEN=eyJpdiI6ImtmSHJNNHJSdTFjTGdnOXJyK1NXbEE9PSIsInZhbHVlIjoiNFJQQUJSOEY2a1QrQ0pOQitrd3NEUElrZUY2eFNzL1FXRnBnelJKejAzWHpKNEg4WTBhbEh1SU1MSktYVzA3eWxqd08xd ▶" 1 => "hours_frontend_session=eyJpdiI6Ill0NnhVbG9TMUR6MitzRkduWFd6S1E9PSIsInZhbHVlIjoiNUYxRnZ0TElUZlQ5REYramI4TENIQnZtSlZ6VDVvMTJKNk56Ny9GWE84dWhBL01HT2lKQW03Y3M1eHlTN0lqR0dreENpakQyNGVTYU5iYkIrMzBzTlVBSVl5dVl0d3pTMCtjdEsrRkVxUm1TMDlwUlNtQU4zREFreldCSCs1bWciLCJtYWMiOiIxOTQ5ODE2NTgyYThhMTdlNjBmNzEzZTkwNzJmYTZhNDY2YTE1ZWQ0OGFkOWEzZGI1Y2VmNDdjMjE4MmVjNGEwIiwidGFnIjoiIn0%3D; expires=Sun, 06 Apr 2025 04:43:04 GMT; Max-Age=7200; path=/; httponly; samesite=lax ◀hours_frontend_session=eyJpdiI6Ill0NnhVbG9TMUR6MitzRkduWFd6S1E9PSIsInZhbHVlIjoiNUYxRnZ0TElUZlQ5REYramI4TENIQnZtSlZ6VDVvMTJKNk56Ny9GWE84dWhBL01HT2lKQW03Y3M1eHlTN ▶" ] "Set-Cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6ImtmSHJNNHJSdTFjTGdnOXJyK1NXbEE9PSIsInZhbHVlIjoiNFJQQUJSOEY2a1QrQ0pOQitrd3NEUElrZUY2eFNzL1FXRnBnelJKejAzWHpKNEg4WTBhbEh1SU1MSktYVzA3eWxqd08xdFZOZ1lxN0hNZDJKekRKUWRqY1hHeUlEbW9PazdDdTdMZGM3SURIYWd6Wm0xNzRpWkxYQjFTeUU2M3MiLCJtYWMiOiIyNjhlNDliZTg3ZjExYTgwNDE2YzI3NDlhZjY4YTI5ZGVlNGQ0NjcxNDY4ZThhMTJlOTdiYjZiZDhmZTUyNDQyIiwidGFnIjoiIn0%3D; expires=Sun, 06-Apr-2025 04:43:04 GMT; path=/; secure ◀XSRF-TOKEN=eyJpdiI6ImtmSHJNNHJSdTFjTGdnOXJyK1NXbEE9PSIsInZhbHVlIjoiNFJQQUJSOEY2a1QrQ0pOQitrd3NEUElrZUY2eFNzL1FXRnBnelJKejAzWHpKNEg4WTBhbEh1SU1MSktYVzA3eWxqd08xd ▶" 1 => "hours_frontend_session=eyJpdiI6Ill0NnhVbG9TMUR6MitzRkduWFd6S1E9PSIsInZhbHVlIjoiNUYxRnZ0TElUZlQ5REYramI4TENIQnZtSlZ6VDVvMTJKNk56Ny9GWE84dWhBL01HT2lKQW03Y3M1eHlTN0lqR0dreENpakQyNGVTYU5iYkIrMzBzTlVBSVl5dVl0d3pTMCtjdEsrRkVxUm1TMDlwUlNtQU4zREFreldCSCs1bWciLCJtYWMiOiIxOTQ5ODE2NTgyYThhMTdlNjBmNzEzZTkwNzJmYTZhNDY2YTE1ZWQ0OGFkOWEzZGI1Y2VmNDdjMjE4MmVjNGEwIiwidGFnIjoiIn0%3D; expires=Sun, 06-Apr-2025 04:43:04 GMT; path=/; httponly ◀hours_frontend_session=eyJpdiI6Ill0NnhVbG9TMUR6MitzRkduWFd6S1E9PSIsInZhbHVlIjoiNUYxRnZ0TElUZlQ5REYramI4TENIQnZtSlZ6VDVvMTJKNk56Ny9GWE84dWhBL01HT2lKQW03Y3M1eHlTN ▶" ] ]
0 of 0array:5 [▼ "_token" => "A4e7b7YBEwc3ZBG0UXaeNMWR7Ra4wVzIqZAtgTpg" "parent_page" => "pages.city-neighbourhood" "url" => array:1 [▶ "intended" => "https://alpha.hours.com/Noord-Holland/Nieuw-Vennep/Getsewoud-Zuid" ] "_previous" => array:1 [▶ "url" => "https://alpha.hours.com/Noord-Holland/Nieuw-Vennep/Getsewoud-Zuid" ] "_flash" => array:2 [▶ "old" => [] "new" => [] ] ]