Smartphone & Mobile

SMARTPHONE VIVO Y1S 2G 32G BLEU

399,000 TND

SMARTPHONE VIVO Y1S 2G 32G BLEU

399,000 TND

SMARTPHONE VIVO Y1S 2G 32G BLEU

Smartphones

Ecran : 6,22" Full-incell (720 × 1520 Pixels) Processeur : MT6765 Octa-core Mémoire RAM : 2Go Stockage : 32Go Appareil Photo Arrière : 13 MP Appareil Photo Avant : 5 MP Batterie : 4030 mAh, Li-polymère Couleur...

399,000 TND

Aperçu rapide

SMARTPHONE VIVO Y1S 2G 32G BLEU

Smartphones

399,000 TND

Aperçu rapide

Nouveau

SMARTPHONE SMART M30 2G 32G 4G

309,000 TND

Nouveau

SMARTPHONE SMART M30 2G 32G 4G

309,000 TND

Nouveau

SMARTPHONE SMART M30 2G 32G 4G

Smartphones

Ecran: 6.3 " HD + IPS Water Drop Système d’exploitation: Android 11 Processeur: Octa-core Mémoire: 2 Go Stockage: 32Go Appareil photo arrière: 13 MP + VGA Avant: 5 MP Batterie: Li-Po 4000 mAh Charge avec 4G et Bluetooth Capteur d'empreinte digital...

309,000 TND

Aperçu rapide

Nouveau

SMARTPHONE SMART M30 2G 32G 4G

Smartphones

309,000 TND

Aperçu rapide

Nouveau

SMARTPHONE NOKIA C12 2GO 64GO

289,000 TND

Nouveau

SMARTPHONE NOKIA C12 2GO 64GO

289,000 TND

Nouveau

SMARTPHONE NOKIA C12 2GO 64GO

Smartphones

Écran 6.3" LCD IPS (720x1600 Pixels) Processeur: Unisoc SC9863A1 (28nm) Octa-core (4x1,6 GHz Cortex-A55 et 4x1,2 GHz Cortex-A55) Systéme d'exploitation: Android 12 RAM: 2 Go Stockage: 64 Go Appareil Photo Arrière: 8 mégapixels , Flash LED, HDR...

289,000 TND

Aperçu rapide

Nouveau

SMARTPHONE NOKIA C12 2GO 64GO

Smartphones

289,000 TND

Aperçu rapide

Load Time	611.504 ms
Querying Time	477 ms
Queries	972
Memory Peak Usage	31.7 Mb
Included Files	772 files - 9.43 Mb
PrestaShop Cache	- Mb
Global vars	0.12 Mb
- global $_MODULES	86k
- global $_MODULE	11k
- global $_SERVER	6k
- global $config	5k
- global $context	3k
- global $exportPhpConfigFile	3k
- global $_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.003 ms	0.003 ms	1.92 Mb	2.0 Mb
__construct	0.371 ms	0.374 ms	0.07 Mb	2.5 Mb
init	7.407 ms	7.781 ms	0.51 Mb	2.9 Mb
checkAccess	0.001 ms	7.782 ms	- Mb	2.9 Mb
setMedia	2.655 ms	10.437 ms	0.23 Mb	2.9 Mb
postProcess	0.001 ms	10.438 ms	- Mb	2.9 Mb
initHeader	0.001 ms	10.439 ms	- Mb	2.9 Mb
initContent	165.200 ms	175.639 ms	4.22 Mb	7.2 Mb
initFooter	0.002 ms	175.641 ms	- Mb	7.2 Mb
display	435.863 ms	611.504 ms	24.26 Mb	31.7 Mb

Hook	Time	Memory Usage
DisplayLeftColumn	225.608 ms	5.29 Mb
=> tvcmsnewproducts	82.003 ms	1.90 Mb
=> tvcmsfeaturedproducts	122.290 ms	1.76 Mb
=> tvcmsbestsellerproducts	21.315 ms	1.63 Mb
DisplayNavFullWidth	171.070 ms	15.38 Mb
=> ets_megamenu	171.070 ms	15.38 Mb
DisplayReviewProductList	6.798 ms	0.96 Mb
=> tvcmsproductcomments	0.729 ms	0.12 Mb
=> tvcmsproductcomments	0.515 ms	0.07 Mb
=> tvcmsproductcomments	0.522 ms	0.07 Mb
=> tvcmsproductcomments	0.529 ms	0.07 Mb
=> tvcmsproductcomments	0.736 ms	0.11 Mb
=> tvcmsproductcomments	0.502 ms	0.07 Mb
=> tvcmsproductcomments	0.491 ms	0.07 Mb
=> tvcmsproductcomments	0.530 ms	0.07 Mb
=> tvcmsproductcomments	0.679 ms	0.10 Mb
=> tvcmsproductcomments	0.528 ms	0.07 Mb
=> tvcmsproductcomments	0.540 ms	0.07 Mb
=> tvcmsproductcomments	0.497 ms	0.07 Mb
DisplayHeader	5.497 ms	1.22 Mb
=> ps_shoppingcart	0.029 ms	- Mb
=> ps_searchbar	0.110 ms	- Mb
=> ps_googleanalytics	0.012 ms	- Mb
=> tvcmsbestsellerproducts	0.046 ms	- Mb
=> tvcmscategoryslider	0.050 ms	- Mb
=> tvcmscustomsetting	0.298 ms	0.01 Mb
=> tvcmsfeaturedproducts	0.034 ms	- Mb
=> tvcmsmultibanner1	0.046 ms	- Mb
=> tvcmsnewproducts	0.031 ms	- Mb
=> tvcmsproductcomments	0.140 ms	- Mb
=> tvcmsproductcompare	0.046 ms	- Mb
=> tvcmssearch	0.100 ms	- Mb
=> tvcmsslider	0.068 ms	- Mb
=> tvcmsthemeoptions	0.132 ms	- Mb
=> tvcmswishlist	0.067 ms	- Mb
=> ets_megamenu	4.288 ms	1.18 Mb
DisplayNavSearchBlock	4.032 ms	0.51 Mb
=> tvcmssearch	4.032 ms	0.51 Mb
DisplayFooterCategory	2.274 ms	0.24 Mb
=> tvcmsfootercategory	2.274 ms	0.24 Mb
displayLeftColumn	1.598 ms	0.06 Mb
=> ps_categorytree (widget)	1.598 ms	0.06 Mb
DisplayBeforeBodyClosingTag	1.482 ms	0.05 Mb
=> statsdata	1.482 ms	0.05 Mb
DisplayProductCompareProductList	1.266 ms	0.02 Mb
=> tvcmsproductcompare	0.151 ms	0.01 Mb
=> tvcmsproductcompare	0.093 ms	- Mb
=> tvcmsproductcompare	0.093 ms	- Mb
=> tvcmsproductcompare	0.089 ms	- Mb
=> tvcmsproductcompare	0.109 ms	- Mb
=> tvcmsproductcompare	0.124 ms	- Mb
=> tvcmsproductcompare	0.127 ms	- Mb
=> tvcmsproductcompare	0.093 ms	- Mb
=> tvcmsproductcompare	0.084 ms	- Mb
=> tvcmsproductcompare	0.119 ms	- Mb
=> tvcmsproductcompare	0.099 ms	- Mb
=> tvcmsproductcompare	0.085 ms	- Mb
DisplayWishlistBtnProductList	1.168 ms	0.02 Mb
=> tvcmswishlist	0.124 ms	0.01 Mb
=> tvcmswishlist	0.084 ms	- Mb
=> tvcmswishlist	0.086 ms	- Mb
=> tvcmswishlist	0.082 ms	- Mb
=> tvcmswishlist	0.115 ms	- Mb
=> tvcmswishlist	0.146 ms	- Mb
=> tvcmswishlist	0.085 ms	- Mb
=> tvcmswishlist	0.081 ms	- Mb
=> tvcmswishlist	0.076 ms	- Mb
=> tvcmswishlist	0.124 ms	- Mb
=> tvcmswishlist	0.085 ms	- Mb
=> tvcmswishlist	0.080 ms	- Mb
Header	1.101 ms	0.05 Mb
=> tvcmsinfinitescroll	0.996 ms	0.04 Mb
=> tvcmsofferbanner	0.055 ms	- Mb
=> tvcmsleftsideofferbanner	0.001 ms	- Mb
=> tvcmstwoofferbanner	0.049 ms	- Mb
DisplayCustomsocialblock	0.770 ms	0.09 Mb
=> tvcmscustomsetting	0.770 ms	0.09 Mb
displayNav1	0.769 ms	0.08 Mb
=> ps_contactinfo (widget)	0.769 ms	0.08 Mb
displayNavCurrencyBlock	0.662 ms	0.08 Mb
=> ps_currencyselector (widget)	0.662 ms	0.08 Mb
displayFooterPart1	0.636 ms	0.06 Mb
=> ps_linklist (widget)	0.636 ms	0.06 Mb
displayMyaccountcblock	0.543 ms	0.06 Mb
=> ps_customeraccountlinks (widget)	0.543 ms	0.06 Mb
displaySocialMediaBlock	0.509 ms	0.07 Mb
=> ps_socialfollow (widget)	0.509 ms	0.07 Mb
displayNewslettersubscription	0.498 ms	0.06 Mb
=> ps_emailsubscription (widget)	0.498 ms	0.06 Mb
DisplayNavWishlistBlock	0.470 ms	0.03 Mb
=> tvcmswishlist	0.470 ms	0.03 Mb
displayContactCinfo	0.426 ms	0.03 Mb
=> ps_contactinfo (widget)	0.426 ms	0.03 Mb
displayNavLanguageBlock	0.348 ms	0.05 Mb
=> ps_languageselector (widget)	0.348 ms	0.05 Mb
ActionFrontControllerSetMedia	0.193 ms	0.01 Mb
=> ps_emailsubscription	0.113 ms	- Mb
=> ps_socialfollow	0.036 ms	- Mb
=> ps_emailalerts	0.044 ms	- Mb
displayNavShoppingCartBlock	0.169 ms	- Mb
=> ps_shoppingcart (widget)	0.169 ms	- Mb
DisplayFacetedSearchBlock	0.151 ms	0.02 Mb
=> ps_facetedsearch	0.151 ms	0.02 Mb
displayNavCustomerSignInBlock	0.150 ms	- Mb
=> ps_customersignin (widget)	0.150 ms	- Mb
ProductSearchProvider	0.139 ms	- Mb
=> ps_facetedsearch	0.139 ms	- Mb
DisplayNavProductCompareBlock	0.130 ms	0.01 Mb
=> tvcmsproductcompare	0.130 ms	0.01 Mb
DisplayCopyRightText	0.095 ms	0.01 Mb
=> tvcmscustomsetting	0.095 ms	0.01 Mb
DisplayCustomJs	0.019 ms	- Mb
=> tvcmscustomcssjs	0.019 ms	- Mb
DisplayTopOfferText	0.011 ms	- Mb
=> tvcmscustomsetting	0.007 ms	- Mb
=> tvcmscustomsetting	0.004 ms	- Mb
DisplayCustomCss	0.006 ms	- Mb
=> tvcmscustomcssjs	0.006 ms	- Mb
DisplayMegamenu	0.005 ms	- Mb
=> ets_megamenu	0.005 ms	- Mb
32 hook(s)	428.594 ms	24.44 Mb

Module	Time	Memory Usage
ps_emailsubscription	1.301 ms	0.14 Mb
__construct	0.686 ms	0.08 Mb
hookActionFrontControllerSetMedia	0.115 ms	0.01 Mb
displayNewslettersubscription	0.500 ms	0.06 Mb
ps_socialfollow	0.604 ms	0.07 Mb
__construct	0.055 ms	0.01 Mb
hookActionFrontControllerSetMedia	0.038 ms	- Mb
displaySocialMediaBlock	0.511 ms	0.07 Mb
ps_emailalerts	0.109 ms	0.01 Mb
__construct	0.064 ms	0.01 Mb
hookActionFrontControllerSetMedia	0.045 ms	- Mb
ps_shoppingcart	0.255 ms	0.01 Mb
__construct	0.053 ms	0.01 Mb
hookDisplayHeader	0.031 ms	- Mb
displayNavShoppingCartBlock	0.171 ms	0.01 Mb
ps_searchbar	0.155 ms	0.01 Mb
__construct	0.044 ms	0.01 Mb
hookDisplayHeader	0.111 ms	- Mb
ps_googleanalytics	0.062 ms	0.01 Mb
__construct	0.049 ms	0.01 Mb
hookDisplayHeader	0.013 ms	- Mb
tvcmsbestsellerproducts	21.495 ms	1.66 Mb
__construct	0.128 ms	0.03 Mb
hookDisplayHeader	0.048 ms	- Mb
hookDisplayLeftColumn	21.319 ms	1.63 Mb
tvcmscategoryslider	0.127 ms	0.01 Mb
__construct	0.076 ms	0.01 Mb
hookDisplayHeader	0.051 ms	- Mb
tvcmscustomsetting	1.265 ms	0.13 Mb
__construct	0.081 ms	0.01 Mb
hookDisplayHeader	0.299 ms	0.01 Mb
hookDisplayTopOfferText	0.010 ms	- Mb
hookDisplayTopOfferText	0.006 ms	- Mb
hookDisplayCustomsocialblock	0.772 ms	0.10 Mb
hookDisplayCopyRightText	0.097 ms	0.01 Mb
tvcmsfeaturedproducts	122.395 ms	1.77 Mb
__construct	0.066 ms	0.01 Mb
hookDisplayHeader	0.035 ms	- Mb
hookDisplayLeftColumn	122.294 ms	1.76 Mb
tvcmsmultibanner1	0.111 ms	0.01 Mb
__construct	0.064 ms	0.01 Mb
hookDisplayHeader	0.047 ms	- Mb
tvcmsnewproducts	82.096 ms	1.91 Mb
__construct	0.058 ms	0.01 Mb
hookDisplayHeader	0.032 ms	- Mb
hookDisplayLeftColumn	82.006 ms	1.90 Mb
tvcmsproductcomments	7.039 ms	0.99 Mb
__construct	0.076 ms	0.02 Mb
hookDisplayHeader	0.141 ms	- Mb
hookDisplayReviewProductList	0.731 ms	0.12 Mb
hookDisplayReviewProductList	0.517 ms	0.07 Mb
hookDisplayReviewProductList	0.524 ms	0.07 Mb
hookDisplayReviewProductList	0.531 ms	0.07 Mb
hookDisplayReviewProductList	0.739 ms	0.11 Mb
hookDisplayReviewProductList	0.504 ms	0.07 Mb
hookDisplayReviewProductList	0.493 ms	0.07 Mb
hookDisplayReviewProductList	0.531 ms	0.07 Mb
hookDisplayReviewProductList	0.681 ms	0.11 Mb
hookDisplayReviewProductList	0.529 ms	0.07 Mb
hookDisplayReviewProductList	0.542 ms	0.07 Mb
hookDisplayReviewProductList	0.499 ms	0.07 Mb
tvcmsproductcompare	1.526 ms	0.03 Mb
__construct	0.061 ms	- Mb
hookDisplayHeader	0.047 ms	- Mb
hookDisplayNavProductCompareBlock	0.131 ms	0.01 Mb
hookDisplayProductCompareProductList	0.154 ms	0.01 Mb
hookDisplayProductCompareProductList	0.095 ms	- Mb
hookDisplayProductCompareProductList	0.094 ms	- Mb
hookDisplayProductCompareProductList	0.090 ms	- Mb
hookDisplayProductCompareProductList	0.111 ms	- Mb
hookDisplayProductCompareProductList	0.126 ms	- Mb
hookDisplayProductCompareProductList	0.128 ms	- Mb
hookDisplayProductCompareProductList	0.095 ms	- Mb
hookDisplayProductCompareProductList	0.086 ms	- Mb
hookDisplayProductCompareProductList	0.121 ms	- Mb
hookDisplayProductCompareProductList	0.101 ms	- Mb
hookDisplayProductCompareProductList	0.086 ms	- Mb
tvcmssearch	4.186 ms	0.52 Mb
__construct	0.051 ms	0.01 Mb
hookDisplayHeader	0.101 ms	- Mb
hookDisplayNavSearchBlock	4.034 ms	0.51 Mb
tvcmsslider	0.191 ms	0.01 Mb
__construct	0.122 ms	0.01 Mb
hookDisplayHeader	0.069 ms	- Mb
tvcmsthemeoptions	0.205 ms	0.01 Mb
__construct	0.072 ms	0.01 Mb
hookDisplayHeader	0.133 ms	0.01 Mb
tvcmswishlist	1.805 ms	0.08 Mb
__construct	0.077 ms	0.02 Mb
hookDisplayHeader	0.069 ms	- Mb
hookDisplayNavWishlistBlock	0.472 ms	0.04 Mb
hookDisplayWishlistBtnProductList	0.126 ms	0.01 Mb
hookDisplayWishlistBtnProductList	0.086 ms	- Mb
hookDisplayWishlistBtnProductList	0.088 ms	- Mb
hookDisplayWishlistBtnProductList	0.084 ms	- Mb
hookDisplayWishlistBtnProductList	0.116 ms	- Mb
hookDisplayWishlistBtnProductList	0.147 ms	- Mb
hookDisplayWishlistBtnProductList	0.086 ms	- Mb
hookDisplayWishlistBtnProductList	0.083 ms	- Mb
hookDisplayWishlistBtnProductList	0.077 ms	- Mb
hookDisplayWishlistBtnProductList	0.126 ms	- Mb
hookDisplayWishlistBtnProductList	0.086 ms	- Mb
hookDisplayWishlistBtnProductList	0.081 ms	- Mb
ets_megamenu	175.507 ms	16.61 Mb
__construct	0.136 ms	0.05 Mb
hookDisplayHeader	4.291 ms	1.19 Mb
hookDisplayMegamenu	0.006 ms	- Mb
hookDisplayNavFullWidth	171.074 ms	15.38 Mb
ps_customersignin	0.210 ms	0.01 Mb
__construct	0.058 ms	0.01 Mb
displayNavCustomerSignInBlock	0.152 ms	- Mb
tvcmsinfinitescroll	1.091 ms	0.09 Mb
__construct	0.093 ms	0.05 Mb
hookHeader	0.998 ms	0.04 Mb
tvcmsofferbanner	0.144 ms	- Mb
__construct	0.087 ms	- Mb
hookHeader	0.057 ms	- Mb
tvcmsleftsideofferbanner	0.078 ms	0.01 Mb
__construct	0.076 ms	0.01 Mb
hookHeader	0.002 ms	- Mb
tvcmstwoofferbanner	0.119 ms	0.01 Mb
__construct	0.069 ms	0.01 Mb
hookHeader	0.050 ms	- Mb
ps_facetedsearch	0.420 ms	0.04 Mb
__construct	0.126 ms	0.01 Mb
hookProductSearchProvider	0.140 ms	- Mb
hookDisplayFacetedSearchBlock	0.154 ms	0.03 Mb
tvcmscustomcssjs	0.146 ms	0.01 Mb
__construct	0.117 ms	0.01 Mb
hookDisplayCustomCss	0.008 ms	- Mb
hookDisplayCustomJs	0.021 ms	- Mb
ps_languageselector	0.420 ms	0.06 Mb
__construct	0.069 ms	0.01 Mb
displayNavLanguageBlock	0.351 ms	0.05 Mb
ps_currencyselector	0.738 ms	0.08 Mb
__construct	0.074 ms	0.01 Mb
displayNavCurrencyBlock	0.664 ms	0.08 Mb
ps_contactinfo	1.261 ms	0.12 Mb
__construct	0.062 ms	0.01 Mb
displayNav1	0.771 ms	0.09 Mb
displayContactCinfo	0.428 ms	0.03 Mb
ps_categorytree	1.669 ms	0.07 Mb
__construct	0.069 ms	0.01 Mb
displayLeftColumn	1.600 ms	0.06 Mb
tvcmsfootercategory	2.475 ms	0.24 Mb
__construct	0.199 ms	0.01 Mb
hookDisplayFooterCategory	2.276 ms	0.24 Mb
ps_linklist	0.739 ms	0.07 Mb
__construct	0.100 ms	0.01 Mb
displayFooterPart1	0.639 ms	0.06 Mb
ps_customeraccountlinks	0.606 ms	0.07 Mb
__construct	0.061 ms	0.01 Mb
displayMyaccountcblock	0.545 ms	0.06 Mb
statsdata	1.565 ms	0.05 Mb
__construct	0.080 ms	0.01 Mb
hookDisplayBeforeBodyClosingTag	1.485 ms	0.05 Mb
34 module(s)	432.115 ms	24.86 Mb

SMARTPHONE VIVO Y1S 2G 32G BLEU

SMARTPHONE VIVO Y1S 2G 32G BLEU

SMARTPHONE VIVO Y1S 2G 32G BLEU

SMARTPHONE VIVO Y1S 2G 32G BLEU

SMARTPHONE SMART M30 2G 32G 4G

SMARTPHONE SMART M30 2G 32G 4G

SMARTPHONE SMART M30 2G 32G 4G

SMARTPHONE SMART M30 2G 32G 4G

SMARTPHONE NOKIA C12 2GO 64GO

SMARTPHONE NOKIA C12 2GO 64GO

SMARTPHONE NOKIA C12 2GO 64GO

SMARTPHONE NOKIA C12 2GO 64GO

Stopwatch SQL - 972 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	39	/classes/Link.php:113 (__construct) [id: 6912] /classes/Link.php:113 (__construct) [id: 8284] /classes/Link.php:113 (__construct) [id: 8582] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 6912] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 8284] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 8582] /classes/Link.php:113 (__construct) [id: 6912] /classes/Link.php:113 (__construct) [id: 8284] /classes/Link.php:113 (__construct) [id: 8582] /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: 7440] /classes/Link.php:113 (__construct) [id: 7818] /classes/Link.php:113 (__construct) [id: 5853] /classes/Link.php:113 (__construct) [id: 9835] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 7440] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 7818] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 5853] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 9835] /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: 6912] /classes/Link.php:113 (__construct) [id: 6912] /classes/Link.php:113 (__construct) [id: 6912] /src/Adapter/Presenter/Product/ProductLazyArray.php:662 (__construct) [id: 8284] /classes/Link.php:113 (__construct) [id: 8284] /classes/Link.php:113 (__construct) [id: 8284]
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	4	/classes/Product.php:5893 (__construct) [id: 271] /classes/Product.php:5893 (__construct) [id: 520] /classes/Product.php:5893 (__construct) [id: 1034] /classes/Product.php:5893 (__construct) [id: 1037]
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
788	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	83.260 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)
716	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	58.710 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)
833	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	16.662 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)
130	SELECT SQL_NO_CACHE fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM mb_product p LEFT JOIN mb_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mb_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN mb_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN mb_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN mb_category_product cp ON (p.id_product = cp.id_product) INNER JOIN mb_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN mb_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN mb_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN mb_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN mb_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN mb_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((fp.id_feature_value=1639)) AND ((fp_1.id_feature_value IN (43, 3659, 46))) AND ((fp_2.id_feature_value IN (27208, 28133, 27167, 27170, 13583, 1110, 27102, 13593, 13297, 13935, 27710, 18514, 27107, 27118, 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_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 ((fp.id_feature=39)) AND ((fp_1.id_feature_value=1639)) AND ((fp_2.id_feature_value IN (43, 3659, 46))) AND ((fp_3.id_feature_value IN (27208, 28133, 27167, 27170, 13583, 1110, 27102, 13593, 13297, 13935, 27710, 18514, 27107, 27118, 214))) GROUP BY fp.id_feature_value	5.901 ms	512	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)
129	SELECT SQL_NO_CACHE fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM mb_product p LEFT JOIN mb_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mb_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN mb_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN mb_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN mb_category_product cp ON (p.id_product = cp.id_product) INNER JOIN mb_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN mb_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN mb_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN mb_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN mb_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN mb_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((fp.id_feature_value=1639)) AND ((fp_1.id_feature_value IN (43, 3659, 46))) AND ((fp_2.id_feature_value IN (27208, 28133, 27167, 27170, 13583, 1110, 27102, 13593, 13297, 13935, 27710, 18514, 27107, 27118, 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_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 ((fp.id_feature=38)) AND ((fp_1.id_feature_value=1639)) AND ((fp_2.id_feature_value IN (43, 3659, 46))) AND ((fp_3.id_feature_value IN (27208, 28133, 27167, 27170, 13583, 1110, 27102, 13593, 13297, 13935, 27710, 18514, 27107, 27118, 214))) GROUP BY fp.id_feature_value	4.232 ms	128	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, cp.position FROM mb_product p LEFT JOIN mb_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mb_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN mb_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN mb_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN mb_category_product cp ON (p.id_product = cp.id_product) INNER JOIN mb_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN mb_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN mb_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN mb_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN mb_feature_product fp_1 ON (p.id_product = fp_1.id_product) WHERE ((fp.id_feature_value IN (43, 3659, 46))) AND ((fp_1.id_feature_value IN (27208, 28133, 27167, 27170, 13583, 1110, 27102, 13593, 13297, 13935, 27710, 18514, 27107, 27118, 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_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN mb_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((fp.id_feature=1)) AND ((fp_1.id_feature_value IN (43, 3659, 46))) AND ((fp_2.id_feature_value IN (27208, 28133, 27167, 27170, 13583, 1110, 27102, 13593, 13297, 13935, 27710, 18514, 27107, 27118, 214))) GROUP BY fp.id_feature_value	3.451 ms	238144	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)
128	SELECT SQL_NO_CACHE fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM mb_product p LEFT JOIN mb_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mb_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN mb_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN mb_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN mb_category_product cp ON (p.id_product = cp.id_product) INNER JOIN mb_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN mb_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN mb_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN mb_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN mb_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN mb_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((fp.id_feature_value=1639)) AND ((fp_1.id_feature_value IN (43, 3659, 46))) AND ((fp_2.id_feature_value IN (27208, 28133, 27167, 27170, 13583, 1110, 27102, 13593, 13297, 13935, 27710, 18514, 27107, 27118, 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_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 ((fp.id_feature=37)) AND ((fp_1.id_feature_value=1639)) AND ((fp_2.id_feature_value IN (43, 3659, 46))) AND ((fp_3.id_feature_value IN (27208, 28133, 27167, 27170, 13583, 1110, 27102, 13593, 13297, 13935, 27710, 18514, 27107, 27118, 214))) GROUP BY fp.id_feature_value	3.166 ms	1024	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)
135	SELECT SQL_NO_CACHE fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM mb_product p LEFT JOIN mb_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mb_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN mb_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN mb_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN mb_category_product cp ON (p.id_product = cp.id_product) INNER JOIN mb_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN mb_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN mb_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN mb_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN mb_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN mb_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((fp.id_feature_value=1639)) AND ((fp_1.id_feature_value IN (43, 3659, 46))) AND ((fp_2.id_feature_value IN (27208, 28133, 27167, 27170, 13583, 1110, 27102, 13593, 13297, 13935, 27710, 18514, 27107, 27118, 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_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 ((fp.id_feature=44)) AND ((fp_1.id_feature_value=1639)) AND ((fp_2.id_feature_value IN (43, 3659, 46))) AND ((fp_3.id_feature_value IN (27208, 28133, 27167, 27170, 13583, 1110, 27102, 13593, 13297, 13935, 27710, 18514, 27107, 27118, 214))) GROUP BY fp.id_feature_value	2.758 ms	512	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)
206	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.734 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)
108	SELECT SQL_NO_CACHE fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM mb_product p LEFT JOIN mb_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mb_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN mb_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN mb_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN mb_category_product cp ON (p.id_product = cp.id_product) INNER JOIN mb_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN mb_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN mb_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN mb_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN mb_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN mb_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((fp.id_feature_value=1639)) AND ((fp_1.id_feature_value IN (43, 3659, 46))) AND ((fp_2.id_feature_value IN (27208, 28133, 27167, 27170, 13583, 1110, 27102, 13593, 13297, 13935, 27710, 18514, 27107, 27118, 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_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 ((fp.id_feature=16)) AND ((fp_1.id_feature_value=1639)) AND ((fp_2.id_feature_value IN (43, 3659, 46))) AND ((fp_3.id_feature_value IN (27208, 28133, 27167, 27170, 13583, 1110, 27102, 13593, 13297, 13935, 27710, 18514, 27107, 27118, 214))) GROUP BY fp.id_feature_value	2.697 ms	768	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)
133	SELECT SQL_NO_CACHE fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM mb_product p LEFT JOIN mb_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mb_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN mb_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN mb_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN mb_category_product cp ON (p.id_product = cp.id_product) INNER JOIN mb_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN mb_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN mb_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN mb_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN mb_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN mb_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((fp.id_feature_value=1639)) AND ((fp_1.id_feature_value IN (43, 3659, 46))) AND ((fp_2.id_feature_value IN (27208, 28133, 27167, 27170, 13583, 1110, 27102, 13593, 13297, 13935, 27710, 18514, 27107, 27118, 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_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 ((fp.id_feature=42)) AND ((fp_1.id_feature_value=1639)) AND ((fp_2.id_feature_value IN (43, 3659, 46))) AND ((fp_3.id_feature_value IN (27208, 28133, 27167, 27170, 13583, 1110, 27102, 13593, 13297, 13935, 27710, 18514, 27107, 27118, 214))) GROUP BY fp.id_feature_value	2.688 ms	768	Yes	/modules/ps_facetedsearch/src/Adapter/MySQL.php:86 /modules/ps_facetedsearch/src/Adapter/MySQL.php:786 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:855 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:154 (getFeaturesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:138 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
111	SELECT SQL_NO_CACHE fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM mb_product p LEFT JOIN mb_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mb_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN mb_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN mb_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN mb_category_product cp ON (p.id_product = cp.id_product) INNER JOIN mb_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN mb_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN mb_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN mb_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN mb_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN mb_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((fp.id_feature_value=1639)) AND ((fp_1.id_feature_value IN (43, 3659, 46))) AND ((fp_2.id_feature_value IN (27208, 28133, 27167, 27170, 13583, 1110, 27102, 13593, 13297, 13935, 27710, 18514, 27107, 27118, 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_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 ((fp.id_feature=18)) AND ((fp_1.id_feature_value=1639)) AND ((fp_2.id_feature_value IN (43, 3659, 46))) AND ((fp_3.id_feature_value IN (27208, 28133, 27167, 27170, 13583, 1110, 27102, 13593, 13297, 13935, 27710, 18514, 27107, 27118, 214))) GROUP BY fp.id_feature_value	2.635 ms	768	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)
77	SELECT SQL_NO_CACHE cp.id_category, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM mb_product p LEFT JOIN mb_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mb_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN mb_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN mb_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN mb_category_product cp ON (p.id_product = cp.id_product) INNER JOIN mb_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN mb_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN mb_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN mb_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN mb_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN mb_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((fp.id_feature_value=1639)) AND ((fp_1.id_feature_value IN (43, 3659, 46))) AND ((fp_2.id_feature_value IN (27208, 28133, 27167, 27170, 13583, 1110, 27102, 13593, 13297, 13935, 27710, 18514, 27107, 27118, 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_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=1639)) AND ((fp_1.id_feature_value IN (43, 3659, 46))) AND ((fp_2.id_feature_value IN (27208, 28133, 27167, 27170, 13583, 1110, 27102, 13593, 13297, 13935, 27710, 18514, 27107, 27118, 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.616 ms	768	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)
132	SELECT SQL_NO_CACHE fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM mb_product p LEFT JOIN mb_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mb_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN mb_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN mb_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN mb_category_product cp ON (p.id_product = cp.id_product) INNER JOIN mb_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN mb_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN mb_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN mb_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN mb_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN mb_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((fp.id_feature_value=1639)) AND ((fp_1.id_feature_value IN (43, 3659, 46))) AND ((fp_2.id_feature_value IN (27208, 28133, 27167, 27170, 13583, 1110, 27102, 13593, 13297, 13935, 27710, 18514, 27107, 27118, 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_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 ((fp.id_feature=41)) AND ((fp_1.id_feature_value=1639)) AND ((fp_2.id_feature_value IN (43, 3659, 46))) AND ((fp_3.id_feature_value IN (27208, 28133, 27167, 27170, 13583, 1110, 27102, 13593, 13297, 13935, 27710, 18514, 27107, 27118, 214))) GROUP BY fp.id_feature_value	2.537 ms	384	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)
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, 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=1639)) AND ((fp_1.id_feature_value IN (43, 3659, 46))) AND ((fp_2.id_feature_value IN (27208, 28133, 27167, 27170, 13583, 1110, 27102, 13593, 13297, 13935, 27710, 18514, 27107, 27118, 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_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 ((fp.id_feature=23)) AND ((fp_1.id_feature_value=1639)) AND ((fp_2.id_feature_value IN (43, 3659, 46))) AND ((fp_3.id_feature_value IN (27208, 28133, 27167, 27170, 13583, 1110, 27102, 13593, 13297, 13935, 27710, 18514, 27107, 27118, 214))) GROUP BY fp.id_feature_value	2.396 ms	256	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)
109	SELECT SQL_NO_CACHE v., vl., IF(lifvlv.`url_name` IS NULL OR lifvlv.`url_name` = "", NULL, lifvlv.`url_name`) AS url_name, IF(lifvlv.`meta_title` IS NULL OR lifvlv.`meta_title` = "", NULL, lifvlv.`meta_title`) AS meta_title FROM `mb_feature_value` v LEFT JOIN `mb_feature_value_lang` vl ON (v.`id_feature_value` = vl.`id_feature_value` AND vl.`id_lang` = 1) LEFT JOIN `mb_layered_indexable_feature_value_lang_value` lifvlv ON (v.`id_feature_value` = lifvlv.`id_feature_value` AND lifvlv.`id_lang` = 1) WHERE v.`id_feature` = 16 ORDER BY vl.`value` ASC	2.066 ms	282	Yes	/modules/ps_facetedsearch/src/Filters/DataAccessor.php:204 /modules/ps_facetedsearch/src/Filters/Block.php:864 (getFeatureValues) /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.033 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)
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, 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=1639)) AND ((fp_1.id_feature_value IN (43, 3659, 46))) AND ((fp_2.id_feature_value IN (27208, 28133, 27167, 27170, 13583, 1110, 27102, 13593, 13297, 13935, 27710, 18514, 27107, 27118, 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_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 ((fp.id_feature=17)) AND ((fp_1.id_feature_value=1639)) AND ((fp_2.id_feature_value IN (43, 3659, 46))) AND ((fp_3.id_feature_value IN (27208, 28133, 27167, 27170, 13583, 1110, 27102, 13593, 13297, 13935, 27710, 18514, 27107, 27118, 214))) GROUP BY fp.id_feature_value	2.032 ms	768	Yes	/modules/ps_facetedsearch/src/Adapter/MySQL.php:86 /modules/ps_facetedsearch/src/Adapter/MySQL.php:786 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:855 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:154 (getFeaturesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:138 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
117	SELECT SQL_NO_CACHE fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM mb_product p LEFT JOIN mb_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mb_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN mb_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN mb_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN mb_category_product cp ON (p.id_product = cp.id_product) INNER JOIN mb_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN mb_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN mb_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN mb_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN mb_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN mb_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((fp.id_feature_value=1639)) AND ((fp_1.id_feature_value IN (43, 3659, 46))) AND ((fp_2.id_feature_value IN (27208, 28133, 27167, 27170, 13583, 1110, 27102, 13593, 13297, 13935, 27710, 18514, 27107, 27118, 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_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 ((fp.id_feature=24)) AND ((fp_1.id_feature_value=1639)) AND ((fp_2.id_feature_value IN (43, 3659, 46))) AND ((fp_3.id_feature_value IN (27208, 28133, 27167, 27170, 13583, 1110, 27102, 13593, 13297, 13935, 27710, 18514, 27107, 27118, 214))) GROUP BY fp.id_feature_value	1.975 ms	768	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 COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM mb_product p LEFT JOIN mb_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mb_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN mb_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN mb_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN mb_category_product cp ON (p.id_product = cp.id_product) INNER JOIN mb_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN mb_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN mb_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN mb_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN mb_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN mb_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((fp.id_feature_value=1639)) AND ((fp_1.id_feature_value IN (43, 3659, 46))) AND ((fp_2.id_feature_value IN (27208, 28133, 27167, 27170, 13583, 1110, 27102, 13593, 13297, 13935, 27710, 18514, 27107, 27118, 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_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=1639)) AND ((fp_1.id_feature_value IN (43, 3659, 46))) AND ((fp_2.id_feature_value IN (27208, 28133, 27167, 27170, 13583, 1110, 27102, 13593, 13297, 13935, 27710, 18514, 27107, 27118, 214)))	1.900 ms	768		/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)
134	SELECT SQL_NO_CACHE fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM mb_product p LEFT JOIN mb_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mb_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN mb_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN mb_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN mb_category_product cp ON (p.id_product = cp.id_product) INNER JOIN mb_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN mb_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN mb_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN mb_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN mb_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN mb_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((fp.id_feature_value=1639)) AND ((fp_1.id_feature_value IN (43, 3659, 46))) AND ((fp_2.id_feature_value IN (27208, 28133, 27167, 27170, 13583, 1110, 27102, 13593, 13297, 13935, 27710, 18514, 27107, 27118, 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_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 ((fp.id_feature=43)) AND ((fp_1.id_feature_value=1639)) AND ((fp_2.id_feature_value IN (43, 3659, 46))) AND ((fp_3.id_feature_value IN (27208, 28133, 27167, 27170, 13583, 1110, 27102, 13593, 13297, 13935, 27710, 18514, 27107, 27118, 214))) GROUP BY fp.id_feature_value	1.895 ms	384	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 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.828 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)
106	SELECT SQL_NO_CACHE fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM mb_product p LEFT JOIN mb_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mb_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN mb_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN mb_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN mb_category_product cp ON (p.id_product = cp.id_product) INNER JOIN mb_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN mb_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN mb_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN mb_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN mb_feature_product fp_1 ON (p.id_product = fp_1.id_product) WHERE ((fp.id_feature_value=1639)) AND ((fp_1.id_feature_value IN (43, 3659, 46))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=188 AND c.nright<=195 GROUP BY p.id_product) p INNER JOIN mb_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN mb_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN mb_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((fp.id_feature=15)) AND ((fp_1.id_feature_value=1639)) AND ((fp_2.id_feature_value IN (43, 3659, 46))) GROUP BY fp.id_feature_value	1.743 ms	2304	Yes	/modules/ps_facetedsearch/src/Adapter/MySQL.php:86 /modules/ps_facetedsearch/src/Adapter/MySQL.php:786 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:855 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:154 (getFeaturesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:138 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
119	SELECT SQL_NO_CACHE fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM mb_product p LEFT JOIN mb_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mb_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN mb_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN mb_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN mb_category_product cp ON (p.id_product = cp.id_product) INNER JOIN mb_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN mb_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN mb_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN mb_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN mb_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN mb_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((fp.id_feature_value=1639)) AND ((fp_1.id_feature_value IN (43, 3659, 46))) AND ((fp_2.id_feature_value IN (27208, 28133, 27167, 27170, 13583, 1110, 27102, 13593, 13297, 13935, 27710, 18514, 27107, 27118, 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_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 ((fp.id_feature=28)) AND ((fp_1.id_feature_value=1639)) AND ((fp_2.id_feature_value IN (43, 3659, 46))) AND ((fp_3.id_feature_value IN (27208, 28133, 27167, 27170, 13583, 1110, 27102, 13593, 13297, 13935, 27710, 18514, 27107, 27118, 214))) GROUP BY fp.id_feature_value	1.716 ms	768	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 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` = 1) LEFT JOIN `mb_layered_indexable_feature_value_lang_value` lifvlv ON (v.`id_feature_value` = lifvlv.`id_feature_value` AND lifvlv.`id_lang` = 1) WHERE v.`id_feature` = 15 ORDER BY vl.`value` ASC	1.669 ms	137	Yes	/modules/ps_facetedsearch/src/Filters/DataAccessor.php:204 /modules/ps_facetedsearch/src/Filters/Block.php:864 (getFeatureValues) /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)
115	SELECT SQL_NO_CACHE fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM mb_product p LEFT JOIN mb_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mb_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN mb_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN mb_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN mb_category_product cp ON (p.id_product = cp.id_product) INNER JOIN mb_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN mb_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN mb_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN mb_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN mb_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN mb_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((fp.id_feature_value=1639)) AND ((fp_1.id_feature_value IN (43, 3659, 46))) AND ((fp_2.id_feature_value IN (27208, 28133, 27167, 27170, 13583, 1110, 27102, 13593, 13297, 13935, 27710, 18514, 27107, 27118, 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_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 ((fp.id_feature=22)) AND ((fp_1.id_feature_value=1639)) AND ((fp_2.id_feature_value IN (43, 3659, 46))) AND ((fp_3.id_feature_value IN (27208, 28133, 27167, 27170, 13583, 1110, 27102, 13593, 13297, 13935, 27710, 18514, 27107, 27118, 214))) GROUP BY fp.id_feature_value	1.657 ms	1152	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)
114	SELECT SQL_NO_CACHE fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM mb_product p LEFT JOIN mb_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mb_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN mb_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN mb_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN mb_category_product cp ON (p.id_product = cp.id_product) INNER JOIN mb_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN mb_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN mb_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN mb_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN mb_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN mb_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((fp.id_feature_value=1639)) AND ((fp_1.id_feature_value IN (43, 3659, 46))) AND ((fp_2.id_feature_value IN (27208, 28133, 27167, 27170, 13583, 1110, 27102, 13593, 13297, 13935, 27710, 18514, 27107, 27118, 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_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 ((fp.id_feature=21)) AND ((fp_1.id_feature_value=1639)) AND ((fp_2.id_feature_value IN (43, 3659, 46))) AND ((fp_3.id_feature_value IN (27208, 28133, 27167, 27170, 13583, 1110, 27102, 13593, 13297, 13935, 27710, 18514, 27107, 27118, 214))) GROUP BY fp.id_feature_value	1.576 ms	384	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 p.id_manufacturer, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM mb_product p LEFT JOIN mb_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mb_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN mb_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN mb_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN mb_category_product cp ON (p.id_product = cp.id_product) INNER JOIN mb_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN mb_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN mb_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN mb_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN mb_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN mb_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((fp.id_feature_value=1639)) AND ((fp_1.id_feature_value IN (43, 3659, 46))) AND ((fp_2.id_feature_value IN (27208, 28133, 27167, 27170, 13583, 1110, 27102, 13593, 13297, 13935, 27710, 18514, 27107, 27118, 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_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=1639)) AND ((fp_1.id_feature_value IN (43, 3659, 46))) AND ((fp_2.id_feature_value IN (27208, 28133, 27167, 27170, 13583, 1110, 27102, 13593, 13297, 13935, 27710, 18514, 27107, 27118, 214))) GROUP BY p.id_manufacturer	1.520 ms	768	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)
126	SELECT SQL_NO_CACHE fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM mb_product p LEFT JOIN mb_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mb_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN mb_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN mb_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN mb_category_product cp ON (p.id_product = cp.id_product) INNER JOIN mb_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN mb_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN mb_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN mb_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN mb_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN mb_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((fp.id_feature_value=1639)) AND ((fp_1.id_feature_value IN (43, 3659, 46))) AND ((fp_2.id_feature_value IN (27208, 28133, 27167, 27170, 13583, 1110, 27102, 13593, 13297, 13935, 27710, 18514, 27107, 27118, 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_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 ((fp.id_feature=35)) AND ((fp_1.id_feature_value=1639)) AND ((fp_2.id_feature_value IN (43, 3659, 46))) AND ((fp_3.id_feature_value IN (27208, 28133, 27167, 27170, 13583, 1110, 27102, 13593, 13297, 13935, 27710, 18514, 27107, 27118, 214))) GROUP BY fp.id_feature_value	1.463 ms	640	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, 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=1639)) AND ((fp_1.id_feature_value IN (43, 3659, 46))) AND ((fp_2.id_feature_value IN (27208, 28133, 27167, 27170, 13583, 1110, 27102, 13593, 13297, 13935, 27710, 18514, 27107, 27118, 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_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 ((fp.id_feature=27)) AND ((fp_1.id_feature_value=1639)) AND ((fp_2.id_feature_value IN (43, 3659, 46))) AND ((fp_3.id_feature_value IN (27208, 28133, 27167, 27170, 13583, 1110, 27102, 13593, 13297, 13935, 27710, 18514, 27107, 27118, 214))) GROUP BY fp.id_feature_value	1.459 ms	768	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)
131	SELECT SQL_NO_CACHE fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM mb_product p LEFT JOIN mb_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mb_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN mb_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN mb_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN mb_category_product cp ON (p.id_product = cp.id_product) INNER JOIN mb_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN mb_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN mb_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN mb_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN mb_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN mb_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((fp.id_feature_value=1639)) AND ((fp_1.id_feature_value IN (43, 3659, 46))) AND ((fp_2.id_feature_value IN (27208, 28133, 27167, 27170, 13583, 1110, 27102, 13593, 13297, 13935, 27710, 18514, 27107, 27118, 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_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 ((fp.id_feature=40)) AND ((fp_1.id_feature_value=1639)) AND ((fp_2.id_feature_value IN (43, 3659, 46))) AND ((fp_3.id_feature_value IN (27208, 28133, 27167, 27170, 13583, 1110, 27102, 13593, 13297, 13935, 27710, 18514, 27107, 27118, 214))) GROUP BY fp.id_feature_value	1.457 ms	128	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 COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM mb_product p LEFT JOIN mb_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mb_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN mb_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN mb_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN mb_category_product cp ON (p.id_product = cp.id_product) INNER JOIN mb_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN mb_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN mb_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN mb_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN mb_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN mb_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((fp.id_feature_value=1639)) AND ((fp_1.id_feature_value IN (43, 3659, 46))) AND ((fp_2.id_feature_value IN (27208, 28133, 27167, 27170, 13583, 1110, 27102, 13593, 13297, 13935, 27710, 18514, 27107, 27118, 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_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 ((p.on_sale=1)) AND ((fp_1.id_feature_value=1639)) AND ((fp_2.id_feature_value IN (43, 3659, 46))) AND ((fp_3.id_feature_value IN (27208, 28133, 27167, 27170, 13583, 1110, 27102, 13593, 13297, 13935, 27710, 18514, 27107, 27118, 214)))	1.445 ms	768		/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)
124	SELECT SQL_NO_CACHE fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM mb_product p LEFT JOIN mb_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mb_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN mb_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN mb_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN mb_category_product cp ON (p.id_product = cp.id_product) INNER JOIN mb_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN mb_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN mb_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN mb_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN mb_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN mb_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((fp.id_feature_value=1639)) AND ((fp_1.id_feature_value IN (43, 3659, 46))) AND ((fp_2.id_feature_value IN (27208, 28133, 27167, 27170, 13583, 1110, 27102, 13593, 13297, 13935, 27710, 18514, 27107, 27118, 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_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 ((fp.id_feature=33)) AND ((fp_1.id_feature_value=1639)) AND ((fp_2.id_feature_value IN (43, 3659, 46))) AND ((fp_3.id_feature_value IN (27208, 28133, 27167, 27170, 13583, 1110, 27102, 13593, 13297, 13935, 27710, 18514, 27107, 27118, 214))) GROUP BY fp.id_feature_value	1.414 ms	768	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, 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=1639)) AND ((fp_1.id_feature_value IN (43, 3659, 46))) AND ((fp_2.id_feature_value IN (27208, 28133, 27167, 27170, 13583, 1110, 27102, 13593, 13297, 13935, 27710, 18514, 27107, 27118, 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:54:53' >= sp.from) AND (sp.to = '0000-00-00 00:00:00' OR '2025-07-28 23:54:53' <= sp.to) ) LEFT JOIN mb_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN mb_feature_product fp_2 ON (p.id_product = fp_2.id_product) LEFT JOIN mb_feature_product fp_3 ON (p.id_product = fp_3.id_product) WHERE ((sp.reduction>0)) AND ((fp_1.id_feature_value=1639)) AND ((fp_2.id_feature_value IN (43, 3659, 46))) AND ((fp_3.id_feature_value IN (27208, 28133, 27167, 27170, 13583, 1110, 27102, 13593, 13297, 13935, 27710, 18514, 27107, 27118, 214)))	1.404 ms	768		/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)
73	SELECT SQL_NO_CACHE p.id_product FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM mb_product p LEFT JOIN mb_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mb_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN mb_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN mb_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN mb_category_product cp ON (p.id_product = cp.id_product) INNER JOIN mb_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN mb_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN mb_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN mb_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN mb_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN mb_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((fp.id_feature_value=1639)) AND ((fp_1.id_feature_value IN (43, 3659, 46))) AND ((fp_2.id_feature_value IN (27208, 28133, 27167, 27170, 13583, 1110, 27102, 13593, 13297, 13935, 27710, 18514, 27107, 27118, 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) GROUP BY p.id_product ORDER BY p.position ASC, p.id_product DESC LIMIT 0, 12	1.394 ms	2304	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)
127	SELECT SQL_NO_CACHE fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM mb_product p LEFT JOIN mb_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mb_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN mb_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN mb_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN mb_category_product cp ON (p.id_product = cp.id_product) INNER JOIN mb_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN mb_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN mb_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN mb_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN mb_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN mb_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((fp.id_feature_value=1639)) AND ((fp_1.id_feature_value IN (43, 3659, 46))) AND ((fp_2.id_feature_value IN (27208, 28133, 27167, 27170, 13583, 1110, 27102, 13593, 13297, 13935, 27710, 18514, 27107, 27118, 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_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 ((fp.id_feature=36)) AND ((fp_1.id_feature_value=1639)) AND ((fp_2.id_feature_value IN (43, 3659, 46))) AND ((fp_3.id_feature_value IN (27208, 28133, 27167, 27170, 13583, 1110, 27102, 13593, 13297, 13935, 27710, 18514, 27107, 27118, 214))) GROUP BY fp.id_feature_value	1.371 ms	256	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)
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, 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=1639)) AND ((fp_1.id_feature_value IN (43, 3659, 46))) AND ((fp_2.id_feature_value IN (27208, 28133, 27167, 27170, 13583, 1110, 27102, 13593, 13297, 13935, 27710, 18514, 27107, 27118, 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=1639)) AND ((fp_2.id_feature_value IN (43, 3659, 46))) AND ((fp_3.id_feature_value IN (27208, 28133, 27167, 27170, 13583, 1110, 27102, 13593, 13297, 13935, 27710, 18514, 27107, 27118, 214))) GROUP BY pac.id_attribute	1.342 ms	18432	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)
137	SELECT SQL_NO_CACHE fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM mb_product p LEFT JOIN mb_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mb_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN mb_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN mb_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN mb_category_product cp ON (p.id_product = cp.id_product) INNER JOIN mb_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN mb_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN mb_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN mb_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN mb_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN mb_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((fp.id_feature_value=1639)) AND ((fp_1.id_feature_value IN (43, 3659, 46))) AND ((fp_2.id_feature_value IN (27208, 28133, 27167, 27170, 13583, 1110, 27102, 13593, 13297, 13935, 27710, 18514, 27107, 27118, 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_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 ((fp.id_feature=55)) AND ((fp_1.id_feature_value=1639)) AND ((fp_2.id_feature_value IN (43, 3659, 46))) AND ((fp_3.id_feature_value IN (27208, 28133, 27167, 27170, 13583, 1110, 27102, 13593, 13297, 13935, 27710, 18514, 27107, 27118, 214))) GROUP BY fp.id_feature_value	1.315 ms	640	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)
94	SELECT SQL_NO_CACHE fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM mb_product p LEFT JOIN mb_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mb_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN mb_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN mb_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN mb_category_product cp ON (p.id_product = cp.id_product) INNER JOIN mb_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN mb_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN mb_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN mb_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN mb_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN mb_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((fp.id_feature_value=1639)) AND ((fp_1.id_feature_value IN (43, 3659, 46))) AND ((fp_2.id_feature_value IN (27208, 28133, 27167, 27170, 13583, 1110, 27102, 13593, 13297, 13935, 27710, 18514, 27107, 27118, 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_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 ((fp.id_feature=4)) AND ((fp_1.id_feature_value=1639)) AND ((fp_2.id_feature_value IN (43, 3659, 46))) AND ((fp_3.id_feature_value IN (27208, 28133, 27167, 27170, 13583, 1110, 27102, 13593, 13297, 13935, 27710, 18514, 27107, 27118, 214))) GROUP BY fp.id_feature_value	1.299 ms	768	Yes	/modules/ps_facetedsearch/src/Adapter/MySQL.php:86 /modules/ps_facetedsearch/src/Adapter/MySQL.php:786 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:855 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:154 (getFeaturesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:138 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
120	SELECT SQL_NO_CACHE fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM mb_product p LEFT JOIN mb_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mb_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN mb_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN mb_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN mb_category_product cp ON (p.id_product = cp.id_product) INNER JOIN mb_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN mb_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN mb_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN mb_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN mb_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN mb_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((fp.id_feature_value=1639)) AND ((fp_1.id_feature_value IN (43, 3659, 46))) AND ((fp_2.id_feature_value IN (27208, 28133, 27167, 27170, 13583, 1110, 27102, 13593, 13297, 13935, 27710, 18514, 27107, 27118, 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_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 ((fp.id_feature=29)) AND ((fp_1.id_feature_value=1639)) AND ((fp_2.id_feature_value IN (43, 3659, 46))) AND ((fp_3.id_feature_value IN (27208, 28133, 27167, 27170, 13583, 1110, 27102, 13593, 13297, 13935, 27710, 18514, 27107, 27118, 214))) GROUP BY fp.id_feature_value	1.279 ms	768	Yes	/modules/ps_facetedsearch/src/Adapter/MySQL.php:86 /modules/ps_facetedsearch/src/Adapter/MySQL.php:786 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:855 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:154 (getFeaturesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:138 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)

193 queries	SELECT * FROM `mb_category` a LEFT JOIN `mb_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = XX LEFT JOIN `mb_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = XX WHERE (a.`id_category` = XX) AND (b.`id_shop` = XX) LIMIT XX
143 queries	SELECT c.*, cl.name,cl.link_rewrite FROM `mb_category` c INNER JOIN `mb_category_shop` cs ON (c.id_category =cs.id_category AND cs.id_shop=XX) LEFT JOIN `mb_category_lang` cl ON c.id_category=cl.id_category AND cl.id_lang=XX AND cl.id_shop=XX WHERE c.active = XX AND c.id_parent=XX AND c.id_category!=XX ORDER BY cl.name ASC,c.id_category ASC
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, cp.position FROM mb_product p LEFT JOIN mb_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mb_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN mb_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, XX) = sa.id_product_attribute AND sa.id_shop = XX AND sa.id_shop_group = XX ) LEFT JOIN mb_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN mb_category_product cp ON (p.id_product = cp.id_product) INNER JOIN mb_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = XX AND ps.active = TRUE) INNER JOIN mb_category c ON (cp.id_category = c.id_category AND c.active=XX) LEFT JOIN mb_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN mb_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN mb_feature_product fp_XX ON (p.id_product = fp_XX.id_product) LEFT JOIN mb_feature_product fp_XX ON (p.id_product = fp_XX.id_product) WHERE ((fp.id_feature_value=XX)) AND ((fp_XX.id_feature_value IN (XX, XX, XX))) AND ((fp_XX.id_feature_value IN (XX, XX, XX, XX, XX, XX, XX, XX, XX, XX, XX, XX, XX, XX, XX))) AND ps.id_shop='XX' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='XX' AND c.nleft>=XX AND c.nright<=XX GROUP BY p.id_product) p INNER JOIN mb_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN mb_feature_product fp_XX ON (p.id_product = fp_XX.id_product) LEFT JOIN mb_feature_product fp_XX ON (p.id_product = fp_XX.id_product) LEFT JOIN mb_feature_product fp_XX ON (p.id_product = fp_XX.id_product) WHERE ((fp.id_feature=XX)) AND ((fp_XX.id_feature_value=XX)) AND ((fp_XX.id_feature_value IN (XX, XX, XX))) AND ((fp_XX.id_feature_value IN (XX, XX, XX, XX, XX, XX, XX, XX, XX, XX, XX, XX, XX, XX, XX))) 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
21 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
19 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 cl.`link_rewrite` FROM `mb_category_lang` cl WHERE `id_lang` = XX AND cl.id_shop = XX AND cl.`id_category` = XX LIMIT XX
10 queries	SELECT v., vl., IF(lifvlv.`url_name` IS NULL OR lifvlv.`url_name` = "", NULL, lifvlv.`url_name`) AS url_name, IF(lifvlv.`meta_title` IS NULL OR lifvlv.`meta_title` = "", NULL, lifvlv.`meta_title`) AS meta_title FROM `mb_feature_value` v LEFT JOIN `mb_feature_value_lang` vl ON (v.`id_feature_value` = vl.`id_feature_value` AND vl.`id_lang` = XX) LEFT JOIN `mb_layered_indexable_feature_value_lang_value` lifvlv ON (v.`id_feature_value` = lifvlv.`id_feature_value` AND lifvlv.`id_lang` = XX) WHERE v.`id_feature` = XX ORDER BY vl.`value` ASC
9 queries	SELECT * 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 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
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 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
4 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
4 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
4 queries	SELECT * FROM `mb_product_attribute_lang` WHERE `id_product_attribute` = XX
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
3 queries	SELECT `need_identification_number` FROM `mb_country` WHERE `id_country` = XX LIMIT XX

#	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 VIVO Y1S 2G 32G BLEU

SMARTPHONE VIVO Y1S 2G 32G BLEU

SMARTPHONE VIVO Y1S 2G 32G BLEU

SMARTPHONE VIVO Y1S 2G 32G BLEU

SMARTPHONE SMART M30 2G 32G 4G

SMARTPHONE SMART M30 2G 32G 4G

SMARTPHONE SMART M30 2G 32G 4G

SMARTPHONE SMART M30 2G 32G 4G

SMARTPHONE NOKIA C12 2GO 64GO

SMARTPHONE NOKIA C12 2GO 64GO

SMARTPHONE NOKIA C12 2GO 64GO

SMARTPHONE NOKIA C12 2GO 64GO

Stopwatch SQL - 972 queries

Doubles

Tables stress

ObjectModel instances

Included Files