Art

Framed poster and vector images, all you need to give personality to your walls or bring your creative projects to life.

There are 3 products.

Sort by:

Showing 1-3 of 3 item(s)

Quick view

The best is yet to come'...

$56.97

Quick view

The adventure begins Framed...

$56.97

Quick view

Today is a good day Framed...

$56.97

Load Time	932 ms
Querying Time	138 ms
Queries	226
Memory Peak Usage	48.5 Mb
Included Files	1061 files - 12.79 Mb
PrestaShop Cache	- Mb
Global vars	0.14 Mb
- global $_MODULES	93k
- global $_SERVER	13k
- global $_ENV	12k
- global $__composer_autoload_files	5k
- global $config	5k
- global $context	3k
- global $smarty	3k
- global $exportPhpConfigFile	3k
- global $_MODULE	3k
- global $_COOKIE	1k
- global $_REQUEST	1k

PrestaShop Version	9.0.3
PHP Version	8.4.18
MySQL Version	10.11.15-MariaDB-log
Memory Limit	-1
Max Execution Time	50000s
Smarty Cache	enabled
Smarty Compilation	never recompile

	Time	Cumulated Time	Memory Usage	Memory Peak Usage
config	240.548 ms	240.548 ms	22.90 Mb	23.9 Mb
__construct	0.096 ms	240.644 ms	- Mb	23.9 Mb
init	50.079 ms	290.723 ms	3.26 Mb	26.2 Mb
checkAccess	0.002 ms	290.725 ms	- Mb	26.2 Mb
setMedia	55.180 ms	345.905 ms	3.67 Mb	29.9 Mb
postProcess	0.002 ms	345.907 ms	- Mb	29.9 Mb
initHeader	0.003 ms	345.910 ms	- Mb	29.9 Mb
initContent	280.137 ms	626.047 ms	9.74 Mb	39.6 Mb
initFooter	0.003 ms	626.050 ms	- Mb	39.6 Mb
display	306.115 ms	932 ms	8.07 Mb	48.5 Mb

Hook	Time	Memory Usage
DisplayHeader	63.809 ms	3.98 Mb
=> ps_shoppingcart	0.089 ms	- Mb
=> ps_searchbar	0.525 ms	0.01 Mb
=> ps_imageslider	0.140 ms	- Mb
=> productcomments	0.168 ms	- Mb
=> ps_facebook	35.346 ms	0.97 Mb
=> psshipping	19.672 ms	1.64 Mb
=> ps_googleanalytics	0.255 ms	0.01 Mb
=> psxmarketingwithgoogle	7.615 ms	1.35 Mb
displayProductListReviews	40.513 ms	2.03 Mb
=> productcomments (widget)	37.097 ms	2.03 Mb
=> productcomments (widget)	1.347 ms	- Mb
=> productcomments (widget)	2.069 ms	- Mb
ActionFrontControllerSetMedia	40.284 ms	2.67 Mb
=> blockreassurance	0.904 ms	0.07 Mb
=> blockwishlist	0.353 ms	- Mb
=> ps_emailsubscription	0.097 ms	- Mb
=> ps_socialfollow	0.063 ms	- Mb
=> ps_facebook	0.184 ms	- Mb
=> ps_emailalerts	0.057 ms	- Mb
=> ps_checkout	38.626 ms	2.60 Mb
DisplayBeforeBodyClosingTag	13.541 ms	0.36 Mb
=> statsdata	6.305 ms	0.09 Mb
=> ps_googleanalytics	7.236 ms	0.27 Mb
displayNav2	11.324 ms	0.36 Mb
=> ps_languageselector (widget)	3.791 ms	0.06 Mb
=> ps_currencyselector (widget)	5.280 ms	0.16 Mb
=> ps_customersignin (widget)	0.908 ms	0.05 Mb
=> ps_shoppingcart (widget)	1.345 ms	0.08 Mb
displayLeftColumn	7.670 ms	0.33 Mb
=> ps_categorytree (widget)	3.751 ms	0.19 Mb
=> ps_supplierlist (widget)	0.424 ms	0.03 Mb
=> ps_brandlist (widget)	3.495 ms	0.10 Mb
displayNav1	6.078 ms	0.07 Mb
=> ps_contactinfo (widget)	6.078 ms	0.07 Mb
displayFooter	3.586 ms	0.19 Mb
=> ps_linklist (widget)	1.149 ms	0.07 Mb
=> ps_customeraccountlinks (widget)	0.934 ms	0.07 Mb
=> ps_contactinfo (widget)	1.503 ms	0.05 Mb
ProductSearchProvider	3.413 ms	0.16 Mb
=> ps_facetedsearch	3.413 ms	0.16 Mb
DisplayFooter	2.330 ms	0.12 Mb
=> blockwishlist	2.076 ms	0.11 Mb
=> ps_facebook	0.254 ms	0.01 Mb
displayFooterBefore	2.145 ms	0.12 Mb
=> ps_emailsubscription (widget)	1.156 ms	0.06 Mb
=> ps_socialfollow (widget)	0.989 ms	0.06 Mb
displayTop	2.080 ms	0.13 Mb
=> ps_mainmenu (widget)	1.292 ms	0.08 Mb
=> ps_searchbar (widget)	0.788 ms	0.05 Mb
DisplayLeftColumn	0.360 ms	0.01 Mb
=> ps_facetedsearch	0.360 ms	0.01 Mb
DisplayTop	0.084 ms	- Mb
=> pagesnotfound	0.075 ms	- Mb
=> psxmarketingwithgoogle	0.009 ms	- Mb
DisplayAfterBodyOpeningTag	0.009 ms	- Mb
=> blockreassurance	0.009 ms	- Mb
DisplayFooterAfter	0.008 ms	- Mb
=> blockreassurance	0.008 ms	- Mb
DisplayFooterBefore	0.008 ms	- Mb
=> blockreassurance	0.008 ms	- Mb
DisplayNavFullWidth	0.007 ms	- Mb
=> blockreassurance	0.007 ms	- Mb
ModuleRoutes	0.006 ms	- Mb
=> ps_checkout	0.006 ms	- Mb
19 hook(s)	197.255 ms	10.53 Mb

Module	Time	Memory Usage
ps_checkout	62.667 ms	5.68 Mb
__construct	24.020 ms	3.08 Mb
hookModuleRoutes	0.014 ms	- Mb
hookActionFrontControllerSetMedia	38.633 ms	2.60 Mb
blockreassurance	2.800 ms	0.22 Mb
__construct	1.842 ms	0.14 Mb
hookActionFrontControllerSetMedia	0.911 ms	0.07 Mb
hookDisplayAfterBodyOpeningTag	0.015 ms	- Mb
hookDisplayNavFullWidth	0.009 ms	- Mb
hookDisplayFooterBefore	0.012 ms	- Mb
hookDisplayFooterAfter	0.011 ms	- Mb
blockwishlist	3.032 ms	0.18 Mb
__construct	0.591 ms	0.06 Mb
hookActionFrontControllerSetMedia	0.357 ms	- Mb
hookDisplayFooter	2.084 ms	0.12 Mb
ps_emailsubscription	4.353 ms	0.34 Mb
__construct	3.088 ms	0.28 Mb
hookActionFrontControllerSetMedia	0.102 ms	- Mb
displayFooterBefore	1.163 ms	0.06 Mb
ps_socialfollow	1.882 ms	0.12 Mb
__construct	0.822 ms	0.06 Mb
hookActionFrontControllerSetMedia	0.066 ms	- Mb
displayFooterBefore	0.994 ms	0.06 Mb
ps_facebook	39.060 ms	1.16 Mb
__construct	3.259 ms	0.19 Mb
hookActionFrontControllerSetMedia	0.190 ms	- Mb
hookDisplayHeader	35.353 ms	0.97 Mb
hookDisplayFooter	0.258 ms	0.01 Mb
ps_emailalerts	3.651 ms	0.24 Mb
__construct	3.588 ms	0.24 Mb
hookActionFrontControllerSetMedia	0.063 ms	- Mb
ps_accounts	2.333 ms	0.20 Mb
__construct	2.333 ms	0.20 Mb
ps_shoppingcart	2.221 ms	0.13 Mb
__construct	0.778 ms	0.04 Mb
hookDisplayHeader	0.095 ms	- Mb
displayNav2	1.348 ms	0.08 Mb
ps_searchbar	1.694 ms	0.08 Mb
__construct	0.373 ms	0.03 Mb
hookDisplayHeader	0.530 ms	0.01 Mb
displayTop	0.791 ms	0.05 Mb
ps_imageslider	3.251 ms	0.21 Mb
__construct	3.105 ms	0.21 Mb
hookDisplayHeader	0.146 ms	- Mb
productcomments	43.626 ms	2.22 Mb
__construct	2.920 ms	0.18 Mb
hookDisplayHeader	0.173 ms	- Mb
displayProductListReviews	37.103 ms	2.03 Mb
displayProductListReviews	1.353 ms	- Mb
displayProductListReviews	2.077 ms	- Mb
psshipping	21.124 ms	1.81 Mb
__construct	1.445 ms	0.17 Mb
hookDisplayHeader	19.679 ms	1.64 Mb
ps_googleanalytics	8.144 ms	0.33 Mb
__construct	0.641 ms	0.05 Mb
hookDisplayHeader	0.259 ms	0.01 Mb
hookDisplayBeforeBodyClosingTag	7.244 ms	0.27 Mb
psxmarketingwithgoogle	8.371 ms	1.40 Mb
__construct	0.737 ms	0.05 Mb
hookDisplayHeader	7.624 ms	1.35 Mb
hookDisplayTop	0.010 ms	- Mb
ps_facetedsearch	9.623 ms	0.62 Mb
__construct	5.836 ms	0.44 Mb
hookProductSearchProvider	3.421 ms	0.17 Mb
hookDisplayLeftColumn	0.366 ms	0.01 Mb
ps_contactinfo	8.175 ms	0.17 Mb
__construct	0.582 ms	0.04 Mb
displayNav1	6.085 ms	0.07 Mb
displayFooter	1.508 ms	0.05 Mb
ps_languageselector	4.193 ms	0.09 Mb
__construct	0.395 ms	0.02 Mb
displayNav2	3.798 ms	0.06 Mb
ps_currencyselector	6.056 ms	0.18 Mb
__construct	0.770 ms	0.03 Mb
displayNav2	5.286 ms	0.16 Mb
ps_customersignin	1.257 ms	0.08 Mb
__construct	0.346 ms	0.02 Mb
displayNav2	0.911 ms	0.05 Mb
ps_mainmenu	4.975 ms	0.34 Mb
__construct	3.677 ms	0.26 Mb
displayTop	1.298 ms	0.08 Mb
pagesnotfound	0.683 ms	0.05 Mb
__construct	0.603 ms	0.05 Mb
hookDisplayTop	0.080 ms	- Mb
ps_categorytree	4.526 ms	0.25 Mb
__construct	0.770 ms	0.06 Mb
displayLeftColumn	3.756 ms	0.19 Mb
ps_supplierlist	1.082 ms	0.08 Mb
__construct	0.655 ms	0.04 Mb
displayLeftColumn	0.427 ms	0.03 Mb
ps_brandlist	4.108 ms	0.15 Mb
__construct	0.607 ms	0.04 Mb
displayLeftColumn	3.501 ms	0.11 Mb
ps_linklist	13.302 ms	1.93 Mb
__construct	12.146 ms	1.86 Mb
displayFooter	1.156 ms	0.07 Mb
ps_customeraccountlinks	1.434 ms	0.10 Mb
__construct	0.494 ms	0.03 Mb
displayFooter	0.940 ms	0.07 Mb
statsdata	7.061 ms	0.14 Mb
__construct	0.749 ms	0.05 Mb
hookDisplayBeforeBodyClosingTag	6.312 ms	0.09 Mb
28 module(s)	274.684 ms	18.49 Mb

Art

The best is yet to come'...

The adventure begins Framed...

Today is a good day Framed...

Stopwatch SQL - 226 queries

Doubles

Tables stress

ObjectModel instances

Included Files

16 queries	SELECT `id_module` FROM `dfdu_module_shop` WHERE `id_module` = XX AND `id_shop` = XX LIMIT XX
12 queries	SELECT SUM(quantity) FROM `dfdu_stock_available` WHERE (id_product = XX) AND (id_product_attribute = XX) AND (id_shop = XX) AND (id_shop_group = XX) LIMIT XX
6 queries	SELECT COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), XX) as deep_quantity, COALESCE(SUM(first_level_quantity), XX) as quantity FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, XX as pack_quantity FROM `dfdu_cart_product` cp WHERE cp.`id_product_attribute` = XX AND cp.`id_cart` = XX AND cp.`id_product` = XX UNION SELECT XX as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity FROM `dfdu_cart_product` cp JOIN `dfdu_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `dfdu_product` pr ON p.`id_product_pack` = pr.`id_product` WHERE cp.`id_product_attribute` = 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
5 queries	SELECT DISTINCT a.`id_attribute`, a.`color`, al.`name`, agl.`id_attribute_group`, IF(lialv.`url_name` IS NULL OR lialv.`url_name` = "", NULL, lialv.`url_name`) AS url_name, IF(lialv.`meta_title` IS NULL OR lialv.`meta_title` = "", NULL, lialv.`meta_title`) AS meta_title FROM `dfdu_attribute_group` ag INNER JOIN `dfdu_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = XX) INNER JOIN `dfdu_attribute` a ON a.`id_attribute_group` = ag.`id_attribute_group` INNER JOIN `dfdu_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = XX) INNER JOIN dfdu_attribute_group_shop attribute_group_shop ON (attribute_group_shop.id_attribute_group = ag.id_attribute_group AND attribute_group_shop.id_shop = XX) INNER JOIN dfdu_attribute_shop attribute_shop ON (attribute_shop.id_attribute = a.id_attribute AND attribute_shop.id_shop = XX) LEFT JOIN `dfdu_layered_indexable_attribute_lang_value` lialv ON (a.`id_attribute` = lialv.`id_attribute` AND lialv.`id_lang` = XX) WHERE ag.id_attribute_group = XX ORDER BY agl.`name` ASC, a.`position` ASC
4 queries	SELECT `id_lang` FROM `dfdu_lang` WHERE `locale` = 'en-us' OR `language_code` = 'en-us' LIMIT XX
4 queries	SELECT XX FROM `dfdu_specific_price` WHERE id_product = XX LIMIT XX
3 queries	SELECT * FROM `dfdu_category` a LEFT JOIN `dfdu_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = XX LEFT JOIN `dfdu_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
3 queries	SELECT `need_identification_number` FROM `dfdu_country` WHERE `id_country` = XX LIMIT XX
3 queries	SELECT pac.id_attribute, 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, cp.position FROM dfdu_product p LEFT JOIN dfdu_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN dfdu_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN dfdu_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 dfdu_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN dfdu_category_product cp ON (p.id_product = cp.id_product) INNER JOIN dfdu_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = XX AND ps.active = TRUE) INNER JOIN dfdu_category c ON (cp.id_category = c.id_category AND c.active=XX) LEFT JOIN dfdu_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN dfdu_feature_product fp_XX ON (p.id_product = fp_XX.id_product) LEFT JOIN dfdu_product_attribute_combination pac_XX ON (pa.id_product_attribute = pac_XX.id_product_attribute) WHERE ((sa.quantity>XX)) AND ((fp_XX.id_feature_value=XX)) AND ((pac_XX.id_attribute IN (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 LEFT JOIN dfdu_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN dfdu_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) INNER JOIN dfdu_attribute a ON (a.id_attribute = pac.id_attribute) LEFT JOIN dfdu_stock_available sa_XX ON (p.id_product = sa_XX.id_product AND IFNULL(pac.id_product_attribute, XX) = sa_XX.id_product_attribute AND sa_XX.id_shop = XX AND sa_XX.id_shop_group = XX ) LEFT JOIN dfdu_feature_product fp_XX ON (p.id_product = fp_XX.id_product) LEFT JOIN dfdu_product_attribute_combination pac_XX ON (pa.id_product_attribute = pac_XX.id_product_attribute) WHERE ((a.id_attribute_group=XX)) AND ((sa_XX.quantity>XX)) AND ((fp_XX.id_feature_value=XX)) AND ((pac_XX.id_attribute IN (XX, XX, XX))) GROUP BY pac.id_attribute
3 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 `dfdu_product` p INNER JOIN `dfdu_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = XX) LEFT JOIN `dfdu_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)
3 queries	SELECT tr.* FROM `dfdu_tax_rule` tr JOIN `dfdu_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
3 queries	SELECT `reduction` FROM `dfdu_product_group_reduction_cache` WHERE `id_product` = XX AND `id_group` = XX LIMIT XX
3 queries	SELECT pa.`available_date` FROM `dfdu_product` p LEFT JOIN `dfdu_product_attribute` pa ON (pa.`id_product` = p.`id_product`) INNER JOIN dfdu_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = XX) INNER JOIN dfdu_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
3 queries	SELECT a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, agl.`public_name` as `public_group`, pa.`reference`, pa.`eanXX`, pa.`isbn`, pa.`upc`, pa.`mpn`, pal.`available_now`, pal.`available_later` FROM `dfdu_attribute` a LEFT JOIN `dfdu_attribute_lang` al ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = XX) LEFT JOIN `dfdu_product_attribute_combination` pac ON (pac.`id_attribute` = a.`id_attribute`) LEFT JOIN `dfdu_product_attribute` pa ON (pa.`id_product_attribute` = pac.`id_product_attribute`) INNER JOIN dfdu_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 `dfdu_product_attribute_lang` pal ON (pal.`id_product_attribute` = pac.`id_product_attribute` AND pal.`id_lang` = XX) LEFT JOIN `dfdu_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
3 queries	SELECT * FROM `dfdu_product_attribute` a LEFT JOIN `dfdu_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
3 queries	SELECT * FROM `dfdu_product_attribute_lang` WHERE `id_product_attribute` = XX
3 queries	SELECT * FROM `dfdu_product` a LEFT JOIN `dfdu_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = XX LEFT JOIN `dfdu_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
3 queries	SELECT image_shop.`cover`, i.`id_image`, il.`legend`, i.`position` FROM `dfdu_image` i INNER JOIN dfdu_image_shop image_shop ON (image_shop.id_image = i.id_image AND image_shop.id_shop = XX) LEFT JOIN `dfdu_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = XX) WHERE i.`id_product` = XX ORDER BY `position`
3 queries	SELECT pai.`id_image`, pai.`id_product_attribute`, il.`legend` FROM `dfdu_product_attribute_image` pai LEFT JOIN `dfdu_image_lang` il ON (il.`id_image` = pai.`id_image`) INNER JOIN `dfdu_image` i ON (i.`id_image` = pai.`id_image`) WHERE i.`id_product` = XX AND il.`id_lang` = XX ORDER by i.`position`
3 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 `dfdu_product_attribute` pa INNER JOIN dfdu_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 `dfdu_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`) JOIN `dfdu_attribute` a ON (a.`id_attribute` = pac.`id_attribute`) JOIN `dfdu_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = XX) JOIN `dfdu_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;
3 queries	SELECT * FROM `dfdu_product` a LEFT JOIN `dfdu_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = XX WHERE (a.`id_product` = XX) LIMIT XX
3 queries	SELECT * FROM `dfdu_product_lang` WHERE `id_product` = XX AND `id_shop` = XX
3 queries	SELECT pa., product_attribute_shop. FROM `dfdu_product_attribute` pa INNER JOIN dfdu_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` = XX GROUP BY pa.`id_product_attribute` ORDER BY pa.`id_product_attribute`
3 queries	SELECT pac.id_product_attribute, GROUP_CONCAT(agl.`name`, ' - ',al.`name` ORDER BY agl.`id_attribute_group` SEPARATOR ', ') as attribute_designation FROM `dfdu_product_attribute_combination` pac LEFT JOIN `dfdu_attribute` a ON a.`id_attribute` = pac.`id_attribute` LEFT JOIN `dfdu_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group` LEFT JOIN `dfdu_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = XX) LEFT JOIN `dfdu_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = XX) WHERE pac.id_product_attribute IN (XX,XX,XX) GROUP BY pac.id_product_attribute ORDER BY pac.id_product_attribute
3 queries	SELECT al.`name` AS attribute_name FROM `dfdu_product_attribute_combination` pac LEFT JOIN `dfdu_attribute` a ON a.`id_attribute` = pac.`id_attribute` LEFT JOIN `dfdu_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group` LEFT JOIN `dfdu_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
2 queries	SELECT * FROM `dfdu_lang` a LEFT JOIN `dfdu_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 `dfdu_lang_shop` WHERE `id_lang` = XX AND id_shop = XX LIMIT XX
2 queries	SELECT m.`id_module`, m.`name`, ms.`id_module`as `mshop` FROM `dfdu_module` m LEFT JOIN `dfdu_module_shop` ms ON m.`id_module` = ms.`id_module` AND ms.`id_shop` = XX
2 queries	SELECT value FROM `dfdu_configuration` WHERE `name` = "PS_MULTISHOP_FEATURE_ACTIVE" LIMIT XX
2 queries	SELECT * FROM `dfdu_currency` a LEFT JOIN `dfdu_currency_lang` `b` ON a.`id_currency` = b.`id_currency` AND b.`id_lang` = XX LEFT JOIN `dfdu_currency_shop` `c` ON a.`id_currency` = c.`id_currency` AND c.`id_shop` = XX WHERE (a.`id_currency` = XX) LIMIT XX
2 queries	SELECT * FROM `dfdu_currency` a LEFT JOIN `dfdu_currency_shop` `c` ON a.`id_currency` = c.`id_currency` AND c.`id_shop` = XX WHERE (a.`id_currency` = XX) LIMIT XX
2 queries	SELECT * FROM `dfdu_currency_lang` WHERE `id_currency` = XX
2 queries	SELECT `id_category` FROM `dfdu_category_shop` WHERE `id_category` = XX AND `id_shop` = XX LIMIT XX
2 queries	SELECT `id_module` FROM `dfdu_module` WHERE `name` = "ps_accounts" LIMIT XX
2 queries	SELECT cl.`link_rewrite` FROM `dfdu_category_lang` cl WHERE `id_lang` = XX AND cl.id_shop = XX AND cl.`id_category` = XX LIMIT XX

Name	Instances	Source
Category	17	/controllers/front/listing/CategoryController.php:87 (__construct) [id: 9] /classes/Meta.php:364 (__construct) [id: 9] /classes/Link.php:416 (__construct) [id: 9] /classes/Link.php:416 (__construct) [id: 9] /classes/PrestaShopCollection.php:383 (hydrateCollection) [id: ] /classes/PrestaShopCollection.php:383 (hydrateCollection) [id: ] /modules/ps_facetedsearch/src/Product/Search.php:365 (__construct) [id: 9] /modules/ps_facetedsearch/src/Filters/Block.php:157 (__construct) [id: 9] /classes/Link.php:416 (__construct) [id: 9] /classes/Link.php:416 (__construct) [id: 9] /classes/Link.php:416 (__construct) [id: 9] /classes/Link.php:416 (__construct) [id: 9] /classes/Link.php:416 (__construct) [id: 9] /classes/Link.php:416 (__construct) [id: 9] /modules/ps_categorytree/ps_categorytree.php:371 (__construct) [id: 2] /modules/ps_categorytree/ps_categorytree.php:364 (getParentsCategories) [id: 2] /src/Adapter/Presenter/Category/CategoryLazyArray.php:112 (__construct) [id: 9]
Product	9	/src/Adapter/Image/ImageRetriever.php:68 (__construct) [id: 3] /src/Adapter/Image/ImageRetriever.php:68 (__construct) [id: 4] /src/Adapter/Image/ImageRetriever.php:68 (__construct) [id: 5] /classes/Link.php:114 (__construct) [id: 3] /classes/Link.php:114 (__construct) [id: 4] /classes/Link.php:114 (__construct) [id: 5] /src/Adapter/Presenter/Product/ProductLazyArray.php:914 (__construct) [id: 3] /src/Adapter/Presenter/Product/ProductLazyArray.php:914 (__construct) [id: 4] /src/Adapter/Presenter/Product/ProductLazyArray.php:914 (__construct) [id: 5]
Country	7	/config/config.inc.php:154 (__construct) [id: 6] /classes/AddressFormat.php:402 (__construct) [id: 6] /classes/controller/FrontController.php:1739 (__construct) [id: 6] /classes/AddressFormat.php:402 (__construct) [id: 6] /modules/ps_contactinfo/ps_contactinfo.php:105 (__construct) [id: 6] /classes/AddressFormat.php:402 (__construct) [id: 6] /modules/ps_contactinfo/ps_contactinfo.php:105 (__construct) [id: 6]
State	5	/classes/controller/FrontController.php:1738 (__construct) [id: 353] /modules/ps_contactinfo/ps_contactinfo.php:94 (__construct) [id: 353] /modules/ps_contactinfo/ps_contactinfo.php:104 (__construct) [id: 353] /modules/ps_contactinfo/ps_contactinfo.php:94 (__construct) [id: 353] /modules/ps_contactinfo/ps_contactinfo.php:104 (__construct) [id: 353]
Address	4	/classes/shop/Shop.php:487 (__construct) [id: ] /classes/Product.php:3454 (initialize) [id: ] /classes/Product.php:3573 (__construct) [id: ] /classes/Product.php:5723 (__construct) [id: ]
Currency	4	/src/Adapter/Currency/CurrencyDataProvider.php:101 (__construct) [id: 2] /src/Adapter/Currency/CurrencyDataProvider.php:101 (__construct) [id: 1] /classes/Tools.php:708 (getCurrencyInstance) [id: 1] /modules/ps_currencyselector/ps_currencyselector.php:112 (getCurrencies) [id: 2]
Language	3	/config/config.inc.php:219 (__construct) [id: 2] /classes/Tools.php:659 (__construct) [id: 1] /classes/Tools.php:553 (__construct) [id: 1]
Combination	3	/classes/Product.php:5671 (__construct) [id: 14] /classes/Product.php:5671 (__construct) [id: 17] /classes/Product.php:5671 (__construct) [id: 20]
AddressFormat	3	/classes/controller/FrontController.php:1733 (generateAddress) [id: ] /modules/ps_contactinfo/ps_contactinfo.php:91 (generateAddress) [id: ] /modules/ps_contactinfo/ps_contactinfo.php:91 (generateAddress) [id: ]
Shop	1	/config/config.inc.php:122 (initialize) [id: 1]
Configuration	1	/modules/ps_accounts/src/Adapter/Configuration.php:239 (__construct) [id: 479]
Gender	1	/classes/controller/FrontController.php:1656 (__construct) [id: 0]
Risk	1	/classes/controller/FrontController.php:1659 (__construct) [id: ]
Group	1	/classes/Cart.php:275 (getCurrent) [id: 1]
Cart	1	/classes/controller/FrontController.php:459 (__construct) [id: ]
Customer	1	/config/config.inc.php:272 (__construct) [id: ]
ShopGroup	1	/classes/shop/Shop.php:562 (__construct) [id: 1]
ConnectionsSource	1	/modules/statsdata/statsdata.php:119 (logHttpReferer) [id: ]

#	Query	Time (ms)	Rows	Filesort	Group By	Location
89	SELECT SQL_NO_CACHE 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, cp.position FROM dfdu_product p LEFT JOIN dfdu_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN dfdu_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN dfdu_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN dfdu_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN dfdu_category_product cp ON (p.id_product = cp.id_product) INNER JOIN dfdu_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN dfdu_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN dfdu_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN dfdu_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) WHERE ((sa.quantity>0)) AND ((pac_1.id_attribute IN (19, 20, 21))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=15 AND c.nright<=16 GROUP BY p.id_product) p INNER JOIN dfdu_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN dfdu_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN dfdu_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN dfdu_stock_available sa_1 ON (p.id_product = sa_1.id_product AND IFNULL(pac.id_product_attribute, 0) = sa_1.id_product_attribute AND sa_1.id_shop = 1 AND sa_1.id_shop_group = 0 ) LEFT JOIN dfdu_product_attribute_combination pac_2 ON (pa.id_product_attribute = pac_2.id_product_attribute) WHERE ((fp.id_feature=1)) AND ((sa_1.quantity>0)) AND ((pac_2.id_attribute IN (19, 20, 21))) GROUP BY fp.id_feature_value	8.420 ms	6	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:808 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:855 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:154 (getFeaturesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:218 (getFilterBlock) /classes/controller/ProductListingFrontController.php:354 (runQuery) /classes/controller/ProductListingFrontController.php:650 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:184 (doProductSearch) /tools/profiling/Controller.php:65 (initContent) /classes/Dispatcher.php:488 (run) /index.php:86 (dispatch)
61	SELECT SQL_NO_CACHE `id_module` FROM `dfdu_module` WHERE `name` = "ps_accounts" LIMIT 1	6.831 ms	1			/src/Adapter/Module/ModuleDataProvider.php:251 /src/Adapter/Module/ModuleDataProvider.php:223 (getModuleIdByName) /src/Core/Module/ModuleManager.php:311 (isInstalled) /modules/ps_facebook/vendor/prestashop/prestashop-accounts-installer/src/Installer/Installer.php:83 (isInstalled) /modules/ps_facebook/vendor/prestashop/prestashop-accounts-installer/src/Installer/Facade/PsAccounts.php:44 (isModuleInstalled) /modules/ps_facebook/vendor/prestashop/prestashop-accounts-installer/src/Installer/Facade/PsAccounts.php:62 (getService) /modules/ps_facebook/classes/Handler/ErrorHandler/ErrorHandler.php:66 (getPsAccountsService) /var/cache/dev/Ps_facebookFrontContainer.php:267 (__construct) /vendor/symfony/dependency-injection/Container.php:231 (getErrorHandlerService) /vendor/symfony/dependency-injection/Container.php:211 (make) /modules/ps_facebook/vendor/prestashop/module-lib-service-container/src/DependencyInjection/ServiceContainer.php:64 (get) /modules/ps_facebook/ps_facebook.php:145 (getService) /modules/ps_facebook/ps_facebook.php:310 (getService) /classes/Hook.php:1237 (hookDisplayHeader) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:454 (coreCallHook) /classes/Hook.php:1128 (callHookOn) /classes/controller/FrontController.php:621 (exec) /controllers/front/listing/CategoryController.php:176 (initContent) /tools/profiling/Controller.php:65 (initContent) /classes/Dispatcher.php:488 (run) /index.php:86 (dispatch)
59	SELECT SQL_NO_CACHE `id_module` FROM `dfdu_module` WHERE `name` = "ps_facebook" LIMIT 1	4.432 ms	1			/classes/module/Module.php:2781 /classes/module/Module.php:2269 (getModuleIdByName) /modules/ps_facebook/classes/Handler/ErrorHandler/ErrorHandler.php:55 (isEnabled) /var/cache/dev/Ps_facebookFrontContainer.php:267 (__construct) /vendor/symfony/dependency-injection/Container.php:231 (getErrorHandlerService) /vendor/symfony/dependency-injection/Container.php:211 (make) /modules/ps_facebook/vendor/prestashop/module-lib-service-container/src/DependencyInjection/ServiceContainer.php:64 (get) /modules/ps_facebook/ps_facebook.php:145 (getService) /modules/ps_facebook/ps_facebook.php:310 (getService) /classes/Hook.php:1237 (hookDisplayHeader) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:454 (coreCallHook) /classes/Hook.php:1128 (callHookOn) /classes/controller/FrontController.php:621 (exec) /controllers/front/listing/CategoryController.php:176 (initContent) /tools/profiling/Controller.php:65 (initContent) /classes/Dispatcher.php:488 (run) /index.php:86 (dispatch)
145	SELECT SQL_NO_CACHE * FROM `dfdu_image_type`	4.274 ms	7			/classes/ImageType.php:161 /classes/ImageType.php:202 (getByNameNType) /src/Adapter/Image/ImageRetriever.php:217 (getFormattedName) /src/Adapter/Image/ImageRetriever.php:102 (getImage) :undefined ({closure:PrestaShop\PrestaShop\Adapter\Image\ImageRetriever::getAllProductImages():95}) /src/Adapter/Image/ImageRetriever.php:95 (array_map) /src/Adapter/Presenter/Product/ProductLazyArray.php:941 (getAllProductImages) /src/Adapter/Presenter/Product/ProductLazyArray.php:137 (fillImages) /src/Adapter/Presenter/Product/ProductListingPresenter.php:50 (__construct) /classes/controller/ProductListingFrontController.php:114 (present) /classes/controller/ProductListingFrontController.php:376 (prepareMultipleProductsForTemplate) /classes/controller/ProductListingFrontController.php:650 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:184 (doProductSearch) /tools/profiling/Controller.php:65 (initContent) /classes/Dispatcher.php:488 (run) /index.php:86 (dispatch)
60	SELECT SQL_NO_CACHE `id_module` FROM `dfdu_module_shop` WHERE `id_module` = 38 AND `id_shop` = 1 LIMIT 1	3.894 ms	1			/classes/module/Module.php:2270 /modules/ps_facebook/classes/Handler/ErrorHandler/ErrorHandler.php:55 (isEnabled) /var/cache/dev/Ps_facebookFrontContainer.php:267 (__construct) /vendor/symfony/dependency-injection/Container.php:231 (getErrorHandlerService) /vendor/symfony/dependency-injection/Container.php:211 (make) /modules/ps_facebook/vendor/prestashop/module-lib-service-container/src/DependencyInjection/ServiceContainer.php:64 (get) /modules/ps_facebook/ps_facebook.php:145 (getService) /modules/ps_facebook/ps_facebook.php:310 (getService) /classes/Hook.php:1237 (hookDisplayHeader) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:454 (coreCallHook) /classes/Hook.php:1128 (callHookOn) /classes/controller/FrontController.php:621 (exec) /controllers/front/listing/CategoryController.php:176 (initContent) /tools/profiling/Controller.php:65 (initContent) /classes/Dispatcher.php:488 (run) /index.php:86 (dispatch)
99	REPLACE INTO dfdu_layered_filter_block (hash, data) VALUES ("20810206e4a829a1e6dd081851a06b89", "a:1:{s:7:\"filters\";a:9:{i:0;a:7:{s:9:\"type_lite\";s:12:\"availability\";s:4:\"type\";s:12:\"availability\";s:6:\"id_key\";i:0;s:4:\"name\";s:12:\"Availability\";s:6:\"values\";a:2:{i:2;a:3:{s:4:\"name\";s:8:\"In stock\";s:3:\"nbr\";i:3;s:7:\"checked\";b:1;}i:0;a:2:{s:4:\"name\";s:13:\"Not available\";s:3:\"nbr\";i:0;}}s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";i:0;}i:1;a:7:{s:9:\"type_lite\";s:6:\"extras\";s:4:\"type\";s:6:\"extras\";s:6:\"id_key\";i:0;s:4:\"name\";s:10:\"Selections\";s:6:\"values\";a:3:{s:4:\"sale\";a:2:{s:4:\"name\";s:7:\"On sale\";s:3:\"nbr\";i:0;}s:3:\"new\";a:2:{s:4:\"name\";s:11:\"New product\";s:3:\"nbr\";i:0;}s:8:\"discount\";a:2:{s:4:\"name\";s:10:\"Discounted\";s:3:\"nbr\";i:0;}}s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";i:0;}i:2;a:12:{s:9:\"type_lite\";s:5:\"price\";s:4:\"type\";s:5:\"price\";s:6:\"id_key\";i:0;s:4:\"name\";s:5:\"Price\";s:3:\"max\";d:0;s:3:\"min\";d:0;s:4:\"unit\";s:1:\"$\";s:14:\"specifications\";a:11:{s:6:\"symbol\";a:11:{i:0;s:1:\".\";i:1;s:1:\",\";i:2;s:1:\";\";i:3;s:1:\"%\";i:4;s:1:\"-\";i:5;s:1:\"+\";i:6;s:1:\"E\";i:7;s:2:\"×\";i:8;s:3:\"‰\";i:9;s:3:\"∞\";i:10;s:3:\"NaN\";}s:12:\"currencyCode\";s:3:\"USD\";s:14:\"currencySymbol\";s:1:\"$\";s:13:\"numberSymbols\";a:11:{i:0;s:1:\".\";i:1;s:1:\",\";i:2;s:1:\";\";i:3;s:1:\"%\";i:4;s:1:\"-\";i:5;s:1:\"+\";i:6;s:1:\"E\";i:7;s:2:\"×\";i:8;s:3:\"‰\";i:9;s:3:\"∞\";i:10;s:3:\"NaN\";}s:15:\"positivePattern\";s:10:\"¤#,##0.00\";s:15:\"negativePattern\";s:11:\"-¤#,##0.00\";s:17:\"maxFractionDigits\";i:2;s:17:\"minFractionDigits\";i:2;s:12:\"groupingUsed\";b:1;s:16:\"primaryGroupSize\";i:3;s:18:\"secondaryGroupSize\";i:3;}s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";i:3;s:3:\"nbr\";i:3;s:5:\"value\";N;}i:3;a:7:{s:9:\"type_lite\";s:8:\"category\";s:4:\"type\";s:8:\"category\";s:6:\"id_key\";i:0;s:4:\"name\";s:10:\"Categories\";s:6:\"values\";a:0:{}s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";i:0;}i:4;a:9:{s:9:\"type_lite\";s:10:\"id_feature\";s:4:\"type\";s:10:\"id_feature\";s:6:\"id_key\";i:1;s:6:\"values\";a:1:{i:6;a:5:{s:3:\"nbr\";i:3;s:4:\"name\";s:10:\"Matt paper\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:7:\"checked\";b:1;}}s:4:\"name\";s:11:\"Composition\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";i:0;}i:5;a:7:{s:9:\"type_lite\";s:12:\"manufacturer\";s:4:\"type\";s:12:\"manufacturer\";s:6:\"id_key\";i:0;s:4:\"name\";s:5:\"Brand\";s:6:\"values\";a:1:{i:2;a:2:{s:4:\"name\";s:14:\"Graphic Corner\";s:3:\"nbr\";i:3;}}s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";i:0;}i:6;a:7:{s:9:\"type_lite\";s:9:\"condition\";s:4:\"type\";s:9:\"condition\";s:6:\"id_key\";i:0;s:4:\"name\";s:9:\"Condition\";s:6:\"values\";a:3:{s:3:\"new\";a:2:{s:4:\"name\";s:3:\"New\";s:3:\"nbr\";i:3;}s:4:\"used\";a:2:{s:4:\"name\";s:4:\"Used\";s:3:\"nbr\";i:0;}s:11:\"refurbished\";a:2:{s:4:\"name\";s:11:\"Refurbished\";s:3:\"nbr\";i:0;}}s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";i:0;}i:7;a:12:{s:9:\"type_lite\";s:6:\"weight\";s:4:\"type\";s:6:\"weight\";s:6:\"id_key\";i:0;s:4:\"name\";s:6:\"Weight\";s:3:\"max\";d:0.3;s:3:\"min\";d:0.3;s:4:\"unit\";s:2:\"kg\";s:14:\"specifications\";N;s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";i:3;s:5:\"value\";N;s:3:\"nbr\";i:3;}i:8;a:10:{s:9:\"type_lite\";s:18:\"id_attribute_group\";s:4:\"type\";s:18:\"id_attribute_group\";s:6:\"id_key\";i:3;s:4:\"name\";s:9:\"Dimension\";s:14:\"is_color_group\";b:0;s:6:\"values\";a:3:{i:19;a:5:{s:4:\"name\";s:7:\"40x60cm\";s:3:\"nbr\";i:3;s:8:\"url_name\";N;s:10:\"meta_title\";N;s:7:\"checked\";b:1;}i:20;a:5:{s:4:\"name\";s:7:\"60x90cm\";s:3:\"nbr\";i:3;s:8:\"url_name\";N;s:10:\"meta_title\";N;s:7:\"checked\";b:1;}i:21;a:5:{s:4:\"name\";s:8:\"80x120cm\";s:3:\"nbr\";i:3;s:8:\"url_name\";N;s:10:\"meta_title\";N;s:7:\"checked\";b:1;}}s:8:\"url_name\";N;s:10:\"meta_title\";N;s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";i:0;}}}")	3.808 ms	1			/modules/ps_facetedsearch/src/Filters/Block.php:209 /modules/ps_facetedsearch/src/Product/SearchProvider.php:220 (insertIntoCache) /classes/controller/ProductListingFrontController.php:354 (runQuery) /classes/controller/ProductListingFrontController.php:650 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:184 (doProductSearch) /tools/profiling/Controller.php:65 (initContent) /classes/Dispatcher.php:488 (run) /index.php:86 (dispatch)
220	SELECT SQL_NO_CACHE data FROM `dfdu_ganalytics_data` WHERE id_cart = 0 AND id_shop = 1 LIMIT 1	3.725 ms	0			/modules/ps_googleanalytics/classes/Repository/GanalyticsDataRepository.php:39 /modules/ps_googleanalytics/classes/Handler/GanalyticsDataHandler.php:51 (findDataByCartIdAndShopId) /modules/ps_googleanalytics/classes/Hook/HookDisplayBeforeBodyClosingTag.php:267 (readData) /modules/ps_googleanalytics/classes/Hook/HookDisplayBeforeBodyClosingTag.php:54 (outputStoredEvents) /modules/ps_googleanalytics/ps_googleanalytics.php:109 (run) /classes/Hook.php:1237 (hookDisplayBeforeBodyClosingTag) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:454 (coreCallHook) /classes/Hook.php:1128 (callHookOn) /config/smarty.config.inc.php:213 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/bf/77/94/bf779460f8c4c036c7e45504a74d2d8e9d6df3a8_2.file.layout-both-columns.tpl.php:379 (__call) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/bf/77/94/bf779460f8c4c036c7e45504a74d2d8e9d6df3a8_2.file.layout-both-columns.tpl.php:123 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69b14af3597e99_82698282) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:115 (_subTemplateRender) /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/a7/7f/c0/a77fc0a1c84dbbceae38d0ec8e850b74ffa1815c_2.file.layout-left-column.tpl.php:38 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69b14af3587435_32635046) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:115 (_subTemplateRender) /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/10/b2/e3/10b2e360d5a533b2b2934e009fc915731c428e56_2.file.product-list.tpl.php:44 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69b14af3581455_05542922) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:115 (_subTemplateRender) /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/f4/86/9d/f4869d8e54faed02ff5f4e8e04ea23686e5637e3_2.file.category.tpl.php:40 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69b14af356c456_12777314) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/Smarty/SmartyDev.php:40 (fetch) /classes/controller/FrontController.php:757 (fetch) /classes/controller/FrontController.php:741 (smartyOutputContent) /tools/profiling/Controller.php:111 (display) /tools/profiling/Controller.php:88 (displayProfiling) /classes/Dispatcher.php:488 (run) /index.php:86 (dispatch)
219	INSERT INTO `dfdu_connections_source` (`id_connections`, `http_referer`, `request_uri`, `keywords`, `date_add`) VALUES ('3355', '', 'izzywine.com/en/9-art?q=Availability-In+stock%2FComposition-Matt+paper%2FDimension-60x90cm-80x120cm-40x60cm', '', '2026-03-12 07:59:43')	3.627 ms	1			/classes/ObjectModel.php:535 /classes/ConnectionsSource.php:106 (add) /modules/statsdata/statsdata.php:119 (logHttpReferer) /modules/statsdata/statsdata.php:74 (getScriptCustomerPagesViews) /classes/Hook.php:1237 (hookDisplayBeforeBodyClosingTag) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:454 (coreCallHook) /classes/Hook.php:1128 (callHookOn) /config/smarty.config.inc.php:213 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/bf/77/94/bf779460f8c4c036c7e45504a74d2d8e9d6df3a8_2.file.layout-both-columns.tpl.php:379 (__call) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/bf/77/94/bf779460f8c4c036c7e45504a74d2d8e9d6df3a8_2.file.layout-both-columns.tpl.php:123 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69b14af3597e99_82698282) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:115 (_subTemplateRender) /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/a7/7f/c0/a77fc0a1c84dbbceae38d0ec8e850b74ffa1815c_2.file.layout-left-column.tpl.php:38 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69b14af3587435_32635046) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:115 (_subTemplateRender) /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/10/b2/e3/10b2e360d5a533b2b2934e009fc915731c428e56_2.file.product-list.tpl.php:44 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69b14af3581455_05542922) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:115 (_subTemplateRender) /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/f4/86/9d/f4869d8e54faed02ff5f4e8e04ea23686e5637e3_2.file.category.tpl.php:40 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69b14af356c456_12777314) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/Smarty/SmartyDev.php:40 (fetch) /classes/controller/FrontController.php:757 (fetch) /classes/controller/FrontController.php:741 (smartyOutputContent) /tools/profiling/Controller.php:111 (display) /tools/profiling/Controller.php:88 (displayProfiling) /classes/Dispatcher.php:488 (run) /index.php:86 (dispatch)
153	SELECT SQL_NO_CACHE `id_module` FROM `dfdu_module` WHERE `name` = "ps_contactinfo" LIMIT 1	3.556 ms	1			/classes/module/Module.php:2781 /classes/module/Module.php:2269 (getModuleIdByName) /classes/Hook.php:1243 (isEnabled) /tools/profiling/Hook.php:64 (coreRenderWidget) /classes/Hook.php:1174 (coreRenderWidget) /config/smarty.config.inc.php:213 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/4d/79/7c/4d797c45b1615515aa294aa9cb1579d3b547a6a2_2.file.header.tpl.php:77 (__call) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/4d/79/7c/4d797c45b1615515aa294aa9cb1579d3b547a6a2_2.file.header.tpl.php:31 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69b14af363ea53_69869488) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/bf/77/94/bf779460f8c4c036c7e45504a74d2d8e9d6df3a8_2.file.layout-both-columns.tpl.php:196 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/bf/77/94/bf779460f8c4c036c7e45504a74d2d8e9d6df3a8_2.file.layout-both-columns.tpl.php:68 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69b14af3597e99_82698282) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:115 (_subTemplateRender) /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/a7/7f/c0/a77fc0a1c84dbbceae38d0ec8e850b74ffa1815c_2.file.layout-left-column.tpl.php:38 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69b14af3587435_32635046) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:115 (_subTemplateRender) /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/10/b2/e3/10b2e360d5a533b2b2934e009fc915731c428e56_2.file.product-list.tpl.php:44 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69b14af3581455_05542922) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:115 (_subTemplateRender) /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/f4/86/9d/f4869d8e54faed02ff5f4e8e04ea23686e5637e3_2.file.category.tpl.php:40 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69b14af356c456_12777314) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/Smarty/SmartyDev.php:40 (fetch) /classes/controller/FrontController.php:757 (fetch) /classes/controller/FrontController.php:741 (smartyOutputContent) /tools/profiling/Controller.php:111 (display) /tools/profiling/Controller.php:88 (displayProfiling) /classes/Dispatcher.php:488 (run) /index.php:86 (dispatch)
50	SELECT SQL_NO_CACHE * FROM `dfdu_image_type` WHERE 1 AND `products` = 1 ORDER BY `width` DESC, `height` DESC, `name`ASC	3.252 ms	7	Yes		/classes/ImageType.php:109 /src/Adapter/Image/ImageRetriever.php:369 (getImagesTypes) /classes/controller/FrontController.php:1561 (getNoPictureImage) /classes/controller/FrontController.php:1713 (getTemplateVarUrls) /classes/controller/FrontController.php:554 (getTemplateVarShop) /classes/controller/FrontController.php:617 (assignGeneralPurposeVariables) /controllers/front/listing/CategoryController.php:176 (initContent) /tools/profiling/Controller.php:65 (initContent) /classes/Dispatcher.php:488 (run) /index.php:86 (dispatch)
98	SELECT SQL_NO_CACHE pac.id_attribute, 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, cp.position FROM dfdu_product p LEFT JOIN dfdu_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN dfdu_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN dfdu_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN dfdu_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN dfdu_category_product cp ON (p.id_product = cp.id_product) INNER JOIN dfdu_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN dfdu_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN dfdu_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN dfdu_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN dfdu_product_attribute_combination pac_2 ON (pa.id_product_attribute = pac_2.id_product_attribute) WHERE ((sa.quantity>0)) AND ((fp_1.id_feature_value=6)) AND ((pac_2.id_attribute IN (19, 20, 21))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=15 AND c.nright<=16 GROUP BY p.id_product) p LEFT JOIN dfdu_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN dfdu_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) INNER JOIN dfdu_attribute a ON (a.id_attribute = pac.id_attribute) LEFT JOIN dfdu_stock_available sa_1 ON (p.id_product = sa_1.id_product AND IFNULL(pac.id_product_attribute, 0) = sa_1.id_product_attribute AND sa_1.id_shop = 1 AND sa_1.id_shop_group = 0 ) LEFT JOIN dfdu_feature_product fp_2 ON (p.id_product = fp_2.id_product) LEFT JOIN dfdu_product_attribute_combination pac_3 ON (pa.id_product_attribute = pac_3.id_product_attribute) WHERE ((a.id_attribute_group=4)) AND ((sa_1.quantity>0)) AND ((fp_2.id_feature_value=6)) AND ((pac_3.id_attribute IN (19, 20, 21))) GROUP BY pac.id_attribute	2.797 ms	54	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:808 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:737 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:150 (getAttributesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:218 (getFilterBlock) /classes/controller/ProductListingFrontController.php:354 (runQuery) /classes/controller/ProductListingFrontController.php:650 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:184 (doProductSearch) /tools/profiling/Controller.php:65 (initContent) /classes/Dispatcher.php:488 (run) /index.php:86 (dispatch)
204	SELECT SQL_NO_CACHE * FROM `dfdu_product_lang` WHERE `id_product` = 5 AND `id_shop` = 1	2.599 ms	2			/src/Adapter/EntityMapper.php:82 /classes/ObjectModel.php:217 (load) /tools/profiling/ObjectModel.php:32 (__construct) /classes/Product.php:708 (__construct) /src/Adapter/Presenter/Product/ProductLazyArray.php:914 (__construct) /src/Adapter/Presenter/Product/ProductLazyArray.php:752 (shouldShowOutOfStockLabel) /src/Adapter/Presenter/AbstractLazyArray.php:264 (getFlags) /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/bf/28/8d/bf288d1685d28b027337584dcfe13cc294fd57c5_2.file.product-flags.tpl.php:44 (offsetGet) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/bf/28/8d/bf288d1685d28b027337584dcfe13cc294fd57c5_2.file.product-flags.tpl.php:26 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69b14af3ac7674_39018710) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:384 (render) /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/ad/17/84/ad17846cda7a00c523f85c365f5ce311b5e246e4_2.file.product.tpl.php:279 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/ad/17/84/ad17846cda7a00c523f85c365f5ce311b5e246e4_2.file.product.tpl.php:28 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69b14af39e4421_73130277) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:384 (render) /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/4a/ab/30/4aab30449ad45f88faf385787cc63afb456ed2ad_2.file.productlist.tpl.php:39 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69b14af39af022_92821126) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/34/9e/8b/349e8bbc865dd6cab3c4fa095935c23d898af6c7_2.file.products.tpl.php:30 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69b14af39a5df4_32547916) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/10/b2/e3/10b2e360d5a533b2b2934e009fc915731c428e56_2.file.product-list.tpl.php:121 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/10/b2/e3/10b2e360d5a533b2b2934e009fc915731c428e56_2.file.product-list.tpl.php:216 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:186 (process) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/a7/7f/c0/a77fc0a1c84dbbceae38d0ec8e850b74ffa1815c_2.file.layout-left-column.tpl.php:84 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:186 (process) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/bf/77/94/bf779460f8c4c036c7e45504a74d2d8e9d6df3a8_2.file.layout-both-columns.tpl.php:94 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69b14af3597e99_82698282) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:115 (_subTemplateRender) /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/a7/7f/c0/a77fc0a1c84dbbceae38d0ec8e850b74ffa1815c_2.file.layout-left-column.tpl.php:38 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69b14af3587435_32635046) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:115 (_subTemplateRender) /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/10/b2/e3/10b2e360d5a533b2b2934e009fc915731c428e56_2.file.product-list.tpl.php:44 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69b14af3581455_05542922) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:115 (_subTemplateRender) /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/f4/86/9d/f4869d8e54faed02ff5f4e8e04ea23686e5637e3_2.file.category.tpl.php:40 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69b14af356c456_12777314) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/Smarty/SmartyDev.php:40 (fetch) /classes/controller/FrontController.php:757 (fetch) /classes/controller/FrontController.php:741 (smartyOutputContent) /tools/profiling/Controller.php:111 (display) /tools/profiling/Controller.php:88 (displayProfiling) /classes/Dispatcher.php:488 (run) /index.php:86 (dispatch)
97	SELECT SQL_NO_CACHE DISTINCT a.`id_attribute`, a.`color`, al.`name`, agl.`id_attribute_group`, IF(lialv.`url_name` IS NULL OR lialv.`url_name` = "", NULL, lialv.`url_name`) AS url_name, IF(lialv.`meta_title` IS NULL OR lialv.`meta_title` = "", NULL, lialv.`meta_title`) AS meta_title FROM `dfdu_attribute_group` ag INNER JOIN `dfdu_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1) INNER JOIN `dfdu_attribute` a ON a.`id_attribute_group` = ag.`id_attribute_group` INNER JOIN `dfdu_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1) INNER JOIN dfdu_attribute_group_shop attribute_group_shop ON (attribute_group_shop.id_attribute_group = ag.id_attribute_group AND attribute_group_shop.id_shop = 1) INNER JOIN dfdu_attribute_shop attribute_shop ON (attribute_shop.id_attribute = a.id_attribute AND attribute_shop.id_shop = 1) LEFT JOIN `dfdu_layered_indexable_attribute_lang_value` lialv ON (a.`id_attribute` = lialv.`id_attribute` AND lialv.`id_lang` = 1) WHERE ag.id_attribute_group = 4 ORDER BY agl.`name` ASC, a.`position` ASC	2.452 ms	4	Yes		/modules/ps_facetedsearch/src/Filters/DataAccessor.php:77 /modules/ps_facetedsearch/src/Filters/Block.php:731 (getAttributes) /modules/ps_facetedsearch/src/Filters/Block.php:150 (getAttributesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:218 (getFilterBlock) /classes/controller/ProductListingFrontController.php:354 (runQuery) /classes/controller/ProductListingFrontController.php:650 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:184 (doProductSearch) /tools/profiling/Controller.php:65 (initContent) /classes/Dispatcher.php:488 (run) /index.php:86 (dispatch)
49	SELECT SQL_NO_CACHE * FROM `dfdu_image_type` WHERE 1 AND `suppliers` = 1 ORDER BY `width` DESC, `height` DESC, `name`ASC	2.351 ms	7	Yes		/classes/ImageType.php:109 /src/Adapter/Image/ImageRetriever.php:369 (getImagesTypes) /classes/controller/FrontController.php:1561 (getNoPictureImage) /classes/controller/FrontController.php:1713 (getTemplateVarUrls) /classes/controller/FrontController.php:554 (getTemplateVarShop) /classes/controller/FrontController.php:617 (assignGeneralPurposeVariables) /controllers/front/listing/CategoryController.php:176 (initContent) /tools/profiling/Controller.php:65 (initContent) /classes/Dispatcher.php:488 (run) /index.php:86 (dispatch)
205	SELECT SQL_NO_CACHE pa., product_attribute_shop. FROM `dfdu_product_attribute` pa INNER JOIN dfdu_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) WHERE pa.`id_product` = 5 GROUP BY pa.`id_product_attribute` ORDER BY pa.`id_product_attribute`	2.266 ms	3	Yes	Yes	/classes/Product.php:2492 /src/Adapter/Presenter/Product/ProductLazyArray.php:920 (getAttributesResume) /src/Adapter/Presenter/Product/ProductLazyArray.php:752 (shouldShowOutOfStockLabel) /src/Adapter/Presenter/AbstractLazyArray.php:264 (getFlags) /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/bf/28/8d/bf288d1685d28b027337584dcfe13cc294fd57c5_2.file.product-flags.tpl.php:44 (offsetGet) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/bf/28/8d/bf288d1685d28b027337584dcfe13cc294fd57c5_2.file.product-flags.tpl.php:26 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69b14af3ac7674_39018710) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:384 (render) /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/ad/17/84/ad17846cda7a00c523f85c365f5ce311b5e246e4_2.file.product.tpl.php:279 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/ad/17/84/ad17846cda7a00c523f85c365f5ce311b5e246e4_2.file.product.tpl.php:28 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69b14af39e4421_73130277) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:384 (render) /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/4a/ab/30/4aab30449ad45f88faf385787cc63afb456ed2ad_2.file.productlist.tpl.php:39 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69b14af39af022_92821126) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/34/9e/8b/349e8bbc865dd6cab3c4fa095935c23d898af6c7_2.file.products.tpl.php:30 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69b14af39a5df4_32547916) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/10/b2/e3/10b2e360d5a533b2b2934e009fc915731c428e56_2.file.product-list.tpl.php:121 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/10/b2/e3/10b2e360d5a533b2b2934e009fc915731c428e56_2.file.product-list.tpl.php:216 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:186 (process) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/a7/7f/c0/a77fc0a1c84dbbceae38d0ec8e850b74ffa1815c_2.file.layout-left-column.tpl.php:84 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:186 (process) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/bf/77/94/bf779460f8c4c036c7e45504a74d2d8e9d6df3a8_2.file.layout-both-columns.tpl.php:94 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69b14af3597e99_82698282) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:115 (_subTemplateRender) /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/a7/7f/c0/a77fc0a1c84dbbceae38d0ec8e850b74ffa1815c_2.file.layout-left-column.tpl.php:38 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69b14af3587435_32635046) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:115 (_subTemplateRender) /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/10/b2/e3/10b2e360d5a533b2b2934e009fc915731c428e56_2.file.product-list.tpl.php:44 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69b14af3581455_05542922) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:115 (_subTemplateRender) /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/f4/86/9d/f4869d8e54faed02ff5f4e8e04ea23686e5637e3_2.file.category.tpl.php:40 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69b14af356c456_12777314) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/Smarty/SmartyDev.php:40 (fetch) /classes/controller/FrontController.php:757 (fetch) /classes/controller/FrontController.php:741 (smartyOutputContent) /tools/profiling/Controller.php:111 (display) /tools/profiling/Controller.php:88 (displayProfiling) /classes/Dispatcher.php:488 (run) /index.php:86 (dispatch)
158	SELECT SQL_NO_CACHE `id_module` FROM `dfdu_module` WHERE `name` = "ps_currencyselector" LIMIT 1	2.211 ms	1			/classes/module/Module.php:2781 /classes/module/Module.php:2269 (getModuleIdByName) /classes/Hook.php:1243 (isEnabled) /tools/profiling/Hook.php:64 (coreRenderWidget) /classes/Hook.php:1174 (coreRenderWidget) /config/smarty.config.inc.php:213 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/4d/79/7c/4d797c45b1615515aa294aa9cb1579d3b547a6a2_2.file.header.tpl.php:81 (__call) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/4d/79/7c/4d797c45b1615515aa294aa9cb1579d3b547a6a2_2.file.header.tpl.php:31 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69b14af363ea53_69869488) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/bf/77/94/bf779460f8c4c036c7e45504a74d2d8e9d6df3a8_2.file.layout-both-columns.tpl.php:196 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/bf/77/94/bf779460f8c4c036c7e45504a74d2d8e9d6df3a8_2.file.layout-both-columns.tpl.php:68 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69b14af3597e99_82698282) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:115 (_subTemplateRender) /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/a7/7f/c0/a77fc0a1c84dbbceae38d0ec8e850b74ffa1815c_2.file.layout-left-column.tpl.php:38 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69b14af3587435_32635046) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:115 (_subTemplateRender) /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/10/b2/e3/10b2e360d5a533b2b2934e009fc915731c428e56_2.file.product-list.tpl.php:44 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69b14af3581455_05542922) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:115 (_subTemplateRender) /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/f4/86/9d/f4869d8e54faed02ff5f4e8e04ea23686e5637e3_2.file.category.tpl.php:40 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69b14af356c456_12777314) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/Smarty/SmartyDev.php:40 (fetch) /classes/controller/FrontController.php:757 (fetch) /classes/controller/FrontController.php:741 (smartyOutputContent) /tools/profiling/Controller.php:111 (display) /tools/profiling/Controller.php:88 (displayProfiling) /classes/Dispatcher.php:488 (run) /index.php:86 (dispatch)
103	SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`, IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on, product_attribute_shop.`ecotax` AS attribute_ecotax FROM `dfdu_product` p INNER JOIN `dfdu_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1) LEFT JOIN `dfdu_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1) WHERE (p.`id_product` = 3)	2.078 ms	3			/classes/Product.php:3629 /classes/Product.php:3485 (priceCalculation) /classes/Product.php:5479 (getPriceStatic) /classes/ProductAssembler.php:214 (getProductProperties) /classes/controller/ProductListingFrontController.php:106 (assembleProducts) /classes/controller/ProductListingFrontController.php:376 (prepareMultipleProductsForTemplate) /classes/controller/ProductListingFrontController.php:650 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:184 (doProductSearch) /tools/profiling/Controller.php:65 (initContent) /classes/Dispatcher.php:488 (run) /index.php:86 (dispatch)
100	SELECT SQL_NO_CACHE p., ps., pl.*, sa.out_of_stock, IFNULL(sa.quantity, 0) as quantity, (DATEDIFF( p.`date_add`, DATE_SUB( '2026-03-12 00:00:00', INTERVAL 20 DAY ) ) > 0) as new FROM dfdu_product p LEFT JOIN dfdu_product_lang pl ON pl.id_product = p.id_product AND pl.id_shop = 1 AND pl.id_lang = 1 LEFT JOIN dfdu_stock_available sa ON sa.id_product = p.id_product AND sa.id_product_attribute = 0 AND sa.id_shop = 1 LEFT JOIN dfdu_product_shop ps ON ps.id_product = p.id_product AND ps.id_shop = 1 WHERE p.id_product IN (3,4,5)	1.879 ms	3			/classes/ProductAssembler.php:101 /classes/ProductAssembler.php:211 (addMissingProductFieldsForMultipleProducts) /classes/controller/ProductListingFrontController.php:106 (assembleProducts) /classes/controller/ProductListingFrontController.php:376 (prepareMultipleProductsForTemplate) /classes/controller/ProductListingFrontController.php:650 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:184 (doProductSearch) /tools/profiling/Controller.php:65 (initContent) /classes/Dispatcher.php:488 (run) /index.php:86 (dispatch)
84	SELECT SQL_NO_CACHE cp.id_category, 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, cp.position FROM dfdu_product p LEFT JOIN dfdu_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN dfdu_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN dfdu_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN dfdu_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN dfdu_category_product cp ON (p.id_product = cp.id_product) INNER JOIN dfdu_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN dfdu_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN dfdu_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN dfdu_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN dfdu_product_attribute_combination pac_2 ON (pa.id_product_attribute = pac_2.id_product_attribute) WHERE ((sa.quantity>0)) AND ((fp_1.id_feature_value=6)) AND ((pac_2.id_attribute IN (19, 20, 21))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=15 AND c.nright<=16 GROUP BY p.id_product) p INNER JOIN dfdu_category_product cp ON (p.id_product = cp.id_product) INNER JOIN dfdu_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN dfdu_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN dfdu_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN dfdu_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN dfdu_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN dfdu_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN dfdu_product_attribute_combination pac_2 ON (pa.id_product_attribute = pac_2.id_product_attribute) WHERE ((sa.quantity>0)) AND ((fp_1.id_feature_value=6)) AND ((pac_2.id_attribute IN (19, 20, 21))) AND cg.id_group='1' AND c.level_depth<=3 AND c.nleft>15 AND c.nright<16 GROUP BY cp.id_category	1.558 ms	54	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:808 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:992 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:158 (getCategoriesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:218 (getFilterBlock) /classes/controller/ProductListingFrontController.php:354 (runQuery) /classes/controller/ProductListingFrontController.php:650 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:184 (doProductSearch) /tools/profiling/Controller.php:65 (initContent) /classes/Dispatcher.php:488 (run) /index.php:86 (dispatch)
104	SELECT SQL_NO_CACHE `id_hook`, `name` FROM `dfdu_hook` UNION SELECT `id_hook`, ha.`alias` as name FROM `dfdu_hook_alias` ha INNER JOIN `dfdu_hook` h ON ha.name = h.name	1.435 ms	0			/classes/Hook.php:1568 /classes/Hook.php:251 (getAllHookIds) /classes/tax/TaxManagerFactory.php:63 (getIdByName) /classes/tax/TaxManagerFactory.php:42 (execHookTaxManagerFactory) /classes/Product.php:3694 (getManager) /classes/Product.php:3485 (priceCalculation) /classes/Product.php:5479 (getPriceStatic) /classes/ProductAssembler.php:214 (getProductProperties) /classes/controller/ProductListingFrontController.php:106 (assembleProducts) /classes/controller/ProductListingFrontController.php:376 (prepareMultipleProductsForTemplate) /classes/controller/ProductListingFrontController.php:650 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:184 (doProductSearch) /tools/profiling/Controller.php:65 (initContent) /classes/Dispatcher.php:488 (run) /index.php:86 (dispatch)
190	SELECT SQL_NO_CACHE cl.`link_rewrite` FROM `dfdu_category_lang` cl WHERE `id_lang` = 0 AND cl.id_shop = 1 AND cl.`id_category` = 9 LIMIT 1	1.347 ms	0			/classes/Category.php:1396 /classes/Product.php:740 (getLinkRewrite) /src/Adapter/Presenter/Product/ProductLazyArray.php:914 (__construct) /src/Adapter/Presenter/Product/ProductLazyArray.php:752 (shouldShowOutOfStockLabel) /src/Adapter/Presenter/AbstractLazyArray.php:264 (getFlags) /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/bf/28/8d/bf288d1685d28b027337584dcfe13cc294fd57c5_2.file.product-flags.tpl.php:44 (offsetGet) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/bf/28/8d/bf288d1685d28b027337584dcfe13cc294fd57c5_2.file.product-flags.tpl.php:26 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69b14af3ac7674_39018710) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/ad/17/84/ad17846cda7a00c523f85c365f5ce311b5e246e4_2.file.product.tpl.php:279 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/ad/17/84/ad17846cda7a00c523f85c365f5ce311b5e246e4_2.file.product.tpl.php:28 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69b14af39e4421_73130277) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/4a/ab/30/4aab30449ad45f88faf385787cc63afb456ed2ad_2.file.productlist.tpl.php:39 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69b14af39af022_92821126) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/34/9e/8b/349e8bbc865dd6cab3c4fa095935c23d898af6c7_2.file.products.tpl.php:30 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69b14af39a5df4_32547916) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/10/b2/e3/10b2e360d5a533b2b2934e009fc915731c428e56_2.file.product-list.tpl.php:121 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/10/b2/e3/10b2e360d5a533b2b2934e009fc915731c428e56_2.file.product-list.tpl.php:216 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:186 (process) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/a7/7f/c0/a77fc0a1c84dbbceae38d0ec8e850b74ffa1815c_2.file.layout-left-column.tpl.php:84 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:186 (process) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/bf/77/94/bf779460f8c4c036c7e45504a74d2d8e9d6df3a8_2.file.layout-both-columns.tpl.php:94 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69b14af3597e99_82698282) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:115 (_subTemplateRender) /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/a7/7f/c0/a77fc0a1c84dbbceae38d0ec8e850b74ffa1815c_2.file.layout-left-column.tpl.php:38 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69b14af3587435_32635046) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:115 (_subTemplateRender) /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/10/b2/e3/10b2e360d5a533b2b2934e009fc915731c428e56_2.file.product-list.tpl.php:44 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69b14af3581455_05542922) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:115 (_subTemplateRender) /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/f4/86/9d/f4869d8e54faed02ff5f4e8e04ea23686e5637e3_2.file.category.tpl.php:40 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69b14af356c456_12777314) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/Smarty/SmartyDev.php:40 (fetch) /classes/controller/FrontController.php:757 (fetch) /classes/controller/FrontController.php:741 (smartyOutputContent) /tools/profiling/Controller.php:111 (display) /tools/profiling/Controller.php:88 (displayProfiling) /classes/Dispatcher.php:488 (run) /index.php:86 (dispatch)
146	SELECT SQL_NO_CACHE * FROM `dfdu_product` a LEFT JOIN `dfdu_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1 LEFT JOIN `dfdu_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1 WHERE (a.`id_product` = 4) AND (b.`id_shop` = 1) LIMIT 1	1.342 ms	1			/src/Adapter/EntityMapper.php:74 /classes/ObjectModel.php:217 (load) /tools/profiling/ObjectModel.php:32 (__construct) /classes/Product.php:708 (__construct) /src/Adapter/Image/ImageRetriever.php:68 (__construct) /src/Adapter/Presenter/Product/ProductLazyArray.php:941 (getAllProductImages) /src/Adapter/Presenter/Product/ProductLazyArray.php:137 (fillImages) /src/Adapter/Presenter/Product/ProductListingPresenter.php:50 (__construct) /classes/controller/ProductListingFrontController.php:114 (present) /classes/controller/ProductListingFrontController.php:376 (prepareMultipleProductsForTemplate) /classes/controller/ProductListingFrontController.php:650 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:184 (doProductSearch) /tools/profiling/Controller.php:65 (initContent) /classes/Dispatcher.php:488 (run) /index.php:86 (dispatch)
62	SELECT SQL_NO_CACHE value FROM `dfdu_configuration` WHERE `name` = "PS_MULTISHOP_FEATURE_ACTIVE" LIMIT 1	1.313 ms	1			/modules/ps_accounts/src/Adapter/Configuration.php:278 /modules/ps_accounts/src/Adapter/Configuration.php:223 (isMultishopActive) /modules/ps_accounts/src/Adapter/Configuration.php:204 (getUncachedConfiguration) /modules/ps_accounts/src/Adapter/Configuration.php:125 (getUncached) /modules/ps_accounts/src/Repository/ConfigurationRepository.php:423 (get) /modules/ps_accounts/src/Account/StatusManager.php:370 (getCachedShopStatus) /modules/ps_accounts/src/Account/StatusManager.php:173 (getCachedStatus) /modules/ps_accounts/src/Account/StatusManager.php:240 (getStatus) /modules/ps_accounts/src/Service/PsAccountsService.php:111 (getCloudShopId) /modules/ps_accounts/src/Service/PsAccountsService.php:103 (getShopUuid) /modules/ps_facebook/classes/Handler/ErrorHandler/ErrorHandler.php:68 (getShopUuidV4) /var/cache/dev/Ps_facebookFrontContainer.php:267 (__construct) /vendor/symfony/dependency-injection/Container.php:231 (getErrorHandlerService) /vendor/symfony/dependency-injection/Container.php:211 (make) /modules/ps_facebook/vendor/prestashop/module-lib-service-container/src/DependencyInjection/ServiceContainer.php:64 (get) /modules/ps_facebook/ps_facebook.php:145 (getService) /modules/ps_facebook/ps_facebook.php:310 (getService) /classes/Hook.php:1237 (hookDisplayHeader) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:454 (coreCallHook) /classes/Hook.php:1128 (callHookOn) /classes/controller/FrontController.php:621 (exec) /controllers/front/listing/CategoryController.php:176 (initContent) /tools/profiling/Controller.php:65 (initContent) /classes/Dispatcher.php:488 (run) /index.php:86 (dispatch)
90	SELECT SQL_NO_CACHE 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, cp.position FROM dfdu_product p LEFT JOIN dfdu_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN dfdu_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN dfdu_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN dfdu_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN dfdu_category_product cp ON (p.id_product = cp.id_product) INNER JOIN dfdu_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN dfdu_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN dfdu_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN dfdu_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN dfdu_product_attribute_combination pac_2 ON (pa.id_product_attribute = pac_2.id_product_attribute) WHERE ((sa.quantity>0)) AND ((fp_1.id_feature_value=6)) AND ((pac_2.id_attribute IN (19, 20, 21))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=15 AND c.nright<=16 GROUP BY p.id_product) p INNER JOIN dfdu_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN dfdu_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN dfdu_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN dfdu_stock_available sa_1 ON (p.id_product = sa_1.id_product AND IFNULL(pac.id_product_attribute, 0) = sa_1.id_product_attribute AND sa_1.id_shop = 1 AND sa_1.id_shop_group = 0 ) LEFT JOIN dfdu_feature_product fp_2 ON (p.id_product = fp_2.id_product) LEFT JOIN dfdu_product_attribute_combination pac_3 ON (pa.id_product_attribute = pac_3.id_product_attribute) WHERE ((fp.id_feature=2)) AND ((sa_1.quantity>0)) AND ((fp_2.id_feature_value=6)) AND ((pac_3.id_attribute IN (19, 20, 21))) GROUP BY fp.id_feature_value	1.287 ms	54	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:808 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:855 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:154 (getFeaturesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:218 (getFilterBlock) /classes/controller/ProductListingFrontController.php:354 (runQuery) /classes/controller/ProductListingFrontController.php:650 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:184 (doProductSearch) /tools/profiling/Controller.php:65 (initContent) /classes/Dispatcher.php:488 (run) /index.php:86 (dispatch)
86	SELECT SQL_NO_CACHE pac.id_attribute, 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, cp.position FROM dfdu_product p LEFT JOIN dfdu_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN dfdu_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN dfdu_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN dfdu_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN dfdu_category_product cp ON (p.id_product = cp.id_product) INNER JOIN dfdu_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN dfdu_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN dfdu_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN dfdu_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN dfdu_product_attribute_combination pac_2 ON (pa.id_product_attribute = pac_2.id_product_attribute) WHERE ((sa.quantity>0)) AND ((fp_1.id_feature_value=6)) AND ((pac_2.id_attribute IN (19, 20, 21))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=15 AND c.nright<=16 GROUP BY p.id_product) p LEFT JOIN dfdu_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN dfdu_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) INNER JOIN dfdu_attribute a ON (a.id_attribute = pac.id_attribute) LEFT JOIN dfdu_stock_available sa_1 ON (p.id_product = sa_1.id_product AND IFNULL(pac.id_product_attribute, 0) = sa_1.id_product_attribute AND sa_1.id_shop = 1 AND sa_1.id_shop_group = 0 ) LEFT JOIN dfdu_feature_product fp_2 ON (p.id_product = fp_2.id_product) LEFT JOIN dfdu_product_attribute_combination pac_3 ON (pa.id_product_attribute = pac_3.id_product_attribute) WHERE ((a.id_attribute_group=1)) AND ((sa_1.quantity>0)) AND ((fp_2.id_feature_value=6)) AND ((pac_3.id_attribute IN (19, 20, 21))) GROUP BY pac.id_attribute	1.273 ms	54	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:808 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:737 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:150 (getAttributesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:218 (getFilterBlock) /classes/controller/ProductListingFrontController.php:354 (runQuery) /classes/controller/ProductListingFrontController.php:650 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:184 (doProductSearch) /tools/profiling/Controller.php:65 (initContent) /classes/Dispatcher.php:488 (run) /index.php:86 (dispatch)
184	SELECT SQL_NO_CACHE `id_module` FROM `dfdu_module_shop` WHERE `id_module` = 59 AND `id_shop` = 1 LIMIT 1	1.211 ms	1			/classes/module/Module.php:2270 /classes/Hook.php:1243 (isEnabled) /tools/profiling/Hook.php:64 (coreRenderWidget) /classes/Hook.php:1174 (coreRenderWidget) /config/smarty.config.inc.php:213 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/bf/77/94/bf779460f8c4c036c7e45504a74d2d8e9d6df3a8_2.file.layout-both-columns.tpl.php:255 (__call) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/bf/77/94/bf779460f8c4c036c7e45504a74d2d8e9d6df3a8_2.file.layout-both-columns.tpl.php:89 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69b14af3597e99_82698282) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:115 (_subTemplateRender) /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/a7/7f/c0/a77fc0a1c84dbbceae38d0ec8e850b74ffa1815c_2.file.layout-left-column.tpl.php:38 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69b14af3587435_32635046) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:115 (_subTemplateRender) /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/10/b2/e3/10b2e360d5a533b2b2934e009fc915731c428e56_2.file.product-list.tpl.php:44 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69b14af3581455_05542922) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:115 (_subTemplateRender) /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/f4/86/9d/f4869d8e54faed02ff5f4e8e04ea23686e5637e3_2.file.category.tpl.php:40 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69b14af356c456_12777314) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/Smarty/SmartyDev.php:40 (fetch) /classes/controller/FrontController.php:757 (fetch) /classes/controller/FrontController.php:741 (smartyOutputContent) /tools/profiling/Controller.php:111 (display) /tools/profiling/Controller.php:88 (displayProfiling) /classes/Dispatcher.php:488 (run) /index.php:86 (dispatch)
81	SELECT SQL_NO_CACHE 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, cp.position FROM dfdu_product p LEFT JOIN dfdu_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN dfdu_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN dfdu_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN dfdu_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN dfdu_category_product cp ON (p.id_product = cp.id_product) INNER JOIN dfdu_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN dfdu_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN dfdu_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN dfdu_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN dfdu_product_attribute_combination pac_2 ON (pa.id_product_attribute = pac_2.id_product_attribute) WHERE ((sa.quantity>0)) AND ((fp_1.id_feature_value=6)) AND ((pac_2.id_attribute IN (19, 20, 21))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=15 AND c.nright<=16 GROUP BY p.id_product) p LEFT JOIN dfdu_specific_price sp ON ( sp.id_product = p.id_product AND sp.id_shop IN (0, 1) AND sp.id_currency IN (0, 1) AND sp.id_country IN (0, 6) AND sp.id_group IN (0, 1) AND sp.from_quantity = 1 AND sp.reduction > 0 AND sp.id_customer = 0 AND sp.id_cart = 0 AND (sp.from = '0000-00-00 00:00:00' OR '2026-03-12 07:59:43' >= sp.from) AND (sp.to = '0000-00-00 00:00:00' OR '2026-03-12 07:59:43' <= sp.to) ) LEFT JOIN dfdu_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN dfdu_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN dfdu_stock_available sa_1 ON (p.id_product = sa_1.id_product AND IFNULL(pac.id_product_attribute, 0) = sa_1.id_product_attribute AND sa_1.id_shop = 1 AND sa_1.id_shop_group = 0 ) LEFT JOIN dfdu_feature_product fp_2 ON (p.id_product = fp_2.id_product) LEFT JOIN dfdu_product_attribute_combination pac_3 ON (pa.id_product_attribute = pac_3.id_product_attribute) WHERE ((sp.reduction>0)) AND ((sa_1.quantity>0)) AND ((fp_2.id_feature_value=6)) AND ((pac_3.id_attribute IN (19, 20, 21)))	1.189 ms	54			/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:808 (execute) /modules/ps_facetedsearch/src/Adapter/MySQL.php:787 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:605 (count) /modules/ps_facetedsearch/src/Filters/Block.php:143 (getHighlightsBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:218 (getFilterBlock) /classes/controller/ProductListingFrontController.php:354 (runQuery) /classes/controller/ProductListingFrontController.php:650 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:184 (doProductSearch) /tools/profiling/Controller.php:65 (initContent) /classes/Dispatcher.php:488 (run) /index.php:86 (dispatch)
2	SELECT SQL_NO_CACHE c.`name`, cl.`id_lang`, IF(cl.`id_lang` IS NULL, c.`value`, cl.`value`) AS value, c.id_shop_group, c.id_shop FROM `dfdu_configuration` c LEFT JOIN `dfdu_configuration_lang` cl ON (c.`id_configuration` = cl.`id_configuration`)	1.115 ms	510			/classes/Configuration.php:182 /classes/Configuration.php:230 (loadConfiguration) /classes/Configuration.php:303 (get) /classes/shop/Shop.php:399 (getMultiShopValues) /config/config.inc.php:122 (initialize) /index.php:40 (require_once)
187	SELECT SQL_NO_CACHE `id_module` FROM `dfdu_module_shop` WHERE `id_module` = 22 AND `id_shop` = 1 LIMIT 1	1.110 ms	1			/classes/module/Module.php:2270 /classes/Hook.php:1243 (isEnabled) /tools/profiling/Hook.php:64 (coreRenderWidget) /classes/Hook.php:1174 (coreRenderWidget) /config/smarty.config.inc.php:213 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/ad/17/84/ad17846cda7a00c523f85c365f5ce311b5e246e4_2.file.product.tpl.php:195 (__call) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/ad/17/84/ad17846cda7a00c523f85c365f5ce311b5e246e4_2.file.product.tpl.php:274 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/ad/17/84/ad17846cda7a00c523f85c365f5ce311b5e246e4_2.file.product.tpl.php:28 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69b14af39e4421_73130277) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/4a/ab/30/4aab30449ad45f88faf385787cc63afb456ed2ad_2.file.productlist.tpl.php:39 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69b14af39af022_92821126) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/34/9e/8b/349e8bbc865dd6cab3c4fa095935c23d898af6c7_2.file.products.tpl.php:30 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69b14af39a5df4_32547916) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/10/b2/e3/10b2e360d5a533b2b2934e009fc915731c428e56_2.file.product-list.tpl.php:121 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/10/b2/e3/10b2e360d5a533b2b2934e009fc915731c428e56_2.file.product-list.tpl.php:216 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:186 (process) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/a7/7f/c0/a77fc0a1c84dbbceae38d0ec8e850b74ffa1815c_2.file.layout-left-column.tpl.php:84 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:186 (process) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/bf/77/94/bf779460f8c4c036c7e45504a74d2d8e9d6df3a8_2.file.layout-both-columns.tpl.php:94 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69b14af3597e99_82698282) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:115 (_subTemplateRender) /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/a7/7f/c0/a77fc0a1c84dbbceae38d0ec8e850b74ffa1815c_2.file.layout-left-column.tpl.php:38 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69b14af3587435_32635046) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:115 (_subTemplateRender) /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/10/b2/e3/10b2e360d5a533b2b2934e009fc915731c428e56_2.file.product-list.tpl.php:44 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69b14af3581455_05542922) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:115 (_subTemplateRender) /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/f4/86/9d/f4869d8e54faed02ff5f4e8e04ea23686e5637e3_2.file.category.tpl.php:40 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69b14af356c456_12777314) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/Smarty/SmartyDev.php:40 (fetch) /classes/controller/FrontController.php:757 (fetch) /classes/controller/FrontController.php:741 (smartyOutputContent) /tools/profiling/Controller.php:111 (display) /tools/profiling/Controller.php:88 (displayProfiling) /classes/Dispatcher.php:488 (run) /index.php:86 (dispatch)
74	SELECT SQL_NO_CACHE p.id_product, p.id_product_attribute 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, cp.position FROM dfdu_product p LEFT JOIN dfdu_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN dfdu_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN dfdu_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN dfdu_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN dfdu_category_product cp ON (p.id_product = cp.id_product) INNER JOIN dfdu_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN dfdu_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN dfdu_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN dfdu_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN dfdu_product_attribute_combination pac_2 ON (pa.id_product_attribute = pac_2.id_product_attribute) WHERE ((sa.quantity>0)) AND ((fp_1.id_feature_value=6)) AND ((pac_2.id_attribute IN (19, 20, 21))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=15 AND c.nright<=16 GROUP BY p.id_product) p LEFT JOIN dfdu_product_attribute pa ON (p.id_product = pa.id_product) INNER JOIN dfdu_category_product cp ON (p.id_product = cp.id_product) GROUP BY p.id_product ORDER BY p.position ASC, p.id_product DESC	1.003 ms	54	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Filters/Products.php:87 (execute) /modules/ps_facetedsearch/src/Product/SearchProvider.php:189 (getProductByFilters) /classes/controller/ProductListingFrontController.php:354 (runQuery) /classes/controller/ProductListingFrontController.php:650 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:184 (doProductSearch) /tools/profiling/Controller.php:65 (initContent) /classes/Dispatcher.php:488 (run) /index.php:86 (dispatch)
147	SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position` FROM `dfdu_image` i INNER JOIN dfdu_image_shop image_shop ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1) LEFT JOIN `dfdu_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 1) WHERE i.`id_product` = 4 ORDER BY `position`	0.997 ms	1	Yes		/classes/Product.php:3285 /src/Adapter/Image/ImageRetriever.php:75 (getImages) /src/Adapter/Presenter/Product/ProductLazyArray.php:941 (getAllProductImages) /src/Adapter/Presenter/Product/ProductLazyArray.php:137 (fillImages) /src/Adapter/Presenter/Product/ProductListingPresenter.php:50 (__construct) /classes/controller/ProductListingFrontController.php:114 (present) /classes/controller/ProductListingFrontController.php:376 (prepareMultipleProductsForTemplate) /classes/controller/ProductListingFrontController.php:650 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:184 (doProductSearch) /tools/profiling/Controller.php:65 (initContent) /classes/Dispatcher.php:488 (run) /index.php:86 (dispatch)
92	SELECT SQL_NO_CACHE p.id_manufacturer, 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, cp.position FROM dfdu_product p LEFT JOIN dfdu_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN dfdu_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN dfdu_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN dfdu_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN dfdu_category_product cp ON (p.id_product = cp.id_product) INNER JOIN dfdu_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN dfdu_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN dfdu_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN dfdu_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN dfdu_product_attribute_combination pac_2 ON (pa.id_product_attribute = pac_2.id_product_attribute) WHERE ((sa.quantity>0)) AND ((fp_1.id_feature_value=6)) AND ((pac_2.id_attribute IN (19, 20, 21))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=15 AND c.nright<=16 GROUP BY p.id_product) p LEFT JOIN dfdu_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN dfdu_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN dfdu_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN dfdu_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN dfdu_product_attribute_combination pac_2 ON (pa.id_product_attribute = pac_2.id_product_attribute) WHERE ((sa.quantity>0)) AND ((fp_1.id_feature_value=6)) AND ((pac_2.id_attribute IN (19, 20, 21))) GROUP BY p.id_manufacturer	0.956 ms	54	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:808 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:661 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:146 (getManufacturersBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:218 (getFilterBlock) /classes/controller/ProductListingFrontController.php:354 (runQuery) /classes/controller/ProductListingFrontController.php:650 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:184 (doProductSearch) /tools/profiling/Controller.php:65 (initContent) /classes/Dispatcher.php:488 (run) /index.php:86 (dispatch)
16	SELECT SQL_NO_CACHE h.`name` as hook, m.`id_module`, h.`id_hook`, m.`name` as module FROM `dfdu_module` m INNER JOIN dfdu_module_shop module_shop ON (module_shop.id_module = m.id_module AND module_shop.id_shop = 1) INNER JOIN `dfdu_hook_module` `hm` ON hm.`id_module` = m.`id_module` INNER JOIN `dfdu_hook` `h` ON hm.`id_hook` = h.`id_hook` LEFT JOIN `dfdu_module_group` `mg` ON mg.`id_module` = m.`id_module` WHERE (h.`name` != "paymentOptions") AND (hm.`id_shop` = 1) AND (mg.id_shop = 1 AND mg.`id_group` IN (1)) GROUP BY hm.id_hook, hm.id_module ORDER BY hm.`position`	0.955 ms	150	Yes	Yes	/classes/Hook.php:1500 /classes/Hook.php:809 (getAllHookRegistrations) /classes/Hook.php:952 (getHookModuleExecList) /classes/Dispatcher.php:595 (exec) /classes/Dispatcher.php:253 (loadRoutes) /classes/Dispatcher.php:215 (__construct) /index.php:86 (getInstance)
203	SELECT SQL_NO_CACHE * FROM `dfdu_product` a LEFT JOIN `dfdu_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1 WHERE (a.`id_product` = 5) LIMIT 1	0.917 ms	1			/src/Adapter/EntityMapper.php:74 /classes/ObjectModel.php:217 (load) /tools/profiling/ObjectModel.php:32 (__construct) /classes/Product.php:708 (__construct) /src/Adapter/Presenter/Product/ProductLazyArray.php:914 (__construct) /src/Adapter/Presenter/Product/ProductLazyArray.php:752 (shouldShowOutOfStockLabel) /src/Adapter/Presenter/AbstractLazyArray.php:264 (getFlags) /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/bf/28/8d/bf288d1685d28b027337584dcfe13cc294fd57c5_2.file.product-flags.tpl.php:44 (offsetGet) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/bf/28/8d/bf288d1685d28b027337584dcfe13cc294fd57c5_2.file.product-flags.tpl.php:26 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69b14af3ac7674_39018710) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:384 (render) /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/ad/17/84/ad17846cda7a00c523f85c365f5ce311b5e246e4_2.file.product.tpl.php:279 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/ad/17/84/ad17846cda7a00c523f85c365f5ce311b5e246e4_2.file.product.tpl.php:28 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69b14af39e4421_73130277) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:384 (render) /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/4a/ab/30/4aab30449ad45f88faf385787cc63afb456ed2ad_2.file.productlist.tpl.php:39 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69b14af39af022_92821126) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/34/9e/8b/349e8bbc865dd6cab3c4fa095935c23d898af6c7_2.file.products.tpl.php:30 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69b14af39a5df4_32547916) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/10/b2/e3/10b2e360d5a533b2b2934e009fc915731c428e56_2.file.product-list.tpl.php:121 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/10/b2/e3/10b2e360d5a533b2b2934e009fc915731c428e56_2.file.product-list.tpl.php:216 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:186 (process) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/a7/7f/c0/a77fc0a1c84dbbceae38d0ec8e850b74ffa1815c_2.file.layout-left-column.tpl.php:84 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:186 (process) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/bf/77/94/bf779460f8c4c036c7e45504a74d2d8e9d6df3a8_2.file.layout-both-columns.tpl.php:94 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69b14af3597e99_82698282) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:115 (_subTemplateRender) /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/a7/7f/c0/a77fc0a1c84dbbceae38d0ec8e850b74ffa1815c_2.file.layout-left-column.tpl.php:38 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69b14af3587435_32635046) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:115 (_subTemplateRender) /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/10/b2/e3/10b2e360d5a533b2b2934e009fc915731c428e56_2.file.product-list.tpl.php:44 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69b14af3581455_05542922) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:115 (_subTemplateRender) /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/f4/86/9d/f4869d8e54faed02ff5f4e8e04ea23686e5637e3_2.file.category.tpl.php:40 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69b14af356c456_12777314) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/Smarty/SmartyDev.php:40 (fetch) /classes/controller/FrontController.php:757 (fetch) /classes/controller/FrontController.php:741 (smartyOutputContent) /tools/profiling/Controller.php:111 (display) /tools/profiling/Controller.php:88 (displayProfiling) /classes/Dispatcher.php:488 (run) /index.php:86 (dispatch)
93	SELECT SQL_NO_CACHE p.condition, 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, cp.position FROM dfdu_product p LEFT JOIN dfdu_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN dfdu_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN dfdu_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN dfdu_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN dfdu_category_product cp ON (p.id_product = cp.id_product) INNER JOIN dfdu_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN dfdu_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN dfdu_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN dfdu_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN dfdu_product_attribute_combination pac_2 ON (pa.id_product_attribute = pac_2.id_product_attribute) WHERE ((sa.quantity>0)) AND ((fp_1.id_feature_value=6)) AND ((pac_2.id_attribute IN (19, 20, 21))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=15 AND c.nright<=16 GROUP BY p.id_product) p LEFT JOIN dfdu_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN dfdu_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN dfdu_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN dfdu_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN dfdu_product_attribute_combination pac_2 ON (pa.id_product_attribute = pac_2.id_product_attribute) WHERE ((sa.quantity>0)) AND ((fp_1.id_feature_value=6)) AND ((pac_2.id_attribute IN (19, 20, 21))) GROUP BY p.condition	0.900 ms	54	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:808 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:394 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:137 (getConditionsBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:218 (getFilterBlock) /classes/controller/ProductListingFrontController.php:354 (runQuery) /classes/controller/ProductListingFrontController.php:650 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:184 (doProductSearch) /tools/profiling/Controller.php:65 (initContent) /classes/Dispatcher.php:488 (run) /index.php:86 (dispatch)
76	SELECT SQL_NO_CACHE 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, cp.position FROM dfdu_product p LEFT JOIN dfdu_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN dfdu_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN dfdu_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN dfdu_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN dfdu_category_product cp ON (p.id_product = cp.id_product) INNER JOIN dfdu_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN dfdu_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN dfdu_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN dfdu_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN dfdu_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) WHERE ((fp.id_feature_value=6)) AND ((pac_1.id_attribute IN (19, 20, 21))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=15 AND c.nright<=16 GROUP BY p.id_product) p LEFT JOIN dfdu_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN dfdu_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN dfdu_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN dfdu_stock_available sa_1 ON (p.id_product = sa_1.id_product AND IFNULL(pac.id_product_attribute, 0) = sa_1.id_product_attribute AND sa_1.id_shop = 1 AND sa_1.id_shop_group = 0 ) LEFT JOIN dfdu_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN dfdu_product_attribute_combination pac_2 ON (pa.id_product_attribute = pac_2.id_product_attribute) WHERE ((sa.quantity<=0 AND sa_1.out_of_stock IN (0, 2))) AND ((fp_1.id_feature_value=6)) AND ((pac_2.id_attribute IN (19, 20, 21)))	0.886 ms	54			/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:808 (execute) /modules/ps_facetedsearch/src/Adapter/MySQL.php:787 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:480 (count) /modules/ps_facetedsearch/src/Filters/Block.php:140 (getAvailabilitiesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:218 (getFilterBlock) /classes/controller/ProductListingFrontController.php:354 (runQuery) /classes/controller/ProductListingFrontController.php:650 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:184 (doProductSearch) /tools/profiling/Controller.php:65 (initContent) /classes/Dispatcher.php:488 (run) /index.php:86 (dispatch)
88	SELECT SQL_NO_CACHE pac.id_attribute, 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, cp.position FROM dfdu_product p LEFT JOIN dfdu_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN dfdu_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN dfdu_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN dfdu_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN dfdu_category_product cp ON (p.id_product = cp.id_product) INNER JOIN dfdu_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN dfdu_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN dfdu_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN dfdu_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN dfdu_product_attribute_combination pac_2 ON (pa.id_product_attribute = pac_2.id_product_attribute) WHERE ((sa.quantity>0)) AND ((fp_1.id_feature_value=6)) AND ((pac_2.id_attribute IN (19, 20, 21))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=15 AND c.nright<=16 GROUP BY p.id_product) p LEFT JOIN dfdu_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN dfdu_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) INNER JOIN dfdu_attribute a ON (a.id_attribute = pac.id_attribute) LEFT JOIN dfdu_stock_available sa_1 ON (p.id_product = sa_1.id_product AND IFNULL(pac.id_product_attribute, 0) = sa_1.id_product_attribute AND sa_1.id_shop = 1 AND sa_1.id_shop_group = 0 ) LEFT JOIN dfdu_feature_product fp_2 ON (p.id_product = fp_2.id_product) LEFT JOIN dfdu_product_attribute_combination pac_3 ON (pa.id_product_attribute = pac_3.id_product_attribute) WHERE ((a.id_attribute_group=2)) AND ((sa_1.quantity>0)) AND ((fp_2.id_feature_value=6)) AND ((pac_3.id_attribute IN (19, 20, 21))) GROUP BY pac.id_attribute	0.871 ms	54	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:808 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:737 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:150 (getAttributesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:218 (getFilterBlock) /classes/controller/ProductListingFrontController.php:354 (runQuery) /classes/controller/ProductListingFrontController.php:650 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:184 (doProductSearch) /tools/profiling/Controller.php:65 (initContent) /classes/Dispatcher.php:488 (run) /index.php:86 (dispatch)
10	SELECT SQL_NO_CACHE domain, domain_ssl FROM dfdu_shop_url WHERE main = 1 AND id_shop = 1 LIMIT 1	0.861 ms	1			/classes/shop/ShopUrl.php:178 /classes/shop/ShopUrl.php:198 (cacheMainDomainForShop) /classes/Tools.php:292 (getMainShopDomain) /classes/Link.php:65 (getShopDomain) /config/config.inc.php:285 (__construct) /index.php:40 (require_once)
77	SELECT SQL_NO_CACHE 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, cp.position FROM dfdu_product p LEFT JOIN dfdu_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN dfdu_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN dfdu_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN dfdu_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN dfdu_category_product cp ON (p.id_product = cp.id_product) INNER JOIN dfdu_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN dfdu_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN dfdu_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN dfdu_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN dfdu_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) WHERE ((fp.id_feature_value=6)) AND ((pac_1.id_attribute IN (19, 20, 21))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=15 AND c.nright<=16 GROUP BY p.id_product) p LEFT JOIN dfdu_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN dfdu_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN dfdu_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN dfdu_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN dfdu_product_attribute_combination pac_2 ON (pa.id_product_attribute = pac_2.id_product_attribute) WHERE ((sa.out_of_stock=1) OR (sa.quantity>0)) AND ((fp_1.id_feature_value=6)) AND ((pac_2.id_attribute IN (19, 20, 21)))	0.852 ms	54			/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:808 (execute) /modules/ps_facetedsearch/src/Adapter/MySQL.php:787 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:494 (count) /modules/ps_facetedsearch/src/Filters/Block.php:140 (getAvailabilitiesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:218 (getFilterBlock) /classes/controller/ProductListingFrontController.php:354 (runQuery) /classes/controller/ProductListingFrontController.php:650 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:184 (doProductSearch) /tools/profiling/Controller.php:65 (initContent) /classes/Dispatcher.php:488 (run) /index.php:86 (dispatch)
156	SELECT SQL_NO_CACHE `id_module` FROM `dfdu_module` WHERE `name` = "ps_languageselector" LIMIT 1	0.836 ms	1			/classes/module/Module.php:2781 /classes/module/Module.php:2269 (getModuleIdByName) /classes/Hook.php:1243 (isEnabled) /tools/profiling/Hook.php:64 (coreRenderWidget) /classes/Hook.php:1174 (coreRenderWidget) /config/smarty.config.inc.php:213 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/4d/79/7c/4d797c45b1615515aa294aa9cb1579d3b547a6a2_2.file.header.tpl.php:81 (__call) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/4d/79/7c/4d797c45b1615515aa294aa9cb1579d3b547a6a2_2.file.header.tpl.php:31 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69b14af363ea53_69869488) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/bf/77/94/bf779460f8c4c036c7e45504a74d2d8e9d6df3a8_2.file.layout-both-columns.tpl.php:196 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/bf/77/94/bf779460f8c4c036c7e45504a74d2d8e9d6df3a8_2.file.layout-both-columns.tpl.php:68 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69b14af3597e99_82698282) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:115 (_subTemplateRender) /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/a7/7f/c0/a77fc0a1c84dbbceae38d0ec8e850b74ffa1815c_2.file.layout-left-column.tpl.php:38 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69b14af3587435_32635046) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:115 (_subTemplateRender) /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/10/b2/e3/10b2e360d5a533b2b2934e009fc915731c428e56_2.file.product-list.tpl.php:44 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69b14af3581455_05542922) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:115 (_subTemplateRender) /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/f4/86/9d/f4869d8e54faed02ff5f4e8e04ea23686e5637e3_2.file.category.tpl.php:40 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69b14af356c456_12777314) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/Smarty/SmartyDev.php:40 (fetch) /classes/controller/FrontController.php:757 (fetch) /classes/controller/FrontController.php:741 (smartyOutputContent) /tools/profiling/Controller.php:111 (display) /tools/profiling/Controller.php:88 (displayProfiling) /classes/Dispatcher.php:488 (run) /index.php:86 (dispatch)

#	Filename
0	/index.php
1	/config/config.inc.php
2	/config/defines.inc.php
3	/config/autoload.php
4	/vendor/autoload.php
5	/vendor/composer/autoload_real.php
6	/vendor/composer/platform_check.php
7	/vendor/composer/ClassLoader.php
8	/vendor/composer/autoload_static.php
9	/vendor/symfony/deprecation-contracts/function.php
10	/vendor/symfony/polyfill-mbstring/bootstrap.php
11	/vendor/symfony/polyfill-mbstring/bootstrap80.php
12	/vendor/symfony/polyfill-ctype/bootstrap.php
13	/vendor/symfony/polyfill-ctype/bootstrap80.php
14	/vendor/symfony/polyfill-php83/bootstrap.php
15	/vendor/symfony/var-dumper/Resources/functions/dump.php
16	/vendor/symfony/polyfill-intl-normalizer/bootstrap.php
17	/vendor/symfony/polyfill-intl-normalizer/bootstrap80.php
18	/vendor/twig/twig/src/Resources/core.php
19	/vendor/twig/twig/src/Resources/debug.php
20	/vendor/twig/twig/src/Resources/escaper.php
21	/vendor/twig/twig/src/Resources/string_loader.php
22	/vendor/symfony/polyfill-intl-grapheme/bootstrap.php
23	/vendor/symfony/polyfill-intl-grapheme/bootstrap80.php
24	/vendor/symfony/string/Resources/functions.php
25	/vendor/symfony/polyfill-intl-idn/bootstrap.php
26	/vendor/symfony/clock/Resources/now.php
27	/vendor/symfony/polyfill-php80/bootstrap.php
28	/vendor/ezyang/htmlpurifier/library/HTMLPurifier.composer.php
29	/vendor/jakeasmith/http_build_url/src/http_build_url.php
30	/vendor/symfony/polyfill-intl-icu/bootstrap.php
31	/vendor/ircmaxell/password-compat/lib/password.php
32	/vendor/martinlindhe/php-mb-helpers/src/mb_helpers.php
33	/vendor/symfony/polyfill-php73/bootstrap.php
34	/vendor/symfony/translation/Resources/functions.php
35	/src/Core/Version.php
36	/config/alias.php
37	/vendor/prestashop/autoload/src/PrestashopAutoload.php
38	/vendor/prestashop/autoload/src/LegacyClassLoader.php
39	/vendor/symfony/filesystem/Filesystem.php