Inicio

Subcategorías

Grid
List

Hay 42 productos.

Ordenar por:

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

Últimas piezas!
- ¡En oferta!
Agregar a lista de deseos

Vista rápida

Agregar a comparación
All in One Dell Optiplex 7420 23.8" Intel Core i5-14500T 512GB SSD Ram 16GB...

$24,509

La Dell OptiPlex 7420 All-in-One de 23.8" combina un diseño elegante con un rendimiento potente, equipada con un procesador Intel Core i5-14500T, 16GB de RAM, 512GB SSD y.
Últimas piezas!
- Sólo por Internet
- ¡En oferta!
Agregar a lista de deseos

Vista rápida

Agregar a comparación
All in One Dell Inspiron 5430 23.8" Intel Core i5-1334U Disco duro 512 GB SSD...

$21,090

La Dell Inspiron 5430 All-in-One de 23.8" ofrece un diseño elegante y un rendimiento potente, equipada con un procesador Intel Core i5-1334U, 16 GB de RAM, 512 GB SSD y Windows.
- Nuevo
Agregar a lista de deseos

Vista rápida

Agregar a comparación
Bobina de 305 Metros / Cable de Cobre / 4 x 22 AWG / Tipo Alarmas UL / Para...

$2,661

Bobina de 305 Metros / Cable de Cobre / 4 x 22 AWG / Tipo Alarmas UL / Para Interior / Color Blanco / Para Aplicaciones de Alarmas de Intrusión / interfonos / TV Porteros / y.
- Nuevo
Agregar a lista de deseos

Vista rápida

Agregar a comparación
Fuente de alimentación para tira LED 009RGBIP65 / Solo compatible con...

$2,137

Fuente de alimentación para tira LED 009RGBIP65 / Solo compatible con barreras vehiculares CAME
- Nuevo
Agregar a lista de deseos

Vista rápida

Agregar a comparación
Tira LED RGB (Enciende en color Verde Rojo ) /Ideal para agregar iluminación...

$2,190

Tira LED RGB (Enciende en color Verde, Rojo ) /Ideal para agregar iluminación a las plumas vehiculares
- Nuevo
Agregar a lista de deseos

Vista rápida

Agregar a comparación
Paquete de 20 bandas reflectantes rojas para mástil 001-G0401001-G0601 CAME

$564

Paquete de 20 bandas reflectantes rojas para mástil 001-G0401,001-G0601 CAME
- Nuevo
Agregar a lista de deseos

Vista rápida

Agregar a comparación
Barrera vehicular GT4 Para Carriles de Hasta 4 Metros / Tiempo de Apertura 4...

$31,474

Barrera vehicular GT4 Para Carriles de Hasta 4 Metros / Tiempo de Apertura 4 Segundos / Izquierda o Derecha Configurable en Campo
- Nuevo
Agregar a lista de deseos

Vista rápida

Agregar a comparación
MASTIL 90 X 60 L 4220 MM PARA GT4

$6,739

MASTIL 90 X 60 L 4220 MM PARA GT4
- Nuevo
Agregar a lista de deseos

Vista rápida

Agregar a comparación
Refacción / Mástil de 4 M / Aluminio / Compatible con...

$3,643

Refacción / Mástil de 4 M / Aluminio / Compatible con KXBGGALED/KXBGG4LED/KXBGG4M / Tiras LED no incluídas
- Nuevo
Agregar a lista de deseos

Vista rápida

Agregar a comparación
Control remoto bicanal 433.92 MHz con auto aprendizaje

$1,245

Control remoto bicanal 433.92 MHz con auto aprendizaje
- Nuevo
Agregar a lista de deseos

Vista rápida

Agregar a comparación
Muelle equilibrado CAME / 50 mm / Resorte VERDE

$1,651

Muelle equilibrado CAME / 50 mm / Resorte VERDE
- Nuevo
Agregar a lista de deseos

Vista rápida

Agregar a comparación
Kit de Barrera Vehicular CAME GT4 con Brazo Iluminado Rojo-Verde / Izquierda...

$32,805

Kit de Barrera Vehicular CAME GT4 con Brazo Iluminado Rojo-Verde / Izquierda o Derecha Configurable en Campo /

Load Time	1273 ms
Querying Time	540 ms
Queries	491
Memory Peak Usage	27.6 Mb
Included Files	778 files - 9.99 Mb
PrestaShop Cache	- Mb
Global vars	0.23 Mb
- global $context	189k
- 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.004 ms	0.004 ms	3.19 Mb	9.1 Mb
__construct	20.700 ms	20.704 ms	0.09 Mb	9.1 Mb
init	238.678 ms	259.382 ms	2.87 Mb	9.1 Mb
checkAccess	0.002 ms	259.384 ms	- Mb	9.1 Mb
setMedia	40.190 ms	299.574 ms	0.47 Mb	9.1 Mb
postProcess	0.002 ms	299.576 ms	- Mb	9.1 Mb
initHeader	0.001 ms	299.577 ms	- Mb	9.1 Mb
initContent	717.368 ms	1017 ms	6.98 Mb	13.8 Mb
initFooter	0.002 ms	1017 ms	- Mb	13.8 Mb
display	256.069 ms	1273 ms	11.38 Mb	27.6 Mb

Hook	Time	Memory Usage
displayLeftColumn	95.792 ms	5.72 Mb
=> ps_categorytree (widget)	94.008 ms	5.62 Mb
=> cz_leftbanner (widget)	1.059 ms	0.04 Mb
=> cz_newproducts (widget)	0.725 ms	0.06 Mb
DisplayProductPriceBlock	20.453 ms	2.07 Mb
=> psproductcountdown	0.001 ms	- Mb
=> psproductcountdown	0.002 ms	- Mb
=> psproductcountdown	0.001 ms	- Mb
=> psproductcountdown	2.046 ms	0.20 Mb
=> psproductcountdown	0.001 ms	- Mb
=> psproductcountdown	0.001 ms	- Mb
=> psproductcountdown	0.001 ms	- Mb
=> psproductcountdown	1.924 ms	0.16 Mb
=> psproductcountdown	0.001 ms	- Mb
=> psproductcountdown	0.001 ms	- Mb
=> psproductcountdown	0.001 ms	- Mb
=> psproductcountdown	1.862 ms	0.20 Mb
=> psproductcountdown	0.001 ms	- Mb
=> psproductcountdown	0.001 ms	- Mb
=> psproductcountdown	0.001 ms	- Mb
=> psproductcountdown	1.691 ms	0.16 Mb
=> psproductcountdown	0.001 ms	- Mb
=> psproductcountdown	0.001 ms	- Mb
=> psproductcountdown	0.001 ms	- Mb
=> psproductcountdown	1.780 ms	0.16 Mb
=> psproductcountdown	0.001 ms	- Mb
=> psproductcountdown	0.001 ms	- Mb
=> psproductcountdown	0.001 ms	- Mb
=> psproductcountdown	1.654 ms	0.16 Mb
=> psproductcountdown	0.001 ms	- Mb
=> psproductcountdown	0.001 ms	- Mb
=> psproductcountdown	0.001 ms	- Mb
=> psproductcountdown	1.867 ms	0.17 Mb
=> psproductcountdown	0.001 ms	- Mb
=> psproductcountdown	0.001 ms	- Mb
=> psproductcountdown	0.001 ms	- Mb
=> psproductcountdown	1.663 ms	0.16 Mb
=> psproductcountdown	0.001 ms	- Mb
=> psproductcountdown	0.001 ms	- Mb
=> psproductcountdown	0.001 ms	- Mb
=> psproductcountdown	1.607 ms	0.16 Mb
=> psproductcountdown	0.001 ms	- Mb
=> psproductcountdown	0.000 ms	- Mb
=> psproductcountdown	0.000 ms	- Mb
=> psproductcountdown	1.575 ms	0.16 Mb
=> psproductcountdown	0.002 ms	- Mb
=> psproductcountdown	0.001 ms	- Mb
=> psproductcountdown	0.001 ms	- Mb
=> psproductcountdown	1.437 ms	0.16 Mb
=> psproductcountdown	0.001 ms	- Mb
=> psproductcountdown	0.001 ms	- Mb
=> psproductcountdown	0.000 ms	- Mb
=> psproductcountdown	1.313 ms	0.17 Mb
DisplayBeforeBodyClosingTag	15.578 ms	0.07 Mb
=> statsdata	15.578 ms	0.07 Mb
DisplayCzHoverImage	8.402 ms	0.55 Mb
=> cz_imagehover	1.151 ms	0.06 Mb
=> cz_imagehover	1.050 ms	0.05 Mb
=> cz_imagehover	0.678 ms	0.04 Mb
=> cz_imagehover	0.599 ms	0.04 Mb
=> cz_imagehover	0.590 ms	0.04 Mb
=> cz_imagehover	0.616 ms	0.04 Mb
=> cz_imagehover	0.593 ms	0.04 Mb
=> cz_imagehover	0.668 ms	0.04 Mb
=> cz_imagehover	0.583 ms	0.04 Mb
=> cz_imagehover	0.540 ms	0.04 Mb
=> cz_imagehover	0.765 ms	0.04 Mb
=> cz_imagehover	0.569 ms	0.04 Mb
displayFooter	6.496 ms	0.51 Mb
=> ps_contactinfo (widget)	1.738 ms	0.07 Mb
=> ps_socialfollow (widget)	0.611 ms	0.05 Mb
=> ps_linklist (widget)	0.980 ms	0.06 Mb
=> ps_customeraccountlinks (widget)	0.724 ms	0.13 Mb
=> ps_emailsubscription (widget)	0.936 ms	0.05 Mb
=> cz_themeimages (widget)	0.806 ms	0.05 Mb
=> cz_themeoptions (widget)	0.701 ms	0.10 Mb
displayTop	5.764 ms	0.28 Mb
=> ps_shoppingcart (widget)	2.857 ms	0.13 Mb
=> ps_customersignin (widget)	2.170 ms	0.10 Mb
=> ps_searchbar (widget)	0.737 ms	0.04 Mb
ProductSearchProvider	5.168 ms	0.07 Mb
=> ps_facetedsearch	5.168 ms	0.07 Mb
displayNavFullWidth	3.581 ms	0.24 Mb
=> cz_verticalmenu (widget)	1.808 ms	0.12 Mb
=> ps_mainmenu (widget)	1.773 ms	0.12 Mb
ActionFrontControllerSetMedia	3.302 ms	0.07 Mb
=> blockreassurance	2.970 ms	0.07 Mb
=> ps_emailsubscription	0.206 ms	- Mb
=> ps_socialfollow	0.068 ms	- Mb
=> ps_emailalerts	0.058 ms	- Mb
displayNav1	3.012 ms	0.08 Mb
=> cz_navcmsblock (widget)	3.012 ms	0.08 Mb
Header	2.883 ms	0.04 Mb
=> stripe_official	0.025 ms	- Mb
=> customhtml	1.092 ms	0.01 Mb
=> cz_themeoptions	0.568 ms	0.01 Mb
=> psproductcountdown	1.198 ms	0.02 Mb
DisplayStWishlistButton	2.685 ms	0.02 Mb
=> stfeature	0.638 ms	0.01 Mb
=> stfeature	0.187 ms	- Mb
=> stfeature	0.179 ms	- Mb
=> stfeature	0.199 ms	- Mb
=> stfeature	0.175 ms	- Mb
=> stfeature	0.170 ms	- Mb
=> stfeature	0.189 ms	- Mb
=> stfeature	0.238 ms	- Mb
=> stfeature	0.160 ms	- Mb
=> stfeature	0.200 ms	- Mb
=> stfeature	0.183 ms	- Mb
=> stfeature	0.167 ms	- Mb
DisplayFooter	1.945 ms	0.19 Mb
=> czuecookie	1.945 ms	0.19 Mb
DisplayStCompareButton	1.666 ms	0.01 Mb
=> stfeature	0.329 ms	0.01 Mb
=> stfeature	0.135 ms	- Mb
=> stfeature	0.132 ms	- Mb
=> stfeature	0.108 ms	- Mb
=> stfeature	0.109 ms	- Mb
=> stfeature	0.123 ms	- Mb
=> stfeature	0.167 ms	- Mb
=> stfeature	0.114 ms	- Mb
=> stfeature	0.104 ms	- Mb
=> stfeature	0.110 ms	- Mb
=> stfeature	0.150 ms	- Mb
=> stfeature	0.085 ms	- Mb
DisplayHeader	1.050 ms	0.02 Mb
=> ps_shoppingcart	0.099 ms	- Mb
=> ps_searchbar	0.102 ms	- Mb
=> cz_verticalmenu	0.055 ms	- Mb
=> cz_imageslider	0.100 ms	- Mb
=> cz_instagramfeeds	0.090 ms	- Mb
=> myprestacomments	0.358 ms	- Mb
=> stfeature	0.246 ms	0.01 Mb
Footer	0.822 ms	0.01 Mb
=> customhtml	0.822 ms	0.01 Mb
displayFooterAfter	0.793 ms	- Mb
=> cz_blocklink (widget)	0.793 ms	- Mb
DisplayStWishlistTopLink	0.752 ms	0.04 Mb
=> stfeature	0.752 ms	0.04 Mb
DisplayLeftColumn	0.431 ms	0.12 Mb
=> ps_facetedsearch	0.431 ms	0.12 Mb
DisplayStCompareTopLink	0.281 ms	0.01 Mb
=> stfeature	0.281 ms	0.01 Mb
DisplayProductListReviews	0.026 ms	- Mb
=> psproductcountdown	0.003 ms	- Mb
=> psproductcountdown	0.003 ms	- Mb
=> psproductcountdown	0.001 ms	- Mb
=> psproductcountdown	0.002 ms	- Mb
=> psproductcountdown	0.002 ms	- Mb
=> psproductcountdown	0.002 ms	- Mb
=> psproductcountdown	0.002 ms	- Mb
=> psproductcountdown	0.002 ms	- Mb
=> psproductcountdown	0.002 ms	- Mb
=> psproductcountdown	0.002 ms	- Mb
=> psproductcountdown	0.003 ms	- Mb
=> psproductcountdown	0.002 ms	- Mb
DisplayFooterAfter	0.006 ms	- Mb
=> cz_themeoptions	0.006 ms	- Mb
22 hook(s)	180.887 ms	10.08 Mb

Module	Time	Memory Usage
blockreassurance	14.723 ms	0.22 Mb
__construct	11.749 ms	0.15 Mb
hookActionFrontControllerSetMedia	2.974 ms	0.07 Mb
ps_emailsubscription	6.627 ms	0.08 Mb
__construct	5.479 ms	0.03 Mb
hookActionFrontControllerSetMedia	0.209 ms	- Mb
displayFooter	0.939 ms	0.05 Mb
ps_socialfollow	8.127 ms	0.07 Mb
__construct	7.443 ms	0.02 Mb
hookActionFrontControllerSetMedia	0.071 ms	- Mb
displayFooter	0.613 ms	0.05 Mb
ps_emailalerts	6.535 ms	0.04 Mb
__construct	6.473 ms	0.04 Mb
hookActionFrontControllerSetMedia	0.062 ms	- Mb
ps_shoppingcart	4.269 ms	0.15 Mb
__construct	1.306 ms	0.02 Mb
hookDisplayHeader	0.102 ms	- Mb
displayTop	2.861 ms	0.14 Mb
ps_searchbar	1.177 ms	0.06 Mb
__construct	0.334 ms	0.02 Mb
hookDisplayHeader	0.103 ms	- Mb
displayTop	0.740 ms	0.04 Mb
cz_verticalmenu	29.002 ms	0.16 Mb
__construct	27.133 ms	0.03 Mb
hookDisplayHeader	0.058 ms	- Mb
displayNavFullWidth	1.811 ms	0.12 Mb
cz_imageslider	5.389 ms	0.10 Mb
__construct	5.285 ms	0.10 Mb
hookDisplayHeader	0.104 ms	- Mb
cz_instagramfeeds	2.174 ms	0.02 Mb
__construct	2.081 ms	0.02 Mb
hookDisplayHeader	0.093 ms	- Mb
myprestacomments	7.931 ms	0.16 Mb
__construct	7.568 ms	0.15 Mb
hookDisplayHeader	0.363 ms	0.01 Mb
stfeature	11.376 ms	0.16 Mb
__construct	5.682 ms	0.06 Mb
hookDisplayHeader	0.250 ms	0.01 Mb
hookDisplayStWishlistTopLink	0.756 ms	0.04 Mb
hookDisplayStCompareTopLink	0.283 ms	0.01 Mb
hookDisplayStWishlistButton	0.641 ms	0.01 Mb
hookDisplayStCompareButton	0.332 ms	0.01 Mb
hookDisplayStWishlistButton	0.190 ms	- Mb
hookDisplayStCompareButton	0.137 ms	- Mb
hookDisplayStWishlistButton	0.181 ms	- Mb
hookDisplayStCompareButton	0.134 ms	- Mb
hookDisplayStWishlistButton	0.201 ms	- Mb
hookDisplayStCompareButton	0.110 ms	- Mb
hookDisplayStWishlistButton	0.178 ms	- Mb
hookDisplayStCompareButton	0.111 ms	- Mb
hookDisplayStWishlistButton	0.172 ms	- Mb
hookDisplayStCompareButton	0.125 ms	- Mb
hookDisplayStWishlistButton	0.192 ms	- Mb
hookDisplayStCompareButton	0.169 ms	- Mb
hookDisplayStWishlistButton	0.241 ms	- Mb
hookDisplayStCompareButton	0.116 ms	- Mb
hookDisplayStWishlistButton	0.162 ms	- Mb
hookDisplayStCompareButton	0.106 ms	- Mb
hookDisplayStWishlistButton	0.202 ms	- Mb
hookDisplayStCompareButton	0.112 ms	- Mb
hookDisplayStWishlistButton	0.185 ms	- Mb
hookDisplayStCompareButton	0.153 ms	- Mb
hookDisplayStWishlistButton	0.169 ms	- Mb
hookDisplayStCompareButton	0.087 ms	- Mb
stripe_official	43.667 ms	0.23 Mb
__construct	43.639 ms	0.23 Mb
hookHeader	0.028 ms	- Mb
customhtml	2.314 ms	0.04 Mb
__construct	0.393 ms	0.02 Mb
hookHeader	1.096 ms	0.01 Mb
hookFooter	0.825 ms	0.01 Mb
cz_themeoptions	44.413 ms	0.31 Mb
__construct	43.131 ms	0.20 Mb
hookHeader	0.572 ms	0.01 Mb
displayFooter	0.703 ms	0.10 Mb
hookDisplayFooterAfter	0.007 ms	- Mb
psproductcountdown	51.169 ms	2.22 Mb
__construct	29.396 ms	0.11 Mb
hookHeader	1.202 ms	0.02 Mb
hookDisplayProductListReviews	0.005 ms	- Mb
hookDisplayProductPriceBlock	0.002 ms	- Mb
hookDisplayProductPriceBlock	0.003 ms	- Mb
hookDisplayProductPriceBlock	0.002 ms	- Mb
hookDisplayProductPriceBlock	2.050 ms	0.20 Mb
hookDisplayProductListReviews	0.004 ms	- Mb
hookDisplayProductPriceBlock	0.002 ms	- Mb
hookDisplayProductPriceBlock	0.002 ms	- Mb
hookDisplayProductPriceBlock	0.002 ms	- Mb
hookDisplayProductPriceBlock	1.928 ms	0.16 Mb
hookDisplayProductListReviews	0.003 ms	- Mb
hookDisplayProductPriceBlock	0.002 ms	- Mb
hookDisplayProductPriceBlock	0.001 ms	- Mb
hookDisplayProductPriceBlock	0.002 ms	- Mb
hookDisplayProductPriceBlock	1.864 ms	0.20 Mb
hookDisplayProductListReviews	0.004 ms	- Mb
hookDisplayProductPriceBlock	0.002 ms	- Mb
hookDisplayProductPriceBlock	0.002 ms	- Mb
hookDisplayProductPriceBlock	0.002 ms	- Mb
hookDisplayProductPriceBlock	1.693 ms	0.16 Mb
hookDisplayProductListReviews	0.003 ms	- Mb
hookDisplayProductPriceBlock	0.003 ms	- Mb
hookDisplayProductPriceBlock	0.002 ms	- Mb
hookDisplayProductPriceBlock	0.002 ms	- Mb
hookDisplayProductPriceBlock	1.783 ms	0.16 Mb
hookDisplayProductListReviews	0.003 ms	- Mb
hookDisplayProductPriceBlock	0.002 ms	- Mb
hookDisplayProductPriceBlock	0.002 ms	- Mb
hookDisplayProductPriceBlock	0.002 ms	- Mb
hookDisplayProductPriceBlock	1.657 ms	0.16 Mb
hookDisplayProductListReviews	0.004 ms	- Mb
hookDisplayProductPriceBlock	0.003 ms	- Mb
hookDisplayProductPriceBlock	0.001 ms	- Mb
hookDisplayProductPriceBlock	0.002 ms	- Mb
hookDisplayProductPriceBlock	1.871 ms	0.17 Mb
hookDisplayProductListReviews	0.004 ms	- Mb
hookDisplayProductPriceBlock	0.003 ms	- Mb
hookDisplayProductPriceBlock	0.002 ms	- Mb
hookDisplayProductPriceBlock	0.003 ms	- Mb
hookDisplayProductPriceBlock	1.666 ms	0.16 Mb
hookDisplayProductListReviews	0.004 ms	- Mb
hookDisplayProductPriceBlock	0.002 ms	- Mb
hookDisplayProductPriceBlock	0.001 ms	- Mb
hookDisplayProductPriceBlock	0.001 ms	- Mb
hookDisplayProductPriceBlock	1.610 ms	0.16 Mb
hookDisplayProductListReviews	0.004 ms	- Mb
hookDisplayProductPriceBlock	0.002 ms	- Mb
hookDisplayProductPriceBlock	0.001 ms	- Mb
hookDisplayProductPriceBlock	0.001 ms	- Mb
hookDisplayProductPriceBlock	1.578 ms	0.16 Mb
hookDisplayProductListReviews	0.004 ms	- Mb
hookDisplayProductPriceBlock	0.003 ms	- Mb
hookDisplayProductPriceBlock	0.002 ms	- Mb
hookDisplayProductPriceBlock	0.001 ms	- Mb
hookDisplayProductPriceBlock	1.441 ms	0.16 Mb
hookDisplayProductListReviews	0.003 ms	- Mb
hookDisplayProductPriceBlock	0.002 ms	- Mb
hookDisplayProductPriceBlock	0.001 ms	- Mb
hookDisplayProductPriceBlock	0.001 ms	- Mb
hookDisplayProductPriceBlock	1.316 ms	0.17 Mb
ps_facetedsearch	46.276 ms	0.30 Mb
__construct	40.668 ms	0.11 Mb
hookProductSearchProvider	5.175 ms	0.07 Mb
hookDisplayLeftColumn	0.433 ms	0.12 Mb
cz_navcmsblock	4.508 ms	0.10 Mb
__construct	1.490 ms	0.02 Mb
displayNav1	3.018 ms	0.08 Mb
ps_customersignin	2.595 ms	0.12 Mb
__construct	0.423 ms	0.02 Mb
displayTop	2.172 ms	0.10 Mb
ps_mainmenu	8.020 ms	0.15 Mb
__construct	6.243 ms	0.03 Mb
displayNavFullWidth	1.777 ms	0.12 Mb
ps_categorytree	95.237 ms	5.70 Mb
__construct	1.223 ms	0.08 Mb
displayLeftColumn	94.014 ms	5.62 Mb
cz_leftbanner	4.811 ms	0.08 Mb
__construct	3.748 ms	0.03 Mb
displayLeftColumn	1.063 ms	0.04 Mb
cz_newproducts	1.887 ms	0.07 Mb
__construct	1.160 ms	0.02 Mb
displayLeftColumn	0.727 ms	0.06 Mb
cz_imagehover	8.888 ms	0.58 Mb
__construct	0.455 ms	0.02 Mb
hookDisplayCzHoverImage	1.154 ms	0.06 Mb
hookDisplayCzHoverImage	1.053 ms	0.05 Mb
hookDisplayCzHoverImage	0.680 ms	0.05 Mb
hookDisplayCzHoverImage	0.601 ms	0.05 Mb
hookDisplayCzHoverImage	0.592 ms	0.05 Mb
hookDisplayCzHoverImage	0.618 ms	0.05 Mb
hookDisplayCzHoverImage	0.595 ms	0.05 Mb
hookDisplayCzHoverImage	0.671 ms	0.05 Mb
hookDisplayCzHoverImage	0.586 ms	0.05 Mb
hookDisplayCzHoverImage	0.543 ms	0.05 Mb
hookDisplayCzHoverImage	0.769 ms	0.05 Mb
hookDisplayCzHoverImage	0.571 ms	0.05 Mb
ps_contactinfo	2.353 ms	0.09 Mb
__construct	0.612 ms	0.02 Mb
displayFooter	1.741 ms	0.07 Mb
ps_linklist	16.017 ms	0.09 Mb
__construct	15.034 ms	0.03 Mb
displayFooter	0.983 ms	0.06 Mb
ps_customeraccountlinks	1.273 ms	0.15 Mb
__construct	0.546 ms	0.02 Mb
displayFooter	0.727 ms	0.13 Mb
cz_themeimages	1.954 ms	0.07 Mb
__construct	1.145 ms	0.02 Mb
displayFooter	0.809 ms	0.05 Mb
czuecookie	2.546 ms	0.21 Mb
__construct	0.597 ms	0.02 Mb
hookDisplayFooter	1.949 ms	0.19 Mb
cz_blocklink	2.873 ms	- Mb
__construct	2.077 ms	0.02 Mb
displayFooterAfter	0.796 ms	- Mb
statsdata	16.436 ms	0.08 Mb
__construct	0.851 ms	0.02 Mb
hookDisplayBeforeBodyClosingTag	15.585 ms	0.07 Mb
30 module(s)	454.567 ms	11.79 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 * 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 product_type FROM `psxXX_product` WHERE id_product = XX LIMIT XX
12 queries	SELECT SUM(quantity) FROM `psxXX_stock_available` WHERE (id_product = XX) AND (id_product_attribute = XX) AND (id_shop = XX) AND (id_shop_group = XX) LIMIT XX
12 queries	SELECT COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), XX) as deep_quantity, COALESCE(SUM(first_level_quantity), XX) as quantity FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, XX as pack_quantity FROM `psxXX_cart_product` cp WHERE cp.`id_product_attribute` = XX AND cp.`id_cart` = XX AND cp.`id_product` = XX UNION SELECT XX as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity FROM `psxXX_cart_product` cp JOIN `psxXX_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `psxXX_product` pr ON p.`id_product_pack` = pr.`id_product` WHERE cp.`id_product_attribute` = XX AND cp.`id_cart` = XX AND p.`id_product_item` = XX AND (pr.`pack_stock_type` IN (XX,XX) OR ( pr.`pack_stock_type` = XX AND XX = XX ))) as q LIMIT XX
12 queries	SELECT name, value, pf.id_feature, f.position, fvl.id_feature_value FROM psxXX_feature_product pf LEFT JOIN psxXX_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = XX) LEFT JOIN psxXX_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = XX) LEFT JOIN psxXX_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = XX) INNER JOIN psxXX_feature_shop feature_shop ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = XX) WHERE pf.id_product = XX ORDER BY f.position ASC
12 queries	SELECT `id_tax_rules_group` FROM `psxXX_product_shop` WHERE `id_product` = XX AND id_shop=XX LIMIT XX
12 queries	SELECT pa.`id_product`, a.`color`, pac.`id_product_attribute`, XX qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by FROM `psxXX_product_attribute` pa INNER JOIN psxXX_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = XX) JOIN `psxXX_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`) JOIN `psxXX_attribute` a ON (a.`id_attribute` = pac.`id_attribute`) JOIN `psxXX_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = XX) JOIN `psxXX_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`) WHERE pa.`id_product` IN (XX) AND ag.`is_color_group` = XX GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` ORDER BY a.`position` ASC;
12 queries	SELECT DISTINCT a.`id_attribute`, a.`id_attribute_group`, al.`name` as `attribute`, agl.`name` as `group`,pa.`reference`, pa.`eanXX`, pa.`isbn`, pa.`upc`, pa.`mpn` FROM `psxXX_attribute` a LEFT JOIN `psxXX_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = XX) LEFT JOIN `psxXX_attribute_group_lang` agl ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = XX) LEFT JOIN `psxXX_product_attribute_combination` pac ON (a.`id_attribute` = pac.`id_attribute`) LEFT JOIN `psxXX_product_attribute` pa ON (pac.`id_product_attribute` = pa.`id_product_attribute`) INNER JOIN psxXX_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = XX) INNER JOIN psxXX_attribute_shop attribute_shop ON (attribute_shop.id_attribute = pac.id_attribute AND attribute_shop.id_shop = XX) WHERE pa.`id_product` = XX
12 queries	SELECT * FROM `psxXX_product_lang` WHERE `id_product` = XX AND `id_shop` = XX
12 queries	SELECT `reduction` FROM `psxXX_product_group_reduction_cache` WHERE `id_product` = XX AND `id_group` = 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 image_shop.`id_image` FROM `psxXX_image` i INNER JOIN psxXX_image_shop image_shop ON (image_shop.id_image = i.id_image AND image_shop.id_shop = XX) WHERE i.`id_product` = XX AND image_shop.`cover` = XX LIMIT XX
12 queries	SELECT `id_product_attribute` FROM `psxXX_product_attribute` WHERE `id_product` = XX
12 queries	SELECT COUNT(*) FROM `psxXX_pack` WHERE id_product_pack = XX LIMIT XX
4 queries	SELECT cl.`link_rewrite` FROM `psxXX_category_lang` cl WHERE `id_lang` = XX AND cl.id_shop = XX AND cl.`id_category` = XX LIMIT XX
4 queries	SELECT `id_lang` FROM `psxXX_lang` WHERE `locale` = 'es-mx' OR `language_code` = 'es-mx' LIMIT XX
3 queries	SELECT `name` FROM `psxXX_manufacturer` WHERE `id_manufacturer` = XX AND `active` = XX LIMIT XX
3 queries	SELECT tr.* FROM `psxXX_tax_rule` tr JOIN `psxXX_tax_rules_group` trg ON (tr.`id_tax_rules_group` = trg.`id_tax_rules_group`) WHERE trg.`active` = XX AND tr.`id_country` = XX AND tr.`id_tax_rules_group` = XX AND tr.`id_state` IN (XX, XX) AND ('XX' BETWEEN tr.`zipcode_from` AND tr.`zipcode_to` OR (tr.`zipcode_to` = XX AND tr.`zipcode_from` IN(XX, 'XX'))) ORDER BY tr.`zipcode_from` DESC, tr.`zipcode_to` DESC, tr.`id_state` DESC, tr.`id_country` DESC
2 queries	SELECT `need_identification_number` FROM `psxXX_country` WHERE `id_country` = XX LIMIT XX
2 queries	SELECT `id_category` FROM `psxXX_category_shop` WHERE `id_category` = XX AND `id_shop` = XX LIMIT XX
2 queries	SELECT 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 * FROM `psxXX_currency` a LEFT JOIN `psxXX_currency_lang` `b` ON a.`id_currency` = b.`id_currency` AND b.`id_lang` = XX LEFT JOIN `psxXX_currency_shop` `c` ON a.`id_currency` = c.`id_currency` AND c.`id_shop` = XX WHERE (a.`id_currency` = XX) LIMIT XX
2 queries	SELECT m.*, ml.`description`, ml.`short_description` FROM `psxXX_manufacturer` m INNER JOIN psxXX_manufacturer_shop manufacturer_shop ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = XX)INNER JOIN `psxXX_manufacturer_lang` ml ON (m.`id_manufacturer` = ml.`id_manufacturer` AND ml.`id_lang` = XX)WHERE XX AND m.`active` = XX ORDER BY m.`name` ASC
2 queries	SELECT XX FROM `psxXX_cart_rule` WHERE ((date_to >= "XX-XX-XX XX:XX:XX" AND date_to <= "XX-XX-XX XX:XX:XX") OR (date_from >= "XX-XX-XX XX:XX:XX" AND date_from <= "XX-XX-XX XX:XX:XX") OR (date_from < "XX-XX-XX XX:XX:XX" AND date_to > "XX-XX-XX XX:XX:XX")) AND `id_customer` IN (XX,XX) LIMIT XX
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

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: 9] /classes/Link.php:113 (__construct) [id: 10] /classes/Link.php:113 (__construct) [id: 1329] /classes/Link.php:113 (__construct) [id: 1358] /classes/Link.php:113 (__construct) [id: 1359] /classes/Link.php:113 (__construct) [id: 1369] /classes/Link.php:113 (__construct) [id: 1599] /classes/Link.php:113 (__construct) [id: 1600] /classes/Link.php:113 (__construct) [id: 1733] /classes/Link.php:113 (__construct) [id: 1737] /classes/Link.php:113 (__construct) [id: 1742] /classes/Link.php:113 (__construct) [id: 1760] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 9] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 10] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 1329] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 1358] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 1359] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 1369] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 1599] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 1600] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 1733] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 1737] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 1742] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 1760] /classes/Link.php:113 (__construct) [id: 9] /classes/Link.php:113 (__construct) [id: 10] /classes/Link.php:113 (__construct) [id: 1329] /classes/Link.php:113 (__construct) [id: 1358] /classes/Link.php:113 (__construct) [id: 1359] /classes/Link.php:113 (__construct) [id: 1369] /classes/Link.php:113 (__construct) [id: 1599] /classes/Link.php:113 (__construct) [id: 1600] /classes/Link.php:113 (__construct) [id: 1733] /classes/Link.php:113 (__construct) [id: 1737] /classes/Link.php:113 (__construct) [id: 1742] /classes/Link.php:113 (__construct) [id: 1760] /modules/cz_imagehover/cz_imagehover.php:73 (__construct) [id: 9] /modules/psproductcountdown/psproductcountdown.php:1574 (__construct) [id: 9] /modules/cz_imagehover/cz_imagehover.php:73 (__construct) [id: 10] /modules/psproductcountdown/psproductcountdown.php:1574 (__construct) [id: 10] /modules/cz_imagehover/cz_imagehover.php:73 (__construct) [id: 1329] /modules/psproductcountdown/psproductcountdown.php:1574 (__construct) [id: 1329] /modules/cz_imagehover/cz_imagehover.php:73 (__construct) [id: 1358] /modules/psproductcountdown/psproductcountdown.php:1574 (__construct) [id: 1358] /modules/cz_imagehover/cz_imagehover.php:73 (__construct) [id: 1359] /modules/psproductcountdown/psproductcountdown.php:1574 (__construct) [id: 1359] /modules/cz_imagehover/cz_imagehover.php:73 (__construct) [id: 1369] /modules/psproductcountdown/psproductcountdown.php:1574 (__construct) [id: 1369] /modules/cz_imagehover/cz_imagehover.php:73 (__construct) [id: 1599] /modules/psproductcountdown/psproductcountdown.php:1574 (__construct) [id: 1599] /modules/cz_imagehover/cz_imagehover.php:73 (__construct) [id: 1600] /modules/psproductcountdown/psproductcountdown.php:1574 (__construct) [id: 1600] /modules/cz_imagehover/cz_imagehover.php:73 (__construct) [id: 1733] /modules/psproductcountdown/psproductcountdown.php:1574 (__construct) [id: 1733] /modules/cz_imagehover/cz_imagehover.php:73 (__construct) [id: 1737] /modules/psproductcountdown/psproductcountdown.php:1574 (__construct) [id: 1737] /modules/cz_imagehover/cz_imagehover.php:73 (__construct) [id: 1742] /modules/psproductcountdown/psproductcountdown.php:1574 (__construct) [id: 1742] /modules/cz_imagehover/cz_imagehover.php:73 (__construct) [id: 1760] /modules/psproductcountdown/psproductcountdown.php:1574 (__construct) [id: 1760]
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	135.646 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)
388	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	55.042 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)
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	15.603 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)
34	SELECT SQL_NO_CACHE `id_category` FROM `psx1_category_shop` WHERE `id_category` = 2 AND `id_shop` = 1 LIMIT 1	13.180 ms	1			/classes/Category.php:2450 /controllers/front/listing/CategoryController.php:83 (existsInShop) /tools/profiling/Controller.php:41 (init) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
490	INSERT INTO `psx1_connections_source` (`id_connections`, `http_referer`, `request_uri`, `keywords`, `date_add`) VALUES ('2704699', '', 'whatabox.mx/mx/2-inicio?q=Marca-CAME-CONDUMEX-DELL-CYBERPOWER', '', '2025-05-01 15:40:29')	12.950 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)
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	10.624 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)
22	SELECT SQL_NO_CACHE `id_lang` FROM `psx1_lang` WHERE `locale` = 'es-mx' OR `language_code` = 'es-mx' LIMIT 1	10.234 ms	2			/classes/Language.php:883 /src/Adapter/Currency/CurrencyDataProvider.php:112 (getIdByLocale) /src/Core/Localization/Currency/DataLayer/CurrencyDatabase.php:102 (getCurrencyByIsoCodeAndLocale) /src/Core/Data/Layer/AbstractDataLayer.php:91 (doRead) /src/Core/Data/Layer/AbstractDataLayer.php:150 (read) /src/Core/Data/Layer/AbstractDataLayer.php:95 (propagateRead) /src/Core/Localization/Currency/CurrencyDataSource.php:67 (read) /src/Core/Localization/Currency/CurrencyDataSource.php:109 (getLocalizedCurrencyData) /src/Core/Localization/Currency/CurrencyDataSource.php:96 (formatCurrenciesData) /src/Core/Localization/Currency/Repository.php:87 (getAllInstalledCurrenciesData) /src/Core/Localization/Locale/Repository.php:207 (getAllInstalledCurrencies) /src/Core/Localization/Locale/Repository.php:150 (getPriceSpecifications) /classes/controller/Controller.php:209 (getLocale) /classes/controller/FrontController.php:284 (init) /override/classes/controller/FrontController.php:26 (init) /controllers/front/listing/CategoryController.php:81 (init) /tools/profiling/Controller.php:41 (init) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
149	SELECT SQL_NO_CACHE * FROM `psx1_country` a 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	10.003 ms	1			/src/Adapter/EntityMapper.php:71 /classes/ObjectModel.php:283 (load) /tools/profiling/ObjectModel.php:32 (__construct) /classes/AddressFormat.php:404 (__construct) /classes/AddressFormat.php:439 (getFormattedAddressFieldsValues) /classes/controller/FrontController.php:1773 (generateAddress) /classes/controller/FrontController.php:563 (getTemplateVarShop) /classes/controller/FrontController.php:625 (assignGeneralPurposeVariables) /controllers/front/listing/CategoryController.php:127 (initContent) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
151	SELECT SQL_NO_CACHE id_required_field, object_name, field_name FROM psx1_required_field	9.966 ms	2			/classes/ObjectModel.php:1592 /classes/ObjectModel.php:1624 (getFieldsRequiredDatabase) /classes/ObjectModel.php:1555 (cacheFieldsRequiredDatabase) /classes/controller/FrontController.php:567 (validateFieldsRequiredDatabase) /classes/controller/FrontController.php:625 (assignGeneralPurposeVariables) /controllers/front/listing/CategoryController.php:127 (initContent) /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 (169, 165, 104, 3) AND c.nleft>=2 AND c.nright<=4175 GROUP BY p.id_product) p WHERE ((p.on_sale=1))	9.929 ms	1849			/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)
161	SELECT SQL_NO_CACHE * FROM `psx1_category` a LEFT JOIN `psx1_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1 WHERE (a.`id_category` = 2) LIMIT 1	9.793 ms	1			/src/Adapter/EntityMapper.php:71 /classes/ObjectModel.php:283 (load) /tools/profiling/ObjectModel.php:32 (__construct) /classes/Category.php:164 (__construct) /modules/ps_facetedsearch/src/Product/Search.php:364 (__construct) /modules/ps_facetedsearch/src/Product/Search.php:130 (addControllerSpecificFilters) /modules/ps_facetedsearch/src/Product/SearchProvider.php:173 (initSearch) /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 (169, 165, 104, 3) AND c.nleft>=2 AND c.nright<=4175 GROUP BY p.id_product) p WHERE p.date_add>'2025-02-01 00:00:00'	9.176 ms	1849			/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)
157	SELECT SQL_NO_CACHE type, id_value, filter_show_limit, filter_type FROM psx1_layered_category WHERE controller = 'category' AND id_category = 2 AND id_shop = 1 GROUP BY `type`, id_value ORDER BY position ASC	8.887 ms	13	Yes	Yes	/modules/ps_facetedsearch/src/Filters/Provider.php:61 /modules/ps_facetedsearch/src/Filters/Converter.php:263 (getFiltersForQuery) /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)
140	SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module`as `mshop` FROM `psx1_module` m LEFT JOIN `psx1_module_shop` ms ON m.`id_module` = ms.`id_module` AND ms.`id_shop` = 1	8.523 ms	96			/classes/module/Module.php:346 /modules/blockreassurance/blockreassurance.php:102 (__construct) :undefined (__construct) /src/Core/Foundation/IoC/Container.php:123 (newInstance) /src/Core/Foundation/IoC/Container.php:153 (makeInstanceFromClassName) /src/Core/Foundation/IoC/Container.php:166 (doMake) /src/Adapter/ServiceLocator.php:70 (make) /classes/module/Module.php:1258 (get) /tools/profiling/Module.php:35 (coreLoadModule) /classes/module/Module.php:1237 (coreLoadModule) /classes/Hook.php:966 (getInstanceByName) /classes/controller/FrontController.php:1004 (exec) /tools/profiling/Controller.php:48 (setMedia) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
130	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` = 312) AND (b.`id_shop` = 1) LIMIT 1	7.169 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)
164	SELECT SQL_NO_CACHE data FROM psx1_layered_filter_block WHERE hash="f8bc936ddbb6623f4ff61f4a85dd9cb0" LIMIT 1	6.854 ms	1			/modules/ps_facetedsearch/src/Filters/Block.php:186 /modules/ps_facetedsearch/src/Product/SearchProvider.php:210 (getFromCache) /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 (169, 165, 104, 3) 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:40:28' >= sp.from) AND (sp.to = '0000-00-00 00:00:00' OR '2025-05-01 15:40:28' <= sp.to) ) WHERE ((sp.reduction>0))	4.851 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)
182	REPLACE INTO psx1_layered_filter_block (hash, data) VALUES ("f8bc936ddbb6623f4ff61f4a85dd9cb0", "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:24;}i:0;a:2:{s:4:\"name\";s:13:\"No disponible\";s:3:\"nbr\";i:18;}}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:2;}s:3:\"new\";a:2:{s:4:\"name\";s:14:\"Nuevo producto\";s:3:\"nbr\";i:40;}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:71159;s:3:\"min\";d:44;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:42;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:3:{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:\"40\";}i:83;a:2:{s:4:\"name\";s:29:\"Cables para Control de Acceso\";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: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;}i:5;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:13:\"Intel Core i5\";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:69;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:5:\"RWRWW\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:65;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:5:\"WFH2R\";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:2:{s:4:\"name\";s:2:\"HP\";s:3:\"nbr\";s:1:\"3\";}i:2;a:2:{s:4:\"name\";s:5:\"Dahua\";s:3:\"nbr\";s:1:\"5\";}i:3;a:3:{s:4:\"name\";s:4:\"DELL\";s:3:\"nbr\";s:1:\"2\";s:7:\"checked\";b:1;}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:3:{s:4:\"name\";s:8:\"CONDUMEX\";s:3:\"nbr\";s:1:\"1\";s:7:\"checked\";b: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:3:{s:4:\"name\";s:4:\"CAME\";s:3:\"nbr\";s:2:\"39\";s:7:\"checked\";b:1;}i:170;a:2:{s:4:\"name\";s:9:\"DORMAKABA\";s:3:\"nbr\";s:1:\"5\";}i:171;a:2:{s:4:\"name\";s:10:\"ASSA ABLOY\";s:3:\"nbr\";s:2:\"23\";}i:172;a:2:{s:4:\"name\";s:15:\"RCI - DORMAKABA\";s:3:\"nbr\";s:2:\"15\";}i:173;a:2:{s:4:\"name\";s:6:\"VIAKON\";s:3:\"nbr\";s:1:\"9\";}i:174;a:2:{s:4:\"name\";s:6:\"ZKTECO\";s:3:\"nbr\";s:2:\"35\";}i:175;a:2:{s:4:\"name\";s:7:\"Century\";s:3:\"nbr\";s:2:\"29\";}i:176;a:2:{s:4:\"name\";s:3:\"HID\";s:3:\"nbr\";s:2:\"38\";}i:177;a:2:{s:4:\"name\";s:20:\"AccessPRO Industrial\";s:3:\"nbr\";s:1:\"3\";}i:178;a:2:{s:4:\"name\";s:3:\"STI\";s:3:\"nbr\";s:1:\"6\";}i:179;a:2:{s:4:\"name\";s:3:\"IDP\";s:3:\"nbr\";s:1:\"8\";}i:180;a:2:{s:4:\"name\";s:7:\"SUPREMA\";s:3:\"nbr\";s:2:\"17\";}i:181;a:2:{s:4:\"name\";s:3:\"BEA\";s:3:\"nbr\";s:1:\"7\";}i:182;a:2:{s:4:\"name\";s:5:\"NEDAP\";s:3:\"nbr\";s:1:\"2\";}i:183;a:2:{s:4:\"name\";s:25:\"ALARM CONTROLS-ASSA ABLOY\";s:3:\"nbr\";s:1:\"6\";}i:184;a:2:{s:4:\"name\";s:11:\"POWER SONIC\";s:3:\"nbr\";s:2:\"24\";}i:185;a:2:{s:4:\"name\";s:4:\"FAAC\";s:3:\"nbr\";s:3:\"114\";}i:186;a:2:{s:4:\"name\";s:12:\"M2M SERVICES\";s:3:\"nbr\";s:1:\"2\";}i:187;a:2:{s:4:\"name\";s:9:\"COMUNELLO\";s:3:\"nbr\";s:2:\"34\";}i:188;a:2:{s:4:\"name\";s:12:\"DKS DOORKING\";s:3:\"nbr\";s:2:\"13\";}i:189;a:2:{s:4:\"name\";s:7:\"GENESIS\";s:3:\"nbr\";s:1:\"2\";}i:190;a: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:2:{s:4:\"name\";s:8:\"HIKMICRO\";s:3:\"nbr\";s:1:\"2\";}i:243;a:2:{s:4:\"name\";s:4:\"MUST\";s:3:\"nbr\";s:1:\"1\";}i:244;a:2:{s:4:\"name\";s:18:\"HUAWEI FUSIONSOLAR\";s:3:\"nbr\";s:1:\"1\";}}s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";s:1:\"0\";}i: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:\"42\";}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:130.229999999999989768184605054557323455810546875;s:3:\"min\";d:0.01000000000000000020816681711721685132943093776702880859375;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:42;}}}")	4.519 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)
120	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` = 173) AND (b.`id_shop` = 1) LIMIT 1	4.475 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)
118	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` = 162) AND (b.`id_shop` = 1) LIMIT 1	4.155 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)
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 (169, 165, 104, 3) 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)))	4.121 ms	1849			/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)
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 (169, 165, 104, 3) 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	3.943 ms	1849	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)
158	SELECT SQL_NO_CACHE ag.id_attribute_group, agl.public_name as attribute_group_name, is_color_group, IF(liaglv.`url_name` IS NULL OR liaglv.`url_name` = "", NULL, liaglv.`url_name`) AS url_name, IF(liaglv.`meta_title` IS NULL OR liaglv.`meta_title` = "", NULL, liaglv.`meta_title`) AS meta_title, IFNULL(liag.indexable, TRUE) AS indexable FROM `psx1_attribute_group` ag INNER JOIN psx1_attribute_group_shop attribute_group_shop ON (attribute_group_shop.id_attribute_group = ag.id_attribute_group AND attribute_group_shop.id_shop = 1) LEFT JOIN `psx1_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 2) LEFT JOIN `psx1_layered_indexable_attribute_group` liag ON (ag.`id_attribute_group` = liag.`id_attribute_group`) LEFT JOIN `psx1_layered_indexable_attribute_group_lang_value` AS liaglv ON (ag.`id_attribute_group` = liaglv.`id_attribute_group` AND agl.`id_lang` = 2) GROUP BY ag.id_attribute_group ORDER BY ag.`position` ASC	3.933 ms	1	Yes	Yes	/modules/ps_facetedsearch/src/Filters/DataAccessor.php:137 /modules/ps_facetedsearch/src/Filters/Converter.php:413 (getAttributesGroups) /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)
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 (169, 165, 104, 3) 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))	3.720 ms	1849			/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)
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 (169, 165, 104, 3) AND c.nleft>=2 AND c.nright<=4175	3.709 ms	43			/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)
138	SELECT SQL_NO_CACHE `id_hook`, `name` FROM `psx1_hook`	3.647 ms	966			/classes/Hook.php:1326 /classes/Hook.php:225 (getAllHookIds) /classes/Hook.php:851 (getIdByName) /classes/controller/FrontController.php:1004 (exec) /tools/profiling/Controller.php:48 (setMedia) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
57	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` = 71) AND (b.`id_shop` = 1) LIMIT 1	3.566 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)
442	SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by FROM `psx1_product_attribute` pa INNER JOIN psx1_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) JOIN `psx1_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`) JOIN `psx1_attribute` a ON (a.`id_attribute` = pac.`id_attribute`) JOIN `psx1_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 2) JOIN `psx1_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`) WHERE pa.`id_product` IN (1600) AND ag.`is_color_group` = 1 GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` ORDER BY a.`position` ASC;	3.391 ms	1	Yes	Yes	/classes/Product.php:4524 /src/Adapter/Product/ProductColorsRetriever.php:43 (getAttributesColorList) /src/Adapter/Presenter/Product/ProductLazyArray.php:528 (getColoredVariants) /src/Adapter/Presenter/AbstractLazyArray.php:269 (getMainVariants) /var/cache/prod/smarty/compile/Bigsoholayouts_layout_left_column_tpl/b7/60/d6/b760d61643013890f27534a87485deeb983095f1_2.file.product-listgrid.tpl.php:311 (offsetGet) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/Bigsoholayouts_layout_left_column_tpl/b7/60/d6/b760d61643013890f27534a87485deeb983095f1_2.file.product-listgrid.tpl.php:28 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_681286da0919f6_35852316) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:384 (render) /var/cache/prod/smarty/compile/Bigsoholayouts_layout_left_column_tpl/d1/51/c3/d151c36008a590748b937b933a7be28c121a8d98_2.file.products.tpl.php:76 (_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/d1/51/c3/d151c36008a590748b937b933a7be28c121a8d98_2.file.products.tpl.php:39 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_681286da06fbc0_50943359) /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/54/05/5a/54055a4729da76c67808f06a50262121f66a0539_2.file.product-list.tpl.php:121 (_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/54/05/5a/54055a4729da76c67808f06a50262121f66a0539_2.file.product-list.tpl.php:208 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:186 (process) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/Bigsoholayouts_layout_left_column_tpl/b6/08/0e/b6080e4e76a0eedaeefd3938168fd139cbd9e0d8_2.file.layout-left-column.tpl.php:84 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:186 (process) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/Bigsoholayouts_layout_left_column_tpl/79/53/21/7953218a69a5faaa48c4e3b281b371e70f946b1d_2.file.layout-both-columns.tpl.php:96 (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)
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 (169, 165, 104, 3) 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))	3.367 ms	1849			/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)
82	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` = 97) AND (b.`id_shop` = 1) LIMIT 1	2.941 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)
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 (169, 165, 104, 3) 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.933 ms	1849	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)
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	2.824 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)
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.770 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)
100	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` = 122) AND (b.`id_shop` = 1) LIMIT 1	2.552 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)
14	SELECT SQL_NO_CACHE h.`name` as hook, m.`id_module`, h.`id_hook`, m.`name` as module FROM `psx1_module` m INNER JOIN psx1_module_shop module_shop ON (module_shop.id_module = m.id_module AND module_shop.id_shop = 1 AND module_shop.enable_device & 1) INNER JOIN `psx1_hook_module` `hm` ON hm.`id_module` = m.`id_module` INNER JOIN `psx1_hook` `h` ON hm.`id_hook` = h.`id_hook` LEFT JOIN `psx1_module_group` `mg` ON mg.`id_module` = m.`id_module` WHERE (h.`name` != "paymentOptions") AND (hm.`id_shop` = 1) AND (mg.id_shop = 1 AND mg.`id_group` IN (1)) GROUP BY hm.id_hook, hm.id_module ORDER BY hm.`position`	2.423 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 (169, 165, 104, 3) AND c.nleft>=2 AND c.nright<=4175 GROUP BY p.id_product) p GROUP BY p.condition	2.314 ms	1849	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)
42	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` = 196) AND (b.`id_shop` = 1) LIMIT 1	2.163 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)
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.147 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)
159	SELECT SQL_NO_CACHE DISTINCT f.id_feature, f., fl., IF(liflv.`url_name` IS NULL OR liflv.`url_name` = "", NULL, liflv.`url_name`) AS url_name, IF(liflv.`meta_title` IS NULL OR liflv.`meta_title` = "", NULL, liflv.`meta_title`) AS meta_title, lif.indexable FROM `psx1_feature` f INNER JOIN psx1_feature_shop feature_shop ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1) LEFT JOIN `psx1_feature_lang` fl ON (f.`id_feature` = fl.`id_feature` AND fl.`id_lang` = 2) LEFT JOIN `psx1_layered_indexable_feature` lif ON (f.`id_feature` = lif.`id_feature`) LEFT JOIN `psx1_layered_indexable_feature_lang_value` liflv ON (f.`id_feature` = liflv.`id_feature` AND liflv.`id_lang` = 2) ORDER BY f.`position` ASC	1.930 ms	196	Yes		/modules/ps_facetedsearch/src/Filters/DataAccessor.php:171 /modules/ps_facetedsearch/src/Filters/Converter.php:388 (getFeatures) /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)
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 (169, 165, 104, 3) 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.897 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)

#	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