Опт Установочные центры Гарантия / Возврат Доставка и оплата Контакты

Личный кабинет
- Авторизация
- Регистрация

Работаем с 2012 года

8 (800) 700-26-44 +7 (977) 809-33-59 +7 (495) 220-33-59 Без выходных: 09:00-20:00

+7 (977) 809-33-59 +7 (495) 220-33-59

Спросите у нас:

Наши обзоры:

8 (800) 700-26-44 +7 (977) 809-33-59 +7 (495) 220-33-59

Подобрать магнитолу Обратный звонок Запись на установку

Каталог товаров

Штатные магнитолы

Видеорегистраторы

Камеры заднего вида

Камеры переднего вида

Камеры для коммерческого транспорта

Круговой обзор

Автомониторы

Противоугонное оборудование

Переходные рамки

Автозвук

Аксессуары

Услуги

8 (800) 700-26-44

Камера заднего вида INCAR VDC-413 для CITROEN JUMPER III, Fiat Ducato X250, PEUGEOT Boxer III (В СТОП-СИГНАЛ)

Артикул: 37663

В закладки

В сравнение

7 000 р.

Нашли аналог дешевле?

Количество

Из категории Камеры для коммерческого транспорта

Камера на крышу cam-127 Mercedes-Benz Sprinter, Viano, Vito / VW Crafter, Transporter / Газел / Ford Transit

Камера заднего вида INCAR VDC-413 для CITROEN JUMPER III, Fiat Ducato X250, PEUGEOT Boxer III (В СТОП-СИГНАЛ)

Встроенная камера cam-177 для Mercedes Sprinter, Viano, Vito / Volkswagen Crafter, Transporter / Газел для установки на крышу (AHD 1080p, 170 градусов)

Штатная камера заднего вида SWAT VDC-419 для Opel Vivaro B (2014+), Renault Trafic X82 (2014+) в стоп-сигнал

Встроенная камера в стоп-сигнал cam-178 для Citroen SpaceTourer, Jumpy III / Peugeot Traveller, Expert / Opel Zafira Life, Vivaro C 2016-2021 (AHD 1080p, 170 градусов)

Встроенная камера в стоп-сигнал cam-175 для Ford Transit, Tourneo (2014+) (AHD 1080p, 170 градусов)

Встроенная камера в стоп-сигнал Incar VDC-423 для Citroen SpaceTourer I, Jumpy III, Peugeot Traveller, Expert, Opel Zafira Life, Vivaro C 2016-2022

Встроенная камера в стоп-сигнал cam-174 для Citroen Jumper III, Fiat Ducato X250, Peugeot Boxer III (AHD 1080p, 170 градусов)

Камера cam-132 Mercedes Sprinter / Volkswagen Crafter

Камера Incar VDC-422 для VW Caravelle,Transporter T5/T6 (для кузова с распашными дверьми) встроенная в стоп-сигнал

Встроенная камера в стоп-сигнал cam-172 для Mercedes Sprinter, Volkswagen Crafter (AHD 1080p, 170 градусов)

Встроенная камера в стоп-сигнал cam-176 для Opel Vivaro, Renault Trafic (2014+) (AHD 1080p, 170 градусов)

Встроенная камера в стоп-сигнал cam-173 для Volkswagen Caravelle, Transporter T5/T6 (для кузова с распашными дверьми) (AHD 1080p, 170 градусов)

Встроенная камера в стоп-сигнал cam-171 для Volkswagen Multivan, Caravelle T6 (AHD 1080p, 170 градусов)

Камера Incar VDC-412 для Mercedes Sprinter, Volkswagen Crafter

Доставка

Установка

12 Установочных центров

Выездная установка

Гарантия качества

ОПЛАТА ПОСЛЕ ПОЛУЧЕНИЯ Возврат в течение 14 дней!

Рейтинг магазина Frontcam.ru яндекс карты

Наш YouTube канал

Дата: 16.04.2024

Магнитола Canbox H-Line 4478 для Bmw 3 (E46) на ANDROID

Дата: 15.04.2024

Магнитола Canbox H-Line 3792 для Audi A4 (B7) на ANDROID

Дата: 14.04.2024

Магнитола Canbox H-Line 2K 4185 для Skoda Octavia 3 (A7) на ANDROID

Дата: 13.04.2024

Магнитола Canbox H-Line 2K 4183 для Nissan Murano 3 (Z52) на ANDROID

Дата: 13.04.2024

Магнитола Teyes CC3 для Haval H6 на ANDROID

Дата: 12.04.2024

Магнитола Canbox PRO-Line 2K 4251 для Dodge Grand Caravan 5 на ANDROID

Дата: 12.04.2024

Магнитола Canbox H-Line 2K 4184 для Chevrolet Tahoe 2 на ANDROID

Дата: 11.04.2024

Магнитола Canbox L-Line 4170 для Volkswagen Passat B6 на Android

Дата: 11.04.2024

Магнитола Canbox H-Line 7843 для Peugeot 308 на ANDROID

Дата: 10.04.2024

Магнитола Canbox L-Line 4170 для Mitsubishi ASX на ANDROID

Описание

Камера заднего вида для автомобилей Citroen Jumper III, Fiat Ducato X250 (устанавливается в стоп-сигнал).

Для большей безопасности во время движения задним ходом, оптимальный вариант - вывести "картинку", происходящего вне зоны видимости водителя на экран консоли (головного устройства, монитора). Подключив камеру заднего вида, вы получите желаемый результат. Качественная оптика, хорошее разрешение и шикарный обзор (170 градусов - видно практически все, что происходит позади автомобиля) это гарантия комфортного и безопасного управления автомобилем. Подключение камеры заднего вида к системе не требует специальных навыков (питание +/- и видеокабель), единственная сложность - грамотно проложить линейный кабель через салон автомобиля к приборной панели. Камера ставиться, как правило в штатное место не нарушая общей конструкции. Повышенная пыле и влагозащита гарантируют длительное использование системы, в течение всего срока эксплуатации транспортного средства (тем не менее не рекомендуется направлять на камеру струю воды под напором при мойке автомобиля). Высокая светочувствительность делает возможным пользоваться камерой в темноте.

Технические характеристики*

Сенсор	(1030) color CMOS
Разрешение	420 ТВ линий
Количество пикселей	648*488
Система	NTSC
Угол обзора	170 градусов
Минимальное освещение	0.5 LUX
Водонепроницаемость	IP66
Видео выход	1Vp-p,75Ohm, RCA male
Рабочее напряжение	12V DC
Рабочая температура	-30...+65 градусов
Парковочные линии	отключаемая разметка

Характеристики

Камеры заднего вида
Марка автомобиля	Citroen, Fiat

Задать вопрос Сообщить об ошибке

Отзывы

Отзывы клиентов о нас

Средняя оценка магазина

4,9

Всего оценок: 278

Юрий

Заказ быстро сформировали и отправили. Хорошая обратная связь...

Анатолий Торопенко

Установил на авто Хонда степвагон автомагнитолу Canbox H-Line 4195. Работой магазина и мастеров доволен. Все сделали быстро и качественно. Магнитола п..

Владимир

Сегодня был по записи на ремонт передней камеры(устанавливали и настраивали другие) Быстро нашли в чём проблемы: исправили и установили прогу для корр..

Дмитрий

Поменял в этом сервисе головное устройство на пассате Б6. Поставил Канбокс с крутилкой. Сервису ставлю 5-ку. Менеджеры помогли выбрать устройство, объ..

Евгений

Добрый день всем. Долго выбирал магнитолу так как Mitsubishi Grandis так сказать эксклюзивное авто, мало чего потходит. Предварительно созвонился с ме..

Смотреть другие оценки и отзывы

Купить магнитолу можно:

На сайте — наши опытные специалисты помогут Вам сделать выбор и предложат наиболее подходящие модели для Вашего автомобиля.
В нашем офлайн магазине. Возможность протестировать магнитолу на демо-стенде: отличный вариант для клиентов, которые хотят непосредственно поработать с магнитолой перед покупкой.
В установочном центре, оплата после принятия работы.
По Москве и Московской области — наш курьер оперативно доставит и примет оплату.
С доставкой по всей России — оплата за магнитолу при получении (после проверки содержимого).

Почему Frontcam:

Работаем более 10 лет (с 2012 года).
Основное направление компании — продажа, установка и дальнейшее обслуживание штатных магнитол на платформе Android.
У нас самый большой ассортимент штатных магнитол.
Есть собственная служба технической поддержки, благодаря которой помогаем клиентам после покупки.
Имея большой опыт, мы любим находить решения, даже для нестандартных автомобилей и сложных комплектаций.

Надежность

Более 12 лет на рынке автотоваров

Большой опыт

Продано более 35 000 автомагнитол

Оплата потом

Проверка и оплата товара после получения

Установка

12 Установочных центров и выездной мастер

Пользовательское соглашение

Created by frontcam.ru

Total time: 0.1039 s | Queries: 153 | Slow queries (>0.003 s): 0

#	Query time (s)	Controller	Query
1	0.0002		SELECT value FROM setting WHERE store_id = '0' AND `key`='config_seo_url_type'
2	0		SET SQL_BIG_SELECTS = 1
3	0.0003		SHOW TABLES LIKE 'ocfilter_setting'
4	0.0002		SELECT * FROM ocfilter_setting
5	0.0001	ControllerStartupStartup	SELECT * FROM store WHERE REPLACE(`ssl`, 'www.', '') = 'https://frontcam.ru/'
6	0.0003	ControllerEventCompatibility	SELECT f1.offname f1_name, f1.offname_gc f1_name_gc, f1.offname_pc f1_name_pc, f1.shortname f1_shortname, f1.fias_id f1_fias_id, f1.level f1_level, f1.postalcode f1_postalcode, f2.offname f2_name, f2.offname_gc f2_name_gc, f2.offname_pc f2_name_pc, f2.shortname f2_shortname, f2.fias_id f2_fias_id, f2.level f2_level, f3.offname f3_name, f3.offname_gc f3_name_gc, f3.offname_pc f3_name_pc, f3.shortname f3_shortname, f3.fias_id f3_fias_id, f3.level f3_level, f4.offname f4_name, f4.offname_gc f4_name_gc, f4.offname_pc f4_name_pc, f4.shortname f4_shortname, f4.fias_id f4_fias_id, f4.level f4_level, f4.parent_id f4_parent_id FROM fias f1 LEFT JOIN fias f2 ON f2.fias_id = f1.parent_id LEFT JOIN fias f3 ON f3.fias_id = f2.parent_id LEFT JOIN fias f4 ON f4.fias_id = f3.parent_id WHERE f1.offname = 'Сиэтл' AND ((f2.offname = 'США' AND f2.level = 0) OR (f3.offname = 'США' AND f3.level = 0) OR (f4.offname = 'США' AND f4.level = 0)) AND ((f1.offname = 'Вашингтон' AND f1.level = 1) OR (f2.offname = 'Вашингтон' AND f2.level = 1) OR (f3.offname = 'Вашингтон' AND f3.level = 1) OR (f4.offname = 'Вашингтон' AND f4.level = 1)) AND f1.level IN (1, 4, 6) ORDER BY f1_level
7	0.0002	ControllerEventCompatibility	SELECT f1.offname f1_name, f1.offname_gc f1_name_gc, f1.offname_pc f1_name_pc, f1.shortname f1_shortname, f1.fias_id f1_fias_id, f1.level f1_level, f1.postalcode f1_postalcode, f2.offname f2_name, f2.offname_gc f2_name_gc, f2.offname_pc f2_name_pc, f2.shortname f2_shortname, f2.fias_id f2_fias_id, f2.level f2_level, f3.offname f3_name, f3.offname_gc f3_name_gc, f3.offname_pc f3_name_pc, f3.shortname f3_shortname, f3.fias_id f3_fias_id, f3.level f3_level, f4.offname f4_name, f4.offname_gc f4_name_gc, f4.offname_pc f4_name_pc, f4.shortname f4_shortname, f4.fias_id f4_fias_id, f4.level f4_level, f4.parent_id f4_parent_id FROM fias f1 LEFT JOIN fias f2 ON f2.fias_id = f1.parent_id LEFT JOIN fias f3 ON f3.fias_id = f2.parent_id LEFT JOIN fias f4 ON f4.fias_id = f3.parent_id WHERE f1.offname = 'Сиэтл' AND ((f2.offname = 'США' AND f2.level = 0) OR (f3.offname = 'США' AND f3.level = 0) OR (f4.offname = 'США' AND f4.level = 0)) AND f1.level IN (1, 4, 6) ORDER BY f1_level
8	0.0001	ControllerEventCompatibility	SELECT * FROM country c WHERE c.iso_code_2 = 'US'
9	0.0001	ControllerEventCompatibility	SELECT * FROM prmn_cm_redirect
10	0.0001	ControllerEventCompatibility	SELECT f1.offname f1_name, f1.offname_gc f1_name_gc, f1.offname_pc f1_name_pc, f1.shortname f1_shortname, f1.fias_id f1_fias_id, f1.level f1_level, f1.postalcode f1_postalcode, f2.offname f2_name, f2.offname_gc f2_name_gc, f2.offname_pc f2_name_pc, f2.shortname f2_shortname, f2.fias_id f2_fias_id, f2.level f2_level, f3.offname f3_name, f3.offname_gc f3_name_gc, f3.offname_pc f3_name_pc, f3.shortname f3_shortname, f3.fias_id f3_fias_id, f3.level f3_level, f4.offname f4_name, f4.offname_gc f4_name_gc, f4.offname_pc f4_name_pc, f4.shortname f4_shortname, f4.fias_id f4_fias_id, f4.level f4_level, f4.parent_id f4_parent_id FROM fias f1 LEFT JOIN fias f2 ON f2.fias_id = f1.parent_id LEFT JOIN fias f3 ON f3.fias_id = f2.parent_id LEFT JOIN fias f4 ON f4.fias_id = f3.parent_id WHERE f1.fias_id = 41
11	0.0001	ControllerEventCompatibility	SELECT * FROM prmn_cm_customer_group WHERE fias_id IN (41,41,1)
12	0.0001	ControllerEventCompatibility	SELECT * FROM currency
13	0.0001	ControllerEventCompatibility	SELECT * FROM weight_class wc LEFT JOIN weight_class_description wcd ON (wc.weight_class_id = wcd.weight_class_id) WHERE wcd.language_id = '1'
14	0.0001	ControllerEventCompatibility	SELECT * FROM length_class mc LEFT JOIN length_class_description mcd ON (mc.length_class_id = mcd.length_class_id) WHERE mcd.language_id = '1'
15	0.0001	ControllerEventCompatibility	DELETE FROM cart WHERE date_added < DATE_SUB(NOW(), INTERVAL '30' DAY)
16	0.0002	ControllerEventCompatibility	SHOW TABLES LIKE 'cartkeeper'
17	0.0002	ControllerEventCompatibility	SHOW TABLES LIKE 'cartkeeper_share'
18	0.0001	ControllerEventCompatibility	DELETE FROM cartkeeper WHERE date_added < DATE_SUB(NOW(), INTERVAL '30' DAY)
19	0.0001	ControllerEventCompatibility	DELETE FROM cartkeeper_share WHERE customer_id = '0' AND date_added < DATE_SUB(NOW(), INTERVAL '3' DAY)
20	0.0001	ControllerEventCompatibility	DELETE FROM cartkeeper_share WHERE customer_id != '0' AND date_added < DATE_SUB(NOW(), INTERVAL '14' DAY)
21	0.0001	ControllerEventCompatibility	SELECT `session_id` FROM `cart` WHERE `session_id` = '61f7012faee037208d6c3b76f2f2def0' LIMIT 1
22	0.0001	ControllerStartupEvent	SELECT * FROM `event` WHERE `trigger` LIKE 'catalog/%' AND status = '1' ORDER BY `event_id` ASC
23	0.0001	ControllerEventCompatibility	SELECT c.* FROM prmn_cm_city c ORDER BY sort, name
24	0.0001	ControllerStartupSeoPro	SELECT query FROM url_alias WHERE keyword = 'kamery-dlja-kommercheskogo-transporta' LIMIT 1
25	0.0001	ControllerStartupSeoPro	SELECT query FROM url_alias WHERE keyword = 'kamera-zadnego-vida-incar-vdc-413-dlya-citroen-jumper-iii-v-stop-signal' LIMIT 1
26	0.0001	ControllerStartupSeoPro	SELECT query FROM url_alias WHERE keyword = 'kamery-dlja-kommercheskogo-transporta/kamera-zadnego-vida-incar-vdc-413-dlya-citroen-jumper-iii-v-stop-signal' LIMIT 1
27	0.0001	ControllerStartupSeoPro	SELECT category_id FROM product_to_category WHERE product_id = '45358' ORDER BY main_category DESC LIMIT 1
28	0.0001	ControllerStartupSeoPro	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=1499' LIMIT 1
29	0.0001	ControllerStartupSeoPro	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'product_id=45358' LIMIT 1
30	0.0001	ControllerProductProduct	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'common/home' LIMIT 1
31	0.0001	ControllerProductProduct	SELECT DISTINCT * FROM category c LEFT JOIN category_description cd ON (c.category_id = cd.category_id) WHERE c.category_id = '1499' AND cd.language_id = '1' AND c.status = '1'
32	0.0001	ControllerProductProduct	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=1499' LIMIT 1
33	0.0001	ControllerProductProduct	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'common/home' LIMIT 1
34	0.0001	ControllerProductProduct	SELECT MAX(category_id) as category_id FROM product_to_category WHERE product_id =45358
35	0	ControllerProductProduct	SELECT parent_id FROM category WHERE category_id =1499
36	0.0001	ControllerProductProduct	SELECT DISTINCT * FROM category c LEFT JOIN category_description cd ON (c.category_id = cd.category_id) WHERE c.category_id = '1499' AND cd.language_id = '1' AND c.status = '1'
37	0.0001	ControllerProductProduct	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=1499' LIMIT 1
38	0.0001	ControllerProductProduct	SELECT * FROM product_to_layout WHERE product_id = '45358' AND store_id = '0'
39	0.0001	ControllerProductProduct	SELECT * FROM layout_route WHERE 'product/product' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1
40	0.0001	ControllerProductProduct	SELECT * FROM layout_module WHERE layout_id = '2' AND `code` = 'ocfilter'
41	0	ControllerProductProduct	SELECT * FROM ocfilter_setting WHERE `key` = 'placement_layout'
42	0.0005	ControllerProductProduct	SELECT DISTINCT , pd.name AS name, p.image, p.market_output, m.name AS manufacturer, (SELECT p2.quantity from product p2 where p.id_baza = p2.product_id) as quantity_baza, (SELECT p2.quantity from product p2 where p.id_ramka = p2.product_id) as quantity_ramka, (SELECT pnl.quantity from product_new_location pnl where p.product_id = pnl.product_id and pnl.location_id = '1') as spb_quantity, (SELECT pnl.quantity from product_new_location pnl where p.id_baza = pnl.product_id and pnl.location_id = '1') as spb_quantity_baza, (SELECT pnl.quantity from product_new_location pnl where p.id_ramka = pnl.product_id and pnl.location_id = '1') as spb_quantity_ramka, (SELECT pa.text from product_attribute pa where p.product_id = pa.product_id and pa.attribute_id = '66') as processor, (SELECT AVG(rating) AS total FROM review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT() AS total FROM review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, (SELECT price FROM product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, p.sort_order FROM product p LEFT JOIN product_description pd ON (p.product_id = pd.product_id) LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '45358' AND p.status = '1'
43	0.0001	ControllerProductProduct	SELECT p2c.product_id, p2c.category_id, p2c.main_category FROM product_to_category p2c LEFT JOIN category_description cd ON (p2c.category_id = cd.category_id) WHERE product_id = '45358' /ORDER BY cd.name ASC/ ORDER BY p2c.category_id ASC
44	0.0001	ControllerProductProduct	SELECT DISTINCT * FROM category c LEFT JOIN category_description cd ON (c.category_id = cd.category_id) WHERE c.category_id = '1499' AND cd.language_id = '1' AND c.status = '1'
45	0.0001	ControllerProductProduct	SELECT category_id FROM product_to_category WHERE product_id = '45358' ORDER BY main_category DESC LIMIT 1
46	0.0001	ControllerProductProduct	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=1499' LIMIT 1
47	0.0001	ControllerProductProduct	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'product_id=45358' LIMIT 1
48	0.0001	ControllerEventCompatibility	SELECT c.* FROM prmn_cm_city c ORDER BY sort, name
49	0.0001	ControllerEventCompatibility	SELECT category_id FROM product_to_category WHERE product_id = '45358' ORDER BY main_category DESC LIMIT 1
50	0.0001	ControllerEventCompatibility	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=1499' LIMIT 1
51	0.0001	ControllerEventCompatibility	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'product_id=45358' LIMIT 1
52	0.0001	ControllerEventCompatibility	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'account/login' LIMIT 1
53	0.0001	ControllerEventCompatibility	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'revolution/account/revregister' LIMIT 1
54	0.0002	ControllerEventCompatibility	SELECT r.review_id, r.author, r.rating, r.likes, r.dislikes, r.text, r.admin_reply, r.admin_name, r.plus, r.minus, r.purchased, r.videos, p.product_id, pd.name, p.price, p.image, r.date_added FROM review r LEFT JOIN product p ON (r.product_id = p.product_id) LEFT JOIN product_description pd ON (p.product_id = pd.product_id) WHERE p.product_id = '45358' AND p.date_available <= NOW() AND p.status = '1' AND r.status = '1' AND pd.language_id = '1' ORDER BY r.rating DESC LIMIT 0,10
55	0.0001	ControllerEventCompatibility	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'manufacturer_id=70' LIMIT 1
56	0.0001	ControllerEventCompatibility	SELECT * FROM product_image WHERE product_id IN (45358) ORDER BY product_id, sort_order ASC
57	0.0001	ControllerEventCompatibility	SELECT * FROM product_discount WHERE product_id = '45358' AND customer_group_id = '1' AND quantity > 1 AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY quantity ASC, priority ASC, price ASC
58	0.0003	ControllerEventCompatibility	SELECT * FROM product_option po LEFT JOIN `option` o ON (po.option_id = o.option_id) LEFT JOIN option_description od ON (o.option_id = od.option_id) WHERE po.product_id = '45358' AND od.language_id = '1' ORDER BY o.sort_order
59	0.0001	ControllerEventCompatibility	SELECT category_id FROM product_to_category WHERE product_id = '45358' ORDER BY main_category DESC LIMIT 1
60	0.0001	ControllerEventCompatibility	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=1499' LIMIT 1
61	0.0001	ControllerEventCompatibility	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'product_id=45358' LIMIT 1
62	0.0003	ControllerEventCompatibility	SELECT ag.attribute_group_id, agd.name, agd.tooltip FROM product_attribute pa LEFT JOIN attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id) LEFT JOIN attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id) WHERE pa.product_id = '45358' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
63	0.0003	ControllerEventCompatibility	SELECT a.attribute_id, ad.name, ad.tooltip, pa.text FROM product_attribute pa LEFT JOIN attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN attribute_description ad ON (a.attribute_id = ad.attribute_id) WHERE pa.product_id = '45358' AND a.attribute_group_id = '11' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
64	0.0002	ControllerEventCompatibility	SELECT pr., p.product_id FROM product_related pr LEFT JOIN product p ON (pr.related_id = p.product_id) /LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id) / WHERE pr.product_id = '45358' AND p.status = '1' AND p.catalog_output = '1' AND p.date_available <= NOW() /AND p2s.store_id = '0' */ ORDER BY p.sort_order LIMIT 30
65	0.0001	ControllerEventCompatibility	SELECT pr., p.product_id FROM product_related pr LEFT JOIN product p ON (pr.related_id = p.product_id) /LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id) / WHERE pr.product_id = '45358' AND p.status = '1' AND p.catalog_output = '1' AND p.date_available <= NOW() /AND p2s.store_id = '0' */ ORDER BY p.sort_order LIMIT 30
66	0.0002	ControllerEventCompatibility	SELECT * FROM tabs t LEFT JOIN tabs_description td ON(t.tab_id = td.tab_id) WHERE t.status = 1 AND td.language_id = '1' AND t.stores LIKE '%0%' ORDER BY t.sort_order ASC
67	0.0001	ControllerEventCompatibility	SELECT manufacturer_id FROM product WHERE product_id = '45358'
68	0.0002	ControllerEventCompatibility	SELECT * FROM product_tab pt LEFT JOIN product_tab_desc ptd ON(pt.product_tab_id = ptd.product_tab_id) WHERE pt.product_id = '45358' AND ptd.language_id = '1' AND pt.status = 1 ORDER BY sort_order ASC
69	0.0001	ControllerEventCompatibility	SELECT rd.* FROM product_recurring pr JOIN recurring_description rd ON (rd.language_id = 1 AND rd.recurring_id = pr.recurring_id) JOIN recurring r ON r.recurring_id = rd.recurring_id WHERE pr.product_id = 45358 AND status = '1' AND pr.customer_group_id = '1' ORDER BY sort_order ASC
70	0.0001	ControllerEventCompatibility	UPDATE product SET viewed = (viewed + 1) WHERE product_id = '45358'
71	0.0001	ControllerEventCompatibility	SELECT p2c.product_id, p2c.category_id, p2c.main_category FROM product_to_category p2c LEFT JOIN category_description cd ON (p2c.category_id = cd.category_id) WHERE product_id = '45358' /ORDER BY cd.name ASC/ ORDER BY p2c.category_id ASC
72	0.0001	ControllerEventCompatibility	SELECT DISTINCT * FROM category c LEFT JOIN category_description cd ON (c.category_id = cd.category_id) WHERE c.category_id = '1499' AND cd.language_id = '1' AND c.status = '1'
73	0.0001	ControllerProductExtendedReviews	SELECT * FROM product WHERE product_id = '45358'
74	0.0001	ControllerEventCompatibility	SELECT *, CONCAT(filter_id, '.', source) AS filter_key FROM ocfilter_filter_value_to_product WHERE product_id = '45358'
75	0.0001	ControllerEventCompatibility	SELECT *, CONCAT(filter_id, '.', source) AS filter_key FROM ocfilter_filter_range_to_product WHERE product_id = '45358'
76	0.0001	ControllerEventCompatibility	SELECT * FROM product_special WHERE product_id = '45358' AND customer_group_id = '1' AND ((date_start = '0000-00-00' OR date_start < '2024-04-17') AND (date_end = '0000-00-00' OR date_end > '2024-04-17')) LIMIT 1
77	0.0001	ControllerEventCompatibility	SELECT * FROM product_discount WHERE product_id = '45358' AND customer_group_id = '1' AND quantity = '1' AND ((date_start = '0000-00-00' OR date_start < '2024-04-17') AND (date_end = '0000-00-00' OR date_end > '2024-04-17')) LIMIT 1
78	0.0003	ControllerEventCompatibility	SELECT p.page_id, p.params, p.params_count, p.category_id, pd.name, pd.heading_title, (SELECT GROUP_CONCAT(DISTINCT cp.path_id ORDER BY cp.`level` SEPARATOR '_') AS path FROM category_path cp WHERE cp.category_id = p.category_id) AS path, (SELECT ua.keyword FROM url_alias ua WHERE ua.`query` = CONCAT('ocfilter_page_id=', p.page_id) LIMIT 1) AS keyword FROM ocfilter_page p LEFT JOIN ocfilter_page_description pd ON (p.page_id = pd.page_id) LEFT JOIN product_to_category p2c ON (p.category_id = p2c.category_id) WHERE p.status = '1' AND p.dynamic = '0' AND pd.language_id = '1' AND p2c.product_id = '45358' AND p.product = '1' ORDER BY p.params_count DESC
79	0.0001	ControllerCommonColumnLeft	SELECT * FROM product_to_layout WHERE product_id = '45358' AND store_id = '0'
80	0.0001	ControllerCommonColumnLeft	SELECT * FROM layout_route WHERE 'product/product' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1
81	0.0001	ControllerCommonColumnLeft	SELECT * FROM layout_module WHERE layout_id = '2' AND position = 'column_left' ORDER BY sort_order
82	0.0001	ControllerCommonColumnRight	SELECT * FROM product_to_layout WHERE product_id = '45358' AND store_id = '0'
83	0.0001	ControllerCommonColumnRight	SELECT * FROM layout_route WHERE 'product/product' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1
84	0.0001	ControllerCommonColumnRight	SELECT * FROM layout_module WHERE layout_id = '2' AND position = 'column_right' ORDER BY sort_order
85	0.0001	ControllerCommonContentTop	SELECT * FROM product_to_layout WHERE product_id = '45358' AND store_id = '0'
86	0.0001	ControllerCommonContentTop	SELECT * FROM layout_route WHERE 'product/product' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1
87	0.0001	ControllerCommonContentTop	SELECT * FROM layout_module WHERE layout_id = '2' AND position = 'content_top' ORDER BY sort_order
88	0.0001	ControllerCommonContentBottom	SELECT * FROM product_to_layout WHERE product_id = '45358' AND store_id = '0'
89	0.0001	ControllerCommonContentBottom	SELECT * FROM layout_route WHERE 'product/product' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1
90	0.0001	ControllerCommonContentBottom	SELECT * FROM layout_module WHERE layout_id = '2' AND position = 'content_bottom' ORDER BY sort_order
91	0.0001	ControllerEventCompatibility	SELECT * FROM module WHERE module_id = '47'
92	0.0001	ControllerEventCompatibility	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'product/ex_reviews_page' LIMIT 1
93	0.0011	ControllerEventCompatibility	SELECT DISTINCT * FROM ( ( SELECT DISTINCT r.*, pd.name, p.image FROM review r LEFT JOIN product p ON (r.product_id = p.product_id) LEFT JOIN product_description pd ON (p.product_id = pd.product_id) LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN product_to_category p2c ON (p.product_id = p2c.product_id) WHERE p2s.store_id = '0' AND p.date_available <= NOW() AND p.status = '1' AND r.status = '1' AND pd.language_id = '1' AND (r.videos != '' OR r.images != '') AND p2c.category_id = '1499' ORDER BY date_added DESC LIMIT 0, 20)) a LIMIT 20
94	0.0002	ControllerEventCompatibility	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'information/shop_rating' LIMIT 1
95	0.0002	ControllerEventCompatibility	SELECT * FROM shop_rating WHERE store_id ='0' AND rate_status = '1' ORDER BY rate_id DESC LIMIT 5
96	0.0009	ControllerEventCompatibility	SELECT * FROM shop_rating WHERE store_id ='0' AND rate_status = '1' ORDER BY date_added DESC
97	0.0003	ControllerEventCompatibility	SELECT m.*, (SELECT description FROM multi_modal_translate WHERE `key` = 'title' AND modal_id = m.id AND lang_id = '1') AS title, (SELECT description FROM multi_modal_translate WHERE `key` = 'content' AND modal_id = m.id AND lang_id = '1') AS content FROM multi_modals m WHERE m.status = 1
98	0.0007	ControllerExtensionModuleOCFilter	SELECT * FROM information i LEFT JOIN information_description id ON (i.information_id = id.information_id) LEFT JOIN information_to_store i2s ON (i.information_id = i2s.information_id) WHERE id.language_id = '1' AND i2s.store_id = '0' AND i.status = '1' ORDER BY i.sort_order, LCASE(id.title) ASC
99	0.0001	ControllerExtensionModuleOCFilter	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'information_id=22' LIMIT 1
100	0.0001	ControllerExtensionModuleOCFilter	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'information_id=21' LIMIT 1
101	0.0001	ControllerExtensionModuleOCFilter	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'information_id=14' LIMIT 1
102	0.0001	ControllerExtensionModuleOCFilter	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'information_id=23' LIMIT 1
103	0.0001	ControllerExtensionModuleOCFilter	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'information_id=8' LIMIT 1
104	0.0001	ControllerExtensionModuleOCFilter	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'information_id=6' LIMIT 1
105	0.0001	ControllerExtensionModuleOCFilter	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'information_id=9' LIMIT 1
106	0.0001	ControllerExtensionModuleOCFilter	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'information/contact' LIMIT 1
107	0.0001	ControllerExtensionModuleOCFilter	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'account/return/add' LIMIT 1
108	0.0001	ControllerExtensionModuleOCFilter	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'information/sitemap' LIMIT 1
109	0.0001	ControllerExtensionModuleOCFilter	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'product/manufacturer' LIMIT 1
110	0.0001	ControllerExtensionModuleOCFilter	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'account/voucher' LIMIT 1
111	0.0001	ControllerExtensionModuleOCFilter	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'affiliate/account' LIMIT 1
112	0.0001	ControllerExtensionModuleOCFilter	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'product/special' LIMIT 1
113	0.0001	ControllerExtensionModuleOCFilter	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'revolution/account/revaccount' LIMIT 1
114	0.0001	ControllerExtensionModuleOCFilter	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'account/order' LIMIT 1
115	0.0001	ControllerExtensionModuleOCFilter	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'account/wishlist' LIMIT 1
116	0.0001	ControllerExtensionModuleOCFilter	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'account/newsletter' LIMIT 1
117	0.0001	ControllerCommonHeader	SELECT * FROM extension WHERE `type` = 'analytics'
118	0.0001	ControllerCommonCartMobi	SELECT SUM(quantity) as total FROM cart WHERE api_id = '0' AND session_id = '61f7012faee037208d6c3b76f2f2def0'
119	0.0001	ControllerCommonCartMobi	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'checkout/cart' LIMIT 1
120	0.0001	ControllerCommonCartMobi	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'checkout/checkout' LIMIT 1
121	0.0001	ControllerExtensionModuleOCFilter	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'product/compare' LIMIT 1
122	0.0001	ControllerExtensionModuleOCFilter	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'revolution/account/revaccount' LIMIT 1
123	0.0001	ControllerExtensionModuleOCFilter	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'account/logout' LIMIT 1
124	0.0001	ControllerExtensionModuleOCFilter	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'common/home' LIMIT 1
125	0.0001	ControllerExtensionModuleOCFilter	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'account/wishlist' LIMIT 1
126	0.0001	ControllerExtensionModuleOCFilter	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'revolution/account/revaccount' LIMIT 1
127	0.0001	ControllerExtensionModuleOCFilter	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'revolution/account/revregister' LIMIT 1
128	0.0001	ControllerExtensionModuleOCFilter	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'account/login' LIMIT 1
129	0.0001	ControllerExtensionModuleOCFilter	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'account/order' LIMIT 1
130	0.0001	ControllerExtensionModuleOCFilter	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'account/transaction' LIMIT 1
131	0.0001	ControllerExtensionModuleOCFilter	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'account/download' LIMIT 1
132	0.0001	ControllerExtensionModuleOCFilter	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'account/logout' LIMIT 1
133	0.0001	ControllerExtensionModuleOCFilter	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'checkout/cart' LIMIT 1
134	0.0001	ControllerExtensionModuleOCFilter	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'checkout/checkout' LIMIT 1
135	0.0001	ControllerExtensionModuleOCFilter	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'information/contact' LIMIT 1
136	0.0001	ControllerCommonLanguage	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'common/language/language' LIMIT 1
137	0.0001	ControllerCommonLanguage	SELECT category_id FROM product_to_category WHERE product_id = '45358' ORDER BY main_category DESC LIMIT 1
138	0.0001	ControllerCommonLanguage	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=1499' LIMIT 1
139	0.0001	ControllerCommonLanguage	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'product_id=45358' LIMIT 1
140	0.0001	ControllerCommonCurrency	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'common/currency/currency' LIMIT 1
141	0.0001	ControllerCommonCurrency	SELECT category_id FROM product_to_category WHERE product_id = '45358' ORDER BY main_category DESC LIMIT 1
142	0.0001	ControllerCommonCurrency	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=1499' LIMIT 1
143	0.0001	ControllerCommonCurrency	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'product_id=45358' LIMIT 1
144	0.0006	ControllerCommonSearch	SELECT * FROM category c LEFT JOIN category_description cd ON (c.category_id = cd.category_id) WHERE c.parent_id = '0' AND cd.language_id = '1' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)
145	0.0001	ControllerCommonCart	SELECT * FROM cart WHERE api_id = '0' AND session_id = '61f7012faee037208d6c3b76f2f2def0'
146	0.0001	ControllerCommonCart	SELECT * FROM extension WHERE `type` = 'total'
147	0.0001	ControllerEventCompatibility	SELECT * FROM cart WHERE api_id = '0' AND session_id = '61f7012faee037208d6c3b76f2f2def0'
148	0.0001	ControllerEventCompatibility	SELECT SUM(quantity) as total FROM cart WHERE api_id = '0' AND session_id = '61f7012faee037208d6c3b76f2f2def0'
149	0.0001	ControllerEventCompatibility	SELECT * FROM cart WHERE api_id = '0' AND session_id = '61f7012faee037208d6c3b76f2f2def0'
150	0.0001	ControllerEventCompatibility	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'checkout/cart' LIMIT 1
151	0.0001	ControllerEventCompatibility	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'checkout/checkout' LIMIT 1
152	0.0001	ControllerExtensionModuleOCFilter	SELECT SUM(quantity) as total FROM cart WHERE api_id = '0' AND session_id = '61f7012faee037208d6c3b76f2f2def0'
153	0.0001	ControllerExtensionModuleFlamixBitrix24Integrations	SELECT * FROM setting WHERE store_id = '0' AND `code` = 'fx_b24'

Запрос на снижение цены.

Наш менеджер свяжется с вами в ближайшее время.

Товар конкурента должен быть в наличии, подходить на ваш автомобиль и вашу комплектацию, сроки доставки не больше наших, с гарантией и возможностью возврата.

Заявки с досок объявлений, китайских сайтов не рассматриваются.

Отмена

Здравствуйте! Мы всегда стремимся улучшить качество нашей услуги. Поэтому нам важно ваше мнение. Благодарим за предоставленную информацию.

Сообщение дойдет напрямую до руководителя отдела продаж.

Отмена