Vetranie strechy

Strešné okno Velux GLL 1064 B

Drevené strešné okno Velux GLL 1064B so spodným ovládaním Drevené výklopné strešné okno STANDARD PLUS so spodným ovládaním kľučkou GLL 1064 B so zasklením VELUX --64 (nízkoenergetické trojsklo s bezpečnostným lepeným sklom, zvýšený útlm hluku pri...

345,90 CZK S DPH

Rýchly náhľad More info

Strešné okno Velux GLL 1064 Z

Drevené strešné okno Velux GLL 1064 Inovované strešné okno so špičkovým ovládaním pre energetickú účinnosť a komfort. Nové horné ovládanie umožňuje jednoduchú montáž v rôznych výškach. Umiestnite pod neho stôl alebo pohovku a stále získate...

323,45 CZK S DPH

Rýchly náhľad More info

Strešné okno VELUX GLU 0051 Z

Strešné okno VELUX GLU 0051 Biele bezúdržbové kyvné strešné okno GLU 0051 STANDARD s horným ovládaním a zasklením VELUX --51 (izolačné dvojsklo s pevným vonkajším sklom, úprava skla proti hluku spôsobenému dažďom, funkcia solárnych ziskov). Kyvné...

295,14 CZK S DPH

Rýchly náhľad More info

This eshop uses cookies to provide services, customize your ads, and analyze your traffic. More information.	Prijať všetky súbory cookie Prispôsobiť
Nevyhnutné cookie Analytické cookie Reklamné cookie	Prijať vybrané cookie

Load Time	1804 ms
Querying Time	897 ms
Queries	2100
Memory Peak Usage	49.9 Mb
Included Files	1011 files - 19.72 Mb
PrestaShop Cache	- Mb
Global vars	0.84 Mb
- global $_MODULES	752k
- global $_MODULE	81k
- global $_SERVER	8k
- global $config	5k
- global $context	3k
- global $__composer_autoload_files	3k
- global $exportPhpConfigFile	3k
- global $_COOKIE	2k
- global $smarty	2k

PrestaShop Version	8.1.3
PHP Version	8.2.29
MySQL Version	10.3.39-MariaDB
Memory Limit	4G
Max Execution Time	600000s
Smarty Cache	enabled
Smarty Compilation	auto

	Time	Cumulated Time	Memory Usage	Memory Peak Usage
config	30.437 ms	30.437 ms	5.23 Mb	5.4 Mb
__construct	0.026 ms	30.463 ms	- Mb	5.4 Mb
init	83.173 ms	113.636 ms	1.50 Mb	6.9 Mb
checkAccess	0.003 ms	113.639 ms	- Mb	6.9 Mb
setMedia	6.698 ms	120.337 ms	0.61 Mb	7.3 Mb
postProcess	0.002 ms	120.339 ms	- Mb	7.3 Mb
initHeader	0.002 ms	120.341 ms	- Mb	7.3 Mb
initContent	477.262 ms	597.603 ms	14.77 Mb	22.2 Mb
initFooter	0.003 ms	597.606 ms	- Mb	22.2 Mb
display	1207 ms	1804 ms	26.82 Mb	49.9 Mb

826 queries	SELECT crc.id_cart_rule FROM ps_cart_rule_country crc WHERE crc.id_cart_rule = XX AND crc.id_country = XX LIMIT XX
169 queries	SELECT a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, pa.`reference`, pa.`eanXX`, pa.`isbn`, pa.`upc`, pa.`mpn`, pal.`available_now`, pal.`available_later` FROM `ps_attribute` a LEFT JOIN `ps_attribute_lang` al ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = XX) LEFT JOIN `ps_product_attribute_combination` pac ON (pac.`id_attribute` = a.`id_attribute`) LEFT JOIN `ps_product_attribute` pa ON (pa.`id_product_attribute` = pac.`id_product_attribute`) INNER JOIN ps_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = XX) LEFT JOIN `ps_product_attribute_lang` pal ON (pal.`id_product_attribute` = pac.`id_product_attribute` AND pal.`id_lang` = XX) LEFT JOIN `ps_attribute_group_lang` agl ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = XX) WHERE pa.`id_product` = XX AND pac.`id_product_attribute` = XX AND agl.`id_lang` = XX
112 queries	SELECT b.*,bl.title,bl.title_link,bl.content,bl.image_link,bl.image FROM `ps_ets_mm_block` b LEFT JOIN `ps_ets_mm_block_lang` bl ON b.id_block=bl.id_block AND bl.id_lang=XX WHERE XX AND b.id_column=XX ORDER BY b.sort_order asc
110 queries	SELECT `id_image_type` FROM `ps_image_type` WHERE `name` = 'home'
42 queries	SELECT SUM(quantity) FROM `ps_stock_available` WHERE (id_product = XX) AND (id_product_attribute = XX) AND (id_shop = XX) AND (id_shop_group = XX) LIMIT XX
42 queries	SELECT COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), XX) as deep_quantity, COALESCE(SUM(first_level_quantity), XX) as quantity FROM (SELECT cp.`quantity` as first_level_quantity, XX as pack_quantity FROM `ps_cart_product` cp WHERE cp.`id_product_attribute` = XX AND cp.`id_customization` = XX AND cp.`id_cart` = XX AND cp.`id_product` = XX UNION SELECT XX as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity FROM `ps_cart_product` cp JOIN `ps_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `ps_product` pr ON p.`id_product_pack` = pr.`id_product` WHERE cp.`id_product_attribute` = XX AND cp.`id_customization` = XX AND cp.`id_cart` = XX AND p.`id_product_item` = XX AND (pr.`pack_stock_type` IN (XX,XX) OR ( pr.`pack_stock_type` = XX AND XX = XX ))) as q LIMIT XX
23 queries	SELECT * FROM `ps_category` a LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = XX LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = XX WHERE (a.`id_category` = XX) AND (b.`id_shop` = XX) LIMIT XX
22 queries	SELECT XX FROM `ps_specific_price` WHERE id_product = XX LIMIT XX
21 queries	SELECT image_shop.`id_image` FROM `ps_image` i INNER JOIN ps_image_shop image_shop ON (image_shop.id_image = i.id_image AND image_shop.id_shop = XX) WHERE i.`id_product` = XX AND image_shop.`cover` = XX LIMIT XX
21 queries	SELECT name FROM ps_category_lang WHERE id_shop = XX AND id_lang = XX AND id_category = XX LIMIT XX
21 queries	SELECT * FROM `ps_product` a LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = XX LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = XX WHERE (a.`id_product` = XX) AND (b.`id_shop` = XX) LIMIT XX
21 queries	SELECT product_attribute_shop.`price` FROM `ps_product_attribute` pa INNER JOIN ps_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = XX) WHERE pa.`id_product_attribute` = XX LIMIT XX
21 queries	SELECT product_shop.`price`, product_shop.`ecotax`, IFNULL(product_attribute_shop.id_product_attribute,XX) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on, product_attribute_shop.`ecotax` AS attribute_ecotax FROM `ps_product` p INNER JOIN `ps_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = XX) LEFT JOIN `ps_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = XX) WHERE (p.`id_product` = XX)
21 queries	SELECT `id_tax_rules_group` FROM `ps_product_shop` WHERE `id_product` = XX AND id_shop=XX LIMIT XX
21 queries	SELECT `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = XX AND `id_group` = XX LIMIT XX
21 queries	SELECT COUNT(*) FROM `ps_pack` WHERE id_product_pack = XX LIMIT XX
21 queries	SELECT product_type FROM `ps_product` WHERE id_product = XX LIMIT XX
21 queries	SELECT pa.`available_date` FROM `ps_product` p LEFT JOIN `ps_product_attribute` pa ON (pa.`id_product` = p.`id_product`) INNER JOIN ps_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = XX) INNER JOIN ps_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = XX) WHERE p.`id_product` = XX AND pa.`id_product` = XX AND pa.`id_product_attribute` = XX LIMIT XX
21 queries	SELECT name, value, pf.id_feature, f.position, fvl.id_feature_value FROM ps_feature_product pf LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = XX) LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = XX) LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = XX) INNER JOIN ps_feature_shop feature_shop ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = XX) WHERE pf.id_product = XX ORDER BY f.position ASC
21 queries	SELECT * FROM `ps_product_attribute` a LEFT JOIN `ps_product_attribute_shop` `c` ON a.`id_product_attribute` = c.`id_product_attribute` AND c.`id_shop` = XX WHERE (a.`id_product_attribute` = XX) LIMIT XX
21 queries	SELECT * FROM `ps_product_attribute_lang` WHERE `id_product_attribute` = XX
21 queries	SELECT image_shop.`cover`, i.`id_image`, il.`legend`, i.`position` FROM `ps_image` i INNER JOIN ps_image_shop image_shop ON (image_shop.id_image = i.id_image AND image_shop.id_shop = XX) LEFT JOIN `ps_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = XX) WHERE i.`id_product` = XX ORDER BY `position`
21 queries	SELECT `id_product_attribute` FROM `ps_product_attribute` WHERE `id_product` = XX
21 queries	SELECT TABLE_COLLATION FROM information_schema.TABLES WHERE table_schema = 'mXX_presta' AND table_name = 'ps_dm_label_text' LIMIT XX
21 queries	SELECT t.`name`, dl.`tag_public_name`, dl.`tag_color`, dl.`id_label_text` FROM ps_tag t LEFT JOIN ps_product_tag pt ON (pt.id_tag = t.id_tag) LEFT JOIN ps_dm_label_text dl ON (t.name = dl.tag_original_name COLLATE utfXX_general_ci AND t.id_lang = dl.id_tag_lang) WHERE pt.`id_product` = XX AND t.`id_lang` = XX AND dl.`id_store` = XX AND dl.`tag_original_name` != '' AND dl.`allowed_position` LIKE '%product-list%' AND dl.`active` = XX AND (dl.`date_from` = 'XX-XX-XX XX:XX:XX' OR 'XX-XX-XX XX:XX:XX' >= dl.`date_from`) AND (dl.`date_to` = 'XX-XX-XX XX:XX:XX' OR 'XX-XX-XX XX:XX:XX' <= dl.`date_to`) ORDER BY dl.`position` ASC
21 queries	SELECT p.`id_supplier`, p.`id_manufacturer`, ps.`id_category_default` FROM `ps_product` p LEFT JOIN `ps_product_shop` ps ON (p.`id_product` = ps.`id_product` AND ps.`id_shop` = XX) WHERE p.`id_product` = XX LIMIT XX
21 queries	SELECT cp.`id_category` FROM `ps_category_product` cp WHERE cp.`id_product` = XX
21 queries	SELECT `id_feature_value` FROM `ps_feature_product` WHERE `id_product` = XX
21 queries	SELECT pa.`id_product`, a.`color`, pac.`id_product_attribute`, XX qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by FROM `ps_product_attribute` pa INNER JOIN ps_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = XX) JOIN `ps_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`) JOIN `ps_attribute` a ON (a.`id_attribute` = pac.`id_attribute`) JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = XX) JOIN `ps_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`) WHERE pa.`id_product` IN (XX) AND ag.`is_color_group` = XX GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` ORDER BY a.`position` ASC;
21 queries	SELECT TABLE_COLLATION FROM information_schema.TABLES WHERE table_schema = 'mXX_presta' AND table_name = 'ps_dm_label' LIMIT XX
21 queries	SELECT t.`name`, dl.`tag_text`, dl.`tag_color`, dl.`id_label`, dl.`tag_url`, dl.`tag_target_url`, dl.`position` FROM ps_tag t LEFT JOIN ps_product_tag pt ON (pt.id_tag = t.id_tag) LEFT JOIN ps_dm_label dl ON (t.name = dl.tag_original_name COLLATE utfXX_general_ci AND t.id_lang = dl.id_tag_lang) WHERE pt.`id_product` = XX AND dl.`active` = XX AND t.`id_lang` = XX AND dl.`id_store` = XX AND dl.`tag_original_name` != '' AND dl.`allowed_position` LIKE '%product-list%' AND (dl.`date_from` = 'XX-XX-XX XX:XX:XX' OR 'XX-XX-XX XX:XX:XX' >= dl.`date_from`) AND (dl.`date_to` = 'XX-XX-XX XX:XX:XX' OR 'XX-XX-XX XX:XX:XX' <= dl.`date_to`) ORDER BY dl.`position` ASC
21 queries	SELECT al.`name` AS attribute_name FROM `ps_product_attribute_combination` pac LEFT JOIN `ps_attribute` a ON a.`id_attribute` = pac.`id_attribute` LEFT JOIN `ps_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group` LEFT JOIN `ps_attribute_lang` al ON ( a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = XX ) WHERE pac.`id_product_attribute` = XX ORDER BY ag.`position` ASC, a.`position` ASC
20 queries	SELECT pai.`id_image`, pai.`id_product_attribute`, il.`legend` FROM `ps_product_attribute_image` pai LEFT JOIN `ps_image_lang` il ON (il.`id_image` = pai.`id_image`) LEFT JOIN `ps_image` i ON (i.`id_image` = pai.`id_image`) WHERE pai.`id_product_attribute` IN (XX, XX, XX, XX, XX, XX, XX, XX) AND il.`id_lang` = XX ORDER by i.`position`
18 queries	SELECT dlat.`tag_name`, dlat.`tag_color` FROM `ps_dm_label_auto_text` dlat WHERE dlat.`id_store` = XX AND dlat.`id_tag_lang` = XX AND dlat.`allowed_position` LIKE '%product-list%' AND dlat.`price_from` <= XX.XX AND dlat.`price_to` >= XX.XX AND dlat.`qty_from` <= XX AND dlat.`qty_to` >= XX AND dlat.`active` = XX AND (dlat.`date_from` = 'XX-XX-XX XX:XX:XX' OR 'XX-XX-XX XX:XX:XX' >= dlat.`date_from`) AND (dlat.`date_to` = 'XX-XX-XX XX:XX:XX' OR 'XX-XX-XX XX:XX:XX' <= dlat.`date_to`) AND (FIND_IN_SET(XX, dlat.`categories_filtr`) OR dlat.`categories_filtr` = '' OR FIND_IN_SET(XX, dlat.`categories_filtr`) OR FIND_IN_SET(XX, dlat.`categories_filtr`) OR FIND_IN_SET(XX, dlat.`categories_filtr`)) AND (FIND_IN_SET(XX, dlat.`manufacturer_filtr`) OR dlat.`manufacturer_filtr` = '') AND (FIND_IN_SET(XX, dlat.`supplier_filtr`) OR dlat.`supplier_filtr` = '') AND (dlat.`id_features` IN (XX,XX,XX,XX) OR dlat.`id_features` = XX) AND dlat.`only_specific_price` = XX ORDER BY dlat.`position` ASC
16 queries	SELECT * FROM `ps_ets_mm_column` WHERE XX AND id_tab=XX ORDER BY sort_order asc
13 queries	SELECT `id_module` FROM `ps_module_shop` WHERE `id_module` = XX AND `id_shop` = XX LIMIT XX
10 queries	SELECT `id_lang` FROM `ps_lang` WHERE `locale` = 'sk-sk' OR `language_code` = 'sk-sk' LIMIT XX
10 queries	SELECT hbl.html,hb.style,hbl.id_lang FROM `ps_ets_hb_html_box` hb LEFT JOIN `ps_ets_hb_html_box_lang` hbl ON (hb.`id_ets_hb_html_box` = hbl.`id_ets_hb_html_box` AND hbl.`id_lang` = XX) JOIN `ps_ets_hb_html_box_position` hbp ON (hbp.`id_ets_hb_html_box` = hb.`id_ets_hb_html_box`) WHERE hb.active = XX AND hbp.`position` = XX
8 queries	SELECT * FROM `ps_ets_mm_column` WHERE XX AND id_menu=XX ORDER BY sort_order asc
6 queries	SELECT * FROM `ps_ets_mm_tab` t LEFT JOIN `ps_ets_mm_tab_lang` tl on (t.id_tab=tl.id_tab AND tl.id_lang=XX) WHERE XX AND id_menu=XX ORDER BY sort_order asc
5 queries	SELECT * FROM `ps_currency` a LEFT JOIN `ps_currency_lang` `b` ON a.`id_currency` = b.`id_currency` AND b.`id_lang` = XX LEFT JOIN `ps_currency_shop` `c` ON a.`id_currency` = c.`id_currency` AND c.`id_shop` = XX WHERE (a.`id_currency` = XX) LIMIT XX
5 queries	SELECT * FROM ps_hook_module WHERE `id_hook` = XX AND `id_module` = XX AND `id_shop` = XX
5 queries	SELECT v., vl., IF(lifvlv.`url_name` IS NULL OR lifvlv.`url_name` = "", NULL, lifvlv.`url_name`) AS url_name, IF(lifvlv.`meta_title` IS NULL OR lifvlv.`meta_title` = "", NULL, lifvlv.`meta_title`) AS meta_title FROM `ps_feature_value` v LEFT JOIN `ps_feature_value_lang` vl ON (v.`id_feature_value` = vl.`id_feature_value` AND vl.`id_lang` = XX) LEFT JOIN `ps_layered_indexable_feature_value_lang_value` lifvlv ON (v.`id_feature_value` = lifvlv.`id_feature_value` AND lifvlv.`id_lang` = XX) WHERE v.`id_feature` = XX ORDER BY vl.`value` ASC
4 queries	SELECT id_lang FROM `ps_lang` WHERE is_rtl=XX AND active=XX LIMIT XX
3 queries	SELECT m.`id_module`, m.`name`, ms.`id_module`as `mshop` FROM `ps_module` m LEFT JOIN `ps_module_shop` ms ON m.`id_module` = ms.`id_module` AND ms.`id_shop` = XX
3 queries	SELECT `need_identification_number` FROM `ps_country` WHERE `id_country` = XX LIMIT XX
3 queries	SELECT fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, pa.id_product_attribute FROM ps_product p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, XX) = sa.id_product_attribute AND sa.id_shop = XX AND sa.id_shop_group = XX ) LEFT JOIN ps_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = XX AND ps.active = TRUE) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=XX) LEFT JOIN ps_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN ps_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN ps_feature_product fp_XX ON (p.id_product = fp_XX.id_product) LEFT JOIN ps_product_attribute_combination pac_XX ON (pa.id_product_attribute = pac_XX.id_product_attribute) WHERE ((fp.id_feature_value=XX)) AND ((fp_XX.id_feature_value=XX)) AND ((pac_XX.id_attribute IN (XX, XX))) AND ps.id_shop='XX' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='XX' AND c.nleft>=XX AND c.nright<=XX GROUP BY p.id_product) p INNER JOIN ps_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN ps_feature_product fp_XX ON (p.id_product = fp_XX.id_product) LEFT JOIN ps_feature_product fp_XX ON (p.id_product = fp_XX.id_product) LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac_XX ON (pa.id_product_attribute = pac_XX.id_product_attribute) WHERE ((fp.id_feature=XX)) AND ((fp_XX.id_feature_value=XX)) AND ((fp_XX.id_feature_value=XX)) AND ((pac_XX.id_attribute IN (XX, XX))) GROUP BY fp.id_feature_value
2 queries	SELECT XX FROM `ps_cart_rule` WHERE ((date_to >= "XX-XX-XX XX:XX:XX" AND date_to <= "XX-XX-XX XX:XX:XX") OR (date_from >= "XX-XX-XX XX:XX:XX" AND date_from <= "XX-XX-XX XX:XX:XX") OR (date_from < "XX-XX-XX XX:XX:XX" AND date_to > "XX-XX-XX XX:XX:XX")) AND `id_customer` IN (XX,XX) LIMIT XX
2 queries	SELECT COUNT(*) FROM `ps_orders` o LEFT JOIN `ps_order_cart_rule` ocr ON (ocr.`id_order` = o.`id_order`) WHERE o.`id_customer` = XX AND ocr.`deleted` = XX AND ocr.`id_cart_rule` = XX LIMIT XX
2 queries	SELECT `id_country` FROM `ps_address` WHERE `id_customer` = XX AND `deleted` = XX
2 queries	SELECT id_block FROM `ps_ets_mm_block` WHERE enabled=XX AND show_clock=XX AND block_type="PRODUCT" LIMIT XX
2 queries	SELECT fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, pa.id_product_attribute FROM ps_product p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, XX) = sa.id_product_attribute AND sa.id_shop = XX AND sa.id_shop_group = XX ) LEFT JOIN ps_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = XX AND ps.active = TRUE) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=XX) LEFT JOIN ps_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN ps_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN ps_product_attribute_combination pac_XX ON (pa.id_product_attribute = pac_XX.id_product_attribute) WHERE ((fp.id_feature_value=XX)) AND ((pac_XX.id_attribute IN (XX, XX))) AND ps.id_shop='XX' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='XX' AND c.nleft>=XX AND c.nright<=XX GROUP BY p.id_product) p INNER JOIN ps_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN ps_feature_product fp_XX ON (p.id_product = fp_XX.id_product) LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac_XX ON (pa.id_product_attribute = pac_XX.id_product_attribute) WHERE ((fp.id_feature=XX)) AND ((fp_XX.id_feature_value=XX)) AND ((pac_XX.id_attribute IN (XX, XX))) GROUP BY fp.id_feature_value
2 queries	SELECT cl.`link_rewrite` FROM `ps_category_lang` cl WHERE `id_lang` = XX AND cl.id_shop = XX AND cl.`id_category` = XX LIMIT XX
2 queries	SELECT tr.* FROM `ps_tax_rule` tr JOIN `ps_tax_rules_group` trg ON (tr.`id_tax_rules_group` = trg.`id_tax_rules_group`) WHERE trg.`active` = XX AND tr.`id_country` = XX AND tr.`id_tax_rules_group` = XX AND tr.`id_state` IN (XX, XX) AND ('XX XX' BETWEEN tr.`zipcode_from` AND tr.`zipcode_to` OR (tr.`zipcode_to` = XX AND tr.`zipcode_from` IN(XX, 'XX XX'))) ORDER BY tr.`zipcode_from` DESC, tr.`zipcode_to` DESC, tr.`id_state` DESC, tr.`id_country` DESC
2 queries	SELECT m.*,ml.title,ml.link,ml.bubble_text FROM `ps_ets_mm_menu` m INNER JOIN `ps_ets_mm_menu_shop` ms ON (m.id_menu =ms.id_menu AND ms.id_shop='XX') LEFT JOIN `ps_ets_mm_menu_lang` ml ON m.id_menu=ml.id_menu AND ml.id_lang=XX WHERE XX AND m.enabled=XX ORDER BY m.sort_order asc
2 queries	SELECT dlat.`tag_name`, dlat.`tag_color` FROM `ps_dm_label_auto_text` dlat WHERE dlat.`id_store` = XX AND dlat.`id_tag_lang` = XX AND dlat.`allowed_position` LIKE '%product-list%' AND dlat.`price_from` <= XX.XX AND dlat.`price_to` >= XX.XX AND dlat.`qty_from` <= XX AND dlat.`qty_to` >= XX AND dlat.`active` = XX AND (dlat.`date_from` = 'XX-XX-XX XX:XX:XX' OR 'XX-XX-XX XX:XX:XX' >= dlat.`date_from`) AND (dlat.`date_to` = 'XX-XX-XX XX:XX:XX' OR 'XX-XX-XX XX:XX:XX' <= dlat.`date_to`) AND (FIND_IN_SET(XX, dlat.`categories_filtr`) OR dlat.`categories_filtr` = '' OR FIND_IN_SET(XX, dlat.`categories_filtr`) OR FIND_IN_SET(XX, dlat.`categories_filtr`) OR FIND_IN_SET(XX, dlat.`categories_filtr`) OR FIND_IN_SET(XX, dlat.`categories_filtr`)) AND (FIND_IN_SET(XX, dlat.`manufacturer_filtr`) OR dlat.`manufacturer_filtr` = '') AND (FIND_IN_SET(XX, dlat.`supplier_filtr`) OR dlat.`supplier_filtr` = '') AND (dlat.`id_features` IN (XX,XX,XX) OR dlat.`id_features` = XX) AND dlat.`only_specific_price` = XX ORDER BY dlat.`position` ASC

Vetranie strechy Počet produktov: 21

Odvetrávacie komíny

Hybridné rotačné komínové hlavice

Anténne prestupy

Prestupy pre solárne panely a fotovoltiku

Strešné odvetrávače

Ostatné produkty