ProductRepository.php#76u542788397_6val770μsselect*from `products` where (`added_by` ='admin') andexists (select*from `brands` where `products`.`brand_id` = `brands`.`id` and (`status` =1)) and (`status` =1) and (`request_status` =1) and (exists (select*from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` ='approved')) or ((`added_by` ='admin'and `status` =1))) and `product_type` in ('physical') and (`slug` ='o-ZKlk8A') limit 1
ProductRepository.php#76u542788397_6val240μsselect*from `translations` where `translations`.`translationable_id` in (93) and `translations`.`translationable_type` ='App\\Models\\Product'and `locale` ='en'
ProductRepository.php#328u542788397_6val520μsselectcount(*) as aggregate from `products` where (`added_by` ='admin') andexists (select*from `brands` where `products`.`brand_id` = `brands`.`id` and (`status` =1)) and (`status` =1) and (`request_status` =1) and (exists (select*from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` ='approved')) or ((`added_by` ='admin'and `status` =1))) and `product_type` in ('physical') and (`added_by` ='admin') and `user_id` =1and `id` notin (93)
ProductRepository.php#328u542788397_6val2.22msselect*from `products` where (`added_by` ='admin') andexists (select*from `brands` where `products`.`brand_id` = `brands`.`id` and (`status` =1)) and (`status` =1) and (`request_status` =1) and (exists (select*from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` ='approved')) or ((`added_by` ='admin'and `status` =1))) and `product_type` in ('physical') and (`added_by` ='admin') and `user_id` =1and `id` notin (93) orderby `id` desc limit 5offset0
ProductRepository.php#328u542788397_6val310μsselect*from `translations` where `translations`.`translationable_id` in (119, 120, 121, 122, 123) and `translations`.`translationable_type` ='App\\Models\\Product'and `locale` ='en'
ProductRepository.php#328u542788397_6val230μsselect*from `reviews` where `reviews`.`product_id` in (119, 120, 121, 122, 123) and `delivery_man_id` isnulland `status` =1
ProductRepository.php#328u542788397_6val490μsselectcount(*) as aggregate from `products` where (`added_by` ='admin') andexists (select*from `brands` where `products`.`brand_id` = `brands`.`id` and (`status` =1)) and (`status` =1) and (`request_status` =1) and (exists (select*from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` ='approved')) or ((`added_by` ='admin'and `status` =1))) and `product_type` in ('physical') and (`added_by` ='admin') and `user_id` =1
ProductRepository.php#328u542788397_6val820μsselect `products`.*, (selectcount(*) from `reviews` where `products`.`id` = `reviews`.`product_id` and `status` =1and `status` =1) as `reviews_count` from `products` where (`added_by` ='admin') andexists (select*from `brands` where `products`.`brand_id` = `brands`.`id` and (`status` =1)) and (`status` =1) and (`request_status` =1) and (exists (select*from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` ='approved')) or ((`added_by` ='admin'and `status` =1))) and `product_type` in ('physical') and (`added_by` ='admin') and `user_id` =1 limit 25offset0
ProductRepository.php#328u542788397_6val440μsselectcount(*) as aggregate from `products` where (`added_by` ='admin') andexists (select*from `brands` where `products`.`brand_id` = `brands`.`id` and (`status` =1)) and (`status` =1) and (`request_status` =1) and (exists (select*from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` ='approved')) or ((`added_by` ='admin'and `status` =1))) and `product_type` in ('physical') and `id` notin (93)
ProductRepository.php#328u542788397_6val570μsselect*from `products` where (`added_by` ='admin') andexists (select*from `brands` where `products`.`brand_id` = `brands`.`id` and (`status` =1)) and (`status` =1) and (`request_status` =1) and (exists (select*from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` ='approved')) or ((`added_by` ='admin'and `status` =1))) and `product_type` in ('physical') and `id` notin (93) limit 12offset0
category-manager.php#82u542788397_6val1.1msselect `categories`.*, (selectcount(*) from `products` where `categories`.`id` = `products`.`category_id` and (`added_by` ='admin') andexists (select*from `brands` where `products`.`brand_id` = `brands`.`id` and (`status` =1)) and (`status` =1) and (`request_status` =1) and (exists (select*from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` ='approved')) or ((`added_by` ='admin'and `status` =1))) and `product_type` in ('physical')) as `product_count` from `categories` where `position` =0
category-manager.php#82u542788397_6val1.18msselect `products`.*, (selectcount(*) from `order_details` where `products`.`id` = `order_details`.`product_id`) as `order_details_count` from `products` where `products`.`category_id` in (1, 2) and (`added_by` ='admin') andexists (select*from `brands` where `products`.`brand_id` = `brands`.`id` and (`status` =1)) and (`status` =1) and (`request_status` =1) and (exists (select*from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` ='approved')) or ((`added_by` ='admin'and `status` =1))) and `product_type` in ('physical')
category-manager.php#82u542788397_6val680μsselect `categories`.*, (selectcount(*) from `products` where `categories`.`id` = `products`.`sub_category_id`) as `sub_category_product_count` from `categories` where `categories`.`parent_id` in (1, 2) and `position` =1orderby `priority` asc
category-manager.php#82u542788397_6val270μsselect `categories`.*, (selectcount(*) from `products` where `categories`.`id` = `products`.`sub_sub_category_id`) as `sub_sub_category_product_count` from `categories` where `categories`.`parent_id` in (3, 7, 8, 9, 10, 11, 12, 13, 14) and `position` =2orderby `priority` asc
category-manager.php#82u542788397_6val240μsselect*from `translations` where `translations`.`translationable_id` in (1, 2) and `translations`.`translationable_type` ='App\\Models\\Category'and `locale` ='en'
brand-manager.php#58u542788397_6val790μsselect `brands`.*, (selectcount(*) from `products` where `brands`.`id` = `products`.`brand_id` and (`added_by` ='admin') andexists (select*from `brands` where `products`.`brand_id` = `brands`.`id` and (`status` =1)) and (`status` =1) and (`request_status` =1) and (exists (select*from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` ='approved')) or ((`added_by` ='admin'and `status` =1))) and `product_type` in ('physical')) as `brand_products_count` from `brands` where `status` =1orderby `created_at` desc
brand-manager.php#58u542788397_6val350μsselect*from `translations` where `translations`.`translationable_id` in (2, 3, 4, 6, 7) and `translations`.`translationable_type` ='App\\Models\\Brand'and `locale` ='en'
_header.blade.php#366u542788397_6val1.06msselectcount(*) as aggregate from `products` where (`added_by` ='admin') andexists (select*from `brands` where `products`.`brand_id` = `brands`.`id` and (`status` =1)) and (`status` =1) and (`request_status` =1) and (exists (select*from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` ='approved')) or ((`added_by` ='admin'and `status` =1))) and `product_type` in ('physical') and `discount` !=0