Печально наблюдаю запросы с выполнением ~1 секунда, приводящие к subj.
Не могу понять - это из стандартного функционала или нет?
[CODE]SEL ECT DISTINCT
BE.DETAIL_PICTURE as DETAIL_PICTURE,
BE.ID as ID,
BE.IBLOCK_ID as IBLOCK_ID,
BE.IBLOCK_SECTION_ID as IBLOCK_SECTION_ID,
BE.NAME as NAME,
IF(
EXTRACT(HOUR_SECOND FR OM
BE.ACTIVE_FROM)>0,
DATE_FORMAT(
BE.ACTIVE_FROM,
'%d.%m.%Y %H:%i:%s'
),
DATE_FORMAT(
BE.ACTIVE_FROM,
'%d.%m.%Y'
)
) as ACTIVE_FROM,
B.DETAIL_PAGE_URL as DETAIL_PAGE_URL,
BE.DETAIL_TEXT as DETAIL_TEXT,
BE.DETAIL_TEXT_TYPE as DETAIL_TEXT_TYPE,
BE.PREVIEW_TEXT as PREVIEW_TEXT,
BE.PREVIEW_TEXT_TYPE as PREVIEW_TEXT_TYPE,
BE.PREVIEW_PICTURE as PREVIEW_PICTURE,
FPS0. *,
L.DIR as LANG_DIR,
BE.SORT as SORT,
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
FR OM
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
INNER JOIN b_iblock_element_prop_s121 FPS0 ON
FPS0.IBLOCK_ELEMENT_ID = BE.ID
LEFT JOIN b_iblock_property FP0 ON
FP0.IBLOCK_ID = B.ID
AND FP0.CODE = 'CAT_VO'
LEFT JOIN b_iblock_property FP1 ON
FP1.IBLOCK_ID = B.ID
AND FP1.CODE = 'ARTICLE'
LEFT JOIN b_iblock_element_prop_m121 FPV0 ON
FPV0.IBLOCK_PROPERTY_ID = FP0.ID
AND FPV0.IBLOCK_ELEMENT_ID = BE.ID
LEFT JOIN b_iblock_element_prop_m121 FPV1 ON
FPV1.IBLOCK_PROPERTY_ID = FP1.ID
AND FPV1.IBLOCK_ELEMENT_ID = BE.ID
WH ERE
1 = 1
AND (
(BE.IBLOCK_ID = '121')
AND (
EXISTS (
SELECT
IBLOCK_ID
FR OM
b_iblock_site
WHERE
IBLOCK_ID = B.ID
AND (SITE_ID = 'vo')
)
)
AND (BE.ACTIVE = 'Y')
AND (
(
BE.ACTIVE_TO >= now()
OR BE.ACTIVE_TO IS NULL
)
AND (
BE.ACTIVE_FROM <= now()
OR BE.ACTIVE_FROM IS NULL
)
)
AND (
BE.ID IS NULL
OR NOT (
BE.ID IN ('353983', '353934', '353998', '353987', '353978', '353957', '353951', '353945', '353939', '353927', '353914', '353905', '353901', '353898', '353892', '353887', '353884', '353881', '353875', '353811', '353767', '353680', '353604', '353608', '352904', '352677', '352241', '353869', '353844', '353837', '353829', '352060', '345659')
)
)
AND (FPV0.VALUE_ENUM IS NOT NULL)
AND (FPS0.PROPERTY_521 IS NULL)
AND (FPV1.VALUE_ENUM IS NULL)
)
AND (
BE.WF_STATUS_ID = 1
AND BE.WF_PARENT_ELEMENT_ID IS NULL
)
AND (
B.ID IN (
SELECT
IBLOCK_ID
FROM
b_iblock_group IBG
WHERE
IBG.GROUP_ID IN (2)
AND IBG.PERMISSION >= 'R'
AND (
IBG.PERMISSION = 'X'
OR B.ACTIVE = 'Y'
)
)
OR (
B.RIGHTS_MODE = 'E'
AND EXISTS (
SELECT
ER.ELEMENT_ID
FROM
b_iblock_element_right ER
INNER JOIN b_iblock_right IBR ON
IBR.ID = ER.RIGHT_ID
INNER JOIN b_user_access UA ON
UA.ACCESS_CODE = IBR.GROUP_CODE
AND UA.USER_ID = 0
WHERE
ER.ELEMENT_ID = BE.ID
AND IBR.OP_EREAD = 'Y'
)
)
)
ORDER BY
BE.ACTIVE_FROM DESC,
BE.SORT ASC,
BE.ID DESC
LIM IT 5568,
12
[/CODE]