DishController.php#110primodishnew450μsselect `dish_categories`.*, `dish_dish_category`.`dish_id` as `pivot_dish_id`, `dish_dish_category`.`dish_category_id` as `pivot_dish_category_id` from `dish_categories` innerjoin `dish_dish_category` on `dish_categories`.`id` = `dish_dish_category`.`dish_category_id` where `dish_dish_category`.`dish_id` in (1220) and `dish_categories`.`deleted_at` isnull
DishController.php#110primodishnew390μsselect `m_dietry_considerations`.*, `dish_m_dietry_consideration`.`dish_id` as `pivot_dish_id`, `dish_m_dietry_consideration`.`m_dietry_consideration_id` as `pivot_m_dietry_consideration_id` from `m_dietry_considerations` innerjoin `dish_m_dietry_consideration` on `m_dietry_considerations`.`id` = `dish_m_dietry_consideration`.`m_dietry_consideration_id` where `dish_m_dietry_consideration`.`dish_id` in (1220) and `m_dietry_considerations`.`deleted_at` isnull
DishController.php#110primodishnew370μsselect*from `visitors_recommendations` where `visitors_recommendations`.`dish_id` in (1220) and `visitors_recommendations`.`deleted_at` isnull
DishController.php#110primodishnew400μsselect*from `visitors_saved_search_results` where `visitors_saved_search_results`.`dish_id` in (1220) and `visitors_saved_search_results`.`deleted_at` isnull
DishController.php#110primodishnew670μsselect*from `reviews` where `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`.`dish_id` in (1220) and `reviews`.`deleted_at` isnull
DishController.php#162primodishnew630μsselectcount(*) as aggregate from `reviews` where `reviews`.`dish_id` =1220and `reviews`.`dish_id` isnotnulland `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
DishController.php#162primodishnew720μsselect*from `reviews` where `reviews`.`dish_id` =1220and `reviews`.`dish_id` isnotnulland `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` isnullorderby `reviews`.`created_at` desc limit 10offset0
InteractsWithMedia.php#545primodishnew440μsselect*from `media` where `media`.`model_id` in (400) and `media`.`model_type` ='App\\Models\\Establishment'
InteractsWithMedia.php#545primodishnew350μsselect*from `media` where `media`.`model_id` in (400) and `media`.`model_type` ='App\\Models\\Establishment'
Dish.php#153primodishnew3.33msselectavg(`reviews`.`rating`) as aggregate from `reviews` innerjoin (SELECT dish_id, visitor_id, MAX(created_at) AS max_created_at
FROM reviews
WHERE deleted_at ISNULLGROUPBY 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` innerjoin `dishes` on `reviews`.`dish_id` = `dishes`.`id` innerjoin `visitors` on `reviews`.`visitor_id` = `visitors`.`id` where `reviews`.`dish_id` =1220and `reviews`.`dish_id` isnotnulland `dishes`.`deleted_at` isnulland `visitors`.`deleted_at` isnulland `reviews`.`deleted_at` isnull
Dish.php#153primodishnew2.87msselectavg(`reviews`.`rating`) as aggregate from `reviews` innerjoin (SELECT dish_id, visitor_id, MAX(created_at) AS max_created_at
FROM reviews
WHERE deleted_at ISNULLGROUPBY 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` innerjoin `dishes` on `reviews`.`dish_id` = `dishes`.`id` innerjoin `visitors` on `reviews`.`visitor_id` = `visitors`.`id` where `reviews`.`dish_id` =1220and `reviews`.`dish_id` isnotnulland `dishes`.`deleted_at` isnulland `visitors`.`deleted_at` isnulland `reviews`.`deleted_at` isnull
Dish.php#99primodishnew740μsselectcount(*) as aggregate from `reviews` where `reviews`.`dish_id` =1220and `reviews`.`dish_id` isnotnulland `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
Dish.php#99primodishnew660μsselectcount(*) as aggregate from `reviews` where `reviews`.`dish_id` =1220and `reviews`.`dish_id` isnotnulland `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
Dish.php#153primodishnew2.73msselectavg(`reviews`.`rating`) as aggregate from `reviews` innerjoin (SELECT dish_id, visitor_id, MAX(created_at) AS max_created_at
FROM reviews
WHERE deleted_at ISNULLGROUPBY 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` innerjoin `dishes` on `reviews`.`dish_id` = `dishes`.`id` innerjoin `visitors` on `reviews`.`visitor_id` = `visitors`.`id` where `reviews`.`dish_id` =1220and `reviews`.`dish_id` isnotnulland `dishes`.`deleted_at` isnulland `visitors`.`deleted_at` isnulland `reviews`.`deleted_at` isnull
dishlisting.blade.php#1117primodishnew370μsselectcount(*) as aggregate from `reviews` where `reviews`.`dish_id` =1220and `reviews`.`dish_id` isnotnulland `reviews`.`deleted_at` isnull
InteractsWithMedia.php#545primodishnew320μsselect*from `media` where `media`.`model_id` in (400) and `media`.`model_type` ='App\\Models\\Establishment'
reviewbox.blade.php#67primodishnew910μsselect `m_dietry_considerations`.*, `m_dietry_consideration_review`.`review_id` as `pivot_review_id`, `m_dietry_consideration_review`.`m_dietry_consideration_id` as `pivot_m_dietry_consideration_id` from `m_dietry_considerations` innerjoin `m_dietry_consideration_review` on `m_dietry_considerations`.`id` = `m_dietry_consideration_review`.`m_dietry_consideration_id` where `m_dietry_consideration_review`.`review_id` =1388and `m_dietry_considerations`.`deleted_at` isnull
Facebook Twitter LinkedIN Telegram WhatsApp Reddit