Ted Drewes Frozen Custard

  • (14 Reviews - 81%)

6726 Chippewa St, St. Louis, MO 63109, United States

Distance : 714 miles
Website
(314) 481-2652
Rating
A-Z
Reviews
  • Vanilla Concrete
    Rating: 100%
    Reviews: 2
    Vanilla Concrete-Ted Drewes Frozen Custard-St. Louis
  • All Shook Up Concrete
    Rating: 90%
    Reviews: 1
    All Shook Up Concrete-Ted Drewes Frozen Custard-St. Louis
  • Blue Note Concrete
    Rating: 90%
    Reviews: 1
    Blue Note Concrete-Ted Drewes Frozen Custard-St. Louis
  • Hawaiian Delight
    Rating: 90%
    Reviews: 1
    Hawaiian Delight-Ted Drewes Frozen Custard-St. Louis
  • The Mildred Concrete
    Rating: 90%
    Reviews: 1
    The Mildred Concrete-Ted Drewes Frozen Custard-St. Louis
  • Fox Treat Concrete
    Rating: 80%
    Reviews: 1
    Fox Treat Concrete-Ted Drewes Frozen Custard-St. Louis
  • Muddy Mississippi
    Rating: 80%
    Reviews: 1
    Muddy Mississippi-Ted Drewes Frozen Custard-St. Louis
  • Twisted Caramel Concrete
    Rating: 80%
    Reviews: 1
    Twisted Caramel Concrete-Ted Drewes Frozen Custard-St. Louis
  • Cardinal Sin Concrete
    Rating: 70%
    Reviews: 1
    Cardinal Sin Concrete-Ted Drewes Frozen Custard-St. Louis
  • Dottie
    Rating: 70%
    Reviews: 1
    Dottie-Ted Drewes Frozen Custard-St. Louis

Showing 1 to 10 of 13 results

© 2011-2025 Primo Analytics, Inc. All rights reserved.
MessagesRequestTimelineExceptionsViews53Queries198Models222Livewire0MailsGate
SettingsRequest history1.42sRequest Duration11MBMemory 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/123-ted-drewes-frozen-custard?page=1&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/123-ted-drewes-frozen-custard?page=1&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
    1.43s
    peak_memory
    14MB
    response
    text/html; charset=UTF-8
    request_format
    html
    request_query
      0 of 0   
    array:2 [▼
  "page" => "1"
  "sortby" => "ratingdesc"
]
    request_request
    []
    request_headers
      0 of 0   
    array:15 [▼
  "priority" => array:1 [▶
    0 => "u=0, i"
  ]
  "accept-encoding" => array:1 [▶
    0 => "gzip, deflate, br, zstd"
  ]
  "sec-fetch-dest" => array:1 [▶
    0 => "document"
  ]
  "sec-fetch-user" => array:1 [▶
    0 => "?1"
  ]
  "sec-fetch-mode" => array:1 [▶
    0 => "navigate"
  ]
  "sec-fetch-site" => array:1 [▶
    0 => "none"
  ]
  "accept" => array:1 [▶
    0 => "text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7"
  ]
  "user-agent" => array:1 [▶
    0 => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)"
  ]
  "upgrade-insecure-requests" => array:1 [▶
    0 => "1"
  ]
  "sec-ch-ua-platform" => array:1 [▶
    0 => ""Windows""
  ]
  "sec-ch-ua-mobile" => array:1 [▶
    0 => "?0"
  ]
  "sec-ch-ua" => array:1 [▶
    0 => ""Chromium";v="130", "HeadlessChrome";v="130", "Not?A_Brand";v="99""
  ]
  "cache-control" => array:1 [▶
    0 => "no-cache"
  ]
  "pragma" => array:1 [▶
    0 => "no-cache"
  ]
  "host" => array:1 [▶
    0 => "primodishnew.webmavens.com"
  ]
]
    request_cookies
    []
    response_headers
      0 of 0   
    array:3 [▼
  "content-type" => array:1 [▶
    0 => "text/html; charset=UTF-8"
  ]
  "cache-control" => array:1 [▶
    0 => "no-cache, private"
  ]
  "date" => array:1 [▶
    0 => "Tue, 10 Jun 2025 06:45:24 GMT"
  ]
]
    session_attributes
      0 of 0   
    array:5 [▼
  "_token" => "VBjInNB3QEjgiqa4HhcSTGfwPeoAdy3zKcmjRbvQ"
  "lastActivityTime" => 1749537924
  "Latitude" => "30.26715"
  "Longitude" => "-97.74306"
  "formatted_address" => "Austin, TX, USA"
]
    • Booting (18.64ms)time
    • Application (1.4s)time
    • Routing (1.01ms)
    • Preparing Response (1.38s)
    • 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: 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: 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 (98.68%)
      1.40s
      1 x Preparing Response (97.1%)
      1.38s
      1 x Booting (1.32%)
      18.64ms
      1 x Routing (0.07%)
      1.01ms
      53 x View (0%)
      0μs
      53 templates were rendered
      • 1x establishmentsestablishments.blade.php#?blade
      • 1x partials.establishmentlistingestablishmentlisting.blade.php#?blade
      • 49x partials.popup_login_buttonpopup_login_button.blade.php#?blade
      • 1x pagination::tailwindtailwind.blade.php#?blade
      • 1x layouts.mastermaster.blade.php#?blade
      198 statements were executed (148 duplicates)Show only duplicatesprimodishnew277ms
      • # Query soft limit for Debugbar is reached after 100 queries, additional 98 queries only show the query. Limits can be raised in the config (debugbar.options.db.soft_limit)
      • 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#61primodishnew2msselect * from `establishments` where `id` = '123' and `establishments`.`deleted_at` is null limit 1
        Bindings
        • 0: 123
        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#78primodishnew840μsselect count(*) as aggregate from `dishes` where `dishes`.`restaurant_id` = 123 and `dishes`.`restaurant_id` is not null and exists (select * from `establishments` where `dishes`.`restaurant_id` = `establishments`.`id` and `id` = 123 and `establishments`.`deleted_at` is null) and `dishes`.`deleted_at` is null and `moderate` = 'Approved'
        Bindings
        • 0: 123
        • 1: 123
        • 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#78primodishnew4.66msselect 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` = 123 and `dishes`.`restaurant_id` is not null and exists (select * from `establishments` where `dishes`.`restaurant_id` = `establishments`.`id` and `id` = 123 and `establishments`.`deleted_at` is null) and `dishes`.`deleted_at` is null and `moderate` = 'Approved' order by `latest_reviews_avg_rating` desc, `dish_name` asc limit 10 offset 0
        Bindings
        • 0: Approved
        • 1: Approved
        • 2: Approved
        • 3: Approved
        • 4: 123
        • 5: 123
        • 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#78primodishnew1.21msselect * 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 (332, 333, 339, 852, 855, 856, 863, 1243, 1247, 1250) 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#78primodishnew1.17msselect * from `media` where `media`.`model_id` in (454, 455, 460, 995, 998, 999, 1006, 1415, 1416, 1421, 1426) 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#545primodishnew1.03msselect * from `media` where `media`.`model_id` in (123) 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#550primodishnew970μsselect * from `dishes` where `dishes`.`restaurant_id` = 123 and `dishes`.`restaurant_id` is not null and `dishes`.`deleted_at` is null and `moderate` = 'Approved'
        Bindings
        • 0: 123
        • 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#97primodishnew1.19msselect count(*) as aggregate from `reviews` where `reviews`.`dish_id` = 330 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: 330
        • 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#151primodishnew5.13msselect 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` = 330 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: 330
        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#97primodishnew990μsselect count(*) as aggregate from `reviews` where `reviews`.`dish_id` = 331 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: 331
        • 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#151primodishnew4.42msselect 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` = 331 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: 331
        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#97primodishnew840μsselect count(*) as aggregate from `reviews` where `reviews`.`dish_id` = 332 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: 332
        • 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#151primodishnew5.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` = 332 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: 332
        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#97primodishnew800μsselect count(*) as aggregate from `reviews` where `reviews`.`dish_id` = 333 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: 333
        • 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#151primodishnew4.51msselect 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` = 333 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: 333
        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#97primodishnew830μsselect count(*) as aggregate from `reviews` where `reviews`.`dish_id` = 339 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: 339
        • 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#151primodishnew4.51msselect 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` = 339 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: 339
        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#97primodishnew8.18msselect count(*) as aggregate from `reviews` where `reviews`.`dish_id` = 852 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: 852
        • 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#151primodishnew4.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` = 852 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: 852
        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#97primodishnew7.66msselect count(*) as aggregate from `reviews` where `reviews`.`dish_id` = 855 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: 855
        • 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#151primodishnew4.37msselect 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` = 855 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: 855
        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#97primodishnew830μsselect count(*) as aggregate from `reviews` where `reviews`.`dish_id` = 856 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: 856
        • 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#151primodishnew4.26msselect 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` = 856 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: 856
        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#97primodishnew9.2msselect count(*) as aggregate from `reviews` where `reviews`.`dish_id` = 863 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: 863
        • 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#151primodishnew4.46msselect 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` = 863 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: 863
        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#97primodishnew840μsselect count(*) as aggregate from `reviews` where `reviews`.`dish_id` = 866 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: 866
        • 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#151primodishnew4.8msselect 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` = 866 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: 866
        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#97primodishnew780μsselect count(*) as aggregate from `reviews` where `reviews`.`dish_id` = 1243 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: 1243
        • 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#151primodishnew5.01msselect 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` = 1243 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: 1243
        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#97primodishnew1.1msselect count(*) as aggregate from `reviews` where `reviews`.`dish_id` = 1247 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: 1247
        • 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#151primodishnew4.81msselect 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` = 1247 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: 1247
        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#97primodishnew740μsselect count(*) as aggregate from `reviews` where `reviews`.`dish_id` = 1250 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: 1250
        • 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#151primodishnew4.41msselect 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` = 1250 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: 1250
        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#555primodishnew5.49msselect `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` = 123 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: 123
        • 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#182primodishnew3.96msselect * 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` = 123 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: 123
        • 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#182primodishnew4.72msselect * 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` = 123 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: 123
        • 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#182primodishnew4.59msselect * 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` = 123 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: 123
        • 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#182primodishnew4.3msselect * 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` = 123 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: 123
        • 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#182primodishnew3.93msselect * 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` = 123 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: 123
        • 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#182primodishnew4.25msselect * 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` = 123 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: 123
        • 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#830primodishnew620μsselect * from `dishes` where `dishes`.`id` = 852 and `dishes`.`deleted_at` is null and `moderate` = 'Approved' limit 1
        Bindings
        • 0: 852
        • 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.1msselect * from `reviews` where `reviews`.`dish_id` = 852 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: 852
        • 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#545primodishnew550μsselect * from `media` where `media`.`model_id` in (995) 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
      • InteractsWithMedia.php#545primodishnew960μsselect * from `media` where `media`.`model_id` in (1415) 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#151primodishnew6.79msselect 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` = 852 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: 852
        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#97primodishnew1.2msselect count(*) as aggregate from `reviews` where `reviews`.`dish_id` = 852 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: 852
        • 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#331primodishnew1.01msselect * from `reviews` where `reviews`.`dish_id` = 852 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: 852
        • 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#331primodishnew490μsselect * from `visitors` where `visitors`.`id` in (22, 310) 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#545primodishnew540μsselect * from `media` where `media`.`model_id` in (1415) 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#345primodishnew1.56msselect * from `establishments` where `establishments`.`id` = 123 and `establishments`.`deleted_at` is null limit 1
        Bindings
        • 0: 123
        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#597primodishnew580μsselect * from `dishes` where `dishes`.`id` = 852 and `dishes`.`deleted_at` is null and `moderate` = 'Approved' limit 1
        Bindings
        • 0: 852
        • 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#545primodishnew710μsselect * from `media` where `media`.`model_id` in (852) 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#236primodishnew890μsselect * from `establishments` where `establishments`.`id` = 123 and `establishments`.`deleted_at` is null limit 1
        Bindings
        • 0: 123
        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#545primodishnew630μsselect * from `media` where `media`.`model_id` in (123) 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.1msselect * 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
      • establishments.blade.php#597primodishnew890μsselect * from `dishes` where `dishes`.`id` = 852 and `dishes`.`deleted_at` is null and `moderate` = 'Approved' limit 1
        Bindings
        • 0: 852
        • 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#545primodishnew590μsselect * from `media` where `media`.`model_id` in (852) 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#236primodishnew750μsselect * from `establishments` where `establishments`.`id` = 123 and `establishments`.`deleted_at` is null limit 1
        Bindings
        • 0: 123
        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#545primodishnew470μsselect * from `media` where `media`.`model_id` in (123) 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 (995) 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
        • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
      • InteractsWithMedia.php#545primodishnew450μsselect * from `media` where `media`.`model_id` in (310) 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#830primodishnew760μsselect * from `dishes` where `dishes`.`id` = 855 and `dishes`.`deleted_at` is null and `moderate` = 'Approved' limit 1
        Bindings
        • 0: 855
        • 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.12msselect * from `reviews` where `reviews`.`dish_id` = 855 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: 855
        • 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#545primodishnew600μsselect * from `media` where `media`.`model_id` in (998) 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#151primodishnew4.44msselect 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` = 855 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: 855
        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#97primodishnew1.04msselect count(*) as aggregate from `reviews` where `reviews`.`dish_id` = 855 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: 855
        • 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#331primodishnew2.51msselect * from `reviews` where `reviews`.`dish_id` = 855 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: 855
        • 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#331primodishnew420μ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#545primodishnew530μsselect * from `media` where `media`.`model_id` in (998) 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` = 123 and `establishments`.`deleted_at` is null limit 1
        Bindings
        • 0: 123
        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#597primodishnew420μsselect * from `dishes` where `dishes`.`id` = 855 and `dishes`.`deleted_at` is null and `moderate` = 'Approved' limit 1
        Bindings
        • 0: 855
        • 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 (855) 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#236primodishnew480μsselect * from `establishments` where `establishments`.`id` = 123 and `establishments`.`deleted_at` is null limit 1
        Bindings
        • 0: 123
        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#545primodishnew390μsselect * from `media` where `media`.`model_id` in (123) 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#545primodishnew5.53msselect * 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#830primodishnew3.1msselect * from `dishes` where `dishes`.`id` = 863 and `dishes`.`deleted_at` is null and `moderate` = 'Approved' limit 1
        Bindings
        • 0: 863
        • 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μsselect * from `reviews` where `reviews`.`dish_id` = 863 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: 863
        • 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#545primodishnew490μsselect * from `media` where `media`.`model_id` in (1006) 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#151primodishnew5.29msselect 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` = 863 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: 863
        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#97primodishnew920μsselect count(*) as aggregate from `reviews` where `reviews`.`dish_id` = 863 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: 863
        • 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#331primodishnew830μsselect * from `reviews` where `reviews`.`dish_id` = 863 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: 863
        • 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#331primodishnew340μ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#545primodishnew460μsselect * from `media` where `media`.`model_id` in (1006) 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#345primodishnew550μsselect * from `establishments` where `establishments`.`id` = 123 and `establishments`.`deleted_at` is null limit 1
        Bindings
        • 0: 123
        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#597primodishnew410μsselect * from `dishes` where `dishes`.`id` = 863 and `dishes`.`deleted_at` is null and `moderate` = 'Approved' limit 1
        Bindings
        • 0: 863
        • 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#545primodishnew410μsselect * from `media` where `media`.`model_id` in (863) 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#236primodishnew490μsselect * from `establishments` where `establishments`.`id` = 123 and `establishments`.`deleted_at` is null limit 1
        Bindings
        • 0: 123
        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#545primodishnew400μsselect * from `media` where `media`.`model_id` in (123) 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#545primodishnew520μ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#830primodishnew920μsselect * from `dishes` where `dishes`.`id` = 333 and `dishes`.`deleted_at` is null and `moderate` = 'Approved' limit 1
        Bindings
        • 0: 333
        • 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.33msselect * from `reviews` where `reviews`.`dish_id` = 333 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: 333
        • 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#545primodishnew570μsselect * from `media` where `media`.`model_id` in (455) 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#151primodishnew5.04msselect 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` = 333 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: 333
        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#97primodishnew890μsselect count(*) as aggregate from `reviews` where `reviews`.`dish_id` = 333 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: 333
        • 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#331primodishnew960μsselect * from `reviews` where `reviews`.`dish_id` = 333 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: 333
        • 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#331primodishnew470μ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#545primodishnew720μsselect * from `media` where `media`.`model_id` in (455) 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#345primodishnew590μsselect * from `establishments` where `establishments`.`id` = 123 and `establishments`.`deleted_at` is null limit 1
        Bindings
        • 0: 123
        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#597primodishnew550μsselect * from `dishes` where `dishes`.`id` = 333 and `dishes`.`deleted_at` is null and `moderate` = 'Approved' limit 1
        Bindings
        • 0: 333
        • 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 (333) 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
      • primodishnew510μsselect * from `establishments` where `establishments`.`id` = ? and `establishments`.`deleted_at` is null limit 1
      • primodishnew410μsselect * from `media` where `media`.`model_id` in (123) and `media`.`model_type` = ?
      • primodishnew540μsselect * from `media` where `media`.`model_id` in (22) and `media`.`model_type` = ?
      • primodishnew520μsselect * from `dishes` where `dishes`.`id` = ? and `dishes`.`deleted_at` is null and `moderate` = ? limit 1
      • primodishnew820μsselect * from `reviews` where `reviews`.`dish_id` = ? 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` = ?) and `reviews`.`deleted_at` is null
      • primodishnew370μsselect * from `media` where `media`.`model_id` in (1416) and `media`.`model_type` = ?
      • primodishnew2.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` = ? 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
      • primodishnew730μsselect count(*) as aggregate from `reviews` where `reviews`.`dish_id` = ? 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` = ?) and `reviews`.`deleted_at` is null
      • primodishnew910μsselect * from `reviews` where `reviews`.`dish_id` = ? 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` = ?) and `reviews`.`deleted_at` is null order by `id` desc
      • primodishnew400μsselect * from `visitors` where `visitors`.`id` in (22) and `visitors`.`deleted_at` is null
      • primodishnew600μsselect * from `media` where `media`.`model_id` in (1416) and `media`.`model_type` = ?
      • primodishnew620μsselect * from `establishments` where `establishments`.`id` = ? and `establishments`.`deleted_at` is null limit 1
      • primodishnew540μsselect * from `dishes` where `dishes`.`id` = ? and `dishes`.`deleted_at` is null and `moderate` = ? limit 1
      • primodishnew420μsselect * from `media` where `media`.`model_id` in (1243) and `media`.`model_type` = ?
      • primodishnew440μsselect * from `establishments` where `establishments`.`id` = ? and `establishments`.`deleted_at` is null limit 1
      • primodishnew450μsselect * from `media` where `media`.`model_id` in (123) and `media`.`model_type` = ?
      • primodishnew580μsselect * from `media` where `media`.`model_id` in (22) and `media`.`model_type` = ?
      • primodishnew720μsselect * from `dishes` where `dishes`.`id` = ? and `dishes`.`deleted_at` is null and `moderate` = ? limit 1
      • primodishnew940μsselect * from `reviews` where `reviews`.`dish_id` = ? 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` = ?) and `reviews`.`deleted_at` is null
      • primodishnew770μsselect * from `media` where `media`.`model_id` in (999) and `media`.`model_type` = ?
      • primodishnew2.83msselect 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` = ? 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
      • primodishnew730μsselect count(*) as aggregate from `reviews` where `reviews`.`dish_id` = ? 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` = ?) and `reviews`.`deleted_at` is null
      • primodishnew770μsselect * from `reviews` where `reviews`.`dish_id` = ? 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` = ?) and `reviews`.`deleted_at` is null order by `id` desc
      • primodishnew350μsselect * from `visitors` where `visitors`.`id` in (22) and `visitors`.`deleted_at` is null
      • primodishnew450μsselect * from `media` where `media`.`model_id` in (999) and `media`.`model_type` = ?
      • primodishnew580μsselect * from `establishments` where `establishments`.`id` = ? and `establishments`.`deleted_at` is null limit 1
      • primodishnew440μsselect * from `dishes` where `dishes`.`id` = ? and `dishes`.`deleted_at` is null and `moderate` = ? limit 1
      • primodishnew420μsselect * from `media` where `media`.`model_id` in (856) and `media`.`model_type` = ?
      • primodishnew480μsselect * from `establishments` where `establishments`.`id` = ? and `establishments`.`deleted_at` is null limit 1
      • primodishnew390μsselect * from `media` where `media`.`model_id` in (123) and `media`.`model_type` = ?
      • primodishnew470μsselect * from `media` where `media`.`model_id` in (22) and `media`.`model_type` = ?
      • primodishnew680μsselect * from `dishes` where `dishes`.`id` = ? and `dishes`.`deleted_at` is null and `moderate` = ? limit 1
      • primodishnew850μsselect * from `reviews` where `reviews`.`dish_id` = ? 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` = ?) and `reviews`.`deleted_at` is null
      • primodishnew470μsselect * from `media` where `media`.`model_id` in (454) and `media`.`model_type` = ?
      • primodishnew2.85msselect 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` = ? 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
      • primodishnew680μsselect count(*) as aggregate from `reviews` where `reviews`.`dish_id` = ? 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` = ?) and `reviews`.`deleted_at` is null
      • primodishnew720μsselect * from `reviews` where `reviews`.`dish_id` = ? 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` = ?) and `reviews`.`deleted_at` is null order by `id` desc
      • primodishnew380μsselect * from `visitors` where `visitors`.`id` in (22) and `visitors`.`deleted_at` is null
      • primodishnew420μsselect * from `media` where `media`.`model_id` in (454) and `media`.`model_type` = ?
      • primodishnew3.28msselect * from `establishments` where `establishments`.`id` = ? and `establishments`.`deleted_at` is null limit 1
      • primodishnew350μsselect * from `dishes` where `dishes`.`id` = ? and `dishes`.`deleted_at` is null and `moderate` = ? limit 1
      • primodishnew360μsselect * from `media` where `media`.`model_id` in (332) and `media`.`model_type` = ?
      • primodishnew360μsselect * from `establishments` where `establishments`.`id` = ? and `establishments`.`deleted_at` is null limit 1
      • primodishnew310μsselect * from `media` where `media`.`model_id` in (123) and `media`.`model_type` = ?
      • primodishnew500μsselect * from `media` where `media`.`model_id` in (22) and `media`.`model_type` = ?
      • primodishnew590μsselect * from `dishes` where `dishes`.`id` = ? and `dishes`.`deleted_at` is null and `moderate` = ? limit 1
      • primodishnew890μsselect * from `reviews` where `reviews`.`dish_id` = ? 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` = ?) and `reviews`.`deleted_at` is null
      • primodishnew370μsselect * from `media` where `media`.`model_id` in (1421) and `media`.`model_type` = ?
      • primodishnew2.82msselect 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` = ? 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
      • primodishnew630μsselect count(*) as aggregate from `reviews` where `reviews`.`dish_id` = ? 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` = ?) and `reviews`.`deleted_at` is null
      • primodishnew880μsselect * from `reviews` where `reviews`.`dish_id` = ? 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` = ?) and `reviews`.`deleted_at` is null order by `id` desc
      • primodishnew280μsselect * from `visitors` where `visitors`.`id` in (22) and `visitors`.`deleted_at` is null
      • primodishnew360μsselect * from `media` where `media`.`model_id` in (1421) and `media`.`model_type` = ?
      • primodishnew450μsselect * from `establishments` where `establishments`.`id` = ? and `establishments`.`deleted_at` is null limit 1
      • primodishnew420μsselect * from `dishes` where `dishes`.`id` = ? and `dishes`.`deleted_at` is null and `moderate` = ? limit 1
      • primodishnew330μsselect * from `media` where `media`.`model_id` in (1247) and `media`.`model_type` = ?
      • primodishnew360μsselect * from `establishments` where `establishments`.`id` = ? and `establishments`.`deleted_at` is null limit 1
      • primodishnew450μsselect * from `media` where `media`.`model_id` in (123) and `media`.`model_type` = ?
      • primodishnew640μsselect * from `media` where `media`.`model_id` in (22) and `media`.`model_type` = ?
      • primodishnew1.49msselect * from `dishes` where `dishes`.`id` = ? and `dishes`.`deleted_at` is null and `moderate` = ? limit 1
      • primodishnew770μsselect * from `reviews` where `reviews`.`dish_id` = ? 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` = ?) and `reviews`.`deleted_at` is null
      • primodishnew380μsselect * from `media` where `media`.`model_id` in (1426) and `media`.`model_type` = ?
      • primodishnew2.95msselect 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` = ? 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
      • primodishnew700μsselect count(*) as aggregate from `reviews` where `reviews`.`dish_id` = ? 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` = ?) and `reviews`.`deleted_at` is null
      • primodishnew710μsselect * from `reviews` where `reviews`.`dish_id` = ? 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` = ?) and `reviews`.`deleted_at` is null order by `id` desc
      • primodishnew370μsselect * from `visitors` where `visitors`.`id` in (22) and `visitors`.`deleted_at` is null
      • primodishnew420μsselect * from `media` where `media`.`model_id` in (1426) and `media`.`model_type` = ?
      • primodishnew520μsselect * from `establishments` where `establishments`.`id` = ? and `establishments`.`deleted_at` is null limit 1
      • primodishnew430μsselect * from `dishes` where `dishes`.`id` = ? and `dishes`.`deleted_at` is null and `moderate` = ? limit 1
      • primodishnew390μsselect * from `media` where `media`.`model_id` in (1250) and `media`.`model_type` = ?
      • primodishnew440μsselect * from `establishments` where `establishments`.`id` = ? and `establishments`.`deleted_at` is null limit 1
      • primodishnew730μsselect * from `media` where `media`.`model_id` in (123) and `media`.`model_type` = ?
      • primodishnew470μsselect * from `media` where `media`.`model_id` in (22) and `media`.`model_type` = ?
      • primodishnew710μsselect * from `dishes` where `dishes`.`id` = ? and `dishes`.`deleted_at` is null and `moderate` = ? limit 1
      • primodishnew880μsselect * from `reviews` where `reviews`.`dish_id` = ? 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` = ?) and `reviews`.`deleted_at` is null
      • primodishnew450μsselect * from `media` where `media`.`model_id` in (460) and `media`.`model_type` = ?
      • primodishnew3.24msselect 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` = ? 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
      • primodishnew690μsselect count(*) as aggregate from `reviews` where `reviews`.`dish_id` = ? 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` = ?) and `reviews`.`deleted_at` is null
      • primodishnew710μsselect * from `reviews` where `reviews`.`dish_id` = ? 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` = ?) and `reviews`.`deleted_at` is null order by `id` desc
      • primodishnew370μsselect * from `visitors` where `visitors`.`id` in (22) and `visitors`.`deleted_at` is null
      • primodishnew410μsselect * from `media` where `media`.`model_id` in (460) and `media`.`model_type` = ?
      • primodishnew510μsselect * from `establishments` where `establishments`.`id` = ? and `establishments`.`deleted_at` is null limit 1
      • primodishnew420μsselect * from `dishes` where `dishes`.`id` = ? and `dishes`.`deleted_at` is null and `moderate` = ? limit 1
      • primodishnew390μsselect * from `media` where `media`.`model_id` in (339) and `media`.`model_type` = ?
      • primodishnew470μsselect * from `establishments` where `establishments`.`id` = ? and `establishments`.`deleted_at` is null limit 1
      • primodishnew410μsselect * from `media` where `media`.`model_id` in (123) and `media`.`model_type` = ?
      • primodishnew460μsselect * from `media` where `media`.`model_id` in (22) and `media`.`model_type` = ?
      • primodishnew700μsselect * from `visitors` where `visitors`.`id` = ? and `visitors`.`deleted_at` is null limit 1
      • primodishnew450μsselect * from `visitors` where `visitors`.`id` = ? and `visitors`.`deleted_at` is null limit 1
      • primodishnew570μsselect * from `visitors` where `visitors`.`id` = ? and `visitors`.`deleted_at` is null limit 1
      • primodishnew360μsselect * from `visitors` where `visitors`.`id` = ? and `visitors`.`deleted_at` is null limit 1
      • primodishnew400μsselect * from `visitors` where `visitors`.`id` = ? and `visitors`.`deleted_at` is null limit 1
      • primodishnew400μsselect * from `visitors` where `visitors`.`id` = ? and `visitors`.`deleted_at` is null limit 1
      • primodishnew370μsselect * from `visitors` where `visitors`.`id` = ? and `visitors`.`deleted_at` is null limit 1
      • primodishnew510μsselect * from `visitors` where `visitors`.`id` = ? and `visitors`.`deleted_at` is null limit 1
      • primodishnew380μsselect * from `visitors` where `visitors`.`id` = ? and `visitors`.`deleted_at` is null limit 1
      • primodishnew360μsselect * from `visitors` where `visitors`.`id` = ? and `visitors`.`deleted_at` is null limit 1
      • primodishnew380μsselect * from `visitors` where `visitors`.`id` = ? and `visitors`.`deleted_at` is null limit 1
      Spatie\MediaLibrary\MediaCollections\Models\Media
      76Media.php#?
      App\Models\Dish
      57Dish.php#?
      App\Models\Review
      45Review.php#?
      App\Models\Establishment
      22Establishment.php#?
      App\Models\Visitor
      22Visitor.php#?
          ClearShow all
          Date ↕MethodURLData
          #12025-06-10 01:45:26GET/establishments/123-ted-drewes-frozen-custard?page=1&sortby=ratingdesc53198222