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	579.338 ms
Querying Time	342 ms
Queries	1195
Memory Peak Usage	66.0 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	2.901 ms	2.901 ms	20.76 Mb	21.5 Mb
__construct	0.009 ms	2.910 ms	- Mb	21.5 Mb
init	24.039 ms	26.949 ms	5.91 Mb	27.8 Mb
checkAccess	0.001 ms	26.950 ms	- Mb	27.8 Mb
setMedia	2.070 ms	29.020 ms	0.46 Mb	27.8 Mb
postProcess	0.000 ms	29.020 ms	- Mb	27.8 Mb
initHeader	0.001 ms	29.021 ms	- Mb	27.8 Mb
initContent	367.488 ms	396.509 ms	21.63 Mb	48.8 Mb
initFooter	0.003 ms	396.512 ms	- Mb	48.8 Mb
display	182.826 ms	579.338 ms	16.96 Mb	66.0 Mb

Hook	Time	Memory Usage
DisplayProductListFunctionalButtons	45.941 ms	4.66 Mb
=> productlabelsandstickers	17.052 ms	2.17 Mb
=> productlabelsandstickers	15.696 ms	1.33 Mb
=> productlabelsandstickers	13.193 ms	1.17 Mb
DisplayProductListReviews	39.475 ms	3.22 Mb
=> productlabelsandstickers	13.903 ms	1.08 Mb
=> productlabelsandstickers	12.991 ms	1.13 Mb
=> productlabelsandstickers	12.581 ms	1.02 Mb
displayFooterBefore	36.431 ms	3.36 Mb
=> ps_emailsubscription (widget)	36.431 ms	3.36 Mb
DisplayGDPRConsent	33.671 ms	3.10 Mb
=> psgdpr	33.671 ms	3.10 Mb
displayBeforeBodyClosingTag	6.019 ms	0.79 Mb
=> iqitwishlist (widget)	5.435 ms	0.74 Mb
=> iqitcookielaw (widget)	0.584 ms	0.05 Mb
DisplayAfterTitleTag	5.578 ms	0.67 Mb
=> cdc_googletagmanager	5.578 ms	0.67 Mb
displayLeftColumn	3.791 ms	0.18 Mb
=> ps_categorytree (widget)	3.791 ms	0.18 Mb
DisplayHeader	3.312 ms	0.49 Mb
=> productcomments	0.047 ms	- Mb
=> ps_shoppingcart	0.018 ms	- Mb
=> psxmarketingwithgoogle	0.979 ms	0.14 Mb
=> iqitcontactpage	0.001 ms	- Mb
=> iqitcookielaw	0.054 ms	- Mb
=> iqitcountdown	0.043 ms	- Mb
=> iqitelementor	0.104 ms	- Mb
=> iqitfreedeliverycount	0.010 ms	- Mb
=> iqitmegamenu	0.063 ms	- Mb
=> iqitreviews	0.036 ms	- Mb
=> iqitsizecharts	0.025 ms	- Mb
=> iqitthemeeditor	0.092 ms	0.02 Mb
=> iqitwishlist	0.037 ms	- Mb
=> iqitextendedproduct	0.039 ms	- Mb
=> iqitsociallogin	0.023 ms	- Mb
=> stripe_official	0.206 ms	0.04 Mb
=> doofinder	1.381 ms	0.26 Mb
=> qrcodefacturesuisse	0.049 ms	- Mb
=> productlabelsandstickers	0.057 ms	- Mb
=> cdc_googletagmanager	0.044 ms	- Mb
=> antispamprotector	0.004 ms	- Mb
displayProductListReviews	2.880 ms	0.35 Mb
=> iqitreviews (widget)	1.472 ms	0.27 Mb
=> iqitreviews (widget)	0.722 ms	0.04 Mb
=> iqitreviews (widget)	0.686 ms	0.04 Mb
displayNav1	1.766 ms	0.21 Mb
=> iqitlinksmanager (widget)	1.766 ms	0.21 Mb
displayFooter	1.481 ms	0.11 Mb
=> iqitlinksmanager (widget)	0.473 ms	0.04 Mb
=> iqitcontactpage (widget)	1.008 ms	0.07 Mb
ProductSearchProvider	1.404 ms	0.26 Mb
=> pm_productsbyattributes	1.364 ms	0.25 Mb
=> iqitthemeeditor	0.002 ms	- Mb
=> pm_productsbyattributes	0.021 ms	- Mb
=> iqitthemeeditor	0.001 ms	- Mb
=> pm_productsbyattributes	0.016 ms	- Mb
=> iqitthemeeditor	0.000 ms	- Mb
displayNav2	1.257 ms	0.11 Mb
=> ps_languageselector (widget)	0.968 ms	0.06 Mb
=> ps_currencyselector (widget)	0.289 ms	0.04 Mb
displayProductListFunctionalButtons	1.118 ms	0.01 Mb
=> iqitwishlist (widget)	0.398 ms	0.01 Mb
=> iqitwishlist (widget)	0.361 ms	- Mb
=> iqitwishlist (widget)	0.359 ms	- Mb
displayMainMenu	1.061 ms	0.18 Mb
=> iqitmegamenu (widget)	1.061 ms	0.18 Mb
renderWidget	0.943 ms	0.06 Mb
=> iqitsearch (widget)	0.943 ms	0.06 Mb
displayCustomerLoginFormAfter	0.868 ms	0.07 Mb
=> iqitsociallogin (widget)	0.868 ms	0.07 Mb
displayCountDown	0.809 ms	0.08 Mb
=> iqitcountdown (widget)	0.809 ms	0.08 Mb
displayCategoryElementor	0.696 ms	0.08 Mb
=> iqitelementor (widget)	0.696 ms	0.08 Mb
displayHeaderButtons	0.684 ms	0.05 Mb
=> iqitwishlist (widget)	0.684 ms	0.05 Mb
ActionFrontControllerSetMedia	0.555 ms	0.12 Mb
=> ps_emailsubscription	0.519 ms	0.12 Mb
=> iqitproductvariants	0.036 ms	- Mb
displayAfterBreadcrumb	0.331 ms	0.04 Mb
=> iqitproductsnav (widget)	0.327 ms	0.04 Mb
=> iqitproductsnav (widget)	0.004 ms	- Mb
DisplayAfterBodyOpeningTag	0.314 ms	0.01 Mb
=> cdc_googletagmanager	0.314 ms	0.01 Mb
ActionDispatcher	0.276 ms	0.01 Mb
=> antispamprotector	0.271 ms	0.01 Mb
=> iqitthemeeditor	0.005 ms	- Mb
IsJustElementor	0.261 ms	0.02 Mb
=> iqitelementor	0.261 ms	0.02 Mb
Header	0.174 ms	0.01 Mb
=> mqc	0.116 ms	- Mb
=> bonslick	0.002 ms	- Mb
=> twint_for_prestashop	0.056 ms	- Mb
ActionGetProductPropertiesAfterUnitPrice	0.128 ms	0.02 Mb
=> pm_productsbyattributes	0.002 ms	- Mb
=> pm_productsbyattributes	0.001 ms	- Mb
=> pm_productsbyattributes	0.005 ms	- Mb
=> pm_productsbyattributes	0.004 ms	- Mb
=> pm_productsbyattributes	0.003 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.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.004 ms	- Mb
=> pm_productsbyattributes	0.002 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.003 ms	- Mb
=> pm_productsbyattributes	0.002 ms	- Mb
=> pm_productsbyattributes	0.003 ms	- Mb
=> pm_productsbyattributes	0.002 ms	- Mb
=> pm_productsbyattributes	0.003 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.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.002 ms	- Mb
=> pm_productsbyattributes	0.002 ms	- Mb
=> pm_productsbyattributes	0.002 ms	- Mb
=> pm_productsbyattributes	0.001 ms	- Mb
=> pm_productsbyattributes	0.002 ms	- Mb
=> pm_productsbyattributes	0.002 ms	- Mb
=> pm_productsbyattributes	0.003 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.003 ms	- Mb
=> pm_productsbyattributes	0.004 ms	- Mb
=> pm_productsbyattributes	0.003 ms	- Mb
=> pm_productsbyattributes	0.003 ms	- Mb
FilterProductSearch	0.042 ms	0.06 Mb
=> pm_productsbyattributes	0.042 ms	0.06 Mb
DisplayProductPriceBlock	0.015 ms	- Mb
=> cdc_googletagmanager	0.003 ms	- Mb
=> cdc_googletagmanager	0.002 ms	- Mb
=> cdc_googletagmanager	0.001 ms	- Mb
=> cdc_googletagmanager	0.003 ms	- Mb
=> cdc_googletagmanager	0.001 ms	- Mb
=> cdc_googletagmanager	0.001 ms	- Mb
=> cdc_googletagmanager	0.000 ms	- Mb
=> cdc_googletagmanager	0.002 ms	- Mb
=> cdc_googletagmanager	0.001 ms	- Mb
=> cdc_googletagmanager	0.001 ms	- Mb
ActionProductFlagsModifier	0.013 ms	- Mb
=> pm_productsbyattributes	0.004 ms	- Mb
=> pm_productsbyattributes	0.004 ms	- Mb
=> pm_productsbyattributes	0.005 ms	- Mb
DisplayBeforeBodyClosingTag	0.011 ms	- Mb
=> cdc_googletagmanager	0.011 ms	- Mb
displayVerticalMenu	0.010 ms	- Mb
=> iqitmegamenu (widget)	0.010 ms	- Mb
ActionProductSearchAfter	0.005 ms	- Mb
=> iqitthemeeditor	0.005 ms	- Mb
ModuleRoutes	0.002 ms	- Mb
=> doofinder	0.002 ms	- Mb
34 hook(s)	191.321 ms	18.32 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 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 - 1195 queries

Doubles

Tables stress

ObjectModel instances

Included Files

Module	Time	Memory Usage
doofinder	6.557 ms	2.28 Mb
__construct	5.170 ms	2.02 Mb
hookModuleRoutes	0.004 ms	- Mb
hookDisplayHeader	1.383 ms	0.26 Mb
antispamprotector	1.770 ms	0.37 Mb
__construct	1.493 ms	0.36 Mb
hookActionDispatcher	0.272 ms	0.01 Mb
hookDisplayHeader	0.005 ms	- Mb
iqitthemeeditor	1.039 ms	0.48 Mb
__construct	0.928 ms	0.45 Mb
hookActionDispatcher	0.006 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	37.968 ms	3.70 Mb
__construct	1.015 ms	0.22 Mb
hookActionFrontControllerSetMedia	0.521 ms	0.12 Mb
displayFooterBefore	36.432 ms	3.36 Mb
iqitproductvariants	0.261 ms	0.10 Mb
__construct	0.224 ms	0.10 Mb
hookActionFrontControllerSetMedia	0.037 ms	- Mb
productcomments	0.723 ms	0.18 Mb
__construct	0.675 ms	0.18 Mb
hookDisplayHeader	0.048 ms	- Mb
ps_shoppingcart	0.202 ms	0.05 Mb
__construct	0.184 ms	0.04 Mb
hookDisplayHeader	0.018 ms	- Mb
psxmarketingwithgoogle	1.324 ms	0.26 Mb
__construct	0.343 ms	0.12 Mb
hookDisplayHeader	0.981 ms	0.14 Mb
iqitcontactpage	1.265 ms	0.12 Mb
__construct	0.252 ms	0.05 Mb
hookDisplayHeader	0.002 ms	- Mb
displayFooter	1.011 ms	0.07 Mb
iqitcookielaw	0.859 ms	0.10 Mb
__construct	0.219 ms	0.05 Mb
hookDisplayHeader	0.055 ms	- Mb
displayBeforeBodyClosingTag	0.585 ms	0.05 Mb

#	Query	Time (ms)	Rows	Filesort	Group By	Location
480	(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	8.379 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)
74	(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	7.400 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)
877	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	4.475 ms	117306			/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)
878	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	4.175 ms	117306			/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)
479	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.550 ms	117306			/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)
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`)	2.904 ms	3398			/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)
83	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	2.515 ms	592			/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)
82	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	2.090 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)
879	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`	1.626 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)
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` = 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`	1.420 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` = 1829 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`	1.398 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` = 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`	1.350 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` = 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`	1.345 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` = 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`	1.277 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)
880	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`	1.242 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)
14	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`	1.212 ms	8	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)
885	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` = 863 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`	1.203 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)
1181	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	1.027 ms	7	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)
887	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.941 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)
1053	SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, SUM(IF(stock.`quantity` > 0, 1, 0)) 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 = 1) LEFT JOIN ps_stock_available stock ON (stock.id_product = `pa`.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_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` = 5) JOIN `ps_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`) WHERE pa.`id_product` IN (299) AND ag.`is_color_group` = 1 GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` HAVING qty > 0 ORDER BY a.`position` ASC;	0.911 ms	1	Yes		/classes/Product.php:4524 /src/Adapter/Product/ProductColorsRetriever.php:43 (getAttributesColorList) /src/Adapter/Presenter/Product/ProductLazyArray.php:528 (getColoredVariants) /src/Adapter/Presenter/AbstractLazyArray.php:269 (getMainVariants) /var/cache/dev/smarty/compile/warehouselayouts_layout_left_column_tpl/6a/fb/c0/6afbc0c3a4d290322b7d6154febe0ad288c474c1_2.file.product-miniature-1.tpl.php:264 (offsetGet) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/warehouselayouts_layout_left_column_tpl/6a/fb/c0/6afbc0c3a4d290322b7d6154febe0ad288c474c1_2.file.product-miniature-1.tpl.php:69 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_691b9e84c65fc1_84847635) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /var/cache/dev/smarty/compile/warehouselayouts_layout_left_column_tpl/dc/73/f5/dc73f5a4497fe278bd5a7ee1177619c86cf6407e_2.file.product.tpl.php:71 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/warehouselayouts_layout_left_column_tpl/dc/73/f5/dc73f5a4497fe278bd5a7ee1177619c86cf6407e_2.file.product.tpl.php:29 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_691b9e84c5c2a9_76589168) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /var/cache/dev/smarty/compile/warehouselayouts_layout_left_column_tpl/76/d7/23/76d723250584d8bcb675dc4a36450523e8803307_2.file.products.tpl.php:67 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/warehouselayouts_layout_left_column_tpl/76/d7/23/76d723250584d8bcb675dc4a36450523e8803307_2.file.products.tpl.php:39 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_691b9e84c55105_39511260) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /var/cache/dev/smarty/compile/warehouselayouts_layout_left_column_tpl/2a/f2/e4/2af2e422e5af552125dd52cd4895a7fff3e94cbb_2.file.product-list.tpl.php:136 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/warehouselayouts_layout_left_column_tpl/2a/f2/e4/2af2e422e5af552125dd52cd4895a7fff3e94cbb_2.file.product-list.tpl.php:267 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:186 (process) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/warehouselayouts_layout_left_column_tpl/5e/c7/c1/5ec7c172abdeb4164092d41f0ee3b65434216b82_2.file.layout-left-column.tpl.php:101 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:186 (process) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/warehouselayouts_layout_left_column_tpl/36/f2/c0/36f2c0d8741ecf0e9c4faf862198e4df4c88ef90_2.file.layout-both-columns.tpl.php:110 (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)
460	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.886 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)
366	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` = 899 GROUP BY a.`id_product_item`, a.`id_product_attribute_item`	0.838 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)
205	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` = 863 GROUP BY a.`id_product_item`, a.`id_product_attribute_item`	0.836 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)
873	SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity, COALESCE(SUM(first_level_quantity), 0) as quantity FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity FROM `ps_cart_product` cp WHERE cp.`id_product_attribute` = 0 AND cp.`id_cart` = 0 AND cp.`id_product` = 1018 UNION SELECT 0 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` = 0 AND cp.`id_cart` = 0 AND p.`id_product_item` = 1018 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1	0.836 ms	0			/classes/Cart.php:1430 /classes/Product.php:4361 (getProductQuantity) /classes/Product.php:5802 (getQuantity) /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: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)
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` = 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.834 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)
459	SELECT SQL_NO_CACHE 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 = 5) LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 5) LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 5) INNER JOIN ps_feature_shop feature_shop ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1) WHERE pf.id_product = 1306 ORDER BY f.position ASC	0.827 ms	4	Yes		/classes/Product.php:6021 /classes/Product.php:5824 (getFrontFeaturesStatic) /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)
874	SELECT SQL_NO_CACHE 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 = 5) LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 5) LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 5) INNER JOIN ps_feature_shop feature_shop ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1) WHERE pf.id_product = 1018 ORDER BY f.position ASC	0.816 ms	4	Yes		/classes/Product.php:6021 /classes/Product.php:5824 (getFrontFeaturesStatic) /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: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)
1120	SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, SUM(IF(stock.`quantity` > 0, 1, 0)) 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 = 1) LEFT JOIN ps_stock_available stock ON (stock.id_product = `pa`.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_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` = 5) JOIN `ps_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`) WHERE pa.`id_product` IN (1158) AND ag.`is_color_group` = 1 GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` HAVING qty > 0 ORDER BY a.`position` ASC;	0.758 ms	1	Yes		/classes/Product.php:4524 /src/Adapter/Product/ProductColorsRetriever.php:43 (getAttributesColorList) /src/Adapter/Presenter/Product/ProductLazyArray.php:528 (getColoredVariants) /src/Adapter/Presenter/AbstractLazyArray.php:269 (getMainVariants) /var/cache/dev/smarty/compile/warehouselayouts_layout_left_column_tpl/6a/fb/c0/6afbc0c3a4d290322b7d6154febe0ad288c474c1_2.file.product-miniature-1.tpl.php:264 (offsetGet) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/warehouselayouts_layout_left_column_tpl/6a/fb/c0/6afbc0c3a4d290322b7d6154febe0ad288c474c1_2.file.product-miniature-1.tpl.php:69 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_691b9e84c65fc1_84847635) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:384 (render) /var/cache/dev/smarty/compile/warehouselayouts_layout_left_column_tpl/dc/73/f5/dc73f5a4497fe278bd5a7ee1177619c86cf6407e_2.file.product.tpl.php:71 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/warehouselayouts_layout_left_column_tpl/dc/73/f5/dc73f5a4497fe278bd5a7ee1177619c86cf6407e_2.file.product.tpl.php:29 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_691b9e84c5c2a9_76589168) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:384 (render) /var/cache/dev/smarty/compile/warehouselayouts_layout_left_column_tpl/76/d7/23/76d723250584d8bcb675dc4a36450523e8803307_2.file.products.tpl.php:67 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/warehouselayouts_layout_left_column_tpl/76/d7/23/76d723250584d8bcb675dc4a36450523e8803307_2.file.products.tpl.php:39 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_691b9e84c55105_39511260) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /var/cache/dev/smarty/compile/warehouselayouts_layout_left_column_tpl/2a/f2/e4/2af2e422e5af552125dd52cd4895a7fff3e94cbb_2.file.product-list.tpl.php:136 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/warehouselayouts_layout_left_column_tpl/2a/f2/e4/2af2e422e5af552125dd52cd4895a7fff3e94cbb_2.file.product-list.tpl.php:267 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:186 (process) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/warehouselayouts_layout_left_column_tpl/5e/c7/c1/5ec7c172abdeb4164092d41f0ee3b65434216b82_2.file.layout-left-column.tpl.php:101 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:186 (process) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/warehouselayouts_layout_left_column_tpl/36/f2/c0/36f2c0d8741ecf0e9c4faf862198e4df4c88ef90_2.file.layout-both-columns.tpl.php:110 (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)
463	SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity, COALESCE(SUM(first_level_quantity), 0) as quantity FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity FROM `ps_cart_product` cp WHERE cp.`id_product_attribute` = 0 AND cp.`id_cart` = 0 AND cp.`id_product` = 1229 UNION SELECT 0 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` = 0 AND cp.`id_cart` = 0 AND p.`id_product_item` = 1229 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1	0.742 ms	0			/classes/Cart.php:1430 /classes/Product.php:4361 (getProductQuantity) /classes/Pack.php:330 (getQuantity) /classes/Pack.php:244 (getQuantity) /classes/Product.php:5845 (isInStock) /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)
1178	SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, SUM(IF(stock.`quantity` > 0, 1, 0)) 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 = 1) LEFT JOIN ps_stock_available stock ON (stock.id_product = `pa`.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_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` = 5) JOIN `ps_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`) WHERE pa.`id_product` IN (1018) AND ag.`is_color_group` = 1 GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` HAVING qty > 0 ORDER BY a.`position` ASC;	0.738 ms	1	Yes		/classes/Product.php:4524 /src/Adapter/Product/ProductColorsRetriever.php:43 (getAttributesColorList) /src/Adapter/Presenter/Product/ProductLazyArray.php:528 (getColoredVariants) /src/Adapter/Presenter/AbstractLazyArray.php:269 (getMainVariants) /var/cache/dev/smarty/compile/warehouselayouts_layout_left_column_tpl/6a/fb/c0/6afbc0c3a4d290322b7d6154febe0ad288c474c1_2.file.product-miniature-1.tpl.php:264 (offsetGet) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/warehouselayouts_layout_left_column_tpl/6a/fb/c0/6afbc0c3a4d290322b7d6154febe0ad288c474c1_2.file.product-miniature-1.tpl.php:69 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_691b9e84c65fc1_84847635) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:384 (render) /var/cache/dev/smarty/compile/warehouselayouts_layout_left_column_tpl/dc/73/f5/dc73f5a4497fe278bd5a7ee1177619c86cf6407e_2.file.product.tpl.php:71 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/warehouselayouts_layout_left_column_tpl/dc/73/f5/dc73f5a4497fe278bd5a7ee1177619c86cf6407e_2.file.product.tpl.php:29 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_691b9e84c5c2a9_76589168) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:384 (render) /var/cache/dev/smarty/compile/warehouselayouts_layout_left_column_tpl/76/d7/23/76d723250584d8bcb675dc4a36450523e8803307_2.file.products.tpl.php:67 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/warehouselayouts_layout_left_column_tpl/76/d7/23/76d723250584d8bcb675dc4a36450523e8803307_2.file.products.tpl.php:39 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_691b9e84c55105_39511260) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /var/cache/dev/smarty/compile/warehouselayouts_layout_left_column_tpl/2a/f2/e4/2af2e422e5af552125dd52cd4895a7fff3e94cbb_2.file.product-list.tpl.php:136 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/warehouselayouts_layout_left_column_tpl/2a/f2/e4/2af2e422e5af552125dd52cd4895a7fff3e94cbb_2.file.product-list.tpl.php:267 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:186 (process) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/warehouselayouts_layout_left_column_tpl/5e/c7/c1/5ec7c172abdeb4164092d41f0ee3b65434216b82_2.file.layout-left-column.tpl.php:101 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:186 (process) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/warehouselayouts_layout_left_column_tpl/36/f2/c0/36f2c0d8741ecf0e9c4faf862198e4df4c88ef90_2.file.layout-both-columns.tpl.php:110 (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)
369	SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity, COALESCE(SUM(first_level_quantity), 0) as quantity FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity FROM `ps_cart_product` cp WHERE cp.`id_product_attribute` = 0 AND cp.`id_cart` = 0 AND cp.`id_product` = 1229 UNION SELECT 0 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` = 0 AND cp.`id_cart` = 0 AND p.`id_product_item` = 1229 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1	0.736 ms	0			/classes/Cart.php:1430 /classes/Product.php:4361 (getProductQuantity) /classes/Pack.php:330 (getQuantity) /classes/Pack.php:244 (getQuantity) /classes/Product.php:5845 (isInStock) /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)
457	SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity, COALESCE(SUM(first_level_quantity), 0) as quantity FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity FROM `ps_cart_product` cp WHERE cp.`id_product_attribute` = 0 AND cp.`id_cart` = 0 AND cp.`id_product` = 804 UNION SELECT 0 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` = 0 AND cp.`id_cart` = 0 AND p.`id_product_item` = 804 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1	0.734 ms	0			/classes/Cart.php:1430 /classes/Product.php:4361 (getProductQuantity) /classes/Pack.php:330 (getQuantity) /classes/Product.php:4345 (getQuantity) /classes/Product.php:5802 (getQuantity) /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)
123	SELECT SQL_NO_CACHE 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 = 5) LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 5) LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 5) INNER JOIN ps_feature_shop feature_shop ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1) WHERE pf.id_product = 1185 ORDER BY f.position ASC	0.727 ms	4	Yes		/classes/Product.php:6021 /classes/Product.php:5824 (getFrontFeaturesStatic) /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)
264	SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) + IF (`id_country` = 19, 4, 0) + IF (`id_currency` = 1, 8, 0) + IF (`id_shop` = 1, 16, 0) + IF (`id_customer` = 0, 32, 0)) AS `score` FROM `ps_specific_price` WHERE `id_shop` IN (0, 1) AND `id_currency` IN (0, 1) AND `id_country` IN (0, 19) AND `id_group` IN (0, 1) AND `id_product` = 1137 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0 AND (`from` = '0000-00-00 00:00:00' OR '2025-11-17 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2025-11-17 00:00:00' <= `to`) AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1	0.720 ms	1	Yes		/classes/SpecificPrice.php:576 /classes/Product.php:3827 (getSpecificPrice) /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)
514	SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity, COALESCE(SUM(first_level_quantity), 0) as quantity FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity FROM `ps_cart_product` cp WHERE cp.`id_product_attribute` = 0 AND cp.`id_cart` = 0 AND cp.`id_product` = 1845 UNION SELECT 0 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` = 0 AND cp.`id_cart` = 0 AND p.`id_product_item` = 1845 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1	0.715 ms	0			/classes/Cart.php:1430 /classes/Product.php:4361 (getProductQuantity) /classes/Product.php:5802 (getQuantity) /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: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)
284	SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity, COALESCE(SUM(first_level_quantity), 0) as quantity FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity FROM `ps_cart_product` cp WHERE cp.`id_product_attribute` = 0 AND cp.`id_cart` = 0 AND cp.`id_product` = 1167 UNION SELECT 0 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` = 0 AND cp.`id_cart` = 0 AND p.`id_product_item` = 1167 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1	0.709 ms	0			/classes/Cart.php:1430 /classes/Product.php:4361 (getProductQuantity) /classes/Product.php:5802 (getQuantity) /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)
527	SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity, COALESCE(SUM(first_level_quantity), 0) as quantity FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity FROM `ps_cart_product` cp WHERE cp.`id_product_attribute` = 0 AND cp.`id_cart` = 0 AND cp.`id_product` = 1193 UNION SELECT 0 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` = 0 AND cp.`id_cart` = 0 AND p.`id_product_item` = 1193 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1	0.707 ms	0			/classes/Cart.php:1430 /classes/Product.php:4361 (getProductQuantity) /classes/Product.php:5802 (getQuantity) /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: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)
462	SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity, COALESCE(SUM(first_level_quantity), 0) as quantity FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity FROM `ps_cart_product` cp WHERE cp.`id_product_attribute` = 0 AND cp.`id_cart` = 0 AND cp.`id_product` = 804 UNION SELECT 0 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` = 0 AND cp.`id_cart` = 0 AND p.`id_product_item` = 804 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1	0.706 ms	0			/classes/Cart.php:1430 /classes/Product.php:4361 (getProductQuantity) /classes/Pack.php:330 (getQuantity) /classes/Pack.php:244 (getQuantity) /classes/Product.php:5845 (isInStock) /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)
433	SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity, COALESCE(SUM(first_level_quantity), 0) as quantity FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity FROM `ps_cart_product` cp WHERE cp.`id_product_attribute` = 0 AND cp.`id_cart` = 0 AND cp.`id_product` = 804 UNION SELECT 0 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` = 0 AND cp.`id_cart` = 0 AND p.`id_product_item` = 804 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1	0.705 ms	0			/classes/Cart.php:1430 /classes/Product.php:4361 (getProductQuantity) /classes/Product.php:5802 (getQuantity) /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)
395	SELECT SQL_NO_CACHE 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 = 5) LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 5) LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 5) INNER JOIN ps_feature_shop feature_shop ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1) WHERE pf.id_product = 1132 ORDER BY f.position ASC	0.702 ms	4	Yes		/classes/Product.php:6021 /classes/Product.php:5824 (getFrontFeaturesStatic) /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)

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:690 (getCurrencyInstance) [id: 1]
Language	3	/config/config.inc.php:211 (__construct) [id: 5] /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