Рамки под планшеты 9/10 дюймов

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

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

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

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

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

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

Наши обзоры:

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

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

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

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

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

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

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

Камеры для коммерческого транспорта

Круговой обзор

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

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

Переходные рамки

Автозвук

Аксессуары

Услуги

8 (800) 700-26-44

Сортировка:

Показать:

Фильтр

В закладки

В сравнение

Рамка RM-9-1230 под магнитолу 9 дюймов для Lada Niva 2123, Niva Travel (2021-2024) / Chevrolet Niva (2002-2020)

Артикул: 234722

Рамка RM-9-1230 под магнитолу 9 дюймов для Lada Niva 2123, Niva Travel (2021-2024) / Chevrolet Niva (2002-2020)
В наличии Москва - Ташкентская 28с1
В наличии Питер - Придорожная аллея 8

17 000 р.

В закладки

В сравнение

Рамка RM-9-9820 под магнитолу 9 дюймов для Lada Vesta (NG) (2022-2024) (черная, матовая)

Артикул: 197581

Рамка RM-9-9820 под магнитолу 9 дюймов для Lada Vesta (NG) (2022-2024) (черная, матовая)
В наличии Москва - Ташкентская 28с1
В наличии Питер - Придорожная аллея 8

2 100 р.

В закладки

В сравнение

Рамка RM-9-1680 под магнитолу 9 дюймов для Geely MK (2006-2013)

Артикул: 117019

Рамка RM-9-1680 под магнитолу 9 дюймов для Geely MK (2006-2013)
В наличии Москва - 1 шт. Ташкентская 28с1
В наличии Питер - 1 шт. Придорожная аллея 8

5 680 р.

В закладки

В сравнение

Рамка RM-10-1210 под магнитолу 10 дюймов для Nissan Almera (N16), Sentra 5 (B15) (1999-2006)

Артикул: 102492

Рамка RM-10-1210 под магнитолу 10 дюймов для Nissan Almera (N16), Sentra 5 (B15) (1999-2006)
В наличии Москва - Ташкентская 28с1

4 160 р.

В закладки

В сравнение

Рамка RM-10-1200 переходная с 10 дюймов на 9 дюймов (проставка)

Артикул: 117617

Рамка RM-10-1200 переходная с 10 дюймов на 9 дюймов (проставка)
В наличии Москва - Ташкентская 28с1
В наличии Питер - Придорожная аллея 8

2 480 р.

В закладки

В сравнение

Рамка RM-1081 под магнитолу 10 дюймов для Chevrolet Lacetti (2004-2013) (тип 1, серая)

Артикул: 36476

Рамка RM-1081 под магнитолу 10 дюймов для Chevrolet Lacetti (2004-2013) (тип 1, серая)
В наличии Москва - Ташкентская 28с1
В наличии Питер - 1 шт. Придорожная аллея 8

3 660 р.

В закладки

В сравнение

Рамка RM-10-2562 под магнитолу 10 дюймов для Mitsubishi Delica D:5 (2018-2024)

Артикул: 151350

Рамка RM-10-2562 под магнитолу 10 дюймов для Mitsubishi Delica D:5 (2018-2024)
В наличии Москва - Ташкентская 28с1
В наличии Питер - Придорожная аллея 8

4 560 р.

В закладки

В сравнение

Рамка RM-9-0138 под магнитолу 9 дюймов для Toyota Land Cruiser Prado 150 (2009-2013) (глянцевая, для макс. комплектации)

Артикул: 196992

Рамка RM-9-0138 под магнитолу 9 дюймов для Toyota Land Cruiser Prado 150 (2009-2013) (глянцевая, для макс. комплектации)
В наличии Москва - Ташкентская 28с1
В наличии Питер - 1 шт. Придорожная аллея 8

21 294 р.

В закладки

В сравнение

Рамка RM-9-442 под магнитолу 9 дюймов для Mazda 323 6 (BJ), Premacy (CP), Protege 3 (BJ) (1998-2004)

Артикул: 35219

Рамка RM-9-442 под магнитолу 9 дюймов для Mazda 323 6 (BJ), Premacy (CP), Protege 3 (BJ) (1998-2004)
В наличии Москва - Ташкентская 28с1
В наличии Питер - 1 шт. Придорожная аллея 8

4 320 р.

В закладки

В сравнение

Рамка RM-9-1424 под магнитолу 9 дюймов для Nissan Navara 3 (D40), Pathfinder 3 (2004-2014) (для авто с навигацией)

Артикул: 156228

Рамка RM-9-1424 под магнитолу 9 дюймов для Nissan Navara 3 (D40), Pathfinder 3 (2004-2014) (для авто с навигацией)
В наличии Москва - Ташкентская 28с1
В наличии Питер - 1 шт. Придорожная аллея 8

5.0

отзыв

15 200 р.

В закладки

В сравнение

Рамка RM-10-1368 под магнитолу 10 дюймов для Mercedes S-klasse (w140) (1991-1998)

Артикул: 127925

Рамка RM-10-1368 под магнитолу 10 дюймов для Mercedes S-klasse (w140) (1991-1998)
В наличии Москва - 1 шт. Ташкентская 28с1

7 054 р.

В закладки

В сравнение

Рамка RM-10-1864 под магнитолу 10 дюймов для Changan CS75 (2014-2020)

Артикул: 195555

Рамка RM-10-1864 под магнитолу 10 дюймов для Changan CS75 (2014-2020)

4 050 р.

В закладки

В сравнение

Рамка RM-10-1280 переходная универсальная с 173*98 / 178*102 под магнитолу 10 дюймов

Артикул: 117614

Рамка RM-10-1280 переходная универсальная с 17398 / 178102 под магнитолу 10 дюймов
В наличии Москва - Ташкентская 28с1
В наличии Питер - Придорожная аллея 8

2 560 р.

В закладки

В сравнение

Рамка RM-9-1862 под магнитолу 9 дюймов для GAZ Газел Бизнес (Gazele Business) (серебристая)

Артикул: 119419

Рамка RM-9-1862 под магнитолу 9 дюймов для GAZ Газел Бизнес (Gazele Business) (серебристая)
В наличии Москва - Ташкентская 28с1

2 684 р.

В закладки

В сравнение

Рамка RM-9-1684 под магнитолу 9 дюймов для Chery Fora (A21) (2006-2011)

Артикул: 117629

Рамка RM-9-1684 под магнитолу 9 дюймов для Chery Fora (A21) (2006-2011)
В наличии Москва - Ташкентская 28с1

3 898 р.

В закладки

В сравнение

Рамка RM-10-0184 под магнитолу 10 дюймов для Ford Explorer 4 (2005-2010)

Артикул: 203325

Рамка RM-10-0184 под магнитолу 10 дюймов для Ford Explorer 4 (2005-2010)

4 720 р.

В закладки

В сравнение

Артикул: 221147

Клипса для установки переходной рамки

187 р.

В закладки

В сравнение

Рамка RM-9-1395 под магнитолу 9 дюймов для Lada Priora (2013-2018) (глянцевая)

Артикул: 147283

Рамка RM-9-1395 под магнитолу 9 дюймов для Lada Priora (2013-2018) (глянцевая)
В наличии Москва - Ташкентская 28с1

3 756 р.

Показать 18 36 60 100

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

Купить магнитолу можно:

На сайте — наши опытные специалисты помогут Вам сделать выбор и предложат наиболее подходящие модели для Вашего автомобиля.
В нашем офлайн магазине. Возможность протестировать магнитолу на демо-стенде: отличный вариант для клиентов, которые хотят непосредственно поработать с магнитолой перед покупкой.
В установочном центре, оплата после принятия работы.
По Москве и Московской области — наш курьер оперативно доставит и примет оплату.
С доставкой по всей России — оплата за магнитолу при получении (после проверки содержимого).

Почему Frontcam:

Работаем более 10 лет (с 2012 года).
Основное направление компании — продажа, установка и дальнейшее обслуживание штатных магнитол на платформе Android.
У нас самый большой ассортимент штатных магнитол.
Есть собственная служба технической поддержки, благодаря которой помогаем клиентам после покупки.
Имея большой опыт, мы любим находить решения, даже для нестандартных автомобилей и сложных комплектаций.

Надежность

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

Большой опыт

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

Оплата потом

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

Установка

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

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

Created by frontcam.ru

Total time: 0.1719 s | Queries: 310 | Slow queries (>0.003 s): 7

#	Query time (s)	Controller	Query
1	0.0002		SELECT value FROM setting WHERE store_id = '0' AND `key`='config_seo_url_type'
2	0.0001		SET SQL_BIG_SELECTS = 1
3	0.0004		SHOW TABLES LIKE 'ocfilter_setting'
4	0.0002		SELECT * FROM ocfilter_setting
5	0.0001		DELETE FROM ocfilter_cache WHERE `expire` < '1713279675'
6	0.0001	ControllerStartupStartup	SELECT * FROM store WHERE REPLACE(`ssl`, 'www.', '') = 'https://frontcam.ru/'
7	0.0004	ControllerEventCompatibility	SELECT f1.offname f1_name, f1.offname_gc f1_name_gc, f1.offname_pc f1_name_pc, f1.shortname f1_shortname, f1.fias_id f1_fias_id, f1.level f1_level, f1.postalcode f1_postalcode, f2.offname f2_name, f2.offname_gc f2_name_gc, f2.offname_pc f2_name_pc, f2.shortname f2_shortname, f2.fias_id f2_fias_id, f2.level f2_level, f3.offname f3_name, f3.offname_gc f3_name_gc, f3.offname_pc f3_name_pc, f3.shortname f3_shortname, f3.fias_id f3_fias_id, f3.level f3_level, f4.offname f4_name, f4.offname_gc f4_name_gc, f4.offname_pc f4_name_pc, f4.shortname f4_shortname, f4.fias_id f4_fias_id, f4.level f4_level, f4.parent_id f4_parent_id FROM fias f1 LEFT JOIN fias f2 ON f2.fias_id = f1.parent_id LEFT JOIN fias f3 ON f3.fias_id = f2.parent_id LEFT JOIN fias f4 ON f4.fias_id = f3.parent_id WHERE f1.offname = 'Сиэтл' AND ((f2.offname = 'США' AND f2.level = 0) OR (f3.offname = 'США' AND f3.level = 0) OR (f4.offname = 'США' AND f4.level = 0)) AND ((f1.offname = 'Вашингтон' AND f1.level = 1) OR (f2.offname = 'Вашингтон' AND f2.level = 1) OR (f3.offname = 'Вашингтон' AND f3.level = 1) OR (f4.offname = 'Вашингтон' AND f4.level = 1)) AND f1.level IN (1, 4, 6) ORDER BY f1_level
8	0.0003	ControllerEventCompatibility	SELECT f1.offname f1_name, f1.offname_gc f1_name_gc, f1.offname_pc f1_name_pc, f1.shortname f1_shortname, f1.fias_id f1_fias_id, f1.level f1_level, f1.postalcode f1_postalcode, f2.offname f2_name, f2.offname_gc f2_name_gc, f2.offname_pc f2_name_pc, f2.shortname f2_shortname, f2.fias_id f2_fias_id, f2.level f2_level, f3.offname f3_name, f3.offname_gc f3_name_gc, f3.offname_pc f3_name_pc, f3.shortname f3_shortname, f3.fias_id f3_fias_id, f3.level f3_level, f4.offname f4_name, f4.offname_gc f4_name_gc, f4.offname_pc f4_name_pc, f4.shortname f4_shortname, f4.fias_id f4_fias_id, f4.level f4_level, f4.parent_id f4_parent_id FROM fias f1 LEFT JOIN fias f2 ON f2.fias_id = f1.parent_id LEFT JOIN fias f3 ON f3.fias_id = f2.parent_id LEFT JOIN fias f4 ON f4.fias_id = f3.parent_id WHERE f1.offname = 'Сиэтл' AND ((f2.offname = 'США' AND f2.level = 0) OR (f3.offname = 'США' AND f3.level = 0) OR (f4.offname = 'США' AND f4.level = 0)) AND f1.level IN (1, 4, 6) ORDER BY f1_level
9	0.0001	ControllerEventCompatibility	SELECT * FROM country c WHERE c.iso_code_2 = 'US'
10	0.0001	ControllerEventCompatibility	SELECT * FROM prmn_cm_redirect
11	0.0002	ControllerEventCompatibility	SELECT f1.offname f1_name, f1.offname_gc f1_name_gc, f1.offname_pc f1_name_pc, f1.shortname f1_shortname, f1.fias_id f1_fias_id, f1.level f1_level, f1.postalcode f1_postalcode, f2.offname f2_name, f2.offname_gc f2_name_gc, f2.offname_pc f2_name_pc, f2.shortname f2_shortname, f2.fias_id f2_fias_id, f2.level f2_level, f3.offname f3_name, f3.offname_gc f3_name_gc, f3.offname_pc f3_name_pc, f3.shortname f3_shortname, f3.fias_id f3_fias_id, f3.level f3_level, f4.offname f4_name, f4.offname_gc f4_name_gc, f4.offname_pc f4_name_pc, f4.shortname f4_shortname, f4.fias_id f4_fias_id, f4.level f4_level, f4.parent_id f4_parent_id FROM fias f1 LEFT JOIN fias f2 ON f2.fias_id = f1.parent_id LEFT JOIN fias f3 ON f3.fias_id = f2.parent_id LEFT JOIN fias f4 ON f4.fias_id = f3.parent_id WHERE f1.fias_id = 41
12	0.0001	ControllerEventCompatibility	SELECT * FROM prmn_cm_customer_group WHERE fias_id IN (41,41,1)
13	0.0001	ControllerEventCompatibility	SELECT * FROM currency
14	0.0002	ControllerEventCompatibility	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'
15	0.0002	ControllerEventCompatibility	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'
16	0.0001	ControllerEventCompatibility	DELETE FROM cart WHERE date_added < DATE_SUB(NOW(), INTERVAL '30' DAY)
17	0.0003	ControllerEventCompatibility	SHOW TABLES LIKE 'cartkeeper'
18	0.0002	ControllerEventCompatibility	SHOW TABLES LIKE 'cartkeeper_share'
19	0.0001	ControllerEventCompatibility	DELETE FROM cartkeeper WHERE date_added < DATE_SUB(NOW(), INTERVAL '30' DAY)
20	0.0001	ControllerEventCompatibility	DELETE FROM cartkeeper_share WHERE customer_id = '0' AND date_added < DATE_SUB(NOW(), INTERVAL '3' DAY)
21	0.0001	ControllerEventCompatibility	DELETE FROM cartkeeper_share WHERE customer_id != '0' AND date_added < DATE_SUB(NOW(), INTERVAL '14' DAY)
22	0.0001	ControllerEventCompatibility	SELECT `session_id` FROM `cart` WHERE `session_id` = 'cfc7a1ff4d683bda1b3e92036047de72' LIMIT 1
23	0.0001	ControllerStartupEvent	SELECT * FROM `event` WHERE `trigger` LIKE 'catalog/%' AND status = '1' ORDER BY `event_id` ASC
24	0.0001	ControllerEventCompatibility	SELECT c.* FROM prmn_cm_city c ORDER BY sort, name
25	0.0001	ControllerStartupSeoPro	SELECT query FROM url_alias WHERE keyword = 'perehodnye-ramki' LIMIT 1
26	0.0001	ControllerStartupSeoPro	SELECT query FROM url_alias WHERE keyword = 'ramki-pod-planshety-9-10-djujomv' LIMIT 1
27	0.0001	ControllerStartupSeoPro	SELECT query FROM url_alias WHERE keyword = 'perehodnye-ramki/ramki-pod-planshety-9-10-djujomv/' LIMIT 1
28	0.0001	ControllerStartupSeoPro	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=94' LIMIT 1
29	0.0001	ControllerStartupSeoPro	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=1543' LIMIT 1
30	0.0001	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'common/home' LIMIT 1
31	0.0002	ControllerProductCategory	SELECT DISTINCT * FROM category c LEFT JOIN category_description cd ON (c.category_id = cd.category_id) WHERE c.category_id = '94' AND cd.language_id = '1' AND c.status = '1'
32	0.0001	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=94' LIMIT 1
33	0.0001	ControllerProductCategory	SELECT DISTINCT * FROM category c LEFT JOIN category_description cd ON (c.category_id = cd.category_id) WHERE c.category_id = '1543' AND cd.language_id = '1' AND c.status = '1'
34	0.0001	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=94' LIMIT 1
35	0.0001	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=1543' LIMIT 1
36	0.0001	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'product/compare' LIMIT 1
37	0.0004	ControllerProductCategory	SELECT * FROM category c LEFT JOIN category_description cd ON (c.category_id = cd.category_id) WHERE c.parent_id = '1543' AND cd.language_id = '1' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)
38	0.0001	ControllerProductCategory	SELECT * FROM category_to_layout WHERE category_id = '1543'
39	0.0001	ControllerProductCategory	SELECT * FROM layout_route WHERE 'product/category' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1
40	0.0001	ControllerProductCategory	SELECT * FROM layout_module WHERE layout_id = '3' AND `code` = 'ocfilter'
41	0.0001	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 = '1543' AND c2s.store_id = '0' LIMIT 1
42	0.0026	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) WHERE p.status = '1' AND p.catalog_output = '1' AND p2c.category_id = '1543'
43	0.0068	ControllerProductCategory	SELECT p.product_id, (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) WHERE p.status = '1' AND p.catalog_output = '1' AND p2c.category_id = '1543' GROUP BY p.product_id ORDER BY p.viewed DESC LIMIT 0,18
44	0.0006	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 pnl.quantity from product_new_location pnl where p.product_id = pnl.product_id and pnl.location_id = '1') as spb_quantity, (SELECT pnl.quantity from product_new_location pnl where p.id_baza = pnl.product_id and pnl.location_id = '1') as spb_quantity_baza, (SELECT pnl.quantity from product_new_location pnl where p.id_ramka = pnl.product_id and pnl.location_id = '1') as spb_quantity_ramka, (SELECT pa.text from product_attribute pa where p.product_id = pa.product_id and pa.attribute_id = '66') as processor, (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 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, p.sort_order FROM product p LEFT JOIN product_description pd ON (p.product_id = pd.product_id) LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '209639' AND p.status = '1'
45	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 pnl.quantity from product_new_location pnl where p.product_id = pnl.product_id and pnl.location_id = '1') as spb_quantity, (SELECT pnl.quantity from product_new_location pnl where p.id_baza = pnl.product_id and pnl.location_id = '1') as spb_quantity_baza, (SELECT pnl.quantity from product_new_location pnl where p.id_ramka = pnl.product_id and pnl.location_id = '1') as spb_quantity_ramka, (SELECT pa.text from product_attribute pa where p.product_id = pa.product_id and pa.attribute_id = '66') as processor, (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 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, p.sort_order FROM product p LEFT JOIN product_description pd ON (p.product_id = pd.product_id) LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '172353' AND p.status = '1'
46	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 pnl.quantity from product_new_location pnl where p.product_id = pnl.product_id and pnl.location_id = '1') as spb_quantity, (SELECT pnl.quantity from product_new_location pnl where p.id_baza = pnl.product_id and pnl.location_id = '1') as spb_quantity_baza, (SELECT pnl.quantity from product_new_location pnl where p.id_ramka = pnl.product_id and pnl.location_id = '1') as spb_quantity_ramka, (SELECT pa.text from product_attribute pa where p.product_id = pa.product_id and pa.attribute_id = '66') as processor, (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 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, p.sort_order FROM product p LEFT JOIN product_description pd ON (p.product_id = pd.product_id) LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '90311' AND p.status = '1'
47	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 pnl.quantity from product_new_location pnl where p.product_id = pnl.product_id and pnl.location_id = '1') as spb_quantity, (SELECT pnl.quantity from product_new_location pnl where p.id_baza = pnl.product_id and pnl.location_id = '1') as spb_quantity_baza, (SELECT pnl.quantity from product_new_location pnl where p.id_ramka = pnl.product_id and pnl.location_id = '1') as spb_quantity_ramka, (SELECT pa.text from product_attribute pa where p.product_id = pa.product_id and pa.attribute_id = '66') as processor, (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 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, p.sort_order FROM product p LEFT JOIN product_description pd ON (p.product_id = pd.product_id) LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '75724' AND p.status = '1'
48	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 pnl.quantity from product_new_location pnl where p.product_id = pnl.product_id and pnl.location_id = '1') as spb_quantity, (SELECT pnl.quantity from product_new_location pnl where p.id_baza = pnl.product_id and pnl.location_id = '1') as spb_quantity_baza, (SELECT pnl.quantity from product_new_location pnl where p.id_ramka = pnl.product_id and pnl.location_id = '1') as spb_quantity_ramka, (SELECT pa.text from product_attribute pa where p.product_id = pa.product_id and pa.attribute_id = '66') as processor, (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 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, p.sort_order FROM product p LEFT JOIN product_description pd ON (p.product_id = pd.product_id) LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '90910' AND p.status = '1'
49	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 pnl.quantity from product_new_location pnl where p.product_id = pnl.product_id and pnl.location_id = '1') as spb_quantity, (SELECT pnl.quantity from product_new_location pnl where p.id_baza = pnl.product_id and pnl.location_id = '1') as spb_quantity_baza, (SELECT pnl.quantity from product_new_location pnl where p.id_ramka = pnl.product_id and pnl.location_id = '1') as spb_quantity_ramka, (SELECT pa.text from product_attribute pa where p.product_id = pa.product_id and pa.attribute_id = '66') as processor, (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 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, p.sort_order FROM product p LEFT JOIN product_description pd ON (p.product_id = pd.product_id) LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '46545' AND p.status = '1'
50	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 pnl.quantity from product_new_location pnl where p.product_id = pnl.product_id and pnl.location_id = '1') as spb_quantity, (SELECT pnl.quantity from product_new_location pnl where p.id_baza = pnl.product_id and pnl.location_id = '1') as spb_quantity_baza, (SELECT pnl.quantity from product_new_location pnl where p.id_ramka = pnl.product_id and pnl.location_id = '1') as spb_quantity_ramka, (SELECT pa.text from product_attribute pa where p.product_id = pa.product_id and pa.attribute_id = '66') as processor, (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 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, p.sort_order FROM product p LEFT JOIN product_description pd ON (p.product_id = pd.product_id) LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '125599' AND p.status = '1'
51	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 pnl.quantity from product_new_location pnl where p.product_id = pnl.product_id and pnl.location_id = '1') as spb_quantity, (SELECT pnl.quantity from product_new_location pnl where p.id_baza = pnl.product_id and pnl.location_id = '1') as spb_quantity_baza, (SELECT pnl.quantity from product_new_location pnl where p.id_ramka = pnl.product_id and pnl.location_id = '1') as spb_quantity_ramka, (SELECT pa.text from product_attribute pa where p.product_id = pa.product_id and pa.attribute_id = '66') as processor, (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 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, p.sort_order FROM product p LEFT JOIN product_description pd ON (p.product_id = pd.product_id) LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '171751' AND p.status = '1'
52	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 pnl.quantity from product_new_location pnl where p.product_id = pnl.product_id and pnl.location_id = '1') as spb_quantity, (SELECT pnl.quantity from product_new_location pnl where p.id_baza = pnl.product_id and pnl.location_id = '1') as spb_quantity_baza, (SELECT pnl.quantity from product_new_location pnl where p.id_ramka = pnl.product_id and pnl.location_id = '1') as spb_quantity_ramka, (SELECT pa.text from product_attribute pa where p.product_id = pa.product_id and pa.attribute_id = '66') as processor, (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 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, p.sort_order FROM product p LEFT JOIN product_description pd ON (p.product_id = pd.product_id) LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '47793' AND p.status = '1'
53	0.0006	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 pnl.quantity from product_new_location pnl where p.product_id = pnl.product_id and pnl.location_id = '1') as spb_quantity, (SELECT pnl.quantity from product_new_location pnl where p.id_baza = pnl.product_id and pnl.location_id = '1') as spb_quantity_baza, (SELECT pnl.quantity from product_new_location pnl where p.id_ramka = pnl.product_id and pnl.location_id = '1') as spb_quantity_ramka, (SELECT pa.text from product_attribute pa where p.product_id = pa.product_id and pa.attribute_id = '66') as processor, (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 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, p.sort_order FROM product p LEFT JOIN product_description pd ON (p.product_id = pd.product_id) LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '130542' AND p.status = '1'
54	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 pnl.quantity from product_new_location pnl where p.product_id = pnl.product_id and pnl.location_id = '1') as spb_quantity, (SELECT pnl.quantity from product_new_location pnl where p.id_baza = pnl.product_id and pnl.location_id = '1') as spb_quantity_baza, (SELECT pnl.quantity from product_new_location pnl where p.id_ramka = pnl.product_id and pnl.location_id = '1') as spb_quantity_ramka, (SELECT pa.text from product_attribute pa where p.product_id = pa.product_id and pa.attribute_id = '66') as processor, (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 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, p.sort_order FROM product p LEFT JOIN product_description pd ON (p.product_id = pd.product_id) LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '101264' AND p.status = '1'
55	0.0006	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 pnl.quantity from product_new_location pnl where p.product_id = pnl.product_id and pnl.location_id = '1') as spb_quantity, (SELECT pnl.quantity from product_new_location pnl where p.id_baza = pnl.product_id and pnl.location_id = '1') as spb_quantity_baza, (SELECT pnl.quantity from product_new_location pnl where p.id_ramka = pnl.product_id and pnl.location_id = '1') as spb_quantity_ramka, (SELECT pa.text from product_attribute pa where p.product_id = pa.product_id and pa.attribute_id = '66') as processor, (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 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, p.sort_order FROM product p LEFT JOIN product_description pd ON (p.product_id = pd.product_id) LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '170309' AND p.status = '1'
56	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 pnl.quantity from product_new_location pnl where p.product_id = pnl.product_id and pnl.location_id = '1') as spb_quantity, (SELECT pnl.quantity from product_new_location pnl where p.id_baza = pnl.product_id and pnl.location_id = '1') as spb_quantity_baza, (SELECT pnl.quantity from product_new_location pnl where p.id_ramka = pnl.product_id and pnl.location_id = '1') as spb_quantity_ramka, (SELECT pa.text from product_attribute pa where p.product_id = pa.product_id and pa.attribute_id = '66') as processor, (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 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, p.sort_order FROM product p LEFT JOIN product_description pd ON (p.product_id = pd.product_id) LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '90907' AND p.status = '1'
57	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 pnl.quantity from product_new_location pnl where p.product_id = pnl.product_id and pnl.location_id = '1') as spb_quantity, (SELECT pnl.quantity from product_new_location pnl where p.id_baza = pnl.product_id and pnl.location_id = '1') as spb_quantity_baza, (SELECT pnl.quantity from product_new_location pnl where p.id_ramka = pnl.product_id and pnl.location_id = '1') as spb_quantity_ramka, (SELECT pa.text from product_attribute pa where p.product_id = pa.product_id and pa.attribute_id = '66') as processor, (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 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, p.sort_order FROM product p LEFT JOIN product_description pd ON (p.product_id = pd.product_id) LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '92748' AND p.status = '1'
58	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 pnl.quantity from product_new_location pnl where p.product_id = pnl.product_id and pnl.location_id = '1') as spb_quantity, (SELECT pnl.quantity from product_new_location pnl where p.id_baza = pnl.product_id and pnl.location_id = '1') as spb_quantity_baza, (SELECT pnl.quantity from product_new_location pnl where p.id_ramka = pnl.product_id and pnl.location_id = '1') as spb_quantity_ramka, (SELECT pa.text from product_attribute pa where p.product_id = pa.product_id and pa.attribute_id = '66') as processor, (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 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, p.sort_order FROM product p LEFT JOIN product_description pd ON (p.product_id = pd.product_id) LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '90922' AND p.status = '1'
59	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 pnl.quantity from product_new_location pnl where p.product_id = pnl.product_id and pnl.location_id = '1') as spb_quantity, (SELECT pnl.quantity from product_new_location pnl where p.id_baza = pnl.product_id and pnl.location_id = '1') as spb_quantity_baza, (SELECT pnl.quantity from product_new_location pnl where p.id_ramka = pnl.product_id and pnl.location_id = '1') as spb_quantity_ramka, (SELECT pa.text from product_attribute pa where p.product_id = pa.product_id and pa.attribute_id = '66') as processor, (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 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, p.sort_order FROM product p LEFT JOIN product_description pd ON (p.product_id = pd.product_id) LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '178104' AND p.status = '1'
60	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 pnl.quantity from product_new_location pnl where p.product_id = pnl.product_id and pnl.location_id = '1') as spb_quantity, (SELECT pnl.quantity from product_new_location pnl where p.id_baza = pnl.product_id and pnl.location_id = '1') as spb_quantity_baza, (SELECT pnl.quantity from product_new_location pnl where p.id_ramka = pnl.product_id and pnl.location_id = '1') as spb_quantity_ramka, (SELECT pa.text from product_attribute pa where p.product_id = pa.product_id and pa.attribute_id = '66') as processor, (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 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, p.sort_order FROM product p LEFT JOIN product_description pd ON (p.product_id = pd.product_id) LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '196049' AND p.status = '1'
61	0.0004	ControllerProductCategory	SELECT DISTINCT , pd.name AS name, p.image, p.market_output, m.name AS manufacturer, (SELECT p2.quantity from product p2 where p.id_baza = p2.product_id) as quantity_baza, (SELECT p2.quantity from product p2 where p.id_ramka = p2.product_id) as quantity_ramka, (SELECT pnl.quantity from product_new_location pnl where p.product_id = pnl.product_id and pnl.location_id = '1') as spb_quantity, (SELECT pnl.quantity from product_new_location pnl where p.id_baza = pnl.product_id and pnl.location_id = '1') as spb_quantity_baza, (SELECT pnl.quantity from product_new_location pnl where p.id_ramka = pnl.product_id and pnl.location_id = '1') as spb_quantity_ramka, (SELECT pa.text from product_attribute pa where p.product_id = pa.product_id and pa.attribute_id = '66') as processor, (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 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, p.sort_order FROM product p LEFT JOIN product_description pd ON (p.product_id = pd.product_id) LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '120725' AND p.status = '1'
62	0.0001	ControllerProductCategory	SELECT * FROM product_image WHERE product_id IN (209639) ORDER BY product_id, sort_order ASC
63	0.0003	ControllerProductCategory	SELECT a.attribute_id, ad.name, ad.tooltip, pa.text FROM product_attribute pa LEFT JOIN attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN attribute_description ad ON (a.attribute_id = ad.attribute_id) WHERE pa.product_id = '209639' AND a.attribute_group_id = '8' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
64	0.0001	ControllerProductCategory	SELECT category_id FROM product_to_category WHERE product_id = '209639' ORDER BY main_category DESC LIMIT 1
65	0.0001	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=94' LIMIT 1
66	0.0001	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=1543' LIMIT 1
67	0.0001	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'product_id=209639' LIMIT 1
68	0.0001	ControllerProductCategory	SELECT * FROM product_image WHERE product_id IN (172353) ORDER BY product_id, sort_order ASC
69	0.0003	ControllerProductCategory	SELECT a.attribute_id, ad.name, ad.tooltip, pa.text FROM product_attribute pa LEFT JOIN attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN attribute_description ad ON (a.attribute_id = ad.attribute_id) WHERE pa.product_id = '172353' AND a.attribute_group_id = '8' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
70	0.0001	ControllerProductCategory	SELECT category_id FROM product_to_category WHERE product_id = '172353' ORDER BY main_category DESC LIMIT 1
71	0.0001	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=94' LIMIT 1
72	0.0001	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=1543' LIMIT 1
73	0.0001	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'product_id=172353' LIMIT 1
74	0.0001	ControllerProductCategory	SELECT * FROM product_image WHERE product_id IN (90311) ORDER BY product_id, sort_order ASC
75	0.0003	ControllerProductCategory	SELECT a.attribute_id, ad.name, ad.tooltip, pa.text FROM product_attribute pa LEFT JOIN attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN attribute_description ad ON (a.attribute_id = ad.attribute_id) WHERE pa.product_id = '90311' AND a.attribute_group_id = '8' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
76	0.0001	ControllerProductCategory	SELECT category_id FROM product_to_category WHERE product_id = '90311' ORDER BY main_category DESC LIMIT 1
77	0.0001	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=94' LIMIT 1
78	0.0001	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=1543' LIMIT 1
79	0.0001	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'product_id=90311' LIMIT 1
80	0.0001	ControllerProductCategory	SELECT * FROM product_image WHERE product_id IN (75724) ORDER BY product_id, sort_order ASC
81	0.0003	ControllerProductCategory	SELECT a.attribute_id, ad.name, ad.tooltip, pa.text FROM product_attribute pa LEFT JOIN attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN attribute_description ad ON (a.attribute_id = ad.attribute_id) WHERE pa.product_id = '75724' AND a.attribute_group_id = '8' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
82	0.0001	ControllerProductCategory	SELECT category_id FROM product_to_category WHERE product_id = '75724' ORDER BY main_category DESC LIMIT 1
83	0.0001	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=94' LIMIT 1
84	0.0001	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=1543' LIMIT 1
85	0.0001	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'product_id=75724' LIMIT 1
86	0.0001	ControllerProductCategory	SELECT * FROM product_image WHERE product_id IN (90910) ORDER BY product_id, sort_order ASC
87	0.0003	ControllerProductCategory	SELECT a.attribute_id, ad.name, ad.tooltip, pa.text FROM product_attribute pa LEFT JOIN attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN attribute_description ad ON (a.attribute_id = ad.attribute_id) WHERE pa.product_id = '90910' AND a.attribute_group_id = '8' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
88	0.0001	ControllerProductCategory	SELECT category_id FROM product_to_category WHERE product_id = '90910' ORDER BY main_category DESC LIMIT 1
89	0.0001	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=94' LIMIT 1
90	0.0001	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=1543' LIMIT 1
91	0.0001	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'product_id=90910' LIMIT 1
92	0.0001	ControllerProductCategory	SELECT * FROM product_image WHERE product_id IN (46545) ORDER BY product_id, sort_order ASC
93	0.0003	ControllerProductCategory	SELECT a.attribute_id, ad.name, ad.tooltip, pa.text FROM product_attribute pa LEFT JOIN attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN attribute_description ad ON (a.attribute_id = ad.attribute_id) WHERE pa.product_id = '46545' AND a.attribute_group_id = '8' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
94	0.0001	ControllerProductCategory	SELECT category_id FROM product_to_category WHERE product_id = '46545' ORDER BY main_category DESC LIMIT 1
95	0.0001	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=94' LIMIT 1
96	0.0001	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=1543' LIMIT 1
97	0.0001	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'product_id=46545' LIMIT 1
98	0.0001	ControllerProductCategory	SELECT * FROM product_image WHERE product_id IN (125599) ORDER BY product_id, sort_order ASC
99	0.0003	ControllerProductCategory	SELECT a.attribute_id, ad.name, ad.tooltip, pa.text FROM product_attribute pa LEFT JOIN attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN attribute_description ad ON (a.attribute_id = ad.attribute_id) WHERE pa.product_id = '125599' AND a.attribute_group_id = '8' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
100	0.0001	ControllerProductCategory	SELECT category_id FROM product_to_category WHERE product_id = '125599' ORDER BY main_category DESC LIMIT 1
101	0.0001	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=94' LIMIT 1
102	0.0001	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=1543' LIMIT 1
103	0.0001	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'product_id=125599' LIMIT 1
104	0.0001	ControllerProductCategory	SELECT * FROM product_image WHERE product_id IN (171751) ORDER BY product_id, sort_order ASC
105	0.0003	ControllerProductCategory	SELECT a.attribute_id, ad.name, ad.tooltip, pa.text FROM product_attribute pa LEFT JOIN attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN attribute_description ad ON (a.attribute_id = ad.attribute_id) WHERE pa.product_id = '171751' AND a.attribute_group_id = '8' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
106	0.0001	ControllerProductCategory	SELECT category_id FROM product_to_category WHERE product_id = '171751' ORDER BY main_category DESC LIMIT 1
107	0.0001	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=94' LIMIT 1
108	0.0001	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=1543' LIMIT 1
109	0.0001	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'product_id=171751' LIMIT 1
110	0.0001	ControllerProductCategory	SELECT * FROM product_image WHERE product_id IN (47793) ORDER BY product_id, sort_order ASC
111	0.0003	ControllerProductCategory	SELECT a.attribute_id, ad.name, ad.tooltip, pa.text FROM product_attribute pa LEFT JOIN attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN attribute_description ad ON (a.attribute_id = ad.attribute_id) WHERE pa.product_id = '47793' AND a.attribute_group_id = '8' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
112	0.0001	ControllerProductCategory	SELECT category_id FROM product_to_category WHERE product_id = '47793' ORDER BY main_category DESC LIMIT 1
113	0.0001	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=94' LIMIT 1
114	0.0001	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=1543' LIMIT 1
115	0.0001	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'product_id=47793' LIMIT 1
116	0.0001	ControllerProductCategory	SELECT * FROM product_image WHERE product_id IN (130542) ORDER BY product_id, sort_order ASC
117	0.0003	ControllerProductCategory	SELECT a.attribute_id, ad.name, ad.tooltip, pa.text FROM product_attribute pa LEFT JOIN attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN attribute_description ad ON (a.attribute_id = ad.attribute_id) WHERE pa.product_id = '130542' AND a.attribute_group_id = '8' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
118	0.0001	ControllerProductCategory	SELECT category_id FROM product_to_category WHERE product_id = '130542' ORDER BY main_category DESC LIMIT 1
119	0.0001	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=94' LIMIT 1
120	0.0001	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=1543' LIMIT 1
121	0.0001	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'product_id=130542' LIMIT 1
122	0.0001	ControllerProductCategory	SELECT * FROM product_image WHERE product_id IN (101264) ORDER BY product_id, sort_order ASC
123	0.0003	ControllerProductCategory	SELECT a.attribute_id, ad.name, ad.tooltip, pa.text FROM product_attribute pa LEFT JOIN attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN attribute_description ad ON (a.attribute_id = ad.attribute_id) WHERE pa.product_id = '101264' AND a.attribute_group_id = '8' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
124	0.0001	ControllerProductCategory	SELECT category_id FROM product_to_category WHERE product_id = '101264' ORDER BY main_category DESC LIMIT 1
125	0.0001	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=94' LIMIT 1
126	0.0001	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=1543' LIMIT 1
127	0.0001	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'product_id=101264' LIMIT 1
128	0.0001	ControllerProductCategory	SELECT * FROM product_image WHERE product_id IN (170309) ORDER BY product_id, sort_order ASC
129	0.0003	ControllerProductCategory	SELECT a.attribute_id, ad.name, ad.tooltip, pa.text FROM product_attribute pa LEFT JOIN attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN attribute_description ad ON (a.attribute_id = ad.attribute_id) WHERE pa.product_id = '170309' AND a.attribute_group_id = '8' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
130	0.0001	ControllerProductCategory	SELECT category_id FROM product_to_category WHERE product_id = '170309' ORDER BY main_category DESC LIMIT 1
131	0.0001	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=94' LIMIT 1
132	0.0001	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=1543' LIMIT 1
133	0.0001	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'product_id=170309' LIMIT 1
134	0.0001	ControllerProductCategory	SELECT * FROM product_image WHERE product_id IN (90907) ORDER BY product_id, sort_order ASC
135	0.0002	ControllerProductCategory	SELECT a.attribute_id, ad.name, ad.tooltip, pa.text FROM product_attribute pa LEFT JOIN attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN attribute_description ad ON (a.attribute_id = ad.attribute_id) WHERE pa.product_id = '90907' AND a.attribute_group_id = '8' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
136	0.0001	ControllerProductCategory	SELECT category_id FROM product_to_category WHERE product_id = '90907' ORDER BY main_category DESC LIMIT 1
137	0.0001	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=94' LIMIT 1
138	0.0001	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=1543' LIMIT 1
139	0.0001	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'product_id=90907' LIMIT 1
140	0.0001	ControllerProductCategory	SELECT * FROM product_image WHERE product_id IN (92748) ORDER BY product_id, sort_order ASC
141	0.0002	ControllerProductCategory	SELECT a.attribute_id, ad.name, ad.tooltip, pa.text FROM product_attribute pa LEFT JOIN attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN attribute_description ad ON (a.attribute_id = ad.attribute_id) WHERE pa.product_id = '92748' AND a.attribute_group_id = '8' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
142	0.0001	ControllerProductCategory	SELECT category_id FROM product_to_category WHERE product_id = '92748' ORDER BY main_category DESC LIMIT 1
143	0.0001	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=94' LIMIT 1
144	0.0001	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=1543' LIMIT 1
145	0.0001	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'product_id=92748' LIMIT 1
146	0.0001	ControllerProductCategory	SELECT * FROM product_image WHERE product_id IN (90922) ORDER BY product_id, sort_order ASC
147	0.0002	ControllerProductCategory	SELECT a.attribute_id, ad.name, ad.tooltip, pa.text FROM product_attribute pa LEFT JOIN attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN attribute_description ad ON (a.attribute_id = ad.attribute_id) WHERE pa.product_id = '90922' AND a.attribute_group_id = '8' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
148	0.0001	ControllerProductCategory	SELECT category_id FROM product_to_category WHERE product_id = '90922' ORDER BY main_category DESC LIMIT 1
149	0.0001	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=94' LIMIT 1
150	0.0001	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=1543' LIMIT 1
151	0.0001	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'product_id=90922' LIMIT 1
152	0.0001	ControllerProductCategory	SELECT * FROM product_image WHERE product_id IN (178104) ORDER BY product_id, sort_order ASC
153	0.0002	ControllerProductCategory	SELECT a.attribute_id, ad.name, ad.tooltip, pa.text FROM product_attribute pa LEFT JOIN attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN attribute_description ad ON (a.attribute_id = ad.attribute_id) WHERE pa.product_id = '178104' AND a.attribute_group_id = '8' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
154	0.0001	ControllerProductCategory	SELECT category_id FROM product_to_category WHERE product_id = '178104' ORDER BY main_category DESC LIMIT 1
155	0.0001	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=94' LIMIT 1
156	0.0001	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=1543' LIMIT 1
157	0.0001	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'product_id=178104' LIMIT 1
158	0.0001	ControllerProductCategory	SELECT * FROM product_image WHERE product_id IN (196049) ORDER BY product_id, sort_order ASC
159	0.0002	ControllerProductCategory	SELECT a.attribute_id, ad.name, ad.tooltip, pa.text FROM product_attribute pa LEFT JOIN attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN attribute_description ad ON (a.attribute_id = ad.attribute_id) WHERE pa.product_id = '196049' AND a.attribute_group_id = '8' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
160	0.0001	ControllerProductCategory	SELECT category_id FROM product_to_category WHERE product_id = '196049' ORDER BY main_category DESC LIMIT 1
161	0.0001	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=94' LIMIT 1
162	0.0001	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'product_id=196049' LIMIT 1
163	0.0001	ControllerProductCategory	SELECT * FROM product_image WHERE product_id IN (120725) ORDER BY product_id, sort_order ASC
164	0.0002	ControllerProductCategory	SELECT a.attribute_id, ad.name, ad.tooltip, pa.text FROM product_attribute pa LEFT JOIN attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN attribute_description ad ON (a.attribute_id = ad.attribute_id) WHERE pa.product_id = '120725' AND a.attribute_group_id = '8' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
165	0.0001	ControllerProductCategory	SELECT category_id FROM product_to_category WHERE product_id = '120725' ORDER BY main_category DESC LIMIT 1
166	0.0001	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=94' LIMIT 1
167	0.0001	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=1543' LIMIT 1
168	0.0001	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'product_id=120725' LIMIT 1
169	0.0001	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=94' LIMIT 1
170	0.0001	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=1543' LIMIT 1
171	0.0001	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=94' LIMIT 1
172	0.0001	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=1543' LIMIT 1
173	0.0001	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=94' LIMIT 1
174	0.0001	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=1543' LIMIT 1
175	0.0001	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=94' LIMIT 1
176	0.0001	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=1543' LIMIT 1
177	0.0001	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=94' LIMIT 1
178	0.0001	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=1543' LIMIT 1
179	0.0001	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=94' LIMIT 1
180	0.0001	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=1543' LIMIT 1
181	0.0001	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=94' LIMIT 1
182	0.0001	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=1543' LIMIT 1
183	0.0001	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=94' LIMIT 1
184	0.0001	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=1543' LIMIT 1
185	0.0001	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=94' LIMIT 1
186	0.0001	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=1543' LIMIT 1
187	0.0001	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=94' LIMIT 1
188	0.0001	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=1543' LIMIT 1
189	0.0001	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=94' LIMIT 1
190	0.0001	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=1543' LIMIT 1
191	0.0001	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=94' LIMIT 1
192	0.0001	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=1543' LIMIT 1
193	0.0001	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=94' LIMIT 1
194	0.0001	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=1543' LIMIT 1
195	0.0001	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=94' LIMIT 1
196	0.0001	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=1543' LIMIT 1
197	0.0001	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=94' LIMIT 1
198	0.0001	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=1543' LIMIT 1
199	0.0001	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=94' LIMIT 1
200	0.0001	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=1543' LIMIT 1
201	0.0001	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=94' LIMIT 1
202	0.0001	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=1543' LIMIT 1
203	0.0001	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=94' LIMIT 1
204	0.0001	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=1543' LIMIT 1
205	0.0001	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=94' LIMIT 1
206	0.0001	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=1543' LIMIT 1
207	0.0001	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=94' LIMIT 1
208	0.0001	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=1543' LIMIT 1
209	0.0001	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=94' LIMIT 1
210	0.0001	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=1543' LIMIT 1
211	0.0001	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=94' LIMIT 1
212	0.0001	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=1543' LIMIT 1
213	0.0001	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=94' LIMIT 1
214	0.0001	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=1543' LIMIT 1
215	0.0001	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=94' LIMIT 1
216	0.0001	ControllerProductCategory	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=1543' LIMIT 1
217	0.0001	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 = '1543' AND c2s.store_id = '0' LIMIT 1
218	0.0003	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 = '1543' AND p.category = '1' ORDER BY p.page_id DESC
219	0.0025	ControllerEventCompatibility	SELECT COUNT(DISTINCT p.product_id) AS total, p.manufacturer_id AS vid FROM product p LEFT JOIN product_to_category p2c ON (p.product_id = p2c.product_id) WHERE p.status = '1' AND p.catalog_output = '1' AND p2c.category_id = '1543' GROUP BY vid
220	0.0043	ControllerEventCompatibility	SELECT COUNT(DISTINCT p.product_id) AS total, IF((p.quantity > 0 AND p.quantity <> 1000), '2', '1') AS vid FROM product p LEFT JOIN product_to_category p2c ON (p.product_id = p2c.product_id) WHERE p.status = '1' AND p.catalog_output = '1' AND p2c.category_id = '1543' GROUP BY vid UNION SELECT COUNT(DISTINCT p.product_id) AS total, '3' AS vid FROM product p LEFT JOIN product_to_category p2c ON (p.product_id = p2c.product_id) WHERE p.status = '1' AND p.catalog_output = '1' AND p2c.category_id = '1543' AND p.quantity_spb > 0 AND p.quantity_spb <> 1000 GROUP BY vid
221	0.0042	ControllerEventCompatibility	SELECT COUNT(DISTINCT p.product_id) AS total, CONCAT(fv2p.filter_id, '.', fv2p.source) AS fk, fv2p.value_id AS vid FROM ocfilter_filter_value_to_product fv2p LEFT JOIN product p ON (fv2p.product_id = p.product_id) LEFT JOIN product_to_category p2c ON (p.product_id = p2c.product_id) WHERE p.status = '1' AND p.catalog_output = '1' AND p2c.category_id = '1543' GROUP BY fk, vid
222	0.0001	ControllerEventCompatibility	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'common/home' LIMIT 1
223	0.0001	ControllerCommonColumnLeft	SELECT * FROM category_to_layout WHERE category_id = '1543'
224	0.0001	ControllerCommonColumnLeft	SELECT * FROM layout_route WHERE 'product/category' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1
225	0.0001	ControllerCommonColumnLeft	SELECT * FROM layout_module WHERE layout_id = '3' AND position = 'column_left' ORDER BY sort_order
226	0.0001	ControllerEventCompatibility	SELECT * FROM ocfilter_setting WHERE `key` = 'placement_layout'
227	0.0001	ControllerEventCompatibility	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=94' LIMIT 1
228	0.0001	ControllerEventCompatibility	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=1543' LIMIT 1
229	0.0021	ControllerEventCompatibility	SELECT COUNT(DISTINCT p.product_id) AS total, p.manufacturer_id AS vid FROM product p LEFT JOIN product_to_category p2c ON (p.product_id = p2c.product_id) WHERE p.status = '1' AND p.catalog_output = '1' AND p2c.category_id = '1543' GROUP BY vid
230	0.0039	ControllerEventCompatibility	SELECT COUNT(DISTINCT p.product_id) AS total, IF((p.quantity > 0 AND p.quantity <> 1000), '2', '1') AS vid FROM product p LEFT JOIN product_to_category p2c ON (p.product_id = p2c.product_id) WHERE p.status = '1' AND p.catalog_output = '1' AND p2c.category_id = '1543' GROUP BY vid UNION SELECT COUNT(DISTINCT p.product_id) AS total, '3' AS vid FROM product p LEFT JOIN product_to_category p2c ON (p.product_id = p2c.product_id) WHERE p.status = '1' AND p.catalog_output = '1' AND p2c.category_id = '1543' AND p.quantity_spb > 0 AND p.quantity_spb <> 1000 GROUP BY vid
231	0.0041	ControllerEventCompatibility	SELECT COUNT(DISTINCT p.product_id) AS total, CONCAT(fv2p.filter_id, '.', fv2p.source) AS fk, fv2p.value_id AS vid FROM ocfilter_filter_value_to_product fv2p LEFT JOIN product p ON (fv2p.product_id = p.product_id) LEFT JOIN product_to_category p2c ON (p.product_id = p2c.product_id) WHERE p.status = '1' AND p.catalog_output = '1' AND p2c.category_id = '1543' GROUP BY fk, vid
232	0.0002	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 = '1543' OR f2c.category_id = '0') GROUP BY f.filter_id, f.source
233	0.0001	ControllerEventCompatibility	SELECT `value` FROM ocfilter_cache WHERE `key` = '799108249'
234	0	ControllerEventCompatibility	SELECT `value` FROM ocfilter_cache WHERE `key` = '3463394037'
235	0	ControllerEventCompatibility	SELECT `value` FROM ocfilter_cache WHERE `key` = '1432436729'
236	0	ControllerEventCompatibility	SELECT `value` FROM ocfilter_cache WHERE `key` = '3236483636'
237	0	ControllerEventCompatibility	SELECT `value` FROM ocfilter_cache WHERE `key` = '1388308038'
238	0.0001	ControllerEventCompatibility	SELECT `value` FROM ocfilter_cache WHERE `key` = '1830280939'
239	0.0001	ControllerEventCompatibility	SELECT `value` FROM ocfilter_cache WHERE `key` = '2775908286'
240	0.0001	ControllerEventCompatibility	SELECT `value` FROM ocfilter_cache WHERE `key` = '2958325014'
241	0.0002	ControllerEventCompatibility	SELECT `value` FROM ocfilter_cache WHERE `key` = '3375549275'
242	0.0004	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 = '1543' AND p.module = '1' ORDER BY p.page_id DESC
243	0.002	ControllerEventCompatibility	SELECT COUNT(DISTINCT p.product_id) AS total, p.manufacturer_id AS vid FROM product p LEFT JOIN product_to_category p2c ON (p.product_id = p2c.product_id) WHERE p.status = '1' AND p.catalog_output = '1' AND p2c.category_id = '1543' GROUP BY vid
244	0.004	ControllerEventCompatibility	SELECT COUNT(DISTINCT p.product_id) AS total, IF((p.quantity > 0 AND p.quantity <> 1000), '2', '1') AS vid FROM product p LEFT JOIN product_to_category p2c ON (p.product_id = p2c.product_id) WHERE p.status = '1' AND p.catalog_output = '1' AND p2c.category_id = '1543' GROUP BY vid UNION SELECT COUNT(DISTINCT p.product_id) AS total, '3' AS vid FROM product p LEFT JOIN product_to_category p2c ON (p.product_id = p2c.product_id) WHERE p.status = '1' AND p.catalog_output = '1' AND p2c.category_id = '1543' AND p.quantity_spb > 0 AND p.quantity_spb <> 1000 GROUP BY vid
245	0.0051	ControllerEventCompatibility	SELECT COUNT(DISTINCT p.product_id) AS total, CONCAT(fv2p.filter_id, '.', fv2p.source) AS fk, fv2p.value_id AS vid FROM ocfilter_filter_value_to_product fv2p LEFT JOIN product p ON (fv2p.product_id = p.product_id) LEFT JOIN product_to_category p2c ON (p.product_id = p2c.product_id) WHERE p.status = '1' AND p.catalog_output = '1' AND p2c.category_id = '1543' GROUP BY fk, vid
246	0.0001	ControllerEventCompatibility	SELECT * FROM module WHERE module_id = '46'
247	0.0002	ControllerCommonColumnRight	SELECT * FROM category_to_layout WHERE category_id = '1543'
248	0.0002	ControllerCommonColumnRight	SELECT * FROM layout_route WHERE 'product/category' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1
249	0.0001	ControllerCommonColumnRight	SELECT * FROM layout_module WHERE layout_id = '3' AND position = 'column_right' ORDER BY sort_order
250	0.0001	ControllerCommonContentTop	SELECT * FROM category_to_layout WHERE category_id = '1543'
251	0.0002	ControllerCommonContentTop	SELECT * FROM layout_route WHERE 'product/category' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1
252	0.0001	ControllerCommonContentTop	SELECT * FROM layout_module WHERE layout_id = '3' AND position = 'content_top' ORDER BY sort_order
253	0.0001	ControllerCommonContentBottom	SELECT * FROM category_to_layout WHERE category_id = '1543'
254	0.0001	ControllerCommonContentBottom	SELECT * FROM layout_route WHERE 'product/category' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1
255	0.0001	ControllerCommonContentBottom	SELECT * FROM layout_module WHERE layout_id = '3' AND position = 'content_bottom' ORDER BY sort_order
256	0.0003	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
257	0.0007	ControllerExtensionModuleOCFilter	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
258	0.0001	ControllerExtensionModuleOCFilter	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'information_id=22' LIMIT 1
259	0.0001	ControllerExtensionModuleOCFilter	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'information_id=21' LIMIT 1
260	0.0001	ControllerExtensionModuleOCFilter	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'information_id=14' LIMIT 1
261	0.0001	ControllerExtensionModuleOCFilter	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'information_id=23' LIMIT 1
262	0.0001	ControllerExtensionModuleOCFilter	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'information_id=8' LIMIT 1
263	0.0001	ControllerExtensionModuleOCFilter	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'information_id=6' LIMIT 1
264	0.0001	ControllerExtensionModuleOCFilter	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'information_id=9' LIMIT 1
265	0.0001	ControllerExtensionModuleOCFilter	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'information/contact' LIMIT 1
266	0.0002	ControllerExtensionModuleOCFilter	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'account/return/add' LIMIT 1
267	0.0001	ControllerExtensionModuleOCFilter	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'information/sitemap' LIMIT 1
268	0.0001	ControllerExtensionModuleOCFilter	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'product/manufacturer' LIMIT 1
269	0.0002	ControllerExtensionModuleOCFilter	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'account/voucher' LIMIT 1
270	0.0001	ControllerExtensionModuleOCFilter	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'affiliate/account' LIMIT 1
271	0.0001	ControllerExtensionModuleOCFilter	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'product/special' LIMIT 1
272	0.0001	ControllerExtensionModuleOCFilter	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'revolution/account/revaccount' LIMIT 1
273	0.0001	ControllerExtensionModuleOCFilter	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'account/order' LIMIT 1
274	0.0001	ControllerExtensionModuleOCFilter	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'account/wishlist' LIMIT 1
275	0.0001	ControllerExtensionModuleOCFilter	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'account/newsletter' LIMIT 1
276	0.0001	ControllerCommonHeader	SELECT * FROM extension WHERE `type` = 'analytics'
277	0.0001	ControllerCommonCartMobi	SELECT SUM(quantity) as total FROM cart WHERE api_id = '0' AND session_id = 'cfc7a1ff4d683bda1b3e92036047de72'
278	0.0001	ControllerCommonCartMobi	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'checkout/cart' LIMIT 1
279	0.0001	ControllerCommonCartMobi	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'checkout/checkout' LIMIT 1
280	0.0001	ControllerExtensionModuleOCFilter	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'product/compare' LIMIT 1
281	0.0001	ControllerExtensionModuleOCFilter	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'revolution/account/revaccount' LIMIT 1
282	0.0001	ControllerExtensionModuleOCFilter	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'account/logout' LIMIT 1
283	0.0001	ControllerExtensionModuleOCFilter	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'common/home' LIMIT 1
284	0.0001	ControllerExtensionModuleOCFilter	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'account/wishlist' LIMIT 1
285	0.0001	ControllerExtensionModuleOCFilter	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'revolution/account/revaccount' LIMIT 1
286	0.0001	ControllerExtensionModuleOCFilter	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'revolution/account/revregister' LIMIT 1
287	0.0001	ControllerExtensionModuleOCFilter	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'account/login' LIMIT 1
288	0.0001	ControllerExtensionModuleOCFilter	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'account/order' LIMIT 1
289	0.0001	ControllerExtensionModuleOCFilter	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'account/transaction' LIMIT 1
290	0.0001	ControllerExtensionModuleOCFilter	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'account/download' LIMIT 1
291	0.0001	ControllerExtensionModuleOCFilter	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'account/logout' LIMIT 1
292	0.0001	ControllerExtensionModuleOCFilter	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'checkout/cart' LIMIT 1
293	0.0001	ControllerExtensionModuleOCFilter	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'checkout/checkout' LIMIT 1
294	0.0001	ControllerExtensionModuleOCFilter	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'information/contact' LIMIT 1
295	0.0001	ControllerCommonLanguage	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'common/language/language' LIMIT 1
296	0.0001	ControllerCommonLanguage	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=94' LIMIT 1
297	0.0001	ControllerCommonLanguage	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=1543' LIMIT 1
298	0.0001	ControllerCommonCurrency	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'common/currency/currency' LIMIT 1
299	0.0001	ControllerCommonCurrency	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=94' LIMIT 1
300	0.0001	ControllerCommonCurrency	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'category_id=1543' LIMIT 1
301	0.0005	ControllerCommonSearch	SELECT * FROM category c LEFT JOIN category_description cd ON (c.category_id = cd.category_id) WHERE c.parent_id = '0' AND cd.language_id = '1' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)
302	0.0001	ControllerCommonCart	SELECT * FROM cart WHERE api_id = '0' AND session_id = 'cfc7a1ff4d683bda1b3e92036047de72'
303	0.0001	ControllerCommonCart	SELECT * FROM extension WHERE `type` = 'total'
304	0.0001	ControllerEventCompatibility	SELECT * FROM cart WHERE api_id = '0' AND session_id = 'cfc7a1ff4d683bda1b3e92036047de72'
305	0.0001	ControllerEventCompatibility	SELECT SUM(quantity) as total FROM cart WHERE api_id = '0' AND session_id = 'cfc7a1ff4d683bda1b3e92036047de72'
306	0.0001	ControllerEventCompatibility	SELECT * FROM cart WHERE api_id = '0' AND session_id = 'cfc7a1ff4d683bda1b3e92036047de72'
307	0.0001	ControllerEventCompatibility	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'checkout/cart' LIMIT 1
308	0.0001	ControllerEventCompatibility	SELECT LCASE(keyword) as keyword FROM url_alias WHERE query = 'checkout/checkout' LIMIT 1
309	0.0001	ControllerExtensionModuleOCFilter	SELECT SUM(quantity) as total FROM cart WHERE api_id = '0' AND session_id = 'cfc7a1ff4d683bda1b3e92036047de72'
310	0.0002	ControllerExtensionModuleFlamixBitrix24Integrations	SELECT * FROM setting WHERE store_id = '0' AND `code` = 'fx_b24'

Запрос на снижение цены.

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

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

Заявки с досок объявлений, китайских сайтов не рассматриваются.

Отмена

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

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

Отмена

Рамки под планшеты 9/10 дюймов

Рамка RM-9-1230 под магнитолу 9 дюймов для Lada Niva 2123, Niva Travel (2021-2024) / Chevrolet Niva (2002-2020) В наличии Москва - Ташкентская 28с1 В наличии Питер - Придорожная аллея 8

Рамка RM-9-9820 под магнитолу 9 дюймов для Lada Vesta (NG) (2022-2024) (черная, матовая) В наличии Москва - Ташкентская 28с1 В наличии Питер - Придорожная аллея 8

Рамка RM-9-1680 под магнитолу 9 дюймов для Geely MK (2006-2013) В наличии Москва - 1 шт. Ташкентская 28с1 В наличии Питер - 1 шт. Придорожная аллея 8

Рамка RM-10-1210 под магнитолу 10 дюймов для Nissan Almera (N16), Sentra 5 (B15) (1999-2006) В наличии Москва - Ташкентская 28с1

Рамка RM-10-1200 переходная с 10 дюймов на 9 дюймов (проставка) В наличии Москва - Ташкентская 28с1 В наличии Питер - Придорожная аллея 8

Рамка RM-1081 под магнитолу 10 дюймов для Chevrolet Lacetti (2004-2013) (тип 1, серая) В наличии Москва - Ташкентская 28с1 В наличии Питер - 1 шт. Придорожная аллея 8

Рамка RM-10-2562 под магнитолу 10 дюймов для Mitsubishi Delica D:5 (2018-2024) В наличии Москва - Ташкентская 28с1 В наличии Питер - Придорожная аллея 8

Рамка RM-9-442 под магнитолу 9 дюймов для Mazda 323 6 (BJ), Premacy (CP), Protege 3 (BJ) (1998-2004) В наличии Москва - Ташкентская 28с1 В наличии Питер - 1 шт. Придорожная аллея 8

Рамка RM-9-1424 под магнитолу 9 дюймов для Nissan Navara 3 (D40), Pathfinder 3 (2004-2014) (для авто с навигацией) В наличии Москва - Ташкентская 28с1 В наличии Питер - 1 шт. Придорожная аллея 8

Рамка RM-10-1368 под магнитолу 10 дюймов для Mercedes S-klasse (w140) (1991-1998) В наличии Москва - 1 шт. Ташкентская 28с1

Рамка RM-10-1864 под магнитолу 10 дюймов для Changan CS75 (2014-2020)

Рамка RM-10-1280 переходная универсальная с 173*98 / 178*102 под магнитолу 10 дюймов В наличии Москва - Ташкентская 28с1 В наличии Питер - Придорожная аллея 8

Рамка RM-9-1862 под магнитолу 9 дюймов для GAZ Газел Бизнес (Gazele Business) (серебристая) В наличии Москва - Ташкентская 28с1

Рамка RM-9-1684 под магнитолу 9 дюймов для Chery Fora (A21) (2006-2011) В наличии Москва - Ташкентская 28с1

Рамка RM-10-0184 под магнитолу 10 дюймов для Ford Explorer 4 (2005-2010)

Клипса для установки переходной рамки

Рамка RM-9-1395 под магнитолу 9 дюймов для Lada Priora (2013-2018) (глянцевая) В наличии Москва - Ташкентская 28с1

Рамка RM-9-1230 под магнитолу 9 дюймов для Lada Niva 2123, Niva Travel (2021-2024) / Chevrolet Niva (2002-2020)
В наличии Москва - Ташкентская 28с1
В наличии Питер - Придорожная аллея 8

Рамка RM-9-9820 под магнитолу 9 дюймов для Lada Vesta (NG) (2022-2024) (черная, матовая)
В наличии Москва - Ташкентская 28с1
В наличии Питер - Придорожная аллея 8

Рамка RM-9-1680 под магнитолу 9 дюймов для Geely MK (2006-2013)
В наличии Москва - 1 шт. Ташкентская 28с1
В наличии Питер - 1 шт. Придорожная аллея 8

Рамка RM-10-1210 под магнитолу 10 дюймов для Nissan Almera (N16), Sentra 5 (B15) (1999-2006)
В наличии Москва - Ташкентская 28с1

Рамка RM-10-1200 переходная с 10 дюймов на 9 дюймов (проставка)
В наличии Москва - Ташкентская 28с1
В наличии Питер - Придорожная аллея 8

Рамка RM-1081 под магнитолу 10 дюймов для Chevrolet Lacetti (2004-2013) (тип 1, серая)
В наличии Москва - Ташкентская 28с1
В наличии Питер - 1 шт. Придорожная аллея 8

Рамка RM-10-2562 под магнитолу 10 дюймов для Mitsubishi Delica D:5 (2018-2024)
В наличии Москва - Ташкентская 28с1
В наличии Питер - Придорожная аллея 8

Рамка RM-9-442 под магнитолу 9 дюймов для Mazda 323 6 (BJ), Premacy (CP), Protege 3 (BJ) (1998-2004)
В наличии Москва - Ташкентская 28с1
В наличии Питер - 1 шт. Придорожная аллея 8

Рамка RM-9-1424 под магнитолу 9 дюймов для Nissan Navara 3 (D40), Pathfinder 3 (2004-2014) (для авто с навигацией)
В наличии Москва - Ташкентская 28с1
В наличии Питер - 1 шт. Придорожная аллея 8

Рамка RM-10-1368 под магнитолу 10 дюймов для Mercedes S-klasse (w140) (1991-1998)
В наличии Москва - 1 шт. Ташкентская 28с1

Рамка RM-10-1280 переходная универсальная с 17398 / 178102 под магнитолу 10 дюймов
В наличии Москва - Ташкентская 28с1
В наличии Питер - Придорожная аллея 8

Рамка RM-9-1862 под магнитолу 9 дюймов для GAZ Газел Бизнес (Gazele Business) (серебристая)
В наличии Москва - Ташкентская 28с1

Рамка RM-9-1684 под магнитолу 9 дюймов для Chery Fora (A21) (2006-2011)
В наличии Москва - Ташкентская 28с1

Рамка RM-9-1395 под магнитолу 9 дюймов для Lada Priora (2013-2018) (глянцевая)
В наличии Москва - Ташкентская 28с1