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);
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) LIMIT21OFFSET105
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)
LIMIT21OFFSET105
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) LIMIT21OFFSET105;
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 (201,205,206,207,208,209,278,279,280,281,282,283,284,285,287,288,450,458)) 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);