Cities That We Service in RI

Messages Timeline Exceptions Views5 Route Queries3 Models3 Mails Gate Session Request

Request history8.3.654.65ms3MBGET List_All_Cities_In_{slug}

Booting (36.42ms)time
Application (18.23ms)time
1 x Booting (66.64%)
36.42ms
1 x Application (33.35%)
18.23ms

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

3 statements were executed3.83ms

SiteMapController.php#28acpr_db_original_staging640μsselect * from `acpr_states` where `state_code` = 'RI' and `acpr_states`.`deleted_at` is null limit 1

Bindings	0: RI
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_staging2.28ms

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

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

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

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

path_info

/List_All_Cities_In_RI

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 => "Sat, 03 May 2025 07:36:19 GMT"
  ]
  "set-cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6Ilh3VXorNDFsN1FyMUZXSmpTNjRONFE9PSIsInZhbHVlIjoibzJHR0ttM28yOW1NYWYvN1I0c2Q2T0ppa016MG9zSmVIZUtpSk8ybVQrRCt5bW5waUM2VXRhTllISklLbWVwUm5VelV6KzlKYXJCL0ZNcFRWSzI2eEJjVG52bGliY3dKWWNmcmtYMStOQmNDRkhSMUZJazVDYyswdlFYc3lQdFYiLCJtYWMiOiIxMDkyMTk2NWUxMDg2ZWY2YWQ5M2VkMTcwYmIxYWExNmFlNzc1YWU2MjFhNmI3ZjMyMTBlODczNDRhN2E1Njk2IiwidGFnIjoiIn0%3D; expires=Sat, 03 May 2025 09:36:19 GMT; Max-Age=7200; path=/; secure; samesite=lax ◀XSRF-TOKEN=eyJpdiI6Ilh3VXorNDFsN1FyMUZXSmpTNjRONFE9PSIsInZhbHVlIjoibzJHR0ttM28yOW1NYWYvN1I0c2Q2T0ppa016MG9zSmVIZUtpSk8ybVQrRCt5bW5waUM2VXRhTllISklLbWVwUm5VelV6K ▶"
    1 => "acprstaging_session=eyJpdiI6Impod201SWlJT2VpcG44OFNjMXIzelE9PSIsInZhbHVlIjoiRVpLS2JpcTc5WjBrS2h5YS93V0QyUkFnUHd4cXJ6UURkMHE0Znl3cHhjZkJLQVE3ZlZJSnR4VUdSQXlCZUtVV01aNFFEN2lGOWM1K21SY01TREVyOEFvS2YwS3grWFZ2N3I2OVJGTWFzWklDYVcrdzkxa29XQlNEZHp2MVJ6QmciLCJtYWMiOiIxMjQwNjBlZDQ2OTNkMGFjNzg4ZTMxM2M1MjM1NmExNGU5NjlhOWMzYmE2ZTIyZDJkOTdjZGNiZDA4MTU3NTg1IiwidGFnIjoiIn0%3D; expires=Sat, 03 May 2025 09:36:19 GMT; Max-Age=7200; path=/; httponly; samesite=lax ◀acprstaging_session=eyJpdiI6Impod201SWlJT2VpcG44OFNjMXIzelE9PSIsInZhbHVlIjoiRVpLS2JpcTc5WjBrS2h5YS93V0QyUkFnUHd4cXJ6UURkMHE0Znl3cHhjZkJLQVE3ZlZJSnR4VUdSQXlCZUtV ▶"
  ]
  "Set-Cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6Ilh3VXorNDFsN1FyMUZXSmpTNjRONFE9PSIsInZhbHVlIjoibzJHR0ttM28yOW1NYWYvN1I0c2Q2T0ppa016MG9zSmVIZUtpSk8ybVQrRCt5bW5waUM2VXRhTllISklLbWVwUm5VelV6KzlKYXJCL0ZNcFRWSzI2eEJjVG52bGliY3dKWWNmcmtYMStOQmNDRkhSMUZJazVDYyswdlFYc3lQdFYiLCJtYWMiOiIxMDkyMTk2NWUxMDg2ZWY2YWQ5M2VkMTcwYmIxYWExNmFlNzc1YWU2MjFhNmI3ZjMyMTBlODczNDRhN2E1Njk2IiwidGFnIjoiIn0%3D; expires=Sat, 03-May-2025 09:36:19 GMT; path=/; secure ◀XSRF-TOKEN=eyJpdiI6Ilh3VXorNDFsN1FyMUZXSmpTNjRONFE9PSIsInZhbHVlIjoibzJHR0ttM28yOW1NYWYvN1I0c2Q2T0ppa016MG9zSmVIZUtpSk8ybVQrRCt5bW5waUM2VXRhTllISklLbWVwUm5VelV6K ▶"
    1 => "acprstaging_session=eyJpdiI6Impod201SWlJT2VpcG44OFNjMXIzelE9PSIsInZhbHVlIjoiRVpLS2JpcTc5WjBrS2h5YS93V0QyUkFnUHd4cXJ6UURkMHE0Znl3cHhjZkJLQVE3ZlZJSnR4VUdSQXlCZUtVV01aNFFEN2lGOWM1K21SY01TREVyOEFvS2YwS3grWFZ2N3I2OVJGTWFzWklDYVcrdzkxa29XQlNEZHp2MVJ6QmciLCJtYWMiOiIxMjQwNjBlZDQ2OTNkMGFjNzg4ZTMxM2M1MjM1NmExNGU5NjlhOWMzYmE2ZTIyZDJkOTdjZGNiZDA4MTU3NTg1IiwidGFnIjoiIn0%3D; expires=Sat, 03-May-2025 09:36:19 GMT; path=/; httponly ◀acprstaging_session=eyJpdiI6Impod201SWlJT2VpcG44OFNjMXIzelE9PSIsInZhbHVlIjoiRVpLS2JpcTc5WjBrS2h5YS93V0QyUkFnUHd4cXJ6UURkMHE0Znl3cHhjZkJLQVE3ZlZJSnR4VUdSQXlCZUtV ▶"
  ]
]

session_attributes

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

AutoshowClear Show all

	Date ↕	Method	URL	Data
#1	2025-05-03 02:36:19	GET	/List_All_Cities_In_RI	5 3 3

1 x Booting (66.64%)	36.42ms
1 x Application (33.35%)	18.23ms

CITIES THAT WE SERVICE IN RI

Oops!

Congratulations!