VisitorsListController.php#403primodishnew670μsselect `visitors_lists`.*, (selectcount(*) from `list_dishes` where `visitors_lists`.`id` = `list_dishes`.`list_id` and `list_dishes`.`deleted_at` isnull) as `list_dishes_count` from `visitors_lists` where `id` in (1773, 1774, 1775, 1776) and `visitors_lists`.`deleted_at` isnullorderby `list_name` asc, `updated_at` desc
Visitor.php#191primodishnew510μsselect `dish_id` from `reviews` where `reviews`.`visitor_id` =495and `reviews`.`visitor_id` isnotnullandexists (select*from `dishes` where `reviews`.`dish_id` = `dishes`.`id` and `deleted_at` isnulland `dishes`.`deleted_at` isnulland `moderate` ='Approved') and `deleted_at` isnulland `id` in (1631) 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
lists.blade.php#300primodishnew420μsselectcount(*) as aggregate from `list_dishes` where `list_dishes`.`list_id` =1773and `list_dishes`.`list_id` isnotnullandexists (select*from `dishes` where `list_dishes`.`dish_id` = `dishes`.`id` and `deleted_at` isnulland `moderate` ='approved'and `deleted_at` isnulland `dishes`.`deleted_at` isnulland `moderate` ='Approved') and `list_dishes`.`deleted_at` isnull
lists.blade.php#300primodishnew410μsselectcount(*) as aggregate from `list_dishes` where `list_dishes`.`list_id` =1775and `list_dishes`.`list_id` isnotnullandexists (select*from `visitors_lists` where `list_dishes`.`related_list_id` = `visitors_lists`.`id` and `deleted_at` isnulland `visibility` ='public'and `deleted_at` isnulland `visitors_lists`.`deleted_at` isnull) and `list_dishes`.`deleted_at` isnull
lists.blade.php#300primodishnew450μsselectcount(*) as aggregate from `list_dishes` where `list_dishes`.`list_id` =1774and `list_dishes`.`list_id` isnotnullandexists (select*from `establishments` where `list_dishes`.`establishment_id` = `establishments`.`id` and `deleted_at` isnulland `deleted_at` isnulland `establishments`.`deleted_at` isnull) and `list_dishes`.`deleted_at` isnull
lists.blade.php#300primodishnew380μsselectcount(*) as aggregate from `list_dishes` where `list_dishes`.`list_id` =1776and `list_dishes`.`list_id` isnotnullandexists (select*from `reviews` where `list_dishes`.`review_id` = `reviews`.`id` and `deleted_at` isnulland `deleted_at` isnulland `reviews`.`deleted_at` isnull) and `list_dishes`.`deleted_at` isnull
Facebook Twitter LinkedIN Telegram WhatsApp Reddit