Missing p-85876 in pages/city-neighbourhood
0.1 km
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.1 km
0.1 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 (99.05%) | 810ms |
| 1 x Booting (0.95%) | 7.78ms |
| Backtrace |
select * from `routes` where `route` = 'Noord-Holland/Haarlem/Oude-Amsterdamsebuurt' limit 1| Bindings | |
| Backtrace |
update `routes` set `visit_count` = `visit_count` + 1, `routes`.`updated_at` = '2025-04-06 21:38:08' where `id` = 265073| Bindings | |
| Backtrace |
select * from `establishments` where `slug` = 'Noord-Holland/Haarlem/Oude-Amsterdamsebuurt' and `establishments`.`deleted_at` is null limit 1| Bindings | |
| Backtrace |
select * from `regions` where `slug` = 'Noord-Holland/Haarlem/Oude-Amsterdamsebuurt' limit 1| Bindings | |
| Backtrace |
select * from `reviews` where `reviews`.`reviewable_type` = 'App\\Models\\Region' and `reviews`.`reviewable_id` = 1158819027 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` = 1158819027 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.64717000', '52.37864600')) AS distance from `establishments` where `establishments`.`neighbourhood_id` = 1158819027 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.64717000', '52.37864600')) AS distance from `establishments` where `establishments`.`neighbourhood_id` = 1158819027 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` = 6351 limit 1| Bindings | |
| Backtrace |
select * from `establishment_departments` where `establishment_departments`.`establishment_id` = 585791 and `establishment_departments`.`establishment_id` is not null| Bindings | |
| Backtrace |
select * from `businesses` where `businesses`.`id` = 11776 limit 1| Bindings | |
| Backtrace |
select * from `establishment_departments` where `establishment_departments`.`establishment_id` = 370307 and `establishment_departments`.`establishment_id` is not null| Bindings | |
| Backtrace |
select * from `businesses` where `businesses`.`id` = 10805 limit 1| Bindings | |
| Backtrace |
select * from `establishment_departments` where `establishment_departments`.`establishment_id` = 358493 and `establishment_departments`.`establishment_id` is not null| Bindings | |
| Backtrace |
select * from `businesses` where `businesses`.`id` = 5814 limit 1| Bindings | |
| Backtrace |
select * from `establishment_departments` where `establishment_departments`.`establishment_id` = 2162880 and `establishment_departments`.`establishment_id` is not null| Bindings | |
| Backtrace |
select * from `static_maps` where (`longitude` = '4.64717000' and `latitude` = '52.37864600' and `height` = 1200 and `width` = 1200) limit 1| Bindings | |
| Backtrace |
select * from `regions` where `regions`.`locality_id` = 1158819027 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` = 1158819027 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` = 5814 limit 1| Bindings | |
| Backtrace |
select * from `businesses` where `businesses`.`id` = 6351 limit 1| Bindings | |
| Backtrace |
select * from `businesses` where `businesses`.`id` = 10805 limit 1| Bindings | |
| Backtrace |
select * from `businesses` where `businesses`.`id` = 5739 limit 1| Bindings | |
| Backtrace |
select * from `businesses` where `businesses`.`id` = 36546 limit 1| Bindings | |
| Backtrace |
select * from `businesses` where `businesses`.`id` = 11776 limit 1| Bindings | |
| Backtrace |
select * from `businesses` where `businesses`.`id` = 5814 limit 1| Bindings | |
| Backtrace |
select * from `businesses` where `businesses`.`id` = 58611 limit 1| Bindings | |
| Backtrace |
select * from `businesses` where `businesses`.`id` = 65438 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` = 1158819027 and `establishments`.`neighbourhood_id` is not null and `establishments`.`deleted_at` is null| Bindings | |
| Backtrace |
select * from `businesses` where `id` in (10805, 11776, 36546, 5739, 5814, 58611, 6351, 65438, 1113774, 5814) 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` = 1158819027 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` = 1158819027 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` = 1158819027 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` = 1158819027 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.64717000', '52.37864600')) AS distance from `establishments` where `establishments`.`neighbourhood_id` = 1158819027 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 (5739, 5814, 6351, 10805, 11776, 36546, 58611, 65438, 1113774)| Backtrace |
select * from `establishment_departments` where `establishment_departments`.`establishment_id` = 524345 and `establishment_departments`.`establishment_id` is not null| Bindings | |
| Backtrace |
select * from `establishment_departments` where `establishment_departments`.`establishment_id` = 2119673 and `establishment_departments`.`establishment_id` is not null| Bindings | |
| Backtrace |
select * from `establishment_departments` where `establishment_departments`.`establishment_id` = 498278 and `establishment_departments`.`establishment_id` is not null| Bindings | |
| Backtrace |
select * from `establishment_departments` where `establishment_departments`.`establishment_id` = 588023 and `establishment_departments`.`establishment_id` is not null| Bindings | |
| Backtrace |
select * from `establishment_departments` where `establishment_departments`.`establishment_id` = 538310 and `establishment_departments`.`establishment_id` is not null| Bindings | |
| Backtrace |
select establishments.*, ST_Distance_Sphere(point(establishments.longitude, establishments.latitude), point('4.64717000', '52.37864600')) AS distance from `establishments` where `establishments`.`neighbourhood_id` = 1158819027 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 (5739, 5814, 6351, 10805, 11776, 36546, 58611, 65438, 1113774)| Backtrace |
select * from `regions` where `regions`.`id` = 101751897 and `type` = 'locality' limit 1| Bindings | |
| Backtrace |
200
[]
[]
0 of 0array:16 [▼ "cookie" => array:1 [▶ 0 => "_pk_id.3.58f2=ead522452d6fbc11.1743975487.; _pk_ses.3.58f2=1; XSRF-TOKEN=eyJpdiI6IjYrQmh3UnBNSnBNNlBnYjJUZWkrMUE9PSIsInZhbHVlIjoiSVphdm8wZ09YVzJjN1haWk5xVVdSMWpxQ08xVDBpMG0ya1ZqVXg4RmVGb3NhMDFHUDNEd2lGb1k4dk11R0pjQ1ZQa1dNRHZrVDdRek9LN0wvUktFbXUyZGJzemZDaGtRTHVBTGNkcUMrQmtWdUJpbXRTSHZ2cFkzbVIvcVhMNlgiLCJtYWMiOiI0YTZiMjAwMTA0ZmE4ZGVhZTEzZjA4ZTU4OWI4M2RhZjQxMDgwZjlhMjQxZjMxZjM1OTI2NWQ4ZDY4ZWI3ZGQyIiwidGFnIjoiIn0%3D; hours_frontend_session=eyJpdiI6ImczZVZvTWxLMlg2dW5lbjlhMDRqTXc9PSIsInZhbHVlIjoiNzRBR0ZvTjN4OUNlVk01ZzA3ajRHT3gvc0txaUdTVmFKZ253eVJvRW1PdC9oOFJQTzVsbDlmTUoyS3lIRzNOa1VwcDlhV1EyN3ZpSXZqNzIyTjNMQy9GN0ZTRHAwdmIrdk1vTkw4cjNzWmN2T0pmendXL0M5ZklRUFRPQ3FLcFkiLCJtYWMiOiI3NjdkZGNlNWYwOWRjMGI1OWVkYmIwYTEwNjA2NGNiY2RjNmIwOGJkM2RhZDE0MzYwZjcyZDRmMTFiNGU4OGZlIiwidGFnIjoiIn0%3D ◀_pk_id.3.58f2=ead522452d6fbc11.1743975487.; _pk_ses.3.58f2=1; XSRF-TOKEN=eyJpdiI6IjYrQmh3UnBNSnBNNlBnYjJUZWkrMUE9PSIsInZhbHVlIjoiSVphdm8wZ09YVzJjN1haWk5xVVdSMWp ▶" ] "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" => "nXZge4sg8Gp6aAOUIabOJdI8BYbcRQYcM4Vp21XJ" "hours_frontend_session" => "kzFh0TqnLf0FgTUYF7QbnWbZAVzKKi7XmjaNQ3cO" ]
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 21:38: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=eyJpdiI6ImhkWkorVWM2amFYS25jM3ovU0F6eEE9PSIsInZhbHVlIjoiKzJTZlZPVjVjbEYxU0dNQXJ0a085S2YwSi9zVDVRNjlhclU2ZUxISEZLdnc0ZEEyQk9LbUUyWDRTbU0vek5WVHdMYlEzWjNNQ0xtdnhscHZzcXNKSUdvb1QyalgvcGoxVjl5TElNT3hyalJnQSs0WFR6L0ZaTFI3c1NJbE1najEiLCJtYWMiOiIzNWM1MzNlMjNhY2IyOWIxMjFlOGQ3M2UxMGEwOGI0NDE2ZGRhOTM2YmQ2YTBiYmJhYmY1MGMxNjI2NzYyODQ5IiwidGFnIjoiIn0%3D; expires=Sun, 06 Apr 2025 23:38:09 GMT; Max-Age=7200; path=/; secure; samesite=lax ◀XSRF-TOKEN=eyJpdiI6ImhkWkorVWM2amFYS25jM3ovU0F6eEE9PSIsInZhbHVlIjoiKzJTZlZPVjVjbEYxU0dNQXJ0a085S2YwSi9zVDVRNjlhclU2ZUxISEZLdnc0ZEEyQk9LbUUyWDRTbU0vek5WVHdMYlEzW ▶" 1 => "hours_frontend_session=eyJpdiI6ImdqYmJacGpjbi80YXh1OXRZZms3cEE9PSIsInZhbHVlIjoiMElIbnl6cysyM25Ia2MrbUhvSi96eXdvYzZaM0hSK0twd0R4WHN5cy94TEZUNFZBeHhZZ05CeTdjd05RSWw1d2x3VnhlTWx0UTVtRkc4VVBlMExtQ3hUQlVxQVU1d05hY1FxYlJ6clFSdnhycUJZL0kyc3dXbnhNQlAwWTBxejEiLCJtYWMiOiIwYTY2OGE2YmZkZjkzNDA0MTBkNGEwZjE3NjE4NjFhYTAxNjhlMjZjYzQ5ZDk3NjEyNjM4NDk0YWI1M2JjMGYxIiwidGFnIjoiIn0%3D; expires=Sun, 06 Apr 2025 23:38:09 GMT; Max-Age=7200; path=/; httponly; samesite=lax ◀hours_frontend_session=eyJpdiI6ImdqYmJacGpjbi80YXh1OXRZZms3cEE9PSIsInZhbHVlIjoiMElIbnl6cysyM25Ia2MrbUhvSi96eXdvYzZaM0hSK0twd0R4WHN5cy94TEZUNFZBeHhZZ05CeTdjd05RS ▶" ] "Set-Cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6ImhkWkorVWM2amFYS25jM3ovU0F6eEE9PSIsInZhbHVlIjoiKzJTZlZPVjVjbEYxU0dNQXJ0a085S2YwSi9zVDVRNjlhclU2ZUxISEZLdnc0ZEEyQk9LbUUyWDRTbU0vek5WVHdMYlEzWjNNQ0xtdnhscHZzcXNKSUdvb1QyalgvcGoxVjl5TElNT3hyalJnQSs0WFR6L0ZaTFI3c1NJbE1najEiLCJtYWMiOiIzNWM1MzNlMjNhY2IyOWIxMjFlOGQ3M2UxMGEwOGI0NDE2ZGRhOTM2YmQ2YTBiYmJhYmY1MGMxNjI2NzYyODQ5IiwidGFnIjoiIn0%3D; expires=Sun, 06-Apr-2025 23:38:09 GMT; path=/; secure ◀XSRF-TOKEN=eyJpdiI6ImhkWkorVWM2amFYS25jM3ovU0F6eEE9PSIsInZhbHVlIjoiKzJTZlZPVjVjbEYxU0dNQXJ0a085S2YwSi9zVDVRNjlhclU2ZUxISEZLdnc0ZEEyQk9LbUUyWDRTbU0vek5WVHdMYlEzW ▶" 1 => "hours_frontend_session=eyJpdiI6ImdqYmJacGpjbi80YXh1OXRZZms3cEE9PSIsInZhbHVlIjoiMElIbnl6cysyM25Ia2MrbUhvSi96eXdvYzZaM0hSK0twd0R4WHN5cy94TEZUNFZBeHhZZ05CeTdjd05RSWw1d2x3VnhlTWx0UTVtRkc4VVBlMExtQ3hUQlVxQVU1d05hY1FxYlJ6clFSdnhycUJZL0kyc3dXbnhNQlAwWTBxejEiLCJtYWMiOiIwYTY2OGE2YmZkZjkzNDA0MTBkNGEwZjE3NjE4NjFhYTAxNjhlMjZjYzQ5ZDk3NjEyNjM4NDk0YWI1M2JjMGYxIiwidGFnIjoiIn0%3D; expires=Sun, 06-Apr-2025 23:38:09 GMT; path=/; httponly ◀hours_frontend_session=eyJpdiI6ImdqYmJacGpjbi80YXh1OXRZZms3cEE9PSIsInZhbHVlIjoiMElIbnl6cysyM25Ia2MrbUhvSi96eXdvYzZaM0hSK0twd0R4WHN5cy94TEZUNFZBeHhZZ05CeTdjd05RS ▶" ] ]
0 of 0array:5 [▼ "_token" => "nXZge4sg8Gp6aAOUIabOJdI8BYbcRQYcM4Vp21XJ" "parent_page" => "pages.city-neighbourhood" "url" => array:1 [▶ "intended" => "https://alpha.hours.com/Noord-Holland/Haarlem/Oude-Amsterdamsebuurt" ] "_previous" => array:1 [▶ "url" => "https://alpha.hours.com/Noord-Holland/Haarlem/Oude-Amsterdamsebuurt" ] "_flash" => array:2 [▶ "old" => [] "new" => [] ] ]