SELECTCOUNT(DISTINCTp0_.id) ASsclr_0FROMproduct_variantp0_INNER JOINproductp1_ONp0_.product_id=p1_.idAND (p1_.deleted_atISNULL) AND (p1_.is_active=1) WHERE (p0_.is_active=1ANDp1_.brand_idIN (?)) AND (p0_.deleted_atISNULL)
SELECTCOUNT(DISTINCTp0_.id) ASsclr_0FROMproduct_variantp0_INNER JOINproductp1_ONp0_.product_id=p1_.idAND (p1_.deleted_atISNULL)
AND (p1_.is_active=1)
WHERE
(
p0_.is_active=1ANDp1_.brand_idIN (?)
)
AND (p0_.deleted_atISNULL)
SELECTCOUNT(DISTINCTp0_.id) ASsclr_0FROMproduct_variantp0_INNER JOINproductp1_ONp0_.product_id=p1_.idAND (p1_.deleted_atISNULL) AND (p1_.is_active=1) WHERE (p0_.is_active=1ANDp1_.brand_idIN (2)) AND (p0_.deleted_atISNULL);
SELECTMIN(p0_.final_price) ASsclr_0,MAX(p0_.final_price) ASsclr_1FROMproduct_variantp0_INNER JOINproductp1_ONp0_.product_id=p1_.idAND (p1_.deleted_atISNULL) AND (p1_.is_active=1) WHERE (p0_.is_active=1ANDp1_.brand_idIN (?)) AND (p0_.deleted_atISNULL)
SELECTMIN(p0_.final_price) ASsclr_0,MAX(p0_.final_price) ASsclr_1FROMproduct_variantp0_INNER JOINproductp1_ONp0_.product_id=p1_.idAND (p1_.deleted_atISNULL)
AND (p1_.is_active=1)
WHERE
(
p0_.is_active=1ANDp1_.brand_idIN (?)
)
AND (p0_.deleted_atISNULL)
SELECTMIN(p0_.final_price) ASsclr_0,MAX(p0_.final_price) ASsclr_1FROMproduct_variantp0_INNER JOINproductp1_ONp0_.product_id=p1_.idAND (p1_.deleted_atISNULL) AND (p1_.is_active=1) WHERE (p0_.is_active=1ANDp1_.brand_idIN (2)) AND (p0_.deleted_atISNULL);
SELECTDISTINCTp0_.idASid_0FROMproduct_variantp0_INNER JOINproductp1_ONp0_.product_id=p1_.idAND (p1_.deleted_atISNULL) AND (p1_.is_active=1) WHERE (p0_.is_active=1ANDp1_.brand_idIN (?)) AND (p0_.deleted_atISNULL) LIMIT21OFFSET42
SELECTDISTINCTp0_.idASid_0FROMproduct_variantp0_INNER JOINproductp1_ONp0_.product_id=p1_.idAND (p1_.deleted_atISNULL)
AND (p1_.is_active=1)
WHERE
(
p0_.is_active=1ANDp1_.brand_idIN (?)
)
AND (p0_.deleted_atISNULL)
LIMIT21OFFSET42
SELECTDISTINCTp0_.idASid_0FROMproduct_variantp0_INNER JOINproductp1_ONp0_.product_id=p1_.idAND (p1_.deleted_atISNULL) AND (p1_.is_active=1) WHERE (p0_.is_active=1ANDp1_.brand_idIN (2)) AND (p0_.deleted_atISNULL) LIMIT21OFFSET42;
SELECTp0_.idASsclr_0,p0_.nameASsclr_1,p0_.slugASsclr_2,p0_.sale_priceASsclr_3,p0_.solde_priceASsclr_4,p0_.discountASsclr_5,p0_.final_priceASsclr_6,p0_.is_new_arrivalASsclr_7,p0_.is_special_offerASsclr_8,p0_.main_image_pathASsclr_9FROMproduct_variantp0_INNER JOINproductp1_ONp0_.product_id=p1_.idAND (p1_.deleted_atISNULL) AND (p1_.is_active=1) WHERE (p0_.is_active=1ANDp1_.brand_idIN (?) ANDp0_.idIN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)) AND (p0_.deleted_atISNULL)
SELECTp0_.idASsclr_0,p0_.nameASsclr_1,p0_.slugASsclr_2,p0_.sale_priceASsclr_3,p0_.solde_priceASsclr_4,p0_.discountASsclr_5,p0_.final_priceASsclr_6,p0_.is_new_arrivalASsclr_7,p0_.is_special_offerASsclr_8,p0_.main_image_pathASsclr_9FROMproduct_variantp0_INNER JOINproductp1_ONp0_.product_id=p1_.idAND (p1_.deleted_atISNULL)
AND (p1_.is_active=1)
WHERE
(
p0_.is_active=1ANDp1_.brand_idIN (?)
ANDp0_.idIN (
?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?
)
)
AND (p0_.deleted_atISNULL)
SELECTp0_.idASsclr_0,p0_.nameASsclr_1,p0_.slugASsclr_2,p0_.sale_priceASsclr_3,p0_.solde_priceASsclr_4,p0_.discountASsclr_5,p0_.final_priceASsclr_6,p0_.is_new_arrivalASsclr_7,p0_.is_special_offerASsclr_8,p0_.main_image_pathASsclr_9FROMproduct_variantp0_INNER JOINproductp1_ONp0_.product_id=p1_.idAND (p1_.deleted_atISNULL) AND (p1_.is_active=1) WHERE (p0_.is_active=1ANDp1_.brand_idIN (2) ANDp0_.idIN (73,74,75,76,77,78,79,80,81,82,83,84,85,86,87,88,90,91,92,94,124)) AND (p0_.deleted_atISNULL);