Делал работу по оптимизации сайта, поменял каталог.секшин поменял хидер. может ли из за этого перестать работать компонент фильтр?
У меня все работает с одним параметром но когда я еще выбираю какой нибудь параметр например(вес) выпадает вот такие запросы SELECT COUNT(DISTINCT BE.ID) as C FROM b_iblock B INNER JOIN b_lang L ON B.LID=L.LID INNER JOIN b_iblock_element BE ON BE.IBLOCK_ID = B.ID LEFT JOIN b_iblock_property FP1 ON FP1.IBLOCK_ID=B.ID AND FP1.CODE='CML2_ARTICLE' LEFT JOIN b_iblock_element_property FPV1 ON FP1.ID=FPV1.IBLOCK_PROPERTY_ID AND FPV1.IBLOCK_ELEMENT_ID=BE.ID INNER JOIN b_iblock_property FP2 ON FP2.IBLOCK_ID=B.ID AND FP2.CODE='FILTER_PROIZ' INNER JOIN b_iblock_element_property FPV2 ON FP2.ID=FPV2.IBLOCK_PROPERTY_ID AND FPV2.IBLOCK_ELEMENT_ID=BE.ID LEFT JOIN b_iblock_property FP3 ON FP3.IBLOCK_ID=B.ID AND FP3.CODE='CML2_MODEL' LEFT JOIN b_iblock_element_property FPV3 ON FP3.ID=FPV3.IBLOCK_PROPERTY_ID AND FPV3.IBLOCK_ELEMENT_ID=BE.ID LEFT JOIN b_iblock_property FP4 ON FP4.IBLOCK_ID=B.ID AND FP4.CODE='CML2_NAME' LEFT JOIN b_iblock_element_property FPV4 ON FP4.ID=FPV4.IBLOCK_PROPERTY_ID AND FPV4.IBLOCK_ELEMENT_ID=BE.ID LEFT JOIN b_iblock_property FP5 ON FP5.IBLOCK_ID=B.ID AND FP5.CODE='CML2_EXISTENZ' LEFT JOIN b_iblock_element_property FPV5 ON FP5.ID=FPV5.IBLOCK_PROPERTY_ID AND FPV5.IBLOCK_ELEMENT_ID=BE.ID LEFT JOIN b_iblock_property FP6 ON FP6.IBLOCK_ID=B.ID AND FP6.CODE='FILTER_PRICE' LEFT JOIN b_iblock_element_property FPV6 ON FP6.ID=FPV6.IBLOCK_PROPERTY_ID AND FPV6.IBLOCK_ELEMENT_ID=BE.ID LEFT JOIN b_iblock_property FP7 ON FP7.IBLOCK_ID=B.ID AND FP7.CODE='FILTER_WEIGHT' LEFT JOIN b_iblock_element_property FPV7 ON FP7.ID=FPV7.IBLOCK_PROPERTY_ID AND FPV7.IBLOCK_ELEMENT_ID=BE.ID INNER JOIN b_iblock_property FP8 ON FP8.IBLOCK_ID=B.ID AND FP8.CODE='FILTER_FREQ' INNER JOIN b_iblock_element_property FPV8 ON FP8.ID=FPV8.IBLOCK_PROPERTY_ID AND FPV8.IBLOCK_ELEMENT_ID=BE.ID LEFT JOIN b_iblock_property FP9 ON FP9.IBLOCK_ID=B.ID AND FP9.CODE='FILTER_RAM' LEFT JOIN b_iblock_element_property FPV9 ON FP9.ID=FPV9.IBLOCK_PROPERTY_ID AND FPV9.IBLOCK_ELEMENT_ID=BE.ID LEFT JOIN b_iblock_property FP10 ON FP10.IBLOCK_ID=B.ID AND FP10.CODE='FILTER_HARDDRIVE' LEFT JOIN b_iblock_element_property FPV10 ON FP10.ID=FPV10.IBLOCK_PROPERTY_ID AND FPV10.IBLOCK_ELEMENT_ID=BE.ID LEFT JOIN b_iblock_property FP11 ON FP11.IBLOCK_ID=B.ID AND FP11.CODE='FILTER_DIAGONAL' LEFT JOIN b_iblock_element_property FPV11 ON FP11.ID=FPV11.IBLOCK_PROPERTY_ID AND FPV11.IBLOCK_ELEMENT_ID=BE.ID LEFT JOIN b_iblock_property FP12 ON FP12.IBLOCK_ID=B.ID AND FP12.CODE='MODEL_VIDEO' LEFT JOIN b_iblock_element_property FPV12 ON FP12.ID=FPV12.IBLOCK_PROPERTY_ID AND FPV12.IBLOCK_ELEMENT_ID=BE.ID LEFT JOIN b_catalog_price CAT_P1 ON (CAT_P1.PRODUCT_ID = BE.ID AND CAT_P1.CATALOG_GROUP_ID = 1) LEFT JOIN b_catalog_price CAT_P2 ON (CAT_P2.PRODUCT_ID = BE.ID AND CAT_P2.CATALOG_GROUP_ID = 2) LEFT JOIN b_catalog_price CAT_P5 ON (CAT_P5.PRODUCT_ID = BE.ID AND CAT_P5.CATALOG_GROUP_ID = 5) LEFT JOIN b_catalog_product CAT_PR ON (CAT_PR.ID = BE.ID) WHERE 1=1 AND B.ID IN (0,42) AND ( (BE.WF_STATUS_ID=1 AND BE.WF_PARENT_ELEMENT_ID IS NULL) ) AND (((( (upper(FPV2.VALUE) like upper('%SAMSUNG%') and FPV2.VALUE is not null) )))) AND ((((FPV8.VALUE_NUM >= '1')))) AND ((((FPV8.VALUE_NUM <= '1.5')))) AND ((((BE.IBLOCK_ID = '42')))) AND (((BE.ACTIVE_TO >= now() OR BE.ACTIVE_TO IS NULL) AND (BE.ACTIVE_FROM <= now() OR BE.ACTIVE_FROM IS NULL))) AND ((((BE.ACTIVE='Y')))) AND (((CAT_P2.PRICE > '0'))) AND (((CAT_P2.PRICE >= '713.689273964'))) AND (((CAT_P2.PRICE <= '892.111592455'))) AND ((CAT_P5.QUANTITY_FROM <= 1 OR CAT_P5.QUANTITY_FROM IS NULL) AND (CAT_P5.QUANTITY_TO >= 1 OR CAT_P5.QUANTITY_TO IS NULL))
У меня все работает с одним параметром но когда я еще выбираю какой нибудь параметр например(вес) выпадает вот такие запросы SELECT COUNT(DISTINCT BE.ID) as C FROM b_iblock B INNER JOIN b_lang L ON B.LID=L.LID INNER JOIN b_iblock_element BE ON BE.IBLOCK_ID = B.ID LEFT JOIN b_iblock_property FP1 ON FP1.IBLOCK_ID=B.ID AND FP1.CODE='CML2_ARTICLE' LEFT JOIN b_iblock_element_property FPV1 ON FP1.ID=FPV1.IBLOCK_PROPERTY_ID AND FPV1.IBLOCK_ELEMENT_ID=BE.ID INNER JOIN b_iblock_property FP2 ON FP2.IBLOCK_ID=B.ID AND FP2.CODE='FILTER_PROIZ' INNER JOIN b_iblock_element_property FPV2 ON FP2.ID=FPV2.IBLOCK_PROPERTY_ID AND FPV2.IBLOCK_ELEMENT_ID=BE.ID LEFT JOIN b_iblock_property FP3 ON FP3.IBLOCK_ID=B.ID AND FP3.CODE='CML2_MODEL' LEFT JOIN b_iblock_element_property FPV3 ON FP3.ID=FPV3.IBLOCK_PROPERTY_ID AND FPV3.IBLOCK_ELEMENT_ID=BE.ID LEFT JOIN b_iblock_property FP4 ON FP4.IBLOCK_ID=B.ID AND FP4.CODE='CML2_NAME' LEFT JOIN b_iblock_element_property FPV4 ON FP4.ID=FPV4.IBLOCK_PROPERTY_ID AND FPV4.IBLOCK_ELEMENT_ID=BE.ID LEFT JOIN b_iblock_property FP5 ON FP5.IBLOCK_ID=B.ID AND FP5.CODE='CML2_EXISTENZ' LEFT JOIN b_iblock_element_property FPV5 ON FP5.ID=FPV5.IBLOCK_PROPERTY_ID AND FPV5.IBLOCK_ELEMENT_ID=BE.ID LEFT JOIN b_iblock_property FP6 ON FP6.IBLOCK_ID=B.ID AND FP6.CODE='FILTER_PRICE' LEFT JOIN b_iblock_element_property FPV6 ON FP6.ID=FPV6.IBLOCK_PROPERTY_ID AND FPV6.IBLOCK_ELEMENT_ID=BE.ID LEFT JOIN b_iblock_property FP7 ON FP7.IBLOCK_ID=B.ID AND FP7.CODE='FILTER_WEIGHT' LEFT JOIN b_iblock_element_property FPV7 ON FP7.ID=FPV7.IBLOCK_PROPERTY_ID AND FPV7.IBLOCK_ELEMENT_ID=BE.ID INNER JOIN b_iblock_property FP8 ON FP8.IBLOCK_ID=B.ID AND FP8.CODE='FILTER_FREQ' INNER JOIN b_iblock_element_property FPV8 ON FP8.ID=FPV8.IBLOCK_PROPERTY_ID AND FPV8.IBLOCK_ELEMENT_ID=BE.ID LEFT JOIN b_iblock_property FP9 ON FP9.IBLOCK_ID=B.ID AND FP9.CODE='FILTER_RAM' LEFT JOIN b_iblock_element_property FPV9 ON FP9.ID=FPV9.IBLOCK_PROPERTY_ID AND FPV9.IBLOCK_ELEMENT_ID=BE.ID LEFT JOIN b_iblock_property FP10 ON FP10.IBLOCK_ID=B.ID AND FP10.CODE='FILTER_HARDDRIVE' LEFT JOIN b_iblock_element_property FPV10 ON FP10.ID=FPV10.IBLOCK_PROPERTY_ID AND FPV10.IBLOCK_ELEMENT_ID=BE.ID LEFT JOIN b_iblock_property FP11 ON FP11.IBLOCK_ID=B.ID AND FP11.CODE='FILTER_DIAGONAL' LEFT JOIN b_iblock_element_property FPV11 ON FP11.ID=FPV11.IBLOCK_PROPERTY_ID AND FPV11.IBLOCK_ELEMENT_ID=BE.ID LEFT JOIN b_iblock_property FP12 ON FP12.IBLOCK_ID=B.ID AND FP12.CODE='MODEL_VIDEO' LEFT JOIN b_iblock_element_property FPV12 ON FP12.ID=FPV12.IBLOCK_PROPERTY_ID AND FPV12.IBLOCK_ELEMENT_ID=BE.ID LEFT JOIN b_catalog_price CAT_P1 ON (CAT_P1.PRODUCT_ID = BE.ID AND CAT_P1.CATALOG_GROUP_ID = 1) LEFT JOIN b_catalog_price CAT_P2 ON (CAT_P2.PRODUCT_ID = BE.ID AND CAT_P2.CATALOG_GROUP_ID = 2) LEFT JOIN b_catalog_price CAT_P5 ON (CAT_P5.PRODUCT_ID = BE.ID AND CAT_P5.CATALOG_GROUP_ID = 5) LEFT JOIN b_catalog_product CAT_PR ON (CAT_PR.ID = BE.ID) WHERE 1=1 AND B.ID IN (0,42) AND ( (BE.WF_STATUS_ID=1 AND BE.WF_PARENT_ELEMENT_ID IS NULL) ) AND (((( (upper(FPV2.VALUE) like upper('%SAMSUNG%') and FPV2.VALUE is not null) )))) AND ((((FPV8.VALUE_NUM >= '1')))) AND ((((FPV8.VALUE_NUM <= '1.5')))) AND ((((BE.IBLOCK_ID = '42')))) AND (((BE.ACTIVE_TO >= now() OR BE.ACTIVE_TO IS NULL) AND (BE.ACTIVE_FROM <= now() OR BE.ACTIVE_FROM IS NULL))) AND ((((BE.ACTIVE='Y')))) AND (((CAT_P2.PRICE > '0'))) AND (((CAT_P2.PRICE >= '713.689273964'))) AND (((CAT_P2.PRICE <= '892.111592455'))) AND ((CAT_P5.QUANTITY_FROM <= 1 OR CAT_P5.QUANTITY_FROM IS NULL) AND (CAT_P5.QUANTITY_TO >= 1 OR CAT_P5.QUANTITY_TO IS NULL))