select `products`.*, (selectcount(*) from `reviews` where `products`.`id` = `reviews`.`product_id` and `delivery_man_id` isnulland `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) 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` ='makhana-seeds-47df72') limit 1
select*from `translations` where `translations`.`translationable_id` in (1604) and `translations`.`translationable_type` ='App\Models\Product'and `locale` ='en'
selectcount(*) 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) 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` ='admin') and `user_id` =4and `id` notin (1604)
select `products`.*, (selectcount(*) from `reviews` where `products`.`id` = `reviews`.`product_id` and `delivery_man_id` isnulland `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) 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` ='admin') and `user_id` =4and `id` notin (1604) orderby `id` desc limit 5offset0
select*from `translations` where `translations`.`translationable_id` in (1600, 1601, 1602, 1603, 1605) and `translations`.`translationable_type` ='App\Models\Product'and `locale` ='en'
selectcount(*) 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) 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` ='admin') and `user_id` =4
select `products`.*, (selectcount(*) from `reviews` where `products`.`id` = `reviews`.`product_id` and `status` =1and `status` =1) as `reviews_count`, (selectcount(*) from `reviews` where `products`.`id` = `reviews`.`product_id` and `delivery_man_id` isnulland `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) 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` ='admin') and `user_id` =4 limit 25offset0
selectcount(*) 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) 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 `id` notin (1604)
select `products`.*, (selectcount(*) from `reviews` where `products`.`id` = `reviews`.`product_id` and `delivery_man_id` isnulland `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) 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 `id` notin (1604) limit 12offset0
select*from `translations` where `translations`.`translationable_id` in (55) and `translations`.`translationable_type` ='App\Models\Category'and `locale` ='en'
select `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) 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
select*from `translations` where `translations`.`translationable_id` in (37) and `translations`.`translationable_type` ='App\Models\Brand'and `locale` ='en'
selectcount(*) 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) 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