Результаты поиска по запросу 20-4

Поиск детали
Оригинальные каталоги
Подбор по марке
Запросы по VIN

По запросу «20-4» найдено 8868 товаров

Сортировать по:

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

Производитель	Артикул	Описание
MERCEDES	204		Показать аналоги
BOSCH	204		Показать аналоги
FORD	204		Показать аналоги
RENAULT	204		Показать аналоги
BMW	204		Показать аналоги
SACHS	204	Колодки тормозные	Показать аналоги
GENERAL MOTORS	204		Показать аналоги
MAHLE	204		Показать аналоги
LEMA	204	Шкворень	Показать аналоги
FISPA	204	Фильтр салонный	Показать аналоги
MECAFILTER	204	Фильтр воздушный	Показать аналоги
CHRYSLER	204		Показать аналоги
GOODWILL	204		Показать аналоги
VAG	204		Показать аналоги
HELLA	204		Показать аналоги
NGK	204	Свеча зажигания	Показать аналоги
ЯМЗ	204		Показать аналоги

Наличие товара на складах и в магазинах, а также цена товара указана на 18.08.2026 14:30.

Цены и наличие товара во всех магазинах и складах обновляются 1 раз в час. При достаточном количестве товара в нужном вам магазине вы можете купить его без предзаказа.

Интернет-цена - действительна при заказе на сайте или через оператора call-центра по телефону 8 800 6006 966. При условии достаточного количества товара в момент заказа.

Цена в магазинах - розничная цена товара в торговых залах магазинов без предварительного заказа.

Представленные данные о запчастях на этой странице несут исключительно информационный характер.

Общий отчет (Время: 0.90724с, Память: 21,630Кб)
Процедура	Номер	Всего (с)	Средн. (с)	Мин. (с)	Макс. (с)
Sphinx select id,@groupby,@distinct,@count,property_msection_id	1	0.57623	0.57623	0.57623	0.57623
Sphinx search. total_found: 8868; time: 0.124	1	0.65974	0.65974	0.65974	0.65974
Sphinx search. total_found: 1392; time: 0.095	1	0.42285	0.42285	0.42285	0.42285
Sphinx index catalog,catalog_morph,marketplace	2	1.36542	0.68271	0.57622	0.78920
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.00121	0.00121	0.00121	0.00121
system.db.CDbCommand.query(SELECT * FROM `b_sale_fuser` `t` WHERE USER_ID=:USER_ID LIMIT 1)	5	0.00108	0.00022	0.00018	0.00028
loading session	2	0.00084	0.00042	0.00000	0.00083
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.00053	0.00053	0.00053	0.00053
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.00044	0.00022	0.00021	0.00023
system.db.CDbCommand.execute(SET SESSION TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;)	1	0.00036	0.00036	0.00036	0.00036
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.00035	0.00018	0.00017	0.00018
system.db.CDbCommand.execute(DELETE FROM `YiiLog` WHERE 0=1)	1	0.00026	0.00026	0.00026	0.00026
system.db.CDbCommand.query(SELECT * FROM `sp_delivery_calc_main` `t` WHERE t.location_id = :location_id LIMIT 1)	1	0.00022	0.00022	0.00022	0.00022

Журнал приложения
Время	Уровень	Категория	Сообщение
15:01:57.113078	trace	system.CModule	Loading "log" application component
15:01:57.118092	trace	glitchtip_fallback	The "Sentry\Integration\RequestIntegration, Sentry\Integration\TransactionIntegration, Sentry\Integration\FrameContextifierIntegration, Sentry\Integration\EnvironmentIntegration" integration(s) have been installed.
15:01:57.118932	trace	system.CModule	Loading "db" application component
15:01:57.119632	trace	system.db.CDbConnection	Opening DB connection
15:01:57.120759	trace	system.db.CDbCommand	Executing SQL: DELETE FROM `YiiLog` WHERE 0=1
15:01:57.120765	profile	system.db.CDbCommand.execute	begin:system.db.CDbCommand.execute(DELETE FROM `YiiLog` WHERE 0=1)
15:01:57.121030	profile	system.db.CDbCommand.execute	end:system.db.CDbCommand.execute(DELETE FROM `YiiLog` WHERE 0=1)
15:01:57.121228	trace	system.CModule	Loading "urlHelper" application component
15:01:57.122286	trace	system.CModule	Loading "DBConfig" application component
15:01:57.122780	trace	system.CModule	Loading "cache" application component
15:01:57.124386	trace	system.caching.CMemCache	Serving "66307959e0460a2e2436b0319b2fda14" from cache
15:01:57.124653	trace	system.CModule	Loading "geo" application component
15:01:57.125343	trace	system.CModule	Loading "request" application component
15:01:57.126650	trace	system.CModule	Loading "user" application component
15:01:57.127177	profile	application	begin:loading session
15:01:57.127182	trace	system.CModule	Loading "session" application component
15:01:57.128012	profile	application	end:loading session
15:01:57.130563	trace	system.CModule	Loading "B2BConfig" application component
15:01:57.131021	trace	system.CModule	Loading "urlManager" application component
15:01:57.132337	trace	system.caching.CMemCache	Serving "Yii.CUrlManager.rules" from cache
15:01:57.133925	trace	system.CModule	Loading "themeInterlayer" application component
15:01:57.137294	trace	system.CModule	Loading "themeManager" application component
15:01:57.138164	trace	system.CModule	Loading "clientScript" application component
15:01:57.142200	trace	system.web.filters.CFilterChain	Running filter DBReadUncomitedLevelFilter.filter()
15:01:57.142220	trace	system.db.CDbCommand	Executing SQL: SET SESSION TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
15:01:57.142225	profile	system.db.CDbCommand.execute	begin:system.db.CDbCommand.execute(SET SESSION TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;)
15:01:57.142585	profile	system.db.CDbCommand.execute	end:system.db.CDbCommand.execute(SET SESSION TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;)
15:01:57.142635	trace	system.CModule	Loading "cart" application component
15:01:57.143349	trace	system.db.ar.CActiveRecord	CartUser.find()
15:01:57.143615	trace	system.caching.CMemCache	Serving "yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:b_sale_fuser" from cache
15:01:57.143676	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `b_sale_fuser` `t` WHERE USER_ID=:USER_ID LIMIT 1
15:01:57.143678	profile	system.db.CDbCommand.query	begin:system.db.CDbCommand.query(SELECT * FROM `b_sale_fuser` `t` WHERE USER_ID=:USER_ID LIMIT 1)
15:01:57.143876	profile	system.db.CDbCommand.query	end:system.db.CDbCommand.query(SELECT * FROM `b_sale_fuser` `t` WHERE USER_ID=:USER_ID LIMIT 1)
15:01:57.144119	trace	system.CModule	Loading "coupon" application component
15:01:57.144663	trace	system.CModule	Loading "assetManager" application component
15:01:57.145347	trace	system.db.ar.CActiveRecord	DeliveryCalcMain.find()
15:01:57.145481	trace	system.caching.CMemCache	Serving "yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:sp_delivery_calc_main" from cache
15:01:57.145514	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `sp_delivery_calc_main` `t` WHERE t.location_id = :location_id LIMIT 1
15:01:57.145517	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:01:57.145737	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:01:57.147593	trace	system.CModule	Loading "redisCache" application component
15:01:57.148379	trace	system.caching.CRedisCache	Serving "sberid_AA\Service\OAuth\Clients\SberIdClient_sberid_authState" from cache
15:01:57.148753	trace	system.caching.CRedisCache	Serving "sberid_AA\Service\OAuth\Clients\SberIdClient_sberid_authState" from cache
15:01:57.148865	profile	application	begin:loading session
15:01:57.148869	profile	application	end:loading session
15:01:57.151680	trace	system.CModule	Loading "order" application component
15:01:57.157332	trace	system.CModule	Loading "IPropeties" application component
15:01:57.161539	trace	system.caching.CMemCache	Serving "iblock_properties_0" from cache
15:01:57.162111	trace	system.caching.CMemCache	Serving "iblock_properties_0getPropValues1408" from cache
15:01:57.162522	trace	system.caching.CMemCache	Serving "IWarehouseIWarehouse::getStaticList" from cache
15:01:57.162631	trace	system.db.ar.CActiveRecord	TPSupToTer.findAll()
15:01:57.162636	trace	system.CModule	Loading "dbTP" application component
15:01:57.162652	trace	system.db.CDbConnection	Opening DB connection
15:01:57.165292	trace	system.caching.CMemCache	Serving "yii:dbschemamysql:host=192.168.0.1;dbname=tp:alliance-auto:{{sup_to_ter}}" from cache
15:01:57.165522	trace	system.caching.CMemCache	Serving "yii:dbschemamysql:host=192.168.0.1;dbname=tp:alliance-auto:{{supplier_delivery_settings}}" from cache
15:01:57.165679	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:01:57.191837	trace	system.CModule	Loading "ICatalog" application component
15:01:57.192483	trace	system.caching.CMemCache	Serving "b_catalog_group1" from cache
15:01:57.194703	trace	system.caching.CMemCache	Serving "yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:b_iblock_element" from cache
15:01:57.195044	trace	system.db.ar.CActiveRecord	TPSupToTer.findAll()
15:01:57.195313	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:01:57.223176	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:01:57.223180	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:01:57.223712	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:01:57.223875	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:01:57.223879	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:01:57.224090	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:01:57.224303	profile	application	begin:Sphinx index catalog,catalog_morph,marketplace
15:01:57.353759	profile	application	begin:Sphinx search. total_found: 8868; time: 0.124
15:01:57.354109	trace	system.caching.CMemCache	Serving "yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:mp_goods" from cache
15:01:57.354191	trace	system.db.ar.CActiveRecord	MpGood.findAll()
15:01:57.354298	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:01:57.354346	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:01:57.355555	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:01:57.356431	trace	system.db.ar.CActiveRecord	TPSupToTer.findAll()
15:01:57.356661	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:01:57.390274	trace	system.caching.CMemCache	Serving "yii:dbschemamysql:host=192.168.0.1;dbname=tp:alliance-auto:{{allprices}}" from cache
15:01:57.390314	trace	system.db.ar.CActiveRecord	TPAllPrices.findAll()
15:01:57.390759	trace	system.caching.CMemCache	Serving "yii:dbschemamysql:host=192.168.0.1;dbname=tp:alliance-auto:{{supplier}}" from cache
15:01:57.391289	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:01:57.394167	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:01:57.394171	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:01:57.394397	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:01:57.394537	trace	system.db.ar.CActiveRecord	TPSupToTer.findAll()
15:01:57.394752	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:01:57.437269	profile	application	begin:Sphinx select id,@groupby,@distinct,@count,property_msection_id
15:01:57.437278	profile	application	begin:Sphinx index catalog,catalog_morph,marketplace
15:01:57.590652	profile	application	begin:Sphinx search. total_found: 1392; time: 0.095
15:01:57.591312	trace	system.CModule	Loading "GoodSections" application component
15:01:57.591422	trace	system.CModule	Loading "fcache" application component
15:01:57.602062	trace	system.caching.CFileCache	Serving "good_sections_tree5" from cache
15:01:57.602389	trace	system.caching.CMemCache	Serving "yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:b_iblock_section" from cache
15:01:57.608967	trace	system.CModule	Loading "dbTecDoc" application component
15:01:57.608995	trace	system.db.CDbConnection	Opening DB connection
15:01:57.610075	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:01:57.612320	trace	system.CModule	Loading "dbTecDoc2" application component
15:01:57.612340	trace	system.db.CDbConnection	Opening DB connection
15:01:57.613125	trace	system.db.CDbCommand	Querying SQL: call get_brandfilter_by_art_no_link_v7_1('204', 49, 66, 1, 66)
15:01:57.819885	trace	system.CModule	Loading "goodTpl" application component
15:01:57.820908	trace	system.CModule	Loading "microdataManager" application component
15:01:57.821743	trace	system.CModule	Loading "widgetFactory" application component
15:01:57.835020	trace	system.CModule	Loading "yandexEcom" application component
15:01:57.850054	trace	system.CModule	Loading "coreMessages" application component
15:01:57.950436	trace	system.CModule	Loading "GoodPropDesc" application component
15:01:57.950691	trace	system.caching.CFileCache	Serving "iblock_properties_desc" from cache
15:01:57.951493	trace	system.caching.CMemCache	Serving "iblock_properties_0getPropIssetValuesByCodes1Goodaf69e938ad2b85713393339417f9edb9" from cache
15:01:57.951775	trace	system.caching.CMemCache	Serving "MpAttrsHelpergetAttrIssetValuesByCodesd41d8cd98f00b204e9800998ecf8427e66af69e938ad2b85713393339417f9edb9" from cache
15:01:57.951930	trace	system.caching.CMemCache	Serving "MpAttrsHelpergetAttrIssetForOurGoodsValuesByCodesd41d8cd98f00b204e9800998ecf8427e66af69e938ad2b85713393339417f9edb9" from cache
15:01:57.956111	trace	system.caching.CMemCache	Serving "iblock_properties_0getPropIssetValuesByCoded41d8cd98f00b204e9800998ecf8427eGoodPROPERTY_MAKER_LISTe71c3cff221dbf201e3205d1ae09bc17dcca48101505dd86b703689a604fe3c4" from cache
15:01:57.957438	trace	system.caching.CMemCache	Serving "iblock_properties_0getPropIssetValuesByCoded41d8cd98f00b204e9800998ecf8427eGoodPROPERTY_CATGROUPe71c3cff221dbf201e3205d1ae09bc17dcca48101505dd86b703689a604fe3c4" from cache
15:01:57.962318	trace	system.caching.CRedisCache	Serving "sberid_AA\Service\OAuth\Clients\SberIdClient_sberid_authState" from cache
15:01:57.962570	trace	system.caching.CRedisCache	Serving "sberid_AA\Service\OAuth\Clients\SberIdClient_sberid_authState" from cache
15:01:57.965470	trace	system.db.ar.CActiveRecord	CartUser.find()
15:01:57.965548	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `b_sale_fuser` `t` WHERE USER_ID=:USER_ID LIMIT 1
15:01:57.965555	profile	system.db.CDbCommand.query	begin:system.db.CDbCommand.query(SELECT * FROM `b_sale_fuser` `t` WHERE USER_ID=:USER_ID LIMIT 1)
15:01:57.965840	profile	system.db.CDbCommand.query	end:system.db.CDbCommand.query(SELECT * FROM `b_sale_fuser` `t` WHERE USER_ID=:USER_ID LIMIT 1)
15:01:57.965997	trace	system.db.ar.CActiveRecord	CartUser.find()
15:01:57.966051	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `b_sale_fuser` `t` WHERE USER_ID=:USER_ID LIMIT 1
15:01:57.966054	profile	system.db.CDbCommand.query	begin:system.db.CDbCommand.query(SELECT * FROM `b_sale_fuser` `t` WHERE USER_ID=:USER_ID LIMIT 1)
15:01:57.966234	profile	system.db.CDbCommand.query	end:system.db.CDbCommand.query(SELECT * FROM `b_sale_fuser` `t` WHERE USER_ID=:USER_ID LIMIT 1)
15:01:57.966242	trace	system.db.ar.CActiveRecord	Cart.count()
15:01:57.966514	trace	system.caching.CMemCache	Serving "yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:b_sale_basket" from cache
15:01:57.966590	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:01:57.966593	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:01:57.966774	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:01:57.969500	trace	system.caching.CMemCache	Serving "CB:name:top_header_menu_delivery_desktop" from cache
15:01:57.970695	trace	system.caching.CMemCache	Serving "CB:name:top_alert_desktop" from cache
15:01:57.972656	trace	system.db.ar.CActiveRecord	CartUser.find()
15:01:57.972707	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `b_sale_fuser` `t` WHERE USER_ID=:USER_ID LIMIT 1
15:01:57.972712	profile	system.db.CDbCommand.query	begin:system.db.CDbCommand.query(SELECT * FROM `b_sale_fuser` `t` WHERE USER_ID=:USER_ID LIMIT 1)
15:01:57.972944	profile	system.db.CDbCommand.query	end:system.db.CDbCommand.query(SELECT * FROM `b_sale_fuser` `t` WHERE USER_ID=:USER_ID LIMIT 1)
15:01:57.972989	trace	system.db.ar.CActiveRecord	CartUser.find()
15:01:57.973020	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `b_sale_fuser` `t` WHERE USER_ID=:USER_ID LIMIT 1
15:01:57.973021	profile	system.db.CDbCommand.query	begin:system.db.CDbCommand.query(SELECT * FROM `b_sale_fuser` `t` WHERE USER_ID=:USER_ID LIMIT 1)
15:01:57.973211	profile	system.db.CDbCommand.query	end:system.db.CDbCommand.query(SELECT * FROM `b_sale_fuser` `t` WHERE USER_ID=:USER_ID LIMIT 1)
15:01:57.973217	trace	system.db.ar.CActiveRecord	Cart.count()
15:01:57.973278	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:01:57.973280	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:01:57.973453	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:01:57.977272	trace	system.caching.CMemCache	Serving "CB:name:bottom_job_desktop" from cache
15:01:57.977895	trace	system.caching.CMemCache	Serving "CB:name:partners_desktop" from cache
15:01:57.978539	trace	system.caching.CMemCache	Serving "CB:name:bottom_for_buyer_desktop" from cache
15:01:57.979027	trace	system.CModule	Loading "territory" application component
15:01:57.983661	trace	system.caching.CMemCache	Serving "ITerritory3" from cache
15:01:57.986884	trace	system.caching.CMemCache	Serving "iblock_properties_0getPropValues1045" from cache
15:01:57.993251	trace	system.caching.CMemCache	Serving "CB:name:bottom_copy_text_desktop" from cache

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

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