En poursuivant votre navigation sur ce site, vous acceptez l'utilisation de Cookies qui garantissent son bon fonctionnement. En savoir plus.

Emporte-pièces et Découpoirs

Emporte-pièces et découpoirs en fer blanc ou en inox pour réaliser petits biscuits, petits gâteaux, sablés et bredele . Vous trouverez un large choix d'emporte-pièce et découpoirs de différentes formes, des plus classiques, aux plus originales, des animaux, de la vie quotidienne, du fun, des...Lire la suite

Sous-Catégories

200 produits

Grille

Grille 2

Liste

Liste 2

Catalogue

Trier par :

Emporte-pièce Hiboux

6,50 €

En rupture de stock

Emporte-pièce Hiboux

6,50 €

En rupture de stock

Emporte-pièce Hiboux

Emporte-pièces Animaux

Emporte-pièce Hiboux avec empreinte, idéal pour la confection de petits biscuits. Emporte-pièce parfait pour la réalisation de bredele. Ajoutez une touche de couleur à vos biscuits avec les stylos de pâtisseries . En inox de...

6,50 €

En rupture de stock

Load Time	1706 ms
Querying Time	894 ms
Queries	1764
Memory Peak Usage	54.4 Mb
Included Files	1247 files - 14.87 Mb
PrestaShop Cache	- Mb
Global vars	1.33 Mb
- global $_MODULES	1319k
- global $_SERVER	12k
- global $_MODULE	9k
- global $config	5k
- global $context	3k
- global $exportPhpConfigFile	3k
- global $smarty	2k
- global $__composer_autoload_files	2k

PrestaShop Version	8.1.7
PHP Version	8.1.29
MySQL Version	10.11.6-MariaDB-0+deb12u1
Memory Limit	128M
Max Execution Time	1200s
Smarty Cache	enabled
Smarty Compilation	auto

	Time	Cumulated Time	Memory Usage	Memory Peak Usage
config	13.412 ms	13.412 ms	8.24 Mb	11.3 Mb
__construct	0.017 ms	13.429 ms	- Mb	11.3 Mb
init	55.986 ms	69.415 ms	1.00 Mb	11.3 Mb
checkAccess	0.002 ms	69.417 ms	- Mb	11.3 Mb
setMedia	7.967 ms	77.384 ms	0.31 Mb	11.3 Mb
postProcess	0.001 ms	77.385 ms	- Mb	11.3 Mb
initHeader	0.001 ms	77.386 ms	- Mb	11.3 Mb
initContent	795.089 ms	872 ms	9.20 Mb	18.9 Mb
initFooter	0.002 ms	872 ms	- Mb	18.9 Mb
display	834 ms	1706 ms	34.74 Mb	54.4 Mb

Hook	Time	Memory Usage
DisplayLeftColumn	547.820 ms	22.84 Mb
=> tvcmsverticalmenu	0.012 ms	- Mb
=> tvcmsleftsideofferbanner	0.775 ms	0.02 Mb
=> tvcmsnewproducts	111.060 ms	1.98 Mb
=> tvcmscustomerservices	0.812 ms	0.02 Mb
=> tvcmsspecialproducts	371.193 ms	19.09 Mb
=> tvcmsfeaturedproducts	63.883 ms	1.72 Mb
=> tvcmsbestsellerproducts	0.085 ms	- Mb
DisplayHeader	171.530 ms	0.36 Mb
=> prestablog	2.645 ms	0.04 Mb
=> ps_searchbar	1.489 ms	- Mb
=> boxtalconnect	142.107 ms	0.03 Mb
=> tvcmsbestsellerproducts	0.239 ms	- Mb
=> tvcmsfeaturedproducts	0.228 ms	- Mb
=> tvcmsfooterproduct	0.238 ms	- Mb
=> tvcmsnewproducts	0.259 ms	- Mb
=> tvcmsslider	0.534 ms	- Mb
=> tvcmsspecialproducts	0.228 ms	- Mb
=> tvcmsbrandlist	0.520 ms	- Mb
=> tvcmscategorychainslider	0.543 ms	- Mb
=> tvcmscategoryslider	0.640 ms	- Mb
=> tvcmscookiesnotice	0.397 ms	- Mb
=> tvcmscustomerservices	0.433 ms	- Mb
=> tvcmscustomsetting	2.521 ms	0.01 Mb
=> tvcmsfooterlogo	0.002 ms	- Mb
=> tvcmsinfinitescroll	3.365 ms	0.04 Mb
=> tvcmsmultibanner1	0.418 ms	- Mb
=> tvcmsnewsletterpopup	0.901 ms	0.06 Mb
=> tvcmspaymenticon	0.002 ms	- Mb
=> tvcmssearch	1.048 ms	- Mb
=> tvcmstabproducts	0.468 ms	- Mb
=> tvcmsthemeoptions	1.164 ms	- Mb
=> tvcmswishlist	0.440 ms	- Mb
=> msiliunas_googletagmanager	0.734 ms	0.01 Mb
=> medbingpixelfree	0.739 ms	0.01 Mb
=> ps_shoppingcart	0.111 ms	- Mb
=> tacartreminder	0.012 ms	- Mb
=> tvcmssizechart	0.390 ms	- Mb
=> pm_advancedtopmenu	3.457 ms	0.02 Mb
=> steavisgarantis	1.238 ms	0.01 Mb
=> ps_googleanalytics	0.802 ms	0.02 Mb
=> gmerchantcenterpro	1.879 ms	0.06 Mb
=> crisp	0.909 ms	0.02 Mb
=> myprestaloyalty	0.430 ms	- Mb
DisplayProductPriceBlock	82.683 ms	5.99 Mb
=> steavisgarantis	1.083 ms	0.07 Mb
=> steavisgarantis	0.003 ms	- Mb
=> steavisgarantis	0.001 ms	- Mb
=> steavisgarantis	1.182 ms	0.07 Mb
=> steavisgarantis	0.002 ms	- Mb
=> steavisgarantis	0.001 ms	- Mb
=> steavisgarantis	1.027 ms	0.07 Mb
=> steavisgarantis	0.010 ms	- Mb
=> steavisgarantis	0.002 ms	- Mb
=> steavisgarantis	1.140 ms	0.07 Mb
=> steavisgarantis	0.003 ms	- Mb
=> steavisgarantis	0.001 ms	- Mb
=> steavisgarantis	1.151 ms	0.07 Mb
=> steavisgarantis	0.006 ms	- Mb
=> steavisgarantis	0.002 ms	- Mb
=> steavisgarantis	0.690 ms	0.07 Mb
=> steavisgarantis	0.002 ms	- Mb
=> steavisgarantis	0.001 ms	- Mb
=> steavisgarantis	0.649 ms	0.07 Mb
=> steavisgarantis	0.002 ms	- Mb
=> steavisgarantis	0.001 ms	- Mb
=> steavisgarantis	0.681 ms	0.07 Mb
=> steavisgarantis	0.002 ms	- Mb
=> steavisgarantis	0.001 ms	- Mb
=> steavisgarantis	0.682 ms	0.07 Mb
=> steavisgarantis	0.002 ms	- Mb
=> steavisgarantis	0.001 ms	- Mb
=> steavisgarantis	0.788 ms	0.07 Mb
=> steavisgarantis	0.002 ms	- Mb
=> steavisgarantis	0.001 ms	- Mb
=> steavisgarantis	0.709 ms	0.07 Mb
=> steavisgarantis	0.003 ms	- Mb
=> steavisgarantis	0.002 ms	- Mb
=> steavisgarantis	0.648 ms	0.07 Mb
=> steavisgarantis	0.003 ms	- Mb
=> steavisgarantis	0.001 ms	- Mb
=> steavisgarantis	0.781 ms	0.07 Mb
=> steavisgarantis	0.002 ms	- Mb
=> steavisgarantis	0.001 ms	- Mb
=> steavisgarantis	1.020 ms	0.07 Mb
=> steavisgarantis	0.003 ms	- Mb
=> steavisgarantis	0.001 ms	- Mb
=> steavisgarantis	0.998 ms	0.07 Mb
=> steavisgarantis	0.003 ms	- Mb
=> steavisgarantis	0.001 ms	- Mb
=> steavisgarantis	0.771 ms	0.07 Mb
=> steavisgarantis	0.003 ms	- Mb
=> steavisgarantis	0.001 ms	- Mb
=> steavisgarantis	0.788 ms	0.07 Mb
=> steavisgarantis	0.003 ms	- Mb
=> steavisgarantis	0.002 ms	- Mb
=> steavisgarantis	0.799 ms	0.07 Mb
=> steavisgarantis	0.004 ms	- Mb
=> steavisgarantis	0.002 ms	- Mb
=> steavisgarantis	0.681 ms	0.07 Mb
=> steavisgarantis	0.002 ms	- Mb
=> steavisgarantis	0.001 ms	- Mb
=> steavisgarantis	0.724 ms	0.07 Mb
=> steavisgarantis	0.003 ms	- Mb
=> steavisgarantis	0.001 ms	- Mb
=> steavisgarantis	1.065 ms	0.07 Mb
=> steavisgarantis	0.005 ms	- Mb
=> steavisgarantis	0.002 ms	- Mb
=> steavisgarantis	0.963 ms	0.07 Mb
=> steavisgarantis	0.004 ms	- Mb
=> steavisgarantis	0.002 ms	- Mb
=> steavisgarantis	0.921 ms	0.07 Mb
=> steavisgarantis	0.004 ms	- Mb
=> steavisgarantis	0.002 ms	- Mb
=> steavisgarantis	1.044 ms	0.07 Mb
=> steavisgarantis	0.006 ms	- Mb
=> steavisgarantis	0.005 ms	- Mb
=> steavisgarantis	1.009 ms	0.07 Mb
=> steavisgarantis	0.003 ms	- Mb
=> steavisgarantis	0.002 ms	- Mb
=> steavisgarantis	0.793 ms	0.07 Mb
=> steavisgarantis	0.003 ms	- Mb
=> steavisgarantis	0.002 ms	- Mb
=> steavisgarantis	0.733 ms	0.07 Mb
=> steavisgarantis	0.004 ms	- Mb
=> steavisgarantis	0.002 ms	- Mb
=> steavisgarantis	0.840 ms	0.07 Mb
=> steavisgarantis	0.003 ms	- Mb
=> steavisgarantis	0.002 ms	- Mb
=> steavisgarantis	0.915 ms	0.07 Mb
=> steavisgarantis	0.003 ms	- Mb
=> steavisgarantis	0.002 ms	- Mb
=> steavisgarantis	0.693 ms	0.07 Mb
=> steavisgarantis	0.007 ms	- Mb
=> steavisgarantis	0.004 ms	- Mb
=> steavisgarantis	0.986 ms	0.07 Mb
=> steavisgarantis	0.005 ms	- Mb
=> steavisgarantis	0.002 ms	- Mb
=> steavisgarantis	0.773 ms	0.07 Mb
=> steavisgarantis	0.004 ms	- Mb
=> steavisgarantis	0.002 ms	- Mb
=> steavisgarantis	2.125 ms	0.09 Mb
=> steavisgarantis	0.004 ms	- Mb
=> steavisgarantis	0.003 ms	- Mb
=> steavisgarantis	1.517 ms	0.08 Mb
=> steavisgarantis	0.005 ms	- Mb
=> steavisgarantis	0.003 ms	- Mb
=> steavisgarantis	1.519 ms	0.08 Mb
=> steavisgarantis	0.004 ms	- Mb
=> steavisgarantis	0.002 ms	- Mb
=> steavisgarantis	1.586 ms	0.08 Mb
=> steavisgarantis	0.011 ms	- Mb
=> steavisgarantis	0.003 ms	- Mb
=> steavisgarantis	1.546 ms	0.08 Mb
=> steavisgarantis	0.004 ms	- Mb
=> steavisgarantis	0.002 ms	- Mb
=> steavisgarantis	1.824 ms	0.08 Mb
=> steavisgarantis	0.004 ms	- Mb
=> steavisgarantis	0.003 ms	- Mb
=> steavisgarantis	1.444 ms	0.08 Mb
=> steavisgarantis	0.004 ms	- Mb
=> steavisgarantis	0.002 ms	- Mb
=> steavisgarantis	1.474 ms	0.08 Mb
=> steavisgarantis	0.004 ms	- Mb
=> steavisgarantis	0.002 ms	- Mb
=> steavisgarantis	1.593 ms	0.08 Mb
=> steavisgarantis	0.004 ms	- Mb
=> steavisgarantis	0.002 ms	- Mb
=> steavisgarantis	1.488 ms	0.08 Mb
=> steavisgarantis	0.003 ms	- Mb
=> steavisgarantis	0.002 ms	- Mb
=> steavisgarantis	1.262 ms	0.08 Mb
=> steavisgarantis	0.003 ms	- Mb
=> steavisgarantis	0.001 ms	- Mb
=> steavisgarantis	1.310 ms	0.08 Mb
=> steavisgarantis	0.003 ms	- Mb
=> steavisgarantis	0.002 ms	- Mb
=> steavisgarantis	0.850 ms	0.07 Mb
=> steavisgarantis	0.002 ms	- Mb
=> steavisgarantis	0.001 ms	- Mb
=> steavisgarantis	1.072 ms	0.07 Mb
=> steavisgarantis	0.006 ms	- Mb
=> steavisgarantis	0.003 ms	- Mb
=> steavisgarantis	1.265 ms	0.07 Mb
=> steavisgarantis	0.004 ms	- Mb
=> steavisgarantis	0.002 ms	- Mb
=> steavisgarantis	1.211 ms	0.07 Mb
=> steavisgarantis	0.004 ms	- Mb
=> steavisgarantis	0.003 ms	- Mb
=> steavisgarantis	1.139 ms	0.07 Mb
=> steavisgarantis	0.003 ms	- Mb
=> steavisgarantis	0.001 ms	- Mb
=> steavisgarantis	1.007 ms	0.07 Mb
=> steavisgarantis	0.003 ms	- Mb
=> steavisgarantis	0.001 ms	- Mb
=> steavisgarantis	1.085 ms	0.07 Mb
=> steavisgarantis	0.003 ms	- Mb
=> steavisgarantis	0.002 ms	- Mb
=> steavisgarantis	1.185 ms	0.07 Mb
=> steavisgarantis	0.004 ms	- Mb
=> steavisgarantis	0.001 ms	- Mb
=> steavisgarantis	1.004 ms	0.07 Mb
=> steavisgarantis	0.004 ms	- Mb
=> steavisgarantis	0.002 ms	- Mb
=> steavisgarantis	0.880 ms	0.07 Mb
=> steavisgarantis	0.003 ms	- Mb
=> steavisgarantis	0.002 ms	- Mb
=> steavisgarantis	0.836 ms	0.07 Mb
=> steavisgarantis	0.003 ms	- Mb
=> steavisgarantis	0.001 ms	- Mb
=> steavisgarantis	0.884 ms	0.07 Mb
=> steavisgarantis	0.003 ms	- Mb
=> steavisgarantis	0.002 ms	- Mb
=> steavisgarantis	0.939 ms	0.07 Mb
=> steavisgarantis	0.004 ms	- Mb
=> steavisgarantis	0.002 ms	- Mb
=> steavisgarantis	0.782 ms	0.07 Mb
=> steavisgarantis	0.002 ms	- Mb
=> steavisgarantis	0.002 ms	- Mb
=> steavisgarantis	0.950 ms	0.07 Mb
=> steavisgarantis	0.005 ms	- Mb
=> steavisgarantis	0.003 ms	- Mb
=> steavisgarantis	0.877 ms	0.07 Mb
=> steavisgarantis	0.003 ms	- Mb
=> steavisgarantis	0.001 ms	- Mb
=> steavisgarantis	0.817 ms	0.07 Mb
=> steavisgarantis	0.003 ms	- Mb
=> steavisgarantis	0.001 ms	- Mb
=> steavisgarantis	0.789 ms	0.07 Mb
=> steavisgarantis	0.008 ms	- Mb
=> steavisgarantis	0.001 ms	- Mb
=> steavisgarantis	0.732 ms	0.07 Mb
=> steavisgarantis	0.002 ms	- Mb
=> steavisgarantis	0.001 ms	- Mb
=> steavisgarantis	0.716 ms	0.07 Mb
=> steavisgarantis	0.002 ms	- Mb
=> steavisgarantis	0.001 ms	- Mb
=> steavisgarantis	0.846 ms	0.07 Mb
=> steavisgarantis	0.002 ms	- Mb
=> steavisgarantis	0.001 ms	- Mb
=> steavisgarantis	0.682 ms	0.07 Mb
=> steavisgarantis	0.003 ms	- Mb
=> steavisgarantis	0.002 ms	- Mb
=> steavisgarantis	0.686 ms	0.07 Mb
=> steavisgarantis	0.002 ms	- Mb
=> steavisgarantis	0.002 ms	- Mb
=> steavisgarantis	0.851 ms	0.07 Mb
=> steavisgarantis	0.002 ms	- Mb
=> steavisgarantis	0.002 ms	- Mb
=> steavisgarantis	1.318 ms	0.08 Mb
=> steavisgarantis	0.003 ms	- Mb
=> steavisgarantis	0.002 ms	- Mb
=> steavisgarantis	1.444 ms	0.08 Mb
=> steavisgarantis	0.002 ms	- Mb
=> steavisgarantis	0.001 ms	- Mb
=> steavisgarantis	1.251 ms	0.08 Mb
=> steavisgarantis	0.003 ms	- Mb
=> steavisgarantis	0.002 ms	- Mb
=> steavisgarantis	1.362 ms	0.08 Mb
=> steavisgarantis	0.003 ms	- Mb
=> steavisgarantis	0.002 ms	- Mb
=> steavisgarantis	1.262 ms	0.08 Mb
=> steavisgarantis	0.003 ms	- Mb
=> steavisgarantis	0.001 ms	- Mb
=> steavisgarantis	1.286 ms	0.08 Mb
=> steavisgarantis	0.003 ms	- Mb
=> steavisgarantis	0.001 ms	- Mb
=> steavisgarantis	1.272 ms	0.08 Mb
=> steavisgarantis	0.003 ms	- Mb
=> steavisgarantis	0.001 ms	- Mb
=> steavisgarantis	1.302 ms	0.08 Mb
=> steavisgarantis	0.002 ms	- Mb
=> steavisgarantis	0.002 ms	- Mb
=> steavisgarantis	0.835 ms	0.07 Mb
=> steavisgarantis	0.002 ms	- Mb
=> steavisgarantis	0.001 ms	- Mb
=> steavisgarantis	0.833 ms	0.07 Mb
=> steavisgarantis	0.003 ms	- Mb
=> steavisgarantis	0.001 ms	- Mb
=> steavisgarantis	0.798 ms	0.07 Mb
=> steavisgarantis	0.003 ms	- Mb
=> steavisgarantis	0.001 ms	- Mb
=> steavisgarantis	0.804 ms	0.07 Mb
=> steavisgarantis	0.003 ms	- Mb
=> steavisgarantis	0.002 ms	- Mb
DisplayWishlistBtnProductList	45.050 ms	- Mb
=> tvcmswishlist	0.802 ms	0.01 Mb
=> tvcmswishlist	0.447 ms	- Mb
=> tvcmswishlist	0.505 ms	- Mb
=> tvcmswishlist	0.475 ms	- Mb
=> tvcmswishlist	0.474 ms	- Mb
=> tvcmswishlist	0.466 ms	- Mb
=> tvcmswishlist	0.513 ms	- Mb
=> tvcmswishlist	0.438 ms	- Mb
=> tvcmswishlist	0.419 ms	- Mb
=> tvcmswishlist	0.524 ms	- Mb
=> tvcmswishlist	0.446 ms	- Mb
=> tvcmswishlist	0.499 ms	- Mb
=> tvcmswishlist	0.423 ms	- Mb
=> tvcmswishlist	0.482 ms	- Mb
=> tvcmswishlist	0.511 ms	- Mb
=> tvcmswishlist	0.460 ms	- Mb
=> tvcmswishlist	0.427 ms	- Mb
=> tvcmswishlist	0.468 ms	- Mb
=> tvcmswishlist	0.429 ms	- Mb
=> tvcmswishlist	0.485 ms	- Mb
=> tvcmswishlist	0.435 ms	- Mb
=> tvcmswishlist	0.815 ms	- Mb
=> tvcmswishlist	0.861 ms	- Mb
=> tvcmswishlist	1.172 ms	- Mb
=> tvcmswishlist	1.216 ms	- Mb
=> tvcmswishlist	0.452 ms	- Mb
=> tvcmswishlist	0.700 ms	- Mb
=> tvcmswishlist	0.624 ms	- Mb
=> tvcmswishlist	0.676 ms	- Mb
=> tvcmswishlist	0.628 ms	- Mb
=> tvcmswishlist	0.890 ms	- Mb
=> tvcmswishlist	0.674 ms	- Mb
=> tvcmswishlist	0.628 ms	- Mb
=> tvcmswishlist	0.720 ms	- Mb
=> tvcmswishlist	0.630 ms	- Mb
=> tvcmswishlist	0.656 ms	- Mb
=> tvcmswishlist	0.701 ms	- Mb
=> tvcmswishlist	0.665 ms	- Mb
=> tvcmswishlist	0.710 ms	- Mb
=> tvcmswishlist	0.822 ms	- Mb
=> tvcmswishlist	0.687 ms	- Mb
=> tvcmswishlist	0.674 ms	- Mb
=> tvcmswishlist	0.420 ms	- Mb
=> tvcmswishlist	0.438 ms	- Mb
=> tvcmswishlist	0.429 ms	- Mb
=> tvcmswishlist	0.453 ms	- Mb
=> tvcmswishlist	0.833 ms	- Mb
=> tvcmswishlist	0.806 ms	- Mb
=> tvcmswishlist	1.035 ms	- Mb
=> tvcmswishlist	0.444 ms	- Mb
=> tvcmswishlist	0.438 ms	- Mb
=> tvcmswishlist	0.564 ms	- Mb
=> tvcmswishlist	0.515 ms	- Mb
=> tvcmswishlist	0.656 ms	- Mb
=> tvcmswishlist	0.618 ms	- Mb
=> tvcmswishlist	0.636 ms	- Mb
=> tvcmswishlist	0.599 ms	- Mb
=> tvcmswishlist	0.545 ms	- Mb
=> tvcmswishlist	0.532 ms	- Mb
=> tvcmswishlist	0.440 ms	- Mb
=> tvcmswishlist	0.434 ms	- Mb
=> tvcmswishlist	0.469 ms	- Mb
=> tvcmswishlist	0.456 ms	- Mb
=> tvcmswishlist	0.489 ms	- Mb
=> tvcmswishlist	0.429 ms	- Mb
=> tvcmswishlist	0.428 ms	- Mb
=> tvcmswishlist	0.465 ms	- Mb
=> tvcmswishlist	0.456 ms	- Mb
=> tvcmswishlist	0.463 ms	- Mb
=> tvcmswishlist	0.482 ms	- Mb
=> tvcmswishlist	0.422 ms	- Mb
=> tvcmswishlist	0.410 ms	- Mb
=> tvcmswishlist	0.420 ms	- Mb
=> tvcmswishlist	0.461 ms	- Mb
=> tvcmswishlist	0.430 ms	- Mb
=> tvcmswishlist	0.409 ms	- Mb
=> tvcmswishlist	0.432 ms	- Mb
=> tvcmswishlist	0.435 ms	- Mb
=> tvcmswishlist	0.475 ms	- Mb
=> tvcmswishlist	0.454 ms	- Mb
DisplayMegamenu	17.897 ms	0.87 Mb
=> tvcmsmegamenu	17.897 ms	0.87 Mb
DisplayFooterCategory	14.934 ms	0.48 Mb
=> tvcmsfootercategory	14.934 ms	0.48 Mb
Header	10.251 ms	0.04 Mb
=> stripe_official	0.016 ms	- Mb
=> eicaptcha	0.012 ms	- Mb
=> tvcmsleftsideofferbanner	0.002 ms	- Mb
=> tvcmsofferbanner	0.373 ms	- Mb
=> tvcmssliderofferbanner	0.454 ms	- Mb
=> tvcmsverticalmenu	0.936 ms	- Mb
=> faqs	2.078 ms	- Mb
=> relaiscolis	0.279 ms	- Mb
=> prestatilldrive	0.673 ms	- Mb
=> paypal	4.033 ms	0.01 Mb
=> doofinder	0.951 ms	0.01 Mb
=> tvcmsmegamenu	0.444 ms	- Mb
DisplayNavSearchBlock	10.238 ms	0.62 Mb
=> tvcmssearch	10.238 ms	0.62 Mb
DisplayBeforeBodyClosingTag	7.004 ms	0.16 Mb
=> statsdata	7.004 ms	0.16 Mb
displayLeftColumn	5.546 ms	0.14 Mb
=> ps_categorytree (widget)	5.546 ms	0.14 Mb
DisplayCustomsocialblock	5.001 ms	0.14 Mb
=> tvcmscustomsetting	5.001 ms	0.14 Mb
DisplayNavWishlistBlock	2.538 ms	0.04 Mb
=> tvcmswishlist	2.538 ms	0.04 Mb
DisplayNavWishlistBlocksticky	2.440 ms	0.05 Mb
=> tvcmswishlist	2.440 ms	0.05 Mb
DisplayPaymentIcon	2.289 ms	0.04 Mb
=> tvcmspaymenticon	2.289 ms	0.04 Mb
displayFooterPart1	2.258 ms	0.06 Mb
=> ps_linklist (widget)	2.258 ms	0.06 Mb
displayNavCustomerSignInBlock	2.058 ms	0.05 Mb
=> ps_customersignin (widget)	2.058 ms	0.05 Mb
displaySocialMediaBlock	2.005 ms	0.07 Mb
=> ps_socialfollow (widget)	2.005 ms	0.07 Mb
displayNewslettersubscription	1.934 ms	0.12 Mb
=> ps_emailsubscription (widget)	1.934 ms	0.12 Mb
displayMyaccountcblock	1.848 ms	0.06 Mb
=> ps_customeraccountlinks (widget)	1.848 ms	0.06 Mb
displayNav1	1.714 ms	0.08 Mb
=> ps_contactinfo (widget)	1.714 ms	0.08 Mb
displayNavCurrencyBlock	1.617 ms	0.08 Mb
=> ps_currencyselector (widget)	1.617 ms	0.08 Mb
ProductSearchProvider	1.430 ms	- Mb
=> ps_facetedsearch	1.430 ms	- Mb
displayNavShoppingCartBlock	1.375 ms	0.05 Mb
=> ps_shoppingcart (widget)	1.375 ms	0.05 Mb
ActionFrontControllerSetMedia	1.317 ms	0.01 Mb
=> ps_emailsubscription	0.604 ms	- Mb
=> ps_emailalerts	0.409 ms	- Mb
=> ps_socialfollow	0.289 ms	- Mb
=> paybox	0.015 ms	- Mb
DisplayCopyRightText	1.230 ms	0.01 Mb
=> tvcmscustomsetting	1.230 ms	0.01 Mb
displayContactCinfo	1.180 ms	0.03 Mb
=> ps_contactinfo (widget)	1.180 ms	0.03 Mb
displayNavLanguageBlock	0.848 ms	0.06 Mb
=> ps_languageselector (widget)	0.848 ms	0.06 Mb
DisplayAfterBodyOpeningTag	0.814 ms	0.01 Mb
=> tvcmscookiesnotice	0.809 ms	0.01 Mb
=> blockreassurance	0.005 ms	- Mb
DisplayFooterPart2	0.780 ms	0.02 Mb
=> tvcmsfooterlogo	0.780 ms	0.02 Mb
DisplayFacetedSearchBlock	0.674 ms	0.03 Mb
=> ps_facetedsearch	0.674 ms	0.03 Mb
ModuleRoutes	0.048 ms	0.01 Mb
=> hspointofsalepro	0.018 ms	- Mb
=> faqs	0.006 ms	- Mb
=> prestablog	0.021 ms	0.01 Mb
=> doofinder	0.003 ms	- Mb
DisplayTopOfferText	0.019 ms	- Mb
=> tvcmscustomsetting	0.013 ms	- Mb
=> tvcmscustomsetting	0.006 ms	- Mb
DisplayCustomCss	0.015 ms	0.01 Mb
=> tvcmscustomcssjs	0.015 ms	0.01 Mb
DisplayCustomJs	0.012 ms	- Mb
=> tvcmscustomcssjs	0.012 ms	- Mb
DisplayNavFullWidth	0.008 ms	- Mb
=> blockreassurance	0.008 ms	- Mb
ActionDispatcherBefore	0.004 ms	- Mb
=> ets_productmanager	0.004 ms	- Mb
ActionFrontControllerAfterInit	0.003 ms	- Mb
=> freelivery	0.003 ms	- Mb
37 hook(s)	948 ms	32.51 Mb

140 queries	SELECT XX FROM `boutiqcookam_specific_price` WHERE id_product = XX LIMIT XX
139 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 `boutiqcookam_product` p INNER JOIN `boutiqcookam_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = XX) LEFT JOIN `boutiqcookam_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)
139 queries	SELECT `id_tax_rules_group` FROM `boutiqcookam_product_shop` WHERE `id_product` = XX AND id_shop=XX LIMIT XX
139 queries	SELECT `reduction` FROM `boutiqcookam_product_group_reduction_cache` WHERE `id_product` = XX AND `id_group` = XX LIMIT XX
111 queries	SELECT product_attribute_shop.id_product_attribute FROM boutiqcookam_product_attribute pa INNER JOIN boutiqcookam_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = XX) WHERE pa.id_product = XX LIMIT XX
109 queries	SELECT `priority`, `id_specific_price_priority` FROM `boutiqcookam_specific_price_priority` WHERE `id_product` = XX ORDER BY `id_specific_price_priority` DESC LIMIT XX
109 queries	SELECT *, ( IF (`id_group` = XX, XX, XX) + IF (`id_country` = XX, XX, XX) + IF (`id_currency` = XX, XX, XX) + IF (`id_shop` = XX, XX, XX) + IF (`id_customer` = XX, XX, XX)) AS `score` FROM `boutiqcookam_specific_price` WHERE `id_shop` IN (XX, XX) AND `id_currency` IN (XX, XX) AND `id_country` IN (XX, XX) AND `id_group` IN (XX, XX) AND `id_product` = XX AND `id_customer` = XX AND `id_product_attribute` = XX AND `id_cart` = XX AND (`from` = 'XX-XX-XX XX:XX:XX' OR 'XX-XX-XX XX:XX:XX' >= `from`) AND (`to` = 'XX-XX-XX XX:XX:XX' OR 'XX-XX-XX XX:XX:XX' <= `to`) AND IF(`from_quantity` > XX, `from_quantity`, XX) <= XX ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT XX
80 queries	SELECT count(*) FROM boutiqcookam_steavisgarantis_reviews WHERE product_id='XX' and id_lang='XX' LIMIT XX
80 queries	SELECT rate FROM boutiqcookam_steavisgarantis_average_rating WHERE product_id='XX' and id_lang='XX' LIMIT XX
37 queries	SELECT * FROM `boutiqcookam_category` a LEFT JOIN `boutiqcookam_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = XX LEFT JOIN `boutiqcookam_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
36 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 `boutiqcookam_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 `boutiqcookam_cart_product` cp JOIN `boutiqcookam_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `boutiqcookam_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
34 queries	SELECT COUNT(*) FROM `boutiqcookam_pack` WHERE id_product_pack = XX LIMIT XX
34 queries	SELECT product_type FROM `boutiqcookam_product` WHERE id_product = XX LIMIT XX
34 queries	SELECT SUM(quantity) FROM `boutiqcookam_stock_available` WHERE (id_product = XX) AND (id_product_attribute = XX) AND (id_shop_group = XX) AND (id_shop = XX) LIMIT XX
34 queries	SELECT * FROM `boutiqcookam_product` a LEFT JOIN `boutiqcookam_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = XX LEFT JOIN `boutiqcookam_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
32 queries	SELECT image_shop.`cover`, i.`id_image`, il.`legend`, i.`position` FROM `boutiqcookam_image` i INNER JOIN boutiqcookam_image_shop image_shop ON (image_shop.id_image = i.id_image AND image_shop.id_shop = XX) LEFT JOIN `boutiqcookam_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = XX) WHERE i.`id_product` = XX ORDER BY `position`
32 queries	SELECT `id_product_attribute` FROM `boutiqcookam_product_attribute` WHERE `id_product` = XX
31 queries	SELECT image_shop.`id_image` FROM `boutiqcookam_image` i INNER JOIN boutiqcookam_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
31 queries	SELECT name FROM boutiqcookam_category_lang WHERE id_shop = XX AND id_lang = XX AND id_category = XX LIMIT XX
31 queries	SELECT name, value, pf.id_feature, f.position, fvl.id_feature_value FROM boutiqcookam_feature_product pf LEFT JOIN boutiqcookam_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = XX) LEFT JOIN boutiqcookam_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = XX) LEFT JOIN boutiqcookam_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = XX) INNER JOIN boutiqcookam_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
20 queries	SELECT pa.`id_product`, a.`color`, pac.`id_product_attribute`, XX qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by FROM `boutiqcookam_product_attribute` pa INNER JOIN boutiqcookam_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = XX) JOIN `boutiqcookam_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`) JOIN `boutiqcookam_attribute` a ON (a.`id_attribute` = pac.`id_attribute`) JOIN `boutiqcookam_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = XX) JOIN `boutiqcookam_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`) WHERE pa.`id_product` IN (XX) AND ag.`is_color_group` = XX GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` ORDER BY a.`position` ASC;
17 queries	SELECT cl.`link_rewrite` FROM `boutiqcookam_category_lang` cl WHERE `id_lang` = XX AND cl.id_shop = XX AND cl.`id_category` = XX LIMIT XX
15 queries	SELECT `id_module` FROM `boutiqcookam_module_shop` WHERE `id_module` = XX AND `id_shop` = XX LIMIT XX
12 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 boutiqcookam_product p LEFT JOIN boutiqcookam_product_lang pl ON pl.id_product = p.id_product AND pl.id_shop = XX AND pl.id_lang = XX LEFT JOIN boutiqcookam_stock_available sa ON sa.id_product = p.id_product AND sa.id_shop = XX AND sa.id_product_attribute = XX AND sa.id_shop_group = XX LEFT JOIN boutiqcookam_product_shop ps ON ps.id_product = p.id_product AND ps.id_shop = XX WHERE p.id_product IN (XX)
9 queries	SELECT * FROM `boutiqcookam_category` a LEFT JOIN `boutiqcookam_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = XX WHERE (a.`id_category` = XX) LIMIT XX
9 queries	SELECT * FROM `boutiqcookam_category_lang` WHERE `id_category` = XX AND `id_shop` = XX
7 queries	SELECT `id_country` FROM `boutiqcookam_country` WHERE `iso_code` = 'FR' LIMIT XX
7 queries	SELECT c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop` FROM `boutiqcookam_category` c LEFT JOIN `boutiqcookam_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = XX ) INNER JOIN boutiqcookam_category_shop category_shop ON (category_shop.id_category = c.id_category AND category_shop.id_shop = XX) WHERE `id_lang` = XX AND c.`id_parent` = XX AND `active` = XX GROUP BY c.`id_category` ORDER BY category_shop.`position` ASC
7 queries	SELECT cg.`id_group` FROM `boutiqcookam_category_group` cg WHERE (cg.`id_category` = XX)
6 queries	SELECT m.`id_module`, m.`name`, ms.`id_module`as `mshop` FROM `boutiqcookam_module` m LEFT JOIN `boutiqcookam_module_shop` ms ON m.`id_module` = ms.`id_module` AND ms.`id_shop` = XX
5 queries	SELECT * FROM `boutiqcookam_country` a LEFT JOIN `boutiqcookam_country_shop` `c` ON a.`id_country` = c.`id_country` AND c.`id_shop` = XX WHERE (a.`id_country` = XX) LIMIT XX
5 queries	SELECT * FROM `boutiqcookam_country_lang` WHERE `id_country` = XX
5 queries	SELECT `name` FROM `boutiqcookam_country_lang` WHERE `id_lang` = XX AND `id_country` = XX LIMIT XX
5 queries	SELECT tr.* FROM `boutiqcookam_tax_rule` tr JOIN `boutiqcookam_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
4 queries	SELECT mr.* FROM boutiqcookam_tvcmsmegamenu_row_shop mr WHERE mr.`id_shop` = XX AND mr.id_tvcmsmegamenu = XX AND mr.`active` = XX
3 queries	SELECT `need_identification_number` FROM `boutiqcookam_country` WHERE `id_country` = XX LIMIT XX
3 queries	SELECT n.key, n.value, n.id_shop, n.id_shop_group FROM `boutiqcookam_bx_notices` n WHERE (n.id_shop_group=XX) AND (n.id_shop=XX) AND (n.key="setupWizard")
3 queries	SELECT n.key, n.value, n.id_shop, n.id_shop_group FROM `boutiqcookam_bx_notices` n WHERE (n.id_shop_group=XX) AND (n.id_shop=XX) AND (n.key="configurationFailure")
3 queries	CREATE TABLE IF NOT EXISTS `boutiqcookam_gmcp_tags_dynamic_last_product_not_ordered` (`id_tag` int(XX) NOT NULL,`start_date` DATETIME, `end_date` DATETIME, `id_product` CHAR(XX), UNIQUE KEY `last_product_ordered` (`id_tag`, `id_product`)) ENGINE=InnoDB DEFAULT CHARSET=utfXX;
3 queries	SELECT out_of_stock FROM `boutiqcookam_stock_available` WHERE (id_product = XX) AND (id_product_attribute = XX) AND (id_shop_group = XX) AND (id_shop = XX) LIMIT XX
3 queries	SELECT depends_on_stock FROM `boutiqcookam_stock_available` WHERE (id_product = XX) AND (id_product_attribute = XX) AND (id_shop_group = XX) AND (id_shop = XX) LIMIT XX
3 queries	SELECT location FROM `boutiqcookam_stock_available` WHERE (id_product = XX) AND (id_product_attribute = XX) AND (id_shop_group = XX) AND (id_shop = XX) LIMIT XX
2 queries	SELECT `id_lang` FROM `boutiqcookam_lang` WHERE `locale` = 'fr-fr' OR `language_code` = 'fr-fr' LIMIT XX
2 queries	SELECT `name` FROM `boutiqcookam_hook` WHERE `id_hook` = XX LIMIT XX
2 queries	SELECT `id_category` FROM `boutiqcookam_category_shop` WHERE `id_category` = XX AND `id_shop` = XX LIMIT XX
2 queries	SELECT ctg.`id_group` FROM boutiqcookam_category_group ctg WHERE ctg.`id_category` = XX AND ctg.`id_group` = XX LIMIT XX
2 queries	SELECT c.*, cl.`id_lang`, cl.`name`, cl.`description`, cl.`additional_description`, cl.`link_rewrite`, cl.`meta_title`, cl.`meta_keywords`, cl.`meta_description` FROM `boutiqcookam_category` c INNER JOIN boutiqcookam_category_shop category_shop ON (category_shop.id_category = c.id_category AND category_shop.id_shop = XX) LEFT JOIN `boutiqcookam_category_lang` cl ON (c.`id_category` = cl.`id_category` AND `id_lang` = XX AND cl.id_shop = XX ) LEFT JOIN `boutiqcookam_category_group` cg ON (cg.`id_category` = c.`id_category`) WHERE `id_parent` = XX AND `active` = XX AND cg.`id_group` =XX GROUP BY c.`id_category` ORDER BY `level_depth` ASC, category_shop.`position` ASC
2 queries	SELECT XX FROM `boutiqcookam_cart_rule` WHERE ((date_to >= "XX-XX-XX XX:XX:XX" AND date_to <= "XX-XX-XX XX:XX:XX") OR (date_from >= "XX-XX-XX XX:XX:XX" AND date_from <= "XX-XX-XX XX:XX:XX") OR (date_from < "XX-XX-XX XX:XX:XX" AND date_to > "XX-XX-XX XX:XX:XX")) AND `id_customer` IN (XX,XX) LIMIT XX
2 queries	SELECT `image_type` FROM `boutiqcookam_pm_advancedtopmenu_lang` WHERE `image_type` NOT IN ("jpg", "png", "gif") AND `id_lang` = XX
2 queries	BEGIN
2 queries	SHOW TABLES LIKE "boutiqcookam_gmcp_XX"
2 queries	CREATE TABLE IF NOT EXISTS `boutiqcookam_gmcp_reporting` (`id_reporting` int(XX) NOT NULL AUTO_INCREMENT,`iso_feed` LONGTEXT NOT NULL, `reporting_content` LONGTEXT NOT NULL,`id_shop` int(XX) NOT NULL,`date_add` datetime NOT NULL,`date_upd` datetime NOT NULL,PRIMARY KEY (`id_reporting`)) ENGINE=' . _MYSQL_ENGINE_ . ' DEFAULT CHARSET=utfXX;
2 queries	CREATE TABLE IF NOT EXISTS `boutiqcookam_gmcp_feeds` (`id_feed` int(XX) NOT NULL AUTO_INCREMENT,`iso_lang` LONGTEXT NOT NULL,`iso_country` LONGTEXT NOT NULL,`iso_currency` LONGTEXT NOT NULL, `taxonomy` LONGTEXT NOT NULL, `id_shop` int(XX) NOT NULL,`date_add` datetime NOT NULL,`date_upd` datetime NOT NULL,PRIMARY KEY (`id_feed`)) ENGINE=' . _MYSQL_ENGINE_ . ' DEFAULT CHARSET=utfXX;
2 queries	CREATE TABLE IF NOT EXISTS `boutiqcookam_gmcp_tags_price_range` (`id_tag` int(XX) NOT NULL, `price_min` CHAR(XX) NOT NULL, `price_max` CHAR(XX), `id_product` CHAR(XX), UNIQUE KEY `tag_price_range` (`id_tag`, `id_product`)) ENGINE=InnoDB DEFAULT CHARSET=utfXX;
2 queries	CREATE TABLE IF NOT EXISTS `boutiqcookam_gmcp_tmp_rules`(`id` int(XX) NOT NULL AUTO_INCREMENT, `id_shop` int(XX) NOT NULL DEFAULT "XX",`type` char(XX) NOT NULL, `exclusion_values` longtext NOT NULL, PRIMARY KEY (`id`)) ENGINE=InnoDB DEFAULT CHARSET=utfXX AUTO_INCREMENT=XX;
2 queries	CREATE TABLE IF NOT EXISTS `boutiqcookam_gmcp_tags_dynamic_last_product_ordered` (`id_tag` int(XX) NOT NULL,`start_date` DATETIME, `end_date` DATETIME, `id_product` CHAR(XX), UNIQUE KEY `last_product_ordered` (`id_tag`, `id_product`)) ENGINE=InnoDB DEFAULT CHARSET=utfXX;
2 queries	CREATE TABLE IF NOT EXISTS `boutiqcookam_gmcp_tags_dynamic_promotion` (`id_tag` int(XX) NOT NULL,`start_date` DATETIME, `end_date` DATETIME, `id_product` CHAR(XX), UNIQUE KEY `promotion` (`id_tag`, `id_product`)) ENGINE=InnoDB DEFAULT CHARSET=utfXX;
2 queries	CREATE TABLE IF NOT EXISTS `boutiqcookam_gmcp_discount_association` (`id_association` int(XX) NOT NULL AUTO_INCREMENT, `id_discount` int(XX) NOT NULL, `id_product` int(XX) NOT NULL, `channel` CHAR(XX) NOT NULL DEFAULT "SHOPPING_ADS", PRIMARY KEY (`id_association`) ) ENGINE=MyISAM DEFAULT CHARSET=utfXX;
2 queries	CREATE TABLE IF NOT EXISTS `boutiqcookam_gmcp_tags` (`id_tag` int(XX) NOT NULL AUTO_INCREMENT, `id_shop` int(XX) NOT NULL DEFAULT "XX", `name` char(XX) NOT NULL, `type` char(XX) NOT NULL, `active` TINYINT NOT NULL, `position` INT NOT NULL, `end_date` DATE, PRIMARY KEY (`id_tag`)) ENGINE=MyISAM DEFAULT CHARSET=utfXX AUTO_INCREMENT=XX ;
2 queries	COMMIT
2 queries	SELECT m.*, ml.`description`, ml.`short_description` FROM `boutiqcookam_manufacturer` m INNER JOIN boutiqcookam_manufacturer_shop manufacturer_shop ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = XX)INNER JOIN `boutiqcookam_manufacturer_lang` ml ON (m.`id_manufacturer` = ml.`id_manufacturer` AND ml.`id_lang` = XX)WHERE XX AND m.`active` = XX ORDER BY m.`name` ASC
2 queries	SELECT DISTINCT a.`id_attribute`, a.`color`, al.`name`, agl.`id_attribute_group`, IF(lialv.`url_name` IS NULL OR lialv.`url_name` = "", NULL, lialv.`url_name`) AS url_name, IF(lialv.`meta_title` IS NULL OR lialv.`meta_title` = "", NULL, lialv.`meta_title`) AS meta_title FROM `boutiqcookam_attribute_group` ag INNER JOIN `boutiqcookam_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = XX) INNER JOIN `boutiqcookam_attribute` a ON a.`id_attribute_group` = ag.`id_attribute_group` INNER JOIN `boutiqcookam_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = XX) INNER JOIN boutiqcookam_attribute_group_shop attribute_group_shop ON (attribute_group_shop.id_attribute_group = ag.id_attribute_group AND attribute_group_shop.id_shop = XX) INNER JOIN boutiqcookam_attribute_shop attribute_shop ON (attribute_shop.id_attribute = a.id_attribute AND attribute_shop.id_shop = XX) LEFT JOIN `boutiqcookam_layered_indexable_attribute_lang_value` lialv ON (a.`id_attribute` = lialv.`id_attribute` AND lialv.`id_lang` = XX) WHERE ag.id_attribute_group = XX ORDER BY agl.`name` ASC, a.`position` ASC
2 queries	SELECT pac.id_attribute, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM boutiqcookam_product p LEFT JOIN boutiqcookam_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN boutiqcookam_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN boutiqcookam_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, XX) = sa.id_product_attribute AND sa.id_shop_group = XX AND sa.id_shop = XX ) LEFT JOIN boutiqcookam_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN boutiqcookam_category_product cp ON (p.id_product = cp.id_product) INNER JOIN boutiqcookam_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = XX AND ps.active = TRUE) INNER JOIN boutiqcookam_category c ON (cp.id_category = c.id_category AND c.active=XX) LEFT JOIN boutiqcookam_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='XX' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='XX' AND p.id_manufacturer IN (XX, XX, XX) AND c.nleft>=XX AND c.nright<=XX GROUP BY p.id_product) p LEFT JOIN boutiqcookam_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN boutiqcookam_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) INNER JOIN boutiqcookam_attribute a ON (a.id_attribute = pac.id_attribute) WHERE ((a.id_attribute_group=XX)) GROUP BY pac.id_attribute
2 queries	SELECT fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM boutiqcookam_product p LEFT JOIN boutiqcookam_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN boutiqcookam_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN boutiqcookam_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, XX) = sa.id_product_attribute AND sa.id_shop_group = XX AND sa.id_shop = XX ) LEFT JOIN boutiqcookam_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN boutiqcookam_category_product cp ON (p.id_product = cp.id_product) INNER JOIN boutiqcookam_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = XX AND ps.active = TRUE) INNER JOIN boutiqcookam_category c ON (cp.id_category = c.id_category AND c.active=XX) LEFT JOIN boutiqcookam_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='XX' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='XX' AND p.id_manufacturer IN (XX, XX, XX) AND c.nleft>=XX AND c.nright<=XX GROUP BY p.id_product) p INNER JOIN boutiqcookam_feature_product fp ON (p.id_product = fp.id_product) WHERE ((fp.id_feature=XX)) GROUP BY fp.id_feature_value
2 queries	SELECT `name` FROM `boutiqcookam_manufacturer` WHERE `id_manufacturer` = XX AND `active` = XX LIMIT XX
2 queries	SELECT * FROM `boutiqcookam_tax` a WHERE (a.`id_tax` = XX) LIMIT XX
2 queries	SELECT * FROM `boutiqcookam_tax_lang` WHERE `id_tax` = XX
2 queries	SELECT count(id_wishlist_product) FROM boutiqcookam_wishlist w, boutiqcookam_wishlist_product wp where w.id_wishlist = wp.id_wishlist and w.id_customer=XX LIMIT XX

Name	Instances	Source
Category	83	/controllers/front/listing/CategoryController.php:78 (__construct) [id: 12] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 16] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 17] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 18] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 20] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 19] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 21] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 22] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 23] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 24] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 25] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 77] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 67] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 81] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 82] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 83] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 84] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 85] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 86] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 117] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 116] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 98] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 80] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 79] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 78] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 61] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 188] /classes/Meta.php:380 (__construct) [id: 12] /classes/PrestaShopCollection.php:385 (hydrateCollection) [id: ] /classes/PrestaShopCollection.php:385 (hydrateCollection) [id: ] /classes/Link.php:402 (__construct) [id: 12] /modules/ps_facetedsearch/src/Product/Search.php:364 (__construct) [id: 12] /modules/ps_facetedsearch/src/Filters/Block.php:157 (__construct) [id: 12] /modules/tvcmssearch/tvcmssearch.php:102 (getNestedCategories) [id: 1] /modules/tvcmsmegamenu/tvcmsmegamenu.php:1395 (__construct) [id: 12] /modules/tvcmsmegamenu/tvcmsmegamenu.php:1774 (__construct) [id: 12] /classes/Link.php:402 (__construct) [id: 12] /modules/tvcmsmegamenu/tvcmsmegamenu.php:1699 (__construct) [id: 12] /modules/tvcmsmegamenu/tvcmsmegamenu.php:1395 (__construct) [id: 13] /modules/tvcmsmegamenu/tvcmsmegamenu.php:1774 (__construct) [id: 13] /classes/Link.php:402 (__construct) [id: 13] /modules/tvcmsmegamenu/tvcmsmegamenu.php:1699 (__construct) [id: 13] /modules/tvcmsmegamenu/tvcmsmegamenu.php:1395 (__construct) [id: 14] /modules/tvcmsmegamenu/tvcmsmegamenu.php:1774 (__construct) [id: 14] /classes/Link.php:402 (__construct) [id: 14] /modules/tvcmsmegamenu/tvcmsmegamenu.php:1699 (__construct) [id: 14] /modules/tvcmsmegamenu/tvcmsmegamenu.php:1395 (__construct) [id: 127] /modules/tvcmsmegamenu/tvcmsmegamenu.php:1774 (__construct) [id: 127] /classes/Link.php:402 (__construct) [id: 127] /modules/tvcmsmegamenu/tvcmsmegamenu.php:1699 (__construct) [id: 127] /modules/tvcmsmegamenu/tvcmsmegamenu.php:1395 (__construct) [id: 137] /modules/tvcmsmegamenu/tvcmsmegamenu.php:1774 (__construct) [id: 137] /classes/Link.php:402 (__construct) [id: 137] /modules/tvcmsmegamenu/tvcmsmegamenu.php:1699 (__construct) [id: 137] /modules/tvcmsmegamenu/tvcmsmegamenu.php:1395 (__construct) [id: 149] /modules/tvcmsmegamenu/tvcmsmegamenu.php:1774 (__construct) [id: 149] /classes/Link.php:402 (__construct) [id: 149] /modules/tvcmsmegamenu/tvcmsmegamenu.php:1699 (__construct) [id: 149] /modules/tvcmsmegamenu/tvcmsmegamenu.php:1395 (__construct) [id: 119] /modules/tvcmsmegamenu/tvcmsmegamenu.php:1774 (__construct) [id: 119] /classes/Link.php:402 (__construct) [id: 119] /modules/tvcmsmegamenu/tvcmsmegamenu.php:1699 (__construct) [id: 119] /classes/Link.php:402 (__construct) [id: 62] /modules/tvcmsmegamenu/tvcmsmegamenu.php:1699 (__construct) [id: 62] /modules/ps_categorytree/ps_categorytree.php:338 (__construct) [id: 12] /modules/tvcmstabproducts/tvcmstabproducts.php:2683 (__construct) [id: 2] /classes/Link.php:402 (__construct) [id: 2] /modules/tvcmsfootercategory/tvcmsfootercategory.php:401 (__construct) [id: 12] /classes/Link.php:402 (__construct) [id: 12] /modules/tvcmsfootercategory/tvcmsfootercategory.php:401 (__construct) [id: 119] /classes/Link.php:402 (__construct) [id: 119] /modules/tvcmsfootercategory/tvcmsfootercategory.php:401 (__construct) [id: 127] /classes/Link.php:402 (__construct) [id: 127] /modules/tvcmsfootercategory/tvcmsfootercategory.php:401 (__construct) [id: 14] /classes/Link.php:402 (__construct) [id: 14] /modules/tvcmsfootercategory/tvcmsfootercategory.php:401 (__construct) [id: 13] /classes/Link.php:402 (__construct) [id: 13] /modules/tvcmsfootercategory/tvcmsfootercategory.php:401 (__construct) [id: 15] /classes/Link.php:402 (__construct) [id: 15] /modules/tvcmsfootercategory/tvcmsfootercategory.php:401 (__construct) [id: 137] /classes/Link.php:402 (__construct) [id: 137] /modules/tvcmsfootercategory/tvcmsfootercategory.php:401 (__construct) [id: 149] /classes/Link.php:402 (__construct) [id: 149]
Product	51	/classes/Link.php:113 (__construct) [id: 1777] /classes/Link.php:113 (__construct) [id: 1778] /classes/Link.php:113 (__construct) [id: 542] /classes/Link.php:113 (__construct) [id: 128] /classes/Link.php:113 (__construct) [id: 541] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 2732] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 3429] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 1777] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 1778] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 1837] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 3118] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 460] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 2488] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 3107] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 3109] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 3111] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 551] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 542] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 1780] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 128] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 2696] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 3223] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 3427] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 3108] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 541] /classes/Link.php:113 (__construct) [id: 1777] /classes/Link.php:113 (__construct) [id: 1778] /classes/Link.php:113 (__construct) [id: 542] /classes/Link.php:113 (__construct) [id: 128] /classes/Link.php:113 (__construct) [id: 541] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 3564] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 3563] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 3562] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 3561] /classes/Link.php:113 (__construct) [id: 601] /classes/Pack.php:286 (__construct) [id: 601] /classes/Pack.php:190 (__construct) [id: 535] /classes/Pack.php:190 (__construct) [id: 544] /classes/Pack.php:190 (__construct) [id: 600] /classes/Pack.php:243 (__construct) [id: 601] /classes/Pack.php:286 (__construct) [id: 601] /classes/Link.php:113 (__construct) [id: 700] /classes/Link.php:113 (__construct) [id: 704] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 1508] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 601] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 700] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 704] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 3430] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 3171] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 3481] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 3564]
Country	20	/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:1767 (__construct) [id: 8] /modules/paypal/paypal.php:341 (__construct) [id: 8] /modules/gmerchantcenterpro/lib/moduleTools.php:211 (__construct) [id: 8] /modules/gmerchantcenterpro/lib/moduleTools.php:211 (__construct) [id: 8] /modules/gmerchantcenterpro/lib/moduleTools.php:211 (__construct) [id: 8] /modules/gmerchantcenterpro/lib/moduleTools.php:211 (__construct) [id: 8] /modules/gmerchantcenterpro/lib/moduleTools.php:211 (__construct) [id: 8] /modules/gmerchantcenterpro/lib/moduleTools.php:211 (__construct) [id: 8] /modules/gmerchantcenterpro/lib/moduleTools.php:211 (__construct) [id: 8] /modules/gmerchantcenterpro/lib/moduleTools.php:211 (__construct) [id: 19] /modules/gmerchantcenterpro/lib/moduleTools.php:211 (__construct) [id: 4] /modules/gmerchantcenterpro/lib/moduleTools.php:211 (__construct) [id: 3] /modules/gmerchantcenterpro/lib/moduleTools.php:211 (__construct) [id: 188] /classes/AddressFormat.php:404 (__construct) [id: 8] /modules/ps_contactinfo/ps_contactinfo.php:104 (__construct) [id: 8] /classes/AddressFormat.php:404 (__construct) [id: 8] /modules/ps_contactinfo/ps_contactinfo.php:104 (__construct) [id: 8]
Language	13	/config/config.inc.php:211 (__construct) [id: 1] /classes/Tools.php:560 (__construct) [id: 1] /modules/gmerchantcenterpro/lib/moduleTools.php:206 (__construct) [id: 1] /modules/gmerchantcenterpro/lib/moduleTools.php:206 (__construct) [id: 1] /modules/gmerchantcenterpro/lib/moduleTools.php:206 (__construct) [id: 1] /modules/gmerchantcenterpro/lib/moduleTools.php:206 (__construct) [id: 1] /modules/gmerchantcenterpro/lib/moduleTools.php:206 (__construct) [id: 1] /modules/gmerchantcenterpro/lib/moduleTools.php:206 (__construct) [id: 1] /modules/gmerchantcenterpro/lib/moduleTools.php:206 (__construct) [id: 1] /modules/gmerchantcenterpro/lib/moduleTools.php:206 (__construct) [id: 1] /modules/gmerchantcenterpro/lib/moduleTools.php:206 (__construct) [id: 1] /modules/gmerchantcenterpro/lib/moduleTools.php:206 (__construct) [id: 1] /modules/gmerchantcenterpro/lib/moduleTools.php:206 (__construct) [id: 1]
Currency	12	/src/Adapter/Currency/CurrencyDataProvider.php:101 (__construct) [id: 1] /classes/Tools.php:695 (getCurrencyInstance) [id: 1] /modules/gmerchantcenterpro/lib/moduleTools.php:216 (__construct) [id: 1] /modules/gmerchantcenterpro/lib/moduleTools.php:216 (__construct) [id: 0] /modules/gmerchantcenterpro/lib/moduleTools.php:216 (__construct) [id: 0] /modules/gmerchantcenterpro/lib/moduleTools.php:216 (__construct) [id: 0] /modules/gmerchantcenterpro/lib/moduleTools.php:216 (__construct) [id: 0] /modules/gmerchantcenterpro/lib/moduleTools.php:216 (__construct) [id: 0] /modules/gmerchantcenterpro/lib/moduleTools.php:216 (__construct) [id: 0] /modules/gmerchantcenterpro/lib/moduleTools.php:216 (__construct) [id: 0] /modules/gmerchantcenterpro/lib/moduleTools.php:216 (__construct) [id: 0] /modules/gmerchantcenterpro/lib/moduleTools.php:216 (__construct) [id: 1]
Tax	4	/classes/tax/TaxRulesTaxManager.php:116 (__construct) [id: 1] /classes/tax/TaxRulesTaxManager.php:116 (__construct) [id: 1] /classes/tax/TaxRulesTaxManager.php:116 (__construct) [id: 3] /classes/tax/TaxRulesTaxManager.php:116 (__construct) [id: 3]
Address	4	/classes/shop/Shop.php:486 (__construct) [id: ] /classes/Product.php:3694 (initialize) [id: ] /classes/Product.php:3804 (__construct) [id: ] /classes/Product.php:5960 (__construct) [id: ]
AddressFormat	3	/classes/controller/FrontController.php:1761 (generateAddress) [id: ] /modules/ps_contactinfo/ps_contactinfo.php:98 (generateAddress) [id: ] /modules/ps_contactinfo/ps_contactinfo.php:98 (generateAddress) [id: ]
State	3	/classes/controller/FrontController.php:1766 (__construct) [id: 0] /modules/ps_contactinfo/ps_contactinfo.php:93 (__construct) [id: 0] /modules/ps_contactinfo/ps_contactinfo.php:93 (__construct) [id: 0]
Cart	2	/classes/controller/FrontController.php:467 (__construct) [id: ] /classes/controller/FrontController.php:541 (__construct) [id: ]
Shop	1	/config/config.inc.php:117 (initialize) [id: 2]
CategoriesClass	1	/modules/prestablog/prestablog.php:8127 (__construct) [id: 0]
Connection	1	/modules/statsdata/statsdata.php:118 (setPageConnection) [id: ]
Guest	1	/modules/statsdata/statsdata.php:82 (setNewGuest) [id: ]
TvcmsMegaMenuClass	1	/modules/tvcmsmegamenu/tvcmsmegamenu.php:1384 (__construct) [id: ]
Risk	1	/classes/controller/FrontController.php:1694 (__construct) [id: ]
NewsClass	1	/modules/prestablog/prestablog.php:8126 (__construct) [id: 0]
Gender	1	/classes/controller/FrontController.php:1691 (__construct) [id: 0]
Group	1	/classes/Cart.php:249 (getCurrent) [id: 1]
PosCarrier	1	/classes/Carrier.php:186 (__construct) [id: 721]
Customer	1	/config/config.inc.php:264 (__construct) [id: ]
ShopGroup	1	/classes/shop/Shop.php:561 (__construct) [id: 1]
ConnectionsSource	1	/modules/statsdata/statsdata.php:119 (logHttpReferer) [id: ]

Module	Time	Memory Usage
hspointofsalepro	79.920 ms	0.51 Mb
__construct	79.897 ms	0.50 Mb
hookModuleRoutes	0.023 ms	- Mb
faqs	4.222 ms	0.03 Mb
__construct	2.131 ms	0.02 Mb
hookModuleRoutes	0.010 ms	- Mb
hookHeader	2.081 ms	0.01 Mb
prestablog	4.716 ms	0.10 Mb
__construct	2.042 ms	0.05 Mb
hookModuleRoutes	0.024 ms	0.01 Mb
hookDisplayHeader	2.650 ms	0.04 Mb
doofinder	2.871 ms	0.02 Mb
__construct	1.911 ms	0.01 Mb
hookModuleRoutes	0.006 ms	- Mb
hookHeader	0.954 ms	0.01 Mb
ets_productmanager	1.487 ms	0.13 Mb
__construct	1.481 ms	0.13 Mb
hookActionDispatcherBefore	0.006 ms	- Mb
freelivery	1.549 ms	0.05 Mb
__construct	1.543 ms	0.04 Mb
hookActionFrontControllerAfterInit	0.006 ms	- Mb
ps_emailsubscription	2.716 ms	0.13 Mb
__construct	0.169 ms	0.01 Mb
hookActionFrontControllerSetMedia	0.608 ms	- Mb
displayNewslettersubscription	1.939 ms	0.12 Mb
ps_emailalerts	0.631 ms	0.01 Mb
__construct	0.219 ms	0.01 Mb
hookActionFrontControllerSetMedia	0.412 ms	- Mb
ps_socialfollow	2.457 ms	0.07 Mb
__construct	0.157 ms	0.01 Mb
hookActionFrontControllerSetMedia	0.291 ms	- Mb
displaySocialMediaBlock	2.009 ms	0.07 Mb
paybox	3.748 ms	0.17 Mb
__construct	3.731 ms	0.17 Mb
hookActionFrontControllerSetMedia	0.017 ms	- Mb
relaiscolis	1.181 ms	0.10 Mb
__construct	0.900 ms	0.10 Mb
hookHeader	0.281 ms	- Mb
stripe_official	1.806 ms	0.10 Mb
__construct	1.787 ms	0.10 Mb

#	Query	Time (ms)	Rows	Filesort	Group By	Location
204	SELECT SQL_NO_CACHE p.id_manufacturer, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM boutiqcookam_product p LEFT JOIN boutiqcookam_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN boutiqcookam_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN boutiqcookam_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_group = 1 AND sa.id_shop = 0 ) LEFT JOIN boutiqcookam_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN boutiqcookam_category_product cp ON (p.id_product = cp.id_product) INNER JOIN boutiqcookam_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 2 AND ps.active = TRUE) INNER JOIN boutiqcookam_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN boutiqcookam_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='2' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=13 AND c.nright<=102 GROUP BY p.id_product) p GROUP BY p.id_manufacturer	44.415 ms	2160900	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:778 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:661 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:146 (getManufacturersBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
202	SELECT SQL_NO_CACHE COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM boutiqcookam_product p LEFT JOIN boutiqcookam_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN boutiqcookam_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN boutiqcookam_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_group = 1 AND sa.id_shop = 0 ) LEFT JOIN boutiqcookam_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN boutiqcookam_category_product cp ON (p.id_product = cp.id_product) INNER JOIN boutiqcookam_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 2 AND ps.active = TRUE) INNER JOIN boutiqcookam_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN boutiqcookam_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='2' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND p.id_manufacturer IN (4, 27, 2) AND c.nleft>=13 AND c.nright<=102 GROUP BY p.id_product) p LEFT JOIN boutiqcookam_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN boutiqcookam_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN boutiqcookam_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_group = 1 AND sa.id_shop = 0 ) WHERE ((sa.quantity>0))	26.159 ms	2160900			/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:778 (execute) /modules/ps_facetedsearch/src/Adapter/MySQL.php:757 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:505 (count) /modules/ps_facetedsearch/src/Filters/Block.php:140 (getAvailabilitiesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
2	SELECT SQL_NO_CACHE c.`name`, cl.`id_lang`, IF(cl.`id_lang` IS NULL, c.`value`, cl.`value`) AS value, c.id_shop_group, c.id_shop FROM `boutiqcookam_configuration` c LEFT JOIN `boutiqcookam_configuration_lang` cl ON (c.`id_configuration` = cl.`id_configuration`)	24.770 ms	22437			/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)
560	SELECT SQL_NO_CACHE p., product_shop., stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, pl.`description`, pl.`description_short`, pl.`link_rewrite`, pl.`meta_description`, pl.`meta_keywords`, pl.`meta_title`, pl.`name`, pl.`available_now`, pl.`available_later`, image_shop.`id_image` id_image, il.`legend`, m.`name` AS manufacturer_name, (DATEDIFF(product_shop.`date_add`, DATE_SUB( "2024-07-08 00:00:00", INTERVAL 60 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 `boutiqcookam_product` p INNER JOIN boutiqcookam_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 2) LEFT JOIN `boutiqcookam_product_lang` `pl` ON p.`id_product` = pl.`id_product` AND pl.`id_lang` = 1 AND pl.id_shop = 2 LEFT JOIN `boutiqcookam_image_shop` `image_shop` ON image_shop.`id_product` = p.`id_product` AND image_shop.cover=1 AND image_shop.id_shop=2 LEFT JOIN `boutiqcookam_image_lang` `il` ON image_shop.`id_image` = il.`id_image` AND il.`id_lang` = 1 LEFT JOIN `boutiqcookam_manufacturer` `m` ON m.`id_manufacturer` = p.`id_manufacturer` LEFT JOIN `boutiqcookam_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=2 LEFT JOIN boutiqcookam_stock_available stock ON (stock.id_product = `p`.id_product AND stock.id_product_attribute = 0 AND stock.id_shop_group = 1 AND stock.id_shop = 0 ) WHERE (product_shop.`active` = 1) AND (product_shop.`visibility` IN ("both", "catalog")) AND (DATEDIFF(product_shop.`date_add`, DATE_SUB( "2024-07-08 00:00:00", INTERVAL 60 DAY ) ) > 0) AND (EXISTS(SELECT 1 FROM `boutiqcookam_category_product` cp JOIN `boutiqcookam_category_group` cg ON (cp.id_category = cg.id_category AND cg.`id_group` =1) WHERE cp.`id_product` = p.`id_product`)) ORDER BY product_shop.`date_add` DESC LIMIT 4	23.874 ms	16621200	Yes		/classes/Product.php:3110 /modules/tvcmstabproducts/tvcmstabproducts.php:2763 (getNewProducts) /modules/tvcmsnewproducts/tvcmsnewproducts.php:157 (displayNewProducts) /modules/tvcmsnewproducts/tvcmsnewproducts.php:266 (showFrontSideResult) /classes/Hook.php:1077 (hookdisplayLeftColumn) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:418 (coreCallHook) /classes/Hook.php:983 (callHookOn) /config/smarty.config.inc.php:201 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/prod/smarty/compile/v1_electron_1layouts_layout_left_column_tpl/4a/5e/91/4a5e9110179653434b7fdb6f5599bdd5f4f189f1_2.file.layout-both-columns.tpl.php:192 (__call) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/v1_electron_1layouts_layout_left_column_tpl/4a/5e/91/4a5e9110179653434b7fdb6f5599bdd5f4f189f1_2.file.layout-both-columns.tpl.php:74 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_668b1ab91977f6_10914871) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/v1_electron_1layouts_layout_left_column_tpl/8a/80/d4/8a80d40a75953a42233b4ece578d094dc56170e3_2.file.layout-left-column.tpl.php:28 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_668b1ab90f27f6_86264371) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/v1_electron_1layouts_layout_left_column_tpl/03/60/e5/0360e54069c3f2afd0117e88c00883bc90fab3e6_2.file.product-list.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_668b1ab90cdf32_17043244) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/v1_electron_1layouts_layout_left_column_tpl/dd/eb/28/ddeb28f9b3bbcba35e2df3ae603ad875cd57d2d0_2.file.category.tpl.php:27 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_668b1ab90c94a9_64054825) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/controller/FrontController.php:760 (fetch) /classes/controller/FrontController.php:742 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
194	SELECT SQL_NO_CACHE p.id_product, sa.out_of_stock FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM boutiqcookam_product p LEFT JOIN boutiqcookam_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN boutiqcookam_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN boutiqcookam_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_group = 1 AND sa.id_shop = 0 ) LEFT JOIN boutiqcookam_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN boutiqcookam_category_product cp ON (p.id_product = cp.id_product) INNER JOIN boutiqcookam_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 2 AND ps.active = TRUE) INNER JOIN boutiqcookam_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN boutiqcookam_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='2' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND p.id_manufacturer IN (4, 27, 2) AND c.nleft>=13 AND c.nright<=102 GROUP BY p.id_product) p LEFT JOIN boutiqcookam_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN boutiqcookam_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN boutiqcookam_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_group = 1 AND sa.id_shop = 0 ) INNER JOIN boutiqcookam_category_product cp ON (p.id_product = cp.id_product) GROUP BY p.id_product ORDER BY IFNULL(p.quantity, 0) <= 0, IFNULL(p.quantity, 0) <= 0 AND FIELD(sa.out_of_stock, 1) DESC, p.position ASC, p.id_product DESC	23.763 ms	2160900	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)
201	SELECT SQL_NO_CACHE COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM boutiqcookam_product p LEFT JOIN boutiqcookam_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN boutiqcookam_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN boutiqcookam_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_group = 1 AND sa.id_shop = 0 ) LEFT JOIN boutiqcookam_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN boutiqcookam_category_product cp ON (p.id_product = cp.id_product) INNER JOIN boutiqcookam_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 2 AND ps.active = TRUE) INNER JOIN boutiqcookam_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN boutiqcookam_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='2' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND p.id_manufacturer IN (4, 27, 2) AND c.nleft>=13 AND c.nright<=102 GROUP BY p.id_product) p LEFT JOIN boutiqcookam_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN boutiqcookam_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN boutiqcookam_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_group = 1 AND sa.id_shop = 0 ) WHERE ((sa.out_of_stock=1) OR (sa.quantity>0))	23.020 ms	2160900			/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:778 (execute) /modules/ps_facetedsearch/src/Adapter/MySQL.php:757 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:494 (count) /modules/ps_facetedsearch/src/Filters/Block.php:140 (getAvailabilitiesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
206	SELECT SQL_NO_CACHE psi.price_min, MIN(price_min) as min, MAX(price_max) as max FROM boutiqcookam_product p INNER JOIN boutiqcookam_layered_price_index psi ON (psi.id_product = p.id_product AND psi.id_shop = 2 AND psi.id_currency = 1 AND psi.id_country = 8) INNER JOIN boutiqcookam_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 2 AND ps.active = TRUE) INNER JOIN boutiqcookam_category_product cp ON (p.id_product = cp.id_product) INNER JOIN boutiqcookam_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN boutiqcookam_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='2' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND p.id_manufacturer IN (4, 27, 2) AND c.nleft>=13 AND c.nright<=102	21.702 ms	1470			/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:57 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:250 (getMinMaxPriceValue) /modules/ps_facetedsearch/src/Filters/Block.php:131 (getPriceRangeBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
197	SELECT SQL_NO_CACHE cp.id_category, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM boutiqcookam_product p LEFT JOIN boutiqcookam_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN boutiqcookam_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN boutiqcookam_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_group = 1 AND sa.id_shop = 0 ) LEFT JOIN boutiqcookam_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN boutiqcookam_category_product cp ON (p.id_product = cp.id_product) INNER JOIN boutiqcookam_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 2 AND ps.active = TRUE) INNER JOIN boutiqcookam_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN boutiqcookam_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='2' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND p.id_manufacturer IN (4, 27, 2) AND c.nleft>=13 AND c.nright<=102 GROUP BY p.id_product) p INNER JOIN boutiqcookam_category_product cp ON (p.id_product = cp.id_product) INNER JOIN boutiqcookam_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN boutiqcookam_category_group cg ON (cg.id_category = c.id_category) WHERE cg.id_group='1' AND c.level_depth<=3 AND c.nleft>13 AND c.nright<102 GROUP BY cp.id_category	21.453 ms	2880	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:778 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:992 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:158 (getCategoriesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
205	SELECT SQL_NO_CACHE p.condition, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM boutiqcookam_product p LEFT JOIN boutiqcookam_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN boutiqcookam_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN boutiqcookam_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_group = 1 AND sa.id_shop = 0 ) LEFT JOIN boutiqcookam_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN boutiqcookam_category_product cp ON (p.id_product = cp.id_product) INNER JOIN boutiqcookam_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 2 AND ps.active = TRUE) INNER JOIN boutiqcookam_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN boutiqcookam_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='2' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND p.id_manufacturer IN (4, 27, 2) AND c.nleft>=13 AND c.nright<=102 GROUP BY p.id_product) p GROUP BY p.condition	20.708 ms	2160900	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:778 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:394 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:137 (getConditionsBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
200	SELECT SQL_NO_CACHE COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM boutiqcookam_product p LEFT JOIN boutiqcookam_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN boutiqcookam_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN boutiqcookam_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_group = 1 AND sa.id_shop = 0 ) LEFT JOIN boutiqcookam_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN boutiqcookam_category_product cp ON (p.id_product = cp.id_product) INNER JOIN boutiqcookam_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 2 AND ps.active = TRUE) INNER JOIN boutiqcookam_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN boutiqcookam_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='2' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND p.id_manufacturer IN (4, 27, 2) AND c.nleft>=13 AND c.nright<=102 GROUP BY p.id_product) p LEFT JOIN boutiqcookam_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN boutiqcookam_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN boutiqcookam_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_group = 1 AND sa.id_shop = 0 ) LEFT JOIN boutiqcookam_stock_available sa_1 ON (p.id_product = sa_1.id_product AND IFNULL(pac.id_product_attribute, 0) = sa_1.id_product_attribute AND sa_1.id_shop_group = 1 AND sa_1.id_shop = 0 ) WHERE ((sa.quantity<=0 AND sa_1.out_of_stock IN (0, 2)))	16.049 ms	2160900			/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:778 (execute) /modules/ps_facetedsearch/src/Adapter/MySQL.php:757 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:480 (count) /modules/ps_facetedsearch/src/Filters/Block.php:140 (getAvailabilitiesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
626	SELECT SQL_NO_CACHE p., product_shop., stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, pl.`description`, pl.`description_short`, pl.`available_now`, pl.`available_later`, IFNULL(product_attribute_shop.id_product_attribute, 0) id_product_attribute, pl.`link_rewrite`, pl.`meta_description`, pl.`meta_keywords`, pl.`meta_title`, pl.`name`, image_shop.`id_image` id_image, il.`legend`, m.`name` AS manufacturer_name, DATEDIFF( p.`date_add`, DATE_SUB( "2024-07-08 00:00:00", INTERVAL 60 DAY ) ) > 0 AS new FROM `boutiqcookam_product` p INNER JOIN boutiqcookam_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 2) LEFT JOIN `boutiqcookam_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=2) LEFT JOIN boutiqcookam_stock_available stock ON (stock.id_product = `p`.id_product AND stock.id_product_attribute = 0 AND stock.id_shop_group = 1 AND stock.id_shop = 0 ) LEFT JOIN `boutiqcookam_product_lang` pl ON ( p.`id_product` = pl.`id_product` AND pl.`id_lang` = 1 AND pl.id_shop = 2 ) LEFT JOIN `boutiqcookam_image_shop` image_shop ON (image_shop.`id_product` = p.`id_product` AND image_shop.cover=1 AND image_shop.id_shop=2) LEFT JOIN `boutiqcookam_image_lang` il ON (image_shop.`id_image` = il.`id_image` AND il.`id_lang` = 1) LEFT JOIN `boutiqcookam_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 (203, 210, 105, 601, 85, 144, 564, 913, 561, 381, 882, 773, 604, 191, 555, 405, 709, 710, 294, 397, 283, 2870, 2871, 2872, 2873, 2874, 2875, 2876, 2877, 2878, 2879, 2880, 2881, 2882, 2884, 2886, 2887, 2888, 2889, 2890, 2891, 2892, 2893, 1763, 1420, 224, 83, 143, 146, 282, 339, 572, 698, 863, 1710, 401, 80, 79, 3367, 3366, 3365, 1761, 1508, 3310, 2654, 557, 3471, 3472, 3462, 3461, 3424, 3423, 3402, 3302, 102, 2340, 2676, 3001, 2674, 3301, 2659, 3197, 3300, 3276, 3199, 2663, 3311, 2661, 2662, 3201, 1975, 371, 571, 670, 785, 829, 133, 370, 411, 418, 554, 707, 1372, 1775, 1776, 896, 1194, 772, 562, 3173, 2658, 861, 867, 1866, 1899, 1914, 2536, 426, 430, 1765, 1939, 1973, 2001, 2007, 2003, 74, 539, 680, 700, 704, 808, 2579, 2576, 2558, 1986, 1227, 3196, 3174, 899, 3202) AND EXISTS(SELECT 1 FROM `boutiqcookam_category_product` cp JOIN `boutiqcookam_category_group` cg ON (cp.id_category = cg.id_category AND cg.`id_group` =1) WHERE cp.`id_product` = p.`id_product`)	8.664 ms	140			/classes/Product.php:3393 /modules/tvcmstabproducts/tvcmstabproducts.php:2817 (getPricesDrop) /modules/tvcmsspecialproducts/tvcmsspecialproducts.php:157 (displaySpecialProducts) /modules/tvcmsspecialproducts/tvcmsspecialproducts.php:268 (showFrontSideResult) /classes/Hook.php:1077 (hookdisplayLeftColumn) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:418 (coreCallHook) /classes/Hook.php:983 (callHookOn) /config/smarty.config.inc.php:201 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/prod/smarty/compile/v1_electron_1layouts_layout_left_column_tpl/4a/5e/91/4a5e9110179653434b7fdb6f5599bdd5f4f189f1_2.file.layout-both-columns.tpl.php:192 (__call) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/v1_electron_1layouts_layout_left_column_tpl/4a/5e/91/4a5e9110179653434b7fdb6f5599bdd5f4f189f1_2.file.layout-both-columns.tpl.php:74 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_668b1ab91977f6_10914871) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/v1_electron_1layouts_layout_left_column_tpl/8a/80/d4/8a80d40a75953a42233b4ece578d094dc56170e3_2.file.layout-left-column.tpl.php:28 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_668b1ab90f27f6_86264371) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/v1_electron_1layouts_layout_left_column_tpl/03/60/e5/0360e54069c3f2afd0117e88c00883bc90fab3e6_2.file.product-list.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_668b1ab90cdf32_17043244) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/v1_electron_1layouts_layout_left_column_tpl/dd/eb/28/ddeb28f9b3bbcba35e2df3ae603ad875cd57d2d0_2.file.category.tpl.php:27 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_668b1ab90c94a9_64054825) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/controller/FrontController.php:760 (fetch) /classes/controller/FrontController.php:742 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
20	SELECT SQL_NO_CACHE * FROM `boutiqcookam_carrier_lang` WHERE `id_carrier` = 721 AND `id_shop` = 2	7.266 ms	16725			/src/Adapter/EntityMapper.php:79 /classes/ObjectModel.php:283 (load) /tools/profiling/ObjectModel.php:32 (__construct) /classes/Carrier.php:186 (__construct) /modules/hspointofsalepro/classes/setup/PosInstaller.php:549 (__construct) /modules/hspointofsalepro/hspointofsalepro.php:133 (installCarrier) :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:1235 (get) /tools/profiling/Module.php:35 (coreLoadModule) /classes/module/Module.php:1214 (coreLoadModule) /classes/Hook.php:966 (getInstanceByName) /classes/Dispatcher.php:606 (exec) /classes/Dispatcher.php:243 (loadRoutes) /classes/Dispatcher.php:201 (__construct) /index.php:28 (getInstance)
15	SELECT SQL_NO_CACHE h.`name` as hook, m.`id_module`, h.`id_hook`, m.`name` as module FROM `boutiqcookam_module` m INNER JOIN boutiqcookam_module_shop module_shop ON (module_shop.id_module = m.id_module AND module_shop.id_shop = 2 AND module_shop.enable_device & 1) INNER JOIN `boutiqcookam_hook_module` `hm` ON hm.`id_module` = m.`id_module` INNER JOIN `boutiqcookam_hook` `h` ON hm.`id_hook` = h.`id_hook` LEFT JOIN `boutiqcookam_module_group` `mg` ON mg.`id_module` = m.`id_module` WHERE (h.`name` != "paymentOptions") AND (hm.`id_shop` = 2) AND (mg.id_shop = 2 AND mg.`id_group` IN (1)) GROUP BY hm.id_hook, hm.id_module ORDER BY hm.`position`	7.221 ms	2898	Yes	Yes	/classes/Hook.php:1267 /classes/Hook.php:735 (getAllHookRegistrations) /classes/Hook.php:842 (getHookModuleExecList) /classes/Dispatcher.php:606 (exec) /classes/Dispatcher.php:243 (loadRoutes) /classes/Dispatcher.php:201 (__construct) /index.php:28 (getInstance)
1494	SELECT SQL_NO_CACHE p., product_shop., stock.out_of_stock, IFNULL(stock.quantity, 0) AS quantity, IFNULL(product_attribute_shop.id_product_attribute, 0) AS id_product_attribute, product_attribute_shop.minimal_quantity AS product_attribute_minimal_quantity, pl.`description`, pl.`description_short`, pl.`available_now`, pl.`available_later`, pl.`link_rewrite`, pl.`meta_description`, pl.`meta_keywords`, pl.`meta_title`, pl.`name`, image_shop.`id_image` id_image, il.`legend` as legend, m.`name` AS manufacturer_name, cl.`name` AS category_default, DATEDIFF(product_shop.`date_add`, DATE_SUB("2024-07-08 00:00:00", INTERVAL 60 DAY)) > 0 AS new, product_shop.price AS orderprice FROM `boutiqcookam_category_product` cp LEFT JOIN `boutiqcookam_product` p ON p.`id_product` = cp.`id_product` INNER JOIN boutiqcookam_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 2) LEFT JOIN `boutiqcookam_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=2) LEFT JOIN boutiqcookam_stock_available stock ON (stock.id_product = `p`.id_product AND stock.id_product_attribute = 0 AND stock.id_shop_group = 1 AND stock.id_shop = 0 ) LEFT JOIN `boutiqcookam_category_lang` cl ON (product_shop.`id_category_default` = cl.`id_category` AND cl.`id_lang` = 1 AND cl.id_shop = 2 ) LEFT JOIN `boutiqcookam_product_lang` pl ON (p.`id_product` = pl.`id_product` AND pl.`id_lang` = 1 AND pl.id_shop = 2 ) LEFT JOIN `boutiqcookam_image_shop` image_shop ON (image_shop.`id_product` = p.`id_product` AND image_shop.cover=1 AND image_shop.id_shop=2) LEFT JOIN `boutiqcookam_image_lang` il ON (image_shop.`id_image` = il.`id_image` AND il.`id_lang` = 1) LEFT JOIN `boutiqcookam_manufacturer` m ON m.`id_manufacturer` = p.`id_manufacturer` WHERE product_shop.`id_shop` = 2 AND cp.`id_category` = 2 AND product_shop.`active` = 1 AND product_shop.`visibility` IN ("both", "catalog") ORDER BY RAND() LIMIT 4	5.725 ms	44	Yes		/classes/Category.php:1062 /src/Adapter/Category/CategoryProductSearchProvider.php:79 (getProducts) /src/Adapter/Category/CategoryProductSearchProvider.php:105 (getProductsOrCount) /modules/tvcmstabproducts/tvcmstabproducts.php:2708 (runQuery) /modules/tvcmsfeaturedproducts/tvcmsfeaturedproducts.php:158 (displayFeaturedProducts) /modules/tvcmsfeaturedproducts/tvcmsfeaturedproducts.php:281 (showFrontSideResult) /classes/Hook.php:1077 (hookdisplayLeftColumn) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:418 (coreCallHook) /classes/Hook.php:983 (callHookOn) /config/smarty.config.inc.php:201 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/prod/smarty/compile/v1_electron_1layouts_layout_left_column_tpl/4a/5e/91/4a5e9110179653434b7fdb6f5599bdd5f4f189f1_2.file.layout-both-columns.tpl.php:192 (__call) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/v1_electron_1layouts_layout_left_column_tpl/4a/5e/91/4a5e9110179653434b7fdb6f5599bdd5f4f189f1_2.file.layout-both-columns.tpl.php:74 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_668b1ab91977f6_10914871) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/v1_electron_1layouts_layout_left_column_tpl/8a/80/d4/8a80d40a75953a42233b4ece578d094dc56170e3_2.file.layout-left-column.tpl.php:28 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_668b1ab90f27f6_86264371) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/v1_electron_1layouts_layout_left_column_tpl/03/60/e5/0360e54069c3f2afd0117e88c00883bc90fab3e6_2.file.product-list.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_668b1ab90cdf32_17043244) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/v1_electron_1layouts_layout_left_column_tpl/dd/eb/28/ddeb28f9b3bbcba35e2df3ae603ad875cd57d2d0_2.file.category.tpl.php:27 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_668b1ab90c94a9_64054825) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/controller/FrontController.php:760 (fetch) /classes/controller/FrontController.php:742 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
517	SELECT SQL_NO_CACHE c., cl. FROM `boutiqcookam_category` c INNER JOIN boutiqcookam_category_shop category_shop ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 2) LEFT JOIN `boutiqcookam_category_lang` cl ON c.`id_category` = cl.`id_category` AND cl.id_shop = 2 WHERE 1 AND `id_lang` = 1 AND c.`active` = 1 ORDER BY c.`level_depth` ASC , category_shop.`position` ASC	5.563 ms	192	Yes		/classes/Category.php:799 /modules/tvcmssearch/tvcmssearch.php:102 (getNestedCategories) /modules/tvcmssearch/tvcmssearch.php:213 (getAllCategories) /classes/Hook.php:1077 (hookdisplayNavSearchBlock) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:418 (coreCallHook) /classes/Hook.php:983 (callHookOn) /config/smarty.config.inc.php:201 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/prod/smarty/compile/v1_electron_1layouts_layout_left_column_tpl/f2/8a/9b/f28a9b8919b5708b74cd7be964cffc12df166983_2.file.desk-header-1.tpl.php:33 (__call) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_668b1ab922ef03_52807559) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /var/cache/prod/smarty/compile/v1_electron_1layouts_layout_left_column_tpl/6f/05/a1/6f05a1153e4cd6ce54286f0367d722add7fc4e16_2.file.desktop-header.tpl.php:25 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_668b1ab92013c9_34178463) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /var/cache/prod/smarty/compile/v1_electron_1layouts_layout_left_column_tpl/1b/81/f6/1b81f61b5053621bcbdb1a5ce4f8b67994f196e8_2.file.header.tpl.php:55 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/v1_electron_1layouts_layout_left_column_tpl/1b/81/f6/1b81f61b5053621bcbdb1a5ce4f8b67994f196e8_2.file.header.tpl.php:29 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_668b1ab91f1579_89440546) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /var/cache/prod/smarty/compile/v1_electron_1layouts_layout_left_column_tpl/4a/5e/91/4a5e9110179653434b7fdb6f5599bdd5f4f189f1_2.file.layout-both-columns.tpl.php:144 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/v1_electron_1layouts_layout_left_column_tpl/4a/5e/91/4a5e9110179653434b7fdb6f5599bdd5f4f189f1_2.file.layout-both-columns.tpl.php:64 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_668b1ab91977f6_10914871) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/v1_electron_1layouts_layout_left_column_tpl/8a/80/d4/8a80d40a75953a42233b4ece578d094dc56170e3_2.file.layout-left-column.tpl.php:28 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_668b1ab90f27f6_86264371) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/v1_electron_1layouts_layout_left_column_tpl/03/60/e5/0360e54069c3f2afd0117e88c00883bc90fab3e6_2.file.product-list.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_668b1ab90cdf32_17043244) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/v1_electron_1layouts_layout_left_column_tpl/dd/eb/28/ddeb28f9b3bbcba35e2df3ae603ad875cd57d2d0_2.file.category.tpl.php:27 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_668b1ab90c94a9_64054825) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/controller/FrontController.php:760 (fetch) /classes/controller/FrontController.php:742 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
222	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 `boutiqcookam_hook_module` hm STRAIGHT_JOIN `boutiqcookam_hook` h ON (h.id_hook = hm.id_hook AND hm.id_shop = 2) STRAIGHT_JOIN `boutiqcookam_module` as m ON (m.id_module = hm.id_module) ORDER BY hm.position	3.760 ms	891			/classes/Hook.php:456 /classes/Hook.php:493 (getHookModuleList) /classes/tax/TaxManagerFactory.php:67 (getModulesFromHook) /classes/tax/TaxManagerFactory.php:46 (execHookTaxManagerFactory) /classes/Product.php:3925 (getManager) /classes/Product.php:3717 (priceCalculation) /classes/Product.php:5688 (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)
107	SHOW TABLES LIKE "boutiqcookam_gmcp_1800"	2.746 ms	1			/modules/gmerchantcenterpro/lib/moduleUpdate.php:88 :undefined (updateTables) /modules/gmerchantcenterpro/lib/moduleUpdate.php:61 (call_user_func_array) /modules/gmerchantcenterpro/lib/moduleTools.php:193 (run) /modules/gmerchantcenterpro/gmerchantcenterpro.php:197 (getLangCurrencyCountry) :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:1235 (get) /tools/profiling/Module.php:35 (coreLoadModule) /classes/module/Module.php:1214 (coreLoadModule) /classes/Hook.php:966 (getInstanceByName) /classes/controller/FrontController.php:622 (exec) /controllers/front/listing/CategoryController.php:127 (initContent) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
114	SHOW TABLES LIKE "boutiqcookam_gmcp_1900"	2.400 ms	1			/modules/gmerchantcenterpro/lib/moduleUpdate.php:88 :undefined (updateTables) /modules/gmerchantcenterpro/lib/moduleUpdate.php:61 (call_user_func_array) /modules/gmerchantcenterpro/lib/moduleTools.php:193 (run) /modules/gmerchantcenterpro/gmerchantcenterpro.php:197 (getLangCurrencyCountry) :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:1235 (get) /tools/profiling/Module.php:35 (coreLoadModule) /classes/module/Module.php:1214 (coreLoadModule) /classes/Hook.php:966 (getInstanceByName) /classes/controller/FrontController.php:622 (exec) /controllers/front/listing/CategoryController.php:127 (initContent) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
76	SELECT SQL_NO_CACHE * FROM `boutiqcookam_cart_rule` cr LEFT JOIN `boutiqcookam_cart_rule_lang` crl ON (cr.`id_cart_rule` = crl.`id_cart_rule` AND crl.`id_lang` = 1) WHERE (cr.`id_customer` = 0) AND NOW() BETWEEN cr.date_from AND cr.date_to AND cr.`active` = 1 AND free_shipping = 1 AND carrier_restriction = 1	2.233 ms	135			/classes/CartRule.php:423 /classes/Cart.php:3067 (getCustomerCartRules) /classes/Cart.php:3451 (getDeliveryOptionList) /classes/Cart.php:3524 (getDeliveryOption) /src/Core/Cart/Fees.php:96 (getTotalShippingCost) /src/Core/Cart/Calculator.php:354 (processCalculation) /src/Core/Cart/Calculator.php:155 (calculateFees) /classes/Cart.php:2189 (processCalculation) /src/Adapter/Presenter/Cart/CartPresenter.php:334 (getOrderTotal) /classes/controller/FrontController.php:545 (present) /classes/controller/FrontController.php:614 (assignGeneralPurposeVariables) /controllers/front/listing/CategoryController.php:127 (initContent) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
221	SELECT SQL_NO_CACHE `id_hook`, `name` FROM `boutiqcookam_hook` UNION SELECT `id_hook`, ha.`alias` as name FROM `boutiqcookam_hook_alias` ha INNER JOIN `boutiqcookam_hook` h ON ha.name = h.name	2.146 ms	0			/classes/Hook.php:1326 /classes/Hook.php:225 (getAllHookIds) /classes/tax/TaxManagerFactory.php:67 (getIdByName) /classes/tax/TaxManagerFactory.php:46 (execHookTaxManagerFactory) /classes/Product.php:3925 (getManager) /classes/Product.php:3717 (priceCalculation) /classes/Product.php:5688 (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)
47	SELECT SQL_NO_CACHE c.*, cl.`id_lang`, cl.`name`, cl.`description`, cl.`additional_description`, cl.`link_rewrite`, cl.`meta_title`, cl.`meta_keywords`, cl.`meta_description` FROM `boutiqcookam_category` c INNER JOIN boutiqcookam_category_shop category_shop ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 2) LEFT JOIN `boutiqcookam_category_lang` cl ON (c.`id_category` = cl.`id_category` AND `id_lang` = 1 AND cl.id_shop = 2 ) LEFT JOIN `boutiqcookam_category_group` cg ON (cg.`id_category` = c.`id_category`) WHERE `id_parent` = 12 AND `active` = 1 AND cg.`id_group` =1 GROUP BY c.`id_category` ORDER BY `level_depth` ASC, category_shop.`position` ASC	1.878 ms	27	Yes	Yes	/classes/Category.php:924 /controllers/front/listing/CategoryController.php:230 (getSubCategories) /controllers/front/listing/CategoryController.php:118 (getTemplateVarSubCategories) /tools/profiling/Controller.php:41 (init) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
559	SELECT SQL_NO_CACHE c.id_parent, c.id_category, cl.name, cl.description, cl.link_rewrite FROM `boutiqcookam_category` c INNER JOIN `boutiqcookam_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.`id_lang` = 1 AND cl.id_shop = 2 ) INNER JOIN `boutiqcookam_category_shop` cs ON (cs.`id_category` = c.`id_category` AND cs.`id_shop` = 2) WHERE (c.`active` = 1 OR c.`id_category` = 2) AND c.`id_category` != 1 AND `level_depth` <= 6 AND nleft >= 13 AND nright <= 102 AND c.id_category IN ( SELECT id_category FROM `boutiqcookam_category_group` WHERE `id_group` IN (1) ) ORDER BY `level_depth` ASC, cs.`position` ASC	1.837 ms	191	Yes		/modules/ps_categorytree/ps_categorytree.php:166 /modules/ps_categorytree/ps_categorytree.php:350 (getCategories) /modules/ps_categorytree/ps_categorytree.php:330 (getWidgetVariables) /classes/Hook.php:1088 (renderWidget) /tools/profiling/Hook.php:64 (coreRenderWidget) /classes/Hook.php:1019 (coreRenderWidget) /config/smarty.config.inc.php:201 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/prod/smarty/compile/v1_electron_1layouts_layout_left_column_tpl/4a/5e/91/4a5e9110179653434b7fdb6f5599bdd5f4f189f1_2.file.layout-both-columns.tpl.php:192 (__call) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/v1_electron_1layouts_layout_left_column_tpl/4a/5e/91/4a5e9110179653434b7fdb6f5599bdd5f4f189f1_2.file.layout-both-columns.tpl.php:74 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_668b1ab91977f6_10914871) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/v1_electron_1layouts_layout_left_column_tpl/8a/80/d4/8a80d40a75953a42233b4ece578d094dc56170e3_2.file.layout-left-column.tpl.php:28 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_668b1ab90f27f6_86264371) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/v1_electron_1layouts_layout_left_column_tpl/03/60/e5/0360e54069c3f2afd0117e88c00883bc90fab3e6_2.file.product-list.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_668b1ab90cdf32_17043244) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/v1_electron_1layouts_layout_left_column_tpl/dd/eb/28/ddeb28f9b3bbcba35e2df3ae603ad875cd57d2d0_2.file.category.tpl.php:27 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_668b1ab90c94a9_64054825) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/controller/FrontController.php:760 (fetch) /classes/controller/FrontController.php:742 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
625	SELECT SQL_NO_CACHE `id_product`, `id_product_attribute` FROM `boutiqcookam_specific_price` WHERE `id_shop` IN (0, 2) AND `id_currency` IN (0, 1) AND `id_country` IN (0, 8) AND `id_group` IN (0, 1) AND `from_quantity` = 1 AND `reduction` > 0 AND `id_customer` = 0 AND `id_cart` = 0 AND (`from` = '0000-00-00 00:00:00' OR '2024-07-08 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-07-08 00:00:00' <= `to`)	1.812 ms	384			/classes/SpecificPrice.php:715 /classes/Product.php:3149 (getProductIdByDate) /classes/Product.php:3308 (_getProductIdByDate) /modules/tvcmstabproducts/tvcmstabproducts.php:2817 (getPricesDrop) /modules/tvcmsspecialproducts/tvcmsspecialproducts.php:157 (displaySpecialProducts) /modules/tvcmsspecialproducts/tvcmsspecialproducts.php:268 (showFrontSideResult) /classes/Hook.php:1077 (hookdisplayLeftColumn) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:418 (coreCallHook) /classes/Hook.php:983 (callHookOn) /config/smarty.config.inc.php:201 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/prod/smarty/compile/v1_electron_1layouts_layout_left_column_tpl/4a/5e/91/4a5e9110179653434b7fdb6f5599bdd5f4f189f1_2.file.layout-both-columns.tpl.php:192 (__call) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/v1_electron_1layouts_layout_left_column_tpl/4a/5e/91/4a5e9110179653434b7fdb6f5599bdd5f4f189f1_2.file.layout-both-columns.tpl.php:74 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_668b1ab91977f6_10914871) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/v1_electron_1layouts_layout_left_column_tpl/8a/80/d4/8a80d40a75953a42233b4ece578d094dc56170e3_2.file.layout-left-column.tpl.php:28 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_668b1ab90f27f6_86264371) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/v1_electron_1layouts_layout_left_column_tpl/03/60/e5/0360e54069c3f2afd0117e88c00883bc90fab3e6_2.file.product-list.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_668b1ab90cdf32_17043244) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/v1_electron_1layouts_layout_left_column_tpl/dd/eb/28/ddeb28f9b3bbcba35e2df3ae603ad875cd57d2d0_2.file.category.tpl.php:27 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_668b1ab90c94a9_64054825) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/controller/FrontController.php:760 (fetch) /classes/controller/FrontController.php:742 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
208	SELECT SQL_NO_CACHE pac.id_attribute, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM boutiqcookam_product p LEFT JOIN boutiqcookam_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN boutiqcookam_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN boutiqcookam_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_group = 1 AND sa.id_shop = 0 ) LEFT JOIN boutiqcookam_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN boutiqcookam_category_product cp ON (p.id_product = cp.id_product) INNER JOIN boutiqcookam_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 2 AND ps.active = TRUE) INNER JOIN boutiqcookam_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN boutiqcookam_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='2' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND p.id_manufacturer IN (4, 27, 2) AND c.nleft>=13 AND c.nright<=102 GROUP BY p.id_product) p LEFT JOIN boutiqcookam_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN boutiqcookam_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) INNER JOIN boutiqcookam_attribute a ON (a.id_attribute = pac.id_attribute) WHERE ((a.id_attribute_group=1)) GROUP BY pac.id_attribute	1.674 ms	178			/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:778 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:737 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:150 (getAttributesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
75	SELECT SQL_NO_CACHE 1 FROM `boutiqcookam_cart_rule` WHERE ((date_to >= "2024-07-08 00:00:00" AND date_to <= "2024-07-08 23:59:59") OR (date_from >= "2024-07-08 00:00:00" AND date_from <= "2024-07-08 23:59:59") OR (date_from < "2024-07-08 00:00:00" AND date_to > "2024-07-08 23:59:59")) AND `id_customer` IN (0,0) LIMIT 1	1.612 ms	510			/classes/CartRule.php:357 /classes/CartRule.php:389 (haveCartRuleToday) /classes/Cart.php:3067 (getCustomerCartRules) /classes/Cart.php:3451 (getDeliveryOptionList) /classes/Cart.php:3524 (getDeliveryOption) /src/Core/Cart/Fees.php:96 (getTotalShippingCost) /src/Core/Cart/Calculator.php:354 (processCalculation) /src/Core/Cart/Calculator.php:155 (calculateFees) /classes/Cart.php:2189 (processCalculation) /src/Adapter/Presenter/Cart/CartPresenter.php:334 (getOrderTotal) /classes/controller/FrontController.php:545 (present) /classes/controller/FrontController.php:614 (assignGeneralPurposeVariables) /controllers/front/listing/CategoryController.php:127 (initContent) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
77	SELECT SQL_NO_CACHE 1 FROM `boutiqcookam_cart_rule` WHERE ((date_to >= "2024-07-08 00:00:00" AND date_to <= "2024-07-08 23:59:59") OR (date_from >= "2024-07-08 00:00:00" AND date_from <= "2024-07-08 23:59:59") OR (date_from < "2024-07-08 00:00:00" AND date_to > "2024-07-08 23:59:59")) AND `id_customer` IN (0,0) LIMIT 1	1.595 ms	510			/classes/CartRule.php:357 /classes/CartRule.php:389 (haveCartRuleToday) /classes/CartRule.php:578 (getCustomerCartRules) /classes/Cart.php:522 (getCustomerHighlightedDiscounts) /src/Adapter/Presenter/Cart/CartPresenter.php:444 (getDiscounts) /classes/controller/FrontController.php:545 (present) /classes/controller/FrontController.php:614 (assignGeneralPurposeVariables) /controllers/front/listing/CategoryController.php:127 (initContent) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
14	SELECT SQL_NO_CACHE lower(name) as name FROM `boutiqcookam_hook` h WHERE (h.active = 1)	1.591 ms	1060			/classes/Hook.php:1366 /classes/Hook.php:811 (getHookStatusByName) /classes/Dispatcher.php:606 (exec) /classes/Dispatcher.php:243 (loadRoutes) /classes/Dispatcher.php:201 (__construct) /index.php:28 (getInstance)
207	SELECT SQL_NO_CACHE DISTINCT a.`id_attribute`, a.`color`, al.`name`, agl.`id_attribute_group`, IF(lialv.`url_name` IS NULL OR lialv.`url_name` = "", NULL, lialv.`url_name`) AS url_name, IF(lialv.`meta_title` IS NULL OR lialv.`meta_title` = "", NULL, lialv.`meta_title`) AS meta_title FROM `boutiqcookam_attribute_group` ag INNER JOIN `boutiqcookam_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1) INNER JOIN `boutiqcookam_attribute` a ON a.`id_attribute_group` = ag.`id_attribute_group` INNER JOIN `boutiqcookam_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1) INNER JOIN boutiqcookam_attribute_group_shop attribute_group_shop ON (attribute_group_shop.id_attribute_group = ag.id_attribute_group AND attribute_group_shop.id_shop = 2) INNER JOIN boutiqcookam_attribute_shop attribute_shop ON (attribute_shop.id_attribute = a.id_attribute AND attribute_shop.id_shop = 2) LEFT JOIN `boutiqcookam_layered_indexable_attribute_lang_value` lialv ON (a.`id_attribute` = lialv.`id_attribute` AND lialv.`id_lang` = 1) WHERE ag.id_attribute_group = 1 ORDER BY agl.`name` ASC, a.`position` ASC	1.574 ms	118	Yes		/modules/ps_facetedsearch/src/Filters/DataAccessor.php:96 /modules/ps_facetedsearch/src/Filters/Block.php:731 (getAttributes) /modules/ps_facetedsearch/src/Filters/Block.php:150 (getAttributesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
25	SELECT SQL_NO_CACHE m.page, ml.url_rewrite, ml.id_lang FROM `boutiqcookam_meta` m LEFT JOIN `boutiqcookam_meta_lang` ml ON (m.id_meta = ml.id_meta AND ml.id_shop = 2 ) ORDER BY LENGTH(ml.url_rewrite) DESC	1.556 ms	240	Yes		/classes/Dispatcher.php:654 /classes/Dispatcher.php:243 (loadRoutes) /classes/Dispatcher.php:201 (__construct) /index.php:28 (getInstance)
558	SELECT SQL_NO_CACHE c.*, cl.`id_lang`, cl.`name`, cl.`description`, cl.`additional_description`, cl.`link_rewrite`, cl.`meta_title`, cl.`meta_keywords`, cl.`meta_description` FROM `boutiqcookam_category` c INNER JOIN boutiqcookam_category_shop category_shop ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 2) LEFT JOIN `boutiqcookam_category_lang` cl ON (c.`id_category` = cl.`id_category` AND `id_lang` = 12 AND cl.id_shop = 2 ) LEFT JOIN `boutiqcookam_category_group` cg ON (cg.`id_category` = c.`id_category`) WHERE `id_parent` = 12 AND `active` = 1 AND cg.`id_group` =1 GROUP BY c.`id_category` ORDER BY `level_depth` ASC, category_shop.`position` ASC	1.513 ms	27	Yes	Yes	/classes/Category.php:924 /modules/ps_categorytree/ps_categorytree.php:345 (getSubCategories) /modules/ps_categorytree/ps_categorytree.php:330 (getWidgetVariables) /classes/Hook.php:1088 (renderWidget) /tools/profiling/Hook.php:64 (coreRenderWidget) /classes/Hook.php:1019 (coreRenderWidget) /config/smarty.config.inc.php:201 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/prod/smarty/compile/v1_electron_1layouts_layout_left_column_tpl/4a/5e/91/4a5e9110179653434b7fdb6f5599bdd5f4f189f1_2.file.layout-both-columns.tpl.php:192 (__call) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/v1_electron_1layouts_layout_left_column_tpl/4a/5e/91/4a5e9110179653434b7fdb6f5599bdd5f4f189f1_2.file.layout-both-columns.tpl.php:74 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_668b1ab91977f6_10914871) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/v1_electron_1layouts_layout_left_column_tpl/8a/80/d4/8a80d40a75953a42233b4ece578d094dc56170e3_2.file.layout-left-column.tpl.php:28 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_668b1ab90f27f6_86264371) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/v1_electron_1layouts_layout_left_column_tpl/03/60/e5/0360e54069c3f2afd0117e88c00883bc90fab3e6_2.file.product-list.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_668b1ab90cdf32_17043244) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/v1_electron_1layouts_layout_left_column_tpl/dd/eb/28/ddeb28f9b3bbcba35e2df3ae603ad875cd57d2d0_2.file.category.tpl.php:27 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_668b1ab90c94a9_64054825) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/controller/FrontController.php:760 (fetch) /classes/controller/FrontController.php:742 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
212	SELECT SQL_NO_CACHE p., ps., pl.*, sa.out_of_stock, IFNULL(sa.quantity, 0) as quantity, (DATEDIFF( p.`date_add`, DATE_SUB( '2024-07-08 00:00:00', INTERVAL 60 DAY ) ) > 0) as new FROM boutiqcookam_product p LEFT JOIN boutiqcookam_product_lang pl ON pl.id_product = p.id_product AND pl.id_shop = 2 AND pl.id_lang = 1 LEFT JOIN boutiqcookam_stock_available sa ON sa.id_product = p.id_product AND sa.id_shop = 0 AND sa.id_product_attribute = 0 AND sa.id_shop_group = 1 LEFT JOIN boutiqcookam_product_shop ps ON ps.id_product = p.id_product AND ps.id_shop = 2 WHERE p.id_product IN (2732,3429,1777,1778,1837,3118,460,2488,3107,3109,3111,551,542,1780,128,2696,3223,3427,3108,541)	1.494 ms	20			/classes/ProductAssembler.php:95 /classes/ProductAssembler.php:203 (addMissingProductFieldsForMultipleProducts) /classes/controller/ProductListingFrontController.php:108 (assembleProducts) /classes/controller/ProductListingFrontController.php:379 (prepareMultipleProductsForTemplate) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
196	SELECT SQL_NO_CACHE c.`id_category`, cl.`name` FROM `boutiqcookam_category` c INNER JOIN boutiqcookam_category_shop category_shop ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 2) LEFT JOIN `boutiqcookam_category_lang` cl ON c.`id_category` = cl.`id_category` AND cl.id_shop = 2 WHERE 1 AND `id_lang` = 1 AND c.`active` = 1 ORDER BY c.nleft, c.position	1.475 ms	192	Yes		/classes/Category.php:724 /modules/ps_facetedsearch/src/Filters/Block.php:986 (getAllCategoriesName) /modules/ps_facetedsearch/src/Filters/Block.php:158 (getCategoriesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
150	SELECT SQL_NO_CACHE * FROM `boutiqcookam_gmcp_feeds` ff WHERE (ff.id_shop=2) ORDER BY ff.feed_is_default ASC	1.467 ms	740	Yes		/modules/gmerchantcenterpro/models/Feeds.php:101 /modules/gmerchantcenterpro/lib/moduleTools.php:199 (getAvailableFeeds) /modules/gmerchantcenterpro/gmerchantcenterpro.php:197 (getLangCurrencyCountry) :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:1235 (get) /tools/profiling/Module.php:35 (coreLoadModule) /classes/module/Module.php:1214 (coreLoadModule) /classes/Hook.php:966 (getInstanceByName) /classes/controller/FrontController.php:622 (exec) /controllers/front/listing/CategoryController.php:127 (initContent) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
199	SELECT SQL_NO_CACHE pac.id_attribute, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM boutiqcookam_product p LEFT JOIN boutiqcookam_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN boutiqcookam_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN boutiqcookam_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_group = 1 AND sa.id_shop = 0 ) LEFT JOIN boutiqcookam_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN boutiqcookam_category_product cp ON (p.id_product = cp.id_product) INNER JOIN boutiqcookam_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 2 AND ps.active = TRUE) INNER JOIN boutiqcookam_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN boutiqcookam_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='2' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND p.id_manufacturer IN (4, 27, 2) AND c.nleft>=13 AND c.nright<=102 GROUP BY p.id_product) p LEFT JOIN boutiqcookam_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN boutiqcookam_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) INNER JOIN boutiqcookam_attribute a ON (a.id_attribute = pac.id_attribute) WHERE ((a.id_attribute_group=2)) GROUP BY pac.id_attribute	1.441 ms	30	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:778 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:737 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:150 (getAttributesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
615	SELECT SQL_NO_CACHE p., ps., pl.*, sa.out_of_stock, IFNULL(sa.quantity, 0) as quantity, (DATEDIFF( p.`date_add`, DATE_SUB( '2024-07-08 00:00:00', INTERVAL 60 DAY ) ) > 0) as new FROM boutiqcookam_product p LEFT JOIN boutiqcookam_product_lang pl ON pl.id_product = p.id_product AND pl.id_shop = 2 AND pl.id_lang = 1 LEFT JOIN boutiqcookam_stock_available sa ON sa.id_product = p.id_product AND sa.id_shop = 0 AND sa.id_product_attribute = 0 AND sa.id_shop_group = 1 LEFT JOIN boutiqcookam_product_shop ps ON ps.id_product = p.id_product AND ps.id_shop = 2 WHERE p.id_product IN (3562)	1.345 ms	1			/classes/ProductAssembler.php:64 /classes/ProductAssembler.php:182 (addMissingProductFields) /modules/tvcmstabproducts/tvcmstabproducts.php:2796 (assembleProduct) /modules/tvcmsnewproducts/tvcmsnewproducts.php:157 (displayNewProducts) /modules/tvcmsnewproducts/tvcmsnewproducts.php:266 (showFrontSideResult) /classes/Hook.php:1077 (hookdisplayLeftColumn) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:418 (coreCallHook) /classes/Hook.php:983 (callHookOn) /config/smarty.config.inc.php:201 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/prod/smarty/compile/v1_electron_1layouts_layout_left_column_tpl/4a/5e/91/4a5e9110179653434b7fdb6f5599bdd5f4f189f1_2.file.layout-both-columns.tpl.php:192 (__call) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/v1_electron_1layouts_layout_left_column_tpl/4a/5e/91/4a5e9110179653434b7fdb6f5599bdd5f4f189f1_2.file.layout-both-columns.tpl.php:74 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_668b1ab91977f6_10914871) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/v1_electron_1layouts_layout_left_column_tpl/8a/80/d4/8a80d40a75953a42233b4ece578d094dc56170e3_2.file.layout-left-column.tpl.php:28 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_668b1ab90f27f6_86264371) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/v1_electron_1layouts_layout_left_column_tpl/03/60/e5/0360e54069c3f2afd0117e88c00883bc90fab3e6_2.file.product-list.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_668b1ab90cdf32_17043244) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/v1_electron_1layouts_layout_left_column_tpl/dd/eb/28/ddeb28f9b3bbcba35e2df3ae603ad875cd57d2d0_2.file.category.tpl.php:27 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_668b1ab90c94a9_64054825) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/controller/FrontController.php:760 (fetch) /classes/controller/FrontController.php:742 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
209	SELECT SQL_NO_CACHE fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM boutiqcookam_product p LEFT JOIN boutiqcookam_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN boutiqcookam_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN boutiqcookam_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_group = 1 AND sa.id_shop = 0 ) LEFT JOIN boutiqcookam_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN boutiqcookam_category_product cp ON (p.id_product = cp.id_product) INNER JOIN boutiqcookam_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 2 AND ps.active = TRUE) INNER JOIN boutiqcookam_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN boutiqcookam_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='2' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND p.id_manufacturer IN (4, 27, 2) AND c.nleft>=13 AND c.nright<=102 GROUP BY p.id_product) p INNER JOIN boutiqcookam_feature_product fp ON (p.id_product = fp.id_product) WHERE ((fp.id_feature=4)) GROUP BY fp.id_feature_value	1.222 ms	68	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:778 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:855 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:154 (getFeaturesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
210	SELECT SQL_NO_CACHE fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM boutiqcookam_product p LEFT JOIN boutiqcookam_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN boutiqcookam_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN boutiqcookam_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_group = 1 AND sa.id_shop = 0 ) LEFT JOIN boutiqcookam_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN boutiqcookam_category_product cp ON (p.id_product = cp.id_product) INNER JOIN boutiqcookam_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 2 AND ps.active = TRUE) INNER JOIN boutiqcookam_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN boutiqcookam_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='2' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND p.id_manufacturer IN (4, 27, 2) AND c.nleft>=13 AND c.nright<=102 GROUP BY p.id_product) p INNER JOIN boutiqcookam_feature_product fp ON (p.id_product = fp.id_product) WHERE ((fp.id_feature=5)) GROUP BY fp.id_feature_value	1.195 ms	74	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:778 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:855 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:154 (getFeaturesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
22	SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module`as `mshop` FROM `boutiqcookam_module` m LEFT JOIN `boutiqcookam_module_shop` ms ON m.`id_module` = ms.`id_module` AND ms.`id_shop` = 2	1.147 ms	214			/classes/module/Module.php:345 /modules/faqs/faqs.php:33 (__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:1235 (get) /tools/profiling/Module.php:35 (coreLoadModule) /classes/module/Module.php:1214 (coreLoadModule) /classes/Hook.php:966 (getInstanceByName) /classes/Dispatcher.php:606 (exec) /classes/Dispatcher.php:243 (loadRoutes) /classes/Dispatcher.php:201 (__construct) /index.php:28 (getInstance)
482	SELECT SQL_NO_CACHE * FROM `boutiqcookam_product` a LEFT JOIN `boutiqcookam_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1 LEFT JOIN `boutiqcookam_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 2 WHERE (a.`id_product` = 3109) AND (b.`id_shop` = 2) LIMIT 1	1.135 ms	1			/src/Adapter/EntityMapper.php:71 /classes/ObjectModel.php:283 (load) /tools/profiling/ObjectModel.php:32 (__construct) /classes/Product.php:725 (__construct) /src/Adapter/Image/ImageRetriever.php:80 (__construct) /src/Adapter/Presenter/Product/ProductLazyArray.php:688 (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)
421	SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity, COALESCE(SUM(first_level_quantity), 0) as quantity FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity FROM `boutiqcookam_cart_product` cp WHERE cp.`id_product_attribute` = 0 AND cp.`id_cart` = 0 AND cp.`id_product` = 3223 UNION SELECT 0 as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity FROM `boutiqcookam_cart_product` cp JOIN `boutiqcookam_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `boutiqcookam_product` pr ON p.`id_product_pack` = pr.`id_product` WHERE cp.`id_product_attribute` = 0 AND cp.`id_cart` = 0 AND p.`id_product_item` = 3223 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 1 = 1 ))) as q LIMIT 1	1.111 ms	0			/classes/Cart.php:1426 /classes/Product.php:4357 (getProductQuantity) /classes/Product.php:5798 (getQuantity) /classes/ProductAssembler.php:209 (getProductProperties) /classes/controller/ProductListingFrontController.php:108 (assembleProducts) /classes/controller/ProductListingFrontController.php:379 (prepareMultipleProductsForTemplate) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)

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

Panier

Emporte-pièces et Découpoirs

Emporte-pièce Hiboux

Emporte-pièce Hiboux

Emporte-pièce Hiboux

Emporte-pièce Hiboux

Emporte-pièce Chat Assis

Emporte-pièce Chat Assis

Emporte-pièce Chat Assis

Emporte-pièce Chat Assis

Emporte-pièce Patte de Lapin

Emporte-pièce Patte de Lapin

Emporte-pièce Patte de Lapin

Emporte-pièce Patte de Lapin

Emporte-pièce Tête de Mouton

Emporte-pièce Tête de Mouton

Emporte-pièce Tête de Mouton

Emporte-pièce Tête de Mouton

Emporte-pièce Ballerine

Emporte-pièce Ballerine

Emporte-pièce Ballerine

Emporte-pièce Ballerine

Emporte-pièce Rose avec empreinte

Emporte-pièce Rose avec empreinte

Emporte-pièce Rose avec empreinte

Emporte-pièce Rose avec empreinte

Emporte-pièce Bavoir Bébé

Emporte-pièce Bavoir Bébé

Emporte-pièce Bavoir Bébé

Emporte-pièce Bavoir Bébé

Emporte-pièce Couronne de Noël

Emporte-pièce Couronne de Noël

Emporte-pièce Couronne de Noël

Emporte-pièce Couronne de Noël

Emporte-pièce Oeuf de Pâques avec empreinte

Emporte-pièce Oeuf de Pâques avec empreinte

Emporte-pièce Oeuf de Pâques avec empreinte

Emporte-pièce Oeuf de Pâques avec empreinte

Emporte-pièce Oeuf avec noeud papillon

Emporte-pièce Oeuf avec noeud papillon

Emporte-pièce Oeuf avec noeud papillon

Emporte-pièce Oeuf avec noeud papillon

Emporte-pièce Lapin - 7,5 cm

Emporte-pièce Lapin - 7,5 cm

Emporte-pièce Lapin - 7,5 cm

Emporte-pièce Lapin - 7,5 cm

Lot de 3 Emporte-pièces Moustache

Lot de 3 Emporte-pièces Moustache

Lot de 3 Emporte-pièces Moustache

Lot de 3 Emporte-pièces Moustache

Emporte-pièces Crèche de Noël

Emporte-pièces Crèche de Noël

Emporte-pièces Crèche de Noël

Emporte-pièces Crèche de Noël

Emporte-pièce Glace

Emporte-pièce Glace

Emporte-pièce Glace

Emporte-pièce Glace

Emporte-pièce Goutte cannelée

Emporte-pièce Goutte cannelée

Emporte-pièce Goutte cannelée

Emporte-pièce Goutte cannelée

Emporte-pièce Yin Yang

Emporte-pièce Yin Yang

Emporte-pièce Yin Yang

Emporte-pièce Yin Yang

Emporte-pièce Eclair

Emporte-pièce Eclair

Emporte-pièce Eclair

Emporte-pièce Eclair

Emporte-pièce Tulipe - 6 cm

Emporte-pièce Tulipe - 6 cm

Emporte-pièce Tulipe - 6 cm

Emporte-pièce Tulipe - 6 cm

Emporte-pièce petit Agneau de Pâques

Emporte-pièce petit Agneau de Pâques

Emporte-pièce petit Agneau de Pâques

Emporte-pièce petit Agneau de Pâques

Emporte-pièces Village d'Hiver

Emporte-pièces Village d'Hiver