Home

Brother TZe-415 compatible label tape

lei16.78

Brother TZe-415 compatible laminated label tape, 6 mm wide, white print on red background for Brother P-Touch thermal printers

Brother TZe-425 compatible laminated label tape

Brother TZe-425 compatible label tape

lei16.54

Brother TZe-425 compatible laminated label tape, width 9 mm for Brother P-Touch printers, white printing on red background

Caseta Band Labels Compatible Brother TZe-435

Brother TZe-435 Compatible Label Tape

lei17.85

Brother TZe-435 compatible label tape cassette, 12 mm wide, white print on red background for Brother P-Touch printers

Brother TZe-515 compatible label tape

lei17.00

Compatible laminated label tape TZe-515, 6 mm width, white print on blue background for Brother P-Touch thermal printers

Brother TZe-535 compatible label tape

lei16.00

Laminated label tape compatible with Brother TZe-535, 12 mm width, white print on blue background for Brother P-Touch printers

Brother TZe-545 compatible label tape

lei25.00

Compatible Brother TZe-545 laminated tape, 18 mm width for Brother P-Touch printers, white print on blue background

Compatible Brother TZe-445 Label tape

lei26.00

Compatible Brother TZe-445 laminated tape, 18 mm width for Brother P-Touch printers, white print on red background

Compatible Brother TZe-725 label tape

lei17.85

Compatible Brother TZe-725 laminated label tape, 9 mm width, white print on green background for Brother P-Touch printers

Compatible Brother TZe-735 label tape

lei15.00

Compatible Brother TZe-735 laminated label tape, 12 mm width, white print on green background for Brother P-Touch printers

Compatible Brother TZe-745 label tape

lei25.00

Laminate label tape cassette compatible with TZe-745, 18 mm width, white print on green background for Brother P-Touch printers

New
Out-of-Stock

Brother TZe-525 compatible label tape

lei17.85

Laminated label tape compatible with Brother TZe-525, width 9 mm, white print on blue background for Brother P-Touch thermal printers

New
Out-of-Stock

Brother TZe-715 compatible label tape

lei17.85

Load Time	366.247 ms
Querying Time	156 ms
Queries	418
Memory Peak Usage	17.8 Mb
Included Files	944 files - 12.75 Mb
PrestaShop Cache	0.01 Mb
Global vars	0.43 Mb
- global $_MODULES	312k
- global $context	101k
- global $_SERVER	6k
- global $__composer_autoload_files	5k
- global $config	5k
- global $exportPhpConfigFile	3k
- global $legacyContainer	1k

PrestaShop Version	8.1.7
PHP Version	7.4.26
MySQL Version	5.7.35
Memory Limit	512M
Max Execution Time	600s
Smarty Cache	disabled
Smarty Compilation	force compile

	Time	Cumulated Time	Memory Usage	Memory Peak Usage
config	0.002 ms	0.002 ms	3.23 Mb	3.5 Mb
__construct	2.253 ms	2.255 ms	0.08 Mb	3.9 Mb
init	46.584 ms	48.839 ms	1.85 Mb	5.2 Mb
checkAccess	0.001 ms	48.840 ms	- Mb	5.2 Mb
setMedia	1.879 ms	50.719 ms	0.11 Mb	5.3 Mb
postProcess	0.001 ms	50.720 ms	- Mb	5.3 Mb
initHeader	0.001 ms	50.721 ms	- Mb	5.3 Mb
initContent	169.722 ms	220.443 ms	5.77 Mb	11.2 Mb
initFooter	0.002 ms	220.445 ms	- Mb	11.2 Mb
display	145.802 ms	366.247 ms	6.46 Mb	17.8 Mb

Hook	Time	Memory Usage
DisplayVerticalmenu	23.113 ms	1.11 Mb
=> mt_verticalmenu	23.113 ms	1.11 Mb
displayLeftColumn	20.282 ms	1.17 Mb
=> mt_banner (widget)	1.239 ms	- Mb
=> ps_bestsellers (widget)	16.518 ms	1.24 Mb
=> mt_testimonials (widget)	2.525 ms	0.06 Mb
displayNav2	12.883 ms	0.38 Mb
=> ps_mainmenu (widget)	3.142 ms	0.11 Mb
=> nrtsearchbar (widget)	9.741 ms	0.27 Mb
displayNav3	11.959 ms	0.43 Mb
=> ps_currencyselector (widget)	3.687 ms	0.20 Mb
=> ps_languageselector (widget)	3.396 ms	0.08 Mb
=> ps_customersignin (widget)	2.664 ms	0.08 Mb
=> ps_shoppingcart (widget)	2.212 ms	0.06 Mb
displayFooter	8.506 ms	1.49 Mb
=> ps_linklist (widget)	8.506 ms	1.49 Mb
DisplayHeader	6.926 ms	0.09 Mb
=> mt_dealoftheday	0.261 ms	- Mb
=> mt_themesettings	1.285 ms	0.01 Mb
=> ps_shoppingcart	0.092 ms	- Mb
=> ph_recommendbycategories	0.006 ms	- Mb
=> ps_searchbar	0.658 ms	- Mb
=> freega4	3.913 ms	0.07 Mb
=> supercheckout	0.567 ms	- Mb
=> securitypro	0.139 ms	- Mb
=> facebookproductsfeed	0.005 ms	- Mb
DisplayFooter	6.672 ms	0.12 Mb
=> blockwishlist	6.664 ms	0.12 Mb
=> freega4	0.005 ms	- Mb
=> securitypro	0.003 ms	- Mb
displayNav	1.866 ms	0.10 Mb
=> mt_headertext (widget)	1.866 ms	0.10 Mb
Header	1.354 ms	0.01 Mb
=> mt_verticalmenu	0.578 ms	- Mb
=> mt_newsletterpopup	0.003 ms	- Mb
=> nrtsearchbar	0.397 ms	- Mb
=> codfee	0.376 ms	- Mb
ActionDispatcher	1.244 ms	- Mb
=> securitypro	1.244 ms	- Mb
displayFooterBefore	1.214 ms	0.06 Mb
=> mt_footerhtml (widget)	1.214 ms	0.06 Mb
displayFooterAfter	1.168 ms	0.06 Mb
=> mt_socialfollow (widget)	1.168 ms	0.06 Mb
displayFooterPayment	1.158 ms	0.06 Mb
=> mt_footerpayment (widget)	1.158 ms	0.06 Mb
DisplayLeftColumn	0.907 ms	0.05 Mb
=> ps_facetedsearch	0.907 ms	0.05 Mb
ProductSearchProvider	0.846 ms	0.01 Mb
=> ps_facetedsearch	0.839 ms	0.01 Mb
=> nrtsearchbar	0.007 ms	- Mb
ActionFrontControllerSetMedia	0.668 ms	0.01 Mb
=> blockwishlist	0.668 ms	0.01 Mb
DisplayContentWrapperTop	0.005 ms	- Mb
=> supercheckout	0.005 ms	- Mb
17 hook(s)	100.770 ms	5.14 Mb

Module	Time	Memory Usage
securitypro	6.587 ms	0.30 Mb
__construct	5.196 ms	0.30 Mb
hookActionDispatcher	1.247 ms	0.01 Mb
hookDisplayHeader	0.140 ms	- Mb
hookDisplayFooter	0.004 ms	- Mb
blockwishlist	7.623 ms	0.14 Mb
__construct	0.288 ms	0.02 Mb
hookActionFrontControllerSetMedia	0.670 ms	0.01 Mb
hookDisplayFooter	6.665 ms	0.12 Mb
mt_dealoftheday	0.642 ms	0.03 Mb
__construct	0.379 ms	0.03 Mb
hookDisplayHeader	0.263 ms	- Mb
mt_themesettings	1.525 ms	0.02 Mb
__construct	0.238 ms	0.02 Mb
hookDisplayHeader	1.287 ms	0.01 Mb
ps_shoppingcart	2.413 ms	0.08 Mb
__construct	0.106 ms	0.02 Mb
hookDisplayHeader	0.094 ms	- Mb
displayNav3	2.213 ms	0.06 Mb
ph_recommendbycategories	0.297 ms	0.09 Mb
__construct	0.290 ms	0.09 Mb
hookDisplayHeader	0.007 ms	- Mb
mt_testimonials	2.797 ms	0.10 Mb
__construct	0.271 ms	0.04 Mb
displayLeftColumn	2.526 ms	0.06 Mb
ps_searchbar	0.788 ms	0.02 Mb
__construct	0.129 ms	0.02 Mb
hookDisplayHeader	0.659 ms	- Mb
freega4	4.242 ms	0.09 Mb
__construct	0.320 ms	0.02 Mb
hookDisplayHeader	3.916 ms	0.07 Mb
hookDisplayFooter	0.006 ms	- Mb
supercheckout	1.169 ms	0.18 Mb
__construct	0.594 ms	0.17 Mb
hookDisplayHeader	0.569 ms	- Mb
hookDisplayContentWrapperTop	0.006 ms	- Mb
facebookproductsfeed	0.886 ms	0.03 Mb
__construct	0.879 ms	0.03 Mb
hookDisplayHeader	0.007 ms	- Mb
mt_verticalmenu	24.081 ms	1.19 Mb
__construct	0.387 ms	0.07 Mb
hookHeader	0.580 ms	- Mb
hookDisplayVerticalmenu	23.114 ms	1.11 Mb
mt_newsletterpopup	0.271 ms	0.02 Mb
__construct	0.266 ms	0.02 Mb
hookHeader	0.005 ms	- Mb
nrtsearchbar	10.650 ms	0.38 Mb
__construct	0.501 ms	0.10 Mb
hookHeader	0.399 ms	- Mb
hookProductSearchProvider	0.008 ms	- Mb
displayNav2	9.742 ms	0.27 Mb
codfee	0.931 ms	0.11 Mb
__construct	0.553 ms	0.10 Mb
hookHeader	0.378 ms	- Mb
ps_facetedsearch	2.828 ms	0.10 Mb
__construct	1.080 ms	0.05 Mb
hookProductSearchProvider	0.840 ms	0.01 Mb
hookDisplayLeftColumn	0.908 ms	0.05 Mb
mt_headertext	2.117 ms	0.12 Mb
__construct	0.249 ms	0.02 Mb
displayNav	1.868 ms	0.10 Mb
ps_currencyselector	3.753 ms	0.22 Mb
__construct	0.065 ms	0.02 Mb
displayNav3	3.688 ms	0.20 Mb
ps_languageselector	3.462 ms	0.10 Mb
__construct	0.065 ms	0.02 Mb
displayNav3	3.397 ms	0.08 Mb
ps_customersignin	2.727 ms	0.10 Mb
__construct	0.062 ms	0.02 Mb
displayNav3	2.665 ms	0.08 Mb
ps_mainmenu	3.249 ms	0.13 Mb
__construct	0.106 ms	0.03 Mb
displayNav2	3.143 ms	0.11 Mb
mt_banner	1.382 ms	- Mb
__construct	0.141 ms	0.02 Mb
displayLeftColumn	1.241 ms	- Mb
ps_bestsellers	16.586 ms	1.26 Mb
__construct	0.066 ms	0.02 Mb
displayLeftColumn	16.520 ms	1.24 Mb
mt_footerhtml	1.390 ms	0.09 Mb
__construct	0.175 ms	0.02 Mb
displayFooterBefore	1.215 ms	0.06 Mb
mt_socialfollow	1.321 ms	0.09 Mb
__construct	0.152 ms	0.02 Mb
displayFooterAfter	1.169 ms	0.07 Mb
ps_linklist	8.860 ms	1.52 Mb
__construct	0.352 ms	0.03 Mb
displayFooter	8.508 ms	1.49 Mb
mt_footerpayment	1.322 ms	0.09 Mb
__construct	0.162 ms	0.02 Mb
displayFooterPayment	1.160 ms	0.06 Mb
27 module(s)	113.900 ms	6.48 Mb

25 queries	SELECT * FROM `ps_category` a LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = XX LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = XX WHERE (a.`id_category` = XX) AND (b.`id_shop` = XX) LIMIT XX
20 queries	SELECT c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop` FROM `ps_category` c LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = XX ) INNER JOIN ps_category_shop category_shop ON (category_shop.id_category = c.id_category AND category_shop.id_shop = XX) WHERE `id_lang` = XX AND c.`id_parent` = XX AND `active` = XX GROUP BY c.`id_category` ORDER BY category_shop.`position` ASC
15 queries	SELECT pa.`id_product`, a.`color`, pac.`id_product_attribute`, XX qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by FROM `ps_product_attribute` pa INNER JOIN ps_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = XX) JOIN `ps_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`) JOIN `ps_attribute` a ON (a.`id_attribute` = pac.`id_attribute`) JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = XX) JOIN `ps_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`) WHERE pa.`id_product` IN (XX) AND ag.`is_color_group` = XX GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` ORDER BY a.`position` ASC;
15 queries	SELECT `id_module` FROM `ps_module_shop` WHERE `id_module` = XX AND `id_shop` = XX LIMIT XX
15 queries	SELECT `id_product_attribute` FROM `ps_product_attribute` WHERE `id_product` = XX
15 queries	SELECT image_shop.`cover`, i.`id_image`, il.`legend`, i.`position` FROM `ps_image` i INNER JOIN ps_image_shop image_shop ON (image_shop.id_image = i.id_image AND image_shop.id_shop = XX) LEFT JOIN `ps_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = XX) WHERE i.`id_product` = XX ORDER BY `position`
14 queries	SELECT name, value, pf.id_feature, f.position, fvl.id_feature_value FROM ps_feature_product pf LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = XX) LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = XX) LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = XX) INNER JOIN ps_feature_shop feature_shop ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = XX) WHERE pf.id_product = XX ORDER BY f.position ASC
14 queries	SELECT COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), XX) as deep_quantity, COALESCE(SUM(first_level_quantity), XX) as quantity FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, XX as pack_quantity FROM `ps_cart_product` cp WHERE cp.`id_product_attribute` = XX AND cp.`id_cart` = XX AND cp.`id_product` = XX UNION SELECT XX as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity FROM `ps_cart_product` cp JOIN `ps_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `ps_product` pr ON p.`id_product_pack` = pr.`id_product` WHERE cp.`id_product_attribute` = XX AND cp.`id_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
14 queries	SELECT * FROM `ps_product` a LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = XX LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = XX WHERE (a.`id_product` = XX) AND (b.`id_shop` = XX) LIMIT XX
14 queries	SELECT `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = XX AND `id_group` = XX LIMIT XX
14 queries	SELECT `id_tax_rules_group` FROM `ps_product_shop` WHERE `id_product` = XX AND id_shop=XX LIMIT XX
14 queries	SELECT product_shop.`price`, product_shop.`ecotax`, IFNULL(product_attribute_shop.id_product_attribute,XX) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on, product_attribute_shop.`ecotax` AS attribute_ecotax FROM `ps_product` p INNER JOIN `ps_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = XX) LEFT JOIN `ps_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = XX) WHERE (p.`id_product` = XX)
14 queries	SELECT image_shop.`id_image` FROM `ps_image` i INNER JOIN ps_image_shop image_shop ON (image_shop.id_image = i.id_image AND image_shop.id_shop = XX) WHERE i.`id_product` = XX AND image_shop.`cover` = XX LIMIT XX
14 queries	SELECT name FROM ps_category_lang WHERE id_shop = XX AND id_lang = XX AND id_category = XX LIMIT XX
14 queries	SELECT SUM(quantity) FROM `ps_stock_available` WHERE (id_product = XX) AND (id_product_attribute = XX) AND (id_shop = XX) AND (id_shop_group = XX) LIMIT XX
10 queries	SELECT * FROM `ps_cms` a LEFT JOIN `ps_cms_shop` `c` ON a.`id_cms` = c.`id_cms` AND c.`id_shop` = XX WHERE (a.`id_cms` = XX) LIMIT XX
10 queries	SELECT * FROM `ps_cms_lang` WHERE `id_cms` = XX AND `id_shop` = XX
8 queries	SELECT v., vl., IF(lifvlv.`url_name` IS NULL OR lifvlv.`url_name` = "", NULL, lifvlv.`url_name`) AS url_name, IF(lifvlv.`meta_title` IS NULL OR lifvlv.`meta_title` = "", NULL, lifvlv.`meta_title`) AS meta_title FROM `ps_feature_value` v LEFT JOIN `ps_feature_value_lang` vl ON (v.`id_feature_value` = vl.`id_feature_value` AND vl.`id_lang` = XX) LEFT JOIN `ps_layered_indexable_feature_value_lang_value` lifvlv ON (v.`id_feature_value` = lifvlv.`id_feature_value` AND lifvlv.`id_lang` = XX) WHERE v.`id_feature` = XX ORDER BY vl.`value` ASC
8 queries	SELECT fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, pl.name FROM ps_product p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, XX) = sa.id_product_attribute AND sa.id_shop = XX AND sa.id_shop_group = XX ) LEFT JOIN ps_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps_product_lang pl ON (p.id_product = pl.id_product AND pl.id_shop = XX AND pl.id_lang = XX) 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) WHERE ((fp.id_feature_value IN (XX, XX, XX))) AND ps.id_shop='XX' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='XX' AND c.nleft>=XX AND c.nright<=XX GROUP BY p.id_product) p INNER JOIN ps_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN ps_feature_product fp_XX ON (p.id_product = fp_XX.id_product) WHERE ((fp.id_feature=XX)) AND ((fp_XX.id_feature_value IN (XX, XX, XX))) GROUP BY fp.id_feature_value
6 queries	SELECT `id_lang` FROM `ps_lang` WHERE `locale` = 'en-us' OR `language_code` = 'en-us' LIMIT XX
4 queries	SELECT * FROM `ps_link_block` a LEFT JOIN `ps_link_block_shop` `c` ON a.`id_link_block` = c.`id_link_block` AND c.`id_shop` = XX WHERE (a.`id_link_block` = XX) LIMIT XX
4 queries	SELECT * FROM `ps_link_block_lang` WHERE `id_link_block` = XX
3 queries	SELECT * FROM `ps_currency_lang` WHERE `id_currency` = XX
3 queries	SELECT DISTINCT a.`id_attribute`, a.`color`, al.`name`, agl.`id_attribute_group`, IF(lialv.`url_name` IS NULL OR lialv.`url_name` = "", NULL, lialv.`url_name`) AS url_name, IF(lialv.`meta_title` IS NULL OR lialv.`meta_title` = "", NULL, lialv.`meta_title`) AS meta_title FROM `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
3 queries	SELECT p., ps., 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_product_attribute = XX AND sa.id_shop = XX LEFT JOIN ps_product_shop ps ON ps.id_product = p.id_product AND ps.id_shop = XX WHERE p.id_product IN (XX)
3 queries	SELECT pac.id_attribute, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, pl.name FROM ps_product p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, XX) = sa.id_product_attribute AND sa.id_shop = XX AND sa.id_shop_group = XX ) LEFT JOIN ps_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps_product_lang pl ON (p.id_product = pl.id_product AND pl.id_shop = XX AND pl.id_lang = XX) 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) WHERE ((fp.id_feature_value IN (XX, XX, XX))) AND ps.id_shop='XX' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='XX' AND c.nleft>=XX AND c.nright<=XX GROUP BY p.id_product) p 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) WHERE ((a.id_attribute_group=XX)) AND ((fp_XX.id_feature_value IN (XX, XX, XX))) GROUP BY pac.id_attribute
3 queries	SELECT * FROM `ps_currency` a LEFT JOIN `ps_currency_lang` `b` ON a.`id_currency` = b.`id_currency` AND b.`id_lang` = XX LEFT JOIN `ps_currency_shop` `c` ON a.`id_currency` = c.`id_currency` AND c.`id_shop` = XX WHERE (a.`id_currency` = XX) LIMIT XX
3 queries	SELECT tr.* FROM `ps_tax_rule` tr JOIN `ps_tax_rules_group` trg ON (tr.`id_tax_rules_group` = trg.`id_tax_rules_group`) WHERE trg.`active` = XX AND tr.`id_country` = XX AND tr.`id_tax_rules_group` = XX AND tr.`id_state` IN (XX, XX) AND ('XX ' BETWEEN tr.`zipcode_from` AND tr.`zipcode_to` OR (tr.`zipcode_to` = XX AND tr.`zipcode_from` IN(XX, 'XX '))) ORDER BY tr.`zipcode_from` DESC, tr.`zipcode_to` DESC, tr.`id_state` DESC, tr.`id_country` DESC
3 queries	SELECT * FROM `ps_currency` a LEFT JOIN `ps_currency_shop` `c` ON a.`id_currency` = c.`id_currency` AND c.`id_shop` = XX WHERE (a.`id_currency` = XX) LIMIT XX
2 queries	SELECT XX FROM `ps_cart_rule` WHERE ((date_to >= "XX-XX-XX XX:XX:XX" AND date_to <= "XX-XX-XX XX:XX:XX") OR (date_from >= "XX-XX-XX XX:XX:XX" AND date_from <= "XX-XX-XX XX:XX:XX") OR (date_from < "XX-XX-XX XX:XX:XX" AND date_to > "XX-XX-XX XX:XX:XX")) AND `id_customer` IN (XX,XX) LIMIT XX
2 queries	SELECT * FROM `ps_tax_lang` WHERE `id_tax` = XX
2 queries	SELECT * FROM `ps_tax` a WHERE (a.`id_tax` = XX) LIMIT XX
2 queries	SELECT * FROM `ps_country` a LEFT JOIN `ps_country_lang` `b` ON a.`id_country` = b.`id_country` AND b.`id_lang` = XX LEFT JOIN `ps_country_shop` `c` ON a.`id_country` = c.`id_country` AND c.`id_shop` = XX WHERE (a.`id_country` = XX) LIMIT XX
2 queries	SELECT * FROM `ps_lang` a LEFT JOIN `ps_lang_shop` `c` ON a.`id_lang` = c.`id_lang` AND c.`id_shop` = XX WHERE (a.`id_lang` = XX) LIMIT XX
2 queries	SELECT id_shop FROM `ps_lang_shop` WHERE `id_lang` = XX AND id_shop = XX LIMIT XX
2 queries	SELECT `name` FROM `ps_manufacturer` WHERE `id_manufacturer` = XX AND `active` = XX LIMIT XX
2 queries	SELECT `id_category` FROM `ps_category_shop` WHERE `id_category` = XX AND `id_shop` = XX LIMIT XX
2 queries	SELECT tr.* FROM `ps_tax_rule` tr JOIN `ps_tax_rules_group` trg ON (tr.`id_tax_rules_group` = trg.`id_tax_rules_group`) WHERE trg.`active` = XX AND tr.`id_country` = XX AND tr.`id_tax_rules_group` = XX AND tr.`id_state` IN (XX, XX) AND ('XX' BETWEEN tr.`zipcode_from` AND tr.`zipcode_to` OR (tr.`zipcode_to` = XX AND tr.`zipcode_from` IN(XX, 'XX'))) ORDER BY tr.`zipcode_from` DESC, tr.`zipcode_to` DESC, tr.`id_state` DESC, tr.`id_country` DESC

Name	Instances	Source
Category	86	/controllers/front/listing/CategoryController.php:78 (__construct) [id: 2] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 1207] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 1208] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 1212] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 1209] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 1228] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 1211] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 1210] /classes/Meta.php:380 (__construct) [id: 2] /classes/Link.php:402 (__construct) [id: 2] /classes/Link.php:402 (__construct) [id: 2] /classes/Link.php:402 (__construct) [id: 2] /classes/PrestaShopCollection.php:385 (hydrateCollection) [id: ] /modules/ps_facetedsearch/src/Product/Search.php:364 (__construct) [id: 2] /modules/ps_facetedsearch/src/Filters/Block.php:157 (__construct) [id: 2] /classes/Link.php:402 (__construct) [id: 2] /classes/Link.php:402 (__construct) [id: 2] /classes/Link.php:402 (__construct) [id: 2] /classes/Link.php:402 (__construct) [id: 2] /classes/Link.php:402 (__construct) [id: 2] /classes/Link.php:402 (__construct) [id: 2] /classes/Link.php:402 (__construct) [id: 2] /classes/Link.php:402 (__construct) [id: 2] /classes/Link.php:402 (__construct) [id: 2] /classes/Link.php:402 (__construct) [id: 1207] /modules/mt_verticalmenu/mt_verticalmenu.php:836 (__construct) [id: 1207] /modules/mt_verticalmenu/mt_verticalmenu.php:794 (__construct) [id: 1207] /modules/mt_verticalmenu/mt_verticalmenu.php:1151 (__construct) [id: 1207] /modules/mt_verticalmenu/mt_verticalmenu.php:1162 (__construct) [id: 1213] /modules/mt_verticalmenu/mt_verticalmenu.php:1151 (__construct) [id: 1213] /modules/mt_verticalmenu/mt_verticalmenu.php:1162 (__construct) [id: 1214] /modules/mt_verticalmenu/mt_verticalmenu.php:1151 (__construct) [id: 1214] /modules/mt_verticalmenu/mt_verticalmenu.php:1162 (__construct) [id: 1215] /modules/mt_verticalmenu/mt_verticalmenu.php:1151 (__construct) [id: 1215] /modules/mt_verticalmenu/mt_verticalmenu.php:1162 (__construct) [id: 1216] /modules/mt_verticalmenu/mt_verticalmenu.php:1151 (__construct) [id: 1216] /classes/Link.php:402 (__construct) [id: 1208] /modules/mt_verticalmenu/mt_verticalmenu.php:836 (__construct) [id: 1208] /modules/mt_verticalmenu/mt_verticalmenu.php:794 (__construct) [id: 1208] /modules/mt_verticalmenu/mt_verticalmenu.php:1151 (__construct) [id: 1208] /modules/mt_verticalmenu/mt_verticalmenu.php:1162 (__construct) [id: 1226] /modules/mt_verticalmenu/mt_verticalmenu.php:1151 (__construct) [id: 1226] /modules/mt_verticalmenu/mt_verticalmenu.php:1162 (__construct) [id: 1227] /modules/mt_verticalmenu/mt_verticalmenu.php:1151 (__construct) [id: 1227] /classes/Link.php:402 (__construct) [id: 1212] /modules/mt_verticalmenu/mt_verticalmenu.php:836 (__construct) [id: 1212] /modules/mt_verticalmenu/mt_verticalmenu.php:794 (__construct) [id: 1212] /modules/mt_verticalmenu/mt_verticalmenu.php:1151 (__construct) [id: 1212] /modules/mt_verticalmenu/mt_verticalmenu.php:1162 (__construct) [id: 1224] /modules/mt_verticalmenu/mt_verticalmenu.php:1151 (__construct) [id: 1224] /modules/mt_verticalmenu/mt_verticalmenu.php:1162 (__construct) [id: 1223] /modules/mt_verticalmenu/mt_verticalmenu.php:1151 (__construct) [id: 1223] /modules/mt_verticalmenu/mt_verticalmenu.php:1162 (__construct) [id: 1225] /modules/mt_verticalmenu/mt_verticalmenu.php:1151 (__construct) [id: 1225] /classes/Link.php:402 (__construct) [id: 1209] /modules/mt_verticalmenu/mt_verticalmenu.php:836 (__construct) [id: 1209] /modules/mt_verticalmenu/mt_verticalmenu.php:794 (__construct) [id: 1209] /modules/mt_verticalmenu/mt_verticalmenu.php:1151 (__construct) [id: 1209] /modules/mt_verticalmenu/mt_verticalmenu.php:1162 (__construct) [id: 1217] /modules/mt_verticalmenu/mt_verticalmenu.php:1151 (__construct) [id: 1217] /modules/mt_verticalmenu/mt_verticalmenu.php:1162 (__construct) [id: 1220] /modules/mt_verticalmenu/mt_verticalmenu.php:1151 (__construct) [id: 1220] /modules/mt_verticalmenu/mt_verticalmenu.php:1162 (__construct) [id: 1218] /modules/mt_verticalmenu/mt_verticalmenu.php:1151 (__construct) [id: 1218] /modules/mt_verticalmenu/mt_verticalmenu.php:1162 (__construct) [id: 1219] /modules/mt_verticalmenu/mt_verticalmenu.php:1151 (__construct) [id: 1219] /classes/Link.php:402 (__construct) [id: 1228] /modules/mt_verticalmenu/mt_verticalmenu.php:836 (__construct) [id: 1228] /classes/Link.php:402 (__construct) [id: 1211] /modules/mt_verticalmenu/mt_verticalmenu.php:836 (__construct) [id: 1211] /classes/Link.php:402 (__construct) [id: 1210] /modules/mt_verticalmenu/mt_verticalmenu.php:836 (__construct) [id: 1210] /modules/mt_verticalmenu/mt_verticalmenu.php:794 (__construct) [id: 1210] /modules/mt_verticalmenu/mt_verticalmenu.php:1151 (__construct) [id: 1210] /modules/mt_verticalmenu/mt_verticalmenu.php:1162 (__construct) [id: 1221] /modules/mt_verticalmenu/mt_verticalmenu.php:1151 (__construct) [id: 1221] /modules/mt_verticalmenu/mt_verticalmenu.php:1162 (__construct) [id: 1222] /modules/mt_verticalmenu/mt_verticalmenu.php:1151 (__construct) [id: 1222] /modules/nrtsearchbar/nrtsearchbar.php:387 (__construct) [id: 2] /classes/Link.php:402 (__construct) [id: 1207] /classes/Link.php:402 (__construct) [id: 1208] /classes/Link.php:402 (__construct) [id: 1212] /classes/Link.php:402 (__construct) [id: 1209] /classes/Link.php:402 (__construct) [id: 1228] /classes/Link.php:402 (__construct) [id: 1211] /classes/Link.php:402 (__construct) [id: 1210]
Product	44	/classes/Link.php:113 (__construct) [id: 182] /classes/Link.php:113 (__construct) [id: 98] /classes/Link.php:113 (__construct) [id: 119] /classes/Link.php:113 (__construct) [id: 181] /classes/Link.php:113 (__construct) [id: 118] /classes/Link.php:113 (__construct) [id: 93] /classes/Link.php:113 (__construct) [id: 99] /classes/Link.php:113 (__construct) [id: 144] /classes/Link.php:113 (__construct) [id: 117] /classes/Link.php:113 (__construct) [id: 142] /classes/Link.php:113 (__construct) [id: 175] /classes/Link.php:113 (__construct) [id: 176] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 182] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 98] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 119] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 181] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 118] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 93] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 99] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 144] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 117] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 142] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 175] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 176] /classes/Link.php:113 (__construct) [id: 211] /classes/Link.php:113 (__construct) [id: 178] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 211] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 98] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 178] /classes/Link.php:113 (__construct) [id: 211] /classes/Link.php:113 (__construct) [id: 98] /classes/Link.php:113 (__construct) [id: 178] /classes/Link.php:113 (__construct) [id: 182] /classes/Link.php:113 (__construct) [id: 98] /classes/Link.php:113 (__construct) [id: 119] /classes/Link.php:113 (__construct) [id: 181] /classes/Link.php:113 (__construct) [id: 118] /classes/Link.php:113 (__construct) [id: 93] /classes/Link.php:113 (__construct) [id: 99] /classes/Link.php:113 (__construct) [id: 144] /classes/Link.php:113 (__construct) [id: 117] /classes/Link.php:113 (__construct) [id: 142] /classes/Link.php:113 (__construct) [id: 175] /classes/Link.php:113 (__construct) [id: 176]
CMS	11	/modules/ps_linklist/src/Presenter/LinkBlockPresenter.php:138 (__construct) [id: 0] /modules/ps_linklist/src/Presenter/LinkBlockPresenter.php:138 (__construct) [id: 33] /modules/ps_linklist/src/Presenter/LinkBlockPresenter.php:138 (__construct) [id: 34] /modules/ps_linklist/src/Presenter/LinkBlockPresenter.php:138 (__construct) [id: 35] /modules/ps_linklist/src/Presenter/LinkBlockPresenter.php:138 (__construct) [id: 36] /modules/ps_linklist/src/Presenter/LinkBlockPresenter.php:138 (__construct) [id: 37] /modules/ps_linklist/src/Presenter/LinkBlockPresenter.php:138 (__construct) [id: 27] /modules/ps_linklist/src/Presenter/LinkBlockPresenter.php:138 (__construct) [id: 28] /modules/ps_linklist/src/Presenter/LinkBlockPresenter.php:138 (__construct) [id: 29] /modules/ps_linklist/src/Presenter/LinkBlockPresenter.php:138 (__construct) [id: 32] /modules/ps_linklist/src/Presenter/LinkBlockPresenter.php:138 (__construct) [id: 30]
Currency	6	/src/Adapter/Currency/CurrencyDataProvider.php:101 (__construct) [id: 2] /src/Adapter/Currency/CurrencyDataProvider.php:101 (__construct) [id: 3] /src/Adapter/Currency/CurrencyDataProvider.php:101 (__construct) [id: 1] /classes/Tools.php:695 (getCurrencyInstance) [id: 1] /modules/ps_currencyselector/ps_currencyselector.php:112 (getCurrencies) [id: 2] /modules/ps_currencyselector/ps_currencyselector.php:112 (getCurrencies) [id: 3]
Language	5	/config/config.inc.php:211 (__construct) [id: 2] /classes/Tools.php:641 (__construct) [id: 1] /classes/Tools.php:560 (__construct) [id: 1] /modules/facebookproductsfeed/facebookproductsfeed.php:2099 (__construct) [id: 2] /modules/facebookproductsfeed/facebookproductsfeed.php:2103 (__construct) [id: 2]
Hook	4	/modules/ps_linklist/src/Presenter/LinkBlockPresenter.php:64 (__construct) [id: 42] /modules/ps_linklist/src/Presenter/LinkBlockPresenter.php:64 (__construct) [id: 42] /modules/ps_linklist/src/Presenter/LinkBlockPresenter.php:64 (__construct) [id: 42] /modules/ps_linklist/src/Presenter/LinkBlockPresenter.php:64 (__construct) [id: 42]
PrestaShop\Module\LinkList\Model\LinkBlock	4	/modules/ps_linklist/src/LegacyLinkBlockRepository.php:91 (__construct) [id: 3] /modules/ps_linklist/src/LegacyLinkBlockRepository.php:91 (__construct) [id: 4] /modules/ps_linklist/src/LegacyLinkBlockRepository.php:91 (__construct) [id: 6] /modules/ps_linklist/src/LegacyLinkBlockRepository.php:91 (__construct) [id: 5]
Tax	4	/classes/tax/TaxRulesTaxManager.php:116 (__construct) [id: 33] /classes/tax/TaxRulesTaxManager.php:116 (__construct) [id: 33] /classes/tax/TaxRulesTaxManager.php:116 (__construct) [id: 34] /classes/tax/TaxRulesTaxManager.php:116 (__construct) [id: 34]
Country	4	/config/config.inc.php:146 (__construct) [id: 36] /classes/controller/FrontController.php:354 (__construct) [id: 36] /classes/AddressFormat.php:404 (__construct) [id: 36] /classes/controller/FrontController.php:1767 (__construct) [id: 36]
Address	4	/classes/shop/Shop.php:486 (__construct) [id: ] /classes/Product.php:3694 (initialize) [id: ] /classes/Product.php:3804 (__construct) [id: ] /classes/Product.php:5960 (__construct) [id: ]
State	2	/classes/AddressFormat.php:404 (__construct) [id: 393] /classes/controller/FrontController.php:1766 (__construct) [id: 393]
Cart	2	/classes/controller/FrontController.php:467 (__construct) [id: ] /classes/controller/FrontController.php:541 (__construct) [id: ]
Mt_VerticalmenuClass	1	/modules/mt_verticalmenu/mt_verticalmenu.php:769 (__construct) [id: ]
Shop	1	/config/config.inc.php:117 (initialize) [id: 1]
AddressFormat	1	/classes/controller/FrontController.php:1761 (generateAddress) [id: ]
Gender	1	/classes/controller/FrontController.php:1691 (__construct) [id: 0]
Group	1	/classes/Cart.php:249 (getCurrent) [id: 1]
Customer	1	/config/config.inc.php:264 (__construct) [id: ]
ShopGroup	1	/classes/shop/Shop.php:561 (__construct) [id: 1]
Risk	1	/classes/controller/FrontController.php:1694 (__construct) [id: ]

#	Query	Time (ms)	Rows	Filesort	Group By	Location
109	REPLACE INTO ps_layered_filter_block (hash, data) VALUES ("f2cdd9aeff797f8f1a9a11cd21717862", "a:1:{s:7:\"filters\";a:10:{i:0;a:7:{s:9:\"type_lite\";s:8:\"category\";s:4:\"type\";s:8:\"category\";s:6:\"id_key\";i:0;s:4:\"name\";s:10:\"Categories\";s:6:\"values\";a:2:{i:1207;a:2:{s:4:\"name\";s:11:\"Label tapes\";s:3:\"nbr\";s:2:\"12\";}i:1213;a:2:{s:4:\"name\";s:29:\"Brother compabile label tapes\";s:3:\"nbr\";s:2:\"12\";}}s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";s:1:\"0\";}i:1;a:7:{s:9:\"type_lite\";s:6:\"extras\";s:4:\"type\";s:6:\"extras\";s:6:\"id_key\";i:0;s:4:\"name\";s:10:\"Selections\";s:6:\"values\";a:3:{s:4:\"sale\";a:2:{s:4:\"name\";s:7:\"On sale\";s:3:\"nbr\";i:0;}s:3:\"new\";a:2:{s:4:\"name\";s:11:\"New product\";s:3:\"nbr\";i:4;}s:8:\"discount\";a:2:{s:4:\"name\";s:10:\"Discounted\";s:3:\"nbr\";i:0;}}s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";s:1:\"0\";}i:2;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:5:\"Price\";s:3:\"max\";d:26;s:3:\"min\";d:15;s:4:\"unit\";s:3:\"lei\";s:14:\"specifications\";a:11:{s:6:\"symbol\";a:11:{i:0;s:1:\".\";i:1;s:1:\",\";i:2;s:1:\";\";i:3;s:1:\"%\";i:4;s:1:\"-\";i:5;s:1:\"+\";i:6;s:1:\"E\";i:7;s:2:\"×\";i:8;s:3:\"‰\";i:9;s:3:\"∞\";i:10;s:3:\"NaN\";}s:12:\"currencyCode\";s:3:\"RON\";s:14:\"currencySymbol\";s:3:\"lei\";s:13:\"numberSymbols\";a:11:{i:0;s:1:\".\";i:1;s:1:\",\";i:2;s:1:\";\";i:3;s:1:\"%\";i:4;s:1:\"-\";i:5;s:1:\"+\";i:6;s:1:\"E\";i:7;s:2:\"×\";i:8;s:3:\"‰\";i:9;s:3:\"∞\";i:10;s:3:\"NaN\";}s:15:\"positivePattern\";s:10:\"¤#,##0.00\";s:15:\"negativePattern\";s:11:\"-¤#,##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:12;s:5:\"value\";N;}i:3;a:9:{s:9:\"type_lite\";s:10:\"id_feature\";s:4:\"type\";s:10:\"id_feature\";s:6:\"id_key\";s:1:\"3\";s:6:\"values\";a:1:{i:5;a:4:{s:3:\"nbr\";s:2:\"12\";s:4:\"name\";s:15:\"Brother P-touch\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}}s:4:\"name\";s:18:\"Compatible printer\";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:\"1\";s:6:\"values\";a:1:{i:1;a:4:{s:3:\"nbr\";s:2:\"12\";s:4:\"name\";s:18:\"Label tape casette\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}}s:4:\"name\";s:12:\"Product name\";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:\"6\";s:6:\"values\";a:18:{i:63;a:4:{s:3:\"nbr\";s:1:\"3\";s:4:\"name\";s:24:\"Black on blue background\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:298;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:37:\"Black on fluorescent green background\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:109;a:4:{s:3:\"nbr\";s:1:\"2\";s:4:\"name\";s:38:\"Black on fluorescent orange background\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:108;a:4:{s:3:\"nbr\";s:1:\"4\";s:4:\"name\";s:38:\"Black on fluorescent yellow background\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:133;a:4:{s:3:\"nbr\";s:1:\"2\";s:4:\"name\";s:26:\"Black on golden background\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:61;a:4:{s:3:\"nbr\";s:1:\"2\";s:4:\"name\";s:25:\"Black on green background\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:60;a:4:{s:3:\"nbr\";s:1:\"2\";s:4:\"name\";s:23:\"Black on red background\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:104;a:4:{s:3:\"nbr\";s:1:\"5\";s:4:\"name\";s:31:\"Black on transparent background\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:53;a:4:{s:3:\"nbr\";s:1:\"9\";s:4:\"name\";s:25:\"Black on white background\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:64;a:4:{s:3:\"nbr\";s:1:\"6\";s:4:\"name\";s:26:\"Black on yellow background\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:55;a:4:{s:3:\"nbr\";s:1:\"3\";s:4:\"name\";s:24:\"Blue on white background\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:295;a:4:{s:3:\"nbr\";s:1:\"2\";s:4:\"name\";s:29:\"Red on transparent background\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:54;a:4:{s:3:\"nbr\";s:1:\"4\";s:4:\"name\";s:23:\"Red on white background\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:59;a:5:{s:3:\"nbr\";s:1:\"4\";s:4:\"name\";s:26:\"White on a blue background\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:7:\"checked\";b:1;}i:62;a:4:{s:3:\"nbr\";s:1:\"4\";s:4:\"name\";s:25:\"White on black background\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:58;a:5:{s:3:\"nbr\";s:1:\"4\";s:4:\"name\";s:25:\"White on green background\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:7:\"checked\";b:1;}i:57;a:5:{s:3:\"nbr\";s:1:\"4\";s:4:\"name\";s:23:\"White on red background\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:7:\"checked\";b:1;}i:150;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:31:\"White on transparent background\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}}s:4:\"name\";s:11:\"Print color\";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:\"10\";s:6:\"values\";a:4:{i:118;a:4:{s:3:\"nbr\";s:1:\"3\";s:4:\"name\";s:4:\"6 mm\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:82;a:4:{s:3:\"nbr\";s:1:\"3\";s:4:\"name\";s:4:\"9 mm\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:83;a:4:{s:3:\"nbr\";s:1:\"3\";s:4:\"name\";s:5:\"12 mm\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:84;a:4:{s:3:\"nbr\";s:1:\"3\";s:4:\"name\";s:5:\"18 mm\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}}s:4:\"name\";s:9:\"Bandwidth\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";s:1:\"0\";}i:7;a:9:{s:9:\"type_lite\";s:10:\"id_feature\";s:4:\"type\";s:10:\"id_feature\";s:6:\"id_key\";s:2:\"13\";s:6:\"values\";a:1:{i:91;a:4:{s:3:\"nbr\";s:2:\"12\";s:4:\"name\";s:8:\"Standard\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}}s:4:\"name\";s:13:\"Type adhesive\";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:8;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:110;a:4:{s:3:\"nbr\";s:2:\"11\";s:4:\"name\";s:7:\"Romania\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}}s:4:\"name\";s:16:\"Product location\";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:9:{s:9:\"type_lite\";s:10:\"id_feature\";s:4:\"type\";s:10:\"id_feature\";s:6:\"id_key\";s:1:\"9\";s:6:\"values\";a:2:{i:81;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:5:\"Paper\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:80;a:4:{s:3:\"nbr\";s:2:\"10\";s:4:\"name\";s:7:\"Plastic\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}}s:4:\"name\";s:11:\"Composition\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";s:1:\"0\";}}}")	38.778 ms	1			/modules/ps_facetedsearch/src/Filters/Block.php:211 /modules/ps_facetedsearch/src/Product/SearchProvider.php:217 (insertIntoCache) /classes/controller/ProductListingFrontController.php:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
2	SELECT SQL_NO_CACHE c.`name`, cl.`id_lang`, IF(cl.`id_lang` IS NULL, c.`value`, cl.`value`) AS value, c.id_shop_group, c.id_shop FROM `ps_configuration` c LEFT JOIN `ps_configuration_lang` cl ON (c.`id_configuration` = cl.`id_configuration`)	8.545 ms	5889			/classes/Configuration.php:180 /classes/Configuration.php:229 (loadConfiguration) /classes/Configuration.php:302 (get) /classes/shop/Shop.php:398 (getMultiShopValues) /config/config.inc.php:117 (initialize) /index.php:27 (require)
323	SELECT SQL_NO_CACHE c.id_parent, c.id_category, cl.name, cl.description, cl.link_rewrite FROM `ps_category` c INNER JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.`id_lang` = 1 AND cl.id_shop = 1 ) INNER JOIN `ps_category_shop` cs ON (cs.`id_category` = c.`id_category` AND cs.`id_shop` = 1) WHERE (c.`active` = 1 OR c.`id_category` = 2) AND c.`id_category` != 1 AND nleft >= 2 AND nright <= 2231 AND c.id_category IN ( SELECT id_category FROM `ps_category_group` WHERE `id_group` IN (1) ) ORDER BY `level_depth` ASC, cs.`position` ASC	7.673 ms	373	Yes		/modules/nrtsearchbar/nrtsearchbar.php:308 /modules/nrtsearchbar/nrtsearchbar.php:393 (getCategories) /modules/nrtsearchbar/nrtsearchbar.php:424 (getWidgetVariables) /classes/Hook.php:1088 (renderWidget) /tools/profiling/Hook.php:64 (coreRenderWidget) /classes/Hook.php:1019 (coreRenderWidget) /config/smarty.config.inc.php:201 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/dev/smarty/compile/electroniclayouts_layout_left_column_tpl/96/30/60/96306027b31a55daf936a38c2b5cf57eead92aae_2.file.header.tpl.php:144 (__call) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/electroniclayouts_layout_left_column_tpl/96/30/60/96306027b31a55daf936a38c2b5cf57eead92aae_2.file.header.tpl.php:36 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67d29bb9bf86d4_40072378) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /var/cache/dev/smarty/compile/electroniclayouts_layout_left_column_tpl/71/5a/b5/715ab599ed96f845fbc799daa8872ed5e3adccb6_2.file.layout-both-columns.tpl.php:233 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/electroniclayouts_layout_left_column_tpl/71/5a/b5/715ab599ed96f845fbc799daa8872ed5e3adccb6_2.file.layout-both-columns.tpl.php:63 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67d29bb9bc0be2_53677533) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/electroniclayouts_layout_left_column_tpl/46/d8/cc/46d8cc2fd68abfd643133d7cdee80d50cff14159_2.file.layout-left-column.tpl.php:38 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67d29bb9baa1f7_92821401) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/electroniclayouts_layout_left_column_tpl/f2/d3/82/f2d382b1f3cdca8e56f02ba27144f28a45bd84ff_2.file.product-list.tpl.php:37 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67d29bb9ba1aa1_86791724) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/electroniclayouts_layout_left_column_tpl/2e/31/04/2e31043655244529250d3ab63cd19ec4683e9b94_2.file.category.tpl.php:34 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67d29bb9b965b7_79755520) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/Smarty/SmartyDev.php:40 (fetch) /classes/controller/FrontController.php:760 (fetch) /classes/controller/FrontController.php:742 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
97	SELECT SQL_NO_CACHE fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, pl.name FROM ps_product p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN ps_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps_product_lang pl ON (p.id_product = pl.id_product AND pl.id_shop = 1 AND pl.id_lang = 1) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=2 AND c.nright<=2231 GROUP BY p.id_product) p INNER JOIN ps_feature_product fp ON (p.id_product = fp.id_product) WHERE ((fp.id_feature=6)) GROUP BY fp.id_feature_value	2.865 ms	808	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:778 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:855 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:154 (getFeaturesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
82	SELECT SQL_NO_CACHE cp.id_category, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, pl.name FROM ps_product p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN ps_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps_product_lang pl ON (p.id_product = pl.id_product AND pl.id_shop = 1 AND pl.id_lang = 1) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN ps_feature_product fp ON (p.id_product = fp.id_product) WHERE ((fp.id_feature_value IN (59, 58, 57))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=2 AND c.nright<=2231 GROUP BY p.id_product) p 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) WHERE ((fp.id_feature_value IN (59, 58, 57))) AND cg.id_group='1' AND c.nleft>2 AND c.nright<2231 GROUP BY cp.id_category	1.829 ms	363600	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:778 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:992 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:158 (getCategoriesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
81	SELECT SQL_NO_CACHE c.`id_category`, cl.`name` FROM `ps_category` c INNER JOIN ps_category_shop category_shop ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1) LEFT JOIN `ps_category_lang` cl ON c.`id_category` = cl.`id_category` AND cl.id_shop = 1 WHERE 1 AND `id_lang` = 1 AND c.`active` = 1 ORDER BY c.nleft, c.position	1.793 ms	373	Yes		/classes/Category.php:724 /modules/ps_facetedsearch/src/Filters/Block.php:986 (getAllCategoriesName) /modules/ps_facetedsearch/src/Filters/Block.php:158 (getCategoriesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
79	SELECT SQL_NO_CACHE p.id_product, sa.out_of_stock FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, pl.name FROM ps_product p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN ps_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps_product_lang pl ON (p.id_product = pl.id_product AND pl.id_shop = 1 AND pl.id_lang = 1) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN ps_feature_product fp ON (p.id_product = fp.id_product) WHERE ((fp.id_feature_value IN (59, 58, 57))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=2 AND c.nright<=2231 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 = 1 AND sa.id_shop_group = 0 ) INNER JOIN ps_product_lang pl ON (p.id_product = pl.id_product AND pl.id_shop = 1 AND pl.id_lang = 1) GROUP BY p.id_product ORDER BY IFNULL(p.quantity, 0) <= 0, IFNULL(p.quantity, 0) <= 0 AND FIELD(sa.out_of_stock, 1) DESC, p.name ASC, p.id_product DESC	1.771 ms	24240	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Filters/Products.php:87 (execute) /modules/ps_facetedsearch/src/Product/SearchProvider.php:187 (getProductByFilters) /classes/controller/ProductListingFrontController.php:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
90	SELECT SQL_NO_CACHE pac.id_attribute, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, pl.name FROM ps_product p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN ps_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps_product_lang pl ON (p.id_product = pl.id_product AND pl.id_shop = 1 AND pl.id_lang = 1) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN ps_feature_product fp ON (p.id_product = fp.id_product) WHERE ((fp.id_feature_value IN (59, 58, 57))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=2 AND c.nright<=2231 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) WHERE ((a.id_attribute_group=2)) AND ((fp_1.id_feature_value IN (59, 58, 57))) GROUP BY pac.id_attribute	1.689 ms	363600	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:778 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:737 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:150 (getAttributesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
107	SELECT SQL_NO_CACHE fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, pl.name FROM ps_product p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN ps_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps_product_lang pl ON (p.id_product = pl.id_product AND pl.id_shop = 1 AND pl.id_lang = 1) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN ps_feature_product fp ON (p.id_product = fp.id_product) WHERE ((fp.id_feature_value IN (59, 58, 57))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=2 AND c.nright<=2231 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) WHERE ((fp.id_feature=9)) AND ((fp_1.id_feature_value IN (59, 58, 57))) GROUP BY fp.id_feature_value	1.678 ms	181800	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:778 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:855 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:154 (getFeaturesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
99	SELECT SQL_NO_CACHE fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, pl.name FROM ps_product p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN ps_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps_product_lang pl ON (p.id_product = pl.id_product AND pl.id_shop = 1 AND pl.id_lang = 1) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN ps_feature_product fp ON (p.id_product = fp.id_product) WHERE ((fp.id_feature_value IN (59, 58, 57))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=2 AND c.nright<=2231 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) WHERE ((fp.id_feature=10)) AND ((fp_1.id_feature_value IN (59, 58, 57))) GROUP BY fp.id_feature_value	1.675 ms	181800	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:778 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:855 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:154 (getFeaturesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
101	SELECT SQL_NO_CACHE fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, pl.name FROM ps_product p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN ps_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps_product_lang pl ON (p.id_product = pl.id_product AND pl.id_shop = 1 AND pl.id_lang = 1) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN ps_feature_product fp ON (p.id_product = fp.id_product) WHERE ((fp.id_feature_value IN (59, 58, 57))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=2 AND c.nright<=2231 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) WHERE ((fp.id_feature=13)) AND ((fp_1.id_feature_value IN (59, 58, 57))) GROUP BY fp.id_feature_value	1.667 ms	181800	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:778 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:855 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:154 (getFeaturesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
105	SELECT SQL_NO_CACHE fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, pl.name FROM ps_product p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN ps_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps_product_lang pl ON (p.id_product = pl.id_product AND pl.id_shop = 1 AND pl.id_lang = 1) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN ps_feature_product fp ON (p.id_product = fp.id_product) WHERE ((fp.id_feature_value IN (59, 58, 57))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=2 AND c.nright<=2231 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) WHERE ((fp.id_feature=20)) AND ((fp_1.id_feature_value IN (59, 58, 57))) GROUP BY fp.id_feature_value	1.657 ms	181800	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:778 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:855 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:154 (getFeaturesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
91	SELECT SQL_NO_CACHE fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, pl.name FROM ps_product p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN ps_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps_product_lang pl ON (p.id_product = pl.id_product AND pl.id_shop = 1 AND pl.id_lang = 1) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN ps_feature_product fp ON (p.id_product = fp.id_product) WHERE ((fp.id_feature_value IN (59, 58, 57))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=2 AND c.nright<=2231 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) WHERE ((fp.id_feature=3)) AND ((fp_1.id_feature_value IN (59, 58, 57))) GROUP BY fp.id_feature_value	1.654 ms	181800	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:778 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:855 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:154 (getFeaturesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
95	SELECT SQL_NO_CACHE fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, pl.name FROM ps_product p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN ps_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps_product_lang pl ON (p.id_product = pl.id_product AND pl.id_shop = 1 AND pl.id_lang = 1) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN ps_feature_product fp ON (p.id_product = fp.id_product) WHERE ((fp.id_feature_value IN (59, 58, 57))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=2 AND c.nright<=2231 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) WHERE ((fp.id_feature=1)) AND ((fp_1.id_feature_value IN (59, 58, 57))) GROUP BY fp.id_feature_value	1.636 ms	181800	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:778 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:855 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:154 (getFeaturesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
124	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.530 ms	0			/classes/Hook.php:1326 /classes/Hook.php:225 (getAllHookIds) /classes/tax/TaxManagerFactory.php:67 (getIdByName) /classes/tax/TaxManagerFactory.php:46 (execHookTaxManagerFactory) /classes/Product.php:3925 (getManager) /classes/Product.php:3717 (priceCalculation) /classes/Product.php:5688 (getPriceStatic) /classes/ProductAssembler.php:209 (getProductProperties) /classes/controller/ProductListingFrontController.php:108 (assembleProducts) /classes/controller/ProductListingFrontController.php:379 (prepareMultipleProductsForTemplate) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
84	SELECT SQL_NO_CACHE COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, pl.name FROM ps_product p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN ps_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps_product_lang pl ON (p.id_product = pl.id_product AND pl.id_shop = 1 AND pl.id_lang = 1) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN ps_feature_product fp ON (p.id_product = fp.id_product) WHERE ((fp.id_feature_value IN (59, 58, 57))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=2 AND c.nright<=2231 GROUP BY p.id_product) p LEFT JOIN ps_feature_product fp ON (p.id_product = fp.id_product) WHERE ((fp.id_feature_value IN (59, 58, 57))) AND p.date_add>'2024-03-19 00:00:00'	1.504 ms	181800			/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:778 (execute) /modules/ps_facetedsearch/src/Adapter/MySQL.php:757 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:587 (count) /modules/ps_facetedsearch/src/Filters/Block.php:143 (getHighlightsBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
83	SELECT SQL_NO_CACHE COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, pl.name FROM ps_product p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN ps_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps_product_lang pl ON (p.id_product = pl.id_product AND pl.id_shop = 1 AND pl.id_lang = 1) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN ps_feature_product fp ON (p.id_product = fp.id_product) WHERE ((fp.id_feature_value IN (59, 58, 57))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=2 AND c.nright<=2231 GROUP BY p.id_product) p LEFT JOIN ps_feature_product fp_1 ON (p.id_product = fp_1.id_product) WHERE ((p.on_sale=1)) AND ((fp_1.id_feature_value IN (59, 58, 57)))	1.479 ms	181800			/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:778 (execute) /modules/ps_facetedsearch/src/Adapter/MySQL.php:757 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:565 (count) /modules/ps_facetedsearch/src/Filters/Block.php:143 (getHighlightsBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
17	SELECT SQL_NO_CACHE h.`name` as hook, m.`id_module`, h.`id_hook`, m.`name` as module FROM `ps_module` m INNER JOIN ps_module_shop module_shop ON (module_shop.id_module = m.id_module AND module_shop.id_shop = 1 AND module_shop.enable_device & 1) INNER JOIN `ps_hook_module` `hm` ON hm.`id_module` = m.`id_module` INNER JOIN `ps_hook` `h` ON hm.`id_hook` = h.`id_hook` LEFT JOIN `ps_module_group` `mg` ON mg.`id_module` = m.`id_module` WHERE (h.`name` != "paymentOptions") AND (hm.`id_shop` = 1) AND (mg.id_shop = 1 AND mg.`id_group` IN (1)) GROUP BY hm.id_hook, hm.id_module ORDER BY hm.`position`	1.473 ms	1431	Yes	Yes	/classes/Hook.php:1267 /classes/Hook.php:735 (getAllHookRegistrations) /classes/Hook.php:842 (getHookModuleExecList) /classes/Dispatcher.php:606 (exec) /classes/Dispatcher.php:243 (loadRoutes) /classes/Dispatcher.php:201 (__construct) /index.php:28 (getInstance)
86	SELECT SQL_NO_CACHE psi.price_min, MIN(price_min) as min, MAX(price_max) as max FROM ps_product p INNER JOIN ps_layered_price_index psi ON (psi.id_product = p.id_product AND psi.id_shop = 1 AND psi.id_currency = 1 AND psi.id_country = 36) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN ps_feature_product fp ON (p.id_product = fp.id_product) WHERE ((fp.id_feature_value IN (59, 58, 57))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=2 AND c.nright<=2231	1.074 ms	3030			/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:57 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:250 (getMinMaxPriceValue) /modules/ps_facetedsearch/src/Filters/Block.php:131 (getPriceRangeBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
16	SELECT SQL_NO_CACHE lower(name) as name FROM `ps_hook` h WHERE (h.active = 1)	1.029 ms	1082			/classes/Hook.php:1366 /classes/Hook.php:811 (getHookStatusByName) /classes/Dispatcher.php:606 (exec) /classes/Dispatcher.php:243 (loadRoutes) /classes/Dispatcher.php:201 (__construct) /index.php:28 (getInstance)
125	SELECT SQL_NO_CACHE h.id_hook, h.name as h_name, title, description, h.position, hm.position as hm_position, m.id_module, m.name, m.active FROM `ps_hook_module` hm STRAIGHT_JOIN `ps_hook` h ON (h.id_hook = hm.id_hook AND hm.id_shop = 1) STRAIGHT_JOIN `ps_module` as m ON (m.id_module = hm.id_module) ORDER BY hm.position	0.761 ms	262			/classes/Hook.php:456 /classes/Hook.php:493 (getHookModuleList) /classes/tax/TaxManagerFactory.php:67 (getModulesFromHook) /classes/tax/TaxManagerFactory.php:46 (execHookTaxManagerFactory) /classes/Product.php:3925 (getManager) /classes/Product.php:3717 (priceCalculation) /classes/Product.php:5688 (getPriceStatic) /classes/ProductAssembler.php:209 (getProductProperties) /classes/controller/ProductListingFrontController.php:108 (assembleProducts) /classes/controller/ProductListingFrontController.php:379 (prepareMultipleProductsForTemplate) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
85	SELECT SQL_NO_CACHE COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, pl.name FROM ps_product p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN ps_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps_product_lang pl ON (p.id_product = pl.id_product AND pl.id_shop = 1 AND pl.id_lang = 1) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN ps_feature_product fp ON (p.id_product = fp.id_product) WHERE ((fp.id_feature_value IN (59, 58, 57))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=2 AND c.nright<=2231 GROUP BY p.id_product) p LEFT JOIN ps_specific_price sp ON ( sp.id_product = p.id_product AND sp.id_shop IN (0, 1) AND sp.id_currency IN (0, 1) AND sp.id_country IN (0, 36) AND sp.id_group IN (0, 1) AND sp.from_quantity = 1 AND sp.reduction > 0 AND sp.id_customer = 0 AND sp.id_cart = 0 AND (sp.from = '0000-00-00 00:00:00' OR '2025-03-13 10:47:53' >= sp.from) AND (sp.to = '0000-00-00 00:00:00' OR '2025-03-13 10:47:53' <= sp.to) ) LEFT JOIN ps_feature_product fp_1 ON (p.id_product = fp_1.id_product) WHERE ((sp.reduction>0)) AND ((fp_1.id_feature_value IN (59, 58, 57)))	0.756 ms	181800			/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:778 (execute) /modules/ps_facetedsearch/src/Adapter/MySQL.php:757 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:605 (count) /modules/ps_facetedsearch/src/Filters/Block.php:143 (getHighlightsBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
88	SELECT SQL_NO_CACHE pac.id_attribute, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, pl.name FROM ps_product p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN ps_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps_product_lang pl ON (p.id_product = pl.id_product AND pl.id_shop = 1 AND pl.id_lang = 1) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN ps_feature_product fp ON (p.id_product = fp.id_product) WHERE ((fp.id_feature_value IN (59, 58, 57))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=2 AND c.nright<=2231 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) WHERE ((a.id_attribute_group=1)) AND ((fp_1.id_feature_value IN (59, 58, 57))) GROUP BY pac.id_attribute	0.755 ms	909000			/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:778 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:737 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:150 (getAttributesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
94	SELECT SQL_NO_CACHE pac.id_attribute, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, pl.name FROM ps_product p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN ps_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps_product_lang pl ON (p.id_product = pl.id_product AND pl.id_shop = 1 AND pl.id_lang = 1) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN ps_feature_product fp ON (p.id_product = fp.id_product) WHERE ((fp.id_feature_value IN (59, 58, 57))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=2 AND c.nright<=2231 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) WHERE ((a.id_attribute_group=4)) AND ((fp_1.id_feature_value IN (59, 58, 57))) GROUP BY pac.id_attribute	0.755 ms	909000			/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:778 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:737 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:150 (getAttributesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
328	SELECT SQL_NO_CACHE p., product_shop., stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, product_attribute_shop.minimal_quantity AS product_attribute_minimal_quantity,IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, pl.`description`, pl.`description_short`, pl.`link_rewrite`, pl.`meta_description`, pl.`meta_keywords`, pl.`meta_title`, pl.`name`, pl.`available_now`, pl.`available_later`, m.`name` AS manufacturer_name, p.`id_manufacturer` as id_manufacturer, image_shop.`id_image` id_image, il.`legend`, ps.`quantity` AS sales, t.`rate`, pl.`meta_keywords`, pl.`meta_title`, pl.`meta_description`, DATEDIFF(p.`date_add`, DATE_SUB("2025-03-13 00:00:00", INTERVAL 360 DAY)) > 0 AS new FROM `ps_product_sale` ps LEFT JOIN `ps_product` p ON ps.`id_product` = p.`id_product` LEFT JOIN ps_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) LEFT JOIN `ps_product_attribute_shop` product_attribute_shop ON (p.`id_product` = product_attribute_shop.`id_product` AND product_attribute_shop.`default_on` = 1 AND product_attribute_shop.id_shop=1) LEFT JOIN `ps_product_lang` pl ON p.`id_product` = pl.`id_product` AND pl.`id_lang` = 1 AND pl.id_shop = 1 LEFT JOIN `ps_image_shop` image_shop ON (image_shop.`id_product` = p.`id_product` AND image_shop.cover=1 AND image_shop.id_shop=1) LEFT JOIN `ps_image_lang` il ON (image_shop.`id_image` = il.`id_image` AND il.`id_lang` = 1) LEFT JOIN `ps_manufacturer` m ON (m.`id_manufacturer` = p.`id_manufacturer`) LEFT JOIN `ps_tax_rule` tr ON (product_shop.`id_tax_rules_group` = tr.`id_tax_rules_group`) AND tr.`id_country` = 36 AND tr.`id_state` = 0 LEFT JOIN `ps_tax` t ON (t.`id_tax` = tr.`id_tax`) LEFT JOIN ps_stock_available stock ON (stock.id_product = `p`.id_product AND stock.id_product_attribute = 0 AND stock.id_shop = 1 AND stock.id_shop_group = 0 ) WHERE product_shop.`active` = 1 AND product_shop.`visibility` != 'none' AND EXISTS(SELECT 1 FROM `ps_category_product` cp JOIN `ps_category_group` cg ON (cp.id_category = cg.id_category AND cg.`id_group` =1) WHERE cp.`id_product` = p.`id_product`) ORDER BY `sales` DESC LIMIT 0, 3	0.735 ms	12			/classes/ProductSale.php:151 /src/Adapter/BestSales/BestSalesProductSearchProvider.php:74 (getBestSales) /modules/ps_bestsellers/ps_bestsellers.php:231 (runQuery) /modules/ps_bestsellers/ps_bestsellers.php:197 (getBestSellers) /modules/ps_bestsellers/ps_bestsellers.php:183 (getWidgetVariables) /classes/Hook.php:1088 (renderWidget) /tools/profiling/Hook.php:64 (coreRenderWidget) /classes/Hook.php:1019 (coreRenderWidget) /config/smarty.config.inc.php:201 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/dev/smarty/compile/electroniclayouts_layout_left_column_tpl/71/5a/b5/715ab599ed96f845fbc799daa8872ed5e3adccb6_2.file.layout-both-columns.tpl.php:292 (__call) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/electroniclayouts_layout_left_column_tpl/71/5a/b5/715ab599ed96f845fbc799daa8872ed5e3adccb6_2.file.layout-both-columns.tpl.php:99 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67d29bb9bc0be2_53677533) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/electroniclayouts_layout_left_column_tpl/46/d8/cc/46d8cc2fd68abfd643133d7cdee80d50cff14159_2.file.layout-left-column.tpl.php:38 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67d29bb9baa1f7_92821401) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/electroniclayouts_layout_left_column_tpl/f2/d3/82/f2d382b1f3cdca8e56f02ba27144f28a45bd84ff_2.file.product-list.tpl.php:37 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67d29bb9ba1aa1_86791724) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/electroniclayouts_layout_left_column_tpl/2e/31/04/2e31043655244529250d3ab63cd19ec4683e9b94_2.file.category.tpl.php:34 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67d29bb9b965b7_79755520) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/Smarty/SmartyDev.php:40 (fetch) /classes/controller/FrontController.php:760 (fetch) /classes/controller/FrontController.php:742 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
20	SELECT SQL_NO_CACHE `id_hook`, `name` FROM `ps_hook`	0.722 ms	1082			/classes/Hook.php:1326 /classes/Hook.php:225 (getAllHookIds) /classes/Hook.php:851 (getIdByName) /classes/Dispatcher.php:507 (exec) /index.php:28 (dispatch)
103	SELECT SQL_NO_CACHE fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, pl.name FROM ps_product p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN ps_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps_product_lang pl ON (p.id_product = pl.id_product AND pl.id_shop = 1 AND pl.id_lang = 1) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN ps_feature_product fp ON (p.id_product = fp.id_product) WHERE ((fp.id_feature_value IN (59, 58, 57))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=2 AND c.nright<=2231 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) WHERE ((fp.id_feature=17)) AND ((fp_1.id_feature_value IN (59, 58, 57))) GROUP BY fp.id_feature_value	0.684 ms	545400	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:778 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:855 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:154 (getFeaturesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
104	SELECT SQL_NO_CACHE fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, pl.name FROM ps_product p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN ps_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps_product_lang pl ON (p.id_product = pl.id_product AND pl.id_shop = 1 AND pl.id_lang = 1) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN ps_feature_product fp ON (p.id_product = fp.id_product) WHERE ((fp.id_feature_value IN (59, 58, 57))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=2 AND c.nright<=2231 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) WHERE ((fp.id_feature=18)) AND ((fp_1.id_feature_value IN (59, 58, 57))) GROUP BY fp.id_feature_value	0.668 ms	181800	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:778 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:855 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:154 (getFeaturesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
283	SELECT SQL_NO_CACHE pi., pl. FROM ps_mt_verticalmenu_item pi LEFT JOIN `ps_mt_verticalmenu_item_lang` pl ON pl.`id_mt_verticalmenu_item` = pi.`id_mt_verticalmenu_item` LEFT JOIN `ps_mt_verticalmenu_item_shop` ps ON ps.`id_mt_verticalmenu_item` = pi.`id_mt_verticalmenu_item` WHERE pi.active = 1 AND ps.id_shop = 1 AND pl.id_lang=1 ORDER BY pi.position ASC, pi.id_mt_verticalmenu_item ASC	0.628 ms	7	Yes		/modules/mt_verticalmenu/classes/Mt_VerticalmenuClass.php:206 /modules/mt_verticalmenu/mt_verticalmenu.php:770 (getMenus) /classes/Hook.php:1077 (hookdisplayVerticalmenu) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:418 (coreCallHook) /classes/Hook.php:983 (callHookOn) /config/smarty.config.inc.php:201 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/dev/smarty/compile/electroniclayouts_layout_left_column_tpl/96/30/60/96306027b31a55daf936a38c2b5cf57eead92aae_2.file.header.tpl.php:142 (__call) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/electroniclayouts_layout_left_column_tpl/96/30/60/96306027b31a55daf936a38c2b5cf57eead92aae_2.file.header.tpl.php:36 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67d29bb9bf86d4_40072378) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /var/cache/dev/smarty/compile/electroniclayouts_layout_left_column_tpl/71/5a/b5/715ab599ed96f845fbc799daa8872ed5e3adccb6_2.file.layout-both-columns.tpl.php:233 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/electroniclayouts_layout_left_column_tpl/71/5a/b5/715ab599ed96f845fbc799daa8872ed5e3adccb6_2.file.layout-both-columns.tpl.php:63 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67d29bb9bc0be2_53677533) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/electroniclayouts_layout_left_column_tpl/46/d8/cc/46d8cc2fd68abfd643133d7cdee80d50cff14159_2.file.layout-left-column.tpl.php:38 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67d29bb9baa1f7_92821401) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/electroniclayouts_layout_left_column_tpl/f2/d3/82/f2d382b1f3cdca8e56f02ba27144f28a45bd84ff_2.file.product-list.tpl.php:37 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67d29bb9ba1aa1_86791724) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/electroniclayouts_layout_left_column_tpl/2e/31/04/2e31043655244529250d3ab63cd19ec4683e9b94_2.file.category.tpl.php:34 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67d29bb9b965b7_79755520) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/Smarty/SmartyDev.php:40 (fetch) /classes/controller/FrontController.php:760 (fetch) /classes/controller/FrontController.php:742 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
47	SELECT SQL_NO_CACHE c.*, cl.`id_lang`, cl.`name`, cl.`description`, cl.`additional_description`, cl.`link_rewrite`, cl.`meta_title`, cl.`meta_keywords`, cl.`meta_description` FROM `ps_category` c INNER JOIN ps_category_shop category_shop ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1) LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND `id_lang` = 1 AND cl.id_shop = 1 ) LEFT JOIN `ps_category_group` cg ON (cg.`id_category` = c.`id_category`) WHERE `id_parent` = 2 AND `active` = 1 AND cg.`id_group` =1 GROUP BY c.`id_category` ORDER BY `level_depth` ASC, category_shop.`position` ASC	0.531 ms	22	Yes	Yes	/classes/Category.php:924 /controllers/front/listing/CategoryController.php:230 (getSubCategories) /controllers/front/listing/CategoryController.php:118 (getTemplateVarSubCategories) /tools/profiling/Controller.php:41 (init) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
110	SELECT SQL_NO_CACHE p., ps., pl.*, sa.out_of_stock, IFNULL(sa.quantity, 0) as quantity, (DATEDIFF( p.`date_add`, DATE_SUB( '2025-03-13 00:00:00', INTERVAL 360 DAY ) ) > 0) as new FROM ps_product p LEFT JOIN ps_product_lang pl ON pl.id_product = p.id_product AND pl.id_shop = 1 AND pl.id_lang = 1 LEFT JOIN ps_stock_available sa ON sa.id_product = p.id_product AND sa.id_product_attribute = 0 AND sa.id_shop = 1 LEFT JOIN ps_product_shop ps ON ps.id_product = p.id_product AND ps.id_shop = 1 WHERE p.id_product IN (182,98,119,181,118,93,99,144,117,142,175,176)	0.515 ms	12			/classes/ProductAssembler.php:95 /classes/ProductAssembler.php:203 (addMissingProductFieldsForMultipleProducts) /classes/controller/ProductListingFrontController.php:108 (assembleProducts) /classes/controller/ProductListingFrontController.php:379 (prepareMultipleProductsForTemplate) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
19	SELECT SQL_NO_CACHE m.page, ml.url_rewrite, ml.id_lang FROM `ps_meta` m LEFT JOIN `ps_meta_lang` ml ON (m.id_meta = ml.id_meta AND ml.id_shop = 1 ) ORDER BY LENGTH(ml.url_rewrite) DESC	0.496 ms	116	Yes		/classes/Dispatcher.php:654 /classes/Dispatcher.php:243 (loadRoutes) /classes/Dispatcher.php:201 (__construct) /index.php:28 (getInstance)
221	SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position, fvl.id_feature_value FROM ps_feature_product pf LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1) LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1) LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1) INNER JOIN ps_feature_shop feature_shop ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1) WHERE pf.id_product = 142 ORDER BY f.position ASC	0.457 ms	17	Yes		/classes/Product.php:6017 /classes/Product.php:5820 (getFrontFeaturesStatic) /classes/ProductAssembler.php:209 (getProductProperties) /classes/controller/ProductListingFrontController.php:108 (assembleProducts) /classes/controller/ProductListingFrontController.php:379 (prepareMultipleProductsForTemplate) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
284	SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop` FROM `ps_category` c LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 ) INNER JOIN ps_category_shop category_shop ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1) WHERE `id_lang` = 1 AND c.`id_parent` = 1207 AND `active` = 1 GROUP BY c.`id_category` ORDER BY category_shop.`position` ASC	0.436 ms	4	Yes	Yes	/classes/Category.php:1151 /modules/mt_verticalmenu/mt_verticalmenu.php:1155 (getChildren) /modules/mt_verticalmenu/mt_verticalmenu.php:795 (getRespCategories) /classes/Hook.php:1077 (hookdisplayVerticalmenu) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:418 (coreCallHook) /classes/Hook.php:983 (callHookOn) /config/smarty.config.inc.php:201 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/dev/smarty/compile/electroniclayouts_layout_left_column_tpl/96/30/60/96306027b31a55daf936a38c2b5cf57eead92aae_2.file.header.tpl.php:142 (__call) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/electroniclayouts_layout_left_column_tpl/96/30/60/96306027b31a55daf936a38c2b5cf57eead92aae_2.file.header.tpl.php:36 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67d29bb9bf86d4_40072378) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /var/cache/dev/smarty/compile/electroniclayouts_layout_left_column_tpl/71/5a/b5/715ab599ed96f845fbc799daa8872ed5e3adccb6_2.file.layout-both-columns.tpl.php:233 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/electroniclayouts_layout_left_column_tpl/71/5a/b5/715ab599ed96f845fbc799daa8872ed5e3adccb6_2.file.layout-both-columns.tpl.php:63 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67d29bb9bc0be2_53677533) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/electroniclayouts_layout_left_column_tpl/46/d8/cc/46d8cc2fd68abfd643133d7cdee80d50cff14159_2.file.layout-left-column.tpl.php:38 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67d29bb9baa1f7_92821401) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/electroniclayouts_layout_left_column_tpl/f2/d3/82/f2d382b1f3cdca8e56f02ba27144f28a45bd84ff_2.file.product-list.tpl.php:37 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67d29bb9ba1aa1_86791724) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/electroniclayouts_layout_left_column_tpl/2e/31/04/2e31043655244529250d3ab63cd19ec4683e9b94_2.file.category.tpl.php:34 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67d29bb9b965b7_79755520) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/Smarty/SmartyDev.php:40 (fetch) /classes/controller/FrontController.php:760 (fetch) /classes/controller/FrontController.php:742 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
394	SELECT SQL_NO_CACHE * FROM `ps_cms_lang` WHERE `id_cms` = 33 AND `id_shop` = 1	0.432 ms	3			/src/Adapter/EntityMapper.php:79 /classes/ObjectModel.php:283 (load) /tools/profiling/ObjectModel.php:32 (__construct) /modules/ps_linklist/src/Presenter/LinkBlockPresenter.php:138 (__construct) /modules/ps_linklist/src/Presenter/LinkBlockPresenter.php:100 (makeCmsLinks) /modules/ps_linklist/src/Presenter/LinkBlockPresenter.php:66 (makeLinks) /modules/ps_linklist/ps_linklist.php:291 (present) /modules/ps_linklist/ps_linklist.php:277 (getWidgetVariables) /classes/Hook.php:1088 (renderWidget) /tools/profiling/Hook.php:64 (coreRenderWidget) /classes/Hook.php:1019 (coreRenderWidget) /config/smarty.config.inc.php:201 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/dev/smarty/compile/electroniclayouts_layout_left_column_tpl/a4/0d/7b/a40d7bd80c0e66b3dcf446aeac9efc5705a5afea_2.file.footer.tpl.php:108 (__call) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/electroniclayouts_layout_left_column_tpl/a4/0d/7b/a40d7bd80c0e66b3dcf446aeac9efc5705a5afea_2.file.footer.tpl.php:49 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67d29bb9d74d72_43856824) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /var/cache/dev/smarty/compile/electroniclayouts_layout_left_column_tpl/71/5a/b5/715ab599ed96f845fbc799daa8872ed5e3adccb6_2.file.layout-both-columns.tpl.php:378 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/electroniclayouts_layout_left_column_tpl/71/5a/b5/715ab599ed96f845fbc799daa8872ed5e3adccb6_2.file.layout-both-columns.tpl.php:125 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67d29bb9bc0be2_53677533) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/electroniclayouts_layout_left_column_tpl/46/d8/cc/46d8cc2fd68abfd643133d7cdee80d50cff14159_2.file.layout-left-column.tpl.php:38 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67d29bb9baa1f7_92821401) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/electroniclayouts_layout_left_column_tpl/f2/d3/82/f2d382b1f3cdca8e56f02ba27144f28a45bd84ff_2.file.product-list.tpl.php:37 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67d29bb9ba1aa1_86791724) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/electroniclayouts_layout_left_column_tpl/2e/31/04/2e31043655244529250d3ab63cd19ec4683e9b94_2.file.category.tpl.php:34 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67d29bb9b965b7_79755520) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/Smarty/SmartyDev.php:40 (fetch) /classes/controller/FrontController.php:760 (fetch) /classes/controller/FrontController.php:742 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
239	SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position, fvl.id_feature_value FROM ps_feature_product pf LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1) LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1) LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1) INNER JOIN ps_feature_shop feature_shop ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1) WHERE pf.id_product = 176 ORDER BY f.position ASC	0.428 ms	17	Yes		/classes/Product.php:6017 /classes/Product.php:5820 (getFrontFeaturesStatic) /classes/ProductAssembler.php:209 (getProductProperties) /classes/controller/ProductListingFrontController.php:108 (assembleProducts) /classes/controller/ProductListingFrontController.php:379 (prepareMultipleProductsForTemplate) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
230	SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position, fvl.id_feature_value FROM ps_feature_product pf LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1) LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1) LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1) INNER JOIN ps_feature_shop feature_shop ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1) WHERE pf.id_product = 175 ORDER BY f.position ASC	0.422 ms	14	Yes		/classes/Product.php:6017 /classes/Product.php:5820 (getFrontFeaturesStatic) /classes/ProductAssembler.php:209 (getProductProperties) /classes/controller/ProductListingFrontController.php:108 (assembleProducts) /classes/controller/ProductListingFrontController.php:379 (prepareMultipleProductsForTemplate) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
22	SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module`as `mshop` FROM `ps_module` m LEFT JOIN `ps_module_shop` ms ON m.`id_module` = ms.`id_module` AND ms.`id_shop` = 1	0.414 ms	160			/classes/module/Module.php:345 /modules/securitypro/securitypro.php:77 (__construct) :undefined (__construct) /src/Core/Foundation/IoC/Container.php:123 (newInstance) /src/Core/Foundation/IoC/Container.php:153 (makeInstanceFromClassName) /src/Core/Foundation/IoC/Container.php:166 (doMake) /src/Adapter/ServiceLocator.php:70 (make) /classes/module/Module.php:1235 (get) /tools/profiling/Module.php:35 (coreLoadModule) /classes/module/Module.php:1214 (coreLoadModule) /classes/Hook.php:966 (getInstanceByName) /classes/Dispatcher.php:507 (exec) /index.php:28 (dispatch)
220	SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity, COALESCE(SUM(first_level_quantity), 0) as quantity FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity FROM `ps_cart_product` cp WHERE cp.`id_product_attribute` = 0 AND cp.`id_cart` = 0 AND cp.`id_product` = 142 UNION SELECT 0 as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity FROM `ps_cart_product` cp JOIN `ps_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `ps_product` pr ON p.`id_product_pack` = pr.`id_product` WHERE cp.`id_product_attribute` = 0 AND cp.`id_cart` = 0 AND p.`id_product_item` = 142 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1	0.413 ms	0			/classes/Cart.php:1426 /classes/Product.php:4357 (getProductQuantity) /classes/Product.php:5798 (getQuantity) /classes/ProductAssembler.php:209 (getProductProperties) /classes/controller/ProductListingFrontController.php:108 (assembleProducts) /classes/controller/ProductListingFrontController.php:379 (prepareMultipleProductsForTemplate) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
357	SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by FROM `ps_product_attribute` pa INNER JOIN ps_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) JOIN `ps_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`) JOIN `ps_attribute` a ON (a.`id_attribute` = pac.`id_attribute`) JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1) JOIN `ps_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`) WHERE pa.`id_product` IN (211) AND ag.`is_color_group` = 1 GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` ORDER BY a.`position` ASC;	0.404 ms	1	Yes	Yes	/classes/Product.php:4520 /src/Adapter/Product/ProductColorsRetriever.php:43 (getAttributesColorList) /src/Adapter/Presenter/Product/ProductLazyArray.php:528 (getColoredVariants) /src/Adapter/Presenter/AbstractLazyArray.php:261 (getMainVariants) /var/cache/dev/smarty/compile/electronic/fb/b8/1e/fbb81eb31788864ff9b13c94adadc686889b7749_2.file.product-vartical.tpl.php:94 (offsetGet) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/electronic/fb/b8/1e/fbb81eb31788864ff9b13c94adadc686889b7749_2.file.product-vartical.tpl.php:243 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/electronic/fb/b8/1e/fbb81eb31788864ff9b13c94adadc686889b7749_2.file.product-vartical.tpl.php:29 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67d29bb9d0e307_22585175) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /var/cache/dev/smarty/compile/electronic/36/81/aa/3681aa30d1f85f48e2cf4794b77200e697f706a9_2.module.ps_bestsellersviewstemplateshookps_bestsellers.tpl.php:38 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67d29bb9cfd4a5_39215437) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/Smarty/SmartyDevTemplate.php:55 (fetch) /classes/module/Module.php:2273 (fetch) /modules/ps_bestsellers/ps_bestsellers.php:192 (fetch) /classes/Hook.php:1088 (renderWidget) /tools/profiling/Hook.php:64 (coreRenderWidget) /classes/Hook.php:1019 (coreRenderWidget) /config/smarty.config.inc.php:201 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/dev/smarty/compile/electroniclayouts_layout_left_column_tpl/71/5a/b5/715ab599ed96f845fbc799daa8872ed5e3adccb6_2.file.layout-both-columns.tpl.php:292 (__call) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/electroniclayouts_layout_left_column_tpl/71/5a/b5/715ab599ed96f845fbc799daa8872ed5e3adccb6_2.file.layout-both-columns.tpl.php:99 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67d29bb9bc0be2_53677533) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/electroniclayouts_layout_left_column_tpl/46/d8/cc/46d8cc2fd68abfd643133d7cdee80d50cff14159_2.file.layout-left-column.tpl.php:38 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67d29bb9baa1f7_92821401) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/electroniclayouts_layout_left_column_tpl/f2/d3/82/f2d382b1f3cdca8e56f02ba27144f28a45bd84ff_2.file.product-list.tpl.php:37 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67d29bb9ba1aa1_86791724) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/electroniclayouts_layout_left_column_tpl/2e/31/04/2e31043655244529250d3ab63cd19ec4683e9b94_2.file.category.tpl.php:34 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67d29bb9b965b7_79755520) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/Smarty/SmartyDev.php:40 (fetch) /classes/controller/FrontController.php:760 (fetch) /classes/controller/FrontController.php:742 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)

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

Bestseller Products

Useful info

Billing for EU countries

Home

Refine Search

Brother TZe-415 compatible laminated label tape, 6 mm wide, white print on red background for Brother P-Touch thermal printers

Brother TZe-425 compatible laminated label tape, width 9 mm for Brother P-Touch printers, white printing on red background

Brother TZe-435 compatible label tape cassette, 12 mm wide, white print on red background for Brother P-Touch printers

Compatible laminated label tape TZe-515, 6 mm width, white print on blue background for Brother P-Touch thermal printers

Laminated label tape compatible with Brother TZe-535, 12 mm width, white print on blue background for Brother P-Touch printers

Compatible Brother TZe-545 laminated tape, 18 mm width for Brother P-Touch printers, white print on blue background

Compatible Brother TZe-445 laminated tape, 18 mm width for Brother P-Touch printers, white print on red background

Compatible Brother TZe-725 laminated label tape, 9 mm width, white print on green background for Brother P-Touch printers

Compatible Brother TZe-735 laminated label tape, 12 mm width, white print on green background for Brother P-Touch printers

Laminate label tape cassette compatible with TZe-745, 18 mm width, white print on green background for Brother P-Touch printers

Laminated label tape compatible with Brother TZe-525, width 9 mm, white print on blue background for Brother P-Touch thermal printers

Brother TZe-715 compatible laminated label tape, 6 mm wide, white print on green background for Brother P-Touch thermal printers

Thermal and classic printers supplies shop

My account

My account

Terms and conditions

Terms and conditions

Useful information

Useful information

Contact us

Contact us

Payment Options