Haarlem
Discover Haarlem
Inloggen
Missing 93115 in components/partials/hero-v2/text
0 Missing 93641 in components/partials/hero-v2/text
Stuijvesantplein 9 2023KT, Haarlem
Gesloten Missing from-87324 in components/partials/location/open-closed
Delen
Opslaan
Missing Telefoonnummer in pages/location 0235253375
Missing Buurt in pages/location Schoterveenpolder
Bewerking voorstellen Dit bedrijf beheren

Ben je eigenaar van dit bedrijf?

Hoe wil je de aanpassingen doorgeven?

Stap 1/2
Plak hieronder het adres van de webpagina waarop de actuele gegevens van dit bedrijf staan.

Geef de pagina door waar bijvoorkeur zowel het actuele adres en de actuele openingstijden staan, of in elk geval de gegevens die u wilt bewerken

Stap 1/2
Plak hieronder het adres van de webpagina waarop de actuele gegevens van dit bedrijf staan.

Geef de pagina door waar bijvoorkeur zowel het actuele adres en de actuele openingstijden staan, of in elk geval de gegevens die u wilt bewerken

TEST to next screen
Nog max. 17 seconden
Stap 2/2
We hebben de nieuwe gegevens kunnen ophalen.

Contactgegevens

Grote Marktstraat 55 A
Missing 85197 in components/modal/modal-report-location
Missing 85137 in components/modal/modal-report-location

Openingstijden

Maandag: 0800/2200
Dinsdag: 0800/2200
Woensdag: 0800/2200
Donderdag: 0800/2200
Vrijdag: 0800/2200
Zaterdag: 0800/2200
Zonddag: 0800/2200

Bron

https://www.ah.nl/winkel/albert-heijn/s-gravenhage/grote-marktstraat/1473

Jouw gegevens

Gegevens Versturen

Onze redactie controleerd handmatig de gegevens van de opgegeven webpagina
Stap 2/2

Contactgegevens

Openingstijden

Maandag
Dinsdag
Woensdag
Donderdag
Vrijdag
Zaterdag
Zondag

Je e-mailadres

Bedankt voor je melding

We zullen de nieuwe gegevens zo snel mogenlijk online beijwerken.
Je kunt dit venster nusluiten.

Bedankt voor je melding

Een van onze specilisten zal deze melding zo snel mogelijk beoordelen. Je kunt dit venster nusluiten.

Missing Openingstijden in pages/location

Missing p-91863 in pages/location

Tijdelijk gesloten
Deze week(31 Mar - 6 Apr)
Volgende week(7 Apr - 13 Apr)
Monday
Missing Gesloten in components/partials/location/openinghours
Tuesday
09:30 - 18:00
Wednesday
09:30 - 17:30
Thursday
09:30 - 17:30
Friday
09:30 - 18:00
Saturday
08:30 - 16:00
Sunday
Missing Gesloten in components/partials/location/openinghours

Beoordelingen

Form grass their, fruit sixth have without herb above fowl set which without, meat. Bearing place image seas likeness one. Land. Deep together midst was female lights. Dry open said.

0.00
0   Missing 56443 in components/common/ratings
Missing No reviews in components/common/ratings
Missing 18970 in pages/location

Populaire tijden

Missing p-19480 in pages/location

Tuesday9:00quite busy
Tuesday10:00quite busy
Tuesday11:00quite busy
Tuesday12:00quite busy
Tuesday13:00quite busy
Tuesday14:00quite busy
Tuesday15:00quite busy
Tuesday16:00quite busy
Tuesday17:00quite busy
Tuesday18:00quite busy
9 12 15 18
Wednesday9:00quite busy
Wednesday10:00quite busy
Wednesday11:00quite busy
Wednesday12:00quite busy
Wednesday13:00quite busy
Wednesday14:00quite busy
Wednesday15:00quite busy
Wednesday16:00quite busy
Wednesday17:00quite busy
9 12 15
Thursday9:00quite busy
Thursday10:00quite busy
Thursday11:00quite busy
Thursday12:00quite busy
Thursday13:00quite busy
Thursday14:00quite busy
Thursday15:00quite busy
Thursday16:00quite busy
Thursday17:00quite busy
9 12 15
Friday9:00quite busy
Friday10:00quite busy
Friday11:00quite busy
Friday12:00quite busy
Friday13:00quite busy
Friday14:00quite busy
Friday15:00quite busy
Friday16:00quite busy
Friday17:00quite busy
Friday18:00quite busy
9 12 15 18
Saturday8:00quite busy
Saturday9:00quite busy
Saturday10:00quite busy
Saturday11:00quite busy
Saturday12:00quite busy
Saturday13:00quite busy
Saturday14:00quite busy
Saturday15:00quite busy
Saturday16:00quite busy
9 12 15

Handig in de buurt

Het leukste en beste van amsterdam geselecteerd door lokale experts in combinatie met onze ratings! Ondenk Amsterdam zoals je niet eerder deed, wij weten precies waar je moet zijn.

Vraag en Antwoord
Vraag en antwoord overZen for Hair Stuijvesantplein

Missing h2-85308 in livewire/partials/question/questions

Het leukste en beste van Amsterdam geselecteerd door lokale experts in combinatie met onze ratings! Ontdek Amsterdam zoals je niet eerder deed, wij weten precies waar je moet zijn.

Route plannen

Het leukste en beste van Amsterdam geselecteerd door lokale experts in combinatie met onze ratings! Ontdek Amsterdam zoals je niet eerder deed, wij weten precies waar je moet zijn.

Home Haarlem Kappers Zen for Hair Stuijvesantplein
Map
in de buurt van:
DHL ServicePunt DHL ServicePunt Albert Heijn Albert Heijn PostNL PostNL
Missing div-50914 in livewire/search/search-results
Amsterdam
Oudezijde
Missing div-35697 in livewire/search/search-results
Shopping
Restaurants & Food
Nightlife
Sport & Recreation
Beauty, Spas & Wellness
Automotive & Transport
Home & Garden
Pet Care & Pets
Professional Services
Health & Medical
Beoordelingen
Beoordelingen van   Stuijvesantplein 9
0.00
0   Missing 81850 in components/popover/review/view
Missing No reviews in components/common/ratings
1   Missing 82934 in components/common/reviews/bars
0
2   Missing 82934 in components/common/reviews/bars
0
3   Missing 82934 in components/common/reviews/bars
0
4   Missing 82934 in components/common/reviews/bars
0
5   Missing 82934 in components/common/reviews/bars
0

Wat is jouw ervaring?

0   Missing 63955 in components/popover/review/view

Beoordeling schrijven
Terug naar Beoordelingen
Missing 12975 in components/popover/review/write   Stuijvesantplein 9

Wat vind je van:

Missing strong-82343 in components/popover/review/write
Bewerking opslaan Bewerking niet opslaan
Beoordeling schrijven
Missing 87130 in components/popover/review/confirm   Stuijvesantplein 9
Beoordeling geplaatst

Bedankt voor je beoordeling. Na controle wordt deze zo snel mogelijk gepubliceerd.

Venster sluiten
Schoterveenpolder
Menu
Business Owners
Mijn locatie

Meld je aan voor Openingstijden.nl en geniet van alle voordelen

Als je verdergaat, ga je akkoord met onzeGebruiksvoorwaardenen bevestig je dat je onzePrivacy- en cookieverklaringhebt gelezen.

Om het meeste uit je account te halen willen we graag meer over je weten:

Aan de hand van je locatie tonen we informatie bij jou in de buurt

Wachtwoord vergeten

Terug

Ben je je wachtwoord vergeten? Vul hieronder je e-mailadres in. Je ontvangt dan een link om een nieuw wachtwoord in te stellen.

Delete account

Do you really want to delete your account?

All your data will be deleted. You will not be able to undo this action.

MessagesTimelineExceptionsViews79RouteQueries47Models24Livewire41MailsGateSessionRequest
Request history8.2.28PHP Version299msRequest Duration4MBMemory UsageGET {route}Route
    • Booting (8.68ms)time
    • Application (290ms)time
    • 1 x Application (97.09%)
      290ms
      1 x Booting (2.91%)
      8.68ms
      79 templates were rendered
      • 1x pages.locationlocation.blade.php#?blade
      • 1x livewire.topbartopbar.blade.php#?blade
      • 1x components.login-buttonlogin-button.blade.php#?blade
      • 1x components.partials.hero-v2.texttext.blade.php#?blade
      • 3x components.common.reviews.starsstars.blade.php#?blade
      • 1x components.partials.location.open-closedopen-closed.blade.php#?blade
      • 1x livewire.common.share-buttonshare-button.blade.php#?blade
      • 1x livewire.common.save-to-listsave-to-list.blade.php#?blade
      • 1x components.modal.modal-report-locationmodal-report-location.blade.php#?blade
      • 1x components.partials.location.openinghoursopeninghours.blade.php#?blade
      • 1x components.common.ratingsratings.blade.php#?blade
      • 1x components.common.review-panelreview-panel.blade.php#?blade
      • 1x components.partials.location.popular-hourspopular-hours.blade.php#?blade
      • 7x components.partials.location.popular-hours-daypopular-hours-day.blade.php#?blade
      • 1x livewire.location.handy-nearbyhandy-nearby.blade.php#?blade
      • 1x livewire.partials.question.questionsquestions.blade.php#?blade
      • 1x livewire.partials.question.qaqa.blade.php#?blade
      • 5x livewire.location.location-autocompletelocation-autocomplete.blade.php#?blade
      • 1x livewire.breadcrumbsbreadcrumbs.blade.php#?blade
      • 1x components.partials.footerfooter.blade.php#?blade
      • 1x components.maps.mapsmaps.blade.php#?blade
      • 1x components.maps.staticstatic.blade.php#?blade
      • 1x livewire.search.search-resultssearch-results.blade.php#?blade
      • 1x livewire.search.search-aroundsearch-around.blade.php#?blade
      • 3x components.img-responsiveimg-responsive.blade.php#?blade
      • 2x livewire.sidebar.cards.areaarea.blade.php#?blade
      • 10x livewire.sidebar.cards.categorycategory.blade.php#?blade
      • 1x components.popover.review.viewview.blade.php#?blade
      • 1x components.common.reviews.barsbars.blade.php#?blade
      • 1x components.popover.review.writewrite.blade.php#?blade
      • 1x components.popover.review.confirmconfirm.blade.php#?blade
      • 2x __components::1104a916f0c55dd05f91d3db3e3f592b1104a916f0c55dd05f91d3db3e3f592b.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
      • 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
      46 statements were executed (15 duplicates)Show only duplicates67.56ms
      • Connection Establishedhours_frontendDynamicRouteControllerDispatcher.php#39
        Backtrace
        • select * from `routes` where `route` = 'Zen-for-Hair/Haarlem/Stuijvesantplein-9' limit 1
          2.66mshours_frontendDynamicRouteControllerDispatcher.php#39
          Bindings
            Backtrace
            • update `routes` set `visit_count` = `visit_count` + 1, `routes`.`updated_at` = '2025-04-06 18:19:13' where `id` = 59638
              540μshours_frontendDynamicRouteControllerDispatcher.php#43
              Bindings
                Backtrace
                • select * from `establishments` where `slug` = 'Zen-for-Hair/Haarlem/Stuijvesantplein-9' and `establishments`.`deleted_at` is null limit 1
                  1.14mshours_frontendBuildsGroupLimitQueries.php#38
                  Bindings
                    Backtrace
                    • select * from `regions` where `regions`.`id` = 101751897 limit 1
                      540μshours_frontendDynamicRouteControllerDispatcher.php#310
                      Bindings
                        Backtrace
                        • select * from `businesses` where `businesses`.`id` = 31040 limit 1
                          390μshours_frontendBuildsGroupLimitQueries.php#38
                          Bindings
                            Backtrace
                            • select `categories`.*, `businesses`.`id` as `laravel_through_key` from `categories` inner join `businesses` on `businesses`.`category_id` = `categories`.`id` where `businesses`.`id` = 31040 limit 1
                              420μshours_frontendBuildsGroupLimitQueries.php#38
                              Bindings
                                Backtrace
                                • select `attributes`.*, `attribute_establishment`.`establishment_hash` as `pivot_establishment_hash`, `attribute_establishment`.`attribute_id` as `pivot_attribute_id` from `attributes` inner join `attribute_establishment` on `attributes`.`id` = `attribute_establishment`.`attribute_id` where `attribute_establishment`.`establishment_hash` = 'd9378b79-6da9-457c-bd1d-3531873d4ea1' and `subtype` in ('shopping area', 'shopping center/mall', 'living mall', 'shopping street', 'uk shopping street', 'uk shopping area', 'uk retail park', 'uk shopping park', 'uk shopping centre', 'uk leisure park', '0') order by `connected_locations` desc limit 1
                                  1.04mshours_frontendEstablishment.php#281
                                  Bindings
                                    Backtrace
                                    • select * from `regions` where `regions`.`id` = 1158819077 limit 1
                                      460μshours_frontendDynamicRouteControllerDispatcher.php#314
                                      Bindings
                                        Backtrace
                                        • select * from `links` where `links`.`business_id` in (31040)
                                          400μshours_frontendBusinessController.php#81
                                          Backtrace
                                          • select `id`, (select count(*) from `links` where `businesses`.`id` = `links`.`business_id`) as `links_count` from `businesses` where `businesses`.`id` in (31040)
                                            390μshours_frontendBuildsGroupLimitQueries.php#38
                                            Backtrace
                                            • select `reviews`.*, (select count(*) from `ratings` where `reviews`.`id` = `ratings`.`review_id`) as `ratings_count`, (select avg(`ratings`.`rating`) from `ratings` where `reviews`.`id` = `ratings`.`review_id`) as `ratings_avg_rating` from `reviews` where `reviews`.`reviewable_id` in ('d9378b79-6da9-457c-bd1d-3531873d4ea1') and `reviews`.`reviewable_type` = 'App\\Models\\Establishment' and `reviews`.`deleted_at` is null
                                              560μshours_frontendBusinessController.php#87
                                              Bindings
                                                Backtrace
                                                • select * from `questions` where `questions`.`questionable_id` in ('d9378b79-6da9-457c-bd1d-3531873d4ea1') and `questions`.`questionable_type` = 'App\\Models\\Establishment' and `questions`.`deleted_at` is null
                                                  440μshours_frontendBusinessController.php#98
                                                  Bindings
                                                    Backtrace
                                                    • select `attributes`.*, `attribute_establishment`.`establishment_hash` as `pivot_establishment_hash`, `attribute_establishment`.`attribute_id` as `pivot_attribute_id` from `attributes` inner join `attribute_establishment` on `attributes`.`id` = `attribute_establishment`.`attribute_id` where `attribute_establishment`.`establishment_hash` in ('d9378b79-6da9-457c-bd1d-3531873d4ea1')
                                                      480μshours_frontendBusinessController.php#106
                                                      Bindings
                                                        Backtrace
                                                        • select * from `businesses` where `businesses`.`id` in (31040)
                                                          400μshours_frontendBuildsGroupLimitQueries.php#38
                                                          Backtrace
                                                          • select `id`, (select count(*) from `attributes` inner join `attribute_establishment` on `attributes`.`id` = `attribute_establishment`.`attribute_id` where `establishments`.`hash` = `attribute_establishment`.`establishment_hash`) as `attributes_count` from `establishments` where `establishments`.`id` in (382613)
                                                            450μshours_frontendBuildsGroupLimitQueries.php#38
                                                            Backtrace
                                                            • select * from `establishment_departments` where `establishment_departments`.`establishment_id` = 382613 and `establishment_departments`.`establishment_id` is not null
                                                              800μshours_frontendBusinessController.php#110
                                                              Bindings
                                                                Backtrace
                                                                • select * from `categories` where `categories`.`id` = 100246 limit 1
                                                                  430μshours_frontendBuildsGroupLimitQueries.php#38
                                                                  Bindings
                                                                    Backtrace
                                                                    • select * from `regions` where `regions`.`id` = 101751897 limit 1
                                                                      380μshours_frontendBusinessController.php#117
                                                                      Bindings
                                                                        Backtrace
                                                                        • select * from `regions` where `type` = 'locality' and `regions`.`id` in (101751897)
                                                                          390μshours_frontend356fe112bc062b18148dd6583d961031.php#9
                                                                          Bindings
                                                                            Backtrace
                                                                            • select count(*) as aggregate from `regions` where `regions`.`locality_id` = 101751897 and `regions`.`locality_id` is not null and `type` = 'neighbourhood'
                                                                              2.1mshours_frontendTopbar.php#78
                                                                              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'
                                                                                  740μshours_frontendTopbar.php#84
                                                                                  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'
                                                                                      1.2mshours_frontendTopbar.php#90
                                                                                      Bindings
                                                                                        Backtrace
                                                                                        • select * from `regions` where `regions`.`id` = 1158819077 and `type` = 'neighbourhood' limit 1
                                                                                          480μshours_frontendRegion.php#50
                                                                                          Bindings
                                                                                            Backtrace
                                                                                            • select * from `regions` where `regions`.`id` = 85687053 and `type` = 'region' limit 1
                                                                                              390μshours_frontendRegion.php#51
                                                                                              Bindings
                                                                                                Backtrace
                                                                                                • select * from `regions` where `regions`.`id` = 101751897 and `type` = 'locality' limit 1
                                                                                                  370μ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
                                                                                                      20.9mshours_frontendTranslations.php#17
                                                                                                      Backtrace
                                                                                                      • select * from `regions` where `regions`.`id` = 1158819077 limit 1
                                                                                                        3.97mshours_frontend356fe112bc062b18148dd6583d961031.php#222
                                                                                                        Bindings
                                                                                                          Backtrace
                                                                                                          • select * from `regions` where `regions`.`id` = 1158819077 limit 1
                                                                                                            1.91mshours_frontend356fe112bc062b18148dd6583d961031.php#234
                                                                                                            Bindings
                                                                                                              Backtrace
                                                                                                              • select * from `establishment_departments` where `establishment_departments`.`establishment_id` = 382613 and `establishment_departments`.`establishment_id` is not null limit 1
                                                                                                                3.28mshours_frontenddd14a96e88664e934f656ffe283e69df.php#22
                                                                                                                Bindings
                                                                                                                  Backtrace
                                                                                                                  • select * from `reviews` where `reviews`.`reviewable_type` = 'App\\Models\\Establishment' and `reviews`.`reviewable_id` = 'd9378b79-6da9-457c-bd1d-3531873d4ea1' 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
                                                                                                                    790μshours_frontend17277c34235421d97751feb36413b757.php#24
                                                                                                                    Bindings
                                                                                                                      Backtrace
                                                                                                                      • select * from `reviews` where `reviews`.`reviewable_type` = 'App\\Models\\Establishment' and `reviews`.`reviewable_id` = 'd9378b79-6da9-457c-bd1d-3531873d4ea1' and `reviews`.`reviewable_id` is not null and `reviews`.`deleted_at` is null
                                                                                                                        520μshours_frontend17277c34235421d97751feb36413b757.php#28
                                                                                                                        Bindings
                                                                                                                          Backtrace
                                                                                                                          • select `attributes`.*, `attribute_establishment`.`establishment_hash` as `pivot_establishment_hash`, `attribute_establishment`.`attribute_id` as `pivot_attribute_id` from `attributes` inner join `attribute_establishment` on `attributes`.`id` = `attribute_establishment`.`attribute_id` where `attribute_establishment`.`establishment_hash` = 'd9378b79-6da9-457c-bd1d-3531873d4ea1' and `subtype` in ('shopping area', 'shopping center/mall', 'living mall', 'shopping street', 'uk shopping street', 'uk shopping area', 'uk retail park', 'uk shopping park', 'uk shopping centre', 'uk leisure park', '0') order by `connected_locations` desc limit 1
                                                                                                                            1.31mshours_frontendEstablishment.php#281
                                                                                                                            Bindings
                                                                                                                              Backtrace
                                                                                                                              • select * from `categories` where `handy_nearby` = 1
                                                                                                                                710μshours_frontendBuildsGroupLimitQueries.php#38
                                                                                                                                Bindings
                                                                                                                                  Backtrace
                                                                                                                                  • select * from `questions` where `questions`.`questionable_type` = 'App\\Models\\Establishment' and `questions`.`questionable_id` = 'd9378b79-6da9-457c-bd1d-3531873d4ea1' and `questions`.`questionable_id` is not null and `questions`.`deleted_at` is null order by `created_at` desc
                                                                                                                                    650μshours_frontendQa.php#25
                                                                                                                                    Bindings
                                                                                                                                      Backtrace
                                                                                                                                      • select * from `questions` where `questions`.`questionable_type` = 'App\\Models\\Establishment' and `questions`.`questionable_id` = 'd9378b79-6da9-457c-bd1d-3531873d4ea1' and `questions`.`questionable_id` is not null and `questions`.`deleted_at` is null order by `created_at` desc limit 3
                                                                                                                                        540μshours_frontend4ab8d689553e1b9274c635a1c5492a5b.php#40
                                                                                                                                        Bindings
                                                                                                                                          Backtrace
                                                                                                                                          • select * from `texts` where `texts`.`textable_type` = 'App\\Models\\Establishment' and `texts`.`textable_id` = 382613 and `texts`.`textable_id` is not null and `slug` = 'business-about' limit 1
                                                                                                                                            620μshours_frontendEstablishment.php#292
                                                                                                                                            Bindings
                                                                                                                                              Backtrace
                                                                                                                                              • select * from `regions` where `regions`.`id` in (101751897)
                                                                                                                                                450μshours_frontend356fe112bc062b18148dd6583d961031.php#772
                                                                                                                                                Backtrace
                                                                                                                                                • select `categories`.*, `businesses`.`id` as `laravel_through_key` from `categories` inner join `businesses` on `businesses`.`category_id` = `categories`.`id` where `businesses`.`id` = 31040 limit 1
                                                                                                                                                  630μshours_frontendBuildsGroupLimitQueries.php#38
                                                                                                                                                  Bindings
                                                                                                                                                    Backtrace
                                                                                                                                                    • select * from `static_maps` where (`longitude` = '4.6318377' and `latitude` = '52.400367' and `height` = 1200 and `width` = 1200) limit 1
                                                                                                                                                      560μshours_frontendStaticMap.php#28
                                                                                                                                                      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.66mshours_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.69mshours_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
                                                                                                                                                                  800μshours_frontendUserLocation.php#78
                                                                                                                                                                  Bindings
                                                                                                                                                                    Backtrace
                                                                                                                                                                    • select * from `reviews` where `reviews`.`reviewable_type` = 'App\\Models\\Establishment' and `reviews`.`reviewable_id` = 'd9378b79-6da9-457c-bd1d-3531873d4ea1' 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
                                                                                                                                                                      670μshours_frontendbd02aa5f958fbb0dbcd1683300f93f26.php#31
                                                                                                                                                                      Bindings
                                                                                                                                                                        Backtrace
                                                                                                                                                                        • select * from `reviews` where `reviews`.`reviewable_type` = 'App\\Models\\Establishment' and `reviews`.`reviewable_id` = 'd9378b79-6da9-457c-bd1d-3531873d4ea1' and `reviews`.`reviewable_id` is not null and `reviews`.`deleted_at` is null
                                                                                                                                                                          440μshours_frontendbd02aa5f958fbb0dbcd1683300f93f26.php#32
                                                                                                                                                                          Bindings
                                                                                                                                                                            Backtrace
                                                                                                                                                                            • select * from `reviews` where `reviews`.`reviewable_type` = 'App\\Models\\Establishment' and `reviews`.`reviewable_id` = 'd9378b79-6da9-457c-bd1d-3531873d4ea1' and `reviews`.`reviewable_id` is not null and `reviews`.`deleted_at` is null
                                                                                                                                                                              440μshours_frontendbd02aa5f958fbb0dbcd1683300f93f26.php#94
                                                                                                                                                                              Bindings
                                                                                                                                                                                Backtrace
                                                                                                                                                                                • select * from `reviews` where `reviews`.`reviewable_type` = 'App\\Models\\Establishment' and `reviews`.`reviewable_id` = 'd9378b79-6da9-457c-bd1d-3531873d4ea1' and `reviews`.`reviewable_id` is not null and `reviews`.`deleted_at` is null
                                                                                                                                                                                  430μshours_frontendbd02aa5f958fbb0dbcd1683300f93f26.php#105
                                                                                                                                                                                  Bindings
                                                                                                                                                                                    Backtrace
                                                                                                                                                                                    App\Models\Region
                                                                                                                                                                                    12Region.php#?
                                                                                                                                                                                    App\Models\Business
                                                                                                                                                                                    3Business.php#?
                                                                                                                                                                                    App\Models\Category
                                                                                                                                                                                    3Category.php#?
                                                                                                                                                                                    App\Models\Establishment
                                                                                                                                                                                    2Establishment.php#?
                                                                                                                                                                                    App\Models\EstablishmentDepartment
                                                                                                                                                                                    2EstablishmentDepartment.php#?
                                                                                                                                                                                    App\Models\Route
                                                                                                                                                                                    1Route.php#?
                                                                                                                                                                                    App\Models\StaticMap
                                                                                                                                                                                    1StaticMap.php#?
                                                                                                                                                                                    topbar #bcE5r57DSu9FStCQWhaH
                                                                                                                                                                                    array:4 [ "data" => array:4 [ "user" => null "parent" => App\Models\Region {#2123 #c...
                                                                                                                                                                                    common.share-button #CGlNXRfZieCRi5ClrdK1
                                                                                                                                                                                    array:4 [ "data" => array:3 [ "currentUrl" => "https://alpha.hours.com/Zen-for-Hair/Haarlem/St...
                                                                                                                                                                                    common.save-to-list #IWfY7dm7oRqVarQqVTge
                                                                                                                                                                                    array:4 [ "data" => array:3 [ "establishment" => App\Models\Establishment {#1908 #connec...
                                                                                                                                                                                    location.handy-nearby #ka5Huj9oqcehP0q8c3c3
                                                                                                                                                                                    array:4 [ "data" => array:2 [ "coordinates" => App\Support\Coordinates {#2126 +longitude...
                                                                                                                                                                                    partials.question.questions #6q1ca548scSQjFoOHeZT
                                                                                                                                                                                    array:4 [ "data" => array:2 [ "entity" => App\Models\Establishment {#1908 #connection: "...
                                                                                                                                                                                    partials.question.qa #gwwb5BWQpLw389qC20Dg
                                                                                                                                                                                    array:4 [ "data" => array:4 [ "entity" => "establishment" "object" => App\Models\Establish...
                                                                                                                                                                                    location.location-autocomplete #P9P0pNJyGaZSplfvyskc
                                                                                                                                                                                    array:4 [ "data" => array:5 [ "initialLocation" => "Amsterdam, 1012 JS" "location" => "Ams...
                                                                                                                                                                                    breadcrumbs #SRE6xizRntP79Oh4o8wi
                                                                                                                                                                                    array:4 [ "data" => array:3 [ "parent" => App\Models\Establishment {#1908 #connection: "...
                                                                                                                                                                                    search-results #NGW3tftrbmwcmCI1rgmD
                                                                                                                                                                                    array:4 [ "data" => array:6 [ "search" => "" "results" => [] "searchOverlayActive" => ...
                                                                                                                                                                                    partials.search-around #e4oSdClSrMilUFtZaKc9
                                                                                                                                                                                    array:4 [ "data" => array:1 [ "userLocation" => array:4 [ "longitude" => 4.895168 ...
                                                                                                                                                                                    sidebar.cards.area #08YTMeRP3vuGKbbrbVIU
                                                                                                                                                                                    array:4 [ "data" => array:1 [ "area" => App\Models\Region {#4269 #connection: "mysql" ...
                                                                                                                                                                                    sidebar.cards.area #KI1CL4Hsw4GdgZ52PaqI
                                                                                                                                                                                    array:4 [ "data" => array:1 [ "area" => App\Models\Region {#4273 #connection: "mysql" ...
                                                                                                                                                                                    sidebar.cards.category #PNhrqnjCQwziIqaSC6lj
                                                                                                                                                                                    array:4 [ "data" => array:2 [ "category" => App\Models\Category {#4245 #connection: "mys...
                                                                                                                                                                                    sidebar.cards.category #LiStQk1KPrAZN4aK3fXt
                                                                                                                                                                                    array:4 [ "data" => array:2 [ "category" => App\Models\Category {#4185 #connection: "mys...
                                                                                                                                                                                    sidebar.cards.category #KsEH42IDojiXFmpmddr5
                                                                                                                                                                                    array:4 [ "data" => array:2 [ "category" => App\Models\Category {#4746 #connection: "mys...
                                                                                                                                                                                    sidebar.cards.category #qYLNlXAyOpTkFxbibDnM
                                                                                                                                                                                    array:4 [ "data" => array:2 [ "category" => App\Models\Category {#4258 #connection: "mys...
                                                                                                                                                                                    sidebar.cards.category #m9NhZqmrUS5OlSH3R2IH
                                                                                                                                                                                    array:4 [ "data" => array:2 [ "category" => App\Models\Category {#4128 #connection: "mys...
                                                                                                                                                                                    sidebar.cards.category #ePeUkj7zux8MUJXlp2XP
                                                                                                                                                                                    array:4 [ "data" => array:2 [ "category" => App\Models\Category {#4127 #connection: "mys...
                                                                                                                                                                                    sidebar.cards.category #qvhasn2Zu1Djg0Yr4f8X
                                                                                                                                                                                    array:4 [ "data" => array:2 [ "category" => App\Models\Category {#4126 #connection: "mys...
                                                                                                                                                                                    sidebar.cards.category #Vea6EM4qMn1eEXQQhkJv
                                                                                                                                                                                    array:4 [ "data" => array:2 [ "category" => App\Models\Category {#4125 #connection: "mys...
                                                                                                                                                                                    sidebar.cards.category #UKzq1eE3uxfvMSdOh40p
                                                                                                                                                                                    array:4 [ "data" => array:2 [ "category" => App\Models\Category {#4124 #connection: "mys...
                                                                                                                                                                                    sidebar.cards.category #E5MiVb2lPPEGuVhzywAp
                                                                                                                                                                                    array:4 [ "data" => array:2 [ "category" => App\Models\Category {#4123 #connection: "mys...
                                                                                                                                                                                    search #uhiMtXaIigrpkbGSlGuw
                                                                                                                                                                                    array:4 [ "data" => array:1 [ "search" => "" ] "name" => "search" "component" => "App\Li...
                                                                                                                                                                                    search #Mdg6A5ddQKGXngLN4h7O
                                                                                                                                                                                    array:4 [ "data" => array:1 [ "search" => "" ] "name" => "search" "component" => "App\Li...
                                                                                                                                                                                    filter.filter #ekVeyJbADn8ifTdjn2wB
                                                                                                                                                                                    array:4 [ "data" => array:5 [ "hours" => 0 "filtersAreNotEmpty" => false "showFilter" ...
                                                                                                                                                                                    filter.slide-in #rnsZ580h2byIk5owAlrQ
                                                                                                                                                                                    array:4 [ "data" => array:8 [ "openFrom" => "" "openTo" => "" "dayRange" => "today" ...
                                                                                                                                                                                    location.location-autocomplete #viF9jzv16uN52VJHhinC
                                                                                                                                                                                    array:4 [ "data" => array:5 [ "initialLocation" => "Amsterdam, 1012 JS" "location" => "Ams...
                                                                                                                                                                                    sidebar.navigation #vlw2QIRjm4bD6Dt4fTX3
                                                                                                                                                                                    array:4 [ "data" => [] "name" => "sidebar.navigation" "component" => "App\Livewire\Sidebar\Nav...
                                                                                                                                                                                    modal.location #oGSwaHPPex5bT2L2dYVT
                                                                                                                                                                                    array:4 [ "data" => array:2 [ "classes" => [] "showModal" => false ] "name" => "modal....
                                                                                                                                                                                    location.location-autocomplete #XhS0eFvNyjPfWr6ZmUBf
                                                                                                                                                                                    array:4 [ "data" => array:5 [ "initialLocation" => "Amsterdam, 1012 JS" "location" => "Ams...
                                                                                                                                                                                    filter.filter #yEfFtW6rXrItGhdSRtRN
                                                                                                                                                                                    array:4 [ "data" => array:5 [ "hours" => 0 "filtersAreNotEmpty" => false "showFilter" ...
                                                                                                                                                                                    filter.slide-in #qJvthcsgKUL6ayeOcn90
                                                                                                                                                                                    array:4 [ "data" => array:8 [ "openFrom" => "" "openTo" => "" "dayRange" => "today" ...
                                                                                                                                                                                    location.location-autocomplete #5beDd1oROGGhDsd79HGi
                                                                                                                                                                                    array:4 [ "data" => array:5 [ "initialLocation" => "Amsterdam, 1012 JS" "location" => "Ams...
                                                                                                                                                                                    common.local-bar #YQPwWUi1QLmYKF5SbfJI
                                                                                                                                                                                    array:4 [ "data" => [] "name" => "common.local-bar" "component" => "App\Livewire\Common\LocalB...
                                                                                                                                                                                    auth.signup #YIntQyVcwDFtwM3jpCFC
                                                                                                                                                                                    array:4 [ "data" => [] "name" => "auth.signup" "component" => "App\Livewire\Auth\Signup" "id...
                                                                                                                                                                                    auth.login #r17rCXPiNkovDnMuxxqO
                                                                                                                                                                                    array:4 [ "data" => array:3 [ "email" => null "password" => null "class" => "" ] "...
                                                                                                                                                                                    auth.onboarding #DpGtTZ7sRHwUQGIC5zVg
                                                                                                                                                                                    array:4 [ "data" => array:6 [ "name" => null "classes" => [] "localities" => null ...
                                                                                                                                                                                    location.location-autocomplete #mASgAiKFY3mFWeqwmxCK
                                                                                                                                                                                    array:4 [ "data" => array:5 [ "initialLocation" => "Amsterdam, 1012 JS" "location" => "Ams...
                                                                                                                                                                                    auth.register #45ZSKxdohNMbL6VCjP8b
                                                                                                                                                                                    array:4 [ "data" => array:3 [ "email" => null "password" => null "class" => "" ] "...
                                                                                                                                                                                    auth.forgot-password #saFZTEmunh5aVHVvG2Ad
                                                                                                                                                                                    array:4 [ "data" => array:3 [ "email" => "" "class" => "" "successMessage" => null ]...
                                                                                                                                                                                    auth.delete-account #EPV71cfPuJPpUFW4LZl0
                                                                                                                                                                                    array:4 [ "data" => [] "name" => "auth.delete-account" "component" => "App\Livewire\Auth\Delet...
                                                                                                                                                                                        _token
                                                                                                                                                                                        tNIZrZVum9pVjysm3CrEl8oBKDKQA0A22wMKrXqT
                                                                                                                                                                                        parent_page
                                                                                                                                                                                        pages.location
                                                                                                                                                                                        url
                                                                                                                                                                                        array:1 [ "intended" => "https://alpha.hours.com/Zen-for-Hair/Haarlem/Stuijvesantplein-9" ]
                                                                                                                                                                                        _previous
                                                                                                                                                                                        array:1 [ "url" => "https://alpha.hours.com/Zen-for-Hair/Haarlem/Stuijvesantplein-9" ]
                                                                                                                                                                                        _flash
                                                                                                                                                                                        array:2 [ "old" => [] "new" => [] ]
                                                                                                                                                                                        path_info
                                                                                                                                                                                        /Zen-for-Hair/Haarlem/Stuijvesantplein-9
                                                                                                                                                                                        status_code
                                                                                                                                                                                        200
                                                                                                                                                                                        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 => "Sun, 06 Apr 2025 18:19:13 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=eyJpdiI6ImVXMThlcDludmE4aU4weWNzaFJBdnc9PSIsInZhbHVlIjoiVGhmMzd2UXZZQUlzdk1CNS9OeWI2bTJuVVk3SU5HYXZvTkJBTE8vVDhKellyVGFJZlBkbUZlTHlNOGdIT1pEYU8xbkpEU3hnaGJmVnRwZkFKbHNwVU5jSUdjNTJLTTJ4enByYUdyeGRxM0xoRUhkR3hsSjFQdjNHaVlGa05wYlgiLCJtYWMiOiJmODYxYzg2NDJmNjAxMjk2YThhMjMwN2U3ZDJjNGIzYzExYWY0ZGZkMjMyODY1NDM3ZTZiMjQ3OWZkYmE5NTQwIiwidGFnIjoiIn0%3D; expires=Sun, 06 Apr 2025 20:19:13 GMT; Max-Age=7200; path=/; secure; samesite=lax ◀XSRF-TOKEN=eyJpdiI6ImVXMThlcDludmE4aU4weWNzaFJBdnc9PSIsInZhbHVlIjoiVGhmMzd2UXZZQUlzdk1CNS9OeWI2bTJuVVk3SU5HYXZvTkJBTE8vVDhKellyVGFJZlBkbUZlTHlNOGdIT1pEYU8xbkpEU ▶"
    1 => "hours_frontend_session=eyJpdiI6Ii9DVlRCeGlrd0U3a01EK1VGYTFGcXc9PSIsInZhbHVlIjoiM0MwdTJMeE4ySmxBQzJaTVRqWkhzazNNc1c4cjN2VjgyN3R1Mmt1b0l3S3hRb1lXQjNpVXY5eW9JWHYxNExWNExLWW4zNjdzc1VxZ3ZXKy81Smd1Mk1aVUNGcEoxemdTcXFmRmFLa2JWN3NEeU0zcWhtc1dZZE00Z3FtSVVmaFgiLCJtYWMiOiI0MDIxYTRkY2NmMzA2OTkyMzRjYzFhOGQzMWQ5ZTc2MGEwZWUxM2Y1ZTFhNTNiMjFlMGYxY2JlYjA1YzJmOTlmIiwidGFnIjoiIn0%3D; expires=Sun, 06 Apr 2025 20:19:13 GMT; Max-Age=7200; path=/; httponly; samesite=lax ◀hours_frontend_session=eyJpdiI6Ii9DVlRCeGlrd0U3a01EK1VGYTFGcXc9PSIsInZhbHVlIjoiM0MwdTJMeE4ySmxBQzJaTVRqWkhzazNNc1c4cjN2VjgyN3R1Mmt1b0l3S3hRb1lXQjNpVXY5eW9JWHYxN ▶"
  ]
  "Set-Cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6ImVXMThlcDludmE4aU4weWNzaFJBdnc9PSIsInZhbHVlIjoiVGhmMzd2UXZZQUlzdk1CNS9OeWI2bTJuVVk3SU5HYXZvTkJBTE8vVDhKellyVGFJZlBkbUZlTHlNOGdIT1pEYU8xbkpEU3hnaGJmVnRwZkFKbHNwVU5jSUdjNTJLTTJ4enByYUdyeGRxM0xoRUhkR3hsSjFQdjNHaVlGa05wYlgiLCJtYWMiOiJmODYxYzg2NDJmNjAxMjk2YThhMjMwN2U3ZDJjNGIzYzExYWY0ZGZkMjMyODY1NDM3ZTZiMjQ3OWZkYmE5NTQwIiwidGFnIjoiIn0%3D; expires=Sun, 06-Apr-2025 20:19:13 GMT; path=/; secure ◀XSRF-TOKEN=eyJpdiI6ImVXMThlcDludmE4aU4weWNzaFJBdnc9PSIsInZhbHVlIjoiVGhmMzd2UXZZQUlzdk1CNS9OeWI2bTJuVVk3SU5HYXZvTkJBTE8vVDhKellyVGFJZlBkbUZlTHlNOGdIT1pEYU8xbkpEU ▶"
    1 => "hours_frontend_session=eyJpdiI6Ii9DVlRCeGlrd0U3a01EK1VGYTFGcXc9PSIsInZhbHVlIjoiM0MwdTJMeE4ySmxBQzJaTVRqWkhzazNNc1c4cjN2VjgyN3R1Mmt1b0l3S3hRb1lXQjNpVXY5eW9JWHYxNExWNExLWW4zNjdzc1VxZ3ZXKy81Smd1Mk1aVUNGcEoxemdTcXFmRmFLa2JWN3NEeU0zcWhtc1dZZE00Z3FtSVVmaFgiLCJtYWMiOiI0MDIxYTRkY2NmMzA2OTkyMzRjYzFhOGQzMWQ5ZTc2MGEwZWUxM2Y1ZTFhNTNiMjFlMGYxY2JlYjA1YzJmOTlmIiwidGFnIjoiIn0%3D; expires=Sun, 06-Apr-2025 20:19:13 GMT; path=/; httponly ◀hours_frontend_session=eyJpdiI6Ii9DVlRCeGlrd0U3a01EK1VGYTFGcXc9PSIsInZhbHVlIjoiM0MwdTJMeE4ySmxBQzJaTVRqWkhzazNNc1c4cjN2VjgyN3R1Mmt1b0l3S3hRb1lXQjNpVXY5eW9JWHYxN ▶"
  ]
]
                                                                                                                                                                                        session_attributes
                                                                                                                                                                                          0 of 0   
                                                                                                                                                                                        array:5 [▼
  "_token" => "tNIZrZVum9pVjysm3CrEl8oBKDKQA0A22wMKrXqT"
  "parent_page" => "pages.location"
  "url" => array:1 [▶
    "intended" => "https://alpha.hours.com/Zen-for-Hair/Haarlem/Stuijvesantplein-9"
  ]
  "_previous" => array:1 [▶
    "url" => "https://alpha.hours.com/Zen-for-Hair/Haarlem/Stuijvesantplein-9"
  ]
  "_flash" => array:2 [▶
    "old" => []
    "new" => []
  ]
]
                                                                                                                                                                                        ClearShow all
                                                                                                                                                                                        Date ↕MethodURLData
                                                                                                                                                                                        #12025-04-06 18:19:13GET/Zen-for-Hair/Haarlem/Stuijvesantplein-979472441