Общий отчет (Время: 0.28594с, Память: 10,310Кб)
Процедура Номер Всего (с) Средн. (с) Мин. (с) Макс. (с)
system.db.CDbCommand.query(SELECT * FROM `b_sale_delivery_handler` `t`) 1 0.00151 0.00151 0.00151 0.00151
system.db.CDbCommand.query(SELECT * FROM `delivery_pvz` `t` WHERE DELIVERY_ID = :DELIVERY_ID ORDER BY t.ADDRESS ASC) 1 0.07646 0.07646 0.07646 0.07646
system.db.CDbCommand.query(SELECT * FROM `b_sale_delivery` `t` WHERE (t.LID = :LID AND (t.ACTIVE = "Y")) AND (PERIOD_FROM > -2) ORDER BY t.SORT asc) 1 0.00093 0.00093 0.00093 0.00093
loading session 2 0.00073 0.00036 0.00000 0.00072
system.db.CDbCommand.query(SELECT * FROM `sp_regex` `t` WHERE (site_lid = "im") AND (block_type = :block_type)) 1 0.00046 0.00046 0.00046 0.00046
system.db.CDbCommand.query(SELECT * FROM `sp_regex` `t` WHERE site_lid = "im") 1 0.00036 0.00036 0.00036 0.00036
system.db.CDbCommand.query(SELECT * FROM `delivery_pvz` `t` WHERE ((DELIVERY_ID = :DELIVERY_ID) AND (CITY_ID=:CITY_ID)) AND (COUNTRY_ID= :COUNTRY_ID) ORDER BY t.ADDRESS ASC) 1 0.00034 0.00034 0.00034 0.00034
system.db.CDbCommand.query(SELECT * FROM `delivery_pvz` `t` WHERE (DELIVERY_ID = :DELIVERY_ID) AND (COUNTRY_ID= :COUNTRY_ID) ORDER BY t.ADDRESS ASC) 1 0.00031 0.00031 0.00031 0.00031
system.db.CDbCommand.query(SELECT * FROM `b_sale_fuser` `t` WHERE USER_ID=:USER_ID LIMIT 1) 1 0.00024 0.00024 0.00024 0.00024
system.db.CDbCommand.execute(DELETE FROM `YiiLog` WHERE 0=1) 1 0.00023 0.00023 0.00023 0.00023
system.db.CDbCommand.query(SELECT * FROM `sp_delivery_calc_main` `t` WHERE t.location_id = :location_id LIMIT 1) 1 0.00019 0.00019 0.00019 0.00019
Журнал приложения
Время Уровень Категория Сообщение
23:18:05.908502 trace system.CModule 
Loading "log" application component
23:18:05.911835 trace glitchtip_fallback 
The "Sentry\Integration\RequestIntegration,
Sentry\Integration\TransactionIntegration,
Sentry\Integration\FrameContextifierIntegration,
Sentry\Integration\EnvironmentIntegration" integration(s) have been
installed.
23:18:05.912064 trace system.CModule 
Loading "db" application component
23:18:05.912111 trace system.db.CDbConnection 
Opening DB connection
23:18:05.913084 trace system.db.CDbCommand 
Executing SQL: DELETE FROM `YiiLog` WHERE 0=1
23:18:05.913089 profile system.db.CDbCommand.execute 
begin:system.db.CDbCommand.execute(DELETE FROM `YiiLog` WHERE 0=1)
23:18:05.913316 profile system.db.CDbCommand.execute 
end:system.db.CDbCommand.execute(DELETE FROM `YiiLog` WHERE 0=1)
23:18:05.913435 trace system.CModule 
Loading "urlHelper" application component
23:18:05.913521 trace system.CModule 
Loading "DBConfig" application component
23:18:05.913546 trace system.CModule 
Loading "cache" application component
23:18:05.914333 trace system.caching.CMemCache 
Serving "66307959e0460a2e2436b0319b2fda14" from cache
23:18:05.914659 trace system.CModule 
Loading "geo" application component
23:18:05.914717 trace system.CModule 
Loading "request" application component
23:18:05.914937 trace system.CModule 
Loading "user" application component
23:18:05.915106 profile application 
begin:loading session
23:18:05.915110 trace system.CModule 
Loading "session" application component
23:18:05.915827 profile application 
end:loading session
23:18:05.916266 trace system.CModule 
Loading "B2BConfig" application component
23:18:05.916332 trace system.CModule 
Loading "urlManager" application component
23:18:05.917493 trace system.caching.CMemCache 
Serving "Yii.CUrlManager.rules" from cache
23:18:05.918672 trace system.CModule 
Loading "themeInterlayer" application component
23:18:05.918908 trace system.CModule 
Loading "themeManager" application component
23:18:05.919626 trace system.CModule 
Loading "cart" application component
23:18:05.919723 trace system.db.ar.CActiveRecord 
CartUser.find()
23:18:05.919992 trace system.caching.CMemCache 
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:b_sale_fuser"
from cache
23:18:05.920034 trace system.db.CDbCommand 
Querying SQL: SELECT * FROM `b_sale_fuser` `t` WHERE USER_ID=:USER_ID LIMIT
1
23:18:05.920038 profile system.db.CDbCommand.query 
begin:system.db.CDbCommand.query(SELECT * FROM `b_sale_fuser` `t` WHERE
USER_ID=:USER_ID LIMIT 1)
23:18:05.920281 profile system.db.CDbCommand.query 
end:system.db.CDbCommand.query(SELECT * FROM `b_sale_fuser` `t` WHERE
USER_ID=:USER_ID LIMIT 1)
23:18:05.920449 trace system.CModule 
Loading "coupon" application component
23:18:05.920660 trace system.CModule 
Loading "assetManager" application component
23:18:05.920814 trace system.db.ar.CActiveRecord 
DeliveryCalcMain.find()
23:18:05.920968 trace system.caching.CMemCache 
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:sp_delivery_calc_main"
from cache
23:18:05.921000 trace system.db.CDbCommand 
Querying SQL: SELECT * FROM `sp_delivery_calc_main` `t` WHERE t.location_id
= :location_id LIMIT 1
23:18:05.921004 profile system.db.CDbCommand.query 
begin:system.db.CDbCommand.query(SELECT * FROM `sp_delivery_calc_main` `t`
WHERE t.location_id = :location_id LIMIT 1)
23:18:05.921194 profile system.db.CDbCommand.query 
end:system.db.CDbCommand.query(SELECT * FROM `sp_delivery_calc_main` `t`
WHERE t.location_id = :location_id LIMIT 1)
23:18:05.922468 trace system.CModule 
Loading "redisCache" application component
23:18:05.923330 trace system.caching.CRedisCache 
Serving "sberid_AA\Service\OAuth\Clients\SberIdClient_sberid_authState"
from cache
23:18:05.923628 trace system.caching.CRedisCache 
Serving "sberid_AA\Service\OAuth\Clients\SberIdClient_sberid_authState"
from cache
23:18:05.923780 profile application 
begin:loading session
23:18:05.923784 profile application 
end:loading session
23:18:05.925299 trace system.CModule 
Loading "order" application component
23:18:05.925653 trace system.db.ar.CActiveRecord 
OrderDelivery.findAll()
23:18:05.925827 trace system.caching.CMemCache 
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:b_sale_delivery"
from cache
23:18:05.925868 trace system.db.CDbCommand 
Querying SQL: SELECT * FROM `b_sale_delivery` `t` WHERE (t.LID = :LID AND
(t.ACTIVE = "Y")) AND (PERIOD_FROM > -2) ORDER BY t.SORT asc
23:18:05.925872 profile system.db.CDbCommand.query 
begin:system.db.CDbCommand.query(SELECT * FROM `b_sale_delivery` `t` WHERE
(t.LID = :LID AND (t.ACTIVE = "Y")) AND (PERIOD_FROM > -2) ORDER BY t.SORT
asc)
23:18:05.926805 profile system.db.CDbCommand.query 
end:system.db.CDbCommand.query(SELECT * FROM `b_sale_delivery` `t` WHERE
(t.LID = :LID AND (t.ACTIVE = "Y")) AND (PERIOD_FROM > -2) ORDER BY t.SORT
asc)
23:18:05.927786 trace system.CModule 
Loading "DeliverySystem" application component
23:18:05.928323 trace system.db.ar.CActiveRecord 
OrderDeliveryHandler.findAll()
23:18:05.928474 trace system.caching.CMemCache 
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:b_sale_delivery_handler"
from cache
23:18:05.928499 trace system.db.CDbCommand 
Querying SQL: SELECT * FROM `b_sale_delivery_handler` `t`
23:18:05.928502 profile system.db.CDbCommand.query 
begin:system.db.CDbCommand.query(SELECT * FROM `b_sale_delivery_handler`
`t`)
23:18:05.930012 profile system.db.CDbCommand.query 
end:system.db.CDbCommand.query(SELECT * FROM `b_sale_delivery_handler` `t`)
23:18:05.934638 trace system.caching.CMemCache 
Serving "IWarehouseIWarehouse::getStaticList" from cache
23:18:05.935127 trace system.caching.CMemCache 
Saving "getDimensions3885d4657d219c3fbbc6d033a1310cb5" to cache
23:18:05.936201 trace system.db.ar.CActiveRecord 
RegExModel.findAll()
23:18:05.936398 trace system.caching.CMemCache 
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:sp_regex"
from cache
23:18:05.936444 trace system.db.CDbCommand 
Querying SQL: SELECT * FROM `sp_regex` `t` WHERE (site_lid = "im") AND
(block_type = :block_type)
23:18:05.936450 profile system.db.CDbCommand.query 
begin:system.db.CDbCommand.query(SELECT * FROM `sp_regex` `t` WHERE
(site_lid = "im") AND (block_type = :block_type))
23:18:05.936913 profile system.db.CDbCommand.query 
end:system.db.CDbCommand.query(SELECT * FROM `sp_regex` `t` WHERE (site_lid
= "im") AND (block_type = :block_type))
23:18:05.938071 trace system.caching.CMemCache 
Serving
"DeliverySystemBBa2072c8a50f1127f73a55a6b5f574da7DeliverySystem::getSubListCount1"
from cache
23:18:05.938081 trace system.caching.CMemCache 
Saving
"DeliverySystemBBa2072c8a50f1127f73a55a6b5f574da7DeliverySystem::getSubListCount1"
to cache
23:18:05.938534 trace system.db.ar.CActiveRecord 
RegExModel.findAll()
23:18:05.938576 trace system.db.CDbCommand 
Querying SQL: SELECT * FROM `sp_regex` `t` WHERE site_lid = "im"
23:18:05.938580 profile system.db.CDbCommand.query 
begin:system.db.CDbCommand.query(SELECT * FROM `sp_regex` `t` WHERE
site_lid = "im")
23:18:05.938939 profile system.db.CDbCommand.query 
end:system.db.CDbCommand.query(SELECT * FROM `sp_regex` `t` WHERE site_lid
= "im")
23:18:05.943458 trace system.db.ar.CActiveRecord 
DeliveryPVZ.findAll()
23:18:05.943631 trace system.caching.CMemCache 
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:delivery_pvz"
from cache
23:18:05.943677 trace system.db.CDbCommand 
Querying SQL: SELECT * FROM `delivery_pvz` `t` WHERE ((DELIVERY_ID =
:DELIVERY_ID) AND (CITY_ID=:CITY_ID)) AND (COUNTRY_ID= :COUNTRY_ID) ORDER
BY t.ADDRESS ASC
23:18:05.943681 profile system.db.CDbCommand.query 
begin:system.db.CDbCommand.query(SELECT * FROM `delivery_pvz` `t` WHERE
((DELIVERY_ID = :DELIVERY_ID) AND (CITY_ID=:CITY_ID)) AND (COUNTRY_ID=
:COUNTRY_ID) ORDER BY t.ADDRESS ASC)
23:18:05.944020 profile system.db.CDbCommand.query 
end:system.db.CDbCommand.query(SELECT * FROM `delivery_pvz` `t` WHERE
((DELIVERY_ID = :DELIVERY_ID) AND (CITY_ID=:CITY_ID)) AND (COUNTRY_ID=
:COUNTRY_ID) ORDER BY t.ADDRESS ASC)
23:18:05.944051 trace system.db.ar.CActiveRecord 
DeliveryPVZ.findAll()
23:18:05.944108 trace system.db.CDbCommand 
Querying SQL: SELECT * FROM `delivery_pvz` `t` WHERE (DELIVERY_ID =
:DELIVERY_ID) AND (COUNTRY_ID= :COUNTRY_ID) ORDER BY t.ADDRESS ASC
23:18:05.944112 profile system.db.CDbCommand.query 
begin:system.db.CDbCommand.query(SELECT * FROM `delivery_pvz` `t` WHERE
(DELIVERY_ID = :DELIVERY_ID) AND (COUNTRY_ID= :COUNTRY_ID) ORDER BY
t.ADDRESS ASC)
23:18:05.944421 profile system.db.CDbCommand.query 
end:system.db.CDbCommand.query(SELECT * FROM `delivery_pvz` `t` WHERE
(DELIVERY_ID = :DELIVERY_ID) AND (COUNTRY_ID= :COUNTRY_ID) ORDER BY
t.ADDRESS ASC)
23:18:05.954829 trace system.db.ar.CActiveRecord 
DeliveryPVZ.findAll()
23:18:05.954885 trace system.db.CDbCommand 
Querying SQL: SELECT * FROM `delivery_pvz` `t` WHERE DELIVERY_ID =
:DELIVERY_ID ORDER BY t.ADDRESS ASC
23:18:05.954889 profile system.db.CDbCommand.query 
begin:system.db.CDbCommand.query(SELECT * FROM `delivery_pvz` `t` WHERE
DELIVERY_ID = :DELIVERY_ID ORDER BY t.ADDRESS ASC)
23:18:06.031348 profile system.db.CDbCommand.query 
end:system.db.CDbCommand.query(SELECT * FROM `delivery_pvz` `t` WHERE
DELIVERY_ID = :DELIVERY_ID ORDER BY t.ADDRESS ASC)