Savon Solide

ROGER & GALLET

BOIS D'ORANGE

Savon parfumé 100 gr

7,90 € (TTC)

Découvrez le savon parfumé BOIS D'ORANGE, un véritable moment de fraîcheur et de vitalité pour votre peau. Avec ses 100 g, ce savon nettoie en douceur tout en offrant un parfum chaleureux et fruité.

Ajouter au panier

ROGER & GALLET

ROSE

Savon parfumé 100 gr

7,90 € (TTC)

Offrez à votre peau un moment de douceur avec le savon parfumé ROSE. Ce savon de 100 g nettoie délicatement tout en enveloppant votre corps d'un parfum floral romantique et envoûtant.

Ajouter au panier

ROGER & GALLET

FLEUR D'OSMANTHUS

Savon parfumé 100 gr

7,90 € (TTC)

Éveillez vos sens avec le savon parfumé FLEUR D'OSMANTHUS. Ce savon de 100 g nettoie votre peau tout en l’enveloppant d'un parfum floral délicat et enivrant, parfait pour une utilisation quotidienne.

Ajouter au panier

ROGER & GALLET

Découvrez le savon parfumé CÉDRAT, un véritable élixir de fraîcheur qui nettoie en profondeur tout en apportant une touche de vitalité à votre peau. Avec ses 100 g, ce savon est parfait pour une utilisation quotidienne.

Ajouter au panier

ROGER & GALLET

NÉROLI

Savon parfumé 100 gr

7,90 € (TTC)

Découvrez le savon parfumé NÉROLI, un soin doux et délicat qui nettoie votre peau tout en l'enveloppant d'un parfum floral envoûtant. Avec ses 100 g de plaisir, ce savon est parfait pour une utilisation quotidienne.

Ajouter au panier

ROGER & GALLET

FLEUR DE FIGUIER

Savons parfumés 3 u

19,90 € (TTC)

Apportez une touche de douceur et de fraîcheur à votre routine de soins avec les savons parfumés FLEUR DE FIGUIER. Ce lot de trois savons offre une expérience olfactive délicate et envoûtante, tout en nettoyant votre...

Ajouter au panier

ROGER & GALLET

LAVANDE ROYALE

Savon bien-être 100 gr

7,90 € (TTC)

Découvrez LAVANDE ROYALE Savon Bien-Être, un savon au parfum apaisant en format 100 g. Conçu pour offrir une expérience relaxante, il allie les vertus de la lavande aux notes aromatiques et boisées, pour un moment de...

Ajouter au panier

ROGER & GALLET

ŒILLET MIGNARDISE

Savon bien-être 100 gr

7,90 € (TTC)

Découvrez ŒILLET MIGNARDISE Savon Bien-Être, un savon bienfaisant de 100 g qui combine l'arôme floral de l'œillet avec des ingrédients de qualité pour un moment de détente ultime. Idéal pour prendre soin de votre peau...

Ajouter au panier

ROGER & GALLET

ROSE THÉ

Savon bien-être 100 gr

7,90 € (TTC)

Découvrez le ROSE THÉ Savon bien-être 100 gr de Roger&Gallet, une barre de savon de 100 gr qui allie douceur et parfum délicat. Ce savon est idéal pour une routine de soin apaisante, apportant une touche florale à...

Ajouter au panier

ROGER & GALLET

FLEUR DE FIGUIER

Savon parfumé 100 gr

7,90 € (TTC)

Découvrez FLEUR DE FIGUIER, un savon parfumé de 100 gr qui apporte une touche de fraîcheur et de sophistication à votre routine quotidienne. Idéal pour une expérience sensorielle élégante, ce savon enrichit votre peau...

Ajouter au panier

ROGER & GALLET

GINGEMBRE ROUGE

Savon parfumé 100 gr

7,90 € (TTC)

Savourez l'exotisme du Savon Parfumé Gingembre Rouge en format 100 gr. Ce savon luxueux est parfait pour une expérience de bain revitalisante et énergisante.

Ajouter au panier

ROGER & GALLET

JEAN MARIE FARINA

Savon parfumé 100 gr

7,90 € (TTC)

Découvrez JEAN MARIE FARINA Savon Parfumé, un savon de 100 gr qui allie luxe et tradition avec une fragrance emblématique.

Ajouter au panier

ROGER & GALLET

BOIS D'ORANGE

Savon parfumé 3 x 100 gr

19,90 € (TTC)

Offrez à votre peau une expérience sensorielle unique avec le savon parfumé BOIS D'ORANGE. Ce savon, composé de trois barres de 100 g, nettoie en douceur tout en enveloppant votre corps d'un parfum délicat et envoûtant.

Ajouter au panier

SISLEY

EAU DE CAMPAGNE

savon 100 gr

36,90 € (TTC)

Plongez dans l'authenticité de la campagne avec notre savon EAU DE CAMPAGNE. Fabriqué à partir d'ingrédients naturels soigneusement sélectionnés, ce savon offre une expérience de nettoyage douce et revitalisante pour...

Ajouter au panier

RITUALS

THE RITUAL OF AYURVEDA

Coffret soin & bain

32,90 € (TTC)

Contenu du coffret : - Gel douche moussant 50 ml - Huile de douche 75 ml - Crème pour le corps 70 ml - Brume pour cheveux et corps 20 ml

Ajouter au panier

RITUALS

THE RITUAL OF SAKURA

Coffret Grand

59,90 € (TTC)

Contenu du Coffret : - Gel douche moussant The Ritual of Sakura — 200 ml - Crème pour le corps The Ritual of Sakura — 150 ml - Lait corporel mousse The Ritual of Sakura — 150 ml - Bougie parfumée Le Rituel de...

Ajouter au panier

Découvrez notre sélection de savon solide sur Parfumera.fr pour une toilette quotidienne simple, efficace et agréable. Des savons aux notes douces, parfumées ou nourrissantes, parfaits pour nettoyer la peau tout en préservant son confort.

LIRE PLUSAFFICHER MOINS

LIRE PLUS AFFICHER MOINS

Load Time	1055 ms
Querying Time	433 ms
Queries	1438
Memory Peak Usage	78.2 Mb
Included Files	1501 files - 21.13 Mb
PrestaShop Cache	- Mb
Global vars	1.41 Mb
- global $_MODULES	1365k
- global $_MODULE	47k
- global $_SERVER	8k
- global $smarty	5k
- global $config	5k
- global $context	3k
- global $__composer_autoload_files	3k
- global $exportPhpConfigFile	3k
- global $_COOKIE	2k

PrestaShop Version	8.1.3
PHP Version	8.1.34
MySQL Version	10.6.23-MariaDB-0ubuntu0.22.04.1
Memory Limit	4096M
Max Execution Time	3000s
Smarty Cache	enabled
Smarty Compilation	never recompile

	Time	Cumulated Time	Memory Usage	Memory Peak Usage
config	27.838 ms	27.838 ms	11.03 Mb	11.4 Mb
__construct	0.023 ms	27.861 ms	- Mb	11.4 Mb
init	67.102 ms	94.963 ms	6.25 Mb	18.3 Mb
checkAccess	0.002 ms	94.965 ms	- Mb	18.3 Mb
setMedia	50.087 ms	145.052 ms	4.57 Mb	22.0 Mb
postProcess	0.003 ms	145.055 ms	- Mb	22.0 Mb
initHeader	0.002 ms	145.057 ms	- Mb	22.0 Mb
initContent	567.460 ms	712.517 ms	33.89 Mb	55.8 Mb
initFooter	0.003 ms	712.520 ms	- Mb	55.8 Mb
display	342.938 ms	1055 ms	22.01 Mb	78.2 Mb

91 queries	SELECT c.`nleft`, c.`nright` FROM `xjXX_category` c LEFT JOIN `xjXX_category_lang` cl ON (c.`id_category` = cl.`id_category` AND `id_lang` = XX AND cl.id_shop = XX ) WHERE c.`id_category` = XX LIMIT XX
91 queries	SELECT c.`nleft`, c.`nright` FROM `xjXX_category` c WHERE c.`id_category` = XX LIMIT XX
91 queries	SELECT c., cl. FROM `xjXX_category` c LEFT JOIN `xjXX_category_lang` cl ON (c.`id_category` = cl.`id_category` AND `id_lang` = XX AND cl.id_shop = XX ) WHERE c.`nleft` <= XX AND c.`nright` >= XX AND c.`nleft` >= XX AND c.`nright` <= XX ORDER BY `nleft` DESC
80 queries	SELECT id_manufacturer FROM `xjXX_product` WHERE id_product = XX LIMIT XX
80 queries	SELECT * FROM `xjXX_product_supplier` aXX WHERE (aXX.`id_product` = XX) GROUP BY aXX.`id_supplier`
80 queries	SELECT gi.* FROM `xjXX_multipleprices_configuration` gi WHERE (date_from <= "XX-XX-XX XX:XX:XX" OR date_from = "XX-XX-XX XX:XX:XX") AND (date_to >= "XX-XX-XX XX:XX:XX" OR date_to = "XX-XX-XX XX:XX:XX") AND gi.`id_shop` = XX AND gi.`active` = XX AND (gi.groups = "" OR FIND_IN_SET(XX, REPLACE(gi.groups, ";", ",")) > XX) AND (gi.manufacturers = "" OR FIND_IN_SET(XX, REPLACE(gi.manufacturers, ";", ",")) > XX) AND (gi.suppliers = "" OR FIND_IN_SET(XX, REPLACE(gi.suppliers, ";", ",")) > XX) ORDER BY position, priority
60 queries	SELECT COUNT(*) FROM `xjXX_warehouse_cart_product` wc INNER JOIN `xjXX_cart_product` cp ON ( cp.`id_product` = wc.`id_product` AND cp.`id_product_attribute` = wc.`id_product_attribute` AND cp.`id_cart` = wc.`id_cart` ) WHERE wc.`id_cart` = XX LIMIT XX
49 queries	SELECT COUNT(*) FROM `xjXX_orders` o LEFT JOIN `xjXX_order_cart_rule` ocr ON (ocr.`id_order` = o.`id_order`) WHERE o.`id_customer` = XX AND ocr.`deleted` = XX AND ocr.`id_cart_rule` = XX LIMIT XX
48 queries	SELECT name FROM xjXX_category_lang WHERE id_shop = XX AND id_lang = XX AND id_category = XX LIMIT XX
48 queries	SELECT COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), XX) as deep_quantity, COALESCE(SUM(first_level_quantity), XX) as quantity FROM (SELECT cp.`quantity` as first_level_quantity, XX as pack_quantity FROM `xjXX_cart_product` cp WHERE cp.`id_product_attribute` = XX AND cp.`id_customization` = XX AND cp.`id_cart` = XX AND cp.`id_product` = XX UNION SELECT XX as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity FROM `xjXX_cart_product` cp JOIN `xjXX_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `xjXX_product` pr ON p.`id_product_pack` = pr.`id_product` WHERE cp.`id_product_attribute` = XX AND cp.`id_customization` = XX AND cp.`id_cart` = XX AND p.`id_product_item` = XX AND (pr.`pack_stock_type` IN (XX,XX) OR ( pr.`pack_stock_type` = XX AND XX = XX ))) as q LIMIT XX
32 queries	SELECT hm.`id_module` FROM `xjXX_hook_module` hm, `xjXX_hook` h WHERE hm.`id_module` = XX AND h.`id_hook` = XX AND h.`id_hook` = hm.`id_hook` AND hm.`id_shop` = XX LIMIT XX
20 queries	SELECT `id_module` FROM `xjXX_module_shop` WHERE `id_module` = XX AND `id_shop` = XX LIMIT XX
17 queries	SELECT XX FROM `xjXX_specific_price` WHERE id_product = XX LIMIT XX
16 queries	SELECT image_shop.`id_image` FROM `xjXX_image` i INNER JOIN xjXX_image_shop image_shop ON (image_shop.id_image = i.id_image AND image_shop.id_shop = XX) WHERE i.`id_product` = XX AND image_shop.`cover` = XX LIMIT XX
16 queries	SELECT * FROM `xjXX_product` a LEFT JOIN `xjXX_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = XX LEFT JOIN `xjXX_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
16 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 `xjXX_product` p INNER JOIN `xjXX_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = XX) LEFT JOIN `xjXX_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)
16 queries	SELECT `id_tax_rules_group` FROM `xjXX_product_shop` WHERE `id_product` = XX AND id_shop=XX LIMIT XX
16 queries	SELECT `reduction` FROM `xjXX_product_group_reduction_cache` WHERE `id_product` = XX AND `id_group` = XX LIMIT XX
16 queries	SELECT COUNT(*) FROM `xjXX_pack` WHERE id_product_pack = XX LIMIT XX
16 queries	SELECT product_type FROM `xjXX_product` WHERE id_product = XX LIMIT XX
16 queries	SELECT SUM(quantity) FROM `xjXX_stock_available` WHERE (id_product = XX) AND (id_product_attribute = XX) AND (id_shop = XX) AND (id_shop_group = XX) LIMIT XX
16 queries	SELECT name, value, pf.id_feature, f.position, fvl.id_feature_value FROM xjXX_feature_product pf LEFT JOIN xjXX_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = XX) LEFT JOIN xjXX_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = XX) LEFT JOIN xjXX_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = XX) INNER JOIN xjXX_feature_shop feature_shop ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = XX) WHERE pf.id_product = XX ORDER BY f.position ASC
16 queries	SELECT pa., product_attribute_shop., GROUP_CONCAT(ag.`id_attribute_group`) AS `id_attribute_group`, GROUP_CONCAT(a.`id_attribute`) AS `id_attribute`, GROUP_CONCAT(al.`name` SEPARATOR "\|s\|p\|a\|") AS attribute_name, GROUP_CONCAT(ag.`is_color_group`) AS `is_color_group`, GROUP_CONCAT(pac.`id_attribute`) as id_attribute_list_custom, p.cache_default_attribute FROM `xjXX_product_attribute` pa INNER JOIN xjXX_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 `xjXX_product_attribute_combination` pac ON pac.`id_product_attribute` = pa.`id_product_attribute` LEFT JOIN `xjXX_attribute` a ON a.`id_attribute` = pac.`id_attribute` LEFT JOIN `xjXX_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group` LEFT JOIN `xjXX_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = XX) JOIN `xjXX_product` p ON (p.`id_product` = pa.`id_product`) LEFT JOIN xjXX_stock_available stock ON (stock.id_product = `p`.id_product AND stock.id_product_attribute = IFNULL(`pa`.id_product_attribute, XX) AND stock.id_shop = XX AND stock.id_shop_group = XX ) WHERE pa.`id_product` = XX AND IF (stock.`quantity` > XX OR (p.`cache_default_attribute` > XX AND p.`cache_default_attribute` = pac.`id_product_attribute`), XX, IF (stock.`out_of_stock` = XX, XX = XX, stock.`out_of_stock` = XX)) GROUP BY pa.`id_product_attribute` ORDER BY product_attribute_shop.`price` ASC
16 queries	SELECT image_shop.`cover`, i.`id_image`, il.`legend`, i.`position` FROM `xjXX_image` i INNER JOIN xjXX_image_shop image_shop ON (image_shop.id_image = i.id_image AND image_shop.id_shop = XX) LEFT JOIN `xjXX_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = XX) WHERE i.`id_product` = XX ORDER BY `position`
16 queries	SELECT * FROM `xjXX_image` i LEFT JOIN `xjXX_image_lang` il ON (i.`id_image` = il.`id_image`) WHERE i.`id_product` = XX AND il.`id_lang` = XX ORDER BY i.`position` ASC
16 queries	SELECT * FROM `xjXX_product` a LEFT JOIN `xjXX_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = XX WHERE (a.`id_product` = XX) LIMIT XX
16 queries	SELECT * FROM `xjXX_product_lang` WHERE `id_product` = XX AND `id_shop` = XX
16 queries	SELECT `id_category` FROM `xjXX_category_product` WHERE `id_product` = XX
16 queries	SELECT COUNT(XX) FROM `xjXX_st_loved_product` WHERE `type`=XX AND `id_source` = XX AND ( `id_guest` = XX) AND `id_shop` = XX LIMIT XX
16 queries	SELECT image_shop.`cover`, i.`id_image`, il.`legend`, i.`position` FROM `xjXX_image` i INNER JOIN xjXX_image_shop image_shop ON (image_shop.id_image = i.id_image AND image_shop.id_shop = XX) LEFT JOIN `xjXX_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = XX) WHERE i.`id_product` = XX ORDER BY `position`
16 queries	SELECT `id_product_attribute` FROM `xjXX_product_attribute` WHERE `id_product` = XX
16 queries	SELECT DISTINCT pl.name as name FROM `xjXX_product_lang` pl WHERE (pl.id_product = XX) AND (pl.id_lang = XX AND pl.id_shop = XX ) LIMIT XX
16 queries	SELECT fp.id_feature, fp.id_product, fp.id_feature_value, custom FROM `xjXX_feature_product` fp LEFT JOIN `xjXX_feature_value` fv ON (fp.id_feature_value = fv.id_feature_value) WHERE `id_product` = XX
15 queries	SELECT * FROM `xjXX_category` a LEFT JOIN `xjXX_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = XX WHERE (a.`id_category` = XX) LIMIT XX
15 queries	SELECT * FROM `xjXX_category_lang` WHERE `id_category` = XX AND `id_shop` = XX
11 queries	SELECT qdrf.* FROM `xjXX_quantity_discount_rule_family` qdrf WHERE XX AND qdrf.active = XX AND qdrf.`id_shop` = XX ORDER BY qdrf.priority ASC;
10 queries	SELECT * FROM `xjXX_st_easy_content_setting` WHERE id_st_easy_content_setting = XX AND setting_type = XX
9 queries	SELECT m.`id_module`, m.`name`, ms.`id_module`as `mshop` FROM `xjXX_module` m LEFT JOIN `xjXX_module_shop` ms ON m.`id_module` = ms.`id_module` AND ms.`id_shop` = XX
9 queries	SELECT id_st_sticker FROM `xjXX_st_sticker_map` WHERE active = XX AND (location = XX OR (location = XX AND (id_manufacturer = XX OR id_manufacturer=XX)) OR (location = XX AND (id_category = XX OR id_category IN(XX,XX,XX,XX,XX,XX,XX,XX,XX,XX))) OR (location = XX AND (id_products LIKE "%,XX,%")))
8 queries	SELECT cl.`link_rewrite` FROM `xjXX_category_lang` cl WHERE `id_lang` = XX AND cl.id_shop = XX AND cl.`id_category` = XX LIMIT XX
8 queries	SELECT secc.* FROM `xjXX_st_easy_content_column` secc WHERE secc.`id_parent`=XX AND secc.`active`=XX AND secc.`id_st_easy_content`=XX ORDER BY secc.`position`
6 queries	SELECT *, qdrl.`name`, '' as id_customer FROM `xjXX_quantity_discount_rule` qdr LEFT JOIN `xjXX_quantity_discount_rule_lang` qdrl ON (qdr.`id_quantity_discount_rule` = qdrl.`id_quantity_discount_rule` AND qdrl.`id_lang` = XX) WHERE qdr.`active` = XX AND `id_family` = XX AND `code` != '' AND `highlight` = XX ORDER BY qdr.`priority` ASC, qdr.`id_quantity_discount_rule` ASC
6 queries	SELECT DISTINCT(qdr.`id_quantity_discount_rule`) FROM `xjXX_quantity_discount_rule` qdr INNER JOIN `xjXX_quantity_discount_rule_lang` qdrl ON (qdr.`id_quantity_discount_rule` = qdrl.`id_quantity_discount_rule` AND qdrl.`id_lang` = XX) INNER JOIN `xjXX_quantity_discount_rule_message` qdrm ON (qdrm.`id_quantity_discount_rule` = qdr.`id_quantity_discount_rule` AND qdrm.`hook_name` = 'hookDisplayTop') INNER JOIN `xjXX_quantity_discount_rule_message_lang` qdrml ON (qdrm.`id_quantity_discount_rule_message` = qdrml.`id_quantity_discount_rule_message` AND qdrml.`id_lang` = XX) WHERE qdr.`active` = XX AND qdr.`id_shop` = XX AND `id_family` = XX ORDER BY qdr.`priority` ASC, qdr.`id_quantity_discount_rule` ASC
6 queries	SELECT DISTINCT(qdr.`id_quantity_discount_rule`) FROM `xjXX_quantity_discount_rule` qdr INNER JOIN `xjXX_quantity_discount_rule_lang` qdrl ON (qdr.`id_quantity_discount_rule` = qdrl.`id_quantity_discount_rule` AND qdrl.`id_lang` = XX) INNER JOIN `xjXX_quantity_discount_rule_message` qdrm ON (qdrm.`id_quantity_discount_rule` = qdr.`id_quantity_discount_rule` AND qdrm.`hook_name` = 'hookDisplayLeftColumn') INNER JOIN `xjXX_quantity_discount_rule_message_lang` qdrml ON (qdrm.`id_quantity_discount_rule_message` = qdrml.`id_quantity_discount_rule_message` AND qdrml.`id_lang` = XX) WHERE qdr.`active` = XX AND qdr.`id_shop` = XX AND `id_family` = XX ORDER BY qdr.`priority` ASC, qdr.`id_quantity_discount_rule` ASC
6 queries	SELECT DISTINCT(qdr.`id_quantity_discount_rule`) FROM `xjXX_quantity_discount_rule` qdr INNER JOIN `xjXX_quantity_discount_rule_lang` qdrl ON (qdr.`id_quantity_discount_rule` = qdrl.`id_quantity_discount_rule` AND qdrl.`id_lang` = XX) INNER JOIN `xjXX_quantity_discount_rule_message` qdrm ON (qdrm.`id_quantity_discount_rule` = qdr.`id_quantity_discount_rule` AND qdrm.`hook_name` = 'hookDisplayContentWrapperTop') INNER JOIN `xjXX_quantity_discount_rule_message_lang` qdrml ON (qdrm.`id_quantity_discount_rule_message` = qdrml.`id_quantity_discount_rule_message` AND qdrml.`id_lang` = XX) WHERE qdr.`active` = XX AND qdr.`id_shop` = XX AND `id_family` = XX ORDER BY qdr.`priority` ASC, qdr.`id_quantity_discount_rule` ASC
6 queries	SELECT DISTINCT(qdr.`id_quantity_discount_rule`) FROM `xjXX_quantity_discount_rule` qdr INNER JOIN `xjXX_quantity_discount_rule_lang` qdrl ON (qdr.`id_quantity_discount_rule` = qdrl.`id_quantity_discount_rule` AND qdrl.`id_lang` = XX) INNER JOIN `xjXX_quantity_discount_rule_message` qdrm ON (qdrm.`id_quantity_discount_rule` = qdr.`id_quantity_discount_rule` AND qdrm.`hook_name` = 'hookDisplayProductPriceBlock') INNER JOIN `xjXX_quantity_discount_rule_message_lang` qdrml ON (qdrm.`id_quantity_discount_rule_message` = qdrml.`id_quantity_discount_rule_message` AND qdrml.`id_lang` = XX) WHERE qdr.`active` = XX AND qdr.`id_shop` = XX AND `id_family` = XX ORDER BY qdr.`priority` ASC, qdr.`id_quantity_discount_rule` ASC
6 queries	SELECT DISTINCT(qdr.`id_quantity_discount_rule`) FROM `xjXX_quantity_discount_rule` qdr INNER JOIN `xjXX_quantity_discount_rule_lang` qdrl ON (qdr.`id_quantity_discount_rule` = qdrl.`id_quantity_discount_rule` AND qdrl.`id_lang` = XX) INNER JOIN `xjXX_quantity_discount_rule_message` qdrm ON (qdrm.`id_quantity_discount_rule` = qdr.`id_quantity_discount_rule` AND qdrm.`hook_name` = 'hookDisplayContentWrapperBottom') INNER JOIN `xjXX_quantity_discount_rule_message_lang` qdrml ON (qdrm.`id_quantity_discount_rule_message` = qdrml.`id_quantity_discount_rule_message` AND qdrml.`id_lang` = XX) WHERE qdr.`active` = XX AND qdr.`id_shop` = XX AND `id_family` = XX ORDER BY qdr.`priority` ASC, qdr.`id_quantity_discount_rule` ASC
6 queries	SELECT DISTINCT(qdr.`id_quantity_discount_rule`) FROM `xjXX_quantity_discount_rule` qdr INNER JOIN `xjXX_quantity_discount_rule_lang` qdrl ON (qdr.`id_quantity_discount_rule` = qdrl.`id_quantity_discount_rule` AND qdrl.`id_lang` = XX) INNER JOIN `xjXX_quantity_discount_rule_message` qdrm ON (qdrm.`id_quantity_discount_rule` = qdr.`id_quantity_discount_rule` AND qdrm.`hook_name` = 'hookDisplayFooter') INNER JOIN `xjXX_quantity_discount_rule_message_lang` qdrml ON (qdrm.`id_quantity_discount_rule_message` = qdrml.`id_quantity_discount_rule_message` AND qdrml.`id_lang` = XX) WHERE qdr.`active` = XX AND qdr.`id_shop` = XX AND `id_family` = XX ORDER BY qdr.`priority` ASC, qdr.`id_quantity_discount_rule` ASC
5 queries	SELECT value FROM `xjXX_configuration` WHERE `name` = "PS_MULTISHOP_FEATURE_ACTIVE" LIMIT XX
5 queries	SELECT count(distinct(o.`id_order`)) FROM `xjXX_orders` o LEFT JOIN xjXX_order_cart_rule od ON o.id_order = od.id_order INNER JOIN xjXX_quantity_discount_rule_order qdro ON od.id_cart_rule = qdro.id_cart_rule WHERE qdro.id_quantity_discount_rule = XX AND XX != o.current_state LIMIT XX
5 queries	SELECT * FROM `xjXX_quantity_discount_rule_condition` t WHERE `id_quantity_discount_rule_group` = XX ORDER BY `id_quantity_discount_rule_condition` ASC
5 queries	SELECT count(XX) FROM `xjXX_st_owl_carousel_group` smsg INNER JOIN xjXX_st_owl_carousel_group_shop st_owl_carousel_group_shop ON (st_owl_carousel_group_shop.id_st_owl_carousel_group = smsg.id_st_owl_carousel_group AND st_owl_carousel_group_shop.id_shop = XX) WHERE smsg.`active`=XX and smsg.`show_on_sub`=XX and smsg.`id_category` = XX LIMIT XX
5 queries	SELECT count(XX) FROM `xjXX_st_banner_group` smsg INNER JOIN xjXX_st_banner_group_shop st_banner_group_shop ON (st_banner_group_shop.id_st_banner_group = smsg.id_st_banner_group AND st_banner_group_shop.id_shop = XX) WHERE smsg.`active`=XX and smsg.`show_on_sub`=XX and smsg.`id_category` = XX LIMIT XX
5 queries	SELECT * FROM `xjXX_st_easy_content_element` WHERE `id_st_easy_content_column`=XX AND `active`=XX ORDER BY `position` ASC
4 queries	SELECT `id_configuration` FROM `xjXX_configuration` WHERE name = 'PS_ACCOUNTS_SHOP_STATUS' AND (id_shop_group IS NULL OR id_shop_group = XX) AND (id_shop IS NULL OR id_shop = XX) LIMIT XX
4 queries	SELECT * FROM `xjXX_configuration` a WHERE (a.`id_configuration` = XX) LIMIT XX
4 queries	SELECT * FROM `xjXX_configuration_lang` WHERE `id_configuration` = XX
4 queries	SELECT SQL_NO_CACHE * FROM `xjXX_cart_rule` cr LEFT JOIN `xjXX_cart_rule_lang` crl ON (cr.`id_cart_rule` = crl.`id_cart_rule` AND crl.`id_lang` = XX) WHERE ((cr.`id_customer` = XX OR (cr.`id_customer` = XX AND (cr.`highlight` = XX OR cr.`code` = "")))) AND NOW() BETWEEN cr.date_from AND cr.date_to AND cr.`active` = XX AND cr.`quantity` > XX AND highlight = XX AND code NOT LIKE "BO_ORDER_%"
4 queries	SELECT `name` FROM `xjXX_manufacturer` WHERE `id_manufacturer` = XX AND `active` = XX LIMIT XX
4 queries	SELECT id_st_sticker FROM `xjXX_st_sticker_map` WHERE active = XX AND (location = XX OR (location = XX AND (id_manufacturer = XX OR id_manufacturer=XX)) OR (location = XX AND (id_category = XX OR id_category IN(XX,XX,XX,XX,XX,XX,XX,XX,XX))) OR (location = XX AND (id_products LIKE "%,XX,%")))
3 queries	SELECT tr.* FROM `xjXX_tax_rule` tr JOIN `xjXX_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 COUNT(total) as total FROM ( ( SELECT COUNT(p.`id_product`) as total FROM `xjXX_category_product` cp RIGHT JOIN `xjXX_category` c ON (c.`id_category` = cp.`id_category` AND c.nleft >= XX AND c.nright <= XX) LEFT JOIN `xjXX_product` p ON p.`id_product` = cp.`id_product` INNER JOIN xjXX_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = XX) LEFT JOIN `xjXX_product_attribute` pa ON pa.`id_product` = p.`id_product` LEFT JOIN `xjXX_product_attribute_combination` pac ON pac.`id_product_attribute` = pa.`id_product_attribute` JOIN `xjXX_pm_spa_cache` pa_cartesian ON (pa_cartesian.`id_product` = p.`id_product` AND pa_cartesian.`id_product_attribute` = pa.`id_product_attribute` AND pa_cartesian.`id_shop` = XX) LEFT JOIN xjXX_stock_available stock ON (stock.id_product = `p`.id_product AND stock.id_product_attribute = IFNULL(`pa`.id_product_attribute, XX) AND stock.id_shop = XX AND stock.id_shop_group = XX ) JOIN `xjXX_attribute` a ON a.`id_attribute` = pac.`id_attribute` LEFT JOIN `xjXX_product_attribute_shop` product_attribute_shop ON (p.`id_product` = product_attribute_shop.`id_product` AND product_attribute_shop.`id_product_attribute` = pac.`id_product_attribute` AND product_attribute_shop.id_shop=XX) WHERE product_shop.`id_shop` = XX AND IF (stock.`quantity` > XX OR (p.`cache_default_attribute` > XX AND p.`cache_default_attribute` = pac.`id_product_attribute`), XX, IF (stock.`out_of_stock` = XX, XX = XX, stock.`out_of_stock` = XX)) AND product_shop.`active` = XX AND cp.`id_category` = XX AND product_shop.`visibility` IN ("both", "catalog") GROUP BY cp.`id_product`, pa.`id_product_attribute` ) UNION ALL ( SELECT COUNT(p.`id_product`) as total FROM `xjXX_category_product` cp RIGHT JOIN `xjXX_category` c ON (c.`id_category` = cp.`id_category` AND c.nleft >= XX AND c.nright <= XX) LEFT JOIN `xjXX_product` p ON p.`id_product` = cp.`id_product` INNER JOIN xjXX_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = XX) LEFT JOIN `xjXX_product_attribute` pa ON pa.`id_product` = p.`id_product` AND pa.`default_on` = XX LEFT JOIN `xjXX_product_attribute_combination` pac ON pac.`id_product_attribute` = pa.`id_product_attribute` LEFT JOIN `xjXX_attribute` a ON a.`id_attribute` = pac.`id_attribute` AND (a.`id_attribute_group` IN (XX)) LEFT JOIN `xjXX_product_attribute_shop` product_attribute_shop ON (p.`id_product` = product_attribute_shop.`id_product` AND product_attribute_shop.`id_product_attribute` = pac.`id_product_attribute` AND product_attribute_shop.`default_on` = XX AND product_attribute_shop.id_shop=XX) LEFT JOIN xjXX_stock_available stock ON (stock.id_product = `p`.id_product AND stock.id_product_attribute = XX AND stock.id_shop = XX AND stock.id_shop_group = XX ) WHERE product_shop.`id_shop` = XX AND product_shop.`active` = XX AND cp.`id_category` = XX AND product_shop.`visibility` IN ("both", "catalog") GROUP BY cp.`id_product` HAVING (COUNT(a.`id_attribute`) = XX) ) ) total_query LIMIT XX
3 queries	SELECT count(XX) FROM `xjXX_st_swiper_group` smsg INNER JOIN xjXX_st_swiper_group_shop st_swiper_group_shop ON (st_swiper_group_shop.id_st_swiper_group = smsg.id_st_swiper_group AND st_swiper_group_shop.id_shop = XX) WHERE smsg.`active`=XX and smsg.`show_on_sub`=XX and smsg.`id_category` = XX LIMIT XX
2 queries	SELECT * FROM `xjXX_category` a LEFT JOIN `xjXX_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = XX LEFT JOIN `xjXX_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
2 queries	SELECT `id_lang` FROM `xjXX_lang` WHERE `locale` = 'fr-fr' OR `language_code` = 'fr-fr' LIMIT XX
2 queries	SELECT qdr.`id_quantity_discount_rule`, qdrc.`id_quantity_discount_rule_condition` FROM `xjXX_quantity_discount_rule` qdr INNER JOIN `xjXX_quantity_discount_rule_condition` qdrc ON (qdr.`id_quantity_discount_rule` = qdrc.`id_quantity_discount_rule`) WHERE qdrc.`id_type` = XX AND qdr.`id_shop` = XX
2 queries	SELECT `id_module` FROM `xjXX_module` WHERE `name` = "ps_accounts" LIMIT XX
2 queries	SELECT XX FROM `xjXX_cart_rule` WHERE ((date_to >= "XX-XX-XX XX:XX:XX" AND date_to <= "XX-XX-XX XX:XX:XX") OR (date_from >= "XX-XX-XX XX:XX:XX" AND date_from <= "XX-XX-XX XX:XX:XX") OR (date_from < "XX-XX-XX XX:XX:XX" AND date_to > "XX-XX-XX XX:XX:XX")) AND `id_customer` IN (XX,XX) LIMIT XX
2 queries	SELECT * FROM `xjXX_quantity_discount_rule` a WHERE (a.`id_quantity_discount_rule` = XX) LIMIT XX
2 queries	SELECT * FROM `xjXX_quantity_discount_rule_lang` WHERE `id_quantity_discount_rule` = XX
2 queries	SELECT s., sl. ,IF(image_multi_lang<>"" && !ISNULL(image_multi_lang), image_multi_lang, image_lang_default) AS image_multi_lang FROM `xjXX_st_sticker` s LEFT JOIN `xjXX_st_sticker_lang` sl ON (s.`id_st_sticker` = sl.`id_st_sticker` AND sl.`id_lang` = XX) LEFT JOIN `xjXX_st_sticker_shop` ss ON (s.`id_st_sticker` = ss.`id_st_sticker`) WHERE ss.`id_shop` = XX AND s.`active`=XX AND s.`type` IN (XX,XX,XX,XX,XX,XX,XX) ORDER BY s.`position` ASC, s.`id_st_sticker`
2 queries	SELECT * FROM `xjXX_st_social` s LEFT JOIN `xjXX_st_social_lang` sl ON (s.`id_st_social`=sl.`id_st_social` AND sl.`id_lang`=XX) INNER JOIN xjXX_st_social_shop st_social_shop ON (st_social_shop.id_st_social = s.id_st_social AND st_social_shop.id_shop = XX) WHERE s.`active`=XX ORDER BY s.`position`, s.`id_st_social`
2 queries	SELECT id_order FROM `xjXX_orders` o WHERE (o.id_cart=XX) LIMIT XX
2 queries	SELECT * FROM `xjXX_customer` a WHERE (a.`id_customer` = XX) LIMIT XX
2 queries	SELECT p., product_shop., stock.out_of_stock, IFNULL(stock.quantity, XX) AS quantity, IFNULL(product_attribute_shop.id_product_attribute, XX) AS id_product_attribute, product_attribute_shop.minimal_quantity AS product_attribute_minimal_quantity, pl.`description`, pl.`description_short`, pl.`available_now`, pl.`available_later`, pl.`link_rewrite`, pl.`meta_description`, pl.`meta_keywords`, pl.`meta_title`, pl.`name`, image_shop.`id_image` id_image, il.`legend` as legend, m.`name` AS manufacturer_name, cl.`name` AS category_default, DATEDIFF(product_shop.`date_add`, DATE_SUB("XX-XX-XX XX:XX:XX", INTERVAL XX DAY)) > XX AS new, product_shop.price AS orderprice FROM `xjXX_category_product` cp LEFT JOIN `xjXX_product` p ON p.`id_product` = cp.`id_product` INNER JOIN xjXX_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = XX) LEFT JOIN `xjXX_product_attribute_shop` product_attribute_shop ON (p.`id_product` = product_attribute_shop.`id_product` AND product_attribute_shop.`default_on` = XX AND product_attribute_shop.id_shop=XX) LEFT JOIN xjXX_stock_available stock ON (stock.id_product = `p`.id_product AND stock.id_product_attribute = XX AND stock.id_shop = XX AND stock.id_shop_group = XX ) LEFT JOIN `xjXX_category_lang` cl ON (product_shop.`id_category_default` = cl.`id_category` AND cl.`id_lang` = XX AND cl.id_shop = XX ) LEFT JOIN `xjXX_product_lang` pl ON (p.`id_product` = pl.`id_product` AND pl.`id_lang` = XX AND pl.id_shop = XX ) LEFT JOIN `xjXX_image_shop` image_shop ON (image_shop.`id_product` = p.`id_product` AND image_shop.cover=XX AND image_shop.id_shop=XX) LEFT JOIN `xjXX_image_lang` il ON (image_shop.`id_image` = il.`id_image` AND il.`id_lang` = XX) LEFT JOIN `xjXX_manufacturer` m ON m.`id_manufacturer` = p.`id_manufacturer` WHERE product_shop.`id_shop` = XX AND cp.`id_category` = XX AND product_shop.`active` = XX AND product_shop.`visibility` IN ("both", "catalog") ORDER BY cp.`position` ASC LIMIT XX,XX
2 queries	SELECT c.`nleft`, c.`nright`, c.`level_depth` FROM `xjXX_category` c WHERE (c.`id_category` = XX) LIMIT XX
2 queries	SELECT c.id_category, cl.name, cl.link_rewrite FROM xjXX_category c LEFT JOIN xjXX_category_shop category_shop ON (category_shop.id_category = c.id_category AND category_shop.id_shop = XX) LEFT JOIN xjXX_category_lang cl ON (cl.id_category = c.id_category AND cl.id_shop = XX )WHERE c.nleft <= XX AND c.nright >= XX AND c.nleft >= XX AND c.nright <= XX AND cl.id_lang = XX AND c.level_depth > XX ORDER BY c.level_depth ASC
2 queries	(SELECT cp.position AS `order_value`, p., product_shop., pl.`name`, stock.out_of_stock, IFNULL(stock.quantity, XX) AS quantity, IFNULL(stock.quantity, XX) AS quantity_sql, IFNULL(product_attribute_shop.id_product_attribute, XX) AS id_product_attribute, product_attribute_shop.minimal_quantity AS product_attribute_minimal_quantity, pl.`description`, pl.`description_short`, pl.`available_now`, pl.`available_later`, pl.`link_rewrite`, pl.`meta_description`, pl.`meta_keywords`, pl.`meta_title`, image_shop.`id_image` id_image, il.`legend` as legend, m.`name` AS manufacturer_name, cl.`name` AS category_default, DATEDIFF(product_shop.`date_add`, DATE_SUB("XX-XX-XX XX:XX:XX", INTERVAL XX DAY)) > XX AS new, (product_shop.`price` + IFNULL(product_attribute_shop.`price`, XX)) AS orderprice, cp.`position`, a.`position` as `position_attribute`, pa.`id_product_attribute` as pai_id_product_attribute, MAX(ag.`is_color_group`), CONCAT_WS("-", "spa", "a", p.id_product, pa.id_product_attribute) as `id_product_pack`, product_attribute_shop.`price` AS `spa_sort_column`, XX AS spa_eligible_product FROM `xjXX_category_product` cp RIGHT JOIN `xjXX_category` c ON (c.`id_category` = cp.`id_category` AND c.nleft >= XX AND c.nright <= XX) LEFT JOIN `xjXX_product` p ON p.`id_product` = cp.`id_product` INNER JOIN xjXX_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = XX) LEFT JOIN `xjXX_category_lang` cl ON (product_shop.`id_category_default` = cl.`id_category` AND cl.`id_lang` = XX AND cl.id_shop = XX ) LEFT JOIN `xjXX_product_lang` pl ON (p.`id_product` = pl.`id_product` AND pl.`id_lang` = XX AND pl.id_shop = XX ) LEFT JOIN `xjXX_image_shop` image_shop ON (image_shop.`id_product` = p.`id_product` AND image_shop.cover=XX AND image_shop.id_shop=XX) LEFT JOIN `xjXX_image_lang` il ON (image_shop.`id_image` = il.`id_image` AND il.`id_lang` = XX) LEFT JOIN `xjXX_manufacturer` m ON m.`id_manufacturer` = p.`id_manufacturer` LEFT JOIN `xjXX_product_attribute` pa ON pa.`id_product` = p.`id_product` LEFT JOIN `xjXX_product_attribute_combination` pac ON pac.`id_product_attribute` = pa.`id_product_attribute` JOIN `xjXX_pm_spa_cache` pa_cartesian ON (pa_cartesian.`id_product` = p.`id_product` AND pa_cartesian.`id_product_attribute` = pa.`id_product_attribute` AND pa_cartesian.`id_shop` = XX) JOIN `xjXX_attribute` a ON a.`id_attribute` = pac.`id_attribute` AND (a.`id_attribute_group` IN (XX)) LEFT JOIN `xjXX_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = XX) LEFT JOIN `xjXX_attribute_group` ag ON (ag.`id_attribute_group` = a.`id_attribute_group`) LEFT JOIN `xjXX_product_attribute_shop` product_attribute_shop ON ( p.`id_product` = product_attribute_shop.`id_product` AND product_attribute_shop.`id_product_attribute` = pac.`id_product_attribute` AND product_attribute_shop.id_shop=XX ) LEFT JOIN xjXX_stock_available stock ON (stock.id_product = `p`.id_product AND stock.id_product_attribute = IFNULL(`pa`.id_product_attribute, XX) AND stock.id_shop = XX AND stock.id_shop_group = XX ) WHERE product_shop.`id_shop` = XX AND product_shop.`active` = XX AND cp.`id_category` = XX AND IF (stock.`quantity` > XX OR (p.`cache_default_attribute` > XX AND p.`cache_default_attribute` = pac.`id_product_attribute`), XX, IF (stock.`out_of_stock` = XX, XX = XX, stock.`out_of_stock` = XX)) AND product_shop.`visibility` IN ("both", "catalog") GROUP BY cp.`id_product`, pa.`id_product_attribute`) UNION ALL (SELECT cp.position AS `order_value`, p., product_shop., pl.`name`, stock.out_of_stock, IFNULL(stock.quantity, XX) AS quantity, IFNULL(stock.quantity, XX) AS quantity_sql, IFNULL(product_attribute_shop.id_product_attribute, XX) AS id_product_attribute, product_attribute_shop.minimal_quantity AS product_attribute_minimal_quantity, pl.`description`, pl.`description_short`, pl.`available_now`, pl.`available_later`, pl.`link_rewrite`, pl.`meta_description`, pl.`meta_keywords`, pl.`meta_title`, image_shop.`id_image` id_image, il.`legend` as legend, m.`name` AS manufacturer_name, cl.`name` AS category_default, DATEDIFF(product_shop.`date_add`, DATE_SUB("XX-XX-XX XX:XX:XX", INTERVAL XX DAY)) > XX AS new, (product_shop.`price` + IFNULL(product_attribute_shop.`price`, XX)) AS orderprice, cp.`position`, a.`position` as `position_attribute`, pa.`id_product_attribute` as pai_id_product_attribute, "XX" as `is_color_group`, "spa-nochanges" as `id_product_pack`, product_attribute_shop.`price` AS `spa_sort_column`, XX AS spa_eligible_product FROM `xjXX_category_product` cp RIGHT JOIN `xjXX_category` c ON (c.`id_category` = cp.`id_category` AND c.nleft >= XX AND c.nright <= XX) LEFT JOIN `xjXX_product` p ON p.`id_product` = cp.`id_product` INNER JOIN xjXX_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = XX) LEFT JOIN `xjXX_category_lang` cl ON (product_shop.`id_category_default` = cl.`id_category` AND cl.`id_lang` = XX AND cl.id_shop = XX ) LEFT JOIN `xjXX_product_lang` pl ON (p.`id_product` = pl.`id_product` AND pl.`id_lang` = XX AND pl.id_shop = XX ) LEFT JOIN `xjXX_image_shop` image_shop ON (image_shop.`id_product` = p.`id_product` AND image_shop.cover=XX AND image_shop.id_shop=XX) LEFT JOIN `xjXX_image_lang` il ON (image_shop.`id_image` = il.`id_image` AND il.`id_lang` = XX) LEFT JOIN `xjXX_manufacturer` m ON m.`id_manufacturer` = p.`id_manufacturer` LEFT JOIN `xjXX_product_attribute` pa ON pa.`id_product` = p.`id_product` LEFT JOIN `xjXX_product_attribute_combination` pac ON pac.`id_product_attribute` = pa.`id_product_attribute` LEFT JOIN `xjXX_attribute` a ON a.`id_attribute` = pac.`id_attribute` AND (a.`id_attribute_group` IN (XX)) LEFT JOIN `xjXX_product_attribute_shop` product_attribute_shop ON (p.`id_product` = product_attribute_shop.`id_product` AND product_attribute_shop.`id_product_attribute` = pac.`id_product_attribute` AND product_attribute_shop.`default_on` = XX AND product_attribute_shop.id_shop=XX) LEFT JOIN xjXX_stock_available stock ON (stock.id_product = `p`.id_product AND stock.id_product_attribute = XX AND stock.id_shop = XX AND stock.id_shop_group = XX ) WHERE product_shop.`id_shop` = XX AND product_shop.`active` = XX AND cp.`id_category` = XX AND product_shop.`visibility` IN ("both", "catalog") GROUP BY cp.id_product HAVING (COUNT(a.`id_attribute`) = XX) ) ORDER BY `order_value` ASC, `spa_sort_column` ASC LIMIT XX,XX
2 queries	SELECT id_st_sticker FROM `xjXX_st_sticker_map` WHERE active = XX AND (location = XX OR (location = XX AND (id_manufacturer = XX OR id_manufacturer=XX)) OR (location = XX AND (id_category = XX OR id_category IN(XX,XX,XX,XX,XX,XX,XX,XX,XX,XX,XX,XX,XX,XX))) OR (location = XX AND (id_products LIKE "%,XX,%")))
2 queries	SELECT snl., snll. FROM `xjXX_st_notification` snl INNER JOIN xjXX_st_notification_shop st_notification_shop ON (st_notification_shop.id_st_notification = snl.id_st_notification AND st_notification_shop.id_shop = XX) LEFT JOIN `xjXX_st_notification_lang` snll ON (snl.`id_st_notification` = snll.`id_st_notification`) WHERE snl.`active`=XX AND snll.`id_lang` = XX ORDER BY snl.`position`
2 queries	SELECT snl., snll. FROM `xjXX_st_sidebar` snl INNER JOIN xjXX_st_sidebar_shop st_sidebar_shop ON (st_sidebar_shop.id_st_sidebar = snl.id_st_sidebar AND st_sidebar_shop.id_shop = XX) LEFT JOIN `xjXX_st_sidebar_lang` snll ON (snl.`id_st_sidebar` = snll.`id_st_sidebar`) WHERE snll.`id_lang` = XX AND snl.`active`=XX ORDER BY snl.`location`, snl.`position`
2 queries	SELECT g., gl. FROM `xjXX_group` g LEFT JOIN `xjXX_group_lang` gl ON (g.`id_group` = gl.`id_group`) WHERE `name` = 'cse' LIMIT XX
2 queries	SELECT * FROM `xjXX_st_loved_product` WHERE `type`=XX AND `id_shop`=XX AND ( `id_guest` = XX) ORDER BY date_add DESC LIMIT XX

Name	Instances	Source
Product	272	/classes/Link.php:113 (__construct) [id: 9060] /classes/Link.php:113 (__construct) [id: 9061] /classes/Link.php:113 (__construct) [id: 9062] /classes/Link.php:113 (__construct) [id: 9063] /classes/Link.php:113 (__construct) [id: 9065] /classes/Link.php:113 (__construct) [id: 9066] /classes/Link.php:113 (__construct) [id: 16535] /classes/Link.php:113 (__construct) [id: 16536] /classes/Link.php:113 (__construct) [id: 16538] /classes/Link.php:113 (__construct) [id: 9058] /classes/Link.php:113 (__construct) [id: 9059] /classes/Link.php:113 (__construct) [id: 9052] /classes/Link.php:113 (__construct) [id: 9067] /classes/Link.php:113 (__construct) [id: 7712] /classes/Link.php:113 (__construct) [id: 65834] /classes/Link.php:113 (__construct) [id: 65840] /classes/Link.php:113 (__construct) [id: 9060] /classes/Link.php:113 (__construct) [id: 9061] /classes/Link.php:113 (__construct) [id: 9062] /classes/Link.php:113 (__construct) [id: 9063] /classes/Link.php:113 (__construct) [id: 9065] /classes/Link.php:113 (__construct) [id: 9066] /classes/Link.php:113 (__construct) [id: 16535] /classes/Link.php:113 (__construct) [id: 16536] /classes/Link.php:113 (__construct) [id: 16538] /classes/Link.php:113 (__construct) [id: 9058] /classes/Link.php:113 (__construct) [id: 9059] /classes/Link.php:113 (__construct) [id: 9052] /classes/Link.php:113 (__construct) [id: 9067] /classes/Link.php:113 (__construct) [id: 7712] /classes/Link.php:113 (__construct) [id: 65834] /classes/Link.php:113 (__construct) [id: 65840] /classes/Link.php:113 (__construct) [id: 9060] /classes/Link.php:113 (__construct) [id: 9061] /classes/Link.php:113 (__construct) [id: 9062] /classes/Link.php:113 (__construct) [id: 9063] /classes/Link.php:113 (__construct) [id: 9065] /classes/Link.php:113 (__construct) [id: 9066] /classes/Link.php:113 (__construct) [id: 16535] /classes/Link.php:113 (__construct) [id: 16536] /classes/Link.php:113 (__construct) [id: 16538] /classes/Link.php:113 (__construct) [id: 9058] /classes/Link.php:113 (__construct) [id: 9059] /classes/Link.php:113 (__construct) [id: 9052] /classes/Link.php:113 (__construct) [id: 9067] /classes/Link.php:113 (__construct) [id: 7712] /classes/Link.php:113 (__construct) [id: 65834] /classes/Link.php:113 (__construct) [id: 65840] /modules/ststickers/classes/StStickersMapClass.php:152 (__construct) [id: 9060] /modules/ststickers/classes/StStickersMapClass.php:152 (__construct) [id: 9061] /modules/ststickers/classes/StStickersMapClass.php:152 (__construct) [id: 9062] /modules/ststickers/classes/StStickersMapClass.php:152 (__construct) [id: 9063] /modules/ststickers/classes/StStickersMapClass.php:152 (__construct) [id: 9065] /modules/ststickers/classes/StStickersMapClass.php:152 (__construct) [id: 9066] /modules/ststickers/classes/StStickersMapClass.php:152 (__construct) [id: 16535] /modules/ststickers/classes/StStickersMapClass.php:152 (__construct) [id: 16536] /modules/ststickers/classes/StStickersMapClass.php:152 (__construct) [id: 16538] /modules/ststickers/classes/StStickersMapClass.php:152 (__construct) [id: 9058] /modules/ststickers/classes/StStickersMapClass.php:152 (__construct) [id: 9059] /modules/ststickers/classes/StStickersMapClass.php:152 (__construct) [id: 9052] /modules/ststickers/classes/StStickersMapClass.php:152 (__construct) [id: 9067] /modules/ststickers/classes/StStickersMapClass.php:152 (__construct) [id: 7712] /modules/ststickers/classes/StStickersMapClass.php:152 (__construct) [id: 65834] /modules/ststickers/classes/StStickersMapClass.php:152 (__construct) [id: 65840] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 9060] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 9061] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 9062] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 9063] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 9065] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 9066] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 16535] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 16536] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 16538] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 9058] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 9059] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 9052] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 9067] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 7712] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 65834] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 65840] /modules/cdc_googletagmanager/services/Gtm_Product.php:164 (__construct) [id: 9060] /modules/cdc_googletagmanager/services/Gtm_Product.php:164 (__construct) [id: 9061] /modules/cdc_googletagmanager/services/Gtm_Product.php:164 (__construct) [id: 9062] /modules/cdc_googletagmanager/services/Gtm_Product.php:164 (__construct) [id: 9063] /modules/cdc_googletagmanager/services/Gtm_Product.php:164 (__construct) [id: 9065] /modules/cdc_googletagmanager/services/Gtm_Product.php:164 (__construct) [id: 9066] /modules/cdc_googletagmanager/services/Gtm_Product.php:164 (__construct) [id: 16535] /modules/cdc_googletagmanager/services/Gtm_Product.php:164 (__construct) [id: 16536] /modules/cdc_googletagmanager/services/Gtm_Product.php:164 (__construct) [id: 16538] /modules/cdc_googletagmanager/services/Gtm_Product.php:164 (__construct) [id: 9058] /modules/cdc_googletagmanager/services/Gtm_Product.php:164 (__construct) [id: 9059] /modules/cdc_googletagmanager/services/Gtm_Product.php:164 (__construct) [id: 9052] /modules/cdc_googletagmanager/services/Gtm_Product.php:164 (__construct) [id: 9067] /modules/cdc_googletagmanager/services/Gtm_Product.php:164 (__construct) [id: 7712] /modules/cdc_googletagmanager/services/Gtm_Product.php:164 (__construct) [id: 65834] /modules/cdc_googletagmanager/services/Gtm_Product.php:164 (__construct) [id: 65840] /classes/Link.php:113 (__construct) [id: 9060] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 9060] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 9060] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 9060] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 9060] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 9060] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 9060] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 9060] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 9060] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 9060] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 9060] /classes/Link.php:113 (__construct) [id: 9061] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 9061] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 9061] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 9061] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 9061] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 9061] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 9061] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 9061] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 9061] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 9061] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 9061] /classes/Link.php:113 (__construct) [id: 9062] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 9062] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 9062] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 9062] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 9062] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 9062] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 9062] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 9062] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 9062] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 9062] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 9062] /classes/Link.php:113 (__construct) [id: 9063] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 9063] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 9063] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 9063] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 9063] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 9063] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 9063] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 9063] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 9063] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 9063] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 9063] /classes/Link.php:113 (__construct) [id: 9065] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 9065] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 9065] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 9065] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 9065] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 9065] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 9065] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 9065] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 9065] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 9065] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 9065] /classes/Link.php:113 (__construct) [id: 9066] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 9066] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 9066] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 9066] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 9066] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 9066] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 9066] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 9066] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 9066] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 9066] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 9066] /classes/Link.php:113 (__construct) [id: 16535] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 16535] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 16535] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 16535] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 16535] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 16535] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 16535] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 16535] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 16535] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 16535] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 16535] /classes/Link.php:113 (__construct) [id: 16536] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 16536] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 16536] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 16536] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 16536] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 16536] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 16536] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 16536] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 16536] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 16536] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 16536] /classes/Link.php:113 (__construct) [id: 16538] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 16538] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 16538] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 16538] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 16538] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 16538] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 16538] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 16538] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 16538] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 16538] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 16538] /classes/Link.php:113 (__construct) [id: 9058] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 9058] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 9058] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 9058] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 9058] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 9058] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 9058] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 9058] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 9058] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 9058] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 9058] /classes/Link.php:113 (__construct) [id: 9059] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 9059] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 9059] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 9059] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 9059] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 9059] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 9059] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 9059] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 9059] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 9059] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 9059] /classes/Link.php:113 (__construct) [id: 9052] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 9052] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 9052] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 9052] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 9052] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 9052] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 9052] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 9052] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 9052] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 9052] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 9052] /classes/Link.php:113 (__construct) [id: 9067] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 9067] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 9067] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 9067] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 9067] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 9067] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 9067] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 9067] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 9067] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 9067] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 9067] /classes/Link.php:113 (__construct) [id: 7712] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 7712] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 7712] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 7712] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 7712] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 7712] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 7712] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 7712] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 7712] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 7712] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 7712] /classes/Link.php:113 (__construct) [id: 65834] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 65834] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 65834] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 65834] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 65834] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 65834] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 65834] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 65834] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 65834] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 65834] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 65834] /classes/Link.php:113 (__construct) [id: 65840] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 65840] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 65840] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 65840] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 65840] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 65840] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 65840] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 65840] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 65840] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 65840] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 65840]
Category	229	/controllers/front/listing/CategoryController.php:78 (__construct) [id: 2531] /classes/Meta.php:380 (__construct) [id: 2531] /classes/PrestaShopCollection.php:385 (hydrateCollection) [id: ] /classes/PrestaShopCollection.php:385 (hydrateCollection) [id: ] /classes/PrestaShopCollection.php:385 (hydrateCollection) [id: ] /classes/PrestaShopCollection.php:385 (hydrateCollection) [id: ] /modules/stsocial/stsocial.php:1288 (__construct) [id: 2531] /modules/facebookproductad/lib/pixel/pixelCategory.php:46 (__construct) [id: 2531] /modules/facebookproductad/lib/moduleTools.php:468 (__construct) [id: 2531] /modules/facebookproductad/lib/pixel/pixelCategory.php:46 (__construct) [id: 2531] /modules/facebookproductad/lib/moduleTools.php:468 (__construct) [id: 2531] /modules/pm_productsbyattributes/src/Pm_ProductsByAttributesProductSearchProvider.php:53 (__construct) [id: 2531] /modules/pm_productsbyattributes/src/Pm_ProductsByAttributesProductSearchProvider.php:53 (__construct) [id: 2531] /modules/pm_productsbyattributes/pm_productsbyattributes.php:741 (__construct) [id: 2531] /modules/pm_productsbyattributes/pm_productsbyattributes.php:741 (__construct) [id: 2531] /modules/pm_productsbyattributes/pm_productsbyattributes.php:741 (__construct) [id: 2531] /modules/pm_productsbyattributes/pm_productsbyattributes.php:741 (__construct) [id: 2531] /modules/pm_productsbyattributes/pm_productsbyattributes.php:741 (__construct) [id: 2531] /modules/ststickers/classes/StStickersMapClass.php:159 (__construct) [id: 3] /modules/ststickers/classes/StStickersMapClass.php:168 (getParentsCategories) [id: 2] /modules/ststickers/classes/StStickersMapClass.php:159 (__construct) [id: 37] /modules/ststickers/classes/StStickersMapClass.php:168 (getParentsCategories) [id: 2] /modules/ststickers/classes/StStickersMapClass.php:159 (__construct) [id: 2517] /modules/ststickers/classes/StStickersMapClass.php:168 (getParentsCategories) [id: 2] /modules/ststickers/classes/StStickersMapClass.php:159 (__construct) [id: 2529] /modules/ststickers/classes/StStickersMapClass.php:168 (getParentsCategories) [id: 2] /modules/ststickers/classes/StStickersMapClass.php:159 (__construct) [id: 2531] /modules/ststickers/classes/StStickersMapClass.php:168 (getParentsCategories) [id: 2] /modules/ststickers/classes/StStickersMapClass.php:159 (__construct) [id: 3] /modules/ststickers/classes/StStickersMapClass.php:168 (getParentsCategories) [id: 2] /modules/ststickers/classes/StStickersMapClass.php:159 (__construct) [id: 37] /modules/ststickers/classes/StStickersMapClass.php:168 (getParentsCategories) [id: 2] /modules/ststickers/classes/StStickersMapClass.php:159 (__construct) [id: 2517] /modules/ststickers/classes/StStickersMapClass.php:168 (getParentsCategories) [id: 2] /modules/ststickers/classes/StStickersMapClass.php:159 (__construct) [id: 2529] /modules/ststickers/classes/StStickersMapClass.php:168 (getParentsCategories) [id: 2] /modules/ststickers/classes/StStickersMapClass.php:159 (__construct) [id: 2531] /modules/ststickers/classes/StStickersMapClass.php:168 (getParentsCategories) [id: 2] /modules/ststickers/classes/StStickersMapClass.php:159 (__construct) [id: 3] /modules/ststickers/classes/StStickersMapClass.php:168 (getParentsCategories) [id: 2] /modules/ststickers/classes/StStickersMapClass.php:159 (__construct) [id: 37] /modules/ststickers/classes/StStickersMapClass.php:168 (getParentsCategories) [id: 2] /modules/ststickers/classes/StStickersMapClass.php:159 (__construct) [id: 2517] /modules/ststickers/classes/StStickersMapClass.php:168 (getParentsCategories) [id: 2] /modules/ststickers/classes/StStickersMapClass.php:159 (__construct) [id: 2529] /modules/ststickers/classes/StStickersMapClass.php:168 (getParentsCategories) [id: 2] /modules/ststickers/classes/StStickersMapClass.php:159 (__construct) [id: 2531] /modules/ststickers/classes/StStickersMapClass.php:168 (getParentsCategories) [id: 2] /modules/ststickers/classes/StStickersMapClass.php:159 (__construct) [id: 3] /modules/ststickers/classes/StStickersMapClass.php:168 (getParentsCategories) [id: 2] /modules/ststickers/classes/StStickersMapClass.php:159 (__construct) [id: 37] /modules/ststickers/classes/StStickersMapClass.php:168 (getParentsCategories) [id: 2] /modules/ststickers/classes/StStickersMapClass.php:159 (__construct) [id: 2517] /modules/ststickers/classes/StStickersMapClass.php:168 (getParentsCategories) [id: 2] /modules/ststickers/classes/StStickersMapClass.php:159 (__construct) [id: 2529] /modules/ststickers/classes/StStickersMapClass.php:168 (getParentsCategories) [id: 2] /modules/ststickers/classes/StStickersMapClass.php:159 (__construct) [id: 2531] /modules/ststickers/classes/StStickersMapClass.php:168 (getParentsCategories) [id: 2] /modules/ststickers/classes/StStickersMapClass.php:159 (__construct) [id: 3] /modules/ststickers/classes/StStickersMapClass.php:168 (getParentsCategories) [id: 2] /modules/ststickers/classes/StStickersMapClass.php:159 (__construct) [id: 37] /modules/ststickers/classes/StStickersMapClass.php:168 (getParentsCategories) [id: 2] /modules/ststickers/classes/StStickersMapClass.php:159 (__construct) [id: 2517] /modules/ststickers/classes/StStickersMapClass.php:168 (getParentsCategories) [id: 2] /modules/ststickers/classes/StStickersMapClass.php:159 (__construct) [id: 2529] /modules/ststickers/classes/StStickersMapClass.php:168 (getParentsCategories) [id: 2] /modules/ststickers/classes/StStickersMapClass.php:159 (__construct) [id: 2531] /modules/ststickers/classes/StStickersMapClass.php:168 (getParentsCategories) [id: 2] /modules/ststickers/classes/StStickersMapClass.php:159 (__construct) [id: 37] /modules/ststickers/classes/StStickersMapClass.php:168 (getParentsCategories) [id: 2] /modules/ststickers/classes/StStickersMapClass.php:159 (__construct) [id: 2517] /modules/ststickers/classes/StStickersMapClass.php:168 (getParentsCategories) [id: 2] /modules/ststickers/classes/StStickersMapClass.php:159 (__construct) [id: 2529] /modules/ststickers/classes/StStickersMapClass.php:168 (getParentsCategories) [id: 2] /modules/ststickers/classes/StStickersMapClass.php:159 (__construct) [id: 2531] /modules/ststickers/classes/StStickersMapClass.php:168 (getParentsCategories) [id: 2] /modules/ststickers/classes/StStickersMapClass.php:159 (__construct) [id: 37] /modules/ststickers/classes/StStickersMapClass.php:168 (getParentsCategories) [id: 2] /modules/ststickers/classes/StStickersMapClass.php:159 (__construct) [id: 2517] /modules/ststickers/classes/StStickersMapClass.php:168 (getParentsCategories) [id: 2] /modules/ststickers/classes/StStickersMapClass.php:159 (__construct) [id: 2529] /modules/ststickers/classes/StStickersMapClass.php:168 (getParentsCategories) [id: 2] /modules/ststickers/classes/StStickersMapClass.php:159 (__construct) [id: 2531] /modules/ststickers/classes/StStickersMapClass.php:168 (getParentsCategories) [id: 2] /modules/ststickers/classes/StStickersMapClass.php:159 (__construct) [id: 37] /modules/ststickers/classes/StStickersMapClass.php:168 (getParentsCategories) [id: 2] /modules/ststickers/classes/StStickersMapClass.php:159 (__construct) [id: 2517] /modules/ststickers/classes/StStickersMapClass.php:168 (getParentsCategories) [id: 2] /modules/ststickers/classes/StStickersMapClass.php:159 (__construct) [id: 2529] /modules/ststickers/classes/StStickersMapClass.php:168 (getParentsCategories) [id: 2] /modules/ststickers/classes/StStickersMapClass.php:159 (__construct) [id: 2531] /modules/ststickers/classes/StStickersMapClass.php:168 (getParentsCategories) [id: 2] /modules/ststickers/classes/StStickersMapClass.php:159 (__construct) [id: 37] /modules/ststickers/classes/StStickersMapClass.php:168 (getParentsCategories) [id: 2] /modules/ststickers/classes/StStickersMapClass.php:159 (__construct) [id: 2517] /modules/ststickers/classes/StStickersMapClass.php:168 (getParentsCategories) [id: 2] /modules/ststickers/classes/StStickersMapClass.php:159 (__construct) [id: 2529] /modules/ststickers/classes/StStickersMapClass.php:168 (getParentsCategories) [id: 2] /modules/ststickers/classes/StStickersMapClass.php:159 (__construct) [id: 2531] /modules/ststickers/classes/StStickersMapClass.php:168 (getParentsCategories) [id: 2] /modules/ststickers/classes/StStickersMapClass.php:159 (__construct) [id: 3] /modules/ststickers/classes/StStickersMapClass.php:168 (getParentsCategories) [id: 2] /modules/ststickers/classes/StStickersMapClass.php:159 (__construct) [id: 37] /modules/ststickers/classes/StStickersMapClass.php:168 (getParentsCategories) [id: 2] /modules/ststickers/classes/StStickersMapClass.php:159 (__construct) [id: 2517] /modules/ststickers/classes/StStickersMapClass.php:168 (getParentsCategories) [id: 2] /modules/ststickers/classes/StStickersMapClass.php:159 (__construct) [id: 2529] /modules/ststickers/classes/StStickersMapClass.php:168 (getParentsCategories) [id: 2] /modules/ststickers/classes/StStickersMapClass.php:159 (__construct) [id: 2531] /modules/ststickers/classes/StStickersMapClass.php:168 (getParentsCategories) [id: 2] /modules/ststickers/classes/StStickersMapClass.php:159 (__construct) [id: 3] /modules/ststickers/classes/StStickersMapClass.php:168 (getParentsCategories) [id: 2] /modules/ststickers/classes/StStickersMapClass.php:159 (__construct) [id: 37] /modules/ststickers/classes/StStickersMapClass.php:168 (getParentsCategories) [id: 2] /modules/ststickers/classes/StStickersMapClass.php:159 (__construct) [id: 2517] /modules/ststickers/classes/StStickersMapClass.php:168 (getParentsCategories) [id: 2] /modules/ststickers/classes/StStickersMapClass.php:159 (__construct) [id: 2529] /modules/ststickers/classes/StStickersMapClass.php:168 (getParentsCategories) [id: 2] /modules/ststickers/classes/StStickersMapClass.php:159 (__construct) [id: 2531] /modules/ststickers/classes/StStickersMapClass.php:168 (getParentsCategories) [id: 2] /modules/ststickers/classes/StStickersMapClass.php:159 (__construct) [id: 3] /modules/ststickers/classes/StStickersMapClass.php:168 (getParentsCategories) [id: 2] /modules/ststickers/classes/StStickersMapClass.php:159 (__construct) [id: 37] /modules/ststickers/classes/StStickersMapClass.php:168 (getParentsCategories) [id: 2] /modules/ststickers/classes/StStickersMapClass.php:159 (__construct) [id: 2517] /modules/ststickers/classes/StStickersMapClass.php:168 (getParentsCategories) [id: 2] /modules/ststickers/classes/StStickersMapClass.php:159 (__construct) [id: 2529] /modules/ststickers/classes/StStickersMapClass.php:168 (getParentsCategories) [id: 2] /modules/ststickers/classes/StStickersMapClass.php:159 (__construct) [id: 2531] /modules/ststickers/classes/StStickersMapClass.php:168 (getParentsCategories) [id: 2] /modules/ststickers/classes/StStickersMapClass.php:159 (__construct) [id: 3] /modules/ststickers/classes/StStickersMapClass.php:168 (getParentsCategories) [id: 2] /modules/ststickers/classes/StStickersMapClass.php:159 (__construct) [id: 37] /modules/ststickers/classes/StStickersMapClass.php:168 (getParentsCategories) [id: 2] /modules/ststickers/classes/StStickersMapClass.php:159 (__construct) [id: 2517] /modules/ststickers/classes/StStickersMapClass.php:168 (getParentsCategories) [id: 2] /modules/ststickers/classes/StStickersMapClass.php:159 (__construct) [id: 2529] /modules/ststickers/classes/StStickersMapClass.php:168 (getParentsCategories) [id: 2] /modules/ststickers/classes/StStickersMapClass.php:159 (__construct) [id: 2531] /modules/ststickers/classes/StStickersMapClass.php:168 (getParentsCategories) [id: 2] /modules/ststickers/classes/StStickersMapClass.php:159 (__construct) [id: 2] /modules/ststickers/classes/StStickersMapClass.php:168 (getParentsCategories) [id: 2] /modules/ststickers/classes/StStickersMapClass.php:159 (__construct) [id: 3] /modules/ststickers/classes/StStickersMapClass.php:168 (getParentsCategories) [id: 2] /modules/ststickers/classes/StStickersMapClass.php:159 (__construct) [id: 2451] /modules/ststickers/classes/StStickersMapClass.php:168 (getParentsCategories) [id: 2] /modules/ststickers/classes/StStickersMapClass.php:159 (__construct) [id: 2517] /modules/ststickers/classes/StStickersMapClass.php:168 (getParentsCategories) [id: 2] /modules/ststickers/classes/StStickersMapClass.php:159 (__construct) [id: 2529] /modules/ststickers/classes/StStickersMapClass.php:168 (getParentsCategories) [id: 2] /modules/ststickers/classes/StStickersMapClass.php:159 (__construct) [id: 2531] /modules/ststickers/classes/StStickersMapClass.php:168 (getParentsCategories) [id: 2] /modules/ststickers/classes/StStickersMapClass.php:159 (__construct) [id: 6665] /modules/ststickers/classes/StStickersMapClass.php:159 (__construct) [id: 2] /modules/ststickers/classes/StStickersMapClass.php:168 (getParentsCategories) [id: 2] /modules/ststickers/classes/StStickersMapClass.php:159 (__construct) [id: 9] /modules/ststickers/classes/StStickersMapClass.php:168 (getParentsCategories) [id: 2] /modules/ststickers/classes/StStickersMapClass.php:159 (__construct) [id: 2517] /modules/ststickers/classes/StStickersMapClass.php:168 (getParentsCategories) [id: 2] /modules/ststickers/classes/StStickersMapClass.php:159 (__construct) [id: 2529] /modules/ststickers/classes/StStickersMapClass.php:168 (getParentsCategories) [id: 2] /modules/ststickers/classes/StStickersMapClass.php:159 (__construct) [id: 2530] /modules/ststickers/classes/StStickersMapClass.php:168 (getParentsCategories) [id: 2] /modules/ststickers/classes/StStickersMapClass.php:159 (__construct) [id: 2531] /modules/ststickers/classes/StStickersMapClass.php:168 (getParentsCategories) [id: 2] /modules/ststickers/classes/StStickersMapClass.php:159 (__construct) [id: 2532] /modules/ststickers/classes/StStickersMapClass.php:168 (getParentsCategories) [id: 2] /modules/ststickers/classes/StStickersMapClass.php:159 (__construct) [id: 2537] /modules/ststickers/classes/StStickersMapClass.php:168 (getParentsCategories) [id: 2] /modules/ststickers/classes/StStickersMapClass.php:159 (__construct) [id: 2547] /modules/ststickers/classes/StStickersMapClass.php:168 (getParentsCategories) [id: 2] /modules/ststickers/classes/StStickersMapClass.php:159 (__construct) [id: 2549] /modules/ststickers/classes/StStickersMapClass.php:159 (__construct) [id: 2] /modules/ststickers/classes/StStickersMapClass.php:168 (getParentsCategories) [id: 2] /modules/ststickers/classes/StStickersMapClass.php:159 (__construct) [id: 9] /modules/ststickers/classes/StStickersMapClass.php:168 (getParentsCategories) [id: 2] /modules/ststickers/classes/StStickersMapClass.php:159 (__construct) [id: 2517] /modules/ststickers/classes/StStickersMapClass.php:168 (getParentsCategories) [id: 2] /modules/ststickers/classes/StStickersMapClass.php:159 (__construct) [id: 2529] /modules/ststickers/classes/StStickersMapClass.php:168 (getParentsCategories) [id: 2] /modules/ststickers/classes/StStickersMapClass.php:159 (__construct) [id: 2530] /modules/ststickers/classes/StStickersMapClass.php:168 (getParentsCategories) [id: 2] /modules/ststickers/classes/StStickersMapClass.php:159 (__construct) [id: 2531] /modules/ststickers/classes/StStickersMapClass.php:168 (getParentsCategories) [id: 2] /modules/ststickers/classes/StStickersMapClass.php:159 (__construct) [id: 2532] /modules/ststickers/classes/StStickersMapClass.php:168 (getParentsCategories) [id: 2] /modules/ststickers/classes/StStickersMapClass.php:159 (__construct) [id: 2537] /modules/ststickers/classes/StStickersMapClass.php:168 (getParentsCategories) [id: 2] /modules/ststickers/classes/StStickersMapClass.php:159 (__construct) [id: 2547] /modules/ststickers/classes/StStickersMapClass.php:168 (getParentsCategories) [id: 2] /modules/ststickers/classes/StStickersMapClass.php:159 (__construct) [id: 2549] /modules/cdc_googletagmanager/cdc_googletagmanager.php:1329 (__construct) [id: 2531] /modules/cdc_googletagmanager/cdc_googletagmanager.php:1357 (getParentsCategories) [id: 2] /modules/cdc_googletagmanager/classes/gtm/DataLayerItem.php:109 (__construct) [id: 2517] /modules/cdc_googletagmanager/cdc_googletagmanager.php:1390 (__construct) [id: 2] /modules/cdc_googletagmanager/classes/gtm/DataLayerItem.php:109 (__construct) [id: 2517] /modules/cdc_googletagmanager/classes/gtm/DataLayerItem.php:109 (__construct) [id: 2517] /modules/cdc_googletagmanager/classes/gtm/DataLayerItem.php:109 (__construct) [id: 2517] /modules/cdc_googletagmanager/classes/gtm/DataLayerItem.php:109 (__construct) [id: 2517] /modules/cdc_googletagmanager/classes/gtm/DataLayerItem.php:109 (__construct) [id: 2517] /modules/cdc_googletagmanager/classes/gtm/DataLayerItem.php:109 (__construct) [id: 2517] /modules/cdc_googletagmanager/classes/gtm/DataLayerItem.php:109 (__construct) [id: 2517] /modules/cdc_googletagmanager/classes/gtm/DataLayerItem.php:109 (__construct) [id: 2517] /modules/cdc_googletagmanager/classes/gtm/DataLayerItem.php:109 (__construct) [id: 3] /modules/cdc_googletagmanager/classes/gtm/DataLayerItem.php:109 (__construct) [id: 3] /modules/cdc_googletagmanager/classes/gtm/DataLayerItem.php:109 (__construct) [id: 3] /modules/cdc_googletagmanager/classes/gtm/DataLayerItem.php:109 (__construct) [id: 2517] /modules/cdc_googletagmanager/classes/gtm/DataLayerItem.php:109 (__construct) [id: 2451] /modules/cdc_googletagmanager/cdc_googletagmanager.php:1339 (__construct) [id: 11] /modules/cdc_googletagmanager/cdc_googletagmanager.php:1339 (__construct) [id: 3] /modules/cdc_googletagmanager/cdc_googletagmanager.php:1339 (__construct) [id: 11] /modules/cdc_googletagmanager/classes/gtm/DataLayerItem.php:109 (__construct) [id: 2549] /modules/cdc_googletagmanager/cdc_googletagmanager.php:1339 (__construct) [id: 2547] /modules/cdc_googletagmanager/cdc_googletagmanager.php:1339 (__construct) [id: 9] /modules/cdc_googletagmanager/cdc_googletagmanager.php:1339 (__construct) [id: 2547] /modules/cdc_googletagmanager/classes/gtm/DataLayerItem.php:109 (__construct) [id: 2549] /modules/cdc_googletagmanager/cdc_googletagmanager.php:1339 (__construct) [id: 2547] /modules/cdc_googletagmanager/cdc_googletagmanager.php:1339 (__construct) [id: 9] /modules/cdc_googletagmanager/cdc_googletagmanager.php:1339 (__construct) [id: 2547] /modules/cdc_googletagmanager/cdc_googletagmanager.php:1329 (__construct) [id: 2531] /modules/cdc_googletagmanager/cdc_googletagmanager.php:1357 (getParentsCategories) [id: 2] /modules/stswiper/classes/StSwiperGroup.php:244 (__construct) [id: 2531] /modules/stswiper/classes/StSwiperGroup.php:245 (getParentsCategories) [id: 2] /modules/stowlcarousel/classes/StOwlCarouselGroup.php:239 (__construct) [id: 2531] /modules/stowlcarousel/classes/StOwlCarouselGroup.php:240 (getParentsCategories) [id: 2] /modules/stbanner/classes/StBannerGroup.php:288 (__construct) [id: 2531] /modules/stbanner/classes/StBannerGroup.php:289 (getParentsCategories) [id: 2] /modules/stpagebanner/classes/StPageBannerClass.php:168 (__construct) [id: 2531] /modules/stpagebanner/classes/StPageBannerClass.php:173 (getParentsCategories) [id: 2]
ProductSupplier	80	/classes/PrestaShopCollection.php:385 (hydrateCollection) [id: ] /classes/PrestaShopCollection.php:385 (hydrateCollection) [id: ] /classes/PrestaShopCollection.php:385 (hydrateCollection) [id: ] /classes/PrestaShopCollection.php:385 (hydrateCollection) [id: ] /classes/PrestaShopCollection.php:385 (hydrateCollection) [id: ] /classes/PrestaShopCollection.php:385 (hydrateCollection) [id: ] /classes/PrestaShopCollection.php:385 (hydrateCollection) [id: ] /classes/PrestaShopCollection.php:385 (hydrateCollection) [id: ] /classes/PrestaShopCollection.php:385 (hydrateCollection) [id: ] /classes/PrestaShopCollection.php:385 (hydrateCollection) [id: ] /classes/PrestaShopCollection.php:385 (hydrateCollection) [id: ] /classes/PrestaShopCollection.php:385 (hydrateCollection) [id: ] /classes/PrestaShopCollection.php:385 (hydrateCollection) [id: ] /classes/PrestaShopCollection.php:385 (hydrateCollection) [id: ] /classes/PrestaShopCollection.php:385 (hydrateCollection) [id: ] /classes/PrestaShopCollection.php:385 (hydrateCollection) [id: ] /classes/PrestaShopCollection.php:385 (hydrateCollection) [id: ] /classes/PrestaShopCollection.php:385 (hydrateCollection) [id: ] /classes/PrestaShopCollection.php:385 (hydrateCollection) [id: ] /classes/PrestaShopCollection.php:385 (hydrateCollection) [id: ] /classes/PrestaShopCollection.php:385 (hydrateCollection) [id: ] /classes/PrestaShopCollection.php:385 (hydrateCollection) [id: ] /classes/PrestaShopCollection.php:385 (hydrateCollection) [id: ] /classes/PrestaShopCollection.php:385 (hydrateCollection) [id: ] /classes/PrestaShopCollection.php:385 (hydrateCollection) [id: ] /classes/PrestaShopCollection.php:385 (hydrateCollection) [id: ] /classes/PrestaShopCollection.php:385 (hydrateCollection) [id: ] /classes/PrestaShopCollection.php:385 (hydrateCollection) [id: ] /classes/PrestaShopCollection.php:385 (hydrateCollection) [id: ] /classes/PrestaShopCollection.php:385 (hydrateCollection) [id: ] /classes/PrestaShopCollection.php:385 (hydrateCollection) [id: ] /classes/PrestaShopCollection.php:385 (hydrateCollection) [id: ] /classes/PrestaShopCollection.php:385 (hydrateCollection) [id: ] /classes/PrestaShopCollection.php:385 (hydrateCollection) [id: ] /classes/PrestaShopCollection.php:385 (hydrateCollection) [id: ] /classes/PrestaShopCollection.php:385 (hydrateCollection) [id: ] /classes/PrestaShopCollection.php:385 (hydrateCollection) [id: ] /classes/PrestaShopCollection.php:385 (hydrateCollection) [id: ] /classes/PrestaShopCollection.php:385 (hydrateCollection) [id: ] /classes/PrestaShopCollection.php:385 (hydrateCollection) [id: ] /classes/PrestaShopCollection.php:385 (hydrateCollection) [id: ] /classes/PrestaShopCollection.php:385 (hydrateCollection) [id: ] /classes/PrestaShopCollection.php:385 (hydrateCollection) [id: ] /classes/PrestaShopCollection.php:385 (hydrateCollection) [id: ] /classes/PrestaShopCollection.php:385 (hydrateCollection) [id: ] /classes/PrestaShopCollection.php:385 (hydrateCollection) [id: ] /classes/PrestaShopCollection.php:385 (hydrateCollection) [id: ] /classes/PrestaShopCollection.php:385 (hydrateCollection) [id: ] /classes/PrestaShopCollection.php:385 (hydrateCollection) [id: ] /classes/PrestaShopCollection.php:385 (hydrateCollection) [id: ] /classes/PrestaShopCollection.php:385 (hydrateCollection) [id: ] /classes/PrestaShopCollection.php:385 (hydrateCollection) [id: ] /classes/PrestaShopCollection.php:385 (hydrateCollection) [id: ] /classes/PrestaShopCollection.php:385 (hydrateCollection) [id: ] /classes/PrestaShopCollection.php:385 (hydrateCollection) [id: ] /classes/PrestaShopCollection.php:385 (hydrateCollection) [id: ] /classes/PrestaShopCollection.php:385 (hydrateCollection) [id: ] /classes/PrestaShopCollection.php:385 (hydrateCollection) [id: ] /classes/PrestaShopCollection.php:385 (hydrateCollection) [id: ] /classes/PrestaShopCollection.php:385 (hydrateCollection) [id: ] /classes/PrestaShopCollection.php:385 (hydrateCollection) [id: ] /classes/PrestaShopCollection.php:385 (hydrateCollection) [id: ] /classes/PrestaShopCollection.php:385 (hydrateCollection) [id: ] /classes/PrestaShopCollection.php:385 (hydrateCollection) [id: ] /classes/PrestaShopCollection.php:385 (hydrateCollection) [id: ] /classes/PrestaShopCollection.php:385 (hydrateCollection) [id: ] /classes/PrestaShopCollection.php:385 (hydrateCollection) [id: ] /classes/PrestaShopCollection.php:385 (hydrateCollection) [id: ] /classes/PrestaShopCollection.php:385 (hydrateCollection) [id: ] /classes/PrestaShopCollection.php:385 (hydrateCollection) [id: ] /classes/PrestaShopCollection.php:385 (hydrateCollection) [id: ] /classes/PrestaShopCollection.php:385 (hydrateCollection) [id: ] /classes/PrestaShopCollection.php:385 (hydrateCollection) [id: ] /classes/PrestaShopCollection.php:385 (hydrateCollection) [id: ] /classes/PrestaShopCollection.php:385 (hydrateCollection) [id: ] /classes/PrestaShopCollection.php:385 (hydrateCollection) [id: ] /classes/PrestaShopCollection.php:385 (hydrateCollection) [id: ] /classes/PrestaShopCollection.php:385 (hydrateCollection) [id: ] /classes/PrestaShopCollection.php:385 (hydrateCollection) [id: ] /classes/PrestaShopCollection.php:385 (hydrateCollection) [id: ]
QuantityDiscountRule	18	/override/classes/CartRule.php:53 (__construct) [id: ] /override/classes/CartRule.php:53 (__construct) [id: ] /override/classes/CartRule.php:113 (__construct) [id: ] /override/classes/CartRule.php:114 (getHighlightedQuantityDiscountRules) [id: 6] /override/classes/CartRule.php:114 (getHighlightedQuantityDiscountRules) [id: 25] /override/classes/CartRule.php:113 (__construct) [id: ] /override/classes/CartRule.php:114 (getHighlightedQuantityDiscountRules) [id: 6] /override/classes/CartRule.php:114 (getHighlightedQuantityDiscountRules) [id: 25] /override/classes/CartRule.php:113 (__construct) [id: ] /override/classes/CartRule.php:114 (getHighlightedQuantityDiscountRules) [id: 6] /override/classes/CartRule.php:114 (getHighlightedQuantityDiscountRules) [id: 25] /override/classes/CartRule.php:113 (__construct) [id: ] /override/classes/CartRule.php:114 (getHighlightedQuantityDiscountRules) [id: 6] /override/classes/CartRule.php:114 (getHighlightedQuantityDiscountRules) [id: 25] /modules/quantitydiscountpro/quantitydiscountpro.php:850 (__construct) [id: 6] /override/classes/CartRule.php:113 (__construct) [id: ] /override/classes/CartRule.php:114 (getHighlightedQuantityDiscountRules) [id: 6] /override/classes/CartRule.php:114 (getHighlightedQuantityDiscountRules) [id: 25]
Language	15	/config/config.inc.php:211 (__construct) [id: 1] /classes/Tools.php:560 (__construct) [id: 1] /modules/facebookproductad/lib/hook/hookDisplay.php:91 (__construct) [id: 1] /modules/facebookproductad/lib/pixel/pixelCategory.php:39 (__construct) [id: 1] /modules/facebookproductad/lib/pixel/pixelCategory.php:39 (__construct) [id: 1] /modules/steasycontent/classes/StEasyContentSettingClass.php:78 (__construct) [id: 1] /modules/steasycontent/classes/StEasyContentSettingClass.php:78 (__construct) [id: 1] /modules/steasycontent/classes/StEasyContentSettingClass.php:78 (__construct) [id: 1] /modules/steasycontent/classes/StEasyContentSettingClass.php:78 (__construct) [id: 1] /modules/steasycontent/classes/StEasyContentSettingClass.php:78 (__construct) [id: 1] /modules/steasycontent/classes/StEasyContentSettingClass.php:78 (__construct) [id: 1] /modules/steasycontent/classes/StEasyContentSettingClass.php:78 (__construct) [id: 1] /modules/steasycontent/classes/StEasyContentSettingClass.php:78 (__construct) [id: 1] /modules/steasycontent/classes/StEasyContentSettingClass.php:78 (__construct) [id: 1] /modules/steasycontent/classes/StEasyContentSettingClass.php:78 (__construct) [id: 1]
Configuration	6	/modules/ps_accounts/src/Adapter/Configuration.php:224 (__construct) [id: 251673] /modules/ps_accounts/src/Adapter/Configuration.php:224 (__construct) [id: 251673] /modules/ps_accounts/src/Adapter/Configuration.php:224 (__construct) [id: 251673] /modules/ps_accounts/src/Adapter/Configuration.php:224 (__construct) [id: 251673] /modules/payplug/src/application/adapter/ConfigurationAdapter.php:38 (__construct) [id: ] /modules/payplug/src/application/adapter/ConfigurationAdapter.php:38 (__construct) [id: ]
Address	6	/classes/shop/Shop.php:486 (__construct) [id: ] /modules/payplug/src/application/adapter/AddressAdapter.php:38 (__construct) [id: ] /modules/payplug/src/application/adapter/AddressAdapter.php:38 (__construct) [id: ] /classes/Product.php:3694 (initialize) [id: ] /classes/Product.php:3804 (__construct) [id: ] /classes/Product.php:5945 (__construct) [id: ]
Customer	5	/config/config.inc.php:264 (__construct) [id: ] /classes/order/Order.php:288 (__construct) [id: 5] /classes/order/Order.php:288 (__construct) [id: 5] /override/modules/stcustomersignin/stcustomersignin.php:574 (isCustomerInCseGroup) [id: ] /override/modules/stcustomersignin/stcustomersignin.php:574 (isCustomerInCseGroup) [id: ]
Cart	5	/classes/controller/FrontController.php:465 (__construct) [id: ] /override/classes/controller/FrontController.php:465 (__construct) [id: ] /override/classes/controller/FrontController.php:534 (__construct) [id: ] /modules/payplug/src/application/adapter/CartAdapter.php:38 (__construct) [id: ] /modules/payplug/src/application/adapter/CartAdapter.php:38 (__construct) [id: ]
QuantityDiscountRuleCondition	5	/modules/quantitydiscountpro/classes/QuantityDiscountRule.php:4320 (__construct) [id: 96] /modules/quantitydiscountpro/classes/QuantityDiscountRule.php:4320 (__construct) [id: 96] /modules/quantitydiscountpro/classes/QuantityDiscountRule.php:4320 (__construct) [id: 96] /modules/quantitydiscountpro/classes/QuantityDiscountRule.php:4320 (__construct) [id: 96] /modules/quantitydiscountpro/classes/QuantityDiscountRule.php:4320 (__construct) [id: 96]
Country	3	/config/config.inc.php:146 (__construct) [id: 8] /classes/AddressFormat.php:404 (__construct) [id: 8] /override/classes/controller/FrontController.php:1770 (__construct) [id: 8]
Order	2	/modules/gmerchantcenterpro/lib/hook/hookDisplay.php:95 (__construct) [id: 1] /modules/facebookproductad/lib/hook/hookDisplay.php:149 (__construct) [id: 1]
Mail	2	/modules/payplug/src/application/adapter/MailAdapter.php:38 (__construct) [id: ] /modules/payplug/src/application/adapter/MailAdapter.php:38 (__construct) [id: ]
OrderState	2	/modules/payplug/src/application/adapter/OrderStateAdapter.php:38 (__construct) [id: ] /modules/payplug/src/application/adapter/OrderStateAdapter.php:38 (__construct) [id: ]
Carrier	2	/modules/payplug/src/application/adapter/CarrierAdapter.php:45 (__construct) [id: ] /modules/payplug/src/application/adapter/CarrierAdapter.php:45 (__construct) [id: ]
Tax	2	/classes/tax/TaxRulesTaxManager.php:116 (__construct) [id: 1] /classes/tax/TaxRulesTaxManager.php:116 (__construct) [id: 1]
CartRule	2	/modules/payplug/src/application/adapter/CartRuleAdapter.php:38 (__construct) [id: ] /modules/payplug/src/application/adapter/CartRuleAdapter.php:38 (__construct) [id: ]
Currency	2	/src/Adapter/Currency/CurrencyDataProvider.php:101 (__construct) [id: 1] /classes/Tools.php:690 (getCurrencyInstance) [id: 1]
CMS	1	/modules/gptchatbox/gptchatbox.php:1342 (__construct) [id: 7]
Shop	1	/config/config.inc.php:117 (initialize) [id: 1]
Risk	1	/override/classes/controller/FrontController.php:1697 (__construct) [id: ]
State	1	/override/classes/controller/FrontController.php:1769 (__construct) [id: 0]
AddressFormat	1	/override/classes/controller/FrontController.php:1764 (generateAddress) [id: ]
Gender	1	/override/classes/controller/FrontController.php:1694 (__construct) [id: 0]
QuantityDiscountRuleGroup	1	/modules/quantitydiscountpro/classes/QuantityDiscountRule.php:159 (hydrateCollection) [id: ]
Group	1	/classes/Cart.php:249 (getCurrent) [id: 1]
ShopGroup	1	/classes/shop/Shop.php:561 (__construct) [id: 1]
ConnectionsSource	1	/modules/statsdata/statsdata.php:119 (logHttpReferer) [id: ]

Nos marques

Savon Solide

BOIS D'ORANGE

ROSE

FLEUR D'OSMANTHUS

CÉDRAT

NÉROLI

FLEUR DE FIGUIER

LAVANDE ROYALE

ŒILLET MIGNARDISE

ROSE THÉ

FLEUR DE FIGUIER

GINGEMBRE ROUGE

JEAN MARIE FARINA

BOIS D'ORANGE

EAU DE CAMPAGNE

THE RITUAL OF AYURVEDA

THE RITUAL OF SAKURA

+9000

Références

Livraison

Offerte

Paiement

Sécurisé

Experts

Beauté

Menu

Nos marques

Paramètres

Rechercher

Stopwatch SQL - 1438 queries

Doubles

Tables stress

ObjectModel instances

Included Files

Hook	Time	Memory Usage
ActionStAssemble	139.073 ms	3.51 Mb
=> stthemeeditor	0.668 ms	0.03 Mb
=> sthoverimage	0.347 ms	0.01 Mb
=> ststickers	9.126 ms	0.30 Mb
=> stlovedproduct	0.504 ms	0.01 Mb
=> stthemeeditor	0.507 ms	0.02 Mb
=> sthoverimage	0.437 ms	0.01 Mb
=> ststickers	6.589 ms	0.15 Mb
=> stlovedproduct	0.645 ms	0.01 Mb
=> stthemeeditor	0.632 ms	0.03 Mb
=> sthoverimage	0.396 ms	0.01 Mb
=> ststickers	6.838 ms	0.15 Mb
=> stlovedproduct	0.710 ms	0.01 Mb
=> stthemeeditor	0.708 ms	0.03 Mb
=> sthoverimage	0.347 ms	0.01 Mb
=> ststickers	6.954 ms	0.15 Mb
=> stlovedproduct	0.651 ms	0.01 Mb
=> stthemeeditor	0.677 ms	0.02 Mb
=> sthoverimage	0.337 ms	0.01 Mb
=> ststickers	7.311 ms	0.15 Mb
=> stlovedproduct	0.717 ms	0.01 Mb
=> stthemeeditor	0.628 ms	0.02 Mb
=> sthoverimage	0.351 ms	0.01 Mb
=> ststickers	6.323 ms	0.13 Mb
=> stlovedproduct	0.674 ms	0.01 Mb
=> stthemeeditor	0.608 ms	0.03 Mb
=> sthoverimage	0.319 ms	0.01 Mb
=> ststickers	6.271 ms	0.13 Mb
=> stlovedproduct	0.666 ms	0.01 Mb
=> stthemeeditor	0.478 ms	0.03 Mb
=> sthoverimage	0.280 ms	0.01 Mb
=> ststickers	5.998 ms	0.13 Mb
=> stlovedproduct	0.696 ms	0.01 Mb
=> stthemeeditor	0.568 ms	0.03 Mb
=> sthoverimage	0.285 ms	0.01 Mb
=> ststickers	5.359 ms	0.13 Mb
=> stlovedproduct	0.494 ms	0.01 Mb
=> stthemeeditor	0.501 ms	0.03 Mb
=> sthoverimage	0.357 ms	0.01 Mb
=> ststickers	6.347 ms	0.16 Mb

Module	Time	Memory Usage
stblog	10.468 ms	1.92 Mb
__construct	10.429 ms	1.91 Mb
hookModuleRoutes	0.017 ms	- Mb
hookOverrideLayoutTemplate	0.010 ms	- Mb
hookOverrideLayoutTemplate	0.007 ms	- Mb
hookOverrideLayoutTemplate	0.005 ms	- Mb
stblogarchives	1.278 ms	0.04 Mb
__construct	1.251 ms	0.04 Mb
hookModuleRoutes	0.004 ms	- Mb
hookDisplayHeader	0.023 ms	- Mb
stblogsearch	1.021 ms	0.02 Mb
__construct	1.017 ms	0.02 Mb
hookModuleRoutes	0.004 ms	- Mb
hioutofstocknotification	6.790 ms	0.59 Mb
__construct	5.681 ms	0.51 Mb
hookModuleRoutes	0.008 ms	- Mb
hookDisplayHeader	0.995 ms	0.06 Mb
hookDisplayProductListReviews	0.008 ms	- Mb
hookDisplayProductListReviews	0.006 ms	- Mb
hookDisplayProductListReviews	0.004 ms	- Mb
hookDisplayProductListReviews	0.023 ms	- Mb
hookDisplayProductListReviews	0.005 ms	- Mb
hookDisplayProductListReviews	0.006 ms	- Mb
hookDisplayProductListReviews	0.006 ms	- Mb
hookDisplayProductListReviews	0.005 ms	- Mb
hookDisplayProductListReviews	0.006 ms	- Mb
hookDisplayProductListReviews	0.009 ms	- Mb
hookDisplayProductListReviews	0.005 ms	- Mb
hookDisplayProductListReviews	0.005 ms	- Mb
hookDisplayProductListReviews	0.005 ms	- Mb
hookDisplayProductListReviews	0.004 ms	- Mb
hookDisplayProductListReviews	0.005 ms	- Mb
hookDisplayProductListReviews	0.004 ms	- Mb
doofinder	3.732 ms	0.41 Mb
__construct	1.604 ms	0.16 Mb
hookModuleRoutes	0.008 ms	- Mb
hookDisplayHeader	2.120 ms	0.25 Mb
ps_checkout	17.617 ms	1.02 Mb
__construct	1.225 ms	0.04 Mb
hookModuleRoutes	0.006 ms	- Mb

#	Query	Time (ms)	Rows	Filesort	Group By	Location
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 `xj8_configuration` c LEFT JOIN `xj8_configuration_lang` cl ON (c.`id_configuration` = cl.`id_configuration`)	17.965 ms	7812			/classes/Configuration.php:180 /classes/Configuration.php:229 (loadConfiguration) /classes/Configuration.php:302 (get) /classes/shop/Shop.php:398 (getMultiShopValues) /config/config.inc.php:117 (initialize) /index.php:27 (require)
1066	SELECT SQL_NO_CACHE p., pl. FROM `xj8_product` p INNER JOIN `xj8_product_lang` `pl` ON pl.id_product = p.id_product AND pl.id_lang = 1 AND pl.id_shop = 1 LEFT JOIN `xj8_category_product` `cp` ON cp.id_product = p.id_product LEFT JOIN `xj8_category_lang` `cl` ON cl.id_category = cp.id_category AND cl.id_lang = 1 WHERE (p.id_product = 65842) LIMIT 1	7.386 ms	0			/override/classes/Product.php:67 /var/cache/prod/smarty/compile/child_panda/14/a1/82/14a18245ef968023fa1313eebc01e17799be8b2a_2.module.stswiperviewstemplateshookstswiperblock.tpl.cache.php:70 (getProductById) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6ac3939196d934_22683398) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:384 (render) /var/cache/prod/smarty/compile/child_panda/2a/d2/8a/2ad28a741794d34f1e05349a19acae3a4048f801_2.module.stswiperviewstemplateshookstswiper0.tpl.cache.php:43 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6ac39391921130_89409152) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:384 (render) /var/cache/prod/smarty/compile/child_panda/a4/72/c8/a472c851952868eec073461c6385b48d635194d8_2.module.stswiperviewstemplateshookstswiper.tpl.cache.php:46 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6ac3939190b721_33513993) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_updatecache.php:38 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_template_cached.php:143 (updateCache) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:212 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/module/Module.php:2273 (fetch) /override/modules/stswiper/stswiper.php:3054 (fetch) /classes/Hook.php:1043 (hookDisplayCategoryHeader) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:418 (coreCallHook) /classes/Hook.php:981 (callHookOn) /config/smarty.config.inc.php:198 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/prod/smarty/compile/child_pandalayouts_layout_left_column_tpl/c6/ad/da/c6addaa5971b2a1e943f8f0e8a5fdba2ed93b339_2.file.category.tpl.php:76 (__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:186 (process) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/child_pandalayouts_layout_left_column_tpl/76/a9/5b/76a95be99df01b610fca2bca744f33c00edb13af_2.file.product-list.tpl.php:72 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:232 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:189 (callParent) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:186 (process) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:186 (process) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/child_pandalayouts_layout_left_column_tpl/16/5e/69/165e6984cc26fc4d30c2e41af5deec6faa952708_2.file.layout-both-columns.tpl.php:98 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6ac393aa1556a4_70405393) /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:116 (_subTemplateRender) /var/cache/prod/smarty/compile/child_pandalayouts_layout_left_column_tpl/6c/3d/79/6c3d7966117dae2bd9ae5035b3ee6cd2e1b2a36d_2.file.layout-left-column.tpl.php:47 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6ac393aa0c3f38_98812868) /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:116 (_subTemplateRender) /var/cache/prod/smarty/compile/child_pandalayouts_layout_left_column_tpl/76/a9/5b/76a95be99df01b610fca2bca744f33c00edb13af_2.file.product-list.tpl.php:39 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6ac393aa0babf9_11094935) /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:116 (_subTemplateRender) /var/cache/prod/smarty/compile/child_pandalayouts_layout_left_column_tpl/c6/ad/da/c6addaa5971b2a1e943f8f0e8a5fdba2ed93b339_2.file.category.tpl.php:42 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6ac393aa08f0e9_25151483) /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) /override/classes/controller/FrontController.php:762 (fetch) /override/classes/controller/FrontController.php:744 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
482	(SELECT cp.position AS `order_value`, p., product_shop., pl.`name`, stock.out_of_stock, IFNULL(stock.quantity, 0) AS quantity, IFNULL(stock.quantity, 0) AS quantity_sql, IFNULL(product_attribute_shop.id_product_attribute, 0) AS id_product_attribute, product_attribute_shop.minimal_quantity AS product_attribute_minimal_quantity, pl.`description`, pl.`description_short`, pl.`available_now`, pl.`available_later`, pl.`link_rewrite`, pl.`meta_description`, pl.`meta_keywords`, pl.`meta_title`, image_shop.`id_image` id_image, il.`legend` as legend, m.`name` AS manufacturer_name, cl.`name` AS category_default, DATEDIFF(product_shop.`date_add`, DATE_SUB("2026-10-05 00:00:00", INTERVAL 20 DAY)) > 0 AS new, (product_shop.`price` + IFNULL(product_attribute_shop.`price`, 0)) AS orderprice, cp.`position`, a.`position` as `position_attribute`, pa.`id_product_attribute` as pai_id_product_attribute, MAX(ag.`is_color_group`), CONCAT_WS("-", "spa", "a", p.id_product, pa.id_product_attribute) as `id_product_pack`, product_attribute_shop.`price` AS `spa_sort_column`, 1 AS spa_eligible_product FROM `xj8_category_product` cp RIGHT JOIN `xj8_category` c ON (c.`id_category` = cp.`id_category` AND c.nleft >= 431 AND c.nright <= 432) LEFT JOIN `xj8_product` p ON p.`id_product` = cp.`id_product` INNER JOIN xj8_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) LEFT JOIN `xj8_category_lang` cl ON (product_shop.`id_category_default` = cl.`id_category` AND cl.`id_lang` = 1 AND cl.id_shop = 1 ) LEFT JOIN `xj8_product_lang` pl ON (p.`id_product` = pl.`id_product` AND pl.`id_lang` = 1 AND pl.id_shop = 1 ) LEFT JOIN `xj8_image_shop` image_shop ON (image_shop.`id_product` = p.`id_product` AND image_shop.cover=1 AND image_shop.id_shop=1) LEFT JOIN `xj8_image_lang` il ON (image_shop.`id_image` = il.`id_image` AND il.`id_lang` = 1) LEFT JOIN `xj8_manufacturer` m ON m.`id_manufacturer` = p.`id_manufacturer` LEFT JOIN `xj8_product_attribute` pa ON pa.`id_product` = p.`id_product` LEFT JOIN `xj8_product_attribute_combination` pac ON pac.`id_product_attribute` = pa.`id_product_attribute` JOIN `xj8_pm_spa_cache` pa_cartesian ON (pa_cartesian.`id_product` = p.`id_product` AND pa_cartesian.`id_product_attribute` = pa.`id_product_attribute` AND pa_cartesian.`id_shop` = 1) JOIN `xj8_attribute` a ON a.`id_attribute` = pac.`id_attribute` AND (a.`id_attribute_group` IN (1)) LEFT JOIN `xj8_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1) LEFT JOIN `xj8_attribute_group` ag ON (ag.`id_attribute_group` = a.`id_attribute_group`) LEFT JOIN `xj8_product_attribute_shop` product_attribute_shop ON ( p.`id_product` = product_attribute_shop.`id_product` AND product_attribute_shop.`id_product_attribute` = pac.`id_product_attribute` AND product_attribute_shop.id_shop=1 ) LEFT JOIN xj8_stock_available stock ON (stock.id_product = `p`.id_product AND stock.id_product_attribute = IFNULL(`pa`.id_product_attribute, 0) AND stock.id_shop = 1 AND stock.id_shop_group = 0 ) WHERE product_shop.`id_shop` = 1 AND product_shop.`active` = 1 AND cp.`id_category` = 2531 AND IF (stock.`quantity` > 0 OR (p.`cache_default_attribute` > 0 AND p.`cache_default_attribute` = pac.`id_product_attribute`), 1, IF (stock.`out_of_stock` = 2, 0 = 1, stock.`out_of_stock` = 1)) AND product_shop.`visibility` IN ("both", "catalog") GROUP BY cp.`id_product`, pa.`id_product_attribute`) UNION ALL (SELECT cp.position AS `order_value`, p., product_shop., pl.`name`, stock.out_of_stock, IFNULL(stock.quantity, 0) AS quantity, IFNULL(stock.quantity, 0) AS quantity_sql, IFNULL(product_attribute_shop.id_product_attribute, 0) AS id_product_attribute, product_attribute_shop.minimal_quantity AS product_attribute_minimal_quantity, pl.`description`, pl.`description_short`, pl.`available_now`, pl.`available_later`, pl.`link_rewrite`, pl.`meta_description`, pl.`meta_keywords`, pl.`meta_title`, image_shop.`id_image` id_image, il.`legend` as legend, m.`name` AS manufacturer_name, cl.`name` AS category_default, DATEDIFF(product_shop.`date_add`, DATE_SUB("2026-10-05 00:00:00", INTERVAL 20 DAY)) > 0 AS new, (product_shop.`price` + IFNULL(product_attribute_shop.`price`, 0)) AS orderprice, cp.`position`, a.`position` as `position_attribute`, pa.`id_product_attribute` as pai_id_product_attribute, "0" as `is_color_group`, "spa-nochanges" as `id_product_pack`, product_attribute_shop.`price` AS `spa_sort_column`, 0 AS spa_eligible_product FROM `xj8_category_product` cp RIGHT JOIN `xj8_category` c ON (c.`id_category` = cp.`id_category` AND c.nleft >= 431 AND c.nright <= 432) LEFT JOIN `xj8_product` p ON p.`id_product` = cp.`id_product` INNER JOIN xj8_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) LEFT JOIN `xj8_category_lang` cl ON (product_shop.`id_category_default` = cl.`id_category` AND cl.`id_lang` = 1 AND cl.id_shop = 1 ) LEFT JOIN `xj8_product_lang` pl ON (p.`id_product` = pl.`id_product` AND pl.`id_lang` = 1 AND pl.id_shop = 1 ) LEFT JOIN `xj8_image_shop` image_shop ON (image_shop.`id_product` = p.`id_product` AND image_shop.cover=1 AND image_shop.id_shop=1) LEFT JOIN `xj8_image_lang` il ON (image_shop.`id_image` = il.`id_image` AND il.`id_lang` = 1) LEFT JOIN `xj8_manufacturer` m ON m.`id_manufacturer` = p.`id_manufacturer` LEFT JOIN `xj8_product_attribute` pa ON pa.`id_product` = p.`id_product` LEFT JOIN `xj8_product_attribute_combination` pac ON pac.`id_product_attribute` = pa.`id_product_attribute` LEFT JOIN `xj8_attribute` a ON a.`id_attribute` = pac.`id_attribute` AND (a.`id_attribute_group` IN (1)) LEFT JOIN `xj8_product_attribute_shop` product_attribute_shop ON (p.`id_product` = product_attribute_shop.`id_product` AND product_attribute_shop.`id_product_attribute` = pac.`id_product_attribute` AND product_attribute_shop.`default_on` = 1 AND product_attribute_shop.id_shop=1) LEFT JOIN xj8_stock_available stock ON (stock.id_product = `p`.id_product AND stock.id_product_attribute = 0 AND stock.id_shop = 1 AND stock.id_shop_group = 0 ) WHERE product_shop.`id_shop` = 1 AND product_shop.`active` = 1 AND cp.`id_category` = 2531 AND product_shop.`visibility` IN ("both", "catalog") GROUP BY cp.id_product HAVING (COUNT(a.`id_attribute`) = 0) ) ORDER BY `order_value` ASC, `spa_sort_column` ASC LIMIT 0,16	6.082 ms	1			/modules/pm_productsbyattributes/pm_productsbyattributes.php:974 /modules/pm_productsbyattributes/src/Pm_ProductsByAttributesCategoryProvider.php:76 (getCategoryProducts) /modules/pm_productsbyattributes/src/Pm_ProductsByAttributesCategoryProvider.php:83 (getProductsOrCount) /modules/pm_productsbyattributes/src/Pm_ProductsByAttributesProductSearchProvider.php:146 (runQuery) /override/classes/controller/ProductListingFrontController.php:361 (runQuery) /override/controllers/front/listing/CategoryController.php:19 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:138 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
448	(SELECT cp.position AS `order_value`, p., product_shop., pl.`name`, stock.out_of_stock, IFNULL(stock.quantity, 0) AS quantity, IFNULL(stock.quantity, 0) AS quantity_sql, IFNULL(product_attribute_shop.id_product_attribute, 0) AS id_product_attribute, product_attribute_shop.minimal_quantity AS product_attribute_minimal_quantity, pl.`description`, pl.`description_short`, pl.`available_now`, pl.`available_later`, pl.`link_rewrite`, pl.`meta_description`, pl.`meta_keywords`, pl.`meta_title`, image_shop.`id_image` id_image, il.`legend` as legend, m.`name` AS manufacturer_name, cl.`name` AS category_default, DATEDIFF(product_shop.`date_add`, DATE_SUB("2026-10-05 00:00:00", INTERVAL 20 DAY)) > 0 AS new, (product_shop.`price` + IFNULL(product_attribute_shop.`price`, 0)) AS orderprice, cp.`position`, a.`position` as `position_attribute`, pa.`id_product_attribute` as pai_id_product_attribute, MAX(ag.`is_color_group`), CONCAT_WS("-", "spa", "a", p.id_product, pa.id_product_attribute) as `id_product_pack`, product_attribute_shop.`price` AS `spa_sort_column`, 1 AS spa_eligible_product FROM `xj8_category_product` cp RIGHT JOIN `xj8_category` c ON (c.`id_category` = cp.`id_category` AND c.nleft >= 431 AND c.nright <= 432) LEFT JOIN `xj8_product` p ON p.`id_product` = cp.`id_product` INNER JOIN xj8_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) LEFT JOIN `xj8_category_lang` cl ON (product_shop.`id_category_default` = cl.`id_category` AND cl.`id_lang` = 1 AND cl.id_shop = 1 ) LEFT JOIN `xj8_product_lang` pl ON (p.`id_product` = pl.`id_product` AND pl.`id_lang` = 1 AND pl.id_shop = 1 ) LEFT JOIN `xj8_image_shop` image_shop ON (image_shop.`id_product` = p.`id_product` AND image_shop.cover=1 AND image_shop.id_shop=1) LEFT JOIN `xj8_image_lang` il ON (image_shop.`id_image` = il.`id_image` AND il.`id_lang` = 1) LEFT JOIN `xj8_manufacturer` m ON m.`id_manufacturer` = p.`id_manufacturer` LEFT JOIN `xj8_product_attribute` pa ON pa.`id_product` = p.`id_product` LEFT JOIN `xj8_product_attribute_combination` pac ON pac.`id_product_attribute` = pa.`id_product_attribute` JOIN `xj8_pm_spa_cache` pa_cartesian ON (pa_cartesian.`id_product` = p.`id_product` AND pa_cartesian.`id_product_attribute` = pa.`id_product_attribute` AND pa_cartesian.`id_shop` = 1) JOIN `xj8_attribute` a ON a.`id_attribute` = pac.`id_attribute` AND (a.`id_attribute_group` IN (1)) LEFT JOIN `xj8_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1) LEFT JOIN `xj8_attribute_group` ag ON (ag.`id_attribute_group` = a.`id_attribute_group`) LEFT JOIN `xj8_product_attribute_shop` product_attribute_shop ON ( p.`id_product` = product_attribute_shop.`id_product` AND product_attribute_shop.`id_product_attribute` = pac.`id_product_attribute` AND product_attribute_shop.id_shop=1 ) LEFT JOIN xj8_stock_available stock ON (stock.id_product = `p`.id_product AND stock.id_product_attribute = IFNULL(`pa`.id_product_attribute, 0) AND stock.id_shop = 1 AND stock.id_shop_group = 0 ) WHERE product_shop.`id_shop` = 1 AND product_shop.`active` = 1 AND cp.`id_category` = 2531 AND IF (stock.`quantity` > 0 OR (p.`cache_default_attribute` > 0 AND p.`cache_default_attribute` = pac.`id_product_attribute`), 1, IF (stock.`out_of_stock` = 2, 0 = 1, stock.`out_of_stock` = 1)) AND product_shop.`visibility` IN ("both", "catalog") GROUP BY cp.`id_product`, pa.`id_product_attribute`) UNION ALL (SELECT cp.position AS `order_value`, p., product_shop., pl.`name`, stock.out_of_stock, IFNULL(stock.quantity, 0) AS quantity, IFNULL(stock.quantity, 0) AS quantity_sql, IFNULL(product_attribute_shop.id_product_attribute, 0) AS id_product_attribute, product_attribute_shop.minimal_quantity AS product_attribute_minimal_quantity, pl.`description`, pl.`description_short`, pl.`available_now`, pl.`available_later`, pl.`link_rewrite`, pl.`meta_description`, pl.`meta_keywords`, pl.`meta_title`, image_shop.`id_image` id_image, il.`legend` as legend, m.`name` AS manufacturer_name, cl.`name` AS category_default, DATEDIFF(product_shop.`date_add`, DATE_SUB("2026-10-05 00:00:00", INTERVAL 20 DAY)) > 0 AS new, (product_shop.`price` + IFNULL(product_attribute_shop.`price`, 0)) AS orderprice, cp.`position`, a.`position` as `position_attribute`, pa.`id_product_attribute` as pai_id_product_attribute, "0" as `is_color_group`, "spa-nochanges" as `id_product_pack`, product_attribute_shop.`price` AS `spa_sort_column`, 0 AS spa_eligible_product FROM `xj8_category_product` cp RIGHT JOIN `xj8_category` c ON (c.`id_category` = cp.`id_category` AND c.nleft >= 431 AND c.nright <= 432) LEFT JOIN `xj8_product` p ON p.`id_product` = cp.`id_product` INNER JOIN xj8_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) LEFT JOIN `xj8_category_lang` cl ON (product_shop.`id_category_default` = cl.`id_category` AND cl.`id_lang` = 1 AND cl.id_shop = 1 ) LEFT JOIN `xj8_product_lang` pl ON (p.`id_product` = pl.`id_product` AND pl.`id_lang` = 1 AND pl.id_shop = 1 ) LEFT JOIN `xj8_image_shop` image_shop ON (image_shop.`id_product` = p.`id_product` AND image_shop.cover=1 AND image_shop.id_shop=1) LEFT JOIN `xj8_image_lang` il ON (image_shop.`id_image` = il.`id_image` AND il.`id_lang` = 1) LEFT JOIN `xj8_manufacturer` m ON m.`id_manufacturer` = p.`id_manufacturer` LEFT JOIN `xj8_product_attribute` pa ON pa.`id_product` = p.`id_product` LEFT JOIN `xj8_product_attribute_combination` pac ON pac.`id_product_attribute` = pa.`id_product_attribute` LEFT JOIN `xj8_attribute` a ON a.`id_attribute` = pac.`id_attribute` AND (a.`id_attribute_group` IN (1)) LEFT JOIN `xj8_product_attribute_shop` product_attribute_shop ON (p.`id_product` = product_attribute_shop.`id_product` AND product_attribute_shop.`id_product_attribute` = pac.`id_product_attribute` AND product_attribute_shop.`default_on` = 1 AND product_attribute_shop.id_shop=1) LEFT JOIN xj8_stock_available stock ON (stock.id_product = `p`.id_product AND stock.id_product_attribute = 0 AND stock.id_shop = 1 AND stock.id_shop_group = 0 ) WHERE product_shop.`id_shop` = 1 AND product_shop.`active` = 1 AND cp.`id_category` = 2531 AND product_shop.`visibility` IN ("both", "catalog") GROUP BY cp.id_product HAVING (COUNT(a.`id_attribute`) = 0) ) ORDER BY `order_value` ASC, `spa_sort_column` ASC LIMIT 0,18	5.843 ms	1			/modules/pm_productsbyattributes/pm_productsbyattributes.php:974 /modules/pm_productsbyattributes/src/Pm_ProductsByAttributesCategoryProvider.php:76 (getCategoryProducts) /modules/pm_productsbyattributes/src/Pm_ProductsByAttributesCategoryProvider.php:83 (getProductsOrCount) /modules/pm_productsbyattributes/src/Pm_ProductsByAttributesProductSearchProvider.php:143 (runQuery) /override/classes/controller/ProductListingFrontController.php:361 (runQuery) /override/controllers/front/listing/CategoryController.php:19 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:138 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
1357	SELECT SQL_NO_CACHE gi.* FROM `xj8_multipleprices_configuration` gi WHERE (date_from <= "2026-10-05 15:04:14" OR date_from = "0000-00-00 00:00:00") AND (date_to >= "2026-10-05 15:04:14" OR date_to = "0000-00-00 00:00:00") AND gi.`id_shop` = 1 AND gi.`active` = 1 AND (gi.groups = "" OR FIND_IN_SET(1, REPLACE(gi.groups, ";", ",")) > 0) AND (gi.manufacturers = "" OR FIND_IN_SET(2929, REPLACE(gi.manufacturers, ";", ",")) > 0) AND (gi.suppliers = "" OR FIND_IN_SET(3, REPLACE(gi.suppliers, ";", ",")) > 0) ORDER BY position, priority	4.996 ms	4	Yes		/modules/multipleprices/classes/MultiplepricesConfiguration.php:241 /modules/multipleprices/classes/MultiplepricesConfiguration.php:749 (getConfigs) /modules/multipleprices/multipleprices.php:253 (getConfigsByProduct) /classes/Hook.php:1043 (hookDisplayProductPriceBlock) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:418 (coreCallHook) /classes/Hook.php:981 (callHookOn) /config/smarty.config.inc.php:198 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/prod/smarty/compile/child_pandalayouts_layout_left_column_tpl/39/7f/1e/397f1e842120307a33ca887c6281c7875ce1487a_2.file.product-price.tpl.php:39 (__call) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6ac393ab5087a6_40969864) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:384 (render) /var/cache/prod/smarty/compile/child_pandalayouts_layout_left_column_tpl/19/a1/f7/19a1f75bede2306511f7bcfd268a0aa64c0990c6_2.file.product.tpl.php:256 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/child_pandalayouts_layout_left_column_tpl/19/a1/f7/19a1f75bede2306511f7bcfd268a0aa64c0990c6_2.file.product.tpl.php:462 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/child_pandalayouts_layout_left_column_tpl/19/a1/f7/19a1f75bede2306511f7bcfd268a0aa64c0990c6_2.file.product.tpl.php:42 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6ac393ab44c379_51822991) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:384 (render) /var/cache/prod/smarty/compile/child_pandalayouts_layout_left_column_tpl/c1/f1/14/c1f114fcc3a7fc691e065e3dca25ff8941f9a563_2.file.list-item.tpl.php:206 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/child_pandalayouts_layout_left_column_tpl/c1/f1/14/c1f114fcc3a7fc691e065e3dca25ff8941f9a563_2.file.list-item.tpl.php:183 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6ac393ab358557_57118264) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /var/cache/prod/smarty/compile/child_pandalayouts_layout_left_column_tpl/59/17/c1/5917c1737404bbe74362254f6ff1afea81c1c32e_2.file.products.tpl.php:31 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6ac393ab3107f4_99010146) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /var/cache/prod/smarty/compile/child_pandalayouts_layout_left_column_tpl/76/a9/5b/76a95be99df01b610fca2bca744f33c00edb13af_2.file.product-list.tpl.php:128 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/child_pandalayouts_layout_left_column_tpl/76/a9/5b/76a95be99df01b610fca2bca744f33c00edb13af_2.file.product-list.tpl.php:225 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:186 (process) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:186 (process) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/child_pandalayouts_layout_left_column_tpl/16/5e/69/165e6984cc26fc4d30c2e41af5deec6faa952708_2.file.layout-both-columns.tpl.php:491 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/child_pandalayouts_layout_left_column_tpl/16/5e/69/165e6984cc26fc4d30c2e41af5deec6faa952708_2.file.layout-both-columns.tpl.php:129 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6ac393aa1556a4_70405393) /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:116 (_subTemplateRender) /var/cache/prod/smarty/compile/child_pandalayouts_layout_left_column_tpl/6c/3d/79/6c3d7966117dae2bd9ae5035b3ee6cd2e1b2a36d_2.file.layout-left-column.tpl.php:47 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6ac393aa0c3f38_98812868) /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:116 (_subTemplateRender) /var/cache/prod/smarty/compile/child_pandalayouts_layout_left_column_tpl/76/a9/5b/76a95be99df01b610fca2bca744f33c00edb13af_2.file.product-list.tpl.php:39 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6ac393aa0babf9_11094935) /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:116 (_subTemplateRender) /var/cache/prod/smarty/compile/child_pandalayouts_layout_left_column_tpl/c6/ad/da/c6addaa5971b2a1e943f8f0e8a5fdba2ed93b339_2.file.category.tpl.php:42 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6ac393aa08f0e9_25151483) /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) /override/classes/controller/FrontController.php:762 (fetch) /override/classes/controller/FrontController.php:744 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
231	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 `xj8_hook_module` hm STRAIGHT_JOIN `xj8_hook` h ON (h.id_hook = hm.id_hook AND hm.id_shop = 1) STRAIGHT_JOIN `xj8_module` as m ON (m.id_module = hm.id_module) ORDER BY hm.position	4.497 ms	969			/classes/Hook.php:456 /classes/Hook.php:493 (getHookModuleList) /classes/tax/TaxManagerFactory.php:67 (getModulesFromHook) /classes/tax/TaxManagerFactory.php:46 (execHookTaxManagerFactory) /classes/Product.php:3925 (getManager) /classes/Product.php:3717 (priceCalculation) /classes/Product.php:5675 (getPriceStatic) /classes/Product.php:5971 (getProductProperties) /classes/Category.php:1074 (getProductsProperties) /modules/facebookproductad/lib/pixel/pixelCategory.php:60 (getProducts) /modules/facebookproductad/lib/pixel/basePixel.php:266 (__construct) /modules/facebookproductad/lib/moduleTools.php:1508 (get) /modules/facebookproductad/lib/hook/hookDisplay.php:124 (buildDynDisplayTag) :undefined (displayHeader) /modules/facebookproductad/lib/hook/hookDisplay.php:62 (call_user_func_array) /modules/facebookproductad/lib/hook/hookController.php:60 (run) /modules/facebookproductad/facebookproductad.php:166 (run) /modules/facebookproductad/facebookproductad.php:142 (_execHook) /classes/Hook.php:1043 (hookDisplayHeader) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:418 (coreCallHook) /classes/Hook.php:981 (callHookOn) /override/classes/controller/FrontController.php:615 (exec) /controllers/front/listing/CategoryController.php:127 (initContent) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
14	SELECT SQL_NO_CACHE h.`name` as hook, m.`id_module`, h.`id_hook`, m.`name` as module FROM `xj8_module` m INNER JOIN xj8_module_shop module_shop ON (module_shop.id_module = m.id_module AND module_shop.id_shop = 1 AND module_shop.enable_device & 1) INNER JOIN `xj8_hook_module` `hm` ON hm.`id_module` = m.`id_module` INNER JOIN `xj8_hook` `h` ON hm.`id_hook` = h.`id_hook` LEFT JOIN `xj8_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`	2.637 ms	321	Yes	Yes	/classes/Hook.php:1233 /classes/Hook.php:735 (getAllHookRegistrations) /classes/Hook.php:842 (getHookModuleExecList) /classes/Dispatcher.php:606 (exec) /classes/Dispatcher.php:243 (loadRoutes) /classes/Dispatcher.php:201 (__construct) /index.php:28 (getInstance)
61	SELECT SQL_NO_CACHE `id_hook`, `name` FROM `xj8_hook` UNION SELECT `id_hook`, ha.`alias` as name FROM `xj8_hook_alias` ha INNER JOIN `xj8_hook` h ON ha.name = h.name	2.300 ms	0			/classes/Hook.php:1292 /classes/Hook.php:225 (getAllHookIds) /modules/allinone_rewards/src/NewsTabHelper.php:69 (getIdByName) /modules/allinone_rewards/allinone_rewards.php:79 (getMissingHooksConfiguration) /modules/allinone_rewards/allinone_rewards.php:63 (_checkWarnings) :undefined (__construct) /src/Core/Foundation/IoC/Container.php:123 (newInstance) /src/Core/Foundation/IoC/Container.php:153 (makeInstanceFromClassName) /src/Core/Foundation/IoC/Container.php:166 (doMake) /src/Adapter/ServiceLocator.php:70 (make) /classes/module/Module.php:1235 (get) /tools/profiling/Module.php:35 (coreLoadModule) /classes/module/Module.php:1214 (coreLoadModule) /classes/Hook.php:966 (getInstanceByName) /override/classes/controller/FrontController.php:995 (exec) /tools/profiling/Controller.php:48 (setMedia) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
221	SELECT SQL_NO_CACHE p., product_shop., stock.out_of_stock, IFNULL(stock.quantity, 0) AS quantity, IFNULL(product_attribute_shop.id_product_attribute, 0) AS id_product_attribute, product_attribute_shop.minimal_quantity AS product_attribute_minimal_quantity, pl.`description`, pl.`description_short`, pl.`available_now`, pl.`available_later`, pl.`link_rewrite`, pl.`meta_description`, pl.`meta_keywords`, pl.`meta_title`, pl.`name`, image_shop.`id_image` id_image, il.`legend` as legend, m.`name` AS manufacturer_name, cl.`name` AS category_default, DATEDIFF(product_shop.`date_add`, DATE_SUB("2026-10-05 00:00:00", INTERVAL 20 DAY)) > 0 AS new, product_shop.price AS orderprice FROM `xj8_category_product` cp LEFT JOIN `xj8_product` p ON p.`id_product` = cp.`id_product` INNER JOIN xj8_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) LEFT JOIN `xj8_product_attribute_shop` product_attribute_shop ON (p.`id_product` = product_attribute_shop.`id_product` AND product_attribute_shop.`default_on` = 1 AND product_attribute_shop.id_shop=1) LEFT JOIN xj8_stock_available stock ON (stock.id_product = `p`.id_product AND stock.id_product_attribute = 0 AND stock.id_shop = 1 AND stock.id_shop_group = 0 ) LEFT JOIN `xj8_category_lang` cl ON (product_shop.`id_category_default` = cl.`id_category` AND cl.`id_lang` = 1 AND cl.id_shop = 1 ) LEFT JOIN `xj8_product_lang` pl ON (p.`id_product` = pl.`id_product` AND pl.`id_lang` = 1 AND pl.id_shop = 1 ) LEFT JOIN `xj8_image_shop` image_shop ON (image_shop.`id_product` = p.`id_product` AND image_shop.cover=1 AND image_shop.id_shop=1) LEFT JOIN `xj8_image_lang` il ON (image_shop.`id_image` = il.`id_image` AND il.`id_lang` = 1) LEFT JOIN `xj8_manufacturer` m ON m.`id_manufacturer` = p.`id_manufacturer` WHERE product_shop.`id_shop` = 1 AND cp.`id_category` = 2531 AND product_shop.`active` = 1 AND product_shop.`visibility` IN ("both", "catalog") ORDER BY cp.`position` ASC LIMIT 0,18	1.924 ms	28			/classes/Category.php:1062 /modules/facebookproductad/lib/pixel/pixelCategory.php:60 (getProducts) /modules/facebookproductad/lib/pixel/basePixel.php:266 (__construct) /modules/facebookproductad/lib/moduleTools.php:1508 (get) /modules/facebookproductad/lib/hook/hookDisplay.php:124 (buildDynDisplayTag) :undefined (displayHeader) /modules/facebookproductad/lib/hook/hookDisplay.php:62 (call_user_func_array) /modules/facebookproductad/lib/hook/hookController.php:60 (run) /modules/facebookproductad/facebookproductad.php:166 (run) /modules/facebookproductad/facebookproductad.php:142 (_execHook) /classes/Hook.php:1043 (hookDisplayHeader) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:418 (coreCallHook) /classes/Hook.php:981 (callHookOn) /override/classes/controller/FrontController.php:615 (exec) /controllers/front/listing/CategoryController.php:127 (initContent) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
483	SELECT SQL_NO_CACHE COUNT(total) as total FROM ( ( SELECT COUNT(p.`id_product`) as total FROM `xj8_category_product` cp RIGHT JOIN `xj8_category` c ON (c.`id_category` = cp.`id_category` AND c.nleft >= 431 AND c.nright <= 432) LEFT JOIN `xj8_product` p ON p.`id_product` = cp.`id_product` INNER JOIN xj8_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) LEFT JOIN `xj8_product_attribute` pa ON pa.`id_product` = p.`id_product` LEFT JOIN `xj8_product_attribute_combination` pac ON pac.`id_product_attribute` = pa.`id_product_attribute` JOIN `xj8_pm_spa_cache` pa_cartesian ON (pa_cartesian.`id_product` = p.`id_product` AND pa_cartesian.`id_product_attribute` = pa.`id_product_attribute` AND pa_cartesian.`id_shop` = 1) LEFT JOIN xj8_stock_available stock ON (stock.id_product = `p`.id_product AND stock.id_product_attribute = IFNULL(`pa`.id_product_attribute, 0) AND stock.id_shop = 1 AND stock.id_shop_group = 0 ) JOIN `xj8_attribute` a ON a.`id_attribute` = pac.`id_attribute` LEFT JOIN `xj8_product_attribute_shop` product_attribute_shop ON (p.`id_product` = product_attribute_shop.`id_product` AND product_attribute_shop.`id_product_attribute` = pac.`id_product_attribute` AND product_attribute_shop.id_shop=1) WHERE product_shop.`id_shop` = 1 AND IF (stock.`quantity` > 0 OR (p.`cache_default_attribute` > 0 AND p.`cache_default_attribute` = pac.`id_product_attribute`), 1, IF (stock.`out_of_stock` = 2, 0 = 1, stock.`out_of_stock` = 1)) AND product_shop.`active` = 1 AND cp.`id_category` = 2531 AND product_shop.`visibility` IN ("both", "catalog") GROUP BY cp.`id_product`, pa.`id_product_attribute` ) UNION ALL ( SELECT COUNT(p.`id_product`) as total FROM `xj8_category_product` cp RIGHT JOIN `xj8_category` c ON (c.`id_category` = cp.`id_category` AND c.nleft >= 431 AND c.nright <= 432) LEFT JOIN `xj8_product` p ON p.`id_product` = cp.`id_product` INNER JOIN xj8_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) LEFT JOIN `xj8_product_attribute` pa ON pa.`id_product` = p.`id_product` AND pa.`default_on` = 1 LEFT JOIN `xj8_product_attribute_combination` pac ON pac.`id_product_attribute` = pa.`id_product_attribute` LEFT JOIN `xj8_attribute` a ON a.`id_attribute` = pac.`id_attribute` AND (a.`id_attribute_group` IN (1)) LEFT JOIN `xj8_product_attribute_shop` product_attribute_shop ON (p.`id_product` = product_attribute_shop.`id_product` AND product_attribute_shop.`id_product_attribute` = pac.`id_product_attribute` AND product_attribute_shop.`default_on` = 1 AND product_attribute_shop.id_shop=1) LEFT JOIN xj8_stock_available stock ON (stock.id_product = `p`.id_product AND stock.id_product_attribute = 0 AND stock.id_shop = 1 AND stock.id_shop_group = 0 ) WHERE product_shop.`id_shop` = 1 AND product_shop.`active` = 1 AND cp.`id_category` = 2531 AND product_shop.`visibility` IN ("both", "catalog") GROUP BY cp.`id_product` HAVING (COUNT(a.`id_attribute`) = 0) ) ) total_query LIMIT 1	1.552 ms	43904			/modules/pm_productsbyattributes/pm_productsbyattributes.php:814 /modules/pm_productsbyattributes/src/Pm_ProductsByAttributesCategoryProvider.php:76 (getCategoryProducts) /modules/pm_productsbyattributes/src/Pm_ProductsByAttributesCategoryProvider.php:84 (getProductsOrCount) /modules/pm_productsbyattributes/src/Pm_ProductsByAttributesProductSearchProvider.php:146 (runQuery) /override/classes/controller/ProductListingFrontController.php:361 (runQuery) /override/controllers/front/listing/CategoryController.php:19 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:138 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
481	SELECT SQL_NO_CACHE COUNT(total) as total FROM ( ( SELECT COUNT(p.`id_product`) as total FROM `xj8_category_product` cp RIGHT JOIN `xj8_category` c ON (c.`id_category` = cp.`id_category` AND c.nleft >= 431 AND c.nright <= 432) LEFT JOIN `xj8_product` p ON p.`id_product` = cp.`id_product` INNER JOIN xj8_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) LEFT JOIN `xj8_product_attribute` pa ON pa.`id_product` = p.`id_product` LEFT JOIN `xj8_product_attribute_combination` pac ON pac.`id_product_attribute` = pa.`id_product_attribute` JOIN `xj8_pm_spa_cache` pa_cartesian ON (pa_cartesian.`id_product` = p.`id_product` AND pa_cartesian.`id_product_attribute` = pa.`id_product_attribute` AND pa_cartesian.`id_shop` = 1) LEFT JOIN xj8_stock_available stock ON (stock.id_product = `p`.id_product AND stock.id_product_attribute = IFNULL(`pa`.id_product_attribute, 0) AND stock.id_shop = 1 AND stock.id_shop_group = 0 ) JOIN `xj8_attribute` a ON a.`id_attribute` = pac.`id_attribute` LEFT JOIN `xj8_product_attribute_shop` product_attribute_shop ON (p.`id_product` = product_attribute_shop.`id_product` AND product_attribute_shop.`id_product_attribute` = pac.`id_product_attribute` AND product_attribute_shop.id_shop=1) WHERE product_shop.`id_shop` = 1 AND IF (stock.`quantity` > 0 OR (p.`cache_default_attribute` > 0 AND p.`cache_default_attribute` = pac.`id_product_attribute`), 1, IF (stock.`out_of_stock` = 2, 0 = 1, stock.`out_of_stock` = 1)) AND product_shop.`active` = 1 AND cp.`id_category` = 2531 AND product_shop.`visibility` IN ("both", "catalog") GROUP BY cp.`id_product`, pa.`id_product_attribute` ) UNION ALL ( SELECT COUNT(p.`id_product`) as total FROM `xj8_category_product` cp RIGHT JOIN `xj8_category` c ON (c.`id_category` = cp.`id_category` AND c.nleft >= 431 AND c.nright <= 432) LEFT JOIN `xj8_product` p ON p.`id_product` = cp.`id_product` INNER JOIN xj8_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) LEFT JOIN `xj8_product_attribute` pa ON pa.`id_product` = p.`id_product` AND pa.`default_on` = 1 LEFT JOIN `xj8_product_attribute_combination` pac ON pac.`id_product_attribute` = pa.`id_product_attribute` LEFT JOIN `xj8_attribute` a ON a.`id_attribute` = pac.`id_attribute` AND (a.`id_attribute_group` IN (1)) LEFT JOIN `xj8_product_attribute_shop` product_attribute_shop ON (p.`id_product` = product_attribute_shop.`id_product` AND product_attribute_shop.`id_product_attribute` = pac.`id_product_attribute` AND product_attribute_shop.`default_on` = 1 AND product_attribute_shop.id_shop=1) LEFT JOIN xj8_stock_available stock ON (stock.id_product = `p`.id_product AND stock.id_product_attribute = 0 AND stock.id_shop = 1 AND stock.id_shop_group = 0 ) WHERE product_shop.`id_shop` = 1 AND product_shop.`active` = 1 AND cp.`id_category` = 2531 AND product_shop.`visibility` IN ("both", "catalog") GROUP BY cp.`id_product` HAVING (COUNT(a.`id_attribute`) = 0) ) ) total_query LIMIT 1	1.441 ms	43904			/modules/pm_productsbyattributes/pm_productsbyattributes.php:814 /modules/pm_productsbyattributes/src/Pm_ProductsByAttributesCategoryProvider.php:76 (getCategoryProducts) /modules/pm_productsbyattributes/src/Pm_ProductsByAttributesCategoryProvider.php:84 (getProductsOrCount) /modules/pm_productsbyattributes/src/Pm_ProductsByAttributesProductSearchProvider.php:143 (runQuery) /override/classes/controller/ProductListingFrontController.php:361 (runQuery) /override/controllers/front/listing/CategoryController.php:19 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:138 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
501	SELECT SQL_NO_CACHE p., ps., pl.*, sa.out_of_stock, IFNULL(sa.quantity, 0) as quantity, (DATEDIFF( p.`date_add`, DATE_SUB( '2026-10-05 00:00:00', INTERVAL 20 DAY ) ) > 0) as new FROM xj8_product p LEFT JOIN xj8_product_lang pl ON pl.id_product = p.id_product AND pl.id_shop = 1 AND pl.id_lang = 1 LEFT JOIN xj8_stock_available sa ON sa.id_product = p.id_product AND sa.id_product_attribute = 0 AND sa.id_shop = 1 LEFT JOIN xj8_product_shop ps ON ps.id_product = p.id_product AND ps.id_shop = 1 WHERE p.id_product IN (9060,9061,9062,9063,9065,9066,16535,16536,16538,9058,9059,9052,9067,7712,65834,65840)	1.418 ms	16			/classes/ProductAssembler.php:95 /classes/ProductAssembler.php:203 (addMissingProductFieldsForMultipleProducts) /override/classes/ProductAssembler.php:55 (assembleProducts) /override/classes/controller/ProductListingFrontController.php:112 (assembleProducts) /override/classes/controller/ProductListingFrontController.php:382 (prepareMultipleProductsForTemplate) /override/controllers/front/listing/CategoryController.php:19 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:138 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
97	SELECT SQL_NO_CACHE * FROM `xj8_cart_rule` cr LEFT JOIN `xj8_cart_rule_lang` crl ON (cr.`id_cart_rule` = crl.`id_cart_rule` AND crl.`id_lang` = 1) WHERE ((cr.`id_customer` = 0 OR (cr.`id_customer` = 0 AND (cr.`highlight` = 1 OR cr.`code` = "")))) AND NOW() BETWEEN cr.date_from AND cr.date_to AND cr.`active` = 1 AND free_shipping = 1 AND carrier_restriction = 1	1.263 ms	242			/classes/CartRule.php:418 /override/classes/CartRule.php:108 (getCustomerCartRules) /classes/Cart.php:3021 (getCustomerCartRules) /override/classes/Cart.php:475 (getDeliveryOptionList) /classes/Cart.php:3405 (getDeliveryOptionList) /classes/Cart.php:3478 (getDeliveryOption) /src/Core/Cart/Fees.php:96 (getTotalShippingCost) /src/Core/Cart/Calculator.php:354 (processCalculation) /src/Core/Cart/Calculator.php:155 (calculateFees) /classes/Cart.php:2173 (processCalculation) /src/Adapter/Presenter/Cart/CartPresenter.php:334 (getOrderTotal) /override/classes/controller/FrontController.php:538 (present) /override/classes/controller/FrontController.php:607 (assignGeneralPurposeVariables) /controllers/front/listing/CategoryController.php:127 (initContent) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
96	SELECT SQL_NO_CACHE 1 FROM `xj8_cart_rule` WHERE ((date_to >= "2026-10-05 00:00:00" AND date_to <= "2026-10-05 23:59:59") OR (date_from >= "2026-10-05 00:00:00" AND date_from <= "2026-10-05 23:59:59") OR (date_from < "2026-10-05 00:00:00" AND date_to > "2026-10-05 23:59:59")) AND `id_customer` IN (0,0) LIMIT 1	1.180 ms	1237			/classes/CartRule.php:357 /classes/CartRule.php:389 (haveCartRuleToday) /override/classes/CartRule.php:108 (getCustomerCartRules) /classes/Cart.php:3021 (getCustomerCartRules) /override/classes/Cart.php:475 (getDeliveryOptionList) /classes/Cart.php:3405 (getDeliveryOptionList) /classes/Cart.php:3478 (getDeliveryOption) /src/Core/Cart/Fees.php:96 (getTotalShippingCost) /src/Core/Cart/Calculator.php:354 (processCalculation) /src/Core/Cart/Calculator.php:155 (calculateFees) /classes/Cart.php:2173 (processCalculation) /src/Adapter/Presenter/Cart/CartPresenter.php:334 (getOrderTotal) /override/classes/controller/FrontController.php:538 (present) /override/classes/controller/FrontController.php:607 (assignGeneralPurposeVariables) /controllers/front/listing/CategoryController.php:127 (initContent) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
484	SELECT SQL_NO_CACHE COUNT(total) as total FROM ( ( SELECT COUNT(p.`id_product`) as total FROM `xj8_category_product` cp RIGHT JOIN `xj8_category` c ON (c.`id_category` = cp.`id_category` AND c.nleft >= 431 AND c.nright <= 432) LEFT JOIN `xj8_product` p ON p.`id_product` = cp.`id_product` INNER JOIN xj8_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) LEFT JOIN `xj8_product_attribute` pa ON pa.`id_product` = p.`id_product` LEFT JOIN `xj8_product_attribute_combination` pac ON pac.`id_product_attribute` = pa.`id_product_attribute` JOIN `xj8_pm_spa_cache` pa_cartesian ON (pa_cartesian.`id_product` = p.`id_product` AND pa_cartesian.`id_product_attribute` = pa.`id_product_attribute` AND pa_cartesian.`id_shop` = 1) LEFT JOIN xj8_stock_available stock ON (stock.id_product = `p`.id_product AND stock.id_product_attribute = IFNULL(`pa`.id_product_attribute, 0) AND stock.id_shop = 1 AND stock.id_shop_group = 0 ) JOIN `xj8_attribute` a ON a.`id_attribute` = pac.`id_attribute` LEFT JOIN `xj8_product_attribute_shop` product_attribute_shop ON (p.`id_product` = product_attribute_shop.`id_product` AND product_attribute_shop.`id_product_attribute` = pac.`id_product_attribute` AND product_attribute_shop.id_shop=1) WHERE product_shop.`id_shop` = 1 AND IF (stock.`quantity` > 0 OR (p.`cache_default_attribute` > 0 AND p.`cache_default_attribute` = pac.`id_product_attribute`), 1, IF (stock.`out_of_stock` = 2, 0 = 1, stock.`out_of_stock` = 1)) AND product_shop.`active` = 1 AND cp.`id_category` = 2531 AND product_shop.`visibility` IN ("both", "catalog") GROUP BY cp.`id_product`, pa.`id_product_attribute` ) UNION ALL ( SELECT COUNT(p.`id_product`) as total FROM `xj8_category_product` cp RIGHT JOIN `xj8_category` c ON (c.`id_category` = cp.`id_category` AND c.nleft >= 431 AND c.nright <= 432) LEFT JOIN `xj8_product` p ON p.`id_product` = cp.`id_product` INNER JOIN xj8_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) LEFT JOIN `xj8_product_attribute` pa ON pa.`id_product` = p.`id_product` AND pa.`default_on` = 1 LEFT JOIN `xj8_product_attribute_combination` pac ON pac.`id_product_attribute` = pa.`id_product_attribute` LEFT JOIN `xj8_attribute` a ON a.`id_attribute` = pac.`id_attribute` AND (a.`id_attribute_group` IN (1)) LEFT JOIN `xj8_product_attribute_shop` product_attribute_shop ON (p.`id_product` = product_attribute_shop.`id_product` AND product_attribute_shop.`id_product_attribute` = pac.`id_product_attribute` AND product_attribute_shop.`default_on` = 1 AND product_attribute_shop.id_shop=1) LEFT JOIN xj8_stock_available stock ON (stock.id_product = `p`.id_product AND stock.id_product_attribute = 0 AND stock.id_shop = 1 AND stock.id_shop_group = 0 ) WHERE product_shop.`id_shop` = 1 AND product_shop.`active` = 1 AND cp.`id_category` = 2531 AND product_shop.`visibility` IN ("both", "catalog") GROUP BY cp.`id_product` HAVING (COUNT(a.`id_attribute`) = 0) ) ) total_query LIMIT 1	1.165 ms	43904			/modules/pm_productsbyattributes/pm_productsbyattributes.php:814 /modules/pm_productsbyattributes/src/Pm_ProductsByAttributesCategoryProvider.php:76 (getCategoryProducts) /modules/pm_productsbyattributes/src/Pm_ProductsByAttributesCategoryProvider.php:84 (getProductsOrCount) /modules/pm_productsbyattributes/src/Pm_ProductsByAttributesProductSearchProvider.php:153 (runQuery) /override/classes/controller/ProductListingFrontController.php:361 (runQuery) /override/controllers/front/listing/CategoryController.php:19 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:138 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
434	SELECT SQL_NO_CACHE p., product_shop., stock.out_of_stock, IFNULL(stock.quantity, 0) AS quantity, IFNULL(product_attribute_shop.id_product_attribute, 0) AS id_product_attribute, product_attribute_shop.minimal_quantity AS product_attribute_minimal_quantity, pl.`description`, pl.`description_short`, pl.`available_now`, pl.`available_later`, pl.`link_rewrite`, pl.`meta_description`, pl.`meta_keywords`, pl.`meta_title`, pl.`name`, image_shop.`id_image` id_image, il.`legend` as legend, m.`name` AS manufacturer_name, cl.`name` AS category_default, DATEDIFF(product_shop.`date_add`, DATE_SUB("2026-10-05 00:00:00", INTERVAL 20 DAY)) > 0 AS new, product_shop.price AS orderprice FROM `xj8_category_product` cp LEFT JOIN `xj8_product` p ON p.`id_product` = cp.`id_product` INNER JOIN xj8_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) LEFT JOIN `xj8_product_attribute_shop` product_attribute_shop ON (p.`id_product` = product_attribute_shop.`id_product` AND product_attribute_shop.`default_on` = 1 AND product_attribute_shop.id_shop=1) LEFT JOIN xj8_stock_available stock ON (stock.id_product = `p`.id_product AND stock.id_product_attribute = 0 AND stock.id_shop = 1 AND stock.id_shop_group = 0 ) LEFT JOIN `xj8_category_lang` cl ON (product_shop.`id_category_default` = cl.`id_category` AND cl.`id_lang` = 1 AND cl.id_shop = 1 ) LEFT JOIN `xj8_product_lang` pl ON (p.`id_product` = pl.`id_product` AND pl.`id_lang` = 1 AND pl.id_shop = 1 ) LEFT JOIN `xj8_image_shop` image_shop ON (image_shop.`id_product` = p.`id_product` AND image_shop.cover=1 AND image_shop.id_shop=1) LEFT JOIN `xj8_image_lang` il ON (image_shop.`id_image` = il.`id_image` AND il.`id_lang` = 1) LEFT JOIN `xj8_manufacturer` m ON m.`id_manufacturer` = p.`id_manufacturer` WHERE product_shop.`id_shop` = 1 AND cp.`id_category` = 2531 AND product_shop.`active` = 1 AND product_shop.`visibility` IN ("both", "catalog") ORDER BY cp.`position` ASC LIMIT 0,18	1.161 ms	28			/classes/Category.php:1062 /modules/facebookproductad/lib/pixel/pixelCategory.php:60 (getProducts) /modules/facebookproductad/lib/pixel/basePixel.php:266 (__construct) /modules/facebookproductad/lib/moduleTools.php:1508 (get) /modules/facebookproductad/lib/hook/hookDisplay.php:127 (buildDynDisplayTag) :undefined (displayHeader) /modules/facebookproductad/lib/hook/hookDisplay.php:62 (call_user_func_array) /modules/facebookproductad/lib/hook/hookController.php:60 (run) /modules/facebookproductad/facebookproductad.php:166 (run) /modules/facebookproductad/facebookproductad.php:142 (_execHook) /classes/Hook.php:1043 (hookDisplayHeader) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:418 (coreCallHook) /classes/Hook.php:981 (callHookOn) /override/classes/controller/FrontController.php:615 (exec) /controllers/front/listing/CategoryController.php:127 (initContent) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
1089	SELECT SQL_NO_CACHE sms., smsl. ,IF(image_multi_lang<>"" && !ISNULL(image_multi_lang), image_multi_lang, image_lang_default) AS image_multi_lang FROM `xj8_st_page_banner` sms LEFT JOIN `xj8_st_page_banner_lang` smsl ON (sms.`id_st_page_banner` = smsl.`id_st_page_banner`) INNER JOIN xj8_st_page_banner_shop st_page_banner_shop ON (st_page_banner_shop.id_st_page_banner = sms.id_st_page_banner AND st_page_banner_shop.id_shop = 1) WHERE smsl.`id_lang` = 1 AND sms.`active`=1 AND sms.`item_k`=1 AND (sms.`show_subcate` = 0 AND sms.`item_v`="2531" OR sms.`show_subcate` = 1 AND sms.`item_v` IN(2531,2529,2517,2,1)) ORDER BY sms.`position` LIMIT 1	1.037 ms	1	Yes		/modules/stpagebanner/classes/StPageBannerClass.php:197 /modules/stpagebanner/stpagebanner.php:1430 (getAll) /modules/stpagebanner/stpagebanner.php:1559 (_prepareHook) /classes/Hook.php:1043 (hookDisplayBreadcrumb) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:418 (coreCallHook) /classes/Hook.php:981 (callHookOn) /config/smarty.config.inc.php:198 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/prod/smarty/compile/child_pandalayouts_layout_left_column_tpl/16/5e/69/165e6984cc26fc4d30c2e41af5deec6faa952708_2.file.layout-both-columns.tpl.php:368 (__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/prod/smarty/compile/child_pandalayouts_layout_left_column_tpl/16/5e/69/165e6984cc26fc4d30c2e41af5deec6faa952708_2.file.layout-both-columns.tpl.php:104 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6ac393aa1556a4_70405393) /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:116 (_subTemplateRender) /var/cache/prod/smarty/compile/child_pandalayouts_layout_left_column_tpl/6c/3d/79/6c3d7966117dae2bd9ae5035b3ee6cd2e1b2a36d_2.file.layout-left-column.tpl.php:47 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6ac393aa0c3f38_98812868) /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:116 (_subTemplateRender) /var/cache/prod/smarty/compile/child_pandalayouts_layout_left_column_tpl/76/a9/5b/76a95be99df01b610fca2bca744f33c00edb13af_2.file.product-list.tpl.php:39 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6ac393aa0babf9_11094935) /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:116 (_subTemplateRender) /var/cache/prod/smarty/compile/child_pandalayouts_layout_left_column_tpl/c6/ad/da/c6addaa5971b2a1e943f8f0e8a5fdba2ed93b339_2.file.category.tpl.php:42 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6ac393aa08f0e9_25151483) /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) /override/classes/controller/FrontController.php:762 (fetch) /override/classes/controller/FrontController.php:744 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
1430	SELECT SQL_NO_CACHE snl.*, snll.`content` FROM `xj8_st_news_letter` snl INNER JOIN xj8_st_news_letter_shop st_news_letter_shop ON (st_news_letter_shop.id_st_news_letter = snl.id_st_news_letter AND st_news_letter_shop.id_shop = 1) LEFT JOIN `xj8_st_news_letter_lang` snll ON (snl.`id_st_news_letter` = snll.`id_st_news_letter`) WHERE snl.`active`=1 AND snll.`id_lang` = 1 AND snl.`location` IN (4) ORDER BY snl.`position`	1.035 ms	1	Yes		/modules/stnewsletter/classes/StNewsLetterClass.php:243 /modules/stnewsletter/stnewsletter.php:1757 (getNewsLetter) /modules/stnewsletter/stnewsletter.php:1813 (_prepareHook) /classes/Hook.php:1043 (hookDisplaySideBar) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:418 (coreCallHook) /classes/Hook.php:981 (callHookOn) /config/smarty.config.inc.php:198 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/prod/smarty/compile/child_pandalayouts_layout_left_column_tpl/16/5e/69/165e6984cc26fc4d30c2e41af5deec6faa952708_2.file.layout-both-columns.tpl.php:599 (__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/prod/smarty/compile/child_pandalayouts_layout_left_column_tpl/16/5e/69/165e6984cc26fc4d30c2e41af5deec6faa952708_2.file.layout-both-columns.tpl.php:160 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6ac393aa1556a4_70405393) /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:116 (_subTemplateRender) /var/cache/prod/smarty/compile/child_pandalayouts_layout_left_column_tpl/6c/3d/79/6c3d7966117dae2bd9ae5035b3ee6cd2e1b2a36d_2.file.layout-left-column.tpl.php:47 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6ac393aa0c3f38_98812868) /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:116 (_subTemplateRender) /var/cache/prod/smarty/compile/child_pandalayouts_layout_left_column_tpl/76/a9/5b/76a95be99df01b610fca2bca744f33c00edb13af_2.file.product-list.tpl.php:39 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6ac393aa0babf9_11094935) /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:116 (_subTemplateRender) /var/cache/prod/smarty/compile/child_pandalayouts_layout_left_column_tpl/c6/ad/da/c6addaa5971b2a1e943f8f0e8a5fdba2ed93b339_2.file.category.tpl.php:42 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6ac393aa08f0e9_25151483) /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) /override/classes/controller/FrontController.php:762 (fetch) /override/classes/controller/FrontController.php:744 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
487	SELECT SQL_NO_CACHE pa., product_attribute_shop., GROUP_CONCAT(ag.`id_attribute_group`) AS `id_attribute_group`, GROUP_CONCAT(a.`id_attribute`) AS `id_attribute`, GROUP_CONCAT(al.`name` SEPARATOR "\|s\|p\|a\|") AS attribute_name, GROUP_CONCAT(ag.`is_color_group`) AS `is_color_group`, GROUP_CONCAT(pac.`id_attribute`) as id_attribute_list_custom, p.cache_default_attribute FROM `xj8_product_attribute` pa INNER JOIN xj8_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) LEFT JOIN `xj8_product_attribute_combination` pac ON pac.`id_product_attribute` = pa.`id_product_attribute` LEFT JOIN `xj8_attribute` a ON a.`id_attribute` = pac.`id_attribute` LEFT JOIN `xj8_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group` LEFT JOIN `xj8_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1) JOIN `xj8_product` p ON (p.`id_product` = pa.`id_product`) LEFT JOIN xj8_stock_available stock ON (stock.id_product = `p`.id_product AND stock.id_product_attribute = IFNULL(`pa`.id_product_attribute, 0) AND stock.id_shop = 1 AND stock.id_shop_group = 0 ) WHERE pa.`id_product` = 9062 AND IF (stock.`quantity` > 0 OR (p.`cache_default_attribute` > 0 AND p.`cache_default_attribute` = pac.`id_product_attribute`), 1, IF (stock.`out_of_stock` = 2, 0 = 1, stock.`out_of_stock` = 1)) GROUP BY pa.`id_product_attribute` ORDER BY product_attribute_shop.`price` ASC	1.002 ms	1	Yes		/modules/pm_productsbyattributes/pm_productsbyattributes.php:1252 /modules/pm_productsbyattributes/pm_productsbyattributes.php:1287 (getAttributeCombinationsById) /modules/pm_productsbyattributes/src/Pm_ProductsByAttributesProductSearchProvider.php:324 (getFullProductName) /override/classes/controller/ProductListingFrontController.php:361 (runQuery) /override/controllers/front/listing/CategoryController.php:19 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:138 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
485	SELECT SQL_NO_CACHE pa., product_attribute_shop., GROUP_CONCAT(ag.`id_attribute_group`) AS `id_attribute_group`, GROUP_CONCAT(a.`id_attribute`) AS `id_attribute`, GROUP_CONCAT(al.`name` SEPARATOR "\|s\|p\|a\|") AS attribute_name, GROUP_CONCAT(ag.`is_color_group`) AS `is_color_group`, GROUP_CONCAT(pac.`id_attribute`) as id_attribute_list_custom, p.cache_default_attribute FROM `xj8_product_attribute` pa INNER JOIN xj8_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) LEFT JOIN `xj8_product_attribute_combination` pac ON pac.`id_product_attribute` = pa.`id_product_attribute` LEFT JOIN `xj8_attribute` a ON a.`id_attribute` = pac.`id_attribute` LEFT JOIN `xj8_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group` LEFT JOIN `xj8_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1) JOIN `xj8_product` p ON (p.`id_product` = pa.`id_product`) LEFT JOIN xj8_stock_available stock ON (stock.id_product = `p`.id_product AND stock.id_product_attribute = IFNULL(`pa`.id_product_attribute, 0) AND stock.id_shop = 1 AND stock.id_shop_group = 0 ) WHERE pa.`id_product` = 9060 AND IF (stock.`quantity` > 0 OR (p.`cache_default_attribute` > 0 AND p.`cache_default_attribute` = pac.`id_product_attribute`), 1, IF (stock.`out_of_stock` = 2, 0 = 1, stock.`out_of_stock` = 1)) GROUP BY pa.`id_product_attribute` ORDER BY product_attribute_shop.`price` ASC	0.990 ms	1	Yes		/modules/pm_productsbyattributes/pm_productsbyattributes.php:1252 /modules/pm_productsbyattributes/pm_productsbyattributes.php:1287 (getAttributeCombinationsById) /modules/pm_productsbyattributes/src/Pm_ProductsByAttributesProductSearchProvider.php:324 (getFullProductName) /override/classes/controller/ProductListingFrontController.php:361 (runQuery) /override/controllers/front/listing/CategoryController.php:19 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:138 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
490	SELECT SQL_NO_CACHE pa., product_attribute_shop., GROUP_CONCAT(ag.`id_attribute_group`) AS `id_attribute_group`, GROUP_CONCAT(a.`id_attribute`) AS `id_attribute`, GROUP_CONCAT(al.`name` SEPARATOR "\|s\|p\|a\|") AS attribute_name, GROUP_CONCAT(ag.`is_color_group`) AS `is_color_group`, GROUP_CONCAT(pac.`id_attribute`) as id_attribute_list_custom, p.cache_default_attribute FROM `xj8_product_attribute` pa INNER JOIN xj8_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) LEFT JOIN `xj8_product_attribute_combination` pac ON pac.`id_product_attribute` = pa.`id_product_attribute` LEFT JOIN `xj8_attribute` a ON a.`id_attribute` = pac.`id_attribute` LEFT JOIN `xj8_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group` LEFT JOIN `xj8_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1) JOIN `xj8_product` p ON (p.`id_product` = pa.`id_product`) LEFT JOIN xj8_stock_available stock ON (stock.id_product = `p`.id_product AND stock.id_product_attribute = IFNULL(`pa`.id_product_attribute, 0) AND stock.id_shop = 1 AND stock.id_shop_group = 0 ) WHERE pa.`id_product` = 9066 AND IF (stock.`quantity` > 0 OR (p.`cache_default_attribute` > 0 AND p.`cache_default_attribute` = pac.`id_product_attribute`), 1, IF (stock.`out_of_stock` = 2, 0 = 1, stock.`out_of_stock` = 1)) GROUP BY pa.`id_product_attribute` ORDER BY product_attribute_shop.`price` ASC	0.970 ms	1	Yes		/modules/pm_productsbyattributes/pm_productsbyattributes.php:1252 /modules/pm_productsbyattributes/pm_productsbyattributes.php:1287 (getAttributeCombinationsById) /modules/pm_productsbyattributes/src/Pm_ProductsByAttributesProductSearchProvider.php:324 (getFullProductName) /override/classes/controller/ProductListingFrontController.php:361 (runQuery) /override/controllers/front/listing/CategoryController.php:19 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:138 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
486	SELECT SQL_NO_CACHE pa., product_attribute_shop., GROUP_CONCAT(ag.`id_attribute_group`) AS `id_attribute_group`, GROUP_CONCAT(a.`id_attribute`) AS `id_attribute`, GROUP_CONCAT(al.`name` SEPARATOR "\|s\|p\|a\|") AS attribute_name, GROUP_CONCAT(ag.`is_color_group`) AS `is_color_group`, GROUP_CONCAT(pac.`id_attribute`) as id_attribute_list_custom, p.cache_default_attribute FROM `xj8_product_attribute` pa INNER JOIN xj8_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) LEFT JOIN `xj8_product_attribute_combination` pac ON pac.`id_product_attribute` = pa.`id_product_attribute` LEFT JOIN `xj8_attribute` a ON a.`id_attribute` = pac.`id_attribute` LEFT JOIN `xj8_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group` LEFT JOIN `xj8_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1) JOIN `xj8_product` p ON (p.`id_product` = pa.`id_product`) LEFT JOIN xj8_stock_available stock ON (stock.id_product = `p`.id_product AND stock.id_product_attribute = IFNULL(`pa`.id_product_attribute, 0) AND stock.id_shop = 1 AND stock.id_shop_group = 0 ) WHERE pa.`id_product` = 9061 AND IF (stock.`quantity` > 0 OR (p.`cache_default_attribute` > 0 AND p.`cache_default_attribute` = pac.`id_product_attribute`), 1, IF (stock.`out_of_stock` = 2, 0 = 1, stock.`out_of_stock` = 1)) GROUP BY pa.`id_product_attribute` ORDER BY product_attribute_shop.`price` ASC	0.965 ms	1	Yes		/modules/pm_productsbyattributes/pm_productsbyattributes.php:1252 /modules/pm_productsbyattributes/pm_productsbyattributes.php:1287 (getAttributeCombinationsById) /modules/pm_productsbyattributes/src/Pm_ProductsByAttributesProductSearchProvider.php:324 (getFullProductName) /override/classes/controller/ProductListingFrontController.php:361 (runQuery) /override/controllers/front/listing/CategoryController.php:19 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:138 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
1437	SELECT SQL_NO_CACHE snl., snll. FROM `xj8_st_notification` snl INNER JOIN xj8_st_notification_shop st_notification_shop ON (st_notification_shop.id_st_notification = snl.id_st_notification AND st_notification_shop.id_shop = 1) LEFT JOIN `xj8_st_notification_lang` snll ON (snl.`id_st_notification` = snll.`id_st_notification`) WHERE snl.`active`=1 AND snll.`id_lang` = 1 ORDER BY snl.`position`	0.943 ms	1	Yes		/modules/stnotification/classes/StNotificationClass.php:213 /modules/stnotification/stnotification.php:1255 (getNotification) /modules/stnotification/stnotification.php:1248 (getWidgetVariables) /classes/Hook.php:1054 (renderWidget) /tools/profiling/Hook.php:64 (coreRenderWidget) /classes/Hook.php:1000 (coreRenderWidget) /config/smarty.config.inc.php:198 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/prod/smarty/compile/child_pandalayouts_layout_left_column_tpl/16/5e/69/165e6984cc26fc4d30c2e41af5deec6faa952708_2.file.layout-both-columns.tpl.php:701 (__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/prod/smarty/compile/child_pandalayouts_layout_left_column_tpl/16/5e/69/165e6984cc26fc4d30c2e41af5deec6faa952708_2.file.layout-both-columns.tpl.php:195 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6ac393aa1556a4_70405393) /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:116 (_subTemplateRender) /var/cache/prod/smarty/compile/child_pandalayouts_layout_left_column_tpl/6c/3d/79/6c3d7966117dae2bd9ae5035b3ee6cd2e1b2a36d_2.file.layout-left-column.tpl.php:47 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6ac393aa0c3f38_98812868) /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:116 (_subTemplateRender) /var/cache/prod/smarty/compile/child_pandalayouts_layout_left_column_tpl/76/a9/5b/76a95be99df01b610fca2bca744f33c00edb13af_2.file.product-list.tpl.php:39 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6ac393aa0babf9_11094935) /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:116 (_subTemplateRender) /var/cache/prod/smarty/compile/child_pandalayouts_layout_left_column_tpl/c6/ad/da/c6addaa5971b2a1e943f8f0e8a5fdba2ed93b339_2.file.category.tpl.php:42 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6ac393aa08f0e9_25151483) /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) /override/classes/controller/FrontController.php:762 (fetch) /override/classes/controller/FrontController.php:744 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
209	SELECT SQL_NO_CACHE * FROM `xj8_st_loved_product` WHERE 1 AND `id_shop`=1 AND ( `id_guest` = 17126222) ORDER BY date_add DESC	0.936 ms	1530	Yes		/modules/stlovedproduct/classes/StLovedProductClass.php:137 /override/modules/stlovedproduct/stlovedproduct.php:1054 (getMyLoved) /classes/Hook.php:1043 (hookDisplayHeader) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:418 (coreCallHook) /classes/Hook.php:981 (callHookOn) /override/classes/controller/FrontController.php:615 (exec) /controllers/front/listing/CategoryController.php:127 (initContent) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
500	SELECT SQL_NO_CACHE pa., product_attribute_shop., GROUP_CONCAT(ag.`id_attribute_group`) AS `id_attribute_group`, GROUP_CONCAT(a.`id_attribute`) AS `id_attribute`, GROUP_CONCAT(al.`name` SEPARATOR "\|s\|p\|a\|") AS attribute_name, GROUP_CONCAT(ag.`is_color_group`) AS `is_color_group`, GROUP_CONCAT(pac.`id_attribute`) as id_attribute_list_custom, p.cache_default_attribute FROM `xj8_product_attribute` pa INNER JOIN xj8_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) LEFT JOIN `xj8_product_attribute_combination` pac ON pac.`id_product_attribute` = pa.`id_product_attribute` LEFT JOIN `xj8_attribute` a ON a.`id_attribute` = pac.`id_attribute` LEFT JOIN `xj8_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group` LEFT JOIN `xj8_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1) JOIN `xj8_product` p ON (p.`id_product` = pa.`id_product`) LEFT JOIN xj8_stock_available stock ON (stock.id_product = `p`.id_product AND stock.id_product_attribute = IFNULL(`pa`.id_product_attribute, 0) AND stock.id_shop = 1 AND stock.id_shop_group = 0 ) WHERE pa.`id_product` = 65840 AND IF (stock.`quantity` > 0 OR (p.`cache_default_attribute` > 0 AND p.`cache_default_attribute` = pac.`id_product_attribute`), 1, IF (stock.`out_of_stock` = 2, 0 = 1, stock.`out_of_stock` = 1)) GROUP BY pa.`id_product_attribute` ORDER BY product_attribute_shop.`price` ASC	0.914 ms	1	Yes		/modules/pm_productsbyattributes/pm_productsbyattributes.php:1252 /modules/pm_productsbyattributes/pm_productsbyattributes.php:1287 (getAttributeCombinationsById) /modules/pm_productsbyattributes/src/Pm_ProductsByAttributesProductSearchProvider.php:324 (getFullProductName) /override/classes/controller/ProductListingFrontController.php:361 (runQuery) /override/controllers/front/listing/CategoryController.php:19 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:138 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
488	SELECT SQL_NO_CACHE pa., product_attribute_shop., GROUP_CONCAT(ag.`id_attribute_group`) AS `id_attribute_group`, GROUP_CONCAT(a.`id_attribute`) AS `id_attribute`, GROUP_CONCAT(al.`name` SEPARATOR "\|s\|p\|a\|") AS attribute_name, GROUP_CONCAT(ag.`is_color_group`) AS `is_color_group`, GROUP_CONCAT(pac.`id_attribute`) as id_attribute_list_custom, p.cache_default_attribute FROM `xj8_product_attribute` pa INNER JOIN xj8_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) LEFT JOIN `xj8_product_attribute_combination` pac ON pac.`id_product_attribute` = pa.`id_product_attribute` LEFT JOIN `xj8_attribute` a ON a.`id_attribute` = pac.`id_attribute` LEFT JOIN `xj8_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group` LEFT JOIN `xj8_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1) JOIN `xj8_product` p ON (p.`id_product` = pa.`id_product`) LEFT JOIN xj8_stock_available stock ON (stock.id_product = `p`.id_product AND stock.id_product_attribute = IFNULL(`pa`.id_product_attribute, 0) AND stock.id_shop = 1 AND stock.id_shop_group = 0 ) WHERE pa.`id_product` = 9063 AND IF (stock.`quantity` > 0 OR (p.`cache_default_attribute` > 0 AND p.`cache_default_attribute` = pac.`id_product_attribute`), 1, IF (stock.`out_of_stock` = 2, 0 = 1, stock.`out_of_stock` = 1)) GROUP BY pa.`id_product_attribute` ORDER BY product_attribute_shop.`price` ASC	0.906 ms	1	Yes		/modules/pm_productsbyattributes/pm_productsbyattributes.php:1252 /modules/pm_productsbyattributes/pm_productsbyattributes.php:1287 (getAttributeCombinationsById) /modules/pm_productsbyattributes/src/Pm_ProductsByAttributesProductSearchProvider.php:324 (getFullProductName) /override/classes/controller/ProductListingFrontController.php:361 (runQuery) /override/controllers/front/listing/CategoryController.php:19 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:138 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
489	SELECT SQL_NO_CACHE pa., product_attribute_shop., GROUP_CONCAT(ag.`id_attribute_group`) AS `id_attribute_group`, GROUP_CONCAT(a.`id_attribute`) AS `id_attribute`, GROUP_CONCAT(al.`name` SEPARATOR "\|s\|p\|a\|") AS attribute_name, GROUP_CONCAT(ag.`is_color_group`) AS `is_color_group`, GROUP_CONCAT(pac.`id_attribute`) as id_attribute_list_custom, p.cache_default_attribute FROM `xj8_product_attribute` pa INNER JOIN xj8_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) LEFT JOIN `xj8_product_attribute_combination` pac ON pac.`id_product_attribute` = pa.`id_product_attribute` LEFT JOIN `xj8_attribute` a ON a.`id_attribute` = pac.`id_attribute` LEFT JOIN `xj8_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group` LEFT JOIN `xj8_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1) JOIN `xj8_product` p ON (p.`id_product` = pa.`id_product`) LEFT JOIN xj8_stock_available stock ON (stock.id_product = `p`.id_product AND stock.id_product_attribute = IFNULL(`pa`.id_product_attribute, 0) AND stock.id_shop = 1 AND stock.id_shop_group = 0 ) WHERE pa.`id_product` = 9065 AND IF (stock.`quantity` > 0 OR (p.`cache_default_attribute` > 0 AND p.`cache_default_attribute` = pac.`id_product_attribute`), 1, IF (stock.`out_of_stock` = 2, 0 = 1, stock.`out_of_stock` = 1)) GROUP BY pa.`id_product_attribute` ORDER BY product_attribute_shop.`price` ASC	0.905 ms	1	Yes		/modules/pm_productsbyattributes/pm_productsbyattributes.php:1252 /modules/pm_productsbyattributes/pm_productsbyattributes.php:1287 (getAttributeCombinationsById) /modules/pm_productsbyattributes/src/Pm_ProductsByAttributesProductSearchProvider.php:324 (getFullProductName) /override/classes/controller/ProductListingFrontController.php:361 (runQuery) /override/controllers/front/listing/CategoryController.php:19 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:138 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
492	SELECT SQL_NO_CACHE pa., product_attribute_shop., GROUP_CONCAT(ag.`id_attribute_group`) AS `id_attribute_group`, GROUP_CONCAT(a.`id_attribute`) AS `id_attribute`, GROUP_CONCAT(al.`name` SEPARATOR "\|s\|p\|a\|") AS attribute_name, GROUP_CONCAT(ag.`is_color_group`) AS `is_color_group`, GROUP_CONCAT(pac.`id_attribute`) as id_attribute_list_custom, p.cache_default_attribute FROM `xj8_product_attribute` pa INNER JOIN xj8_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) LEFT JOIN `xj8_product_attribute_combination` pac ON pac.`id_product_attribute` = pa.`id_product_attribute` LEFT JOIN `xj8_attribute` a ON a.`id_attribute` = pac.`id_attribute` LEFT JOIN `xj8_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group` LEFT JOIN `xj8_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1) JOIN `xj8_product` p ON (p.`id_product` = pa.`id_product`) LEFT JOIN xj8_stock_available stock ON (stock.id_product = `p`.id_product AND stock.id_product_attribute = IFNULL(`pa`.id_product_attribute, 0) AND stock.id_shop = 1 AND stock.id_shop_group = 0 ) WHERE pa.`id_product` = 16536 AND IF (stock.`quantity` > 0 OR (p.`cache_default_attribute` > 0 AND p.`cache_default_attribute` = pac.`id_product_attribute`), 1, IF (stock.`out_of_stock` = 2, 0 = 1, stock.`out_of_stock` = 1)) GROUP BY pa.`id_product_attribute` ORDER BY product_attribute_shop.`price` ASC	0.894 ms	1	Yes		/modules/pm_productsbyattributes/pm_productsbyattributes.php:1252 /modules/pm_productsbyattributes/pm_productsbyattributes.php:1287 (getAttributeCombinationsById) /modules/pm_productsbyattributes/src/Pm_ProductsByAttributesProductSearchProvider.php:324 (getFullProductName) /override/classes/controller/ProductListingFrontController.php:361 (runQuery) /override/controllers/front/listing/CategoryController.php:19 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:138 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
494	SELECT SQL_NO_CACHE pa., product_attribute_shop., GROUP_CONCAT(ag.`id_attribute_group`) AS `id_attribute_group`, GROUP_CONCAT(a.`id_attribute`) AS `id_attribute`, GROUP_CONCAT(al.`name` SEPARATOR "\|s\|p\|a\|") AS attribute_name, GROUP_CONCAT(ag.`is_color_group`) AS `is_color_group`, GROUP_CONCAT(pac.`id_attribute`) as id_attribute_list_custom, p.cache_default_attribute FROM `xj8_product_attribute` pa INNER JOIN xj8_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) LEFT JOIN `xj8_product_attribute_combination` pac ON pac.`id_product_attribute` = pa.`id_product_attribute` LEFT JOIN `xj8_attribute` a ON a.`id_attribute` = pac.`id_attribute` LEFT JOIN `xj8_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group` LEFT JOIN `xj8_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1) JOIN `xj8_product` p ON (p.`id_product` = pa.`id_product`) LEFT JOIN xj8_stock_available stock ON (stock.id_product = `p`.id_product AND stock.id_product_attribute = IFNULL(`pa`.id_product_attribute, 0) AND stock.id_shop = 1 AND stock.id_shop_group = 0 ) WHERE pa.`id_product` = 9058 AND IF (stock.`quantity` > 0 OR (p.`cache_default_attribute` > 0 AND p.`cache_default_attribute` = pac.`id_product_attribute`), 1, IF (stock.`out_of_stock` = 2, 0 = 1, stock.`out_of_stock` = 1)) GROUP BY pa.`id_product_attribute` ORDER BY product_attribute_shop.`price` ASC	0.873 ms	1	Yes		/modules/pm_productsbyattributes/pm_productsbyattributes.php:1252 /modules/pm_productsbyattributes/pm_productsbyattributes.php:1287 (getAttributeCombinationsById) /modules/pm_productsbyattributes/src/Pm_ProductsByAttributesProductSearchProvider.php:324 (getFullProductName) /override/classes/controller/ProductListingFrontController.php:361 (runQuery) /override/controllers/front/listing/CategoryController.php:19 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:138 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
1090	SELECT SQL_NO_CACHE sms., smsl. ,IF(image_multi_lang<>"" && !ISNULL(image_multi_lang), image_multi_lang, image_lang_default) AS image_multi_lang FROM `xj8_st_page_banner` sms LEFT JOIN `xj8_st_page_banner_lang` smsl ON (sms.`id_st_page_banner` = smsl.`id_st_page_banner`) INNER JOIN xj8_st_page_banner_shop st_page_banner_shop ON (st_page_banner_shop.id_st_page_banner = sms.id_st_page_banner AND st_page_banner_shop.id_shop = 1) WHERE smsl.`id_lang` = 1 AND sms.`active`=1 AND sms.`item_k`=11 AND sms.`item_v`="1" ORDER BY sms.`position` LIMIT 1	0.866 ms	1	Yes		/modules/stpagebanner/classes/StPageBannerClass.php:197 /modules/stpagebanner/stpagebanner.php:1432 (getAll) /modules/stpagebanner/stpagebanner.php:1559 (_prepareHook) /classes/Hook.php:1043 (hookDisplayBreadcrumb) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:418 (coreCallHook) /classes/Hook.php:981 (callHookOn) /config/smarty.config.inc.php:198 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/prod/smarty/compile/child_pandalayouts_layout_left_column_tpl/16/5e/69/165e6984cc26fc4d30c2e41af5deec6faa952708_2.file.layout-both-columns.tpl.php:368 (__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/prod/smarty/compile/child_pandalayouts_layout_left_column_tpl/16/5e/69/165e6984cc26fc4d30c2e41af5deec6faa952708_2.file.layout-both-columns.tpl.php:104 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6ac393aa1556a4_70405393) /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:116 (_subTemplateRender) /var/cache/prod/smarty/compile/child_pandalayouts_layout_left_column_tpl/6c/3d/79/6c3d7966117dae2bd9ae5035b3ee6cd2e1b2a36d_2.file.layout-left-column.tpl.php:47 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6ac393aa0c3f38_98812868) /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:116 (_subTemplateRender) /var/cache/prod/smarty/compile/child_pandalayouts_layout_left_column_tpl/76/a9/5b/76a95be99df01b610fca2bca744f33c00edb13af_2.file.product-list.tpl.php:39 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6ac393aa0babf9_11094935) /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:116 (_subTemplateRender) /var/cache/prod/smarty/compile/child_pandalayouts_layout_left_column_tpl/c6/ad/da/c6addaa5971b2a1e943f8f0e8a5fdba2ed93b339_2.file.category.tpl.php:42 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6ac393aa08f0e9_25151483) /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) /override/classes/controller/FrontController.php:762 (fetch) /override/classes/controller/FrontController.php:744 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
176	SELECT SQL_NO_CACHE 1 FROM `xj8_cart_rule` WHERE ((date_to >= "2026-10-05 00:00:00" AND date_to <= "2026-10-05 23:59:59") OR (date_from >= "2026-10-05 00:00:00" AND date_from <= "2026-10-05 23:59:59") OR (date_from < "2026-10-05 00:00:00" AND date_to > "2026-10-05 23:59:59")) AND `id_customer` IN (0,0) LIMIT 1	0.864 ms	1237			/classes/CartRule.php:357 /classes/CartRule.php:389 (haveCartRuleToday) /override/classes/CartRule.php:108 (getCustomerCartRules) /override/classes/CartRule.php:154 (getCustomerCartRules) /classes/Cart.php:522 (getCustomerHighlightedDiscounts) /src/Adapter/Presenter/Cart/CartPresenter.php:444 (getDiscounts) /override/classes/controller/FrontController.php:538 (present) /override/classes/controller/FrontController.php:607 (assignGeneralPurposeVariables) /controllers/front/listing/CategoryController.php:127 (initContent) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
497	SELECT SQL_NO_CACHE pa., product_attribute_shop., GROUP_CONCAT(ag.`id_attribute_group`) AS `id_attribute_group`, GROUP_CONCAT(a.`id_attribute`) AS `id_attribute`, GROUP_CONCAT(al.`name` SEPARATOR "\|s\|p\|a\|") AS attribute_name, GROUP_CONCAT(ag.`is_color_group`) AS `is_color_group`, GROUP_CONCAT(pac.`id_attribute`) as id_attribute_list_custom, p.cache_default_attribute FROM `xj8_product_attribute` pa INNER JOIN xj8_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) LEFT JOIN `xj8_product_attribute_combination` pac ON pac.`id_product_attribute` = pa.`id_product_attribute` LEFT JOIN `xj8_attribute` a ON a.`id_attribute` = pac.`id_attribute` LEFT JOIN `xj8_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group` LEFT JOIN `xj8_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1) JOIN `xj8_product` p ON (p.`id_product` = pa.`id_product`) LEFT JOIN xj8_stock_available stock ON (stock.id_product = `p`.id_product AND stock.id_product_attribute = IFNULL(`pa`.id_product_attribute, 0) AND stock.id_shop = 1 AND stock.id_shop_group = 0 ) WHERE pa.`id_product` = 9067 AND IF (stock.`quantity` > 0 OR (p.`cache_default_attribute` > 0 AND p.`cache_default_attribute` = pac.`id_product_attribute`), 1, IF (stock.`out_of_stock` = 2, 0 = 1, stock.`out_of_stock` = 1)) GROUP BY pa.`id_product_attribute` ORDER BY product_attribute_shop.`price` ASC	0.855 ms	1	Yes		/modules/pm_productsbyattributes/pm_productsbyattributes.php:1252 /modules/pm_productsbyattributes/pm_productsbyattributes.php:1287 (getAttributeCombinationsById) /modules/pm_productsbyattributes/src/Pm_ProductsByAttributesProductSearchProvider.php:324 (getFullProductName) /override/classes/controller/ProductListingFrontController.php:361 (runQuery) /override/controllers/front/listing/CategoryController.php:19 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:138 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
17	SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module`as `mshop` FROM `xj8_module` m LEFT JOIN `xj8_module_shop` ms ON m.`id_module` = ms.`id_module` AND ms.`id_shop` = 1	0.828 ms	151			/classes/module/Module.php:345 /modules/stblog/stblog.php:89 (__construct) /override/modules/stblog/stblog.php:90 (__construct) :undefined (__construct) /src/Core/Foundation/IoC/Container.php:123 (newInstance) /src/Core/Foundation/IoC/Container.php:153 (makeInstanceFromClassName) /src/Core/Foundation/IoC/Container.php:166 (doMake) /src/Adapter/ServiceLocator.php:70 (make) /classes/module/Module.php:1230 (get) /tools/profiling/Module.php:35 (coreLoadModule) /classes/module/Module.php:1214 (coreLoadModule) /classes/Hook.php:966 (getInstanceByName) /classes/Dispatcher.php:606 (exec) /classes/Dispatcher.php:243 (loadRoutes) /classes/Dispatcher.php:201 (__construct) /index.php:28 (getInstance)
491	SELECT SQL_NO_CACHE pa., product_attribute_shop., GROUP_CONCAT(ag.`id_attribute_group`) AS `id_attribute_group`, GROUP_CONCAT(a.`id_attribute`) AS `id_attribute`, GROUP_CONCAT(al.`name` SEPARATOR "\|s\|p\|a\|") AS attribute_name, GROUP_CONCAT(ag.`is_color_group`) AS `is_color_group`, GROUP_CONCAT(pac.`id_attribute`) as id_attribute_list_custom, p.cache_default_attribute FROM `xj8_product_attribute` pa INNER JOIN xj8_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) LEFT JOIN `xj8_product_attribute_combination` pac ON pac.`id_product_attribute` = pa.`id_product_attribute` LEFT JOIN `xj8_attribute` a ON a.`id_attribute` = pac.`id_attribute` LEFT JOIN `xj8_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group` LEFT JOIN `xj8_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1) JOIN `xj8_product` p ON (p.`id_product` = pa.`id_product`) LEFT JOIN xj8_stock_available stock ON (stock.id_product = `p`.id_product AND stock.id_product_attribute = IFNULL(`pa`.id_product_attribute, 0) AND stock.id_shop = 1 AND stock.id_shop_group = 0 ) WHERE pa.`id_product` = 16535 AND IF (stock.`quantity` > 0 OR (p.`cache_default_attribute` > 0 AND p.`cache_default_attribute` = pac.`id_product_attribute`), 1, IF (stock.`out_of_stock` = 2, 0 = 1, stock.`out_of_stock` = 1)) GROUP BY pa.`id_product_attribute` ORDER BY product_attribute_shop.`price` ASC	0.826 ms	1	Yes		/modules/pm_productsbyattributes/pm_productsbyattributes.php:1252 /modules/pm_productsbyattributes/pm_productsbyattributes.php:1287 (getAttributeCombinationsById) /modules/pm_productsbyattributes/src/Pm_ProductsByAttributesProductSearchProvider.php:324 (getFullProductName) /override/classes/controller/ProductListingFrontController.php:361 (runQuery) /override/controllers/front/listing/CategoryController.php:19 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:138 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
994	SELECT SQL_NO_CACHE snl., snll. FROM `xj8_st_notification` snl INNER JOIN xj8_st_notification_shop st_notification_shop ON (st_notification_shop.id_st_notification = snl.id_st_notification AND st_notification_shop.id_shop = 1) LEFT JOIN `xj8_st_notification_lang` snll ON (snl.`id_st_notification` = snll.`id_st_notification`) WHERE snl.`active`=1 AND snll.`id_lang` = 1 ORDER BY snl.`position`	0.800 ms	1	Yes		/modules/stnotification/classes/StNotificationClass.php:213 /modules/stnotification/stnotification.php:1255 (getNotification) /modules/stnotification/stnotification.php:1248 (getWidgetVariables) /classes/Hook.php:1054 (renderWidget) /tools/profiling/Hook.php:64 (coreRenderWidget) /classes/Hook.php:1000 (coreRenderWidget) /config/smarty.config.inc.php:198 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/prod/smarty/compile/child_pandalayouts_layout_left_column_tpl/4e/8f/84/4e8f8467a691768e14a56ca5b1dd4fe3ec1adfe1_2.file.header.tpl.php:57 (__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/prod/smarty/compile/child_pandalayouts_layout_left_column_tpl/4e/8f/84/4e8f8467a691768e14a56ca5b1dd4fe3ec1adfe1_2.file.header.tpl.php:26 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6ac393aa281038_14145018) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /var/cache/prod/smarty/compile/child_pandalayouts_layout_left_column_tpl/16/5e/69/165e6984cc26fc4d30c2e41af5deec6faa952708_2.file.layout-both-columns.tpl.php:298 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/child_pandalayouts_layout_left_column_tpl/16/5e/69/165e6984cc26fc4d30c2e41af5deec6faa952708_2.file.layout-both-columns.tpl.php:86 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6ac393aa1556a4_70405393) /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:116 (_subTemplateRender) /var/cache/prod/smarty/compile/child_pandalayouts_layout_left_column_tpl/6c/3d/79/6c3d7966117dae2bd9ae5035b3ee6cd2e1b2a36d_2.file.layout-left-column.tpl.php:47 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6ac393aa0c3f38_98812868) /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:116 (_subTemplateRender) /var/cache/prod/smarty/compile/child_pandalayouts_layout_left_column_tpl/76/a9/5b/76a95be99df01b610fca2bca744f33c00edb13af_2.file.product-list.tpl.php:39 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6ac393aa0babf9_11094935) /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:116 (_subTemplateRender) /var/cache/prod/smarty/compile/child_pandalayouts_layout_left_column_tpl/c6/ad/da/c6addaa5971b2a1e943f8f0e8a5fdba2ed93b339_2.file.category.tpl.php:42 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6ac393aa08f0e9_25151483) /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) /override/classes/controller/FrontController.php:762 (fetch) /override/classes/controller/FrontController.php:744 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
499	SELECT SQL_NO_CACHE pa., product_attribute_shop., GROUP_CONCAT(ag.`id_attribute_group`) AS `id_attribute_group`, GROUP_CONCAT(a.`id_attribute`) AS `id_attribute`, GROUP_CONCAT(al.`name` SEPARATOR "\|s\|p\|a\|") AS attribute_name, GROUP_CONCAT(ag.`is_color_group`) AS `is_color_group`, GROUP_CONCAT(pac.`id_attribute`) as id_attribute_list_custom, p.cache_default_attribute FROM `xj8_product_attribute` pa INNER JOIN xj8_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) LEFT JOIN `xj8_product_attribute_combination` pac ON pac.`id_product_attribute` = pa.`id_product_attribute` LEFT JOIN `xj8_attribute` a ON a.`id_attribute` = pac.`id_attribute` LEFT JOIN `xj8_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group` LEFT JOIN `xj8_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1) JOIN `xj8_product` p ON (p.`id_product` = pa.`id_product`) LEFT JOIN xj8_stock_available stock ON (stock.id_product = `p`.id_product AND stock.id_product_attribute = IFNULL(`pa`.id_product_attribute, 0) AND stock.id_shop = 1 AND stock.id_shop_group = 0 ) WHERE pa.`id_product` = 65834 AND IF (stock.`quantity` > 0 OR (p.`cache_default_attribute` > 0 AND p.`cache_default_attribute` = pac.`id_product_attribute`), 1, IF (stock.`out_of_stock` = 2, 0 = 1, stock.`out_of_stock` = 1)) GROUP BY pa.`id_product_attribute` ORDER BY product_attribute_shop.`price` ASC	0.792 ms	1	Yes		/modules/pm_productsbyattributes/pm_productsbyattributes.php:1252 /modules/pm_productsbyattributes/pm_productsbyattributes.php:1287 (getAttributeCombinationsById) /modules/pm_productsbyattributes/src/Pm_ProductsByAttributesProductSearchProvider.php:324 (getFullProductName) /override/classes/controller/ProductListingFrontController.php:361 (runQuery) /override/controllers/front/listing/CategoryController.php:19 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:138 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
495	SELECT SQL_NO_CACHE pa., product_attribute_shop., GROUP_CONCAT(ag.`id_attribute_group`) AS `id_attribute_group`, GROUP_CONCAT(a.`id_attribute`) AS `id_attribute`, GROUP_CONCAT(al.`name` SEPARATOR "\|s\|p\|a\|") AS attribute_name, GROUP_CONCAT(ag.`is_color_group`) AS `is_color_group`, GROUP_CONCAT(pac.`id_attribute`) as id_attribute_list_custom, p.cache_default_attribute FROM `xj8_product_attribute` pa INNER JOIN xj8_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) LEFT JOIN `xj8_product_attribute_combination` pac ON pac.`id_product_attribute` = pa.`id_product_attribute` LEFT JOIN `xj8_attribute` a ON a.`id_attribute` = pac.`id_attribute` LEFT JOIN `xj8_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group` LEFT JOIN `xj8_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1) JOIN `xj8_product` p ON (p.`id_product` = pa.`id_product`) LEFT JOIN xj8_stock_available stock ON (stock.id_product = `p`.id_product AND stock.id_product_attribute = IFNULL(`pa`.id_product_attribute, 0) AND stock.id_shop = 1 AND stock.id_shop_group = 0 ) WHERE pa.`id_product` = 9059 AND IF (stock.`quantity` > 0 OR (p.`cache_default_attribute` > 0 AND p.`cache_default_attribute` = pac.`id_product_attribute`), 1, IF (stock.`out_of_stock` = 2, 0 = 1, stock.`out_of_stock` = 1)) GROUP BY pa.`id_product_attribute` ORDER BY product_attribute_shop.`price` ASC	0.785 ms	1	Yes		/modules/pm_productsbyattributes/pm_productsbyattributes.php:1252 /modules/pm_productsbyattributes/pm_productsbyattributes.php:1287 (getAttributeCombinationsById) /modules/pm_productsbyattributes/src/Pm_ProductsByAttributesProductSearchProvider.php:324 (getFullProductName) /override/classes/controller/ProductListingFrontController.php:361 (runQuery) /override/controllers/front/listing/CategoryController.php:19 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:138 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
493	SELECT SQL_NO_CACHE pa., product_attribute_shop., GROUP_CONCAT(ag.`id_attribute_group`) AS `id_attribute_group`, GROUP_CONCAT(a.`id_attribute`) AS `id_attribute`, GROUP_CONCAT(al.`name` SEPARATOR "\|s\|p\|a\|") AS attribute_name, GROUP_CONCAT(ag.`is_color_group`) AS `is_color_group`, GROUP_CONCAT(pac.`id_attribute`) as id_attribute_list_custom, p.cache_default_attribute FROM `xj8_product_attribute` pa INNER JOIN xj8_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) LEFT JOIN `xj8_product_attribute_combination` pac ON pac.`id_product_attribute` = pa.`id_product_attribute` LEFT JOIN `xj8_attribute` a ON a.`id_attribute` = pac.`id_attribute` LEFT JOIN `xj8_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group` LEFT JOIN `xj8_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1) JOIN `xj8_product` p ON (p.`id_product` = pa.`id_product`) LEFT JOIN xj8_stock_available stock ON (stock.id_product = `p`.id_product AND stock.id_product_attribute = IFNULL(`pa`.id_product_attribute, 0) AND stock.id_shop = 1 AND stock.id_shop_group = 0 ) WHERE pa.`id_product` = 16538 AND IF (stock.`quantity` > 0 OR (p.`cache_default_attribute` > 0 AND p.`cache_default_attribute` = pac.`id_product_attribute`), 1, IF (stock.`out_of_stock` = 2, 0 = 1, stock.`out_of_stock` = 1)) GROUP BY pa.`id_product_attribute` ORDER BY product_attribute_shop.`price` ASC	0.782 ms	1	Yes		/modules/pm_productsbyattributes/pm_productsbyattributes.php:1252 /modules/pm_productsbyattributes/pm_productsbyattributes.php:1287 (getAttributeCombinationsById) /modules/pm_productsbyattributes/src/Pm_ProductsByAttributesProductSearchProvider.php:324 (getFullProductName) /override/classes/controller/ProductListingFrontController.php:361 (runQuery) /override/controllers/front/listing/CategoryController.php:19 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:138 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
498	SELECT SQL_NO_CACHE pa., product_attribute_shop., GROUP_CONCAT(ag.`id_attribute_group`) AS `id_attribute_group`, GROUP_CONCAT(a.`id_attribute`) AS `id_attribute`, GROUP_CONCAT(al.`name` SEPARATOR "\|s\|p\|a\|") AS attribute_name, GROUP_CONCAT(ag.`is_color_group`) AS `is_color_group`, GROUP_CONCAT(pac.`id_attribute`) as id_attribute_list_custom, p.cache_default_attribute FROM `xj8_product_attribute` pa INNER JOIN xj8_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) LEFT JOIN `xj8_product_attribute_combination` pac ON pac.`id_product_attribute` = pa.`id_product_attribute` LEFT JOIN `xj8_attribute` a ON a.`id_attribute` = pac.`id_attribute` LEFT JOIN `xj8_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group` LEFT JOIN `xj8_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1) JOIN `xj8_product` p ON (p.`id_product` = pa.`id_product`) LEFT JOIN xj8_stock_available stock ON (stock.id_product = `p`.id_product AND stock.id_product_attribute = IFNULL(`pa`.id_product_attribute, 0) AND stock.id_shop = 1 AND stock.id_shop_group = 0 ) WHERE pa.`id_product` = 7712 AND IF (stock.`quantity` > 0 OR (p.`cache_default_attribute` > 0 AND p.`cache_default_attribute` = pac.`id_product_attribute`), 1, IF (stock.`out_of_stock` = 2, 0 = 1, stock.`out_of_stock` = 1)) GROUP BY pa.`id_product_attribute` ORDER BY product_attribute_shop.`price` ASC	0.776 ms	1	Yes		/modules/pm_productsbyattributes/pm_productsbyattributes.php:1252 /modules/pm_productsbyattributes/pm_productsbyattributes.php:1287 (getAttributeCombinationsById) /modules/pm_productsbyattributes/src/Pm_ProductsByAttributesProductSearchProvider.php:324 (getFullProductName) /override/classes/controller/ProductListingFrontController.php:361 (runQuery) /override/controllers/front/listing/CategoryController.php:19 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:138 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
189	SELECT SQL_NO_CACHE * FROM `xj8_category` a0 LEFT JOIN `xj8_category_lang` `a1` ON (a0.`id_category` = a1.`id_category`) WHERE (a0.`nleft` < 431) AND (a0.`nright` > 432) AND (a1.`id_lang` = 1) AND (a1.`id_shop` = 1) ORDER BY a0.`nleft` asc	0.752 ms	732	Yes		/classes/PrestaShopCollection.php:383 /classes/PrestaShopCollection.php:440 (getAll) /controllers/front/listing/CategoryController.php:245 (rewind) /override/classes/controller/FrontController.php:1867 (getBreadcrumbLinks) /override/classes/controller/FrontController.php:549 (getBreadcrumb) /override/classes/controller/FrontController.php:607 (assignGeneralPurposeVariables) /controllers/front/listing/CategoryController.php:127 (initContent) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (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/include_paths.php
9	/vendor/composer/autoload_static.php
10	/vendor/symfony/polyfill-php72/bootstrap.php
11	/vendor/symfony/polyfill-mbstring/bootstrap.php
12	/vendor/symfony/polyfill-mbstring/bootstrap80.php
13	/vendor/symfony/polyfill-intl-normalizer/bootstrap.php
14	/vendor/symfony/polyfill-intl-normalizer/bootstrap80.php
15	/vendor/symfony/polyfill-intl-idn/bootstrap.php
16	/vendor/symfony/deprecation-contracts/function.php
17	/vendor/ralouphie/getallheaders/src/getallheaders.php
18	/vendor/symfony/polyfill-ctype/bootstrap.php
19	/vendor/symfony/polyfill-ctype/bootstrap80.php
20	/vendor/symfony/polyfill-php80/bootstrap.php
21	/vendor/guzzlehttp/promises/src/functions_include.php
22	/vendor/guzzlehttp/promises/src/functions.php
23	/vendor/guzzlehttp/guzzle/src/functions_include.php
24	/vendor/guzzlehttp/guzzle/src/functions.php
25	/vendor/symfony/polyfill-iconv/bootstrap.php
26	/vendor/ezyang/htmlpurifier/library/HTMLPurifier.composer.php
27	/vendor/jakeasmith/http_build_url/src/http_build_url.php
28	/vendor/lcobucci/jwt/compat/class-aliases.php
29	/vendor/lcobucci/jwt/src/Token.php
30	/vendor/lcobucci/jwt/src/Signature.php
31	/vendor/lcobucci/jwt/compat/json-exception-polyfill.php
32	/vendor/lcobucci/jwt/compat/lcobucci-clock-polyfill.php
33	/vendor/swiftmailer/swiftmailer/lib/swift_required.php
34	/vendor/swiftmailer/swiftmailer/lib/classes/Swift.php
35	/vendor/symfony/polyfill-intl-icu/bootstrap.php
36	/vendor/symfony/polyfill-php73/bootstrap.php
37	/vendor/symfony/polyfill-php81/bootstrap.php
38	/vendor/api-platform/core/src/deprecation.php
39	/vendor/api-platform/core/src/Api/FilterInterface.php