Slnečné okuliare – Štýlové dámske okuliare na leto | NajlepšiaMóda.sk

Filter

Zoradiť:
Najnovšie
Najlacnejšie

DOSTUPNÉ
Univerzálna

Čierne fashion okuliare s modrými sklami a cat-eye...
25,90 €
SKLADOM
Univerzálna

-19% Ušetrite -3,00 €

Štýlové modré štvorcové slnečné okuliare
12,90 € 15,90 € Ušetríte 3,00 €
SKLADOM
Univerzálna

-25% Ušetrite -4,00 €

Štýlové štvorcové okuliare s kovovým detailom
11,90 € 15,90 € Ušetríte 4,00 €

Zobrazených všetkých 3 produktov

Load Time	155 ms - Unicorn powered webserver!
Querying Time	52 ms
Queries	217
Memory Peak Usage	9.7 Mb
Included Files	313 files - 5.04 Mb
PrestaShop Cache	- Mb
Global vars	0.57 Mb
- global $_MODULES	299k
- global $nmBan	143k
- global $_LANG	128k
- global $_SERVER	7k
- global $_MODULE	3k

PrestaShop Version	1.6.1.17
PHP Version	7.1.33-80+0~20261021.127+debian12~1.gbp7a3318 (OK)
MySQL Version	10.11.18-MariaDB-0+deb12u1-log (OK)
Memory Limit	256M
Max Execution Time	480s
Smarty Cache	disabled
Smarty Compilation	auto

	Time	Cumulated Time	Memory Usage	Memory Peak Usage
config	23 ms	23 ms	3.44 Mb	3.44 Mb
__construct	0 ms	23 ms	- Mb	3.44 Mb
init	6 ms	29 ms	0.85 Mb	4.56 Mb
checkAccess	0 ms	29 ms	- Mb	4.56 Mb
setMedia	1 ms	31 ms	0.03 Mb	4.56 Mb
postProcess	0 ms	31 ms	- Mb	4.56 Mb
initHeader	0 ms	31 ms	- Mb	4.56 Mb
initContent	73 ms	104 ms	3.79 Mb	8.12 Mb
initFooter	8 ms	112 ms	0.30 Mb	8.42 Mb
display	43 ms	155 ms	0.97 Mb	9.70 Mb

Hook	Time	Memory Usage
hookdisplayTop	18 ms	- Mb
=> blockuserinfo	0 ms	- Mb
=> bamegamenu	17 ms	- Mb
hookproductlistassign	15 ms	- Mb
=> blocklayered	15 ms	- Mb
__construct	10 ms	- Mb
=> nmban	1 ms	- Mb
=> datakick	1 ms	- Mb
=> fsadvancedurl	1 ms	- Mb
=> revws	1 ms	- Mb
=> blockcart	1 ms	- Mb
=> blockcategories	0 ms	- Mb
=> blockcms	0 ms	- Mb
=> blockcontact	0 ms	- Mb
=> blockcontactinfos	0 ms	- Mb
=> blockmyaccount	0 ms	- Mb
=> blockmyaccountfooter	0 ms	- Mb
=> blocknewproducts	0 ms	- Mb
=> blocknewsletter	1 ms	- Mb
=> blocksearch	0 ms	- Mb
=> blockuserinfo	0 ms	- Mb
=> homefeatured	0 ms	- Mb
=> themeconfigurator	0 ms	- Mb
=> productaccessories	0 ms	- Mb
=> productscategory	0 ms	- Mb
=> bamegamenu	1 ms	- Mb
=> gmseofields	0 ms	- Mb
=> blocklayered	0 ms	- Mb
=> stlazyloading	0 ms	- Mb
=> socialsharing	0 ms	- Mb
=> paybysquare	0 ms	- Mb
=> productlistpics	0 ms	- Mb
=> blockviewed_mod	0 ms	- Mb
=> csoft_instagramfeeds	0 ms	- Mb
=> blockspecials	0 ms	- Mb
=> returnform	0 ms	- Mb
=> homeslider	0 ms	- Mb
=> dynamiccategories	0 ms	- Mb
=> topbanner	0 ms	- Mb
=> productvideos	0 ms	- Mb
=> vatnumber	0 ms	- Mb
=> contentboxinstagram	0 ms	- Mb
=> contentbox2	0 ms	- Mb
=> nmtraffic	0 ms	- Mb
=> attributes	0 ms	- Mb
hookheader	8 ms	- Mb
=> blockcart	0 ms	- Mb
=> blockcategories	0 ms	- Mb
=> blockcms	0 ms	- Mb
=> blockcontactinfos	- ms	- Mb
=> blockmyaccountfooter	- ms	- Mb
=> blocknewproducts	0 ms	- Mb
=> blocksearch	0 ms	- Mb
=> productaccessories	- ms	- Mb
=> productscategory	- ms	- Mb
=> blocklayered	6 ms	- Mb
=> paybysquare	0 ms	- Mb
=> productlistpics	1 ms	- Mb
=> blockviewed_mod	0 ms	- Mb
=> blockspecials	0 ms	- Mb
=> dynamiccategories	- ms	- Mb
=> topbanner	0 ms	- Mb
hookdisplayHeader	4 ms	- Mb
=> blockcontact	- ms	- Mb
=> blockmyaccount	- ms	- Mb
=> blocknewsletter	0 ms	- Mb
=> blockuserinfo	0 ms	- Mb
=> homefeatured	0 ms	- Mb
=> themeconfigurator	1 ms	- Mb
=> bamegamenu	1 ms	- Mb
=> fsadvancedurl	- ms	- Mb
=> gmseofields	0 ms	- Mb
=> stlazyloading	0 ms	- Mb
=> socialsharing	- ms	- Mb
=> revws	1 ms	- Mb
=> csoft_instagramfeeds	0 ms	- Mb
=> returnform	0 ms	- Mb
=> homeslider	- ms	- Mb
=> nmban	- ms	- Mb
=> productvideos	- ms	- Mb
hookdisplayNav	3 ms	- Mb
=> blockcart	1 ms	- Mb
=> blockuserinfo	1 ms	- Mb
=> blocksearch	1 ms	- Mb
=> blockcontact	0 ms	- Mb
hookfooter	3 ms	- Mb
=> blocknewsletter	0 ms	- Mb
=> blockcontactinfos	0 ms	- Mb
=> blockcms	2 ms	- Mb
=> blockmyaccountfooter	0 ms	- Mb
hookdisplayProductOnListVsetky	2 ms	- Mb
=> attributes	0 ms	- Mb
hookdisplayFooter	2 ms	- Mb
=> themeconfigurator	0 ms	- Mb
=> contentboxinstagram	1 ms	- Mb
=> contentbox2	1 ms	- Mb
=> nmtraffic	0 ms	- Mb
hookcategoryTop	1 ms	- Mb
=> blocklayered	1 ms	- Mb
hookdisplayProductListReviews	1 ms	- Mb
=> revws	0 ms	- Mb
=> productlistpics	- ms	- Mb
hookleftcolumn	1 ms	- Mb
=> blockcms	1 ms	- Mb
hookdisplayBanner	1 ms	- Mb
=> topbanner	1 ms	- Mb
hookdisplayLeftColumn	0 ms	- Mb
=> themeconfigurator	0 ms	- Mb
hookdisplayProductVideoListSlide	0 ms	- Mb
=> productvideos	- ms	- Mb
hookmoduleRoutes	0 ms	- Mb
=> datakick	- ms	- Mb
=> fsadvancedurl	0 ms	- Mb
=> revws	- ms	- Mb
hookactionDispatcher	- ms	- Mb
=> fsadvancedurl	- ms	- Mb
=> nmban	- ms	- Mb
hookdisplayTopColumn	- ms	- Mb
=> themeconfigurator	- ms	- Mb
=> homeslider	- ms	- Mb
18 hooks	71 ms	- Mb

Module	Time	Memory Usage
blocklayered	23 ms	- Mb
=> __construct	0 ms	- Mb
=> hookheader	6 ms	- Mb
=> hookproductlistassign	15 ms	- Mb
=> hookcategoryTop	1 ms	- Mb
bamegamenu	20 ms	- Mb
=> __construct	1 ms	- Mb
=> hookdisplayHeader	1 ms	- Mb
=> hookdisplayTop	17 ms	- Mb
blockcms	3 ms	- Mb
=> __construct	0 ms	- Mb
=> hookheader	0 ms	- Mb
=> hookleftcolumn	1 ms	- Mb
=> hookfooter	2 ms	- Mb
revws	3 ms	- Mb
=> __construct	1 ms	- Mb
=> hookmoduleRoutes	- ms	- Mb
=> hookdisplayHeader	1 ms	- Mb
=> hookdisplayProductListReviews	0 ms	- Mb
attributes	2 ms	- Mb
=> __construct	0 ms	- Mb
=> hookdisplayProductOnListVsetky	0 ms	- Mb
blockcart	2 ms	- Mb
=> __construct	1 ms	- Mb
=> hookheader	0 ms	- Mb
=> hookdisplayNav	1 ms	- Mb
themeconfigurator	2 ms	- Mb
=> __construct	0 ms	- Mb
=> hookdisplayHeader	1 ms	- Mb
=> hookdisplayLeftColumn	0 ms	- Mb
=> hookdisplayFooter	0 ms	- Mb
=> hookdisplayTopColumn	- ms	- Mb
blocknewsletter	2 ms	- Mb
=> __construct	1 ms	- Mb
=> hookdisplayHeader	0 ms	- Mb
=> hookfooter	0 ms	- Mb
blocksearch	1 ms	- Mb
=> __construct	0 ms	- Mb
=> hookheader	0 ms	- Mb
=> hookdisplayNav	1 ms	- Mb
topbanner	1 ms	- Mb
=> __construct	0 ms	- Mb
=> hookheader	0 ms	- Mb
=> hookdisplayBanner	1 ms	- Mb
blockuserinfo	1 ms	- Mb
=> __construct	0 ms	- Mb
=> hookdisplayHeader	0 ms	- Mb
=> hookdisplayTop	0 ms	- Mb
=> hookdisplayNav	1 ms	- Mb
fsadvancedurl	1 ms	- Mb
=> __construct	1 ms	- Mb
=> hookmoduleRoutes	0 ms	- Mb
=> hookactionDispatcher	- ms	- Mb
=> hookdisplayHeader	- ms	- Mb
productlistpics	1 ms	- Mb
=> __construct	0 ms	- Mb
=> hookheader	1 ms	- Mb
=> hookdisplayProductListReviews	- ms	- Mb
contentboxinstagram	1 ms	- Mb
=> __construct	0 ms	- Mb
=> hookdisplayFooter	1 ms	- Mb
contentbox2	1 ms	- Mb
=> __construct	0 ms	- Mb
=> hookdisplayFooter	1 ms	- Mb
nmban	1 ms	- Mb
=> __construct	1 ms	- Mb
=> hookactionDispatcher	- ms	- Mb
=> hookdisplayHeader	- ms	- Mb
datakick	1 ms	- Mb
=> __construct	1 ms	- Mb
=> hookmoduleRoutes	- ms	- Mb
stlazyloading	1 ms	- Mb
=> __construct	0 ms	- Mb
=> hookdisplayHeader	0 ms	- Mb
blockcontactinfos	1 ms	- Mb
=> __construct	0 ms	- Mb
=> hookheader	- ms	- Mb
=> hookfooter	0 ms	- Mb
blockmyaccountfooter	1 ms	- Mb
=> __construct	0 ms	- Mb
=> hookheader	- ms	- Mb
=> hookfooter	0 ms	- Mb
blockcontact	0 ms	- Mb
=> __construct	0 ms	- Mb
=> hookdisplayHeader	- ms	- Mb
=> hookdisplayNav	0 ms	- Mb
productvideos	0 ms	- Mb
=> __construct	0 ms	- Mb
=> hookdisplayHeader	- ms	- Mb
=> hookdisplayProductVideoListSlide	- ms	- Mb
nmtraffic	0 ms	- Mb
=> __construct	0 ms	- Mb
=> hookdisplayFooter	0 ms	- Mb
paybysquare	0 ms	- Mb
=> __construct	0 ms	- Mb
=> hookheader	0 ms	- Mb
csoft_instagramfeeds	0 ms	- Mb
=> __construct	0 ms	- Mb
=> hookdisplayHeader	0 ms	- Mb
blockspecials	0 ms	- Mb
=> __construct	0 ms	- Mb
=> hookheader	0 ms	- Mb
homefeatured	0 ms	- Mb
=> __construct	0 ms	- Mb
=> hookdisplayHeader	0 ms	- Mb
returnform	0 ms	- Mb
=> __construct	0 ms	- Mb
=> hookdisplayHeader	0 ms	- Mb
gmseofields	0 ms	- Mb
=> __construct	0 ms	- Mb
=> hookdisplayHeader	0 ms	- Mb
vatnumber	0 ms	- Mb
=> __construct	0 ms	- Mb
blockcategories	0 ms	- Mb
=> __construct	0 ms	- Mb
=> hookheader	0 ms	- Mb
dynamiccategories	0 ms	- Mb
=> __construct	0 ms	- Mb
=> hookheader	- ms	- Mb
productaccessories	0 ms	- Mb
=> __construct	0 ms	- Mb
=> hookheader	- ms	- Mb
blockviewed_mod	0 ms	- Mb
=> __construct	0 ms	- Mb
=> hookheader	0 ms	- Mb
blocknewproducts	0 ms	- Mb
=> __construct	0 ms	- Mb
=> hookheader	0 ms	- Mb
socialsharing	0 ms	- Mb
=> __construct	0 ms	- Mb
=> hookdisplayHeader	- ms	- Mb
blockmyaccount	0 ms	- Mb
=> __construct	0 ms	- Mb
=> hookdisplayHeader	- ms	- Mb
homeslider	0 ms	- Mb
=> __construct	0 ms	- Mb
=> hookdisplayHeader	- ms	- Mb
=> hookdisplayTopColumn	- ms	- Mb
productscategory	0 ms	- Mb
=> __construct	0 ms	- Mb
=> hookheader	- ms	- Mb
39 modules	71 ms	- Mb

Čierne fashion okuliare s modrými sklami a cat-eye...

Štýlové modré štvorcové slnečné okuliare

Štýlové štvorcové okuliare s kovovým detailom

Slnečné okuliare – Štýlové dámske okuliare na leto | NajlepšiaMóda.sk

Expresné doručenie

Bezpečná platba

12 rokov s Vami

14 dní na vrátenie

Stopwatch SQL - 217 queries

Doubles

Tables stress

ObjectModel instances

Included Files

24	SELECT data FROM `ps_layered_friendly_url` WHERE `url_key` = XX LIMIT XX
11	SELECT ctg.`id_group` FROM ps_category_group ctg WHERE ctg.`id_category` = XX AND ctg.`id_group` = XX LIMIT XX
11	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
6	SELECT *, ( IF (`id_group` = XX, XX, XX) + IF (`id_country` = XX, XX, XX) + IF (`id_currency` = XX, XX, XX) + IF (`id_shop` = 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, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT XX
6	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
6	SELECT a.`id_attribute`, g.`id_attribute_group`, g.`url_name` as `group` FROM `ps_layered_indexable_attribute_group_lang_value` g LEFT JOIN `ps_attribute` a ON (a.`id_attribute_group` = g.`id_attribute_group`) WHERE a.`id_attribute` = XX AND g.`id_lang` = XX AND g.`url_name` IS NOT NULL AND g.`url_name` != ''
5	SELECT m.`id_module`, m.`name`, ( SELECT id_module FROM `ps_module_shop` ms WHERE m.`id_module` = ms.`id_module` AND ms.`id_shop` = XX LIMIT XX ) as mshop FROM `ps_module` m
5	SELECT 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 = XX) LEFT JOIN `ps_category_lang` cl ON c.`id_category` = cl.`id_category` AND cl.id_shop = XX LEFT JOIN `ps_category_group` cg ON c.`id_category` = cg.`id_category` RIGHT JOIN `ps_category` cXX ON cXX.`id_category` = XX AND c.`nleft` >= cXX.`nleft` AND c.`nright` <= cXX.`nright` WHERE XX AND `id_lang` = XX AND c.`active` = XX AND cg.`id_group` IN (XX) GROUP BY c.`id_category` ORDER BY c.`level_depth` ASC , category_shop.`position` ASC
4	SELECT `id_module` FROM `ps_module_shop` WHERE `id_module` = XX AND `id_shop` = XX LIMIT XX
3	SELECT DISTINCT la.`id_attribute`, la.`url_name` as `name` FROM `ps_attribute` a LEFT JOIN `ps_product_attribute_combination` pac ON (a.`id_attribute` = pac.`id_attribute`) LEFT JOIN `ps_product_attribute` pa ON (pac.`id_product_attribute` = pa.`id_product_attribute`) 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_layered_indexable_attribute_lang_value` la ON (la.`id_attribute` = a.`id_attribute` AND la.`id_lang` = XX) WHERE la.`url_name` IS NOT NULL AND la.`url_name` != '' AND pa.`id_product` = XX AND pac.`id_product_attribute` = XX
3	SELECT product_attribute_shop.`price` 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) WHERE pa.`id_product_attribute` = XX LIMIT XX
3	SELECT * FROM `ps_cms` a LEFT JOIN `ps_cms_lang` `b` ON a.`id_cms` = b.`id_cms` AND b.`id_lang` = XX LEFT JOIN `ps_cms_shop` `c` ON a.`id_cms` = c.`id_cms` AND c.`id_shop` = XX WHERE (a.`id_cms` = XX) AND (b.`id_shop` = XX) LIMIT XX
3	SELECT DISTINCT a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group` FROM `ps_attribute` a LEFT JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = XX) LEFT JOIN `ps_attribute_group_lang` agl ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = XX) LEFT JOIN `ps_product_attribute_combination` pac ON (a.`id_attribute` = pac.`id_attribute`) LEFT JOIN `ps_product_attribute` pa ON (pac.`id_product_attribute` = pa.`id_product_attribute`) 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) WHERE pa.`id_product` = XX AND pac.id_product_attribute = XX AND a.`id_attribute` NOT IN(XX, XX)
3	SELECT `priority`, `id_specific_price_priority` FROM `ps_specific_price_priority` WHERE `id_product` = XX ORDER BY `id_specific_price_priority` DESC LIMIT XX
3	SELECT `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = XX AND `id_group` = XX LIMIT XX
3	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
3	SELECT COUNT(DISTINCT lpa.id_product) AS nbr, lpa.id_attribute_group, a.color, al.name AS attribute_name, agl.public_name AS attribute_group_name, lpa.id_attribute, ag.is_color_group, liagl.url_name AS name_url_name, liagl.meta_title AS name_meta_title, lial.url_name AS value_url_name, lial.meta_title AS value_meta_title FROM ps_layered_product_attribute lpa INNER JOIN ps_attribute a ON a.id_attribute = lpa.id_attribute INNER JOIN ps_attribute_lang al ON al.id_attribute = a.id_attribute AND al.id_lang = XX INNER JOIN ps_cat_restriction p ON p.id_product = lpa.id_product INNER JOIN ps_attribute_group ag ON ag.id_attribute_group = lpa.id_attribute_group INNER JOIN ps_attribute_group_lang agl ON agl.id_attribute_group = lpa.id_attribute_group AND agl.id_lang = XX LEFT JOIN ps_product_attribute_combination pac ON pac.id_attribute = lpa.id_attribute LEFT JOIN ps_product_attribute pa ON pa.id_product_attribute = pac.id_product_attribute AND pa.id_product = lpa.id_product LEFT JOIN ps_stock_available sa ON ( sa.id_product = lpa.id_product AND sa.id_product_attribute = pa.id_product_attribute AND sa.id_shop = XX ) LEFT JOIN ps_layered_indexable_attribute_group_lang_value liagl ON (liagl.id_attribute_group = lpa.id_attribute_group AND liagl.id_lang = XX) LEFT JOIN ps_layered_indexable_attribute_lang_value lial ON (lial.id_attribute = lpa.id_attribute AND lial.id_lang = XX) WHERE lpa.id_attribute_group = XX AND lpa.id_shop = XX AND sa.quantity > XX GROUP BY lpa.id_attribute ORDER BY ag.position ASC, a.position ASC
3	SELECT `id_tax_rules_group` FROM `ps_product_shop` WHERE `id_product` = XX AND id_shop=XX LIMIT XX
3	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 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)
3	SELECT cl.`meta_title`, cl.`link_rewrite` FROM `ps_cms_lang` cl INNER JOIN `ps_cms` c ON (cl.`id_cms` = c.`id_cms`) WHERE cl.`id_cms` = XX AND (c.`active` = XX OR c.`id_cms` = XX) AND cl.`id_shop` = XX AND cl.`id_lang` = XX LIMIT XX
2	SELECT nleft, nright, level_depth FROM ps_category WHERE id_category = XX LIMIT XX
2	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
2	SELECT cl.`id_category` FROM `ps_category_lang` cl LEFT JOIN `ps_category` c ON cl.id_category = c.id_category WHERE cl.`id_shop` = 'XX' AND cl.`link_rewrite` = 'slnecne-okuliare' AND cl.`id_lang` = 'XX' LIMIT XX
2	SELECT cr.`id_cart_rule`, cr.`code`, cr.`product_restriction`, cr.`group_restriction`, cr.`shop_restriction` FROM `ps_cart_rule` cr WHERE cr.`active` = XX AND cr.`quantity` > XX AND cr.`code` != "" AND cr.`product_restriction` = XX AND cr.`date_from` <= NOW() AND cr.`date_to` >= NOW() AND cr.`id_customer` IN (XX, XX)
2	SELECT cl.`link_rewrite` FROM `ps_category_lang` cl WHERE `id_lang` = XX AND cl.id_shop = XX AND cl.`id_category` = XX LIMIT XX
2	SELECT cl.`id_category` FROM `ps_category_lang` cl LEFT JOIN `ps_category` c ON cl.id_category = c.id_category LEFT JOIN `ps_category_shop` cs ON cl.id_shop = cs.id_shop AND cs.id_category = c.id_category WHERE cl.`id_shop` = 'XX' AND cs.`id_shop` IS NOT NULL AND cl.`link_rewrite` = 'slnecne-okuliare' AND cl.`id_lang` = 'XX' LIMIT XX

Name	Instances	Source
Category	117	/modules/fsadvancedurl/fsadvancedurl.php [3601] /controllers/front/CategoryController.php [99] /override/classes/Link.php [60] /override/classes/Link.php [60] /modules/blocklayered/blocklayered.php [2217] /modules/blocklayered/blocklayered.php [679] /modules/bamegamenu/bamegamenu.php [1712] /modules/bamegamenu/bamegamenu.php [2139] /modules/bamegamenu/bamegamenu.php [2139] /modules/bamegamenu/bamegamenu.php [2139] /modules/bamegamenu/bamegamenu.php [2139] /modules/bamegamenu/bamegamenu.php [2139] /modules/bamegamenu/bamegamenu.php [2139] /modules/bamegamenu/bamegamenu.php [2139] /modules/bamegamenu/bamegamenu.php [2139] /modules/bamegamenu/bamegamenu.php [2139] /modules/bamegamenu/bamegamenu.php [2139] /modules/bamegamenu/bamegamenu.php [2139] /modules/bamegamenu/bamegamenu.php [2139] /modules/bamegamenu/bamegamenu.php [2139] /modules/bamegamenu/bamegamenu.php [2139] /modules/bamegamenu/bamegamenu.php [2139] /modules/bamegamenu/bamegamenu.php [2139] /modules/bamegamenu/bamegamenu.php [2139] /modules/bamegamenu/bamegamenu.php [2139] /modules/bamegamenu/bamegamenu.php [2139] /modules/bamegamenu/bamegamenu.php [2139] /modules/bamegamenu/bamegamenu.php [2139] /modules/bamegamenu/bamegamenu.php [2139] /modules/bamegamenu/bamegamenu.php [2139] /modules/bamegamenu/bamegamenu.php [2139] /modules/bamegamenu/bamegamenu.php [2139] /modules/bamegamenu/bamegamenu.php [2139] /modules/bamegamenu/bamegamenu.php [2139] /modules/bamegamenu/bamegamenu.php [2139] /modules/bamegamenu/bamegamenu.php [2139] /modules/bamegamenu/bamegamenu.php [2139] /modules/bamegamenu/bamegamenu.php [2139] /modules/bamegamenu/bamegamenu.php [2139] /modules/bamegamenu/bamegamenu.php [2139] /modules/bamegamenu/bamegamenu.php [2139] /modules/bamegamenu/bamegamenu.php [2139] /modules/bamegamenu/bamegamenu.php [2139] /modules/bamegamenu/bamegamenu.php [2139] /modules/bamegamenu/bamegamenu.php [2139] /modules/bamegamenu/bamegamenu.php [2139] /modules/bamegamenu/bamegamenu.php [2139] /modules/bamegamenu/bamegamenu.php [2139] /modules/bamegamenu/bamegamenu.php [2139] /modules/bamegamenu/bamegamenu.php [2139] /modules/bamegamenu/bamegamenu.php [2139] /modules/bamegamenu/bamegamenu.php [2139] /modules/bamegamenu/bamegamenu.php [2139] /modules/bamegamenu/bamegamenu.php [2139] /modules/bamegamenu/bamegamenu.php [2139] /modules/bamegamenu/bamegamenu.php [2139] /modules/bamegamenu/bamegamenu.php [2139] /modules/bamegamenu/bamegamenu.php [2139] /modules/bamegamenu/bamegamenu.php [2139] /modules/bamegamenu/bamegamenu.php [2139] /modules/bamegamenu/bamegamenu.php [2139] /modules/bamegamenu/bamegamenu.php [2139] /modules/bamegamenu/bamegamenu.php [2139] /modules/bamegamenu/bamegamenu.php [2139] /modules/bamegamenu/bamegamenu.php [2139] /modules/bamegamenu/bamegamenu.php [2139] /modules/bamegamenu/bamegamenu.php [2139] /modules/bamegamenu/bamegamenu.php [2139] /modules/bamegamenu/bamegamenu.php [2139] /modules/bamegamenu/bamegamenu.php [2139] /modules/bamegamenu/bamegamenu.php [1712] /modules/bamegamenu/bamegamenu.php [2139] /modules/bamegamenu/bamegamenu.php [2139] /modules/bamegamenu/bamegamenu.php [2139] /modules/bamegamenu/bamegamenu.php [2139] /modules/bamegamenu/bamegamenu.php [2139] /modules/bamegamenu/bamegamenu.php [2139] /modules/bamegamenu/bamegamenu.php [2139] /modules/bamegamenu/bamegamenu.php [2139] /modules/bamegamenu/bamegamenu.php [1712] /modules/bamegamenu/bamegamenu.php [1712] /modules/bamegamenu/bamegamenu.php [1712] /modules/bamegamenu/bamegamenu.php [2139] /modules/bamegamenu/bamegamenu.php [2139] /modules/bamegamenu/bamegamenu.php [2139] /modules/bamegamenu/bamegamenu.php [2139] /modules/bamegamenu/bamegamenu.php [2139] /modules/bamegamenu/bamegamenu.php [2139] /modules/bamegamenu/bamegamenu.php [2139] /modules/bamegamenu/bamegamenu.php [2139] /modules/bamegamenu/bamegamenu.php [2139] /modules/bamegamenu/bamegamenu.php [2139] /modules/bamegamenu/bamegamenu.php [2139] /modules/bamegamenu/bamegamenu.php [2139] /modules/bamegamenu/bamegamenu.php [1712] /modules/bamegamenu/bamegamenu.php [1712] /modules/bamegamenu/bamegamenu.php [2139] /modules/bamegamenu/bamegamenu.php [2139] /modules/bamegamenu/bamegamenu.php [2139] /modules/bamegamenu/bamegamenu.php [2139] /modules/bamegamenu/bamegamenu.php [2139] /modules/bamegamenu/bamegamenu.php [2139] /modules/bamegamenu/bamegamenu.php [2139] /modules/bamegamenu/bamegamenu.php [2139] /modules/bamegamenu/bamegamenu.php [1712] /modules/bamegamenu/bamegamenu.php [2139] /modules/bamegamenu/bamegamenu.php [2139] /modules/bamegamenu/bamegamenu.php [2139] /modules/bamegamenu/bamegamenu.php [2139] /modules/bamegamenu/bamegamenu.php [2139] /modules/bamegamenu/bamegamenu.php [2139] /modules/bamegamenu/bamegamenu.php [2139] /modules/bamegamenu/bamegamenu.php [2139] /modules/bamegamenu/bamegamenu.php [1712] /modules/bamegamenu/bamegamenu.php [1712] /modules/blocklayered/blocklayered.php [1868] /override/classes/Link.php [60]
Product	7	/modules/fsadvancedurl/fsadvancedurl.php [3467] /modules/blocklayered/blocklayered.php [3390] /modules/blocklayered/blocklayered.php [3390] /modules/blocklayered/blocklayered.php [3390] /classes/Link.php [104] /classes/Link.php [104] /classes/Link.php [104]
CMS	3	/override/classes/Link.php [164] /override/classes/Link.php [164] /override/classes/Link.php [164]
Language	2	/config/config.inc.php [195] /classes/Tools.php [517]
Address	2	/classes/Product.php [3045] /classes/Product.php [4665]
Shop	1	/config/config.inc.php [114]
Theme	1	/config/config.inc.php [115]
Country	1	/config/config.inc.php [142]
ShopGroup	1	/classes/shop/Shop.php [518]
Customer	1	/config/config.inc.php [221]
Currency	1	/classes/Tools.php [634]
Cart	1	/classes/controller/FrontController.php [357]
Group	1	/classes/Cart.php [184]
Tax	1	/classes/tax/TaxRulesTaxManager.php [115]

#	Filename
1	/index.php
2	/config/config.inc.php
3	/config/defines.inc.php
4	/config/settings.inc.php
5	/config/autoload.php
6	/config/alias.php
7	/classes/PrestaShopAutoload.php
8	/cache/class_index.php
9	/config/bootstrap.php
10	/Core/Business/Core_Business_ContainerBuilder.php
11	/Core/Foundation/IoC/Core_Foundation_IoC_Container.php
12	/Adapter/Adapter_ServiceLocator.php
13	/classes/controller/Controller.php
14	/classes/ObjectModel.php
15	/Core/Foundation/Database/Core_Foundation_Database_EntityInterface.php
16	/classes/db/Db.php
17	/classes/Tools.php
18	/classes/Context.php
19	/classes/shop/Shop.php
20	/override/classes/shop/Shop.php
21	/classes/db/DbPDO.php
22	/classes/Configuration.php
23	/classes/Validate.php
24	/classes/cache/Cache.php
25	/Adapter/Adapter_EntityMapper.php
26	/classes/db/DbQuery.php
27	/classes/Theme.php
28	/config/defines_uri.inc.php
29	/tools/htmlpurifier/HTMLPurifier.standalone.php
30	/classes/Language.php
31	/classes/Country.php
32	/classes/PrestaShopCollection.php
33	/classes/shop/ShopGroup.php
34	/classes/Cookie.php
35	/classes/Rijndael.php
36	/config/smarty.config.inc.php
37	/tools/smarty/Smarty.class.php
38	/tools/smarty/sysplugins/smarty_internal_data.php
39	/tools/smarty/sysplugins/smarty_internal_templatebase.php
40	/tools/smarty/sysplugins/smarty_internal_template.php
41	/tools/smarty/sysplugins/smarty_resource.php
42	/tools/smarty/sysplugins/smarty_internal_resource_file.php
43	/tools/smarty/sysplugins/smarty_cacheresource.php
44	/tools/smarty/sysplugins/smarty_internal_cacheresource_file.php
45	/classes/SmartyCustom.php
46	/config/smartyfront.config.inc.php
47	/classes/Customer.php
48	/classes/Group.php
49	/classes/Link.php
50	/override/classes/Link.php
51	/classes/shop/ShopUrl.php
52	/classes/module/Module.php
53	/modules/nmban/nmban.php
54	/classes/Translate.php
55	/classes/Dispatcher.php
56	/override/classes/Dispatcher.php
57	/classes/Hook.php
58	/override/classes/Hook.php
59	/tools/mobile_Detect/Mobile_Detect.php
60	/config/db_slave_server.inc.php
61	/modules/datakick/datakick.php
62	/themes/najlepsiamoda/modules/datakick/translations/sk.php
63	/modules/datakick/translations/sk.php
64	/modules/fsadvancedurl/fsadvancedurl.php
65	/modules/fsadvancedurl/classes/FsAdvancedUrlDataTransfer.php
66	/modules/fsadvancedurl/classes/FsAdvancedUrlHelperFormMultiShop.php
67	/classes/helper/HelperForm.php
68	/classes/helper/Helper.php
69	/modules/fsadvancedurl/classes/FsAdvancedUrlHelperList.php
70	/classes/helper/HelperList.php
71	/modules/fsadvancedurl/classes/FsAdvancedUrlMessenger.php
72	/modules/fsadvancedurl/classes/FsAdvancedUrlModule.php
73	/modules/fsadvancedurl/classes/FsAdvancedUrlProduct.php
74	/classes/Product.php
75	/modules/fsadvancedurl/classes/FsAdvancedUrlTools.php
76	/themes/najlepsiamoda/modules/fsadvancedurl/translations/sk.php
77	/modules/fsadvancedurl/translations/sk.php
78	/modules/revws/revws.php
79	/modules/revws/app-translation.php
80	/modules/revws/classes/csrf.php
81	/modules/revws/classes/csv-reader.php
82	/modules/revws/classes/color.php
83	/modules/revws/classes/utils.php
84	/modules/revws/classes/gdpr/interface.php
85	/modules/revws/classes/gdpr/psgdpr.php
86	/modules/revws/classes/gdpr/basic.php
87	/modules/revws/classes/gdpr/gdpr.php
88	/modules/revws/classes/settings.php
89	/modules/revws/classes/permissions.php
90	/modules/revws/classes/visitor-permissions.php
91	/modules/revws/classes/employee-permissions.php
92	/modules/revws/classes/no-permissions.php
93	/modules/revws/classes/shapes.php
94	/modules/revws/classes/visitor.php
95	/modules/revws/classes/review-query.php
96	/modules/revws/classes/notifications.php
97	/modules/revws/classes/actor.php
98	/modules/revws/classes/review-list.php
99	/modules/revws/classes/front-app.php
100	/modules/revws/classes/backup.php
101	/modules/revws/classes/integration/datakick.php
102	/modules/revws/classes/integration/krona.php
103	/modules/revws/classes/migration-utils.php
104	/modules/revws/model/criterion.php
105	/modules/revws/model/review.php
106	/themes/najlepsiamoda/modules/revws/translations/sk.php
107	/modules/revws/translations/sk.php
108	/classes/webservice/WebserviceRequest.php
109	/classes/Category.php
110	/override/classes/Category.php
111	/controllers/front/CategoryController.php
112	/classes/controller/FrontController.php
113	/override/classes/controller/FrontController.php
114	/override/controllers/front/CategoryController.php
115	/themes/najlepsiamoda/lang/sk.php
116	/classes/Currency.php
117	/classes/Cart.php
118	/override/classes/Cart.php
119	/classes/CartRule.php
120	/classes/Meta.php
121	/classes/Media.php
122	/classes/Scene.php
123	/modules/blockcart/blockcart.php
124	/themes/najlepsiamoda/modules/blockcart/translations/sk.php
125	/modules/blockcart/translations/sk.php
126	/modules/blockcategories/blockcategories.php
127	/themes/najlepsiamoda/modules/blockcategories/translations/sk.php
128	/modules/blockcategories/translations/sk.php
129	/modules/blockcms/blockcms.php
130	/modules/blockcms/BlockCMSModel.php
131	/themes/najlepsiamoda/modules/blockcms/translations/sk.php
132	/modules/blockcms/translations/sk.php
133	/modules/blockcontact/blockcontact.php
134	/themes/najlepsiamoda/modules/blockcontact/translations/sk.php
135	/modules/blockcontact/translations/sk.php
136	/modules/blockcontactinfos/blockcontactinfos.php
137	/themes/najlepsiamoda/modules/blockcontactinfos/translations/sk.php
138	/modules/blockcontactinfos/translations/sk.php
139	/modules/blockmyaccount/blockmyaccount.php
140	/themes/najlepsiamoda/modules/blockmyaccount/translations/sk.php
141	/modules/blockmyaccount/translations/sk.php
142	/modules/blockmyaccountfooter/blockmyaccountfooter.php
143	/themes/najlepsiamoda/modules/blockmyaccountfooter/translations/sk.php
144	/modules/blockmyaccountfooter/translations/sk.php
145	/modules/blocknewproducts/blocknewproducts.php
146	/classes/NmHomepageCache.php
147	/themes/najlepsiamoda/modules/blocknewproducts/translations/sk.php
148	/modules/blocknewproducts/translations/sk.php
149	/modules/blocknewsletter/blocknewsletter.php
150	/themes/najlepsiamoda/modules/blocknewsletter/translations/sk.php
151	/modules/blocknewsletter/translations/sk.php
152	/modules/blocksearch/blocksearch.php
153	/themes/najlepsiamoda/modules/blocksearch/translations/sk.php
154	/modules/blocksearch/translations/sk.php
155	/modules/blockuserinfo/blockuserinfo.php
156	/themes/najlepsiamoda/modules/blockuserinfo/translations/sk.php
157	/modules/blockuserinfo/translations/sk.php
158	/modules/homefeatured/homefeatured.php
159	/themes/najlepsiamoda/modules/homefeatured/translations/sk.php
160	/modules/homefeatured/translations/sk.php
161	/modules/themeconfigurator/themeconfigurator.php
162	/themes/najlepsiamoda/modules/themeconfigurator/translations/sk.php
163	/modules/themeconfigurator/translations/sk.php
164	/cache/smarty/compile/a0/9d/70/a09d7020dc352831a044132f58ad821edae4e790.file.hook.tpl.php
165	/tools/smarty/sysplugins/smarty_internal_filter_handler.php
166	/modules/productaccessories/productaccessories.php
167	/modules/productaccessories/PrestoChangeoClasses/init.php
168	/modules/productaccessories/PrestoChangeoClasses/PrestoChangeoModule.php
169	/themes/najlepsiamoda/modules/productaccessories/translations/sk.php
170	/modules/productaccessories/translations/sk.php
171	/modules/productscategory/productscategory.php
172	/themes/najlepsiamoda/modules/productscategory/translations/sk.php
173	/modules/productscategory/translations/sk.php
174	/modules/bamegamenu/bamegamenu.php
175	/modules/bamegamenu/include/buyaddons.php
176	/themes/najlepsiamoda/modules/bamegamenu/translations/sk.php
177	/modules/bamegamenu/translations/sk.php
178	/classes/Blowfish.php
179	/modules/gmseofields/gmseofields.php
180	/themes/najlepsiamoda/modules/gmseofields/translations/sk.php
181	/modules/gmseofields/translations/sk.php
182	/modules/blocklayered/blocklayered.php
183	/classes/NmShoppingFilters.php
184	/themes/najlepsiamoda/modules/blocklayered/translations/sk.php
185	/modules/blocklayered/translations/sk.php
186	/modules/stlazyloading/stlazyloading.php
187	/themes/najlepsiamoda/modules/stlazyloading/translations/sk.php
188	/modules/stlazyloading/translations/sk.php
189	/modules/socialsharing/socialsharing.php
190	/themes/najlepsiamoda/modules/socialsharing/translations/sk.php
191	/modules/socialsharing/translations/sk.php
192	/modules/paybysquare/paybysquare.php
193	/modules/paybysquare/autoload.php
194	/modules/paybysquare/classes/PayBySquareAPI.php
195	/modules/paybysquare/classes/AccountDetails.php
196	/modules/paybysquare/classes/PayBySquareMails.php
197	/modules/paybysquare/classes/PayBySquareLog.php
198	/modules/paybysquare/composer/vendor/autoload.php
199	/modules/paybysquare/composer/vendor/composer/autoload_real.php
200	/modules/paybysquare/composer/vendor/composer/ClassLoader.php
201	/modules/paybysquare/composer/vendor/composer/autoload_static.php
202	/modules/paybysquare/composer/vendor/guzzlehttp/promises/src/functions_include.php
203	/modules/paybysquare/composer/vendor/guzzlehttp/promises/src/functions.php
204	/modules/paybysquare/composer/vendor/guzzlehttp/psr7/src/functions_include.php
205	/modules/paybysquare/composer/vendor/guzzlehttp/psr7/src/functions.php
206	/modules/paybysquare/composer/vendor/guzzlehttp/guzzle/src/functions_include.php
207	/modules/paybysquare/composer/vendor/guzzlehttp/guzzle/src/functions.php
208	/classes/PaymentModule.php
209	/themes/najlepsiamoda/modules/paybysquare/translations/sk.php
210	/modules/paybysquare/translations/sk.php
211	/modules/productlistpics/productlistpics.php
212	/themes/najlepsiamoda/modules/productlistpics/translations/sk.php
213	/modules/productlistpics/translations/sk.php
214	/modules/productlistpics/key.php
215	/cache/smarty/compile/27/9d/eb/279deb3e9aa2a942ba20b91cd7e91f92ceae411c.file.header.tpl.php
216	/tools/minify_html/minify_html.class.php
217	/tools/js_minify/jsmin.php
218	/modules/blockviewed_mod/blockviewed_mod.php
219	/themes/najlepsiamoda/modules/blockviewed_mod/translations/sk.php
220	/modules/blockviewed_mod/translations/sk.php
221	/modules/csoft_instagramfeeds/csoft_instagramfeeds.php
222	/themes/najlepsiamoda/modules/csoft_instagramfeeds/translations/sk.php
223	/modules/blockspecials/blockspecials.php
224	/themes/najlepsiamoda/modules/blockspecials/translations/sk.php
225	/modules/blockspecials/translations/sk.php
226	/modules/returnform/returnform.php
227	/modules/homeslider/homeslider.php
228	/modules/homeslider/HomeSlide.php
229	/themes/najlepsiamoda/modules/homeslider/translations/sk.php
230	/modules/homeslider/translations/sk.php
231	/modules/dynamiccategories/dynamiccategories.php
232	/modules/topbanner/topbanner.php
233	/modules/productvideos/productvideos.php
234	/cache/smarty/compile/9d/ea/7b/9dea7b3654decae388479438856ffc51dccb53d2.file.blockuserinfo.tpl.php
235	/cache/smarty/compile/9b/87/ef/9b87effff962686b8c50e3c3c33434e37c7f5434.file.bamegamenu.tpl.php
236	/cache/smarty/compile/f9/d1/5c/f9d15ce73b0462c07690484875d53240bbab0f28.file.blockcms.tpl.php
237	/classes/ImageType.php
238	/classes/Combination.php
239	/classes/stock/StockAvailable.php
240	/classes/Feature.php
241	/classes/tax/Tax.php
242	/classes/Address.php
243	/classes/SpecificPrice.php
244	/classes/tax/TaxManagerFactory.php
245	/modules/vatnumber/vatnumber.php
246	/classes/tax/TaxManagerModule.php
247	/themes/najlepsiamoda/modules/vatnumber/translations/sk.php
248	/modules/vatnumber/translations/sk.php
249	/modules/vatnumber/VATNumberTaxManager.php
250	/classes/tax/TaxManagerInterface.php
251	/classes/tax/TaxRulesTaxManager.php
252	/Adapter/Adapter_Configuration.php
253	/Core/Business/Core_Business_ConfigurationInterface.php
254	/classes/tax/TaxCalculator.php
255	/classes/GroupReduction.php
256	/cache/smarty/compile/a5/01/04/a50104756374e043fa559dafe3e25fc220d13b63.file.product-list-colors.tpl.php
257	/classes/Image.php
258	/classes/Supplier.php
259	/cache/smarty/compile/99/7b/f3/997bf3696526feb2c24889314512bb9641067654.file.blocknewsletter.tpl.php
260	/cache/smarty/compile/a5/a2/0e/a5a20e84615ccc417907557e34bce58b5a9b60c3.file.blockcontactinfos.tpl.php
261	/tools/smarty/plugins/function.mailto.php
262	/classes/CMS.php
263	/cache/smarty/compile/b8/80/fa/b880fa1712370441c1eb24b5df33b9a771833f9a.file.blockmyaccountfooter.tpl.php
264	/modules/contentboxinstagram/contentboxinstagram.php
265	/themes/najlepsiamoda/modules/contentboxinstagram/translations/sk.php
266	/cache/smarty/compile/2a/2b/b5/2a2bb50941e338be5916a517f51d9ed1a0c6e0e7.file.template.tpl.php
267	/modules/contentbox2/contentbox2.php
268	/themes/najlepsiamoda/modules/contentbox2/translations/sk.php
269	/modules/contentbox2/translations/sk.php
270	/cache/smarty/compile/e6/ac/60/e6ac602b06b2001f0720facbdf5b4b7d69b286db.file.template.tpl.php
271	/tools/smarty/plugins/modifier.escape.php
272	/modules/nmtraffic/nmtraffic.php
273	/cache/smarty/compile/b0/9f/ff/b09fff6c729e1e11696440b073bf5e347e511195.file.category.tpl.php
274	/tools/smarty/plugins/modifier.regex_replace.php
275	/tools/smarty/plugins/modifier.replace.php
276	/cache/smarty/compile/c9/ae/18/c9ae18fc43065f6d9113bae307f386f6374bbf6f.file.errors.tpl.php
277	/cache/smarty/compile/00/93/3e/00933e9f91ae6720d74783296acebd38eba4e7ce.file.category-count.tpl.php
278	/cache/smarty/compile/94/df/08/94df08df939154eaa7c4b781993e09d189c62c83.file.blocklayered.tpl.php
279	/cache/smarty/compile/bc/87/c1/bc87c114236ebb244abdb7c6b3a0351835ab7b85.file.product-sort.tpl.php
280	/cache/smarty/compile/c4/e1/d0/c4e1d0573e0fd69b227c04fe1699190f57fa7c0f.file.nbr-product-page.tpl.php
281	/cache/smarty/compile/04/63/72/04637216cc39e9ef9da79a6ae35179916c3d9ae5.file.product-compare.tpl.php
282	/cache/smarty/compile/45/ae/5b/45ae5b2887d8360603bd8c1be05461aa0dfb214e.file.pagination.tpl.php
283	/cache/smarty/compile/ee/c2/4f/eec24fa8b0f13abd8a1d3c4d412b4379ec787700.file.product-list.tpl.php
284	/tools/smarty/plugins/function.math.php
285	/modules/attributes/attributes.php
286	/themes/najlepsiamoda/modules/attributes/translations/sk.php
287	/modules/attributes/translations/sk.php
288	/cache/smarty/compile/00/6d/58/006d58f4ba52ea6572b71621075e46fa4a60fae4.file.combinations.tpl.php
289	/cache/smarty/compile/b8/44/fd/b844fd39d1c239815262f2a385cb211ae1b8e510.file.product_list.tpl.php
290	/cache/smarty/compile/2a/c9/1f/2ac91f7c75640c0f1b331c28b5b5d30dff4d64aa.file.layout.tpl.php
291	/cache/smarty/compile/aa/24/e2/aa24e2215d4463e3dbc1c29ea480fd6aac4eb0ae.file.header.tpl.php
292	/tools/smarty/plugins/function.implode.php
293	/cache/smarty/compile/0f/13/cd/0f13cdbb4dc44f59e75e5ecae26ad097433fed8c.file.displayBanner.tpl.php
294	/Adapter/Adapter_AddressFactory.php
295	/Adapter/Adapter_ProductPriceCalculator.php
296	/classes/Customization.php
297	/cache/smarty/compile/8e/7a/37/8e7a37464477c437fb3f56c1d82fe9bc27ed317f.file.blockcart.tpl.php
298	/tools/smarty/plugins/function.counter.php
299	/cache/smarty/compile/69/2f/d6/692fd6f64452229cc06292e137b0d06f00cdbdb3.file.free-shipping-progress.tpl.php
300	/cache/smarty/compile/32/c9/8d/32c98d7f6b4580b3deb84d7a6a67018291423c1f.file.nav.tpl.php
301	/cache/smarty/compile/06/e8/7f/06e87f691c9d3c2f674bd435f63017ecf4adddff.file.blocksearch-top.tpl.php
302	/cache/smarty/compile/74/a8/f9/74a8f969d08af91efd6445f28097e47d6d4df5fb.file.nav.tpl.php
303	/cache/smarty/compile/ff/13/f4/ff13f4371e3272d237c14520245f21617e20e0f4.file.breadcrumb.tpl.php
304	/cache/smarty/compile/33/54/e0/3354e0c80c17f82f32a6894e611ffedd7d919592.file.footer.tpl.php
305	/tools/smarty/plugins/modifier.date_format.php
306	/tools/smarty/plugins/shared.make_timestamp.php
307	/cache/smarty/compile/13/81/03/138103dccfcc7c1dc5f885a6a5426e6ecab43580.file.global.tpl.php
308	/cache/smarty/compile/cb/a8/6f/cba86f4baa668957f398683a4c9c2787f8a6a591.file.javascript.tpl.php
309	/tools/smarty/plugins/shared.mb_str_replace.php

Query	Time (ms)	Rows	Filesort	Group By	Location
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.1	1425			/classes/Configuration.php:148 /classes/Configuration.php:185 /classes/Configuration.php:247 /classes/shop/Shop.php:369 /config/config.inc.php:114 /index.php:27
SELECT SQL_NO_CACHE h.`name` as hook, m.`id_module`, h.`id_hook`, m.`name` as module, h.`live_edit` 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_module_shop` ms ON ms.`id_module` = m.`id_module` 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 != "displayPayment") 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`	1.3	144	Yes	Yes	/override/classes/Hook.php:70 /classes/Hook.php:440 /classes/Dispatcher.php:407 /override/classes/Dispatcher.php:70 /classes/Dispatcher.php:228 /classes/Dispatcher.php:193 /index.php:40
SELECT SQL_NO_CACHE * FROM `ps_hook_module_exceptions` WHERE `id_shop` IN (1)	1.3	2445			/classes/module/Module.php:2141 /classes/Hook.php:499 /classes/Dispatcher.php:363 /index.php:40
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` = 3 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright` WHERE 1 AND `id_lang` = 2 AND c.`active` = 1 AND cg.`id_group` IN (1) GROUP BY c.`id_category` ORDER BY c.`level_depth` ASC , category_shop.`position` ASC	1.3	67	Yes	Yes	/modules/bamegamenu/include/buyaddons.php:106 /modules/bamegamenu/bamegamenu.php:1997 /modules/bamegamenu/bamegamenu.php:2350 /modules/bamegamenu/bamegamenu.php:2396 /classes/Hook.php:599 /classes/Hook.php:546 /classes/controller/FrontController.php:589 /override/classes/controller/FrontController.php:118 /controllers/front/CategoryController.php:123 /override/controllers/front/CategoryController.php:24 /tools/profiling/Controller.php:220 /classes/Dispatcher.php:367 /index.php:40
SELECT SQL_NO_CACHE p., product_shop., product_shop.id_category_default, pl.*, image_shop.`id_image` id_image, il.legend, m.name manufacturer_name, product_attribute_shop.id_product_attribute id_product_attribute, DATEDIFF(product_shop.`date_add`, DATE_SUB("2026-10-25 00:00:00", INTERVAL 20 DAY)) > 0 AS new, stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, product_attribute_shop.minimal_quantity AS product_attribute_minimal_quantity FROM ps_cat_filter_restriction cp LEFT JOIN `ps_product` p ON p.`id_product` = cp.`id_product` INNER JOIN ps_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) LEFT JOIN `ps_product_attribute_shop` product_attribute_shop ON (p.`id_product` = product_attribute_shop.`id_product` AND product_attribute_shop.`default_on` = 1 AND product_attribute_shop.id_shop=1) LEFT JOIN ps_product_lang pl ON (pl.id_product = p.id_product AND pl.id_shop = 1 AND pl.id_lang = 2) LEFT JOIN `ps_image_shop` image_shop ON (image_shop.`id_product` = p.`id_product` AND image_shop.cover=1 AND image_shop.id_shop=1) LEFT JOIN `ps_image_lang` il ON (image_shop.`id_image` = il.`id_image` AND il.`id_lang` = 2) LEFT JOIN ps_manufacturer m ON (m.id_manufacturer = p.id_manufacturer) LEFT JOIN ps_stock_available stock ON (stock.id_product = p.id_product AND stock.id_product_attribute = 0 AND stock.id_shop = 1 AND stock.id_shop_group = 0 ) WHERE product_shop.`active` = 1 AND product_shop.`visibility` IN ("both", "catalog") GROUP BY p.`id_product` ORDER BY p.date_add desc , cp.id_product LIMIT 0,29	1	12	Yes	Yes	/modules/blocklayered/blocklayered.php:2139 /modules/blocklayered/blocklayered.php:3359 /modules/blocklayered/blocklayered.php:640 /classes/Hook.php:599 /classes/Hook.php:548 /controllers/front/CategoryController.php:215 /override/controllers/front/CategoryController.php:35 /controllers/front/CategoryController.php:144 /override/controllers/front/CategoryController.php:24 /tools/profiling/Controller.php:220 /classes/Dispatcher.php:367 /index.php:40
SELECT SQL_NO_CACHE h.id_hook, h.name as h_name, title, description, h.position, live_edit, hm.position as hm_position, m.id_module, m.name, 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	1	439			/classes/Hook.php:235 /classes/Hook.php:275 /classes/tax/TaxManagerFactory.php:67 /classes/tax/TaxManagerFactory.php:46 /classes/Product.php:3157 /classes/Product.php:3005 /classes/Product.php:4441 /classes/Product.php:4685 /modules/blocklayered/blocklayered.php:3390 /modules/blocklayered/blocklayered.php:640 /classes/Hook.php:599 /classes/Hook.php:548 /controllers/front/CategoryController.php:215 /override/controllers/front/CategoryController.php:35 /controllers/front/CategoryController.php:144 /override/controllers/front/CategoryController.php:24 /tools/profiling/Controller.php:220 /classes/Dispatcher.php:367 /index.php:40
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` = 142 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright` WHERE 1 AND `id_lang` = 2 AND c.`active` = 1 AND cg.`id_group` IN (1) GROUP BY c.`id_category` ORDER BY c.`level_depth` ASC , category_shop.`position` ASC	1	50	Yes	Yes	/modules/bamegamenu/include/buyaddons.php:106 /modules/bamegamenu/bamegamenu.php:1997 /modules/bamegamenu/bamegamenu.php:2350 /modules/bamegamenu/bamegamenu.php:2396 /classes/Hook.php:599 /classes/Hook.php:546 /classes/controller/FrontController.php:589 /override/classes/controller/FrontController.php:118 /controllers/front/CategoryController.php:123 /override/controllers/front/CategoryController.php:24 /tools/profiling/Controller.php:220 /classes/Dispatcher.php:367 /index.php:40
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` = 26 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright` WHERE 1 AND `id_lang` = 2 AND c.`active` = 1 AND cg.`id_group` IN (1) GROUP BY c.`id_category` ORDER BY c.`level_depth` ASC , category_shop.`position` ASC	0.8	15	Yes	Yes	/modules/bamegamenu/include/buyaddons.php:106 /modules/bamegamenu/bamegamenu.php:1997 /modules/bamegamenu/bamegamenu.php:2350 /modules/bamegamenu/bamegamenu.php:2396 /classes/Hook.php:599 /classes/Hook.php:546 /classes/controller/FrontController.php:589 /override/classes/controller/FrontController.php:118 /controllers/front/CategoryController.php:123 /override/controllers/front/CategoryController.php:24 /tools/profiling/Controller.php:220 /classes/Dispatcher.php:367 /index.php:40
SELECT SQL_NO_CACHE STRAIGHT_JOIN pa.id_product, pa.id_product_attribute, pac.id_attribute, al.name AS attribute_name, pa.reference, sa.quantity FROM ps_product_attribute pa INNER JOIN ps_stock_available sa ON ( sa.id_product = pa.id_product AND sa.id_product_attribute = pa.id_product_attribute AND sa.quantity > 0 AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) INNER JOIN ps_product_attribute_combination pac ON (pac.id_product_attribute = pa.id_product_attribute) INNER JOIN ps_attribute_lang al ON (al.id_attribute = pac.id_attribute AND al.id_lang = 2) WHERE pa.id_product IN (11452,11460,12082) AND pac.id_attribute IN (1,2,3,4,25,26,39,40,41,98,114,241,276,495,496,497,498,518,519,520,521,522,523,524,525,526,527,528,529,530,531,532,533,534,535,536,539,540,18,19,20,21,22,23,102,442,475,476,477,502,513,514,515,541,542) ORDER BY pa.id_product ASC, pa.id_product_attribute ASC	0.8	3			/modules/attributes/attributes.php:157 /classes/Hook.php:599 /classes/Hook.php:546 /cache/smarty/compile/ee/c2/4f/eec24fa8b0f13abd8a1d3c4d412b4379ec787700.file.product-list.tpl.php:198 /tools/smarty/sysplugins/smarty_internal_templatebase.php:188 /classes/SmartyCustom.php:317 /tools/smarty/sysplugins/smarty_internal_template.php:303 /cache/smarty/compile/b0/9f/ff/b09fff6c729e1e11696440b073bf5e347e511195.file.category.tpl.php:415 /tools/smarty/sysplugins/smarty_internal_templatebase.php:188 /classes/SmartyCustom.php:110 /classes/controller/FrontController.php:722 /override/classes/controller/FrontController.php:110 /tools/profiling/Controller.php:733 /tools/profiling/Controller.php:241 /classes/Dispatcher.php:367 /index.php:40
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` = 30 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright` WHERE 1 AND `id_lang` = 2 AND c.`active` = 1 AND cg.`id_group` IN (1) GROUP BY c.`id_category` ORDER BY c.`level_depth` ASC , category_shop.`position` ASC	0.8	42	Yes	Yes	/modules/bamegamenu/include/buyaddons.php:106 /modules/bamegamenu/bamegamenu.php:1997 /modules/bamegamenu/bamegamenu.php:2350 /modules/bamegamenu/bamegamenu.php:2396 /classes/Hook.php:599 /classes/Hook.php:546 /classes/controller/FrontController.php:589 /override/classes/controller/FrontController.php:118 /controllers/front/CategoryController.php:123 /override/controllers/front/CategoryController.php:24 /tools/profiling/Controller.php:220 /classes/Dispatcher.php:367 /index.php:40
SELECT SQL_NO_CACHE COUNT(DISTINCT lpa.id_product) AS nbr, lpa.id_attribute_group, a.color, al.name AS attribute_name, agl.public_name AS attribute_group_name, lpa.id_attribute, ag.is_color_group, liagl.url_name AS name_url_name, liagl.meta_title AS name_meta_title, lial.url_name AS value_url_name, lial.meta_title AS value_meta_title FROM ps_layered_product_attribute lpa INNER JOIN ps_attribute a ON a.id_attribute = lpa.id_attribute INNER JOIN ps_attribute_lang al ON al.id_attribute = a.id_attribute AND al.id_lang = 2 INNER JOIN ps_cat_restriction p ON p.id_product = lpa.id_product INNER JOIN ps_attribute_group ag ON ag.id_attribute_group = lpa.id_attribute_group INNER JOIN ps_attribute_group_lang agl ON agl.id_attribute_group = lpa.id_attribute_group AND agl.id_lang = 2 LEFT JOIN ps_product_attribute_combination pac ON pac.id_attribute = lpa.id_attribute LEFT JOIN ps_product_attribute pa ON pa.id_product_attribute = pac.id_product_attribute AND pa.id_product = lpa.id_product LEFT JOIN ps_stock_available sa ON ( sa.id_product = lpa.id_product AND sa.id_product_attribute = pa.id_product_attribute AND sa.id_shop = 1 ) LEFT JOIN ps_layered_indexable_attribute_group_lang_value liagl ON (liagl.id_attribute_group = lpa.id_attribute_group AND liagl.id_lang = 2) LEFT JOIN ps_layered_indexable_attribute_lang_value lial ON (lial.id_attribute = lpa.id_attribute AND lial.id_lang = 2) WHERE lpa.id_attribute_group = 1 AND lpa.id_shop = 1 AND sa.quantity > 0 GROUP BY lpa.id_attribute ORDER BY ag.position ASC, a.position ASC	0.7	6	Yes		/modules/blocklayered/blocklayered.php:2491 /modules/blocklayered/blocklayered.php:673 /classes/Hook.php:599 /classes/Hook.php:548 /classes/controller/FrontController.php:588 /override/classes/controller/FrontController.php:118 /controllers/front/CategoryController.php:123 /override/controllers/front/CategoryController.php:24 /tools/profiling/Controller.php:220 /classes/Dispatcher.php:367 /index.php:40
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` = 20 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright` WHERE 1 AND `id_lang` = 2 AND c.`active` = 1 AND cg.`id_group` IN (1) GROUP BY c.`id_category` ORDER BY c.`level_depth` ASC , category_shop.`position` ASC	0.7	26	Yes	Yes	/modules/bamegamenu/include/buyaddons.php:106 /modules/bamegamenu/bamegamenu.php:1997 /modules/bamegamenu/bamegamenu.php:2350 /modules/bamegamenu/bamegamenu.php:2396 /classes/Hook.php:599 /classes/Hook.php:546 /classes/controller/FrontController.php:589 /override/classes/controller/FrontController.php:118 /controllers/front/CategoryController.php:123 /override/controllers/front/CategoryController.php:24 /tools/profiling/Controller.php:220 /classes/Dispatcher.php:367 /index.php:40
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, SUM(IF(stock.`quantity` > 0, 1, 0)) 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 = 1) LEFT JOIN ps_stock_available stock ON (stock.id_product = pa.id_product AND stock.id_product_attribute = IFNULL(`pa`.id_product_attribute, 0) AND stock.id_shop = 1 AND stock.id_shop_group = 0 ) 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` = 2) JOIN `ps_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`) WHERE pa.`id_product` IN (12082,11460,11452) AND ag.`is_color_group` = 1 GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` HAVING qty > 0 ORDER BY a.`position` ASC;	0.6	3	Yes		/classes/Product.php:3572 /classes/controller/FrontController.php:1661 /controllers/front/CategoryController.php:231 /override/controllers/front/CategoryController.php:35 /controllers/front/CategoryController.php:144 /override/controllers/front/CategoryController.php:24 /tools/profiling/Controller.php:220 /classes/Dispatcher.php:367 /index.php:40
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	0.6	0			/classes/Hook.php:131 /classes/Hook.php:445 /classes/Dispatcher.php:407 /override/classes/Dispatcher.php:70 /classes/Dispatcher.php:228 /classes/Dispatcher.php:193 /index.php:40
SELECT SQL_NO_CACHE COUNT(DISTINCT lpa.id_product) AS nbr, lpa.id_attribute_group, a.color, al.name AS attribute_name, agl.public_name AS attribute_group_name, lpa.id_attribute, ag.is_color_group, liagl.url_name AS name_url_name, liagl.meta_title AS name_meta_title, lial.url_name AS value_url_name, lial.meta_title AS value_meta_title FROM ps_layered_product_attribute lpa INNER JOIN ps_attribute a ON a.id_attribute = lpa.id_attribute INNER JOIN ps_attribute_lang al ON al.id_attribute = a.id_attribute AND al.id_lang = 2 INNER JOIN ps_cat_restriction p ON p.id_product = lpa.id_product INNER JOIN ps_attribute_group ag ON ag.id_attribute_group = lpa.id_attribute_group INNER JOIN ps_attribute_group_lang agl ON agl.id_attribute_group = lpa.id_attribute_group AND agl.id_lang = 2 LEFT JOIN ps_product_attribute_combination pac ON pac.id_attribute = lpa.id_attribute LEFT JOIN ps_product_attribute pa ON pa.id_product_attribute = pac.id_product_attribute AND pa.id_product = lpa.id_product LEFT JOIN ps_stock_available sa ON ( sa.id_product = lpa.id_product AND sa.id_product_attribute = pa.id_product_attribute AND sa.id_shop = 1 ) LEFT JOIN ps_layered_indexable_attribute_group_lang_value liagl ON (liagl.id_attribute_group = lpa.id_attribute_group AND liagl.id_lang = 2) LEFT JOIN ps_layered_indexable_attribute_lang_value lial ON (lial.id_attribute = lpa.id_attribute AND lial.id_lang = 2) WHERE lpa.id_attribute_group = 2 AND lpa.id_shop = 1 AND sa.quantity > 0 GROUP BY lpa.id_attribute ORDER BY ag.position ASC, a.position ASC	0.6	6	Yes		/modules/blocklayered/blocklayered.php:2491 /modules/blocklayered/blocklayered.php:673 /classes/Hook.php:599 /classes/Hook.php:548 /classes/controller/FrontController.php:588 /override/classes/controller/FrontController.php:118 /controllers/front/CategoryController.php:123 /override/controllers/front/CategoryController.php:24 /tools/profiling/Controller.php:220 /classes/Dispatcher.php:367 /index.php:40
CREATE TEMPORARY TABLE ps_cat_filter_restriction ( id_product INT UNSIGNED NOT NULL, position INT UNSIGNED NOT NULL, PRIMARY KEY (id_product), KEY position_product (position, id_product) USING BTREE ) ENGINE=MEMORY SELECT cp.id_product, MIN(cp.position) position FROM ps_category c STRAIGHT_JOIN ps_category_product cp ON (c.id_category = cp.id_category AND c.nleft >= 155 AND c.nright <= 156 AND c.active = 1) STRAIGHT_JOIN `ps_product` p ON (p.id_product=cp.id_product) INNER JOIN ps_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) WHERE 1 AND product_shop.`active` = 1 AND product_shop.`visibility` IN ("both", "catalog") GROUP BY cp.id_product	0.5	1			/modules/blocklayered/blocklayered.php:2028 /modules/blocklayered/blocklayered.php:3359 /modules/blocklayered/blocklayered.php:640 /classes/Hook.php:599 /classes/Hook.php:548 /controllers/front/CategoryController.php:215 /override/controllers/front/CategoryController.php:35 /controllers/front/CategoryController.php:144 /override/controllers/front/CategoryController.php:24 /tools/profiling/Controller.php:220 /classes/Dispatcher.php:367 /index.php:40
SELECT SQL_NO_CACHE COUNT(DISTINCT lpa.id_product) AS nbr, lpa.id_attribute_group, a.color, al.name AS attribute_name, agl.public_name AS attribute_group_name, lpa.id_attribute, ag.is_color_group, liagl.url_name AS name_url_name, liagl.meta_title AS name_meta_title, lial.url_name AS value_url_name, lial.meta_title AS value_meta_title FROM ps_layered_product_attribute lpa INNER JOIN ps_attribute a ON a.id_attribute = lpa.id_attribute INNER JOIN ps_attribute_lang al ON al.id_attribute = a.id_attribute AND al.id_lang = 2 INNER JOIN ps_cat_restriction p ON p.id_product = lpa.id_product INNER JOIN ps_attribute_group ag ON ag.id_attribute_group = lpa.id_attribute_group INNER JOIN ps_attribute_group_lang agl ON agl.id_attribute_group = lpa.id_attribute_group AND agl.id_lang = 2 LEFT JOIN ps_product_attribute_combination pac ON pac.id_attribute = lpa.id_attribute LEFT JOIN ps_product_attribute pa ON pa.id_product_attribute = pac.id_product_attribute AND pa.id_product = lpa.id_product LEFT JOIN ps_stock_available sa ON ( sa.id_product = lpa.id_product AND sa.id_product_attribute = pa.id_product_attribute AND sa.id_shop = 1 ) LEFT JOIN ps_layered_indexable_attribute_group_lang_value liagl ON (liagl.id_attribute_group = lpa.id_attribute_group AND liagl.id_lang = 2) LEFT JOIN ps_layered_indexable_attribute_lang_value lial ON (lial.id_attribute = lpa.id_attribute AND lial.id_lang = 2) WHERE lpa.id_attribute_group = 3 AND lpa.id_shop = 1 AND sa.quantity > 0 GROUP BY lpa.id_attribute ORDER BY ag.position ASC, a.position ASC	0.5	6	Yes		/modules/blocklayered/blocklayered.php:2491 /modules/blocklayered/blocklayered.php:673 /classes/Hook.php:599 /classes/Hook.php:548 /classes/controller/FrontController.php:588 /override/classes/controller/FrontController.php:118 /controllers/front/CategoryController.php:123 /override/controllers/front/CategoryController.php:24 /tools/profiling/Controller.php:220 /classes/Dispatcher.php:367 /index.php:40
SHOW TABLES LIKE 'ps_nmtraffic_ip_rule'	0.5	1			/modules/nmban/nmban.php:251 /modules/nmban/nmban.php:233 /modules/nmban/nmban.php:140 /modules/nmban/nmban.php:106 /index.php:38
CREATE TEMPORARY TABLE ps_cat_restriction ( id_product INT UNSIGNED NOT NULL, id_manufacturer INT UNSIGNED NOT NULL DEFAULT 0, `condition` VARCHAR(32) NOT NULL, weight DECIMAL(20,6) NOT NULL DEFAULT 0, PRIMARY KEY (id_product), KEY `id_manufacturer` (`id_manufacturer`,`id_product`) USING BTREE, KEY `condition` (`condition`,`id_product`) USING BTREE, KEY `weight` (`weight`,`id_product`) USING BTREE ) ENGINE=MEMORY SELECT DISTINCT cp.id_product, p.id_manufacturer, product_shop.condition, p.weight FROM ps_category c STRAIGHT_JOIN ps_category_product cp ON (c.id_category = cp.id_category AND c.nleft >= 155 AND c.nright <= 156 AND c.active = 1) STRAIGHT_JOIN ps_product_shop product_shop ON (product_shop.id_product = cp.id_product AND product_shop.id_shop = 1) STRAIGHT_JOIN ps_product p ON (p.id_product=cp.id_product) WHERE product_shop.`active` = 1 AND product_shop.`visibility` IN ("both", "catalog")	0.5	1			/modules/blocklayered/blocklayered.php:2250 /modules/blocklayered/blocklayered.php:673 /classes/Hook.php:599 /classes/Hook.php:548 /classes/controller/FrontController.php:588 /override/classes/controller/FrontController.php:118 /controllers/front/CategoryController.php:123 /override/controllers/front/CategoryController.php:24 /tools/profiling/Controller.php:220 /classes/Dispatcher.php:367 /index.php:40
SELECT SQL_NO_CACHE c.*, cl.id_lang, cl.name, cl.description, cl.link_rewrite, cl.meta_title, cl.meta_keywords, cl.meta_description 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 `id_lang` = 2 AND cl.id_shop = 1 ) LEFT JOIN `ps_category_group` cg ON (cg.`id_category` = c.`id_category`) WHERE `id_parent` = 171 AND `active` = 1 AND cg.`id_group` =1 GROUP BY c.`id_category` ORDER BY `level_depth` ASC, category_shop.`position` ASC	0.5	1	Yes	Yes	/classes/Category.php:660 /controllers/front/CategoryController.php:197 /override/controllers/front/CategoryController.php:69 /controllers/front/CategoryController.php:143 /override/controllers/front/CategoryController.php:24 /tools/profiling/Controller.php:220 /classes/Dispatcher.php:367 /index.php:40
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ( SELECT id_module FROM `ps_module_shop` ms WHERE m.`id_module` = ms.`id_module` AND ms.`id_shop` = 1 LIMIT 1 ) as mshop FROM `ps_module` m	0.5	108			/classes/module/Module.php:277 /modules/revws/revws.php:67 :undefined /Core/Foundation/IoC/Core_Foundation_IoC_Container.php:124 /Core/Foundation/IoC/Core_Foundation_IoC_Container.php:157 /Core/Foundation/IoC/Core_Foundation_IoC_Container.php:170 /Adapter/Adapter_ServiceLocator.php:52 /classes/module/Module.php:1142 /classes/module/Module.php:1107 /classes/Hook.php:526 /classes/Dispatcher.php:407 /override/classes/Dispatcher.php:70 /classes/Dispatcher.php:228 /classes/Dispatcher.php:193 /index.php:40
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ( SELECT id_module FROM `ps_module_shop` ms WHERE m.`id_module` = ms.`id_module` AND ms.`id_shop` = 1 LIMIT 1 ) as mshop FROM `ps_module` m	0.5	108			/classes/module/Module.php:277 /modules/fsadvancedurl/classes/FsAdvancedUrlModule.php:62 /modules/fsadvancedurl/fsadvancedurl.php:118 :undefined /Core/Foundation/IoC/Core_Foundation_IoC_Container.php:124 /Core/Foundation/IoC/Core_Foundation_IoC_Container.php:157 /Core/Foundation/IoC/Core_Foundation_IoC_Container.php:170 /Adapter/Adapter_ServiceLocator.php:52 /classes/module/Module.php:1142 /classes/module/Module.php:1107 /classes/Hook.php:526 /classes/Dispatcher.php:407 /override/classes/Dispatcher.php:70 /classes/Dispatcher.php:228 /classes/Dispatcher.php:193 /index.php:40
SELECT SQL_NO_CACHE COUNT(DISTINCT p.id_product) FROM ps_product p INNER JOIN ps_product_shop ps ON ps.id_product = p.id_product AND ps.id_shop = 1 INNER JOIN ps_category_product cp ON cp.id_product = p.id_product WHERE ps.active = 1 AND ps.visibility IN ("both", "catalog") AND cp.id_category IN (SELECT child.id_category FROM ps_category child INNER JOIN ps_category parent ON parent.id_category = 171 WHERE child.nleft >= parent.nleft AND child.nright <= parent.nright AND child.active = 1) LIMIT 1	0.5	4797			/classes/NmShoppingFilters.php:233 /override/controllers/front/CategoryController.php:46 /controllers/front/CategoryController.php:144 /override/controllers/front/CategoryController.php:24 /tools/profiling/Controller.php:220 /classes/Dispatcher.php:367 /index.php:40
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ( SELECT id_module FROM `ps_module_shop` ms WHERE m.`id_module` = ms.`id_module` AND ms.`id_shop` = 1 LIMIT 1 ) as mshop FROM `ps_module` m	0.4	108			/classes/module/Module.php:277 /modules/datakick/datakick.php:30 :undefined /Core/Foundation/IoC/Core_Foundation_IoC_Container.php:124 /Core/Foundation/IoC/Core_Foundation_IoC_Container.php:157 /Core/Foundation/IoC/Core_Foundation_IoC_Container.php:170 /Adapter/Adapter_ServiceLocator.php:52 /classes/module/Module.php:1142 /classes/module/Module.php:1107 /classes/Hook.php:526 /classes/Dispatcher.php:407 /override/classes/Dispatcher.php:70 /classes/Dispatcher.php:228 /classes/Dispatcher.php:193 /index.php:40
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ( SELECT id_module FROM `ps_module_shop` ms WHERE m.`id_module` = ms.`id_module` AND ms.`id_shop` = 1 LIMIT 1 ) as mshop FROM `ps_module` m	0.4	108			/classes/module/Module.php:277 /modules/blockcart/blockcart.php:41 :undefined /Core/Foundation/IoC/Core_Foundation_IoC_Container.php:124 /Core/Foundation/IoC/Core_Foundation_IoC_Container.php:157 /Core/Foundation/IoC/Core_Foundation_IoC_Container.php:170 /Adapter/Adapter_ServiceLocator.php:52 /classes/module/Module.php:1142 /classes/module/Module.php:1107 /classes/Hook.php:526 /classes/controller/FrontController.php:588 /override/classes/controller/FrontController.php:118 /controllers/front/CategoryController.php:123 /override/controllers/front/CategoryController.php:24 /tools/profiling/Controller.php:220 /classes/Dispatcher.php:367 /index.php:40
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ( SELECT id_module FROM `ps_module_shop` ms WHERE m.`id_module` = ms.`id_module` AND ms.`id_shop` = 1 LIMIT 1 ) as mshop FROM `ps_module` m	0.4	108			/classes/module/Module.php:277 /modules/nmban/nmban.php:30 :undefined /Core/Foundation/IoC/Core_Foundation_IoC_Container.php:124 /Core/Foundation/IoC/Core_Foundation_IoC_Container.php:157 /Core/Foundation/IoC/Core_Foundation_IoC_Container.php:170 /Adapter/Adapter_ServiceLocator.php:52 /classes/module/Module.php:1142 /classes/module/Module.php:1107 /index.php:34
SELECT SQL_NO_CACHE * FROM `ps_state` ORDER BY `name` ASC	0.4	310	Yes		/classes/Country.php:137 /modules/blocknewsletter/blocknewsletter.php:74 :undefined /Core/Foundation/IoC/Core_Foundation_IoC_Container.php:124 /Core/Foundation/IoC/Core_Foundation_IoC_Container.php:157 /Core/Foundation/IoC/Core_Foundation_IoC_Container.php:170 /Adapter/Adapter_ServiceLocator.php:52 /classes/module/Module.php:1142 /classes/module/Module.php:1107 /classes/Hook.php:526 /classes/controller/FrontController.php:588 /override/classes/controller/FrontController.php:118 /controllers/front/CategoryController.php:123 /override/controllers/front/CategoryController.php:24 /tools/profiling/Controller.php:220 /classes/Dispatcher.php:367 /index.php:40
SELECT SQL_NO_CACHE s.*, sl.`description` FROM `ps_supplier` s LEFT JOIN `ps_supplier_lang` `sl` ON s.`id_supplier` = sl.`id_supplier` AND sl.`id_lang` = 2 INNER JOIN ps_supplier_shop supplier_shop ON (supplier_shop.id_supplier = s.id_supplier AND supplier_shop.id_shop = 1) WHERE (s.`active` = 1) GROUP BY s.id_supplier ORDER BY s.`name` ASC	0.4	4	Yes	Yes	/classes/Supplier.php:127 /controllers/front/CategoryController.php:161 /override/controllers/front/CategoryController.php:24 /tools/profiling/Controller.php:220 /classes/Dispatcher.php:367 /index.php:40
SELECT SQL_NO_CACHE leaf.id_category AS id_category_leaf, c., cl. FROM ps_category leaf INNER JOIN ps_category c ON c.nleft <= leaf.nleft AND c.nright >= leaf.nright LEFT JOIN ps_category_lang cl ON cl.id_category = c.id_category AND cl.id_lang = 2 AND cl.id_shop = 1 WHERE leaf.id_category IN (171) ORDER BY leaf.id_category, c.nleft	0.4	166			/classes/Product.php:6151 /modules/blocklayered/blocklayered.php:3387 /modules/blocklayered/blocklayered.php:640 /classes/Hook.php:599 /classes/Hook.php:548 /controllers/front/CategoryController.php:215 /override/controllers/front/CategoryController.php:35 /controllers/front/CategoryController.php:144 /override/controllers/front/CategoryController.php:24 /tools/profiling/Controller.php:220 /classes/Dispatcher.php:367 /index.php:40
SELECT SQL_NO_CACHE * FROM `ps_category` a LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 2 LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1 WHERE (a.`id_category` = 26) AND (b.`id_shop` = 1) LIMIT 1	0.4	1			/Adapter/Adapter_EntityMapper.php:61 /classes/ObjectModel.php:233 /tools/profiling/ObjectModel.php:33 /classes/Category.php:141 /override/classes/Category.php:11 /modules/bamegamenu/bamegamenu.php:1712 /modules/bamegamenu/bamegamenu.php:2263 /modules/bamegamenu/bamegamenu.php:2396 /classes/Hook.php:599 /classes/Hook.php:546 /classes/controller/FrontController.php:589 /override/classes/controller/FrontController.php:118 /controllers/front/CategoryController.php:123 /override/controllers/front/CategoryController.php:24 /tools/profiling/Controller.php:220 /classes/Dispatcher.php:367 /index.php:40
SELECT SQL_NO_CACHE s.id_shop, CONCAT(su.physical_uri, su.virtual_uri) AS uri, su.domain, su.main FROM ps_shop_url su LEFT JOIN ps_shop s ON (s.id_shop = su.id_shop) WHERE (su.domain = 'najlepsiamoda.sk' OR su.domain_ssl = 'najlepsiamoda.sk') AND s.active = 1 AND s.deleted = 0 ORDER BY LENGTH(CONCAT(su.physical_uri, su.virtual_uri)) DESC	0.4	1	Yes		/classes/shop/Shop.php:334 /config/config.inc.php:114 /index.php:27
SELECT SQL_NO_CACHE cr.`id_cart_rule`, cr.`code`, cr.`product_restriction`, cr.`group_restriction`, cr.`shop_restriction` FROM `ps_cart_rule` cr WHERE cr.`active` = 1 AND cr.`quantity` > 0 AND cr.`code` != "" AND cr.`product_restriction` = 1 AND cr.`date_from` <= NOW() AND cr.`date_to` >= NOW() AND cr.`id_customer` IN (0, 0)	0.4	10			/override/classes/controller/FrontController.php:147 /modules/topbanner/topbanner.php:302 /modules/topbanner/topbanner.php:267 /classes/Hook.php:599 /classes/Hook.php:546 /config/smarty.config.inc.php:203 /config/smarty.config.inc.php:266 /cache/smarty/compile/aa/24/e2/aa24e2215d4463e3dbc1c29ea480fd6aac4eb0ae.file.header.tpl.php:227 /tools/smarty/sysplugins/smarty_internal_templatebase.php:188 /classes/SmartyCustom.php:317 /tools/smarty/sysplugins/smarty_internal_template.php:303 /cache/smarty/compile/2a/c9/1f/2ac91f7c75640c0f1b331c28b5b5d30dff4d64aa.file.layout.tpl.php:38 /tools/smarty/sysplugins/smarty_internal_templatebase.php:188 /classes/SmartyCustom.php:110 /classes/controller/Controller.php:529 /classes/controller/FrontController.php:732 /override/classes/controller/FrontController.php:110 /tools/profiling/Controller.php:733 /tools/profiling/Controller.php:241 /classes/Dispatcher.php:367 /index.php:40
SELECT SQL_NO_CACHE cl.,c., cl.`name` country, z.`name` zone FROM `ps_country` c INNER JOIN ps_country_shop country_shop ON (country_shop.id_country = c.id_country AND country_shop.id_shop = 1) LEFT JOIN `ps_country_lang` cl ON (c.`id_country` = cl.`id_country` AND cl.`id_lang` = 2) LEFT JOIN `ps_zone` z ON (z.`id_zone` = c.`id_zone`) WHERE 1 ORDER BY cl.name ASC	0.4	10	Yes		/classes/Country.php:130 /modules/blocknewsletter/blocknewsletter.php:74 :undefined /Core/Foundation/IoC/Core_Foundation_IoC_Container.php:124 /Core/Foundation/IoC/Core_Foundation_IoC_Container.php:157 /Core/Foundation/IoC/Core_Foundation_IoC_Container.php:170 /Adapter/Adapter_ServiceLocator.php:52 /classes/module/Module.php:1142 /classes/module/Module.php:1107 /classes/Hook.php:526 /classes/controller/FrontController.php:588 /override/classes/controller/FrontController.php:118 /controllers/front/CategoryController.php:123 /override/controllers/front/CategoryController.php:24 /tools/profiling/Controller.php:220 /classes/Dispatcher.php:367 /index.php:40
SELECT SQL_NO_CACHE DISTINCT a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group` FROM `ps_attribute` a LEFT JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 2) LEFT JOIN `ps_attribute_group_lang` agl ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 2) LEFT JOIN `ps_product_attribute_combination` pac ON (a.`id_attribute` = pac.`id_attribute`) LEFT JOIN `ps_product_attribute` pa ON (pac.`id_product_attribute` = pa.`id_product_attribute`) 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 = 1) WHERE pa.`id_product` = 11452 AND pac.id_product_attribute = 118095 AND a.`id_attribute` NOT IN(4, 11)	0.3	2			/classes/Product.php:5834 /classes/Product.php:5967 /classes/Link.php:160 /cache/smarty/compile/a5/01/04/a50104756374e043fa559dafe3e25fc220d13b63.file.product-list-colors.tpl.php:42 /tools/smarty/sysplugins/smarty_internal_templatebase.php:188 /classes/SmartyCustom.php:317 /classes/controller/FrontController.php:1678 /controllers/front/CategoryController.php:231 /override/controllers/front/CategoryController.php:35 /controllers/front/CategoryController.php:144 /override/controllers/front/CategoryController.php:24 /tools/profiling/Controller.php:220 /classes/Dispatcher.php:367 /index.php:40
SELECT SQL_NO_CACHE gs., s., gs.name AS group_name, s.name AS shop_name, s.active, su.domain, su.domain_ssl, su.physical_uri, su.virtual_uri FROM ps_shop_group gs LEFT JOIN ps_shop s ON s.id_shop_group = gs.id_shop_group LEFT JOIN ps_shop_url su ON s.id_shop = su.id_shop AND su.main = 1 WHERE s.deleted = 0 AND gs.deleted = 0 ORDER BY gs.name, s.name	0.3	1	Yes		/classes/shop/Shop.php:663 /classes/shop/Shop.php:717 /classes/Configuration.php:244 /classes/shop/Shop.php:369 /config/config.inc.php:114 /index.php:27
SELECT SQL_NO_CACHE id_product, name, value, pf.id_feature FROM ps_feature_product pf LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 2) LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 2) LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature) INNER JOIN ps_feature_shop feature_shop ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1) WHERE `id_product` IN (12082,11460,11452) ORDER BY f.position ASC	0.3	5	Yes		/classes/Product.php:3874 /modules/blocklayered/blocklayered.php:3388 /modules/blocklayered/blocklayered.php:640 /classes/Hook.php:599 /classes/Hook.php:548 /controllers/front/CategoryController.php:215 /override/controllers/front/CategoryController.php:35 /controllers/front/CategoryController.php:144 /override/controllers/front/CategoryController.php:24 /tools/profiling/Controller.php:220 /classes/Dispatcher.php:367 /index.php:40
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	0.3	51	Yes		/classes/Dispatcher.php:452 /override/classes/Dispatcher.php:70 /classes/Dispatcher.php:228 /classes/Dispatcher.php:193 /index.php:40
SELECT SQL_NO_CACHE r.id_entity AS id_product, (SUM(ra.grade) / COUNT(1)) AS grade, COUNT(DISTINCT r.id_review) AS cnt FROM ps_revws_review r LEFT JOIN ps_revws_review_grade ra ON (r.id_review = ra.id_review) WHERE r.entity_type = 'product' AND r.id_entity IN (12082,11460,11452) AND r.validated = 1 AND r.deleted = 0 AND r.id_lang = 2 GROUP BY r.id_entity	0.3	3			/modules/revws/revws.php:490 /modules/revws/revws.php:444 /classes/Hook.php:599 /classes/Hook.php:546 /config/smarty.config.inc.php:203 /config/smarty.config.inc.php:266 /cache/smarty/compile/ee/c2/4f/eec24fa8b0f13abd8a1d3c4d412b4379ec787700.file.product-list.tpl.php:254 /tools/smarty/sysplugins/smarty_internal_templatebase.php:188 /classes/SmartyCustom.php:317 /tools/smarty/sysplugins/smarty_internal_template.php:303 /cache/smarty/compile/b0/9f/ff/b09fff6c729e1e11696440b073bf5e347e511195.file.category.tpl.php:415 /tools/smarty/sysplugins/smarty_internal_templatebase.php:188 /classes/SmartyCustom.php:110 /classes/controller/FrontController.php:722 /override/classes/controller/FrontController.php:110 /tools/profiling/Controller.php:733 /tools/profiling/Controller.php:241 /classes/Dispatcher.php:367 /index.php:40
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) + IF (`id_country` = 37, 4, 0) + IF (`id_currency` = 1, 8, 0) + IF (`id_shop` = 1, 16, 0) + IF (`id_customer` = 0, 32, 0)) AS `score` FROM `ps_specific_price` WHERE `id_shop` IN (0, 1) AND `id_currency` IN (0, 1) AND `id_country` IN (0, 37) AND `id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0 AND (`from` = '0000-00-00 00:00:00' OR '2026-10-25 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2026-10-25 00:00:00' <= `to`) AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1	0.3	1	Yes		/classes/SpecificPrice.php:362 /classes/Product.php:3080 /classes/Product.php:3005 /classes/Product.php:4441 /classes/Product.php:4685 /modules/blocklayered/blocklayered.php:3390 /modules/blocklayered/blocklayered.php:640 /classes/Hook.php:599 /classes/Hook.php:548 /controllers/front/CategoryController.php:215 /override/controllers/front/CategoryController.php:35 /controllers/front/CategoryController.php:144 /override/controllers/front/CategoryController.php:24 /tools/profiling/Controller.php:220 /classes/Dispatcher.php:367 /index.php:40
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) + IF (`id_country` = 37, 4, 0) + IF (`id_currency` = 1, 8, 0) + IF (`id_shop` = 1, 16, 0) + IF (`id_customer` = 0, 32, 0)) AS `score` FROM `ps_specific_price` WHERE `id_shop` IN (0, 1) AND `id_currency` IN (0, 1) AND `id_country` IN (0, 37) AND `id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0 AND (`from` = '0000-00-00 00:00:00' OR '2026-10-25 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2026-10-25 00:00:00' <= `to`) AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1	0.3	1	Yes		/classes/SpecificPrice.php:362 /classes/Product.php:3080 /classes/Product.php:3005 /classes/Product.php:4441 /classes/Product.php:4685 /modules/blocklayered/blocklayered.php:3390 /modules/blocklayered/blocklayered.php:640 /classes/Hook.php:599 /classes/Hook.php:548 /controllers/front/CategoryController.php:215 /override/controllers/front/CategoryController.php:35 /controllers/front/CategoryController.php:144 /override/controllers/front/CategoryController.php:24 /tools/profiling/Controller.php:220 /classes/Dispatcher.php:367 /index.php:40