DOLCE & GABBANA

THE ONE Coffret eau de parfum 75 ml + 10 ml

79.90 €

Prix adhérent Fidélité
69,90 € (TTC)

Voir plus de détails

HUGO BOSS

BOSS BOTTLED PARFUM Coffret eau de parfum 100 ml

79.90 €

Voir plus de détails

Coffret Soin

Pertinence

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

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

DR.JART+

CICAPAIR

Formule Apaisante pour la Peau - Coffret 2 pièces

36,90 € (TTC)

Ce coffret contient : - La Crème Réparatrice Apaisante Intensive Cicapair™ (35 ml) - Le Soin Correcteur de Teint Apaisant Cicapair™ SPF 30 (15 ml)

Ajouter au panier

COCOSOLIS

GLOWING & HYDRATING

Coffret Illuminateur Aura 100 ml + Aqua Filler-effect 50ml

69,90 € (TTC)

Ce Coffret Contient : - Aura Spray 100 ml - Aqua Filler-Effect 50 ml

Ajouter au panier

BAREMINERALS

SUPERFRUIT

Masque coffret 2p

39,90 € (TTC)

Coffret : - Masque x 2

Ajouter au panier

STRIVECTIN

ANTI-WRINKLE

Coffret 2p

52,90 € (TTC)

Coffret : - Crème Yeux 30 ml + Double Fixation 5 ml

Ajouter au panier

SISLEY

ÉMULSION ÉCOLOGIQUE

Coffret 3 p

349,90 € (TTC)

Contenu du Coffret : - Emulsion 125 ml - Nettoyant 60 ml - All Day All Year 10 ml

Ajouter au panier

CLARINS

RITUEL ENERGIE

Eau Dynamisante Coffret 2 p

49,90 € (TTC)

Contenu du Coffret : - Eau de Soin 100 ml - Gel Douche 30 ml

Ajouter au panier

CLINIQUE

ANTI-BLEMISH SOLUTIONS ANTI-IMPERFECTIONS

COFFRET

34,90 € (TTC)

Contenu du Coffret : - Mousse nettoyante 50 ml - Lotion exfoliante 60 ml - Soin nettoyant 15 ml

Ajouter au panier

ORIGINS

GINZING Rich Energizing Cream

Coffret 3 crèmes énergisantes

59,90 € (TTC)

Contenu du Coffret : - Crème 50 ml - Crème contour des yeux 15 ml - Gommage rafraichissant 30 ml

Ajouter au panier

LIERAC

LIFT INTEGRAL

Coffret sérum tenseur

49,90 € (TTC)

Contenu du Coffret : - Sérum 30 ml - Contour des Yeux 15 ml

Ajouter au panier

RITUALS

RITUALS HOMME

Coffret Bain & Corps

32,90 € (TTC)

Contenu du Coffret : - Gel douche 50 ml - Shampoing 75 ml - Gel douche 70 ml - Lait corporel 70 ml

Ajouter au panier

LIERAC

PROTOCOLE ANTI-TACHES

Coffret Soin du Visage

42,90 € (TTC)

Contenu du Coffret : - Sérum Anti Tâches 30 ml - Fluide Solaire SPF50+ 25 ml

Ajouter au panier

COLLISTAR

ATTIVI PURI

Coffret routine Hydra Liftante

49,90 € (TTC)

Contenu du Coffret : - Aquagel 50 ml - Lotion visage 15 ml - Gouttes magiques x 1 - Trousse de toilette x 1

Ajouter au panier

LANCASTER

SUN PERFECT SPF50

Coffret Crème illuminatrice + Crème Sculptant + Démaquillant

39,90 € (TTC) 65,00 €

Contenu du Coffret : - Crème illuminatrice SPF50 50 ml - Crème sculptant 15 ml - Démaquillant 30 ml

Ajouter au panier

CLARINS

EAU EXTRAORDINAIRE

Coffret eau de soin 100 ml + Baume 30 ml + Huile à lèvre

49,90 € (TTC)

Contenu du Coffret : - Eau de Soin 100 ml - Baume Corps 30 ml - Huile à Lèvres 1.4 ml - Trousse

Ajouter au panier

Découvrez notre sélection de coffret Soin sur Parfumera.fr pour prendre soin de la peau avec des ensembles complets et bien pensés. Des coffrets utiles, pratiques et attractifs, pensés pour accompagner la routine beauté.

LIRE PLUSAFFICHER MOINS

LIRE PLUS AFFICHER MOINS

Load Time	1079 ms
Querying Time	474 ms
Queries	1826
Memory Peak Usage	83.6 Mb
Included Files	1506 files - 21.16 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.118 ms	27.118 ms	11.03 Mb	11.4 Mb
__construct	0.019 ms	27.137 ms	- Mb	11.4 Mb
init	61.280 ms	88.417 ms	6.25 Mb	18.3 Mb
checkAccess	0.002 ms	88.419 ms	- Mb	18.3 Mb
setMedia	46.573 ms	134.992 ms	4.57 Mb	22.0 Mb
postProcess	0.002 ms	134.994 ms	- Mb	22.0 Mb
initHeader	0.001 ms	134.995 ms	- Mb	22.0 Mb
initContent	633.855 ms	768.850 ms	36.26 Mb	58.1 Mb
initFooter	0.002 ms	768.852 ms	- Mb	58.1 Mb
display	309.852 ms	1079 ms	24.99 Mb	83.6 Mb

169 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
169 queries	SELECT c.`nleft`, c.`nright` FROM `xjXX_category` c WHERE c.`id_category` = XX LIMIT XX
169 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
91 queries	SELECT id_manufacturer FROM `xjXX_product` WHERE id_product = XX LIMIT XX
91 queries	SELECT * FROM `xjXX_product_supplier` aXX WHERE (aXX.`id_product` = XX) GROUP BY aXX.`id_supplier`
86 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
50 queries	SELECT name FROM xjXX_category_lang WHERE id_shop = XX AND id_lang = XX AND id_category = XX LIMIT XX
50 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
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
44 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
44 queries	SELECT * FROM `xjXX_category_lang` WHERE `id_category` = XX AND `id_shop` = 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
19 queries	SELECT XX FROM `xjXX_specific_price` WHERE id_product = XX LIMIT XX
19 queries	SELECT `reduction` FROM `xjXX_product_group_reduction_cache` WHERE `id_product` = XX AND `id_group` = XX LIMIT XX
18 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
18 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
18 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)
18 queries	SELECT `id_tax_rules_group` FROM `xjXX_product_shop` WHERE `id_product` = XX AND id_shop=XX LIMIT XX
18 queries	SELECT COUNT(*) FROM `xjXX_pack` WHERE id_product_pack = XX LIMIT XX
18 queries	SELECT product_type FROM `xjXX_product` WHERE id_product = XX LIMIT XX
18 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
18 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
18 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
18 queries	SELECT * FROM `xjXX_product_lang` WHERE `id_product` = XX AND `id_shop` = XX
18 queries	SELECT `id_category` FROM `xjXX_category_product` WHERE `id_product` = XX
18 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
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 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
14 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
14 queries	SELECT `name` FROM `xjXX_manufacturer` WHERE `id_manufacturer` = XX AND `active` = XX LIMIT 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
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` = '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` = '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` = '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 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 OR FIND_IN_SET(XX, REPLACE(gi.suppliers, ";", ",")) > XX) ORDER BY position, priority
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 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
4 queries	SELECT *, ( IF (`id_shop` = XX, XX, XX) + IF (`id_country` = XX, XX, XX) + IF (`id_currency` = XX, XX, XX) + IF (`id_group` = XX, XX, XX) + IF (`id_customer` = XX, XX, XX)) AS `score` FROM `xjXX_specific_price` WHERE `id_shop` IN (XX, XX) AND `id_currency` IN (XX, XX) AND `id_country` IN (XX, XX) AND `id_group` IN (XX, XX) AND `id_product` = XX AND `id_customer` = XX AND `id_product_attribute` = XX AND `id_cart` = XX AND (`from` = 'XX-XX-XX XX:XX:XX' OR 'XX-XX-XX XX:XX:XX' >= `from`) AND (`to` = 'XX-XX-XX XX:XX:XX' OR 'XX-XX-XX XX:XX:XX' <= `to`) AND IF(`from_quantity` > XX, `from_quantity`, XX) <= XX ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC 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,XX,XX,XX,XX,XX,XX,XX,XX))) OR (location = XX AND (id_products LIKE "%,XX,%")))
4 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
4 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
3 queries	SELECT `priority`, `id_specific_price_priority` FROM `xjXX_specific_price_priority` WHERE `id_product` = XX ORDER BY `id_specific_price_priority` DESC LIMIT XX
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 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))) OR (location = XX AND (id_products LIKE "%,XX,%")))
3 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,XX,XX,XX,XX,XX))) OR (location = XX AND (id_products LIKE "%,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 `reduction` FROM `xjXX_group` WHERE `id_group` = XX LIMIT 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))) OR (location = XX AND (id_products LIKE "%,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))) 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 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 p., pl. FROM `xjXX_product` p INNER JOIN `xjXX_product_lang` `pl` ON pl.id_product = p.id_product AND pl.id_lang = XX AND pl.id_shop = XX LEFT JOIN `xjXX_category_product` `cp` ON cp.id_product = p.id_product LEFT JOIN `xjXX_category_lang` `cl` ON cl.id_category = cp.id_category AND cl.id_lang = XX WHERE (p.id_product = XX) 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
Category	413	/controllers/front/listing/CategoryController.php:78 (__construct) [id: 2547] /classes/Meta.php:380 (__construct) [id: 2547] /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: 2547] /modules/facebookproductad/lib/pixel/pixelCategory.php:46 (__construct) [id: 2547] /modules/facebookproductad/lib/moduleTools.php:468 (__construct) [id: 2547] /modules/facebookproductad/lib/pixel/pixelCategory.php:46 (__construct) [id: 2547] /modules/facebookproductad/lib/moduleTools.php:468 (__construct) [id: 2547] /modules/pm_productsbyattributes/src/Pm_ProductsByAttributesProductSearchProvider.php:53 (__construct) [id: 2547] /modules/pm_productsbyattributes/src/Pm_ProductsByAttributesProductSearchProvider.php:53 (__construct) [id: 2547] /modules/pm_productsbyattributes/pm_productsbyattributes.php:741 (__construct) [id: 2547] /modules/pm_productsbyattributes/pm_productsbyattributes.php:741 (__construct) [id: 2547] /modules/pm_productsbyattributes/pm_productsbyattributes.php:741 (__construct) [id: 2547] /modules/pm_productsbyattributes/pm_productsbyattributes.php:741 (__construct) [id: 2547] /modules/pm_productsbyattributes/pm_productsbyattributes.php:741 (__construct) [id: 2547] /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/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: 8] /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: 37] /modules/ststickers/classes/StStickersMapClass.php:168 (getParentsCategories) [id: 2] /modules/ststickers/classes/StStickersMapClass.php:159 (__construct) [id: 2471] /modules/ststickers/classes/StStickersMapClass.php:168 (getParentsCategories) [id: 2] /modules/ststickers/classes/StStickersMapClass.php:159 (__construct) [id: 2473] /modules/ststickers/classes/StStickersMapClass.php:168 (getParentsCategories) [id: 2] /modules/ststickers/classes/StStickersMapClass.php:159 (__construct) [id: 2480] /modules/ststickers/classes/StStickersMapClass.php:168 (getParentsCategories) [id: 2] /modules/ststickers/classes/StStickersMapClass.php:159 (__construct) [id: 2484] /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: 2548] /modules/ststickers/classes/StStickersMapClass.php:159 (__construct) [id: 6678] /modules/ststickers/classes/StStickersMapClass.php:168 (getParentsCategories) [id: 2] /modules/ststickers/classes/StStickersMapClass.php:159 (__construct) [id: 6685] /modules/ststickers/classes/StStickersMapClass.php:168 (getParentsCategories) [id: 2] /modules/ststickers/classes/StStickersMapClass.php:159 (__construct) [id: 6736] /modules/ststickers/classes/StStickersMapClass.php:168 (getParentsCategories) [id: 2] /modules/ststickers/classes/StStickersMapClass.php:159 (__construct) [id: 6758] /modules/ststickers/classes/StStickersMapClass.php:168 (getParentsCategories) [id: 2] /modules/ststickers/classes/StStickersMapClass.php:159 (__construct) [id: 6760] /modules/ststickers/classes/StStickersMapClass.php:168 (getParentsCategories) [id: 2] /modules/ststickers/classes/StStickersMapClass.php:159 (__construct) [id: 6790] /modules/ststickers/classes/StStickersMapClass.php:168 (getParentsCategories) [id: 2] /modules/ststickers/classes/StStickersMapClass.php:159 (__construct) [id: 8] /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: 2510] /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: 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: 6790] /modules/ststickers/classes/StStickersMapClass.php:168 (getParentsCategories) [id: 2] /modules/ststickers/classes/StStickersMapClass.php:159 (__construct) [id: 6796] /modules/ststickers/classes/StStickersMapClass.php:168 (getParentsCategories) [id: 2] /modules/ststickers/classes/StStickersMapClass.php:159 (__construct) [id: 8] /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: 2510] /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: 6790] /modules/ststickers/classes/StStickersMapClass.php:168 (getParentsCategories) [id: 2] /modules/ststickers/classes/StStickersMapClass.php:159 (__construct) [id: 8] /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: 2510] /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: 6790] /modules/ststickers/classes/StStickersMapClass.php:168 (getParentsCategories) [id: 2] /modules/ststickers/classes/StStickersMapClass.php:159 (__construct) [id: 6796] /modules/ststickers/classes/StStickersMapClass.php:168 (getParentsCategories) [id: 2] /modules/ststickers/classes/StStickersMapClass.php:159 (__construct) [id: 8] /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: 2480] /modules/ststickers/classes/StStickersMapClass.php:168 (getParentsCategories) [id: 2] /modules/ststickers/classes/StStickersMapClass.php:159 (__construct) [id: 2484] /modules/ststickers/classes/StStickersMapClass.php:168 (getParentsCategories) [id: 2] /modules/ststickers/classes/StStickersMapClass.php:159 (__construct) [id: 2510] /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: 6665] /modules/ststickers/classes/StStickersMapClass.php:159 (__construct) [id: 6736] /modules/ststickers/classes/StStickersMapClass.php:168 (getParentsCategories) [id: 2] /modules/ststickers/classes/StStickersMapClass.php:159 (__construct) [id: 6790] /modules/ststickers/classes/StStickersMapClass.php:168 (getParentsCategories) [id: 2] /modules/ststickers/classes/StStickersMapClass.php:159 (__construct) [id: 6797] /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: 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: 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: 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: 8] /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: 2480] /modules/ststickers/classes/StStickersMapClass.php:168 (getParentsCategories) [id: 2] /modules/ststickers/classes/StStickersMapClass.php:159 (__construct) [id: 2482] /modules/ststickers/classes/StStickersMapClass.php:168 (getParentsCategories) [id: 2] /modules/ststickers/classes/StStickersMapClass.php:159 (__construct) [id: 2510] /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: 2548] /modules/ststickers/classes/StStickersMapClass.php:159 (__construct) [id: 6790] /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: 8] /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: 2471] /modules/ststickers/classes/StStickersMapClass.php:168 (getParentsCategories) [id: 2] /modules/ststickers/classes/StStickersMapClass.php:159 (__construct) [id: 2473] /modules/ststickers/classes/StStickersMapClass.php:168 (getParentsCategories) [id: 2] /modules/ststickers/classes/StStickersMapClass.php:159 (__construct) [id: 2475] /modules/ststickers/classes/StStickersMapClass.php:168 (getParentsCategories) [id: 2] /modules/ststickers/classes/StStickersMapClass.php:159 (__construct) [id: 2477] /modules/ststickers/classes/StStickersMapClass.php:168 (getParentsCategories) [id: 2] /modules/ststickers/classes/StStickersMapClass.php:159 (__construct) [id: 2480] /modules/ststickers/classes/StStickersMapClass.php:168 (getParentsCategories) [id: 2] /modules/ststickers/classes/StStickersMapClass.php:159 (__construct) [id: 2483] /modules/ststickers/classes/StStickersMapClass.php:168 (getParentsCategories) [id: 2] /modules/ststickers/classes/StStickersMapClass.php:159 (__construct) [id: 2484] /modules/ststickers/classes/StStickersMapClass.php:168 (getParentsCategories) [id: 2] /modules/ststickers/classes/StStickersMapClass.php:159 (__construct) [id: 2510] /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: 2548] /modules/ststickers/classes/StStickersMapClass.php:159 (__construct) [id: 6736] /modules/ststickers/classes/StStickersMapClass.php:168 (getParentsCategories) [id: 2] /modules/ststickers/classes/StStickersMapClass.php:159 (__construct) [id: 6790] /modules/ststickers/classes/StStickersMapClass.php:168 (getParentsCategories) [id: 2] /modules/ststickers/classes/StStickersMapClass.php:159 (__construct) [id: 6796] /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: 8] /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: 51] /modules/ststickers/classes/StStickersMapClass.php:168 (getParentsCategories) [id: 2] /modules/ststickers/classes/StStickersMapClass.php:159 (__construct) [id: 2471] /modules/ststickers/classes/StStickersMapClass.php:168 (getParentsCategories) [id: 2] /modules/ststickers/classes/StStickersMapClass.php:159 (__construct) [id: 2472] /modules/ststickers/classes/StStickersMapClass.php:168 (getParentsCategories) [id: 2] /modules/ststickers/classes/StStickersMapClass.php:159 (__construct) [id: 2480] /modules/ststickers/classes/StStickersMapClass.php:168 (getParentsCategories) [id: 2] /modules/ststickers/classes/StStickersMapClass.php:159 (__construct) [id: 2483] /modules/ststickers/classes/StStickersMapClass.php:168 (getParentsCategories) [id: 2] /modules/ststickers/classes/StStickersMapClass.php:159 (__construct) [id: 2484] /modules/ststickers/classes/StStickersMapClass.php:168 (getParentsCategories) [id: 2] /modules/ststickers/classes/StStickersMapClass.php:159 (__construct) [id: 2490] /modules/ststickers/classes/StStickersMapClass.php:168 (getParentsCategories) [id: 2] /modules/ststickers/classes/StStickersMapClass.php:159 (__construct) [id: 2510] /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: 2548] /modules/ststickers/classes/StStickersMapClass.php:159 (__construct) [id: 2593] /modules/ststickers/classes/StStickersMapClass.php:168 (getParentsCategories) [id: 2] /modules/ststickers/classes/StStickersMapClass.php:159 (__construct) [id: 6736] /modules/ststickers/classes/StStickersMapClass.php:168 (getParentsCategories) [id: 2] /modules/ststickers/classes/StStickersMapClass.php:159 (__construct) [id: 6790] /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: 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: 2518] /modules/ststickers/classes/StStickersMapClass.php:168 (getParentsCategories) [id: 2] /modules/ststickers/classes/StStickersMapClass.php:159 (__construct) [id: 2524] /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: 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: 6736] /modules/ststickers/classes/StStickersMapClass.php:168 (getParentsCategories) [id: 2] /modules/ststickers/classes/StStickersMapClass.php:159 (__construct) [id: 6789] /modules/ststickers/classes/StStickersMapClass.php:168 (getParentsCategories) [id: 2] /modules/ststickers/classes/StStickersMapClass.php:159 (__construct) [id: 6792] /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: 8] /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: 51] /modules/ststickers/classes/StStickersMapClass.php:168 (getParentsCategories) [id: 2] /modules/ststickers/classes/StStickersMapClass.php:159 (__construct) [id: 2471] /modules/ststickers/classes/StStickersMapClass.php:168 (getParentsCategories) [id: 2] /modules/ststickers/classes/StStickersMapClass.php:159 (__construct) [id: 2472] /modules/ststickers/classes/StStickersMapClass.php:168 (getParentsCategories) [id: 2] /modules/ststickers/classes/StStickersMapClass.php:159 (__construct) [id: 2510] /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: 2548] /modules/ststickers/classes/StStickersMapClass.php:159 (__construct) [id: 2551] /modules/ststickers/classes/StStickersMapClass.php:168 (getParentsCategories) [id: 2] /modules/ststickers/classes/StStickersMapClass.php:159 (__construct) [id: 2567] /modules/ststickers/classes/StStickersMapClass.php:168 (getParentsCategories) [id: 2] /modules/ststickers/classes/StStickersMapClass.php:159 (__construct) [id: 2593] /modules/ststickers/classes/StStickersMapClass.php:168 (getParentsCategories) [id: 2] /modules/ststickers/classes/StStickersMapClass.php:159 (__construct) [id: 6736] /modules/ststickers/classes/StStickersMapClass.php:168 (getParentsCategories) [id: 2] /modules/ststickers/classes/StStickersMapClass.php:159 (__construct) [id: 6790] /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: 8] /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: 2471] /modules/ststickers/classes/StStickersMapClass.php:168 (getParentsCategories) [id: 2] /modules/ststickers/classes/StStickersMapClass.php:159 (__construct) [id: 2472] /modules/ststickers/classes/StStickersMapClass.php:168 (getParentsCategories) [id: 2] /modules/ststickers/classes/StStickersMapClass.php:159 (__construct) [id: 2473] /modules/ststickers/classes/StStickersMapClass.php:168 (getParentsCategories) [id: 2] /modules/ststickers/classes/StStickersMapClass.php:159 (__construct) [id: 2480] /modules/ststickers/classes/StStickersMapClass.php:168 (getParentsCategories) [id: 2] /modules/ststickers/classes/StStickersMapClass.php:159 (__construct) [id: 2484] /modules/ststickers/classes/StStickersMapClass.php:168 (getParentsCategories) [id: 2] /modules/ststickers/classes/StStickersMapClass.php:159 (__construct) [id: 2490] /modules/ststickers/classes/StStickersMapClass.php:168 (getParentsCategories) [id: 2] /modules/ststickers/classes/StStickersMapClass.php:159 (__construct) [id: 2510] /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: 2548] /modules/ststickers/classes/StStickersMapClass.php:159 (__construct) [id: 6736] /modules/ststickers/classes/StStickersMapClass.php:168 (getParentsCategories) [id: 2] /modules/ststickers/classes/StStickersMapClass.php:159 (__construct) [id: 6790] /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: 8] /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: 2471] /modules/ststickers/classes/StStickersMapClass.php:168 (getParentsCategories) [id: 2] /modules/ststickers/classes/StStickersMapClass.php:159 (__construct) [id: 2472] /modules/ststickers/classes/StStickersMapClass.php:168 (getParentsCategories) [id: 2] /modules/ststickers/classes/StStickersMapClass.php:159 (__construct) [id: 2480] /modules/ststickers/classes/StStickersMapClass.php:168 (getParentsCategories) [id: 2] /modules/ststickers/classes/StStickersMapClass.php:159 (__construct) [id: 2488] /modules/ststickers/classes/StStickersMapClass.php:168 (getParentsCategories) [id: 2] /modules/ststickers/classes/StStickersMapClass.php:159 (__construct) [id: 2506] /modules/ststickers/classes/StStickersMapClass.php:168 (getParentsCategories) [id: 2] /modules/ststickers/classes/StStickersMapClass.php:159 (__construct) [id: 2507] /modules/ststickers/classes/StStickersMapClass.php:168 (getParentsCategories) [id: 2] /modules/ststickers/classes/StStickersMapClass.php:159 (__construct) [id: 2510] /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: 2548] /modules/ststickers/classes/StStickersMapClass.php:159 (__construct) [id: 6736] /modules/ststickers/classes/StStickersMapClass.php:168 (getParentsCategories) [id: 2] /modules/ststickers/classes/StStickersMapClass.php:159 (__construct) [id: 6790] /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: 8] /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: 2510] /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: 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: 2548] /modules/ststickers/classes/StStickersMapClass.php:159 (__construct) [id: 2549] /modules/cdc_googletagmanager/cdc_googletagmanager.php:1329 (__construct) [id: 2547] /modules/cdc_googletagmanager/cdc_googletagmanager.php:1357 (getParentsCategories) [id: 2] /modules/cdc_googletagmanager/classes/gtm/DataLayerItem.php:109 (__construct) [id: 2549] /modules/cdc_googletagmanager/cdc_googletagmanager.php:1390 (__construct) [id: 2] /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/classes/gtm/DataLayerItem.php:109 (__construct) [id: 6760] /modules/cdc_googletagmanager/cdc_googletagmanager.php:1339 (__construct) [id: 6758] /modules/cdc_googletagmanager/cdc_googletagmanager.php:1339 (__construct) [id: 8] /modules/cdc_googletagmanager/cdc_googletagmanager.php:1339 (__construct) [id: 6758] /modules/cdc_googletagmanager/classes/gtm/DataLayerItem.php:109 (__construct) [id: 9] /modules/cdc_googletagmanager/classes/gtm/DataLayerItem.php:109 (__construct) [id: 9] /modules/cdc_googletagmanager/classes/gtm/DataLayerItem.php:109 (__construct) [id: 9] /modules/cdc_googletagmanager/classes/gtm/DataLayerItem.php:109 (__construct) [id: 9] /modules/cdc_googletagmanager/classes/gtm/DataLayerItem.php:109 (__construct) [id: 9] /modules/cdc_googletagmanager/classes/gtm/DataLayerItem.php:109 (__construct) [id: 2548] /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: 2548] /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: 2548] /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/classes/gtm/DataLayerItem.php:109 (__construct) [id: 2547] /modules/cdc_googletagmanager/cdc_googletagmanager.php:1339 (__construct) [id: 9] /modules/cdc_googletagmanager/classes/gtm/DataLayerItem.php:109 (__construct) [id: 2547] /modules/cdc_googletagmanager/cdc_googletagmanager.php:1339 (__construct) [id: 9] /modules/cdc_googletagmanager/classes/gtm/DataLayerItem.php:109 (__construct) [id: 2548] /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: 2547] /modules/cdc_googletagmanager/cdc_googletagmanager.php:1339 (__construct) [id: 9] /modules/cdc_googletagmanager/cdc_googletagmanager.php:1329 (__construct) [id: 2547] /modules/cdc_googletagmanager/cdc_googletagmanager.php:1357 (getParentsCategories) [id: 2] /modules/stswiper/classes/StSwiperGroup.php:244 (__construct) [id: 2547] /modules/stswiper/classes/StSwiperGroup.php:245 (getParentsCategories) [id: 2] /modules/stowlcarousel/classes/StOwlCarouselGroup.php:239 (__construct) [id: 2547] /modules/stowlcarousel/classes/StOwlCarouselGroup.php:240 (getParentsCategories) [id: 2] /modules/stbanner/classes/StBannerGroup.php:288 (__construct) [id: 2547] /modules/stbanner/classes/StBannerGroup.php:289 (getParentsCategories) [id: 2] /modules/stpagebanner/classes/StPageBannerClass.php:168 (__construct) [id: 2547] /modules/stpagebanner/classes/StPageBannerClass.php:173 (getParentsCategories) [id: 2]
Product	300	/classes/Link.php:113 (__construct) [id: 65840] /classes/Link.php:113 (__construct) [id: 65834] /classes/Link.php:113 (__construct) [id: 51825] /classes/Link.php:113 (__construct) [id: 21166] /classes/Link.php:113 (__construct) [id: 5781] /classes/Link.php:113 (__construct) [id: 8890] /classes/Link.php:113 (__construct) [id: 18708] /classes/Link.php:113 (__construct) [id: 19841] /classes/Link.php:113 (__construct) [id: 96334] /classes/Link.php:113 (__construct) [id: 51984] /classes/Link.php:113 (__construct) [id: 52231] /classes/Link.php:113 (__construct) [id: 65830] /classes/Link.php:113 (__construct) [id: 51655] /classes/Link.php:113 (__construct) [id: 44020] /classes/Link.php:113 (__construct) [id: 92708] /classes/Link.php:113 (__construct) [id: 52841] /classes/Link.php:113 (__construct) [id: 65840] /classes/Link.php:113 (__construct) [id: 65834] /classes/Link.php:113 (__construct) [id: 51825] /classes/Link.php:113 (__construct) [id: 21166] /classes/Link.php:113 (__construct) [id: 5781] /classes/Link.php:113 (__construct) [id: 8890] /classes/Link.php:113 (__construct) [id: 18708] /classes/Link.php:113 (__construct) [id: 19841] /classes/Link.php:113 (__construct) [id: 96334] /classes/Link.php:113 (__construct) [id: 51984] /classes/Link.php:113 (__construct) [id: 52231] /classes/Link.php:113 (__construct) [id: 65830] /classes/Link.php:113 (__construct) [id: 51655] /classes/Link.php:113 (__construct) [id: 44020] /classes/Link.php:113 (__construct) [id: 92708] /classes/Link.php:113 (__construct) [id: 52841] /classes/Link.php:113 (__construct) [id: 65840] /classes/Link.php:113 (__construct) [id: 65834] /classes/Link.php:113 (__construct) [id: 51825] /classes/Link.php:113 (__construct) [id: 21166] /classes/Link.php:113 (__construct) [id: 5781] /classes/Link.php:113 (__construct) [id: 8890] /classes/Link.php:113 (__construct) [id: 18708] /classes/Link.php:113 (__construct) [id: 19841] /classes/Link.php:113 (__construct) [id: 96334] /classes/Link.php:113 (__construct) [id: 51984] /classes/Link.php:113 (__construct) [id: 52231] /classes/Link.php:113 (__construct) [id: 65830] /classes/Link.php:113 (__construct) [id: 51655] /classes/Link.php:113 (__construct) [id: 44020] /classes/Link.php:113 (__construct) [id: 92708] /classes/Link.php:113 (__construct) [id: 52841] /modules/ststickers/classes/StStickersMapClass.php:152 (__construct) [id: 65840] /modules/ststickers/classes/StStickersMapClass.php:152 (__construct) [id: 65834] /modules/ststickers/classes/StStickersMapClass.php:152 (__construct) [id: 51825] /modules/ststickers/classes/StStickersMapClass.php:152 (__construct) [id: 21166] /modules/ststickers/classes/StStickersMapClass.php:152 (__construct) [id: 5781] /modules/ststickers/classes/StStickersMapClass.php:152 (__construct) [id: 8890] /modules/ststickers/classes/StStickersMapClass.php:152 (__construct) [id: 18708] /modules/ststickers/classes/StStickersMapClass.php:152 (__construct) [id: 19841] /modules/ststickers/classes/StStickersMapClass.php:152 (__construct) [id: 96334] /modules/ststickers/classes/StStickersMapClass.php:152 (__construct) [id: 51984] /modules/ststickers/classes/StStickersMapClass.php:152 (__construct) [id: 52231] /modules/ststickers/classes/StStickersMapClass.php:152 (__construct) [id: 65830] /modules/ststickers/classes/StStickersMapClass.php:152 (__construct) [id: 51655] /modules/ststickers/classes/StStickersMapClass.php:152 (__construct) [id: 44020] /modules/ststickers/classes/StStickersMapClass.php:152 (__construct) [id: 92708] /modules/ststickers/classes/StStickersMapClass.php:152 (__construct) [id: 52841] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 65840] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 65834] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 51825] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 21166] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 5781] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 8890] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 18708] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 19841] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 96334] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 51984] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 52231] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 65830] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 51655] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 44020] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 92708] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 52841] /modules/cdc_googletagmanager/services/Gtm_Product.php:164 (__construct) [id: 65840] /modules/cdc_googletagmanager/services/Gtm_Product.php:164 (__construct) [id: 65834] /modules/cdc_googletagmanager/services/Gtm_Product.php:164 (__construct) [id: 51825] /modules/cdc_googletagmanager/services/Gtm_Product.php:164 (__construct) [id: 21166] /modules/cdc_googletagmanager/services/Gtm_Product.php:164 (__construct) [id: 5781] /modules/cdc_googletagmanager/services/Gtm_Product.php:164 (__construct) [id: 8890] /modules/cdc_googletagmanager/services/Gtm_Product.php:164 (__construct) [id: 18708] /modules/cdc_googletagmanager/services/Gtm_Product.php:164 (__construct) [id: 19841] /modules/cdc_googletagmanager/services/Gtm_Product.php:164 (__construct) [id: 96334] /modules/cdc_googletagmanager/services/Gtm_Product.php:164 (__construct) [id: 51984] /modules/cdc_googletagmanager/services/Gtm_Product.php:164 (__construct) [id: 52231] /modules/cdc_googletagmanager/services/Gtm_Product.php:164 (__construct) [id: 65830] /modules/cdc_googletagmanager/services/Gtm_Product.php:164 (__construct) [id: 51655] /modules/cdc_googletagmanager/services/Gtm_Product.php:164 (__construct) [id: 44020] /modules/cdc_googletagmanager/services/Gtm_Product.php:164 (__construct) [id: 92708] /modules/cdc_googletagmanager/services/Gtm_Product.php:164 (__construct) [id: 52841] /classes/Link.php:113 (__construct) [id: 85770] /classes/Link.php:113 (__construct) [id: 85770] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 85770] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 85770] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 85770] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 85770] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 85770] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 85770] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 85770] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 85770] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 85770] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 85770] /classes/Link.php:113 (__construct) [id: 85770] /classes/Link.php:113 (__construct) [id: 92393] /classes/Link.php:113 (__construct) [id: 92393] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 92393] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 92393] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 92393] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 92393] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 92393] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 92393] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 92393] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 92393] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 92393] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 92393] /classes/Link.php:113 (__construct) [id: 92393] /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] /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: 51825] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 51825] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 51825] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 51825] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 51825] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 51825] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 51825] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 51825] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 51825] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 51825] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 51825] /classes/Link.php:113 (__construct) [id: 21166] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 21166] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 21166] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 21166] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 21166] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 21166] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 21166] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 21166] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 21166] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 21166] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 21166] /classes/Link.php:113 (__construct) [id: 5781] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 5781] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 5781] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 5781] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 5781] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 5781] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 5781] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 5781] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 5781] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 5781] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 5781] /classes/Link.php:113 (__construct) [id: 8890] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 8890] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 8890] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 8890] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 8890] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 8890] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 8890] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 8890] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 8890] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 8890] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 8890] /classes/Link.php:113 (__construct) [id: 18708] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 18708] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 18708] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 18708] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 18708] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 18708] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 18708] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 18708] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 18708] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 18708] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 18708] /classes/Link.php:113 (__construct) [id: 19841] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 19841] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 19841] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 19841] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 19841] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 19841] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 19841] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 19841] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 19841] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 19841] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 19841] /classes/Link.php:113 (__construct) [id: 96334] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 96334] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 96334] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 96334] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 96334] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 96334] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 96334] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 96334] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 96334] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 96334] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 96334] /classes/Link.php:113 (__construct) [id: 51984] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 51984] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 51984] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 51984] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 51984] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 51984] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 51984] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 51984] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 51984] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 51984] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 51984] /classes/Link.php:113 (__construct) [id: 52231] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 52231] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 52231] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 52231] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 52231] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 52231] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 52231] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 52231] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 52231] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 52231] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 52231] /classes/Link.php:113 (__construct) [id: 65830] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 65830] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 65830] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 65830] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 65830] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 65830] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 65830] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 65830] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 65830] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 65830] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 65830] /classes/Link.php:113 (__construct) [id: 51655] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 51655] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 51655] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 51655] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 51655] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 51655] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 51655] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 51655] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 51655] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 51655] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 51655] /classes/Link.php:113 (__construct) [id: 44020] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 44020] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 44020] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 44020] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 44020] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 44020] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 44020] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 44020] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 44020] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 44020] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 44020] /classes/Link.php:113 (__construct) [id: 92708] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 92708] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 92708] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 92708] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 92708] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 92708] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 92708] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 92708] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 92708] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 92708] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 92708] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 92708] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 92708] /classes/Link.php:113 (__construct) [id: 52841] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 52841] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 52841] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 52841] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 52841] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 52841] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 52841] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 52841] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 52841] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 52841] /modules/multipleprices/classes/MultiplepricesConfiguration.php:607 (__construct) [id: 52841]
ProductSupplier	96	/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: ] /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]
Address	7	/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: ] /modules/multipleprices/classes/MultiplepricesConfiguration.php:1032 (__construct) [id: ]
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: ]
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]
Carrier	2	/modules/payplug/src/application/adapter/CarrierAdapter.php:45 (__construct) [id: ] /modules/payplug/src/application/adapter/CarrierAdapter.php:45 (__construct) [id: ]
Order	2	/modules/gmerchantcenterpro/lib/hook/hookDisplay.php:95 (__construct) [id: 1] /modules/facebookproductad/lib/hook/hookDisplay.php:149 (__construct) [id: 1]
OrderState	2	/modules/payplug/src/application/adapter/OrderStateAdapter.php:38 (__construct) [id: ] /modules/payplug/src/application/adapter/OrderStateAdapter.php:38 (__construct) [id: ]
CartRule	2	/modules/payplug/src/application/adapter/CartRuleAdapter.php:38 (__construct) [id: ] /modules/payplug/src/application/adapter/CartRuleAdapter.php:38 (__construct) [id: ]
Tax	2	/classes/tax/TaxRulesTaxManager.php:116 (__construct) [id: 1] /classes/tax/TaxRulesTaxManager.php:116 (__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: ]
Currency	2	/src/Adapter/Currency/CurrencyDataProvider.php:101 (__construct) [id: 1] /classes/Tools.php:690 (getCurrencyInstance) [id: 1]
MultiplepricesConfiguration	1	/modules/multipleprices/multipleprices.php:283 (getPriceByProduct) [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

Coffret Soin

THE RITUAL OF SAKURA

THE RITUAL OF AYURVEDA

CICAPAIR

GLOWING & HYDRATING

SUPERFRUIT

ANTI-WRINKLE

ÉMULSION ÉCOLOGIQUE

RITUEL ENERGIE

ANTI-BLEMISH SOLUTIONS ANTI-IMPERFECTIONS

GINZING Rich Energizing Cream

LIFT INTEGRAL

RITUALS HOMME

PROTOCOLE ANTI-TACHES

ATTIVI PURI

SUN PERFECT SPF50

EAU EXTRAORDINAIRE

+9000

Références

Livraison

Offerte

Paiement

Sécurisé

Experts

Beauté

Menu

Nos marques

Paramètres

Rechercher

Stopwatch SQL - 1826 queries

Doubles

Tables stress

ObjectModel instances

Included Files

Hook	Time	Memory Usage
ActionStAssemble	223.334 ms	5.77 Mb
=> stthemeeditor	0.488 ms	0.02 Mb
=> sthoverimage	0.301 ms	0.01 Mb
=> ststickers	14.785 ms	0.49 Mb
=> stlovedproduct	0.526 ms	0.01 Mb
=> stthemeeditor	0.453 ms	0.02 Mb
=> sthoverimage	0.300 ms	0.01 Mb
=> ststickers	9.825 ms	0.23 Mb
=> stlovedproduct	0.568 ms	0.01 Mb
=> stthemeeditor	0.413 ms	0.02 Mb
=> sthoverimage	0.282 ms	0.01 Mb
=> ststickers	20.910 ms	0.65 Mb
=> stlovedproduct	0.538 ms	0.01 Mb
=> stthemeeditor	0.383 ms	0.01 Mb
=> sthoverimage	0.282 ms	0.01 Mb
=> ststickers	10.350 ms	0.27 Mb
=> stlovedproduct	0.782 ms	0.01 Mb
=> stthemeeditor	0.491 ms	0.02 Mb
=> sthoverimage	0.393 ms	0.01 Mb
=> ststickers	6.110 ms	0.15 Mb
=> stlovedproduct	0.586 ms	0.01 Mb
=> stthemeeditor	0.454 ms	0.01 Mb
=> sthoverimage	0.298 ms	0.01 Mb
=> ststickers	6.675 ms	0.17 Mb
=> stlovedproduct	0.556 ms	0.01 Mb
=> stthemeeditor	0.459 ms	0.01 Mb
=> sthoverimage	0.249 ms	0.01 Mb
=> ststickers	11.173 ms	0.28 Mb
=> stlovedproduct	0.532 ms	0.01 Mb
=> stthemeeditor	0.521 ms	0.02 Mb
=> sthoverimage	0.349 ms	0.01 Mb
=> ststickers	6.272 ms	0.15 Mb
=> stlovedproduct	0.753 ms	0.01 Mb
=> stthemeeditor	0.640 ms	0.03 Mb
=> sthoverimage	0.357 ms	0.01 Mb
=> ststickers	9.971 ms	0.24 Mb
=> stlovedproduct	0.544 ms	0.01 Mb
=> stthemeeditor	0.431 ms	0.02 Mb
=> sthoverimage	0.316 ms	0.01 Mb
=> ststickers	17.282 ms	0.42 Mb

Module	Time	Memory Usage
stblog	10.895 ms	1.92 Mb
__construct	10.865 ms	1.91 Mb
hookModuleRoutes	0.009 ms	- Mb
hookOverrideLayoutTemplate	0.011 ms	- Mb
hookOverrideLayoutTemplate	0.006 ms	- Mb
hookOverrideLayoutTemplate	0.004 ms	- Mb
stblogarchives	0.896 ms	0.04 Mb
__construct	0.871 ms	0.04 Mb
hookModuleRoutes	0.005 ms	- Mb
hookDisplayHeader	0.020 ms	- Mb
stblogsearch	0.737 ms	0.02 Mb
__construct	0.733 ms	0.02 Mb
hookModuleRoutes	0.004 ms	- Mb
hioutofstocknotification	6.886 ms	0.59 Mb
__construct	5.855 ms	0.51 Mb
hookModuleRoutes	0.007 ms	- Mb
hookDisplayHeader	0.940 ms	0.06 Mb
hookDisplayProductListReviews	0.006 ms	- Mb
hookDisplayProductListReviews	0.005 ms	- Mb
hookDisplayProductListReviews	0.004 ms	- Mb
hookDisplayProductListReviews	0.005 ms	- Mb
hookDisplayProductListReviews	0.005 ms	- Mb
hookDisplayProductListReviews	0.005 ms	- Mb
hookDisplayProductListReviews	0.005 ms	- Mb
hookDisplayProductListReviews	0.008 ms	- Mb
hookDisplayProductListReviews	0.005 ms	- Mb
hookDisplayProductListReviews	0.006 ms	- Mb
hookDisplayProductListReviews	0.006 ms	- Mb
hookDisplayProductListReviews	0.004 ms	- Mb
hookDisplayProductListReviews	0.005 ms	- Mb
hookDisplayProductListReviews	0.005 ms	- Mb
hookDisplayProductListReviews	0.006 ms	- Mb
hookDisplayProductListReviews	0.004 ms	- Mb
doofinder	3.500 ms	0.41 Mb
__construct	1.603 ms	0.16 Mb
hookModuleRoutes	0.005 ms	- Mb
hookDisplayHeader	1.892 ms	0.25 Mb
ps_checkout	16.425 ms	1.02 Mb
__construct	1.085 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`)	13.048 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)
498	(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 >= 476 AND c.nright <= 481) 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` = 2547 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 >= 476 AND c.nright <= 481) 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` = 2547 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.314 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)
464	(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 >= 476 AND c.nright <= 481) 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` = 2547 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 >= 476 AND c.nright <= 481) 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` = 2547 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.569 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)
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.670 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)
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	2.275 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)
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` = 2547 AND product_shop.`active` = 1 AND product_shop.`visibility` IN ("both", "catalog") ORDER BY cp.`position` ASC LIMIT 0,18	1.933 ms	30			/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)
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	1.644 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)
1818	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.340 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)
450	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` = 2547 AND product_shop.`active` = 1 AND product_shop.`visibility` IN ("both", "catalog") ORDER BY cp.`position` ASC LIMIT 0,18	1.334 ms	30			/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)
497	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 >= 476 AND c.nright <= 481) 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` = 2547 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 >= 476 AND c.nright <= 481) 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` = 2547 AND product_shop.`visibility` IN ("both", "catalog") GROUP BY cp.`id_product` HAVING (COUNT(a.`id_attribute`) = 0) ) ) total_query LIMIT 1	1.316 ms	54000			/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)
499	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 >= 476 AND c.nright <= 481) 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` = 2547 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 >= 476 AND c.nright <= 481) 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` = 2547 AND product_shop.`visibility` IN ("both", "catalog") GROUP BY cp.`id_product` HAVING (COUNT(a.`id_attribute`) = 0) ) ) total_query LIMIT 1	1.290 ms	54000			/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)
517	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 (65840,65834,51825,21166,5781,8890,18708,19841,96334,51984,52231,65830,51655,44020,92708,52841)	1.151 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)
500	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 >= 476 AND c.nright <= 481) 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` = 2547 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 >= 476 AND c.nright <= 481) 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` = 2547 AND product_shop.`visibility` IN ("both", "catalog") GROUP BY cp.`id_product` HAVING (COUNT(a.`id_attribute`) = 0) ) ) total_query LIMIT 1	1.136 ms	54000			/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)
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	1.120 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)
504	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` = 21166 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.082 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)
46	SELECT SQL_NO_CACHE c.*, cl.`id_lang`, cl.`name`, cl.`description`, cl.`additional_description`, cl.`link_rewrite`, cl.`meta_title`, cl.`meta_keywords`, cl.`meta_description` FROM `xj8_category` c INNER JOIN xj8_category_shop category_shop ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1) LEFT JOIN `xj8_category_lang` cl ON (c.`id_category` = cl.`id_category` AND `id_lang` = 1 AND cl.id_shop = 1 ) LEFT JOIN `xj8_category_group` cg ON (cg.`id_category` = c.`id_category`) WHERE `id_parent` = 2547 AND `active` = 1 AND cg.`id_group` =1 GROUP BY c.`id_category` ORDER BY `level_depth` ASC, category_shop.`position` ASC	1.018 ms	2	Yes	Yes	/classes/Category.php:924 /controllers/front/listing/CategoryController.php:229 (getSubCategories) /controllers/front/listing/CategoryController.php:118 (getTemplateVarSubCategories) /tools/profiling/Controller.php:41 (init) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
509	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` = 96334 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.010 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)
505	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` = 5781 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.004 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)
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	0.962 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)
503	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` = 51825 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.962 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)
511	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` = 52231 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.950 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)
513	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` = 51655 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.931 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)
13	SELECT SQL_NO_CACHE lower(name) as name FROM `xj8_hook` h WHERE (h.active = 1)	0.930 ms	1215			/classes/Hook.php:1332 /classes/Hook.php:811 (getHookStatusByName) /classes/Dispatcher.php:606 (exec) /classes/Dispatcher.php:243 (loadRoutes) /classes/Dispatcher.php:201 (__construct) /index.php:28 (getInstance)
515	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` = 92708 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.927 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)
512	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` = 65830 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.903 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)
501	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.893 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)
508	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` = 19841 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.891 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)
506	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` = 8890 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.884 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)
514	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` = 44020 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.866 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)
507	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` = 18708 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.864 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)
502	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.863 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)
1484	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`="2547" OR sms.`show_subcate` = 1 AND sms.`item_v` IN(2547,9,2,1)) ORDER BY sms.`position` LIMIT 1	0.851 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)
1825	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.825 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)
510	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` = 51984 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.811 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)
516	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` = 52841 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.802 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)
42	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.779 ms	151			/classes/module/Module.php:345 /modules/quantitydiscountpro/quantitydiscountpro.php:60 (__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:1235 (get) /tools/profiling/Module.php:35 (coreLoadModule) /classes/module/Module.php:1214 (coreLoadModule) /classes/Hook.php:966 (getInstanceByName) /classes/controller/FrontController.php:514 (exec) /override/classes/controller/FrontController.php:284 (init) /controllers/front/listing/CategoryController.php:81 (init) /tools/profiling/Controller.php:41 (init) /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	0.779 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)
1824	INSERT INTO `xj8_connections_source` (`id_connections`, `http_referer`, `request_uri`, `keywords`, `date_add`) VALUES ('15197661', '', 'preprod-parfumera.fr/2547-coffret-soin', '', '2026-10-05 15:04:19')	0.763 ms	1			/classes/ObjectModel.php:622 /classes/ConnectionsSource.php:105 (add) /modules/statsdata/statsdata.php:119 (logHttpReferer) /modules/statsdata/statsdata.php:74 (getScriptCustomerPagesViews) /classes/Hook.php:1043 (hookDisplayBeforeBodyClosingTag) /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: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)
1304	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.748 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)
919	SELECT SQL_NO_CACHE c., cl. FROM `xj8_category` c LEFT JOIN `xj8_category_lang` cl ON (c.`id_category` = cl.`id_category` AND `id_lang` = 1 AND cl.id_shop = 1 ) WHERE c.`nleft` <= 261 AND c.`nright` >= 262 AND c.`nleft` >= 1 AND c.`nright` <= 1464 ORDER BY `nleft` DESC	0.742 ms	732	Yes		/classes/Category.php:1600 /modules/ststickers/classes/StStickersMapClass.php:168 (getParentsCategories) /modules/ststickers/ststickers.php:1680 (getForProduct) /classes/Hook.php:1043 (hookActionStAssemble) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:418 (coreCallHook) /classes/Hook.php:981 (callHookOn) /override/classes/ProductAssembler.php:57 (exec) /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)

#	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