Messages Request Timeline Exceptions Views4 Queries25 Models379 Livewire0 Mails Gate

Settings Request history1.92s3MB11.xGET senior-resources/{slug}

status

200 OK

full_url

https://seniorsbluebook.com/senior-resources/san-francisco-general-hospital-san-francisco-ca

action_name

senior-resources-listing-view

controller_action

App\Http\Controllers\Front\ListingController@listingData

uri

GET senior-resources/{slug}

controller

App\Http\Controllers\Front\ListingController@listingData

namespace

App\Http\Controllers

file

app/Http/Controllers/Front/ListingController.php:587-719

middleware

web

duration

1.92s

peak_memory

6MB

response

text/html; charset=UTF-8

request_format

html

request_query

[]

request_request

[]

request_headers

  0 of 0   
array:17 [▼
  "host" => array:1 [▶
    0 => "seniorsbluebook.com"
  ]
  "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"
  ]
  "x-forwarded-for" => array:1 [▶
    0 => "216.73.216.211"
  ]
  "x-forwarded-proto" => array:1 [▶
    0 => "https"
  ]
  "x-forwarded-port" => array:1 [▶
    0 => "443"
  ]
]

request_cookies

[]

response_headers

  0 of 0   
array:3 [▼
  "content-type" => array:1 [▶
    0 => "text/html; charset=UTF-8"
  ]
  "cache-control" => array:1 [▶
    0 => "no-cache, private"
  ]
  "date" => array:1 [▶
    0 => "Sun, 06 Jul 2025 04:51:04 GMT"
  ]
]

session_attributes

  0 of 0   
array:1 [▼
  "_token" => "Y1zUnwgBqISPbWjbDwzRNzZXr1m3BICE43tDU6Tb"
]

Booting (40.15ms)time
Application (1.88s)time
Routing (658μs)
Preparing Response (40.39ms)
View: front.listing-viewviews
View: layouts.front.frontviews
View: layouts.front.headerviews
View: layouts.front.footerviews
1 x Application (97.91%)
1.88s
1 x Preparing Response (2.1%)
40.39ms
1 x Booting (2.09%)
40.15ms
1 x Routing (0.03%)
658μs
4 x View (0%)
0μs

4 templates were rendered

front.listing-viewlisting-view.blade.php#?blade
layouts.front.frontfront.blade.php#?blade
layouts.front.headerheader.blade.php#?blade
layouts.front.footerfooter.blade.php#?blade

25 statements were executed1.83s

SessionManager.php#108seniorsbb_db_devConnection Established

Backtrace

vendor/laravel/framework/src/Illuminate/Session/SessionManager.php:108
vendor/laravel/framework/src/Illuminate/Session/SessionManager.php:95
vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php:159
vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php:57
vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:209

DatabaseSessionHandler.php#97seniorsbb_db_dev4.41msselect * from `sessions` where `id` = 'seb3tyG5lXTXkW3Vuo4pCtOMlVlmCFlJb5fWiB67' limit 1

Bindings	0: seb3tyG5lXTXkW3Vuo4pCtOMlVlmCFlJb5fWiB67
Backtrace	vendor/laravel/framework/src/Illuminate/Session/DatabaseSessionHandler.php:97 vendor/laravel/framework/src/Illuminate/Session/Store.php:117 vendor/laravel/framework/src/Illuminate/Session/Store.php:105 vendor/laravel/framework/src/Illuminate/Session/Store.php:89 vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php:147

ListingController.php#590seniorsbb_db_dev310ms

select * from `listings` where `slug` = 'san-francisco-general-hospital-san-francisco-ca' and `listings`.`deleted_at` is null limit 1

Bindings	0: san-francisco-general-hospital-san-francisco-ca
Backtrace	app/Http/Controllers/Front/ListingController.php:590 vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:44 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266 vendor/laravel/framework/src/Illuminate/Routing/Route.php:212

ListingController.php#610seniorsbb_db_dev1.76msselect * from `listingattachment` where `listingId` = 98751 and `type` = 'listing' and `image_type` LIKE '%image%'

Bindings	0: 98751 1: listing 2: %image%
Backtrace	app/Http/Controllers/Front/ListingController.php:610 vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:44 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266 vendor/laravel/framework/src/Illuminate/Routing/Route.php:212

ListingController.php#611seniorsbb_db_dev1.89msselect * from `listingattachment` where `listingId` = 98751 and `type` = 'listing' and `image_type` NOT LIKE '%image%'

Bindings	0: 98751 1: listing 2: %image%
Backtrace	app/Http/Controllers/Front/ListingController.php:611 vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:44 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266 vendor/laravel/framework/src/Illuminate/Routing/Route.php:212

ListingController.php#613seniorsbb_db_dev1.44msselect * from `categorymapping`

Backtrace

app/Http/Controllers/Front/ListingController.php:613
vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:44
vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
vendor/laravel/framework/src/Illuminate/Routing/Route.php:212

ListingController.php#620seniorsbb_db_dev4.11msselect * from `category` where `type` = 'listing'

Bindings	0: listing
Backtrace	app/Http/Controllers/Front/ListingController.php:620 vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:44 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266 vendor/laravel/framework/src/Illuminate/Routing/Route.php:212

ListingController.php#625seniorsbb_db_dev74.33msselect * from `housing_ash` where `listingId` = 98751 limit 1

Bindings	0: 98751
Backtrace	app/Http/Controllers/Front/ListingController.php:625 vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:44 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266 vendor/laravel/framework/src/Illuminate/Routing/Route.php:212

ListingController.php#626seniorsbb_db_dev92.8msselect * from `housing_al` where `listingId` = 98751 limit 1

Bindings	0: 98751
Backtrace	app/Http/Controllers/Front/ListingController.php:626 vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:44 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266 vendor/laravel/framework/src/Illuminate/Routing/Route.php:212

ListingController.php#627seniorsbb_db_dev85.93msselect * from `housing_sn` where `listingId` = 98751 limit 1

Bindings	0: 98751
Backtrace	app/Http/Controllers/Front/ListingController.php:627 vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:44 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266 vendor/laravel/framework/src/Illuminate/Routing/Route.php:212

ListingController.php#628seniorsbb_db_dev86.46msselect * from `housing_mc` where `listingId` = 98751 limit 1

Bindings	0: 98751
Backtrace	app/Http/Controllers/Front/ListingController.php:628 vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:44 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266 vendor/laravel/framework/src/Illuminate/Routing/Route.php:212

ListingController.php#629seniorsbb_db_dev69.64msselect * from `housing_hot` where `listingId` = 98751 limit 1

Bindings	0: 98751
Backtrace	app/Http/Controllers/Front/ListingController.php:629 vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:44 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266 vendor/laravel/framework/src/Illuminate/Routing/Route.php:212

ListingController.php#630seniorsbb_db_dev88.02msselect * from `housing_il` where `listingId` = 98751 limit 1

Bindings	0: 98751
Backtrace	app/Http/Controllers/Front/ListingController.php:630 vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:44 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266 vendor/laravel/framework/src/Illuminate/Routing/Route.php:212

ListingController.php#631seniorsbb_db_dev46.44msselect * from `housing_nmhc` where `listingId` = 98751 limit 1

Bindings	0: 98751
Backtrace	app/Http/Controllers/Front/ListingController.php:631 vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:44 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266 vendor/laravel/framework/src/Illuminate/Routing/Route.php:212

ListingController.php#666seniorsbb_db_dev529ms

select * from `listings` where `company` = 21233 and `active` = 'Yes' and `id` != 98751 and `listings`.`deleted_at` is null order by RAND() limit 4

Bindings	0: 21233 1: Yes 2: 98751
Backtrace	app/Http/Controllers/Front/ListingController.php:666 vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:44 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266 vendor/laravel/framework/src/Illuminate/Routing/Route.php:212

ListingController.php#666seniorsbb_db_dev1.78ms

select * from `listingattachment` where `type` = 'listing' and `primary` = 1 and `listingattachment`.`listingId` in (18027)

Bindings	0: listing 1: 1
Backtrace	app/Http/Controllers/Front/ListingController.php:666 vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:44 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266 vendor/laravel/framework/src/Illuminate/Routing/Route.php:212

DatabaseQueue.php#188seniorsbb_db_dev3.28ms

insert into `queue_jobs` (`queue`, `attempts`, `reserved_at`, `available_at`, `created_at`, `payload`) values ('statsqueue', 0, null, 1751777464, 1751777464, '{\"uuid\":\"6da2e069-9e83-4c31-83ed-fcecd13ddc94\",\"displayName\":\"App\\\\Jobs\\\\TrackUsers\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"App\\\\Jobs\\\\TrackUsers\",\"command\":\"O:19:\\\"App\\\\Jobs\\\\TrackUsers\\\":6:{s:13:\\\"\\u0000*\\u0000track_data\\\";O:45:\\\"Illuminate\\\\Contracts\\\\Database\\\\ModelIdentifier\\\":5:{s:5:\\\"class\\\";s:18:\\\"App\\\\Models\\\\Listing\\\";s:2:\\\"id\\\";a:1:{i:0;i:18027;}s:9:\\\"relations\\\";a:1:{i:0;s:24:\\\"listingattachmentprimary\\\";}s:10:\\\"connection\\\";s:5:\\\"mysql\\\";s:15:\\\"collectionClass\\\";N;}s:13:\\\"\\u0000*\\u0000usercookie\\\";s:18:\\\"us734trb76et634tbr\\\";s:12:\\\"\\u0000*\\u0000dataModel\\\";s:7:\\\"listing\\\";s:11:\\\"\\u0000*\\u0000dataType\\\";s:6:\\\"appear\\\";s:16:\\\"\\u0000*\\u0000inputDataType\\\";s:4:\\\"data\\\";s:5:\\\"queue\\\";s:10:\\\"statsqueue\\\";}\"}}')

Bindings

0: statsqueue
1: 0
2:
3: 1751777464
4: 1751777464
5: {"uuid":"6da2e069-9e83-4c31-83ed-fcecd13ddc94","displayName":"App\\Jobs\\TrackUsers","job":"Illuminate\\Queue\\CallQueuedHandler@call","maxTries":null,"maxExceptions":null,"failOnTimeout":false,"backoff":null,"timeout":null,"retryUntil":null,"data":{"commandName":"App\\Jobs\\TrackUsers","command":"O:19:\"App\\Jobs\\TrackUsers\":6:{s:13:\"\u0000*\u0000track_data\";O:45:\"Illuminate\\Contracts\\Database\\ModelIdentifier\":5:{s:5:\"class\";s:18:\"App\\Models\\Listing\";s:2:\"id\";a:1:{i:0;i:18027;}s:9:\"relations\";a:1:{i:0;s:24:\"listingattachmentprimary\";}s:10:\"connection\";s:5:\"mysql\";s:15:\"collectionClass\";N;}s:13:\"\u0000*\u0000usercookie\";s:18:\"us734trb76et634tbr\";s:12:\"\u0000*\u0000dataModel\";s:7:\"listing\";s:11:\"\u0000*\u0000dataType\";s:6:\"appear\";s:16:\"\u0000*\u0000inputDataType\";s:4:\"data\";s:5:\"queue\";s:10:\"statsqueue\";}"}}

Backtrace

vendor/laravel/framework/src/Illuminate/Queue/DatabaseQueue.php:188
vendor/laravel/framework/src/Illuminate/Queue/DatabaseQueue.php:99
vendor/laravel/framework/src/Illuminate/Queue/Queue.php:338
vendor/laravel/framework/src/Illuminate/Queue/DatabaseQueue.php:93
vendor/laravel/framework/src/Illuminate/Bus/Dispatcher.php:244

ListingController.php#701seniorsbb_db_dev184ms

select `company`.`id` as `parentId`, `child`.`id` as `childId` from `company` left join `company` as `child` on `child`.`parentCompany` = `company`.`id` where `company`.`parentCompany` = 21233 and `company`.`deleted_at` is null

Bindings	0: 21233
Backtrace	app/Http/Controllers/Front/ListingController.php:701 vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:44 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266 vendor/laravel/framework/src/Illuminate/Routing/Route.php:212

ListingController.php#715seniorsbb_db_dev217ms

select * from `articles` where `active` = 'Yes' and `type` = 'article' and `company` in (21233) and `articles`.`deleted_at` is null order by RAND()

Bindings	0: Yes 1: article 2: 21233
Backtrace	app/Http/Controllers/Front/ListingController.php:715 vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:44 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266 vendor/laravel/framework/src/Illuminate/Routing/Route.php:212

2ab192da2a90a9a8fa8f15d882cc1820.php#34seniorsbb_db_dev19.84ms

select * from `listing_servicearea` where `listing_servicearea`.`listingId` = 98751 and `listing_servicearea`.`listingId` is not null

Bindings	0: 98751
Backtrace	var/www/html/sbb/shared/storage/framework/views/2ab192da2a90a9a8fa8f15d882cc1820.php:34 vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124 vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 vendor/livewire/livewire/src/Mechanisms/ExtendBlade/ExtendedCompilerEngine.php:22 vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:75

2ab192da2a90a9a8fa8f15d882cc1820.php#88seniorsbb_db_dev1.37ms

select * from `listingattachment` where `listingattachment`.`listingId` = 98751 and `listingattachment`.`listingId` is not null and `type` = 'listing' and `primary` = 1 limit 1

Bindings	0: 98751 1: listing 2: 1
Backtrace	var/www/html/sbb/shared/storage/framework/views/2ab192da2a90a9a8fa8f15d882cc1820.php:88 vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124 vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 vendor/livewire/livewire/src/Mechanisms/ExtendBlade/ExtendedCompilerEngine.php:22 vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:75

2ab192da2a90a9a8fa8f15d882cc1820.php#104seniorsbb_db_dev1.25msselect * from `packages` where `packages`.`id` = 4 limit 1

Bindings	0: 4
Backtrace	var/www/html/sbb/shared/storage/framework/views/2ab192da2a90a9a8fa8f15d882cc1820.php:104 vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124 vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 vendor/livewire/livewire/src/Mechanisms/ExtendBlade/ExtendedCompilerEngine.php:22 vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:75

2ab192da2a90a9a8fa8f15d882cc1820.php#587seniorsbb_db_dev1.17msselect * from `categorymapping` where `categorymapping`.`slug` = 'SN' and `categorymapping`.`slug` is not null limit 1

Bindings	0: SN
Backtrace	var/www/html/sbb/shared/storage/framework/views/2ab192da2a90a9a8fa8f15d882cc1820.php:587 vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124 vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 vendor/livewire/livewire/src/Mechanisms/ExtendBlade/ExtendedCompilerEngine.php:22 vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:75

2ab192da2a90a9a8fa8f15d882cc1820.php#590seniorsbb_db_dev1.15msselect * from `category` where `category`.`id` = 'SN' and `category`.`id` is not null limit 1

Bindings	0: SN
Backtrace	var/www/html/sbb/shared/storage/framework/views/2ab192da2a90a9a8fa8f15d882cc1820.php:590 vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124 vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 vendor/livewire/livewire/src/Mechanisms/ExtendBlade/ExtendedCompilerEngine.php:22 vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:75

2ab192da2a90a9a8fa8f15d882cc1820.php#658seniorsbb_db_dev1.26ms

select * from `listingcontacts` where `listingcontacts`.`listingId` = 98751 and `listingcontacts`.`listingId` is not null and `type` = 'listing'

Bindings	0: 98751 1: listing
Backtrace	var/www/html/sbb/shared/storage/framework/views/2ab192da2a90a9a8fa8f15d882cc1820.php:658 vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124 vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 vendor/livewire/livewire/src/Mechanisms/ExtendBlade/ExtendedCompilerEngine.php:22 vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:75

6162bf581736fa7f4e9b70a52a1034b4.php#2seniorsbb_db_dev1.6msselect * from `articles` where `articles`.`deleted_at` is null order by `id` desc limit 3

Backtrace

var/www/html/sbb/shared/storage/framework/views/6162bf581736fa7f4e9b70a52a1034b4.php:2
vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
vendor/livewire/livewire/src/Mechanisms/ExtendBlade/ExtendedCompilerEngine.php:22
vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:75

App\Models\Category: 361Category.php#?
App\Models\CategoryMapping: 12CategoryMapping.php#?
App\Models\Article: 3Article.php#?
App\Models\Listing: 2Listing.php#?
App\Models\Packages: 1Packages.php#?

AutoshowClear Show all

	Date ↕	Method	URL	Data
#1	2025-07-05 22:51:04	GET	/senior-resources/san-francisco-general-hospital-san-francisco-ca	4 25 379

San Francisco General Hospital

PHONE

Email US

See More

Additional Services Offered

San Francisco General Hospital Skilled Nursing Facility

Claim This Business Listing

Contact This Service

Continue Your Search! Explore More Local Options.

Let’s engage and get educated!

Map View of San Francisco General Hospital

Explore Our Many Options

1 x Application (97.91%)	1.88s
1 x Preparing Response (2.1%)	40.39ms
1 x Booting (2.09%)	40.15ms
1 x Routing (0.03%)	658μs
4 x View (0%)	0μs