Úvodná stránka

Strieborný náhrdelník - nota, dĺžka 43 až 46 cm

Náhrdelník je vyrobený zo striebra rýdzosti 925/1000. Povrchová úprava striebra je ošetrená rhodiovaním, ktoré zabraňuje oxidácii (černeniu, žltnutiu a strate lesku), vďaka čomu náhrdelník zostane dlho ako nový. Výhodou u náhrdelníka je, že dĺžku môžete kedykoľvek meniť na akúkoľvek z týchto hodnôt: 43 cm, 44 cm, 45 cm a 46 cm. Zapínanie je na kvalitný a bezpečný pérový krúžok.

28,90 € / ks

Skladom, posielame ihneď

Strieborný náhrdelník - slon, dĺžka 43 až 46 cm

31,90 € / ks

Skladom, posielame ihneď

Strieborný náhrdelník - anjel, dĺžka 43 až 46 cm

32,90 € / ks

Skladom, posielame ihneď

Strieborný náhrdelník - labka, dĺžka 43 až 46 cm

29,90 € / ks

Skladom, posielame ihneď

Load Time	407.112 ms
Querying Time	328 ms
Queries	275
Memory Peak Usage	10.6 Mb
Included Files	942 files - 11.34 Mb
PrestaShop Cache	- Mb
Global vars	0.34 Mb
- global $_MODULES	308k
- global $_MODULE	13k
- global $_SERVER	8k
- global $config	5k
- global $context	3k
- global $exportPhpConfigFile	3k
- global $_COOKIE	1k
- global $__composer_autoload_files	1k

PrestaShop Version	8.2.0
PHP Version	8.3.0beta3
MySQL Version	12.1.2-MariaDB-ubu2404
Memory Limit	512M
Max Execution Time	1800s
Smarty Cache	enabled
Smarty Compilation	auto

	Time	Cumulated Time	Memory Usage	Memory Peak Usage
config	0.003 ms	0.003 ms	2.00 Mb	2.0 Mb
__construct	0.430 ms	0.433 ms	0.01 Mb	2.6 Mb
init	47.423 ms	47.856 ms	1.08 Mb	3.5 Mb
checkAccess	0.002 ms	47.858 ms	- Mb	3.5 Mb
setMedia	1.643 ms	49.501 ms	0.04 Mb	3.5 Mb
postProcess	0.001 ms	49.502 ms	- Mb	3.5 Mb
initHeader	0.000 ms	49.502 ms	- Mb	3.5 Mb
initContent	252.829 ms	302.331 ms	3.83 Mb	7.1 Mb
initFooter	0.002 ms	302.333 ms	- Mb	7.1 Mb
display	104.779 ms	407.112 ms	3.22 Mb	10.6 Mb

Hook	Time	Memory Usage
DisplayMegaMenu	57.184 ms	1.40 Mb
=> ets_megamenu	57.184 ms	1.40 Mb
DisplayBlock	34.494 ms	0.75 Mb
=> ets_megamenu	4.060 ms	0.15 Mb
=> ets_megamenu	1.302 ms	0.03 Mb
=> ets_megamenu	2.278 ms	0.03 Mb
=> ets_megamenu	1.343 ms	0.03 Mb
=> ets_megamenu	1.426 ms	0.03 Mb
=> ets_megamenu	1.601 ms	0.03 Mb
=> ets_megamenu	1.271 ms	0.03 Mb
=> ets_megamenu	1.337 ms	0.03 Mb
=> ets_megamenu	1.501 ms	0.03 Mb
=> ets_megamenu	1.641 ms	0.03 Mb
=> ets_megamenu	1.449 ms	0.03 Mb
=> ets_megamenu	1.446 ms	0.03 Mb
=> ets_megamenu	1.435 ms	0.03 Mb
=> ets_megamenu	1.584 ms	0.03 Mb
=> ets_megamenu	1.558 ms	0.03 Mb
=> ets_megamenu	1.465 ms	0.03 Mb
=> ets_megamenu	1.474 ms	0.03 Mb
=> ets_megamenu	1.591 ms	0.03 Mb
=> ets_megamenu	1.494 ms	0.03 Mb
=> ets_megamenu	1.482 ms	0.03 Mb
=> ets_megamenu	0.221 ms	- Mb
=> ets_megamenu	1.535 ms	0.03 Mb
DisplayHeader	25.872 ms	0.18 Mb
=> dm_cookies	3.241 ms	0.03 Mb
=> ps_shoppingcart	0.089 ms	- Mb
=> ps_imageslider	0.319 ms	- Mb
=> ybc_themeconfig	3.317 ms	0.02 Mb
=> ybc_productimagehover	0.743 ms	0.01 Mb
=> ets_megamenu	1.142 ms	0.03 Mb
=> dm_cashondelivery	8.233 ms	0.04 Mb
=> shaim_zasilkovna_widget	0.010 ms	- Mb
=> shaim_google_ecommerce	2.118 ms	0.01 Mb
=> ybc_blocksearch	0.893 ms	0.01 Mb
=> shaim_heureka_cz_overeno	0.002 ms	- Mb
=> arproductlists	4.625 ms	0.01 Mb
=> an_productfields	0.779 ms	- Mb
=> shaim_adwords_full_rem	0.107 ms	- Mb
=> shaim_adwords_full_konverze	0.012 ms	- Mb
=> thecheckout	0.035 ms	- Mb
=> shaim_baliknapostu	0.005 ms	- Mb
=> mk_deliverytime	0.002 ms	- Mb
=> shaim_facebook_pixel	0.198 ms	- Mb
=> mk_homepage_block	0.002 ms	- Mb
displayLeftColumn	7.416 ms	0.47 Mb
=> ps_categorytree (widget)	7.416 ms	0.47 Mb
displayFooter	5.456 ms	0.17 Mb
=> ps_contactinfo (widget)	2.320 ms	0.06 Mb
=> ps_customeraccountlinks (widget)	1.282 ms	0.05 Mb
=> ps_linklist (widget)	1.854 ms	0.06 Mb
DisplayBeforeBodyClosingTag	4.412 ms	0.09 Mb
=> statsdata	3.361 ms	0.04 Mb
=> shaim_heureka_cz_stats	0.010 ms	- Mb
=> shaim_facebook_pixel	1.041 ms	0.05 Mb
displayNav2	3.727 ms	0.12 Mb
=> ps_customersignin (widget)	1.400 ms	0.04 Mb
=> ps_shoppingcart (widget)	2.327 ms	0.08 Mb
DisplayProductExtra	3.463 ms	0.12 Mb
=> mk_getmj	1.052 ms	0.04 Mb
=> mk_getmj	0.920 ms	0.03 Mb
=> mk_getmj	0.787 ms	0.03 Mb
=> mk_getmj	0.704 ms	0.03 Mb
displayNav1	3.167 ms	0.10 Mb
=> ps_languageselector (widget)	1.204 ms	0.04 Mb
=> ps_currencyselector (widget)	1.963 ms	0.06 Mb
DisplayFooterCategory	2.253 ms	0.03 Mb
=> arproductlists	1.041 ms	0.01 Mb
=> mk_heurekarecenzie	1.212 ms	0.02 Mb
displayFooterBefore	1.894 ms	0.05 Mb
=> ps_emailsubscription (widget)	1.894 ms	0.05 Mb
DisplayLeftColumn	1.018 ms	0.09 Mb
=> ps_facetedsearch	0.358 ms	0.07 Mb
=> dm_comgate	0.007 ms	- Mb
=> arproductlists	0.653 ms	0.02 Mb
ProductSearchProvider	0.709 ms	- Mb
=> ps_facetedsearch	0.709 ms	- Mb
DisplayTop	0.671 ms	0.01 Mb
=> ets_megamenu	0.004 ms	- Mb
=> ybc_blocksearch	0.667 ms	0.01 Mb
ActionFrontControllerSetMedia	0.657 ms	0.01 Mb
=> blockreassurance	0.462 ms	- Mb
=> ps_emailsubscription	0.113 ms	- Mb
=> ps_emailalerts	0.082 ms	- Mb
DisplayFooter	0.363 ms	0.01 Mb
=> ybc_themeconfig	0.330 ms	0.01 Mb
=> dm_cookies	0.033 ms	- Mb
Header	0.165 ms	- Mb
=> mailjet	0.005 ms	- Mb
=> mk_heurekarecenzie	0.160 ms	- Mb
DisplayFooterAfter	0.019 ms	- Mb
=> thecheckout	0.019 ms	- Mb
DisplayProductPriceBlock	0.012 ms	- Mb
=> an_productfields	0.002 ms	- Mb
=> an_productfields	0.001 ms	- Mb
=> an_productfields	0.000 ms	- Mb
=> an_productfields	0.002 ms	- Mb
=> an_productfields	0.000 ms	- Mb
=> an_productfields	0.001 ms	- Mb
=> an_productfields	0.001 ms	- Mb
=> an_productfields	0.001 ms	- Mb
=> an_productfields	0.001 ms	- Mb
=> an_productfields	0.001 ms	- Mb
=> an_productfields	0.001 ms	- Mb
=> an_productfields	0.001 ms	- Mb
ActionDispatcher	0.004 ms	- Mb
=> thecheckout	0.004 ms	- Mb
ActionControllerInitBefore	0.004 ms	- Mb
=> mailjet	0.004 ms	- Mb
ActionBuildFrontEndObject	0.004 ms	- Mb
=> thecheckout	0.004 ms	- Mb
DisplayOverrideTemplate	0.003 ms	- Mb
=> an_productfields	0.003 ms	- Mb
23 hook(s)	152.966 ms	3.60 Mb

Module	Time	Memory Usage
thecheckout	6.294 ms	0.17 Mb
__construct	6.226 ms	0.16 Mb
hookActionDispatcher	0.006 ms	- Mb
hookActionBuildFrontEndObject	0.006 ms	- Mb
hookDisplayHeader	0.036 ms	- Mb
hookDisplayFooterAfter	0.020 ms	- Mb
mailjet	0.818 ms	0.04 Mb
__construct	0.806 ms	0.04 Mb
hookActionControllerInitBefore	0.005 ms	- Mb
hookHeader	0.007 ms	- Mb
blockreassurance	0.624 ms	0.02 Mb
__construct	0.160 ms	0.01 Mb
hookActionFrontControllerSetMedia	0.464 ms	0.01 Mb
ps_emailsubscription	2.095 ms	0.06 Mb
__construct	0.083 ms	0.01 Mb
hookActionFrontControllerSetMedia	0.115 ms	- Mb
displayFooterBefore	1.896 ms	0.05 Mb
ps_emailalerts	0.205 ms	0.01 Mb
__construct	0.122 ms	0.01 Mb
hookActionFrontControllerSetMedia	0.083 ms	- Mb
an_productfields	1.055 ms	0.02 Mb
__construct	0.248 ms	0.01 Mb
hookDisplayHeader	0.780 ms	- Mb
hookDisplayOverrideTemplate	0.005 ms	- Mb
hookDisplayProductPriceBlock	0.003 ms	- Mb
hookDisplayProductPriceBlock	0.002 ms	- Mb
hookDisplayProductPriceBlock	0.001 ms	- Mb
hookDisplayProductPriceBlock	0.002 ms	- Mb
hookDisplayProductPriceBlock	0.001 ms	- Mb
hookDisplayProductPriceBlock	0.002 ms	- Mb
hookDisplayProductPriceBlock	0.002 ms	- Mb
hookDisplayProductPriceBlock	0.002 ms	- Mb
hookDisplayProductPriceBlock	0.002 ms	- Mb
hookDisplayProductPriceBlock	0.002 ms	- Mb
hookDisplayProductPriceBlock	0.002 ms	- Mb
hookDisplayProductPriceBlock	0.001 ms	- Mb
dm_cookies	5.654 ms	0.04 Mb
__construct	2.377 ms	0.01 Mb
hookDisplayHeader	3.243 ms	0.03 Mb
hookDisplayFooter	0.034 ms	- Mb
ps_shoppingcart	2.500 ms	0.08 Mb
__construct	0.081 ms	0.01 Mb
hookDisplayHeader	0.091 ms	- Mb
displayNav2	2.328 ms	0.08 Mb
ps_imageslider	0.425 ms	0.01 Mb
__construct	0.105 ms	0.01 Mb
hookDisplayHeader	0.320 ms	- Mb
ybc_themeconfig	5.481 ms	0.12 Mb
__construct	1.830 ms	0.09 Mb
hookDisplayHeader	3.319 ms	0.02 Mb
hookDisplayFooter	0.332 ms	0.01 Mb
ybc_productimagehover	0.980 ms	0.02 Mb
__construct	0.235 ms	0.01 Mb
hookDisplayHeader	0.745 ms	0.01 Mb
ets_megamenu	100.884 ms	2.77 Mb
__construct	8.017 ms	0.59 Mb
hookDisplayHeader	1.144 ms	0.03 Mb
hookDisplayTop	0.005 ms	- Mb
hookDisplayBlock	4.062 ms	0.15 Mb
hookDisplayBlock	1.304 ms	0.03 Mb
hookDisplayBlock	2.280 ms	0.03 Mb
hookDisplayBlock	1.345 ms	0.03 Mb
hookDisplayBlock	1.428 ms	0.03 Mb
hookDisplayBlock	1.603 ms	0.03 Mb
hookDisplayBlock	1.273 ms	0.03 Mb
hookDisplayBlock	1.338 ms	0.03 Mb
hookDisplayBlock	1.503 ms	0.03 Mb
hookDisplayBlock	1.642 ms	0.03 Mb
hookDisplayBlock	1.451 ms	0.03 Mb
hookDisplayBlock	1.447 ms	0.03 Mb
hookDisplayBlock	1.437 ms	0.03 Mb
hookDisplayBlock	1.586 ms	0.03 Mb
hookDisplayBlock	1.559 ms	0.03 Mb
hookDisplayBlock	1.467 ms	0.03 Mb
hookDisplayBlock	1.476 ms	0.03 Mb
hookDisplayBlock	1.593 ms	0.03 Mb
hookDisplayBlock	1.496 ms	0.03 Mb
hookDisplayBlock	1.484 ms	0.03 Mb
hookDisplayBlock	0.222 ms	- Mb
hookDisplayBlock	1.536 ms	0.03 Mb
hookDisplayMegaMenu	57.186 ms	1.40 Mb
dm_cashondelivery	10.659 ms	0.15 Mb
__construct	2.423 ms	0.11 Mb
hookDisplayHeader	8.236 ms	0.04 Mb
shaim_zasilkovna_widget	0.369 ms	0.05 Mb
__construct	0.358 ms	0.05 Mb
hookDisplayHeader	0.011 ms	- Mb
shaim_google_ecommerce	2.385 ms	0.02 Mb
__construct	0.265 ms	0.01 Mb
hookDisplayHeader	2.120 ms	0.01 Mb
ybc_blocksearch	6.718 ms	0.10 Mb
__construct	5.155 ms	0.08 Mb
hookDisplayHeader	0.895 ms	0.01 Mb
hookDisplayTop	0.668 ms	0.01 Mb
shaim_heureka_cz_overeno	0.243 ms	0.01 Mb
__construct	0.240 ms	0.01 Mb
hookDisplayHeader	0.003 ms	- Mb
arproductlists	6.607 ms	0.04 Mb
__construct	0.282 ms	0.01 Mb
hookDisplayHeader	4.627 ms	0.01 Mb
hookDisplayFooterCategory	1.043 ms	0.01 Mb
hookDisplayLeftColumn	0.655 ms	0.02 Mb
dm_comgate	4.723 ms	0.05 Mb
__construct	4.715 ms	0.05 Mb
hookDisplayLeftColumn	0.008 ms	- Mb
shaim_adwords_full_rem	0.379 ms	0.04 Mb
__construct	0.270 ms	0.03 Mb
hookDisplayHeader	0.109 ms	- Mb
shaim_adwords_full_konverze	0.249 ms	0.02 Mb
__construct	0.235 ms	0.02 Mb
hookDisplayHeader	0.014 ms	- Mb
shaim_baliknapostu	0.254 ms	0.02 Mb
__construct	0.247 ms	0.02 Mb
hookDisplayHeader	0.007 ms	- Mb
mk_deliverytime	0.210 ms	0.01 Mb
__construct	0.207 ms	0.01 Mb
hookDisplayHeader	0.003 ms	- Mb
shaim_facebook_pixel	1.484 ms	0.06 Mb
__construct	0.241 ms	0.01 Mb
hookDisplayHeader	0.200 ms	- Mb
hookDisplayBeforeBodyClosingTag	1.043 ms	0.05 Mb
mk_homepage_block	0.229 ms	0.01 Mb
__construct	0.226 ms	0.01 Mb
hookDisplayHeader	0.003 ms	- Mb
mk_heurekarecenzie	1.614 ms	0.09 Mb
__construct	0.238 ms	0.07 Mb
hookHeader	0.162 ms	- Mb
hookDisplayFooterCategory	1.214 ms	0.02 Mb
ps_facetedsearch	1.293 ms	0.09 Mb
__construct	0.222 ms	0.01 Mb
hookProductSearchProvider	0.711 ms	- Mb
hookDisplayLeftColumn	0.360 ms	0.07 Mb
ps_languageselector	1.292 ms	0.04 Mb
__construct	0.086 ms	0.01 Mb
displayNav1	1.206 ms	0.04 Mb
ps_currencyselector	2.062 ms	0.07 Mb
__construct	0.097 ms	0.01 Mb
displayNav1	1.965 ms	0.06 Mb
ps_customersignin	1.484 ms	0.05 Mb
__construct	0.082 ms	0.01 Mb
displayNav2	1.402 ms	0.04 Mb
ps_categorytree	7.509 ms	0.48 Mb
__construct	0.091 ms	0.01 Mb
displayLeftColumn	7.418 ms	0.47 Mb
mk_getmj	3.749 ms	0.12 Mb
__construct	0.278 ms	0.01 Mb
hookDisplayProductExtra	1.054 ms	0.04 Mb
hookDisplayProductExtra	0.922 ms	0.03 Mb
hookDisplayProductExtra	0.789 ms	0.03 Mb
hookDisplayProductExtra	0.706 ms	0.03 Mb
ps_contactinfo	2.407 ms	0.07 Mb
__construct	0.084 ms	0.01 Mb
displayFooter	2.323 ms	0.06 Mb
ps_customeraccountlinks	1.362 ms	0.06 Mb
__construct	0.079 ms	0.01 Mb
displayFooter	1.283 ms	0.05 Mb
ps_linklist	2.012 ms	0.06 Mb
__construct	0.157 ms	0.01 Mb
displayFooter	1.855 ms	0.06 Mb
statsdata	3.445 ms	0.05 Mb
__construct	0.082 ms	0.01 Mb
hookDisplayBeforeBodyClosingTag	3.363 ms	0.04 Mb
shaim_heureka_cz_stats	0.360 ms	0.02 Mb
__construct	0.348 ms	0.01 Mb
hookDisplayBeforeBodyClosingTag	0.012 ms	- Mb
37 module(s)	190.111 ms	5.13 Mb

Materiál

Určenie

Typ

Zapínanie

Materiál

Určenie

Náboženský motív

Iný motív

Materiál

Určenie

Typ

Materiál

Určenie

Typ

Materiál

Určenie

Typ

Materiál

Určenie

Typ retiazky

Vzor

Doplnky

Úvodná stránka

Strieborný náhrdelník - nota, dĺžka 43 až 46 cm

Strieborný náhrdelník - slon, dĺžka 43 až 46 cm

Strieborný náhrdelník - anjel, dĺžka 43 až 46 cm

Strieborný náhrdelník - labka, dĺžka 43 až 46 cm

Stopwatch SQL - 275 queries

Doubles

Tables stress

ObjectModel instances

Included Files

16 queries	SELECT b.*,bl.title,bl.title_link,bl.content,bl.image_link FROM ps_ets_mm_block b LEFT JOIN ps_ets_mm_block_lang bl ON b.id_block=bl.id_block AND bl.id_lang=XX WHERE XX AND b.id_column=XX ORDER BY b.sort_order asc,bl.title asc
15 queries	SELECT `id_module` FROM `ps_module_shop` WHERE `id_module` = XX AND `id_shop` = XX LIMIT XX
15 queries	SELECT c.*, cl.name,cl.link_rewrite FROM ps_category c LEFT JOIN ps_category_lang cl ON c.id_category=cl.id_category AND cl.id_lang=XX WHERE c.id_category IN(XX,XX,XX,XX) ORDER BY cl.name ASC
13 queries	SELECT fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM ps_product p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_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 ps_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = XX AND ps.active = TRUE) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=XX) LEFT JOIN ps_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN ps_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN ps_feature_product fp_XX ON (p.id_product = fp_XX.id_product) LEFT JOIN ps_feature_product fp_XX ON (p.id_product = fp_XX.id_product) WHERE ((fp.id_feature_value=XX)) AND ((fp_XX.id_feature_value=XX)) AND ((fp_XX.id_feature_value IN (XX, XX, XX, XX, XX, XX, XX))) AND ps.id_shop='XX' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='XX' AND c.nleft>=XX AND c.nright<=XX GROUP BY p.id_product) p INNER JOIN ps_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN ps_feature_product fp_XX ON (p.id_product = fp_XX.id_product) LEFT JOIN ps_feature_product fp_XX ON (p.id_product = fp_XX.id_product) LEFT JOIN ps_feature_product fp_XX ON (p.id_product = fp_XX.id_product) WHERE ((fp.id_feature=XX)) AND ((fp_XX.id_feature_value=XX)) AND ((fp_XX.id_feature_value=XX)) AND ((fp_XX.id_feature_value IN (XX, XX, XX, XX, XX, XX, XX))) GROUP BY fp.id_feature_value
11 queries	SELECT * FROM `ps_category` a LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = XX LEFT JOIN `ps_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
10 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 `ps_feature_value` v LEFT JOIN `ps_feature_value_lang` vl ON (v.`id_feature_value` = vl.`id_feature_value` AND vl.`id_lang` = XX) LEFT JOIN `ps_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
7 queries	SELECT * FROM ps_ets_mm_column WHERE XX AND id_menu=XX ORDER BY sort_order asc
6 queries	SELECT c.*, cl.name,cl.link_rewrite FROM ps_category c LEFT JOIN ps_category_lang cl ON c.id_category=cl.id_category AND cl.id_lang=XX WHERE c.id_category IN(XX,XX,XX) ORDER BY cl.name ASC
5 queries	SELECT XX FROM `ps_specific_price` WHERE id_product = XX LIMIT XX
4 queries	SELECT image_shop.`id_image` FROM `ps_image` i INNER JOIN ps_image_shop image_shop ON (image_shop.id_image = i.id_image AND image_shop.id_shop = XX) WHERE i.`id_product` = XX AND image_shop.`cover` = XX LIMIT XX
4 queries	SELECT name FROM ps_category_lang WHERE id_shop = XX AND id_lang = XX AND id_category = XX LIMIT XX
4 queries	SELECT * FROM `ps_product` a LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = XX LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = XX WHERE (a.`id_product` = XX) AND (b.`id_shop` = XX) LIMIT XX
4 queries	SELECT `priority`, `id_specific_price_priority` FROM `ps_specific_price_priority` WHERE `id_product` = XX ORDER BY `id_specific_price_priority` DESC LIMIT XX
4 queries	SELECT *, ( IF (`id_shop` = XX, XX, XX) + IF (`id_country` = XX, XX, XX) + IF (`id_currency` = XX, XX, XX) + IF (`id_group` = XX, XX, XX) + IF (`id_customer` = XX, XX, XX)) AS `score` FROM `ps_specific_price` WHERE `id_shop` IN (XX, XX) AND `id_currency` IN (XX, XX) AND `id_country` IN (XX, XX) AND `id_group` IN (XX, XX) AND `id_product` = XX AND `id_customer` = XX AND `id_product_attribute` = XX AND `id_cart` = XX AND (`from` = 'XX-XX-XX XX:XX:XX' OR 'XX-XX-XX XX:XX:XX' >= `from`) AND (`to` = 'XX-XX-XX XX:XX:XX' OR 'XX-XX-XX XX:XX:XX' <= `to`) AND IF(`from_quantity` > XX, `from_quantity`, XX) <= XX ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT XX
4 queries	SELECT product_shop.`price`, product_shop.`ecotax`, IFNULL(product_attribute_shop.id_product_attribute,XX) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on, product_attribute_shop.`ecotax` AS attribute_ecotax FROM `ps_product` p INNER JOIN `ps_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = XX) LEFT JOIN `ps_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = XX) WHERE (p.`id_product` = XX)
4 queries	SELECT `id_tax_rules_group` FROM `ps_product_shop` WHERE `id_product` = XX AND id_shop=XX LIMIT XX
4 queries	SELECT `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = XX AND `id_group` = XX LIMIT XX
4 queries	SELECT SUM(quantity) FROM `ps_stock_available` WHERE (id_product = XX) AND (id_product_attribute = XX) AND (id_shop = XX) AND (id_shop_group = XX) LIMIT XX
4 queries	SELECT COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), XX) as deep_quantity, COALESCE(SUM(first_level_quantity), XX) as quantity FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, XX as pack_quantity FROM `ps_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, SUM(cp.`quantity` * p.`quantity`) as pack_quantity FROM `ps_cart_product` cp JOIN `ps_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `ps_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
4 queries	SELECT name, value, pf.id_feature, f.position, fvl.id_feature_value FROM ps_feature_product pf LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = XX) LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = XX) LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = XX) INNER JOIN ps_feature_shop feature_shop ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = XX) WHERE pf.id_product = XX ORDER BY f.position ASC
4 queries	SELECT image_shop.`cover`, i.`id_image`, il.`legend`, i.`position` FROM `ps_image` i INNER JOIN ps_image_shop image_shop ON (image_shop.id_image = i.id_image AND image_shop.id_shop = XX) LEFT JOIN `ps_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = XX) WHERE i.`id_product` = XX ORDER BY `position`
4 queries	SELECT `id_product_attribute` FROM `ps_product_attribute` WHERE `id_product` = XX
4 queries	SELECT pa.`id_product`, a.`color`, pac.`id_product_attribute`, SUM(IF(stock.`quantity` > XX, XX, XX)) qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by FROM `ps_product_attribute` pa INNER JOIN ps_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 ps_stock_available stock ON (stock.id_product = `pa`.id_product AND stock.id_product_attribute = IFNULL(`pa`.id_product_attribute, XX) AND stock.id_shop = XX AND stock.id_shop_group = XX ) JOIN `ps_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`) JOIN `ps_attribute` a ON (a.`id_attribute` = pac.`id_attribute`) JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = XX) JOIN `ps_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`) WHERE pa.`id_product` IN (XX) AND ag.`is_color_group` = XX GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` HAVING qty > XX ORDER BY a.`position` ASC;
4 queries	SELECT mj FROM ps_product WHERE reference = 'XX' LIMIT XX
2 queries	SELECT `id_lang` FROM `ps_lang` WHERE `locale` = 'sk-sk' OR `language_code` = 'sk-sk' LIMIT XX
2 queries	SELECT `id_category` FROM `ps_category_shop` WHERE `id_category` = XX AND `id_shop` = XX LIMIT XX
2 queries	SELECT `need_identification_number` FROM `ps_country` WHERE `id_country` = XX LIMIT XX
2 queries	SELECT id_lang FROM ps_lang WHERE is_rtl=XX AND active=XX LIMIT XX
2 queries	SELECT id_manufacturer as value,CONCAT('mm_manufacturer_',id_manufacturer) as id, name as label FROM ps_manufacturer WHERE active=XX ORDER BY name asc
2 queries	SELECT c.id_cms as value,CONCAT('mm_cms_',c.id_cms) as id, cl.meta_title as label FROM ps_cms c LEFT JOIN ps_cms_lang cl ON c.id_cms=cl.id_cms AND cl.id_lang=XX WHERE c.active=XX ORDER BY cl.meta_title asc
2 queries	SELECT XX FROM `ps_cart_rule` WHERE ((date_to >= "XX-XX-XX XX:XX:XX" AND date_to <= "XX-XX-XX XX:XX:XX") OR (date_from >= "XX-XX-XX XX:XX:XX" AND date_from <= "XX-XX-XX XX:XX:XX") OR (date_from < "XX-XX-XX XX:XX:XX" AND date_to > "XX-XX-XX XX:XX:XX")) AND `id_customer` IN (XX,XX) LIMIT XX
2 queries	SELECT fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM ps_product p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_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 ps_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = XX AND ps.active = TRUE) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=XX) LEFT JOIN ps_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN ps_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN ps_feature_product fp_XX ON (p.id_product = fp_XX.id_product) WHERE ((fp.id_feature_value=XX)) AND ((fp_XX.id_feature_value IN (XX, XX, XX, XX, XX, XX, XX))) AND ps.id_shop='XX' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='XX' AND c.nleft>=XX AND c.nright<=XX GROUP BY p.id_product) p INNER JOIN ps_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN ps_feature_product fp_XX ON (p.id_product = fp_XX.id_product) LEFT JOIN ps_feature_product fp_XX ON (p.id_product = fp_XX.id_product) WHERE ((fp.id_feature=XX)) AND ((fp_XX.id_feature_value=XX)) AND ((fp_XX.id_feature_value IN (XX, XX, XX, XX, XX, XX, XX))) GROUP BY fp.id_feature_value
2 queries	SELECT tr.* FROM `ps_tax_rule` tr JOIN `ps_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

Name	Instances	Source
Category	99	/controllers/front/listing/CategoryController.php:76 (__construct) [id: 2] /controllers/front/listing/CategoryController.php:214 (__construct) [id: 3] /controllers/front/listing/CategoryController.php:214 (__construct) [id: 23] /controllers/front/listing/CategoryController.php:214 (__construct) [id: 50] /controllers/front/listing/CategoryController.php:214 (__construct) [id: 65] /controllers/front/listing/CategoryController.php:214 (__construct) [id: 76] /controllers/front/listing/CategoryController.php:214 (__construct) [id: 88] /controllers/front/listing/CategoryController.php:214 (__construct) [id: 110] /classes/Meta.php:380 (__construct) [id: 2] /classes/PrestaShopCollection.php:385 (hydrateCollection) [id: ] /modules/shaim_google_ecommerce/shaim_google_ecommerce.php:979 (__construct) [id: 2] /modules/shaim_adwords_full_rem/shaim_adwords_full_rem.php:566 (__construct) [id: 2] /modules/ps_facetedsearch/src/Product/Search.php:364 (__construct) [id: 2] /classes/Link.php:402 (__construct) [id: 3] /classes/Link.php:402 (__construct) [id: 23] /classes/Link.php:402 (__construct) [id: 50] /classes/Link.php:402 (__construct) [id: 65] /classes/Link.php:402 (__construct) [id: 76] /classes/Link.php:402 (__construct) [id: 88] /classes/Link.php:402 (__construct) [id: 110] /classes/Link.php:402 (__construct) [id: 8] /classes/Link.php:402 (__construct) [id: 3] /classes/Link.php:402 (__construct) [id: 11] /classes/Link.php:402 (__construct) [id: 4] /classes/Link.php:402 (__construct) [id: 3] /classes/Link.php:402 (__construct) [id: 11] /classes/Link.php:402 (__construct) [id: 4] /classes/Link.php:402 (__construct) [id: 8] /classes/Link.php:402 (__construct) [id: 3] /classes/Link.php:402 (__construct) [id: 11] /classes/Link.php:402 (__construct) [id: 4] /classes/Link.php:402 (__construct) [id: 8] /classes/Link.php:402 (__construct) [id: 3] /classes/Link.php:402 (__construct) [id: 11] /classes/Link.php:402 (__construct) [id: 4] /classes/Link.php:402 (__construct) [id: 8] /classes/Link.php:402 (__construct) [id: 3] /classes/Link.php:402 (__construct) [id: 11] /classes/Link.php:402 (__construct) [id: 4] /classes/Link.php:402 (__construct) [id: 3] /classes/Link.php:402 (__construct) [id: 11] /classes/Link.php:402 (__construct) [id: 4] /classes/Link.php:402 (__construct) [id: 8] /classes/Link.php:402 (__construct) [id: 3] /classes/Link.php:402 (__construct) [id: 11] /classes/Link.php:402 (__construct) [id: 4] /classes/Link.php:402 (__construct) [id: 8] /classes/Link.php:402 (__construct) [id: 3] /classes/Link.php:402 (__construct) [id: 11] /classes/Link.php:402 (__construct) [id: 4] /classes/Link.php:402 (__construct) [id: 8] /classes/Link.php:402 (__construct) [id: 3] /classes/Link.php:402 (__construct) [id: 11] /classes/Link.php:402 (__construct) [id: 4] /classes/Link.php:402 (__construct) [id: 3] /classes/Link.php:402 (__construct) [id: 11] /classes/Link.php:402 (__construct) [id: 4] /classes/Link.php:402 (__construct) [id: 8] /classes/Link.php:402 (__construct) [id: 3] /classes/Link.php:402 (__construct) [id: 11] /classes/Link.php:402 (__construct) [id: 4] /classes/Link.php:402 (__construct) [id: 8] /classes/Link.php:402 (__construct) [id: 3] /classes/Link.php:402 (__construct) [id: 11] /classes/Link.php:402 (__construct) [id: 4] /classes/Link.php:402 (__construct) [id: 3] /classes/Link.php:402 (__construct) [id: 11] /classes/Link.php:402 (__construct) [id: 4] /classes/Link.php:402 (__construct) [id: 8] /classes/Link.php:402 (__construct) [id: 3] /classes/Link.php:402 (__construct) [id: 11] /classes/Link.php:402 (__construct) [id: 4] /classes/Link.php:402 (__construct) [id: 8] /classes/Link.php:402 (__construct) [id: 3] /classes/Link.php:402 (__construct) [id: 11] /classes/Link.php:402 (__construct) [id: 4] /classes/Link.php:402 (__construct) [id: 3] /classes/Link.php:402 (__construct) [id: 11] /classes/Link.php:402 (__construct) [id: 4] /classes/Link.php:402 (__construct) [id: 8] /classes/Link.php:402 (__construct) [id: 3] /classes/Link.php:402 (__construct) [id: 11] /classes/Link.php:402 (__construct) [id: 4] /classes/Link.php:402 (__construct) [id: 8] /classes/Link.php:402 (__construct) [id: 3] /classes/Link.php:402 (__construct) [id: 11] /classes/Link.php:402 (__construct) [id: 4] /classes/Link.php:402 (__construct) [id: 3] /classes/Link.php:402 (__construct) [id: 11] /classes/Link.php:402 (__construct) [id: 4] /classes/Link.php:402 (__construct) [id: 8] /classes/Link.php:402 (__construct) [id: 3] /classes/Link.php:402 (__construct) [id: 11] /classes/Link.php:402 (__construct) [id: 4] /classes/Link.php:402 (__construct) [id: 8] /classes/Link.php:402 (__construct) [id: 3] /classes/Link.php:402 (__construct) [id: 11] /classes/Link.php:402 (__construct) [id: 4] /modules/ps_categorytree/ps_categorytree.php:364 (getParentsCategories) [id: 2]
Product	12	/classes/Link.php:113 (__construct) [id: 4457] /classes/Link.php:113 (__construct) [id: 4454] /classes/Link.php:113 (__construct) [id: 4441] /classes/Link.php:113 (__construct) [id: 4438] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 4457] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 4454] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 4441] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 4438] /classes/Link.php:113 (__construct) [id: 4457] /classes/Link.php:113 (__construct) [id: 4454] /classes/Link.php:113 (__construct) [id: 4441] /classes/Link.php:113 (__construct) [id: 4438]
Address	6	/modules/thecheckout/classes/Config.php:83 (__construct) [id: ] /modules/thecheckout/classes/Config.php:83 (__construct) [id: ] /classes/shop/Shop.php:486 (__construct) [id: ] /override/classes/Product.php:3684 (initialize) [id: ] /override/classes/Product.php:3794 (__construct) [id: ] /override/classes/Product.php:5898 (__construct) [id: ]
Country	5	/config/config.inc.php:146 (__construct) [id: 37] /classes/AddressFormat.php:404 (__construct) [id: 37] /classes/controller/FrontController.php:1779 (__construct) [id: 37] /classes/AddressFormat.php:404 (__construct) [id: 37] /modules/ps_contactinfo/ps_contactinfo.php:104 (__construct) [id: 37]
Currency	3	/src/Adapter/Currency/CurrencyDataProvider.php:101 (__construct) [id: 1] /classes/Tools.php:690 (getCurrencyInstance) [id: 1] /modules/shaim_adwords_full_rem/shaim_adwords_full_rem.php:645 (__construct) [id: 1]
Cart	2	/classes/controller/FrontController.php:467 (__construct) [id: ] /classes/controller/FrontController.php:541 (__construct) [id: ]
AddressFormat	2	/classes/controller/FrontController.php:1773 (generateAddress) [id: ] /modules/ps_contactinfo/ps_contactinfo.php:98 (generateAddress) [id: ]
Language	2	/config/config.inc.php:211 (__construct) [id: 1] /classes/Tools.php:560 (__construct) [id: 1]
State	2	/classes/controller/FrontController.php:1778 (__construct) [id: 0] /modules/ps_contactinfo/ps_contactinfo.php:93 (__construct) [id: 0]
Tax	1	/classes/tax/TaxRulesTaxManager.php:116 (__construct) [id: 31]
Shop	1	/config/config.inc.php:117 (initialize) [id: 1]
Risk	1	/classes/controller/FrontController.php:1705 (__construct) [id: ]
Gender	1	/classes/controller/FrontController.php:1702 (__construct) [id: 0]
Group	1	/classes/Cart.php:249 (getCurrent) [id: 1]
Customer	1	/config/config.inc.php:264 (__construct) [id: ]
ShopGroup	1	/classes/shop/Shop.php:561 (__construct) [id: 1]
ConnectionsSource	1	/modules/statsdata/statsdata.php:119 (logHttpReferer) [id: ]

#	Query	Time (ms)	Rows	Filesort	Group By	Location
87	SELECT SQL_NO_CACHE data FROM ps_layered_filter_block WHERE hash="5e0b782edefca43e3c037754019daeb4" LIMIT 1	13.350 ms	1			/modules/ps_facetedsearch/src/Filters/Block.php:185 /modules/ps_facetedsearch/src/Product/SearchProvider.php:210 (getFromCache) /classes/controller/ProductListingFrontController.php:356 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:135 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
93	SELECT SQL_NO_CACHE fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM ps_product p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_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 ps_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN ps_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN ps_feature_product fp_1 ON (p.id_product = fp_1.id_product) WHERE ((fp.id_feature_value=2)) AND ((fp_1.id_feature_value IN (119, 197, 182, 131, 129, 190, 201))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=2 AND c.nright<=229 GROUP BY p.id_product) p INNER JOIN ps_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN ps_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN ps_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((fp.id_feature=13)) AND ((fp_1.id_feature_value=2)) AND ((fp_2.id_feature_value IN (119, 197, 182, 131, 129, 190, 201))) GROUP BY fp.id_feature_value	8.103 ms	3648000	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:778 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:855 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:154 (getFeaturesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:356 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:135 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
91	SELECT SQL_NO_CACHE fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM ps_product p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_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 ps_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN ps_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN ps_feature_product fp_1 ON (p.id_product = fp_1.id_product) WHERE ((fp.id_feature_value=54)) AND ((fp_1.id_feature_value IN (119, 197, 182, 131, 129, 190, 201))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=2 AND c.nright<=229 GROUP BY p.id_product) p INNER JOIN ps_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN ps_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN ps_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((fp.id_feature=2)) AND ((fp_1.id_feature_value=54)) AND ((fp_2.id_feature_value IN (119, 197, 182, 131, 129, 190, 201))) GROUP BY fp.id_feature_value	7.687 ms	3648000	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:778 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:855 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:154 (getFeaturesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:356 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:135 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
92	SELECT SQL_NO_CACHE v., vl., IF(lifvlv.`url_name` IS NULL OR lifvlv.`url_name` = "", NULL, lifvlv.`url_name`) AS url_name, IF(lifvlv.`meta_title` IS NULL OR lifvlv.`meta_title` = "", NULL, lifvlv.`meta_title`) AS meta_title FROM `ps_feature_value` v LEFT JOIN `ps_feature_value_lang` vl ON (v.`id_feature_value` = vl.`id_feature_value` AND vl.`id_lang` = 1) LEFT JOIN `ps_layered_indexable_feature_value_lang_value` lifvlv ON (v.`id_feature_value` = lifvlv.`id_feature_value` AND lifvlv.`id_lang` = 1) WHERE v.`id_feature` = 2 ORDER BY vl.`value` ASC	6.474 ms	4	Yes		/modules/ps_facetedsearch/src/Filters/DataAccessor.php:194 /modules/ps_facetedsearch/src/Filters/Block.php:864 (getFeatureValues) /modules/ps_facetedsearch/src/Filters/Block.php:154 (getFeaturesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:356 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:135 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
88	SELECT SQL_NO_CACHE fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM ps_product p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_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 ps_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN ps_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN ps_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN ps_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((fp.id_feature_value=2)) AND ((fp_1.id_feature_value=54)) AND ((fp_2.id_feature_value IN (119, 197, 182, 131, 129, 190, 201))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=2 AND c.nright<=229 GROUP BY p.id_product) p INNER JOIN ps_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN ps_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN ps_feature_product fp_2 ON (p.id_product = fp_2.id_product) LEFT JOIN ps_feature_product fp_3 ON (p.id_product = fp_3.id_product) WHERE ((fp.id_feature=1)) AND ((fp_1.id_feature_value=2)) AND ((fp_2.id_feature_value=54)) AND ((fp_3.id_feature_value IN (119, 197, 182, 131, 129, 190, 201))) GROUP BY fp.id_feature_value	6.188 ms	364800000	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:778 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:855 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:154 (getFeaturesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:356 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:135 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
109	SELECT SQL_NO_CACHE fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM ps_product p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_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 ps_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN ps_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN ps_feature_product fp_1 ON (p.id_product = fp_1.id_product) WHERE ((fp.id_feature_value=2)) AND ((fp_1.id_feature_value=54)) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=2 AND c.nright<=229 GROUP BY p.id_product) p INNER JOIN ps_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN ps_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN ps_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((fp.id_feature=6)) AND ((fp_1.id_feature_value=2)) AND ((fp_2.id_feature_value=54)) GROUP BY fp.id_feature_value	5.841 ms	5088000	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:778 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:855 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:154 (getFeaturesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:356 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:135 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
89	SELECT SQL_NO_CACHE v., vl., IF(lifvlv.`url_name` IS NULL OR lifvlv.`url_name` = "", NULL, lifvlv.`url_name`) AS url_name, IF(lifvlv.`meta_title` IS NULL OR lifvlv.`meta_title` = "", NULL, lifvlv.`meta_title`) AS meta_title FROM `ps_feature_value` v LEFT JOIN `ps_feature_value_lang` vl ON (v.`id_feature_value` = vl.`id_feature_value` AND vl.`id_lang` = 1) LEFT JOIN `ps_layered_indexable_feature_value_lang_value` lifvlv ON (v.`id_feature_value` = lifvlv.`id_feature_value` AND lifvlv.`id_lang` = 1) WHERE v.`id_feature` = 1 ORDER BY vl.`value` ASC	5.806 ms	2	Yes		/modules/ps_facetedsearch/src/Filters/DataAccessor.php:194 /modules/ps_facetedsearch/src/Filters/Block.php:864 (getFeatureValues) /modules/ps_facetedsearch/src/Filters/Block.php:154 (getFeaturesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:356 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:135 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
90	SELECT SQL_NO_CACHE psi.price_min, MIN(price_min) as min, MAX(price_max) as max FROM ps_product p INNER JOIN ps_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 = 37) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN ps_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN ps_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN ps_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((fp.id_feature_value=2)) AND ((fp_1.id_feature_value=54)) AND ((fp_2.id_feature_value IN (119, 197, 182, 131, 129, 190, 201))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=2 AND c.nright<=229	5.423 ms	91200			/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:57 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:250 (getMinMaxPriceValue) /modules/ps_facetedsearch/src/Filters/Block.php:131 (getPriceRangeBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:356 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:135 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
68	SELECT SQL_NO_CACHE * FROM `ps_cart_rule` cr LEFT JOIN `ps_cart_rule_lang` crl ON (cr.`id_cart_rule` = crl.`id_cart_rule` AND crl.`id_lang` = 1) WHERE (cr.`id_customer` = 0) AND NOW() BETWEEN cr.date_from AND cr.date_to AND cr.`active` = 1 AND free_shipping = 1 AND carrier_restriction = 1	5.315 ms	5289			/classes/CartRule.php:423 /classes/Cart.php:3072 (getCustomerCartRules) /classes/Cart.php:3463 (getDeliveryOptionList) /modules/dm_cashondelivery/dm_cashondelivery.php:891 (getDeliveryOption) /modules/dm_cashondelivery/dm_cashondelivery.php:904 (getCarrierId) /classes/Hook.php:1077 (hookDisplayHeader) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:418 (coreCallHook) /classes/Hook.php:983 (callHookOn) /classes/controller/FrontController.php:633 (exec) /controllers/front/listing/CategoryController.php:127 (initContent) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
112	REPLACE INTO ps_layered_filter_block (hash, data) VALUES ("5e0b782edefca43e3c037754019daeb4", "a:1:{s:7:\"filters\";a:8:{i:0;a:9:{s:9:\"type_lite\";s:10:\"id_feature\";s:4:\"type\";s:10:\"id_feature\";s:6:\"id_key\";s:1:\"1\";s:6:\"values\";a:1:{i:1;a:4:{s:3:\"nbr\";s:1:\"4\";s:4:\"name\";s:12:\"Striebro 925\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}}s:4:\"name\";s:9:\"Materiál\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";s:1:\"0\";}i:1;a:12:{s:9:\"type_lite\";s:5:\"price\";s:4:\"type\";s:5:\"price\";s:6:\"id_key\";i:0;s:4:\"name\";s:4:\"Cena\";s:3:\"max\";d:33;s:3:\"min\";d:28;s:4:\"unit\";s:3:\"€\";s:14:\"specifications\";a:11:{s:6:\"symbol\";a:11:{i:0;s:1:\",\";i:1;s:2:\" \";i:2;s:1:\";\";i:3;s:1:\"%\";i:4;s:1:\"-\";i:5;s:1:\"+\";i:6;s:1:\"e\";i:7;s:2:\"×\";i:8;s:3:\"‰\";i:9;s:3:\"∞\";i:10;s:3:\"NaN\";}s:12:\"currencyCode\";s:3:\"EUR\";s:14:\"currencySymbol\";s:3:\"€\";s:13:\"numberSymbols\";a:11:{i:0;s:1:\",\";i:1;s:2:\" \";i:2;s:1:\";\";i:3;s:1:\"%\";i:4;s:1:\"-\";i:5;s:1:\"+\";i:6;s:1:\"e\";i:7;s:2:\"×\";i:8;s:3:\"‰\";i:9;s:3:\"∞\";i:10;s:3:\"NaN\";}s:15:\"positivePattern\";s:12:\"#,##0.00 ¤\";s:15:\"negativePattern\";s:13:\"-#,##0.00 ¤\";s:17:\"maxFractionDigits\";i:2;s:17:\"minFractionDigits\";i:2;s:12:\"groupingUsed\";b:1;s:16:\"primaryGroupSize\";i:3;s:18:\"secondaryGroupSize\";i:3;}s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";i:3;s:3:\"nbr\";i:4;s:5:\"value\";N;}i:2;a:9:{s:9:\"type_lite\";s:10:\"id_feature\";s:4:\"type\";s:10:\"id_feature\";s:6:\"id_key\";s:1:\"2\";s:6:\"values\";a:1:{i:2;a:5:{s:3:\"nbr\";s:1:\"4\";s:4:\"name\";s:11:\"Rhodiovaná\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:7:\"checked\";b:1;}}s:4:\"name\";s:18:\"Povrchová úprava\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";s:1:\"0\";}i:3;a:9:{s:9:\"type_lite\";s:10:\"id_feature\";s:4:\"type\";s:10:\"id_feature\";s:6:\"id_key\";s:2:\"13\";s:6:\"values\";a:18:{i:124;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:5:\"16 cm\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:117;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:5:\"17 cm\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:122;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:5:\"18 cm\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:111;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:5:\"19 cm\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:88;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:5:\"22 cm\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:81;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:5:\"23 cm\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:82;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:5:\"24 cm\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:83;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:5:\"25 cm\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:84;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:5:\"26 cm\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:139;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:5:\"38 cm\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:156;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:5:\"39 cm\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:140;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:5:\"40 cm\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:163;a:4:{s:3:\"nbr\";s:1:\"2\";s:4:\"name\";s:5:\"41 cm\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:73;a:4:{s:3:\"nbr\";s:1:\"3\";s:4:\"name\";s:5:\"42 cm\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:51;a:4:{s:3:\"nbr\";s:1:\"7\";s:4:\"name\";s:5:\"43 cm\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:52;a:4:{s:3:\"nbr\";s:1:\"6\";s:4:\"name\";s:5:\"44 cm\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:53;a:4:{s:3:\"nbr\";s:1:\"5\";s:4:\"name\";s:5:\"45 cm\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:54;a:5:{s:3:\"nbr\";s:1:\"4\";s:4:\"name\";s:5:\"46 cm\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:7:\"checked\";b:1;}}s:4:\"name\";s:7:\"Dĺžka\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";s:1:\"0\";}i:4;a:9:{s:9:\"type_lite\";s:10:\"id_feature\";s:4:\"type\";s:10:\"id_feature\";s:6:\"id_key\";s:1:\"3\";s:6:\"values\";a:2:{i:5;a:4:{s:3:\"nbr\";s:1:\"4\";s:4:\"name\";s:7:\"Detské\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:3;a:4:{s:3:\"nbr\";s:1:\"4\";s:4:\"name\";s:7:\"Dámske\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}}s:4:\"name\";s:8:\"Určenie\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";s:1:\"0\";}i:5;a:9:{s:9:\"type_lite\";s:10:\"id_feature\";s:4:\"type\";s:10:\"id_feature\";s:6:\"id_key\";s:2:\"12\";s:6:\"values\";a:2:{i:49;a:4:{s:3:\"nbr\";s:1:\"4\";s:4:\"name\";s:6:\"Lacné\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:48;a:4:{s:3:\"nbr\";s:1:\"4\";s:4:\"name\";s:12:\"S príveskom\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}}s:4:\"name\";s:17:\"Typ náhrdelníka\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";s:1:\"0\";}i:6;a:9:{s:9:\"type_lite\";s:10:\"id_feature\";s:4:\"type\";s:10:\"id_feature\";s:6:\"id_key\";s:1:\"5\";s:6:\"values\";a:1:{i:7;a:4:{s:3:\"nbr\";s:1:\"4\";s:4:\"name\";s:12:\"Bez osadenia\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}}s:4:\"name\";s:8:\"Osadenie\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";s:1:\"0\";}i:7;a:9:{s:9:\"type_lite\";s:10:\"id_feature\";s:4:\"type\";s:10:\"id_feature\";s:6:\"id_key\";s:1:\"6\";s:6:\"values\";a:27:{i:119;a:5:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:5:\"Anjel\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:7:\"checked\";b:1;}i:77;a:4:{s:3:\"nbr\";s:2:\"12\";s:4:\"name\";s:17:\"Anjelské krídlo\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:209;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:10:\"Cyklistika\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:109;a:4:{s:3:\"nbr\";s:1:\"2\";s:4:\"name\";s:3:\"EKG\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:87;a:4:{s:3:\"nbr\";s:1:\"2\";s:4:\"name\";s:10:\"Guľôčky\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:120;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:3:\"Had\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:116;a:4:{s:3:\"nbr\";s:1:\"2\";s:4:\"name\";s:11:\"Hviezdička\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:165;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:5:\"Kotva\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:114;a:4:{s:3:\"nbr\";s:1:\"2\";s:4:\"name\";s:4:\"Kruh\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:14;a:4:{s:3:\"nbr\";s:2:\"21\";s:4:\"name\";s:8:\"Krížik\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:187;a:4:{s:3:\"nbr\";s:1:\"2\";s:4:\"name\";s:5:\"Kôň\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:147;a:4:{s:3:\"nbr\";s:1:\"2\";s:4:\"name\";s:7:\"Kľúč\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:182;a:5:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:5:\"Labka\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:7:\"checked\";b:1;}i:183;a:4:{s:3:\"nbr\";s:1:\"2\";s:4:\"name\";s:6:\"Mačka\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:128;a:4:{s:3:\"nbr\";s:2:\"11\";s:4:\"name\";s:7:\"Motýľ\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:78;a:4:{s:3:\"nbr\";s:2:\"12\";s:4:\"name\";s:10:\"Nekonečno\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:129;a:5:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:4:\"Nota\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:7:\"checked\";b:1;}i:157;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:8:\"Nožnice\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:148;a:4:{s:3:\"nbr\";s:1:\"2\";s:4:\"name\";s:7:\"Podkova\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:8;a:4:{s:3:\"nbr\";s:1:\"2\";s:4:\"name\";s:5:\"Slnko\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:190;a:5:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:4:\"Slon\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:7:\"checked\";b:1;}i:11;a:4:{s:3:\"nbr\";s:2:\"10\";s:4:\"name\";s:9:\"Srdiečko\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:105;a:4:{s:3:\"nbr\";s:1:\"4\";s:4:\"name\";s:13:\"Strom života\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:104;a:4:{s:3:\"nbr\";s:2:\"21\";s:4:\"name\";s:9:\"Zvieratá\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:90;a:4:{s:3:\"nbr\";s:2:\"12\";s:4:\"name\";s:19:\"Zázračná medaila\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:199;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:6:\"Šport\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:43;a:4:{s:3:\"nbr\";s:2:\"19\";s:4:\"name\";s:13:\"Štvorlístok\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}}s:4:\"name\";s:6:\"Motív\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";s:1:\"0\";}}}")	3.758 ms	1			/modules/ps_facetedsearch/src/Filters/Block.php:209 /modules/ps_facetedsearch/src/Product/SearchProvider.php:217 (insertIntoCache) /classes/controller/ProductListingFrontController.php:356 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:135 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
94	SELECT SQL_NO_CACHE v., vl., IF(lifvlv.`url_name` IS NULL OR lifvlv.`url_name` = "", NULL, lifvlv.`url_name`) AS url_name, IF(lifvlv.`meta_title` IS NULL OR lifvlv.`meta_title` = "", NULL, lifvlv.`meta_title`) AS meta_title FROM `ps_feature_value` v LEFT JOIN `ps_feature_value_lang` vl ON (v.`id_feature_value` = vl.`id_feature_value` AND vl.`id_lang` = 1) LEFT JOIN `ps_layered_indexable_feature_value_lang_value` lifvlv ON (v.`id_feature_value` = lifvlv.`id_feature_value` AND lifvlv.`id_lang` = 1) WHERE v.`id_feature` = 13 ORDER BY vl.`value` ASC	3.435 ms	42	Yes		/modules/ps_facetedsearch/src/Filters/DataAccessor.php:194 /modules/ps_facetedsearch/src/Filters/Block.php:864 (getFeatureValues) /modules/ps_facetedsearch/src/Filters/Block.php:154 (getFeaturesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:356 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:135 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
86	SELECT SQL_NO_CACHE p.id_product FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM ps_product p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_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 ps_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN ps_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN ps_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN ps_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((fp.id_feature_value=2)) AND ((fp_1.id_feature_value=54)) AND ((fp_2.id_feature_value IN (119, 197, 182, 131, 129, 190, 201))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=2 AND c.nright<=229 GROUP BY p.id_product) p INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) GROUP BY p.id_product ORDER BY p.position ASC, p.id_product DESC	3.354 ms	10289548800	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Filters/Products.php:87 (execute) /modules/ps_facetedsearch/src/Product/SearchProvider.php:186 (getProductByFilters) /classes/controller/ProductListingFrontController.php:356 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:135 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
96	SELECT SQL_NO_CACHE fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM ps_product p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_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 ps_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN ps_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN ps_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN ps_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((fp.id_feature_value=2)) AND ((fp_1.id_feature_value=54)) AND ((fp_2.id_feature_value IN (119, 197, 182, 131, 129, 190, 201))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=2 AND c.nright<=229 GROUP BY p.id_product) p INNER JOIN ps_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN ps_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN ps_feature_product fp_2 ON (p.id_product = fp_2.id_product) LEFT JOIN ps_feature_product fp_3 ON (p.id_product = fp_3.id_product) WHERE ((fp.id_feature=3)) AND ((fp_1.id_feature_value=2)) AND ((fp_2.id_feature_value=54)) AND ((fp_3.id_feature_value IN (119, 197, 182, 131, 129, 190, 201))) GROUP BY fp.id_feature_value	3.130 ms	364800000	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:778 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:855 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:154 (getFeaturesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:356 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:135 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
104	SELECT SQL_NO_CACHE fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM ps_product p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_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 ps_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN ps_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN ps_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN ps_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((fp.id_feature_value=2)) AND ((fp_1.id_feature_value=54)) AND ((fp_2.id_feature_value IN (119, 197, 182, 131, 129, 190, 201))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=2 AND c.nright<=229 GROUP BY p.id_product) p INNER JOIN ps_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN ps_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN ps_feature_product fp_2 ON (p.id_product = fp_2.id_product) LEFT JOIN ps_feature_product fp_3 ON (p.id_product = fp_3.id_product) WHERE ((fp.id_feature=15)) AND ((fp_1.id_feature_value=2)) AND ((fp_2.id_feature_value=54)) AND ((fp_3.id_feature_value IN (119, 197, 182, 131, 129, 190, 201))) GROUP BY fp.id_feature_value	2.912 ms	4656000000	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:778 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:855 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:154 (getFeaturesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:356 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:135 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
127	SELECT SQL_NO_CACHE `id_hook`, `name` FROM `ps_hook` UNION SELECT `id_hook`, ha.`alias` as name FROM `ps_hook_alias` ha INNER JOIN `ps_hook` h ON ha.name = h.name	2.825 ms	0			/classes/Hook.php:1326 /classes/Hook.php:225 (getAllHookIds) /classes/tax/TaxManagerFactory.php:67 (getIdByName) /classes/tax/TaxManagerFactory.php:46 (execHookTaxManagerFactory) /override/classes/Product.php:3915 (getManager) /override/classes/Product.php:3706 (priceCalculation) /override/classes/Product.php:5638 (getPriceStatic) /classes/ProductAssembler.php:206 (getProductProperties) /classes/controller/ProductListingFrontController.php:108 (assembleProducts) /classes/controller/ProductListingFrontController.php:378 (prepareMultipleProductsForTemplate) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:135 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
106	SELECT SQL_NO_CACHE fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM ps_product p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_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 ps_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN ps_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN ps_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN ps_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((fp.id_feature_value=2)) AND ((fp_1.id_feature_value=54)) AND ((fp_2.id_feature_value IN (119, 197, 182, 131, 129, 190, 201))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=2 AND c.nright<=229 GROUP BY p.id_product) p INNER JOIN ps_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN ps_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN ps_feature_product fp_2 ON (p.id_product = fp_2.id_product) LEFT JOIN ps_feature_product fp_3 ON (p.id_product = fp_3.id_product) WHERE ((fp.id_feature=5)) AND ((fp_1.id_feature_value=2)) AND ((fp_2.id_feature_value=54)) AND ((fp_3.id_feature_value IN (119, 197, 182, 131, 129, 190, 201))) GROUP BY fp.id_feature_value	2.792 ms	364800000	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:778 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:855 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:154 (getFeaturesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:356 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:135 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
2	SELECT SQL_NO_CACHE c.`name`, cl.`id_lang`, IF(cl.`id_lang` IS NULL, c.`value`, cl.`value`) AS value, c.id_shop_group, c.id_shop FROM `ps_configuration` c LEFT JOIN `ps_configuration_lang` cl ON (c.`id_configuration` = cl.`id_configuration`)	2.708 ms	1121			/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)
18	SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module`as `mshop` FROM `ps_module` m LEFT JOIN `ps_module_shop` ms ON m.`id_module` = ms.`id_module` AND ms.`id_shop` = 1	2.627 ms	108			/classes/module/Module.php:341 /modules/thecheckout/thecheckout.php:58 (__construct) :undefined (__construct) /src/Core/Foundation/IoC/Container.php:123 (newInstance) /src/Core/Foundation/IoC/Container.php:153 (makeInstanceFromClassName) /src/Core/Foundation/IoC/Container.php:166 (doMake) /src/Adapter/ServiceLocator.php:70 (make) /classes/module/Module.php:1258 (get) /tools/profiling/Module.php:35 (coreLoadModule) /classes/module/Module.php:1237 (coreLoadModule) /classes/Hook.php:966 (getInstanceByName) /classes/Dispatcher.php:507 (exec) /index.php:28 (dispatch)
13	SELECT SQL_NO_CACHE h.`name` as hook, m.`id_module`, h.`id_hook`, m.`name` as module FROM `ps_module` m INNER JOIN ps_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 `ps_hook_module` `hm` ON hm.`id_module` = m.`id_module` INNER JOIN `ps_hook` `h` ON hm.`id_hook` = h.`id_hook` LEFT JOIN `ps_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.508 ms	324	Yes	Yes	/classes/Hook.php:1267 /classes/Hook.php:735 (getAllHookRegistrations) /classes/Hook.php:842 (getHookModuleExecList) /classes/Dispatcher.php:606 (exec) /classes/Dispatcher.php:243 (loadRoutes) /classes/Dispatcher.php:201 (__construct) /index.php:28 (getInstance)
82	SELECT SQL_NO_CACHE v., vl., IF(lifvlv.`url_name` IS NULL OR lifvlv.`url_name` = "", NULL, lifvlv.`url_name`) AS url_name, IF(lifvlv.`meta_title` IS NULL OR lifvlv.`meta_title` = "", NULL, lifvlv.`meta_title`) AS meta_title FROM `ps_feature_value` v LEFT JOIN `ps_feature_value_lang` vl ON (v.`id_feature_value` = vl.`id_feature_value` AND vl.`id_lang` = 1) LEFT JOIN `ps_layered_indexable_feature_value_lang_value` lifvlv ON (v.`id_feature_value` = lifvlv.`id_feature_value` AND lifvlv.`id_lang` = 1) WHERE v.`id_feature` = 13 ORDER BY vl.`value` ASC	2.419 ms	42	Yes		/modules/ps_facetedsearch/src/Filters/DataAccessor.php:194 /modules/ps_facetedsearch/src/Filters/Converter.php:402 (getFeatureValues) /modules/ps_facetedsearch/src/Product/SearchProvider.php:163 (createFacetedSearchFiltersFromQuery) /classes/controller/ProductListingFrontController.php:356 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:135 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
103	SELECT SQL_NO_CACHE fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM ps_product p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_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 ps_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN ps_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN ps_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN ps_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((fp.id_feature_value=2)) AND ((fp_1.id_feature_value=54)) AND ((fp_2.id_feature_value IN (119, 197, 182, 131, 129, 190, 201))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=2 AND c.nright<=229 GROUP BY p.id_product) p INNER JOIN ps_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN ps_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN ps_feature_product fp_2 ON (p.id_product = fp_2.id_product) LEFT JOIN ps_feature_product fp_3 ON (p.id_product = fp_3.id_product) WHERE ((fp.id_feature=14)) AND ((fp_1.id_feature_value=2)) AND ((fp_2.id_feature_value=54)) AND ((fp_3.id_feature_value IN (119, 197, 182, 131, 129, 190, 201))) GROUP BY fp.id_feature_value	2.275 ms	364800000	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:778 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:855 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:154 (getFeaturesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:356 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:135 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
272	INSERT INTO `ps_connections_source` (`id_connections`, `http_referer`, `request_uri`, `keywords`, `date_add`) VALUES ('7331', '', 'argento.sk/2-uvodna-stranka?q=Povrchov%C3%A1+%C3%BAprava-Rhodiovan%C3%A1%2FMot%C3%ADv-Anjel-Gitara-Labka-List-Nota-Slon-Tenis%2FD%C4%BA%C5%BEka-46+cm', '', '2026-01-30 07:49:15')	2.272 ms	1			/classes/ObjectModel.php:622 /classes/ConnectionsSource.php:105 (add) /modules/statsdata/statsdata.php:119 (logHttpReferer) /modules/statsdata/statsdata.php:74 (getScriptCustomerPagesViews) /classes/Hook.php:1077 (hookDisplayBeforeBodyClosingTag) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:418 (coreCallHook) /classes/Hook.php:983 (callHookOn) /config/smarty.config.inc.php:201 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/prod/smarty/compile/giftshoplayouts_layout_left_column_tpl/91/22/bc/9122bc47d094dc04c4f118787769e4ef7bf89f7b_2.file.layout-both-columns.tpl.php:120 (__call) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_697b215d87c868_90280364) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:115 (_subTemplateRender) /var/cache/prod/smarty/compile/giftshoplayouts_layout_left_column_tpl/01/55/38/015538200d6e4837a58f8f9c1201cd595a252a7a_2.file.layout-left-column.tpl.php:38 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_697b215d824722_09566471) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:115 (_subTemplateRender) /var/cache/prod/smarty/compile/giftshoplayouts_layout_left_column_tpl/83/b5/fc/83b5fce11cdf0e80e9ccfae571f5fdc7a9d5f07a_2.file.product-list.tpl.php:37 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_697b215d81ec72_50866102) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:115 (_subTemplateRender) /var/cache/prod/smarty/compile/giftshoplayouts_layout_left_column_tpl/ef/f1/5e/eff15ee23a4262b61d071dba8e87a90261bcdc9b_2.file.category.tpl.php:37 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_697b215d7f9e61_36453509) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/controller/FrontController.php:771 (fetch) /classes/controller/FrontController.php:753 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
101	SELECT SQL_NO_CACHE fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM ps_product p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_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 ps_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN ps_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN ps_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN ps_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((fp.id_feature_value=2)) AND ((fp_1.id_feature_value=54)) AND ((fp_2.id_feature_value IN (119, 197, 182, 131, 129, 190, 201))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=2 AND c.nright<=229 GROUP BY p.id_product) p INNER JOIN ps_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN ps_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN ps_feature_product fp_2 ON (p.id_product = fp_2.id_product) LEFT JOIN ps_feature_product fp_3 ON (p.id_product = fp_3.id_product) WHERE ((fp.id_feature=12)) AND ((fp_1.id_feature_value=2)) AND ((fp_2.id_feature_value=54)) AND ((fp_3.id_feature_value IN (119, 197, 182, 131, 129, 190, 201))) GROUP BY fp.id_feature_value	2.205 ms	364800000	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:778 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:855 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:154 (getFeaturesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:356 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:135 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
128	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 `ps_hook_module` hm STRAIGHT_JOIN `ps_hook` h ON (h.id_hook = hm.id_hook AND hm.id_shop = 1) STRAIGHT_JOIN `ps_module` as m ON (m.id_module = hm.id_module) ORDER BY hm.position	2.133 ms	463			/classes/Hook.php:452 /classes/Hook.php:493 (getHookModuleList) /classes/tax/TaxManagerFactory.php:67 (getModulesFromHook) /classes/tax/TaxManagerFactory.php:46 (execHookTaxManagerFactory) /override/classes/Product.php:3915 (getManager) /override/classes/Product.php:3706 (priceCalculation) /override/classes/Product.php:5638 (getPriceStatic) /classes/ProductAssembler.php:206 (getProductProperties) /classes/controller/ProductListingFrontController.php:108 (assembleProducts) /classes/controller/ProductListingFrontController.php:378 (prepareMultipleProductsForTemplate) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:135 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
25	SELECT SQL_NO_CACHE value FROM `ps_configuration` WHERE `name` = "PS_MULTISHOP_FEATURE_ACTIVE" LIMIT 1	2.114 ms	1			/classes/shop/Shop.php:1183 /classes/Currency.php:968 (isFeatureActive) /classes/Currency.php:890 (getIdByQuery) /src/Adapter/Currency/CurrencyDataProvider.php:92 (getIdByIsoCode) /src/Adapter/Currency/CurrencyDataProvider.php:114 (getCurrencyByIsoCode) /src/Core/Localization/Currency/DataLayer/CurrencyDatabase.php:102 (getCurrencyByIsoCodeAndLocale) /src/Core/Data/Layer/AbstractDataLayer.php:91 (doRead) /src/Core/Data/Layer/AbstractDataLayer.php:150 (read) /src/Core/Data/Layer/AbstractDataLayer.php:95 (propagateRead) /src/Core/Localization/Currency/CurrencyDataSource.php:67 (read) /src/Core/Localization/Currency/CurrencyDataSource.php:109 (getLocalizedCurrencyData) /src/Core/Localization/Currency/CurrencyDataSource.php:96 (formatCurrenciesData) /src/Core/Localization/Currency/Repository.php:87 (getAllInstalledCurrenciesData) /src/Core/Localization/Locale/Repository.php:207 (getAllInstalledCurrencies) /src/Core/Localization/Locale/Repository.php:150 (getPriceSpecifications) /classes/controller/Controller.php:208 (getLocale) /classes/controller/FrontController.php:284 (init) /controllers/front/listing/CategoryController.php:81 (init) /tools/profiling/Controller.php:41 (init) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
67	SELECT SQL_NO_CACHE 1 FROM `ps_cart_rule` WHERE ((date_to >= "2026-01-30 00:00:00" AND date_to <= "2026-01-30 23:59:59") OR (date_from >= "2026-01-30 00:00:00" AND date_from <= "2026-01-30 23:59:59") OR (date_from < "2026-01-30 00:00:00" AND date_to > "2026-01-30 23:59:59")) AND `id_customer` IN (0,0) LIMIT 1	2.091 ms	2440			/classes/CartRule.php:357 /classes/CartRule.php:389 (haveCartRuleToday) /classes/Cart.php:3072 (getCustomerCartRules) /classes/Cart.php:3463 (getDeliveryOptionList) /modules/dm_cashondelivery/dm_cashondelivery.php:891 (getDeliveryOption) /modules/dm_cashondelivery/dm_cashondelivery.php:904 (getCarrierId) /classes/Hook.php:1077 (hookDisplayHeader) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:418 (coreCallHook) /classes/Hook.php:983 (callHookOn) /classes/controller/FrontController.php:633 (exec) /controllers/front/listing/CategoryController.php:127 (initContent) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
26	SELECT SQL_NO_CACHE c.id_currency FROM `ps_currency` c WHERE (iso_code = 'EUR') LIMIT 1	2.079 ms	1			/classes/Currency.php:893 /src/Adapter/Currency/CurrencyDataProvider.php:92 (getIdByIsoCode) /src/Adapter/Currency/CurrencyDataProvider.php:114 (getCurrencyByIsoCode) /src/Core/Localization/Currency/DataLayer/CurrencyDatabase.php:102 (getCurrencyByIsoCodeAndLocale) /src/Core/Data/Layer/AbstractDataLayer.php:91 (doRead) /src/Core/Data/Layer/AbstractDataLayer.php:150 (read) /src/Core/Data/Layer/AbstractDataLayer.php:95 (propagateRead) /src/Core/Localization/Currency/CurrencyDataSource.php:67 (read) /src/Core/Localization/Currency/CurrencyDataSource.php:109 (getLocalizedCurrencyData) /src/Core/Localization/Currency/CurrencyDataSource.php:96 (formatCurrenciesData) /src/Core/Localization/Currency/Repository.php:87 (getAllInstalledCurrenciesData) /src/Core/Localization/Locale/Repository.php:207 (getAllInstalledCurrencies) /src/Core/Localization/Locale/Repository.php:150 (getPriceSpecifications) /classes/controller/Controller.php:208 (getLocale) /classes/controller/FrontController.php:284 (init) /controllers/front/listing/CategoryController.php:81 (init) /tools/profiling/Controller.php:41 (init) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
98	SELECT SQL_NO_CACHE fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM ps_product p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_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 ps_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN ps_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN ps_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN ps_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((fp.id_feature_value=2)) AND ((fp_1.id_feature_value=54)) AND ((fp_2.id_feature_value IN (119, 197, 182, 131, 129, 190, 201))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=2 AND c.nright<=229 GROUP BY p.id_product) p INNER JOIN ps_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN ps_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN ps_feature_product fp_2 ON (p.id_product = fp_2.id_product) LEFT JOIN ps_feature_product fp_3 ON (p.id_product = fp_3.id_product) WHERE ((fp.id_feature=10)) AND ((fp_1.id_feature_value=2)) AND ((fp_2.id_feature_value=54)) AND ((fp_3.id_feature_value IN (119, 197, 182, 131, 129, 190, 201))) GROUP BY fp.id_feature_value	2.056 ms	364800000	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:778 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:855 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:154 (getFeaturesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:356 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:135 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
108	SELECT SQL_NO_CACHE fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM ps_product p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_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 ps_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN ps_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN ps_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN ps_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((fp.id_feature_value=2)) AND ((fp_1.id_feature_value=54)) AND ((fp_2.id_feature_value IN (119, 197, 182, 131, 129, 190, 201))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=2 AND c.nright<=229 GROUP BY p.id_product) p INNER JOIN ps_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN ps_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN ps_feature_product fp_2 ON (p.id_product = fp_2.id_product) LEFT JOIN ps_feature_product fp_3 ON (p.id_product = fp_3.id_product) WHERE ((fp.id_feature=7)) AND ((fp_1.id_feature_value=2)) AND ((fp_2.id_feature_value=54)) AND ((fp_3.id_feature_value IN (119, 197, 182, 131, 129, 190, 201))) GROUP BY fp.id_feature_value	1.928 ms	364800000	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:778 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:855 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:154 (getFeaturesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:356 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:135 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
12	SELECT SQL_NO_CACHE lower(name) as name FROM `ps_hook` h WHERE (h.active = 1)	1.921 ms	1059			/classes/Hook.php:1366 /classes/Hook.php:811 (getHookStatusByName) /classes/Dispatcher.php:606 (exec) /classes/Dispatcher.php:243 (loadRoutes) /classes/Dispatcher.php:201 (__construct) /index.php:28 (getInstance)
20	SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "xbraintreeofficial" LIMIT 1	1.919 ms	0			/classes/module/Module.php:2659 /classes/module/Module.php:2107 (getModuleIdByName) /modules/thecheckout/classes/Config.php:153 (isInstalled) /modules/thecheckout/thecheckout.php:287 (__construct) /modules/thecheckout/thecheckout.php:237 (setConfigOptions) /modules/thecheckout/thecheckout.php:67 (initTheCheckout) :undefined (__construct) /src/Core/Foundation/IoC/Container.php:123 (newInstance) /src/Core/Foundation/IoC/Container.php:153 (makeInstanceFromClassName) /src/Core/Foundation/IoC/Container.php:166 (doMake) /src/Adapter/ServiceLocator.php:70 (make) /classes/module/Module.php:1258 (get) /tools/profiling/Module.php:35 (coreLoadModule) /classes/module/Module.php:1237 (coreLoadModule) /classes/Hook.php:966 (getInstanceByName) /classes/Dispatcher.php:507 (exec) /index.php:28 (dispatch)
99	SELECT SQL_NO_CACHE fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM ps_product p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_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 ps_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN ps_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN ps_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN ps_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((fp.id_feature_value=2)) AND ((fp_1.id_feature_value=54)) AND ((fp_2.id_feature_value IN (119, 197, 182, 131, 129, 190, 201))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=2 AND c.nright<=229 GROUP BY p.id_product) p INNER JOIN ps_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN ps_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN ps_feature_product fp_2 ON (p.id_product = fp_2.id_product) LEFT JOIN ps_feature_product fp_3 ON (p.id_product = fp_3.id_product) WHERE ((fp.id_feature=4)) AND ((fp_1.id_feature_value=2)) AND ((fp_2.id_feature_value=54)) AND ((fp_3.id_feature_value IN (119, 197, 182, 131, 129, 190, 201))) GROUP BY fp.id_feature_value	1.880 ms	364800000	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:778 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:855 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:154 (getFeaturesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:356 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:135 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
248	SELECT SQL_NO_CACHE c., cl. FROM `ps_category` c INNER JOIN ps_category_shop category_shop ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1) LEFT JOIN `ps_category_lang` cl ON c.`id_category` = cl.`id_category` AND cl.id_shop = 1 LEFT JOIN `ps_category_group` cg ON c.`id_category` = cg.`id_category` RIGHT JOIN `ps_category` c2 ON c2.`id_category` = 2 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright` WHERE 1 AND c.`level_depth` <= 5 AND `id_lang` = 1 AND c.`active` = 1 AND cg.`id_group` IN (1) GROUP BY c.`id_category` ORDER BY c.`level_depth` ASC, category_shop.`position` ASC	1.874 ms	115	Yes	Yes	/classes/Category.php:785 /modules/ps_categorytree/ps_categorytree.php:141 (getNestedCategories) /modules/ps_categorytree/ps_categorytree.php:298 (getCategories) /modules/ps_categorytree/ps_categorytree.php:266 (getWidgetVariables) /classes/Hook.php:1088 (renderWidget) /tools/profiling/Hook.php:64 (coreRenderWidget) /classes/Hook.php:1019 (coreRenderWidget) /config/smarty.config.inc.php:201 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/prod/smarty/compile/giftshoplayouts_layout_left_column_tpl/91/22/bc/9122bc47d094dc04c4f118787769e4ef7bf89f7b_2.file.layout-both-columns.tpl.php:234 (__call) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/giftshoplayouts_layout_left_column_tpl/91/22/bc/9122bc47d094dc04c4f118787769e4ef7bf89f7b_2.file.layout-both-columns.tpl.php:87 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_697b215d87c868_90280364) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:115 (_subTemplateRender) /var/cache/prod/smarty/compile/giftshoplayouts_layout_left_column_tpl/01/55/38/015538200d6e4837a58f8f9c1201cd595a252a7a_2.file.layout-left-column.tpl.php:38 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_697b215d824722_09566471) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:115 (_subTemplateRender) /var/cache/prod/smarty/compile/giftshoplayouts_layout_left_column_tpl/83/b5/fc/83b5fce11cdf0e80e9ccfae571f5fdc7a9d5f07a_2.file.product-list.tpl.php:37 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_697b215d81ec72_50866102) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:115 (_subTemplateRender) /var/cache/prod/smarty/compile/giftshoplayouts_layout_left_column_tpl/ef/f1/5e/eff15ee23a4262b61d071dba8e87a90261bcdc9b_2.file.category.tpl.php:37 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_697b215d7f9e61_36453509) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/controller/FrontController.php:771 (fetch) /classes/controller/FrontController.php:753 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
111	SELECT SQL_NO_CACHE fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM ps_product p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_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 ps_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN ps_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN ps_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN ps_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((fp.id_feature_value=2)) AND ((fp_1.id_feature_value=54)) AND ((fp_2.id_feature_value IN (119, 197, 182, 131, 129, 190, 201))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=2 AND c.nright<=229 GROUP BY p.id_product) p INNER JOIN ps_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN ps_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN ps_feature_product fp_2 ON (p.id_product = fp_2.id_product) LEFT JOIN ps_feature_product fp_3 ON (p.id_product = fp_3.id_product) WHERE ((fp.id_feature=16)) AND ((fp_1.id_feature_value=2)) AND ((fp_2.id_feature_value=54)) AND ((fp_3.id_feature_value IN (119, 197, 182, 131, 129, 190, 201))) GROUP BY fp.id_feature_value	1.839 ms	3648000000	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:778 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:855 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:154 (getFeaturesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:356 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:135 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
30	SELECT SQL_NO_CACHE * FROM `ps_currency_lang` WHERE `id_currency` = 1	1.802 ms	1			/src/Adapter/EntityMapper.php:79 /classes/ObjectModel.php:283 (load) /tools/profiling/ObjectModel.php:32 (__construct) /classes/Currency.php:246 (__construct) /classes/Currency.php:1089 (__construct) /classes/Tools.php:690 (getCurrencyInstance) /classes/controller/FrontController.php:368 (setCurrency) /controllers/front/listing/CategoryController.php:81 (init) /tools/profiling/Controller.php:41 (init) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
186	SELECT SQL_NO_CACHE 1 FROM `ps_cart_rule` WHERE ((date_to >= "2026-01-30 00:00:00" AND date_to <= "2026-01-30 23:59:59") OR (date_from >= "2026-01-30 00:00:00" AND date_from <= "2026-01-30 23:59:59") OR (date_from < "2026-01-30 00:00:00" AND date_to > "2026-01-30 23:59:59")) AND `id_customer` IN (0,0) LIMIT 1	1.753 ms	2440			/classes/CartRule.php:357 /classes/CartRule.php:389 (haveCartRuleToday) /classes/CartRule.php:570 (getCustomerCartRules) /classes/Cart.php:522 (getCustomerHighlightedDiscounts) /src/Adapter/Presenter/Cart/CartLazyArray.php:396 (getDiscounts) /src/Adapter/Presenter/AbstractLazyArray.php:269 (getDiscounts) /src/Adapter/Presenter/AbstractLazyArray.php:129 (offsetGet) :undefined (jsonSerialize) /classes/Smarty/SmartyLazyRegister.php:81 (json_encode) /var/cache/prod/smarty/compile/giftshoplayouts_layout_left_column_tpl/4b/9c/24/4b9c241d63310e348778e1166e4480d40b933c62_2.file.javascript.tpl.php:65 (__call) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_697b215d96f0a3_63601271) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /var/cache/prod/smarty/compile/giftshoplayouts_layout_left_column_tpl/86/3c/71/863c711c71da4ab03408b5885ac3aeaa6e15b874_2.file.head.tpl.php:167 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/giftshoplayouts_layout_left_column_tpl/86/3c/71/863c711c71da4ab03408b5885ac3aeaa6e15b874_2.file.head.tpl.php:59 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_697b215d8e8e68_08933279) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /var/cache/prod/smarty/compile/giftshoplayouts_layout_left_column_tpl/91/22/bc/9122bc47d094dc04c4f118787769e4ef7bf89f7b_2.file.layout-both-columns.tpl.php:139 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/giftshoplayouts_layout_left_column_tpl/91/22/bc/9122bc47d094dc04c4f118787769e4ef7bf89f7b_2.file.layout-both-columns.tpl.php:40 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_697b215d87c868_90280364) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:115 (_subTemplateRender) /var/cache/prod/smarty/compile/giftshoplayouts_layout_left_column_tpl/01/55/38/015538200d6e4837a58f8f9c1201cd595a252a7a_2.file.layout-left-column.tpl.php:38 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_697b215d824722_09566471) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:115 (_subTemplateRender) /var/cache/prod/smarty/compile/giftshoplayouts_layout_left_column_tpl/83/b5/fc/83b5fce11cdf0e80e9ccfae571f5fdc7a9d5f07a_2.file.product-list.tpl.php:37 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_697b215d81ec72_50866102) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:115 (_subTemplateRender) /var/cache/prod/smarty/compile/giftshoplayouts_layout_left_column_tpl/ef/f1/5e/eff15ee23a4262b61d071dba8e87a90261bcdc9b_2.file.category.tpl.php:37 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_697b215d7f9e61_36453509) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/controller/FrontController.php:771 (fetch) /classes/controller/FrontController.php:753 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
75	DELETE FROM `ps_arproductlist_views_category` WHERE `view_date` < '2026-01-23 07:49:15'	1.726 ms	1			/modules/arproductlists/classes/ArCategoryViews.php:89 /modules/arproductlists/classes/ArCategoryViews.php:74 (cleanUp) /modules/arproductlists/arproductlists.php:197 (viewCategory) /modules/arproductlists/arproductlists.php:604 (addViewedCategory) /classes/Hook.php:1077 (hookDisplayHeader) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:418 (coreCallHook) /classes/Hook.php:983 (callHookOn) /classes/controller/FrontController.php:633 (exec) /controllers/front/listing/CategoryController.php:127 (initContent) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
15	SELECT SQL_NO_CACHE m.page, ml.url_rewrite, ml.id_lang FROM `ps_meta` m LEFT JOIN `ps_meta_lang` ml ON (m.id_meta = ml.id_meta AND ml.id_shop = 1 ) ORDER BY LENGTH(ml.url_rewrite) DESC	1.653 ms	50	Yes		/classes/Dispatcher.php:654 /classes/Dispatcher.php:243 (loadRoutes) /classes/Dispatcher.php:201 (__construct) /index.php:28 (getInstance)
5	SELECT SQL_NO_CACHE l.*, ls.`id_shop` FROM `ps_lang` l LEFT JOIN `ps_lang_shop` ls ON (l.id_lang = ls.id_lang)	1.652 ms	1			/classes/Language.php:1080 /config/config.inc.php:143 (loadLanguages) /index.php:27 (require)
4	SELECT SQL_NO_CACHE su.physical_uri, su.virtual_uri, su.domain, su.domain_ssl FROM ps_shop s LEFT JOIN ps_shop_url su ON (s.id_shop = su.id_shop) WHERE s.id_shop = 1 AND s.active = 1 AND s.deleted = 0 AND su.main = 1 LIMIT 1	1.641 ms	1			/classes/shop/Shop.php:214 /classes/shop/Shop.php:148 (setUrl) /classes/shop/Shop.php:431 (__construct) /config/config.inc.php:117 (initialize) /index.php:27 (require)

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