Cart Icon

My Cart

0 items

No products in the cart

Designer Georgette Saree with blouse - Blue

0 Reviews

Availability :

Sku: A-S-P7

Categories:

Apparels Saree

Saree Fabric: Georgette Blouse: Running Blouse Blouse Fabric: Satin Pattern: Printed Blouse Pattern: Solid...

AED45.00

Tax excluded

Quantity :

Add to Wishlist

Availability :

Description

The Banarasi Gold Tissue Silk Saree with Blouse Piece is an elegant choice for anyone looking to make a statement at special events. Crafted from high-quality tissue fabric, this saree radiates a subtle golden sheen that adds a touch of luxury to your look. Its solid pattern provides a classic, versatile design, while the separate blouse piece, made from matching tissue fabric and featuring a border pattern, enhances the overall ensemble with its chic appeal.

Whether it's a wedding, festival, or any formal occasion, this saree exudes sophistication and charm. Its timeless design and rich texture make it an excellent addition to your ethnic wear collection.

Product Details:

Saree Fabric: Tissue
Blouse: Separate Blouse Piece (Unstitched)
Blouse Fabric: Tissue
Pattern: Solid
Blouse Pattern: Same as Border
Saree Length: 5.3 meters
Blouse Length: 0.8 meters
Occasions: Weddings, Festivals, Formal Events

Add a touch of glamour and elegance to your special occasion with the Banarasi Gold Tissue Silk Saree—an exquisite blend of traditional design and modern sophistication.

Product Details

Reference A-S-P7

In stock 1 Item

Specific References

Write Review(0)

No customer reviews for the moment.

On Top

Load Time	331.242 ms
Querying Time	193 ms
Queries	471
Memory Peak Usage	17.1 Mb
Included Files	1172 files - 13.48 Mb
PrestaShop Cache	- Mb
Global vars	0.22 Mb
- global $context	142k
- global $_MODULES	36k
- global $_MODULE	12k
- global $_SERVER	7k
- global $vc_row_layouts	6k
- global $config	5k
- global $smarty	3k
- global $__composer_autoload_files	3k
- global $exportPhpConfigFile	3k
- global $_COOKIE	1k
- global $legacyContainer	1k
- global $vc_params_list	1k

PrestaShop Version	8.2.7
PHP Version	7.4.33
MySQL Version	8.0.42-0ubuntu0.20.04.1
Memory Limit	512M
Max Execution Time	60s
Smarty Cache	disabled
Smarty Compilation	auto

	Time	Cumulated Time	Memory Usage	Memory Peak Usage
config	43.377 ms	43.377 ms	4.14 Mb	4.4 Mb
__construct	0.021 ms	43.398 ms	- Mb	4.4 Mb
init	40.337 ms	83.735 ms	2.30 Mb	7.0 Mb
checkAccess	0.002 ms	83.737 ms	- Mb	7.0 Mb
setMedia	2.539 ms	86.276 ms	0.31 Mb	7.0 Mb
postProcess	0.007 ms	86.283 ms	- Mb	7.0 Mb
initHeader	0.002 ms	86.285 ms	- Mb	7.0 Mb
initContent	162.295 ms	248.580 ms	6.15 Mb	12.9 Mb
initFooter	0.002 ms	248.582 ms	- Mb	12.9 Mb
display	82.660 ms	331.242 ms	3.94 Mb	17.1 Mb

Hook	Time	Memory Usage
Header	111.087 ms	2.97 Mb
=> novblocktags	0.001 ms	- Mb
=> novproductcomments	0.193 ms	- Mb
=> novthemeconfig	110.624 ms	2.96 Mb
=> novadvancedsearch	0.177 ms	- Mb
=> novblockwishlist	0.092 ms	- Mb
DisplayHeader	22.462 ms	1.06 Mb
=> ps_shoppingcart	0.053 ms	- Mb
=> novverticalmenu	0.064 ms	- Mb
=> smartblog	0.898 ms	0.02 Mb
=> novmegamenu	0.003 ms	- Mb
=> revsliderprestashop	9.229 ms	0.23 Mb
=> novlookbook	0.004 ms	- Mb
=> jscomposer	12.013 ms	0.80 Mb
=> ps_searchbar	0.198 ms	- Mb
DisplayAdvanceSearch	15.711 ms	0.51 Mb
=> novadvancedsearch	15.711 ms	0.51 Mb
DisplayFooter1	12.958 ms	0.75 Mb
=> jscomposer	12.958 ms	0.75 Mb
DisplayBeforeBodyClosingTag	8.570 ms	0.06 Mb
=> statsdata	8.570 ms	0.06 Mb
DisplayShoppingCart	6.039 ms	0.58 Mb
=> revsliderprestashop	6.039 ms	0.58 Mb
DisplayFooterProduct	5.839 ms	0.55 Mb
=> revsliderprestashop	5.829 ms	0.55 Mb
=> jscomposer	0.010 ms	- Mb
DisplayMegamenu	4.850 ms	0.21 Mb
=> novmegamenu	4.850 ms	0.21 Mb
DisplayPopupLogin	4.622 ms	0.20 Mb
=> novloginsocial	3.100 ms	0.14 Mb
=> novloginsocial	1.522 ms	0.06 Mb
DisplayVerticalMenu	2.514 ms	0.03 Mb
=> novverticalmenu	2.514 ms	0.03 Mb
ProductTab	2.119 ms	0.09 Mb
=> novproductcomments	2.119 ms	0.09 Mb
ProductTabContent	2.015 ms	0.10 Mb
=> novproductcomments	2.015 ms	0.10 Mb
VcBeforeInit	1.950 ms	0.23 Mb
=> jscomposer	0.304 ms	0.01 Mb
=> novmanagevcaddons	1.646 ms	0.22 Mb
DisplayProductListReviews	1.616 ms	0.08 Mb
=> novproductcomments	1.616 ms	0.08 Mb
displayShoppingCart	1.376 ms	0.07 Mb
=> ps_shoppingcart (widget)	1.376 ms	0.07 Mb
displayLoginSocialAnywhere	1.191 ms	0.05 Mb
=> novloginsocial (widget)	0.937 ms	0.05 Mb
=> novloginsocial (widget)	0.254 ms	- Mb
DisplayReassurance	0.785 ms	0.05 Mb
=> blockreassurance	0.785 ms	0.05 Mb
displayFooterProduct	0.527 ms	- Mb
=> ps_viewedproduct (widget)	0.527 ms	- Mb
displayMyAccountBlock	0.401 ms	- Mb
=> ps_customersignin (widget)	0.401 ms	- Mb
ActionFrontControllerSetMedia	0.364 ms	0.01 Mb
=> ps_emailsubscription	0.179 ms	- Mb
=> blockreassurance	0.098 ms	- Mb
=> ps_socialfollow	0.054 ms	- Mb
=> ps_emailalerts	0.033 ms	- Mb
DisplayProductListFunctionalButtons	0.333 ms	- Mb
=> novblockwishlist	0.333 ms	- Mb
DisplayMyAccountBlock	0.320 ms	- Mb
=> novblockwishlist	0.320 ms	- Mb
ModuleRoutes	0.024 ms	0.01 Mb
=> smartblog	0.024 ms	0.01 Mb
VcShortcodesCssClass	0.011 ms	- Mb
=> jscomposer	0.003 ms	- Mb
=> jscomposer	0.002 ms	- Mb
=> jscomposer	0.002 ms	- Mb
=> jscomposer	0.002 ms	- Mb
=> jscomposer	0.002 ms	- Mb
DisplayAfterBodyOpeningTag	0.007 ms	- Mb
=> blockreassurance	0.007 ms	- Mb
25 hook(s)	207.691 ms	7.58 Mb

Module	Time	Memory Usage
smartblog	6.051 ms	0.26 Mb
__construct	5.120 ms	0.23 Mb
hookModuleRoutes	0.029 ms	0.01 Mb
hookDisplayHeader	0.902 ms	0.02 Mb
ps_emailsubscription	1.216 ms	0.14 Mb
__construct	1.033 ms	0.13 Mb
hookActionFrontControllerSetMedia	0.183 ms	- Mb
blockreassurance	1.009 ms	0.15 Mb
__construct	0.111 ms	0.10 Mb
hookActionFrontControllerSetMedia	0.101 ms	- Mb
hookDisplayAfterBodyOpeningTag	0.010 ms	- Mb
hookDisplayReassurance	0.787 ms	0.05 Mb
ps_socialfollow	0.140 ms	0.02 Mb
__construct	0.084 ms	0.02 Mb
hookActionFrontControllerSetMedia	0.056 ms	- Mb
ps_emailalerts	0.142 ms	0.04 Mb
__construct	0.107 ms	0.04 Mb
hookActionFrontControllerSetMedia	0.035 ms	- Mb
ps_shoppingcart	1.560 ms	0.09 Mb
__construct	0.125 ms	0.02 Mb
hookDisplayHeader	0.056 ms	- Mb
displayShoppingCart	1.379 ms	0.07 Mb
novverticalmenu	2.705 ms	0.07 Mb
__construct	0.122 ms	0.03 Mb
hookDisplayHeader	0.066 ms	- Mb
hookDisplayVerticalMenu	2.517 ms	0.03 Mb
novblocktags	0.119 ms	0.02 Mb
__construct	0.116 ms	0.02 Mb
hookHeader	0.003 ms	- Mb
novproductcomments	6.125 ms	0.32 Mb
__construct	0.170 ms	0.05 Mb
hookHeader	0.196 ms	- Mb
hookDisplayProductListReviews	1.619 ms	0.08 Mb
hookProductTab	2.122 ms	0.09 Mb
hookProductTabContent	2.018 ms	0.10 Mb
novmegamenu	5.060 ms	0.30 Mb
__construct	0.201 ms	0.10 Mb
hookDisplayHeader	0.005 ms	- Mb
hookDisplayMegamenu	4.854 ms	0.21 Mb
revsliderprestashop	22.650 ms	1.62 Mb
__construct	1.539 ms	0.25 Mb
hookDisplayHeader	9.235 ms	0.23 Mb
hookDisplayShoppingCart	6.043 ms	0.59 Mb
hookDisplayFooterProduct	5.833 ms	0.55 Mb
novthemeconfig	111.120 ms	3.21 Mb
__construct	0.489 ms	0.25 Mb
hookHeader	110.631 ms	2.96 Mb
ps_customersignin	0.552 ms	0.02 Mb
__construct	0.148 ms	0.02 Mb
displayMyAccountBlock	0.404 ms	- Mb
ps_languageselector	0.166 ms	0.02 Mb
__construct	0.166 ms	0.02 Mb
ps_currencyselector	0.151 ms	0.02 Mb
__construct	0.151 ms	0.02 Mb
ps_bestsellers	0.147 ms	0.02 Mb
__construct	0.147 ms	0.02 Mb
novadvancedsearch	16.078 ms	0.53 Mb
__construct	0.183 ms	0.02 Mb
hookHeader	0.179 ms	- Mb
hookDisplayAdvanceSearch	15.716 ms	0.51 Mb
novlookbook	0.172 ms	0.03 Mb
__construct	0.166 ms	0.03 Mb
hookDisplayHeader	0.006 ms	- Mb
novblockwishlist	0.923 ms	0.11 Mb
__construct	0.170 ms	0.10 Mb
hookHeader	0.094 ms	- Mb
hookDisplayMyAccountBlock	0.323 ms	- Mb
hookDisplayProductListFunctionalButtons	0.336 ms	- Mb
jscomposer	27.414 ms	1.78 Mb
__construct	2.095 ms	0.21 Mb
hookVcBeforeInit	0.307 ms	0.01 Mb
hookDisplayHeader	12.018 ms	0.80 Mb
hookDisplayFooterProduct	0.011 ms	- Mb
hookVcShortcodesCssClass	0.005 ms	- Mb
hookVcShortcodesCssClass	0.005 ms	- Mb
hookVcShortcodesCssClass	0.004 ms	- Mb
hookVcShortcodesCssClass	0.004 ms	- Mb
hookVcShortcodesCssClass	0.004 ms	- Mb
hookDisplayFooter1	12.961 ms	0.75 Mb
novmanagevcaddons	1.822 ms	0.25 Mb
__construct	0.173 ms	0.03 Mb
hookVcBeforeInit	1.649 ms	0.22 Mb
ps_searchbar	0.336 ms	0.02 Mb
__construct	0.135 ms	0.02 Mb
hookDisplayHeader	0.201 ms	- Mb
ps_viewedproduct	0.699 ms	- Mb
__construct	0.169 ms	0.02 Mb
displayFooterProduct	0.530 ms	- Mb
novloginsocial	5.983 ms	0.27 Mb
__construct	0.161 ms	0.02 Mb
displayLoginSocialAnywhere	0.940 ms	0.05 Mb
hookDisplayPopupLogin	3.102 ms	0.14 Mb
displayLoginSocialAnywhere	0.256 ms	- Mb
hookDisplayPopupLogin	1.524 ms	0.06 Mb
statsdata	8.674 ms	0.08 Mb
__construct	0.098 ms	0.02 Mb
hookDisplayBeforeBodyClosingTag	8.576 ms	0.06 Mb
25 module(s)	221.013 ms	9.36 Mb

Designer Georgette Saree with blouse - Blue

Description

Product Details

Specific References

Write Review(0)

Payments accept :

Follow us :

PRODUCT LISTING POLICY - INTELLECTUAL PROPERTY PROTECTION - PRIVACY POLICY - TERMS OF USE - USER INFORMATION LEGAL ENQUIRY GUIDE

Copyright © 2019 Vinovathemes. All rights reserved.

Stopwatch SQL - 471 queries

Doubles

Tables stress

ObjectModel instances

Included Files

17 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
17 queries	SELECT SUM(quantity) FROM `ps_stock_available` WHERE (id_product = XX) AND (id_product_attribute = XX) AND (id_shop = XX) AND (id_shop_group = XX) LIMIT XX
13 queries	SELECT `id_module` FROM `ps_module_shop` WHERE `id_module` = XX AND `id_shop` = XX LIMIT XX
10 queries	SELECT XX FROM `ps_specific_price` WHERE id_product = XX LIMIT XX
10 queries	SELECT 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 = XX) 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_group` cg ON (cg.`id_category` = c.`id_category`) WHERE `id_parent` = XX AND `active` = XX AND cg.`id_group` =XX GROUP BY c.`id_category` ORDER BY `level_depth` ASC, category_shop.`position` ASC
10 queries	SELECT *, ( IF (`id_group` = XX, XX, XX) + IF (`id_country` = XX, XX, XX) + IF (`id_currency` = XX, XX, XX) + IF (`id_shop` = XX, XX, XX) + IF (`id_customer` = XX, XX, XX)) AS `score` FROM `ps_specific_price` WHERE `id_shop` IN (XX, XX) AND `id_currency` IN (XX, XX) AND `id_country` IN (XX, XX) AND `id_group` IN (XX, XX) AND `id_product` = XX AND `id_customer` = XX AND `id_product_attribute` = XX AND `id_cart` = XX AND (`from` = 'XX-XX-XX XX:XX:XX' OR 'XX-XX-XX XX:XX:XX' >= `from`) AND (`to` = 'XX-XX-XX XX:XX:XX' OR 'XX-XX-XX XX:XX:XX' <= `to`) AND IF(`from_quantity` > XX, `from_quantity`, XX) <= XX ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT XX
9 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)
9 queries	SELECT `id_tax_rules_group` FROM `ps_product_shop` WHERE `id_product` = XX AND id_shop=XX LIMIT XX
9 queries	SELECT `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = XX AND `id_group` = XX LIMIT XX
9 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
9 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
9 queries	SELECT `priority`, `id_specific_price_priority` FROM `ps_specific_price_priority` WHERE `id_product` = XX ORDER BY `id_specific_price_priority` DESC LIMIT XX
9 queries	SELECT product_type FROM `ps_product` WHERE id_product = XX LIMIT XX
9 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
9 queries	SELECT name FROM ps_category_lang WHERE id_shop = XX AND id_lang = XX AND id_category = XX LIMIT XX
9 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
9 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`
9 queries	SELECT `id_product_attribute` FROM `ps_product_attribute` WHERE `id_product` = XX
9 queries	SELECT COUNT(*) FROM `ps_pack` WHERE id_product_pack = XX LIMIT XX
8 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
8 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
8 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
8 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
8 queries	SELECT * FROM `ps_product_attribute_lang` WHERE `id_product_attribute` = XX
7 queries	SELECT `file_name`, `subdir` FROM ps_vc_media WHERE id_vc_media=XX
6 queries	SELECT option_value FROM `ps_revslider_options` WHERE `option_name`='revslider-maintenance-addon/revslider-maintenance-addon.php' LIMIT XX
6 queries	SELECT option_value FROM `ps_revslider_options` WHERE `option_name`='revslider-static-css' LIMIT XX
6 queries	SELECT `id_lang` FROM `ps_lang` WHERE `locale` = 'en-us' OR `language_code` = 'en-us' LIMIT XX
5 queries	SELECT m.*, ml.title, ml.sub_title , ml.html, ml.url FROM ps_novmegamenu m LEFT JOIN ps_novmegamenu_lang ml ON m.id_novmegamenu = ml.id_novmegamenu AND ml.id_lang = XX JOIN ps_novmegamenu_shop ms ON m.id_novmegamenu = ms.id_novmegamenu AND ms.id_shop = XX WHERE m.id_parent = XX
5 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, XX, XX, XX) AND il.`id_lang` = XX ORDER by i.`position`
4 queries	SELECT option_value FROM `ps_revslider_options` WHERE `option_name`='revslider-global-settings' LIMIT XX
3 queries	SELECT option_value FROM `ps_revslider_options` WHERE `option_name`='revslider-beforeafter-addon/revslider-beforeafter-addon.php' LIMIT XX
3 queries	SELECT * FROM ps_revslider_sliders
3 queries	SELECT option_value FROM `ps_revslider_options` WHERE `option_name`='revslider-liquideffect-addon/revslider-liquideffect-addon.php' LIMIT XX
3 queries	SELECT option_value FROM `ps_revslider_options` WHERE `option_name`='revslider-bubblemorph-addon/revslider-bubblemorph-addon.php' LIMIT XX
3 queries	SELECT option_value FROM `ps_revslider_options` WHERE `option_name`='revslider-refresh-addon/revslider-refresh-addon.php' LIMIT XX
3 queries	SELECT pa.id_product_attribute FROM `ps_product_attribute` pa INNER JOIN ps_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = XX) WHERE pa.`id_product` = XX
3 queries	SELECT option_value FROM `ps_revslider_options` WHERE `option_name`='revslider-revealer-addon/revslider-revealer-addon.php' LIMIT XX
3 queries	SELECT option_value FROM `ps_revslider_options` WHERE `option_name`='revslider-addons' LIMIT XX
3 queries	SELECT option_value FROM `ps_revslider_options` WHERE `option_name`='revslider-duotonefilters-addon/revslider-duotonefilters-addon.php' LIMIT XX
3 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, XX, XX) AND il.`id_lang` = XX ORDER by i.`position`
3 queries	SELECT option_value FROM `ps_revslider_options` WHERE `option_name`='revslider-weather-addon/revslider-weather-addon.php' LIMIT XX
3 queries	SELECT option_value FROM `ps_revslider_options` WHERE `option_name`='revslider-panorama-addon/revslider-panorama-addon.php' LIMIT XX
3 queries	SELECT option_value FROM `ps_revslider_options` WHERE `option_name`='revslider-whiteboard-addon/revslider-whiteboard-addon.php' LIMIT XX
3 queries	SELECT option_value FROM `ps_revslider_options` WHERE `option_name`='revslider-slicey-addon/revslider-slicey-addon.php' LIMIT XX
3 queries	SELECT option_value FROM `ps_revslider_options` WHERE `option_name`='revslider-filmstrip-addon/revslider-filmstrip-addon.php' LIMIT XX
3 queries	SELECT option_value FROM `ps_revslider_options` WHERE `option_name`='revslider-polyfold-addon/revslider-polyfold-addon.php' LIMIT XX
3 queries	SELECT option_value FROM `ps_revslider_options` WHERE `option_name`='revslider-particles-addon/revslider-particles-addon.php' LIMIT XX
3 queries	SELECT option_value FROM `ps_revslider_options` WHERE `option_name`='revslider-snow-addon/revslider-snow-addon.php' LIMIT XX
3 queries	SELECT option_value FROM `ps_revslider_options` WHERE `option_name`='revslider-typewriter-addon/revslider-typewriter-addon.php' LIMIT XX
3 queries	SELECT option_value FROM `ps_revslider_options` WHERE `option_name`='revslider-backup-addon/revslider-backup-addon.php' LIMIT XX
3 queries	SELECT * FROM `ps_currency` a LEFT JOIN `ps_currency_lang` `b` ON a.`id_currency` = b.`id_currency` AND b.`id_lang` = XX LEFT JOIN `ps_currency_shop` `c` ON a.`id_currency` = c.`id_currency` AND c.`id_shop` = XX WHERE (a.`id_currency` = XX) LIMIT XX
2 queries	SELECT t.`id_lang`, t.`name` FROM ps_tag t LEFT JOIN ps_product_tag pt ON (pt.id_tag = t.id_tag) WHERE pt.`id_product`=XX
2 queries	SELECT * FROM `ps_currency` a LEFT JOIN `ps_currency_shop` `c` ON a.`id_currency` = c.`id_currency` AND c.`id_shop` = XX WHERE (a.`id_currency` = XX) LIMIT XX
2 queries	SELECT cp.`id_category`, cl.`name`, cl.`link_rewrite` FROM `ps_category_product` cp LEFT JOIN `ps_category` c ON (c.id_category = cp.id_category) LEFT JOIN `ps_category_lang` cl ON (cp.`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 cp.`id_product` = XX AND cl.`id_lang` = XX
2 queries	SELECT `legend` FROM ps_vc_media INNER JOIN `ps_vc_media_lang` ON `ps_vc_media`.`id_vc_media` = `ps_vc_media_lang`.`id_vc_media` WHERE ps_vc_media.id_vc_media=XX AND `ps_vc_media_lang`.id_lang = XX LIMIT XX
2 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
2 queries	SELECT (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS grade FROM `ps_product_comment` pc WHERE pc.`id_product` = XX AND pc.`deleted` = XX AND pc.`validate` = XX LIMIT XX
2 queries	SELECT XX FROM `ps_cart_rule` WHERE ((date_to >= "XX-XX-XX XX:XX:XX" AND date_to <= "XX-XX-XX XX:XX:XX") OR (date_from >= "XX-XX-XX XX:XX:XX" AND date_from <= "XX-XX-XX XX:XX:XX") OR (date_from < "XX-XX-XX XX:XX:XX" AND date_to > "XX-XX-XX XX:XX:XX")) AND `id_customer` IN (XX,XX) LIMIT XX
2 queries	SELECT * FROM `ps_currency_lang` WHERE `id_currency` = XX
2 queries	SELECT m.*, ml.title, ml.sub_title , ml.html, ml.url FROM ps_novverticalmenu m LEFT JOIN ps_novverticalmenu_lang ml ON m.id_novverticalmenu = ml.id_novverticalmenu AND ml.id_lang = XX JOIN ps_novverticalmenu_shop ms ON m.id_novverticalmenu = ms.id_novverticalmenu AND ms.id_shop = XX WHERE m.id_parent = XX

Name	Instances	Source
Product	28	/controllers/front/ProductController.php:146 (__construct) [id: 100495] /classes/Link.php:113 (__construct) [id: 100495] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 100495] /classes/Meta.php:353 (__construct) [id: 100495] /classes/Link.php:113 (__construct) [id: 100495] /classes/Link.php:113 (__construct) [id: 100495] /classes/Link.php:113 (__construct) [id: 100495] /classes/Link.php:113 (__construct) [id: 100400] /classes/Link.php:113 (__construct) [id: 100477] /classes/Link.php:113 (__construct) [id: 100413] /classes/Link.php:113 (__construct) [id: 100409] /classes/Link.php:113 (__construct) [id: 100404] /classes/Link.php:113 (__construct) [id: 100485] /classes/Link.php:113 (__construct) [id: 100481] /classes/Link.php:113 (__construct) [id: 100479] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 100400] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 100477] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 100413] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 100409] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 100404] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 100485] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 100481] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 100479] /classes/Link.php:113 (__construct) [id: 100495] /classes/Link.php:113 (__construct) [id: 100495] /classes/Link.php:113 (__construct) [id: 100495] /classes/Link.php:113 (__construct) [id: 100495] /classes/Link.php:113 (__construct) [id: 100495]
Category	19	/controllers/front/ProductController.php:303 (__construct) [id: 2] /controllers/front/ProductController.php:1344 (__construct) [id: 2] /classes/PrestaShopCollection.php:385 (hydrateCollection) [id: ] /modules/novadvancedsearch/novadvancedsearch.php:89 (getRootCategory) [id: 2] /modules/novadvancedsearch/novadvancedsearch.php:89 (recurseLiteCategTree) [id: 4] /modules/novadvancedsearch/novadvancedsearch.php:89 (recurseLiteCategTree) [id: 184] /modules/novadvancedsearch/novadvancedsearch.php:89 (recurseLiteCategTree) [id: 1045] /modules/novadvancedsearch/novadvancedsearch.php:89 (recurseLiteCategTree) [id: 1046] /modules/novadvancedsearch/novadvancedsearch.php:89 (recurseLiteCategTree) [id: 1041] /modules/novadvancedsearch/novadvancedsearch.php:89 (recurseLiteCategTree) [id: 1042] /modules/novadvancedsearch/novadvancedsearch.php:89 (recurseLiteCategTree) [id: 1043] /modules/novadvancedsearch/novadvancedsearch.php:89 (recurseLiteCategTree) [id: 1044] /modules/novverticalmenu/class/Verticalmenu.php:269 (__construct) [id: 4] /modules/novverticalmenu/class/Verticalmenu.php:269 (__construct) [id: 1041] /modules/novmegamenu/class/Megamenu.php:263 (__construct) [id: 4] /modules/novmegamenu/class/Megamenu.php:263 (__construct) [id: 1045] /modules/novmegamenu/class/Megamenu.php:263 (__construct) [id: 1041] /classes/Link.php:402 (__construct) [id: 4] /classes/Link.php:402 (__construct) [id: 1046]
Combination	8	/classes/Product.php:5923 (__construct) [id: 21455] /classes/Product.php:5923 (__construct) [id: 21658] /classes/Product.php:5923 (__construct) [id: 21510] /classes/Product.php:5923 (__construct) [id: 21494] /classes/Product.php:5923 (__construct) [id: 21471] /classes/Product.php:5923 (__construct) [id: 21719] /classes/Product.php:5923 (__construct) [id: 21706] /classes/Product.php:5923 (__construct) [id: 21689]
Address	6	/classes/Product.php:741 (__construct) [id: ] /classes/Product.php:6906 (initialize) [id: ] /classes/Product.php:3804 (__construct) [id: ] /controllers/front/ProductController.php:598 (__construct) [id: 0] /classes/Product.php:5975 (__construct) [id: ] /classes/shop/Shop.php:486 (__construct) [id: ]
Currency	5	/src/Adapter/Currency/CurrencyDataProvider.php:101 (__construct) [id: 2] /src/Adapter/Currency/CurrencyDataProvider.php:101 (__construct) [id: 3] /src/Adapter/Currency/CurrencyDataProvider.php:101 (__construct) [id: 1] /classes/Tools.php:691 (getCurrencyInstance) [id: 2] /modules/ps_currencyselector/ps_currencyselector.php:112 (getCurrencies) [id: 1]
Country	3	/config/config.inc.php:146 (__construct) [id: 217] /classes/AddressFormat.php:404 (__construct) [id: 217] /classes/controller/FrontController.php:1769 (__construct) [id: 217]
Language	2	/config/config.inc.php:211 (__construct) [id: 1] /classes/Tools.php:561 (__construct) [id: 1]
Cart	2	/classes/controller/FrontController.php:467 (__construct) [id: ] /classes/controller/FrontController.php:541 (__construct) [id: ]
Manufacturer	2	/controllers/front/ProductController.php:438 (__construct) [id: 0] /classes/Link.php:657 (__construct) [id: ]
State	1	/classes/controller/FrontController.php:1768 (__construct) [id: 336]
Mgmenu	1	/modules/novmegamenu/novmegamenu.php:657 (__construct) [id: ]
Verticalmenu	1	/modules/novverticalmenu/novverticalmenu.php:637 (__construct) [id: ]
vccontentanywhere	1	/modules/jscomposer/jscomposer.php:3002 (__construct) [id: ]
Shop	1	/config/config.inc.php:117 (initialize) [id: 1]
AddressFormat	1	/classes/controller/FrontController.php:1763 (generateAddress) [id: ]
Risk	1	/classes/controller/FrontController.php:1695 (__construct) [id: ]
Gender	1	/classes/controller/FrontController.php:1692 (__construct) [id: 0]
Group	1	/classes/Cart.php:249 (getCurrent) [id: 1]
Customer	1	/config/config.inc.php:264 (__construct) [id: ]
ShopGroup	1	/classes/shop/Shop.php:561 (__construct) [id: 1]
ConnectionsSource	1	/modules/statsdata/statsdata.php:119 (logHttpReferer) [id: ]

#	Query	Time (ms)	Rows	Filesort	Group By	Location
470	INSERT INTO `ps_connections_source` (`id_connections`, `http_referer`, `request_uri`, `keywords`, `date_add`) VALUES ('7574015', '', 'eswedo.com/home/100495-designer-georgette-saree-with-blouse-blue.html', '', '2026-06-27 00:47:05')	7.537 ms	1			/classes/ObjectModel.php:623 /classes/ConnectionsSource.php:105 (add) /modules/statsdata/statsdata.php:119 (logHttpReferer) /modules/statsdata/statsdata.php:74 (getScriptCustomerPagesViews) /classes/Hook.php:1083 (hookDisplayBeforeBodyClosingTag) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:421 (coreCallHook) /classes/Hook.php:989 (callHookOn) /config/smarty.config.inc.php:201 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/dev/smarty/compile/vinova_nuranium_marketplacelayouts_layout_left_column_tpl/b0/54/02/b05402ec5cd072f96a0f2f91657078b99b9f8bef_2.file.layout-both-columns.tpl.php:705 (__call) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/vinova_nuranium_marketplacelayouts_layout_left_column_tpl/b0/54/02/b05402ec5cd072f96a0f2f91657078b99b9f8bef_2.file.layout-both-columns.tpl.php:337 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6a3ee53d91c4d7_26518256) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/vinova_nuranium_marketplacelayouts_layout_left_column_tpl/f7/f5/ea/f7f5ea22559ddbc81236a3d771db953ea11ee344_2.file.layout-one-column.tpl.php:42 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6a3ee53d8d1100_49160635) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/vinova_nuranium_marketplacelayouts_layout_left_column_tpl/61/10/e2/6110e20a1d42dd2610316ef5dca11d9971407741_2.file.product.tpl.php:53 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6a3ee53d8b3266_82545565) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/Smarty/SmartyDev.php:40 (fetch) /classes/controller/FrontController.php:771 (fetch) /classes/controller/FrontController.php:753 (smartyOutputContent) /tools/profiling/Controller.php:111 (display) /tools/profiling/Controller.php:88 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
249	SELECT SQL_NO_CACHE SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 100404) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1	5.912 ms	1			/classes/stock/StockAvailable.php:453 /classes/Product.php:4349 (getQuantityAvailableByProduct) /classes/Product.php:5813 (getQuantity) /classes/Product.php:6001 (getProductProperties) /classes/ProductSale.php:161 (getProductsProperties) /src/Adapter/BestSales/BestSalesProductSearchProvider.php:74 (getBestSales) /modules/ps_bestsellers/ps_bestsellers.php:195 (runQuery) /modules/ps_bestsellers/ps_bestsellers.php:161 (getBestSellers) /modules/novthemeconfig/novthemeconfig.php:286 (getWidgetVariables) /classes/Hook.php:1083 (hookHeader) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:428 (coreCallHook) /classes/Hook.php:989 (callHookOn) /classes/controller/FrontController.php:633 (exec) /controllers/front/ProductController.php:465 (initContent) /tools/profiling/Controller.php:65 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
26	SELECT SQL_NO_CACHE * FROM `ps_currency` c ORDER BY `iso_code` ASC	4.815 ms	3	Yes		/classes/Currency.php:709 /src/Adapter/Currency/CurrencyDataProvider.php:84 (findAllInstalled) /src/Core/Localization/Currency/DataLayer/CurrencyInstalled.php:90 (findAllInstalled) /src/Core/Localization/Currency/CurrencyDataSource.php:96 (getAllInstalledCurrencyIsoCodes) /src/Core/Localization/Currency/Repository.php:87 (getAllInstalledCurrenciesData) /src/Core/Localization/Locale/Repository.php:207 (getAllInstalledCurrencies) /src/Core/Localization/Locale/Repository.php:150 (getPriceSpecifications) /classes/controller/Controller.php:209 (getLocale) /classes/controller/FrontController.php:284 (init) /controllers/front/ProductController.php:124 (init) /tools/profiling/Controller.php:46 (init) /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`)	4.292 ms	5610			/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)
13	SELECT SQL_NO_CACHE h.`name` as hook, m.`id_module`, h.`id_hook`, m.`name` as module FROM `ps_module` m INNER JOIN ps_module_shop module_shop ON (module_shop.id_module = m.id_module AND module_shop.id_shop = 1 AND module_shop.enable_device & 1) INNER JOIN `ps_hook_module` `hm` ON hm.`id_module` = m.`id_module` INNER JOIN `ps_hook` `h` ON hm.`id_hook` = h.`id_hook` LEFT JOIN `ps_module_group` `mg` ON mg.`id_module` = m.`id_module` WHERE (h.`name` != "paymentOptions") AND (hm.`id_shop` = 1) AND (mg.id_shop = 1 AND mg.`id_group` IN (1)) GROUP BY hm.id_hook, hm.id_module ORDER BY hm.`position`	3.773 ms	3234	Yes	Yes	/classes/Hook.php:1289 /classes/Hook.php:738 (getAllHookRegistrations) /classes/Hook.php:848 (getHookModuleExecList) /classes/Dispatcher.php:606 (exec) /classes/Dispatcher.php:243 (loadRoutes) /classes/Dispatcher.php:201 (__construct) /index.php:28 (getInstance)
50	SELECT SQL_NO_CACHE h.id_hook, h.name as h_name, title, description, h.position, hm.position as hm_position, m.id_module, m.name, m.active FROM `ps_hook_module` hm STRAIGHT_JOIN `ps_hook` h ON (h.id_hook = hm.id_hook AND hm.id_shop = 1) STRAIGHT_JOIN `ps_module` as m ON (m.id_module = hm.id_module) ORDER BY hm.position	3.103 ms	804			/classes/Hook.php:459 /classes/Hook.php:496 (getHookModuleList) /classes/tax/TaxManagerFactory.php:67 (getModulesFromHook) /classes/tax/TaxManagerFactory.php:46 (execHookTaxManagerFactory) /classes/Product.php:6909 (getManager) /classes/Product.php:741 (getTaxesRate) /controllers/front/ProductController.php:146 (__construct) /tools/profiling/Controller.php:46 (init) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
49	SELECT SQL_NO_CACHE `id_hook`, `name` FROM `ps_hook` UNION SELECT `id_hook`, ha.`alias` as name FROM `ps_hook_alias` ha INNER JOIN `ps_hook` h ON ha.name = h.name	2.650 ms	0			/classes/Hook.php:1348 /classes/Hook.php:228 (getAllHookIds) /classes/tax/TaxManagerFactory.php:67 (getIdByName) /classes/tax/TaxManagerFactory.php:46 (execHookTaxManagerFactory) /classes/Product.php:6909 (getManager) /classes/Product.php:741 (getTaxesRate) /controllers/front/ProductController.php:146 (__construct) /tools/profiling/Controller.php:46 (init) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
150	SELECT SQL_NO_CACHE p., product_shop., stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, product_attribute_shop.minimal_quantity AS product_attribute_minimal_quantity,IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, pl.`description`, pl.`description_short`, pl.`link_rewrite`, pl.`meta_description`, pl.`meta_keywords`, pl.`meta_title`, pl.`name`, pl.`available_now`, pl.`available_later`, m.`name` AS manufacturer_name, p.`id_manufacturer` as id_manufacturer, image_shop.`id_image` id_image, il.`legend`, ps.`quantity` AS sales, t.`rate`, pl.`meta_keywords`, pl.`meta_title`, pl.`meta_description`, DATEDIFF(p.`date_add`, DATE_SUB("2026-06-27 00:00:00", INTERVAL 200 DAY)) > 0 AS new FROM `ps_product_sale` ps LEFT JOIN `ps_product` p ON ps.`id_product` = p.`id_product` LEFT JOIN ps_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) LEFT JOIN `ps_product_attribute_shop` product_attribute_shop ON (p.`id_product` = product_attribute_shop.`id_product` AND product_attribute_shop.`default_on` = 1 AND product_attribute_shop.id_shop=1) LEFT JOIN `ps_product_lang` pl ON p.`id_product` = pl.`id_product` AND pl.`id_lang` = 1 AND pl.id_shop = 1 LEFT JOIN `ps_image_shop` image_shop ON (image_shop.`id_product` = p.`id_product` AND image_shop.cover=1 AND image_shop.id_shop=1) LEFT JOIN `ps_image_lang` il ON (image_shop.`id_image` = il.`id_image` AND il.`id_lang` = 1) LEFT JOIN `ps_manufacturer` m ON (m.`id_manufacturer` = p.`id_manufacturer`) LEFT JOIN `ps_tax_rule` tr ON (product_shop.`id_tax_rules_group` = tr.`id_tax_rules_group`) AND tr.`id_country` = 217 AND tr.`id_state` = 0 LEFT JOIN `ps_tax` t ON (t.`id_tax` = tr.`id_tax`) LEFT JOIN ps_stock_available stock ON (stock.id_product = `p`.id_product AND stock.id_product_attribute = 0 AND stock.id_shop = 1 AND stock.id_shop_group = 0 ) WHERE product_shop.`active` = 1 AND product_shop.`visibility` != 'none' AND EXISTS(SELECT 1 FROM `ps_category_product` cp JOIN `ps_category_group` cg ON (cp.id_category = cg.id_category AND cg.`id_group` =1) WHERE cp.`id_product` = p.`id_product`) ORDER BY `sales` DESC LIMIT 0, 8	2.413 ms	8			/classes/ProductSale.php:151 /src/Adapter/BestSales/BestSalesProductSearchProvider.php:74 (getBestSales) /modules/ps_bestsellers/ps_bestsellers.php:195 (runQuery) /modules/ps_bestsellers/ps_bestsellers.php:161 (getBestSellers) /modules/novthemeconfig/novthemeconfig.php:286 (getWidgetVariables) /classes/Hook.php:1083 (hookHeader) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:428 (coreCallHook) /classes/Hook.php:989 (callHookOn) /classes/controller/FrontController.php:633 (exec) /controllers/front/ProductController.php:465 (initContent) /tools/profiling/Controller.php:65 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
12	SELECT SQL_NO_CACHE lower(name) as name FROM `ps_hook` h WHERE (h.active = 1)	1.591 ms	1208			/classes/Hook.php:1388 /classes/Hook.php:817 (getHookStatusByName) /classes/Dispatcher.php:606 (exec) /classes/Dispatcher.php:243 (loadRoutes) /classes/Dispatcher.php:201 (__construct) /index.php:28 (getInstance)
37	SELECT SQL_NO_CACHE c.id_currency FROM `ps_currency` c WHERE (iso_code = 'INR') LIMIT 1	1.405 ms	1			/classes/Currency.php:893 /src/Adapter/Currency/CurrencyDataProvider.php:92 (getIdByIsoCode) /src/Adapter/Currency/CurrencyDataProvider.php:114 (getCurrencyByIsoCode) /src/Core/Localization/Currency/DataLayer/CurrencyDatabase.php:102 (getCurrencyByIsoCodeAndLocale) /src/Core/Data/Layer/AbstractDataLayer.php:91 (doRead) /src/Core/Data/Layer/AbstractDataLayer.php:150 (read) /src/Core/Data/Layer/AbstractDataLayer.php:95 (propagateRead) /src/Core/Localization/Currency/CurrencyDataSource.php:67 (read) /src/Core/Localization/Currency/CurrencyDataSource.php:109 (getLocalizedCurrencyData) /src/Core/Localization/Currency/CurrencyDataSource.php:96 (formatCurrenciesData) /src/Core/Localization/Currency/Repository.php:87 (getAllInstalledCurrenciesData) /src/Core/Localization/Locale/Repository.php:207 (getAllInstalledCurrencies) /src/Core/Localization/Locale/Repository.php:150 (getPriceSpecifications) /classes/controller/Controller.php:209 (getLocale) /classes/controller/FrontController.php:284 (init) /controllers/front/ProductController.php:124 (init) /tools/profiling/Controller.php:46 (init) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
15	SELECT SQL_NO_CACHE `id_hook`, `name` FROM `ps_hook`	1.360 ms	1208			/classes/Hook.php:1348 /classes/Hook.php:228 (getAllHookIds) /classes/Hook.php:857 (getIdByName) /classes/Dispatcher.php:606 (exec) /classes/Dispatcher.php:243 (loadRoutes) /classes/Dispatcher.php:201 (__construct) /index.php:28 (getInstance)
365	SELECT SQL_NO_CACHE c.*, cl.`id_lang`, cl.`name`, cl.`description`, cl.`additional_description`, cl.`link_rewrite`, cl.`meta_title`, cl.`meta_keywords`, cl.`meta_description` FROM `ps_category` c INNER JOIN ps_category_shop category_shop ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1) LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND `id_lang` = 1 AND cl.id_shop = 1 ) LEFT JOIN `ps_category_group` cg ON (cg.`id_category` = c.`id_category`) WHERE `id_parent` = 4 AND `active` = 1 AND cg.`id_group` =1 GROUP BY c.`id_category` ORDER BY `level_depth` ASC, category_shop.`position` ASC	1.222 ms	9	Yes	Yes	/classes/Category.php:924 /classes/Category.php:304 (getSubCategories) /classes/Category.php:311 (recurseLiteCategTree) /modules/novadvancedsearch/novadvancedsearch.php:89 (recurseLiteCategTree) /classes/Hook.php:1083 (hookdisplayAdvanceSearch) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:421 (coreCallHook) /classes/Hook.php:989 (callHookOn) /config/smarty.config.inc.php:201 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/dev/smarty/compile/vinova_nuranium_marketplacelayouts_layout_left_column_tpl/a7/cd/c2/a7cdc2241d8fd480ff35558adfbd83a2d633379c_2.file.style-1.tpl.php:168 (__call) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/vinova_nuranium_marketplacelayouts_layout_left_column_tpl/a7/cd/c2/a7cdc2241d8fd480ff35558adfbd83a2d633379c_2.file.style-1.tpl.php:32 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6a3ee53d9a59f1_93273658) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /var/cache/dev/smarty/compile/vinova_nuranium_marketplacelayouts_layout_left_column_tpl/98/5f/ab/985fab734bcbc65cd9d3bb5db6f815b4ddc7e8f1_2.file.header.tpl.php:31 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6a3ee53d984ca0_55720215) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /var/cache/dev/smarty/compile/vinova_nuranium_marketplacelayouts_layout_left_column_tpl/b0/54/02/b05402ec5cd072f96a0f2f91657078b99b9f8bef_2.file.layout-both-columns.tpl.php:409 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/vinova_nuranium_marketplacelayouts_layout_left_column_tpl/b0/54/02/b05402ec5cd072f96a0f2f91657078b99b9f8bef_2.file.layout-both-columns.tpl.php:66 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6a3ee53d91c4d7_26518256) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/vinova_nuranium_marketplacelayouts_layout_left_column_tpl/f7/f5/ea/f7f5ea22559ddbc81236a3d771db953ea11ee344_2.file.layout-one-column.tpl.php:42 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6a3ee53d8d1100_49160635) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/vinova_nuranium_marketplacelayouts_layout_left_column_tpl/61/10/e2/6110e20a1d42dd2610316ef5dca11d9971407741_2.file.product.tpl.php:53 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6a3ee53d8b3266_82545565) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/Smarty/SmartyDev.php:40 (fetch) /classes/controller/FrontController.php:771 (fetch) /classes/controller/FrontController.php:753 (smartyOutputContent) /tools/profiling/Controller.php:111 (display) /tools/profiling/Controller.php:88 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
25	SELECT SQL_NO_CACHE m.page, ml.url_rewrite, ml.id_lang FROM `ps_meta` m LEFT JOIN `ps_meta_lang` ml ON (m.id_meta = ml.id_meta AND ml.id_shop = 1 ) ORDER BY LENGTH(ml.url_rewrite) DESC	1.211 ms	378	Yes		/classes/Dispatcher.php:654 /classes/Dispatcher.php:243 (loadRoutes) /classes/Dispatcher.php:201 (__construct) /index.php:28 (getInstance)
354	SELECT SQL_NO_CACHE * FROM ps_revslider_sliders WHERE params LIKE '%"template":"false"%' OR params NOT LIKE '%"template"'	1.132 ms	3			/modules/jscomposer/include/classes/vendors/plugins/class-vc-vendor-revslider.php:16 /modules/jscomposer/include/classes/vendors/plugins/class-vc-vendor-revslider.php:9 (buildShortcode) /modules/jscomposer/include/classes/vendors/class-vc-vendors-manager.php:21 (load) /modules/jscomposer/include/classes/vendors/class-vc-vendors-manager.php:13 (load) /modules/jscomposer/include/classes/vendors/class-vc-vendors-manager.php:9 (init) /modules/jscomposer/jscomposer.php:1617 (__construct) /modules/jscomposer/jscomposer.php:1564 (vc) /modules/jscomposer/jscomposer.php:3157 (init) /classes/Hook.php:1083 (hookDisplayHeader) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:421 (coreCallHook) /classes/Hook.php:989 (callHookOn) /classes/controller/FrontController.php:633 (exec) /controllers/front/ProductController.php:465 (initContent) /tools/profiling/Controller.php:65 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
88	SELECT SQL_NO_CACHE p., product_shop., stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, pl.`description`, pl.`description_short`, pl.`link_rewrite`, pl.`meta_description`, pl.`meta_keywords`, pl.`meta_title`, pl.`name`, pl.`available_now`, pl.`available_later`, image_shop.`id_image` id_image, il.`legend`, m.`name` as manufacturer_name, cl.`name` AS category_default, IFNULL(product_attribute_shop.id_product_attribute, 0) id_product_attribute, DATEDIFF( p.`date_add`, DATE_SUB( "2026-06-27 00:00:00", INTERVAL 200 DAY ) ) > 0 AS new FROM `ps_accessory` LEFT JOIN `ps_product` p ON p.`id_product` = `id_product_2` INNER JOIN ps_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) LEFT JOIN `ps_product_attribute_shop` product_attribute_shop ON (p.`id_product` = product_attribute_shop.`id_product` AND product_attribute_shop.`default_on` = 1 AND product_attribute_shop.id_shop=1) LEFT JOIN `ps_product_lang` pl ON ( p.`id_product` = pl.`id_product` AND pl.`id_lang` = 1 AND pl.id_shop = 1 ) LEFT JOIN `ps_category_lang` cl ON ( product_shop.`id_category_default` = cl.`id_category` AND cl.`id_lang` = 1 AND cl.id_shop = 1 ) LEFT JOIN `ps_image_shop` image_shop ON (image_shop.`id_product` = p.`id_product` AND image_shop.cover=1 AND image_shop.id_shop=1) LEFT JOIN `ps_image_lang` il ON (image_shop.`id_image` = il.`id_image` AND il.`id_lang` = 1) LEFT JOIN `ps_manufacturer` m ON (p.`id_manufacturer`= m.`id_manufacturer`) LEFT JOIN ps_stock_available stock ON (stock.id_product = `p`.id_product AND stock.id_product_attribute = 0 AND stock.id_shop = 1 AND stock.id_shop_group = 0 ) WHERE `id_product_1` = 100495 AND product_shop.`active` = 1 AND product_shop.`visibility` != 'none' GROUP BY product_shop.id_product	1.076 ms	1		Yes	/classes/Product.php:4713 /controllers/front/ProductController.php:405 (getAccessories) /tools/profiling/Controller.php:65 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
453	SELECT SQL_NO_CACHE v.,vl.content,vs.id_shop FROM `ps_vccontentanywhere` v INNER JOIN `ps_vccontentanywhere_lang` vl ON (v.`id_vccontentanywhere` = vl.`id_vccontentanywhere` AND vl.`id_lang` = 1) INNER JOIN `ps_vccontentanywhere_shop` vs ON (v.`id_vccontentanywhere` = vs.`id_vccontentanywhere` AND vs.`id_shop` = 1 AND v.`active` = 1) WHERE v.`hook_name` = "displayFooter1" AND v.`active` = 1 AND ( ( v.`exception_type` = 1 AND v.`exception` LIKE "%product%") OR ( v.`exception_type` != 1 AND v.`display_type`= 1 ) OR ( v.`exception_type` != 1 AND v.`display_type` = 0 AND v.`prd_page` = 1 ) ) UNION SELECT v_1.,vl_1.content,vs_1.id_shop FROM `ps_vccontentanywhere` v_1 INNER JOIN `ps_vccontentanywhere_lang` vl_1 ON (v_1.`id_vccontentanywhere` = vl_1.`id_vccontentanywhere` AND vl_1.`id_lang` = 1) INNER JOIN `ps_vccontentanywhere_shop` vs_1 ON (v_1.`id_vccontentanywhere` = vs_1.`id_vccontentanywhere` AND vs_1.`id_shop` = 1 AND v_1.`active` = 1) INNER JOIN `ps_vccontentanywhere_filter` vs_f_1 ON (vs_f_1.`id_vccontentanywhere` = v_1.`id_vccontentanywhere` ) WHERE v_1.`hook_name` = "displayFooter1" AND v_1.active = 1 AND v_1.`exception_type` != 1 AND (vs_f_1.page = 1 AND vs_f_1.id_specify_page = 100495) ORDER BY `position` ASC	0.972 ms	0			/modules/jscomposer/classes/vccontentanywhere.php:148 /modules/jscomposer/jscomposer.php:715 (GetVcContentAnyWhereByHookPageFilter) /modules/jscomposer/jscomposer.php:3875 (contenthookvalue) /classes/Hook.php:1083 (hookDisplayFooter1) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:421 (coreCallHook) /classes/Hook.php:989 (callHookOn) /config/smarty.config.inc.php:201 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/dev/smarty/compile/vinova_nuranium_marketplacelayouts_layout_left_column_tpl/ae/66/bc/ae66bc9f90a12965a2ff55487c75a23a7d53f4bd_2.file.style-1.tpl.php:27 (__call) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6a3ee53dc6c048_67977201) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /var/cache/dev/smarty/compile/vinova_nuranium_marketplacelayouts_layout_left_column_tpl/b0/54/02/b05402ec5cd072f96a0f2f91657078b99b9f8bef_2.file.layout-both-columns.tpl.php:117 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6a3ee53d91c4d7_26518256) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/vinova_nuranium_marketplacelayouts_layout_left_column_tpl/f7/f5/ea/f7f5ea22559ddbc81236a3d771db953ea11ee344_2.file.layout-one-column.tpl.php:42 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6a3ee53d8d1100_49160635) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/vinova_nuranium_marketplacelayouts_layout_left_column_tpl/61/10/e2/6110e20a1d42dd2610316ef5dca11d9971407741_2.file.product.tpl.php:53 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6a3ee53d8b3266_82545565) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/Smarty/SmartyDev.php:40 (fetch) /classes/controller/FrontController.php:771 (fetch) /classes/controller/FrontController.php:753 (smartyOutputContent) /tools/profiling/Controller.php:111 (display) /tools/profiling/Controller.php:88 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
100	SELECT SQL_NO_CACHE ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, agl.`public_name` AS public_group_name, a.`id_attribute`, al.`name` AS attribute_name, a.`color` AS attribute_color, product_attribute_shop.`id_product_attribute`, IFNULL(stock.quantity, 0) as quantity, product_attribute_shop.`price`, product_attribute_shop.`ecotax`, product_attribute_shop.`weight`, product_attribute_shop.`default_on`, pa.`reference`, pa.`ean13`, pa.`mpn`, pa.`upc`, pa.`isbn`, product_attribute_shop.`unit_price_impact`, product_attribute_shop.`minimal_quantity`, product_attribute_shop.`available_date`, ag.`group_type`, pal.`available_now`, pal.`available_later` FROM `ps_product_attribute` pa INNER JOIN ps_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) LEFT JOIN ps_stock_available stock ON (stock.id_product = `pa`.id_product AND stock.id_product_attribute = IFNULL(`pa`.id_product_attribute, 0) AND stock.id_shop = 1 AND stock.id_shop_group = 0 ) LEFT JOIN `ps_product_attribute_lang` `pal` ON pa.id_product_attribute = pal.id_product_attribute AND pal.id_lang = 1 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 LEFT JOIN `ps_attribute_group_lang` `agl` ON ag.id_attribute_group = agl.id_attribute_group INNER JOIN ps_attribute_shop attribute_shop ON (attribute_shop.id_attribute = a.id_attribute AND attribute_shop.id_shop = 1) WHERE (pa.id_product = 100495) AND (al.id_lang = 1) AND (agl.id_lang = 1) GROUP BY id_attribute_group, id_product_attribute ORDER BY ag.position ASC, a.position ASC, agl.name ASC	0.953 ms	1	Yes	Yes	/classes/Product.php:4600 /controllers/front/ProductController.php:648 (getAttributesGroups) /controllers/front/ProductController.php:462 (assignAttributesGroups) /tools/profiling/Controller.php:65 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
322	SELECT SQL_NO_CACHE p., ps., pl.*, sa.out_of_stock, IFNULL(sa.quantity, 0) as quantity, (DATEDIFF( p.`date_add`, DATE_SUB( '2026-06-27 00:00:00', INTERVAL 200 DAY ) ) > 0) as new FROM ps_product p LEFT JOIN ps_product_lang pl ON pl.id_product = p.id_product AND pl.id_shop = 1 AND pl.id_lang = 1 LEFT JOIN ps_stock_available sa ON sa.id_product = p.id_product AND sa.id_product_attribute = 0 AND sa.id_shop = 1 LEFT JOIN ps_product_shop ps ON ps.id_product = p.id_product AND ps.id_shop = 1 WHERE p.id_product IN (100400,100477,100413,100409,100404,100485,100481,100479)	0.949 ms	8			/classes/ProductAssembler.php:95 /classes/ProductAssembler.php:203 (addMissingProductFieldsForMultipleProducts) /modules/ps_bestsellers/ps_bestsellers.php:232 (assembleProducts) /modules/ps_bestsellers/ps_bestsellers.php:161 (getBestSellers) /modules/novthemeconfig/novthemeconfig.php:286 (getWidgetVariables) /classes/Hook.php:1083 (hookHeader) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:428 (coreCallHook) /classes/Hook.php:989 (callHookOn) /classes/controller/FrontController.php:633 (exec) /controllers/front/ProductController.php:465 (initContent) /tools/profiling/Controller.php:65 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
59	SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority` FROM `ps_specific_price_priority` WHERE `id_product` = 100495 ORDER BY `id_specific_price_priority` DESC LIMIT 1	0.915 ms	1			/classes/SpecificPrice.php:259 /classes/SpecificPrice.php:239 (getPriority) /classes/SpecificPrice.php:565 (_getScoreQuery) /classes/Product.php:3827 (getSpecificPrice) /classes/Product.php:3717 (priceCalculation) /classes/Product.php:748 (getPriceStatic) /controllers/front/ProductController.php:146 (__construct) /tools/profiling/Controller.php:46 (init) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
46	SELECT SQL_NO_CACHE * FROM `ps_product` a LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1 LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1 WHERE (a.`id_product` = 100495) AND (b.`id_shop` = 1) LIMIT 1	0.853 ms	1			/src/Adapter/EntityMapper.php:71 /classes/ObjectModel.php:284 (load) /tools/profiling/ObjectModel.php:32 (__construct) /classes/Product.php:725 (__construct) /controllers/front/ProductController.php:146 (__construct) /tools/profiling/Controller.php:46 (init) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
250	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` = 100404 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` = 100404 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1	0.795 ms	0			/classes/Cart.php:1430 /classes/Product.php:4361 (getProductQuantity) /classes/Product.php:5813 (getQuantity) /classes/Product.php:6001 (getProductProperties) /classes/ProductSale.php:161 (getProductsProperties) /src/Adapter/BestSales/BestSalesProductSearchProvider.php:74 (getBestSales) /modules/ps_bestsellers/ps_bestsellers.php:195 (runQuery) /modules/ps_bestsellers/ps_bestsellers.php:161 (getBestSellers) /modules/novthemeconfig/novthemeconfig.php:286 (getWidgetVariables) /classes/Hook.php:1083 (hookHeader) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:428 (coreCallHook) /classes/Hook.php:989 (callHookOn) /classes/controller/FrontController.php:633 (exec) /controllers/front/ProductController.php:465 (initContent) /tools/profiling/Controller.php:65 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
0	SELECT SQL_NO_CACHE s.id_shop, CONCAT(su.physical_uri, su.virtual_uri) AS uri, su.domain, su.main FROM ps_shop_url su LEFT JOIN ps_shop s ON (s.id_shop = su.id_shop) WHERE (su.domain = 'eswedo.com' OR su.domain_ssl = 'eswedo.com') AND s.active = 1 AND s.deleted = 0 ORDER BY LENGTH(CONCAT(su.physical_uri, su.virtual_uri)) DESC	0.784 ms	1	Yes		/classes/shop/Shop.php:1364 /classes/shop/Shop.php:355 (findShopByHost) /config/config.inc.php:117 (initialize) /index.php:27 (require)
85	SELECT SQL_NO_CACHE DISTINCT a.`id_attribute`, a.`id_attribute_group`, al.`name` as `attribute`, agl.`name` as `group`,pa.`reference`, pa.`ean13`, pa.`isbn`, pa.`upc`, pa.`mpn` FROM `ps_attribute` a 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 (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1) LEFT JOIN `ps_product_attribute_combination` pac ON (a.`id_attribute` = pac.`id_attribute`) LEFT JOIN `ps_product_attribute` pa ON (pac.`id_product_attribute` = pa.`id_product_attribute`) INNER JOIN ps_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) INNER JOIN ps_attribute_shop attribute_shop ON (attribute_shop.id_attribute = pac.id_attribute AND attribute_shop.id_shop = 1) WHERE pa.`id_product` = 100495	0.775 ms	1			/classes/Product.php:7575 /controllers/front/ProductController.php:870 (getAttributesInformationsByProduct) /controllers/front/ProductController.php:373 (assignAttributesCombinations) /tools/profiling/Controller.php:65 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
23	SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module`as `mshop` FROM `ps_module` m LEFT JOIN `ps_module_shop` ms ON m.`id_module` = ms.`id_module` AND ms.`id_shop` = 1	0.749 ms	141			/classes/module/Module.php:346 /modules/smartblog/smartblog.php:42 (__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:1263 (get) /tools/profiling/Module.php:35 (coreLoadModule) /classes/module/Module.php:1242 (coreLoadModule) /classes/Hook.php:972 (getInstanceByName) /classes/Dispatcher.php:606 (exec) /classes/Dispatcher.php:243 (loadRoutes) /classes/Dispatcher.php:201 (__construct) /index.php:28 (getInstance)
363	SELECT SQL_NO_CACHE c.*, cl.`id_lang`, cl.`name`, cl.`description`, cl.`additional_description`, cl.`link_rewrite`, cl.`meta_title`, cl.`meta_keywords`, cl.`meta_description` FROM `ps_category` c INNER JOIN ps_category_shop category_shop ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1) LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND `id_lang` = 1 AND cl.id_shop = 1 ) LEFT JOIN `ps_category_group` cg ON (cg.`id_category` = c.`id_category`) WHERE `id_parent` = 2 AND `active` = 1 AND cg.`id_group` =1 GROUP BY c.`id_category` ORDER BY `level_depth` ASC, category_shop.`position` ASC	0.731 ms	3	Yes	Yes	/classes/Category.php:924 /classes/Category.php:304 (getSubCategories) /modules/novadvancedsearch/novadvancedsearch.php:89 (recurseLiteCategTree) /classes/Hook.php:1083 (hookdisplayAdvanceSearch) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:421 (coreCallHook) /classes/Hook.php:989 (callHookOn) /config/smarty.config.inc.php:201 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/dev/smarty/compile/vinova_nuranium_marketplacelayouts_layout_left_column_tpl/a7/cd/c2/a7cdc2241d8fd480ff35558adfbd83a2d633379c_2.file.style-1.tpl.php:168 (__call) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/vinova_nuranium_marketplacelayouts_layout_left_column_tpl/a7/cd/c2/a7cdc2241d8fd480ff35558adfbd83a2d633379c_2.file.style-1.tpl.php:32 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6a3ee53d9a59f1_93273658) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /var/cache/dev/smarty/compile/vinova_nuranium_marketplacelayouts_layout_left_column_tpl/98/5f/ab/985fab734bcbc65cd9d3bb5db6f815b4ddc7e8f1_2.file.header.tpl.php:31 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6a3ee53d984ca0_55720215) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /var/cache/dev/smarty/compile/vinova_nuranium_marketplacelayouts_layout_left_column_tpl/b0/54/02/b05402ec5cd072f96a0f2f91657078b99b9f8bef_2.file.layout-both-columns.tpl.php:409 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/vinova_nuranium_marketplacelayouts_layout_left_column_tpl/b0/54/02/b05402ec5cd072f96a0f2f91657078b99b9f8bef_2.file.layout-both-columns.tpl.php:66 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6a3ee53d91c4d7_26518256) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/vinova_nuranium_marketplacelayouts_layout_left_column_tpl/f7/f5/ea/f7f5ea22559ddbc81236a3d771db953ea11ee344_2.file.layout-one-column.tpl.php:42 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6a3ee53d8d1100_49160635) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/vinova_nuranium_marketplacelayouts_layout_left_column_tpl/61/10/e2/6110e20a1d42dd2610316ef5dca11d9971407741_2.file.product.tpl.php:53 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6a3ee53d8b3266_82545565) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/Smarty/SmartyDev.php:40 (fetch) /classes/controller/FrontController.php:771 (fetch) /classes/controller/FrontController.php:753 (smartyOutputContent) /tools/profiling/Controller.php:111 (display) /tools/profiling/Controller.php:88 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
292	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` = 100481 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` = 100481 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1	0.711 ms	0			/classes/Cart.php:1430 /classes/Product.php:4361 (getProductQuantity) /classes/Product.php:5813 (getQuantity) /classes/Product.php:6001 (getProductProperties) /classes/ProductSale.php:161 (getProductsProperties) /src/Adapter/BestSales/BestSalesProductSearchProvider.php:74 (getBestSales) /modules/ps_bestsellers/ps_bestsellers.php:195 (runQuery) /modules/ps_bestsellers/ps_bestsellers.php:161 (getBestSellers) /modules/novthemeconfig/novthemeconfig.php:286 (getWidgetVariables) /classes/Hook.php:1083 (hookHeader) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:428 (coreCallHook) /classes/Hook.php:989 (callHookOn) /classes/controller/FrontController.php:633 (exec) /controllers/front/ProductController.php:465 (initContent) /tools/profiling/Controller.php:65 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
76	SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module`as `mshop` FROM `ps_module` m LEFT JOIN `ps_module_shop` ms ON m.`id_module` = ms.`id_module` AND ms.`id_shop` = 1	0.672 ms	141			/classes/module/Module.php:346 /modules/ps_emailsubscription/ps_emailsubscription.php:96 (__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:1263 (get) /tools/profiling/Module.php:35 (coreLoadModule) /classes/module/Module.php:1242 (coreLoadModule) /classes/Hook.php:972 (getInstanceByName) /classes/controller/FrontController.php:1002 (exec) /tools/profiling/Controller.php:53 (setMedia) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
162	SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) + IF (`id_country` = 217, 4, 0) + IF (`id_currency` = 2, 8, 0) + IF (`id_shop` = 1, 16, 0) + IF (`id_customer` = 0, 32, 0)) AS `score` FROM `ps_specific_price` WHERE `id_shop` IN (0, 1) AND `id_currency` IN (0, 2) AND `id_country` IN (0, 217) AND `id_group` IN (0, 1) AND `id_product` = 100400 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0 AND (`from` = '0000-00-00 00:00:00' OR '2026-06-27 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2026-06-27 00:00:00' <= `to`) AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1	0.654 ms	1	Yes		/classes/SpecificPrice.php:576 /classes/Product.php:3827 (getSpecificPrice) /classes/Product.php:3717 (priceCalculation) /classes/Product.php:5737 (getPriceStatic) /classes/Product.php:6001 (getProductProperties) /classes/ProductSale.php:161 (getProductsProperties) /src/Adapter/BestSales/BestSalesProductSearchProvider.php:74 (getBestSales) /modules/ps_bestsellers/ps_bestsellers.php:195 (runQuery) /modules/ps_bestsellers/ps_bestsellers.php:161 (getBestSellers) /modules/novthemeconfig/novthemeconfig.php:286 (getWidgetVariables) /classes/Hook.php:1083 (hookHeader) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:428 (coreCallHook) /classes/Hook.php:989 (callHookOn) /classes/controller/FrontController.php:633 (exec) /controllers/front/ProductController.php:465 (initContent) /tools/profiling/Controller.php:65 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
201	SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) + IF (`id_country` = 217, 4, 0) + IF (`id_currency` = 2, 8, 0) + IF (`id_shop` = 1, 16, 0) + IF (`id_customer` = 0, 32, 0)) AS `score` FROM `ps_specific_price` WHERE `id_shop` IN (0, 1) AND `id_currency` IN (0, 2) AND `id_country` IN (0, 217) AND `id_group` IN (0, 1) AND `id_product` = 100413 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0 AND (`from` = '0000-00-00 00:00:00' OR '2026-06-27 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2026-06-27 00:00:00' <= `to`) AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1	0.654 ms	1	Yes		/classes/SpecificPrice.php:576 /classes/Product.php:3827 (getSpecificPrice) /classes/Product.php:3717 (priceCalculation) /classes/Product.php:5703 (getPriceStatic) /classes/Product.php:6001 (getProductProperties) /classes/ProductSale.php:161 (getProductsProperties) /src/Adapter/BestSales/BestSalesProductSearchProvider.php:74 (getBestSales) /modules/ps_bestsellers/ps_bestsellers.php:195 (runQuery) /modules/ps_bestsellers/ps_bestsellers.php:161 (getBestSellers) /modules/novthemeconfig/novthemeconfig.php:286 (getWidgetVariables) /classes/Hook.php:1083 (hookHeader) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:428 (coreCallHook) /classes/Hook.php:989 (callHookOn) /classes/controller/FrontController.php:633 (exec) /controllers/front/ProductController.php:465 (initContent) /tools/profiling/Controller.php:65 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
260	SELECT SQL_NO_CACHE * FROM `ps_product` a LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1 LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1 WHERE (a.`id_product` = 100485) AND (b.`id_shop` = 1) LIMIT 1	0.643 ms	1			/src/Adapter/EntityMapper.php:71 /classes/ObjectModel.php:284 (load) /tools/profiling/ObjectModel.php:32 (__construct) /classes/Product.php:725 (__construct) /classes/Link.php:113 (__construct) /classes/Link.php:189 (getProductObject) /classes/Product.php:5671 (getProductLink) /classes/Product.php:6001 (getProductProperties) /classes/ProductSale.php:161 (getProductsProperties) /src/Adapter/BestSales/BestSalesProductSearchProvider.php:74 (getBestSales) /modules/ps_bestsellers/ps_bestsellers.php:195 (runQuery) /modules/ps_bestsellers/ps_bestsellers.php:161 (getBestSellers) /modules/novthemeconfig/novthemeconfig.php:286 (getWidgetVariables) /classes/Hook.php:1083 (hookHeader) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:428 (coreCallHook) /classes/Hook.php:989 (callHookOn) /classes/controller/FrontController.php:633 (exec) /controllers/front/ProductController.php:465 (initContent) /tools/profiling/Controller.php:65 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
424	SELECT SQL_NO_CACHE pcc.`id_product_comment_criterion`, pccl.`name` FROM `ps_product_comment_criterion` pcc LEFT JOIN `ps_product_comment_criterion_lang` pccl ON (pcc.id_product_comment_criterion = pccl.id_product_comment_criterion) LEFT JOIN `ps_product_comment_criterion_product` pccp ON (pcc.`id_product_comment_criterion` = pccp.`id_product_comment_criterion` AND pccp.`id_product` = 100495) LEFT JOIN `ps_product_comment_criterion_category` pccc ON (pcc.`id_product_comment_criterion` = pccc.`id_product_comment_criterion`) LEFT JOIN `ps_product_shop` ps ON (ps.id_category_default = pccc.id_category AND ps.id_product = 100495) WHERE pccl.`id_lang` = 1 AND ( pccp.id_product IS NOT NULL OR ps.id_product IS NOT NULL OR pcc.id_product_comment_criterion_type = 1 ) AND pcc.active = 1 GROUP BY pcc.id_product_comment_criterion	0.642 ms	1		Yes	/modules/novproductcomments/ProductCommentCriterion.php:163 /modules/novproductcomments/novproductcomments.php:737 (getByProduct) /classes/Hook.php:1083 (hookProductTab) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:421 (coreCallHook) /classes/Hook.php:989 (callHookOn) /config/smarty.config.inc.php:201 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/dev/smarty/compile/vinova_nuranium_marketplacelayouts_layout_left_column_tpl/61/10/e2/6110e20a1d42dd2610316ef5dca11d9971407741_2.file.product.tpl.php:1062 (__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:186 (process) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/vinova_nuranium_marketplacelayouts_layout_left_column_tpl/f7/f5/ea/f7f5ea22559ddbc81236a3d771db953ea11ee344_2.file.layout-one-column.tpl.php:100 (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/dev/smarty/compile/vinova_nuranium_marketplacelayouts_layout_left_column_tpl/b0/54/02/b05402ec5cd072f96a0f2f91657078b99b9f8bef_2.file.layout-both-columns.tpl.php:98 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6a3ee53d91c4d7_26518256) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/vinova_nuranium_marketplacelayouts_layout_left_column_tpl/f7/f5/ea/f7f5ea22559ddbc81236a3d771db953ea11ee344_2.file.layout-one-column.tpl.php:42 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6a3ee53d8d1100_49160635) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/vinova_nuranium_marketplacelayouts_layout_left_column_tpl/61/10/e2/6110e20a1d42dd2610316ef5dca11d9971407741_2.file.product.tpl.php:53 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6a3ee53d8b3266_82545565) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/Smarty/SmartyDev.php:40 (fetch) /classes/controller/FrontController.php:771 (fetch) /classes/controller/FrontController.php:753 (smartyOutputContent) /tools/profiling/Controller.php:111 (display) /tools/profiling/Controller.php:88 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
90	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_customization` = 0 AND cp.`id_cart` = 0 AND cp.`id_product` = 100495 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_customization` = 0 AND cp.`id_cart` = 0 AND p.`id_product_item` = 100495 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1	0.641 ms	0			/classes/Cart.php:1430 /controllers/front/ProductController.php:1211 (getProductQuantity) /controllers/front/ProductController.php:421 (getTemplateVarProduct) /tools/profiling/Controller.php:65 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
180	SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) + IF (`id_country` = 217, 4, 0) + IF (`id_currency` = 2, 8, 0) + IF (`id_shop` = 1, 16, 0) + IF (`id_customer` = 0, 32, 0)) AS `score` FROM `ps_specific_price` WHERE `id_shop` IN (0, 1) AND `id_currency` IN (0, 2) AND `id_country` IN (0, 217) AND `id_group` IN (0, 1) AND `id_product` = 100477 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0 AND (`from` = '0000-00-00 00:00:00' OR '2026-06-27 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2026-06-27 00:00:00' <= `to`) AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1	0.638 ms	1	Yes		/classes/SpecificPrice.php:576 /classes/Product.php:3827 (getSpecificPrice) /classes/Product.php:3717 (priceCalculation) /classes/Product.php:5703 (getPriceStatic) /classes/Product.php:6001 (getProductProperties) /classes/ProductSale.php:161 (getProductsProperties) /src/Adapter/BestSales/BestSalesProductSearchProvider.php:74 (getBestSales) /modules/ps_bestsellers/ps_bestsellers.php:195 (runQuery) /modules/ps_bestsellers/ps_bestsellers.php:161 (getBestSellers) /modules/novthemeconfig/novthemeconfig.php:286 (getWidgetVariables) /classes/Hook.php:1083 (hookHeader) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:428 (coreCallHook) /classes/Hook.php:989 (callHookOn) /classes/controller/FrontController.php:633 (exec) /controllers/front/ProductController.php:465 (initContent) /tools/profiling/Controller.php:65 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
187	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` = 100477 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` = 100477 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1	0.631 ms	0			/classes/Cart.php:1430 /classes/Product.php:4361 (getProductQuantity) /classes/Product.php:5813 (getQuantity) /classes/Product.php:6001 (getProductProperties) /classes/ProductSale.php:161 (getProductsProperties) /src/Adapter/BestSales/BestSalesProductSearchProvider.php:74 (getBestSales) /modules/ps_bestsellers/ps_bestsellers.php:195 (runQuery) /modules/ps_bestsellers/ps_bestsellers.php:161 (getBestSellers) /modules/novthemeconfig/novthemeconfig.php:286 (getWidgetVariables) /classes/Hook.php:1083 (hookHeader) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:428 (coreCallHook) /classes/Hook.php:989 (callHookOn) /classes/controller/FrontController.php:633 (exec) /controllers/front/ProductController.php:465 (initContent) /tools/profiling/Controller.php:65 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
405	SELECT SQL_NO_CACHE m.*, ml.title,ml.sub_title, ml.html, ml.url FROM ps_novverticalmenu m LEFT JOIN ps_novverticalmenu_lang ml ON m.id_novverticalmenu = ml.id_novverticalmenu AND ml.id_lang = 1 JOIN ps_novverticalmenu_shop ms ON m.id_novverticalmenu = ms.id_novverticalmenu AND ms.id_shop = 1 WHERE id_parent=1 AND m.`active`=1 ORDER BY `position`	0.623 ms	42	Yes		/modules/novverticalmenu/class/Verticalmenu.php:126 /modules/novverticalmenu/class/Verticalmenu.php:222 (getChildren) /modules/novverticalmenu/novverticalmenu.php:638 (getMegamenu) /modules/novverticalmenu/novverticalmenu.php:616 (hookDisplayLeftColumn) /classes/Hook.php:1083 (hookdisplayVerticalmenu) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:421 (coreCallHook) /classes/Hook.php:989 (callHookOn) /config/smarty.config.inc.php:201 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/dev/smarty/compile/vinova_nuranium_marketplacelayouts_layout_left_column_tpl/a7/cd/c2/a7cdc2241d8fd480ff35558adfbd83a2d633379c_2.file.style-1.tpl.php:207 (__call) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/vinova_nuranium_marketplacelayouts_layout_left_column_tpl/a7/cd/c2/a7cdc2241d8fd480ff35558adfbd83a2d633379c_2.file.style-1.tpl.php:36 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6a3ee53d9a59f1_93273658) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /var/cache/dev/smarty/compile/vinova_nuranium_marketplacelayouts_layout_left_column_tpl/98/5f/ab/985fab734bcbc65cd9d3bb5db6f815b4ddc7e8f1_2.file.header.tpl.php:31 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6a3ee53d984ca0_55720215) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /var/cache/dev/smarty/compile/vinova_nuranium_marketplacelayouts_layout_left_column_tpl/b0/54/02/b05402ec5cd072f96a0f2f91657078b99b9f8bef_2.file.layout-both-columns.tpl.php:409 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/vinova_nuranium_marketplacelayouts_layout_left_column_tpl/b0/54/02/b05402ec5cd072f96a0f2f91657078b99b9f8bef_2.file.layout-both-columns.tpl.php:66 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6a3ee53d91c4d7_26518256) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/vinova_nuranium_marketplacelayouts_layout_left_column_tpl/f7/f5/ea/f7f5ea22559ddbc81236a3d771db953ea11ee344_2.file.layout-one-column.tpl.php:42 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6a3ee53d8d1100_49160635) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/vinova_nuranium_marketplacelayouts_layout_left_column_tpl/61/10/e2/6110e20a1d42dd2610316ef5dca11d9971407741_2.file.product.tpl.php:53 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6a3ee53d8b3266_82545565) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/Smarty/SmartyDev.php:40 (fetch) /classes/controller/FrontController.php:771 (fetch) /classes/controller/FrontController.php:753 (smartyOutputContent) /tools/profiling/Controller.php:111 (display) /tools/profiling/Controller.php:88 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
321	SELECT SQL_NO_CACHE COUNT(ps.`id_product`) AS nb FROM `ps_product_sale` ps LEFT JOIN `ps_product` p ON p.`id_product` = ps.`id_product` LEFT JOIN ps_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) WHERE product_shop.`active` = 1 LIMIT 1	0.621 ms	104			/classes/ProductSale.php:60 /src/Adapter/BestSales/BestSalesProductSearchProvider.php:79 (getNbSales) /modules/ps_bestsellers/ps_bestsellers.php:195 (runQuery) /modules/ps_bestsellers/ps_bestsellers.php:161 (getBestSellers) /modules/novthemeconfig/novthemeconfig.php:286 (getWidgetVariables) /classes/Hook.php:1083 (hookHeader) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:428 (coreCallHook) /classes/Hook.php:989 (callHookOn) /classes/controller/FrontController.php:633 (exec) /controllers/front/ProductController.php:465 (initContent) /tools/profiling/Controller.php:65 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
358	SELECT SQL_NO_CACHE 1 FROM ps_cart_product cp INNER JOIN ps_product p ON (p.id_product = cp.id_product) INNER JOIN ps_product_shop ps ON (ps.id_shop = cp.id_shop AND ps.id_product = p.id_product) WHERE cp.id_cart=0 LIMIT 1	0.619 ms	1			/classes/Cart.php:4256 /classes/Cart.php:4231 (hasProducts) /classes/Cart.php:2145 (isVirtualCart) /src/Adapter/Presenter/Cart/CartLazyArray.php:185 (getOrderTotal) /src/Adapter/Presenter/AbstractLazyArray.php:269 (getTotals) /src/Adapter/Presenter/AbstractLazyArray.php:129 (offsetGet) :undefined (jsonSerialize) /classes/Smarty/SmartyLazyRegister.php:81 (json_encode) /var/cache/dev/smarty/compile/vinova_nuranium_marketplacelayouts_layout_left_column_tpl/7d/3d/0f/7d3d0f4de21376502afd3bedf08a5bb7e0b99d9a_2.file.javascript.tpl.php:65 (__call) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6a3ee53d95bb74_03777293) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /var/cache/dev/smarty/compile/vinova_nuranium_marketplacelayouts_layout_left_column_tpl/ba/40/6b/ba406bbcff85854b81a4c4219754c28ae6fd1d9b_2.file.head.tpl.php:249 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/vinova_nuranium_marketplacelayouts_layout_left_column_tpl/ba/40/6b/ba406bbcff85854b81a4c4219754c28ae6fd1d9b_2.file.head.tpl.php:62 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6a3ee53d941bf8_42359414) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /var/cache/dev/smarty/compile/vinova_nuranium_marketplacelayouts_layout_left_column_tpl/b0/54/02/b05402ec5cd072f96a0f2f91657078b99b9f8bef_2.file.layout-both-columns.tpl.php:355 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:232 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:181 (callParent) /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/dev/smarty/compile/vinova_nuranium_marketplacelayouts_layout_left_column_tpl/b0/54/02/b05402ec5cd072f96a0f2f91657078b99b9f8bef_2.file.layout-both-columns.tpl.php:45 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6a3ee53d91c4d7_26518256) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/vinova_nuranium_marketplacelayouts_layout_left_column_tpl/f7/f5/ea/f7f5ea22559ddbc81236a3d771db953ea11ee344_2.file.layout-one-column.tpl.php:42 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6a3ee53d8d1100_49160635) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/vinova_nuranium_marketplacelayouts_layout_left_column_tpl/61/10/e2/6110e20a1d42dd2610316ef5dca11d9971407741_2.file.product.tpl.php:53 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6a3ee53d8b3266_82545565) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/Smarty/SmartyDev.php:40 (fetch) /classes/controller/FrontController.php:771 (fetch) /classes/controller/FrontController.php:753 (smartyOutputContent) /tools/profiling/Controller.php:111 (display) /tools/profiling/Controller.php:88 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
252	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` = 21471 AND cp.`id_cart` = 0 AND cp.`id_product` = 100404 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` = 21471 AND cp.`id_cart` = 0 AND p.`id_product_item` = 100404 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1	0.619 ms	0			/classes/Cart.php:1430 /classes/Product.php:4361 (getProductQuantity) /classes/Product.php:5825 (getQuantity) /classes/Product.php:6001 (getProductProperties) /classes/ProductSale.php:161 (getProductsProperties) /src/Adapter/BestSales/BestSalesProductSearchProvider.php:74 (getBestSales) /modules/ps_bestsellers/ps_bestsellers.php:195 (runQuery) /modules/ps_bestsellers/ps_bestsellers.php:161 (getBestSellers) /modules/novthemeconfig/novthemeconfig.php:286 (getWidgetVariables) /classes/Hook.php:1083 (hookHeader) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:428 (coreCallHook) /classes/Hook.php:989 (callHookOn) /classes/controller/FrontController.php:633 (exec) /controllers/front/ProductController.php:465 (initContent) /tools/profiling/Controller.php:65 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
60	SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) + IF (`id_country` = 217, 4, 0) + IF (`id_currency` = 2, 8, 0) + IF (`id_shop` = 1, 16, 0) + IF (`id_customer` = 0, 32, 0)) AS `score` FROM `ps_specific_price` WHERE `id_shop` IN (0, 1) AND `id_currency` IN (0, 2) AND `id_country` IN (0, 217) AND `id_group` IN (0, 1) AND `id_product` = 100495 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0 AND (`from` = '0000-00-00 00:00:00' OR '2026-06-27 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2026-06-27 00:00:00' <= `to`) AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1	0.613 ms	1	Yes		/classes/SpecificPrice.php:576 /classes/Product.php:3827 (getSpecificPrice) /classes/Product.php:3717 (priceCalculation) /classes/Product.php:748 (getPriceStatic) /controllers/front/ProductController.php:146 (__construct) /tools/profiling/Controller.php:46 (init) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
306	SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) + IF (`id_country` = 217, 4, 0) + IF (`id_currency` = 2, 8, 0) + IF (`id_shop` = 1, 16, 0) + IF (`id_customer` = 0, 32, 0)) AS `score` FROM `ps_specific_price` WHERE `id_shop` IN (0, 1) AND `id_currency` IN (0, 2) AND `id_country` IN (0, 217) AND `id_group` IN (0, 1) AND `id_product` = 100479 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0 AND (`from` = '0000-00-00 00:00:00' OR '2026-06-27 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2026-06-27 00:00:00' <= `to`) AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1	0.612 ms	1	Yes		/classes/SpecificPrice.php:576 /classes/Product.php:3827 (getSpecificPrice) /classes/Product.php:3717 (priceCalculation) /classes/Product.php:5703 (getPriceStatic) /classes/Product.php:6001 (getProductProperties) /classes/ProductSale.php:161 (getProductsProperties) /src/Adapter/BestSales/BestSalesProductSearchProvider.php:74 (getBestSales) /modules/ps_bestsellers/ps_bestsellers.php:195 (runQuery) /modules/ps_bestsellers/ps_bestsellers.php:161 (getBestSellers) /modules/novthemeconfig/novthemeconfig.php:286 (getWidgetVariables) /classes/Hook.php:1083 (hookHeader) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:428 (coreCallHook) /classes/Hook.php:989 (callHookOn) /classes/controller/FrontController.php:633 (exec) /controllers/front/ProductController.php:465 (initContent) /tools/profiling/Controller.php:65 (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-intl-normalizer/bootstrap.php
13	/vendor/symfony/polyfill-intl-idn/bootstrap.php
14	/vendor/symfony/deprecation-contracts/function.php
15	/vendor/ralouphie/getallheaders/src/getallheaders.php
16	/vendor/symfony/polyfill-ctype/bootstrap.php
17	/vendor/symfony/polyfill-php80/bootstrap.php
18	/vendor/guzzlehttp/promises/src/functions_include.php
19	/vendor/guzzlehttp/promises/src/functions.php
20	/vendor/guzzlehttp/guzzle/src/functions_include.php
21	/vendor/guzzlehttp/guzzle/src/functions.php
22	/vendor/symfony/polyfill-iconv/bootstrap.php
23	/vendor/ezyang/htmlpurifier/library/HTMLPurifier.composer.php
24	/vendor/jakeasmith/http_build_url/src/http_build_url.php
25	/vendor/lcobucci/jwt/compat/class-aliases.php
26	/vendor/lcobucci/jwt/src/Token.php
27	/vendor/lcobucci/jwt/src/Signature.php
28	/vendor/lcobucci/jwt/compat/json-exception-polyfill.php
29	/vendor/lcobucci/jwt/compat/lcobucci-clock-polyfill.php
30	/vendor/swiftmailer/swiftmailer/lib/swift_required.php
31	/vendor/swiftmailer/swiftmailer/lib/classes/Swift.php
32	/vendor/symfony/polyfill-intl-icu/bootstrap.php
33	/vendor/symfony/polyfill-php73/bootstrap.php
34	/vendor/symfony/polyfill-php81/bootstrap.php
35	/vendor/api-platform/core/src/deprecation.php
36	/vendor/api-platform/core/src/Api/FilterInterface.php
37	/vendor/api-platform/core/src/Api/ResourceClassResolverInterface.php
38	/vendor/api-platform/core/src/deprecated_interfaces.php
39	/vendor/api-platform/core/src/Metadata/Property/Factory/PropertyNameCollectionFactoryInterface.php