To Bookmark and Save this Restaurant for later, you'll need to:
To Share this Restaurant with a fellow PrimoDish Friend, you'll need to:
To Add or Review a Dish at this Restaurant, you'll need to:
12233 Ranch Rd 620 N #205, Austin, TX 78750, United States
Distance : 14 miles1/1
To Bookmark and Save this Review for later, you'll need to:
To Share this Review with a fellow PrimoDish Friend, you'll need to:
To Record Your Thoughts and Rate This Dish, you'll need to:
LOTS of cilantro, so... not my fav, Chicken was cooked well and was quite tender and moist. - Fritz (Austin, Texas)
1/1
To Bookmark and Save this Review for later, you'll need to:
To Share this Review with a fellow PrimoDish Friend, you'll need to:
To Record Your Thoughts and Rate This Dish, you'll need to:
Avg spices, flavor, meat in a sauce. Nothing exciting. - Fritz (Austin, Texas)
1/1
To Bookmark and Save this Review for later, you'll need to:
To Share this Review with a fellow PrimoDish Friend, you'll need to:
To Record Your Thoughts and Rate This Dish, you'll need to:
A mango pudding w/ immersed various fruits. Fruits might have been canned? - Fritz (Austin, Texas)
1/1
To Bookmark and Save this Review for later, you'll need to:
To Share this Review with a fellow PrimoDish Friend, you'll need to:
To Record Your Thoughts and Rate This Dish, you'll need to:
Judging by bright color I was hoping for some heat, a spicy kick, but more mild. Not a lot of flavor either. Good dipped in other sauces. - Fritz (Austin, Texas)
1/1
To Bookmark and Save this Review for later, you'll need to:
To Share this Review with a fellow PrimoDish Friend, you'll need to:
To Record Your Thoughts and Rate This Dish, you'll need to:
Pic got corrupted. A mild savory version of cream of wheat w/ herbs. Needed some salt to bring out flavors. - Fritz (Austin, Texas)
1/1
To Bookmark and Save this Review for later, you'll need to:
To Share this Review with a fellow PrimoDish Friend, you'll need to:
To Record Your Thoughts and Rate This Dish, you'll need to:
Okra w/ some other savory veggies and peppers. Not quite as exciting as I'd hoped. Not much heat and no acidity. Needed both. - Fritz (Austin, Texas)
1/1
To Bookmark and Save this Review for later, you'll need to:
To Share this Review with a fellow PrimoDish Friend, you'll need to:
To Record Your Thoughts and Rate This Dish, you'll need to:
A little hotter than expected and the sauce was not as thick or creamy as others. - Fritz (Austin, Texas)
1/1
To Bookmark and Save this Review for later, you'll need to:
To Share this Review with a fellow PrimoDish Friend, you'll need to:
To Record Your Thoughts and Rate This Dish, you'll need to:
Rendered chicken fat from the chicken & fried onions added a richness the Veg version was missing. Same great spices though. - Fritz (Austin, Texas)
1/1
To Bookmark and Save this Review for later, you'll need to:
To Share this Review with a fellow PrimoDish Friend, you'll need to:
To Record Your Thoughts and Rate This Dish, you'll need to:
Tender white fish in a warm rich savory sauce. Ended up trying lots of other things but probably should have gotten a 2nd helping. - Fritz (Austin, Texas)
1/1
To Bookmark and Save this Review for later, you'll need to:
To Share this Review with a fellow PrimoDish Friend, you'll need to:
To Record Your Thoughts and Rate This Dish, you'll need to:
Fried cauliflower I think. Nice breading & warm flavors. Maybe just a little heat & a little salt and this could have been a 9. - Fritz (Austin, Texas)
Showing 1 to 10 of 13 results
0 of 0array:2 [▼ "page" => "1" "sortby" => "rating" ]
[]
0 of 0array: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" ] ]
[]
0 of 0array:3 [▼ "content-type" => array:1 [▶ 0 => "text/html; charset=UTF-8" ] "cache-control" => array:1 [▶ 0 => "no-cache, private" ] "date" => array:1 [▶ 0 => "Sat, 07 Jun 2025 18:53:02 GMT" ] ]
0 of 0array:5 [▼ "_token" => "EMW4sL72Eas8mAokdYbL988WViuz0oRHH17nuBSI" "lastActivityTime" => 1749322382 "Latitude" => "30.26715" "Longitude" => "-97.74306" "formatted_address" => "Austin, TX, USA" ]
1 x Application (98.3%) | 2.29s |
1 x Preparing Response (96.05%) | 2.24s |
1 x Booting (1.7%) | 39.65ms |
1 x Routing (0.07%) | 1.58ms |
50 x View (0%) | 0μs |
# Query soft limit for Debugbar is reached after 100 queries, additional 90 queries only show the query. Limits can be raised in the config (debugbar.options.db.soft_limit)
Backtrace |
|
select * from `establishments` where `id` = '392' and `establishments`.`deleted_at` is null limit 1
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `dishes` where `dishes`.`restaurant_id` = 392 and `dishes`.`restaurant_id` is not null and exists (select * from `establishments` where `dishes`.`restaurant_id` = `establishments`.`id` and `id` = 392 and `establishments`.`deleted_at` is null) and `dishes`.`deleted_at` is null and `moderate` = 'Approved'
Bindings |
|
Backtrace |
|
select distinct `dishes`.*, (select avg(`reviews`.`rating`) from `reviews` where `dishes`.`id` = `reviews`.`dish_id` and `id` in (select `id` from `reviews` as `r1` where `r1`.`deleted_at` is null and `r1`.`dish_id` = `reviews`.`dish_id` and `r1`.`visitor_id` = `reviews`.`visitor_id` and r1.id = (
SELECT MAX(r2.id)
FROM reviews AS r2
WHERE r2.dish_id = r1.dish_id
AND r2.visitor_id = r1.visitor_id
AND r2.deleted_at IS NULL
)) and exists (select * from `visitors` where `reviews`.`visitor_id` = `visitors`.`id` and `deleted_at` is null and `visitors`.`deleted_at` is null) and exists (select * from `dishes` where `reviews`.`dish_id` = `dishes`.`id` and `deleted_at` is null and `dishes`.`deleted_at` is null and `moderate` = 'Approved') and `reviews`.`deleted_at` is null) as `latest_reviews_avg_rating`, (select count(*) from `reviews` where `dishes`.`id` = `reviews`.`dish_id` and `id` in (select `id` from `reviews` as `r1` where `r1`.`deleted_at` is null and `r1`.`dish_id` = `reviews`.`dish_id` and `r1`.`visitor_id` = `reviews`.`visitor_id` and r1.id = (
SELECT MAX(r2.id)
FROM reviews AS r2
WHERE r2.dish_id = r1.dish_id
AND r2.visitor_id = r1.visitor_id
AND r2.deleted_at IS NULL
)) and exists (select * from `visitors` where `reviews`.`visitor_id` = `visitors`.`id` and `deleted_at` is null and `visitors`.`deleted_at` is null) and exists (select * from `dishes` where `reviews`.`dish_id` = `dishes`.`id` and `deleted_at` is null and `dishes`.`deleted_at` is null and `moderate` = 'Approved') and `reviews`.`deleted_at` is null) as `latest_reviews_count`, (select min(`reviews`.`price_at_time_of_review`) from `reviews` where `dishes`.`id` = `reviews`.`dish_id` and `id` in (select `id` from `reviews` as `r1` where `r1`.`deleted_at` is null and `r1`.`dish_id` = `reviews`.`dish_id` and `r1`.`visitor_id` = `reviews`.`visitor_id` and r1.id = (
SELECT MAX(r2.id)
FROM reviews AS r2
WHERE r2.dish_id = r1.dish_id
AND r2.visitor_id = r1.visitor_id
AND r2.deleted_at IS NULL
)) and exists (select * from `visitors` where `reviews`.`visitor_id` = `visitors`.`id` and `deleted_at` is null and `visitors`.`deleted_at` is null) and exists (select * from `dishes` where `reviews`.`dish_id` = `dishes`.`id` and `deleted_at` is null and `dishes`.`deleted_at` is null and `moderate` = 'Approved') and `reviews`.`deleted_at` is null) as `min_price`, (select max(`reviews`.`price_at_time_of_review`) from `reviews` where `dishes`.`id` = `reviews`.`dish_id` and `id` in (select `id` from `reviews` as `r1` where `r1`.`deleted_at` is null and `r1`.`dish_id` = `reviews`.`dish_id` and `r1`.`visitor_id` = `reviews`.`visitor_id` and r1.id = (
SELECT MAX(r2.id)
FROM reviews AS r2
WHERE r2.dish_id = r1.dish_id
AND r2.visitor_id = r1.visitor_id
AND r2.deleted_at IS NULL
)) and exists (select * from `visitors` where `reviews`.`visitor_id` = `visitors`.`id` and `deleted_at` is null and `visitors`.`deleted_at` is null) and exists (select * from `dishes` where `reviews`.`dish_id` = `dishes`.`id` and `deleted_at` is null and `dishes`.`deleted_at` is null and `moderate` = 'Approved') and `reviews`.`deleted_at` is null) as `max_price` from `dishes` where `dishes`.`restaurant_id` = 392 and `dishes`.`restaurant_id` is not null and exists (select * from `establishments` where `dishes`.`restaurant_id` = `establishments`.`id` and `id` = 392 and `establishments`.`deleted_at` is null) and `dishes`.`deleted_at` is null and `moderate` = 'Approved' order by `latest_reviews_avg_rating` asc, `dish_name` asc limit 10 offset 0
Bindings |
|
Backtrace |
|
select * from `reviews` where `id` in (select `id` from `reviews` as `r1` where `r1`.`deleted_at` is null and `r1`.`dish_id` = `reviews`.`dish_id` and `r1`.`visitor_id` = `reviews`.`visitor_id` and r1.id = (
SELECT MAX(r2.id)
FROM reviews AS r2
WHERE r2.dish_id = r1.dish_id
AND r2.visitor_id = r1.visitor_id
AND r2.deleted_at IS NULL
)) and exists (select * from `visitors` where `reviews`.`visitor_id` = `visitors`.`id` and `deleted_at` is null and `visitors`.`deleted_at` is null) and exists (select * from `dishes` where `reviews`.`dish_id` = `dishes`.`id` and `deleted_at` is null and `dishes`.`deleted_at` is null and `moderate` = 'Approved') and `reviews`.`dish_id` in (1184, 1185, 1186, 1187, 1189, 1190, 1191, 1193, 1195, 1196) and `reviews`.`deleted_at` is null
Bindings |
|
Backtrace |
|
select * from `media` where `media`.`model_id` in (1336, 1337, 1338, 1339, 1341, 1342, 1343, 1345, 1347, 1348) and `media`.`model_type` = 'App\\Models\\Review'
Bindings |
|
Backtrace |
|
select * from `media` where `media`.`model_id` in (392) and `media`.`model_type` = 'App\\Models\\Establishment'
Bindings |
|
Backtrace |
|
select * from `dishes` where `dishes`.`restaurant_id` = 392 and `dishes`.`restaurant_id` is not null and `dishes`.`deleted_at` is null and `moderate` = 'Approved'
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `reviews` where `reviews`.`dish_id` = 1184 and `reviews`.`dish_id` is not null and `id` in (select `id` from `reviews` as `r1` where `r1`.`deleted_at` is null and `r1`.`dish_id` = `reviews`.`dish_id` and `r1`.`visitor_id` = `reviews`.`visitor_id` and r1.id = (
SELECT MAX(r2.id)
FROM reviews AS r2
WHERE r2.dish_id = r1.dish_id
AND r2.visitor_id = r1.visitor_id
AND r2.deleted_at IS NULL
)) and exists (select * from `visitors` where `reviews`.`visitor_id` = `visitors`.`id` and `deleted_at` is null and `visitors`.`deleted_at` is null) and exists (select * from `dishes` where `reviews`.`dish_id` = `dishes`.`id` and `deleted_at` is null and `dishes`.`deleted_at` is null and `moderate` = 'Approved') and `reviews`.`deleted_at` is null
Bindings |
|
Backtrace |
|
select avg(`reviews`.`rating`) as aggregate from `reviews` inner join (SELECT dish_id, visitor_id, MAX(created_at) AS max_created_at
FROM reviews
WHERE deleted_at IS NULL
GROUP BY dish_id, visitor_id) AS latest_reviews on `reviews`.`dish_id` = `latest_reviews`.`dish_id` and `reviews`.`visitor_id` = `latest_reviews`.`visitor_id` and `reviews`.`created_at` = `latest_reviews`.`max_created_at` inner join `dishes` on `reviews`.`dish_id` = `dishes`.`id` inner join `visitors` on `reviews`.`visitor_id` = `visitors`.`id` where `reviews`.`dish_id` = 1184 and `reviews`.`dish_id` is not null and `dishes`.`deleted_at` is null and `visitors`.`deleted_at` is null and `reviews`.`deleted_at` is null
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `reviews` where `reviews`.`dish_id` = 1185 and `reviews`.`dish_id` is not null and `id` in (select `id` from `reviews` as `r1` where `r1`.`deleted_at` is null and `r1`.`dish_id` = `reviews`.`dish_id` and `r1`.`visitor_id` = `reviews`.`visitor_id` and r1.id = (
SELECT MAX(r2.id)
FROM reviews AS r2
WHERE r2.dish_id = r1.dish_id
AND r2.visitor_id = r1.visitor_id
AND r2.deleted_at IS NULL
)) and exists (select * from `visitors` where `reviews`.`visitor_id` = `visitors`.`id` and `deleted_at` is null and `visitors`.`deleted_at` is null) and exists (select * from `dishes` where `reviews`.`dish_id` = `dishes`.`id` and `deleted_at` is null and `dishes`.`deleted_at` is null and `moderate` = 'Approved') and `reviews`.`deleted_at` is null
Bindings |
|
Backtrace |
|
select avg(`reviews`.`rating`) as aggregate from `reviews` inner join (SELECT dish_id, visitor_id, MAX(created_at) AS max_created_at
FROM reviews
WHERE deleted_at IS NULL
GROUP BY dish_id, visitor_id) AS latest_reviews on `reviews`.`dish_id` = `latest_reviews`.`dish_id` and `reviews`.`visitor_id` = `latest_reviews`.`visitor_id` and `reviews`.`created_at` = `latest_reviews`.`max_created_at` inner join `dishes` on `reviews`.`dish_id` = `dishes`.`id` inner join `visitors` on `reviews`.`visitor_id` = `visitors`.`id` where `reviews`.`dish_id` = 1185 and `reviews`.`dish_id` is not null and `dishes`.`deleted_at` is null and `visitors`.`deleted_at` is null and `reviews`.`deleted_at` is null
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `reviews` where `reviews`.`dish_id` = 1186 and `reviews`.`dish_id` is not null and `id` in (select `id` from `reviews` as `r1` where `r1`.`deleted_at` is null and `r1`.`dish_id` = `reviews`.`dish_id` and `r1`.`visitor_id` = `reviews`.`visitor_id` and r1.id = (
SELECT MAX(r2.id)
FROM reviews AS r2
WHERE r2.dish_id = r1.dish_id
AND r2.visitor_id = r1.visitor_id
AND r2.deleted_at IS NULL
)) and exists (select * from `visitors` where `reviews`.`visitor_id` = `visitors`.`id` and `deleted_at` is null and `visitors`.`deleted_at` is null) and exists (select * from `dishes` where `reviews`.`dish_id` = `dishes`.`id` and `deleted_at` is null and `dishes`.`deleted_at` is null and `moderate` = 'Approved') and `reviews`.`deleted_at` is null
Bindings |
|
Backtrace |
|
select avg(`reviews`.`rating`) as aggregate from `reviews` inner join (SELECT dish_id, visitor_id, MAX(created_at) AS max_created_at
FROM reviews
WHERE deleted_at IS NULL
GROUP BY dish_id, visitor_id) AS latest_reviews on `reviews`.`dish_id` = `latest_reviews`.`dish_id` and `reviews`.`visitor_id` = `latest_reviews`.`visitor_id` and `reviews`.`created_at` = `latest_reviews`.`max_created_at` inner join `dishes` on `reviews`.`dish_id` = `dishes`.`id` inner join `visitors` on `reviews`.`visitor_id` = `visitors`.`id` where `reviews`.`dish_id` = 1186 and `reviews`.`dish_id` is not null and `dishes`.`deleted_at` is null and `visitors`.`deleted_at` is null and `reviews`.`deleted_at` is null
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `reviews` where `reviews`.`dish_id` = 1187 and `reviews`.`dish_id` is not null and `id` in (select `id` from `reviews` as `r1` where `r1`.`deleted_at` is null and `r1`.`dish_id` = `reviews`.`dish_id` and `r1`.`visitor_id` = `reviews`.`visitor_id` and r1.id = (
SELECT MAX(r2.id)
FROM reviews AS r2
WHERE r2.dish_id = r1.dish_id
AND r2.visitor_id = r1.visitor_id
AND r2.deleted_at IS NULL
)) and exists (select * from `visitors` where `reviews`.`visitor_id` = `visitors`.`id` and `deleted_at` is null and `visitors`.`deleted_at` is null) and exists (select * from `dishes` where `reviews`.`dish_id` = `dishes`.`id` and `deleted_at` is null and `dishes`.`deleted_at` is null and `moderate` = 'Approved') and `reviews`.`deleted_at` is null
Bindings |
|
Backtrace |
|
select avg(`reviews`.`rating`) as aggregate from `reviews` inner join (SELECT dish_id, visitor_id, MAX(created_at) AS max_created_at
FROM reviews
WHERE deleted_at IS NULL
GROUP BY dish_id, visitor_id) AS latest_reviews on `reviews`.`dish_id` = `latest_reviews`.`dish_id` and `reviews`.`visitor_id` = `latest_reviews`.`visitor_id` and `reviews`.`created_at` = `latest_reviews`.`max_created_at` inner join `dishes` on `reviews`.`dish_id` = `dishes`.`id` inner join `visitors` on `reviews`.`visitor_id` = `visitors`.`id` where `reviews`.`dish_id` = 1187 and `reviews`.`dish_id` is not null and `dishes`.`deleted_at` is null and `visitors`.`deleted_at` is null and `reviews`.`deleted_at` is null
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `reviews` where `reviews`.`dish_id` = 1188 and `reviews`.`dish_id` is not null and `id` in (select `id` from `reviews` as `r1` where `r1`.`deleted_at` is null and `r1`.`dish_id` = `reviews`.`dish_id` and `r1`.`visitor_id` = `reviews`.`visitor_id` and r1.id = (
SELECT MAX(r2.id)
FROM reviews AS r2
WHERE r2.dish_id = r1.dish_id
AND r2.visitor_id = r1.visitor_id
AND r2.deleted_at IS NULL
)) and exists (select * from `visitors` where `reviews`.`visitor_id` = `visitors`.`id` and `deleted_at` is null and `visitors`.`deleted_at` is null) and exists (select * from `dishes` where `reviews`.`dish_id` = `dishes`.`id` and `deleted_at` is null and `dishes`.`deleted_at` is null and `moderate` = 'Approved') and `reviews`.`deleted_at` is null
Bindings |
|
Backtrace |
|
select avg(`reviews`.`rating`) as aggregate from `reviews` inner join (SELECT dish_id, visitor_id, MAX(created_at) AS max_created_at
FROM reviews
WHERE deleted_at IS NULL
GROUP BY dish_id, visitor_id) AS latest_reviews on `reviews`.`dish_id` = `latest_reviews`.`dish_id` and `reviews`.`visitor_id` = `latest_reviews`.`visitor_id` and `reviews`.`created_at` = `latest_reviews`.`max_created_at` inner join `dishes` on `reviews`.`dish_id` = `dishes`.`id` inner join `visitors` on `reviews`.`visitor_id` = `visitors`.`id` where `reviews`.`dish_id` = 1188 and `reviews`.`dish_id` is not null and `dishes`.`deleted_at` is null and `visitors`.`deleted_at` is null and `reviews`.`deleted_at` is null
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `reviews` where `reviews`.`dish_id` = 1189 and `reviews`.`dish_id` is not null and `id` in (select `id` from `reviews` as `r1` where `r1`.`deleted_at` is null and `r1`.`dish_id` = `reviews`.`dish_id` and `r1`.`visitor_id` = `reviews`.`visitor_id` and r1.id = (
SELECT MAX(r2.id)
FROM reviews AS r2
WHERE r2.dish_id = r1.dish_id
AND r2.visitor_id = r1.visitor_id
AND r2.deleted_at IS NULL
)) and exists (select * from `visitors` where `reviews`.`visitor_id` = `visitors`.`id` and `deleted_at` is null and `visitors`.`deleted_at` is null) and exists (select * from `dishes` where `reviews`.`dish_id` = `dishes`.`id` and `deleted_at` is null and `dishes`.`deleted_at` is null and `moderate` = 'Approved') and `reviews`.`deleted_at` is null
Bindings |
|
Backtrace |
|
select avg(`reviews`.`rating`) as aggregate from `reviews` inner join (SELECT dish_id, visitor_id, MAX(created_at) AS max_created_at
FROM reviews
WHERE deleted_at IS NULL
GROUP BY dish_id, visitor_id) AS latest_reviews on `reviews`.`dish_id` = `latest_reviews`.`dish_id` and `reviews`.`visitor_id` = `latest_reviews`.`visitor_id` and `reviews`.`created_at` = `latest_reviews`.`max_created_at` inner join `dishes` on `reviews`.`dish_id` = `dishes`.`id` inner join `visitors` on `reviews`.`visitor_id` = `visitors`.`id` where `reviews`.`dish_id` = 1189 and `reviews`.`dish_id` is not null and `dishes`.`deleted_at` is null and `visitors`.`deleted_at` is null and `reviews`.`deleted_at` is null
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `reviews` where `reviews`.`dish_id` = 1190 and `reviews`.`dish_id` is not null and `id` in (select `id` from `reviews` as `r1` where `r1`.`deleted_at` is null and `r1`.`dish_id` = `reviews`.`dish_id` and `r1`.`visitor_id` = `reviews`.`visitor_id` and r1.id = (
SELECT MAX(r2.id)
FROM reviews AS r2
WHERE r2.dish_id = r1.dish_id
AND r2.visitor_id = r1.visitor_id
AND r2.deleted_at IS NULL
)) and exists (select * from `visitors` where `reviews`.`visitor_id` = `visitors`.`id` and `deleted_at` is null and `visitors`.`deleted_at` is null) and exists (select * from `dishes` where `reviews`.`dish_id` = `dishes`.`id` and `deleted_at` is null and `dishes`.`deleted_at` is null and `moderate` = 'Approved') and `reviews`.`deleted_at` is null
Bindings |
|
Backtrace |
|
select avg(`reviews`.`rating`) as aggregate from `reviews` inner join (SELECT dish_id, visitor_id, MAX(created_at) AS max_created_at
FROM reviews
WHERE deleted_at IS NULL
GROUP BY dish_id, visitor_id) AS latest_reviews on `reviews`.`dish_id` = `latest_reviews`.`dish_id` and `reviews`.`visitor_id` = `latest_reviews`.`visitor_id` and `reviews`.`created_at` = `latest_reviews`.`max_created_at` inner join `dishes` on `reviews`.`dish_id` = `dishes`.`id` inner join `visitors` on `reviews`.`visitor_id` = `visitors`.`id` where `reviews`.`dish_id` = 1190 and `reviews`.`dish_id` is not null and `dishes`.`deleted_at` is null and `visitors`.`deleted_at` is null and `reviews`.`deleted_at` is null
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `reviews` where `reviews`.`dish_id` = 1191 and `reviews`.`dish_id` is not null and `id` in (select `id` from `reviews` as `r1` where `r1`.`deleted_at` is null and `r1`.`dish_id` = `reviews`.`dish_id` and `r1`.`visitor_id` = `reviews`.`visitor_id` and r1.id = (
SELECT MAX(r2.id)
FROM reviews AS r2
WHERE r2.dish_id = r1.dish_id
AND r2.visitor_id = r1.visitor_id
AND r2.deleted_at IS NULL
)) and exists (select * from `visitors` where `reviews`.`visitor_id` = `visitors`.`id` and `deleted_at` is null and `visitors`.`deleted_at` is null) and exists (select * from `dishes` where `reviews`.`dish_id` = `dishes`.`id` and `deleted_at` is null and `dishes`.`deleted_at` is null and `moderate` = 'Approved') and `reviews`.`deleted_at` is null
Bindings |
|
Backtrace |
|
select avg(`reviews`.`rating`) as aggregate from `reviews` inner join (SELECT dish_id, visitor_id, MAX(created_at) AS max_created_at
FROM reviews
WHERE deleted_at IS NULL
GROUP BY dish_id, visitor_id) AS latest_reviews on `reviews`.`dish_id` = `latest_reviews`.`dish_id` and `reviews`.`visitor_id` = `latest_reviews`.`visitor_id` and `reviews`.`created_at` = `latest_reviews`.`max_created_at` inner join `dishes` on `reviews`.`dish_id` = `dishes`.`id` inner join `visitors` on `reviews`.`visitor_id` = `visitors`.`id` where `reviews`.`dish_id` = 1191 and `reviews`.`dish_id` is not null and `dishes`.`deleted_at` is null and `visitors`.`deleted_at` is null and `reviews`.`deleted_at` is null
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `reviews` where `reviews`.`dish_id` = 1192 and `reviews`.`dish_id` is not null and `id` in (select `id` from `reviews` as `r1` where `r1`.`deleted_at` is null and `r1`.`dish_id` = `reviews`.`dish_id` and `r1`.`visitor_id` = `reviews`.`visitor_id` and r1.id = (
SELECT MAX(r2.id)
FROM reviews AS r2
WHERE r2.dish_id = r1.dish_id
AND r2.visitor_id = r1.visitor_id
AND r2.deleted_at IS NULL
)) and exists (select * from `visitors` where `reviews`.`visitor_id` = `visitors`.`id` and `deleted_at` is null and `visitors`.`deleted_at` is null) and exists (select * from `dishes` where `reviews`.`dish_id` = `dishes`.`id` and `deleted_at` is null and `dishes`.`deleted_at` is null and `moderate` = 'Approved') and `reviews`.`deleted_at` is null
Bindings |
|
Backtrace |
|
select avg(`reviews`.`rating`) as aggregate from `reviews` inner join (SELECT dish_id, visitor_id, MAX(created_at) AS max_created_at
FROM reviews
WHERE deleted_at IS NULL
GROUP BY dish_id, visitor_id) AS latest_reviews on `reviews`.`dish_id` = `latest_reviews`.`dish_id` and `reviews`.`visitor_id` = `latest_reviews`.`visitor_id` and `reviews`.`created_at` = `latest_reviews`.`max_created_at` inner join `dishes` on `reviews`.`dish_id` = `dishes`.`id` inner join `visitors` on `reviews`.`visitor_id` = `visitors`.`id` where `reviews`.`dish_id` = 1192 and `reviews`.`dish_id` is not null and `dishes`.`deleted_at` is null and `visitors`.`deleted_at` is null and `reviews`.`deleted_at` is null
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `reviews` where `reviews`.`dish_id` = 1193 and `reviews`.`dish_id` is not null and `id` in (select `id` from `reviews` as `r1` where `r1`.`deleted_at` is null and `r1`.`dish_id` = `reviews`.`dish_id` and `r1`.`visitor_id` = `reviews`.`visitor_id` and r1.id = (
SELECT MAX(r2.id)
FROM reviews AS r2
WHERE r2.dish_id = r1.dish_id
AND r2.visitor_id = r1.visitor_id
AND r2.deleted_at IS NULL
)) and exists (select * from `visitors` where `reviews`.`visitor_id` = `visitors`.`id` and `deleted_at` is null and `visitors`.`deleted_at` is null) and exists (select * from `dishes` where `reviews`.`dish_id` = `dishes`.`id` and `deleted_at` is null and `dishes`.`deleted_at` is null and `moderate` = 'Approved') and `reviews`.`deleted_at` is null
Bindings |
|
Backtrace |
|
select avg(`reviews`.`rating`) as aggregate from `reviews` inner join (SELECT dish_id, visitor_id, MAX(created_at) AS max_created_at
FROM reviews
WHERE deleted_at IS NULL
GROUP BY dish_id, visitor_id) AS latest_reviews on `reviews`.`dish_id` = `latest_reviews`.`dish_id` and `reviews`.`visitor_id` = `latest_reviews`.`visitor_id` and `reviews`.`created_at` = `latest_reviews`.`max_created_at` inner join `dishes` on `reviews`.`dish_id` = `dishes`.`id` inner join `visitors` on `reviews`.`visitor_id` = `visitors`.`id` where `reviews`.`dish_id` = 1193 and `reviews`.`dish_id` is not null and `dishes`.`deleted_at` is null and `visitors`.`deleted_at` is null and `reviews`.`deleted_at` is null
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `reviews` where `reviews`.`dish_id` = 1194 and `reviews`.`dish_id` is not null and `id` in (select `id` from `reviews` as `r1` where `r1`.`deleted_at` is null and `r1`.`dish_id` = `reviews`.`dish_id` and `r1`.`visitor_id` = `reviews`.`visitor_id` and r1.id = (
SELECT MAX(r2.id)
FROM reviews AS r2
WHERE r2.dish_id = r1.dish_id
AND r2.visitor_id = r1.visitor_id
AND r2.deleted_at IS NULL
)) and exists (select * from `visitors` where `reviews`.`visitor_id` = `visitors`.`id` and `deleted_at` is null and `visitors`.`deleted_at` is null) and exists (select * from `dishes` where `reviews`.`dish_id` = `dishes`.`id` and `deleted_at` is null and `dishes`.`deleted_at` is null and `moderate` = 'Approved') and `reviews`.`deleted_at` is null
Bindings |
|
Backtrace |
|
select avg(`reviews`.`rating`) as aggregate from `reviews` inner join (SELECT dish_id, visitor_id, MAX(created_at) AS max_created_at
FROM reviews
WHERE deleted_at IS NULL
GROUP BY dish_id, visitor_id) AS latest_reviews on `reviews`.`dish_id` = `latest_reviews`.`dish_id` and `reviews`.`visitor_id` = `latest_reviews`.`visitor_id` and `reviews`.`created_at` = `latest_reviews`.`max_created_at` inner join `dishes` on `reviews`.`dish_id` = `dishes`.`id` inner join `visitors` on `reviews`.`visitor_id` = `visitors`.`id` where `reviews`.`dish_id` = 1194 and `reviews`.`dish_id` is not null and `dishes`.`deleted_at` is null and `visitors`.`deleted_at` is null and `reviews`.`deleted_at` is null
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `reviews` where `reviews`.`dish_id` = 1195 and `reviews`.`dish_id` is not null and `id` in (select `id` from `reviews` as `r1` where `r1`.`deleted_at` is null and `r1`.`dish_id` = `reviews`.`dish_id` and `r1`.`visitor_id` = `reviews`.`visitor_id` and r1.id = (
SELECT MAX(r2.id)
FROM reviews AS r2
WHERE r2.dish_id = r1.dish_id
AND r2.visitor_id = r1.visitor_id
AND r2.deleted_at IS NULL
)) and exists (select * from `visitors` where `reviews`.`visitor_id` = `visitors`.`id` and `deleted_at` is null and `visitors`.`deleted_at` is null) and exists (select * from `dishes` where `reviews`.`dish_id` = `dishes`.`id` and `deleted_at` is null and `dishes`.`deleted_at` is null and `moderate` = 'Approved') and `reviews`.`deleted_at` is null
Bindings |
|
Backtrace |
|
select avg(`reviews`.`rating`) as aggregate from `reviews` inner join (SELECT dish_id, visitor_id, MAX(created_at) AS max_created_at
FROM reviews
WHERE deleted_at IS NULL
GROUP BY dish_id, visitor_id) AS latest_reviews on `reviews`.`dish_id` = `latest_reviews`.`dish_id` and `reviews`.`visitor_id` = `latest_reviews`.`visitor_id` and `reviews`.`created_at` = `latest_reviews`.`max_created_at` inner join `dishes` on `reviews`.`dish_id` = `dishes`.`id` inner join `visitors` on `reviews`.`visitor_id` = `visitors`.`id` where `reviews`.`dish_id` = 1195 and `reviews`.`dish_id` is not null and `dishes`.`deleted_at` is null and `visitors`.`deleted_at` is null and `reviews`.`deleted_at` is null
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `reviews` where `reviews`.`dish_id` = 1196 and `reviews`.`dish_id` is not null and `id` in (select `id` from `reviews` as `r1` where `r1`.`deleted_at` is null and `r1`.`dish_id` = `reviews`.`dish_id` and `r1`.`visitor_id` = `reviews`.`visitor_id` and r1.id = (
SELECT MAX(r2.id)
FROM reviews AS r2
WHERE r2.dish_id = r1.dish_id
AND r2.visitor_id = r1.visitor_id
AND r2.deleted_at IS NULL
)) and exists (select * from `visitors` where `reviews`.`visitor_id` = `visitors`.`id` and `deleted_at` is null and `visitors`.`deleted_at` is null) and exists (select * from `dishes` where `reviews`.`dish_id` = `dishes`.`id` and `deleted_at` is null and `dishes`.`deleted_at` is null and `moderate` = 'Approved') and `reviews`.`deleted_at` is null
Bindings |
|
Backtrace |
|
select avg(`reviews`.`rating`) as aggregate from `reviews` inner join (SELECT dish_id, visitor_id, MAX(created_at) AS max_created_at
FROM reviews
WHERE deleted_at IS NULL
GROUP BY dish_id, visitor_id) AS latest_reviews on `reviews`.`dish_id` = `latest_reviews`.`dish_id` and `reviews`.`visitor_id` = `latest_reviews`.`visitor_id` and `reviews`.`created_at` = `latest_reviews`.`max_created_at` inner join `dishes` on `reviews`.`dish_id` = `dishes`.`id` inner join `visitors` on `reviews`.`visitor_id` = `visitors`.`id` where `reviews`.`dish_id` = 1196 and `reviews`.`dish_id` is not null and `dishes`.`deleted_at` is null and `visitors`.`deleted_at` is null and `reviews`.`deleted_at` is null
Bindings |
|
Backtrace |
|
select `dishes`.*, (select count(*) from `reviews` where `dishes`.`id` = `reviews`.`dish_id` and `reviews`.`deleted_at` is null and `id` in (select `id` from `reviews` as `r1` where `r1`.`deleted_at` is null and `r1`.`dish_id` = `reviews`.`dish_id` and `r1`.`visitor_id` = `reviews`.`visitor_id` and r1.id = (
SELECT MAX(r2.id)
FROM reviews AS r2
WHERE r2.dish_id = r1.dish_id
AND r2.visitor_id = r1.visitor_id
AND r2.deleted_at IS NULL
)) and exists (select * from `visitors` where `reviews`.`visitor_id` = `visitors`.`id` and `deleted_at` is null and `visitors`.`deleted_at` is null) and exists (select * from `dishes` where `reviews`.`dish_id` = `dishes`.`id` and `deleted_at` is null and `dishes`.`deleted_at` is null and `moderate` = 'Approved') and `reviews`.`deleted_at` is null) as `latest_reviews_count` from `dishes` where `dishes`.`restaurant_id` = 392 and `dishes`.`restaurant_id` is not null and `dishes`.`deleted_at` is null and `dishes`.`deleted_at` is null and `moderate` = 'Approved' having `latest_reviews_count` > 0
Bindings |
|
Backtrace |
|
select * from `reviews` where `reviews`.`id` in (select MAX(reviews.id) from `reviews` inner join `dishes` on `reviews`.`dish_id` = `dishes`.`id` where `dishes`.`restaurant_id` = 392 and `moderate` = 'Approved' and `reviews`.`deleted_at` is null and `dishes`.`deleted_at` is null group by `reviews`.`visitor_id`) and `cost` <> 0 and `deleted_at` is null and `reviews`.`deleted_at` is null
Bindings |
|
Backtrace |
|
select * from `reviews` where `reviews`.`id` in (select MAX(reviews.id) from `reviews` inner join `dishes` on `reviews`.`dish_id` = `dishes`.`id` where `dishes`.`restaurant_id` = 392 and `moderate` = 'Approved' and `reviews`.`deleted_at` is null and `dishes`.`deleted_at` is null group by `reviews`.`visitor_id`) and `parking` <> 0 and `deleted_at` is null and `reviews`.`deleted_at` is null
Bindings |
|
Backtrace |
|
select * from `reviews` where `reviews`.`id` in (select MAX(reviews.id) from `reviews` inner join `dishes` on `reviews`.`dish_id` = `dishes`.`id` where `dishes`.`restaurant_id` = 392 and `moderate` = 'Approved' and `reviews`.`deleted_at` is null and `dishes`.`deleted_at` is null group by `reviews`.`visitor_id`) and `staff` <> 0 and `deleted_at` is null and `reviews`.`deleted_at` is null
Bindings |
|
Backtrace |
|
select * from `reviews` where `reviews`.`id` in (select MAX(reviews.id) from `reviews` inner join `dishes` on `reviews`.`dish_id` = `dishes`.`id` where `dishes`.`restaurant_id` = 392 and `moderate` = 'Approved' and `reviews`.`deleted_at` is null and `dishes`.`deleted_at` is null group by `reviews`.`visitor_id`) and `wait_times` <> 0 and `deleted_at` is null and `reviews`.`deleted_at` is null
Bindings |
|
Backtrace |
|
select * from `reviews` where `reviews`.`id` in (select MAX(reviews.id) from `reviews` inner join `dishes` on `reviews`.`dish_id` = `dishes`.`id` where `dishes`.`restaurant_id` = 392 and `moderate` = 'Approved' and `reviews`.`deleted_at` is null and `dishes`.`deleted_at` is null group by `reviews`.`visitor_id`) and `cleanliness` <> 0 and `deleted_at` is null and `reviews`.`deleted_at` is null
Bindings |
|
Backtrace |
|
select * from `reviews` where `reviews`.`id` in (select MAX(reviews.id) from `reviews` inner join `dishes` on `reviews`.`dish_id` = `dishes`.`id` where `dishes`.`restaurant_id` = 392 and `moderate` = 'Approved' and `reviews`.`deleted_at` is null and `dishes`.`deleted_at` is null group by `reviews`.`visitor_id`) and `family_friendly` <> 0 and `deleted_at` is null and `reviews`.`deleted_at` is null
Bindings |
|
Backtrace |
|
select * from `dishes` where `dishes`.`id` = 1185 and `dishes`.`deleted_at` is null and `moderate` = 'Approved' limit 1
Bindings |
|
Backtrace |
|
select * from `reviews` where `reviews`.`dish_id` = 1185 and `reviews`.`dish_id` is not null and `id` in (select `id` from `reviews` as `r1` where `r1`.`deleted_at` is null and `r1`.`dish_id` = `reviews`.`dish_id` and `r1`.`visitor_id` = `reviews`.`visitor_id` and r1.id = (
SELECT MAX(r2.id)
FROM reviews AS r2
WHERE r2.dish_id = r1.dish_id
AND r2.visitor_id = r1.visitor_id
AND r2.deleted_at IS NULL
)) and exists (select * from `visitors` where `reviews`.`visitor_id` = `visitors`.`id` and `deleted_at` is null and `visitors`.`deleted_at` is null) and exists (select * from `dishes` where `reviews`.`dish_id` = `dishes`.`id` and `deleted_at` is null and `dishes`.`deleted_at` is null and `moderate` = 'Approved') and `reviews`.`deleted_at` is null
Bindings |
|
Backtrace |
|
select * from `media` where `media`.`model_id` in (1337) and `media`.`model_type` = 'App\\Models\\Review'
Bindings |
|
Backtrace |
|
select avg(`reviews`.`rating`) as aggregate from `reviews` inner join (SELECT dish_id, visitor_id, MAX(created_at) AS max_created_at
FROM reviews
WHERE deleted_at IS NULL
GROUP BY dish_id, visitor_id) AS latest_reviews on `reviews`.`dish_id` = `latest_reviews`.`dish_id` and `reviews`.`visitor_id` = `latest_reviews`.`visitor_id` and `reviews`.`created_at` = `latest_reviews`.`max_created_at` inner join `dishes` on `reviews`.`dish_id` = `dishes`.`id` inner join `visitors` on `reviews`.`visitor_id` = `visitors`.`id` where `reviews`.`dish_id` = 1185 and `reviews`.`dish_id` is not null and `dishes`.`deleted_at` is null and `visitors`.`deleted_at` is null and `reviews`.`deleted_at` is null
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `reviews` where `reviews`.`dish_id` = 1185 and `reviews`.`dish_id` is not null and `id` in (select `id` from `reviews` as `r1` where `r1`.`deleted_at` is null and `r1`.`dish_id` = `reviews`.`dish_id` and `r1`.`visitor_id` = `reviews`.`visitor_id` and r1.id = (
SELECT MAX(r2.id)
FROM reviews AS r2
WHERE r2.dish_id = r1.dish_id
AND r2.visitor_id = r1.visitor_id
AND r2.deleted_at IS NULL
)) and exists (select * from `visitors` where `reviews`.`visitor_id` = `visitors`.`id` and `deleted_at` is null and `visitors`.`deleted_at` is null) and exists (select * from `dishes` where `reviews`.`dish_id` = `dishes`.`id` and `deleted_at` is null and `dishes`.`deleted_at` is null and `moderate` = 'Approved') and `reviews`.`deleted_at` is null
Bindings |
|
Backtrace |
|
select * from `reviews` where `reviews`.`dish_id` = 1185 and `reviews`.`dish_id` is not null and `id` in (select `id` from `reviews` as `r1` where `r1`.`deleted_at` is null and `r1`.`dish_id` = `reviews`.`dish_id` and `r1`.`visitor_id` = `reviews`.`visitor_id` and r1.id = (
SELECT MAX(r2.id)
FROM reviews AS r2
WHERE r2.dish_id = r1.dish_id
AND r2.visitor_id = r1.visitor_id
AND r2.deleted_at IS NULL
)) and exists (select * from `visitors` where `reviews`.`visitor_id` = `visitors`.`id` and `deleted_at` is null and `visitors`.`deleted_at` is null) and exists (select * from `dishes` where `reviews`.`dish_id` = `dishes`.`id` and `deleted_at` is null and `dishes`.`deleted_at` is null and `moderate` = 'Approved') and `reviews`.`deleted_at` is null order by `id` desc
Bindings |
|
Backtrace |
|
select * from `visitors` where `visitors`.`id` in (22) and `visitors`.`deleted_at` is null
Backtrace |
|
select * from `media` where `media`.`model_id` in (1337) and `media`.`model_type` = 'App\\Models\\Review'
Bindings |
|
Backtrace |
|
select * from `establishments` where `establishments`.`id` = 392 and `establishments`.`deleted_at` is null limit 1
Bindings |
|
Backtrace |
|
select * from `dishes` where `dishes`.`id` = 1185 and `dishes`.`deleted_at` is null and `moderate` = 'Approved' limit 1
Bindings |
|
Backtrace |
|
select * from `media` where `media`.`model_id` in (1185) and `media`.`model_type` = 'App\\Models\\Dish'
Bindings |
|
Backtrace |
|
select * from `establishments` where `establishments`.`id` = 392 and `establishments`.`deleted_at` is null limit 1
Bindings |
|
Backtrace |
|
select * from `media` where `media`.`model_id` in (392) and `media`.`model_type` = 'App\\Models\\Establishment'
Bindings |
|
Backtrace |
|
select * from `media` where `media`.`model_id` in (22) and `media`.`model_type` = 'App\\Models\\Visitor'
Bindings |
|
Backtrace |
|
select * from `dishes` where `dishes`.`id` = 1186 and `dishes`.`deleted_at` is null and `moderate` = 'Approved' limit 1
Bindings |
|
Backtrace |
|
select * from `reviews` where `reviews`.`dish_id` = 1186 and `reviews`.`dish_id` is not null and `id` in (select `id` from `reviews` as `r1` where `r1`.`deleted_at` is null and `r1`.`dish_id` = `reviews`.`dish_id` and `r1`.`visitor_id` = `reviews`.`visitor_id` and r1.id = (
SELECT MAX(r2.id)
FROM reviews AS r2
WHERE r2.dish_id = r1.dish_id
AND r2.visitor_id = r1.visitor_id
AND r2.deleted_at IS NULL
)) and exists (select * from `visitors` where `reviews`.`visitor_id` = `visitors`.`id` and `deleted_at` is null and `visitors`.`deleted_at` is null) and exists (select * from `dishes` where `reviews`.`dish_id` = `dishes`.`id` and `deleted_at` is null and `dishes`.`deleted_at` is null and `moderate` = 'Approved') and `reviews`.`deleted_at` is null
Bindings |
|
Backtrace |
|
select * from `media` where `media`.`model_id` in (1338) and `media`.`model_type` = 'App\\Models\\Review'
Bindings |
|
Backtrace |
|
select avg(`reviews`.`rating`) as aggregate from `reviews` inner join (SELECT dish_id, visitor_id, MAX(created_at) AS max_created_at
FROM reviews
WHERE deleted_at IS NULL
GROUP BY dish_id, visitor_id) AS latest_reviews on `reviews`.`dish_id` = `latest_reviews`.`dish_id` and `reviews`.`visitor_id` = `latest_reviews`.`visitor_id` and `reviews`.`created_at` = `latest_reviews`.`max_created_at` inner join `dishes` on `reviews`.`dish_id` = `dishes`.`id` inner join `visitors` on `reviews`.`visitor_id` = `visitors`.`id` where `reviews`.`dish_id` = 1186 and `reviews`.`dish_id` is not null and `dishes`.`deleted_at` is null and `visitors`.`deleted_at` is null and `reviews`.`deleted_at` is null
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `reviews` where `reviews`.`dish_id` = 1186 and `reviews`.`dish_id` is not null and `id` in (select `id` from `reviews` as `r1` where `r1`.`deleted_at` is null and `r1`.`dish_id` = `reviews`.`dish_id` and `r1`.`visitor_id` = `reviews`.`visitor_id` and r1.id = (
SELECT MAX(r2.id)
FROM reviews AS r2
WHERE r2.dish_id = r1.dish_id
AND r2.visitor_id = r1.visitor_id
AND r2.deleted_at IS NULL
)) and exists (select * from `visitors` where `reviews`.`visitor_id` = `visitors`.`id` and `deleted_at` is null and `visitors`.`deleted_at` is null) and exists (select * from `dishes` where `reviews`.`dish_id` = `dishes`.`id` and `deleted_at` is null and `dishes`.`deleted_at` is null and `moderate` = 'Approved') and `reviews`.`deleted_at` is null
Bindings |
|
Backtrace |
|
select * from `reviews` where `reviews`.`dish_id` = 1186 and `reviews`.`dish_id` is not null and `id` in (select `id` from `reviews` as `r1` where `r1`.`deleted_at` is null and `r1`.`dish_id` = `reviews`.`dish_id` and `r1`.`visitor_id` = `reviews`.`visitor_id` and r1.id = (
SELECT MAX(r2.id)
FROM reviews AS r2
WHERE r2.dish_id = r1.dish_id
AND r2.visitor_id = r1.visitor_id
AND r2.deleted_at IS NULL
)) and exists (select * from `visitors` where `reviews`.`visitor_id` = `visitors`.`id` and `deleted_at` is null and `visitors`.`deleted_at` is null) and exists (select * from `dishes` where `reviews`.`dish_id` = `dishes`.`id` and `deleted_at` is null and `dishes`.`deleted_at` is null and `moderate` = 'Approved') and `reviews`.`deleted_at` is null order by `id` desc
Bindings |
|
Backtrace |
|
select * from `visitors` where `visitors`.`id` in (22) and `visitors`.`deleted_at` is null
Backtrace |
|
select * from `media` where `media`.`model_id` in (1338) and `media`.`model_type` = 'App\\Models\\Review'
Bindings |
|
Backtrace |
|
select * from `establishments` where `establishments`.`id` = 392 and `establishments`.`deleted_at` is null limit 1
Bindings |
|
Backtrace |
|
select * from `dishes` where `dishes`.`id` = 1186 and `dishes`.`deleted_at` is null and `moderate` = 'Approved' limit 1
Bindings |
|
Backtrace |
|
select * from `media` where `media`.`model_id` in (1186) and `media`.`model_type` = 'App\\Models\\Dish'
Bindings |
|
Backtrace |
|
select * from `establishments` where `establishments`.`id` = 392 and `establishments`.`deleted_at` is null limit 1
Bindings |
|
Backtrace |
|
select * from `media` where `media`.`model_id` in (392) and `media`.`model_type` = 'App\\Models\\Establishment'
Bindings |
|
Backtrace |
|
select * from `media` where `media`.`model_id` in (22) and `media`.`model_type` = 'App\\Models\\Visitor'
Bindings |
|
Backtrace |
|
select * from `dishes` where `dishes`.`id` = 1195 and `dishes`.`deleted_at` is null and `moderate` = 'Approved' limit 1
Bindings |
|
Backtrace |
|
select * from `reviews` where `reviews`.`dish_id` = 1195 and `reviews`.`dish_id` is not null and `id` in (select `id` from `reviews` as `r1` where `r1`.`deleted_at` is null and `r1`.`dish_id` = `reviews`.`dish_id` and `r1`.`visitor_id` = `reviews`.`visitor_id` and r1.id = (
SELECT MAX(r2.id)
FROM reviews AS r2
WHERE r2.dish_id = r1.dish_id
AND r2.visitor_id = r1.visitor_id
AND r2.deleted_at IS NULL
)) and exists (select * from `visitors` where `reviews`.`visitor_id` = `visitors`.`id` and `deleted_at` is null and `visitors`.`deleted_at` is null) and exists (select * from `dishes` where `reviews`.`dish_id` = `dishes`.`id` and `deleted_at` is null and `dishes`.`deleted_at` is null and `moderate` = 'Approved') and `reviews`.`deleted_at` is null
Bindings |
|
Backtrace |
|
select * from `media` where `media`.`model_id` in (1347) and `media`.`model_type` = 'App\\Models\\Review'
Bindings |
|
Backtrace |
|
select avg(`reviews`.`rating`) as aggregate from `reviews` inner join (SELECT dish_id, visitor_id, MAX(created_at) AS max_created_at
FROM reviews
WHERE deleted_at IS NULL
GROUP BY dish_id, visitor_id) AS latest_reviews on `reviews`.`dish_id` = `latest_reviews`.`dish_id` and `reviews`.`visitor_id` = `latest_reviews`.`visitor_id` and `reviews`.`created_at` = `latest_reviews`.`max_created_at` inner join `dishes` on `reviews`.`dish_id` = `dishes`.`id` inner join `visitors` on `reviews`.`visitor_id` = `visitors`.`id` where `reviews`.`dish_id` = 1195 and `reviews`.`dish_id` is not null and `dishes`.`deleted_at` is null and `visitors`.`deleted_at` is null and `reviews`.`deleted_at` is null
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `reviews` where `reviews`.`dish_id` = 1195 and `reviews`.`dish_id` is not null and `id` in (select `id` from `reviews` as `r1` where `r1`.`deleted_at` is null and `r1`.`dish_id` = `reviews`.`dish_id` and `r1`.`visitor_id` = `reviews`.`visitor_id` and r1.id = (
SELECT MAX(r2.id)
FROM reviews AS r2
WHERE r2.dish_id = r1.dish_id
AND r2.visitor_id = r1.visitor_id
AND r2.deleted_at IS NULL
)) and exists (select * from `visitors` where `reviews`.`visitor_id` = `visitors`.`id` and `deleted_at` is null and `visitors`.`deleted_at` is null) and exists (select * from `dishes` where `reviews`.`dish_id` = `dishes`.`id` and `deleted_at` is null and `dishes`.`deleted_at` is null and `moderate` = 'Approved') and `reviews`.`deleted_at` is null
Bindings |
|
Backtrace |
|
select * from `reviews` where `reviews`.`dish_id` = 1195 and `reviews`.`dish_id` is not null and `id` in (select `id` from `reviews` as `r1` where `r1`.`deleted_at` is null and `r1`.`dish_id` = `reviews`.`dish_id` and `r1`.`visitor_id` = `reviews`.`visitor_id` and r1.id = (
SELECT MAX(r2.id)
FROM reviews AS r2
WHERE r2.dish_id = r1.dish_id
AND r2.visitor_id = r1.visitor_id
AND r2.deleted_at IS NULL
)) and exists (select * from `visitors` where `reviews`.`visitor_id` = `visitors`.`id` and `deleted_at` is null and `visitors`.`deleted_at` is null) and exists (select * from `dishes` where `reviews`.`dish_id` = `dishes`.`id` and `deleted_at` is null and `dishes`.`deleted_at` is null and `moderate` = 'Approved') and `reviews`.`deleted_at` is null order by `id` desc
Bindings |
|
Backtrace |
|
select * from `visitors` where `visitors`.`id` in (22) and `visitors`.`deleted_at` is null
Backtrace |
|
select * from `media` where `media`.`model_id` in (1347) and `media`.`model_type` = 'App\\Models\\Review'
Bindings |
|
Backtrace |
|
select * from `establishments` where `establishments`.`id` = 392 and `establishments`.`deleted_at` is null limit 1
Bindings |
|
Backtrace |
|
select * from `dishes` where `dishes`.`id` = 1195 and `dishes`.`deleted_at` is null and `moderate` = 'Approved' limit 1
Bindings |
|
Backtrace |
|
select * from `media` where `media`.`model_id` in (1195) and `media`.`model_type` = 'App\\Models\\Dish'
Bindings |
|
Backtrace |
|
select * from `establishments` where `establishments`.`id` = 392 and `establishments`.`deleted_at` is null limit 1
Bindings |
|
Backtrace |
|
select * from `media` where `media`.`model_id` in (392) and `media`.`model_type` = 'App\\Models\\Establishment'
Bindings |
|
Backtrace |
|
select * from `media` where `media`.`model_id` in (22) and `media`.`model_type` = 'App\\Models\\Visitor'
Bindings |
|
Backtrace |
|
select * from `dishes` where `dishes`.`id` = 1190 and `dishes`.`deleted_at` is null and `moderate` = 'Approved' limit 1
Bindings |
|
Backtrace |
|
select * from `reviews` where `reviews`.`dish_id` = 1190 and `reviews`.`dish_id` is not null and `id` in (select `id` from `reviews` as `r1` where `r1`.`deleted_at` is null and `r1`.`dish_id` = `reviews`.`dish_id` and `r1`.`visitor_id` = `reviews`.`visitor_id` and r1.id = (
SELECT MAX(r2.id)
FROM reviews AS r2
WHERE r2.dish_id = r1.dish_id
AND r2.visitor_id = r1.visitor_id
AND r2.deleted_at IS NULL
)) and exists (select * from `visitors` where `reviews`.`visitor_id` = `visitors`.`id` and `deleted_at` is null and `visitors`.`deleted_at` is null) and exists (select * from `dishes` where `reviews`.`dish_id` = `dishes`.`id` and `deleted_at` is null and `dishes`.`deleted_at` is null and `moderate` = 'Approved') and `reviews`.`deleted_at` is null
Bindings |
|
Backtrace |
|
select * from `media` where `media`.`model_id` in (1342) and `media`.`model_type` = 'App\\Models\\Review'
Bindings |
|
Backtrace |
|
select avg(`reviews`.`rating`) as aggregate from `reviews` inner join (SELECT dish_id, visitor_id, MAX(created_at) AS max_created_at
FROM reviews
WHERE deleted_at IS NULL
GROUP BY dish_id, visitor_id) AS latest_reviews on `reviews`.`dish_id` = `latest_reviews`.`dish_id` and `reviews`.`visitor_id` = `latest_reviews`.`visitor_id` and `reviews`.`created_at` = `latest_reviews`.`max_created_at` inner join `dishes` on `reviews`.`dish_id` = `dishes`.`id` inner join `visitors` on `reviews`.`visitor_id` = `visitors`.`id` where `reviews`.`dish_id` = 1190 and `reviews`.`dish_id` is not null and `dishes`.`deleted_at` is null and `visitors`.`deleted_at` is null and `reviews`.`deleted_at` is null
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `reviews` where `reviews`.`dish_id` = 1190 and `reviews`.`dish_id` is not null and `id` in (select `id` from `reviews` as `r1` where `r1`.`deleted_at` is null and `r1`.`dish_id` = `reviews`.`dish_id` and `r1`.`visitor_id` = `reviews`.`visitor_id` and r1.id = (
SELECT MAX(r2.id)
FROM reviews AS r2
WHERE r2.dish_id = r1.dish_id
AND r2.visitor_id = r1.visitor_id
AND r2.deleted_at IS NULL
)) and exists (select * from `visitors` where `reviews`.`visitor_id` = `visitors`.`id` and `deleted_at` is null and `visitors`.`deleted_at` is null) and exists (select * from `dishes` where `reviews`.`dish_id` = `dishes`.`id` and `deleted_at` is null and `dishes`.`deleted_at` is null and `moderate` = 'Approved') and `reviews`.`deleted_at` is null
Bindings |
|
Backtrace |
|
select * from `reviews` where `reviews`.`dish_id` = 1190 and `reviews`.`dish_id` is not null and `id` in (select `id` from `reviews` as `r1` where `r1`.`deleted_at` is null and `r1`.`dish_id` = `reviews`.`dish_id` and `r1`.`visitor_id` = `reviews`.`visitor_id` and r1.id = (
SELECT MAX(r2.id)
FROM reviews AS r2
WHERE r2.dish_id = r1.dish_id
AND r2.visitor_id = r1.visitor_id
AND r2.deleted_at IS NULL
)) and exists (select * from `visitors` where `reviews`.`visitor_id` = `visitors`.`id` and `deleted_at` is null and `visitors`.`deleted_at` is null) and exists (select * from `dishes` where `reviews`.`dish_id` = `dishes`.`id` and `deleted_at` is null and `dishes`.`deleted_at` is null and `moderate` = 'Approved') and `reviews`.`deleted_at` is null order by `id` desc
Bindings |
|
Backtrace |
|
select * from `visitors` where `visitors`.`id` in (22) and `visitors`.`deleted_at` is null
Backtrace |
|
select * from `media` where `media`.`model_id` in (1342) and `media`.`model_type` = 'App\\Models\\Review'
Bindings |
|
Backtrace |
|
select * from `establishments` where `establishments`.`id` = 392 and `establishments`.`deleted_at` is null limit 1
Bindings |
|
Backtrace |
|
select * from `dishes` where `dishes`.`id` = 1190 and `dishes`.`deleted_at` is null and `moderate` = 'Approved' limit 1
Bindings |
|
Backtrace |
|
select * from `media` where `media`.`model_id` in (1190) and `media`.`model_type` = 'App\\Models\\Dish'
Bindings |
|
Backtrace |
|
select * from `establishments` where `establishments`.`id` = 392 and `establishments`.`deleted_at` is null limit 1
Bindings |
|
Backtrace |
|
select * from `media` where `media`.`model_id` in (392) and `media`.`model_type` = 'App\\Models\\Establishment'
Bindings |
|
Backtrace |
|
select * from `media` where `media`.`model_id` in (22) and `media`.`model_type` = 'App\\Models\\Visitor'
Bindings |
|
Backtrace |
|
select * from `dishes` where `dishes`.`id` = 1196 and `dishes`.`deleted_at` is null and `moderate` = 'Approved' limit 1
Bindings |
|
Backtrace |
|
select * from `reviews` where `reviews`.`dish_id` = 1196 and `reviews`.`dish_id` is not null and `id` in (select `id` from `reviews` as `r1` where `r1`.`deleted_at` is null and `r1`.`dish_id` = `reviews`.`dish_id` and `r1`.`visitor_id` = `reviews`.`visitor_id` and r1.id = (
SELECT MAX(r2.id)
FROM reviews AS r2
WHERE r2.dish_id = r1.dish_id
AND r2.visitor_id = r1.visitor_id
AND r2.deleted_at IS NULL
)) and exists (select * from `visitors` where `reviews`.`visitor_id` = `visitors`.`id` and `deleted_at` is null and `visitors`.`deleted_at` is null) and exists (select * from `dishes` where `reviews`.`dish_id` = `dishes`.`id` and `deleted_at` is null and `dishes`.`deleted_at` is null and `moderate` = 'Approved') and `reviews`.`deleted_at` is null
Bindings |
|
Backtrace |
|
select * from `media` where `media`.`model_id` in (1348) and `media`.`model_type` = 'App\\Models\\Review'
Bindings |
|
Backtrace |
|
select avg(`reviews`.`rating`) as aggregate from `reviews` inner join (SELECT dish_id, visitor_id, MAX(created_at) AS max_created_at
FROM reviews
WHERE deleted_at IS NULL
GROUP BY dish_id, visitor_id) AS latest_reviews on `reviews`.`dish_id` = `latest_reviews`.`dish_id` and `reviews`.`visitor_id` = `latest_reviews`.`visitor_id` and `reviews`.`created_at` = `latest_reviews`.`max_created_at` inner join `dishes` on `reviews`.`dish_id` = `dishes`.`id` inner join `visitors` on `reviews`.`visitor_id` = `visitors`.`id` where `reviews`.`dish_id` = 1196 and `reviews`.`dish_id` is not null and `dishes`.`deleted_at` is null and `visitors`.`deleted_at` is null and `reviews`.`deleted_at` is null
Bindings |
|
Backtrace |
|
select 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
select * 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
select * from `visitors` where `visitors`.`id` in (22) and `visitors`.`deleted_at` is null
select * from `media` where `media`.`model_id` in (1348) and `media`.`model_type` = ?
select * from `establishments` where `establishments`.`id` = ? and `establishments`.`deleted_at` is null limit 1
select * from `dishes` where `dishes`.`id` = ? and `dishes`.`deleted_at` is null and `moderate` = ? limit 1
select * from `media` where `media`.`model_id` in (1196) and `media`.`model_type` = ?
select * from `establishments` where `establishments`.`id` = ? and `establishments`.`deleted_at` is null limit 1
select * from `media` where `media`.`model_id` in (392) and `media`.`model_type` = ?
select * from `media` where `media`.`model_id` in (22) and `media`.`model_type` = ?
select * from `dishes` where `dishes`.`id` = ? and `dishes`.`deleted_at` is null and `moderate` = ? limit 1
select * 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
select * from `media` where `media`.`model_id` in (1345) and `media`.`model_type` = ?
select avg(`reviews`.`rating`) as aggregate from `reviews` inner join (SELECT dish_id, visitor_id, MAX(created_at) AS max_created_at
FROM reviews
WHERE deleted_at IS NULL
GROUP BY dish_id, visitor_id) AS latest_reviews on `reviews`.`dish_id` = `latest_reviews`.`dish_id` and `reviews`.`visitor_id` = `latest_reviews`.`visitor_id` and `reviews`.`created_at` = `latest_reviews`.`max_created_at` inner join `dishes` on `reviews`.`dish_id` = `dishes`.`id` inner join `visitors` on `reviews`.`visitor_id` = `visitors`.`id` where `reviews`.`dish_id` = ? 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
select 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
select * 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
select * from `visitors` where `visitors`.`id` in (22) and `visitors`.`deleted_at` is null
select * from `media` where `media`.`model_id` in (1345) and `media`.`model_type` = ?
select * from `establishments` where `establishments`.`id` = ? and `establishments`.`deleted_at` is null limit 1
select * from `dishes` where `dishes`.`id` = ? and `dishes`.`deleted_at` is null and `moderate` = ? limit 1
select * from `media` where `media`.`model_id` in (1193) and `media`.`model_type` = ?
select * from `establishments` where `establishments`.`id` = ? and `establishments`.`deleted_at` is null limit 1
select * from `media` where `media`.`model_id` in (392) and `media`.`model_type` = ?
select * from `media` where `media`.`model_id` in (22) and `media`.`model_type` = ?
select * from `dishes` where `dishes`.`id` = ? and `dishes`.`deleted_at` is null and `moderate` = ? limit 1
select * 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
select * from `media` where `media`.`model_id` in (1339) and `media`.`model_type` = ?
select avg(`reviews`.`rating`) as aggregate from `reviews` inner join (SELECT dish_id, visitor_id, MAX(created_at) AS max_created_at
FROM reviews
WHERE deleted_at IS NULL
GROUP BY dish_id, visitor_id) AS latest_reviews on `reviews`.`dish_id` = `latest_reviews`.`dish_id` and `reviews`.`visitor_id` = `latest_reviews`.`visitor_id` and `reviews`.`created_at` = `latest_reviews`.`max_created_at` inner join `dishes` on `reviews`.`dish_id` = `dishes`.`id` inner join `visitors` on `reviews`.`visitor_id` = `visitors`.`id` where `reviews`.`dish_id` = ? 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
select 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
select * 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
select * from `visitors` where `visitors`.`id` in (22) and `visitors`.`deleted_at` is null
select * from `media` where `media`.`model_id` in (1339) and `media`.`model_type` = ?
select * from `establishments` where `establishments`.`id` = ? and `establishments`.`deleted_at` is null limit 1
select * from `dishes` where `dishes`.`id` = ? and `dishes`.`deleted_at` is null and `moderate` = ? limit 1
select * from `media` where `media`.`model_id` in (1187) and `media`.`model_type` = ?
select * from `establishments` where `establishments`.`id` = ? and `establishments`.`deleted_at` is null limit 1
select * from `media` where `media`.`model_id` in (392) and `media`.`model_type` = ?
select * from `media` where `media`.`model_id` in (22) and `media`.`model_type` = ?
select * from `dishes` where `dishes`.`id` = ? and `dishes`.`deleted_at` is null and `moderate` = ? limit 1
select * 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
select * from `media` where `media`.`model_id` in (1343) and `media`.`model_type` = ?
select avg(`reviews`.`rating`) as aggregate from `reviews` inner join (SELECT dish_id, visitor_id, MAX(created_at) AS max_created_at
FROM reviews
WHERE deleted_at IS NULL
GROUP BY dish_id, visitor_id) AS latest_reviews on `reviews`.`dish_id` = `latest_reviews`.`dish_id` and `reviews`.`visitor_id` = `latest_reviews`.`visitor_id` and `reviews`.`created_at` = `latest_reviews`.`max_created_at` inner join `dishes` on `reviews`.`dish_id` = `dishes`.`id` inner join `visitors` on `reviews`.`visitor_id` = `visitors`.`id` where `reviews`.`dish_id` = ? 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
select 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
select * 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
select * from `visitors` where `visitors`.`id` in (22) and `visitors`.`deleted_at` is null
select * from `media` where `media`.`model_id` in (1343) and `media`.`model_type` = ?
select * from `establishments` where `establishments`.`id` = ? and `establishments`.`deleted_at` is null limit 1
select * from `dishes` where `dishes`.`id` = ? and `dishes`.`deleted_at` is null and `moderate` = ? limit 1
select * from `media` where `media`.`model_id` in (1191) and `media`.`model_type` = ?
select * from `establishments` where `establishments`.`id` = ? and `establishments`.`deleted_at` is null limit 1
select * from `media` where `media`.`model_id` in (392) and `media`.`model_type` = ?
select * from `media` where `media`.`model_id` in (22) and `media`.`model_type` = ?
select * from `dishes` where `dishes`.`id` = ? and `dishes`.`deleted_at` is null and `moderate` = ? limit 1
select * 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
select * from `media` where `media`.`model_id` in (1336) and `media`.`model_type` = ?
select avg(`reviews`.`rating`) as aggregate from `reviews` inner join (SELECT dish_id, visitor_id, MAX(created_at) AS max_created_at
FROM reviews
WHERE deleted_at IS NULL
GROUP BY dish_id, visitor_id) AS latest_reviews on `reviews`.`dish_id` = `latest_reviews`.`dish_id` and `reviews`.`visitor_id` = `latest_reviews`.`visitor_id` and `reviews`.`created_at` = `latest_reviews`.`max_created_at` inner join `dishes` on `reviews`.`dish_id` = `dishes`.`id` inner join `visitors` on `reviews`.`visitor_id` = `visitors`.`id` where `reviews`.`dish_id` = ? 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
select 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
select * 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
select * from `visitors` where `visitors`.`id` in (22) and `visitors`.`deleted_at` is null
select * from `media` where `media`.`model_id` in (1336) and `media`.`model_type` = ?
select * from `establishments` where `establishments`.`id` = ? and `establishments`.`deleted_at` is null limit 1
select * from `dishes` where `dishes`.`id` = ? and `dishes`.`deleted_at` is null and `moderate` = ? limit 1
select * from `media` where `media`.`model_id` in (1184) and `media`.`model_type` = ?
select * from `establishments` where `establishments`.`id` = ? and `establishments`.`deleted_at` is null limit 1
select * from `media` where `media`.`model_id` in (392) and `media`.`model_type` = ?
select * from `media` where `media`.`model_id` in (22) and `media`.`model_type` = ?
select * from `dishes` where `dishes`.`id` = ? and `dishes`.`deleted_at` is null and `moderate` = ? limit 1
select * 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
select * from `media` where `media`.`model_id` in (1341) and `media`.`model_type` = ?
select avg(`reviews`.`rating`) as aggregate from `reviews` inner join (SELECT dish_id, visitor_id, MAX(created_at) AS max_created_at
FROM reviews
WHERE deleted_at IS NULL
GROUP BY dish_id, visitor_id) AS latest_reviews on `reviews`.`dish_id` = `latest_reviews`.`dish_id` and `reviews`.`visitor_id` = `latest_reviews`.`visitor_id` and `reviews`.`created_at` = `latest_reviews`.`max_created_at` inner join `dishes` on `reviews`.`dish_id` = `dishes`.`id` inner join `visitors` on `reviews`.`visitor_id` = `visitors`.`id` where `reviews`.`dish_id` = ? 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
select 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
select * 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
select * from `visitors` where `visitors`.`id` in (22) and `visitors`.`deleted_at` is null
select * from `media` where `media`.`model_id` in (1341) and `media`.`model_type` = ?
select * from `establishments` where `establishments`.`id` = ? and `establishments`.`deleted_at` is null limit 1
select * from `dishes` where `dishes`.`id` = ? and `dishes`.`deleted_at` is null and `moderate` = ? limit 1
select * from `media` where `media`.`model_id` in (1189) and `media`.`model_type` = ?
select * from `establishments` where `establishments`.`id` = ? and `establishments`.`deleted_at` is null limit 1
select * from `media` where `media`.`model_id` in (392) and `media`.`model_type` = ?
select * from `media` where `media`.`model_id` in (22) and `media`.`model_type` = ?
select * from `visitors` where `visitors`.`id` = ? and `visitors`.`deleted_at` is null limit 1
select * from `visitors` where `visitors`.`id` = ? and `visitors`.`deleted_at` is null limit 1
select * from `visitors` where `visitors`.`id` = ? and `visitors`.`deleted_at` is null limit 1
select * from `visitors` where `visitors`.`id` = ? and `visitors`.`deleted_at` is null limit 1
select * from `visitors` where `visitors`.`id` = ? and `visitors`.`deleted_at` is null limit 1
select * from `visitors` where `visitors`.`id` = ? and `visitors`.`deleted_at` is null limit 1
select * from `visitors` where `visitors`.`id` = ? and `visitors`.`deleted_at` is null limit 1
select * from `visitors` where `visitors`.`id` = ? and `visitors`.`deleted_at` is null limit 1
select * from `visitors` where `visitors`.`id` = ? and `visitors`.`deleted_at` is null limit 1
select * from `visitors` where `visitors`.`id` = ? and `visitors`.`deleted_at` is null limit 1
Facebook Twitter LinkedIN Telegram WhatsApp Reddit