ProductDetailsController.php#54housyegc_housy_nn320μsselect*from `translations` where `translations`.`translationable_id` in (106) and `translations`.`translationable_type` ='App\\Models\\Product'and `locale` ='en'
ProductDetailsController.php#54housyegc_housy_nn260μsselect*from `reviews` where `reviews`.`product_id` in (106) and `delivery_man_id` isnulland `status` =1
ProductRepository.php#76housyegc_housy_nn850μsselect*from `products` where (exists (select*from `brands` where `products`.`brand_id` = `brands`.`id` and (`status` =1)) and (`status` =1) and (`request_status` =1) or (`brand_id` isnulland `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 ('digital', 'physical') and (`slug` ='lighting-Pi7f3r') limit 1
ProductRepository.php#76housyegc_housy_nn310μsselect*from `translations` where `translations`.`translationable_id` in (106) and `translations`.`translationable_type` ='App\\Models\\Product'and `locale` ='en'
ProductRepository.php#311housyegc_housy_nn1.14msselectcount(*) as aggregate from `products` where (exists (select*from `brands` where `products`.`brand_id` = `brands`.`id` and (`status` =1)) and (`status` =1) and (`request_status` =1) or (`brand_id` isnulland `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 ('digital', 'physical') and (`added_by` ='seller') and `user_id` =7and `id` notin (106)
ProductRepository.php#311housyegc_housy_nn2.38msselect*from `products` where (exists (select*from `brands` where `products`.`brand_id` = `brands`.`id` and (`status` =1)) and (`status` =1) and (`request_status` =1) or (`brand_id` isnulland `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 ('digital', 'physical') and (`added_by` ='seller') and `user_id` =7and `id` notin (106) orderby `id` desc limit 5offset0
ProductRepository.php#311housyegc_housy_nn310μsselect*from `translations` where `translations`.`translationable_id` in (139, 140, 141, 142, 143) and `translations`.`translationable_type` ='App\\Models\\Product'and `locale` ='en'
ProductRepository.php#311housyegc_housy_nn260μsselect*from `reviews` where `reviews`.`product_id` in (139, 140, 141, 142, 143) and `delivery_man_id` isnulland `status` =1
ProductRepository.php#311housyegc_housy_nn1.01msselectcount(*) as aggregate from `products` where (exists (select*from `brands` where `products`.`brand_id` = `brands`.`id` and (`status` =1)) and (`status` =1) and (`request_status` =1) or (`brand_id` isnulland `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 ('digital', 'physical') and (`added_by` ='seller') and `user_id` =7
ProductRepository.php#311housyegc_housy_nn1.05msselect `products`.*, (selectcount(*) from `reviews` where `products`.`id` = `reviews`.`product_id` and `status` =1and `status` =1) as `reviews_count` from `products` where (exists (select*from `brands` where `products`.`brand_id` = `brands`.`id` and (`status` =1)) and (`status` =1) and (`request_status` =1) or (`brand_id` isnulland `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 ('digital', 'physical') and (`added_by` ='seller') and `user_id` =7 limit 25offset0
ProductRepository.php#311housyegc_housy_nn1.71msselectcount(*) as aggregate from `products` where (exists (select*from `brands` where `products`.`brand_id` = `brands`.`id` and (`status` =1)) and (`status` =1) and (`request_status` =1) or (`brand_id` isnulland `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 ('digital', 'physical') and (`category_id` =10) and `id` notin (106)
ProductRepository.php#311housyegc_housy_nn840μsselect*from `products` where (exists (select*from `brands` where `products`.`brand_id` = `brands`.`id` and (`status` =1)) and (`status` =1) and (`request_status` =1) or (`brand_id` isnulland `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 ('digital', 'physical') and (`category_id` =10) and `id` notin (106) limit 12offset0
brand-manager.php#31housyegc_housy_nn18.43msselect `brands`.*, (selectcount(*) from `products` where `brands`.`id` = `products`.`brand_id` and (exists (select*from `brands` where `products`.`brand_id` = `brands`.`id` and (`status` =1)) and (`status` =1) and (`request_status` =1) or (`brand_id` isnulland `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 ('digital', 'physical')) as `brand_products_count` from `brands` where `status` =1orderby `created_at` desc
_header.blade.php#342housyegc_housy_nn1.55msselectcount(*) as aggregate from `products` where (exists (select*from `brands` where `products`.`brand_id` = `brands`.`id` and (`status` =1)) and (`status` =1) and (`request_status` =1) or (`brand_id` isnulland `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 ('digital', 'physical') and `discount` !=0