Работает на Битрикс.
2. Из-за сложных запросов битрикса к mySQL не выдерживает сервер хостера.
Пример запроса:
PHP:
скопировать код в буфер обмена
скопировать код в буфер обмена
- SELECT DISTINCT
- BE.ID as ID,
- BE.NAME as NAME,
- BE.IBLOCK_SECTION_ID as IBLOCK_SECTION_ID,
- BE.IBLOCK_ID as IBLOCK_ID,
- B.DETAIL_PAGE_URL as DETAIL_PAGE_URL,
- BE.DETAIL_PICTURE as DETAIL_PICTURE,
- BE.DETAIL_TEXT as DETAIL_TEXT,
- FPV0.VALUE as PROPERTY_PRICE_VALUE,
- FPV0.ID as PROPERTY_PRICE_VALUE_ID,
- FPV1.VALUE as PROPERTY_URL_VALUE,
- FPV1.ID as PROPERTY_URL_VALUE_ID,
- FPV2.VALUE as PROPERTY_VENDOR_VALUE,
- FPV2.ID as PROPERTY_VENDOR_VALUE_ID,
- FPV3.VALUE as PROPERTY_OLD_PRICE_VALUE,
- FPV3.ID as PROPERTY_OLD_PRICE_VALUE_ID,
- FPEN0.VALUE as PROPERTY_SHOP_VALUE,
- FPEN0.ID as PROPERTY_SHOP_ENUM_ID,
- FPV4.ID as PROPERTY_SHOP_VALUE_ID,
- FPV5.VALUE as PROPERTY_SIZE_VALUE,
- FPV5.ID as PROPERTY_SIZE_VALUE_ID,
- FPV6.VALUE as PROPERTY_COLOR_VALUE,
- FPV6.ID as PROPERTY_COLOR_VALUE_ID,
- FPV7.VALUE as PROPERTY_PICTURE_VALUE,
- FPV7.ID as PROPERTY_PICTURE_VALUE_ID,
- BE.CODE as CODE,
- BE.XML_ID as EXTERNAL_ID,
- B.IBLOCK_TYPE_ID as IBLOCK_TYPE_ID,
- B.CODE as IBLOCK_CODE,
- B.XML_ID as IBLOCK_EXTERNAL_ID,
- B.LID as LID,
- BE.DETAIL_TEXT_TYPE as DETAIL_TEXT_TYPE
- 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 FP0 ON
- FP0.IBLOCK_ID = B.ID
- AND FP0.CODE = 'PRICE'
- LEFT JOIN b_iblock_property FP1 ON
- FP1.IBLOCK_ID = B.ID
- AND FP1.CODE = 'URL'
- LEFT JOIN b_iblock_property FP2 ON
- FP2.IBLOCK_ID = B.ID
- AND FP2.CODE = 'VENDOR'
- LEFT JOIN b_iblock_property FP3 ON
- FP3.IBLOCK_ID = B.ID
- AND FP3.CODE = 'OLD_PRICE'
- LEFT JOIN b_iblock_property FP4 ON
- FP4.IBLOCK_ID = B.ID
- AND FP4.CODE = 'SHOP'
- LEFT JOIN b_iblock_property FP5 ON
- FP5.IBLOCK_ID = B.ID
- AND FP5.CODE = 'SIZE'
- LEFT JOIN b_iblock_property FP6 ON
- FP6.IBLOCK_ID = B.ID
- AND FP6.CODE = 'COLOR'
- LEFT JOIN b_iblock_property FP7 ON
- FP7.IBLOCK_ID = B.ID
- AND FP7.CODE = 'PICTURE'
- LEFT JOIN b_iblock_element_property FPV0 ON
- FPV0.IBLOCK_PROPERTY_ID = FP0.ID
- AND FPV0.IBLOCK_ELEMENT_ID = BE.ID
- LEFT JOIN b_iblock_element_property FPV1 ON
- FPV1.IBLOCK_PROPERTY_ID = FP1.ID
- AND FPV1.IBLOCK_ELEMENT_ID = BE.ID
- LEFT JOIN b_iblock_element_property FPV2 ON
- FPV2.IBLOCK_PROPERTY_ID = FP2.ID
- AND FPV2.IBLOCK_ELEMENT_ID = BE.ID
- LEFT JOIN b_iblock_element_property FPV3 ON
- FPV3.IBLOCK_PROPERTY_ID = FP3.ID
- AND FPV3.IBLOCK_ELEMENT_ID = BE.ID
- LEFT JOIN b_iblock_element_property FPV4 ON
- FPV4.IBLOCK_PROPERTY_ID = FP4.ID
- AND FPV4.IBLOCK_ELEMENT_ID = BE.ID
- LEFT JOIN b_iblock_element_property FPV5 ON
- FPV5.IBLOCK_PROPERTY_ID = FP5.ID
- AND FPV5.IBLOCK_ELEMENT_ID = BE.ID
- LEFT JOIN b_iblock_element_property FPV6 ON
- FPV6.IBLOCK_PROPERTY_ID = FP6.ID
- AND FPV6.IBLOCK_ELEMENT_ID = BE.ID
- LEFT JOIN b_iblock_element_property FPV7 ON
- FPV7.IBLOCK_PROPERTY_ID = FP7.ID
- AND FPV7.IBLOCK_ELEMENT_ID = BE.ID
- LEFT JOIN b_iblock_property_enum FPEN0 ON
- FPEN0.PROPERTY_ID = FPV4.IBLOCK_PROPERTY_ID
- AND FPV4.VALUE_ENUM = FPEN0.ID
- WHERE
- 1 = 1
- AND (
- (BE.ID = '730902')
- AND (BE.IBLOCK_ID = '1')
- 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 (
- BE.WF_STATUS_ID = 1
- AND BE.WF_PARENT_ELEMENT_ID IS NULL
- )