CITIES THAT WE SERVICE IN CT

Berlin
Hartford
Madison
NOrwich
New Britain
New Haven
Putnam
Shelton
West Haven
MessagesTimelineExceptionsViews5RouteQueries11Models19MailsGateSessionRequest
Request history8.3.6PHP Version51.49msRequest Duration3MBMemory UsageGET List_All_Cities_In_{slug}Route
    • Booting (30.68ms)time
    • Application (20.8ms)time
    • 1 x Booting (59.58%)
      30.68ms
      1 x Application (40.4%)
      20.80ms
      5 templates were rendered
      • 1x web.sitemapCitysitemapCity.blade.php#?blade
      • 1x web.layout.mastermaster.blade.php#?blade
      • 1x web.include.menumenu.blade.php#?blade
      • 1x web.include.footerfooter.blade.php#?blade
      • 1x web.include.web-alert-modalweb-alert-modal.blade.php#?blade
      uri
      GET List_All_Cities_In_{slug}
      middleware
      web
      controller
      App\Http\Controllers\Web\SiteMapController@viewCities
      namespace
      prefix
      where
      as
      sitemap.city
      file
      app/Http/Controllers/Web/SiteMapController.php:27-46
      11 statements were executed (9 duplicates)Show only duplicates7.52ms
      • SiteMapController.php#28acpr_db_original_staging1.25msselect * from `acpr_states` where `state_code` = 'CT' and `acpr_states`.`deleted_at` is null limit 1
        Bindings
        • 0: CT
        Backtrace
        • app/Http/Controllers/Web/SiteMapController.php:28
        • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
      • SiteMapController.php#35acpr_db_original_staging1.69msselect `state_id`, `id`, `city`, LOWER(city) as city_lower from `acpr_locations` where exists (select * from `acpr_states` where `acpr_locations`.`state_id` = `acpr_states`.`id` and `state_code` = 'CT' and `acpr_states`.`deleted_at` is null) and `acpr_locations`.`deleted_at` is null group by `city_lower`
        Bindings
        • 0: CT
        Backtrace
        • app/Http/Controllers/Web/SiteMapController.php:35
        • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
      • Location.php#28acpr_db_original_staging600μsselect * from `acpr_states` where `acpr_states`.`id` = 7 and `acpr_states`.`deleted_at` is null limit 1
        Bindings
        • 0: 7
        Backtrace
        • app/Models/Location.php:28
        • view::web.sitemapCity:20
        • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
        • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
      • Location.php#28acpr_db_original_staging540μsselect * from `acpr_states` where `acpr_states`.`id` = 7 and `acpr_states`.`deleted_at` is null limit 1
        Bindings
        • 0: 7
        Backtrace
        • app/Models/Location.php:28
        • view::web.sitemapCity:20
        • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
        • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
      • Location.php#28acpr_db_original_staging490μsselect * from `acpr_states` where `acpr_states`.`id` = 7 and `acpr_states`.`deleted_at` is null limit 1
        Bindings
        • 0: 7
        Backtrace
        • app/Models/Location.php:28
        • view::web.sitemapCity:20
        • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
        • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
      • Location.php#28acpr_db_original_staging500μsselect * from `acpr_states` where `acpr_states`.`id` = 7 and `acpr_states`.`deleted_at` is null limit 1
        Bindings
        • 0: 7
        Backtrace
        • app/Models/Location.php:28
        • view::web.sitemapCity:20
        • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
        • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
      • Location.php#28acpr_db_original_staging480μsselect * from `acpr_states` where `acpr_states`.`id` = 7 and `acpr_states`.`deleted_at` is null limit 1
        Bindings
        • 0: 7
        Backtrace
        • app/Models/Location.php:28
        • view::web.sitemapCity:20
        • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
        • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
      • Location.php#28acpr_db_original_staging490μsselect * from `acpr_states` where `acpr_states`.`id` = 7 and `acpr_states`.`deleted_at` is null limit 1
        Bindings
        • 0: 7
        Backtrace
        • app/Models/Location.php:28
        • view::web.sitemapCity:20
        • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
        • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
      • Location.php#28acpr_db_original_staging490μsselect * from `acpr_states` where `acpr_states`.`id` = 7 and `acpr_states`.`deleted_at` is null limit 1
        Bindings
        • 0: 7
        Backtrace
        • app/Models/Location.php:28
        • view::web.sitemapCity:20
        • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
        • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
      • Location.php#28acpr_db_original_staging500μsselect * from `acpr_states` where `acpr_states`.`id` = 7 and `acpr_states`.`deleted_at` is null limit 1
        Bindings
        • 0: 7
        Backtrace
        • app/Models/Location.php:28
        • view::web.sitemapCity:20
        • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
        • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
      • Location.php#28acpr_db_original_staging490μsselect * from `acpr_states` where `acpr_states`.`id` = 7 and `acpr_states`.`deleted_at` is null limit 1
        Bindings
        • 0: 7
        Backtrace
        • app/Models/Location.php:28
        • view::web.sitemapCity:20
        • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
        • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
      App\Models\State
      10State.php#?
      App\Models\Location
      9Location.php#?
          _token
          aGv3ZaJBVLcWxIjZuBeUutvLg0PFuz2IiiJnMjP0
          _previous
          array:1 [ "url" => "https://staging.alwayscpr.com/List_All_Cities_In_CT" ]
          _flash
          array:2 [ "old" => [] "new" => [] ]
          path_info
          /List_All_Cities_In_CT
          status_code
          200
          status_text
          OK
          format
          html
          content_type
          text/html; charset=UTF-8
          request_query
          []
          request_request
          []
          request_headers
            0 of 0   
          array:15 [▼
  "host" => array:1 [▶
    0 => "staging.alwayscpr.com"
  ]
  "connection" => array:1 [▶
    0 => "keep-alive"
  ]
  "pragma" => array:1 [▶
    0 => "no-cache"
  ]
  "cache-control" => array:1 [▶
    0 => "no-cache"
  ]
  "sec-ch-ua" => array:1 [▶
    0 => ""Chromium";v="130", "HeadlessChrome";v="130", "Not?A_Brand";v="99""
  ]
  "sec-ch-ua-mobile" => array:1 [▶
    0 => "?0"
  ]
  "sec-ch-ua-platform" => array:1 [▶
    0 => ""Windows""
  ]
  "upgrade-insecure-requests" => array:1 [▶
    0 => "1"
  ]
  "user-agent" => array:1 [▶
    0 => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)"
  ]
  "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"
  ]
  "sec-fetch-site" => array:1 [▶
    0 => "none"
  ]
  "sec-fetch-mode" => array:1 [▶
    0 => "navigate"
  ]
  "sec-fetch-user" => array:1 [▶
    0 => "?1"
  ]
  "sec-fetch-dest" => array:1 [▶
    0 => "document"
  ]
  "accept-encoding" => array:1 [▶
    0 => "gzip, deflate, br, zstd"
  ]
]
          request_cookies
          []
          response_headers
            0 of 0   
          array:5 [▼
  "content-type" => array:1 [▶
    0 => "text/html; charset=UTF-8"
  ]
  "cache-control" => array:1 [▶
    0 => "no-cache, private"
  ]
  "date" => array:1 [▶
    0 => "Sun, 22 Jun 2025 17:52:26 GMT"
  ]
  "set-cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6ImZZVHB4Q01wWDdNTno0M01LNUVsUkE9PSIsInZhbHVlIjoiam9XdTQvVTVmVGptSWNpSUNzTDFiSFFFU21ZZWJ4c1VaZXEzRGE3MENlRnJxS0k3MzVYZGhXOWZlcjZTR3FnZWZvUVV1VWVTeUpDaWNIRTZsYXJaUWtMSDFQMGFwVWlwbU5BSXRQcGIzQkNtUmo0RTcwOTNiYXpDb2U3MDdnVWciLCJtYWMiOiIzY2UyZjY5Mjc5ZmJjODg3OTI2YTE3ZGQ3N2U3OTM2NDcyMmQ3ZTM0ZDZlZjM5Yzc2MjhmNDg2MGQ0OGFhNjE5IiwidGFnIjoiIn0%3D; expires=Sun, 22 Jun 2025 19:52:26 GMT; Max-Age=7200; path=/; secure; samesite=lax ◀XSRF-TOKEN=eyJpdiI6ImZZVHB4Q01wWDdNTno0M01LNUVsUkE9PSIsInZhbHVlIjoiam9XdTQvVTVmVGptSWNpSUNzTDFiSFFFU21ZZWJ4c1VaZXEzRGE3MENlRnJxS0k3MzVYZGhXOWZlcjZTR3FnZWZvUVV1V ▶"
    1 => "acprstaging_session=eyJpdiI6IitVTXFGNmlCMnVwZTJTMUp3S2p1UFE9PSIsInZhbHVlIjoiWUMrRXBtNTZweTR0enc1UzliNkUveEdIWU4ybXJBOVdoRVpSUFhzK1psMjFCSm1UbEhaNTFvUytKazdYcGZjVXVYVUJHaTFscUdrNmFidkZRSitsaXIzU2FTd3Y2NThDSUZtRHMyRkZLQjlzRkZaWXo1bmErYUt6NlpBME9FZnAiLCJtYWMiOiIxODM3M2QxNjY5MzM4Nzg3ZjIyYTQyMTgzODU4YTEwOWJiMWM2N2ViOTY1ZDQyNWQzNGJlNTQwOGFlODQ0Njc0IiwidGFnIjoiIn0%3D; expires=Sun, 22 Jun 2025 19:52:26 GMT; Max-Age=7200; path=/; httponly; samesite=lax ◀acprstaging_session=eyJpdiI6IitVTXFGNmlCMnVwZTJTMUp3S2p1UFE9PSIsInZhbHVlIjoiWUMrRXBtNTZweTR0enc1UzliNkUveEdIWU4ybXJBOVdoRVpSUFhzK1psMjFCSm1UbEhaNTFvUytKazdYcGZj ▶"
  ]
  "Set-Cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6ImZZVHB4Q01wWDdNTno0M01LNUVsUkE9PSIsInZhbHVlIjoiam9XdTQvVTVmVGptSWNpSUNzTDFiSFFFU21ZZWJ4c1VaZXEzRGE3MENlRnJxS0k3MzVYZGhXOWZlcjZTR3FnZWZvUVV1VWVTeUpDaWNIRTZsYXJaUWtMSDFQMGFwVWlwbU5BSXRQcGIzQkNtUmo0RTcwOTNiYXpDb2U3MDdnVWciLCJtYWMiOiIzY2UyZjY5Mjc5ZmJjODg3OTI2YTE3ZGQ3N2U3OTM2NDcyMmQ3ZTM0ZDZlZjM5Yzc2MjhmNDg2MGQ0OGFhNjE5IiwidGFnIjoiIn0%3D; expires=Sun, 22-Jun-2025 19:52:26 GMT; path=/; secure ◀XSRF-TOKEN=eyJpdiI6ImZZVHB4Q01wWDdNTno0M01LNUVsUkE9PSIsInZhbHVlIjoiam9XdTQvVTVmVGptSWNpSUNzTDFiSFFFU21ZZWJ4c1VaZXEzRGE3MENlRnJxS0k3MzVYZGhXOWZlcjZTR3FnZWZvUVV1V ▶"
    1 => "acprstaging_session=eyJpdiI6IitVTXFGNmlCMnVwZTJTMUp3S2p1UFE9PSIsInZhbHVlIjoiWUMrRXBtNTZweTR0enc1UzliNkUveEdIWU4ybXJBOVdoRVpSUFhzK1psMjFCSm1UbEhaNTFvUytKazdYcGZjVXVYVUJHaTFscUdrNmFidkZRSitsaXIzU2FTd3Y2NThDSUZtRHMyRkZLQjlzRkZaWXo1bmErYUt6NlpBME9FZnAiLCJtYWMiOiIxODM3M2QxNjY5MzM4Nzg3ZjIyYTQyMTgzODU4YTEwOWJiMWM2N2ViOTY1ZDQyNWQzNGJlNTQwOGFlODQ0Njc0IiwidGFnIjoiIn0%3D; expires=Sun, 22-Jun-2025 19:52:26 GMT; path=/; httponly ◀acprstaging_session=eyJpdiI6IitVTXFGNmlCMnVwZTJTMUp3S2p1UFE9PSIsInZhbHVlIjoiWUMrRXBtNTZweTR0enc1UzliNkUveEdIWU4ybXJBOVdoRVpSUFhzK1psMjFCSm1UbEhaNTFvUytKazdYcGZj ▶"
  ]
]
          session_attributes
            0 of 0   
          array:3 [▼
  "_token" => "aGv3ZaJBVLcWxIjZuBeUutvLg0PFuz2IiiJnMjP0"
  "_previous" => array:1 [▶
    "url" => "https://staging.alwayscpr.com/List_All_Cities_In_CT"
  ]
  "_flash" => array:2 [▶
    "old" => []
    "new" => []
  ]
]
          ClearShow all
          Date ↕MethodURLData
          #12025-06-22 12:52:26GET/List_All_Cities_In_CT51119