New Arrivals

Bellerina hanging lamp, frilly shade,...

The BALLERINA lamp uses a very fashionable combination of lampshade and wood in lamps intended for residential and commercial spaces. In the BALLERINA lamp, the lampshade is made of plastic, shaped in the form of a fanciful ruffle resembling a swirling dancer's skirt. The use of a cable allows you to adjust the suspension height, and the E27 socket used allows a lot of scope when choosing the power and color of the light source. This Lamp is available as a single pendant or with 3 light shades on rectangle base. This interesting design will work well as lighting for living rooms, dining rooms, kitchens, but also as a lamp for rooms in hotels and guesthouses, where the unbreakable lampshade will be an advantage.

€28.04

Ballerina hanging lamp, 3 lights, frilled...

The BALLERINA lamp uses a very fashionable combination of lampshade and wood in lamps intended for residential and commercial premises. In the BALERINA lamp, the lampshade is made of plastic, shaped in the form of a fancy frill resembling a dancer's swirling skirt. The use of a cable allows you to adjust the height of the suspension, and the E27 base used gives a lot of room to maneuver when choosing the power and color of the light source. The Ballerina lamp is available in a version with one lampshade, or three lampshades on a beam.

This interesting design will work well as lighting for residential rooms, dining rooms, kitchens, but also as a lamp for rooms in hotels, guesthouses, where the unbreakable lampshade will be a big advantage.

€55.68

Load Time	854 ms
Querying Time	289 ms
Queries	245
Memory Peak Usage	9.6 Mb
Included Files	922 files - 9.98 Mb
PrestaShop Cache	- Mb
Global vars	0.03 Mb
- global $_SERVER	8k
- global $context	4k
- global $exportPhpConfigFile	4k
- global $__composer_autoload_files	3k
- global $config	3k
- global $_COOKIE	2k
- global $_REQUEST	2k
- global $_ENV	1k

PrestaShop Version	8.2.0
PHP Version	8.1.32
MySQL Version	10.5.17-MariaDB
Memory Limit	8192M
Max Execution Time	3000s
Smarty Cache	enabled
Smarty Compilation	auto

	Time	Cumulated Time	Memory Usage	Memory Peak Usage
config	16.540 ms	16.540 ms	3.23 Mb	3.2 Mb
__construct	0.018 ms	16.558 ms	- Mb	3.2 Mb
init	25.720 ms	42.278 ms	0.68 Mb	4.0 Mb
checkAccess	0.001 ms	42.279 ms	- Mb	4.0 Mb
setMedia	2.115 ms	44.394 ms	0.03 Mb	4.0 Mb
postProcess	0.001 ms	44.395 ms	- Mb	4.0 Mb
initHeader	0.001 ms	44.396 ms	- Mb	4.0 Mb
initContent	291.945 ms	336.341 ms	2.80 Mb	6.8 Mb
initFooter	0.001 ms	336.342 ms	- Mb	6.8 Mb
display	517.658 ms	854 ms	2.61 Mb	9.6 Mb

Hook	Time	Memory Usage
DisplayHeader	17.962 ms	0.12 Mb
=> ps_shoppingcart	0.096 ms	- Mb
=> cp_imageslider	0.303 ms	- Mb
=> cp_categorylist	0.215 ms	- Mb
=> cp_categoryproductsslider	0.289 ms	- Mb
=> prettyurls	1.009 ms	0.02 Mb
=> rcpgtagmanager	12.205 ms	0.09 Mb
=> ps_imageslider	0.456 ms	- Mb
=> ps_googleanalytics	0.230 ms	- Mb
=> securitypro	2.951 ms	- Mb
=> cp_sideverticalmenu	0.208 ms	- Mb
displayHeaderCenter	11.247 ms	0.57 Mb
=> cp_blocksearch (widget)	11.247 ms	0.57 Mb
displayHeaderRight	11.002 ms	0.19 Mb
=> cp_sideverticalmenu (widget)	1.394 ms	0.06 Mb
=> cp_blocksearch (widget)	1.005 ms	0.01 Mb
=> ps_customeraccountlinks (widget)	1.204 ms	0.05 Mb
=> ps_shoppingcart (widget)	7.399 ms	0.07 Mb
DisplayBeforeBodyClosingTag	6.918 ms	0.35 Mb
=> statsdata	1.059 ms	0.11 Mb
=> rcpgtagmanager	3.951 ms	0.16 Mb
=> ps_googleanalytics	1.908 ms	0.08 Mb
displayLeftColumnProduct	3.527 ms	0.09 Mb
=> ps_categorytree (widget)	3.527 ms	0.09 Mb
DisplayCpHoverImage	3.094 ms	0.09 Mb
=> cp_imagehover	1.811 ms	0.04 Mb
=> cp_imagehover	1.283 ms	0.04 Mb
displayFooter	3.011 ms	0.22 Mb
=> ps_linklist (widget)	1.123 ms	0.06 Mb
=> cp_parallaximages (widget)	0.997 ms	0.05 Mb
=> cp_themeoptions (widget)	0.891 ms	0.11 Mb
Header	2.780 ms	0.11 Mb
=> payu	0.005 ms	0.06 Mb
=> cp_blocksearch	0.991 ms	- Mb
=> cp_salenotification	0.311 ms	- Mb
=> cp_themeoptions	0.902 ms	0.01 Mb
=> xmlfeeds	0.571 ms	0.04 Mb
displayFooterleft	2.357 ms	0.11 Mb
=> ps_contactinfo (widget)	1.223 ms	0.06 Mb
=> ps_socialfollow (widget)	1.134 ms	0.05 Mb
ProductSearchProvider	1.909 ms	- Mb
=> ps_facetedsearch	1.909 ms	- Mb
displayNavFullWidth	1.247 ms	0.06 Mb
=> ps_mainmenu (widget)	1.247 ms	0.06 Mb
displayFooterAfter	0.869 ms	0.05 Mb
=> cp_footercms1 (widget)	0.869 ms	0.05 Mb
ActionDispatcher	0.762 ms	- Mb
=> securitypro	0.762 ms	- Mb
ActionDispatcherBefore	0.593 ms	0.01 Mb
=> ps_mbo	0.593 ms	0.01 Mb
DisplayLeftColumnProduct	0.426 ms	0.02 Mb
=> ps_facetedsearch	0.426 ms	0.02 Mb
ActionFrontControllerSetMedia	0.361 ms	- Mb
=> ps_emailalerts	0.207 ms	- Mb
=> ps_socialfollow	0.154 ms	- Mb
DisplayProductPriceBlock	0.014 ms	- Mb
=> payu	0.006 ms	- Mb
=> payu	0.002 ms	- Mb
=> payu	0.001 ms	- Mb
=> payu	0.003 ms	- Mb
=> payu	0.001 ms	- Mb
=> payu	0.001 ms	- Mb
DisplayFooter	0.011 ms	- Mb
=> securitypro	0.007 ms	- Mb
=> cp_salenotification	0.004 ms	- Mb
DisplayTop	0.008 ms	- Mb
=> pagesnotfound	0.008 ms	- Mb
DisplayFooterAfter	0.004 ms	- Mb
=> cp_themeoptions	0.004 ms	- Mb
ModuleRoutes	0.003 ms	- Mb
=> simpleimportproduct	0.003 ms	- Mb
=> simpleimportproduct	0.000 ms	- Mb
21 hook(s)	68.105 ms	1.99 Mb

Module	Time	Memory Usage
simpleimportproduct	3.006 ms	- Mb
__construct	3.001 ms	- Mb
hookModuleRoutes	0.004 ms	- Mb
hookModuleRoutes	0.001 ms	- Mb
ps_mbo	7.963 ms	0.11 Mb
__construct	7.367 ms	0.10 Mb
hookActionDispatcherBefore	0.596 ms	0.01 Mb
securitypro	4.978 ms	0.08 Mb
__construct	1.252 ms	0.07 Mb
hookActionDispatcher	0.764 ms	- Mb
hookDisplayHeader	2.954 ms	- Mb
hookDisplayFooter	0.008 ms	- Mb
ps_emailalerts	0.515 ms	0.01 Mb
__construct	0.307 ms	0.01 Mb
hookActionFrontControllerSetMedia	0.208 ms	- Mb
ps_socialfollow	1.573 ms	0.06 Mb
__construct	0.282 ms	0.01 Mb
hookActionFrontControllerSetMedia	0.155 ms	- Mb
displayFooterleft	1.136 ms	0.05 Mb
ps_shoppingcart	7.762 ms	0.07 Mb
__construct	0.262 ms	0.01 Mb
hookDisplayHeader	0.097 ms	- Mb
displayHeaderRight	7.403 ms	0.07 Mb
cp_imageslider	0.575 ms	0.01 Mb
__construct	0.271 ms	0.01 Mb
hookDisplayHeader	0.304 ms	- Mb
cp_categorylist	0.473 ms	0.01 Mb
__construct	0.257 ms	0.01 Mb
hookDisplayHeader	0.216 ms	- Mb
cp_categoryproductsslider	0.564 ms	0.01 Mb
__construct	0.274 ms	0.01 Mb
hookDisplayHeader	0.290 ms	- Mb
prettyurls	1.341 ms	0.03 Mb
__construct	0.331 ms	0.01 Mb
hookDisplayHeader	1.010 ms	0.02 Mb
payu	1.380 ms	0.12 Mb
__construct	1.354 ms	0.05 Mb
hookHeader	0.006 ms	0.06 Mb
hookDisplayProductPriceBlock	0.009 ms	- Mb
hookDisplayProductPriceBlock	0.002 ms	- Mb
hookDisplayProductPriceBlock	0.001 ms	- Mb
hookDisplayProductPriceBlock	0.004 ms	- Mb
hookDisplayProductPriceBlock	0.002 ms	- Mb
hookDisplayProductPriceBlock	0.002 ms	- Mb
rcpgtagmanager	17.141 ms	0.26 Mb
__construct	0.980 ms	0.01 Mb
hookDisplayHeader	12.208 ms	0.09 Mb
hookDisplayBeforeBodyClosingTag	3.953 ms	0.16 Mb
ps_imageslider	0.706 ms	0.01 Mb
__construct	0.248 ms	0.01 Mb
hookDisplayHeader	0.458 ms	- Mb
ps_googleanalytics	2.470 ms	0.09 Mb
__construct	0.327 ms	0.01 Mb
hookDisplayHeader	0.232 ms	- Mb
hookDisplayBeforeBodyClosingTag	1.911 ms	0.08 Mb
cp_blocksearch	13.529 ms	0.59 Mb
__construct	0.279 ms	0.01 Mb
hookHeader	0.993 ms	- Mb
displayHeaderCenter	11.250 ms	0.57 Mb
displayHeaderRight	1.007 ms	0.01 Mb
cp_sideverticalmenu	1.984 ms	0.07 Mb
__construct	0.378 ms	0.01 Mb
hookDisplayHeader	0.210 ms	- Mb
displayHeaderRight	1.396 ms	0.06 Mb
cp_salenotification	0.422 ms	0.01 Mb
__construct	0.106 ms	0.01 Mb
hookHeader	0.312 ms	- Mb
hookDisplayFooter	0.004 ms	- Mb
cp_themeoptions	2.342 ms	0.15 Mb
__construct	0.541 ms	0.03 Mb
hookHeader	0.904 ms	0.01 Mb
displayFooter	0.892 ms	0.11 Mb
hookDisplayFooterAfter	0.005 ms	- Mb
xmlfeeds	0.825 ms	0.04 Mb
__construct	0.252 ms	0.01 Mb
hookHeader	0.573 ms	0.04 Mb
ps_facetedsearch	4.508 ms	0.04 Mb
__construct	2.169 ms	0.01 Mb
hookProductSearchProvider	1.912 ms	- Mb
hookDisplayLeftColumnProduct	0.427 ms	0.02 Mb
ps_customeraccountlinks	1.495 ms	0.06 Mb
__construct	0.289 ms	0.01 Mb
displayHeaderRight	1.206 ms	0.05 Mb
pagesnotfound	0.286 ms	0.01 Mb
__construct	0.277 ms	0.01 Mb
hookDisplayTop	0.009 ms	- Mb
ps_mainmenu	1.529 ms	0.07 Mb
__construct	0.280 ms	0.01 Mb
displayNavFullWidth	1.249 ms	0.06 Mb
ps_categorytree	3.743 ms	0.10 Mb
__construct	0.214 ms	0.01 Mb
displayLeftColumnProduct	3.529 ms	0.09 Mb
cp_imagehover	3.337 ms	0.09 Mb
__construct	0.240 ms	0.01 Mb
hookDisplayCpHoverImage	1.813 ms	0.04 Mb
hookDisplayCpHoverImage	1.284 ms	0.04 Mb
ps_contactinfo	1.488 ms	0.07 Mb
__construct	0.263 ms	0.01 Mb
displayFooterleft	1.225 ms	0.06 Mb
ps_linklist	2.093 ms	0.16 Mb
__construct	0.968 ms	0.09 Mb
displayFooter	1.125 ms	0.07 Mb
cp_parallaximages	1.195 ms	0.06 Mb
__construct	0.196 ms	0.01 Mb
displayFooter	0.999 ms	0.05 Mb
cp_footercms1	1.053 ms	0.05 Mb
__construct	0.183 ms	0.01 Mb
displayFooterAfter	0.870 ms	0.05 Mb
statsdata	1.221 ms	0.11 Mb
__construct	0.160 ms	0.01 Mb
hookDisplayBeforeBodyClosingTag	1.061 ms	0.11 Mb
30 module(s)	91.498 ms	2.50 Mb

Your account

New Arrivals

Contact us

Products

Our company

Stopwatch SQL - 245 queries

Doubles

Tables stress

ObjectModel instances

Included Files

18 queries	SELECT `id_module` FROM `ps_module_shop` WHERE `id_module` = XX AND `id_shop` = XX LIMIT XX
11 queries	SELECT * FROM `ps_category` a LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = XX LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = XX WHERE (a.`id_category` = XX) AND (b.`id_shop` = XX) LIMIT XX
11 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
10 queries	SELECT c., cl. FROM `ps_category` c LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND `id_lang` = XX AND cl.id_shop = XX ) LEFT JOIN `ps_category_shop` cs ON (c.`id_category` = cs.`id_category` AND cs.`id_shop` = XX) WHERE c.`id_category` = XX AND cs.`id_shop` = XX AND c.`id_parent` != XX
9 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
4 queries	SELECT `id_lang` FROM `ps_lang` WHERE `locale` = 'en-us' OR `language_code` = 'en-us' LIMIT XX
4 queries	SELECT fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM ps_product p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, XX) = sa.id_product_attribute AND sa.id_shop_group = XX AND sa.id_shop = XX ) LEFT JOIN ps_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = XX AND ps.active = TRUE) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=XX) LEFT JOIN ps_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN ps_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN ps_feature_product fp_XX ON (p.id_product = fp_XX.id_product) LEFT JOIN ps_feature_product fp_XX ON (p.id_product = fp_XX.id_product) WHERE ((fp.id_feature_value IN (XX, XX, XX, XX))) AND ((fp_XX.id_feature_value=XX)) AND ((fp_XX.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) LEFT JOIN ps_feature_product fp_XX ON (p.id_product = fp_XX.id_product) LEFT JOIN ps_feature_product fp_XX ON (p.id_product = fp_XX.id_product) WHERE ((fp.id_feature=XX)) AND ((fp_XX.id_feature_value IN (XX, XX, XX, XX))) AND ((fp_XX.id_feature_value=XX)) AND ((fp_XX.id_feature_value IN (XX, XX, XX))) GROUP BY fp.id_feature_value
4 queries	SELECT SUM(quantity) FROM `ps_stock_available` WHERE (id_product = XX) AND (id_product_attribute = XX) AND (id_shop_group = XX) AND (id_shop = XX) LIMIT XX
4 queries	SELECT COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), XX) as deep_quantity, COALESCE(SUM(first_level_quantity), XX) as quantity FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, XX as pack_quantity FROM `ps_cart_product` cp WHERE cp.`id_product_attribute` = XX AND cp.`id_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
4 queries	SELECT image_shop.`cover`, i.`id_image`, il.`legend`, i.`position` FROM `ps_image` i INNER JOIN ps_image_shop image_shop ON (image_shop.id_image = i.id_image AND image_shop.id_shop = XX) LEFT JOIN `ps_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = XX) WHERE i.`id_product` = XX ORDER BY `position`
3 queries	SELECT m.`id_module`, m.`name`, ms.`id_module`as `mshop` FROM `ps_module` m LEFT JOIN `ps_module_shop` ms ON m.`id_module` = ms.`id_module` AND ms.`id_shop` = XX
3 queries	SELECT XX FROM `ps_specific_price` WHERE id_product = XX LIMIT XX
2 queries	SELECT 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 = XX ) ORDER BY LENGTH(ml.url_rewrite) DESC
2 queries	SELECT `page` FROM ps_meta WHERE id_meta = XX LIMIT XX
2 queries	SELECT `active` FROM `ps_module` WHERE `name` = "ps_mbo" LIMIT XX
2 queries	SELECT m.`id_module` as `active`, ms.`id_module` as `shop_active` FROM `ps_module` m LEFT JOIN `ps_module_shop` ms ON m.`id_module` = ms.`id_module` WHERE `name` = "ps_mbo" LIMIT XX
2 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
2 queries	SELECT `id_category` FROM `ps_category_shop` WHERE `id_category` = XX AND `id_shop` = XX LIMIT XX
2 queries	SELECT `need_identification_number` FROM `ps_country` WHERE `id_country` = XX LIMIT XX
2 queries	SELECT c.`nleft`, c.`nright` FROM `ps_category` c LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND `id_lang` = XX AND cl.id_shop = XX ) LEFT JOIN `ps_category_shop` cs ON (c.`id_category` = cs.`id_category` AND cs.`id_shop` = XX) AND cs.`id_shop` = XX AND c.`id_parent` != XX WHERE c.`id_category` = XX LIMIT XX
2 queries	SELECT c.`nleft`, c.`nright` FROM `ps_category` c WHERE c.`id_category` = XX LIMIT XX
2 queries	SELECT c., cl. FROM `ps_category` c LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND `id_lang` = XX AND cl.id_shop = XX ) LEFT JOIN `ps_category_shop` cs ON (c.`id_category` = cs.`id_category` AND cs.`id_shop` = XX) AND cs.`id_shop` = XX AND c.`id_parent` != XX WHERE c.`nleft` <= XX AND c.`nright` >= XX AND c.`nleft` >= XX AND c.`nright` <= XX ORDER BY `nleft` DESC
2 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
2 queries	SELECT cl.`link_rewrite` FROM `ps_category_lang` cl WHERE `id_lang` = XX AND cl.id_shop = XX AND cl.`id_category` = XX LIMIT XX
2 queries	SELECT name FROM ps_category_lang WHERE id_shop = XX AND id_lang = XX AND id_category = XX LIMIT XX
2 queries	SELECT product_attribute_shop.`price` FROM `ps_product_attribute` pa INNER JOIN ps_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = XX) WHERE pa.`id_product_attribute` = XX LIMIT XX
2 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)
2 queries	SELECT `id_tax_rules_group` FROM `ps_product_shop` WHERE `id_product` = 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-XX' BETWEEN tr.`zipcode_from` AND tr.`zipcode_to` OR (tr.`zipcode_to` = XX AND tr.`zipcode_from` IN(XX, 'XX-XX'))) ORDER BY tr.`zipcode_from` DESC, tr.`zipcode_to` DESC, tr.`id_state` DESC, tr.`id_country` DESC
2 queries	SELECT `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = XX AND `id_group` = XX LIMIT XX
2 queries	SELECT pa.`available_date` FROM `ps_product` p LEFT JOIN `ps_product_attribute` pa ON (pa.`id_product` = p.`id_product`) INNER JOIN ps_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = XX) INNER JOIN ps_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = XX) WHERE p.`id_product` = XX AND pa.`id_product` = XX AND pa.`id_product_attribute` = XX LIMIT XX
2 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
2 queries	SELECT a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, agl.`public_name` as `public_group`, pa.`reference`, pa.`eanXX`, pa.`isbn`, pa.`upc`, pa.`mpn`, pal.`available_now`, pal.`available_later` FROM `ps_attribute` a LEFT JOIN `ps_attribute_lang` al ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = XX) LEFT JOIN `ps_product_attribute_combination` pac ON (pac.`id_attribute` = a.`id_attribute`) LEFT JOIN `ps_product_attribute` pa ON (pa.`id_product_attribute` = pac.`id_product_attribute`) INNER JOIN ps_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = XX) LEFT JOIN `ps_product_attribute_lang` pal ON (pal.`id_product_attribute` = pac.`id_product_attribute` AND pal.`id_lang` = XX) LEFT JOIN `ps_attribute_group_lang` agl ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = XX) WHERE pa.`id_product` = XX AND pac.`id_product_attribute` = XX AND agl.`id_lang` = XX
2 queries	SELECT * FROM `ps_product_attribute` a LEFT JOIN `ps_product_attribute_shop` `c` ON a.`id_product_attribute` = c.`id_product_attribute` AND c.`id_shop` = XX WHERE (a.`id_product_attribute` = XX) LIMIT XX
2 queries	SELECT * FROM `ps_product_attribute_lang` WHERE `id_product_attribute` = XX
2 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
2 queries	SELECT `id_product_attribute` FROM `ps_product_attribute` WHERE `id_product` = XX
2 queries	SELECT pai.`id_image`, pai.`id_product_attribute`, il.`legend` FROM `ps_product_attribute_image` pai LEFT JOIN `ps_image_lang` il ON (il.`id_image` = pai.`id_image`) LEFT JOIN `ps_image` i ON (i.`id_image` = pai.`id_image`) WHERE pai.`id_product_attribute` IN (XX) AND il.`id_lang` = XX ORDER by i.`position`
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_product` a LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = XX WHERE (a.`id_product` = XX) LIMIT XX
2 queries	SELECT * FROM `ps_product_lang` WHERE `id_product` = XX AND `id_shop` = XX
2 queries	SELECT pa., product_attribute_shop. FROM `ps_product_attribute` pa INNER JOIN ps_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = XX) WHERE pa.`id_product` = XX GROUP BY pa.`id_product_attribute` ORDER BY pa.`id_product_attribute`
2 queries	SELECT pac.id_product_attribute, GROUP_CONCAT(agl.`name`, ' - ',al.`name` ORDER BY agl.`id_attribute_group` SEPARATOR ', ') as attribute_designation FROM `ps_product_attribute_combination` pac LEFT JOIN `ps_attribute` a ON a.`id_attribute` = pac.`id_attribute` LEFT JOIN `ps_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group` LEFT JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = XX) LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = XX) WHERE pac.id_product_attribute IN (XX) GROUP BY pac.id_product_attribute ORDER BY pac.id_product_attribute
2 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;
2 queries	SELECT pa., product_attribute_shop., ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, al.`name` AS attribute_name, a.`id_attribute`, a.`position` FROM `ps_product_attribute` pa INNER JOIN ps_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = XX) LEFT JOIN `ps_product_attribute_combination` pac ON pac.`id_product_attribute` = pa.`id_product_attribute` LEFT JOIN `ps_attribute` a ON a.`id_attribute` = pac.`id_attribute` LEFT JOIN `ps_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group` LEFT JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = XX) LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = XX) WHERE pa.`id_product` = XX AND pa.`id_product_attribute` = XX GROUP BY pa.`id_product_attribute`,ag.`id_attribute_group` ORDER BY pa.`id_product_attribute`
2 queries	SELECT al.`name` AS attribute_name FROM `ps_product_attribute_combination` pac LEFT JOIN `ps_attribute` a ON a.`id_attribute` = pac.`id_attribute` LEFT JOIN `ps_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group` LEFT JOIN `ps_attribute_lang` al ON ( a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = XX ) WHERE pac.`id_product_attribute` = XX ORDER BY ag.`position` ASC, a.`position` ASC

Name	Instances	Source
Category	45	/controllers/front/listing/CategoryController.php:78 (__construct) [id: 46] /override/classes/Link.php:111 (getRootCategory) [id: 2] /override/classes/Link.php:111 (getRootCategory) [id: 2] /classes/Meta.php:380 (__construct) [id: 46] /override/classes/Link.php:111 (getRootCategory) [id: 2] /override/classes/Link.php:111 (getRootCategory) [id: 2] /classes/PrestaShopCollection.php:385 (hydrateCollection) [id: ] /classes/PrestaShopCollection.php:385 (hydrateCollection) [id: ] /override/classes/Link.php:111 (getRootCategory) [id: 2] /override/classes/Link.php:111 (getRootCategory) [id: 2] /classes/Meta.php:380 (__construct) [id: 46] /override/classes/Link.php:111 (getRootCategory) [id: 2] /override/classes/Link.php:111 (getRootCategory) [id: 2] /modules/rcpgtagmanager/src/PSModule/DataModelHandler/ModelBuilder/Category/AbstractCategoryModelBuilder.php:39 (__construct) [id: 46] /modules/rcpgtagmanager/src/PSModule/DataModelHandler/ModelBuilder/Category/AbstractCategoryModelBuilder.php:56 (getParentsCategories) [id: 2] /modules/ps_facetedsearch/src/Product/Search.php:364 (__construct) [id: 46] /modules/cp_blocksearch/cp_blocksearch.php:167 (__construct) [id: 1] /modules/cp_blocksearch/cp_blocksearch.php:167 (__construct) [id: 2] /modules/cp_blocksearch/cp_blocksearch.php:167 (__construct) [id: 31] /modules/cp_blocksearch/cp_blocksearch.php:167 (__construct) [id: 19] /modules/cp_blocksearch/cp_blocksearch.php:167 (__construct) [id: 20] /modules/cp_blocksearch/cp_blocksearch.php:167 (__construct) [id: 21] /modules/cp_blocksearch/cp_blocksearch.php:167 (__construct) [id: 22] /modules/cp_blocksearch/cp_blocksearch.php:167 (__construct) [id: 23] /modules/cp_blocksearch/cp_blocksearch.php:167 (__construct) [id: 24] /modules/cp_blocksearch/cp_blocksearch.php:167 (__construct) [id: 46] /modules/cp_blocksearch/cp_blocksearch.php:167 (__construct) [id: 47] /modules/cp_blocksearch/cp_blocksearch.php:167 (__construct) [id: 1] /modules/cp_blocksearch/cp_blocksearch.php:167 (__construct) [id: 2] /modules/cp_blocksearch/cp_blocksearch.php:167 (__construct) [id: 31] /modules/cp_blocksearch/cp_blocksearch.php:167 (__construct) [id: 19] /modules/cp_blocksearch/cp_blocksearch.php:167 (__construct) [id: 20] /modules/cp_blocksearch/cp_blocksearch.php:167 (__construct) [id: 21] /modules/cp_blocksearch/cp_blocksearch.php:167 (__construct) [id: 22] /modules/cp_blocksearch/cp_blocksearch.php:167 (__construct) [id: 23] /modules/cp_blocksearch/cp_blocksearch.php:167 (__construct) [id: 24] /modules/cp_blocksearch/cp_blocksearch.php:167 (__construct) [id: 46] /modules/cp_blocksearch/cp_blocksearch.php:167 (__construct) [id: 47] /modules/ps_categorytree/ps_categorytree.php:338 (__construct) [id: 46] /override/classes/Link.php:35 (__construct) [id: 46] /override/classes/Link.php:111 (getRootCategory) [id: 2] /override/classes/Link.php:111 (getRootCategory) [id: 2] /modules/rcpgtagmanager/src/PSModule/DataModelHandler/ModelBuilder/Category/AbstractCategoryModelBuilder.php:39 (__construct) [id: 21] /modules/rcpgtagmanager/src/PSModule/DataModelHandler/ModelBuilder/Category/AbstractCategoryModelBuilder.php:56 (getParentsCategories) [id: 2] /modules/rcpgtagmanager/src/PSModule/DataModelHandler/ModelBuilder/Category/AbstractCategoryModelBuilder.php:39 (__construct) [id: 21]
Product	12	/src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 614] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 629] /classes/Link.php:113 (__construct) [id: 614] /classes/Link.php:113 (__construct) [id: 629] /modules/cp_imagehover/cp_imagehover.php:69 (__construct) [id: 614] /src/Adapter/Presenter/Product/ProductLazyArray.php:662 (__construct) [id: 614] /classes/Link.php:113 (__construct) [id: 614] /modules/cp_imagehover/cp_imagehover.php:69 (__construct) [id: 629] /src/Adapter/Presenter/Product/ProductLazyArray.php:662 (__construct) [id: 629] /classes/Link.php:113 (__construct) [id: 629] /modules/rcpgtagmanager/src/PSModule/DataModelHandler/ModelBuilder/Product/AbstractProductModelBuilder.php:51 (__construct) [id: 614] /modules/rcpgtagmanager/src/PSModule/DataModelHandler/ModelBuilder/Product/AbstractProductModelBuilder.php:51 (__construct) [id: 629]
Country	5	/config/config.inc.php:146 (__construct) [id: 14] /classes/AddressFormat.php:404 (__construct) [id: 14] /classes/controller/FrontController.php:1779 (__construct) [id: 14] /classes/AddressFormat.php:404 (__construct) [id: 14] /modules/ps_contactinfo/ps_contactinfo.php:104 (__construct) [id: 14]
Address	4	/classes/shop/Shop.php:486 (__construct) [id: ] /classes/Product.php:3694 (initialize) [id: ] /classes/Product.php:3804 (__construct) [id: ] /classes/Product.php:5964 (__construct) [id: ]
Currency	3	/src/Adapter/Currency/CurrencyDataProvider.php:101 (__construct) [id: 1] /src/Adapter/Currency/CurrencyDataProvider.php:101 (__construct) [id: 2] /classes/Tools.php:690 (getCurrencyInstance) [id: 1]
AddressFormat	2	/classes/controller/FrontController.php:1773 (generateAddress) [id: ] /modules/ps_contactinfo/ps_contactinfo.php:98 (generateAddress) [id: ]
Language	2	/config/config.inc.php:211 (__construct) [id: 1] /classes/Tools.php:560 (__construct) [id: 1]
Combination	2	/classes/Product.php:5912 (__construct) [id: 727] /classes/Product.php:5912 (__construct) [id: 742]
Cart	2	/classes/controller/FrontController.php:467 (__construct) [id: ] /classes/controller/FrontController.php:541 (__construct) [id: ]
Tax	2	/classes/tax/TaxRulesTaxManager.php:116 (__construct) [id: 35] /classes/tax/TaxRulesTaxManager.php:116 (__construct) [id: 35]
State	2	/classes/controller/FrontController.php:1778 (__construct) [id: 0] /modules/ps_contactinfo/ps_contactinfo.php:93 (__construct) [id: 0]
Shop	1	/config/config.inc.php:117 (initialize) [id: 2]
Gender	1	/classes/controller/FrontController.php:1702 (__construct) [id: 0]
Risk	1	/classes/controller/FrontController.php:1705 (__construct) [id: ]
Group	1	/classes/Cart.php:249 (getCurrent) [id: 1]
Customer	1	/config/config.inc.php:264 (__construct) [id: ]
ShopGroup	1	/classes/shop/Shop.php:561 (__construct) [id: 1]
ConnectionsSource	1	/modules/statsdata/statsdata.php:119 (logHttpReferer) [id: ]

#	Query	Time (ms)	Rows	Filesort	Group By	Location
113	SELECT SQL_NO_CACHE fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM ps_product p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop_group = 1 AND sa.id_shop = 0 ) LEFT JOIN ps_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 2 AND ps.active = TRUE) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN ps_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN ps_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN ps_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((fp.id_feature_value IN (54, 56, 53, 57))) AND ((fp_1.id_feature_value=22)) AND ((fp_2.id_feature_value IN (32, 33, 34))) AND ps.id_shop='2' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=17 AND c.nright<=18 GROUP BY p.id_product) p INNER JOIN ps_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN ps_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN ps_feature_product fp_2 ON (p.id_product = fp_2.id_product) LEFT JOIN ps_feature_product fp_3 ON (p.id_product = fp_3.id_product) WHERE ((fp.id_feature=11)) AND ((fp_1.id_feature_value IN (54, 56, 53, 57))) AND ((fp_2.id_feature_value=22)) AND ((fp_3.id_feature_value IN (32, 33, 34))) GROUP BY fp.id_feature_value	27.257 ms	19208	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 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, cp.position FROM ps_product p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop_group = 1 AND sa.id_shop = 0 ) LEFT JOIN ps_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 2 AND ps.active = TRUE) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN ps_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN ps_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN ps_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((fp.id_feature_value IN (54, 56, 53, 57))) AND ((fp_1.id_feature_value=22)) AND ((fp_2.id_feature_value IN (32, 33, 34))) AND ps.id_shop='2' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=17 AND c.nright<=18 GROUP BY p.id_product) p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) INNER JOIN ps_attribute a ON (a.id_attribute = pac.id_attribute) LEFT JOIN ps_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN ps_feature_product fp_2 ON (p.id_product = fp_2.id_product) LEFT JOIN ps_feature_product fp_3 ON (p.id_product = fp_3.id_product) WHERE ((a.id_attribute_group=2)) AND ((fp_1.id_feature_value IN (54, 56, 53, 57))) AND ((fp_2.id_feature_value=22)) AND ((fp_3.id_feature_value IN (32, 33, 34))) GROUP BY pac.id_attribute	26.919 ms	19208	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)
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, cp.position FROM ps_product p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop_group = 1 AND sa.id_shop = 0 ) LEFT JOIN ps_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 2 AND ps.active = TRUE) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN ps_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN ps_feature_product fp_1 ON (p.id_product = fp_1.id_product) WHERE ((fp.id_feature_value IN (54, 56, 53, 57))) AND ((fp_1.id_feature_value IN (32, 33, 34))) AND ps.id_shop='2' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=17 AND c.nright<=18 GROUP BY p.id_product) p INNER JOIN ps_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN ps_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN ps_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((fp.id_feature=6)) AND ((fp_1.id_feature_value IN (54, 56, 53, 57))) AND ((fp_2.id_feature_value IN (32, 33, 34))) GROUP BY fp.id_feature_value	26.536 ms	1527036	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)
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, cp.position FROM ps_product p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop_group = 1 AND sa.id_shop = 0 ) LEFT JOIN ps_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 2 AND ps.active = TRUE) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN ps_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN ps_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN ps_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((fp.id_feature_value IN (54, 56, 53, 57))) AND ((fp_1.id_feature_value=22)) AND ((fp_2.id_feature_value IN (32, 33, 34))) AND ps.id_shop='2' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=17 AND c.nright<=18 GROUP BY p.id_product) p INNER JOIN ps_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN ps_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN ps_feature_product fp_2 ON (p.id_product = fp_2.id_product) LEFT JOIN ps_feature_product fp_3 ON (p.id_product = fp_3.id_product) WHERE ((fp.id_feature=7)) AND ((fp_1.id_feature_value IN (54, 56, 53, 57))) AND ((fp_2.id_feature_value=22)) AND ((fp_3.id_feature_value IN (32, 33, 34))) GROUP BY fp.id_feature_value	26.079 ms	19208	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)
109	SELECT SQL_NO_CACHE fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM ps_product p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop_group = 1 AND sa.id_shop = 0 ) LEFT JOIN ps_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 2 AND ps.active = TRUE) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN ps_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN ps_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN ps_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((fp.id_feature_value IN (54, 56, 53, 57))) AND ((fp_1.id_feature_value=22)) AND ((fp_2.id_feature_value IN (32, 33, 34))) AND ps.id_shop='2' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=17 AND c.nright<=18 GROUP BY p.id_product) p INNER JOIN ps_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN ps_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN ps_feature_product fp_2 ON (p.id_product = fp_2.id_product) LEFT JOIN ps_feature_product fp_3 ON (p.id_product = fp_3.id_product) WHERE ((fp.id_feature=8)) AND ((fp_1.id_feature_value IN (54, 56, 53, 57))) AND ((fp_2.id_feature_value=22)) AND ((fp_3.id_feature_value IN (32, 33, 34))) GROUP BY fp.id_feature_value	25.926 ms	19208	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, cp.position FROM ps_product p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop_group = 1 AND sa.id_shop = 0 ) LEFT JOIN ps_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 2 AND ps.active = TRUE) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN ps_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN ps_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN ps_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((fp.id_feature_value IN (54, 56, 53, 57))) AND ((fp_1.id_feature_value=22)) AND ((fp_2.id_feature_value IN (32, 33, 34))) AND ps.id_shop='2' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=17 AND c.nright<=18 GROUP BY p.id_product) p INNER JOIN ps_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN ps_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN ps_feature_product fp_2 ON (p.id_product = fp_2.id_product) LEFT JOIN ps_feature_product fp_3 ON (p.id_product = fp_3.id_product) WHERE ((fp.id_feature=22)) AND ((fp_1.id_feature_value IN (54, 56, 53, 57))) AND ((fp_2.id_feature_value=22)) AND ((fp_3.id_feature_value IN (32, 33, 34))) GROUP BY fp.id_feature_value	22.921 ms	19208	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)
111	SELECT SQL_NO_CACHE fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM ps_product p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop_group = 1 AND sa.id_shop = 0 ) LEFT JOIN ps_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 2 AND ps.active = TRUE) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN ps_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN ps_feature_product fp_1 ON (p.id_product = fp_1.id_product) WHERE ((fp.id_feature_value IN (54, 56, 53, 57))) AND ((fp_1.id_feature_value=22)) AND ps.id_shop='2' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=17 AND c.nright<=18 GROUP BY p.id_product) p INNER JOIN ps_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN ps_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN ps_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((fp.id_feature=9)) AND ((fp_1.id_feature_value IN (54, 56, 53, 57))) AND ((fp_2.id_feature_value=22)) GROUP BY fp.id_feature_value	13.899 ms	7840	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, cp.position FROM ps_product p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop_group = 1 AND sa.id_shop = 0 ) LEFT JOIN ps_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 2 AND ps.active = TRUE) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN ps_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN ps_feature_product fp_1 ON (p.id_product = fp_1.id_product) WHERE ((fp.id_feature_value=22)) AND ((fp_1.id_feature_value IN (32, 33, 34))) AND ps.id_shop='2' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=17 AND c.nright<=18 GROUP BY p.id_product) p INNER JOIN ps_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN ps_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN ps_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((fp.id_feature=21)) AND ((fp_1.id_feature_value=22)) AND ((fp_2.id_feature_value IN (32, 33, 34))) GROUP BY fp.id_feature_value	13.086 ms	392	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)
97	SELECT SQL_NO_CACHE p.id_product FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM ps_product p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop_group = 1 AND sa.id_shop = 0 ) LEFT JOIN ps_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 2 AND ps.active = TRUE) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN ps_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN ps_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN ps_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((fp.id_feature_value IN (54, 56, 53, 57))) AND ((fp_1.id_feature_value=22)) AND ((fp_2.id_feature_value IN (32, 33, 34))) AND ps.id_shop='2' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=17 AND c.nright<=18 GROUP BY p.id_product) p INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) GROUP BY p.id_product ORDER BY p.position ASC, p.id_product DESC	8.266 ms	9604	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)
197	SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "ps_shoppingcart" LIMIT 1	5.812 ms	1			/classes/module/Module.php:2659 /classes/module/Module.php:2131 (getModuleIdByName) /classes/Hook.php:1083 (isEnabled) /tools/profiling/Hook.php:64 (coreRenderWidget) /classes/Hook.php:1019 (coreRenderWidget) /config/smarty.config.inc.php:201 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/prod/smarty/compile/PRS03058layouts_layout_both_columns_tpl/3c/b8/7e/3cb87e8e8f5de7f0008d8a9e90cf1a42f8e64e47_2.file.header.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/prod/smarty/compile/PRS03058layouts_layout_both_columns_tpl/3c/b8/7e/3cb87e8e8f5de7f0008d8a9e90cf1a42f8e64e47_2.file.header.tpl.php:32 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68120eb47614c2_57805682) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /var/cache/prod/smarty/compile/PRS03058layouts_layout_both_columns_tpl/5e/c0/42/5ec042c8bb6e3bc13eeaf6212933a97916ca4da1_2.file.layout-both-columns.tpl.php:206 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/PRS03058layouts_layout_both_columns_tpl/5e/c0/42/5ec042c8bb6e3bc13eeaf6212933a97916ca4da1_2.file.layout-both-columns.tpl.php:58 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68120eb4704de7_04032364) /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/prod/smarty/compile/PRS03058layouts_layout_both_columns_tpl/1a/51/f0/1a51f047462402a7b59c4d31f66c6692b83d6b5b_2.file.product-list.tpl.php:43 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68120eb46fa030_79561080) /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/prod/smarty/compile/PRS03058layouts_layout_both_columns_tpl/64/73/8b/64738b7bcd80a55751ecd0dcb888bbcd93fe595e_2.file.category.tpl.php:34 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68120eb46f1ea5_03428982) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/controller/FrontController.php:771 (fetch) /classes/controller/FrontController.php:753 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
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`)	5.709 ms	1582			/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)
123	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	3.109 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:5692 (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)
15	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 = 2 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` = 2) AND (mg.id_shop = 2 AND mg.`id_group` IN (1)) GROUP BY hm.id_hook, hm.id_module ORDER BY hm.`position`	3.083 ms	712	Yes	Yes	/classes/Hook.php:1267 /classes/Hook.php:735 (getAllHookRegistrations) /classes/Hook.php:842 (getHookModuleExecList) /override/classes/Dispatcher.php:180 (exec) /classes/Dispatcher.php:243 (loadRoutes) /override/classes/Dispatcher.php:30 (__construct) /classes/Dispatcher.php:201 (__construct) /index.php:28 (getInstance)
98	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 = 2 AND psi.id_currency = 1 AND psi.id_country = 14) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 2 AND ps.active = TRUE) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN ps_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN ps_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN ps_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((fp.id_feature_value IN (54, 56, 53, 57))) AND ((fp_1.id_feature_value=22)) AND ((fp_2.id_feature_value IN (32, 33, 34))) AND ps.id_shop='2' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=17 AND c.nright<=18	2.549 ms	98			/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)
124	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 = 2) STRAIGHT_JOIN `ps_module` as m ON (m.id_module = hm.id_module) ORDER BY hm.position	2.278 ms	498			/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:5692 (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)
24	SELECT SQL_NO_CACHE `id_product` FROM ps_product_lang WHERE `link_rewrite` = "new-arrivals" AND `id_lang` = 1 AND `id_shop` = 2 LIMIT 1	1.979 ms	607			/override/classes/Dispatcher.php:1424 /override/classes/Dispatcher.php:347 (getProductExistance) /classes/Dispatcher.php:346 (getController) /index.php:28 (dispatch)
204	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 = 2 ) INNER JOIN `ps_category_shop` cs ON (cs.`id_category` = c.`id_category` AND cs.`id_shop` = 2) WHERE (c.`active` = 1 OR c.`id_category` = 2) AND c.`id_category` != 1 AND `level_depth` <= 6 AND nleft >= 17 AND nright <= 18 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	1.417 ms	2	Yes		/modules/ps_categorytree/ps_categorytree.php:166 /modules/ps_categorytree/ps_categorytree.php:350 (getCategories) /modules/ps_categorytree/ps_categorytree.php:330 (getWidgetVariables) /classes/Hook.php:1088 (renderWidget) /tools/profiling/Hook.php:64 (coreRenderWidget) /classes/Hook.php:1019 (coreRenderWidget) /config/smarty.config.inc.php:201 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/prod/smarty/compile/PRS03058layouts_layout_both_columns_tpl/5e/c0/42/5ec042c8bb6e3bc13eeaf6212933a97916ca4da1_2.file.layout-both-columns.tpl.php:286 (__call) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/PRS03058layouts_layout_both_columns_tpl/5e/c0/42/5ec042c8bb6e3bc13eeaf6212933a97916ca4da1_2.file.layout-both-columns.tpl.php:95 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68120eb4704de7_04032364) /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/prod/smarty/compile/PRS03058layouts_layout_both_columns_tpl/1a/51/f0/1a51f047462402a7b59c4d31f66c6692b83d6b5b_2.file.product-list.tpl.php:43 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68120eb46fa030_79561080) /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/prod/smarty/compile/PRS03058layouts_layout_both_columns_tpl/64/73/8b/64738b7bcd80a55751ecd0dcb888bbcd93fe595e_2.file.category.tpl.php:34 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68120eb46f1ea5_03428982) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/controller/FrontController.php:771 (fetch) /classes/controller/FrontController.php:753 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
17	SELECT SQL_NO_CACHE `id_hook`, `name` FROM `ps_hook`	1.159 ms	1073			/classes/Hook.php:1326 /classes/Hook.php:225 (getAllHookIds) /classes/Hook.php:851 (getIdByName) /override/classes/Dispatcher.php:180 (exec) /classes/Dispatcher.php:243 (loadRoutes) /override/classes/Dispatcher.php:30 (__construct) /classes/Dispatcher.php:201 (__construct) /index.php:28 (getInstance)
90	SELECT SQL_NO_CACHE DISTINCT f.id_feature, f., fl., IF(liflv.`url_name` IS NULL OR liflv.`url_name` = "", NULL, liflv.`url_name`) AS url_name, IF(liflv.`meta_title` IS NULL OR liflv.`meta_title` = "", NULL, liflv.`meta_title`) AS meta_title, lif.indexable FROM `ps_feature` f INNER JOIN ps_feature_shop feature_shop ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 2) LEFT JOIN `ps_feature_lang` fl ON (f.`id_feature` = fl.`id_feature` AND fl.`id_lang` = 1) LEFT JOIN `ps_layered_indexable_feature` lif ON (f.`id_feature` = lif.`id_feature`) LEFT JOIN `ps_layered_indexable_feature_lang_value` liflv ON (f.`id_feature` = liflv.`id_feature` AND liflv.`id_lang` = 1) ORDER BY f.`position` ASC	0.927 ms	900	Yes		/modules/ps_facetedsearch/src/Filters/DataAccessor.php:171 /modules/ps_facetedsearch/src/Filters/Converter.php:388 (getFeatures) /modules/ps_facetedsearch/src/Product/SearchProvider.php:163 (createFacetedSearchFiltersFromQuery) /classes/controller/ProductListingFrontController.php:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
14	SELECT SQL_NO_CACHE lower(name) as name FROM `ps_hook` h WHERE (h.active = 1)	0.896 ms	1073			/classes/Hook.php:1366 /classes/Hook.php:811 (getHookStatusByName) /override/classes/Dispatcher.php:180 (exec) /classes/Dispatcher.php:243 (loadRoutes) /override/classes/Dispatcher.php:30 (__construct) /classes/Dispatcher.php:201 (__construct) /index.php:28 (getInstance)
65	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 = 2) LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND `id_lang` = 1 AND cl.id_shop = 2 ) LEFT JOIN `ps_category_group` cg ON (cg.`id_category` = c.`id_category`) WHERE `id_parent` = 46 AND `active` = 1 AND cg.`id_group` =1 GROUP BY c.`id_category` ORDER BY `level_depth` ASC, category_shop.`position` ASC	0.845 ms	1	Yes	Yes	/classes/Category.php:924 /controllers/front/listing/CategoryController.php:230 (getSubCategories) /controllers/front/listing/CategoryController.php:118 (getTemplateVarSubCategories) /override/controllers/front/CategoryController.php:57 (init) /tools/profiling/Controller.php:41 (init) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
149	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` = 629 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` = 629 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1	0.811 ms	0			/classes/Cart.php:1430 /classes/Product.php:4361 (getProductQuantity) /classes/Product.php:5802 (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)
103	SELECT SQL_NO_CACHE DISTINCT a.`id_attribute`, a.`color`, al.`name`, agl.`id_attribute_group`, IF(lialv.`url_name` IS NULL OR lialv.`url_name` = "", NULL, lialv.`url_name`) AS url_name, IF(lialv.`meta_title` IS NULL OR lialv.`meta_title` = "", NULL, lialv.`meta_title`) AS meta_title FROM `ps_attribute_group` ag INNER JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1) 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` = 1) 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 = 2) INNER JOIN ps_attribute_shop attribute_shop ON (attribute_shop.id_attribute = a.id_attribute AND attribute_shop.id_shop = 2) LEFT JOIN `ps_layered_indexable_attribute_lang_value` lialv ON (a.`id_attribute` = lialv.`id_attribute` AND lialv.`id_lang` = 1) WHERE ag.id_attribute_group = 2 ORDER BY agl.`name` ASC, a.`position` ASC	0.762 ms	35	Yes		/modules/ps_facetedsearch/src/Filters/DataAccessor.php:96 /modules/ps_facetedsearch/src/Filters/Block.php:731 (getAttributes) /modules/ps_facetedsearch/src/Filters/Block.php:150 (getAttributesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
18	SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module`as `mshop` FROM `ps_module` m LEFT JOIN `ps_module_shop` ms ON m.`id_module` = ms.`id_module` AND ms.`id_shop` = 2	0.717 ms	107			/classes/module/Module.php:346 /modules/simpleimportproduct/simpleimportproduct.php:44 (__construct) :undefined (__construct) /src/Core/Foundation/IoC/Container.php:123 (newInstance) /src/Core/Foundation/IoC/Container.php:153 (makeInstanceFromClassName) /src/Core/Foundation/IoC/Container.php:166 (doMake) /src/Adapter/ServiceLocator.php:70 (make) /classes/module/Module.php:1258 (get) /tools/profiling/Module.php:35 (coreLoadModule) /classes/module/Module.php:1237 (coreLoadModule) /classes/Hook.php:966 (getInstanceByName) /override/classes/Dispatcher.php:180 (exec) /classes/Dispatcher.php:243 (loadRoutes) /override/classes/Dispatcher.php:30 (__construct) /classes/Dispatcher.php:201 (__construct) /index.php:28 (getInstance)
21	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.715 ms	43	Yes		/override/classes/Dispatcher.php:216 /override/classes/Dispatcher.php:31 (loadRoutes) /classes/Dispatcher.php:201 (__construct) /index.php:28 (getInstance)
20	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.704 ms	43	Yes		/override/classes/Dispatcher.php:216 /classes/Dispatcher.php:243 (loadRoutes) /override/classes/Dispatcher.php:30 (__construct) /classes/Dispatcher.php:201 (__construct) /index.php:28 (getInstance)
39	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` = 2	0.700 ms	107			/classes/module/Module.php:346 /modules/securitypro/securitypro.php:87 (__construct) :undefined (__construct) /src/Core/Foundation/IoC/Container.php:123 (newInstance) /src/Core/Foundation/IoC/Container.php:153 (makeInstanceFromClassName) /src/Core/Foundation/IoC/Container.php:166 (doMake) /src/Adapter/ServiceLocator.php:70 (make) /classes/module/Module.php:1258 (get) /tools/profiling/Module.php:35 (coreLoadModule) /classes/module/Module.php:1237 (coreLoadModule) /classes/Hook.php:966 (getInstanceByName) /classes/Dispatcher.php:507 (exec) /index.php:28 (dispatch)
136	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 = 2) WHERE pf.id_product = 614 ORDER BY f.position ASC	0.675 ms	30	Yes		/classes/Product.php:6021 /classes/Product.php:5824 (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)
239	SELECT SQL_NO_CACHE pa., product_attribute_shop., ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, al.`name` AS attribute_name, a.`id_attribute`, a.`position` 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 = 2) LEFT JOIN `ps_product_attribute_combination` pac ON pac.`id_product_attribute` = pa.`id_product_attribute` LEFT JOIN `ps_attribute` a ON a.`id_attribute` = pac.`id_attribute` LEFT JOIN `ps_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group` LEFT JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1) LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1) WHERE pa.`id_product` = 614 AND pa.`id_product_attribute` = 727 GROUP BY pa.`id_product_attribute`,ag.`id_attribute_group` ORDER BY pa.`id_product_attribute`	0.675 ms	1		Yes	/classes/Product.php:2862 /modules/rcpgtagmanager/src/PSModule/DataModelHandler/ModelBuilder/Product/AbstractProductModelBuilder.php:133 (getAttributeCombinationsById) /modules/rcpgtagmanager/src/PSModule/DataModelHandler/ModelBuilder/Product/AbstractProductModelBuilder.php:82 (getCombinationsData) /modules/rcpgtagmanager/src/PSModule/DataModelHandler/DataModelHandler.php:108 (setDetailData) /modules/rcpgtagmanager/src/PSModule/Hook/DisplayBeforeBodyClosingTag/AbstractDisplayBeforeBodyClosingTag.php:218 (buildDetailProductModelList) /modules/rcpgtagmanager/src/PSModule/Hook/DisplayBeforeBodyClosingTag/AbstractDisplayBeforeBodyClosingTag.php:64 (processPage) /modules/rcpgtagmanager/rcpgtagmanager.php:221 (exec) /classes/Hook.php:1077 (hookDisplayBeforeBodyClosingTag) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:418 (coreCallHook) /classes/Hook.php:983 (callHookOn) /config/smarty.config.inc.php:201 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/prod/smarty/compile/PRS03058layouts_layout_both_columns_tpl/5e/c0/42/5ec042c8bb6e3bc13eeaf6212933a97916ca4da1_2.file.layout-both-columns.tpl.php:405 (__call) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/PRS03058layouts_layout_both_columns_tpl/5e/c0/42/5ec042c8bb6e3bc13eeaf6212933a97916ca4da1_2.file.layout-both-columns.tpl.php:134 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68120eb4704de7_04032364) /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/prod/smarty/compile/PRS03058layouts_layout_both_columns_tpl/1a/51/f0/1a51f047462402a7b59c4d31f66c6692b83d6b5b_2.file.product-list.tpl.php:43 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68120eb46fa030_79561080) /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/prod/smarty/compile/PRS03058layouts_layout_both_columns_tpl/64/73/8b/64738b7bcd80a55751ecd0dcb888bbcd93fe595e_2.file.category.tpl.php:34 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68120eb46f1ea5_03428982) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/controller/FrontController.php:771 (fetch) /classes/controller/FrontController.php:753 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
151	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` = 742 AND cp.`id_cart` = 0 AND cp.`id_product` = 629 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` = 742 AND cp.`id_cart` = 0 AND p.`id_product_item` = 629 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1	0.660 ms	0			/classes/Cart.php:1430 /classes/Product.php:4361 (getProductQuantity) /classes/Product.php:5814 (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)
132	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` = 614 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` = 614 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1	0.654 ms	0			/classes/Cart.php:1430 /classes/Product.php:4361 (getProductQuantity) /classes/Product.php:5802 (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)
153	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 = 2) WHERE pf.id_product = 629 ORDER BY f.position ASC	0.641 ms	30	Yes		/classes/Product.php:6021 /classes/Product.php:5824 (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)
114	SELECT SQL_NO_CACHE p., ps., pl.*, sa.out_of_stock, IFNULL(sa.quantity, 0) as quantity, (DATEDIFF( p.`date_add`, DATE_SUB( '2025-04-30 00:00:00', INTERVAL 300 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 = 2 AND pl.id_lang = 1 LEFT JOIN ps_stock_available sa ON sa.id_product = p.id_product AND sa.id_shop = 0 AND sa.id_product_attribute = 0 AND sa.id_shop_group = 1 LEFT JOIN ps_product_shop ps ON ps.id_product = p.id_product AND ps.id_shop = 2 WHERE p.id_product IN (614,629)	0.630 ms	2			/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)
137	SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, agl.`public_name` as `public_group`, pa.`reference`, pa.`ean13`, pa.`isbn`, pa.`upc`, pa.`mpn`, pal.`available_now`, pal.`available_later` FROM `ps_attribute` a LEFT JOIN `ps_attribute_lang` al ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 1) LEFT JOIN `ps_product_attribute_combination` pac ON (pac.`id_attribute` = a.`id_attribute`) LEFT JOIN `ps_product_attribute` pa ON (pa.`id_product_attribute` = pac.`id_product_attribute`) INNER JOIN ps_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 2) LEFT JOIN `ps_product_attribute_lang` pal ON (pal.`id_product_attribute` = pac.`id_product_attribute` AND pal.`id_lang` = 1) LEFT JOIN `ps_attribute_group_lang` agl ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1) WHERE pa.`id_product` = 614 AND pac.`id_product_attribute` = 727 AND agl.`id_lang` = 1	0.601 ms	1			/classes/Product.php:7534 /classes/Product.php:5857 (getAttributesParams) /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)
154	SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, agl.`public_name` as `public_group`, pa.`reference`, pa.`ean13`, pa.`isbn`, pa.`upc`, pa.`mpn`, pal.`available_now`, pal.`available_later` FROM `ps_attribute` a LEFT JOIN `ps_attribute_lang` al ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 1) LEFT JOIN `ps_product_attribute_combination` pac ON (pac.`id_attribute` = a.`id_attribute`) LEFT JOIN `ps_product_attribute` pa ON (pa.`id_product_attribute` = pac.`id_product_attribute`) INNER JOIN ps_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 2) LEFT JOIN `ps_product_attribute_lang` pal ON (pal.`id_product_attribute` = pac.`id_product_attribute` AND pal.`id_lang` = 1) LEFT JOIN `ps_attribute_group_lang` agl ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1) WHERE pa.`id_product` = 629 AND pac.`id_product_attribute` = 742 AND agl.`id_lang` = 1	0.573 ms	1			/classes/Product.php:7534 /classes/Product.php:5857 (getAttributesParams) /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)
207	SELECT SQL_NO_CACHE 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 = 2) LEFT JOIN `ps_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 1) WHERE i.`id_product` = 614 ORDER BY `position`	0.557 ms	5	Yes		/classes/Product.php:3545 /modules/cp_imagehover/cp_imagehover.php:70 (getImages) /classes/Hook.php:1077 (hookDisplayCpHoverImage) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:418 (coreCallHook) /classes/Hook.php:983 (callHookOn) /config/smarty.config.inc.php:201 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/prod/smarty/compile/PRS03058layouts_layout_both_columns_tpl/cb/66/af/cb66af33dc21af892d6d28fd0c5269202385b9e9_2.file.product-listgrid.tpl.php:149 (__call) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/PRS03058layouts_layout_both_columns_tpl/cb/66/af/cb66af33dc21af892d6d28fd0c5269202385b9e9_2.file.product-listgrid.tpl.php:41 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68120eb4910502_44420318) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /var/cache/prod/smarty/compile/PRS03058layouts_layout_both_columns_tpl/14/7f/2a/147f2ab92053aeed94c229b0d69082d63c3800ed_2.file.products.tpl.php:75 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/PRS03058layouts_layout_both_columns_tpl/14/7f/2a/147f2ab92053aeed94c229b0d69082d63c3800ed_2.file.products.tpl.php:40 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68120eb48f7566_77227449) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /var/cache/prod/smarty/compile/PRS03058layouts_layout_both_columns_tpl/1a/51/f0/1a51f047462402a7b59c4d31f66c6692b83d6b5b_2.file.product-list.tpl.php:105 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/PRS03058layouts_layout_both_columns_tpl/1a/51/f0/1a51f047462402a7b59c4d31f66c6692b83d6b5b_2.file.product-list.tpl.php:180 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:186 (process) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/PRS03058layouts_layout_both_columns_tpl/5e/c0/42/5ec042c8bb6e3bc13eeaf6212933a97916ca4da1_2.file.layout-both-columns.tpl.php:329 (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/prod/smarty/compile/PRS03058layouts_layout_both_columns_tpl/5e/c0/42/5ec042c8bb6e3bc13eeaf6212933a97916ca4da1_2.file.layout-both-columns.tpl.php:100 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68120eb4704de7_04032364) /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/prod/smarty/compile/PRS03058layouts_layout_both_columns_tpl/1a/51/f0/1a51f047462402a7b59c4d31f66c6692b83d6b5b_2.file.product-list.tpl.php:43 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68120eb46fa030_79561080) /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/prod/smarty/compile/PRS03058layouts_layout_both_columns_tpl/64/73/8b/64738b7bcd80a55751ecd0dcb888bbcd93fe595e_2.file.category.tpl.php:34 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68120eb46f1ea5_03428982) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/controller/FrontController.php:771 (fetch) /classes/controller/FrontController.php:753 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
25	SELECT SQL_NO_CACHE id_meta FROM ps_meta_lang WHERE url_rewrite = "Light+source+#-1-2-3" AND `id_lang` = 1 AND `id_shop` = 2 LIMIT 1	0.554 ms	35			/override/classes/Dispatcher.php:1408 /override/classes/Dispatcher.php:400 (getKeyExistance) /classes/Dispatcher.php:346 (getController) /index.php:28 (dispatch)
22	SELECT SQL_NO_CACHE id_meta FROM ps_meta_lang WHERE url_rewrite = "new-arrivals" AND `id_lang` = 1 AND `id_shop` = 2 LIMIT 1	0.553 ms	35			/override/classes/Dispatcher.php:1408 /override/classes/Dispatcher.php:321 (getKeyExistance) /classes/Dispatcher.php:346 (getController) /index.php:28 (dispatch)
173	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 = 2 ) INNER JOIN ps_category_shop category_shop ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 2) WHERE `id_lang` = 1 AND c.`id_parent` = 1 AND `active` = 1 GROUP BY c.`id_category` ORDER BY category_shop.`position` ASC	0.531 ms	1	Yes	Yes	/classes/Category.php:1151 /modules/cp_blocksearch/cp_blocksearch.php:172 (getChildren) /modules/cp_blocksearch/cp_blocksearch.php:147 (getCategoryOption) /modules/cp_blocksearch/cp_blocksearch.php:160 (getWidgetVariables) /classes/Hook.php:1088 (renderWidget) /tools/profiling/Hook.php:64 (coreRenderWidget) /classes/Hook.php:1019 (coreRenderWidget) /config/smarty.config.inc.php:201 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/prod/smarty/compile/PRS03058layouts_layout_both_columns_tpl/3c/b8/7e/3cb87e8e8f5de7f0008d8a9e90cf1a42f8e64e47_2.file.header.tpl.php:103 (__call) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/PRS03058layouts_layout_both_columns_tpl/3c/b8/7e/3cb87e8e8f5de7f0008d8a9e90cf1a42f8e64e47_2.file.header.tpl.php:32 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68120eb47614c2_57805682) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /var/cache/prod/smarty/compile/PRS03058layouts_layout_both_columns_tpl/5e/c0/42/5ec042c8bb6e3bc13eeaf6212933a97916ca4da1_2.file.layout-both-columns.tpl.php:206 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/PRS03058layouts_layout_both_columns_tpl/5e/c0/42/5ec042c8bb6e3bc13eeaf6212933a97916ca4da1_2.file.layout-both-columns.tpl.php:58 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68120eb4704de7_04032364) /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/prod/smarty/compile/PRS03058layouts_layout_both_columns_tpl/1a/51/f0/1a51f047462402a7b59c4d31f66c6692b83d6b5b_2.file.product-list.tpl.php:43 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68120eb46fa030_79561080) /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/prod/smarty/compile/PRS03058layouts_layout_both_columns_tpl/64/73/8b/64738b7bcd80a55751ecd0dcb888bbcd93fe595e_2.file.category.tpl.php:34 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68120eb46f1ea5_03428982) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/controller/FrontController.php:771 (fetch) /classes/controller/FrontController.php:753 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
106	SELECT SQL_NO_CACHE v., vl., IF(lifvlv.`url_name` IS NULL OR lifvlv.`url_name` = "", NULL, lifvlv.`url_name`) AS url_name, IF(lifvlv.`meta_title` IS NULL OR lifvlv.`meta_title` = "", NULL, lifvlv.`meta_title`) AS meta_title FROM `ps_feature_value` v LEFT JOIN `ps_feature_value_lang` vl ON (v.`id_feature_value` = vl.`id_feature_value` AND vl.`id_lang` = 1) LEFT JOIN `ps_layered_indexable_feature_value_lang_value` lifvlv ON (v.`id_feature_value` = lifvlv.`id_feature_value` AND lifvlv.`id_lang` = 1) WHERE v.`id_feature` = 6 ORDER BY vl.`value` ASC	0.529 ms	15	Yes		/modules/ps_facetedsearch/src/Filters/DataAccessor.php:204 /modules/ps_facetedsearch/src/Filters/Block.php:864 (getFeatureValues) /modules/ps_facetedsearch/src/Filters/Block.php:154 (getFeaturesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php: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)

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