Запит No 1:
SELECT U.*, DATE_FORMAT(U.TIMESTAMP_X, '%d.%m.%Y %H:%i:%s') TIMESTAMP_X, IF(U.LAST_ACTIVITY_DATE > DATE_SUB(NOW(), INTERVAL 1440 SECOND), 'Y', 'N') IS_ONLINE, DATE_FORMAT(U.DATE_REGISTER, '%d.%m.%Y %H:%i:%s') DATE_REGISTER, DATE_FORMAT(U.LAST_LOGIN, '%d.%m.%Y %H:%i:%s') LAST_LOGIN, DATE_FORMAT(U.PERSONAL_BIRTHDAY, '%d.%m.%Y') PERSONAL_BIRTHDAY , BUF.UF_USER_FAVORITES
FROM
b_user U
LEFT JOIN b_uts_user BUF ON BUF.VALUE_ID = U.ID
WHERE
(1=1 AND ( ( (U.ID='1' and U.ID is not null) ) ) )
Звідки викликаний:
(1.1)/home/bitrix/www/bitrix/modules/main/classes/general/user.php:805
CDatabaseMysql->Query(...)
(1.2)/home/bitrix/www/bitrix/modules/alexkova.market2/lib/basket.php:122
CAllUser::GetList(Array
(
)
)
(1.3)/home/bitrix/www/bitrix/components/bxready.market2/basket.small/component.php:75
Alexkova\Market2\Basket::favorItem(Array
(
)
)
(1.4)/home/bitrix/www/bitrix/modules/main/classes/general/component.php:607
include(Array
(
[0] => /home/bitrix/www/bitrix/components/bxready.market2/basket.small/component.php
)
)
(1.5)/home/bitrix/www/bitrix/modules/main/classes/general/component.php:684
CBitrixComponent->__includeComponent(Array
(
)
)
(1.6)/home/bitrix/www/bitrix/modules/main/classes/general/main.php:1062
CBitrixComponent->includeComponent(Array
(
)
)
(1.7)/home/bitrix/www/local/templates/market2_v1/bxready2/area/header/v2.php:263
CAllMain->IncludeComponent(Array
(
)
)
(1.8)/home/bitrix/www/bitrix/modules/alexkova.bxready2/lib/area.php:48
include(Array
(
[0] => /home/bitrix/www/local/templates/market2_v1/bxready2/area/header/v2.php
)
)
Час виконання: 0.00046 сек.
Запит No 2:
SELECT `sale_internals_basket`.`ID` AS `ID`, `sale_internals_basket`.`NAME` AS `NAME`, `sale_internals_basket`.`CALLBACK_FUNC` AS `CALLBACK_FUNC`, `sale_internals_basket`.`MODULE` AS `MODULE`, `sale_internals_basket`.`PRODUCT_ID` AS `PRODUCT_ID`, `sale_internals_basket`.`QUANTITY` AS `QUANTITY`, `sale_internals_basket`.`DELAY` AS `DELAY`, `sale_internals_basket`.`CAN_BUY` AS `CAN_BUY`, `sale_internals_basket`.`PRICE` AS `PRICE`, `sale_internals_basket`.`WEIGHT` AS `WEIGHT`, `sale_internals_basket`.`DETAIL_PAGE_URL` AS `DETAIL_PAGE_URL`, `sale_internals_basket`.`NOTES` AS `NOTES`, `sale_internals_basket`.`CURRENCY` AS `CURRENCY`, `sale_internals_basket`.`VAT_RATE` AS `VAT_RATE`, `sale_internals_basket`.`CATALOG_XML_ID` AS `CATALOG_XML_ID`, `sale_internals_basket`.`PRODUCT_XML_ID` AS `PRODUCT_XML_ID`, `sale_internals_basket`.`SUBSCRIBE` AS `SUBSCRIBE`, `sale_internals_basket`.`DISCOUNT_PRICE` AS `DISCOUNT_PRICE`, `sale_internals_basket`.`PRODUCT_PROVIDER_CLASS` AS `PRODUCT_PROVIDER_CLASS`, `sale_internals_basket`.`TYPE` AS `TYPE`, `sale_internals_basket`.`SET_PARENT_ID` AS `SET_PARENT_ID`
FROM
`b_sale_basket` `sale_internals_basket`
WHERE
`sale_internals_basket`.`FUSER_ID` = 2074 AND `sale_internals_basket`.`LID` = 's1' AND (`sale_internals_basket`.`ORDER_ID` IS NULL OR `sale_internals_basket`.`ORDER_ID` = 0)
ORDER BY
`ID` ASC
Звідки викликаний:
(1.1)/home/bitrix/www/bitrix/modules/main/lib/orm/query/query.php:3558
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/sale/lib/compatible/compatible.php:586
Bitrix\Main\ORM\Query\Query->exec(Array
(
)
)
(1.4)/home/bitrix/www/bitrix/modules/sale/lib/compatible/internals/entitycompatibility.php:492
Bitrix\Sale\Compatible\OrderQuery->compatibleExec(Array
(
)
)
(1.5)/home/bitrix/www/bitrix/modules/sale/lib/compatible/internals/entitycompatibility.php:162
Bitrix\Sale\Compatible\Internals\EntityCompatibility->execute(Array
(
)
)
(1.6)/home/bitrix/www/bitrix/modules/sale/lib/compatible/internals/entitycompatibility.php:110
Bitrix\Sale\Compatible\Internals\EntityCompatibility::setGetListParameters(Array
(
)
)
(1.7)/home/bitrix/www/bitrix/modules/sale/mysql/basket.php:59
Bitrix\Sale\Compatible\Internals\EntityCompatibility::getList(Array
(
)
)
(1.8)/home/bitrix/www/bitrix/components/bxready.market2/basket.small/component.php:118
CSaleBasket::GetList(Array
(
)
)
Час виконання: 0.0326 сек.
Запит No 3:
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,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 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.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,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=1, '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,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,') ',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,B.CANONICAL_PAGE_URL as CANONICAL_PAGE_URL,DATE_FORMAT(BE.DATE_CREATE, '%Y.%m.%d') as CREATED_DATE,if(BE.WF_STATUS_ID = 1, 'Y', 'N') 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_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.ID = '1434')))) AND ((((BE.ACTIVE='Y')))) AND (((BE.ACTIVE_TO >= now() OR BE.ACTIVE_TO IS NULL) AND (BE.ACTIVE_FROM <= now() OR BE.ACTIVE_FROM IS NULL))) ) AND (((BE.WF_STATUS_ID=1 AND BE.WF_PARENT_ELEMENT_ID IS NULL)))
Звідки викликаний:
(1.1)/home/bitrix/www/bitrix/modules/iblock/classes/mysql/iblockelement.php:830
CDatabaseMysql->Query(...)
(1.2)/home/bitrix/www/bitrix/modules/catalog/general/product.php:625
CIBlockElement::GetList(Array
(
)
)
(1.3)/home/bitrix/www/bitrix/components/bxready.market2/basket.small/component.php:134
CAllCatalogProduct::GetByIDEx(Array
(
)
)
(1.4)/home/bitrix/www/bitrix/modules/main/classes/general/component.php:607
include(Array
(
[0] => /home/bitrix/www/bitrix/components/bxready.market2/basket.small/component.php
)
)
(1.5)/home/bitrix/www/bitrix/modules/main/classes/general/component.php:684
CBitrixComponent->__includeComponent(Array
(
)
)
(1.6)/home/bitrix/www/bitrix/modules/main/classes/general/main.php:1062
CBitrixComponent->includeComponent(Array
(
)
)
(1.7)/home/bitrix/www/local/templates/market2_v1/bxready2/area/header/v2.php:263
CAllMain->IncludeComponent(Array
(
)
)
(1.8)/home/bitrix/www/bitrix/modules/alexkova.bxready2/lib/area.php:48
include(Array
(
[0] => /home/bitrix/www/local/templates/market2_v1/bxready2/area/header/v2.php
)
)
Час виконання: 0.00352 сек.
Запит No 4:
SELECT BP.*, BEP.ID as PROPERTY_VALUE_ID, BEP.VALUE, BEP.DESCRIPTION, BEPE.VALUE VALUE_ENUM, BEPE.XML_ID VALUE_XML_ID, BEPE.SORT VALUE_SORT
FROM
b_iblock B
INNER JOIN b_iblock_property BP ON B.ID=BP.IBLOCK_ID
LEFT JOIN b_iblock_element_prop_m17 BEP ON (BP.ID = BEP.IBLOCK_PROPERTY_ID AND BEP.IBLOCK_ELEMENT_ID = 1434)
LEFT JOIN b_iblock_property_enum BEPE ON (BP.PROPERTY_TYPE = 'L' AND BEPE.ID=BEP.VALUE_ENUM AND BEPE.PROPERTY_ID=BP.ID)
WHERE
B.ID = 17 AND BP.ACTIVE='Y'
ORDER BY
BP.SORT asc, BP.ID asc, BEPE.SORT asc, BEP.ID asc
Звідки викликаний:
(1.1)/home/bitrix/www/bitrix/modules/iblock/classes/general/iblockelement.php:6240
CDatabaseMysql->Query(...)
(1.2)/home/bitrix/www/bitrix/modules/catalog/general/product.php:634
CAllIBlockElement::GetProperty(Array
(
)
)
(1.3)/home/bitrix/www/bitrix/components/bxready.market2/basket.small/component.php:134
CAllCatalogProduct::GetByIDEx(Array
(
)
)
(1.4)/home/bitrix/www/bitrix/modules/main/classes/general/component.php:607
include(Array
(
[0] => /home/bitrix/www/bitrix/components/bxready.market2/basket.small/component.php
)
)
(1.5)/home/bitrix/www/bitrix/modules/main/classes/general/component.php:684
CBitrixComponent->__includeComponent(Array
(
)
)
(1.6)/home/bitrix/www/bitrix/modules/main/classes/general/main.php:1062
CBitrixComponent->includeComponent(Array
(
)
)
(1.7)/home/bitrix/www/local/templates/market2_v1/bxready2/area/header/v2.php:263
CAllMain->IncludeComponent(Array
(
)
)
(1.8)/home/bitrix/www/bitrix/modules/alexkova.bxready2/lib/area.php:48
include(Array
(
[0] => /home/bitrix/www/local/templates/market2_v1/bxready2/area/header/v2.php
)
)
Час виконання: 0.00011 сек.
Запит No 5:
SELECT *
FROM
b_iblock_element_prop_s17
WHERE
IBLOCK_ELEMENT_ID = 1434
Звідки викликаний:
(1.1)/home/bitrix/www/bitrix/modules/iblock/classes/general/iblockelement.php:6252
CDatabaseMysql->Query(...)
(1.2)/home/bitrix/www/bitrix/modules/catalog/general/product.php:634
CAllIBlockElement::GetProperty(Array
(
)
)
(1.3)/home/bitrix/www/bitrix/components/bxready.market2/basket.small/component.php:134
CAllCatalogProduct::GetByIDEx(Array
(
)
)
(1.4)/home/bitrix/www/bitrix/modules/main/classes/general/component.php:607
include(Array
(
[0] => /home/bitrix/www/bitrix/components/bxready.market2/basket.small/component.php
)
)
(1.5)/home/bitrix/www/bitrix/modules/main/classes/general/component.php:684
CBitrixComponent->__includeComponent(Array
(
)
)
(1.6)/home/bitrix/www/bitrix/modules/main/classes/general/main.php:1062
CBitrixComponent->includeComponent(Array
(
)
)
(1.7)/home/bitrix/www/local/templates/market2_v1/bxready2/area/header/v2.php:263
CAllMain->IncludeComponent(Array
(
)
)
(1.8)/home/bitrix/www/bitrix/modules/alexkova.bxready2/lib/area.php:48
include(Array
(
[0] => /home/bitrix/www/local/templates/market2_v1/bxready2/area/header/v2.php
)
)
Час виконання: 0.00113 сек.
Запит No 6:
SELECT `highloadblock_highload_block`.`ID` AS `ID`, `highloadblock_highload_block`.`NAME` AS `NAME`, `highloadblock_highload_block`.`TABLE_NAME` AS `TABLE_NAME`
FROM
`b_hlblock_entity` `highloadblock_highload_block`
WHERE
`highloadblock_highload_block`.`ID` = 5
Звідки викликаний:
(1.1)/home/bitrix/www/bitrix/modules/main/lib/orm/query/query.php:3558
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/main/lib/orm/data/datamanager.php:364
Bitrix\Main\ORM\Data\DataManager::getList(Array
(
)
)
(1.5)/home/bitrix/www/bitrix/modules/main/lib/orm/data/datamanager.php:379
Bitrix\Main\ORM\Data\DataManager::getByPrimary(Array
(
)
)
(1.6)/home/bitrix/www/bitrix/modules/highloadblock/classes/general/cusertypehlblock.php:397
Bitrix\Main\ORM\Data\DataManager::getById(Array
(
)
)
(1.7)/home/bitrix/www/bitrix/modules/main/classes/general/usertypemanager.php:2396
CUserTypeHlblock::getEntityReferences(Array
(
)
)
(1.8)/home/bitrix/www/bitrix/modules/main/lib/userfield.php:430
CUserTypeManager->getEntityReferences(Array
(
)
)
Час виконання: 0.01249 сек.
(2.1)/home/bitrix/www/bitrix/modules/main/lib/orm/query/query.php:3558
Bitrix\Main\DB\Connection->query(...)
(2.2)/home/bitrix/www/bitrix/modules/main/lib/orm/query/query.php:952
Bitrix\Main\ORM\Query\Query->query(Array
(
)
)
(2.3)/home/bitrix/www/bitrix/modules/main/lib/orm/data/datamanager.php:513
Bitrix\Main\ORM\Query\Query->exec(Array
(
)
)
(2.4)/home/bitrix/www/bitrix/modules/main/lib/orm/data/datamanager.php:364
Bitrix\Main\ORM\Data\DataManager::getList(Array
(
)
)
(2.5)/home/bitrix/www/bitrix/modules/main/lib/orm/data/datamanager.php:379
Bitrix\Main\ORM\Data\DataManager::getByPrimary(Array
(
)
)
(2.6)/home/bitrix/www/bitrix/modules/highloadblock/classes/general/cusertypehlblock.php:397
Bitrix\Main\ORM\Data\DataManager::getById(Array
(
)
)
(2.7)/home/bitrix/www/bitrix/modules/main/classes/general/usertypemanager.php:2396
CUserTypeHlblock::getEntityReferences(Array
(
)
)
(2.8)/home/bitrix/www/bitrix/modules/main/lib/userfield.php:328
CUserTypeManager->getEntityReferences(Array
(
)
)
Час виконання: 0.00095 сек.
Запит No 7:
SELECT `catalog_product`.`ID` AS `ID`, `catalog_product`.`QUANTITY` AS `QUANTITY`, `catalog_product`.`QUANTITY_RESERVED` AS `QUANTITY_RESERVED`, `catalog_product`.`QUANTITY_TRACE` AS `QUANTITY_TRACE`, `catalog_product`.`QUANTITY_TRACE` AS `QUANTITY_TRACE_ORIG`, `catalog_product`.`WEIGHT` AS `WEIGHT`, `catalog_product`.`WIDTH` AS `WIDTH`, `catalog_product`.`LENGTH` AS `LENGTH`, `catalog_product`.`HEIGHT` AS `HEIGHT`, `catalog_product`.`MEASURE` AS `MEASURE`, `catalog_product`.`VAT_ID` AS `VAT_ID`, `catalog_product`.`VAT_INCLUDED` AS `VAT_INCLUDED`, `catalog_product`.`CAN_BUY_ZERO` AS `CAN_BUY_ZERO`, `catalog_product`.`CAN_BUY_ZERO` AS `CAN_BUY_ZERO_ORIG`, `catalog_product`.`NEGATIVE_AMOUNT_TRACE` AS `NEGATIVE_AMOUNT_TRACE`, `catalog_product`.`NEGATIVE_AMOUNT_TRACE` AS `NEGATIVE_AMOUNT_TRACE_ORIG`, `catalog_product`.`PRICE_TYPE` AS `PRICE_TYPE`, `catalog_product`.`RECUR_SCHEME_TYPE` AS `RECUR_SCHEME_TYPE`, `catalog_product`.`RECUR_SCHEME_LENGTH` AS `RECUR_SCHEME_LENGTH`, `catalog_product`.`TRIAL_PRICE_ID` AS `TRIAL_PRICE_ID`, `catalog_product`.`WITHOUT_ORDER` AS `WITHOUT_ORDER`, `catalog_product`.`SELECT_BEST_PRICE` AS `SELECT_BEST_PRICE`, `catalog_product`.`TMP_ID` AS `TMP_ID`, `catalog_product`.`PURCHASING_PRICE` AS `PURCHASING_PRICE`, `catalog_product`.`PURCHASING_CURRENCY` AS `PURCHASING_CURRENCY`, `catalog_product`.`BARCODE_MULTI` AS `BARCODE_MULTI`, `catalog_product`.`SUBSCRIBE` AS `SUBSCRIBE`, `catalog_product`.`SUBSCRIBE` AS `SUBSCRIBE_ORIG`, `catalog_product`.`TYPE` AS `TYPE`, `catalog_product`.`BUNDLE` AS `BUNDLE`, `catalog_product`.`AVAILABLE` AS `AVAILABLE`, `catalog_product`.`TIMESTAMP_X` AS `TIMESTAMP_X`
FROM
`b_catalog_product` `catalog_product`
WHERE
`catalog_product`.`ID` = 1434
Звідки викликаний:
(1.1)/home/bitrix/www/bitrix/modules/main/lib/orm/query/query.php:3558
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/lib/model/entity.php:82
Bitrix\Main\ORM\Data\DataManager::getList(Array
(
)
)
(1.5)/home/bitrix/www/bitrix/modules/catalog/general/product.php:597
Bitrix\Catalog\Model\Entity::getList(Array
(
)
)
(1.6)/home/bitrix/www/bitrix/modules/catalog/general/product.php:708
CAllCatalogProduct::GetByID(Array
(
)
)
(1.7)/home/bitrix/www/bitrix/components/bxready.market2/basket.small/component.php:134
CAllCatalogProduct::GetByIDEx(Array
(
)
)
(1.8)/home/bitrix/www/bitrix/modules/main/classes/general/component.php:607
include(Array
(
[0] => /home/bitrix/www/bitrix/components/bxready.market2/basket.small/component.php
)
)
Час виконання: 0.00839 сек.
Запит No 8:
SELECT DISTINCT P.ID as ID, P.PRODUCT_ID as PRODUCT_ID, P.EXTRA_ID as EXTRA_ID, P.CATALOG_GROUP_ID as CATALOG_GROUP_ID, P.PRICE as PRICE, P.CURRENCY as CURRENCY, DATE_FORMAT(P.TIMESTAMP_X, '%d.%m.%Y %H:%i:%s') as TIMESTAMP_X, P.QUANTITY_FROM as QUANTITY_FROM, P.QUANTITY_TO as QUANTITY_TO, CG.BASE as BASE, CG.SORT as SORT, CGL.NAME as CATALOG_GROUP_NAME, IF(CGG.ID IS NULL, 'N', 'Y') as CAN_ACCESS, IF(CGG1.ID IS NULL, 'N', 'Y') as CAN_BUY
FROM
b_catalog_price P
INNER JOIN b_catalog_group CG ON (P.CATALOG_GROUP_ID = CG.ID)
LEFT JOIN b_catalog_group_lang CGL ON (P.CATALOG_GROUP_ID = CGL.CATALOG_GROUP_ID AND CGL.LANG = 'ua')
LEFT JOIN b_catalog_group2group CGG ON (P.CATALOG_GROUP_ID = CGG.CATALOG_GROUP_ID AND CGG.GROUP_ID IN (1,2,3,4) AND CGG.BUY <> 'Y')
LEFT JOIN b_catalog_group2group CGG1 ON (P.CATALOG_GROUP_ID = CGG1.CATALOG_GROUP_ID AND CGG1.GROUP_ID IN (1,2,3,4) AND CGG1.BUY = 'Y')
WHERE
((((P.PRODUCT_ID = 1434 ))))
ORDER BY
CG.SORT ASC
Звідки викликаний:
(1.1)/home/bitrix/www/bitrix/modules/catalog/mysql/price.php:141
CDatabaseMysql->Query(...)
(1.2)/home/bitrix/www/bitrix/modules/catalog/general/product.php:710
CPrice::GetList(Array
(
)
)
(1.3)/home/bitrix/www/bitrix/components/bxready.market2/basket.small/component.php:134
CAllCatalogProduct::GetByIDEx(Array
(
)
)
(1.4)/home/bitrix/www/bitrix/modules/main/classes/general/component.php:607
include(Array
(
[0] => /home/bitrix/www/bitrix/components/bxready.market2/basket.small/component.php
)
)
(1.5)/home/bitrix/www/bitrix/modules/main/classes/general/component.php:684
CBitrixComponent->__includeComponent(Array
(
)
)
(1.6)/home/bitrix/www/bitrix/modules/main/classes/general/main.php:1062
CBitrixComponent->includeComponent(Array
(
)
)
(1.7)/home/bitrix/www/local/templates/market2_v1/bxready2/area/header/v2.php:263
CAllMain->IncludeComponent(Array
(
)
)
(1.8)/home/bitrix/www/bitrix/modules/alexkova.bxready2/lib/area.php:48
include(Array
(
[0] => /home/bitrix/www/local/templates/market2_v1/bxready2/area/header/v2.php
)
)
Час виконання: 0.00281 сек.
Запит No 9:
SELECT CM.ID as ID, CM.CODE as CODE, CM.MEASURE_TITLE as MEASURE_TITLE, CM.SYMBOL_RUS as SYMBOL_RUS, CM.SYMBOL_INTL as SYMBOL_INTL, CM.SYMBOL_LETTER_INTL as SYMBOL_LETTER_INTL, CM.IS_DEFAULT as IS_DEFAULT, CM.SYMBOL_RUS as SYMBOL
FROM
b_catalog_measure CM
WHERE
((((CM.IS_DEFAULT = 'Y' ))))
Звідки викликаний:
(1.1)/home/bitrix/www/bitrix/modules/catalog/mysql/measure.php:111
CDatabaseMysql->Query(...)
(1.2)/home/bitrix/www/bitrix/modules/catalog/general/measure.php:197
CCatalogMeasure::getList(Array
(
)
)
(1.3)/home/bitrix/www/bitrix/modules/sale/include.php:357
CCatalogMeasureAll::getDefaultMeasure(Array
(
)
)
(1.4)/home/bitrix/www/bitrix/components/bxready.market2/basket.small/component.php:159
getMeasures(Array
(
)
)
(1.5)/home/bitrix/www/bitrix/modules/main/classes/general/component.php:607
include(Array
(
[0] => /home/bitrix/www/bitrix/components/bxready.market2/basket.small/component.php
)
)
(1.6)/home/bitrix/www/bitrix/modules/main/classes/general/component.php:684
CBitrixComponent->__includeComponent(Array
(
)
)
(1.7)/home/bitrix/www/bitrix/modules/main/classes/general/main.php:1062
CBitrixComponent->includeComponent(Array
(
)
)
(1.8)/home/bitrix/www/local/templates/market2_v1/bxready2/area/header/v2.php:263
CAllMain->IncludeComponent(Array
(
)
)
Час виконання: 5.0E-5 сек.
Запит No 10:
SELECT CP.ID as ID, CP.MEASURE as MEASURE, CP.TYPE as TYPE, CP.AVAILABLE as AVAILABLE, CP.QUANTITY as QUANTITY, CP.QUANTITY_TRACE as QUANTITY_TRACE_ORIG, CP.CAN_BUY_ZERO as CAN_BUY_ZERO_ORIG, CP.SUBSCRIBE as SUBSCRIBE_ORIG
FROM
b_catalog_product CP
WHERE
((((CP.ID = 1434 ))))
Звідки викликаний:
(1.1)/home/bitrix/www/bitrix/modules/catalog/mysql/product.php:142
CDatabaseMysql->Query(...)
(1.2)/home/bitrix/www/bitrix/modules/sale/include.php:392
CCatalogProduct::GetList(Array
(
)
)
(1.3)/home/bitrix/www/bitrix/components/bxready.market2/basket.small/component.php:159
getMeasures(Array
(
)
)
(1.4)/home/bitrix/www/bitrix/modules/main/classes/general/component.php:607
include(Array
(
[0] => /home/bitrix/www/bitrix/components/bxready.market2/basket.small/component.php
)
)
(1.5)/home/bitrix/www/bitrix/modules/main/classes/general/component.php:684
CBitrixComponent->__includeComponent(Array
(
)
)
(1.6)/home/bitrix/www/bitrix/modules/main/classes/general/main.php:1062
CBitrixComponent->includeComponent(Array
(
)
)
(1.7)/home/bitrix/www/local/templates/market2_v1/bxready2/area/header/v2.php:263
CAllMain->IncludeComponent(Array
(
)
)
(1.8)/home/bitrix/www/bitrix/modules/alexkova.bxready2/lib/area.php:48
include(Array
(
[0] => /home/bitrix/www/local/templates/market2_v1/bxready2/area/header/v2.php
)
)
Час виконання: 0.00453 сек.
Запит No 11:
SELECT CM.ID as ID, CM.SYMBOL_RUS as SYMBOL_RUS, CM.CODE as CODE, CM.SYMBOL_INTL as SYMBOL_INTL, CM.SYMBOL_RUS as SYMBOL
FROM
b_catalog_measure CM
WHERE
((((CM.ID = 5 ))))
Звідки викликаний:
(1.1)/home/bitrix/www/bitrix/modules/catalog/mysql/measure.php:111
CDatabaseMysql->Query(...)
(1.2)/home/bitrix/www/bitrix/modules/sale/include.php:416
CCatalogMeasure::getList(Array
(
)
)
(1.3)/home/bitrix/www/bitrix/components/bxready.market2/basket.small/component.php:159
getMeasures(Array
(
)
)
(1.4)/home/bitrix/www/bitrix/modules/main/classes/general/component.php:607
include(Array
(
[0] => /home/bitrix/www/bitrix/components/bxready.market2/basket.small/component.php
)
)
(1.5)/home/bitrix/www/bitrix/modules/main/classes/general/component.php:684
CBitrixComponent->__includeComponent(Array
(
)
)
(1.6)/home/bitrix/www/bitrix/modules/main/classes/general/main.php:1062
CBitrixComponent->includeComponent(Array
(
)
)
(1.7)/home/bitrix/www/local/templates/market2_v1/bxready2/area/header/v2.php:263
CAllMain->IncludeComponent(Array
(
)
)
(1.8)/home/bitrix/www/bitrix/modules/alexkova.bxready2/lib/area.php:48
include(Array
(
[0] => /home/bitrix/www/local/templates/market2_v1/bxready2/area/header/v2.php
)
)
Час виконання: 0.00067 сек.
Запит No 12:
SELECT `catalog_measure_ratio`.`ID` AS `ID`, `catalog_measure_ratio`.`PRODUCT_ID` AS `PRODUCT_ID`, `catalog_measure_ratio`.`RATIO` AS `RATIO`, `catalog_measure_ratio`.`IS_DEFAULT` AS `IS_DEFAULT`
FROM
`b_catalog_measure_ratio` `catalog_measure_ratio`
WHERE
`catalog_measure_ratio`.`PRODUCT_ID` IN (1434) AND `catalog_measure_ratio`.`IS_DEFAULT` = 'Y'
Звідки викликаний:
(1.1)/home/bitrix/www/bitrix/modules/main/lib/orm/query/query.php:3558
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/sale/include.php:505
Bitrix\Main\ORM\Data\DataManager::getList(Array
(
)
)
(1.5)/home/bitrix/www/bitrix/components/bxready.market2/basket.small/component.php:160
getRatio(Array
(
)
)
(1.6)/home/bitrix/www/bitrix/modules/main/classes/general/component.php:607
include(Array
(
[0] => /home/bitrix/www/bitrix/components/bxready.market2/basket.small/component.php
)
)
(1.7)/home/bitrix/www/bitrix/modules/main/classes/general/component.php:684
CBitrixComponent->__includeComponent(Array
(
)
)
(1.8)/home/bitrix/www/bitrix/modules/main/classes/general/main.php:1062
CBitrixComponent->includeComponent(Array
(
)
)
Час виконання: 0.01303 сек.
Запит No 13:
SELECT DISTINCT BP.ID as ID, BP.BASKET_ID as BASKET_ID, BP.NAME as NAME, BP.VALUE as VALUE, BP.CODE as CODE, BP.SORT as SORT
FROM
b_sale_basket_props BP
WHERE
((((BP.BASKET_ID = 3594 ))))
ORDER BY
BP.SORT ASC, BP.ID ASC
Звідки викликаний:
(1.1)/home/bitrix/www/bitrix/modules/sale/mysql/basket.php:414
CDatabaseMysql->Query(...)
(1.2)/home/bitrix/www/bitrix/components/bxready.market2/basket.small/component.php:184
CSaleBasket::GetPropsList(Array
(
)
)
(1.3)/home/bitrix/www/bitrix/modules/main/classes/general/component.php:607
include(Array
(
[0] => /home/bitrix/www/bitrix/components/bxready.market2/basket.small/component.php
)
)
(1.4)/home/bitrix/www/bitrix/modules/main/classes/general/component.php:684
CBitrixComponent->__includeComponent(Array
(
)
)
(1.5)/home/bitrix/www/bitrix/modules/main/classes/general/main.php:1062
CBitrixComponent->includeComponent(Array
(
)
)
(1.6)/home/bitrix/www/local/templates/market2_v1/bxready2/area/header/v2.php:263
CAllMain->IncludeComponent(Array
(
)
)
(1.7)/home/bitrix/www/bitrix/modules/alexkova.bxready2/lib/area.php:48
include(Array
(
[0] => /home/bitrix/www/local/templates/market2_v1/bxready2/area/header/v2.php
)
)
(1.8)/home/bitrix/www/local/templates/market2_v1/bxready2/area/header/v2_menu.php:7
Alexkova\Bxready2\Area::showArea(Array
(
)
)
Час виконання: 0.00107 сек.
Запит No 14:
SELECT `sale_internals_basket`.`ID` AS `ID`, `sale_internals_basket`.`PRODUCT_PRICE_ID` AS `PRODUCT_PRICE_ID`, `sale_internals_basket`.`PRICE_TYPE_ID` AS `PRICE_TYPE_ID`
FROM
`b_sale_basket` `sale_internals_basket`
WHERE
`sale_internals_basket`.`ID` IN (3594)
Звідки викликаний:
(1.1)/home/bitrix/www/bitrix/modules/main/lib/orm/query/query.php:3558
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/sale/general/discount.php:96
Bitrix\Main\ORM\Data\DataManager::getList(Array
(
)
)
(1.5)/home/bitrix/www/bitrix/components/bxready.market2/basket.small/component.php:230
CAllSaleDiscount::DoProcessOrder(Array
(
)
)
(1.6)/home/bitrix/www/bitrix/modules/main/classes/general/component.php:607
include(Array
(
[0] => /home/bitrix/www/bitrix/components/bxready.market2/basket.small/component.php
)
)
(1.7)/home/bitrix/www/bitrix/modules/main/classes/general/component.php:684
CBitrixComponent->__includeComponent(Array
(
)
)
(1.8)/home/bitrix/www/bitrix/modules/main/classes/general/main.php:1062
CBitrixComponent->includeComponent(Array
(
)
)
Час виконання: 0.00081 сек.
Запит No 15:
SELECT `sale_internals_basket_property`.`ID` AS `ID`, `sale_internals_basket_property`.`BASKET_ID` AS `BASKET_ID`, `sale_internals_basket_property`.`NAME` AS `NAME`, `sale_internals_basket_property`.`VALUE` AS `VALUE`, `sale_internals_basket_property`.`CODE` AS `CODE`, `sale_internals_basket_property`.`SORT` AS `SORT`, `sale_internals_basket_property`.`XML_ID` AS `XML_ID`
FROM
`b_sale_basket_props` `sale_internals_basket_property`
WHERE
(`sale_internals_basket_property`.`BASKET_ID` IS NULL OR `sale_internals_basket_property`.`BASKET_ID` = 0) AND (`sale_internals_basket_property`.`SORT` IS NULL OR `sale_internals_basket_property`.`SORT` = 0) AND (`sale_internals_basket_property`.`ID` IS NULL OR `sale_internals_basket_property`.`ID` = 0)
Звідки викликаний:
(1.1)/home/bitrix/www/bitrix/modules/main/lib/orm/query/query.php:3558
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/sale/lib/basketproperties.php:38
Bitrix\Main\ORM\Data\DataManager::getList(Array
(
)
)
(1.5)/home/bitrix/www/bitrix/modules/sale/lib/compatible/discountcompatibility.php:629
Bitrix\Sale\BasketPropertiesCollection::getList(Array
(
)
)
(1.6)/home/bitrix/www/bitrix/modules/sale/general/discount.php:129
Bitrix\Sale\Compatible\DiscountCompatibility::fillBasketData(Array
(
)
)
(1.7)/home/bitrix/www/bitrix/components/bxready.market2/basket.small/component.php:230
CAllSaleDiscount::DoProcessOrder(Array
(
)
)
(1.8)/home/bitrix/www/bitrix/modules/main/classes/general/component.php:607
include(Array
(
[0] => /home/bitrix/www/bitrix/components/bxready.market2/basket.small/component.php
)
)
Час виконання: 0.00214 сек.
Запит No 16:
SELECT UG.GROUP_ID, G.STRING_ID, DATE_FORMAT(UG.DATE_ACTIVE_FROM, '%d.%m.%Y %H:%i:%s') as DATE_ACTIVE_FROM, DATE_FORMAT(UG.DATE_ACTIVE_TO, '%d.%m.%Y %H:%i:%s') as DATE_ACTIVE_TO
FROM
b_user_group UG
INNER JOIN b_group G ON G.ID=UG.GROUP_ID
WHERE
UG.USER_ID = 1 and ((UG.DATE_ACTIVE_FROM IS NULL) OR (UG.DATE_ACTIVE_FROM <= now())) and ((UG.DATE_ACTIVE_TO IS NULL) OR (UG.DATE_ACTIVE_TO >= now())) and G.ACTIVE = 'Y' UNION SELECT 2, 'everyone', NULL, NULL
Звідки викликаний:
(1.1)/home/bitrix/www/bitrix/modules/main/classes/general/user.php:3173
CDatabaseMysql->Query(...)
(1.2)/home/bitrix/www/bitrix/modules/main/classes/general/user.php:3148
CAllUser::GetUserGroupEx(Array
(
)
)
(1.3)/home/bitrix/www/bitrix/modules/sale/general/discount.php:155
CAllUser::GetUserGroup(Array
(
)
)
(1.4)/home/bitrix/www/bitrix/components/bxready.market2/basket.small/component.php:230
CAllSaleDiscount::DoProcessOrder(Array
(
)
)
(1.5)/home/bitrix/www/bitrix/modules/main/classes/general/component.php:607
include(Array
(
[0] => /home/bitrix/www/bitrix/components/bxready.market2/basket.small/component.php
)
)
(1.6)/home/bitrix/www/bitrix/modules/main/classes/general/component.php:684
CBitrixComponent->__includeComponent(Array
(
)
)
(1.7)/home/bitrix/www/bitrix/modules/main/classes/general/main.php:1062
CBitrixComponent->includeComponent(Array
(
)
)
(1.8)/home/bitrix/www/local/templates/market2_v1/bxready2/area/header/v2.php:263
CAllMain->IncludeComponent(Array
(
)
)
Час виконання: 0.00029 сек.
Запит No 17:
SELECT `sale_internals_discount_group`.`DISCOUNT_ID` AS `DISCOUNT_ID`, `sale_internals_discount_group`.`ID` AS `UALIAS_0`
FROM
`b_sale_discount_group` `sale_internals_discount_group`
WHERE
`sale_internals_discount_group`.`GROUP_ID` IN (1,3,4,2) AND `sale_internals_discount_group`.`ACTIVE` = 'Y'
ORDER BY
`DISCOUNT_ID` ASC
Звідки викликаний:
(1.1)/home/bitrix/www/bitrix/modules/main/lib/orm/query/query.php:3558
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/sale/general/discount.php:154
Bitrix\Main\ORM\Data\DataManager::getList(Array
(
)
)
(1.5)/home/bitrix/www/bitrix/components/bxready.market2/basket.small/component.php:230
CAllSaleDiscount::DoProcessOrder(Array
(
)
)
(1.6)/home/bitrix/www/bitrix/modules/main/classes/general/component.php:607
include(Array
(
[0] => /home/bitrix/www/bitrix/components/bxready.market2/basket.small/component.php
)
)
(1.7)/home/bitrix/www/bitrix/modules/main/classes/general/component.php:684
CBitrixComponent->__includeComponent(Array
(
)
)
(1.8)/home/bitrix/www/bitrix/modules/main/classes/general/main.php:1062
CBitrixComponent->includeComponent(Array
(
)
)
Час виконання: 0.00077 сек.
Запит No 18:
SELECT `sale_internals_discount_entities`.`DISCOUNT_ID` AS `DISCOUNT_ID`, `sale_internals_discount_entities`.`MODULE_ID` AS `MODULE_ID`, `sale_internals_discount_entities`.`ENTITY` AS `ENTITY`, `sale_internals_discount_entities`.`FIELD_ENTITY` AS `FIELD_ENTITY`, `sale_internals_discount_entities`.`FIELD_TABLE` AS `FIELD_TABLE`, `sale_internals_discount_entities`.`ID` AS `UALIAS_0`
FROM
`b_sale_discount_entities` `sale_internals_discount_entities`
WHERE
`sale_internals_discount_entities`.`MODULE_ID` = 'catalog' AND `sale_internals_discount_entities`.`ENTITY` IN ('ELEMENT_PROPERTY', 'PRICE') AND `sale_internals_discount_entities`.`DISCOUNT_ID` IN (38)
Звідки викликаний:
(1.1)/home/bitrix/www/bitrix/modules/main/lib/orm/query/query.php:3558
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/sale/lib/internals/discountentities.php:237
Bitrix\Main\ORM\Data\DataManager::getList(Array
(
)
)
(1.5)/home/bitrix/www/bitrix/modules/sale/general/discount.php:176
Bitrix\Sale\Internals\DiscountEntitiesTable::getByDiscount(Array
(
)
)
(1.6)/home/bitrix/www/bitrix/components/bxready.market2/basket.small/component.php:230
CAllSaleDiscount::DoProcessOrder(Array
(
)
)
(1.7)/home/bitrix/www/bitrix/modules/main/classes/general/component.php:607
include(Array
(
[0] => /home/bitrix/www/bitrix/components/bxready.market2/basket.small/component.php
)
)
(1.8)/home/bitrix/www/bitrix/modules/main/classes/general/component.php:684
CBitrixComponent->__includeComponent(Array
(
)
)
Час виконання: 0.01532 сек.
Запит No 19:
SELECT BS.ID AS ID, BS.IBLOCK_SECTION_ID AS IBLOCK_SECTION_ID, SE.IBLOCK_ELEMENT_ID AS IBLOCK_ELEMENT_ID
FROM
b_iblock_section_element SE
INNER JOIN b_iblock_section BS ON SE.IBLOCK_SECTION_ID = BS.ID
INNER JOIN b_iblock B ON B.ID = BS.IBLOCK_ID
WHERE
SE.IBLOCK_ELEMENT_ID in (1434) AND SE.ADDITIONAL_PROPERTY_ID IS NULL
Звідки викликаний:
(1.1)/home/bitrix/www/bitrix/modules/iblock/classes/general/iblockelement.php:4889
CDatabaseMysql->Query(...)
(1.2)/home/bitrix/www/bitrix/modules/catalog/general/discount.php:4173
CAllIBlockElement::GetElementGroups(Array
(
)
)
(1.3)/home/bitrix/www/bitrix/modules/catalog/general/discount.php:2580
CAllCatalogDiscount::SetProductSectionsCache(Array
(
)
)
(1.4)/home/bitrix/www/bitrix/modules/main/classes/general/module.php:480
CAllCatalogDiscount::ExtendBasketItems(Array
(
)
)
(1.5)/home/bitrix/www/bitrix/modules/sale/general/discount.php:223
ExecuteModuleEventEx(Array
(
)
)
(1.6)/home/bitrix/www/bitrix/components/bxready.market2/basket.small/component.php:230
CAllSaleDiscount::DoProcessOrder(Array
(
)
)
(1.7)/home/bitrix/www/bitrix/modules/main/classes/general/component.php:607
include(Array
(
[0] => /home/bitrix/www/bitrix/components/bxready.market2/basket.small/component.php
)
)
(1.8)/home/bitrix/www/bitrix/modules/main/classes/general/component.php:684
CBitrixComponent->__includeComponent(Array
(
)
)
Час виконання: 0.0004 сек.
Запит No 20:
SELECT BE.ID as ID,BE.IBLOCK_ID as IBLOCK_ID,BE.CODE as CODE,BE.XML_ID as XML_ID,BE.NAME as NAME,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.SORT as SORT,BE.PREVIEW_TEXT as PREVIEW_TEXT,BE.DETAIL_TEXT as DETAIL_TEXT,DATE_FORMAT(BE.DATE_CREATE, '%d.%m.%Y %H:%i:%s') as DATE_CREATE,BE.CREATED_BY as CREATED_BY,DATE_FORMAT(BE.TIMESTAMP_X, '%d.%m.%Y %H:%i:%s') as TIMESTAMP_X,BE.MODIFIED_BY as MODIFIED_BY,BE.TAGS as TAGS,UNIX_TIMESTAMP(BE.TIMESTAMP_X) as TIMESTAMP_X_UNIX,UNIX_TIMESTAMP(BE.DATE_CREATE) as DATE_CREATE_UNIX,BE.DETAIL_TEXT_TYPE as DETAIL_TEXT_TYPE,BE.PREVIEW_TEXT_TYPE as PREVIEW_TEXT_TYPE
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
WHERE
1=1 AND ( ((((BE.ID = '1434')))) ) AND (((BE.WF_STATUS_ID=1 AND BE.WF_PARENT_ELEMENT_ID IS NULL)))
Звідки викликаний:
(1.1)/home/bitrix/www/bitrix/modules/iblock/classes/mysql/iblockelement.php:830
CDatabaseMysql->Query(...)
(1.2)/home/bitrix/www/bitrix/modules/catalog/general/discount.php:2582
CIBlockElement::GetList(Array
(
)
)
(1.3)/home/bitrix/www/bitrix/modules/main/classes/general/module.php:480
CAllCatalogDiscount::ExtendBasketItems(Array
(
)
)
(1.4)/home/bitrix/www/bitrix/modules/sale/general/discount.php:223
ExecuteModuleEventEx(Array
(
)
)
(1.5)/home/bitrix/www/bitrix/components/bxready.market2/basket.small/component.php:230
CAllSaleDiscount::DoProcessOrder(Array
(
)
)
(1.6)/home/bitrix/www/bitrix/modules/main/classes/general/component.php:607
include(Array
(
[0] => /home/bitrix/www/bitrix/components/bxready.market2/basket.small/component.php
)
)
(1.7)/home/bitrix/www/bitrix/modules/main/classes/general/component.php:684
CBitrixComponent->__includeComponent(Array
(
)
)
(1.8)/home/bitrix/www/bitrix/modules/main/classes/general/main.php:1062
CBitrixComponent->includeComponent(Array
(
)
)
Час виконання: 0.00109 сек.
Запит No 21:
SELECT BS.ID AS ID, BS.IBLOCK_SECTION_ID AS IBLOCK_SECTION_ID
FROM
b_iblock_section BS
INNER JOIN b_iblock B ON B.ID = BS.IBLOCK_ID
WHERE
BS.ID=400 AND BS.IBLOCK_ID=17
Звідки викликаний:
(1.1)/home/bitrix/www/bitrix/modules/iblock/classes/general/iblocksection.php:296
CDatabaseMysql->Query(...)
(1.2)/home/bitrix/www/bitrix/modules/catalog/general/discount.php:3162
CAllIBlockSection::GetNavChain(Array
(
)
)
(1.3)/home/bitrix/www/bitrix/modules/catalog/general/discount.php:2639
CAllCatalogDiscount::__GetSectionList(Array
(
)
)
(1.4)/home/bitrix/www/bitrix/modules/main/classes/general/module.php:480
CAllCatalogDiscount::ExtendBasketItems(Array
(
)
)
(1.5)/home/bitrix/www/bitrix/modules/sale/general/discount.php:223
ExecuteModuleEventEx(Array
(
)
)
(1.6)/home/bitrix/www/bitrix/components/bxready.market2/basket.small/component.php:230
CAllSaleDiscount::DoProcessOrder(Array
(
)
)
(1.7)/home/bitrix/www/bitrix/modules/main/classes/general/component.php:607
include(Array
(
[0] => /home/bitrix/www/bitrix/components/bxready.market2/basket.small/component.php
)
)
(1.8)/home/bitrix/www/bitrix/modules/main/classes/general/component.php:684
CBitrixComponent->__includeComponent(Array
(
)
)
Час виконання: 0.00023 сек.
Запит No 22:
SELECT BS.ID AS ID, BS.IBLOCK_SECTION_ID AS IBLOCK_SECTION_ID
FROM
b_iblock_section BS
INNER JOIN b_iblock B ON B.ID = BS.IBLOCK_ID
WHERE
BS.ID=370 AND BS.IBLOCK_ID=17
Звідки викликаний:
(1.1)/home/bitrix/www/bitrix/modules/iblock/classes/general/iblocksection.php:296
CDatabaseMysql->Query(...)
(1.2)/home/bitrix/www/bitrix/modules/catalog/general/discount.php:3162
CAllIBlockSection::GetNavChain(Array
(
)
)
(1.3)/home/bitrix/www/bitrix/modules/catalog/general/discount.php:2639
CAllCatalogDiscount::__GetSectionList(Array
(
)
)
(1.4)/home/bitrix/www/bitrix/modules/main/classes/general/module.php:480
CAllCatalogDiscount::ExtendBasketItems(Array
(
)
)
(1.5)/home/bitrix/www/bitrix/modules/sale/general/discount.php:223
ExecuteModuleEventEx(Array
(
)
)
(1.6)/home/bitrix/www/bitrix/components/bxready.market2/basket.small/component.php:230
CAllSaleDiscount::DoProcessOrder(Array
(
)
)
(1.7)/home/bitrix/www/bitrix/modules/main/classes/general/component.php:607
include(Array
(
[0] => /home/bitrix/www/bitrix/components/bxready.market2/basket.small/component.php
)
)
(1.8)/home/bitrix/www/bitrix/modules/main/classes/general/component.php:684
CBitrixComponent->__includeComponent(Array
(
)
)
Час виконання: 4.0E-5 сек.
Запит No 23:
SELECT BS.ID AS ID, BS.IBLOCK_SECTION_ID AS IBLOCK_SECTION_ID
FROM
b_iblock_section BS
INNER JOIN b_iblock B ON B.ID = BS.IBLOCK_ID
WHERE
BS.ID=119 AND BS.IBLOCK_ID=17
Звідки викликаний:
(1.1)/home/bitrix/www/bitrix/modules/iblock/classes/general/iblocksection.php:296
CDatabaseMysql->Query(...)
(1.2)/home/bitrix/www/bitrix/modules/catalog/general/discount.php:3162
CAllIBlockSection::GetNavChain(Array
(
)
)
(1.3)/home/bitrix/www/bitrix/modules/catalog/general/discount.php:2639
CAllCatalogDiscount::__GetSectionList(Array
(
)
)
(1.4)/home/bitrix/www/bitrix/modules/main/classes/general/module.php:480
CAllCatalogDiscount::ExtendBasketItems(Array
(
)
)
(1.5)/home/bitrix/www/bitrix/modules/sale/general/discount.php:223
ExecuteModuleEventEx(Array
(
)
)
(1.6)/home/bitrix/www/bitrix/components/bxready.market2/basket.small/component.php:230
CAllSaleDiscount::DoProcessOrder(Array
(
)
)
(1.7)/home/bitrix/www/bitrix/modules/main/classes/general/component.php:607
include(Array
(
[0] => /home/bitrix/www/bitrix/components/bxready.market2/basket.small/component.php
)
)
(1.8)/home/bitrix/www/bitrix/modules/main/classes/general/component.php:684
CBitrixComponent->__includeComponent(Array
(
)
)
Час виконання: 4.0E-5 сек.
Запит No 24:
SELECT `catalog_catalog_iblock`.`IBLOCK_ID` AS `IBLOCK_ID`, `catalog_catalog_iblock`.`SKU_PROPERTY_ID` AS `SKU_PROPERTY_ID`, `catalog_catalog_iblock`.`PRODUCT_IBLOCK_ID` AS `PRODUCT_IBLOCK_ID`
FROM
`b_catalog_iblock` `catalog_catalog_iblock`
WHERE
`catalog_catalog_iblock`.`IBLOCK_ID` IN (17)
Звідки викликаний:
(1.1)/home/bitrix/www/bitrix/modules/main/lib/orm/query/query.php:3558
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/discount.php:2658
Bitrix\Main\ORM\Data\DataManager::getList(Array
(
)
)
(1.5)/home/bitrix/www/bitrix/modules/main/classes/general/module.php:480
CAllCatalogDiscount::ExtendBasketItems(Array
(
)
)
(1.6)/home/bitrix/www/bitrix/modules/sale/general/discount.php:223
ExecuteModuleEventEx(Array
(
)
)
(1.7)/home/bitrix/www/bitrix/components/bxready.market2/basket.small/component.php:230
CAllSaleDiscount::DoProcessOrder(Array
(
)
)
(1.8)/home/bitrix/www/bitrix/modules/main/classes/general/component.php:607
include(Array
(
[0] => /home/bitrix/www/bitrix/components/bxready.market2/basket.small/component.php
)
)
Час виконання: 0.00037 сек.
Запит No 25:
SELECT CP.ID as ID, CP.TYPE as TYPE, CP.QUANTITY as QUANTITY, CP.WEIGHT as WEIGHT, CP.VAT_ID as VAT_ID, CP.VAT_INCLUDED as VAT_INCLUDED, CP.AVAILABLE as AVAILABLE, CP.QUANTITY_TRACE as QUANTITY_TRACE_ORIG, CP.CAN_BUY_ZERO as CAN_BUY_ZERO_ORIG, CP.SUBSCRIBE as SUBSCRIBE_ORIG
FROM
b_catalog_product CP
WHERE
((((CP.ID IN (1434)))))
Звідки викликаний:
(1.1)/home/bitrix/www/bitrix/modules/catalog/mysql/product.php:142
CDatabaseMysql->Query(...)
(1.2)/home/bitrix/www/bitrix/modules/catalog/general/discount.php:2732
CCatalogProduct::GetList(Array
(
)
)
(1.3)/home/bitrix/www/bitrix/modules/main/classes/general/module.php:480
CAllCatalogDiscount::ExtendBasketItems(Array
(
)
)
(1.4)/home/bitrix/www/bitrix/modules/sale/general/discount.php:223
ExecuteModuleEventEx(Array
(
)
)
(1.5)/home/bitrix/www/bitrix/components/bxready.market2/basket.small/component.php:230
CAllSaleDiscount::DoProcessOrder(Array
(
)
)
(1.6)/home/bitrix/www/bitrix/modules/main/classes/general/component.php:607
include(Array
(
[0] => /home/bitrix/www/bitrix/components/bxready.market2/basket.small/component.php
)
)
(1.7)/home/bitrix/www/bitrix/modules/main/classes/general/component.php:684
CBitrixComponent->__includeComponent(Array
(
)
)
(1.8)/home/bitrix/www/bitrix/modules/main/classes/general/main.php:1062
CBitrixComponent->includeComponent(Array
(
)
)
Час виконання: 5.0E-5 сек.
Запит No 26:
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`.`IBLOCK_ID` = 17 AND (`catalog_catalog_iblock`.`PRODUCT_IBLOCK_ID` IS NOT NULL AND `catalog_catalog_iblock`.`PRODUCT_IBLOCK_ID` <> 0)
Звідки викликаний:
(1.1)/home/bitrix/www/bitrix/modules/main/lib/orm/query/query.php:3558
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:121
Bitrix\Main\ORM\Data\DataManager::getList(Array
(
)
)
(1.5)/home/bitrix/www/bitrix/modules/catalog/general/discount.php:2813
CCatalogSku::GetInfoByOfferIBlock(Array
(
)
)
(1.6)/home/bitrix/www/bitrix/modules/main/classes/general/module.php:480
CAllCatalogDiscount::ExtendBasketItems(Array
(
)
)
(1.7)/home/bitrix/www/bitrix/modules/sale/general/discount.php:223
ExecuteModuleEventEx(Array
(
)
)
(1.8)/home/bitrix/www/bitrix/components/bxready.market2/basket.small/component.php:230
CAllSaleDiscount::DoProcessOrder(Array
(
)
)
Час виконання: 0.00121 сек.
Запит No 27:
SELECT `sale_internals_discount_module`.`DISCOUNT_ID` AS `DISCOUNT_ID`, `sale_internals_discount_module`.`MODULE_ID` AS `MODULE_ID`, `sale_internals_discount_module`.`ID` AS `UALIAS_0`
FROM
`b_sale_discount_module` `sale_internals_discount_module`
WHERE
`sale_internals_discount_module`.`DISCOUNT_ID` IN (38)
Звідки викликаний:
(1.1)/home/bitrix/www/bitrix/modules/main/lib/orm/query/query.php:3558
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/sale/lib/internals/discountmodule.php:160
Bitrix\Main\ORM\Data\DataManager::getList(Array
(
)
)
(1.5)/home/bitrix/www/bitrix/modules/sale/general/discount.php:1829
Bitrix\Sale\Internals\DiscountModuleTable::getByDiscount(Array
(
)
)
(1.6)/home/bitrix/www/bitrix/modules/sale/general/discount.php:246
CAllSaleDiscount::getDiscountHandlers(Array
(
)
)
(1.7)/home/bitrix/www/bitrix/components/bxready.market2/basket.small/component.php:230
CAllSaleDiscount::DoProcessOrder(Array
(
)
)
(1.8)/home/bitrix/www/bitrix/modules/main/classes/general/component.php:607
include(Array
(
[0] => /home/bitrix/www/bitrix/components/bxready.market2/basket.small/component.php
)
)
Час виконання: 0.0014 сек.
Запит No 28:
SELECT `sale_internals_discount`.`ID` AS `ID`, `sale_internals_discount`.`PRIORITY` AS `PRIORITY`, `sale_internals_discount`.`SORT` AS `SORT`, `sale_internals_discount`.`LAST_DISCOUNT` AS `LAST_DISCOUNT`, `sale_internals_discount`.`LAST_LEVEL_DISCOUNT` AS `LAST_LEVEL_DISCOUNT`, `sale_internals_discount`.`UNPACK` AS `UNPACK`, `sale_internals_discount`.`APPLICATION` AS `APPLICATION`, `sale_internals_discount`.`USE_COUPONS` AS `USE_COUPONS`, `sale_internals_discount`.`EXECUTE_MODULE` AS `EXECUTE_MODULE`, `sale_internals_discount`.`NAME` AS `NAME`, `sale_internals_discount`.`CONDITIONS` AS `CONDITIONS_LIST`, `sale_internals_discount`.`ACTIONS` AS `ACTIONS_LIST`
FROM
`b_sale_discount` `sale_internals_discount`
WHERE
`sale_internals_discount`.`ID` IN (38) AND `sale_internals_discount`.`LID` = 's1' AND ( (`sale_internals_discount`.`ACTIVE_FROM` IS NULL) OR `sale_internals_discount`.`ACTIVE_FROM` <= '2026-11-02 00:30:52' ) AND ( (`sale_internals_discount`.`ACTIVE_TO` IS NULL) OR `sale_internals_discount`.`ACTIVE_TO` >= '2026-11-02 00:30:52' ) AND `sale_internals_discount`.`USE_COUPONS` = 'N'
ORDER BY
`PRIORITY` DESC, `SORT` ASC, `ID` ASC
Звідки викликаний:
(1.1)/home/bitrix/www/bitrix/modules/main/lib/orm/query/query.php:3558
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/sale/general/discount.php:333
Bitrix\Main\ORM\Data\DataManager::getList(Array
(
)
)
(1.5)/home/bitrix/www/bitrix/components/bxready.market2/basket.small/component.php:230
CAllSaleDiscount::DoProcessOrder(Array
(
)
)
(1.6)/home/bitrix/www/bitrix/modules/main/classes/general/component.php:607
include(Array
(
[0] => /home/bitrix/www/bitrix/components/bxready.market2/basket.small/component.php
)
)
(1.7)/home/bitrix/www/bitrix/modules/main/classes/general/component.php:684
CBitrixComponent->__includeComponent(Array
(
)
)
(1.8)/home/bitrix/www/bitrix/modules/main/classes/general/main.php:1062
CBitrixComponent->includeComponent(Array
(
)
)
Час виконання: 0.02238 сек.
Запит No 29:
SELECT BP.*
FROM
b_iblock_property BP ,b_iblock B
WHERE
BP.IBLOCK_ID=B.ID AND B.ID IN (17) AND UPPER(BP.CODE)='UK_NAME'
Звідки викликаний:
(1.1)/home/bitrix/www/bitrix/modules/iblock/classes/general/iblockproperty.php:727
CDatabaseMysql->Query(...)
(1.2)/home/bitrix/www/bitrix/modules/iblock/classes/general/iblockelement.php:3015
CAllIBlockProperty::GetPropertyArray(Array
(
)
)
(1.3)/home/bitrix/www/bitrix/modules/iblock/classes/mysql/iblockelement.php:326
CAllIBlockElement->PrepareGetList(Array
(
)
)
(1.4)/home/bitrix/www/bitrix/modules/iblock/classes/mysql/iblockelement.php:684
CIBlockElement->prepareSql(Array
(
)
)
(1.5)/home/bitrix/www/local/templates/market2_v1/components/bxready.market2/basket.small/.default/result_modifier.php:6
CIBlockElement::GetList(Array
(
)
)
(1.6)/home/bitrix/www/bitrix/modules/main/classes/general/component_template.php:947
include(Array
(
[0] => /home/bitrix/www/local/templates/market2_v1/components/bxready.market2/basket.small/.default/result_modifier.php
)
)
(1.7)/home/bitrix/www/bitrix/modules/main/classes/general/component_template.php:854
CBitrixComponentTemplate->__IncludeMutatorFile(Array
(
)
)
(1.8)/home/bitrix/www/bitrix/modules/main/classes/general/component.php:776
CBitrixComponentTemplate->IncludeTemplate(Array
(
)
)
Час виконання: 0.00253 сек.
Запит No 30:
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` = 17
Звідки викликаний:
(1.1)/home/bitrix/www/bitrix/modules/main/lib/orm/query/query.php:3558
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:746
Bitrix\Iblock\PropertyIndex\QueryBuilder->__construct(Array
(
)
)
(1.8)/home/bitrix/www/bitrix/modules/iblock/classes/general/iblockelement.php:3139
CAllIBlockElement->MkFilter(Array
(
)
)
Час виконання: 0.01125 сек.
Запит No 31:
SHOW TABLES LIKE 'b_iblock_17_index_val'
Звідки викликаний:
(1.1)/home/bitrix/www/bitrix/modules/main/lib/db/mysqlcommonconnection.php:38
Bitrix\Main\DB\Connection->query(...)
(1.2)/home/bitrix/www/bitrix/modules/iblock/lib/propertyindex/dictionary.php:54
Bitrix\Main\DB\MysqlCommonConnection->isTableExists(Array
(
)
)
(1.3)/home/bitrix/www/bitrix/modules/iblock/lib/propertyindex/facet.php:57
Bitrix\Iblock\PropertyIndex\Dictionary->isExists(Array
(
)
)
(1.4)/home/bitrix/www/bitrix/modules/iblock/lib/propertyindex/querybuilder.php:28
Bitrix\Iblock\PropertyIndex\Facet->__construct(Array
(
)
)
(1.5)/home/bitrix/www/bitrix/modules/iblock/classes/general/iblockelement.php:746
Bitrix\Iblock\PropertyIndex\QueryBuilder->__construct(Array
(
)
)
(1.6)/home/bitrix/www/bitrix/modules/iblock/classes/general/iblockelement.php:3139
CAllIBlockElement->MkFilter(Array
(
)
)
(1.7)/home/bitrix/www/bitrix/modules/iblock/classes/mysql/iblockelement.php:326
CAllIBlockElement->PrepareGetList(Array
(
)
)
(1.8)/home/bitrix/www/bitrix/modules/iblock/classes/mysql/iblockelement.php:684
CIBlockElement->prepareSql(Array
(
)
)
Час виконання: 0.00244 сек.
Запит No 32:
SELECT BE.ID as ID,BE.NAME as NAME,BE.IBLOCK_ID as IBLOCK_ID, FPS0.PROPERTY_212 as PROPERTY_UK_NAME_VALUE, concat(BE.ID , ':' , 212) as PROPERTY_UK_NAME_VALUE_ID
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 b_iblock_element_prop_s17 FPS0 ON FPS0.IBLOCK_ELEMENT_ID = BE.ID
WHERE
1=1 AND ( ((((BE.ID = '1434')))) AND ((((BE.IBLOCK_ID = '17')))) ) AND (((BE.WF_STATUS_ID=1 AND BE.WF_PARENT_ELEMENT_ID IS NULL)))
Звідки викликаний:
(1.1)/home/bitrix/www/bitrix/modules/iblock/classes/mysql/iblockelement.php:830
CDatabaseMysql->Query(...)
(1.2)/home/bitrix/www/local/templates/market2_v1/components/bxready.market2/basket.small/.default/result_modifier.php:6
CIBlockElement::GetList(Array
(
)
)
(1.3)/home/bitrix/www/bitrix/modules/main/classes/general/component_template.php:947
include(Array
(
[0] => /home/bitrix/www/local/templates/market2_v1/components/bxready.market2/basket.small/.default/result_modifier.php
)
)
(1.4)/home/bitrix/www/bitrix/modules/main/classes/general/component_template.php:854
CBitrixComponentTemplate->__IncludeMutatorFile(Array
(
)
)
(1.5)/home/bitrix/www/bitrix/modules/main/classes/general/component.php:776
CBitrixComponentTemplate->IncludeTemplate(Array
(
)
)
(1.6)/home/bitrix/www/bitrix/modules/main/classes/general/component.php:716
CBitrixComponent->showComponentTemplate(Array
(
)
)
(1.7)/home/bitrix/www/bitrix/components/bxready.market2/basket.small/component.php:270
CBitrixComponent->includeComponentTemplate(Array
(
)
)
(1.8)/home/bitrix/www/bitrix/modules/main/classes/general/component.php:607
include(Array
(
[0] => /home/bitrix/www/bitrix/components/bxready.market2/basket.small/component.php
)
)
Час виконання: 0.0003 сек.
Запит No 33:
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:3558
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:814
Bitrix\Main\ORM\Data\DataManager::getList(Array
(
)
)
(1.5)/home/bitrix/www/bitrix/modules/catalog/general/querybuilder.php:617
CProductQueryBuilder::getProductUserFields(Array
(
)
)
(1.6)/home/bitrix/www/bitrix/modules/catalog/general/querybuilder.php:103
CProductQueryBuilder::initEntityFields(Array
(
)
)
(1.7)/home/bitrix/www/bitrix/modules/iblock/classes/general/iblockelement.php:1314
CProductQueryBuilder::isValidField(Array
(
)
)
(1.8)/home/bitrix/www/bitrix/modules/iblock/classes/general/iblockelement.php:3139
CAllIBlockElement->MkFilter(Array
(
)
)
Час виконання: 0.00698 сек.
Запит No 34:
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,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 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.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,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=1, '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,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,') ',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,B.CANONICAL_PAGE_URL as CANONICAL_PAGE_URL,DATE_FORMAT(BE.DATE_CREATE, '%Y.%m.%d') as CREATED_DATE,if(BE.WF_STATUS_ID = 1, 'Y', 'N') 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_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.ID = '1434')))) )
Звідки викликаний:
(1.1)/home/bitrix/www/bitrix/modules/iblock/classes/mysql/iblockelement.php:830
CDatabaseMysql->Query(...)
(1.2)/home/bitrix/www/bitrix/modules/iblock/classes/general/iblockelement.php:4145
CIBlockElement::GetList(Array
(
)
)
(1.3)/home/bitrix/www/local/templates/market2_v1/components/bxready.market2/basket.small/.default/items_can_by.php:63
CAllIBlockElement::GetByID(Array
(
)
)
(1.4)/home/bitrix/www/local/templates/market2_v1/components/bxready.market2/basket.small/.default/items_basket.php:26
include(Array
(
[0] => /home/bitrix/www/local/templates/market2_v1/components/bxready.market2/basket.small/.default/items_can_by.php
)
)
(1.5)/home/bitrix/www/local/templates/market2_v1/components/bxready.market2/basket.small/.default/template.php:101
include(Array
(
[0] => /home/bitrix/www/local/templates/market2_v1/components/bxready.market2/basket.small/.default/items_basket.php
)
)
(1.6)/home/bitrix/www/bitrix/modules/main/classes/general/component_template.php:790
include(Array
(
[0] => /home/bitrix/www/local/templates/market2_v1/components/bxready.market2/basket.small/.default/template.php
)
)
(1.7)/home/bitrix/www/bitrix/modules/main/classes/general/component_template.php:885
CBitrixComponentTemplate->__IncludePHPTemplate(Array
(
)
)
(1.8)/home/bitrix/www/bitrix/modules/main/classes/general/component.php:776
CBitrixComponentTemplate->IncludeTemplate(Array
(
)
)
Час виконання: 0.00047 сек.
Запит No 35:
SELECT BS.*, B.LIST_PAGE_URL, B.SECTION_PAGE_URL, B.IBLOCK_TYPE_ID, B.CODE as IBLOCK_CODE, B.XML_ID as IBLOCK_EXTERNAL_ID, BS.XML_ID as EXTERNAL_ID
FROM
b_iblock_section BS
INNER JOIN b_iblock B ON B.ID = BS.IBLOCK_ID
WHERE
BS.ID=400
Звідки викликаний:
(1.1)/home/bitrix/www/bitrix/modules/iblock/classes/general/iblocksection.php:296
CDatabaseMysql->Query(...)
(1.2)/home/bitrix/www/local/templates/market2_v1/components/bxready.market2/basket.small/.default/items_can_by.php:65
CAllIBlockSection::GetNavChain(Array
(
)
)
(1.3)/home/bitrix/www/local/templates/market2_v1/components/bxready.market2/basket.small/.default/items_basket.php:26
include(Array
(
[0] => /home/bitrix/www/local/templates/market2_v1/components/bxready.market2/basket.small/.default/items_can_by.php
)
)
(1.4)/home/bitrix/www/local/templates/market2_v1/components/bxready.market2/basket.small/.default/template.php:101
include(Array
(
[0] => /home/bitrix/www/local/templates/market2_v1/components/bxready.market2/basket.small/.default/items_basket.php
)
)
(1.5)/home/bitrix/www/bitrix/modules/main/classes/general/component_template.php:790
include(Array
(
[0] => /home/bitrix/www/local/templates/market2_v1/components/bxready.market2/basket.small/.default/template.php
)
)
(1.6)/home/bitrix/www/bitrix/modules/main/classes/general/component_template.php:885
CBitrixComponentTemplate->__IncludePHPTemplate(Array
(
)
)
(1.7)/home/bitrix/www/bitrix/modules/main/classes/general/component.php:776
CBitrixComponentTemplate->IncludeTemplate(Array
(
)
)
(1.8)/home/bitrix/www/bitrix/modules/main/classes/general/component.php:716
CBitrixComponent->showComponentTemplate(Array
(
)
)
Час виконання: 6.0E-5 сек.
Запит No 36:
SELECT BS.*, B.LIST_PAGE_URL, B.SECTION_PAGE_URL, B.IBLOCK_TYPE_ID, B.CODE as IBLOCK_CODE, B.XML_ID as IBLOCK_EXTERNAL_ID, BS.XML_ID as EXTERNAL_ID
FROM
b_iblock_section BS
INNER JOIN b_iblock B ON B.ID = BS.IBLOCK_ID
WHERE
BS.ID=370
Звідки викликаний:
(1.1)/home/bitrix/www/bitrix/modules/iblock/classes/general/iblocksection.php:296
CDatabaseMysql->Query(...)
(1.2)/home/bitrix/www/local/templates/market2_v1/components/bxready.market2/basket.small/.default/items_can_by.php:65
CAllIBlockSection::GetNavChain(Array
(
)
)
(1.3)/home/bitrix/www/local/templates/market2_v1/components/bxready.market2/basket.small/.default/items_basket.php:26
include(Array
(
[0] => /home/bitrix/www/local/templates/market2_v1/components/bxready.market2/basket.small/.default/items_can_by.php
)
)
(1.4)/home/bitrix/www/local/templates/market2_v1/components/bxready.market2/basket.small/.default/template.php:101
include(Array
(
[0] => /home/bitrix/www/local/templates/market2_v1/components/bxready.market2/basket.small/.default/items_basket.php
)
)
(1.5)/home/bitrix/www/bitrix/modules/main/classes/general/component_template.php:790
include(Array
(
[0] => /home/bitrix/www/local/templates/market2_v1/components/bxready.market2/basket.small/.default/template.php
)
)
(1.6)/home/bitrix/www/bitrix/modules/main/classes/general/component_template.php:885
CBitrixComponentTemplate->__IncludePHPTemplate(Array
(
)
)
(1.7)/home/bitrix/www/bitrix/modules/main/classes/general/component.php:776
CBitrixComponentTemplate->IncludeTemplate(Array
(
)
)
(1.8)/home/bitrix/www/bitrix/modules/main/classes/general/component.php:716
CBitrixComponent->showComponentTemplate(Array
(
)
)
Час виконання: 0.00041 сек.
Запит No 37:
SELECT BS.*, B.LIST_PAGE_URL, B.SECTION_PAGE_URL, B.IBLOCK_TYPE_ID, B.CODE as IBLOCK_CODE, B.XML_ID as IBLOCK_EXTERNAL_ID, BS.XML_ID as EXTERNAL_ID
FROM
b_iblock_section BS
INNER JOIN b_iblock B ON B.ID = BS.IBLOCK_ID
WHERE
BS.ID=119
Звідки викликаний:
(1.1)/home/bitrix/www/bitrix/modules/iblock/classes/general/iblocksection.php:296
CDatabaseMysql->Query(...)
(1.2)/home/bitrix/www/local/templates/market2_v1/components/bxready.market2/basket.small/.default/items_can_by.php:65
CAllIBlockSection::GetNavChain(Array
(
)
)
(1.3)/home/bitrix/www/local/templates/market2_v1/components/bxready.market2/basket.small/.default/items_basket.php:26
include(Array
(
[0] => /home/bitrix/www/local/templates/market2_v1/components/bxready.market2/basket.small/.default/items_can_by.php
)
)
(1.4)/home/bitrix/www/local/templates/market2_v1/components/bxready.market2/basket.small/.default/template.php:101
include(Array
(
[0] => /home/bitrix/www/local/templates/market2_v1/components/bxready.market2/basket.small/.default/items_basket.php
)
)
(1.5)/home/bitrix/www/bitrix/modules/main/classes/general/component_template.php:790
include(Array
(
[0] => /home/bitrix/www/local/templates/market2_v1/components/bxready.market2/basket.small/.default/template.php
)
)
(1.6)/home/bitrix/www/bitrix/modules/main/classes/general/component_template.php:885
CBitrixComponentTemplate->__IncludePHPTemplate(Array
(
)
)
(1.7)/home/bitrix/www/bitrix/modules/main/classes/general/component.php:776
CBitrixComponentTemplate->IncludeTemplate(Array
(
)
)
(1.8)/home/bitrix/www/bitrix/modules/main/classes/general/component.php:716
CBitrixComponent->showComponentTemplate(Array
(
)
)
Час виконання: 7.0E-5 сек.
