Вот из-за такого запроса жутко тормозит сайт. На сайте немаленькое число пользователей - >61000 и общее число элементов >160000
Это вроде показывает в админке статус элемента (заблокирован, свободен) (красный, желтый, зеленый круглешочек).
Можно как-то это выпилить?
Код |
---|
SEL ECT BE.SORT AS SORT, BE.ID AS ID, DATE_FORMAT( BE.TIMESTAMP_X, '%d.%m.%Y %H:%i:%s' ) AS TIMESTAMP_X, BE.MODIFIED_BY AS MODIFIED_BY, DATE_FORMAT( BE.DATE_CREATE, '%d.%m.%Y %H:%i:%s' ) AS DATE_CREATE, BE.CREATED_BY AS CREATED_BY, BE.IBLOCK_ID AS IBLOCK_ID, BE.IBLOCK_SECTION_ID AS IBLOCK_SECTION_ID, BE.ACTIVE AS ACTIVE, 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, IF( EXTRACT( HOUR_SECOND FROM BE.ACTIVE_TO ) >0, DATE_FORMAT( BE.ACTIVE_TO, '%d.%m.%Y %H:%i:%s' ) , DATE_FORMAT( BE.ACTIVE_TO, '%d.%m.%Y' ) ) AS ACTIVE_TO, IF( EXTRACT( HOUR_SECOND FROM BE.ACTIVE_FROM ) >0, DATE_FORMAT( BE.ACTIVE_FROM, '%d.%m.%Y %H:%i:%s' ) , DATE_FORMAT( BE.ACTIVE_FROM, '%d.%m.%Y' ) ) AS DATE_ACTIVE_FROM, IF( EXTRACT( HOUR_SECOND FROM BE.ACTIVE_TO ) >0, DATE_FORMAT( BE.ACTIVE_TO, '%d.%m.%Y %H:%i:%s' ) , DATE_FORMAT( BE.ACTIVE_TO, '%d.%m.%Y' ) ) AS DATE_ACTIVE_TO, BE.NAME AS NAME, BE.PREVIEW_PICTURE AS PREVIEW_PICTURE, BE.PREVIEW_TEXT AS PREVIEW_TEXT, BE.PREVIEW_TEXT_TYPE AS PREVIEW_TEXT_TYPE, BE.DETAIL_PICTURE AS DETAIL_PICTURE, BE.DETAIL_TEXT AS DETAIL_TEXT, BE.DETAIL_TEXT_TYPE AS DETAIL_TEXT_TYPE, BE.SEARCHABLE_CONTENT AS SEARCHABLE_CONTENT, BE.WF_STATUS_ID AS WF_STATUS_ID, BE.WF_PARENT_ELEMENT_ID AS WF_PARENT_ELEMENT_ID, BE.WF_NEW AS WF_NEW, IF( BE.WF_DATE_LOCK IS NULL , 'green', IF( DATE_ADD( BE.WF_DATE_LOCK, INTERVAL 60 MINUTE ) < NOW( ) , 'green', IF( BE.WF_LOCKED_BY =0, 'yellow', 'red' ) ) ) AS LOCK_STATUS, BE.WF_LOCKED_BY AS WF_LOCKED_BY, DATE_FORMAT( BE.WF_DATE_LOCK, '%d.%m.%Y %H:%i:%s' ) AS WF_DATE_LOCK, BE.WF_COMMENTS AS WF_COMMENTS, BE.IN_SECTIONS AS IN_SECTIONS, BE.SHOW_COUNTER AS SHOW_COUNTER, BE.SHOW_COUNTER_START AS SHOW_COUNTER_START, BE.CODE AS CODE, BE.TAGS AS TAGS, BE.XML_ID AS XML_ID, BE.XML_ID AS EXTERNAL_ID, BE.TMP_ID AS TMP_ID, CONCAT( '(', U.LOGIN, ') ', IFNULL( U.NAME, '' ) , ' ', IFNULL( U.LAST_NAME, '' ) ) AS USER_NAME, CONCAT( '(', UL.LOGIN, ') ', IFNULL( UL.NAME, '' ) , ' ', IFNULL( UL.LAST_NAME, '' ) ) AS LOCKED_USER_NAME, CONCAT( '(', UC.LOGIN, ') ', IFNULL( UC.NAME, '' ) , ' ', IFNULL( UC.LAST_NAME, '' ) ) AS CREATED_USER_NAME, L.DIR AS LANG_DIR, B.LID AS LID, B.IBLOCK_TYPE_ID AS IBLOCK_TYPE_ID, B.CODE AS IBLOCK_CODE, B.NAME AS IBLOCK_NAME, B.XML_ID AS IBLOCK_EXTERNAL_ID, B.DETAIL_PAGE_URL AS DETAIL_PAGE_URL, B.LIST_PAGE_URL AS LIST_PAGE_URL, DATE_FORMAT( BE.DATE_CREATE, '%Y.%m.%d' ) AS CREATED_DATE, IF( BE.WF_STATUS_ID =1, 'Y', 'N' ) AS BP_PUBLISHED 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 LEFT JOIN b_user U ON U.ID = BE.MODIFIED_BY LEFT JOIN b_user UL ON UL.ID = BE.WF_LOCKED_BY LEFT JOIN b_user UC ON UC.ID = BE.CREATED_BY WH ERE 1 =1 AND ( ( ( ( ( B.CODE LIKE 'color' ) ) ) ) ) AND ( ( ( BE.WF_STATUS_ID =1 AND BE.WF_PARENT_ELEMENT_ID IS NULL ) ) ) ORDER BY BE.SORT ASC |
Можно как-то это выпилить?
А все-таки жаль: иногда над победами нашими
встают пьедесталы, которые выше побед. Булат Окуджава
встают пьедесталы, которые выше побед. Булат Окуджава