Антенна модель В2 FM (широкий приемный элемент), Модель В2 FM приёмные элементы BOSCH

Name: Антенна модель В2 FM (широкий приемный элемент), Модель В2 FM приёмные элементы BOSCH
Brand: WarCam
SKU: 35414
Price: 1500 RUB
Availability: InStock

Артикул: 35414

Наличие: Актуальная модель

Производитель: WarCam

Все товары данного производителя

Бесплатная доставка по России

Оплата при получении! Отправка в день заказа!

Гарантия 1 год от производителя!

Техподдержка на все время пользования!

Купи и установи в одном месте!

Список центров в Москве

Обмен/возврат 14 дней!

Дополнительная информация

1 500 р.

Быстрый заказ

Купить оптом

Обзоры наших работ

Магнитола Canbox PRO-Line 2K 4254 для Citroen SpaceTourer на ANDROID с системой кругового обзора 360

Магнитола Canbox L-Line 4167 для Chevrolet Tahoe 3 на ANDROID

Магнитола Canbox H-Line 5627 на Chevrolet Captiva на ANDROID в стиле Тесла с круговым обзором 360 3D

Описание Антенна модель В2 FM (широкий приемный элемент), Модель В2 FM приёмные элементы BOSCH

Приёмные элементы данной антенны проектировались для приёма ТВ сигнала метрового диапазона, что позволяет очень качественно и на большом удалении принимать FM диапазон.

Учитывая применяемый в антенной системе мощный и качественный усилитель, а так же оптимально подобранные приёмные элементы с серебряной антенной решёткой, данная антенна является бескомпромиссной антенной системой для приёма FM диапазона в самых сложных условиях.

В равнинной местности антенна В2 FM позволяет принимать УКВ/FM диапазон при удалении до 120 км. от передающей вышки.

Внутренняя установка
Прозрачные приёмные элементы
Надёжная фиксация на лобовом стекле
Установка в угол или центр лобового стекла

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

рабочие диапазоны	УКВ, СВ, ДВ, FM, AM
усиление	15 дБ.
выходное сопротивление	75 Ом.
длина/диаметр кабеля	3 м./3,5мм.
питание	10-14,5В
ток потребления	50 мА
размеры корпуса	39х40х15 мм.
размеры приемных элем.	480х18мм (2шт.)

1 500 р.

Отзывы Антенна модель В2 FM (широкий приемный элемент), Модель В2 FM приёмные элементы BOSCH

Нет отзывов об этом товаре.

Написать отзыв

Ваше имя:

Рейтинг

Ваш отзыв

Остались вопросы?

Если у вас есть вопросы, используйте
обратный звонок!

Отзывы о магазине

Читайте отзывы о нашем магазине!
Так же можно оставить свой отзыв!

Смотреть/Написать отзыв(ы)

Query time (s)

Controller

Query

0.0058

SELECT value FROM oc_setting WHERE store_id = '0' AND `key`='config_seo_url_type'

0.0001

SET SQL_BIG_SELECTS = 1

0.0006

SHOW TABLES LIKE 'oc_ocfilter_setting'

0.0007

SELECT * FROM oc_ocfilter_setting

0.0005

ControllerStartupStartup

SELECT * FROM oc_store WHERE REPLACE(`ssl`, 'www.', '') = 'https://warcam.ru/'

0.0086

ControllerStartupStartup

SELECT * FROM `oc_setting` WHERE store_id = '0' OR store_id = '0' ORDER BY store_id ASC

0.0005

ControllerExtensionModuleProgromanCityManager

SELECT * FROM oc_currency

0.0008

ControllerExtensionModuleProgromanCityManager

SELECT tr1.tax_class_id, tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority FROM oc_tax_rule tr1 LEFT JOIN oc_tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id) INNER JOIN oc_tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id) LEFT JOIN oc_zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id) LEFT JOIN oc_geo_zone gz ON (tr2.geo_zone_id = gz.geo_zone_id) WHERE tr1.based = 'shipping' AND tr2cg.customer_group_id = '1' AND z2gz.country_id = '176' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '2761') ORDER BY tr1.priority ASC

0.0008

ControllerExtensionModuleProgromanCityManager

SELECT tr1.tax_class_id, tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority FROM oc_tax_rule tr1 LEFT JOIN oc_tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id) INNER JOIN oc_tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id) LEFT JOIN oc_zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id) LEFT JOIN oc_geo_zone gz ON (tr2.geo_zone_id = gz.geo_zone_id) WHERE tr1.based = 'payment' AND tr2cg.customer_group_id = '1' AND z2gz.country_id = '176' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '2761') ORDER BY tr1.priority ASC

0.0007

ControllerExtensionModuleProgromanCityManager

SELECT tr1.tax_class_id, tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority FROM oc_tax_rule tr1 LEFT JOIN oc_tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id) INNER JOIN oc_tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id) LEFT JOIN oc_zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id) LEFT JOIN oc_geo_zone gz ON (tr2.geo_zone_id = gz.geo_zone_id) WHERE tr1.based = 'store' AND tr2cg.customer_group_id = '1' AND z2gz.country_id = '176' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '2761') ORDER BY tr1.priority ASC

0.0005

ControllerExtensionModuleProgromanCityManager

SELECT * FROM oc_weight_class wc LEFT JOIN oc_weight_class_description wcd ON (wc.weight_class_id = wcd.weight_class_id) WHERE wcd.language_id = '1'

0.0003

ControllerExtensionModuleProgromanCityManager

SELECT * FROM oc_length_class mc LEFT JOIN oc_length_class_description mcd ON (mc.length_class_id = mcd.length_class_id) WHERE mcd.language_id = '1'

0.0002

ControllerExtensionModuleProgromanCityManager

DELETE FROM oc_cart WHERE date_added < DATE_SUB(NOW(), INTERVAL '30' DAY)

0.0007

ControllerExtensionModuleProgromanCityManager

SHOW TABLES LIKE 'oc_cartkeeper'

0.0011

ControllerExtensionModuleProgromanCityManager

SHOW TABLES LIKE 'oc_cartkeeper_share'

0.0007

ControllerExtensionModuleProgromanCityManager

DELETE FROM oc_cartkeeper WHERE date_added < DATE_SUB(NOW(), INTERVAL '30' DAY)

0.0001

ControllerExtensionModuleProgromanCityManager

DELETE FROM oc_cartkeeper_share WHERE customer_id = '0' AND date_added < DATE_SUB(NOW(), INTERVAL '3' DAY)

0.0002

ControllerExtensionModuleProgromanCityManager

DELETE FROM oc_cartkeeper_share WHERE customer_id != '0' AND date_added < DATE_SUB(NOW(), INTERVAL '14' DAY)

0.0002

ControllerExtensionModuleProgromanCityManager

SELECT `session_id` FROM `oc_cart` WHERE `session_id` = '9abadb58776c56053ecbca40939b4bad' LIMIT 1

0.0003

ControllerStartupEvent

SELECT * FROM `oc_event` WHERE `trigger` LIKE 'catalog/%' AND status = '1' ORDER BY `event_id` ASC

0.0102

ControllerStartupSeoPro

SELECT category_id, parent_id FROM oc_category ORDER BY parent_id

0.0004

ControllerStartupSeoPro

SELECT query FROM oc_url_alias WHERE keyword = 'drugiye-kategorii' LIMIT 1

0.0002

ControllerStartupSeoPro

SELECT query FROM oc_url_alias WHERE keyword = 'antenna-model-v2-fm-shirokiy-priemnyy-element-model-v2-fm-priemnye-elementy-bosch' LIMIT 1

0.0001

ControllerStartupSeoPro

SELECT query FROM oc_url_alias WHERE keyword = 'drugiye-kategorii/antenna-model-v2-fm-shirokiy-priemnyy-element-model-v2-fm-priemnye-elementy-bosch' LIMIT 1

0.0002

ControllerStartupSeoPro

SELECT category_id FROM oc_product_to_category WHERE product_id = '43857' ORDER BY main_category DESC LIMIT 1

0.0002

ControllerStartupSeoPro

SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=64' LIMIT 1

0.0001

ControllerStartupSeoPro

SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'product_id=43857' LIMIT 1

0.0002

ControllerProductProduct

SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'common/home' LIMIT 1

0.0003

ControllerProductProduct

SELECT DISTINCT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.category_id = '64' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'

0.0005

ControllerProductProduct

SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=64' LIMIT 1

0.0004

ControllerProductProduct

SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'common/home' LIMIT 1

0.0003

ControllerProductProduct

SELECT MAX(category_id) as category_id FROM oc_product_to_category WHERE product_id =43857

0.0003

ControllerProductProduct

SELECT parent_id FROM oc_category WHERE category_id =1458

0.0003

ControllerProductProduct

SELECT parent_id FROM oc_category WHERE category_id =64

0.0004

ControllerProductProduct

0.0003

ControllerProductProduct

SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=64' LIMIT 1

0.0004

ControllerProductProduct

SELECT DISTINCT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.category_id = '1458' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'

0.0004

ControllerProductProduct

SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=64' LIMIT 1

0.0003

ControllerProductProduct

SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=1458' LIMIT 1

0.0014

ControllerProductProduct

SELECT DISTINCT *, pd.name AS name, p.image, m.image AS manufacturer_image, (SELECT md.name FROM oc_manufacturer_description md WHERE md.manufacturer_id = p.manufacturer_id AND md.language_id = '1') AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_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, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM oc_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 oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '43857' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'

0.0006

ControllerProductProduct

SELECT p2c.product_id, p2c.category_id, p2c.main_category FROM oc_product_to_category p2c LEFT JOIN oc_category_description cd ON (p2c.category_id = cd.category_id) WHERE product_id = '43857' ORDER BY cd.name ASC

0.001

ControllerProductProduct

0.0005

ControllerProductProduct

SELECT DISTINCT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.category_id = '1458' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'

0.0004

ControllerProductProduct

SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=64' LIMIT 1

0.0003

ControllerProductProduct

SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=1458' LIMIT 1

0.0004

ControllerProductProduct

SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'captcha/basic_captcha/captcha' LIMIT 1

0.0006

ControllerProductProduct

SELECT SQL_CALC_FOUND_ROWS q.* FROM oc_qa q INNER JOIN oc_qa_to_store q2s ON (q.qa_id = q2s.qa_id) LEFT JOIN oc_product p ON (q.product_id = p.product_id) WHERE p.product_id = '43857' AND q2s.store_id = '0' AND q.status = '1' ORDER BY q.date_asked DESC

0.0001

ControllerProductProduct

SELECT FOUND_ROWS() AS count

0.0005

ControllerProductProduct

SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'product_id=43857' LIMIT 1

0.0006

ControllerExtensionModuleOCFilter

SELECT category_id FROM oc_product_to_category WHERE product_id = '43857' ORDER BY main_category DESC LIMIT 1

0.0004

ControllerExtensionModuleOCFilter

SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=64' LIMIT 1

0.0003

ControllerExtensionModuleOCFilter

SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'product_id=43857' LIMIT 1

0.0004

ControllerExtensionModuleOCFilter

SELECT category_id FROM oc_product_to_category WHERE product_id = '43857' ORDER BY main_category DESC LIMIT 1

0.0004

ControllerExtensionModuleOCFilter

SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=64' LIMIT 1

0.0003

ControllerExtensionModuleOCFilter

SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'product_id=43857' LIMIT 1

0.0003

ControllerExtensionModuleOCFilter

SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'account/login' LIMIT 1

0.0003

ControllerExtensionModuleOCFilter

SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'account/register' LIMIT 1

0.0004

ControllerExtensionModuleOCFilter

SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'manufacturer_id=70' LIMIT 1

0.0007

ControllerExtensionModuleOCFilter

SELECT * FROM oc_product_image WHERE product_id = '43857' ORDER BY sort_order ASC

0.0006

ControllerExtensionModuleOCFilter

SELECT * FROM oc_product_discount WHERE product_id = '43857' AND customer_group_id = '1' AND quantity > 1 AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY quantity ASC, priority ASC, price ASC

0.0008

ControllerExtensionModuleOCFilter

SELECT * FROM oc_product_option po LEFT JOIN `oc_option` o ON (po.option_id = o.option_id) LEFT JOIN oc_option_description od ON (o.option_id = od.option_id) WHERE po.product_id = '43857' AND od.language_id = '1' ORDER BY o.sort_order

0.0006

ControllerEventCompatibility

SELECT COUNT(*) AS total FROM oc_review r LEFT JOIN oc_product p ON (r.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) WHERE p.product_id = '43857' AND p.date_available <= NOW() AND p.status = '1' AND r.status = '1' AND pd.language_id = '1'

0.0004

ControllerEventCompatibility

SELECT r.review_id, r.author, r.rating, r.text, p.product_id, pd.name, p.price, p.image, r.date_added FROM oc_review r LEFT JOIN oc_product p ON (r.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) WHERE p.product_id = '43857' AND p.date_available <= NOW() AND p.status = '1' AND r.status = '1' AND pd.language_id = '1' ORDER BY r.date_added DESC LIMIT 0,5

0.0002

ControllerEventCompatibility

SELECT category_id FROM oc_product_to_category WHERE product_id = '43857' ORDER BY main_category DESC LIMIT 1

0.0002

ControllerEventCompatibility

SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=64' LIMIT 1

0.0001

ControllerEventCompatibility

SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'product_id=43857' LIMIT 1

0.0006

ControllerEventCompatibility

SELECT ag.attribute_group_id, agd.name, agd.tooltip FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id) LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id) WHERE pa.product_id = '43857' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name

0.0003

ControllerEventCompatibility

SELECT * FROM oc_product_to_layout WHERE product_id = '43857' AND store_id = '0'

0.0003

ControllerEventCompatibility

SELECT * FROM oc_layout_route WHERE 'product/product' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1

0.0001

ControllerEventCompatibility

SELECT * FROM oc_layout_module WHERE layout_id = '2' AND `code` = 'ocfilter'

0.0001

ControllerEventCompatibility

SELECT * FROM oc_ocfilter_setting WHERE `key` = 'placement_layout'

0.0007

ControllerEventCompatibility

SELECT p.product_id, (SELECT price FROM oc_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 oc_product_to_category p2c LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE p.status = '1' AND p.catalog_output = '1' AND p2c.category_id = '1458' GROUP BY p.product_id ORDER BY p.viewed ASC, LCASE(pd.name) ASC LIMIT 0,20

0.001

ControllerEventCompatibility

0.0011

ControllerEventCompatibility

SELECT DISTINCT *, pd.name AS name, p.image, m.image AS manufacturer_image, (SELECT md.name FROM oc_manufacturer_description md WHERE md.manufacturer_id = p.manufacturer_id AND md.language_id = '1') AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_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, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM oc_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 oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '43858' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'

0.0012

ControllerEventCompatibility

SELECT DISTINCT *, pd.name AS name, p.image, m.image AS manufacturer_image, (SELECT md.name FROM oc_manufacturer_description md WHERE md.manufacturer_id = p.manufacturer_id AND md.language_id = '1') AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_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, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM oc_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 oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '132483' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'

0.0011

ControllerEventCompatibility

SELECT DISTINCT *, pd.name AS name, p.image, m.image AS manufacturer_image, (SELECT md.name FROM oc_manufacturer_description md WHERE md.manufacturer_id = p.manufacturer_id AND md.language_id = '1') AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_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, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM oc_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 oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '43859' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'

0.0004

ControllerEventCompatibility

SELECT category_id FROM oc_product_to_category WHERE product_id = '43857' ORDER BY main_category DESC LIMIT 1

0.0002

ControllerEventCompatibility

SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=64' LIMIT 1

0.0001

ControllerEventCompatibility

SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'product_id=43857' LIMIT 1

0.0005

ControllerEventCompatibility

SELECT category_id FROM oc_product_to_category WHERE product_id = '43858' ORDER BY main_category DESC LIMIT 1

0.0002

ControllerEventCompatibility

SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=64' LIMIT 1

0.0001

ControllerEventCompatibility

SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'product_id=43858' LIMIT 1

0.0005

ControllerEventCompatibility

SELECT category_id FROM oc_product_to_category WHERE product_id = '132483' ORDER BY main_category DESC LIMIT 1

0.0002

ControllerEventCompatibility

SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=64' LIMIT 1

0.0002

ControllerEventCompatibility

SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=158' LIMIT 1

0.0001

ControllerEventCompatibility

SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'product_id=132483' LIMIT 1

0.0005

ControllerEventCompatibility

SELECT category_id FROM oc_product_to_category WHERE product_id = '43859' ORDER BY main_category DESC LIMIT 1

0.0002

ControllerEventCompatibility

SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=64' LIMIT 1

0.0002

ControllerEventCompatibility

SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'product_id=43859' LIMIT 1

0.0006

ControllerEventCompatibility

SELECT * FROM oc_product_related pr LEFT JOIN oc_product p ON (pr.related_id = p.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pr.product_id = '43857' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' LIMIT 20

0.0004

ControllerEventCompatibility

SELECT rd.* FROM oc_product_recurring pr JOIN oc_recurring_description rd ON (rd.language_id = 1 AND rd.recurring_id = pr.recurring_id) JOIN oc_recurring r ON r.recurring_id = rd.recurring_id WHERE pr.product_id = 43857 AND status = '1' AND pr.customer_group_id = '1' ORDER BY sort_order ASC

0.0003

ControllerEventCompatibility

UPDATE oc_product SET viewed = (viewed + 1) WHERE product_id = '43857'

0.0004

ControllerExtensionModuleMicrodataPro

SELECT author, date_added, rating, text FROM oc_review WHERE product_id = '43857' AND status = '1' ORDER BY date_added DESC

0.0004

ControllerProductExtendedReviews

SELECT * FROM oc_product WHERE product_id = '43857'

0.0002

ControllerEventCompatibility

SELECT *, CONCAT(filter_id, '.', source) AS filter_key FROM oc_ocfilter_filter_value_to_product WHERE product_id = '43857'

0.0002

ControllerEventCompatibility

SELECT *, CONCAT(filter_id, '.', source) AS filter_key FROM oc_ocfilter_filter_range_to_product WHERE product_id = '43857'

0.0003

ControllerEventCompatibility

SELECT * FROM oc_product_special WHERE product_id = '43857' AND customer_group_id = '1' AND ((date_start = '0000-00-00' OR date_start < '2025-08-24') AND (date_end = '0000-00-00' OR date_end > '2025-08-24')) LIMIT 1

0.0002

ControllerEventCompatibility

SELECT * FROM oc_product_discount WHERE product_id = '43857' AND customer_group_id = '1' AND quantity = '1' AND ((date_start = '0000-00-00' OR date_start < '2025-08-24') AND (date_end = '0000-00-00' OR date_end > '2025-08-24')) LIMIT 1

0.0005

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 oc_category_path cp WHERE cp.category_id = p.category_id) AS path, (SELECT ua.keyword FROM oc_url_alias ua WHERE ua.`query` = CONCAT('ocfilter_page_id=', p.page_id) LIMIT 1) AS keyword FROM oc_ocfilter_page p LEFT JOIN oc_ocfilter_page_description pd ON (p.page_id = pd.page_id) LEFT JOIN oc_product_to_category p2c ON (p.category_id = p2c.category_id) WHERE p.status = '1' AND p.dynamic = '0' AND pd.language_id = '1' AND p2c.product_id = '43857' AND p.product = '1' ORDER BY p.params_count DESC

100

0.0002

ControllerCommonColumnLeft

SELECT * FROM oc_product_to_layout WHERE product_id = '43857' AND store_id = '0'

101

0.0003

ControllerCommonColumnLeft

SELECT * FROM oc_layout_route WHERE 'product/product' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1

102

0.0002

ControllerCommonColumnLeft

SELECT * FROM oc_layout_module WHERE layout_id = '2' AND position = 'column_left' ORDER BY sort_order

103

0.0002

ControllerEventCompatibility

SELECT * FROM oc_module WHERE module_id = '45'

104

0.0002

ControllerEventCompatibility

SELECT * FROM oc_module WHERE module_id = '40'

105

0.0002

ControllerEventCompatibility

SELECT * FROM oc_module WHERE module_id = '36'

106

0.0002

ControllerEventCompatibility

SELECT * FROM oc_module WHERE module_id = '37'

107

0.0002

ControllerEventCompatibility

SELECT * FROM oc_module WHERE module_id = '39'

108

0.0002

ControllerCommonColumnRight

SELECT * FROM oc_product_to_layout WHERE product_id = '43857' AND store_id = '0'

109

0.0075

ControllerCommonColumnRight

SELECT * FROM oc_layout_route WHERE 'product/product' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1

110

0.0004

ControllerCommonColumnRight

SELECT * FROM oc_layout_module WHERE layout_id = '2' AND position = 'column_right' ORDER BY sort_order

111

0.0003

ControllerCommonContentTop

SELECT * FROM oc_product_to_layout WHERE product_id = '43857' AND store_id = '0'

112

0.0003

ControllerCommonContentTop

SELECT * FROM oc_layout_route WHERE 'product/product' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1

113

0.0002

ControllerCommonContentTop

SELECT * FROM oc_layout_module WHERE layout_id = '2' AND position = 'content_top' ORDER BY sort_order

114

0.0002

ControllerCommonContentBottom

SELECT * FROM oc_product_to_layout WHERE product_id = '43857' AND store_id = '0'

115

0.0003

ControllerCommonContentBottom

SELECT * FROM oc_layout_route WHERE 'product/product' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1

116

0.0002

ControllerCommonContentBottom

SELECT * FROM oc_layout_module WHERE layout_id = '2' AND position = 'content_bottom' ORDER BY sort_order

117

0.0001

ControllerEventCompatibility

SELECT * FROM oc_module WHERE module_id = '43'

118

0.0004

ControllerCommonFooter

SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'information/contact' LIMIT 1

119

0.0001

ControllerCommonFooter

SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'account/return/add' LIMIT 1

120

0.0001

ControllerCommonFooter

SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'information/sitemap' LIMIT 1

121

0.0001

ControllerCommonFooter

SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'product/manufacturer' LIMIT 1

122

0.0001

ControllerCommonFooter

SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'account/voucher' LIMIT 1

123

0.0001

ControllerCommonFooter

SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'affiliate/account' LIMIT 1

124

0.0002

ControllerCommonFooter

SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'product/special' LIMIT 1

125

0.0001

ControllerCommonFooter

SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'account/account' LIMIT 1

126

0.0001

ControllerCommonFooter

SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'account/order' LIMIT 1

127

0.0001

ControllerCommonFooter

SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'account/wishlist' LIMIT 1

128

0.0001

ControllerCommonFooter

SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'account/newsletter' LIMIT 1

129

0.0002

ControllerEventCompatibility

SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'product/compare' LIMIT 1

130

0.0001

ControllerEventCompatibility

SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'account/wishlist' LIMIT 1

131

0.0002

ControllerEventCompatibility

SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'checkout/cart' LIMIT 1

132

0.0002

ControllerExtensionModuleMicrodataPro

SELECT * FROM oc_store ORDER BY url

133

0.0003

ControllerCommonHeader

SELECT * FROM oc_extension WHERE `type` = 'analytics'

134

0.0002

ControllerCommonHeader

SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'account/account' LIMIT 1

135

0.0001

ControllerCommonHeader

SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'account/logout' LIMIT 1

136

0.0002

ControllerCommonHeader

SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'common/home' LIMIT 1

137

0.0001

ControllerCommonHeader

SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'account/wishlist' LIMIT 1

138

0.0001

ControllerCommonHeader

SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'account/account' LIMIT 1

139

0.0055

ControllerCommonHeader

SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'account/register' LIMIT 1

140

0.0002

ControllerCommonHeader

SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'account/login' LIMIT 1

141

0.0001

ControllerCommonHeader

SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'account/order' LIMIT 1

142

0.0001

ControllerCommonHeader

SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'account/transaction' LIMIT 1

143

0.0001

ControllerCommonHeader

SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'account/download' LIMIT 1

144

0.0001

ControllerCommonHeader

SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'account/logout' LIMIT 1

145

0.0001

ControllerCommonHeader

SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'checkout/cart' LIMIT 1

146

0.0001

ControllerCommonHeader

SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'checkout/checkout' LIMIT 1

147

0.0001

ControllerCommonHeader

SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'information/contact' LIMIT 1

148

0.0001

ControllerCommonHeader

SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'product/compare' LIMIT 1

149

0.0002

ControllerEventCompatibility

SELECT SUM(quantity) as total FROM oc_cart WHERE api_id = '0' AND session_id = '9abadb58776c56053ecbca40939b4bad'

150

0.0003

ControllerCommonLanguage

SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'common/language/language' LIMIT 1

151

0.0004

ControllerCommonLanguage

SELECT category_id FROM oc_product_to_category WHERE product_id = '43857' ORDER BY main_category DESC LIMIT 1

152

0.0002

ControllerCommonLanguage

SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=64' LIMIT 1

153

0.0001

ControllerCommonLanguage

SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'product_id=43857' LIMIT 1

154

0.0003

ControllerCommonCurrency

SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'common/currency/currency' LIMIT 1

155

0.0004

ControllerCommonCurrency

SELECT category_id FROM oc_product_to_category WHERE product_id = '43857' ORDER BY main_category DESC LIMIT 1

156

0.0002

ControllerCommonCurrency

SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=64' LIMIT 1

157

0.0001

ControllerCommonCurrency

SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'product_id=43857' LIMIT 1

158

0.0006

ControllerCommonCart

SELECT * FROM oc_cart WHERE api_id = '0' AND session_id = '9abadb58776c56053ecbca40939b4bad'

159

0.0004

ControllerCommonCart

SELECT * FROM oc_extension WHERE `type` = 'total'

160

0.0004

ControllerEventCompatibility

SELECT * FROM oc_cart WHERE api_id = '0' AND session_id = '9abadb58776c56053ecbca40939b4bad'

161

0.0006

ControllerEventCompatibility

SELECT SUM(amount) AS total FROM oc_customer_transaction WHERE customer_id = '0'

162

0.0006

ControllerEventCompatibility

SELECT SUM(quantity) as total FROM oc_cart WHERE api_id = '0' AND session_id = '9abadb58776c56053ecbca40939b4bad'

163

0.0005

ControllerEventCompatibility

SELECT SUM(quantity) as total FROM oc_cart WHERE api_id = '0' AND session_id = '9abadb58776c56053ecbca40939b4bad'

164

0.0004

ControllerEventCompatibility

SELECT * FROM oc_cart WHERE api_id = '0' AND session_id = '9abadb58776c56053ecbca40939b4bad'

165

0.0004

ControllerEventCompatibility

SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'checkout/cart' LIMIT 1

166

0.0003

ControllerEventCompatibility

SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'checkout/checkout' LIMIT 1

Антенна модель В2 FM (широкий приемный элемент), Модель В2 FM приёмные элементы BOSCH

Наличие: Актуальная модель

Производитель: WarCam

Бесплатная доставка по России

Гарантия 1 год от производителя!

Купи и установи в одном месте!

Обмен/возврат 14 дней!

Обзоры наших работ

Описание Антенна модель В2 FM (широкий приемный элемент), Модель В2 FM приёмные элементы BOSCH

Задайте вопрос по этому товару

Отзывы Антенна модель В2 FM (широкий приемный элемент), Модель В2 FM приёмные элементы BOSCH

Написать отзыв