selectcount(*) as aggregate from `products` whereexists (select*from `categories` where `products`.`category_id` = `categories`.`id` and (`main` in ('1') or `id` in ('1')))
select `products`.*, (selectcount(*) from `reviews` where `products`.`id` = `reviews`.`reviewable_id` and `reviews`.`reviewable_type` ='App\\Models\\Product'and `status` =1) as `verified_reviews_count`, (selectavg(`reviews`.`rating`) from `reviews` where `products`.`id` = `reviews`.`reviewable_id` and `reviews`.`reviewable_type` ='App\\Models\\Product'and `status` =1) as `verified_reviews_avg_rating` from `products` whereexists (select*from `categories` where `products`.`category_id` = `categories`.`id` and (`main` in ('1') or `id` in ('1'))) orderby `created_at` desc limit 60offset0
select `sales`.*, `product_sale`.`product_id` as `pivot_product_id`, `product_sale`.`sale_id` as `pivot_sale_id` from `sales` innerjoin `product_sale` on `sales`.`id` = `product_sale`.`sale_id` where `product_sale`.`product_id` in (2, 4, 5, 6, 7, 11, 13) orderby `expires_at` desc
select `colors`.*, `color_product`.`product_id` as `pivot_product_id`, `color_product`.`color_id` as `pivot_color_id`, `color_product`.`image` as `pivot_image` from `colors` innerjoin `color_product` on `colors`.`id` = `color_product`.`color_id` where `color_product`.`product_id` in (2, 4, 5, 6, 7, 11, 13)
select `products`.*, (selectcount(*) from `reviews` where `products`.`id` = `reviews`.`reviewable_id` and `reviews`.`reviewable_type` ='App\\Models\\Product'and `status` =1) as `verified_reviews_count`, (selectavg(`reviews`.`rating`) from `reviews` where `products`.`id` = `reviews`.`reviewable_id` and `reviews`.`reviewable_type` ='App\\Models\\Product'and `status` =1) as `verified_reviews_avg_rating` from `products` where (`title_en` like'%%'or `title_ar` like'%%'or `title_ku` like'%%'or `description_en` like'%%'or `description_ar` like'%%'or `description_ku` like'%%') limit 5
select `sales`.*, `product_sale`.`product_id` as `pivot_product_id`, `product_sale`.`sale_id` as `pivot_sale_id` from `sales` innerjoin `product_sale` on `sales`.`id` = `product_sale`.`sale_id` where `product_sale`.`product_id` in (2, 4, 5, 6, 7) orderby `expires_at` desc
select `colors`.*, `color_product`.`product_id` as `pivot_product_id`, `color_product`.`color_id` as `pivot_color_id`, `color_product`.`image` as `pivot_image` from `colors` innerjoin `color_product` on `colors`.`id` = `color_product`.`color_id` where `color_product`.`product_id` in (2, 4, 5, 6, 7)