Купить видеорегистратор, Full HD 1080p, С GPS-трекером, С двумя камерами, С оповещением о камерах

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

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

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

Наш интернет-магазин предлагает Вам купить автомобильные видеорегистраторы для вашей машины. Видеорегистратор - независимый свидетель, в правдивости которого не придется сомневаться.

Сортировка:

Показать:

Фильтр

В закладки

В сравнение

Видеорегистратор Canbox X014 для подключения к магнитолам по USB (ADAS) Full HD 1080P

Артикул: 203756

Видеорегистратор Canbox X014 для подключения к магнитолам по USB (ADAS) Full HD 1080P
В наличии Москва - Ташкентская 28с1
В наличии Питер - Придорожная аллея 8

5 900 р.

В закладки

В сравнение

Видеообзор

Видеорегистратор Teyes X5-DVR для подключения к магнитолам Teyes по USB (ADAS) Full HD 1080P

Артикул: 103524

Видеорегистратор Teyes X5-DVR для подключения к магнитолам Teyes по USB (ADAS) Full HD 1080P
В наличии Москва - Ташкентская 28с1
В наличии Питер - Придорожная аллея 8

5.0

отзыв

6 500 р.

В закладки

В сравнение

Видеообзор

Видеорегистратор 720p для подключения к магнитолам Android по USB с поддержкой ADAS

Артикул: 193869

Видеорегистратор 720p для подключения к магнитолам Android по USB с поддержкой ADAS
В наличии Москва - Ташкентская 28с1
В наличии Питер - Придорожная аллея 8

3 000 р.

В закладки

В сравнение

Видеорегистратор Canbox X016 для подключения к магнитолам по USB (ADAS) Full HD 1080P

Артикул: 203755

Видеорегистратор Canbox X016 для подключения к магнитолам по USB (ADAS) Full HD 1080P
В наличии Москва - Ташкентская 28с1
В наличии Питер - Придорожная аллея 8

5 500 р.

В закладки

В сравнение

Видеорегистратор Canbox X019-DUAL с 2 камерами (с функцией парковки) для подключения к магнитолам по USB (ADAS), Full HD 1080P и 720P

Артикул: 205548

Видеорегистратор Canbox X019-DUAL с 2 камерами (с функцией парковки) для подключения к магнитолам по USB (ADAS), Full HD 1080P и 720P
В наличии Москва - Ташкентская 28с1
В наличии Питер - Придорожная аллея 8

7 900 р.

В закладки

В сравнение

Видеорегистратор Canbox X018-DUAL с 2 камерами (с функцией парковки) для подключения к магнитолам по USB (ADAS) Full HD 1080P и 720P

Артикул: 203757

Видеорегистратор Canbox X018-DUAL с 2 камерами (с функцией парковки) для подключения к магнитолам по USB (ADAS) Full HD 1080P и 720P
В наличии Москва - Ташкентская 28с1
В наличии Питер - Придорожная аллея 8

7 900 р.

Показано с 1 по 6 из 6 (всего 1 страниц)

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

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

Почему Frontcam:

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

Надежность

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

Большой опыт

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

Оплата потом

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

Установка

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

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

Created by frontcam.ru

Total time: 0.0834 s | Queries: 185 | 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		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.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.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.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	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` = '306494fe5146b7398341be2ff55c530f' 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 = 'videoregistratory' LIMIT 1
25	0.0001	ControllerStartupSeoPro	SELECT query FROM url_alias WHERE keyword = 'videoregistratory/' LIMIT 1
26	0.0001	ControllerStartupSeoPro	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=20' LIMIT 1
27	0.0001	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'common/home' LIMIT 1
28	0.0001	ControllerProductCategory	SELECT DISTINCT * FROM category c LEFT JOIN category_description cd ON (c.category_id = cd.category_id) WHERE c.category_id = '20' AND cd.language_id = '1' AND c.status = '1'
29	0.0001	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=20' LIMIT 1
30	0.0001	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'product/compare' LIMIT 1
31	0.0004	ControllerProductCategory	SELECT * FROM category c LEFT JOIN category_description cd ON (c.category_id = cd.category_id) WHERE c.parent_id = '20' AND cd.language_id = '1' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)
32	0.0001	ControllerProductCategory	SELECT * FROM category_to_layout WHERE category_id = '20'
33	0.0001	ControllerProductCategory	SELECT * FROM layout_route WHERE 'product/category' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1
34	0.0001	ControllerProductCategory	SELECT * FROM layout_module WHERE layout_id = '3' AND `code` = 'ocfilter'
35	0.0001	ControllerProductCategory	SELECT c.category_id FROM category c LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '20' AND c2s.store_id = '0' LIMIT 1
36	0.0002	ControllerProductCategory	SELECT COUNT(DISTINCT p.product_id) AS total FROM product_to_category p2c LEFT JOIN product p ON (p2c.product_id = p.product_id) WHERE p.status = '1' AND p.catalog_output = '1' AND p2c.category_id = '20'
37	0.0003	ControllerProductCategory	SELECT p.product_id, (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 FROM product_to_category p2c LEFT JOIN product p ON (p2c.product_id = p.product_id) WHERE p.status = '1' AND p.catalog_output = '1' AND p2c.category_id = '20' GROUP BY p.product_id ORDER BY p.viewed DESC LIMIT 0,18
38	0.0005	ControllerProductCategory	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 = '178536' AND p.status = '1'
39	0.0004	ControllerProductCategory	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 = '76756' AND p.status = '1'
40	0.0004	ControllerProductCategory	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 = '168622' AND p.status = '1'
41	0.0004	ControllerProductCategory	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 = '178535' AND p.status = '1'
42	0.0004	ControllerProductCategory	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 = '180356' AND p.status = '1'
43	0.0004	ControllerProductCategory	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 = '178537' AND p.status = '1'
44	0.0001	ControllerProductCategory	SELECT * FROM product_image WHERE product_id IN (178536) ORDER BY product_id, sort_order ASC
45	0.0003	ControllerProductCategory	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 = '178536' AND a.attribute_group_id = '8' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
46	0.0001	ControllerProductCategory	SELECT category_id FROM product_to_category WHERE product_id = '178536' ORDER BY main_category DESC LIMIT 1
47	0.0001	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=20' LIMIT 1
48	0.0001	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'product_id=178536' LIMIT 1
49	0.0001	ControllerProductCategory	SELECT * FROM product_image WHERE product_id IN (76756) ORDER BY product_id, sort_order ASC
50	0.0003	ControllerProductCategory	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 = '76756' AND a.attribute_group_id = '8' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
51	0.0001	ControllerProductCategory	SELECT category_id FROM product_to_category WHERE product_id = '76756' ORDER BY main_category DESC LIMIT 1
52	0.0001	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=20' LIMIT 1
53	0.0001	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'product_id=76756' LIMIT 1
54	0.0001	ControllerProductCategory	SELECT * FROM product_image WHERE product_id IN (168622) ORDER BY product_id, sort_order ASC
55	0.0003	ControllerProductCategory	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 = '168622' AND a.attribute_group_id = '8' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
56	0.0001	ControllerProductCategory	SELECT category_id FROM product_to_category WHERE product_id = '168622' ORDER BY main_category DESC LIMIT 1
57	0.0001	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=20' LIMIT 1
58	0.0001	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'product_id=168622' LIMIT 1
59	0.0001	ControllerProductCategory	SELECT * FROM product_image WHERE product_id IN (178535) ORDER BY product_id, sort_order ASC
60	0.0002	ControllerProductCategory	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 = '178535' AND a.attribute_group_id = '8' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
61	0.0001	ControllerProductCategory	SELECT category_id FROM product_to_category WHERE product_id = '178535' ORDER BY main_category DESC LIMIT 1
62	0.0001	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=20' LIMIT 1
63	0.0001	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'product_id=178535' LIMIT 1
64	0.0001	ControllerProductCategory	SELECT * FROM product_image WHERE product_id IN (180356) ORDER BY product_id, sort_order ASC
65	0.0002	ControllerProductCategory	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 = '180356' AND a.attribute_group_id = '8' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
66	0.0001	ControllerProductCategory	SELECT category_id FROM product_to_category WHERE product_id = '180356' ORDER BY main_category DESC LIMIT 1
67	0.0001	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=20' LIMIT 1
68	0.0001	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'product_id=180356' LIMIT 1
69	0.0001	ControllerProductCategory	SELECT * FROM product_image WHERE product_id IN (178537) ORDER BY product_id, sort_order ASC
70	0.0002	ControllerProductCategory	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 = '178537' AND a.attribute_group_id = '8' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
71	0.0001	ControllerProductCategory	SELECT category_id FROM product_to_category WHERE product_id = '178537' ORDER BY main_category DESC LIMIT 1
72	0.0001	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=20' LIMIT 1
73	0.0001	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'product_id=178537' LIMIT 1
74	0.0001	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=20' LIMIT 1
75	0.0001	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=20' LIMIT 1
76	0.0001	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=20' LIMIT 1
77	0.0001	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=20' LIMIT 1
78	0.0001	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=20' LIMIT 1
79	0.0001	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=20' LIMIT 1
80	0.0001	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=20' LIMIT 1
81	0.0001	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=20' LIMIT 1
82	0.0001	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=20' LIMIT 1
83	0.0001	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=20' LIMIT 1
84	0.0001	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=20' LIMIT 1
85	0.0001	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=20' LIMIT 1
86	0.0001	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=20' LIMIT 1
87	0.0001	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=20' LIMIT 1
88	0.0001	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=20' LIMIT 1
89	0.0001	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=20' LIMIT 1
90	0.0001	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=20' LIMIT 1
91	0.0001	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=20' LIMIT 1
92	0.0001	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=20' LIMIT 1
93	0.0001	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=20' LIMIT 1
94	0.0001	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=20' LIMIT 1
95	0.0001	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=20' LIMIT 1
96	0.0001	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=20' LIMIT 1
97	0.0001	ControllerEventCompatibility	SELECT c.category_id FROM category c LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '20' AND c2s.store_id = '0' LIMIT 1
98	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) WHERE p.status = '1' AND p.dynamic = '0' AND pd.language_id = '1' AND p.category_id = '20' AND p.category = '1' ORDER BY p.page_id DESC
99	0.0002	ControllerEventCompatibility	SELECT COUNT(DISTINCT p.product_id) AS total, p.manufacturer_id AS vid FROM product p LEFT JOIN product_to_category p2c ON (p.product_id = p2c.product_id) WHERE p.status = '1' AND p.catalog_output = '1' AND p2c.category_id = '20' GROUP BY vid
100	0.0003	ControllerEventCompatibility	SELECT COUNT(DISTINCT p.product_id) AS total, IF((p.quantity > 0 AND p.quantity <> 1000), '2', '1') AS vid FROM product p LEFT JOIN product_to_category p2c ON (p.product_id = p2c.product_id) WHERE p.status = '1' AND p.catalog_output = '1' AND p2c.category_id = '20' GROUP BY vid UNION SELECT COUNT(DISTINCT p.product_id) AS total, '3' AS vid FROM product p LEFT JOIN product_to_category p2c ON (p.product_id = p2c.product_id) WHERE p.status = '1' AND p.catalog_output = '1' AND p2c.category_id = '20' AND p.quantity_spb > 0 AND p.quantity_spb <> 1000 GROUP BY vid
101	0.0002	ControllerEventCompatibility	SELECT COUNT(DISTINCT p.product_id) AS total, CONCAT(fv2p.filter_id, '.', fv2p.source) AS fk, fv2p.value_id AS vid FROM ocfilter_filter_value_to_product fv2p LEFT JOIN product p ON (fv2p.product_id = p.product_id) LEFT JOIN product_to_category p2c ON (p.product_id = p2c.product_id) WHERE p.status = '1' AND p.catalog_output = '1' AND p2c.category_id = '20' GROUP BY fk, vid
102	0.0001	ControllerEventCompatibility	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'common/home' LIMIT 1
103	0.0001	ControllerCommonColumnLeft	SELECT * FROM category_to_layout WHERE category_id = '20'
104	0.0001	ControllerCommonColumnLeft	SELECT * FROM layout_route WHERE 'product/category' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1
105	0.0001	ControllerCommonColumnLeft	SELECT * FROM layout_module WHERE layout_id = '3' AND position = 'column_left' ORDER BY sort_order
106	0.0001	ControllerEventCompatibility	SELECT * FROM ocfilter_setting WHERE `key` = 'placement_layout'
107	0.0001	ControllerEventCompatibility	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=20' LIMIT 1
108	0.0002	ControllerEventCompatibility	SELECT COUNT(DISTINCT p.product_id) AS total, p.manufacturer_id AS vid FROM product p LEFT JOIN product_to_category p2c ON (p.product_id = p2c.product_id) WHERE p.status = '1' AND p.catalog_output = '1' AND p2c.category_id = '20' GROUP BY vid
109	0.0002	ControllerEventCompatibility	SELECT COUNT(DISTINCT p.product_id) AS total, IF((p.quantity > 0 AND p.quantity <> 1000), '2', '1') AS vid FROM product p LEFT JOIN product_to_category p2c ON (p.product_id = p2c.product_id) WHERE p.status = '1' AND p.catalog_output = '1' AND p2c.category_id = '20' GROUP BY vid UNION SELECT COUNT(DISTINCT p.product_id) AS total, '3' AS vid FROM product p LEFT JOIN product_to_category p2c ON (p.product_id = p2c.product_id) WHERE p.status = '1' AND p.catalog_output = '1' AND p2c.category_id = '20' AND p.quantity_spb > 0 AND p.quantity_spb <> 1000 GROUP BY vid
110	0.0002	ControllerEventCompatibility	SELECT COUNT(DISTINCT p.product_id) AS total, CONCAT(fv2p.filter_id, '.', fv2p.source) AS fk, fv2p.value_id AS vid FROM ocfilter_filter_value_to_product fv2p LEFT JOIN product p ON (fv2p.product_id = p.product_id) LEFT JOIN product_to_category p2c ON (p.product_id = p2c.product_id) WHERE p.status = '1' AND p.catalog_output = '1' AND p2c.category_id = '20' GROUP BY fk, vid
111	0.0002	ControllerEventCompatibility	SELECT CONCAT(f.filter_id, '.', f.source) AS filter_key FROM ocfilter_filter f LEFT JOIN ocfilter_filter_to_store f2s ON (f.filter_id = f2s.filter_id AND f.source = f2s.source) LEFT JOIN ocfilter_filter_to_category f2c ON (f.filter_id = f2c.filter_id) WHERE f.status = '1' AND f2s.store_id = '0' AND (f2c.category_id = '20' OR f2c.category_id = '0') GROUP BY f.filter_id, f.source
112	0.0001	ControllerEventCompatibility	SELECT `value` FROM ocfilter_cache WHERE `key` = '799108249'
113	0.0001	ControllerEventCompatibility	SELECT `value` FROM ocfilter_cache WHERE `key` = '3463394037'
114	0	ControllerEventCompatibility	SELECT `value` FROM ocfilter_cache WHERE `key` = '1432436729'
115	0	ControllerEventCompatibility	SELECT `value` FROM ocfilter_cache WHERE `key` = '3724481510'
116	0	ControllerEventCompatibility	SELECT `value` FROM ocfilter_cache WHERE `key` = '1830280939'
117	0.0001	ControllerEventCompatibility	SELECT `value` FROM ocfilter_cache WHERE `key` = '2457097422'
118	0.0001	ControllerEventCompatibility	SELECT `value` FROM ocfilter_cache WHERE `key` = '638545595'
119	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) WHERE p.status = '1' AND p.dynamic = '0' AND pd.language_id = '1' AND p.category_id = '20' AND p.module = '1' ORDER BY p.page_id DESC
120	0.0002	ControllerEventCompatibility	SELECT COUNT(DISTINCT p.product_id) AS total, p.manufacturer_id AS vid FROM product p LEFT JOIN product_to_category p2c ON (p.product_id = p2c.product_id) WHERE p.status = '1' AND p.catalog_output = '1' AND p2c.category_id = '20' GROUP BY vid
121	0.0003	ControllerEventCompatibility	SELECT COUNT(DISTINCT p.product_id) AS total, IF((p.quantity > 0 AND p.quantity <> 1000), '2', '1') AS vid FROM product p LEFT JOIN product_to_category p2c ON (p.product_id = p2c.product_id) WHERE p.status = '1' AND p.catalog_output = '1' AND p2c.category_id = '20' GROUP BY vid UNION SELECT COUNT(DISTINCT p.product_id) AS total, '3' AS vid FROM product p LEFT JOIN product_to_category p2c ON (p.product_id = p2c.product_id) WHERE p.status = '1' AND p.catalog_output = '1' AND p2c.category_id = '20' AND p.quantity_spb > 0 AND p.quantity_spb <> 1000 GROUP BY vid
122	0.0002	ControllerEventCompatibility	SELECT COUNT(DISTINCT p.product_id) AS total, CONCAT(fv2p.filter_id, '.', fv2p.source) AS fk, fv2p.value_id AS vid FROM ocfilter_filter_value_to_product fv2p LEFT JOIN product p ON (fv2p.product_id = p.product_id) LEFT JOIN product_to_category p2c ON (p.product_id = p2c.product_id) WHERE p.status = '1' AND p.catalog_output = '1' AND p2c.category_id = '20' GROUP BY fk, vid
123	0.0001	ControllerEventCompatibility	SELECT * FROM module WHERE module_id = '46'
124	0.0001	ControllerCommonColumnRight	SELECT * FROM category_to_layout WHERE category_id = '20'
125	0.0001	ControllerCommonColumnRight	SELECT * FROM layout_route WHERE 'product/category' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1
126	0.0001	ControllerCommonColumnRight	SELECT * FROM layout_module WHERE layout_id = '3' AND position = 'column_right' ORDER BY sort_order
127	0.0001	ControllerCommonContentTop	SELECT * FROM category_to_layout WHERE category_id = '20'
128	0.0001	ControllerCommonContentTop	SELECT * FROM layout_route WHERE 'product/category' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1
129	0.0001	ControllerCommonContentTop	SELECT * FROM layout_module WHERE layout_id = '3' AND position = 'content_top' ORDER BY sort_order
130	0.0001	ControllerCommonContentBottom	SELECT * FROM category_to_layout WHERE category_id = '20'
131	0.0001	ControllerCommonContentBottom	SELECT * FROM layout_route WHERE 'product/category' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1
132	0.0001	ControllerCommonContentBottom	SELECT * FROM layout_module WHERE layout_id = '3' AND position = 'content_bottom' ORDER BY sort_order
133	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
134	0.0006	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
135	0.0001	ControllerExtensionModuleOCFilter	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'information_id=22' LIMIT 1
136	0.0001	ControllerExtensionModuleOCFilter	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'information_id=21' LIMIT 1
137	0.0001	ControllerExtensionModuleOCFilter	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'information_id=14' LIMIT 1
138	0.0001	ControllerExtensionModuleOCFilter	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'information_id=23' LIMIT 1
139	0.0001	ControllerExtensionModuleOCFilter	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'information_id=8' LIMIT 1
140	0.0001	ControllerExtensionModuleOCFilter	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'information_id=6' LIMIT 1
141	0.0001	ControllerExtensionModuleOCFilter	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'information_id=9' LIMIT 1
142	0.0001	ControllerExtensionModuleOCFilter	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'information/contact' LIMIT 1
143	0.0001	ControllerExtensionModuleOCFilter	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'account/return/add' LIMIT 1
144	0.0001	ControllerExtensionModuleOCFilter	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'information/sitemap' LIMIT 1
145	0.0001	ControllerExtensionModuleOCFilter	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'product/manufacturer' LIMIT 1
146	0.0001	ControllerExtensionModuleOCFilter	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'account/voucher' LIMIT 1
147	0.0001	ControllerExtensionModuleOCFilter	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'affiliate/account' LIMIT 1
148	0.0001	ControllerExtensionModuleOCFilter	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'product/special' LIMIT 1
149	0.0001	ControllerExtensionModuleOCFilter	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'revolution/account/revaccount' LIMIT 1
150	0.0001	ControllerExtensionModuleOCFilter	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'account/order' LIMIT 1
151	0.0001	ControllerExtensionModuleOCFilter	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'account/wishlist' LIMIT 1
152	0.0001	ControllerExtensionModuleOCFilter	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'account/newsletter' LIMIT 1
153	0.0001	ControllerCommonHeader	SELECT * FROM extension WHERE `type` = 'analytics'
154	0.0001	ControllerCommonCartMobi	SELECT SUM(quantity) as total FROM cart WHERE api_id = '0' AND session_id = '306494fe5146b7398341be2ff55c530f'
155	0.0001	ControllerCommonCartMobi	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'checkout/cart' LIMIT 1
156	0.0001	ControllerCommonCartMobi	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'checkout/checkout' LIMIT 1
157	0.0001	ControllerExtensionModuleOCFilter	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'product/compare' LIMIT 1
158	0.0001	ControllerExtensionModuleOCFilter	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'revolution/account/revaccount' LIMIT 1
159	0.0001	ControllerExtensionModuleOCFilter	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'account/logout' LIMIT 1
160	0.0001	ControllerExtensionModuleOCFilter	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'common/home' LIMIT 1
161	0.0001	ControllerExtensionModuleOCFilter	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'account/wishlist' LIMIT 1
162	0.0001	ControllerExtensionModuleOCFilter	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'revolution/account/revaccount' LIMIT 1
163	0.0001	ControllerExtensionModuleOCFilter	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'revolution/account/revregister' LIMIT 1
164	0.0001	ControllerExtensionModuleOCFilter	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'account/login' LIMIT 1
165	0.0001	ControllerExtensionModuleOCFilter	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'account/order' LIMIT 1
166	0.0001	ControllerExtensionModuleOCFilter	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'account/transaction' LIMIT 1
167	0.0001	ControllerExtensionModuleOCFilter	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'account/download' LIMIT 1
168	0.0001	ControllerExtensionModuleOCFilter	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'account/logout' LIMIT 1
169	0.0001	ControllerExtensionModuleOCFilter	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'checkout/cart' LIMIT 1
170	0.0001	ControllerExtensionModuleOCFilter	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'checkout/checkout' LIMIT 1
171	0.0001	ControllerExtensionModuleOCFilter	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'information/contact' LIMIT 1
172	0.0001	ControllerCommonLanguage	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'common/language/language' LIMIT 1
173	0.0001	ControllerCommonLanguage	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=20' LIMIT 1
174	0.0001	ControllerCommonCurrency	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'common/currency/currency' LIMIT 1
175	0.0001	ControllerCommonCurrency	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=20' LIMIT 1
176	0.0005	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)
177	0.0001	ControllerCommonCart	SELECT * FROM cart WHERE api_id = '0' AND session_id = '306494fe5146b7398341be2ff55c530f'
178	0.0001	ControllerCommonCart	SELECT * FROM extension WHERE `type` = 'total'
179	0.0001	ControllerEventCompatibility	SELECT * FROM cart WHERE api_id = '0' AND session_id = '306494fe5146b7398341be2ff55c530f'
180	0.0001	ControllerEventCompatibility	SELECT SUM(quantity) as total FROM cart WHERE api_id = '0' AND session_id = '306494fe5146b7398341be2ff55c530f'
181	0.0001	ControllerEventCompatibility	SELECT * FROM cart WHERE api_id = '0' AND session_id = '306494fe5146b7398341be2ff55c530f'
182	0.0001	ControllerEventCompatibility	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'checkout/cart' LIMIT 1
183	0.0001	ControllerEventCompatibility	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'checkout/checkout' LIMIT 1
184	0.0001	ControllerExtensionModuleOCFilter	SELECT SUM(quantity) as total FROM cart WHERE api_id = '0' AND session_id = '306494fe5146b7398341be2ff55c530f'
185	0.0001	ControllerExtensionModuleFlamixBitrix24Integrations	SELECT * FROM setting WHERE store_id = '0' AND `code` = 'fx_b24'

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

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

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

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

Отмена

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

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

Отмена

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

Видеорегистратор Canbox X014 для подключения к магнитолам по USB (ADAS) Full HD 1080P В наличии Москва - Ташкентская 28с1 В наличии Питер - Придорожная аллея 8

Видеорегистратор Teyes X5-DVR для подключения к магнитолам Teyes по USB (ADAS) Full HD 1080P В наличии Москва - Ташкентская 28с1 В наличии Питер - Придорожная аллея 8

Видеорегистратор 720p для подключения к магнитолам Android по USB с поддержкой ADAS В наличии Москва - Ташкентская 28с1 В наличии Питер - Придорожная аллея 8

Видеорегистратор Canbox X016 для подключения к магнитолам по USB (ADAS) Full HD 1080P В наличии Москва - Ташкентская 28с1 В наличии Питер - Придорожная аллея 8

Видеорегистратор Canbox X014 для подключения к магнитолам по USB (ADAS) Full HD 1080P
В наличии Москва - Ташкентская 28с1
В наличии Питер - Придорожная аллея 8

Видеорегистратор Teyes X5-DVR для подключения к магнитолам Teyes по USB (ADAS) Full HD 1080P
В наличии Москва - Ташкентская 28с1
В наличии Питер - Придорожная аллея 8

Видеорегистратор 720p для подключения к магнитолам Android по USB с поддержкой ADAS
В наличии Москва - Ташкентская 28с1
В наличии Питер - Придорожная аллея 8

Видеорегистратор Canbox X016 для подключения к магнитолам по USB (ADAS) Full HD 1080P
В наличии Москва - Ташкентская 28с1
В наличии Питер - Придорожная аллея 8