НПА (проекты и официально опубликованные)

Запрос № 1:

SELECT BP.*
FROM
b_iblock_property BP
WHERE
BP.ACTIVE = 'Y' AND BP.USER_TYPE = 'DateTime' AND BP.IBLOCK_ID = 4
ORDER BY
BP.SORT ASC, BP.NAME ASC

Откуда вызван:

(1.1)/home/bitrix/www/bitrix/modules/iblock/classes/general/iblockproperty.php:126
CAllDatabase->Query(...)

(1.2)/home/bitrix/www/local/components/rating1c/news.calendar/component.php:100
CAllIBlockProperty::GetList(Array ( ) )

(1.3)/home/bitrix/www/bitrix/modules/main/classes/general/component.php:615
include(Array ( [0] => /home/bitrix/www/local/components/rating1c/news.calendar/component.php ) )

(1.4)/home/bitrix/www/bitrix/modules/main/classes/general/component.php:692
CBitrixComponent->__includeComponent(Array ( ) )

(1.5)/home/bitrix/www/bitrix/modules/main/classes/general/main.php:1195
CBitrixComponent->includeComponent(Array ( ) )

(1.6)/home/bitrix/www/sect_sidebar.php:5
CAllMain->IncludeComponent(Array ( ) )

(1.7)/home/bitrix/www/bitrix/components/bitrix/main.include/templates/.default/template.php:17
include(Array ( [0] => /home/bitrix/www/sect_sidebar.php ) )

(1.8)/home/bitrix/www/bitrix/modules/main/classes/general/component_template.php:790
include(Array ( [0] => /home/bitrix/www/bitrix/components/bitrix/main.include/templates/.default/template.php ) )

Время выполнения: 0.00012 сек.

Запрос № 2:

SELECT `main_localization_language`.`LID` AS `ID`, `main_localization_language`.`LID` AS `UALIAS_0`
FROM
`b_language` `main_localization_language`
WHERE
`main_localization_language`.`LID` = 'ru' AND `main_localization_language`.`ACTIVE` = 'Y'

Откуда вызван:

(1.1)/home/bitrix/www/bitrix/modules/main/lib/orm/query/query.php:3557
Bitrix\Main\DB\Connection->query(...)

(1.2)/home/bitrix/www/bitrix/modules/main/lib/orm/query/query.php:952
Bitrix\Main\ORM\Query\Query->query(Array ( ) )

(1.3)/home/bitrix/www/bitrix/modules/main/lib/orm/data/datamanager.php:513
Bitrix\Main\ORM\Query\Query->exec(Array ( ) )

(1.4)/home/bitrix/www/bitrix/modules/fileman/properties.php:821
Bitrix\Main\ORM\Data\DataManager::getList(Array ( ) )

(1.5)/home/bitrix/www/bitrix/modules/main/tools.php:4741
CIBlockPropertyMapYandex::GetUserTypeDescription(Array ( ) )

(1.6)/home/bitrix/www/bitrix/modules/iblock/classes/general/iblockproperty.php:1148
ExecuteModuleEventEx(Array ( ) )

(1.7)/home/bitrix/www/bitrix/modules/iblock/classes/general/iblockpropresult.php:33
CAllIBlockProperty::GetUserType(Array ( ) )

(1.8)/home/bitrix/www/local/components/rating1c/news.calendar/component.php:101
CIBlockPropertyResult->Fetch(Array ( ) )

Время выполнения: 8.0E-5 сек.

Запрос № 3:

SELECT `main_localization_language`.`LID` AS `ID`, `main_localization_language`.`LID` AS `UALIAS_0`
FROM
`b_language` `main_localization_language`
WHERE
`main_localization_language`.`LID` = 'ua' AND `main_localization_language`.`ACTIVE` = 'Y'
LIMIT 0, 1

Откуда вызван:

(1.1)/home/bitrix/www/bitrix/modules/main/lib/orm/query/query.php:3557
Bitrix\Main\DB\Connection->query(...)

(1.2)/home/bitrix/www/bitrix/modules/main/lib/orm/query/query.php:952
Bitrix\Main\ORM\Query\Query->query(Array ( ) )

(1.3)/home/bitrix/www/bitrix/modules/main/lib/orm/data/datamanager.php:513
Bitrix\Main\ORM\Query\Query->exec(Array ( ) )

(1.4)/home/bitrix/www/bitrix/modules/fileman/properties.php:829
Bitrix\Main\ORM\Data\DataManager::getList(Array ( ) )

(1.5)/home/bitrix/www/bitrix/modules/main/tools.php:4741
CIBlockPropertyMapYandex::GetUserTypeDescription(Array ( ) )

(1.6)/home/bitrix/www/bitrix/modules/iblock/classes/general/iblockproperty.php:1148
ExecuteModuleEventEx(Array ( ) )

(1.7)/home/bitrix/www/bitrix/modules/iblock/classes/general/iblockpropresult.php:33
CAllIBlockProperty::GetUserType(Array ( ) )

(1.8)/home/bitrix/www/local/components/rating1c/news.calendar/component.php:101
CIBlockPropertyResult->Fetch(Array ( ) )

Время выполнения: 7.0E-5 сек.

Запрос № 1:

SET NAMES 'utf8'

Откуда вызван:

(1.1)/home/bitrix/www/bitrix/modules/main/lib/db/connection.php:380
Bitrix\Main\DB\Connection->query(...)

(1.2)/home/bitrix/www/bitrix/php_interface/after_connect_d7.php:2
Bitrix\Main\DB\Connection->queryExecute(Array ( ) )

(1.3)/home/bitrix/www/bitrix/modules/main/lib/db/connection.php:1048
include(Array ( [0] => /home/bitrix/www/bitrix/php_interface/after_connect_d7.php ) )

(1.4)/home/bitrix/www/bitrix/modules/main/lib/db/mysqliconnection.php:110
Bitrix\Main\DB\Connection->afterConnected(Array ( ) )

(1.5)/home/bitrix/www/bitrix/modules/main/lib/data/connection.php:53
Bitrix\Main\DB\MysqliConnection->connectInternal(Array ( ) )

(1.6)/home/bitrix/www/bitrix/modules/main/classes/general/database.php:305
Bitrix\Main\Data\Connection->getResource(Array ( ) )

(1.7)/home/bitrix/www/bitrix/modules/main/classes/general/database.php:703
CAllDatabase->DoConnect(Array ( ) )

(1.8)/home/bitrix/www/bitrix/modules/main/classes/general/sqlwhere.php:758
CAllDatabase->ForSql(Array ( ) )

Время выполнения: 0.00013 сек.

Запрос № 2:

SET collation_connection = "utf8_unicode_ci"

Откуда вызван:

(1.1)/home/bitrix/www/bitrix/modules/main/lib/db/connection.php:380
Bitrix\Main\DB\Connection->query(...)

(1.2)/home/bitrix/www/bitrix/php_interface/after_connect_d7.php:3
Bitrix\Main\DB\Connection->queryExecute(Array ( ) )

(1.3)/home/bitrix/www/bitrix/modules/main/lib/db/connection.php:1048
include(Array ( [0] => /home/bitrix/www/bitrix/php_interface/after_connect_d7.php ) )

(1.4)/home/bitrix/www/bitrix/modules/main/lib/db/mysqliconnection.php:110
Bitrix\Main\DB\Connection->afterConnected(Array ( ) )

(1.5)/home/bitrix/www/bitrix/modules/main/lib/data/connection.php:53
Bitrix\Main\DB\MysqliConnection->connectInternal(Array ( ) )

(1.6)/home/bitrix/www/bitrix/modules/main/classes/general/database.php:305
Bitrix\Main\Data\Connection->getResource(Array ( ) )

(1.7)/home/bitrix/www/bitrix/modules/main/classes/general/database.php:703
CAllDatabase->DoConnect(Array ( ) )

(1.8)/home/bitrix/www/bitrix/modules/main/classes/general/sqlwhere.php:758
CAllDatabase->ForSql(Array ( ) )

Время выполнения: 0.0001 сек.

Запрос № 3:

SET LOCAL time_zone='+05:00'

Откуда вызван:

(1.1)/home/bitrix/www/bitrix/modules/main/lib/db/connection.php:380
Bitrix\Main\DB\Connection->query(...)

(1.2)/home/bitrix/www/bitrix/php_interface/after_connect_d7.php:4
Bitrix\Main\DB\Connection->queryExecute(Array ( ) )

(1.3)/home/bitrix/www/bitrix/modules/main/lib/db/connection.php:1048
include(Array ( [0] => /home/bitrix/www/bitrix/php_interface/after_connect_d7.php ) )

(1.4)/home/bitrix/www/bitrix/modules/main/lib/db/mysqliconnection.php:110
Bitrix\Main\DB\Connection->afterConnected(Array ( ) )

(1.5)/home/bitrix/www/bitrix/modules/main/lib/data/connection.php:53
Bitrix\Main\DB\MysqliConnection->connectInternal(Array ( ) )

(1.6)/home/bitrix/www/bitrix/modules/main/classes/general/database.php:305
Bitrix\Main\Data\Connection->getResource(Array ( ) )

(1.7)/home/bitrix/www/bitrix/modules/main/classes/general/database.php:703
CAllDatabase->DoConnect(Array ( ) )

(1.8)/home/bitrix/www/bitrix/modules/main/classes/general/sqlwhere.php:758
CAllDatabase->ForSql(Array ( ) )

Время выполнения: 0.00012 сек.

Запрос № 4:

SET sql_mode=''

Откуда вызван:

(1.1)/home/bitrix/www/bitrix/modules/main/lib/db/connection.php:380
Bitrix\Main\DB\Connection->query(...)

(1.2)/home/bitrix/www/bitrix/php_interface/after_connect_d7.php:5
Bitrix\Main\DB\Connection->queryExecute(Array ( ) )

(1.3)/home/bitrix/www/bitrix/modules/main/lib/db/connection.php:1048
include(Array ( [0] => /home/bitrix/www/bitrix/php_interface/after_connect_d7.php ) )

(1.4)/home/bitrix/www/bitrix/modules/main/lib/db/mysqliconnection.php:110
Bitrix\Main\DB\Connection->afterConnected(Array ( ) )

(1.5)/home/bitrix/www/bitrix/modules/main/lib/data/connection.php:53
Bitrix\Main\DB\MysqliConnection->connectInternal(Array ( ) )

(1.6)/home/bitrix/www/bitrix/modules/main/classes/general/database.php:305
Bitrix\Main\Data\Connection->getResource(Array ( ) )

(1.7)/home/bitrix/www/bitrix/modules/main/classes/general/database.php:703
CAllDatabase->DoConnect(Array ( ) )

(1.8)/home/bitrix/www/bitrix/modules/main/classes/general/sqlwhere.php:758
CAllDatabase->ForSql(Array ( ) )

Время выполнения: 0.00011 сек.

Запрос № 5:

SELECT `main_user_field`.`ID` AS `ID`, `main_user_field`.`ENTITY_ID` AS `ENTITY_ID`, `main_user_field`.`FIELD_NAME` AS `FIELD_NAME`, `main_user_field`.`USER_TYPE_ID` AS `USER_TYPE_ID`, `main_user_field`.`XML_ID` AS `XML_ID`, `main_user_field`.`SORT` AS `SORT`, `main_user_field`.`MULTIPLE` AS `MULTIPLE`
FROM
`b_user_field` `main_user_field`
WHERE
`main_user_field`.`ENTITY_ID` = 'PRODUCT'
ORDER BY
`SORT` ASC, `ID` ASC

Откуда вызван:

(1.1)/home/bitrix/www/bitrix/modules/main/lib/orm/query/query.php:3557
Bitrix\Main\DB\Connection->query(...)

(1.2)/home/bitrix/www/bitrix/modules/main/lib/orm/query/query.php:952
Bitrix\Main\ORM\Query\Query->query(Array ( ) )

(1.3)/home/bitrix/www/bitrix/modules/main/lib/orm/data/datamanager.php:513
Bitrix\Main\ORM\Query\Query->exec(Array ( ) )

(1.4)/home/bitrix/www/bitrix/modules/catalog/general/querybuilder.php:839
Bitrix\Main\ORM\Data\DataManager::getList(Array ( ) )

(1.5)/home/bitrix/www/bitrix/modules/catalog/general/querybuilder.php:642
CProductQueryBuilder::getProductUserFields(Array ( ) )

(1.6)/home/bitrix/www/bitrix/modules/catalog/general/querybuilder.php:104
CProductQueryBuilder::initEntityFields(Array ( ) )

(1.7)/home/bitrix/www/bitrix/modules/iblock/classes/general/iblockelement.php:2781
CProductQueryBuilder::isValidField(Array ( ) )

(1.8)/home/bitrix/www/bitrix/modules/iblock/classes/mysql/iblockelement.php:334
CAllIBlockElement->PrepareGetList(Array ( ) )

Время выполнения: 0.00014 сек.

Запрос № 6:

SELECT `catalog_catalog_iblock`.`IBLOCK_ID` AS `IBLOCK_ID`, `catalog_catalog_iblock`.`PRODUCT_IBLOCK_ID` AS `PRODUCT_IBLOCK_ID`, `catalog_catalog_iblock`.`SKU_PROPERTY_ID` AS `SKU_PROPERTY_ID`, `catalog_catalog_iblock_iblock`.`VERSION` AS `VERSION`, `catalog_catalog_iblock_iblock`.`ID` AS `UALIAS_0`
FROM
`b_catalog_iblock` `catalog_catalog_iblock`
INNER JOIN `b_iblock` `catalog_catalog_iblock_iblock` ON `catalog_catalog_iblock`.`IBLOCK_ID` = `catalog_catalog_iblock_iblock`.`ID`
WHERE
`catalog_catalog_iblock`.`PRODUCT_IBLOCK_ID` = 18

Откуда вызван:

(1.1)/home/bitrix/www/bitrix/modules/main/lib/orm/query/query.php:3557
Bitrix\Main\DB\Connection->query(...)

(1.2)/home/bitrix/www/bitrix/modules/main/lib/orm/query/query.php:952
Bitrix\Main\ORM\Query\Query->query(Array ( ) )

(1.3)/home/bitrix/www/bitrix/modules/main/lib/orm/data/datamanager.php:513
Bitrix\Main\ORM\Query\Query->exec(Array ( ) )

(1.4)/home/bitrix/www/bitrix/modules/catalog/general/catalog_sku.php:151
Bitrix\Main\ORM\Data\DataManager::getList(Array ( ) )

(1.5)/home/bitrix/www/bitrix/modules/iblock/lib/propertyindex/facet.php:45
CCatalogSku::GetInfoByProductIBlock(Array ( ) )

(1.6)/home/bitrix/www/bitrix/modules/iblock/lib/propertyindex/querybuilder.php:28
Bitrix\Iblock\PropertyIndex\Facet->__construct(Array ( ) )

(1.7)/home/bitrix/www/bitrix/modules/iblock/classes/general/iblockelement.php:766
Bitrix\Iblock\PropertyIndex\QueryBuilder->__construct(Array ( ) )

(1.8)/home/bitrix/www/bitrix/modules/iblock/classes/general/iblockelement.php:3178
CAllIBlockElement->MkFilter(Array ( ) )

Время выполнения: 0.0001 сек.

Запрос № 7:

SELECT `iblock_property`.`ID` AS `ID`, `iblock_property`.`TIMESTAMP_X` AS `TIMESTAMP_X`, `iblock_property`.`IBLOCK_ID` AS `IBLOCK_ID`, `iblock_property`.`NAME` AS `NAME`, `iblock_property`.`ACTIVE` AS `ACTIVE`, `iblock_property`.`SORT` AS `SORT`, `iblock_property`.`CODE` AS `CODE`, `iblock_property`.`DEFAULT_VALUE` AS `DEFAULT_VALUE`, `iblock_property`.`PROPERTY_TYPE` AS `PROPERTY_TYPE`, `iblock_property`.`ROW_COUNT` AS `ROW_COUNT`, `iblock_property`.`COL_COUNT` AS `COL_COUNT`, `iblock_property`.`LIST_TYPE` AS `LIST_TYPE`, `iblock_property`.`MULTIPLE` AS `MULTIPLE`, `iblock_property`.`XML_ID` AS `XML_ID`, `iblock_property`.`FILE_TYPE` AS `FILE_TYPE`, `iblock_property`.`MULTIPLE_CNT` AS `MULTIPLE_CNT`, `iblock_property`.`TMP_ID` AS `TMP_ID`, `iblock_property`.`LINK_IBLOCK_ID` AS `LINK_IBLOCK_ID`, `iblock_property`.`WITH_DESCRIPTION` AS `WITH_DESCRIPTION`, `iblock_property`.`SEARCHABLE` AS `SEARCHABLE`, `iblock_property`.`FILTRABLE` AS `FILTRABLE`, `iblock_property`.`IS_REQUIRED` AS `IS_REQUIRED`, `iblock_property`.`VERSION` AS `VERSION`, `iblock_property`.`USER_TYPE` AS `USER_TYPE`, `iblock_property`.`USER_TYPE_SETTINGS` AS `USER_TYPE_SETTINGS_LIST`, `iblock_property`.`USER_TYPE_SETTINGS` AS `USER_TYPE_SETTINGS`, `iblock_property`.`HINT` AS `HINT`, `iblock_property_iblock`.`ID` AS `UALIAS_0`
FROM
`b_iblock_property` `iblock_property`
LEFT JOIN `b_iblock` `iblock_property_iblock` ON `iblock_property`.`IBLOCK_ID` = `iblock_property_iblock`.`ID`
WHERE
`iblock_property_iblock`.`ID` IN (18) AND UPPER(`iblock_property`.`CODE`) = 'VIEWED'

Откуда вызван:

(1.1)/home/bitrix/www/bitrix/modules/main/lib/orm/query/query.php:3557
Bitrix\Main\DB\Connection->query(...)

(1.2)/home/bitrix/www/bitrix/modules/main/lib/orm/query/query.php:952
Bitrix\Main\ORM\Query\Query->query(Array ( ) )

(1.3)/home/bitrix/www/bitrix/modules/main/lib/orm/data/datamanager.php:513
Bitrix\Main\ORM\Query\Query->exec(Array ( ) )

(1.4)/home/bitrix/www/bitrix/modules/iblock/classes/general/iblockproperty.php:849
Bitrix\Main\ORM\Data\DataManager::getList(Array ( ) )

(1.5)/home/bitrix/www/bitrix/modules/iblock/classes/general/iblockelement.php:1303
CAllIBlockProperty::GetPropertyArray(Array ( ) )

(1.6)/home/bitrix/www/bitrix/modules/iblock/classes/general/iblockelement.php:3178
CAllIBlockElement->MkFilter(Array ( ) )

(1.7)/home/bitrix/www/bitrix/modules/iblock/classes/mysql/iblockelement.php:334
CAllIBlockElement->PrepareGetList(Array ( ) )

(1.8)/home/bitrix/www/bitrix/modules/iblock/classes/mysql/iblockelement.php:692
CIBlockElement->prepareSql(Array ( ) )

Время выполнения: 9.0E-5 сек.

Запрос № 8:

SELECT `iblock_property`.`ID` AS `ID`, `iblock_property`.`TIMESTAMP_X` AS `TIMESTAMP_X`, `iblock_property`.`IBLOCK_ID` AS `IBLOCK_ID`, `iblock_property`.`NAME` AS `NAME`, `iblock_property`.`ACTIVE` AS `ACTIVE`, `iblock_property`.`SORT` AS `SORT`, `iblock_property`.`CODE` AS `CODE`, `iblock_property`.`DEFAULT_VALUE` AS `DEFAULT_VALUE`, `iblock_property`.`PROPERTY_TYPE` AS `PROPERTY_TYPE`, `iblock_property`.`ROW_COUNT` AS `ROW_COUNT`, `iblock_property`.`COL_COUNT` AS `COL_COUNT`, `iblock_property`.`LIST_TYPE` AS `LIST_TYPE`, `iblock_property`.`MULTIPLE` AS `MULTIPLE`, `iblock_property`.`XML_ID` AS `XML_ID`, `iblock_property`.`FILE_TYPE` AS `FILE_TYPE`, `iblock_property`.`MULTIPLE_CNT` AS `MULTIPLE_CNT`, `iblock_property`.`TMP_ID` AS `TMP_ID`, `iblock_property`.`LINK_IBLOCK_ID` AS `LINK_IBLOCK_ID`, `iblock_property`.`WITH_DESCRIPTION` AS `WITH_DESCRIPTION`, `iblock_property`.`SEARCHABLE` AS `SEARCHABLE`, `iblock_property`.`FILTRABLE` AS `FILTRABLE`, `iblock_property`.`IS_REQUIRED` AS `IS_REQUIRED`, `iblock_property`.`VERSION` AS `VERSION`, `iblock_property`.`USER_TYPE` AS `USER_TYPE`, `iblock_property`.`USER_TYPE_SETTINGS` AS `USER_TYPE_SETTINGS_LIST`, `iblock_property`.`USER_TYPE_SETTINGS` AS `USER_TYPE_SETTINGS`, `iblock_property`.`HINT` AS `HINT`, `iblock_property_iblock`.`ID` AS `UALIAS_0`
FROM
`b_iblock_property` `iblock_property`
LEFT JOIN `b_iblock` `iblock_property_iblock` ON `iblock_property`.`IBLOCK_ID` = `iblock_property_iblock`.`ID`
WHERE
`iblock_property_iblock`.`ID` IN (18) AND UPPER(`iblock_property`.`CODE`) = 'USER'

Откуда вызван:

(1.1)/home/bitrix/www/bitrix/modules/main/lib/orm/query/query.php:3557
Bitrix\Main\DB\Connection->query(...)

(1.2)/home/bitrix/www/bitrix/modules/main/lib/orm/query/query.php:952
Bitrix\Main\ORM\Query\Query->query(Array ( ) )

(1.3)/home/bitrix/www/bitrix/modules/main/lib/orm/data/datamanager.php:513
Bitrix\Main\ORM\Query\Query->exec(Array ( ) )

(1.4)/home/bitrix/www/bitrix/modules/iblock/classes/general/iblockproperty.php:849
Bitrix\Main\ORM\Data\DataManager::getList(Array ( ) )

(1.5)/home/bitrix/www/bitrix/modules/iblock/classes/general/iblockelement.php:1303
CAllIBlockProperty::GetPropertyArray(Array ( ) )

(1.6)/home/bitrix/www/bitrix/modules/iblock/classes/general/iblockelement.php:3178
CAllIBlockElement->MkFilter(Array ( ) )

(1.7)/home/bitrix/www/bitrix/modules/iblock/classes/mysql/iblockelement.php:334
CAllIBlockElement->PrepareGetList(Array ( ) )

(1.8)/home/bitrix/www/bitrix/modules/iblock/classes/mysql/iblockelement.php:692
CIBlockElement->prepareSql(Array ( ) )

Время выполнения: 0.0001 сек.

Запрос № 9:

SELECT BE.ID as ID,DATE_FORMAT(BE.TIMESTAMP_X, '%d.%m.%Y %H:%i:%s') as TIMESTAMP_X,UNIX_TIMESTAMP(BE.TIMESTAMP_X) as TIMESTAMP_X_UNIX,BE.MODIFIED_BY as MODIFIED_BY,DATE_FORMAT(BE.DATE_CREATE, '%d.%m.%Y %H:%i:%s') as DATE_CREATE,UNIX_TIMESTAMP(BE.DATE_CREATE) as DATE_CREATE_UNIX,BE.CREATED_BY as CREATED_BY,BE.IBLOCK_ID as IBLOCK_ID,BE.IBLOCK_SECTION_ID as IBLOCK_SECTION_ID,BE.ACTIVE as ACTIVE,BE.ACTIVE_FROM as ACTIVE_FROM_X, case when EXTRACT(HOUR
FROM
BE.ACTIVE_FROM) > 0 OR EXTRACT(MINUTE
FROM
BE.ACTIVE_FROM) > 0 OR EXTRACT(SECOND
FROM
BE.ACTIVE_FROM) > 0 then DATE_FORMAT(BE.ACTIVE_FROM, '%d.%m.%Y %H:%i:%s') else DATE_FORMAT(BE.ACTIVE_FROM, '%d.%m.%Y') end as ACTIVE_FROM,case when EXTRACT(HOUR
FROM
BE.ACTIVE_TO) > 0 OR EXTRACT(MINUTE
FROM
BE.ACTIVE_TO) > 0 OR EXTRACT(SECOND
FROM
BE.ACTIVE_TO) > 0 then DATE_FORMAT(BE.ACTIVE_TO, '%d.%m.%Y %H:%i:%s') else DATE_FORMAT(BE.ACTIVE_TO, '%d.%m.%Y') end as ACTIVE_TO,case when EXTRACT(HOUR
FROM
BE.ACTIVE_FROM) > 0 OR EXTRACT(MINUTE
FROM
BE.ACTIVE_FROM) > 0 OR EXTRACT(SECOND
FROM
BE.ACTIVE_FROM) > 0 then DATE_FORMAT(BE.ACTIVE_FROM, '%d.%m.%Y %H:%i:%s') else DATE_FORMAT(BE.ACTIVE_FROM, '%d.%m.%Y') end as DATE_ACTIVE_FROM,case when EXTRACT(HOUR
FROM
BE.ACTIVE_TO) > 0 OR EXTRACT(MINUTE
FROM
BE.ACTIVE_TO) > 0 OR EXTRACT(SECOND
FROM
BE.ACTIVE_TO) > 0 then DATE_FORMAT(BE.ACTIVE_TO, '%d.%m.%Y %H:%i:%s') else DATE_FORMAT(BE.ACTIVE_TO, '%d.%m.%Y') end as DATE_ACTIVE_TO,BE.SORT as SORT,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_LAST_HISTORY_ID as WF_LAST_HISTORY_ID,BE.WF_NEW as WF_NEW,case when BE.WF_DATE_LOCK is null then 'green' when DATE_ADD(BE.WF_DATE_LOCK, INTERVAL 3600 SECOND) < NOW() then 'green' when BE.WF_LOCKED_BY = 1 then 'yellow' else 'red' end 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,DATE_FORMAT(BE.SHOW_COUNTER_START, '%d.%m.%Y %H:%i:%s') as SHOW_COUNTER_START,BE.SHOW_COUNTER_START as SHOW_COUNTER_START_X,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,') ',coalesce(U.NAME,''),' ',coalesce(U.LAST_NAME,'')) as USER_NAME,concat('(',UL.LOGIN,') ',coalesce(UL.NAME,''),' ',coalesce(UL.LAST_NAME,'')) as LOCKED_USER_NAME,concat('(',UC.LOGIN,') ',coalesce(UC.NAME,''),' ',coalesce(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,B.CANONICAL_PAGE_URL as CANONICAL_PAGE_URL,DATE_FORMAT(BE.DATE_CREATE, '%Y.%m.%d') as CREATED_DATE,case when BE.WF_STATUS_ID = 1 then 'Y' else 'N' end as BP_PUBLISHED
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='VIEWED'
INNER JOIN b_iblock_property FP1 ON FP1.IBLOCK_ID = B.ID AND FP1.CODE='USER'
LEFT JOIN b_iblock_element_property FPV0 ON FPV0.IBLOCK_PROPERTY_ID = FP0.ID AND FPV0.IBLOCK_ELEMENT_ID = BE.ID
INNER JOIN b_iblock_element_property FPV1 ON FPV1.IBLOCK_PROPERTY_ID = FP1.ID AND FPV1.IBLOCK_ELEMENT_ID = BE.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
WHERE
1=1 AND ( ((((BE.ACTIVE='Y')))) AND ((((BE.IBLOCK_ID = '18')))) AND ((( FPV0.VALUE IS NULL OR NOT (FPV0.VALUE LIKE 'Y')))) AND ((((FPV1.VALUE LIKE '1')))) ) AND (((BE.WF_STATUS_ID=1 AND BE.WF_PARENT_ELEMENT_ID IS NULL)))
ORDER BY
BE.ID desc

Откуда вызван:

(1.1)/home/bitrix/www/bitrix/modules/iblock/classes/mysql/iblockelement.php:838
CAllDatabase->Query(...)

(1.2)/home/bitrix/www/local/templates/iris/header.php:132
CIBlockElement::GetList(Array ( ) )

(1.3)/home/bitrix/www/bitrix/modules/main/include/prolog_after.php:120
include_once(Array ( [0] => /home/bitrix/www/local/templates/iris/header.php ) )

(1.4)/home/bitrix/www/bitrix/modules/main/include/prolog.php:11
require(Array ( [0] => /home/bitrix/www/bitrix/modules/main/include/prolog_after.php ) )

(1.5)/home/bitrix/www/bitrix/header.php:1
require_once(Array ( [0] => /home/bitrix/www/bitrix/modules/main/include/prolog.php ) )

(1.6)/home/bitrix/www/npa/index.php:2
require(Array ( [0] => /home/bitrix/www/bitrix/header.php ) )

(1.7)/home/bitrix/www/bitrix/modules/main/include/urlrewrite.php:184
include_once(Array ( [0] => /home/bitrix/www/npa/index.php ) )

(1.8)/home/bitrix/www/bitrix/urlrewrite.php:2
include_once(Array ( [0] => /home/bitrix/www/bitrix/modules/main/include/urlrewrite.php ) )

Время выполнения: 0.00181 сек.

Запрос № 10:

SELECT COUNT(ST.ID) as CNT
FROM
b_sticker ST
WHERE
((ST.PERSONAL='Y' AND ST.CREATED_BY=1) OR ST.PERSONAL='N') AND ST.CLOSED='N' AND ST.DELETED='N' AND ST.SITE_ID='s1' AND ST.PAGE_URL='/npa/rasshirenie-perechnya-komponentov-dlya-ts-i-skht-osvobozhdaemykh-ot-nds'

Откуда вызван:

(1.1)/home/bitrix/www/bitrix/modules/fileman/classes/general/sticker.php:354
CAllDatabase->Query(...)

(1.2)/home/bitrix/www/bitrix/modules/fileman/classes/general/sticker.php:325
CSticker::GetCount(Array ( ) )

(1.3)/home/bitrix/www/bitrix/modules/fileman/fileman.php:201
CSticker::GetCurPageCount(Array ( ) )

(1.4)/home/bitrix/www/bitrix/modules/main/tools.php:4741
CFileMan::OnPanelCreate(Array ( ) )

(1.5)/home/bitrix/www/bitrix/modules/main/public/top_panel.php:981
ExecuteModuleEventEx(Array ( ) )

(1.6)/home/bitrix/www/bitrix/modules/main/public/top_panel.php:1077
CTopPanel::InitPanelIcons(Array ( ) )

(1.7)/home/bitrix/www/bitrix/modules/main/public/top_panel.php:1093
CTopPanel::shouldShowPanel(Array ( ) )

(1.8)/home/bitrix/www/bitrix/modules/main/tools.php:4734
CTopPanel::InitPanel(Array ( ) )

Время выполнения: 0.00058 сек.