Cities That We Service in NE

Messages Timeline Exceptions Views5 Route Queries4 Models5 Mails Gate Session Request

Request history8.3.644.48ms3MBGET List_All_Cities_In_{slug}

Booting (30.58ms)time
Application (13.9ms)time
1 x Booting (68.74%)
30.58ms
1 x Application (31.25%)
13.90ms

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

4 statements were executed (2 duplicates)Show only duplicates3.71ms

SiteMapController.php#28acpr_db_original_staging1.11msselect * from `acpr_states` where `state_code` = 'NE' and `acpr_states`.`deleted_at` is null limit 1

Bindings	0: NE
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_staging860μs

select `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` = 'NE' and `acpr_states`.`deleted_at` is null) and `acpr_locations`.`deleted_at` is null group by `city_lower`

Bindings	0: NE
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_staging1.11msselect * from `acpr_states` where `acpr_states`.`id` = 27 and `acpr_states`.`deleted_at` is null limit 1

Bindings	0: 27
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_staging630μsselect * from `acpr_states` where `acpr_states`.`id` = 27 and `acpr_states`.`deleted_at` is null limit 1

Bindings	0: 27
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: 3State.php#?
App\Models\Location: 2Location.php#?

_token: IV2ielEPfBLRW7s2f5m6Bq3UjgE3LcstwdZ4VHY4
_previous: array:1 [ "url" => "https://staging.alwayscpr.com/List_All_Cities_In_NE" ]
_flash: array:2 [ "old" => [] "new" => [] ]

path_info

/List_All_Cities_In_NE

status_code

status_text

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 => "Mon, 05 May 2025 03:44:38 GMT"
  ]
  "set-cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IlczRjhkaHJyeSt6OXpUN252VmJiYXc9PSIsInZhbHVlIjoiRHlYajlYVFpOTXNYUVRnNW0yUmJNRzNlLytodnJPbHh1ejRVc2ExWi9yWTBuZEJMVGhaNWZabnU5c3BLRSt0MTlOb0xPMStHWFlBVGpDNTNoc29za2VpODFmOWhKTVVoOUhoTUVqb09IUjFDVU5TUHFRU2xqa2ZwdmRLdTg4RlAiLCJtYWMiOiIzN2YyNTIzYmZhMGMxZGNkOTY2YjBlNjZjY2E0MWQ4ZjE1YTMxMGNjZTRhNmIxZWU5YWU5NmUxOThlNzY4MWZkIiwidGFnIjoiIn0%3D; expires=Mon, 05 May 2025 05:44:38 GMT; Max-Age=7200; path=/; secure; samesite=lax ◀XSRF-TOKEN=eyJpdiI6IlczRjhkaHJyeSt6OXpUN252VmJiYXc9PSIsInZhbHVlIjoiRHlYajlYVFpOTXNYUVRnNW0yUmJNRzNlLytodnJPbHh1ejRVc2ExWi9yWTBuZEJMVGhaNWZabnU5c3BLRSt0MTlOb0xPM ▶"
    1 => "acprstaging_session=eyJpdiI6Im0vS2VITFk5TU5yZEZZUWw1MEVFUkE9PSIsInZhbHVlIjoibm4xVDNFOVNXYnhHU090TUVlMlRXYVgyTzZkQVg5NDVLa251M3ZCc3kvRExReG1CSXNYTVBPc2o2Y1FDb0JQUGlYMzR0NER5amJNeG5PTWNucENaOGZRVm9XTkpzRlg1Z0lmTVQ3T1NHT1ZVUkxWamVpMW1aUXBUUW5yTWVSZkgiLCJtYWMiOiJmZjgyOGM1YjIwZTU5OTg5OTNmYTE3NTA3YTg4OWQ4YjNkYzU4YzViMmJjNjkxMzkxY2ViZTNkY2NjNTZiYmJhIiwidGFnIjoiIn0%3D; expires=Mon, 05 May 2025 05:44:38 GMT; Max-Age=7200; path=/; httponly; samesite=lax ◀acprstaging_session=eyJpdiI6Im0vS2VITFk5TU5yZEZZUWw1MEVFUkE9PSIsInZhbHVlIjoibm4xVDNFOVNXYnhHU090TUVlMlRXYVgyTzZkQVg5NDVLa251M3ZCc3kvRExReG1CSXNYTVBPc2o2Y1FDb0JQ ▶"
  ]
  "Set-Cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IlczRjhkaHJyeSt6OXpUN252VmJiYXc9PSIsInZhbHVlIjoiRHlYajlYVFpOTXNYUVRnNW0yUmJNRzNlLytodnJPbHh1ejRVc2ExWi9yWTBuZEJMVGhaNWZabnU5c3BLRSt0MTlOb0xPMStHWFlBVGpDNTNoc29za2VpODFmOWhKTVVoOUhoTUVqb09IUjFDVU5TUHFRU2xqa2ZwdmRLdTg4RlAiLCJtYWMiOiIzN2YyNTIzYmZhMGMxZGNkOTY2YjBlNjZjY2E0MWQ4ZjE1YTMxMGNjZTRhNmIxZWU5YWU5NmUxOThlNzY4MWZkIiwidGFnIjoiIn0%3D; expires=Mon, 05-May-2025 05:44:38 GMT; path=/; secure ◀XSRF-TOKEN=eyJpdiI6IlczRjhkaHJyeSt6OXpUN252VmJiYXc9PSIsInZhbHVlIjoiRHlYajlYVFpOTXNYUVRnNW0yUmJNRzNlLytodnJPbHh1ejRVc2ExWi9yWTBuZEJMVGhaNWZabnU5c3BLRSt0MTlOb0xPM ▶"
    1 => "acprstaging_session=eyJpdiI6Im0vS2VITFk5TU5yZEZZUWw1MEVFUkE9PSIsInZhbHVlIjoibm4xVDNFOVNXYnhHU090TUVlMlRXYVgyTzZkQVg5NDVLa251M3ZCc3kvRExReG1CSXNYTVBPc2o2Y1FDb0JQUGlYMzR0NER5amJNeG5PTWNucENaOGZRVm9XTkpzRlg1Z0lmTVQ3T1NHT1ZVUkxWamVpMW1aUXBUUW5yTWVSZkgiLCJtYWMiOiJmZjgyOGM1YjIwZTU5OTg5OTNmYTE3NTA3YTg4OWQ4YjNkYzU4YzViMmJjNjkxMzkxY2ViZTNkY2NjNTZiYmJhIiwidGFnIjoiIn0%3D; expires=Mon, 05-May-2025 05:44:38 GMT; path=/; httponly ◀acprstaging_session=eyJpdiI6Im0vS2VITFk5TU5yZEZZUWw1MEVFUkE9PSIsInZhbHVlIjoibm4xVDNFOVNXYnhHU090TUVlMlRXYVgyTzZkQVg5NDVLa251M3ZCc3kvRExReG1CSXNYTVBPc2o2Y1FDb0JQ ▶"
  ]
]

session_attributes

  0 of 0   
array:3 [▼
  "_token" => "IV2ielEPfBLRW7s2f5m6Bq3UjgE3LcstwdZ4VHY4"
  "_previous" => array:1 [▶
    "url" => "https://staging.alwayscpr.com/List_All_Cities_In_NE"
  ]
  "_flash" => array:2 [▶
    "old" => []
    "new" => []
  ]
]

AutoshowClear Show all

	Date ↕	Method	URL	Data
#1	2025-05-04 22:44:38	GET	/List_All_Cities_In_NE	5 4 5

1 x Booting (68.74%)	30.58ms
1 x Application (31.25%)	13.90ms

CITIES THAT WE SERVICE IN NE

Oops!

Congratulations!