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	1549 ms
Querying Time	901 ms
Queries	1127
Memory Peak Usage	35.3 Mb
Included Files	1256 files - 14.30 Mb
PrestaShop Cache	- Mb
Global vars	0.23 Mb
- global $_MODULES	209k
- global $_SERVER	7k
- global $config	5k
- global $context	3k
- global $__composer_autoload_files	3k
- global $exportPhpConfigFile	3k
- global $smarty	2k
- global $_ENV	2k
- global $_MODULE	2k

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

	Time	Cumulated Time	Memory Usage	Memory Peak Usage
config	19.769 ms	19.769 ms	2.98 Mb	3.3 Mb
__construct	0.009 ms	19.778 ms	- Mb	3.3 Mb
init	93.737 ms	113.515 ms	3.08 Mb	6.5 Mb
checkAccess	0.002 ms	113.517 ms	- Mb	6.5 Mb
setMedia	8.358 ms	121.875 ms	0.20 Mb	6.5 Mb
postProcess	0.001 ms	121.876 ms	- Mb	6.5 Mb
initHeader	0.000 ms	121.876 ms	- Mb	6.5 Mb
initContent	970 ms	1092 ms	6.02 Mb	12.4 Mb
initFooter	0.002 ms	1092 ms	- Mb	12.4 Mb
display	457.333 ms	1549 ms	21.61 Mb	35.3 Mb

Hook	Time	Memory Usage
DisplayHeader	183.613 ms	0.56 Mb
=> ps_shoppingcart	0.074 ms	- Mb
=> ps_searchbar	0.937 ms	- Mb
=> ps_imageslider	0.414 ms	- Mb
=> productcomments	0.470 ms	- Mb
=> psxmarketingwithgoogle	3.586 ms	0.01 Mb
=> ps_googleanalytics	1.626 ms	0.02 Mb
=> tvcmsbestsellerproducts	0.142 ms	- Mb
=> tvcmsblog	0.686 ms	- Mb
=> tvcmsblogdisplayposts	0.438 ms	- Mb
=> tvcmsbrandlist	0.349 ms	- Mb
=> tvcmscategorychainslider	0.414 ms	- Mb
=> tvcmscategoryslider	0.333 ms	- Mb
=> tvcmscookiesnotice	0.339 ms	- Mb
=> tvcmscustomerservices	0.412 ms	- Mb
=> tvcmscustomsetting	2.101 ms	0.01 Mb
=> tvcmsfeaturedproducts	0.133 ms	- Mb
=> tvcmsfooterlogo	0.001 ms	- Mb
=> tvcmsfooterproduct	0.132 ms	- Mb
=> tvcmsnewproducts	0.132 ms	- Mb
=> tvcmsnewsletterpopup	0.677 ms	- Mb
=> tvcmspaymenticon	0.001 ms	- Mb
=> tvcmsproductcomments	1.266 ms	- Mb
=> tvcmsproductcompare	0.347 ms	- Mb
=> tvcmsproductpopup	0.328 ms	- Mb
=> tvcmssearch	0.931 ms	- Mb
=> tvcmssizechart	0.333 ms	- Mb
=> tvcmsslider	0.334 ms	- Mb
=> tvcmsspecialproducts	0.136 ms	- Mb
=> tvcmsstoretime	0.331 ms	- Mb
=> tvcmstabproducts	0.360 ms	- Mb
=> tvcmstestimonial	0.358 ms	- Mb
=> tvcmsthemeoptions	1.029 ms	- Mb
=> tvcmsvideoblock	0.334 ms	- Mb
=> tvcmswishlist	0.370 ms	- Mb
=> smartargetwhatsapp	0.847 ms	0.01 Mb
=> ps_facebook	162.913 ms	0.45 Mb
DisplayLeftColumn	118.474 ms	5.47 Mb
=> tvcmsnewproducts	40.796 ms	0.89 Mb
=> tvcmscustomerservices	0.838 ms	0.08 Mb
=> tvcmsspecialproducts	1.853 ms	0.10 Mb
=> tvcmsfeaturedproducts	47.848 ms	2.72 Mb
=> tvcmsbestsellerproducts	27.139 ms	1.68 Mb
DisplayAfterBodyOpeningTag	67.566 ms	2.77 Mb
=> tvcmscookiesnotice	0.909 ms	0.02 Mb
=> blockreassurance	0.004 ms	- Mb
=> tvcmsproductpopup	66.653 ms	2.76 Mb
DisplayReviewProductList	50.708 ms	3.77 Mb
=> tvcmsproductcomments	1.557 ms	0.12 Mb
=> tvcmsproductcomments	1.153 ms	0.07 Mb
=> tvcmsproductcomments	1.011 ms	0.07 Mb
=> tvcmsproductcomments	0.956 ms	0.07 Mb
=> tvcmsproductcomments	1.201 ms	0.11 Mb
=> tvcmsproductcomments	1.063 ms	0.07 Mb
=> tvcmsproductcomments	1.010 ms	0.07 Mb
=> tvcmsproductcomments	0.929 ms	0.06 Mb
=> tvcmsproductcomments	1.098 ms	0.11 Mb
=> tvcmsproductcomments	1.213 ms	0.07 Mb
=> tvcmsproductcomments	0.991 ms	0.07 Mb
=> tvcmsproductcomments	0.975 ms	0.06 Mb
=> tvcmsproductcomments	1.214 ms	0.11 Mb
=> tvcmsproductcomments	1.013 ms	0.07 Mb
=> tvcmsproductcomments	0.982 ms	0.07 Mb
=> tvcmsproductcomments	0.925 ms	0.06 Mb
=> tvcmsproductcomments	1.239 ms	0.11 Mb
=> tvcmsproductcomments	1.034 ms	0.07 Mb
=> tvcmsproductcomments	1.064 ms	0.07 Mb
=> tvcmsproductcomments	0.970 ms	0.06 Mb
=> tvcmsproductcomments	1.242 ms	0.11 Mb
=> tvcmsproductcomments	0.989 ms	0.07 Mb
=> tvcmsproductcomments	0.968 ms	0.07 Mb
=> tvcmsproductcomments	0.953 ms	0.06 Mb
=> tvcmsproductcomments	1.160 ms	0.14 Mb
=> tvcmsproductcomments	0.970 ms	0.07 Mb
=> tvcmsproductcomments	0.963 ms	0.07 Mb
=> tvcmsproductcomments	0.975 ms	0.06 Mb
=> tvcmsproductcomments	1.159 ms	0.11 Mb
=> tvcmsproductcomments	0.953 ms	0.07 Mb
=> tvcmsproductcomments	0.968 ms	0.07 Mb
=> tvcmsproductcomments	0.959 ms	0.06 Mb
=> tvcmsproductcomments	1.184 ms	0.11 Mb
=> tvcmsproductcomments	1.039 ms	0.07 Mb
=> tvcmsproductcomments	1.035 ms	0.07 Mb
=> tvcmsproductcomments	1.206 ms	0.06 Mb
=> tvcmsproductcomments	1.194 ms	0.11 Mb
=> tvcmsproductcomments	0.968 ms	0.07 Mb
=> tvcmsproductcomments	0.959 ms	0.07 Mb
=> tvcmsproductcomments	0.904 ms	0.06 Mb
=> tvcmsproductcomments	1.313 ms	0.11 Mb
=> tvcmsproductcomments	0.993 ms	0.07 Mb
=> tvcmsproductcomments	0.966 ms	0.07 Mb
=> tvcmsproductcomments	0.936 ms	0.06 Mb
=> tvcmsproductcomments	1.189 ms	0.11 Mb
=> tvcmsproductcomments	1.001 ms	0.07 Mb
=> tvcmsproductcomments	0.988 ms	0.07 Mb
=> tvcmsproductcomments	0.977 ms	0.06 Mb
DisplayWishlistBtnProductList	29.207 ms	- Mb
=> tvcmswishlist	0.839 ms	0.01 Mb
=> tvcmswishlist	0.616 ms	- Mb
=> tvcmswishlist	0.603 ms	- Mb
=> tvcmswishlist	0.594 ms	- Mb
=> tvcmswishlist	0.617 ms	- Mb
=> tvcmswishlist	0.763 ms	- Mb
=> tvcmswishlist	0.609 ms	- Mb
=> tvcmswishlist	0.598 ms	- Mb
=> tvcmswishlist	0.574 ms	- Mb
=> tvcmswishlist	0.595 ms	- Mb
=> tvcmswishlist	0.632 ms	- Mb
=> tvcmswishlist	0.595 ms	- Mb
=> tvcmswishlist	0.687 ms	- Mb
=> tvcmswishlist	0.629 ms	- Mb
=> tvcmswishlist	0.593 ms	- Mb
=> tvcmswishlist	0.627 ms	- Mb
=> tvcmswishlist	0.578 ms	- Mb
=> tvcmswishlist	0.589 ms	- Mb
=> tvcmswishlist	0.593 ms	- Mb
=> tvcmswishlist	0.608 ms	- Mb
=> tvcmswishlist	0.662 ms	- Mb
=> tvcmswishlist	0.590 ms	- Mb
=> tvcmswishlist	0.574 ms	- Mb
=> tvcmswishlist	0.580 ms	- Mb
=> tvcmswishlist	0.588 ms	- Mb
=> tvcmswishlist	0.573 ms	- Mb
=> tvcmswishlist	0.587 ms	- Mb
=> tvcmswishlist	0.579 ms	- Mb
=> tvcmswishlist	0.596 ms	- Mb
=> tvcmswishlist	0.573 ms	- Mb
=> tvcmswishlist	0.636 ms	- Mb
=> tvcmswishlist	0.579 ms	- Mb
=> tvcmswishlist	0.591 ms	- Mb
=> tvcmswishlist	0.602 ms	- Mb
=> tvcmswishlist	0.615 ms	- Mb
=> tvcmswishlist	0.581 ms	- Mb
=> tvcmswishlist	0.583 ms	- Mb
=> tvcmswishlist	0.592 ms	- Mb
=> tvcmswishlist	0.593 ms	- Mb
=> tvcmswishlist	0.589 ms	- Mb
=> tvcmswishlist	0.586 ms	- Mb
=> tvcmswishlist	0.595 ms	- Mb
=> tvcmswishlist	0.589 ms	- Mb
=> tvcmswishlist	0.573 ms	- Mb
=> tvcmswishlist	0.602 ms	- Mb
=> tvcmswishlist	0.595 ms	- Mb
=> tvcmswishlist	0.687 ms	- Mb
=> tvcmswishlist	0.578 ms	- Mb
DisplayProductCompareProductList	27.606 ms	0.10 Mb
=> tvcmsproductcompare	0.874 ms	0.01 Mb
=> tvcmsproductcompare	0.566 ms	- Mb
=> tvcmsproductcompare	0.581 ms	- Mb
=> tvcmsproductcompare	0.590 ms	- Mb
=> tvcmsproductcompare	0.597 ms	- Mb
=> tvcmsproductcompare	0.576 ms	- Mb
=> tvcmsproductcompare	0.547 ms	- Mb
=> tvcmsproductcompare	0.566 ms	- Mb
=> tvcmsproductcompare	0.575 ms	- Mb
=> tvcmsproductcompare	0.559 ms	- Mb
=> tvcmsproductcompare	0.520 ms	- Mb
=> tvcmsproductcompare	0.595 ms	- Mb
=> tvcmsproductcompare	0.611 ms	- Mb
=> tvcmsproductcompare	0.565 ms	- Mb
=> tvcmsproductcompare	0.515 ms	- Mb
=> tvcmsproductcompare	0.558 ms	- Mb
=> tvcmsproductcompare	0.590 ms	- Mb
=> tvcmsproductcompare	0.568 ms	- Mb
=> tvcmsproductcompare	0.520 ms	- Mb
=> tvcmsproductcompare	0.579 ms	- Mb
=> tvcmsproductcompare	0.595 ms	- Mb
=> tvcmsproductcompare	0.581 ms	- Mb
=> tvcmsproductcompare	0.532 ms	- Mb
=> tvcmsproductcompare	0.605 ms	- Mb
=> tvcmsproductcompare	0.560 ms	- Mb
=> tvcmsproductcompare	0.572 ms	- Mb
=> tvcmsproductcompare	0.508 ms	- Mb
=> tvcmsproductcompare	0.595 ms	- Mb
=> tvcmsproductcompare	0.581 ms	- Mb
=> tvcmsproductcompare	0.577 ms	- Mb
=> tvcmsproductcompare	0.585 ms	- Mb
=> tvcmsproductcompare	0.584 ms	- Mb
=> tvcmsproductcompare	0.559 ms	- Mb
=> tvcmsproductcompare	0.586 ms	- Mb
=> tvcmsproductcompare	0.530 ms	- Mb
=> tvcmsproductcompare	0.644 ms	- Mb
=> tvcmsproductcompare	0.604 ms	- Mb
=> tvcmsproductcompare	0.561 ms	- Mb
=> tvcmsproductcompare	0.517 ms	- Mb
=> tvcmsproductcompare	0.576 ms	- Mb
=> tvcmsproductcompare	0.555 ms	- Mb
=> tvcmsproductcompare	0.568 ms	- Mb
=> tvcmsproductcompare	0.522 ms	- Mb
=> tvcmsproductcompare	0.572 ms	- Mb
=> tvcmsproductcompare	0.597 ms	- Mb
=> tvcmsproductcompare	0.565 ms	- Mb
=> tvcmsproductcompare	0.542 ms	- Mb
=> tvcmsproductcompare	0.581 ms	- Mb
displayLeftColumn	22.609 ms	1.96 Mb
=> ps_categorytree (widget)	18.666 ms	1.82 Mb
=> ps_brandlist (widget)	2.027 ms	0.07 Mb
=> ps_supplierlist (widget)	1.916 ms	0.07 Mb
DisplayProductListStockIndicator	10.865 ms	0.68 Mb
=> tvcmsstockinfo	0.830 ms	0.03 Mb
=> tvcmsstockinfo	0.287 ms	0.01 Mb
=> tvcmsstockinfo	0.575 ms	0.05 Mb
=> tvcmsstockinfo	0.645 ms	0.05 Mb
=> tvcmsstockinfo	0.334 ms	0.01 Mb
=> tvcmsstockinfo	0.285 ms	0.01 Mb
=> tvcmsstockinfo	0.582 ms	0.05 Mb
=> tvcmsstockinfo	0.562 ms	0.05 Mb
=> tvcmsstockinfo	0.316 ms	0.01 Mb
=> tvcmsstockinfo	0.290 ms	0.01 Mb
=> tvcmsstockinfo	0.538 ms	0.05 Mb
=> tvcmsstockinfo	0.548 ms	0.05 Mb
=> tvcmsstockinfo	0.304 ms	0.01 Mb
=> tvcmsstockinfo	0.278 ms	0.01 Mb
=> tvcmsstockinfo	0.572 ms	0.05 Mb
=> tvcmsstockinfo	0.580 ms	0.05 Mb
=> tvcmsstockinfo	0.287 ms	0.01 Mb
=> tvcmsstockinfo	0.290 ms	0.01 Mb
=> tvcmsstockinfo	0.573 ms	0.05 Mb
=> tvcmsstockinfo	0.527 ms	0.05 Mb
=> tvcmsstockinfo	0.284 ms	0.01 Mb
=> tvcmsstockinfo	0.278 ms	0.01 Mb
=> tvcmsstockinfo	0.548 ms	0.05 Mb
=> tvcmsstockinfo	0.552 ms	0.05 Mb
DisplayMegamenu	7.932 ms	0.68 Mb
=> tvcmsmegamenu	7.932 ms	0.68 Mb
DisplayNavSearchBlock	6.136 ms	1.48 Mb
=> tvcmssearch	6.136 ms	1.48 Mb
DisplayFooter	3.999 ms	0.14 Mb
=> blockwishlist	3.138 ms	0.13 Mb
=> ps_facebook	0.861 ms	0.01 Mb
Header	3.998 ms	0.11 Mb
=> tvcmsstockinfo	0.450 ms	- Mb
=> tvcmsinfinitescroll	2.371 ms	0.05 Mb
=> tvcmscategoryproduct	0.396 ms	0.02 Mb
=> tvcmsmegamenu	0.405 ms	0.02 Mb
=> tvcmstwoofferbanner	0.376 ms	0.02 Mb
DisplayCustomsocialblock	3.625 ms	0.16 Mb
=> tvcmscustomsetting	3.625 ms	0.16 Mb
DisplayBeforeBodyClosingTag	2.632 ms	0.16 Mb
=> statsdata	2.629 ms	0.16 Mb
=> tvcmsblog	0.003 ms	- Mb
ActionFrontControllerSetMedia	2.331 ms	0.01 Mb
=> blockreassurance	0.622 ms	- Mb
=> blockwishlist	0.562 ms	- Mb
=> ps_emailsubscription	0.145 ms	- Mb
=> ps_socialfollow	0.227 ms	- Mb
=> psxdesign	0.504 ms	- Mb
=> klaviyopsautomation	0.006 ms	- Mb
=> ps_emailalerts	0.111 ms	- Mb
=> monei	0.003 ms	- Mb
=> ps_facebook	0.151 ms	- Mb
displayFooterPart1	2.096 ms	0.09 Mb
=> ps_linklist (widget)	2.096 ms	0.09 Mb
displayMyaccountcblock	1.985 ms	0.09 Mb
=> ps_customeraccountlinks (widget)	1.985 ms	0.09 Mb
displayNewslettersubscription	1.955 ms	0.09 Mb
=> ps_emailsubscription (widget)	1.955 ms	0.09 Mb
displaySocialMediaBlock	1.883 ms	0.09 Mb
=> ps_socialfollow (widget)	1.883 ms	0.09 Mb
ProductSearchProvider	1.674 ms	0.03 Mb
=> ps_facetedsearch	1.674 ms	0.03 Mb
DisplayPaymentIcon	1.401 ms	0.04 Mb
=> tvcmspaymenticon	1.401 ms	0.04 Mb
DisplayNavWishlistBlock	1.204 ms	0.04 Mb
=> tvcmswishlist	1.204 ms	0.04 Mb
DisplayNavWishlistBlocksticky	1.188 ms	0.05 Mb
=> tvcmswishlist	1.188 ms	0.05 Mb
displayNavShoppingCartBlock	1.142 ms	0.09 Mb
=> ps_shoppingcart (widget)	1.142 ms	0.09 Mb
displayNav1	1.080 ms	0.09 Mb
=> ps_contactinfo (widget)	1.080 ms	0.09 Mb
DisplayDownloadApps	0.905 ms	0.02 Mb
=> tvcmscustomsetting	0.905 ms	0.02 Mb
displayContactCinfo	0.884 ms	0.03 Mb
=> ps_contactinfo (widget)	0.884 ms	0.03 Mb
DisplayNavProductCompareBlock	0.871 ms	0.01 Mb
=> tvcmsproductcompare	0.871 ms	0.01 Mb
displayNavCustomerSignInBlock	0.868 ms	0.05 Mb
=> ps_customersignin (widget)	0.868 ms	0.05 Mb
DisplayProductComparesticky	0.866 ms	0.01 Mb
=> tvcmsproductcompare	0.866 ms	0.01 Mb
DisplayAfterTitleTag	0.832 ms	0.01 Mb
=> psxdesign	0.832 ms	0.01 Mb
DisplayCopyRightText	0.811 ms	0.01 Mb
=> tvcmscustomsetting	0.811 ms	0.01 Mb
DisplayFacetedSearchBlock	0.568 ms	0.09 Mb
=> ps_facetedsearch	0.568 ms	0.09 Mb
ActionDispatcherBefore	0.544 ms	0.01 Mb
=> psxdesign	0.225 ms	- Mb
=> ps_mbo	0.319 ms	0.01 Mb
displayNavLanguageBlock	0.282 ms	0.05 Mb
=> ps_languageselector (widget)	0.282 ms	0.05 Mb
displayNavCurrencyBlock	0.267 ms	0.05 Mb
=> ps_currencyselector (widget)	0.267 ms	0.05 Mb
ModuleRoutes	0.019 ms	0.01 Mb
=> klaviyopsautomation	0.005 ms	- Mb
=> tvcmsblog	0.013 ms	0.01 Mb
=> simpleimportproduct	0.001 ms	- Mb
DisplayTopOfferText	0.013 ms	- Mb
=> tvcmscustomsetting	0.010 ms	- Mb
=> tvcmscustomsetting	0.003 ms	- Mb
DisplayCustomCss	0.006 ms	- Mb
=> tvcmscustomcssjs	0.006 ms	- Mb
DisplayCustomJs	0.006 ms	- Mb
=> tvcmscustomcssjs	0.006 ms	- Mb
DisplayNavFullWidth	0.005 ms	- Mb
=> blockreassurance	0.005 ms	- Mb
ActionFrontControllerInitAfter	0.003 ms	- Mb
=> klaviyopsautomation	0.003 ms	- Mb
42 hook(s)	564.659 ms	19.06 Mb

Module	Time	Memory Usage
klaviyopsautomation	1.439 ms	- Mb
__construct	1.420 ms	- Mb
hookModuleRoutes	0.008 ms	- Mb
hookActionFrontControllerInitAfter	0.005 ms	- Mb
hookActionFrontControllerSetMedia	0.006 ms	- Mb
tvcmsblog	5.233 ms	0.19 Mb
__construct	4.527 ms	0.18 Mb
hookModuleRoutes	0.015 ms	0.01 Mb
hookDisplayHeader	0.687 ms	- Mb
hookDisplayBeforeBodyClosingTag	0.004 ms	- Mb
simpleimportproduct	0.888 ms	0.03 Mb
__construct	0.885 ms	0.02 Mb
hookModuleRoutes	0.003 ms	- Mb
psxdesign	4.567 ms	0.03 Mb
__construct	3.000 ms	0.01 Mb
hookActionDispatcherBefore	0.227 ms	- Mb
hookActionFrontControllerSetMedia	0.505 ms	- Mb
hookDisplayAfterTitleTag	0.835 ms	0.01 Mb
ps_mbo	8.939 ms	0.05 Mb
__construct	8.618 ms	0.04 Mb
hookActionDispatcherBefore	0.321 ms	0.01 Mb
blockreassurance	1.307 ms	0.09 Mb
__construct	0.671 ms	0.08 Mb
hookActionFrontControllerSetMedia	0.624 ms	0.01 Mb
hookDisplayAfterBodyOpeningTag	0.005 ms	- Mb
hookDisplayNavFullWidth	0.007 ms	- Mb
blockwishlist	3.869 ms	0.14 Mb
__construct	0.165 ms	0.01 Mb
hookActionFrontControllerSetMedia	0.564 ms	- Mb
hookDisplayFooter	3.140 ms	0.13 Mb
ps_emailsubscription	2.218 ms	0.10 Mb
__construct	0.110 ms	0.01 Mb
hookActionFrontControllerSetMedia	0.146 ms	- Mb
displayNewslettersubscription	1.962 ms	0.09 Mb
ps_socialfollow	2.214 ms	0.10 Mb
__construct	0.101 ms	0.01 Mb
hookActionFrontControllerSetMedia	0.228 ms	- Mb
displaySocialMediaBlock	1.885 ms	0.09 Mb
ps_emailalerts	0.316 ms	0.01 Mb
__construct	0.204 ms	0.01 Mb
hookActionFrontControllerSetMedia	0.112 ms	- Mb
monei	0.799 ms	0.07 Mb
__construct	0.794 ms	0.06 Mb
hookActionFrontControllerSetMedia	0.005 ms	- Mb
ps_facebook	166.292 ms	0.46 Mb
__construct	2.359 ms	- Mb
hookActionFrontControllerSetMedia	0.153 ms	- Mb
hookDisplayHeader	162.917 ms	0.45 Mb
hookDisplayFooter	0.863 ms	0.01 Mb
ps_shoppingcart	1.331 ms	0.10 Mb
__construct	0.112 ms	0.01 Mb
hookDisplayHeader	0.075 ms	- Mb
displayNavShoppingCartBlock	1.144 ms	0.09 Mb
ps_searchbar	1.116 ms	0.01 Mb
__construct	0.177 ms	0.01 Mb
hookDisplayHeader	0.939 ms	- Mb
ps_imageslider	0.591 ms	0.01 Mb
__construct	0.176 ms	0.01 Mb
hookDisplayHeader	0.415 ms	- Mb
productcomments	0.573 ms	0.07 Mb
__construct	0.102 ms	0.07 Mb
hookDisplayHeader	0.471 ms	- Mb
psxmarketingwithgoogle	3.978 ms	0.01 Mb
__construct	0.390 ms	0.01 Mb
hookDisplayHeader	3.588 ms	0.01 Mb
ps_googleanalytics	1.784 ms	0.03 Mb
__construct	0.156 ms	0.01 Mb
hookDisplayHeader	1.628 ms	0.02 Mb
tvcmsbestsellerproducts	27.726 ms	1.68 Mb
__construct	0.440 ms	0.01 Mb
hookDisplayHeader	0.143 ms	- Mb
hookDisplayLeftColumn	27.143 ms	1.68 Mb
tvcmsblogdisplayposts	0.875 ms	0.01 Mb
__construct	0.436 ms	0.01 Mb
hookDisplayHeader	0.439 ms	- Mb
tvcmsbrandlist	0.776 ms	0.01 Mb
__construct	0.426 ms	0.01 Mb
hookDisplayHeader	0.350 ms	- Mb
tvcmscategorychainslider	0.810 ms	0.01 Mb
__construct	0.395 ms	0.01 Mb
hookDisplayHeader	0.415 ms	- Mb
tvcmscategoryslider	0.729 ms	0.01 Mb
__construct	0.394 ms	0.01 Mb
hookDisplayHeader	0.335 ms	- Mb
tvcmscookiesnotice	1.651 ms	0.03 Mb
__construct	0.400 ms	0.01 Mb
hookDisplayHeader	0.340 ms	- Mb
hookDisplayAfterBodyOpeningTag	0.911 ms	0.02 Mb
tvcmscustomerservices	1.683 ms	0.09 Mb
__construct	0.430 ms	0.01 Mb
hookDisplayHeader	0.413 ms	- Mb
hookDisplayLeftColumn	0.840 ms	0.08 Mb
tvcmscustomsetting	7.968 ms	0.22 Mb
__construct	0.503 ms	0.01 Mb
hookDisplayHeader	2.102 ms	0.01 Mb
hookDisplayTopOfferText	0.012 ms	- Mb
hookDisplayTopOfferText	0.005 ms	- Mb
hookDisplayDownloadApps	0.907 ms	0.02 Mb
hookDisplayCustomsocialblock	3.626 ms	0.16 Mb
hookDisplayCopyRightText	0.813 ms	0.01 Mb
tvcmsfeaturedproducts	48.342 ms	2.73 Mb
__construct	0.356 ms	0.01 Mb
hookDisplayHeader	0.134 ms	- Mb
hookDisplayLeftColumn	47.852 ms	2.72 Mb
tvcmsfooterlogo	0.406 ms	0.01 Mb
__construct	0.404 ms	0.01 Mb
hookDisplayHeader	0.002 ms	- Mb
tvcmsfooterproduct	0.481 ms	0.01 Mb
__construct	0.347 ms	0.01 Mb
hookDisplayHeader	0.134 ms	- Mb
tvcmsnewproducts	41.305 ms	0.90 Mb
__construct	0.373 ms	0.01 Mb
hookDisplayHeader	0.133 ms	- Mb
hookDisplayLeftColumn	40.799 ms	0.89 Mb
tvcmsnewsletterpopup	1.060 ms	0.01 Mb
__construct	0.382 ms	0.01 Mb
hookDisplayHeader	0.678 ms	- Mb
tvcmspaymenticon	1.809 ms	0.05 Mb
__construct	0.403 ms	0.01 Mb
hookDisplayHeader	0.003 ms	- Mb
hookDisplayPaymentIcon	1.403 ms	0.04 Mb
tvcmsproductcomments	52.441 ms	3.80 Mb
__construct	0.379 ms	0.01 Mb
hookDisplayHeader	1.268 ms	- Mb
hookDisplayReviewProductList	1.559 ms	0.12 Mb
hookDisplayReviewProductList	1.155 ms	0.07 Mb
hookDisplayReviewProductList	1.013 ms	0.07 Mb
hookDisplayReviewProductList	0.958 ms	0.07 Mb
hookDisplayReviewProductList	1.203 ms	0.11 Mb
hookDisplayReviewProductList	1.065 ms	0.07 Mb
hookDisplayReviewProductList	1.012 ms	0.07 Mb
hookDisplayReviewProductList	0.931 ms	0.06 Mb
hookDisplayReviewProductList	1.100 ms	0.11 Mb
hookDisplayReviewProductList	1.215 ms	0.07 Mb
hookDisplayReviewProductList	0.993 ms	0.07 Mb
hookDisplayReviewProductList	0.977 ms	0.06 Mb
hookDisplayReviewProductList	1.216 ms	0.11 Mb
hookDisplayReviewProductList	1.015 ms	0.07 Mb
hookDisplayReviewProductList	0.984 ms	0.07 Mb
hookDisplayReviewProductList	0.927 ms	0.06 Mb
hookDisplayReviewProductList	1.241 ms	0.11 Mb
hookDisplayReviewProductList	1.036 ms	0.07 Mb
hookDisplayReviewProductList	1.066 ms	0.07 Mb
hookDisplayReviewProductList	0.972 ms	0.06 Mb
hookDisplayReviewProductList	1.244 ms	0.11 Mb
hookDisplayReviewProductList	0.991 ms	0.07 Mb
hookDisplayReviewProductList	0.970 ms	0.07 Mb
hookDisplayReviewProductList	0.955 ms	0.06 Mb
hookDisplayReviewProductList	1.161 ms	0.14 Mb
hookDisplayReviewProductList	0.971 ms	0.07 Mb
hookDisplayReviewProductList	0.965 ms	0.07 Mb
hookDisplayReviewProductList	0.976 ms	0.06 Mb
hookDisplayReviewProductList	1.161 ms	0.11 Mb
hookDisplayReviewProductList	0.954 ms	0.07 Mb
hookDisplayReviewProductList	0.970 ms	0.07 Mb
hookDisplayReviewProductList	0.961 ms	0.06 Mb
hookDisplayReviewProductList	1.186 ms	0.11 Mb
hookDisplayReviewProductList	1.041 ms	0.07 Mb
hookDisplayReviewProductList	1.037 ms	0.07 Mb
hookDisplayReviewProductList	1.208 ms	0.06 Mb
hookDisplayReviewProductList	1.196 ms	0.11 Mb
hookDisplayReviewProductList	0.970 ms	0.07 Mb
hookDisplayReviewProductList	0.960 ms	0.07 Mb
hookDisplayReviewProductList	0.906 ms	0.06 Mb
hookDisplayReviewProductList	1.315 ms	0.11 Mb
hookDisplayReviewProductList	0.994 ms	0.07 Mb
hookDisplayReviewProductList	0.968 ms	0.07 Mb
hookDisplayReviewProductList	0.937 ms	0.06 Mb
hookDisplayReviewProductList	1.191 ms	0.11 Mb
hookDisplayReviewProductList	1.002 ms	0.07 Mb
hookDisplayReviewProductList	0.989 ms	0.07 Mb
hookDisplayReviewProductList	0.979 ms	0.06 Mb
tvcmsproductcompare	30.099 ms	0.14 Mb
__construct	0.315 ms	0.01 Mb
hookDisplayHeader	0.349 ms	- Mb
hookDisplayNavProductCompareBlock	0.873 ms	0.01 Mb
hookDisplayProductCompareProductList	0.876 ms	0.01 Mb
hookDisplayProductCompareProductList	0.567 ms	- Mb
hookDisplayProductCompareProductList	0.583 ms	- Mb
hookDisplayProductCompareProductList	0.592 ms	- Mb
hookDisplayProductCompareProductList	0.599 ms	- Mb
hookDisplayProductCompareProductList	0.578 ms	- Mb
hookDisplayProductCompareProductList	0.549 ms	- Mb
hookDisplayProductCompareProductList	0.568 ms	- Mb
hookDisplayProductCompareProductList	0.577 ms	- Mb
hookDisplayProductCompareProductList	0.561 ms	- Mb
hookDisplayProductCompareProductList	0.522 ms	- Mb
hookDisplayProductCompareProductList	0.597 ms	- Mb
hookDisplayProductCompareProductList	0.613 ms	- Mb
hookDisplayProductCompareProductList	0.567 ms	- Mb
hookDisplayProductCompareProductList	0.517 ms	- Mb
hookDisplayProductCompareProductList	0.560 ms	- Mb
hookDisplayProductCompareProductList	0.592 ms	- Mb
hookDisplayProductCompareProductList	0.569 ms	- Mb
hookDisplayProductCompareProductList	0.521 ms	- Mb
hookDisplayProductCompareProductList	0.581 ms	- Mb
hookDisplayProductCompareProductList	0.597 ms	- Mb
hookDisplayProductCompareProductList	0.583 ms	- Mb
hookDisplayProductCompareProductList	0.533 ms	- Mb
hookDisplayProductCompareProductList	0.606 ms	- Mb
hookDisplayProductCompareProductList	0.562 ms	- Mb
hookDisplayProductCompareProductList	0.574 ms	- Mb
hookDisplayProductCompareProductList	0.509 ms	- Mb
hookDisplayProductCompareProductList	0.596 ms	- Mb
hookDisplayProductCompareProductList	0.583 ms	- Mb
hookDisplayProductCompareProductList	0.579 ms	- Mb
hookDisplayProductCompareProductList	0.587 ms	- Mb
hookDisplayProductCompareProductList	0.586 ms	- Mb
hookDisplayProductCompareProductList	0.561 ms	- Mb
hookDisplayProductCompareProductList	0.588 ms	- Mb
hookDisplayProductCompareProductList	0.532 ms	- Mb
hookDisplayProductCompareProductList	0.646 ms	- Mb
hookDisplayProductCompareProductList	0.606 ms	- Mb
hookDisplayProductCompareProductList	0.563 ms	- Mb
hookDisplayProductCompareProductList	0.519 ms	- Mb
hookDisplayProductCompareProductList	0.578 ms	- Mb
hookDisplayProductCompareProductList	0.557 ms	- Mb
hookDisplayProductCompareProductList	0.570 ms	- Mb
hookDisplayProductCompareProductList	0.524 ms	- Mb
hookDisplayProductCompareProductList	0.574 ms	- Mb
hookDisplayProductCompareProductList	0.599 ms	- Mb
hookDisplayProductCompareProductList	0.566 ms	- Mb
hookDisplayProductCompareProductList	0.544 ms	- Mb
hookDisplayProductCompareProductList	0.583 ms	- Mb
hookDisplayProductComparesticky	0.868 ms	0.01 Mb
tvcmsproductpopup	67.082 ms	2.77 Mb
__construct	0.096 ms	0.01 Mb
hookDisplayHeader	0.330 ms	- Mb
hookDisplayAfterBodyOpeningTag	66.656 ms	2.76 Mb
tvcmssearch	7.414 ms	1.49 Mb
__construct	0.343 ms	0.01 Mb
hookDisplayHeader	0.933 ms	- Mb
hookDisplayNavSearchBlock	6.138 ms	1.48 Mb
tvcmssizechart	0.688 ms	0.01 Mb
__construct	0.354 ms	0.01 Mb
hookDisplayHeader	0.334 ms	- Mb
tvcmsslider	0.748 ms	0.01 Mb
__construct	0.413 ms	0.01 Mb
hookDisplayHeader	0.335 ms	- Mb
tvcmsspecialproducts	2.350 ms	0.11 Mb
__construct	0.358 ms	0.01 Mb
hookDisplayHeader	0.137 ms	- Mb
hookDisplayLeftColumn	1.855 ms	0.10 Mb
tvcmsstockinfo	11.676 ms	0.70 Mb
__construct	0.313 ms	0.01 Mb
hookHeader	0.452 ms	- Mb
hookDisplayProductListStockIndicator	0.832 ms	0.03 Mb
hookDisplayProductListStockIndicator	0.289 ms	0.01 Mb
hookDisplayProductListStockIndicator	0.577 ms	0.05 Mb
hookDisplayProductListStockIndicator	0.647 ms	0.05 Mb
hookDisplayProductListStockIndicator	0.336 ms	0.01 Mb
hookDisplayProductListStockIndicator	0.287 ms	0.01 Mb
hookDisplayProductListStockIndicator	0.583 ms	0.05 Mb
hookDisplayProductListStockIndicator	0.564 ms	0.05 Mb
hookDisplayProductListStockIndicator	0.318 ms	0.01 Mb
hookDisplayProductListStockIndicator	0.291 ms	0.01 Mb
hookDisplayProductListStockIndicator	0.540 ms	0.05 Mb
hookDisplayProductListStockIndicator	0.550 ms	0.05 Mb
hookDisplayProductListStockIndicator	0.306 ms	0.01 Mb
hookDisplayProductListStockIndicator	0.280 ms	0.01 Mb
hookDisplayProductListStockIndicator	0.574 ms	0.05 Mb
hookDisplayProductListStockIndicator	0.582 ms	0.05 Mb
hookDisplayProductListStockIndicator	0.289 ms	0.01 Mb
hookDisplayProductListStockIndicator	0.292 ms	0.01 Mb
hookDisplayProductListStockIndicator	0.576 ms	0.05 Mb
hookDisplayProductListStockIndicator	0.529 ms	0.05 Mb
hookDisplayProductListStockIndicator	0.285 ms	0.01 Mb
hookDisplayProductListStockIndicator	0.280 ms	0.01 Mb
hookDisplayProductListStockIndicator	0.550 ms	0.05 Mb
hookDisplayProductListStockIndicator	0.554 ms	0.05 Mb
tvcmsstoretime	0.683 ms	0.01 Mb
__construct	0.350 ms	- Mb
hookDisplayHeader	0.333 ms	- Mb
tvcmstabproducts	0.680 ms	0.01 Mb
__construct	0.319 ms	0.01 Mb
hookDisplayHeader	0.361 ms	- Mb
tvcmstestimonial	0.748 ms	0.01 Mb
__construct	0.389 ms	0.01 Mb
hookDisplayHeader	0.359 ms	- Mb
tvcmsthemeoptions	1.379 ms	0.01 Mb
__construct	0.349 ms	0.01 Mb
hookDisplayHeader	1.030 ms	- Mb
tvcmsvideoblock	0.739 ms	0.01 Mb
__construct	0.404 ms	0.01 Mb
hookDisplayHeader	0.335 ms	- Mb
tvcmswishlist	32.399 ms	0.10 Mb
__construct	0.338 ms	0.01 Mb
hookDisplayHeader	0.372 ms	- Mb
hookDisplayNavWishlistBlock	1.206 ms	0.04 Mb
hookDisplayWishlistBtnProductList	0.841 ms	0.01 Mb
hookDisplayWishlistBtnProductList	0.618 ms	- Mb
hookDisplayWishlistBtnProductList	0.605 ms	- Mb
hookDisplayWishlistBtnProductList	0.596 ms	- Mb
hookDisplayWishlistBtnProductList	0.619 ms	- Mb
hookDisplayWishlistBtnProductList	0.766 ms	- Mb
hookDisplayWishlistBtnProductList	0.610 ms	- Mb
hookDisplayWishlistBtnProductList	0.600 ms	- Mb
hookDisplayWishlistBtnProductList	0.576 ms	- Mb
hookDisplayWishlistBtnProductList	0.597 ms	- Mb
hookDisplayWishlistBtnProductList	0.633 ms	- Mb
hookDisplayWishlistBtnProductList	0.597 ms	- Mb
hookDisplayWishlistBtnProductList	0.689 ms	- Mb
hookDisplayWishlistBtnProductList	0.631 ms	- Mb
hookDisplayWishlistBtnProductList	0.595 ms	- Mb
hookDisplayWishlistBtnProductList	0.629 ms	- Mb
hookDisplayWishlistBtnProductList	0.580 ms	- Mb
hookDisplayWishlistBtnProductList	0.591 ms	- Mb
hookDisplayWishlistBtnProductList	0.595 ms	- Mb
hookDisplayWishlistBtnProductList	0.610 ms	- Mb
hookDisplayWishlistBtnProductList	0.664 ms	- Mb
hookDisplayWishlistBtnProductList	0.591 ms	- Mb
hookDisplayWishlistBtnProductList	0.575 ms	- Mb
hookDisplayWishlistBtnProductList	0.581 ms	- Mb
hookDisplayWishlistBtnProductList	0.590 ms	- Mb
hookDisplayWishlistBtnProductList	0.575 ms	- Mb
hookDisplayWishlistBtnProductList	0.589 ms	- Mb
hookDisplayWishlistBtnProductList	0.581 ms	- Mb
hookDisplayWishlistBtnProductList	0.597 ms	- Mb
hookDisplayWishlistBtnProductList	0.575 ms	- Mb
hookDisplayWishlistBtnProductList	0.637 ms	- Mb
hookDisplayWishlistBtnProductList	0.580 ms	- Mb
hookDisplayWishlistBtnProductList	0.593 ms	- Mb
hookDisplayWishlistBtnProductList	0.604 ms	- Mb
hookDisplayWishlistBtnProductList	0.617 ms	- Mb
hookDisplayWishlistBtnProductList	0.583 ms	- Mb
hookDisplayWishlistBtnProductList	0.585 ms	- Mb
hookDisplayWishlistBtnProductList	0.594 ms	- Mb
hookDisplayWishlistBtnProductList	0.595 ms	- Mb
hookDisplayWishlistBtnProductList	0.591 ms	- Mb
hookDisplayWishlistBtnProductList	0.587 ms	- Mb
hookDisplayWishlistBtnProductList	0.596 ms	- Mb
hookDisplayWishlistBtnProductList	0.590 ms	- Mb
hookDisplayWishlistBtnProductList	0.575 ms	- Mb
hookDisplayWishlistBtnProductList	0.604 ms	- Mb
hookDisplayWishlistBtnProductList	0.597 ms	- Mb
hookDisplayWishlistBtnProductList	0.690 ms	- Mb
hookDisplayWishlistBtnProductList	0.580 ms	- Mb
hookDisplayNavWishlistBlocksticky	1.190 ms	0.05 Mb
smartargetwhatsapp	1.198 ms	0.01 Mb
__construct	0.350 ms	0.01 Mb
hookDisplayHeader	0.848 ms	0.01 Mb
ps_accounts	0.667 ms	- Mb
__construct	0.667 ms	- Mb
tvcmsinfinitescroll	2.774 ms	0.06 Mb
__construct	0.400 ms	0.01 Mb
hookHeader	2.374 ms	0.05 Mb
tvcmscategoryproduct	0.906 ms	0.03 Mb
__construct	0.508 ms	0.01 Mb
hookHeader	0.398 ms	0.02 Mb
tvcmsmegamenu	8.809 ms	0.71 Mb
__construct	0.468 ms	0.01 Mb
hookHeader	0.407 ms	0.02 Mb
hookDisplayMegamenu	7.934 ms	0.68 Mb
tvcmstwoofferbanner	0.745 ms	0.02 Mb
__construct	0.368 ms	- Mb
hookHeader	0.377 ms	0.02 Mb
ps_facetedsearch	3.819 ms	0.13 Mb
__construct	1.573 ms	0.01 Mb
hookProductSearchProvider	1.676 ms	0.03 Mb
hookDisplayFacetedSearchBlock	0.570 ms	0.09 Mb
tvcmscustomcssjs	0.421 ms	0.01 Mb
__construct	0.406 ms	0.01 Mb
hookDisplayCustomCss	0.008 ms	- Mb
hookDisplayCustomJs	0.007 ms	- Mb
ps_customersignin	1.012 ms	0.06 Mb
__construct	0.142 ms	0.01 Mb
displayNavCustomerSignInBlock	0.870 ms	0.05 Mb
ps_languageselector	0.396 ms	0.06 Mb
__construct	0.112 ms	0.01 Mb
displayNavLanguageBlock	0.284 ms	0.05 Mb
ps_currencyselector	0.385 ms	0.06 Mb
__construct	0.116 ms	0.01 Mb
displayNavCurrencyBlock	0.269 ms	0.05 Mb
ps_contactinfo	2.078 ms	0.12 Mb
__construct	0.110 ms	0.01 Mb
displayNav1	1.082 ms	0.09 Mb
displayContactCinfo	0.886 ms	0.03 Mb
ps_categorytree	18.779 ms	1.82 Mb
__construct	0.111 ms	0.01 Mb
displayLeftColumn	18.668 ms	1.82 Mb
ps_brandlist	2.205 ms	0.08 Mb
__construct	0.175 ms	0.01 Mb
displayLeftColumn	2.030 ms	0.07 Mb
ps_supplierlist	2.033 ms	0.08 Mb
__construct	0.115 ms	0.01 Mb
displayLeftColumn	1.918 ms	0.07 Mb
ps_linklist	2.692 ms	0.09 Mb
__construct	0.594 ms	0.01 Mb
displayFooterPart1	2.098 ms	0.09 Mb
ps_customeraccountlinks	2.109 ms	0.09 Mb
__construct	0.122 ms	0.01 Mb
displayMyaccountcblock	1.987 ms	0.09 Mb
statsdata	2.743 ms	0.17 Mb
__construct	0.112 ms	0.01 Mb
hookDisplayBeforeBodyClosingTag	2.631 ms	0.17 Mb
64 module(s)	605.972 ms	19.99 Mb

281 queries	SELECT * FROM `ps_category` a LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = XX LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = XX WHERE (a.`id_category` = XX) AND (b.`id_shop` = XX) LIMIT XX
54 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
34 queries	SELECT COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), XX) as deep_quantity, COALESCE(SUM(first_level_quantity), XX) as quantity FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, XX as pack_quantity FROM `ps_cart_product` cp WHERE cp.`id_product_attribute` = XX AND cp.`id_cart` = XX AND cp.`id_product` = XX UNION SELECT XX as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity FROM `ps_cart_product` cp JOIN `ps_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `ps_product` pr ON p.`id_product_pack` = pr.`id_product` WHERE cp.`id_product_attribute` = XX AND cp.`id_cart` = XX AND p.`id_product_item` = XX AND (pr.`pack_stock_type` IN (XX,XX) OR ( pr.`pack_stock_type` = XX AND XX = XX ))) as q LIMIT XX
28 queries	SELECT image_shop.`cover`, i.`id_image`, il.`legend`, i.`position` FROM `ps_image` i INNER JOIN ps_image_shop image_shop ON (image_shop.id_image = i.id_image AND image_shop.id_shop = XX) LEFT JOIN `ps_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = XX) WHERE i.`id_product` = XX ORDER BY `position`
25 queries	SELECT XX FROM `ps_specific_price` WHERE id_product = XX LIMIT XX
24 queries	SELECT image_shop.`id_image` FROM `ps_image` i INNER JOIN ps_image_shop image_shop ON (image_shop.id_image = i.id_image AND image_shop.id_shop = XX) WHERE i.`id_product` = XX AND image_shop.`cover` = XX LIMIT XX
24 queries	SELECT name FROM ps_category_lang WHERE id_shop = XX AND id_lang = XX AND id_category = XX LIMIT XX
24 queries	SELECT * FROM `ps_product` a LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = XX LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = XX WHERE (a.`id_product` = XX) AND (b.`id_shop` = XX) LIMIT XX
24 queries	SELECT product_shop.`price`, product_shop.`ecotax`, IFNULL(product_attribute_shop.id_product_attribute,XX) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on, product_attribute_shop.`ecotax` AS attribute_ecotax FROM `ps_product` p INNER JOIN `ps_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = XX) LEFT JOIN `ps_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = XX) WHERE (p.`id_product` = XX)
24 queries	SELECT `id_tax_rules_group` FROM `ps_product_shop` WHERE `id_product` = XX AND id_shop=XX LIMIT XX
24 queries	SELECT `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = XX AND `id_group` = XX LIMIT XX
24 queries	SELECT COUNT(*) FROM `ps_pack` WHERE id_product_pack = XX LIMIT XX
24 queries	SELECT product_type FROM `ps_product` WHERE id_product = XX LIMIT XX
24 queries	SELECT name, value, pf.id_feature, f.position, fvl.id_feature_value FROM ps_feature_product pf LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = XX) LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = XX) LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = XX) INNER JOIN ps_feature_shop feature_shop ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = XX) WHERE pf.id_product = XX ORDER BY f.position ASC
22 queries	SELECT `id_product_attribute` FROM `ps_product_attribute` WHERE `id_product` = XX
18 queries	SELECT `id_module` FROM `ps_module_shop` WHERE `id_module` = XX AND `id_shop` = XX LIMIT XX
16 queries	SELECT p., ps., pl.*, sa.out_of_stock, IFNULL(sa.quantity, XX) as quantity, (DATEDIFF( p.`date_add`, DATE_SUB( 'XX-XX-XX XX:XX:XX', INTERVAL XX DAY ) ) > XX) as new FROM ps_product p LEFT JOIN ps_product_lang pl ON pl.id_product = p.id_product AND pl.id_shop = XX AND pl.id_lang = XX LEFT JOIN ps_stock_available sa ON sa.id_product = p.id_product AND sa.id_product_attribute = XX AND sa.id_shop = XX LEFT JOIN ps_product_shop ps ON ps.id_product = p.id_product AND ps.id_shop = XX WHERE p.id_product IN (XX)
12 queries	SELECT COUNT(`id_tvcmsproduct_comment`) AS "nbr" FROM `ps_tvcmsproduct_comment` pc WHERE `id_product` = XX AND `validate` = XX LIMIT XX
12 queries	select count(pa.`id_product_attribute`) as `total` from `ps_product_attribute` pa inner join `ps_product_attribute_shop` pas on pa.id_product_attribute = pas.id_product_attribute where pas.`id_shop` = XX and pa.`id_product` = XX LIMIT XX
10 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
10 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
10 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
10 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
10 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
10 queries	SELECT * FROM `ps_product_attribute_lang` WHERE `id_product_attribute` = 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
8 queries	SELECT c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop` FROM `ps_category` c LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = XX ) INNER JOIN ps_category_shop category_shop ON (category_shop.id_category = c.id_category AND category_shop.id_shop = XX) WHERE `id_lang` = XX AND c.`id_parent` = XX AND `active` = XX GROUP BY c.`id_category` ORDER BY category_shop.`position` ASC
8 queries	SELECT cg.`id_group` FROM `ps_category_group` cg WHERE (cg.`id_category` = XX)
6 queries	SELECT m.`id_module`, m.`name`, ms.`id_module`as `mshop` FROM `ps_module` m LEFT JOIN `ps_module_shop` ms ON m.`id_module` = ms.`id_module` AND ms.`id_shop` = XX
6 queries	SELECT * FROM `ps_product` a LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = XX WHERE (a.`id_product` = XX) LIMIT XX
6 queries	SELECT * FROM `ps_product_lang` WHERE `id_product` = XX AND `id_shop` = XX
6 queries	SELECT pa., product_attribute_shop. FROM `ps_product_attribute` pa INNER JOIN ps_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = XX) WHERE pa.`id_product` = XX GROUP BY pa.`id_product_attribute` ORDER BY pa.`id_product_attribute`
5 queries	SELECT quantity, reserved_quantity FROM `ps_stock_available` WHERE (id_product = XX) AND (id_product_attribute = XX) AND (id_shop = XX) AND (id_shop_group = XX) LIMIT XX
4 queries	SELECT DISTINCT a.`id_attribute`, a.`color`, al.`name`, agl.`id_attribute_group`, IF(lialv.`url_name` IS NULL OR lialv.`url_name` = "", NULL, lialv.`url_name`) AS url_name, IF(lialv.`meta_title` IS NULL OR lialv.`meta_title` = "", NULL, lialv.`meta_title`) AS meta_title FROM `ps_attribute_group` ag INNER JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = XX) INNER JOIN `ps_attribute` a ON a.`id_attribute_group` = ag.`id_attribute_group` INNER JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = XX) INNER JOIN ps_attribute_group_shop attribute_group_shop ON (attribute_group_shop.id_attribute_group = ag.id_attribute_group AND attribute_group_shop.id_shop = XX) INNER JOIN ps_attribute_shop attribute_shop ON (attribute_shop.id_attribute = a.id_attribute AND attribute_shop.id_shop = XX) LEFT JOIN `ps_layered_indexable_attribute_lang_value` lialv ON (a.`id_attribute` = lialv.`id_attribute` AND lialv.`id_lang` = XX) WHERE ag.id_attribute_group = XX ORDER BY agl.`name` ASC, a.`position` ASC
4 queries	SELECT pac.id_attribute, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM ps_product p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, XX) = sa.id_product_attribute AND sa.id_shop = XX AND sa.id_shop_group = XX ) LEFT JOIN ps_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = XX AND ps.active = TRUE) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=XX) LEFT JOIN ps_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='XX' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='XX' AND cp.id_category IN (XX, XX, XX, XX, XX, XX, XX) GROUP BY p.id_product) p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) INNER JOIN ps_attribute a ON (a.id_attribute = pac.id_attribute) WHERE ((a.id_attribute_group=XX)) GROUP BY pac.id_attribute
4 queries	SELECT tr.* FROM `ps_tax_rule` tr JOIN `ps_tax_rules_group` trg ON (tr.`id_tax_rules_group` = trg.`id_tax_rules_group`) WHERE trg.`active` = XX AND tr.`id_country` = XX AND tr.`id_tax_rules_group` = XX AND tr.`id_state` IN (XX, XX) AND ('XX' BETWEEN tr.`zipcode_from` AND tr.`zipcode_to` OR (tr.`zipcode_to` = XX AND tr.`zipcode_from` IN(XX, 'XX'))) ORDER BY tr.`zipcode_from` DESC, tr.`zipcode_to` DESC, tr.`id_state` DESC, tr.`id_country` DESC
4 queries	SELECT mr.* FROM ps_tvcmsmegamenu_row_shop mr WHERE mr.`id_shop` = XX AND mr.id_tvcmsmegamenu = XX AND mr.`active` = XX
3 queries	SELECT `need_identification_number` FROM `ps_country` WHERE `id_country` = XX LIMIT XX
3 queries	SELECT pai.`id_image`, pai.`id_product_attribute`, il.`legend` FROM `ps_product_attribute_image` pai LEFT JOIN `ps_image_lang` il ON (il.`id_image` = pai.`id_image`) LEFT JOIN `ps_image` i ON (i.`id_image` = pai.`id_image`) WHERE pai.`id_product_attribute` IN (XX, XX, XX, XX, XX, XX, XX, XX) AND il.`id_lang` = XX ORDER by i.`position`
2 queries	SELECT `active` FROM `ps_module` WHERE `name` = "ps_mbo" LIMIT XX
2 queries	SELECT m.`id_module` as `active`, ms.`id_module` as `shop_active` FROM `ps_module` m LEFT JOIN `ps_module_shop` ms ON m.`id_module` = ms.`id_module` WHERE `name` = "ps_mbo" LIMIT XX
2 queries	SELECT `id_lang` FROM `ps_lang` WHERE `locale` = 'es-es' OR `language_code` = 'es-es' LIMIT XX
2 queries	SELECT `id_category` FROM `ps_category_shop` WHERE `id_category` = XX AND `id_shop` = XX LIMIT XX
2 queries	SELECT ctg.`id_group` FROM ps_category_group ctg WHERE ctg.`id_category` = XX AND ctg.`id_group` = XX LIMIT XX
2 queries	SELECT * FROM `ps_category` aXX LEFT JOIN `ps_category_lang` `aXX` ON (aXX.`id_category` = aXX.`id_category`) WHERE (aXX.`nleft` < XX) AND (aXX.`nright` > XX) AND (aXX.`id_lang` = XX) AND (aXX.`id_shop` = XX) ORDER BY aXX.`nleft` asc
2 queries	SELECT fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM ps_product p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, XX) = sa.id_product_attribute AND sa.id_shop = XX AND sa.id_shop_group = XX ) LEFT JOIN ps_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = XX AND ps.active = TRUE) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=XX) LEFT JOIN ps_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='XX' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='XX' AND cp.id_category IN (XX, XX, XX, XX, XX, XX, XX) GROUP BY p.id_product) p INNER JOIN ps_feature_product fp ON (p.id_product = fp.id_product) WHERE ((fp.id_feature=XX)) GROUP BY fp.id_feature_value
2 queries	SELECT pai.`id_image`, pai.`id_product_attribute`, il.`legend` FROM `ps_product_attribute_image` pai LEFT JOIN `ps_image_lang` il ON (il.`id_image` = pai.`id_image`) LEFT JOIN `ps_image` i ON (i.`id_image` = pai.`id_image`) WHERE pai.`id_product_attribute` IN (XX, XX) AND il.`id_lang` = XX ORDER by i.`position`
2 queries	SELECT pai.`id_image`, pai.`id_product_attribute`, il.`legend` FROM `ps_product_attribute_image` pai LEFT JOIN `ps_image_lang` il ON (il.`id_image` = pai.`id_image`) LEFT JOIN `ps_image` i ON (i.`id_image` = pai.`id_image`) WHERE pai.`id_product_attribute` IN (XX, XX, XX) AND il.`id_lang` = XX ORDER by i.`position`
2 queries	SELECT XX FROM `ps_cart_rule` WHERE ((date_to >= "XX-XX-XX XX:XX:XX" AND date_to <= "XX-XX-XX XX:XX:XX") OR (date_from >= "XX-XX-XX XX:XX:XX" AND date_from <= "XX-XX-XX XX:XX:XX") OR (date_from < "XX-XX-XX XX:XX:XX" AND date_to > "XX-XX-XX XX:XX:XX")) AND `id_customer` IN (XX,XX) LIMIT XX
2 queries	SELECT UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache` WHERE `template_hash`=XX AND cache_id="module:tvcmsproductpopup/views/templates/hook/tvcmsproductpopup_footer\|XX\|XX\|XX\|XX" AND compile_id="vXX_giftoo_XX" LIMIT XX
2 queries	SELECT p., product_shop., stock.out_of_stock, IFNULL(stock.quantity, XX) as quantity, pl.`description`, pl.`description_short`, pl.`link_rewrite`, pl.`meta_description`, pl.`meta_keywords`, pl.`meta_title`, pl.`name`, pl.`available_now`, pl.`available_later`, image_shop.`id_image` id_image, il.`legend`, m.`name` AS manufacturer_name, (DATEDIFF(product_shop.`date_add`, DATE_SUB( "XX-XX-XX XX:XX:XX", INTERVAL XX DAY ) ) > XX) as new, product_attribute_shop.minimal_quantity AS product_attribute_minimal_quantity, IFNULL(product_attribute_shop.id_product_attribute,XX) id_product_attribute FROM `ps_product` p INNER JOIN ps_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = XX) LEFT JOIN `ps_product_lang` `pl` ON p.`id_product` = pl.`id_product` AND pl.`id_lang` = XX AND pl.id_shop = XX LEFT JOIN `ps_image_shop` `image_shop` ON image_shop.`id_product` = p.`id_product` AND image_shop.cover=XX AND image_shop.id_shop=XX LEFT JOIN `ps_image_lang` `il` ON image_shop.`id_image` = il.`id_image` AND il.`id_lang` = XX LEFT JOIN `ps_manufacturer` `m` ON m.`id_manufacturer` = p.`id_manufacturer` LEFT JOIN `ps_product_attribute_shop` `product_attribute_shop` ON p.`id_product` = product_attribute_shop.`id_product` AND product_attribute_shop.`default_on` = XX AND product_attribute_shop.id_shop=XX LEFT JOIN ps_stock_available stock ON (stock.id_product = `p`.id_product AND stock.id_product_attribute = XX AND stock.id_shop = XX AND stock.id_shop_group = XX ) WHERE (product_shop.`active` = XX) AND (product_shop.`visibility` IN ("both", "catalog")) AND (DATEDIFF(product_shop.`date_add`, DATE_SUB( "XX-XX-XX XX:XX:XX", INTERVAL XX DAY ) ) > XX) AND (EXISTS(SELECT XX FROM `ps_category_product` cp JOIN `ps_category_group` cg ON (cp.id_category = cg.id_category AND cg.`id_group` =XX) WHERE cp.`id_product` = p.`id_product`)) ORDER BY product_shop.`date_add` DESC LIMIT XX
2 queries	SELECT count(id_wishlist_product) FROM ps_wishlist w, ps_wishlist_product wp where w.id_wishlist = wp.id_wishlist and w.id_customer=XX LIMIT XX
2 queries	SELECT pac.id_product_attribute, GROUP_CONCAT(agl.`name`, ' - ',al.`name` ORDER BY agl.`id_attribute_group` SEPARATOR ', ') as attribute_designation FROM `ps_product_attribute_combination` pac LEFT JOIN `ps_attribute` a ON a.`id_attribute` = pac.`id_attribute` LEFT JOIN `ps_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group` LEFT JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = XX) LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = XX) WHERE pac.id_product_attribute IN (XX,XX) GROUP BY pac.id_product_attribute ORDER BY pac.id_product_attribute

#	Query	Time (ms)	Rows	Filesort	Group By	Location
367	SELECT SQL_NO_CACHE cp.id_category, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM ps_product p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN ps_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' GROUP BY p.id_product) p INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_category_group cg ON (cg.id_category = c.id_category) WHERE cg.id_group='1' AND c.level_depth<=2 AND c.nleft>2 AND c.nright<1457 GROUP BY cp.id_category	628.413 ms	157464			/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)
631	SELECT SQL_NO_CACHE p., product_shop., stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, pl.`description`, pl.`description_short`, pl.`link_rewrite`, pl.`meta_description`, pl.`meta_keywords`, pl.`meta_title`, pl.`name`, pl.`available_now`, pl.`available_later`, image_shop.`id_image` id_image, il.`legend`, m.`name` AS manufacturer_name, (DATEDIFF(product_shop.`date_add`, DATE_SUB( "2025-07-31 00:00:00", INTERVAL 1000 DAY ) ) > 0) as new, product_attribute_shop.minimal_quantity AS product_attribute_minimal_quantity, IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute FROM `ps_product` p INNER JOIN ps_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) LEFT JOIN `ps_product_lang` `pl` ON p.`id_product` = pl.`id_product` AND pl.`id_lang` = 1 AND pl.id_shop = 1 LEFT JOIN `ps_image_shop` `image_shop` ON image_shop.`id_product` = p.`id_product` AND image_shop.cover=1 AND image_shop.id_shop=1 LEFT JOIN `ps_image_lang` `il` ON image_shop.`id_image` = il.`id_image` AND il.`id_lang` = 1 LEFT JOIN `ps_manufacturer` `m` ON m.`id_manufacturer` = p.`id_manufacturer` LEFT JOIN `ps_product_attribute_shop` `product_attribute_shop` ON p.`id_product` = product_attribute_shop.`id_product` AND product_attribute_shop.`default_on` = 1 AND product_attribute_shop.id_shop=1 LEFT JOIN ps_stock_available stock ON (stock.id_product = `p`.id_product AND stock.id_product_attribute = 0 AND stock.id_shop = 1 AND stock.id_shop_group = 0 ) WHERE (product_shop.`active` = 1) AND (product_shop.`visibility` IN ("both", "catalog")) AND (DATEDIFF(product_shop.`date_add`, DATE_SUB( "2025-07-31 00:00:00", INTERVAL 1000 DAY ) ) > 0) AND (EXISTS(SELECT 1 FROM `ps_category_product` cp JOIN `ps_category_group` cg ON (cp.id_category = cg.id_category AND cg.`id_group` =1) WHERE cp.`id_product` = p.`id_product`)) ORDER BY product_shop.`date_add` DESC LIMIT 5	14.871 ms	39366			/classes/Product.php:3110 /modules/tvcmsproductpopup/tvcmsproductpopup.php:367 (getNewProducts) /modules/tvcmsproductpopup/tvcmsproductpopup.php:252 (getNewProducts) /modules/tvcmsproductpopup/tvcmsproductpopup.php:546 (prevHook) /classes/Hook.php:1083 (hookdisplayAfterBodyOpeningTag) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:421 (coreCallHook) /classes/Hook.php:989 (callHookOn) /config/smarty.config.inc.php:201 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/dev/smarty/compile/v1_giftoo_168layouts_layout_left_column_tpl/69/81/ba/6981ba7f75ae91c680b199f8c9b8d3dbd8d96719_2.file.layout-both-columns.tpl.php:116 (__call) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/v1_giftoo_168layouts_layout_left_column_tpl/69/81/ba/6981ba7f75ae91c680b199f8c9b8d3dbd8d96719_2.file.layout-both-columns.tpl.php:54 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_688bca89963334_98279087) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/v1_giftoo_168layouts_layout_left_column_tpl/8d/0f/a6/8d0fa6a125af07e8554a5461801ff205a85e918e_2.file.layout-left-column.tpl.php:28 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_688bca89918cb8_31976545) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/v1_giftoo_168layouts_layout_left_column_tpl/33/cf/b7/33cfb772f37fe9bf7e7da2f4ede7b9ba2ebdb1ff_2.file.product-list.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_688bca898f8023_38089402) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/v1_giftoo_168layouts_layout_left_column_tpl/a5/95/48/a595487cdf0e93c51d790aa7d81fde9f6d267539_2.file.category.tpl.php:29 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_688bca898bc698_82360211) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/Smarty/SmartyCustom.php:112 (fetch) /classes/controller/FrontController.php:771 (fetch) /classes/controller/FrontController.php:753 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
759	SELECT SQL_NO_CACHE p., product_shop., stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, pl.`description`, pl.`description_short`, pl.`link_rewrite`, pl.`meta_description`, pl.`meta_keywords`, pl.`meta_title`, pl.`name`, pl.`available_now`, pl.`available_later`, image_shop.`id_image` id_image, il.`legend`, m.`name` AS manufacturer_name, (DATEDIFF(product_shop.`date_add`, DATE_SUB( "2025-07-31 00:00:00", INTERVAL 1000 DAY ) ) > 0) as new, product_attribute_shop.minimal_quantity AS product_attribute_minimal_quantity, IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute FROM `ps_product` p INNER JOIN ps_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) LEFT JOIN `ps_product_lang` `pl` ON p.`id_product` = pl.`id_product` AND pl.`id_lang` = 1 AND pl.id_shop = 1 LEFT JOIN `ps_image_shop` `image_shop` ON image_shop.`id_product` = p.`id_product` AND image_shop.cover=1 AND image_shop.id_shop=1 LEFT JOIN `ps_image_lang` `il` ON image_shop.`id_image` = il.`id_image` AND il.`id_lang` = 1 LEFT JOIN `ps_manufacturer` `m` ON m.`id_manufacturer` = p.`id_manufacturer` LEFT JOIN `ps_product_attribute_shop` `product_attribute_shop` ON p.`id_product` = product_attribute_shop.`id_product` AND product_attribute_shop.`default_on` = 1 AND product_attribute_shop.id_shop=1 LEFT JOIN ps_stock_available stock ON (stock.id_product = `p`.id_product AND stock.id_product_attribute = 0 AND stock.id_shop = 1 AND stock.id_shop_group = 0 ) WHERE (product_shop.`active` = 1) AND (product_shop.`visibility` IN ("both", "catalog")) AND (DATEDIFF(product_shop.`date_add`, DATE_SUB( "2025-07-31 00:00:00", INTERVAL 1000 DAY ) ) > 0) AND (EXISTS(SELECT 1 FROM `ps_category_product` cp JOIN `ps_category_group` cg ON (cp.id_category = cg.id_category AND cg.`id_group` =1) WHERE cp.`id_product` = p.`id_product`)) ORDER BY product_shop.`date_add` DESC LIMIT 4	12.342 ms	39366			/classes/Product.php:3110 /modules/tvcmstabproducts/tvcmstabproducts.php:2809 (getNewProducts) /modules/tvcmsnewproducts/tvcmsnewproducts.php:157 (displayNewProducts) /modules/tvcmsnewproducts/tvcmsnewproducts.php:266 (showFrontSideResult) /classes/Hook.php:1083 (hookdisplayLeftColumn) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:421 (coreCallHook) /classes/Hook.php:989 (callHookOn) /config/smarty.config.inc.php:201 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/dev/smarty/compile/v1_giftoo_168layouts_layout_left_column_tpl/69/81/ba/6981ba7f75ae91c680b199f8c9b8d3dbd8d96719_2.file.layout-both-columns.tpl.php:192 (__call) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/v1_giftoo_168layouts_layout_left_column_tpl/69/81/ba/6981ba7f75ae91c680b199f8c9b8d3dbd8d96719_2.file.layout-both-columns.tpl.php:74 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_688bca89963334_98279087) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/v1_giftoo_168layouts_layout_left_column_tpl/8d/0f/a6/8d0fa6a125af07e8554a5461801ff205a85e918e_2.file.layout-left-column.tpl.php:28 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_688bca89918cb8_31976545) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/v1_giftoo_168layouts_layout_left_column_tpl/33/cf/b7/33cfb772f37fe9bf7e7da2f4ede7b9ba2ebdb1ff_2.file.product-list.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_688bca898f8023_38089402) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/v1_giftoo_168layouts_layout_left_column_tpl/a5/95/48/a595487cdf0e93c51d790aa7d81fde9f6d267539_2.file.category.tpl.php:29 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_688bca898bc698_82360211) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/Smarty/SmartyCustom.php:112 (fetch) /classes/controller/FrontController.php:771 (fetch) /classes/controller/FrontController.php:753 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
755	SELECT SQL_NO_CACHE c., cl. FROM `ps_category` c INNER JOIN ps_category_shop category_shop ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1) LEFT JOIN `ps_category_lang` cl ON c.`id_category` = cl.`id_category` AND cl.id_shop = 1 LEFT JOIN `ps_category_group` cg ON c.`id_category` = cg.`id_category` RIGHT JOIN `ps_category` c2 ON c2.`id_category` = 2 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright` WHERE 1 AND c.`level_depth` <= 5 AND `id_lang` = 1 AND c.`active` = 1 AND cg.`id_group` IN (1) GROUP BY c.`id_category` ORDER BY c.`level_depth` ASC, category_shop.`position` ASC	10.708 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)
360	SELECT SQL_NO_CACHE COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM ps_product p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN ps_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND cp.id_category IN (723, 694, 654, 731, 623, 515, 32) 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))	4.484 ms	125000			/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)
361	SELECT SQL_NO_CACHE COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM ps_product p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN ps_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND cp.id_category IN (723, 694, 654, 731, 623, 515, 32) 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))	4.339 ms	125000			/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)
738	SELECT SQL_NO_CACHE c., cl. FROM `ps_category` c INNER JOIN ps_category_shop category_shop ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1) LEFT JOIN `ps_category_lang` cl ON c.`id_category` = cl.`id_category` AND cl.id_shop = 1 WHERE 1 AND `id_lang` = 1 AND c.`active` = 1 ORDER BY c.`level_depth` ASC , category_shop.`position` ASC	3.788 ms	624	Yes		/classes/Category.php:799 /modules/tvcmssearch/tvcmssearch.php:100 (getNestedCategories) /modules/tvcmssearch/tvcmssearch.php:211 (getAllCategories) /classes/Hook.php:1083 (hookdisplayNavSearchBlock) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:421 (coreCallHook) /classes/Hook.php:989 (callHookOn) /config/smarty.config.inc.php:201 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/dev/smarty/compile/v1_giftoo_168layouts_layout_left_column_tpl/90/13/a7/9013a7a04bf39036fbad3fb5950dffed201fd662_2.file.desk-header-4.tpl.php:31 (__call) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_688bca8aedb8e5_63912440) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /var/cache/dev/smarty/compile/v1_giftoo_168layouts_layout_left_column_tpl/1f/24/34/1f24346c22c38b7c776c299605d2505a48901b59_2.file.desktop-header.tpl.php:25 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_688bca8aebafe8_11290461) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /var/cache/dev/smarty/compile/v1_giftoo_168layouts_layout_left_column_tpl/dd/09/47/dd09475ae3b50c8ffa5eab9566f11c0a7b74d124_2.file.header.tpl.php:55 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/v1_giftoo_168layouts_layout_left_column_tpl/dd/09/47/dd09475ae3b50c8ffa5eab9566f11c0a7b74d124_2.file.header.tpl.php:29 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_688bca8aea9522_22684211) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /var/cache/dev/smarty/compile/v1_giftoo_168layouts_layout_left_column_tpl/69/81/ba/6981ba7f75ae91c680b199f8c9b8d3dbd8d96719_2.file.layout-both-columns.tpl.php:144 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/v1_giftoo_168layouts_layout_left_column_tpl/69/81/ba/6981ba7f75ae91c680b199f8c9b8d3dbd8d96719_2.file.layout-both-columns.tpl.php:64 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_688bca89963334_98279087) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/v1_giftoo_168layouts_layout_left_column_tpl/8d/0f/a6/8d0fa6a125af07e8554a5461801ff205a85e918e_2.file.layout-left-column.tpl.php:28 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_688bca89918cb8_31976545) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/v1_giftoo_168layouts_layout_left_column_tpl/33/cf/b7/33cfb772f37fe9bf7e7da2f4ede7b9ba2ebdb1ff_2.file.product-list.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_688bca898f8023_38089402) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/v1_giftoo_168layouts_layout_left_column_tpl/a5/95/48/a595487cdf0e93c51d790aa7d81fde9f6d267539_2.file.category.tpl.php:29 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_688bca898bc698_82360211) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/Smarty/SmartyCustom.php:112 (fetch) /classes/controller/FrontController.php:771 (fetch) /classes/controller/FrontController.php:753 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
359	SELECT SQL_NO_CACHE COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM ps_product p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN ps_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND cp.id_category IN (723, 694, 654, 731, 623, 515, 32) 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)))	3.751 ms	125000			/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)
778	SELECT SQL_NO_CACHE p., product_shop., stock.out_of_stock, IFNULL(stock.quantity, 0) AS quantity, IFNULL(product_attribute_shop.id_product_attribute, 0) AS id_product_attribute, product_attribute_shop.minimal_quantity AS product_attribute_minimal_quantity, pl.`description`, pl.`description_short`, pl.`available_now`, pl.`available_later`, pl.`link_rewrite`, pl.`meta_description`, pl.`meta_keywords`, pl.`meta_title`, pl.`name`, image_shop.`id_image` id_image, il.`legend` as legend, m.`name` AS manufacturer_name, cl.`name` AS category_default, DATEDIFF(product_shop.`date_add`, DATE_SUB("2025-07-31 00:00:00", INTERVAL 1000 DAY)) > 0 AS new, product_shop.price AS orderprice FROM `ps_category_product` cp LEFT JOIN `ps_product` p ON p.`id_product` = cp.`id_product` INNER JOIN ps_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) LEFT JOIN `ps_product_attribute_shop` product_attribute_shop ON (p.`id_product` = product_attribute_shop.`id_product` AND product_attribute_shop.`default_on` = 1 AND product_attribute_shop.id_shop=1) LEFT JOIN ps_stock_available stock ON (stock.id_product = `p`.id_product AND stock.id_product_attribute = 0 AND stock.id_shop = 1 AND stock.id_shop_group = 0 ) LEFT JOIN `ps_category_lang` cl ON (product_shop.`id_category_default` = cl.`id_category` AND cl.`id_lang` = 1 AND cl.id_shop = 1 ) LEFT JOIN `ps_product_lang` pl ON (p.`id_product` = pl.`id_product` AND pl.`id_lang` = 1 AND pl.id_shop = 1 ) LEFT JOIN `ps_image_shop` image_shop ON (image_shop.`id_product` = p.`id_product` AND image_shop.cover=1 AND image_shop.id_shop=1) LEFT JOIN `ps_image_lang` il ON (image_shop.`id_image` = il.`id_image` AND il.`id_lang` = 1) LEFT JOIN `ps_manufacturer` m ON m.`id_manufacturer` = p.`id_manufacturer` WHERE product_shop.`id_shop` = 1 AND cp.`id_category` = 25 AND product_shop.`active` = 1 AND product_shop.`visibility` IN ("both", "catalog") ORDER BY RAND() LIMIT 4	3.712 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)
371	SELECT SQL_NO_CACHE pac.id_attribute, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM ps_product p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN ps_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND cp.id_category IN (723, 694, 654, 731, 623, 515, 32) 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	2.921 ms	125000	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)
357	SELECT SQL_NO_CACHE p.id_product FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM ps_product p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN ps_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND cp.id_category IN (723, 694, 654, 731, 623, 515, 32) 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	2.906 ms	62500	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)
375	SELECT SQL_NO_CACHE p.id_manufacturer, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM ps_product p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN ps_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND cp.id_category IN (723, 694, 654, 731, 623, 515, 32) GROUP BY p.id_product) p GROUP BY p.id_manufacturer	2.253 ms	62500	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)
363	SELECT SQL_NO_CACHE COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM ps_product p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN ps_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND cp.id_category IN (723, 694, 654, 731, 623, 515, 32) GROUP BY p.id_product) p WHERE p.date_add>'2022-11-05 00:00:00'	2.191 ms	62500			/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)
376	SELECT SQL_NO_CACHE p.condition, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM ps_product p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN ps_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND cp.id_category IN (723, 694, 654, 731, 623, 515, 32) GROUP BY p.id_product) p GROUP BY p.condition	2.173 ms	62500	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)
43	SELECT SQL_NO_CACHE c.*, cl.`id_lang`, cl.`name`, cl.`description`, cl.`additional_description`, cl.`link_rewrite`, cl.`meta_title`, cl.`meta_keywords`, cl.`meta_description` FROM `ps_category` c INNER JOIN ps_category_shop category_shop ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1) LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND `id_lang` = 1 AND cl.id_shop = 1 ) LEFT JOIN `ps_category_group` cg ON (cg.`id_category` = c.`id_category`) WHERE `id_parent` = 2 AND `active` = 1 AND cg.`id_group` =1 GROUP BY c.`id_category` ORDER BY `level_depth` ASC, category_shop.`position` ASC	2.125 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)
362	SELECT SQL_NO_CACHE COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM ps_product p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN ps_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND cp.id_category IN (723, 694, 654, 731, 623, 515, 32) GROUP BY p.id_product) p WHERE ((p.on_sale=1))	2.110 ms	62500			/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)
366	SELECT SQL_NO_CACHE c.`id_category`, cl.`name` FROM `ps_category` c INNER JOIN ps_category_shop category_shop ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1) LEFT JOIN `ps_category_lang` cl ON c.`id_category` = cl.`id_category` AND cl.id_shop = 1 WHERE 1 AND `id_lang` = 1 AND c.`active` = 1 ORDER BY c.nleft, c.position	2.016 ms	624	Yes		/classes/Category.php:724 /modules/ps_facetedsearch/src/Filters/Block.php:986 (getAllCategoriesName) /modules/ps_facetedsearch/src/Filters/Block.php:158 (getCategoriesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
13	SELECT SQL_NO_CACHE h.`name` as hook, m.`id_module`, h.`id_hook`, m.`name` as module FROM `ps_module` m INNER JOIN ps_module_shop module_shop ON (module_shop.id_module = m.id_module AND module_shop.id_shop = 1 AND module_shop.enable_device & 1) INNER JOIN `ps_hook_module` `hm` ON hm.`id_module` = m.`id_module` INNER JOIN `ps_hook` `h` ON hm.`id_hook` = h.`id_hook` LEFT JOIN `ps_module_group` `mg` ON mg.`id_module` = m.`id_module` WHERE (h.`name` != "paymentOptions") AND (hm.`id_shop` = 1) AND (mg.id_shop = 1 AND mg.`id_group` IN (1)) GROUP BY hm.id_hook, hm.id_module ORDER BY hm.`position`	1.811 ms	230	Yes	Yes	/classes/Hook.php:1289 /classes/Hook.php:738 (getAllHookRegistrations) /classes/Hook.php:848 (getHookModuleExecList) /classes/Dispatcher.php:606 (exec) /classes/Dispatcher.php:243 (loadRoutes) /classes/Dispatcher.php:201 (__construct) /index.php:28 (getInstance)
2	SELECT SQL_NO_CACHE c.`name`, cl.`id_lang`, IF(cl.`id_lang` IS NULL, c.`value`, cl.`value`) AS value, c.id_shop_group, c.id_shop FROM `ps_configuration` c LEFT JOIN `ps_configuration_lang` cl ON (c.`id_configuration` = cl.`id_configuration`)	1.743 ms	1147			/classes/Configuration.php:180 /classes/Configuration.php:229 (loadConfiguration) /classes/Configuration.php:302 (get) /classes/shop/Shop.php:398 (getMultiShopValues) /config/config.inc.php:117 (initialize) /index.php:27 (require)
393	SELECT SQL_NO_CACHE h.id_hook, h.name as h_name, title, description, h.position, hm.position as hm_position, m.id_module, m.name, m.active FROM `ps_hook_module` hm STRAIGHT_JOIN `ps_hook` h ON (h.id_hook = hm.id_hook AND hm.id_shop = 1) STRAIGHT_JOIN `ps_module` as m ON (m.id_module = hm.id_module) ORDER BY hm.position	1.292 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.154 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)
873	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.069 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)
365	SELECT SQL_NO_CACHE psi.price_min, MIN(price_min) as min, MAX(price_max) as max FROM ps_product p INNER JOIN ps_layered_price_index psi ON (psi.id_product = p.id_product AND psi.id_shop = 1 AND psi.id_currency = 1 AND psi.id_country = 6) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND cp.id_category IN (723, 694, 654, 731, 623, 515, 32)	0.863 ms	125			/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)
857	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.797 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)
377	SELECT SQL_NO_CACHE MIN(p.weight) as min, MAX(p.weight) as max FROM ps_product p INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND cp.id_category IN (723, 694, 654, 731, 623, 515, 32)	0.712 ms	125			/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)
12	SELECT SQL_NO_CACHE lower(name) as name FROM `ps_hook` h WHERE (h.active = 1)	0.609 ms	1107			/classes/Hook.php:1388 /classes/Hook.php:817 (getHookStatusByName) /classes/Dispatcher.php:606 (exec) /classes/Dispatcher.php:243 (loadRoutes) /classes/Dispatcher.php:201 (__construct) /index.php:28 (getInstance)
369	SELECT SQL_NO_CACHE pac.id_attribute, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM ps_product p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN ps_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND cp.id_category IN (723, 694, 654, 731, 623, 515, 32) 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.601 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)
339	SELECT SQL_NO_CACHE p., product_shop., stock.out_of_stock, IFNULL(stock.quantity, 0) AS quantity, IFNULL(product_attribute_shop.id_product_attribute, 0) AS id_product_attribute, product_attribute_shop.minimal_quantity AS product_attribute_minimal_quantity, pl.`description`, pl.`description_short`, pl.`available_now`, pl.`available_later`, pl.`link_rewrite`, pl.`meta_description`, pl.`meta_keywords`, pl.`meta_title`, pl.`name`, image_shop.`id_image` id_image, il.`legend` as legend, m.`name` AS manufacturer_name, cl.`name` AS category_default, DATEDIFF(product_shop.`date_add`, DATE_SUB("2025-07-31 00:00:00", INTERVAL 1000 DAY)) > 0 AS new, product_shop.price AS orderprice FROM `ps_category_product` cp LEFT JOIN `ps_product` p ON p.`id_product` = cp.`id_product` INNER JOIN ps_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) LEFT JOIN `ps_product_attribute_shop` product_attribute_shop ON (p.`id_product` = product_attribute_shop.`id_product` AND product_attribute_shop.`default_on` = 1 AND product_attribute_shop.id_shop=1) LEFT JOIN ps_stock_available stock ON (stock.id_product = `p`.id_product AND stock.id_product_attribute = 0 AND stock.id_shop = 1 AND stock.id_shop_group = 0 ) LEFT JOIN `ps_category_lang` cl ON (product_shop.`id_category_default` = cl.`id_category` AND cl.`id_lang` = 1 AND cl.id_shop = 1 ) LEFT JOIN `ps_product_lang` pl ON (p.`id_product` = pl.`id_product` AND pl.`id_lang` = 1 AND pl.id_shop = 1 ) LEFT JOIN `ps_image_shop` image_shop ON (image_shop.`id_product` = p.`id_product` AND image_shop.cover=1 AND image_shop.id_shop=1) LEFT JOIN `ps_image_lang` il ON (image_shop.`id_image` = il.`id_image` AND il.`id_lang` = 1) LEFT JOIN `ps_manufacturer` m ON m.`id_manufacturer` = p.`id_manufacturer` WHERE product_shop.`id_shop` = 1 AND cp.`id_category` = 2 AND product_shop.`active` = 1 AND product_shop.`visibility` IN ("both", "catalog") ORDER BY cp.`position` ASC LIMIT 0,12	0.598 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)
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,63,20873,187,20914,229,20955,248,20996,250,21037,273)	0.595 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)
364	SELECT SQL_NO_CACHE COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM ps_product p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN ps_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND cp.id_category IN (723, 694, 654, 731, 623, 515, 32) GROUP BY p.id_product) p LEFT JOIN ps_specific_price sp ON ( sp.id_product = p.id_product AND sp.id_shop IN (0, 1) AND sp.id_currency IN (0, 1) AND sp.id_country IN (0, 6) AND sp.id_group IN (0, 1) AND sp.from_quantity = 1 AND sp.reduction > 0 AND sp.id_customer = 0 AND sp.id_cart = 0 AND (sp.from = '0000-00-00 00:00:00' OR '2025-07-31 22:45:24' >= sp.from) AND (sp.to = '0000-00-00 00:00:00' OR '2025-07-31 22:45:24' <= sp.to) ) WHERE ((sp.reduction>0))	0.575 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)
379	SELECT SQL_NO_CACHE pac.id_attribute, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM ps_product p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN ps_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND cp.id_category IN (723, 694, 654, 731, 623, 515, 32) 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.552 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)
786	SELECT SQL_NO_CACHE *, ( IF (`id_shop` = 1, 2, 0) + IF (`id_country` = 6, 4, 0) + IF (`id_currency` = 1, 8, 0) + IF (`id_group` = 1, 16, 0) + IF (`id_customer` = 0, 32, 0)) AS `score` FROM `ps_specific_price` WHERE `id_shop` IN (0, 1) AND `id_currency` IN (0, 1) AND `id_country` IN (0, 6) AND `id_group` IN (0, 1) AND `id_product` = 1710 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0 AND (`from` = '0000-00-00 00:00:00' OR '2025-07-31 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2025-07-31 00:00:00' <= `to`) AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1	0.551 ms	3	Yes		/classes/SpecificPrice.php:576 /classes/Product.php:3827 (getSpecificPrice) /classes/Product.php:3717 (priceCalculation) /classes/Product.php:5692 (getPriceStatic) /classes/Product.php:5990 (getProductProperties) /classes/Category.php:1074 (getProductsProperties) /src/Adapter/Category/CategoryProductSearchProvider.php:79 (getProducts) /src/Adapter/Category/CategoryProductSearchProvider.php:105 (getProductsOrCount) /modules/tvcmstabproducts/tvcmstabproducts.php:2754 (runQuery) /modules/tvcmsfeaturedproducts/tvcmsfeaturedproducts.php:158 (displayFeaturedProducts) /modules/tvcmsfeaturedproducts/tvcmsfeaturedproducts.php:281 (showFrontSideResult) /classes/Hook.php:1083 (hookdisplayLeftColumn) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:421 (coreCallHook) /classes/Hook.php:989 (callHookOn) /config/smarty.config.inc.php:201 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/dev/smarty/compile/v1_giftoo_168layouts_layout_left_column_tpl/69/81/ba/6981ba7f75ae91c680b199f8c9b8d3dbd8d96719_2.file.layout-both-columns.tpl.php:192 (__call) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/v1_giftoo_168layouts_layout_left_column_tpl/69/81/ba/6981ba7f75ae91c680b199f8c9b8d3dbd8d96719_2.file.layout-both-columns.tpl.php:74 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_688bca89963334_98279087) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/v1_giftoo_168layouts_layout_left_column_tpl/8d/0f/a6/8d0fa6a125af07e8554a5461801ff205a85e918e_2.file.layout-left-column.tpl.php:28 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_688bca89918cb8_31976545) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/v1_giftoo_168layouts_layout_left_column_tpl/33/cf/b7/33cfb772f37fe9bf7e7da2f4ede7b9ba2ebdb1ff_2.file.product-list.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_688bca898f8023_38089402) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/v1_giftoo_168layouts_layout_left_column_tpl/a5/95/48/a595487cdf0e93c51d790aa7d81fde9f6d267539_2.file.category.tpl.php:29 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_688bca898bc698_82360211) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/Smarty/SmartyCustom.php:112 (fetch) /classes/controller/FrontController.php:771 (fetch) /classes/controller/FrontController.php:753 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
372	SELECT SQL_NO_CACHE fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM ps_product p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN ps_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND cp.id_category IN (723, 694, 654, 731, 623, 515, 32) GROUP BY p.id_product) p INNER JOIN ps_feature_product fp ON (p.id_product = fp.id_product) WHERE ((fp.id_feature=1)) GROUP BY fp.id_feature_value	0.550 ms	4	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:778 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:855 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:154 (getFeaturesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
827	SELECT SQL_NO_CACHE *, ( IF (`id_shop` = 1, 2, 0) + IF (`id_country` = 6, 4, 0) + IF (`id_currency` = 1, 8, 0) + IF (`id_group` = 1, 16, 0) + IF (`id_customer` = 0, 32, 0)) AS `score` FROM `ps_specific_price` WHERE `id_shop` IN (0, 1) AND `id_currency` IN (0, 1) AND `id_country` IN (0, 6) AND `id_group` IN (0, 1) AND `id_product` = 1708 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0 AND (`from` = '0000-00-00 00:00:00' OR '2025-07-31 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2025-07-31 00:00:00' <= `to`) AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1	0.537 ms	3	Yes		/classes/SpecificPrice.php:576 /classes/Product.php:3827 (getSpecificPrice) /classes/Product.php:3717 (priceCalculation) /classes/Product.php:5692 (getPriceStatic) /classes/Product.php:5990 (getProductProperties) /classes/Category.php:1074 (getProductsProperties) /src/Adapter/Category/CategoryProductSearchProvider.php:79 (getProducts) /src/Adapter/Category/CategoryProductSearchProvider.php:105 (getProductsOrCount) /modules/tvcmstabproducts/tvcmstabproducts.php:2754 (runQuery) /modules/tvcmsfeaturedproducts/tvcmsfeaturedproducts.php:158 (displayFeaturedProducts) /modules/tvcmsfeaturedproducts/tvcmsfeaturedproducts.php:281 (showFrontSideResult) /classes/Hook.php:1083 (hookdisplayLeftColumn) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:421 (coreCallHook) /classes/Hook.php:989 (callHookOn) /config/smarty.config.inc.php:201 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/dev/smarty/compile/v1_giftoo_168layouts_layout_left_column_tpl/69/81/ba/6981ba7f75ae91c680b199f8c9b8d3dbd8d96719_2.file.layout-both-columns.tpl.php:192 (__call) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/v1_giftoo_168layouts_layout_left_column_tpl/69/81/ba/6981ba7f75ae91c680b199f8c9b8d3dbd8d96719_2.file.layout-both-columns.tpl.php:74 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_688bca89963334_98279087) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/v1_giftoo_168layouts_layout_left_column_tpl/8d/0f/a6/8d0fa6a125af07e8554a5461801ff205a85e918e_2.file.layout-left-column.tpl.php:28 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_688bca89918cb8_31976545) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/v1_giftoo_168layouts_layout_left_column_tpl/33/cf/b7/33cfb772f37fe9bf7e7da2f4ede7b9ba2ebdb1ff_2.file.product-list.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_688bca898f8023_38089402) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/v1_giftoo_168layouts_layout_left_column_tpl/a5/95/48/a595487cdf0e93c51d790aa7d81fde9f6d267539_2.file.category.tpl.php:29 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_688bca898bc698_82360211) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/Smarty/SmartyCustom.php:112 (fetch) /classes/controller/FrontController.php:771 (fetch) /classes/controller/FrontController.php:753 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
374	SELECT SQL_NO_CACHE m.*, ml.`description`, ml.`short_description` FROM `ps_manufacturer` m INNER JOIN ps_manufacturer_shop manufacturer_shop ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 1)INNER JOIN `ps_manufacturer_lang` ml ON (m.`id_manufacturer` = ml.`id_manufacturer` AND ml.`id_lang` = 1)WHERE 1 AND m.`active` = 1 ORDER BY m.`name` ASC	0.524 ms	13	Yes		/classes/Manufacturer.php:211 /modules/ps_facetedsearch/src/Filters/Block.php:652 (getManufacturers) /modules/ps_facetedsearch/src/Filters/Block.php:146 (getManufacturersBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
381	SELECT SQL_NO_CACHE pac.id_attribute, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM ps_product p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN ps_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND cp.id_category IN (723, 694, 654, 731, 623, 515, 32) GROUP BY p.id_product) p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) INNER JOIN ps_attribute a ON (a.id_attribute = pac.id_attribute) WHERE ((a.id_attribute_group=4)) GROUP BY pac.id_attribute	0.521 ms	800	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:778 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:737 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:150 (getAttributesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
842	SELECT SQL_NO_CACHE *, ( IF (`id_shop` = 1, 2, 0) + IF (`id_country` = 6, 4, 0) + IF (`id_currency` = 1, 8, 0) + IF (`id_group` = 1, 16, 0) + IF (`id_customer` = 0, 32, 0)) AS `score` FROM `ps_specific_price` WHERE `id_shop` IN (0, 1) AND `id_currency` IN (0, 1) AND `id_country` IN (0, 6) AND `id_group` IN (0, 1) AND `id_product` = 451 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0 AND (`from` = '0000-00-00 00:00:00' OR '2025-07-31 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2025-07-31 00:00:00' <= `to`) AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1	0.515 ms	3	Yes		/classes/SpecificPrice.php:576 /classes/Product.php:3827 (getSpecificPrice) /classes/Product.php:3717 (priceCalculation) /classes/Product.php:5692 (getPriceStatic) /classes/Product.php:5990 (getProductProperties) /classes/Category.php:1074 (getProductsProperties) /src/Adapter/Category/CategoryProductSearchProvider.php:79 (getProducts) /src/Adapter/Category/CategoryProductSearchProvider.php:105 (getProductsOrCount) /modules/tvcmstabproducts/tvcmstabproducts.php:2754 (runQuery) /modules/tvcmsfeaturedproducts/tvcmsfeaturedproducts.php:158 (displayFeaturedProducts) /modules/tvcmsfeaturedproducts/tvcmsfeaturedproducts.php:281 (showFrontSideResult) /classes/Hook.php:1083 (hookdisplayLeftColumn) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:421 (coreCallHook) /classes/Hook.php:989 (callHookOn) /config/smarty.config.inc.php:201 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/dev/smarty/compile/v1_giftoo_168layouts_layout_left_column_tpl/69/81/ba/6981ba7f75ae91c680b199f8c9b8d3dbd8d96719_2.file.layout-both-columns.tpl.php:192 (__call) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/v1_giftoo_168layouts_layout_left_column_tpl/69/81/ba/6981ba7f75ae91c680b199f8c9b8d3dbd8d96719_2.file.layout-both-columns.tpl.php:74 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_688bca89963334_98279087) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/v1_giftoo_168layouts_layout_left_column_tpl/8d/0f/a6/8d0fa6a125af07e8554a5461801ff205a85e918e_2.file.layout-left-column.tpl.php:28 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_688bca89918cb8_31976545) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/v1_giftoo_168layouts_layout_left_column_tpl/33/cf/b7/33cfb772f37fe9bf7e7da2f4ede7b9ba2ebdb1ff_2.file.product-list.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_688bca898f8023_38089402) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/v1_giftoo_168layouts_layout_left_column_tpl/a5/95/48/a595487cdf0e93c51d790aa7d81fde9f6d267539_2.file.category.tpl.php:29 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_688bca898bc698_82360211) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/Smarty/SmartyCustom.php:112 (fetch) /classes/controller/FrontController.php:771 (fetch) /classes/controller/FrontController.php:753 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
373	SELECT SQL_NO_CACHE fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM ps_product p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN ps_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND cp.id_category IN (723, 694, 654, 731, 623, 515, 32) GROUP BY p.id_product) p INNER JOIN ps_feature_product fp ON (p.id_product = fp.id_product) WHERE ((fp.id_feature=2)) GROUP BY fp.id_feature_value	0.512 ms	4	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:778 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:855 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:154 (getFeaturesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
15	SELECT SQL_NO_CACHE `id_hook`, `name` FROM `ps_hook`	0.485 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)
774	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.485 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)

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

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

Joyero Mujer

Mesa de Bar

Soporte para Impresora

Biombo

Butaca de Salón

Carrito

Neceser Trevi

Neceser Trevi

Neceser Trevi

Neceser Trevi

Identificador Maletas Cloris

Identificador Maletas Cloris

Identificador Maletas Cloris

Identificador Maletas Cloris

Neceser Espi

Neceser Espi

Neceser Espi

Neceser Espi

Set Viaje Plonet

Set Viaje Plonet

Set Viaje Plonet

Set Viaje Plonet

Zapatillero Recco

Zapatillero Recco

Zapatillero Recco

Zapatillero Recco

Portatrajes Kibix

Portatrajes Kibix

Portatrajes Kibix

Portatrajes Kibix

Stopwatch SQL - 1127 queries

Doubles

Tables stress

ObjectModel instances

Included Files