Depuis plus de 25 ans à votre service. Nous sommes situés à Souchez dans le Pas-de-Calais (62) entre Arras et Béthune. Spécialiste dans le matériel de la motoculture de plaisance et des espaces verts.

Nous utilisons des cookies sur notre site pour améliorer votre expérience de navigation et vous fournir des contenus et services adaptés à vos intérêts. En continuant à naviguer sur notre site, vous acceptez l'utilisation de ces cookies. Si vous souhaitez en savoir plus sur l'utilisation que nous faisons des cookies ou comment les gérer, vous pouvez consulter notre politique de confidentialité.

Depuis plus de 25 ans à votre service. Nous sommes situés à Souchez dans le Pas-de-Calais (62) entre Arras et Béthune. Spécialiste dans le matériel de la motoculture de plaisance et des espaces verts.

Sous catégorie

Les appareils à batterie

21 produits

Grille

Grille-2

Liste

Liste-2

Catalogue

Trier par:

Tondeuse Oléo-Mac GV 48TK Allroad - BEAUCAMP MOTOCULTURE

Promo !

Oleo-Mac GV48TK Allroad

509,00 €529,00 €

Promo !

Oleo-Mac GV48TK Allroad

509,00 €529,00 €-20,00 € désactivé

Promo !

Oleo-Mac GV48TK Allroad

Tondeuses thermique

Tondeuse thermique Oléo Mac GV48TK ALLROAD carter acier confort plus tractée 46 cm, moteur Oléo-Mac 166cm3, réglage centralisé, bac hardtop 60 litres. <img src="https://beaucampmotoculture.com/boutiq/img/cms/livraison_gratuite_1.jpg" alt=""...

509,00 €529,00 €-20,00 € désactivé

Load Time	2431 ms
Querying Time	2340 ms
Queries	2341
Memory Peak Usage	72.6 Mb
Included Files	1148 files - 11.55 Mb
PrestaShop Cache	- Mb
Global vars	0.83 Mb
- global $_MODULES	565k
- global $context	247k
- global $_SERVER	6k
- global $_ENV	6k
- global $__composer_autoload_files	5k
- global $config	5k
- global $exportPhpConfigFile	4k
- global $_MODULE	2k
- global $legacyContainer	1k

PrestaShop Version	8.2.0
PHP Version	7.4.33
MySQL Version	8.0.39-30
Memory Limit	512M
Max Execution Time	165s
Smarty Cache	enabled
Smarty Compilation	auto

	Time	Cumulated Time	Memory Usage	Memory Peak Usage
config	15.715 ms	15.715 ms	7.47 Mb	7.8 Mb
__construct	0.009 ms	15.724 ms	- Mb	7.8 Mb
init	32.109 ms	47.833 ms	1.78 Mb	9.4 Mb
checkAccess	0.001 ms	47.834 ms	- Mb	9.4 Mb
setMedia	3.313 ms	51.147 ms	0.25 Mb	9.5 Mb
postProcess	0.001 ms	51.148 ms	- Mb	9.5 Mb
initHeader	0.001 ms	51.149 ms	- Mb	9.5 Mb
initContent	358.876 ms	410.025 ms	7.88 Mb	17.5 Mb
initFooter	0.002 ms	410.027 ms	- Mb	17.5 Mb
display	2021 ms	2431 ms	54.55 Mb	72.6 Mb

Hook	Time	Memory Usage
DisplayLeftColumn	1693 ms	38.82 Mb
=> tvcmsnewproducts	30.329 ms	0.68 Mb
=> tvcmscustomerservices	0.277 ms	0.06 Mb
=> tvcmsspecialproducts	1489 ms	34.75 Mb
=> tvcmsfeaturedproducts	64.381 ms	1.83 Mb
=> tvcmsbestsellerproducts	109.100 ms	1.51 Mb
DisplayAfterBodyOpeningTag	104.615 ms	2.31 Mb
=> tvcmscookiesnotice	0.191 ms	0.02 Mb
=> blockreassurance	0.003 ms	- Mb
=> tvcmsproductpopup	104.247 ms	2.27 Mb
=> cdc_googletagmanager	0.174 ms	0.02 Mb
DisplayReviewProductList	70.951 ms	4.91 Mb
=> tvcmsproductcomments	2.452 ms	0.14 Mb
=> tvcmsproductcomments	1.595 ms	0.09 Mb
=> tvcmsproductcomments	1.520 ms	0.09 Mb
=> tvcmsproductcomments	1.026 ms	0.09 Mb
=> tvcmsproductcomments	2.895 ms	0.13 Mb
=> tvcmsproductcomments	1.015 ms	0.09 Mb
=> tvcmsproductcomments	1.245 ms	0.09 Mb
=> tvcmsproductcomments	3.254 ms	0.09 Mb
=> tvcmsproductcomments	2.589 ms	0.15 Mb
=> tvcmsproductcomments	1.050 ms	0.09 Mb
=> tvcmsproductcomments	1.024 ms	0.09 Mb
=> tvcmsproductcomments	1.092 ms	0.09 Mb
=> tvcmsproductcomments	1.629 ms	0.13 Mb
=> tvcmsproductcomments	1.060 ms	0.09 Mb
=> tvcmsproductcomments	1.833 ms	0.09 Mb
=> tvcmsproductcomments	1.326 ms	0.09 Mb
=> tvcmsproductcomments	2.308 ms	0.13 Mb
=> tvcmsproductcomments	1.066 ms	0.09 Mb
=> tvcmsproductcomments	1.413 ms	0.09 Mb
=> tvcmsproductcomments	1.604 ms	0.09 Mb
=> tvcmsproductcomments	1.739 ms	0.13 Mb
=> tvcmsproductcomments	2.029 ms	0.09 Mb
=> tvcmsproductcomments	1.072 ms	0.09 Mb
=> tvcmsproductcomments	1.105 ms	0.09 Mb
=> tvcmsproductcomments	2.292 ms	0.13 Mb
=> tvcmsproductcomments	0.990 ms	0.09 Mb
=> tvcmsproductcomments	1.057 ms	0.09 Mb
=> tvcmsproductcomments	2.013 ms	0.09 Mb
=> tvcmsproductcomments	1.778 ms	0.13 Mb
=> tvcmsproductcomments	1.490 ms	0.09 Mb
=> tvcmsproductcomments	1.105 ms	0.09 Mb
=> tvcmsproductcomments	1.072 ms	0.09 Mb
=> tvcmsproductcomments	1.393 ms	0.13 Mb
=> tvcmsproductcomments	1.556 ms	0.09 Mb
=> tvcmsproductcomments	1.061 ms	0.09 Mb
=> tvcmsproductcomments	1.471 ms	0.09 Mb
=> tvcmsproductcomments	1.621 ms	0.13 Mb
=> tvcmsproductcomments	1.564 ms	0.09 Mb
=> tvcmsproductcomments	1.410 ms	0.09 Mb
=> tvcmsproductcomments	1.112 ms	0.09 Mb
=> tvcmsproductcomments	1.318 ms	0.13 Mb
=> tvcmsproductcomments	1.278 ms	0.09 Mb
=> tvcmsproductcomments	1.017 ms	0.09 Mb
=> tvcmsproductcomments	1.031 ms	0.09 Mb
=> tvcmsproductcomments	1.454 ms	0.13 Mb
=> tvcmsproductcomments	1.056 ms	0.09 Mb
=> tvcmsproductcomments	0.994 ms	0.09 Mb
=> tvcmsproductcomments	0.877 ms	0.09 Mb
DisplayAfterTitleTag	36.721 ms	1.74 Mb
=> cdc_googletagmanager	36.721 ms	1.74 Mb
=> cdc_googletagmanager	0.000 ms	- Mb
DisplayMegamenu	12.146 ms	0.32 Mb
=> tvcmsmegamenu	12.146 ms	0.32 Mb
DisplayNavWishlistBlock	11.056 ms	0.10 Mb
=> tvcmswishlist	9.533 ms	0.06 Mb
=> tvcmswishlist	1.523 ms	0.04 Mb
displayNav1	10.264 ms	0.09 Mb
=> ps_contactinfo (widget)	10.264 ms	0.09 Mb
displayLeftColumn	9.311 ms	0.48 Mb
=> ps_categorytree (widget)	7.162 ms	0.38 Mb
=> ps_brandlist (widget)	1.286 ms	0.05 Mb
=> ps_supplierlist (widget)	0.863 ms	0.06 Mb
DisplayHeader	8.170 ms	0.31 Mb
=> ps_searchbar	0.110 ms	- Mb
=> ps_shoppingcart	0.018 ms	- Mb
=> tvcmstabproducts	0.072 ms	- Mb
=> tvcmscustomerservices	0.046 ms	- Mb
=> tvcmscustomsetting	0.272 ms	0.01 Mb
=> tvcmsfooterlogo	0.001 ms	- Mb
=> tvcmsfooterproduct	0.030 ms	- Mb
=> tvcmsmultibanner1	0.042 ms	- Mb
=> tvcmspaymenticon	0.000 ms	- Mb
=> tvcmsslider	0.045 ms	- Mb
=> tvcmswishlist	0.059 ms	- Mb
=> tvcmscategorychainslider	0.042 ms	- Mb
=> tvcmsnewsletterpopup	0.079 ms	- Mb
=> tvcmscookiesnotice	0.044 ms	- Mb
=> tvcmsproductcomments	0.131 ms	- Mb
=> tvcmsbrandlist	0.042 ms	- Mb
=> tvcmsproductpopup	0.040 ms	- Mb
=> tvcmscategoryslider	0.042 ms	- Mb
=> tvcmsbestsellerproducts	0.027 ms	- Mb
=> tvcmsfeaturedproducts	0.024 ms	- Mb
=> tvcmsnewproducts	0.024 ms	- Mb
=> tvcmsproductcompare	0.040 ms	- Mb
=> tvcmssearch	0.093 ms	- Mb
=> tvcmsspecialproducts	0.025 ms	- Mb
=> tvcmsthemeoptions	0.113 ms	- Mb
=> cdc_googletagmanager	0.032 ms	- Mb
=> ganalyticspro	6.667 ms	0.25 Mb
=> ets_advancedcaptcha	0.010 ms	- Mb
DisplayWishlistBtnProductList	7.795 ms	0.64 Mb
=> tvcmswishlist	0.185 ms	0.02 Mb
=> tvcmswishlist	0.168 ms	0.01 Mb
=> tvcmswishlist	0.170 ms	0.01 Mb
=> tvcmswishlist	0.168 ms	0.01 Mb
=> tvcmswishlist	0.164 ms	0.01 Mb
=> tvcmswishlist	0.161 ms	0.01 Mb
=> tvcmswishlist	0.166 ms	0.01 Mb
=> tvcmswishlist	0.162 ms	0.01 Mb
=> tvcmswishlist	0.158 ms	0.01 Mb
=> tvcmswishlist	0.158 ms	0.01 Mb
=> tvcmswishlist	0.159 ms	0.01 Mb
=> tvcmswishlist	0.166 ms	0.01 Mb
=> tvcmswishlist	0.164 ms	0.01 Mb
=> tvcmswishlist	0.166 ms	0.01 Mb
=> tvcmswishlist	0.159 ms	0.01 Mb
=> tvcmswishlist	0.156 ms	0.01 Mb
=> tvcmswishlist	0.158 ms	0.01 Mb
=> tvcmswishlist	0.162 ms	0.01 Mb
=> tvcmswishlist	0.182 ms	0.01 Mb
=> tvcmswishlist	0.164 ms	0.01 Mb
=> tvcmswishlist	0.161 ms	0.01 Mb
=> tvcmswishlist	0.159 ms	0.01 Mb
=> tvcmswishlist	0.167 ms	0.01 Mb
=> tvcmswishlist	0.160 ms	0.01 Mb
=> tvcmswishlist	0.154 ms	0.01 Mb
=> tvcmswishlist	0.162 ms	0.01 Mb
=> tvcmswishlist	0.162 ms	0.01 Mb
=> tvcmswishlist	0.161 ms	0.01 Mb
=> tvcmswishlist	0.158 ms	0.01 Mb
=> tvcmswishlist	0.160 ms	0.01 Mb
=> tvcmswishlist	0.170 ms	0.01 Mb
=> tvcmswishlist	0.165 ms	0.01 Mb
=> tvcmswishlist	0.163 ms	0.01 Mb
=> tvcmswishlist	0.163 ms	0.01 Mb
=> tvcmswishlist	0.172 ms	0.01 Mb
=> tvcmswishlist	0.159 ms	0.01 Mb
=> tvcmswishlist	0.154 ms	0.01 Mb
=> tvcmswishlist	0.156 ms	0.01 Mb
=> tvcmswishlist	0.158 ms	0.01 Mb
=> tvcmswishlist	0.161 ms	0.01 Mb
=> tvcmswishlist	0.152 ms	0.01 Mb
=> tvcmswishlist	0.155 ms	0.01 Mb
=> tvcmswishlist	0.168 ms	0.01 Mb
=> tvcmswishlist	0.164 ms	0.01 Mb
=> tvcmswishlist	0.157 ms	0.01 Mb
=> tvcmswishlist	0.159 ms	0.01 Mb
=> tvcmswishlist	0.159 ms	0.01 Mb
=> tvcmswishlist	0.160 ms	0.01 Mb
DisplayProductCompareProductList	7.460 ms	0.66 Mb
=> tvcmsproductcompare	0.190 ms	0.02 Mb
=> tvcmsproductcompare	0.169 ms	0.01 Mb
=> tvcmsproductcompare	0.159 ms	0.01 Mb
=> tvcmsproductcompare	0.154 ms	0.01 Mb
=> tvcmsproductcompare	0.155 ms	0.01 Mb
=> tvcmsproductcompare	0.156 ms	0.01 Mb
=> tvcmsproductcompare	0.153 ms	0.01 Mb
=> tvcmsproductcompare	0.151 ms	0.01 Mb
=> tvcmsproductcompare	0.158 ms	0.01 Mb
=> tvcmsproductcompare	0.158 ms	0.01 Mb
=> tvcmsproductcompare	0.157 ms	0.01 Mb
=> tvcmsproductcompare	0.151 ms	0.01 Mb
=> tvcmsproductcompare	0.150 ms	0.01 Mb
=> tvcmsproductcompare	0.150 ms	0.01 Mb
=> tvcmsproductcompare	0.150 ms	0.01 Mb
=> tvcmsproductcompare	0.150 ms	0.01 Mb
=> tvcmsproductcompare	0.148 ms	0.01 Mb
=> tvcmsproductcompare	0.165 ms	0.01 Mb
=> tvcmsproductcompare	0.158 ms	0.01 Mb
=> tvcmsproductcompare	0.155 ms	0.01 Mb
=> tvcmsproductcompare	0.154 ms	0.01 Mb
=> tvcmsproductcompare	0.156 ms	0.01 Mb
=> tvcmsproductcompare	0.154 ms	0.01 Mb
=> tvcmsproductcompare	0.161 ms	0.01 Mb
=> tvcmsproductcompare	0.153 ms	0.01 Mb
=> tvcmsproductcompare	0.160 ms	0.01 Mb
=> tvcmsproductcompare	0.155 ms	0.01 Mb
=> tvcmsproductcompare	0.157 ms	0.01 Mb
=> tvcmsproductcompare	0.154 ms	0.07 Mb
=> tvcmsproductcompare	0.159 ms	0.01 Mb
=> tvcmsproductcompare	0.161 ms	0.01 Mb
=> tvcmsproductcompare	0.151 ms	0.01 Mb
=> tvcmsproductcompare	0.158 ms	0.01 Mb
=> tvcmsproductcompare	0.153 ms	0.01 Mb
=> tvcmsproductcompare	0.162 ms	0.01 Mb
=> tvcmsproductcompare	0.149 ms	0.01 Mb
=> tvcmsproductcompare	0.156 ms	0.01 Mb
=> tvcmsproductcompare	0.156 ms	0.01 Mb
=> tvcmsproductcompare	0.151 ms	0.01 Mb
=> tvcmsproductcompare	0.148 ms	0.01 Mb
=> tvcmsproductcompare	0.148 ms	0.01 Mb
=> tvcmsproductcompare	0.147 ms	0.01 Mb
=> tvcmsproductcompare	0.148 ms	0.01 Mb
=> tvcmsproductcompare	0.147 ms	0.01 Mb
=> tvcmsproductcompare	0.156 ms	0.01 Mb
=> tvcmsproductcompare	0.154 ms	0.01 Mb
=> tvcmsproductcompare	0.150 ms	0.01 Mb
=> tvcmsproductcompare	0.164 ms	0.01 Mb
DisplayNavSearchBlock	6.716 ms	0.25 Mb
=> tvcmssearch	6.716 ms	0.25 Mb
Header	5.112 ms	0.38 Mb
=> tvcmsstockinfo	0.050 ms	- Mb
=> alma	2.846 ms	0.31 Mb
=> tvcmsinfinitescroll	2.012 ms	0.06 Mb
=> tvcmsofferbanner	0.048 ms	- Mb
=> tvcmstwoofferbanner	0.044 ms	- Mb
=> tvcmsmegamenu	0.055 ms	- Mb
=> tvcmscategoryproduct	0.057 ms	- Mb
DisplayFooterCategory	4.966 ms	0.25 Mb
=> tvcmsfootercategory	4.966 ms	0.25 Mb
displayNavCustomerSignInBlock	4.183 ms	0.06 Mb
=> ps_customersignin (widget)	4.183 ms	0.06 Mb
displayNavShoppingCartBlock	3.310 ms	0.18 Mb
=> ps_shoppingcart (widget)	3.310 ms	0.18 Mb
DisplayCustomsocialblock	2.944 ms	0.24 Mb
=> tvcmscustomsetting	2.944 ms	0.24 Mb
DisplayProductPriceBlock	2.273 ms	0.21 Mb
=> cdc_googletagmanager	0.002 ms	- Mb
=> alma	0.229 ms	0.08 Mb
=> cdc_googletagmanager	0.001 ms	- Mb
=> alma	0.013 ms	- Mb
=> cdc_googletagmanager	0.001 ms	- Mb
=> alma	0.021 ms	- Mb
=> cdc_googletagmanager	0.000 ms	- Mb
=> alma	0.012 ms	- Mb
=> cdc_googletagmanager	0.000 ms	- Mb
=> alma	0.010 ms	- Mb
=> cdc_googletagmanager	0.000 ms	- Mb
=> alma	0.010 ms	- Mb
=> cdc_googletagmanager	0.001 ms	- Mb
=> alma	0.020 ms	- Mb
=> cdc_googletagmanager	0.001 ms	- Mb
=> alma	0.012 ms	- Mb
=> cdc_googletagmanager	0.001 ms	- Mb
=> alma	0.009 ms	- Mb
=> cdc_googletagmanager	0.000 ms	- Mb
=> alma	0.008 ms	- Mb
=> cdc_googletagmanager	0.000 ms	- Mb
=> alma	0.020 ms	- Mb
=> cdc_googletagmanager	0.001 ms	- Mb
=> alma	0.011 ms	- Mb
=> cdc_googletagmanager	0.001 ms	- Mb
=> alma	0.009 ms	- Mb
=> cdc_googletagmanager	0.000 ms	- Mb
=> alma	0.009 ms	- Mb
=> cdc_googletagmanager	0.001 ms	- Mb
=> alma	0.020 ms	- Mb
=> cdc_googletagmanager	0.000 ms	- Mb
=> alma	0.011 ms	- Mb
=> cdc_googletagmanager	0.000 ms	- Mb
=> alma	0.018 ms	- Mb
=> cdc_googletagmanager	0.001 ms	- Mb
=> alma	0.011 ms	- Mb
=> cdc_googletagmanager	0.001 ms	- Mb
=> alma	0.008 ms	- Mb
=> cdc_googletagmanager	0.001 ms	- Mb
=> alma	0.018 ms	- Mb
=> cdc_googletagmanager	0.001 ms	- Mb
=> alma	0.010 ms	- Mb
=> cdc_googletagmanager	0.000 ms	- Mb
=> alma	0.009 ms	- Mb
=> cdc_googletagmanager	0.001 ms	- Mb
=> alma	0.019 ms	- Mb
=> cdc_googletagmanager	0.000 ms	- Mb
=> alma	0.011 ms	- Mb
=> cdc_googletagmanager	0.000 ms	- Mb
=> alma	0.009 ms	- Mb
=> cdc_googletagmanager	0.001 ms	- Mb
=> alma	0.019 ms	- Mb
=> cdc_googletagmanager	0.000 ms	- Mb
=> alma	0.010 ms	- Mb
=> cdc_googletagmanager	0.001 ms	- Mb
=> alma	0.019 ms	- Mb
=> cdc_googletagmanager	0.001 ms	- Mb
=> alma	0.011 ms	- Mb
=> cdc_googletagmanager	0.001 ms	- Mb
=> alma	0.009 ms	- Mb
=> cdc_googletagmanager	0.000 ms	- Mb
=> alma	0.009 ms	- Mb
=> cdc_googletagmanager	0.001 ms	- Mb
=> alma	0.018 ms	- Mb
=> cdc_googletagmanager	0.001 ms	- Mb
=> alma	0.012 ms	- Mb
=> cdc_googletagmanager	0.001 ms	- Mb
=> alma	0.009 ms	- Mb
=> cdc_googletagmanager	0.000 ms	- Mb
=> alma	0.009 ms	- Mb
=> cdc_googletagmanager	0.001 ms	- Mb
=> alma	0.019 ms	- Mb
=> cdc_googletagmanager	0.001 ms	- Mb
=> alma	0.011 ms	- Mb
=> cdc_googletagmanager	0.000 ms	- Mb
=> alma	0.009 ms	- Mb
=> cdc_googletagmanager	0.000 ms	- Mb
=> alma	0.008 ms	- Mb
=> cdc_googletagmanager	0.001 ms	- Mb
=> alma	0.020 ms	- Mb
=> cdc_googletagmanager	0.000 ms	- Mb
=> alma	0.011 ms	- Mb
=> cdc_googletagmanager	0.001 ms	- Mb
=> alma	0.019 ms	- Mb
=> cdc_googletagmanager	0.001 ms	- Mb
=> alma	0.011 ms	- Mb
=> cdc_googletagmanager	0.001 ms	- Mb
=> alma	0.009 ms	- Mb
=> cdc_googletagmanager	0.001 ms	- Mb
=> alma	0.009 ms	- Mb
=> cdc_googletagmanager	0.001 ms	- Mb
=> alma	0.018 ms	- Mb
=> cdc_googletagmanager	0.001 ms	- Mb
=> alma	0.010 ms	- Mb
=> cdc_googletagmanager	0.001 ms	- Mb
=> alma	0.009 ms	- Mb
=> cdc_googletagmanager	0.000 ms	- Mb
=> alma	0.008 ms	- Mb
=> cdc_googletagmanager	0.000 ms	- Mb
=> alma	0.019 ms	- Mb
=> cdc_googletagmanager	0.001 ms	- Mb
=> alma	0.010 ms	- Mb
=> cdc_googletagmanager	0.000 ms	- Mb
=> alma	0.010 ms	- Mb
=> cdc_googletagmanager	0.000 ms	- Mb
=> alma	0.009 ms	- Mb
=> cdc_googletagmanager	0.001 ms	- Mb
=> alma	0.020 ms	- Mb
=> cdc_googletagmanager	0.001 ms	- Mb
=> alma	0.010 ms	- Mb
=> cdc_googletagmanager	0.001 ms	- Mb
=> alma	0.020 ms	- Mb
=> cdc_googletagmanager	0.000 ms	- Mb
=> alma	0.012 ms	- Mb
=> cdc_googletagmanager	0.000 ms	- Mb
=> alma	0.009 ms	- Mb
=> cdc_googletagmanager	0.001 ms	- Mb
=> alma	0.009 ms	- Mb
=> cdc_googletagmanager	0.001 ms	- Mb
=> alma	0.018 ms	- Mb
=> cdc_googletagmanager	0.000 ms	- Mb
=> alma	0.010 ms	- Mb
=> cdc_googletagmanager	0.001 ms	- Mb
=> alma	0.009 ms	- Mb
=> cdc_googletagmanager	0.000 ms	- Mb
=> alma	0.008 ms	- Mb
=> cdc_googletagmanager	0.001 ms	- Mb
=> alma	0.020 ms	- Mb
=> cdc_googletagmanager	0.001 ms	- Mb
=> alma	0.011 ms	- Mb
=> cdc_googletagmanager	0.001 ms	- Mb
=> alma	0.009 ms	- Mb
=> cdc_googletagmanager	0.001 ms	- Mb
=> alma	0.009 ms	- Mb
=> cdc_googletagmanager	0.001 ms	- Mb
=> alma	0.021 ms	- Mb
=> cdc_googletagmanager	0.000 ms	- Mb
=> alma	0.010 ms	- Mb
=> cdc_googletagmanager	0.001 ms	- Mb
=> alma	0.022 ms	- Mb
=> cdc_googletagmanager	0.000 ms	- Mb
=> alma	0.011 ms	- Mb
=> cdc_googletagmanager	0.000 ms	- Mb
=> alma	0.009 ms	- Mb
=> cdc_googletagmanager	0.001 ms	- Mb
=> alma	0.019 ms	- Mb
=> cdc_googletagmanager	0.000 ms	- Mb
=> alma	0.010 ms	- Mb
=> cdc_googletagmanager	0.001 ms	- Mb
=> alma	0.009 ms	- Mb
=> cdc_googletagmanager	0.001 ms	- Mb
=> alma	0.021 ms	- Mb
=> cdc_googletagmanager	0.000 ms	- Mb
=> alma	0.010 ms	- Mb
=> cdc_googletagmanager	0.000 ms	- Mb
=> alma	0.009 ms	- Mb
=> cdc_googletagmanager	0.001 ms	- Mb
=> alma	0.022 ms	- Mb
=> cdc_googletagmanager	0.001 ms	- Mb
=> alma	0.010 ms	- Mb
=> cdc_googletagmanager	0.001 ms	- Mb
=> alma	0.021 ms	- Mb
=> cdc_googletagmanager	0.000 ms	- Mb
=> alma	0.011 ms	- Mb
=> cdc_googletagmanager	0.001 ms	- Mb
=> alma	0.009 ms	- Mb
=> cdc_googletagmanager	0.001 ms	- Mb
=> alma	0.020 ms	- Mb
=> cdc_googletagmanager	0.000 ms	- Mb
=> alma	0.011 ms	- Mb
=> cdc_googletagmanager	0.000 ms	- Mb
=> alma	0.009 ms	- Mb
=> cdc_googletagmanager	0.001 ms	- Mb
=> alma	0.020 ms	- Mb
=> cdc_googletagmanager	0.001 ms	- Mb
=> alma	0.010 ms	- Mb
=> cdc_googletagmanager	0.001 ms	- Mb
=> alma	0.009 ms	- Mb
=> cdc_googletagmanager	0.001 ms	- Mb
=> alma	0.021 ms	- Mb
=> cdc_googletagmanager	0.001 ms	- Mb
=> alma	0.011 ms	- Mb
=> cdc_googletagmanager	0.001 ms	- Mb
=> alma	0.022 ms	- Mb
=> cdc_googletagmanager	0.001 ms	- Mb
=> alma	0.011 ms	- Mb
=> cdc_googletagmanager	0.000 ms	- Mb
=> alma	0.010 ms	- Mb
=> cdc_googletagmanager	0.001 ms	- Mb
=> alma	0.009 ms	- Mb
=> cdc_googletagmanager	0.001 ms	- Mb
=> alma	0.020 ms	- Mb
=> cdc_googletagmanager	0.000 ms	- Mb
=> alma	0.011 ms	- Mb
=> cdc_googletagmanager	0.000 ms	- Mb
=> alma	0.009 ms	- Mb
=> cdc_googletagmanager	0.000 ms	- Mb
=> alma	0.008 ms	- Mb
=> cdc_googletagmanager	0.001 ms	- Mb
=> alma	0.020 ms	- Mb
=> cdc_googletagmanager	0.001 ms	- Mb
=> alma	0.011 ms	- Mb
=> cdc_googletagmanager	0.001 ms	- Mb
=> alma	0.009 ms	- Mb
=> cdc_googletagmanager	0.001 ms	- Mb
=> alma	0.009 ms	- Mb
=> cdc_googletagmanager	0.001 ms	- Mb
=> alma	0.021 ms	- Mb
=> cdc_googletagmanager	0.001 ms	- Mb
=> alma	0.010 ms	- Mb
=> cdc_googletagmanager	0.001 ms	- Mb
=> alma	0.024 ms	- Mb
=> cdc_googletagmanager	0.001 ms	- Mb
=> alma	0.011 ms	- Mb
=> cdc_googletagmanager	0.001 ms	- Mb
=> alma	0.010 ms	- Mb
=> cdc_googletagmanager	0.001 ms	- Mb
=> alma	0.008 ms	- Mb
=> cdc_googletagmanager	0.001 ms	- Mb
=> alma	0.018 ms	- Mb
=> cdc_googletagmanager	0.000 ms	- Mb
=> alma	0.010 ms	- Mb
=> cdc_googletagmanager	0.001 ms	- Mb
=> alma	0.010 ms	- Mb
=> cdc_googletagmanager	0.000 ms	- Mb
=> alma	0.009 ms	- Mb
=> cdc_googletagmanager	0.001 ms	- Mb
=> alma	0.019 ms	- Mb
=> cdc_googletagmanager	0.000 ms	- Mb
=> alma	0.011 ms	- Mb
=> cdc_googletagmanager	0.000 ms	- Mb
=> alma	0.009 ms	- Mb
=> cdc_googletagmanager	0.001 ms	- Mb
=> alma	0.009 ms	- Mb
=> cdc_googletagmanager	0.001 ms	- Mb
=> alma	0.019 ms	- Mb
=> cdc_googletagmanager	0.001 ms	- Mb
=> alma	0.010 ms	- Mb
=> cdc_googletagmanager	0.001 ms	- Mb
=> alma	0.020 ms	- Mb
=> cdc_googletagmanager	0.001 ms	- Mb
=> alma	0.011 ms	- Mb
=> cdc_googletagmanager	0.000 ms	- Mb
=> alma	0.009 ms	- Mb
=> cdc_googletagmanager	0.000 ms	- Mb
=> alma	0.008 ms	- Mb
=> cdc_googletagmanager	0.001 ms	- Mb
=> alma	0.018 ms	- Mb
=> cdc_googletagmanager	0.000 ms	- Mb
=> alma	0.011 ms	- Mb
=> cdc_googletagmanager	0.000 ms	- Mb
=> alma	0.009 ms	- Mb
=> cdc_googletagmanager	0.001 ms	- Mb
=> alma	0.009 ms	- Mb
=> cdc_googletagmanager	0.001 ms	- Mb
=> alma	0.019 ms	- Mb
=> cdc_googletagmanager	0.000 ms	- Mb
=> alma	0.012 ms	- Mb
=> cdc_googletagmanager	0.000 ms	- Mb
=> alma	0.010 ms	- Mb
=> cdc_googletagmanager	0.000 ms	- Mb
=> alma	0.008 ms	- Mb
=> cdc_googletagmanager	0.001 ms	- Mb
=> alma	0.018 ms	- Mb
=> cdc_googletagmanager	0.000 ms	- Mb
=> alma	0.011 ms	- Mb
=> cdc_googletagmanager	0.001 ms	- Mb
=> alma	0.019 ms	- Mb
=> cdc_googletagmanager	0.001 ms	- Mb
=> alma	0.011 ms	- Mb
=> cdc_googletagmanager	0.000 ms	- Mb
=> alma	0.009 ms	- Mb
=> cdc_googletagmanager	0.001 ms	- Mb
=> alma	0.018 ms	- Mb
=> cdc_googletagmanager	0.000 ms	- Mb
=> alma	0.010 ms	- Mb
=> cdc_googletagmanager	0.000 ms	- Mb
=> alma	0.009 ms	- Mb
=> cdc_googletagmanager	0.001 ms	- Mb
=> alma	0.018 ms	- Mb
=> cdc_googletagmanager	0.001 ms	- Mb
=> alma	0.010 ms	- Mb
=> cdc_googletagmanager	0.000 ms	- Mb
=> alma	0.009 ms	- Mb
=> cdc_googletagmanager	0.001 ms	- Mb
=> alma	0.020 ms	- Mb
=> cdc_googletagmanager	0.000 ms	- Mb
=> alma	0.011 ms	- Mb
=> cdc_googletagmanager	0.001 ms	- Mb
=> alma	0.020 ms	- Mb
=> cdc_googletagmanager	0.000 ms	- Mb
=> alma	0.011 ms	- Mb
=> cdc_googletagmanager	0.000 ms	- Mb
=> alma	0.009 ms	- Mb
=> cdc_googletagmanager	0.001 ms	- Mb
=> alma	0.018 ms	- Mb
=> cdc_googletagmanager	0.001 ms	- Mb
=> alma	0.010 ms	- Mb
=> cdc_googletagmanager	0.000 ms	- Mb
=> alma	0.008 ms	- Mb
=> cdc_googletagmanager	0.001 ms	- Mb
=> alma	0.018 ms	- Mb
=> cdc_googletagmanager	0.000 ms	- Mb
=> alma	0.011 ms	- Mb
=> cdc_googletagmanager	0.001 ms	- Mb
=> alma	0.009 ms	- Mb
DisplayPaymentIcon	2.250 ms	0.06 Mb
=> tvcmspaymenticon	2.250 ms	0.06 Mb
displayNavLanguageBlock	1.601 ms	0.05 Mb
=> ps_languageselector (widget)	1.601 ms	0.05 Mb
displaySocialMediaBlock	1.540 ms	0.07 Mb
=> ps_socialfollow (widget)	1.540 ms	0.07 Mb
displayNavCurrencyBlock	1.449 ms	0.05 Mb
=> ps_currencyselector (widget)	1.449 ms	0.05 Mb
displayFooterPart1	1.164 ms	0.06 Mb
=> ps_linklist (widget)	1.164 ms	0.06 Mb
displayMyaccountcblock	1.049 ms	0.06 Mb
=> ps_customeraccountlinks (widget)	1.049 ms	0.06 Mb
DisplayNavWishlistBlocksticky	0.914 ms	0.06 Mb
=> tvcmswishlist	0.914 ms	0.06 Mb
displayContactCinfo	0.699 ms	0.04 Mb
=> ps_contactinfo (widget)	0.699 ms	0.04 Mb
DisplayNavProductCompareBlock	0.351 ms	0.08 Mb
=> tvcmsproductcompare	0.195 ms	0.08 Mb
=> tvcmsproductcompare	0.156 ms	0.01 Mb
ProductSearchProvider	0.299 ms	0.01 Mb
=> ps_facetedsearch	0.299 ms	0.01 Mb
DisplayProductListStockIndicator	0.196 ms	0.01 Mb
=> tvcmsstockinfo	0.012 ms	- Mb
=> tvcmsstockinfo	0.008 ms	- Mb
=> tvcmsstockinfo	0.007 ms	- Mb
=> tvcmsstockinfo	0.009 ms	- Mb
=> tvcmsstockinfo	0.008 ms	- Mb
=> tvcmsstockinfo	0.007 ms	- Mb
=> tvcmsstockinfo	0.007 ms	- Mb
=> tvcmsstockinfo	0.007 ms	- Mb
=> tvcmsstockinfo	0.009 ms	- Mb
=> tvcmsstockinfo	0.007 ms	- Mb
=> tvcmsstockinfo	0.008 ms	- Mb
=> tvcmsstockinfo	0.008 ms	- Mb
=> tvcmsstockinfo	0.008 ms	- Mb
=> tvcmsstockinfo	0.008 ms	- Mb
=> tvcmsstockinfo	0.014 ms	- Mb
=> tvcmsstockinfo	0.008 ms	- Mb
=> tvcmsstockinfo	0.009 ms	- Mb
=> tvcmsstockinfo	0.007 ms	- Mb
=> tvcmsstockinfo	0.008 ms	- Mb
=> tvcmsstockinfo	0.007 ms	- Mb
=> tvcmsstockinfo	0.008 ms	- Mb
=> tvcmsstockinfo	0.007 ms	- Mb
=> tvcmsstockinfo	0.007 ms	- Mb
=> tvcmsstockinfo	0.007 ms	- Mb
ActionFrontControllerSetMedia	0.178 ms	0.01 Mb
=> blockreassurance	0.109 ms	- Mb
=> ps_socialfollow	0.032 ms	- Mb
=> ps_emailalerts	0.037 ms	- Mb
DisplayFooterPart2	0.170 ms	0.03 Mb
=> tvcmsfooterlogo	0.170 ms	0.03 Mb
DisplayProductComparesticky	0.167 ms	0.01 Mb
=> tvcmsproductcompare	0.167 ms	0.01 Mb
DisplayFacetedSearchBlock	0.166 ms	0.07 Mb
=> ps_facetedsearch	0.166 ms	0.07 Mb
DisplayCopyRightText	0.127 ms	0.02 Mb
=> tvcmscustomsetting	0.127 ms	0.02 Mb
ModuleRoutes	0.067 ms	- Mb
=> alma	0.067 ms	- Mb
DisplayTopOfferText	0.011 ms	- Mb
=> tvcmscustomsetting	0.008 ms	- Mb
=> tvcmscustomsetting	0.003 ms	- Mb
DisplayBeforeBodyClosingTag	0.008 ms	- Mb
=> cdc_googletagmanager	0.008 ms	- Mb
DisplayCustomCss	0.005 ms	- Mb
=> tvcmscustomcssjs	0.005 ms	- Mb
DisplayNavFullWidth	0.004 ms	- Mb
=> blockreassurance	0.004 ms	- Mb
DisplayOverrideTemplate	0.004 ms	- Mb
=> ets_advancedcaptcha	0.004 ms	- Mb
DisplayCustomJs	0.004 ms	- Mb
=> tvcmscustomcssjs	0.004 ms	- Mb
DisplayFooter	0.003 ms	- Mb
=> ganalyticspro	0.003 ms	- Mb
42 hook(s)	2014 ms	52.65 Mb

244 queries	SELECT XX FROM `preXX_specific_price` WHERE id_product = XX LIMIT XX
243 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 `preXX_product` p INNER JOIN `preXX_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = XX) LEFT JOIN `preXX_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)
243 queries	SELECT `reduction` FROM `preXX_product_group_reduction_cache` WHERE `id_product` = XX AND `id_group` = XX LIMIT XX
243 queries	SELECT `id_tax_rules_group` FROM `preXX_product_shop` WHERE `id_product` = XX AND id_shop=XX LIMIT XX
233 queries	SELECT `priority`, `id_specific_price_priority` FROM `preXX_specific_price_priority` WHERE `id_product` = XX ORDER BY `id_specific_price_priority` DESC LIMIT XX
225 queries	SELECT *, ( IF (`id_group` = XX, XX, XX) + IF (`id_country` = XX, XX, XX) + IF (`id_currency` = XX, XX, XX) + IF (`id_shop` = XX, XX, XX) + IF (`id_customer` = XX, XX, XX)) AS `score` FROM `preXX_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
216 queries	SELECT product_attribute_shop.id_product_attribute FROM preXX_product_attribute pa INNER JOIN preXX_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 avg, MIN(pc.`grade`) AS min, MAX(pc.`grade`) AS max FROM `preXX_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 grade FROM `preXX_tvcmsproduct_comment` pc WHERE pc.`id_product` = XX AND pc.`deleted` = XX AND pc.`validate` = XX LIMIT XX
33 queries	SELECT `id_product_attribute` FROM `preXX_product_attribute` WHERE `id_product` = XX
33 queries	SELECT image_shop.`cover`, i.`id_image`, il.`legend`, i.`position` FROM `preXX_image` i INNER JOIN preXX_image_shop image_shop ON (image_shop.id_image = i.id_image AND image_shop.id_shop = XX) LEFT JOIN `preXX_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = XX) WHERE i.`id_product` = XX ORDER BY `position`
32 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 `preXX_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 `preXX_cart_product` cp JOIN `preXX_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `preXX_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
32 queries	SELECT SUM(quantity) FROM `preXX_stock_available` WHERE (id_product = XX) AND (id_product_attribute = XX) AND (id_shop = XX) AND (id_shop_group = XX) LIMIT XX
29 queries	SELECT image_shop.`id_image` FROM `preXX_image` i INNER JOIN preXX_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
29 queries	SELECT name FROM preXX_category_lang WHERE id_shop = XX AND id_lang = XX AND id_category = XX LIMIT XX
29 queries	SELECT * FROM `preXX_product` a LEFT JOIN `preXX_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = XX LEFT JOIN `preXX_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
26 queries	SELECT name, value, pf.id_feature, f.position, fvl.id_feature_value FROM preXX_feature_product pf LEFT JOIN preXX_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = XX) LEFT JOIN preXX_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = XX) LEFT JOIN preXX_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = XX) INNER JOIN preXX_feature_shop feature_shop ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = XX) WHERE pf.id_product = XX ORDER BY f.position ASC
21 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 preXX_product p LEFT JOIN preXX_product_lang pl ON pl.id_product = p.id_product AND pl.id_shop = XX AND pl.id_lang = XX LEFT JOIN preXX_stock_available sa ON sa.id_product = p.id_product AND sa.id_product_attribute = XX AND sa.id_shop = XX LEFT JOIN preXX_product_shop ps ON ps.id_product = p.id_product AND ps.id_shop = XX WHERE p.id_product IN (XX)
17 queries	SELECT cl.`link_rewrite` FROM `preXX_category_lang` cl WHERE `id_lang` = XX AND cl.id_shop = XX AND cl.`id_category` = XX LIMIT XX
16 queries	SELECT `id_module` FROM `preXX_module_shop` WHERE `id_module` = XX AND `id_shop` = XX LIMIT XX
12 queries	SELECT COUNT(`id_tvcmsproduct_comment`) AS "nbr" FROM `preXX_tvcmsproduct_comment` pc WHERE `id_product` = XX AND `validate` = XX LIMIT XX
12 queries	SELECT DISTINCT pl.name as name FROM `preXX_product_lang` pl WHERE (pl.id_product = XX) AND (pl.id_lang = XX AND pl.id_shop = XX ) LIMIT XX
12 queries	SELECT * FROM `preXX_product_lang` WHERE `id_product` = XX AND `id_shop` = XX
12 queries	SELECT * FROM `preXX_product` a LEFT JOIN `preXX_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = XX WHERE (a.`id_product` = XX) LIMIT XX
11 queries	SELECT * FROM `preXX_category` a LEFT JOIN `preXX_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = XX WHERE (a.`id_category` = XX) LIMIT XX
11 queries	SELECT * FROM `preXX_category_lang` WHERE `id_category` = XX AND `id_shop` = XX
10 queries	SELECT mr.* FROM preXX_tvcmsmegamenu_row_shop mr WHERE mr.`id_shop` = XX AND mr.id_tvcmsmegamenu = XX AND mr.`active` = XX
8 queries	SELECT v., vl., IF(lifvlv.`url_name` IS NULL OR lifvlv.`url_name` = "", NULL, lifvlv.`url_name`) AS url_name, IF(lifvlv.`meta_title` IS NULL OR lifvlv.`meta_title` = "", NULL, lifvlv.`meta_title`) AS meta_title FROM `preXX_feature_value` v LEFT JOIN `preXX_feature_value_lang` vl ON (v.`id_feature_value` = vl.`id_feature_value` AND vl.`id_lang` = XX) LEFT JOIN `preXX_layered_indexable_feature_value_lang_value` lifvlv ON (v.`id_feature_value` = lifvlv.`id_feature_value` AND lifvlv.`id_lang` = XX) WHERE v.`id_feature` = XX ORDER BY vl.`value` ASC
8 queries	SELECT *, ( IF (`id_group` = XX, XX, XX) + IF (`id_country` = XX, XX, XX) + IF (`id_currency` = XX, XX, XX) + IF (`id_shop` = XX, XX, XX) + IF (`id_customer` = XX, XX, XX)) AS `score` FROM `preXX_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` IN (XX, XX) AND `id_cart` = XX AND (`from` = 'XX-XX-XX XX:XX:XX' OR 'XX-XX-XX XX:XX:XX' >= `from`) AND (`to` = 'XX-XX-XX XX:XX:XX' OR 'XX-XX-XX XX:XX:XX' <= `to`) AND IF(`from_quantity` > XX, `from_quantity`, XX) <= XX ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT XX
7 queries	SELECT * FROM `preXX_category` a LEFT JOIN `preXX_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = XX LEFT JOIN `preXX_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = XX WHERE (a.`id_category` = XX) AND (b.`id_shop` = XX) LIMIT XX
7 queries	SELECT fp.id_feature, fp.id_feature_value, 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 preXX_product p LEFT JOIN preXX_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN preXX_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN preXX_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 preXX_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN preXX_category_product cp ON (p.id_product = cp.id_product) INNER JOIN preXX_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = XX AND ps.active = TRUE) INNER JOIN preXX_category c ON (cp.id_category = c.id_category AND c.active=XX) LEFT JOIN preXX_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN preXX_feature_product fp ON (p.id_product = fp.id_product) WHERE ((fp.id_feature_value IN (XX, XX, XX, XX, XX))) AND ps.id_shop='XX' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='XX' AND c.nleft>=XX AND c.nright<=XX GROUP BY p.id_product) p INNER JOIN preXX_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN preXX_feature_product fp_XX ON (p.id_product = fp_XX.id_product) WHERE ((fp.id_feature=XX)) AND ((fp_XX.id_feature_value IN (XX, XX, XX, XX, XX))) GROUP BY fp.id_feature_value
7 queries	SELECT `id_country` FROM `preXX_country` WHERE `iso_code` = 'FR' LIMIT XX
5 queries	SELECT `name` FROM `preXX_manufacturer` WHERE `id_manufacturer` = XX AND `active` = XX LIMIT XX
5 queries	SELECT * FROM `preXX_country_lang` WHERE `id_country` = XX
5 queries	SELECT * FROM `preXX_country` a LEFT JOIN `preXX_country_shop` `c` ON a.`id_country` = c.`id_country` AND c.`id_shop` = XX WHERE (a.`id_country` = XX) LIMIT XX
5 queries	SELECT `name` FROM `preXX_country_lang` WHERE `id_lang` = XX AND `id_country` = XX LIMIT XX
5 queries	SELECT quantity, reserved_quantity FROM `preXX_stock_available` WHERE (id_product = XX) AND (id_product_attribute = XX) AND (id_shop = XX) AND (id_shop_group = XX) LIMIT XX
3 queries	SELECT product_attribute_shop.`price` FROM `preXX_product_attribute` pa INNER JOIN preXX_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
3 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 `preXX_attribute` a LEFT JOIN `preXX_attribute_lang` al ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = XX) LEFT JOIN `preXX_product_attribute_combination` pac ON (pac.`id_attribute` = a.`id_attribute`) LEFT JOIN `preXX_product_attribute` pa ON (pa.`id_product_attribute` = pac.`id_product_attribute`) INNER JOIN preXX_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 `preXX_product_attribute_lang` pal ON (pal.`id_product_attribute` = pac.`id_product_attribute` AND pal.`id_lang` = XX) LEFT JOIN `preXX_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
3 queries	SELECT * FROM `preXX_product_attribute` a LEFT JOIN `preXX_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
3 queries	SELECT * FROM `preXX_product_attribute_lang` WHERE `id_product_attribute` = XX
3 queries	SELECT tr.* FROM `preXX_tax_rule` tr JOIN `preXX_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 `need_identification_number` FROM `preXX_country` WHERE `id_country` = XX LIMIT XX
3 queries	SELECT pa.`available_date` FROM `preXX_product` p LEFT JOIN `preXX_product_attribute` pa ON (pa.`id_product` = p.`id_product`) INNER JOIN preXX_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = XX) INNER JOIN preXX_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
3 queries	SELECT count(id_wishlist_product) FROM preXX_wishlist w, preXX_wishlist_product wp where w.id_wishlist = wp.id_wishlist and w.id_customer=XX LIMIT XX
3 queries	SELECT m.`id_module`, m.`name`, ms.`id_module`as `mshop` FROM `preXX_module` m LEFT JOIN `preXX_module_shop` ms ON m.`id_module` = ms.`id_module` AND ms.`id_shop` = XX
2 queries	SELECT `id_lang` FROM `preXX_lang` WHERE `locale` = 'fr-fr' OR `language_code` = 'fr-fr' LIMIT XX
2 queries	SELECT pai.`id_image`, pai.`id_product_attribute`, il.`legend` FROM `preXX_product_attribute_image` pai LEFT JOIN `preXX_image_lang` il ON (il.`id_image` = pai.`id_image`) LEFT JOIN `preXX_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 id_module as id, active FROM preXX_module WHERE name = "pm_advancedcookiebanner" AND active = 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 `preXX_product` p INNER JOIN preXX_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = XX) LEFT JOIN `preXX_product_lang` `pl` ON p.`id_product` = pl.`id_product` AND pl.`id_lang` = XX AND pl.id_shop = XX LEFT JOIN `preXX_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 `preXX_image_lang` `il` ON image_shop.`id_image` = il.`id_image` AND il.`id_lang` = XX LEFT JOIN `preXX_manufacturer` `m` ON m.`id_manufacturer` = p.`id_manufacturer` LEFT JOIN `preXX_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 preXX_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) AND (EXISTS(SELECT XX FROM `preXX_category_product` cp JOIN `preXX_category_group` cg ON (cp.id_category = cg.id_category AND cg.`id_group` =XX) WHERE cp.`id_product` = p.`id_product`)) ORDER BY product_shop.`date_add` DESC LIMIT XX
2 queries	SELECT `id_category` FROM `preXX_category_shop` WHERE `id_category` = XX AND `id_shop` = XX LIMIT XX
2 queries	SELECT ctg.`id_group` FROM preXX_category_group ctg WHERE ctg.`id_category` = XX AND ctg.`id_group` = XX LIMIT XX
2 queries	SELECT pac.`id_product_attribute`, al.`name` AS attribute_name FROM `preXX_product_attribute_combination` pac LEFT JOIN `preXX_attribute` a ON a.`id_attribute` = pac.`id_attribute` LEFT JOIN `preXX_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group` LEFT JOIN `preXX_attribute_lang` al ON ( a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = XX ) WHERE pac.`id_product_attribute` = XX
2 queries	SELECT * FROM preXX_product_attachment pa LEFT JOIN preXX_attachment a ON a.id_attachment = pa.id_attachment LEFT JOIN preXX_attachment_lang al ON (a.id_attachment = al.id_attachment AND al.id_lang = XX) WHERE pa.id_product = XX

Name	Instances	Source
Category	80	/controllers/front/listing/CategoryController.php:78 (__construct) [id: 2] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 37] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 36] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 42] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 49] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 58] /classes/Meta.php:380 (__construct) [id: 2] /classes/PrestaShopCollection.php:385 (hydrateCollection) [id: ] /modules/ganalyticspro/lib/gtag/categoryTag.php:57 (__construct) [id: 2] /modules/ganalyticspro/lib/moduleTools.php:141 (__construct) [id: 2] /modules/ganalyticspro/lib/moduleTools.php:141 (__construct) [id: 2] /classes/Link.php:402 (__construct) [id: 2] /modules/ps_facetedsearch/src/Product/Search.php:364 (__construct) [id: 2] /modules/ps_facetedsearch/src/Filters/Block.php:157 (__construct) [id: 2] /modules/cdc_googletagmanager/cdc_googletagmanager.php:1313 (__construct) [id: 2] /modules/cdc_googletagmanager/classes/gtm/DataLayerItem.php:109 (__construct) [id: 160] /modules/cdc_googletagmanager/cdc_googletagmanager.php:1374 (__construct) [id: 2] /modules/cdc_googletagmanager/cdc_googletagmanager.php:1323 (__construct) [id: 113] /modules/cdc_googletagmanager/cdc_googletagmanager.php:1323 (__construct) [id: 37] /modules/cdc_googletagmanager/cdc_googletagmanager.php:1323 (__construct) [id: 113] /modules/cdc_googletagmanager/classes/gtm/DataLayerItem.php:109 (__construct) [id: 162] /modules/cdc_googletagmanager/cdc_googletagmanager.php:1323 (__construct) [id: 113] /modules/cdc_googletagmanager/cdc_googletagmanager.php:1323 (__construct) [id: 37] /modules/cdc_googletagmanager/cdc_googletagmanager.php:1323 (__construct) [id: 113] /modules/cdc_googletagmanager/classes/gtm/DataLayerItem.php:109 (__construct) [id: 161] /modules/cdc_googletagmanager/cdc_googletagmanager.php:1323 (__construct) [id: 113] /modules/cdc_googletagmanager/cdc_googletagmanager.php:1323 (__construct) [id: 37] /modules/cdc_googletagmanager/cdc_googletagmanager.php:1323 (__construct) [id: 113] /modules/cdc_googletagmanager/classes/gtm/DataLayerItem.php:109 (__construct) [id: 160] /modules/cdc_googletagmanager/cdc_googletagmanager.php:1323 (__construct) [id: 113] /modules/cdc_googletagmanager/cdc_googletagmanager.php:1323 (__construct) [id: 37] /modules/cdc_googletagmanager/cdc_googletagmanager.php:1323 (__construct) [id: 113] /modules/cdc_googletagmanager/classes/gtm/DataLayerItem.php:109 (__construct) [id: 160] /modules/cdc_googletagmanager/cdc_googletagmanager.php:1323 (__construct) [id: 113] /modules/cdc_googletagmanager/cdc_googletagmanager.php:1323 (__construct) [id: 37] /modules/cdc_googletagmanager/cdc_googletagmanager.php:1323 (__construct) [id: 113] /modules/cdc_googletagmanager/classes/gtm/DataLayerItem.php:109 (__construct) [id: 160] /modules/cdc_googletagmanager/cdc_googletagmanager.php:1323 (__construct) [id: 113] /modules/cdc_googletagmanager/cdc_googletagmanager.php:1323 (__construct) [id: 37] /modules/cdc_googletagmanager/cdc_googletagmanager.php:1323 (__construct) [id: 113] /modules/cdc_googletagmanager/classes/gtm/DataLayerItem.php:109 (__construct) [id: 162] /modules/cdc_googletagmanager/cdc_googletagmanager.php:1323 (__construct) [id: 113] /modules/cdc_googletagmanager/cdc_googletagmanager.php:1323 (__construct) [id: 37] /modules/cdc_googletagmanager/cdc_googletagmanager.php:1323 (__construct) [id: 113] /modules/cdc_googletagmanager/classes/gtm/DataLayerItem.php:109 (__construct) [id: 160] /modules/cdc_googletagmanager/cdc_googletagmanager.php:1323 (__construct) [id: 113] /modules/cdc_googletagmanager/cdc_googletagmanager.php:1323 (__construct) [id: 37] /modules/cdc_googletagmanager/cdc_googletagmanager.php:1323 (__construct) [id: 113] /modules/cdc_googletagmanager/classes/gtm/DataLayerItem.php:109 (__construct) [id: 160] /modules/cdc_googletagmanager/cdc_googletagmanager.php:1323 (__construct) [id: 113] /modules/cdc_googletagmanager/cdc_googletagmanager.php:1323 (__construct) [id: 37] /modules/cdc_googletagmanager/cdc_googletagmanager.php:1323 (__construct) [id: 113] /modules/cdc_googletagmanager/classes/gtm/DataLayerItem.php:109 (__construct) [id: 160] /modules/cdc_googletagmanager/cdc_googletagmanager.php:1323 (__construct) [id: 113] /modules/cdc_googletagmanager/cdc_googletagmanager.php:1323 (__construct) [id: 37] /modules/cdc_googletagmanager/cdc_googletagmanager.php:1323 (__construct) [id: 113] /modules/cdc_googletagmanager/classes/gtm/DataLayerItem.php:109 (__construct) [id: 160] /modules/cdc_googletagmanager/cdc_googletagmanager.php:1323 (__construct) [id: 113] /modules/cdc_googletagmanager/cdc_googletagmanager.php:1323 (__construct) [id: 37] /modules/cdc_googletagmanager/cdc_googletagmanager.php:1323 (__construct) [id: 113] /modules/cdc_googletagmanager/classes/gtm/DataLayerItem.php:109 (__construct) [id: 162] /modules/cdc_googletagmanager/cdc_googletagmanager.php:1323 (__construct) [id: 113] /modules/cdc_googletagmanager/cdc_googletagmanager.php:1323 (__construct) [id: 37] /modules/cdc_googletagmanager/cdc_googletagmanager.php:1323 (__construct) [id: 113] /modules/cdc_googletagmanager/cdc_googletagmanager.php:1313 (__construct) [id: 2] /modules/tvcmssearch/tvcmssearch.php:100 (getNestedCategories) [id: 2] /modules/ps_categorytree/ps_categorytree.php:368 (__construct) [id: 2] /modules/ps_categorytree/ps_categorytree.php:361 (getParentsCategories) [id: 2] /modules/tvcmstabproducts/tvcmstabproducts.php:2683 (__construct) [id: 118] /classes/Link.php:402 (__construct) [id: 118] /modules/tvcmsfootercategory/tvcmsfootercategory.php:401 (__construct) [id: 37] /classes/Link.php:402 (__construct) [id: 37] /modules/tvcmsfootercategory/tvcmsfootercategory.php:401 (__construct) [id: 36] /classes/Link.php:402 (__construct) [id: 36] /modules/tvcmsfootercategory/tvcmsfootercategory.php:401 (__construct) [id: 42] /classes/Link.php:402 (__construct) [id: 42] /modules/tvcmsfootercategory/tvcmsfootercategory.php:401 (__construct) [id: 49] /classes/Link.php:402 (__construct) [id: 49] /modules/tvcmsfootercategory/tvcmsfootercategory.php:401 (__construct) [id: 58] /classes/Link.php:402 (__construct) [id: 58]
Product	59	/classes/Link.php:113 (__construct) [id: 289] /classes/Link.php:113 (__construct) [id: 616] /classes/Link.php:113 (__construct) [id: 761] /classes/Link.php:113 (__construct) [id: 617] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 289] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 616] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 88] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 52] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 145] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 675] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 530] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 668] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 386] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 341] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 761] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 617] /classes/Link.php:113 (__construct) [id: 289] /classes/Link.php:113 (__construct) [id: 616] /classes/Link.php:113 (__construct) [id: 761] /classes/Link.php:113 (__construct) [id: 617] /modules/cdc_googletagmanager/services/Gtm_Product.php:164 (__construct) [id: 289] /modules/cdc_googletagmanager/services/Gtm_Product.php:164 (__construct) [id: 616] /modules/cdc_googletagmanager/services/Gtm_Product.php:164 (__construct) [id: 88] /modules/cdc_googletagmanager/services/Gtm_Product.php:164 (__construct) [id: 52] /modules/cdc_googletagmanager/services/Gtm_Product.php:164 (__construct) [id: 145] /modules/cdc_googletagmanager/services/Gtm_Product.php:164 (__construct) [id: 675] /modules/cdc_googletagmanager/services/Gtm_Product.php:164 (__construct) [id: 530] /modules/cdc_googletagmanager/services/Gtm_Product.php:164 (__construct) [id: 668] /modules/cdc_googletagmanager/services/Gtm_Product.php:164 (__construct) [id: 386] /modules/cdc_googletagmanager/services/Gtm_Product.php:164 (__construct) [id: 341] /modules/cdc_googletagmanager/services/Gtm_Product.php:164 (__construct) [id: 761] /modules/cdc_googletagmanager/services/Gtm_Product.php:164 (__construct) [id: 617] /classes/Link.php:113 (__construct) [id: 799] /classes/Link.php:113 (__construct) [id: 798] /classes/Link.php:113 (__construct) [id: 788] /classes/Link.php:113 (__construct) [id: 783] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 799] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 798] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 797] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 788] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 783] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 799] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 798] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 797] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 788] /classes/Link.php:113 (__construct) [id: 220] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 543] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 389] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 220] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 321] /classes/Link.php:113 (__construct) [id: 111] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 750] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 413] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 111] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 210] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 281] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 300] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 347] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 136]
Country	19	/config/config.inc.php:146 (__construct) [id: 8] /modules/gmerchantcenter/lib/moduleTools.php:188 (__construct) [id: 8] /modules/gmerchantcenter/lib/moduleTools.php:188 (__construct) [id: 8] /modules/gmerchantcenter/lib/moduleTools.php:188 (__construct) [id: 8] /modules/gmerchantcenter/lib/moduleTools.php:188 (__construct) [id: 8] /modules/gmerchantcenter/lib/moduleTools.php:188 (__construct) [id: 8] /modules/gmerchantcenter/lib/moduleTools.php:188 (__construct) [id: 8] /modules/gmerchantcenter/lib/moduleTools.php:188 (__construct) [id: 8] /modules/gmerchantcenter/lib/moduleTools.php:188 (__construct) [id: 19] /modules/gmerchantcenter/lib/moduleTools.php:188 (__construct) [id: 4] /modules/gmerchantcenter/lib/moduleTools.php:188 (__construct) [id: 3] /modules/gmerchantcenter/lib/moduleTools.php:188 (__construct) [id: 188] /classes/controller/FrontController.php:354 (__construct) [id: 8] /classes/AddressFormat.php:404 (__construct) [id: 8] /classes/controller/FrontController.php:1779 (__construct) [id: 8] /classes/AddressFormat.php:404 (__construct) [id: 8] /modules/ps_contactinfo/ps_contactinfo.php:104 (__construct) [id: 8] /classes/AddressFormat.php:404 (__construct) [id: 8] /modules/ps_contactinfo/ps_contactinfo.php:104 (__construct) [id: 8]
Language	13	/config/config.inc.php:211 (__construct) [id: 1] /classes/Tools.php:560 (__construct) [id: 1] /modules/gmerchantcenter/lib/moduleTools.php:183 (__construct) [id: 1] /modules/gmerchantcenter/lib/moduleTools.php:183 (__construct) [id: 1] /modules/gmerchantcenter/lib/moduleTools.php:183 (__construct) [id: 1] /modules/gmerchantcenter/lib/moduleTools.php:183 (__construct) [id: 1] /modules/gmerchantcenter/lib/moduleTools.php:183 (__construct) [id: 1] /modules/gmerchantcenter/lib/moduleTools.php:183 (__construct) [id: 1] /modules/gmerchantcenter/lib/moduleTools.php:183 (__construct) [id: 1] /modules/gmerchantcenter/lib/moduleTools.php:183 (__construct) [id: 1] /modules/gmerchantcenter/lib/moduleTools.php:183 (__construct) [id: 1] /modules/gmerchantcenter/lib/moduleTools.php:183 (__construct) [id: 1] /modules/gmerchantcenter/lib/moduleTools.php:183 (__construct) [id: 1]
Currency	10	/modules/gmerchantcenter/lib/moduleTools.php:193 (__construct) [id: 1] /modules/gmerchantcenter/lib/moduleTools.php:193 (__construct) [id: 0] /modules/gmerchantcenter/lib/moduleTools.php:193 (__construct) [id: 0] /modules/gmerchantcenter/lib/moduleTools.php:193 (__construct) [id: 0] /modules/gmerchantcenter/lib/moduleTools.php:193 (__construct) [id: 0] /modules/gmerchantcenter/lib/moduleTools.php:193 (__construct) [id: 0] /modules/gmerchantcenter/lib/moduleTools.php:193 (__construct) [id: 0] /modules/gmerchantcenter/lib/moduleTools.php:193 (__construct) [id: 1] /src/Adapter/Currency/CurrencyDataProvider.php:101 (__construct) [id: 1] /classes/Tools.php:695 (getCurrencyInstance) [id: 1]
Combination	5	/classes/Product.php:5912 (__construct) [id: 54] /classes/Product.php:5912 (__construct) [id: 56] /modules/cdc_googletagmanager/classes/gtm/DataLayerItem.php:72 (__construct) [id: 54] /modules/cdc_googletagmanager/classes/gtm/DataLayerItem.php:72 (__construct) [id: 56] /classes/Product.php:5912 (__construct) [id: 37]
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: ]
State	3	/classes/controller/FrontController.php:1778 (__construct) [id: 0] /modules/ps_contactinfo/ps_contactinfo.php:93 (__construct) [id: 0] /modules/ps_contactinfo/ps_contactinfo.php:93 (__construct) [id: 0]
AddressFormat	3	/classes/controller/FrontController.php:1773 (generateAddress) [id: ] /modules/ps_contactinfo/ps_contactinfo.php:98 (generateAddress) [id: ] /modules/ps_contactinfo/ps_contactinfo.php:98 (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: ]
Shop	1	/config/config.inc.php:117 (initialize) [id: 1]
Image	1	/modules/alma/lib/Services/ImageService.php:46 (__construct) [id: ]
Gender	1	/classes/controller/FrontController.php:1702 (__construct) [id: 0]
Risk	1	/classes/controller/FrontController.php:1705 (__construct) [id: ]
Group	1	/classes/Cart.php:249 (getCurrent) [id: 1]
Customer	1	/config/config.inc.php:264 (__construct) [id: ]
ShopGroup	1	/classes/shop/Shop.php:561 (__construct) [id: 1]
TvcmsMegaMenuClass	1	/modules/tvcmsmegamenu/tvcmsmegamenu.php:1384 (__construct) [id: ]

#	Query	Time (ms)	Rows	Filesort	Group By	Location
2166	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("2024-11-11 00:00:00", INTERVAL 1000 DAY)) > 0 AS new FROM `pre2469_product_sale` ps LEFT JOIN `pre2469_product` p ON ps.`id_product` = p.`id_product` LEFT JOIN pre2469_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) LEFT JOIN `pre2469_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 `pre2469_product_lang` pl ON p.`id_product` = pl.`id_product` AND pl.`id_lang` = 1 AND pl.id_shop = 1 LEFT JOIN `pre2469_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 `pre2469_image_lang` il ON (image_shop.`id_image` = il.`id_image` AND il.`id_lang` = 1) LEFT JOIN `pre2469_manufacturer` m ON (m.`id_manufacturer` = p.`id_manufacturer`) LEFT JOIN `pre2469_tax_rule` tr ON (product_shop.`id_tax_rules_group` = tr.`id_tax_rules_group`) AND tr.`id_country` = 8 AND tr.`id_state` = 0 LEFT JOIN `pre2469_tax` t ON (t.`id_tax` = tr.`id_tax`) LEFT JOIN pre2469_stock_available stock ON (stock.id_product = `p`.id_product AND stock.id_product_attribute = 0 AND stock.id_shop = 1 AND stock.id_shop_group = 0 ) WHERE product_shop.`active` = 1 AND product_shop.`visibility` != 'none' AND EXISTS(SELECT 1 FROM `pre2469_category_product` cp JOIN `pre2469_category_group` cg ON (cp.id_category = cg.id_category AND cg.`id_group` =1) WHERE cp.`id_product` = p.`id_product`) ORDER BY `sales` DESC LIMIT 0, 4	29.222 ms	575	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:1077 (hookdisplayLeftColumn) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:418 (coreCallHook) /classes/Hook.php:983 (callHookOn) /config/smarty.config.inc.php:201 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/prod/smarty/compile/v1_gardenia_11layouts_layout_left_column_tpl/1a/89/a7/1a89a734d096f5ad14ad4dbb33891e0facb00120_2.file.layout-both-columns.tpl.php:192 (__call) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/v1_gardenia_11layouts_layout_left_column_tpl/1a/89/a7/1a89a734d096f5ad14ad4dbb33891e0facb00120_2.file.layout-both-columns.tpl.php:74 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67293b29f16874_07033251) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/v1_gardenia_11layouts_layout_left_column_tpl/6d/33/66/6d33663adfbf67f07eddb2df7d930f4c5287edb8_2.file.layout-left-column.tpl.php:28 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67293b29efacf3_58320531) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/v1_gardenia_11layouts_layout_left_column_tpl/82/55/0e/82550e22f895f1760ff1e1a0c2d6c8c47e0de299_2.file.product-list.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67293b29eea393_23821434) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/v1_gardenia_11layouts_layout_left_column_tpl/37/3d/2c/373d2ce4c1a83676f8228aca20a47aac483b040b_2.file.category.tpl.php:29 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67293b29ed0a52_43895681) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/controller/FrontController.php: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)
118	SELECT SQL_NO_CACHE fp.id_feature, fp.id_feature_value, 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 pre2469_product p LEFT JOIN pre2469_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN pre2469_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN pre2469_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 pre2469_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN pre2469_category_product cp ON (p.id_product = cp.id_product) INNER JOIN pre2469_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN pre2469_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN pre2469_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=2 AND c.nright<=157 GROUP BY p.id_product) p INNER JOIN pre2469_feature_product fp ON (p.id_product = fp.id_product) WHERE ((fp.id_feature=12)) GROUP BY fp.id_feature_value	27.101 ms	2300	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:855 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:154 (getFeaturesBlock) /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)
504	SELECT SQL_NO_CACHE p., product_shop., stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, pl.`description`, pl.`description_short`, pl.`available_now`, pl.`available_later`, IFNULL(product_attribute_shop.id_product_attribute, 0) id_product_attribute, pl.`link_rewrite`, pl.`meta_description`, pl.`meta_keywords`, pl.`meta_title`, pl.`name`, image_shop.`id_image` id_image, il.`legend`, m.`name` AS manufacturer_name, DATEDIFF( p.`date_add`, DATE_SUB( "2024-11-11 00:00:00", INTERVAL 1000 DAY ) ) > 0 AS new FROM `pre2469_product` p INNER JOIN pre2469_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) LEFT JOIN `pre2469_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 pre2469_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 `pre2469_product_lang` pl ON ( p.`id_product` = pl.`id_product` AND pl.`id_lang` = 1 AND pl.id_shop = 1 ) LEFT JOIN `pre2469_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 `pre2469_image_lang` il ON (image_shop.`id_image` = il.`id_image` AND il.`id_lang` = 1) LEFT JOIN `pre2469_manufacturer` m ON (m.`id_manufacturer` = p.`id_manufacturer`) WHERE product_shop.`active` = 1 AND product_shop.`show_price` = 1 AND product_shop.`visibility` IN ("both", "catalog") AND p.`id_product` IN (288, 193, 289, 145, 297, 290, 212, 329, 48, 192, 249, 354, 165, 50, 20, 427, 89, 304, 63, 170, 144, 197, 343, 103, 330, 380, 140, 366, 428, 281, 150, 231, 376, 244, 390, 393, 400, 199, 345, 105, 77, 250, 158, 295, 332, 347, 300, 107, 143, 49, 246, 264, 24, 194, 125, 31, 381, 410, 47, 191, 97, 344, 227, 372, 132, 429, 101, 151, 98, 243, 389, 382, 92, 211, 308, 407, 169, 70, 216, 342, 196, 121, 267, 27, 172, 434, 315, 439, 213, 431, 441, 442, 178, 454, 13, 456, 136, 455, 460, 472, 476, 483, 478, 479, 486, 487, 488, 489, 461, 78, 299, 204, 349, 109, 188, 44, 426, 74, 220, 52, 512, 513, 514, 503, 338, 195, 341, 515, 517, 516, 534, 540, 541, 386, 543, 544, 545, 546, 242, 337, 518, 554, 296, 452, 578, 235, 582, 473, 585, 164, 260, 311, 581, 594, 598, 599, 600, 71, 217, 606, 607, 614, 255, 15, 287, 108, 586, 61, 58, 526, 524, 527, 525, 588, 589, 111, 26, 391, 632, 356, 362, 597, 668, 669, 88, 671, 672, 666, 361, 601, 175, 30, 280, 321, 573, 677, 679, 142, 699, 67, 701, 702, 312, 704, 351, 622, 595, 711, 257, 179, 720, 721, 722, 723, 724, 725, 726, 727, 729, 731, 753, 754, 700, 273, 65, 438, 542, 610, 611, 608, 799, 224, 251, 485, 713, 457, 612) AND EXISTS(SELECT 1 FROM `pre2469_category_product` cp JOIN `pre2469_category_group` cg ON (cp.id_category = cg.id_category AND cg.`id_group` =1) WHERE cp.`id_product` = p.`id_product`)	24.555 ms	575			/classes/Product.php:3393 /modules/tvcmstabproducts/tvcmstabproducts.php:2817 (getPricesDrop) /modules/tvcmsspecialproducts/tvcmsspecialproducts.php:157 (displaySpecialProducts) /modules/tvcmsspecialproducts/tvcmsspecialproducts.php:268 (showFrontSideResult) /classes/Hook.php:1077 (hookdisplayLeftColumn) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:418 (coreCallHook) /classes/Hook.php:983 (callHookOn) /config/smarty.config.inc.php:201 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/prod/smarty/compile/v1_gardenia_11layouts_layout_left_column_tpl/1a/89/a7/1a89a734d096f5ad14ad4dbb33891e0facb00120_2.file.layout-both-columns.tpl.php:192 (__call) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/v1_gardenia_11layouts_layout_left_column_tpl/1a/89/a7/1a89a734d096f5ad14ad4dbb33891e0facb00120_2.file.layout-both-columns.tpl.php:74 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67293b29f16874_07033251) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/v1_gardenia_11layouts_layout_left_column_tpl/6d/33/66/6d33663adfbf67f07eddb2df7d930f4c5287edb8_2.file.layout-left-column.tpl.php:28 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67293b29efacf3_58320531) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/v1_gardenia_11layouts_layout_left_column_tpl/82/55/0e/82550e22f895f1760ff1e1a0c2d6c8c47e0de299_2.file.product-list.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67293b29eea393_23821434) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/v1_gardenia_11layouts_layout_left_column_tpl/37/3d/2c/373d2ce4c1a83676f8228aca20a47aac483b040b_2.file.category.tpl.php:29 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67293b29ed0a52_43895681) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/controller/FrontController.php: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)
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 `pre2469_configuration` c LEFT JOIN `pre2469_configuration_lang` cl ON (c.`id_configuration` = cl.`id_configuration`)	16.486 ms	1616			/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)
855	SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`, IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on, product_attribute_shop.`ecotax` AS attribute_ecotax FROM `pre2469_product` p INNER JOIN `pre2469_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1) LEFT JOIN `pre2469_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1) WHERE (p.`id_product` = 178)	15.492 ms	1			/classes/Product.php:3860 /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:1077 (hookdisplayLeftColumn) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:418 (coreCallHook) /classes/Hook.php:983 (callHookOn) /config/smarty.config.inc.php:201 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/prod/smarty/compile/v1_gardenia_11layouts_layout_left_column_tpl/1a/89/a7/1a89a734d096f5ad14ad4dbb33891e0facb00120_2.file.layout-both-columns.tpl.php:192 (__call) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/v1_gardenia_11layouts_layout_left_column_tpl/1a/89/a7/1a89a734d096f5ad14ad4dbb33891e0facb00120_2.file.layout-both-columns.tpl.php:74 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67293b29f16874_07033251) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/v1_gardenia_11layouts_layout_left_column_tpl/6d/33/66/6d33663adfbf67f07eddb2df7d930f4c5287edb8_2.file.layout-left-column.tpl.php:28 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67293b29efacf3_58320531) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/v1_gardenia_11layouts_layout_left_column_tpl/82/55/0e/82550e22f895f1760ff1e1a0c2d6c8c47e0de299_2.file.product-list.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67293b29eea393_23821434) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/v1_gardenia_11layouts_layout_left_column_tpl/37/3d/2c/373d2ce4c1a83676f8228aca20a47aac483b040b_2.file.category.tpl.php:29 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67293b29ed0a52_43895681) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/controller/FrontController.php: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)
1203	SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority` FROM `pre2469_specific_price_priority` WHERE `id_product` = 321 ORDER BY `id_specific_price_priority` DESC LIMIT 1	14.171 ms	1			/classes/SpecificPrice.php:259 /classes/SpecificPrice.php:239 (getPriority) /classes/SpecificPrice.php:565 (_getScoreQuery) /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:1077 (hookdisplayLeftColumn) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:418 (coreCallHook) /classes/Hook.php:983 (callHookOn) /config/smarty.config.inc.php:201 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/prod/smarty/compile/v1_gardenia_11layouts_layout_left_column_tpl/1a/89/a7/1a89a734d096f5ad14ad4dbb33891e0facb00120_2.file.layout-both-columns.tpl.php:192 (__call) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/v1_gardenia_11layouts_layout_left_column_tpl/1a/89/a7/1a89a734d096f5ad14ad4dbb33891e0facb00120_2.file.layout-both-columns.tpl.php:74 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67293b29f16874_07033251) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/v1_gardenia_11layouts_layout_left_column_tpl/6d/33/66/6d33663adfbf67f07eddb2df7d930f4c5287edb8_2.file.layout-left-column.tpl.php:28 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67293b29efacf3_58320531) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/v1_gardenia_11layouts_layout_left_column_tpl/82/55/0e/82550e22f895f1760ff1e1a0c2d6c8c47e0de299_2.file.product-list.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67293b29eea393_23821434) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/v1_gardenia_11layouts_layout_left_column_tpl/37/3d/2c/373d2ce4c1a83676f8228aca20a47aac483b040b_2.file.category.tpl.php:29 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67293b29ed0a52_43895681) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/controller/FrontController.php: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)
2178	SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity, COALESCE(SUM(first_level_quantity), 0) as quantity FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity FROM `pre2469_cart_product` cp WHERE cp.`id_product_attribute` = 0 AND cp.`id_cart` = 0 AND cp.`id_product` = 300 UNION SELECT 0 as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity FROM `pre2469_cart_product` cp JOIN `pre2469_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `pre2469_product` pr ON p.`id_product_pack` = pr.`id_product` WHERE cp.`id_product_attribute` = 0 AND cp.`id_cart` = 0 AND p.`id_product_item` = 300 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1	13.169 ms	0			/classes/Cart.php:1430 /classes/Product.php:4361 (getProductQuantity) /classes/Product.php:5802 (getQuantity) /classes/Product.php:5990 (getProductProperties) /classes/ProductSale.php:161 (getProductsProperties) /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:1077 (hookdisplayLeftColumn) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:418 (coreCallHook) /classes/Hook.php:983 (callHookOn) /config/smarty.config.inc.php:201 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/prod/smarty/compile/v1_gardenia_11layouts_layout_left_column_tpl/1a/89/a7/1a89a734d096f5ad14ad4dbb33891e0facb00120_2.file.layout-both-columns.tpl.php:192 (__call) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/v1_gardenia_11layouts_layout_left_column_tpl/1a/89/a7/1a89a734d096f5ad14ad4dbb33891e0facb00120_2.file.layout-both-columns.tpl.php:74 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67293b29f16874_07033251) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/v1_gardenia_11layouts_layout_left_column_tpl/6d/33/66/6d33663adfbf67f07eddb2df7d930f4c5287edb8_2.file.layout-left-column.tpl.php:28 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67293b29efacf3_58320531) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/v1_gardenia_11layouts_layout_left_column_tpl/82/55/0e/82550e22f895f1760ff1e1a0c2d6c8c47e0de299_2.file.product-list.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67293b29eea393_23821434) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/v1_gardenia_11layouts_layout_left_column_tpl/37/3d/2c/373d2ce4c1a83676f8228aca20a47aac483b040b_2.file.category.tpl.php:29 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67293b29ed0a52_43895681) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/controller/FrontController.php: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)
60	SELECT SQL_NO_CACHE * FROM `pre2469_hook` h ORDER BY `name`	10.133 ms	1044	Yes		/classes/Hook.php:191 /modules/alma/lib/Helpers/HookHelper.php:43 (getHooks) /modules/alma/alma.php:122 (__construct) :undefined (__construct) /src/Core/Foundation/IoC/Container.php:123 (newInstance) /src/Core/Foundation/IoC/Container.php:153 (makeInstanceFromClassName) /src/Core/Foundation/IoC/Container.php:166 (doMake) /src/Adapter/ServiceLocator.php:70 (make) /classes/module/Module.php:1258 (get) /tools/profiling/Module.php:35 (coreLoadModule) /classes/module/Module.php:1237 (coreLoadModule) /classes/Hook.php:966 (getInstanceByName) /classes/Dispatcher.php:606 (exec) /classes/Dispatcher.php:243 (loadRoutes) /classes/Dispatcher.php:201 (__construct) /index.php:28 (getInstance)
1726	SELECT SQL_NO_CACHE 1 FROM `pre2469_specific_price` WHERE id_product = 545 LIMIT 1	9.923 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:1077 (hookdisplayLeftColumn) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:418 (coreCallHook) /classes/Hook.php:983 (callHookOn) /config/smarty.config.inc.php:201 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/prod/smarty/compile/v1_gardenia_11layouts_layout_left_column_tpl/1a/89/a7/1a89a734d096f5ad14ad4dbb33891e0facb00120_2.file.layout-both-columns.tpl.php:192 (__call) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/v1_gardenia_11layouts_layout_left_column_tpl/1a/89/a7/1a89a734d096f5ad14ad4dbb33891e0facb00120_2.file.layout-both-columns.tpl.php:74 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67293b29f16874_07033251) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/v1_gardenia_11layouts_layout_left_column_tpl/6d/33/66/6d33663adfbf67f07eddb2df7d930f4c5287edb8_2.file.layout-left-column.tpl.php:28 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67293b29efacf3_58320531) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/v1_gardenia_11layouts_layout_left_column_tpl/82/55/0e/82550e22f895f1760ff1e1a0c2d6c8c47e0de299_2.file.product-list.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67293b29eea393_23821434) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/v1_gardenia_11layouts_layout_left_column_tpl/37/3d/2c/373d2ce4c1a83676f8228aca20a47aac483b040b_2.file.category.tpl.php:29 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67293b29ed0a52_43895681) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/controller/FrontController.php: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)
456	SELECT SQL_NO_CACHE count(id_wishlist_product) FROM pre2469_wishlist w, pre2469_wishlist_product wp where w.id_wishlist = wp.id_wishlist and w.id_customer=0 LIMIT 1	9.175 ms	4			/modules/tvcmswishlist/tvcmswishlist.php:278 /modules/tvcmswishlist/tvcmswishlist.php:223 (headerData) /classes/Hook.php:1077 (hookdisplayNavWishlistBlock) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:418 (coreCallHook) /classes/Hook.php:983 (callHookOn) /config/smarty.config.inc.php:201 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/prod/smarty/compile/v1_gardenia_11layouts_layout_left_column_tpl/bd/95/e2/bd95e28a15f35124d814b1a25c3a08ce78345268_2.file.desk-header-7.tpl.php:28 (__call) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67293b2a281d57_86876041) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /var/cache/prod/smarty/compile/v1_gardenia_11layouts_layout_left_column_tpl/b1/6f/68/b16f68e6bb922534b635e7fa572aee543e9fb07a_2.file.desktop-header.tpl.php:25 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67293b2a270919_32767377) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /var/cache/prod/smarty/compile/v1_gardenia_11layouts_layout_left_column_tpl/f7/f8/6b/f7f86be97cfdbafa2735d8030700d58f00d21d2a_2.file.header.tpl.php:55 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/v1_gardenia_11layouts_layout_left_column_tpl/f7/f8/6b/f7f86be97cfdbafa2735d8030700d58f00d21d2a_2.file.header.tpl.php:29 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67293b2a2643b7_90860613) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /var/cache/prod/smarty/compile/v1_gardenia_11layouts_layout_left_column_tpl/1a/89/a7/1a89a734d096f5ad14ad4dbb33891e0facb00120_2.file.layout-both-columns.tpl.php:144 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/v1_gardenia_11layouts_layout_left_column_tpl/1a/89/a7/1a89a734d096f5ad14ad4dbb33891e0facb00120_2.file.layout-both-columns.tpl.php:64 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67293b29f16874_07033251) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/v1_gardenia_11layouts_layout_left_column_tpl/6d/33/66/6d33663adfbf67f07eddb2df7d930f4c5287edb8_2.file.layout-left-column.tpl.php:28 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67293b29efacf3_58320531) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/v1_gardenia_11layouts_layout_left_column_tpl/82/55/0e/82550e22f895f1760ff1e1a0c2d6c8c47e0de299_2.file.product-list.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67293b29eea393_23821434) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/v1_gardenia_11layouts_layout_left_column_tpl/37/3d/2c/373d2ce4c1a83676f8228aca20a47aac483b040b_2.file.category.tpl.php:29 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67293b29ed0a52_43895681) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/controller/FrontController.php: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)
434	SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity, COALESCE(SUM(first_level_quantity), 0) as quantity FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity FROM `pre2469_cart_product` cp WHERE cp.`id_product_attribute` = 0 AND cp.`id_cart` = 0 AND cp.`id_product` = 783 UNION SELECT 0 as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity FROM `pre2469_cart_product` cp JOIN `pre2469_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `pre2469_product` pr ON p.`id_product_pack` = pr.`id_product` WHERE cp.`id_product_attribute` = 0 AND cp.`id_cart` = 0 AND p.`id_product_item` = 783 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1	8.779 ms	0			/classes/Cart.php:1430 /classes/Product.php:4361 (getProductQuantity) /classes/Product.php:5802 (getQuantity) /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:1077 (hookdisplayAfterBodyOpeningTag) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:418 (coreCallHook) /classes/Hook.php:983 (callHookOn) /config/smarty.config.inc.php:201 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/prod/smarty/compile/v1_gardenia_11layouts_layout_left_column_tpl/1a/89/a7/1a89a734d096f5ad14ad4dbb33891e0facb00120_2.file.layout-both-columns.tpl.php:116 (__call) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/v1_gardenia_11layouts_layout_left_column_tpl/1a/89/a7/1a89a734d096f5ad14ad4dbb33891e0facb00120_2.file.layout-both-columns.tpl.php:54 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67293b29f16874_07033251) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/v1_gardenia_11layouts_layout_left_column_tpl/6d/33/66/6d33663adfbf67f07eddb2df7d930f4c5287edb8_2.file.layout-left-column.tpl.php:28 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67293b29efacf3_58320531) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/v1_gardenia_11layouts_layout_left_column_tpl/82/55/0e/82550e22f895f1760ff1e1a0c2d6c8c47e0de299_2.file.product-list.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67293b29eea393_23821434) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/v1_gardenia_11layouts_layout_left_column_tpl/37/3d/2c/373d2ce4c1a83676f8228aca20a47aac483b040b_2.file.category.tpl.php:29 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67293b29ed0a52_43895681) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/controller/FrontController.php: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)
1869	SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) + IF (`id_country` = 8, 4, 0) + IF (`id_currency` = 1, 8, 0) + IF (`id_shop` = 1, 16, 0) + IF (`id_customer` = 0, 32, 0)) AS `score` FROM `pre2469_specific_price` WHERE `id_shop` IN (0, 1) AND `id_currency` IN (0, 1) AND `id_country` IN (0, 8) AND `id_group` IN (0, 1) AND `id_product` = 611 AND `id_customer` = 0 AND `id_product_attribute` IN (0, 58) AND `id_cart` = 0 AND (`from` = '0000-00-00 00:00:00' OR '2024-11-11 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-11-11 00:00:00' <= `to`) AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1	8.725 ms	2	Yes		/classes/SpecificPrice.php:576 /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:1077 (hookdisplayLeftColumn) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:418 (coreCallHook) /classes/Hook.php:983 (callHookOn) /config/smarty.config.inc.php:201 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/prod/smarty/compile/v1_gardenia_11layouts_layout_left_column_tpl/1a/89/a7/1a89a734d096f5ad14ad4dbb33891e0facb00120_2.file.layout-both-columns.tpl.php:192 (__call) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/v1_gardenia_11layouts_layout_left_column_tpl/1a/89/a7/1a89a734d096f5ad14ad4dbb33891e0facb00120_2.file.layout-both-columns.tpl.php:74 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67293b29f16874_07033251) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/v1_gardenia_11layouts_layout_left_column_tpl/6d/33/66/6d33663adfbf67f07eddb2df7d930f4c5287edb8_2.file.layout-left-column.tpl.php:28 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67293b29efacf3_58320531) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/v1_gardenia_11layouts_layout_left_column_tpl/82/55/0e/82550e22f895f1760ff1e1a0c2d6c8c47e0de299_2.file.product-list.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67293b29eea393_23821434) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/v1_gardenia_11layouts_layout_left_column_tpl/37/3d/2c/373d2ce4c1a83676f8228aca20a47aac483b040b_2.file.category.tpl.php:29 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67293b29ed0a52_43895681) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/controller/FrontController.php: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)
2196	SELECT SQL_NO_CACHE p., ps., pl.*, sa.out_of_stock, IFNULL(sa.quantity, 0) as quantity, (DATEDIFF( p.`date_add`, DATE_SUB( '2024-11-11 00:00:00', INTERVAL 1000 DAY ) ) > 0) as new FROM pre2469_product p LEFT JOIN pre2469_product_lang pl ON pl.id_product = p.id_product AND pl.id_shop = 1 AND pl.id_lang = 1 LEFT JOIN pre2469_stock_available sa ON sa.id_product = p.id_product AND sa.id_product_attribute = 0 AND sa.id_shop = 1 LEFT JOIN pre2469_product_shop ps ON ps.id_product = p.id_product AND ps.id_shop = 1 WHERE p.id_product IN (300)	8.425 ms	1			/classes/ProductAssembler.php:64 /classes/ProductAssembler.php:182 (addMissingProductFields) /modules/tvcmstabproducts/tvcmstabproducts.php:2912 (assembleProduct) /modules/tvcmsbestsellerproducts/tvcmsbestsellerproducts.php:156 (displayBestSellers) /modules/tvcmsbestsellerproducts/tvcmsbestsellerproducts.php:269 (showFrontSideResult) /classes/Hook.php:1077 (hookdisplayLeftColumn) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:418 (coreCallHook) /classes/Hook.php:983 (callHookOn) /config/smarty.config.inc.php:201 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/prod/smarty/compile/v1_gardenia_11layouts_layout_left_column_tpl/1a/89/a7/1a89a734d096f5ad14ad4dbb33891e0facb00120_2.file.layout-both-columns.tpl.php:192 (__call) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/v1_gardenia_11layouts_layout_left_column_tpl/1a/89/a7/1a89a734d096f5ad14ad4dbb33891e0facb00120_2.file.layout-both-columns.tpl.php:74 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67293b29f16874_07033251) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/v1_gardenia_11layouts_layout_left_column_tpl/6d/33/66/6d33663adfbf67f07eddb2df7d930f4c5287edb8_2.file.layout-left-column.tpl.php:28 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67293b29efacf3_58320531) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/v1_gardenia_11layouts_layout_left_column_tpl/82/55/0e/82550e22f895f1760ff1e1a0c2d6c8c47e0de299_2.file.product-list.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67293b29eea393_23821434) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/v1_gardenia_11layouts_layout_left_column_tpl/37/3d/2c/373d2ce4c1a83676f8228aca20a47aac483b040b_2.file.category.tpl.php:29 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67293b29ed0a52_43895681) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/controller/FrontController.php: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)
1738	SELECT SQL_NO_CACHE `reduction` FROM `pre2469_product_group_reduction_cache` WHERE `id_product` = 546 AND `id_group` = 1 LIMIT 1	8.399 ms	0			/classes/GroupReduction.php:156 /classes/Product.php:3990 (getValueForProduct) /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:1077 (hookdisplayLeftColumn) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:418 (coreCallHook) /classes/Hook.php:983 (callHookOn) /config/smarty.config.inc.php:201 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/prod/smarty/compile/v1_gardenia_11layouts_layout_left_column_tpl/1a/89/a7/1a89a734d096f5ad14ad4dbb33891e0facb00120_2.file.layout-both-columns.tpl.php:192 (__call) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/v1_gardenia_11layouts_layout_left_column_tpl/1a/89/a7/1a89a734d096f5ad14ad4dbb33891e0facb00120_2.file.layout-both-columns.tpl.php:74 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67293b29f16874_07033251) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/v1_gardenia_11layouts_layout_left_column_tpl/6d/33/66/6d33663adfbf67f07eddb2df7d930f4c5287edb8_2.file.layout-left-column.tpl.php:28 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67293b29efacf3_58320531) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/v1_gardenia_11layouts_layout_left_column_tpl/82/55/0e/82550e22f895f1760ff1e1a0c2d6c8c47e0de299_2.file.product-list.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67293b29eea393_23821434) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/v1_gardenia_11layouts_layout_left_column_tpl/37/3d/2c/373d2ce4c1a83676f8228aca20a47aac483b040b_2.file.category.tpl.php:29 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67293b29ed0a52_43895681) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/controller/FrontController.php: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)
1799	SELECT SQL_NO_CACHE `reduction` FROM `pre2469_product_group_reduction_cache` WHERE `id_product` = 594 AND `id_group` = 1 LIMIT 1	7.449 ms	0			/classes/GroupReduction.php:156 /classes/Product.php:3990 (getValueForProduct) /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:1077 (hookdisplayLeftColumn) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:418 (coreCallHook) /classes/Hook.php:983 (callHookOn) /config/smarty.config.inc.php:201 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/prod/smarty/compile/v1_gardenia_11layouts_layout_left_column_tpl/1a/89/a7/1a89a734d096f5ad14ad4dbb33891e0facb00120_2.file.layout-both-columns.tpl.php:192 (__call) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/v1_gardenia_11layouts_layout_left_column_tpl/1a/89/a7/1a89a734d096f5ad14ad4dbb33891e0facb00120_2.file.layout-both-columns.tpl.php:74 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67293b29f16874_07033251) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/v1_gardenia_11layouts_layout_left_column_tpl/6d/33/66/6d33663adfbf67f07eddb2df7d930f4c5287edb8_2.file.layout-left-column.tpl.php:28 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67293b29efacf3_58320531) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/v1_gardenia_11layouts_layout_left_column_tpl/82/55/0e/82550e22f895f1760ff1e1a0c2d6c8c47e0de299_2.file.product-list.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67293b29eea393_23821434) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/v1_gardenia_11layouts_layout_left_column_tpl/37/3d/2c/373d2ce4c1a83676f8228aca20a47aac483b040b_2.file.category.tpl.php:29 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67293b29ed0a52_43895681) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/controller/FrontController.php: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)
109	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 pre2469_product p LEFT JOIN pre2469_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN pre2469_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN pre2469_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 pre2469_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN pre2469_category_product cp ON (p.id_product = cp.id_product) INNER JOIN pre2469_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN pre2469_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN pre2469_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN pre2469_feature_product fp ON (p.id_product = fp.id_product) WHERE ((fp.id_feature_value IN (21887, 21888, 20992, 21167, 14661))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=2 AND c.nright<=157 GROUP BY p.id_product) p INNER JOIN pre2469_category_product cp ON (p.id_product = cp.id_product) GROUP BY p.id_product ORDER BY p.position ASC, p.id_product DESC	7.122 ms	88	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)
482	SELECT SQL_NO_CACHE `need_identification_number` FROM `pre2469_country` WHERE `id_country` = 8 LIMIT 1	6.959 ms	1			/classes/Country.php:405 /classes/AddressFormat.php:634 (isNeedDniByCountryId) /classes/AddressFormat.php:615 (getFormat) /classes/AddressFormat.php:562 (getAddressCountryFormat) /classes/AddressFormat.php:438 (getOrderedAddressFields) /modules/ps_contactinfo/ps_contactinfo.php:98 (generateAddress) /modules/ps_contactinfo/ps_contactinfo.php:83 (getWidgetVariables) /classes/Hook.php:1088 (renderWidget) /tools/profiling/Hook.php:64 (coreRenderWidget) /classes/Hook.php:1019 (coreRenderWidget) /config/smarty.config.inc.php:201 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/prod/smarty/compile/v1_gardenia_11layouts_layout_left_column_tpl/bd/95/e2/bd95e28a15f35124d814b1a25c3a08ce78345268_2.file.desk-header-7.tpl.php:52 (__call) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67293b2a281d57_86876041) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /var/cache/prod/smarty/compile/v1_gardenia_11layouts_layout_left_column_tpl/b1/6f/68/b16f68e6bb922534b635e7fa572aee543e9fb07a_2.file.desktop-header.tpl.php:25 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67293b2a270919_32767377) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /var/cache/prod/smarty/compile/v1_gardenia_11layouts_layout_left_column_tpl/f7/f8/6b/f7f86be97cfdbafa2735d8030700d58f00d21d2a_2.file.header.tpl.php:55 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/v1_gardenia_11layouts_layout_left_column_tpl/f7/f8/6b/f7f86be97cfdbafa2735d8030700d58f00d21d2a_2.file.header.tpl.php:29 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67293b2a2643b7_90860613) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /var/cache/prod/smarty/compile/v1_gardenia_11layouts_layout_left_column_tpl/1a/89/a7/1a89a734d096f5ad14ad4dbb33891e0facb00120_2.file.layout-both-columns.tpl.php:144 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/v1_gardenia_11layouts_layout_left_column_tpl/1a/89/a7/1a89a734d096f5ad14ad4dbb33891e0facb00120_2.file.layout-both-columns.tpl.php:64 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67293b29f16874_07033251) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/v1_gardenia_11layouts_layout_left_column_tpl/6d/33/66/6d33663adfbf67f07eddb2df7d930f4c5287edb8_2.file.layout-left-column.tpl.php:28 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67293b29efacf3_58320531) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/v1_gardenia_11layouts_layout_left_column_tpl/82/55/0e/82550e22f895f1760ff1e1a0c2d6c8c47e0de299_2.file.product-list.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67293b29eea393_23821434) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/v1_gardenia_11layouts_layout_left_column_tpl/37/3d/2c/373d2ce4c1a83676f8228aca20a47aac483b040b_2.file.category.tpl.php:29 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67293b29ed0a52_43895681) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/controller/FrontController.php: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)
112	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 pre2469_product p LEFT JOIN pre2469_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN pre2469_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN pre2469_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 pre2469_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN pre2469_category_product cp ON (p.id_product = cp.id_product) INNER JOIN pre2469_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN pre2469_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN pre2469_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN pre2469_feature_product fp ON (p.id_product = fp.id_product) WHERE ((fp.id_feature_value IN (21887, 21888, 20992, 21167, 14661))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=2 AND c.nright<=157 GROUP BY p.id_product) p INNER JOIN pre2469_category_product cp ON (p.id_product = cp.id_product) INNER JOIN pre2469_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN pre2469_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN pre2469_feature_product fp ON (p.id_product = fp.id_product) WHERE ((fp.id_feature_value IN (21887, 21888, 20992, 21167, 14661))) AND cg.id_group='1' AND c.nleft>2 AND c.nright<157 GROUP BY cp.id_category	6.835 ms	352	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)
13	SELECT SQL_NO_CACHE h.`name` as hook, m.`id_module`, h.`id_hook`, m.`name` as module FROM `pre2469_module` m INNER JOIN pre2469_module_shop module_shop ON (module_shop.id_module = m.id_module AND module_shop.id_shop = 1 AND module_shop.enable_device & 1) INNER JOIN `pre2469_hook_module` `hm` ON hm.`id_module` = m.`id_module` INNER JOIN `pre2469_hook` `h` ON hm.`id_hook` = h.`id_hook` LEFT JOIN `pre2469_module_group` `mg` ON mg.`id_module` = m.`id_module` WHERE (h.`name` != "paymentOptions") AND (hm.`id_shop` = 1) AND (mg.id_shop = 1 AND mg.`id_group` IN (1)) GROUP BY hm.id_hook, hm.id_module ORDER BY hm.`position`	6.612 ms	2145	Yes	Yes	/classes/Hook.php:1267 /classes/Hook.php:735 (getAllHookRegistrations) /classes/Hook.php:842 (getHookModuleExecList) /classes/Dispatcher.php:606 (exec) /classes/Dispatcher.php:243 (loadRoutes) /classes/Dispatcher.php:201 (__construct) /index.php:28 (getInstance)
122	SELECT SQL_NO_CACHE fp.id_feature, fp.id_feature_value, 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 pre2469_product p LEFT JOIN pre2469_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN pre2469_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN pre2469_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 pre2469_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN pre2469_category_product cp ON (p.id_product = cp.id_product) INNER JOIN pre2469_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN pre2469_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN pre2469_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN pre2469_feature_product fp ON (p.id_product = fp.id_product) WHERE ((fp.id_feature_value IN (21887, 21888, 20992, 21167, 14661))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=2 AND c.nright<=157 GROUP BY p.id_product) p INNER JOIN pre2469_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN pre2469_feature_product fp_1 ON (p.id_product = fp_1.id_product) WHERE ((fp.id_feature=14)) AND ((fp_1.id_feature_value IN (21887, 21888, 20992, 21167, 14661))) GROUP BY fp.id_feature_value	6.106 ms	352	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:855 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:154 (getFeaturesBlock) /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)
2147	SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity, COALESCE(SUM(first_level_quantity), 0) as quantity FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity FROM `pre2469_cart_product` cp WHERE cp.`id_product_attribute` = 0 AND cp.`id_cart` = 0 AND cp.`id_product` = 210 UNION SELECT 0 as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity FROM `pre2469_cart_product` cp JOIN `pre2469_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `pre2469_product` pr ON p.`id_product_pack` = pr.`id_product` WHERE cp.`id_product_attribute` = 0 AND cp.`id_cart` = 0 AND p.`id_product_item` = 210 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1	5.780 ms	0			/classes/Cart.php:1430 /classes/Product.php:4361 (getProductQuantity) /classes/Product.php:5802 (getQuantity) /classes/Product.php:5990 (getProductProperties) /classes/Category.php:1074 (getProductsProperties) /src/Adapter/Category/CategoryProductSearchProvider.php:79 (getProducts) /src/Adapter/Category/CategoryProductSearchProvider.php:105 (getProductsOrCount) /modules/tvcmstabproducts/tvcmstabproducts.php:2708 (runQuery) /modules/tvcmsfeaturedproducts/tvcmsfeaturedproducts.php:158 (displayFeaturedProducts) /modules/tvcmsfeaturedproducts/tvcmsfeaturedproducts.php:281 (showFrontSideResult) /classes/Hook.php:1077 (hookdisplayLeftColumn) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:418 (coreCallHook) /classes/Hook.php:983 (callHookOn) /config/smarty.config.inc.php:201 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/prod/smarty/compile/v1_gardenia_11layouts_layout_left_column_tpl/1a/89/a7/1a89a734d096f5ad14ad4dbb33891e0facb00120_2.file.layout-both-columns.tpl.php:192 (__call) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/v1_gardenia_11layouts_layout_left_column_tpl/1a/89/a7/1a89a734d096f5ad14ad4dbb33891e0facb00120_2.file.layout-both-columns.tpl.php:74 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67293b29f16874_07033251) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/v1_gardenia_11layouts_layout_left_column_tpl/6d/33/66/6d33663adfbf67f07eddb2df7d930f4c5287edb8_2.file.layout-left-column.tpl.php:28 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67293b29efacf3_58320531) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/v1_gardenia_11layouts_layout_left_column_tpl/82/55/0e/82550e22f895f1760ff1e1a0c2d6c8c47e0de299_2.file.product-list.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67293b29eea393_23821434) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/v1_gardenia_11layouts_layout_left_column_tpl/37/3d/2c/373d2ce4c1a83676f8228aca20a47aac483b040b_2.file.category.tpl.php:29 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67293b29ed0a52_43895681) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/controller/FrontController.php: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)
116	SELECT SQL_NO_CACHE fp.id_feature, fp.id_feature_value, 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 pre2469_product p LEFT JOIN pre2469_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN pre2469_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN pre2469_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 pre2469_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN pre2469_category_product cp ON (p.id_product = cp.id_product) INNER JOIN pre2469_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN pre2469_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN pre2469_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN pre2469_feature_product fp ON (p.id_product = fp.id_product) WHERE ((fp.id_feature_value IN (21887, 21888, 20992, 21167, 14661))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=2 AND c.nright<=157 GROUP BY p.id_product) p INNER JOIN pre2469_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN pre2469_feature_product fp_1 ON (p.id_product = fp_1.id_product) WHERE ((fp.id_feature=11)) AND ((fp_1.id_feature_value IN (21887, 21888, 20992, 21167, 14661))) GROUP BY fp.id_feature_value	5.735 ms	352	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:855 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:154 (getFeaturesBlock) /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)
414	SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position, fvl.id_feature_value FROM pre2469_feature_product pf LEFT JOIN pre2469_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1) LEFT JOIN pre2469_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1) LEFT JOIN pre2469_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1) INNER JOIN pre2469_feature_shop feature_shop ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1) WHERE pf.id_product = 797 ORDER BY f.position ASC	5.577 ms	1	Yes		/classes/Product.php:6021 /classes/Product.php:5824 (getFrontFeaturesStatic) /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:1077 (hookdisplayAfterBodyOpeningTag) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:418 (coreCallHook) /classes/Hook.php:983 (callHookOn) /config/smarty.config.inc.php:201 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/prod/smarty/compile/v1_gardenia_11layouts_layout_left_column_tpl/1a/89/a7/1a89a734d096f5ad14ad4dbb33891e0facb00120_2.file.layout-both-columns.tpl.php:116 (__call) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/v1_gardenia_11layouts_layout_left_column_tpl/1a/89/a7/1a89a734d096f5ad14ad4dbb33891e0facb00120_2.file.layout-both-columns.tpl.php:54 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67293b29f16874_07033251) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/v1_gardenia_11layouts_layout_left_column_tpl/6d/33/66/6d33663adfbf67f07eddb2df7d930f4c5287edb8_2.file.layout-left-column.tpl.php:28 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67293b29efacf3_58320531) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/v1_gardenia_11layouts_layout_left_column_tpl/82/55/0e/82550e22f895f1760ff1e1a0c2d6c8c47e0de299_2.file.product-list.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67293b29eea393_23821434) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/v1_gardenia_11layouts_layout_left_column_tpl/37/3d/2c/373d2ce4c1a83676f8228aca20a47aac483b040b_2.file.category.tpl.php:29 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67293b29ed0a52_43895681) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/controller/FrontController.php: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)
120	SELECT SQL_NO_CACHE fp.id_feature, fp.id_feature_value, 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 pre2469_product p LEFT JOIN pre2469_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN pre2469_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN pre2469_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 pre2469_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN pre2469_category_product cp ON (p.id_product = cp.id_product) INNER JOIN pre2469_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN pre2469_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN pre2469_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN pre2469_feature_product fp ON (p.id_product = fp.id_product) WHERE ((fp.id_feature_value IN (21887, 21888, 20992, 21167, 14661))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=2 AND c.nright<=157 GROUP BY p.id_product) p INNER JOIN pre2469_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN pre2469_feature_product fp_1 ON (p.id_product = fp_1.id_product) WHERE ((fp.id_feature=13)) AND ((fp_1.id_feature_value IN (21887, 21888, 20992, 21167, 14661))) GROUP BY fp.id_feature_value	5.506 ms	352	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:855 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:154 (getFeaturesBlock) /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)
126	SELECT SQL_NO_CACHE fp.id_feature, fp.id_feature_value, 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 pre2469_product p LEFT JOIN pre2469_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN pre2469_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN pre2469_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 pre2469_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN pre2469_category_product cp ON (p.id_product = cp.id_product) INNER JOIN pre2469_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN pre2469_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN pre2469_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN pre2469_feature_product fp ON (p.id_product = fp.id_product) WHERE ((fp.id_feature_value IN (21887, 21888, 20992, 21167, 14661))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=2 AND c.nright<=157 GROUP BY p.id_product) p INNER JOIN pre2469_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN pre2469_feature_product fp_1 ON (p.id_product = fp_1.id_product) WHERE ((fp.id_feature=16)) AND ((fp_1.id_feature_value IN (21887, 21888, 20992, 21167, 14661))) GROUP BY fp.id_feature_value	5.480 ms	352	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:855 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:154 (getFeaturesBlock) /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)
114	SELECT SQL_NO_CACHE fp.id_feature, fp.id_feature_value, 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 pre2469_product p LEFT JOIN pre2469_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN pre2469_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN pre2469_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 pre2469_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN pre2469_category_product cp ON (p.id_product = cp.id_product) INNER JOIN pre2469_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN pre2469_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN pre2469_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN pre2469_feature_product fp ON (p.id_product = fp.id_product) WHERE ((fp.id_feature_value IN (21887, 21888, 20992, 21167, 14661))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=2 AND c.nright<=157 GROUP BY p.id_product) p INNER JOIN pre2469_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN pre2469_feature_product fp_1 ON (p.id_product = fp_1.id_product) WHERE ((fp.id_feature=8)) AND ((fp_1.id_feature_value IN (21887, 21888, 20992, 21167, 14661))) GROUP BY fp.id_feature_value	5.260 ms	352	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:855 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:154 (getFeaturesBlock) /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)
19	show tables like "pre2469_gmc_feeds"	5.247 ms	1			/modules/gmerchantcenter/lib/moduleTools.php:1711 /modules/gmerchantcenter/gmerchantcenter.php:85 (checkTableExist) :undefined (__construct) /src/Core/Foundation/IoC/Container.php:123 (newInstance) /src/Core/Foundation/IoC/Container.php:153 (makeInstanceFromClassName) /src/Core/Foundation/IoC/Container.php:166 (doMake) /src/Adapter/ServiceLocator.php:70 (make) /classes/module/Module.php:1258 (get) /tools/profiling/Module.php:35 (coreLoadModule) /classes/module/Module.php:1237 (coreLoadModule) /classes/Hook.php:966 (getInstanceByName) /classes/Dispatcher.php:606 (exec) /classes/Dispatcher.php:243 (loadRoutes) /classes/Dispatcher.php:201 (__construct) /index.php:28 (getInstance)
731	SELECT SQL_NO_CACHE `reduction` FROM `pre2469_product_group_reduction_cache` WHERE `id_product` = 111 AND `id_group` = 1 LIMIT 1	5.126 ms	0			/classes/GroupReduction.php:156 /classes/Product.php:3990 (getValueForProduct) /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:1077 (hookdisplayLeftColumn) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:418 (coreCallHook) /classes/Hook.php:983 (callHookOn) /config/smarty.config.inc.php:201 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/prod/smarty/compile/v1_gardenia_11layouts_layout_left_column_tpl/1a/89/a7/1a89a734d096f5ad14ad4dbb33891e0facb00120_2.file.layout-both-columns.tpl.php:192 (__call) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/v1_gardenia_11layouts_layout_left_column_tpl/1a/89/a7/1a89a734d096f5ad14ad4dbb33891e0facb00120_2.file.layout-both-columns.tpl.php:74 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67293b29f16874_07033251) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/v1_gardenia_11layouts_layout_left_column_tpl/6d/33/66/6d33663adfbf67f07eddb2df7d930f4c5287edb8_2.file.layout-left-column.tpl.php:28 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67293b29efacf3_58320531) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/v1_gardenia_11layouts_layout_left_column_tpl/82/55/0e/82550e22f895f1760ff1e1a0c2d6c8c47e0de299_2.file.product-list.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67293b29eea393_23821434) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/v1_gardenia_11layouts_layout_left_column_tpl/37/3d/2c/373d2ce4c1a83676f8228aca20a47aac483b040b_2.file.category.tpl.php:29 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67293b29ed0a52_43895681) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/controller/FrontController.php: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)
1840	SELECT SQL_NO_CACHE `reduction` FROM `pre2469_product_group_reduction_cache` WHERE `id_product` = 601 AND `id_group` = 1 LIMIT 1	5.002 ms	0			/classes/GroupReduction.php:156 /classes/Product.php:3990 (getValueForProduct) /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:1077 (hookdisplayLeftColumn) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:418 (coreCallHook) /classes/Hook.php:983 (callHookOn) /config/smarty.config.inc.php:201 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/prod/smarty/compile/v1_gardenia_11layouts_layout_left_column_tpl/1a/89/a7/1a89a734d096f5ad14ad4dbb33891e0facb00120_2.file.layout-both-columns.tpl.php:192 (__call) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/v1_gardenia_11layouts_layout_left_column_tpl/1a/89/a7/1a89a734d096f5ad14ad4dbb33891e0facb00120_2.file.layout-both-columns.tpl.php:74 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67293b29f16874_07033251) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/v1_gardenia_11layouts_layout_left_column_tpl/6d/33/66/6d33663adfbf67f07eddb2df7d930f4c5287edb8_2.file.layout-left-column.tpl.php:28 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67293b29efacf3_58320531) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/v1_gardenia_11layouts_layout_left_column_tpl/82/55/0e/82550e22f895f1760ff1e1a0c2d6c8c47e0de299_2.file.product-list.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67293b29eea393_23821434) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/v1_gardenia_11layouts_layout_left_column_tpl/37/3d/2c/373d2ce4c1a83676f8228aca20a47aac483b040b_2.file.category.tpl.php:29 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67293b29ed0a52_43895681) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/controller/FrontController.php: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)
124	SELECT SQL_NO_CACHE fp.id_feature, fp.id_feature_value, 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 pre2469_product p LEFT JOIN pre2469_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN pre2469_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN pre2469_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 pre2469_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN pre2469_category_product cp ON (p.id_product = cp.id_product) INNER JOIN pre2469_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN pre2469_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN pre2469_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN pre2469_feature_product fp ON (p.id_product = fp.id_product) WHERE ((fp.id_feature_value IN (21887, 21888, 20992, 21167, 14661))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=2 AND c.nright<=157 GROUP BY p.id_product) p INNER JOIN pre2469_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN pre2469_feature_product fp_1 ON (p.id_product = fp_1.id_product) WHERE ((fp.id_feature=15)) AND ((fp_1.id_feature_value IN (21887, 21888, 20992, 21167, 14661))) GROUP BY fp.id_feature_value	4.928 ms	352	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:855 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:154 (getFeaturesBlock) /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)
1501	SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`, IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on, product_attribute_shop.`ecotax` AS attribute_ecotax FROM `pre2469_product` p INNER JOIN `pre2469_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1) LEFT JOIN `pre2469_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1) WHERE (p.`id_product` = 456)	4.812 ms	1			/classes/Product.php:3860 /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:1077 (hookdisplayLeftColumn) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:418 (coreCallHook) /classes/Hook.php:983 (callHookOn) /config/smarty.config.inc.php:201 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/prod/smarty/compile/v1_gardenia_11layouts_layout_left_column_tpl/1a/89/a7/1a89a734d096f5ad14ad4dbb33891e0facb00120_2.file.layout-both-columns.tpl.php:192 (__call) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/v1_gardenia_11layouts_layout_left_column_tpl/1a/89/a7/1a89a734d096f5ad14ad4dbb33891e0facb00120_2.file.layout-both-columns.tpl.php:74 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67293b29f16874_07033251) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/v1_gardenia_11layouts_layout_left_column_tpl/6d/33/66/6d33663adfbf67f07eddb2df7d930f4c5287edb8_2.file.layout-left-column.tpl.php:28 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67293b29efacf3_58320531) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/v1_gardenia_11layouts_layout_left_column_tpl/82/55/0e/82550e22f895f1760ff1e1a0c2d6c8c47e0de299_2.file.product-list.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67293b29eea393_23821434) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/v1_gardenia_11layouts_layout_left_column_tpl/37/3d/2c/373d2ce4c1a83676f8228aca20a47aac483b040b_2.file.category.tpl.php:29 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67293b29ed0a52_43895681) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/controller/FrontController.php: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)
1844	SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) + IF (`id_country` = 8, 4, 0) + IF (`id_currency` = 1, 8, 0) + IF (`id_shop` = 1, 16, 0) + IF (`id_customer` = 0, 32, 0)) AS `score` FROM `pre2469_specific_price` WHERE `id_shop` IN (0, 1) AND `id_currency` IN (0, 1) AND `id_country` IN (0, 8) AND `id_group` IN (0, 1) AND `id_product` = 606 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0 AND (`from` = '0000-00-00 00:00:00' OR '2024-11-11 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-11-11 00:00:00' <= `to`) AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1	4.748 ms	1	Yes		/classes/SpecificPrice.php:576 /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:1077 (hookdisplayLeftColumn) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:418 (coreCallHook) /classes/Hook.php:983 (callHookOn) /config/smarty.config.inc.php:201 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/prod/smarty/compile/v1_gardenia_11layouts_layout_left_column_tpl/1a/89/a7/1a89a734d096f5ad14ad4dbb33891e0facb00120_2.file.layout-both-columns.tpl.php:192 (__call) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/v1_gardenia_11layouts_layout_left_column_tpl/1a/89/a7/1a89a734d096f5ad14ad4dbb33891e0facb00120_2.file.layout-both-columns.tpl.php:74 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67293b29f16874_07033251) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/v1_gardenia_11layouts_layout_left_column_tpl/6d/33/66/6d33663adfbf67f07eddb2df7d930f4c5287edb8_2.file.layout-left-column.tpl.php:28 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67293b29efacf3_58320531) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/v1_gardenia_11layouts_layout_left_column_tpl/82/55/0e/82550e22f895f1760ff1e1a0c2d6c8c47e0de299_2.file.product-list.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67293b29eea393_23821434) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/v1_gardenia_11layouts_layout_left_column_tpl/37/3d/2c/373d2ce4c1a83676f8228aca20a47aac483b040b_2.file.category.tpl.php:29 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67293b29ed0a52_43895681) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/controller/FrontController.php: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)
128	SELECT SQL_NO_CACHE fp.id_feature, fp.id_feature_value, 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 pre2469_product p LEFT JOIN pre2469_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN pre2469_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN pre2469_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 pre2469_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN pre2469_category_product cp ON (p.id_product = cp.id_product) INNER JOIN pre2469_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN pre2469_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN pre2469_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN pre2469_feature_product fp ON (p.id_product = fp.id_product) WHERE ((fp.id_feature_value IN (21887, 21888, 20992, 21167, 14661))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=2 AND c.nright<=157 GROUP BY p.id_product) p INNER JOIN pre2469_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN pre2469_feature_product fp_1 ON (p.id_product = fp_1.id_product) WHERE ((fp.id_feature=20)) AND ((fp_1.id_feature_value IN (21887, 21888, 20992, 21167, 14661))) GROUP BY fp.id_feature_value	4.746 ms	352	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:855 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:154 (getFeaturesBlock) /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)
1751	SELECT SQL_NO_CACHE `reduction` FROM `pre2469_product_group_reduction_cache` WHERE `id_product` = 578 AND `id_group` = 1 LIMIT 1	4.742 ms	0			/classes/GroupReduction.php:156 /classes/Product.php:3990 (getValueForProduct) /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:1077 (hookdisplayLeftColumn) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:418 (coreCallHook) /classes/Hook.php:983 (callHookOn) /config/smarty.config.inc.php:201 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/prod/smarty/compile/v1_gardenia_11layouts_layout_left_column_tpl/1a/89/a7/1a89a734d096f5ad14ad4dbb33891e0facb00120_2.file.layout-both-columns.tpl.php:192 (__call) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/v1_gardenia_11layouts_layout_left_column_tpl/1a/89/a7/1a89a734d096f5ad14ad4dbb33891e0facb00120_2.file.layout-both-columns.tpl.php:74 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67293b29f16874_07033251) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/v1_gardenia_11layouts_layout_left_column_tpl/6d/33/66/6d33663adfbf67f07eddb2df7d930f4c5287edb8_2.file.layout-left-column.tpl.php:28 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67293b29efacf3_58320531) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/v1_gardenia_11layouts_layout_left_column_tpl/82/55/0e/82550e22f895f1760ff1e1a0c2d6c8c47e0de299_2.file.product-list.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67293b29eea393_23821434) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/v1_gardenia_11layouts_layout_left_column_tpl/37/3d/2c/373d2ce4c1a83676f8228aca20a47aac483b040b_2.file.category.tpl.php:29 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67293b29ed0a52_43895681) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/controller/FrontController.php: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)
2113	SELECT SQL_NO_CACHE image_shop.`id_image` FROM `pre2469_image` i INNER JOIN pre2469_image_shop image_shop ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1) WHERE i.`id_product` = 750 AND image_shop.`cover` = 1 LIMIT 1	4.687 ms	6			/classes/Product.php:3570 /classes/Product.php:5643 (getCover) /classes/Product.php:5990 (getProductProperties) /classes/Category.php:1074 (getProductsProperties) /src/Adapter/Category/CategoryProductSearchProvider.php:79 (getProducts) /src/Adapter/Category/CategoryProductSearchProvider.php:105 (getProductsOrCount) /modules/tvcmstabproducts/tvcmstabproducts.php:2708 (runQuery) /modules/tvcmsfeaturedproducts/tvcmsfeaturedproducts.php:158 (displayFeaturedProducts) /modules/tvcmsfeaturedproducts/tvcmsfeaturedproducts.php:281 (showFrontSideResult) /classes/Hook.php:1077 (hookdisplayLeftColumn) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:418 (coreCallHook) /classes/Hook.php:983 (callHookOn) /config/smarty.config.inc.php:201 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/prod/smarty/compile/v1_gardenia_11layouts_layout_left_column_tpl/1a/89/a7/1a89a734d096f5ad14ad4dbb33891e0facb00120_2.file.layout-both-columns.tpl.php:192 (__call) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/v1_gardenia_11layouts_layout_left_column_tpl/1a/89/a7/1a89a734d096f5ad14ad4dbb33891e0facb00120_2.file.layout-both-columns.tpl.php:74 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67293b29f16874_07033251) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/v1_gardenia_11layouts_layout_left_column_tpl/6d/33/66/6d33663adfbf67f07eddb2df7d930f4c5287edb8_2.file.layout-left-column.tpl.php:28 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67293b29efacf3_58320531) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/v1_gardenia_11layouts_layout_left_column_tpl/82/55/0e/82550e22f895f1760ff1e1a0c2d6c8c47e0de299_2.file.product-list.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67293b29eea393_23821434) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/v1_gardenia_11layouts_layout_left_column_tpl/37/3d/2c/373d2ce4c1a83676f8228aca20a47aac483b040b_2.file.category.tpl.php:29 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67293b29ed0a52_43895681) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/controller/FrontController.php: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)
461	SELECT SQL_NO_CACHE c., cl. FROM `pre2469_category` c INNER JOIN pre2469_category_shop category_shop ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1) LEFT JOIN `pre2469_category_lang` cl ON c.`id_category` = cl.`id_category` AND cl.id_shop = 1 WHERE 1 AND `id_lang` = 1 AND c.`active` = 1 ORDER BY c.`level_depth` ASC , category_shop.`position` ASC	4.553 ms	79	Yes		/classes/Category.php:799 /modules/tvcmssearch/tvcmssearch.php:100 (getNestedCategories) /modules/tvcmssearch/tvcmssearch.php:211 (getAllCategories) /classes/Hook.php:1077 (hookdisplayNavSearchBlock) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:418 (coreCallHook) /classes/Hook.php:983 (callHookOn) /config/smarty.config.inc.php:201 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/prod/smarty/compile/v1_gardenia_11layouts_layout_left_column_tpl/bd/95/e2/bd95e28a15f35124d814b1a25c3a08ce78345268_2.file.desk-header-7.tpl.php:37 (__call) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67293b2a281d57_86876041) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /var/cache/prod/smarty/compile/v1_gardenia_11layouts_layout_left_column_tpl/b1/6f/68/b16f68e6bb922534b635e7fa572aee543e9fb07a_2.file.desktop-header.tpl.php:25 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67293b2a270919_32767377) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /var/cache/prod/smarty/compile/v1_gardenia_11layouts_layout_left_column_tpl/f7/f8/6b/f7f86be97cfdbafa2735d8030700d58f00d21d2a_2.file.header.tpl.php:55 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/v1_gardenia_11layouts_layout_left_column_tpl/f7/f8/6b/f7f86be97cfdbafa2735d8030700d58f00d21d2a_2.file.header.tpl.php:29 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67293b2a2643b7_90860613) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /var/cache/prod/smarty/compile/v1_gardenia_11layouts_layout_left_column_tpl/1a/89/a7/1a89a734d096f5ad14ad4dbb33891e0facb00120_2.file.layout-both-columns.tpl.php:144 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/v1_gardenia_11layouts_layout_left_column_tpl/1a/89/a7/1a89a734d096f5ad14ad4dbb33891e0facb00120_2.file.layout-both-columns.tpl.php:64 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67293b29f16874_07033251) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/v1_gardenia_11layouts_layout_left_column_tpl/6d/33/66/6d33663adfbf67f07eddb2df7d930f4c5287edb8_2.file.layout-left-column.tpl.php:28 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67293b29efacf3_58320531) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/v1_gardenia_11layouts_layout_left_column_tpl/82/55/0e/82550e22f895f1760ff1e1a0c2d6c8c47e0de299_2.file.product-list.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67293b29eea393_23821434) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/v1_gardenia_11layouts_layout_left_column_tpl/37/3d/2c/373d2ce4c1a83676f8228aca20a47aac483b040b_2.file.category.tpl.php:29 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67293b29ed0a52_43895681) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/controller/FrontController.php: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)
1735	SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) + IF (`id_country` = 8, 4, 0) + IF (`id_currency` = 1, 8, 0) + IF (`id_shop` = 1, 16, 0) + IF (`id_customer` = 0, 32, 0)) AS `score` FROM `pre2469_specific_price` WHERE `id_shop` IN (0, 1) AND `id_currency` IN (0, 1) AND `id_country` IN (0, 8) AND `id_group` IN (0, 1) AND `id_product` = 546 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0 AND (`from` = '0000-00-00 00:00:00' OR '2024-11-11 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-11-11 00:00:00' <= `to`) AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1	4.525 ms	1	Yes		/classes/SpecificPrice.php:576 /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:1077 (hookdisplayLeftColumn) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:418 (coreCallHook) /classes/Hook.php:983 (callHookOn) /config/smarty.config.inc.php:201 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/prod/smarty/compile/v1_gardenia_11layouts_layout_left_column_tpl/1a/89/a7/1a89a734d096f5ad14ad4dbb33891e0facb00120_2.file.layout-both-columns.tpl.php:192 (__call) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/v1_gardenia_11layouts_layout_left_column_tpl/1a/89/a7/1a89a734d096f5ad14ad4dbb33891e0facb00120_2.file.layout-both-columns.tpl.php:74 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67293b29f16874_07033251) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/v1_gardenia_11layouts_layout_left_column_tpl/6d/33/66/6d33663adfbf67f07eddb2df7d930f4c5287edb8_2.file.layout-left-column.tpl.php:28 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67293b29efacf3_58320531) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/v1_gardenia_11layouts_layout_left_column_tpl/82/55/0e/82550e22f895f1760ff1e1a0c2d6c8c47e0de299_2.file.product-list.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67293b29eea393_23821434) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/v1_gardenia_11layouts_layout_left_column_tpl/37/3d/2c/373d2ce4c1a83676f8228aca20a47aac483b040b_2.file.category.tpl.php:29 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67293b29ed0a52_43895681) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/controller/FrontController.php: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)
404	SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity, COALESCE(SUM(first_level_quantity), 0) as quantity FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity FROM `pre2469_cart_product` cp WHERE cp.`id_product_attribute` = 0 AND cp.`id_cart` = 0 AND cp.`id_product` = 798 UNION SELECT 0 as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity FROM `pre2469_cart_product` cp JOIN `pre2469_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `pre2469_product` pr ON p.`id_product_pack` = pr.`id_product` WHERE cp.`id_product_attribute` = 0 AND cp.`id_cart` = 0 AND p.`id_product_item` = 798 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1	4.284 ms	0			/classes/Cart.php:1430 /classes/Product.php:4361 (getProductQuantity) /classes/Product.php:5802 (getQuantity) /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:1077 (hookdisplayAfterBodyOpeningTag) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:418 (coreCallHook) /classes/Hook.php:983 (callHookOn) /config/smarty.config.inc.php:201 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/prod/smarty/compile/v1_gardenia_11layouts_layout_left_column_tpl/1a/89/a7/1a89a734d096f5ad14ad4dbb33891e0facb00120_2.file.layout-both-columns.tpl.php:116 (__call) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/v1_gardenia_11layouts_layout_left_column_tpl/1a/89/a7/1a89a734d096f5ad14ad4dbb33891e0facb00120_2.file.layout-both-columns.tpl.php:54 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67293b29f16874_07033251) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/v1_gardenia_11layouts_layout_left_column_tpl/6d/33/66/6d33663adfbf67f07eddb2df7d930f4c5287edb8_2.file.layout-left-column.tpl.php:28 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67293b29efacf3_58320531) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/v1_gardenia_11layouts_layout_left_column_tpl/82/55/0e/82550e22f895f1760ff1e1a0c2d6c8c47e0de299_2.file.product-list.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67293b29eea393_23821434) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/v1_gardenia_11layouts_layout_left_column_tpl/37/3d/2c/373d2ce4c1a83676f8228aca20a47aac483b040b_2.file.category.tpl.php:29 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67293b29ed0a52_43895681) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/controller/FrontController.php: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)
489	SELECT SQL_NO_CACHE p., product_shop., stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, pl.`description`, pl.`description_short`, pl.`link_rewrite`, pl.`meta_description`, pl.`meta_keywords`, pl.`meta_title`, pl.`name`, pl.`available_now`, pl.`available_later`, image_shop.`id_image` id_image, il.`legend`, m.`name` AS manufacturer_name, (DATEDIFF(product_shop.`date_add`, DATE_SUB( "2024-11-11 00:00:00", INTERVAL 1000 DAY ) ) > 0) as new, product_attribute_shop.minimal_quantity AS product_attribute_minimal_quantity, IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute FROM `pre2469_product` p INNER JOIN pre2469_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) LEFT JOIN `pre2469_product_lang` `pl` ON p.`id_product` = pl.`id_product` AND pl.`id_lang` = 1 AND pl.id_shop = 1 LEFT JOIN `pre2469_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 `pre2469_image_lang` `il` ON image_shop.`id_image` = il.`id_image` AND il.`id_lang` = 1 LEFT JOIN `pre2469_manufacturer` `m` ON m.`id_manufacturer` = p.`id_manufacturer` LEFT JOIN `pre2469_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 pre2469_stock_available stock ON (stock.id_product = `p`.id_product AND stock.id_product_attribute = 0 AND stock.id_shop = 1 AND stock.id_shop_group = 0 ) WHERE (product_shop.`active` = 1) AND (product_shop.`visibility` IN ("both", "catalog")) AND (DATEDIFF(product_shop.`date_add`, DATE_SUB( "2024-11-11 00:00:00", INTERVAL 1000 DAY ) ) > 0) AND (EXISTS(SELECT 1 FROM `pre2469_category_product` cp JOIN `pre2469_category_group` cg ON (cp.id_category = cg.id_category AND cg.`id_group` =1) WHERE cp.`id_product` = p.`id_product`)) ORDER BY product_shop.`date_add` DESC LIMIT 4	4.242 ms	2			/classes/Product.php:3110 /modules/tvcmstabproducts/tvcmstabproducts.php:2763 (getNewProducts) /modules/tvcmsnewproducts/tvcmsnewproducts.php:157 (displayNewProducts) /modules/tvcmsnewproducts/tvcmsnewproducts.php:266 (showFrontSideResult) /classes/Hook.php:1077 (hookdisplayLeftColumn) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:418 (coreCallHook) /classes/Hook.php:983 (callHookOn) /config/smarty.config.inc.php:201 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/prod/smarty/compile/v1_gardenia_11layouts_layout_left_column_tpl/1a/89/a7/1a89a734d096f5ad14ad4dbb33891e0facb00120_2.file.layout-both-columns.tpl.php:192 (__call) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/v1_gardenia_11layouts_layout_left_column_tpl/1a/89/a7/1a89a734d096f5ad14ad4dbb33891e0facb00120_2.file.layout-both-columns.tpl.php:74 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67293b29f16874_07033251) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/v1_gardenia_11layouts_layout_left_column_tpl/6d/33/66/6d33663adfbf67f07eddb2df7d930f4c5287edb8_2.file.layout-left-column.tpl.php:28 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67293b29efacf3_58320531) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/v1_gardenia_11layouts_layout_left_column_tpl/82/55/0e/82550e22f895f1760ff1e1a0c2d6c8c47e0de299_2.file.product-list.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67293b29eea393_23821434) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/v1_gardenia_11layouts_layout_left_column_tpl/37/3d/2c/373d2ce4c1a83676f8228aca20a47aac483b040b_2.file.category.tpl.php:29 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67293b29ed0a52_43895681) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/controller/FrontController.php: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)
1051	SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`, IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on, product_attribute_shop.`ecotax` AS attribute_ecotax FROM `pre2469_product` p INNER JOIN `pre2469_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1) LEFT JOIN `pre2469_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1) WHERE (p.`id_product` = 251)	4.225 ms	1			/classes/Product.php:3860 /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:1077 (hookdisplayLeftColumn) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:418 (coreCallHook) /classes/Hook.php:983 (callHookOn) /config/smarty.config.inc.php:201 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/prod/smarty/compile/v1_gardenia_11layouts_layout_left_column_tpl/1a/89/a7/1a89a734d096f5ad14ad4dbb33891e0facb00120_2.file.layout-both-columns.tpl.php:192 (__call) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/v1_gardenia_11layouts_layout_left_column_tpl/1a/89/a7/1a89a734d096f5ad14ad4dbb33891e0facb00120_2.file.layout-both-columns.tpl.php:74 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67293b29f16874_07033251) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/v1_gardenia_11layouts_layout_left_column_tpl/6d/33/66/6d33663adfbf67f07eddb2df7d930f4c5287edb8_2.file.layout-left-column.tpl.php:28 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67293b29efacf3_58320531) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/v1_gardenia_11layouts_layout_left_column_tpl/82/55/0e/82550e22f895f1760ff1e1a0c2d6c8c47e0de299_2.file.product-list.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67293b29eea393_23821434) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/v1_gardenia_11layouts_layout_left_column_tpl/37/3d/2c/373d2ce4c1a83676f8228aca20a47aac483b040b_2.file.category.tpl.php:29 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67293b29ed0a52_43895681) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/controller/FrontController.php: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-intl-normalizer/bootstrap.php
13	/vendor/symfony/polyfill-intl-idn/bootstrap.php
14	/vendor/symfony/deprecation-contracts/function.php
15	/vendor/ralouphie/getallheaders/src/getallheaders.php
16	/vendor/symfony/polyfill-ctype/bootstrap.php
17	/vendor/symfony/polyfill-php80/bootstrap.php
18	/vendor/guzzlehttp/promises/src/functions_include.php
19	/vendor/guzzlehttp/promises/src/functions.php
20	/vendor/guzzlehttp/guzzle/src/functions_include.php
21	/vendor/guzzlehttp/guzzle/src/functions.php
22	/vendor/symfony/polyfill-iconv/bootstrap.php
23	/vendor/ezyang/htmlpurifier/library/HTMLPurifier.composer.php
24	/vendor/jakeasmith/http_build_url/src/http_build_url.php
25	/vendor/lcobucci/jwt/compat/class-aliases.php
26	/vendor/lcobucci/jwt/src/Token.php
27	/vendor/lcobucci/jwt/src/Signature.php
28	/vendor/lcobucci/jwt/compat/json-exception-polyfill.php
29	/vendor/lcobucci/jwt/compat/lcobucci-clock-polyfill.php
30	/vendor/swiftmailer/swiftmailer/lib/swift_required.php
31	/vendor/swiftmailer/swiftmailer/lib/classes/Swift.php
32	/vendor/symfony/polyfill-intl-icu/bootstrap.php
33	/vendor/symfony/polyfill-php73/bootstrap.php
34	/vendor/symfony/polyfill-php81/bootstrap.php
35	/vendor/api-platform/core/src/deprecation.php
36	/vendor/api-platform/core/src/Api/FilterInterface.php
37	/vendor/api-platform/core/src/Api/ResourceClassResolverInterface.php
38	/vendor/api-platform/core/src/deprecated_interfaces.php
39	/vendor/api-platform/core/src/Metadata/Property/Factory/PropertyNameCollectionFactoryInterface.php

Oleo Mac OM109L-16K

Sécateur KP 280

Sécateur KP 295

Kress KG163E.9

Kress KA3713

Panier

Oleo-Mac GV48TK Allroad

Oleo-Mac GV48TK Allroad

Oleo-Mac GV48TK Allroad

Oleo-Mac GV48TK Allroad

Echo DLM310/46P

Echo DLM310/46P

Echo DLM310/46P

Echo DLM310/46P

Oleo Mac G 48PE

Oleo Mac G 48PE

Oleo Mac G 48PE

Oleo Mac G 48PE

Oleo Mac G48TK Autochock

Oleo Mac G48TK Autochock

Oleo Mac G48TK Autochock

Oleo Mac G48TK Autochock

Oleo Mac MAX 48TK Allroad

Oleo Mac MAX 48TK Allroad

Oleo Mac MAX 48TK Allroad

Oleo Mac MAX 48TK Allroad

Stiga COLLECTOR 48S

Stiga COLLECTOR 48S

Stiga COLLECTOR 48S

Stiga COLLECTOR 48S

Stiga COLLECTOR 548 E

Stiga COLLECTOR 548 E

Stiga COLLECTOR 548 E

Stiga COLLECTOR 548 E

OleoMac G48TKE

OleoMac G48TKE

OleoMac G48TKE

OleoMac G48TKE

OleoMac G48TKE Allroad Plus 4

OleoMac G48TKE Allroad Plus 4

OleoMac G48TKE Allroad Plus 4

OleoMac G48TKE Allroad Plus 4

Outils-Wolf RM46B

Outils-Wolf RM46B

Outils-Wolf RM46B

Outils-Wolf RM46B

Dormak CR48L PLUS

Dormak CR48L PLUS

Dormak CR48L PLUS

Dormak CR48L PLUS

Echo DLM310/46SP

Echo DLM310/46SP

Echo DLM310/46SP

Echo DLM310/46SP

Stopwatch SQL - 2341 queries

Doubles

Tables stress

ObjectModel instances

Included Files