Inicio

Subcategorías

Grid
List

Hay 9 productos.

Ordenar por:

Mostrando 1-9 de 9 artículo(s)

- Nuevo
Agregar a lista de deseos

Vista rápida

Agregar a comparación
Botón Multipropósito Color Azul De Superficie Con Tapa De Policarbonato Con...

$2,470

Botón Multipropósito, Color Azul, De Superficie, Con Tapa De Policarbonato, Con Bocina, Para Interior, Llave Para Restablecer, Texto De Emergencia, Español
- Nuevo
Agregar a lista de deseos

Vista rápida

Agregar a comparación
Tag para cristal Gen 2 UHF formato en 26 bits

$117

Tag para cristal, Gen 2 UHF formato en 26 bits
- Nuevo
Agregar a lista de deseos

Vista rápida

Agregar a comparación
Tag para cristal Gen 2 UHF Windshield Tag Tamperproof W 26

$133

Tag para cristal Gen 2 UHF Windshield Tag Tamperproof W 26
- Nuevo
Agregar a lista de deseos

Vista rápida

Agregar a comparación
Interruptor IR NoTouch de Acero Inoxidable Salida Doble ABIERTO

$1,419

Interruptor IR NoTouch de Acero Inoxidable, Salida Doble, ABIERTO
- Nuevo
Agregar a lista de deseos

Vista rápida

Agregar a comparación
Botón de Emergencia Texto en Español Color Rojo Acción Mantenida Girar para...

$1,432

Botón de Emergencia, Texto en Español, Color Rojo, Acción Mantenida, Girar para Restablecer y LED Multicolor
- Nuevo
Agregar a lista de deseos

Vista rápida

Agregar a comparación
Botón de Emergencia en Español Color Amarillo Acción Mantenida Girar para...

$1,366

Botón de Emergencia en Español, Color Amarillo, Acción Mantenida, Girar para Restablecer y LED Multicolor
- Nuevo
Agregar a lista de deseos

Vista rápida

Agregar a comparación
Gabinete para Control Seguro de Llaves Solución Inteligente para la...

$45,489

Gabinete para Control Seguro de Llaves: Solución Inteligente para la Organización y Protección de Accesos
Agotado
- Nuevo
- Agotado
Agregar a lista de deseos

Vista rápida

Agregar a comparación
Botón de Salida de Emergencia Texto en Español Acción Mantenida Girar para...

$1,591

Botón de Salida de Emergencia , Texto en Español, Acción Mantenida, Girar para Restablecer, LED de iluminación
Agotado
- Nuevo
- Agotado
Agregar a lista de deseos

Vista rápida

Agregar a comparación
Botón de Salida con Múltiples Mensajes en Ingles

$1,566

Botón de Salida con Múltiples Mensajes en Ingles

Load Time	1339 ms
Querying Time	563 ms
Queries	431
Memory Peak Usage	26.4 Mb
Included Files	777 files - 10.00 Mb
PrestaShop Cache	- Mb
Global vars	0.22 Mb
- global $context	180k
- global $_MODULES	13k
- global $_MODULE	12k
- global $_SERVER	6k
- global $config	5k
- global $smarty	4k
- global $exportPhpConfigFile	4k
- 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.007 ms	0.007 ms	3.18 Mb	9.1 Mb
__construct	26.743 ms	26.750 ms	0.08 Mb	9.1 Mb
init	242.520 ms	269.270 ms	2.89 Mb	9.1 Mb
checkAccess	0.002 ms	269.272 ms	- Mb	9.1 Mb
setMedia	55.325 ms	324.597 ms	0.47 Mb	9.1 Mb
postProcess	0.001 ms	324.598 ms	- Mb	9.1 Mb
initHeader	0.001 ms	324.599 ms	- Mb	9.1 Mb
initContent	752.369 ms	1077 ms	6.44 Mb	13.2 Mb
initFooter	0.003 ms	1077 ms	- Mb	13.2 Mb
display	261.679 ms	1339 ms	10.82 Mb	26.4 Mb

Hook	Time	Memory Usage
displayLeftColumn	97.880 ms	5.71 Mb
=> ps_categorytree (widget)	95.392 ms	5.61 Mb
=> cz_leftbanner (widget)	1.321 ms	0.04 Mb
=> cz_newproducts (widget)	1.167 ms	0.06 Mb
DisplayProductPriceBlock	17.353 ms	1.62 Mb
=> psproductcountdown	0.000 ms	- Mb
=> psproductcountdown	0.002 ms	- Mb
=> psproductcountdown	0.001 ms	- Mb
=> psproductcountdown	2.446 ms	0.22 Mb
=> psproductcountdown	0.001 ms	- Mb
=> psproductcountdown	0.001 ms	- Mb
=> psproductcountdown	0.001 ms	- Mb
=> psproductcountdown	1.823 ms	0.16 Mb
=> psproductcountdown	0.001 ms	- Mb
=> psproductcountdown	0.001 ms	- Mb
=> psproductcountdown	0.001 ms	- Mb
=> psproductcountdown	2.151 ms	0.17 Mb
=> psproductcountdown	0.001 ms	- Mb
=> psproductcountdown	0.001 ms	- Mb
=> psproductcountdown	0.001 ms	- Mb
=> psproductcountdown	1.776 ms	0.18 Mb
=> psproductcountdown	0.001 ms	- Mb
=> psproductcountdown	0.001 ms	- Mb
=> psproductcountdown	0.001 ms	- Mb
=> psproductcountdown	1.852 ms	0.18 Mb
=> psproductcountdown	0.000 ms	- Mb
=> psproductcountdown	0.001 ms	- Mb
=> psproductcountdown	0.001 ms	- Mb
=> psproductcountdown	1.926 ms	0.18 Mb
=> psproductcountdown	0.001 ms	- Mb
=> psproductcountdown	0.001 ms	- Mb
=> psproductcountdown	0.001 ms	- Mb
=> psproductcountdown	1.672 ms	0.19 Mb
=> psproductcountdown	0.001 ms	- Mb
=> psproductcountdown	0.001 ms	- Mb
=> psproductcountdown	0.001 ms	- Mb
=> psproductcountdown	1.849 ms	0.18 Mb
=> psproductcountdown	0.001 ms	- Mb
=> psproductcountdown	0.001 ms	- Mb
=> psproductcountdown	0.000 ms	- Mb
=> psproductcountdown	1.833 ms	0.17 Mb
DisplayCzHoverImage	13.124 ms	0.40 Mb
=> cz_imagehover	7.927 ms	0.05 Mb
=> cz_imagehover	0.635 ms	0.04 Mb
=> cz_imagehover	0.674 ms	0.04 Mb
=> cz_imagehover	0.719 ms	0.04 Mb
=> cz_imagehover	0.538 ms	0.04 Mb
=> cz_imagehover	0.662 ms	0.04 Mb
=> cz_imagehover	0.730 ms	0.04 Mb
=> cz_imagehover	0.629 ms	0.04 Mb
=> cz_imagehover	0.610 ms	0.04 Mb
DisplayBeforeBodyClosingTag	11.801 ms	0.20 Mb
=> statsdata	11.801 ms	0.20 Mb
displayTop	11.195 ms	0.22 Mb
=> ps_shoppingcart (widget)	7.099 ms	0.07 Mb
=> ps_customersignin (widget)	2.696 ms	0.10 Mb
=> ps_searchbar (widget)	1.400 ms	0.04 Mb
displayFooter	8.243 ms	0.45 Mb
=> ps_contactinfo (widget)	2.262 ms	0.07 Mb
=> ps_socialfollow (widget)	1.109 ms	0.05 Mb
=> ps_linklist (widget)	1.213 ms	0.06 Mb
=> ps_customeraccountlinks (widget)	0.756 ms	0.07 Mb
=> ps_emailsubscription (widget)	0.981 ms	0.05 Mb
=> cz_themeimages (widget)	1.117 ms	0.06 Mb
=> cz_themeoptions (widget)	0.805 ms	0.10 Mb
ProductSearchProvider	5.194 ms	0.07 Mb
=> ps_facetedsearch	5.194 ms	0.07 Mb
displayNavFullWidth	4.943 ms	0.24 Mb
=> cz_verticalmenu (widget)	2.693 ms	0.12 Mb
=> ps_mainmenu (widget)	2.250 ms	0.12 Mb
ActionFrontControllerSetMedia	3.324 ms	0.07 Mb
=> blockreassurance	2.951 ms	0.07 Mb
=> ps_emailsubscription	0.241 ms	- Mb
=> ps_socialfollow	0.063 ms	- Mb
=> ps_emailalerts	0.069 ms	- Mb
Header	3.228 ms	0.04 Mb
=> stripe_official	0.024 ms	- Mb
=> customhtml	1.425 ms	0.01 Mb
=> cz_themeoptions	0.526 ms	0.01 Mb
=> psproductcountdown	1.253 ms	0.02 Mb
displayNav1	3.151 ms	0.14 Mb
=> cz_navcmsblock (widget)	3.151 ms	0.14 Mb
DisplayFooter	2.413 ms	0.19 Mb
=> czuecookie	2.413 ms	0.19 Mb
DisplayStWishlistButton	2.383 ms	0.01 Mb
=> stfeature	0.647 ms	0.01 Mb
=> stfeature	0.252 ms	- Mb
=> stfeature	0.169 ms	- Mb
=> stfeature	0.215 ms	- Mb
=> stfeature	0.174 ms	- Mb
=> stfeature	0.233 ms	- Mb
=> stfeature	0.249 ms	- Mb
=> stfeature	0.238 ms	- Mb
=> stfeature	0.205 ms	- Mb
DisplayStCompareButton	1.223 ms	0.01 Mb
=> stfeature	0.273 ms	0.01 Mb
=> stfeature	0.134 ms	- Mb
=> stfeature	0.127 ms	- Mb
=> stfeature	0.123 ms	- Mb
=> stfeature	0.089 ms	- Mb
=> stfeature	0.100 ms	- Mb
=> stfeature	0.100 ms	- Mb
=> stfeature	0.159 ms	- Mb
=> stfeature	0.118 ms	- Mb
displayFooterAfter	1.182 ms	- Mb
=> cz_blocklink (widget)	1.182 ms	- Mb
DisplayHeader	1.136 ms	0.02 Mb
=> ps_shoppingcart	0.060 ms	- Mb
=> ps_searchbar	0.319 ms	- Mb
=> cz_verticalmenu	0.054 ms	- Mb
=> cz_imageslider	0.079 ms	- Mb
=> cz_instagramfeeds	0.059 ms	- Mb
=> myprestacomments	0.225 ms	- Mb
=> stfeature	0.340 ms	0.01 Mb
DisplayStWishlistTopLink	0.957 ms	0.04 Mb
=> stfeature	0.957 ms	0.04 Mb
Footer	0.841 ms	0.01 Mb
=> customhtml	0.841 ms	0.01 Mb
DisplayLeftColumn	0.556 ms	0.11 Mb
=> ps_facetedsearch	0.556 ms	0.11 Mb
DisplayStCompareTopLink	0.339 ms	0.01 Mb
=> stfeature	0.339 ms	0.01 Mb
DisplayProductListReviews	0.024 ms	- Mb
=> psproductcountdown	0.004 ms	- Mb
=> psproductcountdown	0.002 ms	- Mb
=> psproductcountdown	0.003 ms	- Mb
=> psproductcountdown	0.003 ms	- Mb
=> psproductcountdown	0.002 ms	- Mb
=> psproductcountdown	0.003 ms	- Mb
=> psproductcountdown	0.003 ms	- Mb
=> psproductcountdown	0.002 ms	- Mb
=> psproductcountdown	0.002 ms	- Mb
DisplayFooterAfter	0.007 ms	- Mb
=> cz_themeoptions	0.007 ms	- Mb
22 hook(s)	190.497 ms	9.54 Mb

Module	Time	Memory Usage
blockreassurance	6.148 ms	0.18 Mb
__construct	3.192 ms	0.11 Mb
hookActionFrontControllerSetMedia	2.956 ms	0.07 Mb
ps_emailsubscription	19.244 ms	0.08 Mb
__construct	18.016 ms	0.03 Mb
hookActionFrontControllerSetMedia	0.244 ms	- Mb
displayFooter	0.984 ms	0.05 Mb
ps_socialfollow	2.595 ms	0.09 Mb
__construct	1.417 ms	0.04 Mb
hookActionFrontControllerSetMedia	0.066 ms	- Mb
displayFooter	1.112 ms	0.05 Mb
ps_emailalerts	16.845 ms	0.06 Mb
__construct	16.773 ms	0.06 Mb
hookActionFrontControllerSetMedia	0.072 ms	- Mb
ps_shoppingcart	8.031 ms	0.09 Mb
__construct	0.864 ms	0.02 Mb
hookDisplayHeader	0.062 ms	- Mb
displayTop	7.105 ms	0.07 Mb
ps_searchbar	2.081 ms	0.06 Mb
__construct	0.355 ms	0.02 Mb
hookDisplayHeader	0.321 ms	- Mb
displayTop	1.405 ms	0.04 Mb
cz_verticalmenu	19.704 ms	0.16 Mb
__construct	16.948 ms	0.03 Mb
hookDisplayHeader	0.057 ms	- Mb
displayNavFullWidth	2.699 ms	0.12 Mb
cz_imageslider	14.970 ms	0.10 Mb
__construct	14.888 ms	0.10 Mb
hookDisplayHeader	0.082 ms	- Mb
cz_instagramfeeds	1.483 ms	0.02 Mb
__construct	1.422 ms	0.02 Mb
hookDisplayHeader	0.061 ms	- Mb
myprestacomments	17.768 ms	0.16 Mb
__construct	17.540 ms	0.15 Mb
hookDisplayHeader	0.228 ms	0.01 Mb
stfeature	10.311 ms	0.16 Mb
__construct	5.019 ms	0.06 Mb
hookDisplayHeader	0.344 ms	0.01 Mb
hookDisplayStWishlistTopLink	0.961 ms	0.04 Mb
hookDisplayStCompareTopLink	0.341 ms	0.01 Mb
hookDisplayStWishlistButton	0.651 ms	0.01 Mb
hookDisplayStCompareButton	0.275 ms	0.01 Mb
hookDisplayStWishlistButton	0.255 ms	- Mb
hookDisplayStCompareButton	0.136 ms	- Mb
hookDisplayStWishlistButton	0.171 ms	- Mb
hookDisplayStCompareButton	0.129 ms	- Mb
hookDisplayStWishlistButton	0.218 ms	- Mb
hookDisplayStCompareButton	0.125 ms	- Mb
hookDisplayStWishlistButton	0.175 ms	- Mb
hookDisplayStCompareButton	0.090 ms	- Mb
hookDisplayStWishlistButton	0.235 ms	- Mb
hookDisplayStCompareButton	0.102 ms	- Mb
hookDisplayStWishlistButton	0.251 ms	- Mb
hookDisplayStCompareButton	0.102 ms	- Mb
hookDisplayStWishlistButton	0.241 ms	- Mb
hookDisplayStCompareButton	0.162 ms	- Mb
hookDisplayStWishlistButton	0.208 ms	- Mb
hookDisplayStCompareButton	0.120 ms	- Mb
stripe_official	23.546 ms	0.23 Mb
__construct	23.519 ms	0.23 Mb
hookHeader	0.027 ms	- Mb
customhtml	13.880 ms	0.04 Mb
__construct	11.606 ms	0.02 Mb
hookHeader	1.429 ms	0.01 Mb
hookFooter	0.845 ms	0.01 Mb
cz_themeoptions	48.477 ms	0.31 Mb
__construct	47.131 ms	0.20 Mb
hookHeader	0.530 ms	0.01 Mb
displayFooter	0.807 ms	0.10 Mb
hookDisplayFooterAfter	0.009 ms	- Mb
psproductcountdown	34.533 ms	1.77 Mb
__construct	15.823 ms	0.11 Mb
hookHeader	1.257 ms	0.02 Mb
hookDisplayProductListReviews	0.005 ms	- Mb
hookDisplayProductPriceBlock	0.001 ms	- Mb
hookDisplayProductPriceBlock	0.004 ms	- Mb
hookDisplayProductPriceBlock	0.002 ms	- Mb
hookDisplayProductPriceBlock	2.450 ms	0.22 Mb
hookDisplayProductListReviews	0.003 ms	- Mb
hookDisplayProductPriceBlock	0.002 ms	- Mb
hookDisplayProductPriceBlock	0.002 ms	- Mb
hookDisplayProductPriceBlock	0.002 ms	- Mb
hookDisplayProductPriceBlock	1.828 ms	0.16 Mb
hookDisplayProductListReviews	0.005 ms	- Mb
hookDisplayProductPriceBlock	0.003 ms	- Mb
hookDisplayProductPriceBlock	0.002 ms	- Mb
hookDisplayProductPriceBlock	0.002 ms	- Mb
hookDisplayProductPriceBlock	2.156 ms	0.17 Mb
hookDisplayProductListReviews	0.004 ms	- Mb
hookDisplayProductPriceBlock	0.002 ms	- Mb
hookDisplayProductPriceBlock	0.002 ms	- Mb
hookDisplayProductPriceBlock	0.002 ms	- Mb
hookDisplayProductPriceBlock	1.779 ms	0.18 Mb
hookDisplayProductListReviews	0.003 ms	- Mb
hookDisplayProductPriceBlock	0.002 ms	- Mb
hookDisplayProductPriceBlock	0.001 ms	- Mb
hookDisplayProductPriceBlock	0.001 ms	- Mb
hookDisplayProductPriceBlock	1.856 ms	0.18 Mb
hookDisplayProductListReviews	0.004 ms	- Mb
hookDisplayProductPriceBlock	0.001 ms	- Mb
hookDisplayProductPriceBlock	0.002 ms	- Mb
hookDisplayProductPriceBlock	0.002 ms	- Mb
hookDisplayProductPriceBlock	1.930 ms	0.18 Mb
hookDisplayProductListReviews	0.004 ms	- Mb
hookDisplayProductPriceBlock	0.002 ms	- Mb
hookDisplayProductPriceBlock	0.002 ms	- Mb
hookDisplayProductPriceBlock	0.002 ms	- Mb
hookDisplayProductPriceBlock	1.675 ms	0.19 Mb
hookDisplayProductListReviews	0.004 ms	- Mb
hookDisplayProductPriceBlock	0.003 ms	- Mb
hookDisplayProductPriceBlock	0.002 ms	- Mb
hookDisplayProductPriceBlock	0.002 ms	- Mb
hookDisplayProductPriceBlock	1.853 ms	0.18 Mb
hookDisplayProductListReviews	0.003 ms	- Mb
hookDisplayProductPriceBlock	0.003 ms	- Mb
hookDisplayProductPriceBlock	0.002 ms	- Mb
hookDisplayProductPriceBlock	0.001 ms	- Mb
hookDisplayProductPriceBlock	1.837 ms	0.17 Mb
ps_facetedsearch	27.494 ms	0.29 Mb
__construct	21.732 ms	0.11 Mb
hookProductSearchProvider	5.203 ms	0.07 Mb
hookDisplayLeftColumn	0.559 ms	0.12 Mb
cz_navcmsblock	4.598 ms	0.17 Mb
__construct	1.443 ms	0.02 Mb
displayNav1	3.155 ms	0.14 Mb
ps_customersignin	3.274 ms	0.12 Mb
__construct	0.575 ms	0.02 Mb
displayTop	2.699 ms	0.10 Mb
ps_mainmenu	9.431 ms	0.21 Mb
__construct	7.176 ms	0.09 Mb
displayNavFullWidth	2.255 ms	0.12 Mb
ps_categorytree	96.700 ms	5.63 Mb
__construct	1.300 ms	0.02 Mb
displayLeftColumn	95.400 ms	5.61 Mb
cz_leftbanner	5.152 ms	0.08 Mb
__construct	3.827 ms	0.03 Mb
displayLeftColumn	1.325 ms	0.04 Mb
cz_newproducts	2.513 ms	0.07 Mb
__construct	1.343 ms	0.02 Mb
displayLeftColumn	1.170 ms	0.06 Mb
cz_imagehover	13.637 ms	0.42 Mb
__construct	0.474 ms	0.02 Mb
hookDisplayCzHoverImage	7.938 ms	0.05 Mb
hookDisplayCzHoverImage	0.639 ms	0.05 Mb
hookDisplayCzHoverImage	0.677 ms	0.05 Mb
hookDisplayCzHoverImage	0.723 ms	0.05 Mb
hookDisplayCzHoverImage	0.541 ms	0.05 Mb
hookDisplayCzHoverImage	0.666 ms	0.05 Mb
hookDisplayCzHoverImage	0.734 ms	0.05 Mb
hookDisplayCzHoverImage	0.632 ms	0.05 Mb
hookDisplayCzHoverImage	0.613 ms	0.05 Mb
ps_contactinfo	2.978 ms	0.09 Mb
__construct	0.711 ms	0.02 Mb
displayFooter	2.267 ms	0.07 Mb
ps_linklist	15.353 ms	0.15 Mb
__construct	14.135 ms	0.09 Mb
displayFooter	1.218 ms	0.06 Mb
ps_customeraccountlinks	1.265 ms	0.08 Mb
__construct	0.506 ms	0.02 Mb
displayFooter	0.759 ms	0.07 Mb
cz_themeimages	2.301 ms	0.07 Mb
__construct	1.180 ms	0.02 Mb
displayFooter	1.121 ms	0.06 Mb
czuecookie	3.129 ms	0.21 Mb
__construct	0.712 ms	0.02 Mb
hookDisplayFooter	2.417 ms	0.19 Mb
cz_blocklink	3.499 ms	- Mb
__construct	2.313 ms	0.02 Mb
displayFooterAfter	1.186 ms	- Mb
statsdata	12.735 ms	0.28 Mb
__construct	0.927 ms	0.08 Mb
hookDisplayBeforeBodyClosingTag	11.808 ms	0.20 Mb
30 module(s)	443.676 ms	11.37 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
19 queries	SELECT `id_module` FROM `psxXX_module_shop` WHERE `id_module` = XX AND `id_shop` = XX LIMIT XX
18 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`
10 queries	SELECT XX FROM `psxXX_specific_price` WHERE id_product = XX LIMIT XX
9 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
9 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
9 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
9 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;
9 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
9 queries	SELECT * FROM `psxXX_product_lang` WHERE `id_product` = XX AND `id_shop` = XX
9 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
9 queries	SELECT `reduction` FROM `psxXX_product_group_reduction_cache` WHERE `id_product` = XX AND `id_group` = XX LIMIT XX
9 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
9 queries	SELECT product_type FROM `psxXX_product` WHERE id_product = XX LIMIT XX
9 queries	SELECT `id_product_attribute` FROM `psxXX_product_attribute` WHERE `id_product` = XX
9 queries	SELECT `id_tax_rules_group` FROM `psxXX_product_shop` WHERE `id_product` = XX AND id_shop=XX LIMIT XX
9 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)
9 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
9 queries	SELECT name FROM psxXX_category_lang WHERE id_shop = XX AND id_lang = XX AND id_category = XX LIMIT XX
9 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
9 queries	SELECT COUNT(*) FROM `psxXX_pack` WHERE id_product_pack = XX LIMIT XX
4 queries	SELECT `id_lang` FROM `psxXX_lang` WHERE `locale` = 'es-mx' OR `language_code` = 'es-mx' LIMIT XX
3 queries	SELECT tr.* FROM `psxXX_tax_rule` tr JOIN `psxXX_tax_rules_group` trg ON (tr.`id_tax_rules_group` = trg.`id_tax_rules_group`) WHERE trg.`active` = XX AND tr.`id_country` = XX AND tr.`id_tax_rules_group` = XX AND tr.`id_state` IN (XX, XX) AND ('XX' BETWEEN tr.`zipcode_from` AND tr.`zipcode_to` OR (tr.`zipcode_to` = XX AND tr.`zipcode_from` IN(XX, 'XX'))) ORDER BY tr.`zipcode_from` DESC, tr.`zipcode_to` DESC, tr.`id_state` DESC, tr.`id_country` DESC
3 queries	SELECT `name` FROM `psxXX_manufacturer` WHERE `id_manufacturer` = XX AND `active` = XX LIMIT XX
2 queries	SELECT XX FROM `psxXX_cart_rule` WHERE ((date_to >= "XX-XX-XX XX:XX:XX" AND date_to <= "XX-XX-XX XX:XX:XX") OR (date_from >= "XX-XX-XX XX:XX:XX" AND date_from <= "XX-XX-XX XX:XX:XX") OR (date_from < "XX-XX-XX XX:XX:XX" AND date_to > "XX-XX-XX XX:XX:XX")) AND `id_customer` IN (XX,XX) LIMIT XX
2 queries	SELECT `id_category` FROM `psxXX_category_shop` WHERE `id_category` = XX AND `id_shop` = XX LIMIT XX
2 queries	SELECT `need_identification_number` FROM `psxXX_country` WHERE `id_country` = XX LIMIT XX
2 queries	SELECT fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM psxXX_product p LEFT JOIN psxXX_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN psxXX_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN psxXX_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, XX) = sa.id_product_attribute AND sa.id_shop = XX AND sa.id_shop_group = XX ) LEFT JOIN psxXX_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN psxXX_category_product cp ON (p.id_product = cp.id_product) INNER JOIN psxXX_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = XX AND ps.active = TRUE) INNER JOIN psxXX_category c ON (cp.id_category = c.id_category AND c.active=XX) LEFT JOIN psxXX_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='XX' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='XX' AND p.id_manufacturer IN (XX, XX, XX, XX) AND c.nleft>=XX AND c.nright<=XX GROUP BY p.id_product) p INNER JOIN psxXX_feature_product fp ON (p.id_product = fp.id_product) WHERE ((fp.id_feature=XX)) GROUP BY fp.id_feature_value
2 queries	SELECT * FROM `psxXX_currency` a LEFT JOIN `psxXX_currency_lang` `b` ON a.`id_currency` = b.`id_currency` AND b.`id_lang` = XX LEFT JOIN `psxXX_currency_shop` `c` ON a.`id_currency` = c.`id_currency` AND c.`id_shop` = XX WHERE (a.`id_currency` = XX) LIMIT XX
2 queries	SELECT m.*, ml.`description`, ml.`short_description` FROM `psxXX_manufacturer` m INNER JOIN psxXX_manufacturer_shop manufacturer_shop ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = XX)INNER JOIN `psxXX_manufacturer_lang` ml ON (m.`id_manufacturer` = ml.`id_manufacturer` AND ml.`id_lang` = XX)WHERE XX AND m.`active` = XX ORDER BY m.`name` ASC
2 queries	SELECT cl.`link_rewrite` FROM `psxXX_category_lang` cl WHERE `id_lang` = XX AND cl.id_shop = XX AND cl.`id_category` = XX LIMIT XX

Name	Instances	Source
Category	106	/controllers/front/listing/CategoryController.php:78 (__construct) [id: 2] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 3] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 195] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 196] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 197] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 198] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 199] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 6] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 10] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 11] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 12] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 13] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 14] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 15] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 16] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 54] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 69] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 70] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 71] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 72] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 73] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 74] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 75] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 76] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 77] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 78] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 79] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 80] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 81] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 82] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 83] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 84] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 85] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 86] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 87] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 88] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 89] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 90] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 91] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 92] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 93] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 94] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 95] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 97] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 99] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 101] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 102] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 103] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 104] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 105] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 106] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 107] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 108] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 109] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 110] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 111] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 113] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 114] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 117] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 118] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 121] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 122] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 123] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 124] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 128] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 132] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 133] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 136] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 137] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 139] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 143] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 150] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 151] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 152] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 153] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 154] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 156] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 159] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 160] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 162] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 165] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 173] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 175] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 177] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 178] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 183] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 184] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 194] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 278] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 280] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 310] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 312] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 328] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 335] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 367] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 374] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 407] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 464] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 1646] /classes/Meta.php:380 (__construct) [id: 2] /classes/Link.php:402 (__construct) [id: 2] /classes/Link.php:402 (__construct) [id: 2] /classes/PrestaShopCollection.php:385 (hydrateCollection) [id: ] /modules/ps_facetedsearch/src/Product/Search.php:364 (__construct) [id: 2] /modules/ps_facetedsearch/src/Filters/Block.php:157 (__construct) [id: 2] /modules/ps_categorytree/ps_categorytree.php:364 (getParentsCategories) [id: 2]
Product	45	/classes/Link.php:113 (__construct) [id: 1403] /classes/Link.php:113 (__construct) [id: 1459] /classes/Link.php:113 (__construct) [id: 1460] /classes/Link.php:113 (__construct) [id: 1610] /classes/Link.php:113 (__construct) [id: 1811] /classes/Link.php:113 (__construct) [id: 1821] /classes/Link.php:113 (__construct) [id: 2180] /classes/Link.php:113 (__construct) [id: 2372] /classes/Link.php:113 (__construct) [id: 2474] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 1403] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 1459] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 1460] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 1610] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 1811] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 1821] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 2180] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 2372] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 2474] /classes/Link.php:113 (__construct) [id: 1403] /classes/Link.php:113 (__construct) [id: 1459] /classes/Link.php:113 (__construct) [id: 1460] /classes/Link.php:113 (__construct) [id: 1610] /classes/Link.php:113 (__construct) [id: 1811] /classes/Link.php:113 (__construct) [id: 1821] /classes/Link.php:113 (__construct) [id: 2180] /classes/Link.php:113 (__construct) [id: 2372] /classes/Link.php:113 (__construct) [id: 2474] /modules/cz_imagehover/cz_imagehover.php:73 (__construct) [id: 1403] /modules/psproductcountdown/psproductcountdown.php:1574 (__construct) [id: 1403] /modules/cz_imagehover/cz_imagehover.php:73 (__construct) [id: 1459] /modules/psproductcountdown/psproductcountdown.php:1574 (__construct) [id: 1459] /modules/cz_imagehover/cz_imagehover.php:73 (__construct) [id: 1460] /modules/psproductcountdown/psproductcountdown.php:1574 (__construct) [id: 1460] /modules/cz_imagehover/cz_imagehover.php:73 (__construct) [id: 1610] /modules/psproductcountdown/psproductcountdown.php:1574 (__construct) [id: 1610] /modules/cz_imagehover/cz_imagehover.php:73 (__construct) [id: 1811] /modules/psproductcountdown/psproductcountdown.php:1574 (__construct) [id: 1811] /modules/cz_imagehover/cz_imagehover.php:73 (__construct) [id: 1821] /modules/psproductcountdown/psproductcountdown.php:1574 (__construct) [id: 1821] /modules/cz_imagehover/cz_imagehover.php:73 (__construct) [id: 2180] /modules/psproductcountdown/psproductcountdown.php:1574 (__construct) [id: 2180] /modules/cz_imagehover/cz_imagehover.php:73 (__construct) [id: 2372] /modules/psproductcountdown/psproductcountdown.php:1574 (__construct) [id: 2372] /modules/cz_imagehover/cz_imagehover.php:73 (__construct) [id: 2474] /modules/psproductcountdown/psproductcountdown.php:1574 (__construct) [id: 2474]
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: ]
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]
Language	2	/config/config.inc.php:211 (__construct) [id: 2] /classes/Tools.php:560 (__construct) [id: 2]
Cart	2	/classes/controller/FrontController.php:467 (__construct) [id: ] /classes/controller/FrontController.php:541 (__construct) [id: ]
Tax	2	/classes/tax/TaxRulesTaxManager.php:116 (__construct) [id: 53] /classes/tax/TaxRulesTaxManager.php:116 (__construct) [id: 53]
AddressFormat	2	/classes/controller/FrontController.php:1773 (generateAddress) [id: ] /modules/ps_contactinfo/ps_contactinfo.php:91 (generateAddress) [id: ]
Shop	1	/config/config.inc.php:117 (initialize) [id: 1]
Connection	1	/modules/statsdata/statsdata.php:118 (setPageConnection) [id: ]
Guest	1	/modules/statsdata/statsdata.php:82 (setNewGuest) [id: ]
CMS	1	/modules/czuecookie/czuecookie.php:135 (__construct) [id: 3]
Risk	1	/classes/controller/FrontController.php:1705 (__construct) [id: ]
Gender	1	/classes/controller/FrontController.php:1702 (__construct) [id: 0]
Group	1	/classes/Cart.php:249 (getCurrent) [id: 1]
Customer	1	/config/config.inc.php:264 (__construct) [id: ]
ShopGroup	1	/classes/shop/Shop.php:561 (__construct) [id: 1]
ConnectionsSource	1	/modules/statsdata/statsdata.php:119 (logHttpReferer) [id: ]

#	Query	Time (ms)	Rows	Filesort	Group By	Location
177	SELECT SQL_NO_CACHE p.id_manufacturer, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM psx1_product p LEFT JOIN psx1_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN psx1_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN psx1_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN psx1_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN psx1_category_product cp ON (p.id_product = cp.id_product) INNER JOIN psx1_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN psx1_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN psx1_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=2 AND c.nright<=4175 GROUP BY p.id_product) p GROUP BY p.id_manufacturer	207.824 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)
343	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	46.761 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)
180	REPLACE INTO psx1_layered_filter_block (hash, data) VALUES ("5462515df3aa577228f944823a4b510d", "a:1:{s:7:\"filters\";a:7:{i:0;a:7:{s:9:\"type_lite\";s:12:\"availability\";s:4:\"type\";s:12:\"availability\";s:6:\"id_key\";i:0;s:4:\"name\";s:14:\"Disponibilidad\";s:6:\"values\";a:2:{i:2;a:2:{s:4:\"name\";s:13:\"En existencia\";s:3:\"nbr\";i:7;}i:0;a:2:{s:4:\"name\";s:13:\"No disponible\";s:3:\"nbr\";i:2;}}s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";s:1:\"0\";}i:1;a:7:{s:9:\"type_lite\";s:6:\"extras\";s:4:\"type\";s:6:\"extras\";s:6:\"id_key\";i:0;s:4:\"name\";s:10:\"Selections\";s:6:\"values\";a:3:{s:4:\"sale\";a:2:{s:4:\"name\";s:12:\"¡En oferta!\";s:3:\"nbr\";i:0;}s:3:\"new\";a:2:{s:4:\"name\";s:14:\"Nuevo producto\";s:3:\"nbr\";i:9;}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:39018;s:3:\"min\";d:108;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:9;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:4:{i:54;a:2:{s:4:\"name\";s:17:\"Control de acceso\";s:3:\"nbr\";s:1:\"9\";}i:75;a:2:{s:4:\"name\";s:19:\"Lectoras y Tarjetas\";s:3:\"nbr\";s:1:\"2\";}i:82;a:2:{s:4:\"name\";s:17:\"Botones de Salida\";s:3:\"nbr\";s:1:\"6\";}i:118;a:2:{s:4:\"name\";s:19:\"Mobiliario de Apoyo\";s:3:\"nbr\";s:1:\"1\";}}s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";s:1:\"0\";}i:4;a:7:{s:9:\"type_lite\";s:12:\"manufacturer\";s:4:\"type\";s:12:\"manufacturer\";s:6:\"id_key\";i:0;s:4:\"name\";s:5:\"Marca\";s:6:\"values\";a:137:{i:1;a:2:{s:4:\"name\";s:2:\"HP\";s:3:\"nbr\";s:1:\"3\";}i:2;a:2:{s:4:\"name\";s:5:\"Dahua\";s:3:\"nbr\";s:1:\"5\";}i:3;a:2:{s:4:\"name\";s:4:\"DELL\";s:3:\"nbr\";s:1:\"2\";}i:5;a:2:{s:4:\"name\";s:6:\"Stylos\";s:3:\"nbr\";s:1:\"1\";}i:6;a:2:{s:4:\"name\";s:6:\"Acteck\";s:3:\"nbr\";s:1:\"1\";}i:7;a:2:{s:4:\"name\";s:7:\"SAMSUNG\";s:3:\"nbr\";s:1:\"1\";}i:9;a:2:{s:4:\"name\";s:5:\"DITEK\";s:3:\"nbr\";s:1:\"3\";}i:11;a:2:{s:4:\"name\";s:18:\"LINKEDPRO BY EPCOM\";s:3:\"nbr\";s:3:\"230\";}i:12;a:2:{s:4:\"name\";s:16:\"EPCOM INDUSTRIAL\";s:3:\"nbr\";s:2:\"27\";}i:13;a:2:{s:4:\"name\";s:10:\"POLYPHASER\";s:3:\"nbr\";s:1:\"4\";}i:14;a:2:{s:4:\"name\";s:6:\"FANVIL\";s:3:\"nbr\";s:2:\"33\";}i:15;a:2:{s:4:\"name\";s:6:\"PLANET\";s:3:\"nbr\";s:2:\"49\";}i:17;a:2:{s:4:\"name\";s:16:\"CAMBIUM NETWORKS\";s:3:\"nbr\";s:2:\"19\";}i:19;a:2:{s:4:\"name\";s:9:\"HIKVISION\";s:3:\"nbr\";s:3:\"163\";}i:20;a:2:{s:4:\"name\";s:8:\"MEITRACK\";s:3:\"nbr\";s:1:\"1\";}i:21;a:2:{s:4:\"name\";s:11:\"GRANDSTREAM\";s:3:\"nbr\";s:2:\"59\";}i:22;a:2:{s:4:\"name\";s:18:\"ALTAI TECHNOLOGIES\";s:3:\"nbr\";s:1:\"6\";}i:25;a:2:{s:4:\"name\";s:8:\"MEANWELL\";s:3:\"nbr\";s:2:\"24\";}i:27;a:2:{s:4:\"name\";s:7:\"PANDUIT\";s:3:\"nbr\";s:3:\"158\";}i:28;a:2:{s:4:\"name\";s:6:\"GEWISS\";s:3:\"nbr\";s:1:\"6\";}i:29;a:2:{s:4:\"name\";s:10:\"CYBERPOWER\";s:3:\"nbr\";s:2:\"44\";}i:30;a:2:{s:4:\"name\";s:8:\"MIKROTIK\";s:3:\"nbr\";s:2:\"61\";}i:31;a:2:{s:4:\"name\";s:15:\"MIMOSA NETWORKS\";s:3:\"nbr\";s:1:\"9\";}i:32;a:2:{s:4:\"name\";s:15:\"EPCOM POWERLINE\";s:3:\"nbr\";s:3:\"248\";}i:33;a:2:{s:4:\"name\";s:5:\"EPCOM\";s:3:\"nbr\";s:1:\"8\";}i:36;a:2:{s:4:\"name\";s:14:\"ALLIED TELESIS\";s:3:\"nbr\";s:1:\"9\";}i:37;a:2:{s:4:\"name\";s:11:\"RF ELEMENTS\";s:3:\"nbr\";s:2:\"10\";}i:39;a:2:{s:4:\"name\";s:6:\"CAMESA\";s:3:\"nbr\";s:1:\"5\";}i:40;a:2:{s:4:\"name\";s:9:\"PRECISION\";s:3:\"nbr\";s:3:\"105\";}i:41;a:2:{s:4:\"name\";s:8:\"Mercusys\";s:3:\"nbr\";s:1:\"6\";}i:43;a:2:{s:4:\"name\";s:9:\"FIBERHOME\";s:3:\"nbr\";s:2:\"35\";}i:44;a:2:{s:4:\"name\";s:5:\"JABRA\";s:3:\"nbr\";s:1:\"9\";}i:48;a:2:{s:4:\"name\";s:22:\"LINKEDPRO BY FIBERHOME\";s:3:\"nbr\";s:2:\"16\";}i:50;a:2:{s:4:\"name\";s:14:\"EPCOM TITANIUM\";s:3:\"nbr\";s:1:\"1\";}i:52;a:2:{s:4:\"name\";s:3:\"PLP\";s:3:\"nbr\";s:2:\"14\";}i:54;a:2:{s:4:\"name\";s:5:\"ANCLO\";s:3:\"nbr\";s:2:\"70\";}i:55;a:2:{s:4:\"name\";s:6:\"RUIJIE\";s:3:\"nbr\";s:2:\"90\";}i:56;a:2:{s:4:\"name\";s:20:\"HIKSEMI by HIKVISION\";s:3:\"nbr\";s:2:\"29\";}i:58;a:2:{s:4:\"name\";s:26:\"EPCOM INDUSTRIAL SIGNALING\";s:3:\"nbr\";s:1:\"3\";}i:61;a:2:{s:4:\"name\";s:6:\"HUAWEI\";s:3:\"nbr\";s:2:\"12\";}i:62;a:2:{s:4:\"name\";s:7:\"HOFFMAN\";s:3:\"nbr\";s:1:\"1\";}i:63;a:2:{s:4:\"name\";s:19:\"HiLook by HIKVISION\";s:3:\"nbr\";s:1:\"1\";}i:64;a:2:{s:4:\"name\";s:9:\"LINKEDPRO\";s:3:\"nbr\";s:1:\"3\";}i:67;a:2:{s:4:\"name\";s:6:\"MAKITA\";s:3:\"nbr\";s:2:\"24\";}i:68;a:2:{s:4:\"name\";s:6:\"SIEMON\";s:3:\"nbr\";s:1:\"3\";}i:70;a:2:{s:4:\"name\";s:5:\"DELTA\";s:3:\"nbr\";s:1:\"2\";}i:71;a:2:{s:4:\"name\";s:11:\"BLUEPARROTT\";s:3:\"nbr\";s:1:\"1\";}i:73;a:2:{s:4:\"name\";s:8:\"NetPoint\";s:3:\"nbr\";s:1:\"1\";}i:74;a:2:{s:4:\"name\";s:11:\"KLEIN TOOLS\";s:3:\"nbr\";s:2:\"29\";}i:76;a:2:{s:4:\"name\";s:6:\"ATLONA\";s:3:\"nbr\";s:1:\"3\";}i:158;a:2:{s:4:\"name\";s:22:\"HONEYWELL HOME RESIDEO\";s:3:\"nbr\";s:1:\"1\";}i:159;a:2:{s:4:\"name\";s:8:\"ALTRONIX\";s:3:\"nbr\";s:1:\"6\";}i:160;a:2:{s:4:\"name\";s:26:\"ROSSLARE SECURITY PRODUCTS\";s:3:\"nbr\";s:2:\"33\";}i:161;a:2:{s:4:\"name\";s:12:\"ELK PRODUCTS\";s:3:\"nbr\";s:1:\"2\";}i:162;a:2:{s:4:\"name\";s:18:\"ZKTECO - AccessPRO\";s:3:\"nbr\";s:1:\"9\";}i:163;a:2:{s:4:\"name\";s:5:\"KOCOM\";s:3:\"nbr\";s:2:\"19\";}i:164;a:2:{s:4:\"name\";s:17:\"ENFORCER SECOLARM\";s:3:\"nbr\";s:2:\"14\";}i:165;a:2:{s:4:\"name\";s:8:\"CONDUMEX\";s:3:\"nbr\";s:1:\"1\";}i:166;a:2:{s:4:\"name\";s:19:\"PHILLIPS-ASSA ABLOY\";s:3:\"nbr\";s:2:\"19\";}i:167;a:2:{s:4:\"name\";s:9:\"ACCESSPRO\";s:3:\"nbr\";s:3:\"327\";}i:168;a:2:{s:4:\"name\";s:5:\"SFIRE\";s:3:\"nbr\";s:2:\"26\";}i:169;a:2:{s:4:\"name\";s:4:\"CAME\";s:3:\"nbr\";s:2:\"39\";}i:170;a:2:{s:4:\"name\";s:9:\"DORMAKABA\";s:3:\"nbr\";s:1:\"5\";}i:171;a:2:{s:4:\"name\";s:10:\"ASSA ABLOY\";s:3:\"nbr\";s:2:\"23\";}i:172;a:2:{s:4:\"name\";s:15:\"RCI - DORMAKABA\";s:3:\"nbr\";s:2:\"15\";}i:173;a:2:{s:4:\"name\";s:6:\"VIAKON\";s:3:\"nbr\";s:1:\"9\";}i:174;a:2:{s:4:\"name\";s:6:\"ZKTECO\";s:3:\"nbr\";s:2:\"35\";}i:175;a:2:{s:4:\"name\";s:7:\"Century\";s:3:\"nbr\";s:2:\"29\";}i:176;a:2:{s:4:\"name\";s:3:\"HID\";s:3:\"nbr\";s:2:\"38\";}i:177;a:2:{s:4:\"name\";s:20:\"AccessPRO Industrial\";s:3:\"nbr\";s:1:\"3\";}i:178;a:3:{s:4:\"name\";s:3:\"STI\";s:3:\"nbr\";s:1:\"6\";s:7:\"checked\";b:1;}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:3:{s:4:\"name\";s:5:\"NEDAP\";s:3:\"nbr\";s:1:\"2\";s:7:\"checked\";b:1;}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:3:{s:4:\"name\";s:8:\"LANDWELL\";s:3:\"nbr\";s:1:\"1\";s:7:\"checked\";b: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:5;a:7:{s:9:\"type_lite\";s:9:\"condition\";s:4:\"type\";s:9:\"condition\";s:6:\"id_key\";i:0;s:4:\"name\";s:10:\"Condición\";s:6:\"values\";a:3:{s:3:\"new\";a:2:{s:4:\"name\";s:5:\"Nuevo\";s:3:\"nbr\";s:1:\"9\";}s:4:\"used\";a:2:{s:4:\"name\";s:5:\"Usado\";s:3:\"nbr\";i:0;}s:11:\"refurbished\";a:2:{s:4:\"name\";s:10:\"Restaurado\";s:3:\"nbr\";i:0;}}s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";s:1:\"0\";}i:6;a:12:{s:9:\"type_lite\";s:6:\"weight\";s:4:\"type\";s:6:\"weight\";s:6:\"id_key\";i:0;s:4:\"name\";s:4:\"Peso\";s:3:\"max\";d:17;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:9;}}}")	26.258 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)
84	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` = 101) AND (b.`id_shop` = 1) LIMIT 1	18.846 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)
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 (204, 182, 88, 178) 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	18.697 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)
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	16.824 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)
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 (204, 182, 88, 178) 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	14.033 ms	100	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)
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	11.030 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)
193	SELECT SQL_NO_CACHE tr.* FROM `psx1_tax_rule` tr JOIN `psx1_tax_rules_group` trg ON (tr.`id_tax_rules_group` = trg.`id_tax_rules_group`) WHERE trg.`active` = 1 AND tr.`id_country` = 144 AND tr.`id_tax_rules_group` = 53 AND tr.`id_state` IN (0, 63) AND ('0' BETWEEN tr.`zipcode_from` AND tr.`zipcode_to` OR (tr.`zipcode_to` = 0 AND tr.`zipcode_from` IN(0, '0'))) ORDER BY tr.`zipcode_from` DESC, tr.`zipcode_to` DESC, tr.`id_state` DESC, tr.`id_country` DESC	10.378 ms	1			/classes/tax/TaxRulesTaxManager.php:109 /classes/Product.php:3926 (getTaxCalculator) /classes/Product.php:3717 (priceCalculation) /classes/Product.php:5692 (getPriceStatic) /classes/ProductAssembler.php:209 (getProductProperties) /classes/controller/ProductListingFrontController.php:108 (assembleProducts) /classes/controller/ProductListingFrontController.php:379 (prepareMultipleProductsForTemplate) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
138	SELECT SQL_NO_CACHE `id_hook`, `name` FROM `psx1_hook`	10.082 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)
142	SELECT SQL_NO_CACHE `id_module` FROM `psx1_module` WHERE `name` = "ps_legalcompliance" LIMIT 1	10.036 ms	0			/classes/module/Module.php:2659 /classes/module/Module.php:2131 (getModuleIdByName) /classes/controller/FrontController.php:1669 (isEnabled) /classes/controller/FrontController.php:1813 (getDisplayTaxesLabel) /controllers/front/listing/CategoryController.php:276 (getTemplateVarPage) /classes/controller/FrontController.php:562 (getTemplateVarPage) /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)
221	SELECT SQL_NO_CACHE 1 FROM `psx1_specific_price` WHERE id_product = 1460 LIMIT 1	9.511 ms	1			/classes/SpecificPrice.php:435 /classes/SpecificPrice.php:523 (couldHaveSpecificPrice) /classes/Product.php:3827 (getSpecificPrice) /classes/Product.php:3717 (priceCalculation) /classes/Product.php:5692 (getPriceStatic) /classes/ProductAssembler.php:209 (getProductProperties) /classes/controller/ProductListingFrontController.php:108 (assembleProducts) /classes/controller/ProductListingFrontController.php:379 (prepareMultipleProductsForTemplate) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
293	SELECT SQL_NO_CACHE * FROM `psx1_product` a LEFT JOIN `psx1_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 2 LEFT JOIN `psx1_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1 WHERE (a.`id_product` = 2474) AND (b.`id_shop` = 1) LIMIT 1	4.029 ms	1			/src/Adapter/EntityMapper.php:71 /classes/ObjectModel.php:283 (load) /tools/profiling/ObjectModel.php:32 (__construct) /classes/Product.php:725 (__construct) /classes/Link.php:113 (__construct) /classes/Link.php:189 (getProductObject) /classes/Product.php:5660 (getProductLink) /classes/ProductAssembler.php:209 (getProductProperties) /classes/controller/ProductListingFrontController.php:108 (assembleProducts) /classes/controller/ProductListingFrontController.php:379 (prepareMultipleProductsForTemplate) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
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 (204, 182, 88, 178) 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.819 ms	100	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)
156	SELECT SQL_NO_CACHE `id_category` FROM `psx1_category_shop` WHERE `id_category` = 2 AND `id_shop` = 1 LIMIT 1	3.369 ms	1			/classes/Category.php:2450 /controllers/front/listing/CategoryController.php:133 (existsInShop) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
14	SELECT SQL_NO_CACHE h.`name` as hook, m.`id_module`, h.`id_hook`, m.`name` as module FROM `psx1_module` m INNER JOIN psx1_module_shop module_shop ON (module_shop.id_module = m.id_module AND module_shop.id_shop = 1 AND module_shop.enable_device & 1) INNER JOIN `psx1_hook_module` `hm` ON hm.`id_module` = m.`id_module` INNER JOIN `psx1_hook` `h` ON hm.`id_hook` = h.`id_hook` LEFT JOIN `psx1_module_group` `mg` ON mg.`id_module` = m.`id_module` WHERE (h.`name` != "paymentOptions") AND (hm.`id_shop` = 1) AND (mg.id_shop = 1 AND mg.`id_group` IN (1)) GROUP BY hm.id_hook, hm.id_module ORDER BY hm.`position`	3.104 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)
53	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` = 16) AND (b.`id_shop` = 1) LIMIT 1	2.968 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)
430	INSERT INTO `psx1_connections_source` (`id_connections`, `http_referer`, `request_uri`, `keywords`, `date_add`) VALUES ('2704725', '', 'whatabox.mx/mx/2-inicio?q=Marca-LANDWELL-NEDAP-STI-POLYPHASER', '', '2025-05-01 15:43:49')	2.888 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)
2	SELECT SQL_NO_CACHE c.`name`, cl.`id_lang`, IF(cl.`id_lang` IS NULL, c.`value`, cl.`value`) AS value, c.id_shop_group, c.id_shop FROM `psx1_configuration` c LEFT JOIN `psx1_configuration_lang` cl ON (c.`id_configuration` = cl.`id_configuration`)	2.884 ms	666			/classes/Configuration.php:180 /classes/Configuration.php:229 (loadConfiguration) /classes/Configuration.php:302 (get) /classes/shop/Shop.php:398 (getMultiShopValues) /config/config.inc.php:117 (initialize) /index.php:27 (require)
36	SELECT SQL_NO_CACHE c.*, cl.`id_lang`, cl.`name`, cl.`description`, cl.`additional_description`, cl.`link_rewrite`, cl.`meta_title`, cl.`meta_keywords`, cl.`meta_description` FROM `psx1_category` c INNER JOIN psx1_category_shop category_shop ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1) LEFT JOIN `psx1_category_lang` cl ON (c.`id_category` = cl.`id_category` AND `id_lang` = 2 AND cl.id_shop = 1 ) LEFT JOIN `psx1_category_group` cg ON (cg.`id_category` = c.`id_category`) WHERE `id_parent` = 2 AND `active` = 1 AND cg.`id_group` =1 GROUP BY c.`id_category` ORDER BY `level_depth` ASC, category_shop.`position` ASC	2.308 ms	103	Yes	Yes	/classes/Category.php:924 /controllers/front/listing/CategoryController.php:230 (getSubCategories) /controllers/front/listing/CategoryController.php:118 (getTemplateVarSubCategories) /tools/profiling/Controller.php:41 (init) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
191	SELECT SQL_NO_CACHE `id_hook`, `name` FROM `psx1_hook` UNION SELECT `id_hook`, ha.`alias` as name FROM `psx1_hook_alias` ha INNER JOIN `psx1_hook` h ON ha.name = h.name	2.219 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)
160	SELECT SQL_NO_CACHE m.*, ml.`description`, ml.`short_description` FROM `psx1_manufacturer` m INNER JOIN psx1_manufacturer_shop manufacturer_shop ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 1)INNER JOIN `psx1_manufacturer_lang` ml ON (m.`id_manufacturer` = ml.`id_manufacturer` AND ml.`id_lang` = 2)WHERE 1 AND m.`active` = 1 ORDER BY m.`name` ASC	2.206 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)
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 (204, 182, 88, 178) 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)))	1.914 ms	100			/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)
176	SELECT SQL_NO_CACHE m.*, ml.`description`, ml.`short_description` FROM `psx1_manufacturer` m INNER JOIN psx1_manufacturer_shop manufacturer_shop ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 1)INNER JOIN `psx1_manufacturer_lang` ml ON (m.`id_manufacturer` = ml.`id_manufacturer` AND ml.`id_lang` = 2)WHERE 1 AND m.`active` = 1 ORDER BY m.`name` ASC	1.863 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)
192	SELECT SQL_NO_CACHE h.id_hook, h.name as h_name, title, description, h.position, hm.position as hm_position, m.id_module, m.name, m.active FROM `psx1_hook_module` hm STRAIGHT_JOIN `psx1_hook` h ON (h.id_hook = hm.id_hook AND hm.id_shop = 1) STRAIGHT_JOIN `psx1_module` as m ON (m.id_module = hm.id_module) ORDER BY hm.position	1.647 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)
178	SELECT SQL_NO_CACHE p.condition, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM psx1_product p LEFT JOIN psx1_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN psx1_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN psx1_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN psx1_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN psx1_category_product cp ON (p.id_product = cp.id_product) INNER JOIN psx1_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN psx1_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN psx1_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND p.id_manufacturer IN (204, 182, 88, 178) AND c.nleft>=2 AND c.nright<=4175 GROUP BY p.id_product) p GROUP BY p.condition	1.332 ms	100	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)
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 (204, 182, 88, 178) 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))	1.327 ms	100			/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)
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 (204, 182, 88, 178) AND c.nleft>=2 AND c.nright<=4175 GROUP BY p.id_product) p WHERE p.date_add>'2025-02-01 00:00:00'	1.213 ms	100			/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)
425	INSERT INTO `psx1_guest` (`id_operating_system`, `id_web_browser`, `id_customer`, `javascript`, `screen_resolution_x`, `screen_resolution_y`, `screen_color`, `sun_java`, `adobe_flash`, `adobe_director`, `apple_quicktime`, `real_player`, `windows_media`, `accept_language`, `mobile_theme`) VALUES ('0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '0')	1.167 ms	1			/classes/ObjectModel.php:622 /classes/ObjectModel.php:576 (add) /classes/Guest.php:251 (save) /modules/statsdata/statsdata.php:82 (setNewGuest) /modules/statsdata/statsdata.php:73 (getScriptPlugins) /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)
66	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` = 80) AND (b.`id_shop` = 1) LIMIT 1	1.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)
429	INSERT INTO `psx1_connections` (`id_guest`, `id_page`, `ip_address`, `http_referer`, `id_shop`, `id_shop_group`, `date_add`) VALUES ('2815822', '25', '2890302340', '', '1', '1', '2025-05-01 15:43:49')	1.118 ms	1			/classes/ObjectModel.php:622 /classes/Connection.php:188 (add) /classes/Connection.php:97 (setNewConnection) /modules/statsdata/statsdata.php:118 (setPageConnection) /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)
1	SELECT SQL_NO_CACHE gs., s., gs.name AS group_name, s.name AS shop_name, s.active, su.domain, su.domain_ssl, su.physical_uri, su.virtual_uri FROM psx1_shop_group gs LEFT JOIN psx1_shop s ON s.id_shop_group = gs.id_shop_group LEFT JOIN psx1_shop_url su ON s.id_shop = su.id_shop AND su.main = 1 WHERE s.deleted = 0 AND gs.deleted = 0 ORDER BY gs.name, s.name	1.084 ms	1	Yes		/classes/shop/Shop.php:715 /classes/shop/Shop.php:774 (cacheShops) /classes/Configuration.php:299 (getShops) /classes/shop/Shop.php:398 (getMultiShopValues) /config/config.inc.php:117 (initialize) /index.php:27 (require)
13	SELECT SQL_NO_CACHE lower(name) as name FROM `psx1_hook` h WHERE (h.active = 1)	1.050 ms	966			/classes/Hook.php:1366 /classes/Hook.php:811 (getHookStatusByName) /classes/Dispatcher.php:606 (exec) /classes/Dispatcher.php:243 (loadRoutes) /classes/Dispatcher.php:201 (__construct) /index.php:28 (getInstance)
181	SELECT SQL_NO_CACHE p., ps., pl.*, sa.out_of_stock, IFNULL(sa.quantity, 0) as quantity, (DATEDIFF( p.`date_add`, DATE_SUB( '2025-05-01 00:00:00', INTERVAL 90 DAY ) ) > 0) as new FROM psx1_product p LEFT JOIN psx1_product_lang pl ON pl.id_product = p.id_product AND pl.id_shop = 1 AND pl.id_lang = 2 LEFT JOIN psx1_stock_available sa ON sa.id_product = p.id_product AND sa.id_product_attribute = 0 AND sa.id_shop = 1 LEFT JOIN psx1_product_shop ps ON ps.id_product = p.id_product AND ps.id_shop = 1 WHERE p.id_product IN (1403,1459,1460,1610,1811,1821,2180,2372,2474)	1.026 ms	9			/classes/ProductAssembler.php:95 /classes/ProductAssembler.php:203 (addMissingProductFieldsForMultipleProducts) /classes/controller/ProductListingFrontController.php:108 (assembleProducts) /classes/controller/ProductListingFrontController.php:379 (prepareMultipleProductsForTemplate) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
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 (204, 182, 88, 178) AND c.nleft>=2 AND c.nright<=4175 GROUP BY p.id_product) p LEFT JOIN psx1_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN psx1_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN psx1_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) WHERE ((sa.quantity>0))	1.018 ms	100			/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)
12	SELECT SQL_NO_CACHE `id_lang` FROM `psx1_lang` WHERE `iso_code` = 'mx' LIMIT 1	0.989 ms	2			/classes/Language.php:854 /classes/Tools.php:627 (getIdByIso) /classes/Dispatcher.php:236 (switchLanguage) /classes/Dispatcher.php:201 (__construct) /index.php:28 (getInstance)
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 (204, 182, 88, 178) AND c.nleft>=2 AND c.nright<=4175 GROUP BY p.id_product) p WHERE ((p.on_sale=1))	0.943 ms	100			/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)
353	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 (1403) AND ag.`is_color_group` = 1 GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` ORDER BY a.`position` ASC;	0.908 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:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (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)
354	SELECT SQL_NO_CACHE DISTINCT a.`id_attribute`, a.`id_attribute_group`, al.`name` as `attribute`, agl.`name` as `group`,pa.`reference`, pa.`ean13`, pa.`isbn`, pa.`upc`, pa.`mpn` FROM `psx1_attribute` a LEFT JOIN `psx1_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 2) LEFT JOIN `psx1_attribute_group_lang` agl ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 2) LEFT JOIN `psx1_product_attribute_combination` pac ON (a.`id_attribute` = pac.`id_attribute`) LEFT JOIN `psx1_product_attribute` pa ON (pac.`id_product_attribute` = pa.`id_product_attribute`) 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) INNER JOIN psx1_attribute_shop attribute_shop ON (attribute_shop.id_attribute = pac.id_attribute AND attribute_shop.id_shop = 1) WHERE pa.`id_product` = 1403	0.856 ms	1			/classes/Product.php:7564 /modules/psproductcountdown/psproductcountdown.php:1521 (getAttributesInformationsByProduct) /modules/psproductcountdown/psproductcountdown.php:1448 (checkProductHasAttributes) /modules/psproductcountdown/psproductcountdown.php:1491 (hookPSPC) /classes/Hook.php:1077 (hookDisplayProductPriceBlock) /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/b7/60/d6/b760d61643013890f27534a87485deeb983095f1_2.file.product-listgrid.tpl.php:200 (__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/b7/60/d6/b760d61643013890f27534a87485deeb983095f1_2.file.product-listgrid.tpl.php:357 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/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:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (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)
11	SELECT SQL_NO_CACHE COUNT(DISTINCT l.id_lang) FROM `psx1_lang` l JOIN psx1_lang_shop lang_shop ON (lang_shop.id_lang = l.id_lang AND lang_shop.id_shop = 1) WHERE l.`active` = 1 LIMIT 1	0.851 ms	4			/classes/Language.php:1216 /classes/Language.php:1513 (countActiveLanguages) /classes/Dispatcher.php:531 (isMultiLanguageActivated) /classes/Dispatcher.php:232 (setRequestUri) /classes/Dispatcher.php:201 (__construct) /index.php:28 (getInstance)

#	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