Планшеты под рамки Tesla Style 9.7"

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

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

Работаем с 2012 года

8 (800) 700-26-44 +7 (495) 220-33-59 +7 (977) 809-33-59 Без выходных: 9:00-20:00

+7 (495) 220-33-59 +7 (977) 809-33-59

Спросите у нас:

Наши обзоры:

8 (800) 700-26-44 8 (495) 220-33-59 8 (977) 809-33-59

Подобрать магнитолу Обратный звонок Запись на установку

Каталог товаров

Штатные магнитолы

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

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

Противоугонное оборудование

Автомониторы

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

Автозвук

Аксессуары

Услуги

8 (800) 700-26-44

Фильтр

24900 - 32600 р. Цена

- р.

Типоразмер

Операционная система

Индекс производительности

Количество ядер процессора

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

Диагональ экрана

Разрешение экрана

Тип матрицы экрана

Наличие CD/DVD привода

Встроенный DSP процессор

Встроенный 4G модем (SIM)

Процессор

Радиомодуль

Поддержка RDS

Усилитель

Поддержка Яндекс Навигатора

Цвет подсветки клавиш

Разделение экрана

Поддержка камер AHD

Голосовое управление магнитолой

Поддержка онлайн кинотеатров

Встроенная память

Беспроводной Android Auto

Беспроводной CarPlay

Проводной Android Auto

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

Сортировка:

Показать:

Фильтр

В закладки

В сравнение

2 DIN Teyes TPRO 2 DS (Tesla style) 9.7 дюймов 4/64 на Android 10 (4G-SIM, DSP, QLed)

Артикул: 105257

2 DIN Teyes TPRO 2 DS (Tesla style) 9.7 дюймов 4/64 на Android 10 (4G-SIM, DSP, QLed)

В наличии Ташкентская 28с1

Система:Android 10

Память ОЗУ:4 Gb

Индекс производительности:1376

Процессор:8 ядер

Экран:9.7 дюймов

29 000 р.

В закладки

В сравнение

2 DIN LeTrun 5610 (Tesla style) 9.7 дюймов 2/32 на Android 10 (4G-SIM, DSP, QLed)

Артикул: 117104

2 DIN LeTrun 5610 (Tesla style) 9.7 дюймов 2/32 на Android 10 (4G-SIM, DSP, QLed)

В наличии Ташкентская 28с1

Система:Android 10

Память ОЗУ:2 Gb

Индекс производительности:739

Процессор:8 ядер

Экран:9.7 дюймов

25 300 р.

В закладки

В сравнение

2 DIN Teyes TPRO 2 DS (Tesla style) 9.7 дюймов 3/32 на Android 10 (4G-SIM, DSP, QLed)

Артикул: 106764

2 DIN Teyes TPRO 2 DS (Tesla style) 9.7 дюймов 3/32 на Android 10 (4G-SIM, DSP, QLed)

В наличии Ташкентская 28с1

Система:Android 10

Память ОЗУ:3 Gb

Индекс производительности:1376

Процессор:8 ядер

Экран:9.7 дюймов

26 800 р.

В закладки

В сравнение

2 DIN LeTrun 5611 (Tesla style) 9.7 дюймов 3/32 на Android 10 (4G-SIM, DSP, QLed)

Артикул: 117105

2 DIN LeTrun 5611 (Tesla style) 9.7 дюймов 3/32 на Android 10 (4G-SIM, DSP, QLed)

В наличии Ташкентская 28с1

Система:Android 10

Память ОЗУ:3 Gb

Индекс производительности:1376

Процессор:8 ядер

Экран:9.7 дюймов

27 400 р.

В закладки

В сравнение

2 DIN LeTrun 5620 (Tesla style) 9.7 дюймов 2/32 на Android 10 (4G-SIM, DSP, QLed)

Артикул: 117106

2 DIN LeTrun 5620 (Tesla style) 9.7 дюймов 2/32 на Android 10 (4G-SIM, DSP, QLed)

В наличии Ташкентская 28с1

Система:Android 10

Память ОЗУ:2 Gb

Индекс производительности:739

Процессор:8 ядер

Экран:9.7 дюймов

24 900 р.

В закладки

В сравнение

2 DIN LeTrun 5627 (Tesla style) 9.7 дюймов 6/128 на Android 10 (4G-SIM, DSP, QLed)

Артикул: 117109

2 DIN LeTrun 5627 (Tesla style) 9.7 дюймов 6/128 на Android 10 (4G-SIM, DSP, QLed)

Система:Android 10

Память ОЗУ:6 Gb

Индекс производительности:1376

Процессор:8 ядер

Экран:9.7 дюймов

32 600 р.

В закладки

В сравнение

2 DIN LeTrun 5621 (Tesla style) 9.7 дюймов 3/32 на Android 10 (4G-SIM, DSP, QLed)

Артикул: 117107

2 DIN LeTrun 5621 (Tesla style) 9.7 дюймов 3/32 на Android 10 (4G-SIM, DSP, QLed)

В наличии Ташкентская 28с1

Система:Android 10

Память ОЗУ:3 Gb

Индекс производительности:1376

Процессор:8 ядер

Экран:9.7 дюймов

26 700 р.

В закладки

В сравнение

2 DIN LeTrun 5623 (Tesla style) 9.7 дюймов 4/64 на Android 10 (4G-SIM, DSP, QLed)

Артикул: 117108

2 DIN LeTrun 5623 (Tesla style) 9.7 дюймов 4/64 на Android 10 (4G-SIM, DSP, QLed)

Система:Android 10

Память ОЗУ:4 Gb

Индекс производительности:1376

Процессор:8 ядер

Экран:9.7 дюймов

29 600 р.

В закладки

В сравнение

2 DIN Teyes TPRO 2 MJD (Tesla style) 9.7 дюймов 4/64 на Android 10 (4G-SIM, DSP, QLed)

Артикул: 132354

2 DIN Teyes TPRO 2 MJD (Tesla style) 9.7 дюймов 4/64 на Android 10 (4G-SIM, DSP, QLed)

В наличии Ташкентская 28с1

Система:Android 10

Память ОЗУ:4 Gb

Индекс производительности:1376

Процессор:8 ядер

Экран:9.7 дюймов

29 000 р.

В закладки

В сравнение

2 DIN Teyes TPRO 2 MJD (Tesla style) 9.7 дюймов 3/32 на Android 10 (4G-SIM, DSP, QLed)

Артикул: 132353

2 DIN Teyes TPRO 2 MJD (Tesla style) 9.7 дюймов 3/32 на Android 10 (4G-SIM, DSP, QLed)

В наличии Ташкентская 28с1

Система:Android 10

Память ОЗУ:3 Gb

Индекс производительности:1376

Процессор:8 ядер

Экран:9.7 дюймов

26 800 р.

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

Надежность

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

Большой опыт

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

Оплата потом

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

Установка

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

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

Created by frontcam.ru

Total time: 0.203 s | Queries: 348 | Slow queries (>0.003 s): 0

#	Query time (s)	Controller	Query
1	0		SELECT value FROM setting WHERE store_id = '0' AND `key`='config_seo_url_type'
2	0		SET SQL_BIG_SELECTS = 1
3	0.0003		SHOW TABLES LIKE 'ocfilter_setting'
4	0.0001		SELECT * FROM ocfilter_setting
5	0	ControllerStartupStartup	SELECT * FROM store WHERE REPLACE(`ssl`, 'www.', '') = 'https://frontcam.ru/'
6	0.0015	ControllerStartupStartup	SELECT * FROM `setting` WHERE store_id = '0' OR store_id = '0' ORDER BY store_id ASC
7	0	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 = 'г.'))
8	0	ControllerExtensionModuleProgromanCityManager	SELECT * FROM country c WHERE c.iso_code_2 = 'US'
9	0	ControllerExtensionModuleProgromanCityManager	SELECT * FROM currency
10	0	ControllerExtensionModuleProgromanCityManager	SELECT 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
11	0	ControllerExtensionModuleProgromanCityManager	SELECT 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
12	0	ControllerExtensionModuleProgromanCityManager	SELECT 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
13	0	ControllerExtensionModuleProgromanCityManager	SELECT * FROM weight_class wc LEFT JOIN weight_class_description wcd ON (wc.weight_class_id = wcd.weight_class_id) WHERE wcd.language_id = '1'
14	0	ControllerExtensionModuleProgromanCityManager	SELECT * FROM length_class mc LEFT JOIN length_class_description mcd ON (mc.length_class_id = mcd.length_class_id) WHERE mcd.language_id = '1'
15	0.0001	ControllerExtensionModuleProgromanCityManager	DELETE FROM cart WHERE date_added < DATE_SUB(NOW(), INTERVAL '30' DAY)
16	0.0002	ControllerExtensionModuleProgromanCityManager	SHOW TABLES LIKE 'cartkeeper'
17	0.0002	ControllerExtensionModuleProgromanCityManager	SHOW TABLES LIKE 'cartkeeper_share'
18	0.0008	ControllerExtensionModuleProgromanCityManager	DELETE FROM cartkeeper WHERE date_added < DATE_SUB(NOW(), INTERVAL '30' DAY)
19	0.0001	ControllerExtensionModuleProgromanCityManager	DELETE FROM cartkeeper_share WHERE customer_id = '0' AND date_added < DATE_SUB(NOW(), INTERVAL '3' DAY)
20	0.0001	ControllerExtensionModuleProgromanCityManager	DELETE FROM cartkeeper_share WHERE customer_id != '0' AND date_added < DATE_SUB(NOW(), INTERVAL '14' DAY)
21	0.0002	ControllerExtensionModuleProgromanCityManager	SELECT `session_id` FROM `cart` WHERE `session_id` = 'tju8bbm61rpi8efhhhcr7ghhh2' LIMIT 1
22	0	ControllerStartupEvent	SELECT * FROM `event` WHERE `trigger` LIKE 'catalog/%' AND status = '1' ORDER BY `event_id` ASC
23	0.0007	ControllerStartupSeoPro	SELECT category_id, parent_id FROM category ORDER BY parent_id
24	0	ControllerStartupSeoPro	SELECT query FROM url_alias WHERE keyword = 'dvm' LIMIT 1
25	0.0004	ControllerStartupSeoPro	SELECT query FROM url_alias WHERE keyword = 'planshetnye-pod-ramki-tesla-style-9-7-djujmov' LIMIT 1
26	0.0001	ControllerStartupSeoPro	SELECT query FROM url_alias WHERE keyword = 'dvm/planshetnye-pod-ramki-tesla-style-9-7-djujmov/' LIMIT 1
27	0	ControllerStartupSeoPro	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=69' LIMIT 1
28	0.0001	ControllerStartupSeoPro	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=1713' LIMIT 1
29	0	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'common/home' LIMIT 1
30	0	ControllerProductCategory	SELECT 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 = '69' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
31	0	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=69' LIMIT 1
32	0.0002	ControllerProductCategory	SELECT 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 = '1713' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
33	0	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=69' LIMIT 1
34	0	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=1713' LIMIT 1
35	0	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'product/compare' LIMIT 1
36	0.0004	ControllerProductCategory	SELECT * 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 = '1713' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)
37	0.0002	ControllerProductCategory	SELECT * FROM category_to_layout WHERE category_id = '1713' AND store_id = '0'
38	0	ControllerProductCategory	SELECT * FROM layout_route WHERE 'product/category' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1
39	0	ControllerProductCategory	SELECT * FROM layout_module WHERE layout_id = '3' AND `code` = 'ocfilter'
40	0.0002	ControllerProductCategory	SELECT c.category_id FROM category c LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1713' AND c2s.store_id = '0' LIMIT 1
41	0.0003	ControllerProductCategory	SELECT COUNT(DISTINCT p.product_id) AS total FROM product_to_category p2c LEFT JOIN product p ON (p2c.product_id = p.product_id) 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 = '1713'
42	0.0004	ControllerProductCategory	SELECT 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 = '1713' GROUP BY p.product_id ORDER BY p.viewed DESC, LCASE(pd.name) DESC LIMIT 0,36
43	0.0004	ControllerProductCategory	SELECT DISTINCT , pd.name AS name, p.image, p.market_output, m.name AS manufacturer, (SELECT p2.quantity from product p2 where p.id_baza = p2.product_id) as quantity_baza, (SELECT p2.quantity from product p2 where p.id_ramka = p2.product_id) as quantity_ramka, (SELECT 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 = '78522' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
44	0.0003	ControllerProductCategory	SELECT DISTINCT , pd.name AS name, p.image, p.market_output, m.name AS manufacturer, (SELECT p2.quantity from product p2 where p.id_baza = p2.product_id) as quantity_baza, (SELECT p2.quantity from product p2 where p.id_ramka = p2.product_id) as quantity_ramka, (SELECT 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 = '90396' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
45	0.0003	ControllerProductCategory	SELECT DISTINCT , pd.name AS name, p.image, p.market_output, m.name AS manufacturer, (SELECT p2.quantity from product p2 where p.id_baza = p2.product_id) as quantity_baza, (SELECT p2.quantity from product p2 where p.id_ramka = p2.product_id) as quantity_ramka, (SELECT 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 = '80029' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
46	0.0003	ControllerProductCategory	SELECT DISTINCT , pd.name AS name, p.image, p.market_output, m.name AS manufacturer, (SELECT p2.quantity from product p2 where p.id_baza = p2.product_id) as quantity_baza, (SELECT p2.quantity from product p2 where p.id_ramka = p2.product_id) as quantity_ramka, (SELECT 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 = '90397' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
47	0.0003	ControllerProductCategory	SELECT DISTINCT , pd.name AS name, p.image, p.market_output, m.name AS manufacturer, (SELECT p2.quantity from product p2 where p.id_baza = p2.product_id) as quantity_baza, (SELECT p2.quantity from product p2 where p.id_ramka = p2.product_id) as quantity_ramka, (SELECT 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 = '90398' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
48	0.0003	ControllerProductCategory	SELECT DISTINCT , pd.name AS name, p.image, p.market_output, m.name AS manufacturer, (SELECT p2.quantity from product p2 where p.id_baza = p2.product_id) as quantity_baza, (SELECT p2.quantity from product p2 where p.id_ramka = p2.product_id) as quantity_ramka, (SELECT 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 = '90401' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
49	0.0003	ControllerProductCategory	SELECT DISTINCT , pd.name AS name, p.image, p.market_output, m.name AS manufacturer, (SELECT p2.quantity from product p2 where p.id_baza = p2.product_id) as quantity_baza, (SELECT p2.quantity from product p2 where p.id_ramka = p2.product_id) as quantity_ramka, (SELECT 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 = '90399' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
50	0.0003	ControllerProductCategory	SELECT DISTINCT , pd.name AS name, p.image, p.market_output, m.name AS manufacturer, (SELECT p2.quantity from product p2 where p.id_baza = p2.product_id) as quantity_baza, (SELECT p2.quantity from product p2 where p.id_ramka = p2.product_id) as quantity_ramka, (SELECT 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 = '90400' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
51	0.0003	ControllerProductCategory	SELECT DISTINCT , pd.name AS name, p.image, p.market_output, m.name AS manufacturer, (SELECT p2.quantity from product p2 where p.id_baza = p2.product_id) as quantity_baza, (SELECT p2.quantity from product p2 where p.id_ramka = p2.product_id) as quantity_ramka, (SELECT 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 = '105753' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
52	0.0003	ControllerProductCategory	SELECT DISTINCT , pd.name AS name, p.image, p.market_output, m.name AS manufacturer, (SELECT p2.quantity from product p2 where p.id_baza = p2.product_id) as quantity_baza, (SELECT p2.quantity from product p2 where p.id_ramka = p2.product_id) as quantity_ramka, (SELECT 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 = '105752' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
53	0.0001	ControllerProductCategory	SELECT * FROM product_image WHERE product_id = '78522' ORDER BY sort_order ASC
54	0.0001	ControllerProductCategory	SELECT 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 = '78522' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
55	0	ControllerProductCategory	SELECT a.attribute_id, ad.name, ad.tooltip, pa.text FROM product_attribute pa LEFT JOIN attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN attribute_description ad ON (a.attribute_id = ad.attribute_id) WHERE pa.product_id = '78522' AND a.attribute_group_id = '8' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
56	0	ControllerProductCategory	SELECT a.attribute_id, ad.name, ad.tooltip, pa.text FROM product_attribute pa LEFT JOIN attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN attribute_description ad ON (a.attribute_id = ad.attribute_id) WHERE pa.product_id = '78522' AND a.attribute_group_id = '18' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
57	0	ControllerProductCategory	SELECT a.attribute_id, ad.name, ad.tooltip, pa.text FROM product_attribute pa LEFT JOIN attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN attribute_description ad ON (a.attribute_id = ad.attribute_id) WHERE pa.product_id = '78522' AND a.attribute_group_id = '22' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
58	0	ControllerProductCategory	SELECT a.attribute_id, ad.name, ad.tooltip, pa.text FROM product_attribute pa LEFT JOIN attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN attribute_description ad ON (a.attribute_id = ad.attribute_id) WHERE pa.product_id = '78522' AND a.attribute_group_id = '19' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
59	0	ControllerProductCategory	SELECT a.attribute_id, ad.name, ad.tooltip, pa.text FROM product_attribute pa LEFT JOIN attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN attribute_description ad ON (a.attribute_id = ad.attribute_id) WHERE pa.product_id = '78522' AND a.attribute_group_id = '21' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
60	0	ControllerProductCategory	SELECT a.attribute_id, ad.name, ad.tooltip, pa.text FROM product_attribute pa LEFT JOIN attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN attribute_description ad ON (a.attribute_id = ad.attribute_id) WHERE pa.product_id = '78522' AND a.attribute_group_id = '20' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
61	0.0004	ControllerProductCategory	SELECT DISTINCT , pd.name AS name, p.image, p.market_output, m.name AS manufacturer, (SELECT p2.quantity from product p2 where p.id_baza = p2.product_id) as quantity_baza, (SELECT p2.quantity from product p2 where p.id_ramka = p2.product_id) as quantity_ramka, (SELECT 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 = '78522' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
62	0	ControllerProductCategory	SELECT category_id FROM product_to_category WHERE product_id = '78522' ORDER BY main_category DESC LIMIT 1
63	0	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=69' LIMIT 1
64	0	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'product_id=78522' LIMIT 1
65	0	ControllerProductCategory	SELECT * FROM product_image WHERE product_id = '90396' ORDER BY sort_order ASC
66	0.0011	ControllerProductCategory	SELECT 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 = '90396' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
67	0.0008	ControllerProductCategory	SELECT a.attribute_id, ad.name, ad.tooltip, pa.text FROM product_attribute pa LEFT JOIN attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN attribute_description ad ON (a.attribute_id = ad.attribute_id) WHERE pa.product_id = '90396' AND a.attribute_group_id = '8' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
68	0.0005	ControllerProductCategory	SELECT a.attribute_id, ad.name, ad.tooltip, pa.text FROM product_attribute pa LEFT JOIN attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN attribute_description ad ON (a.attribute_id = ad.attribute_id) WHERE pa.product_id = '90396' AND a.attribute_group_id = '18' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
69	0.0004	ControllerProductCategory	SELECT a.attribute_id, ad.name, ad.tooltip, pa.text FROM product_attribute pa LEFT JOIN attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN attribute_description ad ON (a.attribute_id = ad.attribute_id) WHERE pa.product_id = '90396' AND a.attribute_group_id = '22' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
70	0.0004	ControllerProductCategory	SELECT a.attribute_id, ad.name, ad.tooltip, pa.text FROM product_attribute pa LEFT JOIN attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN attribute_description ad ON (a.attribute_id = ad.attribute_id) WHERE pa.product_id = '90396' AND a.attribute_group_id = '19' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
71	0.0005	ControllerProductCategory	SELECT a.attribute_id, ad.name, ad.tooltip, pa.text FROM product_attribute pa LEFT JOIN attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN attribute_description ad ON (a.attribute_id = ad.attribute_id) WHERE pa.product_id = '90396' AND a.attribute_group_id = '21' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
72	0.0003	ControllerProductCategory	SELECT a.attribute_id, ad.name, ad.tooltip, pa.text FROM product_attribute pa LEFT JOIN attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN attribute_description ad ON (a.attribute_id = ad.attribute_id) WHERE pa.product_id = '90396' AND a.attribute_group_id = '20' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
73	0.0004	ControllerProductCategory	SELECT DISTINCT , pd.name AS name, p.image, p.market_output, m.name AS manufacturer, (SELECT p2.quantity from product p2 where p.id_baza = p2.product_id) as quantity_baza, (SELECT p2.quantity from product p2 where p.id_ramka = p2.product_id) as quantity_ramka, (SELECT 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 = '90396' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
74	0.0003	ControllerProductCategory	SELECT category_id FROM product_to_category WHERE product_id = '90396' ORDER BY main_category DESC LIMIT 1
75	0	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=69' LIMIT 1
76	0.0002	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'product_id=90396' LIMIT 1
77	0.0001	ControllerProductCategory	SELECT * FROM product_image WHERE product_id = '80029' ORDER BY sort_order ASC
78	0	ControllerProductCategory	SELECT 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 = '80029' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
79	0	ControllerProductCategory	SELECT a.attribute_id, ad.name, ad.tooltip, pa.text FROM product_attribute pa LEFT JOIN attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN attribute_description ad ON (a.attribute_id = ad.attribute_id) WHERE pa.product_id = '80029' AND a.attribute_group_id = '8' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
80	0	ControllerProductCategory	SELECT a.attribute_id, ad.name, ad.tooltip, pa.text FROM product_attribute pa LEFT JOIN attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN attribute_description ad ON (a.attribute_id = ad.attribute_id) WHERE pa.product_id = '80029' AND a.attribute_group_id = '18' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
81	0	ControllerProductCategory	SELECT a.attribute_id, ad.name, ad.tooltip, pa.text FROM product_attribute pa LEFT JOIN attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN attribute_description ad ON (a.attribute_id = ad.attribute_id) WHERE pa.product_id = '80029' AND a.attribute_group_id = '22' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
82	0	ControllerProductCategory	SELECT a.attribute_id, ad.name, ad.tooltip, pa.text FROM product_attribute pa LEFT JOIN attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN attribute_description ad ON (a.attribute_id = ad.attribute_id) WHERE pa.product_id = '80029' AND a.attribute_group_id = '19' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
83	0	ControllerProductCategory	SELECT a.attribute_id, ad.name, ad.tooltip, pa.text FROM product_attribute pa LEFT JOIN attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN attribute_description ad ON (a.attribute_id = ad.attribute_id) WHERE pa.product_id = '80029' AND a.attribute_group_id = '21' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
84	0	ControllerProductCategory	SELECT a.attribute_id, ad.name, ad.tooltip, pa.text FROM product_attribute pa LEFT JOIN attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN attribute_description ad ON (a.attribute_id = ad.attribute_id) WHERE pa.product_id = '80029' AND a.attribute_group_id = '20' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
85	0.0004	ControllerProductCategory	SELECT DISTINCT , pd.name AS name, p.image, p.market_output, m.name AS manufacturer, (SELECT p2.quantity from product p2 where p.id_baza = p2.product_id) as quantity_baza, (SELECT p2.quantity from product p2 where p.id_ramka = p2.product_id) as quantity_ramka, (SELECT 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 = '80029' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
86	0	ControllerProductCategory	SELECT category_id FROM product_to_category WHERE product_id = '80029' ORDER BY main_category DESC LIMIT 1
87	0	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=69' LIMIT 1
88	0	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'product_id=80029' LIMIT 1
89	0	ControllerProductCategory	SELECT * FROM product_image WHERE product_id = '90397' ORDER BY sort_order ASC
90	0.0006	ControllerProductCategory	SELECT 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 = '90397' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
91	0.0005	ControllerProductCategory	SELECT a.attribute_id, ad.name, ad.tooltip, pa.text FROM product_attribute pa LEFT JOIN attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN attribute_description ad ON (a.attribute_id = ad.attribute_id) WHERE pa.product_id = '90397' AND a.attribute_group_id = '8' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
92	0.0005	ControllerProductCategory	SELECT a.attribute_id, ad.name, ad.tooltip, pa.text FROM product_attribute pa LEFT JOIN attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN attribute_description ad ON (a.attribute_id = ad.attribute_id) WHERE pa.product_id = '90397' AND a.attribute_group_id = '18' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
93	0.0003	ControllerProductCategory	SELECT a.attribute_id, ad.name, ad.tooltip, pa.text FROM product_attribute pa LEFT JOIN attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN attribute_description ad ON (a.attribute_id = ad.attribute_id) WHERE pa.product_id = '90397' AND a.attribute_group_id = '22' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
94	0.0004	ControllerProductCategory	SELECT a.attribute_id, ad.name, ad.tooltip, pa.text FROM product_attribute pa LEFT JOIN attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN attribute_description ad ON (a.attribute_id = ad.attribute_id) WHERE pa.product_id = '90397' AND a.attribute_group_id = '19' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
95	0.0004	ControllerProductCategory	SELECT a.attribute_id, ad.name, ad.tooltip, pa.text FROM product_attribute pa LEFT JOIN attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN attribute_description ad ON (a.attribute_id = ad.attribute_id) WHERE pa.product_id = '90397' AND a.attribute_group_id = '21' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
96	0.0003	ControllerProductCategory	SELECT a.attribute_id, ad.name, ad.tooltip, pa.text FROM product_attribute pa LEFT JOIN attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN attribute_description ad ON (a.attribute_id = ad.attribute_id) WHERE pa.product_id = '90397' AND a.attribute_group_id = '20' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
97	0.0004	ControllerProductCategory	SELECT DISTINCT , pd.name AS name, p.image, p.market_output, m.name AS manufacturer, (SELECT p2.quantity from product p2 where p.id_baza = p2.product_id) as quantity_baza, (SELECT p2.quantity from product p2 where p.id_ramka = p2.product_id) as quantity_ramka, (SELECT 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 = '90397' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
98	0.0001	ControllerProductCategory	SELECT category_id FROM product_to_category WHERE product_id = '90397' ORDER BY main_category DESC LIMIT 1
99	0	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=69' LIMIT 1
100	0.0001	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'product_id=90397' LIMIT 1
101	0.0002	ControllerProductCategory	SELECT * FROM product_image WHERE product_id = '90398' ORDER BY sort_order ASC
102	0.0007	ControllerProductCategory	SELECT 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 = '90398' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
103	0.0005	ControllerProductCategory	SELECT a.attribute_id, ad.name, ad.tooltip, pa.text FROM product_attribute pa LEFT JOIN attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN attribute_description ad ON (a.attribute_id = ad.attribute_id) WHERE pa.product_id = '90398' AND a.attribute_group_id = '8' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
104	0.0004	ControllerProductCategory	SELECT a.attribute_id, ad.name, ad.tooltip, pa.text FROM product_attribute pa LEFT JOIN attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN attribute_description ad ON (a.attribute_id = ad.attribute_id) WHERE pa.product_id = '90398' AND a.attribute_group_id = '18' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
105	0.0004	ControllerProductCategory	SELECT a.attribute_id, ad.name, ad.tooltip, pa.text FROM product_attribute pa LEFT JOIN attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN attribute_description ad ON (a.attribute_id = ad.attribute_id) WHERE pa.product_id = '90398' AND a.attribute_group_id = '22' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
106	0.0003	ControllerProductCategory	SELECT a.attribute_id, ad.name, ad.tooltip, pa.text FROM product_attribute pa LEFT JOIN attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN attribute_description ad ON (a.attribute_id = ad.attribute_id) WHERE pa.product_id = '90398' AND a.attribute_group_id = '19' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
107	0.0003	ControllerProductCategory	SELECT a.attribute_id, ad.name, ad.tooltip, pa.text FROM product_attribute pa LEFT JOIN attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN attribute_description ad ON (a.attribute_id = ad.attribute_id) WHERE pa.product_id = '90398' AND a.attribute_group_id = '21' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
108	0.0003	ControllerProductCategory	SELECT a.attribute_id, ad.name, ad.tooltip, pa.text FROM product_attribute pa LEFT JOIN attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN attribute_description ad ON (a.attribute_id = ad.attribute_id) WHERE pa.product_id = '90398' AND a.attribute_group_id = '20' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
109	0.0003	ControllerProductCategory	SELECT DISTINCT , pd.name AS name, p.image, p.market_output, m.name AS manufacturer, (SELECT p2.quantity from product p2 where p.id_baza = p2.product_id) as quantity_baza, (SELECT p2.quantity from product p2 where p.id_ramka = p2.product_id) as quantity_ramka, (SELECT 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 = '90398' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
110	0.0001	ControllerProductCategory	SELECT category_id FROM product_to_category WHERE product_id = '90398' ORDER BY main_category DESC LIMIT 1
111	0	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=69' LIMIT 1
112	0.0002	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'product_id=90398' LIMIT 1
113	0	ControllerProductCategory	SELECT * FROM product_image WHERE product_id = '90401' ORDER BY sort_order ASC
114	0.0007	ControllerProductCategory	SELECT 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 = '90401' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
115	0.0004	ControllerProductCategory	SELECT a.attribute_id, ad.name, ad.tooltip, pa.text FROM product_attribute pa LEFT JOIN attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN attribute_description ad ON (a.attribute_id = ad.attribute_id) WHERE pa.product_id = '90401' AND a.attribute_group_id = '8' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
116	0.0004	ControllerProductCategory	SELECT a.attribute_id, ad.name, ad.tooltip, pa.text FROM product_attribute pa LEFT JOIN attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN attribute_description ad ON (a.attribute_id = ad.attribute_id) WHERE pa.product_id = '90401' AND a.attribute_group_id = '18' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
117	0.0003	ControllerProductCategory	SELECT a.attribute_id, ad.name, ad.tooltip, pa.text FROM product_attribute pa LEFT JOIN attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN attribute_description ad ON (a.attribute_id = ad.attribute_id) WHERE pa.product_id = '90401' AND a.attribute_group_id = '22' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
118	0.0003	ControllerProductCategory	SELECT a.attribute_id, ad.name, ad.tooltip, pa.text FROM product_attribute pa LEFT JOIN attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN attribute_description ad ON (a.attribute_id = ad.attribute_id) WHERE pa.product_id = '90401' AND a.attribute_group_id = '19' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
119	0.0003	ControllerProductCategory	SELECT a.attribute_id, ad.name, ad.tooltip, pa.text FROM product_attribute pa LEFT JOIN attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN attribute_description ad ON (a.attribute_id = ad.attribute_id) WHERE pa.product_id = '90401' AND a.attribute_group_id = '21' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
120	0.0003	ControllerProductCategory	SELECT a.attribute_id, ad.name, ad.tooltip, pa.text FROM product_attribute pa LEFT JOIN attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN attribute_description ad ON (a.attribute_id = ad.attribute_id) WHERE pa.product_id = '90401' AND a.attribute_group_id = '20' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
121	0.0003	ControllerProductCategory	SELECT DISTINCT , pd.name AS name, p.image, p.market_output, m.name AS manufacturer, (SELECT p2.quantity from product p2 where p.id_baza = p2.product_id) as quantity_baza, (SELECT p2.quantity from product p2 where p.id_ramka = p2.product_id) as quantity_ramka, (SELECT 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 = '90401' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
122	0.0001	ControllerProductCategory	SELECT category_id FROM product_to_category WHERE product_id = '90401' ORDER BY main_category DESC LIMIT 1
123	0	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=69' LIMIT 1
124	0.0001	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'product_id=90401' LIMIT 1
125	0.0001	ControllerProductCategory	SELECT * FROM product_image WHERE product_id = '90399' ORDER BY sort_order ASC
126	0.0006	ControllerProductCategory	SELECT 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 = '90399' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
127	0.0004	ControllerProductCategory	SELECT a.attribute_id, ad.name, ad.tooltip, pa.text FROM product_attribute pa LEFT JOIN attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN attribute_description ad ON (a.attribute_id = ad.attribute_id) WHERE pa.product_id = '90399' AND a.attribute_group_id = '8' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
128	0.0004	ControllerProductCategory	SELECT a.attribute_id, ad.name, ad.tooltip, pa.text FROM product_attribute pa LEFT JOIN attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN attribute_description ad ON (a.attribute_id = ad.attribute_id) WHERE pa.product_id = '90399' AND a.attribute_group_id = '18' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
129	0.0003	ControllerProductCategory	SELECT a.attribute_id, ad.name, ad.tooltip, pa.text FROM product_attribute pa LEFT JOIN attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN attribute_description ad ON (a.attribute_id = ad.attribute_id) WHERE pa.product_id = '90399' AND a.attribute_group_id = '22' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
130	0.0003	ControllerProductCategory	SELECT a.attribute_id, ad.name, ad.tooltip, pa.text FROM product_attribute pa LEFT JOIN attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN attribute_description ad ON (a.attribute_id = ad.attribute_id) WHERE pa.product_id = '90399' AND a.attribute_group_id = '19' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
131	0.0003	ControllerProductCategory	SELECT a.attribute_id, ad.name, ad.tooltip, pa.text FROM product_attribute pa LEFT JOIN attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN attribute_description ad ON (a.attribute_id = ad.attribute_id) WHERE pa.product_id = '90399' AND a.attribute_group_id = '21' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
132	0.0003	ControllerProductCategory	SELECT a.attribute_id, ad.name, ad.tooltip, pa.text FROM product_attribute pa LEFT JOIN attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN attribute_description ad ON (a.attribute_id = ad.attribute_id) WHERE pa.product_id = '90399' AND a.attribute_group_id = '20' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
133	0.0003	ControllerProductCategory	SELECT DISTINCT , pd.name AS name, p.image, p.market_output, m.name AS manufacturer, (SELECT p2.quantity from product p2 where p.id_baza = p2.product_id) as quantity_baza, (SELECT p2.quantity from product p2 where p.id_ramka = p2.product_id) as quantity_ramka, (SELECT 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 = '90399' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
134	0.0001	ControllerProductCategory	SELECT category_id FROM product_to_category WHERE product_id = '90399' ORDER BY main_category DESC LIMIT 1
135	0	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=69' LIMIT 1
136	0.0001	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'product_id=90399' LIMIT 1
137	0.0001	ControllerProductCategory	SELECT * FROM product_image WHERE product_id = '90400' ORDER BY sort_order ASC
138	0.0006	ControllerProductCategory	SELECT 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 = '90400' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
139	0.0004	ControllerProductCategory	SELECT a.attribute_id, ad.name, ad.tooltip, pa.text FROM product_attribute pa LEFT JOIN attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN attribute_description ad ON (a.attribute_id = ad.attribute_id) WHERE pa.product_id = '90400' AND a.attribute_group_id = '8' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
140	0.0004	ControllerProductCategory	SELECT a.attribute_id, ad.name, ad.tooltip, pa.text FROM product_attribute pa LEFT JOIN attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN attribute_description ad ON (a.attribute_id = ad.attribute_id) WHERE pa.product_id = '90400' AND a.attribute_group_id = '18' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
141	0.0003	ControllerProductCategory	SELECT a.attribute_id, ad.name, ad.tooltip, pa.text FROM product_attribute pa LEFT JOIN attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN attribute_description ad ON (a.attribute_id = ad.attribute_id) WHERE pa.product_id = '90400' AND a.attribute_group_id = '22' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
142	0.0003	ControllerProductCategory	SELECT a.attribute_id, ad.name, ad.tooltip, pa.text FROM product_attribute pa LEFT JOIN attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN attribute_description ad ON (a.attribute_id = ad.attribute_id) WHERE pa.product_id = '90400' AND a.attribute_group_id = '19' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
143	0.0003	ControllerProductCategory	SELECT a.attribute_id, ad.name, ad.tooltip, pa.text FROM product_attribute pa LEFT JOIN attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN attribute_description ad ON (a.attribute_id = ad.attribute_id) WHERE pa.product_id = '90400' AND a.attribute_group_id = '21' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
144	0.0003	ControllerProductCategory	SELECT a.attribute_id, ad.name, ad.tooltip, pa.text FROM product_attribute pa LEFT JOIN attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN attribute_description ad ON (a.attribute_id = ad.attribute_id) WHERE pa.product_id = '90400' AND a.attribute_group_id = '20' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
145	0.0003	ControllerProductCategory	SELECT DISTINCT , pd.name AS name, p.image, p.market_output, m.name AS manufacturer, (SELECT p2.quantity from product p2 where p.id_baza = p2.product_id) as quantity_baza, (SELECT p2.quantity from product p2 where p.id_ramka = p2.product_id) as quantity_ramka, (SELECT 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 = '90400' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
146	0.0001	ControllerProductCategory	SELECT category_id FROM product_to_category WHERE product_id = '90400' ORDER BY main_category DESC LIMIT 1
147	0	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=69' LIMIT 1
148	0.0001	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'product_id=90400' LIMIT 1
149	0	ControllerProductCategory	SELECT * FROM product_image WHERE product_id = '105753' ORDER BY sort_order ASC
150	0	ControllerProductCategory	SELECT 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 = '105753' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
151	0	ControllerProductCategory	SELECT a.attribute_id, ad.name, ad.tooltip, pa.text FROM product_attribute pa LEFT JOIN attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN attribute_description ad ON (a.attribute_id = ad.attribute_id) WHERE pa.product_id = '105753' AND a.attribute_group_id = '8' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
152	0	ControllerProductCategory	SELECT a.attribute_id, ad.name, ad.tooltip, pa.text FROM product_attribute pa LEFT JOIN attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN attribute_description ad ON (a.attribute_id = ad.attribute_id) WHERE pa.product_id = '105753' AND a.attribute_group_id = '18' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
153	0	ControllerProductCategory	SELECT a.attribute_id, ad.name, ad.tooltip, pa.text FROM product_attribute pa LEFT JOIN attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN attribute_description ad ON (a.attribute_id = ad.attribute_id) WHERE pa.product_id = '105753' AND a.attribute_group_id = '22' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
154	0	ControllerProductCategory	SELECT a.attribute_id, ad.name, ad.tooltip, pa.text FROM product_attribute pa LEFT JOIN attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN attribute_description ad ON (a.attribute_id = ad.attribute_id) WHERE pa.product_id = '105753' AND a.attribute_group_id = '19' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
155	0	ControllerProductCategory	SELECT a.attribute_id, ad.name, ad.tooltip, pa.text FROM product_attribute pa LEFT JOIN attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN attribute_description ad ON (a.attribute_id = ad.attribute_id) WHERE pa.product_id = '105753' AND a.attribute_group_id = '21' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
156	0	ControllerProductCategory	SELECT a.attribute_id, ad.name, ad.tooltip, pa.text FROM product_attribute pa LEFT JOIN attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN attribute_description ad ON (a.attribute_id = ad.attribute_id) WHERE pa.product_id = '105753' AND a.attribute_group_id = '20' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
157	0.0004	ControllerProductCategory	SELECT DISTINCT , pd.name AS name, p.image, p.market_output, m.name AS manufacturer, (SELECT p2.quantity from product p2 where p.id_baza = p2.product_id) as quantity_baza, (SELECT p2.quantity from product p2 where p.id_ramka = p2.product_id) as quantity_ramka, (SELECT 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 = '105753' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
158	0	ControllerProductCategory	SELECT category_id FROM product_to_category WHERE product_id = '105753' ORDER BY main_category DESC LIMIT 1
159	0	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=69' LIMIT 1
160	0	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'product_id=105753' LIMIT 1
161	0	ControllerProductCategory	SELECT * FROM product_image WHERE product_id = '105752' ORDER BY sort_order ASC
162	0	ControllerProductCategory	SELECT 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 = '105752' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
163	0	ControllerProductCategory	SELECT a.attribute_id, ad.name, ad.tooltip, pa.text FROM product_attribute pa LEFT JOIN attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN attribute_description ad ON (a.attribute_id = ad.attribute_id) WHERE pa.product_id = '105752' AND a.attribute_group_id = '8' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
164	0	ControllerProductCategory	SELECT a.attribute_id, ad.name, ad.tooltip, pa.text FROM product_attribute pa LEFT JOIN attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN attribute_description ad ON (a.attribute_id = ad.attribute_id) WHERE pa.product_id = '105752' AND a.attribute_group_id = '18' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
165	0	ControllerProductCategory	SELECT a.attribute_id, ad.name, ad.tooltip, pa.text FROM product_attribute pa LEFT JOIN attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN attribute_description ad ON (a.attribute_id = ad.attribute_id) WHERE pa.product_id = '105752' AND a.attribute_group_id = '22' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
166	0	ControllerProductCategory	SELECT a.attribute_id, ad.name, ad.tooltip, pa.text FROM product_attribute pa LEFT JOIN attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN attribute_description ad ON (a.attribute_id = ad.attribute_id) WHERE pa.product_id = '105752' AND a.attribute_group_id = '19' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
167	0	ControllerProductCategory	SELECT a.attribute_id, ad.name, ad.tooltip, pa.text FROM product_attribute pa LEFT JOIN attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN attribute_description ad ON (a.attribute_id = ad.attribute_id) WHERE pa.product_id = '105752' AND a.attribute_group_id = '21' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
168	0	ControllerProductCategory	SELECT a.attribute_id, ad.name, ad.tooltip, pa.text FROM product_attribute pa LEFT JOIN attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN attribute_description ad ON (a.attribute_id = ad.attribute_id) WHERE pa.product_id = '105752' AND a.attribute_group_id = '20' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
169	0.0004	ControllerProductCategory	SELECT DISTINCT , pd.name AS name, p.image, p.market_output, m.name AS manufacturer, (SELECT p2.quantity from product p2 where p.id_baza = p2.product_id) as quantity_baza, (SELECT p2.quantity from product p2 where p.id_ramka = p2.product_id) as quantity_ramka, (SELECT 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 = '105752' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
170	0	ControllerProductCategory	SELECT category_id FROM product_to_category WHERE product_id = '105752' ORDER BY main_category DESC LIMIT 1
171	0	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=69' LIMIT 1
172	0	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'product_id=105752' LIMIT 1
173	0	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=69' LIMIT 1
174	0	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=1713' LIMIT 1
175	0	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=69' LIMIT 1
176	0	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=1713' LIMIT 1
177	0	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=69' LIMIT 1
178	0	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=1713' LIMIT 1
179	0	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=69' LIMIT 1
180	0	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=1713' LIMIT 1
181	0	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=69' LIMIT 1
182	0	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=1713' LIMIT 1
183	0	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=69' LIMIT 1
184	0	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=1713' LIMIT 1
185	0	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=69' LIMIT 1
186	0	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=1713' LIMIT 1
187	0	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=69' LIMIT 1
188	0	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=1713' LIMIT 1
189	0	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=69' LIMIT 1
190	0	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=1713' LIMIT 1
191	0	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=69' LIMIT 1
192	0	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=1713' LIMIT 1
193	0	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=69' LIMIT 1
194	0	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=1713' LIMIT 1
195	0	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=69' LIMIT 1
196	0	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=1713' LIMIT 1
197	0	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=69' LIMIT 1
198	0	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=1713' LIMIT 1
199	0	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=69' LIMIT 1
200	0	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=1713' LIMIT 1
201	0	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=69' LIMIT 1
202	0	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=1713' LIMIT 1
203	0	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=69' LIMIT 1
204	0	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=1713' LIMIT 1
205	0	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=69' LIMIT 1
206	0	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=1713' LIMIT 1
207	0	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=69' LIMIT 1
208	0	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=1713' LIMIT 1
209	0	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=69' LIMIT 1
210	0	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=1713' LIMIT 1
211	0	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=69' LIMIT 1
212	0	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=1713' LIMIT 1
213	0	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=69' LIMIT 1
214	0	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=1713' LIMIT 1
215	0	ControllerEventCompatibility	SELECT c.category_id FROM category c LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1713' AND c2s.store_id = '0' LIMIT 1
216	0.0002	ControllerEventCompatibility	SELECT p.page_id, p.params, p.params_count, p.category_id, pd.name, pd.heading_title, (SELECT GROUP_CONCAT(DISTINCT cp.path_id ORDER BY cp.`level` SEPARATOR '_') AS path FROM category_path cp WHERE cp.category_id = p.category_id) AS path, (SELECT ua.keyword FROM url_alias ua WHERE ua.`query` = CONCAT('ocfilter_page_id=', p.page_id) LIMIT 1) AS keyword FROM ocfilter_page p LEFT JOIN ocfilter_page_description pd ON (p.page_id = pd.page_id) WHERE p.status = '1' AND p.dynamic = '0' AND pd.language_id = '1' AND p.category_id = '1713' AND p.category = '1' ORDER BY p.page_id DESC
217	0	ControllerEventCompatibility	SELECT * FROM ocfilter_setting WHERE `key` = 'placement_layout'
218	0.0001	ControllerEventCompatibility	SELECT `value` FROM ocfilter_cache WHERE `key` = '3684533298'
219	0.0002	ControllerEventCompatibility	SELECT COUNT(DISTINCT p.product_id) AS total, p.manufacturer_id AS vid FROM product p LEFT JOIN product_to_category p2c ON (p.product_id = p2c.product_id) WHERE p.status = '1' AND p.date_available <= '2022-05-29' AND p.catalog_output = '1' AND p2c.category_id = '1713' GROUP BY vid
220	0.0012	ControllerEventCompatibility	SELECT COUNT(DISTINCT p.product_id) AS total, CONCAT(fv2p.filter_id, '.', fv2p.source) AS fk, fv2p.value_id AS vid FROM ocfilter_filter_value_to_product fv2p LEFT JOIN product p ON (fv2p.product_id = p.product_id) LEFT JOIN product_to_category p2c ON (p.product_id = p2c.product_id) WHERE p.status = '1' AND p.date_available <= '2022-05-29' AND p.catalog_output = '1' AND p2c.category_id = '1713' GROUP BY fk, vid
221	0.0002	ControllerEventCompatibility	INSERT INTO ocfilter_cache SET `key` = '3684533298', path = 'ocfilter.counter.category.1713.0.last_level.0.0.0.0.0.229824060', `value` = '{\"1.0\":{\"136\":6,\"179\":4},\"100.2\":{\"3744679653\":10},\"101.2\":{\"2773675188\":10},\"102.2\":{\"3687225048\":10},\"103.2\":{\"872742374\":10},\"104.2\":{\"1040038908\":8,\"1257933674\":2},\"105.2\":{\"288513789\":2,\"587480191\":8},\"106.2\":{\"3526178466\":10},\"107.2\":{\"1039097244\":10},\"108.2\":{\"3437495825\":10},\"109.2\":{\"589720879\":10},\"111.2\":{\"4051694107\":10},\"112.2\":{\"440944920\":10},\"113.2\":{\"1013091850\":10},\"114.2\":{\"391526751\":10},\"115.2\":{\"2338523523\":6,\"4170469985\":4},\"116.2\":{\"329509218\":10},\"117.2\":{\"4234248796\":10},\"118.2\":{\"1649755345\":4,\"4217116011\":6},\"119.2\":{\"3704364236\":2,\"3802706671\":8},\"120.2\":{\"2271215396\":8,\"4195236642\":2},\"121.2\":{\"1755157530\":10},\"122.2\":{\"2208968473\":10},\"123.2\":{\"1818772519\":6},\"124.2\":{\"2549379959\":4,\"3774039009\":6},\"125.2\":{\"1635136608\":10},\"126.2\":{\"2319552355\":10},\"127.2\":{\"1703142493\":10},\"128.2\":{\"2491989968\":6},\"129.2\":{\"2068501742\":10},\"131.2\":{\"2836614106\":10},\"132.2\":{\"1109717209\":6},\"133.2\":{\"2917571559\":6},\"134.2\":{\"1329234078\":6},\"136.2\":{\"1271877795\":10},\"137.2\":{\"2752330653\":8,\"3887081080\":2},\"138.2\":{\"1426481168\":10},\"139.2\":{\"3133410094\":10},\"140.2\":{\"1877620071\":10},\"141.2\":{\"2150129241\":10},\"142.2\":{\"1797252442\":8,\"3409003989\":2},\"143.2\":{\"2229112420\":10},\"144.2\":{\"1711379741\":10},\"145.2\":{\"2311323171\":6},\"146.2\":{\"1660175648\":6},\"149.2\":{\"2482970285\":6},\"150.2\":{\"2925849255\":6},\"153.2\":{\"1163088292\":10},\"154.2\":{\"100868865\":8,\"1506361312\":2},\"38.2\":{\"3265323307\":10},\"43.2\":{\"3382328015\":10},\"53.2\":{\"3666697292\":6},\"57.2\":{\"370723372\":10},\"58.2\":{\"2898882251\":10},\"59.2\":{\"694655011\":10},\"60.2\":{\"2824372558\":10},\"61.2\":{\"274770677\":4,\"295878850\":2,\"355449968\":3,\"380332062\":1},\"62.2\":{\"3882900097\":10},\"63.2\":{\"1131362893\":10},\"64.2\":{\"2011059414\":10},\"65.2\":{\"1316047370\":10},\"66.2\":{\"751112170\":8,\"920640013\":2},\"67.2\":{\"1944079595\":10},\"68.2\":{\"2834850978\":6,\"2936359153\":4},\"76.2\":{\"2569701214\":10,\"4292743132\":10},\"77.2\":{\"2332706295\":10},\"78.2\":{\"2046893690\":10},\"79.2\":{\"2512614724\":10},\"80.2\":{\"679495998\":10},\"81.2\":{\"390134461\":2,\"1577687291\":8},\"82.2\":{\"2948014879\":10},\"83.2\":{\"2245904136\":3,\"3062778760\":6,\"4064060424\":1},\"86.2\":{\"738012645\":4,\"4147173903\":6},\"87.2\":{\"418558257\":10},\"88.2\":{\"3925469884\":10},\"89.2\":{\"104563074\":6,\"4074585929\":4},\"90.2\":{\"1000371592\":10},\"91.2\":{\"3563200182\":10},\"92.2\":{\"1062577589\":10},\"93.2\":{\"1842542135\":10},\"95.2\":{\"3716792012\":10},\"96.2\":{\"869680672\":10},\"97.2\":{\"3648810737\":10},\"98.2\":{\"678901116\":10}}', `expire` = '1653795194' ON DUPLICATE KEY UPDATE `value` = VALUES(`value`), `expire` = VALUES(`expire`)
222	0	ControllerEventCompatibility	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'common/home' LIMIT 1
223	0	ControllerCommonColumnLeft	SELECT * FROM category_to_layout WHERE category_id = '1713' AND store_id = '0'
224	0	ControllerCommonColumnLeft	SELECT * FROM layout_route WHERE 'product/category' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1
225	0	ControllerCommonColumnLeft	SELECT * FROM layout_module WHERE layout_id = '3' AND position = 'column_left' ORDER BY sort_order
226	0	ControllerEventCompatibility	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=69' LIMIT 1
227	0	ControllerEventCompatibility	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=1713' LIMIT 1
228	0.0004	ControllerEventCompatibility	SELECT CONCAT(f.filter_id, '.', f.source) AS filter_key FROM ocfilter_filter f LEFT JOIN ocfilter_filter_to_store f2s ON (f.filter_id = f2s.filter_id AND f.source = f2s.source) LEFT JOIN ocfilter_filter_to_category f2c ON (f.filter_id = f2c.filter_id) WHERE f.status = '1' AND f2s.store_id = '0' AND (f2c.category_id = '1713' OR f2c.category_id = '0') GROUP BY f.filter_id, f.source
229	0.0001	ControllerEventCompatibility	SELECT `value` FROM ocfilter_cache WHERE `key` = '799108249'
230	0.0001	ControllerEventCompatibility	SELECT `value` FROM ocfilter_cache WHERE `key` = '3463394037'
231	0.0001	ControllerEventCompatibility	SELECT `value` FROM ocfilter_cache WHERE `key` = '3236483636'
232	0.0001	ControllerEventCompatibility	SELECT `value` FROM ocfilter_cache WHERE `key` = '2856178589'
233	0.0001	ControllerEventCompatibility	SELECT `value` FROM ocfilter_cache WHERE `key` = '1633747000'
234	0.0001	ControllerEventCompatibility	SELECT `value` FROM ocfilter_cache WHERE `key` = '2497816312'
235	0.0001	ControllerEventCompatibility	SELECT `value` FROM ocfilter_cache WHERE `key` = '380711209'
236	0.0001	ControllerEventCompatibility	SELECT `value` FROM ocfilter_cache WHERE `key` = '735123609'
237	0.0001	ControllerEventCompatibility	SELECT `value` FROM ocfilter_cache WHERE `key` = '2689927238'
238	0.0001	ControllerEventCompatibility	SELECT `value` FROM ocfilter_cache WHERE `key` = '2637505014'
239	0.0001	ControllerEventCompatibility	SELECT `value` FROM ocfilter_cache WHERE `key` = '3667221286'
240	0.0001	ControllerEventCompatibility	SELECT `value` FROM ocfilter_cache WHERE `key` = '3891622550'
241	0.0001	ControllerEventCompatibility	SELECT `value` FROM ocfilter_cache WHERE `key` = '1440067206'
242	0.0001	ControllerEventCompatibility	SELECT `value` FROM ocfilter_cache WHERE `key` = '1756727094'
243	0.0001	ControllerEventCompatibility	SELECT `value` FROM ocfilter_cache WHERE `key` = '789970406'
244	0.0001	ControllerEventCompatibility	SELECT `value` FROM ocfilter_cache WHERE `key` = '309711958'
245	0.0001	ControllerEventCompatibility	SELECT `value` FROM ocfilter_cache WHERE `key` = '2418361223'
246	0.0001	ControllerEventCompatibility	SELECT `value` FROM ocfilter_cache WHERE `key` = '3830001219'
247	0	ControllerEventCompatibility	SELECT `value` FROM ocfilter_cache WHERE `key` = '1712961938'
248	0.0001	ControllerEventCompatibility	SELECT `value` FROM ocfilter_cache WHERE `key` = '2589944118'
249	0	ControllerEventCompatibility	SELECT `value` FROM ocfilter_cache WHERE `key` = '2805940358'
250	0.0001	ControllerEventCompatibility	SELECT `value` FROM ocfilter_cache WHERE `key` = '3724481510'
251	0.0001	ControllerEventCompatibility	SELECT `value` FROM ocfilter_cache WHERE `key` = '354393238'
252	0.0001	ControllerEventCompatibility	SELECT `value` FROM ocfilter_cache WHERE `key` = '1386010045'
253	0.0001	ControllerEventCompatibility	SELECT `value` FROM ocfilter_cache WHERE `key` = '2496685161'
254	0.0001	ControllerEventCompatibility	SELECT `value` FROM ocfilter_cache WHERE `key` = '3547340473'
255	0.0001	ControllerEventCompatibility	SELECT `value` FROM ocfilter_cache WHERE `key` = '1632682665'
256	0.0001	ControllerEventCompatibility	SELECT `value` FROM ocfilter_cache WHERE `key` = '1830280939'
257	0.0001	ControllerEventCompatibility	SELECT `value` FROM ocfilter_cache WHERE `key` = '3017422053'
258	0.0002	ControllerEventCompatibility	SELECT 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 = '1713') result
259	0.0002	ControllerEventCompatibility	SELECT 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 = '1713') result
260	0.0003	ControllerEventCompatibility	INSERT INTO ocfilter_cache SET `key` = '3017422053', path = 'ocfilter.filter.2.0.slider.category.1713.0.1.1.0.1.0.1.0.last_level.0.0.0.0.0.229824060', `value` = '{\"min\":24900,\"max\":32600}', `expire` = '1653795194' ON DUPLICATE KEY UPDATE `value` = VALUES(`value`), `expire` = VALUES(`expire`)
261	0.0001	ControllerEventCompatibility	SELECT `value` FROM ocfilter_cache WHERE `key` = '2958325014'
262	0.0001	ControllerEventCompatibility	SELECT `value` FROM ocfilter_cache WHERE `key` = '3166033728'
263	0.0001	ControllerEventCompatibility	SELECT `value` FROM ocfilter_cache WHERE `key` = '1629687493'
264	0.0001	ControllerEventCompatibility	SELECT `value` FROM ocfilter_cache WHERE `key` = '1646605754'
265	0.0001	ControllerEventCompatibility	SELECT `value` FROM ocfilter_cache WHERE `key` = '280079051'
266	0.0001	ControllerEventCompatibility	SELECT `value` FROM ocfilter_cache WHERE `key` = '2333402788'
267	0.0001	ControllerEventCompatibility	SELECT `value` FROM ocfilter_cache WHERE `key` = '2876748027'
268	0.0001	ControllerEventCompatibility	SELECT `value` FROM ocfilter_cache WHERE `key` = '819133588'
269	0.0001	ControllerEventCompatibility	SELECT `value` FROM ocfilter_cache WHERE `key` = '1196174948'
270	0.0001	ControllerEventCompatibility	SELECT `value` FROM ocfilter_cache WHERE `key` = '3706282507'
271	0.0001	ControllerEventCompatibility	SELECT `value` FROM ocfilter_cache WHERE `key` = '2826013572'
272	0.0001	ControllerEventCompatibility	SELECT `value` FROM ocfilter_cache WHERE `key` = '869582827'
273	0.0001	ControllerEventCompatibility	SELECT `value` FROM ocfilter_cache WHERE `key` = '1145705755'
274	0.0001	ControllerEventCompatibility	SELECT `value` FROM ocfilter_cache WHERE `key` = '3757005172'
275	0.0001	ControllerEventCompatibility	SELECT `value` FROM ocfilter_cache WHERE `key` = '2910569989'
276	0.0001	ControllerEventCompatibility	SELECT `value` FROM ocfilter_cache WHERE `key` = '2581384350'
277	0.0001	ControllerEventCompatibility	SELECT `value` FROM ocfilter_cache WHERE `key` = '3947385839'
278	0.0001	ControllerEventCompatibility	SELECT `value` FROM ocfilter_cache WHERE `key` = '1368505419'
279	0.0001	ControllerEventCompatibility	SELECT `value` FROM ocfilter_cache WHERE `key` = '3392466980'
280	0.0001	ControllerEventCompatibility	SELECT `value` FROM ocfilter_cache WHERE `key` = '638545595'
281	0.0001	ControllerEventCompatibility	SELECT `value` FROM ocfilter_cache WHERE `key` = '3198949803'
282	0.0001	ControllerEventCompatibility	SELECT `value` FROM ocfilter_cache WHERE `key` = '2881783215'
283	0.0001	ControllerEventCompatibility	SELECT `value` FROM ocfilter_cache WHERE `key` = '3959121595'
284	0.0001	ControllerEventCompatibility	SELECT `value` FROM ocfilter_cache WHERE `key` = '2623910987'
285	0.0001	ControllerEventCompatibility	SELECT `value` FROM ocfilter_cache WHERE `key` = '3908918724'
286	0.0002	ControllerEventCompatibility	SELECT p.page_id, p.params, p.params_count, p.category_id, pd.name, pd.heading_title, (SELECT GROUP_CONCAT(DISTINCT cp.path_id ORDER BY cp.`level` SEPARATOR '_') AS path FROM category_path cp WHERE cp.category_id = p.category_id) AS path, (SELECT ua.keyword FROM url_alias ua WHERE ua.`query` = CONCAT('ocfilter_page_id=', p.page_id) LIMIT 1) AS keyword FROM ocfilter_page p LEFT JOIN ocfilter_page_description pd ON (p.page_id = pd.page_id) WHERE p.status = '1' AND p.dynamic = '0' AND pd.language_id = '1' AND p.category_id = '1713' AND p.module = '1' ORDER BY p.page_id DESC
287	0	ControllerCommonColumnRight	SELECT * FROM category_to_layout WHERE category_id = '1713' AND store_id = '0'
288	0	ControllerCommonColumnRight	SELECT * FROM layout_route WHERE 'product/category' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1
289	0	ControllerCommonColumnRight	SELECT * FROM layout_module WHERE layout_id = '3' AND position = 'column_right' ORDER BY sort_order
290	0	ControllerCommonContentTop	SELECT * FROM category_to_layout WHERE category_id = '1713' AND store_id = '0'
291	0	ControllerCommonContentTop	SELECT * FROM layout_route WHERE 'product/category' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1
292	0	ControllerCommonContentTop	SELECT * FROM layout_module WHERE layout_id = '3' AND position = 'content_top' ORDER BY sort_order
293	0	ControllerCommonContentBottom	SELECT * FROM category_to_layout WHERE category_id = '1713' AND store_id = '0'
294	0	ControllerCommonContentBottom	SELECT * FROM layout_route WHERE 'product/category' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1
295	0	ControllerCommonContentBottom	SELECT * FROM layout_module WHERE layout_id = '3' AND position = 'content_bottom' ORDER BY sort_order
296	0.0001	ControllerEventCompatibility	SELECT m.*, (SELECT description FROM multi_modal_translate WHERE `key` = 'title' AND modal_id = m.id AND lang_id = '1') AS title, (SELECT description FROM multi_modal_translate WHERE `key` = 'content' AND modal_id = m.id AND lang_id = '1') AS content FROM multi_modals m WHERE m.status = 1
297	0.0001	ControllerRevolutionRevsubscribe	SELECT * FROM information i LEFT JOIN information_description id ON (i.information_id = id.information_id) LEFT JOIN information_to_store i2s ON (i.information_id = i2s.information_id) WHERE id.language_id = '1' AND i2s.store_id = '0' AND i.status = '1' ORDER BY i.sort_order, LCASE(id.title) ASC
298	0	ControllerRevolutionRevsubscribe	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'information_id=22' LIMIT 1
299	0	ControllerRevolutionRevsubscribe	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'information_id=21' LIMIT 1
300	0	ControllerRevolutionRevsubscribe	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'information_id=14' LIMIT 1
301	0	ControllerRevolutionRevsubscribe	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'information_id=8' LIMIT 1
302	0	ControllerRevolutionRevsubscribe	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'information_id=6' LIMIT 1
303	0	ControllerRevolutionRevsubscribe	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'information_id=9' LIMIT 1
304	0	ControllerRevolutionRevsubscribe	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'information/contact' LIMIT 1
305	0	ControllerRevolutionRevsubscribe	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'account/return/add' LIMIT 1
306	0	ControllerRevolutionRevsubscribe	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'information/sitemap' LIMIT 1
307	0	ControllerRevolutionRevsubscribe	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'product/manufacturer' LIMIT 1
308	0	ControllerRevolutionRevsubscribe	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'account/voucher' LIMIT 1
309	0	ControllerRevolutionRevsubscribe	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'affiliate/account' LIMIT 1
310	0	ControllerRevolutionRevsubscribe	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'product/special' LIMIT 1
311	0	ControllerRevolutionRevsubscribe	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'revolution/account/revaccount' LIMIT 1
312	0	ControllerRevolutionRevsubscribe	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'account/order' LIMIT 1
313	0	ControllerRevolutionRevsubscribe	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'account/wishlist' LIMIT 1
314	0	ControllerRevolutionRevsubscribe	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'account/newsletter' LIMIT 1
315	0	ControllerCommonHeader	SELECT * FROM extension WHERE `type` = 'analytics'
316	0.0001	ControllerCommonCartMobi	SELECT SUM(quantity) as total FROM cart WHERE api_id = '0' AND session_id = 'tju8bbm61rpi8efhhhcr7ghhh2'
317	0	ControllerCommonCartMobi	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'checkout/simplecheckout' LIMIT 1
318	0	ControllerCommonCartMobi	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'checkout/simplecheckout' LIMIT 1
319	0	ControllerExtensionModuleOCFilter	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'product/compare' LIMIT 1
320	0	ControllerExtensionModuleOCFilter	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'revolution/account/revaccount' LIMIT 1
321	0	ControllerExtensionModuleOCFilter	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'account/logout' LIMIT 1
322	0	ControllerExtensionModuleOCFilter	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'common/home' LIMIT 1
323	0	ControllerExtensionModuleOCFilter	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'account/wishlist' LIMIT 1
324	0	ControllerExtensionModuleOCFilter	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'revolution/account/revaccount' LIMIT 1
325	0	ControllerExtensionModuleOCFilter	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'account/simpleregister' LIMIT 1
326	0	ControllerExtensionModuleOCFilter	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'account/login' LIMIT 1
327	0	ControllerExtensionModuleOCFilter	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'account/order' LIMIT 1
328	0	ControllerExtensionModuleOCFilter	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'account/transaction' LIMIT 1
329	0	ControllerExtensionModuleOCFilter	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'account/download' LIMIT 1
330	0	ControllerExtensionModuleOCFilter	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'account/logout' LIMIT 1
331	0	ControllerExtensionModuleOCFilter	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'checkout/simplecheckout' LIMIT 1
332	0	ControllerExtensionModuleOCFilter	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'checkout/simplecheckout' LIMIT 1
333	0	ControllerExtensionModuleOCFilter	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'information/contact' LIMIT 1
334	0	ControllerCommonLanguage	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'common/language/language' LIMIT 1
335	0	ControllerCommonLanguage	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=69' LIMIT 1
336	0	ControllerCommonLanguage	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=1713' LIMIT 1
337	0	ControllerCommonCurrency	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'common/currency/currency' LIMIT 1
338	0	ControllerCommonCurrency	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=69' LIMIT 1
339	0	ControllerCommonCurrency	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=1713' LIMIT 1
340	0.0002	ControllerCommonSearch	SELECT * 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)
341	0.0001	ControllerCommonCart	SELECT * FROM cart WHERE api_id = '0' AND session_id = 'tju8bbm61rpi8efhhhcr7ghhh2'
342	0	ControllerCommonCart	SELECT * FROM extension WHERE `type` = 'total'
343	0	ControllerEventCompatibility	SELECT * FROM cart WHERE api_id = '0' AND session_id = 'tju8bbm61rpi8efhhhcr7ghhh2'
344	0	ControllerEventCompatibility	SELECT SUM(quantity) as total FROM cart WHERE api_id = '0' AND session_id = 'tju8bbm61rpi8efhhhcr7ghhh2'
345	0	ControllerEventCompatibility	SELECT * FROM cart WHERE api_id = '0' AND session_id = 'tju8bbm61rpi8efhhhcr7ghhh2'
346	0	ControllerEventCompatibility	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'checkout/simplecheckout' LIMIT 1
347	0	ControllerEventCompatibility	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'checkout/simplecheckout' LIMIT 1
348	0	ControllerExtensionModuleOCFilter	SELECT SUM(quantity) as total FROM cart WHERE api_id = '0' AND session_id = 'tju8bbm61rpi8efhhhcr7ghhh2'

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

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

Отмена