PrimodishNew

Messages Request Timeline Exceptions Views21 Queries17 Models11 Livewire0 Mails Gate

Settings Request history119ms5MB10.xGET visitors-lists/{visitors_list}

status

200 OK

full_url

https://primodishnew.webmavens.com/visitors-lists/1078?sortby=distance

action_name

visitors-lists.show

controller_action

App\Http\Controllers\VisitorsListController@show

uri

GET visitors-lists/{visitors_list}

controller

App\Http\Controllers\VisitorsListController@show

namespace

App\Http\Controllers

file

app/Http/Controllers/VisitorsListController.php:98-232

middleware

web

duration

120ms

peak_memory

6MB

response

text/html; charset=UTF-8

request_format

html

request_query

  0 of 0   
array:1 [▼
  "sortby" => "distance"
]

request_request

[]

request_headers

  0 of 0   
array:15 [▼
  "priority" => array:1 [▶
    0 => "u=0, i"
  ]
  "accept-encoding" => array:1 [▶
    0 => "gzip, deflate, br, zstd"
  ]
  "sec-fetch-dest" => array:1 [▶
    0 => "document"
  ]
  "sec-fetch-user" => array:1 [▶
    0 => "?1"
  ]
  "sec-fetch-mode" => array:1 [▶
    0 => "navigate"
  ]
  "sec-fetch-site" => array:1 [▶
    0 => "none"
  ]
  "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"
  ]
  "user-agent" => array:1 [▶
    0 => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)"
  ]
  "upgrade-insecure-requests" => array:1 [▶
    0 => "1"
  ]
  "sec-ch-ua-platform" => array:1 [▶
    0 => ""Windows""
  ]
  "sec-ch-ua-mobile" => array:1 [▶
    0 => "?0"
  ]
  "sec-ch-ua" => array:1 [▶
    0 => ""Chromium";v="130", "HeadlessChrome";v="130", "Not?A_Brand";v="99""
  ]
  "cache-control" => array:1 [▶
    0 => "no-cache"
  ]
  "pragma" => array:1 [▶
    0 => "no-cache"
  ]
  "host" => array:1 [▶
    0 => "primodishnew.webmavens.com"
  ]
]

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 => "Tue, 10 Jun 2025 10:46:56 GMT"
  ]
]

session_attributes

  0 of 0   
array:5 [▼
  "_token" => "pEGdC1kMs3anUkg9VHWVvh966HgxIMQ8OpUt8UHd"
  "lastActivityTime" => 1749552416
  "Latitude" => "30.26715"
  "Longitude" => "-97.74306"
  "formatted_address" => "Austin, TX, USA"
]

Booting (22.88ms)time
Application (96.31ms)time
Routing (2.18ms)
Preparing Response (80.46ms)
View: visitors-listviews
View: partials.profileHeaderviews
View: partials.establishmentlistingviews
View: partials.popup_login_buttonviews
View: partials.popup_login_buttonviews
View: partials.popup_login_buttonviews
View: pagination::tailwindviews
View: layouts.masterviews
View: partials.popup_login_buttonviews
View: partials.popup_login_buttonviews
View: partials.popup_login_buttonviews
View: partials.popup_login_buttonviews
View: partials.popup_login_buttonviews
View: partials.popup_login_buttonviews
View: partials.popup_login_buttonviews
View: partials.popup_login_buttonviews
View: partials.popup_login_buttonviews
View: partials.popup_login_buttonviews
View: partials.popup_login_buttonviews
View: partials.popup_login_buttonviews
View: partials.popup_login_buttonviews
1 x Application (80.79%)
96.31ms
1 x Preparing Response (67.5%)
80.46ms
1 x Booting (19.2%)
22.88ms
1 x Routing (1.83%)
2.18ms
21 x View (0%)
0μs

21 templates were rendered

visitors-listvisitors-list.blade.php#?blade
partials.profileHeaderprofileHeader.blade.php#?blade
partials.establishmentlistingestablishmentlisting.blade.php#?blade
partials.popup_login_buttonpopup_login_button.blade.php#?blade
partials.popup_login_buttonpopup_login_button.blade.php#?blade
partials.popup_login_buttonpopup_login_button.blade.php#?blade
pagination::tailwindtailwind.blade.php#?blade
layouts.mastermaster.blade.php#?blade
partials.popup_login_buttonpopup_login_button.blade.php#?blade
partials.popup_login_buttonpopup_login_button.blade.php#?blade
partials.popup_login_buttonpopup_login_button.blade.php#?blade
partials.popup_login_buttonpopup_login_button.blade.php#?blade
partials.popup_login_buttonpopup_login_button.blade.php#?blade
partials.popup_login_buttonpopup_login_button.blade.php#?blade
partials.popup_login_buttonpopup_login_button.blade.php#?blade
partials.popup_login_buttonpopup_login_button.blade.php#?blade
partials.popup_login_buttonpopup_login_button.blade.php#?blade
partials.popup_login_buttonpopup_login_button.blade.php#?blade
partials.popup_login_buttonpopup_login_button.blade.php#?blade
partials.popup_login_buttonpopup_login_button.blade.php#?blade
partials.popup_login_buttonpopup_login_button.blade.php#?blade

17 statements were executed (2 duplicates)Show only duplicates16.29ms

ImplicitRouteBinding.php#61primodishnewConnection Established

Backtrace

vendor/laravel/framework/src/Illuminate/Routing/ImplicitRouteBinding.php:61
vendor/laravel/framework/src/Illuminate/Routing/Router.php:959
vendor/livewire/livewire/src/Features/SupportPageComponents/SupportPageComponents.php:214
vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php:41
vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183

ImplicitRouteBinding.php#61primodishnew2.28msselect * from `visitors_lists` where `id` = '1078' and `visitors_lists`.`deleted_at` is null limit 1

Bindings	0: 1078
Backtrace	vendor/laravel/framework/src/Illuminate/Routing/ImplicitRouteBinding.php:61 vendor/laravel/framework/src/Illuminate/Routing/Router.php:959 vendor/livewire/livewire/src/Features/SupportPageComponents/SupportPageComponents.php:214 vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php:41 vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183

VisitorsListController.php#117primodishnew1.56msselect * from `list_dishes` where `list_id` = 1078 and `list_id` is not null and `list_dishes`.`deleted_at` is null

Bindings	0: 1078
Backtrace	app/Http/Controllers/VisitorsListController.php:117 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

VisitorsListController.php#154primodishnew1.16ms

select * from `establishments` where `establishments`.`id` = 369 and `deleted_at` is null and `establishments`.`deleted_at` is null limit 1

Bindings	0: 369
Backtrace	app/Http/Controllers/VisitorsListController.php:154 app/Http/Controllers/VisitorsListController.php:153 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

visitors-list.blade.php#6primodishnew600μsselect * from `visitors` where `visitors`.`id` = 321 and `visitors`.`deleted_at` is null limit 1

Bindings	0: 321
Backtrace	view::visitors-list:6 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:72

InteractsWithMedia.php#545primodishnew620μsselect * from `media` where `media`.`model_id` in (321) and `media`.`model_type` = 'App\\Models\\Visitor'

Bindings	0: App\Models\Visitor
Backtrace	vendor/spatie/laravel-medialibrary/src/InteractsWithMedia.php:545 vendor/spatie/laravel-medialibrary/src/MediaCollections/MediaRepository.php:31 vendor/spatie/laravel-medialibrary/src/InteractsWithMedia.php:271 app/Models/Visitor.php:256 view::partials.profileHeader:5

Visitor.php#179primodishnew870μsselect MAX(id) AS id from `reviews` where `visitor_id` = 321 and `reviews`.`deleted_at` is null group by `dish_id`

Bindings	0: 321
Backtrace	app/Models/Visitor.php:179 app/Models/Visitor.php:191 view::partials.profileHeader:37 vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124 vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58

Visitor.php#191primodishnew790μs

select `dish_id` from `reviews` where `reviews`.`visitor_id` = 321 and `reviews`.`visitor_id` is not null and exists (select * from `dishes` where `reviews`.`dish_id` = `dishes`.`id` and `deleted_at` is null and `dishes`.`deleted_at` is null and `moderate` = 'Approved') and `deleted_at` is null and `id` in (1271, 1335) and exists (select * from `dishes` where `reviews`.`dish_id` = `dishes`.`id` and `deleted_at` is null and `dishes`.`deleted_at` is null and `moderate` = 'Approved') and `reviews`.`deleted_at` is null

Bindings	0: 321 1: Approved 2: 1271 3: 1335 4: Approved
Backtrace	app/Models/Visitor.php:191 view::partials.profileHeader:37 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

profileHeader.blade.php#37primodishnew510μs

select * from `visitors_followings` where `visitors_followings`.`follow_visitors_id` = 321 and `visitors_followings`.`follow_visitors_id` is not null and `visitors_followings`.`deleted_at` is null

Bindings	0: 321
Backtrace	view::partials.profileHeader:37 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:72

InteractsWithMedia.php#545primodishnew560μsselect * from `media` where `media`.`model_id` in (369) and `media`.`model_type` = 'App\\Models\\Establishment'

Bindings	0: App\Models\Establishment
Backtrace	vendor/spatie/laravel-medialibrary/src/InteractsWithMedia.php:545 vendor/spatie/laravel-medialibrary/src/MediaCollections/MediaRepository.php:31 vendor/spatie/laravel-medialibrary/src/InteractsWithMedia.php:271 app/Models/Establishment.php:102 vendor/laravel/framework/src/Illuminate/Pagination/LengthAwarePaginator.php:196

visitors-list.blade.php#177primodishnew860μs

select * from `list_dishes` where `list_dishes`.`list_id` = 1078 and `list_dishes`.`list_id` is not null and exists (select * from `establishments` where `list_dishes`.`establishment_id` = `establishments`.`id` and `deleted_at` is null and `deleted_at` is null and `establishments`.`deleted_at` is null) and `list_dishes`.`deleted_at` is null

Bindings	0: 1078
Backtrace	view::visitors-list:177 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:72

establishmentlisting.blade.php#125primodishnew610μs

select * from `dishes` where `dishes`.`restaurant_id` = 369 and `dishes`.`restaurant_id` is not null and `dishes`.`deleted_at` is null and `moderate` = 'Approved'

Bindings	0: 369 1: Approved
Backtrace	view::partials.establishmentlisting:125 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:72

InteractsWithMedia.php#545primodishnew480μsselect * from `media` where `media`.`model_id` in (1125) and `media`.`model_type` = 'App\\Models\\Dish'

Bindings	0: App\Models\Dish
Backtrace	vendor/spatie/laravel-medialibrary/src/InteractsWithMedia.php:545 vendor/spatie/laravel-medialibrary/src/MediaCollections/MediaRepository.php:31 vendor/spatie/laravel-medialibrary/src/InteractsWithMedia.php:271 app/Models/Dish.php:212 vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124

Dish.php#236primodishnew570μsselect * from `establishments` where `establishments`.`id` = 369 and `establishments`.`deleted_at` is null limit 1

Bindings	0: 369
Backtrace	app/Models/Dish.php:236 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:72

InteractsWithMedia.php#545primodishnew490μsselect * from `media` where `media`.`model_id` in (369) and `media`.`model_type` = 'App\\Models\\Establishment'

Bindings	0: App\Models\Establishment
Backtrace	vendor/spatie/laravel-medialibrary/src/InteractsWithMedia.php:545 vendor/spatie/laravel-medialibrary/src/MediaCollections/MediaRepository.php:31 vendor/spatie/laravel-medialibrary/src/InteractsWithMedia.php:271 app/Models/Establishment.php:102 vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124

Dish.php#97primodishnew690μs

select count(*) as aggregate from `reviews` where `reviews`.`dish_id` = 1125 and `reviews`.`dish_id` is not null and `id` in (select `id` from `reviews` as `r1` where `r1`.`deleted_at` is null and `r1`.`dish_id` = `reviews`.`dish_id` and `r1`.`visitor_id` = `reviews`.`visitor_id` and r1.id = (
SELECT MAX(r2.id)
FROM reviews AS r2
WHERE r2.dish_id = r1.dish_id
AND r2.visitor_id = r1.visitor_id
AND r2.deleted_at IS NULL
)) and exists (select * from `visitors` where `reviews`.`visitor_id` = `visitors`.`id` and `deleted_at` is null and `visitors`.`deleted_at` is null) and exists (select * from `dishes` where `reviews`.`dish_id` = `dishes`.`id` and `deleted_at` is null and `dishes`.`deleted_at` is null and `moderate` = 'Approved') and `reviews`.`deleted_at` is null

Bindings	0: 1125 1: Approved
Backtrace	app/Models/Dish.php:97 view::partials.establishmentlisting:551 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

Dish.php#151primodishnew2.78ms

select avg(`reviews`.`rating`) as aggregate from `reviews` inner join (SELECT dish_id, visitor_id, MAX(created_at) AS max_created_at
FROM reviews
WHERE deleted_at IS NULL
GROUP BY dish_id, visitor_id) AS latest_reviews on `reviews`.`dish_id` = `latest_reviews`.`dish_id` and `reviews`.`visitor_id` = `latest_reviews`.`visitor_id` and `reviews`.`created_at` = `latest_reviews`.`max_created_at` inner join `dishes` on `reviews`.`dish_id` = `dishes`.`id` inner join `visitors` on `reviews`.`visitor_id` = `visitors`.`id` where `reviews`.`dish_id` = 1125 and `reviews`.`dish_id` is not null and `dishes`.`deleted_at` is null and `visitors`.`deleted_at` is null and `reviews`.`deleted_at` is null

Bindings	0: 1125
Backtrace	app/Models/Dish.php:151 view::partials.establishmentlisting:552 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

establishmentlisting.blade.php#555primodishnew860μs

select `dishes`.*, (select count(*) from `reviews` where `dishes`.`id` = `reviews`.`dish_id` and `reviews`.`deleted_at` is null and `id` in (select `id` from `reviews` as `r1` where `r1`.`deleted_at` is null and `r1`.`dish_id` = `reviews`.`dish_id` and `r1`.`visitor_id` = `reviews`.`visitor_id` and r1.id = (
SELECT MAX(r2.id)
FROM reviews AS r2
WHERE r2.dish_id = r1.dish_id
AND r2.visitor_id = r1.visitor_id
AND r2.deleted_at IS NULL
)) and exists (select * from `visitors` where `reviews`.`visitor_id` = `visitors`.`id` and `deleted_at` is null and `visitors`.`deleted_at` is null) and exists (select * from `dishes` where `reviews`.`dish_id` = `dishes`.`id` and `deleted_at` is null and `dishes`.`deleted_at` is null and `moderate` = 'Approved') and `reviews`.`deleted_at` is null) as `latest_reviews_count` from `dishes` where `dishes`.`restaurant_id` = 369 and `dishes`.`restaurant_id` is not null and `dishes`.`deleted_at` is null and `dishes`.`deleted_at` is null and `moderate` = 'Approved' having `latest_reviews_count` > 0

Bindings	0: Approved 1: 369 2: Approved 3: 0
Backtrace	view::partials.establishmentlisting:555 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:72

App\Models\ListDish: 2ListDish.php#?
App\Models\Establishment: 2Establishment.php#?
App\Models\Review: 2Review.php#?
App\Models\Dish: 2Dish.php#?
App\Models\VisitorsList: 1VisitorsList.php#?
App\Models\Visitor: 1Visitor.php#?
Spatie\MediaLibrary\MediaCollections\Models\Media: 1Media.php#?

AutoshowClear Show all

	Date ↕	Method	URL	Data
#1	2025-06-10 05:46:56	GET	/visitors-lists/1078?sortby=distance	21 17 11

Dish Name

ben-m000

Restaurant Bookmarks

Opa's Schnitzel Hut

Opa's Schnitzel Hut

Opa's Schnitzel Hut

1 x Application (80.79%)	96.31ms
1 x Preparing Response (67.5%)	80.46ms
1 x Booting (19.2%)	22.88ms
1 x Routing (1.83%)	2.18ms
21 x View (0%)	0μs