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_.category_idIN (?,?) ANDp1_.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_.category_idIN (?,?)
ANDp1_.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_.category_idIN (67,63) ANDp1_.brand_idIN (1)) 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_.category_idIN (?,?) ANDp1_.brand_idIN (?)) AND (p0_.deleted_atISNULL) LIMIT21OFFSET21
SELECTDISTINCTp0_.idASid_0FROMproduct_variantp0_INNER JOINproductp1_ONp0_.product_id=p1_.idAND (p1_.deleted_atISNULL)
AND (p1_.is_active=1)
WHERE
(
p0_.is_active=1ANDp1_.category_idIN (?,?)
ANDp1_.brand_idIN (?)
)
AND (p0_.deleted_atISNULL)
LIMIT21OFFSET21
SELECTDISTINCTp0_.idASid_0FROMproduct_variantp0_INNER JOINproductp1_ONp0_.product_id=p1_.idAND (p1_.deleted_atISNULL) AND (p1_.is_active=1) WHERE (p0_.is_active=1ANDp1_.category_idIN (67,63) ANDp1_.brand_idIN (1)) AND (p0_.deleted_atISNULL) LIMIT21OFFSET21;
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_.category_idIN (?,?) ANDp1_.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_.category_idIN (?,?)
ANDp1_.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_.category_idIN (67,63) ANDp1_.brand_idIN (1) ANDp0_.idIN (152,153,154,155)) 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_.category_idIN (?,?) ANDp1_.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_.category_idIN (?,?)
ANDp1_.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_.category_idIN (67,63) ANDp1_.brand_idIN (1)) AND (p0_.deleted_atISNULL);
SELECTc0_.idASid_0,c0_.nameASname_1,c0_.slugASslug_2,c0_.descriptionASdescription_3,c0_.lftASlft_4,c0_.lvlASlvl_5,c0_.rgtASrgt_6,c0_.image_pathASimage_path_7,c0_.banner_image_pathASbanner_image_path_8,c0_.is_activeASis_active_9,c0_.meta_titleASmeta_title_10,c0_.meta_descriptionASmeta_description_11,c0_.meta_keywordsASmeta_keywords_12,c0_.created_atAScreated_at_13,c0_.updated_atASupdated_at_14,c0_.deleted_atASdeleted_at_15,c0_.tree_rootAStree_root_16,c0_.parent_idASparent_id_17FROMcategoryc0_WHERE (c0_.lft<=1ANDc0_.rgt>=20ANDc0_.tree_root=?) AND (c0_.deleted_atISNULL) ORDER BYc0_.lftASC
SELECTc0_.idASid_0,c0_.nameASname_1,c0_.slugASslug_2,c0_.descriptionASdescription_3,c0_.lftASlft_4,c0_.lvlASlvl_5,c0_.rgtASrgt_6,c0_.image_pathASimage_path_7,c0_.banner_image_pathASbanner_image_path_8,c0_.is_activeASis_active_9,c0_.meta_titleASmeta_title_10,c0_.meta_descriptionASmeta_description_11,c0_.meta_keywordsASmeta_keywords_12,c0_.created_atAScreated_at_13,c0_.updated_atASupdated_at_14,c0_.deleted_atASdeleted_at_15,c0_.tree_rootAStree_root_16,c0_.parent_idASparent_id_17FROMcategoryc0_WHERE
(
c0_.lft<=1ANDc0_.rgt>=20ANDc0_.tree_root=?
)
AND (c0_.deleted_atISNULL)
ORDER BYc0_.lftASC
SELECTc0_.idASid_0,c0_.nameASname_1,c0_.slugASslug_2,c0_.descriptionASdescription_3,c0_.lftASlft_4,c0_.lvlASlvl_5,c0_.rgtASrgt_6,c0_.image_pathASimage_path_7,c0_.banner_image_pathASbanner_image_path_8,c0_.is_activeASis_active_9,c0_.meta_titleASmeta_title_10,c0_.meta_descriptionASmeta_description_11,c0_.meta_keywordsASmeta_keywords_12,c0_.created_atAScreated_at_13,c0_.updated_atASupdated_at_14,c0_.deleted_atASdeleted_at_15,c0_.tree_rootAStree_root_16,c0_.parent_idASparent_id_17FROMcategoryc0_WHERE (c0_.lft<=1ANDc0_.rgt>=20ANDc0_.tree_root=56) AND (c0_.deleted_atISNULL) ORDER BYc0_.lftASC;