Результаты поиска по запросу 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.83460с, Память: 21,631Кб)
Процедура	Номер	Всего (с)	Средн. (с)	Мин. (с)	Макс. (с)
Sphinx select id,@groupby,@distinct,@count,property_msection_id	1	0.58845	0.58845	0.58845	0.58845
Sphinx search. total_found: 8868; time: 0.081	1	0.65559	0.65559	0.65559	0.65559
Sphinx search. total_found: 1392; time: 0.091	1	0.42977	0.42977	0.42977	0.42977
Sphinx index catalog,catalog_morph,marketplace	2	1.32928	0.66464	0.58845	0.74083
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.00135	0.00135	0.00135	0.00135
system.db.CDbCommand.query(SELECT * FROM `b_sale_fuser` `t` WHERE USER_ID=:USER_ID LIMIT 1)	5	0.00109	0.00022	0.00017	0.00030
loading session	2	0.00089	0.00044	0.00000	0.00088
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.00051	0.00025	0.00022	0.00029
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.00040	0.00020	0.00018	0.00022
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.00033	0.00033	0.00033	0.00033
system.db.CDbCommand.execute(DELETE FROM `YiiLog` WHERE 0=1)	1	0.00027	0.00027	0.00027	0.00027
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.00022	0.00022	0.00022	0.00022

Журнал приложения
Время	Уровень	Категория	Сообщение
15:02:43.580336	trace	system.CModule	Loading "log" application component
15:02:43.582730	trace	glitchtip_fallback	The "Sentry\Integration\RequestIntegration, Sentry\Integration\TransactionIntegration, Sentry\Integration\FrameContextifierIntegration, Sentry\Integration\EnvironmentIntegration" integration(s) have been installed.
15:02:43.582942	trace	system.CModule	Loading "db" application component
15:02:43.583012	trace	system.db.CDbConnection	Opening DB connection
15:02:43.584146	trace	system.db.CDbCommand	Executing SQL: DELETE FROM `YiiLog` WHERE 0=1
15:02:43.584151	profile	system.db.CDbCommand.execute	begin:system.db.CDbCommand.execute(DELETE FROM `YiiLog` WHERE 0=1)
15:02:43.584419	profile	system.db.CDbCommand.execute	end:system.db.CDbCommand.execute(DELETE FROM `YiiLog` WHERE 0=1)
15:02:43.584583	trace	system.CModule	Loading "urlHelper" application component
15:02:43.584700	trace	system.CModule	Loading "DBConfig" application component
15:02:43.584739	trace	system.CModule	Loading "cache" application component
15:02:43.585674	trace	system.caching.CMemCache	Serving "66307959e0460a2e2436b0319b2fda14" from cache
15:02:43.585977	trace	system.CModule	Loading "geo" application component
15:02:43.586049	trace	system.CModule	Loading "request" application component
15:02:43.586247	trace	system.CModule	Loading "user" application component
15:02:43.586393	profile	application	begin:loading session
15:02:43.586396	trace	system.CModule	Loading "session" application component
15:02:43.587276	profile	application	end:loading session
15:02:43.587832	trace	system.CModule	Loading "B2BConfig" application component
15:02:43.587923	trace	system.CModule	Loading "urlManager" application component
15:02:43.589040	trace	system.caching.CMemCache	Serving "Yii.CUrlManager.rules" from cache
15:02:43.589865	trace	system.CModule	Loading "themeInterlayer" application component
15:02:43.590585	trace	system.CModule	Loading "themeManager" application component
15:02:43.590775	trace	system.CModule	Loading "clientScript" application component
15:02:43.592938	trace	system.web.filters.CFilterChain	Running filter DBReadUncomitedLevelFilter.filter()
15:02:43.592956	trace	system.db.CDbCommand	Executing SQL: SET SESSION TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
15:02:43.592959	profile	system.db.CDbCommand.execute	begin:system.db.CDbCommand.execute(SET SESSION TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;)
15:02:43.593200	profile	system.db.CDbCommand.execute	end:system.db.CDbCommand.execute(SET SESSION TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;)
15:02:43.593245	trace	system.CModule	Loading "cart" application component
15:02:43.593349	trace	system.db.ar.CActiveRecord	CartUser.find()
15:02:43.593738	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.594027	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.594228	trace	system.CModule	Loading "coupon" application component
15:02:43.594458	trace	system.CModule	Loading "assetManager" application component
15:02:43.594651	trace	system.db.ar.CActiveRecord	DeliveryCalcMain.find()
15:02:43.594831	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.594882	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `sp_delivery_calc_main` `t` WHERE t.location_id = :location_id LIMIT 1
15:02:43.594887	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.595105	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.596451	trace	system.CModule	Loading "redisCache" application component
15:02:43.597155	trace	system.caching.CRedisCache	Serving "sberid_AA\Service\OAuth\Clients\SberIdClient_sberid_authState" from cache
15:02:43.597529	trace	system.caching.CRedisCache	Serving "sberid_AA\Service\OAuth\Clients\SberIdClient_sberid_authState" from cache
15:02:43.597651	profile	application	begin:loading session
15:02:43.597655	profile	application	end:loading session
15:02:43.599442	trace	system.CModule	Loading "order" application component
15:02:43.602447	trace	system.CModule	Loading "IPropeties" application component
15:02:43.606009	trace	system.caching.CMemCache	Serving "iblock_properties_0" from cache
15:02:43.606539	trace	system.caching.CMemCache	Serving "iblock_properties_0getPropValues1408" from cache
15:02:43.606967	trace	system.caching.CMemCache	Serving "IWarehouseIWarehouse::getStaticList" from cache
15:02:43.607074	trace	system.db.ar.CActiveRecord	TPSupToTer.findAll()
15:02:43.607079	trace	system.CModule	Loading "dbTP" application component
15:02:43.607094	trace	system.db.CDbConnection	Opening DB connection
15:02:43.608210	trace	system.caching.CMemCache	Serving "yii:dbschemamysql:host=192.168.0.1;dbname=tp:alliance-auto:{{sup_to_ter}}" from cache
15:02:43.608428	trace	system.caching.CMemCache	Serving "yii:dbschemamysql:host=192.168.0.1;dbname=tp:alliance-auto:{{supplier_delivery_settings}}" from cache
15:02:43.608606	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.638528	trace	system.CModule	Loading "ICatalog" application component
15:02:43.638828	trace	system.caching.CMemCache	Serving "b_catalog_group1" from cache
15:02:43.639462	trace	system.caching.CMemCache	Serving "yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:b_iblock_element" from cache
15:02:43.639811	trace	system.db.ar.CActiveRecord	TPSupToTer.findAll()
15:02:43.640080	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.669045	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.669051	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.669378	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.669570	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.669575	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.669791	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.670020	profile	application	begin:Sphinx index catalog,catalog_morph,marketplace
15:02:43.755264	profile	application	begin:Sphinx search. total_found: 8868; time: 0.081
15:02:43.755738	trace	system.caching.CMemCache	Serving "yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:mp_goods" from cache
15:02:43.755848	trace	system.db.ar.CActiveRecord	MpGood.findAll()
15:02:43.755976	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.755980	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.757327	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.758042	trace	system.db.ar.CActiveRecord	TPSupToTer.findAll()
15:02:43.758256	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.786734	trace	system.caching.CMemCache	Serving "yii:dbschemamysql:host=192.168.0.1;dbname=tp:alliance-auto:{{allprices}}" from cache
15:02:43.786803	trace	system.db.ar.CActiveRecord	TPAllPrices.findAll()
15:02:43.787323	trace	system.caching.CMemCache	Serving "yii:dbschemamysql:host=192.168.0.1;dbname=tp:alliance-auto:{{supplier}}" from cache
15:02:43.787884	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.791014	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.791019	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.791310	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.791486	trace	system.db.ar.CActiveRecord	TPSupToTer.findAll()
15:02:43.791707	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.822402	profile	application	begin:Sphinx select id,@groupby,@distinct,@count,property_msection_id
15:02:43.822407	profile	application	begin:Sphinx index catalog,catalog_morph,marketplace
15:02:43.981081	profile	application	begin:Sphinx search. total_found: 1392; time: 0.091
15:02:43.981755	trace	system.CModule	Loading "GoodSections" application component
15:02:43.981841	trace	system.CModule	Loading "fcache" application component
15:02:43.992242	trace	system.caching.CFileCache	Serving "good_sections_tree5" from cache
15:02:43.992558	trace	system.caching.CMemCache	Serving "yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:b_iblock_section" from cache
15:02:43.999155	trace	system.CModule	Loading "dbTecDoc" application component
15:02:43.999181	trace	system.db.CDbConnection	Opening DB connection
15:02:44.000555	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.001399	trace	system.CModule	Loading "dbTecDoc2" application component
15:02:44.001442	trace	system.db.CDbConnection	Opening DB connection
15:02:44.002489	trace	system.db.CDbCommand	Querying SQL: call get_brandfilter_by_art_no_link_v7_1('204', 49, 66, 1, 66)
15:02:44.215538	trace	system.CModule	Loading "goodTpl" application component
15:02:44.216533	trace	system.CModule	Loading "microdataManager" application component
15:02:44.217333	trace	system.CModule	Loading "widgetFactory" application component
15:02:44.229634	trace	system.CModule	Loading "yandexEcom" application component
15:02:44.244297	trace	system.CModule	Loading "coreMessages" application component
15:02:44.347572	trace	system.CModule	Loading "GoodPropDesc" application component
15:02:44.347806	trace	system.caching.CFileCache	Serving "iblock_properties_desc" from cache
15:02:44.348644	trace	system.caching.CMemCache	Serving "iblock_properties_0getPropIssetValuesByCodes1Goodaf69e938ad2b85713393339417f9edb9" from cache
15:02:44.349040	trace	system.caching.CMemCache	Serving "MpAttrsHelpergetAttrIssetValuesByCodesd41d8cd98f00b204e9800998ecf8427e66af69e938ad2b85713393339417f9edb9" from cache
15:02:44.349210	trace	system.caching.CMemCache	Serving "MpAttrsHelpergetAttrIssetForOurGoodsValuesByCodesd41d8cd98f00b204e9800998ecf8427e66af69e938ad2b85713393339417f9edb9" from cache
15:02:44.353451	trace	system.caching.CMemCache	Serving "iblock_properties_0getPropIssetValuesByCoded41d8cd98f00b204e9800998ecf8427eGoodPROPERTY_MAKER_LISTe71c3cff221dbf201e3205d1ae09bc17dcca48101505dd86b703689a604fe3c4" from cache
15:02:44.355119	trace	system.caching.CMemCache	Serving "iblock_properties_0getPropIssetValuesByCoded41d8cd98f00b204e9800998ecf8427eGoodPROPERTY_CATGROUPe71c3cff221dbf201e3205d1ae09bc17dcca48101505dd86b703689a604fe3c4" from cache
15:02:44.360238	trace	system.caching.CRedisCache	Serving "sberid_AA\Service\OAuth\Clients\SberIdClient_sberid_authState" from cache
15:02:44.360544	trace	system.caching.CRedisCache	Serving "sberid_AA\Service\OAuth\Clients\SberIdClient_sberid_authState" from cache
15:02:44.363503	trace	system.db.ar.CActiveRecord	CartUser.find()
15:02:44.363562	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `b_sale_fuser` `t` WHERE USER_ID=:USER_ID LIMIT 1
15:02:44.363565	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.363864	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.364023	trace	system.db.ar.CActiveRecord	CartUser.find()
15:02:44.364058	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `b_sale_fuser` `t` WHERE USER_ID=:USER_ID LIMIT 1
15:02:44.364061	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.364228	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.364236	trace	system.db.ar.CActiveRecord	Cart.count()
15:02:44.364511	trace	system.caching.CMemCache	Serving "yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:b_sale_basket" from cache
15:02:44.364619	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.364625	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.364845	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.367526	trace	system.caching.CMemCache	Serving "CB:name:top_header_menu_delivery_desktop" from cache
15:02:44.368813	trace	system.caching.CMemCache	Serving "CB:name:top_alert_desktop" from cache
15:02:44.370819	trace	system.db.ar.CActiveRecord	CartUser.find()
15:02:44.370868	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `b_sale_fuser` `t` WHERE USER_ID=:USER_ID LIMIT 1
15:02:44.370873	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.371084	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.371140	trace	system.db.ar.CActiveRecord	CartUser.find()
15:02:44.371192	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `b_sale_fuser` `t` WHERE USER_ID=:USER_ID LIMIT 1
15:02:44.371217	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.371407	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.371412	trace	system.db.ar.CActiveRecord	Cart.count()
15:02:44.371460	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.371464	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.371645	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.375303	trace	system.caching.CMemCache	Serving "CB:name:bottom_job_desktop" from cache
15:02:44.375798	trace	system.caching.CMemCache	Serving "CB:name:partners_desktop" from cache
15:02:44.376410	trace	system.caching.CMemCache	Serving "CB:name:bottom_for_buyer_desktop" from cache
15:02:44.377005	trace	system.CModule	Loading "territory" application component
15:02:44.381719	trace	system.caching.CMemCache	Serving "ITerritory3" from cache
15:02:44.384438	trace	system.caching.CMemCache	Serving "iblock_properties_0getPropValues1045" from cache
15:02:44.390845	trace	system.caching.CMemCache	Serving "CB:name:bottom_copy_text_desktop" from cache

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

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