Выберите город
Проконсультируем по телефону или в мессенджере:
Отправить запрос
нашему специалисту
Вы смотрели
Личный кабинет 0
Общий отчет (Время: 1.20293с, Память: 21,357Кб)
Процедура Номер Всего (с) Средн. (с) Мин. (с) Макс. (с)
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
loading session 2 0.90188 0.45094 0.00001 0.90188
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `b_sale_basket`) 1 0.00113 0.00113 0.00113 0.00113
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `sp_locations`) 1 0.00073 0.00073 0.00073 0.00073
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `sp_delivery_calc_main`) 1 0.00059 0.00059 0.00059 0.00059
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `b_sale_fuser`) 1 0.00053 0.00053 0.00053 0.00053
system.db.CDbCommand.query(SHOW CREATE TABLE `b_sale_basket`) 1 0.00038 0.00038 0.00038 0.00038
system.db.CDbCommand.query(SHOW CREATE TABLE `sp_locations`) 1 0.00029 0.00029 0.00029 0.00029
system.db.CDbCommand.query(SELECT `t`.`ID` AS `t0_c0`, `t`.`FUSER_ID` AS `t0_c1`, `t`.`ORDER_ID` AS `t0_c2`, `t`.`PRODUCT_ID` AS `t0_c3`, `t`.`PRODUCT_PRICE_ID` AS `t0_c4`, `t`.`PRICE` AS `t0_c5`, `t`.`CURRENCY` AS `t0_c6`, `t`.`DATE_INSERT` AS `t0_c7`, `t`.`DATE_UPDATE` AS `t0_c8`, `t`.`WEIGHT` AS `t0_c9`, `t`.`QUANTITY` AS `t0_c10`, `t`.`LID` AS `t0_c11`, `t`.`DELAY` AS `t0_c12`, `t`.`NAME` AS `t0_c13`, `t`.`CAN_BUY` AS `t0_c14`, `t`.`MODULE` AS `t0_c15`, `t`.`CALLBACK_FUNC` AS `t0_c16`, `t`.`NOTES` AS `t0_c17`, `t`.`ORDER_CALLBACK_FUNC` AS `t0_c18`, `t`.`DETAIL_PAGE_URL` AS `t0_c19`, `t`.`DISCOUNT_PRICE` AS `t0_c20`, `t`.`CANCEL_CALLBACK_FUNC` AS `t0_c21`, `t`.`PAY_CALLBACK_FUNC` AS `t0_c22`, `t`.`CATALOG_XML_ID` AS `t0_c23`, `t`.`PRODUCT_XML_ID` AS `t0_c24`, `t`.`DISCOUNT_NAME` AS `t0_c25`, `t`.`DISCOUNT_VALUE` AS `t0_c26`, `t`.`DISCOUNT_COUPON` AS `t0_c27`, `t`.`VAT_RATE` AS `t0_c28`, `t`.`PURCHASE_PRICE` AS `t0_c29`, `t`.`CAR_ID` AS `t0_c30`, `t`.`EXPEND_ID` AS `t0_c31`, `t`.`LINKED_PRODUCT_ID` AS `t0_c32`, `t`.`LINKED_MPRODUCT_ID` AS `t0_c33`, `t`.`basket_id` AS `t0_c34`, `t`.`product_avail` AS `t0_c35` FROM `b_sale_basket` `t` WHERE ((ORDER_ID IS NULL AND DELAY IN("N","F")) AND (FUSER_ID=:FUSER_ID))) 1 0.00028 0.00028 0.00028 0.00028
system.db.CDbCommand.query(SHOW CREATE TABLE `sp_delivery_calc_main`) 1 0.00024 0.00024 0.00024 0.00024
system.db.CDbCommand.execute(SET SESSION TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;) 1 0.00024 0.00024 0.00024 0.00024
system.db.CDbCommand.query(SHOW CREATE TABLE `b_sale_fuser`) 1 0.00022 0.00022 0.00022 0.00022
system.db.CDbCommand.query(SELECT * FROM `sp_locations` `t` WHERE `t`.`id`='' LIMIT 1) 1 0.00020 0.00020 0.00020 0.00020
Sphinx search. total_found: 0; time: 0.000 1 0.08652 0.08652 0.08652 0.08652
system.db.CDbCommand.query(SELECT * FROM `b_sale_fuser` `t` WHERE ID=:ID LIMIT 1) 1 0.00019 0.00019 0.00019 0.00019
system.db.CDbCommand.query(SELECT * FROM `sp_delivery_calc_main` `t` WHERE t.location_id = :location_id LIMIT 1) 1 0.00018 0.00018 0.00018 0.00018
Sphinx search. total_found: 0; time: 0.001 1 0.18812 0.18812 0.18812 0.18812
system.db.CDbCommand.query(call get_all_parts_by_art_no_link_v4_11("2503408117", 66, 66)) 1 0.00354 0.00354 0.00354 0.00354
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `b_iblock_element`) 1 0.00073 0.00073 0.00073 0.00073
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `b_iblock_section`) 1 0.00077 0.00077 0.00077 0.00077
system.db.CDbCommand.query(SELECT `mp`.`ID` AS `t1_c0`, `mp`.`IBLOCK_PROPERTY_ID` AS `t1_c1`, `mp`.`IBLOCK_ELEMENT_ID` AS `t1_c2`, `mp`.`VALUE` AS `t1_c3`, `mp`.`VALUE_TYPE` AS `t1_c4`, `mp`.`VALUE_ENUM` AS `t1_c5`, `mp`.`VALUE_NUM` AS `t1_c6`, `mp`.`DESCRIPTION` AS `t1_c7` FROM `b_iblock_element_property` `mp` WHERE (`mp`.`IBLOCK_ELEMENT_ID`=:ypl0)) 2 0.00127 0.00064 0.00042 0.00085
system.db.CDbCommand.query(SELECT `t`.`ID` AS `t0_c0`, `t`.`TIMESTAMP_X` AS `t0_c1`, `t`.`MODIFIED_BY` AS `t0_c2`, `t`.`DATE_CREATE` AS `t0_c3`, `t`.`CREATED_BY` AS `t0_c4`, `t`.`IBLOCK_ID` AS `t0_c5`, `t`.`IBLOCK_SECTION_ID` AS `t0_c6`, `t`.`ACTIVE` AS `t0_c7`, `t`.`ACTIVE_FROM` AS `t0_c8`, `t`.`ACTIVE_TO` AS `t0_c9`, `t`.`SORT` AS `t0_c10`, `t`.`NAME` AS `t0_c11`, `t`.`PREVIEW_PICTURE` AS `t0_c12`, `t`.`PREVIEW_TEXT` AS `t0_c13`, `t`.`PREVIEW_TEXT_TYPE` AS `t0_c14`, `t`.`DETAIL_PICTURE` AS `t0_c15`, `t`.`DETAIL_TEXT` AS `t0_c16`, `t`.`DETAIL_TEXT_TYPE` AS `t0_c17`, `t`.`SEARCHABLE_CONTENT` AS `t0_c18`, `t`.`WF_STATUS_ID` AS `t0_c19`, `t`.`WF_PARENT_ELEMENT_ID` AS `t0_c20`, `t`.`WF_NEW` AS `t0_c21`, `t`.`WF_LOCKED_BY` AS `t0_c22`, `t`.`WF_DATE_LOCK` AS `t0_c23`, `t`.`WF_COMMENTS` AS `t0_c24`, `t`.`IN_SECTIONS` AS `t0_c25`, `t`.`XML_ID` AS `t0_c26`, `t`.`CODE` AS `t0_c27`, `t`.`TAGS` AS `t0_c28`, `t`.`TMP_ID` AS `t0_c29`, `t`.`WF_LAST_HISTORY_ID` AS `t0_c30`, `t`.`SHOW_COUNTER` AS `t0_c31`, `t`.`SHOW_COUNTER_START` AS `t0_c32`, `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_iblock_element` `t` LEFT OUTER JOIN `b_file` `pp` ON (`t`.`PREVIEW_PICTURE`=`pp`.`ID`) WHERE ((t.IBLOCK_ID = 24) AND (t.ID IN (:ycp0, :ycp1, :ycp2, :ycp3, :ycp4, :ycp5, :ycp6, :ycp7, :ycp8)))) 1 0.00086 0.00086 0.00086 0.00086
system.db.CDbCommand.query(SELECT `NAME`, `CODE` FROM `b_iblock_element` `t` LEFT JOIN `b_iblock_element_property` `mp` ON mp.IBLOCK_ELEMENT_ID = t.ID WHERE IBLOCK_ID =:block_id AND IBLOCK_PROPERTY_ID =:prop_id AND VALUE =:value AND (t.NAME LIKE :word0)) 1 0.00062 0.00062 0.00062 0.00062
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `b_file`) 1 0.00062 0.00062 0.00062 0.00062
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `b_iblock_element_property`) 1 0.00056 0.00056 0.00056 0.00056
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `sp_catalog2msections`) 1 0.00054 0.00054 0.00054 0.00054
system.db.CDbCommand.query(SHOW CREATE TABLE `b_iblock_section`) 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.00030 0.00030 0.00030 0.00030
system.db.CDbCommand.query(SELECT `t`.`ID` AS `t0_c0`, `ms`.`ELEMENT_ID` AS `t2_c0`, `ms`.`SECTION_ID` AS `t2_c1`, `ms`.`IBLOCK_ID` AS `t2_c2`, `ms`.`NUM` AS `t2_c3` FROM `b_iblock_element` `t` LEFT OUTER JOIN `sp_catalog2msections` `ms` ON (`ms`.`ELEMENT_ID`=`t`.`ID`) AND (ms.IBLOCK_ID = 49) WHERE (`t`.`ID` IN (6493896, 80759379, 82286831, 128996927, 200352894, 211295640, 228900132, 233331345, 233402439))) 1 0.00028 0.00028 0.00028 0.00028
system.db.CDbCommand.query(SELECT `t`.`NAME` AS `pattern`, `t`.`CODE` AS `replace` FROM `b_iblock_element` `t` LEFT JOIN `b_iblock_element_property` `mp` ON mp.IBLOCK_ELEMENT_ID = t.ID WHERE IBLOCK_ID = :block_id AND IBLOCK_PROPERTY_ID = :prop_id AND VALUE = :value) 1 0.00027 0.00027 0.00027 0.00027
system.db.CDbCommand.query(SHOW CREATE TABLE `b_iblock_element_property`) 1 0.00024 0.00024 0.00024 0.00024
system.db.CDbCommand.query(SHOW CREATE TABLE `b_file`) 1 0.00023 0.00023 0.00023 0.00023
system.db.CDbCommand.query(SHOW CREATE TABLE `sp_catalog2msections`) 1 0.00021 0.00021 0.00021 0.00021
Sphinx index im_content 1 0.08760 0.08760 0.08760 0.08760
system.db.CDbCommand.query(SHOW CREATE TABLE `b_iblock_element`) 1 0.00030 0.00030 0.00030 0.00030
Sphinx index catalog,catalog_morph,marketplace 1 0.19124 0.19124 0.19124 0.19124
system.db.CDbCommand.execute(DELETE FROM `YiiLog` WHERE 0=1) 1 0.00021 0.00021 0.00021 0.00021
Журнал приложения
Время Уровень Категория Сообщение
14:09:28.923141 trace system.CModule
Loading "log" application component
14:09:28.925420 trace glitchtip_fallback
The "Sentry\Integration\RequestIntegration,
Sentry\Integration\TransactionIntegration,
Sentry\Integration\FrameContextifierIntegration,
Sentry\Integration\EnvironmentIntegration" integration(s) have been
installed.
14:09:28.925626 trace system.CModule
Loading "db" application component
14:09:28.925677 trace system.db.CDbConnection
Opening DB connection
14:09:28.926625 trace system.db.CDbCommand
Executing SQL: DELETE FROM `YiiLog` WHERE 0=1
14:09:28.926630 profile system.db.CDbCommand.execute
begin:system.db.CDbCommand.execute(DELETE FROM `YiiLog` WHERE 0=1)
14:09:28.926841 profile system.db.CDbCommand.execute
end:system.db.CDbCommand.execute(DELETE FROM `YiiLog` WHERE 0=1)
14:09:28.927011 trace system.CModule
Loading "urlHelper" application component
14:09:28.927112 trace system.CModule
Loading "DBConfig" application component
14:09:28.927139 trace system.CModule
Loading "cache" application component
14:09:28.927887 trace system.caching.CMemCache
Serving "66307959e0460a2e2436b0319b2fda14" from cache
14:09:28.928154 trace system.CModule
Loading "geo" application component
14:09:28.928236 trace system.CModule
Loading "request" application component
14:09:28.928642 trace system.caching.CMemCache
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:b_sale_location"
from cache
14:09:28.928678 trace system.db.ar.CActiveRecord
Location.findByPk()
14:09:28.929045 trace system.caching.CMemCache
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:b_sale_location_city"
from cache
14:09:28.929219 trace system.caching.CMemCache
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:b_sale_location_country"
from cache
14:09:28.929347 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
14:09:28.929352 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)
14:09:28.929557 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)
14:09:28.929722 trace system.CModule
Loading "user" application component
14:09:28.929828 profile application
begin:loading session
14:09:28.929832 trace system.CModule
Loading "session" application component
14:09:29.831706 profile application
end:loading session
14:09:29.832145 trace system.db.ar.CActiveRecord
OutLocation.findByPk()
14:09:29.832354 trace system.db.CDbCommand
Querying SQL: SHOW FULL COLUMNS FROM `sp_locations`
14:09:29.832357 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `sp_locations`)
14:09:29.833086 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `sp_locations`)
14:09:29.833317 trace system.db.CDbCommand
Querying SQL: SHOW CREATE TABLE `sp_locations`
14:09:29.833318 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SHOW CREATE TABLE `sp_locations`)
14:09:29.833611 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SHOW CREATE TABLE `sp_locations`)
14:09:29.833676 trace system.caching.CMemCache
Saving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:sp_locations"
to cache
14:09:29.833890 trace system.db.CDbCommand
Querying SQL: SELECT * FROM `sp_locations` `t` WHERE `t`.`id`='' LIMIT 1
14:09:29.833894 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT * FROM `sp_locations` `t` WHERE
`t`.`id`='' LIMIT 1)
14:09:29.834093 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT * FROM `sp_locations` `t` WHERE
`t`.`id`='' LIMIT 1)
14:09:29.834182 trace system.CModule
Loading "B2BConfig" application component
14:09:29.834245 trace system.CModule
Loading "urlManager" application component
14:09:29.835244 trace system.caching.CMemCache
Serving "Yii.CUrlManager.rules" from cache
14:09:29.837811 trace system.CModule
Loading "themeInterlayer" application component
14:09:29.838032 trace system.CModule
Loading "themeManager" application component
14:09:29.839025 trace system.web.filters.CFilterChain
Running filter DBReadUncomitedLevelFilter.filter()
14:09:29.839037 trace system.db.CDbCommand
Executing SQL: SET SESSION TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
14:09:29.839040 profile system.db.CDbCommand.execute
begin:system.db.CDbCommand.execute(SET SESSION TRANSACTION ISOLATION LEVEL
READ UNCOMMITTED;)
14:09:29.839277 profile system.db.CDbCommand.execute
end:system.db.CDbCommand.execute(SET SESSION TRANSACTION ISOLATION LEVEL
READ UNCOMMITTED;)
14:09:29.839309 trace system.CModule
Loading "cart" application component
14:09:29.839401 trace system.db.ar.CActiveRecord
CartUser.find()
14:09:29.839531 trace system.db.CDbCommand
Querying SQL: SHOW FULL COLUMNS FROM `b_sale_fuser`
14:09:29.839534 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `b_sale_fuser`)
14:09:29.840068 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `b_sale_fuser`)
14:09:29.840117 trace system.db.CDbCommand
Querying SQL: SHOW CREATE TABLE `b_sale_fuser`
14:09:29.840121 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SHOW CREATE TABLE `b_sale_fuser`)
14:09:29.840338 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SHOW CREATE TABLE `b_sale_fuser`)
14:09:29.840347 trace system.caching.CMemCache
Saving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:b_sale_fuser"
to cache
14:09:29.840517 trace system.db.CDbCommand
Querying SQL: SELECT * FROM `b_sale_fuser` `t` WHERE ID=:ID LIMIT 1
14:09:29.840519 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT * FROM `b_sale_fuser` `t` WHERE
ID=:ID LIMIT 1)
14:09:29.840706 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT * FROM `b_sale_fuser` `t` WHERE
ID=:ID LIMIT 1)
14:09:29.840939 trace system.CModule
Loading "coupon" application component
14:09:29.841058 trace system.db.ar.CActiveRecord
Cart.findAll()
14:09:29.841197 trace system.db.CDbCommand
Querying SQL: SHOW FULL COLUMNS FROM `b_sale_basket`
14:09:29.841200 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `b_sale_basket`)
14:09:29.842330 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `b_sale_basket`)
14:09:29.842787 trace system.db.CDbCommand
Querying SQL: SHOW CREATE TABLE `b_sale_basket`
14:09:29.842792 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SHOW CREATE TABLE `b_sale_basket`)
14:09:29.843169 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SHOW CREATE TABLE `b_sale_basket`)
14:09:29.843184 trace system.caching.CMemCache
Saving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:b_sale_basket"
to cache
14:09:29.843852 trace system.caching.CMemCache
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:b_sale_basket_props"
from cache
14:09:29.844043 trace system.db.CDbCommand
Querying SQL: SELECT `t`.`ID` AS `t0_c0`, `t`.`FUSER_ID` AS `t0_c1`,
`t`.`ORDER_ID` AS `t0_c2`, `t`.`PRODUCT_ID` AS `t0_c3`,
`t`.`PRODUCT_PRICE_ID` AS `t0_c4`, `t`.`PRICE` AS `t0_c5`, `t`.`CURRENCY`
AS `t0_c6`, `t`.`DATE_INSERT` AS `t0_c7`, `t`.`DATE_UPDATE` AS `t0_c8`,
`t`.`WEIGHT` AS `t0_c9`, `t`.`QUANTITY` AS `t0_c10`, `t`.`LID` AS `t0_c11`,
`t`.`DELAY` AS `t0_c12`, `t`.`NAME` AS `t0_c13`, `t`.`CAN_BUY` AS `t0_c14`,
`t`.`MODULE` AS `t0_c15`, `t`.`CALLBACK_FUNC` AS `t0_c16`, `t`.`NOTES` AS
`t0_c17`, `t`.`ORDER_CALLBACK_FUNC` AS `t0_c18`, `t`.`DETAIL_PAGE_URL` AS
`t0_c19`, `t`.`DISCOUNT_PRICE` AS `t0_c20`, `t`.`CANCEL_CALLBACK_FUNC` AS
`t0_c21`, `t`.`PAY_CALLBACK_FUNC` AS `t0_c22`, `t`.`CATALOG_XML_ID` AS
`t0_c23`, `t`.`PRODUCT_XML_ID` AS `t0_c24`, `t`.`DISCOUNT_NAME` AS
`t0_c25`, `t`.`DISCOUNT_VALUE` AS `t0_c26`, `t`.`DISCOUNT_COUPON` AS
`t0_c27`, `t`.`VAT_RATE` AS `t0_c28`, `t`.`PURCHASE_PRICE` AS `t0_c29`,
`t`.`CAR_ID` AS `t0_c30`, `t`.`EXPEND_ID` AS `t0_c31`,
`t`.`LINKED_PRODUCT_ID` AS `t0_c32`, `t`.`LINKED_MPRODUCT_ID` AS `t0_c33`,
`t`.`basket_id` AS `t0_c34`, `t`.`product_avail` AS `t0_c35` FROM
`b_sale_basket` `t`  WHERE ((ORDER_ID IS NULL AND DELAY IN("N","F")) AND
(FUSER_ID=:FUSER_ID))
14:09:29.844048 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT `t`.`ID` AS `t0_c0`, `t`.`FUSER_ID`
AS `t0_c1`, `t`.`ORDER_ID` AS `t0_c2`, `t`.`PRODUCT_ID` AS `t0_c3`,
`t`.`PRODUCT_PRICE_ID` AS `t0_c4`, `t`.`PRICE` AS `t0_c5`, `t`.`CURRENCY`
AS `t0_c6`, `t`.`DATE_INSERT` AS `t0_c7`, `t`.`DATE_UPDATE` AS `t0_c8`,
`t`.`WEIGHT` AS `t0_c9`, `t`.`QUANTITY` AS `t0_c10`, `t`.`LID` AS `t0_c11`,
`t`.`DELAY` AS `t0_c12`, `t`.`NAME` AS `t0_c13`, `t`.`CAN_BUY` AS `t0_c14`,
`t`.`MODULE` AS `t0_c15`, `t`.`CALLBACK_FUNC` AS `t0_c16`, `t`.`NOTES` AS
`t0_c17`, `t`.`ORDER_CALLBACK_FUNC` AS `t0_c18`, `t`.`DETAIL_PAGE_URL` AS
`t0_c19`, `t`.`DISCOUNT_PRICE` AS `t0_c20`, `t`.`CANCEL_CALLBACK_FUNC` AS
`t0_c21`, `t`.`PAY_CALLBACK_FUNC` AS `t0_c22`, `t`.`CATALOG_XML_ID` AS
`t0_c23`, `t`.`PRODUCT_XML_ID` AS `t0_c24`, `t`.`DISCOUNT_NAME` AS
`t0_c25`, `t`.`DISCOUNT_VALUE` AS `t0_c26`, `t`.`DISCOUNT_COUPON` AS
`t0_c27`, `t`.`VAT_RATE` AS `t0_c28`, `t`.`PURCHASE_PRICE` AS `t0_c29`,
`t`.`CAR_ID` AS `t0_c30`, `t`.`EXPEND_ID` AS `t0_c31`,
`t`.`LINKED_PRODUCT_ID` AS `t0_c32`, `t`.`LINKED_MPRODUCT_ID` AS `t0_c33`,
`t`.`basket_id` AS `t0_c34`, `t`.`product_avail` AS `t0_c35` FROM
`b_sale_basket` `t`  WHERE ((ORDER_ID IS NULL AND DELAY IN("N","F")) AND
(FUSER_ID=:FUSER_ID)))
14:09:29.844329 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT `t`.`ID` AS `t0_c0`, `t`.`FUSER_ID`
AS `t0_c1`, `t`.`ORDER_ID` AS `t0_c2`, `t`.`PRODUCT_ID` AS `t0_c3`,
`t`.`PRODUCT_PRICE_ID` AS `t0_c4`, `t`.`PRICE` AS `t0_c5`, `t`.`CURRENCY`
AS `t0_c6`, `t`.`DATE_INSERT` AS `t0_c7`, `t`.`DATE_UPDATE` AS `t0_c8`,
`t`.`WEIGHT` AS `t0_c9`, `t`.`QUANTITY` AS `t0_c10`, `t`.`LID` AS `t0_c11`,
`t`.`DELAY` AS `t0_c12`, `t`.`NAME` AS `t0_c13`, `t`.`CAN_BUY` AS `t0_c14`,
`t`.`MODULE` AS `t0_c15`, `t`.`CALLBACK_FUNC` AS `t0_c16`, `t`.`NOTES` AS
`t0_c17`, `t`.`ORDER_CALLBACK_FUNC` AS `t0_c18`, `t`.`DETAIL_PAGE_URL` AS
`t0_c19`, `t`.`DISCOUNT_PRICE` AS `t0_c20`, `t`.`CANCEL_CALLBACK_FUNC` AS
`t0_c21`, `t`.`PAY_CALLBACK_FUNC` AS `t0_c22`, `t`.`CATALOG_XML_ID` AS
`t0_c23`, `t`.`PRODUCT_XML_ID` AS `t0_c24`, `t`.`DISCOUNT_NAME` AS
`t0_c25`, `t`.`DISCOUNT_VALUE` AS `t0_c26`, `t`.`DISCOUNT_COUPON` AS
`t0_c27`, `t`.`VAT_RATE` AS `t0_c28`, `t`.`PURCHASE_PRICE` AS `t0_c29`,
`t`.`CAR_ID` AS `t0_c30`, `t`.`EXPEND_ID` AS `t0_c31`,
`t`.`LINKED_PRODUCT_ID` AS `t0_c32`, `t`.`LINKED_MPRODUCT_ID` AS `t0_c33`,
`t`.`basket_id` AS `t0_c34`, `t`.`product_avail` AS `t0_c35` FROM
`b_sale_basket` `t`  WHERE ((ORDER_ID IS NULL AND DELAY IN("N","F")) AND
(FUSER_ID=:FUSER_ID)))
14:09:29.844582 trace system.CModule
Loading "assetManager" application component
14:09:29.844840 trace system.db.ar.CActiveRecord
DeliveryCalcMain.find()
14:09:29.845010 trace system.db.CDbCommand
Querying SQL: SHOW FULL COLUMNS FROM `sp_delivery_calc_main`
14:09:29.845016 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SHOW FULL COLUMNS FROM
`sp_delivery_calc_main`)
14:09:29.845602 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SHOW FULL COLUMNS FROM
`sp_delivery_calc_main`)
14:09:29.845691 trace system.db.CDbCommand
Querying SQL: SHOW CREATE TABLE `sp_delivery_calc_main`
14:09:29.845695 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SHOW CREATE TABLE `sp_delivery_calc_main`)
14:09:29.845935 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SHOW CREATE TABLE `sp_delivery_calc_main`)
14:09:29.845942 trace system.caching.CMemCache
Saving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:sp_delivery_calc_main"
to cache
14:09:29.846110 trace system.db.CDbCommand
Querying SQL: SELECT * FROM `sp_delivery_calc_main` `t` WHERE t.location_id
= :location_id LIMIT 1
14:09:29.846112 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)
14:09:29.846296 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)
14:09:29.847563 trace system.CModule
Loading "redisCache" application component
14:09:29.848293 trace system.caching.CRedisCache
Serving "sberid_AA\Service\OAuth\Clients\SberIdClient_sberid_authState"
from cache
14:09:29.848608 trace system.caching.CRedisCache
Serving "sberid_AA\Service\OAuth\Clients\SberIdClient_sberid_authState"
from cache
14:09:29.848792 profile application
begin:loading session
14:09:29.848798 profile application
end:loading session
14:09:29.850523 trace system.CModule
Loading "order" application component
14:09:29.854249 trace system.CModule
Loading "IPropeties" application component
14:09:29.857817 trace system.caching.CMemCache
Serving "iblock_properties_0" from cache
14:09:29.858376 trace system.caching.CMemCache
Serving "iblock_properties_0getPropValues1408" from cache
14:09:29.858798 trace system.caching.CMemCache
Serving "IWarehouseIWarehouse::getStaticList" from cache
14:09:29.858920 trace system.db.ar.CActiveRecord
TPSupToTer.findAll()
14:09:29.858927 trace system.CModule
Loading "dbTP" application component
14:09:29.858946 trace system.db.CDbConnection
Opening DB connection
14:09:29.860111 trace system.db.CDbCommand
Querying SQL: SHOW FULL COLUMNS FROM `tbl_sup_to_ter`
14:09:29.861222 trace system.db.CDbCommand
Querying SQL: SHOW CREATE TABLE `tbl_sup_to_ter`
14:09:29.861478 trace system.caching.CMemCache
Saving
"yii:dbschemamysql:host=192.168.0.1;dbname=tp:alliance-auto:{{sup_to_ter}}"
to cache
14:09:29.861849 trace system.db.CDbCommand
Querying SQL: SHOW FULL COLUMNS FROM `tbl_supplier_delivery_settings`
14:09:29.862433 trace system.db.CDbCommand
Querying SQL: SHOW CREATE TABLE `tbl_supplier_delivery_settings`
14:09:29.862622 trace system.caching.CMemCache
Saving
"yii:dbschemamysql:host=192.168.0.1;dbname=tp:alliance-auto:{{supplier_delivery_settings}}"
to cache
14:09:29.862886 trace system.db.CDbCommand
Querying SQL: SELECT `t`.`id` AS `t0_c0`, `t`.`ter_id` AS `t0_c1`,
`t`.`sup_id` AS `t0_c2`, `t`.`margin` AS `t0_c3`, `t`.`delivery_ext` AS
`t0_c4`, `t`.`price_min` AS `t0_c5`, `t`.`type` AS `t0_c6`,
`t`.`is_price_purchase_edit` AS `t0_c7`, `t`.`is_price_retail_edit` AS
`t0_c8`, `t`.`use_standart_margin` AS `t0_c9`, `t`.`purchase_price_field`
AS `t0_c10`, `t`.`rating` AS `t0_c11`, `t`.`for_retail` AS `t0_c12`,
`t`.`for_purchase` AS `t0_c13`, `t`.`is_native` AS `t0_c14`,
`t`.`delivery_end_time` AS `t0_c15`, `t`.`delivery_get_orders` AS `t0_c16`,
`t`.`delivery_shipment_orders` AS `t0_c17`, `t`.`is_modified` AS `t0_c18`,
`t`.`is_zzap` AS `t0_c19`, `t`.`email` AS `t0_c20`, `t`.`theme` AS
`t0_c21`, `t`.`message` AS `t0_c22`, `t`.`params` AS `t0_c23`,
`t`.`is_price_rr_use` AS `t0_c24`, `t`.`is_price_erp_less_deny` AS
`t0_c25`, `t`.`parish_territory` AS `t0_c26`, `delivery`.`id` AS `t1_c0`,
`delivery`.`supplier_id` AS `t1_c1`, `delivery`.`territory_id` AS `t1_c2`,
`delivery`.`week_day` AS `t1_c3`, `delivery`.`time_start` AS `t1_c4`,
`delivery`.`time_end` AS `t1_c5`, `delivery`.`add_days` AS `t1_c6`,
`delivery`.`work_days` AS `t1_c7`, `delivery`.`comment` AS `t1_c8`,
`delivery`.`time_finish` AS `t1_c9` FROM `tbl_sup_to_ter` `t`  LEFT OUTER
JOIN `tbl_supplier_delivery_settings` `delivery` ON
(`delivery`.`supplier_id`=`t`.`sup_id`) AND
(`delivery`.`territory_id`=`t`.`ter_id`) WHERE (t.ter_id=:ter_id)
14:09:29.888550 trace system.CModule
Loading "ICatalog" application component
14:09:29.888797 trace system.caching.CMemCache
Serving "b_catalog_group1" from cache
14:09:29.889276 trace system.db.CDbCommand
Querying SQL: call get_all_parts_by_art_no_link_v4_11("2503408117", 66, 66)
14:09:29.889281 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(call
get_all_parts_by_art_no_link_v4_11("2503408117", 66, 66))
14:09:29.892817 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(call
get_all_parts_by_art_no_link_v4_11("2503408117", 66, 66))
14:09:29.897124 trace system.CModule
Loading "dbTecDoc" application component
14:09:29.897151 trace system.db.CDbConnection
Opening DB connection
14:09:29.898071 trace system.db.CDbCommand
Querying SQL: SELECT
    		  DISTINCT ab.level_id, ab.name, lan.description,
ab.is_russian_manufacturer
    	FROM
    		tp.tbl_analogs lan
    		INNER JOIN tp.tbl_allbrands ab ON (ab.id = lan.brand_id)
    	WHERE
    		lan.art_search = :art
14:09:29.899348 trace system.db.CDbCommand
Querying SQL: SHOW FULL COLUMNS FROM `b_iblock_element`
14:09:29.899352 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `b_iblock_element`)
14:09:29.900084 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `b_iblock_element`)
14:09:29.900351 trace system.db.CDbCommand
Querying SQL: SHOW CREATE TABLE `b_iblock_element`
14:09:29.900353 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SHOW CREATE TABLE `b_iblock_element`)
14:09:29.900650 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SHOW CREATE TABLE `b_iblock_element`)
14:09:29.900661 trace system.caching.CMemCache
Saving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:b_iblock_element"
to cache
14:09:29.901201 trace system.db.ar.CActiveRecord
TPSupToTer.findAll()
14:09:29.901427 trace system.db.CDbCommand
Querying SQL: SELECT `t`.`id` AS `t0_c0`, `t`.`ter_id` AS `t0_c1`,
`t`.`sup_id` AS `t0_c2`, `t`.`margin` AS `t0_c3`, `t`.`delivery_ext` AS
`t0_c4`, `t`.`price_min` AS `t0_c5`, `t`.`type` AS `t0_c6`,
`t`.`is_price_purchase_edit` AS `t0_c7`, `t`.`is_price_retail_edit` AS
`t0_c8`, `t`.`use_standart_margin` AS `t0_c9`, `t`.`purchase_price_field`
AS `t0_c10`, `t`.`rating` AS `t0_c11`, `t`.`for_retail` AS `t0_c12`,
`t`.`for_purchase` AS `t0_c13`, `t`.`is_native` AS `t0_c14`,
`t`.`delivery_end_time` AS `t0_c15`, `t`.`delivery_get_orders` AS `t0_c16`,
`t`.`delivery_shipment_orders` AS `t0_c17`, `t`.`is_modified` AS `t0_c18`,
`t`.`is_zzap` AS `t0_c19`, `t`.`email` AS `t0_c20`, `t`.`theme` AS
`t0_c21`, `t`.`message` AS `t0_c22`, `t`.`params` AS `t0_c23`,
`t`.`is_price_rr_use` AS `t0_c24`, `t`.`is_price_erp_less_deny` AS
`t0_c25`, `t`.`parish_territory` AS `t0_c26`, `delivery`.`id` AS `t1_c0`,
`delivery`.`supplier_id` AS `t1_c1`, `delivery`.`territory_id` AS `t1_c2`,
`delivery`.`week_day` AS `t1_c3`, `delivery`.`time_start` AS `t1_c4`,
`delivery`.`time_end` AS `t1_c5`, `delivery`.`add_days` AS `t1_c6`,
`delivery`.`work_days` AS `t1_c7`, `delivery`.`comment` AS `t1_c8`,
`delivery`.`time_finish` AS `t1_c9` FROM `tbl_sup_to_ter` `t`  LEFT OUTER
JOIN `tbl_supplier_delivery_settings` `delivery` ON
(`delivery`.`supplier_id`=`t`.`sup_id`) AND
(`delivery`.`territory_id`=`t`.`ter_id`) WHERE (t.ter_id=:ter_id)
14:09:29.929905 trace system.db.CDbCommand
Querying SQL: SELECT `NAME`, `CODE`
FROM `b_iblock_element` `t`
LEFT JOIN `b_iblock_element_property` `mp` ON mp.IBLOCK_ELEMENT_ID = t.ID
WHERE IBLOCK_ID =:block_id AND IBLOCK_PROPERTY_ID =:prop_id AND VALUE
=:value AND (t.NAME LIKE :word0)
14:09:29.929912 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT `NAME`, `CODE`
FROM `b_iblock_element` `t`
LEFT JOIN `b_iblock_element_property` `mp` ON mp.IBLOCK_ELEMENT_ID = t.ID
WHERE IBLOCK_ID =:block_id AND IBLOCK_PROPERTY_ID =:prop_id AND VALUE
=:value AND (t.NAME LIKE :word0))
14:09:29.930532 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT `NAME`, `CODE`
FROM `b_iblock_element` `t`
LEFT JOIN `b_iblock_element_property` `mp` ON mp.IBLOCK_ELEMENT_ID = t.ID
WHERE IBLOCK_ID =:block_id AND IBLOCK_PROPERTY_ID =:prop_id AND VALUE
=:value AND (t.NAME LIKE :word0))
14:09:29.930721 trace system.db.CDbCommand
Querying SQL: SELECT `t`.`NAME` AS `pattern`, `t`.`CODE` AS `replace`
FROM `b_iblock_element` `t`
LEFT JOIN `b_iblock_element_property` `mp` ON mp.IBLOCK_ELEMENT_ID = t.ID
WHERE IBLOCK_ID = :block_id AND IBLOCK_PROPERTY_ID = :prop_id AND VALUE =
:value
14:09:29.930723 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT `t`.`NAME` AS `pattern`, `t`.`CODE`
AS `replace`
FROM `b_iblock_element` `t`
LEFT JOIN `b_iblock_element_property` `mp` ON mp.IBLOCK_ELEMENT_ID = t.ID
WHERE IBLOCK_ID = :block_id AND IBLOCK_PROPERTY_ID = :prop_id AND VALUE =
:value)
14:09:29.930993 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT `t`.`NAME` AS `pattern`, `t`.`CODE`
AS `replace`
FROM `b_iblock_element` `t`
LEFT JOIN `b_iblock_element_property` `mp` ON mp.IBLOCK_ELEMENT_ID = t.ID
WHERE IBLOCK_ID = :block_id AND IBLOCK_PROPERTY_ID = :prop_id AND VALUE =
:value)
14:09:29.931490 profile application
begin:Sphinx index catalog,catalog_morph,marketplace
14:09:29.934613 profile application
begin:Sphinx search. total_found: 0; time: 0.001
14:09:30.035131 profile application
begin:Sphinx index im_content
14:09:30.036205 profile application
begin:Sphinx search. total_found: 0; time: 0.000
14:09:30.036324 trace system.db.CDbCommand
Querying SQL: SELECT
    		  DISTINCT ab.level_id, ab.name, lan.description,
ab.is_russian_manufacturer
    	FROM
    		tp.tbl_analogs lan
    		INNER JOIN tp.tbl_allbrands ab ON (ab.id = lan.brand_id)
    	WHERE
    		lan.art_search = :art
14:09:30.036802 trace system.CModule
Loading "goodTpl" application component
14:09:30.036896 trace system.CModule
Loading "GoodSections" application component
14:09:30.036947 trace system.CModule
Loading "fcache" application component
14:09:30.047283 trace system.caching.CFileCache
Serving "good_sections_tree5" from cache
14:09:30.047566 trace system.db.CDbCommand
Querying SQL: SHOW FULL COLUMNS FROM `b_iblock_section`
14:09:30.047571 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `b_iblock_section`)
14:09:30.048340 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `b_iblock_section`)
14:09:30.048612 trace system.db.CDbCommand
Querying SQL: SHOW CREATE TABLE `b_iblock_section`
14:09:30.048614 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SHOW CREATE TABLE `b_iblock_section`)
14:09:30.048959 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SHOW CREATE TABLE `b_iblock_section`)
14:09:30.048974 trace system.caching.CMemCache
Saving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:b_iblock_section"
to cache
14:09:30.049398 trace system.caching.CMemCache
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:b_uts_iblock_49_section"
from cache
14:09:30.049904 trace system.CModule
Loading "widgetFactory" application component
14:09:30.050175 trace system.CModule
Loading "coreMessages" application component
14:09:30.050307 trace system.CModule
Loading "clientScript" application component
14:09:30.053050 trace system.caching.CMemCache
Serving "CB:name:global_search_no_results_mobile" from cache
14:09:30.054054 trace system.caching.CMemCache
Serving "GoodsShortListWidget_043c037720362f7577b735c50699edd5" from cache
14:09:30.055011 trace system.db.ar.CActiveRecord
Good.findAll()
14:09:30.055340 trace system.db.CDbCommand
Querying SQL: SHOW FULL COLUMNS FROM `b_file`
14:09:30.055344 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `b_file`)
14:09:30.055964 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `b_file`)
14:09:30.056072 trace system.db.CDbCommand
Querying SQL: SHOW CREATE TABLE `b_file`
14:09:30.056076 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SHOW CREATE TABLE `b_file`)
14:09:30.056303 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SHOW CREATE TABLE `b_file`)
14:09:30.056312 trace system.caching.CMemCache
Saving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:b_file" to
cache
14:09:30.056647 trace system.db.CDbCommand
Querying SQL: SHOW FULL COLUMNS FROM `sp_catalog2msections`
14:09:30.056651 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SHOW FULL COLUMNS FROM
`sp_catalog2msections`)
14:09:30.057192 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SHOW FULL COLUMNS FROM
`sp_catalog2msections`)
14:09:30.057250 trace system.db.CDbCommand
Querying SQL: SHOW CREATE TABLE `sp_catalog2msections`
14:09:30.057252 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SHOW CREATE TABLE `sp_catalog2msections`)
14:09:30.057466 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SHOW CREATE TABLE `sp_catalog2msections`)
14:09:30.057475 trace system.caching.CMemCache
Saving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:sp_catalog2msections"
to cache
14:09:30.057797 trace system.db.CDbCommand
Querying SQL: SELECT `t`.`ID` AS `t0_c0`, `t`.`TIMESTAMP_X` AS `t0_c1`,
`t`.`MODIFIED_BY` AS `t0_c2`, `t`.`DATE_CREATE` AS `t0_c3`,
`t`.`CREATED_BY` AS `t0_c4`, `t`.`IBLOCK_ID` AS `t0_c5`,
`t`.`IBLOCK_SECTION_ID` AS `t0_c6`, `t`.`ACTIVE` AS `t0_c7`,
`t`.`ACTIVE_FROM` AS `t0_c8`, `t`.`ACTIVE_TO` AS `t0_c9`, `t`.`SORT` AS
`t0_c10`, `t`.`NAME` AS `t0_c11`, `t`.`PREVIEW_PICTURE` AS `t0_c12`,
`t`.`PREVIEW_TEXT` AS `t0_c13`, `t`.`PREVIEW_TEXT_TYPE` AS `t0_c14`,
`t`.`DETAIL_PICTURE` AS `t0_c15`, `t`.`DETAIL_TEXT` AS `t0_c16`,
`t`.`DETAIL_TEXT_TYPE` AS `t0_c17`, `t`.`SEARCHABLE_CONTENT` AS `t0_c18`,
`t`.`WF_STATUS_ID` AS `t0_c19`, `t`.`WF_PARENT_ELEMENT_ID` AS `t0_c20`,
`t`.`WF_NEW` AS `t0_c21`, `t`.`WF_LOCKED_BY` AS `t0_c22`,
`t`.`WF_DATE_LOCK` AS `t0_c23`, `t`.`WF_COMMENTS` AS `t0_c24`,
`t`.`IN_SECTIONS` AS `t0_c25`, `t`.`XML_ID` AS `t0_c26`, `t`.`CODE` AS
`t0_c27`, `t`.`TAGS` AS `t0_c28`, `t`.`TMP_ID` AS `t0_c29`,
`t`.`WF_LAST_HISTORY_ID` AS `t0_c30`, `t`.`SHOW_COUNTER` AS `t0_c31`,
`t`.`SHOW_COUNTER_START` AS `t0_c32`, `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_iblock_element` `t`  LEFT OUTER JOIN `b_file` `pp` ON
(`t`.`PREVIEW_PICTURE`=`pp`.`ID`) WHERE ((t.IBLOCK_ID = 24) AND (t.ID IN
(:ycp0, :ycp1, :ycp2, :ycp3, :ycp4, :ycp5, :ycp6, :ycp7, :ycp8)))
14:09:30.057801 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT `t`.`ID` AS `t0_c0`,
`t`.`TIMESTAMP_X` AS `t0_c1`, `t`.`MODIFIED_BY` AS `t0_c2`,
`t`.`DATE_CREATE` AS `t0_c3`, `t`.`CREATED_BY` AS `t0_c4`, `t`.`IBLOCK_ID`
AS `t0_c5`, `t`.`IBLOCK_SECTION_ID` AS `t0_c6`, `t`.`ACTIVE` AS `t0_c7`,
`t`.`ACTIVE_FROM` AS `t0_c8`, `t`.`ACTIVE_TO` AS `t0_c9`, `t`.`SORT` AS
`t0_c10`, `t`.`NAME` AS `t0_c11`, `t`.`PREVIEW_PICTURE` AS `t0_c12`,
`t`.`PREVIEW_TEXT` AS `t0_c13`, `t`.`PREVIEW_TEXT_TYPE` AS `t0_c14`,
`t`.`DETAIL_PICTURE` AS `t0_c15`, `t`.`DETAIL_TEXT` AS `t0_c16`,
`t`.`DETAIL_TEXT_TYPE` AS `t0_c17`, `t`.`SEARCHABLE_CONTENT` AS `t0_c18`,
`t`.`WF_STATUS_ID` AS `t0_c19`, `t`.`WF_PARENT_ELEMENT_ID` AS `t0_c20`,
`t`.`WF_NEW` AS `t0_c21`, `t`.`WF_LOCKED_BY` AS `t0_c22`,
`t`.`WF_DATE_LOCK` AS `t0_c23`, `t`.`WF_COMMENTS` AS `t0_c24`,
`t`.`IN_SECTIONS` AS `t0_c25`, `t`.`XML_ID` AS `t0_c26`, `t`.`CODE` AS
`t0_c27`, `t`.`TAGS` AS `t0_c28`, `t`.`TMP_ID` AS `t0_c29`,
`t`.`WF_LAST_HISTORY_ID` AS `t0_c30`, `t`.`SHOW_COUNTER` AS `t0_c31`,
`t`.`SHOW_COUNTER_START` AS `t0_c32`, `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_iblock_element` `t`  LEFT OUTER JOIN `b_file` `pp` ON
(`t`.`PREVIEW_PICTURE`=`pp`.`ID`) WHERE ((t.IBLOCK_ID = 24) AND (t.ID IN
(:ycp0, :ycp1, :ycp2, :ycp3, :ycp4, :ycp5, :ycp6, :ycp7, :ycp8))))
14:09:30.058665 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT `t`.`ID` AS `t0_c0`,
`t`.`TIMESTAMP_X` AS `t0_c1`, `t`.`MODIFIED_BY` AS `t0_c2`,
`t`.`DATE_CREATE` AS `t0_c3`, `t`.`CREATED_BY` AS `t0_c4`, `t`.`IBLOCK_ID`
AS `t0_c5`, `t`.`IBLOCK_SECTION_ID` AS `t0_c6`, `t`.`ACTIVE` AS `t0_c7`,
`t`.`ACTIVE_FROM` AS `t0_c8`, `t`.`ACTIVE_TO` AS `t0_c9`, `t`.`SORT` AS
`t0_c10`, `t`.`NAME` AS `t0_c11`, `t`.`PREVIEW_PICTURE` AS `t0_c12`,
`t`.`PREVIEW_TEXT` AS `t0_c13`, `t`.`PREVIEW_TEXT_TYPE` AS `t0_c14`,
`t`.`DETAIL_PICTURE` AS `t0_c15`, `t`.`DETAIL_TEXT` AS `t0_c16`,
`t`.`DETAIL_TEXT_TYPE` AS `t0_c17`, `t`.`SEARCHABLE_CONTENT` AS `t0_c18`,
`t`.`WF_STATUS_ID` AS `t0_c19`, `t`.`WF_PARENT_ELEMENT_ID` AS `t0_c20`,
`t`.`WF_NEW` AS `t0_c21`, `t`.`WF_LOCKED_BY` AS `t0_c22`,
`t`.`WF_DATE_LOCK` AS `t0_c23`, `t`.`WF_COMMENTS` AS `t0_c24`,
`t`.`IN_SECTIONS` AS `t0_c25`, `t`.`XML_ID` AS `t0_c26`, `t`.`CODE` AS
`t0_c27`, `t`.`TAGS` AS `t0_c28`, `t`.`TMP_ID` AS `t0_c29`,
`t`.`WF_LAST_HISTORY_ID` AS `t0_c30`, `t`.`SHOW_COUNTER` AS `t0_c31`,
`t`.`SHOW_COUNTER_START` AS `t0_c32`, `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_iblock_element` `t`  LEFT OUTER JOIN `b_file` `pp` ON
(`t`.`PREVIEW_PICTURE`=`pp`.`ID`) WHERE ((t.IBLOCK_ID = 24) AND (t.ID IN
(:ycp0, :ycp1, :ycp2, :ycp3, :ycp4, :ycp5, :ycp6, :ycp7, :ycp8))))
14:09:30.059273 trace system.db.CDbCommand
Querying SQL: SELECT `t`.`ID` AS `t0_c0`, `ms`.`ELEMENT_ID` AS `t2_c0`,
`ms`.`SECTION_ID` AS `t2_c1`, `ms`.`IBLOCK_ID` AS `t2_c2`, `ms`.`NUM` AS
`t2_c3` FROM `b_iblock_element` `t` LEFT OUTER JOIN `sp_catalog2msections`
`ms` ON (`ms`.`ELEMENT_ID`=`t`.`ID`) AND (ms.IBLOCK_ID = 49)  WHERE
(`t`.`ID` IN (6493896, 80759379, 82286831, 128996927, 200352894, 211295640,
228900132, 233331345, 233402439))
14:09:30.059278 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT `t`.`ID` AS `t0_c0`,
`ms`.`ELEMENT_ID` AS `t2_c0`, `ms`.`SECTION_ID` AS `t2_c1`,
`ms`.`IBLOCK_ID` AS `t2_c2`, `ms`.`NUM` AS `t2_c3` FROM `b_iblock_element`
`t` LEFT OUTER JOIN `sp_catalog2msections` `ms` ON
(`ms`.`ELEMENT_ID`=`t`.`ID`) AND (ms.IBLOCK_ID = 49)  WHERE (`t`.`ID` IN
(6493896, 80759379, 82286831, 128996927, 200352894, 211295640, 228900132,
233331345, 233402439)))
14:09:30.059555 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT `t`.`ID` AS `t0_c0`,
`ms`.`ELEMENT_ID` AS `t2_c0`, `ms`.`SECTION_ID` AS `t2_c1`,
`ms`.`IBLOCK_ID` AS `t2_c2`, `ms`.`NUM` AS `t2_c3` FROM `b_iblock_element`
`t` LEFT OUTER JOIN `sp_catalog2msections` `ms` ON
(`ms`.`ELEMENT_ID`=`t`.`ID`) AND (ms.IBLOCK_ID = 49)  WHERE (`t`.`ID` IN
(6493896, 80759379, 82286831, 128996927, 200352894, 211295640, 228900132,
233331345, 233402439)))
14:09:30.061347 trace system.CModule
Loading "warehouse" application component
14:09:30.061634 trace system.caching.CMemCache
Serving "IWarehouse1" from cache
14:09:30.064081 trace system.db.ar.CActiveRecord
lazy loading Good.mproperties
14:09:30.064299 trace system.db.CDbCommand
Querying SQL: SHOW FULL COLUMNS FROM `b_iblock_element_property`
14:09:30.064301 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SHOW FULL COLUMNS FROM
`b_iblock_element_property`)
14:09:30.064866 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SHOW FULL COLUMNS FROM
`b_iblock_element_property`)
14:09:30.064949 trace system.db.CDbCommand
Querying SQL: SHOW CREATE TABLE `b_iblock_element_property`
14:09:30.064950 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SHOW CREATE TABLE
`b_iblock_element_property`)
14:09:30.065190 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SHOW CREATE TABLE
`b_iblock_element_property`)
14:09:30.065201 trace system.caching.CMemCache
Saving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:b_iblock_element_property"
to cache
14:09:30.065434 trace system.db.CDbCommand
Querying SQL: SELECT `mp`.`ID` AS `t1_c0`, `mp`.`IBLOCK_PROPERTY_ID` AS
`t1_c1`, `mp`.`IBLOCK_ELEMENT_ID` AS `t1_c2`, `mp`.`VALUE` AS `t1_c3`,
`mp`.`VALUE_TYPE` AS `t1_c4`, `mp`.`VALUE_ENUM` AS `t1_c5`,
`mp`.`VALUE_NUM` AS `t1_c6`, `mp`.`DESCRIPTION` AS `t1_c7` FROM
`b_iblock_element_property` `mp`  WHERE (`mp`.`IBLOCK_ELEMENT_ID`=:ypl0)
14:09:30.065438 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT `mp`.`ID` AS `t1_c0`,
`mp`.`IBLOCK_PROPERTY_ID` AS `t1_c1`, `mp`.`IBLOCK_ELEMENT_ID` AS `t1_c2`,
`mp`.`VALUE` AS `t1_c3`, `mp`.`VALUE_TYPE` AS `t1_c4`, `mp`.`VALUE_ENUM` AS
`t1_c5`, `mp`.`VALUE_NUM` AS `t1_c6`, `mp`.`DESCRIPTION` AS `t1_c7` FROM
`b_iblock_element_property` `mp`  WHERE (`mp`.`IBLOCK_ELEMENT_ID`=:ypl0))
14:09:30.066292 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT `mp`.`ID` AS `t1_c0`,
`mp`.`IBLOCK_PROPERTY_ID` AS `t1_c1`, `mp`.`IBLOCK_ELEMENT_ID` AS `t1_c2`,
`mp`.`VALUE` AS `t1_c3`, `mp`.`VALUE_TYPE` AS `t1_c4`, `mp`.`VALUE_ENUM` AS
`t1_c5`, `mp`.`VALUE_NUM` AS `t1_c6`, `mp`.`DESCRIPTION` AS `t1_c7` FROM
`b_iblock_element_property` `mp`  WHERE (`mp`.`IBLOCK_ELEMENT_ID`=:ypl0))
14:09:30.079473 trace system.db.ar.CActiveRecord
lazy loading Good.mproperties
14:09:30.079608 trace system.db.CDbCommand
Querying SQL: SELECT `mp`.`ID` AS `t1_c0`, `mp`.`IBLOCK_PROPERTY_ID` AS
`t1_c1`, `mp`.`IBLOCK_ELEMENT_ID` AS `t1_c2`, `mp`.`VALUE` AS `t1_c3`,
`mp`.`VALUE_TYPE` AS `t1_c4`, `mp`.`VALUE_ENUM` AS `t1_c5`,
`mp`.`VALUE_NUM` AS `t1_c6`, `mp`.`DESCRIPTION` AS `t1_c7` FROM
`b_iblock_element_property` `mp`  WHERE (`mp`.`IBLOCK_ELEMENT_ID`=:ypl0)
14:09:30.079612 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT `mp`.`ID` AS `t1_c0`,
`mp`.`IBLOCK_PROPERTY_ID` AS `t1_c1`, `mp`.`IBLOCK_ELEMENT_ID` AS `t1_c2`,
`mp`.`VALUE` AS `t1_c3`, `mp`.`VALUE_TYPE` AS `t1_c4`, `mp`.`VALUE_ENUM` AS
`t1_c5`, `mp`.`VALUE_NUM` AS `t1_c6`, `mp`.`DESCRIPTION` AS `t1_c7` FROM
`b_iblock_element_property` `mp`  WHERE (`mp`.`IBLOCK_ELEMENT_ID`=:ypl0))
14:09:30.080029 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT `mp`.`ID` AS `t1_c0`,
`mp`.`IBLOCK_PROPERTY_ID` AS `t1_c1`, `mp`.`IBLOCK_ELEMENT_ID` AS `t1_c2`,
`mp`.`VALUE` AS `t1_c3`, `mp`.`VALUE_TYPE` AS `t1_c4`, `mp`.`VALUE_ENUM` AS
`t1_c5`, `mp`.`VALUE_NUM` AS `t1_c6`, `mp`.`DESCRIPTION` AS `t1_c7` FROM
`b_iblock_element_property` `mp`  WHERE (`mp`.`IBLOCK_ELEMENT_ID`=:ypl0))
14:09:30.088463 trace system.CModule
Loading "microdataManager" application component
14:09:30.090764 trace system.caching.CRedisCache
Serving "sberid_AA\Service\OAuth\Clients\SberIdClient_sberid_authState"
from cache
14:09:30.091029 trace system.caching.CRedisCache
Serving "sberid_AA\Service\OAuth\Clients\SberIdClient_sberid_authState"
from cache
14:09:30.091250 trace system.caching.CRedisCache
Saving
"sso_b5a21f62775797c9b42790715480006d68913c498bacdabf934209f46df1ca5b" to
cache
14:09:30.097497 trace system.caching.CMemCache
Serving "CB:name:top_alert_mobile" from cache
14:09:30.099256 trace system.caching.CMemCache
Serving "CB:name:bottom_for_buyer_mobile" from cache
14:09:30.099975 trace system.CModule
Loading "territory" application component
14:09:30.104693 trace system.caching.CMemCache
Serving "ITerritory3" from cache
14:09:30.107291 trace system.caching.CMemCache
Serving "iblock_properties_0getPropValues1045" from cache
14:09:30.114422 trace system.caching.CMemCache
Serving "CB:name:bottom_job_mobile" from cache
14:09:30.115221 trace system.caching.CMemCache
Serving "CB:name:partners_mobile" from cache
14:09:30.117966 trace system.db.ar.CActiveRecord
Cart.count()
14:09:30.118060 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
14:09:30.118063 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)
14:09:30.118360 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)
14:09:30.119575 trace system.CModule
Loading "yandexEcom" application component