Maudie's Hacienda

  • (39 Reviews - 79%)

9911 Brodie Ln #900, Austin, TX 78748, United States

Distance : 8.52 miles
Website
(512) 280-8700
Rating
A-Z
Reviews
  • 1# Lite Plate
    Rating: 70%
    Reviews: 1
    1# Lite Plate-Maudie's Hacienda-Austin
  • 5# Mexican Plate
    Rating: 100%
    Reviews: 1
    5# Mexican Plate-Maudie's Hacienda-Austin
  • Beef Chile Relleno
    Rating: 70%
    Reviews: 1
    Beef Chile Relleno-Maudie's Hacienda-Austin
  • Beef Lover’s Enchiladas
    Rating: 50%
    Reviews: 1
    Beef Lover’s Enchiladas-Maudie's Hacienda-Austin
  • Caldo
    Rating: 90%
    Reviews: 1
    Caldo-Maudie's Hacienda-Austin
  • Carne Guisada Burritos
    Rating: 100%
    Reviews: 1
    Carne Guisada Burritos-Maudie's Hacienda-Austin
  • Carnitas Burrito
    Rating: 60%
    Reviews: 1
    Carnitas Burrito-Maudie's Hacienda-Austin
  • Carnitas Tacos
    Rating: 60%
    Reviews: 1
    Carnitas Tacos-Maudie's Hacienda-Austin
  • Cena Plate
    Rating: 80%
    Reviews: 1
    Cena Plate-Maudie's Hacienda-Austin
  • Chicken Chile Relleno
    Rating: 70%
    Reviews: 1
    Chicken Chile Relleno-Maudie's Hacienda-Austin

Showing 1 to 10 of 39 results

© 2011-2025 Primo Analytics, Inc. All rights reserved.
Messages18RequestTimelineExceptionsViews50Queries242Models284Livewire0MailsGate
SettingsRequest history1.31sRequest 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/96-maudies-hacienda
action_name
establishments.show
controller_action
App\Http\Controllers\EstablishmentController@show
Theme
Open Button Position
Hide Empty Tabs
Autoshow
Reset to defaults
  • warninglog[11:16:48] LOG.warning: explode(): Passing null to parameter #2 ($string) of type string is deprecat...
  • warninglog[11:16:48] LOG.warning: explode(): Passing null to parameter #2 ($string) of type string is deprecat...
  • warninglog[11:16:48] LOG.warning: explode(): Passing null to parameter #2 ($string) of type string is deprecat...
  • warninglog[11:16:48] LOG.warning: explode(): Passing null to parameter #2 ($string) of type string is deprecat...
  • warninglog[11:16:48] LOG.warning: explode(): Passing null to parameter #2 ($string) of type string is deprecat...
  • warninglog[11:16:48] LOG.warning: explode(): Passing null to parameter #2 ($string) of type string is deprecat...
  • warninglog[11:16:48] LOG.warning: explode(): Passing null to parameter #2 ($string) of type string is deprecat...
  • warninglog[11:16:48] LOG.warning: explode(): Passing null to parameter #2 ($string) of type string is deprecat...
  • warninglog[11:16:48] LOG.warning: explode(): Passing null to parameter #2 ($string) of type string is deprecat...
  • warninglog[11:16:48] LOG.warning: explode(): Passing null to parameter #2 ($string) of type string is deprecat...
  • warninglog[11:16:48] LOG.warning: explode(): Passing null to parameter #2 ($string) of type string is deprecat...
  • warninglog[11:16:48] LOG.warning: explode(): Passing null to parameter #2 ($string) of type string is deprecat...
  • warninglog[11:16:48] LOG.warning: explode(): Passing null to parameter #2 ($string) of type string is deprecat...
  • warninglog[11:16:48] LOG.warning: explode(): Passing null to parameter #2 ($string) of type string is deprecat...
  • warninglog[11:16:48] LOG.warning: explode(): Passing null to parameter #2 ($string) of type string is deprecat...
  • warninglog[11:16:48] LOG.warning: explode(): Passing null to parameter #2 ($string) of type string is deprecat...
  • warninglog[11:16:48] LOG.warning: explode(): Passing null to parameter #2 ($string) of type string is deprecat...
  • warninglog[11:16:48] LOG.warning: explode(): Passing null to parameter #2 ($string) of type string is deprecat...
status
200 OK
full_url
https://primodishnew.webmavens.com/establishments/96-maudies-hacienda
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.33s
peak_memory
16MB
response
text/html; charset=UTF-8
request_format
html
request_query
[]
request_request
[]
request_headers
  0 of 0   
array:15 [▼
  "priority" => array:1 [▶
    0 => "u=0, i"
  ]
  "accept-encoding" => array:1 [▶
    0 => "gzip, deflate, br, zstd"
  ]
  "sec-fetch-dest" => array:1 [▶
    0 => "document"
  ]
  "sec-fetch-user" => array:1 [▶
    0 => "?1"
  ]
  "sec-fetch-mode" => array:1 [▶
    0 => "navigate"
  ]
  "sec-fetch-site" => array:1 [▶
    0 => "none"
  ]
  "accept" => array:1 [▶
    0 => "text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7"
  ]
  "user-agent" => array:1 [▶
    0 => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)"
  ]
  "upgrade-insecure-requests" => array:1 [▶
    0 => "1"
  ]
  "sec-ch-ua-platform" => array:1 [▶
    0 => ""Windows""
  ]
  "sec-ch-ua-mobile" => array:1 [▶
    0 => "?0"
  ]
  "sec-ch-ua" => array:1 [▶
    0 => ""Chromium";v="130", "HeadlessChrome";v="130", "Not?A_Brand";v="99""
  ]
  "cache-control" => array:1 [▶
    0 => "no-cache"
  ]
  "pragma" => array:1 [▶
    0 => "no-cache"
  ]
  "host" => array:1 [▶
    0 => "primodishnew.webmavens.com"
  ]
]
request_cookies
[]
response_headers
  0 of 0   
array:3 [▼
  "content-type" => array:1 [▶
    0 => "text/html; charset=UTF-8"
  ]
  "cache-control" => array:1 [▶
    0 => "no-cache, private"
  ]
  "date" => array:1 [▶
    0 => "Thu, 19 Jun 2025 16:16:47 GMT"
  ]
]
session_attributes
  0 of 0   
array:5 [▼
  "_token" => "yQf0n4p48zP8wRuoHm4jpiowVpv7361noKhbQeKb"
  "lastActivityTime" => 1750349807
  "Latitude" => "30.26715"
  "Longitude" => "-97.74306"
  "formatted_address" => "Austin, TX, USA"
]
  • Booting (12.49ms)time
  • Application (1.3s)time
  • Routing (907μs)
  • Preparing Response (1.28s)
  • 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: 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 (99.05%)
    1.30s
    1 x Preparing Response (97.7%)
    1.28s
    1 x Booting (0.95%)
    12.49ms
    1 x Routing (0.07%)
    907μs
    50 x View (0%)
    0μs
    50 templates were rendered
    • establishmentsestablishments.blade.php#?blade
    • partials.establishmentlistingestablishmentlisting.blade.php#?blade
    • partials.popup_login_buttonpopup_login_button.blade.php#?blade
    • partials.popup_login_buttonpopup_login_button.blade.php#?blade
    • partials.popup_login_buttonpopup_login_button.blade.php#?blade
    • partials.popup_login_buttonpopup_login_button.blade.php#?blade
    • partials.popup_login_buttonpopup_login_button.blade.php#?blade
    • partials.popup_login_buttonpopup_login_button.blade.php#?blade
    • partials.popup_login_buttonpopup_login_button.blade.php#?blade
    • partials.popup_login_buttonpopup_login_button.blade.php#?blade
    • partials.popup_login_buttonpopup_login_button.blade.php#?blade
    • partials.popup_login_buttonpopup_login_button.blade.php#?blade
    • partials.popup_login_buttonpopup_login_button.blade.php#?blade
    • partials.popup_login_buttonpopup_login_button.blade.php#?blade
    • partials.popup_login_buttonpopup_login_button.blade.php#?blade
    • partials.popup_login_buttonpopup_login_button.blade.php#?blade
    • partials.popup_login_buttonpopup_login_button.blade.php#?blade
    • partials.popup_login_buttonpopup_login_button.blade.php#?blade
    • partials.popup_login_buttonpopup_login_button.blade.php#?blade
    • partials.popup_login_buttonpopup_login_button.blade.php#?blade
    • partials.popup_login_buttonpopup_login_button.blade.php#?blade
    • partials.popup_login_buttonpopup_login_button.blade.php#?blade
    • partials.popup_login_buttonpopup_login_button.blade.php#?blade
    • partials.popup_login_buttonpopup_login_button.blade.php#?blade
    • partials.popup_login_buttonpopup_login_button.blade.php#?blade
    • partials.popup_login_buttonpopup_login_button.blade.php#?blade
    • partials.popup_login_buttonpopup_login_button.blade.php#?blade
    • partials.popup_login_buttonpopup_login_button.blade.php#?blade
    • partials.popup_login_buttonpopup_login_button.blade.php#?blade
    • partials.popup_login_buttonpopup_login_button.blade.php#?blade
    • partials.popup_login_buttonpopup_login_button.blade.php#?blade
    • partials.popup_login_buttonpopup_login_button.blade.php#?blade
    • partials.popup_login_buttonpopup_login_button.blade.php#?blade
    • partials.popup_login_buttonpopup_login_button.blade.php#?blade
    • partials.popup_login_buttonpopup_login_button.blade.php#?blade
    • pagination::tailwindtailwind.blade.php#?blade
    • layouts.mastermaster.blade.php#?blade
    • partials.popup_login_buttonpopup_login_button.blade.php#?blade
    • partials.popup_login_buttonpopup_login_button.blade.php#?blade
    • partials.popup_login_buttonpopup_login_button.blade.php#?blade
    • partials.popup_login_buttonpopup_login_button.blade.php#?blade
    • partials.popup_login_buttonpopup_login_button.blade.php#?blade
    • partials.popup_login_buttonpopup_login_button.blade.php#?blade
    • partials.popup_login_buttonpopup_login_button.blade.php#?blade
    • partials.popup_login_buttonpopup_login_button.blade.php#?blade
    • partials.popup_login_buttonpopup_login_button.blade.php#?blade
    • partials.popup_login_buttonpopup_login_button.blade.php#?blade
    • partials.popup_login_buttonpopup_login_button.blade.php#?blade
    • partials.popup_login_buttonpopup_login_button.blade.php#?blade
    • partials.popup_login_buttonpopup_login_button.blade.php#?blade
    242 statements were executed (139 duplicates)Show only duplicatesprimodishnew280ms
    • # Query soft limit for Debugbar is reached after 100 queries, additional 142 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#61primodishnew1.7msselect * from `establishments` where `id` = '96' and `establishments`.`deleted_at` is null limit 1
      Bindings
      • 0: 96
      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#78primodishnew810μsselect count(*) as aggregate from `dishes` where `dishes`.`restaurant_id` = 96 and `dishes`.`restaurant_id` is not null and exists (select * from `establishments` where `dishes`.`restaurant_id` = `establishments`.`id` and `id` = 96 and `establishments`.`deleted_at` is null) and `dishes`.`deleted_at` is null and `moderate` = 'Approved'
      Bindings
      • 0: 96
      • 1: 96
      • 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#78primodishnew3.95msselect 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` = 96 and `dishes`.`restaurant_id` is not null and exists (select * from `establishments` where `dishes`.`restaurant_id` = `establishments`.`id` and `id` = 96 and `establishments`.`deleted_at` is null) and `dishes`.`deleted_at` is null and `moderate` = 'Approved' order by `latest_reviews_count` desc, `dish_name` asc limit 10 offset 0
      Bindings
      • 0: Approved
      • 1: Approved
      • 2: Approved
      • 3: Approved
      • 4: 96
      • 5: 96
      • 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#78primodishnew950μsselect * from `reviews` where `id` in (select `id` from `reviews` as `r1` where `r1`.`deleted_at` is null and `r1`.`dish_id` = `reviews`.`dish_id` and `r1`.`visitor_id` = `reviews`.`visitor_id` and r1.id = ( SELECT MAX(r2.id) FROM reviews AS r2 WHERE r2.dish_id = r1.dish_id AND r2.visitor_id = r1.visitor_id AND r2.deleted_at IS NULL )) and exists (select * from `visitors` where `reviews`.`visitor_id` = `visitors`.`id` and `deleted_at` is null and `visitors`.`deleted_at` is null) and exists (select * from `dishes` where `reviews`.`dish_id` = `dishes`.`id` and `deleted_at` is null and `dishes`.`deleted_at` is null and `moderate` = 'Approved') and `reviews`.`dish_id` in (371, 467, 641, 671, 1024, 1124, 1198, 1232, 1237, 1265) 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.11msselect * from `media` where `media`.`model_id` in (495, 597, 773, 803, 1170, 1270, 1351, 1400, 1407, 1441) 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#545primodishnew530μsselect * from `media` where `media`.`model_id` in (96) 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#550primodishnew930μsselect * from `dishes` where `dishes`.`restaurant_id` = 96 and `dishes`.`restaurant_id` is not null and `dishes`.`deleted_at` is null and `moderate` = 'Approved'
      Bindings
      • 0: 96
      • 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#97primodishnew840μsselect count(*) as aggregate from `reviews` where `reviews`.`dish_id` = 257 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: 257
      • 1: Approved
      Backtrace
      • app/Models/Dish.php:97
      • view::partials.establishmentlisting:551
      • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
      • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • vendor/livewire/livewire/src/Mechanisms/ExtendBlade/ExtendedCompilerEngine.php:22
    • Dish.php#151primodishnew2.93msselect 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` = 257 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: 257
      Backtrace
      • app/Models/Dish.php:151
      • view::partials.establishmentlisting:552
      • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
      • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • vendor/livewire/livewire/src/Mechanisms/ExtendBlade/ExtendedCompilerEngine.php:22
    • Dish.php#97primodishnew720μsselect count(*) as aggregate from `reviews` where `reviews`.`dish_id` = 371 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: 371
      • 1: Approved
      Backtrace
      • app/Models/Dish.php:97
      • view::partials.establishmentlisting:551
      • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
      • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • vendor/livewire/livewire/src/Mechanisms/ExtendBlade/ExtendedCompilerEngine.php:22
    • Dish.php#151primodishnew2.73msselect 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` = 371 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: 371
      Backtrace
      • app/Models/Dish.php:151
      • view::partials.establishmentlisting:552
      • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
      • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • vendor/livewire/livewire/src/Mechanisms/ExtendBlade/ExtendedCompilerEngine.php:22
    • Dish.php#97primodishnew720μsselect count(*) as aggregate from `reviews` where `reviews`.`dish_id` = 372 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: 372
      • 1: Approved
      Backtrace
      • app/Models/Dish.php:97
      • view::partials.establishmentlisting:551
      • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
      • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • vendor/livewire/livewire/src/Mechanisms/ExtendBlade/ExtendedCompilerEngine.php:22
    • Dish.php#151primodishnew2.72msselect avg(`reviews`.`rating`) as aggregate from `reviews` inner join (SELECT dish_id, visitor_id, MAX(created_at) AS max_created_at FROM reviews WHERE deleted_at IS NULL GROUP BY dish_id, visitor_id) AS latest_reviews on `reviews`.`dish_id` = `latest_reviews`.`dish_id` and `reviews`.`visitor_id` = `latest_reviews`.`visitor_id` and `reviews`.`created_at` = `latest_reviews`.`max_created_at` inner join `dishes` on `reviews`.`dish_id` = `dishes`.`id` inner join `visitors` on `reviews`.`visitor_id` = `visitors`.`id` where `reviews`.`dish_id` = 372 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: 372
      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` = 388 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: 388
      • 1: Approved
      Backtrace
      • app/Models/Dish.php:97
      • view::partials.establishmentlisting:551
      • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
      • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • vendor/livewire/livewire/src/Mechanisms/ExtendBlade/ExtendedCompilerEngine.php:22
    • Dish.php#151primodishnew2.67msselect avg(`reviews`.`rating`) as aggregate from `reviews` inner join (SELECT dish_id, visitor_id, MAX(created_at) AS max_created_at FROM reviews WHERE deleted_at IS NULL GROUP BY dish_id, visitor_id) AS latest_reviews on `reviews`.`dish_id` = `latest_reviews`.`dish_id` and `reviews`.`visitor_id` = `latest_reviews`.`visitor_id` and `reviews`.`created_at` = `latest_reviews`.`max_created_at` inner join `dishes` on `reviews`.`dish_id` = `dishes`.`id` inner join `visitors` on `reviews`.`visitor_id` = `visitors`.`id` where `reviews`.`dish_id` = 388 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: 388
      Backtrace
      • app/Models/Dish.php:151
      • view::partials.establishmentlisting:552
      • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
      • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • vendor/livewire/livewire/src/Mechanisms/ExtendBlade/ExtendedCompilerEngine.php:22
    • Dish.php#97primodishnew720μsselect count(*) as aggregate from `reviews` where `reviews`.`dish_id` = 389 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: 389
      • 1: Approved
      Backtrace
      • app/Models/Dish.php:97
      • view::partials.establishmentlisting:551
      • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
      • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • vendor/livewire/livewire/src/Mechanisms/ExtendBlade/ExtendedCompilerEngine.php:22
    • Dish.php#151primodishnew2.7msselect 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` = 389 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: 389
      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#97primodishnew710μsselect count(*) as aggregate from `reviews` where `reviews`.`dish_id` = 390 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: 390
      • 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.77msselect avg(`reviews`.`rating`) as aggregate from `reviews` inner join (SELECT dish_id, visitor_id, MAX(created_at) AS max_created_at FROM reviews WHERE deleted_at IS NULL GROUP BY dish_id, visitor_id) AS latest_reviews on `reviews`.`dish_id` = `latest_reviews`.`dish_id` and `reviews`.`visitor_id` = `latest_reviews`.`visitor_id` and `reviews`.`created_at` = `latest_reviews`.`max_created_at` inner join `dishes` on `reviews`.`dish_id` = `dishes`.`id` inner join `visitors` on `reviews`.`visitor_id` = `visitors`.`id` where `reviews`.`dish_id` = 390 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: 390
      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#97primodishnew970μsselect count(*) as aggregate from `reviews` where `reviews`.`dish_id` = 467 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: 467
      • 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.63msselect avg(`reviews`.`rating`) as aggregate from `reviews` inner join (SELECT dish_id, visitor_id, MAX(created_at) AS max_created_at FROM reviews WHERE deleted_at IS NULL GROUP BY dish_id, visitor_id) AS latest_reviews on `reviews`.`dish_id` = `latest_reviews`.`dish_id` and `reviews`.`visitor_id` = `latest_reviews`.`visitor_id` and `reviews`.`created_at` = `latest_reviews`.`max_created_at` inner join `dishes` on `reviews`.`dish_id` = `dishes`.`id` inner join `visitors` on `reviews`.`visitor_id` = `visitors`.`id` where `reviews`.`dish_id` = 467 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: 467
      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#97primodishnew1msselect count(*) as aggregate from `reviews` where `reviews`.`dish_id` = 468 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: 468
      • 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.72msselect avg(`reviews`.`rating`) as aggregate from `reviews` inner join (SELECT dish_id, visitor_id, MAX(created_at) AS max_created_at FROM reviews WHERE deleted_at IS NULL GROUP BY dish_id, visitor_id) AS latest_reviews on `reviews`.`dish_id` = `latest_reviews`.`dish_id` and `reviews`.`visitor_id` = `latest_reviews`.`visitor_id` and `reviews`.`created_at` = `latest_reviews`.`max_created_at` inner join `dishes` on `reviews`.`dish_id` = `dishes`.`id` inner join `visitors` on `reviews`.`visitor_id` = `visitors`.`id` where `reviews`.`dish_id` = 468 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: 468
      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#97primodishnew870μsselect count(*) as aggregate from `reviews` where `reviews`.`dish_id` = 469 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: 469
      • 1: Approved
      Backtrace
      • app/Models/Dish.php:97
      • view::partials.establishmentlisting:551
      • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
      • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • vendor/livewire/livewire/src/Mechanisms/ExtendBlade/ExtendedCompilerEngine.php:22
    • Dish.php#151primodishnew2.62msselect avg(`reviews`.`rating`) as aggregate from `reviews` inner join (SELECT dish_id, visitor_id, MAX(created_at) AS max_created_at FROM reviews WHERE deleted_at IS NULL GROUP BY dish_id, visitor_id) AS latest_reviews on `reviews`.`dish_id` = `latest_reviews`.`dish_id` and `reviews`.`visitor_id` = `latest_reviews`.`visitor_id` and `reviews`.`created_at` = `latest_reviews`.`max_created_at` inner join `dishes` on `reviews`.`dish_id` = `dishes`.`id` inner join `visitors` on `reviews`.`visitor_id` = `visitors`.`id` where `reviews`.`dish_id` = 469 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: 469
      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#97primodishnew570μsselect count(*) as aggregate from `reviews` where `reviews`.`dish_id` = 470 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: 470
      • 1: Approved
      Backtrace
      • app/Models/Dish.php:97
      • view::partials.establishmentlisting:551
      • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
      • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • vendor/livewire/livewire/src/Mechanisms/ExtendBlade/ExtendedCompilerEngine.php:22
    • Dish.php#151primodishnew2.56msselect 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` = 470 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: 470
      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#97primodishnew570μsselect count(*) as aggregate from `reviews` where `reviews`.`dish_id` = 524 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: 524
      • 1: Approved
      Backtrace
      • app/Models/Dish.php:97
      • view::partials.establishmentlisting:551
      • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
      • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • vendor/livewire/livewire/src/Mechanisms/ExtendBlade/ExtendedCompilerEngine.php:22
    • Dish.php#151primodishnew2.53msselect 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` = 524 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: 524
      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#97primodishnew660μsselect count(*) as aggregate from `reviews` where `reviews`.`dish_id` = 561 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: 561
      • 1: Approved
      Backtrace
      • app/Models/Dish.php:97
      • view::partials.establishmentlisting:551
      • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
      • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • vendor/livewire/livewire/src/Mechanisms/ExtendBlade/ExtendedCompilerEngine.php:22
    • Dish.php#151primodishnew2.73msselect 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` = 561 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: 561
      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#97primodishnew570μsselect count(*) as aggregate from `reviews` where `reviews`.`dish_id` = 574 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: 574
      • 1: Approved
      Backtrace
      • app/Models/Dish.php:97
      • view::partials.establishmentlisting:551
      • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
      • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • vendor/livewire/livewire/src/Mechanisms/ExtendBlade/ExtendedCompilerEngine.php:22
    • Dish.php#151primodishnew2.55msselect 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` = 574 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: 574
      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#97primodishnew560μsselect count(*) as aggregate from `reviews` where `reviews`.`dish_id` = 576 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: 576
      • 1: Approved
      Backtrace
      • app/Models/Dish.php:97
      • view::partials.establishmentlisting:551
      • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
      • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • vendor/livewire/livewire/src/Mechanisms/ExtendBlade/ExtendedCompilerEngine.php:22
    • Dish.php#151primodishnew2.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` = 576 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: 576
      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#97primodishnew530μsselect count(*) as aggregate from `reviews` where `reviews`.`dish_id` = 577 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: 577
      • 1: Approved
      Backtrace
      • app/Models/Dish.php:97
      • view::partials.establishmentlisting:551
      • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
      • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • vendor/livewire/livewire/src/Mechanisms/ExtendBlade/ExtendedCompilerEngine.php:22
    • Dish.php#151primodishnew2.5msselect 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` = 577 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: 577
      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#97primodishnew530μsselect count(*) as aggregate from `reviews` where `reviews`.`dish_id` = 578 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: 578
      • 1: Approved
      Backtrace
      • app/Models/Dish.php:97
      • view::partials.establishmentlisting:551
      • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
      • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • vendor/livewire/livewire/src/Mechanisms/ExtendBlade/ExtendedCompilerEngine.php:22
    • Dish.php#151primodishnew2.53msselect 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` = 578 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: 578
      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#97primodishnew560μsselect count(*) as aggregate from `reviews` where `reviews`.`dish_id` = 640 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: 640
      • 1: Approved
      Backtrace
      • app/Models/Dish.php:97
      • view::partials.establishmentlisting:551
      • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
      • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • vendor/livewire/livewire/src/Mechanisms/ExtendBlade/ExtendedCompilerEngine.php:22
    • Dish.php#151primodishnew2.54msselect avg(`reviews`.`rating`) as aggregate from `reviews` inner join (SELECT dish_id, visitor_id, MAX(created_at) AS max_created_at FROM reviews WHERE deleted_at IS NULL GROUP BY dish_id, visitor_id) AS latest_reviews on `reviews`.`dish_id` = `latest_reviews`.`dish_id` and `reviews`.`visitor_id` = `latest_reviews`.`visitor_id` and `reviews`.`created_at` = `latest_reviews`.`max_created_at` inner join `dishes` on `reviews`.`dish_id` = `dishes`.`id` inner join `visitors` on `reviews`.`visitor_id` = `visitors`.`id` where `reviews`.`dish_id` = 640 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: 640
      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#97primodishnew540μsselect count(*) as aggregate from `reviews` where `reviews`.`dish_id` = 641 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: 641
      • 1: Approved
      Backtrace
      • app/Models/Dish.php:97
      • view::partials.establishmentlisting:551
      • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
      • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • vendor/livewire/livewire/src/Mechanisms/ExtendBlade/ExtendedCompilerEngine.php:22
    • Dish.php#151primodishnew2.62msselect avg(`reviews`.`rating`) as aggregate from `reviews` inner join (SELECT dish_id, visitor_id, MAX(created_at) AS max_created_at FROM reviews WHERE deleted_at IS NULL GROUP BY dish_id, visitor_id) AS latest_reviews on `reviews`.`dish_id` = `latest_reviews`.`dish_id` and `reviews`.`visitor_id` = `latest_reviews`.`visitor_id` and `reviews`.`created_at` = `latest_reviews`.`max_created_at` inner join `dishes` on `reviews`.`dish_id` = `dishes`.`id` inner join `visitors` on `reviews`.`visitor_id` = `visitors`.`id` where `reviews`.`dish_id` = 641 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: 641
      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#97primodishnew570μsselect count(*) as aggregate from `reviews` where `reviews`.`dish_id` = 647 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: 647
      • 1: Approved
      Backtrace
      • app/Models/Dish.php:97
      • view::partials.establishmentlisting:551
      • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
      • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • vendor/livewire/livewire/src/Mechanisms/ExtendBlade/ExtendedCompilerEngine.php:22
    • Dish.php#151primodishnew2.58msselect avg(`reviews`.`rating`) as aggregate from `reviews` inner join (SELECT dish_id, visitor_id, MAX(created_at) AS max_created_at FROM reviews WHERE deleted_at IS NULL GROUP BY dish_id, visitor_id) AS latest_reviews on `reviews`.`dish_id` = `latest_reviews`.`dish_id` and `reviews`.`visitor_id` = `latest_reviews`.`visitor_id` and `reviews`.`created_at` = `latest_reviews`.`max_created_at` inner join `dishes` on `reviews`.`dish_id` = `dishes`.`id` inner join `visitors` on `reviews`.`visitor_id` = `visitors`.`id` where `reviews`.`dish_id` = 647 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: 647
      Backtrace
      • app/Models/Dish.php:151
      • view::partials.establishmentlisting:552
      • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
      • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • vendor/livewire/livewire/src/Mechanisms/ExtendBlade/ExtendedCompilerEngine.php:22
    • Dish.php#97primodishnew670μsselect count(*) as aggregate from `reviews` where `reviews`.`dish_id` = 671 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: 671
      • 1: Approved
      Backtrace
      • app/Models/Dish.php:97
      • view::partials.establishmentlisting:551
      • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
      • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • vendor/livewire/livewire/src/Mechanisms/ExtendBlade/ExtendedCompilerEngine.php:22
    • Dish.php#151primodishnew2.7msselect 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` = 671 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: 671
      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#97primodishnew660μsselect count(*) as aggregate from `reviews` where `reviews`.`dish_id` = 726 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: 726
      • 1: Approved
      Backtrace
      • app/Models/Dish.php:97
      • view::partials.establishmentlisting:551
      • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
      • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • vendor/livewire/livewire/src/Mechanisms/ExtendBlade/ExtendedCompilerEngine.php:22
    • Dish.php#151primodishnew2.69msselect avg(`reviews`.`rating`) as aggregate from `reviews` inner join (SELECT dish_id, visitor_id, MAX(created_at) AS max_created_at FROM reviews WHERE deleted_at IS NULL GROUP BY dish_id, visitor_id) AS latest_reviews on `reviews`.`dish_id` = `latest_reviews`.`dish_id` and `reviews`.`visitor_id` = `latest_reviews`.`visitor_id` and `reviews`.`created_at` = `latest_reviews`.`max_created_at` inner join `dishes` on `reviews`.`dish_id` = `dishes`.`id` inner join `visitors` on `reviews`.`visitor_id` = `visitors`.`id` where `reviews`.`dish_id` = 726 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: 726
      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#97primodishnew690μsselect count(*) as aggregate from `reviews` where `reviews`.`dish_id` = 794 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: 794
      • 1: Approved
      Backtrace
      • app/Models/Dish.php:97
      • view::partials.establishmentlisting:551
      • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
      • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • vendor/livewire/livewire/src/Mechanisms/ExtendBlade/ExtendedCompilerEngine.php:22
    • Dish.php#151primodishnew2.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` = 794 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: 794
      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#97primodishnew700μsselect count(*) as aggregate from `reviews` where `reviews`.`dish_id` = 1024 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: 1024
      • 1: Approved
      Backtrace
      • app/Models/Dish.php:97
      • view::partials.establishmentlisting:551
      • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
      • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • vendor/livewire/livewire/src/Mechanisms/ExtendBlade/ExtendedCompilerEngine.php:22
    • Dish.php#151primodishnew2.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` = 1024 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: 1024
      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#97primodishnew640μsselect count(*) as aggregate from `reviews` where `reviews`.`dish_id` = 1047 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: 1047
      • 1: Approved
      Backtrace
      • app/Models/Dish.php:97
      • view::partials.establishmentlisting:551
      • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
      • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • vendor/livewire/livewire/src/Mechanisms/ExtendBlade/ExtendedCompilerEngine.php:22
    • Dish.php#151primodishnew2.66msselect 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` = 1047 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: 1047
      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#97primodishnew640μsselect count(*) as aggregate from `reviews` where `reviews`.`dish_id` = 1123 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: 1123
      • 1: Approved
      Backtrace
      • app/Models/Dish.php:97
      • view::partials.establishmentlisting:551
      • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
      • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • vendor/livewire/livewire/src/Mechanisms/ExtendBlade/ExtendedCompilerEngine.php:22
    • Dish.php#151primodishnew2.73msselect 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` = 1123 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: 1123
      Backtrace
      • app/Models/Dish.php:151
      • view::partials.establishmentlisting:552
      • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
      • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • vendor/livewire/livewire/src/Mechanisms/ExtendBlade/ExtendedCompilerEngine.php:22
    • Dish.php#97primodishnew670μsselect count(*) as aggregate from `reviews` where `reviews`.`dish_id` = 1124 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: 1124
      • 1: Approved
      Backtrace
      • app/Models/Dish.php:97
      • view::partials.establishmentlisting:551
      • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
      • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • vendor/livewire/livewire/src/Mechanisms/ExtendBlade/ExtendedCompilerEngine.php:22
    • Dish.php#151primodishnew2.58msselect avg(`reviews`.`rating`) as aggregate from `reviews` inner join (SELECT dish_id, visitor_id, MAX(created_at) AS max_created_at FROM reviews WHERE deleted_at IS NULL GROUP BY dish_id, visitor_id) AS latest_reviews on `reviews`.`dish_id` = `latest_reviews`.`dish_id` and `reviews`.`visitor_id` = `latest_reviews`.`visitor_id` and `reviews`.`created_at` = `latest_reviews`.`max_created_at` inner join `dishes` on `reviews`.`dish_id` = `dishes`.`id` inner join `visitors` on `reviews`.`visitor_id` = `visitors`.`id` where `reviews`.`dish_id` = 1124 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: 1124
      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#97primodishnew650μsselect count(*) as aggregate from `reviews` where `reviews`.`dish_id` = 1197 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: 1197
      • 1: Approved
      Backtrace
      • app/Models/Dish.php:97
      • view::partials.establishmentlisting:551
      • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
      • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • vendor/livewire/livewire/src/Mechanisms/ExtendBlade/ExtendedCompilerEngine.php:22
    • Dish.php#151primodishnew2.72msselect avg(`reviews`.`rating`) as aggregate from `reviews` inner join (SELECT dish_id, visitor_id, MAX(created_at) AS max_created_at FROM reviews WHERE deleted_at IS NULL GROUP BY dish_id, visitor_id) AS latest_reviews on `reviews`.`dish_id` = `latest_reviews`.`dish_id` and `reviews`.`visitor_id` = `latest_reviews`.`visitor_id` and `reviews`.`created_at` = `latest_reviews`.`max_created_at` inner join `dishes` on `reviews`.`dish_id` = `dishes`.`id` inner join `visitors` on `reviews`.`visitor_id` = `visitors`.`id` where `reviews`.`dish_id` = 1197 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: 1197
      Backtrace
      • app/Models/Dish.php:151
      • view::partials.establishmentlisting:552
      • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
      • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • vendor/livewire/livewire/src/Mechanisms/ExtendBlade/ExtendedCompilerEngine.php:22
    • Dish.php#97primodishnew680μsselect count(*) as aggregate from `reviews` where `reviews`.`dish_id` = 1198 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: 1198
      • 1: Approved
      Backtrace
      • app/Models/Dish.php:97
      • view::partials.establishmentlisting:551
      • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
      • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • vendor/livewire/livewire/src/Mechanisms/ExtendBlade/ExtendedCompilerEngine.php:22
    • Dish.php#151primodishnew2.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` = 1198 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: 1198
      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#97primodishnew730μsselect count(*) as aggregate from `reviews` where `reviews`.`dish_id` = 1231 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: 1231
      • 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.74msselect 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` = 1231 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: 1231
      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#97primodishnew940μsselect count(*) as aggregate from `reviews` where `reviews`.`dish_id` = 1232 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: 1232
      • 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#151primodishnew3.34msselect 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` = 1232 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: 1232
      Backtrace
      • app/Models/Dish.php:151
      • view::partials.establishmentlisting:552
      • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
      • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • vendor/livewire/livewire/src/Mechanisms/ExtendBlade/ExtendedCompilerEngine.php:22
    • Dish.php#97primodishnew720μsselect count(*) as aggregate from `reviews` where `reviews`.`dish_id` = 1233 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: 1233
      • 1: Approved
      Backtrace
      • app/Models/Dish.php:97
      • view::partials.establishmentlisting:551
      • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
      • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • vendor/livewire/livewire/src/Mechanisms/ExtendBlade/ExtendedCompilerEngine.php:22
    • Dish.php#151primodishnew2.67msselect avg(`reviews`.`rating`) as aggregate from `reviews` inner join (SELECT dish_id, visitor_id, MAX(created_at) AS max_created_at FROM reviews WHERE deleted_at IS NULL GROUP BY dish_id, visitor_id) AS latest_reviews on `reviews`.`dish_id` = `latest_reviews`.`dish_id` and `reviews`.`visitor_id` = `latest_reviews`.`visitor_id` and `reviews`.`created_at` = `latest_reviews`.`max_created_at` inner join `dishes` on `reviews`.`dish_id` = `dishes`.`id` inner join `visitors` on `reviews`.`visitor_id` = `visitors`.`id` where `reviews`.`dish_id` = 1233 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: 1233
      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#97primodishnew710μsselect count(*) as aggregate from `reviews` where `reviews`.`dish_id` = 1234 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: 1234
      • 1: Approved
      Backtrace
      • app/Models/Dish.php:97
      • view::partials.establishmentlisting:551
      • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
      • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • vendor/livewire/livewire/src/Mechanisms/ExtendBlade/ExtendedCompilerEngine.php:22
    • Dish.php#151primodishnew2.67msselect avg(`reviews`.`rating`) as aggregate from `reviews` inner join (SELECT dish_id, visitor_id, MAX(created_at) AS max_created_at FROM reviews WHERE deleted_at IS NULL GROUP BY dish_id, visitor_id) AS latest_reviews on `reviews`.`dish_id` = `latest_reviews`.`dish_id` and `reviews`.`visitor_id` = `latest_reviews`.`visitor_id` and `reviews`.`created_at` = `latest_reviews`.`max_created_at` inner join `dishes` on `reviews`.`dish_id` = `dishes`.`id` inner join `visitors` on `reviews`.`visitor_id` = `visitors`.`id` where `reviews`.`dish_id` = 1234 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: 1234
      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#97primodishnew660μsselect count(*) as aggregate from `reviews` where `reviews`.`dish_id` = 1236 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: 1236
      • 1: Approved
      Backtrace
      • app/Models/Dish.php:97
      • view::partials.establishmentlisting:551
      • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
      • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • vendor/livewire/livewire/src/Mechanisms/ExtendBlade/ExtendedCompilerEngine.php:22
    • Dish.php#151primodishnew2.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` = 1236 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: 1236
      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#97primodishnew640μsselect count(*) as aggregate from `reviews` where `reviews`.`dish_id` = 1237 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: 1237
      • 1: Approved
      Backtrace
      • app/Models/Dish.php:97
      • view::partials.establishmentlisting:551
      • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
      • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • vendor/livewire/livewire/src/Mechanisms/ExtendBlade/ExtendedCompilerEngine.php:22
    • Dish.php#151primodishnew2.76msselect 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` = 1237 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: 1237
      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#97primodishnew700μsselect count(*) as aggregate from `reviews` where `reviews`.`dish_id` = 1264 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: 1264
      • 1: Approved
      Backtrace
      • app/Models/Dish.php:97
      • view::partials.establishmentlisting:551
      • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
      • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • vendor/livewire/livewire/src/Mechanisms/ExtendBlade/ExtendedCompilerEngine.php:22
    • Dish.php#151primodishnew2.69msselect avg(`reviews`.`rating`) as aggregate from `reviews` inner join (SELECT dish_id, visitor_id, MAX(created_at) AS max_created_at FROM reviews WHERE deleted_at IS NULL GROUP BY dish_id, visitor_id) AS latest_reviews on `reviews`.`dish_id` = `latest_reviews`.`dish_id` and `reviews`.`visitor_id` = `latest_reviews`.`visitor_id` and `reviews`.`created_at` = `latest_reviews`.`max_created_at` inner join `dishes` on `reviews`.`dish_id` = `dishes`.`id` inner join `visitors` on `reviews`.`visitor_id` = `visitors`.`id` where `reviews`.`dish_id` = 1264 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: 1264
      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#97primodishnew710μsselect count(*) as aggregate from `reviews` where `reviews`.`dish_id` = 1265 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: 1265
      • 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#151primodishnew3.75msselect 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` = 1265 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: 1265
      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#97primodishnew640μsselect count(*) as aggregate from `reviews` where `reviews`.`dish_id` = 1296 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: 1296
      • 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#151primodishnew3.73msselect 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` = 1296 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: 1296
      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#97primodishnew660μsselect count(*) as aggregate from `reviews` where `reviews`.`dish_id` = 1301 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: 1301
      • 1: Approved
      Backtrace
      • app/Models/Dish.php:97
      • view::partials.establishmentlisting:551
      • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
      • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • vendor/livewire/livewire/src/Mechanisms/ExtendBlade/ExtendedCompilerEngine.php:22
    • Dish.php#151primodishnew2.58msselect avg(`reviews`.`rating`) as aggregate from `reviews` inner join (SELECT dish_id, visitor_id, MAX(created_at) AS max_created_at FROM reviews WHERE deleted_at IS NULL GROUP BY dish_id, visitor_id) AS latest_reviews on `reviews`.`dish_id` = `latest_reviews`.`dish_id` and `reviews`.`visitor_id` = `latest_reviews`.`visitor_id` and `reviews`.`created_at` = `latest_reviews`.`max_created_at` inner join `dishes` on `reviews`.`dish_id` = `dishes`.`id` inner join `visitors` on `reviews`.`visitor_id` = `visitors`.`id` where `reviews`.`dish_id` = 1301 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: 1301
      Backtrace
      • app/Models/Dish.php:151
      • view::partials.establishmentlisting:552
      • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
      • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • vendor/livewire/livewire/src/Mechanisms/ExtendBlade/ExtendedCompilerEngine.php:22
    • Dish.php#97primodishnew670μsselect count(*) as aggregate from `reviews` where `reviews`.`dish_id` = 1327 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: 1327
      • 1: Approved
      Backtrace
      • app/Models/Dish.php:97
      • view::partials.establishmentlisting:551
      • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
      • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • vendor/livewire/livewire/src/Mechanisms/ExtendBlade/ExtendedCompilerEngine.php:22
    • Dish.php#151primodishnew2.65msselect 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` = 1327 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: 1327
      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#555primodishnew1.83msselect `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` = 96 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: 96
      • 2: Approved
      • 3: 0
      Backtrace
      • view::partials.establishmentlisting:555
      • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
      • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • vendor/livewire/livewire/src/Mechanisms/ExtendBlade/ExtendedCompilerEngine.php:22
      • vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
    • EstablishmentController.php#181primodishnew2.62msselect * 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` = 96 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: 96
      • 1: Approved
      • 2: 0
      Backtrace
      • app/Http/Controllers/EstablishmentController.php:181
      • view::establishments:150
      • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
      • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • vendor/livewire/livewire/src/Mechanisms/ExtendBlade/ExtendedCompilerEngine.php:22
    • EstablishmentController.php#181primodishnew2.67msselect * 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` = 96 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: 96
      • 1: Approved
      • 2: 0
      Backtrace
      • app/Http/Controllers/EstablishmentController.php:181
      • view::establishments:159
      • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
      • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • vendor/livewire/livewire/src/Mechanisms/ExtendBlade/ExtendedCompilerEngine.php:22
    • EstablishmentController.php#181primodishnew2.55msselect * 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` = 96 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: 96
      • 1: Approved
      • 2: 0
      Backtrace
      • app/Http/Controllers/EstablishmentController.php:181
      • view::establishments:169
      • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
      • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • vendor/livewire/livewire/src/Mechanisms/ExtendBlade/ExtendedCompilerEngine.php:22
    • EstablishmentController.php#181primodishnew2.57msselect * 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` = 96 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: 96
      • 1: Approved
      • 2: 0
      Backtrace
      • app/Http/Controllers/EstablishmentController.php:181
      • view::establishments:178
      • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
      • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • vendor/livewire/livewire/src/Mechanisms/ExtendBlade/ExtendedCompilerEngine.php:22
    • EstablishmentController.php#181primodishnew2.57msselect * 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` = 96 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: 96
      • 1: Approved
      • 2: 0
      Backtrace
      • app/Http/Controllers/EstablishmentController.php:181
      • view::establishments:189
      • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
      • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • vendor/livewire/livewire/src/Mechanisms/ExtendBlade/ExtendedCompilerEngine.php:22
    • EstablishmentController.php#181primodishnew2.55msselect * 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` = 96 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: 96
      • 1: Approved
      • 2: 0
      Backtrace
      • app/Http/Controllers/EstablishmentController.php:181
      • view::establishments:200
      • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
      • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • vendor/livewire/livewire/src/Mechanisms/ExtendBlade/ExtendedCompilerEngine.php:22
    • DishController.php#830primodishnew410μsselect * from `dishes` where `dishes`.`id` = 1265 and `dishes`.`deleted_at` is null and `moderate` = 'Approved' limit 1
      Bindings
      • 0: 1265
      • 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#832primodishnew690μsselect * from `reviews` where `reviews`.`dish_id` = 1265 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: 1265
      • 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#545primodishnew1.65msselect * from `media` where `media`.`model_id` in (1441) and `media`.`model_type` = 'App\\Models\\Review'
      Bindings
      • 0: App\Models\Review
      Backtrace
      • vendor/spatie/laravel-medialibrary/src/InteractsWithMedia.php:545
      • vendor/spatie/laravel-medialibrary/src/MediaCollections/MediaRepository.php:31
      • vendor/spatie/laravel-medialibrary/src/InteractsWithMedia.php:271
      • app/Models/Review.php:125
      • app/Http/Controllers/DishController.php:833
    • Dish.php#151primodishnew2.72msselect avg(`reviews`.`rating`) as aggregate from `reviews` inner join (SELECT dish_id, visitor_id, MAX(created_at) AS max_created_at FROM reviews WHERE deleted_at IS NULL GROUP BY dish_id, visitor_id) AS latest_reviews on `reviews`.`dish_id` = `latest_reviews`.`dish_id` and `reviews`.`visitor_id` = `latest_reviews`.`visitor_id` and `reviews`.`created_at` = `latest_reviews`.`max_created_at` inner join `dishes` on `reviews`.`dish_id` = `dishes`.`id` inner join `visitors` on `reviews`.`visitor_id` = `visitors`.`id` where `reviews`.`dish_id` = 1265 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: 1265
      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#97primodishnew700μsselect count(*) as aggregate from `reviews` where `reviews`.`dish_id` = 1265 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: 1265
      • 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#331primodishnew720μsselect * from `reviews` where `reviews`.`dish_id` = 1265 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: 1265
      • 1: Approved
      Backtrace
      • view::establishments:331
      • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
      • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • vendor/livewire/livewire/src/Mechanisms/ExtendBlade/ExtendedCompilerEngine.php:22
      • vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
    • establishments.blade.php#331primodishnew350μsselect * from `visitors` where `visitors`.`id` in (22) and `visitors`.`deleted_at` is null
      Backtrace
      • view::establishments:331
      • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
      • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • vendor/livewire/livewire/src/Mechanisms/ExtendBlade/ExtendedCompilerEngine.php:22
      • vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
    • InteractsWithMedia.php#545primodishnew450μsselect * from `media` where `media`.`model_id` in (1441) 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
    • primodishnew550μ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
    • primodishnew430μsselect * from `media` where `media`.`model_id` in (1265) and `media`.`model_type` = ?
    • primodishnew430μsselect * from `establishments` where `establishments`.`id` = ? and `establishments`.`deleted_at` is null limit 1
    • primodishnew480μsselect * from `media` where `media`.`model_id` in (96) and `media`.`model_type` = ?
    • primodishnew690μsselect * from `media` where `media`.`model_id` in (22) and `media`.`model_type` = ?
    • primodishnew2.06msselect * 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
    • primodishnew510μsselect * from `media` where `media`.`model_id` in (1400) and `media`.`model_type` = ?
    • primodishnew2.84msselect avg(`reviews`.`rating`) as aggregate from `reviews` inner join (SELECT dish_id, visitor_id, MAX(created_at) AS max_created_at FROM reviews WHERE deleted_at IS NULL GROUP BY dish_id, visitor_id) AS latest_reviews on `reviews`.`dish_id` = `latest_reviews`.`dish_id` and `reviews`.`visitor_id` = `latest_reviews`.`visitor_id` and `reviews`.`created_at` = `latest_reviews`.`max_created_at` inner join `dishes` on `reviews`.`dish_id` = `dishes`.`id` inner join `visitors` on `reviews`.`visitor_id` = `visitors`.`id` where `reviews`.`dish_id` = ? 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
    • primodishnew740μ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
    • primodishnew340μsselect * from `visitors` where `visitors`.`id` in (22) and `visitors`.`deleted_at` is null
    • primodishnew410μsselect * from `media` where `media`.`model_id` in (1400) and `media`.`model_type` = ?
    • primodishnew1.38msselect * from `establishments` where `establishments`.`id` = ? and `establishments`.`deleted_at` is null limit 1
    • primodishnew480μsselect * from `dishes` where `dishes`.`id` = ? and `dishes`.`deleted_at` is null and `moderate` = ? limit 1
    • primodishnew690μsselect * from `media` where `media`.`model_id` in (1232) and `media`.`model_type` = ?
    • primodishnew620μsselect * from `establishments` where `establishments`.`id` = ? and `establishments`.`deleted_at` is null limit 1
    • primodishnew440μsselect * from `media` where `media`.`model_id` in (96) and `media`.`model_type` = ?
    • primodishnew500μsselect * from `media` where `media`.`model_id` in (22) and `media`.`model_type` = ?
    • primodishnew740μ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
    • primodishnew490μsselect * from `media` where `media`.`model_id` in (1270) and `media`.`model_type` = ?
    • primodishnew2.77msselect avg(`reviews`.`rating`) as aggregate from `reviews` inner join (SELECT dish_id, visitor_id, MAX(created_at) AS max_created_at FROM reviews WHERE deleted_at IS NULL GROUP BY dish_id, visitor_id) AS latest_reviews on `reviews`.`dish_id` = `latest_reviews`.`dish_id` and `reviews`.`visitor_id` = `latest_reviews`.`visitor_id` and `reviews`.`created_at` = `latest_reviews`.`max_created_at` inner join `dishes` on `reviews`.`dish_id` = `dishes`.`id` inner join `visitors` on `reviews`.`visitor_id` = `visitors`.`id` where `reviews`.`dish_id` = ? 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
    • primodishnew720μ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
    • primodishnew740μ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
    • primodishnew450μsselect * from `media` where `media`.`model_id` in (1270) and `media`.`model_type` = ?
    • primodishnew630μsselect * from `establishments` where `establishments`.`id` = ? and `establishments`.`deleted_at` is null limit 1
    • primodishnew450μsselect * from `dishes` where `dishes`.`id` = ? and `dishes`.`deleted_at` is null and `moderate` = ? limit 1
    • primodishnew440μsselect * from `media` where `media`.`model_id` in (1124) and `media`.`model_type` = ?
    • primodishnew430μsselect * from `establishments` where `establishments`.`id` = ? and `establishments`.`deleted_at` is null limit 1
    • primodishnew460μsselect * from `media` where `media`.`model_id` in (96) and `media`.`model_type` = ?
    • primodishnew590μsselect * from `media` where `media`.`model_id` in (22) and `media`.`model_type` = ?
    • primodishnew580μsselect * from `dishes` where `dishes`.`id` = ? and `dishes`.`deleted_at` is null and `moderate` = ? limit 1
    • primodishnew840μ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
    • primodishnew460μsselect * from `media` where `media`.`model_id` in (773) and `media`.`model_type` = ?
    • primodishnew3msselect 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
    • primodishnew740μ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
    • primodishnew730μ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
    • primodishnew440μsselect * from `media` where `media`.`model_id` in (773) and `media`.`model_type` = ?
    • primodishnew560μ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 (641) and `media`.`model_type` = ?
    • primodishnew440μsselect * from `establishments` where `establishments`.`id` = ? and `establishments`.`deleted_at` is null limit 1
    • primodishnew440μsselect * from `media` where `media`.`model_id` in (96) and `media`.`model_type` = ?
    • primodishnew580μ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
    • primodishnew470μsselect * from `media` where `media`.`model_id` in (1351) and `media`.`model_type` = ?
    • primodishnew2.86msselect 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
    • primodishnew730μ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
    • primodishnew440μsselect * from `media` where `media`.`model_id` in (1351) and `media`.`model_type` = ?
    • primodishnew620μsselect * from `establishments` where `establishments`.`id` = ? and `establishments`.`deleted_at` is null limit 1
    • primodishnew450μsselect * from `dishes` where `dishes`.`id` = ? and `dishes`.`deleted_at` is null and `moderate` = ? limit 1
    • primodishnew430μsselect * from `media` where `media`.`model_id` in (1198) and `media`.`model_type` = ?
    • primodishnew470μsselect * from `establishments` where `establishments`.`id` = ? and `establishments`.`deleted_at` is null limit 1
    • primodishnew470μsselect * from `media` where `media`.`model_id` in (96) and `media`.`model_type` = ?
    • primodishnew720μsselect * from `media` where `media`.`model_id` in (22) and `media`.`model_type` = ?
    • primodishnew630μsselect * from `dishes` where `dishes`.`id` = ? and `dishes`.`deleted_at` is null and `moderate` = ? limit 1
    • primodishnew790μ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
    • primodishnew400μsselect * from `media` where `media`.`model_id` in (1170) 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
    • primodishnew790μ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
    • primodishnew780μ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
    • primodishnew450μsselect * from `media` where `media`.`model_id` in (1170) and `media`.`model_type` = ?
    • primodishnew530μ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
    • primodishnew410μsselect * from `media` where `media`.`model_id` in (1024) and `media`.`model_type` = ?
    • primodishnew430μsselect * from `establishments` where `establishments`.`id` = ? and `establishments`.`deleted_at` is null limit 1
    • primodishnew450μsselect * from `media` where `media`.`model_id` in (96) and `media`.`model_type` = ?
    • primodishnew590μsselect * from `media` where `media`.`model_id` in (22) and `media`.`model_type` = ?
    • primodishnew730μ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
    • primodishnew480μsselect * from `media` where `media`.`model_id` in (1407) and `media`.`model_type` = ?
    • primodishnew2.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` = ? 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
    • primodishnew830μ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
    • primodishnew750μ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
    • primodishnew390μsselect * from `visitors` where `visitors`.`id` in (22) and `visitors`.`deleted_at` is null
    • primodishnew470μsselect * from `media` where `media`.`model_id` in (1407) and `media`.`model_type` = ?
    • primodishnew550μsselect * from `establishments` where `establishments`.`id` = ? and `establishments`.`deleted_at` is null limit 1
    • primodishnew1.57msselect * from `dishes` where `dishes`.`id` = ? and `dishes`.`deleted_at` is null and `moderate` = ? limit 1
    • primodishnew390μsselect * from `media` where `media`.`model_id` in (1237) and `media`.`model_type` = ?
    • primodishnew520μsselect * from `establishments` where `establishments`.`id` = ? and `establishments`.`deleted_at` is null limit 1
    • primodishnew460μsselect * from `media` where `media`.`model_id` in (96) and `media`.`model_type` = ?
    • primodishnew530μsselect * from `media` where `media`.`model_id` in (22) and `media`.`model_type` = ?
    • primodishnew650μsselect * 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
    • primodishnew370μsselect * from `media` where `media`.`model_id` in (597) and `media`.`model_type` = ?
    • primodishnew2.69msselect avg(`reviews`.`rating`) as aggregate from `reviews` inner join (SELECT dish_id, visitor_id, MAX(created_at) AS max_created_at FROM reviews WHERE deleted_at IS NULL GROUP BY dish_id, visitor_id) AS latest_reviews on `reviews`.`dish_id` = `latest_reviews`.`dish_id` and `reviews`.`visitor_id` = `latest_reviews`.`visitor_id` and `reviews`.`created_at` = `latest_reviews`.`max_created_at` inner join `dishes` on `reviews`.`dish_id` = `dishes`.`id` inner join `visitors` on `reviews`.`visitor_id` = `visitors`.`id` where `reviews`.`dish_id` = ? 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
    • primodishnew770μ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
    • primodishnew620μ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
    • primodishnew290μsselect * from `visitors` where `visitors`.`id` in (22) and `visitors`.`deleted_at` is null
    • primodishnew340μsselect * from `media` where `media`.`model_id` in (597) and `media`.`model_type` = ?
    • primodishnew410μsselect * from `establishments` where `establishments`.`id` = ? and `establishments`.`deleted_at` is null limit 1
    • primodishnew330μsselect * from `dishes` where `dishes`.`id` = ? and `dishes`.`deleted_at` is null and `moderate` = ? limit 1
    • primodishnew310μsselect * from `media` where `media`.`model_id` in (467) and `media`.`model_type` = ?
    • primodishnew350μsselect * from `establishments` where `establishments`.`id` = ? and `establishments`.`deleted_at` is null limit 1
    • primodishnew360μsselect * from `media` where `media`.`model_id` in (96) and `media`.`model_type` = ?
    • primodishnew400μ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
    • primodishnew760μ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
    • primodishnew400μsselect * from `media` where `media`.`model_id` in (803) and `media`.`model_type` = ?
    • primodishnew3.11msselect 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
    • primodishnew840μ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
    • primodishnew790μ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
    • primodishnew420μsselect * from `visitors` where `visitors`.`id` in (22) and `visitors`.`deleted_at` is null
    • primodishnew480μsselect * from `media` where `media`.`model_id` in (803) and `media`.`model_type` = ?
    • primodishnew720μsselect * from `establishments` where `establishments`.`id` = ? and `establishments`.`deleted_at` is null limit 1
    • primodishnew500μsselect * from `dishes` where `dishes`.`id` = ? and `dishes`.`deleted_at` is null and `moderate` = ? limit 1
    • primodishnew490μsselect * from `media` where `media`.`model_id` in (671) and `media`.`model_type` = ?
    • primodishnew470μsselect * from `establishments` where `establishments`.`id` = ? and `establishments`.`deleted_at` is null limit 1
    • primodishnew450μsselect * from `media` where `media`.`model_id` in (96) and `media`.`model_type` = ?
    • primodishnew740μsselect * from `media` where `media`.`model_id` in (22) and `media`.`model_type` = ?
    • primodishnew670μsselect * from `dishes` where `dishes`.`id` = ? and `dishes`.`deleted_at` is null and `moderate` = ? limit 1
    • primodishnew900μ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 (495) 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
    • primodishnew750μ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
    • primodishnew730μ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
    • primodishnew3.07msselect * from `visitors` where `visitors`.`id` in (22) and `visitors`.`deleted_at` is null
    • primodishnew460μsselect * from `media` where `media`.`model_id` in (495) and `media`.`model_type` = ?
    • primodishnew580μsselect * from `establishments` where `establishments`.`id` = ? and `establishments`.`deleted_at` is null limit 1
    • primodishnew460μsselect * from `dishes` where `dishes`.`id` = ? and `dishes`.`deleted_at` is null and `moderate` = ? limit 1
    • primodishnew440μsselect * from `media` where `media`.`model_id` in (371) and `media`.`model_type` = ?
    • primodishnew510μsselect * from `establishments` where `establishments`.`id` = ? and `establishments`.`deleted_at` is null limit 1
    • primodishnew460μsselect * from `media` where `media`.`model_id` in (96) and `media`.`model_type` = ?
    • primodishnew590μsselect * from `media` where `media`.`model_id` in (22) and `media`.`model_type` = ?
    • primodishnew710μsselect * from `visitors` where `visitors`.`id` = ? and `visitors`.`deleted_at` is null limit 1
    • primodishnew440μsselect * from `visitors` where `visitors`.`id` = ? and `visitors`.`deleted_at` is null limit 1
    • primodishnew440μsselect * from `visitors` where `visitors`.`id` = ? and `visitors`.`deleted_at` is null limit 1
    • primodishnew390μsselect * from `visitors` where `visitors`.`id` = ? and `visitors`.`deleted_at` is null limit 1
    • primodishnew390μ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
    • primodishnew370μsselect * from `visitors` where `visitors`.`id` = ? and `visitors`.`deleted_at` is null limit 1
    • primodishnew350μ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
    • primodishnew400μsselect * from `visitors` where `visitors`.`id` = ? and `visitors`.`deleted_at` is null limit 1
    App\Models\Dish
    108Dish.php#?
    Spatie\MediaLibrary\MediaCollections\Models\Media
    93Media.php#?
    App\Models\Review
    42Review.php#?
    App\Models\Establishment
    21Establishment.php#?
    App\Models\Visitor
    20Visitor.php#?
        ClearShow all
        Date ↕MethodURLData
        #12025-06-19 11:16:48GET/establishments/96-maudies-hacienda1850242284