Smartphone & Mobile

24 products

Grid

Grid-2

List

List-2

Catelog

Trier par :

Nouveau

iPhone 14 - Ecran : 6,1" OLED Super Retina XDR HDR10, Dolby Vision Résolution : 1170 x 2532 pixels Système d'exploitation : iOS 16 Processeur : Puce A15 bionique (5 nm) Hexa-core(2x3.23 GHz Avalanche + 4x1.82 GHz Blizzard) GPU Graphics Apple 5 Coeurs RAM :...

3 699,000 TND

Load Time	2203 ms
Querying Time	720 ms
Queries	1247
Memory Peak Usage	39.4 Mb
Included Files	773 files - 9.43 Mb
PrestaShop Cache	- Mb
Global vars	0.12 Mb
- global $_MODULES	86k
- global $_MODULE	11k
- global $_SERVER	6k
- global $config	5k
- global $context	3k
- global $exportPhpConfigFile	3k
- global $smarty	2k
- global $_COOKIE	1k
- global $__composer_autoload_files	1k

PrestaShop Version	8.1.4
PHP Version	8.1.32
MySQL Version	10.11.11-MariaDB-0+deb12u1
Memory Limit	256M
Max Execution Time	300s
Smarty Cache	enabled
Smarty Compilation	never recompile

	Time	Cumulated Time	Memory Usage	Memory Peak Usage
config	0.004 ms	0.004 ms	1.92 Mb	2.0 Mb
__construct	0.550 ms	0.554 ms	0.07 Mb	2.5 Mb
init	14.286 ms	14.840 ms	0.51 Mb	2.9 Mb
checkAccess	0.001 ms	14.841 ms	- Mb	2.9 Mb
setMedia	2.501 ms	17.342 ms	0.23 Mb	2.9 Mb
postProcess	0.001 ms	17.343 ms	- Mb	2.9 Mb
initHeader	0.001 ms	17.344 ms	- Mb	2.9 Mb
initContent	332.093 ms	349.437 ms	6.36 Mb	9.4 Mb
initFooter	0.002 ms	349.439 ms	- Mb	9.4 Mb
display	1854 ms	2203 ms	29.37 Mb	39.4 Mb

Hook	Time	Memory Usage
DisplayLeftColumn	258.190 ms	5.33 Mb
=> tvcmsnewproducts	99.129 ms	1.90 Mb
=> tvcmsfeaturedproducts	136.685 ms	1.75 Mb
=> tvcmsbestsellerproducts	22.376 ms	1.68 Mb
DisplayNavFullWidth	186.442 ms	15.37 Mb
=> ets_megamenu	186.442 ms	15.37 Mb
DisplayReviewProductList	33.224 ms	3.79 Mb
=> tvcmsproductcomments	0.965 ms	0.11 Mb
=> tvcmsproductcomments	0.464 ms	0.07 Mb
=> tvcmsproductcomments	0.610 ms	0.07 Mb
=> tvcmsproductcomments	0.519 ms	0.07 Mb
=> tvcmsproductcomments	0.672 ms	0.10 Mb
=> tvcmsproductcomments	0.594 ms	0.07 Mb
=> tvcmsproductcomments	0.494 ms	0.07 Mb
=> tvcmsproductcomments	0.469 ms	0.07 Mb
=> tvcmsproductcomments	0.657 ms	0.11 Mb
=> tvcmsproductcomments	0.455 ms	0.07 Mb
=> tvcmsproductcomments	0.471 ms	0.07 Mb
=> tvcmsproductcomments	0.522 ms	0.07 Mb
=> tvcmsproductcomments	0.709 ms	0.10 Mb
=> tvcmsproductcomments	0.569 ms	0.07 Mb
=> tvcmsproductcomments	0.558 ms	0.07 Mb
=> tvcmsproductcomments	0.588 ms	0.07 Mb
=> tvcmsproductcomments	0.896 ms	0.10 Mb
=> tvcmsproductcomments	0.602 ms	0.07 Mb
=> tvcmsproductcomments	0.622 ms	0.07 Mb
=> tvcmsproductcomments	0.535 ms	0.07 Mb
=> tvcmsproductcomments	0.728 ms	0.11 Mb
=> tvcmsproductcomments	0.473 ms	0.07 Mb
=> tvcmsproductcomments	0.537 ms	0.07 Mb
=> tvcmsproductcomments	0.563 ms	0.07 Mb
=> tvcmsproductcomments	0.672 ms	0.11 Mb
=> tvcmsproductcomments	0.572 ms	0.07 Mb
=> tvcmsproductcomments	0.515 ms	0.07 Mb
=> tvcmsproductcomments	0.601 ms	0.07 Mb
=> tvcmsproductcomments	0.989 ms	0.11 Mb
=> tvcmsproductcomments	0.538 ms	0.07 Mb
=> tvcmsproductcomments	0.733 ms	0.07 Mb
=> tvcmsproductcomments	0.551 ms	0.07 Mb
=> tvcmsproductcomments	0.749 ms	0.11 Mb
=> tvcmsproductcomments	0.567 ms	0.07 Mb
=> tvcmsproductcomments	0.592 ms	0.07 Mb
=> tvcmsproductcomments	0.665 ms	0.07 Mb
=> tvcmsproductcomments	1.001 ms	0.11 Mb
=> tvcmsproductcomments	0.716 ms	0.07 Mb
=> tvcmsproductcomments	1.637 ms	0.07 Mb
=> tvcmsproductcomments	0.657 ms	0.07 Mb
=> tvcmsproductcomments	1.065 ms	0.10 Mb
=> tvcmsproductcomments	0.718 ms	0.07 Mb
=> tvcmsproductcomments	0.635 ms	0.07 Mb
=> tvcmsproductcomments	0.724 ms	0.07 Mb
=> tvcmsproductcomments	1.242 ms	0.10 Mb
=> tvcmsproductcomments	1.090 ms	0.07 Mb
=> tvcmsproductcomments	0.829 ms	0.07 Mb
=> tvcmsproductcomments	0.894 ms	0.07 Mb
DisplayHeader	7.094 ms	1.22 Mb
=> ps_shoppingcart	0.032 ms	- Mb
=> ps_searchbar	0.121 ms	- Mb
=> ps_googleanalytics	0.011 ms	- Mb
=> tvcmsbestsellerproducts	0.044 ms	- Mb
=> tvcmscategoryslider	0.054 ms	- Mb
=> tvcmscustomsetting	0.299 ms	0.01 Mb
=> tvcmsfeaturedproducts	0.035 ms	- Mb
=> tvcmsmultibanner1	0.072 ms	- Mb
=> tvcmsnewproducts	0.052 ms	- Mb
=> tvcmsproductcomments	0.203 ms	- Mb
=> tvcmsproductcompare	0.089 ms	- Mb
=> tvcmssearch	0.110 ms	- Mb
=> tvcmsslider	0.050 ms	- Mb
=> tvcmsthemeoptions	0.192 ms	- Mb
=> tvcmswishlist	0.107 ms	- Mb
=> ets_megamenu	5.623 ms	1.18 Mb
DisplayProductCompareProductList	5.680 ms	0.04 Mb
=> tvcmsproductcompare	0.185 ms	0.01 Mb
=> tvcmsproductcompare	0.145 ms	- Mb
=> tvcmsproductcompare	0.115 ms	- Mb
=> tvcmsproductcompare	0.085 ms	- Mb
=> tvcmsproductcompare	0.094 ms	- Mb
=> tvcmsproductcompare	0.086 ms	- Mb
=> tvcmsproductcompare	0.127 ms	- Mb
=> tvcmsproductcompare	0.087 ms	- Mb
=> tvcmsproductcompare	0.153 ms	- Mb
=> tvcmsproductcompare	0.125 ms	- Mb
=> tvcmsproductcompare	0.102 ms	- Mb
=> tvcmsproductcompare	0.129 ms	- Mb
=> tvcmsproductcompare	0.115 ms	- Mb
=> tvcmsproductcompare	0.088 ms	- Mb
=> tvcmsproductcompare	0.092 ms	- Mb
=> tvcmsproductcompare	0.087 ms	- Mb
=> tvcmsproductcompare	0.084 ms	- Mb
=> tvcmsproductcompare	0.082 ms	- Mb
=> tvcmsproductcompare	0.135 ms	- Mb
=> tvcmsproductcompare	0.131 ms	- Mb
=> tvcmsproductcompare	0.132 ms	- Mb
=> tvcmsproductcompare	0.116 ms	- Mb
=> tvcmsproductcompare	0.197 ms	- Mb
=> tvcmsproductcompare	0.109 ms	- Mb
=> tvcmsproductcompare	0.130 ms	- Mb
=> tvcmsproductcompare	0.129 ms	- Mb
=> tvcmsproductcompare	0.111 ms	- Mb
=> tvcmsproductcompare	0.114 ms	- Mb
=> tvcmsproductcompare	0.124 ms	- Mb
=> tvcmsproductcompare	0.113 ms	- Mb
=> tvcmsproductcompare	0.122 ms	- Mb
=> tvcmsproductcompare	0.125 ms	- Mb
=> tvcmsproductcompare	0.134 ms	- Mb
=> tvcmsproductcompare	0.110 ms	- Mb
=> tvcmsproductcompare	0.131 ms	- Mb
=> tvcmsproductcompare	0.103 ms	- Mb
=> tvcmsproductcompare	0.154 ms	- Mb
=> tvcmsproductcompare	0.118 ms	- Mb
=> tvcmsproductcompare	0.117 ms	- Mb
=> tvcmsproductcompare	0.108 ms	- Mb
=> tvcmsproductcompare	0.114 ms	- Mb
=> tvcmsproductcompare	0.111 ms	- Mb
=> tvcmsproductcompare	0.110 ms	- Mb
=> tvcmsproductcompare	0.114 ms	- Mb
=> tvcmsproductcompare	0.106 ms	- Mb
=> tvcmsproductcompare	0.117 ms	- Mb
=> tvcmsproductcompare	0.110 ms	- Mb
=> tvcmsproductcompare	0.154 ms	- Mb
DisplayWishlistBtnProductList	5.544 ms	0.05 Mb
=> tvcmswishlist	0.157 ms	0.01 Mb
=> tvcmswishlist	0.236 ms	- Mb
=> tvcmswishlist	0.097 ms	- Mb
=> tvcmswishlist	0.156 ms	- Mb
=> tvcmswishlist	0.088 ms	- Mb
=> tvcmswishlist	0.134 ms	- Mb
=> tvcmswishlist	0.087 ms	- Mb
=> tvcmswishlist	0.079 ms	- Mb
=> tvcmswishlist	0.096 ms	- Mb
=> tvcmswishlist	0.087 ms	- Mb
=> tvcmswishlist	0.112 ms	- Mb
=> tvcmswishlist	0.094 ms	- Mb
=> tvcmswishlist	0.096 ms	- Mb
=> tvcmswishlist	0.082 ms	- Mb
=> tvcmswishlist	0.144 ms	- Mb
=> tvcmswishlist	0.079 ms	- Mb
=> tvcmswishlist	0.078 ms	- Mb
=> tvcmswishlist	0.076 ms	- Mb
=> tvcmswishlist	0.128 ms	- Mb
=> tvcmswishlist	0.088 ms	- Mb
=> tvcmswishlist	0.111 ms	- Mb
=> tvcmswishlist	0.107 ms	- Mb
=> tvcmswishlist	0.117 ms	- Mb
=> tvcmswishlist	0.107 ms	- Mb
=> tvcmswishlist	0.115 ms	- Mb
=> tvcmswishlist	0.108 ms	- Mb
=> tvcmswishlist	0.157 ms	- Mb
=> tvcmswishlist	0.101 ms	- Mb
=> tvcmswishlist	0.111 ms	- Mb
=> tvcmswishlist	0.104 ms	- Mb
=> tvcmswishlist	0.122 ms	- Mb
=> tvcmswishlist	0.118 ms	- Mb
=> tvcmswishlist	0.148 ms	- Mb
=> tvcmswishlist	0.107 ms	- Mb
=> tvcmswishlist	0.091 ms	- Mb
=> tvcmswishlist	0.085 ms	- Mb
=> tvcmswishlist	0.127 ms	- Mb
=> tvcmswishlist	0.113 ms	- Mb
=> tvcmswishlist	0.109 ms	- Mb
=> tvcmswishlist	0.105 ms	- Mb
=> tvcmswishlist	0.101 ms	- Mb
=> tvcmswishlist	0.103 ms	- Mb
=> tvcmswishlist	0.112 ms	- Mb
=> tvcmswishlist	0.104 ms	- Mb
=> tvcmswishlist	0.208 ms	- Mb
=> tvcmswishlist	0.157 ms	- Mb
=> tvcmswishlist	0.124 ms	- Mb
=> tvcmswishlist	0.179 ms	- Mb
DisplayFooterCategory	3.661 ms	0.24 Mb
=> tvcmsfootercategory	3.661 ms	0.24 Mb
DisplayNavSearchBlock	3.341 ms	0.51 Mb
=> tvcmssearch	3.341 ms	0.51 Mb
Header	2.746 ms	0.05 Mb
=> tvcmsinfinitescroll	2.560 ms	0.04 Mb
=> tvcmsofferbanner	0.097 ms	- Mb
=> tvcmsleftsideofferbanner	0.002 ms	- Mb
=> tvcmstwoofferbanner	0.087 ms	- Mb
displayLeftColumn	1.890 ms	0.06 Mb
=> ps_categorytree (widget)	1.890 ms	0.06 Mb
DisplayBeforeBodyClosingTag	1.851 ms	0.05 Mb
=> statsdata	1.851 ms	0.05 Mb
DisplayCustomsocialblock	1.433 ms	0.09 Mb
=> tvcmscustomsetting	1.433 ms	0.09 Mb
displaySocialMediaBlock	1.310 ms	0.07 Mb
=> ps_socialfollow (widget)	1.310 ms	0.07 Mb
displayFooterPart1	0.835 ms	0.06 Mb
=> ps_linklist (widget)	0.835 ms	0.06 Mb
displayNav1	0.752 ms	0.08 Mb
=> ps_contactinfo (widget)	0.752 ms	0.08 Mb
displayNewslettersubscription	0.691 ms	0.06 Mb
=> ps_emailsubscription (widget)	0.691 ms	0.06 Mb
displayMyaccountcblock	0.634 ms	0.06 Mb
=> ps_customeraccountlinks (widget)	0.634 ms	0.06 Mb
displayNavCurrencyBlock	0.552 ms	0.08 Mb
=> ps_currencyselector (widget)	0.552 ms	0.08 Mb
DisplayNavWishlistBlock	0.521 ms	0.03 Mb
=> tvcmswishlist	0.521 ms	0.03 Mb
displayContactCinfo	0.494 ms	0.03 Mb
=> ps_contactinfo (widget)	0.494 ms	0.03 Mb
displayNavLanguageBlock	0.356 ms	0.05 Mb
=> ps_languageselector (widget)	0.356 ms	0.05 Mb
ActionFrontControllerSetMedia	0.269 ms	0.01 Mb
=> ps_emailsubscription	0.172 ms	- Mb
=> ps_socialfollow	0.038 ms	- Mb
=> ps_emailalerts	0.059 ms	- Mb
ProductSearchProvider	0.235 ms	- Mb
=> ps_facetedsearch	0.235 ms	- Mb
displayNavShoppingCartBlock	0.214 ms	- Mb
=> ps_shoppingcart (widget)	0.214 ms	- Mb
DisplayFacetedSearchBlock	0.187 ms	0.08 Mb
=> ps_facetedsearch	0.187 ms	0.08 Mb
DisplayCopyRightText	0.160 ms	0.01 Mb
=> tvcmscustomsetting	0.160 ms	0.01 Mb
displayNavCustomerSignInBlock	0.150 ms	- Mb
=> ps_customersignin (widget)	0.150 ms	- Mb
DisplayNavProductCompareBlock	0.133 ms	0.01 Mb
=> tvcmsproductcompare	0.133 ms	0.01 Mb
DisplayTopOfferText	0.070 ms	- Mb
=> tvcmscustomsetting	0.066 ms	- Mb
=> tvcmscustomsetting	0.004 ms	- Mb
DisplayCustomCss	0.006 ms	- Mb
=> tvcmscustomcssjs	0.006 ms	- Mb
DisplayCustomJs	0.005 ms	- Mb
=> tvcmscustomcssjs	0.005 ms	- Mb
DisplayMegamenu	0.003 ms	- Mb
=> ets_megamenu	0.003 ms	- Mb
32 hook(s)	518.674 ms	27.43 Mb

Module	Time	Memory Usage
ps_emailsubscription	1.407 ms	0.14 Mb
__construct	0.539 ms	0.08 Mb
hookActionFrontControllerSetMedia	0.174 ms	0.01 Mb
displayNewslettersubscription	0.694 ms	0.06 Mb
ps_socialfollow	1.439 ms	0.07 Mb
__construct	0.088 ms	0.01 Mb
hookActionFrontControllerSetMedia	0.039 ms	- Mb
displaySocialMediaBlock	1.312 ms	0.07 Mb
ps_emailalerts	0.146 ms	0.01 Mb
__construct	0.085 ms	0.01 Mb
hookActionFrontControllerSetMedia	0.061 ms	- Mb
ps_shoppingcart	0.324 ms	0.01 Mb
__construct	0.074 ms	0.01 Mb
hookDisplayHeader	0.034 ms	- Mb
displayNavShoppingCartBlock	0.216 ms	0.01 Mb
ps_searchbar	0.183 ms	0.01 Mb
__construct	0.061 ms	0.01 Mb
hookDisplayHeader	0.122 ms	- Mb
ps_googleanalytics	0.068 ms	0.01 Mb
__construct	0.056 ms	0.01 Mb
hookDisplayHeader	0.012 ms	- Mb
tvcmsbestsellerproducts	22.554 ms	1.71 Mb
__construct	0.129 ms	0.03 Mb
hookDisplayHeader	0.045 ms	- Mb
hookDisplayLeftColumn	22.380 ms	1.68 Mb
tvcmscategoryslider	0.149 ms	0.01 Mb
__construct	0.094 ms	0.01 Mb
hookDisplayHeader	0.055 ms	- Mb
tvcmscustomsetting	2.051 ms	0.13 Mb
__construct	0.078 ms	0.01 Mb
hookDisplayHeader	0.300 ms	0.01 Mb
hookDisplayTopOfferText	0.069 ms	- Mb
hookDisplayTopOfferText	0.006 ms	- Mb
hookDisplayCustomsocialblock	1.436 ms	0.10 Mb
hookDisplayCopyRightText	0.162 ms	0.01 Mb
tvcmsfeaturedproducts	136.806 ms	1.76 Mb
__construct	0.070 ms	0.01 Mb
hookDisplayHeader	0.036 ms	- Mb
hookDisplayLeftColumn	136.700 ms	1.75 Mb
tvcmsmultibanner1	0.168 ms	0.01 Mb
__construct	0.094 ms	0.01 Mb
hookDisplayHeader	0.074 ms	- Mb
tvcmsnewproducts	99.280 ms	1.91 Mb
__construct	0.094 ms	0.01 Mb
hookDisplayHeader	0.054 ms	- Mb
hookDisplayLeftColumn	99.132 ms	1.90 Mb
tvcmsproductcomments	33.640 ms	3.83 Mb
__construct	0.115 ms	0.02 Mb
hookDisplayHeader	0.205 ms	- Mb
hookDisplayReviewProductList	0.967 ms	0.12 Mb
hookDisplayReviewProductList	0.466 ms	0.07 Mb
hookDisplayReviewProductList	0.612 ms	0.07 Mb
hookDisplayReviewProductList	0.521 ms	0.07 Mb
hookDisplayReviewProductList	0.674 ms	0.11 Mb
hookDisplayReviewProductList	0.595 ms	0.07 Mb
hookDisplayReviewProductList	0.496 ms	0.07 Mb
hookDisplayReviewProductList	0.471 ms	0.07 Mb
hookDisplayReviewProductList	0.659 ms	0.11 Mb
hookDisplayReviewProductList	0.456 ms	0.07 Mb
hookDisplayReviewProductList	0.473 ms	0.07 Mb
hookDisplayReviewProductList	0.524 ms	0.07 Mb
hookDisplayReviewProductList	0.710 ms	0.11 Mb
hookDisplayReviewProductList	0.571 ms	0.07 Mb
hookDisplayReviewProductList	0.560 ms	0.07 Mb
hookDisplayReviewProductList	0.590 ms	0.07 Mb
hookDisplayReviewProductList	0.897 ms	0.11 Mb
hookDisplayReviewProductList	0.604 ms	0.07 Mb
hookDisplayReviewProductList	0.624 ms	0.07 Mb
hookDisplayReviewProductList	0.537 ms	0.07 Mb
hookDisplayReviewProductList	0.730 ms	0.11 Mb
hookDisplayReviewProductList	0.475 ms	0.07 Mb
hookDisplayReviewProductList	0.539 ms	0.07 Mb
hookDisplayReviewProductList	0.565 ms	0.07 Mb
hookDisplayReviewProductList	0.674 ms	0.11 Mb
hookDisplayReviewProductList	0.574 ms	0.07 Mb
hookDisplayReviewProductList	0.517 ms	0.07 Mb
hookDisplayReviewProductList	0.603 ms	0.07 Mb
hookDisplayReviewProductList	0.991 ms	0.11 Mb
hookDisplayReviewProductList	0.540 ms	0.07 Mb
hookDisplayReviewProductList	0.735 ms	0.07 Mb
hookDisplayReviewProductList	0.553 ms	0.07 Mb
hookDisplayReviewProductList	0.751 ms	0.11 Mb
hookDisplayReviewProductList	0.569 ms	0.07 Mb
hookDisplayReviewProductList	0.594 ms	0.07 Mb
hookDisplayReviewProductList	0.668 ms	0.07 Mb
hookDisplayReviewProductList	1.004 ms	0.11 Mb
hookDisplayReviewProductList	0.718 ms	0.07 Mb
hookDisplayReviewProductList	1.640 ms	0.07 Mb
hookDisplayReviewProductList	0.659 ms	0.07 Mb
hookDisplayReviewProductList	1.067 ms	0.11 Mb
hookDisplayReviewProductList	0.720 ms	0.07 Mb
hookDisplayReviewProductList	0.637 ms	0.07 Mb
hookDisplayReviewProductList	0.726 ms	0.07 Mb
hookDisplayReviewProductList	1.244 ms	0.11 Mb
hookDisplayReviewProductList	1.092 ms	0.07 Mb
hookDisplayReviewProductList	0.831 ms	0.07 Mb
hookDisplayReviewProductList	0.897 ms	0.07 Mb
tvcmsproductcompare	6.084 ms	0.07 Mb
__construct	0.086 ms	- Mb
hookDisplayHeader	0.091 ms	- Mb
hookDisplayNavProductCompareBlock	0.135 ms	0.01 Mb
hookDisplayProductCompareProductList	0.187 ms	0.01 Mb
hookDisplayProductCompareProductList	0.147 ms	- Mb
hookDisplayProductCompareProductList	0.118 ms	- Mb
hookDisplayProductCompareProductList	0.086 ms	- Mb
hookDisplayProductCompareProductList	0.096 ms	- Mb
hookDisplayProductCompareProductList	0.087 ms	- Mb
hookDisplayProductCompareProductList	0.129 ms	- Mb
hookDisplayProductCompareProductList	0.089 ms	- Mb
hookDisplayProductCompareProductList	0.156 ms	- Mb
hookDisplayProductCompareProductList	0.127 ms	- Mb
hookDisplayProductCompareProductList	0.103 ms	- Mb
hookDisplayProductCompareProductList	0.131 ms	- Mb
hookDisplayProductCompareProductList	0.117 ms	- Mb
hookDisplayProductCompareProductList	0.089 ms	- Mb
hookDisplayProductCompareProductList	0.094 ms	- Mb
hookDisplayProductCompareProductList	0.088 ms	- Mb
hookDisplayProductCompareProductList	0.085 ms	- Mb
hookDisplayProductCompareProductList	0.083 ms	- Mb
hookDisplayProductCompareProductList	0.137 ms	- Mb
hookDisplayProductCompareProductList	0.133 ms	- Mb
hookDisplayProductCompareProductList	0.134 ms	- Mb
hookDisplayProductCompareProductList	0.117 ms	- Mb
hookDisplayProductCompareProductList	0.199 ms	- Mb
hookDisplayProductCompareProductList	0.111 ms	- Mb
hookDisplayProductCompareProductList	0.132 ms	- Mb
hookDisplayProductCompareProductList	0.131 ms	- Mb
hookDisplayProductCompareProductList	0.113 ms	- Mb
hookDisplayProductCompareProductList	0.116 ms	- Mb
hookDisplayProductCompareProductList	0.127 ms	- Mb
hookDisplayProductCompareProductList	0.114 ms	- Mb
hookDisplayProductCompareProductList	0.125 ms	- Mb
hookDisplayProductCompareProductList	0.127 ms	- Mb
hookDisplayProductCompareProductList	0.136 ms	- Mb
hookDisplayProductCompareProductList	0.112 ms	- Mb
hookDisplayProductCompareProductList	0.133 ms	- Mb
hookDisplayProductCompareProductList	0.105 ms	- Mb
hookDisplayProductCompareProductList	0.156 ms	- Mb
hookDisplayProductCompareProductList	0.120 ms	- Mb
hookDisplayProductCompareProductList	0.118 ms	- Mb
hookDisplayProductCompareProductList	0.110 ms	- Mb
hookDisplayProductCompareProductList	0.116 ms	- Mb
hookDisplayProductCompareProductList	0.114 ms	- Mb
hookDisplayProductCompareProductList	0.112 ms	- Mb
hookDisplayProductCompareProductList	0.116 ms	- Mb
hookDisplayProductCompareProductList	0.108 ms	- Mb
hookDisplayProductCompareProductList	0.119 ms	- Mb
hookDisplayProductCompareProductList	0.112 ms	- Mb
hookDisplayProductCompareProductList	0.157 ms	- Mb
tvcmssearch	3.546 ms	0.52 Mb
__construct	0.092 ms	0.01 Mb
hookDisplayHeader	0.111 ms	- Mb
hookDisplayNavSearchBlock	3.343 ms	0.51 Mb
tvcmsslider	0.147 ms	0.01 Mb
__construct	0.096 ms	0.01 Mb
hookDisplayHeader	0.051 ms	- Mb
tvcmsthemeoptions	0.264 ms	0.01 Mb
__construct	0.070 ms	0.01 Mb
hookDisplayHeader	0.194 ms	0.01 Mb
tvcmswishlist	6.346 ms	0.13 Mb
__construct	0.088 ms	0.02 Mb
hookDisplayHeader	0.109 ms	- Mb
hookDisplayNavWishlistBlock	0.524 ms	0.04 Mb
hookDisplayWishlistBtnProductList	0.159 ms	0.01 Mb
hookDisplayWishlistBtnProductList	0.238 ms	- Mb
hookDisplayWishlistBtnProductList	0.099 ms	- Mb
hookDisplayWishlistBtnProductList	0.158 ms	- Mb
hookDisplayWishlistBtnProductList	0.089 ms	- Mb
hookDisplayWishlistBtnProductList	0.136 ms	- Mb
hookDisplayWishlistBtnProductList	0.088 ms	- Mb
hookDisplayWishlistBtnProductList	0.080 ms	- Mb
hookDisplayWishlistBtnProductList	0.097 ms	- Mb
hookDisplayWishlistBtnProductList	0.089 ms	- Mb
hookDisplayWishlistBtnProductList	0.114 ms	- Mb
hookDisplayWishlistBtnProductList	0.096 ms	- Mb
hookDisplayWishlistBtnProductList	0.098 ms	- Mb
hookDisplayWishlistBtnProductList	0.083 ms	- Mb
hookDisplayWishlistBtnProductList	0.145 ms	- Mb
hookDisplayWishlistBtnProductList	0.081 ms	- Mb
hookDisplayWishlistBtnProductList	0.079 ms	- Mb
hookDisplayWishlistBtnProductList	0.077 ms	- Mb
hookDisplayWishlistBtnProductList	0.130 ms	- Mb
hookDisplayWishlistBtnProductList	0.089 ms	- Mb
hookDisplayWishlistBtnProductList	0.112 ms	- Mb
hookDisplayWishlistBtnProductList	0.108 ms	- Mb
hookDisplayWishlistBtnProductList	0.119 ms	- Mb
hookDisplayWishlistBtnProductList	0.108 ms	- Mb
hookDisplayWishlistBtnProductList	0.117 ms	- Mb
hookDisplayWishlistBtnProductList	0.110 ms	- Mb
hookDisplayWishlistBtnProductList	0.159 ms	- Mb
hookDisplayWishlistBtnProductList	0.103 ms	- Mb
hookDisplayWishlistBtnProductList	0.113 ms	- Mb
hookDisplayWishlistBtnProductList	0.106 ms	- Mb
hookDisplayWishlistBtnProductList	0.124 ms	- Mb
hookDisplayWishlistBtnProductList	0.120 ms	- Mb
hookDisplayWishlistBtnProductList	0.150 ms	- Mb
hookDisplayWishlistBtnProductList	0.109 ms	- Mb
hookDisplayWishlistBtnProductList	0.092 ms	- Mb
hookDisplayWishlistBtnProductList	0.087 ms	- Mb
hookDisplayWishlistBtnProductList	0.129 ms	- Mb
hookDisplayWishlistBtnProductList	0.114 ms	- Mb
hookDisplayWishlistBtnProductList	0.112 ms	- Mb
hookDisplayWishlistBtnProductList	0.107 ms	- Mb
hookDisplayWishlistBtnProductList	0.102 ms	- Mb
hookDisplayWishlistBtnProductList	0.105 ms	- Mb
hookDisplayWishlistBtnProductList	0.114 ms	- Mb
hookDisplayWishlistBtnProductList	0.106 ms	- Mb
hookDisplayWishlistBtnProductList	0.209 ms	- Mb
hookDisplayWishlistBtnProductList	0.159 ms	- Mb
hookDisplayWishlistBtnProductList	0.126 ms	- Mb
hookDisplayWishlistBtnProductList	0.181 ms	- Mb
ets_megamenu	192.209 ms	16.60 Mb
__construct	0.134 ms	0.05 Mb
hookDisplayHeader	5.625 ms	1.19 Mb
hookDisplayMegamenu	0.005 ms	- Mb
hookDisplayNavFullWidth	186.445 ms	15.37 Mb
ps_customersignin	0.212 ms	0.01 Mb
__construct	0.059 ms	0.01 Mb
displayNavCustomerSignInBlock	0.153 ms	- Mb
tvcmsinfinitescroll	2.771 ms	0.09 Mb
__construct	0.209 ms	0.05 Mb
hookHeader	2.562 ms	0.04 Mb
tvcmsofferbanner	0.221 ms	- Mb
__construct	0.122 ms	- Mb
hookHeader	0.099 ms	- Mb
tvcmsleftsideofferbanner	0.117 ms	0.01 Mb
__construct	0.114 ms	0.01 Mb
hookHeader	0.003 ms	- Mb
tvcmstwoofferbanner	0.212 ms	0.01 Mb
__construct	0.123 ms	0.01 Mb
hookHeader	0.089 ms	- Mb
ps_facetedsearch	0.639 ms	0.10 Mb
__construct	0.213 ms	0.01 Mb
hookProductSearchProvider	0.237 ms	- Mb
hookDisplayFacetedSearchBlock	0.189 ms	0.08 Mb
tvcmscustomcssjs	0.160 ms	0.01 Mb
__construct	0.145 ms	0.01 Mb
hookDisplayCustomCss	0.008 ms	- Mb
hookDisplayCustomJs	0.007 ms	- Mb
ps_languageselector	0.429 ms	0.06 Mb
__construct	0.070 ms	0.01 Mb
displayNavLanguageBlock	0.359 ms	0.05 Mb
ps_currencyselector	0.611 ms	0.08 Mb
__construct	0.057 ms	0.01 Mb
displayNavCurrencyBlock	0.554 ms	0.08 Mb
ps_contactinfo	1.325 ms	0.12 Mb
__construct	0.074 ms	0.01 Mb
displayNav1	0.754 ms	0.09 Mb
displayContactCinfo	0.497 ms	0.03 Mb
ps_categorytree	1.964 ms	0.07 Mb
__construct	0.071 ms	0.01 Mb
displayLeftColumn	1.893 ms	0.06 Mb
tvcmsfootercategory	3.837 ms	0.24 Mb
__construct	0.174 ms	0.01 Mb
hookDisplayFooterCategory	3.663 ms	0.24 Mb
ps_linklist	0.956 ms	0.07 Mb
__construct	0.118 ms	0.01 Mb
displayFooterPart1	0.838 ms	0.06 Mb
ps_customeraccountlinks	0.713 ms	0.07 Mb
__construct	0.076 ms	0.01 Mb
displayMyaccountcblock	0.637 ms	0.06 Mb
statsdata	1.918 ms	0.05 Mb
__construct	0.064 ms	0.01 Mb
hookDisplayBeforeBodyClosingTag	1.854 ms	0.05 Mb
34 module(s)	522.894 ms	27.89 Mb

Name	Instances	Source
Category	225	/controllers/front/listing/CategoryController.php:78 (__construct) [id: 129] /controllers/front/listing/CategoryController.php:215 (__construct) [id: 130] /controllers/front/listing/CategoryController.php:215 (__construct) [id: 147] /controllers/front/listing/CategoryController.php:215 (__construct) [id: 269] /classes/Meta.php:380 (__construct) [id: 129] /classes/PrestaShopCollection.php:385 (hydrateCollection) [id: ] /classes/PrestaShopCollection.php:385 (hydrateCollection) [id: ] /classes/PrestaShopCollection.php:385 (hydrateCollection) [id: ] /classes/Link.php:402 (__construct) [id: 129] /modules/ps_facetedsearch/src/Product/Search.php:364 (__construct) [id: 129] /modules/ps_facetedsearch/src/Filters/Block.php:157 (__construct) [id: 129] /modules/tvcmssearch/tvcmssearch.php:102 (getNestedCategories) [id: 2] /classes/Link.php:402 (__construct) [id: 258] /classes/Link.php:402 (__construct) [id: 255] /classes/Link.php:402 (__construct) [id: 14] /classes/Link.php:402 (__construct) [id: 292] /classes/Link.php:402 (__construct) [id: 17] /classes/Link.php:402 (__construct) [id: 16] /classes/Link.php:402 (__construct) [id: 20] /classes/Link.php:402 (__construct) [id: 270] /classes/Link.php:402 (__construct) [id: 330] /classes/Link.php:402 (__construct) [id: 255] /classes/Link.php:402 (__construct) [id: 145] /classes/Link.php:402 (__construct) [id: 257] /classes/Link.php:402 (__construct) [id: 232] /classes/Link.php:402 (__construct) [id: 76] /classes/Link.php:402 (__construct) [id: 111] /classes/Link.php:402 (__construct) [id: 56] /classes/Link.php:402 (__construct) [id: 303] /classes/Link.php:402 (__construct) [id: 304] /classes/Link.php:402 (__construct) [id: 306] /classes/Link.php:402 (__construct) [id: 234] /classes/Link.php:402 (__construct) [id: 241] /classes/Link.php:402 (__construct) [id: 118] /classes/Link.php:402 (__construct) [id: 334] /classes/Link.php:402 (__construct) [id: 333] /classes/Link.php:402 (__construct) [id: 176] /classes/Link.php:402 (__construct) [id: 174] /classes/Link.php:402 (__construct) [id: 149] /classes/Link.php:402 (__construct) [id: 100] /classes/Link.php:402 (__construct) [id: 99] /classes/Link.php:402 (__construct) [id: 84] /classes/Link.php:402 (__construct) [id: 106] /classes/Link.php:402 (__construct) [id: 169] /classes/Link.php:402 (__construct) [id: 121] /classes/Link.php:402 (__construct) [id: 122] /classes/Link.php:402 (__construct) [id: 45] /classes/Link.php:402 (__construct) [id: 110] /classes/Link.php:402 (__construct) [id: 43] /classes/Link.php:402 (__construct) [id: 109] /classes/Link.php:402 (__construct) [id: 260] /classes/Link.php:402 (__construct) [id: 47] /classes/Link.php:402 (__construct) [id: 46] /classes/Link.php:402 (__construct) [id: 72] /classes/Link.php:402 (__construct) [id: 119] /classes/Link.php:402 (__construct) [id: 66] /classes/Link.php:402 (__construct) [id: 48] /classes/Link.php:402 (__construct) [id: 71] /classes/Link.php:402 (__construct) [id: 85] /classes/Link.php:402 (__construct) [id: 108] /classes/Link.php:402 (__construct) [id: 112] /classes/Link.php:402 (__construct) [id: 86] /classes/Link.php:402 (__construct) [id: 87] /classes/Link.php:402 (__construct) [id: 59] /classes/Link.php:402 (__construct) [id: 195] /classes/Link.php:402 (__construct) [id: 124] /classes/Link.php:402 (__construct) [id: 155] /classes/Link.php:402 (__construct) [id: 267] /classes/Link.php:402 (__construct) [id: 265] /classes/Link.php:402 (__construct) [id: 266] /classes/Link.php:402 (__construct) [id: 185] /classes/Link.php:402 (__construct) [id: 268] /classes/Link.php:402 (__construct) [id: 140] /classes/Link.php:402 (__construct) [id: 172] /classes/Link.php:402 (__construct) [id: 154] /classes/Link.php:402 (__construct) [id: 143] /classes/Link.php:402 (__construct) [id: 142] /classes/Link.php:402 (__construct) [id: 139] /classes/Link.php:402 (__construct) [id: 242] /classes/Link.php:402 (__construct) [id: 243] /classes/Link.php:402 (__construct) [id: 240] /classes/Link.php:402 (__construct) [id: 256] /classes/Link.php:402 (__construct) [id: 325] /classes/Link.php:402 (__construct) [id: 291] /classes/Link.php:402 (__construct) [id: 152] /classes/Link.php:402 (__construct) [id: 335] /classes/Link.php:402 (__construct) [id: 191] /classes/Link.php:402 (__construct) [id: 193] /classes/Link.php:402 (__construct) [id: 194] /classes/Link.php:402 (__construct) [id: 332] /classes/Link.php:402 (__construct) [id: 192] /classes/Link.php:402 (__construct) [id: 147] /classes/Link.php:402 (__construct) [id: 130] /classes/Link.php:402 (__construct) [id: 269] /classes/Link.php:402 (__construct) [id: 131] /classes/Link.php:402 (__construct) [id: 37] /classes/Link.php:402 (__construct) [id: 34] /classes/Link.php:402 (__construct) [id: 41] /classes/Link.php:402 (__construct) [id: 177] /classes/Link.php:402 (__construct) [id: 135] /classes/Link.php:402 (__construct) [id: 233] /classes/Link.php:402 (__construct) [id: 126] /classes/Link.php:402 (__construct) [id: 180] /classes/Link.php:402 (__construct) [id: 231] /classes/Link.php:402 (__construct) [id: 181] /classes/Link.php:402 (__construct) [id: 319] /classes/Link.php:402 (__construct) [id: 293] /classes/Link.php:402 (__construct) [id: 324] /classes/Link.php:402 (__construct) [id: 322] /classes/Link.php:402 (__construct) [id: 329] /classes/Link.php:402 (__construct) [id: 327] /classes/Link.php:402 (__construct) [id: 321] /classes/Link.php:402 (__construct) [id: 323] /classes/Link.php:402 (__construct) [id: 300] /classes/Link.php:402 (__construct) [id: 296] /classes/Link.php:402 (__construct) [id: 295] /classes/Link.php:402 (__construct) [id: 297] /classes/Link.php:402 (__construct) [id: 299] /classes/Link.php:402 (__construct) [id: 298] /classes/Link.php:402 (__construct) [id: 190] /classes/Link.php:402 (__construct) [id: 248] /classes/Link.php:402 (__construct) [id: 96] /classes/Link.php:402 (__construct) [id: 95] /classes/Link.php:402 (__construct) [id: 97] /classes/Link.php:402 (__construct) [id: 94] /classes/Link.php:402 (__construct) [id: 226] /classes/Link.php:402 (__construct) [id: 92] /classes/Link.php:402 (__construct) [id: 227] /classes/Link.php:402 (__construct) [id: 90] /classes/Link.php:402 (__construct) [id: 89] /classes/Link.php:402 (__construct) [id: 246] /classes/Link.php:402 (__construct) [id: 245] /classes/Link.php:402 (__construct) [id: 247] /classes/Link.php:402 (__construct) [id: 70] /classes/Link.php:402 (__construct) [id: 68] /classes/Link.php:402 (__construct) [id: 67] /classes/Link.php:402 (__construct) [id: 69] /classes/Link.php:402 (__construct) [id: 156] /classes/Link.php:402 (__construct) [id: 151] /classes/Link.php:402 (__construct) [id: 136] /classes/Link.php:402 (__construct) [id: 235] /classes/Link.php:402 (__construct) [id: 133] /classes/Link.php:402 (__construct) [id: 137] /classes/Link.php:402 (__construct) [id: 54] /classes/Link.php:402 (__construct) [id: 52] /classes/Link.php:402 (__construct) [id: 78] /classes/Link.php:402 (__construct) [id: 79] /classes/Link.php:402 (__construct) [id: 163] /classes/Link.php:402 (__construct) [id: 236] /classes/Link.php:402 (__construct) [id: 77] /classes/Link.php:402 (__construct) [id: 141] /classes/Link.php:402 (__construct) [id: 75] /classes/Link.php:402 (__construct) [id: 178] /classes/Link.php:402 (__construct) [id: 80] /classes/Link.php:402 (__construct) [id: 82] /classes/Link.php:402 (__construct) [id: 81] /classes/Link.php:402 (__construct) [id: 83] /classes/Link.php:402 (__construct) [id: 238] /classes/Link.php:402 (__construct) [id: 239] /classes/Link.php:402 (__construct) [id: 63] /classes/Link.php:402 (__construct) [id: 62] /classes/Link.php:402 (__construct) [id: 173] /classes/Link.php:402 (__construct) [id: 114] /classes/Link.php:402 (__construct) [id: 144] /classes/Link.php:402 (__construct) [id: 171] /classes/Link.php:402 (__construct) [id: 65] /classes/Link.php:402 (__construct) [id: 113] /classes/Link.php:402 (__construct) [id: 170] /classes/Link.php:402 (__construct) [id: 166] /classes/Link.php:402 (__construct) [id: 159] /classes/Link.php:402 (__construct) [id: 228] /classes/Link.php:402 (__construct) [id: 229] /classes/Link.php:402 (__construct) [id: 230] /classes/Link.php:402 (__construct) [id: 160] /classes/Link.php:402 (__construct) [id: 158] /classes/Link.php:402 (__construct) [id: 165] /classes/Link.php:402 (__construct) [id: 161] /classes/Link.php:402 (__construct) [id: 164] /classes/Link.php:402 (__construct) [id: 311] /classes/Link.php:402 (__construct) [id: 310] /classes/Link.php:402 (__construct) [id: 309] /classes/Link.php:402 (__construct) [id: 30] /classes/Link.php:402 (__construct) [id: 175] /classes/Link.php:402 (__construct) [id: 98] /classes/Link.php:402 (__construct) [id: 40] /classes/Link.php:402 (__construct) [id: 39] /classes/Link.php:402 (__construct) [id: 237] /classes/Link.php:402 (__construct) [id: 316] /classes/Link.php:402 (__construct) [id: 317] /classes/Link.php:402 (__construct) [id: 318] /classes/Link.php:402 (__construct) [id: 314] /classes/Link.php:402 (__construct) [id: 312] /classes/Link.php:402 (__construct) [id: 315] /classes/Link.php:402 (__construct) [id: 277] /classes/Link.php:402 (__construct) [id: 123] /classes/Link.php:402 (__construct) [id: 276] /classes/Link.php:402 (__construct) [id: 285] /classes/Link.php:402 (__construct) [id: 284] /classes/Link.php:402 (__construct) [id: 286] /classes/Link.php:402 (__construct) [id: 287] /classes/Link.php:402 (__construct) [id: 274] /classes/Link.php:402 (__construct) [id: 331] /classes/Link.php:402 (__construct) [id: 192] /classes/Link.php:402 (__construct) [id: 332] /classes/Link.php:402 (__construct) [id: 194] /classes/Link.php:402 (__construct) [id: 193] /classes/Link.php:402 (__construct) [id: 191] /classes/Link.php:402 (__construct) [id: 335] /classes/Link.php:402 (__construct) [id: 153] /classes/Link.php:402 (__construct) [id: 256] /classes/Link.php:402 (__construct) [id: 325] /classes/Link.php:402 (__construct) [id: 291] /classes/Link.php:402 (__construct) [id: 152] /classes/Link.php:402 (__construct) [id: 326] /modules/tvcmstabproducts/tvcmstabproducts.php:2683 (__construct) [id: 2] /classes/Link.php:402 (__construct) [id: 2] /modules/ps_categorytree/ps_categorytree.php:338 (__construct) [id: 129] /modules/tvcmsfootercategory/tvcmsfootercategory.php:401 (__construct) [id: 258] /classes/Link.php:402 (__construct) [id: 258] /modules/tvcmsfootercategory/tvcmsfootercategory.php:401 (__construct) [id: 255] /classes/Link.php:402 (__construct) [id: 255] /modules/tvcmsfootercategory/tvcmsfootercategory.php:401 (__construct) [id: 14] /classes/Link.php:402 (__construct) [id: 14] /modules/tvcmsfootercategory/tvcmsfootercategory.php:401 (__construct) [id: 292] /classes/Link.php:402 (__construct) [id: 292]
Product	85	/classes/Link.php:113 (__construct) [id: 10001] /classes/Link.php:113 (__construct) [id: 7347] /classes/Link.php:113 (__construct) [id: 8299] /classes/Link.php:113 (__construct) [id: 8581] /classes/Link.php:113 (__construct) [id: 9031] /classes/Link.php:113 (__construct) [id: 9055] /classes/Link.php:113 (__construct) [id: 9058] /classes/Link.php:113 (__construct) [id: 9059] /classes/Link.php:113 (__construct) [id: 9130] /classes/Link.php:113 (__construct) [id: 10212] /classes/Link.php:113 (__construct) [id: 10213] /classes/Link.php:113 (__construct) [id: 10214] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 10001] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 7347] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 8299] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 8581] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 9031] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 9055] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 9058] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 9059] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 9130] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 10212] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 10213] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 10214] /classes/Link.php:113 (__construct) [id: 10001] /classes/Link.php:113 (__construct) [id: 7347] /classes/Link.php:113 (__construct) [id: 8299] /classes/Link.php:113 (__construct) [id: 8581] /classes/Link.php:113 (__construct) [id: 9031] /classes/Link.php:113 (__construct) [id: 9055] /classes/Link.php:113 (__construct) [id: 9058] /classes/Link.php:113 (__construct) [id: 9059] /classes/Link.php:113 (__construct) [id: 9130] /classes/Link.php:113 (__construct) [id: 10212] /classes/Link.php:113 (__construct) [id: 10213] /classes/Link.php:113 (__construct) [id: 10214] /classes/Link.php:113 (__construct) [id: 10542] /classes/Link.php:113 (__construct) [id: 10543] /classes/Link.php:113 (__construct) [id: 10540] /classes/Link.php:113 (__construct) [id: 10539] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 10542] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 10543] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 10540] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 10539] /classes/Link.php:113 (__construct) [id: 552] /classes/Link.php:113 (__construct) [id: 5761] /classes/Link.php:113 (__construct) [id: 7981] /classes/Link.php:113 (__construct) [id: 8350] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 552] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 5761] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 7981] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 8350] /classes/Link.php:113 (__construct) [id: 6191] /classes/Link.php:113 (__construct) [id: 9243] /classes/Link.php:113 (__construct) [id: 6365] /classes/Link.php:113 (__construct) [id: 3424] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 6191] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 9243] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 6365] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 3424] /src/Adapter/Presenter/Product/ProductLazyArray.php:662 (__construct) [id: 8299] /classes/Link.php:113 (__construct) [id: 8299] /classes/Link.php:113 (__construct) [id: 8299] /classes/Link.php:113 (__construct) [id: 9031] /classes/Link.php:113 (__construct) [id: 9031] /classes/Link.php:113 (__construct) [id: 9031] /classes/Link.php:113 (__construct) [id: 9031] /src/Adapter/Presenter/Product/ProductLazyArray.php:662 (__construct) [id: 9055] /classes/Link.php:113 (__construct) [id: 9055] /classes/Link.php:113 (__construct) [id: 9055] /classes/Link.php:113 (__construct) [id: 9055] /src/Adapter/Presenter/Product/ProductLazyArray.php:662 (__construct) [id: 9058] /classes/Link.php:113 (__construct) [id: 9058] /classes/Link.php:113 (__construct) [id: 9058] /classes/Link.php:113 (__construct) [id: 9058] /src/Adapter/Presenter/Product/ProductLazyArray.php:662 (__construct) [id: 9059] /classes/Link.php:113 (__construct) [id: 9059] /classes/Link.php:113 (__construct) [id: 9059] /src/Adapter/Presenter/Product/ProductLazyArray.php:662 (__construct) [id: 9130] /classes/Link.php:113 (__construct) [id: 9130] /classes/Link.php:113 (__construct) [id: 9130] /classes/Link.php:113 (__construct) [id: 9130] /src/Adapter/Presenter/Product/ProductLazyArray.php:662 (__construct) [id: 10212] /classes/Link.php:113 (__construct) [id: 10212] /classes/Link.php:113 (__construct) [id: 10212]
Combination	9	/classes/Product.php:5893 (__construct) [id: 528] /classes/Product.php:5893 (__construct) [id: 772] /classes/Product.php:5893 (__construct) [id: 776] /classes/Product.php:5893 (__construct) [id: 785] /classes/Product.php:5893 (__construct) [id: 829] /classes/Product.php:5893 (__construct) [id: 813] /classes/Product.php:5893 (__construct) [id: 1017] /classes/Product.php:5893 (__construct) [id: 1034] /classes/Product.php:5893 (__construct) [id: 1037]
Country	7	/config/config.inc.php:146 (__construct) [id: 208] /classes/AddressFormat.php:404 (__construct) [id: 208] /classes/controller/FrontController.php:1760 (__construct) [id: 208] /classes/AddressFormat.php:404 (__construct) [id: 208] /modules/ps_contactinfo/ps_contactinfo.php:104 (__construct) [id: 208] /classes/AddressFormat.php:404 (__construct) [id: 208] /modules/ps_contactinfo/ps_contactinfo.php:104 (__construct) [id: 208]
Address	4	/classes/shop/Shop.php:486 (__construct) [id: ] /classes/Product.php:3694 (initialize) [id: ] /classes/Product.php:3804 (__construct) [id: ] /classes/Product.php:5945 (__construct) [id: ]
State	3	/classes/controller/FrontController.php:1759 (__construct) [id: 0] /modules/ps_contactinfo/ps_contactinfo.php:93 (__construct) [id: 0] /modules/ps_contactinfo/ps_contactinfo.php:93 (__construct) [id: 0]
AddressFormat	3	/classes/controller/FrontController.php:1754 (generateAddress) [id: ] /modules/ps_contactinfo/ps_contactinfo.php:98 (generateAddress) [id: ] /modules/ps_contactinfo/ps_contactinfo.php:98 (generateAddress) [id: ]
Language	2	/config/config.inc.php:211 (__construct) [id: 1] /classes/Tools.php:560 (__construct) [id: 1]
Currency	2	/src/Adapter/Currency/CurrencyDataProvider.php:101 (__construct) [id: 1] /classes/Tools.php:690 (getCurrencyInstance) [id: 1]
Cart	2	/classes/controller/FrontController.php:465 (__construct) [id: ] /classes/controller/FrontController.php:534 (__construct) [id: ]
Shop	1	/config/config.inc.php:117 (initialize) [id: 1]
CMS	1	/classes/Link.php:555 (__construct) [id: 4]
Tax	1	/classes/tax/TaxRulesTaxManager.php:116 (__construct) [id: 7]
Gender	1	/classes/controller/FrontController.php:1684 (__construct) [id: 0]
Risk	1	/classes/controller/FrontController.php:1687 (__construct) [id: ]
Group	1	/classes/Cart.php:249 (getCurrent) [id: 1]
Customer	1	/config/config.inc.php:264 (__construct) [id: ]
ShopGroup	1	/classes/shop/Shop.php:561 (__construct) [id: 1]
ConnectionsSource	1	/modules/statsdata/statsdata.php:119 (logHttpReferer) [id: ]

#	Query	Time (ms)	Rows	Filesort	Location
940	SELECT SQL_NO_CACHE p., product_shop., stock.out_of_stock, IFNULL(stock.quantity, 0) AS quantity, IFNULL(product_attribute_shop.id_product_attribute, 0) AS id_product_attribute, product_attribute_shop.minimal_quantity AS product_attribute_minimal_quantity, pl.`description`, pl.`description_short`, pl.`available_now`, pl.`available_later`, pl.`link_rewrite`, pl.`meta_description`, pl.`meta_keywords`, pl.`meta_title`, pl.`name`, image_shop.`id_image` id_image, il.`legend` as legend, m.`name` AS manufacturer_name, cl.`name` AS category_default, DATEDIFF(product_shop.`date_add`, DATE_SUB("2025-07-28 00:00:00", INTERVAL 1000 DAY)) > 0 AS new, product_shop.price AS orderprice FROM `mb_category_product` cp LEFT JOIN `mb_product` p ON p.`id_product` = cp.`id_product` INNER JOIN mb_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) LEFT JOIN `mb_product_attribute_shop` product_attribute_shop ON (p.`id_product` = product_attribute_shop.`id_product` AND product_attribute_shop.`default_on` = 1 AND product_attribute_shop.id_shop=1) LEFT JOIN mb_stock_available stock ON (stock.id_product = `p`.id_product AND stock.id_product_attribute = 0 AND stock.id_shop = 1 AND stock.id_shop_group = 0 ) LEFT JOIN `mb_category_lang` cl ON (product_shop.`id_category_default` = cl.`id_category` AND cl.`id_lang` = 1 AND cl.id_shop = 1 ) LEFT JOIN `mb_product_lang` pl ON (p.`id_product` = pl.`id_product` AND pl.`id_lang` = 1 AND pl.id_shop = 1 ) LEFT JOIN `mb_image_shop` image_shop ON (image_shop.`id_product` = p.`id_product` AND image_shop.cover=1 AND image_shop.id_shop=1) LEFT JOIN `mb_image_lang` il ON (image_shop.`id_image` = il.`id_image` AND il.`id_lang` = 1) LEFT JOIN `mb_manufacturer` m ON m.`id_manufacturer` = p.`id_manufacturer` WHERE product_shop.`id_shop` = 1 AND cp.`id_category` = 2 AND product_shop.`active` = 1 AND product_shop.`visibility` IN ("both", "catalog") ORDER BY RAND() LIMIT 4	99.036 ms	8092	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:1043 (hookdisplayLeftColumn) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:418 (coreCallHook) /classes/Hook.php:981 (callHookOn) /config/smarty.config.inc.php:198 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/prod/smarty/compile/v1_electron_1layouts_layout_left_column_tpl/7b/20/9b/7b209b8ad3a4b959ee700fbabff63490fd8dfb7e_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/7b/20/9b/7b209b8ad3a4b959ee700fbabff63490fd8dfb7e_2.file.layout-both-columns.tpl.php:74 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68816b9b6d7dd3_62298143) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php: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/59/27/34/592734f8f890bb342f82010dedfdefdfb102af18_2.file.layout-left-column.tpl.php:28 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68816b9b6b85a3_55565069) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php: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/89/73/cd/8973cd33287e2cbf8397bbeb9d03e6e024e12e8e_2.file.product-list.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68816b9b6b26f3_29067136) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php: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/ad/e7/9e/ade79eb0f0f9f51d33a9ae668beef9fcff755b39_2.file.category.tpl.php:29 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68816b9b6a1a00_79340852) /vendor/smarty/smarty/libs/sysplugins/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:753 (fetch) /classes/controller/FrontController.php:735 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
868	SELECT SQL_NO_CACHE p., product_shop., stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, pl.`description`, pl.`description_short`, pl.`link_rewrite`, pl.`meta_description`, pl.`meta_keywords`, pl.`meta_title`, pl.`name`, pl.`available_now`, pl.`available_later`, image_shop.`id_image` id_image, il.`legend`, m.`name` AS manufacturer_name, (DATEDIFF(product_shop.`date_add`, DATE_SUB( "2025-07-28 00:00:00", INTERVAL 1000 DAY ) ) > 0) as new, product_attribute_shop.minimal_quantity AS product_attribute_minimal_quantity, IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute FROM `mb_product` p INNER JOIN mb_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) LEFT JOIN `mb_product_lang` `pl` ON p.`id_product` = pl.`id_product` AND pl.`id_lang` = 1 AND pl.id_shop = 1 LEFT JOIN `mb_image_shop` `image_shop` ON image_shop.`id_product` = p.`id_product` AND image_shop.cover=1 AND image_shop.id_shop=1 LEFT JOIN `mb_image_lang` `il` ON image_shop.`id_image` = il.`id_image` AND il.`id_lang` = 1 LEFT JOIN `mb_manufacturer` `m` ON m.`id_manufacturer` = p.`id_manufacturer` LEFT JOIN `mb_product_attribute_shop` `product_attribute_shop` ON p.`id_product` = product_attribute_shop.`id_product` AND product_attribute_shop.`default_on` = 1 AND product_attribute_shop.id_shop=1 LEFT JOIN mb_stock_available stock ON (stock.id_product = `p`.id_product AND stock.id_product_attribute = 0 AND stock.id_shop = 1 AND stock.id_shop_group = 0 ) WHERE (product_shop.`active` = 1) AND (product_shop.`visibility` IN ("both", "catalog")) AND (DATEDIFF(product_shop.`date_add`, DATE_SUB( "2025-07-28 00:00:00", INTERVAL 1000 DAY ) ) > 0) AND (EXISTS(SELECT 1 FROM `mb_category_product` cp JOIN `mb_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	75.620 ms	100696848	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:1043 (hookdisplayLeftColumn) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:418 (coreCallHook) /classes/Hook.php:981 (callHookOn) /config/smarty.config.inc.php:198 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/prod/smarty/compile/v1_electron_1layouts_layout_left_column_tpl/7b/20/9b/7b209b8ad3a4b959ee700fbabff63490fd8dfb7e_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/7b/20/9b/7b209b8ad3a4b959ee700fbabff63490fd8dfb7e_2.file.layout-both-columns.tpl.php:74 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68816b9b6d7dd3_62298143) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php: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/59/27/34/592734f8f890bb342f82010dedfdefdfb102af18_2.file.layout-left-column.tpl.php:28 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68816b9b6b85a3_55565069) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php: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/89/73/cd/8973cd33287e2cbf8397bbeb9d03e6e024e12e8e_2.file.product-list.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68816b9b6b26f3_29067136) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php: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/ad/e7/9e/ade79eb0f0f9f51d33a9ae668beef9fcff755b39_2.file.category.tpl.php:29 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68816b9b6a1a00_79340852) /vendor/smarty/smarty/libs/sysplugins/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:753 (fetch) /classes/controller/FrontController.php:735 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
984	SELECT SQL_NO_CACHE COUNT(cp.`id_product`) AS total FROM `mb_product` p INNER JOIN mb_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) LEFT JOIN `mb_category_product` cp ON p.`id_product` = cp.`id_product` WHERE cp.`id_category` = 2 AND product_shop.`visibility` IN ("both", "catalog") AND product_shop.`active` = 1 LIMIT 1	18.120 ms	5664		/classes/Category.php:991 /src/Adapter/Category/CategoryProductSearchProvider.php:79 (getProducts) /src/Adapter/Category/CategoryProductSearchProvider.php:106 (getProductsOrCount) /modules/tvcmstabproducts/tvcmstabproducts.php:2708 (runQuery) /modules/tvcmsfeaturedproducts/tvcmsfeaturedproducts.php:158 (displayFeaturedProducts) /modules/tvcmsfeaturedproducts/tvcmsfeaturedproducts.php:281 (showFrontSideResult) /classes/Hook.php:1043 (hookdisplayLeftColumn) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:418 (coreCallHook) /classes/Hook.php:981 (callHookOn) /config/smarty.config.inc.php:198 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/prod/smarty/compile/v1_electron_1layouts_layout_left_column_tpl/7b/20/9b/7b209b8ad3a4b959ee700fbabff63490fd8dfb7e_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/7b/20/9b/7b209b8ad3a4b959ee700fbabff63490fd8dfb7e_2.file.layout-both-columns.tpl.php:74 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68816b9b6d7dd3_62298143) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php: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/59/27/34/592734f8f890bb342f82010dedfdefdfb102af18_2.file.layout-left-column.tpl.php:28 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68816b9b6b85a3_55565069) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php: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/89/73/cd/8973cd33287e2cbf8397bbeb9d03e6e024e12e8e_2.file.product-list.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68816b9b6b26f3_29067136) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php: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/ad/e7/9e/ade79eb0f0f9f51d33a9ae668beef9fcff755b39_2.file.category.tpl.php:29 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68816b9b6a1a00_79340852) /vendor/smarty/smarty/libs/sysplugins/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:753 (fetch) /classes/controller/FrontController.php:735 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
73	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 mb_product p LEFT JOIN mb_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mb_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN mb_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN mb_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN mb_category_product cp ON (p.id_product = cp.id_product) INNER JOIN mb_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN mb_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN mb_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN mb_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN mb_feature_product fp_1 ON (p.id_product = fp_1.id_product) WHERE ((fp.id_feature_value IN (142, 43, 45))) AND ((fp_1.id_feature_value IN (27134, 27321, 26982, 19884, 27466, 24878, 27323, 26988, 27472, 27145, 25062, 27341, 26994, 25071, 27347, 27000, 28003, 27158, 27356, 27011, 26793, 27362, 27019, 27120, 26937, 27389, 27124, 26940, 27392, 27126, 26955, 19635, 27395, 27128, 23731, 27317, 26964, 19641, 27131, 27319, 26973, 19880, 14709, 27889, 18376, 18595, 26253, 21638, 21800, 27178, 17397, 22374, 14366, 24605, 222, 11784, 27141, 20899, 27534, 27935, 27111, 21056, 27688, 27032, 27042, 14362, 27056, 27087, 27093, 27908))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=188 AND c.nright<=195 GROUP BY p.id_product) p LEFT JOIN mb_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN mb_feature_product fp_1 ON (p.id_product = fp_1.id_product) WHERE ((fp.id_feature_value IN (142, 43, 45))) AND ((fp_1.id_feature_value IN (27134, 27321, 26982, 19884, 27466, 24878, 27323, 26988, 27472, 27145, 25062, 27341, 26994, 25071, 27347, 27000, 28003, 27158, 27356, 27011, 26793, 27362, 27019, 27120, 26937, 27389, 27124, 26940, 27392, 27126, 26955, 19635, 27395, 27128, 23731, 27317, 26964, 19641, 27131, 27319, 26973, 19880, 14709, 27889, 18376, 18595, 26253, 21638, 21800, 27178, 17397, 22374, 14366, 24605, 222, 11784, 27141, 20899, 27534, 27935, 27111, 21056, 27688, 27032, 27042, 14362, 27056, 27087, 27093, 27908)))	11.731 ms	1584		/modules/ps_facetedsearch/src/Adapter/MySQL.php:86 /modules/ps_facetedsearch/src/Adapter/MySQL.php:786 (execute) /modules/ps_facetedsearch/src/Adapter/MySQL.php:764 (valueCount) /modules/ps_facetedsearch/src/Filters/Products.php:94 (count) /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:138 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
460	SELECT SQL_NO_CACHE c.*, cl.name,cl.link_rewrite FROM `mb_category` c INNER JOIN `mb_category_shop` cs ON (c.id_category =cs.id_category AND cs.id_shop=1) LEFT JOIN `mb_category_lang` cl ON c.id_category=cl.id_category AND cl.id_lang=1 AND cl.id_shop=1 WHERE c.active = 1 AND c.id_parent=99 AND c.id_category!=99 ORDER BY c.id_category DESC	10.842 ms	1		/modules/ets_megamenu/classes/Ets_megamenu_defines.php:295 /modules/ets_megamenu/ets_megamenu.php:3299 (getChildCategories) /modules/ets_megamenu/ets_megamenu.php:2671 (displayCategories) /modules/ets_megamenu/ets_megamenu.php:2579 (convertBlockProperties) /var/cache/prod/smarty/compile/v1_electron_1/0d/33/c4/0d33c448146e5de9429dcae3809bb001ed5763be_2.file.menu-html.tpl.php:256 (hookDisplayBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68816b99937787_61535144) /vendor/smarty/smarty/libs/sysplugins/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) /modules/ets_megamenu/ets_megamenu.php:4629 (fetch) /modules/ets_megamenu/ets_megamenu.php:3551 (display) /modules/ets_megamenu/ets_megamenu.php:3473 (displayMegaMenu) /modules/ets_megamenu/ets_megamenu.php:3505 (displayMenuFrontend) /classes/Hook.php:1043 (hookDisplayNavFullWidth) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:418 (coreCallHook) /classes/Hook.php:981 (callHookOn) /config/smarty.config.inc.php:198 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/prod/smarty/compile/v1_electron_1layouts_layout_left_column_tpl/1e/d1/c2/1ed1c2bd038ee59c289bc0dfa862939f4ace5853_2.file.header.tpl.php:61 (__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/1e/d1/c2/1ed1c2bd038ee59c289bc0dfa862939f4ace5853_2.file.header.tpl.php:29 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68816b9b73ee58_88544922) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php: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/7b/20/9b/7b209b8ad3a4b959ee700fbabff63490fd8dfb7e_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/7b/20/9b/7b209b8ad3a4b959ee700fbabff63490fd8dfb7e_2.file.layout-both-columns.tpl.php:64 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68816b9b6d7dd3_62298143) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php: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/59/27/34/592734f8f890bb342f82010dedfdefdfb102af18_2.file.layout-left-column.tpl.php:28 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68816b9b6b85a3_55565069) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php: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/89/73/cd/8973cd33287e2cbf8397bbeb9d03e6e024e12e8e_2.file.product-list.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68816b9b6b26f3_29067136) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php: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/ad/e7/9e/ade79eb0f0f9f51d33a9ae668beef9fcff755b39_2.file.category.tpl.php:29 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68816b9b6a1a00_79340852) /vendor/smarty/smarty/libs/sysplugins/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:753 (fetch) /classes/controller/FrontController.php:735 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
77	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 mb_product p LEFT JOIN mb_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mb_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN mb_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN mb_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN mb_category_product cp ON (p.id_product = cp.id_product) INNER JOIN mb_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN mb_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN mb_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN mb_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN mb_feature_product fp_1 ON (p.id_product = fp_1.id_product) WHERE ((fp.id_feature_value IN (142, 43, 45))) AND ((fp_1.id_feature_value IN (27134, 27321, 26982, 19884, 27466, 24878, 27323, 26988, 27472, 27145, 25062, 27341, 26994, 25071, 27347, 27000, 28003, 27158, 27356, 27011, 26793, 27362, 27019, 27120, 26937, 27389, 27124, 26940, 27392, 27126, 26955, 19635, 27395, 27128, 23731, 27317, 26964, 19641, 27131, 27319, 26973, 19880, 14709, 27889, 18376, 18595, 26253, 21638, 21800, 27178, 17397, 22374, 14366, 24605, 222, 11784, 27141, 20899, 27534, 27935, 27111, 21056, 27688, 27032, 27042, 14362, 27056, 27087, 27093, 27908))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=188 AND c.nright<=195 GROUP BY p.id_product) p LEFT JOIN mb_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN mb_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((p.on_sale=1)) AND ((fp_1.id_feature_value IN (142, 43, 45))) AND ((fp_2.id_feature_value IN (27134, 27321, 26982, 19884, 27466, 24878, 27323, 26988, 27472, 27145, 25062, 27341, 26994, 25071, 27347, 27000, 28003, 27158, 27356, 27011, 26793, 27362, 27019, 27120, 26937, 27389, 27124, 26940, 27392, 27126, 26955, 19635, 27395, 27128, 23731, 27317, 26964, 19641, 27131, 27319, 26973, 19880, 14709, 27889, 18376, 18595, 26253, 21638, 21800, 27178, 17397, 22374, 14366, 24605, 222, 11784, 27141, 20899, 27534, 27935, 27111, 21056, 27688, 27032, 27042, 14362, 27056, 27087, 27093, 27908)))	9.647 ms	1584		/modules/ps_facetedsearch/src/Adapter/MySQL.php:86 /modules/ps_facetedsearch/src/Adapter/MySQL.php:786 (execute) /modules/ps_facetedsearch/src/Adapter/MySQL.php:764 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:565 (count) /modules/ps_facetedsearch/src/Filters/Block.php:143 (getHighlightsBlock) /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:138 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
91	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 mb_product p LEFT JOIN mb_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mb_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN mb_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN mb_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN mb_category_product cp ON (p.id_product = cp.id_product) INNER JOIN mb_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN mb_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN mb_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN mb_feature_product fp ON (p.id_product = fp.id_product) WHERE ((fp.id_feature_value IN (27134, 27321, 26982, 19884, 27466, 24878, 27323, 26988, 27472, 27145, 25062, 27341, 26994, 25071, 27347, 27000, 28003, 27158, 27356, 27011, 26793, 27362, 27019, 27120, 26937, 27389, 27124, 26940, 27392, 27126, 26955, 19635, 27395, 27128, 23731, 27317, 26964, 19641, 27131, 27319, 26973, 19880, 14709, 27889, 18376, 18595, 26253, 21638, 21800, 27178, 17397, 22374, 14366, 24605, 222, 11784, 27141, 20899, 27534, 27935, 27111, 21056, 27688, 27032, 27042, 14362, 27056, 27087, 27093, 27908))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=188 AND c.nright<=195 GROUP BY p.id_product) p INNER JOIN mb_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN mb_feature_product fp_1 ON (p.id_product = fp_1.id_product) WHERE ((fp.id_feature=3)) AND ((fp_1.id_feature_value IN (27134, 27321, 26982, 19884, 27466, 24878, 27323, 26988, 27472, 27145, 25062, 27341, 26994, 25071, 27347, 27000, 28003, 27158, 27356, 27011, 26793, 27362, 27019, 27120, 26937, 27389, 27124, 26940, 27392, 27126, 26955, 19635, 27395, 27128, 23731, 27317, 26964, 19641, 27131, 27319, 26973, 19880, 14709, 27889, 18376, 18595, 26253, 21638, 21800, 27178, 17397, 22374, 14366, 24605, 222, 11784, 27141, 20899, 27534, 27935, 27111, 21056, 27688, 27032, 27042, 14362, 27056, 27087, 27093, 27908))) GROUP BY fp.id_feature_value	9.102 ms	19602	Yes	/modules/ps_facetedsearch/src/Adapter/MySQL.php:86 /modules/ps_facetedsearch/src/Adapter/MySQL.php:786 (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:138 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
76	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 mb_product p LEFT JOIN mb_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mb_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN mb_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN mb_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN mb_category_product cp ON (p.id_product = cp.id_product) INNER JOIN mb_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN mb_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN mb_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN mb_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN mb_feature_product fp_1 ON (p.id_product = fp_1.id_product) WHERE ((fp.id_feature_value IN (142, 43, 45))) AND ((fp_1.id_feature_value IN (27134, 27321, 26982, 19884, 27466, 24878, 27323, 26988, 27472, 27145, 25062, 27341, 26994, 25071, 27347, 27000, 28003, 27158, 27356, 27011, 26793, 27362, 27019, 27120, 26937, 27389, 27124, 26940, 27392, 27126, 26955, 19635, 27395, 27128, 23731, 27317, 26964, 19641, 27131, 27319, 26973, 19880, 14709, 27889, 18376, 18595, 26253, 21638, 21800, 27178, 17397, 22374, 14366, 24605, 222, 11784, 27141, 20899, 27534, 27935, 27111, 21056, 27688, 27032, 27042, 14362, 27056, 27087, 27093, 27908))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=188 AND c.nright<=195 GROUP BY p.id_product) p INNER JOIN mb_category_product cp ON (p.id_product = cp.id_product) INNER JOIN mb_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN mb_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN mb_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN mb_feature_product fp_1 ON (p.id_product = fp_1.id_product) WHERE ((fp.id_feature_value IN (142, 43, 45))) AND ((fp_1.id_feature_value IN (27134, 27321, 26982, 19884, 27466, 24878, 27323, 26988, 27472, 27145, 25062, 27341, 26994, 25071, 27347, 27000, 28003, 27158, 27356, 27011, 26793, 27362, 27019, 27120, 26937, 27389, 27124, 26940, 27392, 27126, 26955, 19635, 27395, 27128, 23731, 27317, 26964, 19641, 27131, 27319, 26973, 19880, 14709, 27889, 18376, 18595, 26253, 21638, 21800, 27178, 17397, 22374, 14366, 24605, 222, 11784, 27141, 20899, 27534, 27935, 27111, 21056, 27688, 27032, 27042, 14362, 27056, 27087, 27093, 27908))) AND cg.id_group='1' AND c.level_depth<=4 AND c.nleft>188 AND c.nright<195 GROUP BY cp.id_category	8.800 ms	156816	Yes	/modules/ps_facetedsearch/src/Adapter/MySQL.php:86 /modules/ps_facetedsearch/src/Adapter/MySQL.php:786 (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:138 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
78	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 mb_product p LEFT JOIN mb_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mb_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN mb_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN mb_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN mb_category_product cp ON (p.id_product = cp.id_product) INNER JOIN mb_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN mb_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN mb_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN mb_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN mb_feature_product fp_1 ON (p.id_product = fp_1.id_product) WHERE ((fp.id_feature_value IN (142, 43, 45))) AND ((fp_1.id_feature_value IN (27134, 27321, 26982, 19884, 27466, 24878, 27323, 26988, 27472, 27145, 25062, 27341, 26994, 25071, 27347, 27000, 28003, 27158, 27356, 27011, 26793, 27362, 27019, 27120, 26937, 27389, 27124, 26940, 27392, 27126, 26955, 19635, 27395, 27128, 23731, 27317, 26964, 19641, 27131, 27319, 26973, 19880, 14709, 27889, 18376, 18595, 26253, 21638, 21800, 27178, 17397, 22374, 14366, 24605, 222, 11784, 27141, 20899, 27534, 27935, 27111, 21056, 27688, 27032, 27042, 14362, 27056, 27087, 27093, 27908))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=188 AND c.nright<=195 GROUP BY p.id_product) p LEFT JOIN mb_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN mb_feature_product fp_1 ON (p.id_product = fp_1.id_product) WHERE ((fp.id_feature_value IN (142, 43, 45))) AND ((fp_1.id_feature_value IN (27134, 27321, 26982, 19884, 27466, 24878, 27323, 26988, 27472, 27145, 25062, 27341, 26994, 25071, 27347, 27000, 28003, 27158, 27356, 27011, 26793, 27362, 27019, 27120, 26937, 27389, 27124, 26940, 27392, 27126, 26955, 19635, 27395, 27128, 23731, 27317, 26964, 19641, 27131, 27319, 26973, 19880, 14709, 27889, 18376, 18595, 26253, 21638, 21800, 27178, 17397, 22374, 14366, 24605, 222, 11784, 27141, 20899, 27534, 27935, 27111, 21056, 27688, 27032, 27042, 14362, 27056, 27087, 27093, 27908))) AND p.date_add>'2022-11-02 00:00:00'	7.234 ms	1584		/modules/ps_facetedsearch/src/Adapter/MySQL.php:86 /modules/ps_facetedsearch/src/Adapter/MySQL.php:786 (execute) /modules/ps_facetedsearch/src/Adapter/MySQL.php:764 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:587 (count) /modules/ps_facetedsearch/src/Filters/Block.php:143 (getHighlightsBlock) /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:138 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
93	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 mb_product p LEFT JOIN mb_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mb_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN mb_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN mb_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN mb_category_product cp ON (p.id_product = cp.id_product) INNER JOIN mb_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN mb_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN mb_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN mb_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN mb_feature_product fp_1 ON (p.id_product = fp_1.id_product) WHERE ((fp.id_feature_value IN (142, 43, 45))) AND ((fp_1.id_feature_value IN (27134, 27321, 26982, 19884, 27466, 24878, 27323, 26988, 27472, 27145, 25062, 27341, 26994, 25071, 27347, 27000, 28003, 27158, 27356, 27011, 26793, 27362, 27019, 27120, 26937, 27389, 27124, 26940, 27392, 27126, 26955, 19635, 27395, 27128, 23731, 27317, 26964, 19641, 27131, 27319, 26973, 19880, 14709, 27889, 18376, 18595, 26253, 21638, 21800, 27178, 17397, 22374, 14366, 24605, 222, 11784, 27141, 20899, 27534, 27935, 27111, 21056, 27688, 27032, 27042, 14362, 27056, 27087, 27093, 27908))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=188 AND c.nright<=195 GROUP BY p.id_product) p INNER JOIN mb_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN mb_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN mb_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((fp.id_feature=4)) AND ((fp_1.id_feature_value IN (142, 43, 45))) AND ((fp_2.id_feature_value IN (27134, 27321, 26982, 19884, 27466, 24878, 27323, 26988, 27472, 27145, 25062, 27341, 26994, 25071, 27347, 27000, 28003, 27158, 27356, 27011, 26793, 27362, 27019, 27120, 26937, 27389, 27124, 26940, 27392, 27126, 26955, 19635, 27395, 27128, 23731, 27317, 26964, 19641, 27131, 27319, 26973, 19880, 14709, 27889, 18376, 18595, 26253, 21638, 21800, 27178, 17397, 22374, 14366, 24605, 222, 11784, 27141, 20899, 27534, 27935, 27111, 21056, 27688, 27032, 27042, 14362, 27056, 27087, 27093, 27908))) GROUP BY fp.id_feature_value	6.131 ms	156816	Yes	/modules/ps_facetedsearch/src/Adapter/MySQL.php:86 /modules/ps_facetedsearch/src/Adapter/MySQL.php:786 (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:138 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
81	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 mb_product p LEFT JOIN mb_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mb_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN mb_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN mb_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN mb_category_product cp ON (p.id_product = cp.id_product) INNER JOIN mb_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN mb_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN mb_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN mb_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN mb_feature_product fp_1 ON (p.id_product = fp_1.id_product) WHERE ((fp.id_feature_value IN (142, 43, 45))) AND ((fp_1.id_feature_value IN (27134, 27321, 26982, 19884, 27466, 24878, 27323, 26988, 27472, 27145, 25062, 27341, 26994, 25071, 27347, 27000, 28003, 27158, 27356, 27011, 26793, 27362, 27019, 27120, 26937, 27389, 27124, 26940, 27392, 27126, 26955, 19635, 27395, 27128, 23731, 27317, 26964, 19641, 27131, 27319, 26973, 19880, 14709, 27889, 18376, 18595, 26253, 21638, 21800, 27178, 17397, 22374, 14366, 24605, 222, 11784, 27141, 20899, 27534, 27935, 27111, 21056, 27688, 27032, 27042, 14362, 27056, 27087, 27093, 27908))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=188 AND c.nright<=195 GROUP BY p.id_product) p LEFT JOIN mb_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN mb_feature_product fp_1 ON (p.id_product = fp_1.id_product) WHERE ((fp.id_feature_value IN (142, 43, 45))) AND ((fp_1.id_feature_value IN (27134, 27321, 26982, 19884, 27466, 24878, 27323, 26988, 27472, 27145, 25062, 27341, 26994, 25071, 27347, 27000, 28003, 27158, 27356, 27011, 26793, 27362, 27019, 27120, 26937, 27389, 27124, 26940, 27392, 27126, 26955, 19635, 27395, 27128, 23731, 27317, 26964, 19641, 27131, 27319, 26973, 19880, 14709, 27889, 18376, 18595, 26253, 21638, 21800, 27178, 17397, 22374, 14366, 24605, 222, 11784, 27141, 20899, 27534, 27935, 27111, 21056, 27688, 27032, 27042, 14362, 27056, 27087, 27093, 27908))) GROUP BY p.id_manufacturer	5.702 ms	1584	Yes	/modules/ps_facetedsearch/src/Adapter/MySQL.php:86 /modules/ps_facetedsearch/src/Adapter/MySQL.php:786 (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:138 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
94	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 mb_product p LEFT JOIN mb_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mb_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN mb_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN mb_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN mb_category_product cp ON (p.id_product = cp.id_product) INNER JOIN mb_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN mb_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN mb_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN mb_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN mb_feature_product fp_1 ON (p.id_product = fp_1.id_product) WHERE ((fp.id_feature_value IN (142, 43, 45))) AND ((fp_1.id_feature_value IN (27134, 27321, 26982, 19884, 27466, 24878, 27323, 26988, 27472, 27145, 25062, 27341, 26994, 25071, 27347, 27000, 28003, 27158, 27356, 27011, 26793, 27362, 27019, 27120, 26937, 27389, 27124, 26940, 27392, 27126, 26955, 19635, 27395, 27128, 23731, 27317, 26964, 19641, 27131, 27319, 26973, 19880, 14709, 27889, 18376, 18595, 26253, 21638, 21800, 27178, 17397, 22374, 14366, 24605, 222, 11784, 27141, 20899, 27534, 27935, 27111, 21056, 27688, 27032, 27042, 14362, 27056, 27087, 27093, 27908))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=188 AND c.nright<=195 GROUP BY p.id_product) p INNER JOIN mb_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN mb_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN mb_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((fp.id_feature=5)) AND ((fp_1.id_feature_value IN (142, 43, 45))) AND ((fp_2.id_feature_value IN (27134, 27321, 26982, 19884, 27466, 24878, 27323, 26988, 27472, 27145, 25062, 27341, 26994, 25071, 27347, 27000, 28003, 27158, 27356, 27011, 26793, 27362, 27019, 27120, 26937, 27389, 27124, 26940, 27392, 27126, 26955, 19635, 27395, 27128, 23731, 27317, 26964, 19641, 27131, 27319, 26973, 19880, 14709, 27889, 18376, 18595, 26253, 21638, 21800, 27178, 17397, 22374, 14366, 24605, 222, 11784, 27141, 20899, 27534, 27935, 27111, 21056, 27688, 27032, 27042, 14362, 27056, 27087, 27093, 27908))) GROUP BY fp.id_feature_value	5.685 ms	2112	Yes	/modules/ps_facetedsearch/src/Adapter/MySQL.php:86 /modules/ps_facetedsearch/src/Adapter/MySQL.php:786 (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:138 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
84	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 mb_product p LEFT JOIN mb_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mb_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN mb_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN mb_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN mb_category_product cp ON (p.id_product = cp.id_product) INNER JOIN mb_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN mb_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN mb_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN mb_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN mb_feature_product fp_1 ON (p.id_product = fp_1.id_product) WHERE ((fp.id_feature_value IN (142, 43, 45))) AND ((fp_1.id_feature_value IN (27134, 27321, 26982, 19884, 27466, 24878, 27323, 26988, 27472, 27145, 25062, 27341, 26994, 25071, 27347, 27000, 28003, 27158, 27356, 27011, 26793, 27362, 27019, 27120, 26937, 27389, 27124, 26940, 27392, 27126, 26955, 19635, 27395, 27128, 23731, 27317, 26964, 19641, 27131, 27319, 26973, 19880, 14709, 27889, 18376, 18595, 26253, 21638, 21800, 27178, 17397, 22374, 14366, 24605, 222, 11784, 27141, 20899, 27534, 27935, 27111, 21056, 27688, 27032, 27042, 14362, 27056, 27087, 27093, 27908))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=188 AND c.nright<=195 GROUP BY p.id_product) p LEFT JOIN mb_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mb_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) INNER JOIN mb_attribute a ON (a.id_attribute = pac.id_attribute) LEFT JOIN mb_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN mb_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((a.id_attribute_group=3)) AND ((fp_1.id_feature_value IN (142, 43, 45))) AND ((fp_2.id_feature_value IN (27134, 27321, 26982, 19884, 27466, 24878, 27323, 26988, 27472, 27145, 25062, 27341, 26994, 25071, 27347, 27000, 28003, 27158, 27356, 27011, 26793, 27362, 27019, 27120, 26937, 27389, 27124, 26940, 27392, 27126, 26955, 19635, 27395, 27128, 23731, 27317, 26964, 19641, 27131, 27319, 26973, 19880, 14709, 27889, 18376, 18595, 26253, 21638, 21800, 27178, 17397, 22374, 14366, 24605, 222, 11784, 27141, 20899, 27534, 27935, 27111, 21056, 27688, 27032, 27042, 14362, 27056, 27087, 27093, 27908))) GROUP BY pac.id_attribute	5.385 ms	156816	Yes	/modules/ps_facetedsearch/src/Adapter/MySQL.php:86 /modules/ps_facetedsearch/src/Adapter/MySQL.php:786 (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:138 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
87	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 mb_product p LEFT JOIN mb_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mb_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN mb_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN mb_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN mb_category_product cp ON (p.id_product = cp.id_product) INNER JOIN mb_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN mb_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN mb_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN mb_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN mb_feature_product fp_1 ON (p.id_product = fp_1.id_product) WHERE ((fp.id_feature_value IN (142, 43, 45))) AND ((fp_1.id_feature_value IN (27134, 27321, 26982, 19884, 27466, 24878, 27323, 26988, 27472, 27145, 25062, 27341, 26994, 25071, 27347, 27000, 28003, 27158, 27356, 27011, 26793, 27362, 27019, 27120, 26937, 27389, 27124, 26940, 27392, 27126, 26955, 19635, 27395, 27128, 23731, 27317, 26964, 19641, 27131, 27319, 26973, 19880, 14709, 27889, 18376, 18595, 26253, 21638, 21800, 27178, 17397, 22374, 14366, 24605, 222, 11784, 27141, 20899, 27534, 27935, 27111, 21056, 27688, 27032, 27042, 14362, 27056, 27087, 27093, 27908))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=188 AND c.nright<=195 GROUP BY p.id_product) p INNER JOIN mb_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN mb_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN mb_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((fp.id_feature=1)) AND ((fp_1.id_feature_value IN (142, 43, 45))) AND ((fp_2.id_feature_value IN (27134, 27321, 26982, 19884, 27466, 24878, 27323, 26988, 27472, 27145, 25062, 27341, 26994, 25071, 27347, 27000, 28003, 27158, 27356, 27011, 26793, 27362, 27019, 27120, 26937, 27389, 27124, 26940, 27392, 27126, 26955, 19635, 27395, 27128, 23731, 27317, 26964, 19641, 27131, 27319, 26973, 19880, 14709, 27889, 18376, 18595, 26253, 21638, 21800, 27178, 17397, 22374, 14366, 24605, 222, 11784, 27141, 20899, 27534, 27935, 27111, 21056, 27688, 27032, 27042, 14362, 27056, 27087, 27093, 27908))) GROUP BY fp.id_feature_value	5.377 ms	156816	Yes	/modules/ps_facetedsearch/src/Adapter/MySQL.php:86 /modules/ps_facetedsearch/src/Adapter/MySQL.php:786 (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:138 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
89	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 mb_product p LEFT JOIN mb_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mb_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN mb_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN mb_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN mb_category_product cp ON (p.id_product = cp.id_product) INNER JOIN mb_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN mb_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN mb_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN mb_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN mb_feature_product fp_1 ON (p.id_product = fp_1.id_product) WHERE ((fp.id_feature_value IN (142, 43, 45))) AND ((fp_1.id_feature_value IN (27134, 27321, 26982, 19884, 27466, 24878, 27323, 26988, 27472, 27145, 25062, 27341, 26994, 25071, 27347, 27000, 28003, 27158, 27356, 27011, 26793, 27362, 27019, 27120, 26937, 27389, 27124, 26940, 27392, 27126, 26955, 19635, 27395, 27128, 23731, 27317, 26964, 19641, 27131, 27319, 26973, 19880, 14709, 27889, 18376, 18595, 26253, 21638, 21800, 27178, 17397, 22374, 14366, 24605, 222, 11784, 27141, 20899, 27534, 27935, 27111, 21056, 27688, 27032, 27042, 14362, 27056, 27087, 27093, 27908))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=188 AND c.nright<=195 GROUP BY p.id_product) p INNER JOIN mb_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN mb_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN mb_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((fp.id_feature=2)) AND ((fp_1.id_feature_value IN (142, 43, 45))) AND ((fp_2.id_feature_value IN (27134, 27321, 26982, 19884, 27466, 24878, 27323, 26988, 27472, 27145, 25062, 27341, 26994, 25071, 27347, 27000, 28003, 27158, 27356, 27011, 26793, 27362, 27019, 27120, 26937, 27389, 27124, 26940, 27392, 27126, 26955, 19635, 27395, 27128, 23731, 27317, 26964, 19641, 27131, 27319, 26973, 19880, 14709, 27889, 18376, 18595, 26253, 21638, 21800, 27178, 17397, 22374, 14366, 24605, 222, 11784, 27141, 20899, 27534, 27935, 27111, 21056, 27688, 27032, 27042, 14362, 27056, 27087, 27093, 27908))) GROUP BY fp.id_feature_value	4.317 ms	156816	Yes	/modules/ps_facetedsearch/src/Adapter/MySQL.php:86 /modules/ps_facetedsearch/src/Adapter/MySQL.php:786 (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:138 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
98	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 mb_product p LEFT JOIN mb_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mb_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN mb_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN mb_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN mb_category_product cp ON (p.id_product = cp.id_product) INNER JOIN mb_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN mb_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN mb_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN mb_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN mb_feature_product fp_1 ON (p.id_product = fp_1.id_product) WHERE ((fp.id_feature_value IN (142, 43, 45))) AND ((fp_1.id_feature_value IN (27134, 27321, 26982, 19884, 27466, 24878, 27323, 26988, 27472, 27145, 25062, 27341, 26994, 25071, 27347, 27000, 28003, 27158, 27356, 27011, 26793, 27362, 27019, 27120, 26937, 27389, 27124, 26940, 27392, 27126, 26955, 19635, 27395, 27128, 23731, 27317, 26964, 19641, 27131, 27319, 26973, 19880, 14709, 27889, 18376, 18595, 26253, 21638, 21800, 27178, 17397, 22374, 14366, 24605, 222, 11784, 27141, 20899, 27534, 27935, 27111, 21056, 27688, 27032, 27042, 14362, 27056, 27087, 27093, 27908))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=188 AND c.nright<=195 GROUP BY p.id_product) p INNER JOIN mb_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN mb_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN mb_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((fp.id_feature=8)) AND ((fp_1.id_feature_value IN (142, 43, 45))) AND ((fp_2.id_feature_value IN (27134, 27321, 26982, 19884, 27466, 24878, 27323, 26988, 27472, 27145, 25062, 27341, 26994, 25071, 27347, 27000, 28003, 27158, 27356, 27011, 26793, 27362, 27019, 27120, 26937, 27389, 27124, 26940, 27392, 27126, 26955, 19635, 27395, 27128, 23731, 27317, 26964, 19641, 27131, 27319, 26973, 19880, 14709, 27889, 18376, 18595, 26253, 21638, 21800, 27178, 17397, 22374, 14366, 24605, 222, 11784, 27141, 20899, 27534, 27935, 27111, 21056, 27688, 27032, 27042, 14362, 27056, 27087, 27093, 27908))) GROUP BY fp.id_feature_value	4.300 ms	156816	Yes	/modules/ps_facetedsearch/src/Adapter/MySQL.php:86 /modules/ps_facetedsearch/src/Adapter/MySQL.php:786 (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:138 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
106	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 mb_product p LEFT JOIN mb_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mb_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN mb_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN mb_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN mb_category_product cp ON (p.id_product = cp.id_product) INNER JOIN mb_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN mb_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN mb_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN mb_feature_product fp ON (p.id_product = fp.id_product) WHERE ((fp.id_feature_value IN (142, 43, 45))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=188 AND c.nright<=195 GROUP BY p.id_product) p INNER JOIN mb_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN mb_feature_product fp_1 ON (p.id_product = fp_1.id_product) WHERE ((fp.id_feature=15)) AND ((fp_1.id_feature_value IN (142, 43, 45))) GROUP BY fp.id_feature_value	4.187 ms	45000	Yes	/modules/ps_facetedsearch/src/Adapter/MySQL.php:86 /modules/ps_facetedsearch/src/Adapter/MySQL.php:786 (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:138 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
119	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 mb_product p LEFT JOIN mb_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mb_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN mb_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN mb_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN mb_category_product cp ON (p.id_product = cp.id_product) INNER JOIN mb_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN mb_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN mb_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN mb_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN mb_feature_product fp_1 ON (p.id_product = fp_1.id_product) WHERE ((fp.id_feature_value IN (142, 43, 45))) AND ((fp_1.id_feature_value IN (27134, 27321, 26982, 19884, 27466, 24878, 27323, 26988, 27472, 27145, 25062, 27341, 26994, 25071, 27347, 27000, 28003, 27158, 27356, 27011, 26793, 27362, 27019, 27120, 26937, 27389, 27124, 26940, 27392, 27126, 26955, 19635, 27395, 27128, 23731, 27317, 26964, 19641, 27131, 27319, 26973, 19880, 14709, 27889, 18376, 18595, 26253, 21638, 21800, 27178, 17397, 22374, 14366, 24605, 222, 11784, 27141, 20899, 27534, 27935, 27111, 21056, 27688, 27032, 27042, 14362, 27056, 27087, 27093, 27908))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=188 AND c.nright<=195 GROUP BY p.id_product) p INNER JOIN mb_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN mb_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN mb_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((fp.id_feature=28)) AND ((fp_1.id_feature_value IN (142, 43, 45))) AND ((fp_2.id_feature_value IN (27134, 27321, 26982, 19884, 27466, 24878, 27323, 26988, 27472, 27145, 25062, 27341, 26994, 25071, 27347, 27000, 28003, 27158, 27356, 27011, 26793, 27362, 27019, 27120, 26937, 27389, 27124, 26940, 27392, 27126, 26955, 19635, 27395, 27128, 23731, 27317, 26964, 19641, 27131, 27319, 26973, 19880, 14709, 27889, 18376, 18595, 26253, 21638, 21800, 27178, 17397, 22374, 14366, 24605, 222, 11784, 27141, 20899, 27534, 27935, 27111, 21056, 27688, 27032, 27042, 14362, 27056, 27087, 27093, 27908))) GROUP BY fp.id_feature_value	4.105 ms	156816	Yes	/modules/ps_facetedsearch/src/Adapter/MySQL.php:86 /modules/ps_facetedsearch/src/Adapter/MySQL.php:786 (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:138 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
120	SELECT SQL_NO_CACHE fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM mb_product p LEFT JOIN mb_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mb_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN mb_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN mb_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN mb_category_product cp ON (p.id_product = cp.id_product) INNER JOIN mb_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN mb_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN mb_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN mb_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN mb_feature_product fp_1 ON (p.id_product = fp_1.id_product) WHERE ((fp.id_feature_value IN (142, 43, 45))) AND ((fp_1.id_feature_value IN (27134, 27321, 26982, 19884, 27466, 24878, 27323, 26988, 27472, 27145, 25062, 27341, 26994, 25071, 27347, 27000, 28003, 27158, 27356, 27011, 26793, 27362, 27019, 27120, 26937, 27389, 27124, 26940, 27392, 27126, 26955, 19635, 27395, 27128, 23731, 27317, 26964, 19641, 27131, 27319, 26973, 19880, 14709, 27889, 18376, 18595, 26253, 21638, 21800, 27178, 17397, 22374, 14366, 24605, 222, 11784, 27141, 20899, 27534, 27935, 27111, 21056, 27688, 27032, 27042, 14362, 27056, 27087, 27093, 27908))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=188 AND c.nright<=195 GROUP BY p.id_product) p INNER JOIN mb_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN mb_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN mb_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((fp.id_feature=29)) AND ((fp_1.id_feature_value IN (142, 43, 45))) AND ((fp_2.id_feature_value IN (27134, 27321, 26982, 19884, 27466, 24878, 27323, 26988, 27472, 27145, 25062, 27341, 26994, 25071, 27347, 27000, 28003, 27158, 27356, 27011, 26793, 27362, 27019, 27120, 26937, 27389, 27124, 26940, 27392, 27126, 26955, 19635, 27395, 27128, 23731, 27317, 26964, 19641, 27131, 27319, 26973, 19880, 14709, 27889, 18376, 18595, 26253, 21638, 21800, 27178, 17397, 22374, 14366, 24605, 222, 11784, 27141, 20899, 27534, 27935, 27111, 21056, 27688, 27032, 27042, 14362, 27056, 27087, 27093, 27908))) GROUP BY fp.id_feature_value	3.997 ms	156816	Yes	/modules/ps_facetedsearch/src/Adapter/MySQL.php:86 /modules/ps_facetedsearch/src/Adapter/MySQL.php:786 (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:138 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
117	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 mb_product p LEFT JOIN mb_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mb_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN mb_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN mb_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN mb_category_product cp ON (p.id_product = cp.id_product) INNER JOIN mb_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN mb_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN mb_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN mb_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN mb_feature_product fp_1 ON (p.id_product = fp_1.id_product) WHERE ((fp.id_feature_value IN (142, 43, 45))) AND ((fp_1.id_feature_value IN (27134, 27321, 26982, 19884, 27466, 24878, 27323, 26988, 27472, 27145, 25062, 27341, 26994, 25071, 27347, 27000, 28003, 27158, 27356, 27011, 26793, 27362, 27019, 27120, 26937, 27389, 27124, 26940, 27392, 27126, 26955, 19635, 27395, 27128, 23731, 27317, 26964, 19641, 27131, 27319, 26973, 19880, 14709, 27889, 18376, 18595, 26253, 21638, 21800, 27178, 17397, 22374, 14366, 24605, 222, 11784, 27141, 20899, 27534, 27935, 27111, 21056, 27688, 27032, 27042, 14362, 27056, 27087, 27093, 27908))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=188 AND c.nright<=195 GROUP BY p.id_product) p INNER JOIN mb_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN mb_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN mb_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((fp.id_feature=24)) AND ((fp_1.id_feature_value IN (142, 43, 45))) AND ((fp_2.id_feature_value IN (27134, 27321, 26982, 19884, 27466, 24878, 27323, 26988, 27472, 27145, 25062, 27341, 26994, 25071, 27347, 27000, 28003, 27158, 27356, 27011, 26793, 27362, 27019, 27120, 26937, 27389, 27124, 26940, 27392, 27126, 26955, 19635, 27395, 27128, 23731, 27317, 26964, 19641, 27131, 27319, 26973, 19880, 14709, 27889, 18376, 18595, 26253, 21638, 21800, 27178, 17397, 22374, 14366, 24605, 222, 11784, 27141, 20899, 27534, 27935, 27111, 21056, 27688, 27032, 27042, 14362, 27056, 27087, 27093, 27908))) GROUP BY fp.id_feature_value	3.898 ms	156816	Yes	/modules/ps_facetedsearch/src/Adapter/MySQL.php:86 /modules/ps_facetedsearch/src/Adapter/MySQL.php:786 (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:138 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
108	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 mb_product p LEFT JOIN mb_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mb_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN mb_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN mb_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN mb_category_product cp ON (p.id_product = cp.id_product) INNER JOIN mb_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN mb_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN mb_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN mb_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN mb_feature_product fp_1 ON (p.id_product = fp_1.id_product) WHERE ((fp.id_feature_value IN (142, 43, 45))) AND ((fp_1.id_feature_value IN (27134, 27321, 26982, 19884, 27466, 24878, 27323, 26988, 27472, 27145, 25062, 27341, 26994, 25071, 27347, 27000, 28003, 27158, 27356, 27011, 26793, 27362, 27019, 27120, 26937, 27389, 27124, 26940, 27392, 27126, 26955, 19635, 27395, 27128, 23731, 27317, 26964, 19641, 27131, 27319, 26973, 19880, 14709, 27889, 18376, 18595, 26253, 21638, 21800, 27178, 17397, 22374, 14366, 24605, 222, 11784, 27141, 20899, 27534, 27935, 27111, 21056, 27688, 27032, 27042, 14362, 27056, 27087, 27093, 27908))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=188 AND c.nright<=195 GROUP BY p.id_product) p INNER JOIN mb_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN mb_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN mb_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((fp.id_feature=16)) AND ((fp_1.id_feature_value IN (142, 43, 45))) AND ((fp_2.id_feature_value IN (27134, 27321, 26982, 19884, 27466, 24878, 27323, 26988, 27472, 27145, 25062, 27341, 26994, 25071, 27347, 27000, 28003, 27158, 27356, 27011, 26793, 27362, 27019, 27120, 26937, 27389, 27124, 26940, 27392, 27126, 26955, 19635, 27395, 27128, 23731, 27317, 26964, 19641, 27131, 27319, 26973, 19880, 14709, 27889, 18376, 18595, 26253, 21638, 21800, 27178, 17397, 22374, 14366, 24605, 222, 11784, 27141, 20899, 27534, 27935, 27111, 21056, 27688, 27032, 27042, 14362, 27056, 27087, 27093, 27908))) GROUP BY fp.id_feature_value	3.850 ms	156816	Yes	/modules/ps_facetedsearch/src/Adapter/MySQL.php:86 /modules/ps_facetedsearch/src/Adapter/MySQL.php:786 (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:138 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
112	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 mb_product p LEFT JOIN mb_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mb_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN mb_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN mb_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN mb_category_product cp ON (p.id_product = cp.id_product) INNER JOIN mb_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN mb_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN mb_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN mb_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN mb_feature_product fp_1 ON (p.id_product = fp_1.id_product) WHERE ((fp.id_feature_value IN (142, 43, 45))) AND ((fp_1.id_feature_value IN (27134, 27321, 26982, 19884, 27466, 24878, 27323, 26988, 27472, 27145, 25062, 27341, 26994, 25071, 27347, 27000, 28003, 27158, 27356, 27011, 26793, 27362, 27019, 27120, 26937, 27389, 27124, 26940, 27392, 27126, 26955, 19635, 27395, 27128, 23731, 27317, 26964, 19641, 27131, 27319, 26973, 19880, 14709, 27889, 18376, 18595, 26253, 21638, 21800, 27178, 17397, 22374, 14366, 24605, 222, 11784, 27141, 20899, 27534, 27935, 27111, 21056, 27688, 27032, 27042, 14362, 27056, 27087, 27093, 27908))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=188 AND c.nright<=195 GROUP BY p.id_product) p INNER JOIN mb_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN mb_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN mb_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((fp.id_feature=19)) AND ((fp_1.id_feature_value IN (142, 43, 45))) AND ((fp_2.id_feature_value IN (27134, 27321, 26982, 19884, 27466, 24878, 27323, 26988, 27472, 27145, 25062, 27341, 26994, 25071, 27347, 27000, 28003, 27158, 27356, 27011, 26793, 27362, 27019, 27120, 26937, 27389, 27124, 26940, 27392, 27126, 26955, 19635, 27395, 27128, 23731, 27317, 26964, 19641, 27131, 27319, 26973, 19880, 14709, 27889, 18376, 18595, 26253, 21638, 21800, 27178, 17397, 22374, 14366, 24605, 222, 11784, 27141, 20899, 27534, 27935, 27111, 21056, 27688, 27032, 27042, 14362, 27056, 27087, 27093, 27908))) GROUP BY fp.id_feature_value	3.828 ms	156816	Yes	/modules/ps_facetedsearch/src/Adapter/MySQL.php:86 /modules/ps_facetedsearch/src/Adapter/MySQL.php:786 (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:138 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
102	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 mb_product p LEFT JOIN mb_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mb_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN mb_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN mb_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN mb_category_product cp ON (p.id_product = cp.id_product) INNER JOIN mb_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN mb_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN mb_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN mb_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN mb_feature_product fp_1 ON (p.id_product = fp_1.id_product) WHERE ((fp.id_feature_value IN (142, 43, 45))) AND ((fp_1.id_feature_value IN (27134, 27321, 26982, 19884, 27466, 24878, 27323, 26988, 27472, 27145, 25062, 27341, 26994, 25071, 27347, 27000, 28003, 27158, 27356, 27011, 26793, 27362, 27019, 27120, 26937, 27389, 27124, 26940, 27392, 27126, 26955, 19635, 27395, 27128, 23731, 27317, 26964, 19641, 27131, 27319, 26973, 19880, 14709, 27889, 18376, 18595, 26253, 21638, 21800, 27178, 17397, 22374, 14366, 24605, 222, 11784, 27141, 20899, 27534, 27935, 27111, 21056, 27688, 27032, 27042, 14362, 27056, 27087, 27093, 27908))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=188 AND c.nright<=195 GROUP BY p.id_product) p INNER JOIN mb_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN mb_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN mb_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((fp.id_feature=12)) AND ((fp_1.id_feature_value IN (142, 43, 45))) AND ((fp_2.id_feature_value IN (27134, 27321, 26982, 19884, 27466, 24878, 27323, 26988, 27472, 27145, 25062, 27341, 26994, 25071, 27347, 27000, 28003, 27158, 27356, 27011, 26793, 27362, 27019, 27120, 26937, 27389, 27124, 26940, 27392, 27126, 26955, 19635, 27395, 27128, 23731, 27317, 26964, 19641, 27131, 27319, 26973, 19880, 14709, 27889, 18376, 18595, 26253, 21638, 21800, 27178, 17397, 22374, 14366, 24605, 222, 11784, 27141, 20899, 27534, 27935, 27111, 21056, 27688, 27032, 27042, 14362, 27056, 27087, 27093, 27908))) GROUP BY fp.id_feature_value	3.754 ms	156816	Yes	/modules/ps_facetedsearch/src/Adapter/MySQL.php:86 /modules/ps_facetedsearch/src/Adapter/MySQL.php:786 (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:138 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
105	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 mb_product p LEFT JOIN mb_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mb_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN mb_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN mb_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN mb_category_product cp ON (p.id_product = cp.id_product) INNER JOIN mb_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN mb_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN mb_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN mb_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN mb_feature_product fp_1 ON (p.id_product = fp_1.id_product) WHERE ((fp.id_feature_value IN (142, 43, 45))) AND ((fp_1.id_feature_value IN (27134, 27321, 26982, 19884, 27466, 24878, 27323, 26988, 27472, 27145, 25062, 27341, 26994, 25071, 27347, 27000, 28003, 27158, 27356, 27011, 26793, 27362, 27019, 27120, 26937, 27389, 27124, 26940, 27392, 27126, 26955, 19635, 27395, 27128, 23731, 27317, 26964, 19641, 27131, 27319, 26973, 19880, 14709, 27889, 18376, 18595, 26253, 21638, 21800, 27178, 17397, 22374, 14366, 24605, 222, 11784, 27141, 20899, 27534, 27935, 27111, 21056, 27688, 27032, 27042, 14362, 27056, 27087, 27093, 27908))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=188 AND c.nright<=195 GROUP BY p.id_product) p INNER JOIN mb_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN mb_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN mb_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((fp.id_feature=14)) AND ((fp_1.id_feature_value IN (142, 43, 45))) AND ((fp_2.id_feature_value IN (27134, 27321, 26982, 19884, 27466, 24878, 27323, 26988, 27472, 27145, 25062, 27341, 26994, 25071, 27347, 27000, 28003, 27158, 27356, 27011, 26793, 27362, 27019, 27120, 26937, 27389, 27124, 26940, 27392, 27126, 26955, 19635, 27395, 27128, 23731, 27317, 26964, 19641, 27131, 27319, 26973, 19880, 14709, 27889, 18376, 18595, 26253, 21638, 21800, 27178, 17397, 22374, 14366, 24605, 222, 11784, 27141, 20899, 27534, 27935, 27111, 21056, 27688, 27032, 27042, 14362, 27056, 27087, 27093, 27908))) GROUP BY fp.id_feature_value	3.640 ms	156816	Yes	/modules/ps_facetedsearch/src/Adapter/MySQL.php:86 /modules/ps_facetedsearch/src/Adapter/MySQL.php:786 (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:138 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
79	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 mb_product p LEFT JOIN mb_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mb_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN mb_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN mb_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN mb_category_product cp ON (p.id_product = cp.id_product) INNER JOIN mb_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN mb_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN mb_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN mb_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN mb_feature_product fp_1 ON (p.id_product = fp_1.id_product) WHERE ((fp.id_feature_value IN (142, 43, 45))) AND ((fp_1.id_feature_value IN (27134, 27321, 26982, 19884, 27466, 24878, 27323, 26988, 27472, 27145, 25062, 27341, 26994, 25071, 27347, 27000, 28003, 27158, 27356, 27011, 26793, 27362, 27019, 27120, 26937, 27389, 27124, 26940, 27392, 27126, 26955, 19635, 27395, 27128, 23731, 27317, 26964, 19641, 27131, 27319, 26973, 19880, 14709, 27889, 18376, 18595, 26253, 21638, 21800, 27178, 17397, 22374, 14366, 24605, 222, 11784, 27141, 20899, 27534, 27935, 27111, 21056, 27688, 27032, 27042, 14362, 27056, 27087, 27093, 27908))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=188 AND c.nright<=195 GROUP BY p.id_product) p LEFT JOIN mb_specific_price sp ON ( sp.id_product = p.id_product AND sp.id_shop IN (0, 1) AND sp.id_currency IN (0, 1) AND sp.id_country IN (0, 208) AND sp.id_group IN (0, 1) AND sp.from_quantity = 1 AND sp.reduction > 0 AND sp.id_customer = 0 AND sp.id_cart = 0 AND (sp.from = '0000-00-00 00:00:00' OR '2025-07-28 23:54:47' >= sp.from) AND (sp.to = '0000-00-00 00:00:00' OR '2025-07-28 23:54:47' <= sp.to) ) LEFT JOIN mb_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN mb_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((sp.reduction>0)) AND ((fp_1.id_feature_value IN (142, 43, 45))) AND ((fp_2.id_feature_value IN (27134, 27321, 26982, 19884, 27466, 24878, 27323, 26988, 27472, 27145, 25062, 27341, 26994, 25071, 27347, 27000, 28003, 27158, 27356, 27011, 26793, 27362, 27019, 27120, 26937, 27389, 27124, 26940, 27392, 27126, 26955, 19635, 27395, 27128, 23731, 27317, 26964, 19641, 27131, 27319, 26973, 19880, 14709, 27889, 18376, 18595, 26253, 21638, 21800, 27178, 17397, 22374, 14366, 24605, 222, 11784, 27141, 20899, 27534, 27935, 27111, 21056, 27688, 27032, 27042, 14362, 27056, 27087, 27093, 27908)))	3.584 ms	2912		/modules/ps_facetedsearch/src/Adapter/MySQL.php:86 /modules/ps_facetedsearch/src/Adapter/MySQL.php:786 (execute) /modules/ps_facetedsearch/src/Adapter/MySQL.php:764 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:605 (count) /modules/ps_facetedsearch/src/Filters/Block.php:143 (getHighlightsBlock) /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:138 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
82	SELECT SQL_NO_CACHE psi.price_min, MIN(price_min) as min, MAX(price_max) as max FROM mb_product p INNER JOIN mb_layered_price_index psi ON (psi.id_product = p.id_product AND psi.id_shop = 1 AND psi.id_currency = 1 AND psi.id_country = 208) INNER JOIN mb_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN mb_category_product cp ON (p.id_product = cp.id_product) INNER JOIN mb_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN mb_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN mb_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN mb_feature_product fp_1 ON (p.id_product = fp_1.id_product) WHERE ((fp.id_feature_value IN (142, 43, 45))) AND ((fp_1.id_feature_value IN (27134, 27321, 26982, 19884, 27466, 24878, 27323, 26988, 27472, 27145, 25062, 27341, 26994, 25071, 27347, 27000, 28003, 27158, 27356, 27011, 26793, 27362, 27019, 27120, 26937, 27389, 27124, 26940, 27392, 27126, 26955, 19635, 27395, 27128, 23731, 27317, 26964, 19641, 27131, 27319, 26973, 19880, 14709, 27889, 18376, 18595, 26253, 21638, 21800, 27178, 17397, 22374, 14366, 24605, 222, 11784, 27141, 20899, 27534, 27935, 27111, 21056, 27688, 27032, 27042, 14362, 27056, 27087, 27093, 27908))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=188 AND c.nright<=195	3.419 ms	198		/modules/ps_facetedsearch/src/Adapter/MySQL.php:86 /modules/ps_facetedsearch/src/Adapter/MySQL.php:58 (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:138 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
95	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 mb_product p LEFT JOIN mb_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mb_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN mb_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN mb_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN mb_category_product cp ON (p.id_product = cp.id_product) INNER JOIN mb_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN mb_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN mb_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN mb_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN mb_feature_product fp_1 ON (p.id_product = fp_1.id_product) WHERE ((fp.id_feature_value IN (142, 43, 45))) AND ((fp_1.id_feature_value IN (27134, 27321, 26982, 19884, 27466, 24878, 27323, 26988, 27472, 27145, 25062, 27341, 26994, 25071, 27347, 27000, 28003, 27158, 27356, 27011, 26793, 27362, 27019, 27120, 26937, 27389, 27124, 26940, 27392, 27126, 26955, 19635, 27395, 27128, 23731, 27317, 26964, 19641, 27131, 27319, 26973, 19880, 14709, 27889, 18376, 18595, 26253, 21638, 21800, 27178, 17397, 22374, 14366, 24605, 222, 11784, 27141, 20899, 27534, 27935, 27111, 21056, 27688, 27032, 27042, 14362, 27056, 27087, 27093, 27908))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=188 AND c.nright<=195 GROUP BY p.id_product) p INNER JOIN mb_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN mb_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN mb_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((fp.id_feature=6)) AND ((fp_1.id_feature_value IN (142, 43, 45))) AND ((fp_2.id_feature_value IN (27134, 27321, 26982, 19884, 27466, 24878, 27323, 26988, 27472, 27145, 25062, 27341, 26994, 25071, 27347, 27000, 28003, 27158, 27356, 27011, 26793, 27362, 27019, 27120, 26937, 27389, 27124, 26940, 27392, 27126, 26955, 19635, 27395, 27128, 23731, 27317, 26964, 19641, 27131, 27319, 26973, 19880, 14709, 27889, 18376, 18595, 26253, 21638, 21800, 27178, 17397, 22374, 14366, 24605, 222, 11784, 27141, 20899, 27534, 27935, 27111, 21056, 27688, 27032, 27042, 14362, 27056, 27087, 27093, 27908))) GROUP BY fp.id_feature_value	3.380 ms	156816	Yes	/modules/ps_facetedsearch/src/Adapter/MySQL.php:86 /modules/ps_facetedsearch/src/Adapter/MySQL.php:786 (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:138 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
72	SELECT SQL_NO_CACHE p.id_product FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM mb_product p LEFT JOIN mb_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mb_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN mb_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN mb_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN mb_category_product cp ON (p.id_product = cp.id_product) INNER JOIN mb_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN mb_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN mb_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN mb_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN mb_feature_product fp_1 ON (p.id_product = fp_1.id_product) WHERE ((fp.id_feature_value IN (142, 43, 45))) AND ((fp_1.id_feature_value IN (27134, 27321, 26982, 19884, 27466, 24878, 27323, 26988, 27472, 27145, 25062, 27341, 26994, 25071, 27347, 27000, 28003, 27158, 27356, 27011, 26793, 27362, 27019, 27120, 26937, 27389, 27124, 26940, 27392, 27126, 26955, 19635, 27395, 27128, 23731, 27317, 26964, 19641, 27131, 27319, 26973, 19880, 14709, 27889, 18376, 18595, 26253, 21638, 21800, 27178, 17397, 22374, 14366, 24605, 222, 11784, 27141, 20899, 27534, 27935, 27111, 21056, 27688, 27032, 27042, 14362, 27056, 27087, 27093, 27908))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=188 AND c.nright<=195 GROUP BY p.id_product) p INNER JOIN mb_category_product cp ON (p.id_product = cp.id_product) GROUP BY p.id_product ORDER BY p.position ASC, p.id_product DESC LIMIT 0, 12	3.354 ms	39204	Yes	/modules/ps_facetedsearch/src/Adapter/MySQL.php:86 /modules/ps_facetedsearch/src/Filters/Products.php:90 (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:138 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
80	SELECT SQL_NO_CACHE m.*, ml.`description`, ml.`short_description` FROM `mb_manufacturer` m INNER JOIN mb_manufacturer_shop manufacturer_shop ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 1)INNER JOIN `mb_manufacturer_lang` ml ON (m.`id_manufacturer` = ml.`id_manufacturer` AND ml.`id_lang` = 1)WHERE 1 AND m.`active` = 1 ORDER BY m.`name` ASC	3.024 ms	290	Yes	/classes/Manufacturer.php:211 /modules/ps_facetedsearch/src/Filters/Block.php:652 (getManufacturers) /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:138 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
118	SELECT SQL_NO_CACHE fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM mb_product p LEFT JOIN mb_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mb_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN mb_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN mb_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN mb_category_product cp ON (p.id_product = cp.id_product) INNER JOIN mb_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN mb_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN mb_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN mb_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN mb_feature_product fp_1 ON (p.id_product = fp_1.id_product) WHERE ((fp.id_feature_value IN (142, 43, 45))) AND ((fp_1.id_feature_value IN (27134, 27321, 26982, 19884, 27466, 24878, 27323, 26988, 27472, 27145, 25062, 27341, 26994, 25071, 27347, 27000, 28003, 27158, 27356, 27011, 26793, 27362, 27019, 27120, 26937, 27389, 27124, 26940, 27392, 27126, 26955, 19635, 27395, 27128, 23731, 27317, 26964, 19641, 27131, 27319, 26973, 19880, 14709, 27889, 18376, 18595, 26253, 21638, 21800, 27178, 17397, 22374, 14366, 24605, 222, 11784, 27141, 20899, 27534, 27935, 27111, 21056, 27688, 27032, 27042, 14362, 27056, 27087, 27093, 27908))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=188 AND c.nright<=195 GROUP BY p.id_product) p INNER JOIN mb_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN mb_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN mb_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((fp.id_feature=27)) AND ((fp_1.id_feature_value IN (142, 43, 45))) AND ((fp_2.id_feature_value IN (27134, 27321, 26982, 19884, 27466, 24878, 27323, 26988, 27472, 27145, 25062, 27341, 26994, 25071, 27347, 27000, 28003, 27158, 27356, 27011, 26793, 27362, 27019, 27120, 26937, 27389, 27124, 26940, 27392, 27126, 26955, 19635, 27395, 27128, 23731, 27317, 26964, 19641, 27131, 27319, 26973, 19880, 14709, 27889, 18376, 18595, 26253, 21638, 21800, 27178, 17397, 22374, 14366, 24605, 222, 11784, 27141, 20899, 27534, 27935, 27111, 21056, 27688, 27032, 27042, 14362, 27056, 27087, 27093, 27908))) GROUP BY fp.id_feature_value	2.984 ms	4512	Yes	/modules/ps_facetedsearch/src/Adapter/MySQL.php:86 /modules/ps_facetedsearch/src/Adapter/MySQL.php:786 (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:138 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
12	SELECT SQL_NO_CACHE lower(name) as name FROM `mb_hook` h WHERE (h.active = 1)	2.924 ms	962		/classes/Hook.php:1332 /classes/Hook.php:811 (getHookStatusByName) /classes/Dispatcher.php:606 (exec) /classes/Dispatcher.php:243 (loadRoutes) /classes/Dispatcher.php:201 (__construct) /index.php:28 (getInstance)
123	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 mb_product p LEFT JOIN mb_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mb_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN mb_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN mb_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN mb_category_product cp ON (p.id_product = cp.id_product) INNER JOIN mb_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN mb_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN mb_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN mb_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN mb_feature_product fp_1 ON (p.id_product = fp_1.id_product) WHERE ((fp.id_feature_value IN (142, 43, 45))) AND ((fp_1.id_feature_value IN (27134, 27321, 26982, 19884, 27466, 24878, 27323, 26988, 27472, 27145, 25062, 27341, 26994, 25071, 27347, 27000, 28003, 27158, 27356, 27011, 26793, 27362, 27019, 27120, 26937, 27389, 27124, 26940, 27392, 27126, 26955, 19635, 27395, 27128, 23731, 27317, 26964, 19641, 27131, 27319, 26973, 19880, 14709, 27889, 18376, 18595, 26253, 21638, 21800, 27178, 17397, 22374, 14366, 24605, 222, 11784, 27141, 20899, 27534, 27935, 27111, 21056, 27688, 27032, 27042, 14362, 27056, 27087, 27093, 27908))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=188 AND c.nright<=195 GROUP BY p.id_product) p INNER JOIN mb_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN mb_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN mb_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((fp.id_feature=32)) AND ((fp_1.id_feature_value IN (142, 43, 45))) AND ((fp_2.id_feature_value IN (27134, 27321, 26982, 19884, 27466, 24878, 27323, 26988, 27472, 27145, 25062, 27341, 26994, 25071, 27347, 27000, 28003, 27158, 27356, 27011, 26793, 27362, 27019, 27120, 26937, 27389, 27124, 26940, 27392, 27126, 26955, 19635, 27395, 27128, 23731, 27317, 26964, 19641, 27131, 27319, 26973, 19880, 14709, 27889, 18376, 18595, 26253, 21638, 21800, 27178, 17397, 22374, 14366, 24605, 222, 11784, 27141, 20899, 27534, 27935, 27111, 21056, 27688, 27032, 27042, 14362, 27056, 27087, 27093, 27908))) GROUP BY fp.id_feature_value	2.734 ms	156816	Yes	/modules/ps_facetedsearch/src/Adapter/MySQL.php:86 /modules/ps_facetedsearch/src/Adapter/MySQL.php:786 (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:138 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
121	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 mb_product p LEFT JOIN mb_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mb_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN mb_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN mb_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN mb_category_product cp ON (p.id_product = cp.id_product) INNER JOIN mb_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN mb_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN mb_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN mb_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN mb_feature_product fp_1 ON (p.id_product = fp_1.id_product) WHERE ((fp.id_feature_value IN (142, 43, 45))) AND ((fp_1.id_feature_value IN (27134, 27321, 26982, 19884, 27466, 24878, 27323, 26988, 27472, 27145, 25062, 27341, 26994, 25071, 27347, 27000, 28003, 27158, 27356, 27011, 26793, 27362, 27019, 27120, 26937, 27389, 27124, 26940, 27392, 27126, 26955, 19635, 27395, 27128, 23731, 27317, 26964, 19641, 27131, 27319, 26973, 19880, 14709, 27889, 18376, 18595, 26253, 21638, 21800, 27178, 17397, 22374, 14366, 24605, 222, 11784, 27141, 20899, 27534, 27935, 27111, 21056, 27688, 27032, 27042, 14362, 27056, 27087, 27093, 27908))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=188 AND c.nright<=195 GROUP BY p.id_product) p INNER JOIN mb_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN mb_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN mb_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((fp.id_feature=30)) AND ((fp_1.id_feature_value IN (142, 43, 45))) AND ((fp_2.id_feature_value IN (27134, 27321, 26982, 19884, 27466, 24878, 27323, 26988, 27472, 27145, 25062, 27341, 26994, 25071, 27347, 27000, 28003, 27158, 27356, 27011, 26793, 27362, 27019, 27120, 26937, 27389, 27124, 26940, 27392, 27126, 26955, 19635, 27395, 27128, 23731, 27317, 26964, 19641, 27131, 27319, 26973, 19880, 14709, 27889, 18376, 18595, 26253, 21638, 21800, 27178, 17397, 22374, 14366, 24605, 222, 11784, 27141, 20899, 27534, 27935, 27111, 21056, 27688, 27032, 27042, 14362, 27056, 27087, 27093, 27908))) GROUP BY fp.id_feature_value	2.690 ms	156816	Yes	/modules/ps_facetedsearch/src/Adapter/MySQL.php:86 /modules/ps_facetedsearch/src/Adapter/MySQL.php:786 (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:138 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
14	SELECT SQL_NO_CACHE `name`, `alias` FROM `mb_hook_alias`	2.604 ms	88		/classes/Hook.php:287 /classes/Hook.php:318 (getAllHookAliases) /classes/Hook.php:746 (getHookAliasesFor) /classes/Hook.php:842 (getHookModuleExecList) /classes/Dispatcher.php:606 (exec) /classes/Dispatcher.php:243 (loadRoutes) /classes/Dispatcher.php:201 (__construct) /index.php:28 (getInstance)
100	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 mb_product p LEFT JOIN mb_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mb_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN mb_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN mb_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN mb_category_product cp ON (p.id_product = cp.id_product) INNER JOIN mb_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN mb_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN mb_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN mb_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN mb_feature_product fp_1 ON (p.id_product = fp_1.id_product) WHERE ((fp.id_feature_value IN (142, 43, 45))) AND ((fp_1.id_feature_value IN (27134, 27321, 26982, 19884, 27466, 24878, 27323, 26988, 27472, 27145, 25062, 27341, 26994, 25071, 27347, 27000, 28003, 27158, 27356, 27011, 26793, 27362, 27019, 27120, 26937, 27389, 27124, 26940, 27392, 27126, 26955, 19635, 27395, 27128, 23731, 27317, 26964, 19641, 27131, 27319, 26973, 19880, 14709, 27889, 18376, 18595, 26253, 21638, 21800, 27178, 17397, 22374, 14366, 24605, 222, 11784, 27141, 20899, 27534, 27935, 27111, 21056, 27688, 27032, 27042, 14362, 27056, 27087, 27093, 27908))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=188 AND c.nright<=195 GROUP BY p.id_product) p INNER JOIN mb_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN mb_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN mb_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((fp.id_feature=9)) AND ((fp_1.id_feature_value IN (142, 43, 45))) AND ((fp_2.id_feature_value IN (27134, 27321, 26982, 19884, 27466, 24878, 27323, 26988, 27472, 27145, 25062, 27341, 26994, 25071, 27347, 27000, 28003, 27158, 27356, 27011, 26793, 27362, 27019, 27120, 26937, 27389, 27124, 26940, 27392, 27126, 26955, 19635, 27395, 27128, 23731, 27317, 26964, 19641, 27131, 27319, 26973, 19880, 14709, 27889, 18376, 18595, 26253, 21638, 21800, 27178, 17397, 22374, 14366, 24605, 222, 11784, 27141, 20899, 27534, 27935, 27111, 21056, 27688, 27032, 27042, 14362, 27056, 27087, 27093, 27908))) GROUP BY fp.id_feature_value	2.508 ms	3328	Yes	/modules/ps_facetedsearch/src/Adapter/MySQL.php:86 /modules/ps_facetedsearch/src/Adapter/MySQL.php:786 (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:138 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
75	SELECT SQL_NO_CACHE c.`id_category`, cl.`name` FROM `mb_category` c INNER JOIN mb_category_shop category_shop ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1) LEFT JOIN `mb_category_lang` cl ON c.`id_category` = cl.`id_category` AND cl.id_shop = 1 WHERE 1 AND `id_lang` = 1 AND c.`active` = 1 ORDER BY c.nleft, c.position	2.507 ms	245	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:138 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
86	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 mb_product p LEFT JOIN mb_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mb_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN mb_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN mb_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN mb_category_product cp ON (p.id_product = cp.id_product) INNER JOIN mb_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN mb_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN mb_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN mb_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN mb_feature_product fp_1 ON (p.id_product = fp_1.id_product) WHERE ((fp.id_feature_value IN (142, 43, 45))) AND ((fp_1.id_feature_value IN (27134, 27321, 26982, 19884, 27466, 24878, 27323, 26988, 27472, 27145, 25062, 27341, 26994, 25071, 27347, 27000, 28003, 27158, 27356, 27011, 26793, 27362, 27019, 27120, 26937, 27389, 27124, 26940, 27392, 27126, 26955, 19635, 27395, 27128, 23731, 27317, 26964, 19641, 27131, 27319, 26973, 19880, 14709, 27889, 18376, 18595, 26253, 21638, 21800, 27178, 17397, 22374, 14366, 24605, 222, 11784, 27141, 20899, 27534, 27935, 27111, 21056, 27688, 27032, 27042, 14362, 27056, 27087, 27093, 27908))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=188 AND c.nright<=195 GROUP BY p.id_product) p LEFT JOIN mb_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mb_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) INNER JOIN mb_attribute a ON (a.id_attribute = pac.id_attribute) LEFT JOIN mb_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN mb_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((a.id_attribute_group=4)) AND ((fp_1.id_feature_value IN (142, 43, 45))) AND ((fp_2.id_feature_value IN (27134, 27321, 26982, 19884, 27466, 24878, 27323, 26988, 27472, 27145, 25062, 27341, 26994, 25071, 27347, 27000, 28003, 27158, 27356, 27011, 26793, 27362, 27019, 27120, 26937, 27389, 27124, 26940, 27392, 27126, 26955, 19635, 27395, 27128, 23731, 27317, 26964, 19641, 27131, 27319, 26973, 19880, 14709, 27889, 18376, 18595, 26253, 21638, 21800, 27178, 17397, 22374, 14366, 24605, 222, 11784, 27141, 20899, 27534, 27935, 27111, 21056, 27688, 27032, 27042, 14362, 27056, 27087, 27093, 27908))) GROUP BY pac.id_attribute	2.494 ms	1920	Yes	/modules/ps_facetedsearch/src/Adapter/MySQL.php:86 /modules/ps_facetedsearch/src/Adapter/MySQL.php:786 (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:138 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
101	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 mb_product p LEFT JOIN mb_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mb_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN mb_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN mb_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN mb_category_product cp ON (p.id_product = cp.id_product) INNER JOIN mb_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN mb_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN mb_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN mb_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN mb_feature_product fp_1 ON (p.id_product = fp_1.id_product) WHERE ((fp.id_feature_value IN (142, 43, 45))) AND ((fp_1.id_feature_value IN (27134, 27321, 26982, 19884, 27466, 24878, 27323, 26988, 27472, 27145, 25062, 27341, 26994, 25071, 27347, 27000, 28003, 27158, 27356, 27011, 26793, 27362, 27019, 27120, 26937, 27389, 27124, 26940, 27392, 27126, 26955, 19635, 27395, 27128, 23731, 27317, 26964, 19641, 27131, 27319, 26973, 19880, 14709, 27889, 18376, 18595, 26253, 21638, 21800, 27178, 17397, 22374, 14366, 24605, 222, 11784, 27141, 20899, 27534, 27935, 27111, 21056, 27688, 27032, 27042, 14362, 27056, 27087, 27093, 27908))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=188 AND c.nright<=195 GROUP BY p.id_product) p INNER JOIN mb_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN mb_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN mb_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((fp.id_feature=10)) AND ((fp_1.id_feature_value IN (142, 43, 45))) AND ((fp_2.id_feature_value IN (27134, 27321, 26982, 19884, 27466, 24878, 27323, 26988, 27472, 27145, 25062, 27341, 26994, 25071, 27347, 27000, 28003, 27158, 27356, 27011, 26793, 27362, 27019, 27120, 26937, 27389, 27124, 26940, 27392, 27126, 26955, 19635, 27395, 27128, 23731, 27317, 26964, 19641, 27131, 27319, 26973, 19880, 14709, 27889, 18376, 18595, 26253, 21638, 21800, 27178, 17397, 22374, 14366, 24605, 222, 11784, 27141, 20899, 27534, 27935, 27111, 21056, 27688, 27032, 27042, 14362, 27056, 27087, 27093, 27908))) GROUP BY fp.id_feature_value	2.314 ms	2144	Yes	/modules/ps_facetedsearch/src/Adapter/MySQL.php:86 /modules/ps_facetedsearch/src/Adapter/MySQL.php:786 (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:138 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
104	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 mb_product p LEFT JOIN mb_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mb_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN mb_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN mb_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN mb_category_product cp ON (p.id_product = cp.id_product) INNER JOIN mb_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN mb_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN mb_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN mb_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN mb_feature_product fp_1 ON (p.id_product = fp_1.id_product) WHERE ((fp.id_feature_value IN (142, 43, 45))) AND ((fp_1.id_feature_value IN (27134, 27321, 26982, 19884, 27466, 24878, 27323, 26988, 27472, 27145, 25062, 27341, 26994, 25071, 27347, 27000, 28003, 27158, 27356, 27011, 26793, 27362, 27019, 27120, 26937, 27389, 27124, 26940, 27392, 27126, 26955, 19635, 27395, 27128, 23731, 27317, 26964, 19641, 27131, 27319, 26973, 19880, 14709, 27889, 18376, 18595, 26253, 21638, 21800, 27178, 17397, 22374, 14366, 24605, 222, 11784, 27141, 20899, 27534, 27935, 27111, 21056, 27688, 27032, 27042, 14362, 27056, 27087, 27093, 27908))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=188 AND c.nright<=195 GROUP BY p.id_product) p INNER JOIN mb_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN mb_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN mb_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((fp.id_feature=13)) AND ((fp_1.id_feature_value IN (142, 43, 45))) AND ((fp_2.id_feature_value IN (27134, 27321, 26982, 19884, 27466, 24878, 27323, 26988, 27472, 27145, 25062, 27341, 26994, 25071, 27347, 27000, 28003, 27158, 27356, 27011, 26793, 27362, 27019, 27120, 26937, 27389, 27124, 26940, 27392, 27126, 26955, 19635, 27395, 27128, 23731, 27317, 26964, 19641, 27131, 27319, 26973, 19880, 14709, 27889, 18376, 18595, 26253, 21638, 21800, 27178, 17397, 22374, 14366, 24605, 222, 11784, 27141, 20899, 27534, 27935, 27111, 21056, 27688, 27032, 27042, 14362, 27056, 27087, 27093, 27908))) GROUP BY fp.id_feature_value	2.311 ms	3104	Yes	/modules/ps_facetedsearch/src/Adapter/MySQL.php:86 /modules/ps_facetedsearch/src/Adapter/MySQL.php:786 (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:138 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
111	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 mb_product p LEFT JOIN mb_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mb_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN mb_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN mb_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN mb_category_product cp ON (p.id_product = cp.id_product) INNER JOIN mb_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN mb_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN mb_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN mb_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN mb_feature_product fp_1 ON (p.id_product = fp_1.id_product) WHERE ((fp.id_feature_value IN (142, 43, 45))) AND ((fp_1.id_feature_value IN (27134, 27321, 26982, 19884, 27466, 24878, 27323, 26988, 27472, 27145, 25062, 27341, 26994, 25071, 27347, 27000, 28003, 27158, 27356, 27011, 26793, 27362, 27019, 27120, 26937, 27389, 27124, 26940, 27392, 27126, 26955, 19635, 27395, 27128, 23731, 27317, 26964, 19641, 27131, 27319, 26973, 19880, 14709, 27889, 18376, 18595, 26253, 21638, 21800, 27178, 17397, 22374, 14366, 24605, 222, 11784, 27141, 20899, 27534, 27935, 27111, 21056, 27688, 27032, 27042, 14362, 27056, 27087, 27093, 27908))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=188 AND c.nright<=195 GROUP BY p.id_product) p INNER JOIN mb_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN mb_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN mb_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((fp.id_feature=18)) AND ((fp_1.id_feature_value IN (142, 43, 45))) AND ((fp_2.id_feature_value IN (27134, 27321, 26982, 19884, 27466, 24878, 27323, 26988, 27472, 27145, 25062, 27341, 26994, 25071, 27347, 27000, 28003, 27158, 27356, 27011, 26793, 27362, 27019, 27120, 26937, 27389, 27124, 26940, 27392, 27126, 26955, 19635, 27395, 27128, 23731, 27317, 26964, 19641, 27131, 27319, 26973, 19880, 14709, 27889, 18376, 18595, 26253, 21638, 21800, 27178, 17397, 22374, 14366, 24605, 222, 11784, 27141, 20899, 27534, 27935, 27111, 21056, 27688, 27032, 27042, 14362, 27056, 27087, 27093, 27908))) GROUP BY fp.id_feature_value	2.259 ms	3520	Yes	/modules/ps_facetedsearch/src/Adapter/MySQL.php:86 /modules/ps_facetedsearch/src/Adapter/MySQL.php:786 (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:138 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)

193 queries	SELECT * FROM `mb_category` a LEFT JOIN `mb_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = XX LEFT JOIN `mb_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
143 queries	SELECT c.*, cl.name,cl.link_rewrite FROM `mb_category` c INNER JOIN `mb_category_shop` cs ON (c.id_category =cs.id_category AND cs.id_shop=XX) LEFT JOIN `mb_category_lang` cl ON c.id_category=cl.id_category AND cl.id_lang=XX AND cl.id_shop=XX WHERE c.active = XX AND c.id_parent=XX AND c.id_category!=XX ORDER BY cl.name ASC,c.id_category ASC
48 queries	SELECT (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS grade FROM `mb_tvcmsproduct_comment` pc WHERE pc.`id_product` = XX AND pc.`deleted` = XX AND pc.`validate` = XX LIMIT XX
48 queries	SELECT (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS avg, MIN(pc.`grade`) AS min, MAX(pc.`grade`) AS max FROM `mb_tvcmsproduct_comment` pc WHERE pc.`id_product` = XX AND pc.`deleted` = XX AND pc.`validate` = XX LIMIT XX
43 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 mb_product p LEFT JOIN mb_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mb_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN mb_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, XX) = sa.id_product_attribute AND sa.id_shop = XX AND sa.id_shop_group = XX ) LEFT JOIN mb_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN mb_category_product cp ON (p.id_product = cp.id_product) INNER JOIN mb_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = XX AND ps.active = TRUE) INNER JOIN mb_category c ON (cp.id_category = c.id_category AND c.active=XX) LEFT JOIN mb_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN mb_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN mb_feature_product fp_XX ON (p.id_product = fp_XX.id_product) WHERE ((fp.id_feature_value IN (XX, XX, XX))) AND ((fp_XX.id_feature_value IN (XX, XX, XX, XX, XX, XX, XX, XX, XX, XX, XX, XX, XX, XX, XX, XX, XX, XX, XX, XX, XX, XX, XX, XX, XX, XX, XX, XX, XX, XX, XX, XX, XX, XX, XX, XX, XX, XX, XX, XX, XX, XX, XX, XX, XX, XX, XX, XX, XX, XX, XX, XX, XX, XX, XX, XX, XX, XX, XX, XX, XX, XX, XX, XX, XX, XX, XX, XX, XX, XX))) AND ps.id_shop='XX' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='XX' AND c.nleft>=XX AND c.nright<=XX GROUP BY p.id_product) p INNER JOIN mb_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN mb_feature_product fp_XX ON (p.id_product = fp_XX.id_product) LEFT JOIN mb_feature_product fp_XX ON (p.id_product = fp_XX.id_product) WHERE ((fp.id_feature=XX)) AND ((fp_XX.id_feature_value IN (XX, XX, XX))) AND ((fp_XX.id_feature_value IN (XX, XX, XX, XX, XX, XX, XX, XX, XX, XX, XX, XX, XX, XX, XX, XX, XX, XX, XX, XX, XX, XX, XX, XX, XX, XX, XX, XX, XX, XX, XX, XX, XX, XX, XX, XX, XX, XX, XX, XX, XX, XX, XX, XX, XX, XX, XX, XX, XX, XX, XX, XX, XX, XX, XX, XX, XX, XX, XX, XX, XX, XX, XX, XX, XX, XX, XX, XX, XX, XX))) GROUP BY fp.id_feature_value
42 queries	SELECT SUM(quantity) FROM `mb_stock_available` WHERE (id_product = XX) AND (id_product_attribute = XX) AND (id_shop = XX) AND (id_shop_group = XX) LIMIT XX
41 queries	SELECT `id_image_type` FROM `mb_image_type` WHERE `name` = 'home'
33 queries	SELECT COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), XX) as deep_quantity, COALESCE(SUM(first_level_quantity), XX) as quantity FROM (SELECT cp.`quantity` as first_level_quantity, XX as pack_quantity FROM `mb_cart_product` cp WHERE cp.`id_product_attribute` = XX AND cp.`id_customization` = XX AND cp.`id_cart` = XX AND cp.`id_product` = XX UNION SELECT XX as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity FROM `mb_cart_product` cp JOIN `mb_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `mb_product` pr ON p.`id_product_pack` = pr.`id_product` WHERE cp.`id_product_attribute` = XX AND cp.`id_customization` = XX AND cp.`id_cart` = XX AND p.`id_product_item` = XX AND (pr.`pack_stock_type` IN (XX,XX) OR ( pr.`pack_stock_type` = XX AND XX = XX ))) as q LIMIT XX
31 queries	SELECT c.*, cl.name,cl.link_rewrite FROM `mb_category` c INNER JOIN `mb_category_shop` cs ON (c.id_category =cs.id_category AND cs.id_shop=XX) LEFT JOIN `mb_category_lang` cl ON c.id_category=cl.id_category AND cl.id_lang=XX AND cl.id_shop=XX WHERE c.active = XX AND c.id_parent=XX AND c.id_category!=XX ORDER BY cl.name DESC,c.id_category ASC
27 queries	SELECT b.*,bl.title,bl.title_link,bl.content,bl.image_link,bl.image FROM `mb_ets_mm_block` b LEFT JOIN `mb_ets_mm_block_lang` bl ON b.id_block=bl.id_block AND bl.id_lang=XX WHERE XX AND b.id_column=XX ORDER BY b.sort_order asc
25 queries	SELECT XX FROM `mb_specific_price` WHERE id_product = XX LIMIT XX
24 queries	SELECT image_shop.`id_image` FROM `mb_image` i INNER JOIN mb_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
24 queries	SELECT name FROM mb_category_lang WHERE id_shop = XX AND id_lang = XX AND id_category = XX LIMIT XX
24 queries	SELECT * FROM `mb_product` a LEFT JOIN `mb_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = XX LEFT JOIN `mb_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
24 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 `mb_product` p INNER JOIN `mb_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = XX) LEFT JOIN `mb_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)
24 queries	SELECT `id_tax_rules_group` FROM `mb_product_shop` WHERE `id_product` = XX AND id_shop=XX LIMIT XX
24 queries	SELECT `reduction` FROM `mb_product_group_reduction_cache` WHERE `id_product` = XX AND `id_group` = XX LIMIT XX
24 queries	SELECT image_shop.`cover`, i.`id_image`, il.`legend`, i.`position` FROM `mb_image` i INNER JOIN mb_image_shop image_shop ON (image_shop.id_image = i.id_image AND image_shop.id_shop = XX) LEFT JOIN `mb_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = XX) WHERE i.`id_product` = XX ORDER BY `position`
24 queries	SELECT `id_product_attribute` FROM `mb_product_attribute` WHERE `id_product` = XX
21 queries	SELECT name, value, pf.id_feature, f.position, fvl.id_feature_value FROM mb_feature_product pf LEFT JOIN mb_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = XX) LEFT JOIN mb_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = XX) LEFT JOIN mb_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = XX) INNER JOIN mb_feature_shop feature_shop ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = XX) WHERE pf.id_product = XX ORDER BY f.position ASC
21 queries	SELECT a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, pa.`reference`, pa.`eanXX`, pa.`isbn`, pa.`upc`, pa.`mpn`, pal.`available_now`, pal.`available_later` FROM `mb_attribute` a LEFT JOIN `mb_attribute_lang` al ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = XX) LEFT JOIN `mb_product_attribute_combination` pac ON (pac.`id_attribute` = a.`id_attribute`) LEFT JOIN `mb_product_attribute` pa ON (pa.`id_product_attribute` = pac.`id_product_attribute`) INNER JOIN mb_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = XX) LEFT JOIN `mb_product_attribute_lang` pal ON (pal.`id_product_attribute` = pac.`id_product_attribute` AND pal.`id_lang` = XX) LEFT JOIN `mb_attribute_group_lang` agl ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = XX) WHERE pa.`id_product` = XX AND pac.`id_product_attribute` = XX AND agl.`id_lang` = XX
16 queries	SELECT `id_module` FROM `mb_module_shop` WHERE `id_module` = XX AND `id_shop` = XX LIMIT XX
12 queries	SELECT cl.`link_rewrite` FROM `mb_category_lang` cl WHERE `id_lang` = XX AND cl.id_shop = XX AND cl.`id_category` = 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 mb_product p LEFT JOIN mb_product_lang pl ON pl.id_product = p.id_product AND pl.id_shop = XX AND pl.id_lang = XX LEFT JOIN mb_stock_available sa ON sa.id_product = p.id_product AND sa.id_product_attribute = XX AND sa.id_shop = XX LEFT JOIN mb_product_shop ps ON ps.id_product = p.id_product AND ps.id_shop = XX WHERE p.id_product IN (XX)
12 queries	SELECT COUNT(`id_tvcmsproduct_comment`) AS "nbr" FROM `mb_tvcmsproduct_comment` pc WHERE `id_product` = XX AND `validate` = XX LIMIT XX
12 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 `mb_product_attribute` pa INNER JOIN mb_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 `mb_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`) JOIN `mb_attribute` a ON (a.`id_attribute` = pac.`id_attribute`) JOIN `mb_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = XX) JOIN `mb_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;
10 queries	SELECT v., vl., IF(lifvlv.`url_name` IS NULL OR lifvlv.`url_name` = "", NULL, lifvlv.`url_name`) AS url_name, IF(lifvlv.`meta_title` IS NULL OR lifvlv.`meta_title` = "", NULL, lifvlv.`meta_title`) AS meta_title FROM `mb_feature_value` v LEFT JOIN `mb_feature_value_lang` vl ON (v.`id_feature_value` = vl.`id_feature_value` AND vl.`id_lang` = XX) LEFT JOIN `mb_layered_indexable_feature_value_lang_value` lifvlv ON (v.`id_feature_value` = lifvlv.`id_feature_value` AND lifvlv.`id_lang` = XX) WHERE v.`id_feature` = XX ORDER BY vl.`value` ASC
9 queries	SELECT product_attribute_shop.`price` FROM `mb_product_attribute` pa INNER JOIN mb_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = XX) WHERE pa.`id_product_attribute` = XX LIMIT XX
9 queries	SELECT pa.`available_date` FROM `mb_product` p LEFT JOIN `mb_product_attribute` pa ON (pa.`id_product` = p.`id_product`) INNER JOIN mb_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = XX) INNER JOIN mb_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = XX) WHERE p.`id_product` = XX AND pa.`id_product` = XX AND pa.`id_product_attribute` = XX LIMIT XX
9 queries	SELECT * FROM `mb_product_attribute` a LEFT JOIN `mb_product_attribute_shop` `c` ON a.`id_product_attribute` = c.`id_product_attribute` AND c.`id_shop` = XX WHERE (a.`id_product_attribute` = XX) LIMIT XX
9 queries	SELECT * FROM `mb_product_attribute_lang` WHERE `id_product_attribute` = XX
9 queries	SELECT * FROM `mb_ets_mm_column` WHERE XX AND id_tab=XX ORDER BY sort_order asc
8 queries	SELECT c.*, cl.name,cl.link_rewrite FROM `mb_category` c INNER JOIN `mb_category_shop` cs ON (c.id_category =cs.id_category AND cs.id_shop=XX) LEFT JOIN `mb_category_lang` cl ON c.id_category=cl.id_category AND cl.id_lang=XX AND cl.id_shop=XX WHERE c.active = XX AND c.id_parent=XX AND c.id_category!=XX ORDER BY c.id_category DESC
6 queries	SELECT * FROM `mb_category` a LEFT JOIN `mb_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = XX WHERE (a.`id_category` = XX) LIMIT XX
6 queries	SELECT * FROM `mb_category_lang` WHERE `id_category` = XX AND `id_shop` = XX
6 queries	SELECT `name` FROM `mb_manufacturer` WHERE `id_manufacturer` = XX AND `active` = XX LIMIT XX
6 queries	SELECT c.*, cl.name,cl.link_rewrite FROM `mb_category` c INNER JOIN `mb_category_shop` cs ON (c.id_category=cs.id_category AND cs.id_shop=XX) LEFT JOIN `mb_category_lang` cl ON c.id_category=cl.id_category AND cl.id_lang=XX INNER JOIN `mb_category_group` cg ON c.`id_category` = cg.`id_category` AND cg.id_group IN (XX) WHERE c.active=XX AND c.id_category IN(XX) GROUP BY c.id_category ORDER BY cl.name ASC,c.id_category ASC
6 queries	SELECT * FROM `mb_product` a LEFT JOIN `mb_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = XX WHERE (a.`id_product` = XX) LIMIT XX
6 queries	SELECT * FROM `mb_product_lang` WHERE `id_product` = XX AND `id_shop` = XX
6 queries	SELECT pa., product_attribute_shop. FROM `mb_product_attribute` pa INNER JOIN mb_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 GROUP BY pa.`id_product_attribute` ORDER BY pa.`id_product_attribute`

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

Panier

APPLE IPHONE 14 128GB BLEU

APPLE IPHONE 14 128GB BLEU

APPLE IPHONE 14 128GB BLEU

APPLE IPHONE 14 128GB BLEU

SMARTPHONE XIAOMI 12 PRO 5G 12GO 256GO

SMARTPHONE XIAOMI 12 PRO 5G 12GO 256GO

SMARTPHONE XIAOMI 12 PRO 5G 12GO 256GO

SMARTPHONE XIAOMI 12 PRO 5G 12GO 256GO

SMARTPHONE ITEL A33 PLUS 2GO 32GO

SMARTPHONE ITEL A33 PLUS 2GO 32GO

SMARTPHONE ITEL A33 PLUS 2GO 32GO

SMARTPHONE ITEL A33 PLUS 2GO 32GO

SMARTPHONE NOKIA C2 2GO 32GO

SMARTPHONE NOKIA C2 2GO 32GO

SMARTPHONE NOKIA C2 2GO 32GO

SMARTPHONE NOKIA C2 2GO 32GO

SMARTPHONE SAMSUNG GALAXY S24 ULTRA 12GB 256GB

SMARTPHONE SAMSUNG GALAXY S24 ULTRA 12GB 256GB

SMARTPHONE SAMSUNG GALAXY S24 ULTRA 12GB 256GB

SMARTPHONE SAMSUNG GALAXY S24 ULTRA 12GB 256GB

SMARTPHONE XIAOMI REDMI NOTE 13 6GO 128GO

SMARTPHONE XIAOMI REDMI NOTE 13 6GO 128GO

SMARTPHONE XIAOMI REDMI NOTE 13 6GO 128GO

SMARTPHONE XIAOMI REDMI NOTE 13 6GO 128GO

SMARTPHONE XIAOMI REDMI NOTE 13 PRO 12GO 512GO

SMARTPHONE XIAOMI REDMI NOTE 13 PRO 12GO 512GO

SMARTPHONE XIAOMI REDMI NOTE 13 PRO 12GO 512GO

SMARTPHONE XIAOMI REDMI NOTE 13 PRO 12GO 512GO

SMARTPHONE XIAOMI REDMI NOTE 13 PRO+ 5G 12GO 512GO

SMARTPHONE XIAOMI REDMI NOTE 13 PRO+ 5G 12GO 512GO

SMARTPHONE XIAOMI REDMI NOTE 13 PRO+ 5G 12GO 512GO

SMARTPHONE XIAOMI REDMI NOTE 13 PRO+ 5G 12GO 512GO

SMARTPHONE HONOR X9B 5G 12GO 256G

SMARTPHONE HONOR X9B 5G 12GO 256G

SMARTPHONE HONOR X9B 5G 12GO 256G

SMARTPHONE HONOR X9B 5G 12GO 256G

SMARTPHONE HONOR X9C 5G 12GB 256GB

SMARTPHONE HONOR X9C 5G 12GB 256GB

SMARTPHONE HONOR X9C 5G 12GB 256GB

SMARTPHONE HONOR X9C 5G 12GB 256GB

SMARTPHONE XIAOMI REDMI NOTE 14 PRO 12GB 512GB

SMARTPHONE XIAOMI REDMI NOTE 14 PRO 12GB 512GB

SMARTPHONE XIAOMI REDMI NOTE 14 PRO 12GB 512GB

SMARTPHONE XIAOMI REDMI NOTE 14 PRO 12GB 512GB

SMARTPHONE SAMSUNG GALAXY S25 ULTRA 12GB 256GB NOIR

SMARTPHONE SAMSUNG GALAXY S25 ULTRA 12GB 256GB NOIR

SMARTPHONE SAMSUNG GALAXY S25 ULTRA 12GB 256GB NOIR

SMARTPHONE SAMSUNG GALAXY S25 ULTRA 12GB 256GB NOIR

Stopwatch SQL - 1247 queries

Doubles

Tables stress

ObjectModel instances

Included Files