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

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

Работаем с 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

Камера заднего вида cam-107 для Ford Focus 3 (2015-2017) рестайл седан (SonyCCD 170 градусов) в ручку

Артикул: 28259

5.0

отзыв

В закладки

В сравнение

3 500 р.

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

Количество

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

Универсальная врезная камера заднего/переднего вида cam-645 (AHD 1080p, 170 градусов с отключаемой разметкой, ночная съемка)

Универсальная камера заднего/переднего вида cam-610 (кубик SonyMCCD, 170 градусов по горизонтали, ночная съемка)

Универсальная камера заднего вида cam-605 (кубик, 4 LED, 140 градусов по горизонтали)

Универсальная камера на болтовом креплении cam-635 (Sony AHD 1080p, 170 градусов, заднего/переднего вида с отключаемой разметкой, ночная съемка)

Универсальная камера заднего/переднего вида cam-625 (врезная с омывателем)

Универсальная камера в рамке номерного знака cam-705 (заднего/переднего вида, с отключаемой разметкой AHD 1080p, 170 градусов)

Камера заднего/переднего вида cam-505 для установки в штатное место (через адаптер) с отключаемой разметкой, AHD 1080p, 170 градусов

Универсальная камера заднего вида кубик Teyes SONY-AHD 1080p, 170 градусов по горизонтали (ночная съемка)

Камера заднего вида (AHD 1080p, 150 градусов) в значок логотипа Volkswagen Passat B6/B7/B8/CC, Polo, Golf 6/7, Beetle

Canbox A10 адаптер BC12 с GVIF (LVDS) для подключения штатной видеокамеры Toyota, Lexus 2005+ к новой магнитоле

Камера заднего вида (CCD) в значок логотипа Volkswagen Passat B6/B7/B8/CC, Polo, Golf 6/7, Beetle

Камера AHD 1080p, 170 градусов с отключаемой разметкой, cam-109 для Ford Focus 3 (2011-2017) в ручку багажника

Универсальная камера в рамке номерного знака cam-700 (заднего/переднего вида, с отключаемой разметкой, SonyMCCD 170 градусов)

Камера SonyMCCD 170 градусов cam-145 для Лада Веста НГ (Lada Vesta NG)

Canbox A03 адаптер RGB для оригинальных камер Volkswagen

Универсальная врезная камера заднего вида cam-148 (AHD/CVBS 1080p, 150 градусов с отключаемой разметкой, ночная съемка, чёрная)

Универсальная камера заднего/переднего вида cam-640 (AHD 720p, 150 градусов, врезная с омывателем)

Камера 4 LED 140 градусов cam-023 для Hyundai ix35, Tucson / Kia Ceed Hatchback 2012+

Универсальная камера заднего вида на болте HS SONY AHD 1080P, 170 градусов по горизонтали (ночная съемка)

Canbox A15 адаптер для подключения штатной видеокамеры Hyundai, Kia к новой магнитоле

Доставка

Установка

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

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

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

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

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

Наш YouTube канал

Дата: 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 PRO-Line 2K 4254 для Dodge RAM 4 (DS/DJ) на ANDROID

Дата: 07.04.2024

Магнитола Teyes CC3 2K для Toyota Altezza на ANDROID

Дата: 07.04.2024

Магнитола Canbox PRO-Line 2K 4252 для Subaru Impreza 2 на ANDROID

Описание

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

Вид:	Цветная камера заднего вида
Угол обзора:	180 градусов по диагонали, 170 градусов по горизонтали
Видеосистема:	NTSC или PAL
Характеристика разрешения:	520 TV линий
IP рейтинг защиты от воды:	IP 68
Зеркалирование:	Да (необходимо для задней камеры)
Минимальная освещенность	0,1 Lux
Парковочная разметка	Да, цветная, возможно отключить.
Цветная:	Да.
Разрешение:	728х582 пикселей
Сенсор	1/3" SonyCCD
Сигнал/шум	более 48 db
Материал линзы	Стекло
Рабочая температура	-40...+65 градусов
Напряжение питания	12 В
Видео выход	1.0Vp-p,750hm (тюльпан RCA)
Тип подключения	Проводной (6 метров видеопровода который тянется через салон к магнитоле или монитору)

Комплектация:

Камера заднего вида.
Провод для передачи видео сигнала и питания 6 метров.
Провод для питания камеры заднего вида.
Двухсторонний скотч прокладка (поставляется не ко всем моделям)
Коробка и краткая инструкция по подключению.

Гарантия:

6 месяцев - при условии сохранения целостности проводки.
14 дней - возврат, обмен

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

Камеры заднего вида
Марка автомобиля	Ford
Модель авто	Focus 3 (2015-2017) рестайл седан

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

Отзывы

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

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

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.0877 s | Queries: 156 | Slow queries (>0.003 s): 0

#	Query time (s)	Controller	Query
1	0.0003		SELECT value FROM setting WHERE store_id = '0' AND `key`='config_seo_url_type'
2	0.0001		SET SQL_BIG_SELECTS = 1
3	0.0004		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.0004	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.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.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.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.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.0003	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` = '534f68355e26257a4572f67a28a66823' 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 = 'rear-view-camera' LIMIT 1
25	0.0001	ControllerStartupSeoPro	SELECT query FROM url_alias WHERE keyword = 'kamera-ford-focus-3-2015-2016-2017-sonyccd-170-gradusov' LIMIT 1
26	0.0001	ControllerStartupSeoPro	SELECT query FROM url_alias WHERE keyword = 'rear-view-camera/kamera-ford-focus-3-2015-2016-2017-sonyccd-170-gradusov' LIMIT 1
27	0.0001	ControllerStartupSeoPro	SELECT category_id FROM product_to_category WHERE product_id = '9393' ORDER BY main_category DESC LIMIT 1
28	0.0001	ControllerStartupSeoPro	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=70' LIMIT 1
29	0.0001	ControllerStartupSeoPro	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'product_id=9393' LIMIT 1
30	0.0001	ControllerProductProduct	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'common/home' LIMIT 1
31	0.0002	ControllerProductProduct	SELECT DISTINCT * FROM category c LEFT JOIN category_description cd ON (c.category_id = cd.category_id) WHERE c.category_id = '70' 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=70' 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 =9393
35	0	ControllerProductProduct	SELECT parent_id FROM category WHERE category_id =70
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 = '70' 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=70' LIMIT 1
38	0.0001	ControllerProductProduct	SELECT * FROM product_to_layout WHERE product_id = '9393' 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.0001	ControllerProductProduct	SELECT * FROM ocfilter_setting WHERE `key` = 'placement_layout'
42	0.0006	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 = '9393' 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 = '9393' /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 = '70' AND cd.language_id = '1' AND c.status = '1'
45	0.0001	ControllerProductProduct	SELECT category_id FROM product_to_category WHERE product_id = '9393' ORDER BY main_category DESC LIMIT 1
46	0.0001	ControllerProductProduct	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=70' LIMIT 1
47	0.0001	ControllerProductProduct	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'product_id=9393' 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 = '9393' ORDER BY main_category DESC LIMIT 1
50	0.0001	ControllerEventCompatibility	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=70' LIMIT 1
51	0.0001	ControllerEventCompatibility	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'product_id=9393' 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 = '9393' 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 * FROM ex_review_answer WHERE parent_id = '503' and status = '1'
56	0.0001	ControllerEventCompatibility	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'manufacturer_id=136' LIMIT 1
57	0.0001	ControllerEventCompatibility	SELECT * FROM product_image WHERE product_id IN (9393) ORDER BY product_id, sort_order ASC
58	0.0002	ControllerEventCompatibility	SELECT * FROM product_discount WHERE product_id = '9393' 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
59	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 = '9393' AND od.language_id = '1' ORDER BY o.sort_order
60	0.0001	ControllerEventCompatibility	SELECT category_id FROM product_to_category WHERE product_id = '9393' ORDER BY main_category DESC LIMIT 1
61	0.0001	ControllerEventCompatibility	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=70' LIMIT 1
62	0.0001	ControllerEventCompatibility	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'product_id=9393' LIMIT 1
63	0.0004	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 = '9393' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
64	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 = '9393' AND a.attribute_group_id = '11' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
65	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 = '9393' 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 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 = '9393' 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
67	0.0003	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
68	0.0001	ControllerEventCompatibility	SELECT manufacturer_id FROM product WHERE product_id = '9393'
69	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 = '9393' AND ptd.language_id = '1' AND pt.status = 1 ORDER BY sort_order ASC
70	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 = 9393 AND status = '1' AND pr.customer_group_id = '1' ORDER BY sort_order ASC
71	0.0001	ControllerEventCompatibility	UPDATE product SET viewed = (viewed + 1) WHERE product_id = '9393'
72	0.0002	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 = '9393' /ORDER BY cd.name ASC/ ORDER BY p2c.category_id ASC
73	0.0002	ControllerEventCompatibility	SELECT DISTINCT * FROM category c LEFT JOIN category_description cd ON (c.category_id = cd.category_id) WHERE c.category_id = '70' AND cd.language_id = '1' AND c.status = '1'
74	0.0002	ControllerProductExtendedReviews	SELECT * FROM product WHERE product_id = '9393'
75	0.0001	ControllerEventCompatibility	SELECT *, CONCAT(filter_id, '.', source) AS filter_key FROM ocfilter_filter_value_to_product WHERE product_id = '9393'
76	0.0001	ControllerEventCompatibility	SELECT *, CONCAT(filter_id, '.', source) AS filter_key FROM ocfilter_filter_range_to_product WHERE product_id = '9393'
77	0.0001	ControllerEventCompatibility	SELECT * FROM product_special WHERE product_id = '9393' AND customer_group_id = '1' AND ((date_start = '0000-00-00' OR date_start < '2024-04-16') AND (date_end = '0000-00-00' OR date_end > '2024-04-16')) LIMIT 1
78	0.0001	ControllerEventCompatibility	SELECT * FROM product_discount WHERE product_id = '9393' AND customer_group_id = '1' AND quantity = '1' AND ((date_start = '0000-00-00' OR date_start < '2024-04-16') AND (date_end = '0000-00-00' OR date_end > '2024-04-16')) LIMIT 1
79	0.0004	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 = '9393' AND p.product = '1' ORDER BY p.params_count DESC
80	0.0001	ControllerCommonColumnLeft	SELECT * FROM product_to_layout WHERE product_id = '9393' AND store_id = '0'
81	0.0001	ControllerCommonColumnLeft	SELECT * FROM layout_route WHERE 'product/product' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1
82	0.0001	ControllerCommonColumnLeft	SELECT * FROM layout_module WHERE layout_id = '2' AND position = 'column_left' ORDER BY sort_order
83	0.0001	ControllerCommonColumnRight	SELECT * FROM product_to_layout WHERE product_id = '9393' AND store_id = '0'
84	0.0001	ControllerCommonColumnRight	SELECT * FROM layout_route WHERE 'product/product' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1
85	0.0001	ControllerCommonColumnRight	SELECT * FROM layout_module WHERE layout_id = '2' AND position = 'column_right' ORDER BY sort_order
86	0.0002	ControllerCommonContentTop	SELECT * FROM product_to_layout WHERE product_id = '9393' AND store_id = '0'
87	0.0001	ControllerCommonContentTop	SELECT * FROM layout_route WHERE 'product/product' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1
88	0.0001	ControllerCommonContentTop	SELECT * FROM layout_module WHERE layout_id = '2' AND position = 'content_top' ORDER BY sort_order
89	0.0001	ControllerCommonContentBottom	SELECT * FROM product_to_layout WHERE product_id = '9393' AND store_id = '0'
90	0.0001	ControllerCommonContentBottom	SELECT * FROM layout_route WHERE 'product/product' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1
91	0.0001	ControllerCommonContentBottom	SELECT * FROM layout_module WHERE layout_id = '2' AND position = 'content_bottom' ORDER BY sort_order
92	0.0001	ControllerEventCompatibility	SELECT * FROM module WHERE module_id = '47'
93	0.0001	ControllerEventCompatibility	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'product/ex_reviews_page' LIMIT 1
94	0.002	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 = '70' ORDER BY date_added DESC LIMIT 0, 20)) a LIMIT 20
95	0.0001	ControllerEventCompatibility	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'information/shop_rating' LIMIT 1
96	0.0002	ControllerEventCompatibility	SELECT * FROM shop_rating WHERE store_id ='0' AND rate_status = '1' ORDER BY rate_id DESC LIMIT 5
97	0.0008	ControllerEventCompatibility	SELECT * FROM shop_rating WHERE store_id ='0' AND rate_status = '1' ORDER BY date_added DESC
98	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
99	0.0009	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
100	0.0001	ControllerExtensionModuleOCFilter	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'information_id=22' LIMIT 1
101	0.0001	ControllerExtensionModuleOCFilter	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'information_id=21' LIMIT 1
102	0.0001	ControllerExtensionModuleOCFilter	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'information_id=14' LIMIT 1
103	0.0001	ControllerExtensionModuleOCFilter	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'information_id=23' LIMIT 1
104	0.0001	ControllerExtensionModuleOCFilter	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'information_id=8' LIMIT 1
105	0.0001	ControllerExtensionModuleOCFilter	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'information_id=6' LIMIT 1
106	0.0001	ControllerExtensionModuleOCFilter	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'information_id=9' LIMIT 1
107	0.0001	ControllerExtensionModuleOCFilter	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'information/contact' LIMIT 1
108	0.0001	ControllerExtensionModuleOCFilter	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'account/return/add' LIMIT 1
109	0.0001	ControllerExtensionModuleOCFilter	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'information/sitemap' LIMIT 1
110	0.0001	ControllerExtensionModuleOCFilter	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'product/manufacturer' LIMIT 1
111	0.0001	ControllerExtensionModuleOCFilter	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'account/voucher' LIMIT 1
112	0.0001	ControllerExtensionModuleOCFilter	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'affiliate/account' LIMIT 1
113	0.0001	ControllerExtensionModuleOCFilter	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'product/special' LIMIT 1
114	0.0001	ControllerExtensionModuleOCFilter	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'revolution/account/revaccount' LIMIT 1
115	0.0001	ControllerExtensionModuleOCFilter	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'account/order' LIMIT 1
116	0.0001	ControllerExtensionModuleOCFilter	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'account/wishlist' LIMIT 1
117	0.0001	ControllerExtensionModuleOCFilter	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'account/newsletter' LIMIT 1
118	0.0001	ControllerCommonHeader	SELECT * FROM extension WHERE `type` = 'analytics'
119	0.0001	ControllerCommonCartMobi	SELECT SUM(quantity) as total FROM cart WHERE api_id = '0' AND session_id = '534f68355e26257a4572f67a28a66823'
120	0.0001	ControllerCommonCartMobi	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'checkout/cart' LIMIT 1
121	0.0001	ControllerCommonCartMobi	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'checkout/checkout' LIMIT 1
122	0.0001	ControllerExtensionModuleOCFilter	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'product/compare' LIMIT 1
123	0.0001	ControllerExtensionModuleOCFilter	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'revolution/account/revaccount' LIMIT 1
124	0.0001	ControllerExtensionModuleOCFilter	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'account/logout' LIMIT 1
125	0.0001	ControllerExtensionModuleOCFilter	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'common/home' LIMIT 1
126	0.0001	ControllerExtensionModuleOCFilter	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'account/wishlist' LIMIT 1
127	0.0001	ControllerExtensionModuleOCFilter	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'revolution/account/revaccount' LIMIT 1
128	0.0001	ControllerExtensionModuleOCFilter	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'revolution/account/revregister' LIMIT 1
129	0.0001	ControllerExtensionModuleOCFilter	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'account/login' LIMIT 1
130	0.0001	ControllerExtensionModuleOCFilter	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'account/order' LIMIT 1
131	0.0001	ControllerExtensionModuleOCFilter	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'account/transaction' LIMIT 1
132	0.0001	ControllerExtensionModuleOCFilter	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'account/download' LIMIT 1
133	0.0001	ControllerExtensionModuleOCFilter	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'account/logout' LIMIT 1
134	0.0001	ControllerExtensionModuleOCFilter	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'checkout/cart' LIMIT 1
135	0.0001	ControllerExtensionModuleOCFilter	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'checkout/checkout' LIMIT 1
136	0.0001	ControllerExtensionModuleOCFilter	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'information/contact' LIMIT 1
137	0.0001	ControllerCommonLanguage	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'common/language/language' LIMIT 1
138	0.0001	ControllerCommonLanguage	SELECT category_id FROM product_to_category WHERE product_id = '9393' ORDER BY main_category DESC LIMIT 1
139	0.0001	ControllerCommonLanguage	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=70' LIMIT 1
140	0.0001	ControllerCommonLanguage	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'product_id=9393' LIMIT 1
141	0.0001	ControllerCommonCurrency	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'common/currency/currency' LIMIT 1
142	0.0001	ControllerCommonCurrency	SELECT category_id FROM product_to_category WHERE product_id = '9393' ORDER BY main_category DESC LIMIT 1
143	0.0001	ControllerCommonCurrency	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=70' LIMIT 1
144	0.0001	ControllerCommonCurrency	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'product_id=9393' LIMIT 1
145	0.0007	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)
146	0.0001	ControllerCommonCart	SELECT * FROM cart WHERE api_id = '0' AND session_id = '534f68355e26257a4572f67a28a66823'
147	0.0001	ControllerCommonCart	SELECT * FROM extension WHERE `type` = 'total'
148	0.0001	ControllerEventCompatibility	SELECT * FROM cart WHERE api_id = '0' AND session_id = '534f68355e26257a4572f67a28a66823'
149	0.0001	ControllerEventCompatibility	SELECT SUM(quantity) as total FROM cart WHERE api_id = '0' AND session_id = '534f68355e26257a4572f67a28a66823'
150	0.0001	ControllerEventCompatibility	SELECT * FROM cart WHERE api_id = '0' AND session_id = '534f68355e26257a4572f67a28a66823'
151	0.0001	ControllerEventCompatibility	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'checkout/cart' LIMIT 1
152	0.0001	ControllerEventCompatibility	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'checkout/checkout' LIMIT 1
153	0.0002	ControllerExtensionModuleOCFilter	SELECT SUM(quantity) as total FROM cart WHERE api_id = '0' AND session_id = '534f68355e26257a4572f67a28a66823'
154	0.0002	ControllerExtensionModuleFlamixBitrix24Integrations	SELECT * FROM setting WHERE store_id = '0' AND `code` = 'fx_b24'
155	0.0001	ControllerExtensionModuleFlamixBitrix24Integrations	SELECT pnl.id, pnl.location_id, pnl.address FROM `product_new_location` pnl WHERE pnl.quantity > '0' AND (pnl.product_id = '9393')
156	0.0001	ControllerExtensionModuleFlamixBitrix24Integrations	SELECT pnl.id, pnl.quantity, pnl.location_id, pnl.address FROM `product_new_location` pnl WHERE pnl.product_id = '9393'

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

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

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

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

Отмена

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

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

Отмена