SELECTDISTINCTp0_.idASid_0,p0_.final_priceASfinal_price_1FROMproduct_variantp0_WHERE (p0_.is_active=1) AND (p0_.deleted_atISNULL) ORDER BYp0_.final_priceDESCLIMIT21OFFSET42
SELECTDISTINCTp0_.idASid_0,p0_.final_priceASfinal_price_1FROMproduct_variantp0_WHERE
(p0_.is_active=1)
AND (p0_.deleted_atISNULL)
ORDER BYp0_.final_priceDESCLIMIT21OFFSET42
SELECTDISTINCTp0_.idASid_0,p0_.final_priceASfinal_price_1FROMproduct_variantp0_WHERE (p0_.is_active=1) AND (p0_.deleted_atISNULL) ORDER BYp0_.final_priceDESCLIMIT21OFFSET42;
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_WHERE (p0_.is_active=1ANDp0_.idIN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)) AND (p0_.deleted_atISNULL) ORDER BYp0_.final_priceDESC
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_WHERE
(
p0_.is_active=1ANDp0_.idIN (
?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?
)
)
AND (p0_.deleted_atISNULL)
ORDER BYp0_.final_priceDESC
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_WHERE (p0_.is_active=1ANDp0_.idIN (294,297,150,27,87,69,5,88,146,479,291,375,97,125,124,202,292,83,347,439,471)) AND (p0_.deleted_atISNULL) ORDER BYp0_.final_priceDESC;