Corpuri de Iluminat

Aplică de Perete Modernă cu 2 Brațe, Metal Alb și Abajururi din Sticlă

-60%

Limited special offer

(0)

APLICĂ MODERNĂ, 2 BECURI

369,00 lei
147,60 lei (inclusiv TVA)

Aplică modernă transparentă, 2 becuri, I-AURORA-AP2 BCO

Adauga in cos

Candelabru Modern cu Cristale – Eleganță și Strălucire pentru Casa Ta

-80%

Limited special offer

(0)

CANDELABRU BOLERO

999,00 lei
199,80 lei (inclusiv TVA)

Candelabru suspendat cu cristale acrilice, I-BOLERO/S40

Adauga in cos

Veioză Modernă Transparenta cu Abajur din Sticlă – Design Elegant pentru Orice Interior

-60%

Limited special offer

(0)

VEIOZĂ NEOCLASICĂ TRANSPARENTĂ

299,00 lei
119,60 lei (inclusiv TVA)

Veioză neoclasică, alb cromată, cu 1 bec, I-AURORA-L1 TR

Adauga in cos

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	588.526 ms
Querying Time	482 ms
Queries	312
Memory Peak Usage	15.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

APLICĂ MODERNĂ, 2 BECURI

CANDELABRU BOLERO

VEIOZĂ NEOCLASICĂ TRANSPARENTĂ

Meniu

Cautare

Stopwatch SQL - 312 queries

Doubles

Tables stress

ObjectModel instances

Included Files

	Time	Cumulated Time	Memory Usage	Memory Peak Usage
config	19.881 ms	19.881 ms	4.79 Mb	4.9 Mb
__construct	0.014 ms	19.895 ms	- Mb	4.9 Mb
init	12.230 ms	32.125 ms	0.78 Mb	5.6 Mb
checkAccess	0.002 ms	32.127 ms	- Mb	5.6 Mb
setMedia	3.676 ms	35.803 ms	0.18 Mb	5.8 Mb
postProcess	0.001 ms	35.804 ms	- Mb	5.8 Mb
initHeader	0.002 ms	35.806 ms	- Mb	5.8 Mb
initContent	499.683 ms	535.489 ms	7.04 Mb	12.9 Mb
initFooter	0.003 ms	535.492 ms	- Mb	12.9 Mb
display	53.034 ms	588.526 ms	2.62 Mb	15.7 Mb

Hook	Time	Memory Usage
ActionStAssemble	37.944 ms	0.47 Mb
=> stthemeeditor	1.142 ms	0.01 Mb
=> sthoverimage	2.173 ms	0.01 Mb
=> stcompare	0.008 ms	- Mb
=> ststickers	10.491 ms	0.14 Mb
=> stwishlist	0.394 ms	0.01 Mb
=> stproductcomments	0.383 ms	0.01 Mb
=> stthemeeditor	2.193 ms	0.01 Mb
=> sthoverimage	0.505 ms	0.01 Mb
=> stcompare	0.004 ms	- Mb
=> ststickers	6.842 ms	0.11 Mb
=> stwishlist	0.627 ms	0.01 Mb
=> stproductcomments	2.287 ms	0.01 Mb
=> stthemeeditor	0.434 ms	0.01 Mb
=> sthoverimage	0.431 ms	0.01 Mb
=> stcompare	0.003 ms	- Mb
=> ststickers	9.007 ms	0.12 Mb
=> stwishlist	0.619 ms	0.01 Mb
=> stproductcomments	0.400 ms	0.01 Mb
DisplayHeader	16.826 ms	0.83 Mb
=> stthemeeditor	3.804 ms	0.24 Mb
=> ps_googleanalytics	0.197 ms	0.01 Mb
=> stcustomersignin	0.841 ms	0.02 Mb
=> stmultilink	0.313 ms	0.01 Mb
=> stsearchbar	0.386 ms	0.01 Mb
=> stshoppingcart	0.513 ms	0.01 Mb
=> stmegamenu	0.356 ms	0.01 Mb
=> stswiper	0.279 ms	0.07 Mb
=> stowlcarousel	0.355 ms	0.01 Mb
=> steasycontent	0.365 ms	0.03 Mb
=> stfeaturedslider	0.341 ms	0.01 Mb
=> stfeaturedcategories	0.363 ms	0.01 Mb
=> stblogeditor	0.273 ms	0.01 Mb
=> stblogfeaturedarticles	0.232 ms	0.01 Mb
=> stbanner	0.250 ms	0.01 Mb
=> stbrandsslider	0.228 ms	0.01 Mb
=> stspecialslider	0.308 ms	0.01 Mb
=> stblogrecentarticles	0.245 ms	0.01 Mb
=> stnewsletter	0.263 ms	0.01 Mb
=> stblogarchives	0.020 ms	- Mb
=> stblogcomments	0.048 ms	- Mb
=> stblogrelatedarticles	0.255 ms	0.01 Mb
=> stcountdown	0.279 ms	0.01 Mb
=> sthoverimage	0.082 ms	- Mb
=> stinstagram	0.591 ms	0.04 Mb
=> stcompare	0.455 ms	0.01 Mb
=> stnotification	0.316 ms	0.01 Mb
=> stpagebanner	0.317 ms	0.01 Mb
=> stproductcategoriesslider	0.297 ms	0.01 Mb
=> strelatedproducts	0.278 ms	0.01 Mb
=> stsidebar	0.219 ms	0.01 Mb
=> ststickers	1.286 ms	0.09 Mb
=> stvideo	0.281 ms	0.01 Mb
=> stwishlist	0.409 ms	0.02 Mb
=> stproductcomments	0.447 ms	0.01 Mb
=> stproductsasattrs	0.312 ms	0.01 Mb
=> sturls	0.060 ms	- Mb
=> cookiesplus	0.860 ms	0.02 Mb
=> ets_recaptcha_free	0.020 ms	- Mb
=> ets_whatsapp	0.083 ms	- Mb
DisplayBeforeBodyClosingTag	6.652 ms	0.47 Mb
=> ps_googleanalytics	1.351 ms	0.06 Mb
=> statsdata	0.714 ms	0.06 Mb
=> stwishlist	0.161 ms	- Mb
=> cookiesplus	4.426 ms	0.34 Mb
displayBanner	4.833 ms	0.16 Mb
=> stnotification (widget)	3.407 ms	0.09 Mb
=> steasycontent (widget)	1.426 ms	0.06 Mb
displayTop	4.161 ms	0.16 Mb
=> stcustomersignin (widget)	3.553 ms	0.13 Mb
=> stshoppingcart (widget)	0.608 ms	0.03 Mb
displayLeftColumn	3.403 ms	0.15 Mb
=> ps_categorytree (widget)	3.403 ms	0.15 Mb
DisplaySideBar	3.332 ms	0.16 Mb
=> stsidebar	0.690 ms	0.02 Mb
=> stnewsletter	0.686 ms	0.02 Mb
=> stmegamenu	0.409 ms	0.03 Mb
=> stwishlist	0.986 ms	0.06 Mb
=> stsearchbar	0.223 ms	0.01 Mb
=> stshoppingcart	0.337 ms	0.03 Mb
DisplayMobileBarLeft	2.776 ms	0.14 Mb
=> stsidebar	2.776 ms	0.14 Mb
ActionProductSearchAfter	2.770 ms	0.02 Mb
=> stthemeeditor	0.007 ms	- Mb
=> stcountdown	0.013 ms	- Mb
=> stcompare	0.038 ms	- Mb
=> ststickers	0.811 ms	0.01 Mb
=> stwishlist	1.901 ms	- Mb
ActionFrontControllerSetMedia	2.416 ms	0.05 Mb
=> ps_emailalerts	0.041 ms	- Mb
=> cookiesplus	2.375 ms	0.05 Mb
ActionOutputHTMLBefore	1.676 ms	0.01 Mb
=> cookiesplus	1.538 ms	0.01 Mb
=> stswiper	0.041 ms	- Mb
=> stbanner	0.052 ms	- Mb
=> stinstagram	0.045 ms	- Mb
DisplayMobileBar	1.353 ms	0.03 Mb
=> stsidebar	1.353 ms	0.03 Mb
DisplayFooter	1.191 ms	0.08 Mb
=> ets_whatsapp	0.338 ms	0.02 Mb
=> stnewsletter	0.294 ms	0.02 Mb
=> stmultilink	0.266 ms	0.02 Mb
=> steasycontent	0.293 ms	0.02 Mb
ActionDispatcherBefore	1.174 ms	0.01 Mb
=> sturls	1.165 ms	0.01 Mb
=> ets_delete_order	0.009 ms	- Mb
DisplayMainMenu	1.147 ms	0.03 Mb
=> stmegamenu	1.147 ms	0.03 Mb
displayHeaderCenter	0.969 ms	0.03 Mb
=> stsearchbar (widget)	0.969 ms	0.03 Mb
displayFullWidthTop	0.894 ms	0.05 Mb
=> stswiper (widget)	0.856 ms	0.05 Mb
=> steasycontent (widget)	0.038 ms	- Mb
DisplayCategoryHeader	0.791 ms	0.03 Mb
=> stswiper	0.228 ms	0.01 Mb
=> stowlcarousel	0.225 ms	0.01 Mb
=> stbanner	0.338 ms	0.01 Mb
displayBeforeBodyClosingTag	0.675 ms	0.02 Mb
=> stnotification (widget)	0.675 ms	0.02 Mb
DisplayLeftColumn	0.662 ms	0.08 Mb
=> ps_facetedsearch	0.297 ms	0.07 Mb
=> stmegamenu	0.365 ms	0.01 Mb
DisplayNav2	0.548 ms	0.01 Mb
=> stmultilink	0.548 ms	0.01 Mb
DisplayBreadcrumb	0.405 ms	0.01 Mb
=> stpagebanner	0.405 ms	0.01 Mb
DisplayRightBar	0.332 ms	0.04 Mb
=> stsidebar	0.332 ms	0.04 Mb
DisplayFooterAfter	0.251 ms	0.01 Mb
=> stmultilink	0.251 ms	0.01 Mb
DisplayMobileBarCenter	0.247 ms	- Mb
=> stsidebar	0.247 ms	- Mb
ProductSearchProvider	0.218 ms	- Mb
=> ps_facetedsearch	0.218 ms	- Mb
DisplayMobileBarBottom	0.218 ms	- Mb
=> stsidebar	0.218 ms	- Mb
DisplayNav1	0.213 ms	0.02 Mb
=> stmultilink	0.213 ms	0.02 Mb
ModuleRoutes	0.102 ms	0.01 Mb
=> stblog	0.005 ms	- Mb
=> stblogarchives	0.002 ms	- Mb
=> stblogsearch	0.002 ms	- Mb
=> sturls	0.039 ms	0.01 Mb
=> cookiesplus	0.054 ms	- Mb
DisplayAfterBodyOpeningTag	0.060 ms	- Mb
=> cookiesplus	0.060 ms	- Mb
ActionDispatcher	0.039 ms	- Mb
=> sturls	0.039 ms	- Mb
displayFullWidthTop2	0.014 ms	- Mb
=> steasycontent (widget)	0.014 ms	- Mb
OverrideLayoutTemplate	0.010 ms	- Mb
=> stblog	0.003 ms	- Mb
=> stblog	0.005 ms	- Mb
=> stblog	0.002 ms	- Mb
DisplayFullWidthTop	0.005 ms	- Mb
=> stfeaturedslider	0.003 ms	- Mb
=> stproductcategoriesslider	0.002 ms	- Mb
DisplayFullWidthBottom	0.005 ms	- Mb
=> stblogfeaturedarticles	0.005 ms	- Mb
FilterProductSearch	0.004 ms	- Mb
=> stsearchbar	0.004 ms	- Mb
36 hook(s)	98.315 ms	3.08 Mb

Module	Time	Memory Usage
sturls	2.282 ms	0.06 Mb
__construct	0.970 ms	0.04 Mb
hookModuleRoutes	0.040 ms	0.01 Mb
hookActionDispatcherBefore	1.168 ms	0.01 Mb
hookActionDispatcher	0.042 ms	- Mb
hookDisplayHeader	0.062 ms	- Mb
stblog	1.879 ms	0.10 Mb
__construct	1.849 ms	0.09 Mb
hookModuleRoutes	0.012 ms	- Mb
hookOverrideLayoutTemplate	0.006 ms	- Mb
hookOverrideLayoutTemplate	0.007 ms	- Mb
hookOverrideLayoutTemplate	0.005 ms	- Mb
stblogarchives	0.883 ms	0.03 Mb
__construct	0.857 ms	0.03 Mb
hookModuleRoutes	0.004 ms	- Mb
hookDisplayHeader	0.022 ms	- Mb
stblogsearch	0.731 ms	0.03 Mb
__construct	0.727 ms	0.03 Mb
hookModuleRoutes	0.004 ms	- Mb
cookiesplus	10.257 ms	0.52 Mb
__construct	0.924 ms	0.09 Mb
hookModuleRoutes	0.057 ms	- Mb
hookActionFrontControllerSetMedia	2.378 ms	0.05 Mb
hookDisplayHeader	0.864 ms	0.02 Mb
hookDisplayAfterBodyOpeningTag	0.064 ms	- Mb
hookDisplayBeforeBodyClosingTag	4.429 ms	0.34 Mb
hookActionOutputHTMLBefore	1.541 ms	0.01 Mb
ets_delete_order	0.997 ms	0.14 Mb
__construct	0.985 ms	0.14 Mb
hookActionDispatcherBefore	0.012 ms	- Mb
ps_emailalerts	0.932 ms	0.12 Mb
__construct	0.888 ms	0.12 Mb
hookActionFrontControllerSetMedia	0.044 ms	- Mb
stthemeeditor	8.107 ms	0.37 Mb
__construct	0.485 ms	0.09 Mb
hookDisplayHeader	3.807 ms	0.24 Mb
hookActionStAssemble	1.173 ms	0.02 Mb
hookActionStAssemble	2.196 ms	0.01 Mb
hookActionStAssemble	0.437 ms	0.01 Mb
hookActionProductSearchAfter	0.009 ms	- Mb
ps_googleanalytics	1.758 ms	0.10 Mb
__construct	0.205 ms	0.03 Mb
hookDisplayHeader	0.199 ms	0.01 Mb
hookDisplayBeforeBodyClosingTag	1.354 ms	0.06 Mb
stcustomersignin	4.591 ms	0.18 Mb
__construct	0.175 ms	0.02 Mb
hookDisplayHeader	0.844 ms	0.02 Mb
displayTop	3.572 ms	0.13 Mb
stmultilink	1.811 ms	0.13 Mb
__construct	0.204 ms	0.05 Mb
hookDisplayHeader	0.317 ms	0.01 Mb
hookDisplayNav1	0.216 ms	0.02 Mb
hookDisplayNav2	0.551 ms	0.01 Mb
hookDisplayFooter	0.269 ms	0.02 Mb
hookDisplayFooterAfter	0.254 ms	0.01 Mb
stsearchbar	1.741 ms	0.09 Mb
__construct	0.144 ms	0.03 Mb
hookDisplayHeader	0.389 ms	0.01 Mb
displayHeaderCenter	0.974 ms	0.03 Mb
hookFilterProductSearch	0.008 ms	- Mb
hookDisplaySideBar	0.226 ms	0.01 Mb
stshoppingcart	1.629 ms	0.15 Mb
__construct	0.162 ms	0.08 Mb
hookDisplayHeader	0.516 ms	0.01 Mb
displayTop	0.611 ms	0.03 Mb
hookDisplaySideBar	0.340 ms	0.03 Mb
stmegamenu	5.630 ms	0.14 Mb
__construct	3.327 ms	0.06 Mb
hookDisplayHeader	0.358 ms	0.01 Mb
hookDisplayMainMenu	1.165 ms	0.03 Mb
hookDisplayLeftColumn	0.368 ms	0.01 Mb
hookDisplaySideBar	0.412 ms	0.03 Mb
stswiper	1.857 ms	0.23 Mb
__construct	0.433 ms	0.09 Mb
hookDisplayHeader	0.290 ms	0.07 Mb
displayFullWidthTop	0.859 ms	0.05 Mb
hookDisplayCategoryHeader	0.232 ms	0.01 Mb
hookActionOutputHTMLBefore	0.043 ms	- Mb
stowlcarousel	0.846 ms	0.08 Mb
__construct	0.260 ms	0.06 Mb
hookDisplayHeader	0.358 ms	0.01 Mb
hookDisplayCategoryHeader	0.228 ms	0.01 Mb
steasycontent	2.731 ms	0.29 Mb
__construct	0.586 ms	0.17 Mb
hookDisplayHeader	0.368 ms	0.03 Mb
displayBanner	1.428 ms	0.06 Mb
displayFullWidthTop	0.039 ms	- Mb
displayFullWidthTop2	0.015 ms	- Mb
hookDisplayFooter	0.295 ms	0.02 Mb
stfeaturedslider	0.599 ms	0.08 Mb
__construct	0.251 ms	0.07 Mb
hookDisplayHeader	0.344 ms	0.01 Mb
hookDisplayFullWidthTop	0.004 ms	- Mb
stfeaturedcategories	0.532 ms	0.05 Mb
__construct	0.166 ms	0.04 Mb
hookDisplayHeader	0.366 ms	0.01 Mb
stblogeditor	0.390 ms	0.05 Mb
__construct	0.114 ms	0.03 Mb
hookDisplayHeader	0.276 ms	0.01 Mb
stblogfeaturedarticles	0.360 ms	0.13 Mb
__construct	0.117 ms	0.11 Mb
hookDisplayHeader	0.235 ms	0.01 Mb
hookDisplayFullWidthBottom	0.008 ms	- Mb
stbanner	0.913 ms	0.09 Mb
__construct	0.267 ms	0.06 Mb
hookDisplayHeader	0.252 ms	0.01 Mb
hookDisplayCategoryHeader	0.341 ms	0.01 Mb
hookActionOutputHTMLBefore	0.053 ms	- Mb
stbrandsslider	0.362 ms	0.04 Mb
__construct	0.132 ms	0.03 Mb
hookDisplayHeader	0.230 ms	0.01 Mb
stspecialslider	0.465 ms	0.04 Mb
__construct	0.154 ms	0.03 Mb
hookDisplayHeader	0.311 ms	0.01 Mb
stblogrecentarticles	0.360 ms	0.04 Mb
__construct	0.096 ms	0.03 Mb
hookDisplayHeader	0.264 ms	0.01 Mb
stnewsletter	1.432 ms	0.16 Mb
__construct	0.182 ms	0.11 Mb
hookDisplayHeader	0.265 ms	0.01 Mb
hookDisplayFooter	0.296 ms	0.02 Mb
hookDisplaySideBar	0.689 ms	0.02 Mb
stblogcomments	0.158 ms	0.04 Mb
__construct	0.108 ms	0.04 Mb
hookDisplayHeader	0.050 ms	- Mb
stblogrelatedarticles	0.349 ms	0.04 Mb
__construct	0.091 ms	0.03 Mb
hookDisplayHeader	0.258 ms	0.01 Mb
stcountdown	0.511 ms	0.04 Mb
__construct	0.214 ms	0.03 Mb
hookDisplayHeader	0.282 ms	0.02 Mb
hookActionProductSearchAfter	0.015 ms	- Mb
sthoverimage	3.450 ms	0.05 Mb
__construct	0.248 ms	0.03 Mb
hookDisplayHeader	0.084 ms	- Mb
hookActionStAssemble	2.176 ms	0.01 Mb
hookActionStAssemble	0.508 ms	0.01 Mb
hookActionStAssemble	0.434 ms	0.01 Mb
stinstagram	1.090 ms	0.17 Mb
__construct	0.450 ms	0.13 Mb
hookDisplayHeader	0.594 ms	0.04 Mb
hookActionOutputHTMLBefore	0.046 ms	- Mb
stcompare	0.671 ms	0.05 Mb
__construct	0.145 ms	0.03 Mb
hookDisplayHeader	0.458 ms	0.01 Mb
hookActionStAssemble	0.009 ms	- Mb
hookActionStAssemble	0.016 ms	- Mb
hookActionStAssemble	0.004 ms	- Mb
hookActionProductSearchAfter	0.039 ms	- Mb
stnotification	4.623 ms	0.18 Mb
__construct	0.215 ms	0.05 Mb
hookDisplayHeader	0.319 ms	0.01 Mb
displayBanner	3.411 ms	0.09 Mb
displayBeforeBodyClosingTag	0.678 ms	0.02 Mb
stpagebanner	0.913 ms	0.06 Mb
__construct	0.185 ms	0.04 Mb
hookDisplayHeader	0.320 ms	0.01 Mb
hookDisplayBreadcrumb	0.408 ms	0.01 Mb
stproductcategoriesslider	0.824 ms	0.15 Mb
__construct	0.521 ms	0.14 Mb
hookDisplayHeader	0.300 ms	0.01 Mb
hookDisplayFullWidthTop	0.003 ms	- Mb
strelatedproducts	0.428 ms	0.04 Mb
__construct	0.147 ms	0.03 Mb
hookDisplayHeader	0.281 ms	0.01 Mb
stsidebar	6.149 ms	0.30 Mb
__construct	0.294 ms	0.05 Mb
hookDisplayHeader	0.222 ms	0.01 Mb
hookDisplayMobileBarLeft	2.778 ms	0.14 Mb
hookDisplayMobileBarCenter	0.250 ms	- Mb
hookDisplayMobileBar	1.355 ms	0.03 Mb
hookDisplayMobileBarBottom	0.222 ms	- Mb
hookDisplaySideBar	0.693 ms	0.02 Mb
hookDisplayRightBar	0.335 ms	0.04 Mb
ststickers	28.712 ms	0.53 Mb
__construct	0.259 ms	0.06 Mb
hookDisplayHeader	1.289 ms	0.09 Mb
hookActionStAssemble	10.494 ms	0.14 Mb
hookActionStAssemble	6.846 ms	0.11 Mb
hookActionStAssemble	9.010 ms	0.12 Mb
hookActionProductSearchAfter	0.814 ms	0.02 Mb
stvideo	0.560 ms	0.06 Mb
__construct	0.276 ms	0.05 Mb
hookDisplayHeader	0.284 ms	0.01 Mb
stwishlist	5.347 ms	0.15 Mb
__construct	0.228 ms	0.05 Mb
hookDisplayHeader	0.412 ms	0.02 Mb
hookActionStAssemble	0.397 ms	0.01 Mb
hookActionStAssemble	0.630 ms	0.01 Mb
hookActionStAssemble	0.622 ms	0.01 Mb
hookActionProductSearchAfter	1.905 ms	- Mb
hookDisplaySideBar	0.989 ms	0.06 Mb
hookDisplayBeforeBodyClosingTag	0.164 ms	- Mb
stproductcomments	3.858 ms	0.16 Mb
__construct	0.312 ms	0.13 Mb
hookDisplayHeader	0.450 ms	0.01 Mb
hookActionStAssemble	0.386 ms	0.01 Mb
hookActionStAssemble	2.307 ms	0.01 Mb
hookActionStAssemble	0.403 ms	0.01 Mb
stproductsasattrs	0.515 ms	0.06 Mb
__construct	0.200 ms	0.04 Mb
hookDisplayHeader	0.315 ms	0.02 Mb
ets_recaptcha_free	0.206 ms	0.03 Mb
__construct	0.183 ms	0.03 Mb
hookDisplayHeader	0.023 ms	- Mb
ets_whatsapp	0.592 ms	0.04 Mb
__construct	0.165 ms	0.02 Mb
hookDisplayHeader	0.086 ms	- Mb
hookDisplayFooter	0.341 ms	0.02 Mb
ps_facetedsearch	0.789 ms	0.11 Mb
__construct	0.268 ms	0.04 Mb
hookProductSearchProvider	0.221 ms	- Mb
hookDisplayLeftColumn	0.300 ms	0.07 Mb
ps_categorytree	3.572 ms	0.17 Mb
__construct	0.165 ms	0.02 Mb
displayLeftColumn	3.407 ms	0.15 Mb
statsdata	0.820 ms	0.08 Mb
__construct	0.103 ms	0.02 Mb
hookDisplayBeforeBodyClosingTag	0.717 ms	0.06 Mb
47 module(s)	118.211 ms	5.93 Mb

Name	Instances	Source
Category	41	/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: 22] /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: 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	12	/classes/Link.php:113 (__construct) [id: 32] /classes/Link.php:113 (__construct) [id: 36] /classes/Link.php:113 (__construct) [id: 35] /modules/ststickers/classes/StStickersMapClass.php:152 (__construct) [id: 32] /modules/ststickers/classes/StStickersMapClass.php:152 (__construct) [id: 36] /modules/ststickers/classes/StStickersMapClass.php:152 (__construct) [id: 35] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 32] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 36] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 35] /classes/Link.php:113 (__construct) [id: 32] /classes/Link.php:113 (__construct) [id: 36] /classes/Link.php:113 (__construct) [id: 35]
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
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:57' >= sp.from) AND (sp.to = '0000-00-00 00:00:00' OR '2025-04-25 20:00:57' <= 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, 1199, 1225, 775))) AND ((fp_2.id_feature_value IN (741, 1198))) 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:57' >= sp_1.from) AND (sp_1.to = '0000-00-00 00:00:00' OR '2025-04-25 20:00:57' <= 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, 1199, 1225, 775))) AND ((fp_3.id_feature_value IN (741, 1198))) GROUP BY fp.id_feature_value	19.902 ms	5387844	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:57' >= sp.from) AND (sp.to = '0000-00-00 00:00:00' OR '2025-04-25 20:00:57' <= 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) LEFT JOIN mmag_feature_product fp_3 ON (p.id_product = fp_3.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, 1199, 1225, 775))) AND ((fp_2.id_feature_value IN (741, 1198))) AND ((fp_3.id_feature_value IN (727, 726))) 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:57' >= sp_1.from) AND (sp_1.to = '0000-00-00 00:00:00' OR '2025-04-25 20:00:57' <= 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) LEFT JOIN mmag_feature_product fp_4 ON (p.id_product = fp_4.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, 1199, 1225, 775))) AND ((fp_3.id_feature_value IN (741, 1198))) AND ((fp_4.id_feature_value IN (727, 726))) GROUP BY fp.id_feature_value	15.525 ms	4840416	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)
152	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:57' >= sp.from) AND (sp.to = '0000-00-00 00:00:00' OR '2025-04-25 20:00:57' <= 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) LEFT JOIN mmag_feature_product fp_3 ON (p.id_product = fp_3.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, 1199, 1225, 775))) AND ((fp_2.id_feature_value IN (741, 1198))) AND ((fp_3.id_feature_value IN (727, 726))) 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:57' >= sp_1.from) AND (sp_1.to = '0000-00-00 00:00:00' OR '2025-04-25 20:00:57' <= 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) LEFT JOIN mmag_feature_product fp_4 ON (p.id_product = fp_4.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, 1199, 1225, 775))) AND ((fp_3.id_feature_value IN (741, 1198))) AND ((fp_4.id_feature_value IN (727, 726))) GROUP BY fp.id_feature_value	10.729 ms	4840416	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)
122	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:57' >= sp.from) AND (sp.to = '0000-00-00 00:00:00' OR '2025-04-25 20:00:57' <= 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) LEFT JOIN mmag_feature_product fp_3 ON (p.id_product = fp_3.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, 1199, 1225, 775))) AND ((fp_2.id_feature_value IN (741, 1198))) AND ((fp_3.id_feature_value IN (727, 726))) 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:57' >= sp_1.from) AND (sp_1.to = '0000-00-00 00:00:00' OR '2025-04-25 20:00:57' <= 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) LEFT JOIN mmag_feature_product fp_4 ON (p.id_product = fp_4.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, 1199, 1225, 775))) AND ((fp_3.id_feature_value IN (741, 1198))) AND ((fp_4.id_feature_value IN (727, 726))) GROUP BY pac.id_attribute	10.406 ms	4840416	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)
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:57' >= sp.from) AND (sp.to = '0000-00-00 00:00:00' OR '2025-04-25 20:00:57' <= 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) LEFT JOIN mmag_feature_product fp_3 ON (p.id_product = fp_3.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, 1199, 1225, 775))) AND ((fp_2.id_feature_value IN (741, 1198))) AND ((fp_3.id_feature_value IN (727, 726))) 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:57' >= sp_1.from) AND (sp_1.to = '0000-00-00 00:00:00' OR '2025-04-25 20:00:57' <= 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) LEFT JOIN mmag_feature_product fp_4 ON (p.id_product = fp_4.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, 1199, 1225, 775))) AND ((fp_3.id_feature_value IN (741, 1198))) AND ((fp_4.id_feature_value IN (727, 726))) GROUP BY fp.id_feature_value	10.097 ms	4840416	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:57' >= sp.from) AND (sp.to = '0000-00-00 00:00:00' OR '2025-04-25 20:00:57' <= 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) LEFT JOIN mmag_feature_product fp_3 ON (p.id_product = fp_3.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, 1199, 1225, 775))) AND ((fp_2.id_feature_value IN (741, 1198))) AND ((fp_3.id_feature_value IN (727, 726))) 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:57' >= sp_1.from) AND (sp_1.to = '0000-00-00 00:00:00' OR '2025-04-25 20:00:57' <= 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) LEFT JOIN mmag_feature_product fp_4 ON (p.id_product = fp_4.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, 1199, 1225, 775))) AND ((fp_3.id_feature_value IN (741, 1198))) AND ((fp_4.id_feature_value IN (727, 726))) GROUP BY fp.id_feature_value	10.056 ms	4840416	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)
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:57' >= sp.from) AND (sp.to = '0000-00-00 00:00:00' OR '2025-04-25 20:00:57' <= 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) LEFT JOIN mmag_feature_product fp_3 ON (p.id_product = fp_3.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, 1199, 1225, 775))) AND ((fp_2.id_feature_value IN (741, 1198))) AND ((fp_3.id_feature_value IN (727, 726))) 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:57' >= sp_1.from) AND (sp_1.to = '0000-00-00 00:00:00' OR '2025-04-25 20:00:57' <= 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) LEFT JOIN mmag_feature_product fp_4 ON (p.id_product = fp_4.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, 1199, 1225, 775))) AND ((fp_3.id_feature_value IN (741, 1198))) AND ((fp_4.id_feature_value IN (727, 726))) GROUP BY fp.id_feature_value	9.788 ms	4840416	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)
153	REPLACE INTO mmag_layered_filter_block (hash, data) VALUES ("293353b326e0d52d46f8930b9919fb8a", "a:1:{s:7:\"filters\";a:20:{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:999;s:3:\"min\";d:95;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:3;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:3;}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:0;}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:3;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:\"1\";}i:19;a:2:{s:4:\"name\";s:6:\"Lustre\";s:3:\"nbr\";s:1:\"1\";}i:22;a:2:{s:4:\"name\";s:6:\"Aplice\";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:2:{i:696;a:4:{s:3:\"nbr\";s:1:\"2\";s:4:\"name\";s:6:\"Sticla\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:699;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:36:\"Stofa si cristale pandative acrilice\";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:1:{i:784;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:6:\"Clasic\";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:0:{}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:\"3\";}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:10;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:3;}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:4:{i:774;a:5:{s:3:\"nbr\";s:1:\"2\";s:4:\"name\";s:1:\"1\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:7:\"checked\";b:1;}i:775;a:5:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:1:\"2\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:7:\"checked\";b:1;}i:779;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:1:\"6\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:780;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:1:\"8\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}}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:3:{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:823;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:14:\"37 cm inaltime\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:809;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:15:\"120 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:1:{i:741;a:5:{s:3:\"nbr\";s:1:\"3\";s:4:\"name\";s:8:\"Interior\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:7:\"checked\";b:1;}}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:2:{i:791;a:4:{s:3:\"nbr\";s:1:\"2\";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:\"1\";s:4:\"name\";s:3:\"E27\";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:12:{i:725;a:4:{s:3:\"nbr\";s:2:\"12\";s:4:\"name\";s:3:\"Alb\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:723;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:11:\"Alb si crem\";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:730;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:15:\"Alb transparent\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:737;a:4:{s:3:\"nbr\";s:1:\"2\";s:4:\"name\";s:8:\"Argintiu\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:734;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:4:\"Crem\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:727;a:5:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:4:\"Crom\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:7:\"checked\";b:1;}i:729;a:4:{s:3:\"nbr\";s:1:\"2\";s:4:\"name\";s:10:\"Multicolor\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:728;a:4:{s:3:\"nbr\";s:1:\"2\";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:\"2\";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;}i:726;a:5:{s:3:\"nbr\";s:1:\"2\";s:4:\"name\";s:11:\"Transparent\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:7:\"checked\";b:1;}}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:1:{i:715;a:4:{s:3:\"nbr\";s:1:\"2\";s:4:\"name\";s:12:\"Metal cromat\";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:2:{i:749;a:4:{s:3:\"nbr\";s:1:\"1\";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:\"1\";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:1:{i:693;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:4:\"IP20\";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:3:{i:852;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:13:\"11 cm latime \";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:856;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:13:\"28 cm latime \";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:858;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:12:\"40 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:834;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:13:\"40 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\";}}}")	9.624 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)
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:57' >= sp.from) AND (sp.to = '0000-00-00 00:00:00' OR '2025-04-25 20:00:57' <= 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) LEFT JOIN mmag_feature_product fp_3 ON (p.id_product = fp_3.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, 1199, 1225, 775))) AND ((fp_2.id_feature_value IN (741, 1198))) AND ((fp_3.id_feature_value IN (727, 726))) 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:57' >= sp_1.from) AND (sp_1.to = '0000-00-00 00:00:00' OR '2025-04-25 20:00:57' <= 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) LEFT JOIN mmag_feature_product fp_4 ON (p.id_product = fp_4.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, 1199, 1225, 775))) AND ((fp_3.id_feature_value IN (741, 1198))) AND ((fp_4.id_feature_value IN (727, 726))) GROUP BY fp.id_feature_value	9.421 ms	4840416	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)
119	SELECT SQL_NO_CACHE fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, 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:57' >= sp.from) AND (sp.to = '0000-00-00 00:00:00' OR '2025-04-25 20:00:57' <= 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) LEFT JOIN mmag_feature_product fp_3 ON (p.id_product = fp_3.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, 1199, 1225, 775))) AND ((fp_2.id_feature_value IN (741, 1198))) AND ((fp_3.id_feature_value IN (727, 726))) 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:57' >= sp_1.from) AND (sp_1.to = '0000-00-00 00:00:00' OR '2025-04-25 20:00:57' <= 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) LEFT JOIN mmag_feature_product fp_4 ON (p.id_product = fp_4.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, 1199, 1225, 775))) AND ((fp_3.id_feature_value IN (741, 1198))) AND ((fp_4.id_feature_value IN (727, 726))) GROUP BY fp.id_feature_value	9.306 ms	4840416	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:57' >= sp.from) AND (sp.to = '0000-00-00 00:00:00' OR '2025-04-25 20:00:57' <= 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) LEFT JOIN mmag_feature_product fp_3 ON (p.id_product = fp_3.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, 1199, 1225, 775))) AND ((fp_2.id_feature_value IN (741, 1198))) AND ((fp_3.id_feature_value IN (727, 726))) 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:57' >= sp_1.from) AND (sp_1.to = '0000-00-00 00:00:00' OR '2025-04-25 20:00:57' <= 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) LEFT JOIN mmag_feature_product fp_4 ON (p.id_product = fp_4.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, 1199, 1225, 775))) AND ((fp_3.id_feature_value IN (741, 1198))) AND ((fp_4.id_feature_value IN (727, 726))) GROUP BY fp.id_feature_value	9.178 ms	4840416	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)
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`)	8.980 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)
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:57' >= sp.from) AND (sp.to = '0000-00-00 00:00:00' OR '2025-04-25 20:00:57' <= 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) LEFT JOIN mmag_feature_product fp_3 ON (p.id_product = fp_3.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, 1199, 1225, 775))) AND ((fp_2.id_feature_value IN (741, 1198))) AND ((fp_3.id_feature_value IN (727, 726))) 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:57' >= sp_1.from) AND (sp_1.to = '0000-00-00 00:00:00' OR '2025-04-25 20:00:57' <= 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) LEFT JOIN mmag_feature_product fp_4 ON (p.id_product = fp_4.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, 1199, 1225, 775))) AND ((fp_3.id_feature_value IN (741, 1198))) AND ((fp_4.id_feature_value IN (727, 726))) GROUP BY fp.id_feature_value	8.964 ms	4840416	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:57' >= sp.from) AND (sp.to = '0000-00-00 00:00:00' OR '2025-04-25 20:00:57' <= 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) LEFT JOIN mmag_feature_product fp_3 ON (p.id_product = fp_3.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, 1199, 1225, 775))) AND ((fp_2.id_feature_value IN (741, 1198))) AND ((fp_3.id_feature_value IN (727, 726))) 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:57' >= sp_1.from) AND (sp_1.to = '0000-00-00 00:00:00' OR '2025-04-25 20:00:57' <= 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) LEFT JOIN mmag_feature_product fp_4 ON (p.id_product = fp_4.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, 1199, 1225, 775))) AND ((fp_3.id_feature_value IN (741, 1198))) AND ((fp_4.id_feature_value IN (727, 726))) GROUP BY fp.id_feature_value	8.582 ms	4840416	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)
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:57' >= sp.from) AND (sp.to = '0000-00-00 00:00:00' OR '2025-04-25 20:00:57' <= 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 (741, 1198))) AND ((fp_2.id_feature_value IN (727, 726))) 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:57' >= sp_1.from) AND (sp_1.to = '0000-00-00 00:00:00' OR '2025-04-25 20:00:57' <= 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=4)) AND ((sp_1.reduction>0)) AND ((fp_2.id_feature_value IN (741, 1198))) AND ((fp_3.id_feature_value IN (727, 726))) GROUP BY fp.id_feature_value	8.499 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)
120	SELECT SQL_NO_CACHE fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, 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:57' >= sp.from) AND (sp.to = '0000-00-00 00:00:00' OR '2025-04-25 20:00:57' <= 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) LEFT JOIN mmag_feature_product fp_3 ON (p.id_product = fp_3.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, 1199, 1225, 775))) AND ((fp_2.id_feature_value IN (741, 1198))) AND ((fp_3.id_feature_value IN (727, 726))) 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:57' >= sp_1.from) AND (sp_1.to = '0000-00-00 00:00:00' OR '2025-04-25 20:00:57' <= 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) LEFT JOIN mmag_feature_product fp_4 ON (p.id_product = fp_4.id_product) WHERE ((fp.id_feature=8)) 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, 1199, 1225, 775))) AND ((fp_3.id_feature_value IN (741, 1198))) AND ((fp_4.id_feature_value IN (727, 726))) GROUP BY fp.id_feature_value	8.451 ms	4840416	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)
118	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:57' >= sp.from) AND (sp.to = '0000-00-00 00:00:00' OR '2025-04-25 20:00:57' <= 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) LEFT JOIN mmag_feature_product fp_3 ON (p.id_product = fp_3.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, 1199, 1225, 775))) AND ((fp_2.id_feature_value IN (741, 1198))) AND ((fp_3.id_feature_value IN (727, 726))) 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:57' >= sp_1.from) AND (sp_1.to = '0000-00-00 00:00:00' OR '2025-04-25 20:00:57' <= 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) LEFT JOIN mmag_feature_product fp_4 ON (p.id_product = fp_4.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, 1199, 1225, 775))) AND ((fp_3.id_feature_value IN (741, 1198))) AND ((fp_4.id_feature_value IN (727, 726))) GROUP BY pac.id_attribute	8.410 ms	4840416	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)
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:57' >= sp.from) AND (sp.to = '0000-00-00 00:00:00' OR '2025-04-25 20:00:57' <= 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) LEFT JOIN mmag_feature_product fp_3 ON (p.id_product = fp_3.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, 1199, 1225, 775))) AND ((fp_2.id_feature_value IN (741, 1198))) AND ((fp_3.id_feature_value IN (727, 726))) 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:57' >= sp_1.from) AND (sp_1.to = '0000-00-00 00:00:00' OR '2025-04-25 20:00:57' <= 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) LEFT JOIN mmag_feature_product fp_4 ON (p.id_product = fp_4.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, 1199, 1225, 775))) AND ((fp_3.id_feature_value IN (741, 1198))) AND ((fp_4.id_feature_value IN (727, 726))) GROUP BY fp.id_feature_value	8.189 ms	4840416	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:57' >= sp.from) AND (sp.to = '0000-00-00 00:00:00' OR '2025-04-25 20:00:57' <= 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) LEFT JOIN mmag_feature_product fp_3 ON (p.id_product = fp_3.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, 1199, 1225, 775))) AND ((fp_2.id_feature_value IN (741, 1198))) AND ((fp_3.id_feature_value IN (727, 726))) 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:57' >= sp_1.from) AND (sp_1.to = '0000-00-00 00:00:00' OR '2025-04-25 20:00:57' <= 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) LEFT JOIN mmag_feature_product fp_4 ON (p.id_product = fp_4.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, 1199, 1225, 775))) AND ((fp_3.id_feature_value IN (741, 1198))) AND ((fp_4.id_feature_value IN (727, 726))) GROUP BY fp.id_feature_value	8.131 ms	4840416	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:57' >= sp.from) AND (sp.to = '0000-00-00 00:00:00' OR '2025-04-25 20:00:57' <= 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, 1199, 1225, 775))) AND ((fp_2.id_feature_value IN (727, 726))) 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:57' >= sp_1.from) AND (sp_1.to = '0000-00-00 00:00:00' OR '2025-04-25 20:00:57' <= 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, 1199, 1225, 775))) AND ((fp_3.id_feature_value IN (727, 726))) GROUP BY fp.id_feature_value	8.073 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)
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:57' >= sp.from) AND (sp.to = '0000-00-00 00:00:00' OR '2025-04-25 20:00:57' <= 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) LEFT JOIN mmag_feature_product fp_3 ON (p.id_product = fp_3.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, 1199, 1225, 775))) AND ((fp_2.id_feature_value IN (741, 1198))) AND ((fp_3.id_feature_value IN (727, 726))) 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:57' >= sp_1.from) AND (sp_1.to = '0000-00-00 00:00:00' OR '2025-04-25 20:00:57' <= 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) LEFT JOIN mmag_feature_product fp_4 ON (p.id_product = fp_4.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, 1199, 1225, 775))) AND ((fp_3.id_feature_value IN (741, 1198))) AND ((fp_4.id_feature_value IN (727, 726))) GROUP BY fp.id_feature_value	7.744 ms	4840416	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)
123	SELECT SQL_NO_CACHE fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, 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:57' >= sp.from) AND (sp.to = '0000-00-00 00:00:00' OR '2025-04-25 20:00:57' <= 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) LEFT JOIN mmag_feature_product fp_3 ON (p.id_product = fp_3.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, 1199, 1225, 775))) AND ((fp_2.id_feature_value IN (741, 1198))) AND ((fp_3.id_feature_value IN (727, 726))) 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:57' >= sp_1.from) AND (sp_1.to = '0000-00-00 00:00:00' OR '2025-04-25 20:00:57' <= 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) LEFT JOIN mmag_feature_product fp_4 ON (p.id_product = fp_4.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, 1199, 1225, 775))) AND ((fp_3.id_feature_value IN (741, 1198))) AND ((fp_4.id_feature_value IN (727, 726))) GROUP BY fp.id_feature_value	7.743 ms	9680832	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)
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:57' >= sp.from) AND (sp.to = '0000-00-00 00:00:00' OR '2025-04-25 20:00:57' <= 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) LEFT JOIN mmag_feature_product fp_3 ON (p.id_product = fp_3.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, 1199, 1225, 775))) AND ((fp_2.id_feature_value IN (741, 1198))) AND ((fp_3.id_feature_value IN (727, 726))) 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:57' >= sp_1.from) AND (sp_1.to = '0000-00-00 00:00:00' OR '2025-04-25 20:00:57' <= 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) LEFT JOIN mmag_feature_product fp_4 ON (p.id_product = fp_4.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, 1199, 1225, 775))) AND ((fp_3.id_feature_value IN (741, 1198))) AND ((fp_4.id_feature_value IN (727, 726))) GROUP BY pac.id_attribute	7.723 ms	4840416	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)
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:57' >= sp.from) AND (sp.to = '0000-00-00 00:00:00' OR '2025-04-25 20:00:57' <= 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) LEFT JOIN mmag_feature_product fp_3 ON (p.id_product = fp_3.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, 1199, 1225, 775))) AND ((fp_2.id_feature_value IN (741, 1198))) AND ((fp_3.id_feature_value IN (727, 726))) 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:57' >= sp_1.from) AND (sp_1.to = '0000-00-00 00:00:00' OR '2025-04-25 20:00:57' <= 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) LEFT JOIN mmag_feature_product fp_4 ON (p.id_product = fp_4.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, 1199, 1225, 775))) AND ((fp_3.id_feature_value IN (741, 1198))) AND ((fp_4.id_feature_value IN (727, 726))) GROUP BY fp.id_feature_value	7.188 ms	4840416	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:57' >= sp.from) AND (sp.to = '0000-00-00 00:00:00' OR '2025-04-25 20:00:57' <= 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) LEFT JOIN mmag_feature_product fp_3 ON (p.id_product = fp_3.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, 1199, 1225, 775))) AND ((fp_2.id_feature_value IN (741, 1198))) AND ((fp_3.id_feature_value IN (727, 726))) 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:57' >= sp_1.from) AND (sp_1.to = '0000-00-00 00:00:00' OR '2025-04-25 20:00:57' <= 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) LEFT JOIN mmag_feature_product fp_4 ON (p.id_product = fp_4.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, 1199, 1225, 775))) AND ((fp_3.id_feature_value IN (741, 1198))) AND ((fp_4.id_feature_value IN (727, 726))) GROUP BY fp.id_feature_value	7.032 ms	4840416	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)
170	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	5.843 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)
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: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) LEFT JOIN mmag_feature_product fp_3 ON (p.id_product = fp_3.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, 1199, 1225, 775))) AND ((fp_2.id_feature_value IN (741, 1198))) AND ((fp_3.id_feature_value IN (727, 726))) 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: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) LEFT JOIN mmag_feature_product fp_4 ON (p.id_product = fp_4.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, 1199, 1225, 775))) AND ((fp_3.id_feature_value IN (741, 1198))) AND ((fp_4.id_feature_value IN (727, 726)))	5.482 ms	4840416			/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)
102	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: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) LEFT JOIN mmag_feature_product fp_3 ON (p.id_product = fp_3.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, 1199, 1225, 775))) AND ((fp_2.id_feature_value IN (741, 1198))) AND ((fp_3.id_feature_value IN (727, 726))) 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: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) LEFT JOIN mmag_feature_product fp_3 ON (p.id_product = fp_3.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, 1199, 1225, 775))) AND ((fp_2.id_feature_value IN (741, 1198))) AND ((fp_3.id_feature_value IN (727, 726))) AND cg.id_group='1' AND c.level_depth<=3 AND c.nleft>9 AND c.nright<24 GROUP BY cp.id_category	4.793 ms	9680832	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)
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: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) LEFT JOIN mmag_feature_product fp_3 ON (p.id_product = fp_3.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, 1199, 1225, 775))) AND ((fp_2.id_feature_value IN (741, 1198))) AND ((fp_3.id_feature_value IN (727, 726))) 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: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) LEFT JOIN mmag_feature_product fp_4 ON (p.id_product = fp_4.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, 1199, 1225, 775))) AND ((fp_3.id_feature_value IN (741, 1198))) AND ((fp_4.id_feature_value IN (727, 726)))	4.651 ms	4840416			/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)
92	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: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) LEFT JOIN mmag_feature_product fp_3 ON (p.id_product = fp_3.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, 1199, 1225, 775))) AND ((fp_2.id_feature_value IN (741, 1198))) AND ((fp_3.id_feature_value IN (727, 726))) 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	4.496 ms	4704	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)
109	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) LEFT JOIN mmag_feature_product fp_3 ON (p.id_product = fp_3.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, 1199, 1225, 775))) AND ((fp_2.id_feature_value IN (741, 1198))) AND ((fp_3.id_feature_value IN (727, 726))) 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) LEFT JOIN mmag_feature_product fp_4 ON (p.id_product = fp_4.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, 1199, 1225, 775))) AND ((fp_3.id_feature_value IN (741, 1198))) AND ((fp_4.id_feature_value IN (727, 726))) GROUP BY fp.id_feature_value	4.390 ms	4840416	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)
96	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: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) LEFT JOIN mmag_feature_product fp_3 ON (p.id_product = fp_3.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, 1199, 1225, 775))) AND ((fp_2.id_feature_value IN (741, 1198))) AND ((fp_3.id_feature_value IN (727, 726))) 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: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) LEFT JOIN mmag_feature_product fp_4 ON (p.id_product = fp_4.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, 1199, 1225, 775))) AND ((fp_3.id_feature_value IN (741, 1198))) AND ((fp_4.id_feature_value IN (727, 726)))	4.389 ms	4840416			/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)
106	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) LEFT JOIN mmag_feature_product fp_3 ON (p.id_product = fp_3.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, 1199, 1225, 775))) AND ((fp_2.id_feature_value IN (741, 1198))) AND ((fp_3.id_feature_value IN (727, 726))) 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) LEFT JOIN mmag_feature_product fp_4 ON (p.id_product = fp_4.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, 1199, 1225, 775))) AND ((fp_3.id_feature_value IN (741, 1198))) AND ((fp_4.id_feature_value IN (727, 726))) GROUP BY pac.id_attribute	4.383 ms	4840416	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)
99	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: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) LEFT JOIN mmag_feature_product fp_3 ON (p.id_product = fp_3.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, 1199, 1225, 775))) AND ((fp_2.id_feature_value IN (741, 1198))) AND ((fp_3.id_feature_value IN (727, 726))) 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) LEFT JOIN mmag_feature_product fp_3 ON (p.id_product = fp_3.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, 1199, 1225, 775))) AND ((fp_2.id_feature_value IN (741, 1198))) AND ((fp_3.id_feature_value IN (727, 726))) AND p.date_add>'2025-04-06 00:00:00'	4.292 ms	4840416			/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)
146	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:57' >= sp.from) AND (sp.to = '0000-00-00 00:00:00' OR '2025-04-25 20:00:57' <= 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) LEFT JOIN mmag_feature_product fp_3 ON (p.id_product = fp_3.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, 1199, 1225, 775))) AND ((fp_2.id_feature_value IN (741, 1198))) AND ((fp_3.id_feature_value IN (727, 726))) 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:57' >= sp_1.from) AND (sp_1.to = '0000-00-00 00:00:00' OR '2025-04-25 20:00:57' <= 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) LEFT JOIN mmag_feature_product fp_4 ON (p.id_product = fp_4.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, 1199, 1225, 775))) AND ((fp_3.id_feature_value IN (741, 1198))) AND ((fp_4.id_feature_value IN (727, 726))) GROUP BY fp.id_feature_value	4.247 ms	4840416	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: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) LEFT JOIN mmag_feature_product fp_3 ON (p.id_product = fp_3.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, 1199, 1225, 775))) AND ((fp_2.id_feature_value IN (741, 1198))) AND ((fp_3.id_feature_value IN (727, 726))) 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) LEFT JOIN mmag_feature_product fp_4 ON (p.id_product = fp_4.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, 1199, 1225, 775))) AND ((fp_3.id_feature_value IN (741, 1198))) AND ((fp_4.id_feature_value IN (727, 726))) GROUP BY fp.id_feature_value	4.217 ms	4840416	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)
112	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:57' >= sp.from) AND (sp.to = '0000-00-00 00:00:00' OR '2025-04-25 20:00:57' <= 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) LEFT JOIN mmag_feature_product fp_3 ON (p.id_product = fp_3.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, 1199, 1225, 775))) AND ((fp_2.id_feature_value IN (741, 1198))) AND ((fp_3.id_feature_value IN (727, 726))) 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:57' >= sp.from) AND (sp.to = '0000-00-00 00:00:00' OR '2025-04-25 20:00:57' <= 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) LEFT JOIN mmag_feature_product fp_3 ON (p.id_product = fp_3.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, 1199, 1225, 775))) AND ((fp_2.id_feature_value IN (741, 1198))) AND ((fp_3.id_feature_value IN (727, 726))) GROUP BY p.id_manufacturer	3.997 ms	4840416	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)
113	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:57' >= sp.from) AND (sp.to = '0000-00-00 00:00:00' OR '2025-04-25 20:00:57' <= 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) LEFT JOIN mmag_feature_product fp_3 ON (p.id_product = fp_3.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, 1199, 1225, 775))) AND ((fp_2.id_feature_value IN (741, 1198))) AND ((fp_3.id_feature_value IN (727, 726))) 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:57' >= sp.from) AND (sp.to = '0000-00-00 00:00:00' OR '2025-04-25 20:00:57' <= 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) LEFT JOIN mmag_feature_product fp_3 ON (p.id_product = fp_3.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, 1199, 1225, 775))) AND ((fp_2.id_feature_value IN (741, 1198))) AND ((fp_3.id_feature_value IN (727, 726))) GROUP BY p.condition	3.978 ms	4840416	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)
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: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) LEFT JOIN mmag_feature_product fp_3 ON (p.id_product = fp_3.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, 1199, 1225, 775))) AND ((fp_2.id_feature_value IN (741, 1198))) AND ((fp_3.id_feature_value IN (727, 726))) 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) LEFT JOIN mmag_feature_product fp_4 ON (p.id_product = fp_4.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, 1199, 1225, 775))) AND ((fp_3.id_feature_value IN (741, 1198))) AND ((fp_4.id_feature_value IN (727, 726))) GROUP BY pac.id_attribute	3.744 ms	4840416	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)
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.674 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)

20 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) 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, XX))) AND ((fp_XX.id_feature_value IN (XX, XX))) AND ((fp_XX.id_feature_value IN (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) 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, XX))) AND ((fp_XX.id_feature_value IN (XX, XX))) AND ((fp_XX.id_feature_value IN (XX, XX))) GROUP BY fp.id_feature_value
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
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
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 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
7 queries	SELECT c.`nleft`, c.`nright` FROM `mmag_category` c WHERE c.`id_category` = XX LIMIT XX
7 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
6 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
6 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`
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) 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, XX))) AND ((fp_XX.id_feature_value IN (XX, XX))) AND ((fp_XX.id_feature_value IN (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) 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, XX))) AND ((fp_XX.id_feature_value IN (XX, XX))) AND ((fp_XX.id_feature_value IN (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 * 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
4 queries	SELECT * FROM `mmag_category_lang` WHERE `id_category` = XX AND `id_shop` = XX
4 queries	SELECT XX FROM `mmag_specific_price` WHERE id_product = XX LIMIT 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 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
3 queries	SELECT name FROM mmag_category_lang WHERE id_shop = XX AND id_lang = XX AND id_category = XX LIMIT XX
3 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
3 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
3 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
3 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)
3 queries	SELECT `id_tax_rules_group` FROM `mmag_product_shop` WHERE `id_product` = XX AND id_shop=XX LIMIT XX
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
3 queries	SELECT `reduction` FROM `mmag_product_group_reduction_cache` WHERE `id_product` = XX AND `id_group` = XX LIMIT XX
3 queries	SELECT COUNT(*) FROM `mmag_pack` WHERE id_product_pack = XX LIMIT XX
3 queries	SELECT product_type FROM `mmag_product` WHERE id_product = XX LIMIT XX
3 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
3 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
3 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
3 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
3 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
3 queries	SELECT * FROM `mmag_product_lang` WHERE `id_product` = XX AND `id_shop` = XX
3 queries	SELECT `id_category` FROM `mmag_category_product` WHERE `id_product` = XX
3 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,%")))
3 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
3 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
3 queries	SELECT `id_product_attribute` FROM `mmag_product_attribute` WHERE `id_product` = XX
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

#	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