Arte

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

Hay 3 productos.

Ordenar por:

Mostrando 1-3 de 3 artículo(s)

Vista rápida

The best is yet to come'...

56,97 $

Vista rápida

The adventure begins Framed...

56,97 $

Vista rápida

Today is a good day Framed...

56,97 $

Volver arriba

Load Time	603.467 ms
Querying Time	67 ms
Queries	224
Memory Peak Usage	48.3 Mb
Included Files	1061 files - 12.79 Mb
PrestaShop Cache	- Mb
Global vars	0.15 Mb
- global $_MODULES	99k
- global $_ENV	13k
- global $_SERVER	13k
- global $__composer_autoload_files	5k
- global $config	5k
- global $context	3k
- global $smarty	3k
- global $exportPhpConfigFile	3k
- global $_REQUEST	2k
- global $_COOKIE	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	205.728 ms	205.728 ms	23.03 Mb	24.1 Mb
__construct	0.096 ms	205.824 ms	- Mb	24.1 Mb
init	48.114 ms	253.938 ms	3.26 Mb	26.4 Mb
checkAccess	0.002 ms	253.940 ms	- Mb	26.4 Mb
setMedia	53.725 ms	307.665 ms	3.67 Mb	30.0 Mb
postProcess	0.003 ms	307.668 ms	- Mb	30.0 Mb
initHeader	0.003 ms	307.671 ms	- Mb	30.0 Mb
initContent	184.759 ms	492.430 ms	9.73 Mb	39.8 Mb
initFooter	0.004 ms	492.434 ms	- Mb	39.8 Mb
display	111.033 ms	603.467 ms	7.94 Mb	48.3 Mb

Hook	Time	Memory Usage
DisplayHeader	42.721 ms	3.91 Mb
=> ps_shoppingcart	0.076 ms	- Mb
=> ps_searchbar	0.475 ms	0.01 Mb
=> ps_imageslider	0.110 ms	- Mb
=> productcomments	0.114 ms	- Mb
=> ps_facebook	16.210 ms	0.96 Mb
=> psshipping	21.980 ms	1.58 Mb
=> ps_googleanalytics	1.614 ms	1.26 Mb
=> psxmarketingwithgoogle	2.142 ms	0.10 Mb
ActionFrontControllerSetMedia	39.220 ms	2.67 Mb
=> blockreassurance	0.927 ms	0.07 Mb
=> blockwishlist	0.335 ms	- Mb
=> ps_emailsubscription	0.085 ms	- Mb
=> ps_socialfollow	0.062 ms	- Mb
=> ps_facebook	0.191 ms	- Mb
=> ps_emailalerts	0.057 ms	- Mb
=> ps_checkout	37.563 ms	2.60 Mb
displayProductListReviews	32.733 ms	2.03 Mb
=> productcomments (widget)	31.226 ms	2.03 Mb
=> productcomments (widget)	0.732 ms	- Mb
=> productcomments (widget)	0.775 ms	- Mb
DisplayBeforeBodyClosingTag	6.447 ms	0.36 Mb
=> statsdata	3.186 ms	0.09 Mb
=> ps_googleanalytics	3.261 ms	0.27 Mb
displayLeftColumn	5.829 ms	0.33 Mb
=> ps_categorytree (widget)	3.510 ms	0.19 Mb
=> ps_supplierlist (widget)	0.377 ms	0.03 Mb
=> ps_brandlist (widget)	1.942 ms	0.10 Mb
displayNav2	5.783 ms	0.36 Mb
=> ps_languageselector (widget)	1.389 ms	0.06 Mb
=> ps_currencyselector (widget)	2.335 ms	0.16 Mb
=> ps_customersignin (widget)	0.854 ms	0.05 Mb
=> ps_shoppingcart (widget)	1.205 ms	0.08 Mb
displayFooter	3.268 ms	0.20 Mb
=> ps_linklist (widget)	1.216 ms	0.07 Mb
=> ps_customeraccountlinks (widget)	0.805 ms	0.07 Mb
=> ps_contactinfo (widget)	1.247 ms	0.05 Mb
ProductSearchProvider	3.044 ms	0.16 Mb
=> ps_facetedsearch	3.044 ms	0.16 Mb
DisplayFooter	2.241 ms	0.12 Mb
=> blockwishlist	2.017 ms	0.11 Mb
=> ps_facebook	0.224 ms	0.01 Mb
displayNav1	2.220 ms	0.07 Mb
=> ps_contactinfo (widget)	2.220 ms	0.07 Mb
displayTop	2.075 ms	0.13 Mb
=> ps_mainmenu (widget)	1.312 ms	0.08 Mb
=> ps_searchbar (widget)	0.763 ms	0.05 Mb
displayFooterBefore	1.848 ms	0.11 Mb
=> ps_emailsubscription (widget)	0.990 ms	0.06 Mb
=> ps_socialfollow (widget)	0.858 ms	0.05 Mb
DisplayLeftColumn	0.283 ms	0.02 Mb
=> ps_facetedsearch	0.283 ms	0.02 Mb
DisplayTop	0.126 ms	- Mb
=> pagesnotfound	0.117 ms	- Mb
=> psxmarketingwithgoogle	0.009 ms	- Mb
DisplayNavFullWidth	0.017 ms	- Mb
=> blockreassurance	0.017 ms	- Mb
DisplayAfterBodyOpeningTag	0.010 ms	- Mb
=> blockreassurance	0.010 ms	- Mb
DisplayFooterBefore	0.007 ms	- Mb
=> blockreassurance	0.007 ms	- Mb
DisplayFooterAfter	0.007 ms	- Mb
=> blockreassurance	0.007 ms	- Mb
ModuleRoutes	0.005 ms	- Mb
=> ps_checkout	0.005 ms	- Mb
19 hook(s)	147.883 ms	10.47 Mb

Module	Time	Memory Usage
ps_checkout	60.969 ms	5.81 Mb
__construct	23.386 ms	3.22 Mb
hookModuleRoutes	0.011 ms	- Mb
hookActionFrontControllerSetMedia	37.572 ms	2.60 Mb
blockreassurance	2.752 ms	0.22 Mb
__construct	1.762 ms	0.14 Mb
hookActionFrontControllerSetMedia	0.934 ms	0.07 Mb
hookDisplayAfterBodyOpeningTag	0.017 ms	- Mb
hookDisplayNavFullWidth	0.019 ms	- Mb
hookDisplayFooterBefore	0.010 ms	- Mb
hookDisplayFooterAfter	0.010 ms	- Mb
blockwishlist	2.904 ms	0.18 Mb
__construct	0.542 ms	0.06 Mb
hookActionFrontControllerSetMedia	0.338 ms	- Mb
hookDisplayFooter	2.024 ms	0.12 Mb
ps_emailsubscription	3.960 ms	0.34 Mb
__construct	2.859 ms	0.28 Mb
hookActionFrontControllerSetMedia	0.104 ms	- Mb
displayFooterBefore	0.997 ms	0.06 Mb
ps_socialfollow	1.781 ms	0.12 Mb
__construct	0.855 ms	0.06 Mb
hookActionFrontControllerSetMedia	0.065 ms	- Mb
displayFooterBefore	0.861 ms	0.06 Mb
ps_facebook	19.826 ms	1.16 Mb
__construct	3.184 ms	0.19 Mb
hookActionFrontControllerSetMedia	0.196 ms	- Mb
hookDisplayHeader	16.219 ms	0.96 Mb
hookDisplayFooter	0.227 ms	0.01 Mb
ps_emailalerts	3.655 ms	0.24 Mb
__construct	3.593 ms	0.24 Mb
hookActionFrontControllerSetMedia	0.062 ms	- Mb
ps_accounts	2.332 ms	0.20 Mb
__construct	2.332 ms	0.20 Mb
ps_shoppingcart	2.011 ms	0.13 Mb
__construct	0.721 ms	0.04 Mb
hookDisplayHeader	0.082 ms	- Mb
displayNav2	1.208 ms	0.08 Mb
ps_searchbar	1.561 ms	0.08 Mb
__construct	0.316 ms	0.03 Mb
hookDisplayHeader	0.479 ms	0.01 Mb
displayTop	0.766 ms	0.05 Mb
ps_imageslider	3.037 ms	0.21 Mb
__construct	2.923 ms	0.21 Mb
hookDisplayHeader	0.114 ms	- Mb
productcomments	34.699 ms	2.22 Mb
__construct	1.833 ms	0.18 Mb
hookDisplayHeader	0.118 ms	- Mb
displayProductListReviews	31.232 ms	2.03 Mb
displayProductListReviews	0.736 ms	- Mb
displayProductListReviews	0.780 ms	- Mb
psshipping	23.407 ms	1.74 Mb
__construct	1.419 ms	0.17 Mb
hookDisplayHeader	21.988 ms	1.58 Mb
ps_googleanalytics	5.534 ms	1.64 Mb
__construct	0.649 ms	0.11 Mb
hookDisplayHeader	1.619 ms	1.26 Mb
hookDisplayBeforeBodyClosingTag	3.266 ms	0.27 Mb
psxmarketingwithgoogle	3.048 ms	0.15 Mb
__construct	0.890 ms	0.05 Mb
hookDisplayHeader	2.147 ms	0.10 Mb
hookDisplayTop	0.011 ms	- Mb
ps_facetedsearch	9.426 ms	0.62 Mb
__construct	6.086 ms	0.44 Mb
hookProductSearchProvider	3.052 ms	0.17 Mb
hookDisplayLeftColumn	0.288 ms	0.02 Mb
ps_contactinfo	4.029 ms	0.17 Mb
__construct	0.553 ms	0.04 Mb
displayNav1	2.226 ms	0.07 Mb
displayFooter	1.250 ms	0.05 Mb
ps_languageselector	1.728 ms	0.09 Mb
__construct	0.335 ms	0.02 Mb
displayNav2	1.393 ms	0.06 Mb
ps_currencyselector	2.732 ms	0.18 Mb
__construct	0.394 ms	0.03 Mb
displayNav2	2.338 ms	0.16 Mb
ps_customersignin	1.171 ms	0.08 Mb
__construct	0.314 ms	0.02 Mb
displayNav2	0.857 ms	0.05 Mb
ps_mainmenu	5.058 ms	0.34 Mb
__construct	3.739 ms	0.26 Mb
displayTop	1.319 ms	0.08 Mb
pagesnotfound	0.757 ms	0.05 Mb
__construct	0.635 ms	0.05 Mb
hookDisplayTop	0.122 ms	- Mb
ps_categorytree	4.309 ms	0.32 Mb
__construct	0.793 ms	0.12 Mb
displayLeftColumn	3.516 ms	0.19 Mb
ps_supplierlist	1.035 ms	0.08 Mb
__construct	0.655 ms	0.04 Mb
displayLeftColumn	0.380 ms	0.03 Mb
ps_brandlist	2.488 ms	0.15 Mb
__construct	0.542 ms	0.04 Mb
displayLeftColumn	1.946 ms	0.11 Mb
ps_linklist	11.870 ms	1.81 Mb
__construct	10.648 ms	1.73 Mb
displayFooter	1.222 ms	0.08 Mb
ps_customeraccountlinks	1.259 ms	0.10 Mb
__construct	0.451 ms	0.03 Mb
displayFooter	0.808 ms	0.07 Mb
statsdata	3.876 ms	0.14 Mb
__construct	0.685 ms	0.05 Mb
hookDisplayBeforeBodyClosingTag	3.191 ms	0.09 Mb
28 module(s)	221.214 ms	18.56 Mb

Arte

The best is yet to come'...

The adventure begins Framed...

Today is a good day Framed...

Stopwatch SQL - 224 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` = 'es-es' OR `language_code` = 'es-es' 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_product_attribute_combination pac_XX ON (pa.id_product_attribute = pac_XX.id_product_attribute) WHERE ((sa.quantity>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_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 ((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 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 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, 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_product_attribute_combination pac_XX ON (pa.id_product_attribute = pac_XX.id_product_attribute) WHERE ((sa.quantity>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 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_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_product_attribute_combination pac_XX ON (pa.id_product_attribute = pac_XX.id_product_attribute) WHERE ((fp.id_feature=XX)) AND ((sa_XX.quantity>XX)) AND ((pac_XX.id_attribute IN (XX, XX, XX))) GROUP BY fp.id_feature_value
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: ]
Language	4	/config/config.inc.php:219 (__construct) [id: 2] /classes/Dispatcher.php:553 (__construct) [id: 2] /classes/Tools.php:659 (__construct) [id: 2] /classes/Tools.php:553 (__construct) [id: 2]
Currency	4	/src/Adapter/Currency/CurrencyDataProvider.php:101 (__construct) [id: 2] /src/Adapter/Currency/CurrencyDataProvider.php:101 (__construct) [id: 1] /classes/Tools.php:699 (getCurrencyInstance) [id: 1] /modules/ps_currencyselector/ps_currencyselector.php:112 (getCurrencies) [id: 2]
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
147	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` = 2 LEFT JOIN `dfdu_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1 WHERE (a.`id_product` = 5) AND (b.`id_shop` = 1) LIMIT 1	6.082 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)
140	SELECT SQL_NO_CACHE cl.`link_rewrite` FROM `dfdu_category_lang` cl WHERE `id_lang` = 2 AND cl.id_shop = 1 AND cl.`id_category` = 9 LIMIT 1	2.474 ms	1			/classes/Category.php:1396 /classes/Product.php:740 (getLinkRewrite) /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)
137	SELECT SQL_NO_CACHE * 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` = 1 WHERE (a.`id_product_attribute` = 20) LIMIT 1	1.322 ms	1			/src/Adapter/EntityMapper.php:74 /classes/ObjectModel.php:217 (load) /tools/profiling/ObjectModel.php:32 (__construct) /classes/Product.php:5671 (__construct) /classes/Product.php:5634 (computeUnitPriceRatio) /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)
13	SELECT SQL_NO_CACHE lower(name) as name FROM `dfdu_hook` h WHERE (h.active = 1)	1.305 ms	1186			/classes/Hook.php:1608 /classes/Hook.php:910 (getHookStatusByName) /classes/Dispatcher.php:595 (exec) /classes/Dispatcher.php:253 (loadRoutes) /classes/Dispatcher.php:215 (__construct) /index.php:86 (getInstance)
102	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.108 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)
14	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`	1.015 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)
103	SELECT SQL_NO_CACHE h.id_hook, h.name as h_name, title, description, h.position, hm.position as hm_position, m.id_module, m.name, m.active FROM `dfdu_hook_module` hm STRAIGHT_JOIN `dfdu_hook` h ON (h.id_hook = hm.id_hook AND hm.id_shop = 1) STRAIGHT_JOIN `dfdu_module` as m ON (m.id_module = hm.id_module) ORDER BY hm.position	0.789 ms	374			/classes/Hook.php:495 /classes/Hook.php:542 (getHookModuleList) /classes/tax/TaxManagerFactory.php:63 (getModulesFromHook) /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)
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`)	0.759 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)
97	REPLACE INTO dfdu_layered_filter_block (hash, data) VALUES ("48fa041c27a1e05422a19a1fe07d73a1", "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:14:\"Disponibilidad\";s:6:\"values\";a:2:{i:2;a:3:{s:4:\"name\";s:8:\"En stock\";s:3:\"nbr\";i:3;s:7:\"checked\";b:1;}i:0;a:2:{s:4:\"name\";s:13:\"No disponible\";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:11:\"Selecciones\";s:6:\"values\";a:3:{s:4:\"sale\";a:2:{s:4:\"name\";s:9:\"En oferta\";s:3:\"nbr\";i:0;}s:3:\"new\";a:2:{s:4:\"name\";s:5:\"Nuevo\";s:3:\"nbr\";i:0;}s:8:\"discount\";a:2:{s:4:\"name\";s:13:\"Con descuento\";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:6:\"Precio\";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:12:\"#,##0.00 ¤\";s:15:\"negativePattern\";s:13:\"-#,##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:11:\"Categorías\";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:4:{s:3:\"nbr\";i:3;s:4:\"name\";s:10:\"Papel mate\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}}s:4:\"name\";s:12:\"Composición\";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:\"Marca\";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:6:\"Estado\";s:6:\"values\";a:3:{s:3:\"new\";a:2:{s:4:\"name\";s:5:\"Nuevo\";s:3:\"nbr\";i:3;}s:4:\"used\";a:2:{s:4:\"name\";s:5:\"Usado\";s:3:\"nbr\";i:0;}s:11:\"refurbished\";a:2:{s:4:\"name\";s:15:\"Reacondicionado\";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:4:\"Peso\";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:10:\"Dimensión\";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;}}}")	0.719 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)
81	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_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_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_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 cg.id_group='1' AND c.level_depth<=3 AND c.nleft>15 AND c.nright<16 GROUP BY cp.id_category	0.712 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: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)
89	SELECT SQL_NO_CACHE m.*, ml.`description`, ml.`short_description` FROM `dfdu_manufacturer` m INNER JOIN dfdu_manufacturer_shop manufacturer_shop ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 1)INNER JOIN `dfdu_manufacturer_lang` ml ON (m.`id_manufacturer` = ml.`id_manufacturer` AND ml.`id_lang` = 2)WHERE 1 AND m.`active` = 1 ORDER BY m.`name` ASC	0.698 ms	4	Yes		/classes/Manufacturer.php:195 /modules/ps_facetedsearch/src/Filters/Block.php:652 (getManufacturers) /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)
94	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) WHERE ((sa.quantity>0)) 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 ) WHERE ((a.id_attribute_group=3)) AND ((sa_1.quantity>0)) GROUP BY pac.id_attribute	0.675 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: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)
90	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_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 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_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))) GROUP BY p.id_manufacturer	0.674 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: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)
217	INSERT INTO `dfdu_connections_source` (`id_connections`, `http_referer`, `request_uri`, `keywords`, `date_add`) VALUES ('2488', '', 'izzywine.com/9-arte?SubmitCurrency=1&id_currency=1&q=Dimensi%C3%B3n-40x60cm-60x90cm-80x120cm%2FDisponibilidad-En+stock', '', '2026-03-12 01:22:09')	0.671 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)
83	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_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 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_product_attribute_combination pac_2 ON (pa.id_product_attribute = pac_2.id_product_attribute) WHERE ((a.id_attribute_group=1)) AND ((sa_1.quantity>0)) AND ((pac_2.id_attribute IN (19, 20, 21))) GROUP BY pac.id_attribute	0.654 ms	24	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)
71	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_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 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	0.649 ms	6	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)
86	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	0.638 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)
96	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_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 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_product_attribute_combination pac_2 ON (pa.id_product_attribute = pac_2.id_product_attribute) WHERE ((a.id_attribute_group=4)) AND ((sa_1.quantity>0)) AND ((pac_2.id_attribute IN (19, 20, 21))) GROUP BY pac.id_attribute	0.631 ms	24	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)
78	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_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 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 01:22:09' >= sp.from) AND (sp.to = '0000-00-00 00:00:00' OR '2026-03-12 01:22:09' <= 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_product_attribute_combination pac_2 ON (pa.id_product_attribute = pac_2.id_product_attribute) WHERE ((sp.reduction>0)) AND ((sa_1.quantity>0)) AND ((pac_2.id_attribute IN (19, 20, 21)))	0.629 ms	6			/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)
39	SELECT SQL_NO_CACHE c.*, cl.`id_lang`, cl.`name`, cl.`description`, cl.`additional_description`, cl.`link_rewrite`, cl.`meta_title`, cl.`meta_description` FROM `dfdu_category` c INNER JOIN dfdu_category_shop category_shop ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1) LEFT JOIN `dfdu_category_lang` cl ON (c.`id_category` = cl.`id_category` AND `id_lang` = 2 AND cl.id_shop = 1 ) LEFT JOIN `dfdu_category_group` cg ON (cg.`id_category` = c.`id_category`) WHERE `id_parent` = 9 AND `active` = 1 AND cg.`id_group` =1 GROUP BY c.`id_category` ORDER BY `level_depth` ASC, category_shop.`position` ASC	0.625 ms	1	Yes	Yes	/classes/Category.php:946 /controllers/front/listing/CategoryController.php:280 (getSubCategories) /controllers/front/listing/CategoryController.php:165 (getTemplateVarSubCategories) /tools/profiling/Controller.php:46 (init) /classes/Dispatcher.php:488 (run) /index.php:86 (dispatch)
174	SELECT SQL_NO_CACHE c., cl. FROM `dfdu_category` c INNER JOIN dfdu_category_shop category_shop ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1) LEFT JOIN `dfdu_category_lang` cl ON c.`id_category` = cl.`id_category` AND cl.id_shop = 1 LEFT JOIN `dfdu_category_group` cg ON c.`id_category` = cg.`id_category` RIGHT JOIN `dfdu_category` c2 ON c2.`id_category` = 2 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright` WHERE 1 AND c.`level_depth` <= 5 AND `id_lang` = 2 AND c.`active` = 1 AND cg.`id_group` IN (1) GROUP BY c.`id_category` ORDER BY c.`level_depth` ASC, category_shop.`position` ASC	0.606 ms	9	Yes	Yes	/classes/Category.php:815 /modules/ps_categorytree/ps_categorytree.php:141 (getNestedCategories) /modules/ps_categorytree/ps_categorytree.php:298 (getCategories) /modules/ps_categorytree/ps_categorytree.php:266 (getWidgetVariables) /classes/Hook.php:1248 (renderWidget) /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)
73	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) WHERE ((pac.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_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) WHERE ((sa.quantity<=0 AND sa_1.out_of_stock IN (0, 2))) AND ((pac_1.id_attribute IN (19, 20, 21)))	0.598 ms	6			/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)
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_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 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 ((p.on_sale=1)) AND ((sa_1.quantity>0)) AND ((pac_2.id_attribute IN (19, 20, 21)))	0.597 ms	6			/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:565 (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)
91	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_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 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_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))) GROUP BY p.condition	0.587 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: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)
85	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_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 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_product_attribute_combination pac_2 ON (pa.id_product_attribute = pac_2.id_product_attribute) WHERE ((a.id_attribute_group=2)) AND ((sa_1.quantity>0)) AND ((pac_2.id_attribute IN (19, 20, 21))) GROUP BY pac.id_attribute	0.573 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: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)
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_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 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_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 p.date_add>'2026-02-21 00:00:00'	0.553 ms	6			/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:587 (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)
88	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=2)) AND ((sa_1.quantity>0)) AND ((pac_2.id_attribute IN (19, 20, 21))) GROUP BY fp.id_feature_value	0.550 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)
74	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) WHERE ((pac.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_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) WHERE ((sa.out_of_stock=1) OR (sa.quantity>0)) AND ((pac_1.id_attribute IN (19, 20, 21)))	0.546 ms	6			/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)
75	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) WHERE ((pac.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_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)))	0.541 ms	6			/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:505 (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)
16	SELECT SQL_NO_CACHE `id_hook`, `name` FROM `dfdu_hook`	0.479 ms	1186			/classes/Hook.php:1568 /classes/Hook.php:251 (getAllHookIds) /classes/Hook.php:961 (getIdByName) /classes/Dispatcher.php:595 (exec) /classes/Dispatcher.php:253 (loadRoutes) /classes/Dispatcher.php:215 (__construct) /index.php:86 (getInstance)
98	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 = 2 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)	0.435 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)
44	SELECT SQL_NO_CACHE * FROM `dfdu_category` a LEFT JOIN `dfdu_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1 LEFT JOIN `dfdu_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1 WHERE (a.`id_category` = 9) AND (b.`id_shop` = 1) LIMIT 1	0.434 ms	1			/src/Adapter/EntityMapper.php:74 /classes/ObjectModel.php:217 (load) /tools/profiling/ObjectModel.php:32 (__construct) /classes/Category.php:179 (__construct) /classes/Link.php:416 (__construct) /classes/Link.php:472 (getCategoryObject) /classes/Link.php:1227 (getCategoryLink) /classes/controller/FrontController.php:2135 (getLanguageLink) /classes/controller/FrontController.php:1554 (getAlternativeLangsUrl) /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)
79	SELECT SQL_NO_CACHE psi.price_min, MIN(price_min) as min, MAX(price_max) as max FROM dfdu_product p INNER JOIN dfdu_layered_price_index psi ON (psi.id_product = p.id_product AND psi.id_shop = 1 AND psi.id_currency = 1 AND psi.id_country = 6) 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_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_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	0.410 ms	3			/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:57 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:250 (getMinMaxPriceValue) /modules/ps_facetedsearch/src/Filters/Block.php:131 (getPriceRangeBlock) /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)
92	SELECT SQL_NO_CACHE MIN(p.weight) as min, MAX(p.weight) as max FROM dfdu_product p 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_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_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	0.398 ms	3			/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:774 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:339 (getMinMaxValue) /modules/ps_facetedsearch/src/Filters/Block.php:134 (getWeightRangeBlock) /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)
19	SELECT SQL_NO_CACHE m.page, ml.url_rewrite, ml.id_lang FROM `dfdu_meta` m LEFT JOIN `dfdu_meta_lang` ml ON (m.id_meta = ml.id_meta AND ml.id_shop = 1 ) ORDER BY LENGTH(ml.url_rewrite) DESC	0.397 ms	43	Yes		/classes/Dispatcher.php:643 /classes/Dispatcher.php:253 (loadRoutes) /classes/Dispatcher.php:215 (__construct) /index.php:86 (getInstance)
144	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` = 2 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	0.383 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)
84	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` = 2) 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` = 2) 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` = 2) WHERE ag.id_attribute_group = 2 ORDER BY agl.`name` ASC, a.`position` ASC	0.370 ms	25	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)
93	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` = 2) 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` = 2) 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` = 2) WHERE ag.id_attribute_group = 3 ORDER BY agl.`name` ASC, a.`position` ASC	0.370 ms	3	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)
56	SELECT SQL_NO_CACHE * FROM `dfdu_category` a0 LEFT JOIN `dfdu_category_lang` `a1` ON (a0.`id_category` = a1.`id_category`) WHERE (a0.`nleft` < 15) AND (a0.`nright` > 16) AND (a1.`id_lang` = 2) AND (a1.`id_shop` = 1) ORDER BY a0.`nleft` asc	0.353 ms	2	Yes		/classes/PrestaShopCollection.php:381 /classes/PrestaShopCollection.php:438 (getAll) /controllers/front/listing/CategoryController.php:308 (rewind) /classes/controller/FrontController.php:1853 (getBreadcrumbLinks) /classes/controller/FrontController.php:559 (getBreadcrumb) /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)
20	SELECT SQL_NO_CACHE * FROM `dfdu_category` a LEFT JOIN `dfdu_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 2 LEFT JOIN `dfdu_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1 WHERE (a.`id_category` = 9) AND (b.`id_shop` = 1) LIMIT 1	0.350 ms	1			/src/Adapter/EntityMapper.php:74 /classes/ObjectModel.php:217 (load) /tools/profiling/ObjectModel.php:32 (__construct) /classes/Category.php:179 (__construct) /controllers/front/listing/CategoryController.php:87 (__construct) /tools/profiling/Controller.php:46 (init) /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