Inicio

Subcategorías

Grid
List

Hay 22 productos.

Ordenar por:

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

Últimas piezas!
Agregar a lista de deseos

Vista rápida

Agregar a comparación
ALL IN ONE HP ProOne 245 AMD G10 R37320U 8GB 512GB PC Win11 Home 64bit

$13,677

Equipo Todo en Uno con procesador AMD Ryzen 3 7320U, 8GB de Memoria RAM y Disco SSD de 512GB
- Sólo por Internet
Agregar a lista de deseos

Vista rápida

Agregar a comparación
Laptop HP 240R G9 14" Intel Core i3 1315U 8GB RAM 512GB SSD W11 HOME

$12,738
Agregar a lista de deseos

Vista rápida

Agregar a comparación
Monitor HP 19.5" Led P204v HD+ Resolución 1600x900 Panel TN

$3,224

El Monitor HP P204v de 19,5" ofrece una experiencia visual nítida con resolución HD+ (1600 x 900), conectividad HDMI y VGA, y un diseño elegante que complementa cualquier.
- Nuevo
Agregar a lista de deseos

Vista rápida

Agregar a comparación
BioEntry P2 Lector de Huella Multiformato (125KHz EM & 13.56MHz Mifare...

$10,737

BioEntry P2 Lector de Huella Multiformato (125KHz EM & 13.56MHz Mifare, DesFire/EV1, FeliCa)
- Nuevo
Agregar a lista de deseos

Vista rápida

Agregar a comparación
BioEntry P2 Lector de Huella Multiformato ( 125KHz EM HID Prox)( 13.56MHz...

$11,586

BioEntry P2 Lector de Huella Multiformato ( 125KHz EM, HID Prox)( 13.56MHz MIFARE, DESFire/EV1, FeliCa, iCLASS SE/SR, NFC Físico)
- Nuevo
Agregar a lista de deseos

Vista rápida

Agregar a comparación
CoreStation Panel de Control de Acceso / Biometría Integrada / Compatible...

$16,844

CoreStation Panel de Control de Acceso / Biometría Integrada / Compatible con Sistema de Elevadores / 200,000 Huellas / 4 Puertas
- Nuevo
Agregar a lista de deseos

Vista rápida

Agregar a comparación
Módulo para Control de Puertas / 2 Entradas/Salidas Weigand / 4 Salidas de...

$5,880

Módulo para Control de Puertas / 2 Entradas/Salidas Weigand / 4 Salidas de Relevador tipo C / Uso con BioStar 2
- Nuevo
Agregar a lista de deseos

Vista rápida

Agregar a comparación
Lector de Huella Esclavo compatible con cualquier lector suprema de 2da...

$7,126

Lector de Huella Esclavo, compatible con cualquier lector suprema de 2da generación. Multiformato (125KHz EM)(13.56MHz MIFARE, DESFire/EV1,FeliCa, NFC)
- Nuevo
Agregar a lista de deseos

Vista rápida

Agregar a comparación
Face station F2 con detector de Cubre bocas Lector Facial Lector de tarjetas...

$35,537

Face station F2 con detector de Cubre bocas, Lector Facial, Lector de tarjetas Móviles y lector de tarjetas RFID(125kHz EM & 13.56Mhz MIFARE) Compatible con BioStar2, Uso.
- Nuevo
Agregar a lista de deseos

Vista rápida

Agregar a comparación
Lector Esclavo de Tarjetas con teclado de uso en exterior Multitecnolgia NFC...

$7,318

Lector Esclavo de Tarjetas con teclado de uso en exterior, Multitecnolgia, NFC y Bluetooth
- Nuevo
Agregar a lista de deseos

Vista rápida

Agregar a comparación
Tarjeta Virtual / para uso con su SMARTPHONE / compatible con todos los...

$107

Tarjeta Virtual / para uso con su SMARTPHONE / compatible con todos los lectores SUPREMA que soporten Bluetooth
- Nuevo
Agregar a lista de deseos

Vista rápida

Agregar a comparación
Lector Multi-tecnologia con detector de cubrebocas- Reconocimiento Facial...

$42,116

Lector Multi-tecnologia con detector de cubrebocas- Reconocimiento Facial, Huella, Tarjeta Móvil y lector de RFID(125kHz EM & 13.56 Mhz MIFARE) Compatible con BioStar2, Uso.

Load Time	2240 ms
Querying Time	399 ms
Queries	495
Memory Peak Usage	28.2 Mb
Included Files	779 files - 9.99 Mb
PrestaShop Cache	- Mb
Global vars	0.24 Mb
- global $context	191k
- 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	20.651 ms	20.656 ms	0.09 Mb	9.1 Mb
init	199.937 ms	220.593 ms	2.87 Mb	9.1 Mb
checkAccess	0.002 ms	220.595 ms	- Mb	9.1 Mb
setMedia	21.643 ms	242.238 ms	0.47 Mb	9.1 Mb
postProcess	0.002 ms	242.240 ms	- Mb	9.1 Mb
initHeader	0.000 ms	242.240 ms	- Mb	9.1 Mb
initContent	441.593 ms	683.833 ms	7.27 Mb	14.1 Mb
initFooter	0.002 ms	683.835 ms	- Mb	14.1 Mb
display	1556 ms	2240 ms	11.69 Mb	28.2 Mb

Hook	Time	Memory Usage
displayLeftColumn	77.407 ms	5.72 Mb
=> ps_categorytree (widget)	75.917 ms	5.62 Mb
=> cz_leftbanner (widget)	0.908 ms	0.04 Mb
=> cz_newproducts (widget)	0.582 ms	0.06 Mb
DisplayProductPriceBlock	18.974 ms	2.36 Mb
=> psproductcountdown	0.001 ms	- Mb
=> psproductcountdown	0.002 ms	- Mb
=> psproductcountdown	0.027 ms	- Mb
=> psproductcountdown	1.772 ms	0.21 Mb
=> psproductcountdown	0.000 ms	- Mb
=> psproductcountdown	0.001 ms	- Mb
=> psproductcountdown	0.001 ms	- Mb
=> psproductcountdown	1.604 ms	0.21 Mb
=> psproductcountdown	0.001 ms	- Mb
=> psproductcountdown	0.000 ms	- Mb
=> psproductcountdown	0.001 ms	- Mb
=> psproductcountdown	1.702 ms	0.20 Mb
=> psproductcountdown	0.001 ms	- Mb
=> psproductcountdown	0.000 ms	- Mb
=> psproductcountdown	0.001 ms	- Mb
=> psproductcountdown	1.530 ms	0.21 Mb
=> psproductcountdown	0.001 ms	- Mb
=> psproductcountdown	0.000 ms	- Mb
=> psproductcountdown	0.000 ms	- Mb
=> psproductcountdown	1.407 ms	0.18 Mb
=> psproductcountdown	0.001 ms	- Mb
=> psproductcountdown	0.001 ms	- Mb
=> psproductcountdown	0.001 ms	- Mb
=> psproductcountdown	1.977 ms	0.19 Mb
=> psproductcountdown	0.001 ms	- Mb
=> psproductcountdown	0.000 ms	- Mb
=> psproductcountdown	0.001 ms	- Mb
=> psproductcountdown	1.708 ms	0.17 Mb
=> psproductcountdown	0.001 ms	- Mb
=> psproductcountdown	0.001 ms	- Mb
=> psproductcountdown	0.001 ms	- Mb
=> psproductcountdown	1.321 ms	0.17 Mb
=> psproductcountdown	0.001 ms	- Mb
=> psproductcountdown	0.001 ms	- Mb
=> psproductcountdown	0.001 ms	- Mb
=> psproductcountdown	1.551 ms	0.22 Mb
=> psproductcountdown	0.001 ms	- Mb
=> psproductcountdown	0.001 ms	- Mb
=> psproductcountdown	0.001 ms	- Mb
=> psproductcountdown	1.473 ms	0.19 Mb
=> psproductcountdown	0.001 ms	- Mb
=> psproductcountdown	0.000 ms	- Mb
=> psproductcountdown	0.001 ms	- Mb
=> psproductcountdown	1.327 ms	0.18 Mb
=> psproductcountdown	0.000 ms	- Mb
=> psproductcountdown	0.001 ms	- Mb
=> psproductcountdown	0.001 ms	- Mb
=> psproductcountdown	1.548 ms	0.22 Mb
DisplayCzHoverImage	7.781 ms	0.56 Mb
=> cz_imagehover	1.035 ms	0.06 Mb
=> cz_imagehover	0.821 ms	0.05 Mb
=> cz_imagehover	0.962 ms	0.05 Mb
=> cz_imagehover	0.537 ms	0.04 Mb
=> cz_imagehover	0.479 ms	0.04 Mb
=> cz_imagehover	0.535 ms	0.04 Mb
=> cz_imagehover	0.744 ms	0.04 Mb
=> cz_imagehover	0.536 ms	0.04 Mb
=> cz_imagehover	0.562 ms	0.04 Mb
=> cz_imagehover	0.508 ms	0.04 Mb
=> cz_imagehover	0.543 ms	0.05 Mb
=> cz_imagehover	0.519 ms	0.04 Mb
displayFooter	6.126 ms	0.45 Mb
=> ps_contactinfo (widget)	1.852 ms	0.07 Mb
=> ps_socialfollow (widget)	0.642 ms	0.05 Mb
=> ps_linklist (widget)	0.749 ms	0.06 Mb
=> ps_customeraccountlinks (widget)	0.687 ms	0.07 Mb
=> ps_emailsubscription (widget)	0.768 ms	0.05 Mb
=> cz_themeimages (widget)	0.676 ms	0.05 Mb
=> cz_themeoptions (widget)	0.753 ms	0.10 Mb
ProductSearchProvider	5.153 ms	0.07 Mb
=> ps_facetedsearch	5.153 ms	0.07 Mb
displayTop	5.095 ms	0.28 Mb
=> ps_shoppingcart (widget)	2.774 ms	0.13 Mb
=> ps_customersignin (widget)	1.721 ms	0.10 Mb
=> ps_searchbar (widget)	0.600 ms	0.04 Mb
DisplayBeforeBodyClosingTag	3.765 ms	0.07 Mb
=> statsdata	3.765 ms	0.07 Mb
ActionFrontControllerSetMedia	3.666 ms	0.07 Mb
=> blockreassurance	3.363 ms	0.07 Mb
=> ps_emailsubscription	0.189 ms	- Mb
=> ps_socialfollow	0.065 ms	- Mb
=> ps_emailalerts	0.049 ms	- Mb
displayNav1	3.611 ms	0.08 Mb
=> cz_navcmsblock (widget)	3.611 ms	0.08 Mb
displayNavFullWidth	3.428 ms	0.24 Mb
=> cz_verticalmenu (widget)	1.497 ms	0.12 Mb
=> ps_mainmenu (widget)	1.931 ms	0.12 Mb
Header	3.419 ms	0.04 Mb
=> stripe_official	0.024 ms	- Mb
=> customhtml	1.205 ms	0.01 Mb
=> cz_themeoptions	0.668 ms	0.01 Mb
=> psproductcountdown	1.522 ms	0.02 Mb
DisplayStWishlistButton	2.437 ms	0.02 Mb
=> stfeature	0.530 ms	0.01 Mb
=> stfeature	0.182 ms	- Mb
=> stfeature	0.168 ms	- Mb
=> stfeature	0.139 ms	- Mb
=> stfeature	0.155 ms	- Mb
=> stfeature	0.212 ms	- Mb
=> stfeature	0.203 ms	- Mb
=> stfeature	0.155 ms	- Mb
=> stfeature	0.157 ms	- Mb
=> stfeature	0.150 ms	- Mb
=> stfeature	0.217 ms	- Mb
=> stfeature	0.168 ms	- Mb
DisplayFooter	1.700 ms	0.19 Mb
=> czuecookie	1.700 ms	0.19 Mb
DisplayStCompareButton	1.512 ms	0.01 Mb
=> stfeature	0.276 ms	0.01 Mb
=> stfeature	0.115 ms	- Mb
=> stfeature	0.134 ms	- Mb
=> stfeature	0.116 ms	- Mb
=> stfeature	0.117 ms	- Mb
=> stfeature	0.164 ms	- Mb
=> stfeature	0.121 ms	- Mb
=> stfeature	0.093 ms	- Mb
=> stfeature	0.087 ms	- Mb
=> stfeature	0.114 ms	- Mb
=> stfeature	0.091 ms	- Mb
=> stfeature	0.084 ms	- Mb
DisplayHeader	1.208 ms	0.02 Mb
=> ps_shoppingcart	0.069 ms	- Mb
=> ps_searchbar	0.129 ms	- Mb
=> cz_verticalmenu	0.067 ms	- Mb
=> cz_imageslider	0.113 ms	- Mb
=> cz_instagramfeeds	0.103 ms	- Mb
=> myprestacomments	0.335 ms	- Mb
=> stfeature	0.392 ms	0.01 Mb
displayFooterAfter	0.804 ms	- Mb
=> cz_blocklink (widget)	0.804 ms	- Mb
Footer	0.649 ms	0.01 Mb
=> customhtml	0.649 ms	0.01 Mb
DisplayStWishlistTopLink	0.562 ms	0.04 Mb
=> stfeature	0.562 ms	0.04 Mb
DisplayLeftColumn	0.510 ms	0.12 Mb
=> ps_facetedsearch	0.510 ms	0.12 Mb
DisplayStCompareTopLink	0.224 ms	0.01 Mb
=> stfeature	0.224 ms	0.01 Mb
DisplayProductListReviews	0.024 ms	- Mb
=> psproductcountdown	0.003 ms	- Mb
=> psproductcountdown	0.001 ms	- Mb
=> psproductcountdown	0.003 ms	- Mb
=> psproductcountdown	0.002 ms	- Mb
=> psproductcountdown	0.002 ms	- Mb
=> psproductcountdown	0.003 ms	- Mb
=> psproductcountdown	0.002 ms	- Mb
=> psproductcountdown	0.002 ms	- Mb
=> psproductcountdown	0.001 ms	- Mb
=> psproductcountdown	0.002 ms	- Mb
=> psproductcountdown	0.001 ms	- Mb
=> psproductcountdown	0.002 ms	- Mb
DisplayFooterAfter	0.006 ms	- Mb
=> cz_themeoptions	0.006 ms	- Mb
22 hook(s)	148.060 ms	10.33 Mb

Module	Time	Memory Usage
blockreassurance	6.677 ms	0.22 Mb
__construct	3.306 ms	0.15 Mb
hookActionFrontControllerSetMedia	3.371 ms	0.07 Mb
ps_emailsubscription	5.239 ms	0.08 Mb
__construct	4.277 ms	0.03 Mb
hookActionFrontControllerSetMedia	0.192 ms	- Mb
displayFooter	0.770 ms	0.05 Mb
ps_socialfollow	2.057 ms	0.07 Mb
__construct	1.346 ms	0.02 Mb
hookActionFrontControllerSetMedia	0.068 ms	- Mb
displayFooter	0.643 ms	0.05 Mb
ps_emailalerts	6.168 ms	0.04 Mb
__construct	6.117 ms	0.04 Mb
hookActionFrontControllerSetMedia	0.051 ms	- Mb
ps_shoppingcart	3.806 ms	0.15 Mb
__construct	0.955 ms	0.02 Mb
hookDisplayHeader	0.072 ms	- Mb
displayTop	2.779 ms	0.14 Mb
ps_searchbar	1.082 ms	0.06 Mb
__construct	0.349 ms	0.02 Mb
hookDisplayHeader	0.131 ms	- Mb
displayTop	0.602 ms	0.04 Mb
cz_verticalmenu	9.415 ms	0.16 Mb
__construct	7.844 ms	0.03 Mb
hookDisplayHeader	0.071 ms	- Mb
displayNavFullWidth	1.500 ms	0.12 Mb
cz_imageslider	5.105 ms	0.10 Mb
__construct	4.988 ms	0.10 Mb
hookDisplayHeader	0.117 ms	- Mb
cz_instagramfeeds	1.779 ms	0.02 Mb
__construct	1.673 ms	0.02 Mb
hookDisplayHeader	0.106 ms	- Mb
myprestacomments	8.908 ms	0.16 Mb
__construct	8.568 ms	0.15 Mb
hookDisplayHeader	0.340 ms	0.01 Mb
stfeature	11.725 ms	0.16 Mb
__construct	6.541 ms	0.06 Mb
hookDisplayHeader	0.396 ms	0.01 Mb
hookDisplayStWishlistTopLink	0.565 ms	0.04 Mb
hookDisplayStCompareTopLink	0.226 ms	0.01 Mb
hookDisplayStWishlistButton	0.532 ms	0.01 Mb
hookDisplayStCompareButton	0.278 ms	0.01 Mb
hookDisplayStWishlistButton	0.184 ms	- Mb
hookDisplayStCompareButton	0.117 ms	- Mb
hookDisplayStWishlistButton	0.171 ms	- Mb
hookDisplayStCompareButton	0.136 ms	- Mb
hookDisplayStWishlistButton	0.140 ms	- Mb
hookDisplayStCompareButton	0.117 ms	- Mb
hookDisplayStWishlistButton	0.157 ms	- Mb
hookDisplayStCompareButton	0.119 ms	- Mb
hookDisplayStWishlistButton	0.215 ms	- Mb
hookDisplayStCompareButton	0.166 ms	- Mb
hookDisplayStWishlistButton	0.206 ms	- Mb
hookDisplayStCompareButton	0.123 ms	- Mb
hookDisplayStWishlistButton	0.157 ms	- Mb
hookDisplayStCompareButton	0.095 ms	- Mb
hookDisplayStWishlistButton	0.159 ms	- Mb
hookDisplayStCompareButton	0.089 ms	- Mb
hookDisplayStWishlistButton	0.152 ms	- Mb
hookDisplayStCompareButton	0.115 ms	- Mb
hookDisplayStWishlistButton	0.220 ms	- Mb
hookDisplayStCompareButton	0.093 ms	- Mb
hookDisplayStWishlistButton	0.170 ms	- Mb
hookDisplayStCompareButton	0.086 ms	- Mb
stripe_official	14.040 ms	0.23 Mb
__construct	14.013 ms	0.23 Mb
hookHeader	0.027 ms	- Mb
customhtml	2.262 ms	0.04 Mb
__construct	0.402 ms	0.02 Mb
hookHeader	1.209 ms	0.01 Mb
hookFooter	0.651 ms	0.01 Mb
cz_themeoptions	18.286 ms	0.31 Mb
__construct	16.850 ms	0.20 Mb
hookHeader	0.673 ms	0.01 Mb
displayFooter	0.756 ms	0.10 Mb
hookDisplayFooterAfter	0.007 ms	- Mb
psproductcountdown	29.285 ms	2.51 Mb
__construct	8.673 ms	0.11 Mb
hookHeader	1.527 ms	0.02 Mb
hookDisplayProductListReviews	0.004 ms	- Mb
hookDisplayProductPriceBlock	0.002 ms	- Mb
hookDisplayProductPriceBlock	0.003 ms	- Mb
hookDisplayProductPriceBlock	0.028 ms	- Mb
hookDisplayProductPriceBlock	1.774 ms	0.21 Mb
hookDisplayProductListReviews	0.002 ms	- Mb
hookDisplayProductPriceBlock	0.001 ms	- Mb
hookDisplayProductPriceBlock	0.001 ms	- Mb
hookDisplayProductPriceBlock	0.001 ms	- Mb
hookDisplayProductPriceBlock	1.607 ms	0.21 Mb
hookDisplayProductListReviews	0.004 ms	- Mb
hookDisplayProductPriceBlock	0.002 ms	- Mb
hookDisplayProductPriceBlock	0.001 ms	- Mb
hookDisplayProductPriceBlock	0.001 ms	- Mb
hookDisplayProductPriceBlock	1.718 ms	0.20 Mb
hookDisplayProductListReviews	0.003 ms	- Mb
hookDisplayProductPriceBlock	0.002 ms	- Mb
hookDisplayProductPriceBlock	0.001 ms	- Mb
hookDisplayProductPriceBlock	0.001 ms	- Mb
hookDisplayProductPriceBlock	1.532 ms	0.21 Mb
hookDisplayProductListReviews	0.003 ms	- Mb
hookDisplayProductPriceBlock	0.002 ms	- Mb
hookDisplayProductPriceBlock	0.001 ms	- Mb
hookDisplayProductPriceBlock	0.001 ms	- Mb
hookDisplayProductPriceBlock	1.409 ms	0.18 Mb
hookDisplayProductListReviews	0.004 ms	- Mb
hookDisplayProductPriceBlock	0.003 ms	- Mb
hookDisplayProductPriceBlock	0.001 ms	- Mb
hookDisplayProductPriceBlock	0.002 ms	- Mb
hookDisplayProductPriceBlock	1.981 ms	0.19 Mb
hookDisplayProductListReviews	0.004 ms	- Mb
hookDisplayProductPriceBlock	0.002 ms	- Mb
hookDisplayProductPriceBlock	0.001 ms	- Mb
hookDisplayProductPriceBlock	0.002 ms	- Mb
hookDisplayProductPriceBlock	1.711 ms	0.17 Mb
hookDisplayProductListReviews	0.003 ms	- Mb
hookDisplayProductPriceBlock	0.002 ms	- Mb
hookDisplayProductPriceBlock	0.001 ms	- Mb
hookDisplayProductPriceBlock	0.002 ms	- Mb
hookDisplayProductPriceBlock	1.323 ms	0.17 Mb
hookDisplayProductListReviews	0.003 ms	- Mb
hookDisplayProductPriceBlock	0.002 ms	- Mb
hookDisplayProductPriceBlock	0.002 ms	- Mb
hookDisplayProductPriceBlock	0.002 ms	- Mb
hookDisplayProductPriceBlock	1.553 ms	0.22 Mb
hookDisplayProductListReviews	0.003 ms	- Mb
hookDisplayProductPriceBlock	0.002 ms	- Mb
hookDisplayProductPriceBlock	0.001 ms	- Mb
hookDisplayProductPriceBlock	0.001 ms	- Mb
hookDisplayProductPriceBlock	1.475 ms	0.19 Mb
hookDisplayProductListReviews	0.003 ms	- Mb
hookDisplayProductPriceBlock	0.002 ms	- Mb
hookDisplayProductPriceBlock	0.001 ms	- Mb
hookDisplayProductPriceBlock	0.001 ms	- Mb
hookDisplayProductPriceBlock	1.329 ms	0.18 Mb
hookDisplayProductListReviews	0.003 ms	- Mb
hookDisplayProductPriceBlock	0.001 ms	- Mb
hookDisplayProductPriceBlock	0.002 ms	- Mb
hookDisplayProductPriceBlock	0.002 ms	- Mb
hookDisplayProductPriceBlock	1.551 ms	0.22 Mb
ps_facetedsearch	15.554 ms	0.30 Mb
__construct	9.879 ms	0.11 Mb
hookProductSearchProvider	5.162 ms	0.07 Mb
hookDisplayLeftColumn	0.513 ms	0.12 Mb
cz_navcmsblock	5.132 ms	0.10 Mb
__construct	1.517 ms	0.02 Mb
displayNav1	3.615 ms	0.08 Mb
ps_customersignin	2.245 ms	0.12 Mb
__construct	0.523 ms	0.02 Mb
displayTop	1.722 ms	0.10 Mb
ps_mainmenu	8.177 ms	0.15 Mb
__construct	6.243 ms	0.03 Mb
displayNavFullWidth	1.934 ms	0.12 Mb
ps_categorytree	77.264 ms	5.70 Mb
__construct	1.341 ms	0.08 Mb
displayLeftColumn	75.923 ms	5.62 Mb
cz_leftbanner	4.000 ms	0.08 Mb
__construct	3.090 ms	0.03 Mb
displayLeftColumn	0.910 ms	0.04 Mb
cz_newproducts	1.494 ms	0.07 Mb
__construct	0.910 ms	0.02 Mb
displayLeftColumn	0.584 ms	0.06 Mb
cz_imagehover	8.231 ms	0.58 Mb
__construct	0.420 ms	0.02 Mb
hookDisplayCzHoverImage	1.039 ms	0.06 Mb
hookDisplayCzHoverImage	0.824 ms	0.05 Mb
hookDisplayCzHoverImage	0.964 ms	0.05 Mb
hookDisplayCzHoverImage	0.539 ms	0.05 Mb
hookDisplayCzHoverImage	0.481 ms	0.05 Mb
hookDisplayCzHoverImage	0.537 ms	0.05 Mb
hookDisplayCzHoverImage	0.748 ms	0.05 Mb
hookDisplayCzHoverImage	0.538 ms	0.05 Mb
hookDisplayCzHoverImage	0.565 ms	0.05 Mb
hookDisplayCzHoverImage	0.510 ms	0.05 Mb
hookDisplayCzHoverImage	0.545 ms	0.05 Mb
hookDisplayCzHoverImage	0.522 ms	0.05 Mb
ps_contactinfo	2.466 ms	0.09 Mb
__construct	0.610 ms	0.02 Mb
displayFooter	1.856 ms	0.07 Mb
ps_linklist	12.504 ms	0.09 Mb
__construct	11.752 ms	0.03 Mb
displayFooter	0.752 ms	0.06 Mb
ps_customeraccountlinks	1.127 ms	0.15 Mb
__construct	0.438 ms	0.08 Mb
displayFooter	0.689 ms	0.07 Mb
cz_themeimages	1.623 ms	0.07 Mb
__construct	0.944 ms	0.02 Mb
displayFooter	0.679 ms	0.05 Mb
czuecookie	2.243 ms	0.21 Mb
__construct	0.540 ms	0.02 Mb
hookDisplayFooter	1.703 ms	0.19 Mb
cz_blocklink	2.581 ms	- Mb
__construct	1.774 ms	0.02 Mb
displayFooterAfter	0.807 ms	- Mb
statsdata	4.695 ms	0.08 Mb
__construct	0.926 ms	0.02 Mb
hookDisplayBeforeBodyClosingTag	3.769 ms	0.07 Mb
30 module(s)	275.171 ms	12.11 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 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 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 product_type FROM `psxXX_product` WHERE id_product = XX LIMIT XX
12 queries	SELECT COUNT(*) FROM `psxXX_pack` WHERE id_product_pack = XX LIMIT XX
12 queries	SELECT `reduction` FROM `psxXX_product_group_reduction_cache` WHERE `id_product` = XX AND `id_group` = XX LIMIT XX
12 queries	SELECT `id_product_attribute` FROM `psxXX_product_attribute` WHERE `id_product` = 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 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 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 * 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 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 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 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 * FROM `psxXX_product_lang` WHERE `id_product` = XX AND `id_shop` = XX
8 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 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 v., vl., IF(lifvlv.`url_name` IS NULL OR lifvlv.`url_name` = "", NULL, lifvlv.`url_name`) AS url_name, IF(lifvlv.`meta_title` IS NULL OR lifvlv.`meta_title` = "", NULL, lifvlv.`meta_title`) AS meta_title FROM `psxXX_feature_value` v LEFT JOIN `psxXX_feature_value_lang` vl ON (v.`id_feature_value` = vl.`id_feature_value` AND vl.`id_lang` = XX) LEFT JOIN `psxXX_layered_indexable_feature_value_lang_value` lifvlv ON (v.`id_feature_value` = lifvlv.`id_feature_value` AND lifvlv.`id_lang` = XX) WHERE v.`id_feature` = XX ORDER BY vl.`value` ASC
2 queries	SELECT fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM 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 `id_category` FROM `psxXX_category_shop` WHERE `id_category` = XX AND `id_shop` = 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 * 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 `need_identification_number` FROM `psxXX_country` WHERE `id_country` = XX LIMIT XX
2 queries	SELECT `name` FROM `psxXX_manufacturer` WHERE `id_manufacturer` = XX AND `active` = XX LIMIT XX
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: 2] /classes/Link.php:113 (__construct) [id: 3] /classes/Link.php:113 (__construct) [id: 15] /classes/Link.php:113 (__construct) [id: 1428] /classes/Link.php:113 (__construct) [id: 1767] /classes/Link.php:113 (__construct) [id: 1839] /classes/Link.php:113 (__construct) [id: 1885] /classes/Link.php:113 (__construct) [id: 1902] /classes/Link.php:113 (__construct) [id: 1919] /classes/Link.php:113 (__construct) [id: 1942] /classes/Link.php:113 (__construct) [id: 1947] /classes/Link.php:113 (__construct) [id: 1952] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 2] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 3] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 15] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 1428] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 1767] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 1839] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 1885] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 1902] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 1919] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 1942] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 1947] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 1952] /classes/Link.php:113 (__construct) [id: 2] /classes/Link.php:113 (__construct) [id: 3] /classes/Link.php:113 (__construct) [id: 15] /classes/Link.php:113 (__construct) [id: 1428] /classes/Link.php:113 (__construct) [id: 1767] /classes/Link.php:113 (__construct) [id: 1839] /classes/Link.php:113 (__construct) [id: 1885] /classes/Link.php:113 (__construct) [id: 1902] /classes/Link.php:113 (__construct) [id: 1919] /classes/Link.php:113 (__construct) [id: 1942] /classes/Link.php:113 (__construct) [id: 1947] /classes/Link.php:113 (__construct) [id: 1952] /modules/cz_imagehover/cz_imagehover.php:73 (__construct) [id: 2] /modules/psproductcountdown/psproductcountdown.php:1574 (__construct) [id: 2] /modules/cz_imagehover/cz_imagehover.php:73 (__construct) [id: 3] /modules/psproductcountdown/psproductcountdown.php:1574 (__construct) [id: 3] /modules/cz_imagehover/cz_imagehover.php:73 (__construct) [id: 15] /modules/psproductcountdown/psproductcountdown.php:1574 (__construct) [id: 15] /modules/cz_imagehover/cz_imagehover.php:73 (__construct) [id: 1428] /modules/psproductcountdown/psproductcountdown.php:1574 (__construct) [id: 1428] /modules/cz_imagehover/cz_imagehover.php:73 (__construct) [id: 1767] /modules/psproductcountdown/psproductcountdown.php:1574 (__construct) [id: 1767] /modules/cz_imagehover/cz_imagehover.php:73 (__construct) [id: 1839] /modules/psproductcountdown/psproductcountdown.php:1574 (__construct) [id: 1839] /modules/cz_imagehover/cz_imagehover.php:73 (__construct) [id: 1885] /modules/psproductcountdown/psproductcountdown.php:1574 (__construct) [id: 1885] /modules/cz_imagehover/cz_imagehover.php:73 (__construct) [id: 1902] /modules/psproductcountdown/psproductcountdown.php:1574 (__construct) [id: 1902] /modules/cz_imagehover/cz_imagehover.php:73 (__construct) [id: 1919] /modules/psproductcountdown/psproductcountdown.php:1574 (__construct) [id: 1919] /modules/cz_imagehover/cz_imagehover.php:73 (__construct) [id: 1942] /modules/psproductcountdown/psproductcountdown.php:1574 (__construct) [id: 1942] /modules/cz_imagehover/cz_imagehover.php:73 (__construct) [id: 1947] /modules/psproductcountdown/psproductcountdown.php:1574 (__construct) [id: 1947] /modules/cz_imagehover/cz_imagehover.php:73 (__construct) [id: 1952] /modules/psproductcountdown/psproductcountdown.php:1574 (__construct) [id: 1952]
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
179	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	102.113 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)
390	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	48.802 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)
6	SELECT SQL_NO_CACHE * FROM `psx1_country` a LEFT JOIN `psx1_country_lang` `b` ON a.`id_country` = b.`id_country` AND b.`id_lang` = 2 LEFT JOIN `psx1_country_shop` `c` ON a.`id_country` = c.`id_country` AND c.`id_shop` = 1 WHERE (a.`id_country` = 144) LIMIT 1	11.060 ms	1			/src/Adapter/EntityMapper.php:71 /classes/ObjectModel.php:283 (load) /tools/profiling/ObjectModel.php:32 (__construct) /config/config.inc.php:146 (__construct) /index.php:27 (require)
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	10.061 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)
210	SELECT SQL_NO_CACHE * FROM `psx1_product` a LEFT JOIN `psx1_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 2 LEFT JOIN `psx1_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1 WHERE (a.`id_product` = 3) AND (b.`id_shop` = 1) LIMIT 1	9.889 ms	1			/src/Adapter/EntityMapper.php:71 /classes/ObjectModel.php:283 (load) /tools/profiling/ObjectModel.php:32 (__construct) /classes/Product.php:725 (__construct) /classes/Link.php:113 (__construct) /classes/Link.php:189 (getProductObject) /classes/Product.php:5660 (getProductLink) /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)
209	SELECT SQL_NO_CACHE name FROM psx1_category_lang WHERE id_shop = 1 AND id_lang = 2 AND id_category = 3 LIMIT 1	9.610 ms	1			/classes/Product.php:5659 /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)
211	SELECT SQL_NO_CACHE 1 FROM `psx1_specific_price` WHERE id_product = 3 LIMIT 1	9.429 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)
5	SELECT SQL_NO_CACHE l.*, ls.`id_shop` FROM `psx1_lang` l LEFT JOIN `psx1_lang_shop` ls ON (l.id_lang = ls.id_lang)	7.528 ms	2			/classes/Language.php:1080 /config/config.inc.php:143 (loadLanguages) /index.php:27 (require)
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`	5.888 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	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 (242, 1, 115, 180) AND c.nleft>=2 AND c.nright<=4175 GROUP BY p.id_product) p GROUP BY p.condition	5.233 ms	529	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:778 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:394 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:137 (getConditionsBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
43	SELECT SQL_NO_CACHE * FROM `psx1_category` a LEFT JOIN `psx1_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 2 LEFT JOIN `psx1_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1 WHERE (a.`id_category` = 197) AND (b.`id_shop` = 1) LIMIT 1	4.328 ms	1			/src/Adapter/EntityMapper.php:71 /classes/ObjectModel.php:283 (load) /tools/profiling/ObjectModel.php:32 (__construct) /classes/Category.php:164 (__construct) /controllers/front/listing/CategoryController.php:216 (__construct) :undefined ({closure}) /controllers/front/listing/CategoryController.php:230 (array_map) /controllers/front/listing/CategoryController.php:118 (getTemplateVarSubCategories) /tools/profiling/Controller.php:41 (init) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
368	SELECT SQL_NO_CACHE 1 FROM psx1_cart_product cp INNER JOIN psx1_product p ON (p.id_product = cp.id_product) INNER JOIN psx1_product_shop ps ON (ps.id_shop = cp.id_shop AND ps.id_product = p.id_product) WHERE cp.id_cart=0 LIMIT 1	4.139 ms	1			/classes/Cart.php:4255 /classes/Cart.php:4230 (hasProducts) /classes/Cart.php:2145 (isVirtualCart) /src/Adapter/Presenter/Cart/CartLazyArray.php:185 (getOrderTotal) /src/Adapter/Presenter/AbstractLazyArray.php:269 (getTotals) /src/Adapter/Presenter/AbstractLazyArray.php:129 (offsetGet) :undefined (jsonSerialize) /classes/Smarty/SmartyLazyRegister.php:81 (json_encode) /var/cache/prod/smarty/compile/Bigsoholayouts_layout_left_column_tpl/6f/4b/4b/6f4b4b48bd17a7978e75eeb4b344f752cc937740_2.file.javascript.tpl.php:65 (__call) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_681286d9addc61_68910423) /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/a3/76/4f/a3764fffcfe749f951697d739ead10f80e3ea7d1_2.file.head.tpl.php:386 (_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/a3/76/4f/a3764fffcfe749f951697d739ead10f80e3ea7d1_2.file.head.tpl.php:63 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_681286d9aa9106_46962547) /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:144 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/Bigsoholayouts_layout_left_column_tpl/79/53/21/7953218a69a5faaa48c4e3b281b371e70f946b1d_2.file.layout-both-columns.tpl.php:46 (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)
1	SELECT SQL_NO_CACHE gs., s., gs.name AS group_name, s.name AS shop_name, s.active, su.domain, su.domain_ssl, su.physical_uri, su.virtual_uri FROM psx1_shop_group gs LEFT JOIN psx1_shop s ON s.id_shop_group = gs.id_shop_group LEFT JOIN psx1_shop_url su ON s.id_shop = su.id_shop AND su.main = 1 WHERE s.deleted = 0 AND gs.deleted = 0 ORDER BY gs.name, s.name	4.035 ms	1	Yes		/classes/shop/Shop.php:715 /classes/shop/Shop.php:774 (cacheShops) /classes/Configuration.php:299 (getShops) /classes/shop/Shop.php:398 (getMultiShopValues) /config/config.inc.php:117 (initialize) /index.php:27 (require)
369	SELECT SQL_NO_CACHE 1 FROM `psx1_cart_rule` WHERE ((date_to >= "2025-05-01 00:00:00" AND date_to <= "2025-05-01 23:59:59") OR (date_from >= "2025-05-01 00:00:00" AND date_from <= "2025-05-01 23:59:59") OR (date_from < "2025-05-01 00:00:00" AND date_to > "2025-05-01 23:59:59")) AND `id_customer` IN (0,0) LIMIT 1	3.727 ms	1			/classes/CartRule.php:357 /classes/CartRule.php:389 (haveCartRuleToday) /classes/Cart.php:3079 (getCustomerCartRules) /classes/Cart.php:3463 (getDeliveryOptionList) /classes/Cart.php:3536 (getDeliveryOption) /src/Core/Cart/Fees.php:96 (getTotalShippingCost) /src/Core/Cart/Calculator.php:354 (processCalculation) /src/Core/Cart/Calculator.php:155 (calculateFees) /classes/Cart.php:2201 (processCalculation) /src/Adapter/Presenter/Cart/CartLazyArray.php:185 (getOrderTotal) /src/Adapter/Presenter/AbstractLazyArray.php:269 (getTotals) /src/Adapter/Presenter/AbstractLazyArray.php:129 (offsetGet) :undefined (jsonSerialize) /classes/Smarty/SmartyLazyRegister.php:81 (json_encode) /var/cache/prod/smarty/compile/Bigsoholayouts_layout_left_column_tpl/6f/4b/4b/6f4b4b48bd17a7978e75eeb4b344f752cc937740_2.file.javascript.tpl.php:65 (__call) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_681286d9addc61_68910423) /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/a3/76/4f/a3764fffcfe749f951697d739ead10f80e3ea7d1_2.file.head.tpl.php:386 (_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/a3/76/4f/a3764fffcfe749f951697d739ead10f80e3ea7d1_2.file.head.tpl.php:63 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_681286d9aa9106_46962547) /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:144 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/Bigsoholayouts_layout_left_column_tpl/79/53/21/7953218a69a5faaa48c4e3b281b371e70f946b1d_2.file.layout-both-columns.tpl.php:46 (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)
11	SELECT SQL_NO_CACHE COUNT(DISTINCT l.id_lang) FROM `psx1_lang` l JOIN psx1_lang_shop lang_shop ON (lang_shop.id_lang = l.id_lang AND lang_shop.id_shop = 1) WHERE l.`active` = 1 LIMIT 1	2.983 ms	4			/classes/Language.php:1216 /classes/Language.php:1513 (countActiveLanguages) /classes/Dispatcher.php:531 (isMultiLanguageActivated) /classes/Dispatcher.php:232 (setRequestUri) /classes/Dispatcher.php:201 (__construct) /index.php:28 (getInstance)
3	SELECT SQL_NO_CACHE * FROM `psx1_shop` a WHERE (a.`id_shop` = 1) LIMIT 1	2.908 ms	1			/src/Adapter/EntityMapper.php:71 /classes/ObjectModel.php:283 (load) /tools/profiling/ObjectModel.php:32 (__construct) /classes/shop/Shop.php:145 (__construct) /classes/shop/Shop.php:431 (__construct) /config/config.inc.php:117 (initialize) /index.php:27 (require)
182	REPLACE INTO psx1_layered_filter_block (hash, data) VALUES ("94110f406ab82771dda7d50349d0e694", "a:1:{s:7:\"filters\";a:9:{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:20;}i:0;a:2:{s:4:\"name\";s:13:\"No disponible\";s:3:\"nbr\";i:2;}}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:0;}s:3:\"new\";a:2:{s:4:\"name\";s:14:\"Nuevo producto\";s:3:\"nbr\";i:19;}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:39135;s:3:\"min\";d:99;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:22;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:9:{i:3;a:2:{s:4:\"name\";s:8:\"Cómputo\";s:3:\"nbr\";s:1:\"2\";}i:54;a:2:{s:4:\"name\";s:17:\"Control de acceso\";s:3:\"nbr\";s:2:\"17\";}i:75;a:2:{s:4:\"name\";s:19:\"Lectoras y Tarjetas\";s:3:\"nbr\";s:1:\"3\";}i:76;a:2:{s:4:\"name\";s:20:\"Proximidad (125 KHz)\";s:3:\"nbr\";s:1:\"3\";}i:77;a:2:{s:4:\"name\";s:12:\"Biométricos\";s:3:\"nbr\";s:2:\"12\";}i:78;a:2:{s:4:\"name\";s:22:\"Para Control de Acceso\";s:3:\"nbr\";s:1:\"6\";}i:104;a:2:{s:4:\"name\";s:28:\"Paneles de Control de Acceso\";s:3:\"nbr\";s:1:\"2\";}i:105;a:2:{s:4:\"name\";s:23:\"Controladores de Acceso\";s:3:\"nbr\";s:1:\"2\";}i:106;a:2:{s:4:\"name\";s:26:\"Enroladores y Lectores USB\";s:3:\"nbr\";s:1:\"1\";}}s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";s:1:\"0\";}i:4;a:9:{s:9:\"type_lite\";s:10:\"id_feature\";s:4:\"type\";s:10:\"id_feature\";s:6:\"id_key\";s:1:\"1\";s:6:\"values\";a:2:{i:1;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:6:\"AMD R3\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:6;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:13:\"Intel Core i3\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}}s:4:\"name\";s:10:\"Procesador\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";s:1:\"0\";}i:5;a:9:{s:9:\"type_lite\";s:10:\"id_feature\";s:4:\"type\";s:10:\"id_feature\";s:6:\"id_key\";s:1:\"2\";s:6:\"values\";a:2:{i:23;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:7:\"245 G10\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:24;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:2:\"G9\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}}s:4:\"name\";s:6:\"Modelo\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";s:1:\"0\";}i:6;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:3:{s:4:\"name\";s:2:\"HP\";s:3:\"nbr\";s:1:\"3\";s:7:\"checked\";b:1;}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:2:{s:4:\"name\";s:6:\"Stylos\";s:3:\"nbr\";s:1:\"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:3:{s:4:\"name\";s:7:\"SUPREMA\";s:3:\"nbr\";s:2:\"17\";s:7:\"checked\";b:1;}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:2:{s:4:\"name\";s:5:\"EZVIZ\";s:3:\"nbr\";s:2:\"12\";}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:2:{s:4:\"name\";s:5:\"AFORE\";s:3:\"nbr\";s:1:\"5\";}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:3:{s:4:\"name\";s:8:\"HIKMICRO\";s:3:\"nbr\";s:1:\"2\";s:7:\"checked\";b:1;}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:7;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:\"22\";}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:8;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:8.5;s:3:\"min\";d:0;s:4:\"unit\";s:2:\"kg\";s:14:\"specifications\";N;s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";i:3;s:5:\"value\";N;s:3:\"nbr\";i:22;}}}")	2.721 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)
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 (242, 1, 115, 180) 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.596 ms	529	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)
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 (242, 1, 115, 180) 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.526 ms	529			/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)
193	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.508 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)
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 (242, 1, 115, 180) 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.462 ms	529			/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)
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 (242, 1, 115, 180) 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	2.431 ms	529	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)
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)
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 (242, 1, 115, 180) AND c.nleft>=2 AND c.nright<=4175 GROUP BY p.id_product) p WHERE p.date_add>'2025-02-01 00:00:00'	2.161 ms	529			/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)
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	2.117 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)
194	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	2.021 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)
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`)	2.005 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)
178	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.978 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)
183	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 (2,3,15,1428,1767,1839,1885,1902,1919,1942,1947,1952)	1.853 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)
13	SELECT SQL_NO_CACHE lower(name) as name FROM `psx1_hook` h WHERE (h.active = 1)	1.807 ms	966			/classes/Hook.php:1366 /classes/Hook.php:811 (getHookStatusByName) /classes/Dispatcher.php:606 (exec) /classes/Dispatcher.php:243 (loadRoutes) /classes/Dispatcher.php:201 (__construct) /index.php:28 (getInstance)
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 (242, 1, 115, 180) 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.705 ms	529			/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)
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 (242, 1, 115, 180) AND c.nleft>=2 AND c.nright<=4175 GROUP BY p.id_product) p WHERE ((p.on_sale=1))	1.406 ms	529			/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)
15	SELECT SQL_NO_CACHE `name`, `alias` FROM `psx1_hook_alias`	1.338 ms	87			/classes/Hook.php:287 /classes/Hook.php:318 (getAllHookAliases) /classes/Hook.php:746 (getHookAliasesFor) /classes/Hook.php:842 (getHookModuleExecList) /classes/Dispatcher.php:606 (exec) /classes/Dispatcher.php:243 (loadRoutes) /classes/Dispatcher.php:201 (__construct) /index.php:28 (getInstance)
181	SELECT SQL_NO_CACHE MIN(p.weight) as min, MAX(p.weight) as max FROM psx1_product p 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 (242, 1, 115, 180) AND c.nleft>=2 AND c.nright<=4175	1.274 ms	23			/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:744 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:339 (getMinMaxValue) /modules/ps_facetedsearch/src/Filters/Block.php:134 (getWeightRangeBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
494	INSERT INTO `psx1_connections_source` (`id_connections`, `http_referer`, `request_uri`, `keywords`, `date_add`) VALUES ('2704721', '', 'whatabox.mx/mx/2-inicio?q=Marca-HIKMICRO-HP-SUPREMA-PRECISION', '', '2025-05-01 15:43:21')	1.227 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)
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 (242, 1, 115, 180) 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.158 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)
176	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 (242, 1, 115, 180) 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.077 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)
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 (242, 1, 115, 180) 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:43:19' >= sp.from) AND (sp.to = '0000-00-00 00:00:00' OR '2025-05-01 15:43:19' <= sp.to) ) WHERE ((sp.reduction>0))	0.987 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)
204	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` = 2 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` = 2 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1	0.923 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)
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 (242, 1, 115, 180) AND c.nleft>=2 AND c.nright<=4175	0.913 ms	23			/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)

#	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

Añadir al carrito