150 cl Magnum

Wahrscheinlich das beste Format für die Geschmacksqualität, Hals und Verschluss sind identisch mit einer 75 cl. Flasche und der Luftaustausch mit der Außenseite über den Verschluss ist viel eingeschränkter.

51 Artikel(n)

Cristal Louis Roederer Vinothèque 1995 Blanc MAGNUM - 150 cl

Cristal Louis Roederer Vinothèque 1995 Blanc MAGNUM - 150 cl 2

Nur online erhältlich

Verfügbar

CRISTAL LOUIS ROEDERER

Cristal Louis Roederer

Vinothèque 1995 Blanc MAGNUM - 150 cl

15275.95

3.750,00 CHF

Der 1995er-Jahrgangswein spiegelt die ganz klassischen klimatischen Bedingungen in der Champagne auf perfekte Art und Weise wider: Er ist elegant, hat eine schöne Säure und eine wunderbare geschmackliche Komplexität. Aufgrund der Chardonnay-Trauben der Côte des Blancs und einiger Pinots Noirs, die auf Kreideböden gewachsen sind, ist der Wein noch...

Cristal Louis Roederer Vinothèque 1999 Rosé MAGNUM - 150 cl

Nur online erhältlich
-301,00 CHF

Verfügbar

CRISTAL LOUIS ROEDERER

Cristal Louis Roederer

Vinothèque 1999 Rosé MAGNUM - 150 cl

16415.99

3.449,00 CHF 3.750,00 CHF

Frische rosa Farbe mit goldenen Reflexen. Feine, regelmäßige Perlage, beinahe leuchtend aufgrund ihrer Bläschen und ihrer goldfarbenen Reflexe. Bukett mit zarten, süßen Noten von Blüten (Weißdorn) und leicht säuerlichen, frischen roten Früchten (Johannisbeeren). Die außerordentlich schöne Reife der Trauben zeigt sich in einer lieblichen Dichte, zu der...

Cristal Louis Roederer Vinothèque 1996 Rosé MAGNUM - 150 cl

Nur online erhältlich

Verfügbar

CRISTAL LOUIS ROEDERER

Cristal Louis Roederer

Vinothèque 1996 Rosé MAGNUM - 150 cl

16415.96

3.850,00 CHF

Ein Wein, dessen konzentrierte und fast schon ölige Aromenvielfalt von der Zeit geprägt und geformt wurde wie von einem Künstler und dem sogar seine sanften, perfekten, den Gaumen liebkosenden Bläschen zu Textur und Materie verhelfen. Ausgewogener, vorzüglicher und samtiger Auftakt am Gaumen. Eine mineralische Frische mit einer schier unbegrenzten...

49 - 51 von 51 Artikel(n)

Load Time	469.438 ms
Querying Time	235 ms
Queries	1197
Memory Peak Usage	66.1 Mb
Included Files	1204 files - 12.02 Mb
PrestaShop Cache	- Mb
Global vars	0.17 Mb
- global $_MODULES	91k
- global $_MODULE	37k
- global $_SERVER	12k
- global $_ENV	12k
- global $__composer_autoload_files	5k
- global $config	5k
- global $context	4k
- global $exportPhpConfigFile	4k

PrestaShop Version	8.2.1
PHP Version	8.1.33
MySQL Version	10.6.22-MariaDB-deb11-log
Memory Limit	640M
Max Execution Time	60s
Smarty Cache	enabled
Smarty Compilation	auto

	Time	Cumulated Time	Memory Usage	Memory Peak Usage
config	3.172 ms	3.172 ms	20.69 Mb	21.5 Mb
__construct	0.008 ms	3.180 ms	- Mb	21.5 Mb
init	49.885 ms	53.065 ms	5.91 Mb	27.7 Mb
checkAccess	0.001 ms	53.066 ms	- Mb	27.7 Mb
setMedia	1.989 ms	55.055 ms	0.40 Mb	27.7 Mb
postProcess	0.001 ms	55.056 ms	- Mb	27.7 Mb
initHeader	0.001 ms	55.057 ms	- Mb	27.7 Mb
initContent	255.402 ms	310.459 ms	21.62 Mb	48.7 Mb
initFooter	0.002 ms	310.461 ms	- Mb	48.7 Mb
display	158.977 ms	469.438 ms	17.11 Mb	66.1 Mb

Hook	Time	Memory Usage
DisplayProductListFunctionalButtons	37.751 ms	4.66 Mb
=> productlabelsandstickers	13.655 ms	2.17 Mb
=> productlabelsandstickers	12.686 ms	1.33 Mb
=> productlabelsandstickers	11.410 ms	1.17 Mb
DisplayProductListReviews	32.996 ms	3.22 Mb
=> productlabelsandstickers	11.254 ms	1.08 Mb
=> productlabelsandstickers	11.174 ms	1.13 Mb
=> productlabelsandstickers	10.568 ms	1.02 Mb
displayFooterBefore	28.931 ms	3.36 Mb
=> ps_emailsubscription (widget)	28.931 ms	3.36 Mb
DisplayGDPRConsent	26.177 ms	3.10 Mb
=> psgdpr	26.177 ms	3.10 Mb
DisplayAfterTitleTag	5.824 ms	0.67 Mb
=> cdc_googletagmanager	5.824 ms	0.67 Mb
DisplayHeader	3.328 ms	0.61 Mb
=> productcomments	0.046 ms	- Mb
=> ps_shoppingcart	0.017 ms	- Mb
=> psxmarketingwithgoogle	0.985 ms	0.20 Mb
=> iqitcontactpage	0.001 ms	- Mb
=> iqitcookielaw	0.055 ms	- Mb
=> iqitcountdown	0.044 ms	- Mb
=> iqitelementor	0.103 ms	- Mb
=> iqitfreedeliverycount	0.010 ms	- Mb
=> iqitmegamenu	0.061 ms	- Mb
=> iqitreviews	0.036 ms	- Mb
=> iqitsizecharts	0.025 ms	- Mb
=> iqitthemeeditor	0.092 ms	0.02 Mb
=> iqitwishlist	0.036 ms	- Mb
=> iqitextendedproduct	0.044 ms	- Mb
=> iqitsociallogin	0.023 ms	- Mb
=> stripe_official	0.199 ms	0.04 Mb
=> doofinder	1.395 ms	0.32 Mb
=> qrcodefacturesuisse	0.048 ms	- Mb
=> productlabelsandstickers	0.057 ms	- Mb
=> cdc_googletagmanager	0.046 ms	- Mb
=> antispamprotector	0.005 ms	- Mb
displayBeforeBodyClosingTag	2.986 ms	0.79 Mb
=> iqitwishlist (widget)	2.608 ms	0.74 Mb
=> iqitcookielaw (widget)	0.378 ms	0.05 Mb
displayLeftColumn	2.812 ms	0.18 Mb
=> ps_categorytree (widget)	2.812 ms	0.18 Mb
displayProductListReviews	2.494 ms	0.35 Mb
=> iqitreviews (widget)	1.241 ms	0.27 Mb
=> iqitreviews (widget)	0.640 ms	0.04 Mb
=> iqitreviews (widget)	0.613 ms	0.04 Mb
displayNav1	1.962 ms	0.21 Mb
=> iqitlinksmanager (widget)	1.962 ms	0.21 Mb
ProductSearchProvider	1.854 ms	1.44 Mb
=> pm_productsbyattributes	1.814 ms	1.43 Mb
=> iqitthemeeditor	0.002 ms	- Mb
=> pm_productsbyattributes	0.020 ms	- Mb
=> iqitthemeeditor	0.000 ms	- Mb
=> pm_productsbyattributes	0.018 ms	- Mb
=> iqitthemeeditor	0.000 ms	- Mb
displayNav2	1.343 ms	0.11 Mb
=> ps_languageselector (widget)	1.018 ms	0.06 Mb
=> ps_currencyselector (widget)	0.325 ms	0.04 Mb
displayProductListFunctionalButtons	1.243 ms	0.01 Mb
=> iqitwishlist (widget)	0.464 ms	0.01 Mb
=> iqitwishlist (widget)	0.393 ms	- Mb
=> iqitwishlist (widget)	0.386 ms	- Mb
displayMainMenu	1.200 ms	0.18 Mb
=> iqitmegamenu (widget)	1.200 ms	0.18 Mb
renderWidget	1.115 ms	0.06 Mb
=> iqitsearch (widget)	1.115 ms	0.06 Mb
displayCategoryElementor	0.826 ms	0.08 Mb
=> iqitelementor (widget)	0.826 ms	0.08 Mb
displayHeaderButtons	0.786 ms	0.05 Mb
=> iqitwishlist (widget)	0.786 ms	0.05 Mb
displayCountDown	0.783 ms	0.08 Mb
=> iqitcountdown (widget)	0.783 ms	0.08 Mb
displayFooter	0.701 ms	0.11 Mb
=> iqitlinksmanager (widget)	0.222 ms	0.04 Mb
=> iqitcontactpage (widget)	0.479 ms	0.07 Mb
ActionFrontControllerSetMedia	0.550 ms	0.12 Mb
=> ps_emailsubscription	0.514 ms	0.12 Mb
=> iqitproductvariants	0.036 ms	- Mb
ActionDispatcher	0.507 ms	0.01 Mb
=> antispamprotector	0.498 ms	0.01 Mb
=> iqitthemeeditor	0.009 ms	- Mb
displayCustomerLoginFormAfter	0.440 ms	0.07 Mb
=> iqitsociallogin (widget)	0.440 ms	0.07 Mb
displayAfterBreadcrumb	0.361 ms	0.04 Mb
=> iqitproductsnav (widget)	0.357 ms	0.04 Mb
=> iqitproductsnav (widget)	0.004 ms	- Mb
DisplayAfterBodyOpeningTag	0.336 ms	0.01 Mb
=> cdc_googletagmanager	0.336 ms	0.01 Mb
IsJustElementor	0.268 ms	0.02 Mb
=> iqitelementor	0.268 ms	0.02 Mb
Header	0.174 ms	0.01 Mb
=> mqc	0.117 ms	- Mb
=> bonslick	0.002 ms	- Mb
=> twint_for_prestashop	0.055 ms	- Mb
ActionGetProductPropertiesAfterUnitPrice	0.080 ms	0.02 Mb
=> pm_productsbyattributes	0.002 ms	- Mb
=> pm_productsbyattributes	0.001 ms	- Mb
=> pm_productsbyattributes	0.001 ms	- Mb
=> pm_productsbyattributes	0.001 ms	- Mb
=> pm_productsbyattributes	0.001 ms	- Mb
=> pm_productsbyattributes	0.001 ms	- Mb
=> pm_productsbyattributes	0.001 ms	- Mb
=> pm_productsbyattributes	0.001 ms	- Mb
=> pm_productsbyattributes	0.001 ms	- Mb
=> pm_productsbyattributes	0.001 ms	- Mb
=> pm_productsbyattributes	0.001 ms	- Mb
=> pm_productsbyattributes	0.001 ms	- Mb
=> pm_productsbyattributes	0.000 ms	- Mb
=> pm_productsbyattributes	0.001 ms	- Mb
=> pm_productsbyattributes	0.001 ms	- Mb
=> pm_productsbyattributes	0.000 ms	- Mb
=> pm_productsbyattributes	0.001 ms	- Mb
=> pm_productsbyattributes	0.001 ms	- Mb
=> pm_productsbyattributes	0.001 ms	- Mb
=> pm_productsbyattributes	0.001 ms	- Mb
=> pm_productsbyattributes	0.001 ms	- Mb
=> pm_productsbyattributes	0.001 ms	- Mb
=> pm_productsbyattributes	0.001 ms	- Mb
=> pm_productsbyattributes	0.001 ms	- Mb
=> pm_productsbyattributes	0.001 ms	- Mb
=> pm_productsbyattributes	0.001 ms	- Mb
=> pm_productsbyattributes	0.001 ms	- Mb
=> pm_productsbyattributes	0.001 ms	- Mb
=> pm_productsbyattributes	0.001 ms	- Mb
=> pm_productsbyattributes	0.001 ms	- Mb
=> pm_productsbyattributes	0.001 ms	- Mb
=> pm_productsbyattributes	0.001 ms	- Mb
=> pm_productsbyattributes	0.002 ms	- Mb
=> pm_productsbyattributes	0.002 ms	- Mb
=> pm_productsbyattributes	0.002 ms	- Mb
=> pm_productsbyattributes	0.002 ms	- Mb
=> pm_productsbyattributes	0.002 ms	- Mb
=> pm_productsbyattributes	0.002 ms	- Mb
=> pm_productsbyattributes	0.001 ms	- Mb
=> pm_productsbyattributes	0.003 ms	- Mb
=> pm_productsbyattributes	0.002 ms	- Mb
=> pm_productsbyattributes	0.001 ms	- Mb
=> pm_productsbyattributes	0.002 ms	- Mb
=> pm_productsbyattributes	0.003 ms	- Mb
=> pm_productsbyattributes	0.002 ms	- Mb
=> pm_productsbyattributes	0.002 ms	- Mb
=> pm_productsbyattributes	0.002 ms	- Mb
=> pm_productsbyattributes	0.002 ms	- Mb
=> pm_productsbyattributes	0.002 ms	- Mb
=> pm_productsbyattributes	0.002 ms	- Mb
=> pm_productsbyattributes	0.002 ms	- Mb
=> pm_productsbyattributes	0.004 ms	- Mb
=> pm_productsbyattributes	0.004 ms	- Mb
=> pm_productsbyattributes	0.003 ms	- Mb
FilterProductSearch	0.044 ms	- Mb
=> pm_productsbyattributes	0.044 ms	- Mb
displayVerticalMenu	0.020 ms	- Mb
=> iqitmegamenu (widget)	0.020 ms	- Mb
ActionProductFlagsModifier	0.014 ms	- Mb
=> pm_productsbyattributes	0.005 ms	- Mb
=> pm_productsbyattributes	0.005 ms	- Mb
=> pm_productsbyattributes	0.004 ms	- Mb
DisplayProductPriceBlock	0.014 ms	- Mb
=> cdc_googletagmanager	0.003 ms	- Mb
=> cdc_googletagmanager	0.001 ms	- Mb
=> cdc_googletagmanager	0.001 ms	- Mb
=> cdc_googletagmanager	0.002 ms	- Mb
=> cdc_googletagmanager	0.001 ms	- Mb
=> cdc_googletagmanager	0.001 ms	- Mb
=> cdc_googletagmanager	0.000 ms	- Mb
=> cdc_googletagmanager	0.003 ms	- Mb
=> cdc_googletagmanager	0.001 ms	- Mb
=> cdc_googletagmanager	0.001 ms	- Mb
DisplayBeforeBodyClosingTag	0.008 ms	- Mb
=> cdc_googletagmanager	0.008 ms	- Mb
ActionProductSearchAfter	0.005 ms	- Mb
=> iqitthemeeditor	0.005 ms	- Mb
ModuleRoutes	0.003 ms	- Mb
=> doofinder	0.003 ms	- Mb
34 hook(s)	157.937 ms	19.57 Mb

78 queries	SELECT * FROM ps_attachment a LEFT JOIN ps_attachment_lang al ON (a.id_attachment = al.id_attachment AND al.id_lang = XX)
63 queries	SELECT COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), XX) as deep_quantity, COALESCE(SUM(first_level_quantity), XX) as quantity FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, XX as pack_quantity FROM `ps_cart_product` cp WHERE cp.`id_product_attribute` = XX AND cp.`id_cart` = XX AND cp.`id_product` = XX UNION SELECT XX as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity FROM `ps_cart_product` cp JOIN `ps_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `ps_product` pr ON p.`id_product_pack` = pr.`id_product` WHERE cp.`id_product_attribute` = XX AND cp.`id_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
54 queries	SELECT name FROM ps_category_lang WHERE id_shop = XX AND id_lang = XX AND id_category = XX LIMIT XX
54 queries	SELECT `id_customization_field`, `type` FROM `ps_customization_field` WHERE `id_product` = XX AND `required` = XX AND `is_deleted` = XX
53 queries	SELECT XX FROM `ps_specific_price` WHERE id_product = XX LIMIT XX
52 queries	SELECT product_shop.`price`, product_shop.`ecotax`, IFNULL(product_attribute_shop.id_product_attribute,XX) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on, product_attribute_shop.`ecotax` AS attribute_ecotax FROM `ps_product` p INNER JOIN `ps_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = XX) LEFT JOIN `ps_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = XX) WHERE (p.`id_product` = XX)
52 queries	SELECT `id_tax_rules_group` FROM `ps_product_shop` WHERE `id_product` = XX AND id_shop=XX LIMIT XX
52 queries	SELECT `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = XX AND `id_group` = XX LIMIT XX
52 queries	SELECT COUNT(*) FROM `ps_pack` WHERE id_product_pack = XX LIMIT XX
52 queries	SELECT product_type FROM `ps_product` WHERE id_product = XX LIMIT XX
52 queries	SELECT SUM(quantity) FROM `ps_stock_available` WHERE (id_product = XX) AND (id_product_attribute = XX) AND (id_shop = XX) AND (id_shop_group = XX) LIMIT XX
52 queries	SELECT * FROM `ps_fmm_stickers` WHERE `sticker_id` = XX AND `product` > XX AND ( (`start_date` = 'XX-XX-XX XX:XX:XX' OR 'XX-XX-XX XX:XX:XX' >= `start_date`) AND (`expiry_date` = 'XX-XX-XX XX:XX:XX' OR 'XX-XX-XX XX:XX:XX' <= `expiry_date`) )
51 queries	SELECT image_shop.`id_image` FROM `ps_image` i INNER JOIN ps_image_shop image_shop ON (image_shop.id_image = i.id_image AND image_shop.id_shop = XX) WHERE i.`id_product` = XX AND image_shop.`cover` = XX LIMIT XX
51 queries	SELECT name, value, pf.id_feature, f.position, fvl.id_feature_value FROM ps_feature_product pf LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = XX) LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = XX) LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = XX) INNER JOIN ps_feature_shop feature_shop ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = XX) WHERE pf.id_product = XX ORDER BY f.position ASC
51 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 `ps_product_attribute` pa INNER JOIN ps_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = XX) LEFT JOIN `ps_product_attribute_combination` pac ON pac.`id_product_attribute` = pa.`id_product_attribute` LEFT JOIN `ps_attribute` a ON a.`id_attribute` = pac.`id_attribute` LEFT JOIN `ps_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group` LEFT JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = XX) JOIN `ps_product` p ON (p.`id_product` = pa.`id_product`) LEFT JOIN ps_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, XX, IF (stock.`out_of_stock` = XX, XX = XX, stock.`out_of_stock` = XX)) GROUP BY pa.`id_product_attribute` ORDER BY SUM(ag.`position`), SUM(a.`position`), pac.`id_product_attribute`
19 queries	SELECT `id_module` FROM `ps_module_shop` WHERE `id_module` = XX AND `id_shop` = XX LIMIT XX
16 queries	SELECT cl.`link_rewrite` FROM `ps_category_lang` cl WHERE `id_lang` = XX AND cl.id_shop = XX AND cl.`id_category` = XX LIMIT XX
13 queries	SELECT * FROM `ps_product` a LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = XX LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = XX WHERE (a.`id_product` = XX) AND (b.`id_shop` = XX) LIMIT XX
12 queries	SELECT out_of_stock FROM `ps_stock_available` WHERE (id_product = XX) AND (id_product_attribute = XX) AND (id_shop = XX) AND (id_shop_group = XX) LIMIT XX
12 queries	SELECT depends_on_stock FROM `ps_stock_available` WHERE (id_product = XX) AND (id_product_attribute = XX) AND (id_shop = XX) AND (id_shop_group = XX) LIMIT XX
12 queries	SELECT location FROM `ps_stock_available` WHERE (id_product = XX) AND (id_product_attribute = XX) AND (id_shop = XX) AND (id_shop_group = XX) LIMIT XX
12 queries	SELECT t.`id_lang`, t.`name` FROM ps_tag t LEFT JOIN ps_product_tag pt ON (pt.id_tag = t.id_tag) WHERE pt.`id_product`=XX
10 queries	SELECT `name` FROM `ps_manufacturer` WHERE `id_manufacturer` = XX AND `active` = XX LIMIT XX
8 queries	SELECT `id_lang` FROM `ps_lang` WHERE `locale` = 'de-de' OR `language_code` = 'de-de' LIMIT XX
7 queries	SELECT product_attribute_shop.id_product_attribute FROM ps_product_attribute pa INNER JOIN ps_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = XX) WHERE pa.id_product = XX LIMIT XX
6 queries	SELECT `priority`, `id_specific_price_priority` FROM `ps_specific_price_priority` WHERE `id_product` = XX ORDER BY `id_specific_price_priority` DESC LIMIT XX
6 queries	SELECT *, ( IF (`id_group` = XX, XX, XX) + IF (`id_country` = XX, XX, XX) + IF (`id_currency` = XX, XX, XX) + IF (`id_shop` = XX, XX, XX) + IF (`id_customer` = XX, XX, XX)) AS `score` FROM `ps_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
6 queries	SELECT * FROM `ps_product` a LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = XX WHERE (a.`id_product` = XX) LIMIT XX
6 queries	SELECT * FROM `ps_product_lang` WHERE `id_product` = XX AND `id_shop` = XX
6 queries	SELECT COUNT(p.id_product) FROM `ps_product` p INNER JOIN ps_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = XX) WHERE p.id_product = XX AND DATEDIFF("XX-XX-XX XX:XX:XX", product_shop.`date_add`) < XX LIMIT XX
6 queries	SELECT psXX.* FROM `ps_fmm_stickers` psXX LEFT JOIN ps_fmm_stickers_products psXX ON (psXX.sticker_id = psXX.sticker_id) WHERE psXX.`id_product` = XX AND psXX.`product` > XX AND ( (psXX.`start_date` = 'XX-XX-XX XX:XX:XX' OR 'XX-XX-XX XX:XX:XX' >= psXX.`start_date`) AND (psXX.`expiry_date` = 'XX-XX-XX XX:XX:XX' OR 'XX-XX-XX XX:XX:XX' <= psXX.`expiry_date`) )
6 queries	SELECT b.*, bl.`title` FROM `ps_fmm_stickersbanners` b LEFT JOIN ps_fmm_stickersbanners_products bp ON (b.stickersbanners_id = bp.stickersbanners_id) LEFT JOIN ps_fmm_stickersbanners_lang bl ON (b.stickersbanners_id = bl.stickersbanners_id) LEFT JOIN ps_fmm_stickersbanners_shop ssh ON (b.stickersbanners_id = ssh.stickersbanners_id) WHERE bp.`id_product` = XX AND `id_lang` = XX AND ssh.id_shop = XX AND ( (b.`start_date` = 'XX-XX-XX XX:XX:XX' OR 'XX-XX-XX XX:XX:XX' >= b.`start_date`) AND (b.`expiry_date` = 'XX-XX-XX XX:XX:XX' OR 'XX-XX-XX XX:XX:XX' <= b.`expiry_date`) ) LIMIT XX
6 queries	SELECT fsr.* FROM `ps_fmm_stickers_rules` fsr LEFT JOIN `ps_fmm_stickers_rules_shop` fsrs ON (fsr.`fmm_stickers_rules_id` = fsrs.`fmm_stickers_rules_id`) WHERE fsr.`status` = XX AND fsr.`rule_type` = "new" AND fsrs.`id_shop` = XX AND ( (fsr.`start_date` = 'XX-XX-XX XX:XX:XX' OR 'XX-XX-XX XX:XX:XX' >= fsr.`start_date`) AND (fsr.`expiry_date` = 'XX-XX-XX XX:XX:XX' OR 'XX-XX-XX XX:XX:XX' <= fsr.`expiry_date`) )
6 queries	SELECT SUM(`quantity`) FROM `ps_cart_product` WHERE `id_product` = XX AND `id_cart` = XX LIMIT XX
6 queries	SELECT `sale_nbr` FROM ps_product_sale WHERE `id_product` = XX LIMIT XX
6 queries	SELECT fsr.* FROM `ps_fmm_stickers_rules` fsr LEFT JOIN `ps_fmm_stickers_rules_shop` fsrs ON (fsr.`fmm_stickers_rules_id` = fsrs.`fmm_stickers_rules_id`) WHERE fsr.`status` = XX AND fsr.`rule_type` = "tag" AND fsrs.`id_shop` = XX AND ( (fsr.`start_date` = 'XX-XX-XX XX:XX:XX' OR 'XX-XX-XX XX:XX:XX' >= fsr.`start_date`) AND (fsr.`expiry_date` = 'XX-XX-XX XX:XX:XX' OR 'XX-XX-XX XX:XX:XX' <= fsr.`expiry_date`) )
6 queries	SELECT fsr.* FROM `ps_fmm_stickers_rules` fsr LEFT JOIN `ps_fmm_stickers_rules_shop` fsrs ON (fsr.`fmm_stickers_rules_id` = fsrs.`fmm_stickers_rules_id`) WHERE fsr.`status` = XX AND fsr.`rule_type` = "reference" AND fsrs.`id_shop` = XX AND ( (fsr.`start_date` = 'XX-XX-XX XX:XX:XX' OR 'XX-XX-XX XX:XX:XX' >= fsr.`start_date`) AND (fsr.`expiry_date` = 'XX-XX-XX XX:XX:XX' OR 'XX-XX-XX XX:XX:XX' <= fsr.`expiry_date`) )
6 queries	SELECT fsr.* FROM `ps_fmm_stickers_rules` fsr LEFT JOIN `ps_fmm_stickers_rules_shop` fsrs ON (fsr.`fmm_stickers_rules_id` = fsrs.`fmm_stickers_rules_id`) WHERE fsr.`status` = XX AND fsr.`rule_type` = "price_less" AND fsrs.`id_shop` = XX AND ( (fsr.`start_date` = 'XX-XX-XX XX:XX:XX' OR 'XX-XX-XX XX:XX:XX' >= fsr.`start_date`) AND (fsr.`expiry_date` = 'XX-XX-XX XX:XX:XX' OR 'XX-XX-XX XX:XX:XX' <= fsr.`expiry_date`) )
6 queries	SELECT fsr.* FROM `ps_fmm_stickers_rules` fsr LEFT JOIN `ps_fmm_stickers_rules_shop` fsrs ON (fsr.`fmm_stickers_rules_id` = fsrs.`fmm_stickers_rules_id`) WHERE fsr.`status` = XX AND fsr.`rule_type` = "price_greater" AND fsrs.`id_shop` = XX AND ( (fsr.`start_date` = 'XX-XX-XX XX:XX:XX' OR 'XX-XX-XX XX:XX:XX' >= fsr.`start_date`) AND (fsr.`expiry_date` = 'XX-XX-XX XX:XX:XX' OR 'XX-XX-XX XX:XX:XX' <= fsr.`expiry_date`) )
6 queries	SELECT fsr.* FROM `ps_fmm_stickers_rules` fsr LEFT JOIN `ps_fmm_stickers_rules_shop` fsrs ON (fsr.`fmm_stickers_rules_id` = fsrs.`fmm_stickers_rules_id`) WHERE fsr.`status` = XX AND fsr.`rule_type` = "category" AND fsrs.`id_shop` = XX AND ( (fsr.`start_date` = 'XX-XX-XX XX:XX:XX' OR 'XX-XX-XX XX:XX:XX' >= fsr.`start_date`) AND (fsr.`expiry_date` = 'XX-XX-XX XX:XX:XX' OR 'XX-XX-XX XX:XX:XX' <= fsr.`expiry_date`) )
6 queries	SELECT fsr.* FROM `ps_fmm_stickers_rules` fsr LEFT JOIN `ps_fmm_stickers_rules_shop` fsrs ON (fsr.`fmm_stickers_rules_id` = fsrs.`fmm_stickers_rules_id`) WHERE fsr.`status` = XX AND fsr.`rule_type` = "brand" AND fsrs.`id_shop` = XX AND ( (fsr.`start_date` = 'XX-XX-XX XX:XX:XX' OR 'XX-XX-XX XX:XX:XX' >= fsr.`start_date`) AND (fsr.`expiry_date` = 'XX-XX-XX XX:XX:XX' OR 'XX-XX-XX XX:XX:XX' <= fsr.`expiry_date`) )
6 queries	SELECT fsr.* FROM `ps_fmm_stickers_rules` fsr LEFT JOIN `ps_fmm_stickers_rules_shop` fsrs ON (fsr.`fmm_stickers_rules_id` = fsrs.`fmm_stickers_rules_id`) WHERE fsr.`status` = XX AND fsr.`rule_type` = "supplier" AND fsrs.`id_shop` = XX AND ( (fsr.`start_date` = 'XX-XX-XX XX:XX:XX' OR 'XX-XX-XX XX:XX:XX' >= fsr.`start_date`) AND (fsr.`expiry_date` = 'XX-XX-XX XX:XX:XX' OR 'XX-XX-XX XX:XX:XX' <= fsr.`expiry_date`) )
6 queries	SELECT fsr.* FROM `ps_fmm_stickers_rules` fsr LEFT JOIN `ps_fmm_stickers_rules_shop` fsrs ON (fsr.`fmm_stickers_rules_id` = fsrs.`fmm_stickers_rules_id`) WHERE fsr.`status` = XX AND fsr.`rule_type` = "product" AND fsrs.`id_shop` = XX AND ( (fsr.`start_date` = 'XX-XX-XX XX:XX:XX' OR 'XX-XX-XX XX:XX:XX' >= fsr.`start_date`) AND (fsr.`expiry_date` = 'XX-XX-XX XX:XX:XX' OR 'XX-XX-XX XX:XX:XX' <= fsr.`expiry_date`) )
4 queries	SELECT * FROM `ps_category` a LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = XX LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = XX WHERE (a.`id_category` = XX) AND (b.`id_shop` = XX) LIMIT XX
4 queries	SELECT * FROM `ps_currency` a LEFT JOIN `ps_currency_lang` `b` ON a.`id_currency` = b.`id_currency` AND b.`id_lang` = XX LEFT JOIN `ps_currency_shop` `c` ON a.`id_currency` = c.`id_currency` AND c.`id_shop` = XX WHERE (a.`id_currency` = XX) LIMIT XX
4 queries	SELECT * FROM `ps_category` a LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = XX WHERE (a.`id_category` = XX) LIMIT XX
4 queries	SELECT * FROM `ps_category_lang` WHERE `id_category` = XX AND `id_shop` = XX
3 queries	SELECT tr.* FROM `ps_tax_rule` tr JOIN `ps_tax_rules_group` trg ON (tr.`id_tax_rules_group` = trg.`id_tax_rules_group`) WHERE trg.`active` = XX AND tr.`id_country` = XX AND tr.`id_tax_rules_group` = XX AND tr.`id_state` IN (XX, XX) AND ('XX' BETWEEN tr.`zipcode_from` AND tr.`zipcode_to` OR (tr.`zipcode_to` = XX AND tr.`zipcode_from` IN(XX, 'XX'))) ORDER BY tr.`zipcode_from` DESC, tr.`zipcode_to` DESC, tr.`id_state` DESC, tr.`id_country` DESC
3 queries	SELECT id_product_item, id_product_attribute_item, quantity FROM `ps_pack` where id_product_pack = XX
3 queries	SELECT p., product_shop., pl.*, image_shop.`id_image` id_image, il.`legend`, cl.`name` AS category_default, a.quantity AS pack_quantity, product_shop.`id_category_default`, a.id_product_pack, a.id_product_attribute_item FROM `ps_pack` a LEFT JOIN `ps_product` p ON p.id_product = a.id_product_item LEFT JOIN `ps_product_lang` pl ON p.id_product = pl.id_product AND pl.`id_lang` = XX AND pl.id_shop = XX LEFT JOIN `ps_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 `ps_image_lang` il ON (image_shop.`id_image` = il.`id_image` AND il.`id_lang` = XX) INNER JOIN ps_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = XX) LEFT JOIN `ps_category_lang` cl ON product_shop.`id_category_default` = cl.`id_category` AND cl.`id_lang` = XX AND cl.id_shop = XX WHERE product_shop.`id_shop` = XX AND a.`id_product_pack` = XX GROUP BY a.`id_product_item`, a.`id_product_attribute_item`
3 queries	SELECT COUNT(total) as total FROM ( ( SELECT COUNT(p.`id_product`) as total FROM `ps_category_product` cp RIGHT JOIN `ps_category` c ON (c.`id_category` = cp.`id_category` AND c.nleft >= XX AND c.nright <= XX) LEFT JOIN `ps_product` p ON p.`id_product` = cp.`id_product` INNER JOIN ps_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = XX) LEFT JOIN `ps_product_attribute` pa ON pa.`id_product` = p.`id_product` LEFT JOIN `ps_product_attribute_combination` pac ON pac.`id_product_attribute` = pa.`id_product_attribute` JOIN `ps_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 ps_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 `ps_attribute` a ON a.`id_attribute` = pac.`id_attribute` LEFT JOIN `ps_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, 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 `ps_category_product` cp RIGHT JOIN `ps_category` c ON (c.`id_category` = cp.`id_category` AND c.nleft >= XX AND c.nright <= XX) LEFT JOIN `ps_product` p ON p.`id_product` = cp.`id_product` INNER JOIN ps_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = XX) LEFT JOIN `ps_product_attribute` pa ON pa.`id_product` = p.`id_product` AND pa.`default_on` = XX LEFT JOIN `ps_product_attribute_combination` pac ON pac.`id_product_attribute` = pa.`id_product_attribute` LEFT JOIN `ps_attribute` a ON a.`id_attribute` = pac.`id_attribute` AND (a.`id_attribute_group` IN (XX)) LEFT JOIN `ps_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 ps_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 image_shop.`cover`, i.`id_image`, il.`legend`, i.`position` FROM `ps_image` i INNER JOIN ps_image_shop image_shop ON (image_shop.id_image = i.id_image AND image_shop.id_shop = XX) LEFT JOIN `ps_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = XX) WHERE i.`id_product` = XX ORDER BY `position`
3 queries	SELECT `id_product_attribute` FROM `ps_product_attribute` WHERE `id_product` = XX
3 queries	SELECT DISTINCT pl.name as name FROM `ps_product_lang` pl WHERE (pl.id_product = XX) AND (pl.id_lang = XX AND pl.id_shop = XX ) LIMIT XX
3 queries	SELECT `id_category` FROM `ps_category_product` WHERE `id_product` = XX
3 queries	SELECT (SUM(pr.`rating`) / COUNT(pr.`rating`)) AS avarageRating, COUNT(pr.`rating`) as reviewsNb FROM `ps_iqitreviews_products` pr WHERE pr.`status` = XX AND pr.`id_product` = XX LIMIT XX
3 queries	SELECT pa.`id_product`, a.`color`, pac.`id_product_attribute`, SUM(IF(stock.`quantity` > XX, XX, XX)) qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by FROM `ps_product_attribute` pa INNER JOIN ps_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = XX) LEFT JOIN ps_stock_available stock ON (stock.id_product = `pa`.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 `ps_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`) JOIN `ps_attribute` a ON (a.`id_attribute` = pac.`id_attribute`) JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = XX) JOIN `ps_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`) WHERE pa.`id_product` IN (XX) AND ag.`is_color_group` = XX GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` HAVING qty > XX ORDER BY a.`position` ASC;
2 queries	SELECT * FROM `ps_lang` a LEFT JOIN `ps_lang_shop` `c` ON a.`id_lang` = c.`id_lang` AND c.`id_shop` = XX WHERE (a.`id_lang` = XX) LIMIT XX
2 queries	SELECT id_shop FROM `ps_lang_shop` WHERE `id_lang` = XX AND id_shop = XX LIMIT XX
2 queries	SELECT m.`id_module`, m.`name`, ms.`id_module`as `mshop` FROM `ps_module` m LEFT JOIN `ps_module_shop` ms ON m.`id_module` = ms.`id_module` AND ms.`id_shop` = XX
2 queries	SELECT `id_category` FROM `ps_category_shop` WHERE `id_category` = XX AND `id_shop` = XX LIMIT XX
2 queries	(SELECT 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_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`, XX AS spa_eligible_product FROM `ps_category_product` cp RIGHT JOIN `ps_category` c ON (c.`id_category` = cp.`id_category` AND c.nleft >= XX AND c.nright <= XX) LEFT JOIN `ps_product` p ON p.`id_product` = cp.`id_product` INNER JOIN ps_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = XX) LEFT JOIN `ps_category_lang` cl ON (product_shop.`id_category_default` = cl.`id_category` AND cl.`id_lang` = XX AND cl.id_shop = XX ) LEFT JOIN `ps_product_lang` pl ON (p.`id_product` = pl.`id_product` AND pl.`id_lang` = XX AND pl.id_shop = XX ) LEFT JOIN `ps_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 `ps_image_lang` il ON (image_shop.`id_image` = il.`id_image` AND il.`id_lang` = XX) LEFT JOIN `ps_manufacturer` m ON m.`id_manufacturer` = p.`id_manufacturer` LEFT JOIN `ps_product_attribute` pa ON pa.`id_product` = p.`id_product` LEFT JOIN `ps_product_attribute_combination` pac ON pac.`id_product_attribute` = pa.`id_product_attribute` JOIN `ps_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 `ps_attribute` a ON a.`id_attribute` = pac.`id_attribute` AND (a.`id_attribute_group` IN (XX)) LEFT JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = XX) LEFT JOIN `ps_attribute_group` ag ON (ag.`id_attribute_group` = a.`id_attribute_group`) LEFT JOIN `ps_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 ps_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, 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 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_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`, XX AS spa_eligible_product FROM `ps_category_product` cp RIGHT JOIN `ps_category` c ON (c.`id_category` = cp.`id_category` AND c.nleft >= XX AND c.nright <= XX) LEFT JOIN `ps_product` p ON p.`id_product` = cp.`id_product` INNER JOIN ps_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = XX) LEFT JOIN `ps_category_lang` cl ON (product_shop.`id_category_default` = cl.`id_category` AND cl.`id_lang` = XX AND cl.id_shop = XX ) LEFT JOIN `ps_product_lang` pl ON (p.`id_product` = pl.`id_product` AND pl.`id_lang` = XX AND pl.id_shop = XX ) LEFT JOIN `ps_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 `ps_image_lang` il ON (image_shop.`id_image` = il.`id_image` AND il.`id_lang` = XX) LEFT JOIN `ps_manufacturer` m ON m.`id_manufacturer` = p.`id_manufacturer` LEFT JOIN `ps_product_attribute` pa ON pa.`id_product` = p.`id_product` LEFT JOIN `ps_product_attribute_combination` pac ON pac.`id_product_attribute` = pa.`id_product_attribute` LEFT JOIN `ps_attribute` a ON a.`id_attribute` = pac.`id_attribute` AND (a.`id_attribute_group` IN (XX)) LEFT JOIN `ps_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 ps_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 `orderprice` ASC LIMIT XX,XX
2 queries	SELECT XX FROM `ps_cart_rule` WHERE ((date_to >= "XX-XX-XX XX:XX:XX" AND date_to <= "XX-XX-XX XX:XX:XX") OR (date_from >= "XX-XX-XX XX:XX:XX" AND date_from <= "XX-XX-XX XX:XX:XX") OR (date_from < "XX-XX-XX XX:XX:XX" AND date_to > "XX-XX-XX XX:XX:XX")) AND `id_customer` IN (XX,XX) LIMIT XX
2 queries	SELECT fsr.* FROM `ps_fmm_stickers_rules` fsr LEFT JOIN `ps_fmm_stickers_rules_shop` fsrs ON (fsr.`fmm_stickers_rules_id` = fsrs.`fmm_stickers_rules_id`) WHERE fsr.`status` = XX AND fsr.`rule_type` = "bestseller" AND fsrs.`id_shop` = XX AND ( (fsr.`start_date` = 'XX-XX-XX XX:XX:XX' OR 'XX-XX-XX XX:XX:XX' >= fsr.`start_date`) AND (fsr.`expiry_date` = 'XX-XX-XX XX:XX:XX' OR 'XX-XX-XX XX:XX:XX' <= fsr.`expiry_date`) )
2 queries	SELECT fsr.* FROM `ps_fmm_stickers_rules` fsr LEFT JOIN `ps_fmm_stickers_rules_shop` fsrs ON (fsr.`fmm_stickers_rules_id` = fsrs.`fmm_stickers_rules_id`) WHERE fsr.`status` = XX AND fsr.`rule_type` = "onsale" AND fsrs.`id_shop` = XX AND ( (fsr.`start_date` = 'XX-XX-XX XX:XX:XX' OR 'XX-XX-XX XX:XX:XX' >= fsr.`start_date`) AND (fsr.`expiry_date` = 'XX-XX-XX XX:XX:XX' OR 'XX-XX-XX XX:XX:XX' <= fsr.`expiry_date`) )

150 cl Magnum

Vinothèque 1995 Blanc MAGNUM - 150 cl

Vinothèque 1999 Rosé MAGNUM - 150 cl

Vinothèque 1996 Rosé MAGNUM - 150 cl

Stopwatch SQL - 1197 queries

Doubles

Tables stress

ObjectModel instances

Included Files

Module	Time	Memory Usage
doofinder	6.646 ms	2.35 Mb
__construct	5.244 ms	2.02 Mb
hookModuleRoutes	0.005 ms	- Mb
hookDisplayHeader	1.397 ms	0.32 Mb
antispamprotector	5.511 ms	0.37 Mb
__construct	5.001 ms	0.36 Mb
hookActionDispatcher	0.504 ms	0.01 Mb
hookDisplayHeader	0.006 ms	- Mb
iqitthemeeditor	2.675 ms	0.48 Mb
__construct	2.558 ms	0.45 Mb
hookActionDispatcher	0.012 ms	- Mb
hookDisplayHeader	0.093 ms	0.02 Mb
hookProductSearchProvider	0.003 ms	- Mb
hookProductSearchProvider	0.001 ms	- Mb
hookProductSearchProvider	0.001 ms	- Mb
hookActionProductSearchAfter	0.007 ms	- Mb
ps_emailsubscription	30.384 ms	3.70 Mb
__construct	0.937 ms	0.22 Mb
hookActionFrontControllerSetMedia	0.516 ms	0.12 Mb
displayFooterBefore	28.931 ms	3.36 Mb
iqitproductvariants	0.267 ms	0.04 Mb
__construct	0.230 ms	0.04 Mb
hookActionFrontControllerSetMedia	0.037 ms	- Mb
productcomments	0.720 ms	0.18 Mb
__construct	0.673 ms	0.18 Mb
hookDisplayHeader	0.047 ms	- Mb
ps_shoppingcart	0.203 ms	0.05 Mb
__construct	0.185 ms	0.04 Mb
hookDisplayHeader	0.018 ms	- Mb
psxmarketingwithgoogle	1.330 ms	0.26 Mb
__construct	0.343 ms	0.06 Mb
hookDisplayHeader	0.987 ms	0.20 Mb
iqitcontactpage	0.731 ms	0.12 Mb
__construct	0.249 ms	0.05 Mb
hookDisplayHeader	0.002 ms	- Mb
displayFooter	0.480 ms	0.07 Mb
iqitcookielaw	0.652 ms	0.10 Mb
__construct	0.217 ms	0.05 Mb
hookDisplayHeader	0.056 ms	- Mb
displayBeforeBodyClosingTag	0.379 ms	0.05 Mb

#	Query	Time (ms)	Rows	Filesort	Group By	Location
482	(SELECT 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_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("2025-11-17 00:00:00", INTERVAL 30 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`, 1 AS spa_eligible_product FROM `ps_category_product` cp RIGHT JOIN `ps_category` c ON (c.`id_category` = cp.`id_category` AND c.nleft >= 53 AND c.nright <= 54) LEFT JOIN `ps_product` p ON p.`id_product` = cp.`id_product` INNER JOIN ps_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) LEFT JOIN `ps_category_lang` cl ON (product_shop.`id_category_default` = cl.`id_category` AND cl.`id_lang` = 5 AND cl.id_shop = 1 ) LEFT JOIN `ps_product_lang` pl ON (p.`id_product` = pl.`id_product` AND pl.`id_lang` = 5 AND pl.id_shop = 1 ) LEFT JOIN `ps_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 `ps_image_lang` il ON (image_shop.`id_image` = il.`id_image` AND il.`id_lang` = 5) LEFT JOIN `ps_manufacturer` m ON m.`id_manufacturer` = p.`id_manufacturer` LEFT JOIN `ps_product_attribute` pa ON pa.`id_product` = p.`id_product` LEFT JOIN `ps_product_attribute_combination` pac ON pac.`id_product_attribute` = pa.`id_product_attribute` JOIN `ps_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 `ps_attribute` a ON a.`id_attribute` = pac.`id_attribute` AND (a.`id_attribute_group` IN (6)) LEFT JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 5) LEFT JOIN `ps_attribute_group` ag ON (ag.`id_attribute_group` = a.`id_attribute_group`) LEFT JOIN `ps_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 ps_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` = 33 AND IF (stock.`quantity` > 0, 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 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_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("2025-11-17 00:00:00", INTERVAL 30 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`, 0 AS spa_eligible_product FROM `ps_category_product` cp RIGHT JOIN `ps_category` c ON (c.`id_category` = cp.`id_category` AND c.nleft >= 53 AND c.nright <= 54) LEFT JOIN `ps_product` p ON p.`id_product` = cp.`id_product` INNER JOIN ps_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) LEFT JOIN `ps_category_lang` cl ON (product_shop.`id_category_default` = cl.`id_category` AND cl.`id_lang` = 5 AND cl.id_shop = 1 ) LEFT JOIN `ps_product_lang` pl ON (p.`id_product` = pl.`id_product` AND pl.`id_lang` = 5 AND pl.id_shop = 1 ) LEFT JOIN `ps_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 `ps_image_lang` il ON (image_shop.`id_image` = il.`id_image` AND il.`id_lang` = 5) LEFT JOIN `ps_manufacturer` m ON m.`id_manufacturer` = p.`id_manufacturer` LEFT JOIN `ps_product_attribute` pa ON pa.`id_product` = p.`id_product` LEFT JOIN `ps_product_attribute_combination` pac ON pac.`id_product_attribute` = pa.`id_product_attribute` LEFT JOIN `ps_attribute` a ON a.`id_attribute` = pac.`id_attribute` AND (a.`id_attribute_group` IN (6)) LEFT JOIN `ps_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 ps_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` = 33 AND product_shop.`visibility` IN ("both", "catalog") GROUP BY cp.id_product HAVING (COUNT(a.`id_attribute`) = 0) ) ORDER BY `orderprice` ASC LIMIT 0,51	9.565 ms	1			/modules/pm_productsbyattributes/pm_productsbyattributes.php:1010 /modules/pm_productsbyattributes/src/Pm_ProductsByAttributesCategoryProvider.php:75 (getCategoryProducts) /modules/pm_productsbyattributes/src/Pm_ProductsByAttributesCategoryProvider.php:82 (getProductsOrCount) /modules/pm_productsbyattributes/src/Pm_ProductsByAttributesProductSearchProvider.php:146 (runQuery) /classes/controller/ProductListingFrontController.php:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
2	SELECT SQL_NO_CACHE c.`name`, cl.`id_lang`, IF(cl.`id_lang` IS NULL, c.`value`, cl.`value`) AS value, c.id_shop_group, c.id_shop FROM `ps_configuration` c LEFT JOIN `ps_configuration_lang` cl ON (c.`id_configuration` = cl.`id_configuration`)	5.180 ms	5316			/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)
76	(SELECT 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_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("2025-11-17 00:00:00", INTERVAL 30 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`, 1 AS spa_eligible_product FROM `ps_category_product` cp RIGHT JOIN `ps_category` c ON (c.`id_category` = cp.`id_category` AND c.nleft >= 53 AND c.nright <= 54) LEFT JOIN `ps_product` p ON p.`id_product` = cp.`id_product` INNER JOIN ps_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) LEFT JOIN `ps_category_lang` cl ON (product_shop.`id_category_default` = cl.`id_category` AND cl.`id_lang` = 5 AND cl.id_shop = 1 ) LEFT JOIN `ps_product_lang` pl ON (p.`id_product` = pl.`id_product` AND pl.`id_lang` = 5 AND pl.id_shop = 1 ) LEFT JOIN `ps_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 `ps_image_lang` il ON (image_shop.`id_image` = il.`id_image` AND il.`id_lang` = 5) LEFT JOIN `ps_manufacturer` m ON m.`id_manufacturer` = p.`id_manufacturer` LEFT JOIN `ps_product_attribute` pa ON pa.`id_product` = p.`id_product` LEFT JOIN `ps_product_attribute_combination` pac ON pac.`id_product_attribute` = pa.`id_product_attribute` JOIN `ps_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 `ps_attribute` a ON a.`id_attribute` = pac.`id_attribute` AND (a.`id_attribute_group` IN (6)) LEFT JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 5) LEFT JOIN `ps_attribute_group` ag ON (ag.`id_attribute_group` = a.`id_attribute_group`) LEFT JOIN `ps_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 ps_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` = 33 AND IF (stock.`quantity` > 0, 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 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_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("2025-11-17 00:00:00", INTERVAL 30 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`, 0 AS spa_eligible_product FROM `ps_category_product` cp RIGHT JOIN `ps_category` c ON (c.`id_category` = cp.`id_category` AND c.nleft >= 53 AND c.nright <= 54) LEFT JOIN `ps_product` p ON p.`id_product` = cp.`id_product` INNER JOIN ps_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) LEFT JOIN `ps_category_lang` cl ON (product_shop.`id_category_default` = cl.`id_category` AND cl.`id_lang` = 5 AND cl.id_shop = 1 ) LEFT JOIN `ps_product_lang` pl ON (p.`id_product` = pl.`id_product` AND pl.`id_lang` = 5 AND pl.id_shop = 1 ) LEFT JOIN `ps_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 `ps_image_lang` il ON (image_shop.`id_image` = il.`id_image` AND il.`id_lang` = 5) LEFT JOIN `ps_manufacturer` m ON m.`id_manufacturer` = p.`id_manufacturer` LEFT JOIN `ps_product_attribute` pa ON pa.`id_product` = p.`id_product` LEFT JOIN `ps_product_attribute_combination` pac ON pac.`id_product_attribute` = pa.`id_product_attribute` LEFT JOIN `ps_attribute` a ON a.`id_attribute` = pac.`id_attribute` AND (a.`id_attribute_group` IN (6)) LEFT JOIN `ps_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 ps_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` = 33 AND product_shop.`visibility` IN ("both", "catalog") GROUP BY cp.id_product HAVING (COUNT(a.`id_attribute`) = 0) ) ORDER BY `orderprice` ASC LIMIT 0,24	4.453 ms	1			/modules/pm_productsbyattributes/pm_productsbyattributes.php:1010 /modules/pm_productsbyattributes/src/Pm_ProductsByAttributesCategoryProvider.php:75 (getCategoryProducts) /modules/pm_productsbyattributes/src/Pm_ProductsByAttributesCategoryProvider.php:82 (getProductsOrCount) /modules/pm_productsbyattributes/src/Pm_ProductsByAttributesProductSearchProvider.php:143 (runQuery) /classes/controller/ProductListingFrontController.php:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
481	SELECT SQL_NO_CACHE COUNT(total) as total FROM ( ( SELECT COUNT(p.`id_product`) as total FROM `ps_category_product` cp RIGHT JOIN `ps_category` c ON (c.`id_category` = cp.`id_category` AND c.nleft >= 53 AND c.nright <= 54) LEFT JOIN `ps_product` p ON p.`id_product` = cp.`id_product` INNER JOIN ps_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) LEFT JOIN `ps_product_attribute` pa ON pa.`id_product` = p.`id_product` LEFT JOIN `ps_product_attribute_combination` pac ON pac.`id_product_attribute` = pa.`id_product_attribute` JOIN `ps_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 ps_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 `ps_attribute` a ON a.`id_attribute` = pac.`id_attribute` LEFT JOIN `ps_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, 1, IF (stock.`out_of_stock` = 2, 0 = 1, stock.`out_of_stock` = 1)) AND product_shop.`active` = 1 AND cp.`id_category` = 33 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 `ps_category_product` cp RIGHT JOIN `ps_category` c ON (c.`id_category` = cp.`id_category` AND c.nleft >= 53 AND c.nright <= 54) LEFT JOIN `ps_product` p ON p.`id_product` = cp.`id_product` INNER JOIN ps_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) LEFT JOIN `ps_product_attribute` pa ON pa.`id_product` = p.`id_product` AND pa.`default_on` = 1 LEFT JOIN `ps_product_attribute_combination` pac ON pac.`id_product_attribute` = pa.`id_product_attribute` LEFT JOIN `ps_attribute` a ON a.`id_attribute` = pac.`id_attribute` AND (a.`id_attribute_group` IN (6)) LEFT JOIN `ps_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 ps_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` = 33 AND product_shop.`visibility` IN ("both", "catalog") GROUP BY cp.`id_product` HAVING (COUNT(a.`id_attribute`) = 0) ) ) total_query LIMIT 1	3.004 ms	29412			/modules/pm_productsbyattributes/pm_productsbyattributes.php:850 /modules/pm_productsbyattributes/src/Pm_ProductsByAttributesCategoryProvider.php:75 (getCategoryProducts) /modules/pm_productsbyattributes/src/Pm_ProductsByAttributesCategoryProvider.php:83 (getProductsOrCount) /modules/pm_productsbyattributes/src/Pm_ProductsByAttributesProductSearchProvider.php:143 (runQuery) /classes/controller/ProductListingFrontController.php:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
16	SELECT SQL_NO_CACHE h.`name` as hook, m.`id_module`, h.`id_hook`, m.`name` as module FROM `ps_module` m INNER JOIN ps_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 `ps_hook_module` `hm` ON hm.`id_module` = m.`id_module` INNER JOIN `ps_hook` `h` ON hm.`id_hook` = h.`id_hook` LEFT JOIN `ps_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.333 ms	198	Yes	Yes	/classes/Hook.php:1289 /classes/Hook.php:738 (getAllHookRegistrations) /classes/Hook.php:848 (getHookModuleExecList) /classes/Dispatcher.php:606 (exec) /classes/Dispatcher.php:243 (loadRoutes) /classes/Dispatcher.php:201 (__construct) /index.php:28 (getInstance)
85	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 `ps_hook_module` hm STRAIGHT_JOIN `ps_hook` h ON (h.id_hook = hm.id_hook AND hm.id_shop = 1) STRAIGHT_JOIN `ps_module` as m ON (m.id_module = hm.id_module) ORDER BY hm.position	1.731 ms	585			/classes/Hook.php:459 /classes/Hook.php:496 (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:5692 (getPriceStatic) /override/classes/Product.php:20 (getProductProperties) /classes/Product.php:5990 (getProductProperties) /modules/pm_productsbyattributes/pm_productsbyattributes.php:1038 (getProductsProperties) /modules/pm_productsbyattributes/src/Pm_ProductsByAttributesCategoryProvider.php:75 (getCategoryProducts) /modules/pm_productsbyattributes/src/Pm_ProductsByAttributesCategoryProvider.php:82 (getProductsOrCount) /modules/pm_productsbyattributes/src/Pm_ProductsByAttributesProductSearchProvider.php:143 (runQuery) /classes/controller/ProductListingFrontController.php:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
879	SELECT SQL_NO_CACHE COUNT(total) as total FROM ( ( SELECT COUNT(p.`id_product`) as total FROM `ps_category_product` cp RIGHT JOIN `ps_category` c ON (c.`id_category` = cp.`id_category` AND c.nleft >= 53 AND c.nright <= 54) LEFT JOIN `ps_product` p ON p.`id_product` = cp.`id_product` INNER JOIN ps_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) LEFT JOIN `ps_product_attribute` pa ON pa.`id_product` = p.`id_product` LEFT JOIN `ps_product_attribute_combination` pac ON pac.`id_product_attribute` = pa.`id_product_attribute` JOIN `ps_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 ps_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 `ps_attribute` a ON a.`id_attribute` = pac.`id_attribute` LEFT JOIN `ps_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, 1, IF (stock.`out_of_stock` = 2, 0 = 1, stock.`out_of_stock` = 1)) AND product_shop.`active` = 1 AND cp.`id_category` = 33 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 `ps_category_product` cp RIGHT JOIN `ps_category` c ON (c.`id_category` = cp.`id_category` AND c.nleft >= 53 AND c.nright <= 54) LEFT JOIN `ps_product` p ON p.`id_product` = cp.`id_product` INNER JOIN ps_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) LEFT JOIN `ps_product_attribute` pa ON pa.`id_product` = p.`id_product` AND pa.`default_on` = 1 LEFT JOIN `ps_product_attribute_combination` pac ON pac.`id_product_attribute` = pa.`id_product_attribute` LEFT JOIN `ps_attribute` a ON a.`id_attribute` = pac.`id_attribute` AND (a.`id_attribute_group` IN (6)) LEFT JOIN `ps_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 ps_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` = 33 AND product_shop.`visibility` IN ("both", "catalog") GROUP BY cp.`id_product` HAVING (COUNT(a.`id_attribute`) = 0) ) ) total_query LIMIT 1	1.702 ms	29412			/modules/pm_productsbyattributes/pm_productsbyattributes.php:850 /modules/pm_productsbyattributes/src/Pm_ProductsByAttributesCategoryProvider.php:75 (getCategoryProducts) /modules/pm_productsbyattributes/src/Pm_ProductsByAttributesCategoryProvider.php:83 (getProductsOrCount) /modules/pm_productsbyattributes/src/Pm_ProductsByAttributesProductSearchProvider.php:146 (runQuery) /classes/controller/ProductListingFrontController.php:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
84	SELECT SQL_NO_CACHE `id_hook`, `name` FROM `ps_hook` UNION SELECT `id_hook`, ha.`alias` as name FROM `ps_hook_alias` ha INNER JOIN `ps_hook` h ON ha.name = h.name	1.410 ms	0			/classes/Hook.php:1348 /classes/Hook.php:228 (getAllHookIds) /classes/tax/TaxManagerFactory.php:67 (getIdByName) /classes/tax/TaxManagerFactory.php:46 (execHookTaxManagerFactory) /classes/Product.php:3925 (getManager) /classes/Product.php:3717 (priceCalculation) /classes/Product.php:5692 (getPriceStatic) /override/classes/Product.php:20 (getProductProperties) /classes/Product.php:5990 (getProductProperties) /modules/pm_productsbyattributes/pm_productsbyattributes.php:1038 (getProductsProperties) /modules/pm_productsbyattributes/src/Pm_ProductsByAttributesCategoryProvider.php:75 (getCategoryProducts) /modules/pm_productsbyattributes/src/Pm_ProductsByAttributesCategoryProvider.php:82 (getProductsOrCount) /modules/pm_productsbyattributes/src/Pm_ProductsByAttributesProductSearchProvider.php:143 (runQuery) /classes/controller/ProductListingFrontController.php:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
880	SELECT SQL_NO_CACHE COUNT(total) as total FROM ( ( SELECT COUNT(p.`id_product`) as total FROM `ps_category_product` cp RIGHT JOIN `ps_category` c ON (c.`id_category` = cp.`id_category` AND c.nleft >= 53 AND c.nright <= 54) LEFT JOIN `ps_product` p ON p.`id_product` = cp.`id_product` INNER JOIN ps_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) LEFT JOIN `ps_product_attribute` pa ON pa.`id_product` = p.`id_product` LEFT JOIN `ps_product_attribute_combination` pac ON pac.`id_product_attribute` = pa.`id_product_attribute` JOIN `ps_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 ps_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 `ps_attribute` a ON a.`id_attribute` = pac.`id_attribute` LEFT JOIN `ps_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, 1, IF (stock.`out_of_stock` = 2, 0 = 1, stock.`out_of_stock` = 1)) AND product_shop.`active` = 1 AND cp.`id_category` = 33 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 `ps_category_product` cp RIGHT JOIN `ps_category` c ON (c.`id_category` = cp.`id_category` AND c.nleft >= 53 AND c.nright <= 54) LEFT JOIN `ps_product` p ON p.`id_product` = cp.`id_product` INNER JOIN ps_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) LEFT JOIN `ps_product_attribute` pa ON pa.`id_product` = p.`id_product` AND pa.`default_on` = 1 LEFT JOIN `ps_product_attribute_combination` pac ON pac.`id_product_attribute` = pa.`id_product_attribute` LEFT JOIN `ps_attribute` a ON a.`id_attribute` = pac.`id_attribute` AND (a.`id_attribute_group` IN (6)) LEFT JOIN `ps_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 ps_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` = 33 AND product_shop.`visibility` IN ("both", "catalog") GROUP BY cp.`id_product` HAVING (COUNT(a.`id_attribute`) = 0) ) ) total_query LIMIT 1	1.355 ms	29412			/modules/pm_productsbyattributes/pm_productsbyattributes.php:850 /modules/pm_productsbyattributes/src/Pm_ProductsByAttributesCategoryProvider.php:75 (getCategoryProducts) /modules/pm_productsbyattributes/src/Pm_ProductsByAttributesCategoryProvider.php:83 (getProductsOrCount) /modules/pm_productsbyattributes/src/Pm_ProductsByAttributesProductSearchProvider.php:153 (runQuery) /classes/controller/ProductListingFrontController.php:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
21	SELECT SQL_NO_CACHE m.page, ml.url_rewrite, ml.id_lang FROM `ps_meta` m LEFT JOIN `ps_meta_lang` ml ON (m.id_meta = ml.id_meta AND ml.id_shop = 1 ) ORDER BY LENGTH(ml.url_rewrite) DESC	0.799 ms	264	Yes		/classes/Dispatcher.php:654 /classes/Dispatcher.php:243 (loadRoutes) /classes/Dispatcher.php:201 (__construct) /index.php:28 (getInstance)
462	SELECT SQL_NO_CACHE p., product_shop., pl.*, image_shop.`id_image` id_image, il.`legend`, cl.`name` AS category_default, a.quantity AS pack_quantity, product_shop.`id_category_default`, a.id_product_pack, a.id_product_attribute_item FROM `ps_pack` a LEFT JOIN `ps_product` p ON p.id_product = a.id_product_item LEFT JOIN `ps_product_lang` pl ON p.id_product = pl.id_product AND pl.`id_lang` = 5 AND pl.id_shop = 1 LEFT JOIN `ps_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 `ps_image_lang` il ON (image_shop.`id_image` = il.`id_image` AND il.`id_lang` = 5) INNER JOIN ps_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) LEFT JOIN `ps_category_lang` cl ON product_shop.`id_category_default` = cl.`id_category` AND cl.`id_lang` = 5 AND cl.id_shop = 1 WHERE product_shop.`id_shop` = 1 AND a.`id_product_pack` = 1306 GROUP BY a.`id_product_item`, a.`id_product_attribute_item`	0.764 ms	2		Yes	/classes/Pack.php:385 /classes/Product.php:5842 (getItemTable) /override/classes/Product.php:20 (getProductProperties) /classes/Product.php:5990 (getProductProperties) /modules/pm_productsbyattributes/pm_productsbyattributes.php:1038 (getProductsProperties) /modules/pm_productsbyattributes/src/Pm_ProductsByAttributesCategoryProvider.php:75 (getCategoryProducts) /modules/pm_productsbyattributes/src/Pm_ProductsByAttributesCategoryProvider.php:82 (getProductsOrCount) /modules/pm_productsbyattributes/src/Pm_ProductsByAttributesProductSearchProvider.php:143 (runQuery) /classes/controller/ProductListingFrontController.php:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
15	SELECT SQL_NO_CACHE lower(name) as name FROM `ps_hook` h WHERE (h.active = 1)	0.720 ms	1163			/classes/Hook.php:1388 /classes/Hook.php:817 (getHookStatusByName) /classes/Dispatcher.php:606 (exec) /classes/Dispatcher.php:243 (loadRoutes) /classes/Dispatcher.php:201 (__construct) /index.php:28 (getInstance)
881	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 `ps_product_attribute` pa INNER JOIN ps_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) LEFT JOIN `ps_product_attribute_combination` pac ON pac.`id_product_attribute` = pa.`id_product_attribute` LEFT JOIN `ps_attribute` a ON a.`id_attribute` = pac.`id_attribute` LEFT JOIN `ps_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group` LEFT JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 5) JOIN `ps_product` p ON (p.`id_product` = pa.`id_product`) LEFT JOIN ps_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` = 1828 AND IF (stock.`quantity` > 0, 1, IF (stock.`out_of_stock` = 2, 0 = 1, stock.`out_of_stock` = 1)) GROUP BY pa.`id_product_attribute` ORDER BY SUM(ag.`position`), SUM(a.`position`), pac.`id_product_attribute`	0.632 ms	1	Yes		/modules/pm_productsbyattributes/pm_productsbyattributes.php:1288 /modules/pm_productsbyattributes/pm_productsbyattributes.php:1323 (getAttributeCombinationsById) /modules/pm_productsbyattributes/src/Pm_ProductsByAttributesProductSearchProvider.php:324 (getFullProductName) /classes/controller/ProductListingFrontController.php:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
18	SELECT SQL_NO_CACHE `id_hook`, `name` FROM `ps_hook`	0.611 ms	1163			/classes/Hook.php:1348 /classes/Hook.php:228 (getAllHookIds) /classes/Hook.php:857 (getIdByName) /classes/Dispatcher.php:606 (exec) /classes/Dispatcher.php:243 (loadRoutes) /classes/Dispatcher.php:201 (__construct) /index.php:28 (getInstance)
896	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 `ps_product_attribute` pa INNER JOIN ps_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) LEFT JOIN `ps_product_attribute_combination` pac ON pac.`id_product_attribute` = pa.`id_product_attribute` LEFT JOIN `ps_attribute` a ON a.`id_attribute` = pac.`id_attribute` LEFT JOIN `ps_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group` LEFT JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 5) JOIN `ps_product` p ON (p.`id_product` = pa.`id_product`) LEFT JOIN ps_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` = 1140 AND IF (stock.`quantity` > 0, 1, IF (stock.`out_of_stock` = 2, 0 = 1, stock.`out_of_stock` = 1)) GROUP BY pa.`id_product_attribute` ORDER BY SUM(ag.`position`), SUM(a.`position`), pac.`id_product_attribute`	0.605 ms	1	Yes		/modules/pm_productsbyattributes/pm_productsbyattributes.php:1288 /modules/pm_productsbyattributes/pm_productsbyattributes.php:1323 (getAttributeCombinationsById) /modules/pm_productsbyattributes/src/Pm_ProductsByAttributesProductSearchProvider.php:324 (getFullProductName) /classes/controller/ProductListingFrontController.php:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
882	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 `ps_product_attribute` pa INNER JOIN ps_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) LEFT JOIN `ps_product_attribute_combination` pac ON pac.`id_product_attribute` = pa.`id_product_attribute` LEFT JOIN `ps_attribute` a ON a.`id_attribute` = pac.`id_attribute` LEFT JOIN `ps_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group` LEFT JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 5) JOIN `ps_product` p ON (p.`id_product` = pa.`id_product`) LEFT JOIN ps_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` = 1179 AND IF (stock.`quantity` > 0, 1, IF (stock.`out_of_stock` = 2, 0 = 1, stock.`out_of_stock` = 1)) GROUP BY pa.`id_product_attribute` ORDER BY SUM(ag.`position`), SUM(a.`position`), pac.`id_product_attribute`	0.601 ms	1	Yes		/modules/pm_productsbyattributes/pm_productsbyattributes.php:1288 /modules/pm_productsbyattributes/pm_productsbyattributes.php:1323 (getAttributeCombinationsById) /modules/pm_productsbyattributes/src/Pm_ProductsByAttributesProductSearchProvider.php:324 (getFullProductName) /classes/controller/ProductListingFrontController.php:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
883	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 `ps_product_attribute` pa INNER JOIN ps_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) LEFT JOIN `ps_product_attribute_combination` pac ON pac.`id_product_attribute` = pa.`id_product_attribute` LEFT JOIN `ps_attribute` a ON a.`id_attribute` = pac.`id_attribute` LEFT JOIN `ps_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group` LEFT JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 5) JOIN `ps_product` p ON (p.`id_product` = pa.`id_product`) LEFT JOIN ps_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` = 1185 AND IF (stock.`quantity` > 0, 1, IF (stock.`out_of_stock` = 2, 0 = 1, stock.`out_of_stock` = 1)) GROUP BY pa.`id_product_attribute` ORDER BY SUM(ag.`position`), SUM(a.`position`), pac.`id_product_attribute`	0.593 ms	1	Yes		/modules/pm_productsbyattributes/pm_productsbyattributes.php:1288 /modules/pm_productsbyattributes/pm_productsbyattributes.php:1323 (getAttributeCombinationsById) /modules/pm_productsbyattributes/src/Pm_ProductsByAttributesProductSearchProvider.php:324 (getFullProductName) /classes/controller/ProductListingFrontController.php:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
900	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 `ps_product_attribute` pa INNER JOIN ps_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) LEFT JOIN `ps_product_attribute_combination` pac ON pac.`id_product_attribute` = pa.`id_product_attribute` LEFT JOIN `ps_attribute` a ON a.`id_attribute` = pac.`id_attribute` LEFT JOIN `ps_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group` LEFT JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 5) JOIN `ps_product` p ON (p.`id_product` = pa.`id_product`) LEFT JOIN ps_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` = 1191 AND IF (stock.`quantity` > 0, 1, IF (stock.`out_of_stock` = 2, 0 = 1, stock.`out_of_stock` = 1)) GROUP BY pa.`id_product_attribute` ORDER BY SUM(ag.`position`), SUM(a.`position`), pac.`id_product_attribute`	0.584 ms	1	Yes		/modules/pm_productsbyattributes/pm_productsbyattributes.php:1288 /modules/pm_productsbyattributes/pm_productsbyattributes.php:1323 (getAttributeCombinationsById) /modules/pm_productsbyattributes/src/Pm_ProductsByAttributesProductSearchProvider.php:324 (getFullProductName) /classes/controller/ProductListingFrontController.php:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
931	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 `ps_product_attribute` pa INNER JOIN ps_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) LEFT JOIN `ps_product_attribute_combination` pac ON pac.`id_product_attribute` = pa.`id_product_attribute` LEFT JOIN `ps_attribute` a ON a.`id_attribute` = pac.`id_attribute` LEFT JOIN `ps_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group` LEFT JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 5) JOIN `ps_product` p ON (p.`id_product` = pa.`id_product`) LEFT JOIN ps_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` = 1018 AND IF (stock.`quantity` > 0, 1, IF (stock.`out_of_stock` = 2, 0 = 1, stock.`out_of_stock` = 1)) GROUP BY pa.`id_product_attribute` ORDER BY SUM(ag.`position`), SUM(a.`position`), pac.`id_product_attribute`	0.584 ms	1	Yes		/modules/pm_productsbyattributes/pm_productsbyattributes.php:1288 /modules/pm_productsbyattributes/pm_productsbyattributes.php:1323 (getAttributeCombinationsById) /modules/pm_productsbyattributes/src/Pm_ProductsByAttributesProductSearchProvider.php:324 (getFullProductName) /classes/controller/ProductListingFrontController.php:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
888	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 `ps_product_attribute` pa INNER JOIN ps_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) LEFT JOIN `ps_product_attribute_combination` pac ON pac.`id_product_attribute` = pa.`id_product_attribute` LEFT JOIN `ps_attribute` a ON a.`id_attribute` = pac.`id_attribute` LEFT JOIN `ps_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group` LEFT JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 5) JOIN `ps_product` p ON (p.`id_product` = pa.`id_product`) LEFT JOIN ps_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` = 1564 AND IF (stock.`quantity` > 0, 1, IF (stock.`out_of_stock` = 2, 0 = 1, stock.`out_of_stock` = 1)) GROUP BY pa.`id_product_attribute` ORDER BY SUM(ag.`position`), SUM(a.`position`), pac.`id_product_attribute`	0.581 ms	1	Yes		/modules/pm_productsbyattributes/pm_productsbyattributes.php:1288 /modules/pm_productsbyattributes/pm_productsbyattributes.php:1323 (getAttributeCombinationsById) /modules/pm_productsbyattributes/src/Pm_ProductsByAttributesProductSearchProvider.php:324 (getFullProductName) /classes/controller/ProductListingFrontController.php:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
1183	SELECT SQL_NO_CACHE c., cl. FROM `ps_category` c INNER JOIN ps_category_shop category_shop ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1) LEFT JOIN `ps_category_lang` cl ON c.`id_category` = cl.`id_category` AND cl.id_shop = 1 LEFT JOIN `ps_category_group` cg ON c.`id_category` = cg.`id_category` RIGHT JOIN `ps_category` c2 ON c2.`id_category` = 33 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright` WHERE 1 AND c.`level_depth` <= 8 AND `id_lang` = 5 AND c.`active` = 1 AND cg.`id_group` IN (1) GROUP BY c.`id_category` ORDER BY c.`level_depth` ASC, category_shop.`position` ASC	0.571 ms	15	Yes	Yes	/classes/Category.php:799 /modules/ps_categorytree/ps_categorytree.php:141 (getNestedCategories) /modules/ps_categorytree/ps_categorytree.php:298 (getCategories) /modules/ps_categorytree/ps_categorytree.php:266 (getWidgetVariables) /classes/Hook.php:1094 (renderWidget) /tools/profiling/Hook.php:64 (coreRenderWidget) /classes/Hook.php:1025 (coreRenderWidget) /config/smarty.config.inc.php:201 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/dev/smarty/compile/warehouselayouts_layout_left_column_tpl/36/f2/c0/36f2c0d8741ecf0e9c4faf862198e4df4c88ef90_2.file.layout-both-columns.tpl.php:419 (__call) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/warehouselayouts_layout_left_column_tpl/36/f2/c0/36f2c0d8741ecf0e9c4faf862198e4df4c88ef90_2.file.layout-both-columns.tpl.php:115 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_691b9d274f39a5_75695032) /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/dev/smarty/compile/warehouselayouts_layout_left_column_tpl/5e/c7/c1/5ec7c172abdeb4164092d41f0ee3b65434216b82_2.file.layout-left-column.tpl.php:38 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_691b9d274e5564_74867785) /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/dev/smarty/compile/warehouselayouts_layout_left_column_tpl/2a/f2/e4/2af2e422e5af552125dd52cd4895a7fff3e94cbb_2.file.product-list.tpl.php:43 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_691b9d274e11c7_64749290) /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/dev/smarty/compile/warehouselayouts_layout_left_column_tpl/46/0b/c5/460bc51679008345eed933ac9d48f4c8ec634095_2.file.category.tpl.php:72 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_691b9eaee47a67_53009435) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/Smarty/SmartyDev.php:40 (fetch) /classes/controller/FrontController.php:771 (fetch) /classes/controller/FrontController.php:753 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
902	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 `ps_product_attribute` pa INNER JOIN ps_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) LEFT JOIN `ps_product_attribute_combination` pac ON pac.`id_product_attribute` = pa.`id_product_attribute` LEFT JOIN `ps_attribute` a ON a.`id_attribute` = pac.`id_attribute` LEFT JOIN `ps_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group` LEFT JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 5) JOIN `ps_product` p ON (p.`id_product` = pa.`id_product`) LEFT JOIN ps_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` = 804 AND IF (stock.`quantity` > 0, 1, IF (stock.`out_of_stock` = 2, 0 = 1, stock.`out_of_stock` = 1)) GROUP BY pa.`id_product_attribute` ORDER BY SUM(ag.`position`), SUM(a.`position`), pac.`id_product_attribute`	0.570 ms	1	Yes		/modules/pm_productsbyattributes/pm_productsbyattributes.php:1288 /modules/pm_productsbyattributes/pm_productsbyattributes.php:1323 (getAttributeCombinationsById) /modules/pm_productsbyattributes/src/Pm_ProductsByAttributesProductSearchProvider.php:324 (getFullProductName) /classes/controller/ProductListingFrontController.php:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
903	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 `ps_product_attribute` pa INNER JOIN ps_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) LEFT JOIN `ps_product_attribute_combination` pac ON pac.`id_product_attribute` = pa.`id_product_attribute` LEFT JOIN `ps_attribute` a ON a.`id_attribute` = pac.`id_attribute` LEFT JOIN `ps_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group` LEFT JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 5) JOIN `ps_product` p ON (p.`id_product` = pa.`id_product`) LEFT JOIN ps_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` = 1306 AND IF (stock.`quantity` > 0, 1, IF (stock.`out_of_stock` = 2, 0 = 1, stock.`out_of_stock` = 1)) GROUP BY pa.`id_product_attribute` ORDER BY SUM(ag.`position`), SUM(a.`position`), pac.`id_product_attribute`	0.569 ms	1	Yes		/modules/pm_productsbyattributes/pm_productsbyattributes.php:1288 /modules/pm_productsbyattributes/pm_productsbyattributes.php:1323 (getAttributeCombinationsById) /modules/pm_productsbyattributes/src/Pm_ProductsByAttributesProductSearchProvider.php:324 (getFullProductName) /classes/controller/ProductListingFrontController.php:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
899	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 `ps_product_attribute` pa INNER JOIN ps_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) LEFT JOIN `ps_product_attribute_combination` pac ON pac.`id_product_attribute` = pa.`id_product_attribute` LEFT JOIN `ps_attribute` a ON a.`id_attribute` = pac.`id_attribute` LEFT JOIN `ps_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group` LEFT JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 5) JOIN `ps_product` p ON (p.`id_product` = pa.`id_product`) LEFT JOIN ps_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` = 1132 AND IF (stock.`quantity` > 0, 1, IF (stock.`out_of_stock` = 2, 0 = 1, stock.`out_of_stock` = 1)) GROUP BY pa.`id_product_attribute` ORDER BY SUM(ag.`position`), SUM(a.`position`), pac.`id_product_attribute`	0.569 ms	1	Yes		/modules/pm_productsbyattributes/pm_productsbyattributes.php:1288 /modules/pm_productsbyattributes/pm_productsbyattributes.php:1323 (getAttributeCombinationsById) /modules/pm_productsbyattributes/src/Pm_ProductsByAttributesProductSearchProvider.php:324 (getFullProductName) /classes/controller/ProductListingFrontController.php:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
886	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 `ps_product_attribute` pa INNER JOIN ps_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) LEFT JOIN `ps_product_attribute_combination` pac ON pac.`id_product_attribute` = pa.`id_product_attribute` LEFT JOIN `ps_attribute` a ON a.`id_attribute` = pac.`id_attribute` LEFT JOIN `ps_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group` LEFT JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 5) JOIN `ps_product` p ON (p.`id_product` = pa.`id_product`) LEFT JOIN ps_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` = 1115 AND IF (stock.`quantity` > 0, 1, IF (stock.`out_of_stock` = 2, 0 = 1, stock.`out_of_stock` = 1)) GROUP BY pa.`id_product_attribute` ORDER BY SUM(ag.`position`), SUM(a.`position`), pac.`id_product_attribute`	0.568 ms	1	Yes		/modules/pm_productsbyattributes/pm_productsbyattributes.php:1288 /modules/pm_productsbyattributes/pm_productsbyattributes.php:1323 (getAttributeCombinationsById) /modules/pm_productsbyattributes/src/Pm_ProductsByAttributesProductSearchProvider.php:324 (getFullProductName) /classes/controller/ProductListingFrontController.php:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
884	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 `ps_product_attribute` pa INNER JOIN ps_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) LEFT JOIN `ps_product_attribute_combination` pac ON pac.`id_product_attribute` = pa.`id_product_attribute` LEFT JOIN `ps_attribute` a ON a.`id_attribute` = pac.`id_attribute` LEFT JOIN `ps_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group` LEFT JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 5) JOIN `ps_product` p ON (p.`id_product` = pa.`id_product`) LEFT JOIN ps_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` = 1813 AND IF (stock.`quantity` > 0, 1, IF (stock.`out_of_stock` = 2, 0 = 1, stock.`out_of_stock` = 1)) GROUP BY pa.`id_product_attribute` ORDER BY SUM(ag.`position`), SUM(a.`position`), pac.`id_product_attribute`	0.567 ms	1	Yes		/modules/pm_productsbyattributes/pm_productsbyattributes.php:1288 /modules/pm_productsbyattributes/pm_productsbyattributes.php:1323 (getAttributeCombinationsById) /modules/pm_productsbyattributes/src/Pm_ProductsByAttributesProductSearchProvider.php:324 (getFullProductName) /classes/controller/ProductListingFrontController.php:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
897	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 `ps_product_attribute` pa INNER JOIN ps_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) LEFT JOIN `ps_product_attribute_combination` pac ON pac.`id_product_attribute` = pa.`id_product_attribute` LEFT JOIN `ps_attribute` a ON a.`id_attribute` = pac.`id_attribute` LEFT JOIN `ps_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group` LEFT JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 5) JOIN `ps_product` p ON (p.`id_product` = pa.`id_product`) LEFT JOIN ps_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` = 899 AND IF (stock.`quantity` > 0, 1, IF (stock.`out_of_stock` = 2, 0 = 1, stock.`out_of_stock` = 1)) GROUP BY pa.`id_product_attribute` ORDER BY SUM(ag.`position`), SUM(a.`position`), pac.`id_product_attribute`	0.567 ms	1	Yes		/modules/pm_productsbyattributes/pm_productsbyattributes.php:1288 /modules/pm_productsbyattributes/pm_productsbyattributes.php:1323 (getAttributeCombinationsById) /modules/pm_productsbyattributes/src/Pm_ProductsByAttributesProductSearchProvider.php:324 (getFullProductName) /classes/controller/ProductListingFrontController.php:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
904	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 `ps_product_attribute` pa INNER JOIN ps_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) LEFT JOIN `ps_product_attribute_combination` pac ON pac.`id_product_attribute` = pa.`id_product_attribute` LEFT JOIN `ps_attribute` a ON a.`id_attribute` = pac.`id_attribute` LEFT JOIN `ps_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group` LEFT JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 5) JOIN `ps_product` p ON (p.`id_product` = pa.`id_product`) LEFT JOIN ps_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` = 1565 AND IF (stock.`quantity` > 0, 1, IF (stock.`out_of_stock` = 2, 0 = 1, stock.`out_of_stock` = 1)) GROUP BY pa.`id_product_attribute` ORDER BY SUM(ag.`position`), SUM(a.`position`), pac.`id_product_attribute`	0.567 ms	1	Yes		/modules/pm_productsbyattributes/pm_productsbyattributes.php:1288 /modules/pm_productsbyattributes/pm_productsbyattributes.php:1323 (getAttributeCombinationsById) /modules/pm_productsbyattributes/src/Pm_ProductsByAttributesProductSearchProvider.php:324 (getFullProductName) /classes/controller/ProductListingFrontController.php:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
921	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 `ps_product_attribute` pa INNER JOIN ps_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) LEFT JOIN `ps_product_attribute_combination` pac ON pac.`id_product_attribute` = pa.`id_product_attribute` LEFT JOIN `ps_attribute` a ON a.`id_attribute` = pac.`id_attribute` LEFT JOIN `ps_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group` LEFT JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 5) JOIN `ps_product` p ON (p.`id_product` = pa.`id_product`) LEFT JOIN ps_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` = 1270 AND IF (stock.`quantity` > 0, 1, IF (stock.`out_of_stock` = 2, 0 = 1, stock.`out_of_stock` = 1)) GROUP BY pa.`id_product_attribute` ORDER BY SUM(ag.`position`), SUM(a.`position`), pac.`id_product_attribute`	0.567 ms	1	Yes		/modules/pm_productsbyattributes/pm_productsbyattributes.php:1288 /modules/pm_productsbyattributes/pm_productsbyattributes.php:1323 (getAttributeCombinationsById) /modules/pm_productsbyattributes/src/Pm_ProductsByAttributesProductSearchProvider.php:324 (getFullProductName) /classes/controller/ProductListingFrontController.php:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
889	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 `ps_product_attribute` pa INNER JOIN ps_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) LEFT JOIN `ps_product_attribute_combination` pac ON pac.`id_product_attribute` = pa.`id_product_attribute` LEFT JOIN `ps_attribute` a ON a.`id_attribute` = pac.`id_attribute` LEFT JOIN `ps_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group` LEFT JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 5) JOIN `ps_product` p ON (p.`id_product` = pa.`id_product`) LEFT JOIN ps_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` = 741 AND IF (stock.`quantity` > 0, 1, IF (stock.`out_of_stock` = 2, 0 = 1, stock.`out_of_stock` = 1)) GROUP BY pa.`id_product_attribute` ORDER BY SUM(ag.`position`), SUM(a.`position`), pac.`id_product_attribute`	0.566 ms	1	Yes		/modules/pm_productsbyattributes/pm_productsbyattributes.php:1288 /modules/pm_productsbyattributes/pm_productsbyattributes.php:1323 (getAttributeCombinationsById) /modules/pm_productsbyattributes/src/Pm_ProductsByAttributesProductSearchProvider.php:324 (getFullProductName) /classes/controller/ProductListingFrontController.php:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
901	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 `ps_product_attribute` pa INNER JOIN ps_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) LEFT JOIN `ps_product_attribute_combination` pac ON pac.`id_product_attribute` = pa.`id_product_attribute` LEFT JOIN `ps_attribute` a ON a.`id_attribute` = pac.`id_attribute` LEFT JOIN `ps_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group` LEFT JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 5) JOIN `ps_product` p ON (p.`id_product` = pa.`id_product`) LEFT JOIN ps_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` = 569 AND IF (stock.`quantity` > 0, 1, IF (stock.`out_of_stock` = 2, 0 = 1, stock.`out_of_stock` = 1)) GROUP BY pa.`id_product_attribute` ORDER BY SUM(ag.`position`), SUM(a.`position`), pac.`id_product_attribute`	0.566 ms	1	Yes		/modules/pm_productsbyattributes/pm_productsbyattributes.php:1288 /modules/pm_productsbyattributes/pm_productsbyattributes.php:1323 (getAttributeCombinationsById) /modules/pm_productsbyattributes/src/Pm_ProductsByAttributesProductSearchProvider.php:324 (getFullProductName) /classes/controller/ProductListingFrontController.php:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
891	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 `ps_product_attribute` pa INNER JOIN ps_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) LEFT JOIN `ps_product_attribute_combination` pac ON pac.`id_product_attribute` = pa.`id_product_attribute` LEFT JOIN `ps_attribute` a ON a.`id_attribute` = pac.`id_attribute` LEFT JOIN `ps_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group` LEFT JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 5) JOIN `ps_product` p ON (p.`id_product` = pa.`id_product`) LEFT JOIN ps_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` = 1137 AND IF (stock.`quantity` > 0, 1, IF (stock.`out_of_stock` = 2, 0 = 1, stock.`out_of_stock` = 1)) GROUP BY pa.`id_product_attribute` ORDER BY SUM(ag.`position`), SUM(a.`position`), pac.`id_product_attribute`	0.565 ms	1	Yes		/modules/pm_productsbyattributes/pm_productsbyattributes.php:1288 /modules/pm_productsbyattributes/pm_productsbyattributes.php:1323 (getAttributeCombinationsById) /modules/pm_productsbyattributes/src/Pm_ProductsByAttributesProductSearchProvider.php:324 (getFullProductName) /classes/controller/ProductListingFrontController.php:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
894	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 `ps_product_attribute` pa INNER JOIN ps_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) LEFT JOIN `ps_product_attribute_combination` pac ON pac.`id_product_attribute` = pa.`id_product_attribute` LEFT JOIN `ps_attribute` a ON a.`id_attribute` = pac.`id_attribute` LEFT JOIN `ps_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group` LEFT JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 5) JOIN `ps_product` p ON (p.`id_product` = pa.`id_product`) LEFT JOIN ps_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` = 1495 AND IF (stock.`quantity` > 0, 1, IF (stock.`out_of_stock` = 2, 0 = 1, stock.`out_of_stock` = 1)) GROUP BY pa.`id_product_attribute` ORDER BY SUM(ag.`position`), SUM(a.`position`), pac.`id_product_attribute`	0.565 ms	1	Yes		/modules/pm_productsbyattributes/pm_productsbyattributes.php:1288 /modules/pm_productsbyattributes/pm_productsbyattributes.php:1323 (getAttributeCombinationsById) /modules/pm_productsbyattributes/src/Pm_ProductsByAttributesProductSearchProvider.php:324 (getFullProductName) /classes/controller/ProductListingFrontController.php:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
898	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 `ps_product_attribute` pa INNER JOIN ps_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) LEFT JOIN `ps_product_attribute_combination` pac ON pac.`id_product_attribute` = pa.`id_product_attribute` LEFT JOIN `ps_attribute` a ON a.`id_attribute` = pac.`id_attribute` LEFT JOIN `ps_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group` LEFT JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 5) JOIN `ps_product` p ON (p.`id_product` = pa.`id_product`) LEFT JOIN ps_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` = 1128 AND IF (stock.`quantity` > 0, 1, IF (stock.`out_of_stock` = 2, 0 = 1, stock.`out_of_stock` = 1)) GROUP BY pa.`id_product_attribute` ORDER BY SUM(ag.`position`), SUM(a.`position`), pac.`id_product_attribute`	0.562 ms	1	Yes		/modules/pm_productsbyattributes/pm_productsbyattributes.php:1288 /modules/pm_productsbyattributes/pm_productsbyattributes.php:1323 (getAttributeCombinationsById) /modules/pm_productsbyattributes/src/Pm_ProductsByAttributesProductSearchProvider.php:324 (getFullProductName) /classes/controller/ProductListingFrontController.php:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
929	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 `ps_product_attribute` pa INNER JOIN ps_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) LEFT JOIN `ps_product_attribute_combination` pac ON pac.`id_product_attribute` = pa.`id_product_attribute` LEFT JOIN `ps_attribute` a ON a.`id_attribute` = pac.`id_attribute` LEFT JOIN `ps_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group` LEFT JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 5) JOIN `ps_product` p ON (p.`id_product` = pa.`id_product`) LEFT JOIN ps_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` = 299 AND IF (stock.`quantity` > 0, 1, IF (stock.`out_of_stock` = 2, 0 = 1, stock.`out_of_stock` = 1)) GROUP BY pa.`id_product_attribute` ORDER BY SUM(ag.`position`), SUM(a.`position`), pac.`id_product_attribute`	0.562 ms	1	Yes		/modules/pm_productsbyattributes/pm_productsbyattributes.php:1288 /modules/pm_productsbyattributes/pm_productsbyattributes.php:1323 (getAttributeCombinationsById) /modules/pm_productsbyattributes/src/Pm_ProductsByAttributesProductSearchProvider.php:324 (getFullProductName) /classes/controller/ProductListingFrontController.php:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
23	SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module`as `mshop` FROM `ps_module` m LEFT JOIN `ps_module_shop` ms ON m.`id_module` = ms.`id_module` AND ms.`id_shop` = 1	0.561 ms	123			/classes/module/Module.php:346 /modules/antispamprotector/antispamprotector.php:48 (__construct) /override/modules/antispamprotector/antispamprotector.php:21 (__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:1258 (get) /tools/profiling/Module.php:35 (coreLoadModule) /classes/module/Module.php:1242 (coreLoadModule) /classes/Hook.php:972 (getInstanceByName) /classes/Dispatcher.php:507 (exec) /index.php:28 (dispatch)
892	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 `ps_product_attribute` pa INNER JOIN ps_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) LEFT JOIN `ps_product_attribute_combination` pac ON pac.`id_product_attribute` = pa.`id_product_attribute` LEFT JOIN `ps_attribute` a ON a.`id_attribute` = pac.`id_attribute` LEFT JOIN `ps_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group` LEFT JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 5) JOIN `ps_product` p ON (p.`id_product` = pa.`id_product`) LEFT JOIN ps_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` = 1167 AND IF (stock.`quantity` > 0, 1, IF (stock.`out_of_stock` = 2, 0 = 1, stock.`out_of_stock` = 1)) GROUP BY pa.`id_product_attribute` ORDER BY SUM(ag.`position`), SUM(a.`position`), pac.`id_product_attribute`	0.561 ms	1	Yes		/modules/pm_productsbyattributes/pm_productsbyattributes.php:1288 /modules/pm_productsbyattributes/pm_productsbyattributes.php:1323 (getAttributeCombinationsById) /modules/pm_productsbyattributes/src/Pm_ProductsByAttributesProductSearchProvider.php:324 (getFullProductName) /classes/controller/ProductListingFrontController.php:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
930	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 `ps_product_attribute` pa INNER JOIN ps_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) LEFT JOIN `ps_product_attribute_combination` pac ON pac.`id_product_attribute` = pa.`id_product_attribute` LEFT JOIN `ps_attribute` a ON a.`id_attribute` = pac.`id_attribute` LEFT JOIN `ps_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group` LEFT JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 5) JOIN `ps_product` p ON (p.`id_product` = pa.`id_product`) LEFT JOIN ps_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` = 1158 AND IF (stock.`quantity` > 0, 1, IF (stock.`out_of_stock` = 2, 0 = 1, stock.`out_of_stock` = 1)) GROUP BY pa.`id_product_attribute` ORDER BY SUM(ag.`position`), SUM(a.`position`), pac.`id_product_attribute`	0.561 ms	1	Yes		/modules/pm_productsbyattributes/pm_productsbyattributes.php:1288 /modules/pm_productsbyattributes/pm_productsbyattributes.php:1323 (getAttributeCombinationsById) /modules/pm_productsbyattributes/src/Pm_ProductsByAttributesProductSearchProvider.php:324 (getFullProductName) /classes/controller/ProductListingFrontController.php:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
928	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 `ps_product_attribute` pa INNER JOIN ps_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) LEFT JOIN `ps_product_attribute_combination` pac ON pac.`id_product_attribute` = pa.`id_product_attribute` LEFT JOIN `ps_attribute` a ON a.`id_attribute` = pac.`id_attribute` LEFT JOIN `ps_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group` LEFT JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 5) JOIN `ps_product` p ON (p.`id_product` = pa.`id_product`) LEFT JOIN ps_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` = 300 AND IF (stock.`quantity` > 0, 1, IF (stock.`out_of_stock` = 2, 0 = 1, stock.`out_of_stock` = 1)) GROUP BY pa.`id_product_attribute` ORDER BY SUM(ag.`position`), SUM(a.`position`), pac.`id_product_attribute`	0.560 ms	1	Yes		/modules/pm_productsbyattributes/pm_productsbyattributes.php:1288 /modules/pm_productsbyattributes/pm_productsbyattributes.php:1323 (getAttributeCombinationsById) /modules/pm_productsbyattributes/src/Pm_ProductsByAttributesProductSearchProvider.php:324 (getFullProductName) /classes/controller/ProductListingFrontController.php:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
890	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 `ps_product_attribute` pa INNER JOIN ps_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) LEFT JOIN `ps_product_attribute_combination` pac ON pac.`id_product_attribute` = pa.`id_product_attribute` LEFT JOIN `ps_attribute` a ON a.`id_attribute` = pac.`id_attribute` LEFT JOIN `ps_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group` LEFT JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 5) JOIN `ps_product` p ON (p.`id_product` = pa.`id_product`) LEFT JOIN ps_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` = 1130 AND IF (stock.`quantity` > 0, 1, IF (stock.`out_of_stock` = 2, 0 = 1, stock.`out_of_stock` = 1)) GROUP BY pa.`id_product_attribute` ORDER BY SUM(ag.`position`), SUM(a.`position`), pac.`id_product_attribute`	0.559 ms	1	Yes		/modules/pm_productsbyattributes/pm_productsbyattributes.php:1288 /modules/pm_productsbyattributes/pm_productsbyattributes.php:1323 (getAttributeCombinationsById) /modules/pm_productsbyattributes/src/Pm_ProductsByAttributesProductSearchProvider.php:324 (getFullProductName) /classes/controller/ProductListingFrontController.php:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)

Name	Instances	Source
Product	42	/classes/Pack.php:286 (__construct) [id: 863] /classes/Pack.php:190 (__construct) [id: 1185] /classes/Pack.php:190 (__construct) [id: 1229] /classes/Pack.php:243 (__construct) [id: 863] /classes/Pack.php:286 (__construct) [id: 863] /classes/Link.php:113 (__construct) [id: 1564] /classes/Pack.php:286 (__construct) [id: 899] /classes/Pack.php:190 (__construct) [id: 1167] /classes/Pack.php:190 (__construct) [id: 1229] /classes/Pack.php:243 (__construct) [id: 899] /classes/Pack.php:286 (__construct) [id: 899] /classes/Link.php:113 (__construct) [id: 1306] /classes/Pack.php:286 (__construct) [id: 1306] /classes/Pack.php:190 (__construct) [id: 804] /classes/Pack.php:190 (__construct) [id: 1229] /classes/Pack.php:243 (__construct) [id: 1306] /classes/Pack.php:286 (__construct) [id: 1306] /classes/Link.php:113 (__construct) [id: 1766] /classes/Link.php:113 (__construct) [id: 1163] /classes/Link.php:113 (__construct) [id: 1161] /classes/Link.php:113 (__construct) [id: 300] /classes/Link.php:113 (__construct) [id: 299] /classes/Link.php:113 (__construct) [id: 1158] /classes/Link.php:113 (__construct) [id: 1018] /classes/Link.php:113 (__construct) [id: 299] /classes/Link.php:113 (__construct) [id: 1158] /classes/Link.php:113 (__construct) [id: 1018] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 299] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 1158] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 1018] /modules/cdc_googletagmanager/services/Gtm_Product.php:164 (__construct) [id: 299] /modules/cdc_googletagmanager/services/Gtm_Product.php:164 (__construct) [id: 1158] /modules/cdc_googletagmanager/services/Gtm_Product.php:164 (__construct) [id: 1018] /classes/Link.php:113 (__construct) [id: 299] /classes/Link.php:113 (__construct) [id: 1158] /classes/Link.php:113 (__construct) [id: 1018] /override/modules/productlabelsandstickers/productlabelsandstickers.php:94 (__construct) [id: 299] /override/modules/productlabelsandstickers/productlabelsandstickers.php:94 (__construct) [id: 299] /override/modules/productlabelsandstickers/productlabelsandstickers.php:94 (__construct) [id: 1158] /override/modules/productlabelsandstickers/productlabelsandstickers.php:94 (__construct) [id: 1158] /override/modules/productlabelsandstickers/productlabelsandstickers.php:94 (__construct) [id: 1018] /override/modules/productlabelsandstickers/productlabelsandstickers.php:94 (__construct) [id: 1018]
Rules	38	/override/modules/productlabelsandstickers/productlabelsandstickers.php:93 (__construct) [id: ] /override/modules/productlabelsandstickers/productlabelsandstickers.php:101 (keyNewExists) [id: ] /override/modules/productlabelsandstickers/productlabelsandstickers.php:108 (keyTagExists) [id: ] /override/modules/productlabelsandstickers/productlabelsandstickers.php:117 (keyRefExists) [id: ] /override/modules/productlabelsandstickers/productlabelsandstickers.php:126 (keyPriceExists) [id: ] /override/modules/productlabelsandstickers/productlabelsandstickers.php:132 (keyPriceGreaterExists) [id: ] /override/modules/productlabelsandstickers/productlabelsandstickers.php:93 (__construct) [id: ] /override/modules/productlabelsandstickers/productlabelsandstickers.php:101 (keyNewExists) [id: ] /override/modules/productlabelsandstickers/productlabelsandstickers.php:108 (keyTagExists) [id: ] /override/modules/productlabelsandstickers/productlabelsandstickers.php:117 (keyRefExists) [id: ] /override/modules/productlabelsandstickers/productlabelsandstickers.php:126 (keyPriceExists) [id: ] /override/modules/productlabelsandstickers/productlabelsandstickers.php:132 (keyPriceGreaterExists) [id: ] /override/modules/productlabelsandstickers/productlabelsandstickers.php:93 (__construct) [id: ] /override/modules/productlabelsandstickers/productlabelsandstickers.php:101 (keyNewExists) [id: ] /override/modules/productlabelsandstickers/productlabelsandstickers.php:108 (keyTagExists) [id: ] /override/modules/productlabelsandstickers/productlabelsandstickers.php:117 (keyRefExists) [id: ] /override/modules/productlabelsandstickers/productlabelsandstickers.php:126 (keyPriceExists) [id: ] /override/modules/productlabelsandstickers/productlabelsandstickers.php:132 (keyPriceGreaterExists) [id: ] /override/modules/productlabelsandstickers/productlabelsandstickers.php:147 (keySaleExists) [id: ] /override/modules/productlabelsandstickers/productlabelsandstickers.php:93 (__construct) [id: ] /override/modules/productlabelsandstickers/productlabelsandstickers.php:101 (keyNewExists) [id: ] /override/modules/productlabelsandstickers/productlabelsandstickers.php:108 (keyTagExists) [id: ] /override/modules/productlabelsandstickers/productlabelsandstickers.php:117 (keyRefExists) [id: ] /override/modules/productlabelsandstickers/productlabelsandstickers.php:126 (keyPriceExists) [id: ] /override/modules/productlabelsandstickers/productlabelsandstickers.php:132 (keyPriceGreaterExists) [id: ] /override/modules/productlabelsandstickers/productlabelsandstickers.php:147 (keySaleExists) [id: ] /override/modules/productlabelsandstickers/productlabelsandstickers.php:93 (__construct) [id: ] /override/modules/productlabelsandstickers/productlabelsandstickers.php:101 (keyNewExists) [id: ] /override/modules/productlabelsandstickers/productlabelsandstickers.php:108 (keyTagExists) [id: ] /override/modules/productlabelsandstickers/productlabelsandstickers.php:117 (keyRefExists) [id: ] /override/modules/productlabelsandstickers/productlabelsandstickers.php:126 (keyPriceExists) [id: ] /override/modules/productlabelsandstickers/productlabelsandstickers.php:132 (keyPriceGreaterExists) [id: ] /override/modules/productlabelsandstickers/productlabelsandstickers.php:93 (__construct) [id: ] /override/modules/productlabelsandstickers/productlabelsandstickers.php:101 (keyNewExists) [id: ] /override/modules/productlabelsandstickers/productlabelsandstickers.php:108 (keyTagExists) [id: ] /override/modules/productlabelsandstickers/productlabelsandstickers.php:117 (keyRefExists) [id: ] /override/modules/productlabelsandstickers/productlabelsandstickers.php:126 (keyPriceExists) [id: ] /override/modules/productlabelsandstickers/productlabelsandstickers.php:132 (keyPriceGreaterExists) [id: ]
Category	28	/controllers/front/listing/CategoryController.php:78 (__construct) [id: 33] /classes/Meta.php:380 (__construct) [id: 33] /classes/Link.php:402 (__construct) [id: 33] /classes/Link.php:402 (__construct) [id: 33] /classes/Link.php:402 (__construct) [id: 33] /classes/PrestaShopCollection.php:385 (hydrateCollection) [id: ] /classes/PrestaShopCollection.php:385 (hydrateCollection) [id: ] /classes/PrestaShopCollection.php:385 (hydrateCollection) [id: ] /classes/PrestaShopCollection.php:385 (hydrateCollection) [id: ] /modules/pm_productsbyattributes/src/Pm_ProductsByAttributesProductSearchProvider.php:53 (__construct) [id: 33] /modules/pm_productsbyattributes/src/Pm_ProductsByAttributesProductSearchProvider.php:53 (__construct) [id: 33] /modules/pm_productsbyattributes/pm_productsbyattributes.php:777 (__construct) [id: 33] /modules/pm_productsbyattributes/pm_productsbyattributes.php:777 (__construct) [id: 33] /modules/pm_productsbyattributes/pm_productsbyattributes.php:777 (__construct) [id: 33] /modules/pm_productsbyattributes/pm_productsbyattributes.php:777 (__construct) [id: 33] /modules/pm_productsbyattributes/pm_productsbyattributes.php:777 (__construct) [id: 33] /modules/cdc_googletagmanager/cdc_googletagmanager.php:1329 (__construct) [id: 33] /modules/cdc_googletagmanager/classes/gtm/DataLayerItem.php:109 (__construct) [id: 38] /modules/cdc_googletagmanager/cdc_googletagmanager.php:1390 (__construct) [id: 2] /modules/cdc_googletagmanager/cdc_googletagmanager.php:1339 (__construct) [id: 10] /modules/cdc_googletagmanager/classes/gtm/DataLayerItem.php:109 (__construct) [id: 38] /modules/cdc_googletagmanager/cdc_googletagmanager.php:1339 (__construct) [id: 10] /modules/cdc_googletagmanager/classes/gtm/DataLayerItem.php:109 (__construct) [id: 38] /modules/cdc_googletagmanager/cdc_googletagmanager.php:1339 (__construct) [id: 10] /classes/Link.php:402 (__construct) [id: 33] /classes/Link.php:402 (__construct) [id: 33] /classes/Link.php:402 (__construct) [id: 33] /modules/ps_categorytree/ps_categorytree.php:364 (getParentsCategories) [id: 2]
Address	10	/classes/shop/Shop.php:486 (__construct) [id: ] /classes/Product.php:3694 (initialize) [id: ] /classes/Product.php:3804 (__construct) [id: ] /classes/Product.php:5964 (__construct) [id: ] /classes/Product.php:741 (__construct) [id: ] /classes/Product.php:741 (__construct) [id: ] /classes/Product.php:741 (__construct) [id: ] /classes/Product.php:741 (__construct) [id: ] /classes/Product.php:741 (__construct) [id: ] /classes/Product.php:741 (__construct) [id: ]
Stickers	6	/override/modules/productlabelsandstickers/productlabelsandstickers.php:92 (__construct) [id: ] /override/modules/productlabelsandstickers/productlabelsandstickers.php:92 (__construct) [id: ] /override/modules/productlabelsandstickers/productlabelsandstickers.php:92 (__construct) [id: ] /override/modules/productlabelsandstickers/productlabelsandstickers.php:92 (__construct) [id: ] /override/modules/productlabelsandstickers/productlabelsandstickers.php:92 (__construct) [id: ] /override/modules/productlabelsandstickers/productlabelsandstickers.php:92 (__construct) [id: ]
Currency	5	/src/Adapter/Currency/CurrencyDataProvider.php:101 (__construct) [id: 1] /src/Adapter/Currency/CurrencyDataProvider.php:101 (__construct) [id: 3] /src/Adapter/Currency/CurrencyDataProvider.php:101 (__construct) [id: 4] /src/Adapter/Currency/CurrencyDataProvider.php:101 (__construct) [id: 2] /classes/Tools.php:695 (getCurrencyInstance) [id: 1]
Language	3	/config/config.inc.php:211 (__construct) [id: 1] /classes/Tools.php:641 (__construct) [id: 5] /classes/Tools.php:560 (__construct) [id: 5]
Country	3	/config/config.inc.php:146 (__construct) [id: 19] /classes/AddressFormat.php:404 (__construct) [id: 19] /classes/controller/FrontController.php:1779 (__construct) [id: 19]
Cart	2	/classes/controller/FrontController.php:467 (__construct) [id: ] /classes/controller/FrontController.php:541 (__construct) [id: ]
Tax	2	/classes/tax/TaxRulesTaxManager.php:116 (__construct) [id: 36] /classes/tax/TaxRulesTaxManager.php:116 (__construct) [id: 36]
State	1	/classes/controller/FrontController.php:1778 (__construct) [id: 0]
IqitElementorCategory	1	/modules/iqitelementor/iqitelementor.php:853 (isJustElementor) [id: ]
Shop	1	/config/config.inc.php:117 (initialize) [id: 1]
AddressFormat	1	/classes/controller/FrontController.php:1773 (generateAddress) [id: ]
Risk	1	/classes/controller/FrontController.php:1705 (__construct) [id: ]
Group	1	/classes/Cart.php:249 (getCurrent) [id: 1]
Customer	1	/config/config.inc.php:264 (__construct) [id: ]
ShopGroup	1	/classes/shop/Shop.php:561 (__construct) [id: 1]
Gender	1	/classes/controller/FrontController.php:1702 (__construct) [id: 0]

#	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