Messages Request Timeline Exceptions Views32 Queries82 Models83 Livewire0 Mails Gate

Settings Request history427ms8MB10.xGET establishments/{establishment}-{slug}

status

200 OK

full_url

https://primodishnew.webmavens.com/establishments/297-imos-pizza?sortby=rating

action_name

establishments.show

controller_action

App\Http\Controllers\EstablishmentController@show

uri

GET establishments/{establishment}-{slug}

controller

App\Http\Controllers\EstablishmentController@show

namespace

App\Http\Controllers

file

app/Http/Controllers/EstablishmentController.php:25-81

middleware

web

duration

432ms

peak_memory

12MB

response

text/html; charset=UTF-8

request_format

html

request_query

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

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 => "Thu, 17 Jul 2025 20:47:13 GMT"
  ]
]

session_attributes

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

Booting (13.88ms)time
Application (413ms)time
Routing (1.03ms)
Preparing Response (399ms)
View: establishmentsviews
View: partials.establishmentlistingviews
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
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 (96.75%)
413ms
1 x Preparing Response (93.44%)
399ms
1 x Booting (3.25%)
13.88ms
1 x Routing (0.24%)
1.03ms
32 x View (0%)
0μs

32 templates were rendered

establishmentsestablishments.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
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
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

82 statements were executed (57 duplicates)Show only duplicates81.89ms

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#61primodishnew1.82msselect * from `establishments` where `id` = '297' and `establishments`.`deleted_at` is null limit 1

Bindings	0: 297
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

EstablishmentController.php#78primodishnew710μs

select count(*) as aggregate from `dishes` where `dishes`.`restaurant_id` = 297 and `dishes`.`restaurant_id` is not null and exists (select * from `establishments` where `dishes`.`restaurant_id` = `establishments`.`id` and `id` = 297 and `establishments`.`deleted_at` is null) and `dishes`.`deleted_at` is null and `moderate` = 'Approved'

Bindings	0: 297 1: 297 2: Approved
Backtrace	app/Http/Controllers/EstablishmentController.php:78 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

EstablishmentController.php#78primodishnew1.95ms

select distinct `dishes`.*, (select avg(`reviews`.`rating`) from `reviews` where `dishes`.`id` = `reviews`.`dish_id` 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_avg_rating`, (select count(*) from `reviews` where `dishes`.`id` = `reviews`.`dish_id` 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`, (select min(`reviews`.`price_at_time_of_review`) from `reviews` where `dishes`.`id` = `reviews`.`dish_id` 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 `min_price`, (select max(`reviews`.`price_at_time_of_review`) from `reviews` where `dishes`.`id` = `reviews`.`dish_id` 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 `max_price` from `dishes` where `dishes`.`restaurant_id` = 297 and `dishes`.`restaurant_id` is not null and exists (select * from `establishments` where `dishes`.`restaurant_id` = `establishments`.`id` and `id` = 297 and `establishments`.`deleted_at` is null) and `dishes`.`deleted_at` is null and `moderate` = 'Approved' order by `latest_reviews_avg_rating` asc, `dish_name` asc limit 10 offset 0

Bindings	0: Approved 1: Approved 2: Approved 3: Approved 4: 297 5: 297 6: Approved
Backtrace	app/Http/Controllers/EstablishmentController.php:78 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

EstablishmentController.php#78primodishnew760μs

select * from `reviews` where `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`.`dish_id` in (853, 854, 876, 1246) and `reviews`.`deleted_at` is null

Bindings	0: Approved
Backtrace	app/Http/Controllers/EstablishmentController.php:78 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

EstablishmentController.php#78primodishnew650μs

select * from `media` where `media`.`model_id` in (996, 1414, 1417, 1420) and `media`.`model_type` = 'App\\Models\\Review'

Bindings	0: App\Models\Review
Backtrace	app/Http/Controllers/EstablishmentController.php:78 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

InteractsWithMedia.php#545primodishnew430μsselect * from `media` where `media`.`model_id` in (297) 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

establishmentlisting.blade.php#550primodishnew540μs

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

Bindings	0: 297 1: Approved
Backtrace	view::partials.establishmentlisting:550 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

Dish.php#97primodishnew710μs

select count(*) as aggregate from `reviews` where `reviews`.`dish_id` = 853 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: 853 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.82ms

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` = 853 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: 853
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

Dish.php#97primodishnew720μs

select count(*) as aggregate from `reviews` where `reviews`.`dish_id` = 854 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: 854 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.7ms

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` = 854 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: 854
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

Dish.php#97primodishnew670μs

select count(*) as aggregate from `reviews` where `reviews`.`dish_id` = 876 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: 876 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.62ms

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` = 876 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: 876
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

Dish.php#97primodishnew680μs

select count(*) as aggregate from `reviews` where `reviews`.`dish_id` = 1246 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: 1246 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.69ms

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` = 1246 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: 1246
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#555primodishnew920μ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` = 297 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: 297 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

EstablishmentController.php#181primodishnew2.47ms

select * from `reviews` where `reviews`.`id` in (select MAX(reviews.id) from `reviews` inner join `dishes` on `reviews`.`dish_id` = `dishes`.`id` where `dishes`.`restaurant_id` = 297 and `moderate` = 'Approved' and `reviews`.`deleted_at` is null and `dishes`.`deleted_at` is null group by `reviews`.`visitor_id`) and `cost` <> 0 and `deleted_at` is null and `reviews`.`deleted_at` is null

Bindings	0: 297 1: Approved 2: 0
Backtrace	app/Http/Controllers/EstablishmentController.php:181 view::establishments:150 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

EstablishmentController.php#181primodishnew2.46ms

select * from `reviews` where `reviews`.`id` in (select MAX(reviews.id) from `reviews` inner join `dishes` on `reviews`.`dish_id` = `dishes`.`id` where `dishes`.`restaurant_id` = 297 and `moderate` = 'Approved' and `reviews`.`deleted_at` is null and `dishes`.`deleted_at` is null group by `reviews`.`visitor_id`) and `parking` <> 0 and `deleted_at` is null and `reviews`.`deleted_at` is null

Bindings	0: 297 1: Approved 2: 0
Backtrace	app/Http/Controllers/EstablishmentController.php:181 view::establishments:159 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

EstablishmentController.php#181primodishnew2.42ms

select * from `reviews` where `reviews`.`id` in (select MAX(reviews.id) from `reviews` inner join `dishes` on `reviews`.`dish_id` = `dishes`.`id` where `dishes`.`restaurant_id` = 297 and `moderate` = 'Approved' and `reviews`.`deleted_at` is null and `dishes`.`deleted_at` is null group by `reviews`.`visitor_id`) and `staff` <> 0 and `deleted_at` is null and `reviews`.`deleted_at` is null

Bindings	0: 297 1: Approved 2: 0
Backtrace	app/Http/Controllers/EstablishmentController.php:181 view::establishments:169 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

EstablishmentController.php#181primodishnew2.43ms

select * from `reviews` where `reviews`.`id` in (select MAX(reviews.id) from `reviews` inner join `dishes` on `reviews`.`dish_id` = `dishes`.`id` where `dishes`.`restaurant_id` = 297 and `moderate` = 'Approved' and `reviews`.`deleted_at` is null and `dishes`.`deleted_at` is null group by `reviews`.`visitor_id`) and `wait_times` <> 0 and `deleted_at` is null and `reviews`.`deleted_at` is null

Bindings	0: 297 1: Approved 2: 0
Backtrace	app/Http/Controllers/EstablishmentController.php:181 view::establishments:178 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

EstablishmentController.php#181primodishnew2.41ms

select * from `reviews` where `reviews`.`id` in (select MAX(reviews.id) from `reviews` inner join `dishes` on `reviews`.`dish_id` = `dishes`.`id` where `dishes`.`restaurant_id` = 297 and `moderate` = 'Approved' and `reviews`.`deleted_at` is null and `dishes`.`deleted_at` is null group by `reviews`.`visitor_id`) and `cleanliness` <> 0 and `deleted_at` is null and `reviews`.`deleted_at` is null

Bindings	0: 297 1: Approved 2: 0
Backtrace	app/Http/Controllers/EstablishmentController.php:181 view::establishments:189 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

EstablishmentController.php#181primodishnew2.45ms

select * from `reviews` where `reviews`.`id` in (select MAX(reviews.id) from `reviews` inner join `dishes` on `reviews`.`dish_id` = `dishes`.`id` where `dishes`.`restaurant_id` = 297 and `moderate` = 'Approved' and `reviews`.`deleted_at` is null and `dishes`.`deleted_at` is null group by `reviews`.`visitor_id`) and `family_friendly` <> 0 and `deleted_at` is null and `reviews`.`deleted_at` is null

Bindings	0: 297 1: Approved 2: 0
Backtrace	app/Http/Controllers/EstablishmentController.php:181 view::establishments:200 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

DishController.php#830primodishnew450μsselect * from `dishes` where `dishes`.`id` = 1246 and `dishes`.`deleted_at` is null and `moderate` = 'Approved' limit 1

Bindings	0: 1246 1: Approved
Backtrace	app/Http/Controllers/DishController.php:830 view::establishments:308 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

DishController.php#832primodishnew770μs

select * from `reviews` where `reviews`.`dish_id` = 1246 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: 1246 1: Approved
Backtrace	app/Http/Controllers/DishController.php:832 view::establishments:308 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

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

Bindings	0: App\Models\Review
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/Review.php:125 app/Http/Controllers/DishController.php:833

Dish.php#151primodishnew2.77ms

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` = 1246 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: 1246
Backtrace	app/Models/Dish.php:151 view::establishments:319 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#97primodishnew800μs

select count(*) as aggregate from `reviews` where `reviews`.`dish_id` = 1246 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: 1246 1: Approved
Backtrace	app/Models/Dish.php:97 view::establishments:322 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

establishments.blade.php#331primodishnew710μs

select * from `reviews` where `reviews`.`dish_id` = 1246 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 order by `id` desc

Bindings	0: 1246 1: Approved
Backtrace	view::establishments:331 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

establishments.blade.php#331primodishnew390μsselect * from `visitors` where `visitors`.`id` in (22) and `visitors`.`deleted_at` is null

Backtrace

view::establishments:331
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#545primodishnew440μsselect * from `media` where `media`.`model_id` in (1420) and `media`.`model_type` = 'App\\Models\\Review'

Bindings	0: App\Models\Review
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/Review.php:125 view::establishments:337

establishments.blade.php#345primodishnew620μsselect * from `establishments` where `establishments`.`id` = 297 and `establishments`.`deleted_at` is null limit 1

Bindings	0: 297
Backtrace	view::establishments:345 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

establishments.blade.php#597primodishnew480μsselect * from `dishes` where `dishes`.`id` = 1246 and `dishes`.`deleted_at` is null and `moderate` = 'Approved' limit 1

Bindings	0: 1246 1: Approved
Backtrace	view::establishments:597 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#545primodishnew440μsselect * from `media` where `media`.`model_id` in (1246) 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#236primodishnew500μsselect * from `establishments` where `establishments`.`id` = 297 and `establishments`.`deleted_at` is null limit 1

Bindings	0: 297
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#545primodishnew430μsselect * from `media` where `media`.`model_id` in (297) 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

InteractsWithMedia.php#545primodishnew1.24msselect * from `media` where `media`.`model_id` in (22) 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 vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124

DishController.php#830primodishnew730μsselect * from `dishes` where `dishes`.`id` = 854 and `dishes`.`deleted_at` is null and `moderate` = 'Approved' limit 1

Bindings	0: 854 1: Approved
Backtrace	app/Http/Controllers/DishController.php:830 view::establishments:308 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

DishController.php#832primodishnew950μs

select * from `reviews` where `reviews`.`dish_id` = 854 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: 854 1: Approved
Backtrace	app/Http/Controllers/DishController.php:832 view::establishments:308 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

InteractsWithMedia.php#545primodishnew510μsselect * from `media` where `media`.`model_id` in (1414) and `media`.`model_type` = 'App\\Models\\Review'

Bindings	0: App\Models\Review
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/Review.php:125 app/Http/Controllers/DishController.php:833

Dish.php#151primodishnew3.11ms

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` = 854 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: 854
Backtrace	app/Models/Dish.php:151 view::establishments:319 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#97primodishnew850μs

select count(*) as aggregate from `reviews` where `reviews`.`dish_id` = 854 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: 854 1: Approved
Backtrace	app/Models/Dish.php:97 view::establishments:322 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

establishments.blade.php#331primodishnew780μs

select * from `reviews` where `reviews`.`dish_id` = 854 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 order by `id` desc

Bindings	0: 854 1: Approved
Backtrace	view::establishments:331 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

establishments.blade.php#331primodishnew410μsselect * from `visitors` where `visitors`.`id` in (22) and `visitors`.`deleted_at` is null

Backtrace

view::establishments:331
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#545primodishnew470μsselect * from `media` where `media`.`model_id` in (1414) and `media`.`model_type` = 'App\\Models\\Review'

Bindings	0: App\Models\Review
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/Review.php:125 view::establishments:337

establishments.blade.php#345primodishnew710μsselect * from `establishments` where `establishments`.`id` = 297 and `establishments`.`deleted_at` is null limit 1

Bindings	0: 297
Backtrace	view::establishments:345 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

establishments.blade.php#597primodishnew510μsselect * from `dishes` where `dishes`.`id` = 854 and `dishes`.`deleted_at` is null and `moderate` = 'Approved' limit 1

Bindings	0: 854 1: Approved
Backtrace	view::establishments:597 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#545primodishnew450μsselect * from `media` where `media`.`model_id` in (854) 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#236primodishnew460μsselect * from `establishments` where `establishments`.`id` = 297 and `establishments`.`deleted_at` is null limit 1

Bindings	0: 297
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#545primodishnew560μsselect * from `media` where `media`.`model_id` in (297) 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

InteractsWithMedia.php#545primodishnew600μsselect * from `media` where `media`.`model_id` in (22) 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 vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124

DishController.php#830primodishnew660μsselect * from `dishes` where `dishes`.`id` = 876 and `dishes`.`deleted_at` is null and `moderate` = 'Approved' limit 1

Bindings	0: 876 1: Approved
Backtrace	app/Http/Controllers/DishController.php:830 view::establishments:308 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

DishController.php#832primodishnew900μs

select * from `reviews` where `reviews`.`dish_id` = 876 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: 876 1: Approved
Backtrace	app/Http/Controllers/DishController.php:832 view::establishments:308 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

InteractsWithMedia.php#545primodishnew440μsselect * from `media` where `media`.`model_id` in (1417) and `media`.`model_type` = 'App\\Models\\Review'

Bindings	0: App\Models\Review
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/Review.php:125 app/Http/Controllers/DishController.php:833

Dish.php#151primodishnew2.84ms

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` = 876 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: 876
Backtrace	app/Models/Dish.php:151 view::establishments:319 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#97primodishnew720μs

select count(*) as aggregate from `reviews` where `reviews`.`dish_id` = 876 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: 876 1: Approved
Backtrace	app/Models/Dish.php:97 view::establishments:322 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

establishments.blade.php#331primodishnew740μs

select * from `reviews` where `reviews`.`dish_id` = 876 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 order by `id` desc

Bindings	0: 876 1: Approved
Backtrace	view::establishments:331 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

establishments.blade.php#331primodishnew400μsselect * from `visitors` where `visitors`.`id` in (22) and `visitors`.`deleted_at` is null

Backtrace

view::establishments:331
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#545primodishnew450μsselect * from `media` where `media`.`model_id` in (1417) and `media`.`model_type` = 'App\\Models\\Review'

Bindings	0: App\Models\Review
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/Review.php:125 view::establishments:337

establishments.blade.php#345primodishnew580μsselect * from `establishments` where `establishments`.`id` = 297 and `establishments`.`deleted_at` is null limit 1

Bindings	0: 297
Backtrace	view::establishments:345 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

establishments.blade.php#597primodishnew430μsselect * from `dishes` where `dishes`.`id` = 876 and `dishes`.`deleted_at` is null and `moderate` = 'Approved' limit 1

Bindings	0: 876 1: Approved
Backtrace	view::establishments:597 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#545primodishnew420μsselect * from `media` where `media`.`model_id` in (876) 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#236primodishnew440μsselect * from `establishments` where `establishments`.`id` = 297 and `establishments`.`deleted_at` is null limit 1

Bindings	0: 297
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#545primodishnew410μsselect * from `media` where `media`.`model_id` in (297) 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

InteractsWithMedia.php#545primodishnew470μsselect * from `media` where `media`.`model_id` in (22) 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 vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124

DishController.php#830primodishnew600μsselect * from `dishes` where `dishes`.`id` = 853 and `dishes`.`deleted_at` is null and `moderate` = 'Approved' limit 1

Bindings	0: 853 1: Approved
Backtrace	app/Http/Controllers/DishController.php:830 view::establishments:308 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

DishController.php#832primodishnew1.32ms

select * from `reviews` where `reviews`.`dish_id` = 853 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: 853 1: Approved
Backtrace	app/Http/Controllers/DishController.php:832 view::establishments:308 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

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

Bindings	0: App\Models\Review
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/Review.php:125 app/Http/Controllers/DishController.php:833

Dish.php#151primodishnew2.95ms

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` = 853 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: 853
Backtrace	app/Models/Dish.php:151 view::establishments:319 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#97primodishnew820μs

select count(*) as aggregate from `reviews` where `reviews`.`dish_id` = 853 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: 853 1: Approved
Backtrace	app/Models/Dish.php:97 view::establishments:322 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

establishments.blade.php#331primodishnew880μs

select * from `reviews` where `reviews`.`dish_id` = 853 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 order by `id` desc

Bindings	0: 853 1: Approved
Backtrace	view::establishments:331 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

establishments.blade.php#331primodishnew410μsselect * from `visitors` where `visitors`.`id` in (22) and `visitors`.`deleted_at` is null

Backtrace

view::establishments:331
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#545primodishnew500μsselect * from `media` where `media`.`model_id` in (996) and `media`.`model_type` = 'App\\Models\\Review'

Bindings	0: App\Models\Review
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/Review.php:125 view::establishments:337

establishments.blade.php#345primodishnew780μsselect * from `establishments` where `establishments`.`id` = 297 and `establishments`.`deleted_at` is null limit 1

Bindings	0: 297
Backtrace	view::establishments:345 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

establishments.blade.php#597primodishnew1.42msselect * from `dishes` where `dishes`.`id` = 853 and `dishes`.`deleted_at` is null and `moderate` = 'Approved' limit 1

Bindings	0: 853 1: Approved
Backtrace	view::establishments:597 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 (853) 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#236primodishnew500μsselect * from `establishments` where `establishments`.`id` = 297 and `establishments`.`deleted_at` is null limit 1

Bindings	0: 297
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#545primodishnew500μsselect * from `media` where `media`.`model_id` in (297) 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

InteractsWithMedia.php#545primodishnew680μsselect * from `media` where `media`.`model_id` in (22) 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 vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124

master.blade.php#111primodishnew700μsselect * from `visitors` where `visitors`.`id` = 22 and `visitors`.`deleted_at` is null limit 1

Bindings	0: 22
Backtrace	view::layouts.master:111 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

master.blade.php#111primodishnew470μsselect * from `visitors` where `visitors`.`id` = 22 and `visitors`.`deleted_at` is null limit 1

Bindings	0: 22
Backtrace	view::layouts.master:111 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

master.blade.php#111primodishnew430μsselect * from `visitors` where `visitors`.`id` = 22 and `visitors`.`deleted_at` is null limit 1

Bindings	0: 22
Backtrace	view::layouts.master:111 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

master.blade.php#111primodishnew410μsselect * from `visitors` where `visitors`.`id` = 22 and `visitors`.`deleted_at` is null limit 1

Bindings	0: 22
Backtrace	view::layouts.master:111 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

Spatie\MediaLibrary\MediaCollections\Models\Media: 28Media.php#?
App\Models\Dish: 20Dish.php#?
App\Models\Review: 18Review.php#?
App\Models\Establishment: 9Establishment.php#?
App\Models\Visitor: 8Visitor.php#?

AutoshowClear Show all

	Date ↕	Method	URL	Data
#1	2025-07-17 15:47:14	GET	/establishments/297-imos-pizza?sortby=rating	32 82 83

Dish Name

Imo's Pizza

Imo's Pizza

Imo's Pizza

Restaurant Overall Stats

Fritz's Review

Fritz's Review

Fritz's Review

Fritz's Review

1 x Application (96.75%)	413ms
1 x Preparing Response (93.44%)	399ms
1 x Booting (3.25%)	13.88ms
1 x Routing (0.24%)	1.03ms
32 x View (0%)	0μs