Loading "log" application component

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

Loading "db" application component

Opening DB connection

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

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

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

Loading "urlHelper" application component

Loading "DBConfig" application component

Loading "cache" application component

Serving "66307959e0460a2e2436b0319b2fda14" from cache

Loading "geo" application component

Loading "request" application component

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

Location.findByPk()

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

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

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

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)

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)

Loading "user" application component

begin:loading session

Loading "session" application component

end:loading session

OutLocation.findByPk()

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

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

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

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

Loading "B2BConfig" application component

Loading "urlManager" application component

Serving "Yii.CUrlManager.rules" from cache

Loading "themeInterlayer" application component

Loading "themeManager" application component

Loading "clientScript" application component

Running filter DBReadUncomitedLevelFilter.filter()

Executing SQL: SET SESSION TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;

begin:system.db.CDbCommand.execute(SET SESSION TRANSACTION ISOLATION LEVEL
READ UNCOMMITTED;)

end:system.db.CDbCommand.execute(SET SESSION TRANSACTION ISOLATION LEVEL
READ UNCOMMITTED;)

Loading "cart" application component

CartUser.find()

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

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

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

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

Loading "coupon" application component

Loading "assetManager" application component

DeliveryCalcMain.find()

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

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

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

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

Loading "redisCache" application component

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

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

begin:loading session

end:loading session

Loading "order" application component

Loading "IPropeties" application component

Serving "iblock_properties_0" from cache

Serving "iblock_properties_0getPropValues1408" from cache

Serving "IWarehouseIWarehouse::getStaticList" from cache

TPSupToTer.findAll()

Loading "dbTP" application component

Opening DB connection

Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=tp:alliance-auto:{{sup_to_ter}}"
from cache

Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=tp:alliance-auto:{{supplier_delivery_settings}}"
from cache

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)

Loading "ICatalog" application component

Serving "b_catalog_group1" from cache

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

TPSupToTer.findAll()

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)

Querying SQL: SELECT DISTINCT `t`.`NAME`, `t`.`CODE`
FROM `b_iblock_element` `t`
LEFT JOIN `b_iblock_element_property` `mp` ON mp.IBLOCK_ELEMENT_ID = t.ID
WHERE t.IBLOCK_ID = :block_id AND t.ACTIVE = :active AND
mp.IBLOCK_PROPERTY_ID = :prop_id AND mp.VALUE = :value AND (t.NAME LIKE
:word0 ESCAPE '=' OR t.NAME LIKE :word1 ESCAPE '=' OR t.NAME LIKE :word2
ESCAPE '=' OR t.NAME LIKE :word3 ESCAPE '=' OR t.NAME LIKE :word4 ESCAPE
'=')

begin:system.db.CDbCommand.query(SELECT DISTINCT `t`.`NAME`, `t`.`CODE`
FROM `b_iblock_element` `t`
LEFT JOIN `b_iblock_element_property` `mp` ON mp.IBLOCK_ELEMENT_ID = t.ID
WHERE t.IBLOCK_ID = :block_id AND t.ACTIVE = :active AND
mp.IBLOCK_PROPERTY_ID = :prop_id AND mp.VALUE = :value AND (t.NAME LIKE
:word0 ESCAPE '=' OR t.NAME LIKE :word1 ESCAPE '=' OR t.NAME LIKE :word2
ESCAPE '=' OR t.NAME LIKE :word3 ESCAPE '=' OR t.NAME LIKE :word4 ESCAPE
'='))

end:system.db.CDbCommand.query(SELECT DISTINCT `t`.`NAME`, `t`.`CODE`
FROM `b_iblock_element` `t`
LEFT JOIN `b_iblock_element_property` `mp` ON mp.IBLOCK_ELEMENT_ID = t.ID
WHERE t.IBLOCK_ID = :block_id AND t.ACTIVE = :active AND
mp.IBLOCK_PROPERTY_ID = :prop_id AND mp.VALUE = :value AND (t.NAME LIKE
:word0 ESCAPE '=' OR t.NAME LIKE :word1 ESCAPE '=' OR t.NAME LIKE :word2
ESCAPE '=' OR t.NAME LIKE :word3 ESCAPE '=' OR t.NAME LIKE :word4 ESCAPE
'='))

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 t.IBLOCK_ID = :block_id AND t.ACTIVE = :active AND
mp.IBLOCK_PROPERTY_ID = :prop_id AND mp.VALUE = :value

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 t.IBLOCK_ID = :block_id AND t.ACTIVE = :active AND
mp.IBLOCK_PROPERTY_ID = :prop_id AND mp.VALUE = :value)

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 t.IBLOCK_ID = :block_id AND t.ACTIVE = :active AND
mp.IBLOCK_PROPERTY_ID = :prop_id AND mp.VALUE = :value)

begin:SELECT `p`.* FROM `search_rule_package` `p` INNER JOIN
`search_rule_state` `s` ON s.package_id=p.id WHERE (`p`.`status` =
'published') AND (`s`.`scope` = 'site') ORDER BY `p`.`id` LIMIT 1

begin:Opening DB connection: mysql:host=192.168.0.1;dbname=autoopt

end:Opening DB connection: mysql:host=192.168.0.1;dbname=autoopt

end:SELECT `p`.* FROM `search_rule_package` `p` INNER JOIN
`search_rule_state` `s` ON s.package_id=p.id WHERE (`p`.`status` =
'published') AND (`s`.`scope` = 'site') ORDER BY `p`.`id` LIMIT 1

Serving
"search_rules_package_48_c349e956cc2d64e3804bb0d820dd437f4a61f725de33fab4f08738afdde9beed"
from cache

Применение пакета поисковых правил.

Context: 
Array
(
    [package_id] => 48
    [status] => unchanged
    [rules] => Array
        (
        )

    [milliseconds] => 23.58863
)

Применение пакета поисковых правил.

Context: 
Array
(
    [package_id] => 48
    [status] => unchanged
    [rules] => Array
        (
        )

    [milliseconds] => 23.58863
)

begin:Sphinx index catalog,catalog_morph,marketplace

begin:Sphinx search. total_found: 458; time: 0.004

Good.findAll()

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

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

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

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

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)))

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))))

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))))

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

Querying SQL: SELECT `t`.`ID` AS `t0_c0`, `uf`.`id` AS `t2_c0`,
`uf`.`good_code` AS `t2_c1`, `uf`.`user_id` AS `t2_c2`, `uf`.`date_create`
AS `t2_c3`, `uf`.`date_update` AS `t2_c4`, `uf`.`status` AS `t2_c5`,
`uf`.`sorter` AS `t2_c6`, `uf`.`comment` AS `t2_c7`, `uf`.`review_id` AS
`t2_c8`, `uf`.`file_path` AS `t2_c9`, `uf`.`file_path_small` AS `t2_c10`
FROM `b_iblock_element` `t` LEFT OUTER JOIN `sp_user_good_file`
`userImage_uf` ON (`t`.`ID`=`userImage_uf`.`good_id`) LEFT OUTER JOIN
`sp_user_upload_file_for_good` `uf` ON (`uf`.`id`=`userImage_uf`.`file_id`)
AND (uf.status = :status)  WHERE (`t`.`ID` IN (213642844, 213642846,
213642848, 213642860, 213642862, 217628631, 217800931, 218413873)) ORDER BY
sorter

begin:system.db.CDbCommand.query(SELECT `t`.`ID` AS `t0_c0`, `uf`.`id` AS
`t2_c0`, `uf`.`good_code` AS `t2_c1`, `uf`.`user_id` AS `t2_c2`,
`uf`.`date_create` AS `t2_c3`, `uf`.`date_update` AS `t2_c4`, `uf`.`status`
AS `t2_c5`, `uf`.`sorter` AS `t2_c6`, `uf`.`comment` AS `t2_c7`,
`uf`.`review_id` AS `t2_c8`, `uf`.`file_path` AS `t2_c9`,
`uf`.`file_path_small` AS `t2_c10` FROM `b_iblock_element` `t` LEFT OUTER
JOIN `sp_user_good_file` `userImage_uf` ON
(`t`.`ID`=`userImage_uf`.`good_id`) LEFT OUTER JOIN
`sp_user_upload_file_for_good` `uf` ON (`uf`.`id`=`userImage_uf`.`file_id`)
AND (uf.status = :status)  WHERE (`t`.`ID` IN (213642844, 213642846,
213642848, 213642860, 213642862, 217628631, 217800931, 218413873)) ORDER BY
sorter)

end:system.db.CDbCommand.query(SELECT `t`.`ID` AS `t0_c0`, `uf`.`id` AS
`t2_c0`, `uf`.`good_code` AS `t2_c1`, `uf`.`user_id` AS `t2_c2`,
`uf`.`date_create` AS `t2_c3`, `uf`.`date_update` AS `t2_c4`, `uf`.`status`
AS `t2_c5`, `uf`.`sorter` AS `t2_c6`, `uf`.`comment` AS `t2_c7`,
`uf`.`review_id` AS `t2_c8`, `uf`.`file_path` AS `t2_c9`,
`uf`.`file_path_small` AS `t2_c10` FROM `b_iblock_element` `t` LEFT OUTER
JOIN `sp_user_good_file` `userImage_uf` ON
(`t`.`ID`=`userImage_uf`.`good_id`) LEFT OUTER JOIN
`sp_user_upload_file_for_good` `uf` ON (`uf`.`id`=`userImage_uf`.`file_id`)
AND (uf.status = :status)  WHERE (`t`.`ID` IN (213642844, 213642846,
213642848, 213642860, 213642862, 217628631, 217800931, 218413873)) ORDER BY
sorter)

Querying SQL: SELECT `t`.`ID` AS `t0_c0`, `ms`.`ELEMENT_ID` AS `t3_c0`,
`ms`.`SECTION_ID` AS `t3_c1`, `ms`.`IBLOCK_ID` AS `t3_c2`, `ms`.`NUM` AS
`t3_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 (213642844, 213642846, 213642848, 213642860, 213642862,
217628631, 217800931, 218413873))

begin:system.db.CDbCommand.query(SELECT `t`.`ID` AS `t0_c0`,
`ms`.`ELEMENT_ID` AS `t3_c0`, `ms`.`SECTION_ID` AS `t3_c1`,
`ms`.`IBLOCK_ID` AS `t3_c2`, `ms`.`NUM` AS `t3_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
(213642844, 213642846, 213642848, 213642860, 213642862, 217628631,
217800931, 218413873)))

end:system.db.CDbCommand.query(SELECT `t`.`ID` AS `t0_c0`,
`ms`.`ELEMENT_ID` AS `t3_c0`, `ms`.`SECTION_ID` AS `t3_c1`,
`ms`.`IBLOCK_ID` AS `t3_c2`, `ms`.`NUM` AS `t3_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
(213642844, 213642846, 213642848, 213642860, 213642862, 217628631,
217800931, 218413873)))

Querying SQL: SELECT `t`.`ID` AS `t0_c0`, `mp`.`ID` AS `t4_c0`,
`mp`.`IBLOCK_PROPERTY_ID` AS `t4_c1`, `mp`.`IBLOCK_ELEMENT_ID` AS `t4_c2`,
`mp`.`VALUE` AS `t4_c3`, `mp`.`VALUE_TYPE` AS `t4_c4`, `mp`.`VALUE_ENUM` AS
`t4_c5`, `mp`.`VALUE_NUM` AS `t4_c6`, `mp`.`DESCRIPTION` AS `t4_c7` FROM
`b_iblock_element` `t` LEFT OUTER JOIN `b_iblock_element_property` `mp` ON
(`mp`.`IBLOCK_ELEMENT_ID`=`t`.`ID`) AND (mp.IBLOCK_PROPERTY_ID IN
(2455,436,437,1892,2467))  WHERE (`t`.`ID` IN (213642844, 213642846,
213642848, 213642860, 213642862, 217628631, 217800931, 218413873))

begin:system.db.CDbCommand.query(SELECT `t`.`ID` AS `t0_c0`, `mp`.`ID` AS
`t4_c0`, `mp`.`IBLOCK_PROPERTY_ID` AS `t4_c1`, `mp`.`IBLOCK_ELEMENT_ID` AS
`t4_c2`, `mp`.`VALUE` AS `t4_c3`, `mp`.`VALUE_TYPE` AS `t4_c4`,
`mp`.`VALUE_ENUM` AS `t4_c5`, `mp`.`VALUE_NUM` AS `t4_c6`,
`mp`.`DESCRIPTION` AS `t4_c7` FROM `b_iblock_element` `t` LEFT OUTER JOIN
`b_iblock_element_property` `mp` ON (`mp`.`IBLOCK_ELEMENT_ID`=`t`.`ID`) AND
(mp.IBLOCK_PROPERTY_ID IN (2455,436,437,1892,2467))  WHERE (`t`.`ID` IN
(213642844, 213642846, 213642848, 213642860, 213642862, 217628631,
217800931, 218413873)))

end:system.db.CDbCommand.query(SELECT `t`.`ID` AS `t0_c0`, `mp`.`ID` AS
`t4_c0`, `mp`.`IBLOCK_PROPERTY_ID` AS `t4_c1`, `mp`.`IBLOCK_ELEMENT_ID` AS
`t4_c2`, `mp`.`VALUE` AS `t4_c3`, `mp`.`VALUE_TYPE` AS `t4_c4`,
`mp`.`VALUE_ENUM` AS `t4_c5`, `mp`.`VALUE_NUM` AS `t4_c6`,
`mp`.`DESCRIPTION` AS `t4_c7` FROM `b_iblock_element` `t` LEFT OUTER JOIN
`b_iblock_element_property` `mp` ON (`mp`.`IBLOCK_ELEMENT_ID`=`t`.`ID`) AND
(mp.IBLOCK_PROPERTY_ID IN (2455,436,437,1892,2467))  WHERE (`t`.`ID` IN
(213642844, 213642846, 213642848, 213642860, 213642862, 217628631,
217800931, 218413873)))

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 t.IBLOCK_ID = :block_id AND t.ACTIVE = :active AND
mp.IBLOCK_PROPERTY_ID = :prop_id AND mp.VALUE = :value

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 t.IBLOCK_ID = :block_id AND t.ACTIVE = :active AND
mp.IBLOCK_PROPERTY_ID = :prop_id AND mp.VALUE = :value)

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 t.IBLOCK_ID = :block_id AND t.ACTIVE = :active AND
mp.IBLOCK_PROPERTY_ID = :prop_id AND mp.VALUE = :value)

TPSupToTer.findAll()

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)

begin:Sphinx select id,@groupby,@distinct,@count,property_msection_id

begin:Sphinx index catalog,catalog_morph,marketplace

begin:Sphinx search. total_found: 143; time: 0.009

Loading "GoodSections" application component

Loading "fcache" application component

Serving "good_sections_tree5" from cache

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

Querying SQL: call
get_applied_by_catalog_ids_query('213642844,213642846,213642848,213642860,213642862,217628631,217800931,218413873',
'1', '(cm.`name` LIKE "%236 1003114 B2%")')

begin:system.db.CDbCommand.query(call
get_applied_by_catalog_ids_query('213642844,213642846,213642848,213642860,213642862,217628631,217800931,218413873',
'1', '(cm.`name` LIKE "%236 1003114 B2%")'))

end:system.db.CDbCommand.query(call
get_applied_by_catalog_ids_query('213642844,213642846,213642848,213642860,213642862,217628631,217800931,218413873',
'1', '(cm.`name` LIKE "%236 1003114 B2%")'))

Loading "dbTecDoc" application component

Opening DB connection

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

Loading "dbTecDoc2" application component

Opening DB connection

Querying SQL: call get_brandfilter_by_art_no_link_v7_1('2361003114B2', 49,
66, 1, 66)

Querying SQL: SELECT *
FROM `sp_rating2goods`
WHERE (((rating BETWEEN :from AND :to) OR (group_rating BETWEEN :from AND
:to) OR (rating IS NULL) OR (group_rating IS NULL))) AND (catalog_code IN
("068133","070882","070883","084926","084928","107471","125394","128996"))

begin:system.db.CDbCommand.query(SELECT *
FROM `sp_rating2goods`
WHERE (((rating BETWEEN :from AND :to) OR (group_rating BETWEEN :from AND
:to) OR (rating IS NULL) OR (group_rating IS NULL))) AND (catalog_code IN
("068133","070882","070883","084926","084928","107471","125394","128996")))

end:system.db.CDbCommand.query(SELECT *
FROM `sp_rating2goods`
WHERE (((rating BETWEEN :from AND :to) OR (group_rating BETWEEN :from AND
:to) OR (rating IS NULL) OR (group_rating IS NULL))) AND (catalog_code IN
("068133","070882","070883","084926","084928","107471","125394","128996")))

Loading "warehouse" application component

Serving "IWarehouse1" from cache

Loading "goodTpl" application component

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

Loading "microdataManager" application component

Loading "widgetFactory" application component

Loading "yandexEcom" application component

CartUser.find()

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

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

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

lazy loading Good.main_groups

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

Querying SQL: SELECT `mgr`.`ID` AS `t1_c0`, `mgr`.`TIMESTAMP_X` AS `t1_c1`,
`mgr`.`MODIFIED_BY` AS `t1_c2`, `mgr`.`DATE_CREATE` AS `t1_c3`,
`mgr`.`CREATED_BY` AS `t1_c4`, `mgr`.`IBLOCK_ID` AS `t1_c5`,
`mgr`.`IBLOCK_SECTION_ID` AS `t1_c6`, `mgr`.`ACTIVE` AS `t1_c7`,
`mgr`.`GLOBAL_ACTIVE` AS `t1_c8`, `mgr`.`SORT` AS `t1_c9`, `mgr`.`NAME` AS
`t1_c10`, `mgr`.`PICTURE` AS `t1_c11`, `mgr`.`LEFT_MARGIN` AS `t1_c12`,
`mgr`.`RIGHT_MARGIN` AS `t1_c13`, `mgr`.`DEPTH_LEVEL` AS `t1_c14`,
`mgr`.`DESCRIPTION` AS `t1_c15`, `mgr`.`DESCRIPTION_TYPE` AS `t1_c16`,
`mgr`.`SEARCHABLE_CONTENT` AS `t1_c17`, `mgr`.`CODE` AS `t1_c18`,
`mgr`.`XML_ID` AS `t1_c19`, `mgr`.`TMP_ID` AS `t1_c20`,
`mgr`.`DETAIL_PICTURE` AS `t1_c21`, `mgr`.`SOCNET_GROUP_ID` AS `t1_c22`
FROM `b_iblock_section` `mgr`  INNER JOIN `b_iblock_section_element`
`main_groups_mgr` ON (`main_groups_mgr`.`IBLOCK_ELEMENT_ID`=:ypl0) AND
(`mgr`.`ID`=`main_groups_mgr`.`IBLOCK_SECTION_ID`) AND (mgr.IBLOCK_ID = 24
AND mgr.ACTIVE = "Y") ORDER BY mgr.LEFT_MARGIN, mgr.DEPTH_LEVEL

begin:system.db.CDbCommand.query(SELECT `mgr`.`ID` AS `t1_c0`,
`mgr`.`TIMESTAMP_X` AS `t1_c1`, `mgr`.`MODIFIED_BY` AS `t1_c2`,
`mgr`.`DATE_CREATE` AS `t1_c3`, `mgr`.`CREATED_BY` AS `t1_c4`,
`mgr`.`IBLOCK_ID` AS `t1_c5`, `mgr`.`IBLOCK_SECTION_ID` AS `t1_c6`,
`mgr`.`ACTIVE` AS `t1_c7`, `mgr`.`GLOBAL_ACTIVE` AS `t1_c8`, `mgr`.`SORT`
AS `t1_c9`, `mgr`.`NAME` AS `t1_c10`, `mgr`.`PICTURE` AS `t1_c11`,
`mgr`.`LEFT_MARGIN` AS `t1_c12`, `mgr`.`RIGHT_MARGIN` AS `t1_c13`,
`mgr`.`DEPTH_LEVEL` AS `t1_c14`, `mgr`.`DESCRIPTION` AS `t1_c15`,
`mgr`.`DESCRIPTION_TYPE` AS `t1_c16`, `mgr`.`SEARCHABLE_CONTENT` AS
`t1_c17`, `mgr`.`CODE` AS `t1_c18`, `mgr`.`XML_ID` AS `t1_c19`,
`mgr`.`TMP_ID` AS `t1_c20`, `mgr`.`DETAIL_PICTURE` AS `t1_c21`,
`mgr`.`SOCNET_GROUP_ID` AS `t1_c22` FROM `b_iblock_section` `mgr`  INNER
JOIN `b_iblock_section_element` `main_groups_mgr` ON
(`main_groups_mgr`.`IBLOCK_ELEMENT_ID`=:ypl0) AND
(`mgr`.`ID`=`main_groups_mgr`.`IBLOCK_SECTION_ID`) AND (mgr.IBLOCK_ID = 24
AND mgr.ACTIVE = "Y") ORDER BY mgr.LEFT_MARGIN, mgr.DEPTH_LEVEL)

end:system.db.CDbCommand.query(SELECT `mgr`.`ID` AS `t1_c0`,
`mgr`.`TIMESTAMP_X` AS `t1_c1`, `mgr`.`MODIFIED_BY` AS `t1_c2`,
`mgr`.`DATE_CREATE` AS `t1_c3`, `mgr`.`CREATED_BY` AS `t1_c4`,
`mgr`.`IBLOCK_ID` AS `t1_c5`, `mgr`.`IBLOCK_SECTION_ID` AS `t1_c6`,
`mgr`.`ACTIVE` AS `t1_c7`, `mgr`.`GLOBAL_ACTIVE` AS `t1_c8`, `mgr`.`SORT`
AS `t1_c9`, `mgr`.`NAME` AS `t1_c10`, `mgr`.`PICTURE` AS `t1_c11`,
`mgr`.`LEFT_MARGIN` AS `t1_c12`, `mgr`.`RIGHT_MARGIN` AS `t1_c13`,
`mgr`.`DEPTH_LEVEL` AS `t1_c14`, `mgr`.`DESCRIPTION` AS `t1_c15`,
`mgr`.`DESCRIPTION_TYPE` AS `t1_c16`, `mgr`.`SEARCHABLE_CONTENT` AS
`t1_c17`, `mgr`.`CODE` AS `t1_c18`, `mgr`.`XML_ID` AS `t1_c19`,
`mgr`.`TMP_ID` AS `t1_c20`, `mgr`.`DETAIL_PICTURE` AS `t1_c21`,
`mgr`.`SOCNET_GROUP_ID` AS `t1_c22` FROM `b_iblock_section` `mgr`  INNER
JOIN `b_iblock_section_element` `main_groups_mgr` ON
(`main_groups_mgr`.`IBLOCK_ELEMENT_ID`=:ypl0) AND
(`mgr`.`ID`=`main_groups_mgr`.`IBLOCK_SECTION_ID`) AND (mgr.IBLOCK_ID = 24
AND mgr.ACTIVE = "Y") ORDER BY mgr.LEFT_MARGIN, mgr.DEPTH_LEVEL)

Querying SQL: SELECT *
FROM `personal_settings`
WHERE actor_uid=:uid AND actor_type=:type_id

begin:system.db.CDbCommand.query(SELECT *
FROM `personal_settings`
WHERE actor_uid=:uid AND actor_type=:type_id)

end:system.db.CDbCommand.query(SELECT *
FROM `personal_settings`
WHERE actor_uid=:uid AND actor_type=:type_id)

ApplicationSetting.findByPk()

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

Querying SQL: SELECT * FROM `application_settings` `t` WHERE
`t`.`domain`='dev7.autoall.ru' AND
`t`.`key`='paysystems.yandexSplit.isEnabled' LIMIT 1

begin:system.db.CDbCommand.query(SELECT * FROM `application_settings` `t`
WHERE `t`.`domain`='dev7.autoall.ru' AND
`t`.`key`='paysystems.yandexSplit.isEnabled' LIMIT 1)

end:system.db.CDbCommand.query(SELECT * FROM `application_settings` `t`
WHERE `t`.`domain`='dev7.autoall.ru' AND
`t`.`key`='paysystems.yandexSplit.isEnabled' LIMIT 1)

Querying SQL: SELECT *
FROM `personal_settings`
WHERE actor_uid=:uid AND actor_type=:type_id

begin:system.db.CDbCommand.query(SELECT *
FROM `personal_settings`
WHERE actor_uid=:uid AND actor_type=:type_id)

end:system.db.CDbCommand.query(SELECT *
FROM `personal_settings`
WHERE actor_uid=:uid AND actor_type=:type_id)

ApplicationSetting.findByPk()

Querying SQL: SELECT * FROM `application_settings` `t` WHERE
`t`.`domain`='dev7.autoall.ru' AND
`t`.`key`='paysystems.sberSplit.isEnabled' LIMIT 1

begin:system.db.CDbCommand.query(SELECT * FROM `application_settings` `t`
WHERE `t`.`domain`='dev7.autoall.ru' AND
`t`.`key`='paysystems.sberSplit.isEnabled' LIMIT 1)

end:system.db.CDbCommand.query(SELECT * FROM `application_settings` `t`
WHERE `t`.`domain`='dev7.autoall.ru' AND
`t`.`key`='paysystems.sberSplit.isEnabled' LIMIT 1)

lazy loading Good.main_groups

Querying SQL: SELECT `mgr`.`ID` AS `t1_c0`, `mgr`.`TIMESTAMP_X` AS `t1_c1`,
`mgr`.`MODIFIED_BY` AS `t1_c2`, `mgr`.`DATE_CREATE` AS `t1_c3`,
`mgr`.`CREATED_BY` AS `t1_c4`, `mgr`.`IBLOCK_ID` AS `t1_c5`,
`mgr`.`IBLOCK_SECTION_ID` AS `t1_c6`, `mgr`.`ACTIVE` AS `t1_c7`,
`mgr`.`GLOBAL_ACTIVE` AS `t1_c8`, `mgr`.`SORT` AS `t1_c9`, `mgr`.`NAME` AS
`t1_c10`, `mgr`.`PICTURE` AS `t1_c11`, `mgr`.`LEFT_MARGIN` AS `t1_c12`,
`mgr`.`RIGHT_MARGIN` AS `t1_c13`, `mgr`.`DEPTH_LEVEL` AS `t1_c14`,
`mgr`.`DESCRIPTION` AS `t1_c15`, `mgr`.`DESCRIPTION_TYPE` AS `t1_c16`,
`mgr`.`SEARCHABLE_CONTENT` AS `t1_c17`, `mgr`.`CODE` AS `t1_c18`,
`mgr`.`XML_ID` AS `t1_c19`, `mgr`.`TMP_ID` AS `t1_c20`,
`mgr`.`DETAIL_PICTURE` AS `t1_c21`, `mgr`.`SOCNET_GROUP_ID` AS `t1_c22`
FROM `b_iblock_section` `mgr`  INNER JOIN `b_iblock_section_element`
`main_groups_mgr` ON (`main_groups_mgr`.`IBLOCK_ELEMENT_ID`=:ypl0) AND
(`mgr`.`ID`=`main_groups_mgr`.`IBLOCK_SECTION_ID`) AND (mgr.IBLOCK_ID = 24
AND mgr.ACTIVE = "Y") ORDER BY mgr.LEFT_MARGIN, mgr.DEPTH_LEVEL

begin:system.db.CDbCommand.query(SELECT `mgr`.`ID` AS `t1_c0`,
`mgr`.`TIMESTAMP_X` AS `t1_c1`, `mgr`.`MODIFIED_BY` AS `t1_c2`,
`mgr`.`DATE_CREATE` AS `t1_c3`, `mgr`.`CREATED_BY` AS `t1_c4`,
`mgr`.`IBLOCK_ID` AS `t1_c5`, `mgr`.`IBLOCK_SECTION_ID` AS `t1_c6`,
`mgr`.`ACTIVE` AS `t1_c7`, `mgr`.`GLOBAL_ACTIVE` AS `t1_c8`, `mgr`.`SORT`
AS `t1_c9`, `mgr`.`NAME` AS `t1_c10`, `mgr`.`PICTURE` AS `t1_c11`,
`mgr`.`LEFT_MARGIN` AS `t1_c12`, `mgr`.`RIGHT_MARGIN` AS `t1_c13`,
`mgr`.`DEPTH_LEVEL` AS `t1_c14`, `mgr`.`DESCRIPTION` AS `t1_c15`,
`mgr`.`DESCRIPTION_TYPE` AS `t1_c16`, `mgr`.`SEARCHABLE_CONTENT` AS
`t1_c17`, `mgr`.`CODE` AS `t1_c18`, `mgr`.`XML_ID` AS `t1_c19`,
`mgr`.`TMP_ID` AS `t1_c20`, `mgr`.`DETAIL_PICTURE` AS `t1_c21`,
`mgr`.`SOCNET_GROUP_ID` AS `t1_c22` FROM `b_iblock_section` `mgr`  INNER
JOIN `b_iblock_section_element` `main_groups_mgr` ON
(`main_groups_mgr`.`IBLOCK_ELEMENT_ID`=:ypl0) AND
(`mgr`.`ID`=`main_groups_mgr`.`IBLOCK_SECTION_ID`) AND (mgr.IBLOCK_ID = 24
AND mgr.ACTIVE = "Y") ORDER BY mgr.LEFT_MARGIN, mgr.DEPTH_LEVEL)

end:system.db.CDbCommand.query(SELECT `mgr`.`ID` AS `t1_c0`,
`mgr`.`TIMESTAMP_X` AS `t1_c1`, `mgr`.`MODIFIED_BY` AS `t1_c2`,
`mgr`.`DATE_CREATE` AS `t1_c3`, `mgr`.`CREATED_BY` AS `t1_c4`,
`mgr`.`IBLOCK_ID` AS `t1_c5`, `mgr`.`IBLOCK_SECTION_ID` AS `t1_c6`,
`mgr`.`ACTIVE` AS `t1_c7`, `mgr`.`GLOBAL_ACTIVE` AS `t1_c8`, `mgr`.`SORT`
AS `t1_c9`, `mgr`.`NAME` AS `t1_c10`, `mgr`.`PICTURE` AS `t1_c11`,
`mgr`.`LEFT_MARGIN` AS `t1_c12`, `mgr`.`RIGHT_MARGIN` AS `t1_c13`,
`mgr`.`DEPTH_LEVEL` AS `t1_c14`, `mgr`.`DESCRIPTION` AS `t1_c15`,
`mgr`.`DESCRIPTION_TYPE` AS `t1_c16`, `mgr`.`SEARCHABLE_CONTENT` AS
`t1_c17`, `mgr`.`CODE` AS `t1_c18`, `mgr`.`XML_ID` AS `t1_c19`,
`mgr`.`TMP_ID` AS `t1_c20`, `mgr`.`DETAIL_PICTURE` AS `t1_c21`,
`mgr`.`SOCNET_GROUP_ID` AS `t1_c22` FROM `b_iblock_section` `mgr`  INNER
JOIN `b_iblock_section_element` `main_groups_mgr` ON
(`main_groups_mgr`.`IBLOCK_ELEMENT_ID`=:ypl0) AND
(`mgr`.`ID`=`main_groups_mgr`.`IBLOCK_SECTION_ID`) AND (mgr.IBLOCK_ID = 24
AND mgr.ACTIVE = "Y") ORDER BY mgr.LEFT_MARGIN, mgr.DEPTH_LEVEL)

lazy loading Good.main_groups

Querying SQL: SELECT `mgr`.`ID` AS `t1_c0`, `mgr`.`TIMESTAMP_X` AS `t1_c1`,
`mgr`.`MODIFIED_BY` AS `t1_c2`, `mgr`.`DATE_CREATE` AS `t1_c3`,
`mgr`.`CREATED_BY` AS `t1_c4`, `mgr`.`IBLOCK_ID` AS `t1_c5`,
`mgr`.`IBLOCK_SECTION_ID` AS `t1_c6`, `mgr`.`ACTIVE` AS `t1_c7`,
`mgr`.`GLOBAL_ACTIVE` AS `t1_c8`, `mgr`.`SORT` AS `t1_c9`, `mgr`.`NAME` AS
`t1_c10`, `mgr`.`PICTURE` AS `t1_c11`, `mgr`.`LEFT_MARGIN` AS `t1_c12`,
`mgr`.`RIGHT_MARGIN` AS `t1_c13`, `mgr`.`DEPTH_LEVEL` AS `t1_c14`,
`mgr`.`DESCRIPTION` AS `t1_c15`, `mgr`.`DESCRIPTION_TYPE` AS `t1_c16`,
`mgr`.`SEARCHABLE_CONTENT` AS `t1_c17`, `mgr`.`CODE` AS `t1_c18`,
`mgr`.`XML_ID` AS `t1_c19`, `mgr`.`TMP_ID` AS `t1_c20`,
`mgr`.`DETAIL_PICTURE` AS `t1_c21`, `mgr`.`SOCNET_GROUP_ID` AS `t1_c22`
FROM `b_iblock_section` `mgr`  INNER JOIN `b_iblock_section_element`
`main_groups_mgr` ON (`main_groups_mgr`.`IBLOCK_ELEMENT_ID`=:ypl0) AND
(`mgr`.`ID`=`main_groups_mgr`.`IBLOCK_SECTION_ID`) AND (mgr.IBLOCK_ID = 24
AND mgr.ACTIVE = "Y") ORDER BY mgr.LEFT_MARGIN, mgr.DEPTH_LEVEL

begin:system.db.CDbCommand.query(SELECT `mgr`.`ID` AS `t1_c0`,
`mgr`.`TIMESTAMP_X` AS `t1_c1`, `mgr`.`MODIFIED_BY` AS `t1_c2`,
`mgr`.`DATE_CREATE` AS `t1_c3`, `mgr`.`CREATED_BY` AS `t1_c4`,
`mgr`.`IBLOCK_ID` AS `t1_c5`, `mgr`.`IBLOCK_SECTION_ID` AS `t1_c6`,
`mgr`.`ACTIVE` AS `t1_c7`, `mgr`.`GLOBAL_ACTIVE` AS `t1_c8`, `mgr`.`SORT`
AS `t1_c9`, `mgr`.`NAME` AS `t1_c10`, `mgr`.`PICTURE` AS `t1_c11`,
`mgr`.`LEFT_MARGIN` AS `t1_c12`, `mgr`.`RIGHT_MARGIN` AS `t1_c13`,
`mgr`.`DEPTH_LEVEL` AS `t1_c14`, `mgr`.`DESCRIPTION` AS `t1_c15`,
`mgr`.`DESCRIPTION_TYPE` AS `t1_c16`, `mgr`.`SEARCHABLE_CONTENT` AS
`t1_c17`, `mgr`.`CODE` AS `t1_c18`, `mgr`.`XML_ID` AS `t1_c19`,
`mgr`.`TMP_ID` AS `t1_c20`, `mgr`.`DETAIL_PICTURE` AS `t1_c21`,
`mgr`.`SOCNET_GROUP_ID` AS `t1_c22` FROM `b_iblock_section` `mgr`  INNER
JOIN `b_iblock_section_element` `main_groups_mgr` ON
(`main_groups_mgr`.`IBLOCK_ELEMENT_ID`=:ypl0) AND
(`mgr`.`ID`=`main_groups_mgr`.`IBLOCK_SECTION_ID`) AND (mgr.IBLOCK_ID = 24
AND mgr.ACTIVE = "Y") ORDER BY mgr.LEFT_MARGIN, mgr.DEPTH_LEVEL)

end:system.db.CDbCommand.query(SELECT `mgr`.`ID` AS `t1_c0`,
`mgr`.`TIMESTAMP_X` AS `t1_c1`, `mgr`.`MODIFIED_BY` AS `t1_c2`,
`mgr`.`DATE_CREATE` AS `t1_c3`, `mgr`.`CREATED_BY` AS `t1_c4`,
`mgr`.`IBLOCK_ID` AS `t1_c5`, `mgr`.`IBLOCK_SECTION_ID` AS `t1_c6`,
`mgr`.`ACTIVE` AS `t1_c7`, `mgr`.`GLOBAL_ACTIVE` AS `t1_c8`, `mgr`.`SORT`
AS `t1_c9`, `mgr`.`NAME` AS `t1_c10`, `mgr`.`PICTURE` AS `t1_c11`,
`mgr`.`LEFT_MARGIN` AS `t1_c12`, `mgr`.`RIGHT_MARGIN` AS `t1_c13`,
`mgr`.`DEPTH_LEVEL` AS `t1_c14`, `mgr`.`DESCRIPTION` AS `t1_c15`,
`mgr`.`DESCRIPTION_TYPE` AS `t1_c16`, `mgr`.`SEARCHABLE_CONTENT` AS
`t1_c17`, `mgr`.`CODE` AS `t1_c18`, `mgr`.`XML_ID` AS `t1_c19`,
`mgr`.`TMP_ID` AS `t1_c20`, `mgr`.`DETAIL_PICTURE` AS `t1_c21`,
`mgr`.`SOCNET_GROUP_ID` AS `t1_c22` FROM `b_iblock_section` `mgr`  INNER
JOIN `b_iblock_section_element` `main_groups_mgr` ON
(`main_groups_mgr`.`IBLOCK_ELEMENT_ID`=:ypl0) AND
(`mgr`.`ID`=`main_groups_mgr`.`IBLOCK_SECTION_ID`) AND (mgr.IBLOCK_ID = 24
AND mgr.ACTIVE = "Y") ORDER BY mgr.LEFT_MARGIN, mgr.DEPTH_LEVEL)

lazy loading Good.main_groups

Querying SQL: SELECT `mgr`.`ID` AS `t1_c0`, `mgr`.`TIMESTAMP_X` AS `t1_c1`,
`mgr`.`MODIFIED_BY` AS `t1_c2`, `mgr`.`DATE_CREATE` AS `t1_c3`,
`mgr`.`CREATED_BY` AS `t1_c4`, `mgr`.`IBLOCK_ID` AS `t1_c5`,
`mgr`.`IBLOCK_SECTION_ID` AS `t1_c6`, `mgr`.`ACTIVE` AS `t1_c7`,
`mgr`.`GLOBAL_ACTIVE` AS `t1_c8`, `mgr`.`SORT` AS `t1_c9`, `mgr`.`NAME` AS
`t1_c10`, `mgr`.`PICTURE` AS `t1_c11`, `mgr`.`LEFT_MARGIN` AS `t1_c12`,
`mgr`.`RIGHT_MARGIN` AS `t1_c13`, `mgr`.`DEPTH_LEVEL` AS `t1_c14`,
`mgr`.`DESCRIPTION` AS `t1_c15`, `mgr`.`DESCRIPTION_TYPE` AS `t1_c16`,
`mgr`.`SEARCHABLE_CONTENT` AS `t1_c17`, `mgr`.`CODE` AS `t1_c18`,
`mgr`.`XML_ID` AS `t1_c19`, `mgr`.`TMP_ID` AS `t1_c20`,
`mgr`.`DETAIL_PICTURE` AS `t1_c21`, `mgr`.`SOCNET_GROUP_ID` AS `t1_c22`
FROM `b_iblock_section` `mgr`  INNER JOIN `b_iblock_section_element`
`main_groups_mgr` ON (`main_groups_mgr`.`IBLOCK_ELEMENT_ID`=:ypl0) AND
(`mgr`.`ID`=`main_groups_mgr`.`IBLOCK_SECTION_ID`) AND (mgr.IBLOCK_ID = 24
AND mgr.ACTIVE = "Y") ORDER BY mgr.LEFT_MARGIN, mgr.DEPTH_LEVEL

begin:system.db.CDbCommand.query(SELECT `mgr`.`ID` AS `t1_c0`,
`mgr`.`TIMESTAMP_X` AS `t1_c1`, `mgr`.`MODIFIED_BY` AS `t1_c2`,
`mgr`.`DATE_CREATE` AS `t1_c3`, `mgr`.`CREATED_BY` AS `t1_c4`,
`mgr`.`IBLOCK_ID` AS `t1_c5`, `mgr`.`IBLOCK_SECTION_ID` AS `t1_c6`,
`mgr`.`ACTIVE` AS `t1_c7`, `mgr`.`GLOBAL_ACTIVE` AS `t1_c8`, `mgr`.`SORT`
AS `t1_c9`, `mgr`.`NAME` AS `t1_c10`, `mgr`.`PICTURE` AS `t1_c11`,
`mgr`.`LEFT_MARGIN` AS `t1_c12`, `mgr`.`RIGHT_MARGIN` AS `t1_c13`,
`mgr`.`DEPTH_LEVEL` AS `t1_c14`, `mgr`.`DESCRIPTION` AS `t1_c15`,
`mgr`.`DESCRIPTION_TYPE` AS `t1_c16`, `mgr`.`SEARCHABLE_CONTENT` AS
`t1_c17`, `mgr`.`CODE` AS `t1_c18`, `mgr`.`XML_ID` AS `t1_c19`,
`mgr`.`TMP_ID` AS `t1_c20`, `mgr`.`DETAIL_PICTURE` AS `t1_c21`,
`mgr`.`SOCNET_GROUP_ID` AS `t1_c22` FROM `b_iblock_section` `mgr`  INNER
JOIN `b_iblock_section_element` `main_groups_mgr` ON
(`main_groups_mgr`.`IBLOCK_ELEMENT_ID`=:ypl0) AND
(`mgr`.`ID`=`main_groups_mgr`.`IBLOCK_SECTION_ID`) AND (mgr.IBLOCK_ID = 24
AND mgr.ACTIVE = "Y") ORDER BY mgr.LEFT_MARGIN, mgr.DEPTH_LEVEL)

end:system.db.CDbCommand.query(SELECT `mgr`.`ID` AS `t1_c0`,
`mgr`.`TIMESTAMP_X` AS `t1_c1`, `mgr`.`MODIFIED_BY` AS `t1_c2`,
`mgr`.`DATE_CREATE` AS `t1_c3`, `mgr`.`CREATED_BY` AS `t1_c4`,
`mgr`.`IBLOCK_ID` AS `t1_c5`, `mgr`.`IBLOCK_SECTION_ID` AS `t1_c6`,
`mgr`.`ACTIVE` AS `t1_c7`, `mgr`.`GLOBAL_ACTIVE` AS `t1_c8`, `mgr`.`SORT`
AS `t1_c9`, `mgr`.`NAME` AS `t1_c10`, `mgr`.`PICTURE` AS `t1_c11`,
`mgr`.`LEFT_MARGIN` AS `t1_c12`, `mgr`.`RIGHT_MARGIN` AS `t1_c13`,
`mgr`.`DEPTH_LEVEL` AS `t1_c14`, `mgr`.`DESCRIPTION` AS `t1_c15`,
`mgr`.`DESCRIPTION_TYPE` AS `t1_c16`, `mgr`.`SEARCHABLE_CONTENT` AS
`t1_c17`, `mgr`.`CODE` AS `t1_c18`, `mgr`.`XML_ID` AS `t1_c19`,
`mgr`.`TMP_ID` AS `t1_c20`, `mgr`.`DETAIL_PICTURE` AS `t1_c21`,
`mgr`.`SOCNET_GROUP_ID` AS `t1_c22` FROM `b_iblock_section` `mgr`  INNER
JOIN `b_iblock_section_element` `main_groups_mgr` ON
(`main_groups_mgr`.`IBLOCK_ELEMENT_ID`=:ypl0) AND
(`mgr`.`ID`=`main_groups_mgr`.`IBLOCK_SECTION_ID`) AND (mgr.IBLOCK_ID = 24
AND mgr.ACTIVE = "Y") ORDER BY mgr.LEFT_MARGIN, mgr.DEPTH_LEVEL)

lazy loading Good.main_groups

Querying SQL: SELECT `mgr`.`ID` AS `t1_c0`, `mgr`.`TIMESTAMP_X` AS `t1_c1`,
`mgr`.`MODIFIED_BY` AS `t1_c2`, `mgr`.`DATE_CREATE` AS `t1_c3`,
`mgr`.`CREATED_BY` AS `t1_c4`, `mgr`.`IBLOCK_ID` AS `t1_c5`,
`mgr`.`IBLOCK_SECTION_ID` AS `t1_c6`, `mgr`.`ACTIVE` AS `t1_c7`,
`mgr`.`GLOBAL_ACTIVE` AS `t1_c8`, `mgr`.`SORT` AS `t1_c9`, `mgr`.`NAME` AS
`t1_c10`, `mgr`.`PICTURE` AS `t1_c11`, `mgr`.`LEFT_MARGIN` AS `t1_c12`,
`mgr`.`RIGHT_MARGIN` AS `t1_c13`, `mgr`.`DEPTH_LEVEL` AS `t1_c14`,
`mgr`.`DESCRIPTION` AS `t1_c15`, `mgr`.`DESCRIPTION_TYPE` AS `t1_c16`,
`mgr`.`SEARCHABLE_CONTENT` AS `t1_c17`, `mgr`.`CODE` AS `t1_c18`,
`mgr`.`XML_ID` AS `t1_c19`, `mgr`.`TMP_ID` AS `t1_c20`,
`mgr`.`DETAIL_PICTURE` AS `t1_c21`, `mgr`.`SOCNET_GROUP_ID` AS `t1_c22`
FROM `b_iblock_section` `mgr`  INNER JOIN `b_iblock_section_element`
`main_groups_mgr` ON (`main_groups_mgr`.`IBLOCK_ELEMENT_ID`=:ypl0) AND
(`mgr`.`ID`=`main_groups_mgr`.`IBLOCK_SECTION_ID`) AND (mgr.IBLOCK_ID = 24
AND mgr.ACTIVE = "Y") ORDER BY mgr.LEFT_MARGIN, mgr.DEPTH_LEVEL

begin:system.db.CDbCommand.query(SELECT `mgr`.`ID` AS `t1_c0`,
`mgr`.`TIMESTAMP_X` AS `t1_c1`, `mgr`.`MODIFIED_BY` AS `t1_c2`,
`mgr`.`DATE_CREATE` AS `t1_c3`, `mgr`.`CREATED_BY` AS `t1_c4`,
`mgr`.`IBLOCK_ID` AS `t1_c5`, `mgr`.`IBLOCK_SECTION_ID` AS `t1_c6`,
`mgr`.`ACTIVE` AS `t1_c7`, `mgr`.`GLOBAL_ACTIVE` AS `t1_c8`, `mgr`.`SORT`
AS `t1_c9`, `mgr`.`NAME` AS `t1_c10`, `mgr`.`PICTURE` AS `t1_c11`,
`mgr`.`LEFT_MARGIN` AS `t1_c12`, `mgr`.`RIGHT_MARGIN` AS `t1_c13`,
`mgr`.`DEPTH_LEVEL` AS `t1_c14`, `mgr`.`DESCRIPTION` AS `t1_c15`,
`mgr`.`DESCRIPTION_TYPE` AS `t1_c16`, `mgr`.`SEARCHABLE_CONTENT` AS
`t1_c17`, `mgr`.`CODE` AS `t1_c18`, `mgr`.`XML_ID` AS `t1_c19`,
`mgr`.`TMP_ID` AS `t1_c20`, `mgr`.`DETAIL_PICTURE` AS `t1_c21`,
`mgr`.`SOCNET_GROUP_ID` AS `t1_c22` FROM `b_iblock_section` `mgr`  INNER
JOIN `b_iblock_section_element` `main_groups_mgr` ON
(`main_groups_mgr`.`IBLOCK_ELEMENT_ID`=:ypl0) AND
(`mgr`.`ID`=`main_groups_mgr`.`IBLOCK_SECTION_ID`) AND (mgr.IBLOCK_ID = 24
AND mgr.ACTIVE = "Y") ORDER BY mgr.LEFT_MARGIN, mgr.DEPTH_LEVEL)

end:system.db.CDbCommand.query(SELECT `mgr`.`ID` AS `t1_c0`,
`mgr`.`TIMESTAMP_X` AS `t1_c1`, `mgr`.`MODIFIED_BY` AS `t1_c2`,
`mgr`.`DATE_CREATE` AS `t1_c3`, `mgr`.`CREATED_BY` AS `t1_c4`,
`mgr`.`IBLOCK_ID` AS `t1_c5`, `mgr`.`IBLOCK_SECTION_ID` AS `t1_c6`,
`mgr`.`ACTIVE` AS `t1_c7`, `mgr`.`GLOBAL_ACTIVE` AS `t1_c8`, `mgr`.`SORT`
AS `t1_c9`, `mgr`.`NAME` AS `t1_c10`, `mgr`.`PICTURE` AS `t1_c11`,
`mgr`.`LEFT_MARGIN` AS `t1_c12`, `mgr`.`RIGHT_MARGIN` AS `t1_c13`,
`mgr`.`DEPTH_LEVEL` AS `t1_c14`, `mgr`.`DESCRIPTION` AS `t1_c15`,
`mgr`.`DESCRIPTION_TYPE` AS `t1_c16`, `mgr`.`SEARCHABLE_CONTENT` AS
`t1_c17`, `mgr`.`CODE` AS `t1_c18`, `mgr`.`XML_ID` AS `t1_c19`,
`mgr`.`TMP_ID` AS `t1_c20`, `mgr`.`DETAIL_PICTURE` AS `t1_c21`,
`mgr`.`SOCNET_GROUP_ID` AS `t1_c22` FROM `b_iblock_section` `mgr`  INNER
JOIN `b_iblock_section_element` `main_groups_mgr` ON
(`main_groups_mgr`.`IBLOCK_ELEMENT_ID`=:ypl0) AND
(`mgr`.`ID`=`main_groups_mgr`.`IBLOCK_SECTION_ID`) AND (mgr.IBLOCK_ID = 24
AND mgr.ACTIVE = "Y") ORDER BY mgr.LEFT_MARGIN, mgr.DEPTH_LEVEL)

lazy loading Good.main_groups

Querying SQL: SELECT `mgr`.`ID` AS `t1_c0`, `mgr`.`TIMESTAMP_X` AS `t1_c1`,
`mgr`.`MODIFIED_BY` AS `t1_c2`, `mgr`.`DATE_CREATE` AS `t1_c3`,
`mgr`.`CREATED_BY` AS `t1_c4`, `mgr`.`IBLOCK_ID` AS `t1_c5`,
`mgr`.`IBLOCK_SECTION_ID` AS `t1_c6`, `mgr`.`ACTIVE` AS `t1_c7`,
`mgr`.`GLOBAL_ACTIVE` AS `t1_c8`, `mgr`.`SORT` AS `t1_c9`, `mgr`.`NAME` AS
`t1_c10`, `mgr`.`PICTURE` AS `t1_c11`, `mgr`.`LEFT_MARGIN` AS `t1_c12`,
`mgr`.`RIGHT_MARGIN` AS `t1_c13`, `mgr`.`DEPTH_LEVEL` AS `t1_c14`,
`mgr`.`DESCRIPTION` AS `t1_c15`, `mgr`.`DESCRIPTION_TYPE` AS `t1_c16`,
`mgr`.`SEARCHABLE_CONTENT` AS `t1_c17`, `mgr`.`CODE` AS `t1_c18`,
`mgr`.`XML_ID` AS `t1_c19`, `mgr`.`TMP_ID` AS `t1_c20`,
`mgr`.`DETAIL_PICTURE` AS `t1_c21`, `mgr`.`SOCNET_GROUP_ID` AS `t1_c22`
FROM `b_iblock_section` `mgr`  INNER JOIN `b_iblock_section_element`
`main_groups_mgr` ON (`main_groups_mgr`.`IBLOCK_ELEMENT_ID`=:ypl0) AND
(`mgr`.`ID`=`main_groups_mgr`.`IBLOCK_SECTION_ID`) AND (mgr.IBLOCK_ID = 24
AND mgr.ACTIVE = "Y") ORDER BY mgr.LEFT_MARGIN, mgr.DEPTH_LEVEL

begin:system.db.CDbCommand.query(SELECT `mgr`.`ID` AS `t1_c0`,
`mgr`.`TIMESTAMP_X` AS `t1_c1`, `mgr`.`MODIFIED_BY` AS `t1_c2`,
`mgr`.`DATE_CREATE` AS `t1_c3`, `mgr`.`CREATED_BY` AS `t1_c4`,
`mgr`.`IBLOCK_ID` AS `t1_c5`, `mgr`.`IBLOCK_SECTION_ID` AS `t1_c6`,
`mgr`.`ACTIVE` AS `t1_c7`, `mgr`.`GLOBAL_ACTIVE` AS `t1_c8`, `mgr`.`SORT`
AS `t1_c9`, `mgr`.`NAME` AS `t1_c10`, `mgr`.`PICTURE` AS `t1_c11`,
`mgr`.`LEFT_MARGIN` AS `t1_c12`, `mgr`.`RIGHT_MARGIN` AS `t1_c13`,
`mgr`.`DEPTH_LEVEL` AS `t1_c14`, `mgr`.`DESCRIPTION` AS `t1_c15`,
`mgr`.`DESCRIPTION_TYPE` AS `t1_c16`, `mgr`.`SEARCHABLE_CONTENT` AS
`t1_c17`, `mgr`.`CODE` AS `t1_c18`, `mgr`.`XML_ID` AS `t1_c19`,
`mgr`.`TMP_ID` AS `t1_c20`, `mgr`.`DETAIL_PICTURE` AS `t1_c21`,
`mgr`.`SOCNET_GROUP_ID` AS `t1_c22` FROM `b_iblock_section` `mgr`  INNER
JOIN `b_iblock_section_element` `main_groups_mgr` ON
(`main_groups_mgr`.`IBLOCK_ELEMENT_ID`=:ypl0) AND
(`mgr`.`ID`=`main_groups_mgr`.`IBLOCK_SECTION_ID`) AND (mgr.IBLOCK_ID = 24
AND mgr.ACTIVE = "Y") ORDER BY mgr.LEFT_MARGIN, mgr.DEPTH_LEVEL)

end:system.db.CDbCommand.query(SELECT `mgr`.`ID` AS `t1_c0`,
`mgr`.`TIMESTAMP_X` AS `t1_c1`, `mgr`.`MODIFIED_BY` AS `t1_c2`,
`mgr`.`DATE_CREATE` AS `t1_c3`, `mgr`.`CREATED_BY` AS `t1_c4`,
`mgr`.`IBLOCK_ID` AS `t1_c5`, `mgr`.`IBLOCK_SECTION_ID` AS `t1_c6`,
`mgr`.`ACTIVE` AS `t1_c7`, `mgr`.`GLOBAL_ACTIVE` AS `t1_c8`, `mgr`.`SORT`
AS `t1_c9`, `mgr`.`NAME` AS `t1_c10`, `mgr`.`PICTURE` AS `t1_c11`,
`mgr`.`LEFT_MARGIN` AS `t1_c12`, `mgr`.`RIGHT_MARGIN` AS `t1_c13`,
`mgr`.`DEPTH_LEVEL` AS `t1_c14`, `mgr`.`DESCRIPTION` AS `t1_c15`,
`mgr`.`DESCRIPTION_TYPE` AS `t1_c16`, `mgr`.`SEARCHABLE_CONTENT` AS
`t1_c17`, `mgr`.`CODE` AS `t1_c18`, `mgr`.`XML_ID` AS `t1_c19`,
`mgr`.`TMP_ID` AS `t1_c20`, `mgr`.`DETAIL_PICTURE` AS `t1_c21`,
`mgr`.`SOCNET_GROUP_ID` AS `t1_c22` FROM `b_iblock_section` `mgr`  INNER
JOIN `b_iblock_section_element` `main_groups_mgr` ON
(`main_groups_mgr`.`IBLOCK_ELEMENT_ID`=:ypl0) AND
(`mgr`.`ID`=`main_groups_mgr`.`IBLOCK_SECTION_ID`) AND (mgr.IBLOCK_ID = 24
AND mgr.ACTIVE = "Y") ORDER BY mgr.LEFT_MARGIN, mgr.DEPTH_LEVEL)

lazy loading Good.main_groups

Querying SQL: SELECT `mgr`.`ID` AS `t1_c0`, `mgr`.`TIMESTAMP_X` AS `t1_c1`,
`mgr`.`MODIFIED_BY` AS `t1_c2`, `mgr`.`DATE_CREATE` AS `t1_c3`,
`mgr`.`CREATED_BY` AS `t1_c4`, `mgr`.`IBLOCK_ID` AS `t1_c5`,
`mgr`.`IBLOCK_SECTION_ID` AS `t1_c6`, `mgr`.`ACTIVE` AS `t1_c7`,
`mgr`.`GLOBAL_ACTIVE` AS `t1_c8`, `mgr`.`SORT` AS `t1_c9`, `mgr`.`NAME` AS
`t1_c10`, `mgr`.`PICTURE` AS `t1_c11`, `mgr`.`LEFT_MARGIN` AS `t1_c12`,
`mgr`.`RIGHT_MARGIN` AS `t1_c13`, `mgr`.`DEPTH_LEVEL` AS `t1_c14`,
`mgr`.`DESCRIPTION` AS `t1_c15`, `mgr`.`DESCRIPTION_TYPE` AS `t1_c16`,
`mgr`.`SEARCHABLE_CONTENT` AS `t1_c17`, `mgr`.`CODE` AS `t1_c18`,
`mgr`.`XML_ID` AS `t1_c19`, `mgr`.`TMP_ID` AS `t1_c20`,
`mgr`.`DETAIL_PICTURE` AS `t1_c21`, `mgr`.`SOCNET_GROUP_ID` AS `t1_c22`
FROM `b_iblock_section` `mgr`  INNER JOIN `b_iblock_section_element`
`main_groups_mgr` ON (`main_groups_mgr`.`IBLOCK_ELEMENT_ID`=:ypl0) AND
(`mgr`.`ID`=`main_groups_mgr`.`IBLOCK_SECTION_ID`) AND (mgr.IBLOCK_ID = 24
AND mgr.ACTIVE = "Y") ORDER BY mgr.LEFT_MARGIN, mgr.DEPTH_LEVEL

begin:system.db.CDbCommand.query(SELECT `mgr`.`ID` AS `t1_c0`,
`mgr`.`TIMESTAMP_X` AS `t1_c1`, `mgr`.`MODIFIED_BY` AS `t1_c2`,
`mgr`.`DATE_CREATE` AS `t1_c3`, `mgr`.`CREATED_BY` AS `t1_c4`,
`mgr`.`IBLOCK_ID` AS `t1_c5`, `mgr`.`IBLOCK_SECTION_ID` AS `t1_c6`,
`mgr`.`ACTIVE` AS `t1_c7`, `mgr`.`GLOBAL_ACTIVE` AS `t1_c8`, `mgr`.`SORT`
AS `t1_c9`, `mgr`.`NAME` AS `t1_c10`, `mgr`.`PICTURE` AS `t1_c11`,
`mgr`.`LEFT_MARGIN` AS `t1_c12`, `mgr`.`RIGHT_MARGIN` AS `t1_c13`,
`mgr`.`DEPTH_LEVEL` AS `t1_c14`, `mgr`.`DESCRIPTION` AS `t1_c15`,
`mgr`.`DESCRIPTION_TYPE` AS `t1_c16`, `mgr`.`SEARCHABLE_CONTENT` AS
`t1_c17`, `mgr`.`CODE` AS `t1_c18`, `mgr`.`XML_ID` AS `t1_c19`,
`mgr`.`TMP_ID` AS `t1_c20`, `mgr`.`DETAIL_PICTURE` AS `t1_c21`,
`mgr`.`SOCNET_GROUP_ID` AS `t1_c22` FROM `b_iblock_section` `mgr`  INNER
JOIN `b_iblock_section_element` `main_groups_mgr` ON
(`main_groups_mgr`.`IBLOCK_ELEMENT_ID`=:ypl0) AND
(`mgr`.`ID`=`main_groups_mgr`.`IBLOCK_SECTION_ID`) AND (mgr.IBLOCK_ID = 24
AND mgr.ACTIVE = "Y") ORDER BY mgr.LEFT_MARGIN, mgr.DEPTH_LEVEL)

end:system.db.CDbCommand.query(SELECT `mgr`.`ID` AS `t1_c0`,
`mgr`.`TIMESTAMP_X` AS `t1_c1`, `mgr`.`MODIFIED_BY` AS `t1_c2`,
`mgr`.`DATE_CREATE` AS `t1_c3`, `mgr`.`CREATED_BY` AS `t1_c4`,
`mgr`.`IBLOCK_ID` AS `t1_c5`, `mgr`.`IBLOCK_SECTION_ID` AS `t1_c6`,
`mgr`.`ACTIVE` AS `t1_c7`, `mgr`.`GLOBAL_ACTIVE` AS `t1_c8`, `mgr`.`SORT`
AS `t1_c9`, `mgr`.`NAME` AS `t1_c10`, `mgr`.`PICTURE` AS `t1_c11`,
`mgr`.`LEFT_MARGIN` AS `t1_c12`, `mgr`.`RIGHT_MARGIN` AS `t1_c13`,
`mgr`.`DEPTH_LEVEL` AS `t1_c14`, `mgr`.`DESCRIPTION` AS `t1_c15`,
`mgr`.`DESCRIPTION_TYPE` AS `t1_c16`, `mgr`.`SEARCHABLE_CONTENT` AS
`t1_c17`, `mgr`.`CODE` AS `t1_c18`, `mgr`.`XML_ID` AS `t1_c19`,
`mgr`.`TMP_ID` AS `t1_c20`, `mgr`.`DETAIL_PICTURE` AS `t1_c21`,
`mgr`.`SOCNET_GROUP_ID` AS `t1_c22` FROM `b_iblock_section` `mgr`  INNER
JOIN `b_iblock_section_element` `main_groups_mgr` ON
(`main_groups_mgr`.`IBLOCK_ELEMENT_ID`=:ypl0) AND
(`mgr`.`ID`=`main_groups_mgr`.`IBLOCK_SECTION_ID`) AND (mgr.IBLOCK_ID = 24
AND mgr.ACTIVE = "Y") ORDER BY mgr.LEFT_MARGIN, mgr.DEPTH_LEVEL)

lazy loading Good.main_groups

Querying SQL: SELECT `mgr`.`ID` AS `t1_c0`, `mgr`.`TIMESTAMP_X` AS `t1_c1`,
`mgr`.`MODIFIED_BY` AS `t1_c2`, `mgr`.`DATE_CREATE` AS `t1_c3`,
`mgr`.`CREATED_BY` AS `t1_c4`, `mgr`.`IBLOCK_ID` AS `t1_c5`,
`mgr`.`IBLOCK_SECTION_ID` AS `t1_c6`, `mgr`.`ACTIVE` AS `t1_c7`,
`mgr`.`GLOBAL_ACTIVE` AS `t1_c8`, `mgr`.`SORT` AS `t1_c9`, `mgr`.`NAME` AS
`t1_c10`, `mgr`.`PICTURE` AS `t1_c11`, `mgr`.`LEFT_MARGIN` AS `t1_c12`,
`mgr`.`RIGHT_MARGIN` AS `t1_c13`, `mgr`.`DEPTH_LEVEL` AS `t1_c14`,
`mgr`.`DESCRIPTION` AS `t1_c15`, `mgr`.`DESCRIPTION_TYPE` AS `t1_c16`,
`mgr`.`SEARCHABLE_CONTENT` AS `t1_c17`, `mgr`.`CODE` AS `t1_c18`,
`mgr`.`XML_ID` AS `t1_c19`, `mgr`.`TMP_ID` AS `t1_c20`,
`mgr`.`DETAIL_PICTURE` AS `t1_c21`, `mgr`.`SOCNET_GROUP_ID` AS `t1_c22`
FROM `b_iblock_section` `mgr`  INNER JOIN `b_iblock_section_element`
`main_groups_mgr` ON (`main_groups_mgr`.`IBLOCK_ELEMENT_ID`=:ypl0) AND
(`mgr`.`ID`=`main_groups_mgr`.`IBLOCK_SECTION_ID`) AND (mgr.IBLOCK_ID = 24
AND mgr.ACTIVE = "Y") ORDER BY mgr.LEFT_MARGIN, mgr.DEPTH_LEVEL

begin:system.db.CDbCommand.query(SELECT `mgr`.`ID` AS `t1_c0`,
`mgr`.`TIMESTAMP_X` AS `t1_c1`, `mgr`.`MODIFIED_BY` AS `t1_c2`,
`mgr`.`DATE_CREATE` AS `t1_c3`, `mgr`.`CREATED_BY` AS `t1_c4`,
`mgr`.`IBLOCK_ID` AS `t1_c5`, `mgr`.`IBLOCK_SECTION_ID` AS `t1_c6`,
`mgr`.`ACTIVE` AS `t1_c7`, `mgr`.`GLOBAL_ACTIVE` AS `t1_c8`, `mgr`.`SORT`
AS `t1_c9`, `mgr`.`NAME` AS `t1_c10`, `mgr`.`PICTURE` AS `t1_c11`,
`mgr`.`LEFT_MARGIN` AS `t1_c12`, `mgr`.`RIGHT_MARGIN` AS `t1_c13`,
`mgr`.`DEPTH_LEVEL` AS `t1_c14`, `mgr`.`DESCRIPTION` AS `t1_c15`,
`mgr`.`DESCRIPTION_TYPE` AS `t1_c16`, `mgr`.`SEARCHABLE_CONTENT` AS
`t1_c17`, `mgr`.`CODE` AS `t1_c18`, `mgr`.`XML_ID` AS `t1_c19`,
`mgr`.`TMP_ID` AS `t1_c20`, `mgr`.`DETAIL_PICTURE` AS `t1_c21`,
`mgr`.`SOCNET_GROUP_ID` AS `t1_c22` FROM `b_iblock_section` `mgr`  INNER
JOIN `b_iblock_section_element` `main_groups_mgr` ON
(`main_groups_mgr`.`IBLOCK_ELEMENT_ID`=:ypl0) AND
(`mgr`.`ID`=`main_groups_mgr`.`IBLOCK_SECTION_ID`) AND (mgr.IBLOCK_ID = 24
AND mgr.ACTIVE = "Y") ORDER BY mgr.LEFT_MARGIN, mgr.DEPTH_LEVEL)

end:system.db.CDbCommand.query(SELECT `mgr`.`ID` AS `t1_c0`,
`mgr`.`TIMESTAMP_X` AS `t1_c1`, `mgr`.`MODIFIED_BY` AS `t1_c2`,
`mgr`.`DATE_CREATE` AS `t1_c3`, `mgr`.`CREATED_BY` AS `t1_c4`,
`mgr`.`IBLOCK_ID` AS `t1_c5`, `mgr`.`IBLOCK_SECTION_ID` AS `t1_c6`,
`mgr`.`ACTIVE` AS `t1_c7`, `mgr`.`GLOBAL_ACTIVE` AS `t1_c8`, `mgr`.`SORT`
AS `t1_c9`, `mgr`.`NAME` AS `t1_c10`, `mgr`.`PICTURE` AS `t1_c11`,
`mgr`.`LEFT_MARGIN` AS `t1_c12`, `mgr`.`RIGHT_MARGIN` AS `t1_c13`,
`mgr`.`DEPTH_LEVEL` AS `t1_c14`, `mgr`.`DESCRIPTION` AS `t1_c15`,
`mgr`.`DESCRIPTION_TYPE` AS `t1_c16`, `mgr`.`SEARCHABLE_CONTENT` AS
`t1_c17`, `mgr`.`CODE` AS `t1_c18`, `mgr`.`XML_ID` AS `t1_c19`,
`mgr`.`TMP_ID` AS `t1_c20`, `mgr`.`DETAIL_PICTURE` AS `t1_c21`,
`mgr`.`SOCNET_GROUP_ID` AS `t1_c22` FROM `b_iblock_section` `mgr`  INNER
JOIN `b_iblock_section_element` `main_groups_mgr` ON
(`main_groups_mgr`.`IBLOCK_ELEMENT_ID`=:ypl0) AND
(`mgr`.`ID`=`main_groups_mgr`.`IBLOCK_SECTION_ID`) AND (mgr.IBLOCK_ID = 24
AND mgr.ACTIVE = "Y") ORDER BY mgr.LEFT_MARGIN, mgr.DEPTH_LEVEL)

Loading "coreMessages" application component

Loading "GoodPropDesc" application component

Serving "iblock_properties_desc" from cache

Serving
"iblock_properties_0getPropIssetValuesByCodes180ff6cd97834c98090cbc9fafebe71b4b3936ff877adacc842399418aea71683"
from cache

Serving
"MpAttrsHelpergetAttrIssetValuesByCodesd4b463fb7a0f9130ee08d05c6e32003c0aaab4044b4fe266834bb8c368714660"
from cache

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

MpAttr.find()

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

Querying SQL: SELECT * FROM `mp_attrs` `t` WHERE global_code=:global_code
LIMIT 1

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

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

MpAttr.find()

Querying SQL: SELECT * FROM `mp_attrs` `t` WHERE global_code=:global_code
LIMIT 1

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

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

TPSupToTer.findAll()

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)

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 t.IBLOCK_ID = :block_id AND t.ACTIVE = :active AND
mp.IBLOCK_PROPERTY_ID = :prop_id AND mp.VALUE = :value

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 t.IBLOCK_ID = :block_id AND t.ACTIVE = :active AND
mp.IBLOCK_PROPERTY_ID = :prop_id AND mp.VALUE = :value)

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 t.IBLOCK_ID = :block_id AND t.ACTIVE = :active AND
mp.IBLOCK_PROPERTY_ID = :prop_id AND mp.VALUE = :value)

Saving
"MpAttrsHelpergetAttrIssetValuesByCodesd4b463fb7a0f9130ee08d05c6e32003c0aaab4044b4fe266834bb8c368714660"
to cache

Serving
"MpAttrsHelpergetAttrIssetForOurGoodsValuesByCodesd4b463fb7a0f9130ee08d05c6e32003c0aaab4044b4fe266834bb8c368714660"
from cache

Serving
"iblock_properties_0getPropIssetValuesByCoded41d8cd98f00b204e9800998ecf8427eGoodPROPERTY_MAKER_LIST854044549d8d8804bf928ae1bc88d0b0dcca48101505dd86b703689a604fe3c4"
from cache

Serving
"iblock_properties_0getPropIssetValuesByCoded41d8cd98f00b204e9800998ecf8427eGoodPROPERTY_CATGROUP854044549d8d8804bf928ae1bc88d0b0dcca48101505dd86b703689a604fe3c4"
from cache

Good.findAll()

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
(:ycp8, :ycp9, :ycp10, :ycp11)))

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
(:ycp8, :ycp9, :ycp10, :ycp11))))

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
(:ycp8, :ycp9, :ycp10, :ycp11))))

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 (220118770, 233031799, 233046343, 233076256))

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
(220118770, 233031799, 233046343, 233076256)))

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
(220118770, 233031799, 233046343, 233076256)))

lazy loading Good.mproperties

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)

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))

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))

lazy loading Good.mproperties

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)

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))

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))

lazy loading Good.mproperties

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)

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))

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))

lazy loading Good.mproperties

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)

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))

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))

CartUser.find()

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

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

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

CartUser.find()

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

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

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

Cart.count()

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

Querying SQL: SELECT COUNT(*) FROM `b_sale_basket` `t` WHERE
FUSER_ID=:FUSER_ID AND ORDER_ID IS NULL AND DELAY = :DELAY

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)

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)

Serving "CB:name:top_header_menu_delivery_desktop" from cache

Serving "CB:name:top_alert_desktop" from cache

CartUser.find()

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

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

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

CartUser.find()

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

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

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

Cart.count()

Querying SQL: SELECT COUNT(*) FROM `b_sale_basket` `t` WHERE
FUSER_ID=:FUSER_ID AND ORDER_ID IS NULL AND DELAY = :DELAY

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)

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)

Serving "CB:name:bottom_job_desktop" from cache

Serving "CB:name:partners_desktop" from cache

Serving "CB:name:bottom_for_buyer_desktop" from cache

Loading "territory" application component

Serving "ITerritory3" from cache

Serving "iblock_properties_0getPropValues1045" from cache

Serving "CB:name:bottom_copy_text_desktop" from cache