Результаты поиска по запросу 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.88440с, Память: 21,631Кб)
Процедура	Номер	Всего (с)	Средн. (с)	Мин. (с)	Макс. (с)
Sphinx select id,@groupby,@distinct,@count,property_msection_id	1	0.59067	0.59067	0.59067	0.59067
Sphinx search. total_found: 8868; time: 0.080	1	0.67072	0.67072	0.67072	0.67072
Sphinx search. total_found: 1392; time: 0.095	1	0.43838	0.43838	0.43838	0.43838
Sphinx index catalog,catalog_morph,marketplace	2	1.34702	0.67351	0.59066	0.75636
system.db.CDbCommand.query(SELECT * FROM `sp_delivery_calc_main` `t` WHERE t.location_id = :location_id LIMIT 1)	1	0.00238	0.00238	0.00238	0.00238
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.00153	0.00153	0.00153	0.00153
system.db.CDbCommand.query(SELECT * FROM `b_sale_fuser` `t` WHERE USER_ID=:USER_ID LIMIT 1)	5	0.00127	0.00025	0.00019	0.00035
loading session	2	0.00100	0.00050	0.00001	0.00099
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.00064	0.00032	0.00032	0.00032
system.db.CDbCommand.execute(DELETE FROM `YiiLog` WHERE 0=1)	1	0.00061	0.00061	0.00061	0.00061
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.00042	0.00042	0.00042	0.00042
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.00018
system.db.CDbCommand.execute(SET SESSION TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;)	1	0.00034	0.00034	0.00034	0.00034

Журнал приложения
Время	Уровень	Категория	Сообщение
15:02:21.208867	trace	system.CModule	Loading "log" application component
15:02:21.212649	trace	glitchtip_fallback	The "Sentry\Integration\RequestIntegration, Sentry\Integration\TransactionIntegration, Sentry\Integration\FrameContextifierIntegration, Sentry\Integration\EnvironmentIntegration" integration(s) have been installed.
15:02:21.213249	trace	system.CModule	Loading "db" application component
15:02:21.213670	trace	system.db.CDbConnection	Opening DB connection
15:02:21.215003	trace	system.db.CDbCommand	Executing SQL: DELETE FROM `YiiLog` WHERE 0=1
15:02:21.215008	profile	system.db.CDbCommand.execute	begin:system.db.CDbCommand.execute(DELETE FROM `YiiLog` WHERE 0=1)
15:02:21.215617	profile	system.db.CDbCommand.execute	end:system.db.CDbCommand.execute(DELETE FROM `YiiLog` WHERE 0=1)
15:02:21.215759	trace	system.CModule	Loading "urlHelper" application component
15:02:21.216516	trace	system.CModule	Loading "DBConfig" application component
15:02:21.216888	trace	system.CModule	Loading "cache" application component
15:02:21.218156	trace	system.caching.CMemCache	Serving "66307959e0460a2e2436b0319b2fda14" from cache
15:02:21.218427	trace	system.CModule	Loading "geo" application component
15:02:21.219181	trace	system.CModule	Loading "request" application component
15:02:21.220909	trace	system.CModule	Loading "user" application component
15:02:21.221330	profile	application	begin:loading session
15:02:21.221334	trace	system.CModule	Loading "session" application component
15:02:21.222321	profile	application	end:loading session
15:02:21.224807	trace	system.CModule	Loading "B2BConfig" application component
15:02:21.225205	trace	system.CModule	Loading "urlManager" application component
15:02:21.226578	trace	system.caching.CMemCache	Serving "Yii.CUrlManager.rules" from cache
15:02:21.228228	trace	system.CModule	Loading "themeInterlayer" application component
15:02:21.230716	trace	system.CModule	Loading "themeManager" application component
15:02:21.231561	trace	system.CModule	Loading "clientScript" application component
15:02:21.235368	trace	system.web.filters.CFilterChain	Running filter DBReadUncomitedLevelFilter.filter()
15:02:21.235387	trace	system.db.CDbCommand	Executing SQL: SET SESSION TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
15:02:21.235389	profile	system.db.CDbCommand.execute	begin:system.db.CDbCommand.execute(SET SESSION TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;)
15:02:21.235733	profile	system.db.CDbCommand.execute	end:system.db.CDbCommand.execute(SET SESSION TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;)
15:02:21.235780	trace	system.CModule	Loading "cart" application component
15:02:21.236500	trace	system.db.ar.CActiveRecord	CartUser.find()
15:02:21.237011	trace	system.caching.CMemCache	Serving "yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:b_sale_fuser" from cache
15:02:21.237082	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `b_sale_fuser` `t` WHERE USER_ID=:USER_ID LIMIT 1
15:02:21.237087	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:21.237344	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:21.237576	trace	system.CModule	Loading "coupon" application component
15:02:21.238194	trace	system.CModule	Loading "assetManager" application component
15:02:21.238915	trace	system.db.ar.CActiveRecord	DeliveryCalcMain.find()
15:02:21.239094	trace	system.caching.CMemCache	Serving "yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:sp_delivery_calc_main" from cache
15:02:21.239128	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `sp_delivery_calc_main` `t` WHERE t.location_id = :location_id LIMIT 1
15:02:21.239130	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:21.241512	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:21.243498	trace	system.CModule	Loading "redisCache" application component
15:02:21.244565	trace	system.caching.CRedisCache	Serving "sberid_AA\Service\OAuth\Clients\SberIdClient_sberid_authState" from cache
15:02:21.244951	trace	system.caching.CRedisCache	Serving "sberid_AA\Service\OAuth\Clients\SberIdClient_sberid_authState" from cache
15:02:21.245368	profile	application	begin:loading session
15:02:21.245381	profile	application	end:loading session
15:02:21.247956	trace	system.CModule	Loading "order" application component
15:02:21.251636	trace	system.CModule	Loading "IPropeties" application component
15:02:21.255531	trace	system.caching.CMemCache	Serving "iblock_properties_0" from cache
15:02:21.256158	trace	system.caching.CMemCache	Serving "iblock_properties_0getPropValues1408" from cache
15:02:21.256999	trace	system.caching.CMemCache	Serving "IWarehouseIWarehouse::getStaticList" from cache
15:02:21.257265	trace	system.db.ar.CActiveRecord	TPSupToTer.findAll()
15:02:21.257271	trace	system.CModule	Loading "dbTP" application component
15:02:21.257292	trace	system.db.CDbConnection	Opening DB connection
15:02:21.258651	trace	system.caching.CMemCache	Serving "yii:dbschemamysql:host=192.168.0.1;dbname=tp:alliance-auto:{{sup_to_ter}}" from cache
15:02:21.259067	trace	system.caching.CMemCache	Serving "yii:dbschemamysql:host=192.168.0.1;dbname=tp:alliance-auto:{{supplier_delivery_settings}}" from cache
15:02:21.259259	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:21.287918	trace	system.CModule	Loading "ICatalog" application component
15:02:21.288548	trace	system.caching.CMemCache	Serving "b_catalog_group1" from cache
15:02:21.290848	trace	system.caching.CMemCache	Serving "yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:b_iblock_element" from cache
15:02:21.291245	trace	system.db.ar.CActiveRecord	TPSupToTer.findAll()
15:02:21.291493	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:21.330338	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:21.330346	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:21.330761	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:21.330976	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:21.330981	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:21.331300	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:21.331585	profile	application	begin:Sphinx index catalog,catalog_morph,marketplace
15:02:21.417228	profile	application	begin:Sphinx search. total_found: 8868; time: 0.080
15:02:21.417615	trace	system.caching.CMemCache	Serving "yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:mp_goods" from cache
15:02:21.417702	trace	system.db.ar.CActiveRecord	MpGood.findAll()
15:02:21.417812	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:21.417814	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:21.419348	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:21.420120	trace	system.db.ar.CActiveRecord	TPSupToTer.findAll()
15:02:21.420377	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:21.461510	trace	system.caching.CMemCache	Serving "yii:dbschemamysql:host=192.168.0.1;dbname=tp:alliance-auto:{{allprices}}" from cache
15:02:21.461555	trace	system.db.ar.CActiveRecord	TPAllPrices.findAll()
15:02:21.462111	trace	system.caching.CMemCache	Serving "yii:dbschemamysql:host=192.168.0.1;dbname=tp:alliance-auto:{{supplier}}" from cache
15:02:21.462505	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:21.465960	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:21.465965	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:21.466281	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:21.466481	trace	system.db.ar.CActiveRecord	TPSupToTer.findAll()
15:02:21.466721	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:21.497277	profile	application	begin:Sphinx select id,@groupby,@distinct,@count,property_msection_id
15:02:21.497283	profile	application	begin:Sphinx index catalog,catalog_morph,marketplace
15:02:21.649568	profile	application	begin:Sphinx search. total_found: 1392; time: 0.095
15:02:21.650333	trace	system.CModule	Loading "GoodSections" application component
15:02:21.650898	trace	system.CModule	Loading "fcache" application component
15:02:21.662909	trace	system.caching.CFileCache	Serving "good_sections_tree5" from cache
15:02:21.663285	trace	system.caching.CMemCache	Serving "yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:b_iblock_section" from cache
15:02:21.671340	trace	system.CModule	Loading "dbTecDoc" application component
15:02:21.671371	trace	system.db.CDbConnection	Opening DB connection
15:02:21.672278	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:21.673022	trace	system.CModule	Loading "dbTecDoc2" application component
15:02:21.673038	trace	system.db.CDbConnection	Opening DB connection
15:02:21.676425	trace	system.db.CDbCommand	Querying SQL: call get_brandfilter_by_art_no_link_v7_1('204', 49, 66, 1, 66)
15:02:21.896367	trace	system.CModule	Loading "goodTpl" application component
15:02:21.897176	trace	system.CModule	Loading "microdataManager" application component
15:02:21.897806	trace	system.CModule	Loading "widgetFactory" application component
15:02:21.911951	trace	system.CModule	Loading "yandexEcom" application component
15:02:21.924897	trace	system.CModule	Loading "coreMessages" application component
15:02:22.027515	trace	system.CModule	Loading "GoodPropDesc" application component
15:02:22.028074	trace	system.caching.CFileCache	Serving "iblock_properties_desc" from cache
15:02:22.028928	trace	system.caching.CMemCache	Serving "iblock_properties_0getPropIssetValuesByCodes1Goodaf69e938ad2b85713393339417f9edb9" from cache
15:02:22.029263	trace	system.caching.CMemCache	Serving "MpAttrsHelpergetAttrIssetValuesByCodesd41d8cd98f00b204e9800998ecf8427e66af69e938ad2b85713393339417f9edb9" from cache
15:02:22.029409	trace	system.caching.CMemCache	Serving "MpAttrsHelpergetAttrIssetForOurGoodsValuesByCodesd41d8cd98f00b204e9800998ecf8427e66af69e938ad2b85713393339417f9edb9" from cache
15:02:22.033721	trace	system.caching.CMemCache	Serving "iblock_properties_0getPropIssetValuesByCoded41d8cd98f00b204e9800998ecf8427eGoodPROPERTY_MAKER_LISTe71c3cff221dbf201e3205d1ae09bc17dcca48101505dd86b703689a604fe3c4" from cache
15:02:22.035093	trace	system.caching.CMemCache	Serving "iblock_properties_0getPropIssetValuesByCoded41d8cd98f00b204e9800998ecf8427eGoodPROPERTY_CATGROUPe71c3cff221dbf201e3205d1ae09bc17dcca48101505dd86b703689a604fe3c4" from cache
15:02:22.040076	trace	system.caching.CRedisCache	Serving "sberid_AA\Service\OAuth\Clients\SberIdClient_sberid_authState" from cache
15:02:22.040386	trace	system.caching.CRedisCache	Serving "sberid_AA\Service\OAuth\Clients\SberIdClient_sberid_authState" from cache
15:02:22.042939	trace	system.db.ar.CActiveRecord	CartUser.find()
15:02:22.043004	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `b_sale_fuser` `t` WHERE USER_ID=:USER_ID LIMIT 1
15:02:22.043009	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:22.043358	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:22.043484	trace	system.db.ar.CActiveRecord	CartUser.find()
15:02:22.043519	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `b_sale_fuser` `t` WHERE USER_ID=:USER_ID LIMIT 1
15:02:22.043521	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:22.043757	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:22.043766	trace	system.db.ar.CActiveRecord	Cart.count()
15:02:22.044023	trace	system.caching.CMemCache	Serving "yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:b_sale_basket" from cache
15:02:22.044106	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:22.044110	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:22.044287	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:22.046708	trace	system.caching.CMemCache	Serving "CB:name:top_header_menu_delivery_desktop" from cache
15:02:22.048074	trace	system.caching.CMemCache	Serving "CB:name:top_alert_desktop" from cache
15:02:22.050044	trace	system.db.ar.CActiveRecord	CartUser.find()
15:02:22.050105	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `b_sale_fuser` `t` WHERE USER_ID=:USER_ID LIMIT 1
15:02:22.050108	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:22.050344	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:22.050389	trace	system.db.ar.CActiveRecord	CartUser.find()
15:02:22.050420	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `b_sale_fuser` `t` WHERE USER_ID=:USER_ID LIMIT 1
15:02:22.050422	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:22.050614	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:22.050621	trace	system.db.ar.CActiveRecord	Cart.count()
15:02:22.050676	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:22.050678	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:22.050862	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:22.054186	trace	system.caching.CMemCache	Serving "CB:name:bottom_job_desktop" from cache
15:02:22.054682	trace	system.caching.CMemCache	Serving "CB:name:partners_desktop" from cache
15:02:22.055234	trace	system.caching.CMemCache	Serving "CB:name:bottom_for_buyer_desktop" from cache
15:02:22.055711	trace	system.CModule	Loading "territory" application component
15:02:22.060010	trace	system.caching.CMemCache	Serving "ITerritory3" from cache
15:02:22.063620	trace	system.caching.CMemCache	Serving "iblock_properties_0getPropValues1045" from cache
15:02:22.069235	trace	system.caching.CMemCache	Serving "CB:name:bottom_copy_text_desktop" from cache

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

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