Time 141026 11 44 User Host mediaryazan mediaryazan 127 Query_time 548

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
# 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;