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

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

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

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

Сортировка:

Показать:

Фильтр

В закладки

В сравнение

Камера SonyMCCD 170 градусов cam-140 для Lada XRAY 2015-2019 (Тип2)

Артикул: 153319

Камера SonyMCCD 170 градусов cam-140 для Lada XRAY 2015-2019 (Тип2)
В наличии Москва - Ташкентская 28с1

4 100 р.

В закладки

В сравнение

Камера Teyes SONY-AHD 1080p 170 градусов cam-043 для Nissan Qashqai, X-trail, Pathfinder, Note, Juke, Navara, Sunny, Patrol - Peugeot 207 / 307 (хетч) / 308 / 3008 / 407 / 408 / 508 / RCZ - Volkswagen Crafter - Lifan X60

Артикул: 127076

Камера Teyes SONY-AHD 1080p 170 градусов cam-043 для Nissan Qashqai, X-trail, Pathfinder, Note, Juke, Navara, Sunny, Patrol - Peugeot 207 / 307 (хетч) / 308 / 3008 / 407 / 408 / 508 / RCZ - Volkswagen Crafter - Lifan X60

4 200 р.

В закладки

В сравнение

Камера 4 LED 140 градусов cam-064 для BMW 3 E46 E90 F30 (98-16), 5 E39 E60 F10 (95-16), 7 E38 E65 F01 (94-15), X1 E84 F48 (09-17), X3 E83 F25 (03-17), X5 E53 E70 (99-13), X6 E71 (07-14)

Артикул: 90505

Камера 4 LED 140 градусов cam-064 для BMW 3 E46 E90 F30 (98-16), 5 E39 E60 F10 (95-16), 7 E38 E65 F01 (94-15), X1 E84 F48 (09-17), X3 E83 F25 (03-17), X5 E53 E70 (99-13), X6 E71 (07-14)
В наличии Москва - Ташкентская 28с1
В наличии Питер - Придорожная аллея 8

1 500 р.

В закладки

В сравнение

Камера SonyMCCD 170 градусов cam-125 для FAW X80

Артикул: 126342

Камера SonyMCCD 170 градусов cam-125 для FAW X80
В наличии Москва - Ташкентская 28с1
В наличии Питер - Придорожная аллея 8

4 100 р.

В закладки

В сравнение

Камера Canbox Sony AHD 1080p 170 градусов cam-024 для Opel Astra, Vectra, Zafira, Corsa, Insignia, Meriva (черный)

Артикул: 127243

Камера Canbox Sony AHD 1080p 170 градусов cam-024 для Opel Astra, Vectra, Zafira, Corsa, Insignia, Meriva (черный)
В наличии Москва - Ташкентская 28с1
В наличии Питер - Придорожная аллея 8

6 700 р.

В закладки

В сравнение

Камера Teyes AHD 1080p 150 градусов cam-043 Geely MK (2008-2015)

Артикул: 126920

Камера Teyes AHD 1080p 150 градусов cam-043 Geely MK (2008-2015)
В наличии Питер - Придорожная аллея 8

3 700 р.

В закладки

В сравнение

Камера 4 LED 140 градусов cam-012 для Chevrolet Aveo II (11-15), Cruze (08-15) хэтчбек, Cruze (12-15) универсал, TrailBlazer (12-16)

Артикул: 92448

Камера 4 LED 140 градусов cam-012 для Chevrolet Aveo II (11-15), Cruze (08-15) хэтчбек, Cruze (12-15) универсал, TrailBlazer (12-16)
В наличии Москва - Ташкентская 28с1
В наличии Питер - Придорожная аллея 8

1 500 р.

В закладки

В сравнение

Камера 4 LED 140 градусов cam-006 Toyota HighLander 08+

Артикул: 90545

Камера 4 LED 140 градусов cam-006 Toyota HighLander 08+
В наличии Москва - Ташкентская 28с1
В наличии Питер - Придорожная аллея 8

1 500 р.

В закладки

В сравнение

Камера Teyes AHD 1080p 150 градусов cam-130 для Lada XRAY 2015-2019

Артикул: 126935

Камера Teyes AHD 1080p 150 градусов cam-130 для Lada XRAY 2015-2019
В наличии Питер - Придорожная аллея 8

3 700 р.

В закладки

В сравнение

Камера Canbox AHD 1080p 150 градусов cam-094 Zotye T600 2013+

Артикул: 126680

Камера Canbox AHD 1080p 150 градусов cam-094 Zotye T600 2013+
В наличии Москва - 1 шт. Ташкентская 28с1
В наличии Питер - Придорожная аллея 8

5 500 р.

В закладки

В сравнение

Камера Teyes AHD 1080p 150 градусов cam-094 Zotye T600 2013+

Артикул: 126896

Камера Teyes AHD 1080p 150 градусов cam-094 Zotye T600 2013+
В наличии Питер - Придорожная аллея 8

3 700 р.

В закладки

В сравнение

Камера Teyes SONY-AHD 1080p 170 градусов cam-044 для Chevrolet Aveo I (03-11), Captiva (06-15), Cruze (08-15) седан, Epica (06-12), Orlando (10-15), Lacetti (04-13), Lanos (05-09), Spark (05-15)

Артикул: 127097

Камера Teyes SONY-AHD 1080p 170 градусов cam-044 для Chevrolet Aveo I (03-11), Captiva (06-15), Cruze (08-15) седан, Epica (06-12), Orlando (10-15), Lacetti (04-13), Lanos (05-09), Spark (05-15)

4 200 р.

В закладки

В сравнение

Камера 4 LED 140 градусов cam-095 Kia Rio 2017+

Артикул: 70118

Камера 4 LED 140 градусов cam-095 Kia Rio 2017+
В наличии Москва - Ташкентская 28с1
В наличии Питер - Придорожная аллея 8

1 500 р.

В закладки

В сравнение

Камера 4 LED 140 градусов cam-036 для Mazda 6 универсал (GH) (06-12), 6 седан (GG) (02-08), CX-5 (11+), CX-7 (06+), CX-9 (07+)

Артикул: 90523

Камера 4 LED 140 градусов cam-036 для Mazda 6 универсал (GH) (06-12), 6 седан (GG) (02-08), CX-5 (11+), CX-7 (06+), CX-9 (07+)
В наличии Москва - Ташкентская 28с1
В наличии Питер - Придорожная аллея 8

1 500 р.

В закладки

В сравнение

Камера Canbox Sony AHD 1080p 170 градусов cam-115 Geely MK Cross (2011-2016)

Артикул: 127229

Камера Canbox Sony AHD 1080p 170 градусов cam-115 Geely MK Cross (2011-2016)
В наличии Москва - Ташкентская 28с1

6 700 р.

В закладки

В сравнение

Камера SonyMCCD 170 градусов cam-075 Honda Accord

Артикул: 126433

Камера SonyMCCD 170 градусов cam-075 Honda Accord
В наличии Москва - Ташкентская 28с1

4 100 р.

В закладки

В сравнение

Камера 4 LED 140 градусов cam-026 для Honda Civic 8 4D (05-12) седан, Accord 8 (08-13), Accord 7 (02-08)

Артикул: 90511

Камера 4 LED 140 градусов cam-026 для Honda Civic 8 4D (05-12) седан, Accord 8 (08-13), Accord 7 (02-08)
В наличии Москва - Ташкентская 28с1
В наличии Питер - Придорожная аллея 8

1 500 р.

В закладки

В сравнение

Камера Canbox Sony AHD 1080p 170 градусов cam-025 для Hyundai i40 2011+ / Kia Optima 10-16, Sportage lV 2016+, Soul III 2019-2021, Ceed III 2018-2021

Артикул: 127149

Камера Canbox Sony AHD 1080p 170 градусов cam-025 для Hyundai i40 2011+ / Kia Optima 10-16, Sportage lV 2016+, Soul III 2019-2021, Ceed III 2018-2021
В наличии Москва - Ташкентская 28с1
В наличии Питер - Придорожная аллея 8

6 700 р.

Показать 18 36 60 100

Показано с 109 по 126 из 1091 (всего 61 страниц)

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

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

Почему Frontcam:

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

Надежность

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

Большой опыт

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

Оплата потом

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

Установка

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

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

Created by frontcam.ru

Total time: 0.1651 s | Queries: 260 | Slow queries (>0.003 s): 9

#	Query time (s)	Controller	Query
1	0.0001		SELECT value FROM setting WHERE store_id = '0' AND `key`='config_seo_url_type'
2	0		SET SQL_BIG_SELECTS = 1
3	0.0002		SHOW TABLES LIKE 'ocfilter_setting'
4	0.0001		SELECT * FROM ocfilter_setting
5	0.0001	ControllerStartupStartup	SELECT * FROM store WHERE REPLACE(`ssl`, 'www.', '') = 'https://frontcam.ru/'
6	0.0007	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.0002	ControllerEventCompatibility	SHOW TABLES LIKE 'cartkeeper'
17	0.0002	ControllerEventCompatibility	SHOW TABLES LIKE 'cartkeeper_share'
18	0.0001	ControllerEventCompatibility	DELETE FROM cartkeeper WHERE date_added < DATE_SUB(NOW(), INTERVAL '30' DAY)
19	0	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` = '09273c9cbbbe3a346603810c165e4f98' 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 = 'rear-view-camera/' LIMIT 1
26	0.0001	ControllerStartupSeoPro	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=70' 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 = '70' 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=70' LIMIT 1
30	0.0001	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'product/compare' LIMIT 1
31	0.0003	ControllerProductCategory	SELECT * FROM category c LEFT JOIN category_description cd ON (c.category_id = cd.category_id) WHERE c.parent_id = '70' 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 = '70'
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 = '70' AND c2s.store_id = '0' LIMIT 1
36	0.0031	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 = '70'
37	0.0054	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 = '70' GROUP BY p.product_id ORDER BY p.viewed DESC LIMIT 108,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 = '127569' 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 = '100407' 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 = '707' 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 = '99673' 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 = '100574' 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 = '100251' AND p.status = '1'
44	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 = '3662' AND p.status = '1'
45	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 = '747' AND p.status = '1'
46	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 = '100266' AND p.status = '1'
47	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 = '100011' AND p.status = '1'
48	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 = '100227' AND p.status = '1'
49	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 = '100428' AND p.status = '1'
50	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 = '12108' AND p.status = '1'
51	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 = '725' AND p.status = '1'
52	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 = '100560' AND p.status = '1'
53	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 = '99764' AND p.status = '1'
54	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 = '713' AND p.status = '1'
55	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 = '100480' AND p.status = '1'
56	0.0001	ControllerProductCategory	SELECT * FROM product_image WHERE product_id IN (12760, 127570, 127569) ORDER BY product_id, sort_order ASC
57	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 = '127569' AND a.attribute_group_id = '8' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
58	0.0001	ControllerProductCategory	SELECT category_id FROM product_to_category WHERE product_id = '127569' ORDER BY main_category DESC LIMIT 1
59	0.0001	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=70' LIMIT 1
60	0.0001	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'product_id=127569' LIMIT 1
61	0.0001	ControllerProductCategory	SELECT * FROM product_image WHERE product_id IN (76755, 48092, 100407) ORDER BY product_id, sort_order ASC
62	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 = '100407' AND a.attribute_group_id = '8' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
63	0.0001	ControllerProductCategory	SELECT category_id FROM product_to_category WHERE product_id = '100407' ORDER BY main_category DESC LIMIT 1
64	0.0001	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=70' LIMIT 1
65	0.0001	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'product_id=100407' LIMIT 1
66	0.0001	ControllerProductCategory	SELECT * FROM product_image WHERE product_id IN (8098, 48113, 707) ORDER BY product_id, sort_order ASC
67	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 = '707' AND a.attribute_group_id = '8' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
68	0.0001	ControllerProductCategory	SELECT category_id FROM product_to_category WHERE product_id = '707' ORDER BY main_category DESC LIMIT 1
69	0.0001	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=70' LIMIT 1
70	0.0001	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'product_id=707' LIMIT 1
71	0.0001	ControllerProductCategory	SELECT * FROM product_image WHERE product_id IN (12760, 48165, 99673) ORDER BY product_id, sort_order ASC
72	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 = '99673' AND a.attribute_group_id = '8' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
73	0.0001	ControllerProductCategory	SELECT category_id FROM product_to_category WHERE product_id = '99673' ORDER BY main_category DESC LIMIT 1
74	0.0001	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=70' LIMIT 1
75	0.0001	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'product_id=99673' LIMIT 1
76	0.0001	ControllerProductCategory	SELECT * FROM product_image WHERE product_id IN (125883, 48073, 100574) ORDER BY product_id, sort_order ASC
77	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 = '100574' AND a.attribute_group_id = '8' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
78	0.0001	ControllerProductCategory	SELECT category_id FROM product_to_category WHERE product_id = '100574' ORDER BY main_category DESC LIMIT 1
79	0.0001	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=70' LIMIT 1
80	0.0001	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'product_id=100574' LIMIT 1
81	0.0001	ControllerProductCategory	SELECT * FROM product_image WHERE product_id IN (76754, 48092, 100251) ORDER BY product_id, sort_order ASC
82	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 = '100251' AND a.attribute_group_id = '8' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
83	0.0001	ControllerProductCategory	SELECT category_id FROM product_to_category WHERE product_id = '100251' ORDER BY main_category DESC LIMIT 1
84	0.0001	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=70' LIMIT 1
85	0.0001	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'product_id=100251' LIMIT 1
86	0.0001	ControllerProductCategory	SELECT * FROM product_image WHERE product_id IN (8098, 48061, 3662) ORDER BY product_id, sort_order ASC
87	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 = '3662' AND a.attribute_group_id = '8' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
88	0.0001	ControllerProductCategory	SELECT category_id FROM product_to_category WHERE product_id = '3662' ORDER BY main_category DESC LIMIT 1
89	0.0001	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=70' LIMIT 1
90	0.0001	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'product_id=3662' LIMIT 1
91	0.0001	ControllerProductCategory	SELECT * FROM product_image WHERE product_id IN (8098, 48055, 747) ORDER BY product_id, sort_order ASC
92	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 = '747' AND a.attribute_group_id = '8' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
93	0.0001	ControllerProductCategory	SELECT category_id FROM product_to_category WHERE product_id = '747' ORDER BY main_category DESC LIMIT 1
94	0.0001	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=70' LIMIT 1
95	0.0001	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'product_id=747' LIMIT 1
96	0.0001	ControllerProductCategory	SELECT * FROM product_image WHERE product_id IN (76754, 48167, 100266) ORDER BY product_id, sort_order ASC
97	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 = '100266' AND a.attribute_group_id = '8' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
98	0.0001	ControllerProductCategory	SELECT category_id FROM product_to_category WHERE product_id = '100266' ORDER BY main_category DESC LIMIT 1
99	0.0001	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=70' LIMIT 1
100	0.0001	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'product_id=100266' LIMIT 1
101	0.0001	ControllerProductCategory	SELECT * FROM product_image WHERE product_id IN (47795, 48142, 100011) ORDER BY product_id, sort_order ASC
102	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 = '100011' AND a.attribute_group_id = '8' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
103	0.0001	ControllerProductCategory	SELECT category_id FROM product_to_category WHERE product_id = '100011' ORDER BY main_category DESC LIMIT 1
104	0.0001	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=70' LIMIT 1
105	0.0001	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'product_id=100011' LIMIT 1
106	0.0001	ControllerProductCategory	SELECT * FROM product_image WHERE product_id IN (76754, 48142, 100227) ORDER BY product_id, sort_order ASC
107	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 = '100227' AND a.attribute_group_id = '8' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
108	0.0001	ControllerProductCategory	SELECT category_id FROM product_to_category WHERE product_id = '100227' ORDER BY main_category DESC LIMIT 1
109	0.0001	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=70' LIMIT 1
110	0.0001	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'product_id=100227' LIMIT 1
111	0.0001	ControllerProductCategory	SELECT * FROM product_image WHERE product_id IN (76755, 48093, 100428) ORDER BY product_id, sort_order ASC
112	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 = '100428' AND a.attribute_group_id = '8' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
113	0.0001	ControllerProductCategory	SELECT category_id FROM product_to_category WHERE product_id = '100428' ORDER BY main_category DESC LIMIT 1
114	0.0001	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=70' LIMIT 1
115	0.0001	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'product_id=100428' LIMIT 1
116	0.0001	ControllerProductCategory	SELECT * FROM product_image WHERE product_id IN (8098, 48143, 12108) ORDER BY product_id, sort_order ASC
117	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 = '12108' AND a.attribute_group_id = '8' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
118	0.0001	ControllerProductCategory	SELECT category_id FROM product_to_category WHERE product_id = '12108' ORDER BY main_category DESC LIMIT 1
119	0.0001	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=70' LIMIT 1
120	0.0001	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'product_id=12108' LIMIT 1
121	0.0001	ControllerProductCategory	SELECT * FROM product_image WHERE product_id IN (8098, 48085, 725) ORDER BY product_id, sort_order ASC
122	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 = '725' AND a.attribute_group_id = '8' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
123	0.0001	ControllerProductCategory	SELECT category_id FROM product_to_category WHERE product_id = '725' ORDER BY main_category DESC LIMIT 1
124	0.0001	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=70' LIMIT 1
125	0.0001	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'product_id=725' LIMIT 1
126	0.0001	ControllerProductCategory	SELECT * FROM product_image WHERE product_id IN (125883, 48158, 100560) ORDER BY product_id, sort_order ASC
127	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 = '100560' AND a.attribute_group_id = '8' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
128	0.0001	ControllerProductCategory	SELECT category_id FROM product_to_category WHERE product_id = '100560' ORDER BY main_category DESC LIMIT 1
129	0.0001	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=70' LIMIT 1
130	0.0001	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'product_id=100560' LIMIT 1
131	0.0001	ControllerProductCategory	SELECT * FROM product_image WHERE product_id IN (12760, 48124, 99764) ORDER BY product_id, sort_order ASC
132	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 = '99764' AND a.attribute_group_id = '8' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
133	0.0001	ControllerProductCategory	SELECT category_id FROM product_to_category WHERE product_id = '99764' ORDER BY main_category DESC LIMIT 1
134	0.0001	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=70' LIMIT 1
135	0.0001	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'product_id=99764' LIMIT 1
136	0.0001	ControllerProductCategory	SELECT * FROM product_image WHERE product_id IN (8098, 48075, 713) ORDER BY product_id, sort_order ASC
137	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 = '713' AND a.attribute_group_id = '8' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
138	0.0001	ControllerProductCategory	SELECT category_id FROM product_to_category WHERE product_id = '713' ORDER BY main_category DESC LIMIT 1
139	0.0001	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=70' LIMIT 1
140	0.0001	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'product_id=713' LIMIT 1
141	0.0001	ControllerProductCategory	SELECT * FROM product_image WHERE product_id IN (125883, 48074, 100480) ORDER BY product_id, sort_order ASC
142	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 = '100480' AND a.attribute_group_id = '8' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
143	0.0001	ControllerProductCategory	SELECT category_id FROM product_to_category WHERE product_id = '100480' ORDER BY main_category DESC LIMIT 1
144	0.0001	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=70' LIMIT 1
145	0.0001	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'product_id=100480' LIMIT 1
146	0.0001	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=70' LIMIT 1
147	0.0001	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=70' LIMIT 1
148	0.0001	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=70' LIMIT 1
149	0.0001	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=70' LIMIT 1
150	0.0001	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=70' LIMIT 1
151	0.0001	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=70' LIMIT 1
152	0.0001	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=70' LIMIT 1
153	0.0001	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=70' LIMIT 1
154	0.0001	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=70' LIMIT 1
155	0.0001	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=70' LIMIT 1
156	0.0001	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=70' LIMIT 1
157	0.0001	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=70' LIMIT 1
158	0.0001	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=70' LIMIT 1
159	0.0001	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=70' LIMIT 1
160	0.0001	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=70' LIMIT 1
161	0.0001	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=70' LIMIT 1
162	0.0001	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=70' LIMIT 1
163	0.0001	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=70' LIMIT 1
164	0.0001	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=70' LIMIT 1
165	0.0001	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=70' LIMIT 1
166	0.0001	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=70' LIMIT 1
167	0.0001	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=70' LIMIT 1
168	0.0001	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=70' LIMIT 1
169	0.0001	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=70' LIMIT 1
170	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 = '70' AND c2s.store_id = '0' LIMIT 1
171	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 = '70' AND p.category = '1' ORDER BY p.page_id DESC
172	0.0032	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 = '70' GROUP BY vid
173	0.0039	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 = '70' 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 = '70' AND p.quantity_spb > 0 AND p.quantity_spb <> 1000 GROUP BY vid
174	0.0062	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 = '70' GROUP BY fk, vid
175	0.0001	ControllerEventCompatibility	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'common/home' LIMIT 1
176	0.0001	ControllerCommonColumnLeft	SELECT * FROM category_to_layout WHERE category_id = '70'
177	0.0001	ControllerCommonColumnLeft	SELECT * FROM layout_route WHERE 'product/category' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1
178	0.0001	ControllerCommonColumnLeft	SELECT * FROM layout_module WHERE layout_id = '3' AND position = 'column_left' ORDER BY sort_order
179	0.0001	ControllerEventCompatibility	SELECT * FROM ocfilter_setting WHERE `key` = 'placement_layout'
180	0.0001	ControllerEventCompatibility	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=70' LIMIT 1
181	0.0017	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 = '70' GROUP BY vid
182	0.0034	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 = '70' 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 = '70' AND p.quantity_spb > 0 AND p.quantity_spb <> 1000 GROUP BY vid
183	0.006	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 = '70' GROUP BY fk, vid
184	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 = '70' OR f2c.category_id = '0') GROUP BY f.filter_id, f.source
185	0.0001	ControllerEventCompatibility	SELECT `value` FROM ocfilter_cache WHERE `key` = '799108249'
186	0.0001	ControllerEventCompatibility	SELECT `value` FROM ocfilter_cache WHERE `key` = '3463394037'
187	0.0001	ControllerEventCompatibility	SELECT `value` FROM ocfilter_cache WHERE `key` = '1432436729'
188	0	ControllerEventCompatibility	SELECT `value` FROM ocfilter_cache WHERE `key` = '404557709'
189	0	ControllerEventCompatibility	SELECT `value` FROM ocfilter_cache WHERE `key` = '2843840328'
190	0.0001	ControllerEventCompatibility	SELECT `value` FROM ocfilter_cache WHERE `key` = '1830280939'
191	0.0001	ControllerEventCompatibility	SELECT `value` FROM ocfilter_cache WHERE `key` = '4147604048'
192	0.0001	ControllerEventCompatibility	SELECT `value` FROM ocfilter_cache WHERE `key` = '3358408399'
193	0.0001	ControllerEventCompatibility	SELECT `value` FROM ocfilter_cache WHERE `key` = '4185946581'
194	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) WHERE p.status = '1' AND p.dynamic = '0' AND pd.language_id = '1' AND p.category_id = '70' AND p.module = '1' ORDER BY p.page_id DESC
195	0.0019	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 = '70' GROUP BY vid
196	0.0034	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 = '70' 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 = '70' AND p.quantity_spb > 0 AND p.quantity_spb <> 1000 GROUP BY vid
197	0.0059	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 = '70' GROUP BY fk, vid
198	0.0001	ControllerEventCompatibility	SELECT * FROM module WHERE module_id = '46'
199	0.0001	ControllerCommonColumnRight	SELECT * FROM category_to_layout WHERE category_id = '70'
200	0.0001	ControllerCommonColumnRight	SELECT * FROM layout_route WHERE 'product/category' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1
201	0.0001	ControllerCommonColumnRight	SELECT * FROM layout_module WHERE layout_id = '3' AND position = 'column_right' ORDER BY sort_order
202	0.0001	ControllerCommonContentTop	SELECT * FROM category_to_layout WHERE category_id = '70'
203	0.0001	ControllerCommonContentTop	SELECT * FROM layout_route WHERE 'product/category' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1
204	0.0001	ControllerCommonContentTop	SELECT * FROM layout_module WHERE layout_id = '3' AND position = 'content_top' ORDER BY sort_order
205	0.0001	ControllerCommonContentBottom	SELECT * FROM category_to_layout WHERE category_id = '70'
206	0.0001	ControllerCommonContentBottom	SELECT * FROM layout_route WHERE 'product/category' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1
207	0.0001	ControllerCommonContentBottom	SELECT * FROM layout_module WHERE layout_id = '3' AND position = 'content_bottom' ORDER BY sort_order
208	0.0002	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
209	0.0007	ControllerExtensionModuleOCFilter	SELECT * FROM information i LEFT JOIN information_description id ON (i.information_id = id.information_id) LEFT JOIN information_to_store i2s ON (i.information_id = i2s.information_id) WHERE id.language_id = '1' AND i2s.store_id = '0' AND i.status = '1' ORDER BY i.sort_order, LCASE(id.title) ASC
210	0.0001	ControllerExtensionModuleOCFilter	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'information_id=22' LIMIT 1
211	0.0001	ControllerExtensionModuleOCFilter	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'information_id=21' LIMIT 1
212	0.0001	ControllerExtensionModuleOCFilter	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'information_id=14' LIMIT 1
213	0.0001	ControllerExtensionModuleOCFilter	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'information_id=23' LIMIT 1
214	0.0001	ControllerExtensionModuleOCFilter	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'information_id=8' LIMIT 1
215	0.0001	ControllerExtensionModuleOCFilter	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'information_id=6' LIMIT 1
216	0.0001	ControllerExtensionModuleOCFilter	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'information_id=9' LIMIT 1
217	0.0001	ControllerExtensionModuleOCFilter	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'information/contact' LIMIT 1
218	0.0001	ControllerExtensionModuleOCFilter	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'account/return/add' LIMIT 1
219	0.0001	ControllerExtensionModuleOCFilter	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'information/sitemap' LIMIT 1
220	0.0001	ControllerExtensionModuleOCFilter	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'product/manufacturer' LIMIT 1
221	0.0001	ControllerExtensionModuleOCFilter	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'account/voucher' LIMIT 1
222	0.0001	ControllerExtensionModuleOCFilter	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'affiliate/account' LIMIT 1
223	0.0001	ControllerExtensionModuleOCFilter	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'product/special' LIMIT 1
224	0.0001	ControllerExtensionModuleOCFilter	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'revolution/account/revaccount' LIMIT 1
225	0.0001	ControllerExtensionModuleOCFilter	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'account/order' LIMIT 1
226	0.0001	ControllerExtensionModuleOCFilter	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'account/wishlist' LIMIT 1
227	0.0001	ControllerExtensionModuleOCFilter	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'account/newsletter' LIMIT 1
228	0.0001	ControllerCommonHeader	SELECT * FROM extension WHERE `type` = 'analytics'
229	0.0001	ControllerCommonCartMobi	SELECT SUM(quantity) as total FROM cart WHERE api_id = '0' AND session_id = '09273c9cbbbe3a346603810c165e4f98'
230	0.0001	ControllerCommonCartMobi	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'checkout/cart' LIMIT 1
231	0.0001	ControllerCommonCartMobi	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'checkout/checkout' LIMIT 1
232	0.0001	ControllerExtensionModuleOCFilter	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'product/compare' LIMIT 1
233	0.0001	ControllerExtensionModuleOCFilter	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'revolution/account/revaccount' LIMIT 1
234	0.0001	ControllerExtensionModuleOCFilter	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'account/logout' LIMIT 1
235	0.0001	ControllerExtensionModuleOCFilter	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'common/home' LIMIT 1
236	0.0001	ControllerExtensionModuleOCFilter	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'account/wishlist' LIMIT 1
237	0.0001	ControllerExtensionModuleOCFilter	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'revolution/account/revaccount' LIMIT 1
238	0.0001	ControllerExtensionModuleOCFilter	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'revolution/account/revregister' LIMIT 1
239	0.0001	ControllerExtensionModuleOCFilter	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'account/login' LIMIT 1
240	0.0001	ControllerExtensionModuleOCFilter	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'account/order' LIMIT 1
241	0.0001	ControllerExtensionModuleOCFilter	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'account/transaction' LIMIT 1
242	0.0001	ControllerExtensionModuleOCFilter	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'account/download' LIMIT 1
243	0.0001	ControllerExtensionModuleOCFilter	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'account/logout' LIMIT 1
244	0.0001	ControllerExtensionModuleOCFilter	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'checkout/cart' LIMIT 1
245	0.0001	ControllerExtensionModuleOCFilter	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'checkout/checkout' LIMIT 1
246	0.0001	ControllerExtensionModuleOCFilter	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'information/contact' LIMIT 1
247	0.0001	ControllerCommonLanguage	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'common/language/language' LIMIT 1
248	0.0001	ControllerCommonLanguage	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=70' LIMIT 1
249	0.0001	ControllerCommonCurrency	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'common/currency/currency' LIMIT 1
250	0.0001	ControllerCommonCurrency	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=70' LIMIT 1
251	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)
252	0.0001	ControllerCommonCart	SELECT * FROM cart WHERE api_id = '0' AND session_id = '09273c9cbbbe3a346603810c165e4f98'
253	0.0001	ControllerCommonCart	SELECT * FROM extension WHERE `type` = 'total'
254	0.0001	ControllerEventCompatibility	SELECT * FROM cart WHERE api_id = '0' AND session_id = '09273c9cbbbe3a346603810c165e4f98'
255	0.0001	ControllerEventCompatibility	SELECT SUM(quantity) as total FROM cart WHERE api_id = '0' AND session_id = '09273c9cbbbe3a346603810c165e4f98'
256	0.0001	ControllerEventCompatibility	SELECT * FROM cart WHERE api_id = '0' AND session_id = '09273c9cbbbe3a346603810c165e4f98'
257	0.0001	ControllerEventCompatibility	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'checkout/cart' LIMIT 1
258	0.0001	ControllerEventCompatibility	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'checkout/checkout' LIMIT 1
259	0.0001	ControllerExtensionModuleOCFilter	SELECT SUM(quantity) as total FROM cart WHERE api_id = '0' AND session_id = '09273c9cbbbe3a346603810c165e4f98'
260	0.0001	ControllerExtensionModuleFlamixBitrix24Integrations	SELECT * FROM setting WHERE store_id = '0' AND `code` = 'fx_b24'

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

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

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

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

Отмена

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

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

Отмена

Автомобильные камеры заднего вида

Камера SonyMCCD 170 градусов cam-140 для Lada XRAY 2015-2019 (Тип2) В наличии Москва - Ташкентская 28с1

Камера Teyes SONY-AHD 1080p 170 градусов cam-043 для Nissan Qashqai, X-trail, Pathfinder, Note, Juke, Navara, Sunny, Patrol - Peugeot 207 / 307 (хетч) / 308 / 3008 / 407 / 408 / 508 / RCZ - Volkswagen Crafter - Lifan X60

Камера SonyMCCD 170 градусов cam-125 для FAW X80 В наличии Москва - Ташкентская 28с1 В наличии Питер - Придорожная аллея 8

Камера Canbox Sony AHD 1080p 170 градусов cam-024 для Opel Astra, Vectra, Zafira, Corsa, Insignia, Meriva (черный) В наличии Москва - Ташкентская 28с1 В наличии Питер - Придорожная аллея 8

Камера Teyes AHD 1080p 150 градусов cam-043 Geely MK (2008-2015) В наличии Питер - Придорожная аллея 8

Камера 4 LED 140 градусов cam-012 для Chevrolet Aveo II (11-15), Cruze (08-15) хэтчбек, Cruze (12-15) универсал, TrailBlazer (12-16) В наличии Москва - Ташкентская 28с1 В наличии Питер - Придорожная аллея 8

Камера 4 LED 140 градусов cam-006 Toyota HighLander 08+ В наличии Москва - Ташкентская 28с1 В наличии Питер - Придорожная аллея 8

Камера Teyes AHD 1080p 150 градусов cam-130 для Lada XRAY 2015-2019 В наличии Питер - Придорожная аллея 8

Камера Canbox AHD 1080p 150 градусов cam-094 Zotye T600 2013+ В наличии Москва - 1 шт. Ташкентская 28с1 В наличии Питер - Придорожная аллея 8

Камера Teyes AHD 1080p 150 градусов cam-094 Zotye T600 2013+ В наличии Питер - Придорожная аллея 8

Камера Teyes SONY-AHD 1080p 170 градусов cam-044 для Chevrolet Aveo I (03-11), Captiva (06-15), Cruze (08-15) седан, Epica (06-12), Orlando (10-15), Lacetti (04-13), Lanos (05-09), Spark (05-15)

Камера 4 LED 140 градусов cam-095 Kia Rio 2017+ В наличии Москва - Ташкентская 28с1 В наличии Питер - Придорожная аллея 8

Камера 4 LED 140 градусов cam-036 для Mazda 6 универсал (GH) (06-12), 6 седан (GG) (02-08), CX-5 (11+), CX-7 (06+), CX-9 (07+) В наличии Москва - Ташкентская 28с1 В наличии Питер - Придорожная аллея 8

Камера Canbox Sony AHD 1080p 170 градусов cam-115 Geely MK Cross (2011-2016) В наличии Москва - Ташкентская 28с1

Камера SonyMCCD 170 градусов cam-075 Honda Accord В наличии Москва - Ташкентская 28с1

Камера 4 LED 140 градусов cam-026 для Honda Civic 8 4D (05-12) седан, Accord 8 (08-13), Accord 7 (02-08) В наличии Москва - Ташкентская 28с1 В наличии Питер - Придорожная аллея 8

Камера Canbox Sony AHD 1080p 170 градусов cam-025 для Hyundai i40 2011+ / Kia Optima 10-16, Sportage lV 2016+, Soul III 2019-2021, Ceed III 2018-2021 В наличии Москва - Ташкентская 28с1 В наличии Питер - Придорожная аллея 8

Камера SonyMCCD 170 градусов cam-140 для Lada XRAY 2015-2019 (Тип2)
В наличии Москва - Ташкентская 28с1

Камера SonyMCCD 170 градусов cam-125 для FAW X80
В наличии Москва - Ташкентская 28с1
В наличии Питер - Придорожная аллея 8

Камера Canbox Sony AHD 1080p 170 градусов cam-024 для Opel Astra, Vectra, Zafira, Corsa, Insignia, Meriva (черный)
В наличии Москва - Ташкентская 28с1
В наличии Питер - Придорожная аллея 8

Камера Teyes AHD 1080p 150 градусов cam-043 Geely MK (2008-2015)
В наличии Питер - Придорожная аллея 8

Камера 4 LED 140 градусов cam-012 для Chevrolet Aveo II (11-15), Cruze (08-15) хэтчбек, Cruze (12-15) универсал, TrailBlazer (12-16)
В наличии Москва - Ташкентская 28с1
В наличии Питер - Придорожная аллея 8

Камера 4 LED 140 градусов cam-006 Toyota HighLander 08+
В наличии Москва - Ташкентская 28с1
В наличии Питер - Придорожная аллея 8

Камера Teyes AHD 1080p 150 градусов cam-130 для Lada XRAY 2015-2019
В наличии Питер - Придорожная аллея 8

Камера Canbox AHD 1080p 150 градусов cam-094 Zotye T600 2013+
В наличии Москва - 1 шт. Ташкентская 28с1
В наличии Питер - Придорожная аллея 8

Камера Teyes AHD 1080p 150 градусов cam-094 Zotye T600 2013+
В наличии Питер - Придорожная аллея 8

Камера 4 LED 140 градусов cam-095 Kia Rio 2017+
В наличии Москва - Ташкентская 28с1
В наличии Питер - Придорожная аллея 8

Камера 4 LED 140 градусов cam-036 для Mazda 6 универсал (GH) (06-12), 6 седан (GG) (02-08), CX-5 (11+), CX-7 (06+), CX-9 (07+)
В наличии Москва - Ташкентская 28с1
В наличии Питер - Придорожная аллея 8

Камера Canbox Sony AHD 1080p 170 градусов cam-115 Geely MK Cross (2011-2016)
В наличии Москва - Ташкентская 28с1

Камера SonyMCCD 170 градусов cam-075 Honda Accord
В наличии Москва - Ташкентская 28с1

Камера 4 LED 140 градусов cam-026 для Honda Civic 8 4D (05-12) седан, Accord 8 (08-13), Accord 7 (02-08)
В наличии Москва - Ташкентская 28с1
В наличии Питер - Придорожная аллея 8

Камера Canbox Sony AHD 1080p 170 градусов cam-025 для Hyundai i40 2011+ / Kia Optima 10-16, Sportage lV 2016+, Soul III 2019-2021, Ceed III 2018-2021
В наличии Москва - Ташкентская 28с1
В наличии Питер - Придорожная аллея 8