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