SELECTc0_.idASid_0,c0_.nameASname_1,c0_.slugASslug_2,c0_.lftASlft_3,c0_.lvlASlvl_4,c0_.rgtASrgt_5,c0_.image_pathASimage_path_6,c0_.banner_image_pathASbanner_image_path_7,c0_.is_activeASis_active_8FROMcategoryc0_WHERE (c0_.is_active=1) AND (c0_.deleted_atISNULL) ORDER BYc0_.tree_rootASC,c0_.lftASC
SELECTc0_.idASid_0,c0_.nameASname_1,c0_.slugASslug_2,c0_.lftASlft_3,c0_.lvlASlvl_4,c0_.rgtASrgt_5,c0_.image_pathASimage_path_6,c0_.banner_image_pathASbanner_image_path_7,c0_.is_activeASis_active_8FROMcategoryc0_WHERE
(c0_.is_active=1)
AND (c0_.deleted_atISNULL)
ORDER BYc0_.tree_rootASC,c0_.lftASC
SELECTc0_.idASid_0,c0_.nameASname_1,c0_.slugASslug_2,c0_.lftASlft_3,c0_.lvlASlvl_4,c0_.rgtASrgt_5,c0_.image_pathASimage_path_6,c0_.banner_image_pathASbanner_image_path_7,c0_.is_activeASis_active_8FROMcategoryc0_WHERE (c0_.is_active=1) AND (c0_.deleted_atISNULL) ORDER BYc0_.tree_rootASC,c0_.lftASC;
SELECTDISTINCTp0_.idASid_0,p0_.final_priceASfinal_price_1FROMproduct_variantp0_WHERE (p0_.is_active=1) AND (p0_.deleted_atISNULL) ORDER BYp0_.final_priceDESCLIMIT21
SELECTDISTINCTp0_.idASid_0,p0_.final_priceASfinal_price_1FROMproduct_variantp0_WHERE
(p0_.is_active=1)
AND (p0_.deleted_atISNULL)
ORDER BYp0_.final_priceDESCLIMIT21
SELECTDISTINCTp0_.idASid_0,p0_.final_priceASfinal_price_1FROMproduct_variantp0_WHERE (p0_.is_active=1) AND (p0_.deleted_atISNULL) ORDER BYp0_.final_priceDESCLIMIT21;
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 (377,378,384,361,376,343,379,348,362,433,354,358,357,355,151,380,300,147,344,231,432)) AND (p0_.deleted_atISNULL) ORDER BYp0_.final_priceDESC;