Запит No 1:
SELECT `main_numerator_model_numerator`.`ID` AS `ID`, `main_numerator_model_numerator`.`NAME` AS `NAME`, `main_numerator_model_numerator`.`TEMPLATE` AS `TEMPLATE`, `main_numerator_model_numerator`.`SETTINGS` AS `SETTINGS`, `main_numerator_model_numerator`.`TYPE` AS `TYPE`, `main_numerator_model_numerator`.`CREATED_AT` AS `CREATED_AT`, `main_numerator_model_numerator`.`CREATED_BY` AS `CREATED_BY`, `main_numerator_model_numerator`.`UPDATED_AT` AS `UPDATED_AT`, `main_numerator_model_numerator`.`UPDATED_BY` AS `UPDATED_BY`, `main_numerator_model_numerator`.`CODE` AS `CODE`
FROM
`b_numerator` `main_numerator_model_numerator`
WHERE
`main_numerator_model_numerator`.`TYPE` = 'ORDER'
Звідки викликаний:
(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/numerator/model/numerator.php:146
Bitrix\Main\ORM\Data\DataManager::getList(Array
(
)
)
(1.5)/home/bitrix/www/bitrix/modules/main/lib/numerator/numerator.php:163
Bitrix\Main\Numerator\Model\NumeratorTable::getNumeratorList(Array
(
)
)
(1.6)/home/bitrix/www/bitrix/modules/main/lib/numerator/numerator.php:180
Bitrix\Main\Numerator\Numerator::getListByType(Array
(
)
)
(1.7)/home/bitrix/www/bitrix/modules/sale/lib/integration/numerator/numeratororder.php:20
Bitrix\Main\Numerator\Numerator::getOneByType(Array
(
)
)
(1.8)/home/bitrix/www/bitrix/components/bitrix/sale.personal.order.detail/class.php:367
Bitrix\Sale\Integration\Numerator\NumeratorOrder::isUsedNumeratorForOrder(Array
(
)
)
Час виконання: 0.00216 сек.
Запит No 2:
SELECT `sale_internals_order`.`ID` AS `ID`, `sale_internals_order`.`LID` AS `LID`, `sale_internals_order`.`ACCOUNT_NUMBER` AS `ACCOUNT_NUMBER`, `sale_internals_order`.`TRACKING_NUMBER` AS `TRACKING_NUMBER`, `sale_internals_order`.`PAY_SYSTEM_ID` AS `PAY_SYSTEM_ID`, `sale_internals_order`.`DELIVERY_ID` AS `DELIVERY_ID`, `sale_internals_order`.`DATE_INSERT` AS `DATE_INSERT`, `sale_internals_order`.`DATE_UPDATE` AS `DATE_UPDATE`, `sale_internals_order`.`PERSON_TYPE_ID` AS `PERSON_TYPE_ID`, `sale_internals_order`.`USER_ID` AS `USER_ID`, `sale_internals_order`.`PAYED` AS `PAYED`, `sale_internals_order`.`IS_SYNC_B24` AS `IS_SYNC_B24`, `sale_internals_order`.`DATE_PAYED` AS `DATE_PAYED`, `sale_internals_order`.`EMP_PAYED_ID` AS `EMP_PAYED_ID`, `sale_internals_order`.`DEDUCTED` AS `DEDUCTED`, `sale_internals_order`.`DATE_DEDUCTED` AS `DATE_DEDUCTED`, `sale_internals_order`.`EMP_DEDUCTED_ID` AS `EMP_DEDUCTED_ID`, `sale_internals_order`.`REASON_UNDO_DEDUCTED` AS `REASON_UNDO_DEDUCTED`, `sale_internals_order`.`STATUS_ID` AS `STATUS_ID`, `sale_internals_order`.`DATE_STATUS` AS `DATE_STATUS`, `sale_internals_order`.`EMP_STATUS_ID` AS `EMP_STATUS_ID`, `sale_internals_order`.`MARKED` AS `MARKED`, `sale_internals_order`.`DATE_MARKED` AS `DATE_MARKED`, `sale_internals_order`.`EMP_MARKED_ID` AS `EMP_MARKED_ID`, `sale_internals_order`.`REASON_MARKED` AS `REASON_MARKED`, `sale_internals_order`.`PRICE_DELIVERY` AS `PRICE_DELIVERY`, `sale_internals_order`.`ALLOW_DELIVERY` AS `ALLOW_DELIVERY`, `sale_internals_order`.`DATE_ALLOW_DELIVERY` AS `DATE_ALLOW_DELIVERY`, `sale_internals_order`.`EMP_ALLOW_DELIVERY_ID` AS `EMP_ALLOW_DELIVERY_ID`, `sale_internals_order`.`RESERVED` AS `RESERVED`, `sale_internals_order`.`PRICE` AS `PRICE`, `sale_internals_order`.`CURRENCY` AS `CURRENCY`, `sale_internals_order`.`DISCOUNT_VALUE` AS `DISCOUNT_VALUE`, `sale_internals_order`.`TAX_VALUE` AS `TAX_VALUE`, `sale_internals_order`.`SUM_PAID` AS `SUM_PAID`, `sale_internals_order`.`USER_DESCRIPTION` AS `USER_DESCRIPTION`, `sale_internals_order`.`PAY_VOUCHER_NUM` AS `PAY_VOUCHER_NUM`, `sale_internals_order`.`PAY_VOUCHER_DATE` AS `PAY_VOUCHER_DATE`, `sale_internals_order`.`ADDITIONAL_INFO` AS `ADDITIONAL_INFO`, `sale_internals_order`.`COMMENTS` AS `COMMENTS`, `sale_internals_order`.`COMPANY_ID` AS `COMPANY_ID`, `sale_internals_order`.`CREATED_BY` AS `CREATED_BY`, `sale_internals_order`.`RESPONSIBLE_ID` AS `RESPONSIBLE_ID`, `sale_internals_order`.`STAT_GID` AS `STAT_GID`, `sale_internals_order`.`DATE_PAY_BEFORE` AS `DATE_PAY_BEFORE`, `sale_internals_order`.`DATE_BILL` AS `DATE_BILL`, `sale_internals_order`.`IS_RECURRING` AS `IS_RECURRING`, `sale_internals_order`.`RECURRING_ID` AS `RECURRING_ID`, `sale_internals_order`.`LOCKED_BY` AS `LOCKED_BY`, `sale_internals_order`.`DATE_LOCK` AS `DATE_LOCK`, `sale_internals_order`.`RECOUNT_FLAG` AS `RECOUNT_FLAG`, `sale_internals_order`.`AFFILIATE_ID` AS `AFFILIATE_ID`, `sale_internals_order`.`DELIVERY_DOC_NUM` AS `DELIVERY_DOC_NUM`, `sale_internals_order`.`DELIVERY_DOC_DATE` AS `DELIVERY_DOC_DATE`, `sale_internals_order`.`UPDATED_1C` AS `UPDATED_1C`, `sale_internals_order`.`ORDER_TOPIC` AS `ORDER_TOPIC`, `sale_internals_order`.`XML_ID` AS `XML_ID`, `sale_internals_order`.`ID_1C` AS `ID_1C`, `sale_internals_order`.`VERSION_1C` AS `VERSION_1C`, `sale_internals_order`.`VERSION` AS `VERSION`, `sale_internals_order`.`EXTERNAL_ORDER` AS `EXTERNAL_ORDER`, `sale_internals_order`.`STORE_ID` AS `STORE_ID`, `sale_internals_order`.`CANCELED` AS `CANCELED`, `sale_internals_order`.`EMP_CANCELED_ID` AS `EMP_CANCELED_ID`, `sale_internals_order`.`DATE_CANCELED` AS `DATE_CANCELED`, `sale_internals_order`.`REASON_CANCELED` AS `REASON_CANCELED`, `sale_internals_order`.`BX_USER_ID` AS `BX_USER_ID`, `sale_internals_order`.`SEARCH_CONTENT` AS `SEARCH_CONTENT`, `sale_internals_order`.`RUNNING` AS `RUNNING`
FROM
`b_sale_order` `sale_internals_order`
WHERE
`sale_internals_order`.`ID` = 163
Звідки викликаний:
(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/order.php:1929
Bitrix\Main\ORM\Data\DataManager::getList(Array
(
)
)
(1.5)/home/bitrix/www/bitrix/modules/sale/lib/orderbase.php:361
Bitrix\Sale\Order::getList(Array
(
)
)
(1.6)/home/bitrix/www/bitrix/modules/sale/lib/orderbase.php:282
Bitrix\Sale\OrderBase::loadFromDb(Array
(
)
)
(1.7)/home/bitrix/www/bitrix/modules/sale/lib/orderbase.php:258
Bitrix\Sale\OrderBase::loadByFilter(Array
(
)
)
(1.8)/home/bitrix/www/bitrix/components/bitrix/sale.personal.order.detail/class.php:1304
Bitrix\Sale\OrderBase::load(Array
(
)
)
Час виконання: 0.00316 сек.
Запит No 3:
SELECT `sale_internals_shipment`.`ID` AS `ID`, `sale_internals_shipment`.`ORDER_ID` AS `ORDER_ID`, `sale_internals_shipment`.`ACCOUNT_NUMBER` AS `ACCOUNT_NUMBER`, `sale_internals_shipment`.`DATE_INSERT` AS `DATE_INSERT`, `sale_internals_shipment`.`DATE_UPDATE` AS `DATE_UPDATE`, `sale_internals_shipment`.`STATUS_ID` AS `STATUS_ID`, `sale_internals_shipment`.`DELIVERY_LOCATION` AS `DELIVERY_LOCATION`, `sale_internals_shipment`.`BASE_PRICE_DELIVERY` AS `BASE_PRICE_DELIVERY`, `sale_internals_shipment`.`PRICE_DELIVERY` AS `PRICE_DELIVERY`, `sale_internals_shipment`.`WEIGHT` AS `WEIGHT`, `sale_internals_shipment`.`CUSTOM_PRICE_DELIVERY` AS `CUSTOM_PRICE_DELIVERY`, `sale_internals_shipment`.`CURRENCY` AS `CURRENCY`, `sale_internals_shipment`.`DISCOUNT_PRICE` AS `DISCOUNT_PRICE`, `sale_internals_shipment`.`ALLOW_DELIVERY` AS `ALLOW_DELIVERY`, `sale_internals_shipment`.`DATE_ALLOW_DELIVERY` AS `DATE_ALLOW_DELIVERY`, `sale_internals_shipment`.`EMP_ALLOW_DELIVERY_ID` AS `EMP_ALLOW_DELIVERY_ID`, `sale_internals_shipment`.`DEDUCTED` AS `DEDUCTED`, `sale_internals_shipment`.`DATE_DEDUCTED` AS `DATE_DEDUCTED`, `sale_internals_shipment`.`EMP_DEDUCTED_ID` AS `EMP_DEDUCTED_ID`, `sale_internals_shipment`.`REASON_UNDO_DEDUCTED` AS `REASON_UNDO_DEDUCTED`, `sale_internals_shipment`.`RESERVED` AS `RESERVED`, `sale_internals_shipment`.`DELIVERY_ID` AS `DELIVERY_ID`, `sale_internals_shipment`.`DELIVERY_DOC_NUM` AS `DELIVERY_DOC_NUM`, `sale_internals_shipment`.`DELIVERY_DOC_DATE` AS `DELIVERY_DOC_DATE`, `sale_internals_shipment`.`TRACKING_NUMBER` AS `TRACKING_NUMBER`, `sale_internals_shipment`.`TRACKING_STATUS` AS `TRACKING_STATUS`, `sale_internals_shipment`.`TRACKING_DESCRIPTION` AS `TRACKING_DESCRIPTION`, `sale_internals_shipment`.`TRACKING_LAST_CHECK` AS `TRACKING_LAST_CHECK`, `sale_internals_shipment`.`TRACKING_LAST_CHANGE` AS `TRACKING_LAST_CHANGE`, `sale_internals_shipment`.`XML_ID` AS `XML_ID`, `sale_internals_shipment`.`PARAMS` AS `PARAMS`, `sale_internals_shipment`.`DELIVERY_NAME` AS `DELIVERY_NAME`, `sale_internals_shipment`.`CANCELED` AS `CANCELED`, `sale_internals_shipment`.`DATE_CANCELED` AS `DATE_CANCELED`, `sale_internals_shipment`.`EMP_CANCELED_ID` AS `EMP_CANCELED_ID`, `sale_internals_shipment`.`REASON_CANCELED` AS `REASON_CANCELED`, `sale_internals_shipment`.`MARKED` AS `MARKED`, `sale_internals_shipment`.`DATE_MARKED` AS `DATE_MARKED`, `sale_internals_shipment`.`EMP_MARKED_ID` AS `EMP_MARKED_ID`, `sale_internals_shipment`.`REASON_MARKED` AS `REASON_MARKED`, `sale_internals_shipment`.`SYSTEM` AS `SYSTEM`, `sale_internals_shipment`.`RESPONSIBLE_ID` AS `RESPONSIBLE_ID`, `sale_internals_shipment`.`EMP_RESPONSIBLE_ID` AS `EMP_RESPONSIBLE_ID`, `sale_internals_shipment`.`DATE_RESPONSIBLE_ID` AS `DATE_RESPONSIBLE_ID`, `sale_internals_shipment`.`COMMENTS` AS `COMMENTS`, `sale_internals_shipment`.`COMPANY_ID` AS `COMPANY_ID`, `sale_internals_shipment`.`UPDATED_1C` AS `UPDATED_1C`, `sale_internals_shipment`.`ID_1C` AS `ID_1C`, `sale_internals_shipment`.`VERSION_1C` AS `VERSION_1C`, `sale_internals_shipment`.`EXTERNAL_DELIVERY` AS `EXTERNAL_DELIVERY`
FROM
`b_sale_order_delivery` `sale_internals_shipment`
WHERE
`sale_internals_shipment`.`ORDER_ID` = 163
ORDER BY
`SYSTEM` ASC, `DATE_INSERT` 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/shipment.php:2378
Bitrix\Main\ORM\Data\DataManager::getList(Array
(
)
)
(1.5)/home/bitrix/www/bitrix/modules/sale/lib/shipment.php:895
Bitrix\Sale\Shipment::getList(Array
(
)
)
(1.6)/home/bitrix/www/bitrix/modules/sale/lib/shipmentcollection.php:230
Bitrix\Sale\Shipment::loadForOrder(Array
(
)
)
(1.7)/home/bitrix/www/bitrix/modules/sale/lib/order.php:814
Bitrix\Sale\ShipmentCollection::load(Array
(
)
)
(1.8)/home/bitrix/www/bitrix/modules/sale/lib/order.php:762
Bitrix\Sale\Order->loadShipmentCollection(Array
(
)
)
Час виконання: 0.00319 сек.
Запит No 4:
SELECT `sale_internals_custom_fields`.`FIELD` AS `FIELD`, `sale_internals_custom_fields`.`ENTITY_ID` AS `ENTITY_ID`, `sale_internals_custom_fields`.`ID` AS `UALIAS_0`
FROM
`b_sale_order_entities_custom_fields` `sale_internals_custom_fields`
WHERE
`sale_internals_custom_fields`.`ENTITY_ID` IN (326,325) AND `sale_internals_custom_fields`.`ENTITY_TYPE` = 'SHIPMENT' AND `sale_internals_custom_fields`.`ENTITY_REGISTRY_TYPE` = 'ORDER'
Звідки викликаний:
(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/customfieldscontroller.php:138
Bitrix\Main\ORM\Data\DataManager::getList(Array
(
)
)
(1.5)/home/bitrix/www/bitrix/modules/sale/lib/shipmentcollection.php:239
Bitrix\Sale\Internals\CustomFieldsController->initializeCollection(Array
(
)
)
(1.6)/home/bitrix/www/bitrix/modules/sale/lib/order.php:814
Bitrix\Sale\ShipmentCollection::load(Array
(
)
)
(1.7)/home/bitrix/www/bitrix/modules/sale/lib/order.php:762
Bitrix\Sale\Order->loadShipmentCollection(Array
(
)
)
(1.8)/home/bitrix/www/bitrix/components/bitrix/sale.personal.order.detail/class.php:1349
Bitrix\Sale\Order->getShipmentCollection(Array
(
)
)
Час виконання: 9.0E-5 сек.
Запит No 5:
SELECT `sale_internals_shipment_item`.`ID` AS `ID`, `sale_internals_shipment_item`.`ORDER_DELIVERY_ID` AS `ORDER_DELIVERY_ID`, `sale_internals_shipment_item`.`BASKET_ID` AS `BASKET_ID`, `sale_internals_shipment_item`.`DATE_INSERT` AS `DATE_INSERT`, `sale_internals_shipment_item`.`QUANTITY` AS `QUANTITY`, `sale_internals_shipment_item`.`RESERVED_QUANTITY` AS `RESERVED_QUANTITY`, `sale_internals_shipment_item`.`XML_ID` AS `XML_ID`, `sale_internals_shipment_item_basket`.`ID` AS `UALIAS_0`
FROM
`b_sale_order_dlv_basket` `sale_internals_shipment_item`
LEFT JOIN `b_sale_basket` `sale_internals_shipment_item_basket` ON `sale_internals_shipment_item`.`BASKET_ID` = `sale_internals_shipment_item_basket`.`ID`
WHERE
`sale_internals_shipment_item`.`ORDER_DELIVERY_ID` = 326 AND (`sale_internals_shipment_item_basket`.`ID` IS NOT NULL AND `sale_internals_shipment_item_basket`.`ID` <> 0)
ORDER BY
`DATE_INSERT` 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/shipmentitem.php:1177
Bitrix\Main\ORM\Data\DataManager::getList(Array
(
)
)
(1.5)/home/bitrix/www/bitrix/modules/sale/lib/shipmentitem.php:820
Bitrix\Sale\ShipmentItem::getList(Array
(
)
)
(1.6)/home/bitrix/www/bitrix/modules/sale/lib/shipmentitemcollection.php:663
Bitrix\Sale\ShipmentItem::loadForShipment(Array
(
)
)
(1.7)/home/bitrix/www/bitrix/modules/sale/lib/shipment.php:1227
Bitrix\Sale\ShipmentItemCollection::load(Array
(
)
)
(1.8)/home/bitrix/www/bitrix/components/bitrix/sale.personal.order.detail/class.php:1360
Bitrix\Sale\Shipment->getShipmentItemCollection(Array
(
)
)
Час виконання: 0.00632 сек.
Запит No 6:
SELECT `sale_internals_basket`.`ID` AS `ID`, `sale_internals_basket`.`LID` AS `LID`, `sale_internals_basket`.`MODULE` AS `MODULE`, `sale_internals_basket`.`PRODUCT_ID` AS `PRODUCT_ID`, `sale_internals_basket`.`QUANTITY` AS `QUANTITY`, `sale_internals_basket`.`WEIGHT` AS `WEIGHT`, `sale_internals_basket`.`DELAY` AS `DELAY`, `sale_internals_basket`.`CAN_BUY` AS `CAN_BUY`, `sale_internals_basket`.`PRICE` AS `PRICE`, `sale_internals_basket`.`CUSTOM_PRICE` AS `CUSTOM_PRICE`, `sale_internals_basket`.`BASE_PRICE` AS `BASE_PRICE`, `sale_internals_basket`.`PRODUCT_PRICE_ID` AS `PRODUCT_PRICE_ID`, `sale_internals_basket`.`PRICE_TYPE_ID` AS `PRICE_TYPE_ID`, `sale_internals_basket`.`CURRENCY` AS `CURRENCY`, `sale_internals_basket`.`BARCODE_MULTI` AS `BARCODE_MULTI`, `sale_internals_basket`.`RESERVED` AS `RESERVED`, `sale_internals_basket`.`RESERVE_QUANTITY` AS `RESERVE_QUANTITY`, `sale_internals_basket`.`NAME` AS `NAME`, `sale_internals_basket`.`CATALOG_XML_ID` AS `CATALOG_XML_ID`, `sale_internals_basket`.`VAT_RATE` AS `VAT_RATE`, `sale_internals_basket`.`NOTES` AS `NOTES`, `sale_internals_basket`.`DISCOUNT_PRICE` AS `DISCOUNT_PRICE`, `sale_internals_basket`.`PRODUCT_PROVIDER_CLASS` AS `PRODUCT_PROVIDER_CLASS`, `sale_internals_basket`.`CALLBACK_FUNC` AS `CALLBACK_FUNC`, `sale_internals_basket`.`ORDER_CALLBACK_FUNC` AS `ORDER_CALLBACK_FUNC`, `sale_internals_basket`.`PAY_CALLBACK_FUNC` AS `PAY_CALLBACK_FUNC`, `sale_internals_basket`.`CANCEL_CALLBACK_FUNC` AS `CANCEL_CALLBACK_FUNC`, `sale_internals_basket`.`DIMENSIONS` AS `DIMENSIONS`, `sale_internals_basket`.`TYPE` AS `TYPE`, `sale_internals_basket`.`SET_PARENT_ID` AS `SET_PARENT_ID`, `sale_internals_basket`.`DETAIL_PAGE_URL` AS `DETAIL_PAGE_URL`, `sale_internals_basket`.`FUSER_ID` AS `FUSER_ID`, `sale_internals_basket`.`MEASURE_CODE` AS `MEASURE_CODE`, `sale_internals_basket`.`MEASURE_NAME` AS `MEASURE_NAME`, `sale_internals_basket`.`ORDER_ID` AS `ORDER_ID`, `sale_internals_basket`.`DATE_INSERT` AS `DATE_INSERT`, `sale_internals_basket`.`DATE_UPDATE` AS `DATE_UPDATE`, `sale_internals_basket`.`PRODUCT_XML_ID` AS `PRODUCT_XML_ID`, `sale_internals_basket`.`SUBSCRIBE` AS `SUBSCRIBE`, `sale_internals_basket`.`RECOMMENDATION` AS `RECOMMENDATION`, `sale_internals_basket`.`VAT_INCLUDED` AS `VAT_INCLUDED`, `sale_internals_basket`.`SORT` AS `SORT`, `sale_internals_basket`.`DATE_REFRESH` AS `DATE_REFRESH`, `sale_internals_basket`.`DISCOUNT_NAME` AS `DISCOUNT_NAME`, `sale_internals_basket`.`DISCOUNT_VALUE` AS `DISCOUNT_VALUE`, `sale_internals_basket`.`DISCOUNT_COUPON` AS `DISCOUNT_COUPON`, `sale_internals_basket`.`XML_ID` AS `XML_ID`, `sale_internals_basket`.`MARKING_CODE_GROUP` AS `MARKING_CODE_GROUP`
FROM
`b_sale_basket` `sale_internals_basket`
WHERE
`sale_internals_basket`.`ORDER_ID` = 163
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/sale/lib/basket.php:39
Bitrix\Main\ORM\Data\DataManager::getList(Array
(
)
)
(1.5)/home/bitrix/www/bitrix/modules/sale/lib/basketbase.php:132
Bitrix\Sale\Basket::getList(Array
(
)
)
(1.6)/home/bitrix/www/bitrix/modules/sale/lib/basketbase.php:1068
Bitrix\Sale\BasketBase->loadFromDb(Array
(
)
)
(1.7)/home/bitrix/www/bitrix/modules/sale/lib/orderbase.php:440
Bitrix\Sale\BasketBase::loadItemsForOrder(Array
(
)
)
(1.8)/home/bitrix/www/bitrix/modules/sale/lib/orderbase.php:419
Bitrix\Sale\OrderBase->loadBasket(Array
(
)
)
Час виконання: 0.01158 сек.
Запит No 7:
SELECT `sale_internals_custom_fields`.`FIELD` AS `FIELD`, `sale_internals_custom_fields`.`ENTITY_ID` AS `ENTITY_ID`, `sale_internals_custom_fields`.`ID` AS `UALIAS_0`
FROM
`b_sale_order_entities_custom_fields` `sale_internals_custom_fields`
WHERE
`sale_internals_custom_fields`.`ENTITY_ID` IN (1892,1893) AND `sale_internals_custom_fields`.`ENTITY_TYPE` = 'BASKET_ITEM' AND `sale_internals_custom_fields`.`ENTITY_REGISTRY_TYPE` = 'ORDER'
Звідки викликаний:
(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/customfieldscontroller.php:138
Bitrix\Main\ORM\Data\DataManager::getList(Array
(
)
)
(1.5)/home/bitrix/www/bitrix/modules/sale/lib/basketitemcollection.php:90
Bitrix\Sale\Internals\CustomFieldsController->initializeCollection(Array
(
)
)
(1.6)/home/bitrix/www/bitrix/modules/sale/lib/basketbase.php:165
Bitrix\Sale\BasketItemCollection->loadFromArray(Array
(
)
)
(1.7)/home/bitrix/www/bitrix/modules/sale/lib/basketbase.php:1068
Bitrix\Sale\BasketBase->loadFromDb(Array
(
)
)
(1.8)/home/bitrix/www/bitrix/modules/sale/lib/orderbase.php:440
Bitrix\Sale\BasketBase::loadItemsForOrder(Array
(
)
)
Час виконання: 0.00086 сек.
Запит No 8:
SELECT `sale_internals_payment`.`ID` AS `ID`, `sale_internals_payment`.`ORDER_ID` AS `ORDER_ID`, `sale_internals_payment`.`ACCOUNT_NUMBER` AS `ACCOUNT_NUMBER`, `sale_internals_payment`.`PAID` AS `PAID`, `sale_internals_payment`.`DATE_PAID` AS `DATE_PAID`, `sale_internals_payment`.`EMP_PAID_ID` AS `EMP_PAID_ID`, `sale_internals_payment`.`PAY_SYSTEM_ID` AS `PAY_SYSTEM_ID`, `sale_internals_payment`.`PS_STATUS` AS `PS_STATUS`, `sale_internals_payment`.`PS_STATUS_CODE` AS `PS_STATUS_CODE`, `sale_internals_payment`.`PS_INVOICE_ID` AS `PS_INVOICE_ID`, `sale_internals_payment`.`PS_STATUS_DESCRIPTION` AS `PS_STATUS_DESCRIPTION`, `sale_internals_payment`.`PS_STATUS_MESSAGE` AS `PS_STATUS_MESSAGE`, `sale_internals_payment`.`PS_SUM` AS `PS_SUM`, `sale_internals_payment`.`PS_CURRENCY` AS `PS_CURRENCY`, `sale_internals_payment`.`PS_RESPONSE_DATE` AS `PS_RESPONSE_DATE`, `sale_internals_payment`.`PS_RECURRING_TOKEN` AS `PS_RECURRING_TOKEN`, `sale_internals_payment`.`PS_CARD_NUMBER` AS `PS_CARD_NUMBER`, `sale_internals_payment`.`PAY_VOUCHER_NUM` AS `PAY_VOUCHER_NUM`, `sale_internals_payment`.`PAY_VOUCHER_DATE` AS `PAY_VOUCHER_DATE`, `sale_internals_payment`.`DATE_PAY_BEFORE` AS `DATE_PAY_BEFORE`, `sale_internals_payment`.`DATE_BILL` AS `DATE_BILL`, `sale_internals_payment`.`XML_ID` AS `XML_ID`, `sale_internals_payment`.`SUM` AS `SUM`, `sale_internals_payment`.`PRICE_COD` AS `PRICE_COD`, `sale_internals_payment`.`CURRENCY` AS `CURRENCY`, `sale_internals_payment`.`PAY_SYSTEM_NAME` AS `PAY_SYSTEM_NAME`, `sale_internals_payment`.`RESPONSIBLE_ID` AS `RESPONSIBLE_ID`, `sale_internals_payment`.`EMP_RESPONSIBLE_ID` AS `EMP_RESPONSIBLE_ID`, `sale_internals_payment`.`DATE_RESPONSIBLE_ID` AS `DATE_RESPONSIBLE_ID`, `sale_internals_payment`.`COMMENTS` AS `COMMENTS`, `sale_internals_payment`.`COMPANY_ID` AS `COMPANY_ID`, `sale_internals_payment`.`PAY_RETURN_NUM` AS `PAY_RETURN_NUM`, `sale_internals_payment`.`PAY_RETURN_DATE` AS `PAY_RETURN_DATE`, `sale_internals_payment`.`EMP_RETURN_ID` AS `EMP_RETURN_ID`, `sale_internals_payment`.`PAY_RETURN_COMMENT` AS `PAY_RETURN_COMMENT`, `sale_internals_payment`.`IS_RETURN` AS `IS_RETURN`, `sale_internals_payment`.`MARKED` AS `MARKED`, `sale_internals_payment`.`DATE_MARKED` AS `DATE_MARKED`, `sale_internals_payment`.`EMP_MARKED_ID` AS `EMP_MARKED_ID`, `sale_internals_payment`.`REASON_MARKED` AS `REASON_MARKED`, `sale_internals_payment`.`UPDATED_1C` AS `UPDATED_1C`, `sale_internals_payment`.`ID_1C` AS `ID_1C`, `sale_internals_payment`.`VERSION_1C` AS `VERSION_1C`, `sale_internals_payment`.`EXTERNAL_PAYMENT` AS `EXTERNAL_PAYMENT`
FROM
`b_sale_order_payment` `sale_internals_payment`
WHERE
`sale_internals_payment`.`ORDER_ID` = 163
Звідки викликаний:
(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/payment.php:1221
Bitrix\Main\ORM\Data\DataManager::getList(Array
(
)
)
(1.5)/home/bitrix/www/bitrix/modules/sale/lib/payment.php:240
Bitrix\Sale\Payment::getList(Array
(
)
)
(1.6)/home/bitrix/www/bitrix/modules/sale/lib/paymentcollection.php:287
Bitrix\Sale\Payment::loadForOrder(Array
(
)
)
(1.7)/home/bitrix/www/bitrix/modules/sale/lib/order.php:829
Bitrix\Sale\PaymentCollection::load(Array
(
)
)
(1.8)/home/bitrix/www/bitrix/modules/sale/lib/order.php:795
Bitrix\Sale\Order->loadPaymentCollection(Array
(
)
)
Час виконання: 0.02277 сек.
Запит No 9:
SELECT `sale_cashbox_internals_cashbox`.`ID` AS `ID`, `sale_cashbox_internals_cashbox`.`NAME` AS `NAME`, `sale_cashbox_internals_cashbox`.`ACTIVE` AS `ACTIVE`, `sale_cashbox_internals_cashbox`.`HANDLER` AS `HANDLER`, `sale_cashbox_internals_cashbox`.`EMAIL` AS `EMAIL`, `sale_cashbox_internals_cashbox`.`SORT` AS `SORT`, `sale_cashbox_internals_cashbox`.`DATE_CREATE` AS `DATE_CREATE`, `sale_cashbox_internals_cashbox`.`DATE_LAST_CHECK` AS `DATE_LAST_CHECK`, `sale_cashbox_internals_cashbox`.`KKM_ID` AS `KKM_ID`, `sale_cashbox_internals_cashbox`.`OFD` AS `OFD`, `sale_cashbox_internals_cashbox`.`NUMBER_KKM` AS `NUMBER_KKM`, `sale_cashbox_internals_cashbox`.`SETTINGS` AS `SETTINGS`, `sale_cashbox_internals_cashbox`.`OFD_SETTINGS` AS `OFD_SETTINGS`, `sale_cashbox_internals_cashbox`.`USE_OFFLINE` AS `USE_OFFLINE`, `sale_cashbox_internals_cashbox`.`ENABLED` AS `ENABLED`
FROM
`b_sale_cashbox` `sale_cashbox_internals_cashbox`
Звідки викликаний:
(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/cashbox/manager.php:253
Bitrix\Main\ORM\Data\DataManager::getList(Array
(
)
)
(1.5)/home/bitrix/www/bitrix/modules/sale/lib/cashbox/manager.php:430
Bitrix\Sale\Cashbox\Manager::getListFromCache(Array
(
)
)
(1.6)/home/bitrix/www/bitrix/modules/sale/lib/cashbox/checkmanager.php:627
Bitrix\Sale\Cashbox\Manager::isSupportedFFD105(Array
(
)
)
(1.7)/home/bitrix/www/bitrix/modules/sale/lib/cashbox/checkmanager.php:707
Bitrix\Sale\Cashbox\CheckManager::getBuildInCheckList(Array
(
)
)
(1.8)/home/bitrix/www/bitrix/modules/sale/lib/cashbox/checkmanager.php:734
Bitrix\Sale\Cashbox\CheckManager::getCheckList(Array
(
)
)
Час виконання: 0.01003 сек.
Запит No 10:
SELECT `sale_cashbox_internals_cashbox_check`.`ID` AS `ID`, `sale_cashbox_internals_cashbox_check`.`PAYMENT_ID` AS `PAYMENT_ID`, `sale_cashbox_internals_cashbox_check`.`SHIPMENT_ID` AS `SHIPMENT_ID`, `sale_cashbox_internals_cashbox_check`.`ORDER_ID` AS `ORDER_ID`, `sale_cashbox_internals_cashbox_check`.`EXTERNAL_UUID` AS `EXTERNAL_UUID`, `sale_cashbox_internals_cashbox_check`.`CASHBOX_ID` AS `CASHBOX_ID`, `sale_cashbox_internals_cashbox_check`.`CNT_FAIL_PRINT` AS `CNT_FAIL_PRINT`, `sale_cashbox_internals_cashbox_check`.`DATE_CREATE` AS `DATE_CREATE`, `sale_cashbox_internals_cashbox_check`.`DATE_PRINT_START` AS `DATE_PRINT_START`, `sale_cashbox_internals_cashbox_check`.`DATE_PRINT_END` AS `DATE_PRINT_END`, `sale_cashbox_internals_cashbox_check`.`SUM` AS `SUM`, `sale_cashbox_internals_cashbox_check`.`CURRENCY` AS `CURRENCY`, `sale_cashbox_internals_cashbox_check`.`LINK_PARAMS` AS `LINK_PARAMS`, `sale_cashbox_internals_cashbox_check`.`TYPE` AS `TYPE`, `sale_cashbox_internals_cashbox_check`.`STATUS` AS `STATUS`, `sale_cashbox_internals_cashbox_check`.`ENTITY_REGISTRY_TYPE` AS `ENTITY_REGISTRY_TYPE`, `sale_cashbox_internals_cashbox_check`.`ERROR_MESSAGE` AS `ERROR_MESSAGE`
FROM
`b_sale_cashbox_check` `sale_cashbox_internals_cashbox_check`
WHERE
UPPER(`sale_cashbox_internals_cashbox_check`.`ENTITY_REGISTRY_TYPE`) like upper('ORDER') AND `sale_cashbox_internals_cashbox_check`.`PAYMENT_ID` = 165
Звідки викликаний:
(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/cashbox/checkmanager.php:1526
Bitrix\Main\ORM\Data\DataManager::getList(Array
(
)
)
(1.5)/home/bitrix/www/bitrix/modules/sale/lib/cashbox/checkmanager.php:1453
Bitrix\Sale\Cashbox\CheckManager::getList(Array
(
)
)
(1.6)/home/bitrix/www/bitrix/modules/sale/lib/cashbox/checkmanager.php:1380
Bitrix\Sale\Cashbox\CheckManager::collectInfo(Array
(
)
)
(1.7)/home/bitrix/www/bitrix/components/bitrix/sale.personal.order.detail/class.php:1405
Bitrix\Sale\Cashbox\CheckManager::getCheckInfo(Array
(
)
)
(1.8)/home/bitrix/www/bitrix/components/bitrix/sale.personal.order.detail/class.php:1758
CBitrixPersonalOrderDetailComponent->obtainDataOrder(Array
(
)
)
Час виконання: 0.01427 сек.
Запит No 11:
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/orderstatus.php:91
Bitrix\Sale\OrderStatus::getAllowPayStatusList(Array
(
)
)
(1.8)/home/bitrix/www/bitrix/modules/sale/lib/orderbase.php:2323
Bitrix\Sale\OrderStatus::isAllowPay(Array
(
)
)
Час виконання: 0.00024 сек.
Запит No 12:
SELECT `main_user`.`ID` AS `ID`, `main_user`.`LOGIN` AS `LOGIN`, `main_user`.`EMAIL` AS `EMAIL`, `main_user`.`ACTIVE` AS `ACTIVE`, `main_user`.`BLOCKED` AS `BLOCKED`, `main_user`.`DATE_REGISTER` AS `DATE_REGISTER`, `main_user`.`LAST_LOGIN` AS `LAST_LOGIN`, `main_user`.`LAST_ACTIVITY_DATE` AS `LAST_ACTIVITY_DATE`, `main_user`.`TIMESTAMP_X` AS `TIMESTAMP_X`, `main_user`.`NAME` AS `NAME`, `main_user`.`SECOND_NAME` AS `SECOND_NAME`, `main_user`.`LAST_NAME` AS `LAST_NAME`, `main_user`.`TITLE` AS `TITLE`, `main_user`.`EXTERNAL_AUTH_ID` AS `EXTERNAL_AUTH_ID`, `main_user`.`XML_ID` AS `XML_ID`, `main_user`.`BX_USER_ID` AS `BX_USER_ID`, `main_user`.`CONFIRM_CODE` AS `CONFIRM_CODE`, `main_user`.`LID` AS `LID`, `main_user`.`LANGUAGE_ID` AS `LANGUAGE_ID`, `main_user`.`TIME_ZONE` AS `TIME_ZONE`, `main_user`.`TIME_ZONE_OFFSET` AS `TIME_ZONE_OFFSET`, `main_user`.`PERSONAL_PROFESSION` AS `PERSONAL_PROFESSION`, `main_user`.`PERSONAL_PHONE` AS `PERSONAL_PHONE`, `main_user`.`PERSONAL_MOBILE` AS `PERSONAL_MOBILE`, `main_user`.`PERSONAL_WWW` AS `PERSONAL_WWW`, `main_user`.`PERSONAL_ICQ` AS `PERSONAL_ICQ`, `main_user`.`PERSONAL_FAX` AS `PERSONAL_FAX`, `main_user`.`PERSONAL_PAGER` AS `PERSONAL_PAGER`, `main_user`.`PERSONAL_STREET` AS `PERSONAL_STREET`, `main_user`.`PERSONAL_MAILBOX` AS `PERSONAL_MAILBOX`, `main_user`.`PERSONAL_CITY` AS `PERSONAL_CITY`, `main_user`.`PERSONAL_STATE` AS `PERSONAL_STATE`, `main_user`.`PERSONAL_ZIP` AS `PERSONAL_ZIP`, `main_user`.`PERSONAL_COUNTRY` AS `PERSONAL_COUNTRY`, `main_user`.`PERSONAL_BIRTHDAY` AS `PERSONAL_BIRTHDAY`, `main_user`.`PERSONAL_GENDER` AS `PERSONAL_GENDER`, `main_user`.`PERSONAL_PHOTO` AS `PERSONAL_PHOTO`, `main_user`.`PERSONAL_NOTES` AS `PERSONAL_NOTES`, `main_user`.`WORK_COMPANY` AS `WORK_COMPANY`, `main_user`.`WORK_DEPARTMENT` AS `WORK_DEPARTMENT`, `main_user`.`WORK_PHONE` AS `WORK_PHONE`, `main_user`.`WORK_POSITION` AS `WORK_POSITION`, `main_user`.`WORK_WWW` AS `WORK_WWW`, `main_user`.`WORK_FAX` AS `WORK_FAX`, `main_user`.`WORK_PAGER` AS `WORK_PAGER`, `main_user`.`WORK_STREET` AS `WORK_STREET`, `main_user`.`WORK_MAILBOX` AS `WORK_MAILBOX`, `main_user`.`WORK_CITY` AS `WORK_CITY`, `main_user`.`WORK_STATE` AS `WORK_STATE`, `main_user`.`WORK_ZIP` AS `WORK_ZIP`, `main_user`.`WORK_COUNTRY` AS `WORK_COUNTRY`, `main_user`.`WORK_PROFILE` AS `WORK_PROFILE`, `main_user`.`WORK_LOGO` AS `WORK_LOGO`, `main_user`.`WORK_NOTES` AS `WORK_NOTES`, `main_user`.`ADMIN_NOTES` AS `ADMIN_NOTES`
FROM
`b_user` `main_user`
WHERE
`main_user`.`ID` = 1
Звідки викликаний:
(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/components/bitrix/sale.personal.order.detail/class.php:1431
Bitrix\Main\ORM\Data\DataManager::getById(Array
(
)
)
(1.7)/home/bitrix/www/bitrix/components/bitrix/sale.personal.order.detail/class.php:1759
CBitrixPersonalOrderDetailComponent->obtainDataUser(Array
(
)
)
(1.8)/home/bitrix/www/bitrix/components/bitrix/sale.personal.order.detail/class.php:2087
CBitrixPersonalOrderDetailComponent->obtainData(Array
(
)
)
Час виконання: 0.00323 сек.
Запит No 13:
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` = 8
Звідки викликаний:
(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/delivery/extra_services/manager.php:674
Bitrix\Sale\Delivery\Services\Manager::getById(Array
(
)
)
(1.6)/home/bitrix/www/bitrix/modules/sale/lib/delivery/extra_services/manager.php:543
Bitrix\Sale\Delivery\ExtraServices\Manager::getExtraServicesList(Array
(
)
)
(1.7)/home/bitrix/www/bitrix/modules/sale/lib/delivery/extra_services/manager.php:562
Bitrix\Sale\Delivery\ExtraServices\Manager::getStoresFields(Array
(
)
)
(1.8)/home/bitrix/www/bitrix/components/bitrix/sale.personal.order.detail/class.php:1563
Bitrix\Sale\Delivery\ExtraServices\Manager::getStoresList(Array
(
)
)
Час виконання: 0.00585 сек.
Запит No 14:
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 (8)) 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:543
Bitrix\Sale\Delivery\ExtraServices\Manager::getExtraServicesList(Array
(
)
)
(1.7)/home/bitrix/www/bitrix/modules/sale/lib/delivery/extra_services/manager.php:562
Bitrix\Sale\Delivery\ExtraServices\Manager::getStoresFields(Array
(
)
)
(1.8)/home/bitrix/www/bitrix/components/bitrix/sale.personal.order.detail/class.php:1563
Bitrix\Sale\Delivery\ExtraServices\Manager::getStoresList(Array
(
)
)
Час виконання: 0.0046 сек.
Запит No 15:
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`.`ID` = 1
Звідки викликаний:
(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:101
Bitrix\Sale\PaySystem\Manager::getList(Array
(
)
)
(1.6)/home/bitrix/www/bitrix/components/bitrix/sale.personal.order.detail/class.php:1477
Bitrix\Sale\PaySystem\Manager::getById(Array
(
)
)
(1.7)/home/bitrix/www/bitrix/components/bitrix/sale.personal.order.detail/class.php:1766
CBitrixPersonalOrderDetailComponent->obtainDataPaySystem(Array
(
)
)
(1.8)/home/bitrix/www/bitrix/components/bitrix/sale.personal.order.detail/class.php:2087
CBitrixPersonalOrderDetailComponent->obtainData(Array
(
)
)
Час виконання: 0.0009 сек.
Запит No 16:
SELECT `sale_internals_status`.`ID` AS `ID`, `sale_internals_status_status_lang_status`.`NAME` AS `NAME`, `sale_internals_status_status_lang_status`.`STATUS_ID` AS `UALIAS_0`, `sale_internals_status_status_lang_status`.`LID` AS `UALIAS_1`
FROM
`b_sale_status` `sale_internals_status`
INNER JOIN `b_sale_status_lang` `sale_internals_status_status_lang_status` ON `sale_internals_status_status_lang_status`.`STATUS_ID` = `sale_internals_status`.`ID`
WHERE
`sale_internals_status`.`TYPE` = 'D' AND ( `sale_internals_status`.`TYPE` = 'D' AND `sale_internals_status_status_lang_status`.`LID` = 'ua' )
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:310
Bitrix\Sale\StatusBase::getList(Array
(
)
)
(1.6)/home/bitrix/www/bitrix/components/bitrix/sale.personal.order.detail/class.php:1913
Bitrix\Sale\StatusBase::getAllStatusesNames(Array
(
)
)
(1.7)/home/bitrix/www/bitrix/components/bitrix/sale.personal.order.detail/class.php:2036
CBitrixPersonalOrderDetailComponent->formatResultDeliverySystem(Array
(
)
)
(1.8)/home/bitrix/www/bitrix/components/bitrix/sale.personal.order.detail/class.php:2088
CBitrixPersonalOrderDetailComponent->formatResult(Array
(
)
)
Час виконання: 0.00486 сек.
