Table polyvalente

Table Fix rectangulaire 70x60cm

159.00 €ht

Table fix rectangulaire 70x60cm en mélaminé idéale comme table polyvalente, de réunion ou de conférence. Robuste et élégante elle est très appréciée par les professionnels cette table est conçue pour les collectivités, les amphithéâtres et écoles. Possibilité d'être accompagnée d'autres tables de la gamme fix afin de composer les modules de votre choix et ainsi diversifier la configuration de l'espace.

Afficher

Load Time	1068 ms
Querying Time	936 ms
Queries	945
Memory Peak Usage	63.9 Mb
Included Files	884 files - 11.88 Mb
PrestaShop Cache	- Mb
Global vars	1.16 Mb
- global $_MODULES	1129k
- global $_MODULE	19k
- global $_SERVER	9k
- global $_ENV	9k
- global $context	4k
- global $smarty	4k
- global $config	4k
- global $__composer_autoload_files	3k
- global $exportPhpConfigFile	3k
- global $_COOKIE	1k
- global $_REQUEST	1k

PrestaShop Version	8.1.4
PHP Version	8.2.21
MySQL Version	8.0.41-32
Memory Limit	512M
Max Execution Time	165s
Smarty Cache	enabled
Smarty Compilation	auto

	Time	Cumulated Time	Memory Usage	Memory Peak Usage
config	28.291 ms	28.291 ms	20.99 Mb	21.9 Mb
__construct	0.012 ms	28.303 ms	- Mb	21.9 Mb
init	46.767 ms	75.070 ms	6.72 Mb	28.6 Mb
checkAccess	0.001 ms	75.071 ms	- Mb	28.6 Mb
setMedia	3.377 ms	78.448 ms	0.45 Mb	28.6 Mb
postProcess	0.001 ms	78.449 ms	- Mb	28.6 Mb
initHeader	0.001 ms	78.450 ms	- Mb	28.6 Mb
initContent	270.232 ms	348.682 ms	13.94 Mb	42.2 Mb
initFooter	0.002 ms	348.684 ms	- Mb	42.2 Mb
display	719.229 ms	1068 ms	21.65 Mb	63.9 Mb

Hook	Time	Memory Usage
AdpMicrodatosHook	524.653 ms	14.59 Mb
=> adpmicrodatos	524.653 ms	14.59 Mb
DisplayTop	137.911 ms	2.73 Mb
=> pm_advancedtopmenu	137.911 ms	2.73 Mb
DisplayBeforeBodyClosingTag	15.192 ms	0.45 Mb
=> statsdata	9.670 ms	0.22 Mb
=> cookiesplus	5.275 ms	0.20 Mb
=> cartsguru	0.237 ms	0.03 Mb
=> cdc_googletagmanager	0.010 ms	- Mb
DisplayHeader	14.607 ms	0.50 Mb
=> pricequote	0.160 ms	0.01 Mb
=> paiementadministratif	0.035 ms	- Mb
=> amountbeforefreedelivery	0.417 ms	0.04 Mb
=> ambjolisearch	1.393 ms	0.02 Mb
=> ps_shoppingcart	0.026 ms	- Mb
=> pm_advancedtopmenu	4.462 ms	0.04 Mb
=> ps_searchbar	0.060 ms	- Mb
=> cookiesplus	0.457 ms	0.14 Mb
=> ps_imageslider	0.045 ms	- Mb
=> cdc_googletagmanager	0.042 ms	- Mb
=> tetschema	0.300 ms	0.06 Mb
=> mercanet	0.005 ms	- Mb
=> opartdevis	0.061 ms	- Mb
=> ybc_blog	7.145 ms	0.18 Mb
DisplayAfterTitleTag	10.106 ms	0.54 Mb
=> cdc_googletagmanager	10.106 ms	0.54 Mb
displayNav2	4.260 ms	0.21 Mb
=> ps_searchbar (widget)	0.154 ms	0.01 Mb
=> ps_languageselector (widget)	0.994 ms	0.04 Mb
=> ps_currencyselector (widget)	1.389 ms	0.06 Mb
=> ps_customersignin (widget)	0.925 ms	0.05 Mb
=> ps_shoppingcart (widget)	0.798 ms	0.05 Mb
displayLeftColumn	3.641 ms	0.12 Mb
=> ps_categorytree (widget)	3.641 ms	0.12 Mb
displayFooter	3.021 ms	0.18 Mb
=> ps_linklist (widget)	0.814 ms	0.06 Mb
=> ps_customeraccountlinks (widget)	0.832 ms	0.06 Mb
=> ps_contactinfo (widget)	1.375 ms	0.06 Mb
displayFooterBefore	2.399 ms	0.17 Mb
=> ps_customtext (widget)	1.510 ms	0.12 Mb
=> ps_socialfollow (widget)	0.889 ms	0.05 Mb
ProductSearchProvider	1.035 ms	0.27 Mb
=> ps_facetedsearch	0.971 ms	0.25 Mb
=> ambjolisearch	0.064 ms	0.01 Mb
DisplayLeftColumn	0.435 ms	0.05 Mb
=> ps_facetedsearch	0.137 ms	0.03 Mb
=> opartdevis	0.293 ms	0.02 Mb
=> ybc_blog	0.005 ms	- Mb
DisplayFooter	0.211 ms	0.03 Mb
=> ybc_blog	0.211 ms	0.03 Mb
DisplayAfterBodyOpeningTag	0.128 ms	0.02 Mb
=> cdc_googletagmanager	0.128 ms	0.02 Mb
ActionFrontControllerSetMedia	0.063 ms	- Mb
=> ps_socialfollow	0.032 ms	- Mb
=> ps_emailalerts	0.031 ms	- Mb
ModuleRoutes	0.045 ms	0.02 Mb
=> amppages	0.003 ms	- Mb
=> cookiesplus	0.004 ms	- Mb
=> ybc_blog	0.038 ms	0.02 Mb
ActionOutputHTMLBefore	0.006 ms	- Mb
=> cookiesplus	0.006 ms	- Mb
ActionDispatcher	0.004 ms	- Mb
=> psassistant	0.004 ms	- Mb
DisplayAfterTitleOpenGraph	0.004 ms	- Mb
=> adpmicrodatos	0.004 ms	- Mb
DisplayProductPriceBlock	0.003 ms	- Mb
=> cdc_googletagmanager	0.002 ms	- Mb
=> cdc_googletagmanager	0.000 ms	- Mb
=> cdc_googletagmanager	0.001 ms	- Mb
ActionDispatcherBefore	0.002 ms	- Mb
=> psassistant	0.002 ms	- Mb
DisplayAfterTitle	0.001 ms	- Mb
=> cdc_googletagmanager	0.001 ms	- Mb
21 hook(s)	717.727 ms	19.89 Mb

Module	Time	Memory Usage
amppages	3.309 ms	0.53 Mb
__construct	3.303 ms	0.52 Mb
hookModuleRoutes	0.006 ms	- Mb
cookiesplus	9.862 ms	1.69 Mb
__construct	4.115 ms	1.34 Mb
hookModuleRoutes	0.005 ms	- Mb
hookDisplayHeader	0.458 ms	0.14 Mb
hookDisplayBeforeBodyClosingTag	5.277 ms	0.20 Mb
hookActionOutputHTMLBefore	0.007 ms	- Mb
ybc_blog	23.347 ms	5.75 Mb
__construct	15.943 ms	5.52 Mb
hookModuleRoutes	0.039 ms	0.02 Mb
hookDisplayHeader	7.147 ms	0.18 Mb
hookDisplayLeftColumn	0.006 ms	- Mb
hookDisplayFooter	0.212 ms	0.03 Mb
psassistant	1.808 ms	0.05 Mb
__construct	1.799 ms	0.05 Mb
hookActionDispatcherBefore	0.003 ms	- Mb
hookActionDispatcher	0.006 ms	- Mb
ps_socialfollow	2.784 ms	0.19 Mb
__construct	1.861 ms	0.13 Mb
hookActionFrontControllerSetMedia	0.034 ms	- Mb
displayFooterBefore	0.890 ms	0.06 Mb
ps_emailalerts	1.166 ms	0.30 Mb
__construct	1.133 ms	0.30 Mb
hookActionFrontControllerSetMedia	0.033 ms	- Mb
pricequote	3.813 ms	0.88 Mb
__construct	3.651 ms	0.87 Mb
hookDisplayHeader	0.162 ms	0.01 Mb
paiementadministratif	3.412 ms	0.41 Mb
__construct	3.376 ms	0.41 Mb
hookDisplayHeader	0.036 ms	- Mb
amountbeforefreedelivery	1.406 ms	0.35 Mb
__construct	0.987 ms	0.32 Mb
hookDisplayHeader	0.419 ms	0.04 Mb
ambjolisearch	3.440 ms	0.52 Mb
__construct	1.980 ms	0.49 Mb
hookDisplayHeader	1.395 ms	0.02 Mb
hookProductSearchProvider	0.065 ms	0.01 Mb
ps_shoppingcart	1.052 ms	0.10 Mb
__construct	0.227 ms	0.05 Mb
hookDisplayHeader	0.026 ms	- Mb
displayNav2	0.799 ms	0.05 Mb
pm_advancedtopmenu	147.648 ms	4.37 Mb
__construct	5.270 ms	1.59 Mb
hookDisplayHeader	4.464 ms	0.04 Mb
hookDisplayTop	137.914 ms	2.73 Mb
ps_searchbar	0.361 ms	0.04 Mb
__construct	0.144 ms	0.03 Mb
hookDisplayHeader	0.061 ms	- Mb
displayNav2	0.156 ms	0.01 Mb
ps_imageslider	0.897 ms	0.25 Mb
__construct	0.851 ms	0.24 Mb
hookDisplayHeader	0.046 ms	- Mb
cdc_googletagmanager	12.930 ms	1.28 Mb
__construct	2.631 ms	0.71 Mb
hookDisplayHeader	0.043 ms	- Mb
hookDisplayAfterTitleTag	10.109 ms	0.54 Mb
hookDisplayAfterTitle	0.002 ms	- Mb
hookDisplayAfterBodyOpeningTag	0.129 ms	0.02 Mb
hookDisplayProductPriceBlock	0.004 ms	- Mb
hookDisplayProductPriceBlock	0.001 ms	- Mb
hookDisplayProductPriceBlock	0.001 ms	- Mb
hookDisplayBeforeBodyClosingTag	0.010 ms	- Mb
tetschema	0.827 ms	0.25 Mb
__construct	0.526 ms	0.20 Mb
hookDisplayHeader	0.301 ms	0.06 Mb
mercanet	4.922 ms	1.77 Mb
__construct	4.916 ms	1.77 Mb
hookDisplayHeader	0.006 ms	- Mb
opartdevis	10.124 ms	0.79 Mb
__construct	9.768 ms	0.76 Mb
hookDisplayHeader	0.062 ms	- Mb
hookDisplayLeftColumn	0.294 ms	0.02 Mb
ps_facetedsearch	3.049 ms	0.73 Mb
__construct	1.938 ms	0.44 Mb
hookProductSearchProvider	0.973 ms	0.26 Mb
hookDisplayLeftColumn	0.138 ms	0.03 Mb
adpmicrodatos	526.505 ms	15.08 Mb
__construct	1.844 ms	0.49 Mb
hookDisplayAfterTitleOpenGraph	0.005 ms	- Mb
hookAdpMicrodatosHook	524.656 ms	14.59 Mb
ps_languageselector	1.123 ms	0.07 Mb
__construct	0.128 ms	0.03 Mb
displayNav2	0.995 ms	0.04 Mb
ps_currencyselector	1.544 ms	0.09 Mb
__construct	0.154 ms	0.03 Mb
displayNav2	1.390 ms	0.06 Mb
ps_customersignin	1.055 ms	0.08 Mb
__construct	0.128 ms	0.03 Mb
displayNav2	0.927 ms	0.05 Mb
ps_categorytree	4.004 ms	0.26 Mb
__construct	0.360 ms	0.14 Mb
displayLeftColumn	3.644 ms	0.12 Mb
ps_customtext	1.866 ms	0.19 Mb
__construct	0.354 ms	0.08 Mb
displayFooterBefore	1.512 ms	0.12 Mb
ps_linklist	1.428 ms	0.27 Mb
__construct	0.612 ms	0.21 Mb
displayFooter	0.816 ms	0.06 Mb
ps_customeraccountlinks	0.978 ms	0.10 Mb
__construct	0.144 ms	0.04 Mb
displayFooter	0.834 ms	0.06 Mb
ps_contactinfo	1.553 ms	0.11 Mb
__construct	0.177 ms	0.04 Mb
displayFooter	1.376 ms	0.06 Mb
statsdata	9.895 ms	0.27 Mb
__construct	0.224 ms	0.06 Mb
hookDisplayBeforeBodyClosingTag	9.671 ms	0.22 Mb
cartsguru	2.523 ms	0.56 Mb
__construct	2.285 ms	0.54 Mb
hookDisplayBeforeBodyClosingTag	0.238 ms	0.03 Mb
30 module(s)	788.631 ms	37.32 Mb

Table polyvalente

Table polyvalente

Table de traiteur

Table de réunion

Table de cantine

Table Fix rectangulaire 70x60cm

Information

Stopwatch SQL - 945 queries

Doubles

Tables stress

ObjectModel instances

Included Files

67 queries	SELECT SUM(quantity) FROM `jk_stock_available` WHERE (id_product = XX) AND (id_product_attribute = XX) AND (id_shop = XX) AND (id_shop_group = XX) LIMIT XX
67 queries	SELECT COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), XX) as deep_quantity, COALESCE(SUM(first_level_quantity), XX) as quantity FROM (SELECT cp.`quantity` as first_level_quantity, XX as pack_quantity FROM `jk_cart_product` cp WHERE cp.`id_product_attribute` = XX AND cp.`id_customization` = XX AND cp.`id_cart` = XX AND cp.`id_product` = XX UNION SELECT XX as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity FROM `jk_cart_product` cp JOIN `jk_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `jk_product` pr ON p.`id_product_pack` = pr.`id_product` WHERE cp.`id_product_attribute` = XX AND cp.`id_customization` = 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
37 queries	SELECT XX FROM `jk_specific_price` WHERE id_product = XX LIMIT XX
36 queries	SELECT image_shop.`id_image` FROM `jk_image` i INNER JOIN jk_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
36 queries	SELECT name FROM jk_category_lang WHERE id_shop = XX AND id_lang = XX AND id_category = XX LIMIT XX
36 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 `jk_product` p INNER JOIN `jk_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = XX) LEFT JOIN `jk_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)
36 queries	SELECT `id_tax_rules_group` FROM `jk_product_shop` WHERE `id_product` = XX AND id_shop=XX LIMIT XX
36 queries	SELECT `reduction` FROM `jk_product_group_reduction_cache` WHERE `id_product` = XX AND `id_group` = XX LIMIT XX
36 queries	SELECT COUNT(*) FROM `jk_pack` WHERE id_product_pack = XX LIMIT XX
36 queries	SELECT product_type FROM `jk_product` WHERE id_product = XX LIMIT XX
36 queries	SELECT name, value, pf.id_feature, f.position, fvl.id_feature_value FROM jk_feature_product pf LEFT JOIN jk_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = XX) LEFT JOIN jk_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = XX) LEFT JOIN jk_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = XX) INNER JOIN jk_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
36 queries	SELECT * FROM jk_product_attachment pa LEFT JOIN jk_attachment a ON a.id_attachment = pa.id_attachment LEFT JOIN jk_attachment_lang al ON (a.id_attachment = al.id_attachment AND al.id_lang = XX) WHERE pa.id_product = XX
36 queries	SELECT a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, pa.`reference`, pa.`eanXX`, pa.`isbn`, pa.`upc`, pa.`mpn`, pal.`available_now`, pal.`available_later` FROM `jk_attribute` a LEFT JOIN `jk_attribute_lang` al ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = XX) LEFT JOIN `jk_product_attribute_combination` pac ON (pac.`id_attribute` = a.`id_attribute`) LEFT JOIN `jk_product_attribute` pa ON (pa.`id_product_attribute` = pac.`id_product_attribute`) INNER JOIN jk_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = XX) LEFT JOIN `jk_product_attribute_lang` pal ON (pal.`id_product_attribute` = pac.`id_product_attribute` AND pal.`id_lang` = XX) LEFT JOIN `jk_attribute_group_lang` agl ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = XX) WHERE pa.`id_product` = XX AND pac.`id_product_attribute` = XX AND agl.`id_lang` = XX
35 queries	SELECT ate., atel., cl.link_rewrite, cl.meta_title, cal.link_rewrite as category_link_rewrite, cal.name as category_name, m.name as manufacturer_name, s.name as supplier_name FROM `jk_pm_advancedtopmenu_elements` ate LEFT JOIN `jk_pm_advancedtopmenu_elements_lang` atel ON (ate.`id_element` = atel.`id_element` AND atel.`id_lang` = XX) LEFT JOIN jk_cms c ON (c.id_cms = ate.`id_cms`) LEFT JOIN jk_cms_shop cms_shop ON (cms_shop.id_cms = c.id_cms AND cms_shop.id_shop = XX) LEFT JOIN jk_cms_lang cl ON (c.id_cms = cl.id_cms AND cl.id_lang = XX) LEFT JOIN jk_cms_category cc ON (cc.id_cms_category = ate.`id_cms_category`) LEFT JOIN jk_cms_category_shop cms_category_shop ON (cms_category_shop.id_cms_category = cc.id_cms_category AND cms_category_shop.id_shop = XX) LEFT JOIN jk_cms_category_lang ccl ON (cc.id_cms_category = ccl.id_cms_category AND ccl.id_lang = XX) LEFT JOIN jk_category ca ON (ca.id_category = ate.`id_category`) LEFT JOIN `jk_category_group` cg ON (cg.`id_category` = ca.`id_category`) LEFT JOIN jk_category_lang cal ON (ca.id_category = cal.id_category AND cal.id_lang = XX AND cal.id_shop = XX ) LEFT JOIN `jk_manufacturer` m ON (ate.`id_manufacturer` = m.`id_manufacturer`) LEFT JOIN jk_manufacturer_shop manufacturer_shop ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = XX) LEFT JOIN `jk_supplier` s ON (ate.`id_supplier` = s.`id_supplier`) LEFT JOIN jk_supplier_shop supplier_shop ON (supplier_shop.id_supplier = s.id_supplier AND supplier_shop.id_shop = XX) WHERE ate.`active` = XX AND (ate.`active_desktop` = XX \|\| ate.`active_mobile` = XX) AND ate.`id_column` = XX AND ((ate.`id_manufacturer` = XX AND ate.`id_supplier` = XX AND ate.`id_category` = XX AND ate.`id_cms` = XX AND ate.`id_cms_category` = XX) OR c.id_cms IS NOT NULL OR cc.id_cms_category IS NOT NULL OR m.id_manufacturer IS NOT NULL OR ca.id_category IS NOT NULL OR s.`id_supplier` IS NOT NULL) AND (cms_shop.`id_shop` = XX OR cms_shop.`id_shop` IS NULL) AND (manufacturer_shop.`id_shop` = XX OR manufacturer_shop.`id_shop` IS NULL) AND (supplier_shop.`id_shop` = XX OR supplier_shop.`id_shop` IS NULL)AND IF (ate.`id_category` IS NULL OR ate.`id_category` = XX, XX, cg.`id_group` IN (XX)) GROUP BY ate.`id_element` ORDER BY ate.`position`
31 queries	SELECT * FROM `jk_product` a LEFT JOIN `jk_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = XX LEFT JOIN `jk_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
31 queries	SELECT product_attribute_shop.`price` FROM `jk_product_attribute` pa INNER JOIN jk_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = XX) WHERE pa.`id_product_attribute` = XX LIMIT XX
31 queries	SELECT pa.`available_date` FROM `jk_product` p LEFT JOIN `jk_product_attribute` pa ON (pa.`id_product` = p.`id_product`) INNER JOIN jk_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = XX) INNER JOIN jk_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = XX) WHERE p.`id_product` = XX AND pa.`id_product` = XX AND pa.`id_product_attribute` = XX LIMIT XX
31 queries	SELECT * FROM `jk_product_attribute` a LEFT JOIN `jk_product_attribute_shop` `c` ON a.`id_product_attribute` = c.`id_product_attribute` AND c.`id_shop` = XX WHERE (a.`id_product_attribute` = XX) LIMIT XX
31 queries	SELECT * FROM `jk_product_attribute_lang` WHERE `id_product_attribute` = XX
24 queries	SELECT atmc., atmcl., cl.link_rewrite, cl.meta_title, cal.link_rewrite as category_link_rewrite, cal.name as category_name, m.name as manufacturer_name, s.name as supplier_name FROM `jk_pm_advancedtopmenu_columns` atmc LEFT JOIN `jk_pm_advancedtopmenu_columns_lang` atmcl ON (atmc.`id_column` = atmcl.`id_column` AND atmcl.`id_lang` = XX) LEFT JOIN jk_cms c ON (c.id_cms = atmc.`id_cms`) LEFT JOIN jk_cms_shop cms_shop ON (cms_shop.id_cms = c.id_cms AND cms_shop.id_shop = XX) LEFT JOIN jk_cms_lang cl ON (c.id_cms = cl.id_cms AND cl.id_lang = XX) LEFT JOIN jk_category ca ON (ca.id_category = atmc.`id_category`) LEFT JOIN `jk_category_group` cg ON (cg.`id_category` = ca.`id_category`) LEFT JOIN jk_category_lang cal ON (ca.id_category = cal.id_category AND cal.id_lang = XX AND cal.id_shop = XX ) LEFT JOIN `jk_manufacturer` m ON (atmc.`id_manufacturer` = m.`id_manufacturer`) LEFT JOIN jk_manufacturer_shop manufacturer_shop ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = XX) LEFT JOIN `jk_supplier` s ON (atmc.`id_supplier` = s.`id_supplier`) LEFT JOIN jk_supplier_shop supplier_shop ON (supplier_shop.id_supplier = s.id_supplier AND supplier_shop.id_shop = XX) WHERE atmc.`active` = XX AND (atmc.`active_desktop` = XX \|\| atmc.`active_mobile` = XX) AND atmc.`id_wrap` = XX AND ((atmc.`id_manufacturer` = XX AND atmc.`id_supplier` = XX AND atmc.`id_category` = XX AND atmc.`id_cms` = XX) OR c.id_cms IS NOT NULL OR m.id_manufacturer IS NOT NULL OR ca.id_category IS NOT NULL OR s.`id_supplier` IS NOT NULL)AND IF (atmc.`id_category` IS NULL OR atmc.`id_category` = XX, XX, cg.`id_group` IN (XX)) GROUP BY atmc.`id_column` ORDER BY atmc.`position`
13 queries	SELECT `id_module` FROM `jk_module_shop` WHERE `id_module` = XX AND `id_shop` = XX LIMIT XX
11 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 jk_product p LEFT JOIN jk_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN jk_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN jk_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 jk_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN jk_category_product cp ON (p.id_product = cp.id_product) INNER JOIN jk_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = XX AND ps.active = TRUE) INNER JOIN jk_category c ON (cp.id_category = c.id_category AND c.active=XX) LEFT JOIN jk_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN jk_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN jk_feature_product fp_XX ON (p.id_product = fp_XX.id_product) LEFT JOIN jk_feature_product fp_XX ON (p.id_product = fp_XX.id_product) WHERE ((fp.id_feature_value=XX)) AND ((fp_XX.id_feature_value IN (XX, XX, XX))) AND ((fp_XX.id_feature_value IN (XX, XX, XX, XX, XX))) AND ps.id_shop='XX' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='XX' AND c.nleft>=XX AND c.nright<=XX GROUP BY p.id_product) p INNER JOIN jk_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN jk_feature_product fp_XX ON (p.id_product = fp_XX.id_product) LEFT JOIN jk_feature_product fp_XX ON (p.id_product = fp_XX.id_product) LEFT JOIN jk_feature_product fp_XX ON (p.id_product = fp_XX.id_product) WHERE ((fp.id_feature=XX)) AND ((fp_XX.id_feature_value=XX)) AND ((fp_XX.id_feature_value IN (XX, XX, XX))) AND ((fp_XX.id_feature_value IN (XX, XX, XX, XX, XX))) GROUP BY fp.id_feature_value
9 queries	SELECT v., vl., IF(lifvlv.`url_name` IS NULL OR lifvlv.`url_name` = "", NULL, lifvlv.`url_name`) AS url_name, IF(lifvlv.`meta_title` IS NULL OR lifvlv.`meta_title` = "", NULL, lifvlv.`meta_title`) AS meta_title FROM `jk_feature_value` v LEFT JOIN `jk_feature_value_lang` vl ON (v.`id_feature_value` = vl.`id_feature_value` AND vl.`id_lang` = XX) LEFT JOIN `jk_layered_indexable_feature_value_lang_value` lifvlv ON (v.`id_feature_value` = lifvlv.`id_feature_value` AND lifvlv.`id_lang` = XX) WHERE v.`id_feature` = XX ORDER BY vl.`value` ASC
9 queries	SELECT atmcw., atmcwl. FROM `jk_pm_advancedtopmenu_columns_wrap` atmcw LEFT JOIN `jk_pm_advancedtopmenu_columns_wrap_lang` atmcwl ON (atmcw.`id_wrap` = atmcwl.`id_wrap` AND atmcwl.`id_lang` = XX) WHERE atmcw.`active` = XX AND (atmcw.`active_desktop` = XX \|\| atmcw.`active_mobile` = XX) AND atmcw.`id_menu` = XX ORDER BY atmcw.`position`
5 queries	SELECT m.`id_module`, m.`name`, ms.`id_module`as `mshop` FROM `jk_module` m LEFT JOIN `jk_module_shop` ms ON m.`id_module` = ms.`id_module` AND ms.`id_shop` = XX
5 queries	SELECT * FROM `jk_category` a LEFT JOIN `jk_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = XX LEFT JOIN `jk_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
4 queries	SELECT * FROM `jk_category` a LEFT JOIN `jk_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = XX WHERE (a.`id_category` = XX) LIMIT XX
4 queries	SELECT * FROM `jk_category_lang` WHERE `id_category` = XX AND `id_shop` = XX
4 queries	SELECT cl.`link_rewrite` FROM `jk_category_lang` cl WHERE `id_lang` = XX AND cl.id_shop = XX AND cl.`id_category` = XX LIMIT XX
4 queries	SELECT * FROM jk_cookiesplus_cookie cc LEFT JOIN jk_cookiesplus_cookie_lang ccl on cc.`id_cookiesplus_cookie` = ccl.`id_cookiesplus_cookie` WHERE `id_cookiesplus_finality` = XX AND ccl.`id_lang` = XX AND cc.`active` = XX AND cc.`id_shop` = XX ORDER BY cc.`name`;
3 queries	SELECT c.`nleft`, c.`nright` FROM `jk_category` c LEFT JOIN `jk_category_lang` cl ON (c.`id_category` = cl.`id_category` AND `id_lang` = XX AND cl.id_shop = XX ) WHERE c.`id_category` = XX LIMIT XX
3 queries	SELECT c.`nleft`, c.`nright` FROM `jk_category` c WHERE c.`id_category` = XX LIMIT XX
3 queries	SELECT c., cl. FROM `jk_category` c LEFT JOIN `jk_category_lang` cl ON (c.`id_category` = cl.`id_category` AND `id_lang` = XX AND cl.id_shop = XX ) WHERE c.`nleft` <= XX AND c.`nright` >= XX AND c.`nleft` >= XX AND c.`nright` <= XX ORDER BY `nleft` DESC
2 queries	SELECT `id_lang` FROM `jk_lang` WHERE `locale` = 'fr-fr' OR `language_code` = 'fr-fr' LIMIT XX
2 queries	SELECT c.*, cl.`id_lang`, cl.`name`, cl.`description`, cl.`additional_description`, cl.`link_rewrite`, cl.`meta_title`, cl.`meta_keywords`, cl.`meta_description` FROM `jk_category` c INNER JOIN jk_category_shop category_shop ON (category_shop.id_category = c.id_category AND category_shop.id_shop = XX) LEFT JOIN `jk_category_lang` cl ON (c.`id_category` = cl.`id_category` AND `id_lang` = XX AND cl.id_shop = XX ) LEFT JOIN `jk_category_group` cg ON (cg.`id_category` = c.`id_category`) WHERE `id_parent` = XX AND `active` = XX AND cg.`id_group` =XX GROUP BY c.`id_category` ORDER BY `level_depth` ASC, category_shop.`position` ASC
2 queries	SELECT XX FROM `jk_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 `need_identification_number` FROM `jk_country` WHERE `id_country` = XX LIMIT XX
2 queries	SELECT `image_type` FROM `jk_pm_advancedtopmenu_lang` WHERE `image_type` NOT IN ("jpg", "png", "gif") AND `id_lang` = XX
2 queries	SELECT `image_type` FROM `jk_pm_advancedtopmenu_columns_lang` WHERE `image_type` NOT IN ("jpg", "png", "gif") AND `id_lang` = XX
2 queries	SELECT `image_type` FROM `jk_pm_advancedtopmenu_elements_lang` WHERE `image_type` NOT IN ("jpg", "png", "gif") AND `id_lang` = XX
2 queries	SELECT * FROM jk_hook_module WHERE `id_hook` = XX AND `id_module` = XX AND `id_shop` = XX

Name	Instances	Source
Product	41	/classes/Link.php:113 (__construct) [id: 1236] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 1236] /modules/cdc_googletagmanager/services/Gtm_Product.php:164 (__construct) [id: 1236] /modules/cdc_googletagmanager/services/Gtm_Product.php:164 (__construct) [id: 1236] /classes/Link.php:113 (__construct) [id: 1236] /classes/Link.php:113 (__construct) [id: 1236] /classes/Link.php:113 (__construct) [id: 1236] /classes/Link.php:113 (__construct) [id: 1236] /classes/Link.php:113 (__construct) [id: 1236] /classes/Link.php:113 (__construct) [id: 1236] /classes/Link.php:113 (__construct) [id: 1236] /classes/Link.php:113 (__construct) [id: 1773] /classes/Link.php:113 (__construct) [id: 1774] /classes/Link.php:113 (__construct) [id: 1775] /classes/Link.php:113 (__construct) [id: 1776] /classes/Link.php:113 (__construct) [id: 1777] /classes/Link.php:113 (__construct) [id: 1778] /classes/Link.php:113 (__construct) [id: 1770] /classes/Link.php:113 (__construct) [id: 1771] /classes/Link.php:113 (__construct) [id: 1772] /classes/Link.php:113 (__construct) [id: 1765] /classes/Link.php:113 (__construct) [id: 1766] /classes/Link.php:113 (__construct) [id: 1767] /classes/Link.php:113 (__construct) [id: 1768] /classes/Link.php:113 (__construct) [id: 1119] /classes/Link.php:113 (__construct) [id: 1120] /classes/Link.php:113 (__construct) [id: 1121] /classes/Link.php:113 (__construct) [id: 1123] /classes/Link.php:113 (__construct) [id: 1124] /classes/Link.php:113 (__construct) [id: 1125] /classes/Link.php:113 (__construct) [id: 1109] /classes/Link.php:113 (__construct) [id: 1110] /classes/Link.php:113 (__construct) [id: 1113] /classes/Link.php:113 (__construct) [id: 1111] /classes/Link.php:113 (__construct) [id: 1114] /classes/Link.php:113 (__construct) [id: 1115] /classes/Link.php:113 (__construct) [id: 1116] /classes/Link.php:113 (__construct) [id: 1117] /classes/Link.php:113 (__construct) [id: 1237] /classes/Link.php:113 (__construct) [id: 1238] /classes/Link.php:113 (__construct) [id: 1239]
Combination	32	/classes/Product.php:5898 (__construct) [id: 6834] /modules/cdc_googletagmanager/classes/gtm/DataLayerProduct.php:62 (__construct) [id: 6834] /classes/Product.php:5898 (__construct) [id: 6952] /classes/Product.php:5898 (__construct) [id: 6955] /classes/Product.php:5898 (__construct) [id: 6958] /classes/Product.php:5898 (__construct) [id: 6961] /classes/Product.php:5898 (__construct) [id: 6964] /classes/Product.php:5898 (__construct) [id: 6967] /classes/Product.php:5898 (__construct) [id: 6943] /classes/Product.php:5898 (__construct) [id: 6946] /classes/Product.php:5898 (__construct) [id: 6949] /classes/Product.php:5898 (__construct) [id: 6932] /classes/Product.php:5898 (__construct) [id: 6935] /classes/Product.php:5898 (__construct) [id: 6938] /classes/Product.php:5898 (__construct) [id: 6737] /classes/Product.php:5898 (__construct) [id: 6796] /classes/Product.php:5898 (__construct) [id: 6802] /classes/Product.php:5898 (__construct) [id: 6808] /classes/Product.php:5898 (__construct) [id: 6820] /classes/Product.php:5898 (__construct) [id: 6740] /classes/Product.php:5898 (__construct) [id: 6827] /classes/Product.php:5898 (__construct) [id: 6747] /classes/Product.php:5898 (__construct) [id: 6754] /classes/Product.php:5898 (__construct) [id: 6766] /classes/Product.php:5898 (__construct) [id: 6760] /classes/Product.php:5898 (__construct) [id: 6772] /classes/Product.php:5898 (__construct) [id: 6778] /classes/Product.php:5898 (__construct) [id: 6784] /classes/Product.php:5898 (__construct) [id: 6790] /classes/Product.php:5898 (__construct) [id: 6840] /classes/Product.php:5898 (__construct) [id: 6846] /classes/Product.php:5898 (__construct) [id: 6852]
Category	22	/controllers/front/listing/CategoryController.php:76 (__construct) [id: 158] /controllers/front/listing/CategoryController.php:213 (__construct) [id: 30] /controllers/front/listing/CategoryController.php:213 (__construct) [id: 108] /controllers/front/listing/CategoryController.php:213 (__construct) [id: 159] /classes/Meta.php:380 (__construct) [id: 158] /classes/PrestaShopCollection.php:385 (hydrateCollection) [id: ] /classes/PrestaShopCollection.php:385 (hydrateCollection) [id: ] /classes/PrestaShopCollection.php:385 (hydrateCollection) [id: ] /modules/ps_facetedsearch/src/Product/Search.php:364 (__construct) [id: 158] /modules/cdc_googletagmanager/cdc_googletagmanager.php:1313 (__construct) [id: 158] /modules/cdc_googletagmanager/cdc_googletagmanager.php:1341 (getParentsCategories) [id: 2] /modules/cdc_googletagmanager/classes/gtm/DataLayerProduct.php:101 (__construct) [id: 108] /modules/cdc_googletagmanager/cdc_googletagmanager.php:1374 (__construct) [id: 2] /modules/cdc_googletagmanager/cdc_googletagmanager.php:1323 (__construct) [id: 158] /modules/cdc_googletagmanager/cdc_googletagmanager.php:1323 (__construct) [id: 29] /modules/cdc_googletagmanager/cdc_googletagmanager.php:1323 (__construct) [id: 158] /modules/cdc_googletagmanager/cdc_googletagmanager.php:1313 (__construct) [id: 158] /modules/cdc_googletagmanager/cdc_googletagmanager.php:1341 (getParentsCategories) [id: 2] /modules/ps_categorytree/ps_categorytree.php:338 (__construct) [id: 158] /modules/adpmicrodatos/classes/adpmicrodatos.microdatos.class.php:47 (__construct) [id: 158] /modules/adpmicrodatos/classes/adpmicrodatos.microdatos.class.php:48 (getParentsCategories) [id: 2] /modules/adpmicrodatos/classes/adpmicrodatos.microdatos.class.php:162 (__construct) [id: 158]
Country	5	/config/config.inc.php:151 (__construct) [id: 8] /classes/AddressFormat.php:404 (__construct) [id: 8] /classes/controller/FrontController.php:1760 (__construct) [id: 8] /classes/AddressFormat.php:404 (__construct) [id: 8] /modules/ps_contactinfo/ps_contactinfo.php:104 (__construct) [id: 8]
Address	4	/classes/shop/Shop.php:486 (__construct) [id: ] /classes/Product.php:3694 (initialize) [id: ] /classes/Product.php:3804 (__construct) [id: ] /classes/Product.php:5950 (__construct) [id: ]
AddressFormat	2	/classes/controller/FrontController.php:1754 (generateAddress) [id: ] /modules/ps_contactinfo/ps_contactinfo.php:98 (generateAddress) [id: ]
Language	2	/config/config.inc.php:216 (__construct) [id: 1] /classes/Tools.php:573 (__construct) [id: 1]
Currency	2	/src/Adapter/Currency/CurrencyDataProvider.php:101 (__construct) [id: 1] /classes/Tools.php:703 (getCurrencyInstance) [id: 1]
Cart	2	/classes/controller/FrontController.php:465 (__construct) [id: ] /classes/controller/FrontController.php:534 (__construct) [id: ]
State	2	/classes/controller/FrontController.php:1759 (__construct) [id: 0] /modules/ps_contactinfo/ps_contactinfo.php:93 (__construct) [id: 0]
Shop	1	/config/config.inc.php:122 (initialize) [id: 1]
Tax	1	/classes/tax/TaxRulesTaxManager.php:116 (__construct) [id: 5]
Gender	1	/classes/controller/FrontController.php:1684 (__construct) [id: 0]
Risk	1	/classes/controller/FrontController.php:1687 (__construct) [id: ]
Group	1	/classes/Cart.php:249 (getCurrent) [id: 1]
Customer	1	/config/config.inc.php:269 (__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
90	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 jk_product p LEFT JOIN jk_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN jk_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN jk_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 jk_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN jk_category_product cp ON (p.id_product = cp.id_product) INNER JOIN jk_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN jk_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN jk_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN jk_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN jk_feature_product fp_1 ON (p.id_product = fp_1.id_product) WHERE ((fp.id_feature_value IN (74011, 74010, 74008))) AND ((fp_1.id_feature_value IN (74127, 74139, 74052, 74143, 74054))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=20 AND c.nright<=27 GROUP BY p.id_product) p INNER JOIN jk_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN jk_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN jk_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((fp.id_feature=90)) AND ((fp_1.id_feature_value IN (74011, 74010, 74008))) AND ((fp_2.id_feature_value IN (74127, 74139, 74052, 74143, 74054))) GROUP BY fp.id_feature_value	29.702 ms	319680	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:86 /modules/ps_facetedsearch/src/Adapter/MySQL.php:786 (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:356 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:134 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
87	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 jk_product p LEFT JOIN jk_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN jk_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN jk_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 jk_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN jk_category_product cp ON (p.id_product = cp.id_product) INNER JOIN jk_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN jk_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN jk_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN jk_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN jk_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN jk_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((fp.id_feature_value=74122)) AND ((fp_1.id_feature_value IN (74011, 74010, 74008))) AND ((fp_2.id_feature_value IN (74127, 74139, 74052, 74143, 74054))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=20 AND c.nright<=27 GROUP BY p.id_product) p LEFT JOIN jk_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN jk_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN jk_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((fp.id_feature_value=74122)) AND ((fp_1.id_feature_value IN (74011, 74010, 74008))) AND ((fp_2.id_feature_value IN (74127, 74139, 74052, 74143, 74054))) GROUP BY p.id_manufacturer	8.415 ms	1788480	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:86 /modules/ps_facetedsearch/src/Adapter/MySQL.php:786 (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:356 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:134 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
701	SELECT SQL_NO_CACHE COUNT(*) FROM `jk_pack` WHERE id_product_pack = 1125 LIMIT 1	7.312 ms	1			/classes/Pack.php:89 /classes/Product.php:4338 (isPack) /classes/Product.php:5785 (getQuantity) /classes/Product.php:5976 (getProductProperties) /classes/Category.php:1074 (getProductsProperties) /modules/adpmicrodatos/classes/adpmicrodatos.microdatos.class.php:163 (getProducts) /modules/adpmicrodatos/adpmicrodatos.php:832 (getListadosProductosFromCategory) /modules/adpmicrodatos/adpmicrodatos.php:714 (hook) /classes/Hook.php:1043 (hookAdpMicrodatosHook) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:418 (coreCallHook) /classes/Hook.php:981 (callHookOn) /config/smarty.config.inc.php:198 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/prod/smarty/compile/classic_style_fashionlayouts_layout_left_column_tpl/17/df/bb/17dfbb8581c6c6a12d7607fb69e892d032ee9291_2.file.layout-both-columns.tpl.php:118 (__call) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6800249180a5e2_20613121) /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:115 (_subTemplateRender) /var/cache/prod/smarty/compile/classic_style_fashionlayouts_layout_left_column_tpl/65/f4/7d/65f47d36b8a8414a1523606db7ea19c8ca3dfe52_2.file.layout-left-column.tpl.php:38 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_680024917f7302_51127189) /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:115 (_subTemplateRender) /var/cache/prod/smarty/compile/classic_style_fashionlayouts_layout_left_column_tpl/01/c8/49/01c849af9a7ab6dcfdfbbb03597572a51f2c3fc0_2.file.product-list.tpl.php:35 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_680024917a91f1_03691258) /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:115 (_subTemplateRender) /var/cache/prod/smarty/compile/classic_style_fashionlayouts_layout_left_column_tpl/0a/55/dd/0a55dd745037efad9dd813c5cb67beeea3a44e56_2.file.category.tpl.php:32 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_680024917959d0_75817348) /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:753 (fetch) /classes/controller/FrontController.php:735 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
3	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 `jk_configuration` c LEFT JOIN `jk_configuration_lang` cl ON (c.`id_configuration` = cl.`id_configuration`)	7.298 ms	2220			/classes/Configuration.php:180 /classes/Configuration.php:229 (loadConfiguration) /override/classes/Configuration.php:46 (get) /classes/Configuration.php:302 (get) /classes/shop/Shop.php:398 (getMultiShopValues) /config/config.inc.php:122 (initialize) /index.php:27 (require)
92	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 jk_product p LEFT JOIN jk_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN jk_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN jk_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 jk_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN jk_category_product cp ON (p.id_product = cp.id_product) INNER JOIN jk_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN jk_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN jk_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN jk_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN jk_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN jk_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((fp.id_feature_value=74122)) AND ((fp_1.id_feature_value IN (74011, 74010, 74008))) AND ((fp_2.id_feature_value IN (74127, 74139, 74052, 74143, 74054))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=20 AND c.nright<=27 GROUP BY p.id_product) p INNER JOIN jk_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN jk_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN jk_feature_product fp_2 ON (p.id_product = fp_2.id_product) LEFT JOIN jk_feature_product fp_3 ON (p.id_product = fp_3.id_product) WHERE ((fp.id_feature=188)) AND ((fp_1.id_feature_value=74122)) AND ((fp_2.id_feature_value IN (74011, 74010, 74008))) AND ((fp_3.id_feature_value IN (74127, 74139, 74052, 74143, 74054))) GROUP BY fp.id_feature_value	6.937 ms	1788480	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:86 /modules/ps_facetedsearch/src/Adapter/MySQL.php:786 (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:356 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:134 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
94	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 jk_product p LEFT JOIN jk_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN jk_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN jk_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 jk_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN jk_category_product cp ON (p.id_product = cp.id_product) INNER JOIN jk_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN jk_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN jk_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN jk_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN jk_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN jk_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((fp.id_feature_value=74122)) AND ((fp_1.id_feature_value IN (74011, 74010, 74008))) AND ((fp_2.id_feature_value IN (74127, 74139, 74052, 74143, 74054))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=20 AND c.nright<=27 GROUP BY p.id_product) p INNER JOIN jk_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN jk_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN jk_feature_product fp_2 ON (p.id_product = fp_2.id_product) LEFT JOIN jk_feature_product fp_3 ON (p.id_product = fp_3.id_product) WHERE ((fp.id_feature=111)) AND ((fp_1.id_feature_value=74122)) AND ((fp_2.id_feature_value IN (74011, 74010, 74008))) AND ((fp_3.id_feature_value IN (74127, 74139, 74052, 74143, 74054))) GROUP BY fp.id_feature_value	6.686 ms	1788480	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:86 /modules/ps_facetedsearch/src/Adapter/MySQL.php:786 (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:356 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:134 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
676	SELECT SQL_NO_CACHE product_attribute_shop.`price` FROM `jk_product_attribute` pa INNER JOIN jk_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) WHERE pa.`id_product_attribute` = 6740 LIMIT 1	6.495 ms	1			/classes/Combination.php:560 /classes/Product.php:5666 (getPrice) /classes/Product.php:5976 (getProductProperties) /classes/Category.php:1074 (getProductsProperties) /modules/adpmicrodatos/classes/adpmicrodatos.microdatos.class.php:163 (getProducts) /modules/adpmicrodatos/adpmicrodatos.php:832 (getListadosProductosFromCategory) /modules/adpmicrodatos/adpmicrodatos.php:714 (hook) /classes/Hook.php:1043 (hookAdpMicrodatosHook) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:418 (coreCallHook) /classes/Hook.php:981 (callHookOn) /config/smarty.config.inc.php:198 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/prod/smarty/compile/classic_style_fashionlayouts_layout_left_column_tpl/17/df/bb/17dfbb8581c6c6a12d7607fb69e892d032ee9291_2.file.layout-both-columns.tpl.php:118 (__call) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6800249180a5e2_20613121) /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:115 (_subTemplateRender) /var/cache/prod/smarty/compile/classic_style_fashionlayouts_layout_left_column_tpl/65/f4/7d/65f47d36b8a8414a1523606db7ea19c8ca3dfe52_2.file.layout-left-column.tpl.php:38 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_680024917f7302_51127189) /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:115 (_subTemplateRender) /var/cache/prod/smarty/compile/classic_style_fashionlayouts_layout_left_column_tpl/01/c8/49/01c849af9a7ab6dcfdfbbb03597572a51f2c3fc0_2.file.product-list.tpl.php:35 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_680024917a91f1_03691258) /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:115 (_subTemplateRender) /var/cache/prod/smarty/compile/classic_style_fashionlayouts_layout_left_column_tpl/0a/55/dd/0a55dd745037efad9dd813c5cb67beeea3a44e56_2.file.category.tpl.php:32 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_680024917959d0_75817348) /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:753 (fetch) /classes/controller/FrontController.php:735 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
620	SELECT SQL_NO_CACHE `reduction` FROM `jk_product_group_reduction_cache` WHERE `id_product` = 1120 AND `id_group` = 1 LIMIT 1	6.408 ms	0			/classes/GroupReduction.php:153 /classes/Product.php:3968 (getValueForProduct) /classes/Product.php:3716 (priceCalculation) /classes/Product.php:5679 (getPriceStatic) /classes/Product.php:5976 (getProductProperties) /classes/Category.php:1074 (getProductsProperties) /modules/adpmicrodatos/classes/adpmicrodatos.microdatos.class.php:163 (getProducts) /modules/adpmicrodatos/adpmicrodatos.php:832 (getListadosProductosFromCategory) /modules/adpmicrodatos/adpmicrodatos.php:714 (hook) /classes/Hook.php:1043 (hookAdpMicrodatosHook) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:418 (coreCallHook) /classes/Hook.php:981 (callHookOn) /config/smarty.config.inc.php:198 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/prod/smarty/compile/classic_style_fashionlayouts_layout_left_column_tpl/17/df/bb/17dfbb8581c6c6a12d7607fb69e892d032ee9291_2.file.layout-both-columns.tpl.php:118 (__call) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6800249180a5e2_20613121) /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:115 (_subTemplateRender) /var/cache/prod/smarty/compile/classic_style_fashionlayouts_layout_left_column_tpl/65/f4/7d/65f47d36b8a8414a1523606db7ea19c8ca3dfe52_2.file.layout-left-column.tpl.php:38 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_680024917f7302_51127189) /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:115 (_subTemplateRender) /var/cache/prod/smarty/compile/classic_style_fashionlayouts_layout_left_column_tpl/01/c8/49/01c849af9a7ab6dcfdfbbb03597572a51f2c3fc0_2.file.product-list.tpl.php:35 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_680024917a91f1_03691258) /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:115 (_subTemplateRender) /var/cache/prod/smarty/compile/classic_style_fashionlayouts_layout_left_column_tpl/0a/55/dd/0a55dd745037efad9dd813c5cb67beeea3a44e56_2.file.category.tpl.php:32 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_680024917959d0_75817348) /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:753 (fetch) /classes/controller/FrontController.php:735 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
69	SELECT SQL_NO_CACHE `id_hook`, `name` FROM `jk_hook` UNION SELECT `id_hook`, ha.`alias` as name FROM `jk_hook_alias` ha INNER JOIN `jk_hook` h ON ha.name = h.name	6.273 ms	0			/classes/Hook.php:1292 /classes/Hook.php:225 (getAllHookIds) /classes/Hook.php:506 (getIdByName) /classes/module/Module.php:2147 (isModuleRegisteredOnHook) /modules/opartdevis/opartdevis.php:50 (isRegisteredInHook) :undefined (__construct) /src/Core/Foundation/IoC/Container.php:123 (newInstance) /src/Core/Foundation/IoC/Container.php:153 (makeInstanceFromClassName) /src/Core/Foundation/IoC/Container.php:166 (doMake) /src/Adapter/ServiceLocator.php:70 (make) /classes/module/Module.php:1235 (get) /tools/profiling/Module.php:35 (coreLoadModule) /classes/module/Module.php:1214 (coreLoadModule) /classes/Hook.php:966 (getInstanceByName) /classes/controller/FrontController.php:615 (exec) /controllers/front/listing/CategoryController.php:127 (initContent) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
100	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 jk_product p LEFT JOIN jk_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN jk_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN jk_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 jk_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN jk_category_product cp ON (p.id_product = cp.id_product) INNER JOIN jk_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN jk_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN jk_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN jk_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN jk_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN jk_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((fp.id_feature_value=74122)) AND ((fp_1.id_feature_value IN (74011, 74010, 74008))) AND ((fp_2.id_feature_value IN (74127, 74139, 74052, 74143, 74054))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=20 AND c.nright<=27 GROUP BY p.id_product) p INNER JOIN jk_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN jk_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN jk_feature_product fp_2 ON (p.id_product = fp_2.id_product) LEFT JOIN jk_feature_product fp_3 ON (p.id_product = fp_3.id_product) WHERE ((fp.id_feature=65)) AND ((fp_1.id_feature_value=74122)) AND ((fp_2.id_feature_value IN (74011, 74010, 74008))) AND ((fp_3.id_feature_value IN (74127, 74139, 74052, 74143, 74054))) GROUP BY fp.id_feature_value	6.173 ms	1788480	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:86 /modules/ps_facetedsearch/src/Adapter/MySQL.php:786 (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:356 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:134 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
88	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 jk_product p LEFT JOIN jk_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN jk_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN jk_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 jk_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN jk_category_product cp ON (p.id_product = cp.id_product) INNER JOIN jk_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN jk_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN jk_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN jk_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN jk_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN jk_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((fp.id_feature_value=74122)) AND ((fp_1.id_feature_value IN (74011, 74010, 74008))) AND ((fp_2.id_feature_value IN (74127, 74139, 74052, 74143, 74054))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=20 AND c.nright<=27 GROUP BY p.id_product) p INNER JOIN jk_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN jk_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN jk_feature_product fp_2 ON (p.id_product = fp_2.id_product) LEFT JOIN jk_feature_product fp_3 ON (p.id_product = fp_3.id_product) WHERE ((fp.id_feature=88)) AND ((fp_1.id_feature_value=74122)) AND ((fp_2.id_feature_value IN (74011, 74010, 74008))) AND ((fp_3.id_feature_value IN (74127, 74139, 74052, 74143, 74054))) GROUP BY fp.id_feature_value	5.884 ms	1788480	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:86 /modules/ps_facetedsearch/src/Adapter/MySQL.php:786 (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:356 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:134 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
541	SELECT SQL_NO_CACHE COUNT(*) FROM `jk_pack` WHERE id_product_pack = 1766 LIMIT 1	5.882 ms	1			/classes/Pack.php:89 /classes/Product.php:4338 (isPack) /classes/Product.php:5785 (getQuantity) /classes/Product.php:5976 (getProductProperties) /classes/Category.php:1074 (getProductsProperties) /modules/adpmicrodatos/classes/adpmicrodatos.microdatos.class.php:163 (getProducts) /modules/adpmicrodatos/adpmicrodatos.php:832 (getListadosProductosFromCategory) /modules/adpmicrodatos/adpmicrodatos.php:714 (hook) /classes/Hook.php:1043 (hookAdpMicrodatosHook) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:418 (coreCallHook) /classes/Hook.php:981 (callHookOn) /config/smarty.config.inc.php:198 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/prod/smarty/compile/classic_style_fashionlayouts_layout_left_column_tpl/17/df/bb/17dfbb8581c6c6a12d7607fb69e892d032ee9291_2.file.layout-both-columns.tpl.php:118 (__call) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6800249180a5e2_20613121) /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:115 (_subTemplateRender) /var/cache/prod/smarty/compile/classic_style_fashionlayouts_layout_left_column_tpl/65/f4/7d/65f47d36b8a8414a1523606db7ea19c8ca3dfe52_2.file.layout-left-column.tpl.php:38 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_680024917f7302_51127189) /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:115 (_subTemplateRender) /var/cache/prod/smarty/compile/classic_style_fashionlayouts_layout_left_column_tpl/01/c8/49/01c849af9a7ab6dcfdfbbb03597572a51f2c3fc0_2.file.product-list.tpl.php:35 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_680024917a91f1_03691258) /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:115 (_subTemplateRender) /var/cache/prod/smarty/compile/classic_style_fashionlayouts_layout_left_column_tpl/0a/55/dd/0a55dd745037efad9dd813c5cb67beeea3a44e56_2.file.category.tpl.php:32 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_680024917959d0_75817348) /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:753 (fetch) /classes/controller/FrontController.php:735 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
96	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 jk_product p LEFT JOIN jk_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN jk_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN jk_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 jk_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN jk_category_product cp ON (p.id_product = cp.id_product) INNER JOIN jk_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN jk_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN jk_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN jk_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN jk_feature_product fp_1 ON (p.id_product = fp_1.id_product) WHERE ((fp.id_feature_value=74122)) AND ((fp_1.id_feature_value IN (74127, 74139, 74052, 74143, 74054))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=20 AND c.nright<=27 GROUP BY p.id_product) p INNER JOIN jk_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN jk_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN jk_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((fp.id_feature=177)) AND ((fp_1.id_feature_value=74122)) AND ((fp_2.id_feature_value IN (74127, 74139, 74052, 74143, 74054))) GROUP BY fp.id_feature_value	5.439 ms	49680	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:86 /modules/ps_facetedsearch/src/Adapter/MySQL.php:786 (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:356 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:134 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
690	SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, pa.`reference`, pa.`ean13`, pa.`isbn`, pa.`upc`, pa.`mpn`, pal.`available_now`, pal.`available_later` FROM `jk_attribute` a LEFT JOIN `jk_attribute_lang` al ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 1) LEFT JOIN `jk_product_attribute_combination` pac ON (pac.`id_attribute` = a.`id_attribute`) LEFT JOIN `jk_product_attribute` pa ON (pa.`id_product_attribute` = pac.`id_product_attribute`) INNER JOIN jk_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) LEFT JOIN `jk_product_attribute_lang` pal ON (pal.`id_product_attribute` = pac.`id_product_attribute` AND pal.`id_lang` = 1) LEFT JOIN `jk_attribute_group_lang` agl ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1) WHERE pa.`id_product` = 1124 AND pac.`id_product_attribute` = 6740 AND agl.`id_lang` = 1	5.431 ms	1			/classes/Product.php:7502 /classes/Product.php:5843 (getAttributesParams) /classes/Product.php:5976 (getProductProperties) /classes/Category.php:1074 (getProductsProperties) /modules/adpmicrodatos/classes/adpmicrodatos.microdatos.class.php:163 (getProducts) /modules/adpmicrodatos/adpmicrodatos.php:832 (getListadosProductosFromCategory) /modules/adpmicrodatos/adpmicrodatos.php:714 (hook) /classes/Hook.php:1043 (hookAdpMicrodatosHook) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:418 (coreCallHook) /classes/Hook.php:981 (callHookOn) /config/smarty.config.inc.php:198 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/prod/smarty/compile/classic_style_fashionlayouts_layout_left_column_tpl/17/df/bb/17dfbb8581c6c6a12d7607fb69e892d032ee9291_2.file.layout-both-columns.tpl.php:118 (__call) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6800249180a5e2_20613121) /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:115 (_subTemplateRender) /var/cache/prod/smarty/compile/classic_style_fashionlayouts_layout_left_column_tpl/65/f4/7d/65f47d36b8a8414a1523606db7ea19c8ca3dfe52_2.file.layout-left-column.tpl.php:38 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_680024917f7302_51127189) /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:115 (_subTemplateRender) /var/cache/prod/smarty/compile/classic_style_fashionlayouts_layout_left_column_tpl/01/c8/49/01c849af9a7ab6dcfdfbbb03597572a51f2c3fc0_2.file.product-list.tpl.php:35 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_680024917a91f1_03691258) /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:115 (_subTemplateRender) /var/cache/prod/smarty/compile/classic_style_fashionlayouts_layout_left_column_tpl/0a/55/dd/0a55dd745037efad9dd813c5cb67beeea3a44e56_2.file.category.tpl.php:32 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_680024917959d0_75817348) /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:753 (fetch) /classes/controller/FrontController.php:735 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
98	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 jk_product p LEFT JOIN jk_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN jk_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN jk_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 jk_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN jk_category_product cp ON (p.id_product = cp.id_product) INNER JOIN jk_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN jk_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN jk_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN jk_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN jk_feature_product fp_1 ON (p.id_product = fp_1.id_product) WHERE ((fp.id_feature_value=74122)) AND ((fp_1.id_feature_value IN (74011, 74010, 74008))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=20 AND c.nright<=27 GROUP BY p.id_product) p INNER JOIN jk_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN jk_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN jk_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((fp.id_feature=186)) AND ((fp_1.id_feature_value=74122)) AND ((fp_2.id_feature_value IN (74011, 74010, 74008))) GROUP BY fp.id_feature_value	5.268 ms	49680	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:86 /modules/ps_facetedsearch/src/Adapter/MySQL.php:786 (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:356 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:134 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
102	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 jk_product p LEFT JOIN jk_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN jk_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN jk_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 jk_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN jk_category_product cp ON (p.id_product = cp.id_product) INNER JOIN jk_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN jk_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN jk_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN jk_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN jk_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN jk_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((fp.id_feature_value=74122)) AND ((fp_1.id_feature_value IN (74011, 74010, 74008))) AND ((fp_2.id_feature_value IN (74127, 74139, 74052, 74143, 74054))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=20 AND c.nright<=27 GROUP BY p.id_product) p INNER JOIN jk_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN jk_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN jk_feature_product fp_2 ON (p.id_product = fp_2.id_product) LEFT JOIN jk_feature_product fp_3 ON (p.id_product = fp_3.id_product) WHERE ((fp.id_feature=182)) AND ((fp_1.id_feature_value=74122)) AND ((fp_2.id_feature_value IN (74011, 74010, 74008))) AND ((fp_3.id_feature_value IN (74127, 74139, 74052, 74143, 74054))) GROUP BY fp.id_feature_value	5.188 ms	1788480	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:86 /modules/ps_facetedsearch/src/Adapter/MySQL.php:786 (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:356 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:134 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
83	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 jk_product p LEFT JOIN jk_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN jk_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN jk_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 jk_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN jk_category_product cp ON (p.id_product = cp.id_product) INNER JOIN jk_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN jk_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN jk_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN jk_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN jk_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN jk_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((fp.id_feature_value=74122)) AND ((fp_1.id_feature_value IN (74011, 74010, 74008))) AND ((fp_2.id_feature_value IN (74127, 74139, 74052, 74143, 74054))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=20 AND c.nright<=27 GROUP BY p.id_product) p INNER JOIN jk_category_product cp ON (p.id_product = cp.id_product) GROUP BY p.id_product ORDER BY p.position ASC, p.id_product DESC LIMIT 0, 36	5.124 ms	8280	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:86 /modules/ps_facetedsearch/src/Filters/Products.php:90 (execute) /modules/ps_facetedsearch/src/Product/SearchProvider.php:186 (getProductByFilters) /classes/controller/ProductListingFrontController.php:356 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:134 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
105	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 jk_product p LEFT JOIN jk_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN jk_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN jk_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 jk_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN jk_category_product cp ON (p.id_product = cp.id_product) INNER JOIN jk_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN jk_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN jk_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN jk_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN jk_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN jk_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((fp.id_feature_value=74122)) AND ((fp_1.id_feature_value IN (74011, 74010, 74008))) AND ((fp_2.id_feature_value IN (74127, 74139, 74052, 74143, 74054))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=20 AND c.nright<=27 GROUP BY p.id_product) p INNER JOIN jk_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN jk_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN jk_feature_product fp_2 ON (p.id_product = fp_2.id_product) LEFT JOIN jk_feature_product fp_3 ON (p.id_product = fp_3.id_product) WHERE ((fp.id_feature=183)) AND ((fp_1.id_feature_value=74122)) AND ((fp_2.id_feature_value IN (74011, 74010, 74008))) AND ((fp_3.id_feature_value IN (74127, 74139, 74052, 74143, 74054))) GROUP BY fp.id_feature_value	4.887 ms	1788480	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:86 /modules/ps_facetedsearch/src/Adapter/MySQL.php:786 (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:356 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:134 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
93	SELECT SQL_NO_CACHE MIN(p.weight) as min, MAX(p.weight) as max FROM jk_product p INNER JOIN jk_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN jk_category_product cp ON (p.id_product = cp.id_product) INNER JOIN jk_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN jk_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN jk_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN jk_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN jk_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((fp.id_feature_value=74122)) AND ((fp_1.id_feature_value IN (74011, 74010, 74008))) AND ((fp_2.id_feature_value IN (74127, 74139, 74052, 74143, 74054))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=20 AND c.nright<=27	4.770 ms	828			/modules/ps_facetedsearch/src/Adapter/MySQL.php:86 /modules/ps_facetedsearch/src/Adapter/MySQL.php:751 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:339 (getMinMaxValue) /modules/ps_facetedsearch/src/Filters/Block.php:134 (getWeightRangeBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:356 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:134 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
594	SELECT SQL_NO_CACHE name FROM jk_category_lang WHERE id_shop = 1 AND id_lang = 1 AND id_category = 30 LIMIT 1	4.737 ms	1			/classes/Product.php:5647 /classes/Product.php:5976 (getProductProperties) /classes/Category.php:1074 (getProductsProperties) /modules/adpmicrodatos/classes/adpmicrodatos.microdatos.class.php:163 (getProducts) /modules/adpmicrodatos/adpmicrodatos.php:832 (getListadosProductosFromCategory) /modules/adpmicrodatos/adpmicrodatos.php:714 (hook) /classes/Hook.php:1043 (hookAdpMicrodatosHook) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:418 (coreCallHook) /classes/Hook.php:981 (callHookOn) /config/smarty.config.inc.php:198 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/prod/smarty/compile/classic_style_fashionlayouts_layout_left_column_tpl/17/df/bb/17dfbb8581c6c6a12d7607fb69e892d032ee9291_2.file.layout-both-columns.tpl.php:118 (__call) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6800249180a5e2_20613121) /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:115 (_subTemplateRender) /var/cache/prod/smarty/compile/classic_style_fashionlayouts_layout_left_column_tpl/65/f4/7d/65f47d36b8a8414a1523606db7ea19c8ca3dfe52_2.file.layout-left-column.tpl.php:38 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_680024917f7302_51127189) /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:115 (_subTemplateRender) /var/cache/prod/smarty/compile/classic_style_fashionlayouts_layout_left_column_tpl/01/c8/49/01c849af9a7ab6dcfdfbbb03597572a51f2c3fc0_2.file.product-list.tpl.php:35 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_680024917a91f1_03691258) /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:115 (_subTemplateRender) /var/cache/prod/smarty/compile/classic_style_fashionlayouts_layout_left_column_tpl/0a/55/dd/0a55dd745037efad9dd813c5cb67beeea3a44e56_2.file.category.tpl.php:32 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_680024917959d0_75817348) /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:753 (fetch) /classes/controller/FrontController.php:735 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
74	DESCRIBE jk_ybc_blog_post	4.384 ms	1			/modules/ybc_blog/ybc_blog_defines.php:3158 /modules/ybc_blog/ybc_blog.php:1386 (checkCreatedColumn) /classes/Hook.php:1043 (hookDisplayHeader) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:418 (coreCallHook) /classes/Hook.php:981 (callHookOn) /classes/controller/FrontController.php:615 (exec) /controllers/front/listing/CategoryController.php:127 (initContent) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
107	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 jk_product p LEFT JOIN jk_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN jk_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN jk_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 jk_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN jk_category_product cp ON (p.id_product = cp.id_product) INNER JOIN jk_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN jk_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN jk_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN jk_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN jk_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN jk_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((fp.id_feature_value=74122)) AND ((fp_1.id_feature_value IN (74011, 74010, 74008))) AND ((fp_2.id_feature_value IN (74127, 74139, 74052, 74143, 74054))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=20 AND c.nright<=27 GROUP BY p.id_product) p INNER JOIN jk_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN jk_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN jk_feature_product fp_2 ON (p.id_product = fp_2.id_product) LEFT JOIN jk_feature_product fp_3 ON (p.id_product = fp_3.id_product) WHERE ((fp.id_feature=85)) AND ((fp_1.id_feature_value=74122)) AND ((fp_2.id_feature_value IN (74011, 74010, 74008))) AND ((fp_3.id_feature_value IN (74127, 74139, 74052, 74143, 74054))) GROUP BY fp.id_feature_value	4.290 ms	1788480	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:86 /modules/ps_facetedsearch/src/Adapter/MySQL.php:786 (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:356 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:134 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
276	SELECT SQL_NO_CACHE p., product_shop., stock.out_of_stock, IFNULL(stock.quantity, 0) AS quantity, IFNULL(product_attribute_shop.id_product_attribute, 0) AS id_product_attribute, product_attribute_shop.minimal_quantity AS product_attribute_minimal_quantity, pl.`description`, pl.`description_short`, pl.`available_now`, pl.`available_later`, pl.`link_rewrite`, pl.`meta_description`, pl.`meta_keywords`, pl.`meta_title`, pl.`name`, image_shop.`id_image` id_image, il.`legend` as legend, m.`name` AS manufacturer_name, cl.`name` AS category_default, DATEDIFF(product_shop.`date_add`, DATE_SUB("2025-04-17 00:00:00", INTERVAL 20 DAY)) > 0 AS new, product_shop.price AS orderprice FROM `jk_category_product` cp LEFT JOIN `jk_product` p ON p.`id_product` = cp.`id_product` INNER JOIN jk_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) LEFT JOIN `jk_product_attribute_shop` product_attribute_shop ON (p.`id_product` = product_attribute_shop.`id_product` AND product_attribute_shop.`default_on` = 1 AND product_attribute_shop.id_shop=1) LEFT JOIN jk_stock_available stock ON (stock.id_product = `p`.id_product AND stock.id_product_attribute = 0 AND stock.id_shop = 1 AND stock.id_shop_group = 0 ) LEFT JOIN `jk_category_lang` cl ON (product_shop.`id_category_default` = cl.`id_category` AND cl.`id_lang` = 1 AND cl.id_shop = 1 ) LEFT JOIN `jk_product_lang` pl ON (p.`id_product` = pl.`id_product` AND pl.`id_lang` = 1 AND pl.id_shop = 1 ) LEFT JOIN `jk_image_shop` image_shop ON (image_shop.`id_product` = p.`id_product` AND image_shop.cover=1 AND image_shop.id_shop=1) LEFT JOIN `jk_image_lang` il ON (image_shop.`id_image` = il.`id_image` AND il.`id_lang` = 1) LEFT JOIN `jk_manufacturer` m ON m.`id_manufacturer` = p.`id_manufacturer` WHERE product_shop.`id_shop` = 1 AND cp.`id_category` = 158 AND product_shop.`active` = 1 AND product_shop.`visibility` IN ("both", "catalog") ORDER BY cp.`position` ASC LIMIT 0,36	4.263 ms	55			/classes/Category.php:1062 /modules/adpmicrodatos/classes/adpmicrodatos.microdatos.class.php:163 (getProducts) /modules/adpmicrodatos/adpmicrodatos.php:832 (getListadosProductosFromCategory) /modules/adpmicrodatos/adpmicrodatos.php:714 (hook) /classes/Hook.php:1043 (hookAdpMicrodatosHook) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:418 (coreCallHook) /classes/Hook.php:981 (callHookOn) /config/smarty.config.inc.php:198 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/prod/smarty/compile/classic_style_fashionlayouts_layout_left_column_tpl/17/df/bb/17dfbb8581c6c6a12d7607fb69e892d032ee9291_2.file.layout-both-columns.tpl.php:118 (__call) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6800249180a5e2_20613121) /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:115 (_subTemplateRender) /var/cache/prod/smarty/compile/classic_style_fashionlayouts_layout_left_column_tpl/65/f4/7d/65f47d36b8a8414a1523606db7ea19c8ca3dfe52_2.file.layout-left-column.tpl.php:38 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_680024917f7302_51127189) /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:115 (_subTemplateRender) /var/cache/prod/smarty/compile/classic_style_fashionlayouts_layout_left_column_tpl/01/c8/49/01c849af9a7ab6dcfdfbbb03597572a51f2c3fc0_2.file.product-list.tpl.php:35 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_680024917a91f1_03691258) /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:115 (_subTemplateRender) /var/cache/prod/smarty/compile/classic_style_fashionlayouts_layout_left_column_tpl/0a/55/dd/0a55dd745037efad9dd813c5cb67beeea3a44e56_2.file.category.tpl.php:32 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_680024917959d0_75817348) /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:753 (fetch) /classes/controller/FrontController.php:735 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
78	SELECT SQL_NO_CACHE v., vl., IF(lifvlv.`url_name` IS NULL OR lifvlv.`url_name` = "", NULL, lifvlv.`url_name`) AS url_name, IF(lifvlv.`meta_title` IS NULL OR lifvlv.`meta_title` = "", NULL, lifvlv.`meta_title`) AS meta_title FROM `jk_feature_value` v LEFT JOIN `jk_feature_value_lang` vl ON (v.`id_feature_value` = vl.`id_feature_value` AND vl.`id_lang` = 1) LEFT JOIN `jk_layered_indexable_feature_value_lang_value` lifvlv ON (v.`id_feature_value` = lifvlv.`id_feature_value` AND lifvlv.`id_lang` = 1) WHERE v.`id_feature` = 90 ORDER BY vl.`value` ASC	4.124 ms	31	Yes		/modules/ps_facetedsearch/src/Filters/DataAccessor.php:194 /modules/ps_facetedsearch/src/Filters/Converter.php:402 (getFeatureValues) /modules/ps_facetedsearch/src/Product/SearchProvider.php:163 (createFacetedSearchFiltersFromQuery) /classes/controller/ProductListingFrontController.php:356 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:134 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
104	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 jk_product p LEFT JOIN jk_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN jk_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN jk_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 jk_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN jk_category_product cp ON (p.id_product = cp.id_product) INNER JOIN jk_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN jk_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN jk_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN jk_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN jk_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN jk_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((fp.id_feature_value=74122)) AND ((fp_1.id_feature_value IN (74011, 74010, 74008))) AND ((fp_2.id_feature_value IN (74127, 74139, 74052, 74143, 74054))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=20 AND c.nright<=27 GROUP BY p.id_product) p INNER JOIN jk_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN jk_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN jk_feature_product fp_2 ON (p.id_product = fp_2.id_product) LEFT JOIN jk_feature_product fp_3 ON (p.id_product = fp_3.id_product) WHERE ((fp.id_feature=191)) AND ((fp_1.id_feature_value=74122)) AND ((fp_2.id_feature_value IN (74011, 74010, 74008))) AND ((fp_3.id_feature_value IN (74127, 74139, 74052, 74143, 74054))) GROUP BY fp.id_feature_value	4.111 ms	1788480	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:86 /modules/ps_facetedsearch/src/Adapter/MySQL.php:786 (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:356 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:134 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
103	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 jk_product p LEFT JOIN jk_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN jk_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN jk_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 jk_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN jk_category_product cp ON (p.id_product = cp.id_product) INNER JOIN jk_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN jk_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN jk_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN jk_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN jk_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN jk_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((fp.id_feature_value=74122)) AND ((fp_1.id_feature_value IN (74011, 74010, 74008))) AND ((fp_2.id_feature_value IN (74127, 74139, 74052, 74143, 74054))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=20 AND c.nright<=27 GROUP BY p.id_product) p INNER JOIN jk_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN jk_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN jk_feature_product fp_2 ON (p.id_product = fp_2.id_product) LEFT JOIN jk_feature_product fp_3 ON (p.id_product = fp_3.id_product) WHERE ((fp.id_feature=184)) AND ((fp_1.id_feature_value=74122)) AND ((fp_2.id_feature_value IN (74011, 74010, 74008))) AND ((fp_3.id_feature_value IN (74127, 74139, 74052, 74143, 74054))) GROUP BY fp.id_feature_value	4.098 ms	1788480	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:86 /modules/ps_facetedsearch/src/Adapter/MySQL.php:786 (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:356 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:134 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
84	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 jk_product p LEFT JOIN jk_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN jk_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN jk_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 jk_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN jk_category_product cp ON (p.id_product = cp.id_product) INNER JOIN jk_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN jk_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN jk_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN jk_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN jk_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN jk_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((fp.id_feature_value=74122)) AND ((fp_1.id_feature_value IN (74011, 74010, 74008))) AND ((fp_2.id_feature_value IN (74127, 74139, 74052, 74143, 74054))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=20 AND c.nright<=27 GROUP BY p.id_product) p LEFT JOIN jk_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN jk_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN jk_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((fp.id_feature_value=74122)) AND ((fp_1.id_feature_value IN (74011, 74010, 74008))) AND ((fp_2.id_feature_value IN (74127, 74139, 74052, 74143, 74054)))	4.033 ms	1788480			/modules/ps_facetedsearch/src/Adapter/MySQL.php:86 /modules/ps_facetedsearch/src/Adapter/MySQL.php:786 (execute) /modules/ps_facetedsearch/src/Adapter/MySQL.php:764 (valueCount) /modules/ps_facetedsearch/src/Filters/Products.php:94 (count) /modules/ps_facetedsearch/src/Product/SearchProvider.php:186 (getProductByFilters) /classes/controller/ProductListingFrontController.php:356 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:134 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
14	SELECT SQL_NO_CACHE h.`name` as hook, m.`id_module`, h.`id_hook`, m.`name` as module FROM `jk_module` m INNER JOIN jk_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 `jk_hook_module` `hm` ON hm.`id_module` = m.`id_module` INNER JOIN `jk_hook` `h` ON hm.`id_hook` = h.`id_hook` LEFT JOIN `jk_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.778 ms	1204	Yes	Yes	/classes/Hook.php:1233 /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)
730	SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`, IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on, product_attribute_shop.`ecotax` AS attribute_ecotax FROM `jk_product` p INNER JOIN `jk_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1) LEFT JOIN `jk_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1) WHERE (p.`id_product` = 1109)	3.762 ms	7			/classes/Product.php:3860 /classes/Product.php:3716 (priceCalculation) /classes/Product.php:5679 (getPriceStatic) /classes/Product.php:5976 (getProductProperties) /classes/Category.php:1074 (getProductsProperties) /modules/adpmicrodatos/classes/adpmicrodatos.microdatos.class.php:163 (getProducts) /modules/adpmicrodatos/adpmicrodatos.php:832 (getListadosProductosFromCategory) /modules/adpmicrodatos/adpmicrodatos.php:714 (hook) /classes/Hook.php:1043 (hookAdpMicrodatosHook) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:418 (coreCallHook) /classes/Hook.php:981 (callHookOn) /config/smarty.config.inc.php:198 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/prod/smarty/compile/classic_style_fashionlayouts_layout_left_column_tpl/17/df/bb/17dfbb8581c6c6a12d7607fb69e892d032ee9291_2.file.layout-both-columns.tpl.php:118 (__call) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6800249180a5e2_20613121) /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:115 (_subTemplateRender) /var/cache/prod/smarty/compile/classic_style_fashionlayouts_layout_left_column_tpl/65/f4/7d/65f47d36b8a8414a1523606db7ea19c8ca3dfe52_2.file.layout-left-column.tpl.php:38 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_680024917f7302_51127189) /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:115 (_subTemplateRender) /var/cache/prod/smarty/compile/classic_style_fashionlayouts_layout_left_column_tpl/01/c8/49/01c849af9a7ab6dcfdfbbb03597572a51f2c3fc0_2.file.product-list.tpl.php:35 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_680024917a91f1_03691258) /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:115 (_subTemplateRender) /var/cache/prod/smarty/compile/classic_style_fashionlayouts_layout_left_column_tpl/0a/55/dd/0a55dd745037efad9dd813c5cb67beeea3a44e56_2.file.category.tpl.php:32 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_680024917959d0_75817348) /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:753 (fetch) /classes/controller/FrontController.php:735 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
34	SELECT SQL_NO_CACHE * FROM `jk_group` a LEFT JOIN `jk_group_shop` `c` ON a.`id_group` = c.`id_group` AND c.`id_shop` = 1 WHERE (a.`id_group` = 1) LIMIT 1	3.567 ms	1			/src/Adapter/EntityMapper.php:71 /classes/ObjectModel.php:283 (load) /tools/profiling/ObjectModel.php:32 (__construct) /classes/Group.php:81 (__construct) /classes/Group.php:397 (__construct) /classes/Cart.php:249 (getCurrent) /classes/Cart.php:222 (setTaxCalculationMethod) /classes/controller/FrontController.php:465 (__construct) /controllers/front/listing/CategoryController.php:81 (init) /tools/profiling/Controller.php:41 (init) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
101	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 jk_product p LEFT JOIN jk_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN jk_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN jk_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 jk_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN jk_category_product cp ON (p.id_product = cp.id_product) INNER JOIN jk_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN jk_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN jk_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN jk_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN jk_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN jk_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((fp.id_feature_value=74122)) AND ((fp_1.id_feature_value IN (74011, 74010, 74008))) AND ((fp_2.id_feature_value IN (74127, 74139, 74052, 74143, 74054))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=20 AND c.nright<=27 GROUP BY p.id_product) p INNER JOIN jk_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN jk_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN jk_feature_product fp_2 ON (p.id_product = fp_2.id_product) LEFT JOIN jk_feature_product fp_3 ON (p.id_product = fp_3.id_product) WHERE ((fp.id_feature=181)) AND ((fp_1.id_feature_value=74122)) AND ((fp_2.id_feature_value IN (74011, 74010, 74008))) AND ((fp_3.id_feature_value IN (74127, 74139, 74052, 74143, 74054))) GROUP BY fp.id_feature_value	3.547 ms	1788480	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:86 /modules/ps_facetedsearch/src/Adapter/MySQL.php:786 (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:356 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:134 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
169	SELECT SQL_NO_CACHE atp., atpl., cl.link_rewrite, cl.meta_title, cal.link_rewrite as category_link_rewrite, cal.name as category_name, m.name as manufacturer_name, s.name as supplier_name, ccl.name as cms_category_name FROM `jk_pm_advancedtopmenu` atp LEFT JOIN `jk_pm_advancedtopmenu_lang` atpl ON (atp.`id_menu` = atpl.`id_menu` AND atpl.`id_lang` = 1) LEFT JOIN jk_cms c ON (c.id_cms = atp.`id_cms`) LEFT JOIN jk_cms_shop cms_shop ON (cms_shop.id_cms = c.id_cms AND cms_shop.id_shop = 1 AND 1) LEFT JOIN jk_cms_lang cl ON (c.id_cms = cl.id_cms AND cl.id_lang = 1) LEFT JOIN jk_cms_category cc ON (cc.id_cms_category = atp.`id_cms_category`) LEFT JOIN jk_cms_category_shop cms_category_shop ON (cms_category_shop.id_cms_category = cc.id_cms_category AND cms_category_shop.id_shop = 1 AND 1) LEFT JOIN jk_cms_category_lang ccl ON (cc.id_cms_category = ccl.id_cms_category AND ccl.id_lang = 1) LEFT JOIN jk_category ca ON (ca.id_category = atp.`id_category`) LEFT JOIN `jk_category_group` cg ON (cg.`id_category` = ca.`id_category`) LEFT JOIN jk_category_lang cal ON (ca.id_category = cal.id_category AND cal.id_lang = 1 AND cal.id_shop = 1 ) LEFT JOIN `jk_manufacturer` m ON (atp.`id_manufacturer` = m.`id_manufacturer`) LEFT JOIN jk_manufacturer_shop manufacturer_shop ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 1 AND 1) LEFT JOIN `jk_supplier` s ON (atp.`id_supplier` = s.`id_supplier`) LEFT JOIN jk_supplier_shop supplier_shop ON (supplier_shop.id_supplier = s.id_supplier AND supplier_shop.id_shop = 1 AND 1) WHERE atp.`active` = 1 AND (atp.`active_desktop` = 1 \|\| atp.`active_mobile` = 1) AND ((atp.`id_manufacturer` = 0 AND atp.`id_supplier` = 0 AND atp.`id_category` = 0 AND atp.`id_cms` = 0 AND atp.`id_cms_category` = 0) OR c.id_cms IS NOT NULL OR cc.id_cms_category IS NOT NULL OR m.id_manufacturer IS NOT NULL OR ca.id_category IS NOT NULL OR s.`id_supplier` IS NOT NULL) AND IF (atp.`id_category` IS NULL OR atp.`id_category` = 0, 1, cg.`id_group` IN (1)) GROUP BY atp.`id_menu` ORDER BY atp.`position`	3.470 ms	30	Yes	Yes	/modules/pm_advancedtopmenu/AdvancedTopMenuClass.php:323 /modules/pm_advancedtopmenu/pm_advancedtopmenu.php:5016 (getMenus) /modules/pm_advancedtopmenu/pm_advancedtopmenu.php:4997 (outputMenuContent) /classes/Hook.php:1043 (hookDisplayTop) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:418 (coreCallHook) /classes/Hook.php:981 (callHookOn) /config/smarty.config.inc.php:198 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/prod/smarty/compile/classic_style_fashionlayouts_layout_left_column_tpl/b2/2c/95/b22c95946bc3e7283d9cfc277d5b3ce1d0077d73_2.file.header.tpl.php:70 (__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/classic_style_fashionlayouts_layout_left_column_tpl/b2/2c/95/b22c95946bc3e7283d9cfc277d5b3ce1d0077d73_2.file.header.tpl.php:32 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_680024919573a3_71564441) /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/classic_style_fashionlayouts_layout_left_column_tpl/17/df/bb/17dfbb8581c6c6a12d7607fb69e892d032ee9291_2.file.layout-both-columns.tpl.php:190 (_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/classic_style_fashionlayouts_layout_left_column_tpl/17/df/bb/17dfbb8581c6c6a12d7607fb69e892d032ee9291_2.file.layout-both-columns.tpl.php:62 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6800249180a5e2_20613121) /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:115 (_subTemplateRender) /var/cache/prod/smarty/compile/classic_style_fashionlayouts_layout_left_column_tpl/65/f4/7d/65f47d36b8a8414a1523606db7ea19c8ca3dfe52_2.file.layout-left-column.tpl.php:38 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_680024917f7302_51127189) /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:115 (_subTemplateRender) /var/cache/prod/smarty/compile/classic_style_fashionlayouts_layout_left_column_tpl/01/c8/49/01c849af9a7ab6dcfdfbbb03597572a51f2c3fc0_2.file.product-list.tpl.php:35 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_680024917a91f1_03691258) /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:115 (_subTemplateRender) /var/cache/prod/smarty/compile/classic_style_fashionlayouts_layout_left_column_tpl/0a/55/dd/0a55dd745037efad9dd813c5cb67beeea3a44e56_2.file.category.tpl.php:32 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_680024917959d0_75817348) /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:753 (fetch) /classes/controller/FrontController.php:735 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
698	SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`, IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on, product_attribute_shop.`ecotax` AS attribute_ecotax FROM `jk_product` p INNER JOIN `jk_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1) LEFT JOIN `jk_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1) WHERE (p.`id_product` = 1125)	3.437 ms	7			/classes/Product.php:3860 /classes/Product.php:3716 (priceCalculation) /classes/Product.php:5679 (getPriceStatic) /classes/Product.php:5976 (getProductProperties) /classes/Category.php:1074 (getProductsProperties) /modules/adpmicrodatos/classes/adpmicrodatos.microdatos.class.php:163 (getProducts) /modules/adpmicrodatos/adpmicrodatos.php:832 (getListadosProductosFromCategory) /modules/adpmicrodatos/adpmicrodatos.php:714 (hook) /classes/Hook.php:1043 (hookAdpMicrodatosHook) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:418 (coreCallHook) /classes/Hook.php:981 (callHookOn) /config/smarty.config.inc.php:198 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/prod/smarty/compile/classic_style_fashionlayouts_layout_left_column_tpl/17/df/bb/17dfbb8581c6c6a12d7607fb69e892d032ee9291_2.file.layout-both-columns.tpl.php:118 (__call) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6800249180a5e2_20613121) /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:115 (_subTemplateRender) /var/cache/prod/smarty/compile/classic_style_fashionlayouts_layout_left_column_tpl/65/f4/7d/65f47d36b8a8414a1523606db7ea19c8ca3dfe52_2.file.layout-left-column.tpl.php:38 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_680024917f7302_51127189) /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:115 (_subTemplateRender) /var/cache/prod/smarty/compile/classic_style_fashionlayouts_layout_left_column_tpl/01/c8/49/01c849af9a7ab6dcfdfbbb03597572a51f2c3fc0_2.file.product-list.tpl.php:35 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_680024917a91f1_03691258) /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:115 (_subTemplateRender) /var/cache/prod/smarty/compile/classic_style_fashionlayouts_layout_left_column_tpl/0a/55/dd/0a55dd745037efad9dd813c5cb67beeea3a44e56_2.file.category.tpl.php:32 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_680024917959d0_75817348) /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:753 (fetch) /classes/controller/FrontController.php:735 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
47	SELECT SQL_NO_CACHE 1 FROM `jk_cart_rule` WHERE ((date_to >= "2025-04-17 00:00:00" AND date_to <= "2025-04-17 23:59:59") OR (date_from >= "2025-04-17 00:00:00" AND date_from <= "2025-04-17 23:59:59") OR (date_from < "2025-04-17 00:00:00" AND date_to > "2025-04-17 23:59:59")) AND `id_customer` IN (0,0) LIMIT 1	3.323 ms	63			/classes/CartRule.php:357 /classes/CartRule.php:389 (haveCartRuleToday) /classes/Cart.php:3014 (getCustomerCartRules) /classes/Cart.php:3405 (getDeliveryOptionList) /classes/Cart.php:3478 (getDeliveryOption) /src/Core/Cart/Fees.php:96 (getTotalShippingCost) /src/Core/Cart/Calculator.php:354 (processCalculation) /src/Core/Cart/Calculator.php:155 (calculateFees) /classes/Cart.php:2173 (processCalculation) /src/Adapter/Presenter/Cart/CartPresenter.php:334 (getOrderTotal) /classes/controller/FrontController.php:538 (present) /classes/controller/FrontController.php:607 (assignGeneralPurposeVariables) /controllers/front/listing/CategoryController.php:127 (initContent) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
108	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 jk_product p LEFT JOIN jk_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN jk_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN jk_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 jk_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN jk_category_product cp ON (p.id_product = cp.id_product) INNER JOIN jk_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN jk_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN jk_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN jk_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN jk_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN jk_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((fp.id_feature_value=74122)) AND ((fp_1.id_feature_value IN (74011, 74010, 74008))) AND ((fp_2.id_feature_value IN (74127, 74139, 74052, 74143, 74054))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=20 AND c.nright<=27 GROUP BY p.id_product) p INNER JOIN jk_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN jk_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN jk_feature_product fp_2 ON (p.id_product = fp_2.id_product) LEFT JOIN jk_feature_product fp_3 ON (p.id_product = fp_3.id_product) WHERE ((fp.id_feature=205)) AND ((fp_1.id_feature_value=74122)) AND ((fp_2.id_feature_value IN (74011, 74010, 74008))) AND ((fp_3.id_feature_value IN (74127, 74139, 74052, 74143, 74054))) GROUP BY fp.id_feature_value	3.166 ms	5365440	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:86 /modules/ps_facetedsearch/src/Adapter/MySQL.php:786 (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:356 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:134 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
618	SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`, IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on, product_attribute_shop.`ecotax` AS attribute_ecotax FROM `jk_product` p INNER JOIN `jk_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1) LEFT JOIN `jk_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1) WHERE (p.`id_product` = 1120)	3.123 ms	6			/classes/Product.php:3860 /classes/Product.php:3716 (priceCalculation) /classes/Product.php:5679 (getPriceStatic) /classes/Product.php:5976 (getProductProperties) /classes/Category.php:1074 (getProductsProperties) /modules/adpmicrodatos/classes/adpmicrodatos.microdatos.class.php:163 (getProducts) /modules/adpmicrodatos/adpmicrodatos.php:832 (getListadosProductosFromCategory) /modules/adpmicrodatos/adpmicrodatos.php:714 (hook) /classes/Hook.php:1043 (hookAdpMicrodatosHook) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:418 (coreCallHook) /classes/Hook.php:981 (callHookOn) /config/smarty.config.inc.php:198 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/prod/smarty/compile/classic_style_fashionlayouts_layout_left_column_tpl/17/df/bb/17dfbb8581c6c6a12d7607fb69e892d032ee9291_2.file.layout-both-columns.tpl.php:118 (__call) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6800249180a5e2_20613121) /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:115 (_subTemplateRender) /var/cache/prod/smarty/compile/classic_style_fashionlayouts_layout_left_column_tpl/65/f4/7d/65f47d36b8a8414a1523606db7ea19c8ca3dfe52_2.file.layout-left-column.tpl.php:38 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_680024917f7302_51127189) /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:115 (_subTemplateRender) /var/cache/prod/smarty/compile/classic_style_fashionlayouts_layout_left_column_tpl/01/c8/49/01c849af9a7ab6dcfdfbbb03597572a51f2c3fc0_2.file.product-list.tpl.php:35 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_680024917a91f1_03691258) /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:115 (_subTemplateRender) /var/cache/prod/smarty/compile/classic_style_fashionlayouts_layout_left_column_tpl/0a/55/dd/0a55dd745037efad9dd813c5cb67beeea3a44e56_2.file.category.tpl.php:32 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_680024917959d0_75817348) /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:753 (fetch) /classes/controller/FrontController.php:735 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
121	SELECT SQL_NO_CACHE tr.* FROM `jk_tax_rule` tr JOIN `jk_tax_rules_group` trg ON (tr.`id_tax_rules_group` = trg.`id_tax_rules_group`) WHERE trg.`active` = 1 AND tr.`id_country` = 8 AND tr.`id_tax_rules_group` = 1 AND tr.`id_state` IN (0, 0) 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	2.874 ms	1	Yes		/classes/tax/TaxRulesTaxManager.php:100 /classes/Product.php:3926 (getTaxCalculator) /classes/Product.php:3716 (priceCalculation) /classes/Product.php:5679 (getPriceStatic) /classes/ProductAssembler.php:206 (getProductProperties) /classes/controller/ProductListingFrontController.php:108 (assembleProducts) /classes/controller/ProductListingFrontController.php:378 (prepareMultipleProductsForTemplate) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:134 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
203	SELECT SQL_NO_CACHE ate., atel., cl.link_rewrite, cl.meta_title, cal.link_rewrite as category_link_rewrite, cal.name as category_name, m.name as manufacturer_name, s.name as supplier_name FROM `jk_pm_advancedtopmenu_elements` ate LEFT JOIN `jk_pm_advancedtopmenu_elements_lang` atel ON (ate.`id_element` = atel.`id_element` AND atel.`id_lang` = 1) LEFT JOIN jk_cms c ON (c.id_cms = ate.`id_cms`) LEFT JOIN jk_cms_shop cms_shop ON (cms_shop.id_cms = c.id_cms AND cms_shop.id_shop = 1) LEFT JOIN jk_cms_lang cl ON (c.id_cms = cl.id_cms AND cl.id_lang = 1) LEFT JOIN jk_cms_category cc ON (cc.id_cms_category = ate.`id_cms_category`) LEFT JOIN jk_cms_category_shop cms_category_shop ON (cms_category_shop.id_cms_category = cc.id_cms_category AND cms_category_shop.id_shop = 1) LEFT JOIN jk_cms_category_lang ccl ON (cc.id_cms_category = ccl.id_cms_category AND ccl.id_lang = 1) LEFT JOIN jk_category ca ON (ca.id_category = ate.`id_category`) LEFT JOIN `jk_category_group` cg ON (cg.`id_category` = ca.`id_category`) LEFT JOIN jk_category_lang cal ON (ca.id_category = cal.id_category AND cal.id_lang = 1 AND cal.id_shop = 1 ) LEFT JOIN `jk_manufacturer` m ON (ate.`id_manufacturer` = m.`id_manufacturer`) LEFT JOIN jk_manufacturer_shop manufacturer_shop ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 1) LEFT JOIN `jk_supplier` s ON (ate.`id_supplier` = s.`id_supplier`) LEFT JOIN jk_supplier_shop supplier_shop ON (supplier_shop.id_supplier = s.id_supplier AND supplier_shop.id_shop = 1) WHERE ate.`active` = 1 AND (ate.`active_desktop` = 1 \|\| ate.`active_mobile` = 1) AND ate.`id_column` = 191 AND ((ate.`id_manufacturer` = 0 AND ate.`id_supplier` = 0 AND ate.`id_category` = 0 AND ate.`id_cms` = 0 AND ate.`id_cms_category` = 0) OR c.id_cms IS NOT NULL OR cc.id_cms_category IS NOT NULL OR m.id_manufacturer IS NOT NULL OR ca.id_category IS NOT NULL OR s.`id_supplier` IS NOT NULL) AND (cms_shop.`id_shop` = 1 OR cms_shop.`id_shop` IS NULL) AND (manufacturer_shop.`id_shop` = 1 OR manufacturer_shop.`id_shop` IS NULL) AND (supplier_shop.`id_shop` = 1 OR supplier_shop.`id_shop` IS NULL)AND IF (ate.`id_category` IS NULL OR ate.`id_category` = 0, 1, cg.`id_group` IN (1)) GROUP BY ate.`id_element` ORDER BY ate.`position`	2.685 ms	3	Yes	Yes	/modules/pm_advancedtopmenu/AdvancedTopMenuElementsClass.php:210 /modules/pm_advancedtopmenu/AdvancedTopMenuElementsClass.php:219 (getMenuColumnElements) /modules/pm_advancedtopmenu/pm_advancedtopmenu.php:5023 (getMenuColumnsElements) /modules/pm_advancedtopmenu/pm_advancedtopmenu.php:4997 (outputMenuContent) /classes/Hook.php:1043 (hookDisplayTop) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:418 (coreCallHook) /classes/Hook.php:981 (callHookOn) /config/smarty.config.inc.php:198 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/prod/smarty/compile/classic_style_fashionlayouts_layout_left_column_tpl/b2/2c/95/b22c95946bc3e7283d9cfc277d5b3ce1d0077d73_2.file.header.tpl.php:70 (__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/classic_style_fashionlayouts_layout_left_column_tpl/b2/2c/95/b22c95946bc3e7283d9cfc277d5b3ce1d0077d73_2.file.header.tpl.php:32 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_680024919573a3_71564441) /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/classic_style_fashionlayouts_layout_left_column_tpl/17/df/bb/17dfbb8581c6c6a12d7607fb69e892d032ee9291_2.file.layout-both-columns.tpl.php:190 (_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/classic_style_fashionlayouts_layout_left_column_tpl/17/df/bb/17dfbb8581c6c6a12d7607fb69e892d032ee9291_2.file.layout-both-columns.tpl.php:62 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6800249180a5e2_20613121) /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:115 (_subTemplateRender) /var/cache/prod/smarty/compile/classic_style_fashionlayouts_layout_left_column_tpl/65/f4/7d/65f47d36b8a8414a1523606db7ea19c8ca3dfe52_2.file.layout-left-column.tpl.php:38 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_680024917f7302_51127189) /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:115 (_subTemplateRender) /var/cache/prod/smarty/compile/classic_style_fashionlayouts_layout_left_column_tpl/01/c8/49/01c849af9a7ab6dcfdfbbb03597572a51f2c3fc0_2.file.product-list.tpl.php:35 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_680024917a91f1_03691258) /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:115 (_subTemplateRender) /var/cache/prod/smarty/compile/classic_style_fashionlayouts_layout_left_column_tpl/0a/55/dd/0a55dd745037efad9dd813c5cb67beeea3a44e56_2.file.category.tpl.php:32 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_680024917959d0_75817348) /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:753 (fetch) /classes/controller/FrontController.php:735 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
29	SELECT SQL_NO_CACHE * FROM `jk_currency` a LEFT JOIN `jk_currency_lang` `b` ON a.`id_currency` = b.`id_currency` AND b.`id_lang` = 1 LEFT JOIN `jk_currency_shop` `c` ON a.`id_currency` = c.`id_currency` AND c.`id_shop` = 1 WHERE (a.`id_currency` = 1) LIMIT 1	2.572 ms	1			/src/Adapter/EntityMapper.php:71 /classes/ObjectModel.php:283 (load) /tools/profiling/ObjectModel.php:32 (__construct) /classes/Currency.php:246 (__construct) /src/Adapter/Currency/CurrencyDataProvider.php:101 (__construct) /src/Adapter/Currency/CurrencyDataProvider.php:114 (getCurrencyByIsoCode) /src/Core/Localization/Currency/DataLayer/CurrencyDatabase.php:102 (getCurrencyByIsoCodeAndLocale) /src/Core/Data/Layer/AbstractDataLayer.php:91 (doRead) /src/Core/Data/Layer/AbstractDataLayer.php:150 (read) /src/Core/Data/Layer/AbstractDataLayer.php:95 (propagateRead) /src/Core/Localization/Currency/CurrencyDataSource.php:67 (read) /src/Core/Localization/Currency/CurrencyDataSource.php:109 (getLocalizedCurrencyData) /src/Core/Localization/Currency/CurrencyDataSource.php:96 (formatCurrenciesData) /src/Core/Localization/Currency/Repository.php:87 (getAllInstalledCurrenciesData) /src/Core/Localization/Locale/Repository.php:207 (getAllInstalledCurrencies) /src/Core/Localization/Locale/Repository.php:150 (getPriceSpecifications) /classes/controller/Controller.php:208 (getLocale) /classes/controller/FrontController.php:284 (init) /controllers/front/listing/CategoryController.php:81 (init) /tools/profiling/Controller.php:41 (init) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
590	SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, pa.`reference`, pa.`ean13`, pa.`isbn`, pa.`upc`, pa.`mpn`, pal.`available_now`, pal.`available_later` FROM `jk_attribute` a LEFT JOIN `jk_attribute_lang` al ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 1) LEFT JOIN `jk_product_attribute_combination` pac ON (pac.`id_attribute` = a.`id_attribute`) LEFT JOIN `jk_product_attribute` pa ON (pa.`id_product_attribute` = pac.`id_product_attribute`) INNER JOIN jk_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) LEFT JOIN `jk_product_attribute_lang` pal ON (pal.`id_product_attribute` = pac.`id_product_attribute` AND pal.`id_lang` = 1) LEFT JOIN `jk_attribute_group_lang` agl ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1) WHERE pa.`id_product` = 1768 AND pac.`id_product_attribute` = 6737 AND agl.`id_lang` = 1	2.564 ms	1			/classes/Product.php:7502 /classes/Product.php:5843 (getAttributesParams) /classes/Product.php:5976 (getProductProperties) /classes/Category.php:1074 (getProductsProperties) /modules/adpmicrodatos/classes/adpmicrodatos.microdatos.class.php:163 (getProducts) /modules/adpmicrodatos/adpmicrodatos.php:832 (getListadosProductosFromCategory) /modules/adpmicrodatos/adpmicrodatos.php:714 (hook) /classes/Hook.php:1043 (hookAdpMicrodatosHook) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:418 (coreCallHook) /classes/Hook.php:981 (callHookOn) /config/smarty.config.inc.php:198 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/prod/smarty/compile/classic_style_fashionlayouts_layout_left_column_tpl/17/df/bb/17dfbb8581c6c6a12d7607fb69e892d032ee9291_2.file.layout-both-columns.tpl.php:118 (__call) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6800249180a5e2_20613121) /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:115 (_subTemplateRender) /var/cache/prod/smarty/compile/classic_style_fashionlayouts_layout_left_column_tpl/65/f4/7d/65f47d36b8a8414a1523606db7ea19c8ca3dfe52_2.file.layout-left-column.tpl.php:38 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_680024917f7302_51127189) /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:115 (_subTemplateRender) /var/cache/prod/smarty/compile/classic_style_fashionlayouts_layout_left_column_tpl/01/c8/49/01c849af9a7ab6dcfdfbbb03597572a51f2c3fc0_2.file.product-list.tpl.php:35 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_680024917a91f1_03691258) /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:115 (_subTemplateRender) /var/cache/prod/smarty/compile/classic_style_fashionlayouts_layout_left_column_tpl/0a/55/dd/0a55dd745037efad9dd813c5cb67beeea3a44e56_2.file.category.tpl.php:32 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_680024917959d0_75817348) /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:753 (fetch) /classes/controller/FrontController.php:735 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)

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