Corpuri de Iluminat

Limited special offer

Lampa "GLOBUL LUMINII"

450,00 lei
180,00 lei (inclusiv TVA)

Lampa "GLOBUL LUMINII" combină simplitatea designului modern cu eleganța materialelor, oferind o lumină caldă și plăcută perfectă pentru orice spațiu de lucru sau relaxare.

Adauga in cos

-60%

Limited special offer

(0)

Lampa "UMBRA SERII"

262,50 lei
105,00 lei (inclusiv TVA)

Lampa "UMBRA SERII" aduce un accent modern și elegant oricărui birou sau colț de relaxare, cu un design minimalist în negru mat și lumină ambientală caldă.

Adauga in cos

Lampă de grădină, ornamentala în stil felinar

-40%

Limited special offer

(0)

LAMPĂ DE GRĂDINĂ

299,00 lei
179,40 lei (inclusiv TVA)

Lampă de grădină tip felinar, LANT-CLOE/L1

Adauga in cos

Lampadar Tiffany cu sticlă vitraliată – Eleganță și stil clasic

-40%

Limited special offer

(0)

LAMPADAR STICLĂ VITALIZATĂ TIFFANY

899,00 lei
539,40 lei (inclusiv TVA)

Lampadar din sticla vitralizata Tifanny, I-DAFNE-PT

Adauga in cos

-60%

Limited special offer

(0)

Lustra "LUNA ARGINTIE"

337,50 lei
135,00 lei (inclusiv TVA)

Lustra "LUNA ARGINTIE" aduce o eleganță subtilă în orice încăpere, combinând finisajul metalic cu detalii din lemn natural. Perfectă pentru interioare moderne și rafinate.

Adauga in cos

-60%

Limited special offer

(0)

Lustra "NOAPTEA LINĂ"

337,50 lei
135,00 lei (inclusiv TVA)

Lustra "NOAPTEA LINĂ" aduce un aer de mister și rafinament oricărui spațiu, cu designul său elegant în negru mat și accente naturale din lemn. Ideală pentru interioare moderne și calde.

Adauga in cos

Pendul Suspendat Modern Negru și Auriu – Design Elegant

-40%

Limited special offer

(0)

PENDUL AURIU

699,00 lei
419,40 lei (inclusiv TVA)

Pendul Modern din metal negru si abajur Auriu satinat, I-TWIGA-S1

Adauga in cos

Lampa de Masă Modernă cu Design Circular

-60%

Limited special offer

(0)

VEIOZĂ DE MASĂ

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

Veioză de masă, modernă, finisaj metal alb cromat, I-OLYMPIC-L

Adauga in cos

Veioză modernă de masă din silicon – Design flexibil și inovator

-80%

Limited special offer

(0)

VEIOZĂ DE MASĂ ALBĂ

299,00 lei
59,80 lei (inclusiv TVA)

Veioză Modernă de Masă din Silicon, Stil Contemporan, I-DRUM/L BCO

Adauga in cos

-80%

Limited special offer

(0)

VEIOZĂ DE MASĂ ALBASTRĂ

299,00 lei
59,80 lei (inclusiv TVA)

Veioză Modernă de Masă din Silicon, Stil Contemporan, I-DRUM/L BLU

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	804 ms
Querying Time	351 ms
Queries	538
Memory Peak Usage	18.9 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 $smarty	1k
- 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

Lampa "GLOBUL LUMINII"

Lampa "UMBRA SERII"

LAMPĂ DE GRĂDINĂ

LAMPADAR STICLĂ VITALIZATĂ TIFFANY

Lustra "LUNA ARGINTIE"

Lustra "NOAPTEA LINĂ"

PENDUL AURIU

VEIOZĂ DE MASĂ

VEIOZĂ DE MASĂ ALBĂ

VEIOZĂ DE MASĂ ALBASTRĂ

Meniu

Cautare

Stopwatch SQL - 538 queries

Doubles

Tables stress

ObjectModel instances

Included Files

	Time	Cumulated Time	Memory Usage	Memory Peak Usage
config	38.099 ms	38.099 ms	4.79 Mb	4.9 Mb
__construct	0.016 ms	38.115 ms	- Mb	4.9 Mb
init	22.259 ms	60.374 ms	0.78 Mb	5.6 Mb
checkAccess	0.001 ms	60.375 ms	- Mb	5.6 Mb
setMedia	4.227 ms	64.602 ms	0.18 Mb	5.8 Mb
postProcess	0.001 ms	64.603 ms	- Mb	5.8 Mb
initHeader	0.003 ms	64.606 ms	- Mb	5.8 Mb
initContent	343.019 ms	407.625 ms	9.96 Mb	15.9 Mb
initFooter	0.002 ms	407.627 ms	- Mb	15.9 Mb
display	395.995 ms	804 ms	2.86 Mb	18.9 Mb

Hook	Time	Memory Usage
ActionStAssemble	50.270 ms	1.43 Mb
=> stthemeeditor	0.488 ms	0.01 Mb
=> sthoverimage	0.354 ms	0.01 Mb
=> stcompare	0.005 ms	- Mb
=> ststickers	4.741 ms	0.13 Mb
=> stwishlist	0.279 ms	0.01 Mb
=> stproductcomments	0.324 ms	0.01 Mb
=> stthemeeditor	0.420 ms	0.01 Mb
=> sthoverimage	0.324 ms	0.01 Mb
=> stcompare	0.003 ms	- Mb
=> ststickers	3.177 ms	0.09 Mb
=> stwishlist	0.235 ms	0.01 Mb
=> stproductcomments	0.288 ms	0.01 Mb
=> stthemeeditor	0.407 ms	0.01 Mb
=> sthoverimage	0.338 ms	0.01 Mb
=> stcompare	0.003 ms	- Mb
=> ststickers	5.243 ms	0.15 Mb
=> stwishlist	0.298 ms	0.01 Mb
=> stproductcomments	0.256 ms	0.01 Mb
=> stthemeeditor	0.403 ms	0.01 Mb
=> sthoverimage	0.344 ms	0.01 Mb
=> stcompare	0.003 ms	- Mb
=> ststickers	3.722 ms	0.11 Mb
=> stwishlist	0.264 ms	0.01 Mb
=> stproductcomments	0.273 ms	0.01 Mb
=> stthemeeditor	0.367 ms	0.01 Mb
=> sthoverimage	0.316 ms	0.01 Mb
=> stcompare	0.003 ms	- Mb
=> ststickers	3.559 ms	0.11 Mb
=> stwishlist	0.228 ms	0.01 Mb
=> stproductcomments	0.296 ms	0.01 Mb
=> stthemeeditor	0.406 ms	0.01 Mb
=> sthoverimage	0.298 ms	0.01 Mb
=> stcompare	0.002 ms	- Mb
=> ststickers	3.279 ms	0.09 Mb
=> stwishlist	0.270 ms	0.01 Mb
=> stproductcomments	0.301 ms	0.01 Mb
=> stthemeeditor	0.362 ms	0.01 Mb
=> sthoverimage	0.325 ms	0.01 Mb
=> stcompare	0.002 ms	- Mb
=> ststickers	4.465 ms	0.13 Mb
=> stwishlist	0.258 ms	0.01 Mb
=> stproductcomments	0.306 ms	0.01 Mb
=> stthemeeditor	0.397 ms	0.01 Mb
=> sthoverimage	0.334 ms	0.01 Mb
=> stcompare	0.003 ms	- Mb
=> ststickers	3.040 ms	0.09 Mb
=> stwishlist	0.263 ms	0.01 Mb
=> stproductcomments	0.257 ms	0.01 Mb
=> stthemeeditor	0.374 ms	0.01 Mb
=> sthoverimage	0.324 ms	0.01 Mb
=> stcompare	0.003 ms	- Mb
=> ststickers	3.123 ms	0.09 Mb
=> stwishlist	0.241 ms	0.01 Mb
=> stproductcomments	0.268 ms	0.01 Mb
=> stthemeeditor	0.433 ms	0.01 Mb
=> sthoverimage	0.331 ms	0.01 Mb
=> stcompare	0.002 ms	- Mb
=> ststickers	3.077 ms	0.09 Mb
=> stwishlist	0.255 ms	0.01 Mb
=> stproductcomments	0.310 ms	0.01 Mb
DisplayHeader	15.947 ms	0.83 Mb
=> stthemeeditor	3.964 ms	0.24 Mb
=> ps_googleanalytics	0.231 ms	0.01 Mb
=> stcustomersignin	0.776 ms	0.02 Mb
=> stmultilink	0.237 ms	0.01 Mb
=> stsearchbar	0.312 ms	0.01 Mb
=> stshoppingcart	0.461 ms	0.01 Mb
=> stmegamenu	0.344 ms	0.01 Mb
=> stswiper	0.245 ms	0.07 Mb
=> stowlcarousel	0.277 ms	0.01 Mb
=> steasycontent	0.324 ms	0.03 Mb
=> stfeaturedslider	0.300 ms	0.01 Mb
=> stfeaturedcategories	0.232 ms	0.01 Mb
=> stblogeditor	0.276 ms	0.01 Mb
=> stblogfeaturedarticles	0.216 ms	0.01 Mb
=> stbanner	0.279 ms	0.01 Mb
=> stbrandsslider	0.246 ms	0.01 Mb
=> stspecialslider	0.307 ms	0.01 Mb
=> stblogrecentarticles	0.208 ms	0.01 Mb
=> stnewsletter	0.319 ms	0.01 Mb
=> stblogarchives	0.017 ms	- Mb
=> stblogcomments	0.062 ms	- Mb
=> stblogrelatedarticles	0.229 ms	0.01 Mb
=> stcountdown	0.353 ms	0.01 Mb
=> sthoverimage	0.055 ms	- Mb
=> stinstagram	0.563 ms	0.04 Mb
=> stcompare	0.418 ms	0.01 Mb
=> stnotification	0.254 ms	0.01 Mb
=> stpagebanner	0.236 ms	0.01 Mb
=> stproductcategoriesslider	0.274 ms	0.01 Mb
=> strelatedproducts	0.337 ms	0.01 Mb
=> stsidebar	0.237 ms	0.01 Mb
=> ststickers	1.034 ms	0.09 Mb
=> stvideo	0.236 ms	0.01 Mb
=> stwishlist	0.309 ms	0.02 Mb
=> stproductcomments	0.447 ms	0.01 Mb
=> stproductsasattrs	0.356 ms	0.01 Mb
=> sturls	0.043 ms	- Mb
=> cookiesplus	0.826 ms	0.02 Mb
=> ets_recaptcha_free	0.015 ms	- Mb
=> ets_whatsapp	0.092 ms	- Mb
DisplayBeforeBodyClosingTag	7.186 ms	0.48 Mb
=> ps_googleanalytics	1.941 ms	0.07 Mb
=> statsdata	0.740 ms	0.06 Mb
=> stwishlist	0.170 ms	- Mb
=> cookiesplus	4.335 ms	0.34 Mb
DisplaySideBar	4.082 ms	0.16 Mb
=> stsidebar	0.772 ms	0.02 Mb
=> stnewsletter	0.872 ms	0.02 Mb
=> stmegamenu	0.439 ms	0.03 Mb
=> stwishlist	1.128 ms	0.06 Mb
=> stsearchbar	0.377 ms	0.01 Mb
=> stshoppingcart	0.494 ms	0.03 Mb
displayLeftColumn	3.206 ms	0.15 Mb
=> ps_categorytree (widget)	3.206 ms	0.15 Mb
ActionFrontControllerSetMedia	2.611 ms	0.05 Mb
=> ps_emailalerts	0.077 ms	- Mb
=> cookiesplus	2.534 ms	0.05 Mb
displayBanner	2.504 ms	0.16 Mb
=> stnotification (widget)	1.518 ms	0.09 Mb
=> steasycontent (widget)	0.986 ms	0.06 Mb
displayTop	2.495 ms	0.16 Mb
=> stcustomersignin (widget)	1.998 ms	0.15 Mb
=> stshoppingcart (widget)	0.497 ms	0.01 Mb
ActionOutputHTMLBefore	1.742 ms	0.01 Mb
=> cookiesplus	1.549 ms	0.01 Mb
=> stswiper	0.054 ms	- Mb
=> stbanner	0.080 ms	- Mb
=> stinstagram	0.059 ms	- Mb
DisplayMobileBarLeft	1.384 ms	0.14 Mb
=> stsidebar	1.384 ms	0.14 Mb
DisplayFooter	1.343 ms	0.08 Mb
=> ets_whatsapp	0.399 ms	0.02 Mb
=> stnewsletter	0.355 ms	0.02 Mb
=> stmultilink	0.289 ms	0.02 Mb
=> steasycontent	0.300 ms	0.02 Mb
ActionDispatcherBefore	1.168 ms	0.01 Mb
=> sturls	1.160 ms	0.01 Mb
=> ets_delete_order	0.008 ms	- Mb
displayHeaderCenter	1.004 ms	0.03 Mb
=> stsearchbar (widget)	1.004 ms	0.03 Mb
DisplayMainMenu	0.913 ms	0.03 Mb
=> stmegamenu	0.913 ms	0.03 Mb
displayFullWidthTop	0.837 ms	0.05 Mb
=> stswiper (widget)	0.822 ms	0.05 Mb
=> steasycontent (widget)	0.015 ms	- Mb
DisplayLeftColumn	0.815 ms	0.15 Mb
=> ps_facetedsearch	0.408 ms	0.14 Mb
=> stmegamenu	0.407 ms	0.01 Mb
DisplayCategoryHeader	0.779 ms	0.03 Mb
=> stswiper	0.236 ms	0.01 Mb
=> stowlcarousel	0.240 ms	0.01 Mb
=> stbanner	0.303 ms	0.01 Mb
displayBeforeBodyClosingTag	0.699 ms	0.02 Mb
=> stnotification (widget)	0.699 ms	0.02 Mb
ActionProductSearchAfter	0.678 ms	0.02 Mb
=> stthemeeditor	0.005 ms	- Mb
=> stcountdown	0.011 ms	- Mb
=> stcompare	0.028 ms	- Mb
=> ststickers	0.601 ms	0.01 Mb
=> stwishlist	0.033 ms	- Mb
DisplayMobileBar	0.674 ms	0.03 Mb
=> stsidebar	0.674 ms	0.03 Mb
DisplayRightBar	0.440 ms	0.04 Mb
=> stsidebar	0.440 ms	0.04 Mb
DisplayFooterAfter	0.337 ms	0.01 Mb
=> stmultilink	0.337 ms	0.01 Mb
DisplayBreadcrumb	0.308 ms	0.01 Mb
=> stpagebanner	0.308 ms	0.01 Mb
DisplayNav1	0.263 ms	0.02 Mb
=> stmultilink	0.263 ms	0.02 Mb
DisplayNav2	0.258 ms	0.01 Mb
=> stmultilink	0.258 ms	0.01 Mb
ProductSearchProvider	0.231 ms	- Mb
=> ps_facetedsearch	0.231 ms	- Mb
DisplayMobileBarBottom	0.188 ms	- Mb
=> stsidebar	0.188 ms	- Mb
DisplayMobileBarCenter	0.151 ms	- Mb
=> stsidebar	0.151 ms	- Mb
ModuleRoutes	0.099 ms	0.01 Mb
=> stblog	0.022 ms	- Mb
=> stblogarchives	0.002 ms	- Mb
=> stblogsearch	0.002 ms	- Mb
=> sturls	0.045 ms	0.01 Mb
=> cookiesplus	0.028 ms	- Mb
ActionDispatcher	0.030 ms	- Mb
=> sturls	0.030 ms	- Mb
displayFullWidthTop2	0.012 ms	- Mb
=> steasycontent (widget)	0.012 ms	- Mb
OverrideLayoutTemplate	0.012 ms	- Mb
=> stblog	0.003 ms	- Mb
=> stblog	0.003 ms	- Mb
=> stblog	0.006 ms	- Mb
DisplayAfterBodyOpeningTag	0.011 ms	- Mb
=> cookiesplus	0.011 ms	- Mb
DisplayFullWidthBottom	0.007 ms	- Mb
=> stblogfeaturedarticles	0.007 ms	- Mb
DisplayFullWidthTop	0.004 ms	- Mb
=> stfeaturedslider	0.003 ms	- Mb
=> stproductcategoriesslider	0.001 ms	- Mb
FilterProductSearch	0.003 ms	- Mb
=> stsearchbar	0.003 ms	- Mb
36 hook(s)	102.690 ms	4.12 Mb

Module	Time	Memory Usage
sturls	2.382 ms	0.06 Mb
__construct	1.093 ms	0.04 Mb
hookModuleRoutes	0.046 ms	0.01 Mb
hookActionDispatcherBefore	1.166 ms	0.01 Mb
hookActionDispatcher	0.033 ms	- Mb
hookDisplayHeader	0.044 ms	- Mb
stblog	4.458 ms	0.10 Mb
__construct	4.405 ms	0.09 Mb
hookModuleRoutes	0.029 ms	- Mb
hookOverrideLayoutTemplate	0.006 ms	- Mb
hookOverrideLayoutTemplate	0.005 ms	- Mb
hookOverrideLayoutTemplate	0.013 ms	- Mb
stblogarchives	0.740 ms	0.03 Mb
__construct	0.718 ms	0.03 Mb
hookModuleRoutes	0.004 ms	- Mb
hookDisplayHeader	0.018 ms	- Mb
stblogsearch	0.765 ms	0.03 Mb
__construct	0.745 ms	0.03 Mb
hookModuleRoutes	0.020 ms	- Mb
cookiesplus	13.432 ms	0.52 Mb
__construct	4.130 ms	0.09 Mb
hookModuleRoutes	0.031 ms	- Mb
hookActionFrontControllerSetMedia	2.537 ms	0.05 Mb
hookDisplayHeader	0.829 ms	0.02 Mb
hookDisplayAfterBodyOpeningTag	0.016 ms	- Mb
hookDisplayBeforeBodyClosingTag	4.337 ms	0.34 Mb
hookActionOutputHTMLBefore	1.552 ms	0.01 Mb
ets_delete_order	2.129 ms	0.14 Mb
__construct	2.118 ms	0.14 Mb
hookActionDispatcherBefore	0.011 ms	- Mb
ps_emailalerts	1.326 ms	0.12 Mb
__construct	1.245 ms	0.12 Mb
hookActionFrontControllerSetMedia	0.081 ms	- Mb
stthemeeditor	8.493 ms	0.48 Mb
__construct	0.434 ms	0.09 Mb
hookDisplayHeader	3.967 ms	0.24 Mb
hookActionStAssemble	0.493 ms	0.02 Mb
hookActionStAssemble	0.423 ms	0.01 Mb
hookActionStAssemble	0.410 ms	0.01 Mb
hookActionStAssemble	0.405 ms	0.01 Mb
hookActionStAssemble	0.370 ms	0.01 Mb
hookActionStAssemble	0.409 ms	0.01 Mb
hookActionStAssemble	0.364 ms	0.01 Mb
hookActionStAssemble	0.399 ms	0.01 Mb
hookActionStAssemble	0.377 ms	0.01 Mb
hookActionStAssemble	0.436 ms	0.01 Mb
hookActionProductSearchAfter	0.006 ms	- Mb
ps_googleanalytics	2.296 ms	0.11 Mb
__construct	0.116 ms	0.03 Mb
hookDisplayHeader	0.236 ms	0.01 Mb
hookDisplayBeforeBodyClosingTag	1.944 ms	0.07 Mb
stcustomersignin	2.905 ms	0.19 Mb
__construct	0.126 ms	0.02 Mb
hookDisplayHeader	0.778 ms	0.02 Mb
displayTop	2.001 ms	0.15 Mb
stmultilink	1.620 ms	0.13 Mb
__construct	0.221 ms	0.05 Mb
hookDisplayHeader	0.240 ms	0.01 Mb
hookDisplayNav1	0.266 ms	0.02 Mb
hookDisplayNav2	0.261 ms	0.01 Mb
hookDisplayFooter	0.292 ms	0.02 Mb
hookDisplayFooterAfter	0.340 ms	0.01 Mb
stsearchbar	1.849 ms	0.09 Mb
__construct	0.140 ms	0.03 Mb
hookDisplayHeader	0.315 ms	0.01 Mb
displayHeaderCenter	1.008 ms	0.03 Mb
hookFilterProductSearch	0.006 ms	- Mb
hookDisplaySideBar	0.380 ms	0.01 Mb
stshoppingcart	1.634 ms	0.14 Mb
__construct	0.174 ms	0.08 Mb
hookDisplayHeader	0.463 ms	0.01 Mb
displayTop	0.500 ms	0.01 Mb
hookDisplaySideBar	0.497 ms	0.03 Mb
stmegamenu	2.328 ms	0.14 Mb
__construct	0.214 ms	0.06 Mb
hookDisplayHeader	0.347 ms	0.01 Mb
hookDisplayMainMenu	0.916 ms	0.03 Mb
hookDisplayLeftColumn	0.410 ms	0.01 Mb
hookDisplaySideBar	0.441 ms	0.03 Mb
stswiper	1.717 ms	0.23 Mb
__construct	0.350 ms	0.09 Mb
hookDisplayHeader	0.247 ms	0.07 Mb
displayFullWidthTop	0.825 ms	0.05 Mb
hookDisplayCategoryHeader	0.239 ms	0.01 Mb
hookActionOutputHTMLBefore	0.056 ms	- Mb
stowlcarousel	0.724 ms	0.08 Mb
__construct	0.201 ms	0.06 Mb
hookDisplayHeader	0.280 ms	0.01 Mb
hookDisplayCategoryHeader	0.243 ms	0.01 Mb
steasycontent	2.061 ms	0.29 Mb
__construct	0.414 ms	0.17 Mb
hookDisplayHeader	0.327 ms	0.03 Mb
displayBanner	0.989 ms	0.06 Mb
displayFullWidthTop	0.016 ms	- Mb
displayFullWidthTop2	0.013 ms	- Mb
hookDisplayFooter	0.302 ms	0.02 Mb
stfeaturedslider	0.530 ms	0.08 Mb
__construct	0.223 ms	0.07 Mb
hookDisplayHeader	0.303 ms	0.01 Mb
hookDisplayFullWidthTop	0.004 ms	- Mb
stfeaturedcategories	0.391 ms	0.05 Mb
__construct	0.156 ms	0.04 Mb
hookDisplayHeader	0.235 ms	0.01 Mb
stblogeditor	0.384 ms	0.05 Mb
__construct	0.105 ms	0.03 Mb
hookDisplayHeader	0.279 ms	0.01 Mb
stblogfeaturedarticles	0.393 ms	0.13 Mb
__construct	0.164 ms	0.11 Mb
hookDisplayHeader	0.219 ms	0.01 Mb
hookDisplayFullWidthBottom	0.010 ms	- Mb
stbanner	0.919 ms	0.09 Mb
__construct	0.250 ms	0.06 Mb
hookDisplayHeader	0.282 ms	0.01 Mb
hookDisplayCategoryHeader	0.306 ms	0.01 Mb
hookActionOutputHTMLBefore	0.081 ms	- Mb
stbrandsslider	0.390 ms	0.04 Mb
__construct	0.142 ms	0.03 Mb
hookDisplayHeader	0.248 ms	0.01 Mb
stspecialslider	0.535 ms	0.04 Mb
__construct	0.225 ms	0.03 Mb
hookDisplayHeader	0.310 ms	0.01 Mb
stblogrecentarticles	0.316 ms	0.04 Mb
__construct	0.106 ms	0.03 Mb
hookDisplayHeader	0.210 ms	0.01 Mb
stnewsletter	1.711 ms	0.16 Mb
__construct	0.157 ms	0.11 Mb
hookDisplayHeader	0.321 ms	0.01 Mb
hookDisplayFooter	0.357 ms	0.02 Mb
hookDisplaySideBar	0.876 ms	0.02 Mb
stblogcomments	0.219 ms	0.04 Mb
__construct	0.155 ms	0.04 Mb
hookDisplayHeader	0.064 ms	- Mb
stblogrelatedarticles	0.320 ms	0.04 Mb
__construct	0.089 ms	0.03 Mb
hookDisplayHeader	0.231 ms	0.01 Mb
stcountdown	0.506 ms	0.04 Mb
__construct	0.139 ms	0.03 Mb
hookDisplayHeader	0.355 ms	0.02 Mb
hookActionProductSearchAfter	0.012 ms	- Mb
sthoverimage	3.543 ms	0.10 Mb
__construct	0.169 ms	0.03 Mb
hookDisplayHeader	0.057 ms	- Mb
hookActionStAssemble	0.357 ms	0.01 Mb
hookActionStAssemble	0.327 ms	0.01 Mb
hookActionStAssemble	0.341 ms	0.01 Mb
hookActionStAssemble	0.347 ms	0.01 Mb
hookActionStAssemble	0.319 ms	0.01 Mb
hookActionStAssemble	0.300 ms	0.01 Mb
hookActionStAssemble	0.328 ms	0.01 Mb
hookActionStAssemble	0.337 ms	0.01 Mb
hookActionStAssemble	0.327 ms	0.01 Mb
hookActionStAssemble	0.334 ms	0.01 Mb
stinstagram	0.920 ms	0.17 Mb
__construct	0.294 ms	0.13 Mb
hookDisplayHeader	0.566 ms	0.04 Mb
hookActionOutputHTMLBefore	0.060 ms	- Mb
stcompare	0.652 ms	0.06 Mb
__construct	0.161 ms	0.03 Mb
hookDisplayHeader	0.421 ms	0.01 Mb
hookActionStAssemble	0.007 ms	- Mb
hookActionStAssemble	0.004 ms	- Mb
hookActionStAssemble	0.004 ms	- Mb
hookActionStAssemble	0.004 ms	- Mb
hookActionStAssemble	0.004 ms	- Mb
hookActionStAssemble	0.003 ms	- Mb
hookActionStAssemble	0.003 ms	- Mb
hookActionStAssemble	0.004 ms	- Mb
hookActionStAssemble	0.004 ms	- Mb
hookActionStAssemble	0.003 ms	- Mb
hookActionProductSearchAfter	0.030 ms	- Mb
stnotification	2.674 ms	0.18 Mb
__construct	0.192 ms	0.05 Mb
hookDisplayHeader	0.257 ms	0.01 Mb
displayBanner	1.522 ms	0.09 Mb
displayBeforeBodyClosingTag	0.703 ms	0.02 Mb
stpagebanner	0.759 ms	0.06 Mb
__construct	0.211 ms	0.04 Mb
hookDisplayHeader	0.238 ms	0.01 Mb
hookDisplayBreadcrumb	0.310 ms	0.01 Mb
stproductcategoriesslider	0.854 ms	0.15 Mb
__construct	0.575 ms	0.14 Mb
hookDisplayHeader	0.277 ms	0.01 Mb
hookDisplayFullWidthTop	0.002 ms	- Mb
strelatedproducts	0.499 ms	0.04 Mb
__construct	0.159 ms	0.03 Mb
hookDisplayHeader	0.340 ms	0.01 Mb
stsidebar	4.102 ms	0.30 Mb
__construct	0.235 ms	0.05 Mb
hookDisplayHeader	0.240 ms	0.01 Mb
hookDisplayMobileBarLeft	1.387 ms	0.14 Mb
hookDisplayMobileBarCenter	0.154 ms	- Mb
hookDisplayMobileBar	0.677 ms	0.03 Mb
hookDisplayMobileBarBottom	0.191 ms	- Mb
hookDisplaySideBar	0.775 ms	0.02 Mb
hookDisplayRightBar	0.443 ms	0.04 Mb
ststickers	39.384 ms	1.24 Mb
__construct	0.285 ms	0.06 Mb
hookDisplayHeader	1.037 ms	0.09 Mb
hookActionStAssemble	4.745 ms	0.14 Mb
hookActionStAssemble	3.180 ms	0.09 Mb
hookActionStAssemble	5.246 ms	0.15 Mb
hookActionStAssemble	3.725 ms	0.11 Mb
hookActionStAssemble	3.563 ms	0.11 Mb
hookActionStAssemble	3.282 ms	0.09 Mb
hookActionStAssemble	4.468 ms	0.13 Mb
hookActionStAssemble	3.043 ms	0.09 Mb
hookActionStAssemble	3.126 ms	0.09 Mb
hookActionStAssemble	3.080 ms	0.09 Mb
hookActionProductSearchAfter	0.604 ms	0.02 Mb
stvideo	0.541 ms	0.06 Mb
__construct	0.286 ms	0.05 Mb
hookDisplayHeader	0.255 ms	0.01 Mb
stwishlist	4.507 ms	0.20 Mb
__construct	0.237 ms	0.05 Mb
hookDisplayHeader	0.312 ms	0.02 Mb
hookActionStAssemble	0.282 ms	0.01 Mb
hookActionStAssemble	0.238 ms	0.01 Mb
hookActionStAssemble	0.301 ms	0.01 Mb
hookActionStAssemble	0.266 ms	0.01 Mb
hookActionStAssemble	0.231 ms	0.01 Mb
hookActionStAssemble	0.273 ms	0.01 Mb
hookActionStAssemble	0.261 ms	0.01 Mb
hookActionStAssemble	0.266 ms	0.01 Mb
hookActionStAssemble	0.244 ms	0.01 Mb
hookActionStAssemble	0.258 ms	0.01 Mb
hookActionProductSearchAfter	0.035 ms	- Mb
hookDisplaySideBar	1.131 ms	0.06 Mb
hookDisplayBeforeBodyClosingTag	0.172 ms	- Mb
stproductcomments	3.703 ms	0.21 Mb
__construct	0.350 ms	0.13 Mb
hookDisplayHeader	0.449 ms	0.01 Mb
hookActionStAssemble	0.327 ms	0.01 Mb
hookActionStAssemble	0.291 ms	0.01 Mb
hookActionStAssemble	0.258 ms	0.01 Mb
hookActionStAssemble	0.275 ms	0.01 Mb
hookActionStAssemble	0.299 ms	0.01 Mb
hookActionStAssemble	0.303 ms	0.01 Mb
hookActionStAssemble	0.309 ms	0.01 Mb
hookActionStAssemble	0.259 ms	0.01 Mb
hookActionStAssemble	0.270 ms	0.01 Mb
hookActionStAssemble	0.313 ms	0.01 Mb
stproductsasattrs	0.539 ms	0.06 Mb
__construct	0.181 ms	0.04 Mb
hookDisplayHeader	0.358 ms	0.02 Mb
ets_recaptcha_free	0.216 ms	0.03 Mb
__construct	0.199 ms	0.03 Mb
hookDisplayHeader	0.017 ms	- Mb
ets_whatsapp	0.680 ms	0.04 Mb
__construct	0.183 ms	0.02 Mb
hookDisplayHeader	0.095 ms	- Mb
hookDisplayFooter	0.402 ms	0.02 Mb
ps_facetedsearch	0.987 ms	0.18 Mb
__construct	0.342 ms	0.04 Mb
hookProductSearchProvider	0.234 ms	- Mb
hookDisplayLeftColumn	0.411 ms	0.14 Mb
ps_categorytree	3.356 ms	0.17 Mb
__construct	0.146 ms	0.02 Mb
displayLeftColumn	3.210 ms	0.15 Mb
statsdata	0.914 ms	0.08 Mb
__construct	0.171 ms	0.02 Mb
hookDisplayBeforeBodyClosingTag	0.743 ms	0.06 Mb
47 module(s)	126.302 ms	6.98 Mb

23 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
23 queries	SELECT c.`nleft`, c.`nright` FROM `mmag_category` c WHERE c.`id_category` = XX LIMIT XX
23 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
21 queries	SELECT fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, pl.name FROM mmag_product p LEFT JOIN mmag_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mmag_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN mmag_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, XX) = sa.id_product_attribute AND sa.id_shop = XX AND sa.id_shop_group = XX ) LEFT JOIN mmag_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN mmag_product_lang pl ON (p.id_product = pl.id_product AND pl.id_shop = XX AND pl.id_lang = XX) INNER JOIN mmag_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = XX AND ps.active = TRUE) INNER JOIN mmag_category_product cp ON (p.id_product = cp.id_product) INNER JOIN mmag_category c ON (cp.id_category = c.id_category AND c.active=XX) LEFT JOIN mmag_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN mmag_specific_price sp ON ( sp.id_product = p.id_product AND sp.id_shop IN (XX, XX) AND sp.id_currency IN (XX, XX) AND sp.id_country IN (XX, XX) AND sp.id_group IN (XX, XX) AND sp.from_quantity = XX AND sp.reduction > XX AND sp.id_customer = XX AND sp.id_cart = XX AND (sp.from = 'XX-XX-XX XX:XX:XX' OR 'XX-XX-XX XX:XX:XX' >= sp.from) AND (sp.to = 'XX-XX-XX XX:XX:XX' OR 'XX-XX-XX XX:XX:XX' <= sp.to) ) LEFT JOIN mmag_feature_product fp_XX ON (p.id_product = fp_XX.id_product) LEFT JOIN mmag_feature_product fp_XX ON (p.id_product = fp_XX.id_product) WHERE ((sp.reduction>XX)) AND ((fp_XX.id_feature_value IN (XX, XX, XX, XX, XX, XX, XX, XX, XX, XX, XX, XX, XX))) AND ((fp_XX.id_feature_value IN (XX, XX, XX, XX))) AND ps.id_shop='XX' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='XX' AND c.nleft>=XX AND c.nright<=XX GROUP BY p.id_product) p INNER JOIN mmag_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN mmag_specific_price sp_XX ON ( sp_XX.id_product = p.id_product AND sp_XX.id_shop IN (XX, XX) AND sp_XX.id_currency IN (XX, XX) AND sp_XX.id_country IN (XX, XX) AND sp_XX.id_group IN (XX, XX) AND sp_XX.from_quantity = XX AND sp_XX.reduction > XX AND sp_XX.id_customer = XX AND sp_XX.id_cart = XX AND (sp_XX.from = 'XX-XX-XX XX:XX:XX' OR 'XX-XX-XX XX:XX:XX' >= sp_XX.from) AND (sp_XX.to = 'XX-XX-XX XX:XX:XX' OR 'XX-XX-XX XX:XX:XX' <= sp_XX.to) ) LEFT JOIN mmag_feature_product fp_XX ON (p.id_product = fp_XX.id_product) LEFT JOIN mmag_feature_product fp_XX ON (p.id_product = fp_XX.id_product) WHERE ((fp.id_feature=XX)) AND ((sp_XX.reduction>XX)) AND ((fp_XX.id_feature_value IN (XX, XX, XX, XX, XX, XX, XX, XX, XX, XX, XX, XX, XX))) AND ((fp_XX.id_feature_value IN (XX, XX, XX, XX))) GROUP BY fp.id_feature_value
20 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`
19 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
11 queries	SELECT XX FROM `mmag_specific_price` WHERE id_product = XX LIMIT XX
10 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
10 queries	SELECT name FROM mmag_category_lang WHERE id_shop = XX AND id_lang = XX AND id_category = XX LIMIT XX
10 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
10 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
10 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
10 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)
10 queries	SELECT `id_tax_rules_group` FROM `mmag_product_shop` WHERE `id_product` = XX AND id_shop=XX LIMIT XX
10 queries	SELECT `reduction` FROM `mmag_product_group_reduction_cache` WHERE `id_product` = XX AND `id_group` = XX LIMIT XX
10 queries	SELECT COUNT(*) FROM `mmag_pack` WHERE id_product_pack = XX LIMIT XX
10 queries	SELECT product_type FROM `mmag_product` WHERE id_product = XX LIMIT XX
10 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
10 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
10 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
10 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
10 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
10 queries	SELECT * FROM `mmag_product_lang` WHERE `id_product` = XX AND `id_shop` = XX
10 queries	SELECT `id_category` FROM `mmag_category_product` WHERE `id_product` = XX
10 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
10 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
10 queries	SELECT `id_product_attribute` FROM `mmag_product_attribute` WHERE `id_product` = XX
9 queries	SELECT * FROM `mmag_category` a LEFT JOIN `mmag_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = XX LEFT JOIN `mmag_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = XX WHERE (a.`id_category` = XX) AND (b.`id_shop` = XX) LIMIT XX
8 queries	SELECT 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,%")))
7 queries	SELECT m.`id_module`, m.`name`, ms.`id_module`as `mshop` FROM `mmag_module` m LEFT JOIN `mmag_module_shop` ms ON m.`id_module` = ms.`id_module` AND ms.`id_shop` = XX
7 queries	SELECT * FROM `mmag_category` a LEFT JOIN `mmag_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = XX WHERE (a.`id_category` = XX) LIMIT XX
7 queries	SELECT * FROM `mmag_category_lang` WHERE `id_category` = XX AND `id_shop` = XX
5 queries	SELECT DISTINCT a.`id_attribute`, a.`color`, al.`name`, agl.`id_attribute_group`, IF(lialv.`url_name` IS NULL OR lialv.`url_name` = "", NULL, lialv.`url_name`) AS url_name, IF(lialv.`meta_title` IS NULL OR lialv.`meta_title` = "", NULL, lialv.`meta_title`) AS meta_title FROM `mmag_attribute_group` ag INNER JOIN `mmag_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = XX) INNER JOIN `mmag_attribute` a ON a.`id_attribute_group` = ag.`id_attribute_group` INNER JOIN `mmag_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = XX) INNER JOIN mmag_attribute_group_shop attribute_group_shop ON (attribute_group_shop.id_attribute_group = ag.id_attribute_group AND attribute_group_shop.id_shop = XX) INNER JOIN mmag_attribute_shop attribute_shop ON (attribute_shop.id_attribute = a.id_attribute AND attribute_shop.id_shop = XX) LEFT JOIN `mmag_layered_indexable_attribute_lang_value` lialv ON (a.`id_attribute` = lialv.`id_attribute` AND lialv.`id_lang` = XX) WHERE ag.id_attribute_group = XX ORDER BY agl.`name` ASC, a.`position` ASC
5 queries	SELECT pac.id_attribute, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, pl.name FROM mmag_product p LEFT JOIN mmag_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mmag_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN mmag_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, XX) = sa.id_product_attribute AND sa.id_shop = XX AND sa.id_shop_group = XX ) LEFT JOIN mmag_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN mmag_product_lang pl ON (p.id_product = pl.id_product AND pl.id_shop = XX AND pl.id_lang = XX) INNER JOIN mmag_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = XX AND ps.active = TRUE) INNER JOIN mmag_category_product cp ON (p.id_product = cp.id_product) INNER JOIN mmag_category c ON (cp.id_category = c.id_category AND c.active=XX) LEFT JOIN mmag_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN mmag_specific_price sp ON ( sp.id_product = p.id_product AND sp.id_shop IN (XX, XX) AND sp.id_currency IN (XX, XX) AND sp.id_country IN (XX, XX) AND sp.id_group IN (XX, XX) AND sp.from_quantity = XX AND sp.reduction > XX AND sp.id_customer = XX AND sp.id_cart = XX AND (sp.from = 'XX-XX-XX XX:XX:XX' OR 'XX-XX-XX XX:XX:XX' >= sp.from) AND (sp.to = 'XX-XX-XX XX:XX:XX' OR 'XX-XX-XX XX:XX:XX' <= sp.to) ) LEFT JOIN mmag_feature_product fp_XX ON (p.id_product = fp_XX.id_product) LEFT JOIN mmag_feature_product fp_XX ON (p.id_product = fp_XX.id_product) WHERE ((sp.reduction>XX)) AND ((fp_XX.id_feature_value IN (XX, XX, XX, XX, XX, XX, XX, XX, XX, XX, XX, XX, XX))) AND ((fp_XX.id_feature_value IN (XX, XX, XX, XX))) AND ps.id_shop='XX' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='XX' AND c.nleft>=XX AND c.nright<=XX GROUP BY p.id_product) p LEFT JOIN mmag_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mmag_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) INNER JOIN mmag_attribute a ON (a.id_attribute = pac.id_attribute) LEFT JOIN mmag_specific_price sp_XX ON ( sp_XX.id_product = p.id_product AND sp_XX.id_shop IN (XX, XX) AND sp_XX.id_currency IN (XX, XX) AND sp_XX.id_country IN (XX, XX) AND sp_XX.id_group IN (XX, XX) AND sp_XX.from_quantity = XX AND sp_XX.reduction > XX AND sp_XX.id_customer = XX AND sp_XX.id_cart = XX AND (sp_XX.from = 'XX-XX-XX XX:XX:XX' OR 'XX-XX-XX XX:XX:XX' >= sp_XX.from) AND (sp_XX.to = 'XX-XX-XX XX:XX:XX' OR 'XX-XX-XX XX:XX:XX' <= sp_XX.to) ) LEFT JOIN mmag_feature_product fp_XX ON (p.id_product = fp_XX.id_product) LEFT JOIN mmag_feature_product fp_XX ON (p.id_product = fp_XX.id_product) WHERE ((a.id_attribute_group=XX)) AND ((sp_XX.reduction>XX)) AND ((fp_XX.id_feature_value IN (XX, XX, XX, XX, XX, XX, XX, XX, XX, XX, XX, XX, XX))) AND ((fp_XX.id_feature_value IN (XX, XX, XX, XX))) GROUP BY pac.id_attribute
4 queries	SELECT cc.name FROM mmag_cookiesplus_cookie cc LEFT JOIN mmag_cookiesplus_cookie_lang ccl on cc.`id_cookiesplus_cookie` = ccl.`id_cookiesplus_cookie` WHERE `id_cookiesplus_finality` = XX AND ccl.`id_lang` = XX AND cc.`active` = XX AND cc.`id_shop` = XX ORDER BY cc.`name`;
4 queries	SELECT 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
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`;
2 queries	SELECT `id_lang` FROM `mmag_lang` WHERE `locale` = 'ro-ro' OR `language_code` = 'ro-ro' LIMIT XX
2 queries	SELECT `id_category` FROM `mmag_category_shop` WHERE `id_category` = XX AND `id_shop` = XX LIMIT XX
2 queries	SELECT s., sl. ,IF(image_multi_lang<>"" && !ISNULL(image_multi_lang), image_multi_lang, image_lang_default) AS image_multi_lang FROM `mmag_st_sticker` s LEFT JOIN `mmag_st_sticker_lang` sl ON (s.`id_st_sticker` = sl.`id_st_sticker` AND sl.`id_lang` = XX) LEFT JOIN `mmag_st_sticker_shop` ss ON (s.`id_st_sticker` = ss.`id_st_sticker`) LEFT JOIN `mmag_st_sticker_group` sg ON (s.`id_st_sticker` = sg.`id_st_sticker`) WHERE ss.`id_shop` = XX AND s.`active`=XX AND s.`type` IN (XX,XX,XX,XX,XX,XX,XX) AND sg.`id_group` IN (XX) GROUP BY s.`id_st_sticker` ORDER BY s.`position` ASC, s.`id_st_sticker`
2 queries	SELECT cl.`link_rewrite` FROM `mmag_category_lang` cl WHERE `id_lang` = XX AND cl.id_shop = XX AND cl.`id_category` = XX LIMIT XX
2 queries	SELECT XX FROM `mmag_cart_rule` WHERE ((date_to >= "XX-XX-XX XX:XX:XX" AND date_to <= "XX-XX-XX XX:XX:XX") OR (date_from >= "XX-XX-XX XX:XX:XX" AND date_from <= "XX-XX-XX XX:XX:XX") OR (date_from < "XX-XX-XX XX:XX:XX" AND date_to > "XX-XX-XX XX:XX:XX")) AND `id_customer` IN (XX,XX) LIMIT XX
2 queries	SELECT snl., snll. FROM `mmag_st_notification` snl INNER JOIN mmag_st_notification_shop st_notification_shop ON (st_notification_shop.id_st_notification = snl.id_st_notification AND st_notification_shop.id_shop = XX) LEFT JOIN `mmag_st_notification_lang` snll ON (snl.`id_st_notification` = snll.`id_st_notification`) WHERE snl.`active`=XX AND snll.`id_lang` = XX ORDER BY snl.`position`
2 queries	SELECT snl., snll. FROM `mmag_st_sidebar` snl INNER JOIN mmag_st_sidebar_shop st_sidebar_shop ON (st_sidebar_shop.id_st_sidebar = snl.id_st_sidebar AND st_sidebar_shop.id_shop = XX) LEFT JOIN `mmag_st_sidebar_lang` snll ON (snl.`id_st_sidebar` = snll.`id_st_sidebar`) WHERE snll.`id_lang` = XX AND snl.`active`=XX ORDER BY snl.`location`, snl.`position`

Name	Instances	Source
Category	73	/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: 17] /modules/ststickers/classes/StStickersMapClass.php:168 (getParentsCategories) [id: 2] /modules/ststickers/classes/StStickersMapClass.php:159 (__construct) [id: 10] /modules/ststickers/classes/StStickersMapClass.php:168 (getParentsCategories) [id: 2] /modules/ststickers/classes/StStickersMapClass.php:159 (__construct) [id: 17] /modules/ststickers/classes/StStickersMapClass.php:168 (getParentsCategories) [id: 2] /modules/ststickers/classes/StStickersMapClass.php:159 (__construct) [id: 10] /modules/ststickers/classes/StStickersMapClass.php:168 (getParentsCategories) [id: 2] /modules/ststickers/classes/StStickersMapClass.php:159 (__construct) [id: 21] /modules/ststickers/classes/StStickersMapClass.php:168 (getParentsCategories) [id: 2] /modules/ststickers/classes/StStickersMapClass.php:159 (__construct) [id: 26] /modules/ststickers/classes/StStickersMapClass.php:168 (getParentsCategories) [id: 2] /modules/ststickers/classes/StStickersMapClass.php:159 (__construct) [id: 10] /modules/ststickers/classes/StStickersMapClass.php:168 (getParentsCategories) [id: 2] /modules/ststickers/classes/StStickersMapClass.php:159 (__construct) [id: 18] /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: 19] /modules/ststickers/classes/StStickersMapClass.php:168 (getParentsCategories) [id: 2] /modules/ststickers/classes/StStickersMapClass.php:159 (__construct) [id: 10] /modules/ststickers/classes/StStickersMapClass.php:168 (getParentsCategories) [id: 2] /modules/ststickers/classes/StStickersMapClass.php:159 (__construct) [id: 19] /modules/ststickers/classes/StStickersMapClass.php:168 (getParentsCategories) [id: 2] /modules/ststickers/classes/StStickersMapClass.php:159 (__construct) [id: 24] /modules/ststickers/classes/StStickersMapClass.php:168 (getParentsCategories) [id: 2] /modules/ststickers/classes/StStickersMapClass.php:159 (__construct) [id: 10] /modules/ststickers/classes/StStickersMapClass.php:168 (getParentsCategories) [id: 2] /modules/ststickers/classes/StStickersMapClass.php:159 (__construct) [id: 17] /modules/ststickers/classes/StStickersMapClass.php:168 (getParentsCategories) [id: 2] /modules/ststickers/classes/StStickersMapClass.php:159 (__construct) [id: 10] /modules/ststickers/classes/StStickersMapClass.php:168 (getParentsCategories) [id: 2] /modules/ststickers/classes/StStickersMapClass.php:159 (__construct) [id: 17] /modules/ststickers/classes/StStickersMapClass.php:168 (getParentsCategories) [id: 2] /modules/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	40	/classes/Link.php:113 (__construct) [id: 166] /classes/Link.php:113 (__construct) [id: 161] /classes/Link.php:113 (__construct) [id: 94] /classes/Link.php:113 (__construct) [id: 43] /classes/Link.php:113 (__construct) [id: 159] /classes/Link.php:113 (__construct) [id: 158] /classes/Link.php:113 (__construct) [id: 85] /classes/Link.php:113 (__construct) [id: 68] /classes/Link.php:113 (__construct) [id: 48] /classes/Link.php:113 (__construct) [id: 49] /modules/ststickers/classes/StStickersMapClass.php:152 (__construct) [id: 166] /modules/ststickers/classes/StStickersMapClass.php:152 (__construct) [id: 161] /modules/ststickers/classes/StStickersMapClass.php:152 (__construct) [id: 94] /modules/ststickers/classes/StStickersMapClass.php:152 (__construct) [id: 43] /modules/ststickers/classes/StStickersMapClass.php:152 (__construct) [id: 159] /modules/ststickers/classes/StStickersMapClass.php:152 (__construct) [id: 158] /modules/ststickers/classes/StStickersMapClass.php:152 (__construct) [id: 85] /modules/ststickers/classes/StStickersMapClass.php:152 (__construct) [id: 68] /modules/ststickers/classes/StStickersMapClass.php:152 (__construct) [id: 48] /modules/ststickers/classes/StStickersMapClass.php:152 (__construct) [id: 49] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 166] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 161] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 94] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 43] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 159] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 158] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 85] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 68] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 48] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 49] /classes/Link.php:113 (__construct) [id: 166] /classes/Link.php:113 (__construct) [id: 161] /classes/Link.php:113 (__construct) [id: 94] /classes/Link.php:113 (__construct) [id: 43] /classes/Link.php:113 (__construct) [id: 159] /classes/Link.php:113 (__construct) [id: 158] /classes/Link.php:113 (__construct) [id: 85] /classes/Link.php:113 (__construct) [id: 68] /classes/Link.php:113 (__construct) [id: 48] /classes/Link.php:113 (__construct) [id: 49]
Address	4	/classes/shop/Shop.php:486 (__construct) [id: ] /classes/Product.php:3694 (initialize) [id: ] /classes/Product.php:3804 (__construct) [id: ] /classes/Product.php:5964 (__construct) [id: ]
Country	4	/config/config.inc.php:146 (__construct) [id: 36] /classes/AddressFormat.php:404 (__construct) [id: 36] /classes/controller/FrontController.php:1779 (__construct) [id: 36] /modules/ets_whatsapp/ets_whatsapp.php:466 (__construct) [id: 36]
CMS	2	/classes/Link.php:555 (__construct) [id: 11] /classes/Link.php:555 (__construct) [id: 11]
Language	2	/config/config.inc.php:211 (__construct) [id: 1] /classes/Tools.php:560 (__construct) [id: 1]
Tax	2	/classes/tax/TaxRulesTaxManager.php:116 (__construct) [id: 1] /classes/tax/TaxRulesTaxManager.php:116 (__construct) [id: 1]
Currency	2	/src/Adapter/Currency/CurrencyDataProvider.php:101 (__construct) [id: 1] /classes/Tools.php:690 (getCurrencyInstance) [id: 1]
Cart	2	/classes/controller/FrontController.php:467 (__construct) [id: ] /classes/controller/FrontController.php:541 (__construct) [id: ]
State	2	/classes/AddressFormat.php:404 (__construct) [id: 353] /classes/controller/FrontController.php:1778 (__construct) [id: 353]
ConnectionsSource	1	/modules/statsdata/statsdata.php:119 (logHttpReferer) [id: ]
Shop	1	/config/config.inc.php:117 (initialize) [id: 1]
AddressFormat	1	/classes/controller/FrontController.php:1773 (generateAddress) [id: ]
Risk	1	/classes/controller/FrontController.php:1705 (__construct) [id: ]
Group	1	/classes/Cart.php:249 (getCurrent) [id: 1]
Customer	1	/config/config.inc.php:264 (__construct) [id: ]
ShopGroup	1	/classes/shop/Shop.php:561 (__construct) [id: 1]
Gender	1	/classes/controller/FrontController.php:1702 (__construct) [id: 0]

#	Query	Time (ms)	Rows	Filesort	Group By	Location
2	SELECT SQL_NO_CACHE c.`name`, cl.`id_lang`, IF(cl.`id_lang` IS NULL, c.`value`, cl.`value`) AS value, c.id_shop_group, c.id_shop FROM `mmag_configuration` c LEFT JOIN `mmag_configuration_lang` cl ON (c.`id_configuration` = cl.`id_configuration`)	16.862 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)
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`	9.067 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)
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:01:15' >= sp.from) AND (sp.to = '0000-00-00 00:00:00' OR '2025-04-25 20:01:15' <= sp.to) ) LEFT JOIN mmag_feature_product fp_1 ON (p.id_product = fp_1.id_product) WHERE ((sp.reduction>0)) AND ((fp_1.id_feature_value IN (1192, 1247, 1239, 1235, 1229, 1220, 1215, 1212, 1206, 1194, 1173, 1155, 774))) 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:01:15' >= sp_1.from) AND (sp_1.to = '0000-00-00 00:00:00' OR '2025-04-25 20:01:15' <= sp_1.to) ) LEFT JOIN mmag_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((fp.id_feature=5)) AND ((sp_1.reduction>0)) AND ((fp_2.id_feature_value IN (1192, 1247, 1239, 1235, 1229, 1220, 1215, 1212, 1206, 1194, 1173, 1155, 774))) GROUP BY fp.id_feature_value	7.249 ms	109956	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:778 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:855 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:154 (getFeaturesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:357 (runQuery) /override/controllers/front/listing/CategoryController.php:22 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
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:01:15' >= sp.from) AND (sp.to = '0000-00-00 00:00:00' OR '2025-04-25 20:01:15' <= 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))) AND ((fp_2.id_feature_value IN (811, 820, 1047, 833))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=9 AND c.nright<=24 GROUP BY p.id_product) p INNER JOIN mmag_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN mmag_specific_price sp_1 ON ( sp_1.id_product = p.id_product AND sp_1.id_shop IN (0, 1) AND sp_1.id_currency IN (0, 1) AND sp_1.id_country IN (0, 36) AND sp_1.id_group IN (0, 1) AND sp_1.from_quantity = 1 AND sp_1.reduction > 0 AND sp_1.id_customer = 0 AND sp_1.id_cart = 0 AND (sp_1.from = '0000-00-00 00:00:00' OR '2025-04-25 20:01:15' >= sp_1.from) AND (sp_1.to = '0000-00-00 00:00:00' OR '2025-04-25 20:01:15' <= sp_1.to) ) LEFT JOIN mmag_feature_product fp_2 ON (p.id_product = fp_2.id_product) LEFT JOIN mmag_feature_product fp_3 ON (p.id_product = fp_3.id_product) WHERE ((fp.id_feature=2)) AND ((sp_1.reduction>0)) AND ((fp_2.id_feature_value IN (1192, 1247, 1239, 1235, 1229, 1220, 1215, 1212, 1206, 1194, 1173, 1155, 774))) AND ((fp_3.id_feature_value IN (811, 820, 1047, 833))) GROUP BY fp.id_feature_value	4.297 ms	209916	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:778 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:855 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:154 (getFeaturesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:357 (runQuery) /override/controllers/front/listing/CategoryController.php:22 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
100	SELECT SQL_NO_CACHE cp.id_category, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, pl.name FROM mmag_product p LEFT JOIN mmag_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mmag_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN mmag_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN mmag_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN mmag_product_lang pl ON (p.id_product = pl.id_product AND pl.id_shop = 1 AND pl.id_lang = 1) INNER JOIN mmag_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN mmag_category_product cp ON (p.id_product = cp.id_product) INNER JOIN mmag_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN mmag_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN mmag_specific_price sp ON ( sp.id_product = p.id_product AND sp.id_shop IN (0, 1) AND sp.id_currency IN (0, 1) AND sp.id_country IN (0, 36) AND sp.id_group IN (0, 1) AND sp.from_quantity = 1 AND sp.reduction > 0 AND sp.id_customer = 0 AND sp.id_cart = 0 AND (sp.from = '0000-00-00 00:00:00' OR '2025-04-25 20:01:15' >= sp.from) AND (sp.to = '0000-00-00 00:00:00' OR '2025-04-25 20:01:15' <= 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))) AND ((fp_2.id_feature_value IN (811, 820, 1047, 833))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=9 AND c.nright<=24 GROUP BY p.id_product) p INNER JOIN mmag_category_product cp ON (p.id_product = cp.id_product) INNER JOIN mmag_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN mmag_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN mmag_specific_price sp ON ( sp.id_product = p.id_product AND sp.id_shop IN (0, 1) AND sp.id_currency IN (0, 1) AND sp.id_country IN (0, 36) AND sp.id_group IN (0, 1) AND sp.from_quantity = 1 AND sp.reduction > 0 AND sp.id_customer = 0 AND sp.id_cart = 0 AND (sp.from = '0000-00-00 00:00:00' OR '2025-04-25 20:01:15' >= sp.from) AND (sp.to = '0000-00-00 00:00:00' OR '2025-04-25 20:01:15' <= 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))) AND ((fp_2.id_feature_value IN (811, 820, 1047, 833))) AND cg.id_group='1' AND c.level_depth<=3 AND c.nleft>9 AND c.nright<24 GROUP BY cp.id_category	4.077 ms	419832	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)
105	SELECT SQL_NO_CACHE fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, pl.name FROM mmag_product p LEFT JOIN mmag_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mmag_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN mmag_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN mmag_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN mmag_product_lang pl ON (p.id_product = pl.id_product AND pl.id_shop = 1 AND pl.id_lang = 1) INNER JOIN mmag_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN mmag_category_product cp ON (p.id_product = cp.id_product) INNER JOIN mmag_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN mmag_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN mmag_specific_price sp ON ( sp.id_product = p.id_product AND sp.id_shop IN (0, 1) AND sp.id_currency IN (0, 1) AND sp.id_country IN (0, 36) AND sp.id_group IN (0, 1) AND sp.from_quantity = 1 AND sp.reduction > 0 AND sp.id_customer = 0 AND sp.id_cart = 0 AND (sp.from = '0000-00-00 00:00:00' OR '2025-04-25 20:01:15' >= sp.from) AND (sp.to = '0000-00-00 00:00:00' OR '2025-04-25 20:01:15' <= 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))) AND ((fp_2.id_feature_value IN (811, 820, 1047, 833))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=9 AND c.nright<=24 GROUP BY p.id_product) p INNER JOIN mmag_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN mmag_specific_price sp_1 ON ( sp_1.id_product = p.id_product AND sp_1.id_shop IN (0, 1) AND sp_1.id_currency IN (0, 1) AND sp_1.id_country IN (0, 36) AND sp_1.id_group IN (0, 1) AND sp_1.from_quantity = 1 AND sp_1.reduction > 0 AND sp_1.id_customer = 0 AND sp_1.id_cart = 0 AND (sp_1.from = '0000-00-00 00:00:00' OR '2025-04-25 20:01:15' >= sp_1.from) AND (sp_1.to = '0000-00-00 00:00:00' OR '2025-04-25 20:01:15' <= sp_1.to) ) LEFT JOIN mmag_feature_product fp_2 ON (p.id_product = fp_2.id_product) LEFT JOIN mmag_feature_product fp_3 ON (p.id_product = fp_3.id_product) WHERE ((fp.id_feature=1)) AND ((sp_1.reduction>0)) AND ((fp_2.id_feature_value IN (1192, 1247, 1239, 1235, 1229, 1220, 1215, 1212, 1206, 1194, 1173, 1155, 774))) AND ((fp_3.id_feature_value IN (811, 820, 1047, 833))) GROUP BY fp.id_feature_value	3.896 ms	209916	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)
148	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:01:15' >= sp.from) AND (sp.to = '0000-00-00 00:00:00' OR '2025-04-25 20:01:15' <= 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))) AND ((fp_2.id_feature_value IN (811, 820, 1047, 833))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=9 AND c.nright<=24 GROUP BY p.id_product) p INNER JOIN mmag_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN mmag_specific_price sp_1 ON ( sp_1.id_product = p.id_product AND sp_1.id_shop IN (0, 1) AND sp_1.id_currency IN (0, 1) AND sp_1.id_country IN (0, 36) AND sp_1.id_group IN (0, 1) AND sp_1.from_quantity = 1 AND sp_1.reduction > 0 AND sp_1.id_customer = 0 AND sp_1.id_cart = 0 AND (sp_1.from = '0000-00-00 00:00:00' OR '2025-04-25 20:01:15' >= sp_1.from) AND (sp_1.to = '0000-00-00 00:00:00' OR '2025-04-25 20:01:15' <= sp_1.to) ) LEFT JOIN mmag_feature_product fp_2 ON (p.id_product = fp_2.id_product) LEFT JOIN mmag_feature_product fp_3 ON (p.id_product = fp_3.id_product) WHERE ((fp.id_feature=20)) AND ((sp_1.reduction>0)) AND ((fp_2.id_feature_value IN (1192, 1247, 1239, 1235, 1229, 1220, 1215, 1212, 1206, 1194, 1173, 1155, 774))) AND ((fp_3.id_feature_value IN (811, 820, 1047, 833))) GROUP BY fp.id_feature_value	3.883 ms	209916	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)
93	SELECT SQL_NO_CACHE COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, pl.name FROM mmag_product p LEFT JOIN mmag_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mmag_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN mmag_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN mmag_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN mmag_product_lang pl ON (p.id_product = pl.id_product AND pl.id_shop = 1 AND pl.id_lang = 1) INNER JOIN mmag_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN mmag_category_product cp ON (p.id_product = cp.id_product) INNER JOIN mmag_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN mmag_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN mmag_specific_price sp ON ( sp.id_product = p.id_product AND sp.id_shop IN (0, 1) AND sp.id_currency IN (0, 1) AND sp.id_country IN (0, 36) AND sp.id_group IN (0, 1) AND sp.from_quantity = 1 AND sp.reduction > 0 AND sp.id_customer = 0 AND sp.id_cart = 0 AND (sp.from = '0000-00-00 00:00:00' OR '2025-04-25 20:01:15' >= sp.from) AND (sp.to = '0000-00-00 00:00:00' OR '2025-04-25 20:01:15' <= 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))) AND ((fp_2.id_feature_value IN (811, 820, 1047, 833))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=9 AND c.nright<=24 GROUP BY p.id_product) p LEFT JOIN mmag_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mmag_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN mmag_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN mmag_stock_available sa_1 ON (p.id_product = sa_1.id_product AND IFNULL(pac.id_product_attribute, 0) = sa_1.id_product_attribute AND sa_1.id_shop = 1 AND sa_1.id_shop_group = 0 ) LEFT JOIN mmag_specific_price sp_1 ON ( sp_1.id_product = p.id_product AND sp_1.id_shop IN (0, 1) AND sp_1.id_currency IN (0, 1) AND sp_1.id_country IN (0, 36) AND sp_1.id_group IN (0, 1) AND sp_1.from_quantity = 1 AND sp_1.reduction > 0 AND sp_1.id_customer = 0 AND sp_1.id_cart = 0 AND (sp_1.from = '0000-00-00 00:00:00' OR '2025-04-25 20:01:15' >= sp_1.from) AND (sp_1.to = '0000-00-00 00:00:00' OR '2025-04-25 20:01:15' <= sp_1.to) ) LEFT JOIN mmag_feature_product fp_2 ON (p.id_product = fp_2.id_product) LEFT JOIN mmag_feature_product fp_3 ON (p.id_product = fp_3.id_product) WHERE ((sa.quantity<=0 AND sa_1.out_of_stock=0)) AND ((sp_1.reduction>0)) AND ((fp_2.id_feature_value IN (1192, 1247, 1239, 1235, 1229, 1220, 1215, 1212, 1206, 1194, 1173, 1155, 774))) AND ((fp_3.id_feature_value IN (811, 820, 1047, 833)))	3.716 ms	209916			/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)
150	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:01:15' >= sp.from) AND (sp.to = '0000-00-00 00:00:00' OR '2025-04-25 20:01:15' <= 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))) AND ((fp_2.id_feature_value IN (811, 820, 1047, 833))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=9 AND c.nright<=24 GROUP BY p.id_product) p INNER JOIN mmag_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN mmag_specific_price sp_1 ON ( sp_1.id_product = p.id_product AND sp_1.id_shop IN (0, 1) AND sp_1.id_currency IN (0, 1) AND sp_1.id_country IN (0, 36) AND sp_1.id_group IN (0, 1) AND sp_1.from_quantity = 1 AND sp_1.reduction > 0 AND sp_1.id_customer = 0 AND sp_1.id_cart = 0 AND (sp_1.from = '0000-00-00 00:00:00' OR '2025-04-25 20:01:15' >= sp_1.from) AND (sp_1.to = '0000-00-00 00:00:00' OR '2025-04-25 20:01:15' <= sp_1.to) ) LEFT JOIN mmag_feature_product fp_2 ON (p.id_product = fp_2.id_product) LEFT JOIN mmag_feature_product fp_3 ON (p.id_product = fp_3.id_product) WHERE ((fp.id_feature=21)) AND ((sp_1.reduction>0)) AND ((fp_2.id_feature_value IN (1192, 1247, 1239, 1235, 1229, 1220, 1215, 1212, 1206, 1194, 1173, 1155, 774))) AND ((fp_3.id_feature_value IN (811, 820, 1047, 833))) GROUP BY fp.id_feature_value	3.698 ms	209916	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:778 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:855 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:154 (getFeaturesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:357 (runQuery) /override/controllers/front/listing/CategoryController.php:22 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
138	SELECT SQL_NO_CACHE fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, pl.name FROM mmag_product p LEFT JOIN mmag_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mmag_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN mmag_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN mmag_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN mmag_product_lang pl ON (p.id_product = pl.id_product AND pl.id_shop = 1 AND pl.id_lang = 1) INNER JOIN mmag_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN mmag_category_product cp ON (p.id_product = cp.id_product) INNER JOIN mmag_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN mmag_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN mmag_specific_price sp ON ( sp.id_product = p.id_product AND sp.id_shop IN (0, 1) AND sp.id_currency IN (0, 1) AND sp.id_country IN (0, 36) AND sp.id_group IN (0, 1) AND sp.from_quantity = 1 AND sp.reduction > 0 AND sp.id_customer = 0 AND sp.id_cart = 0 AND (sp.from = '0000-00-00 00:00:00' OR '2025-04-25 20:01:15' >= sp.from) AND (sp.to = '0000-00-00 00:00:00' OR '2025-04-25 20:01:15' <= 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))) AND ((fp_2.id_feature_value IN (811, 820, 1047, 833))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=9 AND c.nright<=24 GROUP BY p.id_product) p INNER JOIN mmag_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN mmag_specific_price sp_1 ON ( sp_1.id_product = p.id_product AND sp_1.id_shop IN (0, 1) AND sp_1.id_currency IN (0, 1) AND sp_1.id_country IN (0, 36) AND sp_1.id_group IN (0, 1) AND sp_1.from_quantity = 1 AND sp_1.reduction > 0 AND sp_1.id_customer = 0 AND sp_1.id_cart = 0 AND (sp_1.from = '0000-00-00 00:00:00' OR '2025-04-25 20:01:15' >= sp_1.from) AND (sp_1.to = '0000-00-00 00:00:00' OR '2025-04-25 20:01:15' <= sp_1.to) ) LEFT JOIN mmag_feature_product fp_2 ON (p.id_product = fp_2.id_product) LEFT JOIN mmag_feature_product fp_3 ON (p.id_product = fp_3.id_product) WHERE ((fp.id_feature=14)) AND ((sp_1.reduction>0)) AND ((fp_2.id_feature_value IN (1192, 1247, 1239, 1235, 1229, 1220, 1215, 1212, 1206, 1194, 1173, 1155, 774))) AND ((fp_3.id_feature_value IN (811, 820, 1047, 833))) GROUP BY fp.id_feature_value	3.697 ms	209916	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:778 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:855 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:154 (getFeaturesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:357 (runQuery) /override/controllers/front/listing/CategoryController.php:22 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
94	SELECT SQL_NO_CACHE COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, pl.name FROM mmag_product p LEFT JOIN mmag_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mmag_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN mmag_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN mmag_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN mmag_product_lang pl ON (p.id_product = pl.id_product AND pl.id_shop = 1 AND pl.id_lang = 1) INNER JOIN mmag_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN mmag_category_product cp ON (p.id_product = cp.id_product) INNER JOIN mmag_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN mmag_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN mmag_specific_price sp ON ( sp.id_product = p.id_product AND sp.id_shop IN (0, 1) AND sp.id_currency IN (0, 1) AND sp.id_country IN (0, 36) AND sp.id_group IN (0, 1) AND sp.from_quantity = 1 AND sp.reduction > 0 AND sp.id_customer = 0 AND sp.id_cart = 0 AND (sp.from = '0000-00-00 00:00:00' OR '2025-04-25 20:01:15' >= sp.from) AND (sp.to = '0000-00-00 00:00:00' OR '2025-04-25 20:01:15' <= 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))) AND ((fp_2.id_feature_value IN (811, 820, 1047, 833))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=9 AND c.nright<=24 GROUP BY p.id_product) p LEFT JOIN mmag_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mmag_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN mmag_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN mmag_specific_price sp_1 ON ( sp_1.id_product = p.id_product AND sp_1.id_shop IN (0, 1) AND sp_1.id_currency IN (0, 1) AND sp_1.id_country IN (0, 36) AND sp_1.id_group IN (0, 1) AND sp_1.from_quantity = 1 AND sp_1.reduction > 0 AND sp_1.id_customer = 0 AND sp_1.id_cart = 0 AND (sp_1.from = '0000-00-00 00:00:00' OR '2025-04-25 20:01:15' >= sp_1.from) AND (sp_1.to = '0000-00-00 00:00:00' OR '2025-04-25 20:01:15' <= sp_1.to) ) LEFT JOIN mmag_feature_product fp_2 ON (p.id_product = fp_2.id_product) LEFT JOIN mmag_feature_product fp_3 ON (p.id_product = fp_3.id_product) WHERE ((sa.out_of_stock IN (1, 2)) OR (sa.quantity>0)) AND ((sp_1.reduction>0)) AND ((fp_2.id_feature_value IN (1192, 1247, 1239, 1235, 1229, 1220, 1215, 1212, 1206, 1194, 1173, 1155, 774))) AND ((fp_3.id_feature_value IN (811, 820, 1047, 833)))	3.658 ms	209916			/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)
154	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:01:15' >= sp.from) AND (sp.to = '0000-00-00 00:00:00' OR '2025-04-25 20:01:15' <= 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))) AND ((fp_2.id_feature_value IN (811, 820, 1047, 833))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=9 AND c.nright<=24 GROUP BY p.id_product) p INNER JOIN mmag_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN mmag_specific_price sp_1 ON ( sp_1.id_product = p.id_product AND sp_1.id_shop IN (0, 1) AND sp_1.id_currency IN (0, 1) AND sp_1.id_country IN (0, 36) AND sp_1.id_group IN (0, 1) AND sp_1.from_quantity = 1 AND sp_1.reduction > 0 AND sp_1.id_customer = 0 AND sp_1.id_cart = 0 AND (sp_1.from = '0000-00-00 00:00:00' OR '2025-04-25 20:01:15' >= sp_1.from) AND (sp_1.to = '0000-00-00 00:00:00' OR '2025-04-25 20:01:15' <= sp_1.to) ) LEFT JOIN mmag_feature_product fp_2 ON (p.id_product = fp_2.id_product) LEFT JOIN mmag_feature_product fp_3 ON (p.id_product = fp_3.id_product) WHERE ((fp.id_feature=23)) AND ((sp_1.reduction>0)) AND ((fp_2.id_feature_value IN (1192, 1247, 1239, 1235, 1229, 1220, 1215, 1212, 1206, 1194, 1173, 1155, 774))) AND ((fp_3.id_feature_value IN (811, 820, 1047, 833))) GROUP BY fp.id_feature_value	3.628 ms	209916	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:778 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:855 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:154 (getFeaturesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:357 (runQuery) /override/controllers/front/listing/CategoryController.php:22 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
95	SELECT SQL_NO_CACHE COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, pl.name FROM mmag_product p LEFT JOIN mmag_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mmag_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN mmag_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN mmag_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN mmag_product_lang pl ON (p.id_product = pl.id_product AND pl.id_shop = 1 AND pl.id_lang = 1) INNER JOIN mmag_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN mmag_category_product cp ON (p.id_product = cp.id_product) INNER JOIN mmag_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN mmag_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN mmag_specific_price sp ON ( sp.id_product = p.id_product AND sp.id_shop IN (0, 1) AND sp.id_currency IN (0, 1) AND sp.id_country IN (0, 36) AND sp.id_group IN (0, 1) AND sp.from_quantity = 1 AND sp.reduction > 0 AND sp.id_customer = 0 AND sp.id_cart = 0 AND (sp.from = '0000-00-00 00:00:00' OR '2025-04-25 20:01:15' >= sp.from) AND (sp.to = '0000-00-00 00:00:00' OR '2025-04-25 20:01:15' <= 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))) AND ((fp_2.id_feature_value IN (811, 820, 1047, 833))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=9 AND c.nright<=24 GROUP BY p.id_product) p LEFT JOIN mmag_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mmag_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN mmag_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN mmag_specific_price sp_1 ON ( sp_1.id_product = p.id_product AND sp_1.id_shop IN (0, 1) AND sp_1.id_currency IN (0, 1) AND sp_1.id_country IN (0, 36) AND sp_1.id_group IN (0, 1) AND sp_1.from_quantity = 1 AND sp_1.reduction > 0 AND sp_1.id_customer = 0 AND sp_1.id_cart = 0 AND (sp_1.from = '0000-00-00 00:00:00' OR '2025-04-25 20:01:15' >= sp_1.from) AND (sp_1.to = '0000-00-00 00:00:00' OR '2025-04-25 20:01:15' <= sp_1.to) ) LEFT JOIN mmag_feature_product fp_2 ON (p.id_product = fp_2.id_product) LEFT JOIN mmag_feature_product fp_3 ON (p.id_product = fp_3.id_product) WHERE ((sa.quantity>0)) AND ((sp_1.reduction>0)) AND ((fp_2.id_feature_value IN (1192, 1247, 1239, 1235, 1229, 1220, 1215, 1212, 1206, 1194, 1173, 1155, 774))) AND ((fp_3.id_feature_value IN (811, 820, 1047, 833)))	3.614 ms	209916			/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)
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:01:15' >= sp.from) AND (sp.to = '0000-00-00 00:00:00' OR '2025-04-25 20:01:15' <= 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))) AND ((fp_2.id_feature_value IN (811, 820, 1047, 833))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=9 AND c.nright<=24 GROUP BY p.id_product) p INNER JOIN mmag_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN mmag_specific_price sp_1 ON ( sp_1.id_product = p.id_product AND sp_1.id_shop IN (0, 1) AND sp_1.id_currency IN (0, 1) AND sp_1.id_country IN (0, 36) AND sp_1.id_group IN (0, 1) AND sp_1.from_quantity = 1 AND sp_1.reduction > 0 AND sp_1.id_customer = 0 AND sp_1.id_cart = 0 AND (sp_1.from = '0000-00-00 00:00:00' OR '2025-04-25 20:01:15' >= sp_1.from) AND (sp_1.to = '0000-00-00 00:00:00' OR '2025-04-25 20:01:15' <= sp_1.to) ) LEFT JOIN mmag_feature_product fp_2 ON (p.id_product = fp_2.id_product) LEFT JOIN mmag_feature_product fp_3 ON (p.id_product = fp_3.id_product) WHERE ((fp.id_feature=13)) AND ((sp_1.reduction>0)) AND ((fp_2.id_feature_value IN (1192, 1247, 1239, 1235, 1229, 1220, 1215, 1212, 1206, 1194, 1173, 1155, 774))) AND ((fp_3.id_feature_value IN (811, 820, 1047, 833))) GROUP BY fp.id_feature_value	3.604 ms	209916	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:01:15' >= sp.from) AND (sp.to = '0000-00-00 00:00:00' OR '2025-04-25 20:01:15' <= 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))) AND ((fp_2.id_feature_value IN (811, 820, 1047, 833))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=9 AND c.nright<=24 GROUP BY p.id_product) p INNER JOIN mmag_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN mmag_specific_price sp_1 ON ( sp_1.id_product = p.id_product AND sp_1.id_shop IN (0, 1) AND sp_1.id_currency IN (0, 1) AND sp_1.id_country IN (0, 36) AND sp_1.id_group IN (0, 1) AND sp_1.from_quantity = 1 AND sp_1.reduction > 0 AND sp_1.id_customer = 0 AND sp_1.id_cart = 0 AND (sp_1.from = '0000-00-00 00:00:00' OR '2025-04-25 20:01:15' >= sp_1.from) AND (sp_1.to = '0000-00-00 00:00:00' OR '2025-04-25 20:01:15' <= sp_1.to) ) LEFT JOIN mmag_feature_product fp_2 ON (p.id_product = fp_2.id_product) LEFT JOIN mmag_feature_product fp_3 ON (p.id_product = fp_3.id_product) WHERE ((fp.id_feature=18)) AND ((sp_1.reduction>0)) AND ((fp_2.id_feature_value IN (1192, 1247, 1239, 1235, 1229, 1220, 1215, 1212, 1206, 1194, 1173, 1155, 774))) AND ((fp_3.id_feature_value IN (811, 820, 1047, 833))) GROUP BY fp.id_feature_value	3.585 ms	209916	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)
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:01:15' >= sp.from) AND (sp.to = '0000-00-00 00:00:00' OR '2025-04-25 20:01:15' <= 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))) AND ((fp_2.id_feature_value IN (811, 820, 1047, 833))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=9 AND c.nright<=24 GROUP BY p.id_product) p INNER JOIN mmag_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN mmag_specific_price sp_1 ON ( sp_1.id_product = p.id_product AND sp_1.id_shop IN (0, 1) AND sp_1.id_currency IN (0, 1) AND sp_1.id_country IN (0, 36) AND sp_1.id_group IN (0, 1) AND sp_1.from_quantity = 1 AND sp_1.reduction > 0 AND sp_1.id_customer = 0 AND sp_1.id_cart = 0 AND (sp_1.from = '0000-00-00 00:00:00' OR '2025-04-25 20:01:15' >= sp_1.from) AND (sp_1.to = '0000-00-00 00:00:00' OR '2025-04-25 20:01:15' <= sp_1.to) ) LEFT JOIN mmag_feature_product fp_2 ON (p.id_product = fp_2.id_product) LEFT JOIN mmag_feature_product fp_3 ON (p.id_product = fp_3.id_product) WHERE ((fp.id_feature=19)) AND ((sp_1.reduction>0)) AND ((fp_2.id_feature_value IN (1192, 1247, 1239, 1235, 1229, 1220, 1215, 1212, 1206, 1194, 1173, 1155, 774))) AND ((fp_3.id_feature_value IN (811, 820, 1047, 833))) GROUP BY fp.id_feature_value	3.553 ms	209916	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)
27	SELECT SQL_NO_CACHE 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` = 1	3.547 ms	129			/classes/module/Module.php:346 /modules/cookiesplus/cookiesplus.php:51 (__construct) :undefined (__construct) /src/Core/Foundation/IoC/Container.php:123 (newInstance) /src/Core/Foundation/IoC/Container.php:153 (makeInstanceFromClassName) /src/Core/Foundation/IoC/Container.php:166 (doMake) /src/Adapter/ServiceLocator.php:70 (make) /classes/module/Module.php:1263 (get) /tools/profiling/Module.php:35 (coreLoadModule) /classes/module/Module.php:1242 (coreLoadModule) /classes/Hook.php:972 (getInstanceByName) /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)
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:01:15' >= sp.from) AND (sp.to = '0000-00-00 00:00:00' OR '2025-04-25 20:01:15' <= 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))) AND ((fp_2.id_feature_value IN (811, 820, 1047, 833))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=9 AND c.nright<=24 GROUP BY p.id_product) p INNER JOIN mmag_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN mmag_specific_price sp_1 ON ( sp_1.id_product = p.id_product AND sp_1.id_shop IN (0, 1) AND sp_1.id_currency IN (0, 1) AND sp_1.id_country IN (0, 36) AND sp_1.id_group IN (0, 1) AND sp_1.from_quantity = 1 AND sp_1.reduction > 0 AND sp_1.id_customer = 0 AND sp_1.id_cart = 0 AND (sp_1.from = '0000-00-00 00:00:00' OR '2025-04-25 20:01:15' >= sp_1.from) AND (sp_1.to = '0000-00-00 00:00:00' OR '2025-04-25 20:01:15' <= sp_1.to) ) LEFT JOIN mmag_feature_product fp_2 ON (p.id_product = fp_2.id_product) LEFT JOIN mmag_feature_product fp_3 ON (p.id_product = fp_3.id_product) WHERE ((fp.id_feature=22)) AND ((sp_1.reduction>0)) AND ((fp_2.id_feature_value IN (1192, 1247, 1239, 1235, 1229, 1220, 1215, 1212, 1206, 1194, 1173, 1155, 774))) AND ((fp_3.id_feature_value IN (811, 820, 1047, 833))) GROUP BY fp.id_feature_value	3.541 ms	209916	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)
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:01:15' >= sp.from) AND (sp.to = '0000-00-00 00:00:00' OR '2025-04-25 20:01:15' <= 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))) AND ((fp_2.id_feature_value IN (811, 820, 1047, 833))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=9 AND c.nright<=24 GROUP BY p.id_product) p INNER JOIN mmag_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN mmag_specific_price sp_1 ON ( sp_1.id_product = p.id_product AND sp_1.id_shop IN (0, 1) AND sp_1.id_currency IN (0, 1) AND sp_1.id_country IN (0, 36) AND sp_1.id_group IN (0, 1) AND sp_1.from_quantity = 1 AND sp_1.reduction > 0 AND sp_1.id_customer = 0 AND sp_1.id_cart = 0 AND (sp_1.from = '0000-00-00 00:00:00' OR '2025-04-25 20:01:15' >= sp_1.from) AND (sp_1.to = '0000-00-00 00:00:00' OR '2025-04-25 20:01:15' <= 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))) AND ((fp_3.id_feature_value IN (811, 820, 1047, 833))) GROUP BY fp.id_feature_value	3.512 ms	209916	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)
111	SELECT SQL_NO_CACHE p.condition, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, pl.name FROM mmag_product p LEFT JOIN mmag_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mmag_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN mmag_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN mmag_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN mmag_product_lang pl ON (p.id_product = pl.id_product AND pl.id_shop = 1 AND pl.id_lang = 1) INNER JOIN mmag_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN mmag_category_product cp ON (p.id_product = cp.id_product) INNER JOIN mmag_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN mmag_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN mmag_specific_price sp ON ( sp.id_product = p.id_product AND sp.id_shop IN (0, 1) AND sp.id_currency IN (0, 1) AND sp.id_country IN (0, 36) AND sp.id_group IN (0, 1) AND sp.from_quantity = 1 AND sp.reduction > 0 AND sp.id_customer = 0 AND sp.id_cart = 0 AND (sp.from = '0000-00-00 00:00:00' OR '2025-04-25 20:01:15' >= sp.from) AND (sp.to = '0000-00-00 00:00:00' OR '2025-04-25 20:01:15' <= 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))) AND ((fp_2.id_feature_value IN (811, 820, 1047, 833))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=9 AND c.nright<=24 GROUP BY p.id_product) p LEFT JOIN mmag_specific_price sp ON ( sp.id_product = p.id_product AND sp.id_shop IN (0, 1) AND sp.id_currency IN (0, 1) AND sp.id_country IN (0, 36) AND sp.id_group IN (0, 1) AND sp.from_quantity = 1 AND sp.reduction > 0 AND sp.id_customer = 0 AND sp.id_cart = 0 AND (sp.from = '0000-00-00 00:00:00' OR '2025-04-25 20:01:15' >= sp.from) AND (sp.to = '0000-00-00 00:00:00' OR '2025-04-25 20:01:15' <= 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))) AND ((fp_2.id_feature_value IN (811, 820, 1047, 833))) GROUP BY p.condition	3.509 ms	209916	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)
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:01:15' >= sp.from) AND (sp.to = '0000-00-00 00:00:00' OR '2025-04-25 20:01:15' <= 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))) AND ((fp_2.id_feature_value IN (811, 820, 1047, 833))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=9 AND c.nright<=24 GROUP BY p.id_product) p INNER JOIN mmag_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN mmag_specific_price sp_1 ON ( sp_1.id_product = p.id_product AND sp_1.id_shop IN (0, 1) AND sp_1.id_currency IN (0, 1) AND sp_1.id_country IN (0, 36) AND sp_1.id_group IN (0, 1) AND sp_1.from_quantity = 1 AND sp_1.reduction > 0 AND sp_1.id_customer = 0 AND sp_1.id_cart = 0 AND (sp_1.from = '0000-00-00 00:00:00' OR '2025-04-25 20:01:15' >= sp_1.from) AND (sp_1.to = '0000-00-00 00:00:00' OR '2025-04-25 20:01:15' <= 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))) AND ((fp_3.id_feature_value IN (811, 820, 1047, 833))) GROUP BY fp.id_feature_value	3.503 ms	209916	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:778 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:855 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:154 (getFeaturesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:357 (runQuery) /override/controllers/front/listing/CategoryController.php:22 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
143	SELECT SQL_NO_CACHE fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, pl.name FROM mmag_product p LEFT JOIN mmag_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mmag_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN mmag_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN mmag_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN mmag_product_lang pl ON (p.id_product = pl.id_product AND pl.id_shop = 1 AND pl.id_lang = 1) INNER JOIN mmag_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN mmag_category_product cp ON (p.id_product = cp.id_product) INNER JOIN mmag_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN mmag_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN mmag_specific_price sp ON ( sp.id_product = p.id_product AND sp.id_shop IN (0, 1) AND sp.id_currency IN (0, 1) AND sp.id_country IN (0, 36) AND sp.id_group IN (0, 1) AND sp.from_quantity = 1 AND sp.reduction > 0 AND sp.id_customer = 0 AND sp.id_cart = 0 AND (sp.from = '0000-00-00 00:00:00' OR '2025-04-25 20:01:15' >= sp.from) AND (sp.to = '0000-00-00 00:00:00' OR '2025-04-25 20:01:15' <= 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))) AND ((fp_2.id_feature_value IN (811, 820, 1047, 833))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=9 AND c.nright<=24 GROUP BY p.id_product) p INNER JOIN mmag_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN mmag_specific_price sp_1 ON ( sp_1.id_product = p.id_product AND sp_1.id_shop IN (0, 1) AND sp_1.id_currency IN (0, 1) AND sp_1.id_country IN (0, 36) AND sp_1.id_group IN (0, 1) AND sp_1.from_quantity = 1 AND sp_1.reduction > 0 AND sp_1.id_customer = 0 AND sp_1.id_cart = 0 AND (sp_1.from = '0000-00-00 00:00:00' OR '2025-04-25 20:01:15' >= sp_1.from) AND (sp_1.to = '0000-00-00 00:00:00' OR '2025-04-25 20:01:15' <= sp_1.to) ) LEFT JOIN mmag_feature_product fp_2 ON (p.id_product = fp_2.id_product) LEFT JOIN mmag_feature_product fp_3 ON (p.id_product = fp_3.id_product) WHERE ((fp.id_feature=17)) AND ((sp_1.reduction>0)) AND ((fp_2.id_feature_value IN (1192, 1247, 1239, 1235, 1229, 1220, 1215, 1212, 1206, 1194, 1173, 1155, 774))) AND ((fp_3.id_feature_value IN (811, 820, 1047, 833))) GROUP BY fp.id_feature_value	3.503 ms	209916	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:01:15' >= sp.from) AND (sp.to = '0000-00-00 00:00:00' OR '2025-04-25 20:01:15' <= 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))) AND ((fp_2.id_feature_value IN (811, 820, 1047, 833))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=9 AND c.nright<=24 GROUP BY p.id_product) p INNER JOIN mmag_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN mmag_specific_price sp_1 ON ( sp_1.id_product = p.id_product AND sp_1.id_shop IN (0, 1) AND sp_1.id_currency IN (0, 1) AND sp_1.id_country IN (0, 36) AND sp_1.id_group IN (0, 1) AND sp_1.from_quantity = 1 AND sp_1.reduction > 0 AND sp_1.id_customer = 0 AND sp_1.id_cart = 0 AND (sp_1.from = '0000-00-00 00:00:00' OR '2025-04-25 20:01:15' >= sp_1.from) AND (sp_1.to = '0000-00-00 00:00:00' OR '2025-04-25 20:01:15' <= sp_1.to) ) LEFT JOIN mmag_feature_product fp_2 ON (p.id_product = fp_2.id_product) LEFT JOIN mmag_feature_product fp_3 ON (p.id_product = fp_3.id_product) WHERE ((fp.id_feature=15)) AND ((sp_1.reduction>0)) AND ((fp_2.id_feature_value IN (1192, 1247, 1239, 1235, 1229, 1220, 1215, 1212, 1206, 1194, 1173, 1155, 774))) AND ((fp_3.id_feature_value IN (811, 820, 1047, 833))) GROUP BY fp.id_feature_value	3.459 ms	209916	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)
110	SELECT SQL_NO_CACHE p.id_manufacturer, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, pl.name FROM mmag_product p LEFT JOIN mmag_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mmag_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN mmag_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN mmag_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN mmag_product_lang pl ON (p.id_product = pl.id_product AND pl.id_shop = 1 AND pl.id_lang = 1) INNER JOIN mmag_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN mmag_category_product cp ON (p.id_product = cp.id_product) INNER JOIN mmag_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN mmag_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN mmag_specific_price sp ON ( sp.id_product = p.id_product AND sp.id_shop IN (0, 1) AND sp.id_currency IN (0, 1) AND sp.id_country IN (0, 36) AND sp.id_group IN (0, 1) AND sp.from_quantity = 1 AND sp.reduction > 0 AND sp.id_customer = 0 AND sp.id_cart = 0 AND (sp.from = '0000-00-00 00:00:00' OR '2025-04-25 20:01:15' >= sp.from) AND (sp.to = '0000-00-00 00:00:00' OR '2025-04-25 20:01:15' <= 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))) AND ((fp_2.id_feature_value IN (811, 820, 1047, 833))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=9 AND c.nright<=24 GROUP BY p.id_product) p LEFT JOIN mmag_specific_price sp ON ( sp.id_product = p.id_product AND sp.id_shop IN (0, 1) AND sp.id_currency IN (0, 1) AND sp.id_country IN (0, 36) AND sp.id_group IN (0, 1) AND sp.from_quantity = 1 AND sp.reduction > 0 AND sp.id_customer = 0 AND sp.id_cart = 0 AND (sp.from = '0000-00-00 00:00:00' OR '2025-04-25 20:01:15' >= sp.from) AND (sp.to = '0000-00-00 00:00:00' OR '2025-04-25 20:01:15' <= 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))) AND ((fp_2.id_feature_value IN (811, 820, 1047, 833))) GROUP BY p.id_manufacturer	3.452 ms	209916	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)
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:01:15' >= sp.from) AND (sp.to = '0000-00-00 00:00:00' OR '2025-04-25 20:01:15' <= 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))) AND ((fp_2.id_feature_value IN (811, 820, 1047, 833))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=9 AND c.nright<=24 GROUP BY p.id_product) p INNER JOIN mmag_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN mmag_specific_price sp_1 ON ( sp_1.id_product = p.id_product AND sp_1.id_shop IN (0, 1) AND sp_1.id_currency IN (0, 1) AND sp_1.id_country IN (0, 36) AND sp_1.id_group IN (0, 1) AND sp_1.from_quantity = 1 AND sp_1.reduction > 0 AND sp_1.id_customer = 0 AND sp_1.id_cart = 0 AND (sp_1.from = '0000-00-00 00:00:00' OR '2025-04-25 20:01:15' >= sp_1.from) AND (sp_1.to = '0000-00-00 00:00:00' OR '2025-04-25 20:01:15' <= sp_1.to) ) LEFT JOIN mmag_feature_product fp_2 ON (p.id_product = fp_2.id_product) LEFT JOIN mmag_feature_product fp_3 ON (p.id_product = fp_3.id_product) WHERE ((fp.id_feature=11)) AND ((sp_1.reduction>0)) AND ((fp_2.id_feature_value IN (1192, 1247, 1239, 1235, 1229, 1220, 1215, 1212, 1206, 1194, 1173, 1155, 774))) AND ((fp_3.id_feature_value IN (811, 820, 1047, 833))) GROUP BY fp.id_feature_value	3.422 ms	209916	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:01:15' >= sp.from) AND (sp.to = '0000-00-00 00:00:00' OR '2025-04-25 20:01:15' <= 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))) AND ((fp_2.id_feature_value IN (811, 820, 1047, 833))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=9 AND c.nright<=24 GROUP BY p.id_product) p INNER JOIN mmag_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN mmag_specific_price sp_1 ON ( sp_1.id_product = p.id_product AND sp_1.id_shop IN (0, 1) AND sp_1.id_currency IN (0, 1) AND sp_1.id_country IN (0, 36) AND sp_1.id_group IN (0, 1) AND sp_1.from_quantity = 1 AND sp_1.reduction > 0 AND sp_1.id_customer = 0 AND sp_1.id_cart = 0 AND (sp_1.from = '0000-00-00 00:00:00' OR '2025-04-25 20:01:15' >= sp_1.from) AND (sp_1.to = '0000-00-00 00:00:00' OR '2025-04-25 20:01:15' <= sp_1.to) ) LEFT JOIN mmag_feature_product fp_2 ON (p.id_product = fp_2.id_product) LEFT JOIN mmag_feature_product fp_3 ON (p.id_product = fp_3.id_product) WHERE ((fp.id_feature=12)) AND ((sp_1.reduction>0)) AND ((fp_2.id_feature_value IN (1192, 1247, 1239, 1235, 1229, 1220, 1215, 1212, 1206, 1194, 1173, 1155, 774))) AND ((fp_3.id_feature_value IN (811, 820, 1047, 833))) GROUP BY fp.id_feature_value	3.406 ms	209916	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:01:15' >= sp.from) AND (sp.to = '0000-00-00 00:00:00' OR '2025-04-25 20:01:15' <= 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))) AND ((fp_2.id_feature_value IN (811, 820, 1047, 833))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=9 AND c.nright<=24 GROUP BY p.id_product) p INNER JOIN mmag_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN mmag_specific_price sp_1 ON ( sp_1.id_product = p.id_product AND sp_1.id_shop IN (0, 1) AND sp_1.id_currency IN (0, 1) AND sp_1.id_country IN (0, 36) AND sp_1.id_group IN (0, 1) AND sp_1.from_quantity = 1 AND sp_1.reduction > 0 AND sp_1.id_customer = 0 AND sp_1.id_cart = 0 AND (sp_1.from = '0000-00-00 00:00:00' OR '2025-04-25 20:01:15' >= sp_1.from) AND (sp_1.to = '0000-00-00 00:00:00' OR '2025-04-25 20:01:15' <= sp_1.to) ) LEFT JOIN mmag_feature_product fp_2 ON (p.id_product = fp_2.id_product) LEFT JOIN mmag_feature_product fp_3 ON (p.id_product = fp_3.id_product) WHERE ((fp.id_feature=9)) AND ((sp_1.reduction>0)) AND ((fp_2.id_feature_value IN (1192, 1247, 1239, 1235, 1229, 1220, 1215, 1212, 1206, 1194, 1173, 1155, 774))) AND ((fp_3.id_feature_value IN (811, 820, 1047, 833))) GROUP BY fp.id_feature_value	3.352 ms	209916	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)
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:01:15' >= sp.from) AND (sp.to = '0000-00-00 00:00:00' OR '2025-04-25 20:01:15' <= 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))) AND ((fp_2.id_feature_value IN (811, 820, 1047, 833))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=9 AND c.nright<=24 GROUP BY p.id_product) p LEFT JOIN mmag_specific_price sp ON ( sp.id_product = p.id_product AND sp.id_shop IN (0, 1) AND sp.id_currency IN (0, 1) AND sp.id_country IN (0, 36) AND sp.id_group IN (0, 1) AND sp.from_quantity = 1 AND sp.reduction > 0 AND sp.id_customer = 0 AND sp.id_cart = 0 AND (sp.from = '0000-00-00 00:00:00' OR '2025-04-25 20:01:15' >= sp.from) AND (sp.to = '0000-00-00 00:00:00' OR '2025-04-25 20:01:15' <= 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))) AND ((fp_2.id_feature_value IN (811, 820, 1047, 833))) AND p.date_add>'2025-04-06 00:00:00'	3.348 ms	209916			/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)
23	SELECT SQL_NO_CACHE 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` = 1	3.322 ms	129			/classes/module/Module.php:346 /modules/stblog/stblog.php:89 (__construct) :undefined (__construct) /src/Core/Foundation/IoC/Container.php:123 (newInstance) /src/Core/Foundation/IoC/Container.php:153 (makeInstanceFromClassName) /src/Core/Foundation/IoC/Container.php:166 (doMake) /src/Adapter/ServiceLocator.php:70 (make) /classes/module/Module.php:1263 (get) /tools/profiling/Module.php:35 (coreLoadModule) /classes/module/Module.php:1242 (coreLoadModule) /classes/Hook.php:972 (getInstanceByName) /classes/Dispatcher.php:606 (exec) /override/classes/Dispatcher.php:90 (loadRoutes) /classes/Dispatcher.php:243 (loadRoutes) /override/classes/Dispatcher.php:42 (__construct) /classes/Dispatcher.php:201 (__construct) /index.php:28 (getInstance)
90	SELECT SQL_NO_CACHE p.id_product FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, pl.name FROM mmag_product p LEFT JOIN mmag_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mmag_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN mmag_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN mmag_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN mmag_product_lang pl ON (p.id_product = pl.id_product AND pl.id_shop = 1 AND pl.id_lang = 1) INNER JOIN mmag_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN mmag_category_product cp ON (p.id_product = cp.id_product) INNER JOIN mmag_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN mmag_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN mmag_specific_price sp ON ( sp.id_product = p.id_product AND sp.id_shop IN (0, 1) AND sp.id_currency IN (0, 1) AND sp.id_country IN (0, 36) AND sp.id_group IN (0, 1) AND sp.from_quantity = 1 AND sp.reduction > 0 AND sp.id_customer = 0 AND sp.id_cart = 0 AND (sp.from = '0000-00-00 00:00:00' OR '2025-04-25 20:01:15' >= sp.from) AND (sp.to = '0000-00-00 00:00:00' OR '2025-04-25 20:01:15' <= 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))) AND ((fp_2.id_feature_value IN (811, 820, 1047, 833))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=9 AND c.nright<=24 GROUP BY p.id_product) p INNER JOIN mmag_product_lang pl ON (p.id_product = pl.id_product AND pl.id_shop = 1 AND pl.id_lang = 1) GROUP BY p.id_product ORDER BY p.name ASC, p.id_product DESC	3.221 ms	1428	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)
98	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_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN mmag_feature_product fp_1 ON (p.id_product = fp_1.id_product) WHERE ((fp.id_feature_value IN (1192, 1247, 1239, 1235, 1229, 1220, 1215, 1212, 1206, 1194, 1173, 1155, 774))) AND ((fp_1.id_feature_value IN (811, 820, 1047, 833))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=9 AND c.nright<=24 GROUP BY p.id_product) p LEFT JOIN mmag_specific_price sp ON ( sp.id_product = p.id_product AND sp.id_shop IN (0, 1) AND sp.id_currency IN (0, 1) AND sp.id_country IN (0, 36) AND sp.id_group IN (0, 1) AND sp.from_quantity = 1 AND sp.reduction > 0 AND sp.id_customer = 0 AND sp.id_cart = 0 AND (sp.from = '0000-00-00 00:00:00' OR '2025-04-25 20:01:15' >= sp.from) AND (sp.to = '0000-00-00 00:00:00' OR '2025-04-25 20:01:15' <= 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))) AND ((fp_2.id_feature_value IN (811, 820, 1047, 833)))	3.206 ms	6136956			/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:605 (count) /modules/ps_facetedsearch/src/Filters/Block.php:143 (getHighlightsBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:357 (runQuery) /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)
264	SELECT SQL_NO_CACHE `id_tax_rules_group` FROM `mmag_product_shop` WHERE `id_product` = 85 AND id_shop=1 LIMIT 1	3.076 ms	1			/classes/Product.php:6876 /classes/Product.php:3925 (getIdTaxRulesGroupByIdProduct) /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)
155	REPLACE INTO mmag_layered_filter_block (hash, data) VALUES ("9b82521a1c302a5b61bb924b2ced9705", "a:1:{s:7:\"filters\";a:24:{i:0;a:12:{s:9:\"type_lite\";s:5:\"price\";s:4:\"type\";s:5:\"price\";s:6:\"id_key\";i:0;s:4:\"name\";s:4:\"Pret\";s:3:\"max\";d:899;s:3:\"min\";d:35;s:4:\"unit\";s:3:\"lei\";s:14:\"specifications\";a:11:{s:6:\"symbol\";a:11:{i:0;s:1:\",\";i:1;s:1:\".\";i:2;s:1:\";\";i:3;s:1:\"%\";i:4;s:1:\"-\";i:5;s:1:\"+\";i:6;s:1:\"E\";i:7;s:2:\"×\";i:8;s:3:\"‰\";i:9;s:3:\"∞\";i:10;s:3:\"NaN\";}s:12:\"currencyCode\";s:3:\"RON\";s:14:\"currencySymbol\";s:3:\"lei\";s:13:\"numberSymbols\";a:11:{i:0;s:1:\",\";i:1;s:1:\".\";i:2;s:1:\";\";i:3;s:1:\"%\";i:4;s:1:\"-\";i:5;s:1:\"+\";i:6;s:1:\"E\";i:7;s:2:\"×\";i:8;s:3:\"‰\";i:9;s:3:\"∞\";i:10;s:3:\"NaN\";}s:15:\"positivePattern\";s:12:\"#,##0.00 ¤\";s:15:\"negativePattern\";s:13:\"-#,##0.00 ¤\";s:17:\"maxFractionDigits\";i:2;s:17:\"minFractionDigits\";i:2;s:12:\"groupingUsed\";b:1;s:16:\"primaryGroupSize\";i:3;s:18:\"secondaryGroupSize\";i:3;}s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";i:3;s:3:\"nbr\";i:10;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:10;}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:4;}s:8:\"discount\";a:3:{s:4:\"name\";s:5:\"Redus\";s:3:\"nbr\";i:10;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:4:{i:17;a:2:{s:4:\"name\";s:6:\"Veioze\";s:3:\"nbr\";s:1:\"5\";}i:18;a:2:{s:4:\"name\";s:9:\"Lampadare\";s:3:\"nbr\";s:1:\"1\";}i:19;a:2:{s:4:\"name\";s:6:\"Lustre\";s:3:\"nbr\";s:1:\"3\";}i:21;a:2:{s:4:\"name\";s:8:\"Exterior\";s:3:\"nbr\";s:1:\"1\";}}s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";s:1:\"0\";}i:4;a:9:{s:9:\"type_lite\";s:10:\"id_feature\";s:4:\"type\";s:10:\"id_feature\";s:6:\"id_key\";s:1:\"1\";s:6:\"values\";a:4:{i:695;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:19:\"Metal auriu satinat\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:711;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:12:\"Policarbonat\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:702;a:4:{s:3:\"nbr\";s:1:\"2\";s:4:\"name\";s:7:\"Silicon\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:700;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:25:\"Sticla vitraliata Tiffany\";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:4:{i:790;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:14:\"Clasic, modern\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:785;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:22:\"Clasic, retro, vintage\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:783;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:6:\"Modern\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:786;a:4:{s:3:\"nbr\";s:1:\"3\";s:4:\"name\";s:19:\"Modern, contemporan\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}}s:4:\"name\";s:4:\"Stil\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";s:1:\"0\";}i:6;a:7:{s:9:\"type_lite\";s:12:\"manufacturer\";s:4:\"type\";s:12:\"manufacturer\";s:6:\"id_key\";i:0;s:4:\"name\";s:5:\"Marca\";s:6:\"values\";a:1:{i:15;a:2:{s:4:\"name\";s:9:\"Faneurope\";s:3:\"nbr\";s:1:\"1\";}}s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";s:1:\"0\";}i:7;a:7:{s:9:\"type_lite\";s:9:\"condition\";s:4:\"type\";s:9:\"condition\";s:6:\"id_key\";i:0;s:4:\"name\";s:5:\"Stare\";s:6:\"values\";a:3:{s:3:\"new\";a:2:{s:4:\"name\";s:3:\"Nou\";s:3:\"nbr\";s:2:\"10\";}s:4:\"used\";a:2:{s:4:\"name\";s:7:\"Folosit\";s:3:\"nbr\";i:0;}s:11:\"refurbished\";a:2:{s:4:\"name\";s:13:\"Reconditionat\";s:3:\"nbr\";i:0;}}s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";s:1:\"0\";}i:8;a:12:{s:9:\"type_lite\";s:6:\"weight\";s:4:\"type\";s:6:\"weight\";s:6:\"id_key\";i:0;s:4:\"name\";s:8:\"Greutate\";s:3:\"max\";d:5;s:3:\"min\";d:0;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:10;}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:2:\"10\";s:4:\"name\";s:1:\"1\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:7:\"checked\";b:1;}i:775;a:4:{s:3:\"nbr\";s:1:\"2\";s:4:\"name\";s:1:\"2\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:776;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:1:\"3\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}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;}}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:23:{i:812;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:14:\"16 cm inaltime\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:862;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:16:\"17.5 cm inaltime\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:815;a:4:{s:3:\"nbr\";s:1:\"4\";s:4:\"name\";s:14:\"20 cm inaltime\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:948;a:4:{s:3:\"nbr\";s:1:\"3\";s:4:\"name\";s:14:\"23 cm inaltime\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:816;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:14:\"25 cm inaltime\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:951;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:16:\"26.5 cm inaltime\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:819;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:15:\"29 cm inaltime \";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:820;a:5:{s:3:\"nbr\";s:1:\"3\";s:4:\"name\";s:14:\"30 cm inaltime\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:7:\"checked\";b:1;}i:1047;a:5:{s:3:\"nbr\";s:1:\"2\";s:4:\"name\";s:14:\"32 cm inaltime\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:7:\"checked\";b:1;}i:822;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:14:\"35 cm inaltime\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:823;a:4:{s:3:\"nbr\";s:1:\"2\";s:4:\"name\";s:14:\"37 cm inaltime\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:825;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:14:\"38 cm inaltime\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:826;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:14:\"42 cm inaltime\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:827;a:4:{s:3:\"nbr\";s:1:\"3\";s:4:\"name\";s:14:\"44 cm inaltime\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:828;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:14:\"46 cm inaltime\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:950;a:4:{s:3:\"nbr\";s:1:\"2\";s:4:\"name\";s:14:\"50 cm inaltime\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:830;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:14:\"59 cm inaltime\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:832;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:15:\"84 cm inaltime \";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:833;a:5:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:14:\"92 cm inaltime\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:7:\"checked\";b:1;}i:808;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:15:\"100 cm inaltime\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:809;a:4:{s:3:\"nbr\";s:1:\"7\";s:4:\"name\";s:15:\"120 cm inaltime\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:811;a:5:{s:3:\"nbr\";s:1:\"4\";s:4:\"name\";s:15:\"150 cm inaltime\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:7:\"checked\";b:1;}i:813;a:4:{s:3:\"nbr\";s:1:\"2\";s:4:\"name\";s:15:\"165 cm inaltime\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}}s:4:\"name\";s:8:\"Inaltime\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";s:1:\"0\";}i:11;a:9:{s:9:\"type_lite\";s:10:\"id_feature\";s:4:\"type\";s:10:\"id_feature\";s:6:\"id_key\";s:1:\"7\";s:6:\"values\";a:2:{i:743;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:8:\"Exterior\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:741;a:4:{s:3:\"nbr\";s:1:\"3\";s:4:\"name\";s:8:\"Interior\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}}s:4:\"name\";s:20:\"Domeniu de utilizare\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";s:1:\"0\";}i:12;a:9:{s:9:\"type_lite\";s:10:\"id_feature\";s:4:\"type\";s:10:\"id_feature\";s:6:\"id_key\";s:1:\"9\";s:6:\"values\";a:3:{i:791;a:4:{s:3:\"nbr\";s:1:\"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:\"5\";s:4:\"name\";s:3:\"E27\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:795;a:4:{s:3:\"nbr\";s:1:\"2\";s:4:\"name\";s:3:\"LED\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}}s:4:\"name\";s:7:\"Tip bec\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";s:1:\"0\";}i:13;a:9:{s:9:\"type_lite\";s:10:\"id_feature\";s:4:\"type\";s:10:\"id_feature\";s:6:\"id_key\";s:2:\"10\";s:6:\"values\";a:6:{i:725;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:3:\"Alb\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:732;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:15:\"Alb si albastru\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:736;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:15:\"Alb si argintiu\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:729;a:4:{s:3:\"nbr\";s:1:\"1\";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:\"1\";s:4:\"name\";s:14:\"Negru si auriu\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}}s:4:\"name\";s:7:\"Culoare\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";s:1:\"0\";}i:14;a:9:{s:9:\"type_lite\";s:10:\"id_feature\";s:4:\"type\";s:10:\"id_feature\";s:6:\"id_key\";s:2:\"11\";s:6:\"values\";a:4:{i:722;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:8:\"Aluminiu\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:716;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:19:\"Metal culoare bronz\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:720;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:11:\"Metal Negru\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:718;a:4:{s:3:\"nbr\";s:1:\"2\";s:4:\"name\";s:16:\"Plastic, Silicon\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}}s:4:\"name\";s:17:\"Compozitie suport\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";s:1:\"0\";}i:15;a:9:{s:9:\"type_lite\";s:10:\"id_feature\";s:4:\"type\";s:10:\"id_feature\";s:6:\"id_key\";s:2:\"12\";s:6:\"values\";a:2:{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;}i:754;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:12:\"Metal cromat\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}}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:4:{i:744;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:3:\"10W\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:745;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:3:\"12W\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:749;a:4:{s:3:\"nbr\";s:1:\"3\";s:4:\"name\";s:3:\"40W\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:751;a:4:{s:3:\"nbr\";s:1:\"3\";s:4:\"name\";s:3:\"60W\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}}s:4:\"name\";s:10:\"Putere bec\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";s:1:\"0\";}i:17;a:9:{s:9:\"type_lite\";s:10:\"id_feature\";s:4:\"type\";s:10:\"id_feature\";s:6:\"id_key\";s:2:\"14\";s:6:\"values\";a:2:{i:693;a:4:{s:3:\"nbr\";s:1:\"4\";s:4:\"name\";s:4:\"IP20\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:694;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:4:\"IP44\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}}s:4:\"name\";s:15:\"Clasa protectie\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";s:1:\"0\";}i:18;a:9:{s:9:\"type_lite\";s:10:\"id_feature\";s:4:\"type\";s:10:\"id_feature\";s:6:\"id_key\";s:2:\"15\";s:6:\"values\";a:1:{i:797;a:4:{s:3:\"nbr\";s:1:\"3\";s:4:\"name\";s:10:\"Bec inclus\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}}s:4:\"name\";s:20:\"Alte Caracteristici \";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:\"18\";s:6:\"values\";a:1:{i:1140;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:5:\"3000K\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}}s:4:\"name\";s:22:\"Temperatura de 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:20;a:9:{s:9:\"type_lite\";s:10:\"id_feature\";s:4:\"type\";s:10:\"id_feature\";s:6:\"id_key\";s:2:\"19\";s:6:\"values\";a:1:{i:1134;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:5:\"800lm\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}}s:4:\"name\";s:21:\"Intensitate luminoasa\";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:21;a:9:{s:9:\"type_lite\";s:10:\"id_feature\";s:4:\"type\";s:10:\"id_feature\";s:6:\"id_key\";s:2:\"20\";s:6:\"values\";a:4:{i:850;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:12:\"10 cm latime\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:867;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:12:\"13 cm latime\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:863;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:12:\"17 cm latime\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:884;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:12:\"25 cm latime\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}}s:4:\"name\";s:6:\"Latime\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";s:1:\"0\";}i:22;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:2:{i:912;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:13:\"16 cm lungime\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:864;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:13:\"17 cm lungime\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}}s:4:\"name\";s:7:\"Lungime\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";s:1:\"0\";}i:23;a:9:{s:9:\"type_lite\";s:10:\"id_feature\";s:4:\"type\";s:10:\"id_feature\";s:6:\"id_key\";s:2:\"22\";s:6:\"values\";a:4:{i:835;a:4:{s:3:\"nbr\";s:1:\"2\";s:4:\"name\";s:14:\"13 cm diametru\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:837;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:14:\"18 cm diametru\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:844;a:4:{s:3:\"nbr\";s:1:\"2\";s:4:\"name\";s:14:\"40 cm diametru\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:846;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:15:\"45 cm diametru \";s:8:\"url_name\";N;s:10:\"meta_title\";N;}}s:4:\"name\";s:8:\"Diametru\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";s:1:\"0\";}}}")	2.898 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)
7	SELECT SQL_NO_CACHE * FROM `mmag_shop_group` a WHERE (a.`id_shop_group` = 1) LIMIT 1	2.866 ms	1			/src/Adapter/EntityMapper.php:71 /classes/ObjectModel.php:283 (load) /tools/profiling/ObjectModel.php:32 (__construct) /classes/shop/Shop.php:561 (__construct) /config/config.inc.php:171 (getGroup) /index.php:27 (require)
122	SELECT SQL_NO_CACHE fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, 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:01:15' >= sp.from) AND (sp.to = '0000-00-00 00:00:00' OR '2025-04-25 20:01:15' <= sp.to) ) LEFT JOIN mmag_feature_product fp_1 ON (p.id_product = fp_1.id_product) WHERE ((sp.reduction>0)) AND ((fp_1.id_feature_value IN (811, 820, 1047, 833))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=9 AND c.nright<=24 GROUP BY p.id_product) p INNER JOIN mmag_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN mmag_specific_price sp_1 ON ( sp_1.id_product = p.id_product AND sp_1.id_shop IN (0, 1) AND sp_1.id_currency IN (0, 1) AND sp_1.id_country IN (0, 36) AND sp_1.id_group IN (0, 1) AND sp_1.from_quantity = 1 AND sp_1.reduction > 0 AND sp_1.id_customer = 0 AND sp_1.id_cart = 0 AND (sp_1.from = '0000-00-00 00:00:00' OR '2025-04-25 20:01:15' >= sp_1.from) AND (sp_1.to = '0000-00-00 00:00:00' OR '2025-04-25 20:01:15' <= sp_1.to) ) LEFT JOIN mmag_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((fp.id_feature=4)) AND ((sp_1.reduction>0)) AND ((fp_2.id_feature_value IN (811, 820, 1047, 833))) GROUP BY fp.id_feature_value	2.808 ms	4284	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 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:01:15' >= sp.from) AND (sp.to = '0000-00-00 00:00:00' OR '2025-04-25 20:01:15' <= 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))) AND ((fp_2.id_feature_value IN (811, 820, 1047, 833))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=9 AND c.nright<=24 GROUP BY p.id_product) p LEFT JOIN mmag_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mmag_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) INNER JOIN mmag_attribute a ON (a.id_attribute = pac.id_attribute) LEFT JOIN mmag_specific_price sp_1 ON ( sp_1.id_product = p.id_product AND sp_1.id_shop IN (0, 1) AND sp_1.id_currency IN (0, 1) AND sp_1.id_country IN (0, 36) AND sp_1.id_group IN (0, 1) AND sp_1.from_quantity = 1 AND sp_1.reduction > 0 AND sp_1.id_customer = 0 AND sp_1.id_cart = 0 AND (sp_1.from = '0000-00-00 00:00:00' OR '2025-04-25 20:01:15' >= sp_1.from) AND (sp_1.to = '0000-00-00 00:00:00' OR '2025-04-25 20:01:15' <= sp_1.to) ) LEFT JOIN mmag_feature_product fp_2 ON (p.id_product = fp_2.id_product) LEFT JOIN mmag_feature_product fp_3 ON (p.id_product = fp_3.id_product) WHERE ((a.id_attribute_group=4)) AND ((sp_1.reduction>0)) AND ((fp_2.id_feature_value IN (1192, 1247, 1239, 1235, 1229, 1220, 1215, 1212, 1206, 1194, 1173, 1155, 774))) AND ((fp_3.id_feature_value IN (811, 820, 1047, 833))) GROUP BY pac.id_attribute	2.792 ms	209916	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)
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_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN mmag_feature_product fp_1 ON (p.id_product = fp_1.id_product) WHERE ((fp.id_feature_value IN (1192, 1247, 1239, 1235, 1229, 1220, 1215, 1212, 1206, 1194, 1173, 1155, 774))) AND ((fp_1.id_feature_value IN (811, 820, 1047, 833))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=9 AND c.nright<=24 GROUP BY p.id_product) p LEFT JOIN mmag_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 ((p.on_sale=1)) AND ((fp_1.id_feature_value IN (1192, 1247, 1239, 1235, 1229, 1220, 1215, 1212, 1206, 1194, 1173, 1155, 774))) AND ((fp_2.id_feature_value IN (811, 820, 1047, 833)))	2.780 ms	2045652			/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:565 (count) /modules/ps_facetedsearch/src/Filters/Block.php:143 (getHighlightsBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:357 (runQuery) /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 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:01:15' >= sp.from) AND (sp.to = '0000-00-00 00:00:00' OR '2025-04-25 20:01:15' <= 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))) AND ((fp_2.id_feature_value IN (811, 820, 1047, 833))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=9 AND c.nright<=24 GROUP BY p.id_product) p INNER JOIN mmag_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN mmag_specific_price sp_1 ON ( sp_1.id_product = p.id_product AND sp_1.id_shop IN (0, 1) AND sp_1.id_currency IN (0, 1) AND sp_1.id_country IN (0, 36) AND sp_1.id_group IN (0, 1) AND sp_1.from_quantity = 1 AND sp_1.reduction > 0 AND sp_1.id_customer = 0 AND sp_1.id_cart = 0 AND (sp_1.from = '0000-00-00 00:00:00' OR '2025-04-25 20:01:15' >= sp_1.from) AND (sp_1.to = '0000-00-00 00:00:00' OR '2025-04-25 20:01:15' <= 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=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))) AND ((fp_3.id_feature_value IN (811, 820, 1047, 833))) GROUP BY fp.id_feature_value	2.775 ms	209916	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)
8	SELECT SQL_NO_CACHE * FROM `mmag_lang` a LEFT JOIN `mmag_lang_shop` `c` ON a.`id_lang` = c.`id_lang` AND c.`id_shop` = 1 WHERE (a.`id_lang` = 1) LIMIT 1	2.732 ms	1			/src/Adapter/EntityMapper.php:71 /classes/ObjectModel.php:283 (load) /tools/profiling/ObjectModel.php:32 (__construct) /config/config.inc.php:211 (__construct) /index.php:27 (require)
121	SELECT SQL_NO_CACHE fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, pl.name FROM mmag_product p LEFT JOIN mmag_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mmag_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN mmag_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN mmag_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN mmag_product_lang pl ON (p.id_product = pl.id_product AND pl.id_shop = 1 AND pl.id_lang = 1) INNER JOIN mmag_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN mmag_category_product cp ON (p.id_product = cp.id_product) INNER JOIN mmag_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN mmag_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN mmag_specific_price sp ON ( sp.id_product = p.id_product AND sp.id_shop IN (0, 1) AND sp.id_currency IN (0, 1) AND sp.id_country IN (0, 36) AND sp.id_group IN (0, 1) AND sp.from_quantity = 1 AND sp.reduction > 0 AND sp.id_customer = 0 AND sp.id_cart = 0 AND (sp.from = '0000-00-00 00:00:00' OR '2025-04-25 20:01:15' >= sp.from) AND (sp.to = '0000-00-00 00:00:00' OR '2025-04-25 20:01:15' <= 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))) AND ((fp_2.id_feature_value IN (811, 820, 1047, 833))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=9 AND c.nright<=24 GROUP BY p.id_product) p INNER JOIN mmag_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN mmag_specific_price sp_1 ON ( sp_1.id_product = p.id_product AND sp_1.id_shop IN (0, 1) AND sp_1.id_currency IN (0, 1) AND sp_1.id_country IN (0, 36) AND sp_1.id_group IN (0, 1) AND sp_1.from_quantity = 1 AND sp_1.reduction > 0 AND sp_1.id_customer = 0 AND sp_1.id_cart = 0 AND (sp_1.from = '0000-00-00 00:00:00' OR '2025-04-25 20:01:15' >= sp_1.from) AND (sp_1.to = '0000-00-00 00:00:00' OR '2025-04-25 20:01:15' <= sp_1.to) ) LEFT JOIN mmag_feature_product fp_2 ON (p.id_product = fp_2.id_product) LEFT JOIN mmag_feature_product fp_3 ON (p.id_product = fp_3.id_product) WHERE ((fp.id_feature=3)) AND ((sp_1.reduction>0)) AND ((fp_2.id_feature_value IN (1192, 1247, 1239, 1235, 1229, 1220, 1215, 1212, 1206, 1194, 1173, 1155, 774))) AND ((fp_3.id_feature_value IN (811, 820, 1047, 833))) GROUP BY fp.id_feature_value	2.669 ms	419832	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)

#	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