|
Добрый день. Есть компонент catalog.section.top - кастомный, который выводит все подразделы родительского раздела. Проблема заключается в кол-ве запросов на страницу. Есть разделы, где много подразделов, от этого страдает время загрузки. Задача уменьшить кол-во запросов. Запросы следующего вида : | SEL ECT CI.*, I.ID as ID, I.IBLOCK_TYPE_ID, I.LID, I.NAME, OFFERS.IBLOCK_ID OFFERS_IBLOCK_ID, OF... (1) | 0.00006 | 2 | SEL ECT DISTINCT BS.*, B.LIST_PAGE_URL, B.SECTION_PAGE_URL, B.IBLOCK_TYPE_ID, B.... (1) | 0.00031 | 3 | SEL ECT `iblock_inherited_property`.`ID` AS `ID` FR OM `b_iblock_iproperty` `iblock_inherited_proper... (1) | 0.00005 | 4 | SEL ECT `iblock_section_property`.`PROPERTY_ID` AS `PROPERTY_ID`, `iblock_section_property_propert... (14) | 0.00041 | 5 | sel ect CATALOG_GROUP_ID, BUY fr om b_catalog_group2group where GROUP_ID in (1,2,3,4,12) and CATALOG_G... (1) | 0.00007 | 6 | SEL ECT DISTINCT BE.ID as ID,BE.IBLOCK_ID as IBLOCK_ID,BE.CODE as CODE,BE.XML_ID as XML_ID,BE.N... (1) | 0.01479 | 7 | SELECT P.ID ,P.CODE ,P.TEMPLATE ,P.ENTITY_TYPE ,P.ENTITY_ID ,IP.V... (1) | 0.00009 | 8 | SELECT BP.*, BEP.ID as PROPERTY_VALUE_ID, BEP.VALUE, BEP.DESCRIPTION, BEPE.VALUE VALUE_ENUM, BEP... (1) | 0.00369 | 9 | SELECT `sale_internals_fuser`.`ID` AS `ID` FR OM `b_sale_fuser` `sale_internals_fuser` WH ERE `sal... (52) | 0.00005 | 10 | SELECT P.ID ,P.CODE ,P.TEMPLATE ,P.ENTITY_TYPE ,P.ENTITY_ID ,IP.V... (1) | 0.00094 | 11 | SELECT f.*,DATE_FORMAT(f.TIMESTAMP_X, '%d.%m.%Y %H:%i:%s') as TIMESTAMP_X FR OM b_file f WHE... (1) | 0.00010 | 12 | SELECT BP.*, BEP.ID as PROPERTY_VALUE_ID, BEP.VALUE, BEP.DESCRIPTION, BEPE.VALUE VALUE_ENUM, BEP... (1) | 0.00357 | 13 | SELECT `iblock_element`.`ID` AS `ID`, `iblock_element`.`IBLOCK_ID` AS `IBLOCK_ID` FR OM `b_iblock_... (2) | 0.00015 | 14 | SELECT BE.ID as ID,BE.IBLOCK_ID as IBLOCK_ID, FPV0.VALUE as PROPERTY_37_VALUE, FPV0.ID as PROP... (1) | 0.00047 | 15 | SELECT `catalog_price`.`ID` AS `ID`, `catalog_price`.`PRODUCT_ID` AS `PRODUCT_ID`, `catalog_pric... (1) | 0.00006 | 16 | SELECT `catalog_catalog_iblock`.`IBLOCK_ID` AS `IBLOCK_ID`, `catalog_catalog_iblock`.`PRODUCT_IBL... (50) | 0.00004 | 17 | SELECT `catalog_price`.`PRODUCT_ID` AS `PRODUCT_ID`, `catalog_price`.`CATALOG_GROUP_ID` AS `CATAL... (1) | 0.00003 | 18 | SELECT `iblock_element`.`ID` AS `ID` FR OM `b_iblock_element` `iblock_element` WH ERE `iblock_elem... (1) | 0.00019 | 19 | SELECT `iblock_section_element`.`IBLOCK_SECTION_ID` AS `IBLOCK_SECTION_ID`, `iblock_section_eleme... (1) | 0.00005 | 20 | SELECT BS.ID AS ID, BS.IBLOCK_SECTION_ID AS IBLOCK_SECTION_ID FR OM b_iblock_s... (1) | 0.00003 | 21 | SELECT `iblock_property`.`ID` AS `ID`, `iblock_property`.`IBLOCK_ID` AS `IBLOCK_ID`, `iblock_pro... (50) | 0.00008 | 22 | SELECT `iblock_property_enumeration`.`ID` AS `ID`, `iblock_property_enumeration`.`PROPERTY_ID` AS... (50) | 0.00005 | 23 | SELECT BE.ID IBLOCK_ELEMENT_ID ,BEP.IBLOCK_PROPERTY_ID ,BEP.VALUE ,BEP.VALU... (1) | 0.00056 | 24 | SELECT `iblock_property`.`ID` AS `ID`, `iblock_property`.`IBLOCK_ID` AS `IBLOCK_ID`, `iblock_pro... (50) | 0.00007 | 25 | SELECT P.ID ,P.CODE ,P.TEMPLATE ,P.ENTITY_TYPE ,P.ENTITY_ID ,IP.V... (1) | 0.00121 | 26 | SELECT f.*,DATE_FORMAT(f.TIMESTAMP_X, '%d.%m.%Y %H:%i:%s') as TIMESTAMP_X FR OM b_file f WHE... (1) | 0.00015 | 27 | SELECT BP.*, BEP.ID as PROPERTY_VALUE_ID, BEP.VALUE, BEP.DESCRIPTION, BEPE.VALUE VALUE_ENUM, BEP... (1) | 0.00591 |
|