Smartphone & Mobile

Nouveau

Écran : 6,71" LCD IPS , 90Hz Processeur : Mediatek Hélio G36 (12 nm) Octa-core (Cortex-A53 4x2,2 GHz et Cortex-A53 4x1,6 GHz) Système d’exploitation : Android 14 RAM : 4Go Stockage : 128Go Appareil photo Arrière: Double AI 8MP Appareil...

389,000 TND

Aperçu rapide

Nouveau

SMARTPHONE REDMI A3 4G 128G

Smartphones

389,000 TND

Aperçu rapide

Nouveau

SMARTPHONE REDMI A3 3G 64G

329,000 TND

Nouveau

SMARTPHONE REDMI A3 3G 64G

329,000 TND

Nouveau

SMARTPHONE REDMI A3 3G 64G

Smartphones

329,000 TND

Aperçu rapide

Nouveau

SMARTPHONE REDMI A3 3G 64G

Smartphones

329,000 TND

Aperçu rapide

Nouveau

SMARTPHONE OPPO RENO 11F 5G 8GO 256GO

1 199,000 TND

Nouveau

SMARTPHONE OPPO RENO 11F 5G 8GO 256GO

1 199,000 TND

Nouveau

SMARTPHONE OPPO RENO 11F 5G 8GO 256GO

Smartphones

Ecran : 6.7" Amoled , 1B colors, Screen FHD+ (2412 x 1080), 120 Hz, HDR10+ Processeur : MediaTek Dimensité 7050 Octa-core (Cortex-A78 2x2,6 GHz et Cortex-A55 6x2,0 GHz) Système...

1 199,000 TND

Aperçu rapide

Nouveau

SMARTPHONE OPPO RENO 11F 5G 8GO 256GO

Smartphones

Ecran : 6.7" Amoled , 1B colors, Screen FHD+ (2412 x 1080), 120 Hz, HDR10+ Processeur : MediaTek Dimensité 7050 Octa-core (Cortex-A78 2x2,6 GHz et Cortex-A55 6x2,0 GHz) Système...

1 199,000 TND

Aperçu rapide

Load Time	753.460 ms
Querying Time	611 ms
Queries	994
Memory Peak Usage	32.4 Mb
Included Files	776 files - 9.45 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 $_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.556 ms	0.560 ms	0.07 Mb	2.5 Mb
init	9.692 ms	10.252 ms	0.51 Mb	2.9 Mb
checkAccess	0.002 ms	10.254 ms	- Mb	2.9 Mb
setMedia	2.737 ms	12.991 ms	0.23 Mb	2.9 Mb
postProcess	0.001 ms	12.992 ms	- Mb	2.9 Mb
initHeader	0.001 ms	12.993 ms	- Mb	2.9 Mb
initContent	159.213 ms	172.206 ms	4.30 Mb	7.3 Mb
initFooter	0.002 ms	172.208 ms	- Mb	7.3 Mb
display	581.252 ms	753.460 ms	24.84 Mb	32.4 Mb

Hook	Time	Memory Usage
DisplayLeftColumn	330.269 ms	5.48 Mb
=> tvcmsnewproducts	120.279 ms	1.90 Mb
=> tvcmsfeaturedproducts	188.649 ms	1.93 Mb
=> tvcmsbestsellerproducts	21.341 ms	1.65 Mb
DisplayNavFullWidth	206.149 ms	15.35 Mb
=> ets_megamenu	206.149 ms	15.35 Mb
DisplayReviewProductList	7.330 ms	0.96 Mb
=> tvcmsproductcomments	0.884 ms	0.12 Mb
=> tvcmsproductcomments	0.496 ms	0.07 Mb
=> tvcmsproductcomments	0.589 ms	0.07 Mb
=> tvcmsproductcomments	0.640 ms	0.07 Mb
=> tvcmsproductcomments	0.736 ms	0.11 Mb
=> tvcmsproductcomments	0.434 ms	0.07 Mb
=> tvcmsproductcomments	0.482 ms	0.07 Mb
=> tvcmsproductcomments	0.444 ms	0.07 Mb
=> tvcmsproductcomments	0.796 ms	0.11 Mb
=> tvcmsproductcomments	0.605 ms	0.07 Mb
=> tvcmsproductcomments	0.572 ms	0.07 Mb
=> tvcmsproductcomments	0.652 ms	0.07 Mb
DisplayHeader	6.371 ms	1.22 Mb
=> ps_shoppingcart	0.032 ms	- Mb
=> ps_searchbar	0.154 ms	- Mb
=> ps_googleanalytics	0.013 ms	- Mb
=> tvcmsbestsellerproducts	0.053 ms	- Mb
=> tvcmscategoryslider	0.061 ms	- Mb
=> tvcmscookiesnotice	0.052 ms	- Mb
=> tvcmscustomsetting	0.338 ms	0.01 Mb
=> tvcmsfeaturedproducts	0.036 ms	- Mb
=> tvcmsmultibanner1	0.056 ms	- Mb
=> tvcmsnewproducts	0.036 ms	- Mb
=> tvcmsproductcomments	0.183 ms	- Mb
=> tvcmsproductcompare	0.085 ms	- Mb
=> tvcmssearch	0.115 ms	- Mb
=> tvcmsslider	0.050 ms	- Mb
=> tvcmsthemeoptions	0.151 ms	- Mb
=> tvcmswishlist	0.079 ms	- Mb
=> ets_megamenu	4.877 ms	1.18 Mb
DisplayNavSearchBlock	3.314 ms	0.51 Mb
=> tvcmssearch	3.314 ms	0.51 Mb
DisplayFooterCategory	2.132 ms	0.24 Mb
=> tvcmsfootercategory	2.132 ms	0.24 Mb
displayLeftColumn	2.070 ms	0.06 Mb
=> ps_categorytree (widget)	2.070 ms	0.06 Mb
DisplayBeforeBodyClosingTag	1.597 ms	0.05 Mb
=> statsdata	1.597 ms	0.05 Mb
DisplayWishlistBtnProductList	1.401 ms	0.02 Mb
=> tvcmswishlist	0.152 ms	0.01 Mb
=> tvcmswishlist	0.119 ms	- Mb
=> tvcmswishlist	0.202 ms	- Mb
=> tvcmswishlist	0.103 ms	- Mb
=> tvcmswishlist	0.103 ms	- Mb
=> tvcmswishlist	0.086 ms	- Mb
=> tvcmswishlist	0.124 ms	- Mb
=> tvcmswishlist	0.075 ms	- Mb
=> tvcmswishlist	0.121 ms	- Mb
=> tvcmswishlist	0.098 ms	- Mb
=> tvcmswishlist	0.122 ms	- Mb
=> tvcmswishlist	0.096 ms	- Mb
DisplayProductCompareProductList	1.291 ms	0.02 Mb
=> tvcmsproductcompare	0.143 ms	0.01 Mb
=> tvcmsproductcompare	0.093 ms	- Mb
=> tvcmsproductcompare	0.175 ms	- Mb
=> tvcmsproductcompare	0.089 ms	- Mb
=> tvcmsproductcompare	0.109 ms	- Mb
=> tvcmsproductcompare	0.107 ms	- Mb
=> tvcmsproductcompare	0.087 ms	- Mb
=> tvcmsproductcompare	0.079 ms	- Mb
=> tvcmsproductcompare	0.106 ms	- Mb
=> tvcmsproductcompare	0.121 ms	- Mb
=> tvcmsproductcompare	0.093 ms	- Mb
=> tvcmsproductcompare	0.089 ms	- Mb
Header	1.116 ms	0.05 Mb
=> tvcmsinfinitescroll	0.992 ms	0.04 Mb
=> tvcmsofferbanner	0.062 ms	- Mb
=> tvcmsleftsideofferbanner	0.002 ms	- Mb
=> tvcmstwoofferbanner	0.060 ms	- Mb
displayNav1	0.804 ms	0.08 Mb
=> ps_contactinfo (widget)	0.804 ms	0.08 Mb
DisplayCustomsocialblock	0.779 ms	0.09 Mb
=> tvcmscustomsetting	0.779 ms	0.09 Mb
displayFooterPart1	0.638 ms	0.06 Mb
=> ps_linklist (widget)	0.638 ms	0.06 Mb
displayNavCurrencyBlock	0.596 ms	0.08 Mb
=> ps_currencyselector (widget)	0.596 ms	0.08 Mb
displayNewslettersubscription	0.558 ms	0.06 Mb
=> ps_emailsubscription (widget)	0.558 ms	0.06 Mb
displayMyaccountcblock	0.540 ms	0.06 Mb
=> ps_customeraccountlinks (widget)	0.540 ms	0.06 Mb
displaySocialMediaBlock	0.486 ms	0.07 Mb
=> ps_socialfollow (widget)	0.486 ms	0.07 Mb
displayContactCinfo	0.410 ms	0.03 Mb
=> ps_contactinfo (widget)	0.410 ms	0.03 Mb
DisplayNavWishlistBlock	0.391 ms	0.03 Mb
=> tvcmswishlist	0.391 ms	0.03 Mb
displayNavLanguageBlock	0.338 ms	0.05 Mb
=> ps_languageselector (widget)	0.338 ms	0.05 Mb
ProductSearchProvider	0.232 ms	- Mb
=> ps_facetedsearch	0.232 ms	- Mb
ActionFrontControllerSetMedia	0.220 ms	0.01 Mb
=> ps_emailsubscription	0.109 ms	- Mb
=> ps_socialfollow	0.057 ms	- Mb
=> ps_emailalerts	0.054 ms	- Mb
displayNavShoppingCartBlock	0.214 ms	- Mb
=> ps_shoppingcart (widget)	0.214 ms	- Mb
DisplayFacetedSearchBlock	0.129 ms	0.03 Mb
=> ps_facetedsearch	0.129 ms	0.03 Mb
DisplayNavProductCompareBlock	0.119 ms	0.01 Mb
=> tvcmsproductcompare	0.119 ms	0.01 Mb
displayNavCustomerSignInBlock	0.118 ms	- Mb
=> ps_customersignin (widget)	0.118 ms	- Mb
DisplayCopyRightText	0.096 ms	0.01 Mb
=> tvcmscustomsetting	0.096 ms	0.01 Mb
DisplayTopOfferText	0.012 ms	- Mb
=> tvcmscustomsetting	0.007 ms	- Mb
=> tvcmscustomsetting	0.005 ms	- Mb
DisplayCustomCss	0.006 ms	- Mb
=> tvcmscustomcssjs	0.006 ms	- Mb
DisplayMegamenu	0.005 ms	- Mb
=> ets_megamenu	0.005 ms	- Mb
DisplayCustomJs	0.004 ms	- Mb
=> tvcmscustomcssjs	0.004 ms	- Mb
32 hook(s)	569.736 ms	24.62 Mb

Module	Time	Memory Usage
ps_emailsubscription	1.224 ms	0.14 Mb
__construct	0.552 ms	0.08 Mb
hookActionFrontControllerSetMedia	0.112 ms	0.01 Mb
displayNewslettersubscription	0.560 ms	0.06 Mb
ps_socialfollow	0.600 ms	0.07 Mb
__construct	0.053 ms	0.01 Mb
hookActionFrontControllerSetMedia	0.059 ms	- Mb
displaySocialMediaBlock	0.488 ms	0.07 Mb
ps_emailalerts	0.174 ms	0.01 Mb
__construct	0.117 ms	0.01 Mb
hookActionFrontControllerSetMedia	0.057 ms	- Mb
ps_shoppingcart	0.312 ms	0.01 Mb
__construct	0.061 ms	0.01 Mb
hookDisplayHeader	0.034 ms	- Mb
displayNavShoppingCartBlock	0.217 ms	0.01 Mb
ps_searchbar	0.202 ms	0.01 Mb
__construct	0.046 ms	0.01 Mb
hookDisplayHeader	0.156 ms	- Mb
ps_googleanalytics	0.082 ms	0.01 Mb
__construct	0.068 ms	0.01 Mb
hookDisplayHeader	0.014 ms	- Mb
tvcmsbestsellerproducts	21.534 ms	1.68 Mb
__construct	0.136 ms	0.03 Mb
hookDisplayHeader	0.054 ms	- Mb
hookDisplayLeftColumn	21.344 ms	1.65 Mb
tvcmscategoryslider	0.154 ms	0.01 Mb
__construct	0.092 ms	0.01 Mb
hookDisplayHeader	0.062 ms	- Mb
tvcmscookiesnotice	0.132 ms	0.01 Mb
__construct	0.079 ms	0.01 Mb
hookDisplayHeader	0.053 ms	- Mb
tvcmscustomsetting	1.313 ms	0.13 Mb
__construct	0.079 ms	0.01 Mb
hookDisplayHeader	0.339 ms	0.01 Mb
hookDisplayTopOfferText	0.009 ms	- Mb
hookDisplayTopOfferText	0.007 ms	- Mb
hookDisplayCustomsocialblock	0.781 ms	0.10 Mb
hookDisplayCopyRightText	0.098 ms	0.01 Mb
tvcmsfeaturedproducts	188.764 ms	1.94 Mb
__construct	0.075 ms	0.01 Mb
hookDisplayHeader	0.037 ms	- Mb
hookDisplayLeftColumn	188.652 ms	1.93 Mb
tvcmsmultibanner1	0.128 ms	0.01 Mb
__construct	0.071 ms	0.01 Mb
hookDisplayHeader	0.057 ms	- Mb
tvcmsnewproducts	120.423 ms	1.91 Mb
__construct	0.103 ms	0.01 Mb
hookDisplayHeader	0.037 ms	- Mb
hookDisplayLeftColumn	120.283 ms	1.90 Mb
tvcmsproductcomments	7.647 ms	0.99 Mb
__construct	0.113 ms	0.02 Mb
hookDisplayHeader	0.184 ms	- Mb
hookDisplayReviewProductList	0.885 ms	0.12 Mb
hookDisplayReviewProductList	0.497 ms	0.07 Mb
hookDisplayReviewProductList	0.591 ms	0.07 Mb
hookDisplayReviewProductList	0.643 ms	0.07 Mb
hookDisplayReviewProductList	0.737 ms	0.11 Mb
hookDisplayReviewProductList	0.437 ms	0.07 Mb
hookDisplayReviewProductList	0.484 ms	0.07 Mb
hookDisplayReviewProductList	0.445 ms	0.07 Mb
hookDisplayReviewProductList	0.798 ms	0.11 Mb
hookDisplayReviewProductList	0.607 ms	0.07 Mb
hookDisplayReviewProductList	0.573 ms	0.07 Mb
hookDisplayReviewProductList	0.653 ms	0.07 Mb
tvcmsproductcompare	1.624 ms	0.03 Mb
__construct	0.105 ms	- Mb
hookDisplayHeader	0.086 ms	- Mb
hookDisplayNavProductCompareBlock	0.121 ms	0.01 Mb
hookDisplayProductCompareProductList	0.145 ms	0.01 Mb
hookDisplayProductCompareProductList	0.095 ms	- Mb
hookDisplayProductCompareProductList	0.177 ms	- Mb
hookDisplayProductCompareProductList	0.091 ms	- Mb
hookDisplayProductCompareProductList	0.111 ms	- Mb
hookDisplayProductCompareProductList	0.109 ms	- Mb
hookDisplayProductCompareProductList	0.089 ms	- Mb
hookDisplayProductCompareProductList	0.080 ms	- Mb
hookDisplayProductCompareProductList	0.108 ms	- Mb
hookDisplayProductCompareProductList	0.122 ms	- Mb
hookDisplayProductCompareProductList	0.095 ms	- Mb
hookDisplayProductCompareProductList	0.090 ms	- Mb
tvcmssearch	3.503 ms	0.52 Mb
__construct	0.071 ms	0.01 Mb
hookDisplayHeader	0.116 ms	- Mb
hookDisplayNavSearchBlock	3.316 ms	0.51 Mb
tvcmsslider	0.148 ms	0.01 Mb
__construct	0.097 ms	0.01 Mb
hookDisplayHeader	0.051 ms	- Mb
tvcmsthemeoptions	0.253 ms	0.01 Mb
__construct	0.100 ms	0.01 Mb
hookDisplayHeader	0.153 ms	0.01 Mb
tvcmswishlist	2.006 ms	0.08 Mb
__construct	0.112 ms	0.02 Mb
hookDisplayHeader	0.081 ms	- Mb
hookDisplayNavWishlistBlock	0.393 ms	0.04 Mb
hookDisplayWishlistBtnProductList	0.153 ms	0.01 Mb
hookDisplayWishlistBtnProductList	0.121 ms	- Mb
hookDisplayWishlistBtnProductList	0.205 ms	- Mb
hookDisplayWishlistBtnProductList	0.104 ms	- Mb
hookDisplayWishlistBtnProductList	0.104 ms	- Mb
hookDisplayWishlistBtnProductList	0.088 ms	- Mb
hookDisplayWishlistBtnProductList	0.126 ms	- Mb
hookDisplayWishlistBtnProductList	0.076 ms	- Mb
hookDisplayWishlistBtnProductList	0.123 ms	- Mb
hookDisplayWishlistBtnProductList	0.100 ms	- Mb
hookDisplayWishlistBtnProductList	0.123 ms	- Mb
hookDisplayWishlistBtnProductList	0.098 ms	- Mb
ets_megamenu	211.191 ms	16.59 Mb
__construct	0.152 ms	0.05 Mb
hookDisplayHeader	4.879 ms	1.18 Mb
hookDisplayMegamenu	0.007 ms	- Mb
hookDisplayNavFullWidth	206.153 ms	15.35 Mb
ps_customersignin	0.207 ms	0.01 Mb
__construct	0.087 ms	0.01 Mb
displayNavCustomerSignInBlock	0.120 ms	- Mb
tvcmsinfinitescroll	1.102 ms	0.09 Mb
__construct	0.108 ms	0.05 Mb
hookHeader	0.994 ms	0.04 Mb
tvcmsofferbanner	0.188 ms	- Mb
__construct	0.124 ms	- Mb
hookHeader	0.064 ms	- Mb
tvcmsleftsideofferbanner	0.116 ms	0.01 Mb
__construct	0.112 ms	0.01 Mb
hookHeader	0.004 ms	- Mb
tvcmstwoofferbanner	0.178 ms	0.01 Mb
__construct	0.116 ms	0.01 Mb
hookHeader	0.062 ms	- Mb
ps_facetedsearch	0.566 ms	0.05 Mb
__construct	0.201 ms	0.01 Mb
hookProductSearchProvider	0.234 ms	- Mb
hookDisplayFacetedSearchBlock	0.131 ms	0.03 Mb
tvcmscustomcssjs	0.167 ms	0.01 Mb
__construct	0.154 ms	0.01 Mb
hookDisplayCustomCss	0.008 ms	- Mb
hookDisplayCustomJs	0.005 ms	- Mb
ps_languageselector	0.431 ms	0.06 Mb
__construct	0.091 ms	0.01 Mb
displayNavLanguageBlock	0.340 ms	0.05 Mb
ps_currencyselector	0.662 ms	0.09 Mb
__construct	0.063 ms	0.01 Mb
displayNavCurrencyBlock	0.599 ms	0.08 Mb
ps_contactinfo	1.281 ms	0.12 Mb
__construct	0.063 ms	0.01 Mb
displayNav1	0.806 ms	0.09 Mb
displayContactCinfo	0.412 ms	0.03 Mb
ps_categorytree	2.171 ms	0.07 Mb
__construct	0.098 ms	0.01 Mb
displayLeftColumn	2.073 ms	0.06 Mb
tvcmsfootercategory	2.253 ms	0.24 Mb
__construct	0.119 ms	0.01 Mb
hookDisplayFooterCategory	2.134 ms	0.24 Mb
ps_linklist	0.773 ms	0.07 Mb
__construct	0.133 ms	0.01 Mb
displayFooterPart1	0.640 ms	0.06 Mb
ps_customeraccountlinks	0.599 ms	0.06 Mb
__construct	0.057 ms	0.01 Mb
displayMyaccountcblock	0.542 ms	0.06 Mb
statsdata	1.654 ms	0.05 Mb
__construct	0.055 ms	0.01 Mb
hookDisplayBeforeBodyClosingTag	1.599 ms	0.05 Mb
35 module(s)	573.762 ms	25.04 Mb

SMARTPHONE REDMI A3 4G 128G

SMARTPHONE REDMI A3 4G 128G

SMARTPHONE REDMI A3 4G 128G

SMARTPHONE REDMI A3 4G 128G

SMARTPHONE REDMI A3 3G 64G

SMARTPHONE REDMI A3 3G 64G

SMARTPHONE REDMI A3 3G 64G

SMARTPHONE REDMI A3 3G 64G

SMARTPHONE OPPO RENO 11F 5G 8GO 256GO

SMARTPHONE OPPO RENO 11F 5G 8GO 256GO

SMARTPHONE OPPO RENO 11F 5G 8GO 256GO

SMARTPHONE OPPO RENO 11F 5G 8GO 256GO

Stopwatch SQL - 994 queries

Doubles

Tables stress

ObjectModel instances

Included Files

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	44	/classes/Link.php:113 (__construct) [id: 9203] /classes/Link.php:113 (__construct) [id: 9204] /classes/Link.php:113 (__construct) [id: 9220] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 9203] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 9204] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 9220] /classes/Link.php:113 (__construct) [id: 9203] /classes/Link.php:113 (__construct) [id: 9204] /classes/Link.php:113 (__construct) [id: 9220] /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: 9133] /classes/Link.php:113 (__construct) [id: 9616] /classes/Link.php:113 (__construct) [id: 9386] /classes/Link.php:113 (__construct) [id: 9362] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 9133] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 9616] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 9386] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 9362] /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: 9203] /classes/Link.php:113 (__construct) [id: 9203] /classes/Link.php:113 (__construct) [id: 9203] /classes/Link.php:113 (__construct) [id: 9203] /src/Adapter/Presenter/Product/ProductLazyArray.php:662 (__construct) [id: 9204] /classes/Link.php:113 (__construct) [id: 9204] /classes/Link.php:113 (__construct) [id: 9204] /classes/Link.php:113 (__construct) [id: 9204] /src/Adapter/Presenter/Product/ProductLazyArray.php:662 (__construct) [id: 9220] /classes/Link.php:113 (__construct) [id: 9220] /classes/Link.php:113 (__construct) [id: 9220]
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]
Combination	6	/classes/Product.php:5893 (__construct) [id: 814] /classes/Product.php:5893 (__construct) [id: 817] /classes/Product.php:5893 (__construct) [id: 820] /classes/Product.php:5893 (__construct) [id: 1034] /classes/Product.php:5893 (__construct) [id: 1037] /classes/Product.php:5893 (__construct) [id: 873]
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
793	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	132.450 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)
721	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	97.701 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)
843	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	29.861 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)
96	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, pa.id_product_attribute, 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_1 ON (p.id_product = fp_1.id_product) LEFT JOIN mb_feature_product fp_2 ON (p.id_product = fp_2.id_product) LEFT JOIN mb_feature_product fp_3 ON (p.id_product = fp_3.id_product) WHERE ((pac.id_attribute=14)) AND ((fp_1.id_feature_value=13080)) AND ((fp_2.id_feature_value IN (12992, 12993, 23697, 27024, 24312))) AND ((fp_3.id_feature_value IN (27111, 21056, 27688, 27032, 27042, 14362, 27056, 27087, 27093, 11784, 27141, 27534, 20899, 27935, 214))) 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_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mb_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) LEFT JOIN mb_feature_product fp_2 ON (p.id_product = fp_2.id_product) LEFT JOIN mb_feature_product fp_3 ON (p.id_product = fp_3.id_product) LEFT JOIN mb_feature_product fp_4 ON (p.id_product = fp_4.id_product) WHERE ((fp.id_feature=6)) AND ((pac_1.id_attribute=14)) AND ((fp_2.id_feature_value=13080)) AND ((fp_3.id_feature_value IN (12992, 12993, 23697, 27024, 24312))) AND ((fp_4.id_feature_value IN (27111, 21056, 27688, 27032, 27042, 14362, 27056, 27087, 27093, 11784, 27141, 27534, 20899, 27935, 214))) GROUP BY fp.id_feature_value	2.927 ms	700928	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)
78	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, pa.id_product_attribute, 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_1 ON (p.id_product = fp_1.id_product) LEFT JOIN mb_feature_product fp_2 ON (p.id_product = fp_2.id_product) LEFT JOIN mb_feature_product fp_3 ON (p.id_product = fp_3.id_product) WHERE ((pac.id_attribute=14)) AND ((fp_1.id_feature_value=13080)) AND ((fp_2.id_feature_value IN (12992, 12993, 23697, 27024, 24312))) AND ((fp_3.id_feature_value IN (27111, 21056, 27688, 27032, 27042, 14362, 27056, 27087, 27093, 11784, 27141, 27534, 20899, 27935, 214))) 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_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_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) LEFT JOIN mb_feature_product fp_3 ON (p.id_product = fp_3.id_product) WHERE ((pac.id_attribute=14)) AND ((fp_1.id_feature_value=13080)) AND ((fp_2.id_feature_value IN (12992, 12993, 23697, 27024, 24312))) AND ((fp_3.id_feature_value IN (27111, 21056, 27688, 27032, 27042, 14362, 27056, 27087, 27093, 11784, 27141, 27534, 20899, 27935, 214))) AND cg.id_group='1' AND c.level_depth<=4 AND c.nleft>188 AND c.nright<195 GROUP BY cp.id_category	2.754 ms	4736	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)
85	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, pa.id_product_attribute, 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) LEFT JOIN mb_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((fp.id_feature_value=13080)) AND ((fp_1.id_feature_value IN (12992, 12993, 23697, 27024, 24312))) AND ((fp_2.id_feature_value IN (27111, 21056, 27688, 27032, 27042, 14362, 27056, 27087, 27093, 11784, 27141, 27534, 20899, 27935, 214))) 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) LEFT JOIN mb_feature_product fp_3 ON (p.id_product = fp_3.id_product) WHERE ((a.id_attribute_group=3)) AND ((fp_1.id_feature_value=13080)) AND ((fp_2.id_feature_value IN (12992, 12993, 23697, 27024, 24312))) AND ((fp_3.id_feature_value IN (27111, 21056, 27688, 27032, 27042, 14362, 27056, 27087, 27093, 11784, 27141, 27534, 20899, 27935, 214))) GROUP BY pac.id_attribute	2.627 ms	700928	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)
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, pa.id_product_attribute, 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_1 ON (p.id_product = fp_1.id_product) LEFT JOIN mb_feature_product fp_2 ON (p.id_product = fp_2.id_product) LEFT JOIN mb_feature_product fp_3 ON (p.id_product = fp_3.id_product) WHERE ((pac.id_attribute=14)) AND ((fp_1.id_feature_value=13080)) AND ((fp_2.id_feature_value IN (12992, 12993, 23697, 27024, 24312))) AND ((fp_3.id_feature_value IN (27111, 21056, 27688, 27032, 27042, 14362, 27056, 27087, 27093, 11784, 27141, 27534, 20899, 27935, 214))) 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_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mb_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) LEFT JOIN mb_feature_product fp_2 ON (p.id_product = fp_2.id_product) LEFT JOIN mb_feature_product fp_3 ON (p.id_product = fp_3.id_product) LEFT JOIN mb_feature_product fp_4 ON (p.id_product = fp_4.id_product) WHERE ((fp.id_feature=4)) AND ((pac_1.id_attribute=14)) AND ((fp_2.id_feature_value=13080)) AND ((fp_3.id_feature_value IN (12992, 12993, 23697, 27024, 24312))) AND ((fp_4.id_feature_value IN (27111, 21056, 27688, 27032, 27042, 14362, 27056, 27087, 27093, 11784, 27141, 27534, 20899, 27935, 214))) GROUP BY fp.id_feature_value	2.437 ms	700928	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)
92	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, pa.id_product_attribute, 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_1 ON (p.id_product = fp_1.id_product) LEFT JOIN mb_feature_product fp_2 ON (p.id_product = fp_2.id_product) LEFT JOIN mb_feature_product fp_3 ON (p.id_product = fp_3.id_product) WHERE ((pac.id_attribute=14)) AND ((fp_1.id_feature_value=13080)) AND ((fp_2.id_feature_value IN (12992, 12993, 23697, 27024, 24312))) AND ((fp_3.id_feature_value IN (27111, 21056, 27688, 27032, 27042, 14362, 27056, 27087, 27093, 11784, 27141, 27534, 20899, 27935, 214))) 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_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mb_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) LEFT JOIN mb_feature_product fp_2 ON (p.id_product = fp_2.id_product) LEFT JOIN mb_feature_product fp_3 ON (p.id_product = fp_3.id_product) LEFT JOIN mb_feature_product fp_4 ON (p.id_product = fp_4.id_product) WHERE ((fp.id_feature=3)) AND ((pac_1.id_attribute=14)) AND ((fp_2.id_feature_value=13080)) AND ((fp_3.id_feature_value IN (12992, 12993, 23697, 27024, 24312))) AND ((fp_4.id_feature_value IN (27111, 21056, 27688, 27032, 27042, 14362, 27056, 27087, 27093, 11784, 27141, 27534, 20899, 27935, 214))) GROUP BY fp.id_feature_value	2.373 ms	700928	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)
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, pa.id_product_attribute, 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_1 ON (p.id_product = fp_1.id_product) LEFT JOIN mb_feature_product fp_2 ON (p.id_product = fp_2.id_product) LEFT JOIN mb_feature_product fp_3 ON (p.id_product = fp_3.id_product) WHERE ((pac.id_attribute=14)) AND ((fp_1.id_feature_value=13080)) AND ((fp_2.id_feature_value IN (12992, 12993, 23697, 27024, 24312))) AND ((fp_3.id_feature_value IN (27111, 21056, 27688, 27032, 27042, 14362, 27056, 27087, 27093, 11784, 27141, 27534, 20899, 27935, 214))) 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_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mb_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) LEFT JOIN mb_feature_product fp_2 ON (p.id_product = fp_2.id_product) LEFT JOIN mb_feature_product fp_3 ON (p.id_product = fp_3.id_product) LEFT JOIN mb_feature_product fp_4 ON (p.id_product = fp_4.id_product) WHERE ((fp.id_feature=33)) AND ((pac_1.id_attribute=14)) AND ((fp_2.id_feature_value=13080)) AND ((fp_3.id_feature_value IN (12992, 12993, 23697, 27024, 24312))) AND ((fp_4.id_feature_value IN (27111, 21056, 27688, 27032, 27042, 14362, 27056, 27087, 27093, 11784, 27141, 27534, 20899, 27935, 214))) GROUP BY fp.id_feature_value	2.317 ms	700928	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)
2	SELECT SQL_NO_CACHE c.`name`, cl.`id_lang`, IF(cl.`id_lang` IS NULL, c.`value`, cl.`value`) AS value, c.id_shop_group, c.id_shop FROM `mb_configuration` c LEFT JOIN `mb_configuration_lang` cl ON (c.`id_configuration` = cl.`id_configuration`)	2.250 ms	928		/classes/Configuration.php:180 /classes/Configuration.php:229 (loadConfiguration) /classes/Configuration.php:302 (get) /classes/shop/Shop.php:398 (getMultiShopValues) /config/config.inc.php:117 (initialize) /index.php:27 (require)
122	SELECT SQL_NO_CACHE fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, pa.id_product_attribute, 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_1 ON (p.id_product = fp_1.id_product) LEFT JOIN mb_feature_product fp_2 ON (p.id_product = fp_2.id_product) LEFT JOIN mb_feature_product fp_3 ON (p.id_product = fp_3.id_product) WHERE ((pac.id_attribute=14)) AND ((fp_1.id_feature_value=13080)) AND ((fp_2.id_feature_value IN (12992, 12993, 23697, 27024, 24312))) AND ((fp_3.id_feature_value IN (27111, 21056, 27688, 27032, 27042, 14362, 27056, 27087, 27093, 11784, 27141, 27534, 20899, 27935, 214))) 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_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mb_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) LEFT JOIN mb_feature_product fp_2 ON (p.id_product = fp_2.id_product) LEFT JOIN mb_feature_product fp_3 ON (p.id_product = fp_3.id_product) LEFT JOIN mb_feature_product fp_4 ON (p.id_product = fp_4.id_product) WHERE ((fp.id_feature=32)) AND ((pac_1.id_attribute=14)) AND ((fp_2.id_feature_value=13080)) AND ((fp_3.id_feature_value IN (12992, 12993, 23697, 27024, 24312))) AND ((fp_4.id_feature_value IN (27111, 21056, 27688, 27032, 27042, 14362, 27056, 27087, 27093, 11784, 27141, 27534, 20899, 27935, 214))) GROUP BY fp.id_feature_value	2.213 ms	700928	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)
74	SELECT SQL_NO_CACHE p.id_product, p.id_product_attribute 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, pa.id_product_attribute, 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_1 ON (p.id_product = fp_1.id_product) LEFT JOIN mb_feature_product fp_2 ON (p.id_product = fp_2.id_product) LEFT JOIN mb_feature_product fp_3 ON (p.id_product = fp_3.id_product) WHERE ((pac.id_attribute=14)) AND ((fp_1.id_feature_value=13080)) AND ((fp_2.id_feature_value IN (12992, 12993, 23697, 27024, 24312))) AND ((fp_3.id_feature_value IN (27111, 21056, 27688, 27032, 27042, 14362, 27056, 27087, 27093, 11784, 27141, 27534, 20899, 27935, 214))) 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) 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	2.195 ms	87616	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)
152	SELECT SQL_NO_CACHE h.id_hook, h.name as h_name, title, description, h.position, hm.position as hm_position, m.id_module, m.name, m.active FROM `mb_hook_module` hm STRAIGHT_JOIN `mb_hook` h ON (h.id_hook = hm.id_hook AND hm.id_shop = 1) STRAIGHT_JOIN `mb_module` as m ON (m.id_module = hm.id_module) ORDER BY hm.position	2.159 ms	469		/classes/Hook.php:456 /classes/Hook.php:493 (getHookModuleList) /classes/tax/TaxManagerFactory.php:67 (getModulesFromHook) /classes/tax/TaxManagerFactory.php:46 (execHookTaxManagerFactory) /classes/Product.php:3925 (getManager) /classes/Product.php:3717 (priceCalculation) /classes/Product.php:5675 (getPriceStatic) /classes/ProductAssembler.php:209 (getProductProperties) /classes/controller/ProductListingFrontController.php:108 (assembleProducts) /classes/controller/ProductListingFrontController.php:379 (prepareMultipleProductsForTemplate) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:138 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
212	SELECT SQL_NO_CACHE c., cl. 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.`level_depth` ASC , category_shop.`position` ASC	2.157 ms	245	Yes	/classes/Category.php:799 /modules/tvcmssearch/tvcmssearch.php:102 (getNestedCategories) /modules/tvcmssearch/tvcmssearch.php:213 (getAllCategories) /classes/Hook.php:1043 (hookdisplayNavSearchBlock) /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/61/ed/c3/61edc3eb579de51f40a524f7e0cb944dbe3715bc_2.file.desk-header-2.tpl.php:29 (__call) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68816b9b74e556_49315661) /vendor/smarty/smarty/libs/sysplugins/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/52/ff/b8/52ffb8ccea06a016c919abddded2a0d83090fa82_2.file.desktop-header.tpl.php:25 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68816b9b743099_20373169) /vendor/smarty/smarty/libs/sysplugins/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/1e/d1/c2/1ed1c2bd038ee59c289bc0dfa862939f4ace5853_2.file.header.tpl.php:55 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/v1_electron_1layouts_layout_left_column_tpl/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)
84	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_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_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) LEFT JOIN mb_feature_product fp_3 ON (p.id_product = fp_3.id_product) WHERE ((pac.id_attribute=14)) AND ((fp_1.id_feature_value=13080)) AND ((fp_2.id_feature_value IN (12992, 12993, 23697, 27024, 24312))) AND ((fp_3.id_feature_value IN (27111, 21056, 27688, 27032, 27042, 14362, 27056, 27087, 27093, 11784, 27141, 27534, 20899, 27935, 214))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=188 AND c.nright<=195	1.932 ms	296		/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)
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, pa.id_product_attribute, 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_1 ON (p.id_product = fp_1.id_product) LEFT JOIN mb_feature_product fp_2 ON (p.id_product = fp_2.id_product) LEFT JOIN mb_feature_product fp_3 ON (p.id_product = fp_3.id_product) WHERE ((pac.id_attribute=14)) AND ((fp_1.id_feature_value=13080)) AND ((fp_2.id_feature_value IN (12992, 12993, 23697, 27024, 24312))) AND ((fp_3.id_feature_value IN (27111, 21056, 27688, 27032, 27042, 14362, 27056, 27087, 27093, 11784, 27141, 27534, 20899, 27935, 214))) 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_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mb_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) LEFT JOIN mb_feature_product fp_2 ON (p.id_product = fp_2.id_product) LEFT JOIN mb_feature_product fp_3 ON (p.id_product = fp_3.id_product) LEFT JOIN mb_feature_product fp_4 ON (p.id_product = fp_4.id_product) WHERE ((fp.id_feature=31)) AND ((pac_1.id_attribute=14)) AND ((fp_2.id_feature_value=13080)) AND ((fp_3.id_feature_value IN (12992, 12993, 23697, 27024, 24312))) AND ((fp_4.id_feature_value IN (27111, 21056, 27688, 27032, 27042, 14362, 27056, 27087, 27093, 11784, 27141, 27534, 20899, 27935, 214))) GROUP BY fp.id_feature_value	1.870 ms	700928	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)
88	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, pa.id_product_attribute, 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_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 ((pac.id_attribute=14)) AND ((fp_1.id_feature_value IN (12992, 12993, 23697, 27024, 24312))) AND ((fp_2.id_feature_value IN (27111, 21056, 27688, 27032, 27042, 14362, 27056, 27087, 27093, 11784, 27141, 27534, 20899, 27935, 214))) 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_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mb_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) LEFT JOIN mb_feature_product fp_2 ON (p.id_product = fp_2.id_product) LEFT JOIN mb_feature_product fp_3 ON (p.id_product = fp_3.id_product) WHERE ((fp.id_feature=1)) AND ((pac_1.id_attribute=14)) AND ((fp_2.id_feature_value IN (12992, 12993, 23697, 27024, 24312))) AND ((fp_3.id_feature_value IN (27111, 21056, 27688, 27032, 27042, 14362, 27056, 27087, 27093, 11784, 27141, 27534, 20899, 27935, 214))) GROUP BY fp.id_feature_value	1.860 ms	121104	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)
103	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, pa.id_product_attribute, 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_1 ON (p.id_product = fp_1.id_product) LEFT JOIN mb_feature_product fp_2 ON (p.id_product = fp_2.id_product) LEFT JOIN mb_feature_product fp_3 ON (p.id_product = fp_3.id_product) WHERE ((pac.id_attribute=14)) AND ((fp_1.id_feature_value=13080)) AND ((fp_2.id_feature_value IN (12992, 12993, 23697, 27024, 24312))) AND ((fp_3.id_feature_value IN (27111, 21056, 27688, 27032, 27042, 14362, 27056, 27087, 27093, 11784, 27141, 27534, 20899, 27935, 214))) 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_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mb_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) LEFT JOIN mb_feature_product fp_2 ON (p.id_product = fp_2.id_product) LEFT JOIN mb_feature_product fp_3 ON (p.id_product = fp_3.id_product) LEFT JOIN mb_feature_product fp_4 ON (p.id_product = fp_4.id_product) WHERE ((fp.id_feature=13)) AND ((pac_1.id_attribute=14)) AND ((fp_2.id_feature_value=13080)) AND ((fp_3.id_feature_value IN (12992, 12993, 23697, 27024, 24312))) AND ((fp_4.id_feature_value IN (27111, 21056, 27688, 27032, 27042, 14362, 27056, 27087, 27093, 11784, 27141, 27534, 20899, 27935, 214))) GROUP BY fp.id_feature_value	1.767 ms	700928	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, pa.id_product_attribute, 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_1 ON (p.id_product = fp_1.id_product) LEFT JOIN mb_feature_product fp_2 ON (p.id_product = fp_2.id_product) LEFT JOIN mb_feature_product fp_3 ON (p.id_product = fp_3.id_product) WHERE ((pac.id_attribute=14)) AND ((fp_1.id_feature_value=13080)) AND ((fp_2.id_feature_value IN (12992, 12993, 23697, 27024, 24312))) AND ((fp_3.id_feature_value IN (27111, 21056, 27688, 27032, 27042, 14362, 27056, 27087, 27093, 11784, 27141, 27534, 20899, 27935, 214))) 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_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mb_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) LEFT JOIN mb_feature_product fp_2 ON (p.id_product = fp_2.id_product) LEFT JOIN mb_feature_product fp_3 ON (p.id_product = fp_3.id_product) LEFT JOIN mb_feature_product fp_4 ON (p.id_product = fp_4.id_product) WHERE ((fp.id_feature=14)) AND ((pac_1.id_attribute=14)) AND ((fp_2.id_feature_value=13080)) AND ((fp_3.id_feature_value IN (12992, 12993, 23697, 27024, 24312))) AND ((fp_4.id_feature_value IN (27111, 21056, 27688, 27032, 27042, 14362, 27056, 27087, 27093, 11784, 27141, 27534, 20899, 27935, 214))) GROUP BY fp.id_feature_value	1.759 ms	700928	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 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, pa.id_product_attribute, 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_1 ON (p.id_product = fp_1.id_product) LEFT JOIN mb_feature_product fp_2 ON (p.id_product = fp_2.id_product) LEFT JOIN mb_feature_product fp_3 ON (p.id_product = fp_3.id_product) WHERE ((pac.id_attribute=14)) AND ((fp_1.id_feature_value=13080)) AND ((fp_2.id_feature_value IN (12992, 12993, 23697, 27024, 24312))) AND ((fp_3.id_feature_value IN (27111, 21056, 27688, 27032, 27042, 14362, 27056, 27087, 27093, 11784, 27141, 27534, 20899, 27935, 214))) 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) 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) LEFT JOIN mb_feature_product fp_3 ON (p.id_product = fp_3.id_product) WHERE ((pac.id_attribute=14)) AND ((fp_1.id_feature_value=13080)) AND ((fp_2.id_feature_value IN (12992, 12993, 23697, 27024, 24312))) AND ((fp_3.id_feature_value IN (27111, 21056, 27688, 27032, 27042, 14362, 27056, 27087, 27093, 11784, 27141, 27534, 20899, 27935, 214)))	1.728 ms	4736		/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)
845	SELECT SQL_NO_CACHE 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 = 1) LEFT JOIN `mb_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 1) WHERE i.`id_product` = 9133 ORDER BY `position`	1.703 ms	1	Yes	/classes/Product.php:3545 /src/Adapter/Image/ImageRetriever.php:84 (getImages) /src/Adapter/Presenter/Product/ProductLazyArray.php:688 (getAllProductImages) /src/Adapter/Presenter/Product/ProductLazyArray.php:127 (fillImages) /src/Adapter/Presenter/Product/ProductListingPresenter.php:57 (__construct) /modules/tvcmstabproducts/tvcmstabproducts.php:2742 (present) /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)
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, pa.id_product_attribute, 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_1 ON (p.id_product = fp_1.id_product) LEFT JOIN mb_feature_product fp_2 ON (p.id_product = fp_2.id_product) LEFT JOIN mb_feature_product fp_3 ON (p.id_product = fp_3.id_product) WHERE ((pac.id_attribute=14)) AND ((fp_1.id_feature_value=13080)) AND ((fp_2.id_feature_value IN (12992, 12993, 23697, 27024, 24312))) AND ((fp_3.id_feature_value IN (27111, 21056, 27688, 27032, 27042, 14362, 27056, 27087, 27093, 11784, 27141, 27534, 20899, 27935, 214))) 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_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mb_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) LEFT JOIN mb_feature_product fp_2 ON (p.id_product = fp_2.id_product) LEFT JOIN mb_feature_product fp_3 ON (p.id_product = fp_3.id_product) LEFT JOIN mb_feature_product fp_4 ON (p.id_product = fp_4.id_product) WHERE ((fp.id_feature=9)) AND ((pac_1.id_attribute=14)) AND ((fp_2.id_feature_value=13080)) AND ((fp_3.id_feature_value IN (12992, 12993, 23697, 27024, 24312))) AND ((fp_4.id_feature_value IN (27111, 21056, 27688, 27032, 27042, 14362, 27056, 27087, 27093, 11784, 27141, 27534, 20899, 27935, 214))) GROUP BY fp.id_feature_value	1.689 ms	700928	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)
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, pa.id_product_attribute, 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_1 ON (p.id_product = fp_1.id_product) LEFT JOIN mb_feature_product fp_2 ON (p.id_product = fp_2.id_product) LEFT JOIN mb_feature_product fp_3 ON (p.id_product = fp_3.id_product) WHERE ((pac.id_attribute=14)) AND ((fp_1.id_feature_value=13080)) AND ((fp_2.id_feature_value IN (12992, 12993, 23697, 27024, 24312))) AND ((fp_3.id_feature_value IN (27111, 21056, 27688, 27032, 27042, 14362, 27056, 27087, 27093, 11784, 27141, 27534, 20899, 27935, 214))) 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_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mb_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) LEFT JOIN mb_feature_product fp_2 ON (p.id_product = fp_2.id_product) LEFT JOIN mb_feature_product fp_3 ON (p.id_product = fp_3.id_product) LEFT JOIN mb_feature_product fp_4 ON (p.id_product = fp_4.id_product) WHERE ((fp.id_feature=5)) AND ((pac_1.id_attribute=14)) AND ((fp_2.id_feature_value=13080)) AND ((fp_3.id_feature_value IN (12992, 12993, 23697, 27024, 24312))) AND ((fp_4.id_feature_value IN (27111, 21056, 27688, 27032, 27042, 14362, 27056, 27087, 27093, 11784, 27141, 27534, 20899, 27935, 214))) GROUP BY fp.id_feature_value	1.665 ms	8448	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, pa.id_product_attribute, 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_1 ON (p.id_product = fp_1.id_product) LEFT JOIN mb_feature_product fp_2 ON (p.id_product = fp_2.id_product) LEFT JOIN mb_feature_product fp_3 ON (p.id_product = fp_3.id_product) WHERE ((pac.id_attribute=14)) AND ((fp_1.id_feature_value=13080)) AND ((fp_2.id_feature_value IN (12992, 12993, 23697, 27024, 24312))) AND ((fp_3.id_feature_value IN (27111, 21056, 27688, 27032, 27042, 14362, 27056, 27087, 27093, 11784, 27141, 27534, 20899, 27935, 214))) 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_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) LEFT JOIN mb_feature_product fp_2 ON (p.id_product = fp_2.id_product) LEFT JOIN mb_feature_product fp_3 ON (p.id_product = fp_3.id_product) LEFT JOIN mb_feature_product fp_4 ON (p.id_product = fp_4.id_product) WHERE ((p.on_sale=1)) AND ((pac_1.id_attribute=14)) AND ((fp_2.id_feature_value=13080)) AND ((fp_3.id_feature_value IN (12992, 12993, 23697, 27024, 24312))) AND ((fp_4.id_feature_value IN (27111, 21056, 27688, 27032, 27042, 14362, 27056, 27087, 27093, 11784, 27141, 27534, 20899, 27935, 214)))	1.660 ms	4736		/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)
90	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, pa.id_product_attribute, 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_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 ((pac.id_attribute=14)) AND ((fp_1.id_feature_value=13080)) AND ((fp_2.id_feature_value IN (27111, 21056, 27688, 27032, 27042, 14362, 27056, 27087, 27093, 11784, 27141, 27534, 20899, 27935, 214))) 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_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mb_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) LEFT JOIN mb_feature_product fp_2 ON (p.id_product = fp_2.id_product) LEFT JOIN mb_feature_product fp_3 ON (p.id_product = fp_3.id_product) WHERE ((fp.id_feature=2)) AND ((pac_1.id_attribute=14)) AND ((fp_2.id_feature_value=13080)) AND ((fp_3.id_feature_value IN (27111, 21056, 27688, 27032, 27042, 14362, 27056, 27087, 27093, 11784, 27141, 27534, 20899, 27935, 214))) GROUP BY fp.id_feature_value	1.630 ms	87616	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, pa.id_product_attribute, 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_1 ON (p.id_product = fp_1.id_product) LEFT JOIN mb_feature_product fp_2 ON (p.id_product = fp_2.id_product) LEFT JOIN mb_feature_product fp_3 ON (p.id_product = fp_3.id_product) WHERE ((pac.id_attribute=14)) AND ((fp_1.id_feature_value=13080)) AND ((fp_2.id_feature_value IN (12992, 12993, 23697, 27024, 24312))) AND ((fp_3.id_feature_value IN (27111, 21056, 27688, 27032, 27042, 14362, 27056, 27087, 27093, 11784, 27141, 27534, 20899, 27935, 214))) 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_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mb_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) LEFT JOIN mb_feature_product fp_2 ON (p.id_product = fp_2.id_product) LEFT JOIN mb_feature_product fp_3 ON (p.id_product = fp_3.id_product) LEFT JOIN mb_feature_product fp_4 ON (p.id_product = fp_4.id_product) WHERE ((fp.id_feature=27)) AND ((pac_1.id_attribute=14)) AND ((fp_2.id_feature_value=13080)) AND ((fp_3.id_feature_value IN (12992, 12993, 23697, 27024, 24312))) AND ((fp_4.id_feature_value IN (27111, 21056, 27688, 27032, 27042, 14362, 27056, 27087, 27093, 11784, 27141, 27534, 20899, 27935, 214))) GROUP BY fp.id_feature_value	1.599 ms	700928	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)
107	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, pa.id_product_attribute, 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_1 ON (p.id_product = fp_1.id_product) LEFT JOIN mb_feature_product fp_2 ON (p.id_product = fp_2.id_product) LEFT JOIN mb_feature_product fp_3 ON (p.id_product = fp_3.id_product) WHERE ((pac.id_attribute=14)) AND ((fp_1.id_feature_value=13080)) AND ((fp_2.id_feature_value IN (12992, 12993, 23697, 27024, 24312))) AND ((fp_3.id_feature_value IN (27111, 21056, 27688, 27032, 27042, 14362, 27056, 27087, 27093, 11784, 27141, 27534, 20899, 27935, 214))) 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_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mb_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) LEFT JOIN mb_feature_product fp_2 ON (p.id_product = fp_2.id_product) LEFT JOIN mb_feature_product fp_3 ON (p.id_product = fp_3.id_product) LEFT JOIN mb_feature_product fp_4 ON (p.id_product = fp_4.id_product) WHERE ((fp.id_feature=16)) AND ((pac_1.id_attribute=14)) AND ((fp_2.id_feature_value=13080)) AND ((fp_3.id_feature_value IN (12992, 12993, 23697, 27024, 24312))) AND ((fp_4.id_feature_value IN (27111, 21056, 27688, 27032, 27042, 14362, 27056, 27087, 27093, 11784, 27141, 27534, 20899, 27935, 214))) GROUP BY fp.id_feature_value	1.592 ms	700928	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)
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, pa.id_product_attribute, 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_1 ON (p.id_product = fp_1.id_product) LEFT JOIN mb_feature_product fp_2 ON (p.id_product = fp_2.id_product) LEFT JOIN mb_feature_product fp_3 ON (p.id_product = fp_3.id_product) WHERE ((pac.id_attribute=14)) AND ((fp_1.id_feature_value=13080)) AND ((fp_2.id_feature_value IN (12992, 12993, 23697, 27024, 24312))) AND ((fp_3.id_feature_value IN (27111, 21056, 27688, 27032, 27042, 14362, 27056, 27087, 27093, 11784, 27141, 27534, 20899, 27935, 214))) 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_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mb_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) LEFT JOIN mb_feature_product fp_2 ON (p.id_product = fp_2.id_product) LEFT JOIN mb_feature_product fp_3 ON (p.id_product = fp_3.id_product) LEFT JOIN mb_feature_product fp_4 ON (p.id_product = fp_4.id_product) WHERE ((fp.id_feature=28)) AND ((pac_1.id_attribute=14)) AND ((fp_2.id_feature_value=13080)) AND ((fp_3.id_feature_value IN (12992, 12993, 23697, 27024, 24312))) AND ((fp_4.id_feature_value IN (27111, 21056, 27688, 27032, 27042, 14362, 27056, 27087, 27093, 11784, 27141, 27534, 20899, 27935, 214))) GROUP BY fp.id_feature_value	1.522 ms	700928	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)
80	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, pa.id_product_attribute, 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_1 ON (p.id_product = fp_1.id_product) LEFT JOIN mb_feature_product fp_2 ON (p.id_product = fp_2.id_product) LEFT JOIN mb_feature_product fp_3 ON (p.id_product = fp_3.id_product) WHERE ((pac.id_attribute=14)) AND ((fp_1.id_feature_value=13080)) AND ((fp_2.id_feature_value IN (12992, 12993, 23697, 27024, 24312))) AND ((fp_3.id_feature_value IN (27111, 21056, 27688, 27032, 27042, 14362, 27056, 27087, 27093, 11784, 27141, 27534, 20899, 27935, 214))) 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) 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) LEFT JOIN mb_feature_product fp_3 ON (p.id_product = fp_3.id_product) WHERE ((pac.id_attribute=14)) AND ((fp_1.id_feature_value=13080)) AND ((fp_2.id_feature_value IN (12992, 12993, 23697, 27024, 24312))) AND ((fp_3.id_feature_value IN (27111, 21056, 27688, 27032, 27042, 14362, 27056, 27087, 27093, 11784, 27141, 27534, 20899, 27935, 214))) AND p.date_add>'2022-11-02 00:00:00'	1.510 ms	4736		/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)
87	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, pa.id_product_attribute, 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_1 ON (p.id_product = fp_1.id_product) LEFT JOIN mb_feature_product fp_2 ON (p.id_product = fp_2.id_product) LEFT JOIN mb_feature_product fp_3 ON (p.id_product = fp_3.id_product) WHERE ((pac.id_attribute=14)) AND ((fp_1.id_feature_value=13080)) AND ((fp_2.id_feature_value IN (12992, 12993, 23697, 27024, 24312))) AND ((fp_3.id_feature_value IN (27111, 21056, 27688, 27032, 27042, 14362, 27056, 27087, 27093, 11784, 27141, 27534, 20899, 27935, 214))) 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_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) LEFT JOIN mb_feature_product fp_2 ON (p.id_product = fp_2.id_product) LEFT JOIN mb_feature_product fp_3 ON (p.id_product = fp_3.id_product) LEFT JOIN mb_feature_product fp_4 ON (p.id_product = fp_4.id_product) WHERE ((a.id_attribute_group=4)) AND ((pac_1.id_attribute=14)) AND ((fp_2.id_feature_value=13080)) AND ((fp_3.id_feature_value IN (12992, 12993, 23697, 27024, 24312))) AND ((fp_4.id_feature_value IN (27111, 21056, 27688, 27032, 27042, 14362, 27056, 27087, 27093, 11784, 27141, 27534, 20899, 27935, 214))) GROUP BY pac.id_attribute	1.482 ms	7680	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)
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, pa.id_product_attribute, 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_1 ON (p.id_product = fp_1.id_product) LEFT JOIN mb_feature_product fp_2 ON (p.id_product = fp_2.id_product) LEFT JOIN mb_feature_product fp_3 ON (p.id_product = fp_3.id_product) WHERE ((pac.id_attribute=14)) AND ((fp_1.id_feature_value=13080)) AND ((fp_2.id_feature_value IN (12992, 12993, 23697, 27024, 24312))) AND ((fp_3.id_feature_value IN (27111, 21056, 27688, 27032, 27042, 14362, 27056, 27087, 27093, 11784, 27141, 27534, 20899, 27935, 214))) 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_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mb_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) LEFT JOIN mb_feature_product fp_2 ON (p.id_product = fp_2.id_product) LEFT JOIN mb_feature_product fp_3 ON (p.id_product = fp_3.id_product) LEFT JOIN mb_feature_product fp_4 ON (p.id_product = fp_4.id_product) WHERE ((fp.id_feature=19)) AND ((pac_1.id_attribute=14)) AND ((fp_2.id_feature_value=13080)) AND ((fp_3.id_feature_value IN (12992, 12993, 23697, 27024, 24312))) AND ((fp_4.id_feature_value IN (27111, 21056, 27688, 27032, 27042, 14362, 27056, 27087, 27093, 11784, 27141, 27534, 20899, 27935, 214))) GROUP BY fp.id_feature_value	1.469 ms	700928	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)
110	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, pa.id_product_attribute, 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_1 ON (p.id_product = fp_1.id_product) LEFT JOIN mb_feature_product fp_2 ON (p.id_product = fp_2.id_product) LEFT JOIN mb_feature_product fp_3 ON (p.id_product = fp_3.id_product) WHERE ((pac.id_attribute=14)) AND ((fp_1.id_feature_value=13080)) AND ((fp_2.id_feature_value IN (12992, 12993, 23697, 27024, 24312))) AND ((fp_3.id_feature_value IN (27111, 21056, 27688, 27032, 27042, 14362, 27056, 27087, 27093, 11784, 27141, 27534, 20899, 27935, 214))) 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_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mb_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) LEFT JOIN mb_feature_product fp_2 ON (p.id_product = fp_2.id_product) LEFT JOIN mb_feature_product fp_3 ON (p.id_product = fp_3.id_product) LEFT JOIN mb_feature_product fp_4 ON (p.id_product = fp_4.id_product) WHERE ((fp.id_feature=18)) AND ((pac_1.id_attribute=14)) AND ((fp_2.id_feature_value=13080)) AND ((fp_3.id_feature_value IN (12992, 12993, 23697, 27024, 24312))) AND ((fp_4.id_feature_value IN (27111, 21056, 27688, 27032, 27042, 14362, 27056, 27087, 27093, 11784, 27141, 27534, 20899, 27935, 214))) GROUP BY fp.id_feature_value	1.460 ms	700928	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, pa.id_product_attribute, 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_1 ON (p.id_product = fp_1.id_product) LEFT JOIN mb_feature_product fp_2 ON (p.id_product = fp_2.id_product) LEFT JOIN mb_feature_product fp_3 ON (p.id_product = fp_3.id_product) WHERE ((pac.id_attribute=14)) AND ((fp_1.id_feature_value=13080)) AND ((fp_2.id_feature_value IN (12992, 12993, 23697, 27024, 24312))) AND ((fp_3.id_feature_value IN (27111, 21056, 27688, 27032, 27042, 14362, 27056, 27087, 27093, 11784, 27141, 27534, 20899, 27935, 214))) 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_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mb_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) LEFT JOIN mb_feature_product fp_2 ON (p.id_product = fp_2.id_product) LEFT JOIN mb_feature_product fp_3 ON (p.id_product = fp_3.id_product) LEFT JOIN mb_feature_product fp_4 ON (p.id_product = fp_4.id_product) WHERE ((fp.id_feature=12)) AND ((pac_1.id_attribute=14)) AND ((fp_2.id_feature_value=13080)) AND ((fp_3.id_feature_value IN (12992, 12993, 23697, 27024, 24312))) AND ((fp_4.id_feature_value IN (27111, 21056, 27688, 27032, 27042, 14362, 27056, 27087, 27093, 11784, 27141, 27534, 20899, 27935, 214))) GROUP BY fp.id_feature_value	1.452 ms	700928	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 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, pa.id_product_attribute, 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_1 ON (p.id_product = fp_1.id_product) LEFT JOIN mb_feature_product fp_2 ON (p.id_product = fp_2.id_product) LEFT JOIN mb_feature_product fp_3 ON (p.id_product = fp_3.id_product) WHERE ((pac.id_attribute=14)) AND ((fp_1.id_feature_value=13080)) AND ((fp_2.id_feature_value IN (12992, 12993, 23697, 27024, 24312))) AND ((fp_3.id_feature_value IN (27111, 21056, 27688, 27032, 27042, 14362, 27056, 27087, 27093, 11784, 27141, 27534, 20899, 27935, 214))) 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:52:35' >= sp.from) AND (sp.to = '0000-00-00 00:00:00' OR '2025-07-28 23:52:35' <= sp.to) ) LEFT JOIN mb_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mb_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) LEFT JOIN mb_feature_product fp_2 ON (p.id_product = fp_2.id_product) LEFT JOIN mb_feature_product fp_3 ON (p.id_product = fp_3.id_product) LEFT JOIN mb_feature_product fp_4 ON (p.id_product = fp_4.id_product) WHERE ((sp.reduction>0)) AND ((pac_1.id_attribute=14)) AND ((fp_2.id_feature_value=13080)) AND ((fp_3.id_feature_value IN (12992, 12993, 23697, 27024, 24312))) AND ((fp_4.id_feature_value IN (27111, 21056, 27688, 27032, 27042, 14362, 27056, 27087, 27093, 11784, 27141, 27534, 20899, 27935, 214)))	1.451 ms	4736		/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)
99	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, pa.id_product_attribute, 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_1 ON (p.id_product = fp_1.id_product) LEFT JOIN mb_feature_product fp_2 ON (p.id_product = fp_2.id_product) LEFT JOIN mb_feature_product fp_3 ON (p.id_product = fp_3.id_product) WHERE ((pac.id_attribute=14)) AND ((fp_1.id_feature_value=13080)) AND ((fp_2.id_feature_value IN (12992, 12993, 23697, 27024, 24312))) AND ((fp_3.id_feature_value IN (27111, 21056, 27688, 27032, 27042, 14362, 27056, 27087, 27093, 11784, 27141, 27534, 20899, 27935, 214))) 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_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mb_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) LEFT JOIN mb_feature_product fp_2 ON (p.id_product = fp_2.id_product) LEFT JOIN mb_feature_product fp_3 ON (p.id_product = fp_3.id_product) LEFT JOIN mb_feature_product fp_4 ON (p.id_product = fp_4.id_product) WHERE ((fp.id_feature=8)) AND ((pac_1.id_attribute=14)) AND ((fp_2.id_feature_value=13080)) AND ((fp_3.id_feature_value IN (12992, 12993, 23697, 27024, 24312))) AND ((fp_4.id_feature_value IN (27111, 21056, 27688, 27032, 27042, 14362, 27056, 27087, 27093, 11784, 27141, 27534, 20899, 27935, 214))) GROUP BY fp.id_feature_value	1.446 ms	700928	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)
83	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, pa.id_product_attribute, 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_1 ON (p.id_product = fp_1.id_product) LEFT JOIN mb_feature_product fp_2 ON (p.id_product = fp_2.id_product) LEFT JOIN mb_feature_product fp_3 ON (p.id_product = fp_3.id_product) WHERE ((pac.id_attribute=14)) AND ((fp_1.id_feature_value=13080)) AND ((fp_2.id_feature_value IN (12992, 12993, 23697, 27024, 24312))) AND ((fp_3.id_feature_value IN (27111, 21056, 27688, 27032, 27042, 14362, 27056, 27087, 27093, 11784, 27141, 27534, 20899, 27935, 214))) 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) 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) LEFT JOIN mb_feature_product fp_3 ON (p.id_product = fp_3.id_product) WHERE ((pac.id_attribute=14)) AND ((fp_1.id_feature_value=13080)) AND ((fp_2.id_feature_value IN (12992, 12993, 23697, 27024, 24312))) AND ((fp_3.id_feature_value IN (27111, 21056, 27688, 27032, 27042, 14362, 27056, 27087, 27093, 11784, 27141, 27534, 20899, 27935, 214))) GROUP BY p.id_manufacturer	1.434 ms	4736	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)
116	SELECT SQL_NO_CACHE fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, pa.id_product_attribute, 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_1 ON (p.id_product = fp_1.id_product) LEFT JOIN mb_feature_product fp_2 ON (p.id_product = fp_2.id_product) LEFT JOIN mb_feature_product fp_3 ON (p.id_product = fp_3.id_product) WHERE ((pac.id_attribute=14)) AND ((fp_1.id_feature_value=13080)) AND ((fp_2.id_feature_value IN (12992, 12993, 23697, 27024, 24312))) AND ((fp_3.id_feature_value IN (27111, 21056, 27688, 27032, 27042, 14362, 27056, 27087, 27093, 11784, 27141, 27534, 20899, 27935, 214))) 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_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mb_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) LEFT JOIN mb_feature_product fp_2 ON (p.id_product = fp_2.id_product) LEFT JOIN mb_feature_product fp_3 ON (p.id_product = fp_3.id_product) LEFT JOIN mb_feature_product fp_4 ON (p.id_product = fp_4.id_product) WHERE ((fp.id_feature=24)) AND ((pac_1.id_attribute=14)) AND ((fp_2.id_feature_value=13080)) AND ((fp_3.id_feature_value IN (12992, 12993, 23697, 27024, 24312))) AND ((fp_4.id_feature_value IN (27111, 21056, 27688, 27032, 27042, 14362, 27056, 27087, 27093, 11784, 27141, 27534, 20899, 27935, 214))) GROUP BY fp.id_feature_value	1.428 ms	700928	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, pa.id_product_attribute, 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_1 ON (p.id_product = fp_1.id_product) LEFT JOIN mb_feature_product fp_2 ON (p.id_product = fp_2.id_product) LEFT JOIN mb_feature_product fp_3 ON (p.id_product = fp_3.id_product) WHERE ((pac.id_attribute=14)) AND ((fp_1.id_feature_value=13080)) AND ((fp_2.id_feature_value IN (12992, 12993, 23697, 27024, 24312))) AND ((fp_3.id_feature_value IN (27111, 21056, 27688, 27032, 27042, 14362, 27056, 27087, 27093, 11784, 27141, 27534, 20899, 27935, 214))) 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_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mb_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) LEFT JOIN mb_feature_product fp_2 ON (p.id_product = fp_2.id_product) LEFT JOIN mb_feature_product fp_3 ON (p.id_product = fp_3.id_product) LEFT JOIN mb_feature_product fp_4 ON (p.id_product = fp_4.id_product) WHERE ((fp.id_feature=29)) AND ((pac_1.id_attribute=14)) AND ((fp_2.id_feature_value=13080)) AND ((fp_3.id_feature_value IN (12992, 12993, 23697, 27024, 24312))) AND ((fp_4.id_feature_value IN (27111, 21056, 27688, 27032, 27042, 14362, 27056, 27087, 27093, 11784, 27141, 27534, 20899, 27935, 214))) GROUP BY fp.id_feature_value	1.426 ms	700928	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, pa.id_product_attribute, 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_1 ON (p.id_product = fp_1.id_product) LEFT JOIN mb_feature_product fp_2 ON (p.id_product = fp_2.id_product) LEFT JOIN mb_feature_product fp_3 ON (p.id_product = fp_3.id_product) WHERE ((pac.id_attribute=14)) AND ((fp_1.id_feature_value=13080)) AND ((fp_2.id_feature_value IN (12992, 12993, 23697, 27024, 24312))) AND ((fp_3.id_feature_value IN (27111, 21056, 27688, 27032, 27042, 14362, 27056, 27087, 27093, 11784, 27141, 27534, 20899, 27935, 214))) 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_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mb_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) LEFT JOIN mb_feature_product fp_2 ON (p.id_product = fp_2.id_product) LEFT JOIN mb_feature_product fp_3 ON (p.id_product = fp_3.id_product) LEFT JOIN mb_feature_product fp_4 ON (p.id_product = fp_4.id_product) WHERE ((fp.id_feature=30)) AND ((pac_1.id_attribute=14)) AND ((fp_2.id_feature_value=13080)) AND ((fp_3.id_feature_value IN (12992, 12993, 23697, 27024, 24312))) AND ((fp_4.id_feature_value IN (27111, 21056, 27688, 27032, 27042, 14362, 27056, 27087, 27093, 11784, 27141, 27534, 20899, 27935, 214))) GROUP BY fp.id_feature_value	1.426 ms	700928	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)
82	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	1.408 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)

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
42 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, pa.id_product_attribute, 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_XX ON (p.id_product = fp_XX.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 ((pac.id_attribute=XX)) AND ((fp_XX.id_feature_value=XX)) AND ((fp_XX.id_feature_value IN (XX, XX, 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))) 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_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mb_product_attribute_combination pac_XX ON (pa.id_product_attribute = pac_XX.id_product_attribute) 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) LEFT JOIN mb_feature_product fp_XX ON (p.id_product = fp_XX.id_product) WHERE ((fp.id_feature=XX)) AND ((pac_XX.id_attribute=XX)) AND ((fp_XX.id_feature_value=XX)) AND ((fp_XX.id_feature_value IN (XX, XX, 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))) GROUP BY fp.id_feature_value
41 queries	SELECT `id_image_type` FROM `mb_image_type` WHERE `name` = 'home'
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
26 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
21 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
16 queries	SELECT `id_module` FROM `mb_module_shop` WHERE `id_module` = XX AND `id_shop` = XX LIMIT XX
16 queries	SELECT XX FROM `mb_specific_price` WHERE id_product = XX LIMIT XX
15 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
15 queries	SELECT name FROM mb_category_lang WHERE id_shop = XX AND id_lang = XX AND id_category = XX LIMIT XX
15 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
15 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)
15 queries	SELECT `id_tax_rules_group` FROM `mb_product_shop` WHERE `id_product` = XX AND id_shop=XX LIMIT XX
15 queries	SELECT `reduction` FROM `mb_product_group_reduction_cache` WHERE `id_product` = XX AND `id_group` = XX LIMIT XX
15 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`
15 queries	SELECT `id_product_attribute` FROM `mb_product_attribute` WHERE `id_product` = XX
12 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
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 (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
12 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
11 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
10 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
9 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 * 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 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
6 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
6 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
6 queries	SELECT * FROM `mb_product_attribute_lang` WHERE `id_product_attribute` = 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
5 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,XX,XX) GROUP BY c.id_category ORDER BY cl.name ASC,c.id_category ASC
5 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,XX) GROUP BY c.id_category ORDER BY cl.name ASC,c.id_category ASC
4 queries	SELECT pai.`id_image`, pai.`id_product_attribute`, il.`legend` FROM `mb_product_attribute_image` pai LEFT JOIN `mb_image_lang` il ON (il.`id_image` = pai.`id_image`) LEFT JOIN `mb_image` i ON (i.`id_image` = pai.`id_image`) WHERE pai.`id_product_attribute` IN (XX, XX, XX) AND il.`id_lang` = XX ORDER by i.`position`
4 queries	SELECT * FROM `mb_ets_mm_column` WHERE XX AND id_menu=XX ORDER BY sort_order asc
4 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,XX,XX,XX,XX) GROUP BY c.id_category ORDER BY cl.name ASC,c.id_category ASC
4 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,XX,XX,XX,XX,XX) GROUP BY c.id_category ORDER BY cl.name ASC,c.id_category ASC

#	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

SMARTPHONE REDMI A3 4G 128G

SMARTPHONE REDMI A3 4G 128G

SMARTPHONE REDMI A3 4G 128G

SMARTPHONE REDMI A3 4G 128G

SMARTPHONE REDMI A3 3G 64G

SMARTPHONE REDMI A3 3G 64G

SMARTPHONE REDMI A3 3G 64G

SMARTPHONE REDMI A3 3G 64G

SMARTPHONE OPPO RENO 11F 5G 8GO 256GO

SMARTPHONE OPPO RENO 11F 5G 8GO 256GO

SMARTPHONE OPPO RENO 11F 5G 8GO 256GO

SMARTPHONE OPPO RENO 11F 5G 8GO 256GO

Stopwatch SQL - 994 queries

Doubles

Tables stress

ObjectModel instances

Included Files