Nume cookie	Furnizor	Scop	Expirare
apc_popup_session	https://www.hometel.ro	Used to know if it is a new browser session.	Sesiune
cookiesplus	https://www.hometel.ro	Reține preferințele dvs. legate de modulele cookie.	1 an
laravel_session	https://www.hometel.ro	Cookie folosit pentru a identifica o instanță de sesiune pentru utilizator.	1 zi
PHP_SESSID	https://www.hometel.ro	Acest cookie este originar din PHP și permite site-urilor web să stocheze date de stare serializate. Este utilizat pentru a stabili o sesiune de utilizator și pentru a transmite date de stare printr-un cookie temporar, care este denumit în mod obișnuit un cookie de sesiune.	Sesiune
PrestaShop-#	https://www.hometel.ro	Acest cookie ajută la menținerea sesiunilor utilizatorului deschise în timp ce vizitează un site web și îi ajută să facă comenzi și multe alte operațiuni, cum ar fi: data adăugării cookie-ului, limba selectată, moneda utilizată, ultima categorie de produse vizitate, ultimele produse văzute, identificarea clientului, numele, prenume, parolă criptată, e-mail conectat la cont, identificare coș de cumpărături.	480 ore
rc::a	Google	Acest cookie este utilizat pentru a distinge oamenii de roboți. Acest lucru este benefic pentru site-ul web pentru a crea rapoarte valabile cu privire la utilizarea site-ului lor.	Persistent
rc::c	Google	Acest cookie este utilizat pentru a distinge între oameni și roboți..	Persistent
__cfduid		Cookie-uri tehnice solicitate de furnizorul CDN Cloudflare.	30 de zile

Nume cookie	Furnizor	Scop	Expirare
collect	Google	Este folosit pentru a trimite date către Google Analytics despre dispozitivul vizitatorului și comportamentul acestuia. Urmăriți vizitatorul pe dispozitive și canale de marketing.	Sesiune
r/collect	Google	Este folosit pentru a trimite date către Google Analytics despre dispozitivul vizitatorului și comportamentul acestuia. Urmăriți vizitatorul pe dispozitive și canale de marketing.	Sesiune
_ga	Google	Înregistrează un ID unic care este utilizat pentru a genera date statistice despre modul în care vizitatorul folosește site-ul web.	2 ani
_gat	Google	Folosit de Google Analytics pentru a restrânge rata solicitării	1 zi
_gat_gtag_UA_*	Google	Folosit pentru a limita rata de solicitare.	1 minut
_ga_#	Google	Used by Google Analytics to collect data on the number of times a user has visited the website as well as dates for the first and most recent visit.	2 ani
_gd#	Google	Acesta este un cookie de sesiune Google Analytics utilizat pentru a genera date statistice despre modul în care utilizați site-ul web, care este eliminat atunci când părăsiți browserul.	Sesiune
_gid	Google	Înregistrează un ID unic care este utilizat pentru a genera date statistice despre modul în care vizitatorul folosește site-ul web.	1 zi

Nume cookie	Furnizor	Scop	Expirare
ads/ga-audiences	Google	Aceste cookie-uri sunt utilizate de Google AdWords pentru a re-atrage vizitatori care ar putea converti la clienți pe baza comportamentului online al vizitatorului pe site-uri web.	Sesiune
NID	Google	Înregistrează un ID unic care identifică dispozitivul unui utilizator care se întoarce. ID-ul este utilizat pentru reclame direcționate.	6 luni

Load Time	401.025 ms
Querying Time	302 ms
Queries	449
Memory Peak Usage	17.7 Mb
Included Files	931 files - 12.95 Mb
PrestaShop Cache	- Mb
Global vars	0.10 Mb
- global $_MODULES	40k
- global $_MODULE	40k
- global $_SERVER	8k
- global $config	5k
- global $context	3k
- global $exportPhpConfigFile	3k
- global $_COOKIE	2k
- global $__composer_autoload_files	1k

PrestaShop Version	8.2.1
PHP Version	8.1.32
MySQL Version	8.0.41-0ubuntu0.24.04.1
Memory Limit	512M
Max Execution Time	60s
Smarty Cache	enabled
Smarty Compilation	auto

	Time	Cumulated Time	Memory Usage	Memory Peak Usage
config	18.635 ms	18.635 ms	4.79 Mb	4.9 Mb
__construct	0.015 ms	18.650 ms	- Mb	4.9 Mb
init	12.629 ms	31.279 ms	0.78 Mb	5.6 Mb
checkAccess	0.002 ms	31.281 ms	- Mb	5.6 Mb
setMedia	3.862 ms	35.143 ms	0.18 Mb	5.8 Mb
postProcess	0.001 ms	35.144 ms	- Mb	5.8 Mb
initHeader	0.002 ms	35.146 ms	- Mb	5.8 Mb
initContent	321.465 ms	356.611 ms	8.83 Mb	14.7 Mb
initFooter	0.004 ms	356.615 ms	- Mb	14.7 Mb
display	44.410 ms	401.025 ms	2.78 Mb	17.7 Mb

Hook	Time	Memory Usage
ActionStAssemble	44.437 ms	1.10 Mb
=> stthemeeditor	0.584 ms	0.02 Mb
=> sthoverimage	0.339 ms	0.01 Mb
=> stcompare	0.009 ms	- Mb
=> ststickers	5.273 ms	0.13 Mb
=> stwishlist	0.352 ms	0.01 Mb
=> stproductcomments	0.431 ms	0.01 Mb
=> stthemeeditor	0.504 ms	0.01 Mb
=> sthoverimage	0.351 ms	0.01 Mb
=> stcompare	0.003 ms	- Mb
=> ststickers	3.755 ms	0.09 Mb
=> stwishlist	0.284 ms	0.01 Mb
=> stproductcomments	0.284 ms	0.01 Mb
=> stthemeeditor	0.513 ms	0.01 Mb
=> sthoverimage	0.320 ms	0.01 Mb
=> stcompare	0.003 ms	- Mb
=> ststickers	5.389 ms	0.13 Mb
=> stwishlist	0.347 ms	0.01 Mb
=> stproductcomments	0.340 ms	0.01 Mb
=> stthemeeditor	0.443 ms	0.01 Mb
=> sthoverimage	0.411 ms	0.01 Mb
=> stcompare	0.004 ms	- Mb
=> ststickers	5.267 ms	0.13 Mb
=> stwishlist	0.268 ms	0.01 Mb
=> stproductcomments	0.312 ms	0.01 Mb
=> stthemeeditor	0.448 ms	0.01 Mb
=> sthoverimage	0.355 ms	0.01 Mb
=> stcompare	0.004 ms	- Mb
=> ststickers	5.947 ms	0.15 Mb
=> stwishlist	0.350 ms	0.01 Mb
=> stproductcomments	0.327 ms	0.01 Mb
=> stthemeeditor	0.434 ms	0.01 Mb
=> sthoverimage	0.359 ms	0.01 Mb
=> stcompare	0.003 ms	- Mb
=> ststickers	4.239 ms	0.11 Mb
=> stwishlist	0.308 ms	0.01 Mb
=> stproductcomments	0.388 ms	0.01 Mb
=> stthemeeditor	0.414 ms	0.01 Mb
=> sthoverimage	0.399 ms	0.01 Mb
=> stcompare	0.002 ms	- Mb
=> ststickers	4.029 ms	0.09 Mb
=> stwishlist	0.321 ms	0.01 Mb
=> stproductcomments	0.323 ms	0.01 Mb
DisplayHeader	20.847 ms	0.83 Mb
=> stthemeeditor	6.833 ms	0.24 Mb
=> ps_googleanalytics	0.202 ms	0.01 Mb
=> stcustomersignin	1.838 ms	0.02 Mb
=> stmultilink	0.359 ms	0.01 Mb
=> stsearchbar	0.387 ms	0.01 Mb
=> stshoppingcart	0.460 ms	0.01 Mb
=> stmegamenu	0.357 ms	0.01 Mb
=> stswiper	0.256 ms	0.07 Mb
=> stowlcarousel	0.329 ms	0.01 Mb
=> steasycontent	0.386 ms	0.03 Mb
=> stfeaturedslider	0.328 ms	0.01 Mb
=> stfeaturedcategories	0.278 ms	0.01 Mb
=> stblogeditor	0.280 ms	0.01 Mb
=> stblogfeaturedarticles	0.271 ms	0.01 Mb
=> stbanner	0.248 ms	0.01 Mb
=> stbrandsslider	0.267 ms	0.01 Mb
=> stspecialslider	0.301 ms	0.01 Mb
=> stblogrecentarticles	0.272 ms	0.01 Mb
=> stnewsletter	0.304 ms	0.01 Mb
=> stblogarchives	0.031 ms	- Mb
=> stblogcomments	0.048 ms	- Mb
=> stblogrelatedarticles	0.276 ms	0.01 Mb
=> stcountdown	0.292 ms	0.01 Mb
=> sthoverimage	0.075 ms	- Mb
=> stinstagram	0.586 ms	0.04 Mb
=> stcompare	0.463 ms	0.01 Mb
=> stnotification	0.301 ms	0.01 Mb
=> stpagebanner	0.271 ms	0.01 Mb
=> stproductcategoriesslider	0.341 ms	0.01 Mb
=> strelatedproducts	0.342 ms	0.01 Mb
=> stsidebar	0.227 ms	0.01 Mb
=> ststickers	1.045 ms	0.09 Mb
=> stvideo	0.256 ms	0.01 Mb
=> stwishlist	0.428 ms	0.02 Mb
=> stproductcomments	0.482 ms	0.01 Mb
=> stproductsasattrs	0.292 ms	0.01 Mb
=> sturls	0.043 ms	- Mb
=> cookiesplus	0.988 ms	0.02 Mb
=> ets_recaptcha_free	0.014 ms	- Mb
=> ets_whatsapp	0.090 ms	- Mb
DisplayBeforeBodyClosingTag	6.739 ms	0.48 Mb
=> ps_googleanalytics	1.599 ms	0.07 Mb
=> statsdata	0.788 ms	0.06 Mb
=> stwishlist	0.224 ms	- Mb
=> cookiesplus	4.128 ms	0.34 Mb
DisplaySideBar	3.406 ms	0.16 Mb
=> stsidebar	0.691 ms	0.02 Mb
=> stnewsletter	0.724 ms	0.02 Mb
=> stmegamenu	0.408 ms	0.03 Mb
=> stwishlist	0.985 ms	0.06 Mb
=> stsearchbar	0.237 ms	0.01 Mb
=> stshoppingcart	0.361 ms	0.03 Mb
displayLeftColumn	3.286 ms	0.15 Mb
=> ps_categorytree (widget)	3.286 ms	0.15 Mb
ActionFrontControllerSetMedia	2.603 ms	0.05 Mb
=> ps_emailalerts	0.056 ms	- Mb
=> cookiesplus	2.547 ms	0.05 Mb
displayBanner	2.602 ms	0.17 Mb
=> stnotification (widget)	1.574 ms	0.09 Mb
=> steasycontent (widget)	1.028 ms	0.08 Mb
displayTop	2.565 ms	0.14 Mb
=> stcustomersignin (widget)	2.024 ms	0.13 Mb
=> stshoppingcart (widget)	0.541 ms	0.01 Mb
ActionOutputHTMLBefore	1.701 ms	0.01 Mb
=> cookiesplus	1.517 ms	0.01 Mb
=> stswiper	0.048 ms	- Mb
=> stbanner	0.072 ms	- Mb
=> stinstagram	0.064 ms	- Mb
DisplayMobileBarLeft	1.399 ms	0.14 Mb
=> stsidebar	1.399 ms	0.14 Mb
DisplayMainMenu	1.309 ms	0.03 Mb
=> stmegamenu	1.309 ms	0.03 Mb
DisplayFooter	1.117 ms	0.08 Mb
=> ets_whatsapp	0.264 ms	0.02 Mb
=> stnewsletter	0.238 ms	0.02 Mb
=> stmultilink	0.293 ms	0.02 Mb
=> steasycontent	0.322 ms	0.02 Mb
displayHeaderCenter	1.066 ms	0.03 Mb
=> stsearchbar (widget)	1.066 ms	0.03 Mb
ActionDispatcherBefore	1.038 ms	0.01 Mb
=> sturls	1.013 ms	0.01 Mb
=> ets_delete_order	0.025 ms	- Mb
displayFullWidthTop	1.022 ms	0.05 Mb
=> stswiper (widget)	1.006 ms	0.05 Mb
=> steasycontent (widget)	0.016 ms	- Mb
ActionProductSearchAfter	0.856 ms	0.02 Mb
=> stthemeeditor	0.006 ms	- Mb
=> stcountdown	0.044 ms	- Mb
=> stcompare	0.031 ms	- Mb
=> ststickers	0.732 ms	0.01 Mb
=> stwishlist	0.043 ms	- Mb
DisplayCategoryHeader	0.795 ms	0.03 Mb
=> stswiper	0.276 ms	0.01 Mb
=> stowlcarousel	0.250 ms	0.01 Mb
=> stbanner	0.269 ms	0.01 Mb
DisplayMobileBar	0.770 ms	0.03 Mb
=> stsidebar	0.770 ms	0.03 Mb
displayBeforeBodyClosingTag	0.658 ms	0.02 Mb
=> stnotification (widget)	0.658 ms	0.02 Mb
DisplayLeftColumn	0.597 ms	0.14 Mb
=> ps_facetedsearch	0.212 ms	0.13 Mb
=> stmegamenu	0.385 ms	0.01 Mb
DisplayBreadcrumb	0.421 ms	0.01 Mb
=> stpagebanner	0.421 ms	0.01 Mb
DisplayRightBar	0.360 ms	0.04 Mb
=> stsidebar	0.360 ms	0.04 Mb
ProductSearchProvider	0.254 ms	- Mb
=> ps_facetedsearch	0.254 ms	- Mb
DisplayNav2	0.251 ms	0.01 Mb
=> stmultilink	0.251 ms	0.01 Mb
DisplayNav1	0.225 ms	0.02 Mb
=> stmultilink	0.225 ms	0.02 Mb
DisplayFooterAfter	0.218 ms	0.01 Mb
=> stmultilink	0.218 ms	0.01 Mb
DisplayMobileBarBottom	0.210 ms	- Mb
=> stsidebar	0.210 ms	- Mb
DisplayMobileBarCenter	0.199 ms	- Mb
=> stsidebar	0.199 ms	- Mb
ModuleRoutes	0.082 ms	0.01 Mb
=> stblog	0.004 ms	- Mb
=> stblogarchives	0.002 ms	- Mb
=> stblogsearch	0.002 ms	- Mb
=> sturls	0.045 ms	0.01 Mb
=> cookiesplus	0.029 ms	- Mb
ActionDispatcher	0.021 ms	- Mb
=> sturls	0.021 ms	- Mb
DisplayFullWidthBottom	0.021 ms	- Mb
=> stblogfeaturedarticles	0.021 ms	- Mb
displayFullWidthTop2	0.013 ms	- Mb
=> steasycontent (widget)	0.013 ms	- Mb
OverrideLayoutTemplate	0.008 ms	- Mb
=> stblog	0.003 ms	- Mb
=> stblog	0.003 ms	- Mb
=> stblog	0.002 ms	- Mb
DisplayAfterBodyOpeningTag	0.008 ms	- Mb
=> cookiesplus	0.008 ms	- Mb
DisplayFullWidthTop	0.006 ms	- Mb
=> stfeaturedslider	0.005 ms	- Mb
=> stproductcategoriesslider	0.001 ms	- Mb
FilterProductSearch	0.003 ms	- Mb
=> stsearchbar	0.003 ms	- Mb
36 hook(s)	101.113 ms	3.77 Mb

Module	Time	Memory Usage
sturls	2.424 ms	0.06 Mb
__construct	1.292 ms	0.04 Mb
hookModuleRoutes	0.047 ms	0.01 Mb
hookActionDispatcherBefore	1.016 ms	0.01 Mb
hookActionDispatcher	0.024 ms	- Mb
hookDisplayHeader	0.045 ms	- Mb
stblog	1.952 ms	0.10 Mb
__construct	1.926 ms	0.09 Mb
hookModuleRoutes	0.011 ms	- Mb
hookOverrideLayoutTemplate	0.006 ms	- Mb
hookOverrideLayoutTemplate	0.005 ms	- Mb
hookOverrideLayoutTemplate	0.004 ms	- Mb
stblogarchives	0.803 ms	0.03 Mb
__construct	0.767 ms	0.03 Mb
hookModuleRoutes	0.004 ms	- Mb
hookDisplayHeader	0.032 ms	- Mb
stblogsearch	0.841 ms	0.03 Mb
__construct	0.837 ms	0.03 Mb
hookModuleRoutes	0.004 ms	- Mb
cookiesplus	10.272 ms	0.52 Mb
__construct	1.037 ms	0.09 Mb
hookModuleRoutes	0.031 ms	- Mb
hookActionFrontControllerSetMedia	2.551 ms	0.05 Mb
hookDisplayHeader	0.991 ms	0.02 Mb
hookDisplayAfterBodyOpeningTag	0.011 ms	- Mb
hookDisplayBeforeBodyClosingTag	4.131 ms	0.34 Mb
hookActionOutputHTMLBefore	1.520 ms	0.01 Mb
ets_delete_order	0.786 ms	0.14 Mb
__construct	0.759 ms	0.14 Mb
hookActionDispatcherBefore	0.027 ms	- Mb
ps_emailalerts	0.972 ms	0.12 Mb
__construct	0.913 ms	0.12 Mb
hookActionFrontControllerSetMedia	0.059 ms	- Mb
stthemeeditor	10.551 ms	0.44 Mb
__construct	0.334 ms	0.09 Mb
hookDisplayHeader	6.837 ms	0.24 Mb
hookActionStAssemble	0.601 ms	0.02 Mb
hookActionStAssemble	0.506 ms	0.01 Mb
hookActionStAssemble	0.516 ms	0.01 Mb
hookActionStAssemble	0.446 ms	0.01 Mb
hookActionStAssemble	0.451 ms	0.01 Mb
hookActionStAssemble	0.437 ms	0.01 Mb
hookActionStAssemble	0.416 ms	0.01 Mb
hookActionProductSearchAfter	0.007 ms	- Mb
ps_googleanalytics	1.915 ms	0.11 Mb
__construct	0.109 ms	0.03 Mb
hookDisplayHeader	0.204 ms	0.01 Mb
hookDisplayBeforeBodyClosingTag	1.602 ms	0.07 Mb
stcustomersignin	4.015 ms	0.18 Mb
__construct	0.124 ms	0.02 Mb
hookDisplayHeader	1.864 ms	0.02 Mb
displayTop	2.027 ms	0.13 Mb
stmultilink	1.667 ms	0.13 Mb
__construct	0.307 ms	0.05 Mb
hookDisplayHeader	0.362 ms	0.01 Mb
hookDisplayNav1	0.228 ms	0.02 Mb
hookDisplayNav2	0.254 ms	0.01 Mb
hookDisplayFooter	0.295 ms	0.02 Mb
hookDisplayFooterAfter	0.221 ms	0.01 Mb
stsearchbar	1.880 ms	0.09 Mb
__construct	0.173 ms	0.03 Mb
hookDisplayHeader	0.390 ms	0.01 Mb
displayHeaderCenter	1.071 ms	0.03 Mb
hookFilterProductSearch	0.007 ms	- Mb
hookDisplaySideBar	0.239 ms	0.01 Mb
stshoppingcart	1.517 ms	0.14 Mb
__construct	0.146 ms	0.08 Mb
hookDisplayHeader	0.463 ms	0.01 Mb
displayTop	0.544 ms	0.01 Mb
hookDisplaySideBar	0.364 ms	0.03 Mb
stmegamenu	2.726 ms	0.14 Mb
__construct	0.255 ms	0.06 Mb
hookDisplayHeader	0.360 ms	0.01 Mb
hookDisplayMainMenu	1.312 ms	0.03 Mb
hookDisplayLeftColumn	0.388 ms	0.01 Mb
hookDisplaySideBar	0.411 ms	0.03 Mb
stswiper	1.890 ms	0.23 Mb
__construct	0.294 ms	0.09 Mb
hookDisplayHeader	0.259 ms	0.07 Mb
displayFullWidthTop	1.009 ms	0.05 Mb
hookDisplayCategoryHeader	0.279 ms	0.01 Mb
hookActionOutputHTMLBefore	0.049 ms	- Mb
stowlcarousel	0.831 ms	0.08 Mb
__construct	0.245 ms	0.06 Mb
hookDisplayHeader	0.333 ms	0.01 Mb
hookDisplayCategoryHeader	0.253 ms	0.01 Mb
steasycontent	2.338 ms	0.31 Mb
__construct	0.561 ms	0.17 Mb
hookDisplayHeader	0.389 ms	0.03 Mb
displayBanner	1.031 ms	0.08 Mb
displayFullWidthTop	0.017 ms	- Mb
displayFullWidthTop2	0.015 ms	- Mb
hookDisplayFooter	0.325 ms	0.02 Mb
stfeaturedslider	0.583 ms	0.08 Mb
__construct	0.245 ms	0.07 Mb
hookDisplayHeader	0.331 ms	0.01 Mb
hookDisplayFullWidthTop	0.007 ms	- Mb
stfeaturedcategories	0.476 ms	0.05 Mb
__construct	0.196 ms	0.04 Mb
hookDisplayHeader	0.280 ms	0.01 Mb
stblogeditor	0.412 ms	0.05 Mb
__construct	0.129 ms	0.03 Mb
hookDisplayHeader	0.283 ms	0.01 Mb
stblogfeaturedarticles	0.407 ms	0.13 Mb
__construct	0.110 ms	0.11 Mb
hookDisplayHeader	0.273 ms	0.01 Mb
hookDisplayFullWidthBottom	0.024 ms	- Mb
stbanner	0.878 ms	0.09 Mb
__construct	0.283 ms	0.06 Mb
hookDisplayHeader	0.250 ms	0.01 Mb
hookDisplayCategoryHeader	0.272 ms	0.01 Mb
hookActionOutputHTMLBefore	0.073 ms	- Mb
stbrandsslider	0.427 ms	0.04 Mb
__construct	0.157 ms	0.03 Mb
hookDisplayHeader	0.270 ms	0.01 Mb
stspecialslider	0.491 ms	0.04 Mb
__construct	0.187 ms	0.03 Mb
hookDisplayHeader	0.304 ms	0.01 Mb
stblogrecentarticles	0.377 ms	0.04 Mb
__construct	0.102 ms	0.03 Mb
hookDisplayHeader	0.275 ms	0.01 Mb
stnewsletter	1.474 ms	0.16 Mb
__construct	0.200 ms	0.11 Mb
hookDisplayHeader	0.307 ms	0.01 Mb
hookDisplayFooter	0.240 ms	0.02 Mb
hookDisplaySideBar	0.727 ms	0.02 Mb
stblogcomments	0.172 ms	0.04 Mb
__construct	0.122 ms	0.04 Mb
hookDisplayHeader	0.050 ms	- Mb
stblogrelatedarticles	0.371 ms	0.04 Mb
__construct	0.092 ms	0.03 Mb
hookDisplayHeader	0.279 ms	0.01 Mb
stcountdown	0.538 ms	0.04 Mb
__construct	0.197 ms	0.03 Mb
hookDisplayHeader	0.295 ms	0.02 Mb
hookActionProductSearchAfter	0.046 ms	- Mb
sthoverimage	2.786 ms	0.08 Mb
__construct	0.153 ms	0.03 Mb
hookDisplayHeader	0.077 ms	- Mb
hookActionStAssemble	0.342 ms	0.01 Mb
hookActionStAssemble	0.354 ms	0.01 Mb
hookActionStAssemble	0.323 ms	0.01 Mb
hookActionStAssemble	0.414 ms	0.01 Mb
hookActionStAssemble	0.358 ms	0.01 Mb
hookActionStAssemble	0.363 ms	0.01 Mb
hookActionStAssemble	0.402 ms	0.01 Mb
stinstagram	1.081 ms	0.17 Mb
__construct	0.427 ms	0.13 Mb
hookDisplayHeader	0.589 ms	0.04 Mb
hookActionOutputHTMLBefore	0.065 ms	- Mb
stcompare	0.747 ms	0.06 Mb
__construct	0.212 ms	0.03 Mb
hookDisplayHeader	0.466 ms	0.01 Mb
hookActionStAssemble	0.010 ms	- Mb
hookActionStAssemble	0.004 ms	- Mb
hookActionStAssemble	0.004 ms	- Mb
hookActionStAssemble	0.006 ms	- Mb
hookActionStAssemble	0.005 ms	- Mb
hookActionStAssemble	0.004 ms	- Mb
hookActionStAssemble	0.004 ms	- Mb
hookActionProductSearchAfter	0.032 ms	- Mb
stnotification	2.754 ms	0.18 Mb
__construct	0.210 ms	0.05 Mb
hookDisplayHeader	0.304 ms	0.01 Mb
displayBanner	1.578 ms	0.09 Mb
displayBeforeBodyClosingTag	0.662 ms	0.02 Mb
stpagebanner	0.929 ms	0.06 Mb
__construct	0.231 ms	0.04 Mb
hookDisplayHeader	0.274 ms	0.01 Mb
hookDisplayBreadcrumb	0.424 ms	0.01 Mb
stproductcategoriesslider	0.952 ms	0.15 Mb
__construct	0.606 ms	0.14 Mb
hookDisplayHeader	0.344 ms	0.01 Mb
hookDisplayFullWidthTop	0.002 ms	- Mb
strelatedproducts	0.489 ms	0.04 Mb
__construct	0.144 ms	0.03 Mb
hookDisplayHeader	0.345 ms	0.01 Mb
stsidebar	4.211 ms	0.30 Mb
__construct	0.332 ms	0.05 Mb
hookDisplayHeader	0.230 ms	0.01 Mb
hookDisplayMobileBarLeft	1.402 ms	0.14 Mb
hookDisplayMobileBarCenter	0.203 ms	- Mb
hookDisplayMobileBar	0.773 ms	0.03 Mb
hookDisplayMobileBarBottom	0.214 ms	- Mb
hookDisplaySideBar	0.694 ms	0.02 Mb
hookDisplayRightBar	0.363 ms	0.04 Mb
ststickers	36.029 ms	1.00 Mb
__construct	0.324 ms	0.06 Mb
hookDisplayHeader	1.048 ms	0.09 Mb
hookActionStAssemble	5.276 ms	0.14 Mb
hookActionStAssemble	3.759 ms	0.09 Mb
hookActionStAssemble	5.392 ms	0.13 Mb
hookActionStAssemble	5.270 ms	0.13 Mb
hookActionStAssemble	5.951 ms	0.15 Mb
hookActionStAssemble	4.242 ms	0.11 Mb
hookActionStAssemble	4.032 ms	0.09 Mb
hookActionProductSearchAfter	0.735 ms	0.02 Mb
stvideo	0.540 ms	0.06 Mb
__construct	0.281 ms	0.05 Mb
hookDisplayHeader	0.259 ms	0.01 Mb
stwishlist	4.230 ms	0.18 Mb
__construct	0.287 ms	0.05 Mb
hookDisplayHeader	0.431 ms	0.02 Mb
hookActionStAssemble	0.356 ms	0.01 Mb
hookActionStAssemble	0.287 ms	0.01 Mb
hookActionStAssemble	0.350 ms	0.01 Mb
hookActionStAssemble	0.271 ms	0.01 Mb
hookActionStAssemble	0.353 ms	0.01 Mb
hookActionStAssemble	0.311 ms	0.01 Mb
hookActionStAssemble	0.324 ms	0.01 Mb
hookActionProductSearchAfter	0.045 ms	- Mb
hookDisplaySideBar	0.988 ms	0.06 Mb
hookDisplayBeforeBodyClosingTag	0.227 ms	- Mb
stproductcomments	3.292 ms	0.19 Mb
__construct	0.348 ms	0.13 Mb
hookDisplayHeader	0.485 ms	0.01 Mb
hookActionStAssemble	0.434 ms	0.01 Mb
hookActionStAssemble	0.287 ms	0.01 Mb
hookActionStAssemble	0.343 ms	0.01 Mb
hookActionStAssemble	0.315 ms	0.01 Mb
hookActionStAssemble	0.330 ms	0.01 Mb
hookActionStAssemble	0.408 ms	0.01 Mb
hookActionStAssemble	0.342 ms	0.01 Mb
stproductsasattrs	0.531 ms	0.06 Mb
__construct	0.237 ms	0.04 Mb
hookDisplayHeader	0.294 ms	0.02 Mb
ets_recaptcha_free	0.220 ms	0.03 Mb
__construct	0.204 ms	0.03 Mb
hookDisplayHeader	0.016 ms	- Mb
ets_whatsapp	0.540 ms	0.04 Mb
__construct	0.180 ms	0.02 Mb
hookDisplayHeader	0.093 ms	- Mb
hookDisplayFooter	0.267 ms	0.02 Mb
ps_facetedsearch	0.824 ms	0.16 Mb
__construct	0.353 ms	0.04 Mb
hookProductSearchProvider	0.256 ms	- Mb
hookDisplayLeftColumn	0.215 ms	0.13 Mb
ps_categorytree	3.384 ms	0.16 Mb
__construct	0.095 ms	0.02 Mb
displayLeftColumn	3.289 ms	0.15 Mb
statsdata	0.874 ms	0.08 Mb
__construct	0.083 ms	0.02 Mb
hookDisplayBeforeBodyClosingTag	0.791 ms	0.06 Mb
47 module(s)	118.401 ms	6.62 Mb

21 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, pl.name FROM mmag_product p LEFT JOIN mmag_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mmag_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN mmag_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 mmag_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN mmag_product_lang pl ON (p.id_product = pl.id_product AND pl.id_shop = XX AND pl.id_lang = XX) INNER JOIN mmag_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = XX AND ps.active = TRUE) INNER JOIN mmag_category_product cp ON (p.id_product = cp.id_product) INNER JOIN mmag_category c ON (cp.id_category = c.id_category AND c.active=XX) LEFT JOIN mmag_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN mmag_specific_price sp ON ( sp.id_product = p.id_product AND sp.id_shop IN (XX, XX) AND sp.id_currency IN (XX, XX) AND sp.id_country IN (XX, XX) AND sp.id_group IN (XX, XX) AND sp.from_quantity = XX AND sp.reduction > XX AND sp.id_customer = XX AND sp.id_cart = XX AND (sp.from = 'XX-XX-XX XX:XX:XX' OR 'XX-XX-XX XX:XX:XX' >= sp.from) AND (sp.to = 'XX-XX-XX XX:XX:XX' OR 'XX-XX-XX XX:XX:XX' <= sp.to) ) LEFT JOIN mmag_feature_product fp_XX ON (p.id_product = fp_XX.id_product) LEFT JOIN mmag_feature_product fp_XX ON (p.id_product = fp_XX.id_product) WHERE ((sp.reduction>XX)) AND ((fp_XX.id_feature_value IN (XX, XX, XX, XX, XX, XX, XX, XX, XX, XX, XX, XX, XX, XX, XX))) AND ((fp_XX.id_feature_value IN (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 mmag_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN mmag_specific_price sp_XX ON ( sp_XX.id_product = p.id_product AND sp_XX.id_shop IN (XX, XX) AND sp_XX.id_currency IN (XX, XX) AND sp_XX.id_country IN (XX, XX) AND sp_XX.id_group IN (XX, XX) AND sp_XX.from_quantity = XX AND sp_XX.reduction > XX AND sp_XX.id_customer = XX AND sp_XX.id_cart = XX AND (sp_XX.from = 'XX-XX-XX XX:XX:XX' OR 'XX-XX-XX XX:XX:XX' >= sp_XX.from) AND (sp_XX.to = 'XX-XX-XX XX:XX:XX' OR 'XX-XX-XX XX:XX:XX' <= sp_XX.to) ) LEFT JOIN mmag_feature_product fp_XX ON (p.id_product = fp_XX.id_product) LEFT JOIN mmag_feature_product fp_XX ON (p.id_product = fp_XX.id_product) WHERE ((fp.id_feature=XX)) AND ((sp_XX.reduction>XX)) AND ((fp_XX.id_feature_value IN (XX, XX, XX, XX, XX, XX, XX, XX, XX, XX, XX, XX, XX, XX, XX))) AND ((fp_XX.id_feature_value IN (XX, XX, XX))) GROUP BY fp.id_feature_value
18 queries	SELECT c.`nleft`, c.`nright` FROM `mmag_category` c LEFT JOIN `mmag_category_lang` cl ON (c.`id_category` = cl.`id_category` AND `id_lang` = XX AND cl.id_shop = XX ) WHERE c.`id_category` = XX LIMIT XX
18 queries	SELECT c.`nleft`, c.`nright` FROM `mmag_category` c WHERE c.`id_category` = XX LIMIT XX
18 queries	SELECT c., cl. FROM `mmag_category` c LEFT JOIN `mmag_category_lang` cl ON (c.`id_category` = cl.`id_category` AND `id_lang` = XX AND cl.id_shop = XX ) WHERE c.`nleft` <= XX AND c.`nright` >= XX AND c.`nleft` >= XX AND c.`nright` <= XX ORDER BY `nleft` DESC
16 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 `mmag_feature_value` v LEFT JOIN `mmag_feature_value_lang` vl ON (v.`id_feature_value` = vl.`id_feature_value` AND vl.`id_lang` = XX) LEFT JOIN `mmag_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
14 queries	SELECT image_shop.`cover`, i.`id_image`, il.`legend`, i.`position` FROM `mmag_image` i INNER JOIN mmag_image_shop image_shop ON (image_shop.id_image = i.id_image AND image_shop.id_shop = XX) LEFT JOIN `mmag_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = XX) WHERE i.`id_product` = XX ORDER BY `position`
13 queries	SELECT `id_module` FROM `mmag_module_shop` WHERE `id_module` = XX AND `id_shop` = XX LIMIT XX
9 queries	SELECT * FROM `mmag_category` a LEFT JOIN `mmag_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = XX LEFT JOIN `mmag_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
8 queries	SELECT XX FROM `mmag_specific_price` WHERE id_product = XX LIMIT XX
7 queries	SELECT m.`id_module`, m.`name`, ms.`id_module`as `mshop` FROM `mmag_module` m LEFT JOIN `mmag_module_shop` ms ON m.`id_module` = ms.`id_module` AND ms.`id_shop` = XX
7 queries	SELECT * FROM `mmag_category` a LEFT JOIN `mmag_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = XX WHERE (a.`id_category` = XX) LIMIT XX
7 queries	SELECT * FROM `mmag_category_lang` WHERE `id_category` = XX AND `id_shop` = XX
7 queries	SELECT image_shop.`id_image` FROM `mmag_image` i INNER JOIN mmag_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
7 queries	SELECT name FROM mmag_category_lang WHERE id_shop = XX AND id_lang = XX AND id_category = XX LIMIT XX
7 queries	SELECT * FROM `mmag_product` a LEFT JOIN `mmag_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = XX LEFT JOIN `mmag_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
7 queries	SELECT `priority`, `id_specific_price_priority` FROM `mmag_specific_price_priority` WHERE `id_product` = XX ORDER BY `id_specific_price_priority` DESC LIMIT XX
7 queries	SELECT *, ( IF (`id_shop` = XX, XX, XX) + IF (`id_country` = XX, XX, XX) + IF (`id_currency` = XX, XX, XX) + IF (`id_group` = XX, XX, XX) + IF (`id_customer` = XX, XX, XX)) AS `score` FROM `mmag_specific_price` WHERE `id_shop` IN (XX, XX) AND `id_currency` IN (XX, XX) AND `id_country` IN (XX, XX) AND `id_group` IN (XX, XX) AND `id_product` = XX AND `id_customer` = XX AND `id_product_attribute` = XX AND `id_cart` = XX AND (`from` = 'XX-XX-XX XX:XX:XX' OR 'XX-XX-XX XX:XX:XX' >= `from`) AND (`to` = 'XX-XX-XX XX:XX:XX' OR 'XX-XX-XX XX:XX:XX' <= `to`) AND IF(`from_quantity` > XX, `from_quantity`, XX) <= XX ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT XX
7 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 `mmag_product` p INNER JOIN `mmag_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = XX) LEFT JOIN `mmag_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)
7 queries	SELECT `id_tax_rules_group` FROM `mmag_product_shop` WHERE `id_product` = XX AND id_shop=XX LIMIT XX
7 queries	SELECT `reduction` FROM `mmag_product_group_reduction_cache` WHERE `id_product` = XX AND `id_group` = XX LIMIT XX
7 queries	SELECT COUNT(*) FROM `mmag_pack` WHERE id_product_pack = XX LIMIT XX
7 queries	SELECT product_type FROM `mmag_product` WHERE id_product = XX LIMIT XX
7 queries	SELECT SUM(quantity) FROM `mmag_stock_available` WHERE (id_product = XX) AND (id_product_attribute = XX) AND (id_shop = XX) AND (id_shop_group = XX) LIMIT XX
7 queries	SELECT COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), XX) as deep_quantity, COALESCE(SUM(first_level_quantity), XX) as quantity FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, XX as pack_quantity FROM `mmag_cart_product` cp WHERE cp.`id_product_attribute` = XX AND cp.`id_cart` = XX AND cp.`id_product` = XX UNION SELECT XX as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity FROM `mmag_cart_product` cp JOIN `mmag_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `mmag_product` pr ON p.`id_product_pack` = pr.`id_product` WHERE cp.`id_product_attribute` = XX AND cp.`id_cart` = XX AND p.`id_product_item` = XX AND (pr.`pack_stock_type` IN (XX,XX) OR ( pr.`pack_stock_type` = XX AND XX = XX ))) as q LIMIT XX
7 queries	SELECT name, value, pf.id_feature, f.position, fvl.id_feature_value FROM mmag_feature_product pf LEFT JOIN mmag_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = XX) LEFT JOIN mmag_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = XX) LEFT JOIN mmag_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = XX) INNER JOIN mmag_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
7 queries	SELECT * FROM `mmag_image` i LEFT JOIN `mmag_image_lang` il ON (i.`id_image` = il.`id_image`) WHERE i.`id_product` = XX AND il.`id_lang` = XX ORDER BY i.`position` ASC
7 queries	SELECT * FROM `mmag_product` a LEFT JOIN `mmag_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = XX WHERE (a.`id_product` = XX) LIMIT XX
7 queries	SELECT * FROM `mmag_product_lang` WHERE `id_product` = XX AND `id_shop` = XX
7 queries	SELECT `id_category` FROM `mmag_category_product` WHERE `id_product` = XX
7 queries	SELECT count(XX) FROM `mmag_st_wishlist_product` whp LEFT JOIN `mmag_st_wishlist` wh ON (wh.`id_st_wishlist`=whp.`id_st_wishlist`) WHERE whp.`id_product` = XX AND wh.`id_customer`=XX AND wh.`id_shop`= XX LIMIT XX
7 queries	SELECT COUNT(XX) as total, (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS avg, MIN(pc.`grade`) AS min, MAX(pc.`grade`) AS max FROM `mmag_st_product_comment` pc WHERE pc.`id_product` = XX AND pc.`id_parent` = XX AND pc.`id_shop`=XX AND pc.`validate` = XX LIMIT XX
7 queries	SELECT `id_product_attribute` FROM `mmag_product_attribute` WHERE `id_product` = XX
5 queries	SELECT DISTINCT a.`id_attribute`, a.`color`, al.`name`, agl.`id_attribute_group`, IF(lialv.`url_name` IS NULL OR lialv.`url_name` = "", NULL, lialv.`url_name`) AS url_name, IF(lialv.`meta_title` IS NULL OR lialv.`meta_title` = "", NULL, lialv.`meta_title`) AS meta_title FROM `mmag_attribute_group` ag INNER JOIN `mmag_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = XX) INNER JOIN `mmag_attribute` a ON a.`id_attribute_group` = ag.`id_attribute_group` INNER JOIN `mmag_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = XX) INNER JOIN mmag_attribute_group_shop attribute_group_shop ON (attribute_group_shop.id_attribute_group = ag.id_attribute_group AND attribute_group_shop.id_shop = XX) INNER JOIN mmag_attribute_shop attribute_shop ON (attribute_shop.id_attribute = a.id_attribute AND attribute_shop.id_shop = XX) LEFT JOIN `mmag_layered_indexable_attribute_lang_value` lialv ON (a.`id_attribute` = lialv.`id_attribute` AND lialv.`id_lang` = XX) WHERE ag.id_attribute_group = XX ORDER BY agl.`name` ASC, a.`position` ASC
5 queries	SELECT pac.id_attribute, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, pl.name FROM mmag_product p LEFT JOIN mmag_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mmag_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN mmag_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 mmag_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN mmag_product_lang pl ON (p.id_product = pl.id_product AND pl.id_shop = XX AND pl.id_lang = XX) INNER JOIN mmag_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = XX AND ps.active = TRUE) INNER JOIN mmag_category_product cp ON (p.id_product = cp.id_product) INNER JOIN mmag_category c ON (cp.id_category = c.id_category AND c.active=XX) LEFT JOIN mmag_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN mmag_specific_price sp ON ( sp.id_product = p.id_product AND sp.id_shop IN (XX, XX) AND sp.id_currency IN (XX, XX) AND sp.id_country IN (XX, XX) AND sp.id_group IN (XX, XX) AND sp.from_quantity = XX AND sp.reduction > XX AND sp.id_customer = XX AND sp.id_cart = XX AND (sp.from = 'XX-XX-XX XX:XX:XX' OR 'XX-XX-XX XX:XX:XX' >= sp.from) AND (sp.to = 'XX-XX-XX XX:XX:XX' OR 'XX-XX-XX XX:XX:XX' <= sp.to) ) LEFT JOIN mmag_feature_product fp_XX ON (p.id_product = fp_XX.id_product) LEFT JOIN mmag_feature_product fp_XX ON (p.id_product = fp_XX.id_product) WHERE ((sp.reduction>XX)) AND ((fp_XX.id_feature_value IN (XX, XX, XX, XX, XX, XX, XX, XX, XX, XX, XX, XX, XX, XX, XX))) AND ((fp_XX.id_feature_value IN (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 LEFT JOIN mmag_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mmag_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) INNER JOIN mmag_attribute a ON (a.id_attribute = pac.id_attribute) LEFT JOIN mmag_specific_price sp_XX ON ( sp_XX.id_product = p.id_product AND sp_XX.id_shop IN (XX, XX) AND sp_XX.id_currency IN (XX, XX) AND sp_XX.id_country IN (XX, XX) AND sp_XX.id_group IN (XX, XX) AND sp_XX.from_quantity = XX AND sp_XX.reduction > XX AND sp_XX.id_customer = XX AND sp_XX.id_cart = XX AND (sp_XX.from = 'XX-XX-XX XX:XX:XX' OR 'XX-XX-XX XX:XX:XX' >= sp_XX.from) AND (sp_XX.to = 'XX-XX-XX XX:XX:XX' OR 'XX-XX-XX XX:XX:XX' <= sp_XX.to) ) LEFT JOIN mmag_feature_product fp_XX ON (p.id_product = fp_XX.id_product) LEFT JOIN mmag_feature_product fp_XX ON (p.id_product = fp_XX.id_product) WHERE ((a.id_attribute_group=XX)) AND ((sp_XX.reduction>XX)) AND ((fp_XX.id_feature_value IN (XX, XX, XX, XX, XX, XX, XX, XX, XX, XX, XX, XX, XX, XX, XX))) AND ((fp_XX.id_feature_value IN (XX, XX, XX))) GROUP BY pac.id_attribute
4 queries	SELECT cc.name FROM mmag_cookiesplus_cookie cc LEFT JOIN mmag_cookiesplus_cookie_lang ccl on cc.`id_cookiesplus_cookie` = ccl.`id_cookiesplus_cookie` WHERE `id_cookiesplus_finality` = XX AND ccl.`id_lang` = XX AND cc.`active` = XX AND cc.`id_shop` = XX ORDER BY cc.`name`;
4 queries	SELECT cl.`link_rewrite` FROM `mmag_category_lang` cl WHERE `id_lang` = XX AND cl.id_shop = XX AND cl.`id_category` = XX LIMIT XX
4 queries	SELECT id_st_sticker FROM `mmag_st_sticker_map` WHERE active = XX AND (location = XX OR (location = XX AND (id_category = XX OR id_category IN(XX,XX,XX,XX,XX,XX,XX))) OR (location = XX AND (id_products LIKE "%,XX,%")))
4 queries	SELECT * FROM mmag_cookiesplus_cookie cc LEFT JOIN mmag_cookiesplus_cookie_lang ccl on cc.`id_cookiesplus_cookie` = ccl.`id_cookiesplus_cookie` WHERE `id_cookiesplus_finality` = XX AND ccl.`id_lang` = XX AND cc.`active` = XX AND cc.`id_shop` = XX ORDER BY cc.`name`;
3 queries	SELECT tr.* FROM `mmag_tax_rule` tr JOIN `mmag_tax_rules_group` trg ON (tr.`id_tax_rules_group` = trg.`id_tax_rules_group`) WHERE trg.`active` = XX AND tr.`id_country` = XX AND tr.`id_tax_rules_group` = XX AND tr.`id_state` IN (XX, XX) AND ('XX' BETWEEN tr.`zipcode_from` AND tr.`zipcode_to` OR (tr.`zipcode_to` = XX AND tr.`zipcode_from` IN(XX, 'XX'))) ORDER BY tr.`zipcode_from` DESC, tr.`zipcode_to` DESC, tr.`id_state` DESC, tr.`id_country` DESC
2 queries	SELECT `id_lang` FROM `mmag_lang` WHERE `locale` = 'ro-ro' OR `language_code` = 'ro-ro' LIMIT XX
2 queries	SELECT `id_category` FROM `mmag_category_shop` WHERE `id_category` = XX AND `id_shop` = XX LIMIT XX
2 queries	SELECT s., sl. ,IF(image_multi_lang<>"" && !ISNULL(image_multi_lang), image_multi_lang, image_lang_default) AS image_multi_lang FROM `mmag_st_sticker` s LEFT JOIN `mmag_st_sticker_lang` sl ON (s.`id_st_sticker` = sl.`id_st_sticker` AND sl.`id_lang` = XX) LEFT JOIN `mmag_st_sticker_shop` ss ON (s.`id_st_sticker` = ss.`id_st_sticker`) LEFT JOIN `mmag_st_sticker_group` sg ON (s.`id_st_sticker` = sg.`id_st_sticker`) WHERE ss.`id_shop` = XX AND s.`active`=XX AND s.`type` IN (XX,XX,XX,XX,XX,XX,XX) AND sg.`id_group` IN (XX) GROUP BY s.`id_st_sticker` ORDER BY s.`position` ASC, s.`id_st_sticker`
2 queries	SELECT id_st_sticker FROM `mmag_st_sticker_map` WHERE active = XX AND (location = XX OR (location = XX AND (id_category = XX OR id_category IN(XX,XX,XX,XX,XX,XX,XX,XX))) OR (location = XX AND (id_products LIKE "%,XX,%")))
2 queries	SELECT XX FROM `mmag_cart_rule` WHERE ((date_to >= "XX-XX-XX XX:XX:XX" AND date_to <= "XX-XX-XX XX:XX:XX") OR (date_from >= "XX-XX-XX XX:XX:XX" AND date_from <= "XX-XX-XX XX:XX:XX") OR (date_from < "XX-XX-XX XX:XX:XX" AND date_to > "XX-XX-XX XX:XX:XX")) AND `id_customer` IN (XX,XX) LIMIT XX
2 queries	SELECT snl., snll. FROM `mmag_st_notification` snl INNER JOIN mmag_st_notification_shop st_notification_shop ON (st_notification_shop.id_st_notification = snl.id_st_notification AND st_notification_shop.id_shop = XX) LEFT JOIN `mmag_st_notification_lang` snll ON (snl.`id_st_notification` = snll.`id_st_notification`) WHERE snl.`active`=XX AND snll.`id_lang` = XX ORDER BY snl.`position`
2 queries	SELECT snl., snll. FROM `mmag_st_sidebar` snl INNER JOIN mmag_st_sidebar_shop st_sidebar_shop ON (st_sidebar_shop.id_st_sidebar = snl.id_st_sidebar AND st_sidebar_shop.id_shop = XX) LEFT JOIN `mmag_st_sidebar_lang` snll ON (snl.`id_st_sidebar` = snll.`id_st_sidebar`) WHERE snll.`id_lang` = XX AND snl.`active`=XX ORDER BY snl.`location`, snl.`position`

Name	Instances	Source
Category	63	/controllers/front/listing/CategoryController.php:78 (__construct) [id: 10] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 17] /override/classes/Link.php:63 (__construct) [id: 17] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 18] /override/classes/Link.php:63 (__construct) [id: 18] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 19] /override/classes/Link.php:63 (__construct) [id: 19] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 21] /override/classes/Link.php:63 (__construct) [id: 21] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 22] /override/classes/Link.php:63 (__construct) [id: 22] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 23] /override/classes/Link.php:63 (__construct) [id: 23] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 27] /override/classes/Link.php:63 (__construct) [id: 27] /classes/Meta.php:380 (__construct) [id: 10] /classes/PrestaShopCollection.php:385 (hydrateCollection) [id: ] /classes/PrestaShopCollection.php:385 (hydrateCollection) [id: ] /modules/ps_facetedsearch/src/Product/Search.php:364 (__construct) [id: 10] /modules/ps_facetedsearch/src/Filters/Block.php:157 (__construct) [id: 10] /modules/ststickers/classes/StStickersMapClass.php:159 (__construct) [id: 10] /modules/ststickers/classes/StStickersMapClass.php:168 (getParentsCategories) [id: 2] /modules/ststickers/classes/StStickersMapClass.php:159 (__construct) [id: 19] /modules/ststickers/classes/StStickersMapClass.php:168 (getParentsCategories) [id: 2] /modules/ststickers/classes/StStickersMapClass.php:159 (__construct) [id: 10] /modules/ststickers/classes/StStickersMapClass.php:168 (getParentsCategories) [id: 2] /modules/ststickers/classes/StStickersMapClass.php:159 (__construct) [id: 19] /modules/ststickers/classes/StStickersMapClass.php:168 (getParentsCategories) [id: 2] /modules/ststickers/classes/StStickersMapClass.php:159 (__construct) [id: 10] /modules/ststickers/classes/StStickersMapClass.php:168 (getParentsCategories) [id: 2] /modules/ststickers/classes/StStickersMapClass.php:159 (__construct) [id: 16] /modules/ststickers/classes/StStickersMapClass.php:168 (getParentsCategories) [id: 2] /modules/ststickers/classes/StStickersMapClass.php:159 (__construct) [id: 19] /modules/ststickers/classes/StStickersMapClass.php:168 (getParentsCategories) [id: 2] /modules/ststickers/classes/StStickersMapClass.php:159 (__construct) [id: 10] /modules/ststickers/classes/StStickersMapClass.php:168 (getParentsCategories) [id: 2] /modules/ststickers/classes/StStickersMapClass.php:159 (__construct) [id: 19] /modules/ststickers/classes/StStickersMapClass.php:168 (getParentsCategories) [id: 2] /modules/ststickers/classes/StStickersMapClass.php:159 (__construct) [id: 24] /modules/ststickers/classes/StStickersMapClass.php:168 (getParentsCategories) [id: 2] /modules/ststickers/classes/StStickersMapClass.php:159 (__construct) [id: 10] /modules/ststickers/classes/StStickersMapClass.php:168 (getParentsCategories) [id: 2] /modules/ststickers/classes/StStickersMapClass.php:159 (__construct) [id: 21] /modules/ststickers/classes/StStickersMapClass.php:168 (getParentsCategories) [id: 2] /modules/ststickers/classes/StStickersMapClass.php:159 (__construct) [id: 26] /modules/ststickers/classes/StStickersMapClass.php:168 (getParentsCategories) [id: 2] /modules/ststickers/classes/StStickersMapClass.php:159 (__construct) [id: 10] /modules/ststickers/classes/StStickersMapClass.php:168 (getParentsCategories) [id: 2] /modules/ststickers/classes/StStickersMapClass.php:159 (__construct) [id: 17] /modules/ststickers/classes/StStickersMapClass.php:168 (getParentsCategories) [id: 2] /modules/ststickers/classes/StStickersMapClass.php:159 (__construct) [id: 10] /modules/ststickers/classes/StStickersMapClass.php:168 (getParentsCategories) [id: 2] /modules/ststickers/classes/StStickersMapClass.php:159 (__construct) [id: 17] /modules/ststickers/classes/StStickersMapClass.php:168 (getParentsCategories) [id: 2] /modules/ps_categorytree/ps_categorytree.php:364 (getParentsCategories) [id: 2] /override/classes/Link.php:63 (__construct) [id: 17] /override/classes/Link.php:63 (__construct) [id: 18] /override/classes/Link.php:63 (__construct) [id: 19] /override/classes/Link.php:63 (__construct) [id: 21] /override/classes/Link.php:63 (__construct) [id: 22] /override/classes/Link.php:63 (__construct) [id: 23] /override/classes/Link.php:63 (__construct) [id: 27] /override/classes/Link.php:63 (__construct) [id: 10]
Product	28	/classes/Link.php:113 (__construct) [id: 82] /classes/Link.php:113 (__construct) [id: 81] /classes/Link.php:113 (__construct) [id: 70] /classes/Link.php:113 (__construct) [id: 85] /classes/Link.php:113 (__construct) [id: 95] /classes/Link.php:113 (__construct) [id: 50] /classes/Link.php:113 (__construct) [id: 47] /modules/ststickers/classes/StStickersMapClass.php:152 (__construct) [id: 82] /modules/ststickers/classes/StStickersMapClass.php:152 (__construct) [id: 81] /modules/ststickers/classes/StStickersMapClass.php:152 (__construct) [id: 70] /modules/ststickers/classes/StStickersMapClass.php:152 (__construct) [id: 85] /modules/ststickers/classes/StStickersMapClass.php:152 (__construct) [id: 95] /modules/ststickers/classes/StStickersMapClass.php:152 (__construct) [id: 50] /modules/ststickers/classes/StStickersMapClass.php:152 (__construct) [id: 47] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 82] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 81] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 70] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 85] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 95] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 50] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 47] /classes/Link.php:113 (__construct) [id: 82] /classes/Link.php:113 (__construct) [id: 81] /classes/Link.php:113 (__construct) [id: 70] /classes/Link.php:113 (__construct) [id: 85] /classes/Link.php:113 (__construct) [id: 95] /classes/Link.php:113 (__construct) [id: 50] /classes/Link.php:113 (__construct) [id: 47]
Address	4	/classes/shop/Shop.php:486 (__construct) [id: ] /classes/Product.php:3694 (initialize) [id: ] /classes/Product.php:3804 (__construct) [id: ] /classes/Product.php:5964 (__construct) [id: ]
Country	4	/config/config.inc.php:146 (__construct) [id: 36] /classes/AddressFormat.php:404 (__construct) [id: 36] /classes/controller/FrontController.php:1779 (__construct) [id: 36] /modules/ets_whatsapp/ets_whatsapp.php:466 (__construct) [id: 36]
CMS	2	/classes/Link.php:555 (__construct) [id: 11] /classes/Link.php:555 (__construct) [id: 11]
Language	2	/config/config.inc.php:211 (__construct) [id: 1] /classes/Tools.php:560 (__construct) [id: 1]
Tax	2	/classes/tax/TaxRulesTaxManager.php:116 (__construct) [id: 1] /classes/tax/TaxRulesTaxManager.php:116 (__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:467 (__construct) [id: ] /classes/controller/FrontController.php:541 (__construct) [id: ]
State	2	/classes/AddressFormat.php:404 (__construct) [id: 353] /classes/controller/FrontController.php:1778 (__construct) [id: 353]
ConnectionsSource	1	/modules/statsdata/statsdata.php:119 (logHttpReferer) [id: ]
Shop	1	/config/config.inc.php:117 (initialize) [id: 1]
AddressFormat	1	/classes/controller/FrontController.php:1773 (generateAddress) [id: ]
Risk	1	/classes/controller/FrontController.php:1705 (__construct) [id: ]
Group	1	/classes/Cart.php:249 (getCurrent) [id: 1]
Customer	1	/config/config.inc.php:264 (__construct) [id: ]
ShopGroup	1	/classes/shop/Shop.php:561 (__construct) [id: 1]
Gender	1	/classes/controller/FrontController.php:1702 (__construct) [id: 0]

#	Query	Time (ms)	Rows	Filesort	Group By	Location
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 `mmag_configuration` c LEFT JOIN `mmag_configuration_lang` cl ON (c.`id_configuration` = cl.`id_configuration`)	18.247 ms	3076			/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)
152	REPLACE INTO mmag_layered_filter_block (hash, data) VALUES ("d215aa51e886358afab93715d1e8fc0e", "a:1:{s:7:\"filters\";a:21:{i:0;a:12:{s:9:\"type_lite\";s:5:\"price\";s:4:\"type\";s:5:\"price\";s:6:\"id_key\";i:0;s:4:\"name\";s:4:\"Pret\";s:3:\"max\";d:899;s:3:\"min\";d:35;s:4:\"unit\";s:3:\"lei\";s:14:\"specifications\";a:11:{s:6:\"symbol\";a:11:{i:0;s:1:\",\";i:1;s:1:\".\";i:2;s:1:\";\";i:3;s:1:\"%\";i:4;s:1:\"-\";i:5;s:1:\"+\";i:6;s:1:\"E\";i:7;s:2:\"×\";i:8;s:3:\"‰\";i:9;s:3:\"∞\";i:10;s:3:\"NaN\";}s:12:\"currencyCode\";s:3:\"RON\";s:14:\"currencySymbol\";s:3:\"lei\";s:13:\"numberSymbols\";a:11:{i:0;s:1:\",\";i:1;s:1:\".\";i:2;s:1:\";\";i:3;s:1:\"%\";i:4;s:1:\"-\";i:5;s:1:\"+\";i:6;s:1:\"E\";i:7;s:2:\"×\";i:8;s:3:\"‰\";i:9;s:3:\"∞\";i:10;s:3:\"NaN\";}s:15:\"positivePattern\";s:12:\"#,##0.00 ¤\";s:15:\"negativePattern\";s:13:\"-#,##0.00 ¤\";s:17:\"maxFractionDigits\";i:2;s:17:\"minFractionDigits\";i:2;s:12:\"groupingUsed\";b:1;s:16:\"primaryGroupSize\";i:3;s:18:\"secondaryGroupSize\";i:3;}s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";i:3;s:3:\"nbr\";i:7;s:5:\"value\";N;}i:1;a:7:{s:9:\"type_lite\";s:12:\"availability\";s:4:\"type\";s:12:\"availability\";s:6:\"id_key\";i:0;s:4:\"name\";s:15:\"Disponibilitate\";s:6:\"values\";a:2:{i:2;a:2:{s:4:\"name\";s:7:\"In stoc\";s:3:\"nbr\";i:7;}i:0;a:2:{s:4:\"name\";s:12:\"Indisponibil\";s:3:\"nbr\";i:0;}}s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";s:1:\"0\";}i:2;a:7:{s:9:\"type_lite\";s:6:\"extras\";s:4:\"type\";s:6:\"extras\";s:6:\"id_key\";i:0;s:4:\"name\";s:8:\"Selectii\";s:6:\"values\";a:3:{s:4:\"sale\";a:2:{s:4:\"name\";s:11:\"La reducere\";s:3:\"nbr\";i:1;}s:3:\"new\";a:2:{s:4:\"name\";s:10:\"Produs nou\";s:3:\"nbr\";i:0;}s:8:\"discount\";a:3:{s:4:\"name\";s:5:\"Redus\";s:3:\"nbr\";i:7;s:7:\"checked\";b:1;}}s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";s:1:\"0\";}i:3;a:7:{s:9:\"type_lite\";s:8:\"category\";s:4:\"type\";s:8:\"category\";s:6:\"id_key\";i:0;s:4:\"name\";s:9:\"Categorii\";s:6:\"values\";a:3:{i:17;a:2:{s:4:\"name\";s:6:\"Veioze\";s:3:\"nbr\";s:1:\"2\";}i:19;a:2:{s:4:\"name\";s:6:\"Lustre\";s:3:\"nbr\";s:1:\"4\";}i:21;a:2:{s:4:\"name\";s:8:\"Exterior\";s:3:\"nbr\";s:1:\"1\";}}s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";s:1:\"0\";}i:4;a:9:{s:9:\"type_lite\";s:10:\"id_feature\";s:4:\"type\";s:10:\"id_feature\";s:6:\"id_key\";s:1:\"1\";s:6:\"values\";a:5:{i:695;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:19:\"Metal auriu satinat\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:711;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:12:\"Policarbonat\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:702;a:4:{s:3:\"nbr\";s:1:\"2\";s:4:\"name\";s:7:\"Silicon\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:707;a:4:{s:3:\"nbr\";s:1:\"2\";s:4:\"name\";s:11:\"Sticla mata\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:697;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:6:\"Textil\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}}s:4:\"name\";s:17:\"Compozitie abajur\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";s:1:\"0\";}i:5;a:9:{s:9:\"type_lite\";s:10:\"id_feature\";s:4:\"type\";s:10:\"id_feature\";s:6:\"id_key\";s:1:\"2\";s:6:\"values\";a:3:{i:784;a:4:{s:3:\"nbr\";s:1:\"2\";s:4:\"name\";s:6:\"Clasic\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:783;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:6:\"Modern\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:786;a:4:{s:3:\"nbr\";s:1:\"4\";s:4:\"name\";s:19:\"Modern, contemporan\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}}s:4:\"name\";s:4:\"Stil\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";s:1:\"0\";}i:6;a:7:{s:9:\"type_lite\";s:12:\"manufacturer\";s:4:\"type\";s:12:\"manufacturer\";s:6:\"id_key\";i:0;s:4:\"name\";s:5:\"Marca\";s:6:\"values\";a:1:{i:15;a:2:{s:4:\"name\";s:9:\"Faneurope\";s:3:\"nbr\";s:1:\"1\";}}s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";s:1:\"0\";}i:7;a:7:{s:9:\"type_lite\";s:9:\"condition\";s:4:\"type\";s:9:\"condition\";s:6:\"id_key\";i:0;s:4:\"name\";s:5:\"Stare\";s:6:\"values\";a:3:{s:3:\"new\";a:2:{s:4:\"name\";s:3:\"Nou\";s:3:\"nbr\";s:1:\"7\";}s:4:\"used\";a:2:{s:4:\"name\";s:7:\"Folosit\";s:3:\"nbr\";i:0;}s:11:\"refurbished\";a:2:{s:4:\"name\";s:13:\"Reconditionat\";s:3:\"nbr\";i:0;}}s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";s:1:\"0\";}i:8;a:12:{s:9:\"type_lite\";s:6:\"weight\";s:4:\"type\";s:6:\"weight\";s:6:\"id_key\";i:0;s:4:\"name\";s:8:\"Greutate\";s:3:\"max\";d:5;s:3:\"min\";d:0.5;s:4:\"unit\";s:2:\"kg\";s:14:\"specifications\";N;s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";i:3;s:5:\"value\";N;s:3:\"nbr\";i:7;}i:9;a:9:{s:9:\"type_lite\";s:10:\"id_feature\";s:4:\"type\";s:10:\"id_feature\";s:6:\"id_key\";s:1:\"4\";s:6:\"values\";a:3:{i:774;a:5:{s:3:\"nbr\";s:1:\"6\";s:4:\"name\";s:1:\"1\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:7:\"checked\";b:1;}i:775;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:1:\"2\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:776;a:5:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:1:\"3\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:7:\"checked\";b:1;}}s:4:\"name\";s:12:\"Numar becuri\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";s:1:\"0\";}i:10;a:9:{s:9:\"type_lite\";s:10:\"id_feature\";s:4:\"type\";s:10:\"id_feature\";s:6:\"id_key\";s:1:\"5\";s:6:\"values\";a:26:{i:812;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:14:\"16 cm inaltime\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:862;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:16:\"17.5 cm inaltime\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:815;a:5:{s:3:\"nbr\";s:1:\"4\";s:4:\"name\";s:14:\"20 cm inaltime\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:7:\"checked\";b:1;}i:948;a:4:{s:3:\"nbr\";s:1:\"3\";s:4:\"name\";s:14:\"23 cm inaltime\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:816;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:14:\"25 cm inaltime\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:951;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:16:\"26.5 cm inaltime\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:819;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:15:\"29 cm inaltime \";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:820;a:4:{s:3:\"nbr\";s:1:\"3\";s:4:\"name\";s:14:\"30 cm inaltime\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:1047;a:4:{s:3:\"nbr\";s:1:\"2\";s:4:\"name\";s:14:\"32 cm inaltime\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:822;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:14:\"35 cm inaltime\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:823;a:4:{s:3:\"nbr\";s:1:\"2\";s:4:\"name\";s:14:\"37 cm inaltime\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:824;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:17:\"37.9 cm inaltime \";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:825;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:14:\"38 cm inaltime\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:826;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:14:\"42 cm inaltime\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:827;a:4:{s:3:\"nbr\";s:1:\"3\";s:4:\"name\";s:14:\"44 cm inaltime\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:828;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:14:\"46 cm inaltime\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:950;a:4:{s:3:\"nbr\";s:1:\"2\";s:4:\"name\";s:14:\"50 cm inaltime\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:830;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:14:\"59 cm inaltime\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:1133;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:14:\"71 cm inaltime\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:832;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:15:\"84 cm inaltime \";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:833;a:5:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:14:\"92 cm inaltime\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:7:\"checked\";b:1;}i:808;a:5:{s:3:\"nbr\";s:1:\"2\";s:4:\"name\";s:15:\"100 cm inaltime\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:7:\"checked\";b:1;}i:809;a:4:{s:3:\"nbr\";s:1:\"8\";s:4:\"name\";s:15:\"120 cm inaltime\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:811;a:4:{s:3:\"nbr\";s:1:\"5\";s:4:\"name\";s:15:\"150 cm inaltime\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:813;a:4:{s:3:\"nbr\";s:1:\"2\";s:4:\"name\";s:15:\"165 cm inaltime\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:814;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:16:\"190 cm inaltime \";s:8:\"url_name\";N;s:10:\"meta_title\";N;}}s:4:\"name\";s:8:\"Inaltime\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";s:1:\"0\";}i:11;a:9:{s:9:\"type_lite\";s:10:\"id_feature\";s:4:\"type\";s:10:\"id_feature\";s:6:\"id_key\";s:1:\"7\";s:6:\"values\";a:2:{i:743;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:8:\"Exterior\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:741;a:4:{s:3:\"nbr\";s:1:\"5\";s:4:\"name\";s:8:\"Interior\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}}s:4:\"name\";s:20:\"Domeniu de utilizare\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";s:1:\"0\";}i:12;a:9:{s:9:\"type_lite\";s:10:\"id_feature\";s:4:\"type\";s:10:\"id_feature\";s:6:\"id_key\";s:1:\"9\";s:6:\"values\";a:3:{i:791;a:4:{s:3:\"nbr\";s:1:\"3\";s:4:\"name\";s:3:\"E14\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:793;a:4:{s:3:\"nbr\";s:1:\"3\";s:4:\"name\";s:3:\"E27\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:795;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:3:\"LED\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}}s:4:\"name\";s:7:\"Tip bec\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";s:1:\"0\";}i:13;a:9:{s:9:\"type_lite\";s:10:\"id_feature\";s:4:\"type\";s:10:\"id_feature\";s:6:\"id_key\";s:2:\"10\";s:6:\"values\";a:6:{i:725;a:4:{s:3:\"nbr\";s:1:\"2\";s:4:\"name\";s:3:\"Alb\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:733;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:10:\"Alb si gri\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:737;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:8:\"Argintiu\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:728;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:5:\"Negru\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:740;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:14:\"Negru si auriu\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:731;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:10:\"Portocaliu\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}}s:4:\"name\";s:7:\"Culoare\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";s:1:\"0\";}i:14;a:9:{s:9:\"type_lite\";s:10:\"id_feature\";s:4:\"type\";s:10:\"id_feature\";s:6:\"id_key\";s:2:\"11\";s:6:\"values\";a:4:{i:722;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:8:\"Aluminiu\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:715;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:12:\"Metal cromat\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:720;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:11:\"Metal Negru\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:718;a:4:{s:3:\"nbr\";s:1:\"2\";s:4:\"name\";s:16:\"Plastic, Silicon\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}}s:4:\"name\";s:17:\"Compozitie suport\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";s:1:\"0\";}i:15;a:9:{s:9:\"type_lite\";s:10:\"id_feature\";s:4:\"type\";s:10:\"id_feature\";s:6:\"id_key\";s:2:\"12\";s:6:\"values\";a:1:{i:753;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:5:\"Metal\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}}s:4:\"name\";s:14:\"Material cadru\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";s:1:\"0\";}i:16;a:9:{s:9:\"type_lite\";s:10:\"id_feature\";s:4:\"type\";s:10:\"id_feature\";s:6:\"id_key\";s:2:\"13\";s:6:\"values\";a:3:{i:746;a:4:{s:3:\"nbr\";s:1:\"2\";s:4:\"name\";s:3:\"15W\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:749;a:4:{s:3:\"nbr\";s:1:\"3\";s:4:\"name\";s:3:\"40W\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:751;a:4:{s:3:\"nbr\";s:1:\"2\";s:4:\"name\";s:3:\"60W\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}}s:4:\"name\";s:10:\"Putere bec\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";s:1:\"0\";}i:17;a:9:{s:9:\"type_lite\";s:10:\"id_feature\";s:4:\"type\";s:10:\"id_feature\";s:6:\"id_key\";s:2:\"14\";s:6:\"values\";a:2:{i:693;a:4:{s:3:\"nbr\";s:1:\"5\";s:4:\"name\";s:4:\"IP20\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:694;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:4:\"IP44\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}}s:4:\"name\";s:15:\"Clasa protectie\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";s:1:\"0\";}i:18;a:9:{s:9:\"type_lite\";s:10:\"id_feature\";s:4:\"type\";s:10:\"id_feature\";s:6:\"id_key\";s:2:\"20\";s:6:\"values\";a:4:{i:873;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:14:\"17.4 cm latime\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:866;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:12:\"19 cm latime\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:881;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:14:\"21.2 cm latime\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:884;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:12:\"25 cm latime\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}}s:4:\"name\";s:6:\"Latime\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";s:1:\"0\";}i:19;a:9:{s:9:\"type_lite\";s:10:\"id_feature\";s:4:\"type\";s:10:\"id_feature\";s:6:\"id_key\";s:2:\"21\";s:6:\"values\";a:1:{i:865;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:13:\"19 cm lungime\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}}s:4:\"name\";s:7:\"Lungime\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";s:1:\"0\";}i:20;a:9:{s:9:\"type_lite\";s:10:\"id_feature\";s:4:\"type\";s:10:\"id_feature\";s:6:\"id_key\";s:2:\"22\";s:6:\"values\";a:2:{i:835;a:4:{s:3:\"nbr\";s:1:\"2\";s:4:\"name\";s:14:\"13 cm diametru\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:806;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:14:\"60 cm diametru\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}}s:4:\"name\";s:8:\"Diametru\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";s:1:\"0\";}}}")	9.969 ms	1			/modules/ps_facetedsearch/src/Filters/Block.php:211 /modules/ps_facetedsearch/src/Product/SearchProvider.php:217 (insertIntoCache) /classes/controller/ProductListingFrontController.php:357 (runQuery) /override/controllers/front/listing/CategoryController.php:22 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (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, pl.name FROM mmag_product p LEFT JOIN mmag_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mmag_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN mmag_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 mmag_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN mmag_product_lang pl ON (p.id_product = pl.id_product AND pl.id_shop = 1 AND pl.id_lang = 1) INNER JOIN mmag_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN mmag_category_product cp ON (p.id_product = cp.id_product) INNER JOIN mmag_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN mmag_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN mmag_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, 36) 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-04-25 20:00:56' >= sp.from) AND (sp.to = '0000-00-00 00:00:00' OR '2025-04-25 20:00:56' <= sp.to) ) LEFT JOIN mmag_feature_product fp_1 ON (p.id_product = fp_1.id_product) WHERE ((sp.reduction>0)) AND ((fp_1.id_feature_value IN (1192, 1247, 1239, 1235, 1229, 1220, 1215, 1212, 1206, 1194, 1173, 1155, 774, 1167, 776))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=9 AND c.nright<=24 GROUP BY p.id_product) p INNER JOIN mmag_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN mmag_specific_price sp_1 ON ( sp_1.id_product = p.id_product AND sp_1.id_shop IN (0, 1) AND sp_1.id_currency IN (0, 1) AND sp_1.id_country IN (0, 36) AND sp_1.id_group IN (0, 1) AND sp_1.from_quantity = 1 AND sp_1.reduction > 0 AND sp_1.id_customer = 0 AND sp_1.id_cart = 0 AND (sp_1.from = '0000-00-00 00:00:00' OR '2025-04-25 20:00:56' >= sp_1.from) AND (sp_1.to = '0000-00-00 00:00:00' OR '2025-04-25 20:00:56' <= sp_1.to) ) LEFT JOIN mmag_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((fp.id_feature=5)) AND ((sp_1.reduction>0)) AND ((fp_2.id_feature_value IN (1192, 1247, 1239, 1235, 1229, 1220, 1215, 1212, 1206, 1194, 1173, 1155, 774, 1167, 776))) GROUP BY fp.id_feature_value	8.892 ms	109956	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:778 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:855 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:154 (getFeaturesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:357 (runQuery) /override/controllers/front/listing/CategoryController.php:22 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
101	SELECT SQL_NO_CACHE DISTINCT a.`id_attribute`, a.`color`, al.`name`, agl.`id_attribute_group`, IF(lialv.`url_name` IS NULL OR lialv.`url_name` = "", NULL, lialv.`url_name`) AS url_name, IF(lialv.`meta_title` IS NULL OR lialv.`meta_title` = "", NULL, lialv.`meta_title`) AS meta_title FROM `mmag_attribute_group` ag INNER JOIN `mmag_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1) INNER JOIN `mmag_attribute` a ON a.`id_attribute_group` = ag.`id_attribute_group` INNER JOIN `mmag_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1) INNER JOIN mmag_attribute_group_shop attribute_group_shop ON (attribute_group_shop.id_attribute_group = ag.id_attribute_group AND attribute_group_shop.id_shop = 1) INNER JOIN mmag_attribute_shop attribute_shop ON (attribute_shop.id_attribute = a.id_attribute AND attribute_shop.id_shop = 1) LEFT JOIN `mmag_layered_indexable_attribute_lang_value` lialv ON (a.`id_attribute` = lialv.`id_attribute` AND lialv.`id_lang` = 1) WHERE ag.id_attribute_group = 1 ORDER BY agl.`name` ASC, a.`position` ASC	5.385 ms	4	Yes		/modules/ps_facetedsearch/src/Filters/DataAccessor.php:96 /modules/ps_facetedsearch/src/Filters/Block.php:731 (getAttributes) /modules/ps_facetedsearch/src/Filters/Block.php:150 (getAttributesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:357 (runQuery) /override/controllers/front/listing/CategoryController.php:22 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
105	SELECT SQL_NO_CACHE 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, pl.name FROM mmag_product p LEFT JOIN mmag_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mmag_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN mmag_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 mmag_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN mmag_product_lang pl ON (p.id_product = pl.id_product AND pl.id_shop = 1 AND pl.id_lang = 1) INNER JOIN mmag_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN mmag_category_product cp ON (p.id_product = cp.id_product) INNER JOIN mmag_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN mmag_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN mmag_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, 36) 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-04-25 20:00:55' >= sp.from) AND (sp.to = '0000-00-00 00:00:00' OR '2025-04-25 20:00:55' <= sp.to) ) LEFT JOIN mmag_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN mmag_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((sp.reduction>0)) AND ((fp_1.id_feature_value IN (1192, 1247, 1239, 1235, 1229, 1220, 1215, 1212, 1206, 1194, 1173, 1155, 774, 1167, 776))) AND ((fp_2.id_feature_value IN (808, 815, 833))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=9 AND c.nright<=24 GROUP BY p.id_product) p INNER JOIN mmag_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN mmag_specific_price sp_1 ON ( sp_1.id_product = p.id_product AND sp_1.id_shop IN (0, 1) AND sp_1.id_currency IN (0, 1) AND sp_1.id_country IN (0, 36) AND sp_1.id_group IN (0, 1) AND sp_1.from_quantity = 1 AND sp_1.reduction > 0 AND sp_1.id_customer = 0 AND sp_1.id_cart = 0 AND (sp_1.from = '0000-00-00 00:00:00' OR '2025-04-25 20:00:55' >= sp_1.from) AND (sp_1.to = '0000-00-00 00:00:00' OR '2025-04-25 20:00:55' <= sp_1.to) ) LEFT JOIN mmag_feature_product fp_2 ON (p.id_product = fp_2.id_product) LEFT JOIN mmag_feature_product fp_3 ON (p.id_product = fp_3.id_product) WHERE ((fp.id_feature=1)) AND ((sp_1.reduction>0)) AND ((fp_2.id_feature_value IN (1192, 1247, 1239, 1235, 1229, 1220, 1215, 1212, 1206, 1194, 1173, 1155, 774, 1167, 776))) AND ((fp_3.id_feature_value IN (808, 815, 833))) GROUP BY fp.id_feature_value	3.575 ms	98784	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:778 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:855 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:154 (getFeaturesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:357 (runQuery) /override/controllers/front/listing/CategoryController.php:22 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
100	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, pl.name FROM mmag_product p LEFT JOIN mmag_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mmag_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN mmag_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 mmag_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN mmag_product_lang pl ON (p.id_product = pl.id_product AND pl.id_shop = 1 AND pl.id_lang = 1) INNER JOIN mmag_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN mmag_category_product cp ON (p.id_product = cp.id_product) INNER JOIN mmag_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN mmag_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN mmag_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, 36) 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-04-25 20:00:55' >= sp.from) AND (sp.to = '0000-00-00 00:00:00' OR '2025-04-25 20:00:55' <= sp.to) ) LEFT JOIN mmag_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN mmag_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((sp.reduction>0)) AND ((fp_1.id_feature_value IN (1192, 1247, 1239, 1235, 1229, 1220, 1215, 1212, 1206, 1194, 1173, 1155, 774, 1167, 776))) AND ((fp_2.id_feature_value IN (808, 815, 833))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=9 AND c.nright<=24 GROUP BY p.id_product) p INNER JOIN mmag_category_product cp ON (p.id_product = cp.id_product) INNER JOIN mmag_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN mmag_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN mmag_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, 36) 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-04-25 20:00:55' >= sp.from) AND (sp.to = '0000-00-00 00:00:00' OR '2025-04-25 20:00:55' <= sp.to) ) LEFT JOIN mmag_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN mmag_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((sp.reduction>0)) AND ((fp_1.id_feature_value IN (1192, 1247, 1239, 1235, 1229, 1220, 1215, 1212, 1206, 1194, 1173, 1155, 774, 1167, 776))) AND ((fp_2.id_feature_value IN (808, 815, 833))) AND cg.id_group='1' AND c.level_depth<=3 AND c.nleft>9 AND c.nright<24 GROUP BY cp.id_category	3.441 ms	197568	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:778 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:992 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:158 (getCategoriesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:357 (runQuery) /override/controllers/front/listing/CategoryController.php:22 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
93	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, pl.name FROM mmag_product p LEFT JOIN mmag_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mmag_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN mmag_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 mmag_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN mmag_product_lang pl ON (p.id_product = pl.id_product AND pl.id_shop = 1 AND pl.id_lang = 1) INNER JOIN mmag_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN mmag_category_product cp ON (p.id_product = cp.id_product) INNER JOIN mmag_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN mmag_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN mmag_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, 36) 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-04-25 20:00:55' >= sp.from) AND (sp.to = '0000-00-00 00:00:00' OR '2025-04-25 20:00:55' <= sp.to) ) LEFT JOIN mmag_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN mmag_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((sp.reduction>0)) AND ((fp_1.id_feature_value IN (1192, 1247, 1239, 1235, 1229, 1220, 1215, 1212, 1206, 1194, 1173, 1155, 774, 1167, 776))) AND ((fp_2.id_feature_value IN (808, 815, 833))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=9 AND c.nright<=24 GROUP BY p.id_product) p LEFT JOIN mmag_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mmag_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN mmag_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 mmag_stock_available sa_1 ON (p.id_product = sa_1.id_product AND IFNULL(pac.id_product_attribute, 0) = sa_1.id_product_attribute AND sa_1.id_shop = 1 AND sa_1.id_shop_group = 0 ) LEFT JOIN mmag_specific_price sp_1 ON ( sp_1.id_product = p.id_product AND sp_1.id_shop IN (0, 1) AND sp_1.id_currency IN (0, 1) AND sp_1.id_country IN (0, 36) AND sp_1.id_group IN (0, 1) AND sp_1.from_quantity = 1 AND sp_1.reduction > 0 AND sp_1.id_customer = 0 AND sp_1.id_cart = 0 AND (sp_1.from = '0000-00-00 00:00:00' OR '2025-04-25 20:00:55' >= sp_1.from) AND (sp_1.to = '0000-00-00 00:00:00' OR '2025-04-25 20:00:55' <= sp_1.to) ) LEFT JOIN mmag_feature_product fp_2 ON (p.id_product = fp_2.id_product) LEFT JOIN mmag_feature_product fp_3 ON (p.id_product = fp_3.id_product) WHERE ((sa.quantity<=0 AND sa_1.out_of_stock=0)) AND ((sp_1.reduction>0)) AND ((fp_2.id_feature_value IN (1192, 1247, 1239, 1235, 1229, 1220, 1215, 1212, 1206, 1194, 1173, 1155, 774, 1167, 776))) AND ((fp_3.id_feature_value IN (808, 815, 833)))	3.306 ms	98784			/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:778 (execute) /modules/ps_facetedsearch/src/Adapter/MySQL.php:757 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:480 (count) /modules/ps_facetedsearch/src/Filters/Block.php:140 (getAvailabilitiesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:357 (runQuery) /override/controllers/front/listing/CategoryController.php:22 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
144	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, pl.name FROM mmag_product p LEFT JOIN mmag_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mmag_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN mmag_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 mmag_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN mmag_product_lang pl ON (p.id_product = pl.id_product AND pl.id_shop = 1 AND pl.id_lang = 1) INNER JOIN mmag_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN mmag_category_product cp ON (p.id_product = cp.id_product) INNER JOIN mmag_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN mmag_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN mmag_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, 36) 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-04-25 20:00:56' >= sp.from) AND (sp.to = '0000-00-00 00:00:00' OR '2025-04-25 20:00:56' <= sp.to) ) LEFT JOIN mmag_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN mmag_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((sp.reduction>0)) AND ((fp_1.id_feature_value IN (1192, 1247, 1239, 1235, 1229, 1220, 1215, 1212, 1206, 1194, 1173, 1155, 774, 1167, 776))) AND ((fp_2.id_feature_value IN (808, 815, 833))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=9 AND c.nright<=24 GROUP BY p.id_product) p INNER JOIN mmag_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN mmag_specific_price sp_1 ON ( sp_1.id_product = p.id_product AND sp_1.id_shop IN (0, 1) AND sp_1.id_currency IN (0, 1) AND sp_1.id_country IN (0, 36) AND sp_1.id_group IN (0, 1) AND sp_1.from_quantity = 1 AND sp_1.reduction > 0 AND sp_1.id_customer = 0 AND sp_1.id_cart = 0 AND (sp_1.from = '0000-00-00 00:00:00' OR '2025-04-25 20:00:56' >= sp_1.from) AND (sp_1.to = '0000-00-00 00:00:00' OR '2025-04-25 20:00:56' <= sp_1.to) ) LEFT JOIN mmag_feature_product fp_2 ON (p.id_product = fp_2.id_product) LEFT JOIN mmag_feature_product fp_3 ON (p.id_product = fp_3.id_product) WHERE ((fp.id_feature=19)) AND ((sp_1.reduction>0)) AND ((fp_2.id_feature_value IN (1192, 1247, 1239, 1235, 1229, 1220, 1215, 1212, 1206, 1194, 1173, 1155, 774, 1167, 776))) AND ((fp_3.id_feature_value IN (808, 815, 833))) GROUP BY fp.id_feature_value	3.301 ms	98784	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:778 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:855 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:154 (getFeaturesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:357 (runQuery) /override/controllers/front/listing/CategoryController.php:22 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
130	SELECT SQL_NO_CACHE 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, pl.name FROM mmag_product p LEFT JOIN mmag_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mmag_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN mmag_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 mmag_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN mmag_product_lang pl ON (p.id_product = pl.id_product AND pl.id_shop = 1 AND pl.id_lang = 1) INNER JOIN mmag_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN mmag_category_product cp ON (p.id_product = cp.id_product) INNER JOIN mmag_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN mmag_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN mmag_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, 36) 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-04-25 20:00:56' >= sp.from) AND (sp.to = '0000-00-00 00:00:00' OR '2025-04-25 20:00:56' <= sp.to) ) LEFT JOIN mmag_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN mmag_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((sp.reduction>0)) AND ((fp_1.id_feature_value IN (1192, 1247, 1239, 1235, 1229, 1220, 1215, 1212, 1206, 1194, 1173, 1155, 774, 1167, 776))) AND ((fp_2.id_feature_value IN (808, 815, 833))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=9 AND c.nright<=24 GROUP BY p.id_product) p INNER JOIN mmag_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN mmag_specific_price sp_1 ON ( sp_1.id_product = p.id_product AND sp_1.id_shop IN (0, 1) AND sp_1.id_currency IN (0, 1) AND sp_1.id_country IN (0, 36) AND sp_1.id_group IN (0, 1) AND sp_1.from_quantity = 1 AND sp_1.reduction > 0 AND sp_1.id_customer = 0 AND sp_1.id_cart = 0 AND (sp_1.from = '0000-00-00 00:00:00' OR '2025-04-25 20:00:56' >= sp_1.from) AND (sp_1.to = '0000-00-00 00:00:00' OR '2025-04-25 20:00:56' <= sp_1.to) ) LEFT JOIN mmag_feature_product fp_2 ON (p.id_product = fp_2.id_product) LEFT JOIN mmag_feature_product fp_3 ON (p.id_product = fp_3.id_product) WHERE ((fp.id_feature=10)) AND ((sp_1.reduction>0)) AND ((fp_2.id_feature_value IN (1192, 1247, 1239, 1235, 1229, 1220, 1215, 1212, 1206, 1194, 1173, 1155, 774, 1167, 776))) AND ((fp_3.id_feature_value IN (808, 815, 833))) GROUP BY fp.id_feature_value	3.268 ms	98784	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:778 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:855 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:154 (getFeaturesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:357 (runQuery) /override/controllers/front/listing/CategoryController.php:22 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
107	SELECT SQL_NO_CACHE fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, pl.name FROM mmag_product p LEFT JOIN mmag_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mmag_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN mmag_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 mmag_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN mmag_product_lang pl ON (p.id_product = pl.id_product AND pl.id_shop = 1 AND pl.id_lang = 1) INNER JOIN mmag_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN mmag_category_product cp ON (p.id_product = cp.id_product) INNER JOIN mmag_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN mmag_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN mmag_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, 36) 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-04-25 20:00:55' >= sp.from) AND (sp.to = '0000-00-00 00:00:00' OR '2025-04-25 20:00:55' <= sp.to) ) LEFT JOIN mmag_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN mmag_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((sp.reduction>0)) AND ((fp_1.id_feature_value IN (1192, 1247, 1239, 1235, 1229, 1220, 1215, 1212, 1206, 1194, 1173, 1155, 774, 1167, 776))) AND ((fp_2.id_feature_value IN (808, 815, 833))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=9 AND c.nright<=24 GROUP BY p.id_product) p INNER JOIN mmag_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN mmag_specific_price sp_1 ON ( sp_1.id_product = p.id_product AND sp_1.id_shop IN (0, 1) AND sp_1.id_currency IN (0, 1) AND sp_1.id_country IN (0, 36) AND sp_1.id_group IN (0, 1) AND sp_1.from_quantity = 1 AND sp_1.reduction > 0 AND sp_1.id_customer = 0 AND sp_1.id_cart = 0 AND (sp_1.from = '0000-00-00 00:00:00' OR '2025-04-25 20:00:55' >= sp_1.from) AND (sp_1.to = '0000-00-00 00:00:00' OR '2025-04-25 20:00:55' <= sp_1.to) ) LEFT JOIN mmag_feature_product fp_2 ON (p.id_product = fp_2.id_product) LEFT JOIN mmag_feature_product fp_3 ON (p.id_product = fp_3.id_product) WHERE ((fp.id_feature=2)) AND ((sp_1.reduction>0)) AND ((fp_2.id_feature_value IN (1192, 1247, 1239, 1235, 1229, 1220, 1215, 1212, 1206, 1194, 1173, 1155, 774, 1167, 776))) AND ((fp_3.id_feature_value IN (808, 815, 833))) GROUP BY fp.id_feature_value	3.240 ms	98784	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:778 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:855 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:154 (getFeaturesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:357 (runQuery) /override/controllers/front/listing/CategoryController.php:22 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (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, pl.name FROM mmag_product p LEFT JOIN mmag_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mmag_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN mmag_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 mmag_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN mmag_product_lang pl ON (p.id_product = pl.id_product AND pl.id_shop = 1 AND pl.id_lang = 1) INNER JOIN mmag_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN mmag_category_product cp ON (p.id_product = cp.id_product) INNER JOIN mmag_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN mmag_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN mmag_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, 36) 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-04-25 20:00:56' >= sp.from) AND (sp.to = '0000-00-00 00:00:00' OR '2025-04-25 20:00:56' <= sp.to) ) LEFT JOIN mmag_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN mmag_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((sp.reduction>0)) AND ((fp_1.id_feature_value IN (1192, 1247, 1239, 1235, 1229, 1220, 1215, 1212, 1206, 1194, 1173, 1155, 774, 1167, 776))) AND ((fp_2.id_feature_value IN (808, 815, 833))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=9 AND c.nright<=24 GROUP BY p.id_product) p INNER JOIN mmag_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN mmag_specific_price sp_1 ON ( sp_1.id_product = p.id_product AND sp_1.id_shop IN (0, 1) AND sp_1.id_currency IN (0, 1) AND sp_1.id_country IN (0, 36) AND sp_1.id_group IN (0, 1) AND sp_1.from_quantity = 1 AND sp_1.reduction > 0 AND sp_1.id_customer = 0 AND sp_1.id_cart = 0 AND (sp_1.from = '0000-00-00 00:00:00' OR '2025-04-25 20:00:56' >= sp_1.from) AND (sp_1.to = '0000-00-00 00:00:00' OR '2025-04-25 20:00:56' <= sp_1.to) ) LEFT JOIN mmag_feature_product fp_2 ON (p.id_product = fp_2.id_product) LEFT JOIN mmag_feature_product fp_3 ON (p.id_product = fp_3.id_product) WHERE ((fp.id_feature=9)) AND ((sp_1.reduction>0)) AND ((fp_2.id_feature_value IN (1192, 1247, 1239, 1235, 1229, 1220, 1215, 1212, 1206, 1194, 1173, 1155, 774, 1167, 776))) AND ((fp_3.id_feature_value IN (808, 815, 833))) GROUP BY fp.id_feature_value	3.227 ms	98784	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:778 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:855 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:154 (getFeaturesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:357 (runQuery) /override/controllers/front/listing/CategoryController.php:22 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
140	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, pl.name FROM mmag_product p LEFT JOIN mmag_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mmag_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN mmag_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 mmag_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN mmag_product_lang pl ON (p.id_product = pl.id_product AND pl.id_shop = 1 AND pl.id_lang = 1) INNER JOIN mmag_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN mmag_category_product cp ON (p.id_product = cp.id_product) INNER JOIN mmag_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN mmag_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN mmag_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, 36) 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-04-25 20:00:56' >= sp.from) AND (sp.to = '0000-00-00 00:00:00' OR '2025-04-25 20:00:56' <= sp.to) ) LEFT JOIN mmag_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN mmag_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((sp.reduction>0)) AND ((fp_1.id_feature_value IN (1192, 1247, 1239, 1235, 1229, 1220, 1215, 1212, 1206, 1194, 1173, 1155, 774, 1167, 776))) AND ((fp_2.id_feature_value IN (808, 815, 833))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=9 AND c.nright<=24 GROUP BY p.id_product) p INNER JOIN mmag_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN mmag_specific_price sp_1 ON ( sp_1.id_product = p.id_product AND sp_1.id_shop IN (0, 1) AND sp_1.id_currency IN (0, 1) AND sp_1.id_country IN (0, 36) AND sp_1.id_group IN (0, 1) AND sp_1.from_quantity = 1 AND sp_1.reduction > 0 AND sp_1.id_customer = 0 AND sp_1.id_cart = 0 AND (sp_1.from = '0000-00-00 00:00:00' OR '2025-04-25 20:00:56' >= sp_1.from) AND (sp_1.to = '0000-00-00 00:00:00' OR '2025-04-25 20:00:56' <= sp_1.to) ) LEFT JOIN mmag_feature_product fp_2 ON (p.id_product = fp_2.id_product) LEFT JOIN mmag_feature_product fp_3 ON (p.id_product = fp_3.id_product) WHERE ((fp.id_feature=15)) AND ((sp_1.reduction>0)) AND ((fp_2.id_feature_value IN (1192, 1247, 1239, 1235, 1229, 1220, 1215, 1212, 1206, 1194, 1173, 1155, 774, 1167, 776))) AND ((fp_3.id_feature_value IN (808, 815, 833))) GROUP BY fp.id_feature_value	3.206 ms	98784	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:778 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:855 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:154 (getFeaturesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:357 (runQuery) /override/controllers/front/listing/CategoryController.php:22 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
142	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, pl.name FROM mmag_product p LEFT JOIN mmag_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mmag_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN mmag_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 mmag_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN mmag_product_lang pl ON (p.id_product = pl.id_product AND pl.id_shop = 1 AND pl.id_lang = 1) INNER JOIN mmag_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN mmag_category_product cp ON (p.id_product = cp.id_product) INNER JOIN mmag_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN mmag_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN mmag_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, 36) 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-04-25 20:00:56' >= sp.from) AND (sp.to = '0000-00-00 00:00:00' OR '2025-04-25 20:00:56' <= sp.to) ) LEFT JOIN mmag_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN mmag_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((sp.reduction>0)) AND ((fp_1.id_feature_value IN (1192, 1247, 1239, 1235, 1229, 1220, 1215, 1212, 1206, 1194, 1173, 1155, 774, 1167, 776))) AND ((fp_2.id_feature_value IN (808, 815, 833))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=9 AND c.nright<=24 GROUP BY p.id_product) p INNER JOIN mmag_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN mmag_specific_price sp_1 ON ( sp_1.id_product = p.id_product AND sp_1.id_shop IN (0, 1) AND sp_1.id_currency IN (0, 1) AND sp_1.id_country IN (0, 36) AND sp_1.id_group IN (0, 1) AND sp_1.from_quantity = 1 AND sp_1.reduction > 0 AND sp_1.id_customer = 0 AND sp_1.id_cart = 0 AND (sp_1.from = '0000-00-00 00:00:00' OR '2025-04-25 20:00:56' >= sp_1.from) AND (sp_1.to = '0000-00-00 00:00:00' OR '2025-04-25 20:00:56' <= sp_1.to) ) LEFT JOIN mmag_feature_product fp_2 ON (p.id_product = fp_2.id_product) LEFT JOIN mmag_feature_product fp_3 ON (p.id_product = fp_3.id_product) WHERE ((fp.id_feature=17)) AND ((sp_1.reduction>0)) AND ((fp_2.id_feature_value IN (1192, 1247, 1239, 1235, 1229, 1220, 1215, 1212, 1206, 1194, 1173, 1155, 774, 1167, 776))) AND ((fp_3.id_feature_value IN (808, 815, 833))) GROUP BY fp.id_feature_value	3.201 ms	98784	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:778 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:855 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:154 (getFeaturesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:357 (runQuery) /override/controllers/front/listing/CategoryController.php:22 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
94	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, pl.name FROM mmag_product p LEFT JOIN mmag_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mmag_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN mmag_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 mmag_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN mmag_product_lang pl ON (p.id_product = pl.id_product AND pl.id_shop = 1 AND pl.id_lang = 1) INNER JOIN mmag_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN mmag_category_product cp ON (p.id_product = cp.id_product) INNER JOIN mmag_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN mmag_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN mmag_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, 36) 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-04-25 20:00:55' >= sp.from) AND (sp.to = '0000-00-00 00:00:00' OR '2025-04-25 20:00:55' <= sp.to) ) LEFT JOIN mmag_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN mmag_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((sp.reduction>0)) AND ((fp_1.id_feature_value IN (1192, 1247, 1239, 1235, 1229, 1220, 1215, 1212, 1206, 1194, 1173, 1155, 774, 1167, 776))) AND ((fp_2.id_feature_value IN (808, 815, 833))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=9 AND c.nright<=24 GROUP BY p.id_product) p LEFT JOIN mmag_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mmag_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN mmag_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 mmag_specific_price sp_1 ON ( sp_1.id_product = p.id_product AND sp_1.id_shop IN (0, 1) AND sp_1.id_currency IN (0, 1) AND sp_1.id_country IN (0, 36) AND sp_1.id_group IN (0, 1) AND sp_1.from_quantity = 1 AND sp_1.reduction > 0 AND sp_1.id_customer = 0 AND sp_1.id_cart = 0 AND (sp_1.from = '0000-00-00 00:00:00' OR '2025-04-25 20:00:55' >= sp_1.from) AND (sp_1.to = '0000-00-00 00:00:00' OR '2025-04-25 20:00:55' <= sp_1.to) ) LEFT JOIN mmag_feature_product fp_2 ON (p.id_product = fp_2.id_product) LEFT JOIN mmag_feature_product fp_3 ON (p.id_product = fp_3.id_product) WHERE ((sa.out_of_stock IN (1, 2)) OR (sa.quantity>0)) AND ((sp_1.reduction>0)) AND ((fp_2.id_feature_value IN (1192, 1247, 1239, 1235, 1229, 1220, 1215, 1212, 1206, 1194, 1173, 1155, 774, 1167, 776))) AND ((fp_3.id_feature_value IN (808, 815, 833)))	3.181 ms	98784			/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:778 (execute) /modules/ps_facetedsearch/src/Adapter/MySQL.php:757 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:494 (count) /modules/ps_facetedsearch/src/Filters/Block.php:140 (getAvailabilitiesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:357 (runQuery) /override/controllers/front/listing/CategoryController.php:22 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (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, pl.name FROM mmag_product p LEFT JOIN mmag_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mmag_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN mmag_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 mmag_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN mmag_product_lang pl ON (p.id_product = pl.id_product AND pl.id_shop = 1 AND pl.id_lang = 1) INNER JOIN mmag_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN mmag_category_product cp ON (p.id_product = cp.id_product) INNER JOIN mmag_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN mmag_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN mmag_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, 36) 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-04-25 20:00:56' >= sp.from) AND (sp.to = '0000-00-00 00:00:00' OR '2025-04-25 20:00:56' <= sp.to) ) LEFT JOIN mmag_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN mmag_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((sp.reduction>0)) AND ((fp_1.id_feature_value IN (1192, 1247, 1239, 1235, 1229, 1220, 1215, 1212, 1206, 1194, 1173, 1155, 774, 1167, 776))) AND ((fp_2.id_feature_value IN (808, 815, 833))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=9 AND c.nright<=24 GROUP BY p.id_product) p INNER JOIN mmag_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN mmag_specific_price sp_1 ON ( sp_1.id_product = p.id_product AND sp_1.id_shop IN (0, 1) AND sp_1.id_currency IN (0, 1) AND sp_1.id_country IN (0, 36) AND sp_1.id_group IN (0, 1) AND sp_1.from_quantity = 1 AND sp_1.reduction > 0 AND sp_1.id_customer = 0 AND sp_1.id_cart = 0 AND (sp_1.from = '0000-00-00 00:00:00' OR '2025-04-25 20:00:56' >= sp_1.from) AND (sp_1.to = '0000-00-00 00:00:00' OR '2025-04-25 20:00:56' <= sp_1.to) ) LEFT JOIN mmag_feature_product fp_2 ON (p.id_product = fp_2.id_product) LEFT JOIN mmag_feature_product fp_3 ON (p.id_product = fp_3.id_product) WHERE ((fp.id_feature=12)) AND ((sp_1.reduction>0)) AND ((fp_2.id_feature_value IN (1192, 1247, 1239, 1235, 1229, 1220, 1215, 1212, 1206, 1194, 1173, 1155, 774, 1167, 776))) AND ((fp_3.id_feature_value IN (808, 815, 833))) GROUP BY fp.id_feature_value	3.170 ms	98784	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:778 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:855 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:154 (getFeaturesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:357 (runQuery) /override/controllers/front/listing/CategoryController.php:22 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
147	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, pl.name FROM mmag_product p LEFT JOIN mmag_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mmag_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN mmag_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 mmag_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN mmag_product_lang pl ON (p.id_product = pl.id_product AND pl.id_shop = 1 AND pl.id_lang = 1) INNER JOIN mmag_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN mmag_category_product cp ON (p.id_product = cp.id_product) INNER JOIN mmag_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN mmag_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN mmag_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, 36) 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-04-25 20:00:56' >= sp.from) AND (sp.to = '0000-00-00 00:00:00' OR '2025-04-25 20:00:56' <= sp.to) ) LEFT JOIN mmag_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN mmag_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((sp.reduction>0)) AND ((fp_1.id_feature_value IN (1192, 1247, 1239, 1235, 1229, 1220, 1215, 1212, 1206, 1194, 1173, 1155, 774, 1167, 776))) AND ((fp_2.id_feature_value IN (808, 815, 833))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=9 AND c.nright<=24 GROUP BY p.id_product) p INNER JOIN mmag_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN mmag_specific_price sp_1 ON ( sp_1.id_product = p.id_product AND sp_1.id_shop IN (0, 1) AND sp_1.id_currency IN (0, 1) AND sp_1.id_country IN (0, 36) AND sp_1.id_group IN (0, 1) AND sp_1.from_quantity = 1 AND sp_1.reduction > 0 AND sp_1.id_customer = 0 AND sp_1.id_cart = 0 AND (sp_1.from = '0000-00-00 00:00:00' OR '2025-04-25 20:00:56' >= sp_1.from) AND (sp_1.to = '0000-00-00 00:00:00' OR '2025-04-25 20:00:56' <= sp_1.to) ) LEFT JOIN mmag_feature_product fp_2 ON (p.id_product = fp_2.id_product) LEFT JOIN mmag_feature_product fp_3 ON (p.id_product = fp_3.id_product) WHERE ((fp.id_feature=21)) AND ((sp_1.reduction>0)) AND ((fp_2.id_feature_value IN (1192, 1247, 1239, 1235, 1229, 1220, 1215, 1212, 1206, 1194, 1173, 1155, 774, 1167, 776))) AND ((fp_3.id_feature_value IN (808, 815, 833))) GROUP BY fp.id_feature_value	3.160 ms	98784	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:778 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:855 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:154 (getFeaturesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:357 (runQuery) /override/controllers/front/listing/CategoryController.php:22 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
143	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, pl.name FROM mmag_product p LEFT JOIN mmag_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mmag_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN mmag_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 mmag_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN mmag_product_lang pl ON (p.id_product = pl.id_product AND pl.id_shop = 1 AND pl.id_lang = 1) INNER JOIN mmag_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN mmag_category_product cp ON (p.id_product = cp.id_product) INNER JOIN mmag_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN mmag_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN mmag_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, 36) 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-04-25 20:00:56' >= sp.from) AND (sp.to = '0000-00-00 00:00:00' OR '2025-04-25 20:00:56' <= sp.to) ) LEFT JOIN mmag_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN mmag_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((sp.reduction>0)) AND ((fp_1.id_feature_value IN (1192, 1247, 1239, 1235, 1229, 1220, 1215, 1212, 1206, 1194, 1173, 1155, 774, 1167, 776))) AND ((fp_2.id_feature_value IN (808, 815, 833))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=9 AND c.nright<=24 GROUP BY p.id_product) p INNER JOIN mmag_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN mmag_specific_price sp_1 ON ( sp_1.id_product = p.id_product AND sp_1.id_shop IN (0, 1) AND sp_1.id_currency IN (0, 1) AND sp_1.id_country IN (0, 36) AND sp_1.id_group IN (0, 1) AND sp_1.from_quantity = 1 AND sp_1.reduction > 0 AND sp_1.id_customer = 0 AND sp_1.id_cart = 0 AND (sp_1.from = '0000-00-00 00:00:00' OR '2025-04-25 20:00:56' >= sp_1.from) AND (sp_1.to = '0000-00-00 00:00:00' OR '2025-04-25 20:00:56' <= sp_1.to) ) LEFT JOIN mmag_feature_product fp_2 ON (p.id_product = fp_2.id_product) LEFT JOIN mmag_feature_product fp_3 ON (p.id_product = fp_3.id_product) WHERE ((fp.id_feature=18)) AND ((sp_1.reduction>0)) AND ((fp_2.id_feature_value IN (1192, 1247, 1239, 1235, 1229, 1220, 1215, 1212, 1206, 1194, 1173, 1155, 774, 1167, 776))) AND ((fp_3.id_feature_value IN (808, 815, 833))) GROUP BY fp.id_feature_value	3.146 ms	98784	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:778 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:855 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:154 (getFeaturesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:357 (runQuery) /override/controllers/front/listing/CategoryController.php:22 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
136	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, pl.name FROM mmag_product p LEFT JOIN mmag_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mmag_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN mmag_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 mmag_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN mmag_product_lang pl ON (p.id_product = pl.id_product AND pl.id_shop = 1 AND pl.id_lang = 1) INNER JOIN mmag_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN mmag_category_product cp ON (p.id_product = cp.id_product) INNER JOIN mmag_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN mmag_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN mmag_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, 36) 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-04-25 20:00:56' >= sp.from) AND (sp.to = '0000-00-00 00:00:00' OR '2025-04-25 20:00:56' <= sp.to) ) LEFT JOIN mmag_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN mmag_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((sp.reduction>0)) AND ((fp_1.id_feature_value IN (1192, 1247, 1239, 1235, 1229, 1220, 1215, 1212, 1206, 1194, 1173, 1155, 774, 1167, 776))) AND ((fp_2.id_feature_value IN (808, 815, 833))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=9 AND c.nright<=24 GROUP BY p.id_product) p INNER JOIN mmag_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN mmag_specific_price sp_1 ON ( sp_1.id_product = p.id_product AND sp_1.id_shop IN (0, 1) AND sp_1.id_currency IN (0, 1) AND sp_1.id_country IN (0, 36) AND sp_1.id_group IN (0, 1) AND sp_1.from_quantity = 1 AND sp_1.reduction > 0 AND sp_1.id_customer = 0 AND sp_1.id_cart = 0 AND (sp_1.from = '0000-00-00 00:00:00' OR '2025-04-25 20:00:56' >= sp_1.from) AND (sp_1.to = '0000-00-00 00:00:00' OR '2025-04-25 20:00:56' <= sp_1.to) ) LEFT JOIN mmag_feature_product fp_2 ON (p.id_product = fp_2.id_product) LEFT JOIN mmag_feature_product fp_3 ON (p.id_product = fp_3.id_product) WHERE ((fp.id_feature=13)) AND ((sp_1.reduction>0)) AND ((fp_2.id_feature_value IN (1192, 1247, 1239, 1235, 1229, 1220, 1215, 1212, 1206, 1194, 1173, 1155, 774, 1167, 776))) AND ((fp_3.id_feature_value IN (808, 815, 833))) GROUP BY fp.id_feature_value	3.131 ms	98784	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:778 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:855 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:154 (getFeaturesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:357 (runQuery) /override/controllers/front/listing/CategoryController.php:22 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (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, pl.name FROM mmag_product p LEFT JOIN mmag_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mmag_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN mmag_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 mmag_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN mmag_product_lang pl ON (p.id_product = pl.id_product AND pl.id_shop = 1 AND pl.id_lang = 1) INNER JOIN mmag_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN mmag_category_product cp ON (p.id_product = cp.id_product) INNER JOIN mmag_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN mmag_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN mmag_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, 36) 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-04-25 20:00:56' >= sp.from) AND (sp.to = '0000-00-00 00:00:00' OR '2025-04-25 20:00:56' <= sp.to) ) LEFT JOIN mmag_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN mmag_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((sp.reduction>0)) AND ((fp_1.id_feature_value IN (1192, 1247, 1239, 1235, 1229, 1220, 1215, 1212, 1206, 1194, 1173, 1155, 774, 1167, 776))) AND ((fp_2.id_feature_value IN (808, 815, 833))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=9 AND c.nright<=24 GROUP BY p.id_product) p INNER JOIN mmag_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN mmag_specific_price sp_1 ON ( sp_1.id_product = p.id_product AND sp_1.id_shop IN (0, 1) AND sp_1.id_currency IN (0, 1) AND sp_1.id_country IN (0, 36) AND sp_1.id_group IN (0, 1) AND sp_1.from_quantity = 1 AND sp_1.reduction > 0 AND sp_1.id_customer = 0 AND sp_1.id_cart = 0 AND (sp_1.from = '0000-00-00 00:00:00' OR '2025-04-25 20:00:56' >= sp_1.from) AND (sp_1.to = '0000-00-00 00:00:00' OR '2025-04-25 20:00:56' <= sp_1.to) ) LEFT JOIN mmag_feature_product fp_2 ON (p.id_product = fp_2.id_product) LEFT JOIN mmag_feature_product fp_3 ON (p.id_product = fp_3.id_product) WHERE ((fp.id_feature=11)) AND ((sp_1.reduction>0)) AND ((fp_2.id_feature_value IN (1192, 1247, 1239, 1235, 1229, 1220, 1215, 1212, 1206, 1194, 1173, 1155, 774, 1167, 776))) AND ((fp_3.id_feature_value IN (808, 815, 833))) GROUP BY fp.id_feature_value	3.128 ms	98784	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:778 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:855 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:154 (getFeaturesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:357 (runQuery) /override/controllers/front/listing/CategoryController.php:22 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
151	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, pl.name FROM mmag_product p LEFT JOIN mmag_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mmag_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN mmag_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 mmag_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN mmag_product_lang pl ON (p.id_product = pl.id_product AND pl.id_shop = 1 AND pl.id_lang = 1) INNER JOIN mmag_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN mmag_category_product cp ON (p.id_product = cp.id_product) INNER JOIN mmag_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN mmag_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN mmag_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, 36) 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-04-25 20:00:56' >= sp.from) AND (sp.to = '0000-00-00 00:00:00' OR '2025-04-25 20:00:56' <= sp.to) ) LEFT JOIN mmag_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN mmag_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((sp.reduction>0)) AND ((fp_1.id_feature_value IN (1192, 1247, 1239, 1235, 1229, 1220, 1215, 1212, 1206, 1194, 1173, 1155, 774, 1167, 776))) AND ((fp_2.id_feature_value IN (808, 815, 833))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=9 AND c.nright<=24 GROUP BY p.id_product) p INNER JOIN mmag_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN mmag_specific_price sp_1 ON ( sp_1.id_product = p.id_product AND sp_1.id_shop IN (0, 1) AND sp_1.id_currency IN (0, 1) AND sp_1.id_country IN (0, 36) AND sp_1.id_group IN (0, 1) AND sp_1.from_quantity = 1 AND sp_1.reduction > 0 AND sp_1.id_customer = 0 AND sp_1.id_cart = 0 AND (sp_1.from = '0000-00-00 00:00:00' OR '2025-04-25 20:00:56' >= sp_1.from) AND (sp_1.to = '0000-00-00 00:00:00' OR '2025-04-25 20:00:56' <= sp_1.to) ) LEFT JOIN mmag_feature_product fp_2 ON (p.id_product = fp_2.id_product) LEFT JOIN mmag_feature_product fp_3 ON (p.id_product = fp_3.id_product) WHERE ((fp.id_feature=23)) AND ((sp_1.reduction>0)) AND ((fp_2.id_feature_value IN (1192, 1247, 1239, 1235, 1229, 1220, 1215, 1212, 1206, 1194, 1173, 1155, 774, 1167, 776))) AND ((fp_3.id_feature_value IN (808, 815, 833))) GROUP BY fp.id_feature_value	3.106 ms	98784	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:778 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:855 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:154 (getFeaturesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:357 (runQuery) /override/controllers/front/listing/CategoryController.php:22 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
138	SELECT SQL_NO_CACHE 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, pl.name FROM mmag_product p LEFT JOIN mmag_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mmag_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN mmag_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 mmag_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN mmag_product_lang pl ON (p.id_product = pl.id_product AND pl.id_shop = 1 AND pl.id_lang = 1) INNER JOIN mmag_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN mmag_category_product cp ON (p.id_product = cp.id_product) INNER JOIN mmag_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN mmag_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN mmag_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, 36) 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-04-25 20:00:56' >= sp.from) AND (sp.to = '0000-00-00 00:00:00' OR '2025-04-25 20:00:56' <= sp.to) ) LEFT JOIN mmag_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN mmag_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((sp.reduction>0)) AND ((fp_1.id_feature_value IN (1192, 1247, 1239, 1235, 1229, 1220, 1215, 1212, 1206, 1194, 1173, 1155, 774, 1167, 776))) AND ((fp_2.id_feature_value IN (808, 815, 833))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=9 AND c.nright<=24 GROUP BY p.id_product) p INNER JOIN mmag_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN mmag_specific_price sp_1 ON ( sp_1.id_product = p.id_product AND sp_1.id_shop IN (0, 1) AND sp_1.id_currency IN (0, 1) AND sp_1.id_country IN (0, 36) AND sp_1.id_group IN (0, 1) AND sp_1.from_quantity = 1 AND sp_1.reduction > 0 AND sp_1.id_customer = 0 AND sp_1.id_cart = 0 AND (sp_1.from = '0000-00-00 00:00:00' OR '2025-04-25 20:00:56' >= sp_1.from) AND (sp_1.to = '0000-00-00 00:00:00' OR '2025-04-25 20:00:56' <= sp_1.to) ) LEFT JOIN mmag_feature_product fp_2 ON (p.id_product = fp_2.id_product) LEFT JOIN mmag_feature_product fp_3 ON (p.id_product = fp_3.id_product) WHERE ((fp.id_feature=14)) AND ((sp_1.reduction>0)) AND ((fp_2.id_feature_value IN (1192, 1247, 1239, 1235, 1229, 1220, 1215, 1212, 1206, 1194, 1173, 1155, 774, 1167, 776))) AND ((fp_3.id_feature_value IN (808, 815, 833))) GROUP BY fp.id_feature_value	3.099 ms	98784	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:778 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:855 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:154 (getFeaturesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:357 (runQuery) /override/controllers/front/listing/CategoryController.php:22 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
145	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, pl.name FROM mmag_product p LEFT JOIN mmag_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mmag_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN mmag_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 mmag_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN mmag_product_lang pl ON (p.id_product = pl.id_product AND pl.id_shop = 1 AND pl.id_lang = 1) INNER JOIN mmag_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN mmag_category_product cp ON (p.id_product = cp.id_product) INNER JOIN mmag_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN mmag_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN mmag_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, 36) 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-04-25 20:00:56' >= sp.from) AND (sp.to = '0000-00-00 00:00:00' OR '2025-04-25 20:00:56' <= sp.to) ) LEFT JOIN mmag_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN mmag_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((sp.reduction>0)) AND ((fp_1.id_feature_value IN (1192, 1247, 1239, 1235, 1229, 1220, 1215, 1212, 1206, 1194, 1173, 1155, 774, 1167, 776))) AND ((fp_2.id_feature_value IN (808, 815, 833))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=9 AND c.nright<=24 GROUP BY p.id_product) p INNER JOIN mmag_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN mmag_specific_price sp_1 ON ( sp_1.id_product = p.id_product AND sp_1.id_shop IN (0, 1) AND sp_1.id_currency IN (0, 1) AND sp_1.id_country IN (0, 36) AND sp_1.id_group IN (0, 1) AND sp_1.from_quantity = 1 AND sp_1.reduction > 0 AND sp_1.id_customer = 0 AND sp_1.id_cart = 0 AND (sp_1.from = '0000-00-00 00:00:00' OR '2025-04-25 20:00:56' >= sp_1.from) AND (sp_1.to = '0000-00-00 00:00:00' OR '2025-04-25 20:00:56' <= sp_1.to) ) LEFT JOIN mmag_feature_product fp_2 ON (p.id_product = fp_2.id_product) LEFT JOIN mmag_feature_product fp_3 ON (p.id_product = fp_3.id_product) WHERE ((fp.id_feature=20)) AND ((sp_1.reduction>0)) AND ((fp_2.id_feature_value IN (1192, 1247, 1239, 1235, 1229, 1220, 1215, 1212, 1206, 1194, 1173, 1155, 774, 1167, 776))) AND ((fp_3.id_feature_value IN (808, 815, 833))) GROUP BY fp.id_feature_value	3.090 ms	98784	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:778 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:855 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:154 (getFeaturesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:357 (runQuery) /override/controllers/front/listing/CategoryController.php:22 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
149	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, pl.name FROM mmag_product p LEFT JOIN mmag_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mmag_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN mmag_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 mmag_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN mmag_product_lang pl ON (p.id_product = pl.id_product AND pl.id_shop = 1 AND pl.id_lang = 1) INNER JOIN mmag_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN mmag_category_product cp ON (p.id_product = cp.id_product) INNER JOIN mmag_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN mmag_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN mmag_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, 36) 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-04-25 20:00:56' >= sp.from) AND (sp.to = '0000-00-00 00:00:00' OR '2025-04-25 20:00:56' <= sp.to) ) LEFT JOIN mmag_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN mmag_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((sp.reduction>0)) AND ((fp_1.id_feature_value IN (1192, 1247, 1239, 1235, 1229, 1220, 1215, 1212, 1206, 1194, 1173, 1155, 774, 1167, 776))) AND ((fp_2.id_feature_value IN (808, 815, 833))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=9 AND c.nright<=24 GROUP BY p.id_product) p INNER JOIN mmag_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN mmag_specific_price sp_1 ON ( sp_1.id_product = p.id_product AND sp_1.id_shop IN (0, 1) AND sp_1.id_currency IN (0, 1) AND sp_1.id_country IN (0, 36) AND sp_1.id_group IN (0, 1) AND sp_1.from_quantity = 1 AND sp_1.reduction > 0 AND sp_1.id_customer = 0 AND sp_1.id_cart = 0 AND (sp_1.from = '0000-00-00 00:00:00' OR '2025-04-25 20:00:56' >= sp_1.from) AND (sp_1.to = '0000-00-00 00:00:00' OR '2025-04-25 20:00:56' <= sp_1.to) ) LEFT JOIN mmag_feature_product fp_2 ON (p.id_product = fp_2.id_product) LEFT JOIN mmag_feature_product fp_3 ON (p.id_product = fp_3.id_product) WHERE ((fp.id_feature=22)) AND ((sp_1.reduction>0)) AND ((fp_2.id_feature_value IN (1192, 1247, 1239, 1235, 1229, 1220, 1215, 1212, 1206, 1194, 1173, 1155, 774, 1167, 776))) AND ((fp_3.id_feature_value IN (808, 815, 833))) GROUP BY fp.id_feature_value	3.075 ms	98784	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:778 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:855 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:154 (getFeaturesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:357 (runQuery) /override/controllers/front/listing/CategoryController.php:22 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
20	SELECT SQL_NO_CACHE h.`name` as hook, m.`id_module`, h.`id_hook`, m.`name` as module FROM `mmag_module` m INNER JOIN mmag_module_shop module_shop ON (module_shop.id_module = m.id_module AND module_shop.id_shop = 1 AND module_shop.enable_device & 1) INNER JOIN `mmag_hook_module` `hm` ON hm.`id_module` = m.`id_module` INNER JOIN `mmag_hook` `h` ON hm.`id_hook` = h.`id_hook` LEFT JOIN `mmag_module_group` `mg` ON mg.`id_module` = m.`id_module` WHERE (h.`name` != "paymentOptions") AND (hm.`id_shop` = 1) AND (mg.id_shop = 1 AND mg.`id_group` IN (1)) GROUP BY hm.id_hook, hm.id_module ORDER BY hm.`position`	3.047 ms	2052	Yes	Yes	/classes/Hook.php:1289 /classes/Hook.php:738 (getAllHookRegistrations) /classes/Hook.php:848 (getHookModuleExecList) /classes/Dispatcher.php:606 (exec) /override/classes/Dispatcher.php:90 (loadRoutes) /classes/Dispatcher.php:243 (loadRoutes) /override/classes/Dispatcher.php:42 (__construct) /classes/Dispatcher.php:201 (__construct) /index.php:28 (getInstance)
90	SELECT SQL_NO_CACHE p.id_product FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, pl.name FROM mmag_product p LEFT JOIN mmag_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mmag_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN mmag_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 mmag_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN mmag_product_lang pl ON (p.id_product = pl.id_product AND pl.id_shop = 1 AND pl.id_lang = 1) INNER JOIN mmag_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN mmag_category_product cp ON (p.id_product = cp.id_product) INNER JOIN mmag_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN mmag_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN mmag_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, 36) 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-04-25 20:00:55' >= sp.from) AND (sp.to = '0000-00-00 00:00:00' OR '2025-04-25 20:00:55' <= sp.to) ) LEFT JOIN mmag_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN mmag_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((sp.reduction>0)) AND ((fp_1.id_feature_value IN (1192, 1247, 1239, 1235, 1229, 1220, 1215, 1212, 1206, 1194, 1173, 1155, 774, 1167, 776))) AND ((fp_2.id_feature_value IN (808, 815, 833))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=9 AND c.nright<=24 GROUP BY p.id_product) p INNER JOIN mmag_product_lang pl ON (p.id_product = pl.id_product AND pl.id_shop = 1 AND pl.id_lang = 1) GROUP BY p.id_product ORDER BY p.name ASC, p.id_product DESC	3.033 ms	672	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Filters/Products.php:87 (execute) /modules/ps_facetedsearch/src/Product/SearchProvider.php:187 (getProductByFilters) /classes/controller/ProductListingFrontController.php:357 (runQuery) /override/controllers/front/listing/CategoryController.php:22 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (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, pl.name FROM mmag_product p LEFT JOIN mmag_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mmag_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN mmag_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 mmag_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN mmag_product_lang pl ON (p.id_product = pl.id_product AND pl.id_shop = 1 AND pl.id_lang = 1) INNER JOIN mmag_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN mmag_category_product cp ON (p.id_product = cp.id_product) INNER JOIN mmag_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN mmag_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN mmag_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, 36) 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-04-25 20:00:56' >= sp.from) AND (sp.to = '0000-00-00 00:00:00' OR '2025-04-25 20:00:56' <= sp.to) ) LEFT JOIN mmag_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN mmag_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((sp.reduction>0)) AND ((fp_1.id_feature_value IN (1192, 1247, 1239, 1235, 1229, 1220, 1215, 1212, 1206, 1194, 1173, 1155, 774, 1167, 776))) AND ((fp_2.id_feature_value IN (808, 815, 833))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=9 AND c.nright<=24 GROUP BY p.id_product) p INNER JOIN mmag_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN mmag_specific_price sp_1 ON ( sp_1.id_product = p.id_product AND sp_1.id_shop IN (0, 1) AND sp_1.id_currency IN (0, 1) AND sp_1.id_country IN (0, 36) AND sp_1.id_group IN (0, 1) AND sp_1.from_quantity = 1 AND sp_1.reduction > 0 AND sp_1.id_customer = 0 AND sp_1.id_cart = 0 AND (sp_1.from = '0000-00-00 00:00:00' OR '2025-04-25 20:00:56' >= sp_1.from) AND (sp_1.to = '0000-00-00 00:00:00' OR '2025-04-25 20:00:56' <= sp_1.to) ) LEFT JOIN mmag_feature_product fp_2 ON (p.id_product = fp_2.id_product) LEFT JOIN mmag_feature_product fp_3 ON (p.id_product = fp_3.id_product) WHERE ((fp.id_feature=7)) AND ((sp_1.reduction>0)) AND ((fp_2.id_feature_value IN (1192, 1247, 1239, 1235, 1229, 1220, 1215, 1212, 1206, 1194, 1173, 1155, 774, 1167, 776))) AND ((fp_3.id_feature_value IN (808, 815, 833))) GROUP BY fp.id_feature_value	3.023 ms	98784	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:778 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:855 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:154 (getFeaturesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:357 (runQuery) /override/controllers/front/listing/CategoryController.php:22 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
95	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, pl.name FROM mmag_product p LEFT JOIN mmag_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mmag_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN mmag_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 mmag_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN mmag_product_lang pl ON (p.id_product = pl.id_product AND pl.id_shop = 1 AND pl.id_lang = 1) INNER JOIN mmag_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN mmag_category_product cp ON (p.id_product = cp.id_product) INNER JOIN mmag_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN mmag_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN mmag_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, 36) 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-04-25 20:00:55' >= sp.from) AND (sp.to = '0000-00-00 00:00:00' OR '2025-04-25 20:00:55' <= sp.to) ) LEFT JOIN mmag_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN mmag_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((sp.reduction>0)) AND ((fp_1.id_feature_value IN (1192, 1247, 1239, 1235, 1229, 1220, 1215, 1212, 1206, 1194, 1173, 1155, 774, 1167, 776))) AND ((fp_2.id_feature_value IN (808, 815, 833))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=9 AND c.nright<=24 GROUP BY p.id_product) p LEFT JOIN mmag_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mmag_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN mmag_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 mmag_specific_price sp_1 ON ( sp_1.id_product = p.id_product AND sp_1.id_shop IN (0, 1) AND sp_1.id_currency IN (0, 1) AND sp_1.id_country IN (0, 36) AND sp_1.id_group IN (0, 1) AND sp_1.from_quantity = 1 AND sp_1.reduction > 0 AND sp_1.id_customer = 0 AND sp_1.id_cart = 0 AND (sp_1.from = '0000-00-00 00:00:00' OR '2025-04-25 20:00:55' >= sp_1.from) AND (sp_1.to = '0000-00-00 00:00:00' OR '2025-04-25 20:00:55' <= sp_1.to) ) LEFT JOIN mmag_feature_product fp_2 ON (p.id_product = fp_2.id_product) LEFT JOIN mmag_feature_product fp_3 ON (p.id_product = fp_3.id_product) WHERE ((sa.quantity>0)) AND ((sp_1.reduction>0)) AND ((fp_2.id_feature_value IN (1192, 1247, 1239, 1235, 1229, 1220, 1215, 1212, 1206, 1194, 1173, 1155, 774, 1167, 776))) AND ((fp_3.id_feature_value IN (808, 815, 833)))	3.018 ms	98784			/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:778 (execute) /modules/ps_facetedsearch/src/Adapter/MySQL.php:757 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:505 (count) /modules/ps_facetedsearch/src/Filters/Block.php:140 (getAvailabilitiesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:357 (runQuery) /override/controllers/front/listing/CategoryController.php:22 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
111	SELECT SQL_NO_CACHE p.condition, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, pl.name FROM mmag_product p LEFT JOIN mmag_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mmag_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN mmag_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 mmag_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN mmag_product_lang pl ON (p.id_product = pl.id_product AND pl.id_shop = 1 AND pl.id_lang = 1) INNER JOIN mmag_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN mmag_category_product cp ON (p.id_product = cp.id_product) INNER JOIN mmag_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN mmag_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN mmag_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, 36) 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-04-25 20:00:56' >= sp.from) AND (sp.to = '0000-00-00 00:00:00' OR '2025-04-25 20:00:56' <= sp.to) ) LEFT JOIN mmag_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN mmag_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((sp.reduction>0)) AND ((fp_1.id_feature_value IN (1192, 1247, 1239, 1235, 1229, 1220, 1215, 1212, 1206, 1194, 1173, 1155, 774, 1167, 776))) AND ((fp_2.id_feature_value IN (808, 815, 833))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=9 AND c.nright<=24 GROUP BY p.id_product) p LEFT JOIN mmag_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, 36) 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-04-25 20:00:56' >= sp.from) AND (sp.to = '0000-00-00 00:00:00' OR '2025-04-25 20:00:56' <= sp.to) ) LEFT JOIN mmag_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN mmag_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((sp.reduction>0)) AND ((fp_1.id_feature_value IN (1192, 1247, 1239, 1235, 1229, 1220, 1215, 1212, 1206, 1194, 1173, 1155, 774, 1167, 776))) AND ((fp_2.id_feature_value IN (808, 815, 833))) GROUP BY p.condition	2.926 ms	98784	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:778 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:394 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:137 (getConditionsBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:357 (runQuery) /override/controllers/front/listing/CategoryController.php:22 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
110	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, pl.name FROM mmag_product p LEFT JOIN mmag_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mmag_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN mmag_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 mmag_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN mmag_product_lang pl ON (p.id_product = pl.id_product AND pl.id_shop = 1 AND pl.id_lang = 1) INNER JOIN mmag_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN mmag_category_product cp ON (p.id_product = cp.id_product) INNER JOIN mmag_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN mmag_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN mmag_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, 36) 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-04-25 20:00:55' >= sp.from) AND (sp.to = '0000-00-00 00:00:00' OR '2025-04-25 20:00:55' <= sp.to) ) LEFT JOIN mmag_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN mmag_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((sp.reduction>0)) AND ((fp_1.id_feature_value IN (1192, 1247, 1239, 1235, 1229, 1220, 1215, 1212, 1206, 1194, 1173, 1155, 774, 1167, 776))) AND ((fp_2.id_feature_value IN (808, 815, 833))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=9 AND c.nright<=24 GROUP BY p.id_product) p LEFT JOIN mmag_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, 36) 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-04-25 20:00:55' >= sp.from) AND (sp.to = '0000-00-00 00:00:00' OR '2025-04-25 20:00:55' <= sp.to) ) LEFT JOIN mmag_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN mmag_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((sp.reduction>0)) AND ((fp_1.id_feature_value IN (1192, 1247, 1239, 1235, 1229, 1220, 1215, 1212, 1206, 1194, 1173, 1155, 774, 1167, 776))) AND ((fp_2.id_feature_value IN (808, 815, 833))) GROUP BY p.id_manufacturer	2.887 ms	98784	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:778 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:661 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:146 (getManufacturersBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:357 (runQuery) /override/controllers/front/listing/CategoryController.php:22 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
97	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, pl.name FROM mmag_product p LEFT JOIN mmag_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mmag_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN mmag_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 mmag_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN mmag_product_lang pl ON (p.id_product = pl.id_product AND pl.id_shop = 1 AND pl.id_lang = 1) INNER JOIN mmag_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN mmag_category_product cp ON (p.id_product = cp.id_product) INNER JOIN mmag_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN mmag_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN mmag_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, 36) 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-04-25 20:00:55' >= sp.from) AND (sp.to = '0000-00-00 00:00:00' OR '2025-04-25 20:00:55' <= sp.to) ) LEFT JOIN mmag_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN mmag_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((sp.reduction>0)) AND ((fp_1.id_feature_value IN (1192, 1247, 1239, 1235, 1229, 1220, 1215, 1212, 1206, 1194, 1173, 1155, 774, 1167, 776))) AND ((fp_2.id_feature_value IN (808, 815, 833))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=9 AND c.nright<=24 GROUP BY p.id_product) p LEFT JOIN mmag_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, 36) 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-04-25 20:00:55' >= sp.from) AND (sp.to = '0000-00-00 00:00:00' OR '2025-04-25 20:00:55' <= sp.to) ) LEFT JOIN mmag_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN mmag_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((sp.reduction>0)) AND ((fp_1.id_feature_value IN (1192, 1247, 1239, 1235, 1229, 1220, 1215, 1212, 1206, 1194, 1173, 1155, 774, 1167, 776))) AND ((fp_2.id_feature_value IN (808, 815, 833))) AND p.date_add>'2025-04-06 00:00:00'	2.762 ms	98784			/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:778 (execute) /modules/ps_facetedsearch/src/Adapter/MySQL.php:757 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:587 (count) /modules/ps_facetedsearch/src/Filters/Block.php:143 (getHighlightsBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:357 (runQuery) /override/controllers/front/listing/CategoryController.php:22 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
120	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, pl.name FROM mmag_product p LEFT JOIN mmag_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mmag_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN mmag_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 mmag_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN mmag_product_lang pl ON (p.id_product = pl.id_product AND pl.id_shop = 1 AND pl.id_lang = 1) INNER JOIN mmag_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN mmag_category_product cp ON (p.id_product = cp.id_product) INNER JOIN mmag_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN mmag_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN mmag_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, 36) 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-04-25 20:00:56' >= sp.from) AND (sp.to = '0000-00-00 00:00:00' OR '2025-04-25 20:00:56' <= sp.to) ) LEFT JOIN mmag_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN mmag_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((sp.reduction>0)) AND ((fp_1.id_feature_value IN (1192, 1247, 1239, 1235, 1229, 1220, 1215, 1212, 1206, 1194, 1173, 1155, 774, 1167, 776))) AND ((fp_2.id_feature_value IN (808, 815, 833))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=9 AND c.nright<=24 GROUP BY p.id_product) p LEFT JOIN mmag_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mmag_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) INNER JOIN mmag_attribute a ON (a.id_attribute = pac.id_attribute) LEFT JOIN mmag_specific_price sp_1 ON ( sp_1.id_product = p.id_product AND sp_1.id_shop IN (0, 1) AND sp_1.id_currency IN (0, 1) AND sp_1.id_country IN (0, 36) AND sp_1.id_group IN (0, 1) AND sp_1.from_quantity = 1 AND sp_1.reduction > 0 AND sp_1.id_customer = 0 AND sp_1.id_cart = 0 AND (sp_1.from = '0000-00-00 00:00:00' OR '2025-04-25 20:00:56' >= sp_1.from) AND (sp_1.to = '0000-00-00 00:00:00' OR '2025-04-25 20:00:56' <= sp_1.to) ) LEFT JOIN mmag_feature_product fp_2 ON (p.id_product = fp_2.id_product) LEFT JOIN mmag_feature_product fp_3 ON (p.id_product = fp_3.id_product) WHERE ((a.id_attribute_group=4)) AND ((sp_1.reduction>0)) AND ((fp_2.id_feature_value IN (1192, 1247, 1239, 1235, 1229, 1220, 1215, 1212, 1206, 1194, 1173, 1155, 774, 1167, 776))) AND ((fp_3.id_feature_value IN (808, 815, 833))) GROUP BY pac.id_attribute	2.658 ms	98784	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:778 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:737 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:150 (getAttributesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:357 (runQuery) /override/controllers/front/listing/CategoryController.php:22 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
102	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, pl.name FROM mmag_product p LEFT JOIN mmag_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mmag_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN mmag_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 mmag_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN mmag_product_lang pl ON (p.id_product = pl.id_product AND pl.id_shop = 1 AND pl.id_lang = 1) INNER JOIN mmag_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN mmag_category_product cp ON (p.id_product = cp.id_product) INNER JOIN mmag_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN mmag_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN mmag_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, 36) 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-04-25 20:00:55' >= sp.from) AND (sp.to = '0000-00-00 00:00:00' OR '2025-04-25 20:00:55' <= sp.to) ) LEFT JOIN mmag_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN mmag_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((sp.reduction>0)) AND ((fp_1.id_feature_value IN (1192, 1247, 1239, 1235, 1229, 1220, 1215, 1212, 1206, 1194, 1173, 1155, 774, 1167, 776))) AND ((fp_2.id_feature_value IN (808, 815, 833))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=9 AND c.nright<=24 GROUP BY p.id_product) p LEFT JOIN mmag_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mmag_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) INNER JOIN mmag_attribute a ON (a.id_attribute = pac.id_attribute) LEFT JOIN mmag_specific_price sp_1 ON ( sp_1.id_product = p.id_product AND sp_1.id_shop IN (0, 1) AND sp_1.id_currency IN (0, 1) AND sp_1.id_country IN (0, 36) AND sp_1.id_group IN (0, 1) AND sp_1.from_quantity = 1 AND sp_1.reduction > 0 AND sp_1.id_customer = 0 AND sp_1.id_cart = 0 AND (sp_1.from = '0000-00-00 00:00:00' OR '2025-04-25 20:00:55' >= sp_1.from) AND (sp_1.to = '0000-00-00 00:00:00' OR '2025-04-25 20:00:55' <= sp_1.to) ) LEFT JOIN mmag_feature_product fp_2 ON (p.id_product = fp_2.id_product) LEFT JOIN mmag_feature_product fp_3 ON (p.id_product = fp_3.id_product) WHERE ((a.id_attribute_group=1)) AND ((sp_1.reduction>0)) AND ((fp_2.id_feature_value IN (1192, 1247, 1239, 1235, 1229, 1220, 1215, 1212, 1206, 1194, 1173, 1155, 774, 1167, 776))) AND ((fp_3.id_feature_value IN (808, 815, 833))) GROUP BY pac.id_attribute	2.617 ms	98784	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:778 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:737 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:150 (getAttributesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:357 (runQuery) /override/controllers/front/listing/CategoryController.php:22 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
116	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, pl.name FROM mmag_product p LEFT JOIN mmag_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mmag_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN mmag_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 mmag_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN mmag_product_lang pl ON (p.id_product = pl.id_product AND pl.id_shop = 1 AND pl.id_lang = 1) INNER JOIN mmag_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN mmag_category_product cp ON (p.id_product = cp.id_product) INNER JOIN mmag_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN mmag_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN mmag_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, 36) 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-04-25 20:00:56' >= sp.from) AND (sp.to = '0000-00-00 00:00:00' OR '2025-04-25 20:00:56' <= sp.to) ) LEFT JOIN mmag_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN mmag_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((sp.reduction>0)) AND ((fp_1.id_feature_value IN (1192, 1247, 1239, 1235, 1229, 1220, 1215, 1212, 1206, 1194, 1173, 1155, 774, 1167, 776))) AND ((fp_2.id_feature_value IN (808, 815, 833))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=9 AND c.nright<=24 GROUP BY p.id_product) p LEFT JOIN mmag_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mmag_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) INNER JOIN mmag_attribute a ON (a.id_attribute = pac.id_attribute) LEFT JOIN mmag_specific_price sp_1 ON ( sp_1.id_product = p.id_product AND sp_1.id_shop IN (0, 1) AND sp_1.id_currency IN (0, 1) AND sp_1.id_country IN (0, 36) AND sp_1.id_group IN (0, 1) AND sp_1.from_quantity = 1 AND sp_1.reduction > 0 AND sp_1.id_customer = 0 AND sp_1.id_cart = 0 AND (sp_1.from = '0000-00-00 00:00:00' OR '2025-04-25 20:00:56' >= sp_1.from) AND (sp_1.to = '0000-00-00 00:00:00' OR '2025-04-25 20:00:56' <= sp_1.to) ) LEFT JOIN mmag_feature_product fp_2 ON (p.id_product = fp_2.id_product) LEFT JOIN mmag_feature_product fp_3 ON (p.id_product = fp_3.id_product) WHERE ((a.id_attribute_group=7)) AND ((sp_1.reduction>0)) AND ((fp_2.id_feature_value IN (1192, 1247, 1239, 1235, 1229, 1220, 1215, 1212, 1206, 1194, 1173, 1155, 774, 1167, 776))) AND ((fp_3.id_feature_value IN (808, 815, 833))) GROUP BY pac.id_attribute	2.609 ms	98784	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:778 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:737 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:150 (getAttributesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:357 (runQuery) /override/controllers/front/listing/CategoryController.php:22 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (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, pl.name FROM mmag_product p LEFT JOIN mmag_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mmag_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN mmag_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 mmag_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN mmag_product_lang pl ON (p.id_product = pl.id_product AND pl.id_shop = 1 AND pl.id_lang = 1) INNER JOIN mmag_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN mmag_category_product cp ON (p.id_product = cp.id_product) INNER JOIN mmag_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN mmag_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN mmag_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, 36) 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-04-25 20:00:56' >= sp.from) AND (sp.to = '0000-00-00 00:00:00' OR '2025-04-25 20:00:56' <= sp.to) ) LEFT JOIN mmag_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN mmag_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((sp.reduction>0)) AND ((fp_1.id_feature_value IN (1192, 1247, 1239, 1235, 1229, 1220, 1215, 1212, 1206, 1194, 1173, 1155, 774, 1167, 776))) AND ((fp_2.id_feature_value IN (808, 815, 833))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=9 AND c.nright<=24 GROUP BY p.id_product) p INNER JOIN mmag_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN mmag_specific_price sp_1 ON ( sp_1.id_product = p.id_product AND sp_1.id_shop IN (0, 1) AND sp_1.id_currency IN (0, 1) AND sp_1.id_country IN (0, 36) AND sp_1.id_group IN (0, 1) AND sp_1.from_quantity = 1 AND sp_1.reduction > 0 AND sp_1.id_customer = 0 AND sp_1.id_cart = 0 AND (sp_1.from = '0000-00-00 00:00:00' OR '2025-04-25 20:00:56' >= sp_1.from) AND (sp_1.to = '0000-00-00 00:00:00' OR '2025-04-25 20:00:56' <= sp_1.to) ) LEFT JOIN mmag_feature_product fp_2 ON (p.id_product = fp_2.id_product) LEFT JOIN mmag_feature_product fp_3 ON (p.id_product = fp_3.id_product) WHERE ((fp.id_feature=6)) AND ((sp_1.reduction>0)) AND ((fp_2.id_feature_value IN (1192, 1247, 1239, 1235, 1229, 1220, 1215, 1212, 1206, 1194, 1173, 1155, 774, 1167, 776))) AND ((fp_3.id_feature_value IN (808, 815, 833))) GROUP BY fp.id_feature_value	2.557 ms	98784	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:778 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:855 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:154 (getFeaturesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:357 (runQuery) /override/controllers/front/listing/CategoryController.php:22 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
169	SELECT SQL_NO_CACHE h.id_hook, h.name as h_name, title, description, h.position, hm.position as hm_position, m.id_module, m.name, m.active FROM `mmag_hook_module` hm STRAIGHT_JOIN `mmag_hook` h ON (h.id_hook = hm.id_hook AND hm.id_shop = 1) STRAIGHT_JOIN `mmag_module` as m ON (m.id_module = hm.id_module) ORDER BY hm.position	2.426 ms	586			/classes/Hook.php:459 /classes/Hook.php:496 (getHookModuleList) /classes/tax/TaxManagerFactory.php:67 (getModulesFromHook) /classes/tax/TaxManagerFactory.php:46 (execHookTaxManagerFactory) /classes/Product.php:3925 (getManager) /classes/Product.php:3717 (priceCalculation) /classes/Product.php:5692 (getPriceStatic) /classes/ProductAssembler.php:209 (getProductProperties) /override/classes/ProductAssembler.php:55 (assembleProducts) /classes/controller/ProductListingFrontController.php:108 (assembleProducts) /classes/controller/ProductListingFrontController.php:379 (prepareMultipleProductsForTemplate) /override/controllers/front/listing/CategoryController.php:22 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
121	SELECT SQL_NO_CACHE fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, pl.name FROM mmag_product p LEFT JOIN mmag_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mmag_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN mmag_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 mmag_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN mmag_product_lang pl ON (p.id_product = pl.id_product AND pl.id_shop = 1 AND pl.id_lang = 1) INNER JOIN mmag_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN mmag_category_product cp ON (p.id_product = cp.id_product) INNER JOIN mmag_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN mmag_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN mmag_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, 36) 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-04-25 20:00:56' >= sp.from) AND (sp.to = '0000-00-00 00:00:00' OR '2025-04-25 20:00:56' <= sp.to) ) LEFT JOIN mmag_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN mmag_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((sp.reduction>0)) AND ((fp_1.id_feature_value IN (1192, 1247, 1239, 1235, 1229, 1220, 1215, 1212, 1206, 1194, 1173, 1155, 774, 1167, 776))) AND ((fp_2.id_feature_value IN (808, 815, 833))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=9 AND c.nright<=24 GROUP BY p.id_product) p INNER JOIN mmag_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN mmag_specific_price sp_1 ON ( sp_1.id_product = p.id_product AND sp_1.id_shop IN (0, 1) AND sp_1.id_currency IN (0, 1) AND sp_1.id_country IN (0, 36) AND sp_1.id_group IN (0, 1) AND sp_1.from_quantity = 1 AND sp_1.reduction > 0 AND sp_1.id_customer = 0 AND sp_1.id_cart = 0 AND (sp_1.from = '0000-00-00 00:00:00' OR '2025-04-25 20:00:56' >= sp_1.from) AND (sp_1.to = '0000-00-00 00:00:00' OR '2025-04-25 20:00:56' <= sp_1.to) ) LEFT JOIN mmag_feature_product fp_2 ON (p.id_product = fp_2.id_product) LEFT JOIN mmag_feature_product fp_3 ON (p.id_product = fp_3.id_product) WHERE ((fp.id_feature=3)) AND ((sp_1.reduction>0)) AND ((fp_2.id_feature_value IN (1192, 1247, 1239, 1235, 1229, 1220, 1215, 1212, 1206, 1194, 1173, 1155, 774, 1167, 776))) AND ((fp_3.id_feature_value IN (808, 815, 833))) GROUP BY fp.id_feature_value	2.409 ms	197568	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:778 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:855 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:154 (getFeaturesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:357 (runQuery) /override/controllers/front/listing/CategoryController.php:22 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
104	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, pl.name FROM mmag_product p LEFT JOIN mmag_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mmag_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN mmag_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 mmag_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN mmag_product_lang pl ON (p.id_product = pl.id_product AND pl.id_shop = 1 AND pl.id_lang = 1) INNER JOIN mmag_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN mmag_category_product cp ON (p.id_product = cp.id_product) INNER JOIN mmag_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN mmag_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN mmag_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, 36) 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-04-25 20:00:55' >= sp.from) AND (sp.to = '0000-00-00 00:00:00' OR '2025-04-25 20:00:55' <= sp.to) ) LEFT JOIN mmag_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN mmag_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((sp.reduction>0)) AND ((fp_1.id_feature_value IN (1192, 1247, 1239, 1235, 1229, 1220, 1215, 1212, 1206, 1194, 1173, 1155, 774, 1167, 776))) AND ((fp_2.id_feature_value IN (808, 815, 833))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=9 AND c.nright<=24 GROUP BY p.id_product) p LEFT JOIN mmag_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mmag_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) INNER JOIN mmag_attribute a ON (a.id_attribute = pac.id_attribute) LEFT JOIN mmag_specific_price sp_1 ON ( sp_1.id_product = p.id_product AND sp_1.id_shop IN (0, 1) AND sp_1.id_currency IN (0, 1) AND sp_1.id_country IN (0, 36) AND sp_1.id_group IN (0, 1) AND sp_1.from_quantity = 1 AND sp_1.reduction > 0 AND sp_1.id_customer = 0 AND sp_1.id_cart = 0 AND (sp_1.from = '0000-00-00 00:00:00' OR '2025-04-25 20:00:55' >= sp_1.from) AND (sp_1.to = '0000-00-00 00:00:00' OR '2025-04-25 20:00:55' <= sp_1.to) ) LEFT JOIN mmag_feature_product fp_2 ON (p.id_product = fp_2.id_product) LEFT JOIN mmag_feature_product fp_3 ON (p.id_product = fp_3.id_product) WHERE ((a.id_attribute_group=2)) AND ((sp_1.reduction>0)) AND ((fp_2.id_feature_value IN (1192, 1247, 1239, 1235, 1229, 1220, 1215, 1212, 1206, 1194, 1173, 1155, 774, 1167, 776))) AND ((fp_3.id_feature_value IN (808, 815, 833))) GROUP BY pac.id_attribute	2.374 ms	98784	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:778 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:737 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:150 (getAttributesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:357 (runQuery) /override/controllers/front/listing/CategoryController.php:22 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
122	SELECT SQL_NO_CACHE fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, pl.name FROM mmag_product p LEFT JOIN mmag_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mmag_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN mmag_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 mmag_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN mmag_product_lang pl ON (p.id_product = pl.id_product AND pl.id_shop = 1 AND pl.id_lang = 1) INNER JOIN mmag_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN mmag_category_product cp ON (p.id_product = cp.id_product) INNER JOIN mmag_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN mmag_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN mmag_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, 36) 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-04-25 20:00:56' >= sp.from) AND (sp.to = '0000-00-00 00:00:00' OR '2025-04-25 20:00:56' <= sp.to) ) LEFT JOIN mmag_feature_product fp_1 ON (p.id_product = fp_1.id_product) WHERE ((sp.reduction>0)) AND ((fp_1.id_feature_value IN (808, 815, 833))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=9 AND c.nright<=24 GROUP BY p.id_product) p INNER JOIN mmag_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN mmag_specific_price sp_1 ON ( sp_1.id_product = p.id_product AND sp_1.id_shop IN (0, 1) AND sp_1.id_currency IN (0, 1) AND sp_1.id_country IN (0, 36) AND sp_1.id_group IN (0, 1) AND sp_1.from_quantity = 1 AND sp_1.reduction > 0 AND sp_1.id_customer = 0 AND sp_1.id_cart = 0 AND (sp_1.from = '0000-00-00 00:00:00' OR '2025-04-25 20:00:56' >= sp_1.from) AND (sp_1.to = '0000-00-00 00:00:00' OR '2025-04-25 20:00:56' <= sp_1.to) ) LEFT JOIN mmag_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((fp.id_feature=4)) AND ((sp_1.reduction>0)) AND ((fp_2.id_feature_value IN (808, 815, 833))) GROUP BY fp.id_feature_value	2.317 ms	2016	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:778 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:855 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:154 (getFeaturesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:357 (runQuery) /override/controllers/front/listing/CategoryController.php:22 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
141	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, pl.name FROM mmag_product p LEFT JOIN mmag_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mmag_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN mmag_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 mmag_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN mmag_product_lang pl ON (p.id_product = pl.id_product AND pl.id_shop = 1 AND pl.id_lang = 1) INNER JOIN mmag_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN mmag_category_product cp ON (p.id_product = cp.id_product) INNER JOIN mmag_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN mmag_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN mmag_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, 36) 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-04-25 20:00:56' >= sp.from) AND (sp.to = '0000-00-00 00:00:00' OR '2025-04-25 20:00:56' <= sp.to) ) LEFT JOIN mmag_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN mmag_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((sp.reduction>0)) AND ((fp_1.id_feature_value IN (1192, 1247, 1239, 1235, 1229, 1220, 1215, 1212, 1206, 1194, 1173, 1155, 774, 1167, 776))) AND ((fp_2.id_feature_value IN (808, 815, 833))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=9 AND c.nright<=24 GROUP BY p.id_product) p INNER JOIN mmag_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN mmag_specific_price sp_1 ON ( sp_1.id_product = p.id_product AND sp_1.id_shop IN (0, 1) AND sp_1.id_currency IN (0, 1) AND sp_1.id_country IN (0, 36) AND sp_1.id_group IN (0, 1) AND sp_1.from_quantity = 1 AND sp_1.reduction > 0 AND sp_1.id_customer = 0 AND sp_1.id_cart = 0 AND (sp_1.from = '0000-00-00 00:00:00' OR '2025-04-25 20:00:56' >= sp_1.from) AND (sp_1.to = '0000-00-00 00:00:00' OR '2025-04-25 20:00:56' <= sp_1.to) ) LEFT JOIN mmag_feature_product fp_2 ON (p.id_product = fp_2.id_product) LEFT JOIN mmag_feature_product fp_3 ON (p.id_product = fp_3.id_product) WHERE ((fp.id_feature=16)) AND ((sp_1.reduction>0)) AND ((fp_2.id_feature_value IN (1192, 1247, 1239, 1235, 1229, 1220, 1215, 1212, 1206, 1194, 1173, 1155, 774, 1167, 776))) AND ((fp_3.id_feature_value IN (808, 815, 833))) GROUP BY fp.id_feature_value	2.305 ms	98784	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:778 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:855 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:154 (getFeaturesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:357 (runQuery) /override/controllers/front/listing/CategoryController.php:22 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
114	SELECT SQL_NO_CACHE 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, pl.name FROM mmag_product p LEFT JOIN mmag_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mmag_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN mmag_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 mmag_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN mmag_product_lang pl ON (p.id_product = pl.id_product AND pl.id_shop = 1 AND pl.id_lang = 1) INNER JOIN mmag_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN mmag_category_product cp ON (p.id_product = cp.id_product) INNER JOIN mmag_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN mmag_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN mmag_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, 36) 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-04-25 20:00:56' >= sp.from) AND (sp.to = '0000-00-00 00:00:00' OR '2025-04-25 20:00:56' <= sp.to) ) LEFT JOIN mmag_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN mmag_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((sp.reduction>0)) AND ((fp_1.id_feature_value IN (1192, 1247, 1239, 1235, 1229, 1220, 1215, 1212, 1206, 1194, 1173, 1155, 774, 1167, 776))) AND ((fp_2.id_feature_value IN (808, 815, 833))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=9 AND c.nright<=24 GROUP BY p.id_product) p LEFT JOIN mmag_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mmag_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) INNER JOIN mmag_attribute a ON (a.id_attribute = pac.id_attribute) LEFT JOIN mmag_specific_price sp_1 ON ( sp_1.id_product = p.id_product AND sp_1.id_shop IN (0, 1) AND sp_1.id_currency IN (0, 1) AND sp_1.id_country IN (0, 36) AND sp_1.id_group IN (0, 1) AND sp_1.from_quantity = 1 AND sp_1.reduction > 0 AND sp_1.id_customer = 0 AND sp_1.id_cart = 0 AND (sp_1.from = '0000-00-00 00:00:00' OR '2025-04-25 20:00:56' >= sp_1.from) AND (sp_1.to = '0000-00-00 00:00:00' OR '2025-04-25 20:00:56' <= sp_1.to) ) LEFT JOIN mmag_feature_product fp_2 ON (p.id_product = fp_2.id_product) LEFT JOIN mmag_feature_product fp_3 ON (p.id_product = fp_3.id_product) WHERE ((a.id_attribute_group=6)) AND ((sp_1.reduction>0)) AND ((fp_2.id_feature_value IN (1192, 1247, 1239, 1235, 1229, 1220, 1215, 1212, 1206, 1194, 1173, 1155, 774, 1167, 776))) AND ((fp_3.id_feature_value IN (808, 815, 833))) GROUP BY pac.id_attribute	2.289 ms	98784	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:778 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:737 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:150 (getAttributesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:357 (runQuery) /override/controllers/front/listing/CategoryController.php:22 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)

#	Filename
0	/index.php
1	/config/config.inc.php
2	/config/defines.inc.php
3	/config/autoload.php
4	/vendor/autoload.php
5	/vendor/composer/autoload_real.php
6	/vendor/composer/platform_check.php
7	/vendor/composer/ClassLoader.php
8	/vendor/composer/include_paths.php
9	/vendor/composer/autoload_static.php
10	/vendor/symfony/polyfill-php72/bootstrap.php
11	/vendor/symfony/polyfill-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

Corpuri de iluminat

Meniu

Cautare