Вход или
регистрация

Войти по e-mail/логину Регистрация как юрлицо
При входе или регистрации
вы соглашаетесь с Политикой конфиденциальности

Общий отчет (Время: 0.07209с, Память: 9,762Кб)
Процедура	Номер	Всего (с)	Средн. (с)	Мин. (с)	Макс. (с)
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `b_sale_location`)	1	0.00075	0.00075	0.00075	0.00075
loading session	2	0.00074	0.00037	0.00000	0.00074
system.db.CDbCommand.query(SELECT * FROM `b_sale_fuser` `t` WHERE USER_ID=:USER_ID LIMIT 1)	3	0.00065	0.00022	0.00019	0.00027
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `sp_locations`)	1	0.00063	0.00063	0.00063	0.00063
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `b_sale_location_city`)	1	0.00050	0.00050	0.00050	0.00050
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `b_sale_location_country`)	1	0.00047	0.00047	0.00047	0.00047
system.db.CDbCommand.query(SHOW CREATE TABLE `sp_locations`)	1	0.00026	0.00026	0.00026	0.00026
system.db.CDbCommand.query(SHOW CREATE TABLE `b_sale_location`)	1	0.00022	0.00022	0.00022	0.00022
system.db.CDbCommand.execute(DELETE FROM `YiiLog` WHERE 0=1)	1	0.00020	0.00020	0.00020	0.00020
system.db.CDbCommand.query(SHOW CREATE TABLE `b_sale_location_city`)	1	0.00020	0.00020	0.00020	0.00020
system.db.CDbCommand.query(SHOW CREATE TABLE `b_sale_location_country`)	1	0.00019	0.00019	0.00019	0.00019
system.db.CDbCommand.query(SELECT * FROM `sp_locations` `t` WHERE `t`.`id`='' LIMIT 1)	1	0.00019	0.00019	0.00019	0.00019
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.00018	0.00018	0.00018	0.00018
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.00018	0.00018	0.00018	0.00018
system.db.CDbCommand.query(SELECT * FROM `sp_delivery_calc_main` `t` WHERE t.location_id = :location_id LIMIT 1)	1	0.00017	0.00017	0.00017	0.00017

Общий отчет (Время: 0.07209с, Память: 9,762Кб)

Процедура

Номер

Всего (с)

Средн. (с)

Мин. (с)

Макс. (с)

system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `b_sale_location`)

0.00075

loading session

0.00074

0.00037

0.00000

0.00074

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

0.00065

0.00022

0.00019

0.00027

system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `sp_locations`)

0.00063

system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `b_sale_location_city`)

0.00050

system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `b_sale_location_country`)

0.00047

system.db.CDbCommand.query(SHOW CREATE TABLE `sp_locations`)

0.00026

system.db.CDbCommand.query(SHOW CREATE TABLE `b_sale_location`)

0.00022

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

0.00020

system.db.CDbCommand.query(SHOW CREATE TABLE `b_sale_location_city`)

0.00020

system.db.CDbCommand.query(SHOW CREATE TABLE `b_sale_location_country`)

0.00019

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

0.00019

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.00018

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.00018

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

0.00017

Журнал приложения
Время	Уровень	Категория	Сообщение
09:46:40.638250	trace	system.CModule	Loading "log" application component
09:46:40.640881	trace	glitchtip_fallback	The "Sentry\Integration\RequestIntegration, Sentry\Integration\TransactionIntegration, Sentry\Integration\FrameContextifierIntegration, Sentry\Integration\EnvironmentIntegration" integration(s) have been installed.
09:46:40.641096	trace	system.CModule	Loading "db" application component
09:46:40.641155	trace	system.db.CDbConnection	Opening DB connection
09:46:40.642136	trace	system.db.CDbCommand	Executing SQL: DELETE FROM `YiiLog` WHERE 0=1
09:46:40.642141	profile	system.db.CDbCommand.execute	begin:system.db.CDbCommand.execute(DELETE FROM `YiiLog` WHERE 0=1)
09:46:40.642343	profile	system.db.CDbCommand.execute	end:system.db.CDbCommand.execute(DELETE FROM `YiiLog` WHERE 0=1)
09:46:40.642499	trace	system.CModule	Loading "urlHelper" application component
09:46:40.642591	trace	system.CModule	Loading "DBConfig" application component
09:46:40.642617	trace	system.CModule	Loading "cache" application component
09:46:40.643507	trace	system.caching.CMemCache	Serving "66307959e0460a2e2436b0319b2fda14" from cache
09:46:40.643824	trace	system.CModule	Loading "geo" application component
09:46:40.643882	trace	system.CModule	Loading "request" application component
09:46:40.644594	trace	system.db.CDbCommand	Querying SQL: SHOW FULL COLUMNS FROM `b_sale_location`
09:46:40.644601	profile	system.db.CDbCommand.query	begin:system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `b_sale_location`)
09:46:40.645349	profile	system.db.CDbCommand.query	end:system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `b_sale_location`)
09:46:40.645637	trace	system.db.CDbCommand	Querying SQL: SHOW CREATE TABLE `b_sale_location`
09:46:40.645641	profile	system.db.CDbCommand.query	begin:system.db.CDbCommand.query(SHOW CREATE TABLE `b_sale_location`)
09:46:40.645865	profile	system.db.CDbCommand.query	end:system.db.CDbCommand.query(SHOW CREATE TABLE `b_sale_location`)
09:46:40.645958	trace	system.caching.CMemCache	Saving "yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:b_sale_location" to cache
09:46:40.646117	trace	system.db.ar.CActiveRecord	Location.findByPk()
09:46:40.646776	trace	system.db.CDbCommand	Querying SQL: SHOW FULL COLUMNS FROM `b_sale_location_city`
09:46:40.646780	profile	system.db.CDbCommand.query	begin:system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `b_sale_location_city`)
09:46:40.647279	profile	system.db.CDbCommand.query	end:system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `b_sale_location_city`)
09:46:40.647367	trace	system.db.CDbCommand	Querying SQL: SHOW CREATE TABLE `b_sale_location_city`
09:46:40.647371	profile	system.db.CDbCommand.query	begin:system.db.CDbCommand.query(SHOW CREATE TABLE `b_sale_location_city`)
09:46:40.647572	profile	system.db.CDbCommand.query	end:system.db.CDbCommand.query(SHOW CREATE TABLE `b_sale_location_city`)
09:46:40.647579	trace	system.caching.CMemCache	Saving "yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:b_sale_location_city" to cache
09:46:40.648056	trace	system.db.CDbCommand	Querying SQL: SHOW FULL COLUMNS FROM `b_sale_location_country`
09:46:40.648058	profile	system.db.CDbCommand.query	begin:system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `b_sale_location_country`)
09:46:40.648533	profile	system.db.CDbCommand.query	end:system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `b_sale_location_country`)
09:46:40.648591	trace	system.db.CDbCommand	Querying SQL: SHOW CREATE TABLE `b_sale_location_country`
09:46:40.648592	profile	system.db.CDbCommand.query	begin:system.db.CDbCommand.query(SHOW CREATE TABLE `b_sale_location_country`)
09:46:40.648782	profile	system.db.CDbCommand.query	end:system.db.CDbCommand.query(SHOW CREATE TABLE `b_sale_location_country`)
09:46:40.648792	trace	system.caching.CMemCache	Saving "yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:b_sale_location_country" to cache
09:46:40.649040	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
09:46:40.649045	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)
09:46:40.649221	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)
09:46:40.649399	trace	system.CModule	Loading "user" application component
09:46:40.649529	profile	application	begin:loading session
09:46:40.649535	trace	system.CModule	Loading "session" application component
09:46:40.650271	profile	application	end:loading session
09:46:40.650831	trace	system.db.ar.CActiveRecord	OutLocation.findByPk()
09:46:40.650964	trace	system.db.CDbCommand	Querying SQL: SHOW FULL COLUMNS FROM `sp_locations`
09:46:40.650966	profile	system.db.CDbCommand.query	begin:system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `sp_locations`)
09:46:40.651595	profile	system.db.CDbCommand.query	end:system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `sp_locations`)
09:46:40.651743	trace	system.db.CDbCommand	Querying SQL: SHOW CREATE TABLE `sp_locations`
09:46:40.651746	profile	system.db.CDbCommand.query	begin:system.db.CDbCommand.query(SHOW CREATE TABLE `sp_locations`)
09:46:40.652002	profile	system.db.CDbCommand.query	end:system.db.CDbCommand.query(SHOW CREATE TABLE `sp_locations`)
09:46:40.652009	trace	system.caching.CMemCache	Saving "yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:sp_locations" to cache
09:46:40.652220	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `sp_locations` `t` WHERE `t`.`id`='' LIMIT 1
09:46:40.652224	profile	system.db.CDbCommand.query	begin:system.db.CDbCommand.query(SELECT * FROM `sp_locations` `t` WHERE `t`.`id`='' LIMIT 1)
09:46:40.652410	profile	system.db.CDbCommand.query	end:system.db.CDbCommand.query(SELECT * FROM `sp_locations` `t` WHERE `t`.`id`='' LIMIT 1)
09:46:40.652482	trace	system.CModule	Loading "B2BConfig" application component
09:46:40.652559	trace	system.CModule	Loading "urlManager" application component
09:46:40.653556	trace	system.caching.CMemCache	Serving "Yii.CUrlManager.rules" from cache
09:46:40.654530	trace	system.CModule	Loading "themeInterlayer" application component
09:46:40.654808	trace	system.CModule	Loading "themeManager" application component
09:46:40.655925	trace	system.web.filters.CFilterChain	Running filter SiteController.filteraccessControl()
09:46:40.656007	trace	system.CModule	Loading "cart" application component
09:46:40.656583	trace	system.db.ar.CActiveRecord	CartUser.find()
09:46:40.656752	trace	system.caching.CMemCache	Serving "yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:b_sale_fuser" from cache
09:46:40.656790	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `b_sale_fuser` `t` WHERE USER_ID=:USER_ID LIMIT 1
09:46:40.656793	profile	system.db.CDbCommand.query	begin:system.db.CDbCommand.query(SELECT * FROM `b_sale_fuser` `t` WHERE USER_ID=:USER_ID LIMIT 1)
09:46:40.656989	profile	system.db.CDbCommand.query	end:system.db.CDbCommand.query(SELECT * FROM `b_sale_fuser` `t` WHERE USER_ID=:USER_ID LIMIT 1)
09:46:40.657227	trace	system.CModule	Loading "coupon" application component
09:46:40.657776	trace	system.CModule	Loading "assetManager" application component
09:46:40.658446	trace	system.db.ar.CActiveRecord	DeliveryCalcMain.find()
09:46:40.658605	trace	system.caching.CMemCache	Serving "yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:sp_delivery_calc_main" from cache
09:46:40.658638	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `sp_delivery_calc_main` `t` WHERE t.location_id = :location_id LIMIT 1
09:46:40.658641	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)
09:46:40.658814	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)
09:46:40.660450	trace	system.CModule	Loading "redisCache" application component
09:46:40.661150	trace	system.caching.CRedisCache	Serving "sberid_AA\Service\OAuth\Clients\SberIdClient_sberid_authState" from cache
09:46:40.661468	trace	system.caching.CRedisCache	Serving "sberid_AA\Service\OAuth\Clients\SberIdClient_sberid_authState" from cache
09:46:40.661607	profile	application	begin:loading session
09:46:40.661609	profile	application	end:loading session
09:46:40.663579	trace	system.CModule	Loading "order" application component
09:46:40.665343	trace	system.CModule	Loading "microdataManager" application component
09:46:40.665807	trace	system.CModule	Loading "clientScript" application component
09:46:40.669785	trace	system.caching.CRedisCache	Serving "sberid_AA\Service\OAuth\Clients\SberIdClient_sberid_authState" from cache
09:46:40.670038	trace	system.caching.CRedisCache	Serving "sberid_AA\Service\OAuth\Clients\SberIdClient_sberid_authState" from cache
09:46:40.671560	trace	system.CModule	Loading "widgetFactory" application component
09:46:40.673695	trace	system.caching.CMemCache	Serving "IWarehouseIWarehouse::getStaticList" from cache
09:46:40.677695	trace	system.caching.CMemCache	Serving "CB:name:top_alert_mobile" from cache
09:46:40.679454	trace	system.caching.CMemCache	Serving "CB:name:bottom_for_buyer_mobile" from cache
09:46:40.680224	trace	system.CModule	Loading "territory" application component
09:46:40.685147	trace	system.caching.CMemCache	Serving "ITerritory3" from cache
09:46:40.685245	trace	system.CModule	Loading "IPropeties" application component
09:46:40.688755	trace	system.caching.CMemCache	Serving "iblock_properties_0" from cache
09:46:40.689114	trace	system.caching.CMemCache	Serving "yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:b_iblock_element" from cache
09:46:40.691267	trace	system.caching.CMemCache	Serving "iblock_properties_0getPropValues1045" from cache
09:46:40.698379	trace	system.caching.CMemCache	Serving "CB:name:bottom_job_mobile" from cache
09:46:40.699196	trace	system.caching.CMemCache	Serving "CB:name:partners_mobile" from cache
09:46:40.701875	trace	system.db.ar.CActiveRecord	CartUser.find()
09:46:40.701945	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `b_sale_fuser` `t` WHERE USER_ID=:USER_ID LIMIT 1
09:46:40.701948	profile	system.db.CDbCommand.query	begin:system.db.CDbCommand.query(SELECT * FROM `b_sale_fuser` `t` WHERE USER_ID=:USER_ID LIMIT 1)
09:46:40.702214	profile	system.db.CDbCommand.query	end:system.db.CDbCommand.query(SELECT * FROM `b_sale_fuser` `t` WHERE USER_ID=:USER_ID LIMIT 1)
09:46:40.703012	trace	system.db.ar.CActiveRecord	CartUser.find()
09:46:40.703047	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `b_sale_fuser` `t` WHERE USER_ID=:USER_ID LIMIT 1
09:46:40.703049	profile	system.db.CDbCommand.query	begin:system.db.CDbCommand.query(SELECT * FROM `b_sale_fuser` `t` WHERE USER_ID=:USER_ID LIMIT 1)
09:46:40.703237	profile	system.db.CDbCommand.query	end:system.db.CDbCommand.query(SELECT * FROM `b_sale_fuser` `t` WHERE USER_ID=:USER_ID LIMIT 1)
09:46:40.703243	trace	system.db.ar.CActiveRecord	Cart.count()
09:46:40.703463	trace	system.caching.CMemCache	Serving "yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:b_sale_basket" from cache
09:46:40.703535	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
09:46:40.703536	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)
09:46:40.703715	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)
09:46:40.704842	trace	system.CModule	Loading "yandexEcom" application component

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

Время

Уровень

Категория

Сообщение

09:46:40.638250

trace

system.CModule

Loading "log" application component

09:46:40.640881

trace

glitchtip_fallback

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

09:46:40.641096

trace

system.CModule

Loading "db" application component

09:46:40.641155

trace

system.db.CDbConnection

Opening DB connection

09:46:40.642136

trace

system.db.CDbCommand

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

09:46:40.642141

profile

system.db.CDbCommand.execute

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

09:46:40.642343

profile

system.db.CDbCommand.execute

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

09:46:40.642499

trace

system.CModule

Loading "urlHelper" application component

09:46:40.642591

trace

system.CModule

Loading "DBConfig" application component

09:46:40.642617

trace

system.CModule

Loading "cache" application component

09:46:40.643507

trace

system.caching.CMemCache

Serving "66307959e0460a2e2436b0319b2fda14" from cache

09:46:40.643824

trace

system.CModule

Loading "geo" application component

09:46:40.643882

trace

system.CModule

Loading "request" application component

09:46:40.644594

trace

system.db.CDbCommand

Querying SQL: SHOW FULL COLUMNS FROM `b_sale_location`

09:46:40.644601

profile

system.db.CDbCommand.query

begin:system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `b_sale_location`)

09:46:40.645349

profile

system.db.CDbCommand.query

end:system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `b_sale_location`)

09:46:40.645637

trace

system.db.CDbCommand

Querying SQL: SHOW CREATE TABLE `b_sale_location`

09:46:40.645641

profile

system.db.CDbCommand.query

begin:system.db.CDbCommand.query(SHOW CREATE TABLE `b_sale_location`)

09:46:40.645865

profile

system.db.CDbCommand.query

end:system.db.CDbCommand.query(SHOW CREATE TABLE `b_sale_location`)

09:46:40.645958

trace

system.caching.CMemCache

Saving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:b_sale_location"
to cache

09:46:40.646117

trace

system.db.ar.CActiveRecord

Location.findByPk()

09:46:40.646776

trace

system.db.CDbCommand

Querying SQL: SHOW FULL COLUMNS FROM `b_sale_location_city`

09:46:40.646780

profile

system.db.CDbCommand.query

begin:system.db.CDbCommand.query(SHOW FULL COLUMNS FROM
`b_sale_location_city`)

09:46:40.647279

profile

system.db.CDbCommand.query

end:system.db.CDbCommand.query(SHOW FULL COLUMNS FROM
`b_sale_location_city`)

09:46:40.647367

trace

system.db.CDbCommand

Querying SQL: SHOW CREATE TABLE `b_sale_location_city`

09:46:40.647371

profile

system.db.CDbCommand.query

begin:system.db.CDbCommand.query(SHOW CREATE TABLE `b_sale_location_city`)

09:46:40.647572

profile

system.db.CDbCommand.query

end:system.db.CDbCommand.query(SHOW CREATE TABLE `b_sale_location_city`)

09:46:40.647579

trace

system.caching.CMemCache

Saving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:b_sale_location_city"
to cache

09:46:40.648056

trace

system.db.CDbCommand

Querying SQL: SHOW FULL COLUMNS FROM `b_sale_location_country`

09:46:40.648058

profile

system.db.CDbCommand.query

begin:system.db.CDbCommand.query(SHOW FULL COLUMNS FROM
`b_sale_location_country`)

09:46:40.648533

profile

system.db.CDbCommand.query

end:system.db.CDbCommand.query(SHOW FULL COLUMNS FROM
`b_sale_location_country`)

09:46:40.648591

trace

system.db.CDbCommand

Querying SQL: SHOW CREATE TABLE `b_sale_location_country`

09:46:40.648592

profile

system.db.CDbCommand.query

begin:system.db.CDbCommand.query(SHOW CREATE TABLE
`b_sale_location_country`)

09:46:40.648782

profile

system.db.CDbCommand.query

end:system.db.CDbCommand.query(SHOW CREATE TABLE `b_sale_location_country`)

09:46:40.648792

trace

system.caching.CMemCache

Saving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:b_sale_location_country"
to cache

09:46:40.649040

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

09:46:40.649045

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)

09:46:40.649221

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)

09:46:40.649399

trace

system.CModule

Loading "user" application component

09:46:40.649529

profile

application

begin:loading session

09:46:40.649535

trace

system.CModule

Loading "session" application component

09:46:40.650271

profile

application

end:loading session

09:46:40.650831

trace

system.db.ar.CActiveRecord

OutLocation.findByPk()

09:46:40.650964

trace

system.db.CDbCommand

Querying SQL: SHOW FULL COLUMNS FROM `sp_locations`

09:46:40.650966

profile

system.db.CDbCommand.query

begin:system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `sp_locations`)

09:46:40.651595

profile

system.db.CDbCommand.query

end:system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `sp_locations`)

09:46:40.651743

trace

system.db.CDbCommand

Querying SQL: SHOW CREATE TABLE `sp_locations`

09:46:40.651746

profile

system.db.CDbCommand.query

begin:system.db.CDbCommand.query(SHOW CREATE TABLE `sp_locations`)

09:46:40.652002

profile

system.db.CDbCommand.query

end:system.db.CDbCommand.query(SHOW CREATE TABLE `sp_locations`)

09:46:40.652009

trace

system.caching.CMemCache

Saving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:sp_locations"
to cache

09:46:40.652220

trace

system.db.CDbCommand

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

09:46:40.652224

profile

system.db.CDbCommand.query

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

09:46:40.652410

profile

system.db.CDbCommand.query

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

09:46:40.652482

trace

system.CModule

Loading "B2BConfig" application component

09:46:40.652559

trace

system.CModule

Loading "urlManager" application component

09:46:40.653556

trace

system.caching.CMemCache

Serving "Yii.CUrlManager.rules" from cache

09:46:40.654530

trace

system.CModule

Loading "themeInterlayer" application component

09:46:40.654808

trace

system.CModule

Loading "themeManager" application component

09:46:40.655925

trace

system.web.filters.CFilterChain

Running filter SiteController.filteraccessControl()

09:46:40.656007

trace

system.CModule

Loading "cart" application component

09:46:40.656583

trace

system.db.ar.CActiveRecord

CartUser.find()

09:46:40.656752

trace

system.caching.CMemCache

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

09:46:40.656790

trace

system.db.CDbCommand

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

09:46:40.656793

profile

system.db.CDbCommand.query

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

09:46:40.656989

profile

system.db.CDbCommand.query

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

09:46:40.657227

trace

system.CModule

Loading "coupon" application component

09:46:40.657776

trace

system.CModule

Loading "assetManager" application component

09:46:40.658446

trace

system.db.ar.CActiveRecord

DeliveryCalcMain.find()

09:46:40.658605

trace

system.caching.CMemCache

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

09:46:40.658638

trace

system.db.CDbCommand

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

09:46:40.658641

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)

09:46:40.658814

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)

09:46:40.660450

trace

system.CModule

Loading "redisCache" application component

09:46:40.661150

trace

system.caching.CRedisCache

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

09:46:40.661468

trace

system.caching.CRedisCache

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

09:46:40.661607

profile

application

begin:loading session

09:46:40.661609

profile

application

end:loading session

09:46:40.663579

trace

system.CModule

Loading "order" application component

09:46:40.665343

trace

system.CModule

Loading "microdataManager" application component

09:46:40.665807

trace

system.CModule

Loading "clientScript" application component

09:46:40.669785

trace

system.caching.CRedisCache

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

09:46:40.670038

trace

system.caching.CRedisCache

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

09:46:40.671560

trace

system.CModule

Loading "widgetFactory" application component

09:46:40.673695

trace

system.caching.CMemCache

Serving "IWarehouseIWarehouse::getStaticList" from cache

09:46:40.677695

trace

system.caching.CMemCache

Serving "CB:name:top_alert_mobile" from cache

09:46:40.679454

trace

system.caching.CMemCache

Serving "CB:name:bottom_for_buyer_mobile" from cache

09:46:40.680224

trace

system.CModule

Loading "territory" application component

09:46:40.685147

trace

system.caching.CMemCache

Serving "ITerritory3" from cache

09:46:40.685245

trace

system.CModule

Loading "IPropeties" application component

09:46:40.688755

trace

system.caching.CMemCache

Serving "iblock_properties_0" from cache

09:46:40.689114

trace

system.caching.CMemCache

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

09:46:40.691267

trace

system.caching.CMemCache

Serving "iblock_properties_0getPropValues1045" from cache

09:46:40.698379

trace

system.caching.CMemCache

Serving "CB:name:bottom_job_mobile" from cache

09:46:40.699196

trace

system.caching.CMemCache

Serving "CB:name:partners_mobile" from cache

09:46:40.701875

trace

system.db.ar.CActiveRecord

CartUser.find()

09:46:40.701945

trace

system.db.CDbCommand

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

09:46:40.701948

profile

system.db.CDbCommand.query

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

09:46:40.702214

profile

system.db.CDbCommand.query

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

09:46:40.703012

trace

system.db.ar.CActiveRecord

CartUser.find()

09:46:40.703047

trace

system.db.CDbCommand

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

09:46:40.703049

profile

system.db.CDbCommand.query

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

09:46:40.703237

profile

system.db.CDbCommand.query

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

09:46:40.703243

trace

system.db.ar.CActiveRecord

Cart.count()

09:46:40.703463

trace

system.caching.CMemCache

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

09:46:40.703535

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

09:46:40.703536

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)

09:46:40.703715

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)

09:46:40.704842

trace

system.CModule

Loading "yandexEcom" application component

Вход или регистрация

Вход или
регистрация