| 24284 | sphinx     | 192.168.0.7:56920    | bitrix | Query       |   139 | Sending data                                                  | SELECT DISTINCT     (@ROW := @ROW + 1) AS ID    ,'' AS FIX,     sec.ID AS SECTION_ID,     prop.ID AS PROPERTY_ID,     prop.PROPERTY_TYPE AS PROPERTY_TYPE,     propValue.VALUE AS VALUE,     propValue.VALUE_NUM AS VALUE_NUM,     propValue.VALUE_ENUM AS VALUE_ENUM,     propEnum.XML_ID AS ENUM_XML_ID,     propEnum.VALUE AS ENUM_VALUE,     elSec.IBLOCK_ELEMENT_ID AS ELEMENT_ID    FROM b_iblock_section_element AS elSec    INNER JOIN a_catalog_properties_topnav ptopnav on (elSec.IBLOCK_SECTION_ID = ptopnav.SECTION_ID)    JOIN (    SELECT @ROW := 0) AS tmp    INNER JOIN b_iblock_section AS sec ON elSec.IBLOCK_SECTION_ID = sec.ID    INNER JOIN b_iblock_element_property AS propValue ON elSec.IBLOCK_ELEMENT_ID = propValue.IBLOCK_ELEMENT_ID    INNER JOIN b_iblock_property AS prop ON propValue.IBLOCK_PROPERTY_ID = prop.ID    LEFT JOIN b_iblock_property_enum AS propEnum ON propValue.VALUE_ENUM = propEnum.ID AND prop.PROPERTY_TYPE = 'L' AND propEnum.VALUE != 'Y'    WHERE    sec.ID IN (select DISTINCT ptopnav.SECTION_ID    from a_catalog_properties_topnav ptopnav) AND    sec.IBLOCK_ID = 56 AND prop.SORT >= 10000 AND prop.PROPERTY_TYPE IN ('N', 'L', 'E') |