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

29 produits

Grille

Grille-2

Liste

Liste-2

Catalogue

Trier par:

Débroussailleuse à roue Oleomac DEB 517 - BEAUCAMP MOTOCULTURE

Oléomac DEB 517

999,00 €1 049,00 €

Oléomac DEB 517

999,00 €1 049,00 €-50,00 € désactivé

Oléomac DEB 517

Les débroussailleuses à roue

La débroussailleuse à roue Oléo Mac DEB 517 est une petite faucheuse-broyeuse très maniable, grâce à ses grandes roues à cliquets, elle possède un moteur Rato de 170cm3 puissant. <img...

999,00 €1 049,00 €-50,00 € désactivé

Load Time	2255 ms
Querying Time	2116 ms
Queries	2328
Memory Peak Usage	72.5 Mb
Included Files	1146 files - 11.51 Mb
PrestaShop Cache	- Mb
Global vars	0.83 Mb
- global $_MODULES	565k
- global $context	246k
- 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	11.191 ms	11.191 ms	7.54 Mb	7.8 Mb
__construct	0.010 ms	11.201 ms	- Mb	7.8 Mb
init	34.826 ms	46.027 ms	1.78 Mb	9.5 Mb
checkAccess	0.001 ms	46.028 ms	- Mb	9.5 Mb
setMedia	3.094 ms	49.122 ms	0.25 Mb	9.6 Mb
postProcess	0.002 ms	49.124 ms	- Mb	9.6 Mb
initHeader	0.001 ms	49.125 ms	- Mb	9.6 Mb
initContent	516.923 ms	566.048 ms	7.56 Mb	17.2 Mb
initFooter	0.002 ms	566.050 ms	- Mb	17.2 Mb
display	1689 ms	2255 ms	54.61 Mb	72.5 Mb

Hook	Time	Memory Usage
DisplayLeftColumn	1358 ms	38.58 Mb
=> tvcmsnewproducts	21.933 ms	0.68 Mb
=> tvcmscustomerservices	0.371 ms	0.06 Mb
=> tvcmsspecialproducts	1138 ms	34.22 Mb
=> tvcmsfeaturedproducts	93.250 ms	2.19 Mb
=> tvcmsbestsellerproducts	103.898 ms	1.44 Mb
DisplayReviewProductList	110.217 ms	4.91 Mb
=> tvcmsproductcomments	2.568 ms	0.14 Mb
=> tvcmsproductcomments	1.280 ms	0.09 Mb
=> tvcmsproductcomments	1.473 ms	0.09 Mb
=> tvcmsproductcomments	1.225 ms	0.09 Mb
=> tvcmsproductcomments	2.077 ms	0.15 Mb
=> tvcmsproductcomments	1.492 ms	0.09 Mb
=> tvcmsproductcomments	1.884 ms	0.09 Mb
=> tvcmsproductcomments	1.971 ms	0.09 Mb
=> tvcmsproductcomments	3.256 ms	0.13 Mb
=> tvcmsproductcomments	1.621 ms	0.09 Mb
=> tvcmsproductcomments	1.448 ms	0.09 Mb
=> tvcmsproductcomments	3.486 ms	0.09 Mb
=> tvcmsproductcomments	2.591 ms	0.13 Mb
=> tvcmsproductcomments	1.547 ms	0.09 Mb
=> tvcmsproductcomments	1.304 ms	0.09 Mb
=> tvcmsproductcomments	1.421 ms	0.09 Mb
=> tvcmsproductcomments	2.299 ms	0.13 Mb
=> tvcmsproductcomments	1.108 ms	0.09 Mb
=> tvcmsproductcomments	1.254 ms	0.09 Mb
=> tvcmsproductcomments	1.476 ms	0.09 Mb
=> tvcmsproductcomments	2.278 ms	0.13 Mb
=> tvcmsproductcomments	1.731 ms	0.09 Mb
=> tvcmsproductcomments	1.987 ms	0.09 Mb
=> tvcmsproductcomments	2.987 ms	0.09 Mb
=> tvcmsproductcomments	2.998 ms	0.13 Mb
=> tvcmsproductcomments	1.999 ms	0.09 Mb
=> tvcmsproductcomments	1.672 ms	0.09 Mb
=> tvcmsproductcomments	2.220 ms	0.09 Mb
=> tvcmsproductcomments	2.478 ms	0.13 Mb
=> tvcmsproductcomments	1.589 ms	0.09 Mb
=> tvcmsproductcomments	1.542 ms	0.09 Mb
=> tvcmsproductcomments	1.616 ms	0.09 Mb
=> tvcmsproductcomments	2.098 ms	0.13 Mb
=> tvcmsproductcomments	4.801 ms	0.09 Mb
=> tvcmsproductcomments	2.384 ms	0.09 Mb
=> tvcmsproductcomments	2.972 ms	0.09 Mb
=> tvcmsproductcomments	6.284 ms	0.13 Mb
=> tvcmsproductcomments	5.348 ms	0.09 Mb
=> tvcmsproductcomments	1.249 ms	0.09 Mb
=> tvcmsproductcomments	2.037 ms	0.09 Mb
=> tvcmsproductcomments	2.760 ms	0.13 Mb
=> tvcmsproductcomments	2.495 ms	0.09 Mb
=> tvcmsproductcomments	3.041 ms	0.09 Mb
=> tvcmsproductcomments	2.111 ms	0.09 Mb
=> tvcmsproductcomments	3.844 ms	0.13 Mb
=> tvcmsproductcomments	2.411 ms	0.09 Mb
=> tvcmsproductcomments	3.151 ms	0.09 Mb
=> tvcmsproductcomments	1.353 ms	0.09 Mb
DisplayAfterBodyOpeningTag	67.922 ms	2.30 Mb
=> tvcmscookiesnotice	0.198 ms	0.02 Mb
=> blockreassurance	0.003 ms	- Mb
=> tvcmsproductpopup	67.559 ms	2.26 Mb
=> cdc_googletagmanager	0.162 ms	0.02 Mb
DisplayAfterTitleTag	51.597 ms	1.80 Mb
=> cdc_googletagmanager	51.596 ms	1.80 Mb
=> cdc_googletagmanager	0.001 ms	- Mb
DisplayHeader	9.606 ms	0.31 Mb
=> ps_searchbar	0.112 ms	- Mb
=> ps_shoppingcart	0.018 ms	- Mb
=> tvcmstabproducts	0.073 ms	- Mb
=> tvcmscustomerservices	0.047 ms	- Mb
=> tvcmscustomsetting	0.276 ms	0.01 Mb
=> tvcmsfooterlogo	0.000 ms	- Mb
=> tvcmsfooterproduct	0.031 ms	- Mb
=> tvcmsmultibanner1	0.042 ms	- Mb
=> tvcmspaymenticon	0.000 ms	- Mb
=> tvcmsslider	0.042 ms	- Mb
=> tvcmswishlist	0.059 ms	- Mb
=> tvcmscategorychainslider	0.042 ms	- Mb
=> tvcmsnewsletterpopup	0.082 ms	- Mb
=> tvcmscookiesnotice	0.045 ms	- Mb
=> tvcmsproductcomments	0.134 ms	- Mb
=> tvcmsbrandlist	0.041 ms	- Mb
=> tvcmsproductpopup	0.039 ms	- Mb
=> tvcmscategoryslider	0.041 ms	- Mb
=> tvcmsbestsellerproducts	0.029 ms	- Mb
=> tvcmsfeaturedproducts	0.024 ms	- Mb
=> tvcmsnewproducts	0.024 ms	- Mb
=> tvcmsproductcompare	0.041 ms	- Mb
=> tvcmssearch	0.100 ms	- Mb
=> tvcmsspecialproducts	0.025 ms	- Mb
=> tvcmsthemeoptions	0.116 ms	- Mb
=> cdc_googletagmanager	0.032 ms	- Mb
=> ganalyticspro	8.081 ms	0.26 Mb
=> ets_advancedcaptcha	0.011 ms	- Mb
displayLeftColumn	8.917 ms	0.48 Mb
=> ps_categorytree (widget)	6.461 ms	0.38 Mb
=> ps_brandlist (widget)	1.356 ms	0.05 Mb
=> ps_supplierlist (widget)	1.100 ms	0.06 Mb
DisplayWishlistBtnProductList	8.658 ms	0.64 Mb
=> tvcmswishlist	0.964 ms	0.02 Mb
=> tvcmswishlist	0.164 ms	0.01 Mb
=> tvcmswishlist	0.168 ms	0.01 Mb
=> tvcmswishlist	0.162 ms	0.01 Mb
=> tvcmswishlist	0.154 ms	0.01 Mb
=> tvcmswishlist	0.179 ms	0.01 Mb
=> tvcmswishlist	0.165 ms	0.01 Mb
=> tvcmswishlist	0.157 ms	0.01 Mb
=> tvcmswishlist	0.154 ms	0.01 Mb
=> tvcmswishlist	0.162 ms	0.01 Mb
=> tvcmswishlist	0.176 ms	0.01 Mb
=> tvcmswishlist	0.156 ms	0.01 Mb
=> tvcmswishlist	0.155 ms	0.01 Mb
=> tvcmswishlist	0.205 ms	0.01 Mb
=> tvcmswishlist	0.160 ms	0.01 Mb
=> tvcmswishlist	0.159 ms	0.01 Mb
=> tvcmswishlist	0.157 ms	0.01 Mb
=> tvcmswishlist	0.159 ms	0.01 Mb
=> tvcmswishlist	0.158 ms	0.01 Mb
=> tvcmswishlist	0.154 ms	0.01 Mb
=> tvcmswishlist	0.151 ms	0.01 Mb
=> tvcmswishlist	0.168 ms	0.01 Mb
=> tvcmswishlist	0.173 ms	0.01 Mb
=> tvcmswishlist	0.173 ms	0.01 Mb
=> tvcmswishlist	0.165 ms	0.01 Mb
=> tvcmswishlist	0.157 ms	0.01 Mb
=> tvcmswishlist	0.159 ms	0.01 Mb
=> tvcmswishlist	0.164 ms	0.01 Mb
=> tvcmswishlist	0.154 ms	0.01 Mb
=> tvcmswishlist	0.156 ms	0.01 Mb
=> tvcmswishlist	0.157 ms	0.01 Mb
=> tvcmswishlist	0.173 ms	0.01 Mb
=> tvcmswishlist	0.167 ms	0.01 Mb
=> tvcmswishlist	0.177 ms	0.01 Mb
=> tvcmswishlist	0.175 ms	0.01 Mb
=> tvcmswishlist	0.175 ms	0.01 Mb
=> tvcmswishlist	0.160 ms	0.01 Mb
=> tvcmswishlist	0.165 ms	0.01 Mb
=> tvcmswishlist	0.169 ms	0.01 Mb
=> tvcmswishlist	0.161 ms	0.01 Mb
=> tvcmswishlist	0.161 ms	0.01 Mb
=> tvcmswishlist	0.159 ms	0.01 Mb
=> tvcmswishlist	0.167 ms	0.01 Mb
=> tvcmswishlist	0.162 ms	0.01 Mb
=> tvcmswishlist	0.156 ms	0.01 Mb
=> tvcmswishlist	0.160 ms	0.01 Mb
=> tvcmswishlist	0.163 ms	0.01 Mb
=> tvcmswishlist	0.162 ms	0.01 Mb
DisplayProductCompareProductList	8.467 ms	0.65 Mb
=> tvcmsproductcompare	1.192 ms	0.08 Mb
=> tvcmsproductcompare	0.163 ms	0.01 Mb
=> tvcmsproductcompare	0.158 ms	0.01 Mb
=> tvcmsproductcompare	0.151 ms	0.01 Mb
=> tvcmsproductcompare	0.153 ms	0.01 Mb
=> tvcmsproductcompare	0.165 ms	0.01 Mb
=> tvcmsproductcompare	0.153 ms	0.01 Mb
=> tvcmsproductcompare	0.149 ms	0.01 Mb
=> tvcmsproductcompare	0.147 ms	0.01 Mb
=> tvcmsproductcompare	0.154 ms	0.01 Mb
=> tvcmsproductcompare	0.166 ms	0.01 Mb
=> tvcmsproductcompare	0.151 ms	0.01 Mb
=> tvcmsproductcompare	0.147 ms	0.01 Mb
=> tvcmsproductcompare	0.165 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.147 ms	0.01 Mb
=> tvcmsproductcompare	0.149 ms	0.01 Mb
=> tvcmsproductcompare	0.144 ms	0.01 Mb
=> tvcmsproductcompare	0.144 ms	0.01 Mb
=> tvcmsproductcompare	0.154 ms	0.01 Mb
=> tvcmsproductcompare	0.163 ms	0.01 Mb
=> tvcmsproductcompare	0.166 ms	0.01 Mb
=> tvcmsproductcompare	0.164 ms	0.01 Mb
=> tvcmsproductcompare	0.149 ms	0.01 Mb
=> tvcmsproductcompare	0.151 ms	0.01 Mb
=> tvcmsproductcompare	0.157 ms	0.01 Mb
=> tvcmsproductcompare	0.147 ms	0.01 Mb
=> tvcmsproductcompare	0.145 ms	0.01 Mb
=> tvcmsproductcompare	0.150 ms	0.01 Mb
=> tvcmsproductcompare	0.161 ms	0.01 Mb
=> tvcmsproductcompare	0.161 ms	0.01 Mb
=> tvcmsproductcompare	0.175 ms	0.01 Mb
=> tvcmsproductcompare	0.167 ms	0.01 Mb
=> tvcmsproductcompare	0.169 ms	0.01 Mb
=> tvcmsproductcompare	0.155 ms	0.01 Mb
=> tvcmsproductcompare	0.157 ms	0.01 Mb
=> tvcmsproductcompare	0.165 ms	0.01 Mb
=> tvcmsproductcompare	0.153 ms	0.01 Mb
=> tvcmsproductcompare	0.152 ms	0.01 Mb
=> tvcmsproductcompare	0.149 ms	0.01 Mb
=> tvcmsproductcompare	0.158 ms	0.01 Mb
=> tvcmsproductcompare	0.151 ms	0.01 Mb
=> tvcmsproductcompare	0.151 ms	0.01 Mb
=> tvcmsproductcompare	0.150 ms	0.01 Mb
=> tvcmsproductcompare	0.155 ms	0.01 Mb
=> tvcmsproductcompare	0.149 ms	0.01 Mb
DisplayMegamenu	8.122 ms	0.32 Mb
=> tvcmsmegamenu	8.122 ms	0.32 Mb
DisplayFooterCategory	7.561 ms	0.25 Mb
=> tvcmsfootercategory	7.561 ms	0.25 Mb
DisplayNavSearchBlock	5.520 ms	0.25 Mb
=> tvcmssearch	5.520 ms	0.25 Mb
Header	5.176 ms	0.32 Mb
=> tvcmsstockinfo	0.049 ms	- Mb
=> alma	2.635 ms	0.24 Mb
=> tvcmsinfinitescroll	2.281 ms	0.06 Mb
=> tvcmsofferbanner	0.052 ms	- Mb
=> tvcmstwoofferbanner	0.044 ms	- Mb
=> tvcmsmegamenu	0.059 ms	- Mb
=> tvcmscategoryproduct	0.056 ms	- Mb
DisplayNavWishlistBlock	4.216 ms	0.10 Mb
=> tvcmswishlist	3.180 ms	0.06 Mb
=> tvcmswishlist	1.036 ms	0.04 Mb
DisplayCustomsocialblock	4.007 ms	0.24 Mb
=> tvcmscustomsetting	4.007 ms	0.24 Mb
displayNavShoppingCartBlock	3.089 ms	0.18 Mb
=> ps_shoppingcart (widget)	3.089 ms	0.18 Mb
DisplayProductPriceBlock	2.959 ms	0.16 Mb
=> cdc_googletagmanager	0.002 ms	- Mb
=> alma	0.736 ms	0.03 Mb
=> cdc_googletagmanager	0.001 ms	- Mb
=> alma	0.016 ms	- Mb
=> cdc_googletagmanager	0.001 ms	- Mb
=> alma	0.021 ms	- Mb
=> cdc_googletagmanager	0.001 ms	- Mb
=> alma	0.012 ms	- Mb
=> cdc_googletagmanager	0.000 ms	- Mb
=> alma	0.010 ms	- Mb
=> cdc_googletagmanager	0.000 ms	- Mb
=> alma	0.008 ms	- Mb
=> cdc_googletagmanager	0.001 ms	- Mb
=> alma	0.019 ms	- Mb
=> cdc_googletagmanager	0.000 ms	- Mb
=> alma	0.011 ms	- Mb
=> cdc_googletagmanager	0.000 ms	- Mb
=> alma	0.010 ms	- Mb
=> cdc_googletagmanager	0.001 ms	- Mb
=> alma	0.008 ms	- Mb
=> cdc_googletagmanager	0.001 ms	- Mb
=> alma	0.019 ms	- Mb
=> cdc_googletagmanager	0.000 ms	- Mb
=> alma	0.012 ms	- Mb
=> cdc_googletagmanager	0.000 ms	- Mb
=> alma	0.010 ms	- Mb
=> cdc_googletagmanager	0.000 ms	- Mb
=> alma	0.009 ms	- Mb
=> cdc_googletagmanager	0.001 ms	- Mb
=> alma	0.023 ms	- Mb
=> cdc_googletagmanager	0.000 ms	- Mb
=> alma	0.012 ms	- Mb
=> cdc_googletagmanager	0.001 ms	- Mb
=> alma	0.020 ms	- Mb
=> cdc_googletagmanager	0.000 ms	- Mb
=> alma	0.011 ms	- Mb
=> cdc_googletagmanager	0.000 ms	- Mb
=> alma	0.009 ms	- Mb
=> cdc_googletagmanager	0.000 ms	- Mb
=> alma	0.008 ms	- Mb
=> cdc_googletagmanager	0.001 ms	- Mb
=> alma	0.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.008 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.016 ms	- Mb
=> cdc_googletagmanager	0.000 ms	- Mb
=> alma	0.009 ms	- Mb
=> cdc_googletagmanager	0.001 ms	- Mb
=> alma	0.021 ms	- Mb
=> cdc_googletagmanager	0.000 ms	- Mb
=> alma	0.011 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.010 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.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.027 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.022 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.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.018 ms	- Mb
=> cdc_googletagmanager	0.001 ms	- Mb
=> alma	0.010 ms	- Mb
=> cdc_googletagmanager	0.000 ms	- Mb
=> alma	0.009 ms	- Mb
=> cdc_googletagmanager	0.000 ms	- Mb
=> alma	0.008 ms	- Mb
=> cdc_googletagmanager	0.001 ms	- Mb
=> alma	0.018 ms	- Mb
=> cdc_googletagmanager	0.001 ms	- Mb
=> alma	0.010 ms	- Mb
=> cdc_googletagmanager	0.000 ms	- Mb
=> alma	0.009 ms	- Mb
=> cdc_googletagmanager	0.000 ms	- Mb
=> alma	0.008 ms	- Mb
=> cdc_googletagmanager	0.001 ms	- Mb
=> alma	0.020 ms	- Mb
=> cdc_googletagmanager	0.000 ms	- Mb
=> alma	0.011 ms	- Mb
=> cdc_googletagmanager	0.001 ms	- Mb
=> alma	0.020 ms	- Mb
=> cdc_googletagmanager	0.001 ms	- Mb
=> alma	0.012 ms	- Mb
=> cdc_googletagmanager	0.001 ms	- Mb
=> alma	0.009 ms	- Mb
=> cdc_googletagmanager	0.000 ms	- Mb
=> alma	0.009 ms	- Mb
=> cdc_googletagmanager	0.001 ms	- Mb
=> alma	0.018 ms	- Mb
=> cdc_googletagmanager	0.001 ms	- Mb
=> alma	0.010 ms	- Mb
=> cdc_googletagmanager	0.001 ms	- Mb
=> alma	0.009 ms	- Mb
=> cdc_googletagmanager	0.000 ms	- Mb
=> alma	0.008 ms	- Mb
=> cdc_googletagmanager	0.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.001 ms	- Mb
=> alma	0.009 ms	- Mb
=> cdc_googletagmanager	0.001 ms	- Mb
=> alma	0.020 ms	- Mb
=> cdc_googletagmanager	0.000 ms	- Mb
=> alma	0.011 ms	- Mb
=> cdc_googletagmanager	0.001 ms	- Mb
=> alma	0.021 ms	- Mb
=> cdc_googletagmanager	0.000 ms	- Mb
=> alma	0.014 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.011 ms	- Mb
=> cdc_googletagmanager	0.000 ms	- Mb
=> alma	0.009 ms	- Mb
=> cdc_googletagmanager	0.000 ms	- Mb
=> alma	0.008 ms	- Mb
=> cdc_googletagmanager	0.001 ms	- Mb
=> alma	0.022 ms	- Mb
=> cdc_googletagmanager	0.001 ms	- Mb
=> alma	0.012 ms	- Mb
=> cdc_googletagmanager	0.000 ms	- Mb
=> alma	0.009 ms	- Mb
=> cdc_googletagmanager	0.000 ms	- Mb
=> alma	0.008 ms	- Mb
=> cdc_googletagmanager	0.001 ms	- Mb
=> alma	0.020 ms	- Mb
=> cdc_googletagmanager	0.000 ms	- Mb
=> alma	0.011 ms	- Mb
=> cdc_googletagmanager	0.001 ms	- Mb
=> alma	0.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.009 ms	- Mb
=> cdc_googletagmanager	0.000 ms	- Mb
=> alma	0.018 ms	- Mb
=> cdc_googletagmanager	0.001 ms	- Mb
=> alma	0.010 ms	- Mb
=> cdc_googletagmanager	0.000 ms	- Mb
=> alma	0.009 ms	- Mb
=> cdc_googletagmanager	0.001 ms	- Mb
=> alma	0.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.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.019 ms	- Mb
=> cdc_googletagmanager	0.001 ms	- Mb
=> alma	0.011 ms	- Mb
=> cdc_googletagmanager	0.000 ms	- Mb
=> alma	0.010 ms	- Mb
=> cdc_googletagmanager	0.001 ms	- Mb
=> alma	0.009 ms	- Mb
=> cdc_googletagmanager	0.001 ms	- Mb
=> alma	0.017 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.009 ms	- Mb
=> cdc_googletagmanager	0.001 ms	- Mb
=> alma	0.021 ms	- Mb
=> cdc_googletagmanager	0.000 ms	- Mb
=> alma	0.012 ms	- Mb
=> cdc_googletagmanager	0.000 ms	- Mb
=> alma	0.010 ms	- Mb
=> cdc_googletagmanager	0.000 ms	- Mb
=> alma	0.010 ms	- Mb
=> cdc_googletagmanager	0.001 ms	- Mb
=> alma	0.026 ms	- Mb
=> cdc_googletagmanager	0.001 ms	- Mb
=> alma	0.017 ms	- Mb
=> cdc_googletagmanager	0.001 ms	- Mb
=> alma	0.022 ms	- Mb
=> cdc_googletagmanager	0.001 ms	- Mb
=> alma	0.012 ms	- Mb
=> cdc_googletagmanager	0.000 ms	- Mb
=> alma	0.010 ms	- Mb
=> cdc_googletagmanager	0.000 ms	- Mb
=> alma	0.009 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.001 ms	- Mb
=> alma	0.009 ms	- Mb
=> cdc_googletagmanager	0.000 ms	- Mb
=> alma	0.008 ms	- Mb
=> cdc_googletagmanager	0.001 ms	- Mb
=> alma	0.022 ms	- Mb
=> cdc_googletagmanager	0.001 ms	- Mb
=> alma	0.012 ms	- Mb
=> cdc_googletagmanager	0.000 ms	- Mb
=> alma	0.009 ms	- Mb
=> cdc_googletagmanager	0.001 ms	- Mb
=> alma	0.012 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.025 ms	- Mb
=> cdc_googletagmanager	0.000 ms	- Mb
=> alma	0.012 ms	- Mb
=> cdc_googletagmanager	0.000 ms	- Mb
=> alma	0.009 ms	- Mb
=> cdc_googletagmanager	0.000 ms	- Mb
=> alma	0.009 ms	- Mb
=> cdc_googletagmanager	0.000 ms	- Mb
=> alma	0.019 ms	- Mb
=> cdc_googletagmanager	0.001 ms	- Mb
=> alma	0.010 ms	- Mb
=> cdc_googletagmanager	0.000 ms	- Mb
=> alma	0.009 ms	- Mb
=> cdc_googletagmanager	0.000 ms	- Mb
=> alma	0.008 ms	- Mb
=> cdc_googletagmanager	0.001 ms	- Mb
=> alma	0.021 ms	- Mb
=> cdc_googletagmanager	0.000 ms	- Mb
=> alma	0.011 ms	- Mb
=> cdc_googletagmanager	0.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.023 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.000 ms	- Mb
=> alma	0.012 ms	- Mb
=> cdc_googletagmanager	0.000 ms	- Mb
=> alma	0.009 ms	- Mb
=> cdc_googletagmanager	0.001 ms	- Mb
=> alma	0.009 ms	- Mb
=> cdc_googletagmanager	0.001 ms	- Mb
=> alma	0.021 ms	- Mb
=> cdc_googletagmanager	0.001 ms	- Mb
=> alma	0.010 ms	- Mb
=> cdc_googletagmanager	0.000 ms	- Mb
=> alma	0.010 ms	- Mb
=> cdc_googletagmanager	0.000 ms	- Mb
=> alma	0.008 ms	- Mb
=> cdc_googletagmanager	0.001 ms	- Mb
=> alma	0.021 ms	- Mb
=> cdc_googletagmanager	0.000 ms	- Mb
=> alma	0.011 ms	- Mb
=> cdc_googletagmanager	0.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.022 ms	- Mb
=> cdc_googletagmanager	0.001 ms	- Mb
=> alma	0.010 ms	- Mb
=> cdc_googletagmanager	0.001 ms	- Mb
=> alma	0.021 ms	- Mb
=> cdc_googletagmanager	0.001 ms	- Mb
=> alma	0.011 ms	- Mb
=> cdc_googletagmanager	0.001 ms	- Mb
=> alma	0.010 ms	- Mb
=> cdc_googletagmanager	0.001 ms	- Mb
=> alma	0.021 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.021 ms	- Mb
=> cdc_googletagmanager	0.000 ms	- Mb
=> alma	0.011 ms	- Mb
=> cdc_googletagmanager	0.000 ms	- Mb
=> alma	0.009 ms	- Mb
displayNavLanguageBlock	2.666 ms	0.05 Mb
=> ps_languageselector (widget)	2.666 ms	0.05 Mb
displayNavCustomerSignInBlock	2.444 ms	0.06 Mb
=> ps_customersignin (widget)	2.444 ms	0.06 Mb
displayNav1	1.597 ms	0.09 Mb
=> ps_contactinfo (widget)	1.597 ms	0.09 Mb
displayFooterPart1	1.522 ms	0.06 Mb
=> ps_linklist (widget)	1.522 ms	0.06 Mb
displaySocialMediaBlock	1.395 ms	0.07 Mb
=> ps_socialfollow (widget)	1.395 ms	0.07 Mb
displayMyaccountcblock	1.313 ms	0.06 Mb
=> ps_customeraccountlinks (widget)	1.313 ms	0.06 Mb
DisplayPaymentIcon	1.228 ms	0.06 Mb
=> tvcmspaymenticon	1.228 ms	0.06 Mb
DisplayNavWishlistBlocksticky	1.069 ms	0.06 Mb
=> tvcmswishlist	1.069 ms	0.06 Mb
displayContactCinfo	0.908 ms	0.04 Mb
=> ps_contactinfo (widget)	0.908 ms	0.04 Mb
displayNavCurrencyBlock	0.870 ms	0.05 Mb
=> ps_currencyselector (widget)	0.870 ms	0.05 Mb
DisplayNavProductCompareBlock	0.349 ms	0.02 Mb
=> tvcmsproductcompare	0.195 ms	0.01 Mb
=> tvcmsproductcompare	0.154 ms	0.01 Mb
ProductSearchProvider	0.316 ms	0.07 Mb
=> ps_facetedsearch	0.316 ms	0.07 Mb
ActionFrontControllerSetMedia	0.203 ms	0.01 Mb
=> blockreassurance	0.123 ms	- Mb
=> ps_socialfollow	0.035 ms	- Mb
=> ps_emailalerts	0.045 ms	- Mb
DisplayProductComparesticky	0.203 ms	0.01 Mb
=> tvcmsproductcompare	0.203 ms	0.01 Mb
DisplayProductListStockIndicator	0.196 ms	0.01 Mb
=> tvcmsstockinfo	0.013 ms	- Mb
=> tvcmsstockinfo	0.008 ms	- Mb
=> tvcmsstockinfo	0.009 ms	- Mb
=> tvcmsstockinfo	0.007 ms	- Mb
=> tvcmsstockinfo	0.008 ms	- Mb
=> tvcmsstockinfo	0.007 ms	- Mb
=> tvcmsstockinfo	0.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.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.009 ms	- Mb
=> tvcmsstockinfo	0.010 ms	- Mb
=> tvcmsstockinfo	0.012 ms	- Mb
=> tvcmsstockinfo	0.008 ms	- Mb
=> tvcmsstockinfo	0.008 ms	- Mb
=> tvcmsstockinfo	0.007 ms	- Mb
=> tvcmsstockinfo	0.009 ms	- Mb
=> tvcmsstockinfo	0.008 ms	- Mb
DisplayFooterPart2	0.180 ms	0.03 Mb
=> tvcmsfooterlogo	0.180 ms	0.03 Mb
DisplayFacetedSearchBlock	0.163 ms	0.07 Mb
=> ps_facetedsearch	0.163 ms	0.07 Mb
DisplayCopyRightText	0.135 ms	0.02 Mb
=> tvcmscustomsetting	0.135 ms	0.02 Mb
ModuleRoutes	0.070 ms	- Mb
=> alma	0.070 ms	- Mb
DisplayTopOfferText	0.010 ms	- Mb
=> tvcmscustomsetting	0.008 ms	- Mb
=> tvcmscustomsetting	0.002 ms	- Mb
DisplayBeforeBodyClosingTag	0.009 ms	- Mb
=> cdc_googletagmanager	0.009 ms	- Mb
DisplayCustomCss	0.006 ms	- Mb
=> tvcmscustomcssjs	0.006 ms	- Mb
DisplayOverrideTemplate	0.005 ms	- Mb
=> ets_advancedcaptcha	0.005 ms	- Mb
DisplayFooter	0.004 ms	- Mb
=> ganalyticspro	0.004 ms	- Mb
DisplayNavFullWidth	0.004 ms	- Mb
=> blockreassurance	0.004 ms	- Mb
DisplayCustomJs	0.004 ms	- Mb
=> tvcmscustomcssjs	0.004 ms	- Mb
42 hook(s)	1681 ms	52.36 Mb

239 queries	SELECT XX FROM `preXX_specific_price` WHERE id_product = XX LIMIT XX
238 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)
238 queries	SELECT `id_tax_rules_group` FROM `preXX_product_shop` WHERE `id_product` = XX AND id_shop=XX LIMIT XX
238 queries	SELECT `reduction` FROM `preXX_product_group_reduction_cache` WHERE `id_product` = XX AND `id_group` = XX LIMIT XX
232 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
224 queries	SELECT *, ( IF (`id_group` = XX, XX, XX) + IF (`id_country` = XX, XX, XX) + IF (`id_currency` = XX, XX, XX) + IF (`id_shop` = XX, XX, XX) + IF (`id_customer` = XX, XX, XX)) AS `score` FROM `preXX_specific_price` WHERE `id_shop` IN (XX, XX) AND `id_currency` IN (XX, XX) AND `id_country` IN (XX, XX) AND `id_group` IN (XX, XX) AND `id_product` = XX AND `id_customer` = XX AND `id_product_attribute` = XX AND `id_cart` = XX AND (`from` = 'XX-XX-XX XX:XX:XX' OR 'XX-XX-XX XX:XX:XX' >= `from`) AND (`to` = 'XX-XX-XX XX:XX:XX' OR 'XX-XX-XX XX:XX:XX' <= `to`) AND IF(`from_quantity` > XX, `from_quantity`, XX) <= XX ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT XX
216 queries	SELECT product_attribute_shop.id_product_attribute FROM preXX_product_attribute pa INNER JOIN preXX_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = XX) WHERE pa.id_product = XX LIMIT XX
48 queries	SELECT (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS grade FROM `preXX_tvcmsproduct_comment` pc WHERE pc.`id_product` = XX AND pc.`deleted` = XX AND pc.`validate` = XX LIMIT XX
48 queries	SELECT (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS 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
33 queries	SELECT `id_product_attribute` FROM `preXX_product_attribute` WHERE `id_product` = XX
33 queries	SELECT image_shop.`cover`, i.`id_image`, il.`legend`, i.`position` FROM `preXX_image` i INNER JOIN preXX_image_shop image_shop ON (image_shop.id_image = i.id_image AND image_shop.id_shop = XX) LEFT JOIN `preXX_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = XX) WHERE i.`id_product` = XX ORDER BY `position`
33 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
33 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
29 queries	SELECT image_shop.`id_image` FROM `preXX_image` i INNER JOIN preXX_image_shop image_shop ON (image_shop.id_image = i.id_image AND image_shop.id_shop = XX) WHERE i.`id_product` = XX AND image_shop.`cover` = XX LIMIT XX
29 queries	SELECT name FROM preXX_category_lang WHERE id_shop = XX AND id_lang = XX AND id_category = XX LIMIT XX
29 queries	SELECT * FROM `preXX_product` a LEFT JOIN `preXX_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = XX LEFT JOIN `preXX_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = XX WHERE (a.`id_product` = XX) AND (b.`id_shop` = XX) LIMIT XX
26 queries	SELECT name, value, pf.id_feature, f.position, fvl.id_feature_value FROM preXX_feature_product pf LEFT JOIN preXX_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = XX) LEFT JOIN preXX_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = XX) LEFT JOIN preXX_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = XX) INNER JOIN preXX_feature_shop feature_shop ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = XX) WHERE pf.id_product = XX ORDER BY f.position ASC
21 queries	SELECT p., ps., pl.*, sa.out_of_stock, IFNULL(sa.quantity, XX) as quantity, (DATEDIFF( p.`date_add`, DATE_SUB( 'XX-XX-XX XX:XX:XX', INTERVAL XX DAY ) ) > XX) as new FROM preXX_product p LEFT JOIN preXX_product_lang pl ON pl.id_product = p.id_product AND pl.id_shop = XX AND pl.id_lang = XX LEFT JOIN preXX_stock_available sa ON sa.id_product = p.id_product AND sa.id_product_attribute = XX AND sa.id_shop = XX LEFT JOIN preXX_product_shop ps ON ps.id_product = p.id_product AND ps.id_shop = XX WHERE p.id_product IN (XX)
17 queries	SELECT cl.`link_rewrite` FROM `preXX_category_lang` cl WHERE `id_lang` = XX AND cl.id_shop = XX AND cl.`id_category` = XX LIMIT XX
16 queries	SELECT `id_module` FROM `preXX_module_shop` WHERE `id_module` = XX AND `id_shop` = XX LIMIT XX
14 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
14 queries	SELECT * FROM `preXX_category_lang` WHERE `id_category` = XX AND `id_shop` = XX
12 queries	SELECT COUNT(`id_tvcmsproduct_comment`) AS "nbr" FROM `preXX_tvcmsproduct_comment` pc WHERE `id_product` = XX AND `validate` = XX LIMIT XX
12 queries	SELECT * 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
12 queries	SELECT * FROM `preXX_product_lang` WHERE `id_product` = XX AND `id_shop` = XX
12 queries	SELECT DISTINCT pl.name as name FROM `preXX_product_lang` pl WHERE (pl.id_product = XX) AND (pl.id_lang = XX AND pl.id_shop = XX ) LIMIT XX
10 queries	SELECT mr.* FROM preXX_tvcmsmegamenu_row_shop mr WHERE mr.`id_shop` = XX AND mr.id_tvcmsmegamenu = XX AND mr.`active` = XX
8 queries	SELECT v., vl., IF(lifvlv.`url_name` IS NULL OR lifvlv.`url_name` = "", NULL, lifvlv.`url_name`) AS url_name, IF(lifvlv.`meta_title` IS NULL OR lifvlv.`meta_title` = "", NULL, lifvlv.`meta_title`) AS meta_title FROM `preXX_feature_value` v LEFT JOIN `preXX_feature_value_lang` vl ON (v.`id_feature_value` = vl.`id_feature_value` AND vl.`id_lang` = XX) LEFT JOIN `preXX_layered_indexable_feature_value_lang_value` lifvlv ON (v.`id_feature_value` = lifvlv.`id_feature_value` AND lifvlv.`id_lang` = XX) WHERE v.`id_feature` = XX ORDER BY vl.`value` ASC
8 queries	SELECT *, ( IF (`id_group` = XX, XX, XX) + IF (`id_country` = XX, XX, XX) + IF (`id_currency` = XX, XX, XX) + IF (`id_shop` = XX, XX, XX) + IF (`id_customer` = XX, XX, XX)) AS `score` FROM `preXX_specific_price` WHERE `id_shop` IN (XX, XX) AND `id_currency` IN (XX, XX) AND `id_country` IN (XX, XX) AND `id_group` IN (XX, XX) AND `id_product` = XX AND `id_customer` = XX AND `id_product_attribute` IN (XX, XX) AND `id_cart` = XX AND (`from` = 'XX-XX-XX XX:XX:XX' OR 'XX-XX-XX XX:XX:XX' >= `from`) AND (`to` = 'XX-XX-XX XX:XX:XX' OR 'XX-XX-XX XX:XX:XX' <= `to`) AND IF(`from_quantity` > XX, `from_quantity`, XX) <= XX ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT XX
7 queries	SELECT * FROM `preXX_category` a LEFT JOIN `preXX_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = XX LEFT JOIN `preXX_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = XX WHERE (a.`id_category` = XX) AND (b.`id_shop` = XX) LIMIT XX
7 queries	SELECT fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM preXX_product p LEFT JOIN preXX_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN preXX_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN preXX_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, XX) = sa.id_product_attribute AND sa.id_shop = XX AND sa.id_shop_group = XX ) LEFT JOIN preXX_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN preXX_category_product cp ON (p.id_product = cp.id_product) INNER JOIN preXX_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = XX AND ps.active = TRUE) INNER JOIN preXX_category c ON (cp.id_category = c.id_category AND c.active=XX) LEFT JOIN preXX_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN preXX_feature_product fp ON (p.id_product = fp.id_product) WHERE ((fp.id_feature_value IN (XX, XX, XX, XX, XX, XX, XX, XX, XX, XX, XX))) AND ps.id_shop='XX' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='XX' AND c.nleft>=XX AND c.nright<=XX GROUP BY p.id_product) p INNER JOIN preXX_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN preXX_feature_product fp_XX ON (p.id_product = fp_XX.id_product) WHERE ((fp.id_feature=XX)) AND ((fp_XX.id_feature_value IN (XX, XX, XX, XX, XX, XX, XX, XX, XX, XX, XX))) GROUP BY fp.id_feature_value
7 queries	SELECT `id_country` FROM `preXX_country` WHERE `iso_code` = 'FR' LIMIT XX
5 queries	SELECT * 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 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
5 queries	SELECT * FROM `preXX_country_lang` WHERE `id_country` = XX
5 queries	SELECT `name` FROM `preXX_country_lang` WHERE `id_lang` = XX AND `id_country` = XX LIMIT XX
4 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
4 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
4 queries	SELECT * FROM `preXX_product_attribute_lang` WHERE `id_product_attribute` = XX
4 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
4 queries	SELECT a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, agl.`public_name` as `public_group`, pa.`reference`, pa.`eanXX`, pa.`isbn`, pa.`upc`, pa.`mpn`, pal.`available_now`, pal.`available_later` FROM `preXX_attribute` a LEFT JOIN `preXX_attribute_lang` al ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = XX) LEFT JOIN `preXX_product_attribute_combination` pac ON (pac.`id_attribute` = a.`id_attribute`) LEFT JOIN `preXX_product_attribute` pa ON (pa.`id_product_attribute` = pac.`id_product_attribute`) INNER JOIN preXX_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = XX) LEFT JOIN `preXX_product_attribute_lang` pal ON (pal.`id_product_attribute` = pac.`id_product_attribute` AND pal.`id_lang` = XX) LEFT JOIN `preXX_attribute_group_lang` agl ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = XX) WHERE pa.`id_product` = XX AND pac.`id_product_attribute` = XX AND agl.`id_lang` = XX
3 queries	SELECT 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 `need_identification_number` FROM `preXX_country` WHERE `id_country` = 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 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 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
2 queries	SELECT `id_category` FROM `preXX_category_shop` WHERE `id_category` = XX AND `id_shop` = XX LIMIT XX
2 queries	SELECT p., product_shop., stock.out_of_stock, IFNULL(stock.quantity, XX) as quantity, pl.`description`, pl.`description_short`, pl.`link_rewrite`, pl.`meta_description`, pl.`meta_keywords`, pl.`meta_title`, pl.`name`, pl.`available_now`, pl.`available_later`, image_shop.`id_image` id_image, il.`legend`, m.`name` AS manufacturer_name, (DATEDIFF(product_shop.`date_add`, DATE_SUB( "XX-XX-XX XX:XX:XX", INTERVAL XX DAY ) ) > XX) as new, product_attribute_shop.minimal_quantity AS product_attribute_minimal_quantity, IFNULL(product_attribute_shop.id_product_attribute,XX) id_product_attribute FROM `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_module as id, active FROM preXX_module WHERE name = "pm_advancedcookiebanner" AND active = 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 `name` FROM `preXX_manufacturer` WHERE `id_manufacturer` = XX AND `active` = XX LIMIT XX
2 queries	SELECT `id_lang` FROM `preXX_lang` WHERE `locale` = 'fr-fr' OR `language_code` = 'fr-fr' LIMIT XX

Name	Instances	Source
Category	80	/controllers/front/listing/CategoryController.php:78 (__construct) [id: 2] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 37] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 36] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 42] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 49] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 58] /classes/Meta.php:380 (__construct) [id: 2] /classes/PrestaShopCollection.php:385 (hydrateCollection) [id: ] /modules/ganalyticspro/lib/gtag/categoryTag.php:57 (__construct) [id: 2] /modules/ganalyticspro/lib/moduleTools.php:141 (__construct) [id: 2] /modules/ganalyticspro/lib/moduleTools.php:141 (__construct) [id: 2] /classes/Link.php:402 (__construct) [id: 2] /modules/ps_facetedsearch/src/Product/Search.php:364 (__construct) [id: 2] /modules/ps_facetedsearch/src/Filters/Block.php:157 (__construct) [id: 2] /modules/cdc_googletagmanager/cdc_googletagmanager.php:1313 (__construct) [id: 2] /modules/cdc_googletagmanager/classes/gtm/DataLayerItem.php:109 (__construct) [id: 174] /modules/cdc_googletagmanager/cdc_googletagmanager.php:1374 (__construct) [id: 2] /modules/cdc_googletagmanager/cdc_googletagmanager.php:1323 (__construct) [id: 115] /modules/cdc_googletagmanager/cdc_googletagmanager.php:1323 (__construct) [id: 37] /modules/cdc_googletagmanager/cdc_googletagmanager.php:1323 (__construct) [id: 115] /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: 174] /modules/cdc_googletagmanager/cdc_googletagmanager.php:1323 (__construct) [id: 115] /modules/cdc_googletagmanager/cdc_googletagmanager.php:1323 (__construct) [id: 37] /modules/cdc_googletagmanager/cdc_googletagmanager.php:1323 (__construct) [id: 115] /modules/cdc_googletagmanager/classes/gtm/DataLayerItem.php:109 (__construct) [id: 165] /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: 174] /modules/cdc_googletagmanager/cdc_googletagmanager.php:1323 (__construct) [id: 115] /modules/cdc_googletagmanager/cdc_googletagmanager.php:1323 (__construct) [id: 37] /modules/cdc_googletagmanager/cdc_googletagmanager.php:1323 (__construct) [id: 115] /modules/cdc_googletagmanager/classes/gtm/DataLayerItem.php:109 (__construct) [id: 165] /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: 174] /modules/cdc_googletagmanager/cdc_googletagmanager.php:1323 (__construct) [id: 115] /modules/cdc_googletagmanager/cdc_googletagmanager.php:1323 (__construct) [id: 37] /modules/cdc_googletagmanager/cdc_googletagmanager.php:1323 (__construct) [id: 115] /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: 165] /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: 174] /modules/cdc_googletagmanager/cdc_googletagmanager.php:1323 (__construct) [id: 115] /modules/cdc_googletagmanager/cdc_googletagmanager.php:1323 (__construct) [id: 37] /modules/cdc_googletagmanager/cdc_googletagmanager.php:1323 (__construct) [id: 115] /modules/cdc_googletagmanager/classes/gtm/DataLayerItem.php:109 (__construct) [id: 174] /modules/cdc_googletagmanager/cdc_googletagmanager.php:1323 (__construct) [id: 115] /modules/cdc_googletagmanager/cdc_googletagmanager.php:1323 (__construct) [id: 37] /modules/cdc_googletagmanager/cdc_googletagmanager.php:1323 (__construct) [id: 115] /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	70	/classes/Link.php:113 (__construct) [id: 89] /classes/Link.php:113 (__construct) [id: 304] /classes/Link.php:113 (__construct) [id: 723] /classes/Link.php:113 (__construct) [id: 63] /classes/Link.php:113 (__construct) [id: 724] /classes/Link.php:113 (__construct) [id: 472] /classes/Link.php:113 (__construct) [id: 391] /classes/Link.php:113 (__construct) [id: 297] /classes/Link.php:113 (__construct) [id: 406] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 89] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 30] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 304] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 723] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 63] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 724] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 472] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 290] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 391] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 297] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 249] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 406] /classes/Link.php:113 (__construct) [id: 89] /classes/Link.php:113 (__construct) [id: 304] /classes/Link.php:113 (__construct) [id: 723] /classes/Link.php:113 (__construct) [id: 63] /classes/Link.php:113 (__construct) [id: 724] /classes/Link.php:113 (__construct) [id: 472] /classes/Link.php:113 (__construct) [id: 391] /classes/Link.php:113 (__construct) [id: 297] /classes/Link.php:113 (__construct) [id: 406] /modules/cdc_googletagmanager/services/Gtm_Product.php:164 (__construct) [id: 89] /modules/cdc_googletagmanager/services/Gtm_Product.php:164 (__construct) [id: 30] /modules/cdc_googletagmanager/services/Gtm_Product.php:164 (__construct) [id: 304] /modules/cdc_googletagmanager/services/Gtm_Product.php:164 (__construct) [id: 723] /modules/cdc_googletagmanager/services/Gtm_Product.php:164 (__construct) [id: 63] /modules/cdc_googletagmanager/services/Gtm_Product.php:164 (__construct) [id: 724] /modules/cdc_googletagmanager/services/Gtm_Product.php:164 (__construct) [id: 472] /modules/cdc_googletagmanager/services/Gtm_Product.php:164 (__construct) [id: 290] /modules/cdc_googletagmanager/services/Gtm_Product.php:164 (__construct) [id: 391] /modules/cdc_googletagmanager/services/Gtm_Product.php:164 (__construct) [id: 297] /modules/cdc_googletagmanager/services/Gtm_Product.php:164 (__construct) [id: 249] /modules/cdc_googletagmanager/services/Gtm_Product.php:164 (__construct) [id: 406] /classes/Link.php:113 (__construct) [id: 799] /classes/Link.php:113 (__construct) [id: 798] /classes/Link.php:113 (__construct) [id: 788] /classes/Link.php:113 (__construct) [id: 783] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 799] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 798] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 797] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 788] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 783] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 799] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 798] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 797] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 788] /classes/Link.php:113 (__construct) [id: 220] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 543] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 389] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 220] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 321] /classes/Link.php:113 (__construct) [id: 111] /classes/Link.php:113 (__construct) [id: 638] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 661] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 518] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 111] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 638] /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	4	/classes/Product.php:5912 (__construct) [id: 37] /classes/Product.php:5912 (__construct) [id: 79] /classes/Product.php:5912 (__construct) [id: 8] /classes/Product.php:5912 (__construct) [id: 122]
Address	4	/classes/shop/Shop.php:486 (__construct) [id: ] /classes/Product.php:3694 (initialize) [id: ] /classes/Product.php:3804 (__construct) [id: ] /classes/Product.php:5964 (__construct) [id: ]
State	3	/classes/controller/FrontController.php:1778 (__construct) [id: 0] /modules/ps_contactinfo/ps_contactinfo.php:93 (__construct) [id: 0] /modules/ps_contactinfo/ps_contactinfo.php:93 (__construct) [id: 0]
AddressFormat	3	/classes/controller/FrontController.php:1773 (generateAddress) [id: ] /modules/ps_contactinfo/ps_contactinfo.php:98 (generateAddress) [id: ] /modules/ps_contactinfo/ps_contactinfo.php:98 (generateAddress) [id: ]
Tax	2	/classes/tax/TaxRulesTaxManager.php:116 (__construct) [id: 1] /classes/tax/TaxRulesTaxManager.php:116 (__construct) [id: 1]
Cart	2	/classes/controller/FrontController.php:467 (__construct) [id: ] /classes/controller/FrontController.php:541 (__construct) [id: ]
TvcmsMegaMenuClass	1	/modules/tvcmsmegamenu/tvcmsmegamenu.php:1384 (__construct) [id: ]
Image	1	/modules/alma/lib/Services/ImageService.php:46 (__construct) [id: ]
Shop	1	/config/config.inc.php:117 (initialize) [id: 1]
Risk	1	/classes/controller/FrontController.php:1705 (__construct) [id: ]
Group	1	/classes/Cart.php:249 (getCurrent) [id: 1]
Customer	1	/config/config.inc.php:264 (__construct) [id: ]
ShopGroup	1	/classes/shop/Shop.php:561 (__construct) [id: 1]
Gender	1	/classes/controller/FrontController.php:1702 (__construct) [id: 0]

#	Query	Time (ms)	Rows	Filesort	Location
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	52.435 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)
2153	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	32.606 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)
499	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`)	28.792 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)
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 (14674, 14677, 22059, 22062, 22065, 22068, 14663, 14669, 22010, 22007, 14670))) 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 (14674, 14677, 22059, 22062, 22065, 22068, 14663, 14669, 22010, 22007, 14670))) GROUP BY fp.id_feature_value	20.315 ms	560	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)
231	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 = 472 ORDER BY f.position ASC	15.667 ms	7	Yes	/classes/Product.php:6021 /classes/Product.php:5824 (getFrontFeaturesStatic) /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)
120	SELECT SQL_NO_CACHE fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM pre2469_product p LEFT JOIN pre2469_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN pre2469_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN pre2469_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN pre2469_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN pre2469_category_product cp ON (p.id_product = cp.id_product) INNER JOIN pre2469_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN pre2469_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN pre2469_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN pre2469_feature_product fp ON (p.id_product = fp.id_product) WHERE ((fp.id_feature_value IN (14674, 14677, 22059, 22062, 22065, 22068, 14663, 14669, 22010, 22007, 14670))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=2 AND c.nright<=157 GROUP BY p.id_product) p INNER JOIN pre2469_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN pre2469_feature_product fp_1 ON (p.id_product = fp_1.id_product) WHERE ((fp.id_feature=13)) AND ((fp_1.id_feature_value IN (14674, 14677, 22059, 22062, 22065, 22068, 14663, 14669, 22010, 22007, 14670))) GROUP BY fp.id_feature_value	13.372 ms	560	Yes	/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:778 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:855 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:154 (getFeaturesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
114	SELECT SQL_NO_CACHE fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM pre2469_product p LEFT JOIN pre2469_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN pre2469_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN pre2469_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN pre2469_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN pre2469_category_product cp ON (p.id_product = cp.id_product) INNER JOIN pre2469_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN pre2469_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN pre2469_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN pre2469_feature_product fp ON (p.id_product = fp.id_product) WHERE ((fp.id_feature_value IN (14674, 14677, 22059, 22062, 22065, 22068, 14663, 14669, 22010, 22007, 14670))) 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 (14674, 14677, 22059, 22062, 22065, 22068, 14663, 14669, 22010, 22007, 14670))) GROUP BY fp.id_feature_value	13.292 ms	560	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)
2115	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` = 111 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` = 111 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1	13.235 ms	0		/classes/Cart.php:1430 /classes/Product.php:4361 (getProductQuantity) /classes/Product.php:5802 (getQuantity) /classes/Product.php:5990 (getProductProperties) /classes/Category.php:1074 (getProductsProperties) /src/Adapter/Category/CategoryProductSearchProvider.php:79 (getProducts) /src/Adapter/Category/CategoryProductSearchProvider.php:105 (getProductsOrCount) /modules/tvcmstabproducts/tvcmstabproducts.php:2708 (runQuery) /modules/tvcmsfeaturedproducts/tvcmsfeaturedproducts.php:158 (displayFeaturedProducts) /modules/tvcmsfeaturedproducts/tvcmsfeaturedproducts.php:281 (showFrontSideResult) /classes/Hook.php:1077 (hookdisplayLeftColumn) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:418 (coreCallHook) /classes/Hook.php:983 (callHookOn) /config/smarty.config.inc.php:201 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/prod/smarty/compile/v1_gardenia_11layouts_layout_left_column_tpl/1a/89/a7/1a89a734d096f5ad14ad4dbb33891e0facb00120_2.file.layout-both-columns.tpl.php:192 (__call) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/v1_gardenia_11layouts_layout_left_column_tpl/1a/89/a7/1a89a734d096f5ad14ad4dbb33891e0facb00120_2.file.layout-both-columns.tpl.php:74 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67293b29f16874_07033251) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/v1_gardenia_11layouts_layout_left_column_tpl/6d/33/66/6d33663adfbf67f07eddb2df7d930f4c5287edb8_2.file.layout-left-column.tpl.php:28 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67293b29efacf3_58320531) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/v1_gardenia_11layouts_layout_left_column_tpl/82/55/0e/82550e22f895f1760ff1e1a0c2d6c8c47e0de299_2.file.product-list.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67293b29eea393_23821434) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/v1_gardenia_11layouts_layout_left_column_tpl/37/3d/2c/373d2ce4c1a83676f8228aca20a47aac483b040b_2.file.category.tpl.php:29 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67293b29ed0a52_43895681) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/controller/FrontController.php:771 (fetch) /classes/controller/FrontController.php:753 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
278	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 = 249 ORDER BY f.position ASC	11.280 ms	6	Yes	/classes/Product.php:6021 /classes/Product.php:5824 (getFrontFeaturesStatic) /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)
126	SELECT SQL_NO_CACHE fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM pre2469_product p LEFT JOIN pre2469_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN pre2469_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN pre2469_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN pre2469_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN pre2469_category_product cp ON (p.id_product = cp.id_product) INNER JOIN pre2469_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN pre2469_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN pre2469_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN pre2469_feature_product fp ON (p.id_product = fp.id_product) WHERE ((fp.id_feature_value IN (14674, 14677, 22059, 22062, 22065, 22068, 14663, 14669, 22010, 22007, 14670))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=2 AND c.nright<=157 GROUP BY p.id_product) p INNER JOIN pre2469_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN pre2469_feature_product fp_1 ON (p.id_product = fp_1.id_product) WHERE ((fp.id_feature=16)) AND ((fp_1.id_feature_value IN (14674, 14677, 22059, 22062, 22065, 22068, 14663, 14669, 22010, 22007, 14670))) GROUP BY fp.id_feature_value	10.399 ms	560	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)
127	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 (14674, 14677, 22059, 22062, 22065, 22068, 14663, 14669, 22010, 22007, 14670))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=2 AND c.nright<=157 GROUP BY p.id_product) p INNER JOIN pre2469_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN pre2469_feature_product fp_1 ON (p.id_product = fp_1.id_product) WHERE ((fp.id_feature=20)) AND ((fp_1.id_feature_value IN (14674, 14677, 22059, 22062, 22065, 22068, 14663, 14669, 22010, 22007, 14670))) GROUP BY fp.id_feature_value	9.677 ms	560	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)
116	SELECT SQL_NO_CACHE fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM pre2469_product p LEFT JOIN pre2469_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN pre2469_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN pre2469_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN pre2469_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN pre2469_category_product cp ON (p.id_product = cp.id_product) INNER JOIN pre2469_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN pre2469_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN pre2469_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN pre2469_feature_product fp ON (p.id_product = fp.id_product) WHERE ((fp.id_feature_value IN (14674, 14677, 22059, 22062, 22065, 22068, 14663, 14669, 22010, 22007, 14670))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=2 AND c.nright<=157 GROUP BY p.id_product) p INNER JOIN pre2469_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN pre2469_feature_product fp_1 ON (p.id_product = fp_1.id_product) WHERE ((fp.id_feature=11)) AND ((fp_1.id_feature_value IN (14674, 14677, 22059, 22062, 22065, 22068, 14663, 14669, 22010, 22007, 14670))) GROUP BY fp.id_feature_value	8.647 ms	560	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 (14674, 14677, 22059, 22062, 22065, 22068, 14663, 14669, 22010, 22007, 14670))) 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 (14674, 14677, 22059, 22062, 22065, 22068, 14663, 14669, 22010, 22007, 14670))) GROUP BY fp.id_feature_value	8.569 ms	560	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)
1916	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` = 677)	8.284 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)
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 (14674, 14677, 22059, 22062, 22065, 22068, 14663, 14669, 22010, 22007, 14670))) 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 (14674, 14677, 22059, 22062, 22065, 22068, 14663, 14669, 22010, 22007, 14670))) AND cg.id_group='1' AND c.nleft>2 AND c.nright<157 GROUP BY cp.id_category	7.760 ms	560	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)
1378	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` = 400 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.362 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)
232	SELECT SQL_NO_CACHE image_shop.`id_image` FROM `pre2469_image` i INNER JOIN pre2469_image_shop image_shop ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1) WHERE i.`id_product` = 290 AND image_shop.`cover` = 1 LIMIT 1	7.293 ms	4		/classes/Product.php:3570 /classes/Product.php:5643 (getCover) /classes/ProductAssembler.php:209 (getProductProperties) /classes/controller/ProductListingFrontController.php:108 (assembleProducts) /classes/controller/ProductListingFrontController.php:379 (prepareMultipleProductsForTemplate) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
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 (14674, 14677, 22059, 22062, 22065, 22068, 14663, 14669, 22010, 22007, 14670))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=2 AND c.nright<=157 GROUP BY p.id_product) p INNER JOIN pre2469_category_product cp ON (p.id_product = cp.id_product) GROUP BY p.id_product ORDER BY p.position ASC, p.id_product DESC	7.048 ms	140	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)
113	SELECT SQL_NO_CACHE psi.price_min, MIN(price_min) as min, MAX(price_max) as max FROM pre2469_product p INNER JOIN pre2469_layered_price_index psi ON (psi.id_product = p.id_product AND psi.id_shop = 1 AND psi.id_currency = 1 AND psi.id_country = 8) 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_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 (14674, 14677, 22059, 22062, 22065, 22068, 14663, 14669, 22010, 22007, 14670))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=2 AND c.nright<=157	6.565 ms	35		/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:57 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:250 (getMinMaxPriceValue) /modules/ps_facetedsearch/src/Filters/Block.php:131 (getPriceRangeBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
216	SELECT SQL_NO_CACHE `reduction` FROM `pre2469_product_group_reduction_cache` WHERE `id_product` = 724 AND `id_group` = 1 LIMIT 1	6.493 ms	0		/classes/GroupReduction.php:156 /classes/Product.php:3990 (getValueForProduct) /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)
190	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` = 723)	6.289 ms	1		/classes/Product.php:3860 /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)
60	SELECT SQL_NO_CACHE * FROM `pre2469_hook` h ORDER BY `name`	6.174 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)
119	SELECT SQL_NO_CACHE 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 `pre2469_feature_value` v LEFT JOIN `pre2469_feature_value_lang` vl ON (v.`id_feature_value` = vl.`id_feature_value` AND vl.`id_lang` = 1) LEFT JOIN `pre2469_layered_indexable_feature_value_lang_value` lifvlv ON (v.`id_feature_value` = lifvlv.`id_feature_value` AND lifvlv.`id_lang` = 1) WHERE v.`id_feature` = 12 ORDER BY vl.`value` ASC	5.861 ms	81	Yes	/modules/ps_facetedsearch/src/Filters/DataAccessor.php:204 /modules/ps_facetedsearch/src/Filters/Block.php:864 (getFeatureValues) /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)
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.772 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)
170	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 = 30 ORDER BY f.position ASC	5.701 ms	6	Yes	/classes/Product.php:6021 /classes/Product.php:5824 (getFrontFeaturesStatic) /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)
185	SELECT SQL_NO_CACHE name FROM pre2469_category_lang WHERE id_shop = 1 AND id_lang = 1 AND id_category = 165 LIMIT 1	5.549 ms	1		/classes/Product.php:5659 /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)
1974	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 = 722 LIMIT 1	5.500 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)
343	SELECT SQL_NO_CACHE * FROM `pre2469_category` a LEFT JOIN `pre2469_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1 WHERE (a.`id_category` = 165) LIMIT 1	5.411 ms	1		/src/Adapter/EntityMapper.php:71 /classes/ObjectModel.php:283 (load) /tools/profiling/ObjectModel.php:32 (__construct) /classes/Category.php:164 (__construct) /modules/cdc_googletagmanager/classes/gtm/DataLayerItem.php:109 (__construct) /modules/cdc_googletagmanager/classes/DataLayer.php:67 (__construct) /modules/cdc_googletagmanager/classes/DataLayer.php:145 (addItem) /modules/cdc_googletagmanager/classes/DataLayer.php:166 (addProductList) /modules/cdc_googletagmanager/cdc_googletagmanager.php:1549 (addCategory) /modules/cdc_googletagmanager/cdc_googletagmanager.php:1046 (displayCategory) /modules/cdc_googletagmanager/cdc_googletagmanager.php:635 (generateEnhancedEcommerce) /classes/Hook.php:1077 (hookDisplayAfterTitleTag) /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/08/89/a8/0889a8be68444b534d4c314300ca23e2c51a9dde_2.file.head.tpl.php:233 (__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/08/89/a8/0889a8be68444b534d4c314300ca23e2c51a9dde_2.file.head.tpl.php:32 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67293b29f3d974_45312362) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /var/cache/prod/smarty/compile/v1_gardenia_11layouts_layout_left_column_tpl/1a/89/a7/1a89a734d096f5ad14ad4dbb33891e0facb00120_2.file.layout-both-columns.tpl.php:102 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/v1_gardenia_11layouts_layout_left_column_tpl/1a/89/a7/1a89a734d096f5ad14ad4dbb33891e0facb00120_2.file.layout-both-columns.tpl.php:40 (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)
214	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` = 724)	5.371 ms	1		/classes/Product.php:3860 /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)
854	SELECT SQL_NO_CACHE 1 FROM `pre2469_specific_price` WHERE id_product = 179 LIMIT 1	5.258 ms	1		/classes/SpecificPrice.php:435 /classes/SpecificPrice.php:523 (couldHaveSpecificPrice) /classes/Product.php:3827 (getSpecificPrice) /classes/Product.php:3717 (priceCalculation) /classes/Tools.php:1700 (getPriceStatic) /classes/Product.php:3400 (orderbyPrice) /modules/tvcmstabproducts/tvcmstabproducts.php:2817 (getPricesDrop) /modules/tvcmsspecialproducts/tvcmsspecialproducts.php:157 (displaySpecialProducts) /modules/tvcmsspecialproducts/tvcmsspecialproducts.php:268 (showFrontSideResult) /classes/Hook.php:1077 (hookdisplayLeftColumn) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:418 (coreCallHook) /classes/Hook.php:983 (callHookOn) /config/smarty.config.inc.php:201 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/prod/smarty/compile/v1_gardenia_11layouts_layout_left_column_tpl/1a/89/a7/1a89a734d096f5ad14ad4dbb33891e0facb00120_2.file.layout-both-columns.tpl.php:192 (__call) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/v1_gardenia_11layouts_layout_left_column_tpl/1a/89/a7/1a89a734d096f5ad14ad4dbb33891e0facb00120_2.file.layout-both-columns.tpl.php:74 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67293b29f16874_07033251) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/v1_gardenia_11layouts_layout_left_column_tpl/6d/33/66/6d33663adfbf67f07eddb2df7d930f4c5287edb8_2.file.layout-left-column.tpl.php:28 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67293b29efacf3_58320531) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/v1_gardenia_11layouts_layout_left_column_tpl/82/55/0e/82550e22f895f1760ff1e1a0c2d6c8c47e0de299_2.file.product-list.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67293b29eea393_23821434) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/v1_gardenia_11layouts_layout_left_column_tpl/37/3d/2c/373d2ce4c1a83676f8228aca20a47aac483b040b_2.file.category.tpl.php:29 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67293b29ed0a52_43895681) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/controller/FrontController.php:771 (fetch) /classes/controller/FrontController.php:753 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
2159	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 = 281 ORDER BY f.position ASC	5.180 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)
2163	SELECT SQL_NO_CACHE name FROM pre2469_category_lang WHERE id_shop = 1 AND id_lang = 1 AND id_category = 123 LIMIT 1	5.075 ms	1		/classes/Product.php:5659 /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)
344	SELECT SQL_NO_CACHE * FROM `pre2469_category_lang` WHERE `id_category` = 165 AND `id_shop` = 1	4.942 ms	1		/src/Adapter/EntityMapper.php:79 /classes/ObjectModel.php:283 (load) /tools/profiling/ObjectModel.php:32 (__construct) /classes/Category.php:164 (__construct) /modules/cdc_googletagmanager/classes/gtm/DataLayerItem.php:109 (__construct) /modules/cdc_googletagmanager/classes/DataLayer.php:67 (__construct) /modules/cdc_googletagmanager/classes/DataLayer.php:145 (addItem) /modules/cdc_googletagmanager/classes/DataLayer.php:166 (addProductList) /modules/cdc_googletagmanager/cdc_googletagmanager.php:1549 (addCategory) /modules/cdc_googletagmanager/cdc_googletagmanager.php:1046 (displayCategory) /modules/cdc_googletagmanager/cdc_googletagmanager.php:635 (generateEnhancedEcommerce) /classes/Hook.php:1077 (hookDisplayAfterTitleTag) /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/08/89/a8/0889a8be68444b534d4c314300ca23e2c51a9dde_2.file.head.tpl.php:233 (__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/08/89/a8/0889a8be68444b534d4c314300ca23e2c51a9dde_2.file.head.tpl.php:32 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67293b29f3d974_45312362) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /var/cache/prod/smarty/compile/v1_gardenia_11layouts_layout_left_column_tpl/1a/89/a7/1a89a734d096f5ad14ad4dbb33891e0facb00120_2.file.layout-both-columns.tpl.php:102 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/v1_gardenia_11layouts_layout_left_column_tpl/1a/89/a7/1a89a734d096f5ad14ad4dbb33891e0facb00120_2.file.layout-both-columns.tpl.php:40 (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)
354	SELECT SQL_NO_CACHE * FROM `pre2469_product` a LEFT JOIN `pre2469_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1 WHERE (a.`id_product` = 290) LIMIT 1	4.759 ms	1		/src/Adapter/EntityMapper.php:71 /classes/ObjectModel.php:283 (load) /tools/profiling/ObjectModel.php:32 (__construct) /classes/Product.php:725 (__construct) /modules/cdc_googletagmanager/services/Gtm_Product.php:164 (__construct) /modules/cdc_googletagmanager/classes/gtm/DataLayerItem.php:93 (getProductName) /modules/cdc_googletagmanager/classes/DataLayer.php:67 (__construct) /modules/cdc_googletagmanager/classes/DataLayer.php:145 (addItem) /modules/cdc_googletagmanager/classes/DataLayer.php:166 (addProductList) /modules/cdc_googletagmanager/cdc_googletagmanager.php:1549 (addCategory) /modules/cdc_googletagmanager/cdc_googletagmanager.php:1046 (displayCategory) /modules/cdc_googletagmanager/cdc_googletagmanager.php:635 (generateEnhancedEcommerce) /classes/Hook.php:1077 (hookDisplayAfterTitleTag) /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/08/89/a8/0889a8be68444b534d4c314300ca23e2c51a9dde_2.file.head.tpl.php:233 (__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/08/89/a8/0889a8be68444b534d4c314300ca23e2c51a9dde_2.file.head.tpl.php:32 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67293b29f3d974_45312362) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /var/cache/prod/smarty/compile/v1_gardenia_11layouts_layout_left_column_tpl/1a/89/a7/1a89a734d096f5ad14ad4dbb33891e0facb00120_2.file.layout-both-columns.tpl.php:102 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/v1_gardenia_11layouts_layout_left_column_tpl/1a/89/a7/1a89a734d096f5ad14ad4dbb33891e0facb00120_2.file.layout-both-columns.tpl.php:40 (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)
706	SELECT SQL_NO_CACHE `reduction` FROM `pre2469_product_group_reduction_cache` WHERE `id_product` = 107 AND `id_group` = 1 LIMIT 1	4.749 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)
146	SELECT SQL_NO_CACHE `id_hook`, `name` FROM `pre2469_hook` UNION SELECT `id_hook`, ha.`alias` as name FROM `pre2469_hook_alias` ha INNER JOIN `pre2469_hook` h ON ha.name = h.name	4.705 ms	0		/classes/Hook.php:1326 /classes/Hook.php:225 (getAllHookIds) /classes/tax/TaxManagerFactory.php:67 (getIdByName) /classes/tax/TaxManagerFactory.php:46 (execHookTaxManagerFactory) /classes/Product.php:3925 (getManager) /classes/Product.php:3717 (priceCalculation) /classes/Product.php:5692 (getPriceStatic) /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)
484	SELECT SQL_NO_CACHE p., product_shop., stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, pl.`description`, pl.`description_short`, pl.`link_rewrite`, pl.`meta_description`, pl.`meta_keywords`, pl.`meta_title`, pl.`name`, pl.`available_now`, pl.`available_later`, image_shop.`id_image` id_image, il.`legend`, m.`name` AS manufacturer_name, (DATEDIFF(product_shop.`date_add`, DATE_SUB( "2024-11-11 00:00:00", INTERVAL 1000 DAY ) ) > 0) as new, product_attribute_shop.minimal_quantity AS product_attribute_minimal_quantity, IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute FROM `pre2469_product` p INNER JOIN pre2469_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) LEFT JOIN `pre2469_product_lang` `pl` ON p.`id_product` = pl.`id_product` AND pl.`id_lang` = 1 AND pl.id_shop = 1 LEFT JOIN `pre2469_image_shop` `image_shop` ON image_shop.`id_product` = p.`id_product` AND image_shop.cover=1 AND image_shop.id_shop=1 LEFT JOIN `pre2469_image_lang` `il` ON image_shop.`id_image` = il.`id_image` AND il.`id_lang` = 1 LEFT JOIN `pre2469_manufacturer` `m` ON m.`id_manufacturer` = p.`id_manufacturer` LEFT JOIN `pre2469_product_attribute_shop` `product_attribute_shop` ON p.`id_product` = product_attribute_shop.`id_product` AND product_attribute_shop.`default_on` = 1 AND product_attribute_shop.id_shop=1 LEFT JOIN pre2469_stock_available stock ON (stock.id_product = `p`.id_product AND stock.id_product_attribute = 0 AND stock.id_shop = 1 AND stock.id_shop_group = 0 ) WHERE (product_shop.`active` = 1) AND (product_shop.`visibility` IN ("both", "catalog")) AND (DATEDIFF(product_shop.`date_add`, DATE_SUB( "2024-11-11 00:00:00", INTERVAL 1000 DAY ) ) > 0) AND (EXISTS(SELECT 1 FROM `pre2469_category_product` cp JOIN `pre2469_category_group` cg ON (cp.id_category = cg.id_category AND cg.`id_group` =1) WHERE cp.`id_product` = p.`id_product`)) ORDER BY product_shop.`date_add` DESC LIMIT 4	4.686 ms	2		/classes/Product.php:3110 /modules/tvcmstabproducts/tvcmstabproducts.php:2763 (getNewProducts) /modules/tvcmsnewproducts/tvcmsnewproducts.php:157 (displayNewProducts) /modules/tvcmsnewproducts/tvcmsnewproducts.php:266 (showFrontSideResult) /classes/Hook.php:1077 (hookdisplayLeftColumn) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:418 (coreCallHook) /classes/Hook.php:983 (callHookOn) /config/smarty.config.inc.php:201 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/prod/smarty/compile/v1_gardenia_11layouts_layout_left_column_tpl/1a/89/a7/1a89a734d096f5ad14ad4dbb33891e0facb00120_2.file.layout-both-columns.tpl.php:192 (__call) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/v1_gardenia_11layouts_layout_left_column_tpl/1a/89/a7/1a89a734d096f5ad14ad4dbb33891e0facb00120_2.file.layout-both-columns.tpl.php:74 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67293b29f16874_07033251) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/v1_gardenia_11layouts_layout_left_column_tpl/6d/33/66/6d33663adfbf67f07eddb2df7d930f4c5287edb8_2.file.layout-left-column.tpl.php:28 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67293b29efacf3_58320531) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/v1_gardenia_11layouts_layout_left_column_tpl/82/55/0e/82550e22f895f1760ff1e1a0c2d6c8c47e0de299_2.file.product-list.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67293b29eea393_23821434) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/v1_gardenia_11layouts_layout_left_column_tpl/37/3d/2c/373d2ce4c1a83676f8228aca20a47aac483b040b_2.file.category.tpl.php:29 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67293b29ed0a52_43895681) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/controller/FrontController.php:771 (fetch) /classes/controller/FrontController.php:753 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
1311	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 = 372 LIMIT 1	4.668 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)
456	SELECT SQL_NO_CACHE c., cl. FROM `pre2469_category` c INNER JOIN pre2469_category_shop category_shop ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1) LEFT JOIN `pre2469_category_lang` cl ON c.`id_category` = cl.`id_category` AND cl.id_shop = 1 WHERE 1 AND `id_lang` = 1 AND c.`active` = 1 ORDER BY c.`level_depth` ASC , category_shop.`position` ASC	4.659 ms	79	Yes	/classes/Category.php:799 /modules/tvcmssearch/tvcmssearch.php:100 (getNestedCategories) /modules/tvcmssearch/tvcmssearch.php:211 (getAllCategories) /classes/Hook.php:1077 (hookdisplayNavSearchBlock) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:418 (coreCallHook) /classes/Hook.php:983 (callHookOn) /config/smarty.config.inc.php:201 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/prod/smarty/compile/v1_gardenia_11layouts_layout_left_column_tpl/bd/95/e2/bd95e28a15f35124d814b1a25c3a08ce78345268_2.file.desk-header-7.tpl.php:37 (__call) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67293b2a281d57_86876041) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /var/cache/prod/smarty/compile/v1_gardenia_11layouts_layout_left_column_tpl/b1/6f/68/b16f68e6bb922534b635e7fa572aee543e9fb07a_2.file.desktop-header.tpl.php:25 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67293b2a270919_32767377) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /var/cache/prod/smarty/compile/v1_gardenia_11layouts_layout_left_column_tpl/f7/f8/6b/f7f86be97cfdbafa2735d8030700d58f00d21d2a_2.file.header.tpl.php:55 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/v1_gardenia_11layouts_layout_left_column_tpl/f7/f8/6b/f7f86be97cfdbafa2735d8030700d58f00d21d2a_2.file.header.tpl.php:29 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67293b2a2643b7_90860613) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /var/cache/prod/smarty/compile/v1_gardenia_11layouts_layout_left_column_tpl/1a/89/a7/1a89a734d096f5ad14ad4dbb33891e0facb00120_2.file.layout-both-columns.tpl.php:144 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/v1_gardenia_11layouts_layout_left_column_tpl/1a/89/a7/1a89a734d096f5ad14ad4dbb33891e0facb00120_2.file.layout-both-columns.tpl.php:64 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67293b29f16874_07033251) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/v1_gardenia_11layouts_layout_left_column_tpl/6d/33/66/6d33663adfbf67f07eddb2df7d930f4c5287edb8_2.file.layout-left-column.tpl.php:28 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67293b29efacf3_58320531) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/v1_gardenia_11layouts_layout_left_column_tpl/82/55/0e/82550e22f895f1760ff1e1a0c2d6c8c47e0de299_2.file.product-list.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67293b29eea393_23821434) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/v1_gardenia_11layouts_layout_left_column_tpl/37/3d/2c/373d2ce4c1a83676f8228aca20a47aac483b040b_2.file.category.tpl.php:29 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67293b29ed0a52_43895681) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/controller/FrontController.php:771 (fetch) /classes/controller/FrontController.php:753 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
2283	SELECT SQL_NO_CACHE (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS grade FROM `pre2469_tvcmsproduct_comment` pc WHERE pc.`id_product` = 297 AND pc.`deleted` = 0 AND pc.`validate` = 1 LIMIT 1	4.636 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)

#	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

Oléomac DEB 517

Oléomac DEB 517

Oléomac DEB 517

Oléomac DEB 517

Stiga Park 300M

Stiga Park 300M

Stiga Park 300M

Stiga Park 300M

Oleo Mac DEB 518

Oleo Mac DEB 518

Oleo Mac DEB 518

Oleo Mac DEB 518

Oléo Mac OM86R-14.5K

Oléo Mac OM86R-14.5K

Oléo Mac OM86R-14.5K

Oléo Mac OM86R-14.5K

Oleo Mac DEB 5158

Oleo Mac DEB 5158

Oleo Mac DEB 5158

Oleo Mac DEB 5158

Oléo Mac OM92R-16K

Oléo Mac OM92R-16K

Oléo Mac OM92R-16K

Oléo Mac OM92R-16K

Oleo Mac TDF 518

Oleo Mac TDF 518

Oleo Mac TDF 518

Oleo Mac TDF 518

Oleo Mac MAX 53TK Allroad

Oleo Mac MAX 53TK Allroad

Oleo Mac MAX 53TK Allroad

Oleo Mac MAX 53TK Allroad

Oleo Mac OM92/16KH

Oleo Mac OM92/16KH

Oleo Mac OM92/16KH

Oleo Mac OM92/16KH

Oleo-Mac GV53TK Allroad

Oleo-Mac GV53TK Allroad

Oleo-Mac GV53TK Allroad

Oleo-Mac GV53TK Allroad

Oleo Mac Tuareg 92 EVOK

Oleo Mac Tuareg 92 EVOK

Oleo Mac Tuareg 92 EVOK

Oleo Mac Tuareg 92 EVOK

Oleo Mac Tuareg 92 EVO

Oleo Mac Tuareg 92 EVO

Oleo Mac Tuareg 92 EVO

Oleo Mac Tuareg 92 EVO

Stopwatch SQL - 2328 queries

Doubles

Tables stress

ObjectModel instances

Included Files