Запрос № 1:
SELECT `sale_internals_status`.`ID` AS `ID`
FROM
`b_sale_status` `sale_internals_status`
WHERE
`sale_internals_status`.`TYPE` = 'O' AND ( `sale_internals_status`.`TYPE` = 'O' )
ORDER BY
`sale_internals_status`.`SORT` 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/lib/statusbase.php:46
Bitrix\Main\ORM\Data\DataManager::getList(Array
(
)
)
(1.5)/home/bitrix/www/bitrix/modules/sale/lib/statusbase.php:264
Bitrix\Sale\StatusBase::getList(Array
(
)
)
(1.6)/home/bitrix/www/bitrix/modules/sale/lib/orderstatus.php:62
Bitrix\Sale\StatusBase::getAllStatuses(Array
(
)
)
(1.7)/home/bitrix/www/bitrix/modules/sale/lib/orderbase.php:2704
Bitrix\Sale\OrderStatus::getAllowPayStatusList(Array
(
)
)
(1.8)/home/bitrix/www/bitrix/modules/sale/lib/orderbase.php:1723
Bitrix\Sale\OrderBase->isStatusChangedOnPay(Array
(
)
)
Время выполнения: 0.00011 сек.
Запрос № 2:
SELECT UA.ID, UA.USER_ID, UA.CURRENT_BUDGET, UA.CURRENCY, UA.NOTES, UA.LOCKED, DATE_FORMAT(UA.TIMESTAMP_X, '%d.%m.%Y %H:%i:%s') as TIMESTAMP_X, DATE_FORMAT(UA.DATE_LOCKED, '%d.%m.%Y %H:%i:%s') as DATE_LOCKED
FROM
b_sale_user_account UA
WHERE
UA.USER_ID = 1 AND UA.CURRENCY = 'RUB'
Откуда вызван:
(1.1)/home/bitrix/www/bitrix/modules/sale/mysql/user.php:67
CDatabaseMysql->Query(...)
(1.2)/home/bitrix/www/bitrix/modules/sale/lib/internals/userbudgetpool.php:315
CSaleUserAccount::GetByUserID(Array
(
)
)
(1.3)/home/bitrix/www/bitrix/modules/sale/lib/internals/userbudgetpool.php:295
Bitrix\Sale\Internals\UserBudgetPool::getUserBudget(Array
(
)
)
(1.4)/home/bitrix/www/bitrix/modules/sale/lib/order.php:1482
Bitrix\Sale\Internals\UserBudgetPool::getUserBudgetByOrder(Array
(
)
)
(1.5)/home/bitrix/www/bitrix/modules/sale/lib/order.php:1355
Bitrix\Sale\Order->syncOrderPaid(Array
(
)
)
(1.6)/home/bitrix/www/bitrix/modules/sale/lib/order.php:1073
Bitrix\Sale\Order->syncOrderAndPayments(Array
(
)
)
(1.7)/home/bitrix/www/bitrix/modules/sale/lib/internals/entity.php:292
Bitrix\Sale\Order->onFieldModify(Array
(
)
)
(1.8)/home/bitrix/www/bitrix/modules/sale/lib/orderbase.php:464
Bitrix\Sale\Internals\Entity->setField(Array
(
)
)
Время выполнения: 0.00033 сек.
(2.1)/home/bitrix/www/bitrix/modules/sale/mysql/user.php:67
CDatabaseMysql->Query(...)
(2.2)/home/bitrix/www/bitrix/modules/sale/lib/internals/userbudgetpool.php:315
CSaleUserAccount::GetByUserID(Array
(
)
)
(2.3)/home/bitrix/www/bitrix/modules/sale/lib/internals/userbudgetpool.php:295
Bitrix\Sale\Internals\UserBudgetPool::getUserBudget(Array
(
)
)
(2.4)/home/bitrix/www/bitrix/modules/sale/lib/order.php:1482
Bitrix\Sale\Internals\UserBudgetPool::getUserBudgetByOrder(Array
(
)
)
(2.5)/home/bitrix/www/bitrix/modules/sale/lib/order.php:1355
Bitrix\Sale\Order->syncOrderPaid(Array
(
)
)
(2.6)/home/bitrix/www/bitrix/modules/sale/lib/order.php:1073
Bitrix\Sale\Order->syncOrderAndPayments(Array
(
)
)
(2.7)/home/bitrix/www/bitrix/modules/sale/lib/internals/entity.php:292
Bitrix\Sale\Order->onFieldModify(Array
(
)
)
(2.8)/home/bitrix/www/bitrix/modules/sale/lib/orderbase.php:464
Bitrix\Sale\Internals\Entity->setField(Array
(
)
)
Время выполнения: 0.00189 сек.
Запрос № 3:
SELECT `sale_delivery_services_`.`ID` AS `ID`, `sale_delivery_services_`.`CODE` AS `CODE`, `sale_delivery_services_`.`PARENT_ID` AS `PARENT_ID`, `sale_delivery_services_`.`NAME` AS `NAME`, `sale_delivery_services_`.`ACTIVE` AS `ACTIVE`, `sale_delivery_services_`.`DESCRIPTION` AS `DESCRIPTION`, `sale_delivery_services_`.`SORT` AS `SORT`, `sale_delivery_services_`.`LOGOTIP` AS `LOGOTIP`, `sale_delivery_services_`.`CONFIG` AS `CONFIG`, `sale_delivery_services_`.`CLASS_NAME` AS `CLASS_NAME`, `sale_delivery_services_`.`CURRENCY` AS `CURRENCY`, `sale_delivery_services_`.`TRACKING_PARAMS` AS `TRACKING_PARAMS`, `sale_delivery_services_`.`ALLOW_EDIT_SHIPMENT` AS `ALLOW_EDIT_SHIPMENT`, `sale_delivery_services_`.`VAT_ID` AS `VAT_ID`, `sale_delivery_services_`.`XML_ID` AS `XML_ID`
FROM
`b_sale_delivery_srv` `sale_delivery_services_`
WHERE
`sale_delivery_services_`.`ID` = 6
Откуда вызван:
(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/delivery/services/manager.php:65
Bitrix\Main\ORM\Data\DataManager::getList(Array
(
)
)
(1.5)/home/bitrix/www/bitrix/modules/sale/lib/shipment.php:191
Bitrix\Sale\Delivery\Services\Manager::getById(Array
(
)
)
(1.6)/home/bitrix/www/bitrix/modules/sale/lib/shipment.php:1253
Bitrix\Sale\Shipment::create(Array
(
)
)
(1.7)/home/bitrix/www/bitrix/modules/sale/lib/shipmentcollection.php:282
Bitrix\Sale\Shipment::createSystem(Array
(
)
)
(1.8)/home/bitrix/www/bitrix/modules/sale/lib/shipmentcollection.php:69
Bitrix\Sale\ShipmentCollection->getSystemShipment(Array
(
)
)
Время выполнения: 0.00136 сек.
Запрос № 4:
SELECT `sale_internals_order_props`.`ID` AS `ID`, `sale_internals_order_props`.`PERSON_TYPE_ID` AS `PERSON_TYPE_ID`, `sale_internals_order_props`.`NAME` AS `NAME`, `sale_internals_order_props`.`TYPE` AS `TYPE`, `sale_internals_order_props`.`REQUIRED` AS `REQUIRED`, `sale_internals_order_props`.`DEFAULT_VALUE` AS `DEFAULT_VALUE`, `sale_internals_order_props`.`SORT` AS `SORT`, `sale_internals_order_props`.`USER_PROPS` AS `USER_PROPS`, `sale_internals_order_props`.`IS_LOCATION` AS `IS_LOCATION`, `sale_internals_order_props`.`PROPS_GROUP_ID` AS `PROPS_GROUP_ID`, `sale_internals_order_props`.`DESCRIPTION` AS `DESCRIPTION`, `sale_internals_order_props`.`IS_EMAIL` AS `IS_EMAIL`, `sale_internals_order_props`.`IS_PROFILE_NAME` AS `IS_PROFILE_NAME`, `sale_internals_order_props`.`IS_PAYER` AS `IS_PAYER`, `sale_internals_order_props`.`IS_LOCATION4TAX` AS `IS_LOCATION4TAX`, `sale_internals_order_props`.`IS_FILTERED` AS `IS_FILTERED`, `sale_internals_order_props`.`CODE` AS `CODE`, `sale_internals_order_props`.`IS_ZIP` AS `IS_ZIP`, `sale_internals_order_props`.`IS_PHONE` AS `IS_PHONE`, `sale_internals_order_props`.`IS_ADDRESS` AS `IS_ADDRESS`, `sale_internals_order_props`.`IS_ADDRESS_FROM` AS `IS_ADDRESS_FROM`, `sale_internals_order_props`.`IS_ADDRESS_TO` AS `IS_ADDRESS_TO`, `sale_internals_order_props`.`ACTIVE` AS `ACTIVE`, `sale_internals_order_props`.`UTIL` AS `UTIL`, `sale_internals_order_props`.`INPUT_FIELD_LOCATION` AS `INPUT_FIELD_LOCATION`, `sale_internals_order_props`.`MULTIPLE` AS `MULTIPLE`, `sale_internals_order_props`.`SETTINGS` AS `SETTINGS`, `sale_internals_order_props`.`ENTITY_TYPE` AS `ENTITY_TYPE`, `sale_internals_order_props_relation_ps`.`PROPERTY_ID` AS `UALIAS_0`, `sale_internals_order_props_relation_ps`.`ENTITY_ID` AS `UALIAS_1`, `sale_internals_order_props_relation_ps`.`ENTITY_TYPE` AS `UALIAS_2`, `sale_internals_order_props_relation_dlv`.`PROPERTY_ID` AS `UALIAS_3`, `sale_internals_order_props_relation_dlv`.`ENTITY_ID` AS `UALIAS_4`, `sale_internals_order_props_relation_dlv`.`ENTITY_TYPE` AS `UALIAS_5`, `sale_internals_order_props_relation_tp_landing`.`PROPERTY_ID` AS `UALIAS_6`, `sale_internals_order_props_relation_tp_landing`.`ENTITY_ID` AS `UALIAS_7`, `sale_internals_order_props_relation_tp_landing`.`ENTITY_TYPE` AS `UALIAS_8`
FROM
`b_sale_order_props` `sale_internals_order_props`
LEFT JOIN `b_sale_order_props_relation` `sale_internals_order_props_relation_ps` ON `sale_internals_order_props`.`ID` = `sale_internals_order_props_relation_ps`.`PROPERTY_ID` AND `sale_internals_order_props_relation_ps`.`ENTITY_TYPE` = 'P'
LEFT JOIN `b_sale_order_props_relation` `sale_internals_order_props_relation_dlv` ON `sale_internals_order_props`.`ID` = `sale_internals_order_props_relation_dlv`.`PROPERTY_ID` AND `sale_internals_order_props_relation_dlv`.`ENTITY_TYPE` = 'D'
LEFT JOIN `b_sale_order_props_relation` `sale_internals_order_props_relation_tp_landing` ON `sale_internals_order_props`.`ID` = `sale_internals_order_props_relation_tp_landing`.`PROPERTY_ID` AND `sale_internals_order_props_relation_tp_landing`.`ENTITY_TYPE` = 'L'
WHERE
`sale_internals_order_props`.`ENTITY_REGISTRY_TYPE` = 'ORDER' AND `sale_internals_order_props`.`ENTITY_TYPE` = 'ORDER' AND ( `sale_internals_order_props`.`ENTITY_TYPE` = 'ORDER' AND ( ( (`sale_internals_order_props_relation_tp_landing`.`ENTITY_ID` IS NULL OR `sale_internals_order_props_relation_tp_landing`.`ENTITY_ID` = '') AND ( ( (`sale_internals_order_props_relation_ps`.`ENTITY_ID` IS NULL OR `sale_internals_order_props_relation_ps`.`ENTITY_ID` = '') ) AND ( (`sale_internals_order_props_relation_dlv`.`ENTITY_ID` IS NULL OR `sale_internals_order_props_relation_dlv`.`ENTITY_ID` = '') ) ) ) ) )
ORDER BY
`SORT` 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/lib/entityproperty.php:64
Bitrix\Main\ORM\Data\DataManager::getList(Array
(
)
)
(1.5)/home/bitrix/www/bitrix/modules/sale/lib/entitypropertyvalue.php:136
Bitrix\Sale\EntityProperty::getList(Array
(
)
)
(1.6)/home/bitrix/www/bitrix/modules/sale/lib/entitypropertyvalue.php:942
Bitrix\Sale\EntityPropertyValue::loadFromDb(Array
(
)
)
(1.7)/home/bitrix/www/bitrix/modules/sale/lib/propertyvaluebase.php:47
Bitrix\Sale\EntityPropertyValue::loadForEntity(Array
(
)
)
(1.8)/home/bitrix/www/bitrix/modules/sale/lib/propertyvaluecollectionbase.php:64
Bitrix\Sale\PropertyValueBase::loadForOrder(Array
(
)
)
Время выполнения: 0.01509 сек.
(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/sale/lib/entityproperty.php:64
Bitrix\Main\ORM\Data\DataManager::getList(Array
(
)
)
(2.5)/home/bitrix/www/bitrix/modules/sale/lib/entitypropertyvalue.php:136
Bitrix\Sale\EntityProperty::getList(Array
(
)
)
(2.6)/home/bitrix/www/bitrix/modules/sale/lib/entitypropertyvalue.php:942
Bitrix\Sale\EntityPropertyValue::loadFromDb(Array
(
)
)
(2.7)/home/bitrix/www/bitrix/modules/sale/lib/entitypropertyvaluecollection.php:527
Bitrix\Sale\EntityPropertyValue::loadForEntity(Array
(
)
)
(2.8)/home/bitrix/www/bitrix/modules/sale/lib/order.php:174
Bitrix\Sale\EntityPropertyValueCollection->refreshRelated(Array
(
)
)
Время выполнения: 0.00374 сек.
Запрос № 5:
SELECT `sale_internals_order_props_relation`.`PROPERTY_ID` AS `PROPERTY_ID`, `sale_internals_order_props_relation`.`ENTITY_ID` AS `ENTITY_ID`, `sale_internals_order_props_relation`.`ENTITY_TYPE` AS `ENTITY_TYPE`
FROM
`b_sale_order_props_relation` `sale_internals_order_props_relation`
WHERE
(`sale_internals_order_props_relation`.`PROPERTY_ID` in (1, 27, 28, 2, 8, 18, 3, 4, 9, 19, 6, 10, 20, 5, 7, 11, 21, 12, 13, 22, 14, 23, 15, 24, 16, 25, 17, 26))
Откуда вызван:
(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/entitypropertyvalue.php:154
Bitrix\Main\ORM\Data\DataManager::getList(Array
(
)
)
(1.5)/home/bitrix/www/bitrix/modules/sale/lib/entitypropertyvalue.php:942
Bitrix\Sale\EntityPropertyValue::loadFromDb(Array
(
)
)
(1.6)/home/bitrix/www/bitrix/modules/sale/lib/propertyvaluebase.php:47
Bitrix\Sale\EntityPropertyValue::loadForEntity(Array
(
)
)
(1.7)/home/bitrix/www/bitrix/modules/sale/lib/propertyvaluecollectionbase.php:64
Bitrix\Sale\PropertyValueBase::loadForOrder(Array
(
)
)
(1.8)/home/bitrix/www/bitrix/modules/sale/lib/orderbase.php:612
Bitrix\Sale\PropertyValueCollectionBase::load(Array
(
)
)
Время выполнения: 0.01101 сек.
(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/sale/lib/entitypropertyvalue.php:154
Bitrix\Main\ORM\Data\DataManager::getList(Array
(
)
)
(2.5)/home/bitrix/www/bitrix/modules/sale/lib/entitypropertyvalue.php:942
Bitrix\Sale\EntityPropertyValue::loadFromDb(Array
(
)
)
(2.6)/home/bitrix/www/bitrix/modules/sale/lib/entitypropertyvaluecollection.php:527
Bitrix\Sale\EntityPropertyValue::loadForEntity(Array
(
)
)
(2.7)/home/bitrix/www/bitrix/modules/sale/lib/order.php:174
Bitrix\Sale\EntityPropertyValueCollection->refreshRelated(Array
(
)
)
(2.8)/home/bitrix/www/bitrix/modules/sale/lib/shipmentcollection.php:142
Bitrix\Sale\Order->onShipmentCollectionModify(Array
(
)
)
Время выполнения: 0.008 сек.
Запрос № 6:
SELECT `sale_delivery_extraservices_`.`ID` AS `ID`, `sale_delivery_extraservices_`.`CODE` AS `CODE`, `sale_delivery_extraservices_`.`NAME` AS `NAME`, `sale_delivery_extraservices_`.`DESCRIPTION` AS `DESCRIPTION`, `sale_delivery_extraservices_`.`CLASS_NAME` AS `CLASS_NAME`, `sale_delivery_extraservices_`.`PARAMS` AS `PARAMS`, `sale_delivery_extraservices_`.`RIGHTS` AS `RIGHTS`, `sale_delivery_extraservices_`.`DELIVERY_ID` AS `DELIVERY_ID`, `sale_delivery_extraservices_`.`INIT_VALUE` AS `INIT_VALUE`, `sale_delivery_extraservices_`.`ACTIVE` AS `ACTIVE`, `sale_delivery_extraservices_`.`SORT` AS `SORT`, `sale_delivery_extraservices__delivery_service`.`CURRENCY` AS `CURRENCY`, `sale_delivery_extraservices__delivery_service`.`ID` AS `UALIAS_0`
FROM
`b_sale_delivery_es` `sale_delivery_extraservices_`
LEFT JOIN `b_sale_delivery_srv` `sale_delivery_extraservices__delivery_service` ON `sale_delivery_extraservices_`.`DELIVERY_ID` = `sale_delivery_extraservices__delivery_service`.`ID`
WHERE
(`sale_delivery_extraservices_`.`DELIVERY_ID` in (6)) AND ( `sale_delivery_extraservices_`.`ACTIVE` = 'Y' OR `sale_delivery_extraservices_`.`CLASS_NAME` = '\\Bitrix\\Sale\\Delivery\\ExtraServices\\Store' )
ORDER BY
`SORT` ASC, `NAME` 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/lib/delivery/extra_services/manager.php:729
Bitrix\Main\ORM\Data\DataManager::getList(Array
(
)
)
(1.5)/home/bitrix/www/bitrix/modules/sale/lib/delivery/extra_services/manager.php:683
Bitrix\Sale\Delivery\ExtraServices\Manager::prepareData(Array
(
)
)
(1.6)/home/bitrix/www/bitrix/modules/sale/lib/delivery/extra_services/manager.php:48
Bitrix\Sale\Delivery\ExtraServices\Manager::getExtraServicesList(Array
(
)
)
(1.7)/home/bitrix/www/bitrix/modules/sale/lib/delivery/services/base.php:127
Bitrix\Sale\Delivery\ExtraServices\Manager->__construct(Array
(
)
)
(1.8)/home/bitrix/www/bitrix/modules/sale/lib/delivery/services/configurable.php:34
Bitrix\Sale\Delivery\Services\Base->__construct(Array
(
)
)
Время выполнения: 0.00025 сек.
Запрос № 7:
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/lib/discount/context/user.php:15
CAllUser::GetUserGroup(Array
(
)
)
(1.4)/home/bitrix/www/bitrix/modules/sale/lib/discountbase.php:271
Bitrix\Sale\Discount\Context\User->__construct(Array
(
)
)
(1.5)/home/bitrix/www/bitrix/modules/sale/lib/orderbase.php:2405
Bitrix\Sale\DiscountBase::buildFromOrder(Array
(
)
)
(1.6)/home/bitrix/www/bitrix/modules/sale/lib/orderbase.php:2374
Bitrix\Sale\OrderBase->loadDiscount(Array
(
)
)
(1.7)/home/bitrix/www/bitrix/modules/sale/lib/orderbase.php:2519
Bitrix\Sale\OrderBase->getDiscount(Array
(
)
)
(1.8)/home/bitrix/www/bitrix/modules/sale/lib/order.php:686
Bitrix\Sale\OrderBase->doFinalAction(Array
(
)
)
Время выполнения: 0.00086 сек.
Запрос № 8:
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,2,3,4) 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/lib/discount/runtimecache/discountcache.php:53
Bitrix\Main\ORM\Data\DataManager::getList(Array
(
)
)
(1.5)/home/bitrix/www/bitrix/modules/sale/lib/discountbase.php:5451
Bitrix\Sale\Discount\RuntimeCache\DiscountCache->getDiscountIds(Array
(
)
)
(1.6)/home/bitrix/www/bitrix/modules/sale/lib/discountbase.php:1322
Bitrix\Sale\DiscountBase->loadDiscountByUserGroups(Array
(
)
)
(1.7)/home/bitrix/www/bitrix/modules/sale/lib/discountbase.php:490
Bitrix\Sale\DiscountBase->calculateFull(Array
(
)
)
(1.8)/home/bitrix/www/bitrix/modules/sale/lib/orderbase.php:2520
Bitrix\Sale\DiscountBase->calculate(Array
(
)
)
Время выполнения: 0.02922 сек.
Запрос № 9:
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`, `sale_internals_discount`.`ACTIVE_FROM` AS `ACTIVE_FROM`, `sale_internals_discount`.`ACTIVE_TO` AS `ACTIVE_TO`, `sale_internals_discount`.`PREDICTIONS` AS `PREDICTIONS_LIST`, `sale_internals_discount`.`PREDICTIONS_APP` AS `PREDICTIONS_APP`, `sale_internals_discount`.`PREDICTION_TEXT` AS `PREDICTION_TEXT`, `sale_internals_discount`.`PRESET_ID` AS `PRESET_ID`, `sale_internals_discount`.`CURRENCY` AS `CURRENCY`, `sale_internals_discount`.`LID` AS `LID`, `sale_internals_discount`.`SHORT_DESCRIPTION` AS `SHORT_DESCRIPTION`, `sale_internals_discount`.`SHORT_DESCRIPTION` AS `SHORT_DESCRIPTION_STRUCTURE`
FROM
`b_sale_discount` `sale_internals_discount`
WHERE
`sale_internals_discount`.`ID` IN (38) AND `sale_internals_discount`.`LID` = 's1' AND `sale_internals_discount`.`EXECUTE_MODULE` IN ('all', 'sale', 'catalog') AND ( (`sale_internals_discount`.`ACTIVE_FROM` IS NULL) OR `sale_internals_discount`.`ACTIVE_FROM` <= '2026-11-01 22:04:14' ) AND ( (`sale_internals_discount`.`ACTIVE_TO` IS NULL) OR `sale_internals_discount`.`ACTIVE_TO` >= '2026-11-01 22:04:14' ) 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/lib/discount/runtimecache/discountcache.php:212
Bitrix\Main\ORM\Data\DataManager::getList(Array
(
)
)
(1.5)/home/bitrix/www/bitrix/modules/sale/lib/discountbase.php:5534
Bitrix\Sale\Discount\RuntimeCache\DiscountCache->getDiscounts(Array
(
)
)
(1.6)/home/bitrix/www/bitrix/modules/sale/lib/discountbase.php:1323
Bitrix\Sale\DiscountBase->loadDiscountList(Array
(
)
)
(1.7)/home/bitrix/www/bitrix/modules/sale/lib/discountbase.php:490
Bitrix\Sale\DiscountBase->calculateFull(Array
(
)
)
(1.8)/home/bitrix/www/bitrix/modules/sale/lib/orderbase.php:2520
Bitrix\Sale\DiscountBase->calculate(Array
(
)
)
Время выполнения: 0.01223 сек.
Запрос № 10:
SELECT TE2G.GROUP_ID, TE2G.TAX_ID
FROM
b_sale_tax_exempt2group TE2G
WHERE
1 = 1 AND (((TE2G.GROUP_ID = 1 ) OR (TE2G.GROUP_ID = 3 ) OR (TE2G.GROUP_ID = 4 ) OR (TE2G.GROUP_ID = 2 )))
Откуда вызван:
(1.1)/home/bitrix/www/bitrix/modules/sale/general/tax.php:683
CDatabaseMysql->Query(...)
(1.2)/home/bitrix/www/bitrix/modules/sale/lib/tax.php:636
CAllSaleTax::GetExemptList(Array
(
)
)
(1.3)/home/bitrix/www/bitrix/modules/sale/lib/tax.php:679
Bitrix\Sale\Tax::loadExemptList(Array
(
)
)
(1.4)/home/bitrix/www/bitrix/modules/sale/lib/tax.php:658
Bitrix\Sale\Tax->loadAvailableList(Array
(
)
)
(1.5)/home/bitrix/www/bitrix/modules/sale/lib/tax.php:524
Bitrix\Sale\Tax->getAvailableList(Array
(
)
)
(1.6)/home/bitrix/www/bitrix/modules/sale/lib/orderbase.php:2391
Bitrix\Sale\Tax::load(Array
(
)
)
(1.7)/home/bitrix/www/bitrix/modules/sale/lib/orderbase.php:1840
Bitrix\Sale\OrderBase->loadTax(Array
(
)
)
(1.8)/home/bitrix/www/bitrix/modules/sale/lib/orderbase.php:2540
Bitrix\Sale\OrderBase->getTax(Array
(
)
)
Время выполнения: 0.00096 сек.
Запрос № 11:
SELECT DISTINCT TR.ID, TR.TAX_ID, TR.PERSON_TYPE_ID, TR.VALUE, TR.CURRENCY, TR.IS_PERCENT, TR.IS_IN_PRICE, TR.APPLY_ORDER, DATE_FORMAT(TR.TIMESTAMP_X, '%d.%m.%Y %H:%i:%s') as TIMESTAMP_X, T.LID, T.NAME, T.DESCRIPTION, TR.ACTIVE, T.CODE
FROM
b_sale_tax_rate TR, b_sale_tax T
WHERE
TR.TAX_ID = T.ID AND (T.LID = 's1' ) AND ( (TR.PERSON_TYPE_ID = 0 OR TR.PERSON_TYPE_ID = 0 OR TR.PERSON_TYPE_ID IS NULL) ) AND (TR.ACTIVE = 'Y' )
ORDER BY
TR.APPLY_ORDER ASC
Откуда вызван:
(1.1)/home/bitrix/www/bitrix/modules/sale/mysql/tax_rate.php:190
CDatabaseMysql->Query(...)
(1.2)/home/bitrix/www/bitrix/modules/sale/lib/tax.php:687
CSaleTaxRate::GetList(Array
(
)
)
(1.3)/home/bitrix/www/bitrix/modules/sale/lib/tax.php:658
Bitrix\Sale\Tax->loadAvailableList(Array
(
)
)
(1.4)/home/bitrix/www/bitrix/modules/sale/lib/tax.php:524
Bitrix\Sale\Tax->getAvailableList(Array
(
)
)
(1.5)/home/bitrix/www/bitrix/modules/sale/lib/orderbase.php:2391
Bitrix\Sale\Tax::load(Array
(
)
)
(1.6)/home/bitrix/www/bitrix/modules/sale/lib/orderbase.php:1840
Bitrix\Sale\OrderBase->loadTax(Array
(
)
)
(1.7)/home/bitrix/www/bitrix/modules/sale/lib/orderbase.php:2540
Bitrix\Sale\OrderBase->getTax(Array
(
)
)
(1.8)/home/bitrix/www/bitrix/modules/sale/lib/order.php:686
Bitrix\Sale\OrderBase->doFinalAction(Array
(
)
)
Время выполнения: 0.00013 сек.
(2.1)/home/bitrix/www/bitrix/modules/sale/mysql/tax_rate.php:190
CDatabaseMysql->Query(...)
(2.2)/home/bitrix/www/bitrix/modules/sale/lib/tax.php:687
CSaleTaxRate::GetList(Array
(
)
)
(2.3)/home/bitrix/www/bitrix/modules/sale/lib/tax.php:658
Bitrix\Sale\Tax->loadAvailableList(Array
(
)
)
(2.4)/home/bitrix/www/bitrix/modules/sale/lib/tax.php:238
Bitrix\Sale\Tax->getAvailableList(Array
(
)
)
(2.5)/home/bitrix/www/bitrix/modules/sale/lib/tax.php:591
Bitrix\Sale\Tax->calculateDelivery(Array
(
)
)
(2.6)/home/bitrix/www/bitrix/modules/sale/lib/orderbase.php:2542
Bitrix\Sale\Tax->refreshData(Array
(
)
)
(2.7)/home/bitrix/www/bitrix/modules/sale/lib/order.php:686
Bitrix\Sale\OrderBase->doFinalAction(Array
(
)
)
(2.8)/home/bitrix/www/bitrix/components/bitrix/sale.account.pay/class.php:469
Bitrix\Sale\Order->setBasket(Array
(
)
)
Время выполнения: 5.0E-5 сек.
Запрос № 12:
SELECT DISTINCT TR.ID, TR.TAX_ID, TR.PERSON_TYPE_ID, TR.VALUE, TR.CURRENCY, TR.IS_PERCENT, TR.IS_IN_PRICE, TR.APPLY_ORDER, DATE_FORMAT(TR.TIMESTAMP_X, '%d.%m.%Y %H:%i:%s') as TIMESTAMP_X, T.LID, T.NAME, T.DESCRIPTION, TR.ACTIVE, T.CODE
FROM
b_sale_tax_rate TR, b_sale_tax T
WHERE
TR.TAX_ID = T.ID AND (T.LID = 's1' ) AND ( (TR.PERSON_TYPE_ID = 1 OR TR.PERSON_TYPE_ID = 0 OR TR.PERSON_TYPE_ID IS NULL) ) AND (TR.ACTIVE = 'Y' )
ORDER BY
TR.APPLY_ORDER ASC
Откуда вызван:
(1.1)/home/bitrix/www/bitrix/modules/sale/mysql/tax_rate.php:190
CDatabaseMysql->Query(...)
(1.2)/home/bitrix/www/bitrix/modules/sale/lib/tax.php:687
CSaleTaxRate::GetList(Array
(
)
)
(1.3)/home/bitrix/www/bitrix/modules/sale/lib/tax.php:658
Bitrix\Sale\Tax->loadAvailableList(Array
(
)
)
(1.4)/home/bitrix/www/bitrix/modules/sale/lib/tax.php:238
Bitrix\Sale\Tax->getAvailableList(Array
(
)
)
(1.5)/home/bitrix/www/bitrix/modules/sale/lib/tax.php:591
Bitrix\Sale\Tax->calculateDelivery(Array
(
)
)
(1.6)/home/bitrix/www/bitrix/modules/sale/lib/orderbase.php:2542
Bitrix\Sale\Tax->refreshData(Array
(
)
)
(1.7)/home/bitrix/www/bitrix/modules/sale/lib/internals/entity.php:327
Bitrix\Sale\OrderBase->doFinalAction(Array
(
)
)
(1.8)/home/bitrix/www/bitrix/modules/sale/lib/orderbase.php:464
Bitrix\Sale\Internals\Entity->setField(Array
(
)
)
Время выполнения: 0.00016 сек.
(2.1)/home/bitrix/www/bitrix/modules/sale/mysql/tax_rate.php:190
CDatabaseMysql->Query(...)
(2.2)/home/bitrix/www/bitrix/modules/sale/lib/tax.php:687
CSaleTaxRate::GetList(Array
(
)
)
(2.3)/home/bitrix/www/bitrix/modules/sale/lib/tax.php:658
Bitrix\Sale\Tax->loadAvailableList(Array
(
)
)
(2.4)/home/bitrix/www/bitrix/modules/sale/lib/tax.php:238
Bitrix\Sale\Tax->getAvailableList(Array
(
)
)
(2.5)/home/bitrix/www/bitrix/modules/sale/lib/tax.php:591
Bitrix\Sale\Tax->calculateDelivery(Array
(
)
)
(2.6)/home/bitrix/www/bitrix/modules/sale/lib/orderbase.php:2542
Bitrix\Sale\Tax->refreshData(Array
(
)
)
(2.7)/home/bitrix/www/bitrix/modules/sale/lib/internals/entitycollection.php:298
Bitrix\Sale\OrderBase->doFinalAction(Array
(
)
)
(2.8)/home/bitrix/www/bitrix/modules/sale/lib/internals/collectableentity.php:133
Bitrix\Sale\Internals\EntityCollection->doFinalAction(Array
(
)
)
Время выполнения: 0.00015 сек.
Запрос № 13:
SELECT `sale_internals_order_props`.`ID` AS `ID`, `sale_internals_order_props`.`PERSON_TYPE_ID` AS `PERSON_TYPE_ID`, `sale_internals_order_props`.`NAME` AS `NAME`, `sale_internals_order_props`.`TYPE` AS `TYPE`, `sale_internals_order_props`.`REQUIRED` AS `REQUIRED`, `sale_internals_order_props`.`DEFAULT_VALUE` AS `DEFAULT_VALUE`, `sale_internals_order_props`.`SORT` AS `SORT`, `sale_internals_order_props`.`USER_PROPS` AS `USER_PROPS`, `sale_internals_order_props`.`IS_LOCATION` AS `IS_LOCATION`, `sale_internals_order_props`.`PROPS_GROUP_ID` AS `PROPS_GROUP_ID`, `sale_internals_order_props`.`DESCRIPTION` AS `DESCRIPTION`, `sale_internals_order_props`.`IS_EMAIL` AS `IS_EMAIL`, `sale_internals_order_props`.`IS_PROFILE_NAME` AS `IS_PROFILE_NAME`, `sale_internals_order_props`.`IS_PAYER` AS `IS_PAYER`, `sale_internals_order_props`.`IS_LOCATION4TAX` AS `IS_LOCATION4TAX`, `sale_internals_order_props`.`IS_FILTERED` AS `IS_FILTERED`, `sale_internals_order_props`.`CODE` AS `CODE`, `sale_internals_order_props`.`IS_ZIP` AS `IS_ZIP`, `sale_internals_order_props`.`IS_PHONE` AS `IS_PHONE`, `sale_internals_order_props`.`IS_ADDRESS` AS `IS_ADDRESS`, `sale_internals_order_props`.`IS_ADDRESS_FROM` AS `IS_ADDRESS_FROM`, `sale_internals_order_props`.`IS_ADDRESS_TO` AS `IS_ADDRESS_TO`, `sale_internals_order_props`.`ACTIVE` AS `ACTIVE`, `sale_internals_order_props`.`UTIL` AS `UTIL`, `sale_internals_order_props`.`INPUT_FIELD_LOCATION` AS `INPUT_FIELD_LOCATION`, `sale_internals_order_props`.`MULTIPLE` AS `MULTIPLE`, `sale_internals_order_props`.`SETTINGS` AS `SETTINGS`, `sale_internals_order_props`.`ENTITY_TYPE` AS `ENTITY_TYPE`, `sale_internals_order_props_relation_ps`.`PROPERTY_ID` AS `UALIAS_0`, `sale_internals_order_props_relation_ps`.`ENTITY_ID` AS `UALIAS_1`, `sale_internals_order_props_relation_ps`.`ENTITY_TYPE` AS `UALIAS_2`, `sale_internals_order_props_relation_dlv`.`PROPERTY_ID` AS `UALIAS_3`, `sale_internals_order_props_relation_dlv`.`ENTITY_ID` AS `UALIAS_4`, `sale_internals_order_props_relation_dlv`.`ENTITY_TYPE` AS `UALIAS_5`, `sale_internals_order_props_relation_tp_landing`.`PROPERTY_ID` AS `UALIAS_6`, `sale_internals_order_props_relation_tp_landing`.`ENTITY_ID` AS `UALIAS_7`, `sale_internals_order_props_relation_tp_landing`.`ENTITY_TYPE` AS `UALIAS_8`
FROM
`b_sale_order_props` `sale_internals_order_props`
LEFT JOIN `b_sale_order_props_relation` `sale_internals_order_props_relation_ps` ON `sale_internals_order_props`.`ID` = `sale_internals_order_props_relation_ps`.`PROPERTY_ID` AND `sale_internals_order_props_relation_ps`.`ENTITY_TYPE` = 'P'
LEFT JOIN `b_sale_order_props_relation` `sale_internals_order_props_relation_dlv` ON `sale_internals_order_props`.`ID` = `sale_internals_order_props_relation_dlv`.`PROPERTY_ID` AND `sale_internals_order_props_relation_dlv`.`ENTITY_TYPE` = 'D'
LEFT JOIN `b_sale_order_props_relation` `sale_internals_order_props_relation_tp_landing` ON `sale_internals_order_props`.`ID` = `sale_internals_order_props_relation_tp_landing`.`PROPERTY_ID` AND `sale_internals_order_props_relation_tp_landing`.`ENTITY_TYPE` = 'L'
WHERE
`sale_internals_order_props`.`ENTITY_REGISTRY_TYPE` = 'ORDER' AND `sale_internals_order_props`.`ENTITY_TYPE` = 'ORDER' AND ( `sale_internals_order_props`.`ENTITY_TYPE` = 'ORDER' AND `sale_internals_order_props`.`PERSON_TYPE_ID` = 1 AND ( ( (`sale_internals_order_props_relation_tp_landing`.`ENTITY_ID` IS NULL OR `sale_internals_order_props_relation_tp_landing`.`ENTITY_ID` = '') AND ( ( (`sale_internals_order_props_relation_ps`.`ENTITY_ID` IS NULL OR `sale_internals_order_props_relation_ps`.`ENTITY_ID` = '') ) AND ( (`sale_internals_order_props_relation_dlv`.`ENTITY_ID` IS NULL OR `sale_internals_order_props_relation_dlv`.`ENTITY_ID` = '') OR `sale_internals_order_props_relation_dlv`.`ENTITY_ID` IN ('6') ) ) ) ) )
ORDER BY
`SORT` 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/lib/entityproperty.php:64
Bitrix\Main\ORM\Data\DataManager::getList(Array
(
)
)
(1.5)/home/bitrix/www/bitrix/modules/sale/lib/entitypropertyvalue.php:136
Bitrix\Sale\EntityProperty::getList(Array
(
)
)
(1.6)/home/bitrix/www/bitrix/modules/sale/lib/entitypropertyvalue.php:942
Bitrix\Sale\EntityPropertyValue::loadFromDb(Array
(
)
)
(1.7)/home/bitrix/www/bitrix/modules/sale/lib/entitypropertyvaluecollection.php:527
Bitrix\Sale\EntityPropertyValue::loadForEntity(Array
(
)
)
(1.8)/home/bitrix/www/bitrix/modules/sale/lib/order.php:174
Bitrix\Sale\EntityPropertyValueCollection->refreshRelated(Array
(
)
)
Время выполнения: 0.00013 сек.
(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/sale/lib/entityproperty.php:64
Bitrix\Main\ORM\Data\DataManager::getList(Array
(
)
)
(2.5)/home/bitrix/www/bitrix/modules/sale/lib/entitypropertyvalue.php:136
Bitrix\Sale\EntityProperty::getList(Array
(
)
)
(2.6)/home/bitrix/www/bitrix/modules/sale/lib/entitypropertyvalue.php:942
Bitrix\Sale\EntityPropertyValue::loadFromDb(Array
(
)
)
(2.7)/home/bitrix/www/bitrix/modules/sale/lib/entitypropertyvaluecollection.php:527
Bitrix\Sale\EntityPropertyValue::loadForEntity(Array
(
)
)
(2.8)/home/bitrix/www/bitrix/modules/sale/lib/order.php:949
Bitrix\Sale\EntityPropertyValueCollection->refreshRelated(Array
(
)
)
Время выполнения: 0.0002 сек.
Запрос № 14:
SELECT `sale_internals_order_props_relation`.`PROPERTY_ID` AS `PROPERTY_ID`, `sale_internals_order_props_relation`.`ENTITY_ID` AS `ENTITY_ID`, `sale_internals_order_props_relation`.`ENTITY_TYPE` AS `ENTITY_TYPE`
FROM
`b_sale_order_props_relation` `sale_internals_order_props_relation`
WHERE
(`sale_internals_order_props_relation`.`PROPERTY_ID` in (1, 27, 28, 2, 3, 4, 6, 5, 7))
Откуда вызван:
(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/entitypropertyvalue.php:154
Bitrix\Main\ORM\Data\DataManager::getList(Array
(
)
)
(1.5)/home/bitrix/www/bitrix/modules/sale/lib/entitypropertyvalue.php:942
Bitrix\Sale\EntityPropertyValue::loadFromDb(Array
(
)
)
(1.6)/home/bitrix/www/bitrix/modules/sale/lib/entitypropertyvaluecollection.php:527
Bitrix\Sale\EntityPropertyValue::loadForEntity(Array
(
)
)
(1.7)/home/bitrix/www/bitrix/modules/sale/lib/order.php:174
Bitrix\Sale\EntityPropertyValueCollection->refreshRelated(Array
(
)
)
(1.8)/home/bitrix/www/bitrix/modules/sale/lib/shipmentcollection.php:142
Bitrix\Sale\Order->onShipmentCollectionModify(Array
(
)
)
Время выполнения: 0.00012 сек.
(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/sale/lib/entitypropertyvalue.php:154
Bitrix\Main\ORM\Data\DataManager::getList(Array
(
)
)
(2.5)/home/bitrix/www/bitrix/modules/sale/lib/entitypropertyvalue.php:942
Bitrix\Sale\EntityPropertyValue::loadFromDb(Array
(
)
)
(2.6)/home/bitrix/www/bitrix/modules/sale/lib/entitypropertyvaluecollection.php:527
Bitrix\Sale\EntityPropertyValue::loadForEntity(Array
(
)
)
(2.7)/home/bitrix/www/bitrix/modules/sale/lib/order.php:949
Bitrix\Sale\EntityPropertyValueCollection->refreshRelated(Array
(
)
)
(2.8)/home/bitrix/www/bitrix/modules/sale/lib/paymentcollection.php:55
Bitrix\Sale\Order->onPaymentCollectionModify(Array
(
)
)
Время выполнения: 7.0E-5 сек.
Запрос № 15:
SELECT `sale_internals_payment_pay_system_available`.`PAY_SYSTEM_ID` AS `PAY_SYSTEM_ID`, `sale_internals_payment_pay_system_available`.`ID` AS `UALIAS_0`
FROM
`b_sale_order_payment_ps_available` `sale_internals_payment_pay_system_available`
WHERE
(`sale_internals_payment_pay_system_available`.`PAYMENT_ID` IS NULL OR `sale_internals_payment_pay_system_available`.`PAYMENT_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/paysystem/paymentavailablespaysystems.php:134
Bitrix\Main\ORM\Data\DataManager::getList(Array
(
)
)
(1.5)/home/bitrix/www/bitrix/modules/sale/lib/paysystem/manager.php:373
Bitrix\Sale\PaySystem\PaymentAvailablesPaySystems::getAvailablePaySystemIdsByPaymentId(Array
(
)
)
(1.6)/home/bitrix/www/bitrix/components/bitrix/sale.account.pay/class.php:229
Bitrix\Sale\PaySystem\Manager::getListWithRestrictions(Array
(
)
)
(1.7)/home/bitrix/www/bitrix/components/bitrix/sale.account.pay/class.php:258
SaleAccountPay->getListPaySystems(Array
(
)
)
(1.8)/home/bitrix/www/bitrix/components/bitrix/sale.account.pay/class.php:350
SaleAccountPay->fillArrayResult(Array
(
)
)
Время выполнения: 0.00014 сек.
Запрос № 16:
SELECT `sale_internals_pay_system_action`.`ID` AS `ID`, `sale_internals_pay_system_action`.`PAY_SYSTEM_ID` AS `PAY_SYSTEM_ID`, `sale_internals_pay_system_action`.`PERSON_TYPE_ID` AS `PERSON_TYPE_ID`, `sale_internals_pay_system_action`.`NAME` AS `NAME`, `sale_internals_pay_system_action`.`PSA_NAME` AS `PSA_NAME`, `sale_internals_pay_system_action`.`CODE` AS `CODE`, `sale_internals_pay_system_action`.`SORT` AS `SORT`, `sale_internals_pay_system_action`.`ACTION_FILE` AS `ACTION_FILE`, `sale_internals_pay_system_action`.`RESULT_FILE` AS `RESULT_FILE`, `sale_internals_pay_system_action`.`DESCRIPTION` AS `DESCRIPTION`, `sale_internals_pay_system_action`.`NEW_WINDOW` AS `NEW_WINDOW`, `sale_internals_pay_system_action`.`PARAMS` AS `PARAMS`, `sale_internals_pay_system_action`.`TARIF` AS `TARIF`, `sale_internals_pay_system_action`.`PS_MODE` AS `PS_MODE`, `sale_internals_pay_system_action`.`PS_CLIENT_TYPE` AS `PS_CLIENT_TYPE`, `sale_internals_pay_system_action`.`HAVE_PAYMENT` AS `HAVE_PAYMENT`, `sale_internals_pay_system_action`.`HAVE_ACTION` AS `HAVE_ACTION`, `sale_internals_pay_system_action`.`HAVE_RESULT` AS `HAVE_RESULT`, `sale_internals_pay_system_action`.`HAVE_PREPAY` AS `HAVE_PREPAY`, `sale_internals_pay_system_action`.`HAVE_PRICE` AS `HAVE_PRICE`, `sale_internals_pay_system_action`.`HAVE_RESULT_RECEIVE` AS `HAVE_RESULT_RECEIVE`, `sale_internals_pay_system_action`.`ENCODING` AS `ENCODING`, `sale_internals_pay_system_action`.`LOGOTIP` AS `LOGOTIP`, `sale_internals_pay_system_action`.`ACTIVE` AS `ACTIVE`, `sale_internals_pay_system_action`.`ALLOW_EDIT_PAYMENT` AS `ALLOW_EDIT_PAYMENT`, `sale_internals_pay_system_action`.`IS_CASH` AS `IS_CASH`, `sale_internals_pay_system_action`.`AUTO_CHANGE_1C` AS `AUTO_CHANGE_1C`, `sale_internals_pay_system_action`.`CAN_PRINT_CHECK` AS `CAN_PRINT_CHECK`, `sale_internals_pay_system_action`.`ENTITY_REGISTRY_TYPE` AS `ENTITY_REGISTRY_TYPE`, `sale_internals_pay_system_action`.`XML_ID` AS `XML_ID`
FROM
`b_sale_pay_system_action` `sale_internals_pay_system_action`
WHERE
`sale_internals_pay_system_action`.`ACTIVE` = 'Y' AND `sale_internals_pay_system_action`.`ENTITY_REGISTRY_TYPE` = 'ORDER'
ORDER BY
`SORT` ASC, `NAME` 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/lib/paysystem/manager.php:84
Bitrix\Main\ORM\Data\DataManager::getList(Array
(
)
)
(1.5)/home/bitrix/www/bitrix/modules/sale/lib/paysystem/manager.php:381
Bitrix\Sale\PaySystem\Manager::getList(Array
(
)
)
(1.6)/home/bitrix/www/bitrix/components/bitrix/sale.account.pay/class.php:229
Bitrix\Sale\PaySystem\Manager::getListWithRestrictions(Array
(
)
)
(1.7)/home/bitrix/www/bitrix/components/bitrix/sale.account.pay/class.php:258
SaleAccountPay->getListPaySystems(Array
(
)
)
(1.8)/home/bitrix/www/bitrix/components/bitrix/sale.account.pay/class.php:350
SaleAccountPay->fillArrayResult(Array
(
)
)
Время выполнения: 0.00011 сек.
Запрос № 17:
SELECT `sale_internals_service_restriction`.`ID` AS `ID`, `sale_internals_service_restriction`.`SERVICE_ID` AS `SERVICE_ID`, `sale_internals_service_restriction`.`SERVICE_TYPE` AS `SERVICE_TYPE`, `sale_internals_service_restriction`.`SORT` AS `SORT`, `sale_internals_service_restriction`.`CLASS_NAME` AS `CLASS_NAME`, `sale_internals_service_restriction`.`PARAMS` AS `PARAMS`
FROM
`b_sale_service_rstr` `sale_internals_service_restriction`
WHERE
`sale_internals_service_restriction`.`SERVICE_TYPE` = 1
ORDER BY
`SORT` 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/lib/services/base/restrictionmanager.php:162
Bitrix\Main\ORM\Data\DataManager::getList(Array
(
)
)
(1.5)/home/bitrix/www/bitrix/modules/sale/lib/services/base/restrictionmanager.php:118
Bitrix\Sale\Services\Base\RestrictionManager::getRestrictionsList(Array
(
)
)
(1.6)/home/bitrix/www/bitrix/modules/sale/lib/paysystem/manager.php:408
Bitrix\Sale\Services\Base\RestrictionManager::checkService(Array
(
)
)
(1.7)/home/bitrix/www/bitrix/components/bitrix/sale.account.pay/class.php:229
Bitrix\Sale\PaySystem\Manager::getListWithRestrictions(Array
(
)
)
(1.8)/home/bitrix/www/bitrix/components/bitrix/sale.account.pay/class.php:258
SaleAccountPay->getListPaySystems(Array
(
)
)
Время выполнения: 0.00014 сек.
Запрос № 18:
SELECT f.*, DATE_FORMAT(f.TIMESTAMP_X, '%d.%m.%Y %H:%i:%s') as TIMESTAMP_X, '' as VERSION_ORIGINAL_ID, '' as META
FROM
b_file f
WHERE
f.ID >= 680 AND f.ID <= 689 UNION SELECT f.*, DATE_FORMAT(f.TIMESTAMP_X, '%d.%m.%Y %H:%i:%s') as TIMESTAMP_X, fv.ORIGINAL_ID as VERSION_ORIGINAL_ID, fv.META as META
FROM
b_file f
INNER JOIN b_file_version fv ON fv.VERSION_ID = f.ID
WHERE
fv.ORIGINAL_ID >= 680 AND fv.ORIGINAL_ID <= 689
ORDER BY
ID
Откуда вызван:
(1.1)/home/bitrix/www/bitrix/modules/main/classes/general/file.php:1023
CDatabaseMysql->Query(...)
(1.2)/home/bitrix/www/bitrix/modules/main/classes/general/file.php:1052
CFile::GetFromCache(Array
(
)
)
(1.3)/home/bitrix/www/bitrix/modules/main/classes/general/file.php:1220
CFile::GetByID(Array
(
)
)
(1.4)/home/bitrix/www/bitrix/components/bitrix/sale.account.pay/class.php:266
CFile::GetFileArray(Array
(
)
)
(1.5)/home/bitrix/www/bitrix/components/bitrix/sale.account.pay/class.php:350
SaleAccountPay->fillArrayResult(Array
(
)
)
(1.6)/home/bitrix/www/bitrix/modules/main/classes/general/component.php:660
SaleAccountPay->executeComponent(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/components/bitrix/sale.personal.section/bxr-market/account.php:40
CAllMain->IncludeComponent(Array
(
)
)
Время выполнения: 0.00068 сек.
Запрос № 19:
SELECT f.*, DATE_FORMAT(f.TIMESTAMP_X, '%d.%m.%Y %H:%i:%s') as TIMESTAMP_X, '' as VERSION_ORIGINAL_ID, '' as META
FROM
b_file f
WHERE
f.ID >= 820 AND f.ID <= 829 UNION SELECT f.*, DATE_FORMAT(f.TIMESTAMP_X, '%d.%m.%Y %H:%i:%s') as TIMESTAMP_X, fv.ORIGINAL_ID as VERSION_ORIGINAL_ID, fv.META as META
FROM
b_file f
INNER JOIN b_file_version fv ON fv.VERSION_ID = f.ID
WHERE
fv.ORIGINAL_ID >= 820 AND fv.ORIGINAL_ID <= 829
ORDER BY
ID
Откуда вызван:
(1.1)/home/bitrix/www/bitrix/modules/main/classes/general/file.php:1023
CDatabaseMysql->Query(...)
(1.2)/home/bitrix/www/bitrix/modules/main/classes/general/file.php:1052
CFile::GetFromCache(Array
(
)
)
(1.3)/home/bitrix/www/bitrix/modules/main/classes/general/file.php:1220
CFile::GetByID(Array
(
)
)
(1.4)/home/bitrix/www/bitrix/components/bitrix/sale.account.pay/class.php:266
CFile::GetFileArray(Array
(
)
)
(1.5)/home/bitrix/www/bitrix/components/bitrix/sale.account.pay/class.php:350
SaleAccountPay->fillArrayResult(Array
(
)
)
(1.6)/home/bitrix/www/bitrix/modules/main/classes/general/component.php:660
SaleAccountPay->executeComponent(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/components/bitrix/sale.personal.section/bxr-market/account.php:40
CAllMain->IncludeComponent(Array
(
)
)
Время выполнения: 9.0E-5 сек.
