Inicio

Subcategorías

Grid
List

Hay 18 productos.

Ordenar por:

Mostrando 1-12 de 18 artículo(s)

- Sólo por Internet
- ¡En oferta!
Agregar a lista de deseos

Vista rápida

Agregar a comparación
Tablet Stylos TAB104 TPU Cover 10.4 PS 4GB RAM+128GB ROM Android 13 T606 Octa...

$2,566

La Tablet Stylos TAB104 de 10.4" ofrece un rendimiento eficiente con su procesador Octa-Core T606, 4 GB de RAM y 128 GB de almacenamiento, ejecutando Android 13. Incluye una.
- Nuevo
Agregar a lista de deseos

Vista rápida

Agregar a comparación
Relevador Wi-Fi Inteligente / 2 Salidas Para 2 Apagadores / Ideal Para...

$531

Relevador Wi-Fi Inteligente / 2 Salidas Para 2 Apagadores / Ideal Para Control de Iluminación / Control Remoto / Horarios Personalizados / Registro de Consumo / 110-240VCA
- Nuevo
Agregar a lista de deseos

Vista rápida

Agregar a comparación
Videoportero IP Conexión a 2 Hilos / Con Monitor Wi-Fi para Interior / Frente...

$4,002

Videoportero IP Conexión a 2 Hilos / Con Monitor Wi-Fi para Interior / Frente de Calle IP65 Uso En Exterior Debe Tener Protección / Cámara 3 Megapíxel / Llamada a la App /.
- Nuevo
Agregar a lista de deseos

Vista rápida

Agregar a comparación
Pantalla Inalámbrica / Con Batería Recargable 4600mAh / Wi-Fi / Ideal Para...

$2,480

Pantalla Inalámbrica / Con Batería Recargable 4600mAh / Wi-Fi / Ideal Para Escritoio o Pared / Vista en Vivo de Cámaras EZVIZ / Compatible con Videoportero CS-HP7 para ver.
- Nuevo
Agregar a lista de deseos

Vista rápida

Agregar a comparación
Cerradura Inteligente / Wi-Fi / Bluetooth / Códigos Temporales Para...

$4,276

Cerradura Inteligente / Wi-Fi / Bluetooth / Códigos Temporales Para Visitantes / Lectura de Huella / Lectura de Tag / Contraseña / Botón para Timbrar / Apertura Remota / Alarma.
- Nuevo
Agregar a lista de deseos

Vista rápida

Agregar a comparación
Cerradura Inteligente / Cerrojo Tipo Americano / Wi-Fi / Bluetooth /...

$4,238

Cerradura Inteligente / Cerrojo Tipo Americano / Wi-Fi / Bluetooth / Códigos Temporales Para Visitantes / Lectura de Huella / Lectura de Tag / Contraseña / Botón para Timbrar /.
- Nuevo
Agregar a lista de deseos

Vista rápida

Agregar a comparación
Relevador Wi-Fi Inteligente / Ideal Para Control de Iluminación / 1 Salida...

$464

Relevador Wi-Fi Inteligente / Ideal Para Control de Iluminación / 1 Salida para un Apagador / Control Remoto / Horarios Personalizados / Registro de Consumo
- Nuevo
Agregar a lista de deseos

Vista rápida

Agregar a comparación
Inversor para Interconexión a CFE de 10 kW con Salida de 220 Vca, Módulo Wifi...

$20,523

Inversor para Interconexión a CFE de 10 kW con Salida de 220 Vca, Módulo Wifi Incluido
- Nuevo
Agregar a lista de deseos

Vista rápida

Agregar a comparación
TAG de Proximidad EZVIZ / Compatible Con Cerraduras CS-L2S / CSDL05-R100 /...

$213

TAG de Proximidad EZVIZ / Compatible Con Cerraduras CS-L2S / CSDL05-R100 / CS-DL05-R200 y Videoportero CS-HP7 / Algoritmo de Encriptado Propio
- Nuevo
Agregar a lista de deseos

Vista rápida

Agregar a comparación
Videoportero Con Mirilla y Pantalla Wi-Fi de Batería Recargable / Para...

$2,153

Videoportero Con Mirilla y Pantalla Wi-Fi de Batería Recargable / Para Instalarse en Puerta / Cámara 1080P / Audio de Dos Vías / Uso en Interior
- Nuevo
Agregar a lista de deseos

Vista rápida

Agregar a comparación
Doorbell de Bateria Recargable con Transformador o Panel Solar (Incluye...

$2,252

Doorbell de Bateria Recargable con Transformador o Panel Solar (Incluye Panel) / 3 megapíxel / Doble Lente / Protección IP65 / Audio de Dos Vías
- Nuevo
Agregar a lista de deseos

Vista rápida

Agregar a comparación
Kit de Enchufe Inteligente / Incluye 4 piezas / Wi-Fi / Control a través de...

$990

Kit de Enchufe Inteligente / Incluye 4 piezas / Wi-Fi / Control a través de la Aplicación / Conecte los Dispositivos del Hogar / Permite Personalizar Horarios / Compatible Con.

Load Time	931 ms
Querying Time	399 ms
Queries	491
Memory Peak Usage	27.8 Mb
Included Files	777 files - 9.99 Mb
PrestaShop Cache	- Mb
Global vars	0.23 Mb
- global $context	188k
- global $_MODULES	13k
- global $_MODULE	12k
- global $_SERVER	7k
- global $config	5k
- global $smarty	4k
- global $exportPhpConfigFile	4k
- global $_COOKIE	1k
- global $__composer_autoload_files	1k
- global $legacyContainer	1k

PrestaShop Version	8.2.0
PHP Version	7.4.33
MySQL Version	10.6.21-MariaDB
Memory Limit	256M
Max Execution Time	300000s
Smarty Cache	enabled
Smarty Compilation	auto

	Time	Cumulated Time	Memory Usage	Memory Peak Usage
config	0.005 ms	0.005 ms	3.19 Mb	9.1 Mb
__construct	21.071 ms	21.076 ms	0.09 Mb	9.1 Mb
init	163.967 ms	185.043 ms	2.87 Mb	9.1 Mb
checkAccess	0.002 ms	185.045 ms	- Mb	9.1 Mb
setMedia	21.026 ms	206.071 ms	0.47 Mb	9.1 Mb
postProcess	0.001 ms	206.072 ms	- Mb	9.1 Mb
initHeader	0.001 ms	206.073 ms	- Mb	9.1 Mb
initContent	455.452 ms	661.525 ms	7.04 Mb	13.8 Mb
initFooter	0.003 ms	661.528 ms	- Mb	13.8 Mb
display	269.680 ms	931 ms	11.51 Mb	27.8 Mb

Hook	Time	Memory Usage
displayLeftColumn	98.921 ms	5.72 Mb
=> ps_categorytree (widget)	96.285 ms	5.62 Mb
=> cz_leftbanner (widget)	1.527 ms	0.04 Mb
=> cz_newproducts (widget)	1.109 ms	0.06 Mb
DisplayProductPriceBlock	27.475 ms	2.20 Mb
=> psproductcountdown	0.002 ms	- Mb
=> psproductcountdown	0.003 ms	- Mb
=> psproductcountdown	0.002 ms	- Mb
=> psproductcountdown	2.491 ms	0.20 Mb
=> psproductcountdown	0.001 ms	- Mb
=> psproductcountdown	0.001 ms	- Mb
=> psproductcountdown	0.001 ms	- Mb
=> psproductcountdown	2.469 ms	0.20 Mb
=> psproductcountdown	0.002 ms	- Mb
=> psproductcountdown	0.001 ms	- Mb
=> psproductcountdown	0.001 ms	- Mb
=> psproductcountdown	2.925 ms	0.21 Mb
=> psproductcountdown	0.001 ms	- Mb
=> psproductcountdown	0.001 ms	- Mb
=> psproductcountdown	0.000 ms	- Mb
=> psproductcountdown	2.156 ms	0.18 Mb
=> psproductcountdown	0.002 ms	- Mb
=> psproductcountdown	0.001 ms	- Mb
=> psproductcountdown	0.001 ms	- Mb
=> psproductcountdown	2.269 ms	0.17 Mb
=> psproductcountdown	0.003 ms	- Mb
=> psproductcountdown	0.001 ms	- Mb
=> psproductcountdown	0.001 ms	- Mb
=> psproductcountdown	2.093 ms	0.17 Mb
=> psproductcountdown	0.001 ms	- Mb
=> psproductcountdown	0.001 ms	- Mb
=> psproductcountdown	0.001 ms	- Mb
=> psproductcountdown	2.011 ms	0.17 Mb
=> psproductcountdown	0.002 ms	- Mb
=> psproductcountdown	0.001 ms	- Mb
=> psproductcountdown	0.001 ms	- Mb
=> psproductcountdown	1.995 ms	0.20 Mb
=> psproductcountdown	0.002 ms	- Mb
=> psproductcountdown	0.000 ms	- Mb
=> psproductcountdown	0.002 ms	- Mb
=> psproductcountdown	2.020 ms	0.16 Mb
=> psproductcountdown	0.002 ms	- Mb
=> psproductcountdown	0.001 ms	- Mb
=> psproductcountdown	0.001 ms	- Mb
=> psproductcountdown	2.725 ms	0.17 Mb
=> psproductcountdown	0.001 ms	- Mb
=> psproductcountdown	0.001 ms	- Mb
=> psproductcountdown	0.000 ms	- Mb
=> psproductcountdown	2.125 ms	0.17 Mb
=> psproductcountdown	0.001 ms	- Mb
=> psproductcountdown	0.001 ms	- Mb
=> psproductcountdown	0.001 ms	- Mb
=> psproductcountdown	2.151 ms	0.17 Mb
displayFooter	11.707 ms	0.51 Mb
=> ps_contactinfo (widget)	3.015 ms	0.07 Mb
=> ps_socialfollow (widget)	1.124 ms	0.05 Mb
=> ps_linklist (widget)	3.404 ms	0.06 Mb
=> ps_customeraccountlinks (widget)	1.089 ms	0.13 Mb
=> ps_emailsubscription (widget)	1.054 ms	0.05 Mb
=> cz_themeimages (widget)	1.174 ms	0.06 Mb
=> cz_themeoptions (widget)	0.847 ms	0.10 Mb
DisplayCzHoverImage	10.923 ms	0.55 Mb
=> cz_imagehover	1.613 ms	0.06 Mb
=> cz_imagehover	0.763 ms	0.04 Mb
=> cz_imagehover	0.999 ms	0.04 Mb
=> cz_imagehover	0.822 ms	0.04 Mb
=> cz_imagehover	0.912 ms	0.04 Mb
=> cz_imagehover	0.752 ms	0.04 Mb
=> cz_imagehover	0.804 ms	0.04 Mb
=> cz_imagehover	0.776 ms	0.04 Mb
=> cz_imagehover	0.870 ms	0.04 Mb
=> cz_imagehover	0.889 ms	0.04 Mb
=> cz_imagehover	0.907 ms	0.04 Mb
=> cz_imagehover	0.816 ms	0.04 Mb
DisplayBeforeBodyClosingTag	9.773 ms	0.07 Mb
=> statsdata	9.773 ms	0.07 Mb
displayTop	6.732 ms	0.28 Mb
=> ps_shoppingcart (widget)	3.328 ms	0.13 Mb
=> ps_customersignin (widget)	2.483 ms	0.10 Mb
=> ps_searchbar (widget)	0.921 ms	0.04 Mb
ProductSearchProvider	4.843 ms	0.07 Mb
=> ps_facetedsearch	4.843 ms	0.07 Mb
displayNavFullWidth	4.063 ms	0.24 Mb
=> cz_verticalmenu (widget)	2.047 ms	0.12 Mb
=> ps_mainmenu (widget)	2.016 ms	0.12 Mb
DisplayStWishlistButton	3.542 ms	0.02 Mb
=> stfeature	0.700 ms	0.01 Mb
=> stfeature	0.255 ms	- Mb
=> stfeature	0.262 ms	- Mb
=> stfeature	0.263 ms	- Mb
=> stfeature	0.251 ms	- Mb
=> stfeature	0.245 ms	- Mb
=> stfeature	0.255 ms	- Mb
=> stfeature	0.258 ms	- Mb
=> stfeature	0.243 ms	- Mb
=> stfeature	0.280 ms	- Mb
=> stfeature	0.261 ms	- Mb
=> stfeature	0.269 ms	- Mb
Header	3.311 ms	0.04 Mb
=> stripe_official	0.035 ms	- Mb
=> customhtml	1.469 ms	0.01 Mb
=> cz_themeoptions	0.428 ms	0.01 Mb
=> psproductcountdown	1.379 ms	0.02 Mb
displayNav1	3.206 ms	0.08 Mb
=> cz_navcmsblock (widget)	3.206 ms	0.08 Mb
ActionFrontControllerSetMedia	3.200 ms	0.07 Mb
=> blockreassurance	2.857 ms	0.07 Mb
=> ps_emailsubscription	0.209 ms	- Mb
=> ps_socialfollow	0.074 ms	- Mb
=> ps_emailalerts	0.060 ms	- Mb
DisplayFooter	2.305 ms	0.19 Mb
=> czuecookie	2.305 ms	0.19 Mb
DisplayStCompareButton	1.977 ms	0.01 Mb
=> stfeature	0.381 ms	0.01 Mb
=> stfeature	0.137 ms	- Mb
=> stfeature	0.156 ms	- Mb
=> stfeature	0.148 ms	- Mb
=> stfeature	0.186 ms	- Mb
=> stfeature	0.140 ms	- Mb
=> stfeature	0.109 ms	- Mb
=> stfeature	0.159 ms	- Mb
=> stfeature	0.145 ms	- Mb
=> stfeature	0.146 ms	- Mb
=> stfeature	0.132 ms	- Mb
=> stfeature	0.138 ms	- Mb
displayFooterAfter	1.432 ms	- Mb
=> cz_blocklink (widget)	1.432 ms	- Mb
DisplayHeader	0.987 ms	0.02 Mb
=> ps_shoppingcart	0.073 ms	- Mb
=> ps_searchbar	0.135 ms	- Mb
=> cz_verticalmenu	0.061 ms	- Mb
=> cz_imageslider	0.067 ms	- Mb
=> cz_instagramfeeds	0.054 ms	- Mb
=> myprestacomments	0.246 ms	- Mb
=> stfeature	0.351 ms	0.01 Mb
DisplayStWishlistTopLink	0.786 ms	0.04 Mb
=> stfeature	0.786 ms	0.04 Mb
Footer	0.716 ms	0.01 Mb
=> customhtml	0.716 ms	0.01 Mb
DisplayLeftColumn	0.715 ms	0.12 Mb
=> ps_facetedsearch	0.715 ms	0.12 Mb
DisplayStCompareTopLink	0.351 ms	0.01 Mb
=> stfeature	0.351 ms	0.01 Mb
DisplayProductListReviews	0.034 ms	- Mb
=> psproductcountdown	0.004 ms	- Mb
=> psproductcountdown	0.002 ms	- Mb
=> psproductcountdown	0.003 ms	- Mb
=> psproductcountdown	0.003 ms	- Mb
=> psproductcountdown	0.003 ms	- Mb
=> psproductcountdown	0.003 ms	- Mb
=> psproductcountdown	0.001 ms	- Mb
=> psproductcountdown	0.003 ms	- Mb
=> psproductcountdown	0.003 ms	- Mb
=> psproductcountdown	0.003 ms	- Mb
=> psproductcountdown	0.002 ms	- Mb
=> psproductcountdown	0.003 ms	- Mb
DisplayFooterAfter	0.008 ms	- Mb
=> cz_themeoptions	0.008 ms	- Mb
22 hook(s)	197.007 ms	10.20 Mb

Module	Time	Memory Usage
blockreassurance	5.692 ms	0.22 Mb
__construct	2.829 ms	0.15 Mb
hookActionFrontControllerSetMedia	2.863 ms	0.07 Mb
ps_emailsubscription	6.064 ms	0.08 Mb
__construct	4.795 ms	0.03 Mb
hookActionFrontControllerSetMedia	0.212 ms	- Mb
displayFooter	1.057 ms	0.05 Mb
ps_socialfollow	2.427 ms	0.07 Mb
__construct	1.224 ms	0.02 Mb
hookActionFrontControllerSetMedia	0.076 ms	- Mb
displayFooter	1.127 ms	0.05 Mb
ps_emailalerts	6.214 ms	0.04 Mb
__construct	6.151 ms	0.04 Mb
hookActionFrontControllerSetMedia	0.063 ms	- Mb
ps_shoppingcart	4.345 ms	0.15 Mb
__construct	0.936 ms	0.02 Mb
hookDisplayHeader	0.076 ms	- Mb
displayTop	3.333 ms	0.14 Mb
ps_searchbar	1.472 ms	0.06 Mb
__construct	0.411 ms	0.02 Mb
hookDisplayHeader	0.137 ms	- Mb
displayTop	0.924 ms	0.04 Mb
cz_verticalmenu	10.269 ms	0.16 Mb
__construct	8.152 ms	0.03 Mb
hookDisplayHeader	0.064 ms	- Mb
displayNavFullWidth	2.053 ms	0.12 Mb
cz_imageslider	4.606 ms	0.10 Mb
__construct	4.536 ms	0.10 Mb
hookDisplayHeader	0.070 ms	- Mb
cz_instagramfeeds	1.376 ms	0.02 Mb
__construct	1.320 ms	0.02 Mb
hookDisplayHeader	0.056 ms	- Mb
myprestacomments	7.143 ms	0.16 Mb
__construct	6.893 ms	0.15 Mb
hookDisplayHeader	0.250 ms	0.01 Mb
stfeature	12.565 ms	0.16 Mb
__construct	5.482 ms	0.06 Mb
hookDisplayHeader	0.355 ms	0.01 Mb
hookDisplayStWishlistTopLink	0.790 ms	0.04 Mb
hookDisplayStCompareTopLink	0.354 ms	0.01 Mb
hookDisplayStWishlistButton	0.704 ms	0.01 Mb
hookDisplayStCompareButton	0.383 ms	0.01 Mb
hookDisplayStWishlistButton	0.258 ms	- Mb
hookDisplayStCompareButton	0.139 ms	- Mb
hookDisplayStWishlistButton	0.265 ms	- Mb
hookDisplayStCompareButton	0.159 ms	- Mb
hookDisplayStWishlistButton	0.266 ms	- Mb
hookDisplayStCompareButton	0.150 ms	- Mb
hookDisplayStWishlistButton	0.254 ms	- Mb
hookDisplayStCompareButton	0.189 ms	- Mb
hookDisplayStWishlistButton	0.248 ms	- Mb
hookDisplayStCompareButton	0.142 ms	- Mb
hookDisplayStWishlistButton	0.257 ms	- Mb
hookDisplayStCompareButton	0.111 ms	- Mb
hookDisplayStWishlistButton	0.261 ms	- Mb
hookDisplayStCompareButton	0.163 ms	- Mb
hookDisplayStWishlistButton	0.245 ms	- Mb
hookDisplayStCompareButton	0.147 ms	- Mb
hookDisplayStWishlistButton	0.283 ms	- Mb
hookDisplayStCompareButton	0.149 ms	- Mb
hookDisplayStWishlistButton	0.265 ms	- Mb
hookDisplayStCompareButton	0.134 ms	- Mb
hookDisplayStWishlistButton	0.272 ms	- Mb
hookDisplayStCompareButton	0.140 ms	- Mb
stripe_official	14.765 ms	0.23 Mb
__construct	14.727 ms	0.23 Mb
hookHeader	0.038 ms	- Mb
customhtml	2.724 ms	0.04 Mb
__construct	0.533 ms	0.02 Mb
hookHeader	1.472 ms	0.01 Mb
hookFooter	0.719 ms	0.01 Mb
cz_themeoptions	21.069 ms	0.31 Mb
__construct	19.779 ms	0.20 Mb
hookHeader	0.431 ms	0.01 Mb
displayFooter	0.850 ms	0.10 Mb
hookDisplayFooterAfter	0.009 ms	- Mb
psproductcountdown	36.151 ms	2.35 Mb
__construct	7.134 ms	0.11 Mb
hookHeader	1.383 ms	0.02 Mb
hookDisplayProductListReviews	0.006 ms	- Mb
hookDisplayProductPriceBlock	0.003 ms	- Mb
hookDisplayProductPriceBlock	0.005 ms	- Mb
hookDisplayProductPriceBlock	0.003 ms	- Mb
hookDisplayProductPriceBlock	2.495 ms	0.20 Mb
hookDisplayProductListReviews	0.004 ms	- Mb
hookDisplayProductPriceBlock	0.003 ms	- Mb
hookDisplayProductPriceBlock	0.002 ms	- Mb
hookDisplayProductPriceBlock	0.002 ms	- Mb
hookDisplayProductPriceBlock	2.474 ms	0.20 Mb
hookDisplayProductListReviews	0.004 ms	- Mb
hookDisplayProductPriceBlock	0.003 ms	- Mb
hookDisplayProductPriceBlock	0.002 ms	- Mb
hookDisplayProductPriceBlock	0.002 ms	- Mb
hookDisplayProductPriceBlock	2.931 ms	0.21 Mb
hookDisplayProductListReviews	0.005 ms	- Mb
hookDisplayProductPriceBlock	0.003 ms	- Mb
hookDisplayProductPriceBlock	0.002 ms	- Mb
hookDisplayProductPriceBlock	0.001 ms	- Mb
hookDisplayProductPriceBlock	2.161 ms	0.18 Mb
hookDisplayProductListReviews	0.005 ms	- Mb
hookDisplayProductPriceBlock	0.004 ms	- Mb
hookDisplayProductPriceBlock	0.002 ms	- Mb
hookDisplayProductPriceBlock	0.002 ms	- Mb
hookDisplayProductPriceBlock	2.274 ms	0.17 Mb
hookDisplayProductListReviews	0.005 ms	- Mb
hookDisplayProductPriceBlock	0.005 ms	- Mb
hookDisplayProductPriceBlock	0.002 ms	- Mb
hookDisplayProductPriceBlock	0.002 ms	- Mb
hookDisplayProductPriceBlock	2.098 ms	0.17 Mb
hookDisplayProductListReviews	0.003 ms	- Mb
hookDisplayProductPriceBlock	0.003 ms	- Mb
hookDisplayProductPriceBlock	0.001 ms	- Mb
hookDisplayProductPriceBlock	0.001 ms	- Mb
hookDisplayProductPriceBlock	2.016 ms	0.17 Mb
hookDisplayProductListReviews	0.004 ms	- Mb
hookDisplayProductPriceBlock	0.003 ms	- Mb
hookDisplayProductPriceBlock	0.003 ms	- Mb
hookDisplayProductPriceBlock	0.002 ms	- Mb
hookDisplayProductPriceBlock	2.000 ms	0.20 Mb
hookDisplayProductListReviews	0.005 ms	- Mb
hookDisplayProductPriceBlock	0.004 ms	- Mb
hookDisplayProductPriceBlock	0.001 ms	- Mb
hookDisplayProductPriceBlock	0.004 ms	- Mb
hookDisplayProductPriceBlock	2.024 ms	0.17 Mb
hookDisplayProductListReviews	0.005 ms	- Mb
hookDisplayProductPriceBlock	0.004 ms	- Mb
hookDisplayProductPriceBlock	0.002 ms	- Mb
hookDisplayProductPriceBlock	0.002 ms	- Mb
hookDisplayProductPriceBlock	2.731 ms	0.17 Mb
hookDisplayProductListReviews	0.004 ms	- Mb
hookDisplayProductPriceBlock	0.003 ms	- Mb
hookDisplayProductPriceBlock	0.002 ms	- Mb
hookDisplayProductPriceBlock	0.001 ms	- Mb
hookDisplayProductPriceBlock	2.129 ms	0.17 Mb
hookDisplayProductListReviews	0.004 ms	- Mb
hookDisplayProductPriceBlock	0.002 ms	- Mb
hookDisplayProductPriceBlock	0.002 ms	- Mb
hookDisplayProductPriceBlock	0.002 ms	- Mb
hookDisplayProductPriceBlock	2.157 ms	0.17 Mb
ps_facetedsearch	15.260 ms	0.30 Mb
__construct	9.695 ms	0.11 Mb
hookProductSearchProvider	4.847 ms	0.07 Mb
hookDisplayLeftColumn	0.718 ms	0.12 Mb
cz_navcmsblock	4.778 ms	0.10 Mb
__construct	1.567 ms	0.02 Mb
displayNav1	3.211 ms	0.08 Mb
ps_customersignin	2.906 ms	0.12 Mb
__construct	0.421 ms	0.02 Mb
displayTop	2.485 ms	0.10 Mb
ps_mainmenu	8.992 ms	0.15 Mb
__construct	6.971 ms	0.03 Mb
displayNavFullWidth	2.021 ms	0.12 Mb
ps_categorytree	97.645 ms	5.70 Mb
__construct	1.352 ms	0.08 Mb
displayLeftColumn	96.293 ms	5.62 Mb
cz_leftbanner	5.739 ms	0.08 Mb
__construct	4.207 ms	0.03 Mb
displayLeftColumn	1.532 ms	0.04 Mb
cz_newproducts	2.461 ms	0.07 Mb
__construct	1.348 ms	0.02 Mb
displayLeftColumn	1.113 ms	0.06 Mb
cz_imagehover	11.547 ms	0.57 Mb
__construct	0.580 ms	0.02 Mb
hookDisplayCzHoverImage	1.617 ms	0.06 Mb
hookDisplayCzHoverImage	0.766 ms	0.05 Mb
hookDisplayCzHoverImage	1.003 ms	0.05 Mb
hookDisplayCzHoverImage	0.826 ms	0.05 Mb
hookDisplayCzHoverImage	0.916 ms	0.05 Mb
hookDisplayCzHoverImage	0.756 ms	0.05 Mb
hookDisplayCzHoverImage	0.807 ms	0.05 Mb
hookDisplayCzHoverImage	0.779 ms	0.05 Mb
hookDisplayCzHoverImage	0.875 ms	0.05 Mb
hookDisplayCzHoverImage	0.892 ms	0.05 Mb
hookDisplayCzHoverImage	0.910 ms	0.05 Mb
hookDisplayCzHoverImage	0.820 ms	0.05 Mb
ps_contactinfo	3.806 ms	0.09 Mb
__construct	0.786 ms	0.02 Mb
displayFooter	3.020 ms	0.07 Mb
ps_linklist	16.461 ms	0.09 Mb
__construct	13.052 ms	0.03 Mb
displayFooter	3.409 ms	0.06 Mb
ps_customeraccountlinks	1.673 ms	0.15 Mb
__construct	0.580 ms	0.02 Mb
displayFooter	1.093 ms	0.13 Mb
cz_themeimages	2.458 ms	0.07 Mb
__construct	1.280 ms	0.02 Mb
displayFooter	1.178 ms	0.06 Mb
czuecookie	3.043 ms	0.21 Mb
__construct	0.734 ms	0.02 Mb
hookDisplayFooter	2.309 ms	0.19 Mb
cz_blocklink	3.371 ms	- Mb
__construct	1.933 ms	0.02 Mb
displayFooterAfter	1.438 ms	- Mb
statsdata	10.743 ms	0.08 Mb
__construct	0.964 ms	0.02 Mb
hookDisplayBeforeBodyClosingTag	9.779 ms	0.07 Mb
30 module(s)	327.764 ms	11.92 Mb

100 queries	SELECT * FROM `psxXX_category` a LEFT JOIN `psxXX_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = XX LEFT JOIN `psxXX_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
24 queries	SELECT image_shop.`cover`, i.`id_image`, il.`legend`, i.`position` FROM `psxXX_image` i INNER JOIN psxXX_image_shop image_shop ON (image_shop.id_image = i.id_image AND image_shop.id_shop = XX) LEFT JOIN `psxXX_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = XX) WHERE i.`id_product` = XX ORDER BY `position`
19 queries	SELECT `id_module` FROM `psxXX_module_shop` WHERE `id_module` = XX AND `id_shop` = XX LIMIT XX
13 queries	SELECT XX FROM `psxXX_specific_price` WHERE id_product = XX LIMIT XX
12 queries	SELECT COUNT(*) FROM `psxXX_pack` WHERE id_product_pack = XX LIMIT XX
12 queries	SELECT product_type FROM `psxXX_product` WHERE id_product = XX LIMIT XX
12 queries	SELECT SUM(quantity) FROM `psxXX_stock_available` WHERE (id_product = XX) AND (id_product_attribute = XX) AND (id_shop = XX) AND (id_shop_group = XX) LIMIT XX
12 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 `psxXX_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 `psxXX_cart_product` cp JOIN `psxXX_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `psxXX_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
12 queries	SELECT name, value, pf.id_feature, f.position, fvl.id_feature_value FROM psxXX_feature_product pf LEFT JOIN psxXX_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = XX) LEFT JOIN psxXX_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = XX) LEFT JOIN psxXX_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = XX) INNER JOIN psxXX_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
12 queries	SELECT pa.`id_product`, a.`color`, pac.`id_product_attribute`, XX qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by FROM `psxXX_product_attribute` pa INNER JOIN psxXX_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = XX) JOIN `psxXX_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`) JOIN `psxXX_attribute` a ON (a.`id_attribute` = pac.`id_attribute`) JOIN `psxXX_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = XX) JOIN `psxXX_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`) WHERE pa.`id_product` IN (XX) AND ag.`is_color_group` = XX GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` ORDER BY a.`position` ASC;
12 queries	SELECT DISTINCT a.`id_attribute`, a.`id_attribute_group`, al.`name` as `attribute`, agl.`name` as `group`,pa.`reference`, pa.`eanXX`, pa.`isbn`, pa.`upc`, pa.`mpn` FROM `psxXX_attribute` a LEFT JOIN `psxXX_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = XX) LEFT JOIN `psxXX_attribute_group_lang` agl ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = XX) LEFT JOIN `psxXX_product_attribute_combination` pac ON (a.`id_attribute` = pac.`id_attribute`) LEFT JOIN `psxXX_product_attribute` pa ON (pac.`id_product_attribute` = pa.`id_product_attribute`) INNER JOIN psxXX_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = XX) INNER JOIN psxXX_attribute_shop attribute_shop ON (attribute_shop.id_attribute = pac.id_attribute AND attribute_shop.id_shop = XX) WHERE pa.`id_product` = XX
12 queries	SELECT * FROM `psxXX_product` a LEFT JOIN `psxXX_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = XX WHERE (a.`id_product` = XX) LIMIT XX
12 queries	SELECT * FROM `psxXX_product_lang` WHERE `id_product` = XX AND `id_shop` = XX
12 queries	SELECT pspcfo.`id_pspcf` FROM `psxXX_pspcf_object` pspcfo LEFT JOIN `psxXX_pspcf` pspcf USING (`id_pspcf`) LEFT JOIN `psxXX_pspcf_shop` pspcfs USING (`id_pspcf`) WHERE pspcfs.`id_shop` IN (XX) AND pspcfo.`type` = "product" AND pspcfo.`id_object` IN (XX) AND pspcfo.`id_product_attribute` IN (XX, XX) ORDER BY pspcfo.`id_product_attribute` DESC, pspcf.`to` ASC, pspcfo.`id_object` DESC LIMIT XX
12 queries	SELECT `id_tax_rules_group` FROM `psxXX_product_shop` WHERE `id_product` = XX AND id_shop=XX LIMIT XX
12 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 `psxXX_product` p INNER JOIN `psxXX_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = XX) LEFT JOIN `psxXX_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)
12 queries	SELECT * FROM `psxXX_product` a LEFT JOIN `psxXX_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = XX LEFT JOIN `psxXX_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
12 queries	SELECT name FROM psxXX_category_lang WHERE id_shop = XX AND id_lang = XX AND id_category = XX LIMIT XX
12 queries	SELECT image_shop.`id_image` FROM `psxXX_image` i INNER JOIN psxXX_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
12 queries	SELECT `id_product_attribute` FROM `psxXX_product_attribute` WHERE `id_product` = XX
12 queries	SELECT `reduction` FROM `psxXX_product_group_reduction_cache` WHERE `id_product` = XX AND `id_group` = XX LIMIT XX
6 queries	SELECT cl.`link_rewrite` FROM `psxXX_category_lang` cl WHERE `id_lang` = XX AND cl.id_shop = XX AND cl.`id_category` = XX LIMIT XX
4 queries	SELECT `id_lang` FROM `psxXX_lang` WHERE `locale` = 'es-mx' OR `language_code` = 'es-mx' LIMIT XX
3 queries	SELECT `name` FROM `psxXX_manufacturer` WHERE `id_manufacturer` = XX AND `active` = XX LIMIT XX
3 queries	SELECT tr.* FROM `psxXX_tax_rule` tr JOIN `psxXX_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
2 queries	SELECT `need_identification_number` FROM `psxXX_country` WHERE `id_country` = XX LIMIT XX
2 queries	SELECT `id_category` FROM `psxXX_category_shop` WHERE `id_category` = XX AND `id_shop` = XX LIMIT XX
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 psxXX_product p LEFT JOIN psxXX_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN psxXX_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN psxXX_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 psxXX_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN psxXX_category_product cp ON (p.id_product = cp.id_product) INNER JOIN psxXX_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = XX AND ps.active = TRUE) INNER JOIN psxXX_category c ON (cp.id_category = c.id_category AND c.active=XX) LEFT JOIN psxXX_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 p.id_manufacturer IN (XX, XX, XX, XX) AND c.nleft>=XX AND c.nright<=XX GROUP BY p.id_product) p INNER JOIN psxXX_feature_product fp ON (p.id_product = fp.id_product) WHERE ((fp.id_feature=XX)) GROUP BY fp.id_feature_value
2 queries	SELECT * FROM `psxXX_currency` a LEFT JOIN `psxXX_currency_lang` `b` ON a.`id_currency` = b.`id_currency` AND b.`id_lang` = XX LEFT JOIN `psxXX_currency_shop` `c` ON a.`id_currency` = c.`id_currency` AND c.`id_shop` = XX WHERE (a.`id_currency` = XX) LIMIT XX
2 queries	SELECT m.*, ml.`description`, ml.`short_description` FROM `psxXX_manufacturer` m INNER JOIN psxXX_manufacturer_shop manufacturer_shop ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = XX)INNER JOIN `psxXX_manufacturer_lang` ml ON (m.`id_manufacturer` = ml.`id_manufacturer` AND ml.`id_lang` = XX)WHERE XX AND m.`active` = XX ORDER BY m.`name` ASC
2 queries	SELECT XX FROM `psxXX_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

Name	Instances	Source
Category	106	/controllers/front/listing/CategoryController.php:78 (__construct) [id: 2] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 3] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 195] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 196] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 197] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 198] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 199] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 6] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 10] /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: 54] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 69] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 70] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 71] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 72] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 73] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 74] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 75] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 76] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 77] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 78] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 79] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 80] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 81] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 82] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 83] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 84] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 85] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 86] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 87] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 88] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 89] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 90] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 91] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 92] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 93] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 94] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 95] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 97] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 99] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 101] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 102] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 103] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 104] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 105] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 106] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 107] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 108] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 109] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 110] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 111] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 113] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 114] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 117] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 118] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 121] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 122] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 123] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 124] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 128] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 132] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 133] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 136] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 137] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 139] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 143] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 150] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 151] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 152] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 153] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 154] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 156] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 159] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 160] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 162] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 165] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 173] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 175] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 177] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 178] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 183] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 184] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 194] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 278] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 280] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 310] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 312] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 328] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 335] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 367] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 374] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 407] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 464] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 1646] /classes/Meta.php:380 (__construct) [id: 2] /classes/Link.php:402 (__construct) [id: 2] /classes/Link.php:402 (__construct) [id: 2] /classes/PrestaShopCollection.php:385 (hydrateCollection) [id: ] /modules/ps_facetedsearch/src/Product/Search.php:364 (__construct) [id: 2] /modules/ps_facetedsearch/src/Filters/Block.php:157 (__construct) [id: 2] /modules/ps_categorytree/ps_categorytree.php:364 (getParentsCategories) [id: 2]
Product	60	/classes/Link.php:113 (__construct) [id: 13] /classes/Link.php:113 (__construct) [id: 2685] /classes/Link.php:113 (__construct) [id: 1674] /classes/Link.php:113 (__construct) [id: 1690] /classes/Link.php:113 (__construct) [id: 1706] /classes/Link.php:113 (__construct) [id: 1707] /classes/Link.php:113 (__construct) [id: 2756] /classes/Link.php:113 (__construct) [id: 2769] /classes/Link.php:113 (__construct) [id: 1751] /classes/Link.php:113 (__construct) [id: 1762] /classes/Link.php:113 (__construct) [id: 1805] /classes/Link.php:113 (__construct) [id: 2838] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 13] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 2685] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 1674] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 1690] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 1706] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 1707] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 2756] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 2769] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 1751] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 1762] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 1805] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 2838] /classes/Link.php:113 (__construct) [id: 13] /classes/Link.php:113 (__construct) [id: 2685] /classes/Link.php:113 (__construct) [id: 1674] /classes/Link.php:113 (__construct) [id: 1690] /classes/Link.php:113 (__construct) [id: 1706] /classes/Link.php:113 (__construct) [id: 1707] /classes/Link.php:113 (__construct) [id: 2756] /classes/Link.php:113 (__construct) [id: 2769] /classes/Link.php:113 (__construct) [id: 1751] /classes/Link.php:113 (__construct) [id: 1762] /classes/Link.php:113 (__construct) [id: 1805] /classes/Link.php:113 (__construct) [id: 2838] /modules/cz_imagehover/cz_imagehover.php:73 (__construct) [id: 13] /modules/psproductcountdown/psproductcountdown.php:1574 (__construct) [id: 13] /modules/cz_imagehover/cz_imagehover.php:73 (__construct) [id: 2685] /modules/psproductcountdown/psproductcountdown.php:1574 (__construct) [id: 2685] /modules/cz_imagehover/cz_imagehover.php:73 (__construct) [id: 1674] /modules/psproductcountdown/psproductcountdown.php:1574 (__construct) [id: 1674] /modules/cz_imagehover/cz_imagehover.php:73 (__construct) [id: 1690] /modules/psproductcountdown/psproductcountdown.php:1574 (__construct) [id: 1690] /modules/cz_imagehover/cz_imagehover.php:73 (__construct) [id: 1706] /modules/psproductcountdown/psproductcountdown.php:1574 (__construct) [id: 1706] /modules/cz_imagehover/cz_imagehover.php:73 (__construct) [id: 1707] /modules/psproductcountdown/psproductcountdown.php:1574 (__construct) [id: 1707] /modules/cz_imagehover/cz_imagehover.php:73 (__construct) [id: 2756] /modules/psproductcountdown/psproductcountdown.php:1574 (__construct) [id: 2756] /modules/cz_imagehover/cz_imagehover.php:73 (__construct) [id: 2769] /modules/psproductcountdown/psproductcountdown.php:1574 (__construct) [id: 2769] /modules/cz_imagehover/cz_imagehover.php:73 (__construct) [id: 1751] /modules/psproductcountdown/psproductcountdown.php:1574 (__construct) [id: 1751] /modules/cz_imagehover/cz_imagehover.php:73 (__construct) [id: 1762] /modules/psproductcountdown/psproductcountdown.php:1574 (__construct) [id: 1762] /modules/cz_imagehover/cz_imagehover.php:73 (__construct) [id: 1805] /modules/psproductcountdown/psproductcountdown.php:1574 (__construct) [id: 1805] /modules/cz_imagehover/cz_imagehover.php:73 (__construct) [id: 2838] /modules/psproductcountdown/psproductcountdown.php:1574 (__construct) [id: 2838]
Country	5	/config/config.inc.php:146 (__construct) [id: 144] /classes/AddressFormat.php:404 (__construct) [id: 144] /classes/controller/FrontController.php:1779 (__construct) [id: 144] /classes/AddressFormat.php:404 (__construct) [id: 144] /modules/ps_contactinfo/ps_contactinfo.php:105 (__construct) [id: 144]
State	5	/classes/AddressFormat.php:404 (__construct) [id: 63] /classes/controller/FrontController.php:1778 (__construct) [id: 63] /classes/AddressFormat.php:404 (__construct) [id: 63] /modules/ps_contactinfo/ps_contactinfo.php:94 (__construct) [id: 63] /modules/ps_contactinfo/ps_contactinfo.php:104 (__construct) [id: 63]
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: ]
Language	3	/config/config.inc.php:211 (__construct) [id: 2] /classes/Tools.php:641 (__construct) [id: 2] /classes/Tools.php:560 (__construct) [id: 2]
Currency	3	/classes/Tools.php:690 (getCurrencyInstance) [id: 2] /src/Adapter/Currency/CurrencyDataProvider.php:101 (__construct) [id: 2] /src/Adapter/Currency/CurrencyDataProvider.php:101 (__construct) [id: 1]
AddressFormat	2	/classes/controller/FrontController.php:1773 (generateAddress) [id: ] /modules/ps_contactinfo/ps_contactinfo.php:91 (generateAddress) [id: ]
Tax	2	/classes/tax/TaxRulesTaxManager.php:116 (__construct) [id: 53] /classes/tax/TaxRulesTaxManager.php:116 (__construct) [id: 53]
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]
CMS	1	/modules/czuecookie/czuecookie.php:135 (__construct) [id: 3]
Gender	1	/classes/controller/FrontController.php:1702 (__construct) [id: 0]
Risk	1	/classes/controller/FrontController.php:1705 (__construct) [id: ]
Group	1	/classes/Cart.php:249 (getCurrent) [id: 1]
Customer	1	/config/config.inc.php:264 (__construct) [id: ]
ShopGroup	1	/classes/shop/Shop.php:561 (__construct) [id: 1]
ConnectionsSource	1	/modules/statsdata/statsdata.php:119 (logHttpReferer) [id: ]

#	Query	Time (ms)	Rows	Filesort	Group By	Location
177	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 psx1_product p LEFT JOIN psx1_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN psx1_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN psx1_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 psx1_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN psx1_category_product cp ON (p.id_product = cp.id_product) INNER JOIN psx1_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN psx1_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN psx1_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 c.nleft>=2 AND c.nright<=4175 GROUP BY p.id_product) p GROUP BY p.id_manufacturer	92.696 ms	13126129	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)
387	SELECT SQL_NO_CACHE c., cl. FROM `psx1_category` c INNER JOIN psx1_category_shop category_shop ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1) LEFT JOIN `psx1_category_lang` cl ON c.`id_category` = cl.`id_category` AND cl.id_shop = 1 LEFT JOIN `psx1_category_group` cg ON c.`id_category` = cg.`id_category` RIGHT JOIN `psx1_category` c2 ON c2.`id_category` = 2 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright` WHERE 1 AND c.`level_depth` <= 11 AND `id_lang` = 2 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	57.517 ms	2071	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:1088 (renderWidget) /tools/profiling/Hook.php:64 (coreRenderWidget) /classes/Hook.php:1019 (coreRenderWidget) /config/smarty.config.inc.php:201 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/prod/smarty/compile/Bigsoholayouts_layout_left_column_tpl/79/53/21/7953218a69a5faaa48c4e3b281b371e70f946b1d_2.file.layout-both-columns.tpl.php:257 (__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/prod/smarty/compile/Bigsoholayouts_layout_left_column_tpl/79/53/21/7953218a69a5faaa48c4e3b281b371e70f946b1d_2.file.layout-both-columns.tpl.php:91 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_681286d9a87275_76185590) /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/prod/smarty/compile/Bigsoholayouts_layout_left_column_tpl/b6/08/0e/b6080e4e76a0eedaeefd3938168fd139cbd9e0d8_2.file.layout-left-column.tpl.php:38 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_681286d9a75990_86582140) /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/prod/smarty/compile/Bigsoholayouts_layout_left_column_tpl/54/05/5a/54055a4729da76c67808f06a50262121f66a0539_2.file.product-list.tpl.php:44 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_681286d9a6f127_57663954) /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/prod/smarty/compile/Bigsoholayouts_layout_left_column_tpl/16/b1/c0/16b1c0714870764f7b1ec50b63a60fd9a3641ec0_2.file.category.tpl.php:38 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_681286d9a5eae0_25470335) /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/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)
320	SELECT SQL_NO_CACHE 1 FROM `psx1_specific_price` WHERE id_product = 1805 LIMIT 1	10.598 ms	1			/classes/SpecificPrice.php:435 /classes/SpecificPrice.php:523 (couldHaveSpecificPrice) /classes/Product.php:3827 (getSpecificPrice) /classes/Product.php:3717 (priceCalculation) /classes/Product.php:5692 (getPriceStatic) /classes/ProductAssembler.php:209 (getProductProperties) /classes/controller/ProductListingFrontController.php:108 (assembleProducts) /classes/controller/ProductListingFrontController.php:379 (prepareMultipleProductsForTemplate) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
205	SELECT SQL_NO_CACHE image_shop.`id_image` FROM `psx1_image` i INNER JOIN psx1_image_shop image_shop ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1) WHERE i.`id_product` = 2685 AND image_shop.`cover` = 1 LIMIT 1	10.559 ms	1			/classes/Product.php:3570 /classes/Product.php:5643 (getCover) /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)
172	SELECT SQL_NO_CACHE c.`id_category`, cl.`name` FROM `psx1_category` c INNER JOIN psx1_category_shop category_shop ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1) LEFT JOIN `psx1_category_lang` cl ON c.`id_category` = cl.`id_category` AND cl.id_shop = 1 WHERE 1 AND `id_lang` = 2 AND c.`active` = 1 ORDER BY c.nleft, c.position	9.264 ms	2071	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)
199	SELECT SQL_NO_CACHE COUNT(*) FROM `psx1_pack` WHERE id_product_pack = 13 LIMIT 1	6.337 ms	1			/classes/Pack.php:89 /classes/Product.php:4344 (isPack) /classes/Product.php:5802 (getQuantity) /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)
490	INSERT INTO `psx1_connections_source` (`id_connections`, `http_referer`, `request_uri`, `keywords`, `date_add`) VALUES ('2704753', '', 'whatabox.mx/mx/2-inicio?q=Marca-AFORE-EZVIZ-Stylos-CYBERPOWER', '', '2025-05-01 15:47:43')	6.299 ms	1			/classes/ObjectModel.php:622 /classes/ConnectionsSource.php:105 (add) /modules/statsdata/statsdata.php:119 (logHttpReferer) /modules/statsdata/statsdata.php:74 (getScriptCustomerPagesViews) /classes/Hook.php:1077 (hookDisplayBeforeBodyClosingTag) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:418 (coreCallHook) /classes/Hook.php:983 (callHookOn) /config/smarty.config.inc.php:201 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/prod/smarty/compile/Bigsoholayouts_layout_left_column_tpl/79/53/21/7953218a69a5faaa48c4e3b281b371e70f946b1d_2.file.layout-both-columns.tpl.php:381 (__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/prod/smarty/compile/Bigsoholayouts_layout_left_column_tpl/79/53/21/7953218a69a5faaa48c4e3b281b371e70f946b1d_2.file.layout-both-columns.tpl.php:125 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_681286d9a87275_76185590) /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/prod/smarty/compile/Bigsoholayouts_layout_left_column_tpl/b6/08/0e/b6080e4e76a0eedaeefd3938168fd139cbd9e0d8_2.file.layout-left-column.tpl.php:38 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_681286d9a75990_86582140) /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/prod/smarty/compile/Bigsoholayouts_layout_left_column_tpl/54/05/5a/54055a4729da76c67808f06a50262121f66a0539_2.file.product-list.tpl.php:44 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_681286d9a6f127_57663954) /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/prod/smarty/compile/Bigsoholayouts_layout_left_column_tpl/16/b1/c0/16b1c0714870764f7b1ec50b63a60fd9a3641ec0_2.file.category.tpl.php:38 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_681286d9a5eae0_25470335) /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/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)
202	SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity, COALESCE(SUM(first_level_quantity), 0) as quantity FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity FROM `psx1_cart_product` cp WHERE cp.`id_product_attribute` = 0 AND cp.`id_cart` = 0 AND cp.`id_product` = 13 UNION SELECT 0 as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity FROM `psx1_cart_product` cp JOIN `psx1_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `psx1_product` pr ON p.`id_product_pack` = pr.`id_product` WHERE cp.`id_product_attribute` = 0 AND cp.`id_cart` = 0 AND p.`id_product_item` = 13 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1	6.030 ms	0			/classes/Cart.php:1430 /classes/Product.php:4361 (getProductQuantity) /classes/Product.php:5802 (getQuantity) /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)
328	SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position, fvl.id_feature_value FROM psx1_feature_product pf LEFT JOIN psx1_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 2) LEFT JOIN psx1_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 2) LEFT JOIN psx1_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 2) INNER JOIN psx1_feature_shop feature_shop ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1) WHERE pf.id_product = 1805 ORDER BY f.position ASC	5.279 ms	1	Yes		/classes/Product.php:6021 /classes/Product.php:5824 (getFrontFeaturesStatic) /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)
193	SELECT SQL_NO_CACHE tr.* FROM `psx1_tax_rule` tr JOIN `psx1_tax_rules_group` trg ON (tr.`id_tax_rules_group` = trg.`id_tax_rules_group`) WHERE trg.`active` = 1 AND tr.`id_country` = 144 AND tr.`id_tax_rules_group` = 53 AND tr.`id_state` IN (0, 63) AND ('0' BETWEEN tr.`zipcode_from` AND tr.`zipcode_to` OR (tr.`zipcode_to` = 0 AND tr.`zipcode_from` IN(0, '0'))) ORDER BY tr.`zipcode_from` DESC, tr.`zipcode_to` DESC, tr.`id_state` DESC, tr.`id_country` DESC	4.864 ms	1			/classes/tax/TaxRulesTaxManager.php:109 /classes/Product.php:3926 (getTaxCalculator) /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)
192	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 `psx1_hook_module` hm STRAIGHT_JOIN `psx1_hook` h ON (h.id_hook = hm.id_hook AND hm.id_shop = 1) STRAIGHT_JOIN `psx1_module` as m ON (m.id_module = hm.id_module) ORDER BY hm.position	4.063 ms	318			/classes/Hook.php:456 /classes/Hook.php:493 (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)
196	SELECT SQL_NO_CACHE `reduction` FROM `psx1_product_group_reduction_cache` WHERE `id_product` = 13 AND `id_group` = 1 LIMIT 1	3.574 ms	0			/classes/GroupReduction.php:156 /classes/Product.php:3990 (getValueForProduct) /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)
203	SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position, fvl.id_feature_value FROM psx1_feature_product pf LEFT JOIN psx1_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 2) LEFT JOIN psx1_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 2) LEFT JOIN psx1_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 2) INNER JOIN psx1_feature_shop feature_shop ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1) WHERE pf.id_product = 13 ORDER BY f.position ASC	3.363 ms	1	Yes		/classes/Product.php:6021 /classes/Product.php:5824 (getFrontFeaturesStatic) /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)
14	SELECT SQL_NO_CACHE h.`name` as hook, m.`id_module`, h.`id_hook`, m.`name` as module FROM `psx1_module` m INNER JOIN psx1_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 `psx1_hook_module` `hm` ON hm.`id_module` = m.`id_module` INNER JOIN `psx1_hook` `h` ON hm.`id_hook` = h.`id_hook` LEFT JOIN `psx1_module_group` `mg` ON mg.`id_module` = m.`id_module` WHERE (h.`name` != "paymentOptions") AND (hm.`id_shop` = 1) AND (mg.id_shop = 1 AND mg.`id_group` IN (1)) GROUP BY hm.id_hook, hm.id_module ORDER BY hm.`position`	2.756 ms	318	Yes	Yes	/classes/Hook.php:1267 /classes/Hook.php:735 (getAllHookRegistrations) /classes/Hook.php:842 (getHookModuleExecList) /classes/Dispatcher.php:606 (exec) /classes/Dispatcher.php:243 (loadRoutes) /classes/Dispatcher.php:201 (__construct) /index.php:28 (getInstance)
180	REPLACE INTO psx1_layered_filter_block (hash, data) VALUES ("e11f755098ed30eccc9d02d57f61b975", "a:1:{s:7:\"filters\";a:7:{i:0;a:7:{s:9:\"type_lite\";s:12:\"availability\";s:4:\"type\";s:12:\"availability\";s:6:\"id_key\";i:0;s:4:\"name\";s:14:\"Disponibilidad\";s:6:\"values\";a:2:{i:2;a:2:{s:4:\"name\";s:13:\"En existencia\";s:3:\"nbr\";i:18;}i:0;a:2:{s:4:\"name\";s:13:\"No disponible\";s:3:\"nbr\";i:0;}}s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";s:1:\"0\";}i:1;a:7:{s:9:\"type_lite\";s:6:\"extras\";s:4:\"type\";s:6:\"extras\";s:6:\"id_key\";i:0;s:4:\"name\";s:10:\"Selections\";s:6:\"values\";a:3:{s:4:\"sale\";a:2:{s:4:\"name\";s:12:\"¡En oferta!\";s:3:\"nbr\";i:1;}s:3:\"new\";a:2:{s:4:\"name\";s:14:\"Nuevo producto\";s:3:\"nbr\";i:17;}s:8:\"discount\";a:2:{s:4:\"name\";s:10:\"Discounted\";s:3:\"nbr\";i:0;}}s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";s:1:\"0\";}i:2;a:12:{s:9:\"type_lite\";s:5:\"price\";s:4:\"type\";s:5:\"price\";s:6:\"id_key\";i:0;s:4:\"name\";s:6:\"Precio\";s:3:\"max\";d:20523;s:3:\"min\";d:197;s:4:\"unit\";s:1:\"$\";s:14:\"specifications\";a:11:{s:6:\"symbol\";a:11:{i:0;s:1:\".\";i:1;s:1:\",\";i:2;s:1:\";\";i:3;s:1:\"%\";i:4;s:1:\"-\";i:5;s:1:\"+\";i:6;s:1:\"E\";i:7;s:2:\"×\";i:8;s:3:\"‰\";i:9;s:3:\"∞\";i:10;s:3:\"NaN\";}s:12:\"currencyCode\";s:3:\"MXN\";s:14:\"currencySymbol\";s:1:\"$\";s:13:\"numberSymbols\";a:11:{i:0;s:1:\".\";i:1;s:1:\",\";i:2;s:1:\";\";i:3;s:1:\"%\";i:4;s:1:\"-\";i:5;s:1:\"+\";i:6;s:1:\"E\";i:7;s:2:\"×\";i:8;s:3:\"‰\";i:9;s:3:\"∞\";i:10;s:3:\"NaN\";}s:15:\"positivePattern\";s:10:\"¤#,##0.00\";s:15:\"negativePattern\";s:11:\"-¤#,##0.00\";s:17:\"maxFractionDigits\";i:0;s:17:\"minFractionDigits\";i:0;s:12:\"groupingUsed\";b:1;s:16:\"primaryGroupSize\";i:3;s:18:\"secondaryGroupSize\";i:3;}s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";i:3;s:3:\"nbr\";i:18;s:5:\"value\";N;}i:3;a:7:{s:9:\"type_lite\";s:8:\"category\";s:4:\"type\";s:8:\"category\";s:6:\"id_key\";i:0;s:4:\"name\";s:11:\"Categorías\";s:6:\"values\";a:7:{i:54;a:2:{s:4:\"name\";s:17:\"Control de acceso\";s:3:\"nbr\";s:1:\"8\";}i:79;a:2:{s:4:\"name\";s:26:\"Videoporteros e Interfonos\";s:3:\"nbr\";s:1:\"4\";}i:84;a:2:{s:4:\"name\";s:10:\"Cerraduras\";s:3:\"nbr\";s:1:\"4\";}i:122;a:2:{s:4:\"name\";s:16:\"Videoporteros IP\";s:3:\"nbr\";s:1:\"3\";}i:153;a:2:{s:4:\"name\";s:25:\"Videoporteros IP Doorbell\";s:3:\"nbr\";s:1:\"1\";}i:196;a:2:{s:4:\"name\";s:12:\"Iluminación\";s:3:\"nbr\";s:1:\"4\";}i:199;a:2:{s:4:\"name\";s:14:\"Energía Solar\";s:3:\"nbr\";s:1:\"5\";}}s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";s:1:\"0\";}i:4;a:7:{s:9:\"type_lite\";s:12:\"manufacturer\";s:4:\"type\";s:12:\"manufacturer\";s:6:\"id_key\";i:0;s:4:\"name\";s:5:\"Marca\";s:6:\"values\";a:137:{i:1;a:2:{s:4:\"name\";s:2:\"HP\";s:3:\"nbr\";s:1:\"3\";}i:2;a:2:{s:4:\"name\";s:5:\"Dahua\";s:3:\"nbr\";s:1:\"5\";}i:3;a:2:{s:4:\"name\";s:4:\"DELL\";s:3:\"nbr\";s:1:\"2\";}i:5;a:3:{s:4:\"name\";s:6:\"Stylos\";s:3:\"nbr\";s:1:\"1\";s:7:\"checked\";b:1;}i:6;a:2:{s:4:\"name\";s:6:\"Acteck\";s:3:\"nbr\";s:1:\"1\";}i:7;a:2:{s:4:\"name\";s:7:\"SAMSUNG\";s:3:\"nbr\";s:1:\"1\";}i:9;a:2:{s:4:\"name\";s:5:\"DITEK\";s:3:\"nbr\";s:1:\"3\";}i:11;a:2:{s:4:\"name\";s:18:\"LINKEDPRO BY EPCOM\";s:3:\"nbr\";s:3:\"230\";}i:12;a:2:{s:4:\"name\";s:16:\"EPCOM INDUSTRIAL\";s:3:\"nbr\";s:2:\"27\";}i:13;a:2:{s:4:\"name\";s:10:\"POLYPHASER\";s:3:\"nbr\";s:1:\"4\";}i:14;a:2:{s:4:\"name\";s:6:\"FANVIL\";s:3:\"nbr\";s:2:\"33\";}i:15;a:2:{s:4:\"name\";s:6:\"PLANET\";s:3:\"nbr\";s:2:\"49\";}i:17;a:2:{s:4:\"name\";s:16:\"CAMBIUM NETWORKS\";s:3:\"nbr\";s:2:\"19\";}i:19;a:2:{s:4:\"name\";s:9:\"HIKVISION\";s:3:\"nbr\";s:3:\"163\";}i:20;a:2:{s:4:\"name\";s:8:\"MEITRACK\";s:3:\"nbr\";s:1:\"1\";}i:21;a:2:{s:4:\"name\";s:11:\"GRANDSTREAM\";s:3:\"nbr\";s:2:\"59\";}i:22;a:2:{s:4:\"name\";s:18:\"ALTAI TECHNOLOGIES\";s:3:\"nbr\";s:1:\"6\";}i:25;a:2:{s:4:\"name\";s:8:\"MEANWELL\";s:3:\"nbr\";s:2:\"24\";}i:27;a:2:{s:4:\"name\";s:7:\"PANDUIT\";s:3:\"nbr\";s:3:\"158\";}i:28;a:2:{s:4:\"name\";s:6:\"GEWISS\";s:3:\"nbr\";s:1:\"6\";}i:29;a:2:{s:4:\"name\";s:10:\"CYBERPOWER\";s:3:\"nbr\";s:2:\"44\";}i:30;a:2:{s:4:\"name\";s:8:\"MIKROTIK\";s:3:\"nbr\";s:2:\"61\";}i:31;a:2:{s:4:\"name\";s:15:\"MIMOSA NETWORKS\";s:3:\"nbr\";s:1:\"9\";}i:32;a:2:{s:4:\"name\";s:15:\"EPCOM POWERLINE\";s:3:\"nbr\";s:3:\"248\";}i:33;a:2:{s:4:\"name\";s:5:\"EPCOM\";s:3:\"nbr\";s:1:\"8\";}i:36;a:2:{s:4:\"name\";s:14:\"ALLIED TELESIS\";s:3:\"nbr\";s:1:\"9\";}i:37;a:2:{s:4:\"name\";s:11:\"RF ELEMENTS\";s:3:\"nbr\";s:2:\"10\";}i:39;a:2:{s:4:\"name\";s:6:\"CAMESA\";s:3:\"nbr\";s:1:\"5\";}i:40;a:2:{s:4:\"name\";s:9:\"PRECISION\";s:3:\"nbr\";s:3:\"105\";}i:41;a:2:{s:4:\"name\";s:8:\"Mercusys\";s:3:\"nbr\";s:1:\"6\";}i:43;a:2:{s:4:\"name\";s:9:\"FIBERHOME\";s:3:\"nbr\";s:2:\"35\";}i:44;a:2:{s:4:\"name\";s:5:\"JABRA\";s:3:\"nbr\";s:1:\"9\";}i:48;a:2:{s:4:\"name\";s:22:\"LINKEDPRO BY FIBERHOME\";s:3:\"nbr\";s:2:\"16\";}i:50;a:2:{s:4:\"name\";s:14:\"EPCOM TITANIUM\";s:3:\"nbr\";s:1:\"1\";}i:52;a:2:{s:4:\"name\";s:3:\"PLP\";s:3:\"nbr\";s:2:\"14\";}i:54;a:2:{s:4:\"name\";s:5:\"ANCLO\";s:3:\"nbr\";s:2:\"70\";}i:55;a:2:{s:4:\"name\";s:6:\"RUIJIE\";s:3:\"nbr\";s:2:\"90\";}i:56;a:2:{s:4:\"name\";s:20:\"HIKSEMI by HIKVISION\";s:3:\"nbr\";s:2:\"29\";}i:58;a:2:{s:4:\"name\";s:26:\"EPCOM INDUSTRIAL SIGNALING\";s:3:\"nbr\";s:1:\"3\";}i:61;a:2:{s:4:\"name\";s:6:\"HUAWEI\";s:3:\"nbr\";s:2:\"12\";}i:62;a:2:{s:4:\"name\";s:7:\"HOFFMAN\";s:3:\"nbr\";s:1:\"1\";}i:63;a:2:{s:4:\"name\";s:19:\"HiLook by HIKVISION\";s:3:\"nbr\";s:1:\"1\";}i:64;a:2:{s:4:\"name\";s:9:\"LINKEDPRO\";s:3:\"nbr\";s:1:\"3\";}i:67;a:2:{s:4:\"name\";s:6:\"MAKITA\";s:3:\"nbr\";s:2:\"24\";}i:68;a:2:{s:4:\"name\";s:6:\"SIEMON\";s:3:\"nbr\";s:1:\"3\";}i:70;a:2:{s:4:\"name\";s:5:\"DELTA\";s:3:\"nbr\";s:1:\"2\";}i:71;a:2:{s:4:\"name\";s:11:\"BLUEPARROTT\";s:3:\"nbr\";s:1:\"1\";}i:73;a:2:{s:4:\"name\";s:8:\"NetPoint\";s:3:\"nbr\";s:1:\"1\";}i:74;a:2:{s:4:\"name\";s:11:\"KLEIN TOOLS\";s:3:\"nbr\";s:2:\"29\";}i:76;a:2:{s:4:\"name\";s:6:\"ATLONA\";s:3:\"nbr\";s:1:\"3\";}i:158;a:2:{s:4:\"name\";s:22:\"HONEYWELL HOME RESIDEO\";s:3:\"nbr\";s:1:\"1\";}i:159;a:2:{s:4:\"name\";s:8:\"ALTRONIX\";s:3:\"nbr\";s:1:\"6\";}i:160;a:2:{s:4:\"name\";s:26:\"ROSSLARE SECURITY PRODUCTS\";s:3:\"nbr\";s:2:\"33\";}i:161;a:2:{s:4:\"name\";s:12:\"ELK PRODUCTS\";s:3:\"nbr\";s:1:\"2\";}i:162;a:2:{s:4:\"name\";s:18:\"ZKTECO - AccessPRO\";s:3:\"nbr\";s:1:\"9\";}i:163;a:2:{s:4:\"name\";s:5:\"KOCOM\";s:3:\"nbr\";s:2:\"19\";}i:164;a:2:{s:4:\"name\";s:17:\"ENFORCER SECOLARM\";s:3:\"nbr\";s:2:\"14\";}i:165;a:2:{s:4:\"name\";s:8:\"CONDUMEX\";s:3:\"nbr\";s:1:\"1\";}i:166;a:2:{s:4:\"name\";s:19:\"PHILLIPS-ASSA ABLOY\";s:3:\"nbr\";s:2:\"19\";}i:167;a:2:{s:4:\"name\";s:9:\"ACCESSPRO\";s:3:\"nbr\";s:3:\"327\";}i:168;a:2:{s:4:\"name\";s:5:\"SFIRE\";s:3:\"nbr\";s:2:\"26\";}i:169;a:2:{s:4:\"name\";s:4:\"CAME\";s:3:\"nbr\";s:2:\"39\";}i:170;a:2:{s:4:\"name\";s:9:\"DORMAKABA\";s:3:\"nbr\";s:1:\"5\";}i:171;a:2:{s:4:\"name\";s:10:\"ASSA ABLOY\";s:3:\"nbr\";s:2:\"23\";}i:172;a:2:{s:4:\"name\";s:15:\"RCI - DORMAKABA\";s:3:\"nbr\";s:2:\"15\";}i:173;a:2:{s:4:\"name\";s:6:\"VIAKON\";s:3:\"nbr\";s:1:\"9\";}i:174;a:2:{s:4:\"name\";s:6:\"ZKTECO\";s:3:\"nbr\";s:2:\"35\";}i:175;a:2:{s:4:\"name\";s:7:\"Century\";s:3:\"nbr\";s:2:\"29\";}i:176;a:2:{s:4:\"name\";s:3:\"HID\";s:3:\"nbr\";s:2:\"38\";}i:177;a:2:{s:4:\"name\";s:20:\"AccessPRO Industrial\";s:3:\"nbr\";s:1:\"3\";}i:178;a:2:{s:4:\"name\";s:3:\"STI\";s:3:\"nbr\";s:1:\"6\";}i:179;a:2:{s:4:\"name\";s:3:\"IDP\";s:3:\"nbr\";s:1:\"8\";}i:180;a:2:{s:4:\"name\";s:7:\"SUPREMA\";s:3:\"nbr\";s:2:\"17\";}i:181;a:2:{s:4:\"name\";s:3:\"BEA\";s:3:\"nbr\";s:1:\"7\";}i:182;a:2:{s:4:\"name\";s:5:\"NEDAP\";s:3:\"nbr\";s:1:\"2\";}i:183;a:2:{s:4:\"name\";s:25:\"ALARM CONTROLS-ASSA ABLOY\";s:3:\"nbr\";s:1:\"6\";}i:184;a:2:{s:4:\"name\";s:11:\"POWER SONIC\";s:3:\"nbr\";s:2:\"24\";}i:185;a:2:{s:4:\"name\";s:4:\"FAAC\";s:3:\"nbr\";s:3:\"114\";}i:186;a:2:{s:4:\"name\";s:12:\"M2M SERVICES\";s:3:\"nbr\";s:1:\"2\";}i:187;a:2:{s:4:\"name\";s:9:\"COMUNELLO\";s:3:\"nbr\";s:2:\"34\";}i:188;a:2:{s:4:\"name\";s:12:\"DKS DOORKING\";s:3:\"nbr\";s:2:\"13\";}i:189;a:2:{s:4:\"name\";s:7:\"GENESIS\";s:3:\"nbr\";s:1:\"2\";}i:190;a:3:{s:4:\"name\";s:5:\"EZVIZ\";s:3:\"nbr\";s:2:\"12\";s:7:\"checked\";b:1;}i:191;a:2:{s:4:\"name\";s:17:\"TESA - ASSA ABLOY\";s:3:\"nbr\";s:1:\"4\";}i:192;a:2:{s:4:\"name\";s:6:\"YONUSA\";s:3:\"nbr\";s:1:\"2\";}i:193;a:2:{s:4:\"name\";s:15:\"IDEMIA (MORPHO)\";s:3:\"nbr\";s:1:\"4\";}i:194;a:2:{s:4:\"name\";s:25:\"RANGER SECURITY DETECTORS\";s:3:\"nbr\";s:1:\"2\";}i:195;a:2:{s:4:\"name\";s:15:\"YALE-ASSA ABLOY\";s:3:\"nbr\";s:2:\"11\";}i:196;a:2:{s:4:\"name\";s:4:\"LOCK\";s:3:\"nbr\";s:2:\"13\";}i:197;a:2:{s:4:\"name\";s:6:\"AKUVOX\";s:3:\"nbr\";s:1:\"6\";}i:198;a:2:{s:4:\"name\";s:13:\"OPEN DESK PRO\";s:3:\"nbr\";s:1:\"5\";}i:199;a:2:{s:4:\"name\";s:12:\"SYSCOM VIDEO\";s:3:\"nbr\";s:1:\"2\";}i:200;a:2:{s:4:\"name\";s:9:\"HONEYWELL\";s:3:\"nbr\";s:1:\"2\";}i:201;a:2:{s:4:\"name\";s:9:\"PANASONIC\";s:3:\"nbr\";s:1:\"4\";}i:202;a:2:{s:4:\"name\";s:16:\"Ruiz Electronics\";s:3:\"nbr\";s:1:\"1\";}i:203;a:2:{s:4:\"name\";s:19:\"MEDECO - ASSA ABLOY\";s:3:\"nbr\";s:1:\"2\";}i:204;a:2:{s:4:\"name\";s:8:\"LANDWELL\";s:3:\"nbr\";s:1:\"1\";}i:205;a:2:{s:4:\"name\";s:21:\"SECURITRON-ASSA ABLOY\";s:3:\"nbr\";s:1:\"3\";}i:206;a:2:{s:4:\"name\";s:17:\"ELECTRONIC DESIGN\";s:3:\"nbr\";s:1:\"1\";}i:207;a:2:{s:4:\"name\";s:17:\"BRUKEN ASSA ABLOY\";s:3:\"nbr\";s:1:\"2\";}i:208;a:2:{s:4:\"name\";s:7:\"HUBBELL\";s:3:\"nbr\";s:2:\"12\";}i:209;a:2:{s:4:\"name\";s:9:\"SECO-LARM\";s:3:\"nbr\";s:1:\"1\";}i:210;a:2:{s:4:\"name\";s:6:\"RITRON\";s:3:\"nbr\";s:1:\"1\";}i:211;a:2:{s:4:\"name\";s:5:\"FLUKE\";s:3:\"nbr\";s:1:\"1\";}i:212;a:2:{s:4:\"name\";s:6:\"SHELLY\";s:3:\"nbr\";s:2:\"12\";}i:213;a:2:{s:4:\"name\";s:25:\"EPCOM POWER LINE BY RITAR\";s:3:\"nbr\";s:1:\"5\";}i:214;a:2:{s:4:\"name\";s:3:\"JWJ\";s:3:\"nbr\";s:2:\"36\";}i:215;a:2:{s:4:\"name\";s:5:\"INDEX\";s:3:\"nbr\";s:2:\"45\";}i:216;a:2:{s:4:\"name\";s:5:\"AUFIT\";s:3:\"nbr\";s:1:\"9\";}i:217;a:2:{s:4:\"name\";s:7:\"ECOFLOW\";s:3:\"nbr\";s:1:\"5\";}i:218;a:2:{s:4:\"name\";s:14:\"VICTRON ENERGY\";s:3:\"nbr\";s:1:\"4\";}i:219;a:2:{s:4:\"name\";s:7:\"GROWATT\";s:3:\"nbr\";s:1:\"5\";}i:220;a:2:{s:4:\"name\";s:12:\"AMANCO-WAVIN\";s:3:\"nbr\";s:2:\"59\";}i:221;a:2:{s:4:\"name\";s:7:\"LEAPTON\";s:3:\"nbr\";s:1:\"1\";}i:222;a:2:{s:4:\"name\";s:3:\"DMT\";s:3:\"nbr\";s:1:\"8\";}i:223;a:2:{s:4:\"name\";s:6:\"EPEVER\";s:3:\"nbr\";s:2:\"33\";}i:224;a:2:{s:4:\"name\";s:4:\"RACO\";s:3:\"nbr\";s:1:\"9\";}i:225;a:3:{s:4:\"name\";s:5:\"AFORE\";s:3:\"nbr\";s:1:\"5\";s:7:\"checked\";b:1;}i:226;a:2:{s:4:\"name\";s:14:\"HUBBELL BURNDY\";s:3:\"nbr\";s:2:\"18\";}i:227;a:2:{s:4:\"name\";s:12:\"SYSCOM PARTS\";s:3:\"nbr\";s:1:\"3\";}i:228;a:2:{s:4:\"name\";s:8:\"HOYMILES\";s:3:\"nbr\";s:2:\"12\";}i:229;a:2:{s:4:\"name\";s:5:\"CHINT\";s:3:\"nbr\";s:2:\"10\";}i:230;a:2:{s:4:\"name\";s:6:\"RAWELT\";s:3:\"nbr\";s:2:\"16\";}i:231;a:2:{s:4:\"name\";s:7:\"JUPITER\";s:3:\"nbr\";s:2:\"39\";}i:232;a:2:{s:4:\"name\";s:7:\"INDIANA\";s:3:\"nbr\";s:1:\"3\";}i:233;a:2:{s:4:\"name\";s:8:\"CHAROFIL\";s:3:\"nbr\";s:2:\"12\";}i:234;a:2:{s:4:\"name\";s:12:\"Ubiquiti Inc\";s:3:\"nbr\";s:1:\"1\";}i:235;a:2:{s:4:\"name\";s:6:\"SAMLEX\";s:3:\"nbr\";s:1:\"8\";}i:236;a:2:{s:4:\"name\";s:11:\"MORNINGSTAR\";s:3:\"nbr\";s:1:\"7\";}i:237;a:2:{s:4:\"name\";s:18:\"LUTRON ELECTRONICS\";s:3:\"nbr\";s:1:\"4\";}i:238;a:2:{s:4:\"name\";s:22:\"LUTRON CASETA WIRELESS\";s:3:\"nbr\";s:1:\"3\";}i:239;a:2:{s:4:\"name\";s:5:\"PYTES\";s:3:\"nbr\";s:1:\"2\";}i:240;a:2:{s:4:\"name\";s:6:\"ASTRON\";s:3:\"nbr\";s:1:\"6\";}i:241;a:2:{s:4:\"name\";s:17:\"RF INDUSTRIES,LTD\";s:3:\"nbr\";s:1:\"1\";}i:242;a:2:{s:4:\"name\";s:8:\"HIKMICRO\";s:3:\"nbr\";s:1:\"2\";}i:243;a:2:{s:4:\"name\";s:4:\"MUST\";s:3:\"nbr\";s:1:\"1\";}i:244;a:2:{s:4:\"name\";s:18:\"HUAWEI FUSIONSOLAR\";s:3:\"nbr\";s:1:\"1\";}}s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";s:1:\"0\";}i:5;a:7:{s:9:\"type_lite\";s:9:\"condition\";s:4:\"type\";s:9:\"condition\";s:6:\"id_key\";i:0;s:4:\"name\";s:10:\"Condición\";s:6:\"values\";a:3:{s:3:\"new\";a:2:{s:4:\"name\";s:5:\"Nuevo\";s:3:\"nbr\";s:2:\"18\";}s:4:\"used\";a:2:{s:4:\"name\";s:5:\"Usado\";s:3:\"nbr\";i:0;}s:11:\"refurbished\";a:2:{s:4:\"name\";s:10:\"Restaurado\";s:3:\"nbr\";i:0;}}s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";s:1:\"0\";}i:6;a:12:{s:9:\"type_lite\";s:6:\"weight\";s:4:\"type\";s:6:\"weight\";s:6:\"id_key\";i:0;s:4:\"name\";s:4:\"Peso\";s:3:\"max\";d:18;s:3:\"min\";d:0.1000000000000000055511151231257827021181583404541015625;s:4:\"unit\";s:2:\"kg\";s:14:\"specifications\";N;s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";i:3;s:5:\"value\";N;s:3:\"nbr\";i:18;}}}")	2.731 ms	1			/modules/ps_facetedsearch/src/Filters/Block.php:211 /modules/ps_facetedsearch/src/Product/SearchProvider.php:217 (insertIntoCache) /classes/controller/ProductListingFrontController.php:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
187	SELECT SQL_NO_CACHE 1 FROM `psx1_specific_price` WHERE id_product = 0 LIMIT 1	2.664 ms	1			/classes/SpecificPrice.php:426 /classes/SpecificPrice.php:523 (couldHaveSpecificPrice) /classes/Product.php:3827 (getSpecificPrice) /classes/Product.php:3717 (priceCalculation) /classes/Product.php:5692 (getPriceStatic) /classes/ProductAssembler.php:209 (getProductProperties) /classes/controller/ProductListingFrontController.php:108 (assembleProducts) /classes/controller/ProductListingFrontController.php:379 (prepareMultipleProductsForTemplate) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
160	SELECT SQL_NO_CACHE m.*, ml.`description`, ml.`short_description` FROM `psx1_manufacturer` m INNER JOIN psx1_manufacturer_shop manufacturer_shop ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 1)INNER JOIN `psx1_manufacturer_lang` ml ON (m.`id_manufacturer` = ml.`id_manufacturer` AND ml.`id_lang` = 2)WHERE 1 AND m.`active` = 1 ORDER BY m.`name` ASC	2.311 ms	236	Yes		/classes/Manufacturer.php:211 /modules/ps_facetedsearch/src/Filters/Converter.php:286 (getManufacturers) /modules/ps_facetedsearch/src/Product/SearchProvider.php:163 (createFacetedSearchFiltersFromQuery) /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)
191	SELECT SQL_NO_CACHE `id_hook`, `name` FROM `psx1_hook` UNION SELECT `id_hook`, ha.`alias` as name FROM `psx1_hook_alias` ha INNER JOIN `psx1_hook` h ON ha.name = h.name	2.145 ms	0			/classes/Hook.php:1326 /classes/Hook.php:225 (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)
165	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 psx1_product p LEFT JOIN psx1_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN psx1_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN psx1_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 psx1_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN psx1_category_product cp ON (p.id_product = cp.id_product) INNER JOIN psx1_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN psx1_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN psx1_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 p.id_manufacturer IN (225, 104, 190, 5) AND c.nleft>=2 AND c.nright<=4175 GROUP BY p.id_product) p LEFT JOIN psx1_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN psx1_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN psx1_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 psx1_stock_available sa_1 ON (p.id_product = sa_1.id_product AND IFNULL(pac.id_product_attribute, 0) = sa_1.id_product_attribute AND sa_1.id_shop = 1 AND sa_1.id_shop_group = 0 ) WHERE ((sa.quantity<=0 AND sa_1.out_of_stock IN (0, 2)))	2.145 ms	361			/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)
166	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 psx1_product p LEFT JOIN psx1_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN psx1_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN psx1_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 psx1_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN psx1_category_product cp ON (p.id_product = cp.id_product) INNER JOIN psx1_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN psx1_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN psx1_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 p.id_manufacturer IN (225, 104, 190, 5) AND c.nleft>=2 AND c.nright<=4175 GROUP BY p.id_product) p LEFT JOIN psx1_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN psx1_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN psx1_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) WHERE ((sa.out_of_stock=1) OR (sa.quantity>0))	2.124 ms	361			/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)
173	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 psx1_product p LEFT JOIN psx1_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN psx1_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN psx1_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 psx1_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN psx1_category_product cp ON (p.id_product = cp.id_product) INNER JOIN psx1_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN psx1_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN psx1_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 p.id_manufacturer IN (225, 104, 190, 5) AND c.nleft>=2 AND c.nright<=4175 GROUP BY p.id_product) p INNER JOIN psx1_category_product cp ON (p.id_product = cp.id_product) INNER JOIN psx1_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN psx1_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<4175 GROUP BY cp.id_category	2.073 ms	361	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: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)
36	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 `psx1_category` c INNER JOIN psx1_category_shop category_shop ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1) LEFT JOIN `psx1_category_lang` cl ON (c.`id_category` = cl.`id_category` AND `id_lang` = 2 AND cl.id_shop = 1 ) LEFT JOIN `psx1_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	1.999 ms	103	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)
169	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 psx1_product p LEFT JOIN psx1_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN psx1_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN psx1_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 psx1_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN psx1_category_product cp ON (p.id_product = cp.id_product) INNER JOIN psx1_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN psx1_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN psx1_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 p.id_manufacturer IN (225, 104, 190, 5) AND c.nleft>=2 AND c.nright<=4175 GROUP BY p.id_product) p WHERE p.date_add>'2025-02-01 00:00:00'	1.984 ms	361			/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)
178	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 psx1_product p LEFT JOIN psx1_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN psx1_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN psx1_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 psx1_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN psx1_category_product cp ON (p.id_product = cp.id_product) INNER JOIN psx1_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN psx1_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN psx1_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 p.id_manufacturer IN (225, 104, 190, 5) AND c.nleft>=2 AND c.nright<=4175 GROUP BY p.id_product) p GROUP BY p.condition	1.947 ms	361	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)
190	SELECT SQL_NO_CACHE `id_tax_rules_group` FROM `psx1_product_shop` WHERE `id_product` = 13 AND id_shop=1 LIMIT 1	1.942 ms	1			/classes/Product.php:6876 /classes/Product.php:3925 (getIdTaxRulesGroupByIdProduct) /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)
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 `psx1_configuration` c LEFT JOIN `psx1_configuration_lang` cl ON (c.`id_configuration` = cl.`id_configuration`)	1.935 ms	666			/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)
163	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 psx1_product p LEFT JOIN psx1_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN psx1_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN psx1_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 psx1_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN psx1_category_product cp ON (p.id_product = cp.id_product) INNER JOIN psx1_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN psx1_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN psx1_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 p.id_manufacturer IN (225, 104, 190, 5) AND c.nleft>=2 AND c.nright<=4175 GROUP BY p.id_product) p INNER JOIN psx1_category_product cp ON (p.id_product = cp.id_product) GROUP BY p.id_product ORDER BY p.position ASC, p.id_product DESC	1.906 ms	361	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)
176	SELECT SQL_NO_CACHE m.*, ml.`description`, ml.`short_description` FROM `psx1_manufacturer` m INNER JOIN psx1_manufacturer_shop manufacturer_shop ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 1)INNER JOIN `psx1_manufacturer_lang` ml ON (m.`id_manufacturer` = ml.`id_manufacturer` AND ml.`id_lang` = 2)WHERE 1 AND m.`active` = 1 ORDER BY m.`name` ASC	1.886 ms	236	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)
186	SELECT SQL_NO_CACHE `name` FROM `psx1_manufacturer` WHERE `id_manufacturer` = 5 AND `active` = 1 LIMIT 1	1.822 ms	1			/classes/Manufacturer.php:316 /classes/Product.php:5669 (getNameById) /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)
168	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 psx1_product p LEFT JOIN psx1_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN psx1_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN psx1_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 psx1_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN psx1_category_product cp ON (p.id_product = cp.id_product) INNER JOIN psx1_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN psx1_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN psx1_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 p.id_manufacturer IN (225, 104, 190, 5) AND c.nleft>=2 AND c.nright<=4175 GROUP BY p.id_product) p WHERE ((p.on_sale=1))	1.541 ms	361			/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)
167	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 psx1_product p LEFT JOIN psx1_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN psx1_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN psx1_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 psx1_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN psx1_category_product cp ON (p.id_product = cp.id_product) INNER JOIN psx1_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN psx1_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN psx1_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 p.id_manufacturer IN (225, 104, 190, 5) AND c.nleft>=2 AND c.nright<=4175 GROUP BY p.id_product) p LEFT JOIN psx1_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN psx1_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN psx1_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))	1.531 ms	361			/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)
263	SELECT SQL_NO_CACHE COUNT(*) FROM `psx1_pack` WHERE id_product_pack = 1707 LIMIT 1	1.528 ms	1			/classes/Pack.php:89 /classes/Product.php:4344 (isPack) /classes/Product.php:5802 (getQuantity) /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)
476	SELECT SQL_NO_CACHE `id_module` FROM `psx1_module` WHERE `name` = "ps_linklist" LIMIT 1	1.408 ms	1			/classes/module/Module.php:2659 /classes/module/Module.php:2131 (getModuleIdByName) /classes/Hook.php:1083 (isEnabled) /tools/profiling/Hook.php:64 (coreRenderWidget) /classes/Hook.php:1019 (coreRenderWidget) /config/smarty.config.inc.php:201 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/prod/smarty/compile/Bigsoholayouts_layout_left_column_tpl/34/c6/bd/34c6bd39aad2d062c3b913918107425dec331137_2.file.footer.tpl.php:96 (__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/prod/smarty/compile/Bigsoholayouts_layout_left_column_tpl/34/c6/bd/34c6bd39aad2d062c3b913918107425dec331137_2.file.footer.tpl.php:39 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_681286da240c23_11816469) /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/prod/smarty/compile/Bigsoholayouts_layout_left_column_tpl/79/53/21/7953218a69a5faaa48c4e3b281b371e70f946b1d_2.file.layout-both-columns.tpl.php:343 (_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/prod/smarty/compile/Bigsoholayouts_layout_left_column_tpl/79/53/21/7953218a69a5faaa48c4e3b281b371e70f946b1d_2.file.layout-both-columns.tpl.php:112 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_681286d9a87275_76185590) /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/prod/smarty/compile/Bigsoholayouts_layout_left_column_tpl/b6/08/0e/b6080e4e76a0eedaeefd3938168fd139cbd9e0d8_2.file.layout-left-column.tpl.php:38 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_681286d9a75990_86582140) /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/prod/smarty/compile/Bigsoholayouts_layout_left_column_tpl/54/05/5a/54055a4729da76c67808f06a50262121f66a0539_2.file.product-list.tpl.php:44 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_681286d9a6f127_57663954) /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/prod/smarty/compile/Bigsoholayouts_layout_left_column_tpl/16/b1/c0/16b1c0714870764f7b1ec50b63a60fd9a3641ec0_2.file.category.tpl.php:38 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_681286d9a5eae0_25470335) /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/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)
181	SELECT SQL_NO_CACHE p., ps., pl.*, sa.out_of_stock, IFNULL(sa.quantity, 0) as quantity, (DATEDIFF( p.`date_add`, DATE_SUB( '2025-05-01 00:00:00', INTERVAL 90 DAY ) ) > 0) as new FROM psx1_product p LEFT JOIN psx1_product_lang pl ON pl.id_product = p.id_product AND pl.id_shop = 1 AND pl.id_lang = 2 LEFT JOIN psx1_stock_available sa ON sa.id_product = p.id_product AND sa.id_product_attribute = 0 AND sa.id_shop = 1 LEFT JOIN psx1_product_shop ps ON ps.id_product = p.id_product AND ps.id_shop = 1 WHERE p.id_product IN (13,2685,1674,1690,1706,1707,2756,2769,1751,1762,1805,2838)	1.393 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)
477	SELECT SQL_NO_CACHE `id_module` FROM `psx1_module_shop` WHERE `id_module` = 1 AND `id_shop` = 1 LIMIT 1	1.265 ms	1			/classes/module/Module.php:2132 /classes/Hook.php:1083 (isEnabled) /tools/profiling/Hook.php:64 (coreRenderWidget) /classes/Hook.php:1019 (coreRenderWidget) /config/smarty.config.inc.php:201 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/prod/smarty/compile/Bigsoholayouts_layout_left_column_tpl/34/c6/bd/34c6bd39aad2d062c3b913918107425dec331137_2.file.footer.tpl.php:96 (__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/prod/smarty/compile/Bigsoholayouts_layout_left_column_tpl/34/c6/bd/34c6bd39aad2d062c3b913918107425dec331137_2.file.footer.tpl.php:39 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_681286da240c23_11816469) /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/prod/smarty/compile/Bigsoholayouts_layout_left_column_tpl/79/53/21/7953218a69a5faaa48c4e3b281b371e70f946b1d_2.file.layout-both-columns.tpl.php:343 (_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/prod/smarty/compile/Bigsoholayouts_layout_left_column_tpl/79/53/21/7953218a69a5faaa48c4e3b281b371e70f946b1d_2.file.layout-both-columns.tpl.php:112 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_681286d9a87275_76185590) /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/prod/smarty/compile/Bigsoholayouts_layout_left_column_tpl/b6/08/0e/b6080e4e76a0eedaeefd3938168fd139cbd9e0d8_2.file.layout-left-column.tpl.php:38 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_681286d9a75990_86582140) /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/prod/smarty/compile/Bigsoholayouts_layout_left_column_tpl/54/05/5a/54055a4729da76c67808f06a50262121f66a0539_2.file.product-list.tpl.php:44 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_681286d9a6f127_57663954) /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/prod/smarty/compile/Bigsoholayouts_layout_left_column_tpl/16/b1/c0/16b1c0714870764f7b1ec50b63a60fd9a3641ec0_2.file.category.tpl.php:38 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_681286d9a5eae0_25470335) /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/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)
170	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 psx1_product p LEFT JOIN psx1_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN psx1_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN psx1_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 psx1_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN psx1_category_product cp ON (p.id_product = cp.id_product) INNER JOIN psx1_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN psx1_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN psx1_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 p.id_manufacturer IN (225, 104, 190, 5) AND c.nleft>=2 AND c.nright<=4175 GROUP BY p.id_product) p LEFT JOIN psx1_specific_price sp ON ( sp.id_product = p.id_product AND sp.id_shop IN (0, 1) AND sp.id_currency IN (0, 2) AND sp.id_country IN (0, 144) 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-05-01 15:47:43' >= sp.from) AND (sp.to = '0000-00-00 00:00:00' OR '2025-05-01 15:47:43' <= sp.to) ) WHERE ((sp.reduction>0))	1.194 ms	2			/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)
175	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 psx1_product p LEFT JOIN psx1_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN psx1_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN psx1_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 psx1_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN psx1_category_product cp ON (p.id_product = cp.id_product) INNER JOIN psx1_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN psx1_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN psx1_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 p.id_manufacturer IN (225, 104, 190, 5) AND c.nleft>=2 AND c.nright<=4175 GROUP BY p.id_product) p INNER JOIN psx1_feature_product fp ON (p.id_product = fp.id_product) WHERE ((fp.id_feature=2)) GROUP BY fp.id_feature_value	1.158 ms	18	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)
171	SELECT SQL_NO_CACHE psi.price_min, MIN(price_min) as min, MAX(price_max) as max FROM psx1_product p INNER JOIN psx1_layered_price_index psi ON (psi.id_product = p.id_product AND psi.id_shop = 1 AND psi.id_currency = 2 AND psi.id_country = 144) INNER JOIN psx1_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN psx1_category_product cp ON (p.id_product = cp.id_product) INNER JOIN psx1_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN psx1_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 p.id_manufacturer IN (225, 104, 190, 5) AND c.nleft>=2 AND c.nright<=4175	1.151 ms	19			/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)
174	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 psx1_product p LEFT JOIN psx1_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN psx1_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN psx1_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 psx1_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN psx1_category_product cp ON (p.id_product = cp.id_product) INNER JOIN psx1_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN psx1_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN psx1_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 p.id_manufacturer IN (225, 104, 190, 5) AND c.nleft>=2 AND c.nright<=4175 GROUP BY p.id_product) p INNER JOIN psx1_feature_product fp ON (p.id_product = fp.id_product) WHERE ((fp.id_feature=1)) GROUP BY fp.id_feature_value	1.099 ms	8	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)
182	SELECT SQL_NO_CACHE image_shop.`id_image` FROM `psx1_image` i INNER JOIN psx1_image_shop image_shop ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1) WHERE i.`id_product` = 13 AND image_shop.`cover` = 1 LIMIT 1	1.054 ms	3			/classes/Product.php:3570 /classes/Product.php:5643 (getCover) /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)

#	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-intl-normalizer/bootstrap.php
13	/vendor/symfony/polyfill-intl-idn/bootstrap.php
14	/vendor/symfony/deprecation-contracts/function.php
15	/vendor/ralouphie/getallheaders/src/getallheaders.php
16	/vendor/symfony/polyfill-ctype/bootstrap.php
17	/vendor/symfony/polyfill-php80/bootstrap.php
18	/vendor/guzzlehttp/promises/src/functions_include.php
19	/vendor/guzzlehttp/promises/src/functions.php
20	/vendor/guzzlehttp/guzzle/src/functions_include.php
21	/vendor/guzzlehttp/guzzle/src/functions.php
22	/vendor/symfony/polyfill-iconv/bootstrap.php
23	/vendor/ezyang/htmlpurifier/library/HTMLPurifier.composer.php
24	/vendor/jakeasmith/http_build_url/src/http_build_url.php
25	/vendor/lcobucci/jwt/compat/class-aliases.php
26	/vendor/lcobucci/jwt/src/Token.php
27	/vendor/lcobucci/jwt/src/Signature.php
28	/vendor/lcobucci/jwt/compat/json-exception-polyfill.php
29	/vendor/lcobucci/jwt/compat/lcobucci-clock-polyfill.php
30	/vendor/swiftmailer/swiftmailer/lib/swift_required.php
31	/vendor/swiftmailer/swiftmailer/lib/classes/Swift.php
32	/vendor/symfony/polyfill-intl-icu/bootstrap.php
33	/vendor/symfony/polyfill-php73/bootstrap.php
34	/vendor/symfony/polyfill-php81/bootstrap.php
35	/vendor/api-platform/core/src/deprecation.php
36	/vendor/api-platform/core/src/Api/FilterInterface.php
37	/vendor/api-platform/core/src/Api/ResourceClassResolverInterface.php
38	/vendor/api-platform/core/src/deprecated_interfaces.php
39	/vendor/api-platform/core/src/Metadata/Property/Factory/PropertyNameCollectionFactoryInterface.php

Filtrar por

Últimas novedades

Últimas novedades

Inicio