EstablishmentController.php#78primodishnew1.74msselectcount(*) as aggregate from `dishes` where `dishes`.`restaurant_id` =437and `dishes`.`restaurant_id` isnotnullandexists (select*from `establishments` where `dishes`.`restaurant_id` = `establishments`.`id` and `id` =437and `establishments`.`deleted_at` isnull) and `dishes`.`deleted_at` isnulland `moderate` ='Approved'
InteractsWithMedia.php#545primodishnew4.45msselect*from `media` where `media`.`model_id` in (437) and `media`.`model_type` ='App\\Models\\Establishment'
establishmentlisting.blade.php#555primodishnew1.08msselect `dishes`.*, (selectcount(*) from `reviews` where `dishes`.`id` = `reviews`.`dish_id` and `reviews`.`deleted_at` isnulland `id` in (select `id` from `reviews` as `r1` where `r1`.`deleted_at` isnulland `r1`.`dish_id` = `reviews`.`dish_id` and `r1`.`visitor_id` = `reviews`.`visitor_id` and r1.id = (
SELECTMAX(r2.id)
FROM reviews AS r2
WHERE r2.dish_id = r1.dish_id
AND r2.visitor_id = r1.visitor_id
AND r2.deleted_at ISNULL
)) andexists (select*from `visitors` where `reviews`.`visitor_id` = `visitors`.`id` and `deleted_at` isnulland `visitors`.`deleted_at` isnull) andexists (select*from `dishes` where `reviews`.`dish_id` = `dishes`.`id` and `deleted_at` isnulland `dishes`.`deleted_at` isnulland `moderate` ='Approved') and `reviews`.`deleted_at` isnull) as `latest_reviews_count` from `dishes` where `dishes`.`restaurant_id` =437and `dishes`.`restaurant_id` isnotnulland `dishes`.`deleted_at` isnulland `dishes`.`deleted_at` isnulland `moderate` ='Approved'having `latest_reviews_count` >0
Facebook Twitter LinkedIN Telegram WhatsApp Reddit