Подбор запчастей для MERCEDES-BENZ

MERCEDES-BENZ

Выберите модель

Выберите модификацию

Общий отчет (Время: 2.14745с, Память: 10,527Кб)
Процедура	Номер	Всего (с)	Средн. (с)	Мин. (с)	Макс. (с)
loading session	2	1.82291	0.91146	0.00000	1.82291
system.db.CDbCommand.query(SELECT * FROM `b_sale_fuser` `t` WHERE USER_ID=:USER_ID LIMIT 1)	3	0.00794	0.00265	0.00022	0.00568
system.db.CDbCommand.query(SELECT * FROM `cat_models` `t` WHERE (((car_type_id = :car_type_id) AND (is_visible = 1)) AND (manufacturer_id = :manufacturer_id)) AND (construct_to_year >= :construct_to_year or is_actual = 1 or construct_to_year IS NULL) ORDER BY sort asc, name asc)	1	0.00308	0.00308	0.00308	0.00308
system.db.CDbCommand.query(SELECT *, ifnull(part, name) as part_name FROM `cat_models` `t` WHERE (((car_type_id = :car_type_id) AND (is_visible = 1)) AND (manufacturer_id = :manufacturer_id)) AND ((construct_from_year >= :construct_to_year or is_actual = 1 or construct_to_year IS NULL) and is_actual !=2) ORDER BY sort asc, part_name asc, name asc)	1	0.00257	0.00257	0.00257	0.00257
system.db.CDbCommand.query(SELECT `t`.`ID` AS `t0_c0`, `t`.`COUNTRY_ID` AS `t0_c1`, `t`.`CITY_ID` AS `t0_c2`, `t`.`SORT` AS `t0_c3`, `ct`.`ID` AS `t1_c0`, `ct`.`NAME` AS `t1_c1`, `ct`.`SHORT_NAME` AS `t1_c2`, `ct`.`country_id` AS `t1_c3`, `cu`.`ID` AS `t2_c0`, `cu`.`NAME` AS `t2_c1`, `cu`.`SHORT_NAME` AS `t2_c2` FROM `b_sale_location` `t` LEFT OUTER JOIN `b_sale_location_city` `ct` ON (`t`.`CITY_ID`=`ct`.`ID`) LEFT OUTER JOIN `b_sale_location_country` `cu` ON (`t`.`COUNTRY_ID`=`cu`.`ID`) WHERE ((t.COUNTRY_ID != :COUNTRY_ID) AND (`t`.`ID`=0)) ORDER BY t.SORT ASC, ct.NAME ASC)	1	0.00123	0.00123	0.00123	0.00123
system.db.CDbCommand.query(SELECT * FROM `sp_locations` `t` WHERE `t`.`id`='' LIMIT 1)	1	0.00091	0.00091	0.00091	0.00091
system.db.CDbCommand.query(SELECT COUNT(*) FROM `b_sale_basket` `t` WHERE FUSER_ID=:FUSER_ID AND ORDER_ID IS NULL AND DELAY = :DELAY)	1	0.00075	0.00075	0.00075	0.00075
system.db.CDbCommand.query(SELECT * FROM `cat_manufacturers` `t` WHERE (t.code = :code) AND (t.is_visible = 1) LIMIT 1)	1	0.00039	0.00039	0.00039	0.00039
system.db.CDbCommand.query(SELECT * FROM `sp_delivery_calc_main` `t` WHERE t.location_id = :location_id LIMIT 1)	1	0.00027	0.00027	0.00027	0.00027
system.db.CDbCommand.execute(DELETE FROM `YiiLog` WHERE 0=1)	1	0.00025	0.00025	0.00025	0.00025

Общий отчет (Время: 2.14745с, Память: 10,527Кб)

Процедура

Номер

Всего (с)

Средн. (с)

Мин. (с)

Макс. (с)

loading session

1.82291

0.91146

0.00000

1.82291

system.db.CDbCommand.query(SELECT * FROM `b_sale_fuser` `t` WHERE USER_ID=:USER_ID LIMIT 1)

0.00794

0.00265

0.00022

0.00568

system.db.CDbCommand.query(SELECT * FROM `cat_models` `t` WHERE (((car_type_id = :car_type_id) AND (is_visible = 1)) AND (manufacturer_id = :manufacturer_id)) AND (construct_to_year >= :construct_to_year or is_actual = 1 or construct_to_year IS NULL) ORDER BY sort asc, name asc)

0.00308

system.db.CDbCommand.query(SELECT *, ifnull(part, name) as part_name FROM `cat_models` `t` WHERE (((car_type_id = :car_type_id) AND (is_visible = 1)) AND (manufacturer_id = :manufacturer_id)) AND ((construct_from_year >= :construct_to_year or is_actual = 1 or construct_to_year IS NULL) and is_actual !=2) ORDER BY sort asc, part_name asc, name asc)

0.00257

system.db.CDbCommand.query(SELECT `t`.`ID` AS `t0_c0`, `t`.`COUNTRY_ID` AS `t0_c1`, `t`.`CITY_ID` AS `t0_c2`, `t`.`SORT` AS `t0_c3`, `ct`.`ID` AS `t1_c0`, `ct`.`NAME` AS `t1_c1`, `ct`.`SHORT_NAME` AS `t1_c2`, `ct`.`country_id` AS `t1_c3`, `cu`.`ID` AS `t2_c0`, `cu`.`NAME` AS `t2_c1`, `cu`.`SHORT_NAME` AS `t2_c2` FROM `b_sale_location` `t` LEFT OUTER JOIN `b_sale_location_city` `ct` ON (`t`.`CITY_ID`=`ct`.`ID`) LEFT OUTER JOIN `b_sale_location_country` `cu` ON (`t`.`COUNTRY_ID`=`cu`.`ID`) WHERE ((t.COUNTRY_ID != :COUNTRY_ID) AND (`t`.`ID`=0)) ORDER BY t.SORT ASC, ct.NAME ASC)

0.00123

system.db.CDbCommand.query(SELECT * FROM `sp_locations` `t` WHERE `t`.`id`='' LIMIT 1)

0.00091

system.db.CDbCommand.query(SELECT COUNT(*) FROM `b_sale_basket` `t` WHERE FUSER_ID=:FUSER_ID AND ORDER_ID IS NULL AND DELAY = :DELAY)

0.00075

system.db.CDbCommand.query(SELECT * FROM `cat_manufacturers` `t` WHERE (t.code = :code) AND (t.is_visible = 1) LIMIT 1)

0.00039

system.db.CDbCommand.query(SELECT * FROM `sp_delivery_calc_main` `t` WHERE t.location_id = :location_id LIMIT 1)

0.00027

system.db.CDbCommand.execute(DELETE FROM `YiiLog` WHERE 0=1)

0.00025

Журнал приложения
Время	Уровень	Категория	Сообщение
01:36:50.265827	trace	system.CModule	Loading "log" application component
01:36:50.268384	trace	glitchtip_fallback	The "Sentry\Integration\RequestIntegration, Sentry\Integration\TransactionIntegration, Sentry\Integration\FrameContextifierIntegration, Sentry\Integration\EnvironmentIntegration" integration(s) have been installed.
01:36:50.268627	trace	system.CModule	Loading "db" application component
01:36:50.268692	trace	system.db.CDbConnection	Opening DB connection
01:36:50.269712	trace	system.db.CDbCommand	Executing SQL: DELETE FROM `YiiLog` WHERE 0=1
01:36:50.269716	profile	system.db.CDbCommand.execute	begin:system.db.CDbCommand.execute(DELETE FROM `YiiLog` WHERE 0=1)
01:36:50.269963	profile	system.db.CDbCommand.execute	end:system.db.CDbCommand.execute(DELETE FROM `YiiLog` WHERE 0=1)
01:36:50.270106	trace	system.CModule	Loading "urlHelper" application component
01:36:50.270193	trace	system.CModule	Loading "DBConfig" application component
01:36:50.270216	trace	system.CModule	Loading "cache" application component
01:36:50.272336	trace	system.caching.CMemCache	Serving "66307959e0460a2e2436b0319b2fda14" from cache
01:36:50.273511	trace	system.CModule	Loading "geo" application component
01:36:50.273696	trace	system.CModule	Loading "request" application component
01:36:50.274861	trace	system.caching.CMemCache	Serving "yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:b_sale_location" from cache
01:36:50.275008	trace	system.db.ar.CActiveRecord	Location.findByPk()
01:36:50.275933	trace	system.caching.CMemCache	Serving "yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:b_sale_location_city" from cache
01:36:50.276494	trace	system.caching.CMemCache	Serving "yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:b_sale_location_country" from cache
01:36:50.276617	trace	system.db.CDbCommand	Querying SQL: SELECT `t`.`ID` AS `t0_c0`, `t`.`COUNTRY_ID` AS `t0_c1`, `t`.`CITY_ID` AS `t0_c2`, `t`.`SORT` AS `t0_c3`, `ct`.`ID` AS `t1_c0`, `ct`.`NAME` AS `t1_c1`, `ct`.`SHORT_NAME` AS `t1_c2`, `ct`.`country_id` AS `t1_c3`, `cu`.`ID` AS `t2_c0`, `cu`.`NAME` AS `t2_c1`, `cu`.`SHORT_NAME` AS `t2_c2` FROM `b_sale_location` `t` LEFT OUTER JOIN `b_sale_location_city` `ct` ON (`t`.`CITY_ID`=`ct`.`ID`) LEFT OUTER JOIN `b_sale_location_country` `cu` ON (`t`.`COUNTRY_ID`=`cu`.`ID`) WHERE ((t.COUNTRY_ID != :COUNTRY_ID) AND (`t`.`ID`=0)) ORDER BY t.SORT ASC, ct.NAME ASC
01:36:50.276619	profile	system.db.CDbCommand.query	begin:system.db.CDbCommand.query(SELECT `t`.`ID` AS `t0_c0`, `t`.`COUNTRY_ID` AS `t0_c1`, `t`.`CITY_ID` AS `t0_c2`, `t`.`SORT` AS `t0_c3`, `ct`.`ID` AS `t1_c0`, `ct`.`NAME` AS `t1_c1`, `ct`.`SHORT_NAME` AS `t1_c2`, `ct`.`country_id` AS `t1_c3`, `cu`.`ID` AS `t2_c0`, `cu`.`NAME` AS `t2_c1`, `cu`.`SHORT_NAME` AS `t2_c2` FROM `b_sale_location` `t` LEFT OUTER JOIN `b_sale_location_city` `ct` ON (`t`.`CITY_ID`=`ct`.`ID`) LEFT OUTER JOIN `b_sale_location_country` `cu` ON (`t`.`COUNTRY_ID`=`cu`.`ID`) WHERE ((t.COUNTRY_ID != :COUNTRY_ID) AND (`t`.`ID`=0)) ORDER BY t.SORT ASC, ct.NAME ASC)
01:36:50.277848	profile	system.db.CDbCommand.query	end:system.db.CDbCommand.query(SELECT `t`.`ID` AS `t0_c0`, `t`.`COUNTRY_ID` AS `t0_c1`, `t`.`CITY_ID` AS `t0_c2`, `t`.`SORT` AS `t0_c3`, `ct`.`ID` AS `t1_c0`, `ct`.`NAME` AS `t1_c1`, `ct`.`SHORT_NAME` AS `t1_c2`, `ct`.`country_id` AS `t1_c3`, `cu`.`ID` AS `t2_c0`, `cu`.`NAME` AS `t2_c1`, `cu`.`SHORT_NAME` AS `t2_c2` FROM `b_sale_location` `t` LEFT OUTER JOIN `b_sale_location_city` `ct` ON (`t`.`CITY_ID`=`ct`.`ID`) LEFT OUTER JOIN `b_sale_location_country` `cu` ON (`t`.`COUNTRY_ID`=`cu`.`ID`) WHERE ((t.COUNTRY_ID != :COUNTRY_ID) AND (`t`.`ID`=0)) ORDER BY t.SORT ASC, ct.NAME ASC)
01:36:50.278192	trace	system.CModule	Loading "user" application component
01:36:50.278340	profile	application	begin:loading session
01:36:50.278345	trace	system.CModule	Loading "session" application component
01:36:52.101246	profile	application	end:loading session
01:36:52.106350	trace	system.db.ar.CActiveRecord	OutLocation.findByPk()
01:36:52.107125	trace	system.caching.CMemCache	Serving "yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:sp_locations" from cache
01:36:52.108305	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `sp_locations` `t` WHERE `t`.`id`='' LIMIT 1
01:36:52.108309	profile	system.db.CDbCommand.query	begin:system.db.CDbCommand.query(SELECT * FROM `sp_locations` `t` WHERE `t`.`id`='' LIMIT 1)
01:36:52.109220	profile	system.db.CDbCommand.query	end:system.db.CDbCommand.query(SELECT * FROM `sp_locations` `t` WHERE `t`.`id`='' LIMIT 1)
01:36:52.109317	trace	system.CModule	Loading "B2BConfig" application component
01:36:52.109389	trace	system.CModule	Loading "urlManager" application component
01:36:52.113219	trace	system.caching.CMemCache	Serving "Yii.CUrlManager.rules" from cache
01:36:52.113375	trace	system.base.CModule	Loading "cat" module
01:36:52.114016	trace	system.CModule	Loading "themeInterlayer" application component
01:36:52.114311	trace	system.CModule	Loading "themeManager" application component
01:36:52.140285	trace	system.CModule	Loading "cart" application component
01:36:52.140393	trace	system.db.ar.CActiveRecord	CartUser.find()
01:36:52.156567	trace	system.caching.CMemCache	Serving "yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:b_sale_fuser" from cache
01:36:52.156640	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `b_sale_fuser` `t` WHERE USER_ID=:USER_ID LIMIT 1
01:36:52.156645	profile	system.db.CDbCommand.query	begin:system.db.CDbCommand.query(SELECT * FROM `b_sale_fuser` `t` WHERE USER_ID=:USER_ID LIMIT 1)
01:36:52.158687	profile	system.db.CDbCommand.query	end:system.db.CDbCommand.query(SELECT * FROM `b_sale_fuser` `t` WHERE USER_ID=:USER_ID LIMIT 1)
01:36:52.158973	trace	system.CModule	Loading "coupon" application component
01:36:52.162303	trace	system.CModule	Loading "assetManager" application component
01:36:52.162513	trace	system.db.ar.CActiveRecord	DeliveryCalcMain.find()
01:36:52.170486	trace	system.caching.CMemCache	Serving "yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:sp_delivery_calc_main" from cache
01:36:52.170562	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `sp_delivery_calc_main` `t` WHERE t.location_id = :location_id LIMIT 1
01:36:52.170567	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)
01:36:52.170841	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)
01:36:52.172394	trace	system.CModule	Loading "redisCache" application component
01:36:52.173455	trace	system.caching.CRedisCache	Serving "sberid_AA\Service\OAuth\Clients\SberIdClient_sberid_authState" from cache
01:36:52.174211	trace	system.caching.CRedisCache	Serving "sberid_AA\Service\OAuth\Clients\SberIdClient_sberid_authState" from cache
01:36:52.174355	profile	application	begin:loading session
01:36:52.174359	profile	application	end:loading session
01:36:52.178461	trace	system.CModule	Loading "order" application component
01:36:52.178968	trace	system.caching.CMemCache	Serving "yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:cat_manufacturers" from cache
01:36:52.179003	trace	system.db.ar.CActiveRecord	CatManufacturer.find()
01:36:52.179071	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `cat_manufacturers` `t` WHERE (t.code = :code) AND (t.is_visible = 1) LIMIT 1
01:36:52.179075	profile	system.db.CDbCommand.query	begin:system.db.CDbCommand.query(SELECT * FROM `cat_manufacturers` `t` WHERE (t.code = :code) AND (t.is_visible = 1) LIMIT 1)
01:36:52.179466	profile	system.db.CDbCommand.query	end:system.db.CDbCommand.query(SELECT * FROM `cat_manufacturers` `t` WHERE (t.code = :code) AND (t.is_visible = 1) LIMIT 1)
01:36:52.180880	trace	system.caching.CMemCache	Serving "yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:cat_models" from cache
01:36:52.181022	trace	system.db.ar.CActiveRecord	CatModel.findAll()
01:36:52.181070	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `cat_models` `t` WHERE (((car_type_id = :car_type_id) AND (is_visible = 1)) AND (manufacturer_id = :manufacturer_id)) AND (construct_to_year >= :construct_to_year or is_actual = 1 or construct_to_year IS NULL) ORDER BY sort asc, name asc
01:36:52.181072	profile	system.db.CDbCommand.query	begin:system.db.CDbCommand.query(SELECT * FROM `cat_models` `t` WHERE (((car_type_id = :car_type_id) AND (is_visible = 1)) AND (manufacturer_id = :manufacturer_id)) AND (construct_to_year >= :construct_to_year or is_actual = 1 or construct_to_year IS NULL) ORDER BY sort asc, name asc)
01:36:52.184155	profile	system.db.CDbCommand.query	end:system.db.CDbCommand.query(SELECT * FROM `cat_models` `t` WHERE (((car_type_id = :car_type_id) AND (is_visible = 1)) AND (manufacturer_id = :manufacturer_id)) AND (construct_to_year >= :construct_to_year or is_actual = 1 or construct_to_year IS NULL) ORDER BY sort asc, name asc)
01:36:52.188966	trace	system.db.ar.CActiveRecord	CatModel.findAll()
01:36:52.189029	trace	system.db.CDbCommand	Querying SQL: SELECT *, ifnull(part, name) as part_name FROM `cat_models` `t` WHERE (((car_type_id = :car_type_id) AND (is_visible = 1)) AND (manufacturer_id = :manufacturer_id)) AND ((construct_from_year >= :construct_to_year or is_actual = 1 or construct_to_year IS NULL) and is_actual !=2) ORDER BY sort asc, part_name asc, name asc
01:36:52.189033	profile	system.db.CDbCommand.query	begin:system.db.CDbCommand.query(SELECT *, ifnull(part, name) as part_name FROM `cat_models` `t` WHERE (((car_type_id = :car_type_id) AND (is_visible = 1)) AND (manufacturer_id = :manufacturer_id)) AND ((construct_from_year >= :construct_to_year or is_actual = 1 or construct_to_year IS NULL) and is_actual !=2) ORDER BY sort asc, part_name asc, name asc)
01:36:52.191606	profile	system.db.CDbCommand.query	end:system.db.CDbCommand.query(SELECT *, ifnull(part, name) as part_name FROM `cat_models` `t` WHERE (((car_type_id = :car_type_id) AND (is_visible = 1)) AND (manufacturer_id = :manufacturer_id)) AND ((construct_from_year >= :construct_to_year or is_actual = 1 or construct_to_year IS NULL) and is_actual !=2) ORDER BY sort asc, part_name asc, name asc)
01:36:52.193905	trace	system.CModule	Loading "widgetFactory" application component
01:36:52.195120	trace	system.CModule	Loading "coreMessages" application component
01:36:52.228982	trace	system.CModule	Loading "microdataManager" application component
01:36:52.229218	trace	system.CModule	Loading "clientScript" application component
01:36:52.255881	trace	system.caching.CMemCache	Serving "IWarehouseIWarehouse::getStaticList" from cache
01:36:52.281888	trace	system.caching.CMemCache	Serving "CB:name:top_alert_mobile" from cache
01:36:52.285862	trace	system.caching.CMemCache	Serving "CB:name:bottom_for_buyer_mobile" from cache
01:36:52.286792	trace	system.CModule	Loading "territory" application component
01:36:52.311448	trace	system.caching.CMemCache	Serving "ITerritory3" from cache
01:36:52.311549	trace	system.CModule	Loading "IPropeties" application component
01:36:52.333693	trace	system.caching.CMemCache	Serving "iblock_properties_0" from cache
01:36:52.339669	trace	system.caching.CMemCache	Serving "yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:b_iblock_element" from cache
01:36:52.343924	trace	system.caching.CMemCache	Serving "iblock_properties_0getPropValues1045" from cache
01:36:52.380626	trace	system.caching.CMemCache	Serving "CB:name:bottom_job_mobile" from cache
01:36:52.386640	trace	system.caching.CMemCache	Serving "CB:name:partners_mobile" from cache
01:36:52.393800	trace	system.db.ar.CActiveRecord	CartUser.find()
01:36:52.393878	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `b_sale_fuser` `t` WHERE USER_ID=:USER_ID LIMIT 1
01:36:52.393883	profile	system.db.CDbCommand.query	begin:system.db.CDbCommand.query(SELECT * FROM `b_sale_fuser` `t` WHERE USER_ID=:USER_ID LIMIT 1)
01:36:52.399565	profile	system.db.CDbCommand.query	end:system.db.CDbCommand.query(SELECT * FROM `b_sale_fuser` `t` WHERE USER_ID=:USER_ID LIMIT 1)
01:36:52.399770	trace	system.db.ar.CActiveRecord	CartUser.find()
01:36:52.399843	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `b_sale_fuser` `t` WHERE USER_ID=:USER_ID LIMIT 1
01:36:52.399849	profile	system.db.CDbCommand.query	begin:system.db.CDbCommand.query(SELECT * FROM `b_sale_fuser` `t` WHERE USER_ID=:USER_ID LIMIT 1)
01:36:52.400068	profile	system.db.CDbCommand.query	end:system.db.CDbCommand.query(SELECT * FROM `b_sale_fuser` `t` WHERE USER_ID=:USER_ID LIMIT 1)
01:36:52.400079	trace	system.db.ar.CActiveRecord	Cart.count()
01:36:52.400516	trace	system.caching.CMemCache	Serving "yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:b_sale_basket" from cache
01:36:52.400602	trace	system.db.CDbCommand	Querying SQL: SELECT COUNT(*) FROM `b_sale_basket` `t` WHERE FUSER_ID=:FUSER_ID AND ORDER_ID IS NULL AND DELAY = :DELAY
01:36:52.400604	profile	system.db.CDbCommand.query	begin:system.db.CDbCommand.query(SELECT COUNT(*) FROM `b_sale_basket` `t` WHERE FUSER_ID=:FUSER_ID AND ORDER_ID IS NULL AND DELAY = :DELAY)
01:36:52.401356	profile	system.db.CDbCommand.query	end:system.db.CDbCommand.query(SELECT COUNT(*) FROM `b_sale_basket` `t` WHERE FUSER_ID=:FUSER_ID AND ORDER_ID IS NULL AND DELAY = :DELAY)
01:36:52.402817	trace	system.CModule	Loading "yandexEcom" application component

Журнал приложения

Время

Уровень

Категория

Сообщение

01:36:50.265827

trace

system.CModule

Loading "log" application component

01:36:50.268384

trace

glitchtip_fallback

The "Sentry\Integration\RequestIntegration,
Sentry\Integration\TransactionIntegration,
Sentry\Integration\FrameContextifierIntegration,
Sentry\Integration\EnvironmentIntegration" integration(s) have been
installed.

01:36:50.268627

trace

system.CModule

Loading "db" application component

01:36:50.268692

trace

system.db.CDbConnection

Opening DB connection

01:36:50.269712

trace

system.db.CDbCommand

Executing SQL: DELETE FROM `YiiLog` WHERE 0=1

01:36:50.269716

profile

system.db.CDbCommand.execute

begin:system.db.CDbCommand.execute(DELETE FROM `YiiLog` WHERE 0=1)

01:36:50.269963

profile

system.db.CDbCommand.execute

end:system.db.CDbCommand.execute(DELETE FROM `YiiLog` WHERE 0=1)

01:36:50.270106

trace

system.CModule

Loading "urlHelper" application component

01:36:50.270193

trace

system.CModule

Loading "DBConfig" application component

01:36:50.270216

trace

system.CModule

Loading "cache" application component

01:36:50.272336

trace

system.caching.CMemCache

Serving "66307959e0460a2e2436b0319b2fda14" from cache

01:36:50.273511

trace

system.CModule

Loading "geo" application component

01:36:50.273696

trace

system.CModule

Loading "request" application component

01:36:50.274861

trace

system.caching.CMemCache

Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:b_sale_location"
from cache

01:36:50.275008

trace

system.db.ar.CActiveRecord

Location.findByPk()

01:36:50.275933

trace

system.caching.CMemCache

Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:b_sale_location_city"
from cache

01:36:50.276494

trace

system.caching.CMemCache

Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:b_sale_location_country"
from cache

01:36:50.276617

trace

system.db.CDbCommand

Querying SQL: SELECT `t`.`ID` AS `t0_c0`, `t`.`COUNTRY_ID` AS `t0_c1`,
`t`.`CITY_ID` AS `t0_c2`, `t`.`SORT` AS `t0_c3`, `ct`.`ID` AS `t1_c0`,
`ct`.`NAME` AS `t1_c1`, `ct`.`SHORT_NAME` AS `t1_c2`, `ct`.`country_id` AS
`t1_c3`, `cu`.`ID` AS `t2_c0`, `cu`.`NAME` AS `t2_c1`, `cu`.`SHORT_NAME` AS
`t2_c2` FROM `b_sale_location` `t`  LEFT OUTER JOIN `b_sale_location_city`
`ct` ON (`t`.`CITY_ID`=`ct`.`ID`) LEFT OUTER JOIN `b_sale_location_country`
`cu` ON (`t`.`COUNTRY_ID`=`cu`.`ID`) WHERE ((t.COUNTRY_ID != :COUNTRY_ID)
AND (`t`.`ID`=0)) ORDER BY t.SORT ASC, ct.NAME ASC

01:36:50.276619

profile

system.db.CDbCommand.query

begin:system.db.CDbCommand.query(SELECT `t`.`ID` AS `t0_c0`,
`t`.`COUNTRY_ID` AS `t0_c1`, `t`.`CITY_ID` AS `t0_c2`, `t`.`SORT` AS
`t0_c3`, `ct`.`ID` AS `t1_c0`, `ct`.`NAME` AS `t1_c1`, `ct`.`SHORT_NAME` AS
`t1_c2`, `ct`.`country_id` AS `t1_c3`, `cu`.`ID` AS `t2_c0`, `cu`.`NAME` AS
`t2_c1`, `cu`.`SHORT_NAME` AS `t2_c2` FROM `b_sale_location` `t`  LEFT
OUTER JOIN `b_sale_location_city` `ct` ON (`t`.`CITY_ID`=`ct`.`ID`) LEFT
OUTER JOIN `b_sale_location_country` `cu` ON (`t`.`COUNTRY_ID`=`cu`.`ID`)
WHERE ((t.COUNTRY_ID != :COUNTRY_ID) AND (`t`.`ID`=0)) ORDER BY t.SORT ASC,
ct.NAME ASC)

01:36:50.277848

profile

system.db.CDbCommand.query

end:system.db.CDbCommand.query(SELECT `t`.`ID` AS `t0_c0`, `t`.`COUNTRY_ID`
AS `t0_c1`, `t`.`CITY_ID` AS `t0_c2`, `t`.`SORT` AS `t0_c3`, `ct`.`ID` AS
`t1_c0`, `ct`.`NAME` AS `t1_c1`, `ct`.`SHORT_NAME` AS `t1_c2`,
`ct`.`country_id` AS `t1_c3`, `cu`.`ID` AS `t2_c0`, `cu`.`NAME` AS `t2_c1`,
`cu`.`SHORT_NAME` AS `t2_c2` FROM `b_sale_location` `t`  LEFT OUTER JOIN
`b_sale_location_city` `ct` ON (`t`.`CITY_ID`=`ct`.`ID`) LEFT OUTER JOIN
`b_sale_location_country` `cu` ON (`t`.`COUNTRY_ID`=`cu`.`ID`) WHERE
((t.COUNTRY_ID != :COUNTRY_ID) AND (`t`.`ID`=0)) ORDER BY t.SORT ASC,
ct.NAME ASC)

01:36:50.278192

trace

system.CModule

Loading "user" application component

01:36:50.278340

profile

application

begin:loading session

01:36:50.278345

trace

system.CModule

Loading "session" application component

01:36:52.101246

profile

application

end:loading session

01:36:52.106350

trace

system.db.ar.CActiveRecord

OutLocation.findByPk()

01:36:52.107125

trace

system.caching.CMemCache

Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:sp_locations"
from cache

01:36:52.108305

trace

system.db.CDbCommand

Querying SQL: SELECT * FROM `sp_locations` `t` WHERE `t`.`id`='' LIMIT 1

01:36:52.108309

profile

system.db.CDbCommand.query

begin:system.db.CDbCommand.query(SELECT * FROM `sp_locations` `t` WHERE
`t`.`id`='' LIMIT 1)

01:36:52.109220

profile

system.db.CDbCommand.query

end:system.db.CDbCommand.query(SELECT * FROM `sp_locations` `t` WHERE
`t`.`id`='' LIMIT 1)

01:36:52.109317

trace

system.CModule

Loading "B2BConfig" application component

01:36:52.109389

trace

system.CModule

Loading "urlManager" application component

01:36:52.113219

trace

system.caching.CMemCache

Serving "Yii.CUrlManager.rules" from cache

01:36:52.113375

trace

system.base.CModule

Loading "cat" module

01:36:52.114016

trace

system.CModule

Loading "themeInterlayer" application component

01:36:52.114311

trace

system.CModule

Loading "themeManager" application component

01:36:52.140285

trace

system.CModule

Loading "cart" application component

01:36:52.140393

trace

system.db.ar.CActiveRecord

CartUser.find()

01:36:52.156567

trace

system.caching.CMemCache

Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:b_sale_fuser"
from cache

01:36:52.156640

trace

system.db.CDbCommand

Querying SQL: SELECT * FROM `b_sale_fuser` `t` WHERE USER_ID=:USER_ID LIMIT
1

01:36:52.156645

profile

system.db.CDbCommand.query

begin:system.db.CDbCommand.query(SELECT * FROM `b_sale_fuser` `t` WHERE
USER_ID=:USER_ID LIMIT 1)

01:36:52.158687

profile

system.db.CDbCommand.query

end:system.db.CDbCommand.query(SELECT * FROM `b_sale_fuser` `t` WHERE
USER_ID=:USER_ID LIMIT 1)

01:36:52.158973

trace

system.CModule

Loading "coupon" application component

01:36:52.162303

trace

system.CModule

Loading "assetManager" application component

01:36:52.162513

trace

system.db.ar.CActiveRecord

DeliveryCalcMain.find()

01:36:52.170486

trace

system.caching.CMemCache

Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:sp_delivery_calc_main"
from cache

01:36:52.170562

trace

system.db.CDbCommand

Querying SQL: SELECT * FROM `sp_delivery_calc_main` `t` WHERE t.location_id
= :location_id LIMIT 1

01:36:52.170567

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)

01:36:52.170841

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)

01:36:52.172394

trace

system.CModule

Loading "redisCache" application component

01:36:52.173455

trace

system.caching.CRedisCache

Serving "sberid_AA\Service\OAuth\Clients\SberIdClient_sberid_authState"
from cache

01:36:52.174211

trace

system.caching.CRedisCache

Serving "sberid_AA\Service\OAuth\Clients\SberIdClient_sberid_authState"
from cache

01:36:52.174355

profile

application

begin:loading session

01:36:52.174359

profile

application

end:loading session

01:36:52.178461

trace

system.CModule

Loading "order" application component

01:36:52.178968

trace

system.caching.CMemCache

Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:cat_manufacturers"
from cache

01:36:52.179003

trace

system.db.ar.CActiveRecord

CatManufacturer.find()

01:36:52.179071

trace

system.db.CDbCommand

Querying SQL: SELECT * FROM `cat_manufacturers` `t` WHERE (t.code = :code)
AND (t.is_visible = 1) LIMIT 1

01:36:52.179075

profile

system.db.CDbCommand.query

begin:system.db.CDbCommand.query(SELECT * FROM `cat_manufacturers` `t`
WHERE (t.code = :code) AND (t.is_visible = 1) LIMIT 1)

01:36:52.179466

profile

system.db.CDbCommand.query

end:system.db.CDbCommand.query(SELECT * FROM `cat_manufacturers` `t` WHERE
(t.code = :code) AND (t.is_visible = 1) LIMIT 1)

01:36:52.180880

trace

system.caching.CMemCache

Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:cat_models"
from cache

01:36:52.181022

trace

system.db.ar.CActiveRecord

CatModel.findAll()

01:36:52.181070

trace

system.db.CDbCommand

Querying SQL: SELECT * FROM `cat_models` `t` WHERE (((car_type_id =
:car_type_id) AND (is_visible = 1)) AND (manufacturer_id =
:manufacturer_id)) AND (construct_to_year >= :construct_to_year or
is_actual = 1 or construct_to_year IS NULL) ORDER BY sort asc, name asc

01:36:52.181072

profile

system.db.CDbCommand.query

begin:system.db.CDbCommand.query(SELECT * FROM `cat_models` `t` WHERE
(((car_type_id = :car_type_id) AND (is_visible = 1)) AND (manufacturer_id =
:manufacturer_id)) AND (construct_to_year >= :construct_to_year or
is_actual = 1 or construct_to_year IS NULL) ORDER BY sort asc, name asc)

01:36:52.184155

profile

system.db.CDbCommand.query

end:system.db.CDbCommand.query(SELECT * FROM `cat_models` `t` WHERE
(((car_type_id = :car_type_id) AND (is_visible = 1)) AND (manufacturer_id =
:manufacturer_id)) AND (construct_to_year >= :construct_to_year or
is_actual = 1 or construct_to_year IS NULL) ORDER BY sort asc, name asc)

01:36:52.188966

trace

system.db.ar.CActiveRecord

CatModel.findAll()

01:36:52.189029

trace

system.db.CDbCommand

Querying SQL: SELECT *, ifnull(part, name) as part_name FROM `cat_models`
`t` WHERE (((car_type_id = :car_type_id) AND (is_visible = 1)) AND
(manufacturer_id = :manufacturer_id)) AND ((construct_from_year >=
:construct_to_year or is_actual = 1 or construct_to_year IS NULL) and
is_actual !=2) ORDER BY sort asc, part_name asc, name asc

01:36:52.189033

profile

system.db.CDbCommand.query

begin:system.db.CDbCommand.query(SELECT *, ifnull(part, name) as part_name
FROM `cat_models` `t` WHERE (((car_type_id = :car_type_id) AND (is_visible
= 1)) AND (manufacturer_id = :manufacturer_id)) AND ((construct_from_year
>= :construct_to_year or is_actual = 1 or construct_to_year IS NULL) and
is_actual !=2) ORDER BY sort asc, part_name asc, name asc)

01:36:52.191606

profile

system.db.CDbCommand.query

end:system.db.CDbCommand.query(SELECT *, ifnull(part, name) as part_name
FROM `cat_models` `t` WHERE (((car_type_id = :car_type_id) AND (is_visible
= 1)) AND (manufacturer_id = :manufacturer_id)) AND ((construct_from_year
>= :construct_to_year or is_actual = 1 or construct_to_year IS NULL) and
is_actual !=2) ORDER BY sort asc, part_name asc, name asc)

01:36:52.193905

trace

system.CModule

Loading "widgetFactory" application component

01:36:52.195120

trace

system.CModule

Loading "coreMessages" application component

01:36:52.228982

trace

system.CModule

Loading "microdataManager" application component

01:36:52.229218

trace

system.CModule

Loading "clientScript" application component

01:36:52.255881

trace

system.caching.CMemCache

Serving "IWarehouseIWarehouse::getStaticList" from cache

01:36:52.281888

trace

system.caching.CMemCache

Serving "CB:name:top_alert_mobile" from cache

01:36:52.285862

trace

system.caching.CMemCache

Serving "CB:name:bottom_for_buyer_mobile" from cache

01:36:52.286792

trace

system.CModule

Loading "territory" application component

01:36:52.311448

trace

system.caching.CMemCache

Serving "ITerritory3" from cache

01:36:52.311549

trace

system.CModule

Loading "IPropeties" application component

01:36:52.333693

trace

system.caching.CMemCache

Serving "iblock_properties_0" from cache

01:36:52.339669

trace

system.caching.CMemCache

Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:b_iblock_element"
from cache

01:36:52.343924

trace

system.caching.CMemCache

Serving "iblock_properties_0getPropValues1045" from cache

01:36:52.380626

trace

system.caching.CMemCache

Serving "CB:name:bottom_job_mobile" from cache

01:36:52.386640

trace

system.caching.CMemCache

Serving "CB:name:partners_mobile" from cache

01:36:52.393800

trace

system.db.ar.CActiveRecord

CartUser.find()

01:36:52.393878

trace

system.db.CDbCommand

Querying SQL: SELECT * FROM `b_sale_fuser` `t` WHERE USER_ID=:USER_ID LIMIT
1

01:36:52.393883

profile

system.db.CDbCommand.query

begin:system.db.CDbCommand.query(SELECT * FROM `b_sale_fuser` `t` WHERE
USER_ID=:USER_ID LIMIT 1)

01:36:52.399565

profile

system.db.CDbCommand.query

end:system.db.CDbCommand.query(SELECT * FROM `b_sale_fuser` `t` WHERE
USER_ID=:USER_ID LIMIT 1)

01:36:52.399770

trace

system.db.ar.CActiveRecord

CartUser.find()

01:36:52.399843

trace

system.db.CDbCommand

Querying SQL: SELECT * FROM `b_sale_fuser` `t` WHERE USER_ID=:USER_ID LIMIT
1

01:36:52.399849

profile

system.db.CDbCommand.query

begin:system.db.CDbCommand.query(SELECT * FROM `b_sale_fuser` `t` WHERE
USER_ID=:USER_ID LIMIT 1)

01:36:52.400068

profile

system.db.CDbCommand.query

end:system.db.CDbCommand.query(SELECT * FROM `b_sale_fuser` `t` WHERE
USER_ID=:USER_ID LIMIT 1)

01:36:52.400079

trace

system.db.ar.CActiveRecord

Cart.count()

01:36:52.400516

trace

system.caching.CMemCache

Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:b_sale_basket"
from cache

01:36:52.400602

trace

system.db.CDbCommand

Querying SQL: SELECT COUNT(*) FROM `b_sale_basket` `t` WHERE
FUSER_ID=:FUSER_ID AND ORDER_ID IS NULL AND DELAY = :DELAY

01:36:52.400604

profile

system.db.CDbCommand.query

begin:system.db.CDbCommand.query(SELECT COUNT(*) FROM `b_sale_basket` `t`
WHERE FUSER_ID=:FUSER_ID AND ORDER_ID IS NULL AND DELAY = :DELAY)

01:36:52.401356

profile

system.db.CDbCommand.query

end:system.db.CDbCommand.query(SELECT COUNT(*) FROM `b_sale_basket` `t`
WHERE FUSER_ID=:FUSER_ID AND ORDER_ID IS NULL AND DELAY = :DELAY)

01:36:52.402817

trace

system.CModule

Loading "yandexEcom" application component