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

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

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

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

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

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

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

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

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

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

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

Общий отчет (Время: 0.84482с, Память: 21,729Кб)
Процедура	Номер	Всего (с)	Средн. (с)	Мин. (с)	Макс. (с)
Sphinx select id,@groupby,@distinct,@count,property_msection_id	1	0.59972	0.59972	0.59972	0.59972
Sphinx search. total_found: 8868; time: 0.072	1	0.67123	0.67123	0.67123	0.67123
Sphinx search. total_found: 1392; time: 0.095	1	0.44288	0.44288	0.44288	0.44288
Sphinx index catalog,catalog_morph,marketplace	2	1.34815	0.67408	0.59972	0.74844
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.00133	0.00133	0.00133	0.00133
system.db.CDbCommand.query(SELECT * FROM `b_sale_fuser` `t` WHERE USER_ID=:USER_ID LIMIT 1)	5	0.00104	0.00021	0.00019	0.00025
loading session	2	0.00079	0.00040	0.00000	0.00079
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.00022	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.00039	0.00019	0.00019	0.00020
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.00029	0.00029	0.00029	0.00029
system.db.CDbCommand.execute(DELETE FROM `YiiLog` WHERE 0=1)	1	0.00024	0.00024	0.00024	0.00024
system.db.CDbCommand.execute(SET SESSION TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;)	1	0.00023	0.00023	0.00023	0.00023
system.db.CDbCommand.query(SELECT * FROM `sp_delivery_calc_main` `t` WHERE t.location_id = :location_id LIMIT 1)	1	0.00021	0.00021	0.00021	0.00021

Журнал приложения
Время	Уровень	Категория	Сообщение
15:49:40.122199	trace	system.CModule	Loading "log" application component
15:49:40.124725	trace	glitchtip_fallback	The "Sentry\Integration\RequestIntegration, Sentry\Integration\TransactionIntegration, Sentry\Integration\FrameContextifierIntegration, Sentry\Integration\EnvironmentIntegration" integration(s) have been installed.
15:49:40.124938	trace	system.CModule	Loading "db" application component
15:49:40.125013	trace	system.db.CDbConnection	Opening DB connection
15:49:40.125881	trace	system.db.CDbCommand	Executing SQL: DELETE FROM `YiiLog` WHERE 0=1
15:49:40.125886	profile	system.db.CDbCommand.execute	begin:system.db.CDbCommand.execute(DELETE FROM `YiiLog` WHERE 0=1)
15:49:40.126127	profile	system.db.CDbCommand.execute	end:system.db.CDbCommand.execute(DELETE FROM `YiiLog` WHERE 0=1)
15:49:40.126262	trace	system.CModule	Loading "urlHelper" application component
15:49:40.126396	trace	system.CModule	Loading "DBConfig" application component
15:49:40.126422	trace	system.CModule	Loading "cache" application component
15:49:40.127291	trace	system.caching.CMemCache	Serving "66307959e0460a2e2436b0319b2fda14" from cache
15:49:40.127563	trace	system.CModule	Loading "geo" application component
15:49:40.127648	trace	system.CModule	Loading "request" application component
15:49:40.127943	trace	system.CModule	Loading "user" application component
15:49:40.128052	profile	application	begin:loading session
15:49:40.128057	trace	system.CModule	Loading "session" application component
15:49:40.128843	profile	application	end:loading session
15:49:40.129295	trace	system.CModule	Loading "B2BConfig" application component
15:49:40.129369	trace	system.CModule	Loading "urlManager" application component
15:49:40.130489	trace	system.caching.CMemCache	Serving "Yii.CUrlManager.rules" from cache
15:49:40.132581	trace	system.CModule	Loading "themeInterlayer" application component
15:49:40.133248	trace	system.CModule	Loading "themeManager" application component
15:49:40.133377	trace	system.CModule	Loading "clientScript" application component
15:49:40.134989	trace	system.web.filters.CFilterChain	Running filter DBReadUncomitedLevelFilter.filter()
15:49:40.135000	trace	system.db.CDbCommand	Executing SQL: SET SESSION TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
15:49:40.135004	profile	system.db.CDbCommand.execute	begin:system.db.CDbCommand.execute(SET SESSION TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;)
15:49:40.135232	profile	system.db.CDbCommand.execute	end:system.db.CDbCommand.execute(SET SESSION TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;)
15:49:40.135262	trace	system.CModule	Loading "cart" application component
15:49:40.135346	trace	system.db.ar.CActiveRecord	CartUser.find()
15:49:40.135648	trace	system.caching.CMemCache	Serving "yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:b_sale_fuser" from cache
15:49:40.135690	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `b_sale_fuser` `t` WHERE USER_ID=:USER_ID LIMIT 1
15:49:40.135694	profile	system.db.CDbCommand.query	begin:system.db.CDbCommand.query(SELECT * FROM `b_sale_fuser` `t` WHERE USER_ID=:USER_ID LIMIT 1)
15:49:40.135888	profile	system.db.CDbCommand.query	end:system.db.CDbCommand.query(SELECT * FROM `b_sale_fuser` `t` WHERE USER_ID=:USER_ID LIMIT 1)
15:49:40.136075	trace	system.CModule	Loading "coupon" application component
15:49:40.136256	trace	system.CModule	Loading "assetManager" application component
15:49:40.136396	trace	system.db.ar.CActiveRecord	DeliveryCalcMain.find()
15:49:40.136533	trace	system.caching.CMemCache	Serving "yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:sp_delivery_calc_main" from cache
15:49:40.136565	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `sp_delivery_calc_main` `t` WHERE t.location_id = :location_id LIMIT 1
15:49:40.136569	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:49:40.136780	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:49:40.137856	trace	system.CModule	Loading "redisCache" application component
15:49:40.138818	trace	system.caching.CRedisCache	Serving "sberid_AA\Service\OAuth\Clients\SberIdClient_sberid_authState" from cache
15:49:40.139178	trace	system.caching.CRedisCache	Serving "sberid_AA\Service\OAuth\Clients\SberIdClient_sberid_authState" from cache
15:49:40.139326	profile	application	begin:loading session
15:49:40.139328	profile	application	end:loading session
15:49:40.140830	trace	system.CModule	Loading "order" application component
15:49:40.144474	trace	system.CModule	Loading "IPropeties" application component
15:49:40.148098	trace	system.caching.CMemCache	Serving "iblock_properties_0" from cache
15:49:40.148648	trace	system.caching.CMemCache	Serving "iblock_properties_0getPropValues1408" from cache
15:49:40.149128	trace	system.caching.CMemCache	Serving "IWarehouseIWarehouse::getStaticList" from cache
15:49:40.149243	trace	system.db.ar.CActiveRecord	TPSupToTer.findAll()
15:49:40.149249	trace	system.CModule	Loading "dbTP" application component
15:49:40.149264	trace	system.db.CDbConnection	Opening DB connection
15:49:40.150556	trace	system.caching.CMemCache	Serving "yii:dbschemamysql:host=192.168.0.1;dbname=tp:alliance-auto:{{sup_to_ter}}" from cache
15:49:40.150780	trace	system.caching.CMemCache	Serving "yii:dbschemamysql:host=192.168.0.1;dbname=tp:alliance-auto:{{supplier_delivery_settings}}" from cache
15:49:40.150943	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:49:40.181811	trace	system.CModule	Loading "ICatalog" application component
15:49:40.181999	trace	system.caching.CMemCache	Serving "b_catalog_group1" from cache
15:49:40.182706	trace	system.caching.CMemCache	Serving "yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:b_iblock_element" from cache
15:49:40.183024	trace	system.db.ar.CActiveRecord	TPSupToTer.findAll()
15:49:40.183271	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:49:40.213726	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:49:40.213730	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:49:40.214024	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:49:40.214169	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:49:40.214173	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:49:40.214395	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:49:40.214840	profile	application	begin:Sphinx index catalog,catalog_morph,marketplace
15:49:40.292049	profile	application	begin:Sphinx search. total_found: 8868; time: 0.072
15:49:40.292330	trace	system.caching.CMemCache	Serving "yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:mp_goods" from cache
15:49:40.292397	trace	system.db.ar.CActiveRecord	MpGood.findAll()
15:49:40.292515	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:49:40.292520	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:49:40.293848	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:49:40.294486	trace	system.db.ar.CActiveRecord	TPSupToTer.findAll()
15:49:40.294742	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:49:40.328418	trace	system.caching.CMemCache	Serving "yii:dbschemamysql:host=192.168.0.1;dbname=tp:alliance-auto:{{allprices}}" from cache
15:49:40.328460	trace	system.db.ar.CActiveRecord	TPAllPrices.findAll()
15:49:40.328864	trace	system.caching.CMemCache	Serving "yii:dbschemamysql:host=192.168.0.1;dbname=tp:alliance-auto:{{supplier}}" from cache
15:49:40.329343	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:49:40.332175	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:49:40.332179	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:49:40.332401	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:49:40.332556	trace	system.db.ar.CActiveRecord	TPSupToTer.findAll()
15:49:40.332751	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:49:40.363553	profile	application	begin:Sphinx select id,@groupby,@distinct,@count,property_msection_id
15:49:40.363559	profile	application	begin:Sphinx index catalog,catalog_morph,marketplace
15:49:40.520401	profile	application	begin:Sphinx search. total_found: 1392; time: 0.095
15:49:40.521111	trace	system.CModule	Loading "GoodSections" application component
15:49:40.521217	trace	system.CModule	Loading "fcache" application component
15:49:40.532736	trace	system.caching.CFileCache	Serving "good_sections_tree5" from cache
15:49:40.533004	trace	system.caching.CMemCache	Serving "yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:b_iblock_section" from cache
15:49:40.539386	trace	system.CModule	Loading "dbTecDoc" application component
15:49:40.539411	trace	system.db.CDbConnection	Opening DB connection
15:49:40.540293	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:49:40.540853	trace	system.CModule	Loading "dbTecDoc2" application component
15:49:40.540868	trace	system.db.CDbConnection	Opening DB connection
15:49:40.541834	trace	system.db.CDbCommand	Querying SQL: call get_brandfilter_by_art_no_link_v7_1('204', 49, 66, 1, 66)
15:49:40.768151	trace	system.CModule	Loading "goodTpl" application component
15:49:40.769124	trace	system.CModule	Loading "microdataManager" application component
15:49:40.769861	trace	system.CModule	Loading "widgetFactory" application component
15:49:40.782550	trace	system.CModule	Loading "yandexEcom" application component
15:49:40.797215	trace	system.CModule	Loading "coreMessages" application component
15:49:40.898705	trace	system.CModule	Loading "GoodPropDesc" application component
15:49:40.899023	trace	system.caching.CFileCache	Serving "iblock_properties_desc" from cache
15:49:40.899784	trace	system.caching.CMemCache	Serving "iblock_properties_0getPropIssetValuesByCodes1Goodaf69e938ad2b85713393339417f9edb9" from cache
15:49:40.902631	trace	system.caching.CMemCache	Serving "MpAttrsHelpergetAttrIssetValuesByCodesd41d8cd98f00b204e9800998ecf8427e66af69e938ad2b85713393339417f9edb9" from cache
15:49:40.902791	trace	system.caching.CMemCache	Serving "MpAttrsHelpergetAttrIssetForOurGoodsValuesByCodesd41d8cd98f00b204e9800998ecf8427e66af69e938ad2b85713393339417f9edb9" from cache
15:49:40.907509	trace	system.caching.CMemCache	Serving "iblock_properties_0getPropIssetValuesByCoded41d8cd98f00b204e9800998ecf8427eGoodPROPERTY_MAKER_LISTe71c3cff221dbf201e3205d1ae09bc17dcca48101505dd86b703689a604fe3c4" from cache
15:49:40.909115	trace	system.caching.CMemCache	Serving "iblock_properties_0getPropIssetValuesByCoded41d8cd98f00b204e9800998ecf8427eGoodPROPERTY_CATGROUPe71c3cff221dbf201e3205d1ae09bc17dcca48101505dd86b703689a604fe3c4" from cache
15:49:40.914444	trace	system.caching.CRedisCache	Serving "sberid_AA\Service\OAuth\Clients\SberIdClient_sberid_authState" from cache
15:49:40.914717	trace	system.caching.CRedisCache	Serving "sberid_AA\Service\OAuth\Clients\SberIdClient_sberid_authState" from cache
15:49:40.917505	trace	system.db.ar.CActiveRecord	CartUser.find()
15:49:40.917561	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `b_sale_fuser` `t` WHERE USER_ID=:USER_ID LIMIT 1
15:49:40.917566	profile	system.db.CDbCommand.query	begin:system.db.CDbCommand.query(SELECT * FROM `b_sale_fuser` `t` WHERE USER_ID=:USER_ID LIMIT 1)
15:49:40.917814	profile	system.db.CDbCommand.query	end:system.db.CDbCommand.query(SELECT * FROM `b_sale_fuser` `t` WHERE USER_ID=:USER_ID LIMIT 1)
15:49:40.917941	trace	system.db.ar.CActiveRecord	CartUser.find()
15:49:40.917974	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `b_sale_fuser` `t` WHERE USER_ID=:USER_ID LIMIT 1
15:49:40.917977	profile	system.db.CDbCommand.query	begin:system.db.CDbCommand.query(SELECT * FROM `b_sale_fuser` `t` WHERE USER_ID=:USER_ID LIMIT 1)
15:49:40.918179	profile	system.db.CDbCommand.query	end:system.db.CDbCommand.query(SELECT * FROM `b_sale_fuser` `t` WHERE USER_ID=:USER_ID LIMIT 1)
15:49:40.918186	trace	system.db.ar.CActiveRecord	Cart.count()
15:49:40.918406	trace	system.caching.CMemCache	Serving "yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:b_sale_basket" from cache
15:49:40.918482	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:49:40.918484	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:49:40.918673	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:49:40.921225	trace	system.caching.CMemCache	Serving "CB:name:top_header_menu_delivery_desktop" from cache
15:49:40.922472	trace	system.caching.CMemCache	Serving "CB:name:top_alert_desktop" from cache
15:49:40.924336	trace	system.db.ar.CActiveRecord	CartUser.find()
15:49:40.924376	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `b_sale_fuser` `t` WHERE USER_ID=:USER_ID LIMIT 1
15:49:40.924381	profile	system.db.CDbCommand.query	begin:system.db.CDbCommand.query(SELECT * FROM `b_sale_fuser` `t` WHERE USER_ID=:USER_ID LIMIT 1)
15:49:40.924576	profile	system.db.CDbCommand.query	end:system.db.CDbCommand.query(SELECT * FROM `b_sale_fuser` `t` WHERE USER_ID=:USER_ID LIMIT 1)
15:49:40.924618	trace	system.db.ar.CActiveRecord	CartUser.find()
15:49:40.924650	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `b_sale_fuser` `t` WHERE USER_ID=:USER_ID LIMIT 1
15:49:40.924654	profile	system.db.CDbCommand.query	begin:system.db.CDbCommand.query(SELECT * FROM `b_sale_fuser` `t` WHERE USER_ID=:USER_ID LIMIT 1)
15:49:40.924851	profile	system.db.CDbCommand.query	end:system.db.CDbCommand.query(SELECT * FROM `b_sale_fuser` `t` WHERE USER_ID=:USER_ID LIMIT 1)
15:49:40.924860	trace	system.db.ar.CActiveRecord	Cart.count()
15:49:40.924922	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:49:40.924926	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:49:40.925126	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:49:40.929142	trace	system.caching.CMemCache	Serving "CB:name:bottom_job_desktop" from cache
15:49:40.929728	trace	system.caching.CMemCache	Serving "CB:name:partners_desktop" from cache
15:49:40.930361	trace	system.caching.CMemCache	Serving "CB:name:bottom_for_buyer_desktop" from cache
15:49:40.930907	trace	system.CModule	Loading "territory" application component
15:49:40.935816	trace	system.caching.CMemCache	Serving "ITerritory3" from cache
15:49:40.939277	trace	system.caching.CMemCache	Serving "iblock_properties_0getPropValues1045" from cache
15:49:40.944969	trace	system.caching.CMemCache	Serving "CB:name:bottom_copy_text_desktop" from cache

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

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