Livres (3)

mars

10,

2025

Balivernes at the ML25 book fair

Le salon Magnifique Livre aura lieu du vendredi 14 mars au dimanche 16 mars à la chapelle de la Trinité, rue de la Bourse à Lyon, métro Hôtel de ...

mars

10,

2025

Balivernes at Primevere fair

Balivernes will participate at the Primevere fair, the main fair about ecology.

mars

10,

2025

Update to our website

We apologize for the update to our website which has taken longer than expected and made it unavailable for a few days.

All blogs

Livres

Les ouvrages de Balivernes éditions, des livres pour la jeunesse pour développer l'imagination !

Subcategory

View Left Column

154 products

Grid

Grid-2

List

List-2

Catelog

Sort by:

Add To Compare

By : 32Satoe ToneSatoe Tone

Doux rêves de moutons

Petit Mouton n’a jamais encore apporté de rêves aux enfants. Cette nuit, ce sera la première fois. Ses frères lui donnent un conseil et un seul : imaginer ce qu’il préfère le plus au monde...

€9.00

Load Time	904 ms
Querying Time	790 ms
Queries	987
Memory Peak Usage	27.8 Mb
Included Files	966 files - 11.33 Mb
PrestaShop Cache	- Mb
Global vars	0.34 Mb
- global $_MODULES	160k
- global $_MODULE	160k
- global $_SERVER	6k
- global $_ENV	6k
- global $config	5k
- global $context	4k
- global $exportPhpConfigFile	4k
- global $smarty	2k
- global $__composer_autoload_files	1k

PrestaShop Version	8.2.1
PHP Version	8.1.32
MySQL Version	8.0.41-32
Memory Limit	512M
Max Execution Time	165s
Smarty Cache	enabled
Smarty Compilation	auto

	Time	Cumulated Time	Memory Usage	Memory Peak Usage
config	8.901 ms	8.901 ms	2.99 Mb	3.5 Mb
__construct	0.011 ms	8.912 ms	- Mb	3.5 Mb
init	60.473 ms	69.385 ms	1.02 Mb	4.0 Mb
checkAccess	0.002 ms	69.387 ms	- Mb	4.0 Mb
setMedia	2.771 ms	72.158 ms	0.14 Mb	4.2 Mb
postProcess	0.001 ms	72.159 ms	- Mb	4.2 Mb
initHeader	0.001 ms	72.160 ms	- Mb	4.2 Mb
initContent	272.003 ms	344.163 ms	4.73 Mb	8.9 Mb
initFooter	0.001 ms	344.164 ms	- Mb	8.9 Mb
display	559.799 ms	904 ms	18.25 Mb	27.8 Mb

Hook	Time	Memory Usage
DisplayLeftColumn	231.022 ms	5.56 Mb
=> tvcmscustomerservices	0.214 ms	0.01 Mb
=> tvcmsspecialproducts	2.824 ms	0.08 Mb
=> tvcmsfeaturedproducts	6.377 ms	0.11 Mb
=> tvcmstestimonial	0.914 ms	0.04 Mb
=> tvcmsbestsellerproducts	91.743 ms	1.89 Mb
=> tvcmsblogdisplayposts	128.950 ms	3.42 Mb
DisplayAfterBodyOpeningTag	76.268 ms	2.54 Mb
=> blockreassurance	0.005 ms	- Mb
=> tvcmsproductpopup	76.263 ms	2.54 Mb
DisplayReviewProductList	71.363 ms	3.85 Mb
=> tvcmsproductcomments	3.392 ms	0.12 Mb
=> tvcmsproductcomments	1.546 ms	0.07 Mb
=> tvcmsproductcomments	1.515 ms	0.07 Mb
=> tvcmsproductcomments	1.745 ms	0.07 Mb
=> tvcmsproductcomments	2.011 ms	0.11 Mb
=> tvcmsproductcomments	1.365 ms	0.07 Mb
=> tvcmsproductcomments	1.249 ms	0.07 Mb
=> tvcmsproductcomments	1.269 ms	0.07 Mb
=> tvcmsproductcomments	1.770 ms	0.11 Mb
=> tvcmsproductcomments	1.131 ms	0.07 Mb
=> tvcmsproductcomments	1.378 ms	0.07 Mb
=> tvcmsproductcomments	1.024 ms	0.07 Mb
=> tvcmsproductcomments	1.495 ms	0.11 Mb
=> tvcmsproductcomments	1.222 ms	0.07 Mb
=> tvcmsproductcomments	1.347 ms	0.07 Mb
=> tvcmsproductcomments	1.081 ms	0.07 Mb
=> tvcmsproductcomments	1.563 ms	0.11 Mb
=> tvcmsproductcomments	1.226 ms	0.07 Mb
=> tvcmsproductcomments	1.279 ms	0.07 Mb
=> tvcmsproductcomments	1.299 ms	0.07 Mb
=> tvcmsproductcomments	1.479 ms	0.11 Mb
=> tvcmsproductcomments	1.068 ms	0.07 Mb
=> tvcmsproductcomments	1.235 ms	0.07 Mb
=> tvcmsproductcomments	1.208 ms	0.07 Mb
=> tvcmsproductcomments	1.765 ms	0.11 Mb
=> tvcmsproductcomments	1.086 ms	0.07 Mb
=> tvcmsproductcomments	1.152 ms	0.07 Mb
=> tvcmsproductcomments	1.256 ms	0.07 Mb
=> tvcmsproductcomments	1.768 ms	0.11 Mb
=> tvcmsproductcomments	1.338 ms	0.07 Mb
=> tvcmsproductcomments	1.240 ms	0.07 Mb
=> tvcmsproductcomments	1.604 ms	0.07 Mb
=> tvcmsproductcomments	1.739 ms	0.11 Mb
=> tvcmsproductcomments	1.308 ms	0.07 Mb
=> tvcmsproductcomments	1.269 ms	0.07 Mb
=> tvcmsproductcomments	1.606 ms	0.07 Mb
=> tvcmsproductcomments	1.968 ms	0.11 Mb
=> tvcmsproductcomments	1.194 ms	0.07 Mb
=> tvcmsproductcomments	1.271 ms	0.07 Mb
=> tvcmsproductcomments	1.281 ms	0.07 Mb
=> tvcmsproductcomments	1.922 ms	0.11 Mb
=> tvcmsproductcomments	1.435 ms	0.07 Mb
=> tvcmsproductcomments	1.754 ms	0.07 Mb
=> tvcmsproductcomments	1.297 ms	0.07 Mb
=> tvcmsproductcomments	3.989 ms	0.11 Mb
=> tvcmsproductcomments	1.066 ms	0.07 Mb
=> tvcmsproductcomments	1.083 ms	0.07 Mb
=> tvcmsproductcomments	1.074 ms	0.07 Mb
displayLeftColumn	28.482 ms	0.99 Mb
=> ps_categorytree (widget)	23.150 ms	0.82 Mb
=> ps_brandlist (widget)	2.810 ms	0.12 Mb
=> ps_supplierlist (widget)	2.522 ms	0.05 Mb
displayNavCurrencyBlock	17.866 ms	0.81 Mb
=> ps_currencyselector (widget)	17.866 ms	0.81 Mb
DisplayMegamenu	8.133 ms	0.35 Mb
=> tvcmsmegamenu	8.133 ms	0.35 Mb
displayNavCustomerSignInBlock	7.457 ms	0.05 Mb
=> ps_customersignin (widget)	7.457 ms	0.05 Mb
displayNavLanguageBlock	7.174 ms	0.33 Mb
=> ps_languageselector (widget)	7.174 ms	0.33 Mb
DisplayFooterCategory	6.795 ms	0.33 Mb
=> tvcmsfootercategory	6.795 ms	0.33 Mb
DisplayWishlistBtnProductList	5.363 ms	0.06 Mb
=> tvcmswishlist	0.206 ms	0.01 Mb
=> tvcmswishlist	0.141 ms	- Mb
=> tvcmswishlist	0.125 ms	- Mb
=> tvcmswishlist	0.116 ms	- Mb
=> tvcmswishlist	0.099 ms	- Mb
=> tvcmswishlist	0.113 ms	- Mb
=> tvcmswishlist	0.100 ms	- Mb
=> tvcmswishlist	0.108 ms	- Mb
=> tvcmswishlist	0.111 ms	- Mb
=> tvcmswishlist	0.110 ms	- Mb
=> tvcmswishlist	0.118 ms	- Mb
=> tvcmswishlist	0.111 ms	- Mb
=> tvcmswishlist	0.121 ms	- Mb
=> tvcmswishlist	0.112 ms	- Mb
=> tvcmswishlist	0.103 ms	- Mb
=> tvcmswishlist	0.126 ms	- Mb
=> tvcmswishlist	0.104 ms	- Mb
=> tvcmswishlist	0.110 ms	- Mb
=> tvcmswishlist	0.097 ms	- Mb
=> tvcmswishlist	0.094 ms	- Mb
=> tvcmswishlist	0.092 ms	- Mb
=> tvcmswishlist	0.096 ms	- Mb
=> tvcmswishlist	0.096 ms	- Mb
=> tvcmswishlist	0.096 ms	- Mb
=> tvcmswishlist	0.091 ms	- Mb
=> tvcmswishlist	0.112 ms	- Mb
=> tvcmswishlist	0.120 ms	- Mb
=> tvcmswishlist	0.095 ms	- Mb
=> tvcmswishlist	0.116 ms	- Mb
=> tvcmswishlist	0.096 ms	- Mb
=> tvcmswishlist	0.101 ms	- Mb
=> tvcmswishlist	0.094 ms	- Mb
=> tvcmswishlist	0.109 ms	- Mb
=> tvcmswishlist	0.107 ms	- Mb
=> tvcmswishlist	0.149 ms	- Mb
=> tvcmswishlist	0.096 ms	- Mb
=> tvcmswishlist	0.101 ms	- Mb
=> tvcmswishlist	0.104 ms	- Mb
=> tvcmswishlist	0.133 ms	- Mb
=> tvcmswishlist	0.110 ms	- Mb
=> tvcmswishlist	0.103 ms	- Mb
=> tvcmswishlist	0.146 ms	- Mb
=> tvcmswishlist	0.111 ms	- Mb
=> tvcmswishlist	0.101 ms	- Mb
=> tvcmswishlist	0.097 ms	- Mb
=> tvcmswishlist	0.111 ms	- Mb
=> tvcmswishlist	0.122 ms	- Mb
=> tvcmswishlist	0.133 ms	- Mb
DisplayProductCompareProductList	4.955 ms	0.06 Mb
=> tvcmsproductcompare	0.176 ms	0.01 Mb
=> tvcmsproductcompare	0.106 ms	- Mb
=> tvcmsproductcompare	0.113 ms	- Mb
=> tvcmsproductcompare	0.106 ms	- Mb
=> tvcmsproductcompare	0.115 ms	- Mb
=> tvcmsproductcompare	0.101 ms	- Mb
=> tvcmsproductcompare	0.092 ms	- Mb
=> tvcmsproductcompare	0.100 ms	- Mb
=> tvcmsproductcompare	0.088 ms	- Mb
=> tvcmsproductcompare	0.101 ms	- Mb
=> tvcmsproductcompare	0.106 ms	- Mb
=> tvcmsproductcompare	0.322 ms	- Mb
=> tvcmsproductcompare	0.094 ms	- Mb
=> tvcmsproductcompare	0.095 ms	- Mb
=> tvcmsproductcompare	0.095 ms	- Mb
=> tvcmsproductcompare	0.109 ms	- Mb
=> tvcmsproductcompare	0.087 ms	- Mb
=> tvcmsproductcompare	0.094 ms	- Mb
=> tvcmsproductcompare	0.084 ms	- Mb
=> tvcmsproductcompare	0.082 ms	- Mb
=> tvcmsproductcompare	0.099 ms	- Mb
=> tvcmsproductcompare	0.083 ms	- Mb
=> tvcmsproductcompare	0.084 ms	- Mb
=> tvcmsproductcompare	0.100 ms	- Mb
=> tvcmsproductcompare	0.081 ms	- Mb
=> tvcmsproductcompare	0.091 ms	- Mb
=> tvcmsproductcompare	0.089 ms	- Mb
=> tvcmsproductcompare	0.083 ms	- Mb
=> tvcmsproductcompare	0.086 ms	- Mb
=> tvcmsproductcompare	0.085 ms	- Mb
=> tvcmsproductcompare	0.090 ms	- Mb
=> tvcmsproductcompare	0.131 ms	- Mb
=> tvcmsproductcompare	0.085 ms	- Mb
=> tvcmsproductcompare	0.085 ms	- Mb
=> tvcmsproductcompare	0.097 ms	- Mb
=> tvcmsproductcompare	0.086 ms	- Mb
=> tvcmsproductcompare	0.087 ms	- Mb
=> tvcmsproductcompare	0.105 ms	- Mb
=> tvcmsproductcompare	0.128 ms	- Mb
=> tvcmsproductcompare	0.104 ms	- Mb
=> tvcmsproductcompare	0.094 ms	- Mb
=> tvcmsproductcompare	0.126 ms	- Mb
=> tvcmsproductcompare	0.096 ms	- Mb
=> tvcmsproductcompare	0.093 ms	- Mb
=> tvcmsproductcompare	0.086 ms	- Mb
=> tvcmsproductcompare	0.099 ms	- Mb
=> tvcmsproductcompare	0.099 ms	- Mb
=> tvcmsproductcompare	0.117 ms	- Mb
Header	4.560 ms	0.07 Mb
=> tvcmsstockinfo	0.046 ms	- Mb
=> tvcmsinfinitescroll	4.399 ms	0.07 Mb
=> tvcmscategoryproduct	0.064 ms	- Mb
=> tvcmsmegamenu	0.051 ms	- Mb
displayFooterPart1	3.187 ms	0.06 Mb
=> ps_linklist (widget)	3.187 ms	0.06 Mb
displayMyaccountcblock	3.046 ms	0.06 Mb
=> ps_customeraccountlinks (widget)	3.046 ms	0.06 Mb
DisplayHeader	2.904 ms	0.08 Mb
=> ps_shoppingcart	0.041 ms	- Mb
=> ps_searchbar	0.103 ms	- Mb
=> tvcmsbestsellerproducts	0.042 ms	- Mb
=> tvcmsblog	0.085 ms	- Mb
=> tvcmsblogdisplayposts	0.052 ms	- Mb
=> tvcmsbrandlist	0.041 ms	- Mb
=> tvcmscategorybanner	0.040 ms	- Mb
=> tvcmscategorychainslider	0.039 ms	- Mb
=> tvcmscustomerservices	0.042 ms	- Mb
=> tvcmscustomsetting	0.315 ms	0.01 Mb
=> tvcmsfeaturedproducts	0.032 ms	- Mb
=> tvcmsfooterlogo	0.001 ms	- Mb
=> tvcmsfooterproduct	0.027 ms	- Mb
=> tvcmsmultibanner1	0.040 ms	- Mb
=> tvcmsnewsletterpopup	0.078 ms	- Mb
=> tvcmspaymenticon	0.000 ms	- Mb
=> tvcmsproductcomments	0.135 ms	- Mb
=> tvcmsproductcompare	0.038 ms	- Mb
=> tvcmsproductpopup	0.037 ms	- Mb
=> tvcmssearch	0.090 ms	- Mb
=> tvcmsslider	0.044 ms	- Mb
=> tvcmsspecialproducts	0.030 ms	- Mb
=> tvcmstabproducts	0.054 ms	- Mb
=> tvcmstestimonial	0.043 ms	- Mb
=> tvcmsthemeoptions	0.113 ms	- Mb
=> tvcmswishlist	0.054 ms	- Mb
=> prettyurls	1.289 ms	0.02 Mb
displaySocialMediaBlock	2.439 ms	0.08 Mb
=> ps_socialfollow (widget)	2.439 ms	0.08 Mb
DisplayCustomsocialblock	2.290 ms	0.11 Mb
=> tvcmscustomsetting	2.290 ms	0.11 Mb
displayNav1	1.944 ms	0.09 Mb
=> ps_contactinfo (widget)	1.944 ms	0.09 Mb
displayNavShoppingCartBlock	1.922 ms	0.09 Mb
=> ps_shoppingcart (widget)	1.922 ms	0.09 Mb
DisplayNavSearchBlock	1.534 ms	0.08 Mb
=> tvcmssearch	1.534 ms	0.08 Mb
DisplayPaymentIcon	1.330 ms	0.04 Mb
=> tvcmspaymenticon	1.330 ms	0.04 Mb
DisplayNavWishlistBlock	1.137 ms	0.04 Mb
=> tvcmswishlist	1.137 ms	0.04 Mb
displayContactCinfo	1.038 ms	0.03 Mb
=> ps_contactinfo (widget)	1.038 ms	0.03 Mb
ProductSearchProvider	0.300 ms	- Mb
=> ps_facetedsearch	0.300 ms	- Mb
DisplayAfterTitleTag	0.193 ms	0.01 Mb
=> lgcookieslaw	0.193 ms	0.01 Mb
ActionFrontControllerSetMedia	0.192 ms	0.01 Mb
=> blockreassurance	0.146 ms	0.01 Mb
=> ps_emailalerts	0.020 ms	- Mb
=> ps_socialfollow	0.026 ms	- Mb
DisplayNavProductCompareBlock	0.188 ms	0.01 Mb
=> tvcmsproductcompare	0.188 ms	0.01 Mb
DisplayFooterPart2	0.157 ms	0.02 Mb
=> tvcmsfooterlogo	0.157 ms	0.02 Mb
DisplayFacetedSearchBlock	0.123 ms	- Mb
=> ps_facetedsearch	0.123 ms	- Mb
DisplayCopyRightText	0.111 ms	0.01 Mb
=> tvcmscustomsetting	0.111 ms	0.01 Mb
DisplayProductListStockIndicator	0.052 ms	0.01 Mb
=> tvcmsstockinfo	0.004 ms	- Mb
=> tvcmsstockinfo	0.002 ms	- Mb
=> tvcmsstockinfo	0.002 ms	- Mb
=> tvcmsstockinfo	0.002 ms	- Mb
=> tvcmsstockinfo	0.002 ms	- Mb
=> tvcmsstockinfo	0.002 ms	- Mb
=> tvcmsstockinfo	0.002 ms	- Mb
=> tvcmsstockinfo	0.001 ms	- Mb
=> tvcmsstockinfo	0.002 ms	- Mb
=> tvcmsstockinfo	0.001 ms	- Mb
=> tvcmsstockinfo	0.002 ms	- Mb
=> tvcmsstockinfo	0.001 ms	- Mb
=> tvcmsstockinfo	0.003 ms	- Mb
=> tvcmsstockinfo	0.001 ms	- Mb
=> tvcmsstockinfo	0.002 ms	- Mb
=> tvcmsstockinfo	0.002 ms	- Mb
=> tvcmsstockinfo	0.002 ms	- Mb
=> tvcmsstockinfo	0.002 ms	- Mb
=> tvcmsstockinfo	0.004 ms	- Mb
=> tvcmsstockinfo	0.002 ms	- Mb
=> tvcmsstockinfo	0.004 ms	- Mb
=> tvcmsstockinfo	0.002 ms	- Mb
=> tvcmsstockinfo	0.003 ms	- Mb
=> tvcmsstockinfo	0.002 ms	- Mb
DisplayFooter	0.039 ms	- Mb
=> lgcookieslaw	0.039 ms	- Mb
ModuleRoutes	0.021 ms	0.01 Mb
=> tvcmsblog	0.015 ms	0.01 Mb
=> tvcmsblog	0.006 ms	0.01 Mb
DisplayTopOfferText	0.015 ms	- Mb
=> tvcmscustomsetting	0.011 ms	- Mb
=> tvcmscustomsetting	0.004 ms	- Mb
DisplayDownloadApps	0.007 ms	- Mb
=> tvcmscustomsetting	0.007 ms	- Mb
DisplayCustomJs	0.005 ms	- Mb
=> tvcmscustomcssjs	0.005 ms	- Mb
DisplayCustomCss	0.004 ms	- Mb
=> tvcmscustomcssjs	0.004 ms	- Mb
DisplayNavFullWidth	0.004 ms	- Mb
=> blockreassurance	0.004 ms	- Mb
DisplayBeforeBodyClosingTag	0.003 ms	- Mb
=> tvcmsblog	0.003 ms	- Mb
39 hook(s)	493.624 ms	15.84 Mb

Module	Time	Memory Usage
tvcmsblog	2.822 ms	0.12 Mb
__construct	2.708 ms	0.10 Mb
hookModuleRoutes	0.016 ms	0.01 Mb
hookModuleRoutes	0.008 ms	0.01 Mb
hookDisplayHeader	0.086 ms	- Mb
hookDisplayBeforeBodyClosingTag	0.004 ms	- Mb
blockreassurance	1.455 ms	0.12 Mb
__construct	1.296 ms	0.11 Mb
hookActionFrontControllerSetMedia	0.148 ms	0.01 Mb
hookDisplayAfterBodyOpeningTag	0.006 ms	- Mb
hookDisplayNavFullWidth	0.005 ms	- Mb
ps_emailalerts	0.121 ms	0.01 Mb
__construct	0.100 ms	0.01 Mb
hookActionFrontControllerSetMedia	0.021 ms	- Mb
ps_socialfollow	2.514 ms	0.09 Mb
__construct	0.046 ms	0.01 Mb
hookActionFrontControllerSetMedia	0.027 ms	- Mb
displaySocialMediaBlock	2.441 ms	0.08 Mb
ps_shoppingcart	2.040 ms	0.10 Mb
__construct	0.073 ms	0.01 Mb
hookDisplayHeader	0.043 ms	- Mb
displayNavShoppingCartBlock	1.924 ms	0.09 Mb
ps_searchbar	0.158 ms	0.01 Mb
__construct	0.054 ms	0.01 Mb
hookDisplayHeader	0.104 ms	- Mb
tvcmsbestsellerproducts	91.977 ms	1.90 Mb
__construct	0.187 ms	0.01 Mb
hookDisplayHeader	0.043 ms	- Mb
hookDisplayLeftColumn	91.747 ms	1.89 Mb
tvcmsblogdisplayposts	129.113 ms	3.43 Mb
__construct	0.106 ms	0.01 Mb
hookDisplayHeader	0.052 ms	- Mb
hookDisplayLeftColumn	128.955 ms	3.42 Mb
tvcmsbrandlist	0.183 ms	0.01 Mb
__construct	0.141 ms	0.01 Mb
hookDisplayHeader	0.042 ms	- Mb
tvcmscategorybanner	0.176 ms	0.01 Mb
__construct	0.135 ms	0.01 Mb
hookDisplayHeader	0.041 ms	- Mb
tvcmscategorychainslider	0.173 ms	0.01 Mb
__construct	0.134 ms	0.01 Mb
hookDisplayHeader	0.039 ms	- Mb
tvcmscustomerservices	0.390 ms	0.02 Mb
__construct	0.131 ms	0.01 Mb
hookDisplayHeader	0.043 ms	- Mb
hookDisplayLeftColumn	0.216 ms	0.01 Mb
tvcmscustomsetting	3.147 ms	0.15 Mb
__construct	0.400 ms	0.01 Mb
hookDisplayHeader	0.316 ms	0.01 Mb
hookDisplayTopOfferText	0.013 ms	- Mb
hookDisplayTopOfferText	0.005 ms	- Mb
hookDisplayDownloadApps	0.008 ms	- Mb
hookDisplayCustomsocialblock	2.292 ms	0.11 Mb
hookDisplayCopyRightText	0.113 ms	0.02 Mb
tvcmsfeaturedproducts	6.486 ms	0.12 Mb
__construct	0.074 ms	0.01 Mb
hookDisplayHeader	0.033 ms	- Mb
hookDisplayLeftColumn	6.379 ms	0.11 Mb
tvcmsfooterlogo	0.294 ms	0.02 Mb
__construct	0.133 ms	0.01 Mb
hookDisplayHeader	0.002 ms	- Mb
hookDisplayFooterPart2	0.159 ms	0.02 Mb
tvcmsfooterproduct	0.097 ms	0.01 Mb
__construct	0.069 ms	0.01 Mb
hookDisplayHeader	0.028 ms	- Mb
tvcmsmultibanner1	0.168 ms	0.01 Mb
__construct	0.128 ms	0.01 Mb
hookDisplayHeader	0.040 ms	- Mb
tvcmsnewsletterpopup	0.200 ms	0.01 Mb
__construct	0.122 ms	0.01 Mb
hookDisplayHeader	0.078 ms	- Mb
tvcmspaymenticon	1.462 ms	0.05 Mb
__construct	0.129 ms	0.01 Mb
hookDisplayHeader	0.001 ms	- Mb
hookDisplayPaymentIcon	1.332 ms	0.05 Mb
tvcmsproductcomments	71.882 ms	3.88 Mb
__construct	0.319 ms	0.01 Mb
hookDisplayHeader	0.136 ms	0.01 Mb
hookDisplayReviewProductList	3.394 ms	0.12 Mb
hookDisplayReviewProductList	1.547 ms	0.07 Mb
hookDisplayReviewProductList	1.516 ms	0.07 Mb
hookDisplayReviewProductList	1.746 ms	0.07 Mb
hookDisplayReviewProductList	2.013 ms	0.11 Mb
hookDisplayReviewProductList	1.366 ms	0.07 Mb
hookDisplayReviewProductList	1.251 ms	0.07 Mb
hookDisplayReviewProductList	1.270 ms	0.07 Mb
hookDisplayReviewProductList	1.772 ms	0.11 Mb
hookDisplayReviewProductList	1.132 ms	0.07 Mb
hookDisplayReviewProductList	1.380 ms	0.07 Mb
hookDisplayReviewProductList	1.025 ms	0.07 Mb
hookDisplayReviewProductList	1.496 ms	0.11 Mb
hookDisplayReviewProductList	1.223 ms	0.07 Mb
hookDisplayReviewProductList	1.348 ms	0.07 Mb
hookDisplayReviewProductList	1.082 ms	0.07 Mb
hookDisplayReviewProductList	1.565 ms	0.11 Mb
hookDisplayReviewProductList	1.227 ms	0.07 Mb
hookDisplayReviewProductList	1.280 ms	0.07 Mb
hookDisplayReviewProductList	1.300 ms	0.07 Mb
hookDisplayReviewProductList	1.480 ms	0.11 Mb
hookDisplayReviewProductList	1.070 ms	0.07 Mb
hookDisplayReviewProductList	1.237 ms	0.07 Mb
hookDisplayReviewProductList	1.209 ms	0.07 Mb
hookDisplayReviewProductList	1.766 ms	0.11 Mb
hookDisplayReviewProductList	1.088 ms	0.07 Mb
hookDisplayReviewProductList	1.153 ms	0.07 Mb
hookDisplayReviewProductList	1.258 ms	0.07 Mb
hookDisplayReviewProductList	1.769 ms	0.11 Mb
hookDisplayReviewProductList	1.340 ms	0.07 Mb
hookDisplayReviewProductList	1.241 ms	0.07 Mb
hookDisplayReviewProductList	1.605 ms	0.07 Mb
hookDisplayReviewProductList	1.741 ms	0.11 Mb
hookDisplayReviewProductList	1.309 ms	0.07 Mb
hookDisplayReviewProductList	1.270 ms	0.07 Mb
hookDisplayReviewProductList	1.607 ms	0.07 Mb
hookDisplayReviewProductList	1.969 ms	0.11 Mb
hookDisplayReviewProductList	1.195 ms	0.07 Mb
hookDisplayReviewProductList	1.272 ms	0.07 Mb
hookDisplayReviewProductList	1.282 ms	0.07 Mb
hookDisplayReviewProductList	1.924 ms	0.11 Mb
hookDisplayReviewProductList	1.436 ms	0.07 Mb
hookDisplayReviewProductList	1.755 ms	0.07 Mb
hookDisplayReviewProductList	1.298 ms	0.07 Mb
hookDisplayReviewProductList	3.991 ms	0.11 Mb
hookDisplayReviewProductList	1.067 ms	0.07 Mb
hookDisplayReviewProductList	1.085 ms	0.07 Mb
hookDisplayReviewProductList	1.076 ms	0.07 Mb
tvcmsproductcompare	5.302 ms	0.09 Mb
__construct	0.070 ms	0.01 Mb
hookDisplayHeader	0.039 ms	- Mb
hookDisplayNavProductCompareBlock	0.189 ms	0.01 Mb
hookDisplayProductCompareProductList	0.178 ms	0.01 Mb
hookDisplayProductCompareProductList	0.107 ms	- Mb
hookDisplayProductCompareProductList	0.114 ms	- Mb
hookDisplayProductCompareProductList	0.107 ms	- Mb
hookDisplayProductCompareProductList	0.116 ms	- Mb
hookDisplayProductCompareProductList	0.102 ms	- Mb
hookDisplayProductCompareProductList	0.092 ms	- Mb
hookDisplayProductCompareProductList	0.101 ms	- Mb
hookDisplayProductCompareProductList	0.089 ms	- Mb
hookDisplayProductCompareProductList	0.102 ms	- Mb
hookDisplayProductCompareProductList	0.107 ms	- Mb
hookDisplayProductCompareProductList	0.323 ms	- Mb
hookDisplayProductCompareProductList	0.095 ms	- Mb
hookDisplayProductCompareProductList	0.096 ms	- Mb
hookDisplayProductCompareProductList	0.096 ms	- Mb
hookDisplayProductCompareProductList	0.110 ms	- Mb
hookDisplayProductCompareProductList	0.088 ms	- Mb
hookDisplayProductCompareProductList	0.095 ms	- Mb
hookDisplayProductCompareProductList	0.084 ms	- Mb
hookDisplayProductCompareProductList	0.083 ms	- Mb
hookDisplayProductCompareProductList	0.100 ms	- Mb
hookDisplayProductCompareProductList	0.084 ms	- Mb
hookDisplayProductCompareProductList	0.085 ms	- Mb
hookDisplayProductCompareProductList	0.101 ms	- Mb
hookDisplayProductCompareProductList	0.082 ms	- Mb
hookDisplayProductCompareProductList	0.092 ms	- Mb
hookDisplayProductCompareProductList	0.090 ms	- Mb
hookDisplayProductCompareProductList	0.084 ms	- Mb
hookDisplayProductCompareProductList	0.087 ms	- Mb
hookDisplayProductCompareProductList	0.086 ms	- Mb
hookDisplayProductCompareProductList	0.091 ms	- Mb
hookDisplayProductCompareProductList	0.132 ms	- Mb
hookDisplayProductCompareProductList	0.086 ms	- Mb
hookDisplayProductCompareProductList	0.086 ms	- Mb
hookDisplayProductCompareProductList	0.099 ms	- Mb
hookDisplayProductCompareProductList	0.087 ms	- Mb
hookDisplayProductCompareProductList	0.088 ms	- Mb
hookDisplayProductCompareProductList	0.106 ms	- Mb
hookDisplayProductCompareProductList	0.130 ms	- Mb
hookDisplayProductCompareProductList	0.105 ms	- Mb
hookDisplayProductCompareProductList	0.094 ms	- Mb
hookDisplayProductCompareProductList	0.128 ms	- Mb
hookDisplayProductCompareProductList	0.097 ms	- Mb
hookDisplayProductCompareProductList	0.093 ms	- Mb
hookDisplayProductCompareProductList	0.087 ms	- Mb
hookDisplayProductCompareProductList	0.100 ms	- Mb
hookDisplayProductCompareProductList	0.100 ms	- Mb
hookDisplayProductCompareProductList	0.119 ms	- Mb
tvcmsproductpopup	76.346 ms	2.55 Mb
__construct	0.042 ms	0.01 Mb
hookDisplayHeader	0.038 ms	- Mb
hookDisplayAfterBodyOpeningTag	76.266 ms	2.54 Mb
tvcmssearch	1.677 ms	0.15 Mb
__construct	0.050 ms	0.07 Mb
hookDisplayHeader	0.091 ms	- Mb
hookDisplayNavSearchBlock	1.536 ms	0.08 Mb
tvcmsslider	0.369 ms	0.01 Mb
__construct	0.324 ms	0.01 Mb
hookDisplayHeader	0.045 ms	- Mb
tvcmsspecialproducts	2.923 ms	0.09 Mb
__construct	0.067 ms	0.01 Mb
hookDisplayHeader	0.030 ms	- Mb
hookDisplayLeftColumn	2.826 ms	0.08 Mb
tvcmsstockinfo	0.183 ms	0.03 Mb
__construct	0.064 ms	0.01 Mb
hookHeader	0.047 ms	- Mb
hookDisplayProductListStockIndicator	0.005 ms	- Mb
hookDisplayProductListStockIndicator	0.003 ms	- Mb
hookDisplayProductListStockIndicator	0.003 ms	- Mb
hookDisplayProductListStockIndicator	0.002 ms	- Mb
hookDisplayProductListStockIndicator	0.003 ms	- Mb
hookDisplayProductListStockIndicator	0.002 ms	- Mb
hookDisplayProductListStockIndicator	0.003 ms	- Mb
hookDisplayProductListStockIndicator	0.002 ms	- Mb
hookDisplayProductListStockIndicator	0.003 ms	- Mb
hookDisplayProductListStockIndicator	0.002 ms	- Mb
hookDisplayProductListStockIndicator	0.003 ms	- Mb
hookDisplayProductListStockIndicator	0.002 ms	- Mb
hookDisplayProductListStockIndicator	0.004 ms	- Mb
hookDisplayProductListStockIndicator	0.002 ms	- Mb
hookDisplayProductListStockIndicator	0.002 ms	- Mb
hookDisplayProductListStockIndicator	0.003 ms	- Mb
hookDisplayProductListStockIndicator	0.004 ms	- Mb
hookDisplayProductListStockIndicator	0.002 ms	- Mb
hookDisplayProductListStockIndicator	0.005 ms	- Mb
hookDisplayProductListStockIndicator	0.003 ms	- Mb
hookDisplayProductListStockIndicator	0.005 ms	- Mb
hookDisplayProductListStockIndicator	0.003 ms	- Mb
hookDisplayProductListStockIndicator	0.004 ms	- Mb
hookDisplayProductListStockIndicator	0.002 ms	- Mb
tvcmstabproducts	0.094 ms	0.01 Mb
__construct	0.039 ms	0.01 Mb
hookDisplayHeader	0.055 ms	- Mb
tvcmstestimonial	1.096 ms	0.05 Mb
__construct	0.137 ms	0.01 Mb
hookDisplayHeader	0.043 ms	- Mb
hookDisplayLeftColumn	0.916 ms	0.04 Mb
tvcmsthemeoptions	0.172 ms	0.01 Mb
__construct	0.059 ms	0.01 Mb
hookDisplayHeader	0.113 ms	- Mb
tvcmswishlist	6.687 ms	0.13 Mb
__construct	0.081 ms	0.01 Mb
hookDisplayHeader	0.055 ms	- Mb
hookDisplayNavWishlistBlock	1.139 ms	0.04 Mb
hookDisplayWishlistBtnProductList	0.208 ms	0.01 Mb
hookDisplayWishlistBtnProductList	0.142 ms	- Mb
hookDisplayWishlistBtnProductList	0.126 ms	- Mb
hookDisplayWishlistBtnProductList	0.117 ms	- Mb
hookDisplayWishlistBtnProductList	0.100 ms	- Mb
hookDisplayWishlistBtnProductList	0.114 ms	- Mb
hookDisplayWishlistBtnProductList	0.101 ms	- Mb
hookDisplayWishlistBtnProductList	0.109 ms	- Mb
hookDisplayWishlistBtnProductList	0.112 ms	- Mb
hookDisplayWishlistBtnProductList	0.111 ms	- Mb
hookDisplayWishlistBtnProductList	0.119 ms	- Mb
hookDisplayWishlistBtnProductList	0.112 ms	- Mb
hookDisplayWishlistBtnProductList	0.122 ms	- Mb
hookDisplayWishlistBtnProductList	0.113 ms	- Mb
hookDisplayWishlistBtnProductList	0.104 ms	- Mb
hookDisplayWishlistBtnProductList	0.127 ms	- Mb
hookDisplayWishlistBtnProductList	0.105 ms	- Mb
hookDisplayWishlistBtnProductList	0.111 ms	- Mb
hookDisplayWishlistBtnProductList	0.098 ms	- Mb
hookDisplayWishlistBtnProductList	0.095 ms	- Mb
hookDisplayWishlistBtnProductList	0.093 ms	- Mb
hookDisplayWishlistBtnProductList	0.096 ms	- Mb
hookDisplayWishlistBtnProductList	0.096 ms	- Mb
hookDisplayWishlistBtnProductList	0.097 ms	- Mb
hookDisplayWishlistBtnProductList	0.092 ms	- Mb
hookDisplayWishlistBtnProductList	0.114 ms	- Mb
hookDisplayWishlistBtnProductList	0.121 ms	- Mb
hookDisplayWishlistBtnProductList	0.096 ms	- Mb
hookDisplayWishlistBtnProductList	0.117 ms	- Mb
hookDisplayWishlistBtnProductList	0.097 ms	- Mb
hookDisplayWishlistBtnProductList	0.102 ms	- Mb
hookDisplayWishlistBtnProductList	0.095 ms	- Mb
hookDisplayWishlistBtnProductList	0.110 ms	- Mb
hookDisplayWishlistBtnProductList	0.108 ms	- Mb
hookDisplayWishlistBtnProductList	0.150 ms	- Mb
hookDisplayWishlistBtnProductList	0.097 ms	- Mb
hookDisplayWishlistBtnProductList	0.102 ms	- Mb
hookDisplayWishlistBtnProductList	0.105 ms	- Mb
hookDisplayWishlistBtnProductList	0.134 ms	- Mb
hookDisplayWishlistBtnProductList	0.111 ms	- Mb
hookDisplayWishlistBtnProductList	0.104 ms	- Mb
hookDisplayWishlistBtnProductList	0.148 ms	- Mb
hookDisplayWishlistBtnProductList	0.112 ms	- Mb
hookDisplayWishlistBtnProductList	0.102 ms	- Mb
hookDisplayWishlistBtnProductList	0.098 ms	- Mb
hookDisplayWishlistBtnProductList	0.112 ms	- Mb
hookDisplayWishlistBtnProductList	0.124 ms	- Mb
hookDisplayWishlistBtnProductList	0.134 ms	- Mb
prettyurls	1.411 ms	0.03 Mb
__construct	0.121 ms	0.01 Mb
hookDisplayHeader	1.290 ms	0.02 Mb
tvcmsinfinitescroll	4.496 ms	0.08 Mb
__construct	0.096 ms	0.01 Mb
hookHeader	4.400 ms	0.07 Mb
tvcmscategoryproduct	0.221 ms	0.01 Mb
__construct	0.157 ms	0.01 Mb
hookHeader	0.064 ms	- Mb
tvcmsmegamenu	8.333 ms	0.36 Mb
__construct	0.147 ms	0.01 Mb
hookHeader	0.051 ms	- Mb
hookDisplayMegamenu	8.135 ms	0.35 Mb
ps_facetedsearch	0.879 ms	0.02 Mb
__construct	0.454 ms	0.01 Mb
hookProductSearchProvider	0.301 ms	- Mb
hookDisplayFacetedSearchBlock	0.124 ms	- Mb
lgcookieslaw	0.765 ms	0.07 Mb
__construct	0.530 ms	0.06 Mb
hookDisplayAfterTitleTag	0.195 ms	0.01 Mb
hookDisplayFooter	0.040 ms	- Mb
tvcmscustomcssjs	0.145 ms	0.01 Mb
__construct	0.134 ms	0.01 Mb
hookDisplayCustomCss	0.005 ms	- Mb
hookDisplayCustomJs	0.006 ms	- Mb
ps_customersignin	7.554 ms	0.06 Mb
__construct	0.095 ms	0.01 Mb
displayNavCustomerSignInBlock	7.459 ms	0.05 Mb
ps_languageselector	7.271 ms	0.34 Mb
__construct	0.096 ms	0.01 Mb
displayNavLanguageBlock	7.175 ms	0.33 Mb
ps_currencyselector	17.954 ms	0.82 Mb
__construct	0.085 ms	0.01 Mb
displayNavCurrencyBlock	17.869 ms	0.81 Mb
ps_contactinfo	3.071 ms	0.12 Mb
__construct	0.087 ms	0.01 Mb
displayNav1	1.945 ms	0.09 Mb
displayContactCinfo	1.039 ms	0.03 Mb
ps_categorytree	23.210 ms	0.83 Mb
__construct	0.058 ms	0.01 Mb
displayLeftColumn	23.152 ms	0.82 Mb
ps_brandlist	2.919 ms	0.12 Mb
__construct	0.107 ms	0.01 Mb
displayLeftColumn	2.812 ms	0.12 Mb
ps_supplierlist	2.609 ms	0.06 Mb
__construct	0.084 ms	0.01 Mb
displayLeftColumn	2.525 ms	0.05 Mb
tvcmsfootercategory	6.975 ms	0.34 Mb
__construct	0.178 ms	0.01 Mb
hookDisplayFooterCategory	6.797 ms	0.34 Mb
ps_linklist	3.952 ms	0.07 Mb
__construct	0.764 ms	0.01 Mb
displayFooterPart1	3.188 ms	0.06 Mb
ps_customeraccountlinks	3.117 ms	0.07 Mb
__construct	0.069 ms	0.01 Mb
displayMyaccountcblock	3.048 ms	0.06 Mb
47 module(s)	504.588 ms	16.59 Mb

159 queries	SELECT c., cl. FROM `zpXXh_category` c LEFT JOIN `zpXXh_category_lang` cl ON (c.`id_category` = cl.`id_category` AND `id_lang` = XX AND cl.id_shop = XX ) WHERE c.`id_category` = XX
81 queries	SELECT xcp.`id_category`,xcl.`name`,xcl.`link_rewrite` FROM `zpXXh_tvcms_category_post` xcp INNER JOIN `zpXXh_tvcmscategory` xc ON (xcp.`id_category` = xc.`id_tvcmscategory` AND xc.`category_type` = "tag") INNER JOIN `zpXXh_tvcmscategory_lang` xcl ON (xcp.`id_category` = xcl.`id_tvcmscategory` AND xcl.`id_lang` = XX) INNER JOIN `zpXXh_tvcmscategory_shop` xcs ON (xcp.`id_category` = xcs.`id_tvcmscategory` AND xcs.`id_shop` = XX) WHERE xcp.`id_post` = XX AND xcp.`type` = "tag"
81 queries	SELECT COUNT(id_tvcms_comments) AS total_comment FROM `zpXXh_tvcms_comments` xc WHERE xc.`id_post` = XX
48 queries	SELECT (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS grade FROM `zpXXh_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 `zpXXh_tvcmsproduct_comment` pc WHERE pc.`id_product` = XX AND pc.`deleted` = XX AND pc.`validate` = XX LIMIT XX
33 queries	SELECT * FROM `zpXXh_category` c LEFT JOIN `zpXXh_category_lang` `cl` ON c.id_category = cl.id_category AND id_lang = XX AND cl.id_shop = XX WHERE (c.nleft <= XX AND c.nright >= XX) ORDER BY c.nleft
23 queries	SELECT SUM(quantity) FROM `zpXXh_stock_available` WHERE (id_product = XX) AND (id_product_attribute = XX) AND (id_shop = XX) AND (id_shop_group = XX) LIMIT XX
23 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 `zpXXh_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 `zpXXh_cart_product` cp JOIN `zpXXh_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `zpXXh_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
21 queries	SELECT `id_module` FROM `zpXXh_module_shop` WHERE `id_module` = XX AND `id_shop` = XX LIMIT XX
21 queries	SELECT image_shop.`id_image` FROM `zpXXh_image` i INNER JOIN zpXXh_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
21 queries	SELECT name FROM zpXXh_category_lang WHERE id_shop = XX AND id_lang = XX AND id_category = XX LIMIT XX
21 queries	SELECT * FROM `zpXXh_product` a LEFT JOIN `zpXXh_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = XX LEFT JOIN `zpXXh_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
21 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 `zpXXh_product` p INNER JOIN `zpXXh_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = XX) LEFT JOIN `zpXXh_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)
21 queries	SELECT `id_tax_rules_group` FROM `zpXXh_product_shop` WHERE `id_product` = XX AND id_shop=XX LIMIT XX
21 queries	SELECT `reduction` FROM `zpXXh_product_group_reduction_cache` WHERE `id_product` = XX AND `id_group` = XX LIMIT XX
21 queries	SELECT COUNT(*) FROM `zpXXh_pack` WHERE id_product_pack = XX LIMIT XX
21 queries	SELECT product_type FROM `zpXXh_product` WHERE id_product = XX LIMIT XX
21 queries	SELECT image_shop.`cover`, i.`id_image`, il.`legend`, i.`position` FROM `zpXXh_image` i INNER JOIN zpXXh_image_shop image_shop ON (image_shop.id_image = i.id_image AND image_shop.id_shop = XX) LEFT JOIN `zpXXh_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = XX) WHERE i.`id_product` = XX ORDER BY `position`
21 queries	SELECT `id_product_attribute` FROM `zpXXh_product_attribute` WHERE `id_product` = XX
16 queries	SELECT name, value, pf.id_feature, f.position, fvl.id_feature_value FROM zpXXh_feature_product pf LEFT JOIN zpXXh_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = XX) LEFT JOIN zpXXh_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = XX) LEFT JOIN zpXXh_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = XX) INNER JOIN zpXXh_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
15 queries	SELECT * FROM `zpXXh_category` a LEFT JOIN `zpXXh_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = XX LEFT JOIN `zpXXh_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = XX WHERE (a.`id_category` = XX) AND (b.`id_shop` = XX) LIMIT XX
12 queries	SELECT COUNT(`id_tvcmsproduct_comment`) AS "nbr" FROM `zpXXh_tvcmsproduct_comment` pc WHERE `id_product` = XX AND `validate` = XX LIMIT XX
9 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 zpXXh_product p LEFT JOIN zpXXh_product_lang pl ON pl.id_product = p.id_product AND pl.id_shop = XX AND pl.id_lang = XX LEFT JOIN zpXXh_stock_available sa ON sa.id_product = p.id_product AND sa.id_product_attribute = XX AND sa.id_shop = XX LEFT JOIN zpXXh_product_shop ps ON ps.id_product = p.id_product AND ps.id_shop = XX WHERE p.id_product IN (XX)
8 queries	SELECT `id_lang` FROM `zpXXh_lang` WHERE `locale` = 'en-us' OR `language_code` = 'en-us' LIMIT XX
8 queries	SELECT id_meta FROM zpXXh_meta WHERE page = "category" LIMIT XX
8 queries	SELECT id_category FROM zpXXh_category_lang WHERE link_rewrite = "livres" AND id_lang = XX AND id_shop = XX LIMIT XX
7 queries	SELECT cl.`link_rewrite` FROM `zpXXh_category_lang` cl WHERE `id_lang` = XX AND cl.id_shop = XX AND cl.`id_category` = XX LIMIT XX
7 queries	SELECT c.`nleft`, c.`nright`, c.`level_depth` FROM `zpXXh_category` c WHERE (c.`id_category` = XX) LIMIT XX
5 queries	SELECT quantity, reserved_quantity FROM `zpXXh_stock_available` WHERE (id_product = XX) AND (id_product_attribute = XX) AND (id_shop = XX) AND (id_shop_group = XX) LIMIT XX
4 queries	SELECT * FROM `zpXXh_currency` a LEFT JOIN `zpXXh_currency_lang` `b` ON a.`id_currency` = b.`id_currency` AND b.`id_lang` = XX LEFT JOIN `zpXXh_currency_shop` `c` ON a.`id_currency` = c.`id_currency` AND c.`id_shop` = XX WHERE (a.`id_currency` = XX) LIMIT XX
4 queries	SELECT * FROM `zpXXh_currency` a LEFT JOIN `zpXXh_currency_shop` `c` ON a.`id_currency` = c.`id_currency` AND c.`id_shop` = XX WHERE (a.`id_currency` = XX) LIMIT XX
4 queries	SELECT * FROM `zpXXh_currency_lang` WHERE `id_currency` = XX
4 queries	SELECT * FROM `zpXXh_category` a LEFT JOIN `zpXXh_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = XX WHERE (a.`id_category` = XX) LIMIT XX
4 queries	SELECT * FROM `zpXXh_category_lang` WHERE `id_category` = XX AND `id_shop` = XX
4 queries	SELECT mr.* FROM zpXXh_tvcmsmegamenu_row_shop mr WHERE mr.`id_shop` = XX AND mr.id_tvcmsmegamenu = XX AND mr.`active` = XX
3 queries	SELECT `need_identification_number` FROM `zpXXh_country` WHERE `id_country` = XX LIMIT XX
3 queries	SELECT tr.* FROM `zpXXh_tax_rule` tr JOIN `zpXXh_tax_rules_group` trg ON (tr.`id_tax_rules_group` = trg.`id_tax_rules_group`) WHERE trg.`active` = XX AND tr.`id_country` = XX AND tr.`id_tax_rules_group` = XX AND tr.`id_state` IN (XX, XX) AND ('XX' BETWEEN tr.`zipcode_from` AND tr.`zipcode_to` OR (tr.`zipcode_to` = XX AND tr.`zipcode_from` IN(XX, 'XX'))) ORDER BY tr.`zipcode_from` DESC, tr.`zipcode_to` DESC, tr.`id_state` DESC, tr.`id_country` DESC
3 queries	SELECT * FROM zpXXh_product_attachment pa LEFT JOIN zpXXh_attachment a ON a.id_attachment = pa.id_attachment LEFT JOIN zpXXh_attachment_lang al ON (a.id_attachment = al.id_attachment AND al.id_lang = XX) WHERE pa.id_product = XX
3 queries	SELECT id_shop FROM `zpXXh_employee_shop` WHERE `id_employee` = XX
2 queries	SELECT * FROM `zpXXh_country` a LEFT JOIN `zpXXh_country_lang` `b` ON a.`id_country` = b.`id_country` AND b.`id_lang` = XX LEFT JOIN `zpXXh_country_shop` `c` ON a.`id_country` = c.`id_country` AND c.`id_shop` = XX WHERE (a.`id_country` = XX) LIMIT XX
2 queries	SELECT * FROM `zpXXh_lang` a LEFT JOIN `zpXXh_lang_shop` `c` ON a.`id_lang` = c.`id_lang` AND c.`id_shop` = XX WHERE (a.`id_lang` = XX) LIMIT XX
2 queries	SELECT id_shop FROM `zpXXh_lang_shop` WHERE `id_lang` = XX AND id_shop = XX LIMIT XX
2 queries	SELECT m.`id_module`, m.`name`, ms.`id_module`as `mshop` FROM `zpXXh_module` m LEFT JOIN `zpXXh_module_shop` ms ON m.`id_module` = ms.`id_module` AND ms.`id_shop` = XX
2 queries	SELECT m.page, ml.url_rewrite, ml.id_lang FROM `zpXXh_meta` m LEFT JOIN `zpXXh_meta_lang` ml ON (m.id_meta = ml.id_meta AND ml.id_shop = XX ) ORDER BY LENGTH(ml.url_rewrite) DESC
2 queries	SELECT id_meta FROM zpXXh_meta_lang WHERE url_rewrite = "livres" AND `id_lang` = XX AND `id_shop` = XX LIMIT XX
2 queries	SELECT `page` FROM zpXXh_meta WHERE id_meta = XX LIMIT XX
2 queries	SELECT `id_category` FROM `zpXXh_category_shop` WHERE `id_category` = XX AND `id_shop` = XX LIMIT XX
2 queries	SELECT ctg.`id_group` FROM zpXXh_category_group ctg WHERE ctg.`id_category` = XX AND ctg.`id_group` = XX LIMIT XX
2 queries	SELECT `name` FROM `zpXXh_hook` WHERE `id_hook` = XX LIMIT XX
2 queries	SELECT product_attribute_shop.`price` FROM `zpXXh_product_attribute` pa INNER JOIN zpXXh_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = XX) WHERE pa.`id_product_attribute` = XX LIMIT XX
2 queries	SELECT pa.`available_date` FROM `zpXXh_product` p LEFT JOIN `zpXXh_product_attribute` pa ON (pa.`id_product` = p.`id_product`) INNER JOIN zpXXh_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = XX) INNER JOIN zpXXh_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = XX) WHERE p.`id_product` = XX AND pa.`id_product` = XX AND pa.`id_product_attribute` = XX LIMIT XX
2 queries	SELECT a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, agl.`public_name` as `public_group`, pa.`reference`, pa.`eanXX`, pa.`isbn`, pa.`upc`, pa.`mpn`, pal.`available_now`, pal.`available_later` FROM `zpXXh_attribute` a LEFT JOIN `zpXXh_attribute_lang` al ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = XX) LEFT JOIN `zpXXh_product_attribute_combination` pac ON (pac.`id_attribute` = a.`id_attribute`) LEFT JOIN `zpXXh_product_attribute` pa ON (pa.`id_product_attribute` = pac.`id_product_attribute`) INNER JOIN zpXXh_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 `zpXXh_product_attribute_lang` pal ON (pal.`id_product_attribute` = pac.`id_product_attribute` AND pal.`id_lang` = XX) LEFT JOIN `zpXXh_attribute_group_lang` agl ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = XX) WHERE pa.`id_product` = XX AND pac.`id_product_attribute` = XX AND agl.`id_lang` = XX
2 queries	SELECT * FROM `zpXXh_product_attribute` a LEFT JOIN `zpXXh_product_attribute_shop` `c` ON a.`id_product_attribute` = c.`id_product_attribute` AND c.`id_shop` = XX WHERE (a.`id_product_attribute` = XX) LIMIT XX
2 queries	SELECT * FROM `zpXXh_product_attribute_lang` WHERE `id_product_attribute` = XX
2 queries	SELECT pai.`id_image`, pai.`id_product_attribute`, il.`legend` FROM `zpXXh_product_attribute_image` pai LEFT JOIN `zpXXh_image_lang` il ON (il.`id_image` = pai.`id_image`) LEFT JOIN `zpXXh_image` i ON (i.`id_image` = pai.`id_image`) WHERE pai.`id_product_attribute` IN (XX, XX) AND il.`id_lang` = XX ORDER by i.`position`
2 queries	SELECT * FROM `zpXXh_tvcms_image_type` WHERE active = XX AND id_shop = XX

Name	Instances	Source
Category	239	/controllers/front/listing/CategoryController.php:78 (__construct) [id: 3] /override/classes/Link.php:111 (getRootCategory) [id: 2] /override/classes/Link.php:111 (getRootCategory) [id: 2] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 5] /override/classes/Link.php:35 (__construct) [id: 5] /override/classes/Link.php:111 (getRootCategory) [id: 2] /override/classes/Link.php:111 (getRootCategory) [id: 2] /override/classes/Link.php:111 (getRootCategory) [id: 2] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 14] /override/classes/Link.php:35 (__construct) [id: 14] /override/classes/Link.php:111 (getRootCategory) [id: 2] /override/classes/Link.php:111 (getRootCategory) [id: 2] /override/classes/Link.php:111 (getRootCategory) [id: 2] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 4] /override/classes/Link.php:35 (__construct) [id: 4] /override/classes/Link.php:111 (getRootCategory) [id: 2] /override/classes/Link.php:111 (getRootCategory) [id: 2] /override/classes/Link.php:111 (getRootCategory) [id: 2] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 17] /override/classes/Link.php:35 (__construct) [id: 17] /override/classes/Link.php:111 (getRootCategory) [id: 2] /override/classes/Link.php:111 (getRootCategory) [id: 2] /override/classes/Link.php:111 (getRootCategory) [id: 2] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 15] /override/classes/Link.php:35 (__construct) [id: 15] /override/classes/Link.php:111 (getRootCategory) [id: 2] /override/classes/Link.php:111 (getRootCategory) [id: 2] /override/classes/Link.php:111 (getRootCategory) [id: 2] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 10] /override/classes/Link.php:35 (__construct) [id: 10] /override/classes/Link.php:111 (getRootCategory) [id: 2] /override/classes/Link.php:111 (getRootCategory) [id: 2] /override/classes/Link.php:111 (getRootCategory) [id: 2] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 12] /override/classes/Link.php:35 (__construct) [id: 12] /override/classes/Link.php:111 (getRootCategory) [id: 2] /override/classes/Link.php:111 (getRootCategory) [id: 2] /override/classes/Link.php:111 (getRootCategory) [id: 2] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 13] /override/classes/Link.php:35 (__construct) [id: 13] /override/classes/Link.php:111 (getRootCategory) [id: 2] /override/classes/Link.php:111 (getRootCategory) [id: 2] /override/classes/Link.php:111 (getRootCategory) [id: 2] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 11] /override/classes/Link.php:35 (__construct) [id: 11] /override/classes/Link.php:111 (getRootCategory) [id: 2] /override/classes/Link.php:111 (getRootCategory) [id: 2] /override/classes/Link.php:111 (getRootCategory) [id: 2] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 16] /override/classes/Link.php:35 (__construct) [id: 16] /override/classes/Link.php:111 (getRootCategory) [id: 2] /override/classes/Link.php:111 (getRootCategory) [id: 2] /override/classes/Link.php:111 (getRootCategory) [id: 2] /classes/Meta.php:380 (__construct) [id: 3] /override/classes/Link.php:111 (getRootCategory) [id: 2] /override/classes/Link.php:111 (getRootCategory) [id: 2] /override/classes/Link.php:35 (__construct) [id: 3] /override/classes/Link.php:111 (getRootCategory) [id: 2] /override/classes/Link.php:111 (getRootCategory) [id: 2] /override/classes/Link.php:35 (__construct) [id: 3] /override/classes/Link.php:111 (getRootCategory) [id: 2] /override/classes/Link.php:111 (getRootCategory) [id: 2] /classes/PrestaShopCollection.php:385 (hydrateCollection) [id: ] /classes/PrestaShopCollection.php:385 (hydrateCollection) [id: ] /override/classes/Link.php:111 (getRootCategory) [id: 2] /override/classes/Link.php:111 (getRootCategory) [id: 2] /classes/Meta.php:380 (__construct) [id: 3] /override/classes/Link.php:111 (getRootCategory) [id: 2] /override/classes/Link.php:111 (getRootCategory) [id: 2] /override/classes/Link.php:35 (__construct) [id: 3] /override/classes/Link.php:111 (getRootCategory) [id: 2] /override/classes/Link.php:111 (getRootCategory) [id: 2] /modules/ps_facetedsearch/src/Product/Search.php:364 (__construct) [id: 3] /modules/tvcmssearch/tvcmssearch.php:100 (getNestedCategories) [id: 2] /override/classes/Link.php:35 (__construct) [id: 3] /override/classes/Link.php:111 (getRootCategory) [id: 2] /override/classes/Link.php:111 (getRootCategory) [id: 2] /override/classes/Link.php:35 (__construct) [id: 3] /override/classes/Link.php:111 (getRootCategory) [id: 2] /override/classes/Link.php:111 (getRootCategory) [id: 2] /override/classes/Link.php:35 (__construct) [id: 3] /override/classes/Link.php:111 (getRootCategory) [id: 2] /override/classes/Link.php:111 (getRootCategory) [id: 2] /override/classes/Link.php:35 (__construct) [id: 3] /override/classes/Link.php:111 (getRootCategory) [id: 2] /override/classes/Link.php:111 (getRootCategory) [id: 2] /override/classes/Link.php:35 (__construct) [id: 3] /override/classes/Link.php:111 (getRootCategory) [id: 2] /override/classes/Link.php:111 (getRootCategory) [id: 2] /override/classes/Link.php:35 (__construct) [id: 3] /override/classes/Link.php:111 (getRootCategory) [id: 2] /override/classes/Link.php:111 (getRootCategory) [id: 2] /modules/tvcmsmegamenu/tvcmsmegamenu.php:1395 (__construct) [id: 3] /modules/tvcmsmegamenu/tvcmsmegamenu.php:1774 (__construct) [id: 3] /override/classes/Link.php:111 (getRootCategory) [id: 2] /override/classes/Link.php:111 (getRootCategory) [id: 2] /override/classes/Link.php:35 (__construct) [id: 3] /override/classes/Link.php:111 (getRootCategory) [id: 2] /override/classes/Link.php:111 (getRootCategory) [id: 2] /modules/tvcmsmegamenu/tvcmsmegamenu.php:1699 (__construct) [id: 3] /modules/ps_categorytree/ps_categorytree.php:364 (getParentsCategories) [id: 2] /override/classes/Link.php:35 (__construct) [id: 10] /override/classes/Link.php:111 (getRootCategory) [id: 2] /override/classes/Link.php:111 (getRootCategory) [id: 2] /override/classes/Link.php:111 (getRootCategory) [id: 2] /override/classes/Link.php:35 (__construct) [id: 11] /override/classes/Link.php:111 (getRootCategory) [id: 2] /override/classes/Link.php:111 (getRootCategory) [id: 2] /override/classes/Link.php:111 (getRootCategory) [id: 2] /override/classes/Link.php:35 (__construct) [id: 13] /override/classes/Link.php:111 (getRootCategory) [id: 2] /override/classes/Link.php:111 (getRootCategory) [id: 2] /override/classes/Link.php:111 (getRootCategory) [id: 2] /override/classes/Link.php:35 (__construct) [id: 5] /override/classes/Link.php:111 (getRootCategory) [id: 2] /override/classes/Link.php:111 (getRootCategory) [id: 2] /override/classes/Link.php:111 (getRootCategory) [id: 2] /override/classes/Link.php:35 (__construct) [id: 12] /override/classes/Link.php:111 (getRootCategory) [id: 2] /override/classes/Link.php:111 (getRootCategory) [id: 2] /override/classes/Link.php:111 (getRootCategory) [id: 2] /override/classes/Link.php:35 (__construct) [id: 17] /override/classes/Link.php:111 (getRootCategory) [id: 2] /override/classes/Link.php:111 (getRootCategory) [id: 2] /override/classes/Link.php:111 (getRootCategory) [id: 2] /override/classes/Link.php:35 (__construct) [id: 14] /override/classes/Link.php:111 (getRootCategory) [id: 2] /override/classes/Link.php:111 (getRootCategory) [id: 2] /override/classes/Link.php:111 (getRootCategory) [id: 2] /override/classes/Link.php:35 (__construct) [id: 4] /override/classes/Link.php:111 (getRootCategory) [id: 2] /override/classes/Link.php:111 (getRootCategory) [id: 2] /override/classes/Link.php:111 (getRootCategory) [id: 2] /override/classes/Link.php:35 (__construct) [id: 15] /override/classes/Link.php:111 (getRootCategory) [id: 2] /override/classes/Link.php:111 (getRootCategory) [id: 2] /override/classes/Link.php:111 (getRootCategory) [id: 2] /override/classes/Link.php:35 (__construct) [id: 16] /override/classes/Link.php:111 (getRootCategory) [id: 2] /override/classes/Link.php:111 (getRootCategory) [id: 2] /override/classes/Link.php:111 (getRootCategory) [id: 2] /override/classes/Link.php:35 (__construct) [id: 3] /override/classes/Link.php:111 (getRootCategory) [id: 2] /override/classes/Link.php:111 (getRootCategory) [id: 2] /modules/tvcmstabproducts/tvcmstabproducts.php:2683 (__construct) [id: 2] /override/classes/Link.php:35 (__construct) [id: 2] /override/classes/Link.php:111 (getRootCategory) [id: 2] /override/classes/Link.php:35 (__construct) [id: 5] /override/classes/Link.php:111 (getRootCategory) [id: 2] /override/classes/Link.php:111 (getRootCategory) [id: 2] /override/classes/Link.php:111 (getRootCategory) [id: 2] /override/classes/Link.php:35 (__construct) [id: 5] /override/classes/Link.php:111 (getRootCategory) [id: 2] /override/classes/Link.php:111 (getRootCategory) [id: 2] /override/classes/Link.php:111 (getRootCategory) [id: 2] /override/classes/Link.php:35 (__construct) [id: 14] /override/classes/Link.php:111 (getRootCategory) [id: 2] /override/classes/Link.php:111 (getRootCategory) [id: 2] /override/classes/Link.php:111 (getRootCategory) [id: 2] /override/classes/Link.php:35 (__construct) [id: 14] /override/classes/Link.php:111 (getRootCategory) [id: 2] /override/classes/Link.php:111 (getRootCategory) [id: 2] /override/classes/Link.php:111 (getRootCategory) [id: 2] /override/classes/Link.php:35 (__construct) [id: 4] /override/classes/Link.php:111 (getRootCategory) [id: 2] /override/classes/Link.php:111 (getRootCategory) [id: 2] /override/classes/Link.php:111 (getRootCategory) [id: 2] /override/classes/Link.php:35 (__construct) [id: 4] /override/classes/Link.php:111 (getRootCategory) [id: 2] /override/classes/Link.php:111 (getRootCategory) [id: 2] /override/classes/Link.php:111 (getRootCategory) [id: 2] /override/classes/Link.php:35 (__construct) [id: 17] /override/classes/Link.php:111 (getRootCategory) [id: 2] /override/classes/Link.php:111 (getRootCategory) [id: 2] /override/classes/Link.php:111 (getRootCategory) [id: 2] /override/classes/Link.php:35 (__construct) [id: 17] /override/classes/Link.php:111 (getRootCategory) [id: 2] /override/classes/Link.php:111 (getRootCategory) [id: 2] /override/classes/Link.php:111 (getRootCategory) [id: 2] /override/classes/Link.php:35 (__construct) [id: 15] /override/classes/Link.php:111 (getRootCategory) [id: 2] /override/classes/Link.php:111 (getRootCategory) [id: 2] /override/classes/Link.php:111 (getRootCategory) [id: 2] /override/classes/Link.php:35 (__construct) [id: 15] /override/classes/Link.php:111 (getRootCategory) [id: 2] /override/classes/Link.php:111 (getRootCategory) [id: 2] /override/classes/Link.php:111 (getRootCategory) [id: 2] /override/classes/Link.php:35 (__construct) [id: 10] /override/classes/Link.php:111 (getRootCategory) [id: 2] /override/classes/Link.php:111 (getRootCategory) [id: 2] /override/classes/Link.php:111 (getRootCategory) [id: 2] /override/classes/Link.php:35 (__construct) [id: 10] /override/classes/Link.php:111 (getRootCategory) [id: 2] /override/classes/Link.php:111 (getRootCategory) [id: 2] /override/classes/Link.php:111 (getRootCategory) [id: 2] /override/classes/Link.php:35 (__construct) [id: 12] /override/classes/Link.php:111 (getRootCategory) [id: 2] /override/classes/Link.php:111 (getRootCategory) [id: 2] /override/classes/Link.php:111 (getRootCategory) [id: 2] /override/classes/Link.php:35 (__construct) [id: 12] /override/classes/Link.php:111 (getRootCategory) [id: 2] /override/classes/Link.php:111 (getRootCategory) [id: 2] /override/classes/Link.php:111 (getRootCategory) [id: 2] /override/classes/Link.php:35 (__construct) [id: 13] /override/classes/Link.php:111 (getRootCategory) [id: 2] /override/classes/Link.php:111 (getRootCategory) [id: 2] /override/classes/Link.php:111 (getRootCategory) [id: 2] /override/classes/Link.php:35 (__construct) [id: 13] /override/classes/Link.php:111 (getRootCategory) [id: 2] /override/classes/Link.php:111 (getRootCategory) [id: 2] /override/classes/Link.php:111 (getRootCategory) [id: 2] /override/classes/Link.php:35 (__construct) [id: 11] /override/classes/Link.php:111 (getRootCategory) [id: 2] /override/classes/Link.php:111 (getRootCategory) [id: 2] /override/classes/Link.php:111 (getRootCategory) [id: 2] /override/classes/Link.php:35 (__construct) [id: 11] /override/classes/Link.php:111 (getRootCategory) [id: 2] /override/classes/Link.php:111 (getRootCategory) [id: 2] /override/classes/Link.php:111 (getRootCategory) [id: 2] /override/classes/Link.php:35 (__construct) [id: 16] /override/classes/Link.php:111 (getRootCategory) [id: 2] /override/classes/Link.php:111 (getRootCategory) [id: 2] /override/classes/Link.php:111 (getRootCategory) [id: 2] /override/classes/Link.php:35 (__construct) [id: 16] /override/classes/Link.php:111 (getRootCategory) [id: 2] /override/classes/Link.php:111 (getRootCategory) [id: 2] /override/classes/Link.php:111 (getRootCategory) [id: 2] /modules/tvcmsfootercategory/tvcmsfootercategory.php:401 (__construct) [id: 3] /override/classes/Link.php:35 (__construct) [id: 3] /override/classes/Link.php:111 (getRootCategory) [id: 2] /override/classes/Link.php:111 (getRootCategory) [id: 2] /modules/tvcmsfootercategory/tvcmsfootercategory.php:401 (__construct) [id: 6] /override/classes/Link.php:35 (__construct) [id: 6] /override/classes/Link.php:111 (getRootCategory) [id: 2] /override/classes/Link.php:111 (getRootCategory) [id: 2] /modules/tvcmsfootercategory/tvcmsfootercategory.php:401 (__construct) [id: 18] /override/classes/Link.php:35 (__construct) [id: 18] /override/classes/Link.php:111 (getRootCategory) [id: 2] /override/classes/Link.php:111 (getRootCategory) [id: 2]
Product	54	/classes/Link.php:113 (__construct) [id: 418] /classes/Link.php:113 (__construct) [id: 512] /classes/Link.php:113 (__construct) [id: 399] /classes/Link.php:113 (__construct) [id: 490] /classes/Link.php:113 (__construct) [id: 410] /classes/Link.php:113 (__construct) [id: 433] /classes/Link.php:113 (__construct) [id: 491] /classes/Link.php:113 (__construct) [id: 364] /classes/Link.php:113 (__construct) [id: 397] /classes/Link.php:113 (__construct) [id: 420] /classes/Link.php:113 (__construct) [id: 422] /classes/Link.php:113 (__construct) [id: 351] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 418] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 512] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 399] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 490] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 410] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 433] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 491] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 364] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 397] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 420] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 422] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 351] /classes/Link.php:113 (__construct) [id: 418] /classes/Link.php:113 (__construct) [id: 512] /classes/Link.php:113 (__construct) [id: 399] /classes/Link.php:113 (__construct) [id: 490] /classes/Link.php:113 (__construct) [id: 410] /classes/Link.php:113 (__construct) [id: 433] /classes/Link.php:113 (__construct) [id: 491] /classes/Link.php:113 (__construct) [id: 364] /classes/Link.php:113 (__construct) [id: 397] /classes/Link.php:113 (__construct) [id: 420] /classes/Link.php:113 (__construct) [id: 422] /classes/Link.php:113 (__construct) [id: 351] /classes/Link.php:113 (__construct) [id: 539] /classes/Link.php:113 (__construct) [id: 537] /classes/Link.php:113 (__construct) [id: 536] /classes/Link.php:113 (__construct) [id: 535] /classes/Link.php:113 (__construct) [id: 534] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 539] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 537] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 536] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 535] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 534] /classes/Link.php:113 (__construct) [id: 458] /classes/Link.php:113 (__construct) [id: 456] /classes/Link.php:113 (__construct) [id: 394] /classes/Link.php:113 (__construct) [id: 385] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 458] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 456] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 394] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 385]
Currency	8	/src/Adapter/Currency/CurrencyDataProvider.php:101 (__construct) [id: 4] /src/Adapter/Currency/CurrencyDataProvider.php:101 (__construct) [id: 1] /src/Adapter/Currency/CurrencyDataProvider.php:101 (__construct) [id: 2] /src/Adapter/Currency/CurrencyDataProvider.php:101 (__construct) [id: 3] /classes/Tools.php:695 (getCurrencyInstance) [id: 1] /modules/ps_currencyselector/ps_currencyselector.php:112 (getCurrencies) [id: 4] /modules/ps_currencyselector/ps_currencyselector.php:112 (getCurrencies) [id: 2] /modules/ps_currencyselector/ps_currencyselector.php:112 (getCurrencies) [id: 3]
Country	8	/config/config.inc.php:146 (__construct) [id: 8] /classes/controller/FrontController.php:354 (__construct) [id: 8] /classes/AddressFormat.php:404 (__construct) [id: 8] /classes/controller/FrontController.php:1779 (__construct) [id: 8] /classes/AddressFormat.php:404 (__construct) [id: 8] /modules/ps_contactinfo/ps_contactinfo.php:105 (__construct) [id: 8] /classes/AddressFormat.php:404 (__construct) [id: 8] /modules/ps_contactinfo/ps_contactinfo.php:105 (__construct) [id: 8]
Address	4	/classes/shop/Shop.php:486 (__construct) [id: ] /classes/Product.php:3694 (initialize) [id: ] /classes/Product.php:3804 (__construct) [id: ] /classes/Product.php:5964 (__construct) [id: ]
TvcmsCategoryClass	3	/modules/tvcmsblog/classes/tvcmspostsclass.php:775 (__construct) [id: 0] /modules/tvcmsblog/classes/tvcmspostsclass.php:775 (__construct) [id: 0] /modules/tvcmsblog/classes/tvcmspostsclass.php:775 (__construct) [id: 0]
Employee	3	/modules/tvcmsblog/classes/tvcmspostsclass.php:729 (__construct) [id: 1] /modules/tvcmsblog/classes/tvcmspostsclass.php:729 (__construct) [id: 1] /modules/tvcmsblog/classes/tvcmspostsclass.php:729 (__construct) [id: 1]
Language	3	/config/config.inc.php:211 (__construct) [id: 1] /classes/Tools.php:641 (__construct) [id: 3] /classes/Tools.php:560 (__construct) [id: 3]
AddressFormat	3	/classes/controller/FrontController.php:1773 (generateAddress) [id: ] /modules/ps_contactinfo/ps_contactinfo.php:91 (generateAddress) [id: ] /modules/ps_contactinfo/ps_contactinfo.php:91 (generateAddress) [id: ]
State	3	/classes/controller/FrontController.php:1778 (__construct) [id: 0] /modules/ps_contactinfo/ps_contactinfo.php:94 (__construct) [id: 0] /modules/ps_contactinfo/ps_contactinfo.php:94 (__construct) [id: 0]
Cart	2	/classes/controller/FrontController.php:467 (__construct) [id: ] /classes/controller/FrontController.php:541 (__construct) [id: ]
Combination	2	/classes/Product.php:5912 (__construct) [id: 61] /classes/Product.php:5912 (__construct) [id: 51]
Tax	2	/classes/tax/TaxRulesTaxManager.php:116 (__construct) [id: 3] /classes/tax/TaxRulesTaxManager.php:116 (__construct) [id: 3]
TvcmsMegaMenuClass	1	/modules/tvcmsmegamenu/tvcmsmegamenu.php:1384 (__construct) [id: ]
Shop	1	/config/config.inc.php:117 (initialize) [id: 1]
Gender	1	/classes/controller/FrontController.php:1702 (__construct) [id: 0]
Group	1	/classes/Cart.php:249 (getCurrent) [id: 1]
Customer	1	/config/config.inc.php:264 (__construct) [id: ]
ShopGroup	1	/classes/shop/Shop.php:561 (__construct) [id: 1]
Risk	1	/classes/controller/FrontController.php:1705 (__construct) [id: ]

#	Query	Time (ms)	Rows	Filesort	Group By	Location
152	SELECT SQL_NO_CACHE p.id_product FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, pl.name FROM zp1h_product p LEFT JOIN zp1h_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN zp1h_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN zp1h_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 zp1h_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN zp1h_product_lang pl ON (p.id_product = pl.id_product AND pl.id_shop = 1 AND pl.id_lang = 3) INNER JOIN zp1h_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN zp1h_category_product cp ON (p.id_product = cp.id_product) INNER JOIN zp1h_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN zp1h_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>=3 AND c.nright<=30 GROUP BY p.id_product) p INNER JOIN zp1h_product_lang pl ON (p.id_product = pl.id_product AND pl.id_shop = 1 AND pl.id_lang = 3) GROUP BY p.id_product ORDER BY p.name ASC, p.id_product DESC	11.243 ms	1472	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Filters/Products.php:87 (execute) /modules/ps_facetedsearch/src/Product/SearchProvider.php:187 (getProductByFilters) /classes/controller/ProductListingFrontController.php:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
2	SELECT SQL_NO_CACHE c.`name`, cl.`id_lang`, IF(cl.`id_lang` IS NULL, c.`value`, cl.`value`) AS value, c.id_shop_group, c.id_shop FROM `zp1h_configuration` c LEFT JOIN `zp1h_configuration_lang` cl ON (c.`id_configuration` = cl.`id_configuration`)	10.761 ms	3146			/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)
292	SELECT SQL_NO_CACHE * FROM `zp1h_product` a LEFT JOIN `zp1h_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 3 LEFT JOIN `zp1h_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1 WHERE (a.`id_product` = 420) AND (b.`id_shop` = 1) LIMIT 1	9.812 ms	1			/src/Adapter/EntityMapper.php:71 /classes/ObjectModel.php:283 (load) /tools/profiling/ObjectModel.php:32 (__construct) /classes/Product.php:725 (__construct) /classes/Link.php:113 (__construct) /override/classes/Link.php:657 (getProductObject) /classes/Product.php:5660 (getProductLink) /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)
585	SELECT SQL_NO_CACHE * FROM `zp1h_category` c LEFT JOIN `zp1h_category_lang` `cl` ON c.id_category = cl.id_category AND id_lang = 3 AND cl.id_shop = 1 WHERE (c.nleft <= 14 AND c.nright >= 15) ORDER BY c.nleft	8.769 ms	9			/classes/Product.php:7854 /override/classes/Link.php:660 (getParentCategories) /classes/Product.php:5660 (getProductLink) /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:1083 (hookdisplayLeftColumn) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:421 (coreCallHook) /classes/Hook.php:989 (callHookOn) /config/smarty.config.inc.php:201 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/dev/smarty/compile/v1_bookbloom_93layouts_layout_left_column_tpl/00/16/77/001677cb0c2c90434042285ef18a2fff36182aae_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/dev/smarty/compile/v1_bookbloom_93layouts_layout_left_column_tpl/00/16/77/001677cb0c2c90434042285ef18a2fff36182aae_2.file.layout-both-columns.tpl.php:74 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68372f6838e869_72646199) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/v1_bookbloom_93layouts_layout_left_column_tpl/4d/db/63/4ddb6394ada23a7738f786704f24712786897bb0_2.file.layout-left-column.tpl.php:28 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68372f68371763_03768153) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/v1_bookbloom_93layouts_layout_left_column_tpl/fb/a6/9e/fba69e6f2df3dc7caa0566fb6dfb82b90cfeda03_2.file.product-list.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68372f683605b9_40838013) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/v1_bookbloom_93layouts_layout_left_column_tpl/45/43/a3/4543a363728a82e475bf989da0bf83752509fd5f_2.file.category.tpl.php:29 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68372f68342b23_59724056) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/Smarty/SmartyDev.php:40 (fetch) /classes/controller/FrontController.php:771 (fetch) /classes/controller/FrontController.php:753 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
557	SELECT SQL_NO_CACHE p., product_shop., stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, product_attribute_shop.minimal_quantity AS product_attribute_minimal_quantity,IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, pl.`description`, pl.`description_short`, pl.`link_rewrite`, pl.`meta_description`, pl.`meta_keywords`, pl.`meta_title`, pl.`name`, pl.`available_now`, pl.`available_later`, m.`name` AS manufacturer_name, p.`id_manufacturer` as id_manufacturer, image_shop.`id_image` id_image, il.`legend`, ps.`quantity` AS sales, t.`rate`, pl.`meta_keywords`, pl.`meta_title`, pl.`meta_description`, DATEDIFF(p.`date_add`, DATE_SUB("2025-05-28 00:00:00", INTERVAL 1000 DAY)) > 0 AS new FROM `zp1h_product_sale` ps LEFT JOIN `zp1h_product` p ON ps.`id_product` = p.`id_product` LEFT JOIN zp1h_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) LEFT JOIN `zp1h_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 `zp1h_product_lang` pl ON p.`id_product` = pl.`id_product` AND pl.`id_lang` = 3 AND pl.id_shop = 1 LEFT JOIN `zp1h_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 `zp1h_image_lang` il ON (image_shop.`id_image` = il.`id_image` AND il.`id_lang` = 3) LEFT JOIN `zp1h_manufacturer` m ON (m.`id_manufacturer` = p.`id_manufacturer`) LEFT JOIN `zp1h_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 `zp1h_tax` t ON (t.`id_tax` = tr.`id_tax`) LEFT JOIN zp1h_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 `zp1h_category_product` cp JOIN `zp1h_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	7.161 ms	368	Yes		/classes/ProductSale.php:151 /src/Adapter/BestSales/BestSalesProductSearchProvider.php:74 (getBestSales) /modules/tvcmstabproducts/tvcmstabproducts.php:2879 (runQuery) /modules/tvcmsbestsellerproducts/tvcmsbestsellerproducts.php:156 (displayBestSellers) /modules/tvcmsbestsellerproducts/tvcmsbestsellerproducts.php:269 (showFrontSideResult) /classes/Hook.php:1083 (hookdisplayLeftColumn) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:421 (coreCallHook) /classes/Hook.php:989 (callHookOn) /config/smarty.config.inc.php:201 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/dev/smarty/compile/v1_bookbloom_93layouts_layout_left_column_tpl/00/16/77/001677cb0c2c90434042285ef18a2fff36182aae_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/dev/smarty/compile/v1_bookbloom_93layouts_layout_left_column_tpl/00/16/77/001677cb0c2c90434042285ef18a2fff36182aae_2.file.layout-both-columns.tpl.php:74 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68372f6838e869_72646199) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/v1_bookbloom_93layouts_layout_left_column_tpl/4d/db/63/4ddb6394ada23a7738f786704f24712786897bb0_2.file.layout-left-column.tpl.php:28 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68372f68371763_03768153) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/v1_bookbloom_93layouts_layout_left_column_tpl/fb/a6/9e/fba69e6f2df3dc7caa0566fb6dfb82b90cfeda03_2.file.product-list.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68372f683605b9_40838013) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/v1_bookbloom_93layouts_layout_left_column_tpl/45/43/a3/4543a363728a82e475bf989da0bf83752509fd5f_2.file.category.tpl.php:29 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68372f68342b23_59724056) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/Smarty/SmartyDev.php:40 (fetch) /classes/controller/FrontController.php:771 (fetch) /classes/controller/FrontController.php:753 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
456	SELECT SQL_NO_CACHE `id_module` FROM `zp1h_module` WHERE `name` = "ps_customersignin" LIMIT 1	6.604 ms	1			/classes/module/Module.php:2664 /classes/module/Module.php:2136 (getModuleIdByName) /classes/Hook.php:1089 (isEnabled) /tools/profiling/Hook.php:64 (coreRenderWidget) /classes/Hook.php:1025 (coreRenderWidget) /config/smarty.config.inc.php:201 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/dev/smarty/compile/v1_bookbloom_93layouts_layout_left_column_tpl/cf/04/af/cf04af256bd75617c42fcbd0c9bb303c293bd3d3_2.file.desk-header-2.tpl.php:36 (__call) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68372f687834d6_91887919) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php: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/dev/smarty/compile/v1_bookbloom_93layouts_layout_left_column_tpl/72/7c/f5/727cf56060da8a894b02ea0e83ca12d00dbbdd5f_2.file.desktop-header.tpl.php:25 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68372f6876c851_83452145) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php: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/dev/smarty/compile/v1_bookbloom_93layouts_layout_left_column_tpl/af/9b/b1/af9bb1e5a1d7eee85bce11ce60374101faad5df0_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/dev/smarty/compile/v1_bookbloom_93layouts_layout_left_column_tpl/af/9b/b1/af9bb1e5a1d7eee85bce11ce60374101faad5df0_2.file.header.tpl.php:29 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68372f6875b9b5_87659696) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php: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/dev/smarty/compile/v1_bookbloom_93layouts_layout_left_column_tpl/00/16/77/001677cb0c2c90434042285ef18a2fff36182aae_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/dev/smarty/compile/v1_bookbloom_93layouts_layout_left_column_tpl/00/16/77/001677cb0c2c90434042285ef18a2fff36182aae_2.file.layout-both-columns.tpl.php:64 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68372f6838e869_72646199) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/v1_bookbloom_93layouts_layout_left_column_tpl/4d/db/63/4ddb6394ada23a7738f786704f24712786897bb0_2.file.layout-left-column.tpl.php:28 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68372f68371763_03768153) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/v1_bookbloom_93layouts_layout_left_column_tpl/fb/a6/9e/fba69e6f2df3dc7caa0566fb6dfb82b90cfeda03_2.file.product-list.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68372f683605b9_40838013) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/v1_bookbloom_93layouts_layout_left_column_tpl/45/43/a3/4543a363728a82e475bf989da0bf83752509fd5f_2.file.category.tpl.php:29 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68372f68342b23_59724056) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/Smarty/SmartyDev.php:40 (fetch) /classes/controller/FrontController.php:771 (fetch) /classes/controller/FrontController.php:753 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
352	SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position` FROM `zp1h_image` i INNER JOIN zp1h_image_shop image_shop ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1) LEFT JOIN `zp1h_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 3) WHERE i.`id_product` = 420 ORDER BY `position`	6.494 ms	3	Yes		/classes/Product.php:3545 /src/Adapter/Image/ImageRetriever.php:84 (getImages) /src/Adapter/Presenter/Product/ProductLazyArray.php:684 (getAllProductImages) /src/Adapter/Presenter/Product/ProductLazyArray.php:127 (fillImages) /src/Adapter/Presenter/Product/ProductListingPresenter.php:57 (__construct) /classes/controller/ProductListingFrontController.php:119 (present) /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)
289	SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position, fvl.id_feature_value FROM zp1h_feature_product pf LEFT JOIN zp1h_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 3) LEFT JOIN zp1h_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 3) LEFT JOIN zp1h_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 3) INNER JOIN zp1h_feature_shop feature_shop ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1) WHERE pf.id_product = 397 ORDER BY f.position ASC	6.115 ms	3	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)
189	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 `zp1h_cart_product` cp WHERE cp.`id_product_attribute` = 0 AND cp.`id_cart` = 0 AND cp.`id_product` = 512 UNION SELECT 0 as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity FROM `zp1h_cart_product` cp JOIN `zp1h_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `zp1h_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` = 512 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1	5.515 ms	0			/classes/Cart.php:1430 /classes/Product.php:4361 (getProductQuantity) /classes/Product.php:5802 (getQuantity) /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)
75	SELECT SQL_NO_CACHE c., cl. FROM `zp1h_category` c LEFT JOIN `zp1h_category_lang` cl ON (c.`id_category` = cl.`id_category` AND `id_lang` = 3 AND cl.id_shop = 1 ) WHERE c.`id_category` = 3	5.352 ms	1			/override/classes/Link.php:120 /override/classes/Link.php:50 (getAllParentCategories) /controllers/front/listing/CategoryController.php:226 (getCategoryLink) :undefined ({closure}) /controllers/front/listing/CategoryController.php:230 (array_map) /controllers/front/listing/CategoryController.php:118 (getTemplateVarSubCategories) /override/controllers/front/CategoryController.php:57 (init) /tools/profiling/Controller.php:41 (init) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
16	SELECT SQL_NO_CACHE h.`name` as hook, m.`id_module`, h.`id_hook`, m.`name` as module FROM `zp1h_module` m INNER JOIN zp1h_module_shop module_shop ON (module_shop.id_module = m.id_module AND module_shop.id_shop = 1 AND module_shop.enable_device & 1) INNER JOIN `zp1h_hook_module` `hm` ON hm.`id_module` = m.`id_module` INNER JOIN `zp1h_hook` `h` ON hm.`id_hook` = h.`id_hook` LEFT JOIN `zp1h_module_group` `mg` ON mg.`id_module` = m.`id_module` WHERE (h.`name` != "paymentOptions") AND (hm.`id_shop` = 1) AND (mg.id_shop = 1 AND mg.`id_group` IN (1)) GROUP BY hm.id_hook, hm.id_module ORDER BY hm.`position`	4.185 ms	1944	Yes	Yes	/classes/Hook.php:1289 /classes/Hook.php:738 (getAllHookRegistrations) /classes/Hook.php:848 (getHookModuleExecList) /override/classes/Dispatcher.php:180 (exec) /classes/Dispatcher.php:243 (loadRoutes) /override/classes/Dispatcher.php:30 (__construct) /classes/Dispatcher.php:201 (__construct) /index.php:28 (getInstance)
256	SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position, fvl.id_feature_value FROM zp1h_feature_product pf LEFT JOIN zp1h_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 3) LEFT JOIN zp1h_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 3) LEFT JOIN zp1h_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 3) INNER JOIN zp1h_feature_shop feature_shop ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1) WHERE pf.id_product = 491 ORDER BY f.position ASC	3.985 ms	4	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)
714	SELECT SQL_NO_CACHE xcp.`id_category`,xcl.`name`,xcl.`link_rewrite` FROM `zp1h_tvcms_category_post` xcp INNER JOIN `zp1h_tvcmscategory` xc ON (xcp.`id_category` = xc.`id_tvcmscategory` AND xc.`category_type` = "tag") INNER JOIN `zp1h_tvcmscategory_lang` xcl ON (xcp.`id_category` = xcl.`id_tvcmscategory` AND xcl.`id_lang` = 3) INNER JOIN `zp1h_tvcmscategory_shop` xcs ON (xcp.`id_category` = xcs.`id_tvcmscategory` AND xcs.`id_shop` = 1) WHERE xcp.`id_post` = 3 AND xcp.`type` = "tag"	3.813 ms	7			/modules/tvcmsblog/classes/tvcmspostsclass.php:577 /modules/tvcmsblog/classes/tvcmspostsclass.php:747 (getPostTagsResults) /modules/tvcmsblogdisplayposts/tvcmsblogdisplayposts.php:418 (getCategoryPosts) /modules/tvcmsblogdisplayposts/tvcmsblogdisplayposts.php:483 (showFrontSideResult) /classes/Hook.php:1083 (hookdisplayLeftColumn) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:421 (coreCallHook) /classes/Hook.php:989 (callHookOn) /config/smarty.config.inc.php:201 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/dev/smarty/compile/v1_bookbloom_93layouts_layout_left_column_tpl/00/16/77/001677cb0c2c90434042285ef18a2fff36182aae_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/dev/smarty/compile/v1_bookbloom_93layouts_layout_left_column_tpl/00/16/77/001677cb0c2c90434042285ef18a2fff36182aae_2.file.layout-both-columns.tpl.php:74 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68372f6838e869_72646199) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/v1_bookbloom_93layouts_layout_left_column_tpl/4d/db/63/4ddb6394ada23a7738f786704f24712786897bb0_2.file.layout-left-column.tpl.php:28 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68372f68371763_03768153) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/v1_bookbloom_93layouts_layout_left_column_tpl/fb/a6/9e/fba69e6f2df3dc7caa0566fb6dfb82b90cfeda03_2.file.product-list.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68372f683605b9_40838013) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/v1_bookbloom_93layouts_layout_left_column_tpl/45/43/a3/4543a363728a82e475bf989da0bf83752509fd5f_2.file.category.tpl.php:29 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68372f68342b23_59724056) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/Smarty/SmartyDev.php:40 (fetch) /classes/controller/FrontController.php:771 (fetch) /classes/controller/FrontController.php:753 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
164	SELECT SQL_NO_CACHE h.id_hook, h.name as h_name, title, description, h.position, hm.position as hm_position, m.id_module, m.name, m.active FROM `zp1h_hook_module` hm STRAIGHT_JOIN `zp1h_hook` h ON (h.id_hook = hm.id_hook AND hm.id_shop = 1) STRAIGHT_JOIN `zp1h_module` as m ON (m.id_module = hm.id_module) ORDER BY hm.position	3.494 ms	717			/classes/Hook.php:459 /classes/Hook.php:496 (getHookModuleList) /classes/tax/TaxManagerFactory.php:67 (getModulesFromHook) /classes/tax/TaxManagerFactory.php:46 (execHookTaxManagerFactory) /classes/Product.php:3925 (getManager) /classes/Product.php:3717 (priceCalculation) /classes/Product.php:5692 (getPriceStatic) /classes/ProductAssembler.php:209 (getProductProperties) /classes/controller/ProductListingFrontController.php:108 (assembleProducts) /classes/controller/ProductListingFrontController.php:379 (prepareMultipleProductsForTemplate) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
227	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 `zp1h_cart_product` cp WHERE cp.`id_product_attribute` = 0 AND cp.`id_cart` = 0 AND cp.`id_product` = 410 UNION SELECT 0 as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity FROM `zp1h_cart_product` cp JOIN `zp1h_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `zp1h_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` = 410 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1	3.208 ms	0			/classes/Cart.php:1430 /classes/Product.php:4361 (getProductQuantity) /classes/Product.php:5802 (getQuantity) /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)
471	SELECT SQL_NO_CACHE * FROM `zp1h_currency` c INNER JOIN zp1h_currency_shop currency_shop ON (currency_shop.id_currency = c.id_currency AND currency_shop.id_shop = 1) WHERE c.`deleted` = 0 AND c.`active` = 1 ORDER BY `iso_code` ASC	2.996 ms	4	Yes		/classes/Currency.php:694 /classes/Currency.php:669 (findAll) /modules/ps_currencyselector/ps_currencyselector.php:112 (getCurrencies) /modules/ps_currencyselector/ps_currencyselector.php:127 (getWidgetVariables) /classes/Hook.php:1094 (renderWidget) /tools/profiling/Hook.php:64 (coreRenderWidget) /classes/Hook.php:1025 (coreRenderWidget) /config/smarty.config.inc.php:201 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/dev/smarty/compile/v1_bookbloom_93layouts_layout_left_column_tpl/cf/04/af/cf04af256bd75617c42fcbd0c9bb303c293bd3d3_2.file.desk-header-2.tpl.php:42 (__call) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68372f687834d6_91887919) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php: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/dev/smarty/compile/v1_bookbloom_93layouts_layout_left_column_tpl/72/7c/f5/727cf56060da8a894b02ea0e83ca12d00dbbdd5f_2.file.desktop-header.tpl.php:25 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68372f6876c851_83452145) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php: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/dev/smarty/compile/v1_bookbloom_93layouts_layout_left_column_tpl/af/9b/b1/af9bb1e5a1d7eee85bce11ce60374101faad5df0_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/dev/smarty/compile/v1_bookbloom_93layouts_layout_left_column_tpl/af/9b/b1/af9bb1e5a1d7eee85bce11ce60374101faad5df0_2.file.header.tpl.php:29 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68372f6875b9b5_87659696) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php: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/dev/smarty/compile/v1_bookbloom_93layouts_layout_left_column_tpl/00/16/77/001677cb0c2c90434042285ef18a2fff36182aae_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/dev/smarty/compile/v1_bookbloom_93layouts_layout_left_column_tpl/00/16/77/001677cb0c2c90434042285ef18a2fff36182aae_2.file.layout-both-columns.tpl.php:64 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68372f6838e869_72646199) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/v1_bookbloom_93layouts_layout_left_column_tpl/4d/db/63/4ddb6394ada23a7738f786704f24712786897bb0_2.file.layout-left-column.tpl.php:28 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68372f68371763_03768153) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/v1_bookbloom_93layouts_layout_left_column_tpl/fb/a6/9e/fba69e6f2df3dc7caa0566fb6dfb82b90cfeda03_2.file.product-list.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68372f683605b9_40838013) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/v1_bookbloom_93layouts_layout_left_column_tpl/45/43/a3/4543a363728a82e475bf989da0bf83752509fd5f_2.file.category.tpl.php:29 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68372f68342b23_59724056) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/Smarty/SmartyDev.php:40 (fetch) /classes/controller/FrontController.php:771 (fetch) /classes/controller/FrontController.php:753 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
72	SELECT SQL_NO_CACHE c.*, cl.`id_lang`, cl.`name`, cl.`description`, cl.`additional_description`, cl.`link_rewrite`, cl.`meta_title`, cl.`meta_keywords`, cl.`meta_description` FROM `zp1h_category` c INNER JOIN zp1h_category_shop category_shop ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1) LEFT JOIN `zp1h_category_lang` cl ON (c.`id_category` = cl.`id_category` AND `id_lang` = 3 AND cl.id_shop = 1 ) LEFT JOIN `zp1h_category_group` cg ON (cg.`id_category` = c.`id_category`) WHERE `id_parent` = 3 AND `active` = 1 AND cg.`id_group` =1 GROUP BY c.`id_category` ORDER BY `level_depth` ASC, category_shop.`position` ASC	2.884 ms	22	Yes	Yes	/classes/Category.php:924 /controllers/front/listing/CategoryController.php:230 (getSubCategories) /controllers/front/listing/CategoryController.php:118 (getTemplateVarSubCategories) /override/controllers/front/CategoryController.php:57 (init) /tools/profiling/Controller.php:41 (init) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
163	SELECT SQL_NO_CACHE `id_hook`, `name` FROM `zp1h_hook` UNION SELECT `id_hook`, ha.`alias` as name FROM `zp1h_hook_alias` ha INNER JOIN `zp1h_hook` h ON ha.name = h.name	2.812 ms	0			/classes/Hook.php:1348 /classes/Hook.php:228 (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)
581	SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position, fvl.id_feature_value FROM zp1h_feature_product pf LEFT JOIN zp1h_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 3) LEFT JOIN zp1h_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 3) LEFT JOIN zp1h_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 3) INNER JOIN zp1h_feature_shop feature_shop ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1) WHERE pf.id_product = 456 ORDER BY f.position ASC	2.804 ms	4	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:1083 (hookdisplayLeftColumn) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:421 (coreCallHook) /classes/Hook.php:989 (callHookOn) /config/smarty.config.inc.php:201 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/dev/smarty/compile/v1_bookbloom_93layouts_layout_left_column_tpl/00/16/77/001677cb0c2c90434042285ef18a2fff36182aae_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/dev/smarty/compile/v1_bookbloom_93layouts_layout_left_column_tpl/00/16/77/001677cb0c2c90434042285ef18a2fff36182aae_2.file.layout-both-columns.tpl.php:74 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68372f6838e869_72646199) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/v1_bookbloom_93layouts_layout_left_column_tpl/4d/db/63/4ddb6394ada23a7738f786704f24712786897bb0_2.file.layout-left-column.tpl.php:28 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68372f68371763_03768153) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/v1_bookbloom_93layouts_layout_left_column_tpl/fb/a6/9e/fba69e6f2df3dc7caa0566fb6dfb82b90cfeda03_2.file.product-list.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68372f683605b9_40838013) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/v1_bookbloom_93layouts_layout_left_column_tpl/45/43/a3/4543a363728a82e475bf989da0bf83752509fd5f_2.file.category.tpl.php:29 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68372f68342b23_59724056) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/Smarty/SmartyDev.php:40 (fetch) /classes/controller/FrontController.php:771 (fetch) /classes/controller/FrontController.php:753 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
345	SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position` FROM `zp1h_image` i INNER JOIN zp1h_image_shop image_shop ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1) LEFT JOIN `zp1h_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 3) WHERE i.`id_product` = 491 ORDER BY `position`	2.779 ms	4	Yes		/classes/Product.php:3545 /src/Adapter/Image/ImageRetriever.php:84 (getImages) /src/Adapter/Presenter/Product/ProductLazyArray.php:684 (getAllProductImages) /src/Adapter/Presenter/Product/ProductLazyArray.php:127 (fillImages) /src/Adapter/Presenter/Product/ProductListingPresenter.php:57 (__construct) /classes/controller/ProductListingFrontController.php:119 (present) /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)
373	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( "2025-05-28 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 `zp1h_product` p INNER JOIN zp1h_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) LEFT JOIN `zp1h_product_lang` `pl` ON p.`id_product` = pl.`id_product` AND pl.`id_lang` = 3 AND pl.id_shop = 1 LEFT JOIN `zp1h_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 `zp1h_image_lang` `il` ON image_shop.`id_image` = il.`id_image` AND il.`id_lang` = 3 LEFT JOIN `zp1h_manufacturer` `m` ON m.`id_manufacturer` = p.`id_manufacturer` LEFT JOIN `zp1h_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 zp1h_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( "2025-05-28 00:00:00", INTERVAL 1000 DAY ) ) > 0) AND (EXISTS(SELECT 1 FROM `zp1h_category_product` cp JOIN `zp1h_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 5	2.690 ms	4			/classes/Product.php:3110 /modules/tvcmsproductpopup/tvcmsproductpopup.php:368 (getNewProducts) /modules/tvcmsproductpopup/tvcmsproductpopup.php:253 (getNewProducts) /modules/tvcmsproductpopup/tvcmsproductpopup.php:547 (prevHook) /classes/Hook.php:1083 (hookdisplayAfterBodyOpeningTag) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:421 (coreCallHook) /classes/Hook.php:989 (callHookOn) /config/smarty.config.inc.php:201 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/dev/smarty/compile/v1_bookbloom_93layouts_layout_left_column_tpl/00/16/77/001677cb0c2c90434042285ef18a2fff36182aae_2.file.layout-both-columns.tpl.php:116 (__call) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/v1_bookbloom_93layouts_layout_left_column_tpl/00/16/77/001677cb0c2c90434042285ef18a2fff36182aae_2.file.layout-both-columns.tpl.php:54 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68372f6838e869_72646199) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/v1_bookbloom_93layouts_layout_left_column_tpl/4d/db/63/4ddb6394ada23a7738f786704f24712786897bb0_2.file.layout-left-column.tpl.php:28 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68372f68371763_03768153) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/v1_bookbloom_93layouts_layout_left_column_tpl/fb/a6/9e/fba69e6f2df3dc7caa0566fb6dfb82b90cfeda03_2.file.product-list.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68372f683605b9_40838013) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/v1_bookbloom_93layouts_layout_left_column_tpl/45/43/a3/4543a363728a82e475bf989da0bf83752509fd5f_2.file.category.tpl.php:29 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68372f68342b23_59724056) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/Smarty/SmartyDev.php:40 (fetch) /classes/controller/FrontController.php:771 (fetch) /classes/controller/FrontController.php:753 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
954	SELECT SQL_NO_CACHE (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS avg, MIN(pc.`grade`) AS min, MAX(pc.`grade`) AS max FROM `zp1h_tvcmsproduct_comment` pc WHERE pc.`id_product` = 351 AND pc.`deleted` = 0 AND pc.`validate` = 1 LIMIT 1	2.683 ms	1			/modules/tvcmsproductcomments/tvcmsproductcomment.php:212 /modules/tvcmsproductcomments/tvcmsproductcomments.php:934 (getRatings) /classes/Hook.php:1083 (hookdisplayReviewProductList) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:421 (coreCallHook) /classes/Hook.php:989 (callHookOn) /config/smarty.config.inc.php:201 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/dev/smarty/compile/v1_bookbloom_93layouts_layout_left_column_tpl/1d/96/4d/1d964ded51899311a4c4245e19b93665b29e9bf7_2.file.product-grid-view.tpl.php:32 (__call) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68372f76ae5d35_12704104) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:384 (render) /var/cache/dev/smarty/compile/v1_bookbloom_93layouts_layout_left_column_tpl/64/95/5d/64955d7ed372eefb1574e580b815b7ab408bd7a4_2.file.product.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/dev/smarty/compile/v1_bookbloom_93layouts_layout_left_column_tpl/64/95/5d/64955d7ed372eefb1574e580b815b7ab408bd7a4_2.file.product.tpl.php:34 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68372f76ab89f2_31253705) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:384 (render) /var/cache/dev/smarty/compile/v1_bookbloom_93layouts_layout_left_column_tpl/20/30/7a/20307a7e1d867f801d097690fb6338ced9d470ed_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/dev/smarty/compile/v1_bookbloom_93layouts_layout_left_column_tpl/20/30/7a/20307a7e1d867f801d097690fb6338ced9d470ed_2.file.products.tpl.php:34 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68372f76aa3c06_78445702) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php: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/dev/smarty/compile/v1_bookbloom_93layouts_layout_left_column_tpl/fb/a6/9e/fba69e6f2df3dc7caa0566fb6dfb82b90cfeda03_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/dev/smarty/compile/v1_bookbloom_93layouts_layout_left_column_tpl/fb/a6/9e/fba69e6f2df3dc7caa0566fb6dfb82b90cfeda03_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/dev/smarty/compile/v1_bookbloom_93layouts_layout_left_column_tpl/4d/db/63/4ddb6394ada23a7738f786704f24712786897bb0_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/dev/smarty/compile/v1_bookbloom_93layouts_layout_left_column_tpl/00/16/77/001677cb0c2c90434042285ef18a2fff36182aae_2.file.layout-both-columns.tpl.php:76 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68372f6838e869_72646199) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/v1_bookbloom_93layouts_layout_left_column_tpl/4d/db/63/4ddb6394ada23a7738f786704f24712786897bb0_2.file.layout-left-column.tpl.php:28 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68372f68371763_03768153) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/v1_bookbloom_93layouts_layout_left_column_tpl/fb/a6/9e/fba69e6f2df3dc7caa0566fb6dfb82b90cfeda03_2.file.product-list.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68372f683605b9_40838013) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/v1_bookbloom_93layouts_layout_left_column_tpl/45/43/a3/4543a363728a82e475bf989da0bf83752509fd5f_2.file.category.tpl.php:29 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68372f68342b23_59724056) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/Smarty/SmartyDev.php:40 (fetch) /classes/controller/FrontController.php:771 (fetch) /classes/controller/FrontController.php:753 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
567	SELECT SQL_NO_CACHE SUM(quantity) FROM `zp1h_stock_available` WHERE (id_product = 458) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1	2.681 ms	1			/classes/stock/StockAvailable.php:453 /classes/Product.php:4349 (getQuantityAvailableByProduct) /classes/Product.php:5802 (getQuantity) /classes/Product.php:5990 (getProductProperties) /classes/ProductSale.php:161 (getProductsProperties) /src/Adapter/BestSales/BestSalesProductSearchProvider.php:74 (getBestSales) /modules/tvcmstabproducts/tvcmstabproducts.php:2879 (runQuery) /modules/tvcmsbestsellerproducts/tvcmsbestsellerproducts.php:156 (displayBestSellers) /modules/tvcmsbestsellerproducts/tvcmsbestsellerproducts.php:269 (showFrontSideResult) /classes/Hook.php:1083 (hookdisplayLeftColumn) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:421 (coreCallHook) /classes/Hook.php:989 (callHookOn) /config/smarty.config.inc.php:201 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/dev/smarty/compile/v1_bookbloom_93layouts_layout_left_column_tpl/00/16/77/001677cb0c2c90434042285ef18a2fff36182aae_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/dev/smarty/compile/v1_bookbloom_93layouts_layout_left_column_tpl/00/16/77/001677cb0c2c90434042285ef18a2fff36182aae_2.file.layout-both-columns.tpl.php:74 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68372f6838e869_72646199) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/v1_bookbloom_93layouts_layout_left_column_tpl/4d/db/63/4ddb6394ada23a7738f786704f24712786897bb0_2.file.layout-left-column.tpl.php:28 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68372f68371763_03768153) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/v1_bookbloom_93layouts_layout_left_column_tpl/fb/a6/9e/fba69e6f2df3dc7caa0566fb6dfb82b90cfeda03_2.file.product-list.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68372f683605b9_40838013) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/v1_bookbloom_93layouts_layout_left_column_tpl/45/43/a3/4543a363728a82e475bf989da0bf83752509fd5f_2.file.category.tpl.php:29 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68372f68342b23_59724056) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/Smarty/SmartyDev.php:40 (fetch) /classes/controller/FrontController.php:771 (fetch) /classes/controller/FrontController.php:753 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
553	SELECT SQL_NO_CACHE p., product_shop., stock.out_of_stock, IFNULL(stock.quantity, 0) AS quantity, IFNULL(product_attribute_shop.id_product_attribute, 0) AS id_product_attribute, product_attribute_shop.minimal_quantity AS product_attribute_minimal_quantity, pl.`description`, pl.`description_short`, pl.`available_now`, pl.`available_later`, pl.`link_rewrite`, pl.`meta_description`, pl.`meta_keywords`, pl.`meta_title`, pl.`name`, image_shop.`id_image` id_image, il.`legend` as legend, m.`name` AS manufacturer_name, cl.`name` AS category_default, DATEDIFF(product_shop.`date_add`, DATE_SUB("2025-05-28 00:00:00", INTERVAL 1000 DAY)) > 0 AS new, product_shop.price AS orderprice FROM `zp1h_category_product` cp LEFT JOIN `zp1h_product` p ON p.`id_product` = cp.`id_product` INNER JOIN zp1h_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) LEFT JOIN `zp1h_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 zp1h_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 `zp1h_category_lang` cl ON (product_shop.`id_category_default` = cl.`id_category` AND cl.`id_lang` = 3 AND cl.id_shop = 1 ) LEFT JOIN `zp1h_product_lang` pl ON (p.`id_product` = pl.`id_product` AND pl.`id_lang` = 3 AND pl.id_shop = 1 ) LEFT JOIN `zp1h_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 `zp1h_image_lang` il ON (image_shop.`id_image` = il.`id_image` AND il.`id_lang` = 3) LEFT JOIN `zp1h_manufacturer` m ON m.`id_manufacturer` = p.`id_manufacturer` WHERE product_shop.`id_shop` = 1 AND cp.`id_category` = 2 AND product_shop.`active` = 1 AND product_shop.`visibility` IN ("both", "catalog") ORDER BY RAND() LIMIT 4	2.576 ms	1	Yes		/classes/Category.php:1062 /src/Adapter/Category/CategoryProductSearchProvider.php:79 (getProducts) /src/Adapter/Category/CategoryProductSearchProvider.php:105 (getProductsOrCount) /modules/tvcmstabproducts/tvcmstabproducts.php:2708 (runQuery) /modules/tvcmsfeaturedproducts/tvcmsfeaturedproducts.php:158 (displayFeaturedProducts) /modules/tvcmsfeaturedproducts/tvcmsfeaturedproducts.php:281 (showFrontSideResult) /classes/Hook.php:1083 (hookdisplayLeftColumn) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:421 (coreCallHook) /classes/Hook.php:989 (callHookOn) /config/smarty.config.inc.php:201 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/dev/smarty/compile/v1_bookbloom_93layouts_layout_left_column_tpl/00/16/77/001677cb0c2c90434042285ef18a2fff36182aae_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/dev/smarty/compile/v1_bookbloom_93layouts_layout_left_column_tpl/00/16/77/001677cb0c2c90434042285ef18a2fff36182aae_2.file.layout-both-columns.tpl.php:74 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68372f6838e869_72646199) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/v1_bookbloom_93layouts_layout_left_column_tpl/4d/db/63/4ddb6394ada23a7738f786704f24712786897bb0_2.file.layout-left-column.tpl.php:28 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68372f68371763_03768153) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/v1_bookbloom_93layouts_layout_left_column_tpl/fb/a6/9e/fba69e6f2df3dc7caa0566fb6dfb82b90cfeda03_2.file.product-list.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68372f683605b9_40838013) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/v1_bookbloom_93layouts_layout_left_column_tpl/45/43/a3/4543a363728a82e475bf989da0bf83752509fd5f_2.file.category.tpl.php:29 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68372f68342b23_59724056) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/Smarty/SmartyDev.php:40 (fetch) /classes/controller/FrontController.php:771 (fetch) /classes/controller/FrontController.php:753 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
606	SELECT SQL_NO_CACHE COUNT(ps.`id_product`) AS nb FROM `zp1h_product_sale` ps LEFT JOIN `zp1h_product` p ON p.`id_product` = ps.`id_product` LEFT JOIN zp1h_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) WHERE product_shop.`active` = 1 LIMIT 1	2.486 ms	184			/classes/ProductSale.php:60 /src/Adapter/BestSales/BestSalesProductSearchProvider.php:79 (getNbSales) /modules/tvcmstabproducts/tvcmstabproducts.php:2879 (runQuery) /modules/tvcmsbestsellerproducts/tvcmsbestsellerproducts.php:156 (displayBestSellers) /modules/tvcmsbestsellerproducts/tvcmsbestsellerproducts.php:269 (showFrontSideResult) /classes/Hook.php:1083 (hookdisplayLeftColumn) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:421 (coreCallHook) /classes/Hook.php:989 (callHookOn) /config/smarty.config.inc.php:201 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/dev/smarty/compile/v1_bookbloom_93layouts_layout_left_column_tpl/00/16/77/001677cb0c2c90434042285ef18a2fff36182aae_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/dev/smarty/compile/v1_bookbloom_93layouts_layout_left_column_tpl/00/16/77/001677cb0c2c90434042285ef18a2fff36182aae_2.file.layout-both-columns.tpl.php:74 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68372f6838e869_72646199) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/v1_bookbloom_93layouts_layout_left_column_tpl/4d/db/63/4ddb6394ada23a7738f786704f24712786897bb0_2.file.layout-left-column.tpl.php:28 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68372f68371763_03768153) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/v1_bookbloom_93layouts_layout_left_column_tpl/fb/a6/9e/fba69e6f2df3dc7caa0566fb6dfb82b90cfeda03_2.file.product-list.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68372f683605b9_40838013) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/v1_bookbloom_93layouts_layout_left_column_tpl/45/43/a3/4543a363728a82e475bf989da0bf83752509fd5f_2.file.category.tpl.php:29 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68372f68342b23_59724056) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/Smarty/SmartyDev.php:40 (fetch) /classes/controller/FrontController.php:771 (fetch) /classes/controller/FrontController.php:753 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
823	SELECT SQL_NO_CACHE c., cl. FROM `zp1h_category` c LEFT JOIN `zp1h_category_lang` cl ON (c.`id_category` = cl.`id_category` AND `id_lang` = 3 AND cl.id_shop = 1 ) WHERE c.`id_category` = 2	2.400 ms	1			/override/classes/Link.php:120 /override/classes/Link.php:50 (getAllParentCategories) /var/cache/dev/smarty/compile/v1_bookbloom_93layouts_layout_left_column_tpl/45/43/a3/4543a363728a82e475bf989da0bf83752509fd5f_2.file.category.tpl.php:69 (getCategoryLink) /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/dev/smarty/compile/v1_bookbloom_93layouts_layout_left_column_tpl/fb/a6/9e/fba69e6f2df3dc7caa0566fb6dfb82b90cfeda03_2.file.product-list.tpl.php:123 (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/dev/smarty/compile/v1_bookbloom_93layouts_layout_left_column_tpl/4d/db/63/4ddb6394ada23a7738f786704f24712786897bb0_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/dev/smarty/compile/v1_bookbloom_93layouts_layout_left_column_tpl/00/16/77/001677cb0c2c90434042285ef18a2fff36182aae_2.file.layout-both-columns.tpl.php:76 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68372f6838e869_72646199) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/v1_bookbloom_93layouts_layout_left_column_tpl/4d/db/63/4ddb6394ada23a7738f786704f24712786897bb0_2.file.layout-left-column.tpl.php:28 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68372f68371763_03768153) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/v1_bookbloom_93layouts_layout_left_column_tpl/fb/a6/9e/fba69e6f2df3dc7caa0566fb6dfb82b90cfeda03_2.file.product-list.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68372f683605b9_40838013) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/v1_bookbloom_93layouts_layout_left_column_tpl/45/43/a3/4543a363728a82e475bf989da0bf83752509fd5f_2.file.category.tpl.php:29 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68372f68342b23_59724056) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/Smarty/SmartyDev.php:40 (fetch) /classes/controller/FrontController.php:771 (fetch) /classes/controller/FrontController.php:753 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
549	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( "2025-05-28 00:00:00", INTERVAL 1000 DAY ) ) > 0 AS new FROM `zp1h_product` p INNER JOIN zp1h_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) LEFT JOIN `zp1h_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 zp1h_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 `zp1h_product_lang` pl ON ( p.`id_product` = pl.`id_product` AND pl.`id_lang` = 3 AND pl.id_shop = 1 ) LEFT JOIN `zp1h_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 `zp1h_image_lang` il ON (image_shop.`id_image` = il.`id_image` AND il.`id_lang` = 3) LEFT JOIN `zp1h_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 (0) AND EXISTS(SELECT 1 FROM `zp1h_category_product` cp JOIN `zp1h_category_group` cg ON (cp.id_category = cg.id_category AND cg.`id_group` =1) WHERE cp.`id_product` = p.`id_product`)	2.367 ms	0			/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:1083 (hookdisplayLeftColumn) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:421 (coreCallHook) /classes/Hook.php:989 (callHookOn) /config/smarty.config.inc.php:201 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/dev/smarty/compile/v1_bookbloom_93layouts_layout_left_column_tpl/00/16/77/001677cb0c2c90434042285ef18a2fff36182aae_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/dev/smarty/compile/v1_bookbloom_93layouts_layout_left_column_tpl/00/16/77/001677cb0c2c90434042285ef18a2fff36182aae_2.file.layout-both-columns.tpl.php:74 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68372f6838e869_72646199) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/v1_bookbloom_93layouts_layout_left_column_tpl/4d/db/63/4ddb6394ada23a7738f786704f24712786897bb0_2.file.layout-left-column.tpl.php:28 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68372f68371763_03768153) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/v1_bookbloom_93layouts_layout_left_column_tpl/fb/a6/9e/fba69e6f2df3dc7caa0566fb6dfb82b90cfeda03_2.file.product-list.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68372f683605b9_40838013) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/v1_bookbloom_93layouts_layout_left_column_tpl/45/43/a3/4543a363728a82e475bf989da0bf83752509fd5f_2.file.category.tpl.php:29 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68372f68342b23_59724056) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/Smarty/SmartyDev.php:40 (fetch) /classes/controller/FrontController.php:771 (fetch) /classes/controller/FrontController.php:753 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
17	SELECT SQL_NO_CACHE `name`, `alias` FROM `zp1h_hook_alias`	2.303 ms	88			/classes/Hook.php:290 /classes/Hook.php:321 (getAllHookAliases) /classes/Hook.php:749 (getHookAliasesFor) /classes/Hook.php:848 (getHookModuleExecList) /override/classes/Dispatcher.php:180 (exec) /classes/Dispatcher.php:243 (loadRoutes) /override/classes/Dispatcher.php:30 (__construct) /classes/Dispatcher.php:201 (__construct) /index.php:28 (getInstance)
275	SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, agl.`public_name` as `public_group`, pa.`reference`, pa.`ean13`, pa.`isbn`, pa.`upc`, pa.`mpn`, pal.`available_now`, pal.`available_later` FROM `zp1h_attribute` a LEFT JOIN `zp1h_attribute_lang` al ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 3) LEFT JOIN `zp1h_product_attribute_combination` pac ON (pac.`id_attribute` = a.`id_attribute`) LEFT JOIN `zp1h_product_attribute` pa ON (pa.`id_product_attribute` = pac.`id_product_attribute`) INNER JOIN zp1h_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) LEFT JOIN `zp1h_product_attribute_lang` pal ON (pal.`id_product_attribute` = pac.`id_product_attribute` AND pal.`id_lang` = 3) LEFT JOIN `zp1h_attribute_group_lang` agl ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 3) WHERE pa.`id_product` = 364 AND pac.`id_product_attribute` = 61 AND agl.`id_lang` = 3	2.222 ms	1			/classes/Product.php:7535 /classes/Product.php:5857 (getAttributesParams) /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)
154	SELECT SQL_NO_CACHE p., ps., pl.*, sa.out_of_stock, IFNULL(sa.quantity, 0) as quantity, (DATEDIFF( p.`date_add`, DATE_SUB( '2025-05-28 00:00:00', INTERVAL 1000 DAY ) ) > 0) as new FROM zp1h_product p LEFT JOIN zp1h_product_lang pl ON pl.id_product = p.id_product AND pl.id_shop = 1 AND pl.id_lang = 3 LEFT JOIN zp1h_stock_available sa ON sa.id_product = p.id_product AND sa.id_product_attribute = 0 AND sa.id_shop = 1 LEFT JOIN zp1h_product_shop ps ON ps.id_product = p.id_product AND ps.id_shop = 1 WHERE p.id_product IN (418,512,399,490,410,433,491,364,397,420,422,351)	2.218 ms	12			/classes/ProductAssembler.php:95 /classes/ProductAssembler.php:203 (addMissingProductFieldsForMultipleProducts) /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)
202	SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position, fvl.id_feature_value FROM zp1h_feature_product pf LEFT JOIN zp1h_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 3) LEFT JOIN zp1h_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 3) LEFT JOIN zp1h_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 3) INNER JOIN zp1h_feature_shop feature_shop ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1) WHERE pf.id_product = 399 ORDER BY f.position ASC	2.184 ms	3	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)
593	SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position, fvl.id_feature_value FROM zp1h_feature_product pf LEFT JOIN zp1h_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 3) LEFT JOIN zp1h_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 3) LEFT JOIN zp1h_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 3) INNER JOIN zp1h_feature_shop feature_shop ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1) WHERE pf.id_product = 394 ORDER BY f.position ASC	2.136 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:1083 (hookdisplayLeftColumn) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:421 (coreCallHook) /classes/Hook.php:989 (callHookOn) /config/smarty.config.inc.php:201 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/dev/smarty/compile/v1_bookbloom_93layouts_layout_left_column_tpl/00/16/77/001677cb0c2c90434042285ef18a2fff36182aae_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/dev/smarty/compile/v1_bookbloom_93layouts_layout_left_column_tpl/00/16/77/001677cb0c2c90434042285ef18a2fff36182aae_2.file.layout-both-columns.tpl.php:74 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68372f6838e869_72646199) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/v1_bookbloom_93layouts_layout_left_column_tpl/4d/db/63/4ddb6394ada23a7738f786704f24712786897bb0_2.file.layout-left-column.tpl.php:28 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68372f68371763_03768153) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/v1_bookbloom_93layouts_layout_left_column_tpl/fb/a6/9e/fba69e6f2df3dc7caa0566fb6dfb82b90cfeda03_2.file.product-list.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68372f683605b9_40838013) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/v1_bookbloom_93layouts_layout_left_column_tpl/45/43/a3/4543a363728a82e475bf989da0bf83752509fd5f_2.file.category.tpl.php:29 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68372f68342b23_59724056) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/Smarty/SmartyDev.php:40 (fetch) /classes/controller/FrontController.php:771 (fetch) /classes/controller/FrontController.php:753 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
15	SELECT SQL_NO_CACHE lower(name) as name FROM `zp1h_hook` h WHERE (h.active = 1)	2.126 ms	1136			/classes/Hook.php:1388 /classes/Hook.php:817 (getHookStatusByName) /override/classes/Dispatcher.php:180 (exec) /classes/Dispatcher.php:243 (loadRoutes) /override/classes/Dispatcher.php:30 (__construct) /classes/Dispatcher.php:201 (__construct) /index.php:28 (getInstance)
613	SELECT SQL_NO_CACHE p., ps., pl.*, sa.out_of_stock, IFNULL(sa.quantity, 0) as quantity, (DATEDIFF( p.`date_add`, DATE_SUB( '2025-05-28 00:00:00', INTERVAL 1000 DAY ) ) > 0) as new FROM zp1h_product p LEFT JOIN zp1h_product_lang pl ON pl.id_product = p.id_product AND pl.id_shop = 1 AND pl.id_lang = 3 LEFT JOIN zp1h_stock_available sa ON sa.id_product = p.id_product AND sa.id_product_attribute = 0 AND sa.id_shop = 1 LEFT JOIN zp1h_product_shop ps ON ps.id_product = p.id_product AND ps.id_shop = 1 WHERE p.id_product IN (394)	2.101 ms	1			/classes/ProductAssembler.php:64 /classes/ProductAssembler.php:182 (addMissingProductFields) /modules/tvcmstabproducts/tvcmstabproducts.php:2912 (assembleProduct) /modules/tvcmsbestsellerproducts/tvcmsbestsellerproducts.php:156 (displayBestSellers) /modules/tvcmsbestsellerproducts/tvcmsbestsellerproducts.php:269 (showFrontSideResult) /classes/Hook.php:1083 (hookdisplayLeftColumn) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:421 (coreCallHook) /classes/Hook.php:989 (callHookOn) /config/smarty.config.inc.php:201 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/dev/smarty/compile/v1_bookbloom_93layouts_layout_left_column_tpl/00/16/77/001677cb0c2c90434042285ef18a2fff36182aae_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/dev/smarty/compile/v1_bookbloom_93layouts_layout_left_column_tpl/00/16/77/001677cb0c2c90434042285ef18a2fff36182aae_2.file.layout-both-columns.tpl.php:74 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68372f6838e869_72646199) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/v1_bookbloom_93layouts_layout_left_column_tpl/4d/db/63/4ddb6394ada23a7738f786704f24712786897bb0_2.file.layout-left-column.tpl.php:28 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68372f68371763_03768153) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/v1_bookbloom_93layouts_layout_left_column_tpl/fb/a6/9e/fba69e6f2df3dc7caa0566fb6dfb82b90cfeda03_2.file.product-list.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68372f683605b9_40838013) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/v1_bookbloom_93layouts_layout_left_column_tpl/45/43/a3/4543a363728a82e475bf989da0bf83752509fd5f_2.file.category.tpl.php:29 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68372f68342b23_59724056) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/Smarty/SmartyDev.php:40 (fetch) /classes/controller/FrontController.php:771 (fetch) /classes/controller/FrontController.php:753 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
328	SELECT SQL_NO_CACHE pa.`available_date` FROM `zp1h_product` p LEFT JOIN `zp1h_product_attribute` pa ON (pa.`id_product` = p.`id_product`) INNER JOIN zp1h_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) INNER JOIN zp1h_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 p.`id_product` = 351 AND pa.`id_product` = 351 AND pa.`id_product_attribute` = 51 LIMIT 1	2.025 ms	1			/classes/Product.php:1209 /classes/Product.php:5818 (getAvailableDate) /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)
616	SELECT SQL_NO_CACHE p., ps., pl.*, sa.out_of_stock, IFNULL(sa.quantity, 0) as quantity, (DATEDIFF( p.`date_add`, DATE_SUB( '2025-05-28 00:00:00', INTERVAL 1000 DAY ) ) > 0) as new FROM zp1h_product p LEFT JOIN zp1h_product_lang pl ON pl.id_product = p.id_product AND pl.id_shop = 1 AND pl.id_lang = 3 LEFT JOIN zp1h_stock_available sa ON sa.id_product = p.id_product AND sa.id_product_attribute = 0 AND sa.id_shop = 1 LEFT JOIN zp1h_product_shop ps ON ps.id_product = p.id_product AND ps.id_shop = 1 WHERE p.id_product IN (385)	2.024 ms	1			/classes/ProductAssembler.php:64 /classes/ProductAssembler.php:182 (addMissingProductFields) /modules/tvcmstabproducts/tvcmstabproducts.php:2912 (assembleProduct) /modules/tvcmsbestsellerproducts/tvcmsbestsellerproducts.php:156 (displayBestSellers) /modules/tvcmsbestsellerproducts/tvcmsbestsellerproducts.php:269 (showFrontSideResult) /classes/Hook.php:1083 (hookdisplayLeftColumn) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:421 (coreCallHook) /classes/Hook.php:989 (callHookOn) /config/smarty.config.inc.php:201 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/dev/smarty/compile/v1_bookbloom_93layouts_layout_left_column_tpl/00/16/77/001677cb0c2c90434042285ef18a2fff36182aae_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/dev/smarty/compile/v1_bookbloom_93layouts_layout_left_column_tpl/00/16/77/001677cb0c2c90434042285ef18a2fff36182aae_2.file.layout-both-columns.tpl.php:74 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68372f6838e869_72646199) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/v1_bookbloom_93layouts_layout_left_column_tpl/4d/db/63/4ddb6394ada23a7738f786704f24712786897bb0_2.file.layout-left-column.tpl.php:28 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68372f68371763_03768153) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/v1_bookbloom_93layouts_layout_left_column_tpl/fb/a6/9e/fba69e6f2df3dc7caa0566fb6dfb82b90cfeda03_2.file.product-list.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68372f683605b9_40838013) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/v1_bookbloom_93layouts_layout_left_column_tpl/45/43/a3/4543a363728a82e475bf989da0bf83752509fd5f_2.file.category.tpl.php:29 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68372f68342b23_59724056) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/Smarty/SmartyDev.php:40 (fetch) /classes/controller/FrontController.php:771 (fetch) /classes/controller/FrontController.php:753 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
398	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 `zp1h_cart_product` cp WHERE cp.`id_product_attribute` = 0 AND cp.`id_cart` = 0 AND cp.`id_product` = 537 UNION SELECT 0 as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity FROM `zp1h_cart_product` cp JOIN `zp1h_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `zp1h_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` = 537 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1	2.016 ms	0			/classes/Cart.php:1430 /classes/Product.php:4361 (getProductQuantity) /classes/Product.php:5802 (getQuantity) /classes/Product.php:5990 (getProductProperties) /classes/Product.php:3127 (getProductsProperties) /modules/tvcmsproductpopup/tvcmsproductpopup.php:368 (getNewProducts) /modules/tvcmsproductpopup/tvcmsproductpopup.php:253 (getNewProducts) /modules/tvcmsproductpopup/tvcmsproductpopup.php:547 (prevHook) /classes/Hook.php:1083 (hookdisplayAfterBodyOpeningTag) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:421 (coreCallHook) /classes/Hook.php:989 (callHookOn) /config/smarty.config.inc.php:201 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/dev/smarty/compile/v1_bookbloom_93layouts_layout_left_column_tpl/00/16/77/001677cb0c2c90434042285ef18a2fff36182aae_2.file.layout-both-columns.tpl.php:116 (__call) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/v1_bookbloom_93layouts_layout_left_column_tpl/00/16/77/001677cb0c2c90434042285ef18a2fff36182aae_2.file.layout-both-columns.tpl.php:54 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68372f6838e869_72646199) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/v1_bookbloom_93layouts_layout_left_column_tpl/4d/db/63/4ddb6394ada23a7738f786704f24712786897bb0_2.file.layout-left-column.tpl.php:28 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68372f68371763_03768153) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/v1_bookbloom_93layouts_layout_left_column_tpl/fb/a6/9e/fba69e6f2df3dc7caa0566fb6dfb82b90cfeda03_2.file.product-list.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68372f683605b9_40838013) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/v1_bookbloom_93layouts_layout_left_column_tpl/45/43/a3/4543a363728a82e475bf989da0bf83752509fd5f_2.file.category.tpl.php:29 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68372f68342b23_59724056) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/Smarty/SmartyDev.php:40 (fetch) /classes/controller/FrontController.php:771 (fetch) /classes/controller/FrontController.php:753 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
604	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 `zp1h_cart_product` cp WHERE cp.`id_product_attribute` = 0 AND cp.`id_cart` = 0 AND cp.`id_product` = 385 UNION SELECT 0 as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity FROM `zp1h_cart_product` cp JOIN `zp1h_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `zp1h_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` = 385 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1	2.013 ms	0			/classes/Cart.php:1430 /classes/Product.php:4361 (getProductQuantity) /classes/Product.php:5802 (getQuantity) /classes/Product.php:5990 (getProductProperties) /classes/ProductSale.php:161 (getProductsProperties) /src/Adapter/BestSales/BestSalesProductSearchProvider.php:74 (getBestSales) /modules/tvcmstabproducts/tvcmstabproducts.php:2879 (runQuery) /modules/tvcmsbestsellerproducts/tvcmsbestsellerproducts.php:156 (displayBestSellers) /modules/tvcmsbestsellerproducts/tvcmsbestsellerproducts.php:269 (showFrontSideResult) /classes/Hook.php:1083 (hookdisplayLeftColumn) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:421 (coreCallHook) /classes/Hook.php:989 (callHookOn) /config/smarty.config.inc.php:201 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/dev/smarty/compile/v1_bookbloom_93layouts_layout_left_column_tpl/00/16/77/001677cb0c2c90434042285ef18a2fff36182aae_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/dev/smarty/compile/v1_bookbloom_93layouts_layout_left_column_tpl/00/16/77/001677cb0c2c90434042285ef18a2fff36182aae_2.file.layout-both-columns.tpl.php:74 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68372f6838e869_72646199) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/v1_bookbloom_93layouts_layout_left_column_tpl/4d/db/63/4ddb6394ada23a7738f786704f24712786897bb0_2.file.layout-left-column.tpl.php:28 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68372f68371763_03768153) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/v1_bookbloom_93layouts_layout_left_column_tpl/fb/a6/9e/fba69e6f2df3dc7caa0566fb6dfb82b90cfeda03_2.file.product-list.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68372f683605b9_40838013) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/v1_bookbloom_93layouts_layout_left_column_tpl/45/43/a3/4543a363728a82e475bf989da0bf83752509fd5f_2.file.category.tpl.php:29 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68372f68342b23_59724056) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/Smarty/SmartyDev.php:40 (fetch) /classes/controller/FrontController.php:771 (fetch) /classes/controller/FrontController.php:753 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
610	SELECT SQL_NO_CACHE p., ps., pl.*, sa.out_of_stock, IFNULL(sa.quantity, 0) as quantity, (DATEDIFF( p.`date_add`, DATE_SUB( '2025-05-28 00:00:00', INTERVAL 1000 DAY ) ) > 0) as new FROM zp1h_product p LEFT JOIN zp1h_product_lang pl ON pl.id_product = p.id_product AND pl.id_shop = 1 AND pl.id_lang = 3 LEFT JOIN zp1h_stock_available sa ON sa.id_product = p.id_product AND sa.id_product_attribute = 0 AND sa.id_shop = 1 LEFT JOIN zp1h_product_shop ps ON ps.id_product = p.id_product AND ps.id_shop = 1 WHERE p.id_product IN (456)	2.004 ms	1			/classes/ProductAssembler.php:64 /classes/ProductAssembler.php:182 (addMissingProductFields) /modules/tvcmstabproducts/tvcmstabproducts.php:2912 (assembleProduct) /modules/tvcmsbestsellerproducts/tvcmsbestsellerproducts.php:156 (displayBestSellers) /modules/tvcmsbestsellerproducts/tvcmsbestsellerproducts.php:269 (showFrontSideResult) /classes/Hook.php:1083 (hookdisplayLeftColumn) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:421 (coreCallHook) /classes/Hook.php:989 (callHookOn) /config/smarty.config.inc.php:201 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/dev/smarty/compile/v1_bookbloom_93layouts_layout_left_column_tpl/00/16/77/001677cb0c2c90434042285ef18a2fff36182aae_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/dev/smarty/compile/v1_bookbloom_93layouts_layout_left_column_tpl/00/16/77/001677cb0c2c90434042285ef18a2fff36182aae_2.file.layout-both-columns.tpl.php:74 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68372f6838e869_72646199) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/v1_bookbloom_93layouts_layout_left_column_tpl/4d/db/63/4ddb6394ada23a7738f786704f24712786897bb0_2.file.layout-left-column.tpl.php:28 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68372f68371763_03768153) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/v1_bookbloom_93layouts_layout_left_column_tpl/fb/a6/9e/fba69e6f2df3dc7caa0566fb6dfb82b90cfeda03_2.file.product-list.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68372f683605b9_40838013) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/v1_bookbloom_93layouts_layout_left_column_tpl/45/43/a3/4543a363728a82e475bf989da0bf83752509fd5f_2.file.category.tpl.php:29 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68372f68342b23_59724056) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/Smarty/SmartyDev.php:40 (fetch) /classes/controller/FrontController.php:771 (fetch) /classes/controller/FrontController.php:753 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
213	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 `zp1h_cart_product` cp WHERE cp.`id_product_attribute` = 0 AND cp.`id_cart` = 0 AND cp.`id_product` = 490 UNION SELECT 0 as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity FROM `zp1h_cart_product` cp JOIN `zp1h_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `zp1h_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` = 490 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1	2.003 ms	0			/classes/Cart.php:1430 /classes/Product.php:4361 (getProductQuantity) /classes/Product.php:5802 (getQuantity) /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)

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

Jusqu'au dernier

Le prince des Maudits

Le jeu des étoiles filantes

Si j'étais un oiseau

Le chat Rivari

Shopping Cart

Balivernes at the ML25 book fair

Balivernes at Primevere fair

Update to our website

Doux rêves de moutons

Doux rêves de moutons

Doux rêves de moutons

Doux rêves de moutons

Écoute

Écoute

Écoute

Écoute

et toute la ville s'éveille

et toute la ville s'éveille

et toute la ville s'éveille

et toute la ville s'éveille

Gainsbourg

Gainsbourg

Gainsbourg

Gainsbourg

Galaxine et les anneaux de Saturne

Galaxine et les anneaux de Saturne

Galaxine et les anneaux de Saturne

Galaxine et les anneaux de Saturne

Galaxine et les cranards de Mars

Galaxine et les cranards de Mars

Galaxine et les cranards de Mars

Galaxine et les cranards de Mars

Gulliver : voyage à Lilliput

Gulliver : voyage à Lilliput

Gulliver : voyage à Lilliput

Gulliver : voyage à Lilliput

Hippopo Tam-tam

Hippopo Tam-tam

Hippopo Tam-tam

Hippopo Tam-tam

i minuscule

i minuscule

i minuscule

i minuscule

Imagier de la Maison

Imagier de la Maison

Imagier de la Maison

Imagier de la Maison

Imagier du Jardin

Imagier du Jardin

Imagier du Jardin

Imagier du Jardin

Iota la Vache

Iota la Vache

Iota la Vache

Iota la Vache

Stopwatch SQL - 987 queries

Doubles

Tables stress

ObjectModel instances

Included Files