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

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	2159 ms
Querying Time	1486 ms
Queries	1085
Memory Peak Usage	34.7 Mb
Included Files	1254 files - 14.29 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
- global $_COOKIE	1k

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.056 ms	21.056 ms	2.99 Mb	3.3 Mb
__construct	0.011 ms	21.067 ms	- Mb	3.3 Mb
init	102.796 ms	123.863 ms	3.07 Mb	6.5 Mb
checkAccess	0.002 ms	123.865 ms	- Mb	6.5 Mb
setMedia	8.507 ms	132.372 ms	0.20 Mb	6.5 Mb
postProcess	0.002 ms	132.374 ms	- Mb	6.5 Mb
initHeader	0.000 ms	132.374 ms	- Mb	6.5 Mb
initContent	957 ms	1089 ms	5.90 Mb	12.3 Mb
initFooter	0.002 ms	1089 ms	- Mb	12.3 Mb
display	1070 ms	2159 ms	21.18 Mb	34.7 Mb

Hook	Time	Memory Usage
DisplayLeftColumn	439.565 ms	5.82 Mb
=> tvcmsnewproducts	341.918 ms	0.89 Mb
=> tvcmscustomerservices	0.926 ms	0.08 Mb
=> tvcmsspecialproducts	2.735 ms	0.14 Mb
=> tvcmsfeaturedproducts	66.580 ms	3.03 Mb
=> tvcmsbestsellerproducts	27.406 ms	1.68 Mb
DisplayAfterBodyOpeningTag	361.577 ms	2.75 Mb
=> tvcmscookiesnotice	0.897 ms	0.02 Mb
=> blockreassurance	0.004 ms	- Mb
=> tvcmsproductpopup	360.676 ms	2.73 Mb
DisplayHeader	186.894 ms	0.56 Mb
=> ps_shoppingcart	0.074 ms	- Mb
=> ps_searchbar	0.893 ms	- Mb
=> ps_imageslider	0.424 ms	- Mb
=> productcomments	0.442 ms	- Mb
=> psxmarketingwithgoogle	3.511 ms	0.01 Mb
=> ps_googleanalytics	1.653 ms	0.02 Mb
=> tvcmsbestsellerproducts	0.142 ms	- Mb
=> tvcmsblog	0.704 ms	- Mb
=> tvcmsblogdisplayposts	0.450 ms	- Mb
=> tvcmsbrandlist	0.333 ms	- Mb
=> tvcmscategorychainslider	0.334 ms	- Mb
=> tvcmscategoryslider	0.334 ms	- Mb
=> tvcmscookiesnotice	0.349 ms	- Mb
=> tvcmscustomerservices	0.337 ms	- Mb
=> tvcmscustomsetting	2.088 ms	0.01 Mb
=> tvcmsfeaturedproducts	0.146 ms	- Mb
=> tvcmsfooterlogo	0.001 ms	- Mb
=> tvcmsfooterproduct	0.186 ms	- Mb
=> tvcmsnewproducts	0.132 ms	- Mb
=> tvcmsnewsletterpopup	0.682 ms	- Mb
=> tvcmspaymenticon	0.002 ms	- Mb
=> tvcmsproductcomments	1.265 ms	- Mb
=> tvcmsproductcompare	0.335 ms	- Mb
=> tvcmsproductpopup	0.343 ms	- Mb
=> tvcmssearch	0.923 ms	- Mb
=> tvcmssizechart	0.344 ms	- Mb
=> tvcmsslider	0.333 ms	- Mb
=> tvcmsspecialproducts	0.132 ms	- Mb
=> tvcmsstoretime	0.439 ms	- Mb
=> tvcmstabproducts	0.366 ms	- Mb
=> tvcmstestimonial	0.340 ms	- Mb
=> tvcmsthemeoptions	1.006 ms	- Mb
=> tvcmsvideoblock	0.334 ms	- Mb
=> tvcmswishlist	0.357 ms	- Mb
=> smartargetwhatsapp	0.802 ms	0.01 Mb
=> ps_facebook	166.357 ms	0.46 Mb
DisplayReviewProductList	49.306 ms	3.77 Mb
=> tvcmsproductcomments	1.649 ms	0.12 Mb
=> tvcmsproductcomments	1.040 ms	0.07 Mb
=> tvcmsproductcomments	1.183 ms	0.07 Mb
=> tvcmsproductcomments	1.031 ms	0.07 Mb
=> tvcmsproductcomments	1.197 ms	0.11 Mb
=> tvcmsproductcomments	1.007 ms	0.07 Mb
=> tvcmsproductcomments	0.960 ms	0.07 Mb
=> tvcmsproductcomments	0.878 ms	0.06 Mb
=> tvcmsproductcomments	1.110 ms	0.11 Mb
=> tvcmsproductcomments	0.949 ms	0.07 Mb
=> tvcmsproductcomments	0.922 ms	0.07 Mb
=> tvcmsproductcomments	0.875 ms	0.06 Mb
=> tvcmsproductcomments	1.171 ms	0.11 Mb
=> tvcmsproductcomments	0.916 ms	0.07 Mb
=> tvcmsproductcomments	0.920 ms	0.07 Mb
=> tvcmsproductcomments	0.949 ms	0.06 Mb
=> tvcmsproductcomments	1.159 ms	0.11 Mb
=> tvcmsproductcomments	0.977 ms	0.07 Mb
=> tvcmsproductcomments	0.942 ms	0.07 Mb
=> tvcmsproductcomments	0.923 ms	0.06 Mb
=> tvcmsproductcomments	1.152 ms	0.11 Mb
=> tvcmsproductcomments	0.964 ms	0.07 Mb
=> tvcmsproductcomments	0.943 ms	0.07 Mb
=> tvcmsproductcomments	0.903 ms	0.06 Mb
=> tvcmsproductcomments	1.210 ms	0.11 Mb
=> tvcmsproductcomments	1.010 ms	0.07 Mb
=> tvcmsproductcomments	0.955 ms	0.07 Mb
=> tvcmsproductcomments	0.920 ms	0.06 Mb
=> tvcmsproductcomments	1.086 ms	0.11 Mb
=> tvcmsproductcomments	1.003 ms	0.07 Mb
=> tvcmsproductcomments	1.124 ms	0.07 Mb
=> tvcmsproductcomments	1.051 ms	0.06 Mb
=> tvcmsproductcomments	1.229 ms	0.11 Mb
=> tvcmsproductcomments	1.043 ms	0.10 Mb
=> tvcmsproductcomments	0.931 ms	0.07 Mb
=> tvcmsproductcomments	0.946 ms	0.06 Mb
=> tvcmsproductcomments	1.092 ms	0.11 Mb
=> tvcmsproductcomments	0.937 ms	0.07 Mb
=> tvcmsproductcomments	0.888 ms	0.07 Mb
=> tvcmsproductcomments	0.955 ms	0.06 Mb
=> tvcmsproductcomments	1.068 ms	0.11 Mb
=> tvcmsproductcomments	0.938 ms	0.07 Mb
=> tvcmsproductcomments	0.975 ms	0.07 Mb
=> tvcmsproductcomments	0.912 ms	0.06 Mb
=> tvcmsproductcomments	1.165 ms	0.11 Mb
=> tvcmsproductcomments	1.163 ms	0.07 Mb
=> tvcmsproductcomments	1.009 ms	0.07 Mb
=> tvcmsproductcomments	0.976 ms	0.06 Mb
DisplayWishlistBtnProductList	28.882 ms	- Mb
=> tvcmswishlist	0.852 ms	0.01 Mb
=> tvcmswishlist	0.595 ms	- Mb
=> tvcmswishlist	0.627 ms	- Mb
=> tvcmswishlist	0.584 ms	- Mb
=> tvcmswishlist	0.591 ms	- Mb
=> tvcmswishlist	0.587 ms	- Mb
=> tvcmswishlist	0.604 ms	- Mb
=> tvcmswishlist	0.587 ms	- Mb
=> tvcmswishlist	0.599 ms	- Mb
=> tvcmswishlist	0.611 ms	- Mb
=> tvcmswishlist	0.579 ms	- Mb
=> tvcmswishlist	0.598 ms	- Mb
=> tvcmswishlist	0.573 ms	- Mb
=> tvcmswishlist	0.576 ms	- Mb
=> tvcmswishlist	0.588 ms	- Mb
=> tvcmswishlist	0.581 ms	- Mb
=> tvcmswishlist	0.641 ms	- Mb
=> tvcmswishlist	0.577 ms	- Mb
=> tvcmswishlist	0.579 ms	- Mb
=> tvcmswishlist	0.591 ms	- Mb
=> tvcmswishlist	0.583 ms	- Mb
=> tvcmswishlist	0.594 ms	- Mb
=> tvcmswishlist	0.650 ms	- Mb
=> tvcmswishlist	0.594 ms	- Mb
=> tvcmswishlist	0.573 ms	- Mb
=> tvcmswishlist	0.643 ms	- Mb
=> tvcmswishlist	0.595 ms	- Mb
=> tvcmswishlist	0.630 ms	- Mb
=> tvcmswishlist	0.589 ms	- Mb
=> tvcmswishlist	0.646 ms	- Mb
=> tvcmswishlist	0.592 ms	- Mb
=> tvcmswishlist	0.627 ms	- Mb
=> tvcmswishlist	0.587 ms	- Mb
=> tvcmswishlist	0.594 ms	- Mb
=> tvcmswishlist	0.579 ms	- Mb
=> tvcmswishlist	0.599 ms	- Mb
=> tvcmswishlist	0.590 ms	- Mb
=> tvcmswishlist	0.573 ms	- Mb
=> tvcmswishlist	0.590 ms	- Mb
=> tvcmswishlist	0.576 ms	- Mb
=> tvcmswishlist	0.588 ms	- Mb
=> tvcmswishlist	0.576 ms	- Mb
=> tvcmswishlist	0.595 ms	- Mb
=> tvcmswishlist	0.577 ms	- Mb
=> tvcmswishlist	0.592 ms	- Mb
=> tvcmswishlist	0.590 ms	- Mb
=> tvcmswishlist	0.643 ms	- Mb
=> tvcmswishlist	0.598 ms	- Mb
DisplayProductCompareProductList	27.527 ms	0.10 Mb
=> tvcmsproductcompare	0.887 ms	0.01 Mb
=> tvcmsproductcompare	0.566 ms	- Mb
=> tvcmsproductcompare	0.580 ms	- Mb
=> tvcmsproductcompare	0.583 ms	- Mb
=> tvcmsproductcompare	0.581 ms	- Mb
=> tvcmsproductcompare	0.571 ms	- Mb
=> tvcmsproductcompare	0.514 ms	- Mb
=> tvcmsproductcompare	0.574 ms	- Mb
=> tvcmsproductcompare	0.651 ms	- Mb
=> tvcmsproductcompare	0.612 ms	- Mb
=> tvcmsproductcompare	0.531 ms	- Mb
=> tvcmsproductcompare	0.556 ms	- Mb
=> tvcmsproductcompare	0.574 ms	- Mb
=> tvcmsproductcompare	0.575 ms	- Mb
=> tvcmsproductcompare	0.508 ms	- Mb
=> tvcmsproductcompare	0.609 ms	- Mb
=> tvcmsproductcompare	0.559 ms	- Mb
=> tvcmsproductcompare	0.575 ms	- Mb
=> tvcmsproductcompare	0.536 ms	- Mb
=> tvcmsproductcompare	0.575 ms	- Mb
=> tvcmsproductcompare	0.610 ms	- Mb
=> tvcmsproductcompare	0.565 ms	- Mb
=> tvcmsproductcompare	0.561 ms	- Mb
=> tvcmsproductcompare	0.563 ms	- Mb
=> tvcmsproductcompare	0.575 ms	- Mb
=> tvcmsproductcompare	0.583 ms	- Mb
=> tvcmsproductcompare	0.510 ms	- Mb
=> tvcmsproductcompare	0.578 ms	- Mb
=> tvcmsproductcompare	0.578 ms	- Mb
=> tvcmsproductcompare	0.558 ms	- Mb
=> tvcmsproductcompare	0.516 ms	- Mb
=> tvcmsproductcompare	0.568 ms	- Mb
=> tvcmsproductcompare	0.601 ms	- Mb
=> tvcmsproductcompare	0.571 ms	- Mb
=> tvcmsproductcompare	0.533 ms	- Mb
=> tvcmsproductcompare	0.571 ms	- Mb
=> tvcmsproductcompare	0.567 ms	- Mb
=> tvcmsproductcompare	0.572 ms	- Mb
=> tvcmsproductcompare	0.508 ms	- Mb
=> tvcmsproductcompare	0.574 ms	- Mb
=> tvcmsproductcompare	0.575 ms	- Mb
=> tvcmsproductcompare	0.582 ms	- Mb
=> tvcmsproductcompare	0.512 ms	- Mb
=> tvcmsproductcompare	0.573 ms	- Mb
=> tvcmsproductcompare	0.604 ms	- Mb
=> tvcmsproductcompare	0.567 ms	- Mb
=> tvcmsproductcompare	0.573 ms	- Mb
=> tvcmsproductcompare	0.563 ms	- Mb
displayLeftColumn	23.772 ms	1.85 Mb
=> ps_categorytree (widget)	19.558 ms	1.71 Mb
=> ps_brandlist (widget)	2.206 ms	0.07 Mb
=> ps_supplierlist (widget)	2.008 ms	0.07 Mb
DisplayMegamenu	9.855 ms	0.72 Mb
=> tvcmsmegamenu	9.855 ms	0.72 Mb
DisplayProductListStockIndicator	9.744 ms	0.54 Mb
=> tvcmsstockinfo	0.857 ms	0.03 Mb
=> tvcmsstockinfo	0.304 ms	0.01 Mb
=> tvcmsstockinfo	0.296 ms	0.01 Mb
=> tvcmsstockinfo	0.281 ms	0.01 Mb
=> tvcmsstockinfo	0.517 ms	0.05 Mb
=> tvcmsstockinfo	0.509 ms	0.05 Mb
=> tvcmsstockinfo	0.301 ms	0.01 Mb
=> tvcmsstockinfo	0.280 ms	0.01 Mb
=> tvcmsstockinfo	0.306 ms	0.01 Mb
=> tvcmsstockinfo	0.300 ms	0.01 Mb
=> tvcmsstockinfo	0.580 ms	0.05 Mb
=> tvcmsstockinfo	0.622 ms	0.05 Mb
=> tvcmsstockinfo	0.288 ms	0.01 Mb
=> tvcmsstockinfo	0.281 ms	0.01 Mb
=> tvcmsstockinfo	0.290 ms	0.01 Mb
=> tvcmsstockinfo	0.288 ms	0.01 Mb
=> tvcmsstockinfo	0.529 ms	0.05 Mb
=> tvcmsstockinfo	0.528 ms	0.05 Mb
=> tvcmsstockinfo	0.302 ms	0.01 Mb
=> tvcmsstockinfo	0.280 ms	0.01 Mb
=> tvcmsstockinfo	0.316 ms	0.01 Mb
=> tvcmsstockinfo	0.307 ms	0.01 Mb
=> tvcmsstockinfo	0.647 ms	0.05 Mb
=> tvcmsstockinfo	0.535 ms	0.05 Mb
DisplayNavSearchBlock	6.980 ms	1.48 Mb
=> tvcmssearch	6.980 ms	1.48 Mb
Header	4.098 ms	0.11 Mb
=> tvcmsstockinfo	0.448 ms	- Mb
=> tvcmsinfinitescroll	2.422 ms	0.05 Mb
=> tvcmscategoryproduct	0.395 ms	0.02 Mb
=> tvcmsmegamenu	0.384 ms	0.02 Mb
=> tvcmstwoofferbanner	0.449 ms	0.02 Mb
DisplayFooter	4.050 ms	0.14 Mb
=> blockwishlist	3.177 ms	0.13 Mb
=> ps_facebook	0.873 ms	0.01 Mb
DisplayCustomsocialblock	3.635 ms	0.16 Mb
=> tvcmscustomsetting	3.635 ms	0.16 Mb
ActionFrontControllerSetMedia	2.382 ms	0.01 Mb
=> blockreassurance	0.638 ms	- Mb
=> blockwishlist	0.557 ms	- Mb
=> ps_emailsubscription	0.134 ms	- Mb
=> ps_socialfollow	0.226 ms	- Mb
=> psxdesign	0.551 ms	- Mb
=> klaviyopsautomation	0.006 ms	- Mb
=> ps_emailalerts	0.115 ms	- Mb
=> monei	0.004 ms	- Mb
=> ps_facebook	0.151 ms	- Mb
displayFooterPart1	2.107 ms	0.09 Mb
=> ps_linklist (widget)	2.107 ms	0.09 Mb
displaySocialMediaBlock	1.951 ms	0.09 Mb
=> ps_socialfollow (widget)	1.951 ms	0.09 Mb
displayMyaccountcblock	1.943 ms	0.09 Mb
=> ps_customeraccountlinks (widget)	1.943 ms	0.09 Mb
displayNewslettersubscription	1.849 ms	0.09 Mb
=> ps_emailsubscription (widget)	1.849 ms	0.09 Mb
ProductSearchProvider	1.798 ms	0.03 Mb
=> ps_facetedsearch	1.798 ms	0.03 Mb
DisplayBeforeBodyClosingTag	1.577 ms	0.05 Mb
=> statsdata	1.574 ms	0.05 Mb
=> tvcmsblog	0.003 ms	- Mb
DisplayPaymentIcon	1.417 ms	0.04 Mb
=> tvcmspaymenticon	1.417 ms	0.04 Mb
DisplayNavWishlistBlock	1.224 ms	0.04 Mb
=> tvcmswishlist	1.224 ms	0.04 Mb
displayNavShoppingCartBlock	1.217 ms	0.09 Mb
=> ps_shoppingcart (widget)	1.217 ms	0.09 Mb
DisplayNavWishlistBlocksticky	1.184 ms	0.05 Mb
=> tvcmswishlist	1.184 ms	0.05 Mb
displayNav1	1.115 ms	0.09 Mb
=> ps_contactinfo (widget)	1.115 ms	0.09 Mb
displayNavCustomerSignInBlock	0.974 ms	0.05 Mb
=> ps_customersignin (widget)	0.974 ms	0.05 Mb
displayContactCinfo	0.915 ms	0.03 Mb
=> ps_contactinfo (widget)	0.915 ms	0.03 Mb
DisplayDownloadApps	0.892 ms	0.02 Mb
=> tvcmscustomsetting	0.892 ms	0.02 Mb
DisplayProductComparesticky	0.883 ms	0.01 Mb
=> tvcmsproductcompare	0.883 ms	0.01 Mb
DisplayNavProductCompareBlock	0.872 ms	0.01 Mb
=> tvcmsproductcompare	0.872 ms	0.01 Mb
DisplayAfterTitleTag	0.807 ms	0.01 Mb
=> psxdesign	0.807 ms	0.01 Mb
DisplayCopyRightText	0.796 ms	0.01 Mb
=> tvcmscustomsetting	0.796 ms	0.01 Mb
DisplayFacetedSearchBlock	0.726 ms	0.09 Mb
=> ps_facetedsearch	0.726 ms	0.09 Mb
ActionDispatcherBefore	0.716 ms	0.01 Mb
=> psxdesign	0.270 ms	- Mb
=> ps_mbo	0.446 ms	0.01 Mb
displayNavLanguageBlock	0.322 ms	0.05 Mb
=> ps_languageselector (widget)	0.322 ms	0.05 Mb
displayNavCurrencyBlock	0.312 ms	0.05 Mb
=> ps_currencyselector (widget)	0.312 ms	0.05 Mb
ModuleRoutes	0.019 ms	0.01 Mb
=> klaviyopsautomation	0.004 ms	- Mb
=> tvcmsblog	0.014 ms	0.01 Mb
=> simpleimportproduct	0.001 ms	- Mb
DisplayTopOfferText	0.016 ms	- Mb
=> tvcmscustomsetting	0.012 ms	- Mb
=> tvcmscustomsetting	0.004 ms	- Mb
DisplayCustomCss	0.007 ms	- Mb
=> tvcmscustomcssjs	0.007 ms	- Mb
DisplayCustomJs	0.005 ms	- Mb
=> tvcmscustomcssjs	0.005 ms	- Mb
ActionFrontControllerInitAfter	0.004 ms	- Mb
=> klaviyopsautomation	0.004 ms	- Mb
DisplayNavFullWidth	0.004 ms	- Mb
=> blockreassurance	0.004 ms	- Mb
42 hook(s)	1184 ms	19.05 Mb

Module	Time	Memory Usage
klaviyopsautomation	1.647 ms	- Mb
__construct	1.627 ms	- Mb
hookModuleRoutes	0.007 ms	- Mb
hookActionFrontControllerInitAfter	0.006 ms	- Mb
hookActionFrontControllerSetMedia	0.007 ms	- Mb
tvcmsblog	5.389 ms	0.13 Mb
__construct	4.661 ms	0.12 Mb
hookModuleRoutes	0.016 ms	0.01 Mb
hookDisplayHeader	0.707 ms	- Mb
hookDisplayBeforeBodyClosingTag	0.005 ms	- Mb
simpleimportproduct	1.012 ms	0.03 Mb
__construct	1.009 ms	0.02 Mb
hookModuleRoutes	0.003 ms	- Mb
psxdesign	4.855 ms	0.03 Mb
__construct	3.219 ms	0.01 Mb
hookActionDispatcherBefore	0.273 ms	- Mb
hookActionFrontControllerSetMedia	0.553 ms	- Mb
hookDisplayAfterTitleTag	0.810 ms	0.01 Mb
ps_mbo	9.332 ms	0.05 Mb
__construct	8.884 ms	0.04 Mb
hookActionDispatcherBefore	0.448 ms	0.01 Mb
blockreassurance	1.381 ms	0.09 Mb
__construct	0.729 ms	0.08 Mb
hookActionFrontControllerSetMedia	0.641 ms	0.01 Mb
hookDisplayAfterBodyOpeningTag	0.005 ms	- Mb
hookDisplayNavFullWidth	0.006 ms	- Mb
blockwishlist	3.887 ms	0.14 Mb
__construct	0.149 ms	0.01 Mb
hookActionFrontControllerSetMedia	0.559 ms	- Mb
hookDisplayFooter	3.179 ms	0.13 Mb
ps_emailsubscription	2.106 ms	0.10 Mb
__construct	0.121 ms	0.01 Mb
hookActionFrontControllerSetMedia	0.135 ms	- Mb
displayNewslettersubscription	1.850 ms	0.09 Mb
ps_socialfollow	2.279 ms	0.10 Mb
__construct	0.099 ms	0.01 Mb
hookActionFrontControllerSetMedia	0.227 ms	- Mb
displaySocialMediaBlock	1.953 ms	0.09 Mb
ps_emailalerts	0.312 ms	0.01 Mb
__construct	0.196 ms	0.01 Mb
hookActionFrontControllerSetMedia	0.116 ms	- Mb
monei	0.774 ms	0.07 Mb
__construct	0.769 ms	0.06 Mb
hookActionFrontControllerSetMedia	0.005 ms	- Mb
ps_facebook	169.800 ms	0.46 Mb
__construct	2.413 ms	- Mb
hookActionFrontControllerSetMedia	0.153 ms	- Mb
hookDisplayHeader	166.360 ms	0.46 Mb
hookDisplayFooter	0.874 ms	0.01 Mb
ps_shoppingcart	1.412 ms	0.10 Mb
__construct	0.118 ms	0.01 Mb
hookDisplayHeader	0.075 ms	- Mb
displayNavShoppingCartBlock	1.219 ms	0.09 Mb
ps_searchbar	1.055 ms	0.07 Mb
__construct	0.161 ms	0.07 Mb
hookDisplayHeader	0.894 ms	- Mb
ps_imageslider	0.592 ms	0.01 Mb
__construct	0.166 ms	0.01 Mb
hookDisplayHeader	0.426 ms	- Mb
productcomments	0.546 ms	0.01 Mb
__construct	0.102 ms	0.01 Mb
hookDisplayHeader	0.444 ms	- Mb
psxmarketingwithgoogle	3.920 ms	0.01 Mb
__construct	0.407 ms	0.01 Mb
hookDisplayHeader	3.513 ms	0.01 Mb
ps_googleanalytics	1.818 ms	0.03 Mb
__construct	0.163 ms	0.01 Mb
hookDisplayHeader	1.655 ms	0.02 Mb
tvcmsbestsellerproducts	28.027 ms	1.68 Mb
__construct	0.474 ms	0.01 Mb
hookDisplayHeader	0.143 ms	- Mb
hookDisplayLeftColumn	27.410 ms	1.68 Mb
tvcmsblogdisplayposts	0.879 ms	0.01 Mb
__construct	0.427 ms	0.01 Mb
hookDisplayHeader	0.452 ms	- Mb
tvcmsbrandlist	0.719 ms	0.01 Mb
__construct	0.384 ms	0.01 Mb
hookDisplayHeader	0.335 ms	- Mb
tvcmscategorychainslider	0.731 ms	0.01 Mb
__construct	0.396 ms	0.01 Mb
hookDisplayHeader	0.335 ms	- Mb
tvcmscategoryslider	0.724 ms	0.01 Mb
__construct	0.389 ms	0.01 Mb
hookDisplayHeader	0.335 ms	- Mb
tvcmscookiesnotice	1.624 ms	0.03 Mb
__construct	0.375 ms	0.01 Mb
hookDisplayHeader	0.350 ms	- Mb
hookDisplayAfterBodyOpeningTag	0.899 ms	0.02 Mb
tvcmscustomerservices	1.649 ms	0.09 Mb
__construct	0.382 ms	0.01 Mb
hookDisplayHeader	0.339 ms	- Mb
hookDisplayLeftColumn	0.928 ms	0.08 Mb
tvcmscustomsetting	7.913 ms	0.22 Mb
__construct	0.475 ms	0.01 Mb
hookDisplayHeader	2.089 ms	0.01 Mb
hookDisplayTopOfferText	0.014 ms	- Mb
hookDisplayTopOfferText	0.006 ms	- Mb
hookDisplayDownloadApps	0.894 ms	0.02 Mb
hookDisplayCustomsocialblock	3.637 ms	0.16 Mb
hookDisplayCopyRightText	0.798 ms	0.01 Mb
tvcmsfeaturedproducts	67.077 ms	3.04 Mb
__construct	0.344 ms	0.01 Mb
hookDisplayHeader	0.148 ms	- Mb
hookDisplayLeftColumn	66.585 ms	3.03 Mb
tvcmsfooterlogo	0.407 ms	0.01 Mb
__construct	0.404 ms	0.01 Mb
hookDisplayHeader	0.003 ms	- Mb
tvcmsfooterproduct	0.529 ms	0.01 Mb
__construct	0.341 ms	0.01 Mb
hookDisplayHeader	0.188 ms	- Mb
tvcmsnewproducts	342.403 ms	0.90 Mb
__construct	0.348 ms	0.01 Mb
hookDisplayHeader	0.133 ms	- Mb
hookDisplayLeftColumn	341.922 ms	0.89 Mb
tvcmsnewsletterpopup	1.082 ms	0.01 Mb
__construct	0.398 ms	0.01 Mb
hookDisplayHeader	0.684 ms	- Mb
tvcmspaymenticon	1.826 ms	0.05 Mb
__construct	0.404 ms	0.01 Mb
hookDisplayHeader	0.003 ms	- Mb
hookDisplayPaymentIcon	1.419 ms	0.04 Mb
tvcmsproductcomments	51.053 ms	3.80 Mb
__construct	0.359 ms	0.01 Mb
hookDisplayHeader	1.267 ms	- Mb
hookDisplayReviewProductList	1.651 ms	0.12 Mb
hookDisplayReviewProductList	1.042 ms	0.07 Mb
hookDisplayReviewProductList	1.185 ms	0.07 Mb
hookDisplayReviewProductList	1.033 ms	0.07 Mb
hookDisplayReviewProductList	1.199 ms	0.11 Mb
hookDisplayReviewProductList	1.009 ms	0.07 Mb
hookDisplayReviewProductList	0.962 ms	0.07 Mb
hookDisplayReviewProductList	0.880 ms	0.06 Mb
hookDisplayReviewProductList	1.112 ms	0.11 Mb
hookDisplayReviewProductList	0.951 ms	0.07 Mb
hookDisplayReviewProductList	0.955 ms	0.07 Mb
hookDisplayReviewProductList	0.877 ms	0.06 Mb
hookDisplayReviewProductList	1.173 ms	0.11 Mb
hookDisplayReviewProductList	0.917 ms	0.07 Mb
hookDisplayReviewProductList	0.922 ms	0.07 Mb
hookDisplayReviewProductList	0.951 ms	0.06 Mb
hookDisplayReviewProductList	1.160 ms	0.11 Mb
hookDisplayReviewProductList	0.979 ms	0.07 Mb
hookDisplayReviewProductList	0.943 ms	0.07 Mb
hookDisplayReviewProductList	0.925 ms	0.06 Mb
hookDisplayReviewProductList	1.154 ms	0.11 Mb
hookDisplayReviewProductList	0.966 ms	0.07 Mb
hookDisplayReviewProductList	0.945 ms	0.07 Mb
hookDisplayReviewProductList	0.904 ms	0.06 Mb
hookDisplayReviewProductList	1.212 ms	0.11 Mb
hookDisplayReviewProductList	1.012 ms	0.07 Mb
hookDisplayReviewProductList	0.957 ms	0.07 Mb
hookDisplayReviewProductList	0.922 ms	0.06 Mb
hookDisplayReviewProductList	1.088 ms	0.11 Mb
hookDisplayReviewProductList	1.005 ms	0.07 Mb
hookDisplayReviewProductList	1.126 ms	0.07 Mb
hookDisplayReviewProductList	1.053 ms	0.06 Mb
hookDisplayReviewProductList	1.231 ms	0.11 Mb
hookDisplayReviewProductList	1.045 ms	0.10 Mb
hookDisplayReviewProductList	0.933 ms	0.07 Mb
hookDisplayReviewProductList	0.948 ms	0.06 Mb
hookDisplayReviewProductList	1.094 ms	0.11 Mb
hookDisplayReviewProductList	0.939 ms	0.07 Mb
hookDisplayReviewProductList	0.890 ms	0.07 Mb
hookDisplayReviewProductList	0.956 ms	0.06 Mb
hookDisplayReviewProductList	1.070 ms	0.11 Mb
hookDisplayReviewProductList	0.939 ms	0.07 Mb
hookDisplayReviewProductList	0.976 ms	0.07 Mb
hookDisplayReviewProductList	0.913 ms	0.06 Mb
hookDisplayReviewProductList	1.167 ms	0.11 Mb
hookDisplayReviewProductList	1.166 ms	0.07 Mb
hookDisplayReviewProductList	1.011 ms	0.07 Mb
hookDisplayReviewProductList	0.978 ms	0.06 Mb
tvcmsproductcompare	30.029 ms	0.14 Mb
__construct	0.315 ms	0.01 Mb
hookDisplayHeader	0.336 ms	- Mb
hookDisplayNavProductCompareBlock	0.874 ms	0.01 Mb
hookDisplayProductCompareProductList	0.890 ms	0.01 Mb
hookDisplayProductCompareProductList	0.567 ms	- Mb
hookDisplayProductCompareProductList	0.582 ms	- Mb
hookDisplayProductCompareProductList	0.585 ms	- Mb
hookDisplayProductCompareProductList	0.583 ms	- Mb
hookDisplayProductCompareProductList	0.572 ms	- Mb
hookDisplayProductCompareProductList	0.516 ms	- Mb
hookDisplayProductCompareProductList	0.576 ms	- Mb
hookDisplayProductCompareProductList	0.653 ms	- Mb
hookDisplayProductCompareProductList	0.613 ms	- Mb
hookDisplayProductCompareProductList	0.533 ms	- Mb
hookDisplayProductCompareProductList	0.558 ms	- Mb
hookDisplayProductCompareProductList	0.576 ms	- Mb
hookDisplayProductCompareProductList	0.577 ms	- Mb
hookDisplayProductCompareProductList	0.510 ms	- Mb
hookDisplayProductCompareProductList	0.611 ms	- Mb
hookDisplayProductCompareProductList	0.561 ms	- Mb
hookDisplayProductCompareProductList	0.576 ms	- Mb
hookDisplayProductCompareProductList	0.538 ms	- Mb
hookDisplayProductCompareProductList	0.577 ms	- Mb
hookDisplayProductCompareProductList	0.612 ms	- Mb
hookDisplayProductCompareProductList	0.567 ms	- Mb
hookDisplayProductCompareProductList	0.563 ms	- Mb
hookDisplayProductCompareProductList	0.565 ms	- Mb
hookDisplayProductCompareProductList	0.577 ms	- Mb
hookDisplayProductCompareProductList	0.585 ms	- Mb
hookDisplayProductCompareProductList	0.512 ms	- Mb
hookDisplayProductCompareProductList	0.580 ms	- Mb
hookDisplayProductCompareProductList	0.580 ms	- Mb
hookDisplayProductCompareProductList	0.559 ms	- Mb
hookDisplayProductCompareProductList	0.518 ms	- Mb
hookDisplayProductCompareProductList	0.570 ms	- Mb
hookDisplayProductCompareProductList	0.604 ms	- Mb
hookDisplayProductCompareProductList	0.573 ms	- Mb
hookDisplayProductCompareProductList	0.534 ms	- Mb
hookDisplayProductCompareProductList	0.573 ms	- Mb
hookDisplayProductCompareProductList	0.569 ms	- Mb
hookDisplayProductCompareProductList	0.574 ms	- Mb
hookDisplayProductCompareProductList	0.510 ms	- Mb
hookDisplayProductCompareProductList	0.576 ms	- Mb
hookDisplayProductCompareProductList	0.577 ms	- Mb
hookDisplayProductCompareProductList	0.584 ms	- Mb
hookDisplayProductCompareProductList	0.513 ms	- Mb
hookDisplayProductCompareProductList	0.575 ms	- Mb
hookDisplayProductCompareProductList	0.606 ms	- Mb
hookDisplayProductCompareProductList	0.568 ms	- Mb
hookDisplayProductCompareProductList	0.576 ms	- Mb
hookDisplayProductCompareProductList	0.565 ms	- Mb
hookDisplayProductComparesticky	0.885 ms	0.01 Mb
tvcmsproductpopup	361.118 ms	2.74 Mb
__construct	0.093 ms	0.01 Mb
hookDisplayHeader	0.345 ms	- Mb
hookDisplayAfterBodyOpeningTag	360.680 ms	2.73 Mb
tvcmssearch	8.206 ms	1.49 Mb
__construct	0.300 ms	0.01 Mb
hookDisplayHeader	0.924 ms	- Mb
hookDisplayNavSearchBlock	6.982 ms	1.48 Mb
tvcmssizechart	0.689 ms	0.01 Mb
__construct	0.343 ms	0.01 Mb
hookDisplayHeader	0.346 ms	- Mb
tvcmsslider	0.722 ms	0.01 Mb
__construct	0.388 ms	0.01 Mb
hookDisplayHeader	0.334 ms	- Mb
tvcmsspecialproducts	3.223 ms	0.15 Mb
__construct	0.353 ms	0.01 Mb
hookDisplayHeader	0.133 ms	- Mb
hookDisplayLeftColumn	2.737 ms	0.14 Mb
tvcmsstockinfo	10.540 ms	0.56 Mb
__construct	0.306 ms	0.01 Mb
hookHeader	0.450 ms	- Mb
hookDisplayProductListStockIndicator	0.859 ms	0.03 Mb
hookDisplayProductListStockIndicator	0.305 ms	0.01 Mb
hookDisplayProductListStockIndicator	0.299 ms	0.01 Mb
hookDisplayProductListStockIndicator	0.282 ms	0.01 Mb
hookDisplayProductListStockIndicator	0.518 ms	0.05 Mb
hookDisplayProductListStockIndicator	0.511 ms	0.05 Mb
hookDisplayProductListStockIndicator	0.303 ms	0.01 Mb
hookDisplayProductListStockIndicator	0.281 ms	0.01 Mb
hookDisplayProductListStockIndicator	0.308 ms	0.01 Mb
hookDisplayProductListStockIndicator	0.302 ms	0.01 Mb
hookDisplayProductListStockIndicator	0.582 ms	0.05 Mb
hookDisplayProductListStockIndicator	0.625 ms	0.05 Mb
hookDisplayProductListStockIndicator	0.289 ms	0.01 Mb
hookDisplayProductListStockIndicator	0.282 ms	0.01 Mb
hookDisplayProductListStockIndicator	0.291 ms	0.01 Mb
hookDisplayProductListStockIndicator	0.289 ms	0.01 Mb
hookDisplayProductListStockIndicator	0.531 ms	0.05 Mb
hookDisplayProductListStockIndicator	0.529 ms	0.05 Mb
hookDisplayProductListStockIndicator	0.304 ms	0.01 Mb
hookDisplayProductListStockIndicator	0.281 ms	0.01 Mb
hookDisplayProductListStockIndicator	0.318 ms	0.01 Mb
hookDisplayProductListStockIndicator	0.309 ms	0.01 Mb
hookDisplayProductListStockIndicator	0.649 ms	0.05 Mb
hookDisplayProductListStockIndicator	0.537 ms	0.05 Mb
tvcmsstoretime	0.824 ms	0.01 Mb
__construct	0.383 ms	- Mb
hookDisplayHeader	0.441 ms	- Mb
tvcmstabproducts	0.687 ms	0.01 Mb
__construct	0.320 ms	0.01 Mb
hookDisplayHeader	0.367 ms	- Mb
tvcmstestimonial	0.758 ms	0.01 Mb
__construct	0.417 ms	0.01 Mb
hookDisplayHeader	0.341 ms	- Mb
tvcmsthemeoptions	1.368 ms	0.01 Mb
__construct	0.360 ms	0.01 Mb
hookDisplayHeader	1.008 ms	- Mb
tvcmsvideoblock	0.721 ms	0.01 Mb
__construct	0.386 ms	0.01 Mb
hookDisplayHeader	0.335 ms	- Mb
tvcmswishlist	32.097 ms	0.10 Mb
__construct	0.344 ms	0.01 Mb
hookDisplayHeader	0.359 ms	- Mb
hookDisplayNavWishlistBlock	1.226 ms	0.04 Mb
hookDisplayWishlistBtnProductList	0.854 ms	0.01 Mb
hookDisplayWishlistBtnProductList	0.597 ms	- Mb
hookDisplayWishlistBtnProductList	0.629 ms	- Mb
hookDisplayWishlistBtnProductList	0.586 ms	- Mb
hookDisplayWishlistBtnProductList	0.593 ms	- Mb
hookDisplayWishlistBtnProductList	0.589 ms	- Mb
hookDisplayWishlistBtnProductList	0.606 ms	- Mb
hookDisplayWishlistBtnProductList	0.589 ms	- Mb
hookDisplayWishlistBtnProductList	0.601 ms	- Mb
hookDisplayWishlistBtnProductList	0.626 ms	- Mb
hookDisplayWishlistBtnProductList	0.581 ms	- Mb
hookDisplayWishlistBtnProductList	0.600 ms	- Mb
hookDisplayWishlistBtnProductList	0.574 ms	- Mb
hookDisplayWishlistBtnProductList	0.577 ms	- Mb
hookDisplayWishlistBtnProductList	0.590 ms	- Mb
hookDisplayWishlistBtnProductList	0.582 ms	- Mb
hookDisplayWishlistBtnProductList	0.644 ms	- Mb
hookDisplayWishlistBtnProductList	0.579 ms	- Mb
hookDisplayWishlistBtnProductList	0.580 ms	- Mb
hookDisplayWishlistBtnProductList	0.593 ms	- Mb
hookDisplayWishlistBtnProductList	0.585 ms	- Mb
hookDisplayWishlistBtnProductList	0.595 ms	- Mb
hookDisplayWishlistBtnProductList	0.652 ms	- Mb
hookDisplayWishlistBtnProductList	0.596 ms	- Mb
hookDisplayWishlistBtnProductList	0.575 ms	- Mb
hookDisplayWishlistBtnProductList	0.645 ms	- Mb
hookDisplayWishlistBtnProductList	0.597 ms	- Mb
hookDisplayWishlistBtnProductList	0.632 ms	- Mb
hookDisplayWishlistBtnProductList	0.591 ms	- Mb
hookDisplayWishlistBtnProductList	0.648 ms	- Mb
hookDisplayWishlistBtnProductList	0.593 ms	- Mb
hookDisplayWishlistBtnProductList	0.629 ms	- Mb
hookDisplayWishlistBtnProductList	0.589 ms	- Mb
hookDisplayWishlistBtnProductList	0.595 ms	- Mb
hookDisplayWishlistBtnProductList	0.580 ms	- Mb
hookDisplayWishlistBtnProductList	0.601 ms	- Mb
hookDisplayWishlistBtnProductList	0.592 ms	- Mb
hookDisplayWishlistBtnProductList	0.575 ms	- Mb
hookDisplayWishlistBtnProductList	0.591 ms	- Mb
hookDisplayWishlistBtnProductList	0.577 ms	- Mb
hookDisplayWishlistBtnProductList	0.590 ms	- Mb
hookDisplayWishlistBtnProductList	0.578 ms	- Mb
hookDisplayWishlistBtnProductList	0.598 ms	- Mb
hookDisplayWishlistBtnProductList	0.579 ms	- Mb
hookDisplayWishlistBtnProductList	0.594 ms	- Mb
hookDisplayWishlistBtnProductList	0.592 ms	- Mb
hookDisplayWishlistBtnProductList	0.645 ms	- Mb
hookDisplayWishlistBtnProductList	0.599 ms	- Mb
hookDisplayNavWishlistBlocksticky	1.186 ms	0.05 Mb
smartargetwhatsapp	1.159 ms	0.01 Mb
__construct	0.356 ms	0.01 Mb
hookDisplayHeader	0.803 ms	0.01 Mb
ps_accounts	0.630 ms	- Mb
__construct	0.630 ms	- Mb
tvcmsinfinitescroll	2.937 ms	0.06 Mb
__construct	0.513 ms	0.01 Mb
hookHeader	2.424 ms	0.05 Mb
tvcmscategoryproduct	0.824 ms	0.03 Mb
__construct	0.427 ms	0.01 Mb
hookHeader	0.397 ms	0.02 Mb
tvcmsmegamenu	10.679 ms	0.75 Mb
__construct	0.435 ms	0.01 Mb
hookHeader	0.385 ms	0.02 Mb
hookDisplayMegamenu	9.859 ms	0.72 Mb
tvcmstwoofferbanner	0.806 ms	0.02 Mb
__construct	0.356 ms	- Mb
hookHeader	0.450 ms	0.02 Mb
ps_facetedsearch	4.138 ms	0.13 Mb
__construct	1.609 ms	0.01 Mb
hookProductSearchProvider	1.800 ms	0.03 Mb
hookDisplayFacetedSearchBlock	0.729 ms	0.09 Mb
tvcmscustomcssjs	0.493 ms	0.01 Mb
__construct	0.477 ms	0.01 Mb
hookDisplayCustomCss	0.009 ms	- Mb
hookDisplayCustomJs	0.007 ms	- Mb
ps_customersignin	1.099 ms	0.06 Mb
__construct	0.123 ms	0.01 Mb
displayNavCustomerSignInBlock	0.976 ms	0.05 Mb
ps_languageselector	0.434 ms	0.06 Mb
__construct	0.110 ms	0.01 Mb
displayNavLanguageBlock	0.324 ms	0.05 Mb
ps_currencyselector	0.425 ms	0.06 Mb
__construct	0.111 ms	0.01 Mb
displayNavCurrencyBlock	0.314 ms	0.05 Mb
ps_contactinfo	2.142 ms	0.12 Mb
__construct	0.108 ms	0.01 Mb
displayNav1	1.117 ms	0.09 Mb
displayContactCinfo	0.917 ms	0.03 Mb
ps_categorytree	19.683 ms	1.72 Mb
__construct	0.122 ms	0.01 Mb
displayLeftColumn	19.561 ms	1.71 Mb
ps_brandlist	2.360 ms	0.08 Mb
__construct	0.151 ms	0.01 Mb
displayLeftColumn	2.209 ms	0.07 Mb
ps_supplierlist	2.127 ms	0.08 Mb
__construct	0.117 ms	0.01 Mb
displayLeftColumn	2.010 ms	0.07 Mb
ps_linklist	2.728 ms	0.09 Mb
__construct	0.619 ms	0.01 Mb
displayFooterPart1	2.109 ms	0.09 Mb
ps_customeraccountlinks	2.059 ms	0.09 Mb
__construct	0.114 ms	0.01 Mb
displayMyaccountcblock	1.945 ms	0.09 Mb
statsdata	1.687 ms	0.06 Mb
__construct	0.111 ms	0.01 Mb
hookDisplayBeforeBodyClosingTag	1.576 ms	0.05 Mb
64 module(s)	1226 ms	19.92 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
51 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
33 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
20 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
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
9 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
9 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
9 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
9 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
9 queries	SELECT * FROM `ps_product_attribute_lang` WHERE `id_product_attribute` = 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)
8 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
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
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 mr.* FROM ps_tvcmsmegamenu_row_shop mr WHERE mr.`id_shop` = XX AND mr.id_tvcmsmegamenu = XX AND mr.`active` = XX
4 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
4 queries	SELECT * FROM `ps_product_lang` WHERE `id_product` = XX AND `id_shop` = XX
4 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`
3 queries	SELECT `need_identification_number` FROM `ps_country` WHERE `id_country` = XX LIMIT XX
3 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
3 queries	SELECT *, ( IF (`id_shop` = XX, XX, XX) + IF (`id_country` = XX, XX, XX) + IF (`id_currency` = XX, XX, XX) + IF (`id_group` = XX, XX, XX) + IF (`id_customer` = XX, XX, XX)) AS `score` FROM `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
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, 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, 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 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

#	Query	Time (ms)	Rows	Filesort	Group By	Location
366	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	625.759 ms	102060			/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)
597	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	305.981 ms	411170760	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)
726	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	305.728 ms	411170760	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)
722	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.657 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)
747	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	3.990 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)
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	3.872 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)
705	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.847 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)
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`)	3.106 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)
358	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, 745, 731, 623, 732, 41, 586) 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.945 ms	48672			/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)
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`	2.910 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)
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, 745, 731, 623, 732, 41, 586) 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.751 ms	48672			/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)
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, 745, 731, 623, 732, 41, 586) 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.741 ms	48672			/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)
365	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.200 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)
356	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, 745, 731, 623, 732, 41, 586) 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.944 ms	24336	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)
370	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, 745, 731, 623, 732, 41, 586) 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.879 ms	48672	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, 745, 731, 623, 732, 41, 586) GROUP BY p.id_product) p WHERE p.date_add>'2022-11-05 00:00:00'	1.682 ms	24336			/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)
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, 745, 731, 623, 732, 41, 586) GROUP BY p.id_product) p WHERE ((p.on_sale=1))	1.458 ms	24336			/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)
374	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, 745, 731, 623, 732, 41, 586) GROUP BY p.id_product) p GROUP BY p.id_manufacturer	1.408 ms	24336	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)
375	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, 745, 731, 623, 732, 41, 586) GROUP BY p.id_product) p GROUP BY p.condition	1.388 ms	24336	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)
392	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.320 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)
391	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.257 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)
850	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	1.017 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)
15	SELECT SQL_NO_CACHE `id_hook`, `name` FROM `ps_hook`	0.847 ms	1107			/classes/Hook.php:1348 /classes/Hook.php:228 (getAllHookIds) /classes/Hook.php:857 (getIdByName) /classes/Dispatcher.php:606 (exec) /classes/Dispatcher.php:243 (loadRoutes) /classes/Dispatcher.php:201 (__construct) /index.php:28 (getInstance)
338	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.826 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)
12	SELECT SQL_NO_CACHE lower(name) as name FROM `ps_hook` h WHERE (h.active = 1)	0.814 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)
818	SELECT SQL_NO_CACHE *, ( IF (`id_shop` = 1, 2, 0) + IF (`id_country` = 6, 4, 0) + IF (`id_currency` = 1, 8, 0) + IF (`id_group` = 1, 16, 0) + IF (`id_customer` = 0, 32, 0)) AS `score` FROM `ps_specific_price` WHERE `id_shop` IN (0, 1) AND `id_currency` IN (0, 1) AND `id_country` IN (0, 6) AND `id_group` IN (0, 1) AND `id_product` = 2227 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0 AND (`from` = '0000-00-00 00:00:00' OR '2025-07-31 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2025-07-31 00:00:00' <= `to`) AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1	0.727 ms	3	Yes		/classes/SpecificPrice.php:576 /classes/Product.php:3827 (getSpecificPrice) /classes/Product.php:3717 (priceCalculation) /classes/Product.php:5692 (getPriceStatic) /classes/Product.php:5990 (getProductProperties) /classes/Category.php:1074 (getProductsProperties) /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)
368	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, 745, 731, 623, 732, 41, 586) 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.706 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)
364	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, 745, 731, 623, 732, 41, 586)	0.680 ms	78			/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)
838	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 (3411)	0.661 ms	1			/classes/ProductAssembler.php:64 /classes/ProductAssembler.php:182 (addMissingProductFields) /modules/tvcmstabproducts/tvcmstabproducts.php:2787 (assembleProduct) /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)
743	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.648 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)
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, 745, 731, 623, 732, 41, 586) 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 22:29:39' >= sp.from) AND (sp.to = '0000-00-00 00:00:00' OR '2025-07-31 22:29:39' <= sp.to) ) WHERE ((sp.reduction>0))	0.622 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)
382	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,20261,842,20873,20292,977,20914,20323,978,20955,20354,979)	0.609 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)
833	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.604 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)
367	SELECT SQL_NO_CACHE DISTINCT a.`id_attribute`, a.`color`, al.`name`, agl.`id_attribute_group`, IF(lialv.`url_name` IS NULL OR lialv.`url_name` = "", NULL, lialv.`url_name`) AS url_name, IF(lialv.`meta_title` IS NULL OR lialv.`meta_title` = "", NULL, lialv.`meta_title`) AS meta_title FROM `ps_attribute_group` ag INNER JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1) 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` = 1) 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 = 1) INNER JOIN ps_attribute_shop attribute_shop ON (attribute_shop.id_attribute = a.id_attribute AND attribute_shop.id_shop = 1) LEFT JOIN `ps_layered_indexable_attribute_lang_value` lialv ON (a.`id_attribute` = lialv.`id_attribute` AND lialv.`id_lang` = 1) WHERE ag.id_attribute_group = 1 ORDER BY agl.`name` ASC, a.`position` ASC	0.598 ms	4	Yes		/modules/ps_facetedsearch/src/Filters/DataAccessor.php:96 /modules/ps_facetedsearch/src/Filters/Block.php:731 (getAttributes) /modules/ps_facetedsearch/src/Filters/Block.php:150 (getAttributesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:357 (runQuery) /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)
1084	INSERT INTO `ps_connections_source` (`id_connections`, `http_referer`, `request_uri`, `keywords`, `date_add`) VALUES ('268731', '', 'nocta.es/2-inicio?q=Categor%C3%ADas-Biombo-Mini+invernadero-Set+andamios-Sof%C3%A1%5C-cama%5C-perro-Steps-USB+STOCK-Cochecito+perro', '', '2025-07-31 22:29:41')	0.586 ms	1			/classes/ObjectModel.php:622 /classes/ConnectionsSource.php:105 (add) /modules/statsdata/statsdata.php:119 (logHttpReferer) /modules/statsdata/statsdata.php:74 (getScriptCustomerPagesViews) /classes/Hook.php:1083 (hookDisplayBeforeBodyClosingTag) /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:309 (__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:89 (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)
378	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, 745, 731, 623, 732, 41, 586) 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.580 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)
376	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, 745, 731, 623, 732, 41, 586)	0.569 ms	78			/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)
373	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.565 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)
371	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, 745, 731, 623, 732, 41, 586) 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.528 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)
609	SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity, COALESCE(SUM(first_level_quantity), 0) as quantity FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity FROM `ps_cart_product` cp WHERE cp.`id_product_attribute` = 0 AND cp.`id_cart` = 0 AND cp.`id_product` = 22845 UNION SELECT 0 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` = 0 AND cp.`id_cart` = 0 AND p.`id_product_item` = 22845 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1	0.518 ms	0			/classes/Cart.php:1430 /classes/Product.php:4361 (getProductQuantity) /classes/Product.php:5802 (getQuantity) /classes/Product.php:5990 (getProductProperties) /classes/Product.php:3127 (getProductsProperties) /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)

Name	Instances	Source
Category	323	/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: 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	62	/classes/Link.php:113 (__construct) [id: 20832] /classes/Link.php:113 (__construct) [id: 20261] /classes/Link.php:113 (__construct) [id: 842] /classes/Link.php:113 (__construct) [id: 20873] /classes/Link.php:113 (__construct) [id: 20292] /classes/Link.php:113 (__construct) [id: 977] /classes/Link.php:113 (__construct) [id: 20914] /classes/Link.php:113 (__construct) [id: 20323] /classes/Link.php:113 (__construct) [id: 978] /classes/Link.php:113 (__construct) [id: 20955] /classes/Link.php:113 (__construct) [id: 20354] /classes/Link.php:113 (__construct) [id: 979] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 20832] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 20261] /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: 20292] /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: 20323] /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: 20354] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 979] /classes/Link.php:113 (__construct) [id: 20832] /classes/Link.php:113 (__construct) [id: 20261] /classes/Link.php:113 (__construct) [id: 842] /classes/Link.php:113 (__construct) [id: 20873] /classes/Link.php:113 (__construct) [id: 20292] /classes/Link.php:113 (__construct) [id: 977] /classes/Link.php:113 (__construct) [id: 20914] /classes/Link.php:113 (__construct) [id: 20323] /classes/Link.php:113 (__construct) [id: 978] /classes/Link.php:113 (__construct) [id: 20955] /classes/Link.php:113 (__construct) [id: 20354] /classes/Link.php:113 (__construct) [id: 979] /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: 723] /classes/Link.php:113 (__construct) [id: 3411] /classes/Link.php:113 (__construct) [id: 961] /classes/Link.php:113 (__construct) [id: 2227] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 723] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 3411] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 961] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 2227] /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]
Combination	9	/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: 3713] /classes/Product.php:5912 (__construct) [id: 11250] /classes/Product.php:5912 (__construct) [id: 4661] /classes/Product.php:5912 (__construct) [id: 8756] /classes/Product.php:5912 (__construct) [id: 2584]
Country	7	/config/config.inc.php:146 (__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: ]
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:690 (getCurrencyInstance) [id: 1]
Cart	2	/classes/controller/FrontController.php:467 (__construct) [id: ] /classes/controller/FrontController.php:541 (__construct) [id: ]
Tax	2	/classes/tax/TaxRulesTaxManager.php:116 (__construct) [id: 1] /classes/tax/TaxRulesTaxManager.php:116 (__construct) [id: 1]
Shop	1	/config/config.inc.php:117 (initialize) [id: 1]
TvcmsMegaMenuClass	1	/modules/tvcmsmegamenu/tvcmsmegamenu.php:1386 (__construct) [id: ]
Gender	1	/classes/controller/FrontController.php:1702 (__construct) [id: 0]
Risk	1	/classes/controller/FrontController.php:1705 (__construct) [id: ]
Group	1	/classes/Cart.php:249 (getCurrent) [id: 1]
Customer	1	/config/config.inc.php:264 (__construct) [id: ]
ShopGroup	1	/classes/shop/Shop.php:561 (__construct) [id: 1]
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

Stopwatch SQL - 1085 queries

Doubles

Tables stress

ObjectModel instances

Included Files