TRES IMPORTANT

OMEGABIO 3 : Un Rôle central au niveau Cellulair

Omégabio 3

ACIDES GRAS ESSENTIELS (A.G.E.)

Ces huiles de type “Omega 3“ sont riches en dérivés métaboliques actifs comme l'E.P.A. (acide

€35.00

Cholesterobio – Nature Bio: Natural Support for Healthy Cholesterol

Cholestérobio

SPHERE DIGESTIVE

La Levure rouge de Riz (ou Monascus Purpureus) était déjà utilisée par les chinois en l’an 800

€42.00

NEREIDOBIO : La Richesse des Océans à votre service - Vitamines - Minéraux - Oligoéléments - Nature Bio

Néréïdobio

VITAMINES - OLIGO-ELEMENTS - MINERAUX

L’Iode a une importance capitale dans la vie fœtale car essentielle pour la formation des hormones

€39.00

Glutaminobio

SPHERE DIGESTIVE

La Glutamine permet de synthétiser les protéines. Les protéines contribuent notamment à augmenter

€42.00

HEMOCROMATOBIO : Eliminez Votre excès de Fer ! - Sphère digestive - Nature Bio

Hémocromatobio

SPHERE DIGESTIVE

C’est une maladie insidieuse, car les premiers symptômes ne sont pas spécifiques (fatigue, douleurs

€42.00

HEPATOBIO : Nettoyez et Protéger votre Foie ! - Sphère digestive - Nature Bio

Hépatobio

SPHERE DIGESTIVE

HEPATOBIO associe les principales plantes traditionnellement reconnues pour stimuler le travail du

€42.00

Vitamine D3+

VITAMINES - OLIGO-ELEMENTS - MINERAUX

La Vitamine D3, appelé parfois « Vitamine du Soleil », est synthétisée en grande partie par

€32.00

Mgbio

VITAMINES - OLIGO-ELEMENTS - MINERAUX

Des études européennes (1997) et nord-américaines (2003) indiquent que les apports alimentaires en

€39.00

All Best Seller Products

TRES IMPORTANT2 products

View

Grid-2

List

Sort by:

On sale!

Plus nous vieillissons, moins nous produisons de Mélatonine ! Grâce à MELATONINOBIO , régulez votre Horloge Biologique et retrouvez un sommeil apaisé. Les troubles du sommeil touchent entre 25 et 40 % des personnes de plus de 55 ans. Vers la soixantaine, la production de Mélatonine, "l'hormone du sommeil", devient irrégulière et chute de moitié par...

€29.00

Quick View

On sale!

Mélatoninobio

ANXIETE - STRESS

€29.00

Quick View

SEROTONINOBIO – Natural serotonin supplement for stress relief

On sale!

Sérotoninobio

€39.00

Sérotoninobio

€39.00

On sale!

Sérotoninobio

ANXIETE - STRESS

Maitrisez Votre production de Sérotonine La Sérotonine, ou 5-HT (5-hydroxytryptamine) , bien que représentant qu'une infime partie de l'organisme, joue un double rôle d'hormone et de neurotransmetteur dans le système nerveux central. Elle est libérée dans l’espace séparant deux neurones par l’arrivée d’un...

€39.00

Quick View

On sale!

Sérotoninobio

ANXIETE - STRESS

€39.00

Quick View

Load Time	1060 ms
Querying Time	887 ms
Queries	476
Memory Peak Usage	20.9 Mb
Included Files	1214 files - 15.52 Mb
PrestaShop Cache	- Mb
Global vars	0.16 Mb
- global $_MODULES	68k
- global $_MODULE	68k
- global $_SERVER	6k
- global $_ENV	6k
- global $config	5k
- global $context	4k
- global $exportPhpConfigFile	4k
- global $smarty	2k
- global $_COOKIE	1k
- global $__composer_autoload_files	1k
- global $_REQUEST	1k

PrestaShop Version	8.1.3
PHP Version	8.1.33
MySQL Version	8.0.42
Memory Limit	8096M
Max Execution Time	5000s
Smarty Cache	disabled
Smarty Compilation	force compile

	Time	Cumulated Time	Memory Usage	Memory Peak Usage
config	62.000 ms	62.000 ms	3.05 Mb	3.2 Mb
__construct	0.013 ms	62.013 ms	- Mb	3.2 Mb
init	22.184 ms	84.197 ms	0.59 Mb	4.0 Mb
checkAccess	0.001 ms	84.198 ms	- Mb	4.0 Mb
setMedia	3.123 ms	87.321 ms	0.28 Mb	4.0 Mb
postProcess	0.001 ms	87.322 ms	- Mb	4.0 Mb
initHeader	0.001 ms	87.323 ms	- Mb	4.0 Mb
initContent	220.759 ms	308.082 ms	3.06 Mb	7.1 Mb
initFooter	0.002 ms	308.084 ms	- Mb	7.1 Mb
display	752.184 ms	1060 ms	13.74 Mb	20.9 Mb

Hook	Time	Memory Usage
DisplayAfterBodyOpeningTag	244.465 ms	3.37 Mb
=> tvcmscookiesnotice	0.790 ms	0.02 Mb
=> blockreassurance	0.005 ms	- Mb
=> tvcmsproductpopup	243.670 ms	3.35 Mb
DisplayLeftColumn	240.871 ms	4.72 Mb
=> tvcmsleftsideofferbanner	2.799 ms	0.04 Mb
=> tvcmsnewproducts	22.339 ms	0.51 Mb
=> tvcmscustomerservices	4.450 ms	0.13 Mb
=> tvcmsspecialproducts	4.180 ms	0.12 Mb
=> tvcmsfeaturedproducts	74.768 ms	1.47 Mb
=> tvcmsbestsellerproducts	132.335 ms	2.46 Mb
DisplayReviewProductList	61.981 ms	1.29 Mb
=> tvcmsproductcomments	7.191 ms	0.12 Mb
=> tvcmsproductcomments	4.723 ms	0.09 Mb
=> tvcmsproductcomments	7.617 ms	0.09 Mb
=> tvcmsproductcomments	5.047 ms	0.09 Mb
=> tvcmsproductcomments	4.261 ms	0.09 Mb
=> tvcmsproductcomments	4.111 ms	0.13 Mb
=> tvcmsproductcomments	8.329 ms	0.09 Mb
=> tvcmsproductcomments	3.271 ms	0.09 Mb
=> tvcmsproductcomments	3.389 ms	0.09 Mb
=> tvcmsproductcomments	4.008 ms	0.13 Mb
=> tvcmsproductcomments	3.373 ms	0.09 Mb
=> tvcmsproductcomments	3.171 ms	0.09 Mb
=> tvcmsproductcomments	3.490 ms	0.09 Mb
displayNav1	31.667 ms	0.09 Mb
=> ps_contactinfo (widget)	31.667 ms	0.09 Mb
DisplayBeforeBodyClosingTag	27.161 ms	0.15 Mb
=> statsdata	27.159 ms	0.15 Mb
=> tvcmsblog	0.002 ms	- Mb
DisplayMegamenu	13.742 ms	0.47 Mb
=> tvcmsmegamenu	13.742 ms	0.47 Mb
Header	12.256 ms	0.10 Mb
=> tvcmsstockinfo	0.095 ms	- Mb
=> tvcmsinfinitescroll	10.956 ms	0.07 Mb
=> tvcmsleftsideofferbanner	0.001 ms	- Mb
=> tvcmstwoofferbanner	0.095 ms	0.01 Mb
=> tvcmsmegamenu	0.141 ms	- Mb
=> tvcmscategoryproduct	0.141 ms	- Mb
=> nicodemo	0.058 ms	- Mb
=> registrationfields	0.373 ms	0.01 Mb
=> lueur_configuration	0.101 ms	- Mb
=> sql2csvmailex	0.077 ms	- Mb
=> ohmproductpdf	0.056 ms	- Mb
=> lueurexporttable	0.059 ms	- Mb
=> lueur_texthomeandcat	0.103 ms	- Mb
DisplayProductCompareProductList	11.399 ms	0.09 Mb
=> tvcmsproductcompare	1.428 ms	0.02 Mb
=> tvcmsproductcompare	1.452 ms	0.01 Mb
=> tvcmsproductcompare	1.577 ms	0.01 Mb
=> tvcmsproductcompare	1.403 ms	0.01 Mb
=> tvcmsproductcompare	1.430 ms	0.01 Mb
=> tvcmsproductcompare	1.384 ms	0.01 Mb
=> tvcmsproductcompare	1.361 ms	0.01 Mb
=> tvcmsproductcompare	1.364 ms	0.01 Mb
displayLeftColumn	10.460 ms	0.26 Mb
=> ps_categorytree (widget)	9.317 ms	0.18 Mb
=> ps_brandlist (widget)	0.602 ms	0.04 Mb
=> ps_supplierlist (widget)	0.541 ms	0.04 Mb
displayNavShoppingCartBlock	8.695 ms	0.16 Mb
=> ps_shoppingcart (widget)	8.695 ms	0.16 Mb
DisplayWrapperTop	8.219 ms	0.14 Mb
=> tvcmsslider	8.219 ms	0.14 Mb
DisplayHeader	6.745 ms	0.15 Mb
=> ps_shoppingcart	0.040 ms	- Mb
=> ps_searchbar	0.148 ms	- Mb
=> ps_googleanalytics	0.017 ms	- Mb
=> tvcmscategorychainslider	0.066 ms	- Mb
=> tvcmscustomerservices	0.062 ms	- Mb
=> tvcmscustomsetting	0.435 ms	0.01 Mb
=> tvcmsfooterlogo	0.001 ms	- Mb
=> tvcmsfooterproduct	0.045 ms	- Mb
=> tvcmspaymenticon	0.001 ms	- Mb
=> tvcmstabproducts	0.113 ms	- Mb
=> tvcmscategoryslider	0.083 ms	- Mb
=> tvcmsnewsletterpopup	0.196 ms	- Mb
=> tvcmscookiesnotice	0.062 ms	- Mb
=> tvcmsproductcomments	0.181 ms	- Mb
=> tvcmssizechart	0.059 ms	- Mb
=> tvcmsbrandlist	0.072 ms	- Mb
=> tvcmsproductpopup	0.086 ms	- Mb
=> tvcmstestimonial	0.064 ms	- Mb
=> tvcmsblog	0.120 ms	- Mb
=> tvcmsblogdisplayposts	0.089 ms	- Mb
=> tvcmsslider	0.122 ms	- Mb
=> tvcmsmultibanner1	0.102 ms	- Mb
=> tvcmsbestsellerproducts	0.046 ms	- Mb
=> tvcmsfeaturedproducts	0.036 ms	- Mb
=> tvcmsnewproducts	0.042 ms	- Mb
=> tvcmsproductcompare	0.078 ms	- Mb
=> tvcmssearch	0.247 ms	- Mb
=> tvcmsspecialproducts	0.054 ms	- Mb
=> tvcmsthemeoptions	0.221 ms	0.01 Mb
=> ets_affiliatemarketing	3.446 ms	0.08 Mb
=> pstcustomerfilter	0.078 ms	- Mb
=> productbutton	0.080 ms	- Mb
=> insuroption	0.067 ms	- Mb
=> colissimo	0.004 ms	- Mb
=> orderfees_options	0.066 ms	- Mb
=> g_cartreminder	0.116 ms	- Mb
DisplayCustomsocialblock	6.352 ms	0.17 Mb
=> tvcmscustomsetting	6.352 ms	0.17 Mb
DisplayFooter	5.780 ms	0.16 Mb
=> blockwishlist	5.283 ms	0.13 Mb
=> ets_affiliatemarketing	0.015 ms	- Mb
=> g_cartreminder	0.482 ms	0.03 Mb
displayFooterPart1	5.728 ms	0.45 Mb
=> ps_linklist (widget)	5.728 ms	0.45 Mb
DisplayNavSearchBlock	5.412 ms	0.61 Mb
=> tvcmssearch	5.412 ms	0.61 Mb
displayFooterPart2	3.116 ms	0.05 Mb
=> ps_linklist (widget)	3.116 ms	0.05 Mb
displayNavLanguageBlock	2.910 ms	0.08 Mb
=> ps_languageselector (widget)	2.910 ms	0.08 Mb
displayNewslettersubscription	2.344 ms	0.12 Mb
=> ps_emailsubscription (widget)	2.344 ms	0.12 Mb
displayNavCustomerSignInBlock	1.773 ms	0.06 Mb
=> ps_customersignin (widget)	1.773 ms	0.06 Mb
DisplayFooterPart2	1.156 ms	0.03 Mb
=> tvcmsfooterlogo	1.156 ms	0.03 Mb
DisplayFacetedSearchBlock	0.816 ms	0.01 Mb
=> ps_facetedsearch	0.816 ms	0.01 Mb
DisplayNavProductCompareBlock	0.776 ms	0.01 Mb
=> tvcmsproductcompare	0.776 ms	0.01 Mb
DisplayProductComparesticky	0.734 ms	0.01 Mb
=> tvcmsproductcompare	0.734 ms	0.01 Mb
displayNavCurrencyBlock	0.574 ms	0.05 Mb
=> ps_currencyselector (widget)	0.574 ms	0.05 Mb
DisplayTexteCategory	0.568 ms	0.02 Mb
=> lueur_texthomeandcat	0.568 ms	0.02 Mb
ActionCartGetOrderTotal	0.505 ms	0.01 Mb
=> orderfees_options	0.002 ms	- Mb
=> orderfees_options	0.001 ms	- Mb
=> orderfees_options	0.001 ms	- Mb
=> orderfees_options	0.498 ms	0.01 Mb
=> orderfees_options	0.002 ms	- Mb
=> orderfees_options	0.001 ms	- Mb
=> orderfees_options	0.000 ms	- Mb
ActionFrontControllerSetMedia	0.446 ms	0.01 Mb
=> blockreassurance	0.101 ms	- Mb
=> blockwishlist	0.203 ms	- Mb
=> ps_emailsubscription	0.053 ms	- Mb
=> ps_socialfollow	0.058 ms	- Mb
=> ps_emailalerts	0.025 ms	- Mb
=> paybox	0.006 ms	- Mb
DisplayGDPRConsent	0.439 ms	0.03 Mb
=> psgdpr	0.439 ms	0.03 Mb
ProductSearchProvider	0.308 ms	- Mb
=> ps_facetedsearch	0.308 ms	- Mb
ActionPresentCart	0.296 ms	0.01 Mb
=> insuroption	0.296 ms	0.01 Mb
DisplayProductListStockIndicator	0.052 ms	- Mb
=> tvcmsstockinfo	0.019 ms	- Mb
=> tvcmsstockinfo	0.014 ms	- Mb
=> tvcmsstockinfo	0.011 ms	- Mb
=> tvcmsstockinfo	0.008 ms	- Mb
ActionCartGetCartRules	0.031 ms	- Mb
=> orderfees_options	0.008 ms	- Mb
=> orderfees_options	0.008 ms	- Mb
=> orderfees_options	0.006 ms	- Mb
=> orderfees_options	0.004 ms	- Mb
=> orderfees_options	0.005 ms	- Mb
ModuleRoutes	0.026 ms	0.01 Mb
=> tvcmsblog	0.018 ms	0.01 Mb
=> registrationfields	0.003 ms	- Mb
=> colissimo	0.002 ms	- Mb
=> orderfees_options	0.001 ms	- Mb
=> g_cartreminder	0.002 ms	- Mb
DisplayTopOfferText	0.017 ms	- Mb
=> tvcmscustomsetting	0.012 ms	- Mb
=> tvcmscustomsetting	0.005 ms	- Mb
DisplayCustomCss	0.009 ms	- Mb
=> tvcmscustomcssjs	0.009 ms	- Mb
ActionModuleRegisterHookAfter	0.006 ms	- Mb
=> ps_customeraccountlinks	0.002 ms	- Mb
=> ps_customeraccountlinks	0.003 ms	- Mb
=> ps_customeraccountlinks	0.001 ms	- Mb
DisplayCustomJs	0.006 ms	- Mb
=> tvcmscustomcssjs	0.006 ms	- Mb
ActionFrontControllerInitAfter	0.005 ms	- Mb
=> orderfees_options	0.005 ms	- Mb
DisplayNavFullWidth	0.005 ms	- Mb
=> blockreassurance	0.005 ms	- Mb
Footer	0.003 ms	- Mb
=> happybirthday	0.003 ms	- Mb
41 hook(s)	717.854 ms	12.91 Mb

20 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`
19 queries	SELECT `id_product_attribute` FROM `ps_product_attribute` WHERE `id_product` = XX
18 queries	SELECT p., ps., pl.*, sa.out_of_stock, IFNULL(sa.quantity, XX) as quantity, (DATEDIFF( p.`date_add`, DATE_SUB( 'XX-XX-XX XX:XX:XX', INTERVAL XX DAY ) ) > XX) as new FROM ps_product p LEFT JOIN ps_product_lang pl ON pl.id_product = p.id_product AND pl.id_shop = XX AND pl.id_lang = XX LEFT JOIN ps_stock_available sa ON sa.id_product = p.id_product AND sa.id_product_attribute = XX AND sa.id_shop = XX LEFT JOIN ps_product_shop ps ON ps.id_product = p.id_product AND ps.id_shop = XX WHERE p.id_product IN (XX)
16 queries	SELECT `id_module` FROM `ps_module_shop` WHERE `id_module` = XX AND `id_shop` = XX LIMIT XX
14 queries	SELECT XX FROM `ps_specific_price` WHERE id_product = XX LIMIT XX
14 queries	SELECT mr.* FROM ps_tvcmsmegamenu_row_shop mr WHERE mr.`id_shop` = XX AND mr.id_tvcmsmegamenu = XX AND mr.`active` = XX
13 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
13 queries	SELECT name FROM ps_category_lang WHERE id_shop = XX AND id_lang = XX AND 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
13 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)
13 queries	SELECT `id_tax_rules_group` FROM `ps_product_shop` WHERE `id_product` = XX AND id_shop=XX LIMIT XX
13 queries	SELECT `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = XX AND `id_group` = XX LIMIT XX
13 queries	SELECT COUNT(*) FROM `ps_pack` WHERE id_product_pack = XX LIMIT XX
13 queries	SELECT product_type FROM `ps_product` WHERE id_product = XX LIMIT XX
13 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
13 queries	SELECT COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), XX) as deep_quantity, COALESCE(SUM(first_level_quantity), XX) as quantity FROM (SELECT cp.`quantity` as first_level_quantity, XX as pack_quantity FROM `ps_cart_product` cp WHERE cp.`id_product_attribute` = XX AND cp.`id_customization` = XX AND cp.`id_cart` = XX AND cp.`id_product` = XX UNION SELECT XX as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity FROM `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_customization` = XX AND cp.`id_cart` = XX AND p.`id_product_item` = XX AND (pr.`pack_stock_type` IN (XX,XX) OR ( pr.`pack_stock_type` = XX AND XX = XX ))) as q LIMIT XX
13 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
13 queries	SELECT (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS grade FROM `ps_tvcmsproduct_comment` pc WHERE pc.`id_product` = XX AND pc.`deleted` = XX AND pc.`validate` = XX LIMIT XX
13 queries	SELECT (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS avg, MIN(pc.`grade`) AS min, MAX(pc.`grade`) AS max FROM `ps_tvcmsproduct_comment` pc WHERE pc.`id_product` = XX AND pc.`deleted` = XX AND pc.`validate` = XX LIMIT XX
12 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
12 queries	SELECT *, ( IF (`id_shop` = XX, XX, XX) + IF (`id_country` = XX, XX, XX) + IF (`id_currency` = XX, XX, XX) + IF (`id_group` = XX, XX, XX) + IF (`id_customer` = XX, XX, XX)) AS `score` FROM `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
7 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
7 queries	SELECT COUNT(`id_tvcmsproduct_comment`) AS "nbr" FROM `ps_tvcmsproduct_comment` pc WHERE `id_product` = XX AND `validate` = XX LIMIT XX
6 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
5 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
5 queries	SELECT quantity, reserved_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
5 queries	SELECT pa.`id_product`, a.`color`, pac.`id_product_attribute`, XX qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by FROM `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) 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` ORDER BY a.`position` ASC;
3 queries	SELECT * FROM ps_hook_module WHERE `id_hook` = XX AND `id_module` = XX AND `id_shop` = XX
2 queries	SELECT * FROM `ps_lang` a LEFT JOIN `ps_lang_shop` `c` ON a.`id_lang` = c.`id_lang` AND c.`id_shop` = XX WHERE (a.`id_lang` = XX) LIMIT XX
2 queries	SELECT id_shop FROM `ps_lang_shop` WHERE `id_lang` = XX AND id_shop = XX LIMIT XX
2 queries	SELECT `id_lang` FROM `ps_lang` WHERE `locale` = 'en-gb' OR `language_code` = 'en-gb' LIMIT XX
2 queries	SELECT ctg.`id_group` FROM ps_category_group ctg WHERE ctg.`id_category` = XX AND ctg.`id_group` = XX LIMIT 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 SUM(total_price) AS total, SUM(total_price_wt) AS total_wt FROM `ps_insuroption_cart` WHERE (`id_cart` = XX) LIMIT XX
2 queries	SELECT `need_identification_number` FROM `ps_country` WHERE `id_country` = XX LIMIT XX
2 queries	SELECT `name` FROM `ps_hook` WHERE `id_hook` = XX LIMIT XX
2 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
2 queries	SELECT * FROM `ps_category_lang` WHERE `id_category` = XX AND `id_shop` = XX
2 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
2 queries	SELECT p., product_shop., stock.out_of_stock, IFNULL(stock.quantity, XX) as quantity, product_attribute_shop.minimal_quantity AS product_attribute_minimal_quantity,IFNULL(product_attribute_shop.id_product_attribute,XX) id_product_attribute, pl.`description`, pl.`description_short`, pl.`link_rewrite`, pl.`meta_description`, pl.`meta_keywords`, pl.`meta_title`, pl.`name`, pl.`available_now`, pl.`available_later`, m.`name` AS manufacturer_name, p.`id_manufacturer` as id_manufacturer, image_shop.`id_image` id_image, il.`legend`, ps.`quantity` AS sales, t.`rate`, pl.`meta_keywords`, pl.`meta_title`, pl.`meta_description`, DATEDIFF(p.`date_add`, DATE_SUB("XX-XX-XX XX:XX:XX", INTERVAL XX DAY)) > XX AS new FROM `ps_product_sale` ps LEFT JOIN `ps_product` p ON ps.`id_product` = p.`id_product` LEFT 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 (p.`id_product` = product_attribute_shop.`id_product` AND product_attribute_shop.`default_on` = XX AND product_attribute_shop.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_tax_rule` tr ON (product_shop.`id_tax_rules_group` = tr.`id_tax_rules_group`) AND tr.`id_country` = XX AND tr.`id_state` = XX LEFT JOIN `ps_tax` t ON (t.`id_tax` = tr.`id_tax`) 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.`active` = XX AND product_shop.`visibility` != 'none' AND EXISTS(SELECT XX FROM `ps_category_product` cp JOIN `ps_category_group` cg ON (cp.id_category = cg.id_category AND cg.`id_group` =XX) WHERE cp.`id_product` = p.`id_product`) ORDER BY `sales` DESC LIMIT XX, XX
2 queries	SELECT COUNT(ps.`id_product`) AS nb FROM `ps_product_sale` ps LEFT JOIN `ps_product` p ON p.`id_product` = ps.`id_product` LEFT JOIN ps_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = XX) WHERE product_shop.`active` = XX LIMIT XX
2 queries	SELECT lb.`id_link_block` FROM ps_link_block lb INNER JOIN ps_link_block_shop lbs ON lbs.`id_link_block` = lb.`id_link_block` WHERE lb. `id_hook` = XX AND lbs.`id_shop` = XX ORDER by lbs.`position`
2 queries	SELECT * FROM `ps_link_block` a LEFT JOIN `ps_link_block_shop` `c` ON a.`id_link_block` = c.`id_link_block` AND c.`id_shop` = XX WHERE (a.`id_link_block` = XX) LIMIT XX
2 queries	SELECT * FROM `ps_link_block_lang` WHERE `id_link_block` = XX
2 queries	SELECT * FROM `ps_hook` a WHERE (a.`id_hook` = XX) LIMIT XX
2 queries	SELECT * FROM `ps_cms` a LEFT JOIN `ps_cms_shop` `c` ON a.`id_cms` = c.`id_cms` AND c.`id_shop` = XX WHERE (a.`id_cms` = XX) LIMIT XX
2 queries	SELECT * FROM `ps_cms_lang` WHERE `id_cms` = XX AND `id_shop` = XX

Omégabio 3

Cholestérobio

Néréïdobio

Glutaminobio

Hémocromatobio

Hépatobio

Vitamine D3+

Mgbio

Mélatoninobio

Mélatoninobio

Mélatoninobio

Mélatoninobio

Sérotoninobio

Sérotoninobio

Sérotoninobio

Sérotoninobio

Stopwatch SQL - 476 queries

Doubles

Tables stress

ObjectModel instances

Included Files

Module	Time	Memory Usage
tvcmsblog	3.310 ms	0.05 Mb
__construct	3.166 ms	0.04 Mb
hookModuleRoutes	0.020 ms	0.01 Mb
hookDisplayHeader	0.121 ms	- Mb
hookDisplayBeforeBodyClosingTag	0.003 ms	- Mb
registrationfields	10.579 ms	0.05 Mb
__construct	10.199 ms	0.04 Mb
hookModuleRoutes	0.005 ms	- Mb
hookHeader	0.375 ms	0.01 Mb
colissimo	3.953 ms	0.16 Mb
__construct	3.943 ms	0.16 Mb
hookModuleRoutes	0.004 ms	- Mb
hookDisplayHeader	0.006 ms	- Mb
orderfees_options	35.475 ms	0.04 Mb
__construct	34.846 ms	0.01 Mb
hookModuleRoutes	0.003 ms	- Mb
hookActionFrontControllerInitAfter	0.007 ms	- Mb
hookActionCartGetOrderTotal	0.004 ms	- Mb
hookActionCartGetCartRules	0.009 ms	- Mb
hookActionCartGetOrderTotal	0.003 ms	- Mb
hookActionCartGetOrderTotal	0.002 ms	- Mb
hookActionCartGetOrderTotal	0.500 ms	0.01 Mb
hookActionCartGetCartRules	0.009 ms	- Mb
hookActionCartGetOrderTotal	0.003 ms	- Mb
hookActionCartGetCartRules	0.007 ms	- Mb
hookActionCartGetOrderTotal	0.002 ms	- Mb
hookActionCartGetOrderTotal	0.001 ms	- Mb
hookActionCartGetCartRules	0.006 ms	- Mb
hookActionCartGetCartRules	0.006 ms	- Mb
hookDisplayHeader	0.067 ms	- Mb
g_cartreminder	6.630 ms	0.06 Mb
__construct	6.026 ms	0.02 Mb
hookModuleRoutes	0.003 ms	- Mb
hookDisplayHeader	0.117 ms	- Mb
hookDisplayFooter	0.484 ms	0.03 Mb
blockreassurance	1.020 ms	0.09 Mb
__construct	0.905 ms	0.08 Mb
hookActionFrontControllerSetMedia	0.103 ms	- Mb
hookDisplayAfterBodyOpeningTag	0.006 ms	- Mb
hookDisplayNavFullWidth	0.006 ms	- Mb
blockwishlist	5.552 ms	0.14 Mb
__construct	0.062 ms	0.01 Mb
hookActionFrontControllerSetMedia	0.205 ms	- Mb
hookDisplayFooter	5.285 ms	0.13 Mb
ps_emailsubscription	2.465 ms	0.13 Mb
__construct	0.065 ms	0.01 Mb
hookActionFrontControllerSetMedia	0.055 ms	- Mb
displayNewslettersubscription	2.345 ms	0.12 Mb
ps_socialfollow	0.120 ms	0.01 Mb
__construct	0.060 ms	0.01 Mb
hookActionFrontControllerSetMedia	0.060 ms	- Mb
ps_emailalerts	0.093 ms	0.01 Mb
__construct	0.067 ms	0.01 Mb
hookActionFrontControllerSetMedia	0.026 ms	- Mb
paybox	1.170 ms	0.15 Mb
__construct	1.163 ms	0.14 Mb
hookActionFrontControllerSetMedia	0.007 ms	- Mb
ps_customeraccountlinks	0.062 ms	0.01 Mb
__construct	0.052 ms	0.01 Mb
hookActionModuleRegisterHookAfter	0.003 ms	- Mb
hookActionModuleRegisterHookAfter	0.005 ms	- Mb
hookActionModuleRegisterHookAfter	0.002 ms	- Mb
insuroption	4.536 ms	0.24 Mb
__construct	4.169 ms	0.23 Mb
hookActionPresentCart	0.298 ms	0.01 Mb
hookDisplayHeader	0.069 ms	- Mb
ps_shoppingcart	8.791 ms	0.17 Mb
__construct	0.052 ms	0.01 Mb
hookDisplayHeader	0.042 ms	- Mb
displayNavShoppingCartBlock	8.697 ms	0.16 Mb
ps_searchbar	0.196 ms	0.01 Mb
__construct	0.047 ms	0.01 Mb
hookDisplayHeader	0.149 ms	- Mb
ps_googleanalytics	0.066 ms	0.01 Mb
__construct	0.048 ms	0.01 Mb
hookDisplayHeader	0.018 ms	- Mb
tvcmscategorychainslider	0.144 ms	0.01 Mb
__construct	0.077 ms	0.01 Mb
hookDisplayHeader	0.067 ms	- Mb
tvcmscustomerservices	4.577 ms	0.13 Mb
__construct	0.063 ms	0.01 Mb
hookDisplayHeader	0.063 ms	- Mb
hookDisplayLeftColumn	4.451 ms	0.13 Mb
tvcmscustomsetting	6.877 ms	0.20 Mb
__construct	0.067 ms	0.01 Mb
hookDisplayHeader	0.437 ms	0.01 Mb
hookDisplayTopOfferText	0.013 ms	- Mb
hookDisplayTopOfferText	0.007 ms	- Mb
hookDisplayCustomsocialblock	6.353 ms	0.17 Mb
tvcmsfooterlogo	1.251 ms	0.03 Mb
__construct	0.091 ms	0.01 Mb
hookDisplayHeader	0.002 ms	- Mb
hookDisplayFooterPart2	1.158 ms	0.03 Mb
tvcmsfooterproduct	0.134 ms	0.01 Mb
__construct	0.088 ms	0.01 Mb
hookDisplayHeader	0.046 ms	- Mb
tvcmspaymenticon	0.067 ms	0.01 Mb
__construct	0.065 ms	0.01 Mb
hookDisplayHeader	0.002 ms	- Mb
tvcmsstockinfo	0.210 ms	0.01 Mb
__construct	0.056 ms	0.01 Mb
hookHeader	0.097 ms	- Mb
hookDisplayProductListStockIndicator	0.020 ms	- Mb
hookDisplayProductListStockIndicator	0.016 ms	- Mb
hookDisplayProductListStockIndicator	0.012 ms	- Mb
hookDisplayProductListStockIndicator	0.009 ms	- Mb
tvcmstabproducts	0.193 ms	0.01 Mb
__construct	0.079 ms	0.01 Mb
hookDisplayHeader	0.114 ms	- Mb
tvcmscategoryslider	0.173 ms	0.01 Mb
__construct	0.089 ms	0.01 Mb
hookDisplayHeader	0.084 ms	- Mb
tvcmsnewsletterpopup	0.271 ms	0.01 Mb
__construct	0.073 ms	0.01 Mb
hookDisplayHeader	0.198 ms	- Mb
tvcmscookiesnotice	0.928 ms	0.02 Mb
__construct	0.072 ms	0.01 Mb
hookDisplayHeader	0.063 ms	- Mb
hookDisplayAfterBodyOpeningTag	0.793 ms	0.02 Mb
tvcmsproductcomments	62.263 ms	1.31 Mb
__construct	0.069 ms	0.01 Mb
hookDisplayHeader	0.182 ms	- Mb
hookDisplayReviewProductList	7.193 ms	0.12 Mb
hookDisplayReviewProductList	4.725 ms	0.09 Mb
hookDisplayReviewProductList	7.620 ms	0.09 Mb
hookDisplayReviewProductList	5.049 ms	0.09 Mb
hookDisplayReviewProductList	4.262 ms	0.09 Mb
hookDisplayReviewProductList	4.114 ms	0.13 Mb
hookDisplayReviewProductList	8.332 ms	0.09 Mb
hookDisplayReviewProductList	3.274 ms	0.09 Mb
hookDisplayReviewProductList	3.392 ms	0.09 Mb
hookDisplayReviewProductList	4.010 ms	0.13 Mb
hookDisplayReviewProductList	3.376 ms	0.09 Mb
hookDisplayReviewProductList	3.173 ms	0.09 Mb
hookDisplayReviewProductList	3.492 ms	0.09 Mb
tvcmssizechart	0.120 ms	0.01 Mb
__construct	0.060 ms	0.01 Mb
hookDisplayHeader	0.060 ms	- Mb
tvcmsbrandlist	0.132 ms	0.01 Mb
__construct	0.059 ms	0.01 Mb
hookDisplayHeader	0.073 ms	- Mb
tvcmsproductpopup	243.813 ms	3.36 Mb
__construct	0.053 ms	0.01 Mb
hookDisplayHeader	0.088 ms	- Mb
hookDisplayAfterBodyOpeningTag	243.672 ms	3.35 Mb
tvcmstestimonial	0.145 ms	0.07 Mb
__construct	0.080 ms	0.07 Mb
hookDisplayHeader	0.065 ms	- Mb
tvcmsblogdisplayposts	0.224 ms	0.01 Mb
__construct	0.134 ms	0.01 Mb
hookDisplayHeader	0.090 ms	- Mb
tvcmsslider	8.455 ms	0.15 Mb
__construct	0.109 ms	0.01 Mb
hookDisplayHeader	0.124 ms	- Mb
hookDisplayWrapperTop	8.222 ms	0.14 Mb
tvcmsmultibanner1	0.194 ms	0.01 Mb
__construct	0.090 ms	0.01 Mb
hookDisplayHeader	0.104 ms	- Mb
tvcmsbestsellerproducts	132.472 ms	2.47 Mb
__construct	0.087 ms	0.01 Mb
hookDisplayHeader	0.047 ms	- Mb
hookDisplayLeftColumn	132.338 ms	2.46 Mb
tvcmsfeaturedproducts	74.870 ms	1.48 Mb
__construct	0.062 ms	0.01 Mb
hookDisplayHeader	0.037 ms	- Mb
hookDisplayLeftColumn	74.771 ms	1.47 Mb
tvcmsnewproducts	22.438 ms	0.52 Mb
__construct	0.054 ms	0.01 Mb
hookDisplayHeader	0.043 ms	- Mb
hookDisplayLeftColumn	22.341 ms	0.51 Mb
tvcmsproductcompare	13.080 ms	0.13 Mb
__construct	0.070 ms	0.01 Mb
hookDisplayHeader	0.079 ms	- Mb
hookDisplayNavProductCompareBlock	0.778 ms	0.01 Mb
hookDisplayProductCompareProductList	1.430 ms	0.02 Mb
hookDisplayProductCompareProductList	1.455 ms	0.01 Mb
hookDisplayProductCompareProductList	1.579 ms	0.01 Mb
hookDisplayProductCompareProductList	1.406 ms	0.01 Mb
hookDisplayProductCompareProductList	1.432 ms	0.01 Mb
hookDisplayProductCompareProductList	1.386 ms	0.01 Mb
hookDisplayProductCompareProductList	1.363 ms	0.01 Mb
hookDisplayProductCompareProductList	1.366 ms	0.01 Mb
hookDisplayProductComparesticky	0.736 ms	0.01 Mb
tvcmssearch	5.751 ms	0.62 Mb
__construct	0.088 ms	0.01 Mb
hookDisplayHeader	0.249 ms	- Mb
hookDisplayNavSearchBlock	5.414 ms	0.61 Mb
tvcmsspecialproducts	4.325 ms	0.13 Mb
__construct	0.088 ms	0.01 Mb
hookDisplayHeader	0.055 ms	- Mb
hookDisplayLeftColumn	4.182 ms	0.12 Mb
tvcmsthemeoptions	0.304 ms	0.01 Mb
__construct	0.081 ms	0.01 Mb
hookDisplayHeader	0.223 ms	0.01 Mb
ets_affiliatemarketing	3.892 ms	0.14 Mb
__construct	0.428 ms	0.06 Mb
hookDisplayHeader	3.448 ms	0.08 Mb
hookDisplayFooter	0.016 ms	- Mb
pstcustomerfilter	0.191 ms	0.01 Mb
__construct	0.111 ms	0.01 Mb
hookDisplayHeader	0.080 ms	- Mb
productbutton	0.183 ms	0.01 Mb
__construct	0.102 ms	0.01 Mb
hookDisplayHeader	0.081 ms	- Mb
tvcmsinfinitescroll	11.038 ms	0.08 Mb
__construct	0.080 ms	0.01 Mb
hookHeader	10.958 ms	0.07 Mb
tvcmsleftsideofferbanner	2.943 ms	0.05 Mb
__construct	0.140 ms	0.01 Mb
hookHeader	0.002 ms	- Mb
hookDisplayLeftColumn	2.801 ms	0.04 Mb
tvcmstwoofferbanner	0.187 ms	0.08 Mb
__construct	0.091 ms	0.07 Mb
hookHeader	0.096 ms	0.01 Mb
tvcmsmegamenu	13.993 ms	0.49 Mb
__construct	0.107 ms	0.01 Mb
hookHeader	0.142 ms	- Mb
hookDisplayMegamenu	13.744 ms	0.48 Mb
tvcmscategoryproduct	0.228 ms	0.01 Mb
__construct	0.085 ms	0.01 Mb
hookHeader	0.143 ms	- Mb
nicodemo	0.123 ms	0.01 Mb
__construct	0.064 ms	0.01 Mb
hookHeader	0.059 ms	- Mb
lueur_configuration	0.832 ms	- Mb
__construct	0.729 ms	- Mb
hookHeader	0.103 ms	- Mb
sql2csvmailex	0.175 ms	0.01 Mb
__construct	0.097 ms	0.01 Mb
hookHeader	0.078 ms	- Mb
ohmproductpdf	0.127 ms	0.01 Mb
__construct	0.070 ms	0.01 Mb
hookHeader	0.057 ms	- Mb
lueurexporttable	0.112 ms	0.01 Mb
__construct	0.052 ms	0.01 Mb
hookHeader	0.060 ms	- Mb
lueur_texthomeandcat	3.725 ms	0.08 Mb
__construct	3.051 ms	0.06 Mb
hookHeader	0.104 ms	- Mb
hookDisplayTexteCategory	0.570 ms	0.02 Mb
ps_facetedsearch	1.434 ms	0.03 Mb
__construct	0.307 ms	0.02 Mb
hookProductSearchProvider	0.309 ms	- Mb
hookDisplayFacetedSearchBlock	0.818 ms	0.01 Mb
tvcmscustomcssjs	0.122 ms	0.01 Mb
__construct	0.104 ms	0.01 Mb
hookDisplayCustomCss	0.011 ms	- Mb
hookDisplayCustomJs	0.007 ms	- Mb
ps_languageselector	2.975 ms	0.15 Mb
__construct	0.063 ms	0.07 Mb
displayNavLanguageBlock	2.912 ms	0.08 Mb
ps_currencyselector	0.629 ms	0.06 Mb
__construct	0.053 ms	0.01 Mb
displayNavCurrencyBlock	0.576 ms	0.05 Mb
ps_customersignin	1.832 ms	0.07 Mb
__construct	0.056 ms	0.01 Mb
displayNavCustomerSignInBlock	1.776 ms	0.07 Mb
ps_contactinfo	31.722 ms	0.09 Mb
__construct	0.052 ms	0.01 Mb
displayNav1	31.670 ms	0.09 Mb
ps_categorytree	9.373 ms	0.18 Mb
__construct	0.054 ms	0.01 Mb
displayLeftColumn	9.319 ms	0.18 Mb
ps_brandlist	0.666 ms	0.05 Mb
__construct	0.062 ms	0.01 Mb
displayLeftColumn	0.604 ms	0.04 Mb
ps_supplierlist	0.598 ms	0.05 Mb
__construct	0.055 ms	0.01 Mb
displayLeftColumn	0.543 ms	0.04 Mb
happybirthday	0.089 ms	0.01 Mb
__construct	0.084 ms	0.01 Mb
hookFooter	0.005 ms	- Mb
psgdpr	0.539 ms	0.04 Mb
__construct	0.098 ms	0.01 Mb
hookDisplayGDPRConsent	0.441 ms	0.03 Mb
ps_linklist	9.023 ms	0.58 Mb
__construct	0.175 ms	0.07 Mb
displayFooterPart1	5.730 ms	0.45 Mb
displayFooterPart2	3.118 ms	0.05 Mb
statsdata	27.209 ms	0.16 Mb
__construct	0.048 ms	0.01 Mb
hookDisplayBeforeBodyClosingTag	27.161 ms	0.15 Mb
69 module(s)	791.391 ms	14.49 Mb

Name	Instances	Source
Product	48	/classes/Link.php:113 (__construct) [id: 157] /classes/Link.php:113 (__construct) [id: 93] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 157] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 93] /classes/Link.php:113 (__construct) [id: 157] /classes/Link.php:113 (__construct) [id: 93] /classes/Link.php:113 (__construct) [id: 77] /classes/Link.php:113 (__construct) [id: 35] /classes/Link.php:113 (__construct) [id: 76] /classes/Link.php:113 (__construct) [id: 54] /classes/Link.php:113 (__construct) [id: 55] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 77] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 35] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 76] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 54] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 55] /classes/Link.php:113 (__construct) [id: 77] /classes/Link.php:113 (__construct) [id: 35] /classes/Link.php:113 (__construct) [id: 76] /classes/Link.php:113 (__construct) [id: 54] /classes/Link.php:113 (__construct) [id: 55] /classes/Link.php:113 (__construct) [id: 178] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 178] /classes/Link.php:113 (__construct) [id: 106] /classes/Link.php:113 (__construct) [id: 38] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 106] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 38] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 35] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 55] /classes/Link.php:113 (__construct) [id: 56] /classes/Link.php:113 (__construct) [id: 119] /classes/Link.php:113 (__construct) [id: 69] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 77] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 35] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 76] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 54] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 55] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 56] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 119] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 69] /classes/Link.php:113 (__construct) [id: 77] /classes/Link.php:113 (__construct) [id: 35] /classes/Link.php:113 (__construct) [id: 76] /classes/Link.php:113 (__construct) [id: 54] /classes/Link.php:113 (__construct) [id: 55] /classes/Link.php:113 (__construct) [id: 56] /classes/Link.php:113 (__construct) [id: 119] /classes/Link.php:113 (__construct) [id: 69]
Category	26	/controllers/front/listing/CategoryController.php:78 (__construct) [id: 174] /classes/Meta.php:380 (__construct) [id: 174] /classes/Link.php:402 (__construct) [id: 174] /classes/Link.php:402 (__construct) [id: 174] /classes/Link.php:402 (__construct) [id: 174] /classes/Link.php:402 (__construct) [id: 174] /classes/PrestaShopCollection.php:385 (hydrateCollection) [id: ] /classes/PrestaShopCollection.php:385 (hydrateCollection) [id: ] /classes/PrestaShopCollection.php:385 (hydrateCollection) [id: ] /classes/PrestaShopCollection.php:385 (hydrateCollection) [id: ] /classes/Link.php:402 (__construct) [id: 174] /modules/ps_facetedsearch/src/Product/Search.php:365 (__construct) [id: 174] /classes/Link.php:402 (__construct) [id: 174] /classes/Link.php:402 (__construct) [id: 174] /classes/Link.php:402 (__construct) [id: 174] /classes/Link.php:402 (__construct) [id: 174] /classes/Link.php:402 (__construct) [id: 174] /classes/Link.php:402 (__construct) [id: 174] /classes/Link.php:402 (__construct) [id: 174] /classes/Link.php:402 (__construct) [id: 174] /modules/tvcmssearch/tvcmssearch.php:102 (getNestedCategories) [id: 2] /classes/Link.php:402 (__construct) [id: 15] /modules/tvcmsmegamenu/tvcmsmegamenu.php:1702 (__construct) [id: 15] /modules/ps_categorytree/ps_categorytree.php:364 (getParentsCategories) [id: 2] /modules/tvcmstabproducts/tvcmstabproducts.php:2683 (__construct) [id: 18] /classes/Link.php:402 (__construct) [id: 18]
Country	5	/config/config.inc.php:146 (__construct) [id: 8] /classes/AddressFormat.php:404 (__construct) [id: 147] /classes/controller/FrontController.php:1760 (__construct) [id: 147] /classes/AddressFormat.php:404 (__construct) [id: 147] /modules/ps_contactinfo/ps_contactinfo.php:105 (__construct) [id: 147]
Address	4	/classes/shop/Shop.php:486 (__construct) [id: ] /classes/Product.php:3694 (initialize) [id: ] /classes/Product.php:3804 (__construct) [id: ] /classes/Product.php:5945 (__construct) [id: ]
CMS	3	/modules/ps_linklist/src/Presenter/LinkBlockPresenter.php:138 (__construct) [id: 2] /modules/ps_linklist/src/Presenter/LinkBlockPresenter.php:138 (__construct) [id: 3] /modules/ps_linklist/src/Presenter/LinkBlockPresenter.php:138 (__construct) [id: 0]
Language	3	/config/config.inc.php:211 (__construct) [id: 1] /classes/Tools.php:641 (__construct) [id: 4] /classes/Tools.php:560 (__construct) [id: 4]
Hook	2	/modules/ps_linklist/src/Presenter/LinkBlockPresenter.php:64 (__construct) [id: 952] /modules/ps_linklist/src/Presenter/LinkBlockPresenter.php:64 (__construct) [id: 960]
PrestaShop\Module\LinkList\Model\LinkBlock	2	/modules/ps_linklist/src/LegacyLinkBlockRepository.php:91 (__construct) [id: 2] /modules/ps_linklist/src/LegacyLinkBlockRepository.php:91 (__construct) [id: 3]
Currency	2	/src/Adapter/Currency/CurrencyDataProvider.php:101 (__construct) [id: 1] /classes/Tools.php:690 (getCurrencyInstance) [id: 1]
Cart	2	/classes/controller/FrontController.php:465 (__construct) [id: ] /classes/controller/FrontController.php:534 (__construct) [id: ]
AddressFormat	2	/classes/controller/FrontController.php:1754 (generateAddress) [id: ] /modules/ps_contactinfo/ps_contactinfo.php:91 (generateAddress) [id: ]
State	2	/classes/controller/FrontController.php:1759 (__construct) [id: 0] /modules/ps_contactinfo/ps_contactinfo.php:94 (__construct) [id: 0]
Shop	1	/config/config.inc.php:117 (initialize) [id: 1]
GnotificationModel	1	/modules/g_cartreminder/g_cartreminder.php:505 (__construct) [id: 1]
TvcmsMegaMenuClass	1	/modules/tvcmsmegamenu/tvcmsmegamenu.php:1386 (__construct) [id: ]
Risk	1	/classes/controller/FrontController.php:1687 (__construct) [id: ]
Tax	1	/classes/tax/TaxRulesTaxManager.php:116 (__construct) [id: 32]
Gender	1	/classes/controller/FrontController.php:1684 (__construct) [id: 0]
Group	1	/classes/Cart.php:272 (getCurrent) [id: 1]
Fields	1	/modules/registrationfields/registrationfields.php:57 (__construct) [id: ]
Customer	1	/config/config.inc.php:264 (__construct) [id: ]
ShopGroup	1	/classes/shop/Shop.php:561 (__construct) [id: 1]
ConnectionsSource	1	/modules/statsdata/statsdata.php:119 (logHttpReferer) [id: ]

#	Query	Time (ms)	Rows	Filesort	Group By	Location
2	SELECT SQL_NO_CACHE c.`name`, cl.`id_lang`, IF(cl.`id_lang` IS NULL, c.`value`, cl.`value`) AS value, c.id_shop_group, c.id_shop FROM `ps_configuration` c LEFT JOIN `ps_configuration_lang` cl ON (c.`id_configuration` = cl.`id_configuration`)	70.264 ms	4996			/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)
355	SELECT SQL_NO_CACHE p., product_shop., stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, product_attribute_shop.minimal_quantity AS product_attribute_minimal_quantity,IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, pl.`description`, pl.`description_short`, pl.`link_rewrite`, pl.`meta_description`, pl.`meta_keywords`, pl.`meta_title`, pl.`name`, pl.`available_now`, pl.`available_later`, m.`name` AS manufacturer_name, p.`id_manufacturer` as id_manufacturer, image_shop.`id_image` id_image, il.`legend`, ps.`quantity` AS sales, t.`rate`, pl.`meta_keywords`, pl.`meta_title`, pl.`meta_description`, DATEDIFF(p.`date_add`, DATE_SUB("2026-04-22 00:00:00", INTERVAL 1000 DAY)) > 0 AS new FROM `ps_product_sale` ps LEFT JOIN `ps_product` p ON ps.`id_product` = p.`id_product` LEFT 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_shop` product_attribute_shop ON (p.`id_product` = product_attribute_shop.`id_product` AND product_attribute_shop.`default_on` = 1 AND product_attribute_shop.id_shop=1) LEFT JOIN `ps_product_lang` pl ON p.`id_product` = pl.`id_product` AND pl.`id_lang` = 4 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` = 4) LEFT JOIN `ps_manufacturer` m ON (m.`id_manufacturer` = p.`id_manufacturer`) LEFT JOIN `ps_tax_rule` tr ON (product_shop.`id_tax_rules_group` = tr.`id_tax_rules_group`) AND tr.`id_country` = 8 AND tr.`id_state` = 0 LEFT JOIN `ps_tax` t ON (t.`id_tax` = tr.`id_tax`) 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.`active` = 1 AND product_shop.`visibility` != 'none' AND EXISTS(SELECT 1 FROM `ps_category_product` cp JOIN `ps_category_group` cg ON (cp.id_category = cg.id_category AND cg.`id_group` =1) WHERE cp.`id_product` = p.`id_product`) ORDER BY `sales` DESC LIMIT 0, 8	66.379 ms	882	Yes		/classes/ProductSale.php:151 /src/Adapter/BestSales/BestSalesProductSearchProvider.php:74 (getBestSales) /modules/tvcmstabproducts/tvcmstabproducts.php:2886 (runQuery) /modules/tvcmsbestsellerproducts/tvcmsbestsellerproducts.php:156 (displayBestSellers) /modules/tvcmsbestsellerproducts/tvcmsbestsellerproducts.php:268 (showFrontSideResult) /classes/Hook.php:1043 (hookdisplayLeftColumn) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:418 (coreCallHook) /classes/Hook.php:981 (callHookOn) /config/smarty.config.inc.php:198 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/prod/smarty/compile/v1_sephora_8_childlayouts_layout_left_column_tpl/99/cb/cf/99cbcf91ff0d17ac022bac38a72e3bacccc49337_2.file.product-list.tpl.php:124 (__call) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:186 (process) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/v1_sephora_8_childlayouts_layout_left_column_tpl/5c/9a/3c/5c9a3c3c5235861686a150a91d53b1f80c7aa467_2.file.layout-left-column.tpl.php:70 (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/prod/smarty/compile/v1_sephora_8_childlayouts_layout_left_column_tpl/4b/9b/63/4b9b638828d2aae72bd0a2f4d1249de65e7ff7e8_2.file.layout-both-columns.tpl.php:78 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69e8b8137e8bd0_02327563) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/v1_sephora_8_childlayouts_layout_left_column_tpl/5c/9a/3c/5c9a3c3c5235861686a150a91d53b1f80c7aa467_2.file.layout-left-column.tpl.php:28 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69e8b8137d57b8_46913727) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/v1_sephora_8_childlayouts_layout_left_column_tpl/99/cb/cf/99cbcf91ff0d17ac022bac38a72e3bacccc49337_2.file.product-list.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69e8b8137d0c18_34258467) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/v1_sephora_8_childlayouts_layout_left_column_tpl/1c/87/64/1c8764be2398138682bcd94e853ed739be6f2e64_2.file.category.tpl.php:31 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69e8b8137c1283_25875336) /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/controller/FrontController.php:753 (fetch) /classes/controller/FrontController.php:735 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
23	SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module`as `mshop` FROM `ps_module` m LEFT JOIN `ps_module_shop` ms ON m.`id_module` = ms.`id_module` AND ms.`id_shop` = 1	34.604 ms	130			/classes/module/Module.php:345 /modules/orderfees_options/helpers/motionseed-module/MotionSeedModule.php:23 (__construct) /modules/orderfees_options/orderfees_options.php:39 (__construct) :undefined (__construct) /src/Core/Foundation/IoC/Container.php:123 (newInstance) /src/Core/Foundation/IoC/Container.php:153 (makeInstanceFromClassName) /src/Core/Foundation/IoC/Container.php:166 (doMake) /src/Adapter/ServiceLocator.php:70 (make) /classes/module/Module.php:1235 (get) /tools/profiling/Module.php:35 (coreLoadModule) /classes/module/Module.php:1214 (coreLoadModule) /classes/Hook.php:966 (getInstanceByName) /classes/Dispatcher.php:606 (exec) /classes/Dispatcher.php:243 (loadRoutes) /classes/Dispatcher.php:201 (__construct) /index.php:28 (getInstance)
313	SELECT SQL_NO_CACHE 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 = 1) WHERE i.`id_product` = 106 AND image_shop.`cover` = 1 LIMIT 1	34.383 ms	1			/classes/Product.php:3570 /classes/Product.php:5626 (getCover) /classes/Product.php:5971 (getProductProperties) /classes/Category.php:1074 (getProductsProperties) /src/Adapter/Category/CategoryProductSearchProvider.php:79 (getProducts) /src/Adapter/Category/CategoryProductSearchProvider.php:105 (getProductsOrCount) /modules/tvcmstabproducts/tvcmstabproducts.php:2708 (runQuery) /modules/tvcmsfeaturedproducts/tvcmsfeaturedproducts.php:158 (displayFeaturedProducts) /modules/tvcmsfeaturedproducts/tvcmsfeaturedproducts.php:281 (showFrontSideResult) /classes/Hook.php:1043 (hookdisplayLeftColumn) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:418 (coreCallHook) /classes/Hook.php:981 (callHookOn) /config/smarty.config.inc.php:198 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/prod/smarty/compile/v1_sephora_8_childlayouts_layout_left_column_tpl/99/cb/cf/99cbcf91ff0d17ac022bac38a72e3bacccc49337_2.file.product-list.tpl.php:124 (__call) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:186 (process) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/v1_sephora_8_childlayouts_layout_left_column_tpl/5c/9a/3c/5c9a3c3c5235861686a150a91d53b1f80c7aa467_2.file.layout-left-column.tpl.php:70 (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/prod/smarty/compile/v1_sephora_8_childlayouts_layout_left_column_tpl/4b/9b/63/4b9b638828d2aae72bd0a2f4d1249de65e7ff7e8_2.file.layout-both-columns.tpl.php:78 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69e8b8137e8bd0_02327563) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/v1_sephora_8_childlayouts_layout_left_column_tpl/5c/9a/3c/5c9a3c3c5235861686a150a91d53b1f80c7aa467_2.file.layout-left-column.tpl.php:28 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69e8b8137d57b8_46913727) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/v1_sephora_8_childlayouts_layout_left_column_tpl/99/cb/cf/99cbcf91ff0d17ac022bac38a72e3bacccc49337_2.file.product-list.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69e8b8137d0c18_34258467) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/v1_sephora_8_childlayouts_layout_left_column_tpl/1c/87/64/1c8764be2398138682bcd94e853ed739be6f2e64_2.file.category.tpl.php:31 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69e8b8137c1283_25875336) /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/controller/FrontController.php:753 (fetch) /classes/controller/FrontController.php:735 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
111	SELECT SQL_NO_CACHE 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` = 1 AND tr.`id_country` = 8 AND tr.`id_tax_rules_group` = 0 AND tr.`id_state` IN (0, 0) AND ('0' BETWEEN tr.`zipcode_from` AND tr.`zipcode_to` OR (tr.`zipcode_to` = 0 AND tr.`zipcode_from` IN(0, '0'))) ORDER BY tr.`zipcode_from` DESC, tr.`zipcode_to` DESC, tr.`id_state` DESC, tr.`id_country` DESC	34.124 ms	0			/classes/tax/TaxRulesTaxManager.php:109 /classes/Product.php:3952 (getTaxCalculator) /classes/Product.php:3717 (priceCalculation) /classes/Product.php:5709 (getPriceStatic) /classes/ProductAssembler.php:209 (getProductProperties) /classes/controller/ProductListingFrontController.php:108 (assembleProducts) /classes/controller/ProductListingFrontController.php:379 (prepareMultipleProductsForTemplate) /classes/controller/ProductListingFrontController.php:648 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:138 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
234	SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 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) 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` = 4) JOIN `ps_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`) WHERE pa.`id_product` IN (77) AND ag.`is_color_group` = 1 GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` ORDER BY a.`position` ASC;	30.551 ms	1	Yes	Yes	/classes/Product.php:4507 /src/Adapter/Product/ProductColorsRetriever.php:43 (getAttributesColorList) /src/Adapter/Presenter/Product/ProductLazyArray.php:528 (getColoredVariants) /src/Adapter/Presenter/AbstractLazyArray.php:261 (getMainVariants) /var/cache/prod/smarty/compile/v1_sephora_8_child/b7/52/68/b752683dfdcebc79418402d1440da0b56960e994_2.file.product.tpl.php:38 (offsetGet) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69e8b813acb090_75905459) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /var/cache/prod/smarty/compile/v1_sephora_8_child/78/e9/70/78e970bc95a3c68784e14c8740225005c09f4238_2.file.tvcmsproductpopup_footer.tpl.php:37 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69e8b813abb759_44494464) /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/module/Module.php:2232 (fetch) /modules/tvcmsproductpopup/tvcmsproductpopup.php:558 (display) /classes/Hook.php:1043 (hookdisplayAfterBodyOpeningTag) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:418 (coreCallHook) /classes/Hook.php:981 (callHookOn) /config/smarty.config.inc.php:198 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/prod/smarty/compile/v1_sephora_8_childlayouts_layout_left_column_tpl/4b/9b/63/4b9b638828d2aae72bd0a2f4d1249de65e7ff7e8_2.file.layout-both-columns.tpl.php:118 (__call) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/v1_sephora_8_childlayouts_layout_left_column_tpl/4b/9b/63/4b9b638828d2aae72bd0a2f4d1249de65e7ff7e8_2.file.layout-both-columns.tpl.php:55 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69e8b8137e8bd0_02327563) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/v1_sephora_8_childlayouts_layout_left_column_tpl/5c/9a/3c/5c9a3c3c5235861686a150a91d53b1f80c7aa467_2.file.layout-left-column.tpl.php:28 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69e8b8137d57b8_46913727) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/v1_sephora_8_childlayouts_layout_left_column_tpl/99/cb/cf/99cbcf91ff0d17ac022bac38a72e3bacccc49337_2.file.product-list.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69e8b8137d0c18_34258467) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/v1_sephora_8_childlayouts_layout_left_column_tpl/1c/87/64/1c8764be2398138682bcd94e853ed739be6f2e64_2.file.category.tpl.php:31 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69e8b8137c1283_25875336) /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/controller/FrontController.php:753 (fetch) /classes/controller/FrontController.php:735 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
278	SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "ps_contactinfo" LIMIT 1	29.773 ms	1			/classes/module/Module.php:2636 /classes/module/Module.php:2108 (getModuleIdByName) /classes/Hook.php:1049 (isEnabled) /tools/profiling/Hook.php:64 (coreRenderWidget) /classes/Hook.php:1000 (coreRenderWidget) /config/smarty.config.inc.php:198 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/prod/smarty/compile/v1_sephora_8_childlayouts_layout_left_column_tpl/47/30/b7/4730b71b23483bc8719af0338bdef1daa3e0ebc6_2.file.desk-header-5.tpl.php:45 (__call) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69e8b813be8ad0_80566357) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /var/cache/prod/smarty/compile/v1_sephora_8_childlayouts_layout_left_column_tpl/b8/3b/3f/b83b3fd7697edd2331efae1297eed79a77fcb3a5_2.file.desktop-header.tpl.php:25 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69e8b813be3133_74264926) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /var/cache/prod/smarty/compile/v1_sephora_8_childlayouts_layout_left_column_tpl/75/0c/07/750c07e833517546506cb1722c6462eee6cfdf58_2.file.header.tpl.php:55 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/v1_sephora_8_childlayouts_layout_left_column_tpl/75/0c/07/750c07e833517546506cb1722c6462eee6cfdf58_2.file.header.tpl.php:29 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69e8b813be0c10_19557802) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /var/cache/prod/smarty/compile/v1_sephora_8_childlayouts_layout_left_column_tpl/4b/9b/63/4b9b638828d2aae72bd0a2f4d1249de65e7ff7e8_2.file.layout-both-columns.tpl.php:146 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/v1_sephora_8_childlayouts_layout_left_column_tpl/4b/9b/63/4b9b638828d2aae72bd0a2f4d1249de65e7ff7e8_2.file.layout-both-columns.tpl.php:65 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69e8b8137e8bd0_02327563) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/v1_sephora_8_childlayouts_layout_left_column_tpl/5c/9a/3c/5c9a3c3c5235861686a150a91d53b1f80c7aa467_2.file.layout-left-column.tpl.php:28 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69e8b8137d57b8_46913727) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/v1_sephora_8_childlayouts_layout_left_column_tpl/99/cb/cf/99cbcf91ff0d17ac022bac38a72e3bacccc49337_2.file.product-list.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69e8b8137d0c18_34258467) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/v1_sephora_8_childlayouts_layout_left_column_tpl/1c/87/64/1c8764be2398138682bcd94e853ed739be6f2e64_2.file.category.tpl.php:31 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69e8b8137c1283_25875336) /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/controller/FrontController.php:753 (fetch) /classes/controller/FrontController.php:735 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
61	SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "ps_legalcompliance" LIMIT 1	29.691 ms	0			/classes/module/Module.php:2636 /classes/module/Module.php:2108 (getModuleIdByName) /classes/controller/FrontController.php:1651 (isEnabled) /classes/controller/FrontController.php:1794 (getDisplayTaxesLabel) /controllers/front/listing/CategoryController.php:275 (getTemplateVarPage) /classes/controller/FrontController.php:543 (getTemplateVarPage) /classes/controller/FrontController.php:607 (assignGeneralPurposeVariables) /controllers/front/listing/CategoryController.php:127 (initContent) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
136	SELECT SQL_NO_CACHE p., product_shop., stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, product_attribute_shop.minimal_quantity AS product_attribute_minimal_quantity,IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, pl.`description`, pl.`description_short`, pl.`link_rewrite`, pl.`meta_description`, pl.`meta_keywords`, pl.`meta_title`, pl.`name`, pl.`available_now`, pl.`available_later`, m.`name` AS manufacturer_name, p.`id_manufacturer` as id_manufacturer, image_shop.`id_image` id_image, il.`legend`, ps.`quantity` AS sales, t.`rate`, pl.`meta_keywords`, pl.`meta_title`, pl.`meta_description`, DATEDIFF(p.`date_add`, DATE_SUB("2026-04-22 00:00:00", INTERVAL 1000 DAY)) > 0 AS new FROM `ps_product_sale` ps LEFT JOIN `ps_product` p ON ps.`id_product` = p.`id_product` LEFT 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_shop` product_attribute_shop ON (p.`id_product` = product_attribute_shop.`id_product` AND product_attribute_shop.`default_on` = 1 AND product_attribute_shop.id_shop=1) LEFT JOIN `ps_product_lang` pl ON p.`id_product` = pl.`id_product` AND pl.`id_lang` = 4 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` = 4) LEFT JOIN `ps_manufacturer` m ON (m.`id_manufacturer` = p.`id_manufacturer`) LEFT JOIN `ps_tax_rule` tr ON (product_shop.`id_tax_rules_group` = tr.`id_tax_rules_group`) AND tr.`id_country` = 8 AND tr.`id_state` = 0 LEFT JOIN `ps_tax` t ON (t.`id_tax` = tr.`id_tax`) 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.`active` = 1 AND product_shop.`visibility` != 'none' AND EXISTS(SELECT 1 FROM `ps_category_product` cp JOIN `ps_category_group` cg ON (cp.id_category = cg.id_category AND cg.`id_group` =1) WHERE cp.`id_product` = p.`id_product`) ORDER BY `sales` DESC LIMIT 0, 5	28.321 ms	882	Yes		/classes/ProductSale.php:151 /src/Adapter/BestSales/BestSalesProductSearchProvider.php:74 (getBestSales) /modules/tvcmsproductpopup/tvcmsproductpopup.php:502 (runQuery) /modules/tvcmsproductpopup/tvcmsproductpopup.php:266 (getBestSellers) /modules/tvcmsproductpopup/tvcmsproductpopup.php:549 (prevHook) /classes/Hook.php:1043 (hookdisplayAfterBodyOpeningTag) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:418 (coreCallHook) /classes/Hook.php:981 (callHookOn) /config/smarty.config.inc.php:198 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/prod/smarty/compile/v1_sephora_8_childlayouts_layout_left_column_tpl/4b/9b/63/4b9b638828d2aae72bd0a2f4d1249de65e7ff7e8_2.file.layout-both-columns.tpl.php:118 (__call) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/v1_sephora_8_childlayouts_layout_left_column_tpl/4b/9b/63/4b9b638828d2aae72bd0a2f4d1249de65e7ff7e8_2.file.layout-both-columns.tpl.php:55 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69e8b8137e8bd0_02327563) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/v1_sephora_8_childlayouts_layout_left_column_tpl/5c/9a/3c/5c9a3c3c5235861686a150a91d53b1f80c7aa467_2.file.layout-left-column.tpl.php:28 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69e8b8137d57b8_46913727) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/v1_sephora_8_childlayouts_layout_left_column_tpl/99/cb/cf/99cbcf91ff0d17ac022bac38a72e3bacccc49337_2.file.product-list.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69e8b8137d0c18_34258467) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/v1_sephora_8_childlayouts_layout_left_column_tpl/1c/87/64/1c8764be2398138682bcd94e853ed739be6f2e64_2.file.category.tpl.php:31 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69e8b8137c1283_25875336) /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/controller/FrontController.php:753 (fetch) /classes/controller/FrontController.php:735 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
174	SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`, IFNULL(product_attribute_shop.id_product_attribute,0) 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 = 1) LEFT JOIN `ps_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1) WHERE (p.`id_product` = 76)	27.748 ms	1			/classes/Product.php:3860 /classes/Product.php:3717 (priceCalculation) /classes/Product.php:5675 (getPriceStatic) /classes/Product.php:5971 (getProductProperties) /classes/ProductSale.php:161 (getProductsProperties) /src/Adapter/BestSales/BestSalesProductSearchProvider.php:74 (getBestSales) /modules/tvcmsproductpopup/tvcmsproductpopup.php:502 (runQuery) /modules/tvcmsproductpopup/tvcmsproductpopup.php:266 (getBestSellers) /modules/tvcmsproductpopup/tvcmsproductpopup.php:549 (prevHook) /classes/Hook.php:1043 (hookdisplayAfterBodyOpeningTag) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:418 (coreCallHook) /classes/Hook.php:981 (callHookOn) /config/smarty.config.inc.php:198 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/prod/smarty/compile/v1_sephora_8_childlayouts_layout_left_column_tpl/4b/9b/63/4b9b638828d2aae72bd0a2f4d1249de65e7ff7e8_2.file.layout-both-columns.tpl.php:118 (__call) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/v1_sephora_8_childlayouts_layout_left_column_tpl/4b/9b/63/4b9b638828d2aae72bd0a2f4d1249de65e7ff7e8_2.file.layout-both-columns.tpl.php:55 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69e8b8137e8bd0_02327563) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/v1_sephora_8_childlayouts_layout_left_column_tpl/5c/9a/3c/5c9a3c3c5235861686a150a91d53b1f80c7aa467_2.file.layout-left-column.tpl.php:28 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69e8b8137d57b8_46913727) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/v1_sephora_8_childlayouts_layout_left_column_tpl/99/cb/cf/99cbcf91ff0d17ac022bac38a72e3bacccc49337_2.file.product-list.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69e8b8137d0c18_34258467) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/v1_sephora_8_childlayouts_layout_left_column_tpl/1c/87/64/1c8764be2398138682bcd94e853ed739be6f2e64_2.file.category.tpl.php:31 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69e8b8137c1283_25875336) /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/controller/FrontController.php:753 (fetch) /classes/controller/FrontController.php:735 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
115	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 cp.`quantity` as first_level_quantity, 0 as pack_quantity FROM `ps_cart_product` cp WHERE cp.`id_product_attribute` = 0 AND cp.`id_customization` = 0 AND cp.`id_cart` = 0 AND cp.`id_product` = 157 UNION SELECT 0 as first_level_quantity, 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_customization` = 0 AND cp.`id_cart` = 0 AND p.`id_product_item` = 157 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1	15.179 ms	0			/classes/Cart.php:1439 /classes/Product.php:4342 (getProductQuantity) /classes/Product.php:5784 (getQuantity) /classes/ProductAssembler.php:209 (getProductProperties) /classes/controller/ProductListingFrontController.php:108 (assembleProducts) /classes/controller/ProductListingFrontController.php:379 (prepareMultipleProductsForTemplate) /classes/controller/ProductListingFrontController.php:648 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:138 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
49	SELECT SQL_NO_CACHE COUNT(*) FROM `ps_orders` o LEFT JOIN `ps_order_cart_rule` ocr ON (ocr.`id_order` = o.`id_order`) WHERE o.`id_customer` = 0 AND ocr.`deleted` = 0 AND ocr.`id_cart_rule` = 31035 LIMIT 1	14.687 ms	1066			/classes/order/Order.php:929 /classes/CartRule.php:441 (getDiscountsCustomer) /override/classes/Cart.php:662 (getCustomerCartRules) /classes/Cart.php:3434 (getDeliveryOptionList) /classes/Cart.php:3507 (getDeliveryOption) /src/Core/Cart/Fees.php:96 (getTotalShippingCost) /src/Core/Cart/Calculator.php:354 (processCalculation) /src/Core/Cart/Calculator.php:155 (calculateFees) /override/classes/Cart.php:443 (processCalculation) /src/Adapter/Presenter/Cart/CartPresenter.php:334 (getOrderTotal) /classes/controller/FrontController.php:538 (present) /classes/controller/FrontController.php:607 (assignGeneralPurposeVariables) /controllers/front/listing/CategoryController.php:127 (initContent) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
16	SELECT SQL_NO_CACHE h.`name` as hook, m.`id_module`, h.`id_hook`, m.`name` as module FROM `ps_module` m INNER JOIN ps_module_shop module_shop ON (module_shop.id_module = m.id_module AND module_shop.id_shop = 1 AND module_shop.enable_device & 1) INNER JOIN `ps_hook_module` `hm` ON hm.`id_module` = m.`id_module` INNER JOIN `ps_hook` `h` ON hm.`id_hook` = h.`id_hook` LEFT JOIN `ps_module_group` `mg` ON mg.`id_module` = m.`id_module` WHERE (h.`name` != "paymentOptions") AND (hm.`id_shop` = 1) AND (mg.id_shop = 1 AND mg.`id_group` IN (1)) GROUP BY hm.id_hook, hm.id_module ORDER BY hm.`position`	13.378 ms	2108	Yes	Yes	/classes/Hook.php:1233 /classes/Hook.php:735 (getAllHookRegistrations) /classes/Hook.php:842 (getHookModuleExecList) /classes/Dispatcher.php:606 (exec) /classes/Dispatcher.php:243 (loadRoutes) /classes/Dispatcher.php:201 (__construct) /index.php:28 (getInstance)
135	SELECT SQL_NO_CACHE COUNT(DISTINCT c.id_currency) FROM `ps_currency` c LEFT JOIN ps_currency_shop cs ON (cs.id_currency = c.id_currency AND cs.id_shop = 1) WHERE c.`active` = 1 AND c.`deleted` = 0 LIMIT 1	13.187 ms	1			/classes/Currency.php:1136 /classes/Currency.php:1153 (countActiveCurrencies) /classes/module/Module.php:2204 (isMultiCurrencyActivated) /modules/tvcmsproductpopup/tvcmsproductpopup.php:548 (getCacheId) /classes/Hook.php:1043 (hookdisplayAfterBodyOpeningTag) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:418 (coreCallHook) /classes/Hook.php:981 (callHookOn) /config/smarty.config.inc.php:198 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/prod/smarty/compile/v1_sephora_8_childlayouts_layout_left_column_tpl/4b/9b/63/4b9b638828d2aae72bd0a2f4d1249de65e7ff7e8_2.file.layout-both-columns.tpl.php:118 (__call) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/v1_sephora_8_childlayouts_layout_left_column_tpl/4b/9b/63/4b9b638828d2aae72bd0a2f4d1249de65e7ff7e8_2.file.layout-both-columns.tpl.php:55 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69e8b8137e8bd0_02327563) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/v1_sephora_8_childlayouts_layout_left_column_tpl/5c/9a/3c/5c9a3c3c5235861686a150a91d53b1f80c7aa467_2.file.layout-left-column.tpl.php:28 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69e8b8137d57b8_46913727) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/v1_sephora_8_childlayouts_layout_left_column_tpl/99/cb/cf/99cbcf91ff0d17ac022bac38a72e3bacccc49337_2.file.product-list.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69e8b8137d0c18_34258467) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/v1_sephora_8_childlayouts_layout_left_column_tpl/1c/87/64/1c8764be2398138682bcd94e853ed739be6f2e64_2.file.category.tpl.php:31 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69e8b8137c1283_25875336) /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/controller/FrontController.php:753 (fetch) /classes/controller/FrontController.php:735 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
143	SELECT SQL_NO_CACHE *, ( IF (`id_shop` = 1, 2, 0) + IF (`id_country` = 8, 4, 0) + IF (`id_currency` = 1, 8, 0) + IF (`id_group` = 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, 8) AND `id_group` IN (0, 1) AND `id_product` = 77 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0 AND (`from` = '0000-00-00 00:00:00' OR '2026-04-22 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2026-04-22 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	10.200 ms	1	Yes		/classes/SpecificPrice.php:576 /classes/Product.php:3827 (getSpecificPrice) /classes/Product.php:3717 (priceCalculation) /classes/Product.php:5675 (getPriceStatic) /classes/Product.php:5971 (getProductProperties) /classes/ProductSale.php:161 (getProductsProperties) /src/Adapter/BestSales/BestSalesProductSearchProvider.php:74 (getBestSales) /modules/tvcmsproductpopup/tvcmsproductpopup.php:502 (runQuery) /modules/tvcmsproductpopup/tvcmsproductpopup.php:266 (getBestSellers) /modules/tvcmsproductpopup/tvcmsproductpopup.php:549 (prevHook) /classes/Hook.php:1043 (hookdisplayAfterBodyOpeningTag) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:418 (coreCallHook) /classes/Hook.php:981 (callHookOn) /config/smarty.config.inc.php:198 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/prod/smarty/compile/v1_sephora_8_childlayouts_layout_left_column_tpl/4b/9b/63/4b9b638828d2aae72bd0a2f4d1249de65e7ff7e8_2.file.layout-both-columns.tpl.php:118 (__call) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/v1_sephora_8_childlayouts_layout_left_column_tpl/4b/9b/63/4b9b638828d2aae72bd0a2f4d1249de65e7ff7e8_2.file.layout-both-columns.tpl.php:55 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69e8b8137e8bd0_02327563) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/v1_sephora_8_childlayouts_layout_left_column_tpl/5c/9a/3c/5c9a3c3c5235861686a150a91d53b1f80c7aa467_2.file.layout-left-column.tpl.php:28 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69e8b8137d57b8_46913727) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/v1_sephora_8_childlayouts_layout_left_column_tpl/99/cb/cf/99cbcf91ff0d17ac022bac38a72e3bacccc49337_2.file.product-list.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69e8b8137d0c18_34258467) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/v1_sephora_8_childlayouts_layout_left_column_tpl/1c/87/64/1c8764be2398138682bcd94e853ed739be6f2e64_2.file.category.tpl.php:31 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69e8b8137c1283_25875336) /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/controller/FrontController.php:753 (fetch) /classes/controller/FrontController.php:735 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
21	SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module`as `mshop` FROM `ps_module` m LEFT JOIN `ps_module_shop` ms ON m.`id_module` = ms.`id_module` AND ms.`id_shop` = 1	9.934 ms	130			/classes/module/Module.php:345 /modules/registrationfields/registrationfields.php:42 (__construct) :undefined (__construct) /src/Core/Foundation/IoC/Container.php:123 (newInstance) /src/Core/Foundation/IoC/Container.php:153 (makeInstanceFromClassName) /src/Core/Foundation/IoC/Container.php:166 (doMake) /src/Adapter/ServiceLocator.php:70 (make) /classes/module/Module.php:1235 (get) /tools/profiling/Module.php:35 (coreLoadModule) /classes/module/Module.php:1214 (coreLoadModule) /classes/Hook.php:966 (getInstanceByName) /classes/Dispatcher.php:606 (exec) /classes/Dispatcher.php:243 (loadRoutes) /classes/Dispatcher.php:201 (__construct) /index.php:28 (getInstance)
116	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 = 4) LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 4) LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 4) 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 = 157 ORDER BY f.position ASC	9.622 ms	3	Yes		/classes/Product.php:6002 /classes/Product.php:5805 (getFrontFeaturesStatic) /classes/ProductAssembler.php:209 (getProductProperties) /classes/controller/ProductListingFrontController.php:108 (assembleProducts) /classes/controller/ProductListingFrontController.php:379 (prepareMultipleProductsForTemplate) /classes/controller/ProductListingFrontController.php:648 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:138 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
472	INSERT IGNORE INTO `ps_connections_page` (`id_connections`, `id_page`, `time_start`) VALUES ('5526716', '231', '2026-04-22 13:59:16')	9.045 ms	1			/classes/Connection.php:122 /modules/statsdata/statsdata.php:118 (setPageConnection) /modules/statsdata/statsdata.php:74 (getScriptCustomerPagesViews) /classes/Hook.php:1043 (hookDisplayBeforeBodyClosingTag) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:418 (coreCallHook) /classes/Hook.php:981 (callHookOn) /config/smarty.config.inc.php:198 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/prod/smarty/compile/v1_sephora_8_childlayouts_layout_left_column_tpl/4b/9b/63/4b9b638828d2aae72bd0a2f4d1249de65e7ff7e8_2.file.layout-both-columns.tpl.php:312 (__call) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/v1_sephora_8_childlayouts_layout_left_column_tpl/4b/9b/63/4b9b638828d2aae72bd0a2f4d1249de65e7ff7e8_2.file.layout-both-columns.tpl.php:91 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69e8b8137e8bd0_02327563) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/v1_sephora_8_childlayouts_layout_left_column_tpl/5c/9a/3c/5c9a3c3c5235861686a150a91d53b1f80c7aa467_2.file.layout-left-column.tpl.php:28 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69e8b8137d57b8_46913727) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/v1_sephora_8_childlayouts_layout_left_column_tpl/99/cb/cf/99cbcf91ff0d17ac022bac38a72e3bacccc49337_2.file.product-list.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69e8b8137d0c18_34258467) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/v1_sephora_8_childlayouts_layout_left_column_tpl/1c/87/64/1c8764be2398138682bcd94e853ed739be6f2e64_2.file.category.tpl.php:31 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69e8b8137c1283_25875336) /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/controller/FrontController.php:753 (fetch) /classes/controller/FrontController.php:735 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
473	INSERT INTO `ps_connections_source` (`id_connections`, `http_referer`, `request_uri`, `keywords`, `date_add`) VALUES ('5526716', '', 'naturebio-recast.cut.in.dmsc.solutions/gb/174-tres-important?p=41&q=Selections-On+sale', '', '2026-04-22 13:59:16')	8.631 ms	1			/classes/ObjectModel.php:622 /classes/ConnectionsSource.php:105 (add) /modules/statsdata/statsdata.php:119 (logHttpReferer) /modules/statsdata/statsdata.php:74 (getScriptCustomerPagesViews) /classes/Hook.php:1043 (hookDisplayBeforeBodyClosingTag) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:418 (coreCallHook) /classes/Hook.php:981 (callHookOn) /config/smarty.config.inc.php:198 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/prod/smarty/compile/v1_sephora_8_childlayouts_layout_left_column_tpl/4b/9b/63/4b9b638828d2aae72bd0a2f4d1249de65e7ff7e8_2.file.layout-both-columns.tpl.php:312 (__call) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/v1_sephora_8_childlayouts_layout_left_column_tpl/4b/9b/63/4b9b638828d2aae72bd0a2f4d1249de65e7ff7e8_2.file.layout-both-columns.tpl.php:91 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69e8b8137e8bd0_02327563) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/v1_sephora_8_childlayouts_layout_left_column_tpl/5c/9a/3c/5c9a3c3c5235861686a150a91d53b1f80c7aa467_2.file.layout-left-column.tpl.php:28 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69e8b8137d57b8_46913727) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/v1_sephora_8_childlayouts_layout_left_column_tpl/99/cb/cf/99cbcf91ff0d17ac022bac38a72e3bacccc49337_2.file.product-list.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69e8b8137d0c18_34258467) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/v1_sephora_8_childlayouts_layout_left_column_tpl/1c/87/64/1c8764be2398138682bcd94e853ed739be6f2e64_2.file.category.tpl.php:31 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69e8b8137c1283_25875336) /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/controller/FrontController.php:753 (fetch) /classes/controller/FrontController.php:735 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
290	SELECT SQL_NO_CACHE p., product_shop., stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, pl.`description`, pl.`description_short`, pl.`link_rewrite`, pl.`meta_description`, pl.`meta_keywords`, pl.`meta_title`, pl.`name`, pl.`available_now`, pl.`available_later`, image_shop.`id_image` id_image, il.`legend`, m.`name` AS manufacturer_name, (DATEDIFF(product_shop.`date_add`, DATE_SUB( "2026-04-22 00:00:00", INTERVAL 1000 DAY ) ) > 0) as new, product_attribute_shop.minimal_quantity AS product_attribute_minimal_quantity, IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute FROM `ps_product` p 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_lang` `pl` ON p.`id_product` = pl.`id_product` AND pl.`id_lang` = 4 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` = 4 LEFT JOIN `ps_manufacturer` `m` ON m.`id_manufacturer` = p.`id_manufacturer` LEFT JOIN `ps_product_attribute_shop` `product_attribute_shop` ON p.`id_product` = product_attribute_shop.`id_product` AND product_attribute_shop.`default_on` = 1 AND product_attribute_shop.id_shop=1 LEFT JOIN 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.`active` = 1) AND (product_shop.`visibility` IN ("both", "catalog")) AND (DATEDIFF(product_shop.`date_add`, DATE_SUB( "2026-04-22 00:00:00", INTERVAL 1000 DAY ) ) > 0) AND (EXISTS(SELECT 1 FROM `ps_category_product` cp JOIN `ps_category_group` cg ON (cp.id_category = cg.id_category AND cg.`id_group` =1) WHERE cp.`id_product` = p.`id_product`)) ORDER BY product_shop.`date_add` DESC LIMIT 4	7.888 ms	6			/classes/Product.php:3110 /modules/tvcmstabproducts/tvcmstabproducts.php:2763 (getNewProducts) /modules/tvcmsnewproducts/tvcmsnewproducts.php:157 (displayNewProducts) /modules/tvcmsnewproducts/tvcmsnewproducts.php:266 (showFrontSideResult) /classes/Hook.php:1043 (hookdisplayLeftColumn) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:418 (coreCallHook) /classes/Hook.php:981 (callHookOn) /config/smarty.config.inc.php:198 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/prod/smarty/compile/v1_sephora_8_childlayouts_layout_left_column_tpl/99/cb/cf/99cbcf91ff0d17ac022bac38a72e3bacccc49337_2.file.product-list.tpl.php:124 (__call) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:186 (process) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/v1_sephora_8_childlayouts_layout_left_column_tpl/5c/9a/3c/5c9a3c3c5235861686a150a91d53b1f80c7aa467_2.file.layout-left-column.tpl.php:70 (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/prod/smarty/compile/v1_sephora_8_childlayouts_layout_left_column_tpl/4b/9b/63/4b9b638828d2aae72bd0a2f4d1249de65e7ff7e8_2.file.layout-both-columns.tpl.php:78 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69e8b8137e8bd0_02327563) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/v1_sephora_8_childlayouts_layout_left_column_tpl/5c/9a/3c/5c9a3c3c5235861686a150a91d53b1f80c7aa467_2.file.layout-left-column.tpl.php:28 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69e8b8137d57b8_46913727) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/v1_sephora_8_childlayouts_layout_left_column_tpl/99/cb/cf/99cbcf91ff0d17ac022bac38a72e3bacccc49337_2.file.product-list.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69e8b8137d0c18_34258467) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/v1_sephora_8_childlayouts_layout_left_column_tpl/1c/87/64/1c8764be2398138682bcd94e853ed739be6f2e64_2.file.category.tpl.php:31 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69e8b8137c1283_25875336) /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/controller/FrontController.php:753 (fetch) /classes/controller/FrontController.php:735 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
387	SELECT SQL_NO_CACHE 1 FROM `ps_specific_price` WHERE id_product = 69 LIMIT 1	7.007 ms	1			/classes/SpecificPrice.php:435 /classes/SpecificPrice.php:523 (couldHaveSpecificPrice) /classes/Product.php:3827 (getSpecificPrice) /classes/Product.php:3717 (priceCalculation) /classes/Product.php:5675 (getPriceStatic) /classes/Product.php:5971 (getProductProperties) /classes/ProductSale.php:161 (getProductsProperties) /src/Adapter/BestSales/BestSalesProductSearchProvider.php:74 (getBestSales) /modules/tvcmstabproducts/tvcmstabproducts.php:2886 (runQuery) /modules/tvcmsbestsellerproducts/tvcmsbestsellerproducts.php:156 (displayBestSellers) /modules/tvcmsbestsellerproducts/tvcmsbestsellerproducts.php:268 (showFrontSideResult) /classes/Hook.php:1043 (hookdisplayLeftColumn) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:418 (coreCallHook) /classes/Hook.php:981 (callHookOn) /config/smarty.config.inc.php:198 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/prod/smarty/compile/v1_sephora_8_childlayouts_layout_left_column_tpl/99/cb/cf/99cbcf91ff0d17ac022bac38a72e3bacccc49337_2.file.product-list.tpl.php:124 (__call) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:186 (process) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/v1_sephora_8_childlayouts_layout_left_column_tpl/5c/9a/3c/5c9a3c3c5235861686a150a91d53b1f80c7aa467_2.file.layout-left-column.tpl.php:70 (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/prod/smarty/compile/v1_sephora_8_childlayouts_layout_left_column_tpl/4b/9b/63/4b9b638828d2aae72bd0a2f4d1249de65e7ff7e8_2.file.layout-both-columns.tpl.php:78 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69e8b8137e8bd0_02327563) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/v1_sephora_8_childlayouts_layout_left_column_tpl/5c/9a/3c/5c9a3c3c5235861686a150a91d53b1f80c7aa467_2.file.layout-left-column.tpl.php:28 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69e8b8137d57b8_46913727) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/v1_sephora_8_childlayouts_layout_left_column_tpl/99/cb/cf/99cbcf91ff0d17ac022bac38a72e3bacccc49337_2.file.product-list.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69e8b8137d0c18_34258467) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/v1_sephora_8_childlayouts_layout_left_column_tpl/1c/87/64/1c8764be2398138682bcd94e853ed739be6f2e64_2.file.category.tpl.php:31 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69e8b8137c1283_25875336) /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/controller/FrontController.php:753 (fetch) /classes/controller/FrontController.php:735 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
50	SELECT SQL_NO_CACHE `id_country` FROM `ps_address` WHERE `id_customer` = 0 AND `deleted` = 0	6.392 ms	2104			/classes/CartRule.php:493 /override/classes/Cart.php:662 (getCustomerCartRules) /classes/Cart.php:3434 (getDeliveryOptionList) /classes/Cart.php:3507 (getDeliveryOption) /src/Core/Cart/Fees.php:96 (getTotalShippingCost) /src/Core/Cart/Calculator.php:354 (processCalculation) /src/Core/Cart/Calculator.php:155 (calculateFees) /override/classes/Cart.php:443 (processCalculation) /src/Adapter/Presenter/Cart/CartPresenter.php:334 (getOrderTotal) /classes/controller/FrontController.php:538 (present) /classes/controller/FrontController.php:607 (assignGeneralPurposeVariables) /controllers/front/listing/CategoryController.php:127 (initContent) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
475	UPDATE `ps_page_viewed` SET `counter` = `counter` + 1 WHERE `id_date_range` = 1064 AND `id_page` = 231 AND `id_shop` = 1	6.224 ms	1			/classes/Page.php:131 /modules/statsdata/statsdata.php:121 (setPageViewed) /modules/statsdata/statsdata.php:74 (getScriptCustomerPagesViews) /classes/Hook.php:1043 (hookDisplayBeforeBodyClosingTag) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:418 (coreCallHook) /classes/Hook.php:981 (callHookOn) /config/smarty.config.inc.php:198 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/prod/smarty/compile/v1_sephora_8_childlayouts_layout_left_column_tpl/4b/9b/63/4b9b638828d2aae72bd0a2f4d1249de65e7ff7e8_2.file.layout-both-columns.tpl.php:312 (__call) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/v1_sephora_8_childlayouts_layout_left_column_tpl/4b/9b/63/4b9b638828d2aae72bd0a2f4d1249de65e7ff7e8_2.file.layout-both-columns.tpl.php:91 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69e8b8137e8bd0_02327563) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/v1_sephora_8_childlayouts_layout_left_column_tpl/5c/9a/3c/5c9a3c3c5235861686a150a91d53b1f80c7aa467_2.file.layout-left-column.tpl.php:28 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69e8b8137d57b8_46913727) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/v1_sephora_8_childlayouts_layout_left_column_tpl/99/cb/cf/99cbcf91ff0d17ac022bac38a72e3bacccc49337_2.file.product-list.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69e8b8137d0c18_34258467) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/v1_sephora_8_childlayouts_layout_left_column_tpl/1c/87/64/1c8764be2398138682bcd94e853ed739be6f2e64_2.file.category.tpl.php:31 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69e8b8137c1283_25875336) /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/controller/FrontController.php:753 (fetch) /classes/controller/FrontController.php:735 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
24	SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module`as `mshop` FROM `ps_module` m LEFT JOIN `ps_module_shop` ms ON m.`id_module` = ms.`id_module` AND ms.`id_shop` = 1	5.813 ms	130			/classes/module/Module.php:345 /modules/g_cartreminder/g_cartreminder.php:32 (__construct) :undefined (__construct) /src/Core/Foundation/IoC/Container.php:123 (newInstance) /src/Core/Foundation/IoC/Container.php:153 (makeInstanceFromClassName) /src/Core/Foundation/IoC/Container.php:166 (doMake) /src/Adapter/ServiceLocator.php:70 (make) /classes/module/Module.php:1235 (get) /tools/profiling/Module.php:35 (coreLoadModule) /classes/module/Module.php:1214 (coreLoadModule) /classes/Hook.php:966 (getInstanceByName) /classes/Dispatcher.php:606 (exec) /classes/Dispatcher.php:243 (loadRoutes) /classes/Dispatcher.php:201 (__construct) /index.php:28 (getInstance)
68	SELECT SQL_NO_CACHE `need_identification_number` FROM `ps_country` WHERE `id_country` = 147 LIMIT 1	5.559 ms	1			/classes/Country.php:405 /classes/AddressFormat.php:634 (isNeedDniByCountryId) /classes/AddressFormat.php:615 (getFormat) /classes/AddressFormat.php:562 (getAddressCountryFormat) /classes/AddressFormat.php:438 (getOrderedAddressFields) /classes/controller/FrontController.php:1754 (generateAddress) /classes/controller/FrontController.php:544 (getTemplateVarShop) /classes/controller/FrontController.php:607 (assignGeneralPurposeVariables) /controllers/front/listing/CategoryController.php:127 (initContent) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
27	SELECT SQL_NO_CACHE * FROM `ps_currency` c ORDER BY `iso_code` ASC	4.894 ms	1	Yes		/classes/Currency.php:709 /src/Adapter/Currency/CurrencyDataProvider.php:84 (findAllInstalled) /src/Core/Localization/Currency/DataLayer/CurrencyInstalled.php:90 (findAllInstalled) /src/Core/Localization/Currency/CurrencyDataSource.php:96 (getAllInstalledCurrencyIsoCodes) /src/Core/Localization/Currency/Repository.php:87 (getAllInstalledCurrenciesData) /src/Core/Localization/Locale/Repository.php:207 (getAllInstalledCurrencies) /src/Core/Localization/Locale/Repository.php:150 (getPriceSpecifications) /classes/controller/Controller.php:209 (getLocale) /classes/controller/FrontController.php:284 (init) /controllers/front/listing/CategoryController.php:81 (init) /tools/profiling/Controller.php:41 (init) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
74	SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "ps_facetedsearch" LIMIT 1	4.544 ms	1			/classes/module/Module.php:2636 /classes/module/Module.php:2108 (getModuleIdByName) /modules/tvcmsinfinitescroll/tvcmsinfinitescroll.php:268 (isEnabled) /classes/Hook.php:1043 (hookHeader) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:418 (coreCallHook) /classes/Hook.php:981 (callHookOn) /classes/controller/FrontController.php:615 (exec) /controllers/front/listing/CategoryController.php:127 (initContent) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
430	SELECT SQL_NO_CACHE (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS grade FROM `ps_tvcmsproduct_comment` pc WHERE pc.`id_product` = 157 AND pc.`deleted` = 0 AND pc.`validate` = 1 LIMIT 1	4.502 ms	1			/modules/tvcmsproductcomments/tvcmsproductcomment.php:224 /modules/tvcmsproductcomments/tvcmsproductcomments.php:928 (getAverageGrade) /classes/Hook.php:1043 (hookdisplayReviewProductList) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:418 (coreCallHook) /classes/Hook.php:981 (callHookOn) /config/smarty.config.inc.php:198 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/prod/smarty/compile/v1_sephora_8_childlayouts_layout_left_column_tpl/be/bd/fb/bebdfb27bfba076c75b7b83201bd81983756e0d2_2.file.product-grid-view2.tpl.php:32 (__call) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69e8b814222f82_62816167) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /var/cache/prod/smarty/compile/v1_sephora_8_childlayouts_layout_left_column_tpl/f0/fa/3f/f0fa3ff5036bcbaf7e9f4582bcd8be30e12eedec_2.file.product.tpl.php:52 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/v1_sephora_8_childlayouts_layout_left_column_tpl/f0/fa/3f/f0fa3ff5036bcbaf7e9f4582bcd8be30e12eedec_2.file.product.tpl.php:34 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69e8b8141dcfd2_89335680) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /var/cache/prod/smarty/compile/v1_sephora_8_childlayouts_layout_left_column_tpl/86/d2/b3/86d2b31632fd543809dde7d506e6963c3a059d08_2.file.products.tpl.php:50 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/v1_sephora_8_childlayouts_layout_left_column_tpl/86/d2/b3/86d2b31632fd543809dde7d506e6963c3a059d08_2.file.products.tpl.php:34 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69e8b8141d7e61_13576624) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /var/cache/prod/smarty/compile/v1_sephora_8_childlayouts_layout_left_column_tpl/99/cb/cf/99cbcf91ff0d17ac022bac38a72e3bacccc49337_2.file.product-list.tpl.php:78 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/v1_sephora_8_childlayouts_layout_left_column_tpl/99/cb/cf/99cbcf91ff0d17ac022bac38a72e3bacccc49337_2.file.product-list.tpl.php:139 (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/prod/smarty/compile/v1_sephora_8_childlayouts_layout_left_column_tpl/5c/9a/3c/5c9a3c3c5235861686a150a91d53b1f80c7aa467_2.file.layout-left-column.tpl.php:70 (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/prod/smarty/compile/v1_sephora_8_childlayouts_layout_left_column_tpl/4b/9b/63/4b9b638828d2aae72bd0a2f4d1249de65e7ff7e8_2.file.layout-both-columns.tpl.php:78 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69e8b8137e8bd0_02327563) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/v1_sephora_8_childlayouts_layout_left_column_tpl/5c/9a/3c/5c9a3c3c5235861686a150a91d53b1f80c7aa467_2.file.layout-left-column.tpl.php:28 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69e8b8137d57b8_46913727) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/v1_sephora_8_childlayouts_layout_left_column_tpl/99/cb/cf/99cbcf91ff0d17ac022bac38a72e3bacccc49337_2.file.product-list.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69e8b8137d0c18_34258467) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/v1_sephora_8_childlayouts_layout_left_column_tpl/1c/87/64/1c8764be2398138682bcd94e853ed739be6f2e64_2.file.category.tpl.php:31 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69e8b8137c1283_25875336) /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/controller/FrontController.php:753 (fetch) /classes/controller/FrontController.php:735 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
315	SELECT SQL_NO_CACHE * FROM `ps_product` a LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 4 LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1 WHERE (a.`id_product` = 106) AND (b.`id_shop` = 1) LIMIT 1	4.365 ms	1			/src/Adapter/EntityMapper.php:71 /classes/ObjectModel.php:283 (load) /tools/profiling/ObjectModel.php:32 (__construct) /classes/Product.php:725 (__construct) /classes/Link.php:113 (__construct) /classes/Link.php:189 (getProductObject) /classes/Product.php:5643 (getProductLink) /classes/Product.php:5971 (getProductProperties) /classes/Category.php:1074 (getProductsProperties) /src/Adapter/Category/CategoryProductSearchProvider.php:79 (getProducts) /src/Adapter/Category/CategoryProductSearchProvider.php:105 (getProductsOrCount) /modules/tvcmstabproducts/tvcmstabproducts.php:2708 (runQuery) /modules/tvcmsfeaturedproducts/tvcmsfeaturedproducts.php:158 (displayFeaturedProducts) /modules/tvcmsfeaturedproducts/tvcmsfeaturedproducts.php:281 (showFrontSideResult) /classes/Hook.php:1043 (hookdisplayLeftColumn) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:418 (coreCallHook) /classes/Hook.php:981 (callHookOn) /config/smarty.config.inc.php:198 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/prod/smarty/compile/v1_sephora_8_childlayouts_layout_left_column_tpl/99/cb/cf/99cbcf91ff0d17ac022bac38a72e3bacccc49337_2.file.product-list.tpl.php:124 (__call) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:186 (process) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/v1_sephora_8_childlayouts_layout_left_column_tpl/5c/9a/3c/5c9a3c3c5235861686a150a91d53b1f80c7aa467_2.file.layout-left-column.tpl.php:70 (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/prod/smarty/compile/v1_sephora_8_childlayouts_layout_left_column_tpl/4b/9b/63/4b9b638828d2aae72bd0a2f4d1249de65e7ff7e8_2.file.layout-both-columns.tpl.php:78 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69e8b8137e8bd0_02327563) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/v1_sephora_8_childlayouts_layout_left_column_tpl/5c/9a/3c/5c9a3c3c5235861686a150a91d53b1f80c7aa467_2.file.layout-left-column.tpl.php:28 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69e8b8137d57b8_46913727) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/v1_sephora_8_childlayouts_layout_left_column_tpl/99/cb/cf/99cbcf91ff0d17ac022bac38a72e3bacccc49337_2.file.product-list.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69e8b8137d0c18_34258467) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/v1_sephora_8_childlayouts_layout_left_column_tpl/1c/87/64/1c8764be2398138682bcd94e853ed739be6f2e64_2.file.category.tpl.php:31 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69e8b8137c1283_25875336) /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/controller/FrontController.php:753 (fetch) /classes/controller/FrontController.php:735 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
145	SELECT SQL_NO_CACHE `id_tax_rules_group` FROM `ps_product_shop` WHERE `id_product` = 77 AND id_shop=1 LIMIT 1	4.143 ms	1			/classes/Product.php:6857 /classes/Product.php:3925 (getIdTaxRulesGroupByIdProduct) /classes/Product.php:3717 (priceCalculation) /classes/Product.php:5675 (getPriceStatic) /classes/Product.php:5971 (getProductProperties) /classes/ProductSale.php:161 (getProductsProperties) /src/Adapter/BestSales/BestSalesProductSearchProvider.php:74 (getBestSales) /modules/tvcmsproductpopup/tvcmsproductpopup.php:502 (runQuery) /modules/tvcmsproductpopup/tvcmsproductpopup.php:266 (getBestSellers) /modules/tvcmsproductpopup/tvcmsproductpopup.php:549 (prevHook) /classes/Hook.php:1043 (hookdisplayAfterBodyOpeningTag) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:418 (coreCallHook) /classes/Hook.php:981 (callHookOn) /config/smarty.config.inc.php:198 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/prod/smarty/compile/v1_sephora_8_childlayouts_layout_left_column_tpl/4b/9b/63/4b9b638828d2aae72bd0a2f4d1249de65e7ff7e8_2.file.layout-both-columns.tpl.php:118 (__call) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/v1_sephora_8_childlayouts_layout_left_column_tpl/4b/9b/63/4b9b638828d2aae72bd0a2f4d1249de65e7ff7e8_2.file.layout-both-columns.tpl.php:55 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69e8b8137e8bd0_02327563) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/v1_sephora_8_childlayouts_layout_left_column_tpl/5c/9a/3c/5c9a3c3c5235861686a150a91d53b1f80c7aa467_2.file.layout-left-column.tpl.php:28 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69e8b8137d57b8_46913727) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/v1_sephora_8_childlayouts_layout_left_column_tpl/99/cb/cf/99cbcf91ff0d17ac022bac38a72e3bacccc49337_2.file.product-list.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69e8b8137d0c18_34258467) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/v1_sephora_8_childlayouts_layout_left_column_tpl/1c/87/64/1c8764be2398138682bcd94e853ed739be6f2e64_2.file.category.tpl.php:31 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69e8b8137c1283_25875336) /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/controller/FrontController.php:753 (fetch) /classes/controller/FrontController.php:735 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
25	SELECT SQL_NO_CACHE m.page, ml.url_rewrite, ml.id_lang FROM `ps_meta` m LEFT JOIN `ps_meta_lang` ml ON (m.id_meta = ml.id_meta AND ml.id_shop = 1 ) ORDER BY LENGTH(ml.url_rewrite) DESC	3.818 ms	228	Yes		/classes/Dispatcher.php:654 /classes/Dispatcher.php:243 (loadRoutes) /classes/Dispatcher.php:201 (__construct) /index.php:28 (getInstance)
22	SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module`as `mshop` FROM `ps_module` m LEFT JOIN `ps_module_shop` ms ON m.`id_module` = ms.`id_module` AND ms.`id_shop` = 1	3.447 ms	130			/classes/module/Module.php:345 /modules/colissimo/colissimo.php:114 (__construct) :undefined (__construct) /src/Core/Foundation/IoC/Container.php:123 (newInstance) /src/Core/Foundation/IoC/Container.php:153 (makeInstanceFromClassName) /src/Core/Foundation/IoC/Container.php:166 (doMake) /src/Adapter/ServiceLocator.php:70 (make) /classes/module/Module.php:1235 (get) /tools/profiling/Module.php:35 (coreLoadModule) /classes/module/Module.php:1214 (coreLoadModule) /classes/Hook.php:966 (getInstanceByName) /classes/Dispatcher.php:606 (exec) /classes/Dispatcher.php:243 (loadRoutes) /classes/Dispatcher.php:201 (__construct) /index.php:28 (getInstance)
213	SELECT SQL_NO_CACHE `id_product_attribute` FROM `ps_product_attribute` WHERE `id_product` = 77	3.338 ms	1			/classes/Product.php:2902 /src/Adapter/Image/ImageRetriever.php:90 (getCombinationImages) /src/Adapter/Presenter/Product/ProductLazyArray.php:688 (getAllProductImages) /src/Adapter/Presenter/Product/ProductLazyArray.php:127 (fillImages) /src/Adapter/Presenter/Product/ProductListingPresenter.php:57 (__construct) /modules/tvcmsproductpopup/tvcmsproductpopup.php:526 (present) /modules/tvcmsproductpopup/tvcmsproductpopup.php:266 (getBestSellers) /modules/tvcmsproductpopup/tvcmsproductpopup.php:549 (prevHook) /classes/Hook.php:1043 (hookdisplayAfterBodyOpeningTag) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:418 (coreCallHook) /classes/Hook.php:981 (callHookOn) /config/smarty.config.inc.php:198 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/prod/smarty/compile/v1_sephora_8_childlayouts_layout_left_column_tpl/4b/9b/63/4b9b638828d2aae72bd0a2f4d1249de65e7ff7e8_2.file.layout-both-columns.tpl.php:118 (__call) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/v1_sephora_8_childlayouts_layout_left_column_tpl/4b/9b/63/4b9b638828d2aae72bd0a2f4d1249de65e7ff7e8_2.file.layout-both-columns.tpl.php:55 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69e8b8137e8bd0_02327563) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/v1_sephora_8_childlayouts_layout_left_column_tpl/5c/9a/3c/5c9a3c3c5235861686a150a91d53b1f80c7aa467_2.file.layout-left-column.tpl.php:28 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69e8b8137d57b8_46913727) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/v1_sephora_8_childlayouts_layout_left_column_tpl/99/cb/cf/99cbcf91ff0d17ac022bac38a72e3bacccc49337_2.file.product-list.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69e8b8137d0c18_34258467) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/v1_sephora_8_childlayouts_layout_left_column_tpl/1c/87/64/1c8764be2398138682bcd94e853ed739be6f2e64_2.file.category.tpl.php:31 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69e8b8137c1283_25875336) /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/controller/FrontController.php:753 (fetch) /classes/controller/FrontController.php:735 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
316	SELECT SQL_NO_CACHE 1 FROM `ps_specific_price` WHERE id_product = 106 LIMIT 1	3.251 ms	1			/classes/SpecificPrice.php:435 /classes/SpecificPrice.php:523 (couldHaveSpecificPrice) /classes/Product.php:3827 (getSpecificPrice) /classes/Product.php:3717 (priceCalculation) /classes/Product.php:5675 (getPriceStatic) /classes/Product.php:5971 (getProductProperties) /classes/Category.php:1074 (getProductsProperties) /src/Adapter/Category/CategoryProductSearchProvider.php:79 (getProducts) /src/Adapter/Category/CategoryProductSearchProvider.php:105 (getProductsOrCount) /modules/tvcmstabproducts/tvcmstabproducts.php:2708 (runQuery) /modules/tvcmsfeaturedproducts/tvcmsfeaturedproducts.php:158 (displayFeaturedProducts) /modules/tvcmsfeaturedproducts/tvcmsfeaturedproducts.php:281 (showFrontSideResult) /classes/Hook.php:1043 (hookdisplayLeftColumn) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:418 (coreCallHook) /classes/Hook.php:981 (callHookOn) /config/smarty.config.inc.php:198 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/prod/smarty/compile/v1_sephora_8_childlayouts_layout_left_column_tpl/99/cb/cf/99cbcf91ff0d17ac022bac38a72e3bacccc49337_2.file.product-list.tpl.php:124 (__call) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:186 (process) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/v1_sephora_8_childlayouts_layout_left_column_tpl/5c/9a/3c/5c9a3c3c5235861686a150a91d53b1f80c7aa467_2.file.layout-left-column.tpl.php:70 (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/prod/smarty/compile/v1_sephora_8_childlayouts_layout_left_column_tpl/4b/9b/63/4b9b638828d2aae72bd0a2f4d1249de65e7ff7e8_2.file.layout-both-columns.tpl.php:78 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69e8b8137e8bd0_02327563) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/v1_sephora_8_childlayouts_layout_left_column_tpl/5c/9a/3c/5c9a3c3c5235861686a150a91d53b1f80c7aa467_2.file.layout-left-column.tpl.php:28 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69e8b8137d57b8_46913727) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/v1_sephora_8_childlayouts_layout_left_column_tpl/99/cb/cf/99cbcf91ff0d17ac022bac38a72e3bacccc49337_2.file.product-list.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69e8b8137d0c18_34258467) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/v1_sephora_8_childlayouts_layout_left_column_tpl/1c/87/64/1c8764be2398138682bcd94e853ed739be6f2e64_2.file.category.tpl.php:31 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69e8b8137c1283_25875336) /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/controller/FrontController.php:753 (fetch) /classes/controller/FrontController.php:735 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
195	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 = 4) LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 4) LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 4) 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 = 54 ORDER BY f.position ASC	3.220 ms	3	Yes		/classes/Product.php:6002 /classes/Product.php:5805 (getFrontFeaturesStatic) /classes/Product.php:5971 (getProductProperties) /classes/ProductSale.php:161 (getProductsProperties) /src/Adapter/BestSales/BestSalesProductSearchProvider.php:74 (getBestSales) /modules/tvcmsproductpopup/tvcmsproductpopup.php:502 (runQuery) /modules/tvcmsproductpopup/tvcmsproductpopup.php:266 (getBestSellers) /modules/tvcmsproductpopup/tvcmsproductpopup.php:549 (prevHook) /classes/Hook.php:1043 (hookdisplayAfterBodyOpeningTag) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:418 (coreCallHook) /classes/Hook.php:981 (callHookOn) /config/smarty.config.inc.php:198 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/prod/smarty/compile/v1_sephora_8_childlayouts_layout_left_column_tpl/4b/9b/63/4b9b638828d2aae72bd0a2f4d1249de65e7ff7e8_2.file.layout-both-columns.tpl.php:118 (__call) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/v1_sephora_8_childlayouts_layout_left_column_tpl/4b/9b/63/4b9b638828d2aae72bd0a2f4d1249de65e7ff7e8_2.file.layout-both-columns.tpl.php:55 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69e8b8137e8bd0_02327563) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/v1_sephora_8_childlayouts_layout_left_column_tpl/5c/9a/3c/5c9a3c3c5235861686a150a91d53b1f80c7aa467_2.file.layout-left-column.tpl.php:28 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69e8b8137d57b8_46913727) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/v1_sephora_8_childlayouts_layout_left_column_tpl/99/cb/cf/99cbcf91ff0d17ac022bac38a72e3bacccc49337_2.file.product-list.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69e8b8137d0c18_34258467) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/v1_sephora_8_childlayouts_layout_left_column_tpl/1c/87/64/1c8764be2398138682bcd94e853ed739be6f2e64_2.file.category.tpl.php:31 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69e8b8137c1283_25875336) /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/controller/FrontController.php:753 (fetch) /classes/controller/FrontController.php:735 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
295	SELECT SQL_NO_CACHE * FROM `ps_product` a LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 4 LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1 WHERE (a.`id_product` = 178) AND (b.`id_shop` = 1) LIMIT 1	3.205 ms	1			/src/Adapter/EntityMapper.php:71 /classes/ObjectModel.php:283 (load) /tools/profiling/ObjectModel.php:32 (__construct) /classes/Product.php:725 (__construct) /classes/Link.php:113 (__construct) /classes/Link.php:189 (getProductObject) /classes/Product.php:5643 (getProductLink) /classes/Product.php:5971 (getProductProperties) /classes/Product.php:3127 (getProductsProperties) /modules/tvcmstabproducts/tvcmstabproducts.php:2763 (getNewProducts) /modules/tvcmsnewproducts/tvcmsnewproducts.php:157 (displayNewProducts) /modules/tvcmsnewproducts/tvcmsnewproducts.php:266 (showFrontSideResult) /classes/Hook.php:1043 (hookdisplayLeftColumn) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:418 (coreCallHook) /classes/Hook.php:981 (callHookOn) /config/smarty.config.inc.php:198 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/prod/smarty/compile/v1_sephora_8_childlayouts_layout_left_column_tpl/99/cb/cf/99cbcf91ff0d17ac022bac38a72e3bacccc49337_2.file.product-list.tpl.php:124 (__call) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:186 (process) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/v1_sephora_8_childlayouts_layout_left_column_tpl/5c/9a/3c/5c9a3c3c5235861686a150a91d53b1f80c7aa467_2.file.layout-left-column.tpl.php:70 (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/prod/smarty/compile/v1_sephora_8_childlayouts_layout_left_column_tpl/4b/9b/63/4b9b638828d2aae72bd0a2f4d1249de65e7ff7e8_2.file.layout-both-columns.tpl.php:78 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69e8b8137e8bd0_02327563) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/v1_sephora_8_childlayouts_layout_left_column_tpl/5c/9a/3c/5c9a3c3c5235861686a150a91d53b1f80c7aa467_2.file.layout-left-column.tpl.php:28 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69e8b8137d57b8_46913727) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/v1_sephora_8_childlayouts_layout_left_column_tpl/99/cb/cf/99cbcf91ff0d17ac022bac38a72e3bacccc49337_2.file.product-list.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69e8b8137d0c18_34258467) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/v1_sephora_8_childlayouts_layout_left_column_tpl/1c/87/64/1c8764be2398138682bcd94e853ed739be6f2e64_2.file.category.tpl.php:31 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69e8b8137c1283_25875336) /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/controller/FrontController.php:753 (fetch) /classes/controller/FrontController.php:735 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
259	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 WHERE 1 AND `id_lang` = 4 AND c.`active` = 1 ORDER BY c.`level_depth` ASC , category_shop.`position` ASC	3.038 ms	281	Yes		/classes/Category.php:799 /modules/tvcmssearch/tvcmssearch.php:102 (getNestedCategories) /modules/tvcmssearch/tvcmssearch.php:213 (getAllCategories) /classes/Hook.php:1043 (hookdisplayNavSearchBlock) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:418 (coreCallHook) /classes/Hook.php:981 (callHookOn) /config/smarty.config.inc.php:198 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/prod/smarty/compile/v1_sephora_8_childlayouts_layout_left_column_tpl/47/30/b7/4730b71b23483bc8719af0338bdef1daa3e0ebc6_2.file.desk-header-5.tpl.php:41 (__call) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69e8b813be8ad0_80566357) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /var/cache/prod/smarty/compile/v1_sephora_8_childlayouts_layout_left_column_tpl/b8/3b/3f/b83b3fd7697edd2331efae1297eed79a77fcb3a5_2.file.desktop-header.tpl.php:25 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69e8b813be3133_74264926) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /var/cache/prod/smarty/compile/v1_sephora_8_childlayouts_layout_left_column_tpl/75/0c/07/750c07e833517546506cb1722c6462eee6cfdf58_2.file.header.tpl.php:55 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/v1_sephora_8_childlayouts_layout_left_column_tpl/75/0c/07/750c07e833517546506cb1722c6462eee6cfdf58_2.file.header.tpl.php:29 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69e8b813be0c10_19557802) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /var/cache/prod/smarty/compile/v1_sephora_8_childlayouts_layout_left_column_tpl/4b/9b/63/4b9b638828d2aae72bd0a2f4d1249de65e7ff7e8_2.file.layout-both-columns.tpl.php:146 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/v1_sephora_8_childlayouts_layout_left_column_tpl/4b/9b/63/4b9b638828d2aae72bd0a2f4d1249de65e7ff7e8_2.file.layout-both-columns.tpl.php:65 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69e8b8137e8bd0_02327563) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/v1_sephora_8_childlayouts_layout_left_column_tpl/5c/9a/3c/5c9a3c3c5235861686a150a91d53b1f80c7aa467_2.file.layout-left-column.tpl.php:28 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69e8b8137d57b8_46913727) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/v1_sephora_8_childlayouts_layout_left_column_tpl/99/cb/cf/99cbcf91ff0d17ac022bac38a72e3bacccc49337_2.file.product-list.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69e8b8137d0c18_34258467) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/v1_sephora_8_childlayouts_layout_left_column_tpl/1c/87/64/1c8764be2398138682bcd94e853ed739be6f2e64_2.file.category.tpl.php:31 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69e8b8137c1283_25875336) /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/controller/FrontController.php:753 (fetch) /classes/controller/FrontController.php:735 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
26	SELECT SQL_NO_CACHE * FROM `ps_category` a LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 4 LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1 WHERE (a.`id_category` = 174) AND (b.`id_shop` = 1) LIMIT 1	2.993 ms	1			/src/Adapter/EntityMapper.php:71 /classes/ObjectModel.php:283 (load) /tools/profiling/ObjectModel.php:32 (__construct) /classes/Category.php:164 (__construct) /controllers/front/listing/CategoryController.php:78 (__construct) /tools/profiling/Controller.php:41 (init) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
356	SELECT SQL_NO_CACHE 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 = 1) WHERE i.`id_product` = 56 AND image_shop.`cover` = 1 LIMIT 1	2.961 ms	1			/classes/Product.php:3570 /classes/Product.php:5626 (getCover) /classes/Product.php:5971 (getProductProperties) /classes/ProductSale.php:161 (getProductsProperties) /src/Adapter/BestSales/BestSalesProductSearchProvider.php:74 (getBestSales) /modules/tvcmstabproducts/tvcmstabproducts.php:2886 (runQuery) /modules/tvcmsbestsellerproducts/tvcmsbestsellerproducts.php:156 (displayBestSellers) /modules/tvcmsbestsellerproducts/tvcmsbestsellerproducts.php:268 (showFrontSideResult) /classes/Hook.php:1043 (hookdisplayLeftColumn) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:418 (coreCallHook) /classes/Hook.php:981 (callHookOn) /config/smarty.config.inc.php:198 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/prod/smarty/compile/v1_sephora_8_childlayouts_layout_left_column_tpl/99/cb/cf/99cbcf91ff0d17ac022bac38a72e3bacccc49337_2.file.product-list.tpl.php:124 (__call) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:186 (process) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/v1_sephora_8_childlayouts_layout_left_column_tpl/5c/9a/3c/5c9a3c3c5235861686a150a91d53b1f80c7aa467_2.file.layout-left-column.tpl.php:70 (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/prod/smarty/compile/v1_sephora_8_childlayouts_layout_left_column_tpl/4b/9b/63/4b9b638828d2aae72bd0a2f4d1249de65e7ff7e8_2.file.layout-both-columns.tpl.php:78 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69e8b8137e8bd0_02327563) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/v1_sephora_8_childlayouts_layout_left_column_tpl/5c/9a/3c/5c9a3c3c5235861686a150a91d53b1f80c7aa467_2.file.layout-left-column.tpl.php:28 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69e8b8137d57b8_46913727) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/v1_sephora_8_childlayouts_layout_left_column_tpl/99/cb/cf/99cbcf91ff0d17ac022bac38a72e3bacccc49337_2.file.product-list.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69e8b8137d0c18_34258467) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/v1_sephora_8_childlayouts_layout_left_column_tpl/1c/87/64/1c8764be2398138682bcd94e853ed739be6f2e64_2.file.category.tpl.php:31 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69e8b8137c1283_25875336) /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/controller/FrontController.php:753 (fetch) /classes/controller/FrontController.php:735 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
88	SELECT SQL_NO_CACHE p.id_product FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, pl.name FROM ps_product p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN ps_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps_product_lang pl ON (p.id_product = pl.id_product AND pl.id_shop = 1 AND pl.id_lang = 4) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_category_group cg ON (cg.id_category = c.id_category) WHERE ((p.on_sale=1)) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=205 AND c.nright<=206 GROUP BY p.id_product) p INNER JOIN ps_product_lang pl ON (p.id_product = pl.id_product AND pl.id_shop = 1 AND pl.id_lang = 4) GROUP BY p.id_product ORDER BY p.name ASC, p.id_product DESC	2.792 ms	1764	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Filters/Products.php:87 (execute) /modules/ps_facetedsearch/src/Product/SearchProvider.php:189 (getProductByFilters) /classes/controller/ProductListingFrontController.php:357 (runQuery) /classes/controller/ProductListingFrontController.php:648 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:138 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)

#	Filename
0	/index.php
1	/config/config.inc.php
2	/config/defines.inc.php
3	/config/autoload.php
4	/vendor/autoload.php
5	/vendor/composer/autoload_real.php
6	/vendor/composer/platform_check.php
7	/vendor/composer/ClassLoader.php
8	/vendor/composer/include_paths.php
9	/vendor/composer/autoload_static.php
10	/vendor/symfony/polyfill-php72/bootstrap.php
11	/vendor/symfony/polyfill-mbstring/bootstrap.php
12	/vendor/symfony/polyfill-mbstring/bootstrap80.php
13	/vendor/symfony/polyfill-intl-normalizer/bootstrap.php
14	/vendor/symfony/polyfill-intl-normalizer/bootstrap80.php
15	/vendor/symfony/polyfill-intl-idn/bootstrap.php
16	/vendor/symfony/deprecation-contracts/function.php
17	/vendor/ralouphie/getallheaders/src/getallheaders.php
18	/vendor/symfony/polyfill-ctype/bootstrap.php
19	/vendor/symfony/polyfill-ctype/bootstrap80.php
20	/vendor/symfony/polyfill-php80/bootstrap.php
21	/vendor/guzzlehttp/promises/src/functions_include.php
22	/vendor/guzzlehttp/promises/src/functions.php
23	/vendor/guzzlehttp/guzzle/src/functions_include.php
24	/vendor/guzzlehttp/guzzle/src/functions.php
25	/vendor/symfony/polyfill-iconv/bootstrap.php
26	/vendor/ezyang/htmlpurifier/library/HTMLPurifier.composer.php
27	/vendor/jakeasmith/http_build_url/src/http_build_url.php
28	/vendor/lcobucci/jwt/compat/class-aliases.php
29	/vendor/lcobucci/jwt/src/Token.php
30	/vendor/lcobucci/jwt/src/Signature.php
31	/vendor/lcobucci/jwt/compat/json-exception-polyfill.php
32	/vendor/lcobucci/jwt/compat/lcobucci-clock-polyfill.php
33	/vendor/swiftmailer/swiftmailer/lib/swift_required.php
34	/vendor/swiftmailer/swiftmailer/lib/classes/Swift.php
35	/vendor/symfony/polyfill-intl-icu/bootstrap.php
36	/vendor/symfony/polyfill-php73/bootstrap.php
37	/vendor/symfony/polyfill-php81/bootstrap.php
38	/vendor/api-platform/core/src/deprecation.php
39	/vendor/api-platform/core/src/Api/FilterInterface.php

Omégabio 3

Cholestérobio

Néréïdobio

Glutaminobio

Hémocromatobio

Shopping Cart

Omégabio 3

Cholestérobio

Néréïdobio

Glutaminobio

Hémocromatobio

Hépatobio

Vitamine D3+

Mgbio

Mélatoninobio

Mélatoninobio

Mélatoninobio

Mélatoninobio

Sérotoninobio

Sérotoninobio

Sérotoninobio

Sérotoninobio

Stopwatch SQL - 476 queries

Doubles

Tables stress

ObjectModel instances

Included Files