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

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

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

Автомобильный потолочный монитор ERGO ER23H 23.6" (1920X1080) черный

Артикул: 117708

В закладки

В сравнение

27 000 р.

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

Количество

Из категории Потолочные мониторы

ERGO ER22AND 22" (смарт ТВ, 1920X1080, ANDROID 9.0) бежевый

ERGO ER17AT 17,3" (Смарт ТВ, 1920x1080, Android 9.0) серый/бежевый/черный

Монитор потолочный WM MR-1 13,3" на базе Android с монтажной платформой (серый)

Монитор потолочный WM MR-3 18,5" (серый)

ERGO ER22AND 22" (смарт ТВ, 1920X1080, ANDROID 9.0) серый

ERGO ER15UN 15,6" (смарт ТВ, 1920X1080, ANDROID 9.0) серый

ERGO ER15AFL 15,6" (смарт ТВ, 1920x1080, ANDROID 9.0) черный

Моторизированный потолочный смарт ТВ 15,6" ERGO ER15AT

Монитор потолочный WM MR-1 13,3" на базе Android с монтажной платформой (бежевый)

Доставка

Установка

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

Описание
Отзывы ⁰

Описание

Потолочный монитор ERGO ER23H со встроенным медиаплеером, оснащен USB/SD/HDMI/AV разъемами для подключения внешних носителей, обладает самым большим экраном 23.6" для подобного класса устройств.

Размещение разъемов HDMI/AV/ на проводе позволяет подключить любое дополнительное оборудование скрытно, например цифровой тюнер или игровую приставку. Интересной особенностью модели ER23H является расположение USB разьёма на проводе, что даёт простор для вывода и размещения USB розетки под флешку в любом месте вашего автомобиля.

Высокое разрешение матрицы FullHD 1920х1080 позволяет использовать данную модель в связке с современной приставкой на IOS или Android и при этом качество изображения будет очень высоким.

ТЕХНИЧЕСКИЕ ХАРАКТЕРИСТИКИ ПОТОЛОЧНОГО МОНИТОРА ERGO ER23H:

Диагональ монитора 23,6" (TFT-LCD).
Разрешение матрицы FullHD 1920 х 1080.
HDMI вход (на проводе).
AV – вход, AV – выход, USB (на проводе)
Встроенные динамики
FM трансмиттер (передача звука по радио каналу).
Светодиодные лампы
Управление при помощи пульта Д/У и кнопок на мониторе.

Монитор на потолок ERGO ER23H идеален для установки в минивэны, микроавтобусы и большие автобусы. Он позволит в полной мере насладиться просмотром любимых фильмов большому количеству пассажиров.

Другой сферой применения монитора ERGO может стать показ рекламных объявлений на оживленных маршрутах городского и коммерческого транспорта.

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

Потолочный монитор
Провода подключения
Гарантийный талон/инструкция
Пульт ДУ

Внимание! Монитор не поддерживает звуковую дорожку AC3

Экран	LCD 23” (1920x1080)
FM/IR	Есть
Входы	HDMI/AV in/ AUDIO OUT/ USB /
Питание	12V
Размеры/ Вес	600х430х40 мм / 7 кг.
Дополнительно	Встроенная светодиодная лампа подсветки салона
Гарантия	Официальная гарантия 12 месяцев

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

Отзывы

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

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

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.1151 s | Queries: 168 | 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.0003		SELECT * FROM ocfilter_setting
5	0.0001	ControllerStartupStartup	SELECT * FROM store WHERE REPLACE(`ssl`, 'www.', '') = 'https://frontcam.ru/'
6	0.0006	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.0003	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` = 'cd9dca2df0af69359353be3b992d8903' LIMIT 1
22	0.0002	ControllerStartupEvent	SELECT * FROM `event` WHERE `trigger` LIKE 'catalog/%' AND status = '1' ORDER BY `event_id` ASC
23	0.0002	ControllerEventCompatibility	SELECT c.* FROM prmn_cm_city c ORDER BY sort, name
24	0.0001	ControllerStartupSeoPro	SELECT query FROM url_alias WHERE keyword = 'avtomonitory' LIMIT 1
25	0.0001	ControllerStartupSeoPro	SELECT query FROM url_alias WHERE keyword = 'potolochnyj-monitor-s-dvd' LIMIT 1
26	0.0001	ControllerStartupSeoPro	SELECT query FROM url_alias WHERE keyword = 'ergo-er23h-23-6-1920x1080-chernyy' LIMIT 1
27	0.0001	ControllerStartupSeoPro	SELECT query FROM url_alias WHERE keyword = 'avtomonitory/potolochnyj-monitor-s-dvd/ergo-er23h-23-6-1920x1080-chernyy' LIMIT 1
28	0.0001	ControllerStartupSeoPro	SELECT category_id FROM product_to_category WHERE product_id = '91001' ORDER BY main_category DESC LIMIT 1
29	0.0001	ControllerStartupSeoPro	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=96' LIMIT 1
30	0.0001	ControllerStartupSeoPro	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=98' LIMIT 1
31	0.0001	ControllerStartupSeoPro	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'product_id=91001' LIMIT 1
32	0.0001	ControllerProductProduct	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'common/home' LIMIT 1
33	0.0002	ControllerProductProduct	SELECT DISTINCT * FROM category c LEFT JOIN category_description cd ON (c.category_id = cd.category_id) WHERE c.category_id = '96' AND cd.language_id = '1' AND c.status = '1'
34	0.0001	ControllerProductProduct	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=96' LIMIT 1
35	0.0002	ControllerProductProduct	SELECT DISTINCT * FROM category c LEFT JOIN category_description cd ON (c.category_id = cd.category_id) WHERE c.category_id = '98' AND cd.language_id = '1' AND c.status = '1'
36	0.0001	ControllerProductProduct	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=96' LIMIT 1
37	0.0001	ControllerProductProduct	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=98' LIMIT 1
38	0.0001	ControllerProductProduct	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'common/home' LIMIT 1
39	0.0001	ControllerProductProduct	SELECT MAX(category_id) as category_id FROM product_to_category WHERE product_id =91001
40	0.0001	ControllerProductProduct	SELECT parent_id FROM category WHERE category_id =98
41	0.0001	ControllerProductProduct	SELECT parent_id FROM category WHERE category_id =96
42	0.0001	ControllerProductProduct	SELECT DISTINCT * FROM category c LEFT JOIN category_description cd ON (c.category_id = cd.category_id) WHERE c.category_id = '96' AND cd.language_id = '1' AND c.status = '1'
43	0.0001	ControllerProductProduct	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=96' LIMIT 1
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 = '98' AND cd.language_id = '1' AND c.status = '1'
45	0.0001	ControllerProductProduct	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=96' LIMIT 1
46	0.0001	ControllerProductProduct	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=98' LIMIT 1
47	0.0001	ControllerProductProduct	SELECT * FROM product_to_layout WHERE product_id = '91001' AND store_id = '0'
48	0.0001	ControllerProductProduct	SELECT * FROM layout_route WHERE 'product/product' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1
49	0.0001	ControllerProductProduct	SELECT * FROM layout_module WHERE layout_id = '2' AND `code` = 'ocfilter'
50	0.0001	ControllerProductProduct	SELECT * FROM ocfilter_setting WHERE `key` = 'placement_layout'
51	0.0008	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 = '91001' AND p.status = '1'
52	0.0002	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 = '91001' /ORDER BY cd.name ASC/ ORDER BY p2c.category_id ASC
53	0.0002	ControllerProductProduct	SELECT DISTINCT * FROM category c LEFT JOIN category_description cd ON (c.category_id = cd.category_id) WHERE c.category_id = '98' AND cd.language_id = '1' AND c.status = '1'
54	0.0001	ControllerProductProduct	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=96' LIMIT 1
55	0.0001	ControllerProductProduct	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=98' LIMIT 1
56	0.0001	ControllerProductProduct	SELECT category_id FROM product_to_category WHERE product_id = '91001' ORDER BY main_category DESC LIMIT 1
57	0.0001	ControllerProductProduct	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=96' LIMIT 1
58	0.0001	ControllerProductProduct	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=98' LIMIT 1
59	0.0001	ControllerProductProduct	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'product_id=91001' LIMIT 1
60	0.0002	ControllerEventCompatibility	SELECT c.* FROM prmn_cm_city c ORDER BY sort, name
61	0.0001	ControllerEventCompatibility	SELECT category_id FROM product_to_category WHERE product_id = '91001' ORDER BY main_category DESC LIMIT 1
62	0.0001	ControllerEventCompatibility	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=96' LIMIT 1
63	0.0001	ControllerEventCompatibility	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=98' LIMIT 1
64	0.0001	ControllerEventCompatibility	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'product_id=91001' LIMIT 1
65	0.0001	ControllerEventCompatibility	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'account/login' LIMIT 1
66	0.0001	ControllerEventCompatibility	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'revolution/account/revregister' LIMIT 1
67	0.0005	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 = '91001' 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
68	0.0002	ControllerEventCompatibility	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'manufacturer_id=25' LIMIT 1
69	0.0002	ControllerEventCompatibility	SELECT * FROM product_image WHERE product_id IN (91001) ORDER BY product_id, sort_order ASC
70	0.0003	ControllerEventCompatibility	SELECT * FROM product_discount WHERE product_id = '91001' 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
71	0.0006	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 = '91001' AND od.language_id = '1' ORDER BY o.sort_order
72	0.0002	ControllerEventCompatibility	SELECT category_id FROM product_to_category WHERE product_id = '91001' ORDER BY main_category DESC LIMIT 1
73	0.0001	ControllerEventCompatibility	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=96' LIMIT 1
74	0.0001	ControllerEventCompatibility	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=98' LIMIT 1
75	0.0001	ControllerEventCompatibility	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'product_id=91001' LIMIT 1
76	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 = '91001' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
77	0.0003	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 = '91001' 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
78	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 = '91001' 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
79	0.0004	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
80	0.0002	ControllerEventCompatibility	SELECT manufacturer_id FROM product WHERE product_id = '91001'
81	0.0003	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 = '91001' AND ptd.language_id = '1' AND pt.status = 1 ORDER BY sort_order ASC
82	0.0002	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 = 91001 AND status = '1' AND pr.customer_group_id = '1' ORDER BY sort_order ASC
83	0.0002	ControllerEventCompatibility	UPDATE product SET viewed = (viewed + 1) WHERE product_id = '91001'
84	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 = '91001' /ORDER BY cd.name ASC/ ORDER BY p2c.category_id ASC
85	0.0002	ControllerEventCompatibility	SELECT DISTINCT * FROM category c LEFT JOIN category_description cd ON (c.category_id = cd.category_id) WHERE c.category_id = '98' AND cd.language_id = '1' AND c.status = '1'
86	0.0003	ControllerProductExtendedReviews	SELECT * FROM product WHERE product_id = '91001'
87	0.0002	ControllerEventCompatibility	SELECT *, CONCAT(filter_id, '.', source) AS filter_key FROM ocfilter_filter_value_to_product WHERE product_id = '91001'
88	0.0001	ControllerEventCompatibility	SELECT *, CONCAT(filter_id, '.', source) AS filter_key FROM ocfilter_filter_range_to_product WHERE product_id = '91001'
89	0.0002	ControllerEventCompatibility	SELECT * FROM product_special WHERE product_id = '91001' 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
90	0.0002	ControllerEventCompatibility	SELECT * FROM product_discount WHERE product_id = '91001' 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
91	0.0006	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 = '91001' AND p.product = '1' ORDER BY p.params_count DESC
92	0.0001	ControllerCommonColumnLeft	SELECT * FROM product_to_layout WHERE product_id = '91001' AND store_id = '0'
93	0.0001	ControllerCommonColumnLeft	SELECT * FROM layout_route WHERE 'product/product' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1
94	0.0001	ControllerCommonColumnLeft	SELECT * FROM layout_module WHERE layout_id = '2' AND position = 'column_left' ORDER BY sort_order
95	0.0001	ControllerCommonColumnRight	SELECT * FROM product_to_layout WHERE product_id = '91001' AND store_id = '0'
96	0.0002	ControllerCommonColumnRight	SELECT * FROM layout_route WHERE 'product/product' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1
97	0.0001	ControllerCommonColumnRight	SELECT * FROM layout_module WHERE layout_id = '2' AND position = 'column_right' ORDER BY sort_order
98	0.0001	ControllerCommonContentTop	SELECT * FROM product_to_layout WHERE product_id = '91001' AND store_id = '0'
99	0.0001	ControllerCommonContentTop	SELECT * FROM layout_route WHERE 'product/product' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1
100	0.0002	ControllerCommonContentTop	SELECT * FROM layout_module WHERE layout_id = '2' AND position = 'content_top' ORDER BY sort_order
101	0.0002	ControllerCommonContentBottom	SELECT * FROM product_to_layout WHERE product_id = '91001' AND store_id = '0'
102	0.0002	ControllerCommonContentBottom	SELECT * FROM layout_route WHERE 'product/product' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1
103	0.0001	ControllerCommonContentBottom	SELECT * FROM layout_module WHERE layout_id = '2' AND position = 'content_bottom' ORDER BY sort_order
104	0.0001	ControllerEventCompatibility	SELECT * FROM module WHERE module_id = '47'
105	0.0002	ControllerEventCompatibility	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'product/ex_reviews_page' LIMIT 1
106	0.0016	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 = '98' ORDER BY date_added DESC LIMIT 0, 20)) a LIMIT 20
107	0.0002	ControllerEventCompatibility	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'information/shop_rating' LIMIT 1
108	0.0002	ControllerEventCompatibility	SELECT * FROM shop_rating WHERE store_id ='0' AND rate_status = '1' ORDER BY rate_id DESC LIMIT 5
109	0.0009	ControllerEventCompatibility	SELECT * FROM shop_rating WHERE store_id ='0' AND rate_status = '1' ORDER BY date_added DESC
110	0.0005	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
111	0.001	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
112	0.0001	ControllerExtensionModuleOCFilter	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'information_id=22' LIMIT 1
113	0.0001	ControllerExtensionModuleOCFilter	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'information_id=21' LIMIT 1
114	0.0001	ControllerExtensionModuleOCFilter	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'information_id=14' LIMIT 1
115	0.0001	ControllerExtensionModuleOCFilter	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'information_id=23' LIMIT 1
116	0.0001	ControllerExtensionModuleOCFilter	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'information_id=8' LIMIT 1
117	0.0001	ControllerExtensionModuleOCFilter	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'information_id=6' LIMIT 1
118	0.0001	ControllerExtensionModuleOCFilter	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'information_id=9' LIMIT 1
119	0.0001	ControllerExtensionModuleOCFilter	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'information/contact' LIMIT 1
120	0.0001	ControllerExtensionModuleOCFilter	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'account/return/add' LIMIT 1
121	0.0001	ControllerExtensionModuleOCFilter	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'information/sitemap' LIMIT 1
122	0.0001	ControllerExtensionModuleOCFilter	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'product/manufacturer' LIMIT 1
123	0.0001	ControllerExtensionModuleOCFilter	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'account/voucher' LIMIT 1
124	0.0001	ControllerExtensionModuleOCFilter	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'affiliate/account' LIMIT 1
125	0.0001	ControllerExtensionModuleOCFilter	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'product/special' LIMIT 1
126	0.0002	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 = 'account/order' LIMIT 1
128	0.0001	ControllerExtensionModuleOCFilter	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'account/wishlist' LIMIT 1
129	0.0001	ControllerExtensionModuleOCFilter	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'account/newsletter' LIMIT 1
130	0.0001	ControllerCommonHeader	SELECT * FROM extension WHERE `type` = 'analytics'
131	0.0002	ControllerCommonCartMobi	SELECT SUM(quantity) as total FROM cart WHERE api_id = '0' AND session_id = 'cd9dca2df0af69359353be3b992d8903'
132	0.0002	ControllerCommonCartMobi	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'checkout/cart' LIMIT 1
133	0.0002	ControllerCommonCartMobi	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'checkout/checkout' LIMIT 1
134	0.0002	ControllerExtensionModuleOCFilter	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'product/compare' LIMIT 1
135	0.0001	ControllerExtensionModuleOCFilter	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'revolution/account/revaccount' LIMIT 1
136	0.0001	ControllerExtensionModuleOCFilter	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'account/logout' LIMIT 1
137	0.0001	ControllerExtensionModuleOCFilter	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'common/home' LIMIT 1
138	0.0001	ControllerExtensionModuleOCFilter	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'account/wishlist' LIMIT 1
139	0.0001	ControllerExtensionModuleOCFilter	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'revolution/account/revaccount' LIMIT 1
140	0.0001	ControllerExtensionModuleOCFilter	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'revolution/account/revregister' LIMIT 1
141	0.0001	ControllerExtensionModuleOCFilter	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'account/login' LIMIT 1
142	0.0001	ControllerExtensionModuleOCFilter	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'account/order' LIMIT 1
143	0.0001	ControllerExtensionModuleOCFilter	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'account/transaction' LIMIT 1
144	0.0001	ControllerExtensionModuleOCFilter	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'account/download' LIMIT 1
145	0.0001	ControllerExtensionModuleOCFilter	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'account/logout' LIMIT 1
146	0.0001	ControllerExtensionModuleOCFilter	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'checkout/cart' LIMIT 1
147	0.0001	ControllerExtensionModuleOCFilter	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'checkout/checkout' LIMIT 1
148	0.0001	ControllerExtensionModuleOCFilter	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'information/contact' LIMIT 1
149	0.0002	ControllerCommonLanguage	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'common/language/language' LIMIT 1
150	0.0002	ControllerCommonLanguage	SELECT category_id FROM product_to_category WHERE product_id = '91001' ORDER BY main_category DESC LIMIT 1
151	0.0001	ControllerCommonLanguage	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=96' LIMIT 1
152	0.0001	ControllerCommonLanguage	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=98' LIMIT 1
153	0.0001	ControllerCommonLanguage	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'product_id=91001' LIMIT 1
154	0.0001	ControllerCommonCurrency	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'common/currency/currency' LIMIT 1
155	0.0001	ControllerCommonCurrency	SELECT category_id FROM product_to_category WHERE product_id = '91001' ORDER BY main_category DESC LIMIT 1
156	0.0001	ControllerCommonCurrency	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=96' LIMIT 1
157	0.0001	ControllerCommonCurrency	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=98' LIMIT 1
158	0.0001	ControllerCommonCurrency	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'product_id=91001' LIMIT 1
159	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)
160	0.0001	ControllerCommonCart	SELECT * FROM cart WHERE api_id = '0' AND session_id = 'cd9dca2df0af69359353be3b992d8903'
161	0.0001	ControllerCommonCart	SELECT * FROM extension WHERE `type` = 'total'
162	0.0001	ControllerEventCompatibility	SELECT * FROM cart WHERE api_id = '0' AND session_id = 'cd9dca2df0af69359353be3b992d8903'
163	0.0001	ControllerEventCompatibility	SELECT SUM(quantity) as total FROM cart WHERE api_id = '0' AND session_id = 'cd9dca2df0af69359353be3b992d8903'
164	0.0001	ControllerEventCompatibility	SELECT * FROM cart WHERE api_id = '0' AND session_id = 'cd9dca2df0af69359353be3b992d8903'
165	0.0001	ControllerEventCompatibility	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'checkout/cart' LIMIT 1
166	0.0001	ControllerEventCompatibility	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'checkout/checkout' LIMIT 1
167	0.0001	ControllerExtensionModuleOCFilter	SELECT SUM(quantity) as total FROM cart WHERE api_id = '0' AND session_id = 'cd9dca2df0af69359353be3b992d8903'
168	0.0001	ControllerExtensionModuleFlamixBitrix24Integrations	SELECT * FROM setting WHERE store_id = '0' AND `code` = 'fx_b24'

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

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

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

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

Отмена

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

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

Отмена