select*from `products` where `brand_id` isnulland `status` =1and (`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 ('digital', 'physical') and (`slug` ='oasis-aqua-cool-botellon-con-bomba-abajo-KAT3cl') limit 1
select*from `translations` where `translations`.`translationable_id` in (1549) and `translations`.`translationable_type` ='App\Models\Product'and `locale` ='es'
selectcount(*) as aggregate from `products` where `brand_id` isnulland `status` =1and (`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 ('digital', 'physical') and (`added_by` ='admin') and `user_id` =1and `id` notin (1549)
select*from `products` where `brand_id` isnulland `status` =1and (`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 ('digital', 'physical') and (`added_by` ='admin') and `user_id` =1and `id` notin (1549) orderby `id` desc limit 5offset0
select*from `translations` where `translations`.`translationable_id` in (1989, 1990, 1991, 1992, 1993) and `translations`.`translationable_type` ='App\Models\Product'and `locale` ='es'
selectcount(*) as aggregate from `products` where `brand_id` isnulland `status` =1and (`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 ('digital', 'physical') and (`added_by` ='admin') and `user_id` =1
select `products`.*, (selectcount(*) from `reviews` where `products`.`id` = `reviews`.`product_id` and `status` =1and `status` =1) as `reviews_count` from `products` where `brand_id` isnulland `status` =1and (`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 ('digital', 'physical') and (`added_by` ='admin') and `user_id` =1 limit 25offset0
selectcount(*) as aggregate from `products` where `brand_id` isnulland `status` =1and (`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 ('digital', 'physical') and (`category_id` =3) and `id` notin (1549)
select*from `products` where `brand_id` isnulland `status` =1and (`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 ('digital', 'physical') and (`category_id` =3) and `id` notin (1549) limit 12offset0
select `categories`.*, (selectcount(*) from `products` where `categories`.`id` = `products`.`category_id` and `brand_id` isnulland `status` =1and (`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 ('digital', 'physical')) as `product_count` from `categories` where `position` =0
select `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, 3, 4, 11, 12, 13, 14, 15, 16, 17) and `brand_id` isnulland `status` =1and (`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 ('digital', 'physical')
select `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, 3, 4, 11, 12, 13, 14, 15, 16, 17) and `position` =1orderby `priority` asc
selectcount(*) as aggregate from `products` where `brand_id` isnulland `status` =1and (`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 ('digital', 'physical') and `discount` !=0