List of products by supplier Mollaian Tappeti Persiani

Mollaian Oriental Rugs Lecce

Sort by:

View

There is 1 product.

Sold - Out of stock - contact the company for info on similar products

Nain 9 line Persia 78x78

Sold - Out of stock - contact the company for info on similar products

Round carpet Nain 9 line extra fine Persia 78x78 White and Green and white silk

€0.00

Details View details

Load Time	703.110 ms
Querying Time	307 ms
Queries	390
Memory Peak Usage	12.5 Mb
Included Files	1305 files - 13.47 Mb
PrestaShop Cache	- Mb
Global vars	0.44 Mb
- global $_MODULES	430k
- global $_SERVER	7k
- global $config	5k
- global $context	4k
- global $__composer_autoload_files	3k
- global $exportPhpConfigFile	3k

PrestaShop Version	8.1.5
PHP Version	8.1.27
MySQL Version	10.6.16-MariaDB-cll-lve
Memory Limit	1024M
Max Execution Time	10000s
Smarty Cache	enabled
Smarty Compilation	auto

	Time	Cumulated Time	Memory Usage	Memory Peak Usage
config	37.843 ms	37.843 ms	2.76 Mb	3.2 Mb
__construct	0.021 ms	37.864 ms	- Mb	3.2 Mb
init	89.154 ms	127.018 ms	0.88 Mb	4.1 Mb
checkAccess	0.001 ms	127.019 ms	- Mb	4.1 Mb
setMedia	24.087 ms	151.106 ms	0.53 Mb	4.2 Mb
postProcess	0.002 ms	151.108 ms	- Mb	4.2 Mb
initHeader	0.001 ms	151.109 ms	- Mb	4.2 Mb
initContent	351.693 ms	502.802 ms	4.04 Mb	8.3 Mb
initFooter	0.002 ms	502.804 ms	- Mb	8.3 Mb
display	200.306 ms	703.110 ms	3.97 Mb	12.5 Mb

Hook	Time	Memory Usage
displayProductListReviews	42.700 ms	0.23 Mb
=> productcomments (widget)	42.700 ms	0.23 Mb
displayLeftColumn	28.599 ms	1.16 Mb
=> ps_categorytree (widget)	28.599 ms	1.16 Mb
DisplayHeader	15.259 ms	0.16 Mb
=> lgcookieslaw	0.055 ms	- Mb
=> ps_shoppingcart	0.092 ms	- Mb
=> ps_searchbar	0.827 ms	- Mb
=> productlabel	0.360 ms	- Mb
=> ps_feeder	2.002 ms	0.01 Mb
=> productcomments	0.388 ms	- Mb
=> whatsappchat	2.441 ms	0.06 Mb
=> zonemegamenu	0.175 ms	- Mb
=> zonethememanager	4.902 ms	0.04 Mb
=> emarketing	1.099 ms	- Mb
=> zonecolorsfonts	2.897 ms	0.03 Mb
=> ets_advancedcaptcha	0.021 ms	- Mb
DisplayProductPriceBlock	14.984 ms	0.41 Mb
=> productlabel	0.003 ms	- Mb
=> nexixpay	0.509 ms	- Mb
=> productlabel	0.003 ms	- Mb
=> nexixpay	0.097 ms	- Mb
=> productlabel	0.002 ms	- Mb
=> nexixpay	0.511 ms	- Mb
=> productlabel	13.782 ms	0.41 Mb
=> nexixpay	0.077 ms	- Mb
DisplayOutsideMainPage	9.937 ms	0.07 Mb
=> zonecolorsfonts	3.641 ms	0.03 Mb
=> zonethememanager	6.296 ms	0.03 Mb
DisplayBeforeBodyClosingTag	9.861 ms	0.16 Mb
=> lgcookieslaw	0.113 ms	- Mb
=> whatsappchat	9.748 ms	0.16 Mb
Header	8.908 ms	0.02 Mb
=> paypal	6.331 ms	0.01 Mb
=> registrationfields	1.769 ms	0.01 Mb
=> codegenerator	0.357 ms	- Mb
=> sendinblue	0.451 ms	- Mb
footer	8.306 ms	0.18 Mb
=> ps_linklist (widget)	4.771 ms	0.09 Mb
=> ps_customeraccountlinks (widget)	3.535 ms	0.09 Mb
DisplayFooter	7.904 ms	0.06 Mb
=> lgcookieslaw	0.064 ms	- Mb
=> zonethememanager	0.002 ms	- Mb
=> blockwishlist	7.838 ms	0.06 Mb
displayNav2	7.151 ms	0.30 Mb
=> ps_languageselector (widget)	2.215 ms	0.05 Mb
=> ps_currencyselector (widget)	4.936 ms	0.25 Mb
displayTop	5.349 ms	0.16 Mb
=> ps_searchbar (widget)	1.702 ms	0.05 Mb
=> ps_customersignin (widget)	1.467 ms	0.05 Mb
=> ps_shoppingcart (widget)	2.180 ms	0.05 Mb
ActionFrontControllerSetMedia	4.384 ms	0.01 Mb
=> blockwishlist	2.743 ms	- Mb
=> nexixpay	0.730 ms	- Mb
=> ps_emailsubscription	0.154 ms	- Mb
=> ps_socialfollow	0.349 ms	- Mb
=> ps_emailalerts	0.408 ms	- Mb
DisplayFooterRight	3.519 ms	0.04 Mb
=> zonethememanager	3.519 ms	0.04 Mb
DisplayFooterAfter	3.206 ms	0.04 Mb
=> zonethememanager	3.206 ms	0.04 Mb
displayFooterLeft	3.153 ms	0.09 Mb
=> ps_socialfollow (widget)	3.153 ms	0.09 Mb
DisplayNav1	2.569 ms	0.05 Mb
=> zonethememanager	2.569 ms	0.05 Mb
DisplayFooterLeft	2.563 ms	0.04 Mb
=> zonethememanager	2.563 ms	0.04 Mb
DisplayBanner	2.536 ms	0.04 Mb
=> zonethememanager	2.536 ms	0.04 Mb
DisplayNavFullWidth	2.375 ms	0.04 Mb
=> zonemegamenu	2.371 ms	0.04 Mb
=> paypal	0.004 ms	- Mb
ProductSearchProvider	2.219 ms	- Mb
=> ps_facetedsearch	2.219 ms	- Mb
ActionFrontControllerSetVariables	2.028 ms	0.07 Mb
=> zonethememanager	2.028 ms	0.07 Mb
DisplaySidebarNavigation	2.017 ms	0.02 Mb
=> zonethememanager	2.017 ms	0.02 Mb
displayFooterRight	1.981 ms	0.05 Mb
=> ps_emailsubscription (widget)	1.981 ms	0.05 Mb
DisplayFooterBefore	1.652 ms	0.04 Mb
=> blockreassurance	1.652 ms	0.04 Mb
ActionDispatcherBefore	1.159 ms	0.01 Mb
=> ps_mbo	1.159 ms	0.01 Mb
DisplayLeftColumn	0.883 ms	0.03 Mb
=> ps_facetedsearch	0.883 ms	0.03 Mb
DisplayWrapperBottom	0.719 ms	0.02 Mb
=> whatsappchat	0.719 ms	0.02 Mb
Top	0.596 ms	0.03 Mb
=> whatsappchat	0.596 ms	0.03 Mb
LeftColumn	0.583 ms	0.03 Mb
=> whatsappchat	0.583 ms	0.03 Mb
DisplayTop	0.075 ms	- Mb
=> lgcookieslaw	0.075 ms	- Mb
DisplayAfterBodyOpeningTag	0.061 ms	- Mb
=> lgcookieslaw	0.057 ms	- Mb
=> blockreassurance	0.004 ms	- Mb
ModuleRoutes	0.008 ms	- Mb
=> registrationfields	0.008 ms	- Mb
DisplayOverrideTemplate	0.007 ms	- Mb
=> ets_advancedcaptcha	0.007 ms	- Mb
33 hook(s)	197.251 ms	3.56 Mb

Module	Time	Memory Usage
registrationfields	10.548 ms	0.01 Mb
__construct	8.765 ms	- Mb
hookModuleRoutes	0.012 ms	- Mb
hookHeader	1.771 ms	0.01 Mb
ps_mbo	25.326 ms	0.05 Mb
__construct	24.161 ms	0.04 Mb
hookActionDispatcherBefore	1.165 ms	0.01 Mb
blockwishlist	11.990 ms	0.13 Mb
__construct	1.395 ms	0.07 Mb
hookActionFrontControllerSetMedia	2.753 ms	- Mb
hookDisplayFooter	7.842 ms	0.06 Mb
nexixpay	17.104 ms	0.43 Mb
__construct	15.165 ms	0.42 Mb
hookActionFrontControllerSetMedia	0.735 ms	- Mb
hookDisplayProductPriceBlock	0.513 ms	- Mb
hookDisplayProductPriceBlock	0.099 ms	- Mb
hookDisplayProductPriceBlock	0.513 ms	- Mb
hookDisplayProductPriceBlock	0.079 ms	- Mb
ps_emailsubscription	2.825 ms	0.06 Mb
__construct	0.683 ms	0.01 Mb
hookActionFrontControllerSetMedia	0.157 ms	- Mb
displayFooterRight	1.985 ms	0.05 Mb
ps_socialfollow	3.826 ms	0.09 Mb
__construct	0.318 ms	0.01 Mb
hookActionFrontControllerSetMedia	0.352 ms	- Mb
displayFooterLeft	3.156 ms	0.09 Mb
ps_emailalerts	1.034 ms	0.01 Mb
__construct	0.623 ms	0.01 Mb
hookActionFrontControllerSetMedia	0.411 ms	- Mb
zonethememanager	30.646 ms	0.42 Mb
__construct	0.970 ms	0.03 Mb
hookActionFrontControllerSetVariables	2.031 ms	0.07 Mb
hookDisplayHeader	4.905 ms	0.04 Mb
hookDisplaySidebarNavigation	2.020 ms	0.03 Mb
hookDisplayBanner	2.539 ms	0.04 Mb
hookDisplayNav1	2.572 ms	0.05 Mb
hookDisplayFooterLeft	2.566 ms	0.04 Mb
hookDisplayFooterRight	3.524 ms	0.04 Mb
hookDisplayFooter	0.004 ms	- Mb
hookDisplayFooterAfter	3.209 ms	0.04 Mb
hookDisplayOutsideMainPage	6.306 ms	0.03 Mb
lgcookieslaw	1.661 ms	0.07 Mb
__construct	1.265 ms	0.06 Mb
hookDisplayHeader	0.058 ms	- Mb
hookDisplayAfterBodyOpeningTag	0.061 ms	- Mb
hookDisplayTop	0.077 ms	- Mb
hookDisplayFooter	0.079 ms	- Mb
hookDisplayBeforeBodyClosingTag	0.121 ms	- Mb
ps_shoppingcart	2.494 ms	0.06 Mb
__construct	0.217 ms	0.01 Mb
hookDisplayHeader	0.094 ms	- Mb
displayTop	2.183 ms	0.05 Mb
ps_searchbar	2.776 ms	0.06 Mb
__construct	0.242 ms	0.01 Mb
hookDisplayHeader	0.829 ms	- Mb
displayTop	1.705 ms	0.05 Mb
productlabel	14.808 ms	0.43 Mb
__construct	0.645 ms	0.02 Mb
hookDisplayHeader	0.363 ms	- Mb
hookDisplayProductPriceBlock	0.006 ms	- Mb
hookDisplayProductPriceBlock	0.005 ms	- Mb
hookDisplayProductPriceBlock	0.003 ms	- Mb
hookDisplayProductPriceBlock	13.786 ms	0.41 Mb
ps_feeder	2.401 ms	0.02 Mb
__construct	0.396 ms	0.01 Mb
hookDisplayHeader	2.005 ms	0.02 Mb
productcomments	43.325 ms	0.24 Mb
__construct	0.230 ms	0.01 Mb
hookDisplayHeader	0.391 ms	- Mb
displayProductListReviews	42.704 ms	0.23 Mb
whatsappchat	14.846 ms	0.36 Mb
__construct	0.745 ms	0.06 Mb
hookDisplayHeader	2.443 ms	0.06 Mb
hookTop	0.599 ms	0.03 Mb
hookLeftColumn	0.585 ms	0.03 Mb
hookDisplayWrapperBottom	0.722 ms	0.02 Mb
hookDisplayBeforeBodyClosingTag	9.752 ms	0.16 Mb
paypal	12.093 ms	0.15 Mb
__construct	5.753 ms	0.13 Mb
hookHeader	6.334 ms	0.01 Mb
hookDisplayNavFullWidth	0.006 ms	- Mb
zonemegamenu	3.220 ms	0.13 Mb
__construct	0.668 ms	0.08 Mb
hookDisplayHeader	0.178 ms	- Mb
hookDisplayNavFullWidth	2.374 ms	0.04 Mb
emarketing	1.693 ms	- Mb
__construct	0.591 ms	- Mb
hookDisplayHeader	1.102 ms	- Mb
zonecolorsfonts	7.230 ms	0.15 Mb
__construct	0.684 ms	0.08 Mb
hookDisplayHeader	2.900 ms	0.03 Mb
hookDisplayOutsideMainPage	3.646 ms	0.03 Mb
ets_advancedcaptcha	0.690 ms	- Mb
__construct	0.656 ms	- Mb
hookDisplayHeader	0.023 ms	- Mb
hookDisplayOverrideTemplate	0.011 ms	- Mb
codegenerator	0.870 ms	0.01 Mb
__construct	0.511 ms	0.01 Mb
hookHeader	0.359 ms	- Mb
sendinblue	0.966 ms	0.01 Mb
__construct	0.512 ms	0.01 Mb
hookHeader	0.454 ms	- Mb
ps_facetedsearch	6.030 ms	0.05 Mb
__construct	2.921 ms	0.01 Mb
hookProductSearchProvider	2.223 ms	- Mb
hookDisplayLeftColumn	0.886 ms	0.03 Mb
blockreassurance	1.996 ms	0.05 Mb
__construct	0.335 ms	0.01 Mb
hookDisplayAfterBodyOpeningTag	0.006 ms	- Mb
hookDisplayFooterBefore	1.655 ms	0.04 Mb
ps_languageselector	2.456 ms	0.06 Mb
__construct	0.238 ms	0.01 Mb
displayNav2	2.218 ms	0.05 Mb
ps_currencyselector	5.169 ms	0.25 Mb
__construct	0.230 ms	0.01 Mb
displayNav2	4.939 ms	0.25 Mb
ps_customersignin	1.666 ms	0.06 Mb
__construct	0.196 ms	0.01 Mb
displayTop	1.470 ms	0.05 Mb
ps_categorytree	28.818 ms	1.16 Mb
__construct	0.215 ms	0.01 Mb
displayLeftColumn	28.603 ms	1.16 Mb
ps_linklist	7.454 ms	0.10 Mb
__construct	2.677 ms	0.01 Mb
footer	4.777 ms	0.09 Mb
ps_customeraccountlinks	3.875 ms	0.09 Mb
__construct	0.337 ms	0.01 Mb
footer	3.538 ms	0.09 Mb
30 module(s)	269.837 ms	4.54 Mb

List of products by supplier Mollaian Tappeti Persiani

Nain 9 line Persia 78x78

Stopwatch SQL - 390 queries

Doubles

Tables stress

ObjectModel instances

Included Files

45 queries	SELECT `id_module` FROM `psXX_module` WHERE `name` = "watermark" LIMIT XX
45 queries	SELECT m.`id_module` as `active`, ms.`id_module` as `shop_active` FROM `psXX_module` m LEFT JOIN `psXX_module_shop` ms ON m.`id_module` = ms.`id_module` WHERE `name` = "watermark" AND ms.`id_shop` IN (XX) LIMIT XX
36 queries	SELECT * FROM `psXX_category` a LEFT JOIN `psXX_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = XX LEFT JOIN `psXX_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
16 queries	SELECT `id_lang` FROM `psXX_lang` WHERE `locale` = 'en-us' OR `language_code` = 'en-us' LIMIT XX
15 queries	SELECT `id_module` FROM `psXX_module_shop` WHERE `id_module` = XX AND `id_shop` = XX LIMIT XX
11 queries	SELECT * FROM psXX_hook_module WHERE `id_hook` = XX AND `id_module` = XX AND `id_shop` = XX
9 queries	SELECT DISTINCT a.`id_attribute`, a.`color`, al.`name`, agl.`id_attribute_group`, IF(lialv.`url_name` IS NULL OR lialv.`url_name` = "", NULL, lialv.`url_name`) AS url_name, IF(lialv.`meta_title` IS NULL OR lialv.`meta_title` = "", NULL, lialv.`meta_title`) AS meta_title FROM `psXX_attribute_group` ag INNER JOIN `psXX_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = XX) INNER JOIN `psXX_attribute` a ON a.`id_attribute_group` = ag.`id_attribute_group` INNER JOIN `psXX_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = XX) INNER JOIN psXX_attribute_group_shop attribute_group_shop ON (attribute_group_shop.id_attribute_group = ag.id_attribute_group AND attribute_group_shop.id_shop = XX) INNER JOIN psXX_attribute_shop attribute_shop ON (attribute_shop.id_attribute = a.id_attribute AND attribute_shop.id_shop = XX) LEFT JOIN `psXX_layered_indexable_attribute_lang_value` lialv ON (a.`id_attribute` = lialv.`id_attribute` AND lialv.`id_lang` = XX) WHERE ag.id_attribute_group = XX ORDER BY agl.`name` ASC, a.`position` ASC
8 queries	SELECT * FROM `psXX_currency` a LEFT JOIN `psXX_currency_lang` `b` ON a.`id_currency` = b.`id_currency` AND b.`id_lang` = XX LEFT JOIN `psXX_currency_shop` `c` ON a.`id_currency` = c.`id_currency` AND c.`id_shop` = XX WHERE (a.`id_currency` = XX) LIMIT XX
7 queries	SELECT pac.id_attribute, 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, pa.id_product_attribute, cp.position FROM psXX_product p LEFT JOIN psXX_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN psXX_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN psXX_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 psXX_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN psXX_category_product cp ON (p.id_product = cp.id_product) INNER JOIN psXX_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = XX AND ps.active = TRUE) INNER JOIN psXX_category c ON (cp.id_category = c.id_category AND c.active=XX) LEFT JOIN psXX_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN psXX_feature_product fp_XX ON (p.id_product = fp_XX.id_product) WHERE ((pac.id_attribute=XX)) AND ((fp_XX.id_feature_value=XX)) AND ps.id_shop='XX' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='XX' AND p.id_supplier='XX' GROUP BY p.id_product) p LEFT JOIN psXX_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN psXX_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) INNER JOIN psXX_attribute a ON (a.id_attribute = pac.id_attribute) LEFT JOIN psXX_product_attribute_combination pac_XX ON (pa.id_product_attribute = pac_XX.id_product_attribute) LEFT JOIN psXX_feature_product fp_XX ON (p.id_product = fp_XX.id_product) WHERE ((a.id_attribute_group=XX)) AND ((pac_XX.id_attribute=XX)) AND ((fp_XX.id_feature_value=XX)) GROUP BY pac.id_attribute
4 queries	SELECT * FROM `psXX_currency` a LEFT JOIN `psXX_currency_shop` `c` ON a.`id_currency` = c.`id_currency` AND c.`id_shop` = XX WHERE (a.`id_currency` = XX) LIMIT XX
4 queries	SELECT * FROM `psXX_currency_lang` WHERE `id_currency` = XX
4 queries	SELECT `name` FROM `psXX_hook` WHERE `id_hook` = XX LIMIT XX
4 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 `psXX_feature_value` v LEFT JOIN `psXX_feature_value_lang` vl ON (v.`id_feature_value` = vl.`id_feature_value` AND vl.`id_lang` = XX) LEFT JOIN `psXX_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
3 queries	SELECT m.`id_module`, m.`name`, ms.`id_module`as `mshop` FROM `psXX_module` m LEFT JOIN `psXX_module_shop` ms ON m.`id_module` = ms.`id_module` AND ms.`id_shop` = XX
3 queries	SELECT `id_country` FROM `psXX_country` WHERE `iso_code` = 'US' LIMIT XX
2 queries	SELECT * FROM `psXX_country` a LEFT JOIN `psXX_country_lang` `b` ON a.`id_country` = b.`id_country` AND b.`id_lang` = XX LEFT JOIN `psXX_country_shop` `c` ON a.`id_country` = c.`id_country` AND c.`id_shop` = XX WHERE (a.`id_country` = XX) LIMIT XX
2 queries	SELECT * FROM `psXX_lang` a LEFT JOIN `psXX_lang_shop` `c` ON a.`id_lang` = c.`id_lang` AND c.`id_shop` = XX WHERE (a.`id_lang` = XX) LIMIT XX
2 queries	SELECT id_shop FROM `psXX_lang_shop` WHERE `id_lang` = XX AND id_shop = XX LIMIT XX
2 queries	SELECT `active` FROM `psXX_module` WHERE `name` = "ps_mbo" LIMIT XX
2 queries	SELECT m.`id_module` as `active`, ms.`id_module` as `shop_active` FROM `psXX_module` m LEFT JOIN `psXX_module_shop` ms ON m.`id_module` = ms.`id_module` WHERE `name` = "ps_mbo" LIMIT XX
2 queries	SELECT * FROM `psXX_supplier` a LEFT JOIN `psXX_supplier_lang` `b` ON a.`id_supplier` = b.`id_supplier` AND b.`id_lang` = XX LEFT JOIN `psXX_supplier_shop` `c` ON a.`id_supplier` = c.`id_supplier` AND c.`id_shop` = XX WHERE (a.`id_supplier` = XX) LIMIT XX
2 queries	SELECT * FROM `psXX_country` a LEFT JOIN `psXX_country_shop` `c` ON a.`id_country` = c.`id_country` AND c.`id_shop` = XX WHERE (a.`id_country` = XX) LIMIT XX
2 queries	SELECT * FROM `psXX_country_lang` WHERE `id_country` = XX
2 queries	SELECT XX FROM `psXX_cart_rule` WHERE ((date_to >= "XX-XX-XX XX:XX:XX" AND date_to <= "XX-XX-XX XX:XX:XX") OR (date_from >= "XX-XX-XX XX:XX:XX" AND date_from <= "XX-XX-XX XX:XX:XX") OR (date_from < "XX-XX-XX XX:XX:XX" AND date_to > "XX-XX-XX XX:XX:XX")) AND `id_customer` IN (XX,XX) LIMIT XX
2 queries	SELECT fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, pa.id_product_attribute, cp.position FROM psXX_product p LEFT JOIN psXX_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN psXX_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN psXX_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 psXX_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN psXX_category_product cp ON (p.id_product = cp.id_product) INNER JOIN psXX_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = XX AND ps.active = TRUE) INNER JOIN psXX_category c ON (cp.id_category = c.id_category AND c.active=XX) LEFT JOIN psXX_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN psXX_feature_product fp_XX ON (p.id_product = fp_XX.id_product) WHERE ((pac.id_attribute=XX)) AND ((fp_XX.id_feature_value=XX)) AND ps.id_shop='XX' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='XX' AND p.id_supplier='XX' GROUP BY p.id_product) p INNER JOIN psXX_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN psXX_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN psXX_product_attribute_combination pac_XX ON (pa.id_product_attribute = pac_XX.id_product_attribute) LEFT JOIN psXX_feature_product fp_XX ON (p.id_product = fp_XX.id_product) WHERE ((fp.id_feature=XX)) AND ((pac_XX.id_attribute=XX)) AND ((fp_XX.id_feature_value=XX)) GROUP BY fp.id_feature_value
2 queries	SELECT cl.`link_rewrite` FROM `psXX_category_lang` cl WHERE `id_lang` = XX AND cl.id_shop = XX AND cl.`id_category` = XX LIMIT XX
2 queries	SELECT XX FROM `psXX_specific_price` WHERE id_product = XX LIMIT XX
2 queries	SELECT tr.* FROM `psXX_tax_rule` tr JOIN `psXX_tax_rules_group` trg ON (tr.`id_tax_rules_group` = trg.`id_tax_rules_group`) WHERE trg.`active` = XX AND tr.`id_country` = XX AND tr.`id_tax_rules_group` = XX AND tr.`id_state` IN (XX, XX) AND ('XX' BETWEEN tr.`zipcode_from` AND tr.`zipcode_to` OR (tr.`zipcode_to` = XX AND tr.`zipcode_from` IN(XX, 'XX'))) ORDER BY tr.`zipcode_from` DESC, tr.`zipcode_to` DESC, tr.`id_state` DESC, tr.`id_country` DESC
2 queries	SELECT SUM(quantity) FROM `psXX_stock_available` WHERE (id_product = XX) AND (id_product_attribute = XX) AND (id_shop = XX) AND (id_shop_group = XX) LIMIT XX
2 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 `psXX_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 `psXX_cart_product` cp JOIN `psXX_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `psXX_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
2 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 `psXX_attribute` a LEFT JOIN `psXX_attribute_lang` al ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = XX) LEFT JOIN `psXX_product_attribute_combination` pac ON (pac.`id_attribute` = a.`id_attribute`) LEFT JOIN `psXX_product_attribute` pa ON (pa.`id_product_attribute` = pac.`id_product_attribute`) INNER JOIN psXX_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 `psXX_product_attribute_lang` pal ON (pal.`id_product_attribute` = pac.`id_product_attribute` AND pal.`id_lang` = XX) LEFT JOIN `psXX_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

Name	Instances	Source
Category	37	/modules/ps_categorytree/ps_categorytree.php:340 (__construct) [id: 2] /classes/Link.php:402 (__construct) [id: 44] /classes/Link.php:402 (__construct) [id: 45] /classes/Link.php:402 (__construct) [id: 46] /classes/Link.php:402 (__construct) [id: 47] /classes/Link.php:402 (__construct) [id: 48] /classes/Link.php:402 (__construct) [id: 61] /classes/Link.php:402 (__construct) [id: 49] /classes/Link.php:402 (__construct) [id: 50] /classes/Link.php:402 (__construct) [id: 51] /classes/Link.php:402 (__construct) [id: 34] /classes/Link.php:402 (__construct) [id: 36] /classes/Link.php:402 (__construct) [id: 30] /classes/Link.php:402 (__construct) [id: 37] /classes/Link.php:402 (__construct) [id: 29] /classes/Link.php:402 (__construct) [id: 42] /classes/Link.php:402 (__construct) [id: 19] /classes/Link.php:402 (__construct) [id: 21] /classes/Link.php:402 (__construct) [id: 6] /classes/Link.php:402 (__construct) [id: 7] /classes/Link.php:402 (__construct) [id: 22] /classes/Link.php:402 (__construct) [id: 24] /classes/Link.php:402 (__construct) [id: 25] /classes/Link.php:402 (__construct) [id: 43] /classes/Link.php:402 (__construct) [id: 26] /classes/Link.php:402 (__construct) [id: 65] /classes/Link.php:402 (__construct) [id: 38] /classes/Link.php:402 (__construct) [id: 39] /classes/Link.php:402 (__construct) [id: 35] /classes/Link.php:402 (__construct) [id: 40] /classes/Link.php:402 (__construct) [id: 62] /classes/Link.php:402 (__construct) [id: 41] /classes/Link.php:402 (__construct) [id: 23] /classes/Link.php:402 (__construct) [id: 18] /classes/Link.php:402 (__construct) [id: 27] /classes/Link.php:402 (__construct) [id: 28] /classes/Link.php:402 (__construct) [id: 2]
Country	14	/config/config.inc.php:146 (__construct) [id: 10] /classes/controller/FrontController.php:935 (__construct) [id: 21] /classes/AddressFormat.php:404 (__construct) [id: 10] /classes/controller/FrontController.php:1767 (__construct) [id: 10] /modules/whatsappchat/classes/WhatsappChatBlock.php:157 (__construct) [id: 21] /modules/paypal/paypal.php:327 (__construct) [id: 10] /modules/whatsappchat/classes/WhatsappChatBlock.php:157 (__construct) [id: 21] /modules/whatsappchat/classes/WhatsappChatBlock.php:157 (__construct) [id: 21] /modules/whatsappchat/classes/WhatsappChatBlock.php:157 (__construct) [id: 21] /modules/whatsappchat/classes/WhatsappChatBlock.php:157 (__construct) [id: 21] /modules/whatsappchat/classes/WhatsappChatBlock.php:157 (__construct) [id: 21] /modules/whatsappchat/classes/WhatsappChatBlock.php:157 (__construct) [id: 21] /modules/whatsappchat/classes/WhatsappChatBlock.php:157 (__construct) [id: 21] /modules/whatsappchat/classes/WhatsappChatBlock.php:157 (__construct) [id: 21]
Address	13	/classes/shop/Shop.php:486 (__construct) [id: ] /modules/whatsappchat/classes/WhatsappChatBlock.php:145 (__construct) [id: 0] /classes/Product.php:3694 (initialize) [id: ] /classes/Product.php:3804 (__construct) [id: ] /classes/Product.php:5958 (__construct) [id: ] /modules/whatsappchat/classes/WhatsappChatBlock.php:145 (__construct) [id: 0] /modules/whatsappchat/classes/WhatsappChatBlock.php:145 (__construct) [id: 0] /modules/whatsappchat/classes/WhatsappChatBlock.php:145 (__construct) [id: 0] /modules/whatsappchat/classes/WhatsappChatBlock.php:145 (__construct) [id: 0] /modules/whatsappchat/classes/WhatsappChatBlock.php:145 (__construct) [id: 0] /modules/whatsappchat/classes/WhatsappChatBlock.php:145 (__construct) [id: 0] /modules/whatsappchat/classes/WhatsappChatBlock.php:145 (__construct) [id: 0] /modules/whatsappchat/classes/WhatsappChatBlock.php:145 (__construct) [id: 0]
Currency	12	/src/Adapter/Currency/CurrencyDataProvider.php:101 (__construct) [id: 7] /src/Adapter/Currency/CurrencyDataProvider.php:101 (__construct) [id: 8] /src/Adapter/Currency/CurrencyDataProvider.php:101 (__construct) [id: 2] /src/Adapter/Currency/CurrencyDataProvider.php:101 (__construct) [id: 6] /src/Adapter/Currency/CurrencyDataProvider.php:101 (__construct) [id: 1] /src/Adapter/Currency/CurrencyDataProvider.php:101 (__construct) [id: 3] /src/Adapter/Currency/CurrencyDataProvider.php:101 (__construct) [id: 5] /src/Adapter/Currency/CurrencyDataProvider.php:101 (__construct) [id: 4] /classes/Tools.php:690 (getCurrencyInstance) [id: 1] /modules/ps_currencyselector/ps_currencyselector.php:112 (getCurrencies) [id: 2] /modules/ps_currencyselector/ps_currencyselector.php:112 (getCurrencies) [id: 3] /modules/ps_currencyselector/ps_currencyselector.php:112 (getCurrencies) [id: 4]
Customer	10	/config/config.inc.php:264 (__construct) [id: ] /modules/whatsappchat/classes/WhatsappChatBlock.php:155 (__construct) [id: 0] /modules/whatsappchat/classes/WhatsappChatBlock.php:155 (__construct) [id: 0] /modules/whatsappchat/classes/WhatsappChatBlock.php:155 (__construct) [id: 0] /modules/whatsappchat/classes/WhatsappChatBlock.php:155 (__construct) [id: 0] /modules/whatsappchat/classes/WhatsappChatBlock.php:155 (__construct) [id: 0] /modules/whatsappchat/classes/WhatsappChatBlock.php:155 (__construct) [id: 0] /modules/whatsappchat/classes/WhatsappChatBlock.php:155 (__construct) [id: 0] /modules/whatsappchat/classes/WhatsappChatBlock.php:155 (__construct) [id: 0] /modules/whatsappchat/classes/WhatsappChatBlock.php:155 (__construct) [id: 0]
Supplier	10	/controllers/front/listing/SupplierController.php:67 (__construct) [id: 2] /classes/Meta.php:448 (__construct) [id: 2] /classes/Link.php:615 (__construct) [id: 2] /classes/Link.php:615 (__construct) [id: 2] /classes/Link.php:615 (__construct) [id: 2] /classes/Link.php:615 (__construct) [id: 2] /classes/Link.php:615 (__construct) [id: 2] /classes/Link.php:615 (__construct) [id: 2] /classes/Link.php:615 (__construct) [id: 2] /classes/Link.php:615 (__construct) [id: 2]
WhatsappChatBlockAgent	10	/modules/whatsappchat/whatsappchat.php:290 (__construct) [id: ] /modules/whatsappchat/whatsappchat.php:550 (__construct) [id: ] /modules/whatsappchat/whatsappchat.php:550 (__construct) [id: ] /modules/whatsappchat/whatsappchat.php:550 (__construct) [id: ] /modules/whatsappchat/whatsappchat.php:550 (__construct) [id: ] /modules/whatsappchat/whatsappchat.php:550 (__construct) [id: ] /modules/whatsappchat/whatsappchat.php:550 (__construct) [id: ] /modules/whatsappchat/whatsappchat.php:550 (__construct) [id: ] /modules/whatsappchat/whatsappchat.php:550 (__construct) [id: ] /modules/whatsappchat/whatsappchat.php:550 (__construct) [id: ]
WhatsappChatBlock	9	/modules/whatsappchat/whatsappchat.php:549 (__construct) [id: ] /modules/whatsappchat/whatsappchat.php:549 (__construct) [id: ] /modules/whatsappchat/whatsappchat.php:549 (__construct) [id: ] /modules/whatsappchat/whatsappchat.php:549 (__construct) [id: ] /modules/whatsappchat/whatsappchat.php:549 (__construct) [id: ] /modules/whatsappchat/whatsappchat.php:549 (__construct) [id: ] /modules/whatsappchat/whatsappchat.php:549 (__construct) [id: ] /modules/whatsappchat/whatsappchat.php:549 (__construct) [id: ] /modules/whatsappchat/whatsappchat.php:549 (__construct) [id: ]
Product	5	/src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 1813] /classes/Link.php:113 (__construct) [id: 1813] /src/Adapter/Presenter/Product/ProductLazyArray.php:662 (__construct) [id: 1813] /modules/productlabel/classes/ProductLabelDAO.php:858 (__construct) [id: 1813] /classes/Link.php:113 (__construct) [id: 1813]
Language	3	/config/config.inc.php:211 (__construct) [id: 1] /classes/Tools.php:641 (__construct) [id: 2] /classes/Tools.php:560 (__construct) [id: 2]
State	2	/classes/AddressFormat.php:404 (__construct) [id: 169] /classes/controller/FrontController.php:1766 (__construct) [id: 169]
Cart	2	/classes/controller/FrontController.php:467 (__construct) [id: ] /classes/controller/FrontController.php:541 (__construct) [id: ]
Combination	1	/classes/Product.php:5906 (__construct) [id: 4654]
ZManager	1	/modules/zonethememanager/zonethememanager.php:1933 (getSettingsByShop) [id: 1]
Shop	1	/config/config.inc.php:117 (initialize) [id: 1]
AddressFormat	1	/classes/controller/FrontController.php:1761 (generateAddress) [id: ]
Risk	1	/classes/controller/FrontController.php:1694 (__construct) [id: ]
Group	1	/modules/ets_superspeed/classes/cache.php:71 (getCurrent) [id: 1]
Fields	1	/modules/registrationfields/registrationfields.php:57 (__construct) [id: ]
ShopGroup	1	/classes/shop/Shop.php:561 (__construct) [id: 1]
Gender	1	/classes/controller/FrontController.php:1691 (__construct) [id: 0]

#	Query	Time (ms)	Rows	Filesort	Group By	Location
154	SELECT SQL_NO_CACHE pac.id_attribute, 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, pa.id_product_attribute, cp.position FROM ps2_product p LEFT JOIN ps2_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps2_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps2_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 ps2_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps2_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps2_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps2_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps2_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN ps2_feature_product fp ON (p.id_product = fp.id_product) WHERE ((fp.id_feature_value=54)) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND p.id_supplier='2' GROUP BY p.id_product) p LEFT JOIN ps2_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps2_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) INNER JOIN ps2_attribute a ON (a.id_attribute = pac.id_attribute) LEFT JOIN ps2_feature_product fp_1 ON (p.id_product = fp_1.id_product) WHERE ((a.id_attribute_group=3)) AND ((fp_1.id_feature_value=54)) GROUP BY pac.id_attribute	47.618 ms	97020	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:737 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:150 (getAttributesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/SupplierController.php:101 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /override/classes/Dispatcher.php:39 (dispatch) /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 `ps2_configuration` c LEFT JOIN `ps2_configuration_lang` cl ON (c.`id_configuration` = cl.`id_configuration`)	7.785 ms	1406			/classes/Configuration.php:180 /classes/Configuration.php:229 (loadConfiguration) /classes/Configuration.php:302 (get) /classes/shop/Shop.php:398 (getMultiShopValues) /config/config.inc.php:117 (initialize) /index.php:27 (require)
146	SELECT SQL_NO_CACHE pac.id_attribute, 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, pa.id_product_attribute, cp.position FROM ps2_product p LEFT JOIN ps2_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps2_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps2_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 ps2_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps2_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps2_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps2_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps2_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN ps2_feature_product fp_1 ON (p.id_product = fp_1.id_product) WHERE ((pac.id_attribute=1066)) AND ((fp_1.id_feature_value=54)) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND p.id_supplier='2' GROUP BY p.id_product) p LEFT JOIN ps2_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps2_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) INNER JOIN ps2_attribute a ON (a.id_attribute = pac.id_attribute) LEFT JOIN ps2_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) LEFT JOIN ps2_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((a.id_attribute_group=1)) AND ((pac_1.id_attribute=1066)) AND ((fp_2.id_feature_value=54)) GROUP BY pac.id_attribute	7.393 ms	3500	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:737 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:150 (getAttributesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/SupplierController.php:101 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /override/classes/Dispatcher.php:39 (dispatch) /index.php:28 (dispatch)
145	SELECT SQL_NO_CACHE DISTINCT a.`id_attribute`, a.`color`, al.`name`, agl.`id_attribute_group`, IF(lialv.`url_name` IS NULL OR lialv.`url_name` = "", NULL, lialv.`url_name`) AS url_name, IF(lialv.`meta_title` IS NULL OR lialv.`meta_title` = "", NULL, lialv.`meta_title`) AS meta_title FROM `ps2_attribute_group` ag INNER JOIN `ps2_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 2) INNER JOIN `ps2_attribute` a ON a.`id_attribute_group` = ag.`id_attribute_group` INNER JOIN `ps2_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 2) INNER JOIN ps2_attribute_group_shop attribute_group_shop ON (attribute_group_shop.id_attribute_group = ag.id_attribute_group AND attribute_group_shop.id_shop = 1) INNER JOIN ps2_attribute_shop attribute_shop ON (attribute_shop.id_attribute = a.id_attribute AND attribute_shop.id_shop = 1) LEFT JOIN `ps2_layered_indexable_attribute_lang_value` lialv ON (a.`id_attribute` = lialv.`id_attribute` AND lialv.`id_lang` = 2) WHERE ag.id_attribute_group = 1 ORDER BY agl.`name` ASC, a.`position` ASC	5.168 ms	1133	Yes		/modules/ps_facetedsearch/src/Filters/DataAccessor.php:96 /modules/ps_facetedsearch/src/Filters/Block.php:731 (getAttributes) /modules/ps_facetedsearch/src/Filters/Block.php:150 (getAttributesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/SupplierController.php:101 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /override/classes/Dispatcher.php:39 (dispatch) /index.php:28 (dispatch)
138	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, pa.id_product_attribute, cp.position FROM ps2_product p LEFT JOIN ps2_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps2_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps2_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 ps2_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps2_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps2_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps2_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps2_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN ps2_feature_product fp_1 ON (p.id_product = fp_1.id_product) WHERE ((pac.id_attribute=1066)) AND ((fp_1.id_feature_value=54)) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND p.id_supplier='2' GROUP BY p.id_product) p LEFT JOIN ps2_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps2_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps2_feature_product fp_1 ON (p.id_product = fp_1.id_product) WHERE ((pac.id_attribute=1066)) AND ((fp_1.id_feature_value=54))	4.903 ms	500			/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:187 (getProductByFilters) /classes/controller/ProductListingFrontController.php:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/SupplierController.php:101 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /override/classes/Dispatcher.php:39 (dispatch) /index.php:28 (dispatch)
152	SELECT SQL_NO_CACHE pac.id_attribute, 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, pa.id_product_attribute, cp.position FROM ps2_product p LEFT JOIN ps2_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps2_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps2_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 ps2_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps2_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps2_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps2_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps2_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN ps2_feature_product fp_1 ON (p.id_product = fp_1.id_product) WHERE ((pac.id_attribute=1066)) AND ((fp_1.id_feature_value=54)) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND p.id_supplier='2' GROUP BY p.id_product) p LEFT JOIN ps2_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps2_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) INNER JOIN ps2_attribute a ON (a.id_attribute = pac.id_attribute) LEFT JOIN ps2_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) LEFT JOIN ps2_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((a.id_attribute_group=4)) AND ((pac_1.id_attribute=1066)) AND ((fp_2.id_feature_value=54)) GROUP BY pac.id_attribute	4.256 ms	3500	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:737 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:150 (getAttributesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/SupplierController.php:101 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /override/classes/Dispatcher.php:39 (dispatch) /index.php:28 (dispatch)
142	SELECT SQL_NO_CACHE pac.id_attribute, 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, pa.id_product_attribute, cp.position FROM ps2_product p LEFT JOIN ps2_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps2_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps2_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 ps2_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps2_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps2_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps2_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps2_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN ps2_feature_product fp_1 ON (p.id_product = fp_1.id_product) WHERE ((pac.id_attribute=1066)) AND ((fp_1.id_feature_value=54)) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND p.id_supplier='2' GROUP BY p.id_product) p LEFT JOIN ps2_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps2_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) INNER JOIN ps2_attribute a ON (a.id_attribute = pac.id_attribute) LEFT JOIN ps2_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) LEFT JOIN ps2_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((a.id_attribute_group=18)) AND ((pac_1.id_attribute=1066)) AND ((fp_2.id_feature_value=54)) GROUP BY pac.id_attribute	4.228 ms	3500	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:737 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:150 (getAttributesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/SupplierController.php:101 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /override/classes/Dispatcher.php:39 (dispatch) /index.php:28 (dispatch)
134	SELECT SQL_NO_CACHE DISTINCT a.`id_attribute`, a.`color`, al.`name`, agl.`id_attribute_group`, IF(lialv.`url_name` IS NULL OR lialv.`url_name` = "", NULL, lialv.`url_name`) AS url_name, IF(lialv.`meta_title` IS NULL OR lialv.`meta_title` = "", NULL, lialv.`meta_title`) AS meta_title FROM `ps2_attribute_group` ag INNER JOIN `ps2_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 2) INNER JOIN `ps2_attribute` a ON a.`id_attribute_group` = ag.`id_attribute_group` INNER JOIN `ps2_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 2) INNER JOIN ps2_attribute_group_shop attribute_group_shop ON (attribute_group_shop.id_attribute_group = ag.id_attribute_group AND attribute_group_shop.id_shop = 1) INNER JOIN ps2_attribute_shop attribute_shop ON (attribute_shop.id_attribute = a.id_attribute AND attribute_shop.id_shop = 1) LEFT JOIN `ps2_layered_indexable_attribute_lang_value` lialv ON (a.`id_attribute` = lialv.`id_attribute` AND lialv.`id_lang` = 2) WHERE ag.id_attribute_group = 3 ORDER BY agl.`name` ASC, a.`position` ASC	4.208 ms	168	Yes		/modules/ps_facetedsearch/src/Filters/DataAccessor.php:96 /modules/ps_facetedsearch/src/Filters/Converter.php:427 (getAttributes) /modules/ps_facetedsearch/src/Product/SearchProvider.php:163 (createFacetedSearchFiltersFromQuery) /classes/controller/ProductListingFrontController.php:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/SupplierController.php:101 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /override/classes/Dispatcher.php:39 (dispatch) /index.php:28 (dispatch)
150	SELECT SQL_NO_CACHE pac.id_attribute, 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, pa.id_product_attribute, cp.position FROM ps2_product p LEFT JOIN ps2_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps2_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps2_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 ps2_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps2_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps2_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps2_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps2_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN ps2_feature_product fp_1 ON (p.id_product = fp_1.id_product) WHERE ((pac.id_attribute=1066)) AND ((fp_1.id_feature_value=54)) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND p.id_supplier='2' GROUP BY p.id_product) p LEFT JOIN ps2_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps2_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) INNER JOIN ps2_attribute a ON (a.id_attribute = pac.id_attribute) LEFT JOIN ps2_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) LEFT JOIN ps2_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((a.id_attribute_group=7)) AND ((pac_1.id_attribute=1066)) AND ((fp_2.id_feature_value=54)) GROUP BY pac.id_attribute	4.141 ms	3500	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:737 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:150 (getAttributesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/SupplierController.php:101 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /override/classes/Dispatcher.php:39 (dispatch) /index.php:28 (dispatch)
144	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, pa.id_product_attribute, cp.position FROM ps2_product p LEFT JOIN ps2_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps2_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps2_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 ps2_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps2_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps2_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps2_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps2_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN ps2_feature_product fp_1 ON (p.id_product = fp_1.id_product) WHERE ((pac.id_attribute=1066)) AND ((fp_1.id_feature_value=54)) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND p.id_supplier='2' GROUP BY p.id_product) p LEFT JOIN ps2_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps2_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps2_feature_product fp_1 ON (p.id_product = fp_1.id_product) WHERE ((pac.id_attribute=1066)) AND ((fp_1.id_feature_value=54)) GROUP BY p.id_manufacturer	4.124 ms	500	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:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/SupplierController.php:101 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /override/classes/Dispatcher.php:39 (dispatch) /index.php:28 (dispatch)
148	SELECT SQL_NO_CACHE pac.id_attribute, 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, pa.id_product_attribute, cp.position FROM ps2_product p LEFT JOIN ps2_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps2_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps2_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 ps2_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps2_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps2_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps2_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps2_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN ps2_feature_product fp_1 ON (p.id_product = fp_1.id_product) WHERE ((pac.id_attribute=1066)) AND ((fp_1.id_feature_value=54)) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND p.id_supplier='2' GROUP BY p.id_product) p LEFT JOIN ps2_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps2_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) INNER JOIN ps2_attribute a ON (a.id_attribute = pac.id_attribute) LEFT JOIN ps2_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) LEFT JOIN ps2_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((a.id_attribute_group=16)) AND ((pac_1.id_attribute=1066)) AND ((fp_2.id_feature_value=54)) GROUP BY pac.id_attribute	4.102 ms	3500	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:737 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:150 (getAttributesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/SupplierController.php:101 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /override/classes/Dispatcher.php:39 (dispatch) /index.php:28 (dispatch)
156	SELECT SQL_NO_CACHE pac.id_attribute, 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, pa.id_product_attribute, cp.position FROM ps2_product p LEFT JOIN ps2_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps2_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps2_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 ps2_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps2_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps2_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps2_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps2_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN ps2_feature_product fp_1 ON (p.id_product = fp_1.id_product) WHERE ((pac.id_attribute=1066)) AND ((fp_1.id_feature_value=54)) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND p.id_supplier='2' GROUP BY p.id_product) p LEFT JOIN ps2_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps2_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) INNER JOIN ps2_attribute a ON (a.id_attribute = pac.id_attribute) LEFT JOIN ps2_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) LEFT JOIN ps2_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((a.id_attribute_group=20)) AND ((pac_1.id_attribute=1066)) AND ((fp_2.id_feature_value=54)) GROUP BY pac.id_attribute	4.023 ms	3500	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:737 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:150 (getAttributesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/SupplierController.php:101 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /override/classes/Dispatcher.php:39 (dispatch) /index.php:28 (dispatch)
157	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, pa.id_product_attribute, cp.position FROM ps2_product p LEFT JOIN ps2_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps2_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps2_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 ps2_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps2_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps2_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps2_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps2_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN ps2_feature_product fp_1 ON (p.id_product = fp_1.id_product) WHERE ((pac.id_attribute=1066)) AND ((fp_1.id_feature_value=54)) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND p.id_supplier='2' GROUP BY p.id_product) p INNER JOIN ps2_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN ps2_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps2_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) LEFT JOIN ps2_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((fp.id_feature=10)) AND ((pac_1.id_attribute=1066)) AND ((fp_2.id_feature_value=54)) GROUP BY fp.id_feature_value	3.925 ms	500	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:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/SupplierController.php:101 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /override/classes/Dispatcher.php:39 (dispatch) /index.php:28 (dispatch)
160	SELECT SQL_NO_CACHE pac.id_attribute, 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, pa.id_product_attribute, cp.position FROM ps2_product p LEFT JOIN ps2_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps2_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps2_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 ps2_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps2_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps2_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps2_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps2_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN ps2_feature_product fp_1 ON (p.id_product = fp_1.id_product) WHERE ((pac.id_attribute=1066)) AND ((fp_1.id_feature_value=54)) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND p.id_supplier='2' GROUP BY p.id_product) p LEFT JOIN ps2_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps2_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) INNER JOIN ps2_attribute a ON (a.id_attribute = pac.id_attribute) LEFT JOIN ps2_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) LEFT JOIN ps2_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((a.id_attribute_group=19)) AND ((pac_1.id_attribute=1066)) AND ((fp_2.id_feature_value=54)) GROUP BY pac.id_attribute	3.815 ms	3500	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:737 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:150 (getAttributesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/SupplierController.php:101 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /override/classes/Dispatcher.php:39 (dispatch) /index.php:28 (dispatch)
163	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, pa.id_product_attribute, cp.position FROM ps2_product p LEFT JOIN ps2_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps2_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps2_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 ps2_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps2_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps2_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps2_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps2_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN ps2_feature_product fp_1 ON (p.id_product = fp_1.id_product) WHERE ((pac.id_attribute=1066)) AND ((fp_1.id_feature_value=54)) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND p.id_supplier='2' GROUP BY p.id_product) p INNER JOIN ps2_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN ps2_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps2_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) LEFT JOIN ps2_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((fp.id_feature=15)) AND ((pac_1.id_attribute=1066)) AND ((fp_2.id_feature_value=54)) GROUP BY fp.id_feature_value	3.739 ms	500	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:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/SupplierController.php:101 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /override/classes/Dispatcher.php:39 (dispatch) /index.php:28 (dispatch)
137	SELECT SQL_NO_CACHE p.id_product, p.id_product_attribute 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, pa.id_product_attribute, cp.position FROM ps2_product p LEFT JOIN ps2_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps2_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps2_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 ps2_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps2_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps2_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps2_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps2_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN ps2_feature_product fp_1 ON (p.id_product = fp_1.id_product) WHERE ((pac.id_attribute=1066)) AND ((fp_1.id_feature_value=54)) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND p.id_supplier='2' GROUP BY p.id_product) p LEFT JOIN ps2_product_attribute pa ON (p.id_product = pa.id_product) INNER JOIN ps2_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, 12	3.045 ms	5000	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:187 (getProductByFilters) /classes/controller/ProductListingFrontController.php:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/SupplierController.php:101 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /override/classes/Dispatcher.php:39 (dispatch) /index.php:28 (dispatch)
183	SELECT SQL_NO_CACHE h.id_hook, h.name as h_name, title, description, h.position, hm.position as hm_position, m.id_module, m.name, m.active FROM `ps2_hook_module` hm STRAIGHT_JOIN `ps2_hook` h ON (h.id_hook = hm.id_hook AND hm.id_shop = 1) STRAIGHT_JOIN `ps2_module` as m ON (m.id_module = hm.id_module) ORDER BY hm.position	2.718 ms	644			/classes/Hook.php:456 /classes/Hook.php:493 (getHookModuleList) /classes/tax/TaxManagerFactory.php:67 (getModulesFromHook) /classes/tax/TaxManagerFactory.php:46 (execHookTaxManagerFactory) /classes/Product.php:3925 (getManager) /classes/Product.php:3717 (priceCalculation) /classes/Product.php:5688 (getPriceStatic) /override/classes/Product.php:354 (getProductProperties) /classes/ProductAssembler.php:209 (getProductProperties) /classes/controller/ProductListingFrontController.php:108 (assembleProducts) /classes/controller/ProductListingFrontController.php:379 (prepareMultipleProductsForTemplate) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/SupplierController.php:101 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /override/classes/Dispatcher.php:39 (dispatch) /index.php:28 (dispatch)
147	SELECT SQL_NO_CACHE DISTINCT a.`id_attribute`, a.`color`, al.`name`, agl.`id_attribute_group`, IF(lialv.`url_name` IS NULL OR lialv.`url_name` = "", NULL, lialv.`url_name`) AS url_name, IF(lialv.`meta_title` IS NULL OR lialv.`meta_title` = "", NULL, lialv.`meta_title`) AS meta_title FROM `ps2_attribute_group` ag INNER JOIN `ps2_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 2) INNER JOIN `ps2_attribute` a ON a.`id_attribute_group` = ag.`id_attribute_group` INNER JOIN `ps2_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 2) INNER JOIN ps2_attribute_group_shop attribute_group_shop ON (attribute_group_shop.id_attribute_group = ag.id_attribute_group AND attribute_group_shop.id_shop = 1) INNER JOIN ps2_attribute_shop attribute_shop ON (attribute_shop.id_attribute = a.id_attribute AND attribute_shop.id_shop = 1) LEFT JOIN `ps2_layered_indexable_attribute_lang_value` lialv ON (a.`id_attribute` = lialv.`id_attribute` AND lialv.`id_lang` = 2) WHERE ag.id_attribute_group = 16 ORDER BY agl.`name` ASC, a.`position` ASC	2.612 ms	28	Yes		/modules/ps_facetedsearch/src/Filters/DataAccessor.php:96 /modules/ps_facetedsearch/src/Filters/Block.php:731 (getAttributes) /modules/ps_facetedsearch/src/Filters/Block.php:150 (getAttributesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/SupplierController.php:101 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /override/classes/Dispatcher.php:39 (dispatch) /index.php:28 (dispatch)
17	SELECT SQL_NO_CACHE h.`name` as hook, m.`id_module`, h.`id_hook`, m.`name` as module FROM `ps2_module` m INNER JOIN ps2_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 `ps2_hook_module` `hm` ON hm.`id_module` = m.`id_module` INNER JOIN `ps2_hook` `h` ON hm.`id_hook` = h.`id_hook` LEFT JOIN `ps2_module_group` `mg` ON mg.`id_module` = m.`id_module` WHERE (h.`name` != "paymentOptions") AND (hm.`id_shop` = 1) AND (mg.id_shop = 1 AND mg.`id_group` IN (1)) GROUP BY hm.id_hook, hm.id_module ORDER BY hm.`position`	2.233 ms	162	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)
360	SELECT SQL_NO_CACHE p.id_product_label, p.id_type, GROUP_CONCAT(CONCAT(a.attribute, ",", a.attribute_value) separator ";") as attr, p.priority, p.id_shop, IFNULL(lt.text_content, IFNULL(lt2.text_content, NULL)) as label_text_content, l.bg_color as label_bg_color, l.text_font as label_text_font, l.text_color as label_text_color, l.text_size as label_text_size, l.position as label_position, l.is_resize as label_is_resize, IFNULL(ba.id_background, IFNULL(ba2.id_background, NULL)) as id_background, IFNULL(ba.image, IFNULL(ba2.image, NULL)) as image, IFNULL(ba.is_perso, IFNULL(ba2.is_perso, NULL)) as is_perso, IFNULL(ba.id_lang, IFNULL(ba2.id_lang, NULL)) as id_lang , bt.id_lang, IFNULL(bt.text_content, IFNULL(bt2.text_content, NULL)) as banner_text_content, b.text_color as banner_text_color, b.bg_color as banner_bg_color FROM ps2_productlabel as p LEFT JOIN ps2_productlabel_banner as b ON b.id_product_label = p.id_product_label LEFT JOIN ps2_productlabel_banner_text as bt ON (bt.id_banner = b.id_banner AND bt.id_lang = 2) LEFT JOIN ps2_productlabel_banner_text as bt2 ON (bt2.id_banner = b.id_banner AND bt2.id_lang = 1) RIGHT JOIN ps2_productlabel_attribute as a ON a.id_product_label = p.id_product_label LEFT JOIN ps2_productlabel_label as l ON l.id_product_label = p.id_product_label LEFT JOIN ps2_productlabel_label_text as lt ON (lt.id_label = l.id_label AND lt.id_lang = 2) LEFT JOIN ps2_productlabel_label_text as lt2 ON (lt2.id_label = l.id_label AND lt2.id_lang = 1) LEFT JOIN ps2_productlabel_background as ba ON (ba.id_label = l.id_label AND ba.id_lang = 2) LEFT JOIN ps2_productlabel_background as ba2 ON (ba2.id_label = l.id_label AND ba2.id_lang = 1) WHERE p.id_type = 3 AND p.status = 1 AND p.id_shop = 1 GROUP BY p.id_product_label ORDER BY p.priority ASC, p.id_product_label DESC LIMIT 1	2.032 ms	2	Yes		/modules/productlabel/classes/ProductLabelDAO.php:908 /modules/productlabel/productlabel.php:436 (getBestAttrPlContent) /modules/productlabel/productlabel.php:315 (getProductLabelContent) /classes/Hook.php:1043 (hookDisplayProductPriceBlock) /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/dev/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/5d/45/99/5d459994de7a97d1e531eee4dc58ed09f2f1c2d9_2.file._product_prices.tpl.php:59 (__call) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_664227c1bcc941_14087234) /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/dev/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/09/ad/a9/09ada93a726f2f6aff9787ea2b5befa239d3a006_2.file.product.tpl.php:143 (_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/dev/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/09/ad/a9/09ada93a726f2f6aff9787ea2b5befa239d3a006_2.file.product.tpl.php:278 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/09/ad/a9/09ada93a726f2f6aff9787ea2b5befa239d3a006_2.file.product.tpl.php:35 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_664227c1ab6fa3_47533840) /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/dev/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/86/cc/82/86cc8292d9f2bb6f016859e0de073f7eebeb639e_2.file.productlist.tpl.php:37 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_664227c1a9eff3_40390945) /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/dev/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/8c/fd/e6/8cfde64064e6c4caece8236ef5e76acbacfa6bdb_2.file.products.tpl.php:31 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_664227c1a951c8_16044150) /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/dev/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/6f/48/65/6f48651488bf64f01fd220f82ba1a04cbe77d385_2.file.product-list.tpl.php:119 (_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/dev/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/6f/48/65/6f48651488bf64f01fd220f82ba1a04cbe77d385_2.file.product-list.tpl.php:216 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:186 (process) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/0f/1b/23/0f1b23a7a1818900f4ac29009e8910042422aaf7_2.file.layout-both-columns.tpl.php:340 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/0f/1b/23/0f1b23a7a1818900f4ac29009e8910042422aaf7_2.file.layout-both-columns.tpl.php:406 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/0f/1b/23/0f1b23a7a1818900f4ac29009e8910042422aaf7_2.file.layout-both-columns.tpl.php:106 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_664227c17e7fb0_03111850) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/c7/5c/9e/c75c9ef97cf0782412db68aec5c3cfd60f1007c5_2.file.layout-left-column.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_664227c17d0068_09189123) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/6f/48/65/6f48651488bf64f01fd220f82ba1a04cbe77d385_2.file.product-list.tpl.php:48 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_664227c17c7649_41398043) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/fe/71/30/fe7130aef2574ffa95f5c33c99a36b6041546837_2.file.supplier.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_664227d9267546_67320972) /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/Smarty/SmartyCustom.php:112 (fetch) /classes/controller/FrontController.php:760 (fetch) /classes/controller/FrontController.php:742 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /override/classes/Dispatcher.php:39 (dispatch) /index.php:28 (dispatch)
78	SELECT SQL_NO_CACHE `id_hook`, `name` FROM `ps2_hook` UNION SELECT `id_hook`, ha.`alias` as name FROM `ps2_hook_alias` ha INNER JOIN `ps2_hook` h ON ha.name = h.name	2.005 ms	0			/classes/Hook.php:1292 /classes/Hook.php:225 (getAllHookIds) /classes/Hook.php:506 (getIdByName) /classes/module/Module.php:2150 (isModuleRegisteredOnHook) /modules/nexixpay/nexixpay.php:150 (isRegisteredInHook) /modules/nexixpay/nexixpay.php:90 (registerHookIfNotRegistered) :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:993 (exec) /tools/profiling/Controller.php:48 (setMedia) /classes/Dispatcher.php:510 (run) /override/classes/Dispatcher.php:39 (dispatch) /index.php:28 (dispatch)
358	SELECT SQL_NO_CACHE p.id_product_label, p.priority, p.id_shop, p.id_type, IFNULL(lt.text_content, IFNULL(lt2.text_content, NULL)) as label_text_content, l.bg_color as label_bg_color, l.text_font as label_text_font, l.text_color as label_text_color, l.text_size as label_text_size, l.position as label_position, l.is_resize as label_is_resize, IFNULL(ba.id_background, IFNULL(ba2.id_background, NULL)) as id_background, IFNULL(ba.image, IFNULL(ba2.image, NULL)) as image, IFNULL(ba.is_perso, IFNULL(ba2.is_perso, NULL)) as is_perso, IFNULL(ba.id_lang, IFNULL(ba2.id_lang, NULL)) as id_lang , bt.id_lang, IFNULL(bt.text_content, IFNULL(bt2.text_content, NULL)) as banner_text_content, b.text_color as banner_text_color, b.bg_color as banner_bg_color FROM ps2_productlabel as p LEFT JOIN ps2_productlabel_banner as b ON b.id_product_label = p.id_product_label LEFT JOIN ps2_productlabel_banner_text as bt ON (bt.id_banner = b.id_banner AND bt.id_lang = 2) LEFT JOIN ps2_productlabel_banner_text as bt2 ON (bt2.id_banner = b.id_banner AND bt2.id_lang = 1) LEFT JOIN ps2_productlabel_label as l ON l.id_product_label = p.id_product_label LEFT JOIN ps2_productlabel_label_text as lt ON (lt.id_label = l.id_label AND lt.id_lang = 2) LEFT JOIN ps2_productlabel_label_text as lt2 ON (lt2.id_label = l.id_label AND lt2.id_lang = 1) LEFT JOIN ps2_productlabel_background as ba ON (ba.id_label = l.id_label AND ba.id_lang = 2) LEFT JOIN ps2_productlabel_background as ba2 ON (ba2.id_label = l.id_label AND ba2.id_lang = 1) WHERE p.id_type = 1 AND p.status = 1 AND p.id_shop = 1 ORDER BY p.priority ASC LIMIT 1	2.005 ms	4	Yes		/modules/productlabel/classes/ProductLabelDAO.php:675 /modules/productlabel/productlabel.php:420 (getPromoPlContent) /modules/productlabel/productlabel.php:315 (getProductLabelContent) /classes/Hook.php:1043 (hookDisplayProductPriceBlock) /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/dev/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/5d/45/99/5d459994de7a97d1e531eee4dc58ed09f2f1c2d9_2.file._product_prices.tpl.php:59 (__call) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_664227c1bcc941_14087234) /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/dev/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/09/ad/a9/09ada93a726f2f6aff9787ea2b5befa239d3a006_2.file.product.tpl.php:143 (_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/dev/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/09/ad/a9/09ada93a726f2f6aff9787ea2b5befa239d3a006_2.file.product.tpl.php:278 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/09/ad/a9/09ada93a726f2f6aff9787ea2b5befa239d3a006_2.file.product.tpl.php:35 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_664227c1ab6fa3_47533840) /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/dev/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/86/cc/82/86cc8292d9f2bb6f016859e0de073f7eebeb639e_2.file.productlist.tpl.php:37 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_664227c1a9eff3_40390945) /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/dev/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/8c/fd/e6/8cfde64064e6c4caece8236ef5e76acbacfa6bdb_2.file.products.tpl.php:31 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_664227c1a951c8_16044150) /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/dev/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/6f/48/65/6f48651488bf64f01fd220f82ba1a04cbe77d385_2.file.product-list.tpl.php:119 (_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/dev/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/6f/48/65/6f48651488bf64f01fd220f82ba1a04cbe77d385_2.file.product-list.tpl.php:216 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:186 (process) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/0f/1b/23/0f1b23a7a1818900f4ac29009e8910042422aaf7_2.file.layout-both-columns.tpl.php:340 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/0f/1b/23/0f1b23a7a1818900f4ac29009e8910042422aaf7_2.file.layout-both-columns.tpl.php:406 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/0f/1b/23/0f1b23a7a1818900f4ac29009e8910042422aaf7_2.file.layout-both-columns.tpl.php:106 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_664227c17e7fb0_03111850) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/c7/5c/9e/c75c9ef97cf0782412db68aec5c3cfd60f1007c5_2.file.layout-left-column.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_664227c17d0068_09189123) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/6f/48/65/6f48651488bf64f01fd220f82ba1a04cbe77d385_2.file.product-list.tpl.php:48 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_664227c17c7649_41398043) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/fe/71/30/fe7130aef2574ffa95f5c33c99a36b6041546837_2.file.supplier.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_664227d9267546_67320972) /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/Smarty/SmartyCustom.php:112 (fetch) /classes/controller/FrontController.php:760 (fetch) /classes/controller/FrontController.php:742 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /override/classes/Dispatcher.php:39 (dispatch) /index.php:28 (dispatch)
357	SELECT SQL_NO_CACHE p.id_product_label, p.id_type, p.priority, p.id_shop, IFNULL(p.start_date, "") as start_date, IFNULL(p.end_date, "") as end_date, IFNULL(lt.text_content, IFNULL(lt2.text_content, NULL)) as label_text_content, l.bg_color as label_bg_color, l.text_font as label_text_font, l.text_color as label_text_color, l.text_size as label_text_size, l.position as label_position, l.is_resize as label_is_resize, IFNULL(ba.id_background, IFNULL(ba2.id_background, NULL)) as id_background, IFNULL(ba.image, IFNULL(ba2.image, NULL)) as image, IFNULL(ba.is_perso, IFNULL(ba2.is_perso, NULL)) as is_perso, IFNULL(ba.id_lang, IFNULL(ba2.id_lang, NULL)) as id_lang , bt.id_lang, IFNULL(bt.text_content, IFNULL(bt2.text_content, NULL)) as banner_text_content, b.text_color as banner_text_color, b.bg_color as banner_bg_color FROM ps2_productlabel as p LEFT JOIN ps2_productlabel_banner as b ON b.id_product_label = p.id_product_label LEFT JOIN ps2_productlabel_banner_text as bt ON (bt.id_banner = b.id_banner AND bt.id_lang = 2) LEFT JOIN ps2_productlabel_banner_text as bt2 ON (bt2.id_banner = b.id_banner AND bt2.id_lang = 1) LEFT JOIN ps2_productlabel_item as i ON i.id_product_label = p.id_product_label LEFT JOIN ps2_productlabel_label as l ON l.id_product_label = p.id_product_label LEFT JOIN ps2_productlabel_label_text as lt ON (lt.id_label = l.id_label AND lt.id_lang = 2) LEFT JOIN ps2_productlabel_label_text as lt2 ON (lt2.id_label = l.id_label AND lt2.id_lang = 1) LEFT JOIN ps2_productlabel_background as ba ON (ba.id_label = l.id_label AND ba.id_lang = 2) LEFT JOIN ps2_productlabel_background as ba2 ON (ba2.id_label = l.id_label AND ba2.id_lang = 1) WHERE ((i.id_item = 1813 AND i.type_item = "Product") OR (i.id_item = 2 AND i.type_item = "Category") OR (i.type_item = "Category" AND i.id_item = (SELECT DISTINCT(cp.id_category) FROM ps2_category_product as cp WHERE cp.id_category = i.id_item AND cp.id_product = 1813))) AND p.status = 1 AND p.id_shop = 1 AND ((start_date <= "2024-05-13" OR start_date = "0000-00-00") AND (end_date >= "2024-05-13" OR end_date = "0000-00-00")) ORDER BY p.priority ASC LIMIT 1	1.951 ms	4	Yes		/modules/productlabel/classes/ProductLabelDAO.php:731 /modules/productlabel/productlabel.php:412 (getManualPlContent) /modules/productlabel/productlabel.php:315 (getProductLabelContent) /classes/Hook.php:1043 (hookDisplayProductPriceBlock) /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/dev/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/5d/45/99/5d459994de7a97d1e531eee4dc58ed09f2f1c2d9_2.file._product_prices.tpl.php:59 (__call) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_664227c1bcc941_14087234) /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/dev/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/09/ad/a9/09ada93a726f2f6aff9787ea2b5befa239d3a006_2.file.product.tpl.php:143 (_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/dev/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/09/ad/a9/09ada93a726f2f6aff9787ea2b5befa239d3a006_2.file.product.tpl.php:278 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/09/ad/a9/09ada93a726f2f6aff9787ea2b5befa239d3a006_2.file.product.tpl.php:35 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_664227c1ab6fa3_47533840) /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/dev/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/86/cc/82/86cc8292d9f2bb6f016859e0de073f7eebeb639e_2.file.productlist.tpl.php:37 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_664227c1a9eff3_40390945) /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/dev/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/8c/fd/e6/8cfde64064e6c4caece8236ef5e76acbacfa6bdb_2.file.products.tpl.php:31 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_664227c1a951c8_16044150) /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/dev/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/6f/48/65/6f48651488bf64f01fd220f82ba1a04cbe77d385_2.file.product-list.tpl.php:119 (_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/dev/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/6f/48/65/6f48651488bf64f01fd220f82ba1a04cbe77d385_2.file.product-list.tpl.php:216 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:186 (process) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/0f/1b/23/0f1b23a7a1818900f4ac29009e8910042422aaf7_2.file.layout-both-columns.tpl.php:340 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/0f/1b/23/0f1b23a7a1818900f4ac29009e8910042422aaf7_2.file.layout-both-columns.tpl.php:406 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/0f/1b/23/0f1b23a7a1818900f4ac29009e8910042422aaf7_2.file.layout-both-columns.tpl.php:106 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_664227c17e7fb0_03111850) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/c7/5c/9e/c75c9ef97cf0782412db68aec5c3cfd60f1007c5_2.file.layout-left-column.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_664227c17d0068_09189123) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/6f/48/65/6f48651488bf64f01fd220f82ba1a04cbe77d385_2.file.product-list.tpl.php:48 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_664227c17c7649_41398043) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/fe/71/30/fe7130aef2574ffa95f5c33c99a36b6041546837_2.file.supplier.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_664227d9267546_67320972) /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/Smarty/SmartyCustom.php:112 (fetch) /classes/controller/FrontController.php:760 (fetch) /classes/controller/FrontController.php:742 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /override/classes/Dispatcher.php:39 (dispatch) /index.php:28 (dispatch)
349	SELECT SQL_NO_CACHE * FROM `ps2_product` a LEFT JOIN `ps2_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1 WHERE (a.`id_product` = 1813) LIMIT 1	1.932 ms	1			/src/Adapter/EntityMapper.php:71 /classes/ObjectModel.php:283 (load) /tools/profiling/ObjectModel.php:32 (__construct) /classes/Product.php:725 (__construct) /override/classes/Product.php:40 (__construct) /src/Adapter/Presenter/Product/ProductLazyArray.php:662 (__construct) /src/Adapter/Presenter/Product/ProductLazyArray.php:505 (shouldShowOutOfStockLabel) /src/Adapter/Presenter/AbstractLazyArray.php:261 (getFlags) /var/cache/dev/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/4c/91/2a/4c912ab707eee1cc9b456cd3aa8b9c6a1a5cfe94_2.file.product-flags.tpl.php:46 (offsetGet) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/4c/91/2a/4c912ab707eee1cc9b456cd3aa8b9c6a1a5cfe94_2.file.product-flags.tpl.php:29 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_664227c1ad1759_79643962) /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/dev/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/09/ad/a9/09ada93a726f2f6aff9787ea2b5befa239d3a006_2.file.product.tpl.php:235 (_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/dev/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/09/ad/a9/09ada93a726f2f6aff9787ea2b5befa239d3a006_2.file.product.tpl.php:35 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_664227c1ab6fa3_47533840) /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/dev/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/86/cc/82/86cc8292d9f2bb6f016859e0de073f7eebeb639e_2.file.productlist.tpl.php:37 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_664227c1a9eff3_40390945) /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/dev/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/8c/fd/e6/8cfde64064e6c4caece8236ef5e76acbacfa6bdb_2.file.products.tpl.php:31 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_664227c1a951c8_16044150) /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/dev/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/6f/48/65/6f48651488bf64f01fd220f82ba1a04cbe77d385_2.file.product-list.tpl.php:119 (_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/dev/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/6f/48/65/6f48651488bf64f01fd220f82ba1a04cbe77d385_2.file.product-list.tpl.php:216 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:186 (process) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/0f/1b/23/0f1b23a7a1818900f4ac29009e8910042422aaf7_2.file.layout-both-columns.tpl.php:340 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/0f/1b/23/0f1b23a7a1818900f4ac29009e8910042422aaf7_2.file.layout-both-columns.tpl.php:406 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/0f/1b/23/0f1b23a7a1818900f4ac29009e8910042422aaf7_2.file.layout-both-columns.tpl.php:106 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_664227c17e7fb0_03111850) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/c7/5c/9e/c75c9ef97cf0782412db68aec5c3cfd60f1007c5_2.file.layout-left-column.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_664227c17d0068_09189123) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/6f/48/65/6f48651488bf64f01fd220f82ba1a04cbe77d385_2.file.product-list.tpl.php:48 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_664227c17c7649_41398043) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/fe/71/30/fe7130aef2574ffa95f5c33c99a36b6041546837_2.file.supplier.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_664227d9267546_67320972) /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/Smarty/SmartyCustom.php:112 (fetch) /classes/controller/FrontController.php:760 (fetch) /classes/controller/FrontController.php:742 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /override/classes/Dispatcher.php:39 (dispatch) /index.php:28 (dispatch)
143	SELECT SQL_NO_CACHE m.*, ml.`description`, ml.`short_description` FROM `ps2_manufacturer` m INNER JOIN ps2_manufacturer_shop manufacturer_shop ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 1)INNER JOIN `ps2_manufacturer_lang` ml ON (m.`id_manufacturer` = ml.`id_manufacturer` AND ml.`id_lang` = 2)WHERE 1 AND m.`active` = 1 ORDER BY m.`name` ASC	1.913 ms	95	Yes		/classes/Manufacturer.php:211 /modules/ps_facetedsearch/src/Filters/Block.php:652 (getManufacturers) /modules/ps_facetedsearch/src/Filters/Block.php:146 (getManufacturersBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/SupplierController.php:101 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /override/classes/Dispatcher.php:39 (dispatch) /index.php:28 (dispatch)
140	SELECT SQL_NO_CACHE psi.price_min, MIN(price_min) as min, MAX(price_max) as max FROM ps2_product p INNER JOIN ps2_layered_price_index psi ON (psi.id_product = p.id_product AND psi.id_shop = 1 AND psi.id_currency = 1 AND psi.id_country = 21) INNER JOIN ps2_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps2_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps2_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps2_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN ps2_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps2_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps2_feature_product fp_1 ON (p.id_product = fp_1.id_product) WHERE ((pac.id_attribute=1066)) AND ((fp_1.id_feature_value=54)) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND p.id_supplier='2'	1.901 ms	50			/modules/ps_facetedsearch/src/Adapter/MySQL.php:86 /modules/ps_facetedsearch/src/Adapter/MySQL.php:58 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:250 (getMinMaxPriceValue) /modules/ps_facetedsearch/src/Filters/Block.php:131 (getPriceRangeBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/SupplierController.php:101 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /override/classes/Dispatcher.php:39 (dispatch) /index.php:28 (dispatch)
133	SELECT SQL_NO_CACHE ag.id_attribute_group, agl.public_name as attribute_group_name, is_color_group, IF(liaglv.`url_name` IS NULL OR liaglv.`url_name` = "", NULL, liaglv.`url_name`) AS url_name, IF(liaglv.`meta_title` IS NULL OR liaglv.`meta_title` = "", NULL, liaglv.`meta_title`) AS meta_title, IFNULL(liag.indexable, TRUE) AS indexable FROM `ps2_attribute_group` ag INNER JOIN ps2_attribute_group_shop attribute_group_shop ON (attribute_group_shop.id_attribute_group = ag.id_attribute_group AND attribute_group_shop.id_shop = 1) LEFT JOIN `ps2_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 2) LEFT JOIN `ps2_layered_indexable_attribute_group` liag ON (ag.`id_attribute_group` = liag.`id_attribute_group`) LEFT JOIN `ps2_layered_indexable_attribute_group_lang_value` AS liaglv ON (ag.`id_attribute_group` = liaglv.`id_attribute_group` AND agl.`id_lang` = 2) GROUP BY ag.id_attribute_group ORDER BY ag.`position` ASC	1.832 ms	20	Yes	Yes	/modules/ps_facetedsearch/src/Filters/DataAccessor.php:137 /modules/ps_facetedsearch/src/Filters/Converter.php:413 (getAttributesGroups) /modules/ps_facetedsearch/src/Product/SearchProvider.php:163 (createFacetedSearchFiltersFromQuery) /classes/controller/ProductListingFrontController.php:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/SupplierController.php:101 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /override/classes/Dispatcher.php:39 (dispatch) /index.php:28 (dispatch)
153	SELECT SQL_NO_CACHE DISTINCT a.`id_attribute`, a.`color`, al.`name`, agl.`id_attribute_group`, IF(lialv.`url_name` IS NULL OR lialv.`url_name` = "", NULL, lialv.`url_name`) AS url_name, IF(lialv.`meta_title` IS NULL OR lialv.`meta_title` = "", NULL, lialv.`meta_title`) AS meta_title FROM `ps2_attribute_group` ag INNER JOIN `ps2_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 2) INNER JOIN `ps2_attribute` a ON a.`id_attribute_group` = ag.`id_attribute_group` INNER JOIN `ps2_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 2) INNER JOIN ps2_attribute_group_shop attribute_group_shop ON (attribute_group_shop.id_attribute_group = ag.id_attribute_group AND attribute_group_shop.id_shop = 1) INNER JOIN ps2_attribute_shop attribute_shop ON (attribute_shop.id_attribute = a.id_attribute AND attribute_shop.id_shop = 1) LEFT JOIN `ps2_layered_indexable_attribute_lang_value` lialv ON (a.`id_attribute` = lialv.`id_attribute` AND lialv.`id_lang` = 2) WHERE ag.id_attribute_group = 3 ORDER BY agl.`name` ASC, a.`position` ASC	1.823 ms	168	Yes		/modules/ps_facetedsearch/src/Filters/DataAccessor.php:96 /modules/ps_facetedsearch/src/Filters/Block.php:731 (getAttributes) /modules/ps_facetedsearch/src/Filters/Block.php:150 (getAttributesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/SupplierController.php:101 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /override/classes/Dispatcher.php:39 (dispatch) /index.php:28 (dispatch)
191	SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity, COALESCE(SUM(first_level_quantity), 0) as quantity FROM (SELECT cp.`quantity` as first_level_quantity, 0 as pack_quantity FROM `ps2_cart_product` cp WHERE cp.`id_product_attribute` = 4654 AND cp.`id_customization` = 0 AND cp.`id_cart` = 0 AND cp.`id_product` = 1813 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity FROM `ps2_cart_product` cp JOIN `ps2_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `ps2_product` pr ON p.`id_product_pack` = pr.`id_product` WHERE cp.`id_product_attribute` = 4654 AND cp.`id_customization` = 0 AND cp.`id_cart` = 0 AND p.`id_product_item` = 1813 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1	1.792 ms	0			/classes/Cart.php:1423 /classes/Product.php:4357 (getProductQuantity) /classes/Product.php:5808 (getQuantity) /override/classes/Product.php:354 (getProductProperties) /classes/ProductAssembler.php:209 (getProductProperties) /classes/controller/ProductListingFrontController.php:108 (assembleProducts) /classes/controller/ProductListingFrontController.php:379 (prepareMultipleProductsForTemplate) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/SupplierController.php:101 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /override/classes/Dispatcher.php:39 (dispatch) /index.php:28 (dispatch)
361	SELECT SQL_NO_CACHE p.id_product_label, p.id_type, a.attribute, a.attribute_value, p.priority, p.id_shop, IFNULL(lt.text_content, IFNULL(lt2.text_content, NULL)) as label_text_content, l.bg_color as label_bg_color, l.text_font as label_text_font, l.text_color as label_text_color, l.text_size as label_text_size, l.position as label_position, l.is_resize as label_is_resize, IFNULL(ba.id_background, IFNULL(ba2.id_background, NULL)) as id_background, IFNULL(ba.image, IFNULL(ba2.image, NULL)) as image, IFNULL(ba.is_perso, IFNULL(ba2.is_perso, NULL)) as is_perso, IFNULL(ba.id_lang, IFNULL(ba2.id_lang, NULL)) as id_lang , bt.id_lang, IFNULL(bt.text_content, IFNULL(bt2.text_content, NULL)) as banner_text_content, b.text_color as banner_text_color, b.bg_color as banner_bg_color FROM ps2_productlabel as p LEFT JOIN ps2_productlabel_banner as b ON b.id_product_label = p.id_product_label LEFT JOIN ps2_productlabel_banner_text as bt ON (bt.id_banner = b.id_banner AND bt.id_lang = 2) LEFT JOIN ps2_productlabel_banner_text as bt2 ON (bt2.id_banner = b.id_banner AND bt2.id_lang = 1) RIGHT JOIN ps2_productlabel_attribute as a ON a.id_product_label = p.id_product_label LEFT JOIN ps2_productlabel_label as l ON l.id_product_label = p.id_product_label LEFT JOIN ps2_productlabel_label_text as lt ON (lt.id_label = l.id_label AND lt.id_lang = 2) LEFT JOIN ps2_productlabel_label_text as lt2 ON (lt2.id_label = l.id_label AND lt2.id_lang = 1) LEFT JOIN ps2_productlabel_background as ba ON (ba.id_label = l.id_label AND ba.id_lang = 2) LEFT JOIN ps2_productlabel_background as ba2 ON (ba2.id_label = l.id_label AND ba2.id_lang = 1) WHERE p.id_type = 5 AND p.status = 1 AND p.id_shop = 1 ORDER BY p.priority ASC LIMIT 1	1.735 ms	2	Yes		/modules/productlabel/classes/ProductLabelDAO.php:845 /modules/productlabel/productlabel.php:444 (getShippingAttrPlContent) /modules/productlabel/productlabel.php:315 (getProductLabelContent) /classes/Hook.php:1043 (hookDisplayProductPriceBlock) /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/dev/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/5d/45/99/5d459994de7a97d1e531eee4dc58ed09f2f1c2d9_2.file._product_prices.tpl.php:59 (__call) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_664227c1bcc941_14087234) /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/dev/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/09/ad/a9/09ada93a726f2f6aff9787ea2b5befa239d3a006_2.file.product.tpl.php:143 (_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/dev/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/09/ad/a9/09ada93a726f2f6aff9787ea2b5befa239d3a006_2.file.product.tpl.php:278 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/09/ad/a9/09ada93a726f2f6aff9787ea2b5befa239d3a006_2.file.product.tpl.php:35 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_664227c1ab6fa3_47533840) /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/dev/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/86/cc/82/86cc8292d9f2bb6f016859e0de073f7eebeb639e_2.file.productlist.tpl.php:37 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_664227c1a9eff3_40390945) /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/dev/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/8c/fd/e6/8cfde64064e6c4caece8236ef5e76acbacfa6bdb_2.file.products.tpl.php:31 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_664227c1a951c8_16044150) /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/dev/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/6f/48/65/6f48651488bf64f01fd220f82ba1a04cbe77d385_2.file.product-list.tpl.php:119 (_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/dev/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/6f/48/65/6f48651488bf64f01fd220f82ba1a04cbe77d385_2.file.product-list.tpl.php:216 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:186 (process) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/0f/1b/23/0f1b23a7a1818900f4ac29009e8910042422aaf7_2.file.layout-both-columns.tpl.php:340 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/0f/1b/23/0f1b23a7a1818900f4ac29009e8910042422aaf7_2.file.layout-both-columns.tpl.php:406 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/0f/1b/23/0f1b23a7a1818900f4ac29009e8910042422aaf7_2.file.layout-both-columns.tpl.php:106 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_664227c17e7fb0_03111850) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/c7/5c/9e/c75c9ef97cf0782412db68aec5c3cfd60f1007c5_2.file.layout-left-column.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_664227c17d0068_09189123) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/6f/48/65/6f48651488bf64f01fd220f82ba1a04cbe77d385_2.file.product-list.tpl.php:48 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_664227c17c7649_41398043) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/fe/71/30/fe7130aef2574ffa95f5c33c99a36b6041546837_2.file.supplier.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_664227d9267546_67320972) /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/Smarty/SmartyCustom.php:112 (fetch) /classes/controller/FrontController.php:760 (fetch) /classes/controller/FrontController.php:742 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /override/classes/Dispatcher.php:39 (dispatch) /index.php:28 (dispatch)
311	SELECT SQL_NO_CACHE c.id_parent, c.id_category, cl.name, cl.description, cl.link_rewrite FROM `ps2_category` c INNER JOIN `ps2_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.`id_lang` = 2 AND cl.id_shop = 1 ) INNER JOIN `ps2_category_shop` cs ON (cs.`id_category` = c.`id_category` AND cs.`id_shop` = 1) WHERE (c.`active` = 1 OR c.`id_category` = 2) AND c.`id_category` != 1 AND `level_depth` <= 5 AND nleft >= 2 AND nright <= 73 AND c.id_category IN ( SELECT id_category FROM `ps2_category_group` WHERE `id_group` IN (1) ) ORDER BY `level_depth` ASC, cs.`position` ASC	1.692 ms	37	Yes		/modules/ps_categorytree/ps_categorytree.php:166 /modules/ps_categorytree/ps_categorytree.php:350 (getCategories) /modules/ps_categorytree/ps_categorytree.php:330 (getWidgetVariables) /classes/Hook.php:1054 (renderWidget) /tools/profiling/Hook.php:64 (coreRenderWidget) /classes/Hook.php:1000 (coreRenderWidget) /config/smarty.config.inc.php:198 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/dev/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/0f/1b/23/0f1b23a7a1818900f4ac29009e8910042422aaf7_2.file.layout-both-columns.tpl.php:309 (__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/dev/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/0f/1b/23/0f1b23a7a1818900f4ac29009e8910042422aaf7_2.file.layout-both-columns.tpl.php:401 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/0f/1b/23/0f1b23a7a1818900f4ac29009e8910042422aaf7_2.file.layout-both-columns.tpl.php:106 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_664227c17e7fb0_03111850) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/c7/5c/9e/c75c9ef97cf0782412db68aec5c3cfd60f1007c5_2.file.layout-left-column.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_664227c17d0068_09189123) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/6f/48/65/6f48651488bf64f01fd220f82ba1a04cbe77d385_2.file.product-list.tpl.php:48 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_664227c17c7649_41398043) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/fe/71/30/fe7130aef2574ffa95f5c33c99a36b6041546837_2.file.supplier.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_664227d9267546_67320972) /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/Smarty/SmartyCustom.php:112 (fetch) /classes/controller/FrontController.php:760 (fetch) /classes/controller/FrontController.php:742 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /override/classes/Dispatcher.php:39 (dispatch) /index.php:28 (dispatch)
141	SELECT SQL_NO_CACHE DISTINCT a.`id_attribute`, a.`color`, al.`name`, agl.`id_attribute_group`, IF(lialv.`url_name` IS NULL OR lialv.`url_name` = "", NULL, lialv.`url_name`) AS url_name, IF(lialv.`meta_title` IS NULL OR lialv.`meta_title` = "", NULL, lialv.`meta_title`) AS meta_title FROM `ps2_attribute_group` ag INNER JOIN `ps2_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 2) INNER JOIN `ps2_attribute` a ON a.`id_attribute_group` = ag.`id_attribute_group` INNER JOIN `ps2_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 2) INNER JOIN ps2_attribute_group_shop attribute_group_shop ON (attribute_group_shop.id_attribute_group = ag.id_attribute_group AND attribute_group_shop.id_shop = 1) INNER JOIN ps2_attribute_shop attribute_shop ON (attribute_shop.id_attribute = a.id_attribute AND attribute_shop.id_shop = 1) LEFT JOIN `ps2_layered_indexable_attribute_lang_value` lialv ON (a.`id_attribute` = lialv.`id_attribute` AND lialv.`id_lang` = 2) WHERE ag.id_attribute_group = 18 ORDER BY agl.`name` ASC, a.`position` ASC	1.684 ms	124	Yes		/modules/ps_facetedsearch/src/Filters/DataAccessor.php:96 /modules/ps_facetedsearch/src/Filters/Block.php:731 (getAttributes) /modules/ps_facetedsearch/src/Filters/Block.php:150 (getAttributesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/SupplierController.php:101 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /override/classes/Dispatcher.php:39 (dispatch) /index.php:28 (dispatch)
135	SELECT SQL_NO_CACHE DISTINCT f.id_feature, f., fl., IF(liflv.`url_name` IS NULL OR liflv.`url_name` = "", NULL, liflv.`url_name`) AS url_name, IF(liflv.`meta_title` IS NULL OR liflv.`meta_title` = "", NULL, liflv.`meta_title`) AS meta_title, lif.indexable FROM `ps2_feature` f INNER JOIN ps2_feature_shop feature_shop ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1) LEFT JOIN `ps2_feature_lang` fl ON (f.`id_feature` = fl.`id_feature` AND fl.`id_lang` = 2) LEFT JOIN `ps2_layered_indexable_feature` lif ON (f.`id_feature` = lif.`id_feature`) LEFT JOIN `ps2_layered_indexable_feature_lang_value` liflv ON (f.`id_feature` = liflv.`id_feature` AND liflv.`id_lang` = 2) ORDER BY f.`position` ASC	1.636 ms	196	Yes		/modules/ps_facetedsearch/src/Filters/DataAccessor.php:171 /modules/ps_facetedsearch/src/Filters/Converter.php:388 (getFeatures) /modules/ps_facetedsearch/src/Product/SearchProvider.php:163 (createFacetedSearchFiltersFromQuery) /classes/controller/ProductListingFrontController.php:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/SupplierController.php:101 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /override/classes/Dispatcher.php:39 (dispatch) /index.php:28 (dispatch)
353	SELECT SQL_NO_CACHE pac.id_product_attribute, GROUP_CONCAT(agl.`name`, ' - ',al.`name` ORDER BY agl.`id_attribute_group` SEPARATOR ', ') as attribute_designation FROM `ps2_product_attribute_combination` pac LEFT JOIN `ps2_attribute` a ON a.`id_attribute` = pac.`id_attribute` LEFT JOIN `ps2_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group` LEFT JOIN `ps2_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 2) LEFT JOIN `ps2_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 2) WHERE pac.id_product_attribute IN (4654) GROUP BY pac.id_product_attribute ORDER BY pac.id_product_attribute	1.611 ms	17			/classes/Product.php:2752 /src/Adapter/Presenter/Product/ProductLazyArray.php:667 (getAttributesResume) /src/Adapter/Presenter/Product/ProductLazyArray.php:505 (shouldShowOutOfStockLabel) /src/Adapter/Presenter/AbstractLazyArray.php:261 (getFlags) /var/cache/dev/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/4c/91/2a/4c912ab707eee1cc9b456cd3aa8b9c6a1a5cfe94_2.file.product-flags.tpl.php:46 (offsetGet) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/4c/91/2a/4c912ab707eee1cc9b456cd3aa8b9c6a1a5cfe94_2.file.product-flags.tpl.php:29 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_664227c1ad1759_79643962) /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/dev/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/09/ad/a9/09ada93a726f2f6aff9787ea2b5befa239d3a006_2.file.product.tpl.php:235 (_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/dev/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/09/ad/a9/09ada93a726f2f6aff9787ea2b5befa239d3a006_2.file.product.tpl.php:35 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_664227c1ab6fa3_47533840) /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/dev/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/86/cc/82/86cc8292d9f2bb6f016859e0de073f7eebeb639e_2.file.productlist.tpl.php:37 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_664227c1a9eff3_40390945) /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/dev/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/8c/fd/e6/8cfde64064e6c4caece8236ef5e76acbacfa6bdb_2.file.products.tpl.php:31 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_664227c1a951c8_16044150) /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/dev/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/6f/48/65/6f48651488bf64f01fd220f82ba1a04cbe77d385_2.file.product-list.tpl.php:119 (_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/dev/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/6f/48/65/6f48651488bf64f01fd220f82ba1a04cbe77d385_2.file.product-list.tpl.php:216 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:186 (process) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/0f/1b/23/0f1b23a7a1818900f4ac29009e8910042422aaf7_2.file.layout-both-columns.tpl.php:340 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/0f/1b/23/0f1b23a7a1818900f4ac29009e8910042422aaf7_2.file.layout-both-columns.tpl.php:406 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/0f/1b/23/0f1b23a7a1818900f4ac29009e8910042422aaf7_2.file.layout-both-columns.tpl.php:106 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_664227c17e7fb0_03111850) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/c7/5c/9e/c75c9ef97cf0782412db68aec5c3cfd60f1007c5_2.file.layout-left-column.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_664227c17d0068_09189123) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/6f/48/65/6f48651488bf64f01fd220f82ba1a04cbe77d385_2.file.product-list.tpl.php:48 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_664227c17c7649_41398043) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/fe/71/30/fe7130aef2574ffa95f5c33c99a36b6041546837_2.file.supplier.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_664227d9267546_67320972) /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/Smarty/SmartyCustom.php:112 (fetch) /classes/controller/FrontController.php:760 (fetch) /classes/controller/FrontController.php:742 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /override/classes/Dispatcher.php:39 (dispatch) /index.php:28 (dispatch)
189	SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity, COALESCE(SUM(first_level_quantity), 0) as quantity FROM (SELECT cp.`quantity` as first_level_quantity, 0 as pack_quantity FROM `ps2_cart_product` cp WHERE cp.`id_product_attribute` = 0 AND cp.`id_customization` = 0 AND cp.`id_cart` = 0 AND cp.`id_product` = 1813 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity FROM `ps2_cart_product` cp JOIN `ps2_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `ps2_product` pr ON p.`id_product_pack` = pr.`id_product` WHERE cp.`id_product_attribute` = 0 AND cp.`id_customization` = 0 AND cp.`id_cart` = 0 AND p.`id_product_item` = 1813 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1	1.572 ms	0			/classes/Cart.php:1423 /classes/Product.php:4357 (getProductQuantity) /classes/Product.php:5797 (getQuantity) /override/classes/Product.php:354 (getProductProperties) /classes/ProductAssembler.php:209 (getProductProperties) /classes/controller/ProductListingFrontController.php:108 (assembleProducts) /classes/controller/ProductListingFrontController.php:379 (prepareMultipleProductsForTemplate) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/SupplierController.php:101 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /override/classes/Dispatcher.php:39 (dispatch) /index.php:28 (dispatch)
270	SELECT SQL_NO_CACHE m.`id_module` as `active`, ms.`id_module` as `shop_active` FROM `ps2_module` m LEFT JOIN `ps2_module_shop` ms ON m.`id_module` = ms.`id_module` WHERE `name` = "watermark" AND ms.`id_shop` IN (1) LIMIT 1	1.524 ms	0			/src/Adapter/Module/ModuleDataProvider.php:217 /src/Core/Module/ModuleManager.php:339 (isEnabled) /override/classes/Link.php:44 (isEnabled) /src/Adapter/Image/ImageRetriever.php:251 (getImageLink) /src/Adapter/Image/ImageRetriever.php:111 (getImage) :undefined (PrestaShop\PrestaShop\Adapter\Image\{closure}) /src/Adapter/Image/ImageRetriever.php:104 (array_map) /src/Adapter/Presenter/Product/ProductLazyArray.php:688 (getAllProductImages) /src/Adapter/Presenter/Product/ProductLazyArray.php:127 (fillImages) /src/Adapter/Presenter/Product/ProductListingPresenter.php:57 (__construct) /classes/controller/ProductListingFrontController.php:119 (present) /classes/controller/ProductListingFrontController.php:379 (prepareMultipleProductsForTemplate) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/SupplierController.php:101 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /override/classes/Dispatcher.php:39 (dispatch) /index.php:28 (dispatch)
354	SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by FROM `ps2_product_attribute` pa INNER JOIN ps2_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) JOIN `ps2_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`) JOIN `ps2_attribute` a ON (a.`id_attribute` = pac.`id_attribute`) JOIN `ps2_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 2) JOIN `ps2_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`) WHERE pa.`id_product` IN (1813) AND ag.`is_color_group` = 1 GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` ORDER BY a.`position` ASC;	1.510 ms	7	Yes	Yes	/classes/Product.php:4520 /src/Adapter/Product/ProductColorsRetriever.php:43 (getAttributesColorList) /src/Adapter/Presenter/Product/ProductLazyArray.php:528 (getColoredVariants) /src/Adapter/Presenter/AbstractLazyArray.php:261 (getMainVariants) /var/cache/dev/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/09/ad/a9/09ada93a726f2f6aff9787ea2b5befa239d3a006_2.file.product.tpl.php:117 (offsetGet) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/09/ad/a9/09ada93a726f2f6aff9787ea2b5befa239d3a006_2.file.product.tpl.php:265 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/09/ad/a9/09ada93a726f2f6aff9787ea2b5befa239d3a006_2.file.product.tpl.php:35 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_664227c1ab6fa3_47533840) /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/dev/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/86/cc/82/86cc8292d9f2bb6f016859e0de073f7eebeb639e_2.file.productlist.tpl.php:37 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_664227c1a9eff3_40390945) /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/dev/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/8c/fd/e6/8cfde64064e6c4caece8236ef5e76acbacfa6bdb_2.file.products.tpl.php:31 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_664227c1a951c8_16044150) /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/dev/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/6f/48/65/6f48651488bf64f01fd220f82ba1a04cbe77d385_2.file.product-list.tpl.php:119 (_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/dev/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/6f/48/65/6f48651488bf64f01fd220f82ba1a04cbe77d385_2.file.product-list.tpl.php:216 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:186 (process) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/0f/1b/23/0f1b23a7a1818900f4ac29009e8910042422aaf7_2.file.layout-both-columns.tpl.php:340 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/0f/1b/23/0f1b23a7a1818900f4ac29009e8910042422aaf7_2.file.layout-both-columns.tpl.php:406 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/0f/1b/23/0f1b23a7a1818900f4ac29009e8910042422aaf7_2.file.layout-both-columns.tpl.php:106 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_664227c17e7fb0_03111850) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/c7/5c/9e/c75c9ef97cf0782412db68aec5c3cfd60f1007c5_2.file.layout-left-column.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_664227c17d0068_09189123) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/6f/48/65/6f48651488bf64f01fd220f82ba1a04cbe77d385_2.file.product-list.tpl.php:48 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_664227c17c7649_41398043) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/fe/71/30/fe7130aef2574ffa95f5c33c99a36b6041546837_2.file.supplier.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_664227d9267546_67320972) /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/Smarty/SmartyCustom.php:112 (fetch) /classes/controller/FrontController.php:760 (fetch) /classes/controller/FrontController.php:742 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /override/classes/Dispatcher.php:39 (dispatch) /index.php:28 (dispatch)
132	SELECT SQL_NO_CACHE type, id_value, filter_show_limit, filter_type FROM ps2_layered_category WHERE controller = 'supplier' AND id_category = 0 AND id_shop = 1 GROUP BY `type`, id_value ORDER BY position ASC	1.510 ms	78	Yes	Yes	/modules/ps_facetedsearch/src/Filters/Provider.php:61 /modules/ps_facetedsearch/src/Filters/Converter.php:263 (getFiltersForQuery) /modules/ps_facetedsearch/src/Product/SearchProvider.php:163 (createFacetedSearchFiltersFromQuery) /classes/controller/ProductListingFrontController.php:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/SupplierController.php:101 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /override/classes/Dispatcher.php:39 (dispatch) /index.php:28 (dispatch)
359	SELECT SQL_NO_CACHE p.id_product_label, p.id_type, a.attribute, a.attribute_value, p.priority, p.id_shop, IFNULL(lt.text_content, IFNULL(lt2.text_content, NULL)) as label_text_content, l.bg_color as label_bg_color, l.text_font as label_text_font, l.text_color as label_text_color, l.text_size as label_text_size, l.position as label_position, l.is_resize as label_is_resize, IFNULL(ba.id_background, IFNULL(ba2.id_background, NULL)) as id_background, IFNULL(ba.image, IFNULL(ba2.image, NULL)) as image, IFNULL(ba.is_perso, IFNULL(ba2.is_perso, NULL)) as is_perso, IFNULL(ba.id_lang, IFNULL(ba2.id_lang, NULL)) as id_lang , bt.id_lang, IFNULL(bt.text_content, IFNULL(bt2.text_content, NULL)) as banner_text_content, b.text_color as banner_text_color, b.bg_color as banner_bg_color FROM ps2_productlabel as p LEFT JOIN ps2_productlabel_banner as b ON b.id_product_label = p.id_product_label LEFT JOIN ps2_productlabel_banner_text as bt ON (bt.id_banner = b.id_banner AND bt.id_lang = 2) LEFT JOIN ps2_productlabel_banner_text as bt2 ON (bt2.id_banner = b.id_banner AND bt2.id_lang = 1) RIGHT JOIN ps2_productlabel_attribute as a ON a.id_product_label = p.id_product_label LEFT JOIN ps2_productlabel_label as l ON l.id_product_label = p.id_product_label LEFT JOIN ps2_productlabel_label_text as lt ON (lt.id_label = l.id_label AND lt.id_lang = 2) LEFT JOIN ps2_productlabel_label_text as lt2 ON (lt2.id_label = l.id_label AND lt2.id_lang = 1) LEFT JOIN ps2_productlabel_background as ba ON (ba.id_label = l.id_label AND ba.id_lang = 2) LEFT JOIN ps2_productlabel_background as ba2 ON (ba2.id_label = l.id_label AND ba2.id_lang = 1) WHERE p.id_type = 2 AND p.status = 1 AND p.id_shop = 1 ORDER BY p.priority ASC LIMIT 1	1.498 ms	2	Yes		/modules/productlabel/classes/ProductLabelDAO.php:780 /modules/productlabel/productlabel.php:428 (getNewAttrPlContent) /modules/productlabel/productlabel.php:315 (getProductLabelContent) /classes/Hook.php:1043 (hookDisplayProductPriceBlock) /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/dev/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/5d/45/99/5d459994de7a97d1e531eee4dc58ed09f2f1c2d9_2.file._product_prices.tpl.php:59 (__call) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_664227c1bcc941_14087234) /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/dev/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/09/ad/a9/09ada93a726f2f6aff9787ea2b5befa239d3a006_2.file.product.tpl.php:143 (_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/dev/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/09/ad/a9/09ada93a726f2f6aff9787ea2b5befa239d3a006_2.file.product.tpl.php:278 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/09/ad/a9/09ada93a726f2f6aff9787ea2b5befa239d3a006_2.file.product.tpl.php:35 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_664227c1ab6fa3_47533840) /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/dev/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/86/cc/82/86cc8292d9f2bb6f016859e0de073f7eebeb639e_2.file.productlist.tpl.php:37 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_664227c1a9eff3_40390945) /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/dev/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/8c/fd/e6/8cfde64064e6c4caece8236ef5e76acbacfa6bdb_2.file.products.tpl.php:31 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_664227c1a951c8_16044150) /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/dev/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/6f/48/65/6f48651488bf64f01fd220f82ba1a04cbe77d385_2.file.product-list.tpl.php:119 (_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/dev/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/6f/48/65/6f48651488bf64f01fd220f82ba1a04cbe77d385_2.file.product-list.tpl.php:216 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:186 (process) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/0f/1b/23/0f1b23a7a1818900f4ac29009e8910042422aaf7_2.file.layout-both-columns.tpl.php:340 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/0f/1b/23/0f1b23a7a1818900f4ac29009e8910042422aaf7_2.file.layout-both-columns.tpl.php:406 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/0f/1b/23/0f1b23a7a1818900f4ac29009e8910042422aaf7_2.file.layout-both-columns.tpl.php:106 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_664227c17e7fb0_03111850) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/c7/5c/9e/c75c9ef97cf0782412db68aec5c3cfd60f1007c5_2.file.layout-left-column.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_664227c17d0068_09189123) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/6f/48/65/6f48651488bf64f01fd220f82ba1a04cbe77d385_2.file.product-list.tpl.php:48 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_664227c17c7649_41398043) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/fe/71/30/fe7130aef2574ffa95f5c33c99a36b6041546837_2.file.supplier.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_664227d9267546_67320972) /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/Smarty/SmartyCustom.php:112 (fetch) /classes/controller/FrontController.php:760 (fetch) /classes/controller/FrontController.php:742 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /override/classes/Dispatcher.php:39 (dispatch) /index.php:28 (dispatch)
161	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, pa.id_product_attribute, cp.position FROM ps2_product p LEFT JOIN ps2_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps2_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps2_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 ps2_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps2_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps2_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps2_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps2_category_group cg ON (cg.id_category = c.id_category) WHERE ((pac.id_attribute=1066)) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND p.id_supplier='2' GROUP BY p.id_product) p INNER JOIN ps2_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN ps2_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps2_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) WHERE ((fp.id_feature=9)) AND ((pac_1.id_attribute=1066)) GROUP BY fp.id_feature_value	1.487 ms	100	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:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/SupplierController.php:101 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /override/classes/Dispatcher.php:39 (dispatch) /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-intl-normalizer/bootstrap.php
12	/vendor/symfony/polyfill-intl-normalizer/bootstrap80.php
13	/vendor/symfony/polyfill-intl-idn/bootstrap.php
14	/vendor/symfony/polyfill-mbstring/bootstrap.php
15	/vendor/symfony/polyfill-mbstring/bootstrap80.php
16	/vendor/symfony/polyfill-php80/bootstrap.php
17	/vendor/symfony/polyfill-ctype/bootstrap.php
18	/vendor/symfony/polyfill-ctype/bootstrap80.php
19	/vendor/symfony/deprecation-contracts/function.php
20	/vendor/guzzlehttp/promises/src/functions_include.php
21	/vendor/guzzlehttp/promises/src/functions.php
22	/vendor/symfony/polyfill-iconv/bootstrap.php
23	/vendor/ralouphie/getallheaders/src/getallheaders.php
24	/vendor/swiftmailer/swiftmailer/lib/swift_required.php
25	/vendor/swiftmailer/swiftmailer/lib/classes/Swift.php
26	/vendor/guzzlehttp/guzzle/src/functions_include.php
27	/vendor/guzzlehttp/guzzle/src/functions.php
28	/vendor/symfony/polyfill-php81/bootstrap.php
29	/vendor/symfony/polyfill-php73/bootstrap.php
30	/vendor/symfony/polyfill-intl-icu/bootstrap.php
31	/vendor/lcobucci/jwt/compat/class-aliases.php
32	/vendor/lcobucci/jwt/src/Token.php
33	/vendor/lcobucci/jwt/src/Signature.php
34	/vendor/lcobucci/jwt/compat/json-exception-polyfill.php
35	/vendor/lcobucci/jwt/compat/lcobucci-clock-polyfill.php
36	/vendor/ezyang/htmlpurifier/library/HTMLPurifier.composer.php
37	/vendor/jakeasmith/http_build_url/src/http_build_url.php
38	/vendor/prestashop/laminas-code-lts/polyfill/ReflectionEnumPolyfill.php
39	/vendor/ircmaxell/password-compat/lib/password.php