Name: ЗУБР 200 л/мин, 6 л, 1500 Вт, безмасляный компрессор (КП-200-6)
Brand: ЗУБР
SKU: MKSM-КП-200-6
Price: 15970 RUB
Availability: InStock

Код товара: КП-200-6

ЗУБР 1500 Вт, 200 л/мин, 6 л, поршневой, безмасляный, компрессор воздушный КП-200-6 Мастер

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

ЗУБР

15970 р

Ближайшая доставка: дата
Самовывоз: дата, бесплатно по адресу Москва, ул. Ивана Сусанина, 2с2

Габариты, см

44x18x46

Гарантия

Кол-во выходов, шт

Мак. давление, Атм

Макс производительность, л/мин

200

Все характеристики

Качественное и надежное переносное оборудование для периодических работ дома, на даче, в небольшой мастерской, а так же для регулярной очистки от пыли офисной и бытовой техники . Безмасляный компрессор - это чистый, без примесей масла, воздух на выходе. При правильной эксплуатации ресурс данных компрессоров составляет не менее 1000 часов*. * на основании результатов испытаний лаборатории компании АО «ЗУБР ОВК»

Преимущества

Готов к работе сразу после покупки
Вырабатываемый воздух не содержит примесей масла, что не требует установки дорогостоящих маслоотделителей
Поршневой тип компрессора наиболее производителен среди другим типов
Не требует заправки маслом и контроля за наличием и его замены
Прямой привод упрощает конструкцию и увеличивает надежность
Выключатель давления обеспечивает автоматическое включение/выключение изделия при расходе сжатого воздуха
Сменный воздушный фильтр на входе защищает цилиндро-поршневую группу от абразивного износа
Быстросъемный штуцер обеспечивает удобное и быстрое подключение и отключение пневмоинструмента
Контроль давления в ресивере и на выходе при помощи двух манометров
Самовосстанавливающийся термопредохранитель
Регулировка давления на выходе позволяет настраивать давление воздуха зависимости от используемого пневмоинструмента
Механический клапан сброса давления
Шумозащитный пластиковый кожух
Удобная ручка для транспортировки

Использование

Для накопления, хранения и подачи воздуха

Характеристики

Габариты, см

44x18x46

Гарантия

Кол-во выходов, шт

Мак. давление, Атм

Макс производительность, л/мин

200

Масса в упаковке, кг

Масса изделия, кг

Мощность, Вт

1500

Набор пневмоинструментов

нет

Напряжение, В/Гц

220±10% /50

Объем ресивера, л

Термопредохранитель

есть

Тип компрессора

поршневой

Тип привода

прямой

Тип смазки

безмасляный

Тип соединения

быстросъемный

Тип упаковки

коробка картонная

Частота вращения, об/мин

2850

Отзывов: 0

Средняя оценка: 0.0

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

Вопросов: 0

Пока нет вопросов об этом товаре. Станьте первым!

Аналогичные товары

ЗУБР 200 л/мин, 6 л, 1500 Вт, 6 предметов, безмасляный компрессор (КП-200-6 Н6)

17990 р

ЗУБР 240 л/мин, 24 л, 1500 Вт, масляный компрессор (КПМ-240-24)

14200 р

ЗУБР 240 л/мин, 24 л, 1500 Вт, 6 предметов, масляный компрессор (КПМ-240-24 Н6)

17990 р

ЗУБР 260 л/мин, 50 л, 1500 Вт, масляный компрессор (КПМ-260-50)

21240 р

ЗУБР 240 л/мин, 24 л, 1500 Вт, масляный компрессор, Профессионал (ЗКПМ-240-24-1.5)

18360 р

0.0257670879	event/translation (50 action)
0.0121572015	event/theme (25 action)
0.0075876715	event/language (95 action)

0.3375599384	startup/router (1 action)
0.0158159733	startup/startup (1 action)
0.0121920109	startup/seo_url (1 action)
0.0012998581	startup/event (1 action)
0.0004470348	startup/session (1 action)
0.0001308918	startup/error (1 action)
0.0000808239	startup/maintenance (1 action)

0.1609320640	extension/module/uni_new_data (7 action)
0.1173579693	extension/module/uni_auto_related (1 action)
0.0131900311	extension/module/bundles (1 action)
0.0074720383	extension/module/uni_request (1 action)
0.0069570541	extension/module/uni_news_related (1 action)
0.0051372051	extension/advertise/google (2 action)
0.0045948029	extension/module/banner (2 action)
0.0030329227	extension/module/uni_subscribe (1 action)
0.0016651154	extension/module/uni_slideshow_v2 (1 action)
0.0011224746	extension/module/ocfilter (25 action)
0.0010809898	extension/module/uni_notification (1 action)
0.0001139641	extension/module/uni_tool (1 action)
0.0000979900	extension/module/uni_viewed (1 action)

0.3371758461	product/product (1 action)
0.0045890808	product/uni_reviews (1 action)

0.0799300671	common/header (1 action)
0.0271759033	common/menu (1 action)
0.0227930546	common/cart (1 action)
0.0201170444	common/content_bottom (1 action)
0.0200700760	common/footer (1 action)
0.0131719112	common/column_left (2 action)
0.0079731942	common/currency (2 action)
0.0060491562	common/column_right (2 action)
0.0032019615	common/search (1 action)
0.0029311180	common/language (1 action)
0.0028889179	common/content_top (1 action)

0.0576219559	SELECT p.product_id FROM `oc_product` p LEFT JOIN `oc_product_to_category` p2c ON (p.product_id = p2c.product_id) LEFT JOIN `oc_product_to_store` p2s ON (p.product_id = p2s.product_id) WHERE p2c.category_id = '1074' AND p.quantity > '0' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p.product_id > '124349' AND p.product_id != '124349' GROUP BY p.product_id ORDER BY p.product_id ASC LIMIT 5
0.0204980373	UPDATE oc_product SET viewed = (viewed + 1) WHERE product_id = '124349'
0.0132050514	DELETE FROM `oc_session` WHERE `expire` < '2025-12-17 09:14:39'
0.0095291138	SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE (c.parent_id = '0' OR c.category_id IN(SELECT category_id FROM oc_category_parent cpr WHERE cpr.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)
0.0066978931	SELECT p.product_id FROM `oc_product` p LEFT JOIN `oc_product_to_category` p2c ON (p.product_id = p2c.product_id) LEFT JOIN `oc_product_to_store` p2s ON (p.product_id = p2s.product_id) WHERE p2c.category_id = '1092' AND p.quantity > '0' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p.product_id > '124349' AND p.product_id != '124349' GROUP BY p.product_id ORDER BY p.product_id ASC LIMIT 5
0.0056469440	SELECT category_id, parent_id FROM oc_category ORDER BY parent_id
0.0053908825	SELECT * FROM oc_product_option po LEFT JOIN `oc_option` o ON (po.option_id = o.option_id) LEFT JOIN oc_option_description od ON (o.option_id = od.option_id) WHERE po.product_id = '124353' AND od.language_id = '1' ORDER BY o.sort_order
0.0053291321	SELECT * FROM oc_product_option po LEFT JOIN `oc_option` o ON (po.option_id = o.option_id) LEFT JOIN oc_option_description od ON (o.option_id = od.option_id) WHERE po.product_id = '124349' AND od.language_id = '1' ORDER BY o.sort_order
0.0048952103	SELECT * FROM oc_product_option po LEFT JOIN `oc_option` o ON (po.option_id = o.option_id) LEFT JOIN oc_option_description od ON (o.option_id = od.option_id) WHERE po.product_id = '124354' AND od.language_id = '1' ORDER BY o.sort_order
0.0041608810	SELECT * FROM oc_product_option po LEFT JOIN `oc_option` o ON (po.option_id = o.option_id) LEFT JOIN oc_option_description od ON (o.option_id = od.option_id) WHERE po.product_id = '124352' AND od.language_id = '1' ORDER BY o.sort_order
0.0040240288	SELECT * FROM oc_product_option po LEFT JOIN `oc_option` o ON (po.option_id = o.option_id) LEFT JOIN oc_option_description od ON (o.option_id = od.option_id) WHERE po.product_id = '124351' AND od.language_id = '1' ORDER BY o.sort_order
0.0039751530	SELECT * FROM oc_product_option po LEFT JOIN `oc_option` o ON (po.option_id = o.option_id) LEFT JOIN oc_option_description od ON (o.option_id = od.option_id) WHERE po.product_id = '124350' AND od.language_id = '1' ORDER BY o.sort_order
0.0029459000	SELECT * FROM `oc_setting` WHERE store_id = '0' OR store_id = '0' ORDER BY store_id ASC
0.0025811195	SELECT nr.news_id FROM `oc_uni_news_product_related` nr LEFT JOIN `oc_uni_news_story` n ON (nr.news_id = n.news_id) LEFT JOIN `oc_uni_news_story_to_store` n2s ON (n.news_id = n2s.news_id) WHERE nr.product_id = '124349' AND n2s.store_id = '0' AND n.date_added <= NOW() AND n.status = '1' ORDER BY n.date_added DESC LIMIT 20
0.0023241043	SELECT * FROM oc_setting WHERE store_id = '0' AND `code` = 'advertise_google'
0.0022919178	SELECT * FROM oc_setting WHERE store_id = '0' AND `code` = 'advertise_google'
0.0018270016	SHOW TABLES LIKE 'oc_cartkeeper_share'
0.0016372204	SHOW TABLES LIKE 'oc_ocfilter_setting'
0.0015511513	SHOW TABLES LIKE 'oc_cartkeeper'
0.0014779568	SELECT p.product_id FROM `oc_product` p LEFT JOIN `oc_product_to_category` p2c ON (p.product_id = p2c.product_id) LEFT JOIN `oc_product_to_store` p2s ON (p.product_id = p2s.product_id) WHERE p2c.category_id = '3957' AND p.quantity > '0' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p.product_id > '124349' AND p.product_id != '124349' GROUP BY p.product_id ORDER BY p.product_id ASC LIMIT 5
0.0013909340	SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/module/uni_othertext' OR route = 'ru-ru')
0.0013809204	SELECT * FROM oc_information i LEFT JOIN oc_information_description id ON (i.information_id = id.information_id) LEFT JOIN oc_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
0.0013720989	SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/module/uni_news' OR route = 'ru-ru')
0.0012960434	SELECT DISTINCT , pd.name AS name, p.image, p.noindex AS noindex, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT() AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '124350' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
0.0012531281	SELECT DISTINCT * FROM oc_information i LEFT JOIN oc_information_description id ON (i.information_id = id.information_id) LEFT JOIN oc_information_to_store i2s ON (i.information_id = i2s.information_id) WHERE i.information_id = '3' AND id.language_id = '1' AND i2s.store_id = '0' AND i.status = '1'
0.0012190342	SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'common/currency' OR route = 'ru-ru')
0.0012059212	SELECT DISTINCT , pd.name AS name, p.image, p.noindex AS noindex, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT() AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '124351' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
0.0011630058	SELECT * FROM oc_layout_route WHERE 'product/product' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1
0.0010042191	SELECT ag.attribute_group_id, agd.name FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id) LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id) WHERE pa.product_id = '124349' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
0.0009889603	SELECT DISTINCT * FROM oc_information i LEFT JOIN oc_information_description id ON (i.information_id = id.information_id) LEFT JOIN oc_information_to_store i2s ON (i.information_id = i2s.information_id) WHERE i.information_id = '3' AND id.language_id = '1' AND i2s.store_id = '0' AND i.status = '1'
0.0009789467	SELECT DISTINCT , pd.name AS name, p.image, p.noindex AS noindex, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT() AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '124349' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
0.0009739399	SELECT DISTINCT * FROM oc_information i LEFT JOIN oc_information_description id ON (i.information_id = id.information_id) LEFT JOIN oc_information_to_store i2s ON (i.information_id = i2s.information_id) WHERE i.information_id = '3' AND id.language_id = '1' AND i2s.store_id = '0' AND i.status = '1'
0.0009701252	SELECT DISTINCT , pd.name AS name, p.image, p.noindex AS noindex, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT() AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '124352' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
0.0009078979	SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/module/uni_reviews' OR route = 'ru-ru')
0.0008881092	SELECT DISTINCT , pd.name AS name, p.image, p.noindex AS noindex, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT() AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '124353' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
0.0008561611	SELECT DISTINCT , pd.name AS name, p.image, p.noindex AS noindex, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT() AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '124354' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
0.0008490086	SELECT * FROM oc_layout_route WHERE 'product/product' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1
0.0008068085	SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/module/uni_othertext' OR route = 'ru-ru')
0.0007870197	SELECT * FROM oc_banner b LEFT JOIN oc_banner_image bi ON (b.banner_id = bi.banner_id) WHERE b.banner_id = '6' AND b.status = '1' AND bi.language_id = '1' ORDER BY bi.sort_order ASC
0.0007629395	SELECT * FROM oc_layout_route WHERE 'product/product' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1

ЗУБР 1500 Вт, 200 л/мин, 6 л, поршневой, безмасляный, компрессор воздушный КП-200-6 Мастер

Преимущества

Использование

Характеристики

event

startup

extension

product

common