Inicio

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

Subcategoría

Jaula grande exterior para gatos

Llaveros para eventos

Tumbona plegable

2 mesillas de noche flotantes

Rascador grande

Ventiladores de pie

Butaca con patas

Bloques espuma juguete (escalera/rampa)

Sombrilla de pared (una y media)

Tractor juguete a pedales

Aparador

Tienda de campaña 6-8 personas

Barrera seguridad mascotas

Caseta jardín gato

Jaula pájaros con patas

Conjunto 4 sillas de comedor

Bicicleta-triciclo infantil

Carrito para playa

armario-vitrina auxiliar cocina

Techo para carpas

Pérgola

Rascador mediano + caseta

Mesa plegable cocina con rueda

Cubierta radiador

Invernadero

2 mesitas de noche flotantes

Chimenea con patas

Sofá + cama 2 plazas

Doble pizarra con caballete y acjones infantil

Jaula doble para conejo con patas exterior

Corral metálico mascotas

Espejo baño + armario

Mueble tv + estantería

Juegos equilibrios madera

Marquesina

Carpa con paredes

Jaula pájaros

Cochecito paseo pedales

Ventiladores torre

Sofá-cama-perro

Cama plegable

Mesa auxiliar jardín-balcón

Almacenar juguetes con ruedas

Mueble cocina

Sillón madera jardín

Estantería baja madera

Nevera portátil-eléctrica

Cama elevada perros

Casa conejo

Mesa pequeña jardín

Banco trabajo plegable

Balancín infantil

Tocador adulto

Jaula con patas para pájaros

Carretilla jardín

Roll geotextil

Columna baño

Soporte para saco de boxeo

Canasta baloncesto niño-adulto

Estructura columpio doble jardín

Césped artificial

Carpa pabellón

Peso gazebo

Pérgola techo plegable y paredes plegables

Arenero gato

Carrito tabla de surf

Carpa simple doble

Tienda campaña 2-3 personas

Mesa de comedor de jardín

sillón masaje + taburete

Cama infantil 50 kg 143x73x60cm

Estantería para macetas

Barrera coche perro

Jaula conejos exterior con suelo

Funda mueble exterior

sombrilla reclinable con luces led

Mesita centro jardín balcón

Sombrilla reclinable soporte al lado

Jaula roedores con ruedas

Mueble bajo pica baño

Pedales bicicleta

Jaula pájaros pequeña doble elevada con ruedas

Póker

Sombrilla

Cojín asiento banco jardín

Barbacoa con tapa de sobremesa-Gas

Jaula para pequeños roedores metal ruedas

Tobogán infantil + canasta + columpio

Taburete con ruedas

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

Canasta baloncesto-infantil

Mesa auxiliar sofá-cama con ruedas

Lámpara estantería

Columpio

Correpasillos con mango empuje

Espejo de pie

Nevera para cosméticos

pesa rusa

Pesa rusa 12 kg

Pesas Barra + Discos 20 Kg

Pantalla proyector

Cesto ropa

Carritos de cocina metal y plástico

Columna baño con estantes

somier matrimonio con cabezal

Mesa ping pong adulto

Carritos de cocina

Moto batería

Armario ropero de tela

Espejo de pared

Pesas 2 discos (10 kg)

Cortadora papel

Carro para playa

Sombrilla doble con luces led

Mesa auxiliar jardín

Jardinera con enrejado nivel suelo

Diana electrónica

Ducha solar

Biombo

Carpa simple con 2 paredes

Silla plegable baja playa

Splash pad para mascotas

Arenero niños + cocina juguete toldo jardín

Jaula trasportín perro

Andador-caminador gente con dificultad andar

Cama elástica infantil con red

Arenero infantil jardín

Carpa simple con 4 paredes

Toldo pared

Tumbona de madera con ruedas

Jaula perro con ruedas

Gallinero solo corral

Alfombra para terraza

Puente de jardín

Arenero gatos autolimpiable

Armario modular 12 cubos

Bicicleta sin pedales

Escritorio infantil altura ajustable

Conjunto taburetes y mesa alta

Caseta de jardín de tela

Consola recibidor

Baúl banco infantil

Cama alta perro con toldo

Speed Ball montaje pared

Torre aprendizaje niño

sifonier

Escritorio

Jaula para perros exterior

Multiestación musculación

Sillón relax

tumbona sin patas playa

Caballito balancín madera

Caseta jardín

Armario auxiliar

Kit pesas 20 kg (convertible)

Mesa plegable cocina con ruedas y cajones

mesa consola

Cama alta perros

Carritos de cocina metálicos

Sombrilla media pantalla terraza

Cubo basura apertura automática

Caseta gato

Funda protectora sombrilla

Columna baño para pared

Rascador mediano + cama + caseta

Canasta de baloncesto niño-adulto

Sombrilla reclinable

Jaula para gatos

Herramientas, Brico y Automóvil

Sube y baja

Juguetes y Ocio

Conjunto 2 tumbonas ratán

Infantil y Puericultura

Mascotas

Juguetes y Aficiones

Agricultura

Vino, Accesorios de Bebida y Hostelería

Tecnología y Accesorios

Oficina y Negocios

Artículos Sostenibles

Tazas, Jarras y Termos

Cuidado Personal y Pharma

Productos para mascotas

Colección protección higiénica

Ver columna izquierda

productos

Red

Cuadrícula-2

Lista

Lista-2

Catálogo

Ordenar por:

Nuevo

¡En oferta!

71,99 €

Nuevo

¡En oferta!

71,99 €

Nuevo

¡En oferta!

71,99 €

Load Time	4068 ms
Querying Time	3426 ms
Queries	1188
Memory Peak Usage	37.5 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.330 ms	21.330 ms	2.99 Mb	3.3 Mb
__construct	0.023 ms	21.353 ms	- Mb	3.3 Mb
init	100.633 ms	121.986 ms	3.08 Mb	6.5 Mb
checkAccess	0.002 ms	121.988 ms	- Mb	6.5 Mb
setMedia	8.699 ms	130.687 ms	0.20 Mb	6.5 Mb
postProcess	0.002 ms	130.689 ms	- Mb	6.5 Mb
initHeader	0.001 ms	130.690 ms	- Mb	6.5 Mb
initContent	3492 ms	3623 ms	6.10 Mb	12.5 Mb
initFooter	0.002 ms	3623 ms	- Mb	12.5 Mb
display	445.401 ms	4068 ms	23.77 Mb	37.5 Mb

Hook	Time	Memory Usage
DisplayHeader	182.711 ms	0.56 Mb
=> ps_shoppingcart	0.075 ms	- Mb
=> ps_searchbar	0.893 ms	- Mb
=> ps_imageslider	0.428 ms	- Mb
=> productcomments	0.464 ms	- Mb
=> psxmarketingwithgoogle	3.577 ms	0.01 Mb
=> ps_googleanalytics	1.671 ms	0.02 Mb
=> tvcmsbestsellerproducts	0.144 ms	- Mb
=> tvcmsblog	0.705 ms	- Mb
=> tvcmsblogdisplayposts	0.451 ms	- Mb
=> tvcmsbrandlist	0.351 ms	- Mb
=> tvcmscategorychainslider	0.335 ms	- Mb
=> tvcmscategoryslider	0.357 ms	- Mb
=> tvcmscookiesnotice	0.340 ms	- Mb
=> tvcmscustomerservices	0.353 ms	- Mb
=> tvcmscustomsetting	2.172 ms	0.01 Mb
=> tvcmsfeaturedproducts	0.141 ms	- Mb
=> tvcmsfooterlogo	0.001 ms	- Mb
=> tvcmsfooterproduct	0.137 ms	- Mb
=> tvcmsnewproducts	0.143 ms	- Mb
=> tvcmsnewsletterpopup	0.679 ms	- Mb
=> tvcmspaymenticon	0.001 ms	- Mb
=> tvcmsproductcomments	1.357 ms	- Mb
=> tvcmsproductcompare	0.355 ms	- Mb
=> tvcmsproductpopup	0.331 ms	- Mb
=> tvcmssearch	0.919 ms	- Mb
=> tvcmssizechart	0.363 ms	- Mb
=> tvcmsslider	0.335 ms	- Mb
=> tvcmsspecialproducts	0.159 ms	- Mb
=> tvcmsstoretime	0.334 ms	- Mb
=> tvcmstabproducts	0.375 ms	- Mb
=> tvcmstestimonial	0.354 ms	- Mb
=> tvcmsthemeoptions	1.055 ms	- Mb
=> tvcmsvideoblock	0.336 ms	- Mb
=> tvcmswishlist	0.377 ms	- Mb
=> smartargetwhatsapp	0.877 ms	0.01 Mb
=> ps_facebook	161.765 ms	0.46 Mb
DisplayLeftColumn	108.333 ms	5.48 Mb
=> tvcmsnewproducts	40.468 ms	0.89 Mb
=> tvcmscustomerservices	0.933 ms	0.08 Mb
=> tvcmsspecialproducts	1.948 ms	0.10 Mb
=> tvcmsfeaturedproducts	40.294 ms	2.73 Mb
=> tvcmsbestsellerproducts	24.690 ms	1.68 Mb
DisplayAfterBodyOpeningTag	66.820 ms	2.75 Mb
=> tvcmscookiesnotice	0.918 ms	0.02 Mb
=> blockreassurance	0.005 ms	- Mb
=> tvcmsproductpopup	65.897 ms	2.74 Mb
DisplayReviewProductList	46.513 ms	3.77 Mb
=> tvcmsproductcomments	1.435 ms	0.12 Mb
=> tvcmsproductcomments	0.920 ms	0.07 Mb
=> tvcmsproductcomments	0.891 ms	0.07 Mb
=> tvcmsproductcomments	0.923 ms	0.07 Mb
=> tvcmsproductcomments	1.058 ms	0.11 Mb
=> tvcmsproductcomments	1.013 ms	0.07 Mb
=> tvcmsproductcomments	1.010 ms	0.07 Mb
=> tvcmsproductcomments	1.014 ms	0.06 Mb
=> tvcmsproductcomments	1.062 ms	0.11 Mb
=> tvcmsproductcomments	0.903 ms	0.07 Mb
=> tvcmsproductcomments	0.902 ms	0.07 Mb
=> tvcmsproductcomments	0.871 ms	0.06 Mb
=> tvcmsproductcomments	1.075 ms	0.11 Mb
=> tvcmsproductcomments	0.914 ms	0.07 Mb
=> tvcmsproductcomments	0.893 ms	0.07 Mb
=> tvcmsproductcomments	0.844 ms	0.06 Mb
=> tvcmsproductcomments	1.101 ms	0.14 Mb
=> tvcmsproductcomments	0.958 ms	0.07 Mb
=> tvcmsproductcomments	0.907 ms	0.07 Mb
=> tvcmsproductcomments	0.867 ms	0.06 Mb
=> tvcmsproductcomments	1.059 ms	0.11 Mb
=> tvcmsproductcomments	0.901 ms	0.07 Mb
=> tvcmsproductcomments	0.881 ms	0.07 Mb
=> tvcmsproductcomments	0.897 ms	0.06 Mb
=> tvcmsproductcomments	1.123 ms	0.11 Mb
=> tvcmsproductcomments	0.922 ms	0.07 Mb
=> tvcmsproductcomments	0.886 ms	0.07 Mb
=> tvcmsproductcomments	0.865 ms	0.06 Mb
=> tvcmsproductcomments	1.108 ms	0.11 Mb
=> tvcmsproductcomments	0.916 ms	0.07 Mb
=> tvcmsproductcomments	0.915 ms	0.07 Mb
=> tvcmsproductcomments	0.857 ms	0.06 Mb
=> tvcmsproductcomments	1.082 ms	0.11 Mb
=> tvcmsproductcomments	0.910 ms	0.07 Mb
=> tvcmsproductcomments	0.898 ms	0.07 Mb
=> tvcmsproductcomments	0.856 ms	0.06 Mb
=> tvcmsproductcomments	1.057 ms	0.11 Mb
=> tvcmsproductcomments	0.920 ms	0.07 Mb
=> tvcmsproductcomments	0.974 ms	0.07 Mb
=> tvcmsproductcomments	0.932 ms	0.06 Mb
=> tvcmsproductcomments	1.161 ms	0.11 Mb
=> tvcmsproductcomments	1.087 ms	0.07 Mb
=> tvcmsproductcomments	0.969 ms	0.07 Mb
=> tvcmsproductcomments	0.933 ms	0.06 Mb
=> tvcmsproductcomments	1.119 ms	0.11 Mb
=> tvcmsproductcomments	0.949 ms	0.07 Mb
=> tvcmsproductcomments	0.901 ms	0.07 Mb
=> tvcmsproductcomments	0.874 ms	0.06 Mb
DisplayWishlistBtnProductList	28.652 ms	- Mb
=> tvcmswishlist	0.849 ms	0.01 Mb
=> tvcmswishlist	0.595 ms	- Mb
=> tvcmswishlist	0.575 ms	- Mb
=> tvcmswishlist	0.578 ms	- Mb
=> tvcmswishlist	0.585 ms	- Mb
=> tvcmswishlist	0.597 ms	- Mb
=> tvcmswishlist	0.592 ms	- Mb
=> tvcmswishlist	0.576 ms	- Mb
=> tvcmswishlist	0.604 ms	- Mb
=> tvcmswishlist	0.629 ms	- Mb
=> tvcmswishlist	0.578 ms	- Mb
=> tvcmswishlist	0.580 ms	- Mb
=> tvcmswishlist	0.617 ms	- Mb
=> tvcmswishlist	0.580 ms	- Mb
=> tvcmswishlist	0.598 ms	- Mb
=> tvcmswishlist	0.590 ms	- Mb
=> tvcmswishlist	0.588 ms	- Mb
=> tvcmswishlist	0.574 ms	- Mb
=> tvcmswishlist	0.591 ms	- Mb
=> tvcmswishlist	0.606 ms	- Mb
=> tvcmswishlist	0.590 ms	- Mb
=> tvcmswishlist	0.573 ms	- Mb
=> tvcmswishlist	0.590 ms	- Mb
=> tvcmswishlist	0.575 ms	- Mb
=> tvcmswishlist	0.599 ms	- Mb
=> tvcmswishlist	0.578 ms	- Mb
=> tvcmswishlist	0.578 ms	- Mb
=> tvcmswishlist	0.589 ms	- Mb
=> tvcmswishlist	0.580 ms	- Mb
=> tvcmswishlist	0.590 ms	- Mb
=> tvcmswishlist	0.592 ms	- Mb
=> tvcmswishlist	0.595 ms	- Mb
=> tvcmswishlist	0.589 ms	- Mb
=> tvcmswishlist	0.574 ms	- Mb
=> tvcmswishlist	0.592 ms	- Mb
=> tvcmswishlist	0.629 ms	- Mb
=> tvcmswishlist	0.590 ms	- Mb
=> tvcmswishlist	0.589 ms	- Mb
=> tvcmswishlist	0.599 ms	- Mb
=> tvcmswishlist	0.600 ms	- Mb
=> tvcmswishlist	0.662 ms	- Mb
=> tvcmswishlist	0.591 ms	- Mb
=> tvcmswishlist	0.595 ms	- Mb
=> tvcmswishlist	0.592 ms	- Mb
=> tvcmswishlist	0.582 ms	- Mb
=> tvcmswishlist	0.592 ms	- Mb
=> tvcmswishlist	0.589 ms	- Mb
=> tvcmswishlist	0.575 ms	- Mb
DisplayProductCompareProductList	27.410 ms	0.10 Mb
=> tvcmsproductcompare	0.879 ms	0.01 Mb
=> tvcmsproductcompare	0.565 ms	- Mb
=> tvcmsproductcompare	0.578 ms	- Mb
=> tvcmsproductcompare	0.583 ms	- Mb
=> tvcmsproductcompare	0.578 ms	- Mb
=> tvcmsproductcompare	0.557 ms	- Mb
=> tvcmsproductcompare	0.595 ms	- Mb
=> tvcmsproductcompare	0.577 ms	- Mb
=> tvcmsproductcompare	0.584 ms	- Mb
=> tvcmsproductcompare	0.579 ms	- Mb
=> tvcmsproductcompare	0.531 ms	- Mb
=> tvcmsproductcompare	0.561 ms	- Mb
=> tvcmsproductcompare	0.592 ms	- Mb
=> tvcmsproductcompare	0.559 ms	- Mb
=> tvcmsproductcompare	0.553 ms	- Mb
=> tvcmsproductcompare	0.577 ms	- Mb
=> tvcmsproductcompare	0.555 ms	- Mb
=> tvcmsproductcompare	0.580 ms	- Mb
=> tvcmsproductcompare	0.530 ms	- Mb
=> tvcmsproductcompare	0.577 ms	- Mb
=> tvcmsproductcompare	0.559 ms	- Mb
=> tvcmsproductcompare	0.570 ms	- Mb
=> tvcmsproductcompare	0.545 ms	- Mb
=> tvcmsproductcompare	0.575 ms	- Mb
=> tvcmsproductcompare	0.579 ms	- Mb
=> tvcmsproductcompare	0.581 ms	- Mb
=> tvcmsproductcompare	0.525 ms	- Mb
=> tvcmsproductcompare	0.558 ms	- Mb
=> tvcmsproductcompare	0.598 ms	- Mb
=> tvcmsproductcompare	0.561 ms	- Mb
=> tvcmsproductcompare	0.521 ms	- Mb
=> tvcmsproductcompare	0.582 ms	- Mb
=> tvcmsproductcompare	0.559 ms	- Mb
=> tvcmsproductcompare	0.570 ms	- Mb
=> tvcmsproductcompare	0.523 ms	- Mb
=> tvcmsproductcompare	0.573 ms	- Mb
=> tvcmsproductcompare	0.577 ms	- Mb
=> tvcmsproductcompare	0.557 ms	- Mb
=> tvcmsproductcompare	0.520 ms	- Mb
=> tvcmsproductcompare	0.582 ms	- Mb
=> tvcmsproductcompare	0.605 ms	- Mb
=> tvcmsproductcompare	0.562 ms	- Mb
=> tvcmsproductcompare	0.514 ms	- Mb
=> tvcmsproductcompare	0.558 ms	- Mb
=> tvcmsproductcompare	0.598 ms	- Mb
=> tvcmsproductcompare	0.563 ms	- Mb
=> tvcmsproductcompare	0.532 ms	- Mb
=> tvcmsproductcompare	0.574 ms	- Mb
displayLeftColumn	23.111 ms	1.96 Mb
=> ps_categorytree (widget)	19.029 ms	1.82 Mb
=> ps_brandlist (widget)	2.069 ms	0.07 Mb
=> ps_supplierlist (widget)	2.013 ms	0.07 Mb
DisplayProductListStockIndicator	10.442 ms	0.68 Mb
=> tvcmsstockinfo	0.865 ms	0.03 Mb
=> tvcmsstockinfo	0.285 ms	0.01 Mb
=> tvcmsstockinfo	0.323 ms	0.01 Mb
=> tvcmsstockinfo	0.281 ms	0.01 Mb
=> tvcmsstockinfo	0.527 ms	0.05 Mb
=> tvcmsstockinfo	0.540 ms	0.05 Mb
=> tvcmsstockinfo	0.499 ms	0.05 Mb
=> tvcmsstockinfo	0.501 ms	0.05 Mb
=> tvcmsstockinfo	0.302 ms	0.01 Mb
=> tvcmsstockinfo	0.278 ms	0.01 Mb
=> tvcmsstockinfo	0.285 ms	0.01 Mb
=> tvcmsstockinfo	0.281 ms	0.01 Mb
=> tvcmsstockinfo	0.538 ms	0.05 Mb
=> tvcmsstockinfo	0.520 ms	0.05 Mb
=> tvcmsstockinfo	0.507 ms	0.05 Mb
=> tvcmsstockinfo	0.488 ms	0.05 Mb
=> tvcmsstockinfo	0.309 ms	0.01 Mb
=> tvcmsstockinfo	0.280 ms	0.01 Mb
=> tvcmsstockinfo	0.338 ms	0.01 Mb
=> tvcmsstockinfo	0.282 ms	0.01 Mb
=> tvcmsstockinfo	0.646 ms	0.05 Mb
=> tvcmsstockinfo	0.551 ms	0.05 Mb
=> tvcmsstockinfo	0.499 ms	0.05 Mb
=> tvcmsstockinfo	0.516 ms	0.05 Mb
DisplayMegamenu	8.718 ms	0.68 Mb
=> tvcmsmegamenu	8.718 ms	0.68 Mb
DisplayNavSearchBlock	6.296 ms	1.48 Mb
=> tvcmssearch	6.296 ms	1.48 Mb
DisplayCustomsocialblock	4.256 ms	0.16 Mb
=> tvcmscustomsetting	4.256 ms	0.16 Mb
DisplayFooter	4.028 ms	0.14 Mb
=> blockwishlist	3.159 ms	0.13 Mb
=> ps_facebook	0.869 ms	0.01 Mb
Header	4.021 ms	0.11 Mb
=> tvcmsstockinfo	0.438 ms	- Mb
=> tvcmsinfinitescroll	2.404 ms	0.05 Mb
=> tvcmscategoryproduct	0.393 ms	0.02 Mb
=> tvcmsmegamenu	0.379 ms	0.02 Mb
=> tvcmstwoofferbanner	0.407 ms	0.02 Mb
ActionFrontControllerSetMedia	2.420 ms	0.01 Mb
=> blockreassurance	0.648 ms	- Mb
=> blockwishlist	0.598 ms	- Mb
=> ps_emailsubscription	0.136 ms	- Mb
=> ps_socialfollow	0.225 ms	- Mb
=> psxdesign	0.525 ms	- Mb
=> klaviyopsautomation	0.006 ms	- Mb
=> ps_emailalerts	0.113 ms	- Mb
=> monei	0.004 ms	- Mb
=> ps_facebook	0.165 ms	- Mb
displayFooterPart1	2.084 ms	0.09 Mb
=> ps_linklist (widget)	2.084 ms	0.09 Mb
displaySocialMediaBlock	2.034 ms	0.09 Mb
=> ps_socialfollow (widget)	2.034 ms	0.09 Mb
displayNewslettersubscription	1.848 ms	0.09 Mb
=> ps_emailsubscription (widget)	1.848 ms	0.09 Mb
displayMyaccountcblock	1.847 ms	0.09 Mb
=> ps_customeraccountlinks (widget)	1.847 ms	0.09 Mb
ProductSearchProvider	1.695 ms	0.03 Mb
=> ps_facetedsearch	1.695 ms	0.03 Mb
DisplayBeforeBodyClosingTag	1.676 ms	0.05 Mb
=> statsdata	1.673 ms	0.05 Mb
=> tvcmsblog	0.003 ms	- Mb
DisplayPaymentIcon	1.437 ms	0.04 Mb
=> tvcmspaymenticon	1.437 ms	0.04 Mb
DisplayNavWishlistBlock	1.297 ms	0.04 Mb
=> tvcmswishlist	1.297 ms	0.04 Mb
DisplayNavWishlistBlocksticky	1.293 ms	0.05 Mb
=> tvcmswishlist	1.293 ms	0.05 Mb
displayNavShoppingCartBlock	1.147 ms	0.09 Mb
=> ps_shoppingcart (widget)	1.147 ms	0.09 Mb
displayNav1	1.103 ms	0.09 Mb
=> ps_contactinfo (widget)	1.103 ms	0.09 Mb
displayContactCinfo	0.927 ms	0.03 Mb
=> ps_contactinfo (widget)	0.927 ms	0.03 Mb
DisplayDownloadApps	0.906 ms	0.02 Mb
=> tvcmscustomsetting	0.906 ms	0.02 Mb
DisplayProductComparesticky	0.881 ms	0.01 Mb
=> tvcmsproductcompare	0.881 ms	0.01 Mb
displayNavCustomerSignInBlock	0.870 ms	0.05 Mb
=> ps_customersignin (widget)	0.870 ms	0.05 Mb
DisplayNavProductCompareBlock	0.858 ms	0.01 Mb
=> tvcmsproductcompare	0.858 ms	0.01 Mb
DisplayAfterTitleTag	0.813 ms	0.01 Mb
=> psxdesign	0.813 ms	0.01 Mb
DisplayCopyRightText	0.812 ms	0.01 Mb
=> tvcmscustomsetting	0.812 ms	0.01 Mb
ActionDispatcherBefore	0.708 ms	0.01 Mb
=> psxdesign	0.232 ms	- Mb
=> ps_mbo	0.476 ms	0.01 Mb
DisplayFacetedSearchBlock	0.559 ms	0.09 Mb
=> ps_facetedsearch	0.559 ms	0.09 Mb
displayNavLanguageBlock	0.284 ms	0.05 Mb
=> ps_languageselector (widget)	0.284 ms	0.05 Mb
displayNavCurrencyBlock	0.264 ms	0.05 Mb
=> ps_currencyselector (widget)	0.264 ms	0.05 Mb
ModuleRoutes	0.022 ms	0.01 Mb
=> klaviyopsautomation	0.005 ms	- Mb
=> tvcmsblog	0.015 ms	0.01 Mb
=> simpleimportproduct	0.002 ms	- Mb
DisplayTopOfferText	0.014 ms	- Mb
=> tvcmscustomsetting	0.011 ms	- Mb
=> tvcmscustomsetting	0.003 ms	- Mb
DisplayCustomJs	0.007 ms	- Mb
=> tvcmscustomcssjs	0.007 ms	- Mb
DisplayCustomCss	0.006 ms	- Mb
=> tvcmscustomcssjs	0.006 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)	549.131 ms	18.93 Mb

Module	Time	Memory Usage
klaviyopsautomation	1.473 ms	- Mb
__construct	1.451 ms	- Mb
hookModuleRoutes	0.008 ms	- Mb
hookActionFrontControllerInitAfter	0.007 ms	- Mb
hookActionFrontControllerSetMedia	0.007 ms	- Mb
tvcmsblog	5.715 ms	0.13 Mb
__construct	4.989 ms	0.12 Mb
hookModuleRoutes	0.016 ms	0.01 Mb
hookDisplayHeader	0.706 ms	- Mb
hookDisplayBeforeBodyClosingTag	0.004 ms	- Mb
simpleimportproduct	0.893 ms	0.03 Mb
__construct	0.889 ms	0.02 Mb
hookModuleRoutes	0.004 ms	- Mb
psxdesign	4.934 ms	0.03 Mb
__construct	3.358 ms	0.01 Mb
hookActionDispatcherBefore	0.234 ms	- Mb
hookActionFrontControllerSetMedia	0.526 ms	- Mb
hookDisplayAfterTitleTag	0.816 ms	0.01 Mb
ps_mbo	9.493 ms	0.05 Mb
__construct	9.011 ms	0.04 Mb
hookActionDispatcherBefore	0.482 ms	0.01 Mb
blockreassurance	1.391 ms	0.09 Mb
__construct	0.729 ms	0.08 Mb
hookActionFrontControllerSetMedia	0.651 ms	0.01 Mb
hookDisplayAfterBodyOpeningTag	0.006 ms	- Mb
hookDisplayNavFullWidth	0.005 ms	- Mb
blockwishlist	3.917 ms	0.14 Mb
__construct	0.156 ms	0.01 Mb
hookActionFrontControllerSetMedia	0.600 ms	- Mb
hookDisplayFooter	3.161 ms	0.13 Mb
ps_emailsubscription	2.131 ms	0.10 Mb
__construct	0.145 ms	0.01 Mb
hookActionFrontControllerSetMedia	0.137 ms	- Mb
displayNewslettersubscription	1.849 ms	0.09 Mb
ps_socialfollow	2.368 ms	0.10 Mb
__construct	0.104 ms	0.01 Mb
hookActionFrontControllerSetMedia	0.227 ms	- Mb
displaySocialMediaBlock	2.037 ms	0.09 Mb
ps_emailalerts	0.312 ms	0.01 Mb
__construct	0.198 ms	0.01 Mb
hookActionFrontControllerSetMedia	0.114 ms	- Mb
monei	0.818 ms	0.07 Mb
__construct	0.812 ms	0.06 Mb
hookActionFrontControllerSetMedia	0.006 ms	- Mb
ps_facebook	165.280 ms	0.46 Mb
__construct	2.473 ms	- Mb
hookActionFrontControllerSetMedia	0.167 ms	- Mb
hookDisplayHeader	161.769 ms	0.46 Mb
hookDisplayFooter	0.871 ms	0.01 Mb
ps_shoppingcart	1.338 ms	0.10 Mb
__construct	0.112 ms	0.01 Mb
hookDisplayHeader	0.077 ms	- Mb
displayNavShoppingCartBlock	1.149 ms	0.09 Mb
ps_searchbar	1.056 ms	0.07 Mb
__construct	0.162 ms	0.07 Mb
hookDisplayHeader	0.894 ms	- Mb
ps_imageslider	0.599 ms	0.01 Mb
__construct	0.169 ms	0.01 Mb
hookDisplayHeader	0.430 ms	- Mb
productcomments	0.569 ms	0.01 Mb
__construct	0.103 ms	0.01 Mb
hookDisplayHeader	0.466 ms	- Mb
psxmarketingwithgoogle	3.975 ms	0.01 Mb
__construct	0.396 ms	0.01 Mb
hookDisplayHeader	3.579 ms	0.01 Mb
ps_googleanalytics	1.831 ms	0.03 Mb
__construct	0.158 ms	0.01 Mb
hookDisplayHeader	1.673 ms	0.02 Mb
tvcmsbestsellerproducts	25.299 ms	1.68 Mb
__construct	0.460 ms	0.01 Mb
hookDisplayHeader	0.145 ms	- Mb
hookDisplayLeftColumn	24.694 ms	1.68 Mb
tvcmsblogdisplayposts	0.878 ms	0.01 Mb
__construct	0.426 ms	0.01 Mb
hookDisplayHeader	0.452 ms	- Mb
tvcmsbrandlist	0.746 ms	0.01 Mb
__construct	0.394 ms	0.01 Mb
hookDisplayHeader	0.352 ms	- Mb
tvcmscategorychainslider	0.733 ms	0.01 Mb
__construct	0.397 ms	0.01 Mb
hookDisplayHeader	0.336 ms	- Mb
tvcmscategoryslider	0.764 ms	0.01 Mb
__construct	0.405 ms	0.01 Mb
hookDisplayHeader	0.359 ms	- Mb
tvcmscookiesnotice	1.671 ms	0.03 Mb
__construct	0.410 ms	0.01 Mb
hookDisplayHeader	0.341 ms	- Mb
hookDisplayAfterBodyOpeningTag	0.920 ms	0.02 Mb
tvcmscustomerservices	1.679 ms	0.09 Mb
__construct	0.389 ms	0.01 Mb
hookDisplayHeader	0.354 ms	- Mb
hookDisplayLeftColumn	0.936 ms	0.08 Mb
tvcmscustomsetting	8.749 ms	0.22 Mb
__construct	0.577 ms	0.01 Mb
hookDisplayHeader	2.174 ms	0.01 Mb
hookDisplayTopOfferText	0.013 ms	- Mb
hookDisplayTopOfferText	0.005 ms	- Mb
hookDisplayDownloadApps	0.908 ms	0.02 Mb
hookDisplayCustomsocialblock	4.258 ms	0.16 Mb
hookDisplayCopyRightText	0.814 ms	0.01 Mb
tvcmsfeaturedproducts	40.808 ms	2.74 Mb
__construct	0.368 ms	0.01 Mb
hookDisplayHeader	0.142 ms	- Mb
hookDisplayLeftColumn	40.298 ms	2.73 Mb
tvcmsfooterlogo	0.406 ms	0.01 Mb
__construct	0.404 ms	0.01 Mb
hookDisplayHeader	0.002 ms	- Mb
tvcmsfooterproduct	0.491 ms	0.01 Mb
__construct	0.353 ms	0.01 Mb
hookDisplayHeader	0.138 ms	- Mb
tvcmsnewproducts	40.956 ms	0.90 Mb
__construct	0.341 ms	0.01 Mb
hookDisplayHeader	0.145 ms	- Mb
hookDisplayLeftColumn	40.470 ms	0.89 Mb
tvcmsnewsletterpopup	1.066 ms	0.01 Mb
__construct	0.386 ms	0.01 Mb
hookDisplayHeader	0.680 ms	- Mb
tvcmspaymenticon	1.836 ms	0.05 Mb
__construct	0.395 ms	0.01 Mb
hookDisplayHeader	0.002 ms	- Mb
hookDisplayPaymentIcon	1.439 ms	0.04 Mb
tvcmsproductcomments	48.345 ms	3.80 Mb
__construct	0.386 ms	0.01 Mb
hookDisplayHeader	1.359 ms	- Mb
hookDisplayReviewProductList	1.437 ms	0.12 Mb
hookDisplayReviewProductList	0.922 ms	0.07 Mb
hookDisplayReviewProductList	0.892 ms	0.07 Mb
hookDisplayReviewProductList	0.925 ms	0.07 Mb
hookDisplayReviewProductList	1.060 ms	0.11 Mb
hookDisplayReviewProductList	1.015 ms	0.07 Mb
hookDisplayReviewProductList	1.012 ms	0.07 Mb
hookDisplayReviewProductList	1.016 ms	0.06 Mb
hookDisplayReviewProductList	1.064 ms	0.11 Mb
hookDisplayReviewProductList	0.905 ms	0.07 Mb
hookDisplayReviewProductList	0.903 ms	0.07 Mb
hookDisplayReviewProductList	0.873 ms	0.06 Mb
hookDisplayReviewProductList	1.077 ms	0.11 Mb
hookDisplayReviewProductList	0.916 ms	0.07 Mb
hookDisplayReviewProductList	0.895 ms	0.07 Mb
hookDisplayReviewProductList	0.845 ms	0.06 Mb
hookDisplayReviewProductList	1.103 ms	0.14 Mb
hookDisplayReviewProductList	0.960 ms	0.07 Mb
hookDisplayReviewProductList	0.909 ms	0.07 Mb
hookDisplayReviewProductList	0.869 ms	0.06 Mb
hookDisplayReviewProductList	1.061 ms	0.11 Mb
hookDisplayReviewProductList	0.902 ms	0.07 Mb
hookDisplayReviewProductList	0.883 ms	0.07 Mb
hookDisplayReviewProductList	0.899 ms	0.06 Mb
hookDisplayReviewProductList	1.125 ms	0.11 Mb
hookDisplayReviewProductList	0.923 ms	0.07 Mb
hookDisplayReviewProductList	0.888 ms	0.07 Mb
hookDisplayReviewProductList	0.867 ms	0.06 Mb
hookDisplayReviewProductList	1.110 ms	0.11 Mb
hookDisplayReviewProductList	0.917 ms	0.07 Mb
hookDisplayReviewProductList	0.917 ms	0.07 Mb
hookDisplayReviewProductList	0.859 ms	0.06 Mb
hookDisplayReviewProductList	1.084 ms	0.11 Mb
hookDisplayReviewProductList	0.911 ms	0.07 Mb
hookDisplayReviewProductList	0.900 ms	0.07 Mb
hookDisplayReviewProductList	0.858 ms	0.06 Mb
hookDisplayReviewProductList	1.059 ms	0.11 Mb
hookDisplayReviewProductList	0.922 ms	0.07 Mb
hookDisplayReviewProductList	0.976 ms	0.07 Mb
hookDisplayReviewProductList	0.934 ms	0.06 Mb
hookDisplayReviewProductList	1.163 ms	0.11 Mb
hookDisplayReviewProductList	1.089 ms	0.07 Mb
hookDisplayReviewProductList	0.971 ms	0.07 Mb
hookDisplayReviewProductList	0.934 ms	0.06 Mb
hookDisplayReviewProductList	1.121 ms	0.11 Mb
hookDisplayReviewProductList	0.950 ms	0.07 Mb
hookDisplayReviewProductList	0.903 ms	0.07 Mb
hookDisplayReviewProductList	0.876 ms	0.06 Mb
tvcmsproductcompare	29.952 ms	0.14 Mb
__construct	0.335 ms	0.01 Mb
hookDisplayHeader	0.357 ms	- Mb
hookDisplayNavProductCompareBlock	0.860 ms	0.01 Mb
hookDisplayProductCompareProductList	0.882 ms	0.01 Mb
hookDisplayProductCompareProductList	0.566 ms	- Mb
hookDisplayProductCompareProductList	0.580 ms	- Mb
hookDisplayProductCompareProductList	0.585 ms	- Mb
hookDisplayProductCompareProductList	0.580 ms	- Mb
hookDisplayProductCompareProductList	0.559 ms	- Mb
hookDisplayProductCompareProductList	0.597 ms	- Mb
hookDisplayProductCompareProductList	0.579 ms	- Mb
hookDisplayProductCompareProductList	0.586 ms	- Mb
hookDisplayProductCompareProductList	0.581 ms	- Mb
hookDisplayProductCompareProductList	0.533 ms	- Mb
hookDisplayProductCompareProductList	0.575 ms	- Mb
hookDisplayProductCompareProductList	0.594 ms	- Mb
hookDisplayProductCompareProductList	0.561 ms	- Mb
hookDisplayProductCompareProductList	0.555 ms	- Mb
hookDisplayProductCompareProductList	0.579 ms	- Mb
hookDisplayProductCompareProductList	0.557 ms	- Mb
hookDisplayProductCompareProductList	0.582 ms	- Mb
hookDisplayProductCompareProductList	0.532 ms	- Mb
hookDisplayProductCompareProductList	0.579 ms	- Mb
hookDisplayProductCompareProductList	0.561 ms	- Mb
hookDisplayProductCompareProductList	0.572 ms	- Mb
hookDisplayProductCompareProductList	0.546 ms	- Mb
hookDisplayProductCompareProductList	0.577 ms	- Mb
hookDisplayProductCompareProductList	0.581 ms	- Mb
hookDisplayProductCompareProductList	0.583 ms	- Mb
hookDisplayProductCompareProductList	0.527 ms	- Mb
hookDisplayProductCompareProductList	0.560 ms	- Mb
hookDisplayProductCompareProductList	0.600 ms	- Mb
hookDisplayProductCompareProductList	0.563 ms	- Mb
hookDisplayProductCompareProductList	0.522 ms	- Mb
hookDisplayProductCompareProductList	0.583 ms	- Mb
hookDisplayProductCompareProductList	0.561 ms	- Mb
hookDisplayProductCompareProductList	0.572 ms	- Mb
hookDisplayProductCompareProductList	0.525 ms	- Mb
hookDisplayProductCompareProductList	0.575 ms	- Mb
hookDisplayProductCompareProductList	0.579 ms	- Mb
hookDisplayProductCompareProductList	0.559 ms	- Mb
hookDisplayProductCompareProductList	0.522 ms	- Mb
hookDisplayProductCompareProductList	0.584 ms	- Mb
hookDisplayProductCompareProductList	0.607 ms	- Mb
hookDisplayProductCompareProductList	0.564 ms	- Mb
hookDisplayProductCompareProductList	0.517 ms	- Mb
hookDisplayProductCompareProductList	0.560 ms	- Mb
hookDisplayProductCompareProductList	0.600 ms	- Mb
hookDisplayProductCompareProductList	0.565 ms	- Mb
hookDisplayProductCompareProductList	0.534 ms	- Mb
hookDisplayProductCompareProductList	0.576 ms	- Mb
hookDisplayProductComparesticky	0.883 ms	0.01 Mb
tvcmsproductpopup	66.335 ms	2.75 Mb
__construct	0.102 ms	0.01 Mb
hookDisplayHeader	0.332 ms	- Mb
hookDisplayAfterBodyOpeningTag	65.901 ms	2.74 Mb
tvcmssearch	7.536 ms	1.49 Mb
__construct	0.318 ms	0.01 Mb
hookDisplayHeader	0.920 ms	- Mb
hookDisplayNavSearchBlock	6.298 ms	1.48 Mb
tvcmssizechart	0.724 ms	0.01 Mb
__construct	0.360 ms	0.01 Mb
hookDisplayHeader	0.364 ms	- Mb
tvcmsslider	0.761 ms	0.01 Mb
__construct	0.424 ms	0.01 Mb
hookDisplayHeader	0.337 ms	- Mb
tvcmsspecialproducts	2.469 ms	0.11 Mb
__construct	0.359 ms	0.01 Mb
hookDisplayHeader	0.160 ms	- Mb
hookDisplayLeftColumn	1.950 ms	0.10 Mb
tvcmsstockinfo	11.246 ms	0.70 Mb
__construct	0.317 ms	0.01 Mb
hookHeader	0.440 ms	- Mb
hookDisplayProductListStockIndicator	0.868 ms	0.03 Mb
hookDisplayProductListStockIndicator	0.287 ms	0.01 Mb
hookDisplayProductListStockIndicator	0.325 ms	0.01 Mb
hookDisplayProductListStockIndicator	0.283 ms	0.01 Mb
hookDisplayProductListStockIndicator	0.529 ms	0.05 Mb
hookDisplayProductListStockIndicator	0.541 ms	0.05 Mb
hookDisplayProductListStockIndicator	0.501 ms	0.05 Mb
hookDisplayProductListStockIndicator	0.503 ms	0.05 Mb
hookDisplayProductListStockIndicator	0.304 ms	0.01 Mb
hookDisplayProductListStockIndicator	0.280 ms	0.01 Mb
hookDisplayProductListStockIndicator	0.286 ms	0.01 Mb
hookDisplayProductListStockIndicator	0.283 ms	0.01 Mb
hookDisplayProductListStockIndicator	0.540 ms	0.05 Mb
hookDisplayProductListStockIndicator	0.522 ms	0.05 Mb
hookDisplayProductListStockIndicator	0.509 ms	0.05 Mb
hookDisplayProductListStockIndicator	0.490 ms	0.05 Mb
hookDisplayProductListStockIndicator	0.312 ms	0.01 Mb
hookDisplayProductListStockIndicator	0.282 ms	0.01 Mb
hookDisplayProductListStockIndicator	0.341 ms	0.01 Mb
hookDisplayProductListStockIndicator	0.283 ms	0.01 Mb
hookDisplayProductListStockIndicator	0.648 ms	0.05 Mb
hookDisplayProductListStockIndicator	0.553 ms	0.05 Mb
hookDisplayProductListStockIndicator	0.501 ms	0.05 Mb
hookDisplayProductListStockIndicator	0.518 ms	0.05 Mb
tvcmsstoretime	0.710 ms	0.01 Mb
__construct	0.375 ms	- Mb
hookDisplayHeader	0.335 ms	- Mb
tvcmstabproducts	0.698 ms	0.01 Mb
__construct	0.322 ms	0.01 Mb
hookDisplayHeader	0.376 ms	- Mb
tvcmstestimonial	0.757 ms	0.01 Mb
__construct	0.401 ms	0.01 Mb
hookDisplayHeader	0.356 ms	- Mb
tvcmsthemeoptions	1.415 ms	0.01 Mb
__construct	0.358 ms	0.01 Mb
hookDisplayHeader	1.057 ms	- Mb
tvcmsvideoblock	0.752 ms	0.01 Mb
__construct	0.414 ms	0.01 Mb
hookDisplayHeader	0.338 ms	- Mb
tvcmswishlist	32.049 ms	0.10 Mb
__construct	0.343 ms	0.01 Mb
hookDisplayHeader	0.379 ms	- Mb
hookDisplayNavWishlistBlock	1.299 ms	0.04 Mb
hookDisplayWishlistBtnProductList	0.851 ms	0.01 Mb
hookDisplayWishlistBtnProductList	0.597 ms	- Mb
hookDisplayWishlistBtnProductList	0.576 ms	- Mb
hookDisplayWishlistBtnProductList	0.580 ms	- Mb
hookDisplayWishlistBtnProductList	0.587 ms	- Mb
hookDisplayWishlistBtnProductList	0.598 ms	- Mb
hookDisplayWishlistBtnProductList	0.594 ms	- Mb
hookDisplayWishlistBtnProductList	0.577 ms	- Mb
hookDisplayWishlistBtnProductList	0.605 ms	- Mb
hookDisplayWishlistBtnProductList	0.632 ms	- Mb
hookDisplayWishlistBtnProductList	0.580 ms	- Mb
hookDisplayWishlistBtnProductList	0.582 ms	- Mb
hookDisplayWishlistBtnProductList	0.619 ms	- Mb
hookDisplayWishlistBtnProductList	0.581 ms	- Mb
hookDisplayWishlistBtnProductList	0.600 ms	- Mb
hookDisplayWishlistBtnProductList	0.591 ms	- Mb
hookDisplayWishlistBtnProductList	0.589 ms	- Mb
hookDisplayWishlistBtnProductList	0.576 ms	- Mb
hookDisplayWishlistBtnProductList	0.592 ms	- Mb
hookDisplayWishlistBtnProductList	0.607 ms	- Mb
hookDisplayWishlistBtnProductList	0.592 ms	- Mb
hookDisplayWishlistBtnProductList	0.575 ms	- Mb
hookDisplayWishlistBtnProductList	0.592 ms	- Mb
hookDisplayWishlistBtnProductList	0.577 ms	- Mb
hookDisplayWishlistBtnProductList	0.601 ms	- Mb
hookDisplayWishlistBtnProductList	0.580 ms	- Mb
hookDisplayWishlistBtnProductList	0.580 ms	- Mb
hookDisplayWishlistBtnProductList	0.591 ms	- Mb
hookDisplayWishlistBtnProductList	0.582 ms	- Mb
hookDisplayWishlistBtnProductList	0.591 ms	- Mb
hookDisplayWishlistBtnProductList	0.594 ms	- Mb
hookDisplayWishlistBtnProductList	0.597 ms	- Mb
hookDisplayWishlistBtnProductList	0.591 ms	- Mb
hookDisplayWishlistBtnProductList	0.575 ms	- Mb
hookDisplayWishlistBtnProductList	0.594 ms	- Mb
hookDisplayWishlistBtnProductList	0.630 ms	- Mb
hookDisplayWishlistBtnProductList	0.591 ms	- Mb
hookDisplayWishlistBtnProductList	0.591 ms	- Mb
hookDisplayWishlistBtnProductList	0.601 ms	- Mb
hookDisplayWishlistBtnProductList	0.602 ms	- Mb
hookDisplayWishlistBtnProductList	0.663 ms	- Mb
hookDisplayWishlistBtnProductList	0.593 ms	- Mb
hookDisplayWishlistBtnProductList	0.597 ms	- Mb
hookDisplayWishlistBtnProductList	0.593 ms	- Mb
hookDisplayWishlistBtnProductList	0.583 ms	- Mb
hookDisplayWishlistBtnProductList	0.594 ms	- Mb
hookDisplayWishlistBtnProductList	0.591 ms	- Mb
hookDisplayWishlistBtnProductList	0.576 ms	- Mb
hookDisplayNavWishlistBlocksticky	1.297 ms	0.05 Mb
smartargetwhatsapp	1.233 ms	0.01 Mb
__construct	0.353 ms	0.01 Mb
hookDisplayHeader	0.880 ms	0.01 Mb
ps_accounts	0.661 ms	- Mb
__construct	0.661 ms	- Mb
tvcmsinfinitescroll	2.802 ms	0.06 Mb
__construct	0.395 ms	0.01 Mb
hookHeader	2.407 ms	0.05 Mb
tvcmscategoryproduct	0.830 ms	0.03 Mb
__construct	0.435 ms	0.01 Mb
hookHeader	0.395 ms	0.02 Mb
tvcmsmegamenu	9.545 ms	0.71 Mb
__construct	0.444 ms	0.01 Mb
hookHeader	0.381 ms	0.02 Mb
hookDisplayMegamenu	8.720 ms	0.68 Mb
tvcmstwoofferbanner	0.767 ms	0.02 Mb
__construct	0.359 ms	- Mb
hookHeader	0.408 ms	0.02 Mb
ps_facetedsearch	3.834 ms	0.13 Mb
__construct	1.576 ms	0.01 Mb
hookProductSearchProvider	1.697 ms	0.03 Mb
hookDisplayFacetedSearchBlock	0.561 ms	0.09 Mb
tvcmscustomcssjs	0.414 ms	0.01 Mb
__construct	0.397 ms	0.01 Mb
hookDisplayCustomCss	0.008 ms	- Mb
hookDisplayCustomJs	0.009 ms	- Mb
ps_customersignin	0.992 ms	0.06 Mb
__construct	0.120 ms	0.01 Mb
displayNavCustomerSignInBlock	0.872 ms	0.05 Mb
ps_languageselector	0.396 ms	0.06 Mb
__construct	0.110 ms	0.01 Mb
displayNavLanguageBlock	0.286 ms	0.05 Mb
ps_currencyselector	0.370 ms	0.06 Mb
__construct	0.104 ms	0.01 Mb
displayNavCurrencyBlock	0.266 ms	0.05 Mb
ps_contactinfo	2.141 ms	0.12 Mb
__construct	0.106 ms	0.01 Mb
displayNav1	1.105 ms	0.09 Mb
displayContactCinfo	0.930 ms	0.03 Mb
ps_categorytree	19.147 ms	1.82 Mb
__construct	0.116 ms	0.01 Mb
displayLeftColumn	19.031 ms	1.82 Mb
ps_brandlist	2.193 ms	0.08 Mb
__construct	0.121 ms	0.01 Mb
displayLeftColumn	2.072 ms	0.07 Mb
ps_supplierlist	2.127 ms	0.08 Mb
__construct	0.112 ms	0.01 Mb
displayLeftColumn	2.015 ms	0.07 Mb
ps_linklist	2.697 ms	0.09 Mb
__construct	0.611 ms	0.01 Mb
displayFooterPart1	2.086 ms	0.09 Mb
ps_customeraccountlinks	1.977 ms	0.09 Mb
__construct	0.128 ms	0.01 Mb
displayMyaccountcblock	1.849 ms	0.09 Mb
statsdata	1.801 ms	0.06 Mb
__construct	0.125 ms	0.01 Mb
hookDisplayBeforeBodyClosingTag	1.676 ms	0.05 Mb
64 module(s)	591.851 ms	19.80 Mb

#	Query	Time (ms)	Rows	Filesort	Group By	Location
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, 590, 731, 623, 22, 39, 734) 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)))	1424 ms	2099520000			/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)
367	SELECT SQL_NO_CACHE cp.id_category, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM ps_product p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN ps_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' GROUP BY p.id_product) p INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_category_group cg ON (cg.id_category = c.id_category) WHERE cg.id_group='1' AND c.level_depth<=2 AND c.nleft>2 AND c.nright<1457 GROUP BY cp.id_category	761.601 ms	99144			/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)
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, 590, 731, 623, 22, 39, 734) 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))	329.293 ms	2099520000			/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:778 (execute) /modules/ps_facetedsearch/src/Adapter/MySQL.php:757 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:505 (count) /modules/ps_facetedsearch/src/Filters/Block.php:140 (getAvailabilitiesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
360	SELECT SQL_NO_CACHE COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM ps_product p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN ps_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND cp.id_category IN (723, 590, 731, 623, 22, 39, 734) 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))	327.334 ms	2099520000			/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)
357	SELECT SQL_NO_CACHE p.id_product FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM ps_product p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN ps_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND cp.id_category IN (723, 590, 731, 623, 22, 39, 734) 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	55.732 ms	1049760000	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)
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, 590, 731, 623, 22, 39, 734) GROUP BY p.id_product) p WHERE p.date_add>'2022-11-05 00:00:00'	54.602 ms	1049760000			/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)
375	SELECT SQL_NO_CACHE p.id_manufacturer, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM ps_product p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN ps_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND cp.id_category IN (723, 590, 731, 623, 22, 39, 734) GROUP BY p.id_product) p GROUP BY p.id_manufacturer	51.767 ms	1049760000	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)
376	SELECT SQL_NO_CACHE p.condition, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM ps_product p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN ps_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND cp.id_category IN (723, 590, 731, 623, 22, 39, 734) GROUP BY p.id_product) p GROUP BY p.condition	50.625 ms	1049760000	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)
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, 590, 731, 623, 22, 39, 734) GROUP BY p.id_product) p WHERE ((p.on_sale=1))	49.921 ms	1049760000			/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)
377	SELECT SQL_NO_CACHE MIN(p.weight) as min, MAX(p.weight) as max FROM ps_product p INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND cp.id_category IN (723, 590, 731, 623, 22, 39, 734)	47.680 ms	16200			/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)
365	SELECT SQL_NO_CACHE psi.price_min, MIN(price_min) as min, MAX(price_max) as max FROM ps_product p INNER JOIN ps_layered_price_index psi ON (psi.id_product = p.id_product AND psi.id_shop = 1 AND psi.id_currency = 1 AND psi.id_country = 6) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND cp.id_category IN (723, 590, 731, 623, 22, 39, 734)	19.310 ms	9468			/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)
631	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	12.702 ms	24786			/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)
759	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	12.569 ms	24786			/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)
755	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.942 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)
778	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.900 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)
738	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.890 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)
43	SELECT SQL_NO_CACHE c.*, cl.`id_lang`, cl.`name`, cl.`description`, cl.`additional_description`, cl.`link_rewrite`, cl.`meta_title`, cl.`meta_keywords`, cl.`meta_description` FROM `ps_category` c INNER JOIN ps_category_shop category_shop ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1) LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND `id_lang` = 1 AND cl.id_shop = 1 ) LEFT JOIN `ps_category_group` cg ON (cg.`id_category` = c.`id_category`) WHERE `id_parent` = 2 AND `active` = 1 AND cg.`id_group` =1 GROUP BY c.`id_category` ORDER BY `level_depth` ASC, category_shop.`position` ASC	2.468 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)
366	SELECT SQL_NO_CACHE c.`id_category`, cl.`name` FROM `ps_category` c INNER JOIN ps_category_shop category_shop ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1) LEFT JOIN `ps_category_lang` cl ON c.`id_category` = cl.`id_category` AND cl.id_shop = 1 WHERE 1 AND `id_lang` = 1 AND c.`active` = 1 ORDER BY c.nleft, c.position	2.103 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)
13	SELECT SQL_NO_CACHE h.`name` as hook, m.`id_module`, h.`id_hook`, m.`name` as module FROM `ps_module` m INNER JOIN ps_module_shop module_shop ON (module_shop.id_module = m.id_module AND module_shop.id_shop = 1 AND module_shop.enable_device & 1) INNER JOIN `ps_hook_module` `hm` ON hm.`id_module` = m.`id_module` INNER JOIN `ps_hook` `h` ON hm.`id_hook` = h.`id_hook` LEFT JOIN `ps_module_group` `mg` ON mg.`id_module` = m.`id_module` WHERE (h.`name` != "paymentOptions") AND (hm.`id_shop` = 1) AND (mg.id_shop = 1 AND mg.`id_group` IN (1)) GROUP BY hm.id_hook, hm.id_module ORDER BY hm.`position`	1.892 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)
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`)	1.716 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)
393	SELECT SQL_NO_CACHE h.id_hook, h.name as h_name, title, description, h.position, hm.position as hm_position, m.id_module, m.name, m.active FROM `ps_hook_module` hm STRAIGHT_JOIN `ps_hook` h ON (h.id_hook = hm.id_hook AND hm.id_shop = 1) STRAIGHT_JOIN `ps_module` as m ON (m.id_module = hm.id_module) ORDER BY hm.position	1.288 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)
392	SELECT SQL_NO_CACHE `id_hook`, `name` FROM `ps_hook` UNION SELECT `id_hook`, ha.`alias` as name FROM `ps_hook_alias` ha INNER JOIN `ps_hook` h ON ha.name = h.name	1.184 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)
582	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` = 93 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	1.147 ms	3	Yes		/classes/SpecificPrice.php:576 /classes/Product.php:3827 (getSpecificPrice) /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)
339	SELECT SQL_NO_CACHE p., product_shop., stock.out_of_stock, IFNULL(stock.quantity, 0) AS quantity, IFNULL(product_attribute_shop.id_product_attribute, 0) AS id_product_attribute, product_attribute_shop.minimal_quantity AS product_attribute_minimal_quantity, pl.`description`, pl.`description_short`, pl.`available_now`, pl.`available_later`, pl.`link_rewrite`, pl.`meta_description`, pl.`meta_keywords`, pl.`meta_title`, pl.`name`, image_shop.`id_image` id_image, il.`legend` as legend, m.`name` AS manufacturer_name, cl.`name` AS category_default, DATEDIFF(product_shop.`date_add`, DATE_SUB("2025-07-31 00:00:00", INTERVAL 1000 DAY)) > 0 AS new, product_shop.price AS orderprice FROM `ps_category_product` cp LEFT JOIN `ps_product` p ON p.`id_product` = cp.`id_product` INNER JOIN ps_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) LEFT JOIN `ps_product_attribute_shop` product_attribute_shop ON (p.`id_product` = product_attribute_shop.`id_product` AND product_attribute_shop.`default_on` = 1 AND product_attribute_shop.id_shop=1) LEFT JOIN ps_stock_available stock ON (stock.id_product = `p`.id_product AND stock.id_product_attribute = 0 AND stock.id_shop = 1 AND stock.id_shop_group = 0 ) LEFT JOIN `ps_category_lang` cl ON (product_shop.`id_category_default` = cl.`id_category` AND cl.`id_lang` = 1 AND cl.id_shop = 1 ) LEFT JOIN `ps_product_lang` pl ON (p.`id_product` = pl.`id_product` AND pl.`id_lang` = 1 AND pl.id_shop = 1 ) LEFT JOIN `ps_image_shop` image_shop ON (image_shop.`id_product` = p.`id_product` AND image_shop.cover=1 AND image_shop.id_shop=1) LEFT JOIN `ps_image_lang` il ON (image_shop.`id_image` = il.`id_image` AND il.`id_lang` = 1) LEFT JOIN `ps_manufacturer` m ON m.`id_manufacturer` = p.`id_manufacturer` WHERE product_shop.`id_shop` = 1 AND cp.`id_category` = 2 AND product_shop.`active` = 1 AND product_shop.`visibility` IN ("both", "catalog") ORDER BY cp.`position` ASC LIMIT 0,12	0.978 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)
876	SELECT SQL_NO_CACHE p., product_shop., stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, product_attribute_shop.minimal_quantity AS product_attribute_minimal_quantity,IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, pl.`description`, pl.`description_short`, pl.`link_rewrite`, pl.`meta_description`, pl.`meta_keywords`, pl.`meta_title`, pl.`name`, pl.`available_now`, pl.`available_later`, m.`name` AS manufacturer_name, p.`id_manufacturer` as id_manufacturer, image_shop.`id_image` id_image, il.`legend`, ps.`quantity` AS sales, t.`rate`, pl.`meta_keywords`, pl.`meta_title`, pl.`meta_description`, DATEDIFF(p.`date_add`, DATE_SUB("2025-07-31 00:00:00", INTERVAL 1000 DAY)) > 0 AS new FROM `ps_product_sale` ps LEFT JOIN `ps_product` p ON ps.`id_product` = p.`id_product` LEFT JOIN ps_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) LEFT JOIN `ps_product_attribute_shop` product_attribute_shop ON (p.`id_product` = product_attribute_shop.`id_product` AND product_attribute_shop.`default_on` = 1 AND product_attribute_shop.id_shop=1) LEFT JOIN `ps_product_lang` pl ON p.`id_product` = pl.`id_product` AND pl.`id_lang` = 1 AND pl.id_shop = 1 LEFT JOIN `ps_image_shop` image_shop ON (image_shop.`id_product` = p.`id_product` AND image_shop.cover=1 AND image_shop.id_shop=1) LEFT JOIN `ps_image_lang` il ON (image_shop.`id_image` = il.`id_image` AND il.`id_lang` = 1) LEFT JOIN `ps_manufacturer` m ON (m.`id_manufacturer` = p.`id_manufacturer`) LEFT JOIN `ps_tax_rule` tr ON (product_shop.`id_tax_rules_group` = tr.`id_tax_rules_group`) AND tr.`id_country` = 6 AND tr.`id_state` = 0 LEFT JOIN `ps_tax` t ON (t.`id_tax` = tr.`id_tax`) LEFT JOIN ps_stock_available stock ON (stock.id_product = `p`.id_product AND stock.id_product_attribute = 0 AND stock.id_shop = 1 AND stock.id_shop_group = 0 ) WHERE product_shop.`active` = 1 AND product_shop.`visibility` != 'none' AND EXISTS(SELECT 1 FROM `ps_category_product` cp JOIN `ps_category_group` cg ON (cp.id_category = cg.id_category AND cg.`id_group` =1) WHERE cp.`id_product` = p.`id_product`) ORDER BY `sales` DESC LIMIT 0, 4	0.928 ms	2			/classes/ProductSale.php:151 /src/Adapter/BestSales/BestSalesProductSearchProvider.php:74 (getBestSales) /modules/tvcmstabproducts/tvcmstabproducts.php:2925 (runQuery) /modules/tvcmsbestsellerproducts/tvcmsbestsellerproducts.php:156 (displayBestSellers) /modules/tvcmsbestsellerproducts/tvcmsbestsellerproducts.php:269 (showFrontSideResult) /classes/Hook.php:1083 (hookdisplayLeftColumn) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:421 (coreCallHook) /classes/Hook.php:989 (callHookOn) /config/smarty.config.inc.php:201 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/dev/smarty/compile/v1_giftoo_168layouts_layout_left_column_tpl/69/81/ba/6981ba7f75ae91c680b199f8c9b8d3dbd8d96719_2.file.layout-both-columns.tpl.php:192 (__call) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/v1_giftoo_168layouts_layout_left_column_tpl/69/81/ba/6981ba7f75ae91c680b199f8c9b8d3dbd8d96719_2.file.layout-both-columns.tpl.php:74 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_688bca89963334_98279087) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/v1_giftoo_168layouts_layout_left_column_tpl/8d/0f/a6/8d0fa6a125af07e8554a5461801ff205a85e918e_2.file.layout-left-column.tpl.php:28 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_688bca89918cb8_31976545) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/v1_giftoo_168layouts_layout_left_column_tpl/33/cf/b7/33cfb772f37fe9bf7e7da2f4ede7b9ba2ebdb1ff_2.file.product-list.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_688bca898f8023_38089402) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/v1_giftoo_168layouts_layout_left_column_tpl/a5/95/48/a595487cdf0e93c51d790aa7d81fde9f6d267539_2.file.category.tpl.php:29 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_688bca898bc698_82360211) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/Smarty/SmartyCustom.php:112 (fetch) /classes/controller/FrontController.php:771 (fetch) /classes/controller/FrontController.php:753 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
364	SELECT SQL_NO_CACHE COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM ps_product p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN ps_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND cp.id_category IN (723, 590, 731, 623, 22, 39, 734) 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:55:50' >= sp.from) AND (sp.to = '0000-00-00 00:00:00' OR '2025-07-31 22:55:50' <= sp.to) ) WHERE ((sp.reduction>0))	0.786 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)
369	SELECT SQL_NO_CACHE pac.id_attribute, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM ps_product p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN ps_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND cp.id_category IN (723, 590, 731, 623, 22, 39, 734) 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.702 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)
859	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.675 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)
962	SELECT SQL_NO_CACHE 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` = 1) LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1) WHERE pac.id_product_attribute IN (686,687,688,689,690,691,692,693,694,695,696,697,698,699,700,701,702,703,704,705,706,707,708,709,710,711,712,713,714,715) GROUP BY pac.id_product_attribute ORDER BY pac.id_product_attribute	0.671 ms	60			/classes/Product.php:2752 /src/Adapter/Presenter/Product/ProductLazyArray.php:663 (getAttributesResume) /src/Adapter/Presenter/Product/ProductLazyArray.php:505 (shouldShowOutOfStockLabel) /src/Adapter/Presenter/AbstractLazyArray.php:269 (getFlags) /var/cache/dev/smarty/compile/v1_giftoo_168layouts_layout_left_column_tpl/3a/64/40/3a64402dbc7e6570e1c5104e357fe82a876a78b9_2.file.product-grid-view.tpl.php:43 (offsetGet) /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/3a/64/40/3a64402dbc7e6570e1c5104e357fe82a876a78b9_2.file.product-grid-view.tpl.php:121 (instanceBlock) /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/3a/64/40/3a64402dbc7e6570e1c5104e357fe82a876a78b9_2.file.product-grid-view.tpl.php:30 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_688bca8b372f58_83600086) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:384 (render) /var/cache/dev/smarty/compile/v1_giftoo_168layouts_layout_left_column_tpl/d3/3b/d8/d33bd896585232850ede585856d13da0768b971d_2.file.product.tpl.php:50 (_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/d3/3b/d8/d33bd896585232850ede585856d13da0768b971d_2.file.product.tpl.php:34 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_688bca8b2de626_55894951) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:384 (render) /var/cache/dev/smarty/compile/v1_giftoo_168layouts_layout_left_column_tpl/00/19/6e/00196ea9a379d15da176d33bd3bf44ea480825b2_2.file.products.tpl.php:50 (_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/00/19/6e/00196ea9a379d15da176d33bd3bf44ea480825b2_2.file.products.tpl.php:34 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_688bca8b2c9485_64974469) /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/33/cf/b7/33cfb772f37fe9bf7e7da2f4ede7b9ba2ebdb1ff_2.file.product-list.tpl.php:78 (_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/33/cf/b7/33cfb772f37fe9bf7e7da2f4ede7b9ba2ebdb1ff_2.file.product-list.tpl.php:133 (instanceBlock) /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:186 (process) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/v1_giftoo_168layouts_layout_left_column_tpl/8d/0f/a6/8d0fa6a125af07e8554a5461801ff205a85e918e_2.file.layout-left-column.tpl.php:70 (instanceBlock) /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:186 (process) /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:76 (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)
12	SELECT SQL_NO_CACHE lower(name) as name FROM `ps_hook` h WHERE (h.active = 1)	0.665 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)
379	SELECT SQL_NO_CACHE pac.id_attribute, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM ps_product p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN ps_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND cp.id_category IN (723, 590, 731, 623, 22, 39, 734) 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.651 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)
383	SELECT SQL_NO_CACHE p., ps., pl.*, sa.out_of_stock, IFNULL(sa.quantity, 0) as quantity, (DATEDIFF( p.`date_add`, DATE_SUB( '2025-07-31 00:00:00', INTERVAL 1000 DAY ) ) > 0) as new FROM ps_product p LEFT JOIN ps_product_lang pl ON pl.id_product = p.id_product AND pl.id_shop = 1 AND pl.id_lang = 1 LEFT JOIN ps_stock_available sa ON sa.id_product = p.id_product AND sa.id_product_attribute = 0 AND sa.id_shop = 1 LEFT JOIN ps_product_shop ps ON ps.id_product = p.id_product AND ps.id_shop = 1 WHERE p.id_product IN (20832,20267,194,33,20873,20268,197,49,20914,20298,198,93)	0.616 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)
381	SELECT SQL_NO_CACHE pac.id_attribute, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM ps_product p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN ps_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND cp.id_category IN (723, 590, 731, 623, 22, 39, 734) GROUP BY p.id_product) p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) INNER JOIN ps_attribute a ON (a.id_attribute = pac.id_attribute) WHERE ((a.id_attribute_group=4)) GROUP BY pac.id_attribute	0.595 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)
22	SELECT SQL_NO_CACHE 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` = 1	0.575 ms	117			/classes/module/Module.php:346 /modules/psxdesign/psxdesign.php:68 (__construct) :undefined (__construct) /src/Core/Foundation/IoC/Container.php:123 (newInstance) /src/Core/Foundation/IoC/Container.php:153 (makeInstanceFromClassName) /src/Core/Foundation/IoC/Container.php:166 (doMake) /src/Adapter/ServiceLocator.php:70 (make) /classes/module/Module.php:1263 (get) /tools/profiling/Module.php:35 (coreLoadModule) /classes/module/Module.php:1242 (coreLoadModule) /classes/Hook.php:972 (getInstanceByName) /classes/Dispatcher.php:351 (exec) /index.php:28 (dispatch)
1118	SELECT SQL_NO_CACHE 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` = 1) LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1) WHERE pac.id_product_attribute IN (743,744,745,746,747,748,749,750,751,752,753,754,755,756,757,758,759,760,761,762) GROUP BY pac.id_product_attribute ORDER BY pac.id_product_attribute	0.569 ms	40			/classes/Product.php:2752 /src/Adapter/Presenter/Product/ProductLazyArray.php:663 (getAttributesResume) /src/Adapter/Presenter/Product/ProductLazyArray.php:505 (shouldShowOutOfStockLabel) /src/Adapter/Presenter/AbstractLazyArray.php:269 (getFlags) /var/cache/dev/smarty/compile/v1_giftoo_168layouts_layout_left_column_tpl/3a/64/40/3a64402dbc7e6570e1c5104e357fe82a876a78b9_2.file.product-grid-view.tpl.php:43 (offsetGet) /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/3a/64/40/3a64402dbc7e6570e1c5104e357fe82a876a78b9_2.file.product-grid-view.tpl.php:121 (instanceBlock) /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/3a/64/40/3a64402dbc7e6570e1c5104e357fe82a876a78b9_2.file.product-grid-view.tpl.php:30 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_688bca8b372f58_83600086) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:384 (render) /var/cache/dev/smarty/compile/v1_giftoo_168layouts_layout_left_column_tpl/d3/3b/d8/d33bd896585232850ede585856d13da0768b971d_2.file.product.tpl.php:50 (_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/d3/3b/d8/d33bd896585232850ede585856d13da0768b971d_2.file.product.tpl.php:34 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_688bca8b2de626_55894951) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:384 (render) /var/cache/dev/smarty/compile/v1_giftoo_168layouts_layout_left_column_tpl/00/19/6e/00196ea9a379d15da176d33bd3bf44ea480825b2_2.file.products.tpl.php:50 (_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/00/19/6e/00196ea9a379d15da176d33bd3bf44ea480825b2_2.file.products.tpl.php:34 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_688bca8b2c9485_64974469) /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/33/cf/b7/33cfb772f37fe9bf7e7da2f4ede7b9ba2ebdb1ff_2.file.product-list.tpl.php:78 (_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/33/cf/b7/33cfb772f37fe9bf7e7da2f4ede7b9ba2ebdb1ff_2.file.product-list.tpl.php:133 (instanceBlock) /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:186 (process) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/v1_giftoo_168layouts_layout_left_column_tpl/8d/0f/a6/8d0fa6a125af07e8554a5461801ff205a85e918e_2.file.layout-left-column.tpl.php:70 (instanceBlock) /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:186 (process) /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:76 (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)
371	SELECT SQL_NO_CACHE pac.id_attribute, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM ps_product p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN ps_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND cp.id_category IN (723, 590, 731, 623, 22, 39, 734) 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	0.565 ms	2800	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)
1044	SELECT SQL_NO_CACHE 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` = 1) LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1) WHERE pac.id_product_attribute IN (723,724,725,726,727,728,729,730,731,732,733,734,735,736,737,738,739,740,741,742) GROUP BY pac.id_product_attribute ORDER BY pac.id_product_attribute	0.557 ms	40			/classes/Product.php:2752 /src/Adapter/Presenter/Product/ProductLazyArray.php:663 (getAttributesResume) /src/Adapter/Presenter/Product/ProductLazyArray.php:505 (shouldShowOutOfStockLabel) /src/Adapter/Presenter/AbstractLazyArray.php:269 (getFlags) /var/cache/dev/smarty/compile/v1_giftoo_168layouts_layout_left_column_tpl/3a/64/40/3a64402dbc7e6570e1c5104e357fe82a876a78b9_2.file.product-grid-view.tpl.php:43 (offsetGet) /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/3a/64/40/3a64402dbc7e6570e1c5104e357fe82a876a78b9_2.file.product-grid-view.tpl.php:121 (instanceBlock) /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/3a/64/40/3a64402dbc7e6570e1c5104e357fe82a876a78b9_2.file.product-grid-view.tpl.php:30 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_688bca8b372f58_83600086) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:384 (render) /var/cache/dev/smarty/compile/v1_giftoo_168layouts_layout_left_column_tpl/d3/3b/d8/d33bd896585232850ede585856d13da0768b971d_2.file.product.tpl.php:50 (_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/d3/3b/d8/d33bd896585232850ede585856d13da0768b971d_2.file.product.tpl.php:34 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_688bca8b2de626_55894951) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:384 (render) /var/cache/dev/smarty/compile/v1_giftoo_168layouts_layout_left_column_tpl/00/19/6e/00196ea9a379d15da176d33bd3bf44ea480825b2_2.file.products.tpl.php:50 (_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/00/19/6e/00196ea9a379d15da176d33bd3bf44ea480825b2_2.file.products.tpl.php:34 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_688bca8b2c9485_64974469) /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/33/cf/b7/33cfb772f37fe9bf7e7da2f4ede7b9ba2ebdb1ff_2.file.product-list.tpl.php:78 (_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/33/cf/b7/33cfb772f37fe9bf7e7da2f4ede7b9ba2ebdb1ff_2.file.product-list.tpl.php:133 (instanceBlock) /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:186 (process) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/v1_giftoo_168layouts_layout_left_column_tpl/8d/0f/a6/8d0fa6a125af07e8554a5461801ff205a85e918e_2.file.layout-left-column.tpl.php:70 (instanceBlock) /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:186 (process) /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:76 (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)
374	SELECT SQL_NO_CACHE m.*, ml.`description`, ml.`short_description` FROM `ps_manufacturer` m INNER JOIN ps_manufacturer_shop manufacturer_shop ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 1)INNER JOIN `ps_manufacturer_lang` ml ON (m.`id_manufacturer` = ml.`id_manufacturer` AND ml.`id_lang` = 1)WHERE 1 AND m.`active` = 1 ORDER BY m.`name` ASC	0.548 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)
1187	INSERT INTO `ps_connections_source` (`id_connections`, `http_referer`, `request_uri`, `keywords`, `date_add`) VALUES ('268842', '', 'nocta.es/2-inicio?q=Categor%C3%ADas-Biombo-Gazebo-Set+andamios-Sof%C3%A1%5C-cama%5C-perro-Take+Away-Textil-Tienda+playa', '', '2025-07-31 22:55:51')	0.544 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)
372	SELECT SQL_NO_CACHE fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM ps_product p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN ps_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND cp.id_category IN (723, 590, 731, 623, 22, 39, 734) 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.530 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)

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
117 queries	SELECT SUM(quantity) FROM `ps_stock_available` WHERE (id_product = XX) AND (id_product_attribute = XX) AND (id_shop = XX) AND (id_shop_group = XX) LIMIT XX
48 queries	SELECT (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS grade FROM `ps_tvcmsproduct_comment` pc WHERE pc.`id_product` = XX AND pc.`deleted` = XX AND pc.`validate` = XX LIMIT XX
48 queries	SELECT (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS avg, MIN(pc.`grade`) AS min, MAX(pc.`grade`) AS max FROM `ps_tvcmsproduct_comment` pc WHERE pc.`id_product` = XX AND pc.`deleted` = XX AND pc.`validate` = XX LIMIT XX
35 queries	SELECT COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), XX) as deep_quantity, COALESCE(SUM(first_level_quantity), XX) as quantity FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, XX as pack_quantity FROM `ps_cart_product` cp WHERE cp.`id_product_attribute` = XX AND cp.`id_cart` = XX AND cp.`id_product` = XX UNION SELECT XX as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity FROM `ps_cart_product` cp JOIN `ps_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `ps_product` pr ON p.`id_product_pack` = pr.`id_product` WHERE cp.`id_product_attribute` = XX AND cp.`id_cart` = XX AND p.`id_product_item` = XX AND (pr.`pack_stock_type` IN (XX,XX) OR ( pr.`pack_stock_type` = XX AND XX = XX ))) as q LIMIT XX
28 queries	SELECT image_shop.`cover`, i.`id_image`, il.`legend`, i.`position` FROM `ps_image` i INNER JOIN ps_image_shop image_shop ON (image_shop.id_image = i.id_image AND image_shop.id_shop = XX) LEFT JOIN `ps_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = XX) WHERE i.`id_product` = XX ORDER BY `position`
25 queries	SELECT XX FROM `ps_specific_price` WHERE id_product = XX LIMIT XX
24 queries	SELECT image_shop.`id_image` FROM `ps_image` i INNER JOIN ps_image_shop image_shop ON (image_shop.id_image = i.id_image AND image_shop.id_shop = XX) WHERE i.`id_product` = XX AND image_shop.`cover` = XX LIMIT XX
24 queries	SELECT name FROM ps_category_lang WHERE id_shop = XX AND id_lang = XX AND id_category = XX LIMIT XX
24 queries	SELECT * FROM `ps_product` a LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = XX LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = XX WHERE (a.`id_product` = XX) AND (b.`id_shop` = XX) LIMIT XX
24 queries	SELECT product_shop.`price`, product_shop.`ecotax`, IFNULL(product_attribute_shop.id_product_attribute,XX) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on, product_attribute_shop.`ecotax` AS attribute_ecotax FROM `ps_product` p INNER JOIN `ps_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = XX) LEFT JOIN `ps_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = XX) WHERE (p.`id_product` = XX)
24 queries	SELECT `id_tax_rules_group` FROM `ps_product_shop` WHERE `id_product` = XX AND id_shop=XX LIMIT XX
24 queries	SELECT `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = XX AND `id_group` = XX LIMIT XX
24 queries	SELECT COUNT(*) FROM `ps_pack` WHERE id_product_pack = XX LIMIT XX
24 queries	SELECT product_type FROM `ps_product` WHERE id_product = XX LIMIT XX
24 queries	SELECT name, value, pf.id_feature, f.position, fvl.id_feature_value FROM ps_feature_product pf LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = XX) LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = XX) LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = XX) INNER JOIN ps_feature_shop feature_shop ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = XX) WHERE pf.id_product = XX ORDER BY f.position ASC
22 queries	SELECT `id_product_attribute` FROM `ps_product_attribute` WHERE `id_product` = XX
18 queries	SELECT `id_module` FROM `ps_module_shop` WHERE `id_module` = XX AND `id_shop` = XX LIMIT XX
16 queries	SELECT p., ps., pl.*, sa.out_of_stock, IFNULL(sa.quantity, XX) as quantity, (DATEDIFF( p.`date_add`, DATE_SUB( 'XX-XX-XX XX:XX:XX', INTERVAL XX DAY ) ) > XX) as new FROM ps_product p LEFT JOIN ps_product_lang pl ON pl.id_product = p.id_product AND pl.id_shop = XX AND pl.id_lang = XX LEFT JOIN ps_stock_available sa ON sa.id_product = p.id_product AND sa.id_product_attribute = XX AND sa.id_shop = XX LEFT JOIN ps_product_shop ps ON ps.id_product = p.id_product AND ps.id_shop = XX WHERE p.id_product IN (XX)
12 queries	SELECT cl.`link_rewrite` FROM `ps_category_lang` cl WHERE `id_lang` = XX AND cl.id_shop = XX AND cl.`id_category` = XX LIMIT XX
12 queries	SELECT COUNT(`id_tvcmsproduct_comment`) AS "nbr" FROM `ps_tvcmsproduct_comment` pc WHERE `id_product` = XX AND `validate` = XX LIMIT XX
12 queries	select count(pa.`id_product_attribute`) as `total` from `ps_product_attribute` pa inner join `ps_product_attribute_shop` pas on pa.id_product_attribute = pas.id_product_attribute where pas.`id_shop` = XX and pa.`id_product` = XX LIMIT XX
11 queries	SELECT product_attribute_shop.`price` FROM `ps_product_attribute` pa INNER JOIN ps_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = XX) WHERE pa.`id_product_attribute` = XX LIMIT XX
11 queries	SELECT pa.`available_date` FROM `ps_product` p LEFT JOIN `ps_product_attribute` pa ON (pa.`id_product` = p.`id_product`) INNER JOIN ps_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = XX) INNER JOIN ps_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = XX) WHERE p.`id_product` = XX AND pa.`id_product` = XX AND pa.`id_product_attribute` = XX LIMIT XX
11 queries	SELECT a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, agl.`public_name` as `public_group`, pa.`reference`, pa.`eanXX`, pa.`isbn`, pa.`upc`, pa.`mpn`, pal.`available_now`, pal.`available_later` FROM `ps_attribute` a LEFT JOIN `ps_attribute_lang` al ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = XX) LEFT JOIN `ps_product_attribute_combination` pac ON (pac.`id_attribute` = a.`id_attribute`) LEFT JOIN `ps_product_attribute` pa ON (pa.`id_product_attribute` = pac.`id_product_attribute`) INNER JOIN ps_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = XX) LEFT JOIN `ps_product_attribute_lang` pal ON (pal.`id_product_attribute` = pac.`id_product_attribute` AND pal.`id_lang` = XX) LEFT JOIN `ps_attribute_group_lang` agl ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = XX) WHERE pa.`id_product` = XX AND pac.`id_product_attribute` = XX AND agl.`id_lang` = XX
11 queries	SELECT * FROM `ps_product_attribute` a LEFT JOIN `ps_product_attribute_shop` `c` ON a.`id_product_attribute` = c.`id_product_attribute` AND c.`id_shop` = XX WHERE (a.`id_product_attribute` = XX) LIMIT XX
11 queries	SELECT * FROM `ps_product_attribute_lang` WHERE `id_product_attribute` = XX
8 queries	SELECT c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop` FROM `ps_category` c LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = XX ) INNER JOIN ps_category_shop category_shop ON (category_shop.id_category = c.id_category AND category_shop.id_shop = XX) WHERE `id_lang` = XX AND c.`id_parent` = XX AND `active` = XX GROUP BY c.`id_category` ORDER BY category_shop.`position` ASC
8 queries	SELECT cg.`id_group` FROM `ps_category_group` cg WHERE (cg.`id_category` = XX)
6 queries	SELECT m.`id_module`, m.`name`, ms.`id_module`as `mshop` FROM `ps_module` m LEFT JOIN `ps_module_shop` ms ON m.`id_module` = ms.`id_module` AND ms.`id_shop` = XX
6 queries	SELECT `priority`, `id_specific_price_priority` FROM `ps_specific_price_priority` WHERE `id_product` = XX ORDER BY `id_specific_price_priority` DESC LIMIT XX
6 queries	SELECT *, ( IF (`id_shop` = XX, XX, XX) + IF (`id_country` = XX, XX, XX) + IF (`id_currency` = XX, XX, XX) + IF (`id_group` = XX, XX, XX) + IF (`id_customer` = XX, XX, XX)) AS `score` FROM `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
6 queries	SELECT * FROM `ps_product` a LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = XX WHERE (a.`id_product` = XX) LIMIT XX
6 queries	SELECT * FROM `ps_product_lang` WHERE `id_product` = XX AND `id_shop` = XX
6 queries	SELECT pa., product_attribute_shop. FROM `ps_product_attribute` pa INNER JOIN ps_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = XX) WHERE pa.`id_product` = XX GROUP BY pa.`id_product_attribute` ORDER BY pa.`id_product_attribute`
5 queries	SELECT quantity, reserved_quantity FROM `ps_stock_available` WHERE (id_product = XX) AND (id_product_attribute = XX) AND (id_shop = XX) AND (id_shop_group = XX) LIMIT XX
4 queries	SELECT DISTINCT a.`id_attribute`, a.`color`, al.`name`, agl.`id_attribute_group`, IF(lialv.`url_name` IS NULL OR lialv.`url_name` = "", NULL, lialv.`url_name`) AS url_name, IF(lialv.`meta_title` IS NULL OR lialv.`meta_title` = "", NULL, lialv.`meta_title`) AS meta_title FROM `ps_attribute_group` ag INNER JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = XX) INNER JOIN `ps_attribute` a ON a.`id_attribute_group` = ag.`id_attribute_group` INNER JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = XX) INNER JOIN ps_attribute_group_shop attribute_group_shop ON (attribute_group_shop.id_attribute_group = ag.id_attribute_group AND attribute_group_shop.id_shop = XX) INNER JOIN ps_attribute_shop attribute_shop ON (attribute_shop.id_attribute = a.id_attribute AND attribute_shop.id_shop = XX) LEFT JOIN `ps_layered_indexable_attribute_lang_value` lialv ON (a.`id_attribute` = lialv.`id_attribute` AND lialv.`id_lang` = XX) WHERE ag.id_attribute_group = XX ORDER BY agl.`name` ASC, a.`position` ASC
4 queries	SELECT pac.id_attribute, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM ps_product p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, XX) = sa.id_product_attribute AND sa.id_shop = XX AND sa.id_shop_group = XX ) LEFT JOIN ps_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = XX AND ps.active = TRUE) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=XX) LEFT JOIN ps_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='XX' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='XX' AND cp.id_category IN (XX, XX, XX, XX, XX, XX, XX) GROUP BY p.id_product) p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) INNER JOIN ps_attribute a ON (a.id_attribute = pac.id_attribute) WHERE ((a.id_attribute_group=XX)) GROUP BY pac.id_attribute
4 queries	SELECT tr.* FROM `ps_tax_rule` tr JOIN `ps_tax_rules_group` trg ON (tr.`id_tax_rules_group` = trg.`id_tax_rules_group`) WHERE trg.`active` = XX AND tr.`id_country` = XX AND tr.`id_tax_rules_group` = XX AND tr.`id_state` IN (XX, XX) AND ('XX' BETWEEN tr.`zipcode_from` AND tr.`zipcode_to` OR (tr.`zipcode_to` = XX AND tr.`zipcode_from` IN(XX, 'XX'))) ORDER BY tr.`zipcode_from` DESC, tr.`zipcode_to` DESC, tr.`id_state` DESC, tr.`id_country` DESC
4 queries	SELECT mr.* FROM ps_tvcmsmegamenu_row_shop mr WHERE mr.`id_shop` = XX AND mr.id_tvcmsmegamenu = XX AND mr.`active` = XX

Name	Instances	Source
Category	324	/controllers/front/listing/CategoryController.php:78 (__construct) [id: 2] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 230] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 515] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 520] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 531] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 537] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 553] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 557] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 572] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 573] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 574] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 575] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 576] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 577] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 578] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 579] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 580] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 581] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 582] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 583] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 584] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 585] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 586] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 587] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 588] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 589] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 590] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 591] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 592] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 593] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 594] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 595] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 596] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 597] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 598] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 599] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 600] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 601] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 602] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 603] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 604] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 605] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 606] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 607] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 608] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 609] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 610] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 611] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 612] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 613] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 614] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 615] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 616] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 617] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 618] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 619] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 620] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 621] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 622] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 623] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 624] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 625] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 626] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 627] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 628] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 629] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 630] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 631] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 632] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 633] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 634] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 635] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 636] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 637] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 638] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 639] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 640] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 641] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 642] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 643] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 644] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 645] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 646] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 647] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 648] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 649] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 650] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 651] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 652] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 653] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 654] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 655] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 656] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 657] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 658] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 659] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 660] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 661] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 662] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 663] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 664] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 665] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 666] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 667] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 668] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 669] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 670] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 671] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 672] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 673] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 674] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 675] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 676] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 677] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 678] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 679] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 680] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 681] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 682] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 683] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 684] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 685] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 686] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 687] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 688] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 689] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 690] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 691] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 692] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 693] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 694] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 695] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 696] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 697] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 698] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 699] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 700] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 701] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 702] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 703] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 704] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 705] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 706] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 707] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 708] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 709] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 710] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 711] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 712] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 713] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 714] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 715] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 716] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 717] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 718] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 719] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 720] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 721] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 722] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 723] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 724] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 725] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 726] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 727] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 728] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 729] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 730] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 731] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 732] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 733] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 734] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 735] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 736] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 737] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 738] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 739] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 740] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 741] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 742] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 743] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 744] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 745] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 746] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 747] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 748] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 749] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 750] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 751] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 752] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 753] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 754] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 755] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 756] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 757] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 758] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 759] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 760] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 761] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 762] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 763] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 764] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 765] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 766] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 767] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 768] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 769] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 770] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 771] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 772] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 773] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 774] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 775] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 776] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 777] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 778] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 779] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 780] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 781] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 782] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 783] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 784] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 785] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 786] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 787] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 788] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 789] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 793] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 798] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 800] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 802] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 804] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 251] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 266] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 10] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 283] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 471] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 501] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 116] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 121] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 134] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 146] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 169] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 203] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 214] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 227] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 11] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 12] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 13] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 14] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 15] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 16] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 17] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 18] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 19] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 20] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 21] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 22] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 23] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 24] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 25] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 26] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 27] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 28] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 29] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 30] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 31] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 32] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 33] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 34] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 35] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 36] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 37] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 38] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 39] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 40] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 41] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 42] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 43] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 44] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 45] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 46] /classes/Meta.php:380 (__construct) [id: 2] /classes/PrestaShopCollection.php:385 (hydrateCollection) [id: ] /classes/Link.php:402 (__construct) [id: 2] /classes/PrestaShopCollection.php:385 (hydrateCollection) [id: ] /classes/Link.php:402 (__construct) [id: 2] /modules/ps_facetedsearch/src/Filters/Block.php:157 (__construct) [id: 2] /modules/tvcmsmegamenu/tvcmsmegamenu.php:1397 (__construct) [id: 121] /modules/tvcmsmegamenu/tvcmsmegamenu.php:1776 (__construct) [id: 121] /classes/Link.php:402 (__construct) [id: 121] /modules/tvcmsmegamenu/tvcmsmegamenu.php:1701 (__construct) [id: 121] /modules/tvcmsmegamenu/tvcmsmegamenu.php:1397 (__construct) [id: 116] /modules/tvcmsmegamenu/tvcmsmegamenu.php:1776 (__construct) [id: 116] /classes/Link.php:402 (__construct) [id: 116] /modules/tvcmsmegamenu/tvcmsmegamenu.php:1701 (__construct) [id: 116] /modules/tvcmsmegamenu/tvcmsmegamenu.php:1397 (__construct) [id: 146] /modules/tvcmsmegamenu/tvcmsmegamenu.php:1776 (__construct) [id: 146] /classes/Link.php:402 (__construct) [id: 146] /modules/tvcmsmegamenu/tvcmsmegamenu.php:1701 (__construct) [id: 146] /modules/tvcmsmegamenu/tvcmsmegamenu.php:1397 (__construct) [id: 214] /modules/tvcmsmegamenu/tvcmsmegamenu.php:1776 (__construct) [id: 214] /classes/Link.php:402 (__construct) [id: 214] /modules/tvcmsmegamenu/tvcmsmegamenu.php:1701 (__construct) [id: 214] /modules/tvcmsmegamenu/tvcmsmegamenu.php:1397 (__construct) [id: 134] /modules/tvcmsmegamenu/tvcmsmegamenu.php:1776 (__construct) [id: 134] /classes/Link.php:402 (__construct) [id: 134] /modules/tvcmsmegamenu/tvcmsmegamenu.php:1701 (__construct) [id: 134] /modules/tvcmsmegamenu/tvcmsmegamenu.php:1397 (__construct) [id: 227] /modules/tvcmsmegamenu/tvcmsmegamenu.php:1776 (__construct) [id: 227] /classes/Link.php:402 (__construct) [id: 227] /modules/tvcmsmegamenu/tvcmsmegamenu.php:1701 (__construct) [id: 227] /modules/tvcmsmegamenu/tvcmsmegamenu.php:1397 (__construct) [id: 203] /modules/tvcmsmegamenu/tvcmsmegamenu.php:1776 (__construct) [id: 203] /classes/Link.php:402 (__construct) [id: 203] /modules/tvcmsmegamenu/tvcmsmegamenu.php:1701 (__construct) [id: 203] /modules/tvcmsmegamenu/tvcmsmegamenu.php:1397 (__construct) [id: 169] /modules/tvcmsmegamenu/tvcmsmegamenu.php:1776 (__construct) [id: 169] /classes/Link.php:402 (__construct) [id: 169] /modules/tvcmsmegamenu/tvcmsmegamenu.php:1701 (__construct) [id: 169] /modules/tvcmssearch/tvcmssearch.php:100 (getNestedCategories) [id: 2] /modules/ps_categorytree/ps_categorytree.php:371 (__construct) [id: 2] /modules/ps_categorytree/ps_categorytree.php:364 (getParentsCategories) [id: 2] /modules/tvcmstabproducts/tvcmstabproducts.php:2729 (__construct) [id: 25] /classes/Link.php:402 (__construct) [id: 25]
Product	64	/classes/Link.php:113 (__construct) [id: 20832] /classes/Link.php:113 (__construct) [id: 20267] /classes/Link.php:113 (__construct) [id: 194] /classes/Link.php:113 (__construct) [id: 33] /classes/Link.php:113 (__construct) [id: 20873] /classes/Link.php:113 (__construct) [id: 20268] /classes/Link.php:113 (__construct) [id: 197] /classes/Link.php:113 (__construct) [id: 49] /classes/Link.php:113 (__construct) [id: 20914] /classes/Link.php:113 (__construct) [id: 20298] /classes/Link.php:113 (__construct) [id: 198] /classes/Link.php:113 (__construct) [id: 93] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 20832] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 20267] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 194] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 33] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 20873] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 20268] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 197] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 49] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 20914] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 20298] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 198] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 93] /classes/Link.php:113 (__construct) [id: 20832] /classes/Link.php:113 (__construct) [id: 20267] /classes/Link.php:113 (__construct) [id: 194] /classes/Link.php:113 (__construct) [id: 33] /classes/Link.php:113 (__construct) [id: 20873] /classes/Link.php:113 (__construct) [id: 20268] /classes/Link.php:113 (__construct) [id: 197] /classes/Link.php:113 (__construct) [id: 49] /classes/Link.php:113 (__construct) [id: 20914] /classes/Link.php:113 (__construct) [id: 20298] /classes/Link.php:113 (__construct) [id: 198] /classes/Link.php:113 (__construct) [id: 93] /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: 3293] /classes/Link.php:113 (__construct) [id: 3998] /classes/Link.php:113 (__construct) [id: 1616] /classes/Link.php:113 (__construct) [id: 3850] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 3293] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 3998] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 1616] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 3850] /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: 194] /src/Adapter/Presenter/Product/ProductLazyArray.php:658 (__construct) [id: 33] /src/Adapter/Presenter/Product/ProductLazyArray.php:658 (__construct) [id: 197] /src/Adapter/Presenter/Product/ProductLazyArray.php:658 (__construct) [id: 49] /src/Adapter/Presenter/Product/ProductLazyArray.php:658 (__construct) [id: 198] /src/Adapter/Presenter/Product/ProductLazyArray.php:658 (__construct) [id: 93]
Combination	11	/classes/Product.php:5912 (__construct) [id: 686] /classes/Product.php:5912 (__construct) [id: 64] /classes/Product.php:5912 (__construct) [id: 727] /classes/Product.php:5912 (__construct) [id: 110] /classes/Product.php:5912 (__construct) [id: 743] /classes/Product.php:5912 (__construct) [id: 331] /classes/Product.php:5912 (__construct) [id: 10949] /classes/Product.php:5912 (__construct) [id: 13693] /classes/Product.php:5912 (__construct) [id: 7268] /classes/Product.php:5912 (__construct) [id: 12881] /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

Chaqueta Molter

Chaqueta Molter

Chaqueta Molter

Chaqueta Molter

VELA VESTIDO DE NOVIA

VELA VESTIDO DE NOVIA

VELA VESTIDO DE NOVIA

VELA VESTIDO DE NOVIA

Parka Zylka

Parka Zylka

Parka Zylka

Parka Zylka

Nevera Coolcan

Nevera Coolcan

Nevera Coolcan

Nevera Coolcan

Impermeable Garu

Impermeable Garu

Impermeable Garu

Impermeable Garu

Bolsa Nevera Daniels

Bolsa Nevera Daniels

Bolsa Nevera Daniels

Bolsa Nevera Daniels

Stopwatch SQL - 1188 queries

Doubles

Tables stress

ObjectModel instances

Included Files