CITIES THAT WE SERVICE IN SC

Aiken
Anderson
Clinton
Columbia
Duncan
Fairfax
Ft Mill
Gaffney
Georgetown
Greenville
Greenvillke
Greer
Inman
Laurens
Lexington
Mauldin
Myrtle Beach
Orangeburg
Simpsonville
Spartanburg
TR
MessagesTimelineExceptionsViews5RouteQueries23Models43MailsGateSessionRequest
Request history8.3.6PHP Version86.68msRequest Duration3MBMemory UsageGET List_All_Cities_In_{slug}Route
    • Booting (40.69ms)time
    • Application (45.99ms)time
    • 1 x Application (53.05%)
      45.99ms
      1 x Booting (46.94%)
      40.69ms
      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
      23 statements were executed (21 duplicates)Show only duplicates21.06ms
      • SiteMapController.php#28acpr_db_original_staging810μsselect * from `acpr_states` where `state_code` = 'SC' and `acpr_states`.`deleted_at` is null limit 1
        Bindings
        • 0: SC
        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.58msselect `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` = 'SC' and `acpr_states`.`deleted_at` is null) and `acpr_locations`.`deleted_at` is null group by `city_lower`
        Bindings
        • 0: SC
        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_staging690μsselect * from `acpr_states` where `acpr_states`.`id` = 40 and `acpr_states`.`deleted_at` is null limit 1
        Bindings
        • 0: 40
        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_staging620μsselect * from `acpr_states` where `acpr_states`.`id` = 40 and `acpr_states`.`deleted_at` is null limit 1
        Bindings
        • 0: 40
        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_staging580μsselect * from `acpr_states` where `acpr_states`.`id` = 40 and `acpr_states`.`deleted_at` is null limit 1
        Bindings
        • 0: 40
        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` = 40 and `acpr_states`.`deleted_at` is null limit 1
        Bindings
        • 0: 40
        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_staging430μsselect * from `acpr_states` where `acpr_states`.`id` = 40 and `acpr_states`.`deleted_at` is null limit 1
        Bindings
        • 0: 40
        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_staging920μsselect * from `acpr_states` where `acpr_states`.`id` = 40 and `acpr_states`.`deleted_at` is null limit 1
        Bindings
        • 0: 40
        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_staging470μsselect * from `acpr_states` where `acpr_states`.`id` = 40 and `acpr_states`.`deleted_at` is null limit 1
        Bindings
        • 0: 40
        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_staging880μsselect * from `acpr_states` where `acpr_states`.`id` = 40 and `acpr_states`.`deleted_at` is null limit 1
        Bindings
        • 0: 40
        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_staging1.66msselect * from `acpr_states` where `acpr_states`.`id` = 40 and `acpr_states`.`deleted_at` is null limit 1
        Bindings
        • 0: 40
        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` = 40 and `acpr_states`.`deleted_at` is null limit 1
        Bindings
        • 0: 40
        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` = 40 and `acpr_states`.`deleted_at` is null limit 1
        Bindings
        • 0: 40
        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_staging1.11msselect * from `acpr_states` where `acpr_states`.`id` = 40 and `acpr_states`.`deleted_at` is null limit 1
        Bindings
        • 0: 40
        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_staging1.2msselect * from `acpr_states` where `acpr_states`.`id` = 40 and `acpr_states`.`deleted_at` is null limit 1
        Bindings
        • 0: 40
        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_staging1.72msselect * from `acpr_states` where `acpr_states`.`id` = 40 and `acpr_states`.`deleted_at` is null limit 1
        Bindings
        • 0: 40
        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_staging1.14msselect * from `acpr_states` where `acpr_states`.`id` = 40 and `acpr_states`.`deleted_at` is null limit 1
        Bindings
        • 0: 40
        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_staging2.9msselect * from `acpr_states` where `acpr_states`.`id` = 40 and `acpr_states`.`deleted_at` is null limit 1
        Bindings
        • 0: 40
        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_staging750μsselect * from `acpr_states` where `acpr_states`.`id` = 40 and `acpr_states`.`deleted_at` is null limit 1
        Bindings
        • 0: 40
        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_staging740μsselect * from `acpr_states` where `acpr_states`.`id` = 40 and `acpr_states`.`deleted_at` is null limit 1
        Bindings
        • 0: 40
        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_staging470μsselect * from `acpr_states` where `acpr_states`.`id` = 40 and `acpr_states`.`deleted_at` is null limit 1
        Bindings
        • 0: 40
        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_staging470μsselect * from `acpr_states` where `acpr_states`.`id` = 40 and `acpr_states`.`deleted_at` is null limit 1
        Bindings
        • 0: 40
        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_staging460μsselect * from `acpr_states` where `acpr_states`.`id` = 40 and `acpr_states`.`deleted_at` is null limit 1
        Bindings
        • 0: 40
        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
      22State.php#?
      App\Models\Location
      21Location.php#?
          _token
          cxMHi5xWO0iYLtMIMFG2ceAwNevwnWSjDjJXWsez
          _previous
          array:1 [ "url" => "https://staging.alwayscpr.com/List_All_Cities_In_SC" ]
          _flash
          array:2 [ "old" => [] "new" => [] ]
          path_info
          /List_All_Cities_In_SC
          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 => "Tue, 06 May 2025 02:57:04 GMT"
  ]
  "set-cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IjVuQ1hvcktUb2V5cGdWNDU3REtsZFE9PSIsInZhbHVlIjoiR1pFb2Z0YUZ3RU92Zlg5OTVsMDh3b2tJVkMva1A0RWxvaHBOQk1CYllpaFkramZWdThLb2U2TmNSUGQ5Q1FLVzBDRWlFb2ZLTEw2UXN4U29EclNKU2h3R3pib3RKQm54N0d6L0xHVmRaZHRKMHcrdWVjRDNQL1VDcVBLOHE2K0giLCJtYWMiOiIwYzJkYzJiNDIyMjM3ZTk1MTA2YmE5ZTI0M2UzNzkzNTVmMzM1ZTA1ZWU4N2MyY2IyYzM3ZjM2MmYxNjQ4MmYwIiwidGFnIjoiIn0%3D; expires=Tue, 06 May 2025 04:57:04 GMT; Max-Age=7200; path=/; secure; samesite=lax ◀XSRF-TOKEN=eyJpdiI6IjVuQ1hvcktUb2V5cGdWNDU3REtsZFE9PSIsInZhbHVlIjoiR1pFb2Z0YUZ3RU92Zlg5OTVsMDh3b2tJVkMva1A0RWxvaHBOQk1CYllpaFkramZWdThLb2U2TmNSUGQ5Q1FLVzBDRWlFb ▶"
    1 => "acprstaging_session=eyJpdiI6IlVKRHZSVU9mMkx4YW1pMURiMGZSTWc9PSIsInZhbHVlIjoiWExBT0VFTml3YWxha2UyYlQzaG85SjJ2MExzWGxQZjZ2QUp1eHZsS0o3OXp6dkoxNE5QNmZER3JGQ0lyVVhIMGkzbHlMenBpclRGM2xjUW1taEFWSDFtRVpYQXB2OXZpR1NPT3o0LzZLWk8yMEtKaXh2U0dyK0ZFcmNvNjE5bjgiLCJtYWMiOiI5NTg0YmQ0NDk5MDc2N2ZiNzQzZTdiYTljMTI5MjUxNmFkNzJlMTNhN2UwNjA1NTZiODg0NDczNTExNjJhYjI2IiwidGFnIjoiIn0%3D; expires=Tue, 06 May 2025 04:57:04 GMT; Max-Age=7200; path=/; httponly; samesite=lax ◀acprstaging_session=eyJpdiI6IlVKRHZSVU9mMkx4YW1pMURiMGZSTWc9PSIsInZhbHVlIjoiWExBT0VFTml3YWxha2UyYlQzaG85SjJ2MExzWGxQZjZ2QUp1eHZsS0o3OXp6dkoxNE5QNmZER3JGQ0lyVVhI ▶"
  ]
  "Set-Cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IjVuQ1hvcktUb2V5cGdWNDU3REtsZFE9PSIsInZhbHVlIjoiR1pFb2Z0YUZ3RU92Zlg5OTVsMDh3b2tJVkMva1A0RWxvaHBOQk1CYllpaFkramZWdThLb2U2TmNSUGQ5Q1FLVzBDRWlFb2ZLTEw2UXN4U29EclNKU2h3R3pib3RKQm54N0d6L0xHVmRaZHRKMHcrdWVjRDNQL1VDcVBLOHE2K0giLCJtYWMiOiIwYzJkYzJiNDIyMjM3ZTk1MTA2YmE5ZTI0M2UzNzkzNTVmMzM1ZTA1ZWU4N2MyY2IyYzM3ZjM2MmYxNjQ4MmYwIiwidGFnIjoiIn0%3D; expires=Tue, 06-May-2025 04:57:04 GMT; path=/; secure ◀XSRF-TOKEN=eyJpdiI6IjVuQ1hvcktUb2V5cGdWNDU3REtsZFE9PSIsInZhbHVlIjoiR1pFb2Z0YUZ3RU92Zlg5OTVsMDh3b2tJVkMva1A0RWxvaHBOQk1CYllpaFkramZWdThLb2U2TmNSUGQ5Q1FLVzBDRWlFb ▶"
    1 => "acprstaging_session=eyJpdiI6IlVKRHZSVU9mMkx4YW1pMURiMGZSTWc9PSIsInZhbHVlIjoiWExBT0VFTml3YWxha2UyYlQzaG85SjJ2MExzWGxQZjZ2QUp1eHZsS0o3OXp6dkoxNE5QNmZER3JGQ0lyVVhIMGkzbHlMenBpclRGM2xjUW1taEFWSDFtRVpYQXB2OXZpR1NPT3o0LzZLWk8yMEtKaXh2U0dyK0ZFcmNvNjE5bjgiLCJtYWMiOiI5NTg0YmQ0NDk5MDc2N2ZiNzQzZTdiYTljMTI5MjUxNmFkNzJlMTNhN2UwNjA1NTZiODg0NDczNTExNjJhYjI2IiwidGFnIjoiIn0%3D; expires=Tue, 06-May-2025 04:57:04 GMT; path=/; httponly ◀acprstaging_session=eyJpdiI6IlVKRHZSVU9mMkx4YW1pMURiMGZSTWc9PSIsInZhbHVlIjoiWExBT0VFTml3YWxha2UyYlQzaG85SjJ2MExzWGxQZjZ2QUp1eHZsS0o3OXp6dkoxNE5QNmZER3JGQ0lyVVhI ▶"
  ]
]
          session_attributes
            0 of 0   
          array:3 [▼
  "_token" => "cxMHi5xWO0iYLtMIMFG2ceAwNevwnWSjDjJXWsez"
  "_previous" => array:1 [▶
    "url" => "https://staging.alwayscpr.com/List_All_Cities_In_SC"
  ]
  "_flash" => array:2 [▶
    "old" => []
    "new" => []
  ]
]
          ClearShow all
          Date ↕MethodURLData
          #12025-05-05 21:57:04GET/List_All_Cities_In_SC52343