Acasa

Aplică cu sticlă decorativa argintie | Iluminat de perete elegant

-60%

Limited special offer

(0)

APLICĂ STICLĂ DEKO

499,00 lei
199,60 lei (inclusiv TVA)

Aplică de perete cu sticlă decorativă și efect metalizat., I-VANITY/AP SIL

Adauga in cos

-60%

Limited special offer

(0)

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

Veioză de masă din cristal - Eleganță și rafinament pentru decorul tău

-60%

Limited special offer

(0)

LAMPĂ DE MASĂ DIN CRISTAL H60

399,00 lei
159,60 lei (inclusiv TVA)

Lampa de masă din cristale decorative K9 şi finisaje cromate, I-LOUVRE-LG1

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

-40%

Limited special offer

(0)

PENDUL AURIU DUBLU

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

Pendul Modern Dublu, 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

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	442.976 ms
Querying Time	334 ms
Queries	432
Memory Peak Usage	18.0 Mb
Included Files	931 files - 12.95 Mb
PrestaShop Cache	- Mb
Global vars	0.10 Mb
- global $_MODULES	40k
- global $_MODULE	40k
- global $_SERVER	8k
- global $config	5k
- global $context	3k
- global $exportPhpConfigFile	3k
- global $_COOKIE	2k
- global $__composer_autoload_files	1k

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

Acasa

APLICĂ STICLĂ DEKO

Lampa "GLOBUL LUMINII"

LAMPĂ DE MASĂ DIN CRISTAL H60

PENDUL AURIU

PENDUL AURIU DUBLU

VEIOZĂ DE MASĂ

Meniu

Cautare

Stopwatch SQL - 432 queries

Doubles

Tables stress

ObjectModel instances

Included Files

	Time	Cumulated Time	Memory Usage	Memory Peak Usage
config	34.223 ms	34.223 ms	4.79 Mb	4.9 Mb
__construct	0.015 ms	34.238 ms	- Mb	4.9 Mb
init	31.562 ms	65.800 ms	0.95 Mb	5.8 Mb
checkAccess	0.002 ms	65.802 ms	- Mb	5.8 Mb
setMedia	6.531 ms	72.333 ms	0.19 Mb	6.0 Mb
postProcess	0.002 ms	72.335 ms	- Mb	6.0 Mb
initHeader	0.002 ms	72.337 ms	- Mb	6.0 Mb
initContent	316.088 ms	388.425 ms	8.38 Mb	14.5 Mb
initFooter	0.003 ms	388.428 ms	- Mb	14.5 Mb
display	54.548 ms	442.976 ms	3.32 Mb	18.0 Mb

Hook	Time	Memory Usage
ActionStAssemble	34.820 ms	0.90 Mb
=> stthemeeditor	0.509 ms	0.01 Mb
=> sthoverimage	0.349 ms	0.01 Mb
=> stcompare	0.008 ms	- Mb
=> ststickers	5.352 ms	0.15 Mb
=> stwishlist	0.308 ms	0.01 Mb
=> stproductcomments	0.434 ms	0.01 Mb
=> stthemeeditor	0.469 ms	0.01 Mb
=> sthoverimage	0.327 ms	0.01 Mb
=> stcompare	0.005 ms	- Mb
=> ststickers	3.787 ms	0.11 Mb
=> stwishlist	0.320 ms	0.01 Mb
=> stproductcomments	0.326 ms	0.01 Mb
=> stthemeeditor	0.445 ms	0.01 Mb
=> sthoverimage	0.307 ms	0.01 Mb
=> stcompare	0.004 ms	- Mb
=> ststickers	3.277 ms	0.09 Mb
=> stwishlist	0.282 ms	0.01 Mb
=> stproductcomments	0.309 ms	0.01 Mb
=> stthemeeditor	0.506 ms	0.01 Mb
=> sthoverimage	0.381 ms	0.01 Mb
=> stcompare	0.003 ms	- Mb
=> ststickers	5.677 ms	0.15 Mb
=> stwishlist	0.336 ms	0.01 Mb
=> stproductcomments	0.357 ms	0.01 Mb
=> stthemeeditor	0.411 ms	0.01 Mb
=> sthoverimage	0.331 ms	0.01 Mb
=> stcompare	0.003 ms	- Mb
=> ststickers	4.711 ms	0.11 Mb
=> stwishlist	0.278 ms	0.01 Mb
=> stproductcomments	0.363 ms	0.01 Mb
=> stthemeeditor	0.426 ms	0.01 Mb
=> sthoverimage	0.354 ms	0.01 Mb
=> stcompare	0.004 ms	- Mb
=> ststickers	3.270 ms	0.09 Mb
=> stwishlist	0.278 ms	0.01 Mb
=> stproductcomments	0.312 ms	0.01 Mb
DisplayHeader	32.176 ms	0.63 Mb
=> stthemeeditor	6.070 ms	0.17 Mb
=> ps_googleanalytics	2.544 ms	0.01 Mb
=> stcustomersignin	0.971 ms	0.02 Mb
=> stmultilink	0.272 ms	0.01 Mb
=> stsearchbar	0.321 ms	0.01 Mb
=> stshoppingcart	0.424 ms	0.01 Mb
=> stmegamenu	0.402 ms	0.01 Mb
=> stswiper	0.333 ms	0.01 Mb
=> stowlcarousel	0.264 ms	0.01 Mb
=> steasycontent	0.369 ms	0.03 Mb
=> stfeaturedslider	0.345 ms	0.01 Mb
=> stfeaturedcategories	0.256 ms	0.01 Mb
=> stblogeditor	0.258 ms	0.01 Mb
=> stblogfeaturedarticles	0.292 ms	0.01 Mb
=> stbanner	0.244 ms	0.01 Mb
=> stbrandsslider	0.250 ms	0.01 Mb
=> stspecialslider	0.264 ms	0.01 Mb
=> stblogrecentarticles	3.735 ms	0.01 Mb
=> stnewsletter	0.251 ms	0.01 Mb
=> stblogarchives	0.059 ms	- Mb
=> stblogcomments	0.046 ms	- Mb
=> stblogrelatedarticles	0.235 ms	0.01 Mb
=> stcountdown	0.243 ms	0.01 Mb
=> sthoverimage	0.055 ms	- Mb
=> stinstagram	3.910 ms	0.04 Mb
=> stcompare	0.336 ms	0.01 Mb
=> stnotification	0.230 ms	0.01 Mb
=> stpagebanner	0.221 ms	0.01 Mb
=> stproductcategoriesslider	0.358 ms	0.01 Mb
=> strelatedproducts	0.270 ms	0.01 Mb
=> stsidebar	0.220 ms	0.01 Mb
=> ststickers	3.993 ms	0.03 Mb
=> stvideo	0.266 ms	0.01 Mb
=> stwishlist	0.377 ms	0.02 Mb
=> stproductcomments	0.381 ms	0.01 Mb
=> stproductsasattrs	1.923 ms	0.01 Mb
=> sturls	0.198 ms	- Mb
=> cookiesplus	0.889 ms	0.02 Mb
=> ets_recaptcha_free	0.018 ms	- Mb
=> ets_whatsapp	0.083 ms	- Mb
displayLeftColumn	10.767 ms	0.54 Mb
=> ps_categorytree (widget)	10.767 ms	0.54 Mb
DisplayBeforeBodyClosingTag	7.519 ms	0.48 Mb
=> ps_googleanalytics	1.647 ms	0.07 Mb
=> statsdata	0.738 ms	0.06 Mb
=> stwishlist	0.209 ms	- Mb
=> cookiesplus	4.925 ms	0.34 Mb
DisplaySideBar	3.566 ms	0.16 Mb
=> stsidebar	0.747 ms	0.02 Mb
=> stnewsletter	0.874 ms	0.02 Mb
=> stmegamenu	0.355 ms	0.03 Mb
=> stwishlist	0.927 ms	0.06 Mb
=> stsearchbar	0.277 ms	0.01 Mb
=> stshoppingcart	0.386 ms	0.03 Mb
displayHeaderCenter	3.560 ms	0.03 Mb
=> stsearchbar (widget)	3.560 ms	0.03 Mb
displayTop	2.708 ms	0.14 Mb
=> stcustomersignin (widget)	2.151 ms	0.13 Mb
=> stshoppingcart (widget)	0.557 ms	0.01 Mb
displayBanner	2.502 ms	0.16 Mb
=> stnotification (widget)	1.552 ms	0.09 Mb
=> steasycontent (widget)	0.950 ms	0.06 Mb
ActionFrontControllerSetMedia	2.462 ms	0.06 Mb
=> ps_emailalerts	0.036 ms	- Mb
=> cookiesplus	2.426 ms	0.06 Mb
ActionOutputHTMLBefore	1.752 ms	0.01 Mb
=> cookiesplus	1.508 ms	0.01 Mb
=> stswiper	0.059 ms	- Mb
=> stbanner	0.105 ms	- Mb
=> stinstagram	0.080 ms	- Mb
DisplayMobileBarLeft	1.478 ms	0.14 Mb
=> stsidebar	1.478 ms	0.14 Mb
ActionDispatcherBefore	1.224 ms	0.01 Mb
=> sturls	1.215 ms	0.01 Mb
=> ets_delete_order	0.009 ms	- Mb
DisplayFooter	1.194 ms	0.08 Mb
=> ets_whatsapp	0.323 ms	0.02 Mb
=> stnewsletter	0.288 ms	0.02 Mb
=> stmultilink	0.285 ms	0.02 Mb
=> steasycontent	0.298 ms	0.02 Mb
DisplayMainMenu	1.075 ms	0.03 Mb
=> stmegamenu	1.075 ms	0.03 Mb
displayFullWidthTop	0.937 ms	0.05 Mb
=> stswiper (widget)	0.918 ms	0.05 Mb
=> steasycontent (widget)	0.019 ms	- Mb
ActionProductSearchAfter	0.936 ms	0.02 Mb
=> stthemeeditor	0.007 ms	- Mb
=> stcountdown	0.013 ms	- Mb
=> stcompare	0.047 ms	- Mb
=> ststickers	0.831 ms	0.01 Mb
=> stwishlist	0.038 ms	- Mb
DisplayLeftColumn	0.929 ms	0.22 Mb
=> ps_facetedsearch	0.527 ms	0.20 Mb
=> stmegamenu	0.402 ms	0.01 Mb
DisplayCategoryHeader	0.784 ms	0.03 Mb
=> stswiper	0.244 ms	0.01 Mb
=> stowlcarousel	0.270 ms	0.01 Mb
=> stbanner	0.270 ms	0.01 Mb
DisplayMobileBar	0.781 ms	0.03 Mb
=> stsidebar	0.781 ms	0.03 Mb
displayBeforeBodyClosingTag	0.659 ms	0.02 Mb
=> stnotification (widget)	0.659 ms	0.02 Mb
DisplayBreadcrumb	0.413 ms	0.01 Mb
=> stpagebanner	0.413 ms	0.01 Mb
DisplayRightBar	0.348 ms	0.04 Mb
=> stsidebar	0.348 ms	0.04 Mb
DisplayNav1	0.279 ms	0.02 Mb
=> stmultilink	0.279 ms	0.02 Mb
ProductSearchProvider	0.250 ms	0.06 Mb
=> ps_facetedsearch	0.250 ms	0.06 Mb
DisplayNav2	0.236 ms	0.01 Mb
=> stmultilink	0.236 ms	0.01 Mb
DisplayFooterAfter	0.229 ms	0.01 Mb
=> stmultilink	0.229 ms	0.01 Mb
DisplayMobileBarBottom	0.186 ms	- Mb
=> stsidebar	0.186 ms	- Mb
DisplayMobileBarCenter	0.163 ms	- Mb
=> stsidebar	0.163 ms	- Mb
ModuleRoutes	0.119 ms	0.01 Mb
=> stblog	0.004 ms	- Mb
=> stblogarchives	0.002 ms	- Mb
=> stblogsearch	0.002 ms	- Mb
=> sturls	0.069 ms	0.01 Mb
=> cookiesplus	0.042 ms	- Mb
ActionDispatcher	0.021 ms	- Mb
=> sturls	0.021 ms	- Mb
displayFullWidthTop2	0.017 ms	- Mb
=> steasycontent (widget)	0.017 ms	- Mb
OverrideLayoutTemplate	0.010 ms	- Mb
=> stblog	0.004 ms	- Mb
=> stblog	0.004 ms	- Mb
=> stblog	0.002 ms	- Mb
DisplayAfterBodyOpeningTag	0.010 ms	- Mb
=> cookiesplus	0.010 ms	- Mb
DisplayFullWidthBottom	0.005 ms	- Mb
=> stblogfeaturedarticles	0.005 ms	- Mb
DisplayFullWidthTop	0.005 ms	- Mb
=> stfeaturedslider	0.003 ms	- Mb
=> stproductcategoriesslider	0.002 ms	- Mb
FilterProductSearch	0.004 ms	- Mb
=> stsearchbar	0.004 ms	- Mb
36 hook(s)	114.123 ms	3.91 Mb

Module	Time	Memory Usage
sturls	5.626 ms	0.06 Mb
__construct	4.113 ms	0.04 Mb
hookModuleRoutes	0.071 ms	0.01 Mb
hookActionDispatcherBefore	1.218 ms	0.01 Mb
hookActionDispatcher	0.023 ms	- Mb
hookDisplayHeader	0.201 ms	- Mb
stblog	1.924 ms	0.10 Mb
__construct	1.897 ms	0.09 Mb
hookModuleRoutes	0.009 ms	- Mb
hookOverrideLayoutTemplate	0.007 ms	- Mb
hookOverrideLayoutTemplate	0.006 ms	- Mb
hookOverrideLayoutTemplate	0.005 ms	- Mb
stblogarchives	0.850 ms	0.03 Mb
__construct	0.785 ms	0.03 Mb
hookModuleRoutes	0.004 ms	- Mb
hookDisplayHeader	0.061 ms	- Mb
stblogsearch	0.846 ms	0.03 Mb
__construct	0.842 ms	0.03 Mb
hookModuleRoutes	0.004 ms	- Mb
cookiesplus	11.207 ms	0.52 Mb
__construct	1.390 ms	0.09 Mb
hookModuleRoutes	0.044 ms	- Mb
hookActionFrontControllerSetMedia	2.429 ms	0.06 Mb
hookDisplayHeader	0.892 ms	0.02 Mb
hookDisplayAfterBodyOpeningTag	0.013 ms	- Mb
hookDisplayBeforeBodyClosingTag	4.928 ms	0.34 Mb
hookActionOutputHTMLBefore	1.511 ms	0.01 Mb
ets_delete_order	1.390 ms	0.14 Mb
__construct	1.379 ms	0.14 Mb
hookActionDispatcherBefore	0.011 ms	- Mb
ps_emailalerts	3.776 ms	0.12 Mb
__construct	3.736 ms	0.12 Mb
hookActionFrontControllerSetMedia	0.040 ms	- Mb
stthemeeditor	9.270 ms	0.35 Mb
__construct	0.386 ms	0.09 Mb
hookDisplayHeader	6.074 ms	0.17 Mb
hookActionStAssemble	0.531 ms	0.02 Mb
hookActionStAssemble	0.472 ms	0.01 Mb
hookActionStAssemble	0.448 ms	0.01 Mb
hookActionStAssemble	0.509 ms	0.01 Mb
hookActionStAssemble	0.414 ms	0.01 Mb
hookActionStAssemble	0.429 ms	0.01 Mb
hookActionProductSearchAfter	0.008 ms	- Mb
ps_googleanalytics	4.320 ms	0.11 Mb
__construct	0.123 ms	0.03 Mb
hookDisplayHeader	2.547 ms	0.01 Mb
hookDisplayBeforeBodyClosingTag	1.650 ms	0.07 Mb
stcustomersignin	3.261 ms	0.18 Mb
__construct	0.132 ms	0.02 Mb
hookDisplayHeader	0.974 ms	0.02 Mb
displayTop	2.155 ms	0.13 Mb
stmultilink	1.524 ms	0.13 Mb
__construct	0.208 ms	0.05 Mb
hookDisplayHeader	0.275 ms	0.01 Mb
hookDisplayNav1	0.282 ms	0.02 Mb
hookDisplayNav2	0.239 ms	0.01 Mb
hookDisplayFooter	0.288 ms	0.02 Mb
hookDisplayFooterAfter	0.232 ms	0.01 Mb
stsearchbar	4.305 ms	0.09 Mb
__construct	0.126 ms	0.03 Mb
hookDisplayHeader	0.324 ms	0.01 Mb
displayHeaderCenter	3.567 ms	0.03 Mb
hookFilterProductSearch	0.008 ms	- Mb
hookDisplaySideBar	0.280 ms	0.01 Mb
stshoppingcart	1.510 ms	0.13 Mb
__construct	0.134 ms	0.08 Mb
hookDisplayHeader	0.427 ms	0.01 Mb
displayTop	0.560 ms	0.01 Mb
hookDisplaySideBar	0.389 ms	0.03 Mb
stmegamenu	5.422 ms	0.14 Mb
__construct	3.175 ms	0.06 Mb
hookDisplayHeader	0.405 ms	0.01 Mb
hookDisplayMainMenu	1.078 ms	0.03 Mb
hookDisplayLeftColumn	0.406 ms	0.01 Mb
hookDisplaySideBar	0.358 ms	0.03 Mb
stswiper	1.886 ms	0.23 Mb
__construct	0.320 ms	0.16 Mb
hookDisplayHeader	0.336 ms	0.01 Mb
displayFullWidthTop	0.922 ms	0.05 Mb
hookDisplayCategoryHeader	0.247 ms	0.01 Mb
hookActionOutputHTMLBefore	0.061 ms	- Mb
stowlcarousel	0.756 ms	0.08 Mb
__construct	0.215 ms	0.06 Mb
hookDisplayHeader	0.268 ms	0.01 Mb
hookDisplayCategoryHeader	0.273 ms	0.01 Mb
steasycontent	4.026 ms	0.29 Mb
__construct	2.360 ms	0.17 Mb
hookDisplayHeader	0.372 ms	0.03 Mb
displayBanner	0.955 ms	0.06 Mb
displayFullWidthTop	0.020 ms	- Mb
displayFullWidthTop2	0.019 ms	- Mb
hookDisplayFooter	0.300 ms	0.02 Mb
stfeaturedslider	0.615 ms	0.08 Mb
__construct	0.246 ms	0.07 Mb
hookDisplayHeader	0.364 ms	0.01 Mb
hookDisplayFullWidthTop	0.005 ms	- Mb
stfeaturedcategories	1.467 ms	0.05 Mb
__construct	1.208 ms	0.04 Mb
hookDisplayHeader	0.259 ms	0.01 Mb
stblogeditor	0.386 ms	0.11 Mb
__construct	0.125 ms	0.09 Mb
hookDisplayHeader	0.261 ms	0.01 Mb
stblogfeaturedarticles	0.421 ms	0.06 Mb
__construct	0.118 ms	0.05 Mb
hookDisplayHeader	0.295 ms	0.01 Mb
hookDisplayFullWidthBottom	0.008 ms	- Mb
stbanner	0.904 ms	0.09 Mb
__construct	0.276 ms	0.06 Mb
hookDisplayHeader	0.247 ms	0.01 Mb
hookDisplayCategoryHeader	0.273 ms	0.01 Mb
hookActionOutputHTMLBefore	0.108 ms	- Mb
stbrandsslider	0.436 ms	0.04 Mb
__construct	0.166 ms	0.03 Mb
hookDisplayHeader	0.270 ms	0.01 Mb
stspecialslider	0.451 ms	0.04 Mb
__construct	0.184 ms	0.03 Mb
hookDisplayHeader	0.267 ms	0.01 Mb
stblogrecentarticles	3.825 ms	0.04 Mb
__construct	0.087 ms	0.03 Mb
hookDisplayHeader	3.738 ms	0.01 Mb
stnewsletter	1.692 ms	0.16 Mb
__construct	0.270 ms	0.11 Mb
hookDisplayHeader	0.254 ms	0.01 Mb
hookDisplayFooter	0.291 ms	0.02 Mb
hookDisplaySideBar	0.877 ms	0.02 Mb
stblogcomments	0.186 ms	0.04 Mb
__construct	0.138 ms	0.04 Mb
hookDisplayHeader	0.048 ms	- Mb
stblogrelatedarticles	0.402 ms	0.04 Mb
__construct	0.164 ms	0.03 Mb
hookDisplayHeader	0.238 ms	0.01 Mb
stcountdown	0.396 ms	0.04 Mb
__construct	0.136 ms	0.03 Mb
hookDisplayHeader	0.246 ms	0.02 Mb
hookActionProductSearchAfter	0.014 ms	- Mb
sthoverimage	2.255 ms	0.14 Mb
__construct	0.132 ms	0.09 Mb
hookDisplayHeader	0.057 ms	- Mb
hookActionStAssemble	0.352 ms	0.01 Mb
hookActionStAssemble	0.329 ms	0.01 Mb
hookActionStAssemble	0.310 ms	0.01 Mb
hookActionStAssemble	0.384 ms	0.01 Mb
hookActionStAssemble	0.334 ms	0.01 Mb
hookActionStAssemble	0.357 ms	0.01 Mb
stinstagram	4.319 ms	0.10 Mb
__construct	0.324 ms	0.07 Mb
hookDisplayHeader	3.913 ms	0.04 Mb
hookActionOutputHTMLBefore	0.082 ms	- Mb
stcompare	0.611 ms	0.05 Mb
__construct	0.190 ms	0.03 Mb
hookDisplayHeader	0.339 ms	0.01 Mb
hookActionStAssemble	0.009 ms	- Mb
hookActionStAssemble	0.007 ms	- Mb
hookActionStAssemble	0.004 ms	- Mb
hookActionStAssemble	0.004 ms	- Mb
hookActionStAssemble	0.004 ms	- Mb
hookActionStAssemble	0.006 ms	- Mb
hookActionProductSearchAfter	0.048 ms	- Mb
stnotification	2.647 ms	0.18 Mb
__construct	0.195 ms	0.05 Mb
hookDisplayHeader	0.233 ms	0.01 Mb
displayBanner	1.556 ms	0.09 Mb
displayBeforeBodyClosingTag	0.663 ms	0.02 Mb
stpagebanner	0.859 ms	0.13 Mb
__construct	0.219 ms	0.10 Mb
hookDisplayHeader	0.224 ms	0.01 Mb
hookDisplayBreadcrumb	0.416 ms	0.01 Mb
stproductcategoriesslider	2.917 ms	0.09 Mb
__construct	2.552 ms	0.07 Mb
hookDisplayHeader	0.362 ms	0.01 Mb
hookDisplayFullWidthTop	0.003 ms	- Mb
strelatedproducts	0.441 ms	0.04 Mb
__construct	0.168 ms	0.03 Mb
hookDisplayHeader	0.273 ms	0.01 Mb
stsidebar	4.221 ms	0.30 Mb
__construct	0.276 ms	0.05 Mb
hookDisplayHeader	0.223 ms	0.01 Mb
hookDisplayMobileBarLeft	1.481 ms	0.14 Mb
hookDisplayMobileBarCenter	0.166 ms	- Mb
hookDisplayMobileBar	0.784 ms	0.03 Mb
hookDisplayMobileBarBottom	0.189 ms	- Mb
hookDisplaySideBar	0.750 ms	0.02 Mb
hookDisplayRightBar	0.352 ms	0.04 Mb
ststickers	31.207 ms	0.85 Mb
__construct	0.284 ms	0.12 Mb
hookDisplayHeader	3.996 ms	0.03 Mb
hookActionStAssemble	5.356 ms	0.15 Mb
hookActionStAssemble	3.790 ms	0.11 Mb
hookActionStAssemble	3.280 ms	0.09 Mb
hookActionStAssemble	5.680 ms	0.15 Mb
hookActionStAssemble	4.714 ms	0.11 Mb
hookActionStAssemble	3.273 ms	0.09 Mb
hookActionProductSearchAfter	0.834 ms	0.02 Mb
stvideo	0.560 ms	0.06 Mb
__construct	0.291 ms	0.05 Mb
hookDisplayHeader	0.269 ms	0.01 Mb
stwishlist	3.636 ms	0.18 Mb
__construct	0.254 ms	0.05 Mb
hookDisplayHeader	0.380 ms	0.02 Mb
hookActionStAssemble	0.311 ms	0.01 Mb
hookActionStAssemble	0.323 ms	0.01 Mb
hookActionStAssemble	0.285 ms	0.01 Mb
hookActionStAssemble	0.339 ms	0.01 Mb
hookActionStAssemble	0.281 ms	0.01 Mb
hookActionStAssemble	0.281 ms	0.01 Mb
hookActionProductSearchAfter	0.039 ms	- Mb
hookDisplaySideBar	0.930 ms	0.06 Mb
hookDisplayBeforeBodyClosingTag	0.212 ms	- Mb
stproductcomments	2.793 ms	0.18 Mb
__construct	0.292 ms	0.13 Mb
hookDisplayHeader	0.384 ms	0.01 Mb
hookActionStAssemble	0.437 ms	0.01 Mb
hookActionStAssemble	0.329 ms	0.01 Mb
hookActionStAssemble	0.311 ms	0.01 Mb
hookActionStAssemble	0.360 ms	0.01 Mb
hookActionStAssemble	0.366 ms	0.01 Mb
hookActionStAssemble	0.314 ms	0.01 Mb
stproductsasattrs	2.115 ms	0.05 Mb
__construct	0.188 ms	0.04 Mb
hookDisplayHeader	1.927 ms	0.01 Mb
ets_recaptcha_free	0.214 ms	0.03 Mb
__construct	0.193 ms	0.03 Mb
hookDisplayHeader	0.021 ms	- Mb
ets_whatsapp	0.533 ms	0.04 Mb
__construct	0.122 ms	0.02 Mb
hookDisplayHeader	0.085 ms	- Mb
hookDisplayFooter	0.326 ms	0.02 Mb
ps_facetedsearch	1.078 ms	0.31 Mb
__construct	0.278 ms	0.04 Mb
hookProductSearchProvider	0.254 ms	0.07 Mb
hookDisplayLeftColumn	0.546 ms	0.20 Mb
ps_categorytree	10.921 ms	0.56 Mb
__construct	0.150 ms	0.02 Mb
displayLeftColumn	10.771 ms	0.55 Mb
statsdata	0.871 ms	0.08 Mb
__construct	0.130 ms	0.02 Mb
hookDisplayBeforeBodyClosingTag	0.741 ms	0.06 Mb
47 module(s)	145.278 ms	6.89 Mb

26 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
22 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) WHERE ((sp.reduction>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) WHERE ((fp.id_feature=XX)) AND ((sp_XX.reduction>XX)) AND ((fp_XX.id_feature_value IN (XX, XX, XX, XX))) GROUP BY fp.id_feature_value
18 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
15 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
15 queries	SELECT c.`nleft`, c.`nright` FROM `mmag_category` c WHERE c.`id_category` = XX LIMIT XX
15 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
13 queries	SELECT `id_module` FROM `mmag_module_shop` WHERE `id_module` = XX AND `id_shop` = XX LIMIT XX
12 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`
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 XX FROM `mmag_specific_price` WHERE id_product = XX LIMIT XX
6 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
6 queries	SELECT * FROM `mmag_category_lang` WHERE `id_category` = XX AND `id_shop` = XX
6 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
6 queries	SELECT name FROM mmag_category_lang WHERE id_shop = XX AND id_lang = XX AND id_category = XX LIMIT XX
6 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
6 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
6 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
6 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)
6 queries	SELECT `id_tax_rules_group` FROM `mmag_product_shop` WHERE `id_product` = XX AND id_shop=XX LIMIT XX
6 queries	SELECT `reduction` FROM `mmag_product_group_reduction_cache` WHERE `id_product` = XX AND `id_group` = XX LIMIT XX
6 queries	SELECT COUNT(*) FROM `mmag_pack` WHERE id_product_pack = XX LIMIT XX
6 queries	SELECT product_type FROM `mmag_product` WHERE id_product = XX LIMIT XX
6 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
6 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
6 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
6 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
6 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
6 queries	SELECT * FROM `mmag_product_lang` WHERE `id_product` = XX AND `id_shop` = XX
6 queries	SELECT `id_category` FROM `mmag_category_product` WHERE `id_product` = XX
6 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
6 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
6 queries	SELECT `id_product_attribute` FROM `mmag_product_attribute` WHERE `id_product` = XX
5 queries	SELECT DISTINCT a.`id_attribute`, a.`color`, al.`name`, agl.`id_attribute_group`, IF(lialv.`url_name` IS NULL OR lialv.`url_name` = "", NULL, lialv.`url_name`) AS url_name, IF(lialv.`meta_title` IS NULL OR lialv.`meta_title` = "", NULL, lialv.`meta_title`) AS meta_title FROM `mmag_attribute_group` ag INNER JOIN `mmag_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = XX) INNER JOIN `mmag_attribute` a ON a.`id_attribute_group` = ag.`id_attribute_group` INNER JOIN `mmag_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = XX) INNER JOIN mmag_attribute_group_shop attribute_group_shop ON (attribute_group_shop.id_attribute_group = ag.id_attribute_group AND attribute_group_shop.id_shop = XX) INNER JOIN mmag_attribute_shop attribute_shop ON (attribute_shop.id_attribute = a.id_attribute AND attribute_shop.id_shop = XX) LEFT JOIN `mmag_layered_indexable_attribute_lang_value` lialv ON (a.`id_attribute` = lialv.`id_attribute` AND lialv.`id_lang` = XX) WHERE ag.id_attribute_group = XX ORDER BY agl.`name` ASC, a.`position` ASC
5 queries	SELECT pac.id_attribute, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, pl.name FROM mmag_product p LEFT JOIN mmag_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mmag_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN mmag_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, XX) = sa.id_product_attribute AND sa.id_shop = XX AND sa.id_shop_group = XX ) LEFT JOIN mmag_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN mmag_product_lang pl ON (p.id_product = pl.id_product AND pl.id_shop = XX AND pl.id_lang = XX) INNER JOIN mmag_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = XX AND ps.active = TRUE) INNER JOIN mmag_category_product cp ON (p.id_product = cp.id_product) INNER JOIN mmag_category c ON (cp.id_category = c.id_category AND c.active=XX) LEFT JOIN mmag_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN mmag_specific_price sp ON ( sp.id_product = p.id_product AND sp.id_shop IN (XX, XX) AND sp.id_currency IN (XX, XX) AND sp.id_country IN (XX, XX) AND sp.id_group IN (XX, XX) AND sp.from_quantity = XX AND sp.reduction > XX AND sp.id_customer = XX AND sp.id_cart = XX AND (sp.from = 'XX-XX-XX XX:XX:XX' OR 'XX-XX-XX XX:XX:XX' >= sp.from) AND (sp.to = 'XX-XX-XX XX:XX:XX' OR 'XX-XX-XX XX:XX:XX' <= sp.to) ) LEFT JOIN mmag_feature_product fp_XX ON (p.id_product = fp_XX.id_product) WHERE ((sp.reduction>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) WHERE ((a.id_attribute_group=XX)) AND ((sp_XX.reduction>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 id_st_sticker FROM `mmag_st_sticker_map` WHERE active = XX AND (location = XX OR (location = XX AND (id_category = XX OR id_category IN(XX,XX,XX,XX,XX,XX,XX))) OR (location = XX AND (id_products LIKE "%,XX,%")))
4 queries	SELECT * FROM mmag_cookiesplus_cookie cc LEFT JOIN mmag_cookiesplus_cookie_lang ccl on cc.`id_cookiesplus_cookie` = ccl.`id_cookiesplus_cookie` WHERE `id_cookiesplus_finality` = XX AND ccl.`id_lang` = XX AND cc.`active` = XX AND cc.`id_shop` = XX ORDER BY cc.`name`;
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 id_st_sticker FROM `mmag_st_sticker_map` WHERE active = XX AND (location = XX OR (location = XX AND (id_category = XX OR id_category IN(XX,XX,XX,XX,XX,XX,XX,XX,XX,XX))) OR (location = XX AND (id_products LIKE "%,XX,%")))
2 queries	SELECT XX FROM `mmag_cart_rule` WHERE ((date_to >= "XX-XX-XX XX:XX:XX" AND date_to <= "XX-XX-XX XX:XX:XX") OR (date_from >= "XX-XX-XX XX:XX:XX" AND date_from <= "XX-XX-XX XX:XX:XX") OR (date_from < "XX-XX-XX XX:XX:XX" AND date_to > "XX-XX-XX XX:XX:XX")) AND `id_customer` IN (XX,XX) LIMIT XX
2 queries	SELECT snl., snll. FROM `mmag_st_notification` snl INNER JOIN mmag_st_notification_shop st_notification_shop ON (st_notification_shop.id_st_notification = snl.id_st_notification AND st_notification_shop.id_shop = XX) LEFT JOIN `mmag_st_notification_lang` snll ON (snl.`id_st_notification` = snll.`id_st_notification`) WHERE snl.`active`=XX AND snll.`id_lang` = XX ORDER BY snl.`position`
2 queries	SELECT snl., snll. FROM `mmag_st_sidebar` snl INNER JOIN mmag_st_sidebar_shop st_sidebar_shop ON (st_sidebar_shop.id_st_sidebar = snl.id_st_sidebar AND st_sidebar_shop.id_shop = XX) LEFT JOIN `mmag_st_sidebar_lang` snll ON (snl.`id_st_sidebar` = snll.`id_st_sidebar`) WHERE snll.`id_lang` = XX AND snl.`active`=XX ORDER BY snl.`location`, snl.`position`

Name	Instances	Source
Category	82	/controllers/front/listing/CategoryController.php:78 (__construct) [id: 2] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 6] /override/classes/Link.php:63 (__construct) [id: 6] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 10] /override/classes/Link.php:63 (__construct) [id: 10] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 11] /override/classes/Link.php:63 (__construct) [id: 11] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 12] /override/classes/Link.php:63 (__construct) [id: 12] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 13] /override/classes/Link.php:63 (__construct) [id: 13] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 14] /override/classes/Link.php:63 (__construct) [id: 14] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 15] /override/classes/Link.php:63 (__construct) [id: 15] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 16] /override/classes/Link.php:63 (__construct) [id: 16] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 24] /override/classes/Link.php:63 (__construct) [id: 24] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 25] /override/classes/Link.php:63 (__construct) [id: 25] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 26] /override/classes/Link.php:63 (__construct) [id: 26] /classes/Meta.php:380 (__construct) [id: 2] /classes/PrestaShopCollection.php:385 (hydrateCollection) [id: ] /modules/ps_facetedsearch/src/Product/Search.php:364 (__construct) [id: 2] /modules/ps_facetedsearch/src/Filters/Block.php:157 (__construct) [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: 22] /modules/ststickers/classes/StStickersMapClass.php:168 (getParentsCategories) [id: 2] /modules/ststickers/classes/StStickersMapClass.php:159 (__construct) [id: 10] /modules/ststickers/classes/StStickersMapClass.php:168 (getParentsCategories) [id: 2] /modules/ststickers/classes/StStickersMapClass.php:159 (__construct) [id: 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: 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: 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/ps_categorytree/ps_categorytree.php:364 (getParentsCategories) [id: 2] /override/classes/Link.php:63 (__construct) [id: 7] /override/classes/Link.php:63 (__construct) [id: 8] /override/classes/Link.php:63 (__construct) [id: 6] /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] /override/classes/Link.php:63 (__construct) [id: 29] /override/classes/Link.php:63 (__construct) [id: 30] /override/classes/Link.php:63 (__construct) [id: 31] /override/classes/Link.php:63 (__construct) [id: 32] /override/classes/Link.php:63 (__construct) [id: 33] /override/classes/Link.php:63 (__construct) [id: 11] /override/classes/Link.php:63 (__construct) [id: 12] /override/classes/Link.php:63 (__construct) [id: 13] /override/classes/Link.php:63 (__construct) [id: 14] /override/classes/Link.php:63 (__construct) [id: 15] /override/classes/Link.php:63 (__construct) [id: 16] /override/classes/Link.php:63 (__construct) [id: 24] /override/classes/Link.php:63 (__construct) [id: 25] /override/classes/Link.php:63 (__construct) [id: 26] /override/classes/Link.php:63 (__construct) [id: 2]
Product	24	/classes/Link.php:113 (__construct) [id: 88] /classes/Link.php:113 (__construct) [id: 166] /classes/Link.php:113 (__construct) [id: 62] /classes/Link.php:113 (__construct) [id: 85] /classes/Link.php:113 (__construct) [id: 86] /classes/Link.php:113 (__construct) [id: 68] /modules/ststickers/classes/StStickersMapClass.php:152 (__construct) [id: 88] /modules/ststickers/classes/StStickersMapClass.php:152 (__construct) [id: 166] /modules/ststickers/classes/StStickersMapClass.php:152 (__construct) [id: 62] /modules/ststickers/classes/StStickersMapClass.php:152 (__construct) [id: 85] /modules/ststickers/classes/StStickersMapClass.php:152 (__construct) [id: 86] /modules/ststickers/classes/StStickersMapClass.php:152 (__construct) [id: 68] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 88] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 166] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 62] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 85] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 86] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 68] /classes/Link.php:113 (__construct) [id: 88] /classes/Link.php:113 (__construct) [id: 166] /classes/Link.php:113 (__construct) [id: 62] /classes/Link.php:113 (__construct) [id: 85] /classes/Link.php:113 (__construct) [id: 86] /classes/Link.php:113 (__construct) [id: 68]
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
160	REPLACE INTO mmag_layered_filter_block (hash, data) VALUES ("6c72f5f4432e2f81d9a0336d9ea10ba3", "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:95;s:4:\"unit\";s:3:\"lei\";s:14:\"specifications\";a:11:{s:6:\"symbol\";a:11:{i:0;s:1:\",\";i:1;s:1:\".\";i:2;s:1:\";\";i:3;s:1:\"%\";i:4;s:1:\"-\";i:5;s:1:\"+\";i:6;s:1:\"E\";i:7;s:2:\"×\";i:8;s:3:\"‰\";i:9;s:3:\"∞\";i:10;s:3:\"NaN\";}s:12:\"currencyCode\";s:3:\"RON\";s:14:\"currencySymbol\";s:3:\"lei\";s:13:\"numberSymbols\";a:11:{i:0;s:1:\",\";i:1;s:1:\".\";i:2;s:1:\";\";i:3;s:1:\"%\";i:4;s:1:\"-\";i:5;s:1:\"+\";i:6;s:1:\"E\";i:7;s:2:\"×\";i:8;s:3:\"‰\";i:9;s:3:\"∞\";i:10;s:3:\"NaN\";}s:15:\"positivePattern\";s:12:\"#,##0.00 ¤\";s:15:\"negativePattern\";s:13:\"-#,##0.00 ¤\";s:17:\"maxFractionDigits\";i:2;s:17:\"minFractionDigits\";i:2;s:12:\"groupingUsed\";b:1;s:16:\"primaryGroupSize\";i:3;s:18:\"secondaryGroupSize\";i:3;}s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";i:3;s:3:\"nbr\";i:6;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:6;}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:1;}s:8:\"discount\";a:3:{s:4:\"name\";s:5:\"Redus\";s:3:\"nbr\";i:6;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:2:{i:10;a:2:{s:4:\"name\";s:19:\"Corpuri de iluminat\";s:3:\"nbr\";s:1:\"6\";}i:24;a:2:{s:4:\"name\";s:19:\"Produse la reducere\";s:3:\"nbr\";s:1:\"2\";}}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:1:{i:695;a:4:{s:3:\"nbr\";s:1:\"2\";s:4:\"name\";s:19:\"Metal auriu satinat\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}}s:4:\"name\";s:17:\"Compozitie abajur\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";s:1:\"0\";}i:5;a:9:{s:9:\"type_lite\";s:10:\"id_feature\";s:4:\"type\";s:10:\"id_feature\";s:6:\"id_key\";s:1:\"2\";s:6:\"values\";a:3:{i:787;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:13:\"Clasic, baroc\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:783;a:4:{s:3:\"nbr\";s:1:\"3\";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:\"1\";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:0:{}s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";s:1:\"0\";}i:7;a:7:{s:9:\"type_lite\";s:9:\"condition\";s:4:\"type\";s:9:\"condition\";s:6:\"id_key\";i:0;s:4:\"name\";s:5:\"Stare\";s:6:\"values\";a:3:{s:3:\"new\";a:2:{s:4:\"name\";s:3:\"Nou\";s:3:\"nbr\";s:1:\"6\";}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:2;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:6;}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:2:{i:774;a:4:{s:3:\"nbr\";s:1:\"4\";s:4:\"name\";s:1:\"1\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}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;}}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:93:{i:1050;a:4:{s:3:\"nbr\";s:1:\"2\";s:4:\"name\";s:13:\"6 cm inaltime\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:949;a:5:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:14:\"15 cm inaltime\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:7:\"checked\";b:1;}i:812;a:4:{s:3:\"nbr\";s:1:\"2\";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:\"2\";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:\"4\";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:\"5\";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:818;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:14:\"28 cm inaltime\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:819;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:15:\"29 cm inaltime \";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:820;a:4:{s:3:\"nbr\";s:1:\"3\";s:4:\"name\";s:14:\"30 cm inaltime\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:821;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:15:\"31 cm inaltime \";s:8:\"url_name\";N;s:10:\"meta_title\";N;}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:1354;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:5:\"35 CM\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:822;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:14:\"35 cm inaltime\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:823;a:4:{s:3:\"nbr\";s:1:\"2\";s:4:\"name\";s:14:\"37 cm inaltime\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:824;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:17:\"37.9 cm inaltime \";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:825;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:14:\"38 cm inaltime\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:826;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:14:\"42 cm inaltime\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:827;a:4:{s:3:\"nbr\";s:1:\"3\";s:4:\"name\";s:14:\"44 cm inaltime\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:1346;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:5:\"45 CM\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:1374;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:5:\"45 CM\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:828;a:4:{s:3:\"nbr\";s:1:\"2\";s:4:\"name\";s:14:\"46 cm inaltime\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:1310;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:5:\"50 CM\";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:1287;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:5:\"55 CM\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:1297;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:5:\"55 CM\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:1316;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:5:\"55 CM\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:1398;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:5:\"55 CM\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:829;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:15:\"55 cm inaltime \";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:1045;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:14:\"57 cm inaltime\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:830;a:5:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:14:\"59 cm inaltime\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:7:\"checked\";b:1;}i:1359;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:5:\"60 CM\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:952;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:14:\"60 cm inaltime\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:1343;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:5:\"65 CM\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:1352;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:5:\"65 CM\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:1395;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:5:\"65 CM\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:831;a:4:{s:3:\"nbr\";s:1:\"4\";s:4:\"name\";s:15:\"67 cm inaltime \";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:1271;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:5:\"70 CM\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:1274;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:5:\"70 CM\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:1278;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:5:\"70 CM\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:1283;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:5:\"70 CM\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:1293;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:5:\"70 CM\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:1133;a:4:{s:3:\"nbr\";s:1:\"2\";s:4:\"name\";s:14:\"71 cm inaltime\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:1052;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:14:\"72 cm inaltime\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:1340;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:5:\"75 CM\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:1347;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:5:\"75 CM\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:1402;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:5:\"75 CM\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:1424;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:5:\"75 CM\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:1046;a:4:{s:3:\"nbr\";s:1:\"2\";s:4:\"name\";s:14:\"77 cm inaltime\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:1281;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:5:\"80 CM\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:1301;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:5:\"80 CM\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:1307;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:5:\"80 CM\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:1327;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:5:\"80 CM\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:1328;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:5:\"80 CM\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:1362;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:5:\"80 CM\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:1365;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:5:\"80 CM\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:1412;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:5:\"80 CM\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:1421;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:5:\"80 CM\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:832;a:4:{s:3:\"nbr\";s:1:\"3\";s:4:\"name\";s:15:\"84 cm inaltime \";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:1322;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:5:\"85 CM\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:1334;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:5:\"85 CM\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:1337;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:5:\"85 CM\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:1356;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:5:\"85 CM\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:1392;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:2:\"90\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:1291;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:5:\"90 CM\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:1371;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:5:\"90 CM\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:1403;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:5:\"90 CM\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:1406;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:5:\"90 CM\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:1415;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:5:\"90 CM\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:1418;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:5:\"90 CM\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:833;a:5:{s:3:\"nbr\";s:1:\"2\";s:4:\"name\";s:14:\"92 cm inaltime\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:7:\"checked\";b:1;}i:1368;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:5:\"95 CM\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:1430;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:5:\"95 CM\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:1304;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:6:\"100 CM\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:1314;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:6:\"100 CM\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:1377;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:6:\"100 CM\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:1380;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:6:\"100 CM\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:808;a:4:{s:3:\"nbr\";s:1:\"2\";s:4:\"name\";s:15:\"100 cm inaltime\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:1389;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:6:\"110 CM\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:1399;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:6:\"110 CM\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:1386;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:6:\"120 CM\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:809;a:4:{s:3:\"nbr\";s:1:\"8\";s:4:\"name\";s:15:\"120 cm inaltime\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:810;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:15:\"133 cm inaltime\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:1427;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:6:\"150 CM\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:811;a:4:{s:3:\"nbr\";s:1:\"9\";s:4:\"name\";s:15:\"150 cm inaltime\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:813;a:4:{s:3:\"nbr\";s:1:\"2\";s:4:\"name\";s:15:\"165 cm inaltime\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:1333;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:6:\"170 CM\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:1262;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:6:\"180 CM\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:1383;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:6:\"190 CM\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:814;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:16:\"190 cm inaltime \";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:1319;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:6:\"210 CM\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:817;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:25:\"250 cm inaltime ajustabil\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}}s:4:\"name\";s:8:\"Inaltime\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";s:1:\"0\";}i:11;a:9:{s:9:\"type_lite\";s:10:\"id_feature\";s:4:\"type\";s:10:\"id_feature\";s:6:\"id_key\";s:1:\"7\";s:6:\"values\";a:1:{i:741;a: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:\"2\";s:4:\"name\";s:3:\"E27\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:795;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:3:\"LED\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}}s:4:\"name\";s:7:\"Tip bec\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";s:1:\"0\";}i:13;a:9:{s:9:\"type_lite\";s:10:\"id_feature\";s:4:\"type\";s:10:\"id_feature\";s:6:\"id_key\";s:2:\"10\";s:6:\"values\";a:3:{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:737;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:8:\"Argintiu\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:740;a:4:{s:3:\"nbr\";s:1:\"2\";s:4:\"name\";s:14:\"Negru si auriu\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}}s:4:\"name\";s:7:\"Culoare\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";s:1:\"0\";}i:14;a:9:{s:9:\"type_lite\";s:10:\"id_feature\";s:4:\"type\";s:10:\"id_feature\";s:6:\"id_key\";s:2:\"11\";s:6:\"values\";a:1:{i:720;a:4:{s:3:\"nbr\";s:1:\"2\";s:4:\"name\";s:11:\"Metal Negru\";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:\"3\";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:\"2\";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:2:{i:749;a:4:{s:3:\"nbr\";s:1:\"2\";s:4:\"name\";s:3:\"40W\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:751;a:4:{s:3:\"nbr\";s:1:\"2\";s:4:\"name\";s:3:\"60W\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}}s:4:\"name\";s:10:\"Putere bec\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";s:1:\"0\";}i:17;a:9:{s:9:\"type_lite\";s:10:\"id_feature\";s:4:\"type\";s:10:\"id_feature\";s:6:\"id_key\";s:2:\"14\";s:6:\"values\";a:1:{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;}}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:\"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:19;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:20;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:2:{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:884;a:4:{s:3:\"nbr\";s:1:\"2\";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:21;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:929;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:13:\"28 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:22;a:9:{s:9:\"type_lite\";s:10:\"id_feature\";s:4:\"type\";s:10:\"id_feature\";s:6:\"id_key\";s:2:\"22\";s:6:\"values\";a:2:{i: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:838;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:14:\"23 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\";}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:\"23\";s:6:\"values\";a:1:{i:760;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:10:\"Cristal K9\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}}s:4:\"name\";s:13:\"Material corp\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";s:1:\"0\";}}}")	28.017 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)
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.256 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)
129	SELECT SQL_NO_CACHE fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, pl.name FROM mmag_product p LEFT JOIN mmag_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mmag_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN mmag_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN mmag_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN mmag_product_lang pl ON (p.id_product = pl.id_product AND pl.id_shop = 1 AND pl.id_lang = 1) INNER JOIN mmag_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN mmag_category_product cp ON (p.id_product = cp.id_product) INNER JOIN mmag_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN mmag_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN mmag_specific_price sp ON ( sp.id_product = p.id_product AND sp.id_shop IN (0, 1) AND sp.id_currency IN (0, 1) AND sp.id_country IN (0, 36) AND sp.id_group IN (0, 1) AND sp.from_quantity = 1 AND sp.reduction > 0 AND sp.id_customer = 0 AND sp.id_cart = 0 AND (sp.from = '0000-00-00 00:00:00' OR '2025-04-25 20:00:58' >= sp.from) AND (sp.to = '0000-00-00 00:00:00' OR '2025-04-25 20:00:58' <= sp.to) ) WHERE ((sp.reduction>0)) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=2 AND c.nright<=53 GROUP BY p.id_product) p INNER JOIN mmag_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN mmag_specific_price sp_1 ON ( sp_1.id_product = p.id_product AND sp_1.id_shop IN (0, 1) AND sp_1.id_currency IN (0, 1) AND sp_1.id_country IN (0, 36) AND sp_1.id_group IN (0, 1) AND sp_1.from_quantity = 1 AND sp_1.reduction > 0 AND sp_1.id_customer = 0 AND sp_1.id_cart = 0 AND (sp_1.from = '0000-00-00 00:00:00' OR '2025-04-25 20:00:58' >= sp_1.from) AND (sp_1.to = '0000-00-00 00:00:00' OR '2025-04-25 20:00:58' <= sp_1.to) ) WHERE ((fp.id_feature=5)) AND ((sp_1.reduction>0)) GROUP BY fp.id_feature_value	9.339 ms	2244	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:778 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:855 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:154 (getFeaturesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:357 (runQuery) /override/controllers/front/listing/CategoryController.php:22 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
20	SELECT SQL_NO_CACHE h.`name` as hook, m.`id_module`, h.`id_hook`, m.`name` as module FROM `mmag_module` m INNER JOIN mmag_module_shop module_shop ON (module_shop.id_module = m.id_module AND module_shop.id_shop = 1 AND module_shop.enable_device & 1) INNER JOIN `mmag_hook_module` `hm` ON hm.`id_module` = m.`id_module` INNER JOIN `mmag_hook` `h` ON hm.`id_hook` = h.`id_hook` LEFT JOIN `mmag_module_group` `mg` ON mg.`id_module` = m.`id_module` WHERE (h.`name` != "paymentOptions") AND (hm.`id_shop` = 1) AND (mg.id_shop = 1 AND mg.`id_group` IN (1)) GROUP BY hm.id_hook, hm.id_module ORDER BY hm.`position`	9.188 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)
126	SELECT SQL_NO_CACHE fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, pl.name FROM mmag_product p LEFT JOIN mmag_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mmag_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN mmag_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN mmag_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN mmag_product_lang pl ON (p.id_product = pl.id_product AND pl.id_shop = 1 AND pl.id_lang = 1) INNER JOIN mmag_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN mmag_category_product cp ON (p.id_product = cp.id_product) INNER JOIN mmag_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN mmag_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN mmag_specific_price sp ON ( sp.id_product = p.id_product AND sp.id_shop IN (0, 1) AND sp.id_currency IN (0, 1) AND sp.id_country IN (0, 36) AND sp.id_group IN (0, 1) AND sp.from_quantity = 1 AND sp.reduction > 0 AND sp.id_customer = 0 AND sp.id_cart = 0 AND (sp.from = '0000-00-00 00:00:00' OR '2025-04-25 20:00:58' >= sp.from) AND (sp.to = '0000-00-00 00:00:00' OR '2025-04-25 20:00:58' <= 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 (949, 1047, 830, 833))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=2 AND c.nright<=53 GROUP BY p.id_product) p INNER JOIN mmag_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN mmag_specific_price sp_1 ON ( sp_1.id_product = p.id_product AND sp_1.id_shop IN (0, 1) AND sp_1.id_currency IN (0, 1) AND sp_1.id_country IN (0, 36) AND sp_1.id_group IN (0, 1) AND sp_1.from_quantity = 1 AND sp_1.reduction > 0 AND sp_1.id_customer = 0 AND sp_1.id_cart = 0 AND (sp_1.from = '0000-00-00 00:00:00' OR '2025-04-25 20:00:58' >= sp_1.from) AND (sp_1.to = '0000-00-00 00:00:00' OR '2025-04-25 20:00:58' <= sp_1.to) ) LEFT JOIN mmag_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((fp.id_feature=3)) AND ((sp_1.reduction>0)) AND ((fp_2.id_feature_value IN (949, 1047, 830, 833))) GROUP BY fp.id_feature_value	6.130 ms	3528	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)
19	SELECT SQL_NO_CACHE lower(name) as name FROM `mmag_hook` h WHERE (h.active = 1)	3.972 ms	1048			/classes/Hook.php:1388 /classes/Hook.php:817 (getHookStatusByName) /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)
13	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.671 ms	129			/classes/module/Module.php:346 /modules/sturls/sturls.php:61 (__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) /override/classes/Dispatcher.php:39 (getInstanceByName) /classes/Dispatcher.php:201 (__construct) /index.php:28 (getInstance)
85	SELECT SQL_NO_CACHE 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` = 1) 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` = 1 AND s.`active`=1 AND s.`type` IN (1,2,3,4,5,6,7) AND sg.`id_group` IN (1) GROUP BY s.`id_st_sticker` ORDER BY s.`position` ASC, s.`id_st_sticker`	3.653 ms	7	Yes	Yes	/modules/ststickers/classes/StStickersClass.php:171 /modules/ststickers/ststickers.php:1670 (getAll) /modules/ststickers/ststickers.php:1397 (getWidgetVariables) /classes/Hook.php:1083 (hookDisplayHeader) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:421 (coreCallHook) /classes/Hook.php:989 (callHookOn) /classes/controller/FrontController.php:633 (exec) /override/classes/controller/FrontController.php:11 (initContent) /controllers/front/listing/CategoryController.php:127 (initContent) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
62	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.454 ms	129			/classes/module/Module.php:346 /modules/ps_emailalerts/ps_emailalerts.php:67 (__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/controller/FrontController.php:1004 (exec) /tools/profiling/Controller.php:48 (setMedia) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
22	SELECT SQL_NO_CACHE `id_hook`, `name` FROM `mmag_hook`	3.344 ms	1048			/classes/Hook.php:1348 /classes/Hook.php:228 (getAllHookIds) /classes/Hook.php:857 (getIdByName) /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)
50	SELECT SQL_NO_CACHE * FROM `mmag_image_type` WHERE 1 AND `categories` = 1 ORDER BY `width` DESC, `height` DESC, `name`ASC	3.304 ms	17	Yes		/classes/ImageType.php:109 /src/Adapter/Image/ImageRetriever.php:221 (getImagesTypes) /controllers/front/listing/CategoryController.php:239 (getImage) /controllers/front/listing/CategoryController.php:221 (getImage) :undefined ({closure}) /controllers/front/listing/CategoryController.php:230 (array_map) /controllers/front/listing/CategoryController.php:118 (getTemplateVarSubCategories) /tools/profiling/Controller.php:41 (init) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
57	SELECT SQL_NO_CACHE * FROM `mmag_category` a LEFT JOIN `mmag_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1 LEFT JOIN `mmag_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1 WHERE (a.`id_category` = 15) AND (b.`id_shop` = 1) LIMIT 1	3.286 ms	1			/src/Adapter/EntityMapper.php:71 /classes/ObjectModel.php:283 (load) /tools/profiling/ObjectModel.php:32 (__construct) /classes/Category.php:164 (__construct) /controllers/front/listing/CategoryController.php:216 (__construct) :undefined ({closure}) /controllers/front/listing/CategoryController.php:230 (array_map) /controllers/front/listing/CategoryController.php:118 (getTemplateVarSubCategories) /tools/profiling/Controller.php:41 (init) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
68	SELECT SQL_NO_CACHE `id_module` FROM `mmag_module` WHERE `name` = "ps_legalcompliance" LIMIT 1	3.005 ms	0			/classes/module/Module.php:2664 /classes/module/Module.php:2136 (getModuleIdByName) /classes/controller/FrontController.php:1669 (isEnabled) /classes/controller/FrontController.php:1813 (getDisplayTaxesLabel) /controllers/front/listing/CategoryController.php:276 (getTemplateVarPage) /classes/controller/FrontController.php:562 (getTemplateVarPage) /classes/controller/FrontController.php:625 (assignGeneralPurposeVariables) /override/classes/controller/FrontController.php:11 (initContent) /controllers/front/listing/CategoryController.php:127 (initContent) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
32	SELECT SQL_NO_CACHE * FROM `mmag_category` a LEFT JOIN `mmag_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1 LEFT JOIN `mmag_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1 WHERE (a.`id_category` = 2) AND (b.`id_shop` = 1) LIMIT 1	2.940 ms	1			/src/Adapter/EntityMapper.php:71 /classes/ObjectModel.php:283 (load) /tools/profiling/ObjectModel.php:32 (__construct) /classes/Category.php:164 (__construct) /controllers/front/listing/CategoryController.php:78 (__construct) /tools/profiling/Controller.php:41 (init) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
78	SELECT SQL_NO_CACHE `id_module` FROM `mmag_module` WHERE `name` = "steasybuilder" LIMIT 1	2.842 ms	0			/classes/module/Module.php:2664 /classes/module/Module.php:2112 (getModuleIdByName) /modules/stthemeeditor/stthemeeditor.php:4213 (isInstalled) /modules/stthemeeditor/stthemeeditor.php:4125 (isEbTransPandaInstalled) /classes/Hook.php:1083 (hookDisplayHeader) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:421 (coreCallHook) /classes/Hook.php:989 (callHookOn) /classes/controller/FrontController.php:633 (exec) /override/classes/controller/FrontController.php:11 (initContent) /controllers/front/listing/CategoryController.php:127 (initContent) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
86	SELECT SQL_NO_CACHE `id_module` FROM `mmag_module` WHERE `name` = "stsearchbar" LIMIT 1	2.660 ms	1			/classes/module/Module.php:2664 /classes/module/Module.php:2136 (getModuleIdByName) /classes/Hook.php:1089 (isEnabled) /tools/profiling/Hook.php:64 (coreRenderWidget) /classes/Hook.php:1025 (coreRenderWidget) /override/classes/controller/FrontController.php:15 (exec) /controllers/front/listing/CategoryController.php:127 (initContent) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
33	SELECT SQL_NO_CACHE * FROM `mmag_currency` c ORDER BY `iso_code` ASC	2.509 ms	1	Yes		/classes/Currency.php:709 /src/Adapter/Currency/CurrencyDataProvider.php:84 (findAllInstalled) /src/Core/Localization/Currency/DataLayer/CurrencyInstalled.php:90 (findAllInstalled) /src/Core/Localization/Currency/CurrencyDataSource.php:96 (getAllInstalledCurrencyIsoCodes) /src/Core/Localization/Currency/Repository.php:87 (getAllInstalledCurrenciesData) /src/Core/Localization/Locale/Repository.php:207 (getAllInstalledCurrencies) /src/Core/Localization/Locale/Repository.php:150 (getPriceSpecifications) /classes/controller/Controller.php:209 (getLocale) /classes/controller/FrontController.php:284 (init) /controllers/front/listing/CategoryController.php:81 (init) /tools/profiling/Controller.php:41 (init) /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:00:58' >= sp.from) AND (sp.to = '0000-00-00 00:00:00' OR '2025-04-25 20:00:58' <= 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 (949, 1047, 830, 833))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=2 AND c.nright<=53 GROUP BY p.id_product) p INNER JOIN mmag_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN mmag_specific_price sp_1 ON ( sp_1.id_product = p.id_product AND sp_1.id_shop IN (0, 1) AND sp_1.id_currency IN (0, 1) AND sp_1.id_country IN (0, 36) AND sp_1.id_group IN (0, 1) AND sp_1.from_quantity = 1 AND sp_1.reduction > 0 AND sp_1.id_customer = 0 AND sp_1.id_cart = 0 AND (sp_1.from = '0000-00-00 00:00:00' OR '2025-04-25 20:00:58' >= sp_1.from) AND (sp_1.to = '0000-00-00 00:00:00' OR '2025-04-25 20:00:58' <= sp_1.to) ) LEFT JOIN mmag_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((fp.id_feature=18)) AND ((sp_1.reduction>0)) AND ((fp_2.id_feature_value IN (949, 1047, 830, 833))) GROUP BY fp.id_feature_value	2.441 ms	1764	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)
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_specific_price sp ON ( sp.id_product = p.id_product AND sp.id_shop IN (0, 1) AND sp.id_currency IN (0, 1) AND sp.id_country IN (0, 36) AND sp.id_group IN (0, 1) AND sp.from_quantity = 1 AND sp.reduction > 0 AND sp.id_customer = 0 AND sp.id_cart = 0 AND (sp.from = '0000-00-00 00:00:00' OR '2025-04-25 20:00:58' >= sp.from) AND (sp.to = '0000-00-00 00:00:00' OR '2025-04-25 20:00:58' <= 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 (949, 1047, 830, 833))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=2 AND c.nright<=53 GROUP BY p.id_product) p LEFT JOIN mmag_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mmag_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN mmag_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN mmag_stock_available sa_1 ON (p.id_product = sa_1.id_product AND IFNULL(pac.id_product_attribute, 0) = sa_1.id_product_attribute AND sa_1.id_shop = 1 AND sa_1.id_shop_group = 0 ) LEFT JOIN mmag_specific_price sp_1 ON ( sp_1.id_product = p.id_product AND sp_1.id_shop IN (0, 1) AND sp_1.id_currency IN (0, 1) AND sp_1.id_country IN (0, 36) AND sp_1.id_group IN (0, 1) AND sp_1.from_quantity = 1 AND sp_1.reduction > 0 AND sp_1.id_customer = 0 AND sp_1.id_cart = 0 AND (sp_1.from = '0000-00-00 00:00:00' OR '2025-04-25 20:00:58' >= sp_1.from) AND (sp_1.to = '0000-00-00 00:00:00' OR '2025-04-25 20:00:58' <= sp_1.to) ) LEFT JOIN mmag_feature_product fp_2 ON (p.id_product = fp_2.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 (949, 1047, 830, 833)))	2.436 ms	1764			/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)
133	SELECT SQL_NO_CACHE fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, pl.name FROM mmag_product p LEFT JOIN mmag_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mmag_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN mmag_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN mmag_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN mmag_product_lang pl ON (p.id_product = pl.id_product AND pl.id_shop = 1 AND pl.id_lang = 1) INNER JOIN mmag_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN mmag_category_product cp ON (p.id_product = cp.id_product) INNER JOIN mmag_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN mmag_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN mmag_specific_price sp ON ( sp.id_product = p.id_product AND sp.id_shop IN (0, 1) AND sp.id_currency IN (0, 1) AND sp.id_country IN (0, 36) AND sp.id_group IN (0, 1) AND sp.from_quantity = 1 AND sp.reduction > 0 AND sp.id_customer = 0 AND sp.id_cart = 0 AND (sp.from = '0000-00-00 00:00:00' OR '2025-04-25 20:00:58' >= sp.from) AND (sp.to = '0000-00-00 00:00:00' OR '2025-04-25 20:00:58' <= 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 (949, 1047, 830, 833))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=2 AND c.nright<=53 GROUP BY p.id_product) p INNER JOIN mmag_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN mmag_specific_price sp_1 ON ( sp_1.id_product = p.id_product AND sp_1.id_shop IN (0, 1) AND sp_1.id_currency IN (0, 1) AND sp_1.id_country IN (0, 36) AND sp_1.id_group IN (0, 1) AND sp_1.from_quantity = 1 AND sp_1.reduction > 0 AND sp_1.id_customer = 0 AND sp_1.id_cart = 0 AND (sp_1.from = '0000-00-00 00:00:00' OR '2025-04-25 20:00:58' >= sp_1.from) AND (sp_1.to = '0000-00-00 00:00:00' OR '2025-04-25 20:00:58' <= sp_1.to) ) LEFT JOIN mmag_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((fp.id_feature=9)) AND ((sp_1.reduction>0)) AND ((fp_2.id_feature_value IN (949, 1047, 830, 833))) GROUP BY fp.id_feature_value	2.427 ms	1764	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:778 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:855 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:154 (getFeaturesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:357 (runQuery) /override/controllers/front/listing/CategoryController.php:22 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
122	SELECT SQL_NO_CACHE fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, pl.name FROM mmag_product p LEFT JOIN mmag_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mmag_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN mmag_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN mmag_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN mmag_product_lang pl ON (p.id_product = pl.id_product AND pl.id_shop = 1 AND pl.id_lang = 1) INNER JOIN mmag_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN mmag_category_product cp ON (p.id_product = cp.id_product) INNER JOIN mmag_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN mmag_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN mmag_specific_price sp ON ( sp.id_product = p.id_product AND sp.id_shop IN (0, 1) AND sp.id_currency IN (0, 1) AND sp.id_country IN (0, 36) AND sp.id_group IN (0, 1) AND sp.from_quantity = 1 AND sp.reduction > 0 AND sp.id_customer = 0 AND sp.id_cart = 0 AND (sp.from = '0000-00-00 00:00:00' OR '2025-04-25 20:00:58' >= sp.from) AND (sp.to = '0000-00-00 00:00:00' OR '2025-04-25 20:00:58' <= 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 (949, 1047, 830, 833))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=2 AND c.nright<=53 GROUP BY p.id_product) p INNER JOIN mmag_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN mmag_specific_price sp_1 ON ( sp_1.id_product = p.id_product AND sp_1.id_shop IN (0, 1) AND sp_1.id_currency IN (0, 1) AND sp_1.id_country IN (0, 36) AND sp_1.id_group IN (0, 1) AND sp_1.from_quantity = 1 AND sp_1.reduction > 0 AND sp_1.id_customer = 0 AND sp_1.id_cart = 0 AND (sp_1.from = '0000-00-00 00:00:00' OR '2025-04-25 20:00:58' >= sp_1.from) AND (sp_1.to = '0000-00-00 00:00:00' OR '2025-04-25 20:00:58' <= sp_1.to) ) LEFT JOIN mmag_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((fp.id_feature=6)) AND ((sp_1.reduction>0)) AND ((fp_2.id_feature_value IN (949, 1047, 830, 833))) GROUP BY fp.id_feature_value	2.380 ms	1764	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)
121	SELECT SQL_NO_CACHE pac.id_attribute, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, pl.name FROM mmag_product p LEFT JOIN mmag_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mmag_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN mmag_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN mmag_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN mmag_product_lang pl ON (p.id_product = pl.id_product AND pl.id_shop = 1 AND pl.id_lang = 1) INNER JOIN mmag_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN mmag_category_product cp ON (p.id_product = cp.id_product) INNER JOIN mmag_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN mmag_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN mmag_specific_price sp ON ( sp.id_product = p.id_product AND sp.id_shop IN (0, 1) AND sp.id_currency IN (0, 1) AND sp.id_country IN (0, 36) AND sp.id_group IN (0, 1) AND sp.from_quantity = 1 AND sp.reduction > 0 AND sp.id_customer = 0 AND sp.id_cart = 0 AND (sp.from = '0000-00-00 00:00:00' OR '2025-04-25 20:00:58' >= sp.from) AND (sp.to = '0000-00-00 00:00:00' OR '2025-04-25 20:00:58' <= 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 (949, 1047, 830, 833))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=2 AND c.nright<=53 GROUP BY p.id_product) p LEFT JOIN mmag_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mmag_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) INNER JOIN mmag_attribute a ON (a.id_attribute = pac.id_attribute) LEFT JOIN mmag_specific_price sp_1 ON ( sp_1.id_product = p.id_product AND sp_1.id_shop IN (0, 1) AND sp_1.id_currency IN (0, 1) AND sp_1.id_country IN (0, 36) AND sp_1.id_group IN (0, 1) AND sp_1.from_quantity = 1 AND sp_1.reduction > 0 AND sp_1.id_customer = 0 AND sp_1.id_cart = 0 AND (sp_1.from = '0000-00-00 00:00:00' OR '2025-04-25 20:00:58' >= sp_1.from) AND (sp_1.to = '0000-00-00 00:00:00' OR '2025-04-25 20:00:58' <= sp_1.to) ) LEFT JOIN mmag_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((a.id_attribute_group=7)) AND ((sp_1.reduction>0)) AND ((fp_2.id_feature_value IN (949, 1047, 830, 833))) GROUP BY pac.id_attribute	2.322 ms	1764	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)
95	SELECT SQL_NO_CACHE p.id_product FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, pl.name FROM mmag_product p LEFT JOIN mmag_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mmag_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN mmag_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN mmag_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN mmag_product_lang pl ON (p.id_product = pl.id_product AND pl.id_shop = 1 AND pl.id_lang = 1) INNER JOIN mmag_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN mmag_category_product cp ON (p.id_product = cp.id_product) INNER JOIN mmag_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN mmag_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN mmag_specific_price sp ON ( sp.id_product = p.id_product AND sp.id_shop IN (0, 1) AND sp.id_currency IN (0, 1) AND sp.id_country IN (0, 36) AND sp.id_group IN (0, 1) AND sp.from_quantity = 1 AND sp.reduction > 0 AND sp.id_customer = 0 AND sp.id_cart = 0 AND (sp.from = '0000-00-00 00:00:00' OR '2025-04-25 20:00:58' >= sp.from) AND (sp.to = '0000-00-00 00:00:00' OR '2025-04-25 20:00:58' <= 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 (949, 1047, 830, 833))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=2 AND c.nright<=53 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	2.286 ms	84	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)
99	SELECT SQL_NO_CACHE COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, pl.name FROM mmag_product p LEFT JOIN mmag_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mmag_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN mmag_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN mmag_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN mmag_product_lang pl ON (p.id_product = pl.id_product AND pl.id_shop = 1 AND pl.id_lang = 1) INNER JOIN mmag_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN mmag_category_product cp ON (p.id_product = cp.id_product) INNER JOIN mmag_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN mmag_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN mmag_specific_price sp ON ( sp.id_product = p.id_product AND sp.id_shop IN (0, 1) AND sp.id_currency IN (0, 1) AND sp.id_country IN (0, 36) AND sp.id_group IN (0, 1) AND sp.from_quantity = 1 AND sp.reduction > 0 AND sp.id_customer = 0 AND sp.id_cart = 0 AND (sp.from = '0000-00-00 00:00:00' OR '2025-04-25 20:00:58' >= sp.from) AND (sp.to = '0000-00-00 00:00:00' OR '2025-04-25 20:00:58' <= 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 (949, 1047, 830, 833))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=2 AND c.nright<=53 GROUP BY p.id_product) p LEFT JOIN mmag_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mmag_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN mmag_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN mmag_specific_price sp_1 ON ( sp_1.id_product = p.id_product AND sp_1.id_shop IN (0, 1) AND sp_1.id_currency IN (0, 1) AND sp_1.id_country IN (0, 36) AND sp_1.id_group IN (0, 1) AND sp_1.from_quantity = 1 AND sp_1.reduction > 0 AND sp_1.id_customer = 0 AND sp_1.id_cart = 0 AND (sp_1.from = '0000-00-00 00:00:00' OR '2025-04-25 20:00:58' >= sp_1.from) AND (sp_1.to = '0000-00-00 00:00:00' OR '2025-04-25 20:00:58' <= sp_1.to) ) LEFT JOIN mmag_feature_product fp_2 ON (p.id_product = fp_2.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 (949, 1047, 830, 833)))	2.273 ms	1764			/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)
105	SELECT SQL_NO_CACHE cp.id_category, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, pl.name FROM mmag_product p LEFT JOIN mmag_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mmag_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN mmag_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN mmag_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN mmag_product_lang pl ON (p.id_product = pl.id_product AND pl.id_shop = 1 AND pl.id_lang = 1) INNER JOIN mmag_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN mmag_category_product cp ON (p.id_product = cp.id_product) INNER JOIN mmag_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN mmag_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN mmag_specific_price sp ON ( sp.id_product = p.id_product AND sp.id_shop IN (0, 1) AND sp.id_currency IN (0, 1) AND sp.id_country IN (0, 36) AND sp.id_group IN (0, 1) AND sp.from_quantity = 1 AND sp.reduction > 0 AND sp.id_customer = 0 AND sp.id_cart = 0 AND (sp.from = '0000-00-00 00:00:00' OR '2025-04-25 20:00:58' >= sp.from) AND (sp.to = '0000-00-00 00:00:00' OR '2025-04-25 20:00:58' <= 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 (949, 1047, 830, 833))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=2 AND c.nright<=53 GROUP BY p.id_product) p INNER JOIN mmag_category_product cp ON (p.id_product = cp.id_product) INNER JOIN mmag_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN mmag_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN mmag_specific_price sp ON ( sp.id_product = p.id_product AND sp.id_shop IN (0, 1) AND sp.id_currency IN (0, 1) AND sp.id_country IN (0, 36) AND sp.id_group IN (0, 1) AND sp.from_quantity = 1 AND sp.reduction > 0 AND sp.id_customer = 0 AND sp.id_cart = 0 AND (sp.from = '0000-00-00 00:00:00' OR '2025-04-25 20:00:58' >= sp.from) AND (sp.to = '0000-00-00 00:00:00' OR '2025-04-25 20:00:58' <= 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 (949, 1047, 830, 833))) AND cg.id_group='1' AND c.level_depth<=2 AND c.nleft>2 AND c.nright<53 GROUP BY cp.id_category	2.272 ms	3528	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)
112	SELECT SQL_NO_CACHE fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, pl.name FROM mmag_product p LEFT JOIN mmag_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mmag_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN mmag_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN mmag_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN mmag_product_lang pl ON (p.id_product = pl.id_product AND pl.id_shop = 1 AND pl.id_lang = 1) INNER JOIN mmag_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN mmag_category_product cp ON (p.id_product = cp.id_product) INNER JOIN mmag_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN mmag_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN mmag_specific_price sp ON ( sp.id_product = p.id_product AND sp.id_shop IN (0, 1) AND sp.id_currency IN (0, 1) AND sp.id_country IN (0, 36) AND sp.id_group IN (0, 1) AND sp.from_quantity = 1 AND sp.reduction > 0 AND sp.id_customer = 0 AND sp.id_cart = 0 AND (sp.from = '0000-00-00 00:00:00' OR '2025-04-25 20:00:58' >= sp.from) AND (sp.to = '0000-00-00 00:00:00' OR '2025-04-25 20:00:58' <= 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 (949, 1047, 830, 833))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=2 AND c.nright<=53 GROUP BY p.id_product) p INNER JOIN mmag_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN mmag_specific_price sp_1 ON ( sp_1.id_product = p.id_product AND sp_1.id_shop IN (0, 1) AND sp_1.id_currency IN (0, 1) AND sp_1.id_country IN (0, 36) AND sp_1.id_group IN (0, 1) AND sp_1.from_quantity = 1 AND sp_1.reduction > 0 AND sp_1.id_customer = 0 AND sp_1.id_cart = 0 AND (sp_1.from = '0000-00-00 00:00:00' OR '2025-04-25 20:00:58' >= sp_1.from) AND (sp_1.to = '0000-00-00 00:00:00' OR '2025-04-25 20:00:58' <= sp_1.to) ) LEFT JOIN mmag_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((fp.id_feature=2)) AND ((sp_1.reduction>0)) AND ((fp_2.id_feature_value IN (949, 1047, 830, 833))) GROUP BY fp.id_feature_value	2.270 ms	1764	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:778 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:855 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:154 (getFeaturesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:357 (runQuery) /override/controllers/front/listing/CategoryController.php:22 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
119	SELECT SQL_NO_CACHE pac.id_attribute, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, pl.name FROM mmag_product p LEFT JOIN mmag_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mmag_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN mmag_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN mmag_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN mmag_product_lang pl ON (p.id_product = pl.id_product AND pl.id_shop = 1 AND pl.id_lang = 1) INNER JOIN mmag_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN mmag_category_product cp ON (p.id_product = cp.id_product) INNER JOIN mmag_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN mmag_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN mmag_specific_price sp ON ( sp.id_product = p.id_product AND sp.id_shop IN (0, 1) AND sp.id_currency IN (0, 1) AND sp.id_country IN (0, 36) AND sp.id_group IN (0, 1) AND sp.from_quantity = 1 AND sp.reduction > 0 AND sp.id_customer = 0 AND sp.id_cart = 0 AND (sp.from = '0000-00-00 00:00:00' OR '2025-04-25 20:00:58' >= sp.from) AND (sp.to = '0000-00-00 00:00:00' OR '2025-04-25 20:00:58' <= 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 (949, 1047, 830, 833))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=2 AND c.nright<=53 GROUP BY p.id_product) p LEFT JOIN mmag_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mmag_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) INNER JOIN mmag_attribute a ON (a.id_attribute = pac.id_attribute) LEFT JOIN mmag_specific_price sp_1 ON ( sp_1.id_product = p.id_product AND sp_1.id_shop IN (0, 1) AND sp_1.id_currency IN (0, 1) AND sp_1.id_country IN (0, 36) AND sp_1.id_group IN (0, 1) AND sp_1.from_quantity = 1 AND sp_1.reduction > 0 AND sp_1.id_customer = 0 AND sp_1.id_cart = 0 AND (sp_1.from = '0000-00-00 00:00:00' OR '2025-04-25 20:00:58' >= sp_1.from) AND (sp_1.to = '0000-00-00 00:00:00' OR '2025-04-25 20:00:58' <= sp_1.to) ) LEFT JOIN mmag_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((a.id_attribute_group=6)) AND ((sp_1.reduction>0)) AND ((fp_2.id_feature_value IN (949, 1047, 830, 833))) GROUP BY pac.id_attribute	2.247 ms	1764	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)
127	SELECT SQL_NO_CACHE fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, pl.name FROM mmag_product p LEFT JOIN mmag_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mmag_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN mmag_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN mmag_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN mmag_product_lang pl ON (p.id_product = pl.id_product AND pl.id_shop = 1 AND pl.id_lang = 1) INNER JOIN mmag_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN mmag_category_product cp ON (p.id_product = cp.id_product) INNER JOIN mmag_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN mmag_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN mmag_specific_price sp ON ( sp.id_product = p.id_product AND sp.id_shop IN (0, 1) AND sp.id_currency IN (0, 1) AND sp.id_country IN (0, 36) AND sp.id_group IN (0, 1) AND sp.from_quantity = 1 AND sp.reduction > 0 AND sp.id_customer = 0 AND sp.id_cart = 0 AND (sp.from = '0000-00-00 00:00:00' OR '2025-04-25 20:00:58' >= sp.from) AND (sp.to = '0000-00-00 00:00:00' OR '2025-04-25 20:00:58' <= 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 (949, 1047, 830, 833))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=2 AND c.nright<=53 GROUP BY p.id_product) p INNER JOIN mmag_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN mmag_specific_price sp_1 ON ( sp_1.id_product = p.id_product AND sp_1.id_shop IN (0, 1) AND sp_1.id_currency IN (0, 1) AND sp_1.id_country IN (0, 36) AND sp_1.id_group IN (0, 1) AND sp_1.from_quantity = 1 AND sp_1.reduction > 0 AND sp_1.id_customer = 0 AND sp_1.id_cart = 0 AND (sp_1.from = '0000-00-00 00:00:00' OR '2025-04-25 20:00:58' >= sp_1.from) AND (sp_1.to = '0000-00-00 00:00:00' OR '2025-04-25 20:00:58' <= 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 (949, 1047, 830, 833))) GROUP BY fp.id_feature_value	2.241 ms	1764	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.233 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)
84	SELECT SQL_NO_CACHE `id_module` FROM `mmag_module` WHERE `name` = "jscomposer" LIMIT 1	2.227 ms	0			/classes/module/Module.php:2664 /classes/module/Module.php:2112 (getModuleIdByName) /modules/stproductcategoriesslider/stproductcategoriesslider.php:91 (isInstalled) /modules/stproductcategoriesslider/stproductcategoriesslider.php:83 (initHookArray) :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/controller/FrontController.php:633 (exec) /override/classes/controller/FrontController.php:11 (initContent) /controllers/front/listing/CategoryController.php:127 (initContent) /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:00:58' >= sp.from) AND (sp.to = '0000-00-00 00:00:00' OR '2025-04-25 20:00:58' <= 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 (949, 1047, 830, 833))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=2 AND c.nright<=53 GROUP BY p.id_product) p INNER JOIN mmag_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN mmag_specific_price sp_1 ON ( sp_1.id_product = p.id_product AND sp_1.id_shop IN (0, 1) AND sp_1.id_currency IN (0, 1) AND sp_1.id_country IN (0, 36) AND sp_1.id_group IN (0, 1) AND sp_1.from_quantity = 1 AND sp_1.reduction > 0 AND sp_1.id_customer = 0 AND sp_1.id_cart = 0 AND (sp_1.from = '0000-00-00 00:00:00' OR '2025-04-25 20:00:58' >= sp_1.from) AND (sp_1.to = '0000-00-00 00:00:00' OR '2025-04-25 20:00:58' <= sp_1.to) ) LEFT JOIN mmag_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((fp.id_feature=21)) AND ((sp_1.reduction>0)) AND ((fp_2.id_feature_value IN (949, 1047, 830, 833))) GROUP BY fp.id_feature_value	2.193 ms	1764	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)
45	SELECT SQL_NO_CACHE `id_category` FROM `mmag_category_shop` WHERE `id_category` = 2 AND `id_shop` = 1 LIMIT 1	2.181 ms	1			/classes/Category.php:2450 /controllers/front/listing/CategoryController.php:83 (existsInShop) /tools/profiling/Controller.php:41 (init) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
131	SELECT SQL_NO_CACHE fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, pl.name FROM mmag_product p LEFT JOIN mmag_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mmag_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN mmag_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN mmag_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN mmag_product_lang pl ON (p.id_product = pl.id_product AND pl.id_shop = 1 AND pl.id_lang = 1) INNER JOIN mmag_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN mmag_category_product cp ON (p.id_product = cp.id_product) INNER JOIN mmag_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN mmag_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN mmag_specific_price sp ON ( sp.id_product = p.id_product AND sp.id_shop IN (0, 1) AND sp.id_currency IN (0, 1) AND sp.id_country IN (0, 36) AND sp.id_group IN (0, 1) AND sp.from_quantity = 1 AND sp.reduction > 0 AND sp.id_customer = 0 AND sp.id_cart = 0 AND (sp.from = '0000-00-00 00:00:00' OR '2025-04-25 20:00:58' >= sp.from) AND (sp.to = '0000-00-00 00:00:00' OR '2025-04-25 20:00:58' <= 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 (949, 1047, 830, 833))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=2 AND c.nright<=53 GROUP BY p.id_product) p INNER JOIN mmag_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN mmag_specific_price sp_1 ON ( sp_1.id_product = p.id_product AND sp_1.id_shop IN (0, 1) AND sp_1.id_currency IN (0, 1) AND sp_1.id_country IN (0, 36) AND sp_1.id_group IN (0, 1) AND sp_1.from_quantity = 1 AND sp_1.reduction > 0 AND sp_1.id_customer = 0 AND sp_1.id_cart = 0 AND (sp_1.from = '0000-00-00 00:00:00' OR '2025-04-25 20:00:58' >= sp_1.from) AND (sp_1.to = '0000-00-00 00:00:00' OR '2025-04-25 20:00:58' <= sp_1.to) ) LEFT JOIN mmag_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((fp.id_feature=7)) AND ((sp_1.reduction>0)) AND ((fp_2.id_feature_value IN (949, 1047, 830, 833))) GROUP BY fp.id_feature_value	2.113 ms	1764	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)
156	SELECT SQL_NO_CACHE fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, pl.name FROM mmag_product p LEFT JOIN mmag_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mmag_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN mmag_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN mmag_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN mmag_product_lang pl ON (p.id_product = pl.id_product AND pl.id_shop = 1 AND pl.id_lang = 1) INNER JOIN mmag_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN mmag_category_product cp ON (p.id_product = cp.id_product) INNER JOIN mmag_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN mmag_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN mmag_specific_price sp ON ( sp.id_product = p.id_product AND sp.id_shop IN (0, 1) AND sp.id_currency IN (0, 1) AND sp.id_country IN (0, 36) AND sp.id_group IN (0, 1) AND sp.from_quantity = 1 AND sp.reduction > 0 AND sp.id_customer = 0 AND sp.id_cart = 0 AND (sp.from = '0000-00-00 00:00:00' OR '2025-04-25 20:00:58' >= sp.from) AND (sp.to = '0000-00-00 00:00:00' OR '2025-04-25 20:00:58' <= 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 (949, 1047, 830, 833))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=2 AND c.nright<=53 GROUP BY p.id_product) p INNER JOIN mmag_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN mmag_specific_price sp_1 ON ( sp_1.id_product = p.id_product AND sp_1.id_shop IN (0, 1) AND sp_1.id_currency IN (0, 1) AND sp_1.id_country IN (0, 36) AND sp_1.id_group IN (0, 1) AND sp_1.from_quantity = 1 AND sp_1.reduction > 0 AND sp_1.id_customer = 0 AND sp_1.id_cart = 0 AND (sp_1.from = '0000-00-00 00:00:00' OR '2025-04-25 20:00:58' >= sp_1.from) AND (sp_1.to = '0000-00-00 00:00:00' OR '2025-04-25 20:00:58' <= sp_1.to) ) LEFT JOIN mmag_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((fp.id_feature=22)) AND ((sp_1.reduction>0)) AND ((fp_2.id_feature_value IN (949, 1047, 830, 833))) GROUP BY fp.id_feature_value	2.109 ms	1764	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)
158	SELECT SQL_NO_CACHE fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, pl.name FROM mmag_product p LEFT JOIN mmag_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mmag_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN mmag_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN mmag_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN mmag_product_lang pl ON (p.id_product = pl.id_product AND pl.id_shop = 1 AND pl.id_lang = 1) INNER JOIN mmag_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN mmag_category_product cp ON (p.id_product = cp.id_product) INNER JOIN mmag_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN mmag_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN mmag_specific_price sp ON ( sp.id_product = p.id_product AND sp.id_shop IN (0, 1) AND sp.id_currency IN (0, 1) AND sp.id_country IN (0, 36) AND sp.id_group IN (0, 1) AND sp.from_quantity = 1 AND sp.reduction > 0 AND sp.id_customer = 0 AND sp.id_cart = 0 AND (sp.from = '0000-00-00 00:00:00' OR '2025-04-25 20:00:58' >= sp.from) AND (sp.to = '0000-00-00 00:00:00' OR '2025-04-25 20:00:58' <= 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 (949, 1047, 830, 833))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=2 AND c.nright<=53 GROUP BY p.id_product) p INNER JOIN mmag_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN mmag_specific_price sp_1 ON ( sp_1.id_product = p.id_product AND sp_1.id_shop IN (0, 1) AND sp_1.id_currency IN (0, 1) AND sp_1.id_country IN (0, 36) AND sp_1.id_group IN (0, 1) AND sp_1.from_quantity = 1 AND sp_1.reduction > 0 AND sp_1.id_customer = 0 AND sp_1.id_cart = 0 AND (sp_1.from = '0000-00-00 00:00:00' OR '2025-04-25 20:00:58' >= sp_1.from) AND (sp_1.to = '0000-00-00 00:00:00' OR '2025-04-25 20:00:58' <= sp_1.to) ) LEFT JOIN mmag_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((fp.id_feature=23)) AND ((sp_1.reduction>0)) AND ((fp_2.id_feature_value IN (949, 1047, 830, 833))) GROUP BY fp.id_feature_value	2.100 ms	1764	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 fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, pl.name FROM mmag_product p LEFT JOIN mmag_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mmag_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN mmag_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN mmag_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN mmag_product_lang pl ON (p.id_product = pl.id_product AND pl.id_shop = 1 AND pl.id_lang = 1) INNER JOIN mmag_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN mmag_category_product cp ON (p.id_product = cp.id_product) INNER JOIN mmag_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN mmag_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN mmag_specific_price sp ON ( sp.id_product = p.id_product AND sp.id_shop IN (0, 1) AND sp.id_currency IN (0, 1) AND sp.id_country IN (0, 36) AND sp.id_group IN (0, 1) AND sp.from_quantity = 1 AND sp.reduction > 0 AND sp.id_customer = 0 AND sp.id_cart = 0 AND (sp.from = '0000-00-00 00:00:00' OR '2025-04-25 20:00:58' >= sp.from) AND (sp.to = '0000-00-00 00:00:00' OR '2025-04-25 20:00:58' <= 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 (949, 1047, 830, 833))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=2 AND c.nright<=53 GROUP BY p.id_product) p INNER JOIN mmag_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN mmag_specific_price sp_1 ON ( sp_1.id_product = p.id_product AND sp_1.id_shop IN (0, 1) AND sp_1.id_currency IN (0, 1) AND sp_1.id_country IN (0, 36) AND sp_1.id_group IN (0, 1) AND sp_1.from_quantity = 1 AND sp_1.reduction > 0 AND sp_1.id_customer = 0 AND sp_1.id_cart = 0 AND (sp_1.from = '0000-00-00 00:00:00' OR '2025-04-25 20:00:58' >= sp_1.from) AND (sp_1.to = '0000-00-00 00:00:00' OR '2025-04-25 20:00:58' <= sp_1.to) ) LEFT JOIN mmag_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((fp.id_feature=1)) AND ((sp_1.reduction>0)) AND ((fp_2.id_feature_value IN (949, 1047, 830, 833))) GROUP BY fp.id_feature_value	2.084 ms	1764	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:778 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:855 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:154 (getFeaturesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:357 (runQuery) /override/controllers/front/listing/CategoryController.php:22 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
152	SELECT SQL_NO_CACHE fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, pl.name FROM mmag_product p LEFT JOIN mmag_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mmag_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN mmag_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN mmag_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN mmag_product_lang pl ON (p.id_product = pl.id_product AND pl.id_shop = 1 AND pl.id_lang = 1) INNER JOIN mmag_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN mmag_category_product cp ON (p.id_product = cp.id_product) INNER JOIN mmag_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN mmag_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN mmag_specific_price sp ON ( sp.id_product = p.id_product AND sp.id_shop IN (0, 1) AND sp.id_currency IN (0, 1) AND sp.id_country IN (0, 36) AND sp.id_group IN (0, 1) AND sp.from_quantity = 1 AND sp.reduction > 0 AND sp.id_customer = 0 AND sp.id_cart = 0 AND (sp.from = '0000-00-00 00:00:00' OR '2025-04-25 20:00:58' >= sp.from) AND (sp.to = '0000-00-00 00:00:00' OR '2025-04-25 20:00:58' <= 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 (949, 1047, 830, 833))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=2 AND c.nright<=53 GROUP BY p.id_product) p INNER JOIN mmag_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN mmag_specific_price sp_1 ON ( sp_1.id_product = p.id_product AND sp_1.id_shop IN (0, 1) AND sp_1.id_currency IN (0, 1) AND sp_1.id_country IN (0, 36) AND sp_1.id_group IN (0, 1) AND sp_1.from_quantity = 1 AND sp_1.reduction > 0 AND sp_1.id_customer = 0 AND sp_1.id_cart = 0 AND (sp_1.from = '0000-00-00 00:00:00' OR '2025-04-25 20:00:58' >= sp_1.from) AND (sp_1.to = '0000-00-00 00:00:00' OR '2025-04-25 20:00:58' <= sp_1.to) ) LEFT JOIN mmag_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((fp.id_feature=20)) AND ((sp_1.reduction>0)) AND ((fp_2.id_feature_value IN (949, 1047, 830, 833))) GROUP BY fp.id_feature_value	2.073 ms	1764	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)
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:00:58' >= sp.from) AND (sp.to = '0000-00-00 00:00:00' OR '2025-04-25 20:00:58' <= 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 (949, 1047, 830, 833))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=2 AND c.nright<=53 GROUP BY p.id_product) p INNER JOIN mmag_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN mmag_specific_price sp_1 ON ( sp_1.id_product = p.id_product AND sp_1.id_shop IN (0, 1) AND sp_1.id_currency IN (0, 1) AND sp_1.id_country IN (0, 36) AND sp_1.id_group IN (0, 1) AND sp_1.from_quantity = 1 AND sp_1.reduction > 0 AND sp_1.id_customer = 0 AND sp_1.id_cart = 0 AND (sp_1.from = '0000-00-00 00:00:00' OR '2025-04-25 20:00:58' >= sp_1.from) AND (sp_1.to = '0000-00-00 00:00:00' OR '2025-04-25 20:00:58' <= sp_1.to) ) LEFT JOIN mmag_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((fp.id_feature=19)) AND ((sp_1.reduction>0)) AND ((fp_2.id_feature_value IN (949, 1047, 830, 833))) GROUP BY fp.id_feature_value	2.067 ms	1764	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:778 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:855 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:154 (getFeaturesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:357 (runQuery) /override/controllers/front/listing/CategoryController.php:22 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
141	SELECT SQL_NO_CACHE fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, pl.name FROM mmag_product p LEFT JOIN mmag_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mmag_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN mmag_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN mmag_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN mmag_product_lang pl ON (p.id_product = pl.id_product AND pl.id_shop = 1 AND pl.id_lang = 1) INNER JOIN mmag_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN mmag_category_product cp ON (p.id_product = cp.id_product) INNER JOIN mmag_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN mmag_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN mmag_specific_price sp ON ( sp.id_product = p.id_product AND sp.id_shop IN (0, 1) AND sp.id_currency IN (0, 1) AND sp.id_country IN (0, 36) AND sp.id_group IN (0, 1) AND sp.from_quantity = 1 AND sp.reduction > 0 AND sp.id_customer = 0 AND sp.id_cart = 0 AND (sp.from = '0000-00-00 00:00:00' OR '2025-04-25 20:00:58' >= sp.from) AND (sp.to = '0000-00-00 00:00:00' OR '2025-04-25 20:00:58' <= 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 (949, 1047, 830, 833))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=2 AND c.nright<=53 GROUP BY p.id_product) p INNER JOIN mmag_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN mmag_specific_price sp_1 ON ( sp_1.id_product = p.id_product AND sp_1.id_shop IN (0, 1) AND sp_1.id_currency IN (0, 1) AND sp_1.id_country IN (0, 36) AND sp_1.id_group IN (0, 1) AND sp_1.from_quantity = 1 AND sp_1.reduction > 0 AND sp_1.id_customer = 0 AND sp_1.id_cart = 0 AND (sp_1.from = '0000-00-00 00:00:00' OR '2025-04-25 20:00:58' >= sp_1.from) AND (sp_1.to = '0000-00-00 00:00:00' OR '2025-04-25 20:00:58' <= sp_1.to) ) LEFT JOIN mmag_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((fp.id_feature=13)) AND ((sp_1.reduction>0)) AND ((fp_2.id_feature_value IN (949, 1047, 830, 833))) GROUP BY fp.id_feature_value	2.050 ms	1764	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:778 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:855 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:154 (getFeaturesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:357 (runQuery) /override/controllers/front/listing/CategoryController.php:22 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
147	SELECT SQL_NO_CACHE fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, pl.name FROM mmag_product p LEFT JOIN mmag_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mmag_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN mmag_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN mmag_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN mmag_product_lang pl ON (p.id_product = pl.id_product AND pl.id_shop = 1 AND pl.id_lang = 1) INNER JOIN mmag_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN mmag_category_product cp ON (p.id_product = cp.id_product) INNER JOIN mmag_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN mmag_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN mmag_specific_price sp ON ( sp.id_product = p.id_product AND sp.id_shop IN (0, 1) AND sp.id_currency IN (0, 1) AND sp.id_country IN (0, 36) AND sp.id_group IN (0, 1) AND sp.from_quantity = 1 AND sp.reduction > 0 AND sp.id_customer = 0 AND sp.id_cart = 0 AND (sp.from = '0000-00-00 00:00:00' OR '2025-04-25 20:00:58' >= sp.from) AND (sp.to = '0000-00-00 00:00:00' OR '2025-04-25 20:00:58' <= 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 (949, 1047, 830, 833))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=2 AND c.nright<=53 GROUP BY p.id_product) p INNER JOIN mmag_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN mmag_specific_price sp_1 ON ( sp_1.id_product = p.id_product AND sp_1.id_shop IN (0, 1) AND sp_1.id_currency IN (0, 1) AND sp_1.id_country IN (0, 36) AND sp_1.id_group IN (0, 1) AND sp_1.from_quantity = 1 AND sp_1.reduction > 0 AND sp_1.id_customer = 0 AND sp_1.id_cart = 0 AND (sp_1.from = '0000-00-00 00:00:00' OR '2025-04-25 20:00:58' >= sp_1.from) AND (sp_1.to = '0000-00-00 00:00:00' OR '2025-04-25 20:00:58' <= sp_1.to) ) LEFT JOIN mmag_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((fp.id_feature=17)) AND ((sp_1.reduction>0)) AND ((fp_2.id_feature_value IN (949, 1047, 830, 833))) GROUP BY fp.id_feature_value	2.045 ms	1764	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