Soodushinnaga

Kokku on 3 toodet.

Sorteeri:

Kuvatakse 1–3 toodet (kokku 3)

−20%

Voodipesukomplekt Nala Blue

71,96 € - 135,96 € 89,95 € - 169,95 €
- Materjal: 100% puuvilla
- Kanga tüüp: Satään
- TC: 220
−40%

Voodipesukomplekt Silke Blue Green

55,31 € - 104,50 € 92,18 € - 174,16 €
- Materjal: 100% puuvilla
- Kanga tüüp: Satään
- TC: 220
−20%

Padjapüür Silke Blue Green

15,99 € 19,99 €
- Materjal: 100% puuvilla
- Kanga tüüp: Satään
- TC: 220

Load Time	324 ms - Unicorn powered webserver!
Querying Time	196 ms
Queries	568
Memory Peak Usage	21.1 Mb
Included Files	1008 files - 10.42 Mb
PrestaShop Cache	- Mb
Global vars	0.23 Mb
- global $_MODULES	128k
- global $smarty	65k
- global $context	15k
- global $_SERVER	8k
- global $__composer_autoload_files	8k
- global $exportPhpConfigFile	4k
- global $config	3k

PrestaShop Version	1.7.6.7
PHP Version	7.3.33 (OK)
MySQL Version	8.0.44 (OK)
Memory Limit	256M
Max Execution Time	30s
Smarty Cache	enabled
Smarty Compilation	auto

	Time	Cumulated Time	Memory Usage	Memory Peak Usage
config	43 ms	43 ms	4.88 Mb	4.88 Mb
__construct	0 ms	43 ms	- Mb	4.88 Mb
init	18 ms	60 ms	1.55 Mb	6.44 Mb
checkAccess	0 ms	60 ms	- Mb	6.44 Mb
setMedia	1 ms	62 ms	0.27 Mb	6.71 Mb
postProcess	0 ms	62 ms	- Mb	6.71 Mb
initHeader	- ms	62 ms	- Mb	6.71 Mb
initContent	185 ms	247 ms	6.35 Mb	13.41 Mb
initFooter	0 ms	247 ms	- Mb	13.41 Mb
display	77 ms	324 ms	7.68 Mb	21.06 Mb

59	SELECT `id_tot_switch_attribute_disabled` FROM `ps_tot_switch_attribute_disabled` WHERE `id_product_attribute` = "XX" AND `id_shop` = "XX" LIMIT XX
35	SELECT `excluded_p` FROM `ps_fmm_stickers_rules` WHERE `fmm_stickers_rules_id` = XX LIMIT XX
34	SELECT COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), XX) as deep_quantity, COALESCE(SUM(first_level_quantity), XX) as quantity FROM (SELECT cp.`quantity` as first_level_quantity, XX as pack_quantity FROM `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, 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
34	SELECT SUM(quantity) FROM `ps_stock_available` WHERE (id_product = XX) AND (id_product_attribute = XX) AND (id_shop_group = XX) AND (id_shop = XX) LIMIT XX
32	SELECT fsr.* FROM `ps_fmm_stickers_rules` fsr LEFT JOIN `ps_fmm_stickers_rules_shop` fsrs ON (fsr.`fmm_stickers_rules_id` = fsrs.`fmm_stickers_rules_id`) WHERE fsr.`status` = XX AND fsr.`rule_type` = "category" AND fsrs.`id_shop` = XX AND ( (fsr.`start_date` = 'XX-XX-XX XX:XX:XX' OR 'XX-XX-XX XX:XX:XX' >= fsr.`start_date`) AND (fsr.`expiry_date` = 'XX-XX-XX XX:XX:XX' OR 'XX-XX-XX XX:XX:XX' <= fsr.`expiry_date`) )
31	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` IN (XX, 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
10	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	SELECT out_of_stock FROM `ps_stock_available` WHERE (id_product = XX) AND (id_product_attribute = XX) AND (id_shop_group = XX) AND (id_shop = XX) LIMIT XX
7	SELECT 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` = XX
6	SELECT t.`id_lang`, t.`name` FROM ps_tag t LEFT JOIN ps_product_tag pt ON (pt.id_tag = t.id_tag) WHERE pt.`id_product`=XX
6	SELECT hm.`id_module` FROM `ps_hook_module` hm, `ps_hook` h WHERE hm.`id_module` = XX AND h.`id_hook` = XX AND h.`id_hook` = hm.`id_hook` AND `id_shop` = XX LIMIT XX
6	SELECT `id_module` FROM `ps_module_shop` WHERE `id_module` = XX AND `id_shop` = XX LIMIT XX
6	SELECT COUNT(*) 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` = XX LIMIT XX
5	SELECT c.`nleft`, c.`nright` FROM `ps_category` c WHERE c.`id_category` = XX LIMIT XX
5	SELECT * FROM `ps_category_lang` WHERE `id_category` = XX AND `id_shop` = XX
5	SELECT c.`nleft`, c.`nright` FROM `ps_category` c LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND `id_lang` = XX AND cl.id_shop = XX ) LEFT JOIN `ps_category_shop` cs ON (c.`id_category` = cs.`id_category` AND cs.`id_shop` = XX) AND cs.`id_shop` = XX AND c.`id_parent` != XX WHERE c.`id_category` = XX LIMIT XX
5	SELECT * FROM `ps_category` a LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = XX WHERE (a.`id_category` = XX) LIMIT XX
5	SELECT c., cl. FROM `ps_category` c LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND `id_lang` = XX AND cl.id_shop = XX ) LEFT JOIN `ps_category_shop` cs ON (c.`id_category` = cs.`id_category` AND cs.`id_shop` = XX) AND cs.`id_shop` = XX AND c.`id_parent` != XX WHERE c.`nleft` <= XX AND c.`nright` >= XX AND c.`nleft` >= XX AND c.`nright` <= XX ORDER BY `nleft` DESC
5	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 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_group = XX AND sa.id_shop = XX ) LEFT JOIN ps_product_sale psales ON (psales.id_product = p.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_product cp ON (p.id_product = cp.id_product) 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 IN (XX, XX, XX))) AND ((fp_XX.id_feature_value=XX)) AND ((fp_XX.id_feature_value IN (XX, XX))) AND ps.id_shop='XX' AND p.visibility IN ('both', 'catalog') AND cg.id_group='XX' AND p.id_manufacturer='XX' AND cp.id_category='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 IN (XX, XX, XX))) AND ((fp_XX.id_feature_value=XX)) AND ((fp_XX.id_feature_value IN (XX, XX))) GROUP BY fp.id_feature_value
4	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
3	SELECT pa.id_product_attribute 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_tot_switch_attribute_disabled` `t` ON t.id_product_attribute = pa.id_product_attribute WHERE (pa.id_product = XX) AND (t.id_tot_switch_attribute_disabled IS NULL) GROUP BY pa.id_product_attribute
3	(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` = XX) WHERE cr.`id_customer` = XX AND NOW() BETWEEN cr.date_from AND cr.date_to AND cr.`active` = XX AND cr.`quantity` > XX AND highlight = XX AND code NOT LIKE "BO_ORDER_%") UNION (SELECT * 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` = XX) WHERE cr.`group_restriction` = XX AND NOW() BETWEEN cr.date_from AND cr.date_to AND cr.`active` = XX AND cr.`quantity` > XX AND highlight = XX AND code NOT LIKE "BO_ORDER_%")
3	SELECT id_image FROM `ps_image` WHERE (id_product = XX) AND (on_hover = XX) LIMIT XX
3	SELECT pac.`id_product_attribute`, al.`name` AS attribute_name FROM `ps_product_attribute_combination` pac LEFT JOIN `ps_attribute` a ON a.`id_attribute` = pac.`id_attribute` LEFT JOIN `ps_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group` LEFT JOIN `ps_attribute_lang` al ON ( a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = XX ) WHERE pac.`id_product_attribute` = XX
3	SELECT DISTINCT pl.name as name FROM `ps_product_lang` pl WHERE (pl.id_product = XX) AND (pl.id_lang = XX AND pl.id_shop = XX ) LIMIT XX
3	SELECT pa., product_attribute_shop., ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, al.`name` AS attribute_name, a.`id_attribute` 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_product_attribute_combination` pac ON pac.`id_product_attribute` = pa.`id_product_attribute` LEFT JOIN `ps_attribute` a ON a.`id_attribute` = pac.`id_attribute` LEFT JOIN `ps_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group` 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 (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = XX) WHERE pa.`id_product` = XX ORDER BY pa.`id_product_attribute`
3	SELECT * FROM `ps_product` a LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = XX WHERE (a.`id_product` = XX) LIMIT XX
3	SELECT name FROM ps_category_lang WHERE id_shop = XX AND id_lang = XX AND id_category = XX LIMIT XX
3	SELECT pa., product_attribute_shop., ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, al.`name` AS attribute_name, a.`id_attribute` 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_product_attribute_combination` pac ON pac.`id_product_attribute` = pa.`id_product_attribute` LEFT JOIN `ps_attribute` a ON a.`id_attribute` = pac.`id_attribute` LEFT JOIN `ps_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group` 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 (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = XX) WHERE pa.`id_product` = XX GROUP BY pa.`id_product_attribute`,ag.`id_attribute_group` ORDER BY pa.`id_product_attribute`
3	SELECT p., pl., sa.out_of_stock, IFNULL(sa.quantity, XX) as quantity, (DATEDIFF( p.`date_add`, DATE_SUB( 'XX-XX-XX XX:XX:XX', INTERVAL XX DAY ) ) > XX) as new FROM ps_product p LEFT JOIN ps_product_lang pl ON pl.id_product = p.id_product AND pl.id_shop = XX AND pl.id_lang = XX LEFT JOIN ps_stock_available sa ON sa.id_product = p.id_product AND sa.id_shop = XX WHERE p.id_product = XX
3	SELECT `id_product_attribute` FROM `ps_product_attribute` WHERE `id_product` = XX
3	SELECT `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = XX AND `id_group` = XX LIMIT XX
3	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`
3	SELECT pai.id_image FROM `ps_product_attribute` pa INNER JOIN `ps_product_attribute_image` `pai` ON pai.id_product_attribute = pa.id_product_attribute LEFT JOIN `ps_tot_switch_attribute_disabled` `t` ON t.id_product_attribute = pa.id_product_attribute WHERE (pa.id_product = XX) AND (t.id_tot_switch_attribute_disabled IS NULL)
3	SELECT product_attribute_shop.id_product_attribute 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 = XX LIMIT XX
3	SELECT product_attribute_shop.id_product_attribute 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 product_attribute_shop.default_on = XX AND pa.id_product = XX LIMIT XX
3	SELECT * FROM `ps_product_attribute` a LEFT JOIN `ps_product_attribute_shop` `c` ON a.`id_product_attribute` = c.`id_product_attribute` AND c.`id_shop` = XX WHERE (a.`id_product_attribute` = XX) LIMIT XX
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 * FROM `ps_tot_switch_attribute_disabled` AS sad WHERE `id_product_attribute` = XX AND sad.id_shop IN (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 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 name, value, image, pf.id_feature, f.position 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 fv ON (fv.id_feature_value = pf.id_feature_value) 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, fv.id_feature_value ASC
3	SELECT pa.`available_date` FROM `ps_product` p LEFT JOIN `ps_product_attribute` pa ON (pa.`id_product` = p.`id_product`) INNER JOIN ps_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = XX) 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 p.`id_product` = XX AND pa.`id_product` = XX AND pa.`id_product_attribute` = XX LIMIT XX
3	SELECT a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, pa.`reference`, pa.`eanXX`, pa.`isbn`,pa.`upc` FROM `ps_attribute` a LEFT JOIN `ps_attribute_lang` al ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = XX) LEFT JOIN `ps_product_attribute_combination` pac ON (pac.`id_attribute` = a.`id_attribute`) LEFT JOIN `ps_product_attribute` pa ON (pa.`id_product_attribute` = pac.`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_attribute_group_lang` agl ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = XX) WHERE pa.`id_product` = XX AND pac.`id_product_attribute` = XX AND agl.`id_lang` = XX
3	SELECT * FROM `ps_product_lang` WHERE `id_product` = XX AND `id_shop` = 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 fsr.* FROM `ps_fmm_stickers_rules` fsr LEFT JOIN `ps_fmm_stickers_rules_shop` fsrs ON (fsr.`fmm_stickers_rules_id` = fsrs.`fmm_stickers_rules_id`) WHERE fsr.`status` = XX AND fsr.`rule_type` = "reference" AND fsrs.`id_shop` = XX AND ( (fsr.`start_date` = 'XX-XX-XX XX:XX:XX' OR 'XX-XX-XX XX:XX:XX' >= fsr.`start_date`) AND (fsr.`expiry_date` = 'XX-XX-XX XX:XX:XX' OR 'XX-XX-XX XX:XX:XX' <= fsr.`expiry_date`) )
3	SELECT fsr.* FROM `ps_fmm_stickers_rules` fsr LEFT JOIN `ps_fmm_stickers_rules_shop` fsrs ON (fsr.`fmm_stickers_rules_id` = fsrs.`fmm_stickers_rules_id`) WHERE fsr.`status` = XX AND fsr.`rule_type` = "stock_l" AND fsrs.`id_shop` = XX AND ( (fsr.`start_date` = 'XX-XX-XX XX:XX:XX' OR 'XX-XX-XX XX:XX:XX' >= fsr.`start_date`) AND (fsr.`expiry_date` = 'XX-XX-XX XX:XX:XX' OR 'XX-XX-XX XX:XX:XX' <= fsr.`expiry_date`) )
3	SELECT fsr.* FROM `ps_fmm_stickers_rules` fsr LEFT JOIN `ps_fmm_stickers_rules_shop` fsrs ON (fsr.`fmm_stickers_rules_id` = fsrs.`fmm_stickers_rules_id`) WHERE fsr.`status` = XX AND fsr.`rule_type` = "stock_g" AND fsrs.`id_shop` = XX AND ( (fsr.`start_date` = 'XX-XX-XX XX:XX:XX' OR 'XX-XX-XX XX:XX:XX' >= fsr.`start_date`) AND (fsr.`expiry_date` = 'XX-XX-XX XX:XX:XX' OR 'XX-XX-XX XX:XX:XX' <= fsr.`expiry_date`) )
3	SELECT fsr.* FROM `ps_fmm_stickers_rules` fsr LEFT JOIN `ps_fmm_stickers_rules_shop` fsrs ON (fsr.`fmm_stickers_rules_id` = fsrs.`fmm_stickers_rules_id`) WHERE fsr.`status` = XX AND fsr.`rule_type` = "customer" AND fsrs.`id_shop` = XX AND ( (fsr.`start_date` = 'XX-XX-XX XX:XX:XX' OR 'XX-XX-XX XX:XX:XX' >= fsr.`start_date`) AND (fsr.`expiry_date` = 'XX-XX-XX XX:XX:XX' OR 'XX-XX-XX XX:XX:XX' <= fsr.`expiry_date`) )
3	SELECT * FROM `ps_shop` a WHERE (a.`id_shop` = XX) LIMIT XX
3	SELECT 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 = XX AND s.active = XX AND s.deleted = XX AND su.main = XX LIMIT XX
3	SELECT fsr.* FROM `ps_fmm_stickers_rules` fsr LEFT JOIN `ps_fmm_stickers_rules_shop` fsrs ON (fsr.`fmm_stickers_rules_id` = fsrs.`fmm_stickers_rules_id`) WHERE fsr.`status` = XX AND fsr.`rule_type` = "bestseller" AND fsrs.`id_shop` = XX AND ( (fsr.`start_date` = 'XX-XX-XX XX:XX:XX' OR 'XX-XX-XX XX:XX:XX' >= fsr.`start_date`) AND (fsr.`expiry_date` = 'XX-XX-XX XX:XX:XX' OR 'XX-XX-XX XX:XX:XX' <= fsr.`expiry_date`) )
3	SELECT fsr.* FROM `ps_fmm_stickers_rules` fsr LEFT JOIN `ps_fmm_stickers_rules_shop` fsrs ON (fsr.`fmm_stickers_rules_id` = fsrs.`fmm_stickers_rules_id`) WHERE fsr.`status` = XX AND fsr.`rule_type` = "product" AND fsrs.`id_shop` = XX AND ( (fsr.`start_date` = 'XX-XX-XX XX:XX:XX' OR 'XX-XX-XX XX:XX:XX' >= fsr.`start_date`) AND (fsr.`expiry_date` = 'XX-XX-XX XX:XX:XX' OR 'XX-XX-XX XX:XX:XX' <= fsr.`expiry_date`) )
3	SELECT fsr.* FROM `ps_fmm_stickers_rules` fsr LEFT JOIN `ps_fmm_stickers_rules_shop` fsrs ON (fsr.`fmm_stickers_rules_id` = fsrs.`fmm_stickers_rules_id`) WHERE fsr.`status` = XX AND fsr.`rule_type` = "supplier" AND fsrs.`id_shop` = XX AND ( (fsr.`start_date` = 'XX-XX-XX XX:XX:XX' OR 'XX-XX-XX XX:XX:XX' >= fsr.`start_date`) AND (fsr.`expiry_date` = 'XX-XX-XX XX:XX:XX' OR 'XX-XX-XX XX:XX:XX' <= fsr.`expiry_date`) )
3	SELECT fsr.* FROM `ps_fmm_stickers_rules` fsr LEFT JOIN `ps_fmm_stickers_rules_shop` fsrs ON (fsr.`fmm_stickers_rules_id` = fsrs.`fmm_stickers_rules_id`) WHERE fsr.`status` = XX AND fsr.`rule_type` = "p_type" AND fsrs.`id_shop` = XX AND ( (fsr.`start_date` = 'XX-XX-XX XX:XX:XX' OR 'XX-XX-XX XX:XX:XX' >= fsr.`start_date`) AND (fsr.`expiry_date` = 'XX-XX-XX XX:XX:XX' OR 'XX-XX-XX XX:XX:XX' <= fsr.`expiry_date`) )
3	SELECT fsr.* FROM `ps_fmm_stickers_rules` fsr LEFT JOIN `ps_fmm_stickers_rules_shop` fsrs ON (fsr.`fmm_stickers_rules_id` = fsrs.`fmm_stickers_rules_id`) WHERE fsr.`status` = XX AND fsr.`rule_type` = "condition" AND fsrs.`id_shop` = XX AND ( (fsr.`start_date` = 'XX-XX-XX XX:XX:XX' OR 'XX-XX-XX XX:XX:XX' >= fsr.`start_date`) AND (fsr.`expiry_date` = 'XX-XX-XX XX:XX:XX' OR 'XX-XX-XX XX:XX:XX' <= fsr.`expiry_date`) )
3	SELECT fsr.* FROM `ps_fmm_stickers_rules` fsr LEFT JOIN `ps_fmm_stickers_rules_shop` fsrs ON (fsr.`fmm_stickers_rules_id` = fsrs.`fmm_stickers_rules_id`) WHERE fsr.`status` = XX AND fsr.`rule_type` = "brand" AND fsrs.`id_shop` = XX AND ( (fsr.`start_date` = 'XX-XX-XX XX:XX:XX' OR 'XX-XX-XX XX:XX:XX' >= fsr.`start_date`) AND (fsr.`expiry_date` = 'XX-XX-XX XX:XX:XX' OR 'XX-XX-XX XX:XX:XX' <= fsr.`expiry_date`) )
3	SELECT fsr.* FROM `ps_fmm_stickers_rules` fsr LEFT JOIN `ps_fmm_stickers_rules_shop` fsrs ON (fsr.`fmm_stickers_rules_id` = fsrs.`fmm_stickers_rules_id`) WHERE fsr.`status` = XX AND fsr.`rule_type` = "onsale" AND fsrs.`id_shop` = XX AND ( (fsr.`start_date` = 'XX-XX-XX XX:XX:XX' OR 'XX-XX-XX XX:XX:XX' >= fsr.`start_date`) AND (fsr.`expiry_date` = 'XX-XX-XX XX:XX:XX' OR 'XX-XX-XX XX:XX:XX' <= fsr.`expiry_date`) )
3	SELECT fsr.* FROM `ps_fmm_stickers_rules` fsr LEFT JOIN `ps_fmm_stickers_rules_shop` fsrs ON (fsr.`fmm_stickers_rules_id` = fsrs.`fmm_stickers_rules_id`) WHERE fsr.`status` = XX AND fsr.`rule_type` = "price_greater" AND fsrs.`id_shop` = XX AND ( (fsr.`start_date` = 'XX-XX-XX XX:XX:XX' OR 'XX-XX-XX XX:XX:XX' >= fsr.`start_date`) AND (fsr.`expiry_date` = 'XX-XX-XX XX:XX:XX' OR 'XX-XX-XX XX:XX:XX' <= fsr.`expiry_date`) )
3	SELECT `id_tax_rules_group` FROM `ps_product_shop` WHERE `id_product` = XX AND id_shop=XX LIMIT XX
3	SELECT fsr.* FROM `ps_fmm_stickers_rules` fsr LEFT JOIN `ps_fmm_stickers_rules_shop` fsrs ON (fsr.`fmm_stickers_rules_id` = fsrs.`fmm_stickers_rules_id`) WHERE fsr.`status` = XX AND fsr.`rule_type` = "price_less" AND fsrs.`id_shop` = XX AND ( (fsr.`start_date` = 'XX-XX-XX XX:XX:XX' OR 'XX-XX-XX XX:XX:XX' >= fsr.`start_date`) AND (fsr.`expiry_date` = 'XX-XX-XX XX:XX:XX' OR 'XX-XX-XX XX:XX:XX' <= fsr.`expiry_date`) )
3	SELECT `sale_nbr` FROM ps_product_sale WHERE `id_product` = XX LIMIT XX
3	SELECT location FROM `ps_stock_available` WHERE (id_product = XX) AND (id_product_attribute = XX) AND (id_shop_group = XX) AND (id_shop = XX) LIMIT XX
3	SELECT SUM(`quantity`) FROM `ps_cart_product` WHERE `id_product` = XX AND `id_cart` = XX LIMIT XX
3	SELECT fsr.* FROM `ps_fmm_stickers_rules` fsr LEFT JOIN `ps_fmm_stickers_rules_shop` fsrs ON (fsr.`fmm_stickers_rules_id` = fsrs.`fmm_stickers_rules_id`) WHERE fsr.`status` = XX AND fsr.`rule_type` = "new" AND fsrs.`id_shop` = XX AND ( (fsr.`start_date` = 'XX-XX-XX XX:XX:XX' OR 'XX-XX-XX XX:XX:XX' >= fsr.`start_date`) AND (fsr.`expiry_date` = 'XX-XX-XX XX:XX:XX' OR 'XX-XX-XX XX:XX:XX' <= fsr.`expiry_date`) )
3	SELECT p.id_product 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) WHERE p.id_product = XX AND DATEDIFF( product_shop.`date_add`, DATE_SUB( "XX-XX-XX XX:XX:XX", INTERVAL XX DAY ) ) > XX
3	SELECT b.*, bl.`title` FROM `ps_fmm_stickersbanners` b LEFT JOIN ps_fmm_stickersbanners_products bp ON (b.stickersbanners_id = bp.stickersbanners_id) LEFT JOIN ps_fmm_stickersbanners_lang bl ON (b.stickersbanners_id = bl.stickersbanners_id) LEFT JOIN ps_fmm_stickersbanners_shop ssh ON (b.stickersbanners_id = ssh.stickersbanners_id) WHERE bp.`id_product` = XX AND `id_lang` = XX AND ssh.id_shop = XX AND ( (b.`start_date` = 'XX-XX-XX XX:XX:XX' OR 'XX-XX-XX XX:XX:XX' >= b.`start_date`) AND (b.`expiry_date` = 'XX-XX-XX XX:XX:XX' OR 'XX-XX-XX XX:XX:XX' <= b.`expiry_date`) ) LIMIT XX
3	SELECT psXX.* FROM `ps_fmm_stickers` psXX LEFT JOIN ps_fmm_stickers_products psXX ON (psXX.sticker_id = psXX.sticker_id) WHERE psXX.`id_product` = XX AND psXX.`listing` > XX AND ( (psXX.`start_date` = 'XX-XX-XX XX:XX:XX' OR 'XX-XX-XX XX:XX:XX' >= psXX.`start_date`) AND (psXX.`expiry_date` = 'XX-XX-XX XX:XX:XX' OR 'XX-XX-XX XX:XX:XX' <= psXX.`expiry_date`) )
3	SELECT depends_on_stock FROM `ps_stock_available` WHERE (id_product = XX) AND (id_product_attribute = XX) AND (id_shop_group = XX) AND (id_shop = XX) LIMIT XX
3	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` IN (XX, XX) AND `id_customer` = 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
3	SELECT `id_category` FROM `ps_category_product` WHERE `id_product` = 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 pac.id_attribute, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales 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_group = XX AND sa.id_shop = XX ) LEFT JOIN ps_product_sale psales ON (psales.id_product = p.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_product cp ON (p.id_product = cp.id_product) 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 IN (XX, XX, XX))) AND ((fp_XX.id_feature_value=XX)) AND ((fp_XX.id_feature_value IN (XX, XX))) AND ps.id_shop='XX' AND p.visibility IN ('both', 'catalog') AND cg.id_group='XX' AND p.id_manufacturer='XX' AND cp.id_category='XX' GROUP BY p.id_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) INNER JOIN ps_attribute a ON (a.id_attribute = pac.id_attribute) 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 ((a.id_attribute_group=XX)) AND ((fp_XX.id_feature_value IN (XX, XX, XX))) AND ((fp_XX.id_feature_value=XX)) AND ((fp_XX.id_feature_value IN (XX, XX))) GROUP BY pac.id_attribute
2	SELECT DISTINCT a.`id_attribute`, a.`color`, al.`name`, agl.`id_attribute_group`, IF(lialv.`url_name` IS NULL OR lialv.`url_name` = "", NULL, lialv.`url_name`) AS url_name, IF(lialv.`meta_title` IS NULL OR lialv.`meta_title` = "", NULL, lialv.`meta_title`) AS meta_title FROM `ps_attribute_group` ag INNER JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = XX) INNER JOIN `ps_attribute` a ON a.`id_attribute_group` = ag.`id_attribute_group` INNER JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = XX) INNER JOIN ps_attribute_group_shop attribute_group_shop ON (attribute_group_shop.id_attribute_group = ag.id_attribute_group AND attribute_group_shop.id_shop = XX) INNER JOIN ps_attribute_shop attribute_shop ON (attribute_shop.id_attribute = a.id_attribute AND attribute_shop.id_shop = XX) LEFT JOIN `ps_layered_indexable_attribute_lang_value` lialv ON (a.`id_attribute` = lialv.`id_attribute` AND lialv.`id_lang` = XX) WHERE ag.id_attribute_group = XX ORDER BY agl.`name` ASC, a.`position` ASC
2	SELECT m.*, ml.`description`, ml.`short_description` FROM `ps_manufacturer` m INNER JOIN ps_manufacturer_shop manufacturer_shop ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = XX)INNER JOIN `ps_manufacturer_lang` ml ON (m.`id_manufacturer` = ml.`id_manufacturer` AND ml.`id_lang` = XX)WHERE XX AND m.`active` = XX ORDER BY m.`name` ASC
2	(SELECT XX FROM `ps_cart_rule` WHERE date_to >= "XX-XX-XX XX:XX:XX" AND date_to <= "XX-XX-XX XX:XX:XX" AND `id_customer` IN (XX,XX) LIMIT XX)UNION ALL (SELECT XX FROM `ps_cart_rule` WHERE date_from >= "XX-XX-XX XX:XX:XX" AND date_from <= "XX-XX-XX XX:XX:XX" AND `id_customer` IN (XX,XX) LIMIT XX)UNION ALL (SELECT XX FROM `ps_cart_rule` WHERE 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) LIMIT XX
2	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
2	SELECT * FROM `ps_hook_alias`

Name	Instances	Source
Rules	47	/modules/productlabelsandstickers/productlabelsandstickers.php [650] /modules/productlabelsandstickers/productlabelsandstickers.php [659] /modules/productlabelsandstickers/productlabelsandstickers.php [678] /modules/productlabelsandstickers/productlabelsandstickers.php [687] /modules/productlabelsandstickers/productlabelsandstickers.php [693] /modules/productlabelsandstickers/productlabelsandstickers.php [710] /modules/productlabelsandstickers/productlabelsandstickers.php [734] /modules/productlabelsandstickers/productlabelsandstickers.php [734] /modules/productlabelsandstickers/productlabelsandstickers.php [734] /modules/productlabelsandstickers/productlabelsandstickers.php [734] /modules/productlabelsandstickers/productlabelsandstickers.php [734] /modules/productlabelsandstickers/productlabelsandstickers.php [734] /modules/productlabelsandstickers/productlabelsandstickers.php [734] /modules/productlabelsandstickers/productlabelsandstickers.php [734] /modules/productlabelsandstickers/productlabelsandstickers.php [734] /modules/productlabelsandstickers/productlabelsandstickers.php [734] /modules/productlabelsandstickers/productlabelsandstickers.php [734] /modules/productlabelsandstickers/productlabelsandstickers.php [650] /modules/productlabelsandstickers/productlabelsandstickers.php [659] /modules/productlabelsandstickers/productlabelsandstickers.php [678] /modules/productlabelsandstickers/productlabelsandstickers.php [687] /modules/productlabelsandstickers/productlabelsandstickers.php [693] /modules/productlabelsandstickers/productlabelsandstickers.php [710] /modules/productlabelsandstickers/productlabelsandstickers.php [734] /modules/productlabelsandstickers/productlabelsandstickers.php [734] /modules/productlabelsandstickers/productlabelsandstickers.php [734] /modules/productlabelsandstickers/productlabelsandstickers.php [734] /modules/productlabelsandstickers/productlabelsandstickers.php [734] /modules/productlabelsandstickers/productlabelsandstickers.php [734] /modules/productlabelsandstickers/productlabelsandstickers.php [734] /modules/productlabelsandstickers/productlabelsandstickers.php [734] /modules/productlabelsandstickers/productlabelsandstickers.php [734] /modules/productlabelsandstickers/productlabelsandstickers.php [650] /modules/productlabelsandstickers/productlabelsandstickers.php [659] /modules/productlabelsandstickers/productlabelsandstickers.php [678] /modules/productlabelsandstickers/productlabelsandstickers.php [687] /modules/productlabelsandstickers/productlabelsandstickers.php [693] /modules/productlabelsandstickers/productlabelsandstickers.php [710] /modules/productlabelsandstickers/productlabelsandstickers.php [734] /modules/productlabelsandstickers/productlabelsandstickers.php [734] /modules/productlabelsandstickers/productlabelsandstickers.php [734] /modules/productlabelsandstickers/productlabelsandstickers.php [734] /modules/productlabelsandstickers/productlabelsandstickers.php [734] /modules/productlabelsandstickers/productlabelsandstickers.php [734] /modules/productlabelsandstickers/productlabelsandstickers.php [734] /modules/productlabelsandstickers/productlabelsandstickers.php [734] /modules/productlabelsandstickers/productlabelsandstickers.php [734]
Category	21	/modules/fsadvancedurl/fsadvancedurl.php [3628] /controllers/front/listing/CategoryController.php [85] /override/classes/Link.php [65] /classes/Meta.php [379] /override/classes/Link.php [65] /override/classes/Link.php [50] /override/classes/Link.php [65] /classes/PrestaShopCollection.php [383] /classes/PrestaShopCollection.php [383] /classes/PrestaShopCollection.php [383] /override/classes/Link.php [65] /override/classes/Link.php [65] /modules/ps_facetedsearch/src/Product/Search.php [324] /modules/cdc_googletagmanager/cdc_googletagmanager.php [1146] /modules/cdc_googletagmanager/classes/gtm/DataLayerProduct.php [111] /modules/cdc_googletagmanager/cdc_googletagmanager.php [1207] /modules/cdc_googletagmanager/cdc_googletagmanager.php [1156] /modules/cdc_googletagmanager/classes/gtm/DataLayerProduct.php [111] /modules/cdc_googletagmanager/cdc_googletagmanager.php [1156] /modules/cdc_googletagmanager/classes/gtm/DataLayerProduct.php [111] /modules/cdc_googletagmanager/cdc_googletagmanager.php [1156]
Product	21	/classes/Link.php [106] /src/Adapter/Image/ImageRetriever.php [63] /classes/Link.php [106] /src/Adapter/Image/ImageRetriever.php [63] /classes/Link.php [106] /src/Adapter/Image/ImageRetriever.php [63] /modules/trustpilot/trustbox.php [104] /modules/trustpilot/trustbox.php [104] /modules/trustpilot/trustbox.php [104] /modules/cdc_googletagmanager/services/Gtm_Product.php [154] /modules/cdc_googletagmanager/services/Gtm_Product.php [154] /modules/cdc_googletagmanager/services/Gtm_Product.php [154] /modules/cdc_googletagmanager/services/Gtm_Product.php [154] /modules/cdc_googletagmanager/services/Gtm_Product.php [154] /modules/cdc_googletagmanager/services/Gtm_Product.php [154] /modules/productlabelsandstickers/productlabelsandstickers.php [651] /classes/Link.php [106] /modules/productlabelsandstickers/productlabelsandstickers.php [651] /classes/Link.php [106] /modules/productlabelsandstickers/productlabelsandstickers.php [651] /classes/Link.php [106]
Address	7	/classes/shop/Shop.php [467] /classes/Product.php [4973] /classes/Product.php [3201] /classes/Product.php [3310] /classes/Product.php [566] /classes/Product.php [566] /classes/Product.php [566]
Combination	6	/classes/Product.php [4951] /classes/Product.php [4951] /classes/Product.php [4951] /modules/cdc_googletagmanager/classes/gtm/DataLayerProduct.php [59] /modules/cdc_googletagmanager/classes/gtm/DataLayerProduct.php [59] /modules/cdc_googletagmanager/classes/gtm/DataLayerProduct.php [59]
Shop	5	/config/config.inc.php [119] /modules/customsettings/customsettings.php [115] /classes/Link.php [1342] /modules/customsettings/customsettings.php [115] /classes/Link.php [1342]
Country	3	/config/config.inc.php [141] /classes/AddressFormat.php [357] /classes/controller/FrontController.php [1623]
Stickers	3	/modules/productlabelsandstickers/productlabelsandstickers.php [649] /modules/productlabelsandstickers/productlabelsandstickers.php [649] /modules/productlabelsandstickers/productlabelsandstickers.php [649]
Currency	2	/src/Adapter/Currency/CurrencyDataProvider.php [101] /classes/Tools.php [700]
Language	2	/config/config.inc.php [194] /classes/Tools.php [579]
Cart	1	/classes/controller/FrontController.php [410]
Group	1	/classes/Cart.php [245]
Gender	1	/classes/controller/FrontController.php [1584]
Customer	1	/config/config.inc.php [220]
AddressFormat	1	/classes/controller/FrontController.php [1617]
State	1	/classes/controller/FrontController.php [1622]
Tax	1	/override/classes/tax/TaxRulesTaxManager.php [119]
ShopGroup	1	/classes/shop/Shop.php [551]
LeftBanner	1	/modules/prcategoryleftbanners/prcategoryleftbanners.php [143]
LeftBannerBottom	1	/modules/prcategoryleftbannersbottom/prcategoryleftbannersbottom.php [143]
Risk	1	/classes/controller/FrontController.php [1587]

Soodushinnaga

Voodipesukomplekt Nala Blue

Voodipesukomplekt Silke Blue Green

Padjapüür Silke Blue Green

Stopwatch SQL - 568 queries

Doubles

Tables stress

ObjectModel instances

Included Files

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`)	8.8	9156			/classes/Configuration.php:160 /classes/Configuration.php:209 /classes/Configuration.php:289 /classes/shop/Shop.php:382 /config/config.inc.php:119 /index.php:27
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 = 3 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` != "paymentOptions") AND (hm.`id_shop` = 3) AND (mg.id_shop = 3 AND mg.`id_group` IN (1)) GROUP BY hm.id_hook, hm.id_module ORDER BY hm.`position`	4.9	80100	Yes	Yes	/classes/Hook.php:670 /classes/Hook.php:775 /classes/Dispatcher.php:593 /override/classes/Dispatcher.php:24 /classes/Dispatcher.php:249 /classes/Dispatcher.php:207 /index.php:28
SELECT SQL_NO_CACHE COUNT(DISTINCT `id_product`) FROM `ps_specific_price` WHERE `id_product` != 0 LIMIT 1	3.5	659			/classes/SpecificPrice.php:283 /classes/SpecificPrice.php:341 /classes/SpecificPrice.php:529 /override/classes/Product.php:83 /override/classes/ProductAssembler.php:67 /override/classes/ProductAssembler.php:82 /classes/controller/ProductListingFrontController.php:54 :undefined /classes/controller/ProductListingFrontController.php:76 /classes/controller/ProductListingFrontController.php:324 /override/controllers/front/listing/CategoryController.php:8 /classes/controller/ProductListingFrontController.php:580 /controllers/front/listing/CategoryController.php:137 /tools/profiling/Controller.php:233 /classes/Dispatcher.php:515 /index.php:28
SELECT SQL_NO_CACHE * FROM `ps_product` a LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 4 LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 3 WHERE (a.`id_product` = 17694) AND (b.`id_shop` = 3) LIMIT 1	3	1			/src/Adapter/EntityMapper.php:75 /classes/ObjectModel.php:264 /tools/profiling/ObjectModel.php:33 /classes/Product.php:551 /override/classes/Product.php:15 /classes/Link.php:106 /classes/Link.php:174 /override/classes/Link.php:110 /classes/Product.php:4763 /override/classes/ProductAssembler.php:87 /classes/controller/ProductListingFrontController.php:54 :undefined /classes/controller/ProductListingFrontController.php:76 /classes/controller/ProductListingFrontController.php:324 /override/controllers/front/listing/CategoryController.php:8 /classes/controller/ProductListingFrontController.php:580 /controllers/front/listing/CategoryController.php:137 /tools/profiling/Controller.php:233 /classes/Dispatcher.php:515 /index.php:28
SELECT SQL_NO_CACHE p.id_manufacturer, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales 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_group = 1 AND sa.id_shop = 0 ) LEFT JOIN ps_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 3 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 IN (1955, 64, 66))) AND ((fp_1.id_feature_value=2101)) AND ((fp_2.id_feature_value IN (2260, 2297))) AND ps.id_shop='3' AND p.visibility IN ('both', 'catalog') AND cg.id_group='1' AND cp.id_category='407' GROUP BY p.id_product) p 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 IN (1955, 64, 66))) AND ((fp_1.id_feature_value=2101)) AND ((fp_2.id_feature_value IN (2260, 2297))) GROUP BY p.id_manufacturer	2.8	465567744	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:86 /modules/ps_facetedsearch/src/Adapter/MySQL.php:772 /modules/ps_facetedsearch/src/Filters/Block.php:557 /modules/ps_facetedsearch/src/Filters/Block.php:142 /modules/ps_facetedsearch/src/Product/SearchProvider.php:200 /classes/controller/ProductListingFrontController.php:307 /override/controllers/front/listing/CategoryController.php:8 /classes/controller/ProductListingFrontController.php:580 /controllers/front/listing/CategoryController.php:137 /tools/profiling/Controller.php:233 /classes/Dispatcher.php:515 /index.php:28
REPLACE INTO ps_layered_filter_block (hash, data) VALUES ("8bd2962c788b7af7bdbada59beacc8db", "a:1:{s:7:\"filters\";a:12:{i:0;a:10:{s:9:\"type_lite\";s:18:\"id_attribute_group\";s:4:\"type\";s:18:\"id_attribute_group\";s:6:\"id_key\";s:3:\"100\";s:4:\"name\";s:14:\"Teki mõõtmed\";s:14:\"is_color_group\";b:0;s:6:\"values\";a:4:{i:3181;a:4:{s:4:\"name\";s:10:\"140x200 cm\";s:3:\"nbr\";s:1:\"2\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:3183;a:4:{s:4:\"name\";s:10:\"200x200 cm\";s:3:\"nbr\";s:1:\"2\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:3184;a:4:{s:4:\"name\";s:10:\"200x220 cm\";s:3:\"nbr\";s:1:\"2\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:3185;a:4:{s:4:\"name\";s:10:\"240x220 cm\";s:3:\"nbr\";s:1:\"1\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}}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:10:{s:9:\"type_lite\";s:18:\"id_attribute_group\";s:4:\"type\";s:18:\"id_attribute_group\";s:6:\"id_key\";s:2:\"99\";s:4:\"name\";s:16:\"Padjad mõõtmed\";s:14:\"is_color_group\";b:0;s:6:\"values\";a:6:{i:3175;a:4:{s:4:\"name\";s:8:\"40x60 cm\";s:3:\"nbr\";s:1:\"2\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:3176;a:4:{s:4:\"name\";s:8:\"50x60 cm\";s:3:\"nbr\";s:1:\"2\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:3174;a:4:{s:4:\"name\";s:8:\"50x70 cm\";s:3:\"nbr\";s:1:\"3\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:3177;a:4:{s:4:\"name\";s:8:\"60x60 cm\";s:3:\"nbr\";s:1:\"1\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:3190;a:4:{s:4:\"name\";s:8:\"60x70 cm\";s:3:\"nbr\";s:1:\"2\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:3179;a:4:{s:4:\"name\";s:8:\"70x70 cm\";s:3:\"nbr\";s:1:\"1\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}}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:2;a:9:{s:9:\"type_lite\";s:10:\"id_feature\";s:4:\"type\";s:10:\"id_feature\";s:6:\"id_key\";s:2:\"58\";s:6:\"values\";a:2:{i:2294;a:4:{s:3:\"nbr\";s:1:\"2\";s:4:\"name\";s:3:\"20%\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:2290;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:3:\"40%\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}}s:4:\"name\";s:18:\"Allahindluse summa\";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:\"25\";s:6:\"values\";a:1:{i:1554;a:4:{s:3:\"nbr\";s:1:\"3\";s:4:\"name\";s:8:\"Satään\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}}s:4:\"name\";s:12:\"Kanga tüüp\";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:\"4\";s:6:\"values\";a:1:{i:16;a:4:{s:3:\"nbr\";s:1:\"3\";s:4:\"name\";s:13:\"100% puuvilla\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}}s:4:\"name\";s:8:\"Materjal\";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:1:\"5\";s:6:\"values\";a:3:{i:59;a:4:{s:3:\"nbr\";s:1:\"2\";s:4:\"name\";s:5:\"Pruun\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:63;a:4:{s:3:\"nbr\";s:1:\"2\";s:4:\"name\";s:8:\"Roheline\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:66;a:5:{s:3:\"nbr\";s:1:\"3\";s:4:\"name\";s:6:\"Sinine\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:7:\"checked\";b:1;}}s:4:\"name\";s:8:\"Värvus:\";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:2:\"20\";s:6:\"values\";a:1:{i:1334;a:4:{s:3:\"nbr\";s:1:\"3\";s:4:\"name\";s:10:\"Mustriline\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}}s:4:\"name\";s:6:\"Disain\";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:7:{s:9:\"type_lite\";s:12:\"manufacturer\";s:4:\"type\";s:12:\"manufacturer\";s:6:\"id_key\";i:0;s:4:\"name\";s:6:\"Bränd\";s:6:\"values\";a:2:{i:191;a:3:{s:4:\"name\";s:12:\"Beddinghouse\";s:3:\"nbr\";s:1:\"3\";s:7:\"checked\";b:1;}i:194;a:2:{s:4:\"name\";s:6:\"Kardol\";s:3:\"nbr\";s:1:\"1\";}}s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";s:1:\"0\";}i:8;a:9:{s:9:\"type_lite\";s:10:\"id_feature\";s:4:\"type\";s:10:\"id_feature\";s:6:\"id_key\";s:2:\"34\";s:6:\"values\";a:1:{i:2101;a:5:{s:3:\"nbr\";s:1:\"3\";s:4:\"name\";s:3:\"220\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:7:\"checked\";b:1;}}s:4:\"name\";s:2:\"TC\";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:9;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:\"Hind\";s:3:\"max\";d:90;s:3:\"min\";d:6;s:4:\"unit\";s:3:\"€\";s:14:\"specifications\";a:10:{s:6:\"symbol\";a:11:{i:0;s:1:\",\";i:1;s:2:\" \";i:2;s:1:\";\";i:3;s:1:\"%\";i:4;s:3:\"−\";i:5;s:1:\"+\";i:6;s:5:\"×10^\";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: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:3;s:5:\"value\";N;}i:10;a:9:{s:9:\"type_lite\";s:10:\"id_feature\";s:4:\"type\";s:10:\"id_feature\";s:6:\"id_key\";s:2:\"52\";s:6:\"values\";a:3:{i:2277;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:18:\"2024 Autumn/Winter\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:2260;a:5:{s:3:\"nbr\";s:1:\"2\";s:4:\"name\";s:18:\"2024 Spring/Summer\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:7:\"checked\";b:1;}i:2297;a:5:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:18:\"2025 Spring/Summer\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:7:\"checked\";b:1;}}s:4:\"name\";s:8:\"Kogumine\";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:11;a:7:{s:9:\"type_lite\";s:12:\"availability\";s:4:\"type\";s:12:\"availability\";s:6:\"id_key\";i:0;s:4:\"name\";s:8:\"Saadavus\";s:6:\"values\";a:3:{i:0;a:2:{s:4:\"name\";s:5:\"Otsas\";s:3:\"nbr\";i:1;}i:1;a:2:{s:4:\"name\";s:9:\"Available\";s:3:\"nbr\";i:3;}i:2;a:2:{s:4:\"name\";s:15:\"Laosolevad enne\";s:3:\"nbr\";i:3;}}s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";s:1:\"0\";}}}")	2.8	1			/modules/ps_facetedsearch/src/Filters/Block.php:207 /modules/ps_facetedsearch/src/Product/SearchProvider.php:202 /classes/controller/ProductListingFrontController.php:307 /override/controllers/front/listing/CategoryController.php:8 /classes/controller/ProductListingFrontController.php:580 /controllers/front/listing/CategoryController.php:137 /tools/profiling/Controller.php:233 /classes/Dispatcher.php:515 /index.php:28
SELECT SQL_NO_CACHE COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales 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_group = 1 AND sa.id_shop = 0 ) LEFT JOIN ps_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 3 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 IN (1955, 64, 66))) AND ((fp_1.id_feature_value=2101)) AND ((fp_2.id_feature_value IN (2260, 2297))) AND ps.id_shop='3' AND p.visibility IN ('both', 'catalog') AND cg.id_group='1' AND p.id_manufacturer='191' AND cp.id_category='407' GROUP BY p.id_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_group = 1 AND sa.id_shop = 0 ) 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 ((sa.out_of_stock IN (1, 2)) OR (sa.quantity>0)) AND ((fp_1.id_feature_value IN (1955, 64, 66))) AND ((fp_2.id_feature_value=2101)) AND ((fp_3.id_feature_value IN (2260, 2297)))	2.7	5586812928			/modules/ps_facetedsearch/src/Adapter/MySQL.php:86 /modules/ps_facetedsearch/src/Adapter/MySQL.php:772 /modules/ps_facetedsearch/src/Adapter/MySQL.php:750 /modules/ps_facetedsearch/src/Filters/Block.php:490 /modules/ps_facetedsearch/src/Filters/Block.php:139 /modules/ps_facetedsearch/src/Product/SearchProvider.php:200 /classes/controller/ProductListingFrontController.php:307 /override/controllers/front/listing/CategoryController.php:8 /classes/controller/ProductListingFrontController.php:580 /controllers/front/listing/CategoryController.php:137 /tools/profiling/Controller.php:233 /classes/Dispatcher.php:515 /index.php:28
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 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_group = 1 AND sa.id_shop = 0 ) LEFT JOIN ps_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 3 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 IN (1955, 64, 66))) AND ((fp_1.id_feature_value=2101)) AND ((fp_2.id_feature_value IN (2260, 2297))) AND ps.id_shop='3' AND p.visibility IN ('both', 'catalog') AND cg.id_group='1' AND p.id_manufacturer='191' AND cp.id_category='407' GROUP BY p.id_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_group = 1 AND sa.id_shop = 0 ) GROUP BY p.id_product ORDER BY p.quantity DESC, p.id_product DESC LIMIT 0, 192	2.3	5455872	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:86 /modules/ps_facetedsearch/src/Filters/Products.php:90 /modules/ps_facetedsearch/src/Product/SearchProvider.php:172 /classes/controller/ProductListingFrontController.php:307 /override/controllers/front/listing/CategoryController.php:8 /classes/controller/ProductListingFrontController.php:580 /controllers/front/listing/CategoryController.php:137 /tools/profiling/Controller.php:233 /classes/Dispatcher.php:515 /index.php:28
SELECT SQL_NO_CACHE pac.id_attribute, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales 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_group = 1 AND sa.id_shop = 0 ) LEFT JOIN ps_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 3 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 IN (1955, 64, 66))) AND ((fp_1.id_feature_value=2101)) AND ((fp_2.id_feature_value IN (2260, 2297))) AND ps.id_shop='3' AND p.visibility IN ('both', 'catalog') AND cg.id_group='1' AND p.id_manufacturer='191' AND cp.id_category='407' GROUP BY p.id_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) INNER JOIN ps_attribute a ON (a.id_attribute = pac.id_attribute) 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 ((a.id_attribute_group=100)) AND ((fp_1.id_feature_value IN (1955, 64, 66))) AND ((fp_2.id_feature_value=2101)) AND ((fp_3.id_feature_value IN (2260, 2297))) GROUP BY pac.id_attribute	2.2	2793406464	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:86 /modules/ps_facetedsearch/src/Adapter/MySQL.php:772 /modules/ps_facetedsearch/src/Filters/Block.php:633 /modules/ps_facetedsearch/src/Filters/Block.php:146 /modules/ps_facetedsearch/src/Product/SearchProvider.php:200 /classes/controller/ProductListingFrontController.php:307 /override/controllers/front/listing/CategoryController.php:8 /classes/controller/ProductListingFrontController.php:580 /controllers/front/listing/CategoryController.php:137 /tools/profiling/Controller.php:233 /classes/Dispatcher.php:515 /index.php:28
SELECT SQL_NO_CACHE COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales 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_group = 1 AND sa.id_shop = 0 ) LEFT JOIN ps_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 3 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 IN (1955, 64, 66))) AND ((fp_1.id_feature_value=2101)) AND ((fp_2.id_feature_value IN (2260, 2297))) AND ps.id_shop='3' AND p.visibility IN ('both', 'catalog') AND cg.id_group='1' AND p.id_manufacturer='191' AND cp.id_category='407' GROUP BY p.id_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_group = 1 AND sa.id_shop = 0 ) 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 ((sa.quantity>0)) AND ((fp_1.id_feature_value IN (1955, 64, 66))) AND ((fp_2.id_feature_value=2101)) AND ((fp_3.id_feature_value IN (2260, 2297)))	2.2	5586812928			/modules/ps_facetedsearch/src/Adapter/MySQL.php:86 /modules/ps_facetedsearch/src/Adapter/MySQL.php:772 /modules/ps_facetedsearch/src/Adapter/MySQL.php:750 /modules/ps_facetedsearch/src/Filters/Block.php:501 /modules/ps_facetedsearch/src/Filters/Block.php:139 /modules/ps_facetedsearch/src/Product/SearchProvider.php:200 /classes/controller/ProductListingFrontController.php:307 /override/controllers/front/listing/CategoryController.php:8 /classes/controller/ProductListingFrontController.php:580 /controllers/front/listing/CategoryController.php:137 /tools/profiling/Controller.php:233 /classes/Dispatcher.php:515 /index.php:28
SELECT SQL_NO_CACHE pac.id_attribute, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales 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_group = 1 AND sa.id_shop = 0 ) LEFT JOIN ps_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 3 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 IN (1955, 64, 66))) AND ((fp_1.id_feature_value=2101)) AND ((fp_2.id_feature_value IN (2260, 2297))) AND ps.id_shop='3' AND p.visibility IN ('both', 'catalog') AND cg.id_group='1' AND p.id_manufacturer='191' AND cp.id_category='407' GROUP BY p.id_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) INNER JOIN ps_attribute a ON (a.id_attribute = pac.id_attribute) 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 ((a.id_attribute_group=99)) AND ((fp_1.id_feature_value IN (1955, 64, 66))) AND ((fp_2.id_feature_value=2101)) AND ((fp_3.id_feature_value IN (2260, 2297))) GROUP BY pac.id_attribute	2.1	2793406464	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:86 /modules/ps_facetedsearch/src/Adapter/MySQL.php:772 /modules/ps_facetedsearch/src/Filters/Block.php:633 /modules/ps_facetedsearch/src/Filters/Block.php:146 /modules/ps_facetedsearch/src/Product/SearchProvider.php:200 /classes/controller/ProductListingFrontController.php:307 /override/controllers/front/listing/CategoryController.php:8 /classes/controller/ProductListingFrontController.php:580 /controllers/front/listing/CategoryController.php:137 /tools/profiling/Controller.php:233 /classes/Dispatcher.php:515 /index.php:28
SELECT SQL_NO_CACHE COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales 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_group = 1 AND sa.id_shop = 0 ) LEFT JOIN ps_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 3 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 IN (1955, 64, 66))) AND ((fp_1.id_feature_value=2101)) AND ((fp_2.id_feature_value IN (2260, 2297))) AND ps.id_shop='3' AND p.visibility IN ('both', 'catalog') AND cg.id_group='1' AND p.id_manufacturer='191' AND cp.id_category='407' GROUP BY p.id_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_group = 1 AND sa.id_shop = 0 ) LEFT JOIN ps_stock_available sa_1 ON (p.id_product = sa_1.id_product AND IFNULL(pac.id_product_attribute, 0) = sa_1.id_product_attribute AND sa_1.id_shop_group = 1 AND sa_1.id_shop = 0 ) 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 ((sa.quantity<=0 AND sa_1.out_of_stock=0)) AND ((fp_1.id_feature_value IN (1955, 64, 66))) AND ((fp_2.id_feature_value=2101)) AND ((fp_3.id_feature_value IN (2260, 2297)))	2.1	11173625856			/modules/ps_facetedsearch/src/Adapter/MySQL.php:86 /modules/ps_facetedsearch/src/Adapter/MySQL.php:772 /modules/ps_facetedsearch/src/Adapter/MySQL.php:750 /modules/ps_facetedsearch/src/Filters/Block.php:476 /modules/ps_facetedsearch/src/Filters/Block.php:139 /modules/ps_facetedsearch/src/Product/SearchProvider.php:200 /classes/controller/ProductListingFrontController.php:307 /override/controllers/front/listing/CategoryController.php:8 /classes/controller/ProductListingFrontController.php:580 /controllers/front/listing/CategoryController.php:137 /tools/profiling/Controller.php:233 /classes/Dispatcher.php:515 /index.php:28
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 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_group = 1 AND sa.id_shop = 0 ) LEFT JOIN ps_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 3 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 IN (1955, 64, 66))) AND ((fp_1.id_feature_value=2101)) AND ((fp_2.id_feature_value IN (2260, 2297))) AND ps.id_shop='3' AND p.visibility IN ('both', 'catalog') AND cg.id_group='1' AND p.id_manufacturer='191' AND cp.id_category='407' 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=54)) AND ((fp_1.id_feature_value IN (1955, 64, 66))) AND ((fp_2.id_feature_value=2101)) AND ((fp_3.id_feature_value IN (2260, 2297))) GROUP BY fp.id_feature_value	1.9	465567744	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:86 /modules/ps_facetedsearch/src/Adapter/MySQL.php:772 /modules/ps_facetedsearch/src/Filters/Block.php:751 /modules/ps_facetedsearch/src/Filters/Block.php:150 /modules/ps_facetedsearch/src/Product/SearchProvider.php:200 /classes/controller/ProductListingFrontController.php:307 /override/controllers/front/listing/CategoryController.php:8 /classes/controller/ProductListingFrontController.php:580 /controllers/front/listing/CategoryController.php:137 /tools/profiling/Controller.php:233 /classes/Dispatcher.php:515 /index.php:28
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 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_group = 1 AND sa.id_shop = 0 ) LEFT JOIN ps_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 3 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 IN (1955, 64, 66))) AND ((fp_1.id_feature_value=2101)) AND ((fp_2.id_feature_value IN (2260, 2297))) AND ps.id_shop='3' AND p.visibility IN ('both', 'catalog') AND cg.id_group='1' AND p.id_manufacturer='191' AND cp.id_category='407' 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=20)) AND ((fp_1.id_feature_value IN (1955, 64, 66))) AND ((fp_2.id_feature_value=2101)) AND ((fp_3.id_feature_value IN (2260, 2297))) GROUP BY fp.id_feature_value	1.9	465567744	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:86 /modules/ps_facetedsearch/src/Adapter/MySQL.php:772 /modules/ps_facetedsearch/src/Filters/Block.php:751 /modules/ps_facetedsearch/src/Filters/Block.php:150 /modules/ps_facetedsearch/src/Product/SearchProvider.php:200 /classes/controller/ProductListingFrontController.php:307 /override/controllers/front/listing/CategoryController.php:8 /classes/controller/ProductListingFrontController.php:580 /controllers/front/listing/CategoryController.php:137 /tools/profiling/Controller.php:233 /classes/Dispatcher.php:515 /index.php:28
SELECT SQL_NO_CACHE COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales 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_group = 1 AND sa.id_shop = 0 ) LEFT JOIN ps_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 3 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 IN (1955, 64, 66))) AND ((fp_1.id_feature_value=2101)) AND ((fp_2.id_feature_value IN (2260, 2297))) AND ps.id_shop='3' AND p.visibility IN ('both', 'catalog') AND cg.id_group='1' AND p.id_manufacturer='191' AND cp.id_category='407' GROUP BY p.id_product) p 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 IN (1955, 64, 66))) AND ((fp_1.id_feature_value=2101)) AND ((fp_2.id_feature_value IN (2260, 2297)))	1.9	465567744			/modules/ps_facetedsearch/src/Adapter/MySQL.php:86 /modules/ps_facetedsearch/src/Adapter/MySQL.php:772 /modules/ps_facetedsearch/src/Adapter/MySQL.php:750 /modules/ps_facetedsearch/src/Filters/Products.php:94 /modules/ps_facetedsearch/src/Product/SearchProvider.php:172 /classes/controller/ProductListingFrontController.php:307 /override/controllers/front/listing/CategoryController.php:8 /classes/controller/ProductListingFrontController.php:580 /controllers/front/listing/CategoryController.php:137 /tools/profiling/Controller.php:233 /classes/Dispatcher.php:515 /index.php:28
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 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_group = 1 AND sa.id_shop = 0 ) LEFT JOIN ps_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 3 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 IN (1955, 64, 66))) AND ((fp_1.id_feature_value=2101)) AND ((fp_2.id_feature_value IN (2260, 2297))) AND ps.id_shop='3' AND p.visibility IN ('both', 'catalog') AND cg.id_group='1' AND p.id_manufacturer='191' AND cp.id_category='407' 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=25)) AND ((fp_1.id_feature_value IN (1955, 64, 66))) AND ((fp_2.id_feature_value=2101)) AND ((fp_3.id_feature_value IN (2260, 2297))) GROUP BY fp.id_feature_value	1.9	465567744	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:86 /modules/ps_facetedsearch/src/Adapter/MySQL.php:772 /modules/ps_facetedsearch/src/Filters/Block.php:751 /modules/ps_facetedsearch/src/Filters/Block.php:150 /modules/ps_facetedsearch/src/Product/SearchProvider.php:200 /classes/controller/ProductListingFrontController.php:307 /override/controllers/front/listing/CategoryController.php:8 /classes/controller/ProductListingFrontController.php:580 /controllers/front/listing/CategoryController.php:137 /tools/profiling/Controller.php:233 /classes/Dispatcher.php:515 /index.php:28
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 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_group = 1 AND sa.id_shop = 0 ) LEFT JOIN ps_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 3 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) WHERE ((fp.id_feature_value=2101)) AND ((fp_1.id_feature_value IN (2260, 2297))) AND ps.id_shop='3' AND p.visibility IN ('both', 'catalog') AND cg.id_group='1' AND p.id_manufacturer='191' AND cp.id_category='407' 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=5)) AND ((fp_1.id_feature_value=2101)) AND ((fp_2.id_feature_value IN (2260, 2297))) GROUP BY fp.id_feature_value	1.9	7274496	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:86 /modules/ps_facetedsearch/src/Adapter/MySQL.php:772 /modules/ps_facetedsearch/src/Filters/Block.php:751 /modules/ps_facetedsearch/src/Filters/Block.php:150 /modules/ps_facetedsearch/src/Product/SearchProvider.php:200 /classes/controller/ProductListingFrontController.php:307 /override/controllers/front/listing/CategoryController.php:8 /classes/controller/ProductListingFrontController.php:580 /controllers/front/listing/CategoryController.php:137 /tools/profiling/Controller.php:233 /classes/Dispatcher.php:515 /index.php:28
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 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_group = 1 AND sa.id_shop = 0 ) LEFT JOIN ps_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 3 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 IN (1955, 64, 66))) AND ((fp_1.id_feature_value=2101)) AND ((fp_2.id_feature_value IN (2260, 2297))) AND ps.id_shop='3' AND p.visibility IN ('both', 'catalog') AND cg.id_group='1' AND p.id_manufacturer='191' AND cp.id_category='407' 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=58)) AND ((fp_1.id_feature_value IN (1955, 64, 66))) AND ((fp_2.id_feature_value=2101)) AND ((fp_3.id_feature_value IN (2260, 2297))) GROUP BY fp.id_feature_value	1.9	465567744	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:86 /modules/ps_facetedsearch/src/Adapter/MySQL.php:772 /modules/ps_facetedsearch/src/Filters/Block.php:751 /modules/ps_facetedsearch/src/Filters/Block.php:150 /modules/ps_facetedsearch/src/Product/SearchProvider.php:200 /classes/controller/ProductListingFrontController.php:307 /override/controllers/front/listing/CategoryController.php:8 /classes/controller/ProductListingFrontController.php:580 /controllers/front/listing/CategoryController.php:137 /tools/profiling/Controller.php:233 /classes/Dispatcher.php:515 /index.php:28
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 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_group = 1 AND sa.id_shop = 0 ) LEFT JOIN ps_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 3 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 IN (1955, 64, 66))) AND ((fp_1.id_feature_value=2101)) AND ((fp_2.id_feature_value IN (2260, 2297))) AND ps.id_shop='3' AND p.visibility IN ('both', 'catalog') AND cg.id_group='1' AND p.id_manufacturer='191' AND cp.id_category='407' 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 IN (1955, 64, 66))) AND ((fp_2.id_feature_value=2101)) AND ((fp_3.id_feature_value IN (2260, 2297))) GROUP BY fp.id_feature_value	1.8	465567744	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:86 /modules/ps_facetedsearch/src/Adapter/MySQL.php:772 /modules/ps_facetedsearch/src/Filters/Block.php:751 /modules/ps_facetedsearch/src/Filters/Block.php:150 /modules/ps_facetedsearch/src/Product/SearchProvider.php:200 /classes/controller/ProductListingFrontController.php:307 /override/controllers/front/listing/CategoryController.php:8 /classes/controller/ProductListingFrontController.php:580 /controllers/front/listing/CategoryController.php:137 /tools/profiling/Controller.php:233 /classes/Dispatcher.php:515 /index.php:28
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, active FROM `ps_hook_module` hm STRAIGHT_JOIN `ps_hook` h ON (h.id_hook = hm.id_hook AND hm.id_shop = 3) STRAIGHT_JOIN `ps_module` as m ON (m.id_module = hm.id_module) ORDER BY hm.position	1.7	563			/classes/Hook.php:407 /classes/Hook.php:449 /classes/tax/TaxManagerFactory.php:67 /classes/tax/TaxManagerFactory.php:46 /classes/Product.php:4980 /override/classes/Product.php:25 /override/classes/ProductAssembler.php:67 /override/classes/ProductAssembler.php:82 /classes/controller/ProductListingFrontController.php:54 :undefined /classes/controller/ProductListingFrontController.php:76 /classes/controller/ProductListingFrontController.php:324 /override/controllers/front/listing/CategoryController.php:8 /classes/controller/ProductListingFrontController.php:580 /controllers/front/listing/CategoryController.php:137 /tools/profiling/Controller.php:233 /classes/Dispatcher.php:515 /index.php:28
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 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_group = 1 AND sa.id_shop = 0 ) LEFT JOIN ps_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 3 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) WHERE ((fp.id_feature_value IN (1955, 64, 66))) AND ((fp_1.id_feature_value IN (2260, 2297))) AND ps.id_shop='3' AND p.visibility IN ('both', 'catalog') AND cg.id_group='1' AND p.id_manufacturer='191' AND cp.id_category='407' 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=34)) AND ((fp_1.id_feature_value IN (1955, 64, 66))) AND ((fp_2.id_feature_value IN (2260, 2297))) GROUP BY fp.id_feature_value	1.6	7274496	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:86 /modules/ps_facetedsearch/src/Adapter/MySQL.php:772 /modules/ps_facetedsearch/src/Filters/Block.php:751 /modules/ps_facetedsearch/src/Filters/Block.php:150 /modules/ps_facetedsearch/src/Product/SearchProvider.php:200 /classes/controller/ProductListingFrontController.php:307 /override/controllers/front/listing/CategoryController.php:8 /classes/controller/ProductListingFrontController.php:580 /controllers/front/listing/CategoryController.php:137 /tools/profiling/Controller.php:233 /classes/Dispatcher.php:515 /index.php:28
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 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_group = 1 AND sa.id_shop = 0 ) LEFT JOIN ps_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 3 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) WHERE ((fp.id_feature_value IN (1955, 64, 66))) AND ((fp_1.id_feature_value=2101)) AND ps.id_shop='3' AND p.visibility IN ('both', 'catalog') AND cg.id_group='1' AND p.id_manufacturer='191' AND cp.id_category='407' 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=52)) AND ((fp_1.id_feature_value IN (1955, 64, 66))) AND ((fp_2.id_feature_value=2101)) GROUP BY fp.id_feature_value	1.6	7274496	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:86 /modules/ps_facetedsearch/src/Adapter/MySQL.php:772 /modules/ps_facetedsearch/src/Filters/Block.php:751 /modules/ps_facetedsearch/src/Filters/Block.php:150 /modules/ps_facetedsearch/src/Product/SearchProvider.php:200 /classes/controller/ProductListingFrontController.php:307 /override/controllers/front/listing/CategoryController.php:8 /classes/controller/ProductListingFrontController.php:580 /controllers/front/listing/CategoryController.php:137 /tools/profiling/Controller.php:233 /classes/Dispatcher.php:515 /index.php:28
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	1.2	0			/classes/Hook.php:194 /classes/Hook.php:787 /classes/Dispatcher.php:593 /override/classes/Dispatcher.php:24 /classes/Dispatcher.php:249 /classes/Dispatcher.php:207 /index.php:28
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 = 3 AND psi.id_currency = 1 AND psi.id_country = 86) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 3 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 IN (1955, 64, 66))) AND ((fp_1.id_feature_value=2101)) AND ((fp_2.id_feature_value IN (2260, 2297))) AND ps.id_shop='3' AND p.visibility IN ('both', 'catalog') AND cg.id_group='1' AND p.id_manufacturer='191' AND cp.id_category='407'	1.2	75776			/modules/ps_facetedsearch/src/Adapter/MySQL.php:86 /modules/ps_facetedsearch/src/Adapter/MySQL.php:58 /modules/ps_facetedsearch/src/Filters/Block.php:246 /modules/ps_facetedsearch/src/Filters/Block.php:130 /modules/ps_facetedsearch/src/Product/SearchProvider.php:200 /classes/controller/ProductListingFrontController.php:307 /override/controllers/front/listing/CategoryController.php:8 /classes/controller/ProductListingFrontController.php:580 /controllers/front/listing/CategoryController.php:137 /tools/profiling/Controller.php:233 /classes/Dispatcher.php:515 /index.php:28
SELECT SQL_NO_CACHE pa., product_attribute_shop., ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, al.`name` AS attribute_name, a.`id_attribute` 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 = 3) LEFT JOIN `ps_product_attribute_combination` pac ON pac.`id_product_attribute` = pa.`id_product_attribute` LEFT JOIN `ps_attribute` a ON a.`id_attribute` = pac.`id_attribute` LEFT JOIN `ps_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group` LEFT JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 4) LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 4) WHERE pa.`id_product` = 17648 ORDER BY pa.`id_product_attribute`	1.1	16	Yes		/override/classes/Product.php:37 /override/classes/ProductAssembler.php:67 /override/classes/ProductAssembler.php:82 /classes/controller/ProductListingFrontController.php:54 :undefined /classes/controller/ProductListingFrontController.php:76 /classes/controller/ProductListingFrontController.php:324 /override/controllers/front/listing/CategoryController.php:8 /classes/controller/ProductListingFrontController.php:580 /controllers/front/listing/CategoryController.php:137 /tools/profiling/Controller.php:233 /classes/Dispatcher.php:515 /index.php:28
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) + IF (`id_country` = 86, 4, 0) + IF (`id_currency` = 1, 8, 0) + IF (`id_shop` = 3, 16, 0) + IF (`id_customer` = 0, 32, 0)) AS `score` FROM `ps_specific_price` WHERE `id_shop` IN (0, 3) AND `id_currency` IN (0, 1) AND `id_country` IN (0, 86) AND `id_group` IN (0, 1) AND `id_product` IN (0, 17648) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0 AND (`from` = '0000-00-00 00:00:00' OR '2025-11-28 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2025-11-28 00:00:00' <= `to`) AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1	1	4	Yes		/classes/SpecificPrice.php:557 /override/classes/Product.php:83 /override/classes/ProductAssembler.php:67 /override/classes/ProductAssembler.php:82 /classes/controller/ProductListingFrontController.php:54 :undefined /classes/controller/ProductListingFrontController.php:76 /classes/controller/ProductListingFrontController.php:324 /override/controllers/front/listing/CategoryController.php:8 /classes/controller/ProductListingFrontController.php:580 /controllers/front/listing/CategoryController.php:137 /tools/profiling/Controller.php:233 /classes/Dispatcher.php:515 /index.php:28
SELECT SQL_NO_CACHE pa., product_attribute_shop., ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, al.`name` AS attribute_name, a.`id_attribute` 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 = 3) LEFT JOIN `ps_product_attribute_combination` pac ON pac.`id_product_attribute` = pa.`id_product_attribute` LEFT JOIN `ps_attribute` a ON a.`id_attribute` = pac.`id_attribute` LEFT JOIN `ps_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group` LEFT JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 4) LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 4) WHERE pa.`id_product` = 17648 GROUP BY pa.`id_product_attribute`,ag.`id_attribute_group` ORDER BY pa.`id_product_attribute`	0.9	16	Yes	Yes	/classes/Product.php:2397 /modules/trustpilot/trustbox.php:109 /modules/trustpilot/trustbox.php:40 /modules/trustpilot/trustpilot.php:443 /classes/Hook.php:970 /classes/Hook.php:355 /classes/Hook.php:907 /classes/controller/ProductListingFrontController.php:389 /override/controllers/front/listing/CategoryController.php:8 /classes/controller/ProductListingFrontController.php:580 /controllers/front/listing/CategoryController.php:137 /tools/profiling/Controller.php:233 /classes/Dispatcher.php:515 /index.php:28
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 = 'www.haldjakodu.ee' OR su.domain_ssl = 'www.haldjakodu.ee') AND s.active = 1 AND s.deleted = 0 ORDER BY LENGTH(CONCAT(su.physical_uri, su.virtual_uri)) DESC	0.8	6	Yes		/classes/shop/Shop.php:345 /config/config.inc.php:119 /index.php:27
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) + IF (`id_country` = 86, 4, 0) + IF (`id_currency` = 1, 8, 0) + IF (`id_shop` = 3, 16, 0) + IF (`id_customer` = 0, 32, 0)) AS `score` FROM `ps_specific_price` WHERE `id_shop` IN (0, 3) AND `id_currency` IN (0, 1) AND `id_country` IN (0, 86) AND `id_group` IN (0, 1) AND `id_product` IN (0, 17648) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0 AND (`from` = '0000-00-00 00:00:00' OR '2025-11-28 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2025-11-28 00:00:00' <= `to`) AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1	0.7	4	Yes		/classes/SpecificPrice.php:557 /override/classes/Product.php:83 /override/classes/ProductAssembler.php:67 /override/classes/ProductAssembler.php:82 /classes/controller/ProductListingFrontController.php:54 :undefined /classes/controller/ProductListingFrontController.php:76 /classes/controller/ProductListingFrontController.php:324 /override/controllers/front/listing/CategoryController.php:8 /classes/controller/ProductListingFrontController.php:580 /controllers/front/listing/CategoryController.php:137 /tools/profiling/Controller.php:233 /classes/Dispatcher.php:515 /index.php:28
SELECT SQL_NO_CACHE pa., product_attribute_shop., ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, al.`name` AS attribute_name, a.`id_attribute` 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 = 3) LEFT JOIN `ps_product_attribute_combination` pac ON pac.`id_product_attribute` = pa.`id_product_attribute` LEFT JOIN `ps_attribute` a ON a.`id_attribute` = pac.`id_attribute` LEFT JOIN `ps_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group` LEFT JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 4) LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 4) WHERE pa.`id_product` = 17694 GROUP BY pa.`id_product_attribute`,ag.`id_attribute_group` ORDER BY pa.`id_product_attribute`	0.7	12	Yes	Yes	/classes/Product.php:2397 /modules/trustpilot/trustbox.php:109 /modules/trustpilot/trustbox.php:40 /modules/trustpilot/trustpilot.php:443 /classes/Hook.php:970 /classes/Hook.php:355 /classes/Hook.php:907 /classes/controller/ProductListingFrontController.php:389 /override/controllers/front/listing/CategoryController.php:8 /classes/controller/ProductListingFrontController.php:580 /controllers/front/listing/CategoryController.php:137 /tools/profiling/Controller.php:233 /classes/Dispatcher.php:515 /index.php:28
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) + IF (`id_country` = 86, 4, 0) + IF (`id_currency` = 1, 8, 0) + IF (`id_shop` = 3, 16, 0) + IF (`id_customer` = 0, 32, 0)) AS `score` FROM `ps_specific_price` WHERE `id_shop` IN (0, 3) AND `id_currency` IN (0, 1) AND `id_country` IN (0, 86) AND `id_group` IN (0, 1) AND `id_product` IN (0, 17648) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0 AND (`from` = '0000-00-00 00:00:00' OR '2025-11-28 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2025-11-28 00:00:00' <= `to`) AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1	0.7	4	Yes		/classes/SpecificPrice.php:557 /override/classes/Product.php:83 /override/classes/ProductAssembler.php:67 /override/classes/ProductAssembler.php:82 /classes/controller/ProductListingFrontController.php:54 :undefined /classes/controller/ProductListingFrontController.php:76 /classes/controller/ProductListingFrontController.php:324 /override/controllers/front/listing/CategoryController.php:8 /classes/controller/ProductListingFrontController.php:580 /controllers/front/listing/CategoryController.php:137 /tools/profiling/Controller.php:233 /classes/Dispatcher.php:515 /index.php:28
SELECT SQL_NO_CACHE DISTINCT f.id_feature, f., fl., IF(liflv.`url_name` IS NULL OR liflv.`url_name` = "", NULL, liflv.`url_name`) AS url_name, IF(liflv.`meta_title` IS NULL OR liflv.`meta_title` = "", NULL, liflv.`meta_title`) AS meta_title, lif.indexable FROM `ps_feature` f INNER JOIN ps_feature_shop feature_shop ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 3) LEFT JOIN `ps_feature_lang` fl ON (f.`id_feature` = fl.`id_feature` AND fl.`id_lang` = 4) LEFT JOIN `ps_layered_indexable_feature` lif ON (f.`id_feature` = lif.`id_feature`) LEFT JOIN `ps_layered_indexable_feature_lang_value` liflv ON (f.`id_feature` = liflv.`id_feature` AND liflv.`id_lang` = 4) ORDER BY f.`position` ASC	0.7	34	Yes		/modules/ps_facetedsearch/src/Filters/DataAccessor.php:171 /modules/ps_facetedsearch/src/Filters/Converter.php:359 /modules/ps_facetedsearch/src/Product/SearchProvider.php:155 /classes/controller/ProductListingFrontController.php:307 /override/controllers/front/listing/CategoryController.php:8 /classes/controller/ProductListingFrontController.php:580 /controllers/front/listing/CategoryController.php:137 /tools/profiling/Controller.php:233 /classes/Dispatcher.php:515 /index.php:28
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) + IF (`id_country` = 86, 4, 0) + IF (`id_currency` = 1, 8, 0) + IF (`id_shop` = 3, 16, 0) + IF (`id_customer` = 0, 32, 0)) AS `score` FROM `ps_specific_price` WHERE `id_shop` IN (0, 3) AND `id_currency` IN (0, 1) AND `id_country` IN (0, 86) AND `id_group` IN (0, 1) AND `id_product` IN (0, 17648) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0 AND (`from` = '0000-00-00 00:00:00' OR '2025-11-28 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2025-11-28 00:00:00' <= `to`) AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1	0.7	4	Yes		/classes/SpecificPrice.php:557 /override/classes/Product.php:83 /override/classes/ProductAssembler.php:67 /override/classes/ProductAssembler.php:82 /classes/controller/ProductListingFrontController.php:54 :undefined /classes/controller/ProductListingFrontController.php:76 /classes/controller/ProductListingFrontController.php:324 /override/controllers/front/listing/CategoryController.php:8 /classes/controller/ProductListingFrontController.php:580 /controllers/front/listing/CategoryController.php:137 /tools/profiling/Controller.php:233 /classes/Dispatcher.php:515 /index.php:28
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 = 3 ) ORDER BY LENGTH(ml.url_rewrite) DESC	0.7	235	Yes		/classes/Dispatcher.php:640 /override/classes/Dispatcher.php:24 /classes/Dispatcher.php:249 /classes/Dispatcher.php:207 /index.php:28
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` = 4) LEFT JOIN `ps_layered_indexable_feature_value_lang_value` lifvlv ON (v.`id_feature_value` = lifvlv.`id_feature_value` AND lifvlv.`id_lang` = 4) WHERE v.`id_feature` = 4 ORDER BY vl.`value` ASC	0.6	64	Yes		/modules/ps_facetedsearch/src/Filters/DataAccessor.php:204 /modules/ps_facetedsearch/src/Filters/Block.php:760 /modules/ps_facetedsearch/src/Filters/Block.php:150 /modules/ps_facetedsearch/src/Product/SearchProvider.php:200 /classes/controller/ProductListingFrontController.php:307 /override/controllers/front/listing/CategoryController.php:8 /classes/controller/ProductListingFrontController.php:580 /controllers/front/listing/CategoryController.php:137 /tools/profiling/Controller.php:233 /classes/Dispatcher.php:515 /index.php:28
SELECT SQL_NO_CACHE pa., product_attribute_shop., ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, al.`name` AS attribute_name, a.`id_attribute` 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 = 3) LEFT JOIN `ps_product_attribute_combination` pac ON pac.`id_product_attribute` = pa.`id_product_attribute` LEFT JOIN `ps_attribute` a ON a.`id_attribute` = pac.`id_attribute` LEFT JOIN `ps_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group` LEFT JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 4) LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 4) WHERE pa.`id_product` = 17694 ORDER BY pa.`id_product_attribute`	0.6	12	Yes		/override/classes/Product.php:37 /override/classes/ProductAssembler.php:67 /override/classes/ProductAssembler.php:82 /classes/controller/ProductListingFrontController.php:54 :undefined /classes/controller/ProductListingFrontController.php:76 /classes/controller/ProductListingFrontController.php:324 /override/controllers/front/listing/CategoryController.php:8 /classes/controller/ProductListingFrontController.php:580 /controllers/front/listing/CategoryController.php:137 /tools/profiling/Controller.php:233 /classes/Dispatcher.php:515 /index.php:28
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) + IF (`id_country` = 86, 4, 0) + IF (`id_currency` = 1, 8, 0) + IF (`id_shop` = 3, 16, 0) + IF (`id_customer` = 0, 32, 0)) AS `score` FROM `ps_specific_price` WHERE `id_shop` IN (0, 3) AND `id_currency` IN (0, 1) AND `id_country` IN (0, 86) AND `id_group` IN (0, 1) AND `id_product` IN (0, 17791) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0 AND (`from` = '0000-00-00 00:00:00' OR '2025-11-28 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2025-11-28 00:00:00' <= `to`) AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1	0.6	8	Yes		/classes/SpecificPrice.php:557 /override/classes/Product.php:83 /override/classes/ProductAssembler.php:67 /override/classes/ProductAssembler.php:82 /classes/controller/ProductListingFrontController.php:54 :undefined /classes/controller/ProductListingFrontController.php:76 /classes/controller/ProductListingFrontController.php:324 /override/controllers/front/listing/CategoryController.php:8 /classes/controller/ProductListingFrontController.php:580 /controllers/front/listing/CategoryController.php:137 /tools/profiling/Controller.php:233 /classes/Dispatcher.php:515 /index.php:28
(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` = 4) WHERE cr.`id_customer` = 0 AND NOW() BETWEEN cr.date_from AND cr.date_to AND cr.`active` = 1 AND cr.`quantity` > 0 AND highlight = 1 AND code NOT LIKE "BO_ORDER_%") UNION (SELECT * 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` = 4) WHERE cr.`group_restriction` = 1 AND NOW() BETWEEN cr.date_from AND cr.date_to AND cr.`active` = 1 AND cr.`quantity` > 0 AND highlight = 1 AND code NOT LIKE "BO_ORDER_%")	0.6	1			/classes/CartRule.php:401 /classes/CartRule.php:512 /classes/Cart.php:508 /src/Adapter/Presenter/Cart/CartPresenter.php:439 /modules/ps_shoppingcart/ps_shoppingcart.php:84 /modules/ps_shoppingcart/ps_shoppingcart.php:96 /classes/Hook.php:975 /classes/Hook.php:927 /config/smarty.config.inc.php:163 /classes/Smarty/SmartyLazyRegister.php:83 /var/cache/prod/smarty/compile/layouts_layout_left_column_tpl/32/24/ed/3224edc9f2f76d90ed1a41b4b2564444599f2481_2.file.header.tpl.php:28 /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:216 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:385 /var/cache/prod/smarty/compile/layouts_layout_left_column_tpl/c2/33/4d/c2334dfe3a8d5bf19cd520f8a0b0f58c9d7c6bf3_2.file.layout-both-columns.tpl.php:334 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 /var/cache/prod/smarty/compile/layouts_layout_left_column_tpl/c2/33/4d/c2334dfe3a8d5bf19cd520f8a0b0f58c9d7c6bf3_2.file.layout-both-columns.tpl.php:133 /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:216 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:385 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 /var/cache/prod/smarty/compile/layouts_layout_left_column_tpl/48/df/cf/48dfcf1d4635656103adea909c003933c96b45aa_2.file.layout-left-column.tpl.php:38 /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:216 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:385 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 /var/cache/prod/smarty/compile/layouts_layout_left_column_tpl/10/14/53/10145383f11b9821d1288908adcc5ae8c4048485_2.file.product-list.tpl.php:37 /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:216 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:385 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 /var/cache/prod/smarty/compile/layouts_layout_left_column_tpl/eb/11/27/eb1127a89f60b404e810874562e00a42e094c2b9_2.file.category.tpl.php:34 /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:216 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:232 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 /classes/controller/FrontController.php:683 /override/classes/controller/FrontController.php:76 /tools/profiling/Controller.php:716 /tools/profiling/Controller.php:255 /classes/Dispatcher.php:515 /index.php:28
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) + IF (`id_country` = 86, 4, 0) + IF (`id_currency` = 1, 8, 0) + IF (`id_shop` = 3, 16, 0) + IF (`id_customer` = 0, 32, 0)) AS `score` FROM `ps_specific_price` WHERE `id_shop` IN (0, 3) AND `id_currency` IN (0, 1) AND `id_country` IN (0, 86) AND `id_group` IN (0, 1) AND `id_product` IN (0, 17791) AND `id_customer` = 0 AND `id_cart` = 0 AND (`from` = '0000-00-00 00:00:00' OR '2025-11-28 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2025-11-28 00:00:00' <= `to`) AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1	0.6	8	Yes		/classes/SpecificPrice.php:557 /classes/Product.php:3543 /modules/productlabelsandstickers/productlabelsandstickers.php:660 /modules/productlabelsandstickers/productlabelsandstickers.php:514 /classes/Hook.php:970 /classes/Hook.php:355 /classes/Hook.php:907 /config/smarty.config.inc.php:163 /classes/Smarty/SmartyLazyRegister.php:83 /var/cache/prod/smarty/compile/layouts_layout_left_column_tpl/65/6b/4d/656b4d0997ebf7339624a9aad7d1b1df6655be95_2.file.product-vertical.tpl.php:28 /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:383 /var/cache/prod/smarty/compile/layouts_layout_left_column_tpl/3b/1b/b0/3b1bb0b14055b06e5a73d958482e81094fc9a191_2.file.product.tpl.php:57 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 /var/cache/prod/smarty/compile/layouts_layout_left_column_tpl/3b/1b/b0/3b1bb0b14055b06e5a73d958482e81094fc9a191_2.file.product.tpl.php:30 /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:383 /var/cache/prod/smarty/compile/layouts_layout_left_column_tpl/75/4a/c1/754ac1d2bd8e03b4b011dd66c8b845745074ed81_2.file.productlist.tpl.php:125 /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:216 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:385 /var/cache/prod/smarty/compile/layouts_layout_left_column_tpl/3b/f6/c8/3bf6c88b8be046c38e07a3da3cfbafe84c512446_2.file.products.tpl.php:25 /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:216 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:385 /var/cache/prod/smarty/compile/layouts_layout_left_column_tpl/10/14/53/10145383f11b9821d1288908adcc5ae8c4048485_2.file.product-list.tpl.php:83 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 /var/cache/prod/smarty/compile/layouts_layout_left_column_tpl/10/14/53/10145383f11b9821d1288908adcc5ae8c4048485_2.file.product-list.tpl.php:175 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:186 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 /var/cache/prod/smarty/compile/layouts_layout_left_column_tpl/48/df/cf/48dfcf1d4635656103adea909c003933c96b45aa_2.file.layout-left-column.tpl.php:88 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:186 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 /var/cache/prod/smarty/compile/layouts_layout_left_column_tpl/c2/33/4d/c2334dfe3a8d5bf19cd520f8a0b0f58c9d7c6bf3_2.file.layout-both-columns.tpl.php:190 /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:216 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:385 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 /var/cache/prod/smarty/compile/layouts_layout_left_column_tpl/48/df/cf/48dfcf1d4635656103adea909c003933c96b45aa_2.file.layout-left-column.tpl.php:38 /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:216 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:385 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 /var/cache/prod/smarty/compile/layouts_layout_left_column_tpl/10/14/53/10145383f11b9821d1288908adcc5ae8c4048485_2.file.product-list.tpl.php:37 /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:216 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:385 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 /var/cache/prod/smarty/compile/layouts_layout_left_column_tpl/eb/11/27/eb1127a89f60b404e810874562e00a42e094c2b9_2.file.category.tpl.php:34 /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:216 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:232 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 /classes/controller/FrontController.php:683 /override/classes/controller/FrontController.php:76 /tools/profiling/Controller.php:716 /tools/profiling/Controller.php:255 /classes/Dispatcher.php:515 /index.php:28
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) + IF (`id_country` = 86, 4, 0) + IF (`id_currency` = 1, 8, 0) + IF (`id_shop` = 3, 16, 0) + IF (`id_customer` = 0, 32, 0)) AS `score` FROM `ps_specific_price` WHERE `id_shop` IN (0, 3) AND `id_currency` IN (0, 1) AND `id_country` IN (0, 86) AND `id_group` IN (0, 1) AND `id_product` IN (0, 17694) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0 AND (`from` = '0000-00-00 00:00:00' OR '2025-11-28 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2025-11-28 00:00:00' <= `to`) AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1	0.6	8	Yes		/classes/SpecificPrice.php:557 /override/classes/Product.php:83 /override/classes/ProductAssembler.php:67 /override/classes/ProductAssembler.php:82 /classes/controller/ProductListingFrontController.php:54 :undefined /classes/controller/ProductListingFrontController.php:76 /classes/controller/ProductListingFrontController.php:324 /override/controllers/front/listing/CategoryController.php:8 /classes/controller/ProductListingFrontController.php:580 /controllers/front/listing/CategoryController.php:137 /tools/profiling/Controller.php:233 /classes/Dispatcher.php:515 /index.php:28

#	Filename
1	/index.php
2	/config/config.inc.php
3	/config/defines.inc.php
4	/config/autoload.php
5	/vendor/autoload.php
6	/vendor/composer/autoload_real.php
7	/vendor/composer/ClassLoader.php
8	/vendor/composer/include_paths.php
9	/vendor/composer/autoload_static.php
10	/vendor/symfony/polyfill-ctype/bootstrap.php
11	/vendor/react/promise/src/functions_include.php
12	/vendor/react/promise/src/functions.php
13	/vendor/swiftmailer/swiftmailer/lib/swift_required.php
14	/vendor/swiftmailer/swiftmailer/lib/classes/Swift.php
15	/vendor/paragonie/random_compat/lib/random.php
16	/vendor/symfony/polyfill-php70/bootstrap.php
17	/vendor/symfony/polyfill-php56/bootstrap.php
18	/vendor/symfony/polyfill-mbstring/bootstrap.php
19	/vendor/symfony/polyfill-intl-icu/bootstrap.php
20	/vendor/symfony/polyfill-apcu/bootstrap.php
21	/vendor/markbaker/matrix/classes/src/functions/adjoint.php
22	/vendor/markbaker/matrix/classes/src/functions/antidiagonal.php
23	/vendor/markbaker/matrix/classes/src/functions/cofactors.php
24	/vendor/markbaker/matrix/classes/src/functions/determinant.php
25	/vendor/markbaker/matrix/classes/src/functions/diagonal.php
26	/vendor/markbaker/matrix/classes/src/functions/identity.php
27	/vendor/markbaker/matrix/classes/src/functions/inverse.php
28	/vendor/markbaker/matrix/classes/src/functions/minors.php
29	/vendor/markbaker/matrix/classes/src/functions/trace.php
30	/vendor/markbaker/matrix/classes/src/functions/transpose.php
31	/vendor/markbaker/matrix/classes/src/operations/add.php
32	/vendor/markbaker/matrix/classes/src/operations/directsum.php
33	/vendor/markbaker/matrix/classes/src/operations/subtract.php
34	/vendor/markbaker/matrix/classes/src/operations/multiply.php
35	/vendor/markbaker/matrix/classes/src/operations/divideby.php
36	/vendor/markbaker/matrix/classes/src/operations/divideinto.php
37	/vendor/markbaker/complex/classes/src/functions/abs.php
38	/vendor/markbaker/complex/classes/src/functions/acos.php
39	/vendor/markbaker/complex/classes/src/functions/acosh.php
40	/vendor/markbaker/complex/classes/src/functions/acot.php