Inicio

To give you the best possible experience, this site uses cookies. Using your site means your agree to our use of cookies. We have published a new cookies policy, which you should need to find out more about the cookies we use. View Cookies Policy.

Subcategoría

Jaula grande exterior para gatos

Llaveros para eventos

Tumbona plegable

2 mesillas de noche flotantes

Rascador grande

Ventiladores de pie

Butaca con patas

Bloques espuma juguete (escalera/rampa)

Sombrilla de pared (una y media)

Tractor juguete a pedales

Aparador

Tienda de campaña 6-8 personas

Barrera seguridad mascotas

Caseta jardín gato

Jaula pájaros con patas

Conjunto 4 sillas de comedor

Bicicleta-triciclo infantil

Carrito para playa

armario-vitrina auxiliar cocina

Techo para carpas

Pérgola

Rascador mediano + caseta

Mesa plegable cocina con rueda

Cubierta radiador

Invernadero

2 mesitas de noche flotantes

Chimenea con patas

Sofá + cama 2 plazas

Doble pizarra con caballete y acjones infantil

Jaula doble para conejo con patas exterior

Corral metálico mascotas

Espejo baño + armario

Mueble tv + estantería

Juegos equilibrios madera

Marquesina

Carpa con paredes

Jaula pájaros

Cochecito paseo pedales

Ventiladores torre

Sofá-cama-perro

Cama plegable

Mesa auxiliar jardín-balcón

Almacenar juguetes con ruedas

Mueble cocina

Sillón madera jardín

Estantería baja madera

Nevera portátil-eléctrica

Cama elevada perros

Casa conejo

Mesa pequeña jardín

Banco trabajo plegable

Balancín infantil

Tocador adulto

Jaula con patas para pájaros

Carretilla jardín

Roll geotextil

Columna baño

Soporte para saco de boxeo

Canasta baloncesto niño-adulto

Estructura columpio doble jardín

Césped artificial

Carpa pabellón

Peso gazebo

Pérgola techo plegable y paredes plegables

Arenero gato

Carrito tabla de surf

Carpa simple doble

Tienda campaña 2-3 personas

Mesa de comedor de jardín

sillón masaje + taburete

Cama infantil 50 kg 143x73x60cm

Estantería para macetas

Barrera coche perro

Jaula conejos exterior con suelo

Funda mueble exterior

sombrilla reclinable con luces led

Mesita centro jardín balcón

Sombrilla reclinable soporte al lado

Jaula roedores con ruedas

Mueble bajo pica baño

Pedales bicicleta

Jaula pájaros pequeña doble elevada con ruedas

Póker

Sombrilla

Cojín asiento banco jardín

Barbacoa con tapa de sobremesa-Gas

Jaula para pequeños roedores metal ruedas

Tobogán infantil + canasta + columpio

Taburete con ruedas

Conjunto 2 sillas + mesa jardín balcón ratán

Canasta baloncesto-infantil

Mesa auxiliar sofá-cama con ruedas

Lámpara estantería

Columpio

Correpasillos con mango empuje

Espejo de pie

Nevera para cosméticos

pesa rusa

Pesa rusa 12 kg

Pesas Barra + Discos 20 Kg

Pantalla proyector

Cesto ropa

Carritos de cocina metal y plástico

Columna baño con estantes

somier matrimonio con cabezal

Mesa ping pong adulto

Carritos de cocina

Moto batería

Armario ropero de tela

Espejo de pared

Pesas 2 discos (10 kg)

Cortadora papel

Carro para playa

Sombrilla doble con luces led

Mesa auxiliar jardín

Jardinera con enrejado nivel suelo

Diana electrónica

Ducha solar

Biombo

Carpa simple con 2 paredes

Silla plegable baja playa

Splash pad para mascotas

Arenero niños + cocina juguete toldo jardín

Jaula trasportín perro

Andador-caminador gente con dificultad andar

Cama elástica infantil con red

Arenero infantil jardín

Carpa simple con 4 paredes

Toldo pared

Tumbona de madera con ruedas

Jaula perro con ruedas

Gallinero solo corral

Alfombra para terraza

Puente de jardín

Arenero gatos autolimpiable

Armario modular 12 cubos

Bicicleta sin pedales

Escritorio infantil altura ajustable

Conjunto taburetes y mesa alta

Caseta de jardín de tela

Consola recibidor

Baúl banco infantil

Cama alta perro con toldo

Speed Ball montaje pared

Torre aprendizaje niño

sifonier

Escritorio

Jaula para perros exterior

Multiestación musculación

Sillón relax

tumbona sin patas playa

Caballito balancín madera

Caseta jardín

Armario auxiliar

Kit pesas 20 kg (convertible)

Mesa plegable cocina con ruedas y cajones

mesa consola

Cama alta perros

Carritos de cocina metálicos

Sombrilla media pantalla terraza

Cubo basura apertura automática

Caseta gato

Funda protectora sombrilla

Columna baño para pared

Rascador mediano + cama + caseta

Canasta de baloncesto niño-adulto

Sombrilla reclinable

Jaula para gatos

Herramientas, Brico y Automóvil

Sube y baja

Juguetes y Ocio

Conjunto 2 tumbonas ratán

Infantil y Puericultura

Mascotas

Juguetes y Aficiones

Agricultura

Vino, Accesorios de Bebida y Hostelería

Tecnología y Accesorios

Oficina y Negocios

Artículos Sostenibles

Tazas, Jarras y Termos

Cuidado Personal y Pharma

Productos para mascotas

Colección protección higiénica

Ver columna izquierda

productos

Red

Cuadrícula-2

Lista

Lista-2

Catálogo

Ordenar por:

Nuevo

¡En oferta!

71,99 €

Nuevo

¡En oferta!

71,99 €

Nuevo

¡En oferta!

71,99 €

Load Time	2272 ms
Querying Time	1605 ms
Queries	1128
Memory Peak Usage	35.6 Mb
Included Files	1256 files - 14.30 Mb
PrestaShop Cache	- Mb
Global vars	0.23 Mb
- global $_MODULES	209k
- global $_SERVER	8k
- global $config	5k
- global $context	3k
- global $__composer_autoload_files	3k
- global $exportPhpConfigFile	3k
- global $smarty	2k
- global $_ENV	2k
- global $_MODULE	2k

PrestaShop Version	8.2.1
PHP Version	8.1.33
MySQL Version	10.11.13-MariaDB-0ubuntu0.24.04.1
Memory Limit	256M
Max Execution Time	600s
Smarty Cache	enabled
Smarty Compilation	never recompile

	Time	Cumulated Time	Memory Usage	Memory Peak Usage
config	21.242 ms	21.242 ms	2.98 Mb	3.3 Mb
__construct	0.011 ms	21.253 ms	- Mb	3.3 Mb
init	112.780 ms	134.033 ms	3.08 Mb	6.5 Mb
checkAccess	0.001 ms	134.034 ms	- Mb	6.5 Mb
setMedia	8.659 ms	142.693 ms	0.20 Mb	6.5 Mb
postProcess	0.001 ms	142.694 ms	- Mb	6.5 Mb
initHeader	0.001 ms	142.695 ms	- Mb	6.5 Mb
initContent	1058 ms	1200 ms	6.11 Mb	12.5 Mb
initFooter	0.002 ms	1200 ms	- Mb	12.5 Mb
display	1072 ms	2272 ms	21.83 Mb	35.6 Mb

Hook	Time	Memory Usage
DisplayLeftColumn	463.640 ms	5.55 Mb
=> tvcmsnewproducts	387.834 ms	0.89 Mb
=> tvcmscustomerservices	0.881 ms	0.08 Mb
=> tvcmsspecialproducts	2.001 ms	0.10 Mb
=> tvcmsfeaturedproducts	41.302 ms	2.82 Mb
=> tvcmsbestsellerproducts	31.622 ms	1.67 Mb
DisplayAfterBodyOpeningTag	341.042 ms	2.75 Mb
=> tvcmscookiesnotice	0.918 ms	0.02 Mb
=> blockreassurance	0.004 ms	- Mb
=> tvcmsproductpopup	340.120 ms	2.73 Mb
DisplayHeader	187.262 ms	0.56 Mb
=> ps_shoppingcart	0.076 ms	- Mb
=> ps_searchbar	0.927 ms	- Mb
=> ps_imageslider	0.441 ms	- Mb
=> productcomments	0.489 ms	- Mb
=> psxmarketingwithgoogle	3.726 ms	0.01 Mb
=> ps_googleanalytics	1.718 ms	0.02 Mb
=> tvcmsbestsellerproducts	0.163 ms	- Mb
=> tvcmsblog	0.692 ms	- Mb
=> tvcmsblogdisplayposts	0.443 ms	- Mb
=> tvcmsbrandlist	0.339 ms	- Mb
=> tvcmscategorychainslider	0.363 ms	- Mb
=> tvcmscategoryslider	0.349 ms	- Mb
=> tvcmscookiesnotice	0.339 ms	- Mb
=> tvcmscustomerservices	0.341 ms	- Mb
=> tvcmscustomsetting	2.188 ms	0.01 Mb
=> tvcmsfeaturedproducts	0.152 ms	- Mb
=> tvcmsfooterlogo	0.001 ms	- Mb
=> tvcmsfooterproduct	0.146 ms	- Mb
=> tvcmsnewproducts	0.140 ms	- Mb
=> tvcmsnewsletterpopup	0.688 ms	- Mb
=> tvcmspaymenticon	0.002 ms	- Mb
=> tvcmsproductcomments	1.416 ms	- Mb
=> tvcmsproductcompare	0.355 ms	- Mb
=> tvcmsproductpopup	0.335 ms	- Mb
=> tvcmssearch	0.958 ms	- Mb
=> tvcmssizechart	0.416 ms	- Mb
=> tvcmsslider	0.362 ms	- Mb
=> tvcmsspecialproducts	0.135 ms	- Mb
=> tvcmsstoretime	0.357 ms	- Mb
=> tvcmstabproducts	0.405 ms	- Mb
=> tvcmstestimonial	0.354 ms	- Mb
=> tvcmsthemeoptions	1.039 ms	- Mb
=> tvcmsvideoblock	0.360 ms	- Mb
=> tvcmswishlist	0.374 ms	- Mb
=> smartargetwhatsapp	0.857 ms	0.01 Mb
=> ps_facebook	165.815 ms	0.45 Mb
DisplayReviewProductList	47.812 ms	3.77 Mb
=> tvcmsproductcomments	1.473 ms	0.12 Mb
=> tvcmsproductcomments	0.981 ms	0.07 Mb
=> tvcmsproductcomments	0.960 ms	0.07 Mb
=> tvcmsproductcomments	0.898 ms	0.07 Mb
=> tvcmsproductcomments	1.121 ms	0.11 Mb
=> tvcmsproductcomments	0.939 ms	0.07 Mb
=> tvcmsproductcomments	0.932 ms	0.07 Mb
=> tvcmsproductcomments	0.883 ms	0.06 Mb
=> tvcmsproductcomments	1.086 ms	0.11 Mb
=> tvcmsproductcomments	0.929 ms	0.07 Mb
=> tvcmsproductcomments	0.926 ms	0.07 Mb
=> tvcmsproductcomments	0.882 ms	0.06 Mb
=> tvcmsproductcomments	1.115 ms	0.11 Mb
=> tvcmsproductcomments	0.941 ms	0.07 Mb
=> tvcmsproductcomments	1.021 ms	0.07 Mb
=> tvcmsproductcomments	0.924 ms	0.06 Mb
=> tvcmsproductcomments	1.100 ms	0.11 Mb
=> tvcmsproductcomments	0.947 ms	0.07 Mb
=> tvcmsproductcomments	0.939 ms	0.07 Mb
=> tvcmsproductcomments	0.915 ms	0.06 Mb
=> tvcmsproductcomments	1.098 ms	0.11 Mb
=> tvcmsproductcomments	0.938 ms	0.07 Mb
=> tvcmsproductcomments	0.952 ms	0.07 Mb
=> tvcmsproductcomments	0.893 ms	0.06 Mb
=> tvcmsproductcomments	1.089 ms	0.14 Mb
=> tvcmsproductcomments	1.089 ms	0.07 Mb
=> tvcmsproductcomments	0.997 ms	0.07 Mb
=> tvcmsproductcomments	0.887 ms	0.06 Mb
=> tvcmsproductcomments	1.222 ms	0.11 Mb
=> tvcmsproductcomments	0.942 ms	0.07 Mb
=> tvcmsproductcomments	0.957 ms	0.07 Mb
=> tvcmsproductcomments	0.991 ms	0.06 Mb
=> tvcmsproductcomments	1.209 ms	0.11 Mb
=> tvcmsproductcomments	0.937 ms	0.07 Mb
=> tvcmsproductcomments	0.922 ms	0.07 Mb
=> tvcmsproductcomments	0.911 ms	0.06 Mb
=> tvcmsproductcomments	1.202 ms	0.11 Mb
=> tvcmsproductcomments	0.940 ms	0.07 Mb
=> tvcmsproductcomments	0.935 ms	0.07 Mb
=> tvcmsproductcomments	0.938 ms	0.06 Mb
=> tvcmsproductcomments	1.147 ms	0.11 Mb
=> tvcmsproductcomments	0.989 ms	0.07 Mb
=> tvcmsproductcomments	1.013 ms	0.07 Mb
=> tvcmsproductcomments	0.914 ms	0.06 Mb
=> tvcmsproductcomments	1.079 ms	0.11 Mb
=> tvcmsproductcomments	0.916 ms	0.07 Mb
=> tvcmsproductcomments	0.894 ms	0.07 Mb
=> tvcmsproductcomments	0.899 ms	0.06 Mb
DisplayWishlistBtnProductList	29.073 ms	- Mb
=> tvcmswishlist	0.860 ms	0.01 Mb
=> tvcmswishlist	0.586 ms	- Mb
=> tvcmswishlist	0.606 ms	- Mb
=> tvcmswishlist	0.603 ms	- Mb
=> tvcmswishlist	0.605 ms	- Mb
=> tvcmswishlist	0.662 ms	- Mb
=> tvcmswishlist	0.598 ms	- Mb
=> tvcmswishlist	0.583 ms	- Mb
=> tvcmswishlist	0.617 ms	- Mb
=> tvcmswishlist	0.596 ms	- Mb
=> tvcmswishlist	0.595 ms	- Mb
=> tvcmswishlist	0.711 ms	- Mb
=> tvcmswishlist	0.603 ms	- Mb
=> tvcmswishlist	0.587 ms	- Mb
=> tvcmswishlist	0.584 ms	- Mb
=> tvcmswishlist	0.582 ms	- Mb
=> tvcmswishlist	0.590 ms	- Mb
=> tvcmswishlist	0.600 ms	- Mb
=> tvcmswishlist	0.594 ms	- Mb
=> tvcmswishlist	0.579 ms	- Mb
=> tvcmswishlist	0.644 ms	- Mb
=> tvcmswishlist	0.597 ms	- Mb
=> tvcmswishlist	0.583 ms	- Mb
=> tvcmswishlist	0.581 ms	- Mb
=> tvcmswishlist	0.593 ms	- Mb
=> tvcmswishlist	0.581 ms	- Mb
=> tvcmswishlist	0.595 ms	- Mb
=> tvcmswishlist	0.589 ms	- Mb
=> tvcmswishlist	0.600 ms	- Mb
=> tvcmswishlist	0.582 ms	- Mb
=> tvcmswishlist	0.580 ms	- Mb
=> tvcmswishlist	0.639 ms	- Mb
=> tvcmswishlist	0.597 ms	- Mb
=> tvcmswishlist	0.580 ms	- Mb
=> tvcmswishlist	0.598 ms	- Mb
=> tvcmswishlist	0.580 ms	- Mb
=> tvcmswishlist	0.586 ms	- Mb
=> tvcmswishlist	0.599 ms	- Mb
=> tvcmswishlist	0.607 ms	- Mb
=> tvcmswishlist	0.622 ms	- Mb
=> tvcmswishlist	0.597 ms	- Mb
=> tvcmswishlist	0.597 ms	- Mb
=> tvcmswishlist	0.592 ms	- Mb
=> tvcmswishlist	0.611 ms	- Mb
=> tvcmswishlist	0.607 ms	- Mb
=> tvcmswishlist	0.604 ms	- Mb
=> tvcmswishlist	0.596 ms	- Mb
=> tvcmswishlist	0.594 ms	- Mb
DisplayProductCompareProductList	27.971 ms	0.10 Mb
=> tvcmsproductcompare	0.869 ms	0.01 Mb
=> tvcmsproductcompare	0.588 ms	- Mb
=> tvcmsproductcompare	0.579 ms	- Mb
=> tvcmsproductcompare	0.572 ms	- Mb
=> tvcmsproductcompare	0.589 ms	- Mb
=> tvcmsproductcompare	0.591 ms	- Mb
=> tvcmsproductcompare	0.570 ms	- Mb
=> tvcmsproductcompare	0.584 ms	- Mb
=> tvcmsproductcompare	0.579 ms	- Mb
=> tvcmsproductcompare	0.563 ms	- Mb
=> tvcmsproductcompare	0.529 ms	- Mb
=> tvcmsproductcompare	0.578 ms	- Mb
=> tvcmsproductcompare	0.602 ms	- Mb
=> tvcmsproductcompare	0.648 ms	- Mb
=> tvcmsproductcompare	0.648 ms	- Mb
=> tvcmsproductcompare	0.582 ms	- Mb
=> tvcmsproductcompare	0.587 ms	- Mb
=> tvcmsproductcompare	0.562 ms	- Mb
=> tvcmsproductcompare	0.516 ms	- Mb
=> tvcmsproductcompare	0.574 ms	- Mb
=> tvcmsproductcompare	0.588 ms	- Mb
=> tvcmsproductcompare	0.585 ms	- Mb
=> tvcmsproductcompare	0.540 ms	- Mb
=> tvcmsproductcompare	0.583 ms	- Mb
=> tvcmsproductcompare	0.566 ms	- Mb
=> tvcmsproductcompare	0.579 ms	- Mb
=> tvcmsproductcompare	0.513 ms	- Mb
=> tvcmsproductcompare	0.578 ms	- Mb
=> tvcmsproductcompare	0.631 ms	- Mb
=> tvcmsproductcompare	0.593 ms	- Mb
=> tvcmsproductcompare	0.541 ms	- Mb
=> tvcmsproductcompare	0.576 ms	- Mb
=> tvcmsproductcompare	0.592 ms	- Mb
=> tvcmsproductcompare	0.594 ms	- Mb
=> tvcmsproductcompare	0.513 ms	- Mb
=> tvcmsproductcompare	0.579 ms	- Mb
=> tvcmsproductcompare	0.623 ms	- Mb
=> tvcmsproductcompare	0.579 ms	- Mb
=> tvcmsproductcompare	0.541 ms	- Mb
=> tvcmsproductcompare	0.584 ms	- Mb
=> tvcmsproductcompare	0.579 ms	- Mb
=> tvcmsproductcompare	0.581 ms	- Mb
=> tvcmsproductcompare	0.538 ms	- Mb
=> tvcmsproductcompare	0.578 ms	- Mb
=> tvcmsproductcompare	0.635 ms	- Mb
=> tvcmsproductcompare	0.566 ms	- Mb
=> tvcmsproductcompare	0.518 ms	- Mb
=> tvcmsproductcompare	0.589 ms	- Mb
displayLeftColumn	23.083 ms	1.96 Mb
=> ps_categorytree (widget)	18.766 ms	1.82 Mb
=> ps_brandlist (widget)	2.237 ms	0.07 Mb
=> ps_supplierlist (widget)	2.080 ms	0.07 Mb
DisplayProductListStockIndicator	10.269 ms	0.68 Mb
=> tvcmsstockinfo	0.833 ms	0.03 Mb
=> tvcmsstockinfo	0.316 ms	0.01 Mb
=> tvcmsstockinfo	0.530 ms	0.05 Mb
=> tvcmsstockinfo	0.515 ms	0.05 Mb
=> tvcmsstockinfo	0.290 ms	0.01 Mb
=> tvcmsstockinfo	0.285 ms	0.01 Mb
=> tvcmsstockinfo	0.524 ms	0.05 Mb
=> tvcmsstockinfo	0.528 ms	0.05 Mb
=> tvcmsstockinfo	0.290 ms	0.01 Mb
=> tvcmsstockinfo	0.284 ms	0.01 Mb
=> tvcmsstockinfo	0.516 ms	0.05 Mb
=> tvcmsstockinfo	0.501 ms	0.05 Mb
=> tvcmsstockinfo	0.309 ms	0.01 Mb
=> tvcmsstockinfo	0.282 ms	0.01 Mb
=> tvcmsstockinfo	0.544 ms	0.05 Mb
=> tvcmsstockinfo	0.513 ms	0.05 Mb
=> tvcmsstockinfo	0.304 ms	0.01 Mb
=> tvcmsstockinfo	0.282 ms	0.01 Mb
=> tvcmsstockinfo	0.502 ms	0.05 Mb
=> tvcmsstockinfo	0.499 ms	0.05 Mb
=> tvcmsstockinfo	0.299 ms	0.01 Mb
=> tvcmsstockinfo	0.289 ms	0.01 Mb
=> tvcmsstockinfo	0.532 ms	0.05 Mb
=> tvcmsstockinfo	0.502 ms	0.05 Mb
DisplayMegamenu	7.926 ms	0.68 Mb
=> tvcmsmegamenu	7.926 ms	0.68 Mb
DisplayNavSearchBlock	6.253 ms	1.48 Mb
=> tvcmssearch	6.253 ms	1.48 Mb
DisplayFooter	4.147 ms	0.14 Mb
=> blockwishlist	3.250 ms	0.13 Mb
=> ps_facebook	0.897 ms	0.01 Mb
Header	3.961 ms	0.11 Mb
=> tvcmsstockinfo	0.458 ms	- Mb
=> tvcmsinfinitescroll	2.351 ms	0.05 Mb
=> tvcmscategoryproduct	0.415 ms	0.02 Mb
=> tvcmsmegamenu	0.382 ms	0.02 Mb
=> tvcmstwoofferbanner	0.355 ms	0.02 Mb
DisplayCustomsocialblock	3.630 ms	0.16 Mb
=> tvcmscustomsetting	3.630 ms	0.16 Mb
DisplayBeforeBodyClosingTag	3.240 ms	0.16 Mb
=> statsdata	3.237 ms	0.16 Mb
=> tvcmsblog	0.003 ms	- Mb
ActionFrontControllerSetMedia	2.404 ms	0.01 Mb
=> blockreassurance	0.647 ms	- Mb
=> blockwishlist	0.578 ms	- Mb
=> ps_emailsubscription	0.150 ms	- Mb
=> ps_socialfollow	0.228 ms	- Mb
=> psxdesign	0.526 ms	- Mb
=> klaviyopsautomation	0.006 ms	- Mb
=> ps_emailalerts	0.113 ms	- Mb
=> monei	0.004 ms	- Mb
=> ps_facebook	0.152 ms	- Mb
displayFooterPart1	2.095 ms	0.09 Mb
=> ps_linklist (widget)	2.095 ms	0.09 Mb
displaySocialMediaBlock	2.073 ms	0.09 Mb
=> ps_socialfollow (widget)	2.073 ms	0.09 Mb
displayNewslettersubscription	1.972 ms	0.09 Mb
=> ps_emailsubscription (widget)	1.972 ms	0.09 Mb
displayMyaccountcblock	1.970 ms	0.09 Mb
=> ps_customeraccountlinks (widget)	1.970 ms	0.09 Mb
ProductSearchProvider	1.846 ms	0.03 Mb
=> ps_facetedsearch	1.846 ms	0.03 Mb
DisplayPaymentIcon	1.357 ms	0.04 Mb
=> tvcmspaymenticon	1.357 ms	0.04 Mb
displayNav1	1.357 ms	0.09 Mb
=> ps_contactinfo (widget)	1.357 ms	0.09 Mb
DisplayNavWishlistBlock	1.233 ms	0.04 Mb
=> tvcmswishlist	1.233 ms	0.04 Mb
DisplayNavWishlistBlocksticky	1.223 ms	0.05 Mb
=> tvcmswishlist	1.223 ms	0.05 Mb
displayNavShoppingCartBlock	1.165 ms	0.09 Mb
=> ps_shoppingcart (widget)	1.165 ms	0.09 Mb
displayNavCustomerSignInBlock	0.924 ms	0.05 Mb
=> ps_customersignin (widget)	0.924 ms	0.05 Mb
DisplayDownloadApps	0.907 ms	0.02 Mb
=> tvcmscustomsetting	0.907 ms	0.02 Mb
DisplayNavProductCompareBlock	0.888 ms	0.01 Mb
=> tvcmsproductcompare	0.888 ms	0.01 Mb
displayContactCinfo	0.883 ms	0.03 Mb
=> ps_contactinfo (widget)	0.883 ms	0.03 Mb
DisplayProductComparesticky	0.876 ms	0.01 Mb
=> tvcmsproductcompare	0.876 ms	0.01 Mb
DisplayAfterTitleTag	0.823 ms	0.01 Mb
=> psxdesign	0.823 ms	0.01 Mb
DisplayCopyRightText	0.814 ms	0.01 Mb
=> tvcmscustomsetting	0.814 ms	0.01 Mb
ActionDispatcherBefore	0.677 ms	0.01 Mb
=> psxdesign	0.276 ms	- Mb
=> ps_mbo	0.401 ms	0.01 Mb
DisplayFacetedSearchBlock	0.670 ms	0.09 Mb
=> ps_facetedsearch	0.670 ms	0.09 Mb
displayNavLanguageBlock	0.294 ms	0.05 Mb
=> ps_languageselector (widget)	0.294 ms	0.05 Mb
displayNavCurrencyBlock	0.265 ms	0.05 Mb
=> ps_currencyselector (widget)	0.265 ms	0.05 Mb
ModuleRoutes	0.042 ms	0.01 Mb
=> klaviyopsautomation	0.005 ms	- Mb
=> tvcmsblog	0.036 ms	0.01 Mb
=> simpleimportproduct	0.001 ms	- Mb
DisplayTopOfferText	0.015 ms	- Mb
=> tvcmscustomsetting	0.011 ms	- Mb
=> tvcmscustomsetting	0.004 ms	- Mb
DisplayCustomJs	0.008 ms	- Mb
=> tvcmscustomcssjs	0.008 ms	- Mb
DisplayCustomCss	0.006 ms	- Mb
=> tvcmscustomcssjs	0.006 ms	- Mb
DisplayNavFullWidth	0.005 ms	- Mb
=> blockreassurance	0.005 ms	- Mb
ActionFrontControllerInitAfter	0.003 ms	- Mb
=> klaviyopsautomation	0.003 ms	- Mb
42 hook(s)	1186 ms	19.11 Mb

Module	Time	Memory Usage
klaviyopsautomation	1.497 ms	- Mb
__construct	1.476 ms	- Mb
hookModuleRoutes	0.008 ms	- Mb
hookActionFrontControllerInitAfter	0.006 ms	- Mb
hookActionFrontControllerSetMedia	0.007 ms	- Mb
tvcmsblog	5.525 ms	0.19 Mb
__construct	4.788 ms	0.18 Mb
hookModuleRoutes	0.038 ms	0.01 Mb
hookDisplayHeader	0.694 ms	- Mb
hookDisplayBeforeBodyClosingTag	0.005 ms	- Mb
simpleimportproduct	0.841 ms	0.03 Mb
__construct	0.838 ms	0.02 Mb
hookModuleRoutes	0.003 ms	- Mb
psxdesign	4.846 ms	0.03 Mb
__construct	3.215 ms	0.01 Mb
hookActionDispatcherBefore	0.278 ms	- Mb
hookActionFrontControllerSetMedia	0.527 ms	- Mb
hookDisplayAfterTitleTag	0.826 ms	0.01 Mb
ps_mbo	9.762 ms	0.05 Mb
__construct	9.359 ms	0.04 Mb
hookActionDispatcherBefore	0.403 ms	0.01 Mb
blockreassurance	1.323 ms	0.09 Mb
__construct	0.662 ms	0.08 Mb
hookActionFrontControllerSetMedia	0.650 ms	0.01 Mb
hookDisplayAfterBodyOpeningTag	0.005 ms	- Mb
hookDisplayNavFullWidth	0.006 ms	- Mb
blockwishlist	4.005 ms	0.14 Mb
__construct	0.173 ms	0.01 Mb
hookActionFrontControllerSetMedia	0.580 ms	- Mb
hookDisplayFooter	3.252 ms	0.13 Mb
ps_emailsubscription	2.240 ms	0.10 Mb
__construct	0.116 ms	0.01 Mb
hookActionFrontControllerSetMedia	0.151 ms	- Mb
displayNewslettersubscription	1.973 ms	0.09 Mb
ps_socialfollow	2.408 ms	0.10 Mb
__construct	0.103 ms	0.01 Mb
hookActionFrontControllerSetMedia	0.229 ms	- Mb
displaySocialMediaBlock	2.076 ms	0.09 Mb
ps_emailalerts	0.311 ms	0.01 Mb
__construct	0.197 ms	0.01 Mb
hookActionFrontControllerSetMedia	0.114 ms	- Mb
monei	0.800 ms	0.07 Mb
__construct	0.795 ms	0.06 Mb
hookActionFrontControllerSetMedia	0.005 ms	- Mb
ps_facebook	169.299 ms	0.46 Mb
__construct	2.428 ms	- Mb
hookActionFrontControllerSetMedia	0.154 ms	- Mb
hookDisplayHeader	165.819 ms	0.45 Mb
hookDisplayFooter	0.898 ms	0.01 Mb
ps_shoppingcart	1.362 ms	0.10 Mb
__construct	0.117 ms	0.01 Mb
hookDisplayHeader	0.078 ms	- Mb
displayNavShoppingCartBlock	1.167 ms	0.09 Mb
ps_searchbar	1.116 ms	0.01 Mb
__construct	0.188 ms	0.01 Mb
hookDisplayHeader	0.928 ms	- Mb
ps_imageslider	0.656 ms	0.01 Mb
__construct	0.213 ms	0.01 Mb
hookDisplayHeader	0.443 ms	- Mb
productcomments	0.598 ms	0.07 Mb
__construct	0.108 ms	0.07 Mb
hookDisplayHeader	0.490 ms	- Mb
psxmarketingwithgoogle	4.128 ms	0.01 Mb
__construct	0.400 ms	0.01 Mb
hookDisplayHeader	3.728 ms	0.01 Mb
ps_googleanalytics	1.880 ms	0.03 Mb
__construct	0.160 ms	0.01 Mb
hookDisplayHeader	1.720 ms	0.02 Mb
tvcmsbestsellerproducts	32.236 ms	1.68 Mb
__construct	0.445 ms	0.01 Mb
hookDisplayHeader	0.165 ms	- Mb
hookDisplayLeftColumn	31.626 ms	1.67 Mb
tvcmsblogdisplayposts	0.924 ms	0.01 Mb
__construct	0.480 ms	0.01 Mb
hookDisplayHeader	0.444 ms	- Mb
tvcmsbrandlist	0.777 ms	0.01 Mb
__construct	0.437 ms	0.01 Mb
hookDisplayHeader	0.340 ms	- Mb
tvcmscategorychainslider	0.802 ms	0.01 Mb
__construct	0.437 ms	0.01 Mb
hookDisplayHeader	0.365 ms	- Mb
tvcmscategoryslider	0.748 ms	0.01 Mb
__construct	0.398 ms	0.01 Mb
hookDisplayHeader	0.350 ms	- Mb
tvcmscookiesnotice	1.651 ms	0.03 Mb
__construct	0.390 ms	0.01 Mb
hookDisplayHeader	0.341 ms	- Mb
hookDisplayAfterBodyOpeningTag	0.920 ms	0.02 Mb
tvcmscustomerservices	1.626 ms	0.09 Mb
__construct	0.400 ms	0.01 Mb
hookDisplayHeader	0.343 ms	- Mb
hookDisplayLeftColumn	0.883 ms	0.08 Mb
tvcmscustomsetting	8.094 ms	0.22 Mb
__construct	0.528 ms	0.01 Mb
hookDisplayHeader	2.190 ms	0.01 Mb
hookDisplayTopOfferText	0.013 ms	- Mb
hookDisplayTopOfferText	0.007 ms	- Mb
hookDisplayDownloadApps	0.909 ms	0.02 Mb
hookDisplayCustomsocialblock	3.632 ms	0.16 Mb
hookDisplayCopyRightText	0.815 ms	0.01 Mb
tvcmsfeaturedproducts	41.851 ms	2.82 Mb
__construct	0.391 ms	0.01 Mb
hookDisplayHeader	0.154 ms	- Mb
hookDisplayLeftColumn	41.306 ms	2.82 Mb
tvcmsfooterlogo	0.392 ms	0.01 Mb
__construct	0.390 ms	0.01 Mb
hookDisplayHeader	0.002 ms	- Mb
tvcmsfooterproduct	0.529 ms	0.01 Mb
__construct	0.381 ms	0.01 Mb
hookDisplayHeader	0.148 ms	- Mb
tvcmsnewproducts	388.324 ms	0.89 Mb
__construct	0.345 ms	0.01 Mb
hookDisplayHeader	0.142 ms	- Mb
hookDisplayLeftColumn	387.837 ms	0.89 Mb
tvcmsnewsletterpopup	1.115 ms	0.01 Mb
__construct	0.426 ms	0.01 Mb
hookDisplayHeader	0.689 ms	- Mb
tvcmspaymenticon	1.769 ms	0.05 Mb
__construct	0.407 ms	0.01 Mb
hookDisplayHeader	0.003 ms	- Mb
hookDisplayPaymentIcon	1.359 ms	0.04 Mb
tvcmsproductcomments	49.756 ms	3.80 Mb
__construct	0.430 ms	0.01 Mb
hookDisplayHeader	1.418 ms	- Mb
hookDisplayReviewProductList	1.475 ms	0.12 Mb
hookDisplayReviewProductList	0.983 ms	0.07 Mb
hookDisplayReviewProductList	0.962 ms	0.07 Mb
hookDisplayReviewProductList	0.900 ms	0.07 Mb
hookDisplayReviewProductList	1.123 ms	0.11 Mb
hookDisplayReviewProductList	0.941 ms	0.07 Mb
hookDisplayReviewProductList	0.934 ms	0.07 Mb
hookDisplayReviewProductList	0.885 ms	0.06 Mb
hookDisplayReviewProductList	1.088 ms	0.11 Mb
hookDisplayReviewProductList	0.931 ms	0.07 Mb
hookDisplayReviewProductList	0.928 ms	0.07 Mb
hookDisplayReviewProductList	0.884 ms	0.06 Mb
hookDisplayReviewProductList	1.118 ms	0.11 Mb
hookDisplayReviewProductList	0.943 ms	0.07 Mb
hookDisplayReviewProductList	1.023 ms	0.07 Mb
hookDisplayReviewProductList	0.926 ms	0.06 Mb
hookDisplayReviewProductList	1.103 ms	0.11 Mb
hookDisplayReviewProductList	0.949 ms	0.07 Mb
hookDisplayReviewProductList	0.941 ms	0.07 Mb
hookDisplayReviewProductList	0.916 ms	0.06 Mb
hookDisplayReviewProductList	1.100 ms	0.11 Mb
hookDisplayReviewProductList	0.940 ms	0.07 Mb
hookDisplayReviewProductList	0.954 ms	0.07 Mb
hookDisplayReviewProductList	0.895 ms	0.06 Mb
hookDisplayReviewProductList	1.091 ms	0.14 Mb
hookDisplayReviewProductList	1.091 ms	0.07 Mb
hookDisplayReviewProductList	0.998 ms	0.07 Mb
hookDisplayReviewProductList	0.889 ms	0.06 Mb
hookDisplayReviewProductList	1.224 ms	0.11 Mb
hookDisplayReviewProductList	0.944 ms	0.07 Mb
hookDisplayReviewProductList	0.959 ms	0.07 Mb
hookDisplayReviewProductList	0.993 ms	0.06 Mb
hookDisplayReviewProductList	1.211 ms	0.11 Mb
hookDisplayReviewProductList	0.939 ms	0.07 Mb
hookDisplayReviewProductList	0.924 ms	0.07 Mb
hookDisplayReviewProductList	0.913 ms	0.06 Mb
hookDisplayReviewProductList	1.204 ms	0.11 Mb
hookDisplayReviewProductList	0.942 ms	0.07 Mb
hookDisplayReviewProductList	0.937 ms	0.07 Mb
hookDisplayReviewProductList	0.940 ms	0.06 Mb
hookDisplayReviewProductList	1.149 ms	0.11 Mb
hookDisplayReviewProductList	0.991 ms	0.07 Mb
hookDisplayReviewProductList	1.015 ms	0.07 Mb
hookDisplayReviewProductList	0.916 ms	0.06 Mb
hookDisplayReviewProductList	1.081 ms	0.11 Mb
hookDisplayReviewProductList	0.917 ms	0.07 Mb
hookDisplayReviewProductList	0.896 ms	0.07 Mb
hookDisplayReviewProductList	0.901 ms	0.06 Mb
tvcmsproductcompare	30.528 ms	0.14 Mb
__construct	0.334 ms	0.01 Mb
hookDisplayHeader	0.357 ms	- Mb
hookDisplayNavProductCompareBlock	0.890 ms	0.01 Mb
hookDisplayProductCompareProductList	0.871 ms	0.01 Mb
hookDisplayProductCompareProductList	0.590 ms	- Mb
hookDisplayProductCompareProductList	0.581 ms	- Mb
hookDisplayProductCompareProductList	0.574 ms	- Mb
hookDisplayProductCompareProductList	0.591 ms	- Mb
hookDisplayProductCompareProductList	0.593 ms	- Mb
hookDisplayProductCompareProductList	0.573 ms	- Mb
hookDisplayProductCompareProductList	0.586 ms	- Mb
hookDisplayProductCompareProductList	0.581 ms	- Mb
hookDisplayProductCompareProductList	0.565 ms	- Mb
hookDisplayProductCompareProductList	0.531 ms	- Mb
hookDisplayProductCompareProductList	0.580 ms	- Mb
hookDisplayProductCompareProductList	0.605 ms	- Mb
hookDisplayProductCompareProductList	0.650 ms	- Mb
hookDisplayProductCompareProductList	0.650 ms	- Mb
hookDisplayProductCompareProductList	0.584 ms	- Mb
hookDisplayProductCompareProductList	0.589 ms	- Mb
hookDisplayProductCompareProductList	0.563 ms	- Mb
hookDisplayProductCompareProductList	0.518 ms	- Mb
hookDisplayProductCompareProductList	0.576 ms	- Mb
hookDisplayProductCompareProductList	0.590 ms	- Mb
hookDisplayProductCompareProductList	0.587 ms	- Mb
hookDisplayProductCompareProductList	0.542 ms	- Mb
hookDisplayProductCompareProductList	0.585 ms	- Mb
hookDisplayProductCompareProductList	0.568 ms	- Mb
hookDisplayProductCompareProductList	0.581 ms	- Mb
hookDisplayProductCompareProductList	0.515 ms	- Mb
hookDisplayProductCompareProductList	0.580 ms	- Mb
hookDisplayProductCompareProductList	0.633 ms	- Mb
hookDisplayProductCompareProductList	0.595 ms	- Mb
hookDisplayProductCompareProductList	0.543 ms	- Mb
hookDisplayProductCompareProductList	0.578 ms	- Mb
hookDisplayProductCompareProductList	0.595 ms	- Mb
hookDisplayProductCompareProductList	0.596 ms	- Mb
hookDisplayProductCompareProductList	0.514 ms	- Mb
hookDisplayProductCompareProductList	0.581 ms	- Mb
hookDisplayProductCompareProductList	0.625 ms	- Mb
hookDisplayProductCompareProductList	0.580 ms	- Mb
hookDisplayProductCompareProductList	0.543 ms	- Mb
hookDisplayProductCompareProductList	0.586 ms	- Mb
hookDisplayProductCompareProductList	0.581 ms	- Mb
hookDisplayProductCompareProductList	0.583 ms	- Mb
hookDisplayProductCompareProductList	0.539 ms	- Mb
hookDisplayProductCompareProductList	0.580 ms	- Mb
hookDisplayProductCompareProductList	0.638 ms	- Mb
hookDisplayProductCompareProductList	0.568 ms	- Mb
hookDisplayProductCompareProductList	0.520 ms	- Mb
hookDisplayProductCompareProductList	0.591 ms	- Mb
hookDisplayProductComparesticky	0.878 ms	0.01 Mb
tvcmsproductpopup	340.570 ms	2.74 Mb
__construct	0.110 ms	0.01 Mb
hookDisplayHeader	0.336 ms	- Mb
hookDisplayAfterBodyOpeningTag	340.124 ms	2.73 Mb
tvcmssearch	7.554 ms	1.49 Mb
__construct	0.339 ms	0.01 Mb
hookDisplayHeader	0.960 ms	- Mb
hookDisplayNavSearchBlock	6.255 ms	1.48 Mb
tvcmssizechart	0.787 ms	0.01 Mb
__construct	0.369 ms	0.01 Mb
hookDisplayHeader	0.418 ms	- Mb
tvcmsslider	0.767 ms	0.01 Mb
__construct	0.403 ms	0.01 Mb
hookDisplayHeader	0.364 ms	- Mb
tvcmsspecialproducts	2.499 ms	0.11 Mb
__construct	0.358 ms	0.01 Mb
hookDisplayHeader	0.137 ms	- Mb
hookDisplayLeftColumn	2.004 ms	0.10 Mb
tvcmsstockinfo	11.102 ms	0.70 Mb
__construct	0.327 ms	0.01 Mb
hookHeader	0.460 ms	- Mb
hookDisplayProductListStockIndicator	0.835 ms	0.03 Mb
hookDisplayProductListStockIndicator	0.318 ms	0.01 Mb
hookDisplayProductListStockIndicator	0.532 ms	0.05 Mb
hookDisplayProductListStockIndicator	0.517 ms	0.05 Mb
hookDisplayProductListStockIndicator	0.292 ms	0.01 Mb
hookDisplayProductListStockIndicator	0.287 ms	0.01 Mb
hookDisplayProductListStockIndicator	0.526 ms	0.05 Mb
hookDisplayProductListStockIndicator	0.530 ms	0.05 Mb
hookDisplayProductListStockIndicator	0.291 ms	0.01 Mb
hookDisplayProductListStockIndicator	0.286 ms	0.01 Mb
hookDisplayProductListStockIndicator	0.518 ms	0.05 Mb
hookDisplayProductListStockIndicator	0.503 ms	0.05 Mb
hookDisplayProductListStockIndicator	0.311 ms	0.01 Mb
hookDisplayProductListStockIndicator	0.283 ms	0.01 Mb
hookDisplayProductListStockIndicator	0.546 ms	0.05 Mb
hookDisplayProductListStockIndicator	0.515 ms	0.05 Mb
hookDisplayProductListStockIndicator	0.306 ms	0.01 Mb
hookDisplayProductListStockIndicator	0.284 ms	0.01 Mb
hookDisplayProductListStockIndicator	0.504 ms	0.05 Mb
hookDisplayProductListStockIndicator	0.501 ms	0.05 Mb
hookDisplayProductListStockIndicator	0.301 ms	0.01 Mb
hookDisplayProductListStockIndicator	0.291 ms	0.01 Mb
hookDisplayProductListStockIndicator	0.534 ms	0.05 Mb
hookDisplayProductListStockIndicator	0.504 ms	0.05 Mb
tvcmsstoretime	0.722 ms	0.01 Mb
__construct	0.364 ms	- Mb
hookDisplayHeader	0.358 ms	- Mb
tvcmstabproducts	0.737 ms	0.01 Mb
__construct	0.330 ms	0.01 Mb
hookDisplayHeader	0.407 ms	- Mb
tvcmstestimonial	0.764 ms	0.01 Mb
__construct	0.409 ms	0.01 Mb
hookDisplayHeader	0.355 ms	- Mb
tvcmsthemeoptions	1.415 ms	0.01 Mb
__construct	0.374 ms	0.01 Mb
hookDisplayHeader	1.041 ms	- Mb
tvcmsvideoblock	0.766 ms	0.01 Mb
__construct	0.404 ms	0.01 Mb
hookDisplayHeader	0.362 ms	- Mb
tvcmswishlist	32.347 ms	0.10 Mb
__construct	0.348 ms	0.01 Mb
hookDisplayHeader	0.375 ms	- Mb
hookDisplayNavWishlistBlock	1.235 ms	0.04 Mb
hookDisplayWishlistBtnProductList	0.862 ms	0.01 Mb
hookDisplayWishlistBtnProductList	0.588 ms	- Mb
hookDisplayWishlistBtnProductList	0.608 ms	- Mb
hookDisplayWishlistBtnProductList	0.605 ms	- Mb
hookDisplayWishlistBtnProductList	0.607 ms	- Mb
hookDisplayWishlistBtnProductList	0.664 ms	- Mb
hookDisplayWishlistBtnProductList	0.600 ms	- Mb
hookDisplayWishlistBtnProductList	0.585 ms	- Mb
hookDisplayWishlistBtnProductList	0.619 ms	- Mb
hookDisplayWishlistBtnProductList	0.598 ms	- Mb
hookDisplayWishlistBtnProductList	0.597 ms	- Mb
hookDisplayWishlistBtnProductList	0.713 ms	- Mb
hookDisplayWishlistBtnProductList	0.605 ms	- Mb
hookDisplayWishlistBtnProductList	0.588 ms	- Mb
hookDisplayWishlistBtnProductList	0.586 ms	- Mb
hookDisplayWishlistBtnProductList	0.584 ms	- Mb
hookDisplayWishlistBtnProductList	0.592 ms	- Mb
hookDisplayWishlistBtnProductList	0.601 ms	- Mb
hookDisplayWishlistBtnProductList	0.596 ms	- Mb
hookDisplayWishlistBtnProductList	0.581 ms	- Mb
hookDisplayWishlistBtnProductList	0.647 ms	- Mb
hookDisplayWishlistBtnProductList	0.599 ms	- Mb
hookDisplayWishlistBtnProductList	0.585 ms	- Mb
hookDisplayWishlistBtnProductList	0.583 ms	- Mb
hookDisplayWishlistBtnProductList	0.595 ms	- Mb
hookDisplayWishlistBtnProductList	0.582 ms	- Mb
hookDisplayWishlistBtnProductList	0.597 ms	- Mb
hookDisplayWishlistBtnProductList	0.591 ms	- Mb
hookDisplayWishlistBtnProductList	0.602 ms	- Mb
hookDisplayWishlistBtnProductList	0.583 ms	- Mb
hookDisplayWishlistBtnProductList	0.582 ms	- Mb
hookDisplayWishlistBtnProductList	0.641 ms	- Mb
hookDisplayWishlistBtnProductList	0.599 ms	- Mb
hookDisplayWishlistBtnProductList	0.582 ms	- Mb
hookDisplayWishlistBtnProductList	0.600 ms	- Mb
hookDisplayWishlistBtnProductList	0.582 ms	- Mb
hookDisplayWishlistBtnProductList	0.588 ms	- Mb
hookDisplayWishlistBtnProductList	0.601 ms	- Mb
hookDisplayWishlistBtnProductList	0.609 ms	- Mb
hookDisplayWishlistBtnProductList	0.624 ms	- Mb
hookDisplayWishlistBtnProductList	0.598 ms	- Mb
hookDisplayWishlistBtnProductList	0.599 ms	- Mb
hookDisplayWishlistBtnProductList	0.594 ms	- Mb
hookDisplayWishlistBtnProductList	0.613 ms	- Mb
hookDisplayWishlistBtnProductList	0.609 ms	- Mb
hookDisplayWishlistBtnProductList	0.606 ms	- Mb
hookDisplayWishlistBtnProductList	0.598 ms	- Mb
hookDisplayWishlistBtnProductList	0.596 ms	- Mb
hookDisplayNavWishlistBlocksticky	1.225 ms	0.05 Mb
smartargetwhatsapp	1.228 ms	0.01 Mb
__construct	0.369 ms	0.01 Mb
hookDisplayHeader	0.859 ms	0.01 Mb
ps_accounts	0.698 ms	- Mb
__construct	0.698 ms	- Mb
tvcmsinfinitescroll	2.751 ms	0.06 Mb
__construct	0.398 ms	0.01 Mb
hookHeader	2.353 ms	0.05 Mb
tvcmscategoryproduct	0.841 ms	0.03 Mb
__construct	0.425 ms	0.01 Mb
hookHeader	0.416 ms	0.02 Mb
tvcmsmegamenu	8.761 ms	0.71 Mb
__construct	0.449 ms	0.01 Mb
hookHeader	0.384 ms	0.02 Mb
hookDisplayMegamenu	7.928 ms	0.68 Mb
tvcmstwoofferbanner	0.720 ms	0.02 Mb
__construct	0.364 ms	- Mb
hookHeader	0.356 ms	0.02 Mb
ps_facetedsearch	4.267 ms	0.13 Mb
__construct	1.746 ms	0.01 Mb
hookProductSearchProvider	1.848 ms	0.03 Mb
hookDisplayFacetedSearchBlock	0.673 ms	0.09 Mb
tvcmscustomcssjs	0.446 ms	0.03 Mb
__construct	0.427 ms	0.02 Mb
hookDisplayCustomCss	0.008 ms	- Mb
hookDisplayCustomJs	0.011 ms	- Mb
ps_customersignin	1.049 ms	0.06 Mb
__construct	0.123 ms	0.01 Mb
displayNavCustomerSignInBlock	0.926 ms	0.05 Mb
ps_languageselector	0.426 ms	0.06 Mb
__construct	0.129 ms	0.01 Mb
displayNavLanguageBlock	0.297 ms	0.05 Mb
ps_currencyselector	0.384 ms	0.06 Mb
__construct	0.117 ms	0.01 Mb
displayNavCurrencyBlock	0.267 ms	0.05 Mb
ps_contactinfo	2.367 ms	0.12 Mb
__construct	0.122 ms	0.01 Mb
displayNav1	1.360 ms	0.09 Mb
displayContactCinfo	0.885 ms	0.03 Mb
ps_categorytree	18.912 ms	1.82 Mb
__construct	0.143 ms	0.01 Mb
displayLeftColumn	18.769 ms	1.82 Mb
ps_brandlist	2.376 ms	0.08 Mb
__construct	0.136 ms	0.01 Mb
displayLeftColumn	2.240 ms	0.07 Mb
ps_supplierlist	2.210 ms	0.08 Mb
__construct	0.128 ms	0.01 Mb
displayLeftColumn	2.082 ms	0.07 Mb
ps_linklist	2.721 ms	0.09 Mb
__construct	0.624 ms	0.01 Mb
displayFooterPart1	2.097 ms	0.09 Mb
ps_customeraccountlinks	2.093 ms	0.09 Mb
__construct	0.121 ms	0.01 Mb
displayMyaccountcblock	1.972 ms	0.09 Mb
statsdata	3.368 ms	0.17 Mb
__construct	0.128 ms	0.01 Mb
hookDisplayBeforeBodyClosingTag	3.240 ms	0.17 Mb
64 module(s)	1229 ms	20.06 Mb

281 queries	SELECT * FROM `ps_category` a LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = XX LEFT JOIN `ps_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
60 queries	SELECT SUM(quantity) FROM `ps_stock_available` WHERE (id_product = XX) AND (id_product_attribute = XX) AND (id_shop = XX) AND (id_shop_group = XX) LIMIT XX
48 queries	SELECT (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS grade FROM `ps_tvcmsproduct_comment` pc WHERE pc.`id_product` = XX AND pc.`deleted` = XX AND pc.`validate` = XX LIMIT XX
48 queries	SELECT (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS avg, MIN(pc.`grade`) AS min, MAX(pc.`grade`) AS max FROM `ps_tvcmsproduct_comment` pc WHERE pc.`id_product` = XX AND pc.`deleted` = XX AND pc.`validate` = XX LIMIT XX
35 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 `ps_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 `ps_cart_product` cp JOIN `ps_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `ps_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
28 queries	SELECT image_shop.`cover`, i.`id_image`, il.`legend`, i.`position` FROM `ps_image` i INNER JOIN ps_image_shop image_shop ON (image_shop.id_image = i.id_image AND image_shop.id_shop = XX) LEFT JOIN `ps_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = XX) WHERE i.`id_product` = XX ORDER BY `position`
25 queries	SELECT XX FROM `ps_specific_price` WHERE id_product = XX LIMIT XX
24 queries	SELECT image_shop.`id_image` FROM `ps_image` i INNER JOIN ps_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
24 queries	SELECT name FROM ps_category_lang WHERE id_shop = XX AND id_lang = XX AND id_category = XX LIMIT XX
24 queries	SELECT * FROM `ps_product` a LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = XX LEFT JOIN `ps_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
24 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 `ps_product` p INNER JOIN `ps_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = XX) LEFT JOIN `ps_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)
24 queries	SELECT `id_tax_rules_group` FROM `ps_product_shop` WHERE `id_product` = XX AND id_shop=XX LIMIT XX
24 queries	SELECT `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = XX AND `id_group` = XX LIMIT XX
24 queries	SELECT COUNT(*) FROM `ps_pack` WHERE id_product_pack = XX LIMIT XX
24 queries	SELECT product_type FROM `ps_product` WHERE id_product = XX LIMIT XX
24 queries	SELECT name, value, pf.id_feature, f.position, fvl.id_feature_value FROM ps_feature_product pf LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = XX) LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = XX) LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = XX) INNER JOIN ps_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
22 queries	SELECT `id_product_attribute` FROM `ps_product_attribute` WHERE `id_product` = XX
18 queries	SELECT `id_module` FROM `ps_module_shop` WHERE `id_module` = XX AND `id_shop` = XX LIMIT XX
16 queries	SELECT p., ps., pl.*, sa.out_of_stock, IFNULL(sa.quantity, XX) as quantity, (DATEDIFF( p.`date_add`, DATE_SUB( 'XX-XX-XX XX:XX:XX', INTERVAL XX DAY ) ) > XX) as new FROM ps_product p LEFT JOIN ps_product_lang pl ON pl.id_product = p.id_product AND pl.id_shop = XX AND pl.id_lang = XX LEFT JOIN ps_stock_available sa ON sa.id_product = p.id_product AND sa.id_product_attribute = XX AND sa.id_shop = XX LEFT JOIN ps_product_shop ps ON ps.id_product = p.id_product AND ps.id_shop = XX WHERE p.id_product IN (XX)
12 queries	SELECT COUNT(`id_tvcmsproduct_comment`) AS "nbr" FROM `ps_tvcmsproduct_comment` pc WHERE `id_product` = XX AND `validate` = XX LIMIT XX
12 queries	select count(pa.`id_product_attribute`) as `total` from `ps_product_attribute` pa inner join `ps_product_attribute_shop` pas on pa.id_product_attribute = pas.id_product_attribute where pas.`id_shop` = XX and pa.`id_product` = XX LIMIT XX
11 queries	SELECT product_attribute_shop.`price` FROM `ps_product_attribute` pa INNER JOIN ps_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = XX) WHERE pa.`id_product_attribute` = XX LIMIT XX
11 queries	SELECT pa.`available_date` FROM `ps_product` p LEFT JOIN `ps_product_attribute` pa ON (pa.`id_product` = p.`id_product`) INNER JOIN ps_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = XX) INNER JOIN ps_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = XX) WHERE p.`id_product` = XX AND pa.`id_product` = XX AND pa.`id_product_attribute` = XX LIMIT XX
11 queries	SELECT a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, agl.`public_name` as `public_group`, pa.`reference`, pa.`eanXX`, pa.`isbn`, pa.`upc`, pa.`mpn`, pal.`available_now`, pal.`available_later` FROM `ps_attribute` a LEFT JOIN `ps_attribute_lang` al ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = XX) LEFT JOIN `ps_product_attribute_combination` pac ON (pac.`id_attribute` = a.`id_attribute`) LEFT JOIN `ps_product_attribute` pa ON (pa.`id_product_attribute` = pac.`id_product_attribute`) INNER JOIN ps_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = XX) LEFT JOIN `ps_product_attribute_lang` pal ON (pal.`id_product_attribute` = pac.`id_product_attribute` AND pal.`id_lang` = XX) LEFT JOIN `ps_attribute_group_lang` agl ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = XX) WHERE pa.`id_product` = XX AND pac.`id_product_attribute` = XX AND agl.`id_lang` = XX
11 queries	SELECT * FROM `ps_product_attribute` a LEFT JOIN `ps_product_attribute_shop` `c` ON a.`id_product_attribute` = c.`id_product_attribute` AND c.`id_shop` = XX WHERE (a.`id_product_attribute` = XX) LIMIT XX
11 queries	SELECT * FROM `ps_product_attribute_lang` WHERE `id_product_attribute` = XX
9 queries	SELECT cl.`link_rewrite` FROM `ps_category_lang` cl WHERE `id_lang` = XX AND cl.id_shop = XX AND cl.`id_category` = XX LIMIT XX
8 queries	SELECT c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop` FROM `ps_category` c LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = XX ) INNER JOIN ps_category_shop category_shop ON (category_shop.id_category = c.id_category AND category_shop.id_shop = XX) WHERE `id_lang` = XX AND c.`id_parent` = XX AND `active` = XX GROUP BY c.`id_category` ORDER BY category_shop.`position` ASC
8 queries	SELECT cg.`id_group` FROM `ps_category_group` cg WHERE (cg.`id_category` = XX)
6 queries	SELECT m.`id_module`, m.`name`, ms.`id_module`as `mshop` FROM `ps_module` m LEFT JOIN `ps_module_shop` ms ON m.`id_module` = ms.`id_module` AND ms.`id_shop` = XX
6 queries	SELECT * FROM `ps_product` a LEFT JOIN `ps_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 `ps_product_lang` WHERE `id_product` = XX AND `id_shop` = XX
6 queries	SELECT pa., product_attribute_shop. FROM `ps_product_attribute` pa INNER JOIN ps_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = XX) WHERE pa.`id_product` = XX GROUP BY pa.`id_product_attribute` ORDER BY pa.`id_product_attribute`
5 queries	SELECT quantity, reserved_quantity FROM `ps_stock_available` WHERE (id_product = XX) AND (id_product_attribute = XX) AND (id_shop = XX) AND (id_shop_group = XX) LIMIT XX
4 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 `ps_attribute_group` ag INNER JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = XX) INNER JOIN `ps_attribute` a ON a.`id_attribute_group` = ag.`id_attribute_group` INNER JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = XX) INNER JOIN ps_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 ps_attribute_shop attribute_shop ON (attribute_shop.id_attribute = a.id_attribute AND attribute_shop.id_shop = XX) LEFT JOIN `ps_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
4 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, cp.position FROM ps_product p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_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 ps_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = XX AND ps.active = TRUE) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=XX) LEFT JOIN ps_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='XX' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='XX' AND cp.id_category IN (XX, XX, XX, XX, XX, XX, XX) GROUP BY p.id_product) p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) INNER JOIN ps_attribute a ON (a.id_attribute = pac.id_attribute) WHERE ((a.id_attribute_group=XX)) GROUP BY pac.id_attribute
4 queries	SELECT tr.* FROM `ps_tax_rule` tr JOIN `ps_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 `priority`, `id_specific_price_priority` FROM `ps_specific_price_priority` WHERE `id_product` = XX ORDER BY `id_specific_price_priority` DESC LIMIT XX
4 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 `ps_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
4 queries	SELECT mr.* FROM ps_tvcmsmegamenu_row_shop mr WHERE mr.`id_shop` = XX AND mr.id_tvcmsmegamenu = XX AND mr.`active` = XX
3 queries	SELECT `need_identification_number` FROM `ps_country` WHERE `id_country` = XX LIMIT XX
3 queries	SELECT pai.`id_image`, pai.`id_product_attribute`, il.`legend` FROM `ps_product_attribute_image` pai LEFT JOIN `ps_image_lang` il ON (il.`id_image` = pai.`id_image`) LEFT JOIN `ps_image` i ON (i.`id_image` = pai.`id_image`) WHERE pai.`id_product_attribute` IN (XX, XX, XX, XX, XX, XX, XX, XX) AND il.`id_lang` = XX ORDER by i.`position`
3 queries	SELECT pac.id_product_attribute, GROUP_CONCAT(agl.`name`, ' - ',al.`name` ORDER BY agl.`id_attribute_group` SEPARATOR ', ') as attribute_designation FROM `ps_product_attribute_combination` pac LEFT JOIN `ps_attribute` a ON a.`id_attribute` = pac.`id_attribute` LEFT JOIN `ps_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group` LEFT JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = XX) LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = XX) WHERE pac.id_product_attribute IN (XX,XX,XX,XX,XX,XX,XX,XX) GROUP BY pac.id_product_attribute ORDER BY pac.id_product_attribute
2 queries	SELECT `active` FROM `ps_module` WHERE `name` = "ps_mbo" LIMIT XX
2 queries	SELECT m.`id_module` as `active`, ms.`id_module` as `shop_active` FROM `ps_module` m LEFT JOIN `ps_module_shop` ms ON m.`id_module` = ms.`id_module` WHERE `name` = "ps_mbo" LIMIT XX
2 queries	SELECT `id_lang` FROM `ps_lang` WHERE `locale` = 'es-es' OR `language_code` = 'es-es' LIMIT XX
2 queries	SELECT `id_category` FROM `ps_category_shop` WHERE `id_category` = XX AND `id_shop` = XX LIMIT XX
2 queries	SELECT ctg.`id_group` FROM ps_category_group ctg WHERE ctg.`id_category` = XX AND ctg.`id_group` = XX LIMIT XX
2 queries	SELECT * FROM `ps_category` aXX LEFT JOIN `ps_category_lang` `aXX` ON (aXX.`id_category` = aXX.`id_category`) WHERE (aXX.`nleft` < XX) AND (aXX.`nright` > XX) AND (aXX.`id_lang` = XX) AND (aXX.`id_shop` = XX) ORDER BY aXX.`nleft` asc
2 queries	SELECT fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM ps_product p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_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 ps_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = XX AND ps.active = TRUE) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=XX) LEFT JOIN ps_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='XX' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='XX' AND cp.id_category IN (XX, XX, XX, XX, XX, XX, XX) GROUP BY p.id_product) p INNER JOIN ps_feature_product fp ON (p.id_product = fp.id_product) WHERE ((fp.id_feature=XX)) GROUP BY fp.id_feature_value
2 queries	SELECT pai.`id_image`, pai.`id_product_attribute`, il.`legend` FROM `ps_product_attribute_image` pai LEFT JOIN `ps_image_lang` il ON (il.`id_image` = pai.`id_image`) LEFT JOIN `ps_image` i ON (i.`id_image` = pai.`id_image`) WHERE pai.`id_product_attribute` IN (XX, XX, XX, XX) AND il.`id_lang` = XX ORDER by i.`position`
2 queries	SELECT pai.`id_image`, pai.`id_product_attribute`, il.`legend` FROM `ps_product_attribute_image` pai LEFT JOIN `ps_image_lang` il ON (il.`id_image` = pai.`id_image`) LEFT JOIN `ps_image` i ON (i.`id_image` = pai.`id_image`) WHERE pai.`id_product_attribute` IN (XX, XX) AND il.`id_lang` = XX ORDER by i.`position`
2 queries	SELECT XX FROM `ps_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 UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache` WHERE `template_hash`=XX AND cache_id="module:tvcmsproductpopup/views/templates/hook/tvcmsproductpopup_footer\|XX\|XX\|XX\|XX" AND compile_id="vXX_giftoo_XX" LIMIT XX
2 queries	SELECT p., product_shop., stock.out_of_stock, IFNULL(stock.quantity, XX) as quantity, pl.`description`, pl.`description_short`, pl.`link_rewrite`, pl.`meta_description`, pl.`meta_keywords`, pl.`meta_title`, pl.`name`, pl.`available_now`, pl.`available_later`, image_shop.`id_image` id_image, il.`legend`, m.`name` AS manufacturer_name, (DATEDIFF(product_shop.`date_add`, DATE_SUB( "XX-XX-XX XX:XX:XX", INTERVAL XX DAY ) ) > XX) as new, product_attribute_shop.minimal_quantity AS product_attribute_minimal_quantity, IFNULL(product_attribute_shop.id_product_attribute,XX) id_product_attribute FROM `ps_product` p INNER JOIN ps_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = XX) LEFT JOIN `ps_product_lang` `pl` ON p.`id_product` = pl.`id_product` AND pl.`id_lang` = XX AND pl.id_shop = XX LEFT JOIN `ps_image_shop` `image_shop` ON image_shop.`id_product` = p.`id_product` AND image_shop.cover=XX AND image_shop.id_shop=XX LEFT JOIN `ps_image_lang` `il` ON image_shop.`id_image` = il.`id_image` AND il.`id_lang` = XX LEFT JOIN `ps_manufacturer` `m` ON m.`id_manufacturer` = p.`id_manufacturer` LEFT JOIN `ps_product_attribute_shop` `product_attribute_shop` ON p.`id_product` = product_attribute_shop.`id_product` AND product_attribute_shop.`default_on` = XX AND product_attribute_shop.id_shop=XX LEFT JOIN ps_stock_available stock ON (stock.id_product = `p`.id_product AND stock.id_product_attribute = XX AND stock.id_shop = XX AND stock.id_shop_group = XX ) WHERE (product_shop.`active` = XX) AND (product_shop.`visibility` IN ("both", "catalog")) AND (DATEDIFF(product_shop.`date_add`, DATE_SUB( "XX-XX-XX XX:XX:XX", INTERVAL XX DAY ) ) > XX) AND (EXISTS(SELECT XX FROM `ps_category_product` cp JOIN `ps_category_group` cg ON (cp.id_category = cg.id_category AND cg.`id_group` =XX) WHERE cp.`id_product` = p.`id_product`)) ORDER BY product_shop.`date_add` DESC LIMIT XX
2 queries	SELECT count(id_wishlist_product) FROM ps_wishlist w, ps_wishlist_product wp where w.id_wishlist = wp.id_wishlist and w.id_customer=XX LIMIT XX
2 queries	SELECT pai.`id_image`, pai.`id_product_attribute`, il.`legend` FROM `ps_product_attribute_image` pai LEFT JOIN `ps_image_lang` il ON (il.`id_image` = pai.`id_image`) LEFT JOIN `ps_image` i ON (i.`id_image` = pai.`id_image`) WHERE pai.`id_product_attribute` IN (XX, XX, XX, XX, XX) AND il.`id_lang` = XX ORDER by i.`position`

#	Query	Time (ms)	Rows	Filesort	Group By	Location
367	SELECT SQL_NO_CACHE cp.id_category, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM ps_product p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_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 ps_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' GROUP BY p.id_product) p INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_category_group cg ON (cg.id_category = c.id_category) WHERE cg.id_group='1' AND c.level_depth<=2 AND c.nleft>2 AND c.nright<1457 GROUP BY cp.id_category	720.876 ms	96228			/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) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
749	SELECT SQL_NO_CACHE p., product_shop., stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, pl.`description`, pl.`description_short`, pl.`link_rewrite`, pl.`meta_description`, pl.`meta_keywords`, pl.`meta_title`, pl.`name`, pl.`available_now`, pl.`available_later`, image_shop.`id_image` id_image, il.`legend`, m.`name` AS manufacturer_name, (DATEDIFF(product_shop.`date_add`, DATE_SUB( "2025-07-31 00:00:00", INTERVAL 1000 DAY ) ) > 0) as new, product_attribute_shop.minimal_quantity AS product_attribute_minimal_quantity, IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute FROM `ps_product` p INNER JOIN ps_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) LEFT JOIN `ps_product_lang` `pl` ON p.`id_product` = pl.`id_product` AND pl.`id_lang` = 1 AND pl.id_shop = 1 LEFT JOIN `ps_image_shop` `image_shop` ON image_shop.`id_product` = p.`id_product` AND image_shop.cover=1 AND image_shop.id_shop=1 LEFT JOIN `ps_image_lang` `il` ON image_shop.`id_image` = il.`id_image` AND il.`id_lang` = 1 LEFT JOIN `ps_manufacturer` `m` ON m.`id_manufacturer` = p.`id_manufacturer` LEFT JOIN `ps_product_attribute_shop` `product_attribute_shop` ON p.`id_product` = product_attribute_shop.`id_product` AND product_attribute_shop.`default_on` = 1 AND product_attribute_shop.id_shop=1 LEFT JOIN ps_stock_available stock ON (stock.id_product = `p`.id_product AND stock.id_product_attribute = 0 AND stock.id_shop = 1 AND stock.id_shop_group = 0 ) WHERE (product_shop.`active` = 1) AND (product_shop.`visibility` IN ("both", "catalog")) AND (DATEDIFF(product_shop.`date_add`, DATE_SUB( "2025-07-31 00:00:00", INTERVAL 1000 DAY ) ) > 0) AND (EXISTS(SELECT 1 FROM `ps_category_product` cp JOIN `ps_category_group` cg ON (cp.id_category = cg.id_category AND cg.`id_group` =1) WHERE cp.`id_product` = p.`id_product`)) ORDER BY product_shop.`date_add` DESC LIMIT 4	357.139 ms	384671430	Yes		/classes/Product.php:3110 /modules/tvcmstabproducts/tvcmstabproducts.php:2809 (getNewProducts) /modules/tvcmsnewproducts/tvcmsnewproducts.php:157 (displayNewProducts) /modules/tvcmsnewproducts/tvcmsnewproducts.php:266 (showFrontSideResult) /classes/Hook.php:1083 (hookdisplayLeftColumn) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:421 (coreCallHook) /classes/Hook.php:989 (callHookOn) /config/smarty.config.inc.php:201 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/dev/smarty/compile/v1_giftoo_168layouts_layout_left_column_tpl/69/81/ba/6981ba7f75ae91c680b199f8c9b8d3dbd8d96719_2.file.layout-both-columns.tpl.php:192 (__call) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/v1_giftoo_168layouts_layout_left_column_tpl/69/81/ba/6981ba7f75ae91c680b199f8c9b8d3dbd8d96719_2.file.layout-both-columns.tpl.php:74 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_688bca89963334_98279087) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/v1_giftoo_168layouts_layout_left_column_tpl/8d/0f/a6/8d0fa6a125af07e8554a5461801ff205a85e918e_2.file.layout-left-column.tpl.php:28 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_688bca89918cb8_31976545) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/v1_giftoo_168layouts_layout_left_column_tpl/33/cf/b7/33cfb772f37fe9bf7e7da2f4ede7b9ba2ebdb1ff_2.file.product-list.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_688bca898f8023_38089402) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/v1_giftoo_168layouts_layout_left_column_tpl/a5/95/48/a595487cdf0e93c51d790aa7d81fde9f6d267539_2.file.category.tpl.php:29 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_688bca898bc698_82360211) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/Smarty/SmartyCustom.php:112 (fetch) /classes/controller/FrontController.php:771 (fetch) /classes/controller/FrontController.php:753 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
621	SELECT SQL_NO_CACHE p., product_shop., stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, pl.`description`, pl.`description_short`, pl.`link_rewrite`, pl.`meta_description`, pl.`meta_keywords`, pl.`meta_title`, pl.`name`, pl.`available_now`, pl.`available_later`, image_shop.`id_image` id_image, il.`legend`, m.`name` AS manufacturer_name, (DATEDIFF(product_shop.`date_add`, DATE_SUB( "2025-07-31 00:00:00", INTERVAL 1000 DAY ) ) > 0) as new, product_attribute_shop.minimal_quantity AS product_attribute_minimal_quantity, IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute FROM `ps_product` p INNER JOIN ps_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) LEFT JOIN `ps_product_lang` `pl` ON p.`id_product` = pl.`id_product` AND pl.`id_lang` = 1 AND pl.id_shop = 1 LEFT JOIN `ps_image_shop` `image_shop` ON image_shop.`id_product` = p.`id_product` AND image_shop.cover=1 AND image_shop.id_shop=1 LEFT JOIN `ps_image_lang` `il` ON image_shop.`id_image` = il.`id_image` AND il.`id_lang` = 1 LEFT JOIN `ps_manufacturer` `m` ON m.`id_manufacturer` = p.`id_manufacturer` LEFT JOIN `ps_product_attribute_shop` `product_attribute_shop` ON p.`id_product` = product_attribute_shop.`id_product` AND product_attribute_shop.`default_on` = 1 AND product_attribute_shop.id_shop=1 LEFT JOIN ps_stock_available stock ON (stock.id_product = `p`.id_product AND stock.id_product_attribute = 0 AND stock.id_shop = 1 AND stock.id_shop_group = 0 ) WHERE (product_shop.`active` = 1) AND (product_shop.`visibility` IN ("both", "catalog")) AND (DATEDIFF(product_shop.`date_add`, DATE_SUB( "2025-07-31 00:00:00", INTERVAL 1000 DAY ) ) > 0) AND (EXISTS(SELECT 1 FROM `ps_category_product` cp JOIN `ps_category_group` cg ON (cp.id_category = cg.id_category AND cg.`id_group` =1) WHERE cp.`id_product` = p.`id_product`)) ORDER BY product_shop.`date_add` DESC LIMIT 5	286.987 ms	384671430	Yes		/classes/Product.php:3110 /modules/tvcmsproductpopup/tvcmsproductpopup.php:367 (getNewProducts) /modules/tvcmsproductpopup/tvcmsproductpopup.php:252 (getNewProducts) /modules/tvcmsproductpopup/tvcmsproductpopup.php:546 (prevHook) /classes/Hook.php:1083 (hookdisplayAfterBodyOpeningTag) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:421 (coreCallHook) /classes/Hook.php:989 (callHookOn) /config/smarty.config.inc.php:201 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/dev/smarty/compile/v1_giftoo_168layouts_layout_left_column_tpl/69/81/ba/6981ba7f75ae91c680b199f8c9b8d3dbd8d96719_2.file.layout-both-columns.tpl.php:116 (__call) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/v1_giftoo_168layouts_layout_left_column_tpl/69/81/ba/6981ba7f75ae91c680b199f8c9b8d3dbd8d96719_2.file.layout-both-columns.tpl.php:54 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_688bca89963334_98279087) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/v1_giftoo_168layouts_layout_left_column_tpl/8d/0f/a6/8d0fa6a125af07e8554a5461801ff205a85e918e_2.file.layout-left-column.tpl.php:28 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_688bca89918cb8_31976545) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/v1_giftoo_168layouts_layout_left_column_tpl/33/cf/b7/33cfb772f37fe9bf7e7da2f4ede7b9ba2ebdb1ff_2.file.product-list.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_688bca898f8023_38089402) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/v1_giftoo_168layouts_layout_left_column_tpl/a5/95/48/a595487cdf0e93c51d790aa7d81fde9f6d267539_2.file.category.tpl.php:29 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_688bca898bc698_82360211) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/Smarty/SmartyCustom.php:112 (fetch) /classes/controller/FrontController.php:771 (fetch) /classes/controller/FrontController.php:753 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
745	SELECT SQL_NO_CACHE c., cl. FROM `ps_category` c INNER JOIN ps_category_shop category_shop ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1) LEFT JOIN `ps_category_lang` cl ON c.`id_category` = cl.`id_category` AND cl.id_shop = 1 LEFT JOIN `ps_category_group` cg ON c.`id_category` = cg.`id_category` RIGHT JOIN `ps_category` c2 ON c2.`id_category` = 2 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright` WHERE 1 AND c.`level_depth` <= 5 AND `id_lang` = 1 AND c.`active` = 1 AND cg.`id_group` IN (1) GROUP BY c.`id_category` ORDER BY c.`level_depth` ASC, category_shop.`position` ASC	10.850 ms	624	Yes	Yes	/classes/Category.php:799 /modules/ps_categorytree/ps_categorytree.php:141 (getNestedCategories) /modules/ps_categorytree/ps_categorytree.php:298 (getCategories) /modules/ps_categorytree/ps_categorytree.php:266 (getWidgetVariables) /classes/Hook.php:1094 (renderWidget) /tools/profiling/Hook.php:64 (coreRenderWidget) /classes/Hook.php:1025 (coreRenderWidget) /config/smarty.config.inc.php:201 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/dev/smarty/compile/v1_giftoo_168layouts_layout_left_column_tpl/69/81/ba/6981ba7f75ae91c680b199f8c9b8d3dbd8d96719_2.file.layout-both-columns.tpl.php:192 (__call) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/v1_giftoo_168layouts_layout_left_column_tpl/69/81/ba/6981ba7f75ae91c680b199f8c9b8d3dbd8d96719_2.file.layout-both-columns.tpl.php:74 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_688bca89963334_98279087) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/v1_giftoo_168layouts_layout_left_column_tpl/8d/0f/a6/8d0fa6a125af07e8554a5461801ff205a85e918e_2.file.layout-left-column.tpl.php:28 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_688bca89918cb8_31976545) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/v1_giftoo_168layouts_layout_left_column_tpl/33/cf/b7/33cfb772f37fe9bf7e7da2f4ede7b9ba2ebdb1ff_2.file.product-list.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_688bca898f8023_38089402) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/v1_giftoo_168layouts_layout_left_column_tpl/a5/95/48/a595487cdf0e93c51d790aa7d81fde9f6d267539_2.file.category.tpl.php:29 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_688bca898bc698_82360211) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/Smarty/SmartyCustom.php:112 (fetch) /classes/controller/FrontController.php:771 (fetch) /classes/controller/FrontController.php:753 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
768	SELECT SQL_NO_CACHE p., product_shop., stock.out_of_stock, IFNULL(stock.quantity, 0) AS quantity, IFNULL(product_attribute_shop.id_product_attribute, 0) AS id_product_attribute, product_attribute_shop.minimal_quantity AS product_attribute_minimal_quantity, pl.`description`, pl.`description_short`, pl.`available_now`, pl.`available_later`, pl.`link_rewrite`, pl.`meta_description`, pl.`meta_keywords`, pl.`meta_title`, pl.`name`, image_shop.`id_image` id_image, il.`legend` as legend, m.`name` AS manufacturer_name, cl.`name` AS category_default, DATEDIFF(product_shop.`date_add`, DATE_SUB("2025-07-31 00:00:00", INTERVAL 1000 DAY)) > 0 AS new, product_shop.price AS orderprice FROM `ps_category_product` cp LEFT JOIN `ps_product` p ON p.`id_product` = cp.`id_product` INNER JOIN ps_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) LEFT JOIN `ps_product_attribute_shop` product_attribute_shop ON (p.`id_product` = product_attribute_shop.`id_product` AND product_attribute_shop.`default_on` = 1 AND product_attribute_shop.id_shop=1) LEFT JOIN ps_stock_available stock ON (stock.id_product = `p`.id_product AND stock.id_product_attribute = 0 AND stock.id_shop = 1 AND stock.id_shop_group = 0 ) LEFT JOIN `ps_category_lang` cl ON (product_shop.`id_category_default` = cl.`id_category` AND cl.`id_lang` = 1 AND cl.id_shop = 1 ) LEFT JOIN `ps_product_lang` pl ON (p.`id_product` = pl.`id_product` AND pl.`id_lang` = 1 AND pl.id_shop = 1 ) LEFT JOIN `ps_image_shop` image_shop ON (image_shop.`id_product` = p.`id_product` AND image_shop.cover=1 AND image_shop.id_shop=1) LEFT JOIN `ps_image_lang` il ON (image_shop.`id_image` = il.`id_image` AND il.`id_lang` = 1) LEFT JOIN `ps_manufacturer` m ON m.`id_manufacturer` = p.`id_manufacturer` WHERE product_shop.`id_shop` = 1 AND cp.`id_category` = 25 AND product_shop.`active` = 1 AND product_shop.`visibility` IN ("both", "catalog") ORDER BY RAND() LIMIT 4	4.192 ms	122	Yes		/classes/Category.php:1062 /src/Adapter/Category/CategoryProductSearchProvider.php:79 (getProducts) /src/Adapter/Category/CategoryProductSearchProvider.php:105 (getProductsOrCount) /modules/tvcmstabproducts/tvcmstabproducts.php:2754 (runQuery) /modules/tvcmsfeaturedproducts/tvcmsfeaturedproducts.php:158 (displayFeaturedProducts) /modules/tvcmsfeaturedproducts/tvcmsfeaturedproducts.php:281 (showFrontSideResult) /classes/Hook.php:1083 (hookdisplayLeftColumn) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:421 (coreCallHook) /classes/Hook.php:989 (callHookOn) /config/smarty.config.inc.php:201 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/dev/smarty/compile/v1_giftoo_168layouts_layout_left_column_tpl/69/81/ba/6981ba7f75ae91c680b199f8c9b8d3dbd8d96719_2.file.layout-both-columns.tpl.php:192 (__call) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/v1_giftoo_168layouts_layout_left_column_tpl/69/81/ba/6981ba7f75ae91c680b199f8c9b8d3dbd8d96719_2.file.layout-both-columns.tpl.php:74 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_688bca89963334_98279087) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/v1_giftoo_168layouts_layout_left_column_tpl/8d/0f/a6/8d0fa6a125af07e8554a5461801ff205a85e918e_2.file.layout-left-column.tpl.php:28 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_688bca89918cb8_31976545) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/v1_giftoo_168layouts_layout_left_column_tpl/33/cf/b7/33cfb772f37fe9bf7e7da2f4ede7b9ba2ebdb1ff_2.file.product-list.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_688bca898f8023_38089402) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/v1_giftoo_168layouts_layout_left_column_tpl/a5/95/48/a595487cdf0e93c51d790aa7d81fde9f6d267539_2.file.category.tpl.php:29 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_688bca898bc698_82360211) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/Smarty/SmartyCustom.php:112 (fetch) /classes/controller/FrontController.php:771 (fetch) /classes/controller/FrontController.php:753 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
728	SELECT SQL_NO_CACHE c., cl. FROM `ps_category` c INNER JOIN ps_category_shop category_shop ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1) LEFT JOIN `ps_category_lang` cl ON c.`id_category` = cl.`id_category` AND cl.id_shop = 1 WHERE 1 AND `id_lang` = 1 AND c.`active` = 1 ORDER BY c.`level_depth` ASC , category_shop.`position` ASC	3.808 ms	624	Yes		/classes/Category.php:799 /modules/tvcmssearch/tvcmssearch.php:100 (getNestedCategories) /modules/tvcmssearch/tvcmssearch.php:211 (getAllCategories) /classes/Hook.php:1083 (hookdisplayNavSearchBlock) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:421 (coreCallHook) /classes/Hook.php:989 (callHookOn) /config/smarty.config.inc.php:201 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/dev/smarty/compile/v1_giftoo_168layouts_layout_left_column_tpl/90/13/a7/9013a7a04bf39036fbad3fb5950dffed201fd662_2.file.desk-header-4.tpl.php:31 (__call) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_688bca8aedb8e5_63912440) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /var/cache/dev/smarty/compile/v1_giftoo_168layouts_layout_left_column_tpl/1f/24/34/1f24346c22c38b7c776c299605d2505a48901b59_2.file.desktop-header.tpl.php:25 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_688bca8aebafe8_11290461) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /var/cache/dev/smarty/compile/v1_giftoo_168layouts_layout_left_column_tpl/dd/09/47/dd09475ae3b50c8ffa5eab9566f11c0a7b74d124_2.file.header.tpl.php:55 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/v1_giftoo_168layouts_layout_left_column_tpl/dd/09/47/dd09475ae3b50c8ffa5eab9566f11c0a7b74d124_2.file.header.tpl.php:29 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_688bca8aea9522_22684211) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /var/cache/dev/smarty/compile/v1_giftoo_168layouts_layout_left_column_tpl/69/81/ba/6981ba7f75ae91c680b199f8c9b8d3dbd8d96719_2.file.layout-both-columns.tpl.php:144 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/v1_giftoo_168layouts_layout_left_column_tpl/69/81/ba/6981ba7f75ae91c680b199f8c9b8d3dbd8d96719_2.file.layout-both-columns.tpl.php:64 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_688bca89963334_98279087) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/v1_giftoo_168layouts_layout_left_column_tpl/8d/0f/a6/8d0fa6a125af07e8554a5461801ff205a85e918e_2.file.layout-left-column.tpl.php:28 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_688bca89918cb8_31976545) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/v1_giftoo_168layouts_layout_left_column_tpl/33/cf/b7/33cfb772f37fe9bf7e7da2f4ede7b9ba2ebdb1ff_2.file.product-list.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_688bca898f8023_38089402) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/v1_giftoo_168layouts_layout_left_column_tpl/a5/95/48/a595487cdf0e93c51d790aa7d81fde9f6d267539_2.file.category.tpl.php:29 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_688bca898bc698_82360211) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/Smarty/SmartyCustom.php:112 (fetch) /classes/controller/FrontController.php:771 (fetch) /classes/controller/FrontController.php:753 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
359	SELECT SQL_NO_CACHE COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM ps_product p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_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 ps_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND cp.id_category IN (723, 746, 731, 623, 732, 41, 650) GROUP BY p.id_product) p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_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 ps_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 ) WHERE ((sa.quantity<=0 AND sa_1.out_of_stock IN (0, 2)))	2.771 ms	30752			/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) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
361	SELECT SQL_NO_CACHE COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM ps_product p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_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 ps_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND cp.id_category IN (723, 746, 731, 623, 732, 41, 650) GROUP BY p.id_product) p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_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 ) WHERE ((sa.quantity>0))	2.668 ms	30752			/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:778 (execute) /modules/ps_facetedsearch/src/Adapter/MySQL.php:757 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:505 (count) /modules/ps_facetedsearch/src/Filters/Block.php:140 (getAvailabilitiesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
360	SELECT SQL_NO_CACHE COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM ps_product p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_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 ps_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND cp.id_category IN (723, 746, 731, 623, 732, 41, 650) GROUP BY p.id_product) p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_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 ) WHERE ((sa.out_of_stock=1) OR (sa.quantity>0))	2.611 ms	30752			/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) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
43	SELECT SQL_NO_CACHE c.*, cl.`id_lang`, cl.`name`, cl.`description`, cl.`additional_description`, cl.`link_rewrite`, cl.`meta_title`, cl.`meta_keywords`, cl.`meta_description` FROM `ps_category` c INNER JOIN ps_category_shop category_shop ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1) LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND `id_lang` = 1 AND cl.id_shop = 1 ) LEFT JOIN `ps_category_group` cg ON (cg.`id_category` = c.`id_category`) WHERE `id_parent` = 2 AND `active` = 1 AND cg.`id_group` =1 GROUP BY c.`id_category` ORDER BY `level_depth` ASC, category_shop.`position` ASC	2.466 ms	729	Yes	Yes	/classes/Category.php:924 /controllers/front/listing/CategoryController.php:230 (getSubCategories) /controllers/front/listing/CategoryController.php:118 (getTemplateVarSubCategories) /tools/profiling/Controller.php:41 (init) /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 `ps_configuration` c LEFT JOIN `ps_configuration_lang` cl ON (c.`id_configuration` = cl.`id_configuration`)	2.390 ms	1147			/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)
366	SELECT SQL_NO_CACHE c.`id_category`, cl.`name` FROM `ps_category` c INNER JOIN ps_category_shop category_shop ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1) LEFT JOIN `ps_category_lang` cl ON c.`id_category` = cl.`id_category` AND cl.id_shop = 1 WHERE 1 AND `id_lang` = 1 AND c.`active` = 1 ORDER BY c.nleft, c.position	2.275 ms	624	Yes		/classes/Category.php:724 /modules/ps_facetedsearch/src/Filters/Block.php:986 (getAllCategoriesName) /modules/ps_facetedsearch/src/Filters/Block.php:158 (getCategoriesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
357	SELECT SQL_NO_CACHE p.id_product FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM ps_product p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_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 ps_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND cp.id_category IN (723, 746, 731, 623, 732, 41, 650) GROUP BY p.id_product) p INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) GROUP BY p.id_product ORDER BY p.position ASC, p.id_product DESC	1.826 ms	15376	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) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
13	SELECT SQL_NO_CACHE h.`name` as hook, m.`id_module`, h.`id_hook`, m.`name` as module FROM `ps_module` m INNER JOIN ps_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 `ps_hook_module` `hm` ON hm.`id_module` = m.`id_module` INNER JOIN `ps_hook` `h` ON hm.`id_hook` = h.`id_hook` LEFT JOIN `ps_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`	1.777 ms	230	Yes	Yes	/classes/Hook.php:1289 /classes/Hook.php:738 (getAllHookRegistrations) /classes/Hook.php:848 (getHookModuleExecList) /classes/Dispatcher.php:606 (exec) /classes/Dispatcher.php:243 (loadRoutes) /classes/Dispatcher.php:201 (__construct) /index.php:28 (getInstance)
371	SELECT SQL_NO_CACHE pac.id_attribute, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM ps_product p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_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 ps_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND cp.id_category IN (723, 746, 731, 623, 732, 41, 650) GROUP BY p.id_product) p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) INNER JOIN ps_attribute a ON (a.id_attribute = pac.id_attribute) WHERE ((a.id_attribute_group=2)) GROUP BY pac.id_attribute	1.523 ms	30752	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) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
362	SELECT SQL_NO_CACHE COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM ps_product p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_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 ps_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND cp.id_category IN (723, 746, 731, 623, 732, 41, 650) GROUP BY p.id_product) p WHERE ((p.on_sale=1))	1.396 ms	15376			/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:778 (execute) /modules/ps_facetedsearch/src/Adapter/MySQL.php:757 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:565 (count) /modules/ps_facetedsearch/src/Filters/Block.php:143 (getHighlightsBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
393	SELECT SQL_NO_CACHE h.id_hook, h.name as h_name, title, description, h.position, hm.position as hm_position, m.id_module, m.name, m.active FROM `ps_hook_module` hm STRAIGHT_JOIN `ps_hook` h ON (h.id_hook = hm.id_hook AND hm.id_shop = 1) STRAIGHT_JOIN `ps_module` as m ON (m.id_module = hm.id_module) ORDER BY hm.position	1.389 ms	593			/classes/Hook.php:459 /classes/Hook.php:496 (getHookModuleList) /classes/tax/TaxManagerFactory.php:67 (getModulesFromHook) /classes/tax/TaxManagerFactory.php:46 (execHookTaxManagerFactory) /classes/Product.php:3925 (getManager) /classes/Product.php:3717 (priceCalculation) /classes/Product.php:5692 (getPriceStatic) /classes/ProductAssembler.php:209 (getProductProperties) /classes/controller/ProductListingFrontController.php:108 (assembleProducts) /classes/controller/ProductListingFrontController.php:379 (prepareMultipleProductsForTemplate) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
363	SELECT SQL_NO_CACHE COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM ps_product p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_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 ps_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND cp.id_category IN (723, 746, 731, 623, 732, 41, 650) GROUP BY p.id_product) p WHERE p.date_add>'2022-11-05 00:00:00'	1.365 ms	15376			/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:778 (execute) /modules/ps_facetedsearch/src/Adapter/MySQL.php:757 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:587 (count) /modules/ps_facetedsearch/src/Filters/Block.php:143 (getHighlightsBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
392	SELECT SQL_NO_CACHE `id_hook`, `name` FROM `ps_hook` UNION SELECT `id_hook`, ha.`alias` as name FROM `ps_hook_alias` ha INNER JOIN `ps_hook` h ON ha.name = h.name	1.338 ms	0			/classes/Hook.php:1348 /classes/Hook.php:228 (getAllHookIds) /classes/tax/TaxManagerFactory.php:67 (getIdByName) /classes/tax/TaxManagerFactory.php:46 (execHookTaxManagerFactory) /classes/Product.php:3925 (getManager) /classes/Product.php:3717 (priceCalculation) /classes/Product.php:5692 (getPriceStatic) /classes/ProductAssembler.php:209 (getProductProperties) /classes/controller/ProductListingFrontController.php:108 (assembleProducts) /classes/controller/ProductListingFrontController.php:379 (prepareMultipleProductsForTemplate) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
376	SELECT SQL_NO_CACHE p.condition, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM ps_product p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_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 ps_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND cp.id_category IN (723, 746, 731, 623, 732, 41, 650) GROUP BY p.id_product) p GROUP BY p.condition	1.272 ms	15376	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:778 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:394 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:137 (getConditionsBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
375	SELECT SQL_NO_CACHE p.id_manufacturer, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM ps_product p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_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 ps_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND cp.id_category IN (723, 746, 731, 623, 732, 41, 650) GROUP BY p.id_product) p GROUP BY p.id_manufacturer	1.255 ms	15376	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:778 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:661 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:146 (getManufacturersBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
870	SELECT SQL_NO_CACHE p., product_shop., stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, product_attribute_shop.minimal_quantity AS product_attribute_minimal_quantity,IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, pl.`description`, pl.`description_short`, pl.`link_rewrite`, pl.`meta_description`, pl.`meta_keywords`, pl.`meta_title`, pl.`name`, pl.`available_now`, pl.`available_later`, m.`name` AS manufacturer_name, p.`id_manufacturer` as id_manufacturer, image_shop.`id_image` id_image, il.`legend`, ps.`quantity` AS sales, t.`rate`, pl.`meta_keywords`, pl.`meta_title`, pl.`meta_description`, DATEDIFF(p.`date_add`, DATE_SUB("2025-07-31 00:00:00", INTERVAL 1000 DAY)) > 0 AS new FROM `ps_product_sale` ps LEFT JOIN `ps_product` p ON ps.`id_product` = p.`id_product` LEFT JOIN ps_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) LEFT JOIN `ps_product_attribute_shop` product_attribute_shop ON (p.`id_product` = product_attribute_shop.`id_product` AND product_attribute_shop.`default_on` = 1 AND product_attribute_shop.id_shop=1) LEFT JOIN `ps_product_lang` pl ON p.`id_product` = pl.`id_product` AND pl.`id_lang` = 1 AND pl.id_shop = 1 LEFT JOIN `ps_image_shop` image_shop ON (image_shop.`id_product` = p.`id_product` AND image_shop.cover=1 AND image_shop.id_shop=1) LEFT JOIN `ps_image_lang` il ON (image_shop.`id_image` = il.`id_image` AND il.`id_lang` = 1) LEFT JOIN `ps_manufacturer` m ON (m.`id_manufacturer` = p.`id_manufacturer`) LEFT JOIN `ps_tax_rule` tr ON (product_shop.`id_tax_rules_group` = tr.`id_tax_rules_group`) AND tr.`id_country` = 6 AND tr.`id_state` = 0 LEFT JOIN `ps_tax` t ON (t.`id_tax` = tr.`id_tax`) LEFT JOIN ps_stock_available stock ON (stock.id_product = `p`.id_product AND stock.id_product_attribute = 0 AND stock.id_shop = 1 AND stock.id_shop_group = 0 ) WHERE product_shop.`active` = 1 AND product_shop.`visibility` != 'none' AND EXISTS(SELECT 1 FROM `ps_category_product` cp JOIN `ps_category_group` cg ON (cp.id_category = cg.id_category AND cg.`id_group` =1) WHERE cp.`id_product` = p.`id_product`) ORDER BY `sales` DESC LIMIT 0, 4	0.896 ms	2			/classes/ProductSale.php:151 /src/Adapter/BestSales/BestSalesProductSearchProvider.php:74 (getBestSales) /modules/tvcmstabproducts/tvcmstabproducts.php:2925 (runQuery) /modules/tvcmsbestsellerproducts/tvcmsbestsellerproducts.php:156 (displayBestSellers) /modules/tvcmsbestsellerproducts/tvcmsbestsellerproducts.php:269 (showFrontSideResult) /classes/Hook.php:1083 (hookdisplayLeftColumn) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:421 (coreCallHook) /classes/Hook.php:989 (callHookOn) /config/smarty.config.inc.php:201 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/dev/smarty/compile/v1_giftoo_168layouts_layout_left_column_tpl/69/81/ba/6981ba7f75ae91c680b199f8c9b8d3dbd8d96719_2.file.layout-both-columns.tpl.php:192 (__call) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/v1_giftoo_168layouts_layout_left_column_tpl/69/81/ba/6981ba7f75ae91c680b199f8c9b8d3dbd8d96719_2.file.layout-both-columns.tpl.php:74 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_688bca89963334_98279087) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/v1_giftoo_168layouts_layout_left_column_tpl/8d/0f/a6/8d0fa6a125af07e8554a5461801ff205a85e918e_2.file.layout-left-column.tpl.php:28 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_688bca89918cb8_31976545) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/v1_giftoo_168layouts_layout_left_column_tpl/33/cf/b7/33cfb772f37fe9bf7e7da2f4ede7b9ba2ebdb1ff_2.file.product-list.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_688bca898f8023_38089402) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/v1_giftoo_168layouts_layout_left_column_tpl/a5/95/48/a595487cdf0e93c51d790aa7d81fde9f6d267539_2.file.category.tpl.php:29 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_688bca898bc698_82360211) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/Smarty/SmartyCustom.php:112 (fetch) /classes/controller/FrontController.php:771 (fetch) /classes/controller/FrontController.php:753 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
364	SELECT SQL_NO_CACHE COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM ps_product p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_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 ps_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND cp.id_category IN (723, 746, 731, 623, 732, 41, 650) GROUP BY p.id_product) p LEFT JOIN ps_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, 6) AND sp.id_group IN (0, 1) AND sp.from_quantity = 1 AND sp.reduction > 0 AND sp.id_customer = 0 AND sp.id_cart = 0 AND (sp.from = '0000-00-00 00:00:00' OR '2025-07-31 23:35:25' >= sp.from) AND (sp.to = '0000-00-00 00:00:00' OR '2025-07-31 23:35:25' <= sp.to) ) WHERE ((sp.reduction>0))	0.704 ms	4			/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:778 (execute) /modules/ps_facetedsearch/src/Adapter/MySQL.php:757 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:605 (count) /modules/ps_facetedsearch/src/Filters/Block.php:143 (getHighlightsBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
339	SELECT SQL_NO_CACHE p., product_shop., stock.out_of_stock, IFNULL(stock.quantity, 0) AS quantity, IFNULL(product_attribute_shop.id_product_attribute, 0) AS id_product_attribute, product_attribute_shop.minimal_quantity AS product_attribute_minimal_quantity, pl.`description`, pl.`description_short`, pl.`available_now`, pl.`available_later`, pl.`link_rewrite`, pl.`meta_description`, pl.`meta_keywords`, pl.`meta_title`, pl.`name`, image_shop.`id_image` id_image, il.`legend` as legend, m.`name` AS manufacturer_name, cl.`name` AS category_default, DATEDIFF(product_shop.`date_add`, DATE_SUB("2025-07-31 00:00:00", INTERVAL 1000 DAY)) > 0 AS new, product_shop.price AS orderprice FROM `ps_category_product` cp LEFT JOIN `ps_product` p ON p.`id_product` = cp.`id_product` INNER JOIN ps_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) LEFT JOIN `ps_product_attribute_shop` product_attribute_shop ON (p.`id_product` = product_attribute_shop.`id_product` AND product_attribute_shop.`default_on` = 1 AND product_attribute_shop.id_shop=1) LEFT JOIN ps_stock_available stock ON (stock.id_product = `p`.id_product AND stock.id_product_attribute = 0 AND stock.id_shop = 1 AND stock.id_shop_group = 0 ) LEFT JOIN `ps_category_lang` cl ON (product_shop.`id_category_default` = cl.`id_category` AND cl.`id_lang` = 1 AND cl.id_shop = 1 ) LEFT JOIN `ps_product_lang` pl ON (p.`id_product` = pl.`id_product` AND pl.`id_lang` = 1 AND pl.id_shop = 1 ) LEFT JOIN `ps_image_shop` image_shop ON (image_shop.`id_product` = p.`id_product` AND image_shop.cover=1 AND image_shop.id_shop=1) LEFT JOIN `ps_image_lang` il ON (image_shop.`id_image` = il.`id_image` AND il.`id_lang` = 1) LEFT JOIN `ps_manufacturer` m ON m.`id_manufacturer` = p.`id_manufacturer` WHERE product_shop.`id_shop` = 1 AND cp.`id_category` = 2 AND product_shop.`active` = 1 AND product_shop.`visibility` IN ("both", "catalog") ORDER BY cp.`position` ASC LIMIT 0,12	0.664 ms	1			/classes/Category.php:1062 /modules/ps_facebook/classes/Provider/EventDataProvider.php:214 (getProducts) /modules/ps_facebook/classes/Provider/EventDataProvider.php:117 (getCategoryPageData) /modules/ps_facebook/classes/Dispatcher/EventDispatcher.php:90 (generateEventData) /modules/ps_facebook/ps_facebook.php:321 (dispatch) /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) /controllers/front/listing/CategoryController.php:127 (initContent) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
365	SELECT SQL_NO_CACHE psi.price_min, MIN(price_min) as min, MAX(price_max) as max FROM ps_product p INNER JOIN ps_layered_price_index psi ON (psi.id_product = p.id_product AND psi.id_shop = 1 AND psi.id_currency = 1 AND psi.id_country = 6) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND cp.id_category IN (723, 746, 731, 623, 732, 41, 650)	0.660 ms	62			/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:57 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:250 (getMinMaxPriceValue) /modules/ps_facetedsearch/src/Filters/Block.php:131 (getPriceRangeBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
382	REPLACE INTO ps_layered_filter_block (hash, data) VALUES ("36edea5671a4353f5ad94b07684fce95", "a:1:{s:7:\"filters\";a:7:{i:0;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:14:\"Disponibilidad\";s:6:\"values\";a:2:{i:2;a:2:{s:4:\"name\";s:8:\"En stock\";s:3:\"nbr\";i:54;}i:0;a:2:{s:4:\"name\";s:13:\"No disponible\";s:3:\"nbr\";i:3;}}s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";s:1:\"0\";}i:1;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:10:\"Selections\";s:6:\"values\";a:3:{s:4:\"sale\";a:2:{s:4:\"name\";s:9:\"En oferta\";s:3:\"nbr\";i:21;}s:3:\"new\";a:2:{s:4:\"name\";s:5:\"Nuevo\";s:3:\"nbr\";i:54;}s:8:\"discount\";a:2:{s:4:\"name\";s:10:\"Discounted\";s:3:\"nbr\";i:0;}}s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";s:1:\"0\";}i:2;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:6:\"Precio\";s:3:\"max\";d:9;s:3:\"min\";d:2;s:4:\"unit\";s:3:\"€\";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:\"EUR\";s:14:\"currencySymbol\";s:3:\"€\";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:54;s:5:\"value\";N;}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:11:\"Categorías\";s:6:\"values\";a:122:{i:10;a:2:{s:4:\"name\";s:32:\"Herramientas, Brico y Automóvil\";s:3:\"nbr\";s:3:\"168\";}i:11;a:2:{s:4:\"name\";s:11:\"Agricultura\";s:3:\"nbr\";s:2:\"56\";}i:12;a:2:{s:4:\"name\";s:40:\"Vino, Accesorios de Bebida y Hostelería\";s:3:\"nbr\";s:3:\"227\";}i:13;a:2:{s:4:\"name\";s:24:\"Tecnología y Accesorios\";s:3:\"nbr\";s:3:\"552\";}i:14;a:2:{s:4:\"name\";s:18:\"Oficina y Negocios\";s:3:\"nbr\";s:3:\"429\";}i:15;a:2:{s:4:\"name\";s:22:\"Artículos Sostenibles\";s:3:\"nbr\";s:4:\"1629\";}i:16;a:2:{s:4:\"name\";s:9:\"Escritura\";s:3:\"nbr\";s:3:\"349\";}i:17;a:2:{s:4:\"name\";s:6:\"Outlet\";s:3:\"nbr\";s:3:\"222\";}i:18;a:2:{s:4:\"name\";s:18:\"Regalos y Premiums\";s:3:\"nbr\";s:3:\"411\";}i:19;a:2:{s:4:\"name\";s:14:\"Verano y Playa\";s:3:\"nbr\";s:3:\"274\";}i:20;a:2:{s:4:\"name\";s:22:\"Tazas, Jarras y Termos\";s:3:\"nbr\";s:3:\"417\";}i:21;a:2:{s:4:\"name\";s:16:\"Eventos y Fiesta\";s:3:\"nbr\";s:3:\"151\";}i:22;a:2:{s:4:\"name\";s:9:\"Take Away\";s:3:\"nbr\";s:3:\"107\";}i:23;a:2:{s:4:\"name\";s:8:\"Infantil\";s:3:\"nbr\";s:3:\"250\";}i:24;a:2:{s:4:\"name\";s:8:\"Mochilas\";s:3:\"nbr\";s:3:\"209\";}i:25;a:2:{s:4:\"name\";s:18:\"Gorras y Sombreros\";s:3:\"nbr\";s:3:\"118\";}i:26;a:2:{s:4:\"name\";s:12:\"Sublimación\";s:3:\"nbr\";s:3:\"127\";}i:27;a:2:{s:4:\"name\";s:6:\"Bolsas\";s:3:\"nbr\";s:3:\"207\";}i:28;a:2:{s:4:\"name\";s:5:\"Mujer\";s:3:\"nbr\";s:2:\"58\";}i:29;a:2:{s:4:\"name\";s:25:\"Cuidado Personal y Pharma\";s:3:\"nbr\";s:3:\"211\";}i:30;a:2:{s:4:\"name\";s:23:\"Productos para mascotas\";s:3:\"nbr\";s:2:\"40\";}i:31;a:2:{s:4:\"name\";s:18:\"Deporte y Aventura\";s:3:\"nbr\";s:3:\"137\";}i:32;a:2:{s:4:\"name\";s:5:\"Viaje\";s:3:\"nbr\";s:2:\"89\";}i:33;a:2:{s:4:\"name\";s:19:\"Hogar y Decoración\";s:3:\"nbr\";s:3:\"285\";}i:34;a:2:{s:4:\"name\";s:13:\"Lluvia y Frio\";s:3:\"nbr\";s:3:\"110\";}i:35;a:2:{s:4:\"name\";s:10:\"Spain Line\";s:3:\"nbr\";s:2:\"18\";}i:36;a:2:{s:4:\"name\";s:17:\"Embalaje Especial\";s:3:\"nbr\";s:2:\"66\";}i:37;a:2:{s:4:\"name\";s:7:\"Navidad\";s:3:\"nbr\";s:2:\"69\";}i:38;a:2:{s:4:\"name\";s:19:\"Ocio y tiempo libre\";s:3:\"nbr\";s:2:\"68\";}i:39;a:2:{s:4:\"name\";s:6:\"Textil\";s:3:\"nbr\";s:3:\"182\";}i:40;a:2:{s:4:\"name\";s:6:\"Marcas\";s:3:\"nbr\";s:2:\"57\";}i:41;a:3:{s:4:\"name\";s:9:\"USB STOCK\";s:3:\"nbr\";s:2:\"33\";s:7:\"checked\";b:1;}i:42;a:2:{s:4:\"name\";s:33:\"Colección protección higiénica\";s:3:\"nbr\";s:2:\"28\";}i:43;a:2:{s:4:\"name\";s:13:\"Antibacterial\";s:3:\"nbr\";s:2:\"23\";}i:44;a:2:{s:4:\"name\";s:14:\"Made in europe\";s:3:\"nbr\";s:2:\"40\";}i:45;a:2:{s:4:\"name\";s:15:\"Limited Edition\";s:3:\"nbr\";s:2:\"22\";}i:46;a:2:{s:4:\"name\";s:9:\"Novedades\";s:3:\"nbr\";s:3:\"387\";}i:116;a:2:{s:4:\"name\";s:17:\"Terraza y Jardín\";s:3:\"nbr\";s:4:\"2176\";}i:121;a:2:{s:4:\"name\";s:5:\"Hogar\";s:3:\"nbr\";s:4:\"3135\";}i:134;a:2:{s:4:\"name\";s:15:\"Deportes y Ocio\";s:3:\"nbr\";s:3:\"642\";}i:146;a:2:{s:4:\"name\";s:11:\"Ferretería\";s:3:\"nbr\";s:3:\"296\";}i:169;a:2:{s:4:\"name\";s:7:\"Oficina\";s:3:\"nbr\";s:3:\"565\";}i:203;a:2:{s:4:\"name\";s:23:\"Infantil y Puericultura\";s:3:\"nbr\";s:3:\"483\";}i:214;a:2:{s:4:\"name\";s:8:\"Mascotas\";s:3:\"nbr\";s:4:\"1170\";}i:227;a:2:{s:4:\"name\";s:20:\"Juguetes y Aficiones\";s:3:\"nbr\";s:3:\"673\";}i:230;a:2:{s:4:\"name\";s:32:\"Jaula grande exterior para gatos\";s:3:\"nbr\";s:1:\"1\";}i:251;a:2:{s:4:\"name\";s:20:\"Sombrilla reclinable\";s:3:\"nbr\";s:1:\"2\";}i:266;a:2:{s:4:\"name\";s:16:\"Jaula para gatos\";s:3:\"nbr\";s:1:\"1\";}i:283;a:2:{s:4:\"name\";s:11:\"Sube y baja\";s:3:\"nbr\";s:1:\"1\";}i:471;a:2:{s:4:\"name\";s:15:\"Juguetes y Ocio\";s:3:\"nbr\";s:1:\"6\";}i:501;a:2:{s:4:\"name\";s:26:\"Conjunto 2 tumbonas ratán\";s:3:\"nbr\";s:1:\"1\";}i:515;a:2:{s:4:\"name\";s:9:\"Temporary\";s:3:\"nbr\";s:1:\"2\";}i:520;a:2:{s:4:\"name\";s:8:\"Deportes\";s:3:\"nbr\";s:1:\"1\";}i:531;a:2:{s:4:\"name\";s:10:\"Categorias\";s:3:\"nbr\";s:4:\"1117\";}i:537;a:2:{s:4:\"name\";s:16:\"Detalles de Boda\";s:3:\"nbr\";s:3:\"242\";}i:553;a:2:{s:4:\"name\";s:11:\"Colecciones\";s:3:\"nbr\";s:1:\"6\";}i:557;a:2:{s:4:\"name\";s:21:\"Llaveros para eventos\";s:3:\"nbr\";s:1:\"3\";}i:572;a:2:{s:4:\"name\";s:16:\"Tumbona plegable\";s:3:\"nbr\";s:2:\"38\";}i:573;a:2:{s:4:\"name\";s:29:\"2 mesillas de noche flotantes\";s:3:\"nbr\";s:2:\"17\";}i:574;a:2:{s:4:\"name\";s:15:\"Rascador grande\";s:3:\"nbr\";s:2:\"34\";}i:575;a:2:{s:4:\"name\";s:19:\"Ventiladores de pie\";s:3:\"nbr\";s:2:\"17\";}i:576;a:2:{s:4:\"name\";s:16:\"Butaca con patas\";s:3:\"nbr\";s:2:\"17\";}i:577;a:2:{s:4:\"name\";s:39:\"Bloques espuma juguete (escalera/rampa)\";s:3:\"nbr\";s:2:\"17\";}i:578;a:2:{s:4:\"name\";s:32:\"Sombrilla de pared (una y media)\";s:3:\"nbr\";s:2:\"17\";}i:579;a:2:{s:4:\"name\";s:25:\"Tractor juguete a pedales\";s:3:\"nbr\";s:2:\"17\";}i:580;a:2:{s:4:\"name\";s:8:\"Aparador\";s:3:\"nbr\";s:2:\"38\";}i:581;a:2:{s:4:\"name\";s:31:\"Tienda de campaña 6-8 personas\";s:3:\"nbr\";s:2:\"17\";}i:582;a:2:{s:4:\"name\";s:26:\"Barrera seguridad mascotas\";s:3:\"nbr\";s:2:\"51\";}i:583;a:2:{s:4:\"name\";s:19:\"Caseta jardín gato\";s:3:\"nbr\";s:2:\"17\";}i:584;a:2:{s:4:\"name\";s:24:\"Jaula pájaros con patas\";s:3:\"nbr\";s:2:\"17\";}i:585;a:2:{s:4:\"name\";s:20:\"Mesa plegable cocina\";s:3:\"nbr\";s:2:\"17\";}i:586;a:2:{s:4:\"name\";s:15:\"Cochecito perro\";s:3:\"nbr\";s:2:\"17\";}i:587;a:2:{s:4:\"name\";s:21:\"Mueble auxiliar baño\";s:3:\"nbr\";s:2:\"17\";}i:588;a:2:{s:4:\"name\";s:19:\"Patinete eléctrico\";s:3:\"nbr\";s:2:\"34\";}i:589;a:2:{s:4:\"name\";s:17:\"Caja herramientas\";s:3:\"nbr\";s:2:\"17\";}i:590;a:2:{s:4:\"name\";s:6:\"Gazebo\";s:3:\"nbr\";s:2:\"34\";}i:591;a:2:{s:4:\"name\";s:28:\"Conjunto 4 sillas de comedor\";s:3:\"nbr\";s:2:\"17\";}i:592;a:2:{s:4:\"name\";s:27:\"Bicicleta-triciclo infantil\";s:3:\"nbr\";s:2:\"17\";}i:593;a:2:{s:4:\"name\";s:18:\"Carrito para playa\";s:3:\"nbr\";s:2:\"17\";}i:594;a:2:{s:4:\"name\";s:31:\"armario-vitrina auxiliar cocina\";s:3:\"nbr\";s:2:\"17\";}i:595;a:2:{s:4:\"name\";s:17:\"Techo para carpas\";s:3:\"nbr\";s:2:\"17\";}i:596;a:2:{s:4:\"name\";s:8:\"Pérgola\";s:3:\"nbr\";s:2:\"17\";}i:597;a:2:{s:4:\"name\";s:25:\"Rascador mediano + caseta\";s:3:\"nbr\";s:2:\"17\";}i:598;a:2:{s:4:\"name\";s:30:\"Mesa plegable cocina con rueda\";s:3:\"nbr\";s:2:\"21\";}i:599;a:2:{s:4:\"name\";s:17:\"Cubierta radiador\";s:3:\"nbr\";s:2:\"21\";}i:600;a:2:{s:4:\"name\";s:11:\"Invernadero\";s:3:\"nbr\";s:2:\"21\";}i:601;a:2:{s:4:\"name\";s:28:\"2 mesitas de noche flotantes\";s:3:\"nbr\";s:2:\"21\";}i:602;a:2:{s:4:\"name\";s:18:\"Chimenea con patas\";s:3:\"nbr\";s:2:\"21\";}i:603;a:2:{s:4:\"name\";s:21:\"Sofá + cama 2 plazas\";s:3:\"nbr\";s:2:\"21\";}i:604;a:2:{s:4:\"name\";s:46:\"Doble pizarra con caballete y acjones infantil\";s:3:\"nbr\";s:2:\"21\";}i:605;a:2:{s:4:\"name\";s:42:\"Jaula doble para conejo con patas exterior\";s:3:\"nbr\";s:2:\"21\";}i:606;a:2:{s:4:\"name\";s:17:\"Pérgola de pared\";s:3:\"nbr\";s:2:\"21\";}i:607;a:2:{s:4:\"name\";s:21:\"Mesita ratán jardín\";s:3:\"nbr\";s:2:\"21\";}i:608;a:2:{s:4:\"name\";s:17:\"Tobogán infantil\";s:3:\"nbr\";s:2:\"21\";}i:609;a:2:{s:4:\"name\";s:16:\"Carpa mosquitera\";s:3:\"nbr\";s:2:\"21\";}i:610;a:2:{s:4:\"name\";s:25:\"Corral metálico mascotas\";s:3:\"nbr\";s:2:\"21\";}i:611;a:2:{s:4:\"name\";s:22:\"Espejo baño + armario\";s:3:\"nbr\";s:2:\"21\";}i:612;a:2:{s:4:\"name\";s:23:\"Mueble tv + estantería\";s:3:\"nbr\";s:2:\"21\";}i:613;a:2:{s:4:\"name\";s:15:\"Corral exterior\";s:3:\"nbr\";s:2:\"21\";}i:614;a:2:{s:4:\"name\";s:14:\"Hidrolimpiador\";s:3:\"nbr\";s:2:\"21\";}i:615;a:2:{s:4:\"name\";s:17:\"Balancín jardín\";s:3:\"nbr\";s:2:\"21\";}i:616;a:2:{s:4:\"name\";s:19:\"Ventilador de techo\";s:3:\"nbr\";s:2:\"21\";}i:617;a:2:{s:4:\"name\";s:25:\"Juegos equilibrios madera\";s:3:\"nbr\";s:2:\"21\";}i:618;a:2:{s:4:\"name\";s:10:\"Marquesina\";s:3:\"nbr\";s:2:\"21\";}i:619;a:2:{s:4:\"name\";s:17:\"Carpa con paredes\";s:3:\"nbr\";s:2:\"21\";}i:620;a:2:{s:4:\"name\";s:14:\"Jaula pájaros\";s:3:\"nbr\";s:2:\"21\";}i:621;a:2:{s:4:\"name\";s:23:\"Cochecito paseo pedales\";s:3:\"nbr\";s:2:\"21\";}i:622;a:2:{s:4:\"name\";s:18:\"Ventiladores torre\";s:3:\"nbr\";s:2:\"21\";}i:623;a:3:{s:4:\"name\";s:16:\"Sofá-cama-perro\";s:3:\"nbr\";s:2:\"21\";s:7:\"checked\";b:1;}i:624;a:2:{s:4:\"name\";s:13:\"Cama plegable\";s:3:\"nbr\";s:2:\"21\";}i:625;a:2:{s:4:\"name\";s:29:\"Mesa auxiliar jardín-balcón\";s:3:\"nbr\";s:2:\"21\";}i:626;a:2:{s:4:\"name\";s:29:\"Almacenar juguetes con ruedas\";s:3:\"nbr\";s:2:\"21\";}i:627;a:2:{s:4:\"name\";s:13:\"Mueble cocina\";s:3:\"nbr\";s:2:\"21\";}i:628;a:2:{s:4:\"name\";s:22:\"Sillón madera jardín\";s:3:\"nbr\";s:2:\"21\";}i:629;a:2:{s:4:\"name\";s:23:\"Estantería baja madera\";s:3:\"nbr\";s:2:\"21\";}i:630;a:2:{s:4:\"name\";s:27:\"Nevera portátil-eléctrica\";s:3:\"nbr\";s:2:\"21\";}i:631;a:2:{s:4:\"name\";s:19:\"Cama elevada perros\";s:3:\"nbr\";s:2:\"21\";}i:632;a:2:{s:4:\"name\";s:11:\"Casa conejo\";s:3:\"nbr\";s:2:\"21\";}i:633;a:2:{s:4:\"name\";s:21:\"Mesa pequeña jardín\";s:3:\"nbr\";s:2:\"21\";}i:634;a:2:{s:4:\"name\";s:22:\"Banco trabajo plegable\";s:3:\"nbr\";s:2:\"21\";}i:635;a:2:{s:4:\"name\";s:18:\"Balancín infantil\";s:3:\"nbr\";s:2:\"21\";}i:636;a:2:{s:4:\"name\";s:14:\"Tocador adulto\";s:3:\"nbr\";s:2:\"21\";}}s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";s:1:\"0\";}i:4;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:5;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:6:\"Estado\";s:6:\"values\";a:3:{s:3:\"new\";a:2:{s:4:\"name\";s:5:\"Nuevo\";s:3:\"nbr\";s:2:\"54\";}s:4:\"used\";a:2:{s:4:\"name\";s:5:\"Usado\";s:3:\"nbr\";i:0;}s:11:\"refurbished\";a:2:{s:4:\"name\";s:15:\"Reacondicionado\";s:3:\"nbr\";i:0;}}s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";s:1:\"0\";}i:6;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:4:\"Peso\";s:3:\"max\";d:0.026;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:54;}}}")	0.621 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) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
12	SELECT SQL_NO_CACHE lower(name) as name FROM `ps_hook` h WHERE (h.active = 1)	0.589 ms	1107			/classes/Hook.php:1388 /classes/Hook.php:817 (getHookStatusByName) /classes/Dispatcher.php:606 (exec) /classes/Dispatcher.php:243 (loadRoutes) /classes/Dispatcher.php:201 (__construct) /index.php:28 (getInstance)
369	SELECT SQL_NO_CACHE pac.id_attribute, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM ps_product p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_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 ps_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND cp.id_category IN (723, 746, 731, 623, 732, 41, 650) GROUP BY p.id_product) p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) INNER JOIN ps_attribute a ON (a.id_attribute = pac.id_attribute) WHERE ((a.id_attribute_group=1)) GROUP BY pac.id_attribute	0.583 ms	800	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) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
383	SELECT SQL_NO_CACHE p., ps., pl.*, sa.out_of_stock, IFNULL(sa.quantity, 0) as quantity, (DATEDIFF( p.`date_add`, DATE_SUB( '2025-07-31 00:00:00', INTERVAL 1000 DAY ) ) > 0) as new FROM ps_product p LEFT JOIN ps_product_lang pl ON pl.id_product = p.id_product AND pl.id_shop = 1 AND pl.id_lang = 1 LEFT JOIN ps_stock_available sa ON sa.id_product = p.id_product AND sa.id_product_attribute = 0 AND sa.id_shop = 1 LEFT JOIN ps_product_shop ps ON ps.id_product = p.id_product AND ps.id_shop = 1 WHERE p.id_product IN (20832,842,20873,977,20914,978,20955,979,20996,980,21037,981)	0.567 ms	12			/classes/ProductAssembler.php:95 /classes/ProductAssembler.php:203 (addMissingProductFieldsForMultipleProducts) /classes/controller/ProductListingFrontController.php:108 (assembleProducts) /classes/controller/ProductListingFrontController.php:379 (prepareMultipleProductsForTemplate) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
853	SELECT SQL_NO_CACHE COUNT(cp.`id_product`) AS total FROM `ps_product` p INNER JOIN ps_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) LEFT JOIN `ps_category_product` cp ON p.`id_product` = cp.`id_product` WHERE cp.`id_category` = 25 AND product_shop.`visibility` IN ("both", "catalog") AND product_shop.`active` = 1 LIMIT 1	0.557 ms	122			/classes/Category.php:991 /src/Adapter/Category/CategoryProductSearchProvider.php:79 (getProducts) /src/Adapter/Category/CategoryProductSearchProvider.php:106 (getProductsOrCount) /modules/tvcmstabproducts/tvcmstabproducts.php:2754 (runQuery) /modules/tvcmsfeaturedproducts/tvcmsfeaturedproducts.php:158 (displayFeaturedProducts) /modules/tvcmsfeaturedproducts/tvcmsfeaturedproducts.php:281 (showFrontSideResult) /classes/Hook.php:1083 (hookdisplayLeftColumn) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:421 (coreCallHook) /classes/Hook.php:989 (callHookOn) /config/smarty.config.inc.php:201 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/dev/smarty/compile/v1_giftoo_168layouts_layout_left_column_tpl/69/81/ba/6981ba7f75ae91c680b199f8c9b8d3dbd8d96719_2.file.layout-both-columns.tpl.php:192 (__call) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/v1_giftoo_168layouts_layout_left_column_tpl/69/81/ba/6981ba7f75ae91c680b199f8c9b8d3dbd8d96719_2.file.layout-both-columns.tpl.php:74 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_688bca89963334_98279087) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/v1_giftoo_168layouts_layout_left_column_tpl/8d/0f/a6/8d0fa6a125af07e8554a5461801ff205a85e918e_2.file.layout-left-column.tpl.php:28 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_688bca89918cb8_31976545) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/v1_giftoo_168layouts_layout_left_column_tpl/33/cf/b7/33cfb772f37fe9bf7e7da2f4ede7b9ba2ebdb1ff_2.file.product-list.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_688bca898f8023_38089402) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/v1_giftoo_168layouts_layout_left_column_tpl/a5/95/48/a595487cdf0e93c51d790aa7d81fde9f6d267539_2.file.category.tpl.php:29 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_688bca898bc698_82360211) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/Smarty/SmartyCustom.php:112 (fetch) /classes/controller/FrontController.php:771 (fetch) /classes/controller/FrontController.php:753 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
685	SELECT SQL_NO_CACHE p., ps., pl.*, sa.out_of_stock, IFNULL(sa.quantity, 0) as quantity, (DATEDIFF( p.`date_add`, DATE_SUB( '2025-07-31 00:00:00', INTERVAL 1000 DAY ) ) > 0) as new FROM ps_product p LEFT JOIN ps_product_lang pl ON pl.id_product = p.id_product AND pl.id_shop = 1 AND pl.id_lang = 1 LEFT JOIN ps_stock_available sa ON sa.id_product = p.id_product AND sa.id_product_attribute = 0 AND sa.id_shop = 1 LEFT JOIN ps_product_shop ps ON ps.id_product = p.id_product AND ps.id_shop = 1 WHERE p.id_product IN (22844)	0.557 ms	1			/classes/ProductAssembler.php:64 /classes/ProductAssembler.php:182 (addMissingProductFields) /modules/tvcmsproductpopup/tvcmsproductpopup.php:390 (assembleProduct) /modules/tvcmsproductpopup/tvcmsproductpopup.php:252 (getNewProducts) /modules/tvcmsproductpopup/tvcmsproductpopup.php:546 (prevHook) /classes/Hook.php:1083 (hookdisplayAfterBodyOpeningTag) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:421 (coreCallHook) /classes/Hook.php:989 (callHookOn) /config/smarty.config.inc.php:201 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/dev/smarty/compile/v1_giftoo_168layouts_layout_left_column_tpl/69/81/ba/6981ba7f75ae91c680b199f8c9b8d3dbd8d96719_2.file.layout-both-columns.tpl.php:116 (__call) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/v1_giftoo_168layouts_layout_left_column_tpl/69/81/ba/6981ba7f75ae91c680b199f8c9b8d3dbd8d96719_2.file.layout-both-columns.tpl.php:54 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_688bca89963334_98279087) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/v1_giftoo_168layouts_layout_left_column_tpl/8d/0f/a6/8d0fa6a125af07e8554a5461801ff205a85e918e_2.file.layout-left-column.tpl.php:28 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_688bca89918cb8_31976545) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/v1_giftoo_168layouts_layout_left_column_tpl/33/cf/b7/33cfb772f37fe9bf7e7da2f4ede7b9ba2ebdb1ff_2.file.product-list.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_688bca898f8023_38089402) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/v1_giftoo_168layouts_layout_left_column_tpl/a5/95/48/a595487cdf0e93c51d790aa7d81fde9f6d267539_2.file.category.tpl.php:29 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_688bca898bc698_82360211) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/Smarty/SmartyCustom.php:112 (fetch) /classes/controller/FrontController.php:771 (fetch) /classes/controller/FrontController.php:753 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
379	SELECT SQL_NO_CACHE pac.id_attribute, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM ps_product p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_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 ps_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND cp.id_category IN (723, 746, 731, 623, 732, 41, 650) GROUP BY p.id_product) p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) INNER JOIN ps_attribute a ON (a.id_attribute = pac.id_attribute) WHERE ((a.id_attribute_group=3)) GROUP BY pac.id_attribute	0.534 ms	600	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) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
381	SELECT SQL_NO_CACHE pac.id_attribute, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM ps_product p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_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 ps_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND cp.id_category IN (723, 746, 731, 623, 732, 41, 650) GROUP BY p.id_product) p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) INNER JOIN ps_attribute a ON (a.id_attribute = pac.id_attribute) WHERE ((a.id_attribute_group=4)) GROUP BY pac.id_attribute	0.521 ms	800	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) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
374	SELECT SQL_NO_CACHE m.*, ml.`description`, ml.`short_description` FROM `ps_manufacturer` m INNER JOIN ps_manufacturer_shop manufacturer_shop ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 1)INNER JOIN `ps_manufacturer_lang` ml ON (m.`id_manufacturer` = ml.`id_manufacturer` AND ml.`id_lang` = 1)WHERE 1 AND m.`active` = 1 ORDER BY m.`name` ASC	0.514 ms	13	Yes		/classes/Manufacturer.php:211 /modules/ps_facetedsearch/src/Filters/Block.php:652 (getManufacturers) /modules/ps_facetedsearch/src/Filters/Block.php:146 (getManufacturersBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
764	SELECT SQL_NO_CACHE p., product_shop., stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, pl.`description`, pl.`description_short`, pl.`available_now`, pl.`available_later`, IFNULL(product_attribute_shop.id_product_attribute, 0) id_product_attribute, pl.`link_rewrite`, pl.`meta_description`, pl.`meta_keywords`, pl.`meta_title`, pl.`name`, image_shop.`id_image` id_image, il.`legend`, m.`name` AS manufacturer_name, DATEDIFF( p.`date_add`, DATE_SUB( "2025-07-31 00:00:00", INTERVAL 1000 DAY ) ) > 0 AS new FROM `ps_product` p INNER JOIN ps_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) LEFT JOIN `ps_product_attribute_shop` product_attribute_shop ON (p.`id_product` = product_attribute_shop.`id_product` AND product_attribute_shop.`default_on` = 1 AND product_attribute_shop.id_shop=1) LEFT JOIN ps_stock_available stock ON (stock.id_product = `p`.id_product AND stock.id_product_attribute = 0 AND stock.id_shop = 1 AND stock.id_shop_group = 0 ) LEFT JOIN `ps_product_lang` pl ON ( p.`id_product` = pl.`id_product` AND pl.`id_lang` = 1 AND pl.id_shop = 1 ) LEFT JOIN `ps_image_shop` image_shop ON (image_shop.`id_product` = p.`id_product` AND image_shop.cover=1 AND image_shop.id_shop=1) LEFT JOIN `ps_image_lang` il ON (image_shop.`id_image` = il.`id_image` AND il.`id_lang` = 1) LEFT JOIN `ps_manufacturer` m ON (m.`id_manufacturer` = p.`id_manufacturer`) WHERE product_shop.`active` = 1 AND product_shop.`show_price` = 1 AND product_shop.`visibility` IN ("both", "catalog") AND p.`id_product` IN (0) AND EXISTS(SELECT 1 FROM `ps_category_product` cp JOIN `ps_category_group` cg ON (cp.id_category = cg.id_category AND cg.`id_group` =1) WHERE cp.`id_product` = p.`id_product`)	0.494 ms	0			/classes/Product.php:3393 /modules/tvcmstabproducts/tvcmstabproducts.php:2863 (getPricesDrop) /modules/tvcmsspecialproducts/tvcmsspecialproducts.php:157 (displaySpecialProducts) /modules/tvcmsspecialproducts/tvcmsspecialproducts.php:268 (showFrontSideResult) /classes/Hook.php:1083 (hookdisplayLeftColumn) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:421 (coreCallHook) /classes/Hook.php:989 (callHookOn) /config/smarty.config.inc.php:201 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/dev/smarty/compile/v1_giftoo_168layouts_layout_left_column_tpl/69/81/ba/6981ba7f75ae91c680b199f8c9b8d3dbd8d96719_2.file.layout-both-columns.tpl.php:192 (__call) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/v1_giftoo_168layouts_layout_left_column_tpl/69/81/ba/6981ba7f75ae91c680b199f8c9b8d3dbd8d96719_2.file.layout-both-columns.tpl.php:74 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_688bca89963334_98279087) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/v1_giftoo_168layouts_layout_left_column_tpl/8d/0f/a6/8d0fa6a125af07e8554a5461801ff205a85e918e_2.file.layout-left-column.tpl.php:28 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_688bca89918cb8_31976545) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/v1_giftoo_168layouts_layout_left_column_tpl/33/cf/b7/33cfb772f37fe9bf7e7da2f4ede7b9ba2ebdb1ff_2.file.product-list.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_688bca898f8023_38089402) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/v1_giftoo_168layouts_layout_left_column_tpl/a5/95/48/a595487cdf0e93c51d790aa7d81fde9f6d267539_2.file.category.tpl.php:29 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_688bca898bc698_82360211) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/Smarty/SmartyCustom.php:112 (fetch) /classes/controller/FrontController.php:771 (fetch) /classes/controller/FrontController.php:753 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
924	SELECT SQL_NO_CACHE p., ps., pl.*, sa.out_of_stock, IFNULL(sa.quantity, 0) as quantity, (DATEDIFF( p.`date_add`, DATE_SUB( '2025-07-31 00:00:00', INTERVAL 1000 DAY ) ) > 0) as new FROM ps_product p LEFT JOIN ps_product_lang pl ON pl.id_product = p.id_product AND pl.id_shop = 1 AND pl.id_lang = 1 LEFT JOIN ps_stock_available sa ON sa.id_product = p.id_product AND sa.id_product_attribute = 0 AND sa.id_shop = 1 LEFT JOIN ps_product_shop ps ON ps.id_product = p.id_product AND ps.id_shop = 1 WHERE p.id_product IN (441)	0.493 ms	1			/classes/ProductAssembler.php:64 /classes/ProductAssembler.php:182 (addMissingProductFields) /modules/tvcmstabproducts/tvcmstabproducts.php:2958 (assembleProduct) /modules/tvcmsbestsellerproducts/tvcmsbestsellerproducts.php:156 (displayBestSellers) /modules/tvcmsbestsellerproducts/tvcmsbestsellerproducts.php:269 (showFrontSideResult) /classes/Hook.php:1083 (hookdisplayLeftColumn) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:421 (coreCallHook) /classes/Hook.php:989 (callHookOn) /config/smarty.config.inc.php:201 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/dev/smarty/compile/v1_giftoo_168layouts_layout_left_column_tpl/69/81/ba/6981ba7f75ae91c680b199f8c9b8d3dbd8d96719_2.file.layout-both-columns.tpl.php:192 (__call) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/v1_giftoo_168layouts_layout_left_column_tpl/69/81/ba/6981ba7f75ae91c680b199f8c9b8d3dbd8d96719_2.file.layout-both-columns.tpl.php:74 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_688bca89963334_98279087) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/v1_giftoo_168layouts_layout_left_column_tpl/8d/0f/a6/8d0fa6a125af07e8554a5461801ff205a85e918e_2.file.layout-left-column.tpl.php:28 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_688bca89918cb8_31976545) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/v1_giftoo_168layouts_layout_left_column_tpl/33/cf/b7/33cfb772f37fe9bf7e7da2f4ede7b9ba2ebdb1ff_2.file.product-list.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_688bca898f8023_38089402) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/v1_giftoo_168layouts_layout_left_column_tpl/a5/95/48/a595487cdf0e93c51d790aa7d81fde9f6d267539_2.file.category.tpl.php:29 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_688bca898bc698_82360211) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/Smarty/SmartyCustom.php:112 (fetch) /classes/controller/FrontController.php:771 (fetch) /classes/controller/FrontController.php:753 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
920	SELECT SQL_NO_CACHE p., ps., pl.*, sa.out_of_stock, IFNULL(sa.quantity, 0) as quantity, (DATEDIFF( p.`date_add`, DATE_SUB( '2025-07-31 00:00:00', INTERVAL 1000 DAY ) ) > 0) as new FROM ps_product p LEFT JOIN ps_product_lang pl ON pl.id_product = p.id_product AND pl.id_shop = 1 AND pl.id_lang = 1 LEFT JOIN ps_stock_available sa ON sa.id_product = p.id_product AND sa.id_product_attribute = 0 AND sa.id_shop = 1 LEFT JOIN ps_product_shop ps ON ps.id_product = p.id_product AND ps.id_shop = 1 WHERE p.id_product IN (15023)	0.491 ms	1			/classes/ProductAssembler.php:64 /classes/ProductAssembler.php:182 (addMissingProductFields) /modules/tvcmstabproducts/tvcmstabproducts.php:2958 (assembleProduct) /modules/tvcmsbestsellerproducts/tvcmsbestsellerproducts.php:156 (displayBestSellers) /modules/tvcmsbestsellerproducts/tvcmsbestsellerproducts.php:269 (showFrontSideResult) /classes/Hook.php:1083 (hookdisplayLeftColumn) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:421 (coreCallHook) /classes/Hook.php:989 (callHookOn) /config/smarty.config.inc.php:201 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/dev/smarty/compile/v1_giftoo_168layouts_layout_left_column_tpl/69/81/ba/6981ba7f75ae91c680b199f8c9b8d3dbd8d96719_2.file.layout-both-columns.tpl.php:192 (__call) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/v1_giftoo_168layouts_layout_left_column_tpl/69/81/ba/6981ba7f75ae91c680b199f8c9b8d3dbd8d96719_2.file.layout-both-columns.tpl.php:74 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_688bca89963334_98279087) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/v1_giftoo_168layouts_layout_left_column_tpl/8d/0f/a6/8d0fa6a125af07e8554a5461801ff205a85e918e_2.file.layout-left-column.tpl.php:28 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_688bca89918cb8_31976545) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/v1_giftoo_168layouts_layout_left_column_tpl/33/cf/b7/33cfb772f37fe9bf7e7da2f4ede7b9ba2ebdb1ff_2.file.product-list.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_688bca898f8023_38089402) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/v1_giftoo_168layouts_layout_left_column_tpl/a5/95/48/a595487cdf0e93c51d790aa7d81fde9f6d267539_2.file.category.tpl.php:29 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_688bca898bc698_82360211) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/Smarty/SmartyCustom.php:112 (fetch) /classes/controller/FrontController.php:771 (fetch) /classes/controller/FrontController.php:753 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
372	SELECT SQL_NO_CACHE fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM ps_product p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_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 ps_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND cp.id_category IN (723, 746, 731, 623, 732, 41, 650) GROUP BY p.id_product) p INNER JOIN ps_feature_product fp ON (p.id_product = fp.id_product) WHERE ((fp.id_feature=1)) GROUP BY fp.id_feature_value	0.490 ms	4	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) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
377	SELECT SQL_NO_CACHE MIN(p.weight) as min, MAX(p.weight) as max FROM ps_product p INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND cp.id_category IN (723, 746, 731, 623, 732, 41, 650)	0.477 ms	62			/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:744 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:339 (getMinMaxValue) /modules/ps_facetedsearch/src/Filters/Block.php:134 (getWeightRangeBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
695	SELECT SQL_NO_CACHE p., ps., pl.*, sa.out_of_stock, IFNULL(sa.quantity, 0) as quantity, (DATEDIFF( p.`date_add`, DATE_SUB( '2025-07-31 00:00:00', INTERVAL 1000 DAY ) ) > 0) as new FROM ps_product p LEFT JOIN ps_product_lang pl ON pl.id_product = p.id_product AND pl.id_shop = 1 AND pl.id_lang = 1 LEFT JOIN ps_stock_available sa ON sa.id_product = p.id_product AND sa.id_product_attribute = 0 AND sa.id_shop = 1 LEFT JOIN ps_product_shop ps ON ps.id_product = p.id_product AND ps.id_shop = 1 WHERE p.id_product IN (22842)	0.471 ms	1			/classes/ProductAssembler.php:64 /classes/ProductAssembler.php:182 (addMissingProductFields) /modules/tvcmsproductpopup/tvcmsproductpopup.php:390 (assembleProduct) /modules/tvcmsproductpopup/tvcmsproductpopup.php:252 (getNewProducts) /modules/tvcmsproductpopup/tvcmsproductpopup.php:546 (prevHook) /classes/Hook.php:1083 (hookdisplayAfterBodyOpeningTag) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:421 (coreCallHook) /classes/Hook.php:989 (callHookOn) /config/smarty.config.inc.php:201 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/dev/smarty/compile/v1_giftoo_168layouts_layout_left_column_tpl/69/81/ba/6981ba7f75ae91c680b199f8c9b8d3dbd8d96719_2.file.layout-both-columns.tpl.php:116 (__call) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/v1_giftoo_168layouts_layout_left_column_tpl/69/81/ba/6981ba7f75ae91c680b199f8c9b8d3dbd8d96719_2.file.layout-both-columns.tpl.php:54 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_688bca89963334_98279087) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/v1_giftoo_168layouts_layout_left_column_tpl/8d/0f/a6/8d0fa6a125af07e8554a5461801ff205a85e918e_2.file.layout-left-column.tpl.php:28 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_688bca89918cb8_31976545) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/v1_giftoo_168layouts_layout_left_column_tpl/33/cf/b7/33cfb772f37fe9bf7e7da2f4ede7b9ba2ebdb1ff_2.file.product-list.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_688bca898f8023_38089402) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/v1_giftoo_168layouts_layout_left_column_tpl/a5/95/48/a595487cdf0e93c51d790aa7d81fde9f6d267539_2.file.category.tpl.php:29 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_688bca898bc698_82360211) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/Smarty/SmartyCustom.php:112 (fetch) /classes/controller/FrontController.php:771 (fetch) /classes/controller/FrontController.php:753 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)

Name	Instances	Source
Category	324	/controllers/front/listing/CategoryController.php:78 (__construct) [id: 2] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 230] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 515] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 520] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 531] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 537] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 553] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 557] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 572] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 573] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 574] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 575] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 576] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 577] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 578] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 579] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 580] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 581] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 582] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 583] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 584] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 585] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 586] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 587] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 588] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 589] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 590] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 591] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 592] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 593] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 594] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 595] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 596] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 597] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 598] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 599] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 600] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 601] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 602] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 603] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 604] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 605] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 606] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 607] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 608] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 609] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 610] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 611] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 612] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 613] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 614] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 615] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 616] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 617] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 618] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 619] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 620] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 621] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 622] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 623] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 624] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 625] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 626] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 627] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 628] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 629] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 630] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 631] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 632] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 633] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 634] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 635] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 636] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 637] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 638] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 639] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 640] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 641] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 642] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 643] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 644] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 645] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 646] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 647] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 648] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 649] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 650] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 651] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 652] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 653] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 654] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 655] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 656] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 657] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 658] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 659] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 660] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 661] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 662] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 663] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 664] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 665] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 666] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 667] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 668] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 669] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 670] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 671] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 672] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 673] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 674] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 675] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 676] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 677] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 678] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 679] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 680] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 681] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 682] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 683] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 684] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 685] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 686] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 687] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 688] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 689] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 690] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 691] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 692] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 693] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 694] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 695] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 696] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 697] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 698] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 699] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 700] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 701] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 702] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 703] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 704] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 705] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 706] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 707] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 708] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 709] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 710] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 711] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 712] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 713] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 714] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 715] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 716] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 717] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 718] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 719] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 720] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 721] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 722] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 723] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 724] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 725] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 726] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 727] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 728] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 729] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 730] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 731] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 732] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 733] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 734] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 735] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 736] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 737] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 738] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 739] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 740] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 741] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 742] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 743] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 744] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 745] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 746] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 747] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 748] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 749] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 750] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 751] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 752] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 753] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 754] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 755] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 756] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 757] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 758] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 759] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 760] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 761] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 762] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 763] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 764] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 765] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 766] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 767] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 768] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 769] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 770] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 771] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 772] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 773] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 774] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 775] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 776] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 777] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 778] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 779] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 780] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 781] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 782] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 783] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 784] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 785] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 786] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 787] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 788] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 789] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 793] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 798] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 800] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 802] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 804] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 251] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 266] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 10] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 283] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 471] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 501] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 116] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 121] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 134] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 146] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 169] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 203] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 214] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 227] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 11] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 12] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 13] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 14] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 15] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 16] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 17] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 18] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 19] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 20] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 21] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 22] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 23] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 24] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 25] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 26] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 27] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 28] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 29] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 30] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 31] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 32] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 33] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 34] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 35] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 36] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 37] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 38] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 39] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 40] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 41] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 42] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 43] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 44] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 45] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 46] /classes/Meta.php:380 (__construct) [id: 2] /classes/PrestaShopCollection.php:385 (hydrateCollection) [id: ] /classes/Link.php:402 (__construct) [id: 2] /classes/PrestaShopCollection.php:385 (hydrateCollection) [id: ] /classes/Link.php:402 (__construct) [id: 2] /modules/ps_facetedsearch/src/Filters/Block.php:157 (__construct) [id: 2] /modules/tvcmsmegamenu/tvcmsmegamenu.php:1397 (__construct) [id: 121] /modules/tvcmsmegamenu/tvcmsmegamenu.php:1776 (__construct) [id: 121] /classes/Link.php:402 (__construct) [id: 121] /modules/tvcmsmegamenu/tvcmsmegamenu.php:1701 (__construct) [id: 121] /modules/tvcmsmegamenu/tvcmsmegamenu.php:1397 (__construct) [id: 116] /modules/tvcmsmegamenu/tvcmsmegamenu.php:1776 (__construct) [id: 116] /classes/Link.php:402 (__construct) [id: 116] /modules/tvcmsmegamenu/tvcmsmegamenu.php:1701 (__construct) [id: 116] /modules/tvcmsmegamenu/tvcmsmegamenu.php:1397 (__construct) [id: 146] /modules/tvcmsmegamenu/tvcmsmegamenu.php:1776 (__construct) [id: 146] /classes/Link.php:402 (__construct) [id: 146] /modules/tvcmsmegamenu/tvcmsmegamenu.php:1701 (__construct) [id: 146] /modules/tvcmsmegamenu/tvcmsmegamenu.php:1397 (__construct) [id: 214] /modules/tvcmsmegamenu/tvcmsmegamenu.php:1776 (__construct) [id: 214] /classes/Link.php:402 (__construct) [id: 214] /modules/tvcmsmegamenu/tvcmsmegamenu.php:1701 (__construct) [id: 214] /modules/tvcmsmegamenu/tvcmsmegamenu.php:1397 (__construct) [id: 134] /modules/tvcmsmegamenu/tvcmsmegamenu.php:1776 (__construct) [id: 134] /classes/Link.php:402 (__construct) [id: 134] /modules/tvcmsmegamenu/tvcmsmegamenu.php:1701 (__construct) [id: 134] /modules/tvcmsmegamenu/tvcmsmegamenu.php:1397 (__construct) [id: 227] /modules/tvcmsmegamenu/tvcmsmegamenu.php:1776 (__construct) [id: 227] /classes/Link.php:402 (__construct) [id: 227] /modules/tvcmsmegamenu/tvcmsmegamenu.php:1701 (__construct) [id: 227] /modules/tvcmsmegamenu/tvcmsmegamenu.php:1397 (__construct) [id: 203] /modules/tvcmsmegamenu/tvcmsmegamenu.php:1776 (__construct) [id: 203] /classes/Link.php:402 (__construct) [id: 203] /modules/tvcmsmegamenu/tvcmsmegamenu.php:1701 (__construct) [id: 203] /modules/tvcmsmegamenu/tvcmsmegamenu.php:1397 (__construct) [id: 169] /modules/tvcmsmegamenu/tvcmsmegamenu.php:1776 (__construct) [id: 169] /classes/Link.php:402 (__construct) [id: 169] /modules/tvcmsmegamenu/tvcmsmegamenu.php:1701 (__construct) [id: 169] /modules/tvcmssearch/tvcmssearch.php:100 (getNestedCategories) [id: 2] /modules/ps_categorytree/ps_categorytree.php:371 (__construct) [id: 2] /modules/ps_categorytree/ps_categorytree.php:364 (getParentsCategories) [id: 2] /modules/tvcmstabproducts/tvcmstabproducts.php:2729 (__construct) [id: 25] /classes/Link.php:402 (__construct) [id: 25]
Product	64	/classes/Link.php:113 (__construct) [id: 20832] /classes/Link.php:113 (__construct) [id: 842] /classes/Link.php:113 (__construct) [id: 20873] /classes/Link.php:113 (__construct) [id: 977] /classes/Link.php:113 (__construct) [id: 20914] /classes/Link.php:113 (__construct) [id: 978] /classes/Link.php:113 (__construct) [id: 20955] /classes/Link.php:113 (__construct) [id: 979] /classes/Link.php:113 (__construct) [id: 20996] /classes/Link.php:113 (__construct) [id: 980] /classes/Link.php:113 (__construct) [id: 21037] /classes/Link.php:113 (__construct) [id: 981] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 20832] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 842] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 20873] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 977] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 20914] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 978] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 20955] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 979] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 20996] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 980] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 21037] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 981] /classes/Link.php:113 (__construct) [id: 20832] /classes/Link.php:113 (__construct) [id: 842] /classes/Link.php:113 (__construct) [id: 20873] /classes/Link.php:113 (__construct) [id: 977] /classes/Link.php:113 (__construct) [id: 20914] /classes/Link.php:113 (__construct) [id: 978] /classes/Link.php:113 (__construct) [id: 20955] /classes/Link.php:113 (__construct) [id: 979] /classes/Link.php:113 (__construct) [id: 20996] /classes/Link.php:113 (__construct) [id: 980] /classes/Link.php:113 (__construct) [id: 21037] /classes/Link.php:113 (__construct) [id: 981] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 22845] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 22844] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 22843] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 22842] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 22841] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 22845] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 22844] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 22843] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 22842] /classes/Link.php:113 (__construct) [id: 771] /classes/Link.php:113 (__construct) [id: 2102] /classes/Link.php:113 (__construct) [id: 1710] /classes/Link.php:113 (__construct) [id: 3410] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 771] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 2102] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 1710] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 3410] /classes/Link.php:113 (__construct) [id: 19321] /classes/Link.php:113 (__construct) [id: 441] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 19321] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 15023] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 441] /src/Adapter/Presenter/Product/ProductLazyArray.php:658 (__construct) [id: 842] /src/Adapter/Presenter/Product/ProductLazyArray.php:658 (__construct) [id: 977] /src/Adapter/Presenter/Product/ProductLazyArray.php:658 (__construct) [id: 978] /src/Adapter/Presenter/Product/ProductLazyArray.php:658 (__construct) [id: 979] /src/Adapter/Presenter/Product/ProductLazyArray.php:658 (__construct) [id: 980] /src/Adapter/Presenter/Product/ProductLazyArray.php:658 (__construct) [id: 981]
Combination	11	/classes/Product.php:5912 (__construct) [id: 4275] /classes/Product.php:5912 (__construct) [id: 4713] /classes/Product.php:5912 (__construct) [id: 4715] /classes/Product.php:5912 (__construct) [id: 4722] /classes/Product.php:5912 (__construct) [id: 4724] /classes/Product.php:5912 (__construct) [id: 4725] /classes/Product.php:5912 (__construct) [id: 3981] /classes/Product.php:5912 (__construct) [id: 8524] /classes/Product.php:5912 (__construct) [id: 7446] /classes/Product.php:5912 (__construct) [id: 11248] /classes/Product.php:5912 (__construct) [id: 2584]
Country	8	/config/config.inc.php:146 (__construct) [id: 6] /classes/controller/FrontController.php:354 (__construct) [id: 6] /classes/AddressFormat.php:404 (__construct) [id: 6] /classes/controller/FrontController.php:1779 (__construct) [id: 6] /classes/AddressFormat.php:404 (__construct) [id: 6] /modules/ps_contactinfo/ps_contactinfo.php:105 (__construct) [id: 6] /classes/AddressFormat.php:404 (__construct) [id: 6] /modules/ps_contactinfo/ps_contactinfo.php:105 (__construct) [id: 6]
State	5	/classes/controller/FrontController.php:1778 (__construct) [id: 369] /modules/ps_contactinfo/ps_contactinfo.php:94 (__construct) [id: 369] /modules/ps_contactinfo/ps_contactinfo.php:104 (__construct) [id: 369] /modules/ps_contactinfo/ps_contactinfo.php:94 (__construct) [id: 369] /modules/ps_contactinfo/ps_contactinfo.php:104 (__construct) [id: 369]
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: ]
AddressFormat	3	/classes/controller/FrontController.php:1773 (generateAddress) [id: ] /modules/ps_contactinfo/ps_contactinfo.php:91 (generateAddress) [id: ] /modules/ps_contactinfo/ps_contactinfo.php:91 (generateAddress) [id: ]
Tax	2	/classes/tax/TaxRulesTaxManager.php:116 (__construct) [id: 1] /classes/tax/TaxRulesTaxManager.php:116 (__construct) [id: 1]
Language	2	/config/config.inc.php:211 (__construct) [id: 1] /classes/Tools.php:560 (__construct) [id: 1]
Currency	2	/src/Adapter/Currency/CurrencyDataProvider.php:101 (__construct) [id: 1] /classes/Tools.php:695 (getCurrencyInstance) [id: 1]
Cart	2	/classes/controller/FrontController.php:467 (__construct) [id: ] /classes/controller/FrontController.php:541 (__construct) [id: ]
Shop	1	/config/config.inc.php:117 (initialize) [id: 1]
Connection	1	/modules/statsdata/statsdata.php:118 (setPageConnection) [id: ]
Guest	1	/modules/statsdata/statsdata.php:82 (setNewGuest) [id: ]
TvcmsMegaMenuClass	1	/modules/tvcmsmegamenu/tvcmsmegamenu.php:1386 (__construct) [id: ]
Risk	1	/classes/controller/FrontController.php:1705 (__construct) [id: ]
Gender	1	/classes/controller/FrontController.php:1702 (__construct) [id: 0]
Group	1	/classes/Cart.php:249 (getCurrent) [id: 1]
Customer	1	/config/config.inc.php:264 (__construct) [id: ]
ShopGroup	1	/classes/shop/Shop.php:561 (__construct) [id: 1]
ConnectionsSource	1	/modules/statsdata/statsdata.php:119 (logHttpReferer) [id: ]

#	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

Joyero Mujer

Mesa de Bar

Soporte para Impresora

Biombo

Butaca de Salón

Carrito

Memoria USB Rebik 16GB

Memoria USB Rebik 16GB

Memoria USB Rebik 16GB

Memoria USB Rebik 16GB

Memoria USB Drelan 8GB

Memoria USB Drelan 8GB

Memoria USB Drelan 8GB

Memoria USB Drelan 8GB

Memoria USB Fixing 16GB

Memoria USB Fixing 16GB

Memoria USB Fixing 16GB

Memoria USB Fixing 16GB

Memoria USB Ditop 16GB

Memoria USB Ditop 16GB

Memoria USB Ditop 16GB

Memoria USB Ditop 16GB

Memoria USB Sondy 16GB

Memoria USB Sondy 16GB

Memoria USB Sondy 16GB

Memoria USB Sondy 16GB

Bolígrafo Puntero USB Sivart 16GB

Bolígrafo Puntero USB Sivart 16GB

Bolígrafo Puntero USB Sivart 16GB

Bolígrafo Puntero USB Sivart 16GB

Stopwatch SQL - 1128 queries

Doubles

Tables stress

ObjectModel instances

Included Files