Личный кабинетВход
Выберите город
Что с моим заказом?
Магазины и партнёры
Доставка
Консультируем и принимаем заказы с 9:00 до 22:00 (MSK) по бесплатному телефону
8 800 6006 966
Полная версия сайта
Главная   Обзоры   Доработка диагностики / Китаец тоже машина!
Пишите обзоры — зарабатывайте деньги!
1 место — 15 000 ₽ 2 место — 10 000 ₽ 3 место — 5 000 ₽
+ 1 000 ₽ каждому!
Подробнее →

Доработка диагностики / Китаец тоже машина!

Автор: Evil_Smile
1303
Обсудить

Немножко из мира автолюбителей нестандартных решений.

Каждый из автовладельцев мечтает знать свой автомобиль наизусть, но не каждый может и имеет определённые знания. Очень многие автосервисы пользуются этим и накручивают спектр услуг поднимая цену. А что делать? Пора платить! Именно в такой ситуации, хоть раз, но был каждый из нас. Я не говорю про честные сервисы в которых работают люди и делают всё на высшем уровне, ведь за это можно и непожалеть больших денег. Найти хороший сервис трудно, проще получить некий спектр знаний!


Первым делом нужно научится диагностировать свой автомобиль и выявлять причину. Как это сделать? Я смогу? Даже маленький ребёнок, который умеет пользоваться интернетом может легко произвести диагностику. Достаточно вбить в поиске вопрос и получить ответ. Сегодня расскажу как подключить диагностику ELM327 к двигателю автомобиля Chery Amulet A15.


Диагностировать двигатель данного автомобиля довольно просто, что не сказать про систему ABS и AirBag. Производители не всех сканеров берут данную ошибку в этом автомобиле и найдено решение Vag 409.1 на чипе FTDI с доработкой контактов. Начн?м с доработки OBD2!



Многие лезут в разъём OBD2, который находится под рулём в салоне автомобиля. Как раз этот разъём отвечает за AirBag и ABS. А вот про сканировать ошибки двигателя придется лезть под капот. Сама фишка разъёма диагностики находится за расширительным бачком. Конечно проще купить переходник, но постоянно лазить под капот, особенно в дождь не удобно.


Что потребуется?

  1. Разъем OBDII 16-ти контактный ЕВРО 3 (арт. 788787)
  2. Держатель предохранителя (арт. 7112)
  3. Предохранитель 5А (арт. 145168)
  4. Провод 0,75 — желательно 3 цвета (арт. 560839, 471822, 471823)



Схема подключения: Все пины подписаны на OBDII.

1) Далее кидаем "+" с аккумулятора на предохранитель 5А, тем самым защитим нашу ELM327. А уже от предохранителя на 16 пин.

2) Минус от аккумулятора кидаем на 4 пин.


3) Далее берём диагностический разъём и как показано на схеме, обрезаем провод. Прикручиваем к нему белый провод и кидаем на 7 пин.


Наш разъём для диагностики полностью готов! Для удобства проведите провода в салон и закрепите новый OBD2 в удобном для Вас месте.


Какой сканер я использую для диагностики? Есть две версии Elm327: советую v1.5 (Оригинальная), сканирует практически все автомобили, а вот v2.1 (Китаец) например не смогла подключиться к старому автомобилю ВАЗ 2115. И как немного внетреностей данных диагностических сканеров, чтобы раз лечить их.

Самая лучшая программа для диагностики, с которой я работаю InCarDoc. Так как OpenDiag и прочие программы не работают в данном автомобиле.

Награды у обзора:
2

Комментарии

Чтобы написать комментарий, вам необходимо авторизоваться

Товары, участвующие в обзоре

Разъем диагностики 16-ти контактная ЕВРО-3 CARGEN
540 ₽
Чтобы добавить реакцию, необходимо
авторизоваться/зарегистрироваться
на сайте
Чтобы посмотреть профиль автора, необходимо
авторизоваться/зарегистрироваться
на сайте
Личный кабинет 0
Общий отчет (Время: 0.57509с, Память: 20,330Кб)
Процедура Номер Всего (с) Средн. (с) Мин. (с) Макс. (с)
loading session 2 0.45301 0.22651 0.00000 0.45301
system.db.CDbCommand.query(SELECT * FROM `sp_locations` `t` WHERE `t`.`id`='' LIMIT 1) 1 0.00031 0.00031 0.00031 0.00031
system.db.CDbCommand.query(SELECT * FROM `b_sale_fuser` `t` WHERE USER_ID=:USER_ID LIMIT 1) 3 0.00239 0.00080 0.00023 0.00192
system.db.CDbCommand.query(SELECT * FROM `sp_comments` `t` WHERE (t.entity_id=:reviewId) AND (t.status_id=:statusId)) 1 0.00168 0.00168 0.00168 0.00168
system.db.CDbCommand.execute(DELETE FROM `YiiLog` WHERE 0=1) 1 0.00026 0.00026 0.00026 0.00026
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.00023 0.00023 0.00023 0.00023
system.db.CDbCommand.query(SELECT * FROM `sp_reviews` `t` WHERE seo_url=:seoUrl LIMIT 1) 1 0.00469 0.00469 0.00469 0.00469
system.db.CDbCommand.query(SELECT * FROM `sp_review_images` `t` WHERE REVIEW_ID=:reviewId) 1 0.00401 0.00401 0.00401 0.00401
system.db.CDbCommand.query(SELECT `product`.`ID` AS `t1_c0`, `product`.`TIMESTAMP_X` AS `t1_c1`, `product`.`MODIFIED_BY` AS `t1_c2`, `product`.`DATE_CREATE` AS `t1_c3`, `product`.`CREATED_BY` AS `t1_c4`, `product`.`IBLOCK_ID` AS `t1_c5`, `product`.`IBLOCK_SECTION_ID` AS `t1_c6`, `product`.`ACTIVE` AS `t1_c7`, `product`.`ACTIVE_FROM` AS `t1_c8`, `product`.`ACTIVE_TO` AS `t1_c9`, `product`.`SORT` AS `t1_c10`, `product`.`NAME` AS `t1_c11`, `product`.`PREVIEW_PICTURE` AS `t1_c12`, `product`.`PREVIEW_TEXT` AS `t1_c13`, `product`.`PREVIEW_TEXT_TYPE` AS `t1_c14`, `product`.`DETAIL_PICTURE` AS `t1_c15`, `product`.`DETAIL_TEXT` AS `t1_c16`, `product`.`DETAIL_TEXT_TYPE` AS `t1_c17`, `product`.`SEARCHABLE_CONTENT` AS `t1_c18`, `product`.`WF_STATUS_ID` AS `t1_c19`, `product`.`WF_PARENT_ELEMENT_ID` AS `t1_c20`, `product`.`WF_NEW` AS `t1_c21`, `product`.`WF_LOCKED_BY` AS `t1_c22`, `product`.`WF_DATE_LOCK` AS `t1_c23`, `product`.`WF_COMMENTS` AS `t1_c24`, `product`.`IN_SECTIONS` AS `t1_c25`, `product`.`XML_ID` AS `t1_c26`, `product`.`CODE` AS `t1_c27`, `product`.`TAGS` AS `t1_c28`, `product`.`TMP_ID` AS `t1_c29`, `product`.`WF_LAST_HISTORY_ID` AS `t1_c30`, `product`.`SHOW_COUNTER` AS `t1_c31`, `product`.`SHOW_COUNTER_START` AS `t1_c32` FROM `b_iblock_element` `product` INNER JOIN `sp_review_product` `goods_product` ON (`goods_product`.`review_id`=:ypl0) AND (`product`.`ID`=`goods_product`.`product_id`) AND (product.IBLOCK_ID = 24)) 1 0.00089 0.00089 0.00089 0.00089
system.db.CDbCommand.execute(UPDATE `sp_reviews` SET `id`=:yp0, `user_id`=:yp1, `seo_url`=:yp2, `type_id`=:yp3, `status_id`=:yp4, `meta_title`=:yp5, `meta_description`=:yp6, `title`=:yp7, `preview`=:yp8, `content`=:yp9, `views`=:yp10, `created_at`=:yp11, `updated_at`=:yp12, `published_at`=:yp13, `state_change_reason`=:yp14, `real_views`=:yp15, `question`=:yp16 WHERE `sp_reviews`.`id`='7648') 1 0.00081 0.00081 0.00081 0.00081
system.db.CDbCommand.query(SELECT `user`.`ID` AS `t1_c0`, `user`.`TIMESTAMP_X` AS `t1_c1`, `user`.`LOGIN` AS `t1_c2`, `user`.`PASSWORD` AS `t1_c3`, `user`.`CHECKWORD` AS `t1_c4`, `user`.`ACTIVE` AS `t1_c5`, `user`.`NAME` AS `t1_c6`, `user`.`LAST_NAME` AS `t1_c7`, `user`.`EMAIL` AS `t1_c8`, `user`.`LAST_LOGIN` AS `t1_c9`, `user`.`DATE_REGISTER` AS `t1_c10`, `user`.`LID` AS `t1_c11`, `user`.`PERSONAL_PROFESSION` AS `t1_c12`, `user`.`PERSONAL_WWW` AS `t1_c13`, `user`.`PERSONAL_ICQ` AS `t1_c14`, `user`.`PERSONAL_GENDER` AS `t1_c15`, `user`.`PERSONAL_BIRTHDATE` AS `t1_c16`, `user`.`PERSONAL_PHOTO` AS `t1_c17`, `user`.`PERSONAL_PHONE` AS `t1_c18`, `user`.`PERSONAL_FAX` AS `t1_c19`, `user`.`PERSONAL_MOBILE` AS `t1_c20`, `user`.`PERSONAL_PAGER` AS `t1_c21`, `user`.`PERSONAL_STREET` AS `t1_c22`, `user`.`PERSONAL_MAILBOX` AS `t1_c23`, `user`.`PERSONAL_CITY` AS `t1_c24`, `user`.`PERSONAL_STATE` AS `t1_c25`, `user`.`PERSONAL_ZIP` AS `t1_c26`, `user`.`PERSONAL_COUNTRY` AS `t1_c27`, `user`.`PERSONAL_NOTES` AS `t1_c28`, `user`.`WORK_COMPANY` AS `t1_c29`, `user`.`WORK_DEPARTMENT` AS `t1_c30`, `user`.`WORK_POSITION` AS `t1_c31`, `user`.`WORK_WWW` AS `t1_c32`, `user`.`WORK_PHONE` AS `t1_c33`, `user`.`WORK_FAX` AS `t1_c34`, `user`.`WORK_PAGER` AS `t1_c35`, `user`.`WORK_STREET` AS `t1_c36`, `user`.`WORK_MAILBOX` AS `t1_c37`, `user`.`WORK_CITY` AS `t1_c38`, `user`.`WORK_STATE` AS `t1_c39`, `user`.`WORK_ZIP` AS `t1_c40`, `user`.`WORK_COUNTRY` AS `t1_c41`, `user`.`WORK_PROFILE` AS `t1_c42`, `user`.`WORK_LOGO` AS `t1_c43`, `user`.`WORK_NOTES` AS `t1_c44`, `user`.`ADMIN_NOTES` AS `t1_c45`, `user`.`STORED_HASH` AS `t1_c46`, `user`.`XML_ID` AS `t1_c47`, `user`.`PERSONAL_BIRTHDAY` AS `t1_c48`, `user`.`EXTERNAL_AUTH_ID` AS `t1_c49`, `user`.`CHECKWORD_TIME` AS `t1_c50`, `user`.`SECOND_NAME` AS `t1_c51`, `user`.`CONFIRM_CODE` AS `t1_c52`, `user`.`LOGIN_ATTEMPTS` AS `t1_c53`, `user`.`LAST_ACTIVITY_DATE` AS `t1_c54`, `user`.`_sendMerge` AS `t1_c55`, `user`.`_sendInfo` AS `t1_c56`, `user`.`unread_ticket_msg` AS `t1_c57`, `user`.`unread_vin_msg` AS `t1_c58`, `user`.`inn` AS `t1_c59` FROM `b_user` `user` WHERE (`user`.`ID`=:ypl0)) 1 0.00061 0.00061 0.00061 0.00061
system.db.CDbCommand.query(SELECT `profile`.`user_id` AS `t1_c0`, `profile`.`nickname` AS `t1_c1`, `profile`.`avatar_filename` AS `t1_c2`, `profile`.`bio` AS `t1_c3`, `profile`.`experience` AS `t1_c4`, `profile`.`level` AS `t1_c5`, `profile`.`internal_rating` AS `t1_c6`, `profile`.`created_at` AS `t1_c7`, `profile`.`updated_at` AS `t1_c8` FROM `sp_user_social_profiles` `profile` WHERE (`profile`.`user_id`=:ypl0)) 2 0.00054 0.00027 0.00020 0.00035
system.db.CDbCommand.query(SELECT `ms`.`ELEMENT_ID` AS `t1_c0`, `ms`.`SECTION_ID` AS `t1_c1`, `ms`.`IBLOCK_ID` AS `t1_c2`, `ms`.`NUM` AS `t1_c3` FROM `sp_catalog2msections` `ms` WHERE (ms.IBLOCK_ID = 49) AND (`ms`.`ELEMENT_ID`=:ypl0)) 1 0.00046 0.00046 0.00046 0.00046
system.db.CDbCommand.query(SELECT * FROM `sp_achievements` `t` WHERE entity_id=:reviewId) 1 0.00039 0.00039 0.00039 0.00039
system.db.CDbCommand.query(SELECT `r`.`entity_id` AS `t1_c0`, `r`.`entity_type` AS `t1_c1`, `r`.`user_id` AS `t1_c2`, `r`.`reaction_type` AS `t1_c3`, `r`.`created_at` AS `t1_c4` FROM `sp_reactions` `r` WHERE (r.entity_type=:entityType) AND (`r`.`entity_id`=:ypl0)) 1 0.00036 0.00036 0.00036 0.00036
system.db.CDbCommand.query(SELECT `pp`.`ID` AS `t1_c0`, `pp`.`TIMESTAMP_X` AS `t1_c1`, `pp`.`MODULE_ID` AS `t1_c2`, `pp`.`HEIGHT` AS `t1_c3`, `pp`.`WIDTH` AS `t1_c4`, `pp`.`FILE_SIZE` AS `t1_c5`, `pp`.`CONTENT_TYPE` AS `t1_c6`, `pp`.`SUBDIR` AS `t1_c7`, `pp`.`FILE_NAME` AS `t1_c8`, `pp`.`ORIGINAL_NAME` AS `t1_c9`, `pp`.`DESCRIPTION` AS `t1_c10` FROM `b_file` `pp` WHERE (`pp`.`ID`=:ypl0)) 1 0.00034 0.00034 0.00034 0.00034
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.00025 0.00025 0.00025 0.00025
system.db.CDbCommand.query(SELECT * FROM `sp_delivery_calc_main` `t` WHERE t.location_id = :location_id LIMIT 1) 1 0.00022 0.00022 0.00022 0.00022
Журнал приложения
Время Уровень Категория Сообщение
05:44:17.008673 trace system.CModule 
Loading "log" application component
05:44:17.013735 trace glitchtip_fallback 
The "Sentry\Integration\RequestIntegration,
Sentry\Integration\TransactionIntegration,
Sentry\Integration\FrameContextifierIntegration,
Sentry\Integration\EnvironmentIntegration" integration(s) have been
installed.
05:44:17.014034 trace system.CModule 
Loading "db" application component
05:44:17.014107 trace system.db.CDbConnection 
Opening DB connection
05:44:17.015194 trace system.db.CDbCommand 
Executing SQL: DELETE FROM `YiiLog` WHERE 0=1
05:44:17.015230 profile system.db.CDbCommand.execute 
begin:system.db.CDbCommand.execute(DELETE FROM `YiiLog` WHERE 0=1)
05:44:17.015486 profile system.db.CDbCommand.execute 
end:system.db.CDbCommand.execute(DELETE FROM `YiiLog` WHERE 0=1)
05:44:17.015714 trace system.CModule 
Loading "urlHelper" application component
05:44:17.015837 trace system.CModule 
Loading "DBConfig" application component
05:44:17.015875 trace system.CModule 
Loading "cache" application component
05:44:17.016767 trace system.caching.CMemCache 
Serving "66307959e0460a2e2436b0319b2fda14" from cache
05:44:17.017163 trace system.CModule 
Loading "geo" application component
05:44:17.017245 trace system.CModule 
Loading "request" application component
05:44:17.017847 trace system.caching.CMemCache 
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:b_sale_location"
from cache
05:44:17.017930 trace system.db.ar.CActiveRecord 
Location.findByPk()
05:44:17.018390 trace system.caching.CMemCache 
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:b_sale_location_city"
from cache
05:44:17.018670 trace system.caching.CMemCache 
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:b_sale_location_country"
from cache
05:44:17.018898 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
05:44:17.018903 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)
05:44:17.019133 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)
05:44:17.019367 trace system.CModule 
Loading "user" application component
05:44:17.019531 profile application 
begin:loading session
05:44:17.019539 trace system.CModule 
Loading "session" application component
05:44:17.472539 profile application 
end:loading session
05:44:17.473115 trace system.db.ar.CActiveRecord 
OutLocation.findByPk()
05:44:17.473289 trace system.caching.CMemCache 
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:sp_locations"
from cache
05:44:17.473367 trace system.db.CDbCommand 
Querying SQL: SELECT * FROM `sp_locations` `t` WHERE `t`.`id`='' LIMIT 1
05:44:17.473371 profile system.db.CDbCommand.query 
begin:system.db.CDbCommand.query(SELECT * FROM `sp_locations` `t` WHERE
`t`.`id`='' LIMIT 1)
05:44:17.473684 profile system.db.CDbCommand.query 
end:system.db.CDbCommand.query(SELECT * FROM `sp_locations` `t` WHERE
`t`.`id`='' LIMIT 1)
05:44:17.473772 trace system.CModule 
Loading "B2BConfig" application component
05:44:17.473835 trace system.CModule 
Loading "urlManager" application component
05:44:17.476147 trace system.caching.CMemCache 
Serving "Yii.CUrlManager.rules" from cache
05:44:17.477372 trace system.CModule 
Loading "themeInterlayer" application component
05:44:17.477682 trace system.CModule 
Loading "themeManager" application component
05:44:17.480854 trace system.CModule 
Loading "cart" application component
05:44:17.480963 trace system.db.ar.CActiveRecord 
CartUser.find()
05:44:17.481144 trace system.caching.CMemCache 
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:b_sale_fuser"
from cache
05:44:17.481194 trace system.db.CDbCommand 
Querying SQL: SELECT * FROM `b_sale_fuser` `t` WHERE USER_ID=:USER_ID LIMIT
1
05:44:17.481198 profile system.db.CDbCommand.query 
begin:system.db.CDbCommand.query(SELECT * FROM `b_sale_fuser` `t` WHERE
USER_ID=:USER_ID LIMIT 1)
05:44:17.481437 profile system.db.CDbCommand.query 
end:system.db.CDbCommand.query(SELECT * FROM `b_sale_fuser` `t` WHERE
USER_ID=:USER_ID LIMIT 1)
05:44:17.481654 trace system.CModule 
Loading "coupon" application component
05:44:17.481861 trace system.CModule 
Loading "assetManager" application component
05:44:17.482069 trace system.db.ar.CActiveRecord 
DeliveryCalcMain.find()
05:44:17.482482 trace system.caching.CMemCache 
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:sp_delivery_calc_main"
from cache
05:44:17.482522 trace system.db.CDbCommand 
Querying SQL: SELECT * FROM `sp_delivery_calc_main` `t` WHERE t.location_id
= :location_id LIMIT 1
05:44:17.482523 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)
05:44:17.482742 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)
05:44:17.487478 trace system.CModule 
Loading "redisCache" application component
05:44:17.488822 trace system.caching.CRedisCache 
Serving "sberid_AA\Service\OAuth\Clients\SberIdClient_sberid_authState"
from cache
05:44:17.491278 trace system.caching.CRedisCache 
Serving "sberid_AA\Service\OAuth\Clients\SberIdClient_sberid_authState"
from cache
05:44:17.491413 profile application 
begin:loading session
05:44:17.491416 profile application 
end:loading session
05:44:17.493940 trace system.CModule 
Loading "order" application component
05:44:17.494462 trace system.db.ar.CActiveRecord 
ReviewModel.find()
05:44:17.494683 trace system.caching.CMemCache 
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:sp_reviews"
from cache
05:44:17.494910 trace system.db.CDbCommand 
Querying SQL: SELECT * FROM `sp_reviews` `t` WHERE seo_url=:seoUrl LIMIT 1
05:44:17.494916 profile system.db.CDbCommand.query 
begin:system.db.CDbCommand.query(SELECT * FROM `sp_reviews` `t` WHERE
seo_url=:seoUrl LIMIT 1)
05:44:17.499610 profile system.db.CDbCommand.query 
end:system.db.CDbCommand.query(SELECT * FROM `sp_reviews` `t` WHERE
seo_url=:seoUrl LIMIT 1)
05:44:17.499819 trace system.db.ar.CActiveRecord 
ReviewModel.update()
05:44:17.499835 trace system.db.ar.CActiveRecord 
ReviewModel.updateByPk()
05:44:17.500001 trace system.db.CDbCommand 
Executing SQL: UPDATE `sp_reviews` SET `id`=:yp0, `user_id`=:yp1,
`seo_url`=:yp2, `type_id`=:yp3, `status_id`=:yp4, `meta_title`=:yp5,
`meta_description`=:yp6, `title`=:yp7, `preview`=:yp8, `content`=:yp9,
`views`=:yp10, `created_at`=:yp11, `updated_at`=:yp12,
`published_at`=:yp13, `state_change_reason`=:yp14, `real_views`=:yp15,
`question`=:yp16 WHERE `sp_reviews`.`id`='7648'
05:44:17.500005 profile system.db.CDbCommand.execute 
begin:system.db.CDbCommand.execute(UPDATE `sp_reviews` SET `id`=:yp0,
`user_id`=:yp1, `seo_url`=:yp2, `type_id`=:yp3, `status_id`=:yp4,
`meta_title`=:yp5, `meta_description`=:yp6, `title`=:yp7, `preview`=:yp8,
`content`=:yp9, `views`=:yp10, `created_at`=:yp11, `updated_at`=:yp12,
`published_at`=:yp13, `state_change_reason`=:yp14, `real_views`=:yp15,
`question`=:yp16 WHERE `sp_reviews`.`id`='7648')
05:44:17.500813 profile system.db.CDbCommand.execute 
end:system.db.CDbCommand.execute(UPDATE `sp_reviews` SET `id`=:yp0,
`user_id`=:yp1, `seo_url`=:yp2, `type_id`=:yp3, `status_id`=:yp4,
`meta_title`=:yp5, `meta_description`=:yp6, `title`=:yp7, `preview`=:yp8,
`content`=:yp9, `views`=:yp10, `created_at`=:yp11, `updated_at`=:yp12,
`published_at`=:yp13, `state_change_reason`=:yp14, `real_views`=:yp15,
`question`=:yp16 WHERE `sp_reviews`.`id`='7648')
05:44:17.501068 trace system.db.ar.CActiveRecord 
ReviewImages.findAll()
05:44:17.501437 trace system.caching.CMemCache 
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:sp_review_images"
from cache
05:44:17.501477 trace system.db.CDbCommand 
Querying SQL: SELECT * FROM `sp_review_images` `t` WHERE
REVIEW_ID=:reviewId
05:44:17.501480 profile system.db.CDbCommand.query 
begin:system.db.CDbCommand.query(SELECT * FROM `sp_review_images` `t` WHERE
REVIEW_ID=:reviewId)
05:44:17.505491 profile system.db.CDbCommand.query 
end:system.db.CDbCommand.query(SELECT * FROM `sp_review_images` `t` WHERE
REVIEW_ID=:reviewId)
05:44:17.505820 trace system.db.ar.CActiveRecord 
CommentModel.findAll()
05:44:17.506032 trace system.caching.CMemCache 
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:sp_comments"
from cache
05:44:17.506108 trace system.db.CDbCommand 
Querying SQL: SELECT * FROM `sp_comments` `t` WHERE (t.entity_id=:reviewId)
AND (t.status_id=:statusId)
05:44:17.506112 profile system.db.CDbCommand.query 
begin:system.db.CDbCommand.query(SELECT * FROM `sp_comments` `t` WHERE
(t.entity_id=:reviewId) AND (t.status_id=:statusId))
05:44:17.507793 profile system.db.CDbCommand.query 
end:system.db.CDbCommand.query(SELECT * FROM `sp_comments` `t` WHERE
(t.entity_id=:reviewId) AND (t.status_id=:statusId))
05:44:17.508069 trace system.db.ar.CActiveRecord 
AchievementsModel.findAll()
05:44:17.508249 trace system.caching.CMemCache 
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:sp_achievements"
from cache
05:44:17.508286 trace system.db.CDbCommand 
Querying SQL: SELECT * FROM `sp_achievements` `t` WHERE entity_id=:reviewId
05:44:17.508290 profile system.db.CDbCommand.query 
begin:system.db.CDbCommand.query(SELECT * FROM `sp_achievements` `t` WHERE
entity_id=:reviewId)
05:44:17.508678 profile system.db.CDbCommand.query 
end:system.db.CDbCommand.query(SELECT * FROM `sp_achievements` `t` WHERE
entity_id=:reviewId)
05:44:17.508723 trace system.db.ar.CActiveRecord 
lazy loading ReviewModel.goods
05:44:17.509124 trace system.caching.CMemCache 
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:b_iblock_element"
from cache
05:44:17.509414 trace system.caching.CMemCache 
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:sp_review_product"
from cache
05:44:17.509469 trace system.db.CDbCommand 
Querying SQL: SELECT `product`.`ID` AS `t1_c0`, `product`.`TIMESTAMP_X` AS
`t1_c1`, `product`.`MODIFIED_BY` AS `t1_c2`, `product`.`DATE_CREATE` AS
`t1_c3`, `product`.`CREATED_BY` AS `t1_c4`, `product`.`IBLOCK_ID` AS
`t1_c5`, `product`.`IBLOCK_SECTION_ID` AS `t1_c6`, `product`.`ACTIVE` AS
`t1_c7`, `product`.`ACTIVE_FROM` AS `t1_c8`, `product`.`ACTIVE_TO` AS
`t1_c9`, `product`.`SORT` AS `t1_c10`, `product`.`NAME` AS `t1_c11`,
`product`.`PREVIEW_PICTURE` AS `t1_c12`, `product`.`PREVIEW_TEXT` AS
`t1_c13`, `product`.`PREVIEW_TEXT_TYPE` AS `t1_c14`,
`product`.`DETAIL_PICTURE` AS `t1_c15`, `product`.`DETAIL_TEXT` AS
`t1_c16`, `product`.`DETAIL_TEXT_TYPE` AS `t1_c17`,
`product`.`SEARCHABLE_CONTENT` AS `t1_c18`, `product`.`WF_STATUS_ID` AS
`t1_c19`, `product`.`WF_PARENT_ELEMENT_ID` AS `t1_c20`, `product`.`WF_NEW`
AS `t1_c21`, `product`.`WF_LOCKED_BY` AS `t1_c22`, `product`.`WF_DATE_LOCK`
AS `t1_c23`, `product`.`WF_COMMENTS` AS `t1_c24`, `product`.`IN_SECTIONS`
AS `t1_c25`, `product`.`XML_ID` AS `t1_c26`, `product`.`CODE` AS `t1_c27`,
`product`.`TAGS` AS `t1_c28`, `product`.`TMP_ID` AS `t1_c29`,
`product`.`WF_LAST_HISTORY_ID` AS `t1_c30`, `product`.`SHOW_COUNTER` AS
`t1_c31`, `product`.`SHOW_COUNTER_START` AS `t1_c32` FROM
`b_iblock_element` `product`  INNER JOIN `sp_review_product`
`goods_product` ON (`goods_product`.`review_id`=:ypl0) AND
(`product`.`ID`=`goods_product`.`product_id`) AND (product.IBLOCK_ID = 24)
05:44:17.509473 profile system.db.CDbCommand.query 
begin:system.db.CDbCommand.query(SELECT `product`.`ID` AS `t1_c0`,
`product`.`TIMESTAMP_X` AS `t1_c1`, `product`.`MODIFIED_BY` AS `t1_c2`,
`product`.`DATE_CREATE` AS `t1_c3`, `product`.`CREATED_BY` AS `t1_c4`,
`product`.`IBLOCK_ID` AS `t1_c5`, `product`.`IBLOCK_SECTION_ID` AS `t1_c6`,
`product`.`ACTIVE` AS `t1_c7`, `product`.`ACTIVE_FROM` AS `t1_c8`,
`product`.`ACTIVE_TO` AS `t1_c9`, `product`.`SORT` AS `t1_c10`,
`product`.`NAME` AS `t1_c11`, `product`.`PREVIEW_PICTURE` AS `t1_c12`,
`product`.`PREVIEW_TEXT` AS `t1_c13`, `product`.`PREVIEW_TEXT_TYPE` AS
`t1_c14`, `product`.`DETAIL_PICTURE` AS `t1_c15`, `product`.`DETAIL_TEXT`
AS `t1_c16`, `product`.`DETAIL_TEXT_TYPE` AS `t1_c17`,
`product`.`SEARCHABLE_CONTENT` AS `t1_c18`, `product`.`WF_STATUS_ID` AS
`t1_c19`, `product`.`WF_PARENT_ELEMENT_ID` AS `t1_c20`, `product`.`WF_NEW`
AS `t1_c21`, `product`.`WF_LOCKED_BY` AS `t1_c22`, `product`.`WF_DATE_LOCK`
AS `t1_c23`, `product`.`WF_COMMENTS` AS `t1_c24`, `product`.`IN_SECTIONS`
AS `t1_c25`, `product`.`XML_ID` AS `t1_c26`, `product`.`CODE` AS `t1_c27`,
`product`.`TAGS` AS `t1_c28`, `product`.`TMP_ID` AS `t1_c29`,
`product`.`WF_LAST_HISTORY_ID` AS `t1_c30`, `product`.`SHOW_COUNTER` AS
`t1_c31`, `product`.`SHOW_COUNTER_START` AS `t1_c32` FROM
`b_iblock_element` `product`  INNER JOIN `sp_review_product`
`goods_product` ON (`goods_product`.`review_id`=:ypl0) AND
(`product`.`ID`=`goods_product`.`product_id`) AND (product.IBLOCK_ID = 24))
05:44:17.510360 profile system.db.CDbCommand.query 
end:system.db.CDbCommand.query(SELECT `product`.`ID` AS `t1_c0`,
`product`.`TIMESTAMP_X` AS `t1_c1`, `product`.`MODIFIED_BY` AS `t1_c2`,
`product`.`DATE_CREATE` AS `t1_c3`, `product`.`CREATED_BY` AS `t1_c4`,
`product`.`IBLOCK_ID` AS `t1_c5`, `product`.`IBLOCK_SECTION_ID` AS `t1_c6`,
`product`.`ACTIVE` AS `t1_c7`, `product`.`ACTIVE_FROM` AS `t1_c8`,
`product`.`ACTIVE_TO` AS `t1_c9`, `product`.`SORT` AS `t1_c10`,
`product`.`NAME` AS `t1_c11`, `product`.`PREVIEW_PICTURE` AS `t1_c12`,
`product`.`PREVIEW_TEXT` AS `t1_c13`, `product`.`PREVIEW_TEXT_TYPE` AS
`t1_c14`, `product`.`DETAIL_PICTURE` AS `t1_c15`, `product`.`DETAIL_TEXT`
AS `t1_c16`, `product`.`DETAIL_TEXT_TYPE` AS `t1_c17`,
`product`.`SEARCHABLE_CONTENT` AS `t1_c18`, `product`.`WF_STATUS_ID` AS
`t1_c19`, `product`.`WF_PARENT_ELEMENT_ID` AS `t1_c20`, `product`.`WF_NEW`
AS `t1_c21`, `product`.`WF_LOCKED_BY` AS `t1_c22`, `product`.`WF_DATE_LOCK`
AS `t1_c23`, `product`.`WF_COMMENTS` AS `t1_c24`, `product`.`IN_SECTIONS`
AS `t1_c25`, `product`.`XML_ID` AS `t1_c26`, `product`.`CODE` AS `t1_c27`,
`product`.`TAGS` AS `t1_c28`, `product`.`TMP_ID` AS `t1_c29`,
`product`.`WF_LAST_HISTORY_ID` AS `t1_c30`, `product`.`SHOW_COUNTER` AS
`t1_c31`, `product`.`SHOW_COUNTER_START` AS `t1_c32` FROM
`b_iblock_element` `product`  INNER JOIN `sp_review_product`
`goods_product` ON (`goods_product`.`review_id`=:ypl0) AND
(`product`.`ID`=`goods_product`.`product_id`) AND (product.IBLOCK_ID = 24))
05:44:17.510493 trace system.CModule 
Loading "clientScript" application component
05:44:17.513056 trace system.CModule 
Loading "widgetFactory" application component
05:44:17.514486 trace system.CModule 
Loading "coreMessages" application component
05:44:17.514880 trace system.db.ar.CActiveRecord 
lazy loading ReviewModel.user
05:44:17.515503 trace system.caching.CMemCache 
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:b_user"
from cache
05:44:17.515783 trace system.db.CDbCommand 
Querying SQL: SELECT `user`.`ID` AS `t1_c0`, `user`.`TIMESTAMP_X` AS
`t1_c1`, `user`.`LOGIN` AS `t1_c2`, `user`.`PASSWORD` AS `t1_c3`,
`user`.`CHECKWORD` AS `t1_c4`, `user`.`ACTIVE` AS `t1_c5`, `user`.`NAME` AS
`t1_c6`, `user`.`LAST_NAME` AS `t1_c7`, `user`.`EMAIL` AS `t1_c8`,
`user`.`LAST_LOGIN` AS `t1_c9`, `user`.`DATE_REGISTER` AS `t1_c10`,
`user`.`LID` AS `t1_c11`, `user`.`PERSONAL_PROFESSION` AS `t1_c12`,
`user`.`PERSONAL_WWW` AS `t1_c13`, `user`.`PERSONAL_ICQ` AS `t1_c14`,
`user`.`PERSONAL_GENDER` AS `t1_c15`, `user`.`PERSONAL_BIRTHDATE` AS
`t1_c16`, `user`.`PERSONAL_PHOTO` AS `t1_c17`, `user`.`PERSONAL_PHONE` AS
`t1_c18`, `user`.`PERSONAL_FAX` AS `t1_c19`, `user`.`PERSONAL_MOBILE` AS
`t1_c20`, `user`.`PERSONAL_PAGER` AS `t1_c21`, `user`.`PERSONAL_STREET` AS
`t1_c22`, `user`.`PERSONAL_MAILBOX` AS `t1_c23`, `user`.`PERSONAL_CITY` AS
`t1_c24`, `user`.`PERSONAL_STATE` AS `t1_c25`, `user`.`PERSONAL_ZIP` AS
`t1_c26`, `user`.`PERSONAL_COUNTRY` AS `t1_c27`, `user`.`PERSONAL_NOTES` AS
`t1_c28`, `user`.`WORK_COMPANY` AS `t1_c29`, `user`.`WORK_DEPARTMENT` AS
`t1_c30`, `user`.`WORK_POSITION` AS `t1_c31`, `user`.`WORK_WWW` AS
`t1_c32`, `user`.`WORK_PHONE` AS `t1_c33`, `user`.`WORK_FAX` AS `t1_c34`,
`user`.`WORK_PAGER` AS `t1_c35`, `user`.`WORK_STREET` AS `t1_c36`,
`user`.`WORK_MAILBOX` AS `t1_c37`, `user`.`WORK_CITY` AS `t1_c38`,
`user`.`WORK_STATE` AS `t1_c39`, `user`.`WORK_ZIP` AS `t1_c40`,
`user`.`WORK_COUNTRY` AS `t1_c41`, `user`.`WORK_PROFILE` AS `t1_c42`,
`user`.`WORK_LOGO` AS `t1_c43`, `user`.`WORK_NOTES` AS `t1_c44`,
`user`.`ADMIN_NOTES` AS `t1_c45`, `user`.`STORED_HASH` AS `t1_c46`,
`user`.`XML_ID` AS `t1_c47`, `user`.`PERSONAL_BIRTHDAY` AS `t1_c48`,
`user`.`EXTERNAL_AUTH_ID` AS `t1_c49`, `user`.`CHECKWORD_TIME` AS `t1_c50`,
`user`.`SECOND_NAME` AS `t1_c51`, `user`.`CONFIRM_CODE` AS `t1_c52`,
`user`.`LOGIN_ATTEMPTS` AS `t1_c53`, `user`.`LAST_ACTIVITY_DATE` AS
`t1_c54`, `user`.`_sendMerge` AS `t1_c55`, `user`.`_sendInfo` AS `t1_c56`,
`user`.`unread_ticket_msg` AS `t1_c57`, `user`.`unread_vin_msg` AS
`t1_c58`, `user`.`inn` AS `t1_c59` FROM `b_user` `user`  WHERE
(`user`.`ID`=:ypl0)
05:44:17.515786 profile system.db.CDbCommand.query 
begin:system.db.CDbCommand.query(SELECT `user`.`ID` AS `t1_c0`,
`user`.`TIMESTAMP_X` AS `t1_c1`, `user`.`LOGIN` AS `t1_c2`,
`user`.`PASSWORD` AS `t1_c3`, `user`.`CHECKWORD` AS `t1_c4`,
`user`.`ACTIVE` AS `t1_c5`, `user`.`NAME` AS `t1_c6`, `user`.`LAST_NAME` AS
`t1_c7`, `user`.`EMAIL` AS `t1_c8`, `user`.`LAST_LOGIN` AS `t1_c9`,
`user`.`DATE_REGISTER` AS `t1_c10`, `user`.`LID` AS `t1_c11`,
`user`.`PERSONAL_PROFESSION` AS `t1_c12`, `user`.`PERSONAL_WWW` AS
`t1_c13`, `user`.`PERSONAL_ICQ` AS `t1_c14`, `user`.`PERSONAL_GENDER` AS
`t1_c15`, `user`.`PERSONAL_BIRTHDATE` AS `t1_c16`, `user`.`PERSONAL_PHOTO`
AS `t1_c17`, `user`.`PERSONAL_PHONE` AS `t1_c18`, `user`.`PERSONAL_FAX` AS
`t1_c19`, `user`.`PERSONAL_MOBILE` AS `t1_c20`, `user`.`PERSONAL_PAGER` AS
`t1_c21`, `user`.`PERSONAL_STREET` AS `t1_c22`, `user`.`PERSONAL_MAILBOX`
AS `t1_c23`, `user`.`PERSONAL_CITY` AS `t1_c24`, `user`.`PERSONAL_STATE` AS
`t1_c25`, `user`.`PERSONAL_ZIP` AS `t1_c26`, `user`.`PERSONAL_COUNTRY` AS
`t1_c27`, `user`.`PERSONAL_NOTES` AS `t1_c28`, `user`.`WORK_COMPANY` AS
`t1_c29`, `user`.`WORK_DEPARTMENT` AS `t1_c30`, `user`.`WORK_POSITION` AS
`t1_c31`, `user`.`WORK_WWW` AS `t1_c32`, `user`.`WORK_PHONE` AS `t1_c33`,
`user`.`WORK_FAX` AS `t1_c34`, `user`.`WORK_PAGER` AS `t1_c35`,
`user`.`WORK_STREET` AS `t1_c36`, `user`.`WORK_MAILBOX` AS `t1_c37`,
`user`.`WORK_CITY` AS `t1_c38`, `user`.`WORK_STATE` AS `t1_c39`,
`user`.`WORK_ZIP` AS `t1_c40`, `user`.`WORK_COUNTRY` AS `t1_c41`,
`user`.`WORK_PROFILE` AS `t1_c42`, `user`.`WORK_LOGO` AS `t1_c43`,
`user`.`WORK_NOTES` AS `t1_c44`, `user`.`ADMIN_NOTES` AS `t1_c45`,
`user`.`STORED_HASH` AS `t1_c46`, `user`.`XML_ID` AS `t1_c47`,
`user`.`PERSONAL_BIRTHDAY` AS `t1_c48`, `user`.`EXTERNAL_AUTH_ID` AS
`t1_c49`, `user`.`CHECKWORD_TIME` AS `t1_c50`, `user`.`SECOND_NAME` AS
`t1_c51`, `user`.`CONFIRM_CODE` AS `t1_c52`, `user`.`LOGIN_ATTEMPTS` AS
`t1_c53`, `user`.`LAST_ACTIVITY_DATE` AS `t1_c54`, `user`.`_sendMerge` AS
`t1_c55`, `user`.`_sendInfo` AS `t1_c56`, `user`.`unread_ticket_msg` AS
`t1_c57`, `user`.`unread_vin_msg` AS `t1_c58`, `user`.`inn` AS `t1_c59`
FROM `b_user` `user`  WHERE (`user`.`ID`=:ypl0))
05:44:17.516398 profile system.db.CDbCommand.query 
end:system.db.CDbCommand.query(SELECT `user`.`ID` AS `t1_c0`,
`user`.`TIMESTAMP_X` AS `t1_c1`, `user`.`LOGIN` AS `t1_c2`,
`user`.`PASSWORD` AS `t1_c3`, `user`.`CHECKWORD` AS `t1_c4`,
`user`.`ACTIVE` AS `t1_c5`, `user`.`NAME` AS `t1_c6`, `user`.`LAST_NAME` AS
`t1_c7`, `user`.`EMAIL` AS `t1_c8`, `user`.`LAST_LOGIN` AS `t1_c9`,
`user`.`DATE_REGISTER` AS `t1_c10`, `user`.`LID` AS `t1_c11`,
`user`.`PERSONAL_PROFESSION` AS `t1_c12`, `user`.`PERSONAL_WWW` AS
`t1_c13`, `user`.`PERSONAL_ICQ` AS `t1_c14`, `user`.`PERSONAL_GENDER` AS
`t1_c15`, `user`.`PERSONAL_BIRTHDATE` AS `t1_c16`, `user`.`PERSONAL_PHOTO`
AS `t1_c17`, `user`.`PERSONAL_PHONE` AS `t1_c18`, `user`.`PERSONAL_FAX` AS
`t1_c19`, `user`.`PERSONAL_MOBILE` AS `t1_c20`, `user`.`PERSONAL_PAGER` AS
`t1_c21`, `user`.`PERSONAL_STREET` AS `t1_c22`, `user`.`PERSONAL_MAILBOX`
AS `t1_c23`, `user`.`PERSONAL_CITY` AS `t1_c24`, `user`.`PERSONAL_STATE` AS
`t1_c25`, `user`.`PERSONAL_ZIP` AS `t1_c26`, `user`.`PERSONAL_COUNTRY` AS
`t1_c27`, `user`.`PERSONAL_NOTES` AS `t1_c28`, `user`.`WORK_COMPANY` AS
`t1_c29`, `user`.`WORK_DEPARTMENT` AS `t1_c30`, `user`.`WORK_POSITION` AS
`t1_c31`, `user`.`WORK_WWW` AS `t1_c32`, `user`.`WORK_PHONE` AS `t1_c33`,
`user`.`WORK_FAX` AS `t1_c34`, `user`.`WORK_PAGER` AS `t1_c35`,
`user`.`WORK_STREET` AS `t1_c36`, `user`.`WORK_MAILBOX` AS `t1_c37`,
`user`.`WORK_CITY` AS `t1_c38`, `user`.`WORK_STATE` AS `t1_c39`,
`user`.`WORK_ZIP` AS `t1_c40`, `user`.`WORK_COUNTRY` AS `t1_c41`,
`user`.`WORK_PROFILE` AS `t1_c42`, `user`.`WORK_LOGO` AS `t1_c43`,
`user`.`WORK_NOTES` AS `t1_c44`, `user`.`ADMIN_NOTES` AS `t1_c45`,
`user`.`STORED_HASH` AS `t1_c46`, `user`.`XML_ID` AS `t1_c47`,
`user`.`PERSONAL_BIRTHDAY` AS `t1_c48`, `user`.`EXTERNAL_AUTH_ID` AS
`t1_c49`, `user`.`CHECKWORD_TIME` AS `t1_c50`, `user`.`SECOND_NAME` AS
`t1_c51`, `user`.`CONFIRM_CODE` AS `t1_c52`, `user`.`LOGIN_ATTEMPTS` AS
`t1_c53`, `user`.`LAST_ACTIVITY_DATE` AS `t1_c54`, `user`.`_sendMerge` AS
`t1_c55`, `user`.`_sendInfo` AS `t1_c56`, `user`.`unread_ticket_msg` AS
`t1_c57`, `user`.`unread_vin_msg` AS `t1_c58`, `user`.`inn` AS `t1_c59`
FROM `b_user` `user`  WHERE (`user`.`ID`=:ypl0))
05:44:17.516495 trace system.db.ar.CActiveRecord 
lazy loading User.profile
05:44:17.517128 trace system.caching.CMemCache 
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:sp_user_social_profiles"
from cache
05:44:17.517220 trace system.db.CDbCommand 
Querying SQL: SELECT `profile`.`user_id` AS `t1_c0`, `profile`.`nickname`
AS `t1_c1`, `profile`.`avatar_filename` AS `t1_c2`, `profile`.`bio` AS
`t1_c3`, `profile`.`experience` AS `t1_c4`, `profile`.`level` AS `t1_c5`,
`profile`.`internal_rating` AS `t1_c6`, `profile`.`created_at` AS `t1_c7`,
`profile`.`updated_at` AS `t1_c8` FROM `sp_user_social_profiles` `profile` 
WHERE (`profile`.`user_id`=:ypl0)
05:44:17.517222 profile system.db.CDbCommand.query 
begin:system.db.CDbCommand.query(SELECT `profile`.`user_id` AS `t1_c0`,
`profile`.`nickname` AS `t1_c1`, `profile`.`avatar_filename` AS `t1_c2`,
`profile`.`bio` AS `t1_c3`, `profile`.`experience` AS `t1_c4`,
`profile`.`level` AS `t1_c5`, `profile`.`internal_rating` AS `t1_c6`,
`profile`.`created_at` AS `t1_c7`, `profile`.`updated_at` AS `t1_c8` FROM
`sp_user_social_profiles` `profile`  WHERE (`profile`.`user_id`=:ypl0))
05:44:17.517569 profile system.db.CDbCommand.query 
end:system.db.CDbCommand.query(SELECT `profile`.`user_id` AS `t1_c0`,
`profile`.`nickname` AS `t1_c1`, `profile`.`avatar_filename` AS `t1_c2`,
`profile`.`bio` AS `t1_c3`, `profile`.`experience` AS `t1_c4`,
`profile`.`level` AS `t1_c5`, `profile`.`internal_rating` AS `t1_c6`,
`profile`.`created_at` AS `t1_c7`, `profile`.`updated_at` AS `t1_c8` FROM
`sp_user_social_profiles` `profile`  WHERE (`profile`.`user_id`=:ypl0))
05:44:17.517615 trace system.db.ar.CActiveRecord 
lazy loading ReviewModel.profile
05:44:17.517726 trace system.db.CDbCommand 
Querying SQL: SELECT `profile`.`user_id` AS `t1_c0`, `profile`.`nickname`
AS `t1_c1`, `profile`.`avatar_filename` AS `t1_c2`, `profile`.`bio` AS
`t1_c3`, `profile`.`experience` AS `t1_c4`, `profile`.`level` AS `t1_c5`,
`profile`.`internal_rating` AS `t1_c6`, `profile`.`created_at` AS `t1_c7`,
`profile`.`updated_at` AS `t1_c8` FROM `sp_user_social_profiles` `profile` 
WHERE (`profile`.`user_id`=:ypl0)
05:44:17.517729 profile system.db.CDbCommand.query 
begin:system.db.CDbCommand.query(SELECT `profile`.`user_id` AS `t1_c0`,
`profile`.`nickname` AS `t1_c1`, `profile`.`avatar_filename` AS `t1_c2`,
`profile`.`bio` AS `t1_c3`, `profile`.`experience` AS `t1_c4`,
`profile`.`level` AS `t1_c5`, `profile`.`internal_rating` AS `t1_c6`,
`profile`.`created_at` AS `t1_c7`, `profile`.`updated_at` AS `t1_c8` FROM
`sp_user_social_profiles` `profile`  WHERE (`profile`.`user_id`=:ypl0))
05:44:17.517925 profile system.db.CDbCommand.query 
end:system.db.CDbCommand.query(SELECT `profile`.`user_id` AS `t1_c0`,
`profile`.`nickname` AS `t1_c1`, `profile`.`avatar_filename` AS `t1_c2`,
`profile`.`bio` AS `t1_c3`, `profile`.`experience` AS `t1_c4`,
`profile`.`level` AS `t1_c5`, `profile`.`internal_rating` AS `t1_c6`,
`profile`.`created_at` AS `t1_c7`, `profile`.`updated_at` AS `t1_c8` FROM
`sp_user_social_profiles` `profile`  WHERE (`profile`.`user_id`=:ypl0))
05:44:17.518094 trace system.db.ar.CActiveRecord 
lazy loading ReviewModel.reactions
05:44:17.518477 trace system.caching.CMemCache 
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:sp_reactions"
from cache
05:44:17.518563 trace system.db.CDbCommand 
Querying SQL: SELECT `r`.`entity_id` AS `t1_c0`, `r`.`entity_type` AS
`t1_c1`, `r`.`user_id` AS `t1_c2`, `r`.`reaction_type` AS `t1_c3`,
`r`.`created_at` AS `t1_c4` FROM `sp_reactions` `r`  WHERE
(r.entity_type=:entityType) AND (`r`.`entity_id`=:ypl0)
05:44:17.518567 profile system.db.CDbCommand.query 
begin:system.db.CDbCommand.query(SELECT `r`.`entity_id` AS `t1_c0`,
`r`.`entity_type` AS `t1_c1`, `r`.`user_id` AS `t1_c2`, `r`.`reaction_type`
AS `t1_c3`, `r`.`created_at` AS `t1_c4` FROM `sp_reactions` `r`  WHERE
(r.entity_type=:entityType) AND (`r`.`entity_id`=:ypl0))
05:44:17.518927 profile system.db.CDbCommand.query 
end:system.db.CDbCommand.query(SELECT `r`.`entity_id` AS `t1_c0`,
`r`.`entity_type` AS `t1_c1`, `r`.`user_id` AS `t1_c2`, `r`.`reaction_type`
AS `t1_c3`, `r`.`created_at` AS `t1_c4` FROM `sp_reactions` `r`  WHERE
(r.entity_type=:entityType) AND (`r`.`entity_id`=:ypl0))
05:44:17.519418 trace system.db.ar.CActiveRecord 
lazy loading Good.I_PREVIEW_PICTURE
05:44:17.519681 trace system.caching.CMemCache 
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:b_file"
from cache
05:44:17.519776 trace system.db.CDbCommand 
Querying SQL: SELECT `pp`.`ID` AS `t1_c0`, `pp`.`TIMESTAMP_X` AS `t1_c1`,
`pp`.`MODULE_ID` AS `t1_c2`, `pp`.`HEIGHT` AS `t1_c3`, `pp`.`WIDTH` AS
`t1_c4`, `pp`.`FILE_SIZE` AS `t1_c5`, `pp`.`CONTENT_TYPE` AS `t1_c6`,
`pp`.`SUBDIR` AS `t1_c7`, `pp`.`FILE_NAME` AS `t1_c8`, `pp`.`ORIGINAL_NAME`
AS `t1_c9`, `pp`.`DESCRIPTION` AS `t1_c10` FROM `b_file` `pp`  WHERE
(`pp`.`ID`=:ypl0)
05:44:17.519778 profile system.db.CDbCommand.query 
begin:system.db.CDbCommand.query(SELECT `pp`.`ID` AS `t1_c0`,
`pp`.`TIMESTAMP_X` AS `t1_c1`, `pp`.`MODULE_ID` AS `t1_c2`, `pp`.`HEIGHT`
AS `t1_c3`, `pp`.`WIDTH` AS `t1_c4`, `pp`.`FILE_SIZE` AS `t1_c5`,
`pp`.`CONTENT_TYPE` AS `t1_c6`, `pp`.`SUBDIR` AS `t1_c7`, `pp`.`FILE_NAME`
AS `t1_c8`, `pp`.`ORIGINAL_NAME` AS `t1_c9`, `pp`.`DESCRIPTION` AS `t1_c10`
FROM `b_file` `pp`  WHERE (`pp`.`ID`=:ypl0))
05:44:17.520117 profile system.db.CDbCommand.query 
end:system.db.CDbCommand.query(SELECT `pp`.`ID` AS `t1_c0`,
`pp`.`TIMESTAMP_X` AS `t1_c1`, `pp`.`MODULE_ID` AS `t1_c2`, `pp`.`HEIGHT`
AS `t1_c3`, `pp`.`WIDTH` AS `t1_c4`, `pp`.`FILE_SIZE` AS `t1_c5`,
`pp`.`CONTENT_TYPE` AS `t1_c6`, `pp`.`SUBDIR` AS `t1_c7`, `pp`.`FILE_NAME`
AS `t1_c8`, `pp`.`ORIGINAL_NAME` AS `t1_c9`, `pp`.`DESCRIPTION` AS `t1_c10`
FROM `b_file` `pp`  WHERE (`pp`.`ID`=:ypl0))
05:44:17.520327 trace system.CModule 
Loading "warehouse" application component
05:44:17.520616 trace system.caching.CMemCache 
Serving "IWarehouseIWarehouse::getStaticList" from cache
05:44:17.520919 trace system.caching.CMemCache 
Serving "IWarehouse1" from cache
05:44:17.522099 trace system.db.ar.CActiveRecord 
lazy loading Good.msections
05:44:17.522653 trace system.caching.CMemCache 
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:sp_catalog2msections"
from cache
05:44:17.522778 trace system.db.CDbCommand 
Querying SQL: SELECT `ms`.`ELEMENT_ID` AS `t1_c0`, `ms`.`SECTION_ID` AS
`t1_c1`, `ms`.`IBLOCK_ID` AS `t1_c2`, `ms`.`NUM` AS `t1_c3` FROM
`sp_catalog2msections` `ms`  WHERE (ms.IBLOCK_ID = 49) AND
(`ms`.`ELEMENT_ID`=:ypl0)
05:44:17.522783 profile system.db.CDbCommand.query 
begin:system.db.CDbCommand.query(SELECT `ms`.`ELEMENT_ID` AS `t1_c0`,
`ms`.`SECTION_ID` AS `t1_c1`, `ms`.`IBLOCK_ID` AS `t1_c2`, `ms`.`NUM` AS
`t1_c3` FROM `sp_catalog2msections` `ms`  WHERE (ms.IBLOCK_ID = 49) AND
(`ms`.`ELEMENT_ID`=:ypl0))
05:44:17.523242 profile system.db.CDbCommand.query 
end:system.db.CDbCommand.query(SELECT `ms`.`ELEMENT_ID` AS `t1_c0`,
`ms`.`SECTION_ID` AS `t1_c1`, `ms`.`IBLOCK_ID` AS `t1_c2`, `ms`.`NUM` AS
`t1_c3` FROM `sp_catalog2msections` `ms`  WHERE (ms.IBLOCK_ID = 49) AND
(`ms`.`ELEMENT_ID`=:ypl0))
05:44:17.523394 trace system.CModule 
Loading "GoodSections" application component
05:44:17.523458 trace system.CModule 
Loading "fcache" application component
05:44:17.535392 trace system.caching.CFileCache 
Serving "good_sections_tree5" from cache
05:44:17.535638 trace system.caching.CMemCache 
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:b_iblock_section"
from cache
05:44:17.538430 trace system.CModule 
Loading "microdataManager" application component
05:44:17.546020 trace system.caching.CMemCache 
Serving "CB:name:top_alert_mobile" from cache
05:44:17.547755 trace system.caching.CMemCache 
Serving "CB:name:bottom_for_buyer_mobile" from cache
05:44:17.548491 trace system.CModule 
Loading "territory" application component
05:44:17.552561 trace system.caching.CMemCache 
Serving "ITerritory3" from cache
05:44:17.552644 trace system.CModule 
Loading "IPropeties" application component
05:44:17.557835 trace system.caching.CMemCache 
Serving "iblock_properties_0" from cache
05:44:17.560626 trace system.caching.CMemCache 
Serving "iblock_properties_0getPropValues1045" from cache
05:44:17.568137 trace system.caching.CMemCache 
Serving "CB:name:bottom_job_mobile" from cache
05:44:17.568968 trace system.caching.CMemCache 
Serving "CB:name:partners_mobile" from cache
05:44:17.571568 trace system.db.ar.CActiveRecord 
CartUser.find()
05:44:17.571633 trace system.db.CDbCommand 
Querying SQL: SELECT * FROM `b_sale_fuser` `t` WHERE USER_ID=:USER_ID LIMIT
1
05:44:17.571636 profile system.db.CDbCommand.query 
begin:system.db.CDbCommand.query(SELECT * FROM `b_sale_fuser` `t` WHERE
USER_ID=:USER_ID LIMIT 1)
05:44:17.573556 profile system.db.CDbCommand.query 
end:system.db.CDbCommand.query(SELECT * FROM `b_sale_fuser` `t` WHERE
USER_ID=:USER_ID LIMIT 1)
05:44:17.574377 trace system.db.ar.CActiveRecord 
CartUser.find()
05:44:17.574429 trace system.db.CDbCommand 
Querying SQL: SELECT * FROM `b_sale_fuser` `t` WHERE USER_ID=:USER_ID LIMIT
1
05:44:17.574433 profile system.db.CDbCommand.query 
begin:system.db.CDbCommand.query(SELECT * FROM `b_sale_fuser` `t` WHERE
USER_ID=:USER_ID LIMIT 1)
05:44:17.574661 profile system.db.CDbCommand.query 
end:system.db.CDbCommand.query(SELECT * FROM `b_sale_fuser` `t` WHERE
USER_ID=:USER_ID LIMIT 1)
05:44:17.574668 trace system.db.ar.CActiveRecord 
Cart.count()
05:44:17.574913 trace system.caching.CMemCache 
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:b_sale_basket"
from cache
05:44:17.574995 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
05:44:17.574999 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)
05:44:17.575247 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)
05:44:17.576380 trace system.CModule 
Loading "yandexEcom" application component