Экспресс доставка
Возврат 90 дней
Консультируем и принимаем заказы
с 9:00 до 22:00 (MSK)
по бесплатному телефону
с 9:00 до 20:00 (MSK) в
Max и Telegram
По запросу «20-4» найдено 8868 товаров
Сортировать по:
Перейти к странице:

Уточните бренд, чтобы увидеть больше результатов


Производитель Артикул Описание
MERCEDES 204 Показать аналоги
BOSCH 204 Показать аналоги
FORD 204 Показать аналоги
RENAULT 204 Показать аналоги
BMW 204 Показать аналоги
SACHS 204 Колодки тормозные Показать аналоги
GENERAL MOTORS 204 Показать аналоги
MAHLE 204 Показать аналоги
FISPA 204 Фильтр салонный Показать аналоги
LEMA 204 Шкворень Показать аналоги
MECAFILTER 204 Фильтр воздушный Показать аналоги
CHRYSLER 204 Показать аналоги
GOODWILL 204 Показать аналоги
VAG 204 Показать аналоги
HELLA 204 Показать аналоги
NGK 204 Свеча зажигания Показать аналоги
Наличие товара на складах и в магазинах, а также цена товара указана на 18.08.2026 14:30.
Цены и наличие товара во всех магазинах и складах обновляются 1 раз в час. При достаточном количестве товара в нужном вам магазине вы можете купить его без предзаказа.
Интернет-цена - действительна при заказе на сайте или через оператора call-центра по телефону 8 800 6006 966. При условии достаточного количества товара в момент заказа.
Цена в магазинах - розничная цена товара в торговых залах магазинов без предварительного заказа.
Представленные данные о запчастях на этой странице несут исключительно информационный характер.

Уточните категорию

Общий отчет (Время: 0.83140с, Память: 21,603Кб)
Процедура Номер Всего (с) Средн. (с) Мин. (с) Макс. (с)
Sphinx select id,@groupby,@distinct,@count,property_msection_id 1 0.57093 0.57093 0.57093 0.57093
Sphinx search. total_found: 8868; time: 0.075 1 0.64702 0.64702 0.64702 0.64702
Sphinx search. total_found: 1392; time: 0.087 1 0.42749 0.42749 0.42749 0.42749
Sphinx index catalog,catalog_morph,marketplace 2 1.29855 0.64927 0.57093 0.72762
system.db.CDbCommand.query(SELECT * FROM `b_sale_fuser` `t` WHERE USER_ID=:USER_ID LIMIT 1) 5 0.00107 0.00021 0.00018 0.00028
system.db.CDbCommand.query(SELECT * FROM `mp_goods` `t` WHERE 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, :ycp28, :ycp29)) 1 0.00095 0.00095 0.00095 0.00095
loading session 2 0.00083 0.00042 0.00000 0.00083
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `mp_goods`) 1 0.00076 0.00076 0.00076 0.00076
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) 2 0.00065 0.00032 0.00027 0.00038
system.db.CDbCommand.query(SELECT COUNT(*) FROM `b_sale_basket` `t` WHERE FUSER_ID=:FUSER_ID AND ORDER_ID IS NULL AND DELAY = :DELAY) 2 0.00038 0.00019 0.00019 0.00019
system.db.CDbCommand.query(SHOW CREATE TABLE `mp_goods`) 1 0.00037 0.00037 0.00037 0.00037
system.db.CDbCommand.query(SELECT `NAME`, `CODE` FROM `b_iblock_element` `t` LEFT JOIN `b_iblock_element_property` `mp` ON mp.IBLOCK_ELEMENT_ID = t.ID WHERE IBLOCK_ID =:block_id AND IBLOCK_PROPERTY_ID =:prop_id AND VALUE =:value AND (t.NAME LIKE :word0)) 1 0.00032 0.00032 0.00032 0.00032
system.db.CDbCommand.execute(DELETE FROM `YiiLog` WHERE 0=1) 1 0.00029 0.00029 0.00029 0.00029
system.db.CDbCommand.execute(SET SESSION TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;) 1 0.00024 0.00024 0.00024 0.00024
system.db.CDbCommand.query(SELECT * FROM `sp_delivery_calc_main` `t` WHERE t.location_id = :location_id LIMIT 1) 1 0.00019 0.00019 0.00019 0.00019
Журнал приложения
Время Уровень Категория Сообщение
15:48:46.308286 trace system.CModule
Loading "log" application component
15:48:46.311810 trace glitchtip_fallback
The "Sentry\Integration\RequestIntegration,
Sentry\Integration\TransactionIntegration,
Sentry\Integration\FrameContextifierIntegration,
Sentry\Integration\EnvironmentIntegration" integration(s) have been
installed.
15:48:46.312069 trace system.CModule
Loading "db" application component
15:48:46.312144 trace system.db.CDbConnection
Opening DB connection
15:48:46.313136 trace system.db.CDbCommand
Executing SQL: DELETE FROM `YiiLog` WHERE 0=1
15:48:46.313142 profile system.db.CDbCommand.execute
begin:system.db.CDbCommand.execute(DELETE FROM `YiiLog` WHERE 0=1)
15:48:46.313431 profile system.db.CDbCommand.execute
end:system.db.CDbCommand.execute(DELETE FROM `YiiLog` WHERE 0=1)
15:48:46.313621 trace system.CModule
Loading "urlHelper" application component
15:48:46.313749 trace system.CModule
Loading "DBConfig" application component
15:48:46.313787 trace system.CModule
Loading "cache" application component
15:48:46.314636 trace system.caching.CMemCache
Serving "66307959e0460a2e2436b0319b2fda14" from cache
15:48:46.315052 trace system.CModule
Loading "geo" application component
15:48:46.315128 trace system.CModule
Loading "request" application component
15:48:46.315444 trace system.CModule
Loading "user" application component
15:48:46.315598 profile application
begin:loading session
15:48:46.315603 trace system.CModule
Loading "session" application component
15:48:46.316428 profile application
end:loading session
15:48:46.316948 trace system.CModule
Loading "B2BConfig" application component
15:48:46.317037 trace system.CModule
Loading "urlManager" application component
15:48:46.318388 trace system.caching.CMemCache
Serving "Yii.CUrlManager.rules" from cache
15:48:46.319452 trace system.CModule
Loading "themeInterlayer" application component
15:48:46.320439 trace system.CModule
Loading "themeManager" application component
15:48:46.320625 trace system.CModule
Loading "clientScript" application component
15:48:46.323276 trace system.web.filters.CFilterChain
Running filter DBReadUncomitedLevelFilter.filter()
15:48:46.323297 trace system.db.CDbCommand
Executing SQL: SET SESSION TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
15:48:46.323302 profile system.db.CDbCommand.execute
begin:system.db.CDbCommand.execute(SET SESSION TRANSACTION ISOLATION LEVEL
READ UNCOMMITTED;)
15:48:46.323540 profile system.db.CDbCommand.execute
end:system.db.CDbCommand.execute(SET SESSION TRANSACTION ISOLATION LEVEL
READ UNCOMMITTED;)
15:48:46.323585 trace system.CModule
Loading "cart" application component
15:48:46.323721 trace system.db.ar.CActiveRecord
CartUser.find()
15:48:46.324033 trace system.caching.CMemCache
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:b_sale_fuser"
from cache
15:48:46.324080 trace system.db.CDbCommand
Querying SQL: SELECT * FROM `b_sale_fuser` `t` WHERE USER_ID=:USER_ID LIMIT
1
15:48:46.324084 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT * FROM `b_sale_fuser` `t` WHERE
USER_ID=:USER_ID LIMIT 1)
15:48:46.324285 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT * FROM `b_sale_fuser` `t` WHERE
USER_ID=:USER_ID LIMIT 1)
15:48:46.324515 trace system.CModule
Loading "coupon" application component
15:48:46.324714 trace system.CModule
Loading "assetManager" application component
15:48:46.324965 trace system.db.ar.CActiveRecord
DeliveryCalcMain.find()
15:48:46.325145 trace system.caching.CMemCache
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:sp_delivery_calc_main"
from cache
15:48:46.325196 trace system.db.CDbCommand
Querying SQL: SELECT * FROM `sp_delivery_calc_main` `t` WHERE t.location_id
= :location_id LIMIT 1
15:48:46.325200 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT * FROM `sp_delivery_calc_main` `t`
WHERE t.location_id = :location_id LIMIT 1)
15:48:46.325387 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT * FROM `sp_delivery_calc_main` `t`
WHERE t.location_id = :location_id LIMIT 1)
15:48:46.326508 trace system.CModule
Loading "redisCache" application component
15:48:46.327301 trace system.caching.CRedisCache
Serving "sberid_AA\Service\OAuth\Clients\SberIdClient_sberid_authState"
from cache
15:48:46.327794 trace system.caching.CRedisCache
Serving "sberid_AA\Service\OAuth\Clients\SberIdClient_sberid_authState"
from cache
15:48:46.327920 profile application
begin:loading session
15:48:46.327924 profile application
end:loading session
15:48:46.329742 trace system.CModule
Loading "order" application component
15:48:46.332839 trace system.CModule
Loading "IPropeties" application component
15:48:46.336205 trace system.caching.CMemCache
Serving "iblock_properties_0" from cache
15:48:46.336735 trace system.caching.CMemCache
Serving "iblock_properties_0getPropValues1408" from cache
15:48:46.337197 trace system.caching.CMemCache
Serving "IWarehouseIWarehouse::getStaticList" from cache
15:48:46.337315 trace system.db.ar.CActiveRecord
TPSupToTer.findAll()
15:48:46.337321 trace system.CModule
Loading "dbTP" application component
15:48:46.337338 trace system.db.CDbConnection
Opening DB connection
15:48:46.338522 trace system.caching.CMemCache
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=tp:alliance-auto:{{sup_to_ter}}"
from cache
15:48:46.338759 trace system.caching.CMemCache
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=tp:alliance-auto:{{supplier_delivery_settings}}"
from cache
15:48:46.338937 trace system.db.CDbCommand
Querying SQL: SELECT `t`.`id` AS `t0_c0`, `t`.`ter_id` AS `t0_c1`,
`t`.`sup_id` AS `t0_c2`, `t`.`margin` AS `t0_c3`, `t`.`delivery_ext` AS
`t0_c4`, `t`.`price_min` AS `t0_c5`, `t`.`type` AS `t0_c6`,
`t`.`is_price_purchase_edit` AS `t0_c7`, `t`.`is_price_retail_edit` AS
`t0_c8`, `t`.`use_standart_margin` AS `t0_c9`, `t`.`purchase_price_field`
AS `t0_c10`, `t`.`rating` AS `t0_c11`, `t`.`for_retail` AS `t0_c12`,
`t`.`for_purchase` AS `t0_c13`, `t`.`is_native` AS `t0_c14`,
`t`.`delivery_end_time` AS `t0_c15`, `t`.`delivery_get_orders` AS `t0_c16`,
`t`.`delivery_shipment_orders` AS `t0_c17`, `t`.`is_modified` AS `t0_c18`,
`t`.`is_zzap` AS `t0_c19`, `t`.`email` AS `t0_c20`, `t`.`theme` AS
`t0_c21`, `t`.`message` AS `t0_c22`, `t`.`params` AS `t0_c23`,
`t`.`is_price_rr_use` AS `t0_c24`, `t`.`is_price_erp_less_deny` AS
`t0_c25`, `t`.`parish_territory` AS `t0_c26`, `delivery`.`id` AS `t1_c0`,
`delivery`.`supplier_id` AS `t1_c1`, `delivery`.`territory_id` AS `t1_c2`,
`delivery`.`week_day` AS `t1_c3`, `delivery`.`time_start` AS `t1_c4`,
`delivery`.`time_end` AS `t1_c5`, `delivery`.`add_days` AS `t1_c6`,
`delivery`.`work_days` AS `t1_c7`, `delivery`.`comment` AS `t1_c8`,
`delivery`.`time_finish` AS `t1_c9` FROM `tbl_sup_to_ter` `t`  LEFT OUTER
JOIN `tbl_supplier_delivery_settings` `delivery` ON
(`delivery`.`supplier_id`=`t`.`sup_id`) AND
(`delivery`.`territory_id`=`t`.`ter_id`) WHERE (t.ter_id=:ter_id)
15:48:46.368601 trace system.CModule
Loading "ICatalog" application component
15:48:46.368841 trace system.caching.CMemCache
Serving "b_catalog_group1" from cache
15:48:46.369966 trace system.caching.CMemCache
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:b_iblock_element"
from cache
15:48:46.370913 trace system.db.ar.CActiveRecord
TPSupToTer.findAll()
15:48:46.371186 trace system.db.CDbCommand
Querying SQL: SELECT `t`.`id` AS `t0_c0`, `t`.`ter_id` AS `t0_c1`,
`t`.`sup_id` AS `t0_c2`, `t`.`margin` AS `t0_c3`, `t`.`delivery_ext` AS
`t0_c4`, `t`.`price_min` AS `t0_c5`, `t`.`type` AS `t0_c6`,
`t`.`is_price_purchase_edit` AS `t0_c7`, `t`.`is_price_retail_edit` AS
`t0_c8`, `t`.`use_standart_margin` AS `t0_c9`, `t`.`purchase_price_field`
AS `t0_c10`, `t`.`rating` AS `t0_c11`, `t`.`for_retail` AS `t0_c12`,
`t`.`for_purchase` AS `t0_c13`, `t`.`is_native` AS `t0_c14`,
`t`.`delivery_end_time` AS `t0_c15`, `t`.`delivery_get_orders` AS `t0_c16`,
`t`.`delivery_shipment_orders` AS `t0_c17`, `t`.`is_modified` AS `t0_c18`,
`t`.`is_zzap` AS `t0_c19`, `t`.`email` AS `t0_c20`, `t`.`theme` AS
`t0_c21`, `t`.`message` AS `t0_c22`, `t`.`params` AS `t0_c23`,
`t`.`is_price_rr_use` AS `t0_c24`, `t`.`is_price_erp_less_deny` AS
`t0_c25`, `t`.`parish_territory` AS `t0_c26`, `delivery`.`id` AS `t1_c0`,
`delivery`.`supplier_id` AS `t1_c1`, `delivery`.`territory_id` AS `t1_c2`,
`delivery`.`week_day` AS `t1_c3`, `delivery`.`time_start` AS `t1_c4`,
`delivery`.`time_end` AS `t1_c5`, `delivery`.`add_days` AS `t1_c6`,
`delivery`.`work_days` AS `t1_c7`, `delivery`.`comment` AS `t1_c8`,
`delivery`.`time_finish` AS `t1_c9` FROM `tbl_sup_to_ter` `t`  LEFT OUTER
JOIN `tbl_supplier_delivery_settings` `delivery` ON
(`delivery`.`supplier_id`=`t`.`sup_id`) AND
(`delivery`.`territory_id`=`t`.`ter_id`) WHERE (t.ter_id=:ter_id)
15:48:46.406421 trace system.db.CDbCommand
Querying SQL: SELECT `NAME`, `CODE`
FROM `b_iblock_element` `t`
LEFT JOIN `b_iblock_element_property` `mp` ON mp.IBLOCK_ELEMENT_ID = t.ID
WHERE IBLOCK_ID =:block_id AND IBLOCK_PROPERTY_ID =:prop_id AND VALUE
=:value AND (t.NAME LIKE :word0)
15:48:46.406430 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT `NAME`, `CODE`
FROM `b_iblock_element` `t`
LEFT JOIN `b_iblock_element_property` `mp` ON mp.IBLOCK_ELEMENT_ID = t.ID
WHERE IBLOCK_ID =:block_id AND IBLOCK_PROPERTY_ID =:prop_id AND VALUE
=:value AND (t.NAME LIKE :word0))
15:48:46.406754 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT `NAME`, `CODE`
FROM `b_iblock_element` `t`
LEFT JOIN `b_iblock_element_property` `mp` ON mp.IBLOCK_ELEMENT_ID = t.ID
WHERE IBLOCK_ID =:block_id AND IBLOCK_PROPERTY_ID =:prop_id AND VALUE
=:value AND (t.NAME LIKE :word0))
15:48:46.406949 trace system.db.CDbCommand
Querying SQL: SELECT `t`.`NAME` AS `pattern`, `t`.`CODE` AS `replace`
FROM `b_iblock_element` `t`
LEFT JOIN `b_iblock_element_property` `mp` ON mp.IBLOCK_ELEMENT_ID = t.ID
WHERE IBLOCK_ID = :block_id AND IBLOCK_PROPERTY_ID = :prop_id AND VALUE =
:value
15:48:46.406953 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT `t`.`NAME` AS `pattern`, `t`.`CODE`
AS `replace`
FROM `b_iblock_element` `t`
LEFT JOIN `b_iblock_element_property` `mp` ON mp.IBLOCK_ELEMENT_ID = t.ID
WHERE IBLOCK_ID = :block_id AND IBLOCK_PROPERTY_ID = :prop_id AND VALUE =
:value)
15:48:46.407334 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT `t`.`NAME` AS `pattern`, `t`.`CODE`
AS `replace`
FROM `b_iblock_element` `t`
LEFT JOIN `b_iblock_element_property` `mp` ON mp.IBLOCK_ELEMENT_ID = t.ID
WHERE IBLOCK_ID = :block_id AND IBLOCK_PROPERTY_ID = :prop_id AND VALUE =
:value)
15:48:46.407675 profile application
begin:Sphinx index catalog,catalog_morph,marketplace
15:48:46.488281 profile application
begin:Sphinx search. total_found: 8868; time: 0.075
15:48:46.488611 trace system.db.CDbCommand
Querying SQL: SHOW FULL COLUMNS FROM `mp_goods`
15:48:46.488615 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `mp_goods`)
15:48:46.489379 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `mp_goods`)
15:48:46.489624 trace system.db.CDbCommand
Querying SQL: SHOW CREATE TABLE `mp_goods`
15:48:46.489628 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SHOW CREATE TABLE `mp_goods`)
15:48:46.489996 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SHOW CREATE TABLE `mp_goods`)
15:48:46.490061 trace system.caching.CMemCache
Saving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:mp_goods"
to cache
15:48:46.490356 trace system.db.ar.CActiveRecord
MpGood.findAll()
15:48:46.490447 trace system.db.CDbCommand
Querying SQL: SELECT * FROM `mp_goods` `t` WHERE 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, :ycp28, :ycp29)
15:48:46.490449 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT * FROM `mp_goods` `t` WHERE 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,
:ycp28, :ycp29))
15:48:46.491401 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT * FROM `mp_goods` `t` WHERE 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,
:ycp28, :ycp29))
15:48:46.492224 trace system.db.ar.CActiveRecord
TPSupToTer.findAll()
15:48:46.492451 trace system.db.CDbCommand
Querying SQL: SELECT `t`.`id` AS `t0_c0`, `t`.`ter_id` AS `t0_c1`,
`t`.`sup_id` AS `t0_c2`, `t`.`margin` AS `t0_c3`, `t`.`delivery_ext` AS
`t0_c4`, `t`.`price_min` AS `t0_c5`, `t`.`type` AS `t0_c6`,
`t`.`is_price_purchase_edit` AS `t0_c7`, `t`.`is_price_retail_edit` AS
`t0_c8`, `t`.`use_standart_margin` AS `t0_c9`, `t`.`purchase_price_field`
AS `t0_c10`, `t`.`rating` AS `t0_c11`, `t`.`for_retail` AS `t0_c12`,
`t`.`for_purchase` AS `t0_c13`, `t`.`is_native` AS `t0_c14`,
`t`.`delivery_end_time` AS `t0_c15`, `t`.`delivery_get_orders` AS `t0_c16`,
`t`.`delivery_shipment_orders` AS `t0_c17`, `t`.`is_modified` AS `t0_c18`,
`t`.`is_zzap` AS `t0_c19`, `t`.`email` AS `t0_c20`, `t`.`theme` AS
`t0_c21`, `t`.`message` AS `t0_c22`, `t`.`params` AS `t0_c23`,
`t`.`is_price_rr_use` AS `t0_c24`, `t`.`is_price_erp_less_deny` AS
`t0_c25`, `t`.`parish_territory` AS `t0_c26`, `delivery`.`id` AS `t1_c0`,
`delivery`.`supplier_id` AS `t1_c1`, `delivery`.`territory_id` AS `t1_c2`,
`delivery`.`week_day` AS `t1_c3`, `delivery`.`time_start` AS `t1_c4`,
`delivery`.`time_end` AS `t1_c5`, `delivery`.`add_days` AS `t1_c6`,
`delivery`.`work_days` AS `t1_c7`, `delivery`.`comment` AS `t1_c8`,
`delivery`.`time_finish` AS `t1_c9` FROM `tbl_sup_to_ter` `t`  LEFT OUTER
JOIN `tbl_supplier_delivery_settings` `delivery` ON
(`delivery`.`supplier_id`=`t`.`sup_id`) AND
(`delivery`.`territory_id`=`t`.`ter_id`) WHERE (t.ter_id=:ter_id)
15:48:46.525856 trace system.db.CDbCommand
Querying SQL: SHOW FULL COLUMNS FROM `tbl_allprices`
15:48:46.526854 trace system.db.CDbCommand
Querying SQL: SHOW CREATE TABLE `tbl_allprices`
15:48:46.527147 trace system.caching.CMemCache
Saving
"yii:dbschemamysql:host=192.168.0.1;dbname=tp:alliance-auto:{{allprices}}"
to cache
15:48:46.527508 trace system.db.ar.CActiveRecord
TPAllPrices.findAll()
15:48:46.527997 trace system.db.CDbCommand
Querying SQL: SHOW FULL COLUMNS FROM `tbl_supplier`
15:48:46.529313 trace system.db.CDbCommand
Querying SQL: SHOW CREATE TABLE `tbl_supplier`
15:48:46.529660 trace system.caching.CMemCache
Saving
"yii:dbschemamysql:host=192.168.0.1;dbname=tp:alliance-auto:{{supplier}}"
to cache
15:48:46.530311 trace system.db.CDbCommand
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, :ycp32,
:ycp33, :ycp34, :ycp35, :ycp36, :ycp37, :ycp38, :ycp39, :ycp40, :ycp41,
:ycp42, :ycp43, :ycp44, :ycp45, :ycp46, :ycp47, :ycp48, :ycp49, :ycp50,
:ycp51, :ycp52, :ycp53, :ycp54, :ycp55, :ycp56, :ycp57, :ycp58, :ycp59)))
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
15:48:46.532934 trace system.db.CDbCommand
Querying SQL: SELECT `t`.`NAME` AS `pattern`, `t`.`CODE` AS `replace`
FROM `b_iblock_element` `t`
LEFT JOIN `b_iblock_element_property` `mp` ON mp.IBLOCK_ELEMENT_ID = t.ID
WHERE IBLOCK_ID = :block_id AND IBLOCK_PROPERTY_ID = :prop_id AND VALUE =
:value
15:48:46.532939 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT `t`.`NAME` AS `pattern`, `t`.`CODE`
AS `replace`
FROM `b_iblock_element` `t`
LEFT JOIN `b_iblock_element_property` `mp` ON mp.IBLOCK_ELEMENT_ID = t.ID
WHERE IBLOCK_ID = :block_id AND IBLOCK_PROPERTY_ID = :prop_id AND VALUE =
:value)
15:48:46.533205 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT `t`.`NAME` AS `pattern`, `t`.`CODE`
AS `replace`
FROM `b_iblock_element` `t`
LEFT JOIN `b_iblock_element_property` `mp` ON mp.IBLOCK_ELEMENT_ID = t.ID
WHERE IBLOCK_ID = :block_id AND IBLOCK_PROPERTY_ID = :prop_id AND VALUE =
:value)
15:48:46.533356 trace system.db.ar.CActiveRecord
TPSupToTer.findAll()
15:48:46.533555 trace system.db.CDbCommand
Querying SQL: SELECT `t`.`id` AS `t0_c0`, `t`.`ter_id` AS `t0_c1`,
`t`.`sup_id` AS `t0_c2`, `t`.`margin` AS `t0_c3`, `t`.`delivery_ext` AS
`t0_c4`, `t`.`price_min` AS `t0_c5`, `t`.`type` AS `t0_c6`,
`t`.`is_price_purchase_edit` AS `t0_c7`, `t`.`is_price_retail_edit` AS
`t0_c8`, `t`.`use_standart_margin` AS `t0_c9`, `t`.`purchase_price_field`
AS `t0_c10`, `t`.`rating` AS `t0_c11`, `t`.`for_retail` AS `t0_c12`,
`t`.`for_purchase` AS `t0_c13`, `t`.`is_native` AS `t0_c14`,
`t`.`delivery_end_time` AS `t0_c15`, `t`.`delivery_get_orders` AS `t0_c16`,
`t`.`delivery_shipment_orders` AS `t0_c17`, `t`.`is_modified` AS `t0_c18`,
`t`.`is_zzap` AS `t0_c19`, `t`.`email` AS `t0_c20`, `t`.`theme` AS
`t0_c21`, `t`.`message` AS `t0_c22`, `t`.`params` AS `t0_c23`,
`t`.`is_price_rr_use` AS `t0_c24`, `t`.`is_price_erp_less_deny` AS
`t0_c25`, `t`.`parish_territory` AS `t0_c26`, `delivery`.`id` AS `t1_c0`,
`delivery`.`supplier_id` AS `t1_c1`, `delivery`.`territory_id` AS `t1_c2`,
`delivery`.`week_day` AS `t1_c3`, `delivery`.`time_start` AS `t1_c4`,
`delivery`.`time_end` AS `t1_c5`, `delivery`.`add_days` AS `t1_c6`,
`delivery`.`work_days` AS `t1_c7`, `delivery`.`comment` AS `t1_c8`,
`delivery`.`time_finish` AS `t1_c9` FROM `tbl_sup_to_ter` `t`  LEFT OUTER
JOIN `tbl_supplier_delivery_settings` `delivery` ON
(`delivery`.`supplier_id`=`t`.`sup_id`) AND
(`delivery`.`territory_id`=`t`.`ter_id`) WHERE (t.ter_id=:ter_id)
15:48:46.564364 profile application
begin:Sphinx select id,@groupby,@distinct,@count,property_msection_id
15:48:46.564373 profile application
begin:Sphinx index catalog,catalog_morph,marketplace
15:48:46.707808 profile application
begin:Sphinx search. total_found: 1392; time: 0.087
15:48:46.708419 trace system.CModule
Loading "GoodSections" application component
15:48:46.708527 trace system.CModule
Loading "fcache" application component
15:48:46.720890 trace system.caching.CFileCache
Serving "good_sections_tree5" from cache
15:48:46.721355 trace system.caching.CMemCache
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:b_iblock_section"
from cache
15:48:46.728140 trace system.CModule
Loading "dbTecDoc" application component
15:48:46.728167 trace system.db.CDbConnection
Opening DB connection
15:48:46.729106 trace system.db.CDbCommand
Querying SQL: SELECT
    		  DISTINCT ab.level_id, ab.name, lan.description,
ab.is_russian_manufacturer
    	FROM
    		tp.tbl_analogs lan
    		INNER JOIN tp.tbl_allbrands ab ON (ab.id = lan.brand_id)
    	WHERE
    		lan.art_search = :art
15:48:46.729598 trace system.CModule
Loading "dbTecDoc2" application component
15:48:46.729618 trace system.db.CDbConnection
Opening DB connection
15:48:46.730493 trace system.db.CDbCommand
Querying SQL: call get_brandfilter_by_art_no_link_v7_1('204', 49, 66, 1,
66)
15:48:46.922759 trace system.CModule
Loading "goodTpl" application component
15:48:46.923778 trace system.CModule
Loading "microdataManager" application component
15:48:46.924551 trace system.CModule
Loading "widgetFactory" application component
15:48:46.938004 trace system.CModule
Loading "yandexEcom" application component
15:48:46.952888 trace system.CModule
Loading "coreMessages" application component
15:48:47.070467 trace system.CModule
Loading "GoodPropDesc" application component
15:48:47.070770 trace system.caching.CFileCache
Serving "iblock_properties_desc" from cache
15:48:47.071768 trace system.caching.CMemCache
Serving
"iblock_properties_0getPropIssetValuesByCodes1Goodaf69e938ad2b85713393339417f9edb9"
from cache
15:48:47.072101 trace system.caching.CMemCache
Serving
"MpAttrsHelpergetAttrIssetValuesByCodesd41d8cd98f00b204e9800998ecf8427e66af69e938ad2b85713393339417f9edb9"
from cache
15:48:47.072249 trace system.caching.CMemCache
Serving
"MpAttrsHelpergetAttrIssetForOurGoodsValuesByCodesd41d8cd98f00b204e9800998ecf8427e66af69e938ad2b85713393339417f9edb9"
from cache
15:48:47.077080 trace system.caching.CMemCache
Serving
"iblock_properties_0getPropIssetValuesByCoded41d8cd98f00b204e9800998ecf8427eGoodPROPERTY_MAKER_LISTe71c3cff221dbf201e3205d1ae09bc17dcca48101505dd86b703689a604fe3c4"
from cache
15:48:47.078794 trace system.caching.CMemCache
Serving
"iblock_properties_0getPropIssetValuesByCoded41d8cd98f00b204e9800998ecf8427eGoodPROPERTY_CATGROUPe71c3cff221dbf201e3205d1ae09bc17dcca48101505dd86b703689a604fe3c4"
from cache
15:48:47.085041 trace system.caching.CRedisCache
Serving "sberid_AA\Service\OAuth\Clients\SberIdClient_sberid_authState"
from cache
15:48:47.085452 trace system.caching.CRedisCache
Serving "sberid_AA\Service\OAuth\Clients\SberIdClient_sberid_authState"
from cache
15:48:47.088186 trace system.db.ar.CActiveRecord
CartUser.find()
15:48:47.088254 trace system.db.CDbCommand
Querying SQL: SELECT * FROM `b_sale_fuser` `t` WHERE USER_ID=:USER_ID LIMIT
1
15:48:47.088258 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT * FROM `b_sale_fuser` `t` WHERE
USER_ID=:USER_ID LIMIT 1)
15:48:47.088535 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT * FROM `b_sale_fuser` `t` WHERE
USER_ID=:USER_ID LIMIT 1)
15:48:47.088665 trace system.db.ar.CActiveRecord
CartUser.find()
15:48:47.088697 trace system.db.CDbCommand
Querying SQL: SELECT * FROM `b_sale_fuser` `t` WHERE USER_ID=:USER_ID LIMIT
1
15:48:47.088700 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT * FROM `b_sale_fuser` `t` WHERE
USER_ID=:USER_ID LIMIT 1)
15:48:47.088876 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT * FROM `b_sale_fuser` `t` WHERE
USER_ID=:USER_ID LIMIT 1)
15:48:47.088884 trace system.db.ar.CActiveRecord
Cart.count()
15:48:47.089086 trace system.caching.CMemCache
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:b_sale_basket"
from cache
15:48:47.089155 trace system.db.CDbCommand
Querying SQL: SELECT COUNT(*) FROM `b_sale_basket` `t` WHERE
FUSER_ID=:FUSER_ID AND ORDER_ID IS NULL AND DELAY = :DELAY
15:48:47.089158 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT COUNT(*) FROM `b_sale_basket` `t`
WHERE FUSER_ID=:FUSER_ID AND ORDER_ID IS NULL AND DELAY = :DELAY)
15:48:47.089349 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT COUNT(*) FROM `b_sale_basket` `t`
WHERE FUSER_ID=:FUSER_ID AND ORDER_ID IS NULL AND DELAY = :DELAY)
15:48:47.091677 trace system.caching.CMemCache
Serving "CB:name:top_header_menu_delivery_desktop" from cache
15:48:47.092777 trace system.caching.CMemCache
Serving "CB:name:top_alert_desktop" from cache
15:48:47.094546 trace system.db.ar.CActiveRecord
CartUser.find()
15:48:47.094582 trace system.db.CDbCommand
Querying SQL: SELECT * FROM `b_sale_fuser` `t` WHERE USER_ID=:USER_ID LIMIT
1
15:48:47.094584 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT * FROM `b_sale_fuser` `t` WHERE
USER_ID=:USER_ID LIMIT 1)
15:48:47.094804 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT * FROM `b_sale_fuser` `t` WHERE
USER_ID=:USER_ID LIMIT 1)
15:48:47.094841 trace system.db.ar.CActiveRecord
CartUser.find()
15:48:47.094872 trace system.db.CDbCommand
Querying SQL: SELECT * FROM `b_sale_fuser` `t` WHERE USER_ID=:USER_ID LIMIT
1
15:48:47.094875 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT * FROM `b_sale_fuser` `t` WHERE
USER_ID=:USER_ID LIMIT 1)
15:48:47.095074 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT * FROM `b_sale_fuser` `t` WHERE
USER_ID=:USER_ID LIMIT 1)
15:48:47.095082 trace system.db.ar.CActiveRecord
Cart.count()
15:48:47.095125 trace system.db.CDbCommand
Querying SQL: SELECT COUNT(*) FROM `b_sale_basket` `t` WHERE
FUSER_ID=:FUSER_ID AND ORDER_ID IS NULL AND DELAY = :DELAY
15:48:47.095128 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT COUNT(*) FROM `b_sale_basket` `t`
WHERE FUSER_ID=:FUSER_ID AND ORDER_ID IS NULL AND DELAY = :DELAY)
15:48:47.095320 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT COUNT(*) FROM `b_sale_basket` `t`
WHERE FUSER_ID=:FUSER_ID AND ORDER_ID IS NULL AND DELAY = :DELAY)
15:48:47.099175 trace system.caching.CMemCache
Serving "CB:name:bottom_job_desktop" from cache
15:48:47.099752 trace system.caching.CMemCache
Serving "CB:name:partners_desktop" from cache
15:48:47.100318 trace system.caching.CMemCache
Serving "CB:name:bottom_for_buyer_desktop" from cache
15:48:47.100837 trace system.CModule
Loading "territory" application component
15:48:47.108908 trace system.caching.CMemCache
Serving "ITerritory3" from cache
15:48:47.111963 trace system.caching.CMemCache
Serving "iblock_properties_0getPropValues1045" from cache
15:48:47.116914 trace system.caching.CMemCache
Serving "CB:name:bottom_copy_text_desktop" from cache