Home

To give you the best possible experience, this site uses cookies. Using your site means your agree to our use of cookies. We have published a new cookies policy, which you should need to find out more about the cookies we use. View Cookies Policy.

Emsibeth: La Scienza Italiana al Servizio della Salute e della Bellezza dei Tuoi Capelli

Apr ,

2025

Emsibeth: La Scienza Italiana al Servizio della Salute e della Bellezza dei Tuoi Capelli

Se sei alla ricerca di soluzioni specifiche e performanti per la cura dei tuoi capelli e del cuoio capelluto, sei nel posto giusto! Noi di Hair ...

Insight: La Natura al Servizio della Bellezza Autentica dei Tuoi Capelli

Apr ,

2025

Insight: La Natura al Servizio della Bellezza Autentica dei Tuoi Capelli

Sei alla ricerca di un haircare che rispetti la natura dei tuoi capelli e del pianeta? Noi di Hair Saloon siamo entusiasti di presentarti la ...

Framesi: L'Eccellenza Italiana per Capelli che Ispirano

Mar ,

2025

Framesi: L'Eccellenza Italiana per Capelli che Ispirano

Se cerchi risultati professionali direttamente a casa tua, sei nel posto giusto! Noi di Hair Saloon siamo entusiasti di presentarti la nostra ...

Davines: La Bellezza Sostenibile che Nutre i Tuoi Capelli (e il Pianeta!)

Mar ,

2025

Davines: La Bellezza Sostenibile che Nutre i Tuoi Capelli (e il Pianeta!)

Noi di Hair Saloon siamo fieri di essere il tuo punto di riferimento per l'intera gamma di prodotti Davines. Abbiamo selezionato con cura ogni ...

Subcategory

View Left Column

79 products

Grid

Grid-2

List

List-2

Catelog

Ordina per:

Home

INSIGHT ANTI FRIZZ SHAMPOO IDRATANTE HYDRATING SHAMPOO 900ML

20,60 €

Home

INSIGHT ANTI FRIZZ SHAMPOO IDRATANTE HYDRATING SHAMPOO 900ML

20,60 €

Home

INSIGHT ANTI FRIZZ SHAMPOO IDRATANTE HYDRATING SHAMPOO 900ML

20,60 €

Load Time	2059 ms
Querying Time	1379 ms
Queries	1415
Memory Peak Usage	42.0 Mb
Included Files	1392 files - 18.05 Mb
PrestaShop Cache	- Mb
Global vars	1.31 Mb
- global $_MODULES	1274k
- global $_MODULE	37k
- global $_SERVER	13k
- global $config	5k
- global $context	3k
- global $smarty	3k
- global $__composer_autoload_files	3k
- global $exportPhpConfigFile	3k

PrestaShop Version	8.2.1
PHP Version	8.1.32
MySQL Version	8.0.18-9
Memory Limit	256M
Max Execution Time	180s
Smarty Cache	enabled
Smarty Compilation	auto

	Time	Cumulated Time	Memory Usage	Memory Peak Usage
config	67.936 ms	67.936 ms	3.68 Mb	3.9 Mb
__construct	0.033 ms	67.969 ms	- Mb	3.9 Mb
init	25.278 ms	93.247 ms	0.92 Mb	4.6 Mb
checkAccess	0.003 ms	93.250 ms	- Mb	4.6 Mb
setMedia	58.785 ms	152.035 ms	0.23 Mb	5.1 Mb
postProcess	0.003 ms	152.038 ms	- Mb	5.1 Mb
initHeader	0.002 ms	152.040 ms	- Mb	5.1 Mb
initContent	700.897 ms	853 ms	5.70 Mb	10.6 Mb
initFooter	0.004 ms	853 ms	- Mb	10.6 Mb
display	1206 ms	2059 ms	30.61 Mb	42.0 Mb

Hook	Time	Memory Usage
DisplayLeftColumn	665.607 ms	17.84 Mb
=> tvcmsnewproducts	9.192 ms	0.56 Mb
=> tvcmscustomerservices	0.206 ms	0.02 Mb
=> tvcmsspecialproducts	265.275 ms	7.43 Mb
=> tvcmsfeaturedproducts	104.577 ms	1.45 Mb
=> tvcmsbestsellerproducts	102.417 ms	1.75 Mb
=> tvcmsblogdisplayposts	179.410 ms	6.58 Mb
=> tvcmstestimonial	4.530 ms	0.04 Mb
DisplayAfterBodyOpeningTag	124.116 ms	4.29 Mb
=> tvcmscookiesnotice	0.399 ms	0.02 Mb
=> tvcmsproductpopup	123.717 ms	4.28 Mb
DisplayHeader	80.731 ms	0.44 Mb
=> lgcookieslaw	0.478 ms	- Mb
=> ps_shoppingcart	0.087 ms	- Mb
=> ps_searchbar	0.668 ms	- Mb
=> ps_imageslider	0.147 ms	- Mb
=> ps_facebook	3.968 ms	0.07 Mb
=> ps_googleanalytics	0.023 ms	- Mb
=> psxmarketingwithgoogle	0.385 ms	0.01 Mb
=> tvcmsbestsellerproducts	0.183 ms	0.01 Mb
=> tvcmsblog	0.350 ms	0.05 Mb
=> tvcmsblogdisplayposts	0.238 ms	0.03 Mb
=> tvcmsbrandlist	0.186 ms	0.02 Mb
=> tvcmscategorychainslider	0.184 ms	- Mb
=> tvcmscategoryslider	0.189 ms	- Mb
=> tvcmscookiesnotice	0.195 ms	- Mb
=> tvcmscustomerservices	0.192 ms	- Mb
=> tvcmscustomsetting	0.936 ms	0.01 Mb
=> tvcmsfeaturedproducts	0.138 ms	- Mb
=> tvcmsfooterlogo	0.003 ms	- Mb
=> tvcmsfooterproduct	0.124 ms	- Mb
=> tvcmsnewproducts	0.125 ms	- Mb
=> tvcmsnewsletterpopup	0.332 ms	- Mb
=> tvcmspaymenticon	0.003 ms	- Mb
=> tvcmsproductcomments	0.523 ms	- Mb
=> tvcmsproductcompare	0.180 ms	- Mb
=> tvcmsproductpopup	0.161 ms	- Mb
=> tvcmssearch	0.429 ms	- Mb
=> tvcmssingleblock	0.182 ms	- Mb
=> tvcmssizechart	0.175 ms	- Mb
=> tvcmsslider	0.177 ms	- Mb
=> tvcmsspecialproducts	0.129 ms	- Mb
=> tvcmsstoretime	0.172 ms	- Mb
=> tvcmstabproducts	0.246 ms	- Mb
=> tvcmstestimonial	0.190 ms	- Mb
=> tvcmsthemeoptions	0.511 ms	0.01 Mb
=> tvcmsvideoblock	0.182 ms	- Mb
=> tvcmswishlist	0.241 ms	- Mb
=> ets_promotion	8.927 ms	0.06 Mb
=> ets_affiliatemarketing	0.527 ms	0.01 Mb
=> ets_reviews	0.091 ms	- Mb
=> ets_seo	55.176 ms	0.10 Mb
=> fermopoint	0.007 ms	- Mb
=> ets_whatsapp	0.233 ms	- Mb
=> gmerchantcenterpro	3.138 ms	0.01 Mb
DisplayBeforeBodyClosingTag	68.688 ms	0.18 Mb
=> statsdata	68.682 ms	0.18 Mb
=> tvcmsblog	0.006 ms	- Mb
DisplayWishlistBtnProductList	68.197 ms	0.10 Mb
=> tvcmswishlist	0.401 ms	0.01 Mb
=> tvcmswishlist	0.289 ms	- Mb
=> tvcmswishlist	0.169 ms	- Mb
=> tvcmswishlist	0.155 ms	- Mb
=> tvcmswishlist	0.148 ms	- Mb
=> tvcmswishlist	0.147 ms	- Mb
=> tvcmswishlist	0.111 ms	- Mb
=> tvcmswishlist	0.116 ms	- Mb
=> tvcmswishlist	0.103 ms	- Mb
=> tvcmswishlist	0.105 ms	- Mb
=> tvcmswishlist	0.148 ms	- Mb
=> tvcmswishlist	0.124 ms	- Mb
=> tvcmswishlist	0.111 ms	- Mb
=> tvcmswishlist	0.112 ms	- Mb
=> tvcmswishlist	0.111 ms	- Mb
=> tvcmswishlist	0.114 ms	- Mb
=> tvcmswishlist	0.103 ms	- Mb
=> tvcmswishlist	0.105 ms	- Mb
=> tvcmswishlist	0.330 ms	- Mb
=> tvcmswishlist	0.328 ms	- Mb
=> tvcmswishlist	0.505 ms	- Mb
=> tvcmswishlist	0.394 ms	- Mb
=> tvcmswishlist	0.429 ms	- Mb
=> tvcmswishlist	0.141 ms	- Mb
=> tvcmswishlist	0.156 ms	- Mb
=> tvcmswishlist	0.142 ms	- Mb
=> tvcmswishlist	0.144 ms	- Mb
=> tvcmswishlist	0.110 ms	- Mb
=> tvcmswishlist	0.126 ms	- Mb
=> tvcmswishlist	0.242 ms	- Mb
=> tvcmswishlist	0.219 ms	- Mb
=> tvcmswishlist	0.384 ms	- Mb
=> tvcmswishlist	0.317 ms	- Mb
=> tvcmswishlist	0.403 ms	- Mb
=> tvcmswishlist	0.266 ms	- Mb
=> tvcmswishlist	0.261 ms	- Mb
=> tvcmswishlist	58.811 ms	- Mb
=> tvcmswishlist	0.195 ms	- Mb
=> tvcmswishlist	0.208 ms	- Mb
=> tvcmswishlist	0.229 ms	- Mb
=> tvcmswishlist	0.181 ms	- Mb
=> tvcmswishlist	0.258 ms	- Mb
=> tvcmswishlist	0.115 ms	- Mb
=> tvcmswishlist	0.117 ms	- Mb
=> tvcmswishlist	0.105 ms	- Mb
=> tvcmswishlist	0.122 ms	- Mb
=> tvcmswishlist	0.153 ms	- Mb
=> tvcmswishlist	0.135 ms	- Mb
DisplayReviewProductList	57.034 ms	3.84 Mb
=> tvcmsproductcomments	2.399 ms	0.12 Mb
=> tvcmsproductcomments	1.446 ms	0.07 Mb
=> tvcmsproductcomments	0.944 ms	0.07 Mb
=> tvcmsproductcomments	1.034 ms	0.07 Mb
=> tvcmsproductcomments	1.178 ms	0.11 Mb
=> tvcmsproductcomments	0.875 ms	0.07 Mb
=> tvcmsproductcomments	0.723 ms	0.07 Mb
=> tvcmsproductcomments	0.759 ms	0.07 Mb
=> tvcmsproductcomments	0.950 ms	0.11 Mb
=> tvcmsproductcomments	0.737 ms	0.07 Mb
=> tvcmsproductcomments	0.746 ms	0.07 Mb
=> tvcmsproductcomments	0.722 ms	0.07 Mb
=> tvcmsproductcomments	0.937 ms	0.11 Mb
=> tvcmsproductcomments	0.749 ms	0.07 Mb
=> tvcmsproductcomments	0.723 ms	0.07 Mb
=> tvcmsproductcomments	0.713 ms	0.07 Mb
=> tvcmsproductcomments	0.965 ms	0.11 Mb
=> tvcmsproductcomments	1.240 ms	0.07 Mb
=> tvcmsproductcomments	1.058 ms	0.07 Mb
=> tvcmsproductcomments	0.936 ms	0.07 Mb
=> tvcmsproductcomments	2.282 ms	0.11 Mb
=> tvcmsproductcomments	1.427 ms	0.07 Mb
=> tvcmsproductcomments	1.351 ms	0.07 Mb
=> tvcmsproductcomments	1.283 ms	0.07 Mb
=> tvcmsproductcomments	1.349 ms	0.11 Mb
=> tvcmsproductcomments	1.044 ms	0.07 Mb
=> tvcmsproductcomments	0.913 ms	0.07 Mb
=> tvcmsproductcomments	0.825 ms	0.07 Mb
=> tvcmsproductcomments	1.717 ms	0.11 Mb
=> tvcmsproductcomments	1.028 ms	0.07 Mb
=> tvcmsproductcomments	0.950 ms	0.07 Mb
=> tvcmsproductcomments	1.266 ms	0.07 Mb
=> tvcmsproductcomments	1.752 ms	0.11 Mb
=> tvcmsproductcomments	1.375 ms	0.07 Mb
=> tvcmsproductcomments	1.120 ms	0.07 Mb
=> tvcmsproductcomments	0.863 ms	0.07 Mb
=> tvcmsproductcomments	2.032 ms	0.11 Mb
=> tvcmsproductcomments	1.204 ms	0.07 Mb
=> tvcmsproductcomments	1.508 ms	0.07 Mb
=> tvcmsproductcomments	1.180 ms	0.07 Mb
=> tvcmsproductcomments	1.470 ms	0.11 Mb
=> tvcmsproductcomments	1.388 ms	0.07 Mb
=> tvcmsproductcomments	1.393 ms	0.07 Mb
=> tvcmsproductcomments	1.025 ms	0.07 Mb
=> tvcmsproductcomments	2.008 ms	0.11 Mb
=> tvcmsproductcomments	1.534 ms	0.07 Mb
=> tvcmsproductcomments	1.101 ms	0.07 Mb
=> tvcmsproductcomments	0.812 ms	0.07 Mb
ActionFrontControllerSetMedia	56.949 ms	0.19 Mb
=> ps_emailalerts	0.058 ms	- Mb
=> ps_socialfollow	0.084 ms	- Mb
=> ps_emailsubscription	0.193 ms	- Mb
=> klaviyopsautomation	0.009 ms	- Mb
=> ps_checkout	56.350 ms	0.18 Mb
=> ps_facebook	0.163 ms	- Mb
=> fermopoint	0.092 ms	- Mb
DisplayMegamenu	50.604 ms	0.47 Mb
=> tvcmsmegamenu	50.604 ms	0.47 Mb
displayLeftColumn	11.696 ms	0.59 Mb
=> ps_categorytree (widget)	7.162 ms	0.45 Mb
=> ps_brandlist (widget)	3.007 ms	0.07 Mb
=> ps_supplierlist (widget)	1.527 ms	0.07 Mb
DisplayProductCompareProductList	10.872 ms	0.11 Mb
=> tvcmsproductcompare	0.485 ms	0.01 Mb
=> tvcmsproductcompare	0.322 ms	- Mb
=> tvcmsproductcompare	0.184 ms	- Mb
=> tvcmsproductcompare	0.171 ms	- Mb
=> tvcmsproductcompare	0.171 ms	- Mb
=> tvcmsproductcompare	0.177 ms	- Mb
=> tvcmsproductcompare	0.126 ms	- Mb
=> tvcmsproductcompare	0.121 ms	- Mb
=> tvcmsproductcompare	0.159 ms	- Mb
=> tvcmsproductcompare	0.125 ms	- Mb
=> tvcmsproductcompare	0.130 ms	- Mb
=> tvcmsproductcompare	0.123 ms	- Mb
=> tvcmsproductcompare	0.118 ms	- Mb
=> tvcmsproductcompare	0.127 ms	- Mb
=> tvcmsproductcompare	0.127 ms	- Mb
=> tvcmsproductcompare	0.137 ms	- Mb
=> tvcmsproductcompare	0.112 ms	- Mb
=> tvcmsproductcompare	0.121 ms	- Mb
=> tvcmsproductcompare	0.402 ms	- Mb
=> tvcmsproductcompare	0.413 ms	- Mb
=> tvcmsproductcompare	0.607 ms	- Mb
=> tvcmsproductcompare	0.470 ms	- Mb
=> tvcmsproductcompare	0.433 ms	- Mb
=> tvcmsproductcompare	0.162 ms	- Mb
=> tvcmsproductcompare	0.223 ms	- Mb
=> tvcmsproductcompare	0.172 ms	- Mb
=> tvcmsproductcompare	0.168 ms	- Mb
=> tvcmsproductcompare	0.140 ms	- Mb
=> tvcmsproductcompare	0.113 ms	- Mb
=> tvcmsproductcompare	0.307 ms	- Mb
=> tvcmsproductcompare	0.222 ms	- Mb
=> tvcmsproductcompare	0.333 ms	- Mb
=> tvcmsproductcompare	0.333 ms	- Mb
=> tvcmsproductcompare	0.482 ms	- Mb
=> tvcmsproductcompare	0.260 ms	- Mb
=> tvcmsproductcompare	0.276 ms	- Mb
=> tvcmsproductcompare	0.297 ms	- Mb
=> tvcmsproductcompare	0.273 ms	- Mb
=> tvcmsproductcompare	0.225 ms	- Mb
=> tvcmsproductcompare	0.220 ms	- Mb
=> tvcmsproductcompare	0.184 ms	- Mb
=> tvcmsproductcompare	0.260 ms	- Mb
=> tvcmsproductcompare	0.135 ms	- Mb
=> tvcmsproductcompare	0.131 ms	- Mb
=> tvcmsproductcompare	0.118 ms	- Mb
=> tvcmsproductcompare	0.148 ms	- Mb
=> tvcmsproductcompare	0.187 ms	- Mb
=> tvcmsproductcompare	0.142 ms	- Mb
Header	6.912 ms	0.07 Mb
=> tvcmsstockinfo	0.212 ms	- Mb
=> paypal	1.604 ms	0.03 Mb
=> tvcmsinfinitescroll	3.798 ms	0.04 Mb
=> tvcmstwoofferbanner	0.316 ms	- Mb
=> tvcmscategoryproduct	0.386 ms	- Mb
=> tvcmsmegamenu	0.326 ms	- Mb
=> tvcmsofferbanner	0.270 ms	- Mb
DisplayNavSearchBlock	6.472 ms	0.35 Mb
=> tvcmssearch	6.472 ms	0.35 Mb
DisplayNavWishlistBlock	4.048 ms	0.04 Mb
=> tvcmswishlist	4.048 ms	0.04 Mb
displayNewslettersubscription	2.838 ms	0.12 Mb
=> ps_emailsubscription (widget)	2.838 ms	0.12 Mb
displayNav1	2.662 ms	0.15 Mb
=> ps_contactinfo (widget)	2.662 ms	0.15 Mb
DisplayCustomsocialblock	2.485 ms	0.17 Mb
=> tvcmscustomsetting	2.485 ms	0.17 Mb
DisplayPaymentIcon	2.133 ms	0.05 Mb
=> tvcmspaymenticon	2.133 ms	0.05 Mb
displayNavShoppingCartBlock	2.116 ms	0.09 Mb
=> ps_shoppingcart (widget)	2.116 ms	0.09 Mb
displayNavCustomerSignInBlock	2.006 ms	0.06 Mb
=> ps_customersignin (widget)	2.006 ms	0.06 Mb
displayFooter	1.836 ms	0.09 Mb
=> ps_linklist (widget)	1.836 ms	0.09 Mb
DisplayGDPRConsent	1.166 ms	0.03 Mb
=> psgdpr	1.166 ms	0.03 Mb
displayContactCinfo	1.152 ms	0.03 Mb
=> ps_contactinfo (widget)	1.152 ms	0.03 Mb
ModuleRoutes	1.108 ms	0.03 Mb
=> klaviyopsautomation	0.011 ms	- Mb
=> ps_checkout	0.005 ms	- Mb
=> tvcmsblog	0.039 ms	0.01 Mb
=> ets_reviews	1.053 ms	0.02 Mb
DisplayNavWishlistBlocksticky	1.096 ms	0.05 Mb
=> tvcmswishlist	1.096 ms	0.05 Mb
displayNavLanguageBlock	1.086 ms	0.05 Mb
=> ps_languageselector (widget)	1.086 ms	0.05 Mb
DisplayFacetedSearchBlock	0.968 ms	0.02 Mb
=> ps_facetedsearch	0.968 ms	0.02 Mb
displayNavCurrencyBlock	0.844 ms	0.05 Mb
=> ps_currencyselector (widget)	0.844 ms	0.05 Mb
ProductSearchProvider	0.768 ms	- Mb
=> ps_facetedsearch	0.768 ms	- Mb
DisplayFooter	0.560 ms	0.02 Mb
=> lgcookieslaw	0.108 ms	- Mb
=> ps_facebook	0.118 ms	- Mb
=> ets_affiliatemarketing	0.018 ms	- Mb
=> ets_reviews	0.002 ms	- Mb
=> ets_whatsapp	0.314 ms	0.02 Mb
DisplayProductListStockIndicator	0.444 ms	0.01 Mb
=> tvcmsstockinfo	0.033 ms	- Mb
=> tvcmsstockinfo	0.016 ms	- Mb
=> tvcmsstockinfo	0.016 ms	- Mb
=> tvcmsstockinfo	0.009 ms	- Mb
=> tvcmsstockinfo	0.015 ms	- Mb
=> tvcmsstockinfo	0.010 ms	- Mb
=> tvcmsstockinfo	0.013 ms	- Mb
=> tvcmsstockinfo	0.011 ms	- Mb
=> tvcmsstockinfo	0.028 ms	- Mb
=> tvcmsstockinfo	0.020 ms	- Mb
=> tvcmsstockinfo	0.040 ms	- Mb
=> tvcmsstockinfo	0.025 ms	- Mb
=> tvcmsstockinfo	0.016 ms	- Mb
=> tvcmsstockinfo	0.011 ms	- Mb
=> tvcmsstockinfo	0.023 ms	- Mb
=> tvcmsstockinfo	0.016 ms	- Mb
=> tvcmsstockinfo	0.029 ms	- Mb
=> tvcmsstockinfo	0.019 ms	- Mb
=> tvcmsstockinfo	0.027 ms	- Mb
=> tvcmsstockinfo	0.013 ms	- Mb
=> tvcmsstockinfo	0.015 ms	- Mb
=> tvcmsstockinfo	0.009 ms	- Mb
=> tvcmsstockinfo	0.017 ms	- Mb
=> tvcmsstockinfo	0.013 ms	- Mb
DisplayNavProductCompareBlock	0.394 ms	0.01 Mb
=> tvcmsproductcompare	0.394 ms	0.01 Mb
DisplayAfterTitleTag	0.313 ms	0.01 Mb
=> lgcookieslaw	0.313 ms	0.01 Mb
DisplayProductPriceBlock	0.273 ms	0.06 Mb
=> ets_reviews	0.006 ms	- Mb
=> ets_reviews	0.002 ms	- Mb
=> ets_reviews	0.001 ms	- Mb
=> ets_reviews	0.003 ms	- Mb
=> ets_reviews	0.002 ms	- Mb
=> ets_reviews	0.001 ms	- Mb
=> ets_reviews	0.002 ms	- Mb
=> ets_reviews	0.001 ms	- Mb
=> ets_reviews	0.001 ms	- Mb
=> ets_reviews	0.003 ms	- Mb
=> ets_reviews	0.002 ms	- Mb
=> ets_reviews	0.001 ms	- Mb
=> ets_reviews	0.003 ms	- Mb
=> ets_reviews	0.001 ms	- Mb
=> ets_reviews	0.002 ms	- Mb
=> ets_reviews	0.002 ms	- Mb
=> ets_reviews	0.000 ms	- Mb
=> ets_reviews	0.000 ms	- Mb
=> ets_reviews	0.001 ms	- Mb
=> ets_reviews	0.001 ms	- Mb
=> ets_reviews	0.001 ms	- Mb
=> ets_reviews	0.002 ms	- Mb
=> ets_reviews	0.001 ms	- Mb
=> ets_reviews	0.000 ms	- Mb
=> ets_reviews	0.002 ms	- Mb
=> ets_reviews	0.000 ms	- Mb
=> ets_reviews	0.001 ms	- Mb
=> ets_reviews	0.002 ms	- Mb
=> ets_reviews	0.001 ms	- Mb
=> ets_reviews	0.001 ms	- Mb
=> ets_reviews	0.001 ms	- Mb
=> ets_reviews	0.001 ms	- Mb
=> ets_reviews	0.001 ms	- Mb
=> ets_reviews	0.002 ms	- Mb
=> ets_reviews	0.000 ms	- Mb
=> ets_reviews	0.001 ms	- Mb
=> ets_reviews	0.002 ms	- Mb
=> ets_reviews	0.001 ms	- Mb
=> ets_reviews	0.001 ms	- Mb
=> ets_reviews	0.002 ms	- Mb
=> ets_reviews	0.001 ms	- Mb
=> ets_reviews	0.001 ms	- Mb
=> ets_reviews	0.002 ms	- Mb
=> ets_reviews	0.000 ms	- Mb
=> ets_reviews	0.000 ms	- Mb
=> ets_reviews	0.002 ms	- Mb
=> ets_reviews	0.001 ms	- Mb
=> ets_reviews	0.001 ms	- Mb
=> ets_reviews	0.002 ms	- Mb
=> ets_reviews	0.001 ms	- Mb
=> ets_reviews	0.001 ms	- Mb
=> ets_reviews	0.007 ms	- Mb
=> ets_reviews	0.004 ms	- Mb
=> ets_reviews	0.003 ms	- Mb
=> ets_reviews	0.005 ms	- Mb
=> ets_reviews	0.004 ms	- Mb
=> ets_reviews	0.003 ms	- Mb
=> ets_reviews	0.003 ms	- Mb
=> ets_reviews	0.002 ms	- Mb
=> ets_reviews	0.001 ms	- Mb
=> ets_reviews	0.008 ms	- Mb
=> ets_reviews	0.003 ms	- Mb
=> ets_reviews	0.004 ms	- Mb
=> ets_reviews	0.004 ms	- Mb
=> ets_reviews	0.002 ms	- Mb
=> ets_reviews	0.002 ms	- Mb
=> ets_reviews	0.004 ms	- Mb
=> ets_reviews	0.003 ms	- Mb
=> ets_reviews	0.002 ms	- Mb
=> ets_reviews	0.004 ms	- Mb
=> ets_reviews	0.002 ms	- Mb
=> ets_reviews	0.002 ms	- Mb
=> ets_reviews	0.004 ms	- Mb
=> ets_reviews	0.002 ms	- Mb
=> ets_reviews	0.001 ms	- Mb
=> ets_reviews	0.004 ms	- Mb
=> ets_reviews	0.002 ms	- Mb
=> ets_reviews	0.001 ms	- Mb
=> ets_reviews	0.001 ms	- Mb
=> ets_reviews	0.001 ms	- Mb
=> ets_reviews	0.000 ms	- Mb
=> ets_reviews	0.002 ms	- Mb
=> ets_reviews	0.001 ms	- Mb
=> ets_reviews	0.001 ms	- Mb
=> ets_reviews	0.005 ms	- Mb
=> ets_reviews	0.002 ms	- Mb
=> ets_reviews	0.002 ms	- Mb
=> ets_reviews	0.004 ms	- Mb
=> ets_reviews	0.002 ms	- Mb
=> ets_reviews	0.001 ms	- Mb
=> ets_reviews	0.002 ms	- Mb
=> ets_reviews	0.001 ms	- Mb
=> ets_reviews	0.001 ms	- Mb
=> ets_reviews	0.003 ms	- Mb
=> ets_reviews	0.002 ms	- Mb
=> ets_reviews	0.001 ms	- Mb
=> ets_reviews	0.007 ms	- Mb
=> ets_reviews	0.003 ms	- Mb
=> ets_reviews	0.002 ms	- Mb
=> ets_reviews	0.006 ms	- Mb
=> ets_reviews	0.002 ms	- Mb
=> ets_reviews	0.002 ms	- Mb
=> ets_reviews	0.004 ms	- Mb
=> ets_reviews	0.003 ms	- Mb
=> ets_reviews	0.002 ms	- Mb
=> ets_reviews	0.003 ms	- Mb
=> ets_reviews	0.002 ms	- Mb
=> ets_reviews	0.001 ms	- Mb
=> ets_reviews	0.004 ms	- Mb
=> ets_reviews	0.001 ms	- Mb
=> ets_reviews	0.001 ms	- Mb
=> ets_reviews	0.003 ms	- Mb
=> ets_reviews	0.001 ms	- Mb
=> ets_reviews	0.001 ms	- Mb
=> ets_reviews	0.001 ms	- Mb
=> ets_reviews	0.001 ms	- Mb
=> ets_reviews	0.001 ms	- Mb
=> ets_reviews	0.002 ms	- Mb
=> ets_reviews	0.001 ms	- Mb
=> ets_reviews	0.001 ms	- Mb
=> ets_reviews	0.004 ms	- Mb
=> ets_reviews	0.002 ms	- Mb
=> ets_reviews	0.001 ms	- Mb
=> ets_reviews	0.002 ms	- Mb
=> ets_reviews	0.000 ms	- Mb
=> ets_reviews	0.001 ms	- Mb
=> ets_reviews	0.002 ms	- Mb
=> ets_reviews	0.001 ms	- Mb
=> ets_reviews	0.001 ms	- Mb
=> ets_reviews	0.001 ms	- Mb
=> ets_reviews	0.000 ms	- Mb
=> ets_reviews	0.001 ms	- Mb
=> ets_reviews	0.002 ms	- Mb
=> ets_reviews	0.000 ms	- Mb
=> ets_reviews	0.000 ms	- Mb
=> ets_reviews	0.002 ms	- Mb
=> ets_reviews	0.000 ms	- Mb
=> ets_reviews	0.001 ms	- Mb
=> ets_reviews	0.001 ms	- Mb
=> ets_reviews	0.001 ms	- Mb
=> ets_reviews	0.001 ms	- Mb
=> ets_reviews	0.002 ms	- Mb
=> ets_reviews	0.001 ms	- Mb
=> ets_reviews	0.001 ms	- Mb
DisplayFooterPart2	0.228 ms	0.02 Mb
=> tvcmsfooterlogo	0.228 ms	0.02 Mb
DisplayProductComparesticky	0.224 ms	0.02 Mb
=> tvcmsproductcompare	0.224 ms	0.02 Mb
ActionObjectAddAfter	0.142 ms	- Mb
=> ets_seo	0.056 ms	- Mb
=> ets_seo	0.054 ms	- Mb
=> ets_seo	0.032 ms	- Mb
DisplayFooterStoreTime	0.036 ms	0.01 Mb
=> tvcmsstoretime	0.036 ms	0.01 Mb
ActionDispatcherBefore	0.029 ms	- Mb
=> psassistant	0.022 ms	- Mb
=> ets_seo	0.007 ms	- Mb
ActionDispatcher	0.027 ms	- Mb
=> psassistant	0.017 ms	- Mb
=> fermopoint	0.010 ms	- Mb
DisplayTopOfferText	0.024 ms	- Mb
=> tvcmscustomsetting	0.015 ms	- Mb
=> tvcmscustomsetting	0.009 ms	- Mb
ActionFrontControllerInitAfter	0.018 ms	- Mb
=> klaviyopsautomation	0.009 ms	- Mb
=> ets_affiliatemarketing	0.009 ms	- Mb
ActionObjectAddBefore	0.017 ms	- Mb
=> ets_seo	0.004 ms	- Mb
=> ets_seo	0.008 ms	- Mb
=> ets_seo	0.005 ms	- Mb
DisplayCustomCss	0.015 ms	- Mb
=> tvcmscustomcssjs	0.015 ms	- Mb
DisplayOverrideTemplate	0.014 ms	- Mb
=> ets_promotion	0.010 ms	- Mb
=> ets_seo	0.004 ms	- Mb
DisplayCustomJs	0.010 ms	- Mb
=> tvcmscustomcssjs	0.010 ms	- Mb
DisplayCopyRightText	0.009 ms	- Mb
=> tvcmscustomsetting	0.009 ms	- Mb
DisplayDownloadApps	0.006 ms	- Mb
=> tvcmscustomsetting	0.006 ms	- Mb
47 hook(s)	1239 ms	29.66 Mb

108 queries	SELECT `id_tvcmsposts` FROM `ps_tvcmsposts_view` where `id_tvcmsposts` = XX
108 queries	SELECT xcp.`id_category`,xcl.`name`,xcl.`link_rewrite` FROM `ps_tvcms_category_post` xcp INNER JOIN `ps_tvcmscategory` xc ON (xcp.`id_category` = xc.`id_tvcmscategory` AND xc.`category_type` = "tag") INNER JOIN `ps_tvcmscategory_lang` xcl ON (xcp.`id_category` = xcl.`id_tvcmscategory` AND xcl.`id_lang` = XX) INNER JOIN `ps_tvcmscategory_shop` xcs ON (xcp.`id_category` = xcs.`id_tvcmscategory` AND xcs.`id_shop` = XX) WHERE xcp.`id_post` = XX AND xcp.`type` = "tag"
108 queries	SELECT COUNT(id_tvcms_comments) AS total_comment FROM `ps_tvcms_comments` xc WHERE xc.`id_post` = XX
76 queries	SELECT XX FROM `ps_specific_price` WHERE id_product = XX LIMIT XX
75 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)
75 queries	SELECT `id_tax_rules_group` FROM `ps_product_shop` WHERE `id_product` = XX AND id_shop=XX LIMIT XX
57 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
57 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
57 queries	SELECT product_attribute_shop.id_product_attribute FROM ps_product_attribute pa INNER JOIN ps_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = XX) WHERE pa.id_product = XX LIMIT XX
48 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
48 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
38 queries	SELECT `id_product_attribute` FROM `ps_product_attribute` WHERE `id_product` = XX
36 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
36 queries	SELECT COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), XX) as deep_quantity, COALESCE(SUM(first_level_quantity), XX) as quantity FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, XX as pack_quantity FROM `ps_cart_product` cp WHERE cp.`id_product_attribute` = XX AND cp.`id_cart` = XX AND cp.`id_product` = XX UNION SELECT XX as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity FROM `ps_cart_product` cp JOIN `ps_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `ps_product` pr ON p.`id_product_pack` = pr.`id_product` WHERE cp.`id_product_attribute` = XX AND cp.`id_cart` = XX AND p.`id_product_item` = XX AND (pr.`pack_stock_type` IN (XX,XX) OR ( pr.`pack_stock_type` = XX AND XX = XX ))) as q LIMIT XX
34 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
34 queries	SELECT name FROM ps_category_lang WHERE id_shop = XX AND id_lang = XX AND id_category = XX LIMIT XX
34 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
34 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`
26 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)
21 queries	SELECT `id_module` FROM `ps_module_shop` WHERE `id_module` = XX AND `id_shop` = XX LIMIT XX
12 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
12 queries	SELECT COUNT(`id_tvcmsproduct_comment`) AS "nbr" FROM `ps_tvcmsproduct_comment` pc WHERE `id_product` = XX AND `validate` = XX LIMIT XX
10 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
7 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 c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop` FROM `ps_category` c LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = XX ) INNER JOIN ps_category_shop category_shop ON (category_shop.id_category = c.id_category AND category_shop.id_shop = XX) WHERE `id_lang` = XX AND c.`id_parent` = XX AND `active` = XX GROUP BY c.`id_category` ORDER BY category_shop.`position` ASC
5 queries	SELECT cg.`id_group` FROM `ps_category_group` cg WHERE (cg.`id_category` = XX)
4 queries	SELECT DISTINCT a.`id_attribute`, a.`color`, al.`name`, agl.`id_attribute_group`, IF(lialv.`url_name` IS NULL OR lialv.`url_name` = "", NULL, lialv.`url_name`) AS url_name, IF(lialv.`meta_title` IS NULL OR lialv.`meta_title` = "", NULL, lialv.`meta_title`) AS meta_title FROM `ps_attribute_group` ag INNER JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = XX) INNER JOIN `ps_attribute` a ON a.`id_attribute_group` = ag.`id_attribute_group` INNER JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = XX) INNER JOIN ps_attribute_group_shop attribute_group_shop ON (attribute_group_shop.id_attribute_group = ag.id_attribute_group AND attribute_group_shop.id_shop = XX) INNER JOIN ps_attribute_shop attribute_shop ON (attribute_shop.id_attribute = a.id_attribute AND attribute_shop.id_shop = XX) LEFT JOIN `ps_layered_indexable_attribute_lang_value` lialv ON (a.`id_attribute` = lialv.`id_attribute` AND lialv.`id_lang` = XX) WHERE ag.id_attribute_group = XX ORDER BY agl.`name` ASC, a.`position` ASC
4 queries	SELECT pac.id_attribute, COUNT(DISTINCT p.id_product) c 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, cp.position 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, XX) = sa.id_product_attribute AND sa.id_shop = XX AND sa.id_shop_group = XX ) LEFT JOIN ps_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = XX AND ps.active = TRUE) LEFT JOIN ps_stock_available sa_XX ON (p.id_product = sa_XX.id_product AND IFNULL(pac.id_product_attribute, XX) = sa_XX.id_product_attribute AND sa_XX.id_shop = XX AND sa_XX.id_shop_group = XX ) WHERE ((sa.quantity<=XX AND sa_XX.out_of_stock IN (XX, XX))) AND ps.id_shop='XX' AND ps.visibility IN ('both', 'catalog') AND cp.id_category IN (XX, XX) GROUP BY p.id_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) INNER JOIN ps_attribute a ON (a.id_attribute = pac.id_attribute) LEFT JOIN ps_stock_available sa_XX ON (p.id_product = sa_XX.id_product AND IFNULL(pac.id_product_attribute, XX) = sa_XX.id_product_attribute AND sa_XX.id_shop = XX AND sa_XX.id_shop_group = XX ) LEFT JOIN ps_stock_available sa_XX_XX ON (p.id_product = sa_XX_XX.id_product AND IFNULL(pac.id_product_attribute, XX) = sa_XX_XX.id_product_attribute AND sa_XX_XX.id_shop = XX AND sa_XX_XX.id_shop_group = XX ) WHERE ((a.id_attribute_group=XX)) AND ((sa_XX.quantity<=XX AND sa_XX_XX.out_of_stock IN (XX, XX))) GROUP BY pac.id_attribute
4 queries	SELECT id_shop FROM `ps_employee_shop` WHERE `id_employee` = XX
3 queries	SELECT `need_identification_number` FROM `ps_country` WHERE `id_country` = XX LIMIT XX
3 queries	CREATE TABLE IF NOT EXISTS `ps_gmcp_tags_dynamic_last_product_not_ordered` (`id_tag` int(XX) NOT NULL,`start_date` DATETIME, `end_date` DATETIME, `id_product` CHAR(XX), UNIQUE KEY `last_product_ordered` (`id_tag`, `id_product`)) ENGINE=InnoDB DEFAULT CHARSET=utfXX;
3 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
3 queries	SELECT tr.* FROM `ps_tax_rule` tr JOIN `ps_tax_rules_group` trg ON (tr.`id_tax_rules_group` = trg.`id_tax_rules_group`) WHERE trg.`active` = XX AND tr.`id_country` = XX AND tr.`id_tax_rules_group` = XX AND tr.`id_state` IN (XX, XX) AND ('XX' BETWEEN tr.`zipcode_from` AND tr.`zipcode_to` OR (tr.`zipcode_to` = XX AND tr.`zipcode_from` IN(XX, 'XX'))) ORDER BY tr.`zipcode_from` DESC, tr.`zipcode_to` DESC, tr.`id_state` DESC, tr.`id_country` DESC
3 queries	SELECT `name` FROM `ps_manufacturer` WHERE `id_manufacturer` = XX AND `active` = XX LIMIT XX
2 queries	SELECT `id_lang` FROM `ps_lang` WHERE `locale` = 'it-it' OR `language_code` = 'it-it' LIMIT XX
2 queries	SELECT `id_category` FROM `ps_category_shop` WHERE `id_category` = XX AND `id_shop` = XX LIMIT XX
2 queries	SELECT `id_module` FROM `ps_module` WHERE `name` = "ps_accounts" LIMIT XX
2 queries	SELECT * FROM `ps_country` a LEFT JOIN `ps_country_shop` `c` ON a.`id_country` = c.`id_country` AND c.`id_shop` = XX WHERE (a.`id_country` = XX) LIMIT XX
2 queries	SELECT * FROM `ps_country_lang` WHERE `id_country` = XX
2 queries	BEGIN
2 queries	SHOW TABLES LIKE "ps_gmcp_XX"
2 queries	CREATE TABLE IF NOT EXISTS `ps_gmcp_reporting` (`id_reporting` int(XX) NOT NULL AUTO_INCREMENT,`iso_feed` LONGTEXT NOT NULL, `reporting_content` LONGTEXT NOT NULL,`id_shop` int(XX) NOT NULL,`date_add` datetime NOT NULL,`date_upd` datetime NOT NULL,PRIMARY KEY (`id_reporting`)) ENGINE=' . _MYSQL_ENGINE_ . ' DEFAULT CHARSET=utfXX;
2 queries	CREATE TABLE IF NOT EXISTS `ps_gmcp_feeds` (`id_feed` int(XX) NOT NULL AUTO_INCREMENT,`iso_lang` LONGTEXT NOT NULL,`iso_country` LONGTEXT NOT NULL,`iso_currency` LONGTEXT NOT NULL, `taxonomy` LONGTEXT NOT NULL, `id_shop` int(XX) NOT NULL,`date_add` datetime NOT NULL,`date_upd` datetime NOT NULL,PRIMARY KEY (`id_feed`)) ENGINE=' . _MYSQL_ENGINE_ . ' DEFAULT CHARSET=utfXX;
2 queries	CREATE TABLE IF NOT EXISTS `ps_gmcp_tags_price_range` (`id_tag` int(XX) NOT NULL, `price_min` CHAR(XX) NOT NULL, `price_max` CHAR(XX), `id_product` CHAR(XX), UNIQUE KEY `tag_price_range` (`id_tag`, `id_product`)) ENGINE=InnoDB DEFAULT CHARSET=utfXX;
2 queries	CREATE TABLE IF NOT EXISTS `ps_gmcp_tmp_rules`(`id` int(XX) NOT NULL AUTO_INCREMENT, `id_shop` int(XX) NOT NULL DEFAULT "XX",`type` char(XX) NOT NULL, `exclusion_values` longtext NOT NULL, PRIMARY KEY (`id`)) ENGINE=InnoDB DEFAULT CHARSET=utfXX AUTO_INCREMENT=XX;
2 queries	CREATE TABLE IF NOT EXISTS `ps_gmcp_tags_dynamic_last_product_ordered` (`id_tag` int(XX) NOT NULL,`start_date` DATETIME, `end_date` DATETIME, `id_product` CHAR(XX), UNIQUE KEY `last_product_ordered` (`id_tag`, `id_product`)) ENGINE=InnoDB DEFAULT CHARSET=utfXX;
2 queries	CREATE TABLE IF NOT EXISTS `ps_gmcp_tags_dynamic_promotion` (`id_tag` int(XX) NOT NULL,`start_date` DATETIME, `end_date` DATETIME, `id_product` CHAR(XX), UNIQUE KEY `promotion` (`id_tag`, `id_product`)) ENGINE=InnoDB DEFAULT CHARSET=utfXX;
2 queries	CREATE TABLE IF NOT EXISTS `ps_gmcp_discount_association` (`id_association` int(XX) NOT NULL AUTO_INCREMENT, `id_discount` int(XX) NOT NULL, `id_product` int(XX) NOT NULL, `channel` CHAR(XX) NOT NULL DEFAULT "SHOPPING_ADS", PRIMARY KEY (`id_association`) ) ENGINE=MyISAM DEFAULT CHARSET=utfXX;
2 queries	CREATE TABLE IF NOT EXISTS `ps_gmcp_tags` (`id_tag` int(XX) NOT NULL AUTO_INCREMENT, `id_shop` int(XX) NOT NULL DEFAULT "XX", `name` char(XX) NOT NULL, `type` char(XX) NOT NULL, `active` TINYINT NOT NULL, `position` INT NOT NULL, `end_date` DATE, PRIMARY KEY (`id_tag`)) ENGINE=MyISAM DEFAULT CHARSET=utfXX AUTO_INCREMENT=XX ;
2 queries	COMMIT
2 queries	SELECT `name` FROM `ps_country_lang` WHERE `id_lang` = XX AND `id_country` = 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 UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache` WHERE `template_hash`=XX AND cache_id="module:tvcmsproductpopup/views/templates/hook/tvcmsproductpopup_footer\|XX\|XX" AND compile_id="child_vXX_swert_smell_XX" LIMIT XX
2 queries	SELECT p., product_shop., stock.out_of_stock, IFNULL(stock.quantity, XX) 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( "XX-XX-XX XX:XX:XX", INTERVAL XX DAY ) ) > XX) as new, product_attribute_shop.minimal_quantity AS product_attribute_minimal_quantity, IFNULL(product_attribute_shop.id_product_attribute,XX) 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 = XX) LEFT JOIN `ps_product_lang` `pl` ON p.`id_product` = pl.`id_product` AND pl.`id_lang` = XX AND pl.id_shop = XX LEFT JOIN `ps_image_shop` `image_shop` ON image_shop.`id_product` = p.`id_product` AND image_shop.cover=XX AND image_shop.id_shop=XX LEFT JOIN `ps_image_lang` `il` ON image_shop.`id_image` = il.`id_image` AND il.`id_lang` = XX LEFT JOIN `ps_manufacturer` `m` ON m.`id_manufacturer` = p.`id_manufacturer` LEFT JOIN `ps_product_attribute_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_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` IN ("both", "catalog")) AND (DATEDIFF(product_shop.`date_add`, DATE_SUB( "XX-XX-XX XX:XX:XX", INTERVAL XX DAY ) ) > XX) ORDER BY product_shop.`date_add` DESC LIMIT XX
2 queries	SELECT mr.* FROM ps_tvcmsmegamenu_row_shop mr WHERE mr.`id_shop` = XX AND mr.id_tvcmsmegamenu = XX AND mr.`active` = XX
2 queries	SELECT count(id_wishlist_product) FROM ps_wishlist w, ps_wishlist_product wp where w.id_wishlist = wp.id_wishlist and w.id_customer=XX LIMIT XX
2 queries	SELECT product_attribute_shop.`price` FROM `ps_product_attribute` pa INNER JOIN ps_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = XX) WHERE pa.`id_product_attribute` = XX LIMIT XX
2 queries	SELECT pa.`available_date` FROM `ps_product` p LEFT JOIN `ps_product_attribute` pa ON (pa.`id_product` = p.`id_product`) INNER JOIN ps_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = XX) INNER JOIN ps_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = XX) WHERE p.`id_product` = XX AND pa.`id_product` = XX AND pa.`id_product_attribute` = XX LIMIT XX
2 queries	SELECT a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, agl.`public_name` as `public_group`, pa.`reference`, pa.`eanXX`, pa.`isbn`, pa.`upc`, pa.`mpn`, pal.`available_now`, pal.`available_later` FROM `ps_attribute` a LEFT JOIN `ps_attribute_lang` al ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = XX) LEFT JOIN `ps_product_attribute_combination` pac ON (pac.`id_attribute` = a.`id_attribute`) LEFT JOIN `ps_product_attribute` pa ON (pa.`id_product_attribute` = pac.`id_product_attribute`) INNER JOIN ps_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = XX) LEFT JOIN `ps_product_attribute_lang` pal ON (pal.`id_product_attribute` = pac.`id_product_attribute` AND pal.`id_lang` = XX) LEFT JOIN `ps_attribute_group_lang` agl ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = XX) WHERE pa.`id_product` = XX AND pac.`id_product_attribute` = XX AND agl.`id_lang` = XX
2 queries	SELECT * FROM `ps_product_attribute` a LEFT JOIN `ps_product_attribute_shop` `c` ON a.`id_product_attribute` = c.`id_product_attribute` AND c.`id_shop` = XX WHERE (a.`id_product_attribute` = XX) LIMIT XX
2 queries	SELECT * FROM `ps_product_attribute_lang` WHERE `id_product_attribute` = XX
2 queries	SELECT pai.`id_image`, pai.`id_product_attribute`, il.`legend` FROM `ps_product_attribute_image` pai LEFT JOIN `ps_image_lang` il ON (il.`id_image` = pai.`id_image`) LEFT JOIN `ps_image` i ON (i.`id_image` = pai.`id_image`) WHERE pai.`id_product_attribute` IN (XX, XX) AND il.`id_lang` = XX ORDER by i.`position`
2 queries	SELECT * FROM `ps_tvcms_image_type` WHERE active = XX AND id_shop = XX

Name	Instances	Source
Product	81	/classes/Link.php:113 (__construct) [id: 406] /classes/Link.php:113 (__construct) [id: 440] /classes/Link.php:113 (__construct) [id: 455] /classes/Link.php:113 (__construct) [id: 471] /classes/Link.php:113 (__construct) [id: 475] /classes/Link.php:113 (__construct) [id: 565] /classes/Link.php:113 (__construct) [id: 568] /classes/Link.php:113 (__construct) [id: 570] /classes/Link.php:113 (__construct) [id: 571] /classes/Link.php:113 (__construct) [id: 639] /classes/Link.php:113 (__construct) [id: 660] /classes/Link.php:113 (__construct) [id: 683] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 406] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 440] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 455] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 471] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 475] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 565] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 568] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 570] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 571] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 639] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 660] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 683] /classes/Link.php:113 (__construct) [id: 406] /classes/Link.php:113 (__construct) [id: 440] /classes/Link.php:113 (__construct) [id: 455] /classes/Link.php:113 (__construct) [id: 471] /classes/Link.php:113 (__construct) [id: 475] /classes/Link.php:113 (__construct) [id: 565] /classes/Link.php:113 (__construct) [id: 568] /classes/Link.php:113 (__construct) [id: 570] /classes/Link.php:113 (__construct) [id: 571] /classes/Link.php:113 (__construct) [id: 639] /classes/Link.php:113 (__construct) [id: 660] /classes/Link.php:113 (__construct) [id: 683] /classes/Link.php:113 (__construct) [id: 986] /classes/Link.php:113 (__construct) [id: 985] /classes/Link.php:113 (__construct) [id: 984] /classes/Link.php:113 (__construct) [id: 983] /classes/Link.php:113 (__construct) [id: 982] /classes/Link.php:113 (__construct) [id: 978] /classes/Link.php:113 (__construct) [id: 977] /classes/Link.php:113 (__construct) [id: 976] /classes/Link.php:113 (__construct) [id: 975] /classes/Link.php:113 (__construct) [id: 974] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 986] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 985] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 984] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 983] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 982] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 978] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 977] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 976] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 975] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 974] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 986] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 985] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 984] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 983] /classes/Link.php:113 (__construct) [id: 972] /classes/Link.php:113 (__construct) [id: 971] /classes/Link.php:113 (__construct) [id: 970] /classes/Link.php:113 (__construct) [id: 952] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 972] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 971] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 970] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 952] /classes/Link.php:113 (__construct) [id: 750] /classes/Link.php:113 (__construct) [id: 285] /classes/Link.php:113 (__construct) [id: 134] /classes/Link.php:113 (__construct) [id: 124] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 750] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 285] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 134] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 124] /classes/Link.php:113 (__construct) [id: 256] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 256] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 23] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 32] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 29]
Category	43	/controllers/front/listing/CategoryController.php:78 (__construct) [id: 2] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 9] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 12] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 21] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 58] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 51] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 73] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 140] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 153] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 169] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 170] /classes/Meta.php:380 (__construct) [id: 2] /classes/PrestaShopCollection.php:385 (hydrateCollection) [id: ] /classes/Link.php:402 (__construct) [id: 2] /classes/Meta.php:380 (__construct) [id: 2] /modules/ets_seo/ets_seo.php:2594 (__construct) [id: 2] /modules/ets_seo/ets_seo.php:2775 (__construct) [id: 2] /classes/Link.php:402 (__construct) [id: 2] /modules/ps_facetedsearch/src/Filters/Block.php:157 (__construct) [id: 2] /modules/tvcmsmegamenu/tvcmsmegamenu.php:1395 (__construct) [id: 21] /modules/tvcmsmegamenu/tvcmsmegamenu.php:1774 (__construct) [id: 21] /classes/Link.php:402 (__construct) [id: 21] /modules/tvcmsmegamenu/tvcmsmegamenu.php:1699 (__construct) [id: 21] /modules/tvcmsmegamenu/tvcmsmegamenu.php:1395 (__construct) [id: 58] /modules/tvcmsmegamenu/tvcmsmegamenu.php:1774 (__construct) [id: 58] /classes/Link.php:402 (__construct) [id: 58] /modules/tvcmsmegamenu/tvcmsmegamenu.php:1699 (__construct) [id: 58] /modules/tvcmsmegamenu/tvcmsmegamenu.php:1395 (__construct) [id: 51] /modules/tvcmsmegamenu/tvcmsmegamenu.php:1774 (__construct) [id: 51] /classes/Link.php:402 (__construct) [id: 51] /modules/tvcmsmegamenu/tvcmsmegamenu.php:1699 (__construct) [id: 51] /modules/tvcmsmegamenu/tvcmsmegamenu.php:1395 (__construct) [id: 153] /modules/tvcmsmegamenu/tvcmsmegamenu.php:1774 (__construct) [id: 153] /classes/Link.php:402 (__construct) [id: 153] /modules/tvcmsmegamenu/tvcmsmegamenu.php:1699 (__construct) [id: 153] /modules/tvcmsmegamenu/tvcmsmegamenu.php:1395 (__construct) [id: 20] /modules/tvcmsmegamenu/tvcmsmegamenu.php:1774 (__construct) [id: 20] /classes/Link.php:402 (__construct) [id: 20] /modules/tvcmsmegamenu/tvcmsmegamenu.php:1699 (__construct) [id: 20] /modules/tvcmssearch/tvcmssearch.php:100 (getNestedCategories) [id: 2] /modules/ps_categorytree/ps_categorytree.php:364 (getParentsCategories) [id: 2] /modules/tvcmstabproducts/tvcmstabproducts.php:2683 (__construct) [id: 2] /classes/Link.php:402 (__construct) [id: 2]
Country	12	/config/config.inc.php:146 (__construct) [id: 10] /classes/controller/FrontController.php:354 (__construct) [id: 10] /classes/AddressFormat.php:404 (__construct) [id: 10] /classes/controller/FrontController.php:1779 (__construct) [id: 10] /modules/paypal/paypal.php:350 (__construct) [id: 10] /modules/gmerchantcenterpro/lib/moduleTools.php:211 (__construct) [id: 10] /modules/gmerchantcenterpro/lib/moduleTools.php:211 (__construct) [id: 19] /classes/AddressFormat.php:404 (__construct) [id: 10] /modules/ps_contactinfo/ps_contactinfo.php:105 (__construct) [id: 10] /classes/AddressFormat.php:404 (__construct) [id: 10] /modules/ps_contactinfo/ps_contactinfo.php:105 (__construct) [id: 10] /modules/ets_whatsapp/ets_whatsapp.php:466 (__construct) [id: 10]
State	8	/classes/AddressFormat.php:404 (__construct) [id: 128] /classes/controller/FrontController.php:1778 (__construct) [id: 128] /classes/AddressFormat.php:404 (__construct) [id: 128] /modules/ps_contactinfo/ps_contactinfo.php:94 (__construct) [id: 128] /modules/ps_contactinfo/ps_contactinfo.php:104 (__construct) [id: 128] /classes/AddressFormat.php:404 (__construct) [id: 128] /modules/ps_contactinfo/ps_contactinfo.php:94 (__construct) [id: 128] /modules/ps_contactinfo/ps_contactinfo.php:104 (__construct) [id: 128]
Address	4	/classes/shop/Shop.php:486 (__construct) [id: ] /classes/Product.php:3694 (initialize) [id: ] /classes/Product.php:3804 (__construct) [id: ] /classes/Product.php:5964 (__construct) [id: ]
Language	4	/config/config.inc.php:211 (__construct) [id: 1] /classes/Tools.php:560 (__construct) [id: 1] /modules/gmerchantcenterpro/lib/moduleTools.php:206 (__construct) [id: 1] /modules/gmerchantcenterpro/lib/moduleTools.php:206 (__construct) [id: 1]
TvcmsCategoryClass	4	/modules/tvcmsblog/classes/tvcmspostsclass.php:775 (__construct) [id: 0] /modules/tvcmsblog/classes/tvcmspostsclass.php:775 (__construct) [id: 0] /modules/tvcmsblog/classes/tvcmspostsclass.php:775 (__construct) [id: 1] /modules/tvcmsblog/classes/tvcmspostsclass.php:775 (__construct) [id: 1]
Employee	4	/modules/tvcmsblog/classes/tvcmspostsclass.php:729 (__construct) [id: 5] /modules/tvcmsblog/classes/tvcmspostsclass.php:729 (__construct) [id: 5] /modules/tvcmsblog/classes/tvcmspostsclass.php:729 (__construct) [id: 5] /modules/tvcmsblog/classes/tvcmspostsclass.php:729 (__construct) [id: 5]
Currency	3	/src/Adapter/Currency/CurrencyDataProvider.php:101 (__construct) [id: 1] /classes/Tools.php:695 (getCurrencyInstance) [id: 1] /modules/gmerchantcenterpro/lib/moduleTools.php:216 (__construct) [id: 1]
AddressFormat	3	/classes/controller/FrontController.php:1773 (generateAddress) [id: ] /modules/ps_contactinfo/ps_contactinfo.php:91 (generateAddress) [id: ] /modules/ps_contactinfo/ps_contactinfo.php:91 (generateAddress) [id: ]
Tax	2	/classes/tax/TaxRulesTaxManager.php:116 (__construct) [id: 1] /classes/tax/TaxRulesTaxManager.php:116 (__construct) [id: 1]
Cart	2	/classes/controller/FrontController.php:467 (__construct) [id: ] /classes/controller/FrontController.php:541 (__construct) [id: ]
Combination	2	/classes/Product.php:5912 (__construct) [id: 47] /classes/Product.php:5912 (__construct) [id: 98]
Connection	1	/modules/statsdata/statsdata.php:118 (setPageConnection) [id: ]
Guest	1	/modules/statsdata/statsdata.php:82 (setNewGuest) [id: ]
Shop	1	/config/config.inc.php:117 (initialize) [id: 1]
TvcmsMegaMenuClass	1	/modules/tvcmsmegamenu/tvcmsmegamenu.php:1384 (__construct) [id: ]
Risk	1	/classes/controller/FrontController.php:1705 (__construct) [id: ]
Gender	1	/classes/controller/FrontController.php:1702 (__construct) [id: 0]
Group	1	/classes/Cart.php:249 (getCurrent) [id: 1]
Customer	1	/config/config.inc.php:264 (__construct) [id: ]
ShopGroup	1	/classes/shop/Shop.php:561 (__construct) [id: 1]
ConnectionsSource	1	/modules/statsdata/statsdata.php:119 (logHttpReferer) [id: ]

Module	Time	Memory Usage
klaviyopsautomation	2.781 ms	- Mb
__construct	2.737 ms	- Mb
hookModuleRoutes	0.017 ms	- Mb
hookActionFrontControllerInitAfter	0.016 ms	- Mb
hookActionFrontControllerSetMedia	0.011 ms	- Mb
ps_checkout	107.972 ms	0.39 Mb
__construct	51.603 ms	0.21 Mb
hookModuleRoutes	0.010 ms	- Mb
hookActionFrontControllerSetMedia	56.359 ms	0.18 Mb
tvcmsblog	3.422 ms	0.08 Mb
__construct	3.015 ms	0.03 Mb
hookModuleRoutes	0.046 ms	0.01 Mb
hookDisplayHeader	0.352 ms	0.05 Mb
hookDisplayBeforeBodyClosingTag	0.009 ms	- Mb
ets_reviews	3.675 ms	0.33 Mb
__construct	1.983 ms	0.20 Mb
hookModuleRoutes	1.062 ms	0.02 Mb
hookDisplayHeader	0.092 ms	- Mb
hookDisplayProductPriceBlock	0.010 ms	- Mb
hookDisplayProductPriceBlock	0.006 ms	- Mb
hookDisplayProductPriceBlock	0.004 ms	- Mb
hookDisplayProductPriceBlock	0.004 ms	- Mb
hookDisplayProductPriceBlock	0.003 ms	- Mb
hookDisplayProductPriceBlock	0.002 ms	- Mb
hookDisplayProductPriceBlock	0.003 ms	- Mb
hookDisplayProductPriceBlock	0.003 ms	- Mb
hookDisplayProductPriceBlock	0.002 ms	- Mb
hookDisplayProductPriceBlock	0.004 ms	- Mb
hookDisplayProductPriceBlock	0.003 ms	- Mb
hookDisplayProductPriceBlock	0.002 ms	- Mb
hookDisplayProductPriceBlock	0.005 ms	- Mb
hookDisplayProductPriceBlock	0.002 ms	- Mb
hookDisplayProductPriceBlock	0.003 ms	- Mb
hookDisplayProductPriceBlock	0.004 ms	- Mb
hookDisplayProductPriceBlock	0.002 ms	- Mb
hookDisplayProductPriceBlock	0.001 ms	- Mb
hookDisplayProductPriceBlock	0.002 ms	- Mb
hookDisplayProductPriceBlock	0.001 ms	- Mb
hookDisplayProductPriceBlock	0.002 ms	- Mb
hookDisplayProductPriceBlock	0.003 ms	- Mb

#	Query	Time (ms)	Rows	Filesort	Group By	Location
153	SELECT SQL_NO_CACHE COUNT(DISTINCT p.id_product) c 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, cp.position 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_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) WHERE ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cp.id_category IN (12, 9) GROUP BY p.id_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_stock_available sa_1 ON (p.id_product = sa_1.id_product AND IFNULL(pac.id_product_attribute, 0) = sa_1.id_product_attribute AND sa_1.id_shop = 1 AND sa_1.id_shop_group = 0 ) WHERE ((sa.quantity<=0 AND sa_1.out_of_stock IN (0, 2)))	67.032 ms	25960			/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:778 (execute) /modules/ps_facetedsearch/src/Adapter/MySQL.php:757 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:480 (count) /modules/ps_facetedsearch/src/Filters/Block.php:140 (getAvailabilitiesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
1411	SELECT SQL_NO_CACHE id_page_type FROM ps_page_type WHERE name = 'category' LIMIT 1	56.915 ms	1			/classes/Page.php:104 /classes/Page.php:55 (getPageTypeByName) /classes/Connection.php:180 (getCurrentId) /classes/Connection.php:97 (setNewConnection) /modules/statsdata/statsdata.php:118 (setPageConnection) /modules/statsdata/statsdata.php:74 (getScriptCustomerPagesViews) /classes/Hook.php:1083 (hookDisplayBeforeBodyClosingTag) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:421 (coreCallHook) /classes/Hook.php:989 (callHookOn) /config/smarty.config.inc.php:201 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/prod/smarty/compile/child_v4_swert_smell_70layouts_layout_left_column_tpl/8f/37/95/8f3795b4a93d48b203ec4f57dbf6538087b26c3f_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/child_v4_swert_smell_70layouts_layout_left_column_tpl/8f/37/95/8f3795b4a93d48b203ec4f57dbf6538087b26c3f_2.file.layout-both-columns.tpl.php:90 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_681b4f69396bf4_25173037) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/child_v4_swert_smell_70layouts_layout_left_column_tpl/2c/f3/59/2cf359a4bde30a497bd3846c4e7eed28bd416158_2.file.layout-left-column.tpl.php:28 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_681b4f693498d1_48637902) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/child_v4_swert_smell_70layouts_layout_left_column_tpl/06/96/b8/0696b8dda42afe8abc39c0ae77760a155a97487a_2.file.product-list.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_681b4f69318f69_46238223) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/child_v4_swert_smell_70layouts_layout_left_column_tpl/e9/63/70/e963706bc093b6c72ec0976bcd7f9787d22154f2_2.file.category.tpl.php:29 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6825e843ab5c66_97590843) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/Smarty/SmartyCustom.php:112 (fetch) /classes/controller/FrontController.php:771 (fetch) /classes/controller/FrontController.php:753 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
134	SELECT SQL_NO_CACHE c.id_currency FROM `ps_currency` c WHERE (deleted = 0) AND (iso_code = 'EUR') LIMIT 1	52.958 ms	1			/classes/Currency.php:893 /modules/gmerchantcenterpro/lib/moduleTools.php:215 (getIdByIsoCode) /modules/gmerchantcenterpro/gmerchantcenterpro.php:197 (getLangCurrencyCountry) :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:1263 (get) /tools/profiling/Module.php:35 (coreLoadModule) /classes/module/Module.php:1242 (coreLoadModule) /classes/Hook.php:972 (getInstanceByName) /classes/controller/FrontController.php:633 (exec) /controllers/front/listing/CategoryController.php:127 (initContent) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
81	SELECT SQL_NO_CACHE * FROM `ps_ets_seo_category` WHERE id_category = 2 AND id_shop = 1 AND id_lang = 1 LIMIT 1	52.047 ms	0			/modules/ets_seo/classes/EtsSeoCategory.php:242 /modules/ets_seo/ets_seo.php:3145 (getSeoCategory) /modules/ets_seo/ets_seo.php:2339 (getSeoMetaDataArray) /classes/Hook.php:1083 (hookDisplayHeader) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:421 (coreCallHook) /classes/Hook.php:989 (callHookOn) /classes/controller/FrontController.php:633 (exec) /controllers/front/listing/CategoryController.php:127 (initContent) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
20	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	49.139 ms	124			/classes/module/Module.php:346 /modules/ps_checkout/ps_checkout.php:149 (__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:1263 (get) /tools/profiling/Module.php:35 (coreLoadModule) /classes/module/Module.php:1242 (coreLoadModule) /classes/Hook.php:972 (getInstanceByName) /classes/Dispatcher.php:606 (exec) /classes/Dispatcher.php:243 (loadRoutes) /override/classes/Dispatcher.php:48 (__construct) /classes/Dispatcher.php:201 (__construct) /index.php:28 (getInstance)
159	SELECT SQL_NO_CACHE psi.price_min, MIN(price_min) as min, MAX(price_max) as max FROM ps_product p INNER JOIN ps_layered_price_index psi ON (psi.id_product = p.id_product AND psi.id_shop = 1 AND psi.id_currency = 1 AND psi.id_country = 10) 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) 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_stock_available sa_1 ON (p.id_product = sa_1.id_product AND IFNULL(pac.id_product_attribute, 0) = sa_1.id_product_attribute AND sa_1.id_shop = 1 AND sa_1.id_shop_group = 0 ) WHERE ((sa.quantity<=0 AND sa_1.out_of_stock IN (0, 2))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cp.id_category IN (12, 9)	48.314 ms	6490			/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:57 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:250 (getMinMaxPriceValue) /modules/ps_facetedsearch/src/Filters/Block.php:131 (getPriceRangeBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
834	SELECT SQL_NO_CACHE p., ps., pl.*, sa.out_of_stock, IFNULL(sa.quantity, 0) as quantity, (DATEDIFF( p.`date_add`, DATE_SUB( '2025-05-15 00:00:00', INTERVAL 1000 DAY ) ) > 0) as new FROM ps_product p LEFT JOIN ps_product_lang pl ON pl.id_product = p.id_product AND pl.id_shop = 1 AND pl.id_lang = 1 LEFT JOIN ps_stock_available sa ON sa.id_product = p.id_product AND sa.id_product_attribute = 0 AND sa.id_shop = 1 LEFT JOIN ps_product_shop ps ON ps.id_product = p.id_product AND ps.id_shop = 1 WHERE p.id_product IN (970)	43.631 ms	1			/classes/ProductAssembler.php:64 /classes/ProductAssembler.php:182 (addMissingProductFields) /modules/tvcmstabproducts/tvcmstabproducts.php:2850 (assembleProduct) /modules/tvcmsspecialproducts/tvcmsspecialproducts.php:157 (displaySpecialProducts) /modules/tvcmsspecialproducts/tvcmsspecialproducts.php:268 (showFrontSideResult) /classes/Hook.php:1083 (hookdisplayLeftColumn) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:421 (coreCallHook) /classes/Hook.php:989 (callHookOn) /config/smarty.config.inc.php:201 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/prod/smarty/compile/child_v4_swert_smell_70layouts_layout_left_column_tpl/8f/37/95/8f3795b4a93d48b203ec4f57dbf6538087b26c3f_2.file.layout-both-columns.tpl.php:195 (__call) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/child_v4_swert_smell_70layouts_layout_left_column_tpl/8f/37/95/8f3795b4a93d48b203ec4f57dbf6538087b26c3f_2.file.layout-both-columns.tpl.php:75 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_681b4f69396bf4_25173037) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/child_v4_swert_smell_70layouts_layout_left_column_tpl/2c/f3/59/2cf359a4bde30a497bd3846c4e7eed28bd416158_2.file.layout-left-column.tpl.php:28 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_681b4f693498d1_48637902) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/child_v4_swert_smell_70layouts_layout_left_column_tpl/06/96/b8/0696b8dda42afe8abc39c0ae77760a155a97487a_2.file.product-list.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_681b4f69318f69_46238223) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/child_v4_swert_smell_70layouts_layout_left_column_tpl/e9/63/70/e963706bc093b6c72ec0976bcd7f9787d22154f2_2.file.category.tpl.php:29 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6825e843ab5c66_97590843) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/Smarty/SmartyCustom.php:112 (fetch) /classes/controller/FrontController.php:771 (fetch) /classes/controller/FrontController.php:753 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
1065	SELECT SQL_NO_CACHE COUNT(id_tvcms_comments) AS total_comment FROM `ps_tvcms_comments` xc WHERE xc.`id_post` = 3	42.204 ms	1			/modules/tvcmsblog/classes/tvcmscommentclass.php:109 /modules/tvcmsblog/classes/tvcmspostsclass.php:790 (getCountComments) /modules/tvcmsblogdisplayposts/tvcmsblogdisplayposts.php:418 (getCategoryPosts) /modules/tvcmsblogdisplayposts/tvcmsblogdisplayposts.php:483 (showFrontSideResult) /classes/Hook.php:1083 (hookdisplayLeftColumn) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:421 (coreCallHook) /classes/Hook.php:989 (callHookOn) /config/smarty.config.inc.php:201 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/prod/smarty/compile/child_v4_swert_smell_70layouts_layout_left_column_tpl/8f/37/95/8f3795b4a93d48b203ec4f57dbf6538087b26c3f_2.file.layout-both-columns.tpl.php:195 (__call) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/child_v4_swert_smell_70layouts_layout_left_column_tpl/8f/37/95/8f3795b4a93d48b203ec4f57dbf6538087b26c3f_2.file.layout-both-columns.tpl.php:75 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_681b4f69396bf4_25173037) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/child_v4_swert_smell_70layouts_layout_left_column_tpl/2c/f3/59/2cf359a4bde30a497bd3846c4e7eed28bd416158_2.file.layout-left-column.tpl.php:28 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_681b4f693498d1_48637902) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/child_v4_swert_smell_70layouts_layout_left_column_tpl/06/96/b8/0696b8dda42afe8abc39c0ae77760a155a97487a_2.file.product-list.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_681b4f69318f69_46238223) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/child_v4_swert_smell_70layouts_layout_left_column_tpl/e9/63/70/e963706bc093b6c72ec0976bcd7f9787d22154f2_2.file.category.tpl.php:29 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6825e843ab5c66_97590843) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/Smarty/SmartyCustom.php:112 (fetch) /classes/controller/FrontController.php:771 (fetch) /classes/controller/FrontController.php:753 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
749	SELECT SQL_NO_CACHE `id_tax_rules_group` FROM `ps_product_shop` WHERE `id_product` = 964 AND id_shop=1 LIMIT 1	40.863 ms	1			/classes/Product.php:6876 /classes/Product.php:3925 (getIdTaxRulesGroupByIdProduct) /classes/Product.php:3717 (priceCalculation) /classes/Tools.php:1700 (getPriceStatic) /classes/Product.php:3400 (orderbyPrice) /modules/tvcmstabproducts/tvcmstabproducts.php:2817 (getPricesDrop) /modules/tvcmsspecialproducts/tvcmsspecialproducts.php:157 (displaySpecialProducts) /modules/tvcmsspecialproducts/tvcmsspecialproducts.php:268 (showFrontSideResult) /classes/Hook.php:1083 (hookdisplayLeftColumn) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:421 (coreCallHook) /classes/Hook.php:989 (callHookOn) /config/smarty.config.inc.php:201 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/prod/smarty/compile/child_v4_swert_smell_70layouts_layout_left_column_tpl/8f/37/95/8f3795b4a93d48b203ec4f57dbf6538087b26c3f_2.file.layout-both-columns.tpl.php:195 (__call) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/child_v4_swert_smell_70layouts_layout_left_column_tpl/8f/37/95/8f3795b4a93d48b203ec4f57dbf6538087b26c3f_2.file.layout-both-columns.tpl.php:75 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_681b4f69396bf4_25173037) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/child_v4_swert_smell_70layouts_layout_left_column_tpl/2c/f3/59/2cf359a4bde30a497bd3846c4e7eed28bd416158_2.file.layout-left-column.tpl.php:28 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_681b4f693498d1_48637902) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/child_v4_swert_smell_70layouts_layout_left_column_tpl/06/96/b8/0696b8dda42afe8abc39c0ae77760a155a97487a_2.file.product-list.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_681b4f69318f69_46238223) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/child_v4_swert_smell_70layouts_layout_left_column_tpl/e9/63/70/e963706bc093b6c72ec0976bcd7f9787d22154f2_2.file.category.tpl.php:29 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6825e843ab5c66_97590843) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/Smarty/SmartyCustom.php:112 (fetch) /classes/controller/FrontController.php:771 (fetch) /classes/controller/FrontController.php:753 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
932	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` = 1 LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1 WHERE (a.`id_product` = 23) AND (b.`id_shop` = 1) LIMIT 1	38.903 ms	1			/src/Adapter/EntityMapper.php:71 /classes/ObjectModel.php:283 (load) /tools/profiling/ObjectModel.php:32 (__construct) /classes/Product.php:725 (__construct) /src/Adapter/Image/ImageRetriever.php:80 (__construct) /src/Adapter/Presenter/Product/ProductLazyArray.php:684 (getAllProductImages) /src/Adapter/Presenter/Product/ProductLazyArray.php:127 (fillImages) /src/Adapter/Presenter/Product/ProductListingPresenter.php:57 (__construct) /modules/tvcmstabproducts/tvcmstabproducts.php:2913 (present) /modules/tvcmsbestsellerproducts/tvcmsbestsellerproducts.php:156 (displayBestSellers) /modules/tvcmsbestsellerproducts/tvcmsbestsellerproducts.php:269 (showFrontSideResult) /classes/Hook.php:1083 (hookdisplayLeftColumn) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:421 (coreCallHook) /classes/Hook.php:989 (callHookOn) /config/smarty.config.inc.php:201 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/prod/smarty/compile/child_v4_swert_smell_70layouts_layout_left_column_tpl/8f/37/95/8f3795b4a93d48b203ec4f57dbf6538087b26c3f_2.file.layout-both-columns.tpl.php:195 (__call) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/child_v4_swert_smell_70layouts_layout_left_column_tpl/8f/37/95/8f3795b4a93d48b203ec4f57dbf6538087b26c3f_2.file.layout-both-columns.tpl.php:75 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_681b4f69396bf4_25173037) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/child_v4_swert_smell_70layouts_layout_left_column_tpl/2c/f3/59/2cf359a4bde30a497bd3846c4e7eed28bd416158_2.file.layout-left-column.tpl.php:28 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_681b4f693498d1_48637902) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/child_v4_swert_smell_70layouts_layout_left_column_tpl/06/96/b8/0696b8dda42afe8abc39c0ae77760a155a97487a_2.file.product-list.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_681b4f69318f69_46238223) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/child_v4_swert_smell_70layouts_layout_left_column_tpl/e9/63/70/e963706bc093b6c72ec0976bcd7f9787d22154f2_2.file.category.tpl.php:29 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6825e843ab5c66_97590843) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/Smarty/SmartyCustom.php:112 (fetch) /classes/controller/FrontController.php:771 (fetch) /classes/controller/FrontController.php:753 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
172	SELECT SQL_NO_CACHE DISTINCT a.`id_attribute`, a.`color`, al.`name`, agl.`id_attribute_group`, IF(lialv.`url_name` IS NULL OR lialv.`url_name` = "", NULL, lialv.`url_name`) AS url_name, IF(lialv.`meta_title` IS NULL OR lialv.`meta_title` = "", NULL, lialv.`meta_title`) AS meta_title FROM `ps_attribute_group` ag INNER JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1) INNER JOIN `ps_attribute` a ON a.`id_attribute_group` = ag.`id_attribute_group` INNER JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1) INNER JOIN ps_attribute_group_shop attribute_group_shop ON (attribute_group_shop.id_attribute_group = ag.id_attribute_group AND attribute_group_shop.id_shop = 1) INNER JOIN ps_attribute_shop attribute_shop ON (attribute_shop.id_attribute = a.id_attribute AND attribute_shop.id_shop = 1) LEFT JOIN `ps_layered_indexable_attribute_lang_value` lialv ON (a.`id_attribute` = lialv.`id_attribute` AND lialv.`id_lang` = 1) WHERE ag.id_attribute_group = 4 ORDER BY agl.`name` ASC, a.`position` ASC	35.024 ms	0			/modules/ps_facetedsearch/src/Filters/DataAccessor.php:96 /modules/ps_facetedsearch/src/Filters/Block.php:731 (getAttributes) /modules/ps_facetedsearch/src/Filters/Block.php:150 (getAttributesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
259	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` = 639 AND image_shop.`cover` = 1 LIMIT 1	34.386 ms	1			/classes/Product.php:3570 /classes/Product.php:5643 (getCover) /classes/ProductAssembler.php:209 (getProductProperties) /classes/controller/ProductListingFrontController.php:108 (assembleProducts) /classes/controller/ProductListingFrontController.php:379 (prepareMultipleProductsForTemplate) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
481	SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop` FROM `ps_category` c LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 ) INNER JOIN ps_category_shop category_shop ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1) WHERE `id_lang` = 1 AND c.`id_parent` = 20 AND `active` = 1 GROUP BY c.`id_category` ORDER BY category_shop.`position` ASC	33.775 ms	1	Yes	Yes	/classes/Category.php:1151 /modules/tvcmsmegamenu/tvcmsmegamenu.php:1782 (getChildren) /modules/tvcmsmegamenu/tvcmsmegamenu.php:1397 (getRespCategories) /modules/tvcmsmegamenu/tvcmsmegamenu.php:1362 (getWidgetVariables) /classes/Hook.php:1083 (hookdisplayMegamenu) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:421 (coreCallHook) /classes/Hook.php:989 (callHookOn) /config/smarty.config.inc.php:201 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/prod/smarty/compile/child_v4_swert_smell_70layouts_layout_left_column_tpl/d7/8c/52/d78c525e835956275175baed0dc1961dd1dd5470_2.file.desk-header-4.tpl.php:29 (__call) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6825e84411ed33_73816054) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /var/cache/prod/smarty/compile/child_v4_swert_smell_70layouts_layout_left_column_tpl/1d/d8/d3/1dd8d30d11b8305632e1713f0fc527bbff25834f_2.file.desktop-header.tpl.php:25 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_681b4f69e35258_98697214) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /var/cache/prod/smarty/compile/child_v4_swert_smell_70layouts_layout_left_column_tpl/d0/c8/99/d0c899298e2c7cf95202bfd50ba7a6f767510e61_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/child_v4_swert_smell_70layouts_layout_left_column_tpl/d0/c8/99/d0c899298e2c7cf95202bfd50ba7a6f767510e61_2.file.header.tpl.php:29 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_681b4f69e0cc59_18739253) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /var/cache/prod/smarty/compile/child_v4_swert_smell_70layouts_layout_left_column_tpl/8f/37/95/8f3795b4a93d48b203ec4f57dbf6538087b26c3f_2.file.layout-both-columns.tpl.php:147 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/child_v4_swert_smell_70layouts_layout_left_column_tpl/8f/37/95/8f3795b4a93d48b203ec4f57dbf6538087b26c3f_2.file.layout-both-columns.tpl.php:65 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_681b4f69396bf4_25173037) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/child_v4_swert_smell_70layouts_layout_left_column_tpl/2c/f3/59/2cf359a4bde30a497bd3846c4e7eed28bd416158_2.file.layout-left-column.tpl.php:28 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_681b4f693498d1_48637902) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/child_v4_swert_smell_70layouts_layout_left_column_tpl/06/96/b8/0696b8dda42afe8abc39c0ae77760a155a97487a_2.file.product-list.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_681b4f69318f69_46238223) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/child_v4_swert_smell_70layouts_layout_left_column_tpl/e9/63/70/e963706bc093b6c72ec0976bcd7f9787d22154f2_2.file.category.tpl.php:29 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6825e843ab5c66_97590843) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/Smarty/SmartyCustom.php:112 (fetch) /classes/controller/FrontController.php:771 (fetch) /classes/controller/FrontController.php:753 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
388	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` = 977 AND image_shop.`cover` = 1 LIMIT 1	31.275 ms	1			/classes/Product.php:3570 /classes/Product.php:5643 (getCover) /classes/Product.php:5990 (getProductProperties) /classes/Product.php:3127 (getProductsProperties) /modules/tvcmsproductpopup/tvcmsproductpopup.php:368 (getNewProducts) /modules/tvcmsproductpopup/tvcmsproductpopup.php:253 (getNewProducts) /modules/tvcmsproductpopup/tvcmsproductpopup.php:547 (prevHook) /classes/Hook.php:1083 (hookdisplayAfterBodyOpeningTag) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:421 (coreCallHook) /classes/Hook.php:989 (callHookOn) /config/smarty.config.inc.php:201 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/prod/smarty/compile/child_v4_swert_smell_70layouts_layout_left_column_tpl/8f/37/95/8f3795b4a93d48b203ec4f57dbf6538087b26c3f_2.file.layout-both-columns.tpl.php:117 (__call) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/child_v4_swert_smell_70layouts_layout_left_column_tpl/8f/37/95/8f3795b4a93d48b203ec4f57dbf6538087b26c3f_2.file.layout-both-columns.tpl.php:55 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_681b4f69396bf4_25173037) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/child_v4_swert_smell_70layouts_layout_left_column_tpl/2c/f3/59/2cf359a4bde30a497bd3846c4e7eed28bd416158_2.file.layout-left-column.tpl.php:28 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_681b4f693498d1_48637902) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/child_v4_swert_smell_70layouts_layout_left_column_tpl/06/96/b8/0696b8dda42afe8abc39c0ae77760a155a97487a_2.file.product-list.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_681b4f69318f69_46238223) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/child_v4_swert_smell_70layouts_layout_left_column_tpl/e9/63/70/e963706bc093b6c72ec0976bcd7f9787d22154f2_2.file.category.tpl.php:29 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6825e843ab5c66_97590843) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/Smarty/SmartyCustom.php:112 (fetch) /classes/controller/FrontController.php:771 (fetch) /classes/controller/FrontController.php:753 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
601	SELECT SQL_NO_CACHE 1 FROM `ps_specific_price` WHERE id_product = 102 LIMIT 1	21.350 ms	1			/classes/SpecificPrice.php:435 /classes/SpecificPrice.php:523 (couldHaveSpecificPrice) /classes/Product.php:3827 (getSpecificPrice) /classes/Product.php:3717 (priceCalculation) /classes/Tools.php:1700 (getPriceStatic) /classes/Product.php:3400 (orderbyPrice) /modules/tvcmstabproducts/tvcmstabproducts.php:2817 (getPricesDrop) /modules/tvcmsspecialproducts/tvcmsspecialproducts.php:157 (displaySpecialProducts) /modules/tvcmsspecialproducts/tvcmsspecialproducts.php:268 (showFrontSideResult) /classes/Hook.php:1083 (hookdisplayLeftColumn) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:421 (coreCallHook) /classes/Hook.php:989 (callHookOn) /config/smarty.config.inc.php:201 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/prod/smarty/compile/child_v4_swert_smell_70layouts_layout_left_column_tpl/8f/37/95/8f3795b4a93d48b203ec4f57dbf6538087b26c3f_2.file.layout-both-columns.tpl.php:195 (__call) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/child_v4_swert_smell_70layouts_layout_left_column_tpl/8f/37/95/8f3795b4a93d48b203ec4f57dbf6538087b26c3f_2.file.layout-both-columns.tpl.php:75 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_681b4f69396bf4_25173037) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/child_v4_swert_smell_70layouts_layout_left_column_tpl/2c/f3/59/2cf359a4bde30a497bd3846c4e7eed28bd416158_2.file.layout-left-column.tpl.php:28 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_681b4f693498d1_48637902) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/child_v4_swert_smell_70layouts_layout_left_column_tpl/06/96/b8/0696b8dda42afe8abc39c0ae77760a155a97487a_2.file.product-list.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_681b4f69318f69_46238223) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/child_v4_swert_smell_70layouts_layout_left_column_tpl/e9/63/70/e963706bc093b6c72ec0976bcd7f9787d22154f2_2.file.category.tpl.php:29 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6825e843ab5c66_97590843) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/Smarty/SmartyCustom.php:112 (fetch) /classes/controller/FrontController.php:771 (fetch) /classes/controller/FrontController.php:753 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
886	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("2025-05-15 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` = 1 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` = 1) 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` = 10 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' ORDER BY `sales` DESC LIMIT 0, 4	19.577 ms	649	Yes		/classes/ProductSale.php:151 /src/Adapter/BestSales/BestSalesProductSearchProvider.php:74 (getBestSales) /modules/tvcmstabproducts/tvcmstabproducts.php:2879 (runQuery) /modules/tvcmsbestsellerproducts/tvcmsbestsellerproducts.php:156 (displayBestSellers) /modules/tvcmsbestsellerproducts/tvcmsbestsellerproducts.php:269 (showFrontSideResult) /classes/Hook.php:1083 (hookdisplayLeftColumn) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:421 (coreCallHook) /classes/Hook.php:989 (callHookOn) /config/smarty.config.inc.php:201 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/prod/smarty/compile/child_v4_swert_smell_70layouts_layout_left_column_tpl/8f/37/95/8f3795b4a93d48b203ec4f57dbf6538087b26c3f_2.file.layout-both-columns.tpl.php:195 (__call) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/child_v4_swert_smell_70layouts_layout_left_column_tpl/8f/37/95/8f3795b4a93d48b203ec4f57dbf6538087b26c3f_2.file.layout-both-columns.tpl.php:75 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_681b4f69396bf4_25173037) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/child_v4_swert_smell_70layouts_layout_left_column_tpl/2c/f3/59/2cf359a4bde30a497bd3846c4e7eed28bd416158_2.file.layout-left-column.tpl.php:28 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_681b4f693498d1_48637902) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/child_v4_swert_smell_70layouts_layout_left_column_tpl/06/96/b8/0696b8dda42afe8abc39c0ae77760a155a97487a_2.file.product-list.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_681b4f69318f69_46238223) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/child_v4_swert_smell_70layouts_layout_left_column_tpl/e9/63/70/e963706bc093b6c72ec0976bcd7f9787d22154f2_2.file.category.tpl.php:29 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6825e843ab5c66_97590843) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/Smarty/SmartyCustom.php:112 (fetch) /classes/controller/FrontController.php:771 (fetch) /classes/controller/FrontController.php:753 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
842	SELECT SQL_NO_CACHE p., product_shop., stock.out_of_stock, IFNULL(stock.quantity, 0) AS quantity, IFNULL(product_attribute_shop.id_product_attribute, 0) AS id_product_attribute, product_attribute_shop.minimal_quantity AS product_attribute_minimal_quantity, pl.`description`, pl.`description_short`, pl.`available_now`, pl.`available_later`, pl.`link_rewrite`, pl.`meta_description`, pl.`meta_keywords`, pl.`meta_title`, pl.`name`, image_shop.`id_image` id_image, il.`legend` as legend, m.`name` AS manufacturer_name, cl.`name` AS category_default, DATEDIFF(product_shop.`date_add`, DATE_SUB("2025-05-15 00:00:00", INTERVAL 1000 DAY)) > 0 AS new, product_shop.price AS orderprice FROM `ps_category_product` cp LEFT JOIN `ps_product` p ON p.`id_product` = cp.`id_product` INNER JOIN ps_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) LEFT JOIN `ps_product_attribute_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 ) LEFT JOIN `ps_category_lang` cl ON (product_shop.`id_category_default` = cl.`id_category` AND cl.`id_lang` = 1 AND cl.id_shop = 1 ) LEFT JOIN `ps_product_lang` pl ON (p.`id_product` = pl.`id_product` AND pl.`id_lang` = 1 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` = 1) LEFT JOIN `ps_manufacturer` m ON m.`id_manufacturer` = p.`id_manufacturer` WHERE product_shop.`id_shop` = 1 AND cp.`id_category` = 2 AND product_shop.`active` = 1 AND product_shop.`visibility` IN ("both", "catalog") ORDER BY RAND() LIMIT 4	18.982 ms	649	Yes		/classes/Category.php:1062 /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:1083 (hookdisplayLeftColumn) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:421 (coreCallHook) /classes/Hook.php:989 (callHookOn) /config/smarty.config.inc.php:201 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/prod/smarty/compile/child_v4_swert_smell_70layouts_layout_left_column_tpl/8f/37/95/8f3795b4a93d48b203ec4f57dbf6538087b26c3f_2.file.layout-both-columns.tpl.php:195 (__call) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/child_v4_swert_smell_70layouts_layout_left_column_tpl/8f/37/95/8f3795b4a93d48b203ec4f57dbf6538087b26c3f_2.file.layout-both-columns.tpl.php:75 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_681b4f69396bf4_25173037) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/child_v4_swert_smell_70layouts_layout_left_column_tpl/2c/f3/59/2cf359a4bde30a497bd3846c4e7eed28bd416158_2.file.layout-left-column.tpl.php:28 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_681b4f693498d1_48637902) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/child_v4_swert_smell_70layouts_layout_left_column_tpl/06/96/b8/0696b8dda42afe8abc39c0ae77760a155a97487a_2.file.product-list.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_681b4f69318f69_46238223) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/child_v4_swert_smell_70layouts_layout_left_column_tpl/e9/63/70/e963706bc093b6c72ec0976bcd7f9787d22154f2_2.file.category.tpl.php:29 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6825e843ab5c66_97590843) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/Smarty/SmartyCustom.php:112 (fetch) /classes/controller/FrontController.php:771 (fetch) /classes/controller/FrontController.php:753 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
154	SELECT SQL_NO_CACHE COUNT(DISTINCT p.id_product) c 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, cp.position 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_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) WHERE ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cp.id_category IN (12, 9) GROUP BY p.id_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 ) WHERE ((sa.out_of_stock=1) OR (sa.quantity>0))	12.476 ms	25960			/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:778 (execute) /modules/ps_facetedsearch/src/Adapter/MySQL.php:757 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:494 (count) /modules/ps_facetedsearch/src/Filters/Block.php:140 (getAvailabilitiesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
155	SELECT SQL_NO_CACHE COUNT(DISTINCT p.id_product) c 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, cp.position 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_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) WHERE ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cp.id_category IN (12, 9) GROUP BY p.id_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 ) WHERE ((sa.quantity>0))	11.637 ms	25960			/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:778 (execute) /modules/ps_facetedsearch/src/Adapter/MySQL.php:757 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:505 (count) /modules/ps_facetedsearch/src/Filters/Block.php:140 (getAvailabilitiesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
161	SELECT SQL_NO_CACHE cp.id_category, COUNT(DISTINCT p.id_product) c 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, cp.position 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_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) LEFT JOIN ps_stock_available sa_1 ON (p.id_product = sa_1.id_product AND IFNULL(pac.id_product_attribute, 0) = sa_1.id_product_attribute AND sa_1.id_shop = 1 AND sa_1.id_shop_group = 0 ) WHERE ((sa.quantity<=0 AND sa_1.out_of_stock IN (0, 2))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') GROUP BY p.id_product) p 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_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_stock_available sa_1 ON (p.id_product = sa_1.id_product AND IFNULL(pac.id_product_attribute, 0) = sa_1.id_product_attribute AND sa_1.id_shop = 1 AND sa_1.id_shop_group = 0 ) WHERE ((sa.quantity<=0 AND sa_1.out_of_stock IN (0, 2))) AND c.level_depth<=2 AND c.nleft>2 AND c.nright<283 GROUP BY cp.id_category	11.075 ms	129800	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:778 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:992 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:158 (getCategoriesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
151	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, cp.position 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_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) LEFT JOIN ps_stock_available sa_1 ON (p.id_product = sa_1.id_product AND IFNULL(pac.id_product_attribute, 0) = sa_1.id_product_attribute AND sa_1.id_shop = 1 AND sa_1.id_shop_group = 0 ) WHERE ((sa.quantity<=0 AND sa_1.out_of_stock IN (0, 2))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cp.id_category IN (12, 9) GROUP BY p.id_product) p INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) GROUP BY p.id_product ORDER BY p.position ASC, p.id_product DESC	8.844 ms	64900	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:187 (getProductByFilters) /classes/controller/ProductListingFrontController.php:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
2	SELECT SQL_NO_CACHE c.`name`, cl.`id_lang`, IF(cl.`id_lang` IS NULL, c.`value`, cl.`value`) AS value, c.id_shop_group, c.id_shop FROM `ps_configuration` c LEFT JOIN `ps_configuration_lang` cl ON (c.`id_configuration` = cl.`id_configuration`)	7.930 ms	1258			/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)
165	SELECT SQL_NO_CACHE pac.id_attribute, COUNT(DISTINCT p.id_product) c 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, cp.position 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_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) LEFT JOIN ps_stock_available sa_1 ON (p.id_product = sa_1.id_product AND IFNULL(pac.id_product_attribute, 0) = sa_1.id_product_attribute AND sa_1.id_shop = 1 AND sa_1.id_shop_group = 0 ) WHERE ((sa.quantity<=0 AND sa_1.out_of_stock IN (0, 2))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cp.id_category IN (12, 9) GROUP BY p.id_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) INNER JOIN ps_attribute a ON (a.id_attribute = pac.id_attribute) LEFT JOIN ps_stock_available sa_1 ON (p.id_product = sa_1.id_product AND IFNULL(pac.id_product_attribute, 0) = sa_1.id_product_attribute AND sa_1.id_shop = 1 AND sa_1.id_shop_group = 0 ) LEFT JOIN ps_stock_available sa_1_1 ON (p.id_product = sa_1_1.id_product AND IFNULL(pac.id_product_attribute, 0) = sa_1_1.id_product_attribute AND sa_1_1.id_shop = 1 AND sa_1_1.id_shop_group = 0 ) WHERE ((a.id_attribute_group=2)) AND ((sa_1.quantity<=0 AND sa_1_1.out_of_stock IN (0, 2))) GROUP BY pac.id_attribute	7.779 ms	25960	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:778 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:737 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:150 (getAttributesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
167	SELECT SQL_NO_CACHE p.id_manufacturer, COUNT(DISTINCT p.id_product) c 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, cp.position 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_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) LEFT JOIN ps_stock_available sa_1 ON (p.id_product = sa_1.id_product AND IFNULL(pac.id_product_attribute, 0) = sa_1.id_product_attribute AND sa_1.id_shop = 1 AND sa_1.id_shop_group = 0 ) WHERE ((sa.quantity<=0 AND sa_1.out_of_stock IN (0, 2))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cp.id_category IN (12, 9) GROUP BY p.id_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_stock_available sa_1 ON (p.id_product = sa_1.id_product AND IFNULL(pac.id_product_attribute, 0) = sa_1.id_product_attribute AND sa_1.id_shop = 1 AND sa_1.id_shop_group = 0 ) WHERE ((sa.quantity<=0 AND sa_1.out_of_stock IN (0, 2))) GROUP BY p.id_manufacturer	7.560 ms	25960	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:778 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:661 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:146 (getManufacturersBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
168	SELECT SQL_NO_CACHE p.condition, COUNT(DISTINCT p.id_product) c 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, cp.position 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_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) LEFT JOIN ps_stock_available sa_1 ON (p.id_product = sa_1.id_product AND IFNULL(pac.id_product_attribute, 0) = sa_1.id_product_attribute AND sa_1.id_shop = 1 AND sa_1.id_shop_group = 0 ) WHERE ((sa.quantity<=0 AND sa_1.out_of_stock IN (0, 2))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cp.id_category IN (12, 9) GROUP BY p.id_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_stock_available sa_1 ON (p.id_product = sa_1.id_product AND IFNULL(pac.id_product_attribute, 0) = sa_1.id_product_attribute AND sa_1.id_shop = 1 AND sa_1.id_shop_group = 0 ) WHERE ((sa.quantity<=0 AND sa_1.out_of_stock IN (0, 2))) GROUP BY p.condition	7.155 ms	25960	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:778 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:394 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:137 (getConditionsBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
156	SELECT SQL_NO_CACHE COUNT(DISTINCT p.id_product) c 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, cp.position 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_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) LEFT JOIN ps_stock_available sa_1 ON (p.id_product = sa_1.id_product AND IFNULL(pac.id_product_attribute, 0) = sa_1.id_product_attribute AND sa_1.id_shop = 1 AND sa_1.id_shop_group = 0 ) WHERE ((sa.quantity<=0 AND sa_1.out_of_stock IN (0, 2))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cp.id_category IN (12, 9) GROUP BY p.id_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_1 ON (p.id_product = sa_1.id_product AND IFNULL(pac.id_product_attribute, 0) = sa_1.id_product_attribute AND sa_1.id_shop = 1 AND sa_1.id_shop_group = 0 ) LEFT JOIN ps_stock_available sa_1_1 ON (p.id_product = sa_1_1.id_product AND IFNULL(pac.id_product_attribute, 0) = sa_1_1.id_product_attribute AND sa_1_1.id_shop = 1 AND sa_1_1.id_shop_group = 0 ) WHERE ((p.on_sale=1)) AND ((sa_1.quantity<=0 AND sa_1_1.out_of_stock IN (0, 2)))	6.735 ms	25960			/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:778 (execute) /modules/ps_facetedsearch/src/Adapter/MySQL.php:757 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:565 (count) /modules/ps_facetedsearch/src/Filters/Block.php:143 (getHighlightsBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
158	SELECT SQL_NO_CACHE COUNT(DISTINCT p.id_product) c 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, cp.position 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_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) LEFT JOIN ps_stock_available sa_1 ON (p.id_product = sa_1.id_product AND IFNULL(pac.id_product_attribute, 0) = sa_1.id_product_attribute AND sa_1.id_shop = 1 AND sa_1.id_shop_group = 0 ) WHERE ((sa.quantity<=0 AND sa_1.out_of_stock IN (0, 2))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cp.id_category IN (12, 9) GROUP BY p.id_product) p LEFT JOIN ps_specific_price sp ON ( sp.id_product = p.id_product AND sp.id_shop IN (0, 1) AND sp.id_currency IN (0, 1) AND sp.id_country IN (0, 10) AND sp.id_group IN (0, 3) AND sp.from_quantity = 1 AND sp.reduction > 0 AND sp.id_customer = 0 AND sp.id_cart = 0 AND (sp.from = '0000-00-00 00:00:00' OR '2025-05-15 15:37:28' >= sp.from) AND (sp.to = '0000-00-00 00:00:00' OR '2025-05-15 15:37:28' <= sp.to) ) 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_1 ON (p.id_product = sa_1.id_product AND IFNULL(pac.id_product_attribute, 0) = sa_1.id_product_attribute AND sa_1.id_shop = 1 AND sa_1.id_shop_group = 0 ) LEFT JOIN ps_stock_available sa_1_1 ON (p.id_product = sa_1_1.id_product AND IFNULL(pac.id_product_attribute, 0) = sa_1_1.id_product_attribute AND sa_1_1.id_shop = 1 AND sa_1_1.id_shop_group = 0 ) WHERE ((sp.reduction>0)) AND ((sa_1.quantity<=0 AND sa_1_1.out_of_stock IN (0, 2)))	6.698 ms	25960			/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:778 (execute) /modules/ps_facetedsearch/src/Adapter/MySQL.php:757 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:605 (count) /modules/ps_facetedsearch/src/Filters/Block.php:143 (getHighlightsBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
157	SELECT SQL_NO_CACHE COUNT(DISTINCT p.id_product) c 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, cp.position 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_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) LEFT JOIN ps_stock_available sa_1 ON (p.id_product = sa_1.id_product AND IFNULL(pac.id_product_attribute, 0) = sa_1.id_product_attribute AND sa_1.id_shop = 1 AND sa_1.id_shop_group = 0 ) WHERE ((sa.quantity<=0 AND sa_1.out_of_stock IN (0, 2))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cp.id_category IN (12, 9) GROUP BY p.id_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_stock_available sa_1 ON (p.id_product = sa_1.id_product AND IFNULL(pac.id_product_attribute, 0) = sa_1.id_product_attribute AND sa_1.id_shop = 1 AND sa_1.id_shop_group = 0 ) WHERE ((sa.quantity<=0 AND sa_1.out_of_stock IN (0, 2))) AND p.date_add>'2022-08-20 00:00:00'	6.694 ms	25960			/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:778 (execute) /modules/ps_facetedsearch/src/Adapter/MySQL.php:757 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:587 (count) /modules/ps_facetedsearch/src/Filters/Block.php:143 (getHighlightsBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
169	SELECT SQL_NO_CACHE MIN(p.weight) as min, MAX(p.weight) as max FROM ps_product p 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) 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_stock_available sa_1 ON (p.id_product = sa_1.id_product AND IFNULL(pac.id_product_attribute, 0) = sa_1.id_product_attribute AND sa_1.id_shop = 1 AND sa_1.id_shop_group = 0 ) WHERE ((sa.quantity<=0 AND sa_1.out_of_stock IN (0, 2))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cp.id_category IN (12, 9)	5.374 ms	6490			/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:744 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:339 (getMinMaxValue) /modules/ps_facetedsearch/src/Filters/Block.php:134 (getWeightRangeBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
0	SELECT SQL_NO_CACHE s.id_shop, CONCAT(su.physical_uri, su.virtual_uri) AS uri, su.domain, su.main FROM ps_shop_url su LEFT JOIN ps_shop s ON (s.id_shop = su.id_shop) WHERE (su.domain = 'hairsaloon.it' OR su.domain_ssl = 'hairsaloon.it') AND s.active = 1 AND s.deleted = 0 ORDER BY LENGTH(CONCAT(su.physical_uri, su.virtual_uri)) DESC	4.875 ms	1	Yes		/classes/shop/Shop.php:1364 /classes/shop/Shop.php:355 (findShopByHost) /config/config.inc.php:117 (initialize) /index.php:27 (require)
149	SELECT SQL_NO_CACHE ag.id_attribute_group, agl.public_name as attribute_group_name, is_color_group, IF(liaglv.`url_name` IS NULL OR liaglv.`url_name` = "", NULL, liaglv.`url_name`) AS url_name, IF(liaglv.`meta_title` IS NULL OR liaglv.`meta_title` = "", NULL, liaglv.`meta_title`) AS meta_title, IFNULL(liag.indexable, TRUE) AS indexable FROM `ps_attribute_group` ag INNER JOIN ps_attribute_group_shop attribute_group_shop ON (attribute_group_shop.id_attribute_group = ag.id_attribute_group AND attribute_group_shop.id_shop = 1) LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1) LEFT JOIN `ps_layered_indexable_attribute_group` liag ON (ag.`id_attribute_group` = liag.`id_attribute_group`) LEFT JOIN `ps_layered_indexable_attribute_group_lang_value` AS liaglv ON (ag.`id_attribute_group` = liaglv.`id_attribute_group` AND agl.`id_lang` = 1) GROUP BY ag.id_attribute_group ORDER BY ag.`position` ASC	4.716 ms	4	Yes	Yes	/modules/ps_facetedsearch/src/Filters/DataAccessor.php:137 /modules/ps_facetedsearch/src/Filters/Converter.php:413 (getAttributesGroups) /modules/ps_facetedsearch/src/Product/SearchProvider.php:163 (createFacetedSearchFiltersFromQuery) /classes/controller/ProductListingFrontController.php:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
76	SELECT SQL_NO_CACHE p.,pl.,r.,rl.name,a. FROM `ps_ets_pr_rule` r INNER JOIN `ps_ets_pr_action_rule` a ON (r.id_ets_pr_rule = a.id_ets_pr_rule) INNER JOIN `ps_ets_pr_promote_rule` p ON (r.id_ets_pr_rule = p.id_ets_pr_rule AND (p.position_to_display LIKE "%displayProductListHeaderAfter%" OR p.position_to_display="all") ) LEFT JOIN `ps_ets_pr_promote_rule_lang` pl ON (p.id_ets_pr_promote_rule = pl.id_ets_pr_promote_rule AND pl.id_lang="1") LEFT JOIN `ps_ets_pr_rule_lang` rl ON (r.id_ets_pr_rule=rl.id_ets_pr_rule AND rl.id_lang="1") WHERE r.active=1 AND (r.from_date ="0000-00-00 00:00:00" or r.from_date <="2025-05-15 15:37:28") AND (r.to_date ="0000-00-00 00:00:00" or r.to_date >="2025-05-15 15:37:28") AND r.id_shop = "1"	4.602 ms	1			/modules/ets_promotion/classes/ets_pr_rule.php:142 /modules/ets_promotion/ets_promotion.php:537 (getPromoteDiscountRulesByPosition) /modules/ets_promotion/ets_promotion.php:454 (displayPromoteDiscountRule) /modules/ets_promotion/ets_promotion.php:354 (hookDisplayProductListHeaderAfter) /modules/ets_promotion/ets_promotion.php:403 (_header) /classes/Hook.php:1083 (hookDisplayHeader) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:421 (coreCallHook) /classes/Hook.php:989 (callHookOn) /classes/controller/FrontController.php:633 (exec) /controllers/front/listing/CategoryController.php:127 (initContent) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
87	SHOW TABLES LIKE "ps_gmcp_1800"	4.296 ms	1			/modules/gmerchantcenterpro/lib/moduleUpdate.php:88 :undefined (updateTables) /modules/gmerchantcenterpro/lib/moduleUpdate.php:61 (call_user_func_array) /modules/gmerchantcenterpro/lib/moduleTools.php:193 (run) /modules/gmerchantcenterpro/gmerchantcenterpro.php:197 (getLangCurrencyCountry) :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:1263 (get) /tools/profiling/Module.php:35 (coreLoadModule) /classes/module/Module.php:1242 (coreLoadModule) /classes/Hook.php:972 (getInstanceByName) /classes/controller/FrontController.php:633 (exec) /controllers/front/listing/CategoryController.php:127 (initContent) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
170	SELECT SQL_NO_CACHE DISTINCT a.`id_attribute`, a.`color`, al.`name`, agl.`id_attribute_group`, IF(lialv.`url_name` IS NULL OR lialv.`url_name` = "", NULL, lialv.`url_name`) AS url_name, IF(lialv.`meta_title` IS NULL OR lialv.`meta_title` = "", NULL, lialv.`meta_title`) AS meta_title FROM `ps_attribute_group` ag INNER JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1) INNER JOIN `ps_attribute` a ON a.`id_attribute_group` = ag.`id_attribute_group` INNER JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1) INNER JOIN ps_attribute_group_shop attribute_group_shop ON (attribute_group_shop.id_attribute_group = ag.id_attribute_group AND attribute_group_shop.id_shop = 1) INNER JOIN ps_attribute_shop attribute_shop ON (attribute_shop.id_attribute = a.id_attribute AND attribute_shop.id_shop = 1) LEFT JOIN `ps_layered_indexable_attribute_lang_value` lialv ON (a.`id_attribute` = lialv.`id_attribute` AND lialv.`id_lang` = 1) WHERE ag.id_attribute_group = 3 ORDER BY agl.`name` ASC, a.`position` ASC	4.194 ms	0			/modules/ps_facetedsearch/src/Filters/DataAccessor.php:96 /modules/ps_facetedsearch/src/Filters/Block.php:731 (getAttributes) /modules/ps_facetedsearch/src/Filters/Block.php:150 (getAttributesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
1287	SELECT SQL_NO_CACHE mainTable.id_tvcmstestimonial AS code, mainTable.image, mainTable.signature_image, mainTable.signature_text, mainTable.link, subTable.title, subTable.designation, subTable.short_description, subTable.description FROM `ps_tvcmstestimonial` mainTable LEFT JOIN ps_tvcmstestimonial_lang subTable ON mainTable.id_tvcmstestimonial = subTable.id_tvcmstestimonial WHERE mainTable.id_shop_group = 1 AND mainTable.id_shop = 1 AND mainTable.status = 1 AND subTable.id_lang = 1 ORDER BY `position`	3.712 ms	3	Yes		/modules/tvcmstestimonial/tvcmstestimonial.php:532 /modules/tvcmstestimonial/tvcmstestimonial.php:1227 (showFrontData) /modules/tvcmstestimonial/tvcmstestimonial.php:1247 (showFrontSideResult) /classes/Hook.php:1083 (hookdisplayLeftColumn) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:421 (coreCallHook) /classes/Hook.php:989 (callHookOn) /config/smarty.config.inc.php:201 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/prod/smarty/compile/child_v4_swert_smell_70layouts_layout_left_column_tpl/8f/37/95/8f3795b4a93d48b203ec4f57dbf6538087b26c3f_2.file.layout-both-columns.tpl.php:195 (__call) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/child_v4_swert_smell_70layouts_layout_left_column_tpl/8f/37/95/8f3795b4a93d48b203ec4f57dbf6538087b26c3f_2.file.layout-both-columns.tpl.php:75 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_681b4f69396bf4_25173037) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/child_v4_swert_smell_70layouts_layout_left_column_tpl/2c/f3/59/2cf359a4bde30a497bd3846c4e7eed28bd416158_2.file.layout-left-column.tpl.php:28 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_681b4f693498d1_48637902) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/child_v4_swert_smell_70layouts_layout_left_column_tpl/06/96/b8/0696b8dda42afe8abc39c0ae77760a155a97487a_2.file.product-list.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_681b4f69318f69_46238223) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/child_v4_swert_smell_70layouts_layout_left_column_tpl/e9/63/70/e963706bc093b6c72ec0976bcd7f9787d22154f2_2.file.category.tpl.php:29 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6825e843ab5c66_97590843) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/Smarty/SmartyCustom.php:112 (fetch) /classes/controller/FrontController.php:771 (fetch) /classes/controller/FrontController.php:753 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
150	SELECT SQL_NO_CACHE DISTINCT f.id_feature, f., fl., IF(liflv.`url_name` IS NULL OR liflv.`url_name` = "", NULL, liflv.`url_name`) AS url_name, IF(liflv.`meta_title` IS NULL OR liflv.`meta_title` = "", NULL, liflv.`meta_title`) AS meta_title, lif.indexable FROM `ps_feature` f INNER JOIN ps_feature_shop feature_shop ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1) LEFT JOIN `ps_feature_lang` fl ON (f.`id_feature` = fl.`id_feature` AND fl.`id_lang` = 1) LEFT JOIN `ps_layered_indexable_feature` lif ON (f.`id_feature` = lif.`id_feature`) LEFT JOIN `ps_layered_indexable_feature_lang_value` liflv ON (f.`id_feature` = liflv.`id_feature` AND liflv.`id_lang` = 1) ORDER BY f.`position` ASC	3.577 ms	1	Yes		/modules/ps_facetedsearch/src/Filters/DataAccessor.php:171 /modules/ps_facetedsearch/src/Filters/Converter.php:388 (getFeatures) /modules/ps_facetedsearch/src/Product/SearchProvider.php:163 (createFacetedSearchFiltersFromQuery) /classes/controller/ProductListingFrontController.php:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
173	SELECT SQL_NO_CACHE pac.id_attribute, COUNT(DISTINCT p.id_product) c 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, cp.position 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_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) LEFT JOIN ps_stock_available sa_1 ON (p.id_product = sa_1.id_product AND IFNULL(pac.id_product_attribute, 0) = sa_1.id_product_attribute AND sa_1.id_shop = 1 AND sa_1.id_shop_group = 0 ) WHERE ((sa.quantity<=0 AND sa_1.out_of_stock IN (0, 2))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cp.id_category IN (12, 9) GROUP BY p.id_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) INNER JOIN ps_attribute a ON (a.id_attribute = pac.id_attribute) LEFT JOIN ps_stock_available sa_1 ON (p.id_product = sa_1.id_product AND IFNULL(pac.id_product_attribute, 0) = sa_1.id_product_attribute AND sa_1.id_shop = 1 AND sa_1.id_shop_group = 0 ) LEFT JOIN ps_stock_available sa_1_1 ON (p.id_product = sa_1_1.id_product AND IFNULL(pac.id_product_attribute, 0) = sa_1_1.id_product_attribute AND sa_1_1.id_shop = 1 AND sa_1_1.id_shop_group = 0 ) WHERE ((a.id_attribute_group=4)) AND ((sa_1.quantity<=0 AND sa_1_1.out_of_stock IN (0, 2))) GROUP BY pac.id_attribute	3.522 ms	25960	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:778 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:737 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:150 (getAttributesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
935	SELECT SQL_NO_CACHE pai.`id_image`, pai.`id_product_attribute`, il.`legend` FROM `ps_product_attribute_image` pai LEFT JOIN `ps_image_lang` il ON (il.`id_image` = pai.`id_image`) LEFT JOIN `ps_image` i ON (i.`id_image` = pai.`id_image`) WHERE pai.`id_product_attribute` IN (47, 48) AND il.`id_lang` = 1 ORDER by i.`position`	3.435 ms	1	Yes		/classes/Product.php:2921 /src/Adapter/Image/ImageRetriever.php:90 (getCombinationImages) /src/Adapter/Presenter/Product/ProductLazyArray.php:684 (getAllProductImages) /src/Adapter/Presenter/Product/ProductLazyArray.php:127 (fillImages) /src/Adapter/Presenter/Product/ProductListingPresenter.php:57 (__construct) /modules/tvcmstabproducts/tvcmstabproducts.php:2913 (present) /modules/tvcmsbestsellerproducts/tvcmsbestsellerproducts.php:156 (displayBestSellers) /modules/tvcmsbestsellerproducts/tvcmsbestsellerproducts.php:269 (showFrontSideResult) /classes/Hook.php:1083 (hookdisplayLeftColumn) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:421 (coreCallHook) /classes/Hook.php:989 (callHookOn) /config/smarty.config.inc.php:201 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/prod/smarty/compile/child_v4_swert_smell_70layouts_layout_left_column_tpl/8f/37/95/8f3795b4a93d48b203ec4f57dbf6538087b26c3f_2.file.layout-both-columns.tpl.php:195 (__call) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/child_v4_swert_smell_70layouts_layout_left_column_tpl/8f/37/95/8f3795b4a93d48b203ec4f57dbf6538087b26c3f_2.file.layout-both-columns.tpl.php:75 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_681b4f69396bf4_25173037) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/child_v4_swert_smell_70layouts_layout_left_column_tpl/2c/f3/59/2cf359a4bde30a497bd3846c4e7eed28bd416158_2.file.layout-left-column.tpl.php:28 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_681b4f693498d1_48637902) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/child_v4_swert_smell_70layouts_layout_left_column_tpl/06/96/b8/0696b8dda42afe8abc39c0ae77760a155a97487a_2.file.product-list.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_681b4f69318f69_46238223) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/child_v4_swert_smell_70layouts_layout_left_column_tpl/e9/63/70/e963706bc093b6c72ec0976bcd7f9787d22154f2_2.file.category.tpl.php:29 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6825e843ab5c66_97590843) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/Smarty/SmartyCustom.php:112 (fetch) /classes/controller/FrontController.php:771 (fetch) /classes/controller/FrontController.php:753 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
174	REPLACE INTO ps_layered_filter_block (hash, data) VALUES ("5c9456d085463b630503234b656330e8", "a:1:{s:7:\"filters\";a:7:{i:0;a:7:{s:9:\"type_lite\";s:12:\"availability\";s:4:\"type\";s:12:\"availability\";s:6:\"id_key\";i:0;s:4:\"name\";s:14:\"Disponibilità\";s:6:\"values\";a:2:{i:2;a:2:{s:4:\"name\";s:12:\"In magazzino\";s:3:\"nbr\";i:488;}i:0;a:3:{s:4:\"name\";s:15:\"Non disponibile\";s:3:\"nbr\";i:79;s:7:\"checked\";b:1;}}s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";s:1:\"0\";}i:1;a:7:{s:9:\"type_lite\";s:6:\"extras\";s:4:\"type\";s:6:\"extras\";s:6:\"id_key\";i:0;s:4:\"name\";s:9:\"Selezioni\";s:6:\"values\";a:3:{s:4:\"sale\";a:2:{s:4:\"name\";s:8:\"In saldo\";s:3:\"nbr\";i:0;}s:3:\"new\";a:2:{s:4:\"name\";s:14:\"Nuovo prodotto\";s:3:\"nbr\";i:46;}s:8:\"discount\";a:2:{s:4:\"name\";s:8:\"Scontato\";s:3:\"nbr\";i:3;}}s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";s:1:\"0\";}i:2;a:12:{s:9:\"type_lite\";s:5:\"price\";s:4:\"type\";s:5:\"price\";s:6:\"id_key\";i:0;s:4:\"name\";s:6:\"Prezzo\";s:3:\"max\";d:105;s:3:\"min\";d:0;s:4:\"unit\";s:3:\"€\";s:14:\"specifications\";a:11:{s:6:\"symbol\";a:11:{i:0;s:1:\",\";i:1;s:1:\".\";i:2;s:1:\";\";i:3;s:1:\"%\";i:4;s:1:\"-\";i:5;s:1:\"+\";i:6;s:1:\"E\";i:7;s:2:\"×\";i:8;s:3:\"‰\";i:9;s:3:\"∞\";i:10;s:3:\"NaN\";}s:12:\"currencyCode\";s:3:\"EUR\";s:14:\"currencySymbol\";s:3:\"€\";s:13:\"numberSymbols\";a:11:{i:0;s:1:\",\";i:1;s:1:\".\";i:2;s:1:\";\";i:3;s:1:\"%\";i:4;s:1:\"-\";i:5;s:1:\"+\";i:6;s:1:\"E\";i:7;s:2:\"×\";i:8;s:3:\"‰\";i:9;s:3:\"∞\";i:10;s:3:\"NaN\";}s:15:\"positivePattern\";s:12:\"#,##0.00 ¤\";s:15:\"negativePattern\";s:13:\"-#,##0.00 ¤\";s:17:\"maxFractionDigits\";i:2;s:17:\"minFractionDigits\";i:2;s:12:\"groupingUsed\";b:1;s:16:\"primaryGroupSize\";i:3;s:18:\"secondaryGroupSize\";i:3;}s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";i:3;s:3:\"nbr\";i:79;s:5:\"value\";N;}i:3;a:7:{s:9:\"type_lite\";s:8:\"category\";s:4:\"type\";s:8:\"category\";s:6:\"id_key\";i:0;s:4:\"name\";s:9:\"Categorie\";s:6:\"values\";a:8:{i:9;a:3:{s:4:\"name\";s:4:\"HAIR\";s:3:\"nbr\";s:2:\"79\";s:7:\"checked\";b:1;}i:12;a:3:{s:4:\"name\";s:6:\"BEAUTY\";s:3:\"nbr\";s:1:\"1\";s:7:\"checked\";b:1;}i:21;a:2:{s:4:\"name\";s:7:\"DAVINES\";s:3:\"nbr\";s:2:\"10\";}i:51;a:2:{s:4:\"name\";s:7:\"INSIGHT\";s:3:\"nbr\";s:2:\"49\";}i:58;a:2:{s:4:\"name\";s:8:\"EMSIBETH\";s:3:\"nbr\";s:2:\"14\";}i:73;a:2:{s:4:\"name\";s:7:\"OLAPLEX\";s:3:\"nbr\";s:1:\"2\";}i:153;a:2:{s:4:\"name\";s:7:\"FRAMESI\";s:3:\"nbr\";s:1:\"7\";}i:170;a:2:{s:4:\"name\";s:13:\"TRAVEL E MAXI\";s:3:\"nbr\";s:1:\"1\";}}s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";s:1:\"0\";}i:4;a:7:{s:9:\"type_lite\";s:12:\"manufacturer\";s:4:\"type\";s:12:\"manufacturer\";s:6:\"id_key\";i:0;s:4:\"name\";s:5:\"Marca\";s:6:\"values\";a:4:{i:1;a:2:{s:4:\"name\";s:7:\"DAVINES\";s:3:\"nbr\";s:1:\"8\";}i:3;a:2:{s:4:\"name\";s:7:\"INSIGHT\";s:3:\"nbr\";s:2:\"46\";}i:6;a:2:{s:4:\"name\";s:7:\"OLAPLEX\";s:3:\"nbr\";s:1:\"2\";}i:7;a:2:{s:4:\"name\";s:8:\"EMSIBETH\";s:3:\"nbr\";s:1:\"9\";}}s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";s:1:\"0\";}i:5;a:7:{s:9:\"type_lite\";s:9:\"condition\";s:4:\"type\";s:9:\"condition\";s:6:\"id_key\";i:0;s:4:\"name\";s:10:\"Condizione\";s:6:\"values\";a:3:{s:3:\"new\";a:2:{s:4:\"name\";s:5:\"Nuovo\";s:3:\"nbr\";s:2:\"79\";}s:4:\"used\";a:2:{s:4:\"name\";s:5:\"Usati\";s:3:\"nbr\";i:0;}s:11:\"refurbished\";a:2:{s:4:\"name\";s:14:\"imesso a nuovo\";s:3:\"nbr\";i:0;}}s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";s:1:\"0\";}i:6;a:0:{}}}")	3.342 ms	1			/modules/ps_facetedsearch/src/Filters/Block.php:211 /modules/ps_facetedsearch/src/Product/SearchProvider.php:217 (insertIntoCache) /classes/controller/ProductListingFrontController.php:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
310	SELECT SQL_NO_CACHE * FROM `ps_cart_rule` cr LEFT JOIN `ps_cart_rule_lang` crl ON (cr.`id_cart_rule` = crl.`id_cart_rule` AND crl.`id_lang` = 1) WHERE (cr.`id_customer` = 0) AND NOW() BETWEEN cr.date_from AND cr.date_to AND cr.`active` = 1 AND free_shipping = 1 AND carrier_restriction = 1	3.316 ms	1			/classes/CartRule.php:423 /override/classes/CartRule.php:27 (getCustomerCartRules) /classes/Cart.php:3079 (getCustomerCartRules) /classes/Cart.php:3463 (getDeliveryOptionList) /classes/Cart.php:3536 (getDeliveryOption) /src/Core/Cart/Fees.php:96 (getTotalShippingCost) /src/Core/Cart/Calculator.php:354 (processCalculation) /src/Core/Cart/Calculator.php:155 (calculateFees) /classes/Cart.php:2201 (processCalculation) /override/classes/Cart.php:30 (getOrderTotal) /src/Adapter/Presenter/Cart/CartLazyArray.php:185 (getOrderTotal) /src/Adapter/Presenter/AbstractLazyArray.php:269 (getTotals) /src/Adapter/Presenter/AbstractLazyArray.php:129 (offsetGet) :undefined (jsonSerialize) /classes/Smarty/SmartyLazyRegister.php:81 (json_encode) /var/cache/prod/smarty/compile/child_v4_swert_smell_70layouts_layout_left_column_tpl/03/46/1a/03461a2365221812cfd712a45cfe5499c721e451_2.file.javascript.tpl.php:54 (__call) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6825e842817820_12858624) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /var/cache/prod/smarty/compile/child_v4_swert_smell_70layouts_layout_left_column_tpl/36/16/ae/3616aebfc06afdbd53cd54c6139c7386068aed79_2.file.head.tpl.php:296 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/child_v4_swert_smell_70layouts_layout_left_column_tpl/36/16/ae/3616aebfc06afdbd53cd54c6139c7386068aed79_2.file.head.tpl.php:38 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_681b4f69418878_86644367) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /var/cache/prod/smarty/compile/child_v4_swert_smell_70layouts_layout_left_column_tpl/8f/37/95/8f3795b4a93d48b203ec4f57dbf6538087b26c3f_2.file.layout-both-columns.tpl.php:103 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/child_v4_swert_smell_70layouts_layout_left_column_tpl/8f/37/95/8f3795b4a93d48b203ec4f57dbf6538087b26c3f_2.file.layout-both-columns.tpl.php:41 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_681b4f69396bf4_25173037) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/child_v4_swert_smell_70layouts_layout_left_column_tpl/2c/f3/59/2cf359a4bde30a497bd3846c4e7eed28bd416158_2.file.layout-left-column.tpl.php:28 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_681b4f693498d1_48637902) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/child_v4_swert_smell_70layouts_layout_left_column_tpl/06/96/b8/0696b8dda42afe8abc39c0ae77760a155a97487a_2.file.product-list.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_681b4f69318f69_46238223) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/child_v4_swert_smell_70layouts_layout_left_column_tpl/e9/63/70/e963706bc093b6c72ec0976bcd7f9787d22154f2_2.file.category.tpl.php:29 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6825e843ab5c66_97590843) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/Smarty/SmartyCustom.php:112 (fetch) /classes/controller/FrontController.php:771 (fetch) /classes/controller/FrontController.php:753 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)

#	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

Kit Insight Anti-Frizz Shampoo 900ml + Conditioner 900ml

Kit Insight Anti-Frizz Shampoo 350ml + Conditioner 350ml

Kit Insight Anti-Frizz Shampoo 900ml + Maschera 400ml

Kit Insight Anti-Frizz Shampoo 350ml + Maschera 200ml

Kit Insight Anti-Frizz Shampoo 75ml + Maschera 75ml

Insight Dry Hair Shampoo 900ml + Conditioner capelli nutriente 900ml

Insight Dry Hair Shampoo 900ml + Maschera capelli nutriente 400ml

Insight Dry Hair Shampoo 100ml + Maschera capelli nutriente 75ml

Insight Dry Hair Shampoo 350ml + Maschera capelli nutriente 200ml

Insight Dry Hair Shampoo 350ml + Conditioner capelli nutriente 350ml

Carrello

Emsibeth: La Scienza Italiana al Servizio della Salute e della Bellezza dei Tuoi Capelli

Insight: La Natura al Servizio della Bellezza Autentica dei Tuoi Capelli

Framesi: L'Eccellenza Italiana per Capelli che Ispirano

Davines: La Bellezza Sostenibile che Nutre i Tuoi Capelli (e il Pianeta!)

INSIGHT ANTI FRIZZ SHAMPOO IDRATANTE HYDRATING SHAMPOO 900ML

INSIGHT ANTI FRIZZ SHAMPOO IDRATANTE HYDRATING SHAMPOO 900ML

INSIGHT ANTI FRIZZ SHAMPOO IDRATANTE HYDRATING SHAMPOO 900ML

INSIGHT ANTI FRIZZ SHAMPOO IDRATANTE HYDRATING SHAMPOO 900ML

INSIGHT STYLING CRISTALLI LIQUIDI 100ML LIQUID CRISTALS

INSIGHT STYLING CRISTALLI LIQUIDI 100ML LIQUID CRISTALS

INSIGHT STYLING CRISTALLI LIQUIDI 100ML LIQUID CRISTALS

INSIGHT STYLING CRISTALLI LIQUIDI 100ML LIQUID CRISTALS

INSIGHT COLORED HAIR SHAMPOO PROTETTIVO PROTECTIVE SHAMPOO 400ML

INSIGHT COLORED HAIR SHAMPOO PROTETTIVO PROTECTIVE SHAMPOO 400ML

INSIGHT COLORED HAIR SHAMPOO PROTETTIVO PROTECTIVE SHAMPOO 400ML

INSIGHT COLORED HAIR SHAMPOO PROTETTIVO PROTECTIVE SHAMPOO 400ML

INSIGHT MAN CREMA EMOLLIENTE VISO E DOPO BARBA EMOLLIENT AFTERSHAVE AND FACE CREAM 100ML

INSIGHT MAN CREMA EMOLLIENTE VISO E DOPO BARBA EMOLLIENT AFTERSHAVE AND FACE CREAM 100ML

INSIGHT MAN CREMA EMOLLIENTE VISO E DOPO BARBA EMOLLIENT AFTERSHAVE AND FACE CREAM 100ML

INSIGHT MAN CREMA EMOLLIENTE VISO E DOPO BARBA EMOLLIENT AFTERSHAVE AND FACE CREAM 100ML

INSIGHT BLONDE SHAMPOO ILLLUMINANTE PER RIFLESSI FREDDI 400ML

INSIGHT BLONDE SHAMPOO ILLLUMINANTE PER RIFLESSI FREDDI 400ML

INSIGHT BLONDE SHAMPOO ILLLUMINANTE PER RIFLESSI FREDDI 400ML

INSIGHT BLONDE SHAMPOO ILLLUMINANTE PER RIFLESSI FREDDI 400ML

ETHÈ CURLS SHAMPOO PER CAPELLI RICCI O MOSSI 250ML

ETHÈ CURLS SHAMPOO PER CAPELLI RICCI O MOSSI 250ML

ETHÈ CURLS SHAMPOO PER CAPELLI RICCI O MOSSI 250ML

ETHÈ CURLS SHAMPOO PER CAPELLI RICCI O MOSSI 250ML

ETHÈ CURLS SIERO RICCI 150ML

ETHÈ CURLS SIERO RICCI 150ML

ETHÈ CURLS SIERO RICCI 150ML

ETHÈ CURLS SIERO RICCI 150ML

EMSIBETH HULAHOOP MATT WAX CERA EFFETTO OPACO LINEA STYLING FINISHING 75ML

EMSIBETH HULAHOOP MATT WAX CERA EFFETTO OPACO LINEA STYLING FINISHING 75ML

EMSIBETH HULAHOOP MATT WAX CERA EFFETTO OPACO LINEA STYLING FINISHING 75ML

EMSIBETH HULAHOOP MATT WAX CERA EFFETTO OPACO LINEA STYLING FINISHING 75ML

EMSIBETH HULAHOOP SHAPE CERA ALL’ACQUA LINEA STYLING & FINISHING 75ML

EMSIBETH HULAHOOP SHAPE CERA ALL’ACQUA LINEA STYLING & FINISHING 75ML

EMSIBETH HULAHOOP SHAPE CERA ALL’ACQUA LINEA STYLING & FINISHING 75ML

EMSIBETH HULAHOOP SHAPE CERA ALL’ACQUA LINEA STYLING & FINISHING 75ML

EMSIBETH THERMAL ENERGIZING LOZIONE ENERGIZZANTE ANTICADUTA 100ML

EMSIBETH THERMAL ENERGIZING LOZIONE ENERGIZZANTE ANTICADUTA 100ML

EMSIBETH THERMAL ENERGIZING LOZIONE ENERGIZZANTE ANTICADUTA 100ML

EMSIBETH THERMAL ENERGIZING LOZIONE ENERGIZZANTE ANTICADUTA 100ML

OLAPLEX N.7 BONDING OIL 30ML

OLAPLEX N.7 BONDING OIL 30ML

OLAPLEX N.7 BONDING OIL 30ML

OLAPLEX N.7 BONDING OIL 30ML

EMSIBETH MYMASK MASCHERA 150ML

EMSIBETH MYMASK MASCHERA 150ML

EMSIBETH MYMASK MASCHERA 150ML

EMSIBETH MYMASK MASCHERA 150ML

Stopwatch SQL - 1415 queries

Doubles

Tables stress

ObjectModel instances

Included Files