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 `style_id` in ('5') 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 (11) 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 (11)
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)