Ureterp

Missing h1-71267 in pages/city-category

Missing p-71267 in pages/city-category

Missing h2-83945 in pages/city-category

Missing p-83945 in pages/city-category

Missing 69245 in livewire/partials/join-us

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

Map
Request history8.2.28PHP Version4.27sRequest Duration8MBMemory UsageGET {route}Route
    • Booting (9.34ms)time
    • Application (4.26s)time
    • 1 x Application (99.78%)
      4.26s
      1 x Booting (0.22%)
      9.34ms
      199 templates were rendered
      • 1x pages.city-categorycity-category.blade.php#?blade
      • 1x livewire.topbartopbar.blade.php#?blade
      • 1x components.login-buttonlogin-button.blade.php#?blade
      • 1x components.partials.hero-v2.defaultdefault.blade.php#?blade
      • 1x livewire.partials.top-ratedtop-rated.blade.php#?blade
      • 2x livewire.partials.cards.card-chainratingcard-chainrating.blade.php#?blade
      • 6x livewire.partials.cards.card-chainrating-blockcard-chainrating-block.blade.php#?blade
      • 6x components.common.reviews.starsstars.blade.php#?blade
      • 1x livewire.partials.join-usjoin-us.blade.php#?blade
      • 1x livewire.partials.city-guidescity-guides.blade.php#?blade
      • 1x livewire.breadcrumbsbreadcrumbs.blade.php#?blade
      • 1x components.partials.footerfooter.blade.php#?blade
      • 1x livewire.search.search-resultssearch-results.blade.php#?blade
      • 1x livewire.search.search-aroundsearch-around.blade.php#?blade
      • 11x components.img-responsiveimg-responsive.blade.php#?blade
      • 2x livewire.sidebar.cards.areaarea.blade.php#?blade
      • 10x livewire.sidebar.cards.categorycategory.blade.php#?blade
      • 1x static.template-parts.modal.modal-locationmodal-location.blade.php#?blade
      • 1x components.maps.mapsmaps.blade.php#?blade
      • 1x components.maps.staticstatic.blade.php#?blade
      • 2x livewire.sidebar.blocks.locationslocations.blade.php#?blade
      • 60x components.sidebar.cards.storestore.blade.php#?blade
      • 60x components.partials.location.open-closedopen-closed.blade.php#?blade
      • 1x layouts.mainmain.blade.php#?blade
      • 1x meta.google-analyticsgoogle-analytics.blade.php#?blade
      • 1x components.sidebar.headerheader.blade.php#?blade
      • 2x livewire.search.searchsearch.blade.php#?blade
      • 1x components.sidebar.sidebarsidebar.blade.php#?blade
      • 2x livewire.filter.filterfilter.blade.php#?blade
      • 2x livewire.filter.slide-inslide-in.blade.php#?blade
      • 4x livewire.location.location-autocompletelocation-autocomplete.blade.php#?blade
      • 1x livewire.sidebar.navigationnavigation.blade.php#?blade
      • 1x livewire.modal.locationlocation.blade.php#?blade
      • 1x components.sidebar.locationlocation.blade.php#?blade
      • 1x livewire.common.local-barlocal-bar.blade.php#?blade
      • 1x components.modal.loginlogin.blade.php#?blade
      • 1x livewire.auth.signupsignup.blade.php#?blade
      • 1x livewire.auth.loginlogin.blade.php#?blade
      • 1x livewire.auth.onboardingonboarding.blade.php#?blade
      • 1x livewire.auth.registerregister.blade.php#?blade
      • 1x livewire.auth.forgot-passwordforgot-password.blade.php#?blade
      • 1x livewire.auth.delete-accountdelete-account.blade.php#?blade
      • 1x meta.yext-scriptyext-script.blade.php#?blade
      uri
      GET {route}
      middleware
      web
      uses
      App\Http\Controllers\DynamicRouteControllerDispatcher@__invoke
      controller
      App\Http\Controllers\DynamicRouteControllerDispatcher
      namespace
      prefix
      where
      47 statements were executed (6 duplicates)Show only duplicates4.01s
      • Connection Establishedhours_frontendDynamicRouteControllerDispatcher.php#39
        Backtrace
        • select * from `routes` where `route` = 'Friesland/Ureterp/Sport-Recreation' limit 1
          3.31mshours_frontendDynamicRouteControllerDispatcher.php#39
          Bindings
            Backtrace
            • update `routes` set `visit_count` = `visit_count` + 1, `routes`.`updated_at` = '2025-04-08 08:54:24' where `id` = 290087
              610μshours_frontendDynamicRouteControllerDispatcher.php#43
              Bindings
                Backtrace
                • select * from `establishments` where `slug` = 'Friesland/Ureterp/Sport-Recreation' and `establishments`.`deleted_at` is null limit 1
                  980μshours_frontendBuildsGroupLimitQueries.php#38
                  Bindings
                    Backtrace
                    • select * from `regions` where `slug` = 'Friesland/Ureterp/Sport-Recreation' limit 1
                      520μshours_frontendDynamicRouteControllerDispatcher.php#111
                      Bindings
                        Backtrace
                        • select * from `categories` where `slug` = 'Friesland/Ureterp/Sport-Recreation' limit 1
                          390μshours_frontendBuildsGroupLimitQueries.php#38
                          Bindings
                            Backtrace
                            • select * from `businesses` where `slug` = 'Friesland/Ureterp/Sport-Recreation' limit 1
                              450μshours_frontendBuildsGroupLimitQueries.php#38
                              Bindings
                                Backtrace
                                • select * from `attributes` where `slug` = 'Friesland/Ureterp/Sport-Recreation' limit 1
                                  770μshours_frontendDynamicRouteControllerDispatcher.php#111
                                  Bindings
                                    Backtrace
                                    • select * from `categories` where `slug` = 'Sport-Recreation' limit 1
                                      500μshours_frontendBuildsGroupLimitQueries.php#38
                                      Bindings
                                        Backtrace
                                        • select * from `regions` where `slug` = 'Friesland/Ureterp' and `type` = 'locality' limit 1
                                          450μshours_frontendDynamicRouteControllerDispatcher.php#195
                                          Bindings
                                            Backtrace
                                            • select * from `regions` where `regions`.`id` = 101807437 and `type` = 'locality' limit 1
                                              540μshours_frontendTopbar.php#66
                                              Bindings
                                                Backtrace
                                                • select count(*) as aggregate from `regions` where `regions`.`locality_id` = 101807437 and `regions`.`locality_id` is not null and `type` = 'neighbourhood'
                                                  2.36mshours_frontendTopbar.php#78
                                                  Bindings
                                                    Backtrace
                                                    • select count(*) as aggregate from `attributes` where `attributes`.`locality_id` = 101807437 and `attributes`.`locality_id` is not null and `subtype` = 'uk shopping area'
                                                      680μshours_frontendTopbar.php#84
                                                      Bindings
                                                        Backtrace
                                                        • select count(*) as aggregate from `attributes` where `attributes`.`locality_id` = 101807437 and `attributes`.`locality_id` is not null and `subtype` = 'uk shopping street'
                                                          510μshours_frontendTopbar.php#90
                                                          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
                                                              19.54mshours_frontendTranslations.php#17
                                                              Backtrace
                                                              • select `establishments`.*, (select count(*) from `reviews` where `establishments`.`hash` = `reviews`.`reviewable_id` and `reviews`.`reviewable_type` = 'App\\Models\\Establishment' and `reviews`.`deleted_at` is null) as `reviews_count` from `establishments` where `establishments`.`locality_id` = 101807437 and `establishments`.`locality_id` is not null and exists (select * from `businesses` where `establishments`.`business_id` = `businesses`.`id` and exists (select * from `categories` where `businesses`.`category_id` = `categories`.`id` and `name` = 'Sport & Recreation')) and `establishments`.`deleted_at` is null limit 3
                                                                172mshours_frontendBuildsGroupLimitQueries.php#38
                                                                Bindings
                                                                  Backtrace
                                                                  • select `establishments`.*, (select count(*) from `reviews` where `establishments`.`hash` = `reviews`.`reviewable_id` and `reviews`.`reviewable_type` = 'App\\Models\\Establishment' and `reviews`.`deleted_at` is null) as `reviews_count`, establishments.*, ST_Distance_Sphere(point(establishments.longitude, establishments.latitude), point('6.16066800', '53.09196600')) AS distance from `establishments` where exists (select * from `businesses` where `establishments`.`business_id` = `businesses`.`id` and exists (select * from `categories` where `businesses`.`category_id` = `categories`.`id` and `name` = 'Sport & Recreation')) and 1 = 1 and `establishments`.`deleted_at` is null order by `distance` asc limit 3
                                                                    693mshours_frontendBuildsGroupLimitQueries.php#38
                                                                    Bindings
                                                                      Backtrace
                                                                      • select `establishments`.*, (select count(*) from `reviews` where `establishments`.`hash` = `reviews`.`reviewable_id` and `reviews`.`reviewable_type` = 'App\\Models\\Establishment' and `reviews`.`deleted_at` is null) as `reviews_count` from `establishments` where `establishments`.`locality_id` = 101807437 and `establishments`.`locality_id` is not null and exists (select * from `businesses` where `establishments`.`business_id` = `businesses`.`id` and exists (select * from `categories` where `businesses`.`category_id` = `categories`.`id` and `name` = 'Clothing')) and `establishments`.`deleted_at` is null limit 3
                                                                        152mshours_frontendBuildsGroupLimitQueries.php#38
                                                                        Bindings
                                                                          Backtrace
                                                                          • select `establishments`.*, (select count(*) from `reviews` where `establishments`.`hash` = `reviews`.`reviewable_id` and `reviews`.`reviewable_type` = 'App\\Models\\Establishment' and `reviews`.`deleted_at` is null) as `reviews_count`, establishments.*, ST_Distance_Sphere(point(establishments.longitude, establishments.latitude), point('6.16066800', '53.09196600')) AS distance from `establishments` where exists (select * from `businesses` where `establishments`.`business_id` = `businesses`.`id` and exists (select * from `categories` where `businesses`.`category_id` = `categories`.`id` and `name` = 'Clothing')) and 1 = 1 and `establishments`.`deleted_at` is null order by `distance` asc limit 3
                                                                            703mshours_frontendBuildsGroupLimitQueries.php#38
                                                                            Bindings
                                                                              Backtrace
                                                                              • select `establishments`.*, (select count(*) from `reviews` where `establishments`.`hash` = `reviews`.`reviewable_id` and `reviews`.`reviewable_type` = 'App\\Models\\Establishment' and `reviews`.`deleted_at` is null) as `reviews_count` from `establishments` where `establishments`.`locality_id` = 101807437 and `establishments`.`locality_id` is not null and exists (select * from `businesses` where `establishments`.`business_id` = `businesses`.`id` and exists (select * from `categories` where `businesses`.`category_id` = `categories`.`id` and `name` = 'Supermarkets')) and `establishments`.`deleted_at` is null limit 3
                                                                                154mshours_frontendBuildsGroupLimitQueries.php#38
                                                                                Bindings
                                                                                  Backtrace
                                                                                  • select `establishments`.*, (select count(*) from `reviews` where `establishments`.`hash` = `reviews`.`reviewable_id` and `reviews`.`reviewable_type` = 'App\\Models\\Establishment' and `reviews`.`deleted_at` is null) as `reviews_count`, establishments.*, ST_Distance_Sphere(point(establishments.longitude, establishments.latitude), point('6.16066800', '53.09196600')) AS distance from `establishments` where exists (select * from `businesses` where `establishments`.`business_id` = `businesses`.`id` and exists (select * from `categories` where `businesses`.`category_id` = `categories`.`id` and `name` = 'Supermarkets')) and 1 = 1 and `establishments`.`deleted_at` is null order by `distance` asc limit 3
                                                                                    664mshours_frontendBuildsGroupLimitQueries.php#38
                                                                                    Bindings
                                                                                      Backtrace
                                                                                      • select `establishments`.*, (select count(*) from `reviews` where `establishments`.`hash` = `reviews`.`reviewable_id` and `reviews`.`reviewable_type` = 'App\\Models\\Establishment' and `reviews`.`deleted_at` is null) as `reviews_count` from `establishments` where `establishments`.`locality_id` = 101807437 and `establishments`.`locality_id` is not null and exists (select * from `businesses` where `establishments`.`business_id` = `businesses`.`id` and exists (select * from `categories` where `businesses`.`category_id` = `categories`.`id` and `name` = 'Restaurants')) and `establishments`.`deleted_at` is null limit 3
                                                                                        148mshours_frontendBuildsGroupLimitQueries.php#38
                                                                                        Bindings
                                                                                          Backtrace
                                                                                          • select `establishments`.*, (select count(*) from `reviews` where `establishments`.`hash` = `reviews`.`reviewable_id` and `reviews`.`reviewable_type` = 'App\\Models\\Establishment' and `reviews`.`deleted_at` is null) as `reviews_count`, establishments.*, ST_Distance_Sphere(point(establishments.longitude, establishments.latitude), point('6.16066800', '53.09196600')) AS distance from `establishments` where exists (select * from `businesses` where `establishments`.`business_id` = `businesses`.`id` and exists (select * from `categories` where `businesses`.`category_id` = `categories`.`id` and `name` = 'Restaurants')) and 1 = 1 and `establishments`.`deleted_at` is null order by `distance` asc limit 3
                                                                                            101mshours_frontendBuildsGroupLimitQueries.php#38
                                                                                            Bindings
                                                                                              Backtrace
                                                                                              • select * from `businesses` where `businesses`.`id` in (31944, 39797, 55371)
                                                                                                660μshours_frontendBuildsGroupLimitQueries.php#38
                                                                                                Backtrace
                                                                                                • select * from `categories` where `categories`.`id` in (100394)
                                                                                                  500μshours_frontendBuildsGroupLimitQueries.php#38
                                                                                                  Backtrace
                                                                                                  • select `establishments`.*, (select count(*) from `reviews` where `establishments`.`hash` = `reviews`.`reviewable_id` and `reviews`.`reviewable_type` = 'App\\Models\\Establishment' and `reviews`.`deleted_at` is null) as `reviews_count` from `establishments` where `establishments`.`locality_id` = 101807437 and `establishments`.`locality_id` is not null and exists (select * from `businesses` where `establishments`.`business_id` = `businesses`.`id` and exists (select * from `categories` where `businesses`.`category_id` = `categories`.`id` and `name` = 'Hotels')) and `establishments`.`deleted_at` is null limit 3
                                                                                                    148mshours_frontendBuildsGroupLimitQueries.php#38
                                                                                                    Bindings
                                                                                                      Backtrace
                                                                                                      • select `establishments`.*, (select count(*) from `reviews` where `establishments`.`hash` = `reviews`.`reviewable_id` and `reviews`.`reviewable_type` = 'App\\Models\\Establishment' and `reviews`.`deleted_at` is null) as `reviews_count`, establishments.*, ST_Distance_Sphere(point(establishments.longitude, establishments.latitude), point('6.16066800', '53.09196600')) AS distance from `establishments` where exists (select * from `businesses` where `establishments`.`business_id` = `businesses`.`id` and exists (select * from `categories` where `businesses`.`category_id` = `categories`.`id` and `name` = 'Hotels')) and 1 = 1 and `establishments`.`deleted_at` is null order by `distance` asc limit 3
                                                                                                        106mshours_frontendBuildsGroupLimitQueries.php#38
                                                                                                        Bindings
                                                                                                          Backtrace
                                                                                                          • select * from `businesses` where `businesses`.`id` in (32551, 56147, 81493)
                                                                                                            590μshours_frontendBuildsGroupLimitQueries.php#38
                                                                                                            Backtrace
                                                                                                            • select * from `categories` where `categories`.`id` in (100209)
                                                                                                              480μshours_frontendBuildsGroupLimitQueries.php#38
                                                                                                              Backtrace
                                                                                                              • select `establishments`.*, (select count(*) from `reviews` where `establishments`.`hash` = `reviews`.`reviewable_id` and `reviews`.`reviewable_type` = 'App\\Models\\Establishment' and `reviews`.`deleted_at` is null) as `reviews_count` from `establishments` where `establishments`.`locality_id` = 101807437 and `establishments`.`locality_id` is not null and exists (select * from `businesses` where `establishments`.`business_id` = `businesses`.`id` and exists (select * from `categories` where `businesses`.`category_id` = `categories`.`id` and `name` = 'DIY Stores')) and `establishments`.`deleted_at` is null limit 3
                                                                                                                146mshours_frontendBuildsGroupLimitQueries.php#38
                                                                                                                Bindings
                                                                                                                  Backtrace
                                                                                                                  • select `establishments`.*, (select count(*) from `reviews` where `establishments`.`hash` = `reviews`.`reviewable_id` and `reviews`.`reviewable_type` = 'App\\Models\\Establishment' and `reviews`.`deleted_at` is null) as `reviews_count`, establishments.*, ST_Distance_Sphere(point(establishments.longitude, establishments.latitude), point('6.16066800', '53.09196600')) AS distance from `establishments` where exists (select * from `businesses` where `establishments`.`business_id` = `businesses`.`id` and exists (select * from `categories` where `businesses`.`category_id` = `categories`.`id` and `name` = 'DIY Stores')) and 1 = 1 and `establishments`.`deleted_at` is null order by `distance` asc limit 3
                                                                                                                    629mshours_frontendBuildsGroupLimitQueries.php#38
                                                                                                                    Bindings
                                                                                                                      Backtrace
                                                                                                                      • select establishments.*, ST_Distance_Sphere(point(establishments.longitude, establishments.latitude), point(4.895168, 52.370216)) AS distance, `businesses`.`category_id` as `laravel_through_key` from `establishments` inner join `businesses` on `businesses`.`id` = `establishments`.`business_id` where `businesses`.`category_id` = 1000005 and `establishments`.`deleted_at` is null order by `distance` asc limit 6
                                                                                                                        1.47mshours_frontendBuildsGroupLimitQueries.php#38
                                                                                                                        Bindings
                                                                                                                          Backtrace
                                                                                                                          • select *, ST_Distance_Sphere(point(longitude, latitude), point(4.895168, 52.370216)) AS distance from `regions` where `type` = 'locality' order by `distance` asc limit 1
                                                                                                                            3.58mshours_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.52mshours_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
                                                                                                                                    750μshours_frontendUserLocation.php#78
                                                                                                                                    Bindings
                                                                                                                                      Backtrace
                                                                                                                                      • select `id` from `categories` where `categories`.`parent_id` = 1000005 and `categories`.`parent_id` is not null
                                                                                                                                        650μshours_frontendCategory.php#74
                                                                                                                                        Bindings
                                                                                                                                          Backtrace
                                                                                                                                          • select establishments.*, ST_Distance_Sphere(point(establishments.longitude, establishments.latitude), point('6.16066800', '53.09196600')) AS distance from `establishments` where exists (select * from `businesses` where `establishments`.`business_id` = `businesses`.`id` and `category_id` in (100120, 100162, 100185, 100215, 100235, 100248, 100267, 100314, 100325, 100435, 100436, 100437, 100439, 100440, 100441, 100443, 100494, 100505, 100522, 100551)) and `establishments`.`deleted_at` is null order by `distance` asc limit 90
                                                                                                                                            59.54mshours_frontendBuildsGroupLimitQueries.php#38
                                                                                                                                            Bindings
                                                                                                                                              Backtrace
                                                                                                                                              • select * from `businesses` where `businesses`.`id` in (5662, 5692, 5742, 5760, 8484, 9867, 10801, 11718, 11719, 11720, 11740, 11748, 11936, 19569, 20053, 31166, 32995, 33854, 34105, 34180, 34537, 35244, 36867, 37387, 37495, 39064, 39362, 42345, 42414, 43293, 43848, 46660, 51805, 52174, 52481, 55112, 55227, 55368, 55380, 55442, 56011, 56358, 56648, 56649, 57031, 57058, 58357, 61759, 70401, 70538, 70545, 71741, 71812, 71930, 75449, 75553, 78217, 80627, 83502, 1097239, 1105686, 1105742, 1107508, 1115330, 1170967, 1171297, 1171565, 1608458)
                                                                                                                                                1.82mshours_frontendBuildsGroupLimitQueries.php#38
                                                                                                                                                Backtrace
                                                                                                                                                • select * from `establishment_departments` where `establishment_departments`.`establishment_id` = 463280 and `establishment_departments`.`establishment_id` is not null
                                                                                                                                                  610μshours_frontendHasHours.php#36
                                                                                                                                                  Bindings
                                                                                                                                                    Backtrace
                                                                                                                                                    • select * from `establishment_departments` where `establishment_departments`.`establishment_id` = 463511 and `establishment_departments`.`establishment_id` is not null
                                                                                                                                                      690μshours_frontendHasHours.php#36
                                                                                                                                                      Bindings
                                                                                                                                                        Backtrace
                                                                                                                                                        • select * from `establishment_departments` where `establishment_departments`.`establishment_id` = 462890 and `establishment_departments`.`establishment_id` is not null
                                                                                                                                                          570μshours_frontendHasHours.php#36
                                                                                                                                                          Bindings
                                                                                                                                                            Backtrace
                                                                                                                                                            • select * from `establishment_departments` where `establishment_departments`.`establishment_id` = 466232 and `establishment_departments`.`establishment_id` is not null
                                                                                                                                                              680μshours_frontendHasHours.php#36
                                                                                                                                                              Bindings
                                                                                                                                                                Backtrace
                                                                                                                                                                • select * from `establishment_departments` where `establishment_departments`.`establishment_id` = 2862535 and `establishment_departments`.`establishment_id` is not null
                                                                                                                                                                  660μshours_frontendHasHours.php#36
                                                                                                                                                                  Bindings
                                                                                                                                                                    Backtrace
                                                                                                                                                                    • select * from `establishment_departments` where `establishment_departments`.`establishment_id` = 2110678 and `establishment_departments`.`establishment_id` is not null
                                                                                                                                                                      620μshours_frontendHasHours.php#36
                                                                                                                                                                      Bindings
                                                                                                                                                                        Backtrace
                                                                                                                                                                        • select * from `establishment_departments` where `establishment_departments`.`establishment_id` = 400745 and `establishment_departments`.`establishment_id` is not null
                                                                                                                                                                          620μshours_frontendHasHours.php#36
                                                                                                                                                                          Bindings
                                                                                                                                                                            Backtrace
                                                                                                                                                                            • select `id` from `categories` where `categories`.`parent_id` = 1000005 and `categories`.`parent_id` is not null
                                                                                                                                                                              520μshours_frontendCategory.php#74
                                                                                                                                                                              Bindings
                                                                                                                                                                                Backtrace
                                                                                                                                                                                • select establishments.*, ST_Distance_Sphere(point(establishments.longitude, establishments.latitude), point('6.16066800', '53.09196600')) AS distance from `establishments` where exists (select * from `businesses` where `establishments`.`business_id` = `businesses`.`id` and `category_id` in (100120, 100162, 100185, 100215, 100235, 100248, 100267, 100314, 100325, 100435, 100436, 100437, 100439, 100440, 100441, 100443, 100494, 100505, 100522, 100551)) and `establishments`.`deleted_at` is null order by `distance` asc limit 90
                                                                                                                                                                                  84.64mshours_frontendBuildsGroupLimitQueries.php#38
                                                                                                                                                                                  Bindings
                                                                                                                                                                                    Backtrace
                                                                                                                                                                                    • select * from `businesses` where `businesses`.`id` in (5662, 5692, 5742, 5760, 8484, 9867, 10801, 11718, 11719, 11720, 11740, 11748, 11936, 19569, 20053, 31166, 32995, 33854, 34105, 34180, 34537, 35244, 36867, 37387, 37495, 39064, 39362, 42345, 42414, 43293, 43848, 46660, 51805, 52174, 52481, 55112, 55227, 55368, 55380, 55442, 56011, 56358, 56648, 56649, 57031, 57058, 58357, 61759, 70401, 70538, 70545, 71741, 71812, 71930, 75449, 75553, 78217, 80627, 83502, 1097239, 1105686, 1105742, 1107508, 1115330, 1170967, 1171297, 1171565, 1608458)
                                                                                                                                                                                      1.01mshours_frontendBuildsGroupLimitQueries.php#38
                                                                                                                                                                                      Backtrace
                                                                                                                                                                                      App\Models\Establishment
                                                                                                                                                                                      186Establishment.php#?
                                                                                                                                                                                      App\Models\Business
                                                                                                                                                                                      142Business.php#?
                                                                                                                                                                                      App\Models\Category
                                                                                                                                                                                      43Category.php#?
                                                                                                                                                                                      App\Models\EstablishmentDepartment
                                                                                                                                                                                      7EstablishmentDepartment.php#?
                                                                                                                                                                                      App\Models\Region
                                                                                                                                                                                      4Region.php#?
                                                                                                                                                                                      App\Models\Route
                                                                                                                                                                                      1Route.php#?
                                                                                                                                                                                      topbar #L4lt6Kh4JDGpIbOI8gy6
                                                                                                                                                                                      array:4 [ "data" => array:4 [ "user" => null "parent" => App\Models\Region {#1879 #c...
                                                                                                                                                                                      partials.top-rated #Lq4FnKntG04bntIMcRep
                                                                                                                                                                                      array:4 [ "data" => array:5 [ "title" => "Missing h2-83945 in pages/city-category" "descri...
                                                                                                                                                                                      partials.cards.card-chainrating #3g8St6ggqWq6RcfKqkHz
                                                                                                                                                                                      array:4 [ "data" => array:3 [ "headingText" => "Missing Beste in in livewire/partials/top-rate...
                                                                                                                                                                                      partials.cards.card-chainrating-block #fj7BLoJfmn4VXypsHdmB
                                                                                                                                                                                      array:4 [ "data" => array:4 [ "establishment" => App\Models\Establishment {#4501 #connec...
                                                                                                                                                                                      partials.cards.card-chainrating-block #b54Ss5bThSS3qBfnWRdc
                                                                                                                                                                                      array:4 [ "data" => array:4 [ "establishment" => App\Models\Establishment {#4504 #connec...
                                                                                                                                                                                      partials.cards.card-chainrating-block #hziLYrlWa7b1znoq3ccU
                                                                                                                                                                                      array:4 [ "data" => array:4 [ "establishment" => App\Models\Establishment {#4505 #connec...
                                                                                                                                                                                      partials.cards.card-chainrating #JAxnd3FFqXLxDrrFsiwT
                                                                                                                                                                                      array:4 [ "data" => array:3 [ "headingText" => "Missing Beste in in livewire/partials/top-rate...
                                                                                                                                                                                      partials.cards.card-chainrating-block #w34FwA48PqYpRDViMOsD
                                                                                                                                                                                      array:4 [ "data" => array:4 [ "establishment" => App\Models\Establishment {#4408 #connec...
                                                                                                                                                                                      partials.cards.card-chainrating-block #WDH3nOognzmEprzCNGqu
                                                                                                                                                                                      array:4 [ "data" => array:4 [ "establishment" => App\Models\Establishment {#4409 #connec...
                                                                                                                                                                                      partials.cards.card-chainrating-block #Il4nYZsmpQW24KCD10Ng
                                                                                                                                                                                      array:4 [ "data" => array:4 [ "establishment" => App\Models\Establishment {#4410 #connec...
                                                                                                                                                                                      partials.join-us #HXav6ibXk6SofdoMj4IA
                                                                                                                                                                                      array:4 [ "data" => array:1 [ "cityName" => "Ureterp" ] "name" => "partials.join-us" "co...
                                                                                                                                                                                      partials.city-guides #WuBIxjQhdNu713tphiwq
                                                                                                                                                                                      array:4 [ "data" => array:2 [ "scrollable" => null "locations" => Illuminate\Database\Eloq...
                                                                                                                                                                                      breadcrumbs #QYe3bzy9S6iXzas7wjjD
                                                                                                                                                                                      array:4 [ "data" => array:3 [ "parent" => App\Models\Region {#1879 #connection: "mysql" ...
                                                                                                                                                                                      search-results #zWjq0xVYUIMDnXgYaJa2
                                                                                                                                                                                      array:4 [ "data" => array:6 [ "search" => "" "results" => [] "searchOverlayActive" => ...
                                                                                                                                                                                      partials.search-around #71sqnDhy0MayTFPrcVqq
                                                                                                                                                                                      array:4 [ "data" => array:1 [ "userLocation" => array:4 [ "longitude" => 4.895168 ...
                                                                                                                                                                                      sidebar.cards.area #a1cZ025CZmO4xe6hOgEp
                                                                                                                                                                                      array:4 [ "data" => array:1 [ "area" => App\Models\Region {#3460 #connection: "mysql" ...
                                                                                                                                                                                      sidebar.cards.area #sXMIaDgOZVOSzSSOqa5D
                                                                                                                                                                                      array:4 [ "data" => array:1 [ "area" => App\Models\Region {#3464 #connection: "mysql" ...
                                                                                                                                                                                      sidebar.cards.category #syktLlZ6nbWLmStDuWdP
                                                                                                                                                                                      array:4 [ "data" => array:2 [ "category" => App\Models\Category {#3469 #connection: "mys...
                                                                                                                                                                                      sidebar.cards.category #kpGDjiurwzv7dOD0BvnR
                                                                                                                                                                                      array:4 [ "data" => array:2 [ "category" => App\Models\Category {#3376 #connection: "mys...
                                                                                                                                                                                      sidebar.cards.category #thXph8iOLZRSaOQpN3Pf
                                                                                                                                                                                      array:4 [ "data" => array:2 [ "category" => App\Models\Category {#3814 #connection: "mys...
                                                                                                                                                                                      sidebar.cards.category #N9qT3U59WTR3pYN4TIui
                                                                                                                                                                                      array:4 [ "data" => array:2 [ "category" => App\Models\Category {#3446 #connection: "mys...
                                                                                                                                                                                      sidebar.cards.category #Wif7kNCsnhVQG5R4QXXh
                                                                                                                                                                                      array:4 [ "data" => array:2 [ "category" => App\Models\Category {#3319 #connection: "mys...
                                                                                                                                                                                      sidebar.cards.category #7t9EDI7SExzw9MyejIFy
                                                                                                                                                                                      array:4 [ "data" => array:2 [ "category" => App\Models\Category {#3318 #connection: "mys...
                                                                                                                                                                                      sidebar.cards.category #b4TgPafIaVbYf45R5tJN
                                                                                                                                                                                      array:4 [ "data" => array:2 [ "category" => App\Models\Category {#3317 #connection: "mys...
                                                                                                                                                                                      sidebar.cards.category #H4PpWw9yiwxR4CJJBtI0
                                                                                                                                                                                      array:4 [ "data" => array:2 [ "category" => App\Models\Category {#3316 #connection: "mys...
                                                                                                                                                                                      sidebar.cards.category #fiMFVcv45bqnxfrt0Us2
                                                                                                                                                                                      array:4 [ "data" => array:2 [ "category" => App\Models\Category {#3315 #connection: "mys...
                                                                                                                                                                                      sidebar.cards.category #xLNsZPmJ0KGu0PfY9q6g
                                                                                                                                                                                      array:4 [ "data" => array:2 [ "category" => App\Models\Category {#3314 #connection: "mys...
                                                                                                                                                                                      sidebar.blocks.locations #m7EWWW6HqhVAQYZYzMqs
                                                                                                                                                                                      array:4 [ "data" => array:16 [ "locations" => null "current_id" => null "heading" => "...
                                                                                                                                                                                      sidebar.blocks.locations #NQzkLYjx7ubiGYCUCfrn
                                                                                                                                                                                      array:4 [ "data" => array:16 [ "locations" => null "current_id" => null "heading" => "...
                                                                                                                                                                                      search #wbs0NpKKm6EU0zaBiCfe
                                                                                                                                                                                      array:4 [ "data" => array:1 [ "search" => "" ] "name" => "search" "component" => "App\Li...
                                                                                                                                                                                      search #W8LLHE0A48lHj2RX8AXa
                                                                                                                                                                                      array:4 [ "data" => array:1 [ "search" => "" ] "name" => "search" "component" => "App\Li...
                                                                                                                                                                                      filter.filter #frxbPWCy4zLWio0K4a7N
                                                                                                                                                                                      array:4 [ "data" => array:5 [ "hours" => 0 "filtersAreNotEmpty" => false "showFilter" ...
                                                                                                                                                                                      filter.slide-in #g0xHQtReYMufoF4hB39l
                                                                                                                                                                                      array:4 [ "data" => array:8 [ "openFrom" => "" "openTo" => "" "dayRange" => "today" ...
                                                                                                                                                                                      location.location-autocomplete #sgJ9eXF6VjAxC4MdR0ts
                                                                                                                                                                                      array:4 [ "data" => array:5 [ "initialLocation" => "Amsterdam, 1012 JS" "location" => "Ams...
                                                                                                                                                                                      sidebar.navigation #68njNye3QEmYDWUvub5s
                                                                                                                                                                                      array:4 [ "data" => [] "name" => "sidebar.navigation" "component" => "App\Livewire\Sidebar\Nav...
                                                                                                                                                                                      modal.location #25yoeCLgeZF5odbmfTmx
                                                                                                                                                                                      array:4 [ "data" => array:2 [ "classes" => [] "showModal" => false ] "name" => "modal....
                                                                                                                                                                                      location.location-autocomplete #r7Xf4Q1Dasj1pxpAZOpI
                                                                                                                                                                                      array:4 [ "data" => array:5 [ "initialLocation" => "Amsterdam, 1012 JS" "location" => "Ams...
                                                                                                                                                                                      filter.filter #du9PIYMz6b3wnrgc0tnu
                                                                                                                                                                                      array:4 [ "data" => array:5 [ "hours" => 0 "filtersAreNotEmpty" => false "showFilter" ...
                                                                                                                                                                                      filter.slide-in #Dhp4Gwf4f8C4Q8h58iV5
                                                                                                                                                                                      array:4 [ "data" => array:8 [ "openFrom" => "" "openTo" => "" "dayRange" => "today" ...
                                                                                                                                                                                      location.location-autocomplete #Ddc5uE89ayFxUMLbyMHc
                                                                                                                                                                                      array:4 [ "data" => array:5 [ "initialLocation" => "Amsterdam, 1012 JS" "location" => "Ams...
                                                                                                                                                                                      common.local-bar #cszFWhZkLpRdwkMkMead
                                                                                                                                                                                      array:4 [ "data" => [] "name" => "common.local-bar" "component" => "App\Livewire\Common\LocalB...
                                                                                                                                                                                      auth.signup #fZa93Q06zCUFyD90IgY1
                                                                                                                                                                                      array:4 [ "data" => [] "name" => "auth.signup" "component" => "App\Livewire\Auth\Signup" "id...
                                                                                                                                                                                      auth.login #x4svo2HjRkLBSKHlAc4z
                                                                                                                                                                                      array:4 [ "data" => array:3 [ "email" => null "password" => null "class" => "" ] "...
                                                                                                                                                                                      auth.onboarding #gBwAoHfRVphvRU4q3Xne
                                                                                                                                                                                      array:4 [ "data" => array:6 [ "name" => null "classes" => [] "localities" => null ...
                                                                                                                                                                                      location.location-autocomplete #rKl68l9q8GC3nWrQ0vjp
                                                                                                                                                                                      array:4 [ "data" => array:5 [ "initialLocation" => "Amsterdam, 1012 JS" "location" => "Ams...
                                                                                                                                                                                      auth.register #5we0Fcf4Xx4tGT9cBxcq
                                                                                                                                                                                      array:4 [ "data" => array:3 [ "email" => null "password" => null "class" => "" ] "...
                                                                                                                                                                                      auth.forgot-password #6l0ClNhVS0XuXZYl0vOj
                                                                                                                                                                                      array:4 [ "data" => array:3 [ "email" => "" "class" => "" "successMessage" => null ]...
                                                                                                                                                                                      auth.delete-account #e9MKRktwuxxpAxEzlAqe
                                                                                                                                                                                      array:4 [ "data" => [] "name" => "auth.delete-account" "component" => "App\Livewire\Auth\Delet...
                                                                                                                                                                                          _token
                                                                                                                                                                                          JjSnzQmgE1IpeAO3BAln9kTIOvIKU0mWVrzph8mD
                                                                                                                                                                                          parent_page
                                                                                                                                                                                          pages.city-category
                                                                                                                                                                                          url
                                                                                                                                                                                          array:1 [ "intended" => "https://alpha.hours.com/Friesland/Ureterp/Sport-Recreation" ]
                                                                                                                                                                                          _previous
                                                                                                                                                                                          array:1 [ "url" => "https://alpha.hours.com/Friesland/Ureterp/Sport-Recreation" ]
                                                                                                                                                                                          _flash
                                                                                                                                                                                          array:2 [ "old" => [] "new" => [] ]
                                                                                                                                                                                          path_info
                                                                                                                                                                                          /Friesland/Ureterp/Sport-Recreation
                                                                                                                                                                                          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:16 [ "cookie" => array:1 [ 0 => "_pk_id.3.58f2=4dc27582433ddb92.1744102452.; _pk_ses.3.58f2=1; XSRF-TOKEN=eyJpdiI6IklicVFXSFIyS3pqemw0ekp5by8vcWc9PSIsInZhbHVlIjoiRlJYeHhPNm5YSytnZ2tZU3pTQXFYZzFzcDNDZkxCZmloSkxxYWp2b3FtL2FkM05RMW9sWitNL1FFU0Vzc1ZGTGlJOW5YcXVPUHNQYkZKMndmbTJ5ZXZHRGVhVnRmdStmbnRpck52SjVoOEltZXdrZnlMWEVtUm1XejIvL1dzR2YiLCJtYWMiOiI1NGE3NDJlZGRkNjY2ZGIyM2I5MTdmNzU3ZjBlM2ZkNDA2OWQ1YzE2NGFkMDk1MzhmMmNjODFhOTg2ZDE5YzhiIiwidGFnIjoiIn0%3D; hours_frontend_session=eyJpdiI6IkFlUXZDV2xSZ2JRQzZVVjFkQ0lMNFE9PSIsInZhbHVlIjoiWWluYnZ0ZWxrQWsxenhXOUxaMmZyazZzSTFHOVpZMXdwbGx0eE5kVFJYKyt4RE0raG1FWlMwM0tqMDRxbUtRTkFHK0V1ZlczNmRtWEh5Nkdlb1NqbDNacXNhclRRbHcyOTdtWjN4dEpZVnVLS2o4OTYzaHFCMGJDdW5KTGEwN2siLCJtYWMiOiI2OWRjYzljYmM5NWFkZWZhZWMyODAzODc2OTg0MDk5MWFiOWYzZGNkNGE3NzgxNTRiNjg3YTY0ODc3NjBhNTQzIiwidGFnIjoiIn0%3D_pk_id.3.58f2=4dc27582433ddb92.1744102452.; _pk_ses.3.58f2=1; XSRF-TOKEN=eyJpdiI6IklicVFXSFIyS3pqemw0ekp5by8vcWc9PSIsInZhbHVlIjoiRlJYeHhPNm5YSytnZ2tZU3pTQXFYZzF" ] "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
                                                                                                                                                                                          0 of 0
                                                                                                                                                                                          array:4 [ "_pk_id_3_58f2" => null "_pk_ses_3_58f2" => null "XSRF-TOKEN" => "JjSnzQmgE1IpeAO3BAln9kTIOvIKU0mWVrzph8mD" "hours_frontend_session" => "CEgaRxCnlZpkFa0CA23G5Y0mFFHRdkZVfGuL035N" ]
                                                                                                                                                                                          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 => "Tue, 08 Apr 2025 08:54:24 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=eyJpdiI6IlRDQnJiYVZqczhNaDRYQzB6N3I3UlE9PSIsInZhbHVlIjoiNTNlekY4dDlKeVNDNmo3aUlUU3dOTEdqMDNCd1Jrc2U2SThaR2NtREJteUFBN1E4NHNNNjkyeVZBT2ZTR0N2ZnEvWExrNW9ZcWtCTENtODdxejlDTGErV1YwOFkwcjl2a3g5SzI2bzlrd2RaOXd6bk8rWUUzK1FvY1JkNmRyQ3ciLCJtYWMiOiIxNzIyYmQyOTQxYjhhYjI1YjBmZWRjNjUwNGMwYWNhZjhjNzljZTY4NWMzMzU5NDVlMDY0MDliNjBmYTU0ZWExIiwidGFnIjoiIn0%3D; expires=Tue, 08 Apr 2025 10:54:28 GMT; Max-Age=7200; path=/; secure; samesite=laxXSRF-TOKEN=eyJpdiI6IlRDQnJiYVZqczhNaDRYQzB6N3I3UlE9PSIsInZhbHVlIjoiNTNlekY4dDlKeVNDNmo3aUlUU3dOTEdqMDNCd1Jrc2U2SThaR2NtREJteUFBN1E4NHNNNjkyeVZBT2ZTR0N2ZnEvWExrN" 1 => "hours_frontend_session=eyJpdiI6InRhQndwUG5RNi82MFZvdXcvUXMyclE9PSIsInZhbHVlIjoiS2N0NnVDRnVLbVV2NTNZQWQwRS9tNWJpZTFUdHVCSXRVWHZSMXpQdllNZnpYa2ZiZmRxeDNXQll5MlA1Q0dJOVhMS0xNUXhDc3JyMzlSeXF0WFBRdjZRM1V1ZlYxTnc0WEFhQm03ekwxd29wQU1STWVFVkR0ZjYyY05CVmpsNXUiLCJtYWMiOiIzYjM2MWFhNDJjNzFiMzI0NDRmYzAzNzg5ZmQ1YTQyNDY5MGU1NGM2YTY2NjAzMzk0ZjYzNjA3MmFmM2ZlOWIxIiwidGFnIjoiIn0%3D; expires=Tue, 08 Apr 2025 10:54:28 GMT; Max-Age=7200; path=/; httponly; samesite=laxhours_frontend_session=eyJpdiI6InRhQndwUG5RNi82MFZvdXcvUXMyclE9PSIsInZhbHVlIjoiS2N0NnVDRnVLbVV2NTNZQWQwRS9tNWJpZTFUdHVCSXRVWHZSMXpQdllNZnpYa2ZiZmRxeDNXQll5MlA1Q" ] "Set-Cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6IlRDQnJiYVZqczhNaDRYQzB6N3I3UlE9PSIsInZhbHVlIjoiNTNlekY4dDlKeVNDNmo3aUlUU3dOTEdqMDNCd1Jrc2U2SThaR2NtREJteUFBN1E4NHNNNjkyeVZBT2ZTR0N2ZnEvWExrNW9ZcWtCTENtODdxejlDTGErV1YwOFkwcjl2a3g5SzI2bzlrd2RaOXd6bk8rWUUzK1FvY1JkNmRyQ3ciLCJtYWMiOiIxNzIyYmQyOTQxYjhhYjI1YjBmZWRjNjUwNGMwYWNhZjhjNzljZTY4NWMzMzU5NDVlMDY0MDliNjBmYTU0ZWExIiwidGFnIjoiIn0%3D; expires=Tue, 08-Apr-2025 10:54:28 GMT; path=/; secureXSRF-TOKEN=eyJpdiI6IlRDQnJiYVZqczhNaDRYQzB6N3I3UlE9PSIsInZhbHVlIjoiNTNlekY4dDlKeVNDNmo3aUlUU3dOTEdqMDNCd1Jrc2U2SThaR2NtREJteUFBN1E4NHNNNjkyeVZBT2ZTR0N2ZnEvWExrN" 1 => "hours_frontend_session=eyJpdiI6InRhQndwUG5RNi82MFZvdXcvUXMyclE9PSIsInZhbHVlIjoiS2N0NnVDRnVLbVV2NTNZQWQwRS9tNWJpZTFUdHVCSXRVWHZSMXpQdllNZnpYa2ZiZmRxeDNXQll5MlA1Q0dJOVhMS0xNUXhDc3JyMzlSeXF0WFBRdjZRM1V1ZlYxTnc0WEFhQm03ekwxd29wQU1STWVFVkR0ZjYyY05CVmpsNXUiLCJtYWMiOiIzYjM2MWFhNDJjNzFiMzI0NDRmYzAzNzg5ZmQ1YTQyNDY5MGU1NGM2YTY2NjAzMzk0ZjYzNjA3MmFmM2ZlOWIxIiwidGFnIjoiIn0%3D; expires=Tue, 08-Apr-2025 10:54:28 GMT; path=/; httponlyhours_frontend_session=eyJpdiI6InRhQndwUG5RNi82MFZvdXcvUXMyclE9PSIsInZhbHVlIjoiS2N0NnVDRnVLbVV2NTNZQWQwRS9tNWJpZTFUdHVCSXRVWHZSMXpQdllNZnpYa2ZiZmRxeDNXQll5MlA1Q" ] ]
                                                                                                                                                                                          session_attributes
                                                                                                                                                                                          0 of 0
                                                                                                                                                                                          array:5 [ "_token" => "JjSnzQmgE1IpeAO3BAln9kTIOvIKU0mWVrzph8mD" "parent_page" => "pages.city-category" "url" => array:1 [ "intended" => "https://alpha.hours.com/Friesland/Ureterp/Sport-Recreation" ] "_previous" => array:1 [ "url" => "https://alpha.hours.com/Friesland/Ureterp/Sport-Recreation" ] "_flash" => array:2 [ "old" => [] "new" => [] ] ]
                                                                                                                                                                                          ClearShow all
                                                                                                                                                                                          Date ↕MethodURLData
                                                                                                                                                                                          #12025-04-08 08:54:28GET/Friesland/Ureterp/Sport-Recreation1994838348