Belüftungsschornsteine

Sonderangebot

Dachfenster VELUX GGU 0068

534,63€ Bruttopreis

Velux GLL 1064B Holzdachfenster mit unterer Bedienung STANDARD PLUS Holz-Schwingdachfenster mit unterer Griffsteuerung GLL 1064 B mit VELUX --64 Verglasung (Niedrigenergie-Dreifachverglasung mit Sicherheitsverbundglas, erhöhte...

345,90€ Bruttopreis

Vorschau Weitere Infos

Velux Dachfenster GLL 1064 Z

Velux GLL 1064 Holz-Dachfenster Innovatives Dachfenster mit Oberbedienung für Energieeffizienz und Komfort. Der neue obere Griff ermöglicht einen einfachen Einbau in verschiedenen Höhen. Sie können einen Tisch oder ein Sofa darunter stellen und...

323,45€ Bruttopreis

Vorschau Weitere Infos

Dachfenster VELUX GLU 0051 Z

VELUX Dachfenster GLU 0051 Das weiße, wartungsfreie STANDARD-Aufsatz-Dachfenster GLU 0051 mit VELUX --51-Verglasung (Zweifach-Isolierglas mit feststehendem Außenglas, Glasbehandlung gegen Regengeräusche, Solargewinnfunktion) kann in Schrägdächer...

295,14€ Bruttopreis

Vorschau Weitere Infos

Alle reduzierten Artikel

Kompatibilta s výrobci a modely krytin

Výrobce

Model

Aussicht  

Lüftungskamin E21 Uniwersal EVO Ø150 mit Kondensatabsaugung

Aussicht  

This eshop uses cookies to provide services, customize your ads, and analyze your traffic. More information.	Accept all cookies Personalize
Necessary cookies Analytical cookies Advertising cookies	Accept selected cookies

Load Time	606.825 ms
Querying Time	341 ms
Queries	1562
Memory Peak Usage	39.0 Mb
Included Files	1011 files - 19.57 Mb
PrestaShop Cache	- Mb
Global vars	0.57 Mb
- global $_MODULES	557k
- global $_SERVER	8k
- global $config	5k
- global $_MODULE	4k
- global $context	3k
- global $__composer_autoload_files	3k
- global $exportPhpConfigFile	3k
- global $_COOKIE	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	21.777 ms	21.777 ms	5.50 Mb	5.8 Mb
__construct	0.019 ms	21.796 ms	- Mb	5.8 Mb
init	43.820 ms	65.616 ms	1.48 Mb	7.1 Mb
checkAccess	0.002 ms	65.618 ms	- Mb	7.1 Mb
setMedia	6.062 ms	71.680 ms	0.60 Mb	7.6 Mb
postProcess	0.002 ms	71.682 ms	- Mb	7.6 Mb
initHeader	0.001 ms	71.683 ms	- Mb	7.6 Mb
initContent	229.987 ms	301.670 ms	11.10 Mb	18.8 Mb
initFooter	0.003 ms	301.673 ms	- Mb	18.8 Mb
display	305.152 ms	606.825 ms	19.48 Mb	39.0 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
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'
61 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
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
16 queries	SELECT * FROM `ps_ets_mm_column` WHERE XX AND id_tab=XX ORDER BY sort_order asc
14 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
14 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
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` = 'de-de' OR `language_code` = 'de-de' 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 XX FROM `ps_specific_price` WHERE id_product = XX LIMIT XX
8 queries	SELECT * FROM `ps_ets_mm_column` WHERE XX AND id_menu=XX ORDER BY sort_order asc
7 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
7 queries	SELECT name FROM ps_category_lang WHERE id_shop = XX AND id_lang = XX AND id_category = XX LIMIT XX
7 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
7 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
7 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)
7 queries	SELECT `id_tax_rules_group` FROM `ps_product_shop` WHERE `id_product` = XX AND id_shop=XX LIMIT XX
7 queries	SELECT `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = XX AND `id_group` = XX LIMIT XX
7 queries	SELECT COUNT(*) FROM `ps_pack` WHERE id_product_pack = XX LIMIT XX
7 queries	SELECT product_type FROM `ps_product` WHERE id_product = XX LIMIT XX
7 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
7 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
7 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
7 queries	SELECT * FROM `ps_product_attribute_lang` WHERE `id_product_attribute` = XX
7 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`
7 queries	SELECT `id_product_attribute` FROM `ps_product_attribute` WHERE `id_product` = XX
7 queries	SELECT TABLE_COLLATION FROM information_schema.TABLES WHERE table_schema = 'mXX_presta' AND table_name = 'ps_dm_label_text' LIMIT XX
7 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
7 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
7 queries	SELECT cp.`id_category` FROM `ps_category_product` cp WHERE cp.`id_product` = XX
7 queries	SELECT `id_feature_value` FROM `ps_feature_product` WHERE `id_product` = XX
7 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;
7 queries	SELECT TABLE_COLLATION FROM information_schema.TABLES WHERE table_schema = 'mXX_presta' AND table_name = 'ps_dm_label' LIMIT XX
7 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
7 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
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
5 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, XX) AND il.`id_lang` = XX ORDER by i.`position`
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, XX, 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, XX, XX, XX))) GROUP BY fp.id_feature_value
3 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
3 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
2 queries	SELECT * FROM `ps_lang` a LEFT JOIN `ps_lang_shop` `c` ON a.`id_lang` = c.`id_lang` AND c.`id_shop` = XX WHERE (a.`id_lang` = XX) LIMIT XX
2 queries	SELECT id_shop FROM `ps_lang_shop` WHERE `id_lang` = XX AND id_shop = XX LIMIT XX
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, XX, 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, XX, XX, XX))) GROUP BY fp.id_feature_value
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 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' BETWEEN tr.`zipcode_from` AND tr.`zipcode_to` OR (tr.`zipcode_to` = XX AND tr.`zipcode_from` IN(XX, 'XX'))) ORDER BY tr.`zipcode_from` DESC, tr.`zipcode_to` DESC, tr.`id_state` DESC, tr.`id_country` DESC
2 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`
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,XX) OR dlat.`id_features` = XX) AND dlat.`only_specific_price` = XX ORDER BY dlat.`position` ASC

Belüftungsschornsteine 7 Artikel gefunden

Taschen aus Blech

Flache Blätter

Trapezbleche

Bituminöse Bedachung

Harte Beläge