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	5025 ms
Querying Time	4280 ms
Queries	1257
Memory Peak Usage	39.4 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	22.547 ms	22.547 ms	2.99 Mb	3.3 Mb
__construct	0.036 ms	22.583 ms	- Mb	3.3 Mb
init	123.598 ms	146.181 ms	3.08 Mb	6.5 Mb
checkAccess	0.001 ms	146.182 ms	- Mb	6.5 Mb
setMedia	8.417 ms	154.599 ms	0.20 Mb	6.5 Mb
postProcess	0.001 ms	154.600 ms	- Mb	6.5 Mb
initHeader	0.001 ms	154.601 ms	- Mb	6.5 Mb
initContent	3589 ms	3744 ms	6.44 Mb	12.8 Mb
initFooter	0.002 ms	3744 ms	- Mb	12.8 Mb
display	1282 ms	5025 ms	25.33 Mb	39.4 Mb

Hook	Time	Memory Usage
DisplayLeftColumn	583.028 ms	5.66 Mb
=> tvcmsnewproducts	477.062 ms	0.89 Mb
=> tvcmscustomerservices	1.369 ms	0.08 Mb
=> tvcmsspecialproducts	2.622 ms	0.10 Mb
=> tvcmsfeaturedproducts	67.940 ms	2.92 Mb
=> tvcmsbestsellerproducts	34.035 ms	1.67 Mb
DisplayAfterBodyOpeningTag	376.314 ms	2.75 Mb
=> tvcmscookiesnotice	0.886 ms	0.02 Mb
=> blockreassurance	0.004 ms	- Mb
=> tvcmsproductpopup	375.424 ms	2.73 Mb
DisplayHeader	182.930 ms	0.56 Mb
=> ps_shoppingcart	0.078 ms	- Mb
=> ps_searchbar	0.901 ms	- Mb
=> ps_imageslider	0.431 ms	- Mb
=> productcomments	0.447 ms	- Mb
=> psxmarketingwithgoogle	3.568 ms	0.01 Mb
=> ps_googleanalytics	1.685 ms	0.02 Mb
=> tvcmsbestsellerproducts	0.151 ms	- Mb
=> tvcmsblog	0.701 ms	- Mb
=> tvcmsblogdisplayposts	0.453 ms	- Mb
=> tvcmsbrandlist	0.336 ms	- Mb
=> tvcmscategorychainslider	0.336 ms	- Mb
=> tvcmscategoryslider	0.338 ms	- Mb
=> tvcmscookiesnotice	0.353 ms	- Mb
=> tvcmscustomerservices	0.341 ms	- Mb
=> tvcmscustomsetting	2.123 ms	0.01 Mb
=> tvcmsfeaturedproducts	0.139 ms	- Mb
=> tvcmsfooterlogo	0.002 ms	- Mb
=> tvcmsfooterproduct	0.135 ms	- Mb
=> tvcmsnewproducts	0.130 ms	- Mb
=> tvcmsnewsletterpopup	0.674 ms	- Mb
=> tvcmspaymenticon	0.001 ms	- Mb
=> tvcmsproductcomments	1.321 ms	- Mb
=> tvcmsproductcompare	0.341 ms	- Mb
=> tvcmsproductpopup	0.347 ms	- Mb
=> tvcmssearch	0.932 ms	- Mb
=> tvcmssizechart	0.348 ms	- Mb
=> tvcmsslider	0.349 ms	- Mb
=> tvcmsspecialproducts	0.135 ms	- Mb
=> tvcmsstoretime	0.371 ms	- Mb
=> tvcmstabproducts	0.366 ms	- Mb
=> tvcmstestimonial	0.338 ms	- Mb
=> tvcmsthemeoptions	1.015 ms	- Mb
=> tvcmsvideoblock	0.335 ms	- Mb
=> tvcmswishlist	0.360 ms	- Mb
=> smartargetwhatsapp	0.838 ms	0.01 Mb
=> ps_facebook	162.211 ms	0.46 Mb
DisplayReviewProductList	48.424 ms	3.74 Mb
=> tvcmsproductcomments	1.442 ms	0.12 Mb
=> tvcmsproductcomments	0.947 ms	0.07 Mb
=> tvcmsproductcomments	0.923 ms	0.07 Mb
=> tvcmsproductcomments	0.869 ms	0.07 Mb
=> tvcmsproductcomments	1.102 ms	0.11 Mb
=> tvcmsproductcomments	0.922 ms	0.07 Mb
=> tvcmsproductcomments	0.899 ms	0.07 Mb
=> tvcmsproductcomments	0.848 ms	0.06 Mb
=> tvcmsproductcomments	1.089 ms	0.11 Mb
=> tvcmsproductcomments	0.913 ms	0.07 Mb
=> tvcmsproductcomments	0.889 ms	0.07 Mb
=> tvcmsproductcomments	0.860 ms	0.06 Mb
=> tvcmsproductcomments	1.103 ms	0.11 Mb
=> tvcmsproductcomments	0.923 ms	0.07 Mb
=> tvcmsproductcomments	0.900 ms	0.07 Mb
=> tvcmsproductcomments	0.886 ms	0.06 Mb
=> tvcmsproductcomments	1.251 ms	0.11 Mb
=> tvcmsproductcomments	1.029 ms	0.07 Mb
=> tvcmsproductcomments	1.016 ms	0.07 Mb
=> tvcmsproductcomments	0.998 ms	0.06 Mb
=> tvcmsproductcomments	1.267 ms	0.11 Mb
=> tvcmsproductcomments	1.036 ms	0.07 Mb
=> tvcmsproductcomments	1.023 ms	0.07 Mb
=> tvcmsproductcomments	0.895 ms	0.06 Mb
=> tvcmsproductcomments	1.081 ms	0.11 Mb
=> tvcmsproductcomments	0.923 ms	0.07 Mb
=> tvcmsproductcomments	0.913 ms	0.07 Mb
=> tvcmsproductcomments	0.867 ms	0.06 Mb
=> tvcmsproductcomments	1.078 ms	0.11 Mb
=> tvcmsproductcomments	0.919 ms	0.07 Mb
=> tvcmsproductcomments	0.939 ms	0.07 Mb
=> tvcmsproductcomments	0.868 ms	0.06 Mb
=> tvcmsproductcomments	1.099 ms	0.11 Mb
=> tvcmsproductcomments	0.968 ms	0.07 Mb
=> tvcmsproductcomments	0.895 ms	0.07 Mb
=> tvcmsproductcomments	0.867 ms	0.06 Mb
=> tvcmsproductcomments	1.255 ms	0.11 Mb
=> tvcmsproductcomments	1.045 ms	0.07 Mb
=> tvcmsproductcomments	1.051 ms	0.07 Mb
=> tvcmsproductcomments	1.002 ms	0.06 Mb
=> tvcmsproductcomments	1.237 ms	0.11 Mb
=> tvcmsproductcomments	1.099 ms	0.07 Mb
=> tvcmsproductcomments	1.033 ms	0.07 Mb
=> tvcmsproductcomments	0.996 ms	0.06 Mb
=> tvcmsproductcomments	1.225 ms	0.11 Mb
=> tvcmsproductcomments	1.028 ms	0.07 Mb
=> tvcmsproductcomments	1.015 ms	0.07 Mb
=> tvcmsproductcomments	0.991 ms	0.06 Mb
displayLeftColumn	31.645 ms	1.98 Mb
=> ps_categorytree (widget)	25.625 ms	1.84 Mb
=> ps_brandlist (widget)	3.029 ms	0.07 Mb
=> ps_supplierlist (widget)	2.991 ms	0.07 Mb
DisplayWishlistBtnProductList	29.136 ms	- Mb
=> tvcmswishlist	1.220 ms	0.01 Mb
=> tvcmswishlist	0.606 ms	- Mb
=> tvcmswishlist	0.581 ms	- Mb
=> tvcmswishlist	0.579 ms	- Mb
=> tvcmswishlist	0.586 ms	- Mb
=> tvcmswishlist	0.599 ms	- Mb
=> tvcmswishlist	0.596 ms	- Mb
=> tvcmswishlist	0.578 ms	- Mb
=> tvcmswishlist	0.603 ms	- Mb
=> tvcmswishlist	0.580 ms	- Mb
=> tvcmswishlist	0.583 ms	- Mb
=> tvcmswishlist	0.599 ms	- Mb
=> tvcmswishlist	0.599 ms	- Mb
=> tvcmswishlist	0.595 ms	- Mb
=> tvcmswishlist	0.611 ms	- Mb
=> tvcmswishlist	0.592 ms	- Mb
=> tvcmswishlist	0.595 ms	- Mb
=> tvcmswishlist	0.591 ms	- Mb
=> tvcmswishlist	0.577 ms	- Mb
=> tvcmswishlist	0.580 ms	- Mb
=> tvcmswishlist	0.604 ms	- Mb
=> tvcmswishlist	0.614 ms	- Mb
=> tvcmswishlist	0.600 ms	- Mb
=> tvcmswishlist	0.612 ms	- Mb
=> tvcmswishlist	0.601 ms	- Mb
=> tvcmswishlist	0.582 ms	- Mb
=> tvcmswishlist	0.600 ms	- Mb
=> tvcmswishlist	0.601 ms	- Mb
=> tvcmswishlist	0.604 ms	- Mb
=> tvcmswishlist	0.601 ms	- Mb
=> tvcmswishlist	0.598 ms	- Mb
=> tvcmswishlist	0.593 ms	- Mb
=> tvcmswishlist	0.596 ms	- Mb
=> tvcmswishlist	0.575 ms	- Mb
=> tvcmswishlist	0.595 ms	- Mb
=> tvcmswishlist	0.593 ms	- Mb
=> tvcmswishlist	0.586 ms	- Mb
=> tvcmswishlist	0.594 ms	- Mb
=> tvcmswishlist	0.602 ms	- Mb
=> tvcmswishlist	0.597 ms	- Mb
=> tvcmswishlist	0.586 ms	- Mb
=> tvcmswishlist	0.596 ms	- Mb
=> tvcmswishlist	0.581 ms	- Mb
=> tvcmswishlist	0.580 ms	- Mb
=> tvcmswishlist	0.585 ms	- Mb
=> tvcmswishlist	0.597 ms	- Mb
=> tvcmswishlist	0.600 ms	- Mb
=> tvcmswishlist	0.613 ms	- Mb
DisplayProductCompareProductList	28.023 ms	0.10 Mb
=> tvcmsproductcompare	1.402 ms	0.01 Mb
=> tvcmsproductcompare	0.574 ms	- Mb
=> tvcmsproductcompare	0.589 ms	- Mb
=> tvcmsproductcompare	0.596 ms	- Mb
=> tvcmsproductcompare	0.603 ms	- Mb
=> tvcmsproductcompare	0.562 ms	- Mb
=> tvcmsproductcompare	0.518 ms	- Mb
=> tvcmsproductcompare	0.581 ms	- Mb
=> tvcmsproductcompare	0.587 ms	- Mb
=> tvcmsproductcompare	0.581 ms	- Mb
=> tvcmsproductcompare	0.535 ms	- Mb
=> tvcmsproductcompare	0.560 ms	- Mb
=> tvcmsproductcompare	0.602 ms	- Mb
=> tvcmsproductcompare	0.561 ms	- Mb
=> tvcmsproductcompare	0.518 ms	- Mb
=> tvcmsproductcompare	0.561 ms	- Mb
=> tvcmsproductcompare	0.557 ms	- Mb
=> tvcmsproductcompare	0.563 ms	- Mb
=> tvcmsproductcompare	0.542 ms	- Mb
=> tvcmsproductcompare	0.575 ms	- Mb
=> tvcmsproductcompare	0.583 ms	- Mb
=> tvcmsproductcompare	0.580 ms	- Mb
=> tvcmsproductcompare	0.518 ms	- Mb
=> tvcmsproductcompare	0.651 ms	- Mb
=> tvcmsproductcompare	0.599 ms	- Mb
=> tvcmsproductcompare	0.582 ms	- Mb
=> tvcmsproductcompare	0.526 ms	- Mb
=> tvcmsproductcompare	0.562 ms	- Mb
=> tvcmsproductcompare	0.597 ms	- Mb
=> tvcmsproductcompare	0.563 ms	- Mb
=> tvcmsproductcompare	0.516 ms	- Mb
=> tvcmsproductcompare	0.579 ms	- Mb
=> tvcmsproductcompare	0.561 ms	- Mb
=> tvcmsproductcompare	0.577 ms	- Mb
=> tvcmsproductcompare	0.509 ms	- Mb
=> tvcmsproductcompare	0.583 ms	- Mb
=> tvcmsproductcompare	0.601 ms	- Mb
=> tvcmsproductcompare	0.562 ms	- Mb
=> tvcmsproductcompare	0.518 ms	- Mb
=> tvcmsproductcompare	0.561 ms	- Mb
=> tvcmsproductcompare	0.602 ms	- Mb
=> tvcmsproductcompare	0.563 ms	- Mb
=> tvcmsproductcompare	0.533 ms	- Mb
=> tvcmsproductcompare	0.576 ms	- Mb
=> tvcmsproductcompare	0.613 ms	- Mb
=> tvcmsproductcompare	0.565 ms	- Mb
=> tvcmsproductcompare	0.515 ms	- Mb
=> tvcmsproductcompare	0.561 ms	- Mb
DisplayProductListStockIndicator	12.554 ms	0.89 Mb
=> tvcmsstockinfo	0.846 ms	0.03 Mb
=> tvcmsstockinfo	0.294 ms	0.01 Mb
=> tvcmsstockinfo	0.537 ms	0.05 Mb
=> tvcmsstockinfo	0.503 ms	0.05 Mb
=> tvcmsstockinfo	0.565 ms	0.05 Mb
=> tvcmsstockinfo	0.543 ms	0.05 Mb
=> tvcmsstockinfo	0.612 ms	0.05 Mb
=> tvcmsstockinfo	0.542 ms	0.05 Mb
=> tvcmsstockinfo	0.288 ms	0.01 Mb
=> tvcmsstockinfo	0.283 ms	0.01 Mb
=> tvcmsstockinfo	0.608 ms	0.05 Mb
=> tvcmsstockinfo	0.528 ms	0.05 Mb
=> tvcmsstockinfo	0.540 ms	0.05 Mb
=> tvcmsstockinfo	0.558 ms	0.05 Mb
=> tvcmsstockinfo	0.519 ms	0.05 Mb
=> tvcmsstockinfo	0.502 ms	0.05 Mb
=> tvcmsstockinfo	0.311 ms	0.01 Mb
=> tvcmsstockinfo	0.280 ms	0.01 Mb
=> tvcmsstockinfo	0.615 ms	0.05 Mb
=> tvcmsstockinfo	0.600 ms	0.05 Mb
=> tvcmsstockinfo	0.637 ms	0.05 Mb
=> tvcmsstockinfo	0.632 ms	0.05 Mb
=> tvcmsstockinfo	0.620 ms	0.05 Mb
=> tvcmsstockinfo	0.591 ms	0.05 Mb
DisplayMegamenu	9.648 ms	0.68 Mb
=> tvcmsmegamenu	9.648 ms	0.68 Mb
DisplayNavSearchBlock	6.709 ms	1.48 Mb
=> tvcmssearch	6.709 ms	1.48 Mb
Header	4.100 ms	0.11 Mb
=> tvcmsstockinfo	0.455 ms	- Mb
=> tvcmsinfinitescroll	2.449 ms	0.05 Mb
=> tvcmscategoryproduct	0.412 ms	0.02 Mb
=> tvcmsmegamenu	0.383 ms	0.02 Mb
=> tvcmstwoofferbanner	0.401 ms	0.02 Mb
DisplayFooter	4.059 ms	0.14 Mb
=> blockwishlist	3.179 ms	0.13 Mb
=> ps_facebook	0.880 ms	0.01 Mb
DisplayCustomsocialblock	3.664 ms	0.16 Mb
=> tvcmscustomsetting	3.664 ms	0.16 Mb
ActionFrontControllerSetMedia	2.401 ms	0.01 Mb
=> blockreassurance	0.648 ms	- Mb
=> blockwishlist	0.577 ms	- Mb
=> ps_emailsubscription	0.133 ms	- Mb
=> ps_socialfollow	0.227 ms	- Mb
=> psxdesign	0.524 ms	- Mb
=> klaviyopsautomation	0.006 ms	- Mb
=> ps_emailalerts	0.113 ms	- Mb
=> monei	0.005 ms	- Mb
=> ps_facebook	0.168 ms	- Mb
displayFooterPart1	2.076 ms	0.09 Mb
=> ps_linklist (widget)	2.076 ms	0.09 Mb
displaySocialMediaBlock	1.958 ms	0.09 Mb
=> ps_socialfollow (widget)	1.958 ms	0.09 Mb
displayMyaccountcblock	1.893 ms	0.09 Mb
=> ps_customeraccountlinks (widget)	1.893 ms	0.09 Mb
displayNewslettersubscription	1.849 ms	0.09 Mb
=> ps_emailsubscription (widget)	1.849 ms	0.09 Mb
ProductSearchProvider	1.663 ms	0.03 Mb
=> ps_facetedsearch	1.663 ms	0.03 Mb
DisplayPaymentIcon	1.563 ms	0.04 Mb
=> tvcmspaymenticon	1.563 ms	0.04 Mb
DisplayBeforeBodyClosingTag	1.447 ms	0.05 Mb
=> statsdata	1.443 ms	0.05 Mb
=> tvcmsblog	0.004 ms	- Mb
DisplayNavWishlistBlock	1.310 ms	0.04 Mb
=> tvcmswishlist	1.310 ms	0.04 Mb
displayNavShoppingCartBlock	1.309 ms	0.09 Mb
=> ps_shoppingcart (widget)	1.309 ms	0.09 Mb
displayNav1	1.208 ms	0.09 Mb
=> ps_contactinfo (widget)	1.208 ms	0.09 Mb
DisplayNavWishlistBlocksticky	1.183 ms	0.05 Mb
=> tvcmswishlist	1.183 ms	0.05 Mb
displayNavCustomerSignInBlock	0.961 ms	0.05 Mb
=> ps_customersignin (widget)	0.961 ms	0.05 Mb
DisplayNavProductCompareBlock	0.921 ms	0.01 Mb
=> tvcmsproductcompare	0.921 ms	0.01 Mb
displayContactCinfo	0.912 ms	0.03 Mb
=> ps_contactinfo (widget)	0.912 ms	0.03 Mb
DisplayDownloadApps	0.899 ms	0.02 Mb
=> tvcmscustomsetting	0.899 ms	0.02 Mb
DisplayProductComparesticky	0.885 ms	0.01 Mb
=> tvcmsproductcompare	0.885 ms	0.01 Mb
DisplayCopyRightText	0.818 ms	0.01 Mb
=> tvcmscustomsetting	0.818 ms	0.01 Mb
DisplayAfterTitleTag	0.813 ms	0.01 Mb
=> psxdesign	0.813 ms	0.01 Mb
ActionDispatcherBefore	0.742 ms	0.01 Mb
=> psxdesign	0.247 ms	- Mb
=> ps_mbo	0.495 ms	0.01 Mb
DisplayFacetedSearchBlock	0.630 ms	0.09 Mb
=> ps_facetedsearch	0.630 ms	0.09 Mb
displayNavLanguageBlock	0.394 ms	0.05 Mb
=> ps_languageselector (widget)	0.394 ms	0.05 Mb
displayNavCurrencyBlock	0.359 ms	0.05 Mb
=> ps_currencyselector (widget)	0.359 ms	0.05 Mb
ModuleRoutes	0.026 ms	0.01 Mb
=> klaviyopsautomation	0.006 ms	- Mb
=> tvcmsblog	0.018 ms	0.01 Mb
=> simpleimportproduct	0.002 ms	- Mb
DisplayTopOfferText	0.018 ms	- Mb
=> tvcmscustomsetting	0.014 ms	- Mb
=> tvcmscustomsetting	0.004 ms	- Mb
DisplayCustomCss	0.006 ms	- Mb
=> tvcmscustomcssjs	0.006 ms	- Mb
DisplayCustomJs	0.005 ms	- Mb
=> tvcmscustomcssjs	0.005 ms	- Mb
ActionFrontControllerInitAfter	0.004 ms	- Mb
=> klaviyopsautomation	0.004 ms	- Mb
DisplayNavFullWidth	0.004 ms	- Mb
=> blockreassurance	0.004 ms	- Mb
42 hook(s)	1348 ms	19.31 Mb

Module	Time	Memory Usage
klaviyopsautomation	1.791 ms	- Mb
__construct	1.767 ms	- Mb
hookModuleRoutes	0.010 ms	- Mb
hookActionFrontControllerInitAfter	0.007 ms	- Mb
hookActionFrontControllerSetMedia	0.007 ms	- Mb
tvcmsblog	6.193 ms	0.13 Mb
__construct	5.464 ms	0.12 Mb
hookModuleRoutes	0.021 ms	0.01 Mb
hookDisplayHeader	0.703 ms	- Mb
hookDisplayBeforeBodyClosingTag	0.005 ms	- Mb
simpleimportproduct	1.040 ms	0.03 Mb
__construct	1.037 ms	0.02 Mb
hookModuleRoutes	0.003 ms	- Mb
psxdesign	4.802 ms	0.03 Mb
__construct	3.212 ms	0.01 Mb
hookActionDispatcherBefore	0.249 ms	- Mb
hookActionFrontControllerSetMedia	0.525 ms	- Mb
hookDisplayAfterTitleTag	0.816 ms	0.01 Mb
ps_mbo	9.577 ms	0.05 Mb
__construct	9.078 ms	0.04 Mb
hookActionDispatcherBefore	0.499 ms	0.01 Mb
blockreassurance	1.330 ms	0.09 Mb
__construct	0.668 ms	0.08 Mb
hookActionFrontControllerSetMedia	0.651 ms	0.01 Mb
hookDisplayAfterBodyOpeningTag	0.005 ms	- Mb
hookDisplayNavFullWidth	0.006 ms	- Mb
blockwishlist	3.909 ms	0.14 Mb
__construct	0.150 ms	0.01 Mb
hookActionFrontControllerSetMedia	0.578 ms	- Mb
hookDisplayFooter	3.181 ms	0.13 Mb
ps_emailsubscription	2.095 ms	0.10 Mb
__construct	0.111 ms	0.01 Mb
hookActionFrontControllerSetMedia	0.134 ms	- Mb
displayNewslettersubscription	1.850 ms	0.09 Mb
ps_socialfollow	2.286 ms	0.10 Mb
__construct	0.098 ms	0.01 Mb
hookActionFrontControllerSetMedia	0.228 ms	- Mb
displaySocialMediaBlock	1.960 ms	0.09 Mb
ps_emailalerts	0.308 ms	0.01 Mb
__construct	0.194 ms	0.01 Mb
hookActionFrontControllerSetMedia	0.114 ms	- Mb
monei	0.804 ms	0.07 Mb
__construct	0.798 ms	0.06 Mb
hookActionFrontControllerSetMedia	0.006 ms	- Mb
ps_facebook	165.609 ms	0.46 Mb
__construct	2.343 ms	- Mb
hookActionFrontControllerSetMedia	0.170 ms	- Mb
hookDisplayHeader	162.215 ms	0.46 Mb
hookDisplayFooter	0.881 ms	0.01 Mb
ps_shoppingcart	1.504 ms	0.10 Mb
__construct	0.113 ms	0.01 Mb
hookDisplayHeader	0.080 ms	- Mb
displayNavShoppingCartBlock	1.311 ms	0.09 Mb
ps_searchbar	1.065 ms	0.07 Mb
__construct	0.162 ms	0.07 Mb
hookDisplayHeader	0.903 ms	- Mb
ps_imageslider	0.600 ms	0.01 Mb
__construct	0.168 ms	0.01 Mb
hookDisplayHeader	0.432 ms	- Mb
productcomments	0.552 ms	0.01 Mb
__construct	0.103 ms	0.01 Mb
hookDisplayHeader	0.449 ms	- Mb
psxmarketingwithgoogle	3.979 ms	0.01 Mb
__construct	0.408 ms	0.01 Mb
hookDisplayHeader	3.571 ms	0.01 Mb
ps_googleanalytics	1.856 ms	0.03 Mb
__construct	0.169 ms	0.01 Mb
hookDisplayHeader	1.687 ms	0.02 Mb
tvcmsbestsellerproducts	34.665 ms	1.68 Mb
__construct	0.474 ms	0.01 Mb
hookDisplayHeader	0.152 ms	- Mb
hookDisplayLeftColumn	34.039 ms	1.67 Mb
tvcmsblogdisplayposts	0.874 ms	0.01 Mb
__construct	0.419 ms	0.01 Mb
hookDisplayHeader	0.455 ms	- Mb
tvcmsbrandlist	0.726 ms	0.01 Mb
__construct	0.389 ms	0.01 Mb
hookDisplayHeader	0.337 ms	- Mb
tvcmscategorychainslider	0.748 ms	0.01 Mb
__construct	0.410 ms	0.01 Mb
hookDisplayHeader	0.338 ms	- Mb
tvcmscategoryslider	0.734 ms	0.01 Mb
__construct	0.395 ms	0.01 Mb
hookDisplayHeader	0.339 ms	- Mb
tvcmscookiesnotice	1.623 ms	0.03 Mb
__construct	0.381 ms	0.01 Mb
hookDisplayHeader	0.354 ms	- Mb
hookDisplayAfterBodyOpeningTag	0.888 ms	0.02 Mb
tvcmscustomerservices	2.093 ms	0.09 Mb
__construct	0.380 ms	0.01 Mb
hookDisplayHeader	0.342 ms	- Mb
hookDisplayLeftColumn	1.371 ms	0.08 Mb
tvcmscustomsetting	8.020 ms	0.22 Mb
__construct	0.486 ms	0.01 Mb
hookDisplayHeader	2.124 ms	0.01 Mb
hookDisplayTopOfferText	0.017 ms	- Mb
hookDisplayTopOfferText	0.006 ms	- Mb
hookDisplayDownloadApps	0.902 ms	0.02 Mb
hookDisplayCustomsocialblock	3.665 ms	0.16 Mb
hookDisplayCopyRightText	0.820 ms	0.01 Mb
tvcmsfeaturedproducts	68.446 ms	2.93 Mb
__construct	0.361 ms	0.01 Mb
hookDisplayHeader	0.140 ms	- Mb
hookDisplayLeftColumn	67.945 ms	2.92 Mb
tvcmsfooterlogo	0.390 ms	0.01 Mb
__construct	0.387 ms	0.01 Mb
hookDisplayHeader	0.003 ms	- Mb
tvcmsfooterproduct	0.514 ms	0.01 Mb
__construct	0.378 ms	0.01 Mb
hookDisplayHeader	0.136 ms	- Mb
tvcmsnewproducts	477.540 ms	0.89 Mb
__construct	0.342 ms	0.01 Mb
hookDisplayHeader	0.131 ms	- Mb
hookDisplayLeftColumn	477.067 ms	0.89 Mb
tvcmsnewsletterpopup	1.067 ms	0.01 Mb
__construct	0.392 ms	0.01 Mb
hookDisplayHeader	0.675 ms	- Mb
tvcmspaymenticon	1.963 ms	0.05 Mb
__construct	0.396 ms	0.01 Mb
hookDisplayHeader	0.002 ms	- Mb
hookDisplayPaymentIcon	1.565 ms	0.04 Mb
tvcmsproductcomments	50.194 ms	3.77 Mb
__construct	0.360 ms	0.01 Mb
hookDisplayHeader	1.323 ms	- Mb
hookDisplayReviewProductList	1.444 ms	0.12 Mb
hookDisplayReviewProductList	0.949 ms	0.07 Mb
hookDisplayReviewProductList	0.925 ms	0.07 Mb
hookDisplayReviewProductList	0.871 ms	0.07 Mb
hookDisplayReviewProductList	1.104 ms	0.11 Mb
hookDisplayReviewProductList	0.923 ms	0.07 Mb
hookDisplayReviewProductList	0.901 ms	0.07 Mb
hookDisplayReviewProductList	0.850 ms	0.06 Mb
hookDisplayReviewProductList	1.091 ms	0.11 Mb
hookDisplayReviewProductList	0.915 ms	0.07 Mb
hookDisplayReviewProductList	0.891 ms	0.07 Mb
hookDisplayReviewProductList	0.862 ms	0.06 Mb
hookDisplayReviewProductList	1.105 ms	0.11 Mb
hookDisplayReviewProductList	0.925 ms	0.07 Mb
hookDisplayReviewProductList	0.901 ms	0.07 Mb
hookDisplayReviewProductList	0.888 ms	0.06 Mb
hookDisplayReviewProductList	1.253 ms	0.11 Mb
hookDisplayReviewProductList	1.031 ms	0.07 Mb
hookDisplayReviewProductList	1.018 ms	0.07 Mb
hookDisplayReviewProductList	1.000 ms	0.06 Mb
hookDisplayReviewProductList	1.269 ms	0.11 Mb
hookDisplayReviewProductList	1.038 ms	0.07 Mb
hookDisplayReviewProductList	1.024 ms	0.07 Mb
hookDisplayReviewProductList	0.897 ms	0.06 Mb
hookDisplayReviewProductList	1.083 ms	0.11 Mb
hookDisplayReviewProductList	0.925 ms	0.07 Mb
hookDisplayReviewProductList	0.915 ms	0.07 Mb
hookDisplayReviewProductList	0.869 ms	0.06 Mb
hookDisplayReviewProductList	1.080 ms	0.11 Mb
hookDisplayReviewProductList	0.921 ms	0.07 Mb
hookDisplayReviewProductList	0.941 ms	0.07 Mb
hookDisplayReviewProductList	0.870 ms	0.06 Mb
hookDisplayReviewProductList	1.101 ms	0.11 Mb
hookDisplayReviewProductList	0.970 ms	0.07 Mb
hookDisplayReviewProductList	0.896 ms	0.07 Mb
hookDisplayReviewProductList	0.869 ms	0.06 Mb
hookDisplayReviewProductList	1.257 ms	0.11 Mb
hookDisplayReviewProductList	1.046 ms	0.07 Mb
hookDisplayReviewProductList	1.053 ms	0.07 Mb
hookDisplayReviewProductList	1.003 ms	0.06 Mb
hookDisplayReviewProductList	1.238 ms	0.11 Mb
hookDisplayReviewProductList	1.100 ms	0.07 Mb
hookDisplayReviewProductList	1.035 ms	0.07 Mb
hookDisplayReviewProductList	0.998 ms	0.06 Mb
hookDisplayReviewProductList	1.226 ms	0.11 Mb
hookDisplayReviewProductList	1.030 ms	0.07 Mb
hookDisplayReviewProductList	1.017 ms	0.07 Mb
hookDisplayReviewProductList	0.993 ms	0.06 Mb
tvcmsproductcompare	30.594 ms	0.14 Mb
__construct	0.324 ms	0.01 Mb
hookDisplayHeader	0.342 ms	- Mb
hookDisplayNavProductCompareBlock	0.924 ms	0.01 Mb
hookDisplayProductCompareProductList	1.408 ms	0.01 Mb
hookDisplayProductCompareProductList	0.576 ms	- Mb
hookDisplayProductCompareProductList	0.590 ms	- Mb
hookDisplayProductCompareProductList	0.597 ms	- Mb
hookDisplayProductCompareProductList	0.605 ms	- Mb
hookDisplayProductCompareProductList	0.563 ms	- Mb
hookDisplayProductCompareProductList	0.520 ms	- Mb
hookDisplayProductCompareProductList	0.583 ms	- Mb
hookDisplayProductCompareProductList	0.589 ms	- Mb
hookDisplayProductCompareProductList	0.583 ms	- Mb
hookDisplayProductCompareProductList	0.537 ms	- Mb
hookDisplayProductCompareProductList	0.562 ms	- Mb
hookDisplayProductCompareProductList	0.604 ms	- Mb
hookDisplayProductCompareProductList	0.563 ms	- Mb
hookDisplayProductCompareProductList	0.520 ms	- Mb
hookDisplayProductCompareProductList	0.563 ms	- Mb
hookDisplayProductCompareProductList	0.559 ms	- Mb
hookDisplayProductCompareProductList	0.565 ms	- Mb
hookDisplayProductCompareProductList	0.543 ms	- Mb
hookDisplayProductCompareProductList	0.577 ms	- Mb
hookDisplayProductCompareProductList	0.585 ms	- Mb
hookDisplayProductCompareProductList	0.582 ms	- Mb
hookDisplayProductCompareProductList	0.520 ms	- Mb
hookDisplayProductCompareProductList	0.653 ms	- Mb
hookDisplayProductCompareProductList	0.601 ms	- Mb
hookDisplayProductCompareProductList	0.584 ms	- Mb
hookDisplayProductCompareProductList	0.528 ms	- Mb
hookDisplayProductCompareProductList	0.564 ms	- Mb
hookDisplayProductCompareProductList	0.599 ms	- Mb
hookDisplayProductCompareProductList	0.565 ms	- Mb
hookDisplayProductCompareProductList	0.518 ms	- Mb
hookDisplayProductCompareProductList	0.581 ms	- Mb
hookDisplayProductCompareProductList	0.563 ms	- Mb
hookDisplayProductCompareProductList	0.579 ms	- Mb
hookDisplayProductCompareProductList	0.511 ms	- Mb
hookDisplayProductCompareProductList	0.585 ms	- Mb
hookDisplayProductCompareProductList	0.603 ms	- Mb
hookDisplayProductCompareProductList	0.563 ms	- Mb
hookDisplayProductCompareProductList	0.520 ms	- Mb
hookDisplayProductCompareProductList	0.563 ms	- Mb
hookDisplayProductCompareProductList	0.604 ms	- Mb
hookDisplayProductCompareProductList	0.565 ms	- Mb
hookDisplayProductCompareProductList	0.535 ms	- Mb
hookDisplayProductCompareProductList	0.578 ms	- Mb
hookDisplayProductCompareProductList	0.615 ms	- Mb
hookDisplayProductCompareProductList	0.567 ms	- Mb
hookDisplayProductCompareProductList	0.517 ms	- Mb
hookDisplayProductCompareProductList	0.562 ms	- Mb
hookDisplayProductComparesticky	0.887 ms	0.01 Mb
tvcmsproductpopup	375.875 ms	2.74 Mb
__construct	0.097 ms	0.01 Mb
hookDisplayHeader	0.348 ms	- Mb
hookDisplayAfterBodyOpeningTag	375.430 ms	2.73 Mb
tvcmssearch	7.950 ms	1.49 Mb
__construct	0.304 ms	0.01 Mb
hookDisplayHeader	0.934 ms	- Mb
hookDisplayNavSearchBlock	6.712 ms	1.48 Mb
tvcmssizechart	0.699 ms	0.01 Mb
__construct	0.349 ms	0.01 Mb
hookDisplayHeader	0.350 ms	- Mb
tvcmsslider	0.742 ms	0.01 Mb
__construct	0.392 ms	0.01 Mb
hookDisplayHeader	0.350 ms	- Mb
tvcmsspecialproducts	3.107 ms	0.11 Mb
__construct	0.346 ms	0.01 Mb
hookDisplayHeader	0.137 ms	- Mb
hookDisplayLeftColumn	2.624 ms	0.10 Mb
tvcmsstockinfo	13.362 ms	0.91 Mb
__construct	0.312 ms	0.01 Mb
hookHeader	0.456 ms	- Mb
hookDisplayProductListStockIndicator	0.848 ms	0.03 Mb
hookDisplayProductListStockIndicator	0.295 ms	0.01 Mb
hookDisplayProductListStockIndicator	0.539 ms	0.05 Mb
hookDisplayProductListStockIndicator	0.505 ms	0.05 Mb
hookDisplayProductListStockIndicator	0.566 ms	0.05 Mb
hookDisplayProductListStockIndicator	0.544 ms	0.05 Mb
hookDisplayProductListStockIndicator	0.614 ms	0.05 Mb
hookDisplayProductListStockIndicator	0.544 ms	0.05 Mb
hookDisplayProductListStockIndicator	0.290 ms	0.01 Mb
hookDisplayProductListStockIndicator	0.284 ms	0.01 Mb
hookDisplayProductListStockIndicator	0.610 ms	0.05 Mb
hookDisplayProductListStockIndicator	0.530 ms	0.05 Mb
hookDisplayProductListStockIndicator	0.542 ms	0.05 Mb
hookDisplayProductListStockIndicator	0.560 ms	0.05 Mb
hookDisplayProductListStockIndicator	0.521 ms	0.05 Mb
hookDisplayProductListStockIndicator	0.504 ms	0.05 Mb
hookDisplayProductListStockIndicator	0.313 ms	0.01 Mb
hookDisplayProductListStockIndicator	0.281 ms	0.01 Mb
hookDisplayProductListStockIndicator	0.616 ms	0.05 Mb
hookDisplayProductListStockIndicator	0.602 ms	0.05 Mb
hookDisplayProductListStockIndicator	0.638 ms	0.05 Mb
hookDisplayProductListStockIndicator	0.634 ms	0.05 Mb
hookDisplayProductListStockIndicator	0.622 ms	0.05 Mb
hookDisplayProductListStockIndicator	0.592 ms	0.05 Mb
tvcmsstoretime	0.720 ms	0.01 Mb
__construct	0.348 ms	- Mb
hookDisplayHeader	0.372 ms	- Mb
tvcmstabproducts	0.679 ms	0.01 Mb
__construct	0.312 ms	0.01 Mb
hookDisplayHeader	0.367 ms	- Mb
tvcmstestimonial	0.741 ms	0.01 Mb
__construct	0.401 ms	0.01 Mb
hookDisplayHeader	0.340 ms	- Mb
tvcmsthemeoptions	1.381 ms	0.01 Mb
__construct	0.364 ms	0.01 Mb
hookDisplayHeader	1.017 ms	- Mb
tvcmsvideoblock	0.721 ms	0.01 Mb
__construct	0.384 ms	0.01 Mb
hookDisplayHeader	0.337 ms	- Mb
tvcmswishlist	32.426 ms	0.10 Mb
__construct	0.349 ms	0.01 Mb
hookDisplayHeader	0.361 ms	- Mb
hookDisplayNavWishlistBlock	1.312 ms	0.04 Mb
hookDisplayWishlistBtnProductList	1.222 ms	0.01 Mb
hookDisplayWishlistBtnProductList	0.608 ms	- Mb
hookDisplayWishlistBtnProductList	0.583 ms	- Mb
hookDisplayWishlistBtnProductList	0.581 ms	- Mb
hookDisplayWishlistBtnProductList	0.588 ms	- Mb
hookDisplayWishlistBtnProductList	0.601 ms	- Mb
hookDisplayWishlistBtnProductList	0.598 ms	- Mb
hookDisplayWishlistBtnProductList	0.580 ms	- Mb
hookDisplayWishlistBtnProductList	0.605 ms	- Mb
hookDisplayWishlistBtnProductList	0.582 ms	- Mb
hookDisplayWishlistBtnProductList	0.584 ms	- Mb
hookDisplayWishlistBtnProductList	0.600 ms	- Mb
hookDisplayWishlistBtnProductList	0.601 ms	- Mb
hookDisplayWishlistBtnProductList	0.597 ms	- Mb
hookDisplayWishlistBtnProductList	0.613 ms	- Mb
hookDisplayWishlistBtnProductList	0.594 ms	- Mb
hookDisplayWishlistBtnProductList	0.596 ms	- Mb
hookDisplayWishlistBtnProductList	0.592 ms	- Mb
hookDisplayWishlistBtnProductList	0.578 ms	- Mb
hookDisplayWishlistBtnProductList	0.582 ms	- Mb
hookDisplayWishlistBtnProductList	0.606 ms	- Mb
hookDisplayWishlistBtnProductList	0.616 ms	- Mb
hookDisplayWishlistBtnProductList	0.601 ms	- Mb
hookDisplayWishlistBtnProductList	0.614 ms	- Mb
hookDisplayWishlistBtnProductList	0.603 ms	- Mb
hookDisplayWishlistBtnProductList	0.584 ms	- Mb
hookDisplayWishlistBtnProductList	0.602 ms	- Mb
hookDisplayWishlistBtnProductList	0.603 ms	- Mb
hookDisplayWishlistBtnProductList	0.605 ms	- Mb
hookDisplayWishlistBtnProductList	0.602 ms	- Mb
hookDisplayWishlistBtnProductList	0.599 ms	- Mb
hookDisplayWishlistBtnProductList	0.595 ms	- Mb
hookDisplayWishlistBtnProductList	0.598 ms	- Mb
hookDisplayWishlistBtnProductList	0.577 ms	- Mb
hookDisplayWishlistBtnProductList	0.596 ms	- Mb
hookDisplayWishlistBtnProductList	0.595 ms	- Mb
hookDisplayWishlistBtnProductList	0.588 ms	- Mb
hookDisplayWishlistBtnProductList	0.596 ms	- Mb
hookDisplayWishlistBtnProductList	0.604 ms	- Mb
hookDisplayWishlistBtnProductList	0.599 ms	- Mb
hookDisplayWishlistBtnProductList	0.588 ms	- Mb
hookDisplayWishlistBtnProductList	0.597 ms	- Mb
hookDisplayWishlistBtnProductList	0.583 ms	- Mb
hookDisplayWishlistBtnProductList	0.582 ms	- Mb
hookDisplayWishlistBtnProductList	0.587 ms	- Mb
hookDisplayWishlistBtnProductList	0.599 ms	- Mb
hookDisplayWishlistBtnProductList	0.601 ms	- Mb
hookDisplayWishlistBtnProductList	0.615 ms	- Mb
hookDisplayNavWishlistBlocksticky	1.185 ms	0.05 Mb
smartargetwhatsapp	1.199 ms	0.01 Mb
__construct	0.359 ms	0.01 Mb
hookDisplayHeader	0.840 ms	0.01 Mb
ps_accounts	0.665 ms	- Mb
__construct	0.665 ms	- Mb
tvcmsinfinitescroll	2.837 ms	0.06 Mb
__construct	0.386 ms	0.01 Mb
hookHeader	2.451 ms	0.05 Mb
tvcmscategoryproduct	0.831 ms	0.03 Mb
__construct	0.417 ms	0.01 Mb
hookHeader	0.414 ms	0.02 Mb
tvcmsmegamenu	10.472 ms	0.71 Mb
__construct	0.435 ms	0.01 Mb
hookHeader	0.385 ms	0.02 Mb
hookDisplayMegamenu	9.652 ms	0.68 Mb
tvcmstwoofferbanner	0.762 ms	0.02 Mb
__construct	0.359 ms	- Mb
hookHeader	0.403 ms	0.02 Mb
ps_facetedsearch	3.877 ms	0.13 Mb
__construct	1.580 ms	0.01 Mb
hookProductSearchProvider	1.665 ms	0.03 Mb
hookDisplayFacetedSearchBlock	0.632 ms	0.09 Mb
tvcmscustomcssjs	0.418 ms	0.01 Mb
__construct	0.404 ms	0.01 Mb
hookDisplayCustomCss	0.007 ms	- Mb
hookDisplayCustomJs	0.007 ms	- Mb
ps_customersignin	1.088 ms	0.06 Mb
__construct	0.124 ms	0.01 Mb
displayNavCustomerSignInBlock	0.964 ms	0.05 Mb
ps_languageselector	0.508 ms	0.06 Mb
__construct	0.112 ms	0.01 Mb
displayNavLanguageBlock	0.396 ms	0.05 Mb
ps_currencyselector	0.470 ms	0.06 Mb
__construct	0.109 ms	0.01 Mb
displayNavCurrencyBlock	0.361 ms	0.05 Mb
ps_contactinfo	2.232 ms	0.12 Mb
__construct	0.108 ms	0.01 Mb
displayNav1	1.210 ms	0.09 Mb
displayContactCinfo	0.914 ms	0.03 Mb
ps_categorytree	25.739 ms	1.84 Mb
__construct	0.111 ms	0.01 Mb
displayLeftColumn	25.628 ms	1.84 Mb
ps_brandlist	3.215 ms	0.08 Mb
__construct	0.182 ms	0.01 Mb
displayLeftColumn	3.033 ms	0.07 Mb
ps_supplierlist	3.166 ms	0.08 Mb
__construct	0.173 ms	0.01 Mb
displayLeftColumn	2.993 ms	0.07 Mb
ps_linklist	2.701 ms	0.09 Mb
__construct	0.623 ms	0.01 Mb
displayFooterPart1	2.078 ms	0.09 Mb
ps_customeraccountlinks	2.013 ms	0.09 Mb
__construct	0.118 ms	0.01 Mb
displayMyaccountcblock	1.895 ms	0.09 Mb
statsdata	1.561 ms	0.06 Mb
__construct	0.116 ms	0.01 Mb
hookDisplayBeforeBodyClosingTag	1.445 ms	0.05 Mb
64 module(s)	1392 ms	20.18 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 (731, 623, 732, 22, 39, 41, 656) 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)))	1557 ms	2070589952			/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	669.929 ms	93312			/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)
786	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	433.819 ms	375300864	Yes		/classes/Product.php:3110 /modules/tvcmstabproducts/tvcmstabproducts.php:2809 (getNewProducts) /modules/tvcmsnewproducts/tvcmsnewproducts.php:157 (displayNewProducts) /modules/tvcmsnewproducts/tvcmsnewproducts.php:266 (showFrontSideResult) /classes/Hook.php:1083 (hookdisplayLeftColumn) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:421 (coreCallHook) /classes/Hook.php:989 (callHookOn) /config/smarty.config.inc.php:201 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/dev/smarty/compile/v1_giftoo_168layouts_layout_left_column_tpl/69/81/ba/6981ba7f75ae91c680b199f8c9b8d3dbd8d96719_2.file.layout-both-columns.tpl.php:192 (__call) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/v1_giftoo_168layouts_layout_left_column_tpl/69/81/ba/6981ba7f75ae91c680b199f8c9b8d3dbd8d96719_2.file.layout-both-columns.tpl.php:74 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_688bca89963334_98279087) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/v1_giftoo_168layouts_layout_left_column_tpl/8d/0f/a6/8d0fa6a125af07e8554a5461801ff205a85e918e_2.file.layout-left-column.tpl.php:28 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_688bca89918cb8_31976545) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/v1_giftoo_168layouts_layout_left_column_tpl/33/cf/b7/33cfb772f37fe9bf7e7da2f4ede7b9ba2ebdb1ff_2.file.product-list.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_688bca898f8023_38089402) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/v1_giftoo_168layouts_layout_left_column_tpl/a5/95/48/a595487cdf0e93c51d790aa7d81fde9f6d267539_2.file.category.tpl.php:29 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_688bca898bc698_82360211) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/Smarty/SmartyCustom.php:112 (fetch) /classes/controller/FrontController.php:771 (fetch) /classes/controller/FrontController.php:753 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
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 (731, 623, 732, 22, 39, 41, 656) 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))	324.022 ms	2070589952			/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 (731, 623, 732, 22, 39, 41, 656) 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))	323.027 ms	2070589952			/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)
658	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	313.959 ms	375300864	Yes		/classes/Product.php:3110 /modules/tvcmsproductpopup/tvcmsproductpopup.php:367 (getNewProducts) /modules/tvcmsproductpopup/tvcmsproductpopup.php:252 (getNewProducts) /modules/tvcmsproductpopup/tvcmsproductpopup.php:546 (prevHook) /classes/Hook.php:1083 (hookdisplayAfterBodyOpeningTag) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:421 (coreCallHook) /classes/Hook.php:989 (callHookOn) /config/smarty.config.inc.php:201 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/dev/smarty/compile/v1_giftoo_168layouts_layout_left_column_tpl/69/81/ba/6981ba7f75ae91c680b199f8c9b8d3dbd8d96719_2.file.layout-both-columns.tpl.php:116 (__call) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/v1_giftoo_168layouts_layout_left_column_tpl/69/81/ba/6981ba7f75ae91c680b199f8c9b8d3dbd8d96719_2.file.layout-both-columns.tpl.php:54 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_688bca89963334_98279087) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/v1_giftoo_168layouts_layout_left_column_tpl/8d/0f/a6/8d0fa6a125af07e8554a5461801ff205a85e918e_2.file.layout-left-column.tpl.php:28 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_688bca89918cb8_31976545) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/v1_giftoo_168layouts_layout_left_column_tpl/33/cf/b7/33cfb772f37fe9bf7e7da2f4ede7b9ba2ebdb1ff_2.file.product-list.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_688bca898f8023_38089402) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/v1_giftoo_168layouts_layout_left_column_tpl/a5/95/48/a595487cdf0e93c51d790aa7d81fde9f6d267539_2.file.category.tpl.php:29 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_688bca898bc698_82360211) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/Smarty/SmartyCustom.php:112 (fetch) /classes/controller/FrontController.php:771 (fetch) /classes/controller/FrontController.php:753 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
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 (731, 623, 732, 22, 39, 41, 656) GROUP BY p.id_product) p WHERE ((p.on_sale=1))	67.980 ms	1035294976			/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)
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 (731, 623, 732, 22, 39, 41, 656) GROUP BY p.id_product) p WHERE p.date_add>'2022-11-05 00:00:00'	66.400 ms	1035294976			/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)
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 (731, 623, 732, 22, 39, 41, 656) 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	56.937 ms	1035294976	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)
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 (731, 623, 732, 22, 39, 41, 656)	52.292 ms	16088			/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)
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 (731, 623, 732, 22, 39, 41, 656) GROUP BY p.id_product) p GROUP BY p.condition	51.694 ms	1035294976	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:778 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:394 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:137 (getConditionsBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
375	SELECT SQL_NO_CACHE p.id_manufacturer, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM ps_product p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN ps_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND cp.id_category IN (731, 623, 732, 22, 39, 41, 656) GROUP BY p.id_product) p GROUP BY p.id_manufacturer	50.638 ms	1035294976	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)
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 (731, 623, 732, 22, 39, 41, 656)	26.046 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)
782	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	16.875 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)
199	SELECT SQL_NO_CACHE * FROM `ps_category` a LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1 LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1 WHERE (a.`id_category` = 720) AND (b.`id_shop` = 1) LIMIT 1	10.339 ms	1			/src/Adapter/EntityMapper.php:71 /classes/ObjectModel.php:283 (load) /tools/profiling/ObjectModel.php:32 (__construct) /classes/Category.php:164 (__construct) /controllers/front/listing/CategoryController.php:216 (__construct) :undefined ({closure}) /controllers/front/listing/CategoryController.php:230 (array_map) /controllers/front/listing/CategoryController.php:118 (getTemplateVarSubCategories) /tools/profiling/Controller.php:41 (init) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
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	4.210 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)
765	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	4.125 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)
805	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.908 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)
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	3.477 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)
2	SELECT SQL_NO_CACHE c.`name`, cl.`id_lang`, IF(cl.`id_lang` IS NULL, c.`value`, cl.`value`) AS value, c.id_shop_group, c.id_shop FROM `ps_configuration` c LEFT JOIN `ps_configuration_lang` cl ON (c.`id_configuration` = cl.`id_configuration`)	2.881 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)
13	SELECT SQL_NO_CACHE h.`name` as hook, m.`id_module`, h.`id_hook`, m.`name` as module FROM `ps_module` m INNER JOIN ps_module_shop module_shop ON (module_shop.id_module = m.id_module AND module_shop.id_shop = 1 AND module_shop.enable_device & 1) INNER JOIN `ps_hook_module` `hm` ON hm.`id_module` = m.`id_module` INNER JOIN `ps_hook` `h` ON hm.`id_hook` = h.`id_hook` LEFT JOIN `ps_module_group` `mg` ON mg.`id_module` = m.`id_module` WHERE (h.`name` != "paymentOptions") AND (hm.`id_shop` = 1) AND (mg.id_shop = 1 AND mg.`id_group` IN (1)) GROUP BY hm.id_hook, hm.id_module ORDER BY hm.`position`	2.575 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)
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.487 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.375 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)
909	SELECT SQL_NO_CACHE p., product_shop., stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, product_attribute_shop.minimal_quantity AS product_attribute_minimal_quantity,IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, pl.`description`, pl.`description_short`, pl.`link_rewrite`, pl.`meta_description`, pl.`meta_keywords`, pl.`meta_title`, pl.`name`, pl.`available_now`, pl.`available_later`, m.`name` AS manufacturer_name, p.`id_manufacturer` as id_manufacturer, image_shop.`id_image` id_image, il.`legend`, ps.`quantity` AS sales, t.`rate`, pl.`meta_keywords`, pl.`meta_title`, pl.`meta_description`, DATEDIFF(p.`date_add`, DATE_SUB("2025-07-31 00:00:00", INTERVAL 1000 DAY)) > 0 AS new FROM `ps_product_sale` ps LEFT JOIN `ps_product` p ON ps.`id_product` = p.`id_product` LEFT JOIN ps_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) LEFT JOIN `ps_product_attribute_shop` product_attribute_shop ON (p.`id_product` = product_attribute_shop.`id_product` AND product_attribute_shop.`default_on` = 1 AND product_attribute_shop.id_shop=1) LEFT JOIN `ps_product_lang` pl ON p.`id_product` = pl.`id_product` AND pl.`id_lang` = 1 AND pl.id_shop = 1 LEFT JOIN `ps_image_shop` image_shop ON (image_shop.`id_product` = p.`id_product` AND image_shop.cover=1 AND image_shop.id_shop=1) LEFT JOIN `ps_image_lang` il ON (image_shop.`id_image` = il.`id_image` AND il.`id_lang` = 1) LEFT JOIN `ps_manufacturer` m ON (m.`id_manufacturer` = p.`id_manufacturer`) LEFT JOIN `ps_tax_rule` tr ON (product_shop.`id_tax_rules_group` = tr.`id_tax_rules_group`) AND tr.`id_country` = 6 AND tr.`id_state` = 0 LEFT JOIN `ps_tax` t ON (t.`id_tax` = tr.`id_tax`) LEFT JOIN ps_stock_available stock ON (stock.id_product = `p`.id_product AND stock.id_product_attribute = 0 AND stock.id_shop = 1 AND stock.id_shop_group = 0 ) WHERE product_shop.`active` = 1 AND product_shop.`visibility` != 'none' AND EXISTS(SELECT 1 FROM `ps_category_product` cp JOIN `ps_category_group` cg ON (cp.id_category = cg.id_category AND cg.`id_group` =1) WHERE cp.`id_product` = p.`id_product`) ORDER BY `sales` DESC LIMIT 0, 4	1.126 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)
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	1.051 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)
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 (731, 623, 732, 22, 39, 41, 656) GROUP BY p.id_product) p LEFT JOIN ps_specific_price sp ON ( sp.id_product = p.id_product AND sp.id_shop IN (0, 1) AND sp.id_currency IN (0, 1) AND sp.id_country IN (0, 6) AND sp.id_group IN (0, 1) AND sp.from_quantity = 1 AND sp.reduction > 0 AND sp.id_customer = 0 AND sp.id_cart = 0 AND (sp.from = '0000-00-00 00:00:00' OR '2025-07-31 23:13:37' >= sp.from) AND (sp.to = '0000-00-00 00:00:00' OR '2025-07-31 23:13:37' <= sp.to) ) WHERE ((sp.reduction>0))	0.962 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)
12	SELECT SQL_NO_CACHE lower(name) as name FROM `ps_hook` h WHERE (h.active = 1)	0.828 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)
1187	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.753 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)
383	SELECT SQL_NO_CACHE p., ps., pl.*, sa.out_of_stock, IFNULL(sa.quantity, 0) as quantity, (DATEDIFF( p.`date_add`, DATE_SUB( '2025-07-31 00:00:00', INTERVAL 1000 DAY ) ) > 0) as new FROM ps_product p LEFT JOIN ps_product_lang pl ON pl.id_product = p.id_product AND pl.id_shop = 1 AND pl.id_lang = 1 LEFT JOIN ps_stock_available sa ON sa.id_product = p.id_product AND sa.id_product_attribute = 0 AND sa.id_shop = 1 LEFT JOIN ps_product_shop ps ON ps.id_product = p.id_product AND ps.id_shop = 1 WHERE p.id_product IN (20832,842,194,33,20873,977,197,49,20914,978,198,93)	0.747 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)
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 (731, 623, 732, 22, 39, 41, 656) 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.737 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)
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 (731, 623, 732, 22, 39, 41, 656) 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.709 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)
1009	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.699 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)
737	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 (22841)	0.677 ms	1			/classes/ProductAssembler.php:64 /classes/ProductAssembler.php:182 (addMissingProductFields) /modules/tvcmsproductpopup/tvcmsproductpopup.php:390 (assembleProduct) /modules/tvcmsproductpopup/tvcmsproductpopup.php:252 (getNewProducts) /modules/tvcmsproductpopup/tvcmsproductpopup.php:546 (prevHook) /classes/Hook.php:1083 (hookdisplayAfterBodyOpeningTag) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:421 (coreCallHook) /classes/Hook.php:989 (callHookOn) /config/smarty.config.inc.php:201 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/dev/smarty/compile/v1_giftoo_168layouts_layout_left_column_tpl/69/81/ba/6981ba7f75ae91c680b199f8c9b8d3dbd8d96719_2.file.layout-both-columns.tpl.php:116 (__call) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/v1_giftoo_168layouts_layout_left_column_tpl/69/81/ba/6981ba7f75ae91c680b199f8c9b8d3dbd8d96719_2.file.layout-both-columns.tpl.php:54 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_688bca89963334_98279087) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/v1_giftoo_168layouts_layout_left_column_tpl/8d/0f/a6/8d0fa6a125af07e8554a5461801ff205a85e918e_2.file.layout-left-column.tpl.php:28 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_688bca89918cb8_31976545) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/v1_giftoo_168layouts_layout_left_column_tpl/33/cf/b7/33cfb772f37fe9bf7e7da2f4ede7b9ba2ebdb1ff_2.file.product-list.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_688bca898f8023_38089402) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/v1_giftoo_168layouts_layout_left_column_tpl/a5/95/48/a595487cdf0e93c51d790aa7d81fde9f6d267539_2.file.category.tpl.php:29 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_688bca898bc698_82360211) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/Smarty/SmartyCustom.php:112 (fetch) /classes/controller/FrontController.php:771 (fetch) /classes/controller/FrontController.php:753 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
727	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 (22843)	0.667 ms	1			/classes/ProductAssembler.php:64 /classes/ProductAssembler.php:182 (addMissingProductFields) /modules/tvcmsproductpopup/tvcmsproductpopup.php:390 (assembleProduct) /modules/tvcmsproductpopup/tvcmsproductpopup.php:252 (getNewProducts) /modules/tvcmsproductpopup/tvcmsproductpopup.php:546 (prevHook) /classes/Hook.php:1083 (hookdisplayAfterBodyOpeningTag) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:421 (coreCallHook) /classes/Hook.php:989 (callHookOn) /config/smarty.config.inc.php:201 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/dev/smarty/compile/v1_giftoo_168layouts_layout_left_column_tpl/69/81/ba/6981ba7f75ae91c680b199f8c9b8d3dbd8d96719_2.file.layout-both-columns.tpl.php:116 (__call) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/v1_giftoo_168layouts_layout_left_column_tpl/69/81/ba/6981ba7f75ae91c680b199f8c9b8d3dbd8d96719_2.file.layout-both-columns.tpl.php:54 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_688bca89963334_98279087) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/v1_giftoo_168layouts_layout_left_column_tpl/8d/0f/a6/8d0fa6a125af07e8554a5461801ff205a85e918e_2.file.layout-left-column.tpl.php:28 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_688bca89918cb8_31976545) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/v1_giftoo_168layouts_layout_left_column_tpl/33/cf/b7/33cfb772f37fe9bf7e7da2f4ede7b9ba2ebdb1ff_2.file.product-list.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_688bca898f8023_38089402) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/v1_giftoo_168layouts_layout_left_column_tpl/a5/95/48/a595487cdf0e93c51d790aa7d81fde9f6d267539_2.file.category.tpl.php:29 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_688bca898bc698_82360211) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/Smarty/SmartyCustom.php:112 (fetch) /classes/controller/FrontController.php:771 (fetch) /classes/controller/FrontController.php:753 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
15	SELECT SQL_NO_CACHE `id_hook`, `name` FROM `ps_hook`	0.634 ms	1107			/classes/Hook.php:1348 /classes/Hook.php:228 (getAllHookIds) /classes/Hook.php:857 (getIdByName) /classes/Dispatcher.php:606 (exec) /classes/Dispatcher.php:243 (loadRoutes) /classes/Dispatcher.php:201 (__construct) /index.php:28 (getInstance)
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 (731, 623, 732, 22, 39, 41, 656) 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.600 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)
382	REPLACE INTO ps_layered_filter_block (hash, data) VALUES ("0be2346adee8660bc06310f3b073fdf0", "a:1:{s:7:\"filters\";a:7:{i:0;a:7:{s:9:\"type_lite\";s:12:\"availability\";s:4:\"type\";s:12:\"availability\";s:6:\"id_key\";i:0;s:4:\"name\";s:14:\"Disponibilidad\";s:6:\"values\";a:2:{i:2;a:2:{s:4:\"name\";s:8:\"En stock\";s:3:\"nbr\";i:343;}i:0;a:2:{s:4:\"name\";s:13:\"No disponible\";s:3:\"nbr\";i:109;}}s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";s:1:\"0\";}i:1;a:7:{s:9:\"type_lite\";s:6:\"extras\";s:4:\"type\";s:6:\"extras\";s:6:\"id_key\";i:0;s:4:\"name\";s:10:\"Selections\";s:6:\"values\";a:3:{s:4:\"sale\";a:2:{s:4:\"name\";s:9:\"En oferta\";s:3:\"nbr\";i:21;}s:3:\"new\";a:2:{s:4:\"name\";s:5:\"Nuevo\";s:3:\"nbr\";i:343;}s:8:\"discount\";a:2:{s:4:\"name\";s:10:\"Discounted\";s:3:\"nbr\";i:0;}}s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";s:1:\"0\";}i:2;a:12:{s:9:\"type_lite\";s:5:\"price\";s:4:\"type\";s:5:\"price\";s:6:\"id_key\";i:0;s:4:\"name\";s:6:\"Precio\";s:3:\"max\";d:26;s:3:\"min\";d:1;s:4:\"unit\";s:3:\"€\";s:14:\"specifications\";a:11:{s:6:\"symbol\";a:11:{i:0;s:1:\",\";i:1;s:1:\".\";i:2;s:1:\";\";i:3;s:1:\"%\";i:4;s:1:\"-\";i:5;s:1:\"+\";i:6;s:1:\"E\";i:7;s:2:\"×\";i:8;s:3:\"‰\";i:9;s:3:\"∞\";i:10;s:3:\"NaN\";}s:12:\"currencyCode\";s:3:\"EUR\";s:14:\"currencySymbol\";s:3:\"€\";s:13:\"numberSymbols\";a:11:{i:0;s:1:\",\";i:1;s:1:\".\";i:2;s:1:\";\";i:3;s:1:\"%\";i:4;s:1:\"-\";i:5;s:1:\"+\";i:6;s:1:\"E\";i:7;s:2:\"×\";i:8;s:3:\"‰\";i:9;s:3:\"∞\";i:10;s:3:\"NaN\";}s:15:\"positivePattern\";s:12:\"#,##0.00 ¤\";s:15:\"negativePattern\";s:13:\"-#,##0.00 ¤\";s:17:\"maxFractionDigits\";i:2;s:17:\"minFractionDigits\";i:2;s:12:\"groupingUsed\";b:1;s:16:\"primaryGroupSize\";i:3;s:18:\"secondaryGroupSize\";i:3;}s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";i:3;s:3:\"nbr\";i:343;s:5:\"value\";N;}i:3;a:7:{s:9:\"type_lite\";s:8:\"category\";s:4:\"type\";s:8:\"category\";s:6:\"id_key\";i:0;s:4:\"name\";s:11:\"Categorías\";s:6:\"values\";a:122:{i:10;a:2:{s:4:\"name\";s:32:\"Herramientas, Brico y Automóvil\";s:3:\"nbr\";s:3:\"168\";}i:11;a:2:{s:4:\"name\";s:11:\"Agricultura\";s:3:\"nbr\";s:2:\"56\";}i:12;a:2:{s:4:\"name\";s:40:\"Vino, Accesorios de Bebida y Hostelería\";s:3:\"nbr\";s:3:\"227\";}i:13;a:2:{s:4:\"name\";s:24:\"Tecnología y Accesorios\";s:3:\"nbr\";s:3:\"552\";}i:14;a:2:{s:4:\"name\";s:18:\"Oficina y Negocios\";s:3:\"nbr\";s:3:\"429\";}i:15;a:2:{s:4:\"name\";s:22:\"Artículos Sostenibles\";s:3:\"nbr\";s:4:\"1629\";}i:16;a:2:{s:4:\"name\";s:9:\"Escritura\";s:3:\"nbr\";s:3:\"349\";}i:17;a:2:{s:4:\"name\";s:6:\"Outlet\";s:3:\"nbr\";s:3:\"222\";}i:18;a:2:{s:4:\"name\";s:18:\"Regalos y Premiums\";s:3:\"nbr\";s:3:\"411\";}i:19;a:2:{s:4:\"name\";s:14:\"Verano y Playa\";s:3:\"nbr\";s:3:\"274\";}i:20;a:2:{s:4:\"name\";s:22:\"Tazas, Jarras y Termos\";s:3:\"nbr\";s:3:\"417\";}i:21;a:2:{s:4:\"name\";s:16:\"Eventos y Fiesta\";s:3:\"nbr\";s:3:\"151\";}i:22;a:3:{s:4:\"name\";s:9:\"Take Away\";s:3:\"nbr\";s:3:\"107\";s:7:\"checked\";b:1;}i:23;a:2:{s:4:\"name\";s:8:\"Infantil\";s:3:\"nbr\";s:3:\"250\";}i:24;a:2:{s:4:\"name\";s:8:\"Mochilas\";s:3:\"nbr\";s:3:\"209\";}i:25;a:2:{s:4:\"name\";s:18:\"Gorras y Sombreros\";s:3:\"nbr\";s:3:\"118\";}i:26;a:2:{s:4:\"name\";s:12:\"Sublimación\";s:3:\"nbr\";s:3:\"127\";}i:27;a:2:{s:4:\"name\";s:6:\"Bolsas\";s:3:\"nbr\";s:3:\"207\";}i:28;a:2:{s:4:\"name\";s:5:\"Mujer\";s:3:\"nbr\";s:2:\"58\";}i:29;a:2:{s:4:\"name\";s:25:\"Cuidado Personal y Pharma\";s:3:\"nbr\";s:3:\"211\";}i:30;a:2:{s:4:\"name\";s:23:\"Productos para mascotas\";s:3:\"nbr\";s:2:\"40\";}i:31;a:2:{s:4:\"name\";s:18:\"Deporte y Aventura\";s:3:\"nbr\";s:3:\"137\";}i:32;a:2:{s:4:\"name\";s:5:\"Viaje\";s:3:\"nbr\";s:2:\"89\";}i:33;a:2:{s:4:\"name\";s:19:\"Hogar y Decoración\";s:3:\"nbr\";s:3:\"285\";}i:34;a:2:{s:4:\"name\";s:13:\"Lluvia y Frio\";s:3:\"nbr\";s:3:\"110\";}i:35;a:2:{s:4:\"name\";s:10:\"Spain Line\";s:3:\"nbr\";s:2:\"18\";}i:36;a:2:{s:4:\"name\";s:17:\"Embalaje Especial\";s:3:\"nbr\";s:2:\"66\";}i:37;a:2:{s:4:\"name\";s:7:\"Navidad\";s:3:\"nbr\";s:2:\"69\";}i:38;a:2:{s:4:\"name\";s:19:\"Ocio y tiempo libre\";s:3:\"nbr\";s:2:\"68\";}i:39;a:3:{s:4:\"name\";s:6:\"Textil\";s:3:\"nbr\";s:3:\"182\";s:7:\"checked\";b:1;}i:40;a:2:{s:4:\"name\";s:6:\"Marcas\";s:3:\"nbr\";s:2:\"57\";}i:41;a:3:{s:4:\"name\";s:9:\"USB STOCK\";s:3:\"nbr\";s:2:\"33\";s:7:\"checked\";b:1;}i:42;a:2:{s:4:\"name\";s:33:\"Colección protección higiénica\";s:3:\"nbr\";s:2:\"28\";}i:43;a:2:{s:4:\"name\";s:13:\"Antibacterial\";s:3:\"nbr\";s:2:\"23\";}i:44;a:2:{s:4:\"name\";s:14:\"Made in europe\";s:3:\"nbr\";s:2:\"40\";}i:45;a:2:{s:4:\"name\";s:15:\"Limited Edition\";s:3:\"nbr\";s:2:\"22\";}i:46;a:2:{s:4:\"name\";s:9:\"Novedades\";s:3:\"nbr\";s:3:\"387\";}i:116;a:2:{s:4:\"name\";s:17:\"Terraza y Jardín\";s:3:\"nbr\";s:4:\"2176\";}i:121;a:2:{s:4:\"name\";s:5:\"Hogar\";s:3:\"nbr\";s:4:\"3135\";}i:134;a:2:{s:4:\"name\";s:15:\"Deportes y Ocio\";s:3:\"nbr\";s:3:\"642\";}i:146;a:2:{s:4:\"name\";s:11:\"Ferretería\";s:3:\"nbr\";s:3:\"296\";}i:169;a:2:{s:4:\"name\";s:7:\"Oficina\";s:3:\"nbr\";s:3:\"565\";}i:203;a:2:{s:4:\"name\";s:23:\"Infantil y Puericultura\";s:3:\"nbr\";s:3:\"483\";}i:214;a:2:{s:4:\"name\";s:8:\"Mascotas\";s:3:\"nbr\";s:4:\"1170\";}i:227;a:2:{s:4:\"name\";s:20:\"Juguetes y Aficiones\";s:3:\"nbr\";s:3:\"673\";}i:230;a:2:{s:4:\"name\";s:32:\"Jaula grande exterior para gatos\";s:3:\"nbr\";s:1:\"1\";}i:251;a:2:{s:4:\"name\";s:20:\"Sombrilla reclinable\";s:3:\"nbr\";s:1:\"2\";}i:266;a:2:{s:4:\"name\";s:16:\"Jaula para gatos\";s:3:\"nbr\";s:1:\"1\";}i:283;a:2:{s:4:\"name\";s:11:\"Sube y baja\";s:3:\"nbr\";s:1:\"1\";}i:471;a:2:{s:4:\"name\";s:15:\"Juguetes y Ocio\";s:3:\"nbr\";s:1:\"6\";}i:501;a:2:{s:4:\"name\";s:26:\"Conjunto 2 tumbonas ratán\";s:3:\"nbr\";s:1:\"1\";}i:515;a:2:{s:4:\"name\";s:9:\"Temporary\";s:3:\"nbr\";s:1:\"2\";}i:520;a:2:{s:4:\"name\";s:8:\"Deportes\";s:3:\"nbr\";s:1:\"1\";}i:531;a:2:{s:4:\"name\";s:10:\"Categorias\";s:3:\"nbr\";s:4:\"1117\";}i:537;a:2:{s:4:\"name\";s:16:\"Detalles de Boda\";s:3:\"nbr\";s:3:\"242\";}i:553;a:2:{s:4:\"name\";s:11:\"Colecciones\";s:3:\"nbr\";s:1:\"6\";}i:557;a:2:{s:4:\"name\";s:21:\"Llaveros para eventos\";s:3:\"nbr\";s:1:\"3\";}i:572;a:2:{s:4:\"name\";s:16:\"Tumbona plegable\";s:3:\"nbr\";s:2:\"38\";}i:573;a:2:{s:4:\"name\";s:29:\"2 mesillas de noche flotantes\";s:3:\"nbr\";s:2:\"17\";}i:574;a:2:{s:4:\"name\";s:15:\"Rascador grande\";s:3:\"nbr\";s:2:\"34\";}i:575;a:2:{s:4:\"name\";s:19:\"Ventiladores de pie\";s:3:\"nbr\";s:2:\"17\";}i:576;a:2:{s:4:\"name\";s:16:\"Butaca con patas\";s:3:\"nbr\";s:2:\"17\";}i:577;a:2:{s:4:\"name\";s:39:\"Bloques espuma juguete (escalera/rampa)\";s:3:\"nbr\";s:2:\"17\";}i:578;a:2:{s:4:\"name\";s:32:\"Sombrilla de pared (una y media)\";s:3:\"nbr\";s:2:\"17\";}i:579;a:2:{s:4:\"name\";s:25:\"Tractor juguete a pedales\";s:3:\"nbr\";s:2:\"17\";}i:580;a:2:{s:4:\"name\";s:8:\"Aparador\";s:3:\"nbr\";s:2:\"38\";}i:581;a:2:{s:4:\"name\";s:31:\"Tienda de campaña 6-8 personas\";s:3:\"nbr\";s:2:\"17\";}i:582;a:2:{s:4:\"name\";s:26:\"Barrera seguridad mascotas\";s:3:\"nbr\";s:2:\"51\";}i:583;a:2:{s:4:\"name\";s:19:\"Caseta jardín gato\";s:3:\"nbr\";s:2:\"17\";}i:584;a:2:{s:4:\"name\";s:24:\"Jaula pájaros con patas\";s:3:\"nbr\";s:2:\"17\";}i:585;a:2:{s:4:\"name\";s:20:\"Mesa plegable cocina\";s:3:\"nbr\";s:2:\"17\";}i:586;a:2:{s:4:\"name\";s:15:\"Cochecito perro\";s:3:\"nbr\";s:2:\"17\";}i:587;a:2:{s:4:\"name\";s:21:\"Mueble auxiliar baño\";s:3:\"nbr\";s:2:\"17\";}i:588;a:2:{s:4:\"name\";s:19:\"Patinete eléctrico\";s:3:\"nbr\";s:2:\"34\";}i:589;a:2:{s:4:\"name\";s:17:\"Caja herramientas\";s:3:\"nbr\";s:2:\"17\";}i:590;a:2:{s:4:\"name\";s:6:\"Gazebo\";s:3:\"nbr\";s:2:\"34\";}i:591;a:2:{s:4:\"name\";s:28:\"Conjunto 4 sillas de comedor\";s:3:\"nbr\";s:2:\"17\";}i:592;a:2:{s:4:\"name\";s:27:\"Bicicleta-triciclo infantil\";s:3:\"nbr\";s:2:\"17\";}i:593;a:2:{s:4:\"name\";s:18:\"Carrito para playa\";s:3:\"nbr\";s:2:\"17\";}i:594;a:2:{s:4:\"name\";s:31:\"armario-vitrina auxiliar cocina\";s:3:\"nbr\";s:2:\"17\";}i:595;a:2:{s:4:\"name\";s:17:\"Techo para carpas\";s:3:\"nbr\";s:2:\"17\";}i:596;a:2:{s:4:\"name\";s:8:\"Pérgola\";s:3:\"nbr\";s:2:\"17\";}i:597;a:2:{s:4:\"name\";s:25:\"Rascador mediano + caseta\";s:3:\"nbr\";s:2:\"17\";}i:598;a:2:{s:4:\"name\";s:30:\"Mesa plegable cocina con rueda\";s:3:\"nbr\";s:2:\"21\";}i:599;a:2:{s:4:\"name\";s:17:\"Cubierta radiador\";s:3:\"nbr\";s:2:\"21\";}i:600;a:2:{s:4:\"name\";s:11:\"Invernadero\";s:3:\"nbr\";s:2:\"21\";}i:601;a:2:{s:4:\"name\";s:28:\"2 mesitas de noche flotantes\";s:3:\"nbr\";s:2:\"21\";}i:602;a:2:{s:4:\"name\";s:18:\"Chimenea con patas\";s:3:\"nbr\";s:2:\"21\";}i:603;a:2:{s:4:\"name\";s:21:\"Sofá + cama 2 plazas\";s:3:\"nbr\";s:2:\"21\";}i:604;a:2:{s:4:\"name\";s:46:\"Doble pizarra con caballete y acjones infantil\";s:3:\"nbr\";s:2:\"21\";}i:605;a:2:{s:4:\"name\";s:42:\"Jaula doble para conejo con patas exterior\";s:3:\"nbr\";s:2:\"21\";}i:606;a:2:{s:4:\"name\";s:17:\"Pérgola de pared\";s:3:\"nbr\";s:2:\"21\";}i:607;a:2:{s:4:\"name\";s:21:\"Mesita ratán jardín\";s:3:\"nbr\";s:2:\"21\";}i:608;a:2:{s:4:\"name\";s:17:\"Tobogán infantil\";s:3:\"nbr\";s:2:\"21\";}i:609;a:2:{s:4:\"name\";s:16:\"Carpa mosquitera\";s:3:\"nbr\";s:2:\"21\";}i:610;a:2:{s:4:\"name\";s:25:\"Corral metálico mascotas\";s:3:\"nbr\";s:2:\"21\";}i:611;a:2:{s:4:\"name\";s:22:\"Espejo baño + armario\";s:3:\"nbr\";s:2:\"21\";}i:612;a:2:{s:4:\"name\";s:23:\"Mueble tv + estantería\";s:3:\"nbr\";s:2:\"21\";}i:613;a:2:{s:4:\"name\";s:15:\"Corral exterior\";s:3:\"nbr\";s:2:\"21\";}i:614;a:2:{s:4:\"name\";s:14:\"Hidrolimpiador\";s:3:\"nbr\";s:2:\"21\";}i:615;a:2:{s:4:\"name\";s:17:\"Balancín jardín\";s:3:\"nbr\";s:2:\"21\";}i:616;a:2:{s:4:\"name\";s:19:\"Ventilador de techo\";s:3:\"nbr\";s:2:\"21\";}i:617;a:2:{s:4:\"name\";s:25:\"Juegos equilibrios madera\";s:3:\"nbr\";s:2:\"21\";}i:618;a:2:{s:4:\"name\";s:10:\"Marquesina\";s:3:\"nbr\";s:2:\"21\";}i:619;a:2:{s:4:\"name\";s:17:\"Carpa con paredes\";s:3:\"nbr\";s:2:\"21\";}i:620;a:2:{s:4:\"name\";s:14:\"Jaula pájaros\";s:3:\"nbr\";s:2:\"21\";}i:621;a:2:{s:4:\"name\";s:23:\"Cochecito paseo pedales\";s:3:\"nbr\";s:2:\"21\";}i:622;a:2:{s:4:\"name\";s:18:\"Ventiladores torre\";s:3:\"nbr\";s:2:\"21\";}i:623;a:3:{s:4:\"name\";s:16:\"Sofá-cama-perro\";s:3:\"nbr\";s:2:\"21\";s:7:\"checked\";b:1;}i:624;a:2:{s:4:\"name\";s:13:\"Cama plegable\";s:3:\"nbr\";s:2:\"21\";}i:625;a:2:{s:4:\"name\";s:29:\"Mesa auxiliar jardín-balcón\";s:3:\"nbr\";s:2:\"21\";}i:626;a:2:{s:4:\"name\";s:29:\"Almacenar juguetes con ruedas\";s:3:\"nbr\";s:2:\"21\";}i:627;a:2:{s:4:\"name\";s:13:\"Mueble cocina\";s:3:\"nbr\";s:2:\"21\";}i:628;a:2:{s:4:\"name\";s:22:\"Sillón madera jardín\";s:3:\"nbr\";s:2:\"21\";}i:629;a:2:{s:4:\"name\";s:23:\"Estantería baja madera\";s:3:\"nbr\";s:2:\"21\";}i:630;a:2:{s:4:\"name\";s:27:\"Nevera portátil-eléctrica\";s:3:\"nbr\";s:2:\"21\";}i:631;a:2:{s:4:\"name\";s:19:\"Cama elevada perros\";s:3:\"nbr\";s:2:\"21\";}i:632;a:2:{s:4:\"name\";s:11:\"Casa conejo\";s:3:\"nbr\";s:2:\"21\";}i:633;a:2:{s:4:\"name\";s:21:\"Mesa pequeña jardín\";s:3:\"nbr\";s:2:\"21\";}i:634;a:2:{s:4:\"name\";s:22:\"Banco trabajo plegable\";s:3:\"nbr\";s:2:\"21\";}i:635;a:2:{s:4:\"name\";s:18:\"Balancín infantil\";s:3:\"nbr\";s:2:\"21\";}i:636;a:2:{s:4:\"name\";s:14:\"Tocador adulto\";s:3:\"nbr\";s:2:\"21\";}}s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";s:1:\"0\";}i:4;a:7:{s:9:\"type_lite\";s:12:\"manufacturer\";s:4:\"type\";s:12:\"manufacturer\";s:6:\"id_key\";i:0;s:4:\"name\";s:5:\"Marca\";s:6:\"values\";a:2:{i:3;a:2:{s:4:\"name\";s:17:\"Fruit Of The Loom\";s:3:\"nbr\";s:2:\"26\";}i:10;a:2:{s:4:\"name\";s:4:\"KEYA\";s:3:\"nbr\";s:2:\"27\";}}s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";s:1:\"0\";}i:5;a:7:{s:9:\"type_lite\";s:9:\"condition\";s:4:\"type\";s:9:\"condition\";s:6:\"id_key\";i:0;s:4:\"name\";s:6:\"Estado\";s:6:\"values\";a:3:{s:3:\"new\";a:2:{s:4:\"name\";s:5:\"Nuevo\";s:3:\"nbr\";s:3:\"343\";}s:4:\"used\";a:2:{s:4:\"name\";s:5:\"Usado\";s:3:\"nbr\";i:0;}s:11:\"refurbished\";a:2:{s:4:\"name\";s:15:\"Reacondicionado\";s:3:\"nbr\";i:0;}}s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";s:1:\"0\";}i:6;a:12:{s:9:\"type_lite\";s:6:\"weight\";s:4:\"type\";s:6:\"weight\";s:6:\"id_key\";i:0;s:4:\"name\";s:4:\"Peso\";s:3:\"max\";d:0.556;s:3:\"min\";d:0;s:4:\"unit\";s:2:\"kg\";s:14:\"specifications\";N;s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";i:3;s:5:\"value\";N;s:3:\"nbr\";i:343;}}}")	0.593 ms	1			/modules/ps_facetedsearch/src/Filters/Block.php:211 /modules/ps_facetedsearch/src/Product/SearchProvider.php:217 (insertIntoCache) /classes/controller/ProductListingFrontController.php:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
801	SELECT SQL_NO_CACHE p., product_shop., stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, pl.`description`, pl.`description_short`, pl.`available_now`, pl.`available_later`, IFNULL(product_attribute_shop.id_product_attribute, 0) id_product_attribute, pl.`link_rewrite`, pl.`meta_description`, pl.`meta_keywords`, pl.`meta_title`, pl.`name`, image_shop.`id_image` id_image, il.`legend`, m.`name` AS manufacturer_name, DATEDIFF( p.`date_add`, DATE_SUB( "2025-07-31 00:00:00", INTERVAL 1000 DAY ) ) > 0 AS new FROM `ps_product` p INNER JOIN ps_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) LEFT JOIN `ps_product_attribute_shop` product_attribute_shop ON (p.`id_product` = product_attribute_shop.`id_product` AND product_attribute_shop.`default_on` = 1 AND product_attribute_shop.id_shop=1) LEFT JOIN ps_stock_available stock ON (stock.id_product = `p`.id_product AND stock.id_product_attribute = 0 AND stock.id_shop = 1 AND stock.id_shop_group = 0 ) LEFT JOIN `ps_product_lang` pl ON ( p.`id_product` = pl.`id_product` AND pl.`id_lang` = 1 AND pl.id_shop = 1 ) LEFT JOIN `ps_image_shop` image_shop ON (image_shop.`id_product` = p.`id_product` AND image_shop.cover=1 AND image_shop.id_shop=1) LEFT JOIN `ps_image_lang` il ON (image_shop.`id_image` = il.`id_image` AND il.`id_lang` = 1) LEFT JOIN `ps_manufacturer` m ON (m.`id_manufacturer` = p.`id_manufacturer`) WHERE product_shop.`active` = 1 AND product_shop.`show_price` = 1 AND product_shop.`visibility` IN ("both", "catalog") AND p.`id_product` IN (0) AND EXISTS(SELECT 1 FROM `ps_category_product` cp JOIN `ps_category_group` cg ON (cp.id_category = cg.id_category AND cg.`id_group` =1) WHERE cp.`id_product` = p.`id_product`)	0.591 ms	0			/classes/Product.php:3393 /modules/tvcmstabproducts/tvcmstabproducts.php:2863 (getPricesDrop) /modules/tvcmsspecialproducts/tvcmsspecialproducts.php:157 (displaySpecialProducts) /modules/tvcmsspecialproducts/tvcmsspecialproducts.php:268 (showFrontSideResult) /classes/Hook.php:1083 (hookdisplayLeftColumn) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:421 (coreCallHook) /classes/Hook.php:989 (callHookOn) /config/smarty.config.inc.php:201 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/dev/smarty/compile/v1_giftoo_168layouts_layout_left_column_tpl/69/81/ba/6981ba7f75ae91c680b199f8c9b8d3dbd8d96719_2.file.layout-both-columns.tpl.php:192 (__call) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/v1_giftoo_168layouts_layout_left_column_tpl/69/81/ba/6981ba7f75ae91c680b199f8c9b8d3dbd8d96719_2.file.layout-both-columns.tpl.php:74 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_688bca89963334_98279087) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/v1_giftoo_168layouts_layout_left_column_tpl/8d/0f/a6/8d0fa6a125af07e8554a5461801ff205a85e918e_2.file.layout-left-column.tpl.php:28 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_688bca89918cb8_31976545) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/v1_giftoo_168layouts_layout_left_column_tpl/33/cf/b7/33cfb772f37fe9bf7e7da2f4ede7b9ba2ebdb1ff_2.file.product-list.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_688bca898f8023_38089402) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/v1_giftoo_168layouts_layout_left_column_tpl/a5/95/48/a595487cdf0e93c51d790aa7d81fde9f6d267539_2.file.category.tpl.php:29 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_688bca898bc698_82360211) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/Smarty/SmartyCustom.php:112 (fetch) /classes/controller/FrontController.php:771 (fetch) /classes/controller/FrontController.php:753 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
892	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.589 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)
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 (731, 623, 732, 22, 39, 41, 656) 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.585 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)

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
137 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
38 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
25 queries	SELECT `id_product_attribute` FROM `ps_product_attribute` WHERE `id_product` = 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
18 queries	SELECT `id_module` FROM `ps_module_shop` WHERE `id_module` = XX AND `id_shop` = XX LIMIT XX
18 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
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)
14 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
14 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
14 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
14 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
14 queries	SELECT * FROM `ps_product_attribute_lang` WHERE `id_product_attribute` = XX
13 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
9 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
9 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
9 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
9 queries	SELECT * FROM `ps_product_lang` WHERE `id_product` = XX AND `id_shop` = XX
9 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`
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
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	67	/classes/Link.php:113 (__construct) [id: 20832] /classes/Link.php:113 (__construct) [id: 842] /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: 977] /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: 978] /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: 842] /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: 977] /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: 978] /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: 842] /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: 977] /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: 978] /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: 724] /classes/Link.php:113 (__construct) [id: 2227] /classes/Link.php:113 (__construct) [id: 99] /classes/Link.php:113 (__construct) [id: 654] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 724] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 2227] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 99] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 654] /classes/Link.php:113 (__construct) [id: 19321] /classes/Link.php:113 (__construct) [id: 441] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 19321] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 15023] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 441] /src/Adapter/Presenter/Product/ProductLazyArray.php:658 (__construct) [id: 842] /src/Adapter/Presenter/Product/ProductLazyArray.php:658 (__construct) [id: 194] /src/Adapter/Presenter/Product/ProductLazyArray.php:658 (__construct) [id: 33] /src/Adapter/Presenter/Product/ProductLazyArray.php:658 (__construct) [id: 977] /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: 978] /src/Adapter/Presenter/Product/ProductLazyArray.php:658 (__construct) [id: 198] /src/Adapter/Presenter/Product/ProductLazyArray.php:658 (__construct) [id: 93]
Combination	14	/classes/Product.php:5912 (__construct) [id: 4275] /classes/Product.php:5912 (__construct) [id: 686] /classes/Product.php:5912 (__construct) [id: 64] /classes/Product.php:5912 (__construct) [id: 4713] /classes/Product.php:5912 (__construct) [id: 727] /classes/Product.php:5912 (__construct) [id: 110] /classes/Product.php:5912 (__construct) [id: 4715] /classes/Product.php:5912 (__construct) [id: 743] /classes/Product.php:5912 (__construct) [id: 331] /classes/Product.php:5912 (__construct) [id: 3731] /classes/Product.php:5912 (__construct) [id: 8756] /classes/Product.php:5912 (__construct) [id: 343] /classes/Product.php:5912 (__construct) [id: 3524] /classes/Product.php:5912 (__construct) [id: 2584]
Country	7	/config/config.inc.php:146 (__construct) [id: 6] /classes/AddressFormat.php:404 (__construct) [id: 6] /classes/controller/FrontController.php:1779 (__construct) [id: 6] /classes/AddressFormat.php:404 (__construct) [id: 6] /modules/ps_contactinfo/ps_contactinfo.php:105 (__construct) [id: 6] /classes/AddressFormat.php:404 (__construct) [id: 6] /modules/ps_contactinfo/ps_contactinfo.php:105 (__construct) [id: 6]
State	5	/classes/controller/FrontController.php:1778 (__construct) [id: 369] /modules/ps_contactinfo/ps_contactinfo.php:94 (__construct) [id: 369] /modules/ps_contactinfo/ps_contactinfo.php:104 (__construct) [id: 369] /modules/ps_contactinfo/ps_contactinfo.php:94 (__construct) [id: 369] /modules/ps_contactinfo/ps_contactinfo.php:104 (__construct) [id: 369]
Address	4	/classes/shop/Shop.php:486 (__construct) [id: ] /classes/Product.php:3694 (initialize) [id: ] /classes/Product.php:3804 (__construct) [id: ] /classes/Product.php:5964 (__construct) [id: ]
AddressFormat	3	/classes/controller/FrontController.php:1773 (generateAddress) [id: ] /modules/ps_contactinfo/ps_contactinfo.php:91 (generateAddress) [id: ] /modules/ps_contactinfo/ps_contactinfo.php:91 (generateAddress) [id: ]
Language	2	/config/config.inc.php:211 (__construct) [id: 1] /classes/Tools.php:560 (__construct) [id: 1]
Currency	2	/src/Adapter/Currency/CurrencyDataProvider.php:101 (__construct) [id: 1] /classes/Tools.php:690 (getCurrencyInstance) [id: 1]
Cart	2	/classes/controller/FrontController.php:467 (__construct) [id: ] /classes/controller/FrontController.php:541 (__construct) [id: ]
Tax	2	/classes/tax/TaxRulesTaxManager.php:116 (__construct) [id: 1] /classes/tax/TaxRulesTaxManager.php:116 (__construct) [id: 1]
Shop	1	/config/config.inc.php:117 (initialize) [id: 1]
TvcmsMegaMenuClass	1	/modules/tvcmsmegamenu/tvcmsmegamenu.php:1386 (__construct) [id: ]
Gender	1	/classes/controller/FrontController.php:1702 (__construct) [id: 0]
Risk	1	/classes/controller/FrontController.php:1705 (__construct) [id: ]
Group	1	/classes/Cart.php:249 (getCurrent) [id: 1]
Customer	1	/config/config.inc.php:264 (__construct) [id: ]
ShopGroup	1	/classes/shop/Shop.php:561 (__construct) [id: 1]
ConnectionsSource	1	/modules/statsdata/statsdata.php:119 (logHttpReferer) [id: ]

#	Filename
0	/index.php
1	/config/config.inc.php
2	/config/defines.inc.php
3	/config/autoload.php
4	/vendor/autoload.php
5	/vendor/composer/autoload_real.php
6	/vendor/composer/platform_check.php
7	/vendor/composer/ClassLoader.php
8	/vendor/composer/include_paths.php
9	/vendor/composer/autoload_static.php
10	/vendor/symfony/polyfill-php72/bootstrap.php
11	/vendor/symfony/polyfill-mbstring/bootstrap.php
12	/vendor/symfony/polyfill-mbstring/bootstrap80.php
13	/vendor/symfony/polyfill-intl-normalizer/bootstrap.php
14	/vendor/symfony/polyfill-intl-normalizer/bootstrap80.php
15	/vendor/symfony/polyfill-intl-idn/bootstrap.php
16	/vendor/symfony/deprecation-contracts/function.php
17	/vendor/ralouphie/getallheaders/src/getallheaders.php
18	/vendor/symfony/polyfill-ctype/bootstrap.php
19	/vendor/symfony/polyfill-ctype/bootstrap80.php
20	/vendor/symfony/polyfill-php80/bootstrap.php
21	/vendor/guzzlehttp/promises/src/functions_include.php
22	/vendor/guzzlehttp/promises/src/functions.php
23	/vendor/guzzlehttp/guzzle/src/functions_include.php
24	/vendor/guzzlehttp/guzzle/src/functions.php
25	/vendor/symfony/polyfill-iconv/bootstrap.php
26	/vendor/ezyang/htmlpurifier/library/HTMLPurifier.composer.php
27	/vendor/jakeasmith/http_build_url/src/http_build_url.php
28	/vendor/lcobucci/jwt/compat/class-aliases.php
29	/vendor/lcobucci/jwt/src/Token.php
30	/vendor/lcobucci/jwt/src/Signature.php
31	/vendor/lcobucci/jwt/compat/json-exception-polyfill.php
32	/vendor/lcobucci/jwt/compat/lcobucci-clock-polyfill.php
33	/vendor/swiftmailer/swiftmailer/lib/swift_required.php
34	/vendor/swiftmailer/swiftmailer/lib/classes/Swift.php
35	/vendor/symfony/polyfill-intl-icu/bootstrap.php
36	/vendor/symfony/polyfill-php73/bootstrap.php
37	/vendor/symfony/polyfill-php81/bootstrap.php
38	/vendor/api-platform/core/src/deprecation.php
39	/vendor/api-platform/core/src/Api/FilterInterface.php

Joyero Mujer

Mesa de Bar

Soporte para Impresora

Biombo

Butaca de Salón

Carrito

Memoria USB Rebik 16GB

Memoria USB Rebik 16GB

Memoria USB Rebik 16GB

Memoria USB Rebik 16GB

Chaqueta Molter

Chaqueta Molter

Chaqueta Molter

Chaqueta Molter

VELA VESTIDO DE NOVIA

VELA VESTIDO DE NOVIA

VELA VESTIDO DE NOVIA

VELA VESTIDO DE NOVIA

Memoria USB Drelan 8GB

Memoria USB Drelan 8GB

Memoria USB Drelan 8GB

Memoria USB Drelan 8GB

Parka Zylka

Parka Zylka

Parka Zylka

Parka Zylka

Nevera Coolcan

Nevera Coolcan

Nevera Coolcan

Nevera Coolcan

Memoria USB Fixing 16GB

Memoria USB Fixing 16GB

Memoria USB Fixing 16GB

Memoria USB Fixing 16GB

Impermeable Garu

Impermeable Garu

Impermeable Garu

Impermeable Garu

Bolsa Nevera Daniels

Bolsa Nevera Daniels

Bolsa Nevera Daniels

Bolsa Nevera Daniels

Stopwatch SQL - 1257 queries

Doubles

Tables stress

ObjectModel instances

Included Files