# Time: 141026 2:11:44 # User@Host: mediaryazan[mediaryazan] @ [127.0.0.1] # Query_time: 3.548305 Lock_time: 0.000138 Rows_sent: 84 Rows_examined: 16369 SET timestamp=1414275104; /* #0 /var/www/mediaryazan/html/bitrix/modules/main/classes/mysql/database.php(161): CDatabaseMysql->getBacktrace(...) #1 /var/www/mediaryazan/html/bitrix/modules/iblock/classes/mysql/iblockelement.php(735): CDatabaseMysql->Query(...) #2 /var/www/mediaryazan/html/bitrix/components/usw/news.calendar/component.php(132): CIBlockElement->GetList(...) #3 /var/www/mediaryazan/html/bitrix/modules/main/classes/general/component.php(467): include(...) #4 /var/www/mediaryazan/html/bitrix/modules/main/classes/general/component.php(510): CBitrixComponent->__includeComponent(...) #5 /var/www/mediaryazan/html/bitrix/modules/main/classes/general/main.php(2223): CBitrixComponent->includeComponent(...) #6 /var/www/mediaryazan/html/bitrix_personal/templates/biz_main/header.php(397): CAllMain->IncludeComponent(...) #7 /var/www/mediaryazan/html/bitrix/modules/main/include/prolog_after.php(86): include_once(...) #8 /var/www/mediaryazan/html/bitrix/modules/main/include/prolog.php(12): require(...) #9 /var/www/mediaryazan/html/bitrix/header.php(1): require_once(...) #10 /var/www/mediaryazan/html/biz/news_detail.php(2): require(...) #11 /var/www/mediaryazan/html/bitrix/modules/main/include/urlrewrite.php(155): include_once(...) #12 /var/www/mediaryazan/html/bitrix/urlrewrite.php(2): include_once(...) */ SELECT DISTINCT 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 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 INNER JOIN ( SELECT DISTINCT BSE.IBLOCK_ELEMENT_ID FROM b_iblock_section_element BSE INNER JOIN b_iblock_section BSubS ON BSE.IBLOCK_SECTION_ID = BSubS.ID INNER JOIN b_iblock_section BS ON (BSubS.IBLOCK_ID=BS.IBLOCK_ID AND BSubS.LEFT_MARGIN>=BS.LEFT_MARGIN AND BSubS.RIGHT_MARGIN<=BS.RIGHT_MARGIN) WHERE ((BS.ID IN (890))) ) BES ON BES.IBLOCK_ELEMENT_ID = BE.ID WHERE 1=1 AND ( ((((BE.ACTIVE='Y')))) AND ((((BE.ACTIVE_FROM >= '2014-10-01 00:00:00')))) AND ((((BE.ACTIVE_FROM < '2014-11-01 00:00:00')))) AND ((((BE.IBLOCK_ID = '2')))) ) AND (((BE.WF_STATUS_ID=1 AND BE.WF_PARENT_ELEMENT_ID IS NULL))) LIMIT 10000;