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

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

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

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

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)

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)

begin:Sphinx index catalog,catalog_morph,marketplace

begin:Sphinx search. total_found: 8626; time: 0.075

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, :ycp8, :ycp9,
:ycp10, :ycp11, :ycp12, :ycp13, :ycp14, :ycp15, :ycp16, :ycp17, :ycp18,
:ycp19, :ycp20, :ycp21, :ycp22, :ycp23, :ycp24, :ycp25, :ycp26, :ycp27)))

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, :ycp9,
:ycp10, :ycp11, :ycp12, :ycp13, :ycp14, :ycp15, :ycp16, :ycp17, :ycp18,
:ycp19, :ycp20, :ycp21, :ycp22, :ycp23, :ycp24, :ycp25, :ycp26, :ycp27))))

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, :ycp9,
:ycp10, :ycp11, :ycp12, :ycp13, :ycp14, :ycp15, :ycp16, :ycp17, :ycp18,
:ycp19, :ycp20, :ycp21, :ycp22, :ycp23, :ycp24, :ycp25, :ycp26, :ycp27))))

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 (4153320, 4172059, 4173227,
4282753, 7389429, 20500495, 50350489, 50473231, 57267677, 121839623,
150024959, 169058594, 169059446, 202255477, 206350515, 207193741,
209119011, 211073308, 223192317, 223320681, 225218541, 226630399,
226708834, 226708852, 228650422, 229227915, 232292505, 233374029)) 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 (4153320, 4172059, 4173227,
4282753, 7389429, 20500495, 50350489, 50473231, 57267677, 121839623,
150024959, 169058594, 169059446, 202255477, 206350515, 207193741,
209119011, 211073308, 223192317, 223320681, 225218541, 226630399,
226708834, 226708852, 228650422, 229227915, 232292505, 233374029)) 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 (4153320, 4172059, 4173227,
4282753, 7389429, 20500495, 50350489, 50473231, 57267677, 121839623,
150024959, 169058594, 169059446, 202255477, 206350515, 207193741,
209119011, 211073308, 223192317, 223320681, 225218541, 226630399,
226708834, 226708852, 228650422, 229227915, 232292505, 233374029)) 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 (4153320, 4172059, 4173227, 4282753, 7389429, 20500495,
50350489, 50473231, 57267677, 121839623, 150024959, 169058594, 169059446,
202255477, 206350515, 207193741, 209119011, 211073308, 223192317,
223320681, 225218541, 226630399, 226708834, 226708852, 228650422,
229227915, 232292505, 233374029))

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
(4153320, 4172059, 4173227, 4282753, 7389429, 20500495, 50350489, 50473231,
57267677, 121839623, 150024959, 169058594, 169059446, 202255477, 206350515,
207193741, 209119011, 211073308, 223192317, 223320681, 225218541,
226630399, 226708834, 226708852, 228650422, 229227915, 232292505,
233374029)))

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
(4153320, 4172059, 4173227, 4282753, 7389429, 20500495, 50350489, 50473231,
57267677, 121839623, 150024959, 169058594, 169059446, 202255477, 206350515,
207193741, 209119011, 211073308, 223192317, 223320681, 225218541,
226630399, 226708834, 226708852, 228650422, 229227915, 232292505,
233374029)))

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 (4153320, 4172059, 4173227,
4282753, 7389429, 20500495, 50350489, 50473231, 57267677, 121839623,
150024959, 169058594, 169059446, 202255477, 206350515, 207193741,
209119011, 211073308, 223192317, 223320681, 225218541, 226630399,
226708834, 226708852, 228650422, 229227915, 232292505, 233374029))

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
(4153320, 4172059, 4173227, 4282753, 7389429, 20500495, 50350489, 50473231,
57267677, 121839623, 150024959, 169058594, 169059446, 202255477, 206350515,
207193741, 209119011, 211073308, 223192317, 223320681, 225218541,
226630399, 226708834, 226708852, 228650422, 229227915, 232292505,
233374029)))

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
(4153320, 4172059, 4173227, 4282753, 7389429, 20500495, 50350489, 50473231,
57267677, 121839623, 150024959, 169058594, 169059446, 202255477, 206350515,
207193741, 209119011, 211073308, 223192317, 223320681, 225218541,
226630399, 226708834, 226708852, 228650422, 229227915, 232292505,
233374029)))

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

MpGood.findAll()

Querying SQL: SELECT * FROM `mp_goods` `t` WHERE t.id IN (:ycp28, :ycp29)

begin:system.db.CDbCommand.query(SELECT * FROM `mp_goods` `t` WHERE t.id IN
(:ycp28, :ycp29))

end:system.db.CDbCommand.query(SELECT * FROM `mp_goods` `t` WHERE t.id IN
(:ycp28, :ycp29))

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)

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

TPAllPrices.findAll()

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

Querying SQL: SELECT `t`.`id` AS `t0_c0`, `t`.`sup_id` AS `t0_c1`,
`t`.`art_search` AS `t0_c2`, `t`.`art_replace` AS `t0_c3`, `t`.`brand_id`
AS `t0_c4`, `t`.`brand_art` AS `t0_c5`, `t`.`brand_name` AS `t0_c6`,
`t`.`name` AS `t0_c7`, `t`.`name_ext` AS `t0_c8`, `t`.`quantity` AS
`t0_c9`, `t`.`quantity_min` AS `t0_c10`, `t`.`quantity_expectation` AS
`t0_c11`, `t`.`quantity_expectation_min` AS `t0_c12`, `t`.`price_id` AS
`t0_c13`, `t`.`price` AS `t0_c14`, `t`.`price_purchase` AS `t0_c15`,
`t`.`price_retail` AS `t0_c16`, `t`.`delivery_date` AS `t0_c17`,
`t`.`package_type` AS `t0_c18`, `t`.`weight` AS `t0_c19`, `t`.`weight_id`
AS `t0_c20`, `t`.`sup_code` AS `t0_c21`, `t`.`date_added` AS `t0_c22`,
`t`.`art_supplier` AS `t0_c23`, `t`.`is_im_visible` AS `t0_c24`,
`t`.`price_rr` AS `t0_c25`, os.good_id AS good_id, `suptoter`.`id` AS
`t1_c0`, `suptoter`.`ter_id` AS `t1_c1`, `suptoter`.`sup_id` AS `t1_c2`,
`suptoter`.`margin` AS `t1_c3`, `suptoter`.`delivery_ext` AS `t1_c4`,
`suptoter`.`price_min` AS `t1_c5`, `suptoter`.`type` AS `t1_c6`,
`suptoter`.`is_price_purchase_edit` AS `t1_c7`,
`suptoter`.`is_price_retail_edit` AS `t1_c8`,
`suptoter`.`use_standart_margin` AS `t1_c9`,
`suptoter`.`purchase_price_field` AS `t1_c10`, `suptoter`.`rating` AS
`t1_c11`, `suptoter`.`for_retail` AS `t1_c12`, `suptoter`.`for_purchase` AS
`t1_c13`, `suptoter`.`is_native` AS `t1_c14`,
`suptoter`.`delivery_end_time` AS `t1_c15`,
`suptoter`.`delivery_get_orders` AS `t1_c16`,
`suptoter`.`delivery_shipment_orders` AS `t1_c17`, `suptoter`.`is_modified`
AS `t1_c18`, `suptoter`.`is_zzap` AS `t1_c19`, `suptoter`.`email` AS
`t1_c20`, `suptoter`.`theme` AS `t1_c21`, `suptoter`.`message` AS `t1_c22`,
`suptoter`.`params` AS `t1_c23`, `suptoter`.`is_price_rr_use` AS `t1_c24`,
`suptoter`.`is_price_erp_less_deny` AS `t1_c25`,
`suptoter`.`parish_territory` AS `t1_c26`, `supplier`.`id` AS `t2_c0`,
`supplier`.`legal_name` AS `t2_c1`, `supplier`.`name` AS `t2_c2`,
`supplier`.`address` AS `t2_c3`, `supplier`.`contact` AS `t2_c4`,
`supplier`.`is_load_price` AS `t2_c5`, `supplier`.`load_price_params` AS
`t2_c6`, `supplier`.`srok` AS `t2_c7`, `supplier`.`nacenka` AS `t2_c8`,
`supplier`.`is_ext_price` AS `t2_c9`, `supplier`.`ext_price_model` AS
`t2_c10`, `supplier`.`tmp_table_name` AS `t2_c11`,
`supplier`.`date_updated` AS `t2_c12`, `supplier`.`type` AS `t2_c13`,
`supplier`.`cfo` AS `t2_c14`, `supplier`.`adjective_field` AS `t2_c15`,
`supplier`.`adjective_value` AS `t2_c16`,
`supplier`.`adjective_price_field` AS `t2_c17`, `supplier`.`warehouses` AS
`t2_c18`, `supplier`.`use_for_replacement` AS `t2_c19`,
`supplier`.`lf_code` AS `t2_c20`, `supplier`.`purchase_channel` AS
`t2_c21`, `supplier`.`is_purchase_auto` AS `t2_c22`,
`supplier`.`api_auth_params` AS `t2_c23`, `supplier`.`comment` AS `t2_c24`,
`supplier`.`min_order_price` AS `t2_c25`, `supplier`.`is_official` AS
`t2_c26`, `supplier`.`is_by_codes` AS `t2_c27`,
`supplier`.`is_order_without_tp` AS `t2_c28`, `supplier`.`order_email` AS
`t2_c29`, `supplier`.`margin_type_id` AS `t2_c30`, `supplier`.`is_checkall`
AS `t2_c31`, `supplier`.`margin_id` AS `t2_c32`, `supplier`.`grid_id` AS
`t2_c33`, `supplier`.`quantity_min_restriction` AS `t2_c34`,
`supplier`.`encrypt_name` AS `t2_c35`,
`supplier`.`additional_adjective_field` AS `t2_c36`,
`supplier`.`additional_adjective_value` AS `t2_c37`,
`supplier`.`additional_adjective_price_field` AS `t2_c38`,
`supplier`.`auto_update` AS `t2_c39`, `supplier`.`is_price_rr_use` AS
`t2_c40`, `supplier`.`is_price_rr_less_deny` AS `t2_c41`,
`supplier`.`is_price_rr_greater_deny` AS `t2_c42`,
`supplier`.`is_manual_price` AS `t2_c43`, `supplier`.`margin_type` AS
`t2_c44`, `supplier`.`is_factory` AS `t2_c45`, `supplier`.`owner_id` AS
`t2_c46`, `supplier`.`response_time` AS `t2_c47`,
`supplier`.`days_to_return` AS `t2_c48`, `supplier`.`is_not_update` AS
`t2_c49`, `supplier`.`unique_delivery` AS `t2_c50`,
`supplier`.`is_fast_update` AS `t2_c51`, `supplier`.`update_version` AS
`t2_c52` FROM `tbl_allprices` `t` INNER JOIN autoopt.mp_goods2offers os ON
os.type = "art_brand" AND os.param1 = t.art_search AND os.param2 =
t.brand_id LEFT OUTER JOIN `tbl_sup_to_ter` `suptoter` ON
(`suptoter`.`sup_id`=`t`.`sup_id`)  LEFT OUTER JOIN `tbl_supplier`
`supplier` ON (`t`.`sup_id`=`supplier`.`id`) WHERE (((((t.is_im_visible =
1) AND (suptoter.ter_id = 66)) AND (os.good_id IN (:ycp30, :ycp31))) AND
(t.date_added > :date_added)) AND (t.quantity > 0)) ORDER BY
IF(suptoter.delivery_ext <= 10, 0, 1) ASC, t.price_purchase ASC, t.id ASC

TPMrp.findAll()

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

Querying SQL: SELECT * FROM `tbl_mrp` `t` WHERE (status IN (:ycp32,
:ycp33)) AND ((t.art_search IN (:ycp34, :ycp35)) AND ((t.art_search,
t.brand_id) IN (("2030503", 17773),("2022503", 17773))))

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

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)

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)

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: 1394; time: 0.086

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('223192317,223320681,225218541,226630399,226708834,226708852,228650422,229227915,232292505,233374029,4282753,4172059,7389429,4153320,4173227,169058594,202255477,50473231,150024959,20500495,50350489,169059446,206350515,209119011,211073308,207193741,57267677,121839623',
'1', '(cm.`name` LIKE "%20 3%")')

begin:system.db.CDbCommand.query(call
get_applied_by_catalog_ids_query('223192317,223320681,225218541,226630399,226708834,226708852,228650422,229227915,232292505,233374029,4282753,4172059,7389429,4153320,4173227,169058594,202255477,50473231,150024959,20500495,50350489,169059446,206350515,209119011,211073308,207193741,57267677,121839623',
'1', '(cm.`name` LIKE "%20 3%")'))

end:system.db.CDbCommand.query(call
get_applied_by_catalog_ids_query('223192317,223320681,225218541,226630399,226708834,226708852,228650422,229227915,232292505,233374029,4282753,4172059,7389429,4153320,4173227,169058594,202255477,50473231,150024959,20500495,50350489,169059446,206350515,209119011,211073308,207193741,57267677,121839623',
'1', '(cm.`name` LIKE "%20 3%")'))

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('203', 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
("404884","087305","170499","238873","231784","270306","540851","399311","861081","705578","077127","616776","770987","142397","623457","890975","382064","799549","870330","976688","479321","891240","293972","329546","180960","307109","496327","841970"))

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
("404884","087305","170499","238873","231784","270306","540851","399311","861081","705578","077127","616776","770987","142397","623457","890975","382064","799549","870330","976688","479321","891240","293972","329546","180960","307109","496327","841970")))

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
("404884","087305","170499","238873","231784","270306","540851","399311","861081","705578","077127","616776","770987","142397","623457","890975","382064","799549","870330","976688","479321","891240","293972","329546","180960","307109","496327","841970")))

Loading "warehouse" application component

Serving "IWarehouse1" from cache

Loading "goodTpl" application component

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)

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)

Loading "image" application component

TPMarginType.findByPk()

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

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

Querying SQL: SELECT `t`.`id` AS `t0_c0`, `t`.`name` AS `t0_c1`,
`t`.`margin_min` AS `t0_c2`, `t`.`round` AS `t0_c3`,
`t`.`ter_retail_price_type` AS `t0_c4`, `margin`.`id` AS `t1_c0`,
`margin`.`price_min` AS `t1_c1`, `margin`.`price_max` AS `t1_c2`,
`margin`.`margin` AS `t1_c3`, `margin`.`round` AS `t1_c4`, `margin`.`type`
AS `t1_c5`, `margin`.`grid_id` AS `t1_c6`,
`margin`.`perc_price_les_show_other_suppliers` AS `t1_c7` FROM
`tbl_standart_margin_type` `t`  LEFT OUTER JOIN `tbl_standart_margin`
`margin` ON (`margin`.`type`=`t`.`id`) WHERE (`t`.`id`=6)

lazy loading TPSupToTer.territory

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

Querying SQL: SELECT `territory`.`id` AS `t1_c0`, `territory`.`name` AS
`t1_c1`, `territory`.`code` AS `t1_c2`, `territory`.`phone` AS `t1_c3`,
`territory`.`params` AS `t1_c4`, `territory`.`margin_type` AS `t1_c5`,
`territory`.`type` AS `t1_c6`, `territory`.`default_department_id` AS
`t1_c7`, `territory`.`default_legal_id` AS `t1_c8`,
`territory`.`is_lf_price_round` AS `t1_c9`, `territory`.`is_im` AS
`t1_c10`, `territory`.`prepay_default` AS `t1_c11`,
`territory`.`is_price_mr_use` AS `t1_c12`,
`territory`.`is_price_erp_less_deny` AS `t1_c13`, `territory`.`web_code` AS
`t1_c14`, `territory`.`margin_type_priority` AS `t1_c15` FROM
`tbl_territory` `territory`  WHERE (`territory`.`id`=:ypl0)

TPMrp.find()

Querying SQL: SELECT * FROM `tbl_mrp` `t` WHERE (status IN (:ycp36,
:ycp37)) AND (art_search=:art_search AND brand_id=:brand_id) LIMIT 1

TPMrp.find()

Querying SQL: SELECT * FROM `tbl_mrp` `t` WHERE (status IN (:ycp38,
:ycp39)) AND (art_search=:art_search AND brand_id=:brand_id) LIMIT 1

TPMrp.find()

Querying SQL: SELECT * FROM `tbl_mrp` `t` WHERE (status IN (:ycp40,
:ycp41)) AND (art_search=:art_search AND brand_id=:brand_id) LIMIT 1

TPMrp.find()

Querying SQL: SELECT * FROM `tbl_mrp` `t` WHERE (status IN (:ycp42,
:ycp43)) AND (art_search=:art_search AND brand_id=:brand_id) LIMIT 1

TPMrp.find()

Querying SQL: SELECT * FROM `tbl_mrp` `t` WHERE (status IN (:ycp44,
:ycp45)) AND (art_search=:art_search AND brand_id=:brand_id) LIMIT 1

TPMrp.find()

Querying SQL: SELECT * FROM `tbl_mrp` `t` WHERE (status IN (:ycp46,
:ycp47)) AND (art_search=:art_search AND brand_id=:brand_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)

CartUser.insert()

Executing SQL: INSERT INTO `b_sale_fuser` (`DATE_INSERT`, `DATE_UPDATE`)
VALUES (:yp0, :yp1)

begin:system.db.CDbCommand.execute(INSERT INTO `b_sale_fuser`
(`DATE_INSERT`, `DATE_UPDATE`) VALUES (:yp0, :yp1))

end:system.db.CDbCommand.execute(INSERT INTO `b_sale_fuser` (`DATE_INSERT`,
`DATE_UPDATE`) VALUES (:yp0, :yp1))

Bookmark.findAll()

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

Querying SQL: SELECT * FROM `b_sale_basket` `t` WHERE (t.LID = :CART_LID
and DELAY = "Y") AND (FUSER_ID=:FUSER_ID)

begin:system.db.CDbCommand.query(SELECT * FROM `b_sale_basket` `t` WHERE
(t.LID = :CART_LID and DELAY = "Y") AND (FUSER_ID=:FUSER_ID))

end:system.db.CDbCommand.query(SELECT * FROM `b_sale_basket` `t` WHERE
(t.LID = :CART_LID and DELAY = "Y") AND (FUSER_ID=:FUSER_ID))

TPMrp.find()

Querying SQL: SELECT * FROM `tbl_mrp` `t` WHERE (status IN (:ycp48,
:ycp49)) AND (art_search=:art_search AND brand_id=:brand_id) LIMIT 1

TPMrp.find()

Querying SQL: SELECT * FROM `tbl_mrp` `t` WHERE (status IN (:ycp50,
:ycp51)) AND (art_search=:art_search AND brand_id=:brand_id) LIMIT 1

TPMrp.find()

Querying SQL: SELECT * FROM `tbl_mrp` `t` WHERE (status IN (:ycp52,
:ycp53)) AND (art_search=:art_search AND brand_id=:brand_id) LIMIT 1

TPMrp.find()

Querying SQL: SELECT * FROM `tbl_mrp` `t` WHERE (status IN (:ycp54,
:ycp55)) AND (art_search=:art_search AND brand_id=:brand_id) LIMIT 1

TPMrp.find()

Querying SQL: SELECT * FROM `tbl_mrp` `t` WHERE (status IN (:ycp56,
:ycp57)) AND (art_search=:art_search AND brand_id=:brand_id) LIMIT 1

TPMrp.find()

Querying SQL: SELECT * FROM `tbl_mrp` `t` WHERE (status IN (:ycp58,
:ycp59)) AND (art_search=:art_search AND brand_id=:brand_id) LIMIT 1

Loading "coreMessages" application component

Loading "GoodPropDesc" application component

Serving "iblock_properties_desc" from cache

Serving
"iblock_properties_0getPropIssetValuesByCodes1Good5c134132c0080d54b0f1f4d11178ba1d"
from cache

Serving
"MpAttrsHelpergetAttrIssetValuesByCodesd41d8cd98f00b204e9800998ecf8427e665c134132c0080d54b0f1f4d11178ba1d"
from cache

Serving
"MpAttrsHelpergetAttrIssetForOurGoodsValuesByCodesd41d8cd98f00b204e9800998ecf8427e665c134132c0080d54b0f1f4d11178ba1d"
from cache

Serving
"iblock_properties_0getPropIssetValuesByCoded41d8cd98f00b204e9800998ecf8427eGoodPROPERTY_MAKER_LISTb5637e45882604048ae26506158a44b5dcca48101505dd86b703689a604fe3c4"
from cache

Serving
"iblock_properties_0getPropIssetValuesByCoded41d8cd98f00b204e9800998ecf8427eGoodPROPERTY_CATGROUPb5637e45882604048ae26506158a44b5dcca48101505dd86b703689a604fe3c4"
from cache

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:top_header_menu_delivery_desktop" from cache

Serving "CB:name:top_alert_desktop" from cache

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