iso-переходники для магнитол

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

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

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

Фильтр

Сортировка:

Показать:

Фильтр

В закладки

В сравнение

Артикул: 96972

Переходник антенный Intro ISO ANT-9 Volkswagen, Audi, Opel, Skoda, Chery, Ford, Mercedes короткий, прямой

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

150 р.

В закладки

В сравнение

Артикул: 95900

Intro ISO NS-04 Переходник Subaru / Nissan Almera, Juke, Qashqai, X-Trail, Tiida, Note, Terrano

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

350 р.

В закладки

В сравнение

Артикул: 96337

Intro ANT-1 Переходник антенный для Renault, Volkswagen, BMW, Chevrolet, Audi, Citroen, Peugeot, Opel (Fakra)

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

290 р.

В закладки

В сравнение

Адаптер рулевого управления RE/LA-R Renault Logan, Duster, Sandero, Kaptur / Lada Vesta, Xray / Nissan Terrano (обучаемый)

Артикул: 65426

Адаптер рулевого управления RE/LA-R Renault Logan, Duster, Sandero, Kaptur / Lada Vesta, Xray / Nissan Terrano (обучаемый)

2 600 р.

В закладки

В сравнение

ISO-коннектор универсальный Male 2x8 IC-UNM2x8

Артикул: 98951

ISO-коннектор универсальный Male 2x8 IC-UNM2x8

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

200 р.

В закладки

В сравнение

Артикул: 95901

Intro ISO ANT-6 Переходник Nissan 07+ Антенный

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

340 р.

В закладки

В сравнение

Артикул: 96338

Intro ISO ANT-2 Переходник антенный с питанием для Renault, Volkswagen, BMW, Chevrolet, Audi, Citroen, Peugeot, Opel (Fakra)

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

490 р.

В закладки

В сравнение

Артикул: 71076

Intro ISO HY-01 переходник Hyundai, Kia до 2005 года

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

350 р.

В закладки

В сравнение

Артикул: 96344

Intro ISO ANT-15 Переходник антенный для Toyota

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

290 р.

В закладки

В сравнение

Артикул: 71077

Intro ISO HY-02 переходник Hyundai, Kia с 2005 года

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

350 р.

В закладки

В сравнение

Артикул: 96339

Intro ISO ANT-11 Переходник антенный для Hyundai, Kia

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

390 р.

В закладки

В сравнение

Артикул: 96341

Intro ISO ANT-00 Переходник антенный с питанием для Renault, Volkswagen, BMW, Chevrolet, Audi, Citroen, Peugeot, Opel

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

390 р.

В закладки

В сравнение

Артикул: 96340

Intro ISO ANT-7 Переходник антенный с питанием для Suzuki, Mazda, Honda

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

390 р.

В закладки

В сравнение

Артикул: 58900

ISO-переходник Intro IC-CHER для Chery

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

470 р.

В закладки

В сравнение

Артикул: 71078

Intro ISO-002 универсальный ISO разъем (Европа)

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

90 р.

В закладки

В сравнение

Адаптер кнопок на руле для UAZ Patriot (УАЗ Патриот) 2016+

Артикул: 64576

Адаптер кнопок на руле для UAZ Patriot (УАЗ Патриот) 2016+

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

3 200 р.

В закладки

В сравнение

Артикул: 65442

ISO-коннектор Intro NS-03 для Nissan X-Trail T30 2005-2007, Almera 1994-2004

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

350 р.

В закладки

В сравнение

Адаптер кнопок на руле для Lada / Renault и магнитол со встроенным рулевым интерфейсом SWC-RL

Артикул: 59458

Адаптер кнопок на руле для Lada / Renault и магнитол со встроенным рулевым интерфейсом SWC-RL

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

1 200 р.

В закладки

В сравнение

ISO-коннектор Intro VW-03 FO-05 BM-01 BMW / Volkswagen / Skoda / Ford / Opel (квадралок)

Артикул: 65376

ISO-коннектор Intro VW-03 FO-05 BM-01 BMW / Volkswagen / Skoda / Ford / Opel (квадралок)

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

350 р.

В закладки

В сравнение

Артикул: 64884

ISO-переходник Intro MS-07 для Mitsubishi ASX, Lancer, Outlander, Pajero

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

350 р.

В закладки

В сравнение

ISO-коннектор для Suzuki Grand Vitara, SX4 Intro HO-99

Артикул: 63119

ISO-коннектор для Suzuki Grand Vitara, SX4 Intro HO-99

350 р.

В закладки

В сравнение

Артикул: 58905

Connects2 CTSVL004 адаптер кнопок на руле для Volvo XC90 (2006-2014)

8 600 р.

В закладки

В сравнение

ISO-переходник для Ford C-MAX, Fiesta, Focus III, Transit, Kuga II Intro ISO FO-11

Артикул: 55080

ISO-переходник для Ford C-MAX, Fiesta, Focus III, Transit, Kuga II Intro ISO FO-11

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

600 р.

В закладки

В сравнение

Артикул: 63656

ISO-коннектор для Toyota 1987-2017 Intro ISO TY-01

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

500 р.

В закладки

В сравнение

Артикул: 64878

Переходник с ISO на штатный разъем Intro ISO VW-15 для Volkswagen, Skoda 2015+ Rapid, Octavia A7

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

780 р.

В закладки

В сравнение

ISO-коннектор Intro DWL-98 для Daewoo / SsangYong Actyon, Tivoli, XLV, Kyron, Korando

Артикул: 65353

ISO-коннектор Intro DWL-98 для Daewoo / SsangYong Actyon, Tivoli, XLV, Kyron, Korando

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

350 р.

В закладки

В сравнение

Артикул: 58903

Connects2 CTSVL002 адаптер кнопок на руле для Volvo

4 690 р.

В закладки

В сравнение

Артикул: 54955

Антенный удлинитель для Лада Гранта (Lada Granta FL) 2018+ (80 см)

500 р.

В закладки

В сравнение

ISO-коннектор на антенну IC-UNA5 для VW, Audi, Opel, Skoda 2002 - двойной (Fakra)

Артикул: 63117

ISO-коннектор на антенну IC-UNA5 для VW, Audi, Opel, Skoda 2002 - двойной (Fakra)

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

600 р.

В закладки

В сравнение

Артикул: 104733

Комплект проводов 183 для УАЗ Патриот (UAZ Patriot), Профи 2012-2021 Teyes Canbus

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

3 800 р.

В закладки

В сравнение

Артикул: 63113

ISO-коннектор для Mitsubishi L200, Pajero (Sport) 1994-2007 Intro MS-96

500 р.

В закладки

В сравнение

ISO-коннектор для KIA, Hyundai 2017-(в комплектации с USB, AUX) Incar ISO HY-04A

Артикул: 64386

ISO-коннектор для KIA, Hyundai 2017-(в комплектации с USB, AUX) Incar ISO HY-04A

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

1 200 р.

В закладки

В сравнение

ISO-переходник Intro MZ-01 для Mazda 3, 5, 6, CX-7, CX-5

Артикул: 61642

ISO-переходник Intro MZ-01 для Mazda 3, 5, 6, CX-7, CX-5

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

450 р.

В закладки

В сравнение

Артикул: 63114

ISO-коннектор на антенну для VW, Audi, Opel, Skoda Intro ANT-3 с питанием двойной (Fakra)

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

900 р.

В закладки

В сравнение

Артикул: 64721

ISO-переходник Intro HO-06 для Honda

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

320 р.

В закладки

В сравнение

ISO-коннектор для Hyundai, Kia 2010+ Intro HY-03

Артикул: 63109

ISO-коннектор для Hyundai, Kia 2010+ Intro HY-03

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

350 р.

Показать 36 60 100

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

Надежность

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

Большой опыт

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

Оплата потом

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

Установка

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

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

Created by frontcam.ru

Total time: 0.2267 s | Queries: 454 | Slow queries (>0.003 s): 2

#	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.0017	ControllerStartupStartup	SELECT * FROM `setting` WHERE store_id = '0' OR store_id = '0' ORDER BY store_id ASC
7	0.0001	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.0002	ControllerExtensionModuleProgromanCityManager	DELETE FROM cart WHERE date_added < DATE_SUB(NOW(), INTERVAL '30' DAY)
16	0.0003	ControllerExtensionModuleProgromanCityManager	SHOW TABLES LIKE 'cartkeeper'
17	0.0002	ControllerExtensionModuleProgromanCityManager	SHOW TABLES LIKE 'cartkeeper_share'
18	0.0009	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` = 'd4qj6il8pcq192v6o6jjlu6ro3' 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 = 'auto-audio' LIMIT 1
25	0.0005	ControllerStartupSeoPro	SELECT query FROM url_alias WHERE keyword = 'iso-perexodniki' LIMIT 1
26	0.0001	ControllerStartupSeoPro	SELECT query FROM url_alias WHERE keyword = 'auto-audio/iso-perexodniki/' LIMIT 1
27	0	ControllerStartupSeoPro	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=71' LIMIT 1
28	0.0001	ControllerStartupSeoPro	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=106' 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 = '71' 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=71' 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 = '106' 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=71' LIMIT 1
34	0	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=106' 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 = '106' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)
37	0.0001	ControllerProductCategory	SELECT * FROM category_to_layout WHERE category_id = '106' 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 = '106' AND c2s.store_id = '0' LIMIT 1
41	0.007	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 = '106'
42	0.0031	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 = '106' 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 = '8449' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
44	0.0005	ControllerProductCategory	SELECT DISTINCT , pd.name AS name, p.image, p.market_output, m.name AS manufacturer, (SELECT p2.quantity from product p2 where p.id_baza = p2.product_id) as quantity_baza, (SELECT p2.quantity from product p2 where p.id_ramka = p2.product_id) as quantity_ramka, (SELECT 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 = '7370' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
45	0.0004	ControllerProductCategory	SELECT DISTINCT , pd.name AS name, p.image, p.market_output, m.name AS manufacturer, (SELECT p2.quantity from product p2 where p.id_baza = p2.product_id) as quantity_baza, (SELECT p2.quantity from product p2 where p.id_ramka = p2.product_id) as quantity_ramka, (SELECT 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 = '7807' 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 = '16845' 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 = '10470' 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 = '7371' 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 = '7808' 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 = '11662' 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 = '7814' 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 = '11663' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
53	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 = '7809' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
54	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 = '7811' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
55	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 = '7810' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
56	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 = '23475' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
57	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 = '11665' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
58	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 = '17697' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
59	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 = '16828' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
60	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 = '22916' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
61	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 = '16895' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
62	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 = '17389' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
63	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 = '19158' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
64	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 = '23470' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
65	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 = '27301' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
66	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 = '18620' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
67	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 = '17395' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
68	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 = '16918' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
69	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 = '23472' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
70	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 = '27429' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
71	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 = '19160' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
72	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 = '77998' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
73	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 = '19164' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
74	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 = '17887' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
75	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 = '20640' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
76	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 = '19163' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
77	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 = '17552' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
78	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 = '19168' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
79	0.0003	ControllerProductCategory	SELECT * FROM product_image WHERE product_id = '8449' ORDER BY sort_order ASC
80	0.0005	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 = '8449' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
81	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 = '8449' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
82	0.0003	ControllerProductCategory	SELECT category_id FROM product_to_category WHERE product_id = '8449' ORDER BY main_category DESC LIMIT 1
83	0.0002	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=71' LIMIT 1
84	0	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=106' LIMIT 1
85	0.0001	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'product_id=8449' LIMIT 1
86	0.0002	ControllerProductCategory	SELECT * FROM product_image WHERE product_id = '7370' ORDER BY sort_order ASC
87	0.0003	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 = '7370' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
88	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 = '7370' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
89	0.0003	ControllerProductCategory	SELECT category_id FROM product_to_category WHERE product_id = '7370' ORDER BY main_category DESC LIMIT 1
90	0	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=71' LIMIT 1
91	0	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=106' LIMIT 1
92	0.0001	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'product_id=7370' LIMIT 1
93	0.0002	ControllerProductCategory	SELECT * FROM product_image WHERE product_id = '7807' ORDER BY sort_order ASC
94	0.0005	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 = '7807' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
95	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 = '7807' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
96	0.0002	ControllerProductCategory	SELECT category_id FROM product_to_category WHERE product_id = '7807' ORDER BY main_category DESC LIMIT 1
97	0	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=71' LIMIT 1
98	0	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=106' LIMIT 1
99	0.0001	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'product_id=7807' LIMIT 1
100	0.0002	ControllerProductCategory	SELECT * FROM product_image WHERE product_id = '16845' ORDER BY sort_order ASC
101	0.0003	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 = '16845' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
102	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 = '16845' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
103	0.0001	ControllerProductCategory	SELECT category_id FROM product_to_category WHERE product_id = '16845' ORDER BY main_category DESC LIMIT 1
104	0	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=71' LIMIT 1
105	0	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=106' LIMIT 1
106	0.0001	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'product_id=16845' LIMIT 1
107	0.0003	ControllerProductCategory	SELECT * FROM product_image WHERE product_id = '10470' ORDER BY sort_order ASC
108	0.0004	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 = '10470' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.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 = '10470' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
110	0.0002	ControllerProductCategory	SELECT category_id FROM product_to_category WHERE product_id = '10470' ORDER BY main_category DESC LIMIT 1
111	0	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=71' LIMIT 1
112	0	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=106' LIMIT 1
113	0.0001	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'product_id=10470' LIMIT 1
114	0.0001	ControllerProductCategory	SELECT * FROM product_image WHERE product_id = '7371' ORDER BY sort_order ASC
115	0.0002	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 = '7371' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
116	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 = '7371' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
117	0.0001	ControllerProductCategory	SELECT category_id FROM product_to_category WHERE product_id = '7371' ORDER BY main_category DESC LIMIT 1
118	0	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=71' LIMIT 1
119	0	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=106' LIMIT 1
120	0.0001	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'product_id=7371' LIMIT 1
121	0.0001	ControllerProductCategory	SELECT * FROM product_image WHERE product_id = '7808' ORDER BY sort_order ASC
122	0.0002	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 = '7808' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
123	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 = '7808' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
124	0.0001	ControllerProductCategory	SELECT category_id FROM product_to_category WHERE product_id = '7808' ORDER BY main_category DESC LIMIT 1
125	0	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=71' LIMIT 1
126	0	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=106' LIMIT 1
127	0.0001	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'product_id=7808' LIMIT 1
128	0.0001	ControllerProductCategory	SELECT * FROM product_image WHERE product_id = '11662' ORDER BY sort_order ASC
129	0.0004	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 = '11662' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
130	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 = '11662' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
131	0.0001	ControllerProductCategory	SELECT category_id FROM product_to_category WHERE product_id = '11662' ORDER BY main_category DESC LIMIT 1
132	0	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=71' LIMIT 1
133	0	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=106' LIMIT 1
134	0.0002	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'product_id=11662' LIMIT 1
135	0.0001	ControllerProductCategory	SELECT * FROM product_image WHERE product_id = '7814' ORDER BY sort_order ASC
136	0.0002	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 = '7814' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
137	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 = '7814' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
138	0.0001	ControllerProductCategory	SELECT category_id FROM product_to_category WHERE product_id = '7814' ORDER BY main_category DESC LIMIT 1
139	0	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=71' LIMIT 1
140	0	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=106' LIMIT 1
141	0.0001	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'product_id=7814' LIMIT 1
142	0.0001	ControllerProductCategory	SELECT * FROM product_image WHERE product_id = '11663' ORDER BY sort_order ASC
143	0.0002	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 = '11663' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
144	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 = '11663' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
145	0.0001	ControllerProductCategory	SELECT category_id FROM product_to_category WHERE product_id = '11663' ORDER BY main_category DESC LIMIT 1
146	0	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=71' LIMIT 1
147	0	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=106' LIMIT 1
148	0.0001	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'product_id=11663' LIMIT 1
149	0.0001	ControllerProductCategory	SELECT * FROM product_image WHERE product_id = '7809' ORDER BY sort_order ASC
150	0.0002	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 = '7809' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
151	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 = '7809' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
152	0.0001	ControllerProductCategory	SELECT category_id FROM product_to_category WHERE product_id = '7809' ORDER BY main_category DESC LIMIT 1
153	0	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=71' LIMIT 1
154	0	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=106' LIMIT 1
155	0.0001	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'product_id=7809' LIMIT 1
156	0.0001	ControllerProductCategory	SELECT * FROM product_image WHERE product_id = '7811' ORDER BY sort_order ASC
157	0.0002	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 = '7811' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
158	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 = '7811' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
159	0.0001	ControllerProductCategory	SELECT category_id FROM product_to_category WHERE product_id = '7811' ORDER BY main_category DESC LIMIT 1
160	0	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=71' LIMIT 1
161	0	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=106' LIMIT 1
162	0.0001	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'product_id=7811' LIMIT 1
163	0.0001	ControllerProductCategory	SELECT * FROM product_image WHERE product_id = '7810' ORDER BY sort_order ASC
164	0.0002	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 = '7810' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
165	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 = '7810' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
166	0.0001	ControllerProductCategory	SELECT category_id FROM product_to_category WHERE product_id = '7810' ORDER BY main_category DESC LIMIT 1
167	0	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=71' LIMIT 1
168	0	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=106' LIMIT 1
169	0.0001	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'product_id=7810' LIMIT 1
170	0.0002	ControllerProductCategory	SELECT * FROM product_image WHERE product_id = '23475' ORDER BY sort_order ASC
171	0.0003	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 = '23475' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
172	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 = '23475' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
173	0.0001	ControllerProductCategory	SELECT category_id FROM product_to_category WHERE product_id = '23475' ORDER BY main_category DESC LIMIT 1
174	0	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=71' LIMIT 1
175	0	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=106' LIMIT 1
176	0.0001	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'product_id=23475' LIMIT 1
177	0.0001	ControllerProductCategory	SELECT * FROM product_image WHERE product_id = '11665' ORDER BY sort_order ASC
178	0.0002	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 = '11665' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
179	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 = '11665' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
180	0.0001	ControllerProductCategory	SELECT category_id FROM product_to_category WHERE product_id = '11665' ORDER BY main_category DESC LIMIT 1
181	0	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=71' LIMIT 1
182	0	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=106' LIMIT 1
183	0.0001	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'product_id=11665' LIMIT 1
184	0.0002	ControllerProductCategory	SELECT * FROM product_image WHERE product_id = '17697' ORDER BY sort_order ASC
185	0.0003	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 = '17697' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
186	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 = '17697' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
187	0.0001	ControllerProductCategory	SELECT category_id FROM product_to_category WHERE product_id = '17697' ORDER BY main_category DESC LIMIT 1
188	0	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=71' LIMIT 1
189	0	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=106' LIMIT 1
190	0.0001	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'product_id=17697' LIMIT 1
191	0.0001	ControllerProductCategory	SELECT * FROM product_image WHERE product_id = '16828' ORDER BY sort_order ASC
192	0.0004	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 = '16828' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
193	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 = '16828' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
194	0.0001	ControllerProductCategory	SELECT category_id FROM product_to_category WHERE product_id = '16828' ORDER BY main_category DESC LIMIT 1
195	0	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=71' LIMIT 1
196	0	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=106' LIMIT 1
197	0.0001	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'product_id=16828' LIMIT 1
198	0.0002	ControllerProductCategory	SELECT * FROM product_image WHERE product_id = '22916' ORDER BY sort_order ASC
199	0.0004	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 = '22916' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
200	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 = '22916' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
201	0.0001	ControllerProductCategory	SELECT category_id FROM product_to_category WHERE product_id = '22916' ORDER BY main_category DESC LIMIT 1
202	0	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=71' LIMIT 1
203	0	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=106' LIMIT 1
204	0.0001	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'product_id=22916' LIMIT 1
205	0.0002	ControllerProductCategory	SELECT * FROM product_image WHERE product_id = '16895' ORDER BY sort_order ASC
206	0.0004	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 = '16895' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
207	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 = '16895' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
208	0.0001	ControllerProductCategory	SELECT category_id FROM product_to_category WHERE product_id = '16895' ORDER BY main_category DESC LIMIT 1
209	0	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=71' LIMIT 1
210	0	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=106' LIMIT 1
211	0.0001	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'product_id=16895' LIMIT 1
212	0.0002	ControllerProductCategory	SELECT * FROM product_image WHERE product_id = '17389' ORDER BY sort_order ASC
213	0.0004	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 = '17389' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
214	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 = '17389' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
215	0.0002	ControllerProductCategory	SELECT category_id FROM product_to_category WHERE product_id = '17389' ORDER BY main_category DESC LIMIT 1
216	0	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=71' LIMIT 1
217	0	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=106' LIMIT 1
218	0.0001	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'product_id=17389' LIMIT 1
219	0.0004	ControllerProductCategory	SELECT * FROM product_image WHERE product_id = '19158' ORDER BY sort_order ASC
220	0.0003	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 = '19158' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
221	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 = '19158' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
222	0.0001	ControllerProductCategory	SELECT category_id FROM product_to_category WHERE product_id = '19158' ORDER BY main_category DESC LIMIT 1
223	0	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=71' LIMIT 1
224	0	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=106' LIMIT 1
225	0.0002	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'product_id=19158' LIMIT 1
226	0.0001	ControllerProductCategory	SELECT * FROM product_image WHERE product_id = '23470' ORDER BY sort_order ASC
227	0.0002	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 = '23470' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
228	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 = '23470' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
229	0.0001	ControllerProductCategory	SELECT category_id FROM product_to_category WHERE product_id = '23470' ORDER BY main_category DESC LIMIT 1
230	0	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=71' LIMIT 1
231	0	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=106' LIMIT 1
232	0.0002	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'product_id=23470' LIMIT 1
233	0.0003	ControllerProductCategory	SELECT * FROM product_image WHERE product_id = '27301' ORDER BY sort_order ASC
234	0.0003	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 = '27301' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
235	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 = '27301' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
236	0.0002	ControllerProductCategory	SELECT category_id FROM product_to_category WHERE product_id = '27301' ORDER BY main_category DESC LIMIT 1
237	0	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=71' LIMIT 1
238	0	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=106' LIMIT 1
239	0.0001	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'product_id=27301' LIMIT 1
240	0.0001	ControllerProductCategory	SELECT * FROM product_image WHERE product_id = '18620' ORDER BY sort_order ASC
241	0.0003	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 = '18620' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
242	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 = '18620' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
243	0.0002	ControllerProductCategory	SELECT category_id FROM product_to_category WHERE product_id = '18620' ORDER BY main_category DESC LIMIT 1
244	0	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=71' LIMIT 1
245	0	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=106' LIMIT 1
246	0.0001	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'product_id=18620' LIMIT 1
247	0.0001	ControllerProductCategory	SELECT * FROM product_image WHERE product_id = '17395' ORDER BY sort_order ASC
248	0.0002	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 = '17395' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
249	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 = '17395' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
250	0.0001	ControllerProductCategory	SELECT category_id FROM product_to_category WHERE product_id = '17395' ORDER BY main_category DESC LIMIT 1
251	0	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=71' LIMIT 1
252	0	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=106' LIMIT 1
253	0.0001	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'product_id=17395' LIMIT 1
254	0.0002	ControllerProductCategory	SELECT * FROM product_image WHERE product_id = '16918' ORDER BY sort_order ASC
255	0.0004	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 = '16918' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
256	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 = '16918' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
257	0.0001	ControllerProductCategory	SELECT category_id FROM product_to_category WHERE product_id = '16918' ORDER BY main_category DESC LIMIT 1
258	0	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=71' LIMIT 1
259	0	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=106' LIMIT 1
260	0.0001	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'product_id=16918' LIMIT 1
261	0.0001	ControllerProductCategory	SELECT * FROM product_image WHERE product_id = '23472' ORDER BY sort_order ASC
262	0.0002	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 = '23472' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
263	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 = '23472' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
264	0.0001	ControllerProductCategory	SELECT category_id FROM product_to_category WHERE product_id = '23472' ORDER BY main_category DESC LIMIT 1
265	0	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=71' LIMIT 1
266	0	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=106' LIMIT 1
267	0.0001	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'product_id=23472' LIMIT 1
268	0.0001	ControllerProductCategory	SELECT * FROM product_image WHERE product_id = '27429' ORDER BY sort_order ASC
269	0.0003	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 = '27429' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
270	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 = '27429' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
271	0.0001	ControllerProductCategory	SELECT category_id FROM product_to_category WHERE product_id = '27429' ORDER BY main_category DESC LIMIT 1
272	0	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=71' LIMIT 1
273	0	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=106' LIMIT 1
274	0.0001	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'product_id=27429' LIMIT 1
275	0.0003	ControllerProductCategory	SELECT * FROM product_image WHERE product_id = '19160' ORDER BY sort_order ASC
276	0.0002	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 = '19160' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
277	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 = '19160' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
278	0.0001	ControllerProductCategory	SELECT category_id FROM product_to_category WHERE product_id = '19160' ORDER BY main_category DESC LIMIT 1
279	0	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=71' LIMIT 1
280	0	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=106' LIMIT 1
281	0.0001	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'product_id=19160' LIMIT 1
282	0.0001	ControllerProductCategory	SELECT * FROM product_image WHERE product_id = '77998' ORDER BY sort_order ASC
283	0.0003	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 = '77998' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
284	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 = '77998' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
285	0.0001	ControllerProductCategory	SELECT category_id FROM product_to_category WHERE product_id = '77998' ORDER BY main_category DESC LIMIT 1
286	0	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=71' LIMIT 1
287	0	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=106' LIMIT 1
288	0.0001	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'product_id=77998' LIMIT 1
289	0.0001	ControllerProductCategory	SELECT * FROM product_image WHERE product_id = '19164' ORDER BY sort_order ASC
290	0.0002	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 = '19164' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
291	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 = '19164' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
292	0.0001	ControllerProductCategory	SELECT category_id FROM product_to_category WHERE product_id = '19164' ORDER BY main_category DESC LIMIT 1
293	0	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=71' LIMIT 1
294	0	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=106' LIMIT 1
295	0.0001	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'product_id=19164' LIMIT 1
296	0.0003	ControllerProductCategory	SELECT * FROM product_image WHERE product_id = '17887' ORDER BY sort_order ASC
297	0.0004	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 = '17887' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
298	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 = '17887' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
299	0.0001	ControllerProductCategory	SELECT category_id FROM product_to_category WHERE product_id = '17887' ORDER BY main_category DESC LIMIT 1
300	0	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=71' LIMIT 1
301	0	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=106' LIMIT 1
302	0.0001	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'product_id=17887' LIMIT 1
303	0.0004	ControllerProductCategory	SELECT * FROM product_image WHERE product_id = '20640' ORDER BY sort_order ASC
304	0.0004	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 = '20640' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
305	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 = '20640' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
306	0.0002	ControllerProductCategory	SELECT category_id FROM product_to_category WHERE product_id = '20640' ORDER BY main_category DESC LIMIT 1
307	0	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=71' LIMIT 1
308	0	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=106' LIMIT 1
309	0.0001	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'product_id=20640' LIMIT 1
310	0.0001	ControllerProductCategory	SELECT * FROM product_image WHERE product_id = '19163' ORDER BY sort_order ASC
311	0.0002	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 = '19163' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
312	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 = '19163' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
313	0.0001	ControllerProductCategory	SELECT category_id FROM product_to_category WHERE product_id = '19163' ORDER BY main_category DESC LIMIT 1
314	0	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=71' LIMIT 1
315	0	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=106' LIMIT 1
316	0.0002	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'product_id=19163' LIMIT 1
317	0.0002	ControllerProductCategory	SELECT * FROM product_image WHERE product_id = '17552' ORDER BY sort_order ASC
318	0.0004	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 = '17552' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
319	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 = '17552' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
320	0.0001	ControllerProductCategory	SELECT category_id FROM product_to_category WHERE product_id = '17552' ORDER BY main_category DESC LIMIT 1
321	0	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=71' LIMIT 1
322	0	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=106' LIMIT 1
323	0.0001	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'product_id=17552' LIMIT 1
324	0.0003	ControllerProductCategory	SELECT * FROM product_image WHERE product_id = '19168' ORDER BY sort_order ASC
325	0.0002	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 = '19168' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
326	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 = '19168' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
327	0.0001	ControllerProductCategory	SELECT category_id FROM product_to_category WHERE product_id = '19168' ORDER BY main_category DESC LIMIT 1
328	0	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=71' LIMIT 1
329	0	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=106' LIMIT 1
330	0.0001	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'product_id=19168' LIMIT 1
331	0	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=71' LIMIT 1
332	0	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=106' LIMIT 1
333	0	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=71' LIMIT 1
334	0	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=106' LIMIT 1
335	0	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=71' LIMIT 1
336	0	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=106' LIMIT 1
337	0	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=71' LIMIT 1
338	0	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=106' LIMIT 1
339	0	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=71' LIMIT 1
340	0	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=106' LIMIT 1
341	0	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=71' LIMIT 1
342	0	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=106' LIMIT 1
343	0	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=71' LIMIT 1
344	0	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=106' LIMIT 1
345	0	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=71' LIMIT 1
346	0	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=106' LIMIT 1
347	0	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=71' LIMIT 1
348	0	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=106' LIMIT 1
349	0	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=71' LIMIT 1
350	0	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=106' LIMIT 1
351	0	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=71' LIMIT 1
352	0	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=106' LIMIT 1
353	0	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=71' LIMIT 1
354	0	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=106' LIMIT 1
355	0	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=71' LIMIT 1
356	0	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=106' LIMIT 1
357	0	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=71' LIMIT 1
358	0	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=106' LIMIT 1
359	0	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=71' LIMIT 1
360	0	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=106' LIMIT 1
361	0	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=71' LIMIT 1
362	0	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=106' LIMIT 1
363	0	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=71' LIMIT 1
364	0	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=106' LIMIT 1
365	0	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=71' LIMIT 1
366	0	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=106' LIMIT 1
367	0	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=71' LIMIT 1
368	0	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=106' LIMIT 1
369	0	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=71' LIMIT 1
370	0	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=106' LIMIT 1
371	0	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=71' LIMIT 1
372	0	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=106' LIMIT 1
373	0	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=71' LIMIT 1
374	0	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=106' LIMIT 1
375	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 = '106' AND c2s.store_id = '0' LIMIT 1
376	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 = '106' AND p.category = '1' ORDER BY p.page_id DESC
377	0	ControllerEventCompatibility	SELECT * FROM ocfilter_setting WHERE `key` = 'placement_layout'
378	0.0001	ControllerEventCompatibility	SELECT `value` FROM ocfilter_cache WHERE `key` = '1456609850'
379	0	ControllerEventCompatibility	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'common/home' LIMIT 1
380	0	ControllerCommonColumnLeft	SELECT * FROM category_to_layout WHERE category_id = '106' AND store_id = '0'
381	0	ControllerCommonColumnLeft	SELECT * FROM layout_route WHERE 'product/category' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1
382	0	ControllerCommonColumnLeft	SELECT * FROM layout_module WHERE layout_id = '3' AND position = 'column_left' ORDER BY sort_order
383	0	ControllerEventCompatibility	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=71' LIMIT 1
384	0	ControllerEventCompatibility	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=106' LIMIT 1
385	0.0003	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 = '106' OR f2c.category_id = '0') GROUP BY f.filter_id, f.source
386	0.0001	ControllerEventCompatibility	SELECT `value` FROM ocfilter_cache WHERE `key` = '799108249'
387	0.0001	ControllerEventCompatibility	SELECT `value` FROM ocfilter_cache WHERE `key` = '3463394037'
388	0.0001	ControllerEventCompatibility	SELECT `value` FROM ocfilter_cache WHERE `key` = '1388308038'
389	0.0001	ControllerEventCompatibility	SELECT `value` FROM ocfilter_cache WHERE `key` = '1830280939'
390	0.0001	ControllerEventCompatibility	SELECT `value` FROM ocfilter_cache WHERE `key` = '1751832306'
391	0.0001	ControllerEventCompatibility	SELECT `value` FROM ocfilter_cache WHERE `key` = '3375549275'
392	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 = '106' AND p.module = '1' ORDER BY p.page_id DESC
393	0	ControllerCommonColumnRight	SELECT * FROM category_to_layout WHERE category_id = '106' AND store_id = '0'
394	0	ControllerCommonColumnRight	SELECT * FROM layout_route WHERE 'product/category' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1
395	0	ControllerCommonColumnRight	SELECT * FROM layout_module WHERE layout_id = '3' AND position = 'column_right' ORDER BY sort_order
396	0	ControllerCommonContentTop	SELECT * FROM category_to_layout WHERE category_id = '106' AND store_id = '0'
397	0	ControllerCommonContentTop	SELECT * FROM layout_route WHERE 'product/category' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1
398	0	ControllerCommonContentTop	SELECT * FROM layout_module WHERE layout_id = '3' AND position = 'content_top' ORDER BY sort_order
399	0	ControllerCommonContentBottom	SELECT * FROM category_to_layout WHERE category_id = '106' AND store_id = '0'
400	0	ControllerCommonContentBottom	SELECT * FROM layout_route WHERE 'product/category' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1
401	0	ControllerCommonContentBottom	SELECT * FROM layout_module WHERE layout_id = '3' AND position = 'content_bottom' ORDER BY sort_order
402	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
403	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
404	0	ControllerRevolutionRevsubscribe	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'information_id=22' LIMIT 1
405	0	ControllerRevolutionRevsubscribe	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'information_id=21' LIMIT 1
406	0	ControllerRevolutionRevsubscribe	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'information_id=14' LIMIT 1
407	0	ControllerRevolutionRevsubscribe	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'information_id=8' LIMIT 1
408	0	ControllerRevolutionRevsubscribe	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'information_id=6' LIMIT 1
409	0	ControllerRevolutionRevsubscribe	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'information_id=9' LIMIT 1
410	0	ControllerRevolutionRevsubscribe	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'information/contact' LIMIT 1
411	0	ControllerRevolutionRevsubscribe	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'account/return/add' LIMIT 1
412	0	ControllerRevolutionRevsubscribe	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'information/sitemap' LIMIT 1
413	0	ControllerRevolutionRevsubscribe	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'product/manufacturer' LIMIT 1
414	0	ControllerRevolutionRevsubscribe	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'account/voucher' LIMIT 1
415	0	ControllerRevolutionRevsubscribe	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'affiliate/account' LIMIT 1
416	0	ControllerRevolutionRevsubscribe	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'product/special' LIMIT 1
417	0	ControllerRevolutionRevsubscribe	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'revolution/account/revaccount' LIMIT 1
418	0	ControllerRevolutionRevsubscribe	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'account/order' LIMIT 1
419	0	ControllerRevolutionRevsubscribe	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'account/wishlist' LIMIT 1
420	0	ControllerRevolutionRevsubscribe	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'account/newsletter' LIMIT 1
421	0	ControllerCommonHeader	SELECT * FROM extension WHERE `type` = 'analytics'
422	0.0001	ControllerCommonCartMobi	SELECT SUM(quantity) as total FROM cart WHERE api_id = '0' AND session_id = 'd4qj6il8pcq192v6o6jjlu6ro3'
423	0	ControllerCommonCartMobi	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'checkout/simplecheckout' LIMIT 1
424	0	ControllerCommonCartMobi	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'checkout/simplecheckout' LIMIT 1
425	0	ControllerExtensionModuleOCFilter	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'product/compare' LIMIT 1
426	0	ControllerExtensionModuleOCFilter	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'revolution/account/revaccount' LIMIT 1
427	0	ControllerExtensionModuleOCFilter	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'account/logout' LIMIT 1
428	0	ControllerExtensionModuleOCFilter	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'common/home' LIMIT 1
429	0	ControllerExtensionModuleOCFilter	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'account/wishlist' LIMIT 1
430	0	ControllerExtensionModuleOCFilter	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'revolution/account/revaccount' LIMIT 1
431	0	ControllerExtensionModuleOCFilter	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'account/simpleregister' LIMIT 1
432	0	ControllerExtensionModuleOCFilter	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'account/login' LIMIT 1
433	0	ControllerExtensionModuleOCFilter	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'account/order' LIMIT 1
434	0	ControllerExtensionModuleOCFilter	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'account/transaction' LIMIT 1
435	0	ControllerExtensionModuleOCFilter	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'account/download' LIMIT 1
436	0	ControllerExtensionModuleOCFilter	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'account/logout' LIMIT 1
437	0	ControllerExtensionModuleOCFilter	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'checkout/simplecheckout' LIMIT 1
438	0	ControllerExtensionModuleOCFilter	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'checkout/simplecheckout' LIMIT 1
439	0	ControllerExtensionModuleOCFilter	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'information/contact' LIMIT 1
440	0	ControllerCommonLanguage	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'common/language/language' LIMIT 1
441	0	ControllerCommonLanguage	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=71' LIMIT 1
442	0	ControllerCommonLanguage	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=106' LIMIT 1
443	0	ControllerCommonCurrency	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'common/currency/currency' LIMIT 1
444	0	ControllerCommonCurrency	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=71' LIMIT 1
445	0	ControllerCommonCurrency	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=106' LIMIT 1
446	0.0001	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)
447	0.0001	ControllerCommonCart	SELECT * FROM cart WHERE api_id = '0' AND session_id = 'd4qj6il8pcq192v6o6jjlu6ro3'
448	0	ControllerCommonCart	SELECT * FROM extension WHERE `type` = 'total'
449	0	ControllerEventCompatibility	SELECT * FROM cart WHERE api_id = '0' AND session_id = 'd4qj6il8pcq192v6o6jjlu6ro3'
450	0	ControllerEventCompatibility	SELECT SUM(quantity) as total FROM cart WHERE api_id = '0' AND session_id = 'd4qj6il8pcq192v6o6jjlu6ro3'
451	0	ControllerEventCompatibility	SELECT * FROM cart WHERE api_id = '0' AND session_id = 'd4qj6il8pcq192v6o6jjlu6ro3'
452	0	ControllerEventCompatibility	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'checkout/simplecheckout' LIMIT 1
453	0	ControllerEventCompatibility	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'checkout/simplecheckout' LIMIT 1
454	0	ControllerExtensionModuleOCFilter	SELECT SUM(quantity) as total FROM cart WHERE api_id = '0' AND session_id = 'd4qj6il8pcq192v6o6jjlu6ro3'

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

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

Отмена

ISO-переходники