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) LIMIT21OFFSET21
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)
LIMIT21OFFSET21
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) LIMIT21OFFSET21;
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 (50,51,52,53,55,56,57,58,59,60,61,62,63,64,65,66,67,68,70,71,72)) AND (p0_.deleted_atISNULL);