Request history8.2.28PHP Version146msRequest Duration5MBMemory UsageGET {route}Route
    • Booting (7.55ms)time
    • Application (139ms)time
    • 1 x Application (94.83%)
      139ms
      1 x Booting (5.17%)
      7.55ms
      150 templates were rendered
      • 1x pages.provinceprovince.blade.php#?blade
      • 1x livewire.topbartopbar.blade.php#?blade
      • 1x components.login-buttonlogin-button.blade.php#?blade
      • 1x components.partials.hero.hubhub.blade.php#?blade
      • 1x components.common.list.alphabetalphabet.blade.php#?blade
      • 19x components.common.list.iconicon.blade.php#?blade
      • 70x components.common.list.itemitem.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
      • 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.sidebar.blocks.citiescities.blade.php#?blade
      • 1x components.sidebar.blocks.categoriescategories.blade.php#?blade
      • 9x components.sidebar.cards.categorycategory.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
      7 statements were executed61.41ms
      • Connection Establishedhours_frontendDynamicRouteControllerDispatcher.php#43
        Backtrace
        • update `routes` set `visit_count` = `visit_count` + 1, `routes`.`updated_at` = '2025-04-08 14:30:16' where `id` = 255899
          3.99mshours_frontendDynamicRouteControllerDispatcher.php#43
          Bindings
            Backtrace
            • select count(*) as aggregate from `regions` where `regions`.`region_id` = 85687055 and `regions`.`region_id` is not null and `type` = 'locality' and `is_landingpage` = 1
              2.67mshours_frontendDynamicRouteControllerDispatcher.php#258
              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
                  34.51mshours_frontendTranslations.php#17
                  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
                    6.42mshours_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
                        11.7mshours_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
                            1.13mshours_frontendUserLocation.php#78
                            Bindings
                              Backtrace
                              • select * from `regions` where `regions`.`id` = 85687055 limit 1
                                990μshours_frontendCategory.php#39
                                Bindings
                                  Backtrace
                                  App\Models\Region
                                  3Region.php#?
                                  topbar #IKVAANRTFzAl8413BwFF
                                  array:4 [ "data" => array:4 [ "user" => null "parent" => null "sub" => null "fullW...
                                  breadcrumbs #0suA8lep7YVEVnLBEnAH
                                  array:4 [ "data" => array:3 [ "parent" => null "sub" => null "fixedName" => "" ] "...
                                  search-results #lgUpyowBj81WLmjLK50C
                                  array:4 [ "data" => array:6 [ "search" => "" "results" => [] "searchOverlayActive" => ...
                                  partials.search-around #hH5GfillJaLdO441mtY6
                                  array:4 [ "data" => array:1 [ "userLocation" => array:4 [ "longitude" => 4.895168 ...
                                  sidebar.cards.area #Bhjghn1XvZw9yCKECYnU
                                  array:4 [ "data" => array:1 [ "area" => App\Models\Region {#4375 #connection: "mysql" ...
                                  sidebar.cards.area #YoW5ZSbGdBDYr2oyvUGQ
                                  array:4 [ "data" => array:1 [ "area" => App\Models\Region {#4379 #connection: "mysql" ...
                                  sidebar.cards.category #2LiWOkSV6IXPh5ytP0th
                                  array:4 [ "data" => array:2 [ "category" => App\Models\Category {#4462 #connection: "mys...
                                  sidebar.cards.category #05oU8DUcMa66ZEDrEx5a
                                  array:4 [ "data" => array:2 [ "category" => App\Models\Category {#4447 #connection: "mys...
                                  sidebar.cards.category #UUB3S7M1fwiJXs3ZK5Yc
                                  array:4 [ "data" => array:2 [ "category" => App\Models\Category {#4667 #connection: "mys...
                                  sidebar.cards.category #YOdQ1JZvPvkdpoyMkjDk
                                  array:4 [ "data" => array:2 [ "category" => App\Models\Category {#4355 #connection: "mys...
                                  sidebar.cards.category #JNQUZjBNqkFEqllCXLqm
                                  array:4 [ "data" => array:2 [ "category" => App\Models\Category {#4212 #connection: "mys...
                                  sidebar.cards.category #lVm24OuGMVJxXX8gZbvY
                                  array:4 [ "data" => array:2 [ "category" => App\Models\Category {#4211 #connection: "mys...
                                  sidebar.cards.category #rbPTFmazEXNnHCiLIRUh
                                  array:4 [ "data" => array:2 [ "category" => App\Models\Category {#4210 #connection: "mys...
                                  sidebar.cards.category #nbl8YTfOs3f9chih3oD9
                                  array:4 [ "data" => array:2 [ "category" => App\Models\Category {#4209 #connection: "mys...
                                  sidebar.cards.category #KTogWYl0xI7mASx82JTe
                                  array:4 [ "data" => array:2 [ "category" => App\Models\Category {#4208 #connection: "mys...
                                  sidebar.cards.category #mzwOxXKH7sbEWI4ntsgz
                                  array:4 [ "data" => array:2 [ "category" => App\Models\Category {#4207 #connection: "mys...
                                  search #xmUCl1Z80ACpVXenfoze
                                  array:4 [ "data" => array:1 [ "search" => "" ] "name" => "search" "component" => "App\Li...
                                  search #Xuzdbv6HV1iP6RzzNWoI
                                  array:4 [ "data" => array:1 [ "search" => "" ] "name" => "search" "component" => "App\Li...
                                  filter.filter #LfNO68qECgagOt59aO65
                                  array:4 [ "data" => array:5 [ "hours" => 0 "filtersAreNotEmpty" => false "showFilter" ...
                                  filter.slide-in #09ZrH3kQlaMoDtH0F3zx
                                  array:4 [ "data" => array:8 [ "openFrom" => "" "openTo" => "" "dayRange" => "today" ...
                                  location.location-autocomplete #2DiWdAMMmWDBYZUp0PJh
                                  array:4 [ "data" => array:5 [ "initialLocation" => "Amsterdam, 1012 JS" "location" => "Ams...
                                  sidebar.navigation #qq1KdXLZPnFNRPAWwUoe
                                  array:4 [ "data" => [] "name" => "sidebar.navigation" "component" => "App\Livewire\Sidebar\Nav...
                                  modal.location #P1ZWkglSeiEAnQKnsp1y
                                  array:4 [ "data" => array:2 [ "classes" => [] "showModal" => false ] "name" => "modal....
                                  location.location-autocomplete #cSQ1yYiFJjh5GxFn9G23
                                  array:4 [ "data" => array:5 [ "initialLocation" => "Amsterdam, 1012 JS" "location" => "Ams...
                                  filter.filter #sOfzPooc5YekQBxtWy2F
                                  array:4 [ "data" => array:5 [ "hours" => 0 "filtersAreNotEmpty" => false "showFilter" ...
                                  filter.slide-in #OBQkUCzigDhdX8RPBzCe
                                  array:4 [ "data" => array:8 [ "openFrom" => "" "openTo" => "" "dayRange" => "today" ...
                                  location.location-autocomplete #9c4KHWclXVMgkADIpWdT
                                  array:4 [ "data" => array:5 [ "initialLocation" => "Amsterdam, 1012 JS" "location" => "Ams...
                                  common.local-bar #NtUfw4wgOwZdgNVoahWW
                                  array:4 [ "data" => [] "name" => "common.local-bar" "component" => "App\Livewire\Common\LocalB...
                                  auth.signup #7RJcQCFwnjUG9C46jKeu
                                  array:4 [ "data" => [] "name" => "auth.signup" "component" => "App\Livewire\Auth\Signup" "id...
                                  auth.login #tPauMiqqrDkEWvYI5158
                                  array:4 [ "data" => array:3 [ "email" => null "password" => null "class" => "" ] "...
                                  auth.onboarding #vO8UadYSDPa8Iq0fXPSa
                                  array:4 [ "data" => array:6 [ "name" => null "classes" => [] "localities" => null ...
                                  location.location-autocomplete #Z2X2YleFgIUryNWCBXvr
                                  array:4 [ "data" => array:5 [ "initialLocation" => "Amsterdam, 1012 JS" "location" => "Ams...
                                  auth.register #GQ9re0h2v1IAFxEEB4ZV
                                  array:4 [ "data" => array:3 [ "email" => null "password" => null "class" => "" ] "...
                                  auth.forgot-password #NpQ8Sw1CjS7YqsO14Oxx
                                  array:4 [ "data" => array:3 [ "email" => "" "class" => "" "successMessage" => null ]...
                                  auth.delete-account #Bd7DGNlwoxq4Rs222a9f
                                  array:4 [ "data" => [] "name" => "auth.delete-account" "component" => "App\Livewire\Auth\Delet...
                                      _token
                                      kSsy0PkwCuCLBMQ18E7ew40g37cdwkIssZnB3Cvn
                                      parent_page
                                      pages.province
                                      url
                                      array:1 [ "intended" => "https://alpha.hours.com/Friesland" ]
                                      _previous
                                      array:1 [ "url" => "https://alpha.hours.com/Friesland" ]
                                      _flash
                                      array:2 [ "old" => [] "new" => [] ]
                                      path_info
                                      /Friesland
                                      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=090057d274fe8d98.1744122598.; _pk_ses.3.58f2=1; XSRF-TOKEN=eyJpdiI6InhKVXFZRWMrb2dqdnpydlZnZ2wvVkE9PSIsInZhbHVlIjoiUy82SXgyalJzMVFyQi9oYU01eE90cWk5TFZDcFV2Wm1FS0dDMURIRTkvZHEwZUltaHo2SkwxZzc5R0VHUGdacVBrSlJEMVhaSXFxRVlVdy9DTGQwR3JMMVRCT3RlRzFWem5CSFNQb1pwQ3dkamt2Z1dCYUxGVDNKazJLY0V1NTkiLCJtYWMiOiIyYTc5YTcyZWEwZDFhZDZiMmQ3NzA3MjZkMzA5NmQwMGNmNTE3ODkyMDM5NzViYmQyMjk0MTc4MzE5NTY5MmExIiwidGFnIjoiIn0%3D; hours_frontend_session=eyJpdiI6IksxbURoWmpJUjVHekJIbTFoMVhiNnc9PSIsInZhbHVlIjoieDZvOTV6NXVOYmFlcEpybzlLS0xLR3JnbDdXdUlVZTQrR29OSm5GNm4xZ2xLbGlVT3pIOVl6S3VFYWZWWFRlcmVNcHY5eGQxeTdMclFkVE9rekFtaFFCbzhKMmtNVGRmVzJlZWVScEpWME5ydFZKY3FGMW9JOW5aMXBNcEN6ZlAiLCJtYWMiOiJmMTczYjNiMjlhZTE2NmJiNTY0OTJkZmNjMjljOTBmODA0ODlkYmU1Y2MzZmJjNjhiYjJhYzExZmM1YWU0MTExIiwidGFnIjoiIn0%3D_pk_id.3.58f2=090057d274fe8d98.1744122598.; _pk_ses.3.58f2=1; XSRF-TOKEN=eyJpdiI6InhKVXFZRWMrb2dqdnpydlZnZ2wvVkE9PSIsInZhbHVlIjoiUy82SXgyalJzMVFyQi9oYU01eE90cWk" ] "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" => "kSsy0PkwCuCLBMQ18E7ew40g37cdwkIssZnB3Cvn" "hours_frontend_session" => "We1L9OVlMr3Jit51QHvlVSa4xMhdq5qApUuZWIdl" ]
                                      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 14:30:16 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=eyJpdiI6IlZFMWRZc1NBbVhMNnpQNmhGLzYxdHc9PSIsInZhbHVlIjoiMmVsSFpQN3JxMTZnbWhoNWxBNmx5QVgrYzhlT3lCMkZEVk5LZUdSTHlCeXU5RlZudldRS0syVjVFUzJLdkczZmVxa1BqQ1JrQ0pmckcvTDVyR1RYZnRKSi84MWZ6dUdRMkp0ZktKL2lHdVJRUUgvQ0EvU0daZ05LSkhxMHhsUUIiLCJtYWMiOiJjOGY2N2VhZWI2ZWFkYjgxYmU5ZmE2NTM4OWNjMDBlNmJlNTEwZTBiNmYyYzE4ODI5ZjgxNzg4ZTliNjYwYjBiIiwidGFnIjoiIn0%3D; expires=Tue, 08 Apr 2025 16:30:16 GMT; Max-Age=7200; path=/; secure; samesite=laxXSRF-TOKEN=eyJpdiI6IlZFMWRZc1NBbVhMNnpQNmhGLzYxdHc9PSIsInZhbHVlIjoiMmVsSFpQN3JxMTZnbWhoNWxBNmx5QVgrYzhlT3lCMkZEVk5LZUdSTHlCeXU5RlZudldRS0syVjVFUzJLdkczZmVxa1BqQ" 1 => "hours_frontend_session=eyJpdiI6IjBwSVdOQUtJZXZLUm15V01yT0xpY1E9PSIsInZhbHVlIjoidzN0b1FvaVZ5UUkzMmE5MUNZS1dUTVE4a1hPeXYvRlppZlJuY25SZlVWYTZXVklQdVNpNy9neXkrblhNN1NIM1ZKUklTTHhjQ3JVaHBkMFRDNmtJKy91NXpTVnV4cnRHOXJRMHNUYWg0S01LeWZMUUNGUlpPd2dCRXhIbDdlYlAiLCJtYWMiOiI4Zjg2MzdmNWIwY2Y5N2NjMjY0NmQ1ZTI0MmY2Yjk2MjdjNThlNDljMGFlMDQwNWQzN2ZiMGUxZDdkMGM4NTcyIiwidGFnIjoiIn0%3D; expires=Tue, 08 Apr 2025 16:30:16 GMT; Max-Age=7200; path=/; httponly; samesite=laxhours_frontend_session=eyJpdiI6IjBwSVdOQUtJZXZLUm15V01yT0xpY1E9PSIsInZhbHVlIjoidzN0b1FvaVZ5UUkzMmE5MUNZS1dUTVE4a1hPeXYvRlppZlJuY25SZlVWYTZXVklQdVNpNy9neXkrblhNN" ] "Set-Cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6IlZFMWRZc1NBbVhMNnpQNmhGLzYxdHc9PSIsInZhbHVlIjoiMmVsSFpQN3JxMTZnbWhoNWxBNmx5QVgrYzhlT3lCMkZEVk5LZUdSTHlCeXU5RlZudldRS0syVjVFUzJLdkczZmVxa1BqQ1JrQ0pmckcvTDVyR1RYZnRKSi84MWZ6dUdRMkp0ZktKL2lHdVJRUUgvQ0EvU0daZ05LSkhxMHhsUUIiLCJtYWMiOiJjOGY2N2VhZWI2ZWFkYjgxYmU5ZmE2NTM4OWNjMDBlNmJlNTEwZTBiNmYyYzE4ODI5ZjgxNzg4ZTliNjYwYjBiIiwidGFnIjoiIn0%3D; expires=Tue, 08-Apr-2025 16:30:16 GMT; path=/; secureXSRF-TOKEN=eyJpdiI6IlZFMWRZc1NBbVhMNnpQNmhGLzYxdHc9PSIsInZhbHVlIjoiMmVsSFpQN3JxMTZnbWhoNWxBNmx5QVgrYzhlT3lCMkZEVk5LZUdSTHlCeXU5RlZudldRS0syVjVFUzJLdkczZmVxa1BqQ" 1 => "hours_frontend_session=eyJpdiI6IjBwSVdOQUtJZXZLUm15V01yT0xpY1E9PSIsInZhbHVlIjoidzN0b1FvaVZ5UUkzMmE5MUNZS1dUTVE4a1hPeXYvRlppZlJuY25SZlVWYTZXVklQdVNpNy9neXkrblhNN1NIM1ZKUklTTHhjQ3JVaHBkMFRDNmtJKy91NXpTVnV4cnRHOXJRMHNUYWg0S01LeWZMUUNGUlpPd2dCRXhIbDdlYlAiLCJtYWMiOiI4Zjg2MzdmNWIwY2Y5N2NjMjY0NmQ1ZTI0MmY2Yjk2MjdjNThlNDljMGFlMDQwNWQzN2ZiMGUxZDdkMGM4NTcyIiwidGFnIjoiIn0%3D; expires=Tue, 08-Apr-2025 16:30:16 GMT; path=/; httponlyhours_frontend_session=eyJpdiI6IjBwSVdOQUtJZXZLUm15V01yT0xpY1E9PSIsInZhbHVlIjoidzN0b1FvaVZ5UUkzMmE5MUNZS1dUTVE4a1hPeXYvRlppZlJuY25SZlVWYTZXVklQdVNpNy9neXkrblhNN" ] ]
                                      session_attributes
                                      0 of 0
                                      array:5 [ "_token" => "kSsy0PkwCuCLBMQ18E7ew40g37cdwkIssZnB3Cvn" "parent_page" => "pages.province" "url" => array:1 [ "intended" => "https://alpha.hours.com/Friesland" ] "_previous" => array:1 [ "url" => "https://alpha.hours.com/Friesland" ] "_flash" => array:2 [ "old" => [] "new" => [] ] ]
                                      ClearShow all
                                      Date ↕MethodURLData
                                      #12025-04-08 14:30:16GET/Friesland1508335