collection farfadaises

mars

10,

2025

Salon Magnifique Livre 2025

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

Salon Primevère

Balivernes sera présent au salon Primevère 2025

Et encore une petite mise à jour de notre site

mars

10,

2025

Et encore une petite mise à jour de notre site

Nous avons encore une fois dû effectuer de nombreuses modifications sur notre site. Nous vous présentons nos excuses pour l'interruption dans sa ...

Tout les articles

Albums tout-carton pour les plus petits (mais pas que !)

Voir colonne gauche

1 produit

Grille

Grille-2

Liste

Liste-2

Catalogue

Trier par :

Add To Compare

Par : 22Pierre CrooksFrédéric LaurentMiguel de Cervantès

Don Quichotte décide de devenir chevalier. Mais... n'est-il pas devenu fou ? Un gentilhomme a lu tellement de livres de chevalerie qu’il en perd l’esprit. Il se nomme maintenant Don Quichotte et part à l’aventure avec un laboureur, Sancho Panza. Ils rencontreront des géants, à moins que ce ne soient des moulins à vent, et des armées en bataille, sauf si ce n’étaient que...

9,00 €

Vue rapide

Add To Compare

Don Quichotte

9,00 €

Vue rapide

Add To Compare

Load Time	727.043 ms
Querying Time	536 ms
Queries	587
Memory Peak Usage	18.8 Mb
Included Files	994 files - 11.42 Mb
PrestaShop Cache	- Mb
Global vars	0.48 Mb
- global $_MODULES	296k
- global $_MODULE	168k
- global $_SERVER	6k
- global $_ENV	6k
- global $config	5k
- global $context	4k
- global $exportPhpConfigFile	4k
- 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	16.817 ms	16.817 ms	3.00 Mb	3.6 Mb
__construct	0.011 ms	16.828 ms	- Mb	3.6 Mb
init	59.479 ms	76.307 ms	0.66 Mb	4.0 Mb
checkAccess	0.002 ms	76.309 ms	- Mb	4.0 Mb
setMedia	8.414 ms	84.723 ms	0.14 Mb	4.0 Mb
postProcess	0.001 ms	84.724 ms	- Mb	4.0 Mb
initHeader	0.001 ms	84.725 ms	- Mb	4.0 Mb
initContent	207.396 ms	292.121 ms	2.45 Mb	6.4 Mb
initFooter	0.003 ms	292.124 ms	- Mb	6.4 Mb
display	434.919 ms	727.043 ms	12.30 Mb	18.8 Mb

Hook	Time	Memory Usage
DisplayLeftColumn	209.532 ms	5.63 Mb
=> tvcmscustomerservices	1.303 ms	0.01 Mb
=> tvcmsspecialproducts	4.908 ms	0.08 Mb
=> tvcmsfeaturedproducts	10.505 ms	0.11 Mb
=> tvcmstestimonial	3.960 ms	0.04 Mb
=> tvcmsbestsellerproducts	81.304 ms	1.89 Mb
=> tvcmsblogdisplayposts	107.551 ms	3.50 Mb
DisplayAfterBodyOpeningTag	78.297 ms	2.57 Mb
=> blockreassurance	0.004 ms	- Mb
=> tvcmsproductpopup	78.293 ms	2.57 Mb
displayLeftColumn	30.648 ms	0.28 Mb
=> ps_categorytree (widget)	12.527 ms	0.18 Mb
=> ps_brandlist (widget)	14.415 ms	0.05 Mb
=> ps_supplierlist (widget)	3.706 ms	0.05 Mb
displayNavCurrencyBlock	16.125 ms	0.95 Mb
=> ps_currencyselector (widget)	16.125 ms	0.95 Mb
DisplayHeader	15.907 ms	0.09 Mb
=> ps_shoppingcart	0.197 ms	- Mb
=> ps_searchbar	1.576 ms	- Mb
=> tvcmsbestsellerproducts	0.349 ms	- Mb
=> tvcmsblog	0.389 ms	- Mb
=> tvcmsblogdisplayposts	0.522 ms	- Mb
=> tvcmsbrandlist	0.498 ms	- Mb
=> tvcmscategorybanner	0.485 ms	- Mb
=> tvcmscategorychainslider	0.509 ms	- Mb
=> tvcmscustomerservices	0.485 ms	- Mb
=> tvcmscustomsetting	1.358 ms	0.01 Mb
=> tvcmsfeaturedproducts	0.328 ms	- Mb
=> tvcmsfooterlogo	0.001 ms	- Mb
=> tvcmsfooterproduct	0.341 ms	- Mb
=> tvcmsmultibanner1	0.497 ms	- Mb
=> tvcmsnewsletterpopup	0.689 ms	- Mb
=> tvcmspaymenticon	0.001 ms	- Mb
=> tvcmsproductcomments	0.580 ms	- Mb
=> tvcmsproductcompare	0.498 ms	- Mb
=> tvcmsproductpopup	0.481 ms	- Mb
=> tvcmssearch	0.576 ms	- Mb
=> tvcmsslider	0.534 ms	- Mb
=> tvcmsspecialproducts	0.330 ms	- Mb
=> tvcmstabproducts	0.552 ms	- Mb
=> tvcmstestimonial	0.487 ms	- Mb
=> tvcmsthemeoptions	0.600 ms	- Mb
=> tvcmswishlist	0.524 ms	- Mb
=> prettyurls	2.520 ms	0.03 Mb
Header	14.447 ms	0.08 Mb
=> tvcmsstockinfo	0.390 ms	- Mb
=> tvcmsinfinitescroll	12.977 ms	0.08 Mb
=> tvcmscategoryproduct	0.561 ms	- Mb
=> tvcmsmegamenu	0.519 ms	- Mb
DisplayReviewProductList	8.769 ms	0.33 Mb
=> tvcmsproductcomments	4.939 ms	0.12 Mb
=> tvcmsproductcomments	1.273 ms	0.07 Mb
=> tvcmsproductcomments	1.205 ms	0.07 Mb
=> tvcmsproductcomments	1.352 ms	0.07 Mb
DisplayMegamenu	8.497 ms	0.39 Mb
=> tvcmsmegamenu	8.497 ms	0.39 Mb
DisplayFooterCategory	8.436 ms	0.39 Mb
=> tvcmsfootercategory	8.436 ms	0.39 Mb
displayNavShoppingCartBlock	7.141 ms	0.09 Mb
=> ps_shoppingcart (widget)	7.141 ms	0.09 Mb
displayNavLanguageBlock	6.198 ms	0.40 Mb
=> ps_languageselector (widget)	6.198 ms	0.40 Mb
ProductSearchProvider	2.680 ms	- Mb
=> ps_facetedsearch	2.680 ms	- Mb
displayFooterPart1	2.526 ms	0.07 Mb
=> ps_linklist (widget)	2.526 ms	0.07 Mb
displayMyaccountcblock	2.349 ms	0.06 Mb
=> ps_customeraccountlinks (widget)	2.349 ms	0.06 Mb
displaySocialMediaBlock	2.226 ms	0.08 Mb
=> ps_socialfollow (widget)	2.226 ms	0.08 Mb
displayNav1	2.057 ms	0.09 Mb
=> ps_contactinfo (widget)	2.057 ms	0.09 Mb
ActionFrontControllerSetMedia	1.814 ms	0.01 Mb
=> blockreassurance	1.001 ms	- Mb
=> ps_emailalerts	0.328 ms	- Mb
=> ps_socialfollow	0.485 ms	- Mb
DisplayNavSearchBlock	1.760 ms	0.09 Mb
=> tvcmssearch	1.760 ms	0.09 Mb
DisplayCustomsocialblock	1.760 ms	0.11 Mb
=> tvcmscustomsetting	1.760 ms	0.11 Mb
DisplayAfterTitleTag	1.515 ms	- Mb
=> lgcookieslaw	1.515 ms	- Mb
displayNavCustomerSignInBlock	1.330 ms	0.05 Mb
=> ps_customersignin (widget)	1.330 ms	0.05 Mb
DisplayWishlistBtnProductList	1.330 ms	0.02 Mb
=> tvcmswishlist	0.923 ms	0.01 Mb
=> tvcmswishlist	0.166 ms	- Mb
=> tvcmswishlist	0.129 ms	- Mb
=> tvcmswishlist	0.112 ms	- Mb
DisplayProductCompareProductList	1.255 ms	0.01 Mb
=> tvcmsproductcompare	0.916 ms	0.01 Mb
=> tvcmsproductcompare	0.137 ms	- Mb
=> tvcmsproductcompare	0.105 ms	- Mb
=> tvcmsproductcompare	0.097 ms	- Mb
displayContactCinfo	1.115 ms	0.03 Mb
=> ps_contactinfo (widget)	1.115 ms	0.03 Mb
DisplayPaymentIcon	1.080 ms	0.04 Mb
=> tvcmspaymenticon	1.080 ms	0.04 Mb
DisplayNavWishlistBlock	0.968 ms	0.04 Mb
=> tvcmswishlist	0.968 ms	0.04 Mb
DisplayFacetedSearchBlock	0.932 ms	- Mb
=> ps_facetedsearch	0.932 ms	- Mb
DisplayFooterPart2	0.156 ms	0.02 Mb
=> tvcmsfooterlogo	0.156 ms	0.02 Mb
DisplayNavProductCompareBlock	0.136 ms	0.01 Mb
=> tvcmsproductcompare	0.136 ms	0.01 Mb
DisplayCopyRightText	0.117 ms	0.01 Mb
=> tvcmscustomsetting	0.117 ms	0.01 Mb
DisplayFooter	0.039 ms	- Mb
=> lgcookieslaw	0.039 ms	- Mb
DisplayTopOfferText	0.023 ms	- Mb
=> tvcmscustomsetting	0.019 ms	- Mb
=> tvcmscustomsetting	0.004 ms	- Mb
ModuleRoutes	0.023 ms	0.01 Mb
=> tvcmsblog	0.015 ms	0.01 Mb
=> tvcmsblog	0.008 ms	0.01 Mb
DisplayDownloadApps	0.010 ms	- Mb
=> tvcmscustomsetting	0.010 ms	- Mb
DisplayProductListStockIndicator	0.008 ms	- Mb
=> tvcmsstockinfo	0.005 ms	- Mb
=> tvcmsstockinfo	0.003 ms	- Mb
DisplayCustomCss	0.006 ms	- Mb
=> tvcmscustomcssjs	0.006 ms	- Mb
DisplayCustomJs	0.005 ms	- Mb
=> tvcmscustomcssjs	0.005 ms	- Mb
DisplayNavFullWidth	0.004 ms	- Mb
=> blockreassurance	0.004 ms	- Mb
DisplayBeforeBodyClosingTag	0.002 ms	- Mb
=> tvcmsblog	0.002 ms	- Mb
39 hook(s)	431.222 ms	11.96 Mb

Module	Time	Memory Usage
tvcmsblog	12.509 ms	0.13 Mb
__construct	12.090 ms	0.12 Mb
hookModuleRoutes	0.017 ms	0.01 Mb
hookModuleRoutes	0.009 ms	0.01 Mb
hookDisplayHeader	0.389 ms	- Mb
hookDisplayBeforeBodyClosingTag	0.004 ms	- Mb
blockreassurance	3.295 ms	0.11 Mb
__construct	2.281 ms	0.11 Mb
hookActionFrontControllerSetMedia	1.003 ms	0.01 Mb
hookDisplayAfterBodyOpeningTag	0.006 ms	- Mb
hookDisplayNavFullWidth	0.005 ms	- Mb
ps_emailalerts	0.737 ms	0.01 Mb
__construct	0.408 ms	0.01 Mb
hookActionFrontControllerSetMedia	0.329 ms	- Mb
ps_socialfollow	2.917 ms	0.09 Mb
__construct	0.204 ms	0.01 Mb
hookActionFrontControllerSetMedia	0.485 ms	- Mb
displaySocialMediaBlock	2.228 ms	0.08 Mb
ps_shoppingcart	7.582 ms	0.10 Mb
__construct	0.242 ms	0.01 Mb
hookDisplayHeader	0.198 ms	- Mb
displayNavShoppingCartBlock	7.142 ms	0.09 Mb
ps_searchbar	1.808 ms	0.01 Mb
__construct	0.230 ms	0.01 Mb
hookDisplayHeader	1.578 ms	- Mb
tvcmsbestsellerproducts	83.033 ms	1.90 Mb
__construct	1.375 ms	0.01 Mb
hookDisplayHeader	0.350 ms	- Mb
hookDisplayLeftColumn	81.308 ms	1.89 Mb
tvcmsblogdisplayposts	109.122 ms	3.51 Mb
__construct	1.044 ms	0.01 Mb
hookDisplayHeader	0.523 ms	- Mb
hookDisplayLeftColumn	107.555 ms	3.50 Mb
tvcmsbrandlist	1.625 ms	0.01 Mb
__construct	1.125 ms	0.01 Mb
hookDisplayHeader	0.500 ms	- Mb
tvcmscategorybanner	1.607 ms	0.01 Mb
__construct	1.121 ms	0.01 Mb
hookDisplayHeader	0.486 ms	- Mb
tvcmscategorychainslider	1.554 ms	0.01 Mb
__construct	1.044 ms	0.01 Mb
hookDisplayHeader	0.510 ms	- Mb
tvcmscustomerservices	2.840 ms	0.02 Mb
__construct	1.049 ms	0.01 Mb
hookDisplayHeader	0.487 ms	- Mb
hookDisplayLeftColumn	1.304 ms	0.01 Mb
tvcmscustomsetting	4.739 ms	0.15 Mb
__construct	1.463 ms	0.01 Mb
hookDisplayHeader	1.360 ms	0.01 Mb
hookDisplayTopOfferText	0.021 ms	- Mb
hookDisplayTopOfferText	0.006 ms	- Mb
hookDisplayDownloadApps	0.010 ms	- Mb
hookDisplayCustomsocialblock	1.761 ms	0.11 Mb
hookDisplayCopyRightText	0.118 ms	0.02 Mb
tvcmsfeaturedproducts	11.415 ms	0.12 Mb
__construct	0.579 ms	0.01 Mb
hookDisplayHeader	0.329 ms	- Mb
hookDisplayLeftColumn	10.507 ms	0.11 Mb
tvcmsfooterlogo	1.248 ms	0.02 Mb
__construct	1.088 ms	0.01 Mb
hookDisplayHeader	0.002 ms	- Mb
hookDisplayFooterPart2	0.158 ms	0.02 Mb
tvcmsfooterproduct	1.220 ms	0.01 Mb
__construct	0.878 ms	0.01 Mb
hookDisplayHeader	0.342 ms	- Mb
tvcmsmultibanner1	1.583 ms	0.01 Mb
__construct	1.085 ms	0.01 Mb
hookDisplayHeader	0.498 ms	- Mb
tvcmsnewsletterpopup	1.756 ms	0.01 Mb
__construct	1.066 ms	0.01 Mb
hookDisplayHeader	0.690 ms	- Mb
tvcmspaymenticon	2.145 ms	0.05 Mb
__construct	1.061 ms	0.01 Mb
hookDisplayHeader	0.002 ms	- Mb
hookDisplayPaymentIcon	1.082 ms	0.05 Mb
tvcmsproductcomments	10.246 ms	0.36 Mb
__construct	0.890 ms	0.02 Mb
hookDisplayHeader	0.581 ms	0.01 Mb
hookDisplayReviewProductList	4.941 ms	0.12 Mb
hookDisplayReviewProductList	1.274 ms	0.07 Mb
hookDisplayReviewProductList	1.207 ms	0.07 Mb
hookDisplayReviewProductList	1.353 ms	0.07 Mb
tvcmsproductcompare	2.517 ms	0.02 Mb
__construct	0.620 ms	- Mb
hookDisplayHeader	0.499 ms	- Mb
hookDisplayNavProductCompareBlock	0.137 ms	0.01 Mb
hookDisplayProductCompareProductList	0.918 ms	0.01 Mb
hookDisplayProductCompareProductList	0.139 ms	- Mb
hookDisplayProductCompareProductList	0.106 ms	- Mb
hookDisplayProductCompareProductList	0.098 ms	- Mb
tvcmsproductpopup	78.994 ms	2.57 Mb
__construct	0.216 ms	0.01 Mb
hookDisplayHeader	0.482 ms	- Mb
hookDisplayAfterBodyOpeningTag	78.296 ms	2.57 Mb
tvcmssearch	2.882 ms	0.10 Mb
__construct	0.544 ms	0.01 Mb
hookDisplayHeader	0.576 ms	- Mb
hookDisplayNavSearchBlock	1.762 ms	0.09 Mb
tvcmsslider	2.059 ms	0.07 Mb
__construct	1.524 ms	0.07 Mb
hookDisplayHeader	0.535 ms	- Mb
tvcmsspecialproducts	5.795 ms	0.09 Mb
__construct	0.554 ms	0.01 Mb
hookDisplayHeader	0.331 ms	- Mb
hookDisplayLeftColumn	4.910 ms	0.08 Mb
tvcmsstockinfo	1.138 ms	0.01 Mb
__construct	0.737 ms	0.01 Mb
hookHeader	0.391 ms	- Mb
hookDisplayProductListStockIndicator	0.006 ms	- Mb
hookDisplayProductListStockIndicator	0.004 ms	- Mb
tvcmstabproducts	0.946 ms	0.01 Mb
__construct	0.393 ms	0.01 Mb
hookDisplayHeader	0.553 ms	- Mb
tvcmstestimonial	5.639 ms	0.05 Mb
__construct	1.189 ms	0.01 Mb
hookDisplayHeader	0.488 ms	- Mb
hookDisplayLeftColumn	3.962 ms	0.04 Mb
tvcmsthemeoptions	1.171 ms	0.01 Mb
__construct	0.559 ms	0.01 Mb
hookDisplayHeader	0.612 ms	- Mb
tvcmswishlist	3.558 ms	0.10 Mb
__construct	0.728 ms	0.03 Mb
hookDisplayHeader	0.525 ms	- Mb
hookDisplayNavWishlistBlock	0.969 ms	0.04 Mb
hookDisplayWishlistBtnProductList	0.925 ms	0.01 Mb
hookDisplayWishlistBtnProductList	0.168 ms	- Mb
hookDisplayWishlistBtnProductList	0.130 ms	- Mb
hookDisplayWishlistBtnProductList	0.113 ms	- Mb
prettyurls	3.896 ms	0.03 Mb
__construct	1.374 ms	- Mb
hookDisplayHeader	2.522 ms	0.03 Mb
tvcmsinfinitescroll	13.636 ms	0.08 Mb
__construct	0.656 ms	0.01 Mb
hookHeader	12.980 ms	0.08 Mb
tvcmscategoryproduct	1.711 ms	0.01 Mb
__construct	1.148 ms	0.01 Mb
hookHeader	0.563 ms	- Mb
tvcmsmegamenu	10.726 ms	0.40 Mb
__construct	1.707 ms	0.01 Mb
hookHeader	0.520 ms	- Mb
hookDisplayMegamenu	8.499 ms	0.39 Mb
ps_facetedsearch	7.647 ms	0.02 Mb
__construct	4.032 ms	0.01 Mb
hookProductSearchProvider	2.682 ms	- Mb
hookDisplayFacetedSearchBlock	0.933 ms	- Mb
lgcookieslaw	3.062 ms	0.11 Mb
__construct	1.504 ms	0.10 Mb
hookDisplayAfterTitleTag	1.518 ms	0.01 Mb
hookDisplayFooter	0.040 ms	- Mb
tvcmscustomcssjs	0.390 ms	0.01 Mb
__construct	0.376 ms	0.01 Mb
hookDisplayCustomCss	0.008 ms	- Mb
hookDisplayCustomJs	0.006 ms	- Mb
ps_customersignin	1.405 ms	0.06 Mb
__construct	0.073 ms	0.01 Mb
displayNavCustomerSignInBlock	1.332 ms	0.05 Mb
ps_languageselector	6.261 ms	0.41 Mb
__construct	0.062 ms	0.01 Mb
displayNavLanguageBlock	6.199 ms	0.40 Mb
ps_currencyselector	16.204 ms	0.96 Mb
__construct	0.077 ms	0.01 Mb
displayNavCurrencyBlock	16.127 ms	0.95 Mb
ps_contactinfo	3.247 ms	0.12 Mb
__construct	0.071 ms	0.01 Mb
displayNav1	2.059 ms	0.09 Mb
displayContactCinfo	1.117 ms	0.03 Mb
ps_categorytree	12.777 ms	0.19 Mb
__construct	0.248 ms	0.01 Mb
displayLeftColumn	12.529 ms	0.18 Mb
ps_brandlist	14.743 ms	0.06 Mb
__construct	0.325 ms	0.01 Mb
displayLeftColumn	14.418 ms	0.05 Mb
ps_supplierlist	3.974 ms	0.06 Mb
__construct	0.267 ms	0.01 Mb
displayLeftColumn	3.707 ms	0.05 Mb
tvcmsfootercategory	8.834 ms	0.40 Mb
__construct	0.396 ms	0.01 Mb
hookDisplayFooterCategory	8.438 ms	0.39 Mb
ps_linklist	3.107 ms	0.08 Mb
__construct	0.579 ms	0.01 Mb
displayFooterPart1	2.528 ms	0.08 Mb
ps_customeraccountlinks	2.414 ms	0.07 Mb
__construct	0.063 ms	0.01 Mb
displayMyaccountcblock	2.351 ms	0.06 Mb
47 module(s)	481.715 ms	12.72 Mb

Salon Magnifique Livre 2025

Salon Primevère

Et encore une petite mise à jour de notre site

Don Quichotte

Don Quichotte

Don Quichotte

Don Quichotte

Stopwatch SQL - 587 queries

Doubles

Tables stress

ObjectModel instances

Included Files

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
55 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
21 queries	SELECT `id_module` FROM `zpXXh_module_shop` WHERE `id_module` = XX AND `id_shop` = XX LIMIT XX
11 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
10 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)
10 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
10 queries	SELECT name FROM zpXXh_category_lang WHERE id_shop = XX AND id_lang = XX AND id_category = XX LIMIT XX
10 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
10 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)
10 queries	SELECT `id_tax_rules_group` FROM `zpXXh_product_shop` WHERE `id_product` = XX AND id_shop=XX LIMIT XX
10 queries	SELECT `reduction` FROM `zpXXh_product_group_reduction_cache` WHERE `id_product` = XX AND `id_group` = XX LIMIT XX
10 queries	SELECT COUNT(*) FROM `zpXXh_pack` WHERE id_product_pack = XX LIMIT XX
10 queries	SELECT product_type FROM `zpXXh_product` WHERE id_product = XX LIMIT XX
10 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
10 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
10 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`
10 queries	SELECT `id_product_attribute` FROM `zpXXh_product_attribute` WHERE `id_product` = XX
8 queries	SELECT `id_lang` FROM `zpXXh_lang` WHERE `locale` = 'fr-fr' OR `language_code` = 'fr-fr' 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 = "farfadaises" AND id_lang = XX AND id_shop = XX LIMIT XX
6 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
5 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
5 queries	SELECT * FROM `zpXXh_category_lang` WHERE `id_category` = XX AND `id_shop` = XX
5 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
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 cl.`link_rewrite` FROM `zpXXh_category_lang` cl WHERE `id_lang` = XX AND cl.id_shop = XX AND cl.`id_category` = XX LIMIT XX
4 queries	SELECT c.`nleft`, c.`nright`, c.`level_depth` FROM `zpXXh_category` c WHERE (c.`id_category` = XX) LIMIT 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
4 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
4 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
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 id_shop FROM `zpXXh_employee_shop` WHERE `id_employee` = 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 = "farfadaises" 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 * FROM `zpXXh_tvcms_image_type` WHERE active = XX AND id_shop = XX

Name	Instances	Source
Category	86	/controllers/front/listing/CategoryController.php:78 (__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] /classes/Meta.php:380 (__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: 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] /classes/PrestaShopCollection.php:385 (hydrateCollection) [id: ] /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] /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: 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] /modules/ps_facetedsearch/src/Product/Search.php:364 (__construct) [id: 5] /modules/tvcmssearch/tvcmssearch.php:100 (getNestedCategories) [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: 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: 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] /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: 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] /modules/tvcmstabproducts/tvcmstabproducts.php:2683 (__construct) [id: 2] /override/classes/Link.php:35 (__construct) [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	21	/classes/Link.php:113 (__construct) [id: 477] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 477] /classes/Link.php:113 (__construct) [id: 477] /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]
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]
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] /override/classes/Dispatcher.php:1352 (__construct) [id: 1] /classes/Tools.php:560 (__construct) [id: 1]
AddressFormat	3	/classes/controller/FrontController.php:1773 (generateAddress) [id: ] /modules/ps_contactinfo/ps_contactinfo.php:91 (generateAddress) [id: ] /modules/ps_contactinfo/ps_contactinfo.php:91 (generateAddress) [id: ]
Cart	2	/classes/controller/FrontController.php:467 (__construct) [id: ] /classes/controller/FrontController.php:541 (__construct) [id: ]
Tax	2	/classes/tax/TaxRulesTaxManager.php:116 (__construct) [id: 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]
Risk	1	/classes/controller/FrontController.php:1705 (__construct) [id: ]
Group	1	/classes/Cart.php:249 (getCurrent) [id: 1]
Customer	1	/config/config.inc.php:264 (__construct) [id: ]
ShopGroup	1	/classes/shop/Shop.php:561 (__construct) [id: 1]
Gender	1	/classes/controller/FrontController.php:1702 (__construct) [id: 0]

#	Query	Time (ms)	Rows	Filesort	Group By	Location
118	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 = 1) 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) LEFT JOIN zp1h_feature_product fp ON (p.id_product = fp.id_product) WHERE ((fp.id_feature_value=160)) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=4 AND c.nright<=5 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 = 1) GROUP BY p.id_product ORDER BY p.name ASC, p.id_product DESC	16.989 ms	8	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)
314	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-30 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` = 1 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` = 1) 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	13.189 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)
14	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`	9.029 ms	1968	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)
113	SELECT SQL_NO_CACHE ag.id_attribute_group, agl.public_name as attribute_group_name, is_color_group, IF(liaglv.`url_name` IS NULL OR liaglv.`url_name` = "", NULL, liaglv.`url_name`) AS url_name, IF(liaglv.`meta_title` IS NULL OR liaglv.`meta_title` = "", NULL, liaglv.`meta_title`) AS meta_title, IFNULL(liag.indexable, TRUE) AS indexable FROM `zp1h_attribute_group` ag INNER JOIN zp1h_attribute_group_shop attribute_group_shop ON (attribute_group_shop.id_attribute_group = ag.id_attribute_group AND attribute_group_shop.id_shop = 1) LEFT JOIN `zp1h_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1) LEFT JOIN `zp1h_layered_indexable_attribute_group` liag ON (ag.`id_attribute_group` = liag.`id_attribute_group`) LEFT JOIN `zp1h_layered_indexable_attribute_group_lang_value` AS liaglv ON (ag.`id_attribute_group` = liaglv.`id_attribute_group` AND agl.`id_lang` = 1) GROUP BY ag.id_attribute_group ORDER BY ag.`position` ASC	8.200 ms	5	Yes	Yes	/modules/ps_facetedsearch/src/Filters/DataAccessor.php:137 /modules/ps_facetedsearch/src/Filters/Converter.php:413 (getAttributesGroups) /modules/ps_facetedsearch/src/Product/SearchProvider.php:163 (createFacetedSearchFiltersFromQuery) /classes/controller/ProductListingFrontController.php:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
130	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	8.113 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)
380	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` = 1) INNER JOIN `zp1h_tvcmscategory_shop` xcs ON (xcp.`id_category` = xcs.`id_tvcmscategory` AND xcs.`id_shop` = 1) WHERE xcp.`id_post` = 2 AND xcp.`type` = "tag"	7.471 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)
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`)	7.300 ms	3156			/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)
115	SELECT SQL_NO_CACHE v., vl., IF(lifvlv.`url_name` IS NULL OR lifvlv.`url_name` = "", NULL, lifvlv.`url_name`) AS url_name, IF(lifvlv.`meta_title` IS NULL OR lifvlv.`meta_title` = "", NULL, lifvlv.`meta_title`) AS meta_title FROM `zp1h_feature_value` v LEFT JOIN `zp1h_feature_value_lang` vl ON (v.`id_feature_value` = vl.`id_feature_value` AND vl.`id_lang` = 1) LEFT JOIN `zp1h_layered_indexable_feature_value_lang_value` lifvlv ON (v.`id_feature_value` = lifvlv.`id_feature_value` AND lifvlv.`id_lang` = 1) WHERE v.`id_feature` = 6 ORDER BY vl.`value` ASC	6.886 ms	7	Yes		/modules/ps_facetedsearch/src/Filters/DataAccessor.php:204 /modules/ps_facetedsearch/src/Filters/Converter.php:402 (getFeatureValues) /modules/ps_facetedsearch/src/Product/SearchProvider.php:163 (createFacetedSearchFiltersFromQuery) /classes/controller/ProductListingFrontController.php:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
114	SELECT SQL_NO_CACHE DISTINCT f.id_feature, f., fl., IF(liflv.`url_name` IS NULL OR liflv.`url_name` = "", NULL, liflv.`url_name`) AS url_name, IF(liflv.`meta_title` IS NULL OR liflv.`meta_title` = "", NULL, liflv.`meta_title`) AS meta_title, lif.indexable FROM `zp1h_feature` f INNER JOIN zp1h_feature_shop feature_shop ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1) LEFT JOIN `zp1h_feature_lang` fl ON (f.`id_feature` = fl.`id_feature` AND fl.`id_lang` = 1) LEFT JOIN `zp1h_layered_indexable_feature` lif ON (f.`id_feature` = lif.`id_feature`) LEFT JOIN `zp1h_layered_indexable_feature_lang_value` liflv ON (f.`id_feature` = liflv.`id_feature` AND liflv.`id_lang` = 1) ORDER BY f.`position` ASC	6.299 ms	6	Yes		/modules/ps_facetedsearch/src/Filters/DataAccessor.php:171 /modules/ps_facetedsearch/src/Filters/Converter.php:388 (getFeatures) /modules/ps_facetedsearch/src/Product/SearchProvider.php:163 (createFacetedSearchFiltersFromQuery) /classes/controller/ProductListingFrontController.php:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
280	SELECT SQL_NO_CACHE `id_module` FROM `zp1h_module_shop` WHERE `id_module` = 32 AND `id_shop` = 1 LIMIT 1	5.201 ms	1			/classes/module/Module.php:2137 /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:44 (__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)
19	SELECT SQL_NO_CACHE m.page, ml.url_rewrite, ml.id_lang FROM `zp1h_meta` m LEFT JOIN `zp1h_meta_lang` ml ON (m.id_meta = ml.id_meta AND ml.id_shop = 1 ) ORDER BY LENGTH(ml.url_rewrite) DESC	4.628 ms	120	Yes		/override/classes/Dispatcher.php:216 /classes/Dispatcher.php:243 (loadRoutes) /override/classes/Dispatcher.php:30 (__construct) /classes/Dispatcher.php:201 (__construct) /index.php:28 (getInstance)
5	SELECT SQL_NO_CACHE l.*, ls.`id_shop` FROM `zp1h_lang` l LEFT JOIN `zp1h_lang_shop` ls ON (l.id_lang = ls.id_lang)	3.990 ms	2			/classes/Language.php:1080 /config/config.inc.php:143 (loadLanguages) /index.php:27 (require)
299	SELECT SQL_NO_CACHE c., cl. 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 cl.id_shop = 1 LEFT JOIN `zp1h_category_group` cg ON c.`id_category` = cg.`id_category` RIGHT JOIN `zp1h_category` c2 ON c2.`id_category` = 5 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright` WHERE 1 AND c.`level_depth` <= 4 AND `id_lang` = 1 AND c.`active` = 1 AND cg.`id_group` IN (1) GROUP BY c.`id_category` ORDER BY c.`level_depth` ASC, cl.`name` ASC	3.900 ms	1	Yes	Yes	/classes/Category.php:799 /modules/ps_categorytree/ps_categorytree.php:141 (getNestedCategories) /modules/ps_categorytree/ps_categorytree.php:298 (getCategories) /modules/ps_categorytree/ps_categorytree.php:266 (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/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)
150	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-30 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` = 1 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` = 1 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-30 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	3.794 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)
6	SELECT SQL_NO_CACHE * FROM `zp1h_country` a LEFT JOIN `zp1h_country_lang` `b` ON a.`id_country` = b.`id_country` AND b.`id_lang` = 1 LEFT JOIN `zp1h_country_shop` `c` ON a.`id_country` = c.`id_country` AND c.`id_shop` = 1 WHERE (a.`id_country` = 8) LIMIT 1	3.544 ms	1			/src/Adapter/EntityMapper.php:71 /classes/ObjectModel.php:283 (load) /tools/profiling/ObjectModel.php:32 (__construct) /config/config.inc.php:146 (__construct) /index.php:27 (require)
33	SELECT SQL_NO_CACHE * FROM `zp1h_category` a LEFT JOIN `zp1h_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1 LEFT JOIN `zp1h_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1 WHERE (a.`id_category` = 5) AND (b.`id_shop` = 1) LIMIT 1	3.467 ms	1			/src/Adapter/EntityMapper.php:71 /classes/ObjectModel.php:283 (load) /tools/profiling/ObjectModel.php:32 (__construct) /classes/Category.php:164 (__construct) /override/classes/Category.php:18 (__construct) /controllers/front/listing/CategoryController.php:78 (__construct) /override/controllers/front/CategoryController.php:57 (init) /tools/profiling/Controller.php:41 (init) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
306	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-30 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` = 1 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` = 1) 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`)	3.416 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)
218	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-30 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 = 1 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 (537)	3.395 ms	1			/classes/ProductAssembler.php:64 /classes/ProductAssembler.php:182 (addMissingProductFields) /modules/tvcmsproductpopup/tvcmsproductpopup.php:391 (assembleProduct) /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)
310	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-30 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` = 1 AND cl.id_shop = 1 ) LEFT JOIN `zp1h_product_lang` pl ON (p.`id_product` = pl.`id_product` AND pl.`id_lang` = 1 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` = 1) 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	3.345 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)
38	SELECT SQL_NO_CACHE * FROM `zp1h_currency` a LEFT JOIN `zp1h_currency_lang` `b` ON a.`id_currency` = b.`id_currency` AND b.`id_lang` = 1 LEFT JOIN `zp1h_currency_shop` `c` ON a.`id_currency` = c.`id_currency` AND c.`id_shop` = 1 WHERE (a.`id_currency` = 4) LIMIT 1	3.265 ms	1			/src/Adapter/EntityMapper.php:71 /classes/ObjectModel.php:283 (load) /tools/profiling/ObjectModel.php:32 (__construct) /classes/Currency.php:246 (__construct) /src/Adapter/Currency/CurrencyDataProvider.php:101 (__construct) /src/Adapter/Currency/CurrencyDataProvider.php:114 (getCurrencyByIsoCode) /src/Core/Localization/Currency/DataLayer/CurrencyDatabase.php:102 (getCurrencyByIsoCodeAndLocale) /src/Core/Data/Layer/AbstractDataLayer.php:91 (doRead) /src/Core/Data/Layer/AbstractDataLayer.php:150 (read) /src/Core/Data/Layer/AbstractDataLayer.php:95 (propagateRead) /src/Core/Localization/Currency/CurrencyDataSource.php:67 (read) /src/Core/Localization/Currency/CurrencyDataSource.php:109 (getLocalizedCurrencyData) /src/Core/Localization/Currency/CurrencyDataSource.php:96 (formatCurrenciesData) /src/Core/Localization/Currency/Repository.php:87 (getAllInstalledCurrenciesData) /src/Core/Localization/Locale/Repository.php:207 (getAllInstalledCurrencies) /src/Core/Localization/Locale/Repository.php:150 (getPriceSpecifications) /classes/controller/Controller.php:209 (getLocale) /classes/controller/FrontController.php:284 (init) /controllers/front/listing/CategoryController.php:81 (init) /override/controllers/front/CategoryController.php:57 (init) /tools/profiling/Controller.php:41 (init) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
55	SELECT SQL_NO_CACHE * FROM `zp1h_group` a LEFT JOIN `zp1h_group_shop` `c` ON a.`id_group` = c.`id_group` AND c.`id_shop` = 1 WHERE (a.`id_group` = 1) LIMIT 1	3.153 ms	1			/src/Adapter/EntityMapper.php:71 /classes/ObjectModel.php:283 (load) /tools/profiling/ObjectModel.php:32 (__construct) /classes/Group.php:81 (__construct) /classes/Group.php:397 (__construct) /classes/Cart.php:249 (getCurrent) /classes/Cart.php:222 (setTaxCalculationMethod) /classes/controller/FrontController.php:467 (__construct) /controllers/front/listing/CategoryController.php:81 (init) /override/controllers/front/CategoryController.php:57 (init) /tools/profiling/Controller.php:41 (init) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
13	SELECT SQL_NO_CACHE lower(name) as name FROM `zp1h_hook` h WHERE (h.active = 1)	2.852 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)
313	SELECT SQL_NO_CACHE mainTable.id_tvcmstestimonial AS code, mainTable.image, mainTable.signature_image, mainTable.signature_text, mainTable.link, subTable.title, subTable.designation, subTable.short_description, subTable.description FROM `zp1h_tvcmstestimonial` mainTable LEFT JOIN zp1h_tvcmstestimonial_lang subTable ON mainTable.id_tvcmstestimonial = subTable.id_tvcmstestimonial WHERE mainTable.id_shop_group = 1 AND mainTable.id_shop = 1 AND mainTable.status = 1 AND subTable.id_lang = 1 ORDER BY `position`	2.818 ms	6	Yes		/modules/tvcmstestimonial/tvcmstestimonial.php:532 /modules/tvcmstestimonial/tvcmstestimonial.php:1227 (showFrontData) /modules/tvcmstestimonial/tvcmstestimonial.php:1247 (showFrontSideResult) /classes/Hook.php:1083 (hookdisplayLeftColumn) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:421 (coreCallHook) /classes/Hook.php:989 (callHookOn) /config/smarty.config.inc.php:201 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/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)
126	SELECT SQL_NO_CACHE * FROM `zp1h_category` c LEFT JOIN `zp1h_category_lang` `cl` ON c.id_category = cl.id_category AND id_lang = 1 AND cl.id_shop = 1 WHERE (c.nleft <= 4 AND c.nright >= 5) ORDER BY c.nleft	2.789 ms	4			/classes/Product.php:7854 /override/classes/Link.php:660 (getParentCategories) /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)
382	SELECT SQL_NO_CACHE * FROM `zp1h_employee` a LEFT JOIN `zp1h_employee_shop` `c` ON a.`id_employee` = c.`id_employee` AND c.`id_shop` = 1 WHERE (a.`id_employee` = 1) LIMIT 1	2.762 ms	1			/src/Adapter/EntityMapper.php:71 /classes/ObjectModel.php:283 (load) /tools/profiling/ObjectModel.php:32 (__construct) /classes/Employee.php:167 (__construct) /modules/tvcmsblog/classes/tvcmspostsclass.php:729 (__construct) /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)
129	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.753 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)
138	SELECT SQL_NO_CACHE product_type FROM `zp1h_product` WHERE id_product = 477 LIMIT 1	2.727 ms	1			/classes/Pack.php:90 /classes/Product.php:4344 (isPack) /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)
131	SELECT SQL_NO_CACHE tr.* FROM `zp1h_tax_rule` tr JOIN `zp1h_tax_rules_group` trg ON (tr.`id_tax_rules_group` = trg.`id_tax_rules_group`) WHERE trg.`active` = 1 AND tr.`id_country` = 8 AND tr.`id_tax_rules_group` = 3 AND tr.`id_state` IN (0, 0) AND ('69340' BETWEEN tr.`zipcode_from` AND tr.`zipcode_to` OR (tr.`zipcode_to` = 0 AND tr.`zipcode_from` IN(0, '69340'))) ORDER BY tr.`zipcode_from` DESC, tr.`zipcode_to` DESC, tr.`id_state` DESC, tr.`id_country` DESC	2.586 ms	1	Yes		/classes/tax/TaxRulesTaxManager.php:109 /classes/Product.php:3926 (getTaxCalculator) /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)
23	SELECT SQL_NO_CACHE `id_product` FROM zp1h_product_lang WHERE `link_rewrite` = "farfadaises" AND `id_lang` = 1 AND `id_shop` = 1 LIMIT 1	2.580 ms	184			/override/classes/Dispatcher.php:1424 /override/classes/Dispatcher.php:347 (getProductExistance) /classes/Dispatcher.php:346 (getController) /index.php:28 (dispatch)
145	SELECT SQL_NO_CACHE state FROM zp1h_feature_flag WHERE name = 'multiple_image_format' LIMIT 1	2.561 ms	1			/classes/FeatureFlag.php:105 /src/Core/Image/ImageFormatConfiguration.php:69 (isEnabled) /src/Adapter/Image/ImageRetriever.php:209 (getGenerationFormats) /src/Adapter/Image/ImageRetriever.php:111 (getImage) :undefined (PrestaShop\PrestaShop\Adapter\Image\{closure}) /src/Adapter/Image/ImageRetriever.php:104 (array_map) /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)
105	SELECT SQL_NO_CACHE `id_manufacturer` FROM zp1h_manufacturer WHERE `name` LIKE "farfadaises" LIMIT 1	2.499 ms	9			/override/classes/Link.php:730 /override/classes/Link.php:195 (getKeyExistanceManuf) /modules/tvcmsinfinitescroll/tvcmsinfinitescroll.php:196 (getPaginationLink) /classes/Hook.php:1083 (hookHeader) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:421 (coreCallHook) /classes/Hook.php:989 (callHookOn) /classes/controller/FrontController.php:633 (exec) /controllers/front/listing/CategoryController.php:127 (initContent) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
551	SELECT SQL_NO_CACHE (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS grade FROM `zp1h_tvcmsproduct_comment` pc WHERE pc.`id_product` = 477 AND pc.`deleted` = 0 AND pc.`validate` = 1 LIMIT 1	2.486 ms	1			/modules/tvcmsproductcomments/tvcmsproductcomment.php:224 /modules/tvcmsproductcomments/tvcmsproductcomments.php:928 (getAverageGrade) /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: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/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: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/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)
381	SELECT SQL_NO_CACHE COUNT(id_tvcms_comments) AS total_comment FROM `zp1h_tvcms_comments` xc WHERE xc.`id_post` = 2	2.384 ms	1			/modules/tvcmsblog/classes/tvcmscommentclass.php:109 /modules/tvcmsblog/classes/tvcmspostsclass.php:790 (getCountComments) /modules/tvcmsblogdisplayposts/tvcmsblogdisplayposts.php:418 (getCategoryPosts) /modules/tvcmsblogdisplayposts/tvcmsblogdisplayposts.php:483 (showFrontSideResult) /classes/Hook.php:1083 (hookdisplayLeftColumn) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:421 (coreCallHook) /classes/Hook.php:989 (callHookOn) /config/smarty.config.inc.php:201 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/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)
132	SELECT SQL_NO_CACHE * FROM `zp1h_tax` a WHERE (a.`id_tax` = 3) LIMIT 1	2.376 ms	1			/src/Adapter/EntityMapper.php:71 /classes/ObjectModel.php:283 (load) /tools/profiling/ObjectModel.php:32 (__construct) /classes/tax/TaxRulesTaxManager.php:116 (__construct) /classes/Product.php:3926 (getTaxCalculator) /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)
112	SELECT SQL_NO_CACHE type, id_value, filter_show_limit, filter_type FROM zp1h_layered_category WHERE controller = 'category' AND id_category = 5 AND id_shop = 1 GROUP BY `type`, id_value ORDER BY position ASC	2.230 ms	3	Yes	Yes	/modules/ps_facetedsearch/src/Filters/Provider.php:61 /modules/ps_facetedsearch/src/Filters/Converter.php:263 (getFiltersForQuery) /modules/ps_facetedsearch/src/Product/SearchProvider.php:163 (createFacetedSearchFiltersFromQuery) /classes/controller/ProductListingFrontController.php:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
32	SELECT SQL_NO_CACHE `id_category` FROM zp1h_category_lang WHERE `link_rewrite` = 'farfadaises' AND `id_lang` = 1 AND `id_shop` = 1 LIMIT 1	2.203 ms	44			/override/controllers/front/CategoryController.php:40 /tools/profiling/Controller.php:41 (init) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
17	SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module`as `mshop` FROM `zp1h_module` m LEFT JOIN `zp1h_module_shop` ms ON m.`id_module` = ms.`id_module` AND ms.`id_shop` = 1	2.177 ms	163			/classes/module/Module.php:346 /modules/tvcmsblog/tvcmsblog.php:116 (__construct) :undefined (__construct) /src/Core/Foundation/IoC/Container.php:123 (newInstance) /src/Core/Foundation/IoC/Container.php:153 (makeInstanceFromClassName) /src/Core/Foundation/IoC/Container.php:166 (doMake) /src/Adapter/ServiceLocator.php:70 (make) /classes/module/Module.php:1263 (get) /tools/profiling/Module.php:35 (coreLoadModule) /classes/module/Module.php:1242 (coreLoadModule) /classes/Hook.php:972 (getInstanceByName) /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)
106	SELECT SQL_NO_CACHE `id_supplier` FROM zp1h_supplier WHERE `name` LIKE "farfadaises" LIMIT 1	2.085 ms	5			/override/classes/Link.php:742 /override/classes/Link.php:196 (getKeyExistanceSup) /modules/tvcmsinfinitescroll/tvcmsinfinitescroll.php:196 (getPaginationLink) /classes/Hook.php:1083 (hookHeader) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:421 (coreCallHook) /classes/Hook.php:989 (callHookOn) /classes/controller/FrontController.php:633 (exec) /controllers/front/listing/CategoryController.php:127 (initContent) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
151	SELECT SQL_NO_CACHE id_product, name, value, pf.id_feature FROM zp1h_feature_product pf LEFT JOIN zp1h_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1) LEFT JOIN zp1h_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1) LEFT JOIN zp1h_feature f ON (f.id_feature = pf.id_feature) INNER JOIN zp1h_feature_shop feature_shop ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1) WHERE `id_product` IN (539,537,536,535,534) ORDER BY f.position ASC	2.077 ms	15	Yes		/classes/Product.php:4904 /classes/Product.php:3125 (cacheFrontFeatures) /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)
86	SELECT SQL_NO_CACHE * FROM `zp1h_image_type` WHERE 1 AND `products` = 1 ORDER BY `width` DESC, `height` DESC, `name`ASC	2.076 ms	14	Yes		/classes/ImageType.php:109 /src/Adapter/Image/ImageRetriever.php:381 (getImagesTypes) /classes/controller/FrontController.php:1627 (getNoPictureImage) /classes/controller/FrontController.php:1753 (getTemplateVarUrls) /classes/controller/FrontController.php:563 (getTemplateVarShop) /classes/controller/FrontController.php:625 (assignGeneralPurposeVariables) /controllers/front/listing/CategoryController.php:127 (initContent) /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

Panier

Salon Magnifique Livre 2025

Salon Primevère

Et encore une petite mise à jour de notre site

Don Quichotte

Don Quichotte

Don Quichotte

Don Quichotte

Stopwatch SQL - 587 queries

Doubles

Tables stress

ObjectModel instances

Included Files