Результаты поиска по запросу 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.84047с, Память: 21,631Кб)
Процедура	Номер	Всего (с)	Средн. (с)	Мин. (с)	Макс. (с)
Sphinx select id,@groupby,@distinct,@count,property_msection_id	1	0.58991	0.58991	0.58991	0.58991
Sphinx search. total_found: 8868; time: 0.076	1	0.66253	0.66253	0.66253	0.66253
Sphinx search. total_found: 1392; time: 0.086	1	0.43528	0.43528	0.43528	0.43528
Sphinx index catalog,catalog_morph,marketplace	2	1.33291	0.66645	0.58990	0.74301
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.00134	0.00134	0.00134	0.00134
system.db.CDbCommand.query(SELECT * FROM `b_sale_fuser` `t` WHERE USER_ID=:USER_ID LIMIT 1)	5	0.00102	0.00020	0.00018	0.00026
loading session	2	0.00085	0.00043	0.00000	0.00085
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.00043	0.00021	0.00021	0.00022
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.00036	0.00018	0.00018	0.00019
system.db.CDbCommand.execute(DELETE FROM `YiiLog` WHERE 0=1)	1	0.00027	0.00027	0.00027	0.00027
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.00025	0.00025	0.00025	0.00025
system.db.CDbCommand.execute(SET SESSION TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;)	1	0.00022	0.00022	0.00022	0.00022
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:02:43.579943	trace	system.CModule	Loading "log" application component
15:02:43.582606	trace	glitchtip_fallback	The "Sentry\Integration\RequestIntegration, Sentry\Integration\TransactionIntegration, Sentry\Integration\FrameContextifierIntegration, Sentry\Integration\EnvironmentIntegration" integration(s) have been installed.
15:02:43.582793	trace	system.CModule	Loading "db" application component
15:02:43.582853	trace	system.db.CDbConnection	Opening DB connection
15:02:43.583931	trace	system.db.CDbCommand	Executing SQL: DELETE FROM `YiiLog` WHERE 0=1
15:02:43.583939	profile	system.db.CDbCommand.execute	begin:system.db.CDbCommand.execute(DELETE FROM `YiiLog` WHERE 0=1)
15:02:43.584209	profile	system.db.CDbCommand.execute	end:system.db.CDbCommand.execute(DELETE FROM `YiiLog` WHERE 0=1)
15:02:43.584372	trace	system.CModule	Loading "urlHelper" application component
15:02:43.584486	trace	system.CModule	Loading "DBConfig" application component
15:02:43.584528	trace	system.CModule	Loading "cache" application component
15:02:43.585498	trace	system.caching.CMemCache	Serving "66307959e0460a2e2436b0319b2fda14" from cache
15:02:43.585835	trace	system.CModule	Loading "geo" application component
15:02:43.585916	trace	system.CModule	Loading "request" application component
15:02:43.586141	trace	system.CModule	Loading "user" application component
15:02:43.586272	profile	application	begin:loading session
15:02:43.586280	trace	system.CModule	Loading "session" application component
15:02:43.587122	profile	application	end:loading session
15:02:43.587707	trace	system.CModule	Loading "B2BConfig" application component
15:02:43.587804	trace	system.CModule	Loading "urlManager" application component
15:02:43.589057	trace	system.caching.CMemCache	Serving "Yii.CUrlManager.rules" from cache
15:02:43.589871	trace	system.CModule	Loading "themeInterlayer" application component
15:02:43.590576	trace	system.CModule	Loading "themeManager" application component
15:02:43.590751	trace	system.CModule	Loading "clientScript" application component
15:02:43.592999	trace	system.web.filters.CFilterChain	Running filter DBReadUncomitedLevelFilter.filter()
15:02:43.593013	trace	system.db.CDbCommand	Executing SQL: SET SESSION TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
15:02:43.593015	profile	system.db.CDbCommand.execute	begin:system.db.CDbCommand.execute(SET SESSION TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;)
15:02:43.593230	profile	system.db.CDbCommand.execute	end:system.db.CDbCommand.execute(SET SESSION TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;)
15:02:43.593275	trace	system.CModule	Loading "cart" application component
15:02:43.593399	trace	system.db.ar.CActiveRecord	CartUser.find()
15:02:43.593739	trace	system.caching.CMemCache	Serving "yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:b_sale_fuser" from cache
15:02:43.593796	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `b_sale_fuser` `t` WHERE USER_ID=:USER_ID LIMIT 1
15:02:43.593799	profile	system.db.CDbCommand.query	begin:system.db.CDbCommand.query(SELECT * FROM `b_sale_fuser` `t` WHERE USER_ID=:USER_ID LIMIT 1)
15:02:43.594005	profile	system.db.CDbCommand.query	end:system.db.CDbCommand.query(SELECT * FROM `b_sale_fuser` `t` WHERE USER_ID=:USER_ID LIMIT 1)
15:02:43.594218	trace	system.CModule	Loading "coupon" application component
15:02:43.594491	trace	system.CModule	Loading "assetManager" application component
15:02:43.594675	trace	system.db.ar.CActiveRecord	DeliveryCalcMain.find()
15:02:43.594820	trace	system.caching.CMemCache	Serving "yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:sp_delivery_calc_main" from cache
15:02:43.594873	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `sp_delivery_calc_main` `t` WHERE t.location_id = :location_id LIMIT 1
15:02:43.594877	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:02:43.595068	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:02:43.596435	trace	system.CModule	Loading "redisCache" application component
15:02:43.597222	trace	system.caching.CRedisCache	Serving "sberid_AA\Service\OAuth\Clients\SberIdClient_sberid_authState" from cache
15:02:43.597579	trace	system.caching.CRedisCache	Serving "sberid_AA\Service\OAuth\Clients\SberIdClient_sberid_authState" from cache
15:02:43.597686	profile	application	begin:loading session
15:02:43.597690	profile	application	end:loading session
15:02:43.599335	trace	system.CModule	Loading "order" application component
15:02:43.602312	trace	system.CModule	Loading "IPropeties" application component
15:02:43.605696	trace	system.caching.CMemCache	Serving "iblock_properties_0" from cache
15:02:43.606288	trace	system.caching.CMemCache	Serving "iblock_properties_0getPropValues1408" from cache
15:02:43.606720	trace	system.caching.CMemCache	Serving "IWarehouseIWarehouse::getStaticList" from cache
15:02:43.606841	trace	system.db.ar.CActiveRecord	TPSupToTer.findAll()
15:02:43.606846	trace	system.CModule	Loading "dbTP" application component
15:02:43.606873	trace	system.db.CDbConnection	Opening DB connection
15:02:43.608094	trace	system.caching.CMemCache	Serving "yii:dbschemamysql:host=192.168.0.1;dbname=tp:alliance-auto:{{sup_to_ter}}" from cache
15:02:43.608372	trace	system.caching.CMemCache	Serving "yii:dbschemamysql:host=192.168.0.1;dbname=tp:alliance-auto:{{supplier_delivery_settings}}" from cache
15:02:43.608594	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:02:43.640415	trace	system.CModule	Loading "ICatalog" application component
15:02:43.640985	trace	system.caching.CMemCache	Serving "b_catalog_group1" from cache
15:02:43.641510	trace	system.caching.CMemCache	Serving "yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:b_iblock_element" from cache
15:02:43.641820	trace	system.db.ar.CActiveRecord	TPSupToTer.findAll()
15:02:43.642051	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:02:43.672615	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:02:43.672619	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:02:43.672871	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:02:43.673038	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:02:43.673043	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:02:43.673249	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:02:43.673504	profile	application	begin:Sphinx index catalog,catalog_morph,marketplace
15:02:43.753978	profile	application	begin:Sphinx search. total_found: 8868; time: 0.076
15:02:43.754522	trace	system.caching.CMemCache	Serving "yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:mp_goods" from cache
15:02:43.754666	trace	system.db.ar.CActiveRecord	MpGood.findAll()
15:02:43.754775	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:02:43.754777	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:02:43.756117	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:02:43.756905	trace	system.db.ar.CActiveRecord	TPSupToTer.findAll()
15:02:43.757159	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:02:43.789592	trace	system.caching.CMemCache	Serving "yii:dbschemamysql:host=192.168.0.1;dbname=tp:alliance-auto:{{allprices}}" from cache
15:02:43.789635	trace	system.db.ar.CActiveRecord	TPAllPrices.findAll()
15:02:43.790051	trace	system.caching.CMemCache	Serving "yii:dbschemamysql:host=192.168.0.1;dbname=tp:alliance-auto:{{supplier}}" from cache
15:02:43.790489	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:02:43.793042	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:02:43.793046	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:02:43.793265	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:02:43.793443	trace	system.db.ar.CActiveRecord	TPSupToTer.findAll()
15:02:43.793741	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:02:43.826603	profile	application	begin:Sphinx select id,@groupby,@distinct,@count,property_msection_id
15:02:43.826608	profile	application	begin:Sphinx index catalog,catalog_morph,marketplace
15:02:43.981228	profile	application	begin:Sphinx search. total_found: 1392; time: 0.086
15:02:43.982285	trace	system.CModule	Loading "GoodSections" application component
15:02:43.982389	trace	system.CModule	Loading "fcache" application component
15:02:43.998599	trace	system.caching.CFileCache	Serving "good_sections_tree5" from cache
15:02:43.998958	trace	system.caching.CMemCache	Serving "yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:b_iblock_section" from cache
15:02:44.009702	trace	system.CModule	Loading "dbTecDoc" application component
15:02:44.009737	trace	system.db.CDbConnection	Opening DB connection
15:02:44.011101	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:02:44.011738	trace	system.CModule	Loading "dbTecDoc2" application component
15:02:44.011754	trace	system.db.CDbConnection	Opening DB connection
15:02:44.012572	trace	system.db.CDbCommand	Querying SQL: call get_brandfilter_by_art_no_link_v7_1('204', 49, 66, 1, 66)
15:02:44.222719	trace	system.CModule	Loading "goodTpl" application component
15:02:44.223727	trace	system.CModule	Loading "microdataManager" application component
15:02:44.224536	trace	system.CModule	Loading "widgetFactory" application component
15:02:44.238886	trace	system.CModule	Loading "yandexEcom" application component
15:02:44.254811	trace	system.CModule	Loading "coreMessages" application component
15:02:44.354878	trace	system.CModule	Loading "GoodPropDesc" application component
15:02:44.355081	trace	system.caching.CFileCache	Serving "iblock_properties_desc" from cache
15:02:44.355761	trace	system.caching.CMemCache	Serving "iblock_properties_0getPropIssetValuesByCodes1Goodaf69e938ad2b85713393339417f9edb9" from cache
15:02:44.355998	trace	system.caching.CMemCache	Serving "MpAttrsHelpergetAttrIssetValuesByCodesd41d8cd98f00b204e9800998ecf8427e66af69e938ad2b85713393339417f9edb9" from cache
15:02:44.356147	trace	system.caching.CMemCache	Serving "MpAttrsHelpergetAttrIssetForOurGoodsValuesByCodesd41d8cd98f00b204e9800998ecf8427e66af69e938ad2b85713393339417f9edb9" from cache
15:02:44.360409	trace	system.caching.CMemCache	Serving "iblock_properties_0getPropIssetValuesByCoded41d8cd98f00b204e9800998ecf8427eGoodPROPERTY_MAKER_LISTe71c3cff221dbf201e3205d1ae09bc17dcca48101505dd86b703689a604fe3c4" from cache
15:02:44.362546	trace	system.caching.CMemCache	Serving "iblock_properties_0getPropIssetValuesByCoded41d8cd98f00b204e9800998ecf8427eGoodPROPERTY_CATGROUPe71c3cff221dbf201e3205d1ae09bc17dcca48101505dd86b703689a604fe3c4" from cache
15:02:44.367440	trace	system.caching.CRedisCache	Serving "sberid_AA\Service\OAuth\Clients\SberIdClient_sberid_authState" from cache
15:02:44.367815	trace	system.caching.CRedisCache	Serving "sberid_AA\Service\OAuth\Clients\SberIdClient_sberid_authState" from cache
15:02:44.370249	trace	system.db.ar.CActiveRecord	CartUser.find()
15:02:44.370310	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `b_sale_fuser` `t` WHERE USER_ID=:USER_ID LIMIT 1
15:02:44.370315	profile	system.db.CDbCommand.query	begin:system.db.CDbCommand.query(SELECT * FROM `b_sale_fuser` `t` WHERE USER_ID=:USER_ID LIMIT 1)
15:02:44.370572	profile	system.db.CDbCommand.query	end:system.db.CDbCommand.query(SELECT * FROM `b_sale_fuser` `t` WHERE USER_ID=:USER_ID LIMIT 1)
15:02:44.370687	trace	system.db.ar.CActiveRecord	CartUser.find()
15:02:44.370719	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `b_sale_fuser` `t` WHERE USER_ID=:USER_ID LIMIT 1
15:02:44.370723	profile	system.db.CDbCommand.query	begin:system.db.CDbCommand.query(SELECT * FROM `b_sale_fuser` `t` WHERE USER_ID=:USER_ID LIMIT 1)
15:02:44.370909	profile	system.db.CDbCommand.query	end:system.db.CDbCommand.query(SELECT * FROM `b_sale_fuser` `t` WHERE USER_ID=:USER_ID LIMIT 1)
15:02:44.370915	trace	system.db.ar.CActiveRecord	Cart.count()
15:02:44.371140	trace	system.caching.CMemCache	Serving "yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:b_sale_basket" from cache
15:02:44.371242	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:02:44.371244	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:02:44.371431	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:02:44.373725	trace	system.caching.CMemCache	Serving "CB:name:top_header_menu_delivery_desktop" from cache
15:02:44.375051	trace	system.caching.CMemCache	Serving "CB:name:top_alert_desktop" from cache
15:02:44.376751	trace	system.db.ar.CActiveRecord	CartUser.find()
15:02:44.376790	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `b_sale_fuser` `t` WHERE USER_ID=:USER_ID LIMIT 1
15:02:44.376794	profile	system.db.CDbCommand.query	begin:system.db.CDbCommand.query(SELECT * FROM `b_sale_fuser` `t` WHERE USER_ID=:USER_ID LIMIT 1)
15:02:44.376991	profile	system.db.CDbCommand.query	end:system.db.CDbCommand.query(SELECT * FROM `b_sale_fuser` `t` WHERE USER_ID=:USER_ID LIMIT 1)
15:02:44.377028	trace	system.db.ar.CActiveRecord	CartUser.find()
15:02:44.377059	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `b_sale_fuser` `t` WHERE USER_ID=:USER_ID LIMIT 1
15:02:44.377063	profile	system.db.CDbCommand.query	begin:system.db.CDbCommand.query(SELECT * FROM `b_sale_fuser` `t` WHERE USER_ID=:USER_ID LIMIT 1)
15:02:44.377239	profile	system.db.CDbCommand.query	end:system.db.CDbCommand.query(SELECT * FROM `b_sale_fuser` `t` WHERE USER_ID=:USER_ID LIMIT 1)
15:02:44.377245	trace	system.db.ar.CActiveRecord	Cart.count()
15:02:44.377295	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:02:44.377298	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:02:44.377475	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:02:44.380783	trace	system.caching.CMemCache	Serving "CB:name:bottom_job_desktop" from cache
15:02:44.381316	trace	system.caching.CMemCache	Serving "CB:name:partners_desktop" from cache
15:02:44.381863	trace	system.caching.CMemCache	Serving "CB:name:bottom_for_buyer_desktop" from cache
15:02:44.382333	trace	system.CModule	Loading "territory" application component
15:02:44.386661	trace	system.caching.CMemCache	Serving "ITerritory3" from cache
15:02:44.389460	trace	system.caching.CMemCache	Serving "iblock_properties_0getPropValues1045" from cache
15:02:44.394870	trace	system.caching.CMemCache	Serving "CB:name:bottom_copy_text_desktop" from cache

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

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