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) LIMIT21OFFSET63
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)
LIMIT21OFFSET63
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) LIMIT21OFFSET63;
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 (125,156,157,158,159,162,163,164,165,166,167,168,169,170,171,172,173,174,175,176,177)) AND (p0_.deleted_atISNULL);