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

10 produits

Grille

Grille-2

Liste

Liste-2

Catalogue

Trier par:

Twinclip 950 EV

1 429,00 €

Twinclip 950 EV

1 429,00 €

Twinclip 950 EV

Tondeuses à batterie

Tondeuse à batterie Stiga Twinclip 950 EV avec 2 batteries de 48 volts en 7.5Ah est idéale pour ceux qui attendent un résultat de coupe parfaite avec peu d'effort. Le châssis en acier galvanisé...

1 429,00 €

Load Time	2257 ms
Querying Time	2178 ms
Queries	2318
Memory Peak Usage	71.2 Mb
Included Files	1145 files - 11.51 Mb
PrestaShop Cache	- Mb
Global vars	0.82 Mb
- global $_MODULES	565k
- global $context	235k
- global $_SERVER	7k
- global $_ENV	7k
- global $__composer_autoload_files	5k
- global $config	5k
- global $exportPhpConfigFile	4k
- global $_MODULE	2k
- global $_COOKIE	1k
- global $_REQUEST	1k
- 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	12.722 ms	12.722 ms	7.54 Mb	7.8 Mb
__construct	0.011 ms	12.733 ms	- Mb	7.8 Mb
init	32.526 ms	45.259 ms	1.78 Mb	9.5 Mb
checkAccess	0.001 ms	45.260 ms	- Mb	9.5 Mb
setMedia	3.452 ms	48.712 ms	0.25 Mb	9.6 Mb
postProcess	0.001 ms	48.713 ms	- Mb	9.6 Mb
initHeader	0.000 ms	48.713 ms	- Mb	9.6 Mb
initContent	304.409 ms	353.122 ms	7.46 Mb	17.1 Mb
initFooter	0.002 ms	353.124 ms	- Mb	17.1 Mb
display	1904 ms	2257 ms	53.52 Mb	71.2 Mb

Hook	Time	Memory Usage
DisplayLeftColumn	1630 ms	38.95 Mb
=> tvcmsnewproducts	15.475 ms	0.68 Mb
=> tvcmscustomerservices	0.277 ms	0.06 Mb
=> tvcmsspecialproducts	1355 ms	34.87 Mb
=> tvcmsfeaturedproducts	94.967 ms	1.90 Mb
=> tvcmsbestsellerproducts	164.222 ms	1.44 Mb
DisplayReviewProductList	77.163 ms	4.10 Mb
=> tvcmsproductcomments	2.884 ms	0.14 Mb
=> tvcmsproductcomments	1.528 ms	0.09 Mb
=> tvcmsproductcomments	1.822 ms	0.09 Mb
=> tvcmsproductcomments	1.666 ms	0.09 Mb
=> tvcmsproductcomments	1.680 ms	0.13 Mb
=> tvcmsproductcomments	1.640 ms	0.09 Mb
=> tvcmsproductcomments	1.520 ms	0.09 Mb
=> tvcmsproductcomments	1.378 ms	0.09 Mb
=> tvcmsproductcomments	2.310 ms	0.13 Mb
=> tvcmsproductcomments	1.586 ms	0.09 Mb
=> tvcmsproductcomments	1.213 ms	0.09 Mb
=> tvcmsproductcomments	1.552 ms	0.09 Mb
=> tvcmsproductcomments	2.671 ms	0.13 Mb
=> tvcmsproductcomments	2.432 ms	0.09 Mb
=> tvcmsproductcomments	1.248 ms	0.09 Mb
=> tvcmsproductcomments	1.195 ms	0.09 Mb
=> tvcmsproductcomments	1.497 ms	0.15 Mb
=> tvcmsproductcomments	7.160 ms	0.09 Mb
=> tvcmsproductcomments	1.203 ms	0.09 Mb
=> tvcmsproductcomments	1.321 ms	0.09 Mb
=> tvcmsproductcomments	1.856 ms	0.13 Mb
=> tvcmsproductcomments	1.307 ms	0.09 Mb
=> tvcmsproductcomments	1.436 ms	0.09 Mb
=> tvcmsproductcomments	1.135 ms	0.09 Mb
=> tvcmsproductcomments	1.340 ms	0.13 Mb
=> tvcmsproductcomments	8.639 ms	0.09 Mb
=> tvcmsproductcomments	1.427 ms	0.09 Mb
=> tvcmsproductcomments	1.808 ms	0.09 Mb
=> tvcmsproductcomments	4.944 ms	0.13 Mb
=> tvcmsproductcomments	1.397 ms	0.09 Mb
=> tvcmsproductcomments	1.113 ms	0.09 Mb
=> tvcmsproductcomments	1.387 ms	0.09 Mb
=> tvcmsproductcomments	1.461 ms	0.13 Mb
=> tvcmsproductcomments	1.042 ms	0.09 Mb
=> tvcmsproductcomments	1.086 ms	0.09 Mb
=> tvcmsproductcomments	1.043 ms	0.09 Mb
=> tvcmsproductcomments	1.464 ms	0.13 Mb
=> tvcmsproductcomments	1.259 ms	0.09 Mb
=> tvcmsproductcomments	1.338 ms	0.09 Mb
=> tvcmsproductcomments	1.175 ms	0.09 Mb
DisplayAfterBodyOpeningTag	71.037 ms	2.31 Mb
=> tvcmscookiesnotice	0.194 ms	0.02 Mb
=> blockreassurance	0.003 ms	- Mb
=> tvcmsproductpopup	70.673 ms	2.27 Mb
=> cdc_googletagmanager	0.167 ms	0.02 Mb
DisplayAfterTitleTag	38.071 ms	1.64 Mb
=> cdc_googletagmanager	38.071 ms	1.64 Mb
=> cdc_googletagmanager	0.000 ms	- Mb
displayLeftColumn	9.643 ms	0.48 Mb
=> ps_categorytree (widget)	6.482 ms	0.38 Mb
=> ps_brandlist (widget)	2.067 ms	0.05 Mb
=> ps_supplierlist (widget)	1.094 ms	0.06 Mb
DisplayHeader	7.975 ms	0.31 Mb
=> ps_searchbar	0.109 ms	- Mb
=> ps_shoppingcart	0.018 ms	- Mb
=> tvcmstabproducts	0.071 ms	- Mb
=> tvcmscustomerservices	0.046 ms	- Mb
=> tvcmscustomsetting	0.272 ms	0.01 Mb
=> tvcmsfooterlogo	0.000 ms	- Mb
=> tvcmsfooterproduct	0.030 ms	- Mb
=> tvcmsmultibanner1	0.044 ms	- Mb
=> tvcmspaymenticon	0.000 ms	- Mb
=> tvcmsslider	0.043 ms	- Mb
=> tvcmswishlist	0.060 ms	- Mb
=> tvcmscategorychainslider	0.042 ms	- Mb
=> tvcmsnewsletterpopup	0.079 ms	- Mb
=> tvcmscookiesnotice	0.042 ms	- Mb
=> tvcmsproductcomments	0.132 ms	- Mb
=> tvcmsbrandlist	0.041 ms	- Mb
=> tvcmsproductpopup	0.038 ms	- Mb
=> tvcmscategoryslider	0.041 ms	- Mb
=> tvcmsbestsellerproducts	0.028 ms	- Mb
=> tvcmsfeaturedproducts	0.024 ms	- Mb
=> tvcmsnewproducts	0.023 ms	- Mb
=> tvcmsproductcompare	0.041 ms	- Mb
=> tvcmssearch	0.093 ms	- Mb
=> tvcmsspecialproducts	0.025 ms	- Mb
=> tvcmsthemeoptions	0.115 ms	- Mb
=> cdc_googletagmanager	0.032 ms	- Mb
=> ganalyticspro	6.476 ms	0.26 Mb
=> ets_advancedcaptcha	0.009 ms	- Mb
DisplayMegamenu	7.582 ms	0.32 Mb
=> tvcmsmegamenu	7.582 ms	0.32 Mb
DisplayFooterCategory	6.964 ms	0.26 Mb
=> tvcmsfootercategory	6.964 ms	0.26 Mb
DisplayWishlistBtnProductList	6.303 ms	0.60 Mb
=> tvcmswishlist	0.193 ms	0.02 Mb
=> tvcmswishlist	0.167 ms	0.01 Mb
=> tvcmswishlist	0.163 ms	0.08 Mb
=> tvcmswishlist	0.163 ms	0.01 Mb
=> tvcmswishlist	0.155 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.152 ms	0.01 Mb
=> tvcmswishlist	0.157 ms	0.01 Mb
=> tvcmswishlist	0.157 ms	0.01 Mb
=> tvcmswishlist	0.157 ms	0.01 Mb
=> tvcmswishlist	0.154 ms	0.01 Mb
=> tvcmswishlist	0.158 ms	0.01 Mb
=> tvcmswishlist	0.156 ms	0.01 Mb
=> tvcmswishlist	0.156 ms	0.01 Mb
=> tvcmswishlist	0.150 ms	0.01 Mb
=> tvcmswishlist	0.155 ms	0.01 Mb
=> tvcmswishlist	0.163 ms	0.01 Mb
=> tvcmswishlist	0.157 ms	0.01 Mb
=> tvcmswishlist	0.152 ms	0.01 Mb
=> tvcmswishlist	0.155 ms	0.01 Mb
=> tvcmswishlist	0.161 ms	0.01 Mb
=> tvcmswishlist	0.158 ms	0.01 Mb
=> tvcmswishlist	0.153 ms	0.01 Mb
=> tvcmswishlist	0.160 ms	0.01 Mb
=> tvcmswishlist	0.160 ms	0.01 Mb
=> tvcmswishlist	0.159 ms	0.01 Mb
=> tvcmswishlist	0.154 ms	0.01 Mb
=> tvcmswishlist	0.157 ms	0.01 Mb
=> tvcmswishlist	0.155 ms	0.01 Mb
=> tvcmswishlist	0.154 ms	0.01 Mb
=> tvcmswishlist	0.151 ms	0.01 Mb
=> tvcmswishlist	0.155 ms	0.01 Mb
=> tvcmswishlist	0.157 ms	0.01 Mb
=> tvcmswishlist	0.152 ms	0.01 Mb
=> tvcmswishlist	0.151 ms	0.01 Mb
=> tvcmswishlist	0.155 ms	0.01 Mb
=> tvcmswishlist	0.157 ms	0.01 Mb
=> tvcmswishlist	0.154 ms	0.01 Mb
DisplayProductCompareProductList	5.978 ms	0.56 Mb
=> tvcmsproductcompare	0.197 ms	0.08 Mb
=> tvcmsproductcompare	0.163 ms	0.01 Mb
=> tvcmsproductcompare	0.154 ms	0.01 Mb
=> tvcmsproductcompare	0.153 ms	0.01 Mb
=> tvcmsproductcompare	0.150 ms	0.01 Mb
=> tvcmsproductcompare	0.149 ms	0.01 Mb
=> tvcmsproductcompare	0.149 ms	0.01 Mb
=> tvcmsproductcompare	0.148 ms	0.01 Mb
=> tvcmsproductcompare	0.147 ms	0.01 Mb
=> tvcmsproductcompare	0.147 ms	0.01 Mb
=> tvcmsproductcompare	0.150 ms	0.01 Mb
=> tvcmsproductcompare	0.146 ms	0.01 Mb
=> tvcmsproductcompare	0.148 ms	0.01 Mb
=> tvcmsproductcompare	0.154 ms	0.01 Mb
=> tvcmsproductcompare	0.150 ms	0.01 Mb
=> tvcmsproductcompare	0.146 ms	0.01 Mb
=> tvcmsproductcompare	0.147 ms	0.01 Mb
=> tvcmsproductcompare	0.148 ms	0.01 Mb
=> tvcmsproductcompare	0.152 ms	0.01 Mb
=> tvcmsproductcompare	0.146 ms	0.01 Mb
=> tvcmsproductcompare	0.146 ms	0.01 Mb
=> tvcmsproductcompare	0.147 ms	0.01 Mb
=> tvcmsproductcompare	0.150 ms	0.01 Mb
=> tvcmsproductcompare	0.144 ms	0.01 Mb
=> tvcmsproductcompare	0.144 ms	0.01 Mb
=> tvcmsproductcompare	0.147 ms	0.01 Mb
=> tvcmsproductcompare	0.151 ms	0.01 Mb
=> tvcmsproductcompare	0.149 ms	0.01 Mb
=> tvcmsproductcompare	0.149 ms	0.01 Mb
=> tvcmsproductcompare	0.147 ms	0.01 Mb
=> tvcmsproductcompare	0.149 ms	0.01 Mb
=> tvcmsproductcompare	0.146 ms	0.01 Mb
=> tvcmsproductcompare	0.145 ms	0.01 Mb
=> tvcmsproductcompare	0.146 ms	0.01 Mb
=> tvcmsproductcompare	0.148 ms	0.01 Mb
=> tvcmsproductcompare	0.144 ms	0.01 Mb
=> tvcmsproductcompare	0.146 ms	0.01 Mb
=> tvcmsproductcompare	0.146 ms	0.01 Mb
=> tvcmsproductcompare	0.148 ms	0.01 Mb
=> tvcmsproductcompare	0.142 ms	0.01 Mb
Header	4.760 ms	0.32 Mb
=> tvcmsstockinfo	0.049 ms	- Mb
=> alma	2.605 ms	0.24 Mb
=> tvcmsinfinitescroll	1.901 ms	0.06 Mb
=> tvcmsofferbanner	0.049 ms	- Mb
=> tvcmstwoofferbanner	0.044 ms	- Mb
=> tvcmsmegamenu	0.055 ms	- Mb
=> tvcmscategoryproduct	0.057 ms	- Mb
DisplayCustomsocialblock	4.165 ms	0.24 Mb
=> tvcmscustomsetting	4.165 ms	0.24 Mb
displayNav1	3.681 ms	0.09 Mb
=> ps_contactinfo (widget)	3.681 ms	0.09 Mb
DisplayNavSearchBlock	3.606 ms	0.25 Mb
=> tvcmssearch	3.606 ms	0.25 Mb
displayFooterPart1	2.902 ms	0.06 Mb
=> ps_linklist (widget)	2.902 ms	0.06 Mb
displayNavCustomerSignInBlock	2.598 ms	0.06 Mb
=> ps_customersignin (widget)	2.598 ms	0.06 Mb
DisplayNavWishlistBlock	2.213 ms	0.10 Mb
=> tvcmswishlist	1.345 ms	0.06 Mb
=> tvcmswishlist	0.868 ms	0.04 Mb
displayMyaccountcblock	2.100 ms	0.06 Mb
=> ps_customeraccountlinks (widget)	2.100 ms	0.06 Mb
displayNavShoppingCartBlock	2.003 ms	0.18 Mb
=> ps_shoppingcart (widget)	2.003 ms	0.18 Mb
DisplayProductPriceBlock	1.819 ms	0.12 Mb
=> cdc_googletagmanager	0.002 ms	- Mb
=> alma	0.234 ms	0.03 Mb
=> cdc_googletagmanager	0.001 ms	- Mb
=> alma	0.014 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.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.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.001 ms	- Mb
=> alma	0.020 ms	- Mb
=> cdc_googletagmanager	0.001 ms	- Mb
=> alma	0.010 ms	- Mb
=> cdc_googletagmanager	0.000 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.008 ms	- Mb
=> cdc_googletagmanager	0.001 ms	- Mb
=> alma	0.017 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.000 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.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.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.017 ms	- Mb
=> cdc_googletagmanager	0.001 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.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.010 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.009 ms	- Mb
=> cdc_googletagmanager	0.001 ms	- Mb
=> alma	0.017 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.019 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.019 ms	- Mb
=> cdc_googletagmanager	0.000 ms	- Mb
=> alma	0.010 ms	- Mb
=> cdc_googletagmanager	0.001 ms	- Mb
=> alma	0.025 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.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.000 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.011 ms	- Mb
=> cdc_googletagmanager	0.000 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.001 ms	- Mb
=> alma	0.010 ms	- Mb
=> cdc_googletagmanager	0.000 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.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.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.001 ms	- Mb
=> alma	0.011 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.001 ms	- Mb
=> alma	0.017 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.019 ms	- Mb
=> cdc_googletagmanager	0.001 ms	- Mb
=> alma	0.010 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.010 ms	- Mb
=> cdc_googletagmanager	0.001 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.009 ms	- Mb
=> cdc_googletagmanager	0.000 ms	- Mb
=> alma	0.017 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.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.018 ms	- Mb
=> cdc_googletagmanager	0.001 ms	- Mb
=> alma	0.010 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.001 ms	- Mb
=> alma	0.017 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.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.010 ms	- Mb
=> cdc_googletagmanager	0.001 ms	- Mb
=> alma	0.018 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.017 ms	- Mb
=> cdc_googletagmanager	0.000 ms	- Mb
=> alma	0.011 ms	- Mb
=> cdc_googletagmanager	0.000 ms	- Mb
=> alma	0.008 ms	- Mb
=> cdc_googletagmanager	0.001 ms	- Mb
=> alma	0.017 ms	- Mb
=> cdc_googletagmanager	0.000 ms	- Mb
=> alma	0.010 ms	- Mb
=> cdc_googletagmanager	0.001 ms	- Mb
=> alma	0.009 ms	- Mb
displayNavLanguageBlock	1.576 ms	0.05 Mb
=> ps_languageselector (widget)	1.576 ms	0.05 Mb
displaySocialMediaBlock	1.467 ms	0.07 Mb
=> ps_socialfollow (widget)	1.467 ms	0.07 Mb
displayNavCurrencyBlock	1.249 ms	0.05 Mb
=> ps_currencyselector (widget)	1.249 ms	0.05 Mb
DisplayPaymentIcon	1.189 ms	0.06 Mb
=> tvcmspaymenticon	1.189 ms	0.06 Mb
DisplayNavWishlistBlocksticky	1.093 ms	0.06 Mb
=> tvcmswishlist	1.093 ms	0.06 Mb
displayContactCinfo	1.066 ms	0.04 Mb
=> ps_contactinfo (widget)	1.066 ms	0.04 Mb
DisplayNavProductCompareBlock	0.346 ms	0.02 Mb
=> tvcmsproductcompare	0.195 ms	0.01 Mb
=> tvcmsproductcompare	0.151 ms	0.01 Mb
ProductSearchProvider	0.305 ms	0.07 Mb
=> ps_facetedsearch	0.305 ms	0.07 Mb
ActionFrontControllerSetMedia	0.183 ms	0.01 Mb
=> blockreassurance	0.115 ms	- Mb
=> ps_socialfollow	0.030 ms	- Mb
=> ps_emailalerts	0.038 ms	- Mb
DisplayFooterPart2	0.169 ms	0.03 Mb
=> tvcmsfooterlogo	0.169 ms	0.03 Mb
DisplayProductComparesticky	0.168 ms	0.01 Mb
=> tvcmsproductcompare	0.168 ms	0.01 Mb
DisplayFacetedSearchBlock	0.168 ms	0.07 Mb
=> ps_facetedsearch	0.168 ms	0.07 Mb
DisplayProductListStockIndicator	0.154 ms	0.01 Mb
=> tvcmsstockinfo	0.012 ms	- Mb
=> tvcmsstockinfo	0.008 ms	- Mb
=> tvcmsstockinfo	0.008 ms	- Mb
=> tvcmsstockinfo	0.007 ms	- Mb
=> tvcmsstockinfo	0.008 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.007 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
=> tvcmsstockinfo	0.007 ms	- Mb
=> tvcmsstockinfo	0.007 ms	- Mb
=> tvcmsstockinfo	0.008 ms	- Mb
=> tvcmsstockinfo	0.007 ms	- Mb
DisplayCopyRightText	0.127 ms	0.02 Mb
=> tvcmscustomsetting	0.127 ms	0.02 Mb
ModuleRoutes	0.072 ms	- Mb
=> alma	0.072 ms	- Mb
DisplayTopOfferText	0.009 ms	- Mb
=> tvcmscustomsetting	0.007 ms	- Mb
=> tvcmscustomsetting	0.002 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)	1900 ms	51.59 Mb

245 queries	SELECT XX FROM `preXX_specific_price` WHERE id_product = XX LIMIT XX
244 queries	SELECT `reduction` FROM `preXX_product_group_reduction_cache` WHERE `id_product` = XX AND `id_group` = XX LIMIT XX
244 queries	SELECT `id_tax_rules_group` FROM `preXX_product_shop` WHERE `id_product` = XX AND id_shop=XX LIMIT XX
244 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)
231 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
223 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
40 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
40 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
31 queries	SELECT `id_product_attribute` FROM `preXX_product_attribute` WHERE `id_product` = XX
31 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`
31 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
31 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
26 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 FROM preXX_category_lang WHERE id_shop = XX AND id_lang = XX AND id_category = XX LIMIT XX
26 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
23 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)
18 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
13 queries	SELECT * FROM `preXX_category_lang` WHERE `id_category` = XX AND `id_shop` = XX
13 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
10 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
10 queries	SELECT * FROM `preXX_product_lang` WHERE `id_product` = XX AND `id_shop` = XX
10 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
10 queries	SELECT COUNT(`id_tvcmsproduct_comment`) AS "nbr" FROM `preXX_tvcmsproduct_comment` pc WHERE `id_product` = XX AND `validate` = XX LIMIT 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 `id_country` FROM `preXX_country` WHERE `iso_code` = 'FR' 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))) 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))) GROUP BY fp.id_feature_value
5 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
5 queries	SELECT * FROM `preXX_country_lang` WHERE `id_country` = XX
5 queries	SELECT * FROM `preXX_product_attribute_lang` WHERE `id_product_attribute` = XX
5 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
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 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
5 queries	SELECT `name` FROM `preXX_country_lang` WHERE `id_lang` = XX AND `id_country` = XX LIMIT XX
5 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
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
4 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
4 queries	SELECT `name` FROM `preXX_manufacturer` WHERE `id_manufacturer` = XX AND `active` = 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
3 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`
3 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, XX) AND il.`id_lang` = XX ORDER by i.`position`
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
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 * 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
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_lang` FROM `preXX_lang` WHERE `locale` = 'fr-fr' OR `language_code` = 'fr-fr' LIMIT XX
2 queries	SELECT `id_category` FROM `preXX_category_shop` WHERE `id_category` = XX AND `id_shop` = XX LIMIT XX
2 queries	SELECT id_module as id, active FROM preXX_module WHERE name = "pm_advancedcookiebanner" AND active = XX

Name	Instances	Source
Category	72	/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: 162] /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: 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: 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: 166] /modules/cdc_googletagmanager/cdc_googletagmanager.php:1323 (__construct) [id: 114] /modules/cdc_googletagmanager/cdc_googletagmanager.php:1323 (__construct) [id: 37] /modules/cdc_googletagmanager/cdc_googletagmanager.php:1323 (__construct) [id: 114] /modules/cdc_googletagmanager/classes/gtm/DataLayerItem.php:109 (__construct) [id: 166] /modules/cdc_googletagmanager/cdc_googletagmanager.php:1323 (__construct) [id: 114] /modules/cdc_googletagmanager/cdc_googletagmanager.php:1323 (__construct) [id: 37] /modules/cdc_googletagmanager/cdc_googletagmanager.php:1323 (__construct) [id: 114] /modules/cdc_googletagmanager/classes/gtm/DataLayerItem.php:109 (__construct) [id: 166] /modules/cdc_googletagmanager/cdc_googletagmanager.php:1323 (__construct) [id: 114] /modules/cdc_googletagmanager/cdc_googletagmanager.php:1323 (__construct) [id: 37] /modules/cdc_googletagmanager/cdc_googletagmanager.php:1323 (__construct) [id: 114] /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	50	/src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 462] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 329] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 195] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 529] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 321] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 41] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 185] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 760] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 203] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 781] /classes/Link.php:113 (__construct) [id: 321] /classes/Link.php:113 (__construct) [id: 41] /classes/Link.php:113 (__construct) [id: 185] /classes/Link.php:113 (__construct) [id: 781] /modules/cdc_googletagmanager/services/Gtm_Product.php:164 (__construct) [id: 462] /modules/cdc_googletagmanager/services/Gtm_Product.php:164 (__construct) [id: 329] /modules/cdc_googletagmanager/services/Gtm_Product.php:164 (__construct) [id: 195] /modules/cdc_googletagmanager/services/Gtm_Product.php:164 (__construct) [id: 529] /modules/cdc_googletagmanager/services/Gtm_Product.php:164 (__construct) [id: 321] /modules/cdc_googletagmanager/services/Gtm_Product.php:164 (__construct) [id: 41] /modules/cdc_googletagmanager/services/Gtm_Product.php:164 (__construct) [id: 185] /modules/cdc_googletagmanager/services/Gtm_Product.php:164 (__construct) [id: 760] /modules/cdc_googletagmanager/services/Gtm_Product.php:164 (__construct) [id: 203] /modules/cdc_googletagmanager/services/Gtm_Product.php:164 (__construct) [id: 781] /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] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 518] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 465] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 560] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 211] /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	18	/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/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:690 (getCurrencyInstance) [id: 1]
Combination	9	/classes/Product.php:5912 (__construct) [id: 37] /classes/Product.php:5912 (__construct) [id: 21] /classes/Product.php:5912 (__construct) [id: 25] /classes/Product.php:5912 (__construct) [id: 116] /modules/cdc_googletagmanager/classes/gtm/DataLayerItem.php:72 (__construct) [id: 37] /modules/cdc_googletagmanager/classes/gtm/DataLayerItem.php:72 (__construct) [id: 21] /modules/cdc_googletagmanager/classes/gtm/DataLayerItem.php:72 (__construct) [id: 25] /modules/cdc_googletagmanager/classes/gtm/DataLayerItem.php:72 (__construct) [id: 116] /classes/Product.php:5912 (__construct) [id: 8]
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: ]
Cart	2	/classes/controller/FrontController.php:467 (__construct) [id: ] /classes/controller/FrontController.php:541 (__construct) [id: ]
Tax	2	/classes/tax/TaxRulesTaxManager.php:116 (__construct) [id: 1] /classes/tax/TaxRulesTaxManager.php:116 (__construct) [id: 1]
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
2161	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	61.057 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	31.058 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)
489	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`)	23.729 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)
2198	SELECT SQL_NO_CACHE `id_product_attribute` FROM `pre2469_product_attribute` WHERE `id_product` = 347	22.623 ms	1			/classes/Product.php:2902 /src/Adapter/Image/ImageRetriever.php:90 (getCombinationImages) /src/Adapter/Presenter/Product/ProductLazyArray.php:688 (getAllProductImages) /src/Adapter/Presenter/Product/ProductLazyArray.php:127 (fillImages) /src/Adapter/Presenter/Product/ProductListingPresenter.php:57 (__construct) /modules/tvcmstabproducts/tvcmstabproducts.php:2913 (present) /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)
1796	SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority` FROM `pre2469_specific_price_priority` WHERE `id_product` = 594 ORDER BY `id_specific_price_priority` DESC LIMIT 1	12.112 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)
1942	SELECT SQL_NO_CACHE `reduction` FROM `pre2469_product_group_reduction_cache` WHERE `id_product` = 677 AND `id_group` = 1 LIMIT 1	11.320 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)
1024	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` = 246 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	10.848 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)
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`	10.750 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)
2073	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 = 543 ORDER BY f.position ASC	10.526 ms	6	Yes		/classes/Product.php:6021 /classes/Product.php:5824 (getFrontFeaturesStatic) /classes/Product.php:5990 (getProductProperties) /classes/Product.php:3404 (getProductsProperties) /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)
1787	SELECT SQL_NO_CACHE `reduction` FROM `pre2469_product_group_reduction_cache` WHERE `id_product` = 588 AND `id_group` = 1 LIMIT 1	8.195 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)
2264	SELECT SQL_NO_CACHE (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS grade FROM `pre2469_tvcmsproduct_comment` pc WHERE pc.`id_product` = 185 AND pc.`deleted` = 0 AND pc.`validate` = 1 LIMIT 1	7.846 ms	1			/modules/tvcmsproductcomments/tvcmsproductcomment.php:224 /modules/tvcmsproductcomments/tvcmsproductcomments.php:928 (getAverageGrade) /classes/Hook.php:1077 (hookdisplayReviewProductList) /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/65/91/c0/6591c0e9face84c5cc8526c86a16495863924379_2.file.product-grid-view2.tpl.php:32 (__call) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67293b2a48acb6_50834176) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:384 (render) /var/cache/prod/smarty/compile/v1_gardenia_11layouts_layout_left_column_tpl/51/22/9b/51229b277affe3689a61af0e5f19acadf9ebad2e_2.file.product.tpl.php:52 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/v1_gardenia_11layouts_layout_left_column_tpl/51/22/9b/51229b277affe3689a61af0e5f19acadf9ebad2e_2.file.product.tpl.php:34 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67293b2a401c65_04154377) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:384 (render) /var/cache/prod/smarty/compile/v1_gardenia_11layouts_layout_left_column_tpl/62/0e/f9/620ef910b4a1401136b5f1791e075131afc4a358_2.file.products.tpl.php:50 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/v1_gardenia_11layouts_layout_left_column_tpl/62/0e/f9/620ef910b4a1401136b5f1791e075131afc4a358_2.file.products.tpl.php:34 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67293b2a3f1492_14467522) /vendor/smarty/smarty/libs/sysplugins/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/82/55/0e/82550e22f895f1760ff1e1a0c2d6c8c47e0de299_2.file.product-list.tpl.php:78 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/v1_gardenia_11layouts_layout_left_column_tpl/82/55/0e/82550e22f895f1760ff1e1a0c2d6c8c47e0de299_2.file.product-list.tpl.php:133 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:186 (process) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/v1_gardenia_11layouts_layout_left_column_tpl/6d/33/66/6d33663adfbf67f07eddb2df7d930f4c5287edb8_2.file.layout-left-column.tpl.php:70 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:186 (process) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/v1_gardenia_11layouts_layout_left_column_tpl/1a/89/a7/1a89a734d096f5ad14ad4dbb33891e0facb00120_2.file.layout-both-columns.tpl.php:76 (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`	7.585 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)
2174	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 = 300 ORDER BY f.position ASC	7.525 ms	3	Yes		/classes/Product.php:6021 /classes/Product.php:5824 (getFrontFeaturesStatic) /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)
1797	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` = 594 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	7.199 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)
2072	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` = 543 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` = 543 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1	6.667 ms	0			/classes/Cart.php:1430 /classes/Product.php:4361 (getProductQuantity) /classes/Product.php:5802 (getQuantity) /classes/Product.php:5990 (getProductProperties) /classes/Product.php:3404 (getProductsProperties) /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)
1808	SELECT SQL_NO_CACHE product_attribute_shop.id_product_attribute FROM pre2469_product_attribute pa INNER JOIN pre2469_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) WHERE pa.id_product = 597 LIMIT 1	6.465 ms	1			/classes/Product.php:1106 /classes/Product.php:3817 (getDefaultAttribute) /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)
2246	SELECT SQL_NO_CACHE (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS grade FROM `pre2469_tvcmsproduct_comment` pc WHERE pc.`id_product` = 321 AND pc.`deleted` = 0 AND pc.`validate` = 1 LIMIT 1	6.442 ms	1			/modules/tvcmsproductcomments/tvcmsproductcomment.php:224 /modules/tvcmsproductcomments/tvcmsproductcomments.php:928 (getAverageGrade) /classes/Hook.php:1077 (hookdisplayReviewProductList) /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/65/91/c0/6591c0e9face84c5cc8526c86a16495863924379_2.file.product-grid-view2.tpl.php:32 (__call) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67293b2a48acb6_50834176) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:384 (render) /var/cache/prod/smarty/compile/v1_gardenia_11layouts_layout_left_column_tpl/51/22/9b/51229b277affe3689a61af0e5f19acadf9ebad2e_2.file.product.tpl.php:52 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/v1_gardenia_11layouts_layout_left_column_tpl/51/22/9b/51229b277affe3689a61af0e5f19acadf9ebad2e_2.file.product.tpl.php:34 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67293b2a401c65_04154377) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:384 (render) /var/cache/prod/smarty/compile/v1_gardenia_11layouts_layout_left_column_tpl/62/0e/f9/620ef910b4a1401136b5f1791e075131afc4a358_2.file.products.tpl.php:50 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/v1_gardenia_11layouts_layout_left_column_tpl/62/0e/f9/620ef910b4a1401136b5f1791e075131afc4a358_2.file.products.tpl.php:34 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67293b2a3f1492_14467522) /vendor/smarty/smarty/libs/sysplugins/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/82/55/0e/82550e22f895f1760ff1e1a0c2d6c8c47e0de299_2.file.product-list.tpl.php:78 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/v1_gardenia_11layouts_layout_left_column_tpl/82/55/0e/82550e22f895f1760ff1e1a0c2d6c8c47e0de299_2.file.product-list.tpl.php:133 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:186 (process) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/v1_gardenia_11layouts_layout_left_column_tpl/6d/33/66/6d33663adfbf67f07eddb2df7d930f4c5287edb8_2.file.layout-left-column.tpl.php:70 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:186 (process) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/v1_gardenia_11layouts_layout_left_column_tpl/1a/89/a7/1a89a734d096f5ad14ad4dbb33891e0facb00120_2.file.layout-both-columns.tpl.php:76 (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)
559	SELECT SQL_NO_CACHE product_attribute_shop.id_product_attribute FROM pre2469_product_attribute pa INNER JOIN pre2469_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) WHERE pa.id_product = 49 LIMIT 1	6.323 ms	1			/classes/Product.php:1106 /classes/Product.php:3817 (getDefaultAttribute) /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)
1798	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` = 594)	6.277 ms	2			/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)
1723	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` = 544)	6.144 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)
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 (14672, 14660, 14662))) 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 (14672, 14660, 14662))) GROUP BY fp.id_feature_value	6.106 ms	176	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)
2116	SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, agl.`public_name` as `public_group`, pa.`reference`, pa.`ean13`, pa.`isbn`, pa.`upc`, pa.`mpn`, pal.`available_now`, pal.`available_later` FROM `pre2469_attribute` a LEFT JOIN `pre2469_attribute_lang` al ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 1) LEFT JOIN `pre2469_product_attribute_combination` pac ON (pac.`id_attribute` = a.`id_attribute`) LEFT JOIN `pre2469_product_attribute` pa ON (pa.`id_product_attribute` = pac.`id_product_attribute`) INNER JOIN pre2469_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) LEFT JOIN `pre2469_product_attribute_lang` pal ON (pal.`id_product_attribute` = pac.`id_product_attribute` AND pal.`id_lang` = 1) LEFT JOIN `pre2469_attribute_group_lang` agl ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1) WHERE pa.`id_product` = 518 AND pac.`id_product_attribute` = 8 AND agl.`id_lang` = 1	6.011 ms	1			/classes/Product.php:7534 /classes/Product.php:5857 (getAttributesParams) /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)
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`)	5.900 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)
14	SELECT SQL_NO_CACHE `name`, `alias` FROM `pre2469_hook_alias`	5.829 ms	88			/classes/Hook.php:287 /classes/Hook.php:318 (getAllHookAliases) /classes/Hook.php:746 (getHookAliasesFor) /classes/Hook.php:842 (getHookModuleExecList) /classes/Dispatcher.php:606 (exec) /classes/Dispatcher.php:243 (loadRoutes) /classes/Dispatcher.php:201 (__construct) /index.php:28 (getInstance)
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 (14672, 14660, 14662))) 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 (14672, 14660, 14662))) AND cg.id_group='1' AND c.nleft>2 AND c.nright<157 GROUP BY cp.id_category	5.746 ms	176	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)
1023	SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority` FROM `pre2469_specific_price_priority` WHERE `id_product` = 246 ORDER BY `id_specific_price_priority` DESC LIMIT 1	5.640 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)
2105	SELECT SQL_NO_CACHE p., product_shop., stock.out_of_stock, IFNULL(stock.quantity, 0) AS quantity, IFNULL(product_attribute_shop.id_product_attribute, 0) AS id_product_attribute, product_attribute_shop.minimal_quantity AS product_attribute_minimal_quantity, pl.`description`, pl.`description_short`, pl.`available_now`, pl.`available_later`, pl.`link_rewrite`, pl.`meta_description`, pl.`meta_keywords`, pl.`meta_title`, pl.`name`, image_shop.`id_image` id_image, il.`legend` as legend, m.`name` AS manufacturer_name, cl.`name` AS category_default, DATEDIFF(product_shop.`date_add`, DATE_SUB("2024-11-11 00:00:00", INTERVAL 1000 DAY)) > 0 AS new, product_shop.price AS orderprice FROM `pre2469_category_product` cp LEFT JOIN `pre2469_product` p ON p.`id_product` = cp.`id_product` 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_category_lang` cl ON (product_shop.`id_category_default` = cl.`id_category` AND cl.`id_lang` = 1 AND cl.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` WHERE product_shop.`id_shop` = 1 AND cp.`id_category` = 118 AND product_shop.`active` = 1 AND product_shop.`visibility` IN ("both", "catalog") ORDER BY RAND() LIMIT 4	5.597 ms	26	Yes		/classes/Category.php:1062 /src/Adapter/Category/CategoryProductSearchProvider.php:79 (getProducts) /src/Adapter/Category/CategoryProductSearchProvider.php:105 (getProductsOrCount) /modules/tvcmstabproducts/tvcmstabproducts.php:2708 (runQuery) /modules/tvcmsfeaturedproducts/tvcmsfeaturedproducts.php:158 (displayFeaturedProducts) /modules/tvcmsfeaturedproducts/tvcmsfeaturedproducts.php:281 (showFrontSideResult) /classes/Hook.php: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)
1301	SELECT SQL_NO_CACHE `reduction` FROM `pre2469_product_group_reduction_cache` WHERE `id_product` = 356 AND `id_group` = 1 LIMIT 1	5.407 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)
160	SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority` FROM `pre2469_specific_price_priority` WHERE `id_product` = 329 ORDER BY `id_specific_price_priority` DESC LIMIT 1	5.405 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/Product.php:5692 (getPriceStatic) /classes/ProductAssembler.php:209 (getProductProperties) /classes/controller/ProductListingFrontController.php:108 (assembleProducts) /classes/controller/ProductListingFrontController.php:379 (prepareMultipleProductsForTemplate) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
1780	SELECT SQL_NO_CACHE `reduction` FROM `pre2469_product_group_reduction_cache` WHERE `id_product` = 586 AND `id_group` = 1 LIMIT 1	4.940 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)
1804	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` = 595 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.921 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)
2184	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 = 136 ORDER BY f.position ASC	4.832 ms	3	Yes		/classes/Product.php:6021 /classes/Product.php:5824 (getFrontFeaturesStatic) /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)
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 (14672, 14660, 14662))) 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	4.826 ms	44	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)
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` = 347 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` = 347 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1	4.693 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)
140	SELECT SQL_NO_CACHE h.id_hook, h.name as h_name, title, description, h.position, hm.position as hm_position, m.id_module, m.name, m.active FROM `pre2469_hook_module` hm STRAIGHT_JOIN `pre2469_hook` h ON (h.id_hook = hm.id_hook AND hm.id_shop = 1) STRAIGHT_JOIN `pre2469_module` as m ON (m.id_module = hm.id_module) ORDER BY hm.position	4.558 ms	674			/classes/Hook.php:456 /classes/Hook.php:493 (getHookModuleList) /classes/tax/TaxManagerFactory.php:67 (getModulesFromHook) /classes/tax/TaxManagerFactory.php:46 (execHookTaxManagerFactory) /classes/Product.php:3925 (getManager) /classes/Product.php:3717 (priceCalculation) /classes/Product.php:5692 (getPriceStatic) /classes/ProductAssembler.php:209 (getProductProperties) /classes/controller/ProductListingFrontController.php:108 (assembleProducts) /classes/controller/ProductListingFrontController.php:379 (prepareMultipleProductsForTemplate) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
1846	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` = 606)	4.525 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)
15	SELECT SQL_NO_CACHE `id_hook`, `name` FROM `pre2469_hook`	4.506 ms	1044			/classes/Hook.php:1326 /classes/Hook.php:225 (getAllHookIds) /classes/Hook.php:851 (getIdByName) /classes/Dispatcher.php:606 (exec) /classes/Dispatcher.php:243 (loadRoutes) /classes/Dispatcher.php:201 (__construct) /index.php:28 (getInstance)
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 (14672, 14660, 14662))) 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 (14672, 14660, 14662))) GROUP BY fp.id_feature_value	4.493 ms	176	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)
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 (14672, 14660, 14662))) 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 (14672, 14660, 14662))) GROUP BY fp.id_feature_value	4.393 ms	176	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)
1746	SELECT SQL_NO_CACHE product_attribute_shop.id_product_attribute FROM pre2469_product_attribute pa INNER JOIN pre2469_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) WHERE pa.id_product = 578 LIMIT 1	4.084 ms	1			/classes/Product.php:1106 /classes/Product.php:3817 (getDefaultAttribute) /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

Twinclip 950 EV

Twinclip 950 EV

Twinclip 950 EV

Twinclip 950 EV

Oleo-Mac G 44PE

Oleo-Mac G 44PE

Oleo-Mac G 44PE

Oleo-Mac G 44PE

Outils-Wolf RM41B

Outils-Wolf RM41B

Outils-Wolf RM41B

Outils-Wolf RM41B

Stiga COLLECTOR 543 AE

Stiga COLLECTOR 543 AE

Stiga COLLECTOR 543 AE

Stiga COLLECTOR 543 AE

Stiga Park 500WX

Stiga Park 500WX

Stiga Park 500WX

Stiga Park 500WX

Stiga Park 700W

Stiga Park 700W

Stiga Park 700W

Stiga Park 700W

Stiga Park 700WX 4WD

Stiga Park 700WX 4WD

Stiga Park 700WX 4WD

Stiga Park 700WX 4WD

Stiga TWINCLIP 950S

Stiga TWINCLIP 950S

Stiga TWINCLIP 950S

Stiga TWINCLIP 950S

Stiga TWINCLIP 950V

Stiga TWINCLIP 950V

Stiga TWINCLIP 950V

Stiga TWINCLIP 950V

Kress KG 748.E9

Kress KG 748.E9

Kress KG 748.E9

Kress KG 748.E9

Stopwatch SQL - 2318 queries

Doubles

Tables stress

ObjectModel instances

Included Files