Оригинальная навигационная система MMI 3G Plus Audi A4 (2007-2014)

Name: Оригинальная навигационная система MMI 3G Plus Audi A4 (2007-2014)
Brand: WarCam
SKU: 39496
Price: 84600 RUB
Availability: InStock

Артикул: 39496

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

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

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

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

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

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

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

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

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

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

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

84 600 р.

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

Купить оптом

Товар снят с производства!

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

Магнитола Canbox H-Line 5621 для Nissan X-Trail 2 (T31) на ANDROID в стиле Тесла

Описание Оригинальная навигационная система MMI 3G Plus Audi A4 (2007-2014)

MMI 3G Plus – это навигация Audi A4 B8, которая является также мультимедийно-информационной системой с широким функционалом и большим количеством современных возможностей. Устройство позволит модернизировать автомобиль и сделает эксплуатацию транспортного средства более удобной.

При дооснащении оригинальной навигационной системой MMI 3G Plus будут доступны следующие опции:

оригинальная навигационная систмема с полноценной картой Европы и России;
жесткий диск общим объемом 40Gb, из которых 30Gb предназначены для навигационной карты и 10 GB предназначены для сохранения музыкальных файлов;
оригинальная подготовка для мобильного телефона через Bluetooth, позволяющая звонить и принимать звонки по громкой связи, а также управлять всеми настройками записной книги мобильного телефона через панель управления MMI;
2 входа для карт памяти SD, максимальным объемом 32Gb;
оригинальный DVD-проигрыватель, позволяющий просматривать фильмы, работающий при движении (по желанию);
панель управления MMI, расположенная в районе селектора АКПП, оснащенная специальным джойстиком для управления навигационной картой и меню DVD- проигрывателя;
новый дисплей MMI диагональю 7 дюймов и разрешением 800х480точек;
Bluetooth Audio;
опция голосового управления (в том числе и русский язык).

Навигационные возможности MMI Audi A4 B8

Для навигации оригинальная система Multi Media Interface в Audi A4 использует актуальные российские и европейские карты. При приближении на определенное расстояние прорисовка зданий становится полностью трехмерной. Также полностью в 3D изображаются постройки, которые относятся к категории памятников архитектуры.

Audi A4 B8 MMI 3G оснащена встроенной функцией TMP – она позволяет получать актуальные сведения о пробках посредством радиоканала и переносить их на карту. Предусмотрена также дополнительная функция для просмотра пробок на карте в реальном времени – Audi Traffic Online. После ее активации карта показывает ситуацию на дороге на несколько километров вперед, а увеличить или уменьшить это расстояние можно путем масштабирования карты. Если дорожная ситуация на проложенном маршруте изменяется, то Audi A4 MMI самостоятельно создает новый, чтобы как можно быстрее довести автомобиль до конечного пункта.

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

Информационно-развлекательный функционал MMI Ауди А4 (ММИ)

Видеоинтерфейс Audi A4 MMI 2G использует в своей работе сервис Audi Conneсt, который предоставляет следующие информационные возможности:

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

Установленная на Ауди А4 навигация позволит также пользоваться громкой связью при разговорах по мобильному телефону, принимать звонки и звонить самому. Панель управления Multi Media Interface также откроет удобный доступ к настройкам мобильного и телефонной книжке.

Жесткий диск устройства имеет объем в 40 Гб, предназначенный для хранения карт и мультимедийных файлов. Проигрыватель DVD позволит смотреть видео даже в движении. Картинка выводится семидюймовый монитор MMI.

У нас вы можете не только купить MMI Audi A4 B8, но и воспользоваться услугами по установке и подключению этой мультимедийно-навигационной системы.

Навигация Audi A4 B8 – это симбиоз инновационных технологий в области навигационно-мультимедийного оснащения автомобилей. Панель Audi A4 B8 3G дополнительно укомплектовывается новыми кнопками и дополнительными функциями. Кроме того, есть возможность встроить систему акустики Bang&Olufsen Advanced Sound System.

Параметры и управление

Среди основных технических параметров, присущих навигатору Ауди A4 Б8, можно выделить:

яркий 7-дюймовый экран с дополнительным отображением информации;
карты навигации по России и Европы с показателями граничной скорости на протяжении всего пути;
трехмерное изображение объектов с помощью 3-D навигации;
радиоприемник с тюнерами и антенной со встроенной системой разнесения по фазе, что позволяет лучше и качественнее принимать сигналы;
встроенный Блютуз с возможность передачи музыкальных файлов;
MMI Audi A4 графически отображает парктроники;
DVD-плеер поддерживает все основные аудио и видеоформаты;
Голосовая система менеджмента (русскоязычная);
установка камеры заднего вида;
клавиатура с кнопками menu, back, tone.

В комплект оригинальной навигации Audi A4 входят:

Экран.
Модуль навигации.
Панель навигации джойстиком.
Радиомодуль.
Антенна GPS.

Почему ММИ 3G на Аudi A4 так востребован среди владельцев авто?

MMI A4 B8 позволяет с легкостью управлять мультимедийной и информационной системами автомобиля благодаря таким преимуществам:

высокое экранное разрешение;
оперативное реагирование во время прокладки маршрутка;
максимально простое и интуитивное управление;
трехмерная графика;
внушительный объем жесткого диска для быстрого доступа к большому количеству информации;
мультимедиа Ауди А4 Б8 комплектуется всеми необходимыми опциями, входящими в стоимость системы.

В нашем сервисном центре Вы сможете купить MMI Audi A4 по доступной цене. Также специалистами оказывается услуга подключения, в которую включаются работы по протяжке оптоволокна и микрофона, удаление защитных элементов на дилере и т.д. Все работы выполняются на профессиональных устройствах. Гарантия производителя на транспортное средство сохраняется.

84 600 р.

Отзывы Оригинальная навигационная система MMI 3G Plus Audi A4 (2007-2014)

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

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

Ваше имя:

Рейтинг

Ваш отзыв

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

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

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

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

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

Query time (s)

Controller

Query

0.0011

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

0.0001

SET SQL_BIG_SELECTS = 1

0.0005

SHOW TABLES LIKE 'oc_ocfilter_setting'

0.0003

SELECT * FROM oc_ocfilter_setting

0.0002

ControllerStartupStartup

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

0.0032

ControllerStartupStartup

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

0.0002

ControllerEventCompatibility

SELECT f1.offname f1_name, f1.shortname f1_shortname, f1.fias_id f1_fias_id, f1.level f1_level, f1.postalcode f1_postalcode, f2.offname f2_name, f2.shortname f2_shortname, f2.fias_id f2_fias_id, f2.level f2_level, f3.offname f3_name, f3.shortname f3_shortname, f3.fias_id f3_fias_id, f3.level f3_level, f4.offname f4_name, 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

0.0002

ControllerEventCompatibility

SELECT * FROM oc_currency

0.0004

ControllerEventCompatibility

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.0002

ControllerEventCompatibility

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.0002

ControllerEventCompatibility

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.0001

ControllerEventCompatibility

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.0001

ControllerEventCompatibility

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.0001

ControllerEventCompatibility

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

0.0003

ControllerEventCompatibility

SHOW TABLES LIKE 'oc_cartkeeper'

0.0003

ControllerEventCompatibility

SHOW TABLES LIKE 'oc_cartkeeper_share'

0.0002

ControllerEventCompatibility

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

0.0001

ControllerEventCompatibility

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

0.0001

ControllerEventCompatibility

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

0.0001

ControllerEventCompatibility

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

0.0001

ControllerStartupEvent

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

0.0027

ControllerStartupSeoPro

SELECT category_id, parent_id FROM oc_category ORDER BY parent_id

0.0002

ControllerStartupSeoPro

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

0.0001

ControllerStartupSeoPro

SELECT query FROM oc_url_alias WHERE keyword = 'videointerfeysy' LIMIT 1

0.0001

ControllerStartupSeoPro

SELECT query FROM oc_url_alias WHERE keyword = 'originalnaya-navigacionnaya-sistema-mmi-3g-plus-audi-a4-2007-2014' LIMIT 1

0.0001

ControllerStartupSeoPro

SELECT query FROM oc_url_alias WHERE keyword = 'drugiye-kategorii/videointerfeysy/originalnaya-navigacionnaya-sistema-mmi-3g-plus-audi-a4-2007-2014' LIMIT 1

0.0002

ControllerStartupSeoPro

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

0.0001

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 = 'category_id=141' LIMIT 1

0.0001

ControllerStartupSeoPro

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

0.0001

ControllerProductProduct

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

0.0002

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.0001

ControllerProductProduct

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

0.0002

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 = '141' 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.0001

ControllerProductProduct

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

0.0001

ControllerProductProduct

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

0.0001

ControllerProductProduct

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

0.0001

ControllerProductProduct

SELECT parent_id FROM oc_category WHERE category_id =900

0.0001

ControllerProductProduct

SELECT parent_id FROM oc_category WHERE category_id =159

0.0002

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 = '69' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'

0.0001

ControllerProductProduct

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

0.0002

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 = '159' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'

0.0001

ControllerProductProduct

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

0.0001

ControllerProductProduct

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

0.0002

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 = '900' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'

0.0001

ControllerProductProduct

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

0.0001

ControllerProductProduct

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

0.0001

ControllerProductProduct

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

0.0011

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 = '43541' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'

0.0002

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 = '43541' ORDER BY cd.name ASC

0.0002

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 = '900' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'

0.0003

ControllerProductProduct

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

0.0001

ControllerProductProduct

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

0.0001

ControllerProductProduct

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

0.0002

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 = '159' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'

0.0001

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 = '141' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'

0.0001

ControllerProductProduct

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

0.0001

ControllerProductProduct

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

0.0001

ControllerProductProduct

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

0.0002

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 = '43541' AND q2s.store_id = '0' AND q.status = '1' ORDER BY q.date_asked DESC

0.0001

ControllerProductProduct

SELECT FOUND_ROWS() AS count

0.0001

ControllerProductProduct

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

0.0001

ControllerExtensionModuleOCFilter

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

0.0001

ControllerExtensionModuleOCFilter

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

0.0001

ControllerExtensionModuleOCFilter

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

0.0001

ControllerExtensionModuleOCFilter

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

0.0001

ControllerExtensionModuleOCFilter

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

0.0001

ControllerExtensionModuleOCFilter

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

0.0001

ControllerExtensionModuleOCFilter

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

0.0001

ControllerExtensionModuleOCFilter

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

0.0001

ControllerExtensionModuleOCFilter

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

0.0001

ControllerExtensionModuleOCFilter

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

0.0001

ControllerExtensionModuleOCFilter

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

0.0002

ControllerExtensionModuleOCFilter

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

0.0003

ControllerExtensionModuleOCFilter

SELECT * FROM oc_product_discount WHERE product_id = '43541' 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.0004

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 = '43541' AND od.language_id = '1' ORDER BY o.sort_order

0.0004

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 = '43541' AND p.date_available <= NOW() AND p.status = '1' AND r.status = '1' AND pd.language_id = '1'

0.0002

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 = '43541' 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.0001

ControllerEventCompatibility

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

0.0001

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 = 'category_id=141' LIMIT 1

0.0001

ControllerEventCompatibility

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

0.0005

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 = '43541' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name

0.0002

ControllerEventCompatibility

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

0.0002

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.0013

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 = '900' GROUP BY p.product_id ORDER BY p.viewed ASC, LCASE(pd.name) ASC LIMIT 0,20

0.0009

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 = '81759' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'

0.0007

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 = '82028' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'

0.0008

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 = '82237' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'

0.0007

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 = '140621' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'

0.0016

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 = '80937' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'

0.0008

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 = '139047' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'

0.0007

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 = '140262' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'

0.0034

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 = '140091' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'

0.001

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 = '139296' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'

0.001

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 = '138365' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'

100

0.0019

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 = '138614' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'

101

0.0009

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 = '34339' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'

102

0.0014

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 = '126481' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'

103

0.0008

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 = '69718' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'

104

0.0017

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 = '104170' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'

105

0.001

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 = '68993' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'

106

0.0014

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 = '68633' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'

107

0.0009

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 = '71127' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'

108

0.0015

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 = '61071' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'

109

0.0009

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 = '102938' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'

110

0.0002

ControllerEventCompatibility

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

111

0.0001

ControllerEventCompatibility

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

112

0.0001

ControllerEventCompatibility

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

113

0.0001

ControllerEventCompatibility

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

114

0.0003

ControllerEventCompatibility

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

115

0.0001

ControllerEventCompatibility

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

116

0.0001

ControllerEventCompatibility

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

117

0.0001

ControllerEventCompatibility

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

118

0.0001

ControllerEventCompatibility

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

119

0.0001

ControllerEventCompatibility

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

120

0.0001

ControllerEventCompatibility

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

121

0.0001

ControllerEventCompatibility

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

122

0.0001

ControllerEventCompatibility

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

123

0.0001

ControllerEventCompatibility

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

124

0.0001

ControllerEventCompatibility

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

125

0.0002

ControllerEventCompatibility

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

126

0.0001

ControllerEventCompatibility

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

127

0.0001

ControllerEventCompatibility

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

128

0.0001

ControllerEventCompatibility

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

129

0.0001

ControllerEventCompatibility

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

130

0.0002

ControllerEventCompatibility

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

131

0.0001

ControllerEventCompatibility

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

132

0.0001

ControllerEventCompatibility

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

133

0.0001

ControllerEventCompatibility

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

134

0.0001

ControllerEventCompatibility

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

135

0.0001

ControllerEventCompatibility

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

136

0.0001

ControllerEventCompatibility

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

137

0.0001

ControllerEventCompatibility

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

138

0.0002

ControllerEventCompatibility

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

139

0.0001

ControllerEventCompatibility

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

140

0.0001

ControllerEventCompatibility

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

141

0.0001

ControllerEventCompatibility

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

142

0.0001

ControllerEventCompatibility

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

143

0.0001

ControllerEventCompatibility

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

144

0.0001

ControllerEventCompatibility

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

145

0.0001

ControllerEventCompatibility

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

146

0.0001

ControllerEventCompatibility

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

147

0.0001

ControllerEventCompatibility

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

148

0.0001

ControllerEventCompatibility

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

149

0.0001

ControllerEventCompatibility

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

150

0.0002

ControllerEventCompatibility

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

151

0.0001

ControllerEventCompatibility

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

152

0.0001

ControllerEventCompatibility

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

153

0.0001

ControllerEventCompatibility

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

154

0.0001

ControllerEventCompatibility

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

155

0.0001

ControllerEventCompatibility

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

156

0.0001

ControllerEventCompatibility

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

157

0.0001

ControllerEventCompatibility

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

158

0.0003

ControllerEventCompatibility

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

159

0.0001

ControllerEventCompatibility

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

160

0.0001

ControllerEventCompatibility

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

161

0.0001

ControllerEventCompatibility

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

162

0.0002

ControllerEventCompatibility

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

163

0.0001

ControllerEventCompatibility

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

164

0.0001

ControllerEventCompatibility

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

165

0.0001

ControllerEventCompatibility

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

166

0.0002

ControllerEventCompatibility

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

167

0.0001

ControllerEventCompatibility

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

168

0.0001

ControllerEventCompatibility

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

169

0.0001

ControllerEventCompatibility

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

170

0.0002

ControllerEventCompatibility

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

171

0.0001

ControllerEventCompatibility

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

172

0.0001

ControllerEventCompatibility

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

173

0.0001

ControllerEventCompatibility

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

174

0.0002

ControllerEventCompatibility

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

175

0.0001

ControllerEventCompatibility

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

176

0.0001

ControllerEventCompatibility

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

177

0.0001

ControllerEventCompatibility

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

178

0.0002

ControllerEventCompatibility

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

179

0.0002

ControllerEventCompatibility

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

180

0.0001

ControllerEventCompatibility

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

181

0.0001

ControllerEventCompatibility

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

182

0.0002

ControllerEventCompatibility

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

183

0.0001

ControllerEventCompatibility

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

184

0.0001

ControllerEventCompatibility

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

185

0.0001

ControllerEventCompatibility

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

186

0.0002

ControllerEventCompatibility

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

187

0.0001

ControllerEventCompatibility

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

188

0.0001

ControllerEventCompatibility

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

189

0.0002

ControllerEventCompatibility

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

190

0.0004

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 = '43541' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' LIMIT 20

191

0.0002

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 = 43541 AND status = '1' AND pr.customer_group_id = '1' ORDER BY sort_order ASC

192

0.0005

ControllerEventCompatibility

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

193

0.0004

ControllerExtensionModuleMicrodataPro

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

194

0.0005

ControllerProductExtendedReviews

SELECT * FROM oc_product WHERE product_id = '43541'

195

0.0003

ControllerEventCompatibility

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

196

0.0003

ControllerEventCompatibility

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

197

0.0004

ControllerEventCompatibility

SELECT * FROM oc_product_special WHERE product_id = '43541' AND customer_group_id = '1' AND ((date_start = '0000-00-00' OR date_start < '2025-06-18') AND (date_end = '0000-00-00' OR date_end > '2025-06-18')) LIMIT 1

198

0.0005

ControllerEventCompatibility

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

199

0.0008

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 = '43541' AND p.product = '1' ORDER BY p.params_count DESC

200

0.0003

ControllerCommonColumnLeft

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

201

0.0005

ControllerCommonColumnLeft

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

202

0.0004

ControllerCommonColumnLeft

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

203

0.0004

ControllerEventCompatibility

SELECT * FROM oc_module WHERE module_id = '45'

204

0.0004

ControllerEventCompatibility

SELECT * FROM oc_module WHERE module_id = '40'

205

0.0004

ControllerEventCompatibility

SELECT * FROM oc_module WHERE module_id = '36'

206

0.0004

ControllerEventCompatibility

SELECT * FROM oc_module WHERE module_id = '37'

207

0.0003

ControllerEventCompatibility

SELECT * FROM oc_module WHERE module_id = '39'

208

0.0011

ControllerCommonColumnRight

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

209

0.0006

ControllerCommonColumnRight

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

210

0.0004

ControllerCommonColumnRight

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

211

0.0003

ControllerCommonContentTop

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

212

0.0004

ControllerCommonContentTop

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

213

0.0004

ControllerCommonContentTop

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

214

0.0003

ControllerCommonContentBottom

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

215

0.0004

ControllerCommonContentBottom

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

216

0.0003

ControllerCommonContentBottom

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

217

0.0003

ControllerEventCompatibility

SELECT * FROM oc_module WHERE module_id = '43'

218

0.0004

ControllerCommonFooter

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

219

0.0005

ControllerCommonFooter

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

220

0.0004

ControllerCommonFooter

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

221

0.0003

ControllerCommonFooter

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

222

0.0003

ControllerCommonFooter

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

223

0.0003

ControllerCommonFooter

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

224

0.0003

ControllerCommonFooter

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

225

0.0003

ControllerCommonFooter

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

226

0.0003

ControllerCommonFooter

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

227

0.0003

ControllerCommonFooter

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

228

0.0003

ControllerCommonFooter

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

229

0.0003

ControllerEventCompatibility

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

230

0.0004

ControllerEventCompatibility

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

231

0.0003

ControllerEventCompatibility

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

232

0.0003

ControllerExtensionModuleMicrodataPro

SELECT * FROM oc_store ORDER BY url

233

0.0005

ControllerCommonHeader

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

234

0.0003

ControllerCommonHeader

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

235

0.0003

ControllerCommonHeader

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

236

0.0004

ControllerCommonHeader

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

237

0.0003

ControllerCommonHeader

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

238

0.0004

ControllerCommonHeader

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

239

0.0003

ControllerCommonHeader

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

240

0.0003

ControllerCommonHeader

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

241

0.0003

ControllerCommonHeader

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

242

0.0003

ControllerCommonHeader

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

243

0.0003

ControllerCommonHeader

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

244

0.0004

ControllerCommonHeader

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

245

0.0003

ControllerCommonHeader

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

246

0.0003

ControllerCommonHeader

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

247

0.0003

ControllerCommonHeader

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

248

0.0004

ControllerCommonHeader

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

249

0.0003

ControllerEventCompatibility

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

250

0.0004

ControllerCommonLanguage

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

251

0.0004

ControllerCommonLanguage

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

252

0.0003

ControllerCommonLanguage

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

253

0.0003

ControllerCommonLanguage

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

254

0.0004

ControllerCommonLanguage

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

255

0.0004

ControllerCommonCurrency

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

256

0.0004

ControllerCommonCurrency

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

257

0.0003

ControllerCommonCurrency

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

258

0.0004

ControllerCommonCurrency

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

259

0.0003

ControllerCommonCurrency

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

260

0.0004

ControllerCommonCart

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

261

0.0003

ControllerCommonCart

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

262

0.0003

ControllerEventCompatibility

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

263

0.0004

ControllerEventCompatibility

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

264

0.0005

ControllerEventCompatibility

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

265

0.0003

ControllerEventCompatibility

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

266

0.0003

ControllerEventCompatibility

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

267

0.0005

ControllerEventCompatibility

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

268

0.0003

ControllerEventCompatibility

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

Оригинальная навигационная система MMI 3G Plus Audi A4 (2007-2014)

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

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

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

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

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

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

Товар снят с производства!

Рекомендуем рассмотреть актуальные модели из категории A4 (B8) (2007-2015).

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

Описание Оригинальная навигационная система MMI 3G Plus Audi A4 (2007-2014)

Навигационные возможности MMI Audi A4 B8

Информационно-развлекательный функционал MMI Ауди А4 (ММИ)

Параметры и управление

Почему ММИ 3G на Аudi A4 так востребован среди владельцев авто?

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

Отзывы Оригинальная навигационная система MMI 3G Plus Audi A4 (2007-2014)

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