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

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

Общий отчет (Время: 0.06965с, Память: 9,762Кб)
Процедура	Номер	Всего (с)	Средн. (с)	Мин. (с)	Макс. (с)
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `b_sale_location`)	1	0.00063	0.00063	0.00063	0.00063
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.00062	0.00062	0.00062	0.00062
loading session	2	0.00062	0.00031	0.00000	0.00062
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `b_sale_location_country`)	1	0.00054	0.00054	0.00054	0.00054
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `b_sale_location_city`)	1	0.00054	0.00054	0.00054	0.00054
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.00035	0.00035	0.00035	0.00035
system.db.CDbCommand.query(SHOW CREATE TABLE `b_sale_location`)	1	0.00032	0.00032	0.00032	0.00032
system.db.CDbCommand.query(SELECT * FROM `sp_locations` `t` WHERE `t`.`id`='' LIMIT 1)	1	0.00032	0.00032	0.00032	0.00032
system.db.CDbCommand.query(SHOW CREATE TABLE `sp_locations`)	1	0.00027	0.00027	0.00027	0.00027
system.db.CDbCommand.query(SHOW CREATE TABLE `b_sale_location_city`)	1	0.00023	0.00023	0.00023	0.00023
system.db.CDbCommand.query(SHOW CREATE TABLE `b_sale_location_country`)	1	0.00022	0.00022	0.00022	0.00022
system.db.CDbCommand.execute(DELETE FROM `YiiLog` WHERE 0=1)	1	0.00021	0.00021	0.00021	0.00021
system.db.CDbCommand.query(SELECT * FROM `sp_delivery_calc_main` `t` WHERE t.location_id = :location_id LIMIT 1)	1	0.00020	0.00020	0.00020	0.00020
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

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

Процедура

Номер

Всего (с)

Средн. (с)

Мин. (с)

Макс. (с)

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

0.00063

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

loading session

0.00062

0.00031

0.00000

0.00062

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

0.00054

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

0.00054

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

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

0.00032

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

0.00032

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

0.00027

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

0.00023

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

0.00022

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

0.00021

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

0.00020

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

Журнал приложения
Время	Уровень	Категория	Сообщение
20:51:17.473059	trace	system.CModule	Loading "log" application component
20:51:17.475096	trace	glitchtip_fallback	The "Sentry\Integration\RequestIntegration, Sentry\Integration\TransactionIntegration, Sentry\Integration\FrameContextifierIntegration, Sentry\Integration\EnvironmentIntegration" integration(s) have been installed.
20:51:17.475294	trace	system.CModule	Loading "db" application component
20:51:17.475343	trace	system.db.CDbConnection	Opening DB connection
20:51:17.476474	trace	system.db.CDbCommand	Executing SQL: DELETE FROM `YiiLog` WHERE 0=1
20:51:17.476478	profile	system.db.CDbCommand.execute	begin:system.db.CDbCommand.execute(DELETE FROM `YiiLog` WHERE 0=1)
20:51:17.476689	profile	system.db.CDbCommand.execute	end:system.db.CDbCommand.execute(DELETE FROM `YiiLog` WHERE 0=1)
20:51:17.476816	trace	system.CModule	Loading "urlHelper" application component
20:51:17.476902	trace	system.CModule	Loading "DBConfig" application component
20:51:17.476928	trace	system.CModule	Loading "cache" application component
20:51:17.477685	trace	system.caching.CMemCache	Serving "66307959e0460a2e2436b0319b2fda14" from cache
20:51:17.477955	trace	system.CModule	Loading "geo" application component
20:51:17.478014	trace	system.CModule	Loading "request" application component
20:51:17.478635	trace	system.db.CDbCommand	Querying SQL: SHOW FULL COLUMNS FROM `b_sale_location`
20:51:17.478638	profile	system.db.CDbCommand.query	begin:system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `b_sale_location`)
20:51:17.479268	profile	system.db.CDbCommand.query	end:system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `b_sale_location`)
20:51:17.479402	trace	system.db.CDbCommand	Querying SQL: SHOW CREATE TABLE `b_sale_location`
20:51:17.479404	profile	system.db.CDbCommand.query	begin:system.db.CDbCommand.query(SHOW CREATE TABLE `b_sale_location`)
20:51:17.479727	profile	system.db.CDbCommand.query	end:system.db.CDbCommand.query(SHOW CREATE TABLE `b_sale_location`)
20:51:17.479738	trace	system.caching.CMemCache	Saving "yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:b_sale_location" to cache
20:51:17.479886	trace	system.db.ar.CActiveRecord	Location.findByPk()
20:51:17.480447	trace	system.db.CDbCommand	Querying SQL: SHOW FULL COLUMNS FROM `b_sale_location_city`
20:51:17.480449	profile	system.db.CDbCommand.query	begin:system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `b_sale_location_city`)
20:51:17.480993	profile	system.db.CDbCommand.query	end:system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `b_sale_location_city`)
20:51:17.481040	trace	system.db.CDbCommand	Querying SQL: SHOW CREATE TABLE `b_sale_location_city`
20:51:17.481043	profile	system.db.CDbCommand.query	begin:system.db.CDbCommand.query(SHOW CREATE TABLE `b_sale_location_city`)
20:51:17.481277	profile	system.db.CDbCommand.query	end:system.db.CDbCommand.query(SHOW CREATE TABLE `b_sale_location_city`)
20:51:17.481286	trace	system.caching.CMemCache	Saving "yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:b_sale_location_city" to cache
20:51:17.481731	trace	system.db.CDbCommand	Querying SQL: SHOW FULL COLUMNS FROM `b_sale_location_country`
20:51:17.481734	profile	system.db.CDbCommand.query	begin:system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `b_sale_location_country`)
20:51:17.482279	profile	system.db.CDbCommand.query	end:system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `b_sale_location_country`)
20:51:17.482342	trace	system.db.CDbCommand	Querying SQL: SHOW CREATE TABLE `b_sale_location_country`
20:51:17.482345	profile	system.db.CDbCommand.query	begin:system.db.CDbCommand.query(SHOW CREATE TABLE `b_sale_location_country`)
20:51:17.482569	profile	system.db.CDbCommand.query	end:system.db.CDbCommand.query(SHOW CREATE TABLE `b_sale_location_country`)
20:51:17.482578	trace	system.caching.CMemCache	Saving "yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:b_sale_location_country" to cache
20:51:17.482799	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
20:51:17.482801	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)
20:51:17.483153	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)
20:51:17.483329	trace	system.CModule	Loading "user" application component
20:51:17.483434	profile	application	begin:loading session
20:51:17.483438	trace	system.CModule	Loading "session" application component
20:51:17.484054	profile	application	end:loading session
20:51:17.484606	trace	system.db.ar.CActiveRecord	OutLocation.findByPk()
20:51:17.484730	trace	system.db.CDbCommand	Querying SQL: SHOW FULL COLUMNS FROM `sp_locations`
20:51:17.484734	profile	system.db.CDbCommand.query	begin:system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `sp_locations`)
20:51:17.485357	profile	system.db.CDbCommand.query	end:system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `sp_locations`)
20:51:17.485472	trace	system.db.CDbCommand	Querying SQL: SHOW CREATE TABLE `sp_locations`
20:51:17.485475	profile	system.db.CDbCommand.query	begin:system.db.CDbCommand.query(SHOW CREATE TABLE `sp_locations`)
20:51:17.485745	profile	system.db.CDbCommand.query	end:system.db.CDbCommand.query(SHOW CREATE TABLE `sp_locations`)
20:51:17.485754	trace	system.caching.CMemCache	Saving "yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:sp_locations" to cache
20:51:17.485939	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `sp_locations` `t` WHERE `t`.`id`='' LIMIT 1
20:51:17.485941	profile	system.db.CDbCommand.query	begin:system.db.CDbCommand.query(SELECT * FROM `sp_locations` `t` WHERE `t`.`id`='' LIMIT 1)
20:51:17.486260	profile	system.db.CDbCommand.query	end:system.db.CDbCommand.query(SELECT * FROM `sp_locations` `t` WHERE `t`.`id`='' LIMIT 1)
20:51:17.486329	trace	system.CModule	Loading "B2BConfig" application component
20:51:17.486386	trace	system.CModule	Loading "urlManager" application component
20:51:17.487318	trace	system.caching.CMemCache	Serving "Yii.CUrlManager.rules" from cache
20:51:17.487901	trace	system.CModule	Loading "themeInterlayer" application component
20:51:17.488151	trace	system.CModule	Loading "themeManager" application component
20:51:17.489132	trace	system.web.filters.CFilterChain	Running filter SiteController.filteraccessControl()
20:51:17.489207	trace	system.CModule	Loading "cart" application component
20:51:17.489800	trace	system.db.ar.CActiveRecord	CartUser.find()
20:51:17.489931	trace	system.caching.CMemCache	Serving "yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:b_sale_fuser" from cache
20:51:17.489964	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `b_sale_fuser` `t` WHERE USER_ID=:USER_ID LIMIT 1
20:51:17.489967	profile	system.db.CDbCommand.query	begin:system.db.CDbCommand.query(SELECT * FROM `b_sale_fuser` `t` WHERE USER_ID=:USER_ID LIMIT 1)
20:51:17.490159	profile	system.db.CDbCommand.query	end:system.db.CDbCommand.query(SELECT * FROM `b_sale_fuser` `t` WHERE USER_ID=:USER_ID LIMIT 1)
20:51:17.490418	trace	system.CModule	Loading "coupon" application component
20:51:17.490998	trace	system.CModule	Loading "assetManager" application component
20:51:17.491640	trace	system.db.ar.CActiveRecord	DeliveryCalcMain.find()
20:51:17.491816	trace	system.caching.CMemCache	Serving "yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:sp_delivery_calc_main" from cache
20:51:17.491851	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `sp_delivery_calc_main` `t` WHERE t.location_id = :location_id LIMIT 1
20:51:17.491852	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)
20:51:17.492049	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)
20:51:17.493489	trace	system.CModule	Loading "redisCache" application component
20:51:17.494317	trace	system.caching.CRedisCache	Serving "sberid_AA\Service\OAuth\Clients\SberIdClient_sberid_authState" from cache
20:51:17.494646	trace	system.caching.CRedisCache	Serving "sberid_AA\Service\OAuth\Clients\SberIdClient_sberid_authState" from cache
20:51:17.494752	profile	application	begin:loading session
20:51:17.494755	profile	application	end:loading session
20:51:17.496529	trace	system.CModule	Loading "order" application component
20:51:17.498308	trace	system.CModule	Loading "microdataManager" application component
20:51:17.498778	trace	system.CModule	Loading "clientScript" application component
20:51:17.502522	trace	system.caching.CRedisCache	Serving "sberid_AA\Service\OAuth\Clients\SberIdClient_sberid_authState" from cache
20:51:17.502763	trace	system.caching.CRedisCache	Serving "sberid_AA\Service\OAuth\Clients\SberIdClient_sberid_authState" from cache
20:51:17.504235	trace	system.CModule	Loading "widgetFactory" application component
20:51:17.506308	trace	system.caching.CMemCache	Serving "IWarehouseIWarehouse::getStaticList" from cache
20:51:17.510217	trace	system.caching.CMemCache	Serving "CB:name:top_alert_mobile" from cache
20:51:17.511962	trace	system.caching.CMemCache	Serving "CB:name:bottom_for_buyer_mobile" from cache
20:51:17.512754	trace	system.CModule	Loading "territory" application component
20:51:17.517745	trace	system.caching.CMemCache	Serving "ITerritory3" from cache
20:51:17.517827	trace	system.CModule	Loading "IPropeties" application component
20:51:17.522074	trace	system.caching.CMemCache	Serving "iblock_properties_0" from cache
20:51:17.522442	trace	system.caching.CMemCache	Serving "yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:b_iblock_element" from cache
20:51:17.524538	trace	system.caching.CMemCache	Serving "iblock_properties_0getPropValues1045" from cache
20:51:17.531352	trace	system.caching.CMemCache	Serving "CB:name:bottom_job_mobile" from cache
20:51:17.532145	trace	system.caching.CMemCache	Serving "CB:name:partners_mobile" from cache
20:51:17.534718	trace	system.db.ar.CActiveRecord	CartUser.find()
20:51:17.534782	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `b_sale_fuser` `t` WHERE USER_ID=:USER_ID LIMIT 1
20:51:17.534785	profile	system.db.CDbCommand.query	begin:system.db.CDbCommand.query(SELECT * FROM `b_sale_fuser` `t` WHERE USER_ID=:USER_ID LIMIT 1)
20:51:17.535052	profile	system.db.CDbCommand.query	end:system.db.CDbCommand.query(SELECT * FROM `b_sale_fuser` `t` WHERE USER_ID=:USER_ID LIMIT 1)
20:51:17.535877	trace	system.db.ar.CActiveRecord	CartUser.find()
20:51:17.535912	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `b_sale_fuser` `t` WHERE USER_ID=:USER_ID LIMIT 1
20:51:17.535914	profile	system.db.CDbCommand.query	begin:system.db.CDbCommand.query(SELECT * FROM `b_sale_fuser` `t` WHERE USER_ID=:USER_ID LIMIT 1)
20:51:17.536106	profile	system.db.CDbCommand.query	end:system.db.CDbCommand.query(SELECT * FROM `b_sale_fuser` `t` WHERE USER_ID=:USER_ID LIMIT 1)
20:51:17.536112	trace	system.db.ar.CActiveRecord	Cart.count()
20:51:17.536314	trace	system.caching.CMemCache	Serving "yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:b_sale_basket" from cache
20:51:17.536385	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
20:51:17.536386	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)
20:51:17.536564	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)
20:51:17.537647	trace	system.CModule	Loading "yandexEcom" application component

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

Время

Уровень

Категория

Сообщение

20:51:17.473059

trace

system.CModule

Loading "log" application component

20:51:17.475096

trace

glitchtip_fallback

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

20:51:17.475294

trace

system.CModule

Loading "db" application component

20:51:17.475343

trace

system.db.CDbConnection

Opening DB connection

20:51:17.476474

trace

system.db.CDbCommand

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

20:51:17.476478

profile

system.db.CDbCommand.execute

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

20:51:17.476689

profile

system.db.CDbCommand.execute

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

20:51:17.476816

trace

system.CModule

Loading "urlHelper" application component

20:51:17.476902

trace

system.CModule

Loading "DBConfig" application component

20:51:17.476928

trace

system.CModule

Loading "cache" application component

20:51:17.477685

trace

system.caching.CMemCache

Serving "66307959e0460a2e2436b0319b2fda14" from cache

20:51:17.477955

trace

system.CModule

Loading "geo" application component

20:51:17.478014

trace

system.CModule

Loading "request" application component

20:51:17.478635

trace

system.db.CDbCommand

Querying SQL: SHOW FULL COLUMNS FROM `b_sale_location`

20:51:17.478638

profile

system.db.CDbCommand.query

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

20:51:17.479268

profile

system.db.CDbCommand.query

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

20:51:17.479402

trace

system.db.CDbCommand

Querying SQL: SHOW CREATE TABLE `b_sale_location`

20:51:17.479404

profile

system.db.CDbCommand.query

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

20:51:17.479727

profile

system.db.CDbCommand.query

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

20:51:17.479738

trace

system.caching.CMemCache

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

20:51:17.479886

trace

system.db.ar.CActiveRecord

Location.findByPk()

20:51:17.480447

trace

system.db.CDbCommand

Querying SQL: SHOW FULL COLUMNS FROM `b_sale_location_city`

20:51:17.480449

profile

system.db.CDbCommand.query

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

20:51:17.480993

profile

system.db.CDbCommand.query

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

20:51:17.481040

trace

system.db.CDbCommand

Querying SQL: SHOW CREATE TABLE `b_sale_location_city`

20:51:17.481043

profile

system.db.CDbCommand.query

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

20:51:17.481277

profile

system.db.CDbCommand.query

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

20:51:17.481286

trace

system.caching.CMemCache

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

20:51:17.481731

trace

system.db.CDbCommand

Querying SQL: SHOW FULL COLUMNS FROM `b_sale_location_country`

20:51:17.481734

profile

system.db.CDbCommand.query

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

20:51:17.482279

profile

system.db.CDbCommand.query

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

20:51:17.482342

trace

system.db.CDbCommand

Querying SQL: SHOW CREATE TABLE `b_sale_location_country`

20:51:17.482345

profile

system.db.CDbCommand.query

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

20:51:17.482569

profile

system.db.CDbCommand.query

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

20:51:17.482578

trace

system.caching.CMemCache

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

20:51:17.482799

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

20:51:17.482801

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)

20:51:17.483153

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)

20:51:17.483329

trace

system.CModule

Loading "user" application component

20:51:17.483434

profile

application

begin:loading session

20:51:17.483438

trace

system.CModule

Loading "session" application component

20:51:17.484054

profile

application

end:loading session

20:51:17.484606

trace

system.db.ar.CActiveRecord

OutLocation.findByPk()

20:51:17.484730

trace

system.db.CDbCommand

Querying SQL: SHOW FULL COLUMNS FROM `sp_locations`

20:51:17.484734

profile

system.db.CDbCommand.query

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

20:51:17.485357

profile

system.db.CDbCommand.query

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

20:51:17.485472

trace

system.db.CDbCommand

Querying SQL: SHOW CREATE TABLE `sp_locations`

20:51:17.485475

profile

system.db.CDbCommand.query

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

20:51:17.485745

profile

system.db.CDbCommand.query

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

20:51:17.485754

trace

system.caching.CMemCache

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

20:51:17.485939

trace

system.db.CDbCommand

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

20:51:17.485941

profile

system.db.CDbCommand.query

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

20:51:17.486260

profile

system.db.CDbCommand.query

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

20:51:17.486329

trace

system.CModule

Loading "B2BConfig" application component

20:51:17.486386

trace

system.CModule

Loading "urlManager" application component

20:51:17.487318

trace

system.caching.CMemCache

Serving "Yii.CUrlManager.rules" from cache

20:51:17.487901

trace

system.CModule

Loading "themeInterlayer" application component

20:51:17.488151

trace

system.CModule

Loading "themeManager" application component

20:51:17.489132

trace

system.web.filters.CFilterChain

Running filter SiteController.filteraccessControl()

20:51:17.489207

trace

system.CModule

Loading "cart" application component

20:51:17.489800

trace

system.db.ar.CActiveRecord

CartUser.find()

20:51:17.489931

trace

system.caching.CMemCache

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

20:51:17.489964

trace

system.db.CDbCommand

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

20:51:17.489967

profile

system.db.CDbCommand.query

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

20:51:17.490159

profile

system.db.CDbCommand.query

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

20:51:17.490418

trace

system.CModule

Loading "coupon" application component

20:51:17.490998

trace

system.CModule

Loading "assetManager" application component

20:51:17.491640

trace

system.db.ar.CActiveRecord

DeliveryCalcMain.find()

20:51:17.491816

trace

system.caching.CMemCache

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

20:51:17.491851

trace

system.db.CDbCommand

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

20:51:17.491852

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)

20:51:17.492049

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)

20:51:17.493489

trace

system.CModule

Loading "redisCache" application component

20:51:17.494317

trace

system.caching.CRedisCache

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

20:51:17.494646

trace

system.caching.CRedisCache

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

20:51:17.494752

profile

application

begin:loading session

20:51:17.494755

profile

application

end:loading session

20:51:17.496529

trace

system.CModule

Loading "order" application component

20:51:17.498308

trace

system.CModule

Loading "microdataManager" application component

20:51:17.498778

trace

system.CModule

Loading "clientScript" application component

20:51:17.502522

trace

system.caching.CRedisCache

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

20:51:17.502763

trace

system.caching.CRedisCache

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

20:51:17.504235

trace

system.CModule

Loading "widgetFactory" application component

20:51:17.506308

trace

system.caching.CMemCache

Serving "IWarehouseIWarehouse::getStaticList" from cache

20:51:17.510217

trace

system.caching.CMemCache

Serving "CB:name:top_alert_mobile" from cache

20:51:17.511962

trace

system.caching.CMemCache

Serving "CB:name:bottom_for_buyer_mobile" from cache

20:51:17.512754

trace

system.CModule

Loading "territory" application component

20:51:17.517745

trace

system.caching.CMemCache

Serving "ITerritory3" from cache

20:51:17.517827

trace

system.CModule

Loading "IPropeties" application component

20:51:17.522074

trace

system.caching.CMemCache

Serving "iblock_properties_0" from cache

20:51:17.522442

trace

system.caching.CMemCache

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

20:51:17.524538

trace

system.caching.CMemCache

Serving "iblock_properties_0getPropValues1045" from cache

20:51:17.531352

trace

system.caching.CMemCache

Serving "CB:name:bottom_job_mobile" from cache

20:51:17.532145

trace

system.caching.CMemCache

Serving "CB:name:partners_mobile" from cache

20:51:17.534718

trace

system.db.ar.CActiveRecord

CartUser.find()

20:51:17.534782

trace

system.db.CDbCommand

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

20:51:17.534785

profile

system.db.CDbCommand.query

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

20:51:17.535052

profile

system.db.CDbCommand.query

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

20:51:17.535877

trace

system.db.ar.CActiveRecord

CartUser.find()

20:51:17.535912

trace

system.db.CDbCommand

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

20:51:17.535914

profile

system.db.CDbCommand.query

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

20:51:17.536106

profile

system.db.CDbCommand.query

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

20:51:17.536112

trace

system.db.ar.CActiveRecord

Cart.count()

20:51:17.536314

trace

system.caching.CMemCache

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

20:51:17.536385

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

20:51:17.536386

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)

20:51:17.536564

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)

20:51:17.537647

trace

system.CModule

Loading "yandexEcom" application component

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

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