Выберите город

Подбор запчастей для ROVER

ROVER
Выберите модель
Выберите модификацию
Личный кабинет 0
Общий отчет (Время: 0.67502с, Память: 10,410Кб)
Процедура Номер Всего (с) Средн. (с) Мин. (с) Макс. (с)
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `b_sale_location`) 1 0.00067 0.00067 0.00067 0.00067
loading session 2 0.60180 0.30090 0.00000 0.60180
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.00066 0.00066 0.00066 0.00066
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.00056 0.00056 0.00056 0.00056
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.00052 0.00052 0.00052 0.00052
system.db.CDbCommand.query(SELECT * FROM `b_sale_fuser` `t` WHERE USER_ID=:USER_ID LIMIT 1) 3 0.00051 0.00017 0.00015 0.00018
system.db.CDbCommand.query(SHOW CREATE TABLE `b_sale_location`) 1 0.00033 0.00033 0.00033 0.00033
system.db.CDbCommand.query(SELECT * FROM `cat_manufacturers` `t` WHERE (t.code = :code) AND (t.is_visible = 1) LIMIT 1) 1 0.00030 0.00030 0.00030 0.00030
system.db.CDbCommand.query(SHOW CREATE TABLE `b_sale_location_country`) 1 0.00024 0.00024 0.00024 0.00024
system.db.CDbCommand.execute(DELETE FROM `YiiLog` WHERE 0=1) 1 0.00023 0.00023 0.00023 0.00023
system.db.CDbCommand.query(SELECT * FROM `sp_locations` `t` WHERE `t`.`id`='' LIMIT 1) 1 0.00023 0.00023 0.00023 0.00023
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.00021 0.00021 0.00021 0.00021
system.db.CDbCommand.query(SHOW CREATE TABLE `b_sale_location_city`) 1 0.00021 0.00021 0.00021 0.00021
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 * FROM `sp_delivery_calc_main` `t` WHERE t.location_id = :location_id LIMIT 1) 1 0.00016 0.00016 0.00016 0.00016
Журнал приложения
Время Уровень Категория Сообщение
07:38:42.867769 trace system.CModule
Loading "log" application component
07:38:42.869911 trace glitchtip_fallback
The "Sentry\Integration\RequestIntegration,
Sentry\Integration\TransactionIntegration,
Sentry\Integration\FrameContextifierIntegration,
Sentry\Integration\EnvironmentIntegration" integration(s) have been
installed.
07:38:42.870099 trace system.CModule
Loading "db" application component
07:38:42.870151 trace system.db.CDbConnection
Opening DB connection
07:38:42.871287 trace system.db.CDbCommand
Executing SQL: DELETE FROM `YiiLog` WHERE 0=1
07:38:42.871292 profile system.db.CDbCommand.execute
begin:system.db.CDbCommand.execute(DELETE FROM `YiiLog` WHERE 0=1)
07:38:42.871520 profile system.db.CDbCommand.execute
end:system.db.CDbCommand.execute(DELETE FROM `YiiLog` WHERE 0=1)
07:38:42.871722 trace system.CModule
Loading "urlHelper" application component
07:38:42.871820 trace system.CModule
Loading "DBConfig" application component
07:38:42.871860 trace system.CModule
Loading "cache" application component
07:38:42.872764 trace system.caching.CMemCache
Serving "66307959e0460a2e2436b0319b2fda14" from cache
07:38:42.873212 trace system.CModule
Loading "geo" application component
07:38:42.873305 trace system.CModule
Loading "request" application component
07:38:42.873850 trace system.db.CDbCommand
Querying SQL: SHOW FULL COLUMNS FROM `b_sale_location`
07:38:42.873857 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `b_sale_location`)
07:38:42.874530 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `b_sale_location`)
07:38:42.874696 trace system.db.CDbCommand
Querying SQL: SHOW CREATE TABLE `b_sale_location`
07:38:42.874701 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SHOW CREATE TABLE `b_sale_location`)
07:38:42.875034 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SHOW CREATE TABLE `b_sale_location`)
07:38:42.875046 trace system.caching.CMemCache
Saving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:b_sale_location"
to cache
07:38:42.875323 trace system.db.ar.CActiveRecord
Location.findByPk()
07:38:42.875680 trace system.db.CDbCommand
Querying SQL: SHOW FULL COLUMNS FROM `b_sale_location_city`
07:38:42.875684 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SHOW FULL COLUMNS FROM
`b_sale_location_city`)
07:38:42.876205 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SHOW FULL COLUMNS FROM
`b_sale_location_city`)
07:38:42.876259 trace system.db.CDbCommand
Querying SQL: SHOW CREATE TABLE `b_sale_location_city`
07:38:42.876260 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SHOW CREATE TABLE `b_sale_location_city`)
07:38:42.876466 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SHOW CREATE TABLE `b_sale_location_city`)
07:38:42.876473 trace system.caching.CMemCache
Saving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:b_sale_location_city"
to cache
07:38:42.876785 trace system.db.CDbCommand
Querying SQL: SHOW FULL COLUMNS FROM `b_sale_location_country`
07:38:42.876789 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SHOW FULL COLUMNS FROM
`b_sale_location_country`)
07:38:42.877331 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SHOW FULL COLUMNS FROM
`b_sale_location_country`)
07:38:42.877372 trace system.db.CDbCommand
Querying SQL: SHOW CREATE TABLE `b_sale_location_country`
07:38:42.877374 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SHOW CREATE TABLE
`b_sale_location_country`)
07:38:42.877616 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SHOW CREATE TABLE `b_sale_location_country`)
07:38:42.877624 trace system.caching.CMemCache
Saving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:b_sale_location_country"
to cache
07:38:42.877923 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
07:38:42.877926 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)
07:38:42.878139 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)
07:38:42.878307 trace system.CModule
Loading "user" application component
07:38:42.878421 profile application
begin:loading session
07:38:42.878426 trace system.CModule
Loading "session" application component
07:38:43.480218 profile application
end:loading session
07:38:43.480619 trace system.db.ar.CActiveRecord
OutLocation.findByPk()
07:38:43.480803 trace system.caching.CMemCache
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:sp_locations"
from cache
07:38:43.480873 trace system.db.CDbCommand
Querying SQL: SELECT * FROM `sp_locations` `t` WHERE `t`.`id`='' LIMIT 1
07:38:43.480875 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT * FROM `sp_locations` `t` WHERE
`t`.`id`='' LIMIT 1)
07:38:43.481101 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT * FROM `sp_locations` `t` WHERE
`t`.`id`='' LIMIT 1)
07:38:43.481185 trace system.CModule
Loading "B2BConfig" application component
07:38:43.481246 trace system.CModule
Loading "urlManager" application component
07:38:43.482323 trace system.caching.CMemCache
Serving "Yii.CUrlManager.rules" from cache
07:38:43.482472 trace system.base.CModule
Loading "cat" module
07:38:43.482985 trace system.CModule
Loading "themeInterlayer" application component
07:38:43.483247 trace system.CModule
Loading "themeManager" application component
07:38:43.485632 trace system.CModule
Loading "cart" application component
07:38:43.485729 trace system.db.ar.CActiveRecord
CartUser.find()
07:38:43.485869 trace system.caching.CMemCache
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:b_sale_fuser"
from cache
07:38:43.485905 trace system.db.CDbCommand
Querying SQL: SELECT * FROM `b_sale_fuser` `t` WHERE USER_ID=:USER_ID LIMIT
1
07:38:43.485908 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT * FROM `b_sale_fuser` `t` WHERE
USER_ID=:USER_ID LIMIT 1)
07:38:43.486090 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT * FROM `b_sale_fuser` `t` WHERE
USER_ID=:USER_ID LIMIT 1)
07:38:43.486283 trace system.CModule
Loading "coupon" application component
07:38:43.486483 trace system.CModule
Loading "assetManager" application component
07:38:43.486639 trace system.db.ar.CActiveRecord
DeliveryCalcMain.find()
07:38:43.486788 trace system.caching.CMemCache
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:sp_delivery_calc_main"
from cache
07:38:43.486821 trace system.db.CDbCommand
Querying SQL: SELECT * FROM `sp_delivery_calc_main` `t` WHERE t.location_id
= :location_id LIMIT 1
07:38:43.486824 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)
07:38:43.486987 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)
07:38:43.488240 trace system.CModule
Loading "redisCache" application component
07:38:43.489037 trace system.caching.CRedisCache
Serving "sberid_AA\Service\OAuth\Clients\SberIdClient_sberid_authState"
from cache
07:38:43.489403 trace system.caching.CRedisCache
Serving "sberid_AA\Service\OAuth\Clients\SberIdClient_sberid_authState"
from cache
07:38:43.489516 profile application
begin:loading session
07:38:43.489518 profile application
end:loading session
07:38:43.491148 trace system.CModule
Loading "order" application component
07:38:43.491525 trace system.caching.CMemCache
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:cat_manufacturers"
from cache
07:38:43.491549 trace system.db.ar.CActiveRecord
CatManufacturer.find()
07:38:43.491589 trace system.db.CDbCommand
Querying SQL: SELECT * FROM `cat_manufacturers` `t` WHERE (t.code = :code)
AND (t.is_visible = 1) LIMIT 1
07:38:43.491590 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)
07:38:43.491890 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)
07:38:43.492153 trace system.caching.CMemCache
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:cat_models"
from cache
07:38:43.492203 trace system.db.ar.CActiveRecord
CatModel.findAll()
07:38:43.492516 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
07:38:43.492520 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)
07:38:43.493176 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)
07:38:43.493496 trace system.db.ar.CActiveRecord
CatModel.findAll()
07:38:43.493534 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
07:38:43.493536 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)
07:38:43.494098 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)
07:38:43.494613 trace system.CModule
Loading "widgetFactory" application component
07:38:43.495702 trace system.CModule
Loading "coreMessages" application component
07:38:43.498979 trace system.CModule
Loading "microdataManager" application component
07:38:43.499123 trace system.CModule
Loading "clientScript" application component
07:38:43.505350 trace system.caching.CMemCache
Serving "IWarehouseIWarehouse::getStaticList" from cache
07:38:43.509150 trace system.caching.CMemCache
Serving "CB:name:top_alert_mobile" from cache
07:38:43.510982 trace system.caching.CMemCache
Serving "CB:name:bottom_for_buyer_mobile" from cache
07:38:43.511841 trace system.CModule
Loading "territory" application component
07:38:43.516009 trace system.caching.CMemCache
Serving "ITerritory3" from cache
07:38:43.516068 trace system.CModule
Loading "IPropeties" application component
07:38:43.519521 trace system.caching.CMemCache
Serving "iblock_properties_0" from cache
07:38:43.519886 trace system.caching.CMemCache
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:b_iblock_element"
from cache
07:38:43.522142 trace system.caching.CMemCache
Serving "iblock_properties_0getPropValues1045" from cache
07:38:43.530479 trace system.caching.CMemCache
Serving "CB:name:bottom_job_mobile" from cache
07:38:43.531418 trace system.caching.CMemCache
Serving "CB:name:partners_mobile" from cache
07:38:43.534133 trace system.db.ar.CActiveRecord
CartUser.find()
07:38:43.534179 trace system.db.CDbCommand
Querying SQL: SELECT * FROM `b_sale_fuser` `t` WHERE USER_ID=:USER_ID LIMIT
1
07:38:43.534183 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT * FROM `b_sale_fuser` `t` WHERE
USER_ID=:USER_ID LIMIT 1)
07:38:43.534362 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT * FROM `b_sale_fuser` `t` WHERE
USER_ID=:USER_ID LIMIT 1)
07:38:43.534507 trace system.db.ar.CActiveRecord
CartUser.find()
07:38:43.534539 trace system.db.CDbCommand
Querying SQL: SELECT * FROM `b_sale_fuser` `t` WHERE USER_ID=:USER_ID LIMIT
1
07:38:43.534543 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT * FROM `b_sale_fuser` `t` WHERE
USER_ID=:USER_ID LIMIT 1)
07:38:43.534688 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT * FROM `b_sale_fuser` `t` WHERE
USER_ID=:USER_ID LIMIT 1)
07:38:43.534696 trace system.db.ar.CActiveRecord
Cart.count()
07:38:43.534915 trace system.caching.CMemCache
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:b_sale_basket"
from cache
07:38:43.534985 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
07:38:43.534987 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)
07:38:43.535166 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)
07:38:43.536334 trace system.CModule
Loading "yandexEcom" application component