• На главную
  • Штатные магнитолы
    • Планшеты под рамки 10"
    • Планшеты под рамки 9"
    • Планшеты под рамки Tesla Style 9.7"
    • 1 DIN Универсальные
    • 2 DIN Универсальные
    • Audi
    • Bentley
    • BMW
    • Brilliance
    • Buick
    • BYD
    • Cadillac
    • Changan
    • Chery
    • Chevrolet
    • Chrysler
    • Citroen
    • Daewoo
    • Daihatsu
    • Datsun
    • Dodge
    • Dongfeng
    • FAW
    • Fiat
    • Ford
    • Foton
    • GAZ
    • Geely
    • Genesis
    • Great Wall
    • Haima
    • Haval
    • Honda
    • Hummer
    • Hyundai
    • Infiniti
    • Isuzu
    • Iveco
    • JAC
    • Jaguar
    • Jeep
    • Kia
    • Lada
    • Land Rover
    • Lexus
    • Lifan
    • Lincoln
    • Maserati
    • Mazda
    • Mercedes-Benz
    • Mini Cooper
    • Mitsubishi
    • Nissan
    • Opel
    • Peugeot
    • Porsche
    • Ravon
    • Renault
    • Rolls Royce
    • Saab
    • Seat
    • Skoda
    • Smart
    • SsangYong
    • Subaru
    • Suzuki
    • Toyota
    • UAZ
    • Volkswagen
    • Volvo
    • Zotye
  • Камеры заднего вида
  • Камеры переднего вида
  • Противоугонное оборудование
    • Замки капота
    • Иммобилайзеры
    • Сигнализации
    • GPS-маяки
  • Автомониторы
    • Зеркала заднего вида с монитором
    • Мониторы на подголовник
    • Подголовники с монитором
    • Мониторы на торпедо
    • Потолочные мониторы
    • Наушники
  • Видеорегистраторы
  • Автозвук
    • ISO-переходники
    • Адаптеры усилителя
    • Акустические системы
    • Кабели
    • Проставочные кольца
    • Сабвуферы
    • Усилители
  • Аксессуары
    • Автомобильная зарядка
    • Временная карта парковки
    • Для автомагнитол
    • Кнопки управления на руль
    • Радиоантенны, усилители
    • DVD/CD приводы
    • Wi-Fi адаптеры
    • Модемы 3G/4G
    • Парктроники
    • ТВ-антенны
    • ТВ-тюнеры
    • Навигационное ПО
    • Диагностика
    • Карты памяти
    • USB флешки
    • Держатели телефонов
  • Услуги
Информация
  • Опт
  • Установочные центры
  • Гарантия / Возврат
  • Доставка и оплата
  • Контакты
  • Опт
  • Установочные центры
  • Гарантия / Возврат
  • Доставка и оплата
  • Контакты
Опт Установочные центры Гарантия / Возврат Доставка и оплата Контакты
  • Личный кабинет
    • Авторизация
    • Регистрация
Работаем с 2012 года
8 (800) 700-26-44 +7 (495) 220-33-59 +7 (977) 809-33-59
  • Заказать обратный звонок
  • г. Москва, ул.Ташкентская 28, стр.1
  • Написать нам в WatsApp
  • info@frontcam.ru
Без выходных: 9:00-20:00
+7 (495) 220-33-59 +7 (977) 809-33-59
Спросите у нас:
whatsapp telegram viber
Наши обзоры:
youtube vkontakte instagram
8 (800) 700-26-44 8 (495) 220-33-59 8 (977) 809-33-59
Подобрать магнитолу Обратный звонок Запись на установку
frontcam.ru
frontcam.ru Каталог товаров
Штатные магнитолы
  • Планшеты под рамки 10"
  • Планшеты под рамки 9"
  • Планшеты под рамки Tesla Style 9.7"
  • 1 DIN Универсальные
  • 2 DIN Универсальные
  • Audi
  • Bentley
  • BMW
  • Brilliance
  • Buick
  • BYD
  • Cadillac
  • Changan
  • Chery
  • Chevrolet
  • Chrysler
  • Citroen
  • Daewoo
  • Daihatsu
  • Datsun
  • Dodge
  • Dongfeng
  • FAW
  • Fiat
  • Ford
  • Foton
  • GAZ
  • Geely
  • Genesis
  • Great Wall
  • Haima
  • Haval
  • Honda
  • Hummer
  • Hyundai
  • Infiniti
  • Isuzu
  • Iveco
  • JAC
  • Jaguar
  • Jeep
  • Kia
  • Lada
  • Land Rover
  • Lexus
  • Lifan
  • Lincoln
  • Maserati
  • Mazda
  • Mercedes-Benz
  • Mini Cooper
  • Mitsubishi
  • Nissan
  • Opel
  • Peugeot
  • Porsche
  • Ravon
  • Renault
  • Rolls Royce
  • Saab
  • Seat
  • Skoda
  • Smart
  • SsangYong
  • Subaru
  • Suzuki
  • Toyota
  • UAZ
  • Volkswagen
  • Volvo
  • Zotye
Камеры заднего вида
Камеры переднего вида
Противоугонное оборудование
  • Замки капота
  • Иммобилайзеры
  • Сигнализации
  • GPS-маяки
Автомониторы
  • Зеркала заднего вида с монитором
  • Мониторы на подголовник
  • Подголовники с монитором
  • Мониторы на торпедо
  • Потолочные мониторы
  • Наушники
Видеорегистраторы
Автозвук
  • ISO-переходники
  • Адаптеры усилителя
  • Акустические системы
  • Кабели
  • Проставочные кольца
  • Сабвуферы
  • Усилители
Аксессуары
  • Автомобильная зарядка
  • Временная карта парковки
  • Для автомагнитол
  • Кнопки управления на руль
  • Радиоантенны, усилители
  • DVD/CD приводы
  • Wi-Fi адаптеры
  • Модемы 3G/4G
  • Парктроники
  • ТВ-антенны
  • ТВ-тюнеры
  • Навигационное ПО
  • Диагностика
  • Карты памяти
  • USB флешки
  • Держатели телефонов
Услуги
8 (800) 700-26-44
  • Везде
  • Штатные магнитолы
  • Видеоинтерфейсы
  • Камеры для коммерческого транспорта
  • Камеры заднего вида
  • Камеры переднего вида
  • Противоугонное оборудование
  • Автомониторы
  • Видеорегистраторы
  • Штатные регистраторы
  • Радар детекторы
  • Роботы-пылесосы
  • Переходные рамки
  • Action-камеры
  • Навигаторы
  • Автозвук
  • Аксессуары
  • Услуги
  • Автомобильный инвертер
  • Автомобильный подогрев
  • Акустика для мотоцикла
  • Акустика для скутера / мопеда
  • Видеорегистратор для мотоцикла / квадроцикла / снегохода
  • Виртуальная приборная панель
  • Датчики давления в шинах
  • Доводчики дверей
  • Круговой обзор
  • Навигаторы для мотоцикла/ квадроцикла
  • Система контроля слепых зон
  • Спорттовары
  • Тюнинг
  • Сравнение0
  • Закладки0
  • Везде
  • Штатные магнитолы
  • Видеоинтерфейсы
  • Камеры для коммерческого транспорта
  • Камеры заднего вида
  • Камеры переднего вида
  • Противоугонное оборудование
  • Автомониторы
  • Видеорегистраторы
  • Штатные регистраторы
  • Радар детекторы
  • Роботы-пылесосы
  • Переходные рамки
  • Action-камеры
  • Навигаторы
  • Автозвук
  • Аксессуары
  • Услуги
  • Автомобильный инвертер
  • Автомобильный подогрев
  • Акустика для мотоцикла
  • Акустика для скутера / мопеда
  • Видеорегистратор для мотоцикла / квадроцикла / снегохода
  • Виртуальная приборная панель
  • Датчики давления в шинах
  • Доводчики дверей
  • Круговой обзор
  • Навигаторы для мотоцикла/ квадроцикла
  • Система контроля слепых зон
  • Спорттовары
  • Тюнинг
  • ...
  • Главная
  • Автозвук
  • Автомобильные сабвуферы

Фильтр
4000 - 9100 р. Цена
- р.
Тип товара
Производитель
Сортировка:

Показать:

Фильтр

В закладки
В сравнение
Активный сабвуфер URAL (Урал) AS-D12A BLACK HURRICANE
Активный сабвуфер URAL (Урал) AS-D12A BLACK HURRICANE
Активный сабвуфер URAL (Урал) AS-D12A BLACK HURRICANE
Активный сабвуфер URAL (Урал) AS-D12A BLACK HURRICANE
Активный сабвуфер URAL (Урал) AS-D12A BLACK HURRICANE
Активный сабвуфер URAL (Урал) AS-D12A BLACK HURRICANE
Артикул: 40280

Активный сабвуфер URAL (Урал) AS-D12A BLACK HURRICANE

0
9 100 р.
В корзину
Быстрый заказ
В закладки
В сравнение
Сабвуфер URAL (Урал) TT 15
Сабвуфер URAL (Урал) TT 15
Сабвуфер URAL (Урал) TT 15
Сабвуфер URAL (Урал) TT 15
Сабвуфер URAL (Урал) TT 15
Сабвуфер URAL (Урал) TT 15
Артикул: 40260

Сабвуфер URAL (Урал) TT 15

0
6 190 р.
В корзину
Быстрый заказ
В закладки
В сравнение
Сабвуфер URAL (Урал) TT 12
Сабвуфер URAL (Урал) TT 12
Сабвуфер URAL (Урал) TT 12
Сабвуфер URAL (Урал) TT 12
Сабвуфер URAL (Урал) TT 12
Сабвуфер URAL (Урал) TT 12
Артикул: 40261

Сабвуфер URAL (Урал) TT 12

0
5 790 р.
В корзину
Быстрый заказ
В закладки
В сравнение
Сабвуфер URAL (Урал) Molot 10
Сабвуфер URAL (Урал) Molot 10
Сабвуфер URAL (Урал) Molot 10
Сабвуфер URAL (Урал) Molot 10
Артикул: 40259

Сабвуфер URAL (Урал) Molot 10

0
4 000 р.
В корзину
Быстрый заказ
В закладки
В сравнение
Сабвуфер URAL (Урал) TT 10
Сабвуфер URAL (Урал) TT 10
Сабвуфер URAL (Урал) TT 10
Сабвуфер URAL (Урал) TT 10
Артикул: 40262

Сабвуфер URAL (Урал) TT 10

0
5 190 р.
В корзину
Быстрый заказ
В закладки
В сравнение
Сабвуфер URAL (Урал) Molot 12
Сабвуфер URAL (Урал) Molot 12
Сабвуфер URAL (Урал) Molot 12
Сабвуфер URAL (Урал) Molot 12
Сабвуфер URAL (Урал) Molot 12
Сабвуфер URAL (Урал) Molot 12
Артикул: 40258

Сабвуфер URAL (Урал) Molot 12

0
4 300 р.
В корзину
Быстрый заказ
Показано с 1 по 6 из 6 (всего 1 страниц)
Надежность
Надежность

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

Большой опыт
Большой опыт

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

Оплата потом
Оплата потом

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

Установка
Установка

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

Logo Frontcam
Пн-Вс: 09:00-20:00
+7 (495) 220-33-59
+7 (977) 809-33-59
Без выходных
8 (800) 551-94-79
info@frontcam.ru
Вконтакте
YouTube
Instagram
Покупателю
  • Доставка и оплата
  • Установочные центры
  • Техподдержка
  • Гарантия / Возврат и обмен
  • Акции
Навигация
  • О компании
  • Партнеры
  • Вакансии
  • Сертификаты
  • Оптовым клиентам
  • Контакты

Есть жалобы или предложения?

Нам важно Ваше мнение!
Задать вопрос Пожаловаться
Пользовательское соглашение
Все права защищены. Политика конфиденциальности.
Created by frontcam.ru

Total time: 0.1393 s | Queries: 224 | Slow queries (>0.003 s): 0

#Query time (s)ControllerQuery
10 SELECT value FROM setting WHERE store_id = '0' AND `key`='config_seo_url_type'
20 SET SQL_BIG_SELECTS = 1
30.0003 SHOW TABLES LIKE 'ocfilter_setting'
40.0001 SELECT * FROM ocfilter_setting
50 ControllerStartupStartupSELECT * FROM store WHERE REPLACE(`ssl`, 'www.', '') = 'https://frontcam.ru/'
60.0016 ControllerStartupStartupSELECT * FROM `setting` WHERE store_id = '0' OR store_id = '0' ORDER BY store_id ASC
70 ControllerExtensionModuleProgromanCityManager SELECT f1.postalcode f1_postalcode, f1.offname f1_name, f1.level f1_level, f1.fias_id f1_fias_id, f1.shortname f1_shortname, CONCAT(f2.offname, ' ', f2.shortname) f2_name, f2.level f2_level, f2.fias_id f2_fias_id, CONCAT(f3.offname, ' ', f3.shortname) f3_name, f3.level f3_level, f3.fias_id f3_fias_id, CONCAT(f4.offname, ' ', f4.shortname) f4_name, f4.level f4_level, f4.fias_id f4_fias_id FROM fias f1 LEFT JOIN fias f2 ON f2.fias_id = f1.parent_id LEFT JOIN fias f3 ON f3.fias_id = f2.parent_id LEFT JOIN fias f4 ON f4.fias_id = f3.parent_id WHERE f1.offname = 'Ашберн' AND (f3.offname = 'США' OR f2.offname = 'США' OR f4.offname = 'США') AND (f1.level = 4 OR (f1.level = 1 AND f1.shortname = 'г.'))
80 ControllerExtensionModuleProgromanCityManagerSELECT * FROM country c WHERE c.iso_code_2 = 'US'
90 ControllerExtensionModuleProgromanCityManagerSELECT * FROM currency
100 ControllerExtensionModuleProgromanCityManagerSELECT tr1.tax_class_id, tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority FROM tax_rule tr1 LEFT JOIN tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id) INNER JOIN tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id) LEFT JOIN zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id) LEFT JOIN 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 = '223' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '0') ORDER BY tr1.priority ASC
110 ControllerExtensionModuleProgromanCityManagerSELECT tr1.tax_class_id, tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority FROM tax_rule tr1 LEFT JOIN tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id) INNER JOIN tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id) LEFT JOIN zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id) LEFT JOIN 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 = '223' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '0') ORDER BY tr1.priority ASC
120 ControllerExtensionModuleProgromanCityManagerSELECT tr1.tax_class_id, tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority FROM tax_rule tr1 LEFT JOIN tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id) INNER JOIN tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id) LEFT JOIN zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id) LEFT JOIN 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
130 ControllerExtensionModuleProgromanCityManagerSELECT * FROM weight_class wc LEFT JOIN weight_class_description wcd ON (wc.weight_class_id = wcd.weight_class_id) WHERE wcd.language_id = '1'
140 ControllerExtensionModuleProgromanCityManagerSELECT * FROM length_class mc LEFT JOIN length_class_description mcd ON (mc.length_class_id = mcd.length_class_id) WHERE mcd.language_id = '1'
150.0001 ControllerExtensionModuleProgromanCityManagerDELETE FROM cart WHERE date_added < DATE_SUB(NOW(), INTERVAL '30' DAY)
160.0003 ControllerExtensionModuleProgromanCityManagerSHOW TABLES LIKE 'cartkeeper'
170.0002 ControllerExtensionModuleProgromanCityManagerSHOW TABLES LIKE 'cartkeeper_share'
180.0009 ControllerExtensionModuleProgromanCityManagerDELETE FROM cartkeeper WHERE date_added < DATE_SUB(NOW(), INTERVAL '30' DAY)
190.0001 ControllerExtensionModuleProgromanCityManagerDELETE FROM cartkeeper_share WHERE customer_id = '0' AND date_added < DATE_SUB(NOW(), INTERVAL '3' DAY)
200.0001 ControllerExtensionModuleProgromanCityManagerDELETE FROM cartkeeper_share WHERE customer_id != '0' AND date_added < DATE_SUB(NOW(), INTERVAL '14' DAY)
210.0002 ControllerExtensionModuleProgromanCityManagerSELECT `session_id` FROM `cart` WHERE `session_id` = 'mlakgkntsnndkpqkhkrerlm062' LIMIT 1
220 ControllerStartupEventSELECT * FROM `event` WHERE `trigger` LIKE 'catalog/%' AND status = '1' ORDER BY `event_id` ASC
230.0007 ControllerStartupSeoProSELECT category_id, parent_id FROM category ORDER BY parent_id
240 ControllerStartupSeoProSELECT query FROM url_alias WHERE keyword = 'auto-audio' LIMIT 1
250.0008 ControllerStartupSeoProSELECT query FROM url_alias WHERE keyword = 'subwoofers' LIMIT 1
260.0006 ControllerStartupSeoProSELECT query FROM url_alias WHERE keyword = 'auto-audio/subwoofers/' LIMIT 1
270 ControllerStartupSeoProSELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=71' LIMIT 1
280 ControllerStartupSeoProSELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=74' LIMIT 1
290 ControllerProductCategorySELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'common/home' LIMIT 1
300 ControllerProductCategorySELECT DISTINCT * FROM category c LEFT JOIN category_description cd ON (c.category_id = cd.category_id) LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.category_id = '71' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
310 ControllerProductCategorySELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=71' LIMIT 1
320.0002 ControllerProductCategorySELECT DISTINCT * FROM category c LEFT JOIN category_description cd ON (c.category_id = cd.category_id) LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.category_id = '74' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
330 ControllerProductCategorySELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=71' LIMIT 1
340 ControllerProductCategorySELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=74' LIMIT 1
350 ControllerProductCategorySELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'product/compare' LIMIT 1
360 ControllerProductCategorySELECT * FROM category c LEFT JOIN category_description cd ON (c.category_id = cd.category_id) LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '74' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)
370.0001 ControllerProductCategorySELECT * FROM category_to_layout WHERE category_id = '74' AND store_id = '0'
380 ControllerProductCategorySELECT * FROM layout_route WHERE 'product/category' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1
390 ControllerProductCategorySELECT * FROM layout_module WHERE layout_id = '3' AND `code` = 'ocfilter'
400.0001 ControllerProductCategorySELECT c.category_id FROM category c LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '74' AND c2s.store_id = '0' LIMIT 1
410.0007 ControllerProductCategorySELECT COUNT(DISTINCT p.product_id) AS total FROM product_to_category p2c LEFT JOIN product p ON (p2c.product_id = p.product_id) LEFT JOIN product_description pd ON (p.product_id = pd.product_id) LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id) WHERE /* pd.language_id = '1' AND */ p.status = '1' /* AND p.date_available <= NOW()*/ AND p2s.store_id = '0' AND p.quantity != '-1' AND p.catalog_output = '1' AND p2c.category_id = '74'
420.0004 ControllerProductCategorySELECT p.product_id, /*(SELECT p2.quantity FROM product p2 where p.id_baza = p2.product_id) as quantity_baza, (SELECT p2.quantity FROM product p2 where p.id_ramka = p2.product_id) as quantity_ramka, (SELECT p2.quantity FROM product p2 where p.id_provod = p2.product_id) as quantity_provod, (SELECT AVG(rating) AS total FROM review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT price FROM 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 product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special FROM product_to_category p2c LEFT JOIN product p ON (p2c.product_id = p.product_id) LEFT JOIN product_description pd ON (p.product_id = pd.product_id) LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id) WHERE p.status = '1' AND p.catalog_output = '1' AND p2c.category_id = '74' GROUP BY p.product_id ORDER BY p.viewed DESC, LCASE(pd.name) DESC LIMIT 0,36
430.0004 ControllerProductCategorySELECT DISTINCT *, pd.name AS name, p.image, p.market_output, m.name AS manufacturer, (SELECT p2.quantity from product p2 where p.id_baza = p2.product_id) as quantity_baza, (SELECT p2.quantity from product p2 where p.id_ramka = p2.product_id) as quantity_ramka, (SELECT p2.quantity from product p2 where p.id_provod = p2.product_id) as quantity_provod, /*(SELECT price FROM 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 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 product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name FROM stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM 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 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 review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, */ (SELECT COUNT(*) AS total FROM review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM product p LEFT JOIN product_description pd ON (p.product_id = pd.product_id) LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '42768' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
440.0006 ControllerProductCategorySELECT DISTINCT *, pd.name AS name, p.image, p.market_output, m.name AS manufacturer, (SELECT p2.quantity from product p2 where p.id_baza = p2.product_id) as quantity_baza, (SELECT p2.quantity from product p2 where p.id_ramka = p2.product_id) as quantity_ramka, (SELECT p2.quantity from product p2 where p.id_provod = p2.product_id) as quantity_provod, /*(SELECT price FROM 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 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 product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name FROM stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM 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 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 review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, */ (SELECT COUNT(*) AS total FROM review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM product p LEFT JOIN product_description pd ON (p.product_id = pd.product_id) LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '42788' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
450.0005 ControllerProductCategorySELECT DISTINCT *, pd.name AS name, p.image, p.market_output, m.name AS manufacturer, (SELECT p2.quantity from product p2 where p.id_baza = p2.product_id) as quantity_baza, (SELECT p2.quantity from product p2 where p.id_ramka = p2.product_id) as quantity_ramka, (SELECT p2.quantity from product p2 where p.id_provod = p2.product_id) as quantity_provod, /*(SELECT price FROM 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 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 product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name FROM stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM 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 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 review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, */ (SELECT COUNT(*) AS total FROM review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM product p LEFT JOIN product_description pd ON (p.product_id = pd.product_id) LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '42787' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
460.0005 ControllerProductCategorySELECT DISTINCT *, pd.name AS name, p.image, p.market_output, m.name AS manufacturer, (SELECT p2.quantity from product p2 where p.id_baza = p2.product_id) as quantity_baza, (SELECT p2.quantity from product p2 where p.id_ramka = p2.product_id) as quantity_ramka, (SELECT p2.quantity from product p2 where p.id_provod = p2.product_id) as quantity_provod, /*(SELECT price FROM 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 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 product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name FROM stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM 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 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 review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, */ (SELECT COUNT(*) AS total FROM review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM product p LEFT JOIN product_description pd ON (p.product_id = pd.product_id) LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '42789' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
470.0005 ControllerProductCategorySELECT DISTINCT *, pd.name AS name, p.image, p.market_output, m.name AS manufacturer, (SELECT p2.quantity from product p2 where p.id_baza = p2.product_id) as quantity_baza, (SELECT p2.quantity from product p2 where p.id_ramka = p2.product_id) as quantity_ramka, (SELECT p2.quantity from product p2 where p.id_provod = p2.product_id) as quantity_provod, /*(SELECT price FROM 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 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 product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name FROM stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM 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 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 review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, */ (SELECT COUNT(*) AS total FROM review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM product p LEFT JOIN product_description pd ON (p.product_id = pd.product_id) LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '42786' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
480.0004 ControllerProductCategorySELECT DISTINCT *, pd.name AS name, p.image, p.market_output, m.name AS manufacturer, (SELECT p2.quantity from product p2 where p.id_baza = p2.product_id) as quantity_baza, (SELECT p2.quantity from product p2 where p.id_ramka = p2.product_id) as quantity_ramka, (SELECT p2.quantity from product p2 where p.id_provod = p2.product_id) as quantity_provod, /*(SELECT price FROM 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 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 product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name FROM stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM 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 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 review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, */ (SELECT COUNT(*) AS total FROM review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM product p LEFT JOIN product_description pd ON (p.product_id = pd.product_id) LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '42790' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
490.0003 ControllerProductCategorySELECT * FROM product_image WHERE product_id = '42768' ORDER BY sort_order ASC
500.0005 ControllerProductCategorySELECT ag.attribute_group_id, agd.name, agd.tooltip FROM product_attribute pa LEFT JOIN attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id) LEFT JOIN attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id) WHERE pa.product_id = '42768' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
510.0005 ControllerProductCategorySELECT a.attribute_id, ad.name, ad.tooltip, pa.text FROM product_attribute pa LEFT JOIN attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN attribute_description ad ON (a.attribute_id = ad.attribute_id) WHERE pa.product_id = '42768' AND a.attribute_group_id = '10' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
520.0004 ControllerProductCategorySELECT DISTINCT *, pd.name AS name, p.image, p.market_output, m.name AS manufacturer, (SELECT p2.quantity from product p2 where p.id_baza = p2.product_id) as quantity_baza, (SELECT p2.quantity from product p2 where p.id_ramka = p2.product_id) as quantity_ramka, (SELECT p2.quantity from product p2 where p.id_provod = p2.product_id) as quantity_provod, /*(SELECT price FROM 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 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 product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name FROM stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM 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 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 review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, */ (SELECT COUNT(*) AS total FROM review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM product p LEFT JOIN product_description pd ON (p.product_id = pd.product_id) LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '42768' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
530.0001 ControllerProductCategorySELECT category_id FROM product_to_category WHERE product_id = '42768' ORDER BY main_category DESC LIMIT 1
540 ControllerProductCategorySELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=71' LIMIT 1
550 ControllerProductCategorySELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=74' LIMIT 1
560.0001 ControllerProductCategorySELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'product_id=42768' LIMIT 1
570.0002 ControllerProductCategorySELECT * FROM product_image WHERE product_id = '42788' ORDER BY sort_order ASC
580.0005 ControllerProductCategorySELECT ag.attribute_group_id, agd.name, agd.tooltip FROM product_attribute pa LEFT JOIN attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id) LEFT JOIN attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id) WHERE pa.product_id = '42788' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
590.0007 ControllerProductCategorySELECT a.attribute_id, ad.name, ad.tooltip, pa.text FROM product_attribute pa LEFT JOIN attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN attribute_description ad ON (a.attribute_id = ad.attribute_id) WHERE pa.product_id = '42788' AND a.attribute_group_id = '10' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
600.0004 ControllerProductCategorySELECT DISTINCT *, pd.name AS name, p.image, p.market_output, m.name AS manufacturer, (SELECT p2.quantity from product p2 where p.id_baza = p2.product_id) as quantity_baza, (SELECT p2.quantity from product p2 where p.id_ramka = p2.product_id) as quantity_ramka, (SELECT p2.quantity from product p2 where p.id_provod = p2.product_id) as quantity_provod, /*(SELECT price FROM 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 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 product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name FROM stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM 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 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 review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, */ (SELECT COUNT(*) AS total FROM review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM product p LEFT JOIN product_description pd ON (p.product_id = pd.product_id) LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '42788' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
610.0001 ControllerProductCategorySELECT category_id FROM product_to_category WHERE product_id = '42788' ORDER BY main_category DESC LIMIT 1
620 ControllerProductCategorySELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=71' LIMIT 1
630 ControllerProductCategorySELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=74' LIMIT 1
640.0001 ControllerProductCategorySELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'product_id=42788' LIMIT 1
650.0001 ControllerProductCategorySELECT * FROM product_image WHERE product_id = '42787' ORDER BY sort_order ASC
660.0004 ControllerProductCategorySELECT ag.attribute_group_id, agd.name, agd.tooltip FROM product_attribute pa LEFT JOIN attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id) LEFT JOIN attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id) WHERE pa.product_id = '42787' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
670.0003 ControllerProductCategorySELECT a.attribute_id, ad.name, ad.tooltip, pa.text FROM product_attribute pa LEFT JOIN attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN attribute_description ad ON (a.attribute_id = ad.attribute_id) WHERE pa.product_id = '42787' AND a.attribute_group_id = '10' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
680.0003 ControllerProductCategorySELECT DISTINCT *, pd.name AS name, p.image, p.market_output, m.name AS manufacturer, (SELECT p2.quantity from product p2 where p.id_baza = p2.product_id) as quantity_baza, (SELECT p2.quantity from product p2 where p.id_ramka = p2.product_id) as quantity_ramka, (SELECT p2.quantity from product p2 where p.id_provod = p2.product_id) as quantity_provod, /*(SELECT price FROM 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 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 product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name FROM stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM 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 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 review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, */ (SELECT COUNT(*) AS total FROM review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM product p LEFT JOIN product_description pd ON (p.product_id = pd.product_id) LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '42787' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
690.0001 ControllerProductCategorySELECT category_id FROM product_to_category WHERE product_id = '42787' ORDER BY main_category DESC LIMIT 1
700 ControllerProductCategorySELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=71' LIMIT 1
710 ControllerProductCategorySELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=74' LIMIT 1
720.0001 ControllerProductCategorySELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'product_id=42787' LIMIT 1
730.0001 ControllerProductCategorySELECT * FROM product_image WHERE product_id = '42789' ORDER BY sort_order ASC
740.0003 ControllerProductCategorySELECT ag.attribute_group_id, agd.name, agd.tooltip FROM product_attribute pa LEFT JOIN attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id) LEFT JOIN attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id) WHERE pa.product_id = '42789' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
750.0003 ControllerProductCategorySELECT a.attribute_id, ad.name, ad.tooltip, pa.text FROM product_attribute pa LEFT JOIN attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN attribute_description ad ON (a.attribute_id = ad.attribute_id) WHERE pa.product_id = '42789' AND a.attribute_group_id = '10' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
760.0003 ControllerProductCategorySELECT DISTINCT *, pd.name AS name, p.image, p.market_output, m.name AS manufacturer, (SELECT p2.quantity from product p2 where p.id_baza = p2.product_id) as quantity_baza, (SELECT p2.quantity from product p2 where p.id_ramka = p2.product_id) as quantity_ramka, (SELECT p2.quantity from product p2 where p.id_provod = p2.product_id) as quantity_provod, /*(SELECT price FROM 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 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 product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name FROM stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM 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 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 review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, */ (SELECT COUNT(*) AS total FROM review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM product p LEFT JOIN product_description pd ON (p.product_id = pd.product_id) LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '42789' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
770.0001 ControllerProductCategorySELECT category_id FROM product_to_category WHERE product_id = '42789' ORDER BY main_category DESC LIMIT 1
780 ControllerProductCategorySELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=71' LIMIT 1
790 ControllerProductCategorySELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=74' LIMIT 1
800.0001 ControllerProductCategorySELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'product_id=42789' LIMIT 1
810.0001 ControllerProductCategorySELECT * FROM product_image WHERE product_id = '42786' ORDER BY sort_order ASC
820.0004 ControllerProductCategorySELECT ag.attribute_group_id, agd.name, agd.tooltip FROM product_attribute pa LEFT JOIN attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id) LEFT JOIN attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id) WHERE pa.product_id = '42786' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
830.0003 ControllerProductCategorySELECT a.attribute_id, ad.name, ad.tooltip, pa.text FROM product_attribute pa LEFT JOIN attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN attribute_description ad ON (a.attribute_id = ad.attribute_id) WHERE pa.product_id = '42786' AND a.attribute_group_id = '10' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
840.0003 ControllerProductCategorySELECT DISTINCT *, pd.name AS name, p.image, p.market_output, m.name AS manufacturer, (SELECT p2.quantity from product p2 where p.id_baza = p2.product_id) as quantity_baza, (SELECT p2.quantity from product p2 where p.id_ramka = p2.product_id) as quantity_ramka, (SELECT p2.quantity from product p2 where p.id_provod = p2.product_id) as quantity_provod, /*(SELECT price FROM 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 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 product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name FROM stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM 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 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 review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, */ (SELECT COUNT(*) AS total FROM review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM product p LEFT JOIN product_description pd ON (p.product_id = pd.product_id) LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '42786' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
850.0001 ControllerProductCategorySELECT category_id FROM product_to_category WHERE product_id = '42786' ORDER BY main_category DESC LIMIT 1
860 ControllerProductCategorySELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=71' LIMIT 1
870 ControllerProductCategorySELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=74' LIMIT 1
880.0001 ControllerProductCategorySELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'product_id=42786' LIMIT 1
890.0001 ControllerProductCategorySELECT * FROM product_image WHERE product_id = '42790' ORDER BY sort_order ASC
900.0003 ControllerProductCategorySELECT ag.attribute_group_id, agd.name, agd.tooltip FROM product_attribute pa LEFT JOIN attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id) LEFT JOIN attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id) WHERE pa.product_id = '42790' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
910.0003 ControllerProductCategorySELECT a.attribute_id, ad.name, ad.tooltip, pa.text FROM product_attribute pa LEFT JOIN attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN attribute_description ad ON (a.attribute_id = ad.attribute_id) WHERE pa.product_id = '42790' AND a.attribute_group_id = '10' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
920.0004 ControllerProductCategorySELECT DISTINCT *, pd.name AS name, p.image, p.market_output, m.name AS manufacturer, (SELECT p2.quantity from product p2 where p.id_baza = p2.product_id) as quantity_baza, (SELECT p2.quantity from product p2 where p.id_ramka = p2.product_id) as quantity_ramka, (SELECT p2.quantity from product p2 where p.id_provod = p2.product_id) as quantity_provod, /*(SELECT price FROM 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 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 product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name FROM stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM 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 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 review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, */ (SELECT COUNT(*) AS total FROM review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM product p LEFT JOIN product_description pd ON (p.product_id = pd.product_id) LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '42790' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
930.0001 ControllerProductCategorySELECT category_id FROM product_to_category WHERE product_id = '42790' ORDER BY main_category DESC LIMIT 1
940 ControllerProductCategorySELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=71' LIMIT 1
950 ControllerProductCategorySELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=74' LIMIT 1
960.0001 ControllerProductCategorySELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'product_id=42790' LIMIT 1
970 ControllerProductCategorySELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=71' LIMIT 1
980 ControllerProductCategorySELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=74' LIMIT 1
990 ControllerProductCategorySELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=71' LIMIT 1
1000 ControllerProductCategorySELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=74' LIMIT 1
1010 ControllerProductCategorySELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=71' LIMIT 1
1020 ControllerProductCategorySELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=74' LIMIT 1
1030 ControllerProductCategorySELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=71' LIMIT 1
1040 ControllerProductCategorySELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=74' LIMIT 1
1050 ControllerProductCategorySELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=71' LIMIT 1
1060 ControllerProductCategorySELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=74' LIMIT 1
1070 ControllerProductCategorySELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=71' LIMIT 1
1080 ControllerProductCategorySELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=74' LIMIT 1
1090 ControllerProductCategorySELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=71' LIMIT 1
1100 ControllerProductCategorySELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=74' LIMIT 1
1110 ControllerProductCategorySELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=71' LIMIT 1
1120 ControllerProductCategorySELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=74' LIMIT 1
1130 ControllerProductCategorySELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=71' LIMIT 1
1140 ControllerProductCategorySELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=74' LIMIT 1
1150 ControllerProductCategorySELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=71' LIMIT 1
1160 ControllerProductCategorySELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=74' LIMIT 1
1170 ControllerProductCategorySELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=71' LIMIT 1
1180 ControllerProductCategorySELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=74' LIMIT 1
1190 ControllerProductCategorySELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=71' LIMIT 1
1200 ControllerProductCategorySELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=74' LIMIT 1
1210 ControllerProductCategorySELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=71' LIMIT 1
1220 ControllerProductCategorySELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=74' LIMIT 1
1230 ControllerProductCategorySELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=71' LIMIT 1
1240 ControllerProductCategorySELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=74' LIMIT 1
1250 ControllerProductCategorySELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=71' LIMIT 1
1260 ControllerProductCategorySELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=74' LIMIT 1
1270 ControllerProductCategorySELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=71' LIMIT 1
1280 ControllerProductCategorySELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=74' LIMIT 1
1290 ControllerProductCategorySELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=71' LIMIT 1
1300 ControllerProductCategorySELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=74' LIMIT 1
1310 ControllerProductCategorySELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=71' LIMIT 1
1320 ControllerProductCategorySELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=74' LIMIT 1
1330 ControllerProductCategorySELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=71' LIMIT 1
1340 ControllerProductCategorySELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=74' LIMIT 1
1350 ControllerProductCategorySELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=71' LIMIT 1
1360 ControllerProductCategorySELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=74' LIMIT 1
1370 ControllerProductCategorySELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=71' LIMIT 1
1380 ControllerProductCategorySELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=74' LIMIT 1
1390 ControllerEventCompatibilitySELECT c.category_id FROM category c LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '74' AND c2s.store_id = '0' LIMIT 1
1400.0002 ControllerEventCompatibilitySELECT p.page_id, p.params, p.params_count, p.category_id, pd.name, pd.heading_title, (SELECT GROUP_CONCAT(DISTINCT cp.path_id ORDER BY cp.`level` SEPARATOR '_') AS path FROM category_path cp WHERE cp.category_id = p.category_id) AS path, (SELECT ua.keyword FROM url_alias ua WHERE ua.`query` = CONCAT('ocfilter_page_id=', p.page_id) LIMIT 1) AS keyword FROM ocfilter_page p LEFT JOIN ocfilter_page_description pd ON (p.page_id = pd.page_id) WHERE p.status = '1' AND p.dynamic = '0' AND pd.language_id = '1' AND p.category_id = '74' AND p.category = '1' ORDER BY p.page_id DESC
1410 ControllerEventCompatibilitySELECT * FROM ocfilter_setting WHERE `key` = 'placement_layout'
1420.0001 ControllerEventCompatibilitySELECT `value` FROM ocfilter_cache WHERE `key` = '1370408422'
1430.0002 ControllerEventCompatibilitySELECT COUNT(DISTINCT p.product_id) AS total, p.manufacturer_id AS vid FROM product p LEFT JOIN product_to_category p2c ON (p.product_id = p2c.product_id) WHERE p.status = '1' AND p.date_available <= '2022-05-29' AND p.catalog_output = '1' AND p2c.category_id = '74' GROUP BY vid
1440.0007 ControllerEventCompatibilitySELECT COUNT(DISTINCT p.product_id) AS total, CONCAT(fv2p.filter_id, '.', fv2p.source) AS fk, fv2p.value_id AS vid FROM ocfilter_filter_value_to_product fv2p LEFT JOIN product p ON (fv2p.product_id = p.product_id) LEFT JOIN product_to_category p2c ON (p.product_id = p2c.product_id) WHERE p.status = '1' AND p.date_available <= '2022-05-29' AND p.catalog_output = '1' AND p2c.category_id = '74' GROUP BY fk, vid
1450.0001 ControllerEventCompatibilityINSERT INTO ocfilter_cache SET `key` = '1370408422', path = 'ocfilter.counter.category.74.0.last_level.0.0.0.0.0.3921966138', `value` = '{\"1.0\":{\"178\":6},\"45.2\":{\"3049843697\":6}}', `expire` = '1653794283' ON DUPLICATE KEY UPDATE `value` = VALUES(`value`), `expire` = VALUES(`expire`)
1460 ControllerEventCompatibilitySELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'common/home' LIMIT 1
1470 ControllerCommonColumnLeftSELECT * FROM category_to_layout WHERE category_id = '74' AND store_id = '0'
1480 ControllerCommonColumnLeftSELECT * FROM layout_route WHERE 'product/category' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1
1490 ControllerCommonColumnLeftSELECT * FROM layout_module WHERE layout_id = '3' AND position = 'column_left' ORDER BY sort_order
1500 ControllerEventCompatibilitySELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=71' LIMIT 1
1510 ControllerEventCompatibilitySELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=74' LIMIT 1
1520.0002 ControllerEventCompatibilitySELECT CONCAT(f.filter_id, '.', f.source) AS filter_key FROM ocfilter_filter f LEFT JOIN ocfilter_filter_to_store f2s ON (f.filter_id = f2s.filter_id AND f.source = f2s.source) LEFT JOIN ocfilter_filter_to_category f2c ON (f.filter_id = f2c.filter_id) WHERE f.status = '1' AND f2s.store_id = '0' AND (f2c.category_id = '74' OR f2c.category_id = '0') GROUP BY f.filter_id, f.source
1530.0001 ControllerEventCompatibilitySELECT `value` FROM ocfilter_cache WHERE `key` = '799108249'
1540.0001 ControllerEventCompatibilitySELECT `value` FROM ocfilter_cache WHERE `key` = '3463394037'
1550.0001 ControllerEventCompatibilitySELECT `value` FROM ocfilter_cache WHERE `key` = '628958781'
1560.0001 ControllerEventCompatibilitySELECT `value` FROM ocfilter_cache WHERE `key` = '1830280939'
1570.0001 ControllerEventCompatibilitySELECT `value` FROM ocfilter_cache WHERE `key` = '1059489276'
1580.0002 ControllerEventCompatibilitySELECT MIN(price) AS `min`, MAX(price) AS `max` FROM (SELECT p.price FROM product p LEFT JOIN product_to_category p2c ON (p.product_id = p2c.product_id) WHERE p.price > '0' AND p.status = '1' AND p.date_available <= '2022-05-29' AND p.catalog_output = '1' AND p2c.category_id = '74') result
1590.0002 ControllerEventCompatibilitySELECT MIN(price) AS `min`, MAX(price) AS `max` FROM (SELECT ocf_ps.price FROM product_special ocf_ps LEFT JOIN product p ON (ocf_ps.product_id = p.product_id) LEFT JOIN product_to_category p2c ON (p.product_id = p2c.product_id) WHERE ocf_ps.price > '0' AND ocf_ps.customer_group_id = '1' AND ((ocf_ps.date_start = '0000-00-00' OR ocf_ps.date_start <= '2022-05-29') AND (ocf_ps.date_end = '0000-00-00' OR ocf_ps.date_end >= '2022-05-29')) AND p.status = '1' AND p.date_available <= '2022-05-29' AND p.catalog_output = '1' AND p2c.category_id = '74') result
1600.0001 ControllerEventCompatibilityINSERT INTO ocfilter_cache SET `key` = '1059489276', path = 'ocfilter.filter.2.0.slider.category.74.0.1.1.0.1.0.1.0.last_level.0.0.0.0.0.3921966138', `value` = '{\"min\":4000,\"max\":9100}', `expire` = '1653794283' ON DUPLICATE KEY UPDATE `value` = VALUES(`value`), `expire` = VALUES(`expire`)
1610.0001 ControllerEventCompatibilitySELECT `value` FROM ocfilter_cache WHERE `key` = '1401451168'
1620.0002 ControllerEventCompatibilitySELECT p.page_id, p.params, p.params_count, p.category_id, pd.name, pd.heading_title, (SELECT GROUP_CONCAT(DISTINCT cp.path_id ORDER BY cp.`level` SEPARATOR '_') AS path FROM category_path cp WHERE cp.category_id = p.category_id) AS path, (SELECT ua.keyword FROM url_alias ua WHERE ua.`query` = CONCAT('ocfilter_page_id=', p.page_id) LIMIT 1) AS keyword FROM ocfilter_page p LEFT JOIN ocfilter_page_description pd ON (p.page_id = pd.page_id) WHERE p.status = '1' AND p.dynamic = '0' AND pd.language_id = '1' AND p.category_id = '74' AND p.module = '1' ORDER BY p.page_id DESC
1630 ControllerCommonColumnRightSELECT * FROM category_to_layout WHERE category_id = '74' AND store_id = '0'
1640 ControllerCommonColumnRightSELECT * FROM layout_route WHERE 'product/category' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1
1650 ControllerCommonColumnRightSELECT * FROM layout_module WHERE layout_id = '3' AND position = 'column_right' ORDER BY sort_order
1660 ControllerCommonContentTopSELECT * FROM category_to_layout WHERE category_id = '74' AND store_id = '0'
1670 ControllerCommonContentTopSELECT * FROM layout_route WHERE 'product/category' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1
1680 ControllerCommonContentTopSELECT * FROM layout_module WHERE layout_id = '3' AND position = 'content_top' ORDER BY sort_order
1690 ControllerCommonContentBottomSELECT * FROM category_to_layout WHERE category_id = '74' AND store_id = '0'
1700 ControllerCommonContentBottomSELECT * FROM layout_route WHERE 'product/category' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1
1710 ControllerCommonContentBottomSELECT * FROM layout_module WHERE layout_id = '3' AND position = 'content_bottom' ORDER BY sort_order
1720.0001 ControllerEventCompatibilitySELECT m.*, (SELECT description FROM multi_modal_translate WHERE `key` = 'title' AND modal_id = m.id AND lang_id = '1') AS title, (SELECT description FROM multi_modal_translate WHERE `key` = 'content' AND modal_id = m.id AND lang_id = '1') AS content FROM multi_modals m WHERE m.status = 1
1730.0001 ControllerRevolutionRevsubscribeSELECT * FROM information i LEFT JOIN information_description id ON (i.information_id = id.information_id) LEFT JOIN information_to_store i2s ON (i.information_id = i2s.information_id) WHERE id.language_id = '1' AND i2s.store_id = '0' AND i.status = '1' ORDER BY i.sort_order, LCASE(id.title) ASC
1740 ControllerRevolutionRevsubscribeSELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'information_id=22' LIMIT 1
1750 ControllerRevolutionRevsubscribeSELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'information_id=21' LIMIT 1
1760 ControllerRevolutionRevsubscribeSELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'information_id=14' LIMIT 1
1770 ControllerRevolutionRevsubscribeSELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'information_id=8' LIMIT 1
1780 ControllerRevolutionRevsubscribeSELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'information_id=6' LIMIT 1
1790 ControllerRevolutionRevsubscribeSELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'information_id=9' LIMIT 1
1800 ControllerRevolutionRevsubscribeSELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'information/contact' LIMIT 1
1810 ControllerRevolutionRevsubscribeSELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'account/return/add' LIMIT 1
1820 ControllerRevolutionRevsubscribeSELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'information/sitemap' LIMIT 1
1830 ControllerRevolutionRevsubscribeSELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'product/manufacturer' LIMIT 1
1840 ControllerRevolutionRevsubscribeSELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'account/voucher' LIMIT 1
1850 ControllerRevolutionRevsubscribeSELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'affiliate/account' LIMIT 1
1860 ControllerRevolutionRevsubscribeSELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'product/special' LIMIT 1
1870 ControllerRevolutionRevsubscribeSELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'revolution/account/revaccount' LIMIT 1
1880 ControllerRevolutionRevsubscribeSELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'account/order' LIMIT 1
1890 ControllerRevolutionRevsubscribeSELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'account/wishlist' LIMIT 1
1900 ControllerRevolutionRevsubscribeSELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'account/newsletter' LIMIT 1
1910 ControllerCommonHeaderSELECT * FROM extension WHERE `type` = 'analytics'
1920.0001 ControllerCommonCartMobiSELECT SUM(quantity) as total FROM cart WHERE api_id = '0' AND session_id = 'mlakgkntsnndkpqkhkrerlm062'
1930 ControllerCommonCartMobiSELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'checkout/simplecheckout' LIMIT 1
1940 ControllerCommonCartMobiSELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'checkout/simplecheckout' LIMIT 1
1950 ControllerExtensionModuleOCFilterSELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'product/compare' LIMIT 1
1960 ControllerExtensionModuleOCFilterSELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'revolution/account/revaccount' LIMIT 1
1970 ControllerExtensionModuleOCFilterSELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'account/logout' LIMIT 1
1980 ControllerExtensionModuleOCFilterSELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'common/home' LIMIT 1
1990 ControllerExtensionModuleOCFilterSELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'account/wishlist' LIMIT 1
2000 ControllerExtensionModuleOCFilterSELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'revolution/account/revaccount' LIMIT 1
2010 ControllerExtensionModuleOCFilterSELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'account/simpleregister' LIMIT 1
2020 ControllerExtensionModuleOCFilterSELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'account/login' LIMIT 1
2030 ControllerExtensionModuleOCFilterSELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'account/order' LIMIT 1
2040 ControllerExtensionModuleOCFilterSELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'account/transaction' LIMIT 1
2050 ControllerExtensionModuleOCFilterSELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'account/download' LIMIT 1
2060 ControllerExtensionModuleOCFilterSELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'account/logout' LIMIT 1
2070 ControllerExtensionModuleOCFilterSELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'checkout/simplecheckout' LIMIT 1
2080 ControllerExtensionModuleOCFilterSELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'checkout/simplecheckout' LIMIT 1
2090 ControllerExtensionModuleOCFilterSELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'information/contact' LIMIT 1
2100 ControllerCommonLanguageSELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'common/language/language' LIMIT 1
2110 ControllerCommonLanguageSELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=71' LIMIT 1
2120 ControllerCommonLanguageSELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=74' LIMIT 1
2130 ControllerCommonCurrencySELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'common/currency/currency' LIMIT 1
2140 ControllerCommonCurrencySELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=71' LIMIT 1
2150 ControllerCommonCurrencySELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=74' LIMIT 1
2160.0002 ControllerCommonSearchSELECT * FROM category c LEFT JOIN category_description cd ON (c.category_id = cd.category_id) LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '0' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)
2170.0001 ControllerCommonCartSELECT * FROM cart WHERE api_id = '0' AND session_id = 'mlakgkntsnndkpqkhkrerlm062'
2180 ControllerCommonCartSELECT * FROM extension WHERE `type` = 'total'
2190 ControllerEventCompatibilitySELECT * FROM cart WHERE api_id = '0' AND session_id = 'mlakgkntsnndkpqkhkrerlm062'
2200 ControllerEventCompatibilitySELECT SUM(quantity) as total FROM cart WHERE api_id = '0' AND session_id = 'mlakgkntsnndkpqkhkrerlm062'
2210 ControllerEventCompatibilitySELECT * FROM cart WHERE api_id = '0' AND session_id = 'mlakgkntsnndkpqkhkrerlm062'
2220 ControllerEventCompatibilitySELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'checkout/simplecheckout' LIMIT 1
2230 ControllerEventCompatibilitySELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'checkout/simplecheckout' LIMIT 1
2240 ControllerExtensionModuleOCFilterSELECT SUM(quantity) as total FROM cart WHERE api_id = '0' AND session_id = 'mlakgkntsnndkpqkhkrerlm062'
0 0
Показать еще
Задать вопрос

Бесплатная консультация специалиста

Наш менеджер ответит на все ваши вопросы.

Отмена Отправить
Получить консультацию

Бесплатная консультация специалиста

Наш менеджер ответит на все ваши вопросы.

Отмена Отправить
Запись на установку

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

Открыть карту
Отмена Отправить
Заявка на подбор автомагнитолы

Заполните форму для подбора автомагнитолы

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

Отмена Отправить
Нашли аналог дешевле?

Снижение цены гарантируется если условия конкурента выгоднее.

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

Отмена Отправить
Заявка на обратный звонок

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

Отмена Отправить
Связь с руководством

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

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

Отмена Отправить
Сообщить о неточности в описании

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

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

Отмена Отправить