Godavari Austin

  • (13 Reviews - 72%)
  • Vegetarian Biryani
    Rating: 80%
    Reviews: 1
    Vegetarian Biryani-Godavari Austin-Austin
  • Chilli Chicken
    Rating: 90%
    Reviews: 1
    Chilli Chicken-Godavari Austin-Austin
  • Semiya Payasam
    Rating: 100%
    Reviews: 1
    Semiya Payasam-Godavari Austin-Austin

Showing 11 to 13 of 13 results

© 2011-2025 Primo Analytics, Inc. All rights reserved.
SettingsRequest history397msRequest Duration8MBMemory Usage10.x
Laravel Version
10.48.29
PHP Version
8.2.0
Environment
local
Debug Mode
Enabled
URL
primodishnew.webmavens.com
Timezone
America/Chicago
Locale
en
GET establishments/{establishment}-{slug}
status
200 OK
full_url
https://primodishnew.webmavens.com/establishments/392-godavari-austin?page=2&sortby=rating
action_name
establishments.show
controller_action
App\Http\Controllers\EstablishmentController@show
Theme
Open Button Position
Hide Empty Tabs
Autoshow
Reset to defaults
    status
    200 OK
    full_url
    https://primodishnew.webmavens.com/establishments/392-godavari-austin?page=2&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
    402ms
    peak_memory
    12MB
    response
    text/html; charset=UTF-8
    request_format
    html
    request_query
    0 of 0
    array:2 [ "page" => "2" "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 => "Wed, 21 May 2025 19:38:08 GMT" ] ]
    session_attributes
    0 of 0
    array:5 [ "_token" => "HprnzPYxitbOtrJwvi4dGJ9C9IXZUdOMTV0dDiT9" "lastActivityTime" => 1747856288 "Latitude" => "30.26715" "Longitude" => "-97.74306" "formatted_address" => "Austin, TX, USA" ]
    • Booting (13.93ms)time
    • Application (383ms)time
    • Routing (946μs)
    • Preparing Response (368ms)
    • 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: 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.49%)
      383ms
      1 x Preparing Response (92.88%)
      368ms
      1 x Booting (3.51%)
      13.93ms
      1 x Routing (0.24%)
      946μs
      29 x View (0%)
      0μs
      29 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
      • 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
      85 statements were executed (43 duplicates)Show only duplicates109ms
      • 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.71msselect * from `establishments` where `id` = '392' and `establishments`.`deleted_at` is null limit 1
        Bindings
        • 0: 392
        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#78primodishnew670μsselect count(*) as aggregate from `dishes` where `dishes`.`restaurant_id` = 392 and `dishes`.`restaurant_id` is not null and exists (select * from `establishments` where `dishes`.`restaurant_id` = `establishments`.`id` and `id` = 392 and `establishments`.`deleted_at` is null) and `dishes`.`deleted_at` is null and `moderate` = 'Approved'
        Bindings
        • 0: 392
        • 1: 392
        • 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#78primodishnew2.35msselect 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` = 392 and `dishes`.`restaurant_id` is not null and exists (select * from `establishments` where `dishes`.`restaurant_id` = `establishments`.`id` and `id` = 392 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 10
        Bindings
        • 0: Approved
        • 1: Approved
        • 2: Approved
        • 3: Approved
        • 4: 392
        • 5: 392
        • 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#78primodishnew740μsselect * 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 (1188, 1192, 1194) 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#78primodishnew640μsselect * from `media` where `media`.`model_id` in (1340, 1344, 1346) 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#545primodishnew450μsselect * from `media` where `media`.`model_id` in (392) 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#550primodishnew550μsselect * from `dishes` where `dishes`.`restaurant_id` = 392 and `dishes`.`restaurant_id` is not null and `dishes`.`deleted_at` is null and `moderate` = 'Approved'
        Bindings
        • 0: 392
        • 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#99primodishnew720μsselect count(*) as aggregate from `reviews` where `reviews`.`dish_id` = 1184 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: 1184
        • 1: Approved
        Backtrace
        • app/Models/Dish.php:99
        • 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#153primodishnew2.84msselect 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` = 1184 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: 1184
        Backtrace
        • app/Models/Dish.php:153
        • 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#99primodishnew1.73msselect count(*) as aggregate from `reviews` where `reviews`.`dish_id` = 1185 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: 1185
        • 1: Approved
        Backtrace
        • app/Models/Dish.php:99
        • 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#153primodishnew2.69msselect 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` = 1185 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: 1185
        Backtrace
        • app/Models/Dish.php:153
        • 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#99primodishnew640μsselect count(*) as aggregate from `reviews` where `reviews`.`dish_id` = 1186 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: 1186
        • 1: Approved
        Backtrace
        • app/Models/Dish.php:99
        • 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#153primodishnew2.67msselect 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` = 1186 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: 1186
        Backtrace
        • app/Models/Dish.php:153
        • 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#99primodishnew630μsselect count(*) as aggregate from `reviews` where `reviews`.`dish_id` = 1187 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: 1187
        • 1: Approved
        Backtrace
        • app/Models/Dish.php:99
        • 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#153primodishnew2.61msselect 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` = 1187 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: 1187
        Backtrace
        • app/Models/Dish.php:153
        • 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#99primodishnew620μsselect count(*) as aggregate from `reviews` where `reviews`.`dish_id` = 1188 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: 1188
        • 1: Approved
        Backtrace
        • app/Models/Dish.php:99
        • 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#153primodishnew2.64msselect 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` = 1188 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: 1188
        Backtrace
        • app/Models/Dish.php:153
        • 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#99primodishnew610μsselect count(*) as aggregate from `reviews` where `reviews`.`dish_id` = 1189 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: 1189
        • 1: Approved
        Backtrace
        • app/Models/Dish.php:99
        • 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#153primodishnew2.64msselect 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` = 1189 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: 1189
        Backtrace
        • app/Models/Dish.php:153
        • 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#99primodishnew620μsselect count(*) as aggregate from `reviews` where `reviews`.`dish_id` = 1190 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: 1190
        • 1: Approved
        Backtrace
        • app/Models/Dish.php:99
        • 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#153primodishnew2.6msselect 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` = 1190 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: 1190
        Backtrace
        • app/Models/Dish.php:153
        • 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#99primodishnew660μsselect count(*) as aggregate from `reviews` where `reviews`.`dish_id` = 1191 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: 1191
        • 1: Approved
        Backtrace
        • app/Models/Dish.php:99
        • 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#153primodishnew2.61msselect 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` = 1191 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: 1191
        Backtrace
        • app/Models/Dish.php:153
        • 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#99primodishnew660μsselect count(*) as aggregate from `reviews` where `reviews`.`dish_id` = 1192 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: 1192
        • 1: Approved
        Backtrace
        • app/Models/Dish.php:99
        • 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#153primodishnew2.62msselect 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` = 1192 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: 1192
        Backtrace
        • app/Models/Dish.php:153
        • 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#99primodishnew660μsselect count(*) as aggregate from `reviews` where `reviews`.`dish_id` = 1193 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: 1193
        • 1: Approved
        Backtrace
        • app/Models/Dish.php:99
        • 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#153primodishnew2.72msselect 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` = 1193 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: 1193
        Backtrace
        • app/Models/Dish.php:153
        • 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#99primodishnew680μsselect count(*) as aggregate from `reviews` where `reviews`.`dish_id` = 1194 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: 1194
        • 1: Approved
        Backtrace
        • app/Models/Dish.php:99
        • 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#153primodishnew2.58msselect 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` = 1194 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: 1194
        Backtrace
        • app/Models/Dish.php:153
        • 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#99primodishnew620μsselect count(*) as aggregate from `reviews` where `reviews`.`dish_id` = 1195 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: 1195
        • 1: Approved
        Backtrace
        • app/Models/Dish.php:99
        • 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#153primodishnew2.54msselect 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` = 1195 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: 1195
        Backtrace
        • app/Models/Dish.php:153
        • 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#99primodishnew610μsselect count(*) as aggregate from `reviews` where `reviews`.`dish_id` = 1196 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: 1196
        • 1: Approved
        Backtrace
        • app/Models/Dish.php:99
        • 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#153primodishnew2.63msselect 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` = 1196 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: 1196
        Backtrace
        • app/Models/Dish.php:153
        • 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#555primodishnew1.21msselect `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` = 392 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: 392
        • 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#182primodishnew2.5msselect * 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` = 392 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: 392
        • 1: Approved
        • 2: 0
        Backtrace
        • app/Http/Controllers/EstablishmentController.php:182
        • 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#182primodishnew2.52msselect * 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` = 392 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: 392
        • 1: Approved
        • 2: 0
        Backtrace
        • app/Http/Controllers/EstablishmentController.php:182
        • 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#182primodishnew2.46msselect * 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` = 392 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: 392
        • 1: Approved
        • 2: 0
        Backtrace
        • app/Http/Controllers/EstablishmentController.php:182
        • 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#182primodishnew2.5msselect * 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` = 392 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: 392
        • 1: Approved
        • 2: 0
        Backtrace
        • app/Http/Controllers/EstablishmentController.php:182
        • 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#182primodishnew2.43msselect * 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` = 392 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: 392
        • 1: Approved
        • 2: 0
        Backtrace
        • app/Http/Controllers/EstablishmentController.php:182
        • 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#182primodishnew2.45msselect * 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` = 392 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: 392
        • 1: Approved
        • 2: 0
        Backtrace
        • app/Http/Controllers/EstablishmentController.php:182
        • 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#837primodishnew400μsselect * from `dishes` where `dishes`.`id` = 1192 and `dishes`.`deleted_at` is null and `moderate` = 'Approved' limit 1
        Bindings
        • 0: 1192
        • 1: Approved
        Backtrace
        • app/Http/Controllers/DishController.php:837
        • 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#839primodishnew750μsselect * from `reviews` where `reviews`.`dish_id` = 1192 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: 1192
        • 1: Approved
        Backtrace
        • app/Http/Controllers/DishController.php:839
        • 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 (1344) 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:840
      • Dish.php#153primodishnew2.87msselect 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` = 1192 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: 1192
        Backtrace
        • app/Models/Dish.php:153
        • 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#99primodishnew720μsselect count(*) as aggregate from `reviews` where `reviews`.`dish_id` = 1192 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: 1192
        • 1: Approved
        Backtrace
        • app/Models/Dish.php:99
        • 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#331primodishnew730μsselect * from `reviews` where `reviews`.`dish_id` = 1192 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: 1192
        • 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 (1344) 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#345primodishnew520μsselect * from `establishments` where `establishments`.`id` = 392 and `establishments`.`deleted_at` is null limit 1
        Bindings
        • 0: 392
        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.66msselect * from `dishes` where `dishes`.`id` = 1192 and `dishes`.`deleted_at` is null and `moderate` = 'Approved' limit 1
        Bindings
        • 0: 1192
        • 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#545primodishnew430μsselect * from `media` where `media`.`model_id` in (1192) 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:214
        • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
      • Dish.php#238primodishnew480μsselect * from `establishments` where `establishments`.`id` = 392 and `establishments`.`deleted_at` is null limit 1
        Bindings
        • 0: 392
        Backtrace
        • app/Models/Dish.php:238
        • 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 (392) 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#545primodishnew640μ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:257
        • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
      • DishController.php#837primodishnew650μsselect * from `dishes` where `dishes`.`id` = 1188 and `dishes`.`deleted_at` is null and `moderate` = 'Approved' limit 1
        Bindings
        • 0: 1188
        • 1: Approved
        Backtrace
        • app/Http/Controllers/DishController.php:837
        • 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#839primodishnew8.61msselect * from `reviews` where `reviews`.`dish_id` = 1188 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: 1188
        • 1: Approved
        Backtrace
        • app/Http/Controllers/DishController.php:839
        • 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#545primodishnew550μsselect * from `media` where `media`.`model_id` in (1340) 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:840
      • Dish.php#153primodishnew2.77msselect 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` = 1188 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: 1188
        Backtrace
        • app/Models/Dish.php:153
        • 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#99primodishnew670μsselect count(*) as aggregate from `reviews` where `reviews`.`dish_id` = 1188 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: 1188
        • 1: Approved
        Backtrace
        • app/Models/Dish.php:99
        • 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#331primodishnew2.96msselect * from `reviews` where `reviews`.`dish_id` = 1188 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: 1188
        • 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#331primodishnew370μ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 (1340) 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#345primodishnew500μsselect * from `establishments` where `establishments`.`id` = 392 and `establishments`.`deleted_at` is null limit 1
        Bindings
        • 0: 392
        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` = 1188 and `dishes`.`deleted_at` is null and `moderate` = 'Approved' limit 1
        Bindings
        • 0: 1188
        • 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#545primodishnew390μsselect * from `media` where `media`.`model_id` in (1188) 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:214
        • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
      • Dish.php#238primodishnew440μsselect * from `establishments` where `establishments`.`id` = 392 and `establishments`.`deleted_at` is null limit 1
        Bindings
        • 0: 392
        Backtrace
        • app/Models/Dish.php:238
        • 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#545primodishnew380μsselect * from `media` where `media`.`model_id` in (392) 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#545primodishnew490μ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:257
        • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
      • DishController.php#837primodishnew690μsselect * from `dishes` where `dishes`.`id` = 1194 and `dishes`.`deleted_at` is null and `moderate` = 'Approved' limit 1
        Bindings
        • 0: 1194
        • 1: Approved
        Backtrace
        • app/Http/Controllers/DishController.php:837
        • 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#839primodishnew870μsselect * from `reviews` where `reviews`.`dish_id` = 1194 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: 1194
        • 1: Approved
        Backtrace
        • app/Http/Controllers/DishController.php:839
        • 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#545primodishnew470μsselect * from `media` where `media`.`model_id` in (1346) 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:840
      • Dish.php#153primodishnew2.9msselect 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` = 1194 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: 1194
        Backtrace
        • app/Models/Dish.php:153
        • 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#99primodishnew670μsselect count(*) as aggregate from `reviews` where `reviews`.`dish_id` = 1194 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: 1194
        • 1: Approved
        Backtrace
        • app/Models/Dish.php:99
        • 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#331primodishnew730μsselect * from `reviews` where `reviews`.`dish_id` = 1194 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: 1194
        • 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#331primodishnew350μ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 (1346) 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#345primodishnew600μsselect * from `establishments` where `establishments`.`id` = 392 and `establishments`.`deleted_at` is null limit 1
        Bindings
        • 0: 392
        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#597primodishnew450μsselect * from `dishes` where `dishes`.`id` = 1194 and `dishes`.`deleted_at` is null and `moderate` = 'Approved' limit 1
        Bindings
        • 0: 1194
        • 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 (1194) 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:214
        • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
      • Dish.php#238primodishnew480μsselect * from `establishments` where `establishments`.`id` = 392 and `establishments`.`deleted_at` is null limit 1
        Bindings
        • 0: 392
        Backtrace
        • app/Models/Dish.php:238
        • 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#545primodishnew390μsselect * from `media` where `media`.`model_id` in (392) 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#545primodishnew610μ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:257
        • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
      • master.blade.php#111primodishnew660μ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#111primodishnew460μ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#111primodishnew400μ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
      App\Models\Dish
      35Dish.php#?
      Spatie\MediaLibrary\MediaCollections\Models\Media
      24Media.php#?
      App\Models\Review
      15Review.php#?
      App\Models\Establishment
      7Establishment.php#?
      App\Models\Visitor
      6Visitor.php#?
          ClearShow all
          Date ↕MethodURLData
          #12025-05-21 14:38:09GET/establishments/392-godavari-austin?page=2&sortby=rating298587