Sale 70% OFF

Sweet Lil Baby Lettering Embroidery Design Pattern

Included Design Sizes Are For 4X4, 5X7, 8x8, 6X10, and 12x12 Hoop.

Included File Formats: PES, XXX, VIP, VP3, HUS, JEF, SEW, EXP, PCS, DST.

PDF color sequence sheet is included.

Full Set Available HERE

Please note that you must have an embroidery machine and a method to transfer the digital embroidery file to your machine. You're not purchasing a graphic file, patch, or finished product from our website.

$1.20 No tax

1.2 Tax excluded

$4.00 SAVE $2.80

High-quality, manually digitized machine embroidery and applique designs since 2012.

Annual Premium Membership Plan

KNOW MORE

Description

Sweet Lil Baby Machine Embroidery Design Pattern For Baby Shower.

Our professional embroidery digitizers manually digitize every machine embroidery and applique design to ensure the best quality stitch out.

Related Products

Expecting Something Sweet Baby Quote Embroidery Design Pattern

$1.20 $4.00

Good Night Owl Lettering Applique Design Pattern

$1.20 $4.00

Love Firefighter Lettering Embroidery Design Pattern

$1.20 $4.00

Mrs. Always Right Embroidery Design Pattern

$1.20 $4.00

Mrs. Always Right-2 Embroidery Design Pattern

$1.20 $4.00

Welcome To Our Hive Bee Lettering Embroidery Design Pattern

$1.20 $4.00

Load Time	208.927 ms
Querying Time	126 ms
Queries	293
Memory Peak Usage	11.4 Mb
Included Files	979 files - 10.67 Mb
PrestaShop Cache	- Mb
Global vars	0.21 Mb
- global $_MODULES	172k
- global $_MODULE	22k
- global $_SERVER	6k
- global $config	5k
- global $smarty	4k
- global $context	3k
- global $exportPhpConfigFile	3k
- global $__composer_autoload_files	1k

PrestaShop Version	9.0.3
PHP Version	8.4.21
MySQL Version	11.8.6-MariaDB
Memory Limit	2048M
Max Execution Time	300s
Smarty Cache	enabled
Smarty Compilation	never recompile

	Time	Cumulated Time	Memory Usage	Memory Peak Usage
config	29.606 ms	29.606 ms	4.12 Mb	5.4 Mb
__construct	0.011 ms	29.617 ms	- Mb	5.4 Mb
init	21.577 ms	51.194 ms	1.32 Mb	5.5 Mb
checkAccess	0.001 ms	51.195 ms	- Mb	5.5 Mb
setMedia	1.744 ms	52.939 ms	0.08 Mb	5.5 Mb
postProcess	0.005 ms	52.944 ms	- Mb	5.5 Mb
initHeader	0.001 ms	52.945 ms	- Mb	5.5 Mb
initContent	56.510 ms	109.455 ms	2.64 Mb	8.2 Mb
initFooter	0.002 ms	109.457 ms	- Mb	8.2 Mb
display	99.470 ms	208.927 ms	2.95 Mb	11.4 Mb

Hook	Time	Memory Usage
DisplayBeforeBodyClosingTag	67.604 ms	0.80 Mb
=> statsdata	1.710 ms	0.13 Mb
=> htmlboxpro	0.006 ms	- Mb
=> rcpgtagmanager	8.262 ms	0.43 Mb
=> advancedpopupcreator	57.626 ms	0.25 Mb
DisplayHeader	10.164 ms	0.37 Mb
=> ps_shoppingcart	0.040 ms	- Mb
=> ps_searchbar	0.327 ms	0.01 Mb
=> zonecolorsfonts	0.621 ms	0.03 Mb
=> zonemegamenu	0.438 ms	0.01 Mb
=> zonethememanager	0.364 ms	0.01 Mb
=> nrtsociallogin	0.092 ms	- Mb
=> ets_recaptcha_free	0.011 ms	- Mb
=> blackholebots	0.169 ms	- Mb
=> stripe_official	4.014 ms	0.23 Mb
=> htmlboxpro	0.009 ms	- Mb
=> rcpgtagmanager	2.933 ms	0.04 Mb
=> ets_abandonedcart	0.627 ms	0.01 Mb
=> advancedpopupcreator	0.519 ms	0.01 Mb
displayTop	4.877 ms	0.51 Mb
=> ps_searchbar (widget)	0.466 ms	0.04 Mb
=> ps_customersignin (widget)	0.478 ms	0.04 Mb
=> ps_currencyselector (widget)	3.027 ms	0.36 Mb
=> ps_shoppingcart (widget)	0.906 ms	0.07 Mb
DisplayReassurance	4.197 ms	0.27 Mb
=> htmlboxpro	4.197 ms	0.27 Mb
ActionProductOutOfStock	3.477 ms	0.18 Mb
=> htmlboxpro	3.477 ms	0.18 Mb
DisplayProduct3rdColumn	1.919 ms	0.10 Mb
=> zoneproductadditional	1.919 ms	0.10 Mb
DisplayProductAdditionalInfo2	1.595 ms	0.10 Mb
=> zoneproductadditional	1.595 ms	0.10 Mb
DisplayAfterProductThumbs2	1.487 ms	0.10 Mb
=> zoneproductadditional	1.487 ms	0.10 Mb
ActionFrontControllerSetVariables	1.378 ms	0.08 Mb
=> zonethememanager	1.378 ms	0.08 Mb
displayFooterLeft	1.057 ms	0.08 Mb
=> ps_emailsubscription (widget)	0.577 ms	0.03 Mb
=> ps_socialfollow (widget)	0.480 ms	0.05 Mb
displayProductAdditionalInfo	0.949 ms	0.06 Mb
=> ps_sharebuttons (widget)	0.949 ms	0.06 Mb
DisplayProductExtraContent	0.825 ms	0.04 Mb
=> zoneproductadditional	0.825 ms	0.04 Mb
Header	0.686 ms	0.01 Mb
=> paypal	0.686 ms	0.01 Mb
DisplayFooter	0.623 ms	0.07 Mb
=> zonethememanager	0.001 ms	- Mb
=> blockwishlist	0.581 ms	0.06 Mb
=> blackholebots	0.023 ms	- Mb
=> htmlboxpro	0.005 ms	- Mb
=> ets_abandonedcart	0.013 ms	- Mb
ActionFrontControllerSetMedia	0.400 ms	0.01 Mb
=> blockwishlist	0.194 ms	- Mb
=> ps_emailsubscription	0.046 ms	- Mb
=> ps_socialfollow	0.050 ms	- Mb
=> rcpgtagmanager	0.110 ms	- Mb
DisplayOutsideMainPage	0.390 ms	0.02 Mb
=> zonecolorsfonts	0.212 ms	0.01 Mb
=> zonethememanager	0.178 ms	0.01 Mb
DisplayProductActions	0.319 ms	- Mb
=> blockwishlist	0.178 ms	- Mb
=> blockwishlist	0.141 ms	- Mb
DisplayFooterLeft	0.275 ms	0.01 Mb
=> zonethememanager	0.275 ms	0.01 Mb
DisplayBanner	0.273 ms	0.01 Mb
=> zonethememanager	0.265 ms	0.01 Mb
=> htmlboxpro	0.008 ms	- Mb
DisplayNavFullWidth	0.239 ms	0.01 Mb
=> zonemegamenu	0.234 ms	0.01 Mb
=> htmlboxpro	0.005 ms	- Mb
DisplayFooterAfter	0.231 ms	0.01 Mb
=> zonethememanager	0.226 ms	0.01 Mb
=> htmlboxpro	0.005 ms	- Mb
DisplayFooterRight	0.219 ms	0.02 Mb
=> zonethememanager	0.219 ms	0.02 Mb
DisplayNav1	0.199 ms	0.01 Mb
=> zonethememanager	0.194 ms	0.01 Mb
=> htmlboxpro	0.005 ms	- Mb
ModuleRoutes	0.016 ms	0.01 Mb
=> blackholebots	0.011 ms	- Mb
=> ssoconnect	0.001 ms	- Mb
=> ets_abandonedcart	0.004 ms	0.01 Mb
ActionDispatcherBefore	0.013 ms	- Mb
=> ets_abandonedcart	0.013 ms	- Mb
DisplayProductAdditionalInfo	0.008 ms	- Mb
=> htmlboxpro	0.008 ms	- Mb
DisplayFooterProduct	0.008 ms	- Mb
=> htmlboxpro	0.008 ms	- Mb
DisplayAfterProductThumbs	0.007 ms	- Mb
=> htmlboxpro	0.007 ms	- Mb
DisplayTop	0.007 ms	- Mb
=> htmlboxpro	0.007 ms	- Mb
DisplayFooterBefore	0.006 ms	- Mb
=> htmlboxpro	0.006 ms	- Mb
DisplayNav2	0.003 ms	- Mb
=> htmlboxpro	0.003 ms	- Mb
31 hook(s)	103.451 ms	2.88 Mb

Module	Time	Memory Usage
blackholebots	1.370 ms	- Mb
__construct	1.161 ms	- Mb
hookModuleRoutes	0.014 ms	- Mb
hookDisplayHeader	0.171 ms	- Mb
hookDisplayFooter	0.024 ms	- Mb
ssoconnect	0.359 ms	0.01 Mb
__construct	0.357 ms	0.01 Mb
hookModuleRoutes	0.002 ms	- Mb
ets_abandonedcart	1.267 ms	0.03 Mb
__construct	0.604 ms	0.01 Mb
hookModuleRoutes	0.006 ms	0.01 Mb
hookActionDispatcherBefore	0.015 ms	- Mb
hookDisplayHeader	0.629 ms	0.01 Mb
hookDisplayFooter	0.013 ms	- Mb
blockwishlist	1.602 ms	0.11 Mb
__construct	0.499 ms	0.04 Mb
hookActionFrontControllerSetMedia	0.197 ms	0.01 Mb
hookDisplayProductActions	0.180 ms	- Mb
hookDisplayProductActions	0.143 ms	- Mb
hookDisplayFooter	0.583 ms	0.06 Mb
ps_emailsubscription	0.775 ms	0.04 Mb
__construct	0.148 ms	0.01 Mb
hookActionFrontControllerSetMedia	0.048 ms	- Mb
displayFooterLeft	0.579 ms	0.03 Mb
ps_socialfollow	0.593 ms	0.06 Mb
__construct	0.061 ms	0.01 Mb
hookActionFrontControllerSetMedia	0.051 ms	- Mb
displayFooterLeft	0.481 ms	0.05 Mb
rcpgtagmanager	11.597 ms	0.48 Mb
__construct	0.284 ms	0.01 Mb
hookActionFrontControllerSetMedia	0.112 ms	- Mb
hookDisplayHeader	2.936 ms	0.04 Mb
hookDisplayBeforeBodyClosingTag	8.265 ms	0.43 Mb
zoneproductadditional	6.045 ms	0.44 Mb
__construct	0.207 ms	0.10 Mb
hookDisplayProductExtraContent	0.828 ms	0.04 Mb
hookDisplayProduct3rdColumn	1.922 ms	0.10 Mb
hookDisplayAfterProductThumbs2	1.490 ms	0.10 Mb
hookDisplayProductAdditionalInfo2	1.598 ms	0.10 Mb
zonethememanager	3.284 ms	0.18 Mb
__construct	0.168 ms	0.01 Mb
hookActionFrontControllerSetVariables	1.381 ms	0.08 Mb
hookDisplayHeader	0.366 ms	0.01 Mb
hookDisplayBanner	0.267 ms	0.01 Mb
hookDisplayNav1	0.195 ms	0.01 Mb
hookDisplayFooterLeft	0.277 ms	0.01 Mb
hookDisplayFooterRight	0.220 ms	0.02 Mb
hookDisplayFooter	0.002 ms	- Mb
hookDisplayFooterAfter	0.228 ms	0.01 Mb
hookDisplayOutsideMainPage	0.180 ms	0.01 Mb
ps_shoppingcart	1.028 ms	0.08 Mb
__construct	0.078 ms	0.01 Mb
hookDisplayHeader	0.042 ms	- Mb
displayTop	0.908 ms	0.07 Mb
ps_searchbar	0.877 ms	0.05 Mb
__construct	0.080 ms	0.01 Mb
hookDisplayHeader	0.329 ms	0.01 Mb
displayTop	0.468 ms	0.04 Mb
zonecolorsfonts	0.940 ms	0.05 Mb
__construct	0.103 ms	0.01 Mb
hookDisplayHeader	0.623 ms	0.04 Mb
hookDisplayOutsideMainPage	0.214 ms	0.01 Mb
zonemegamenu	0.793 ms	0.03 Mb
__construct	0.117 ms	0.01 Mb
hookDisplayHeader	0.440 ms	0.01 Mb
hookDisplayNavFullWidth	0.236 ms	0.02 Mb
nrtsociallogin	0.186 ms	0.01 Mb
__construct	0.092 ms	0.01 Mb
hookDisplayHeader	0.094 ms	- Mb
ets_recaptcha_free	0.141 ms	0.01 Mb
__construct	0.128 ms	0.01 Mb
hookDisplayHeader	0.013 ms	- Mb
paypal	1.470 ms	0.18 Mb
__construct	0.782 ms	0.17 Mb
hookHeader	0.688 ms	0.01 Mb
stripe_official	4.484 ms	0.28 Mb
__construct	0.468 ms	0.05 Mb
hookDisplayHeader	4.016 ms	0.23 Mb
htmlboxpro	8.003 ms	0.48 Mb
__construct	0.225 ms	0.02 Mb
hookDisplayHeader	0.010 ms	- Mb
hookDisplayBanner	0.009 ms	- Mb
hookDisplayNav1	0.006 ms	- Mb
hookDisplayNav2	0.004 ms	- Mb
hookDisplayTop	0.009 ms	- Mb
hookDisplayNavFullWidth	0.006 ms	- Mb
hookDisplayAfterProductThumbs	0.009 ms	- Mb
hookActionProductOutOfStock	3.480 ms	0.18 Mb
hookDisplayProductAdditionalInfo	0.009 ms	- Mb
hookDisplayReassurance	4.199 ms	0.27 Mb
hookDisplayFooterProduct	0.010 ms	- Mb
hookDisplayFooterBefore	0.008 ms	- Mb
hookDisplayFooter	0.006 ms	- Mb
hookDisplayFooterAfter	0.006 ms	- Mb
hookDisplayBeforeBodyClosingTag	0.007 ms	- Mb
advancedpopupcreator	58.298 ms	0.31 Mb
__construct	0.146 ms	0.05 Mb
hookDisplayHeader	0.521 ms	0.02 Mb
hookDisplayBeforeBodyClosingTag	57.631 ms	0.25 Mb
ps_customersignin	0.565 ms	0.05 Mb
__construct	0.085 ms	0.01 Mb
displayTop	0.480 ms	0.04 Mb
ps_currencyselector	3.087 ms	0.37 Mb
__construct	0.058 ms	0.01 Mb
displayTop	3.029 ms	0.36 Mb
ps_sharebuttons	1.036 ms	0.07 Mb
__construct	0.085 ms	0.01 Mb
displayProductAdditionalInfo	0.951 ms	0.06 Mb
statsdata	1.785 ms	0.13 Mb
__construct	0.073 ms	0.01 Mb
hookDisplayBeforeBodyClosingTag	1.712 ms	0.13 Mb
23 module(s)	109.586 ms	3.40 Mb

Sweet Lil Baby Lettering Embroidery Design Pattern

High-quality, manually digitized machine embroidery and applique designs since 2012.

Annual Premium Membership Plan

Sweet Lil Baby Machine Embroidery Design Pattern For Baby Shower.

Stopwatch SQL - 293 queries

Doubles

Tables stress

ObjectModel instances

Included Files

14 queries	SELECT `id_lang` FROM `ps_lang` WHERE `locale` = 'en-us' OR `language_code` = 'en-us' LIMIT XX
9 queries	SELECT `id_module` FROM `ps_module_shop` WHERE `id_module` = XX AND `id_shop` = XX LIMIT XX
8 queries	SELECT XX FROM `ps_specific_price` WHERE id_product = XX LIMIT XX
8 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`
7 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
7 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
7 queries	SELECT * FROM `ps_currency_lang` WHERE `id_currency` = XX
7 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
7 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
7 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
7 queries	SELECT product_shop.`price`, product_shop.`ecotax`, XX as id_product_attribute FROM `ps_product` p INNER JOIN `ps_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = XX) WHERE (p.`id_product` = XX)
7 queries	SELECT `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = XX AND `id_group` = XX LIMIT XX
7 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
7 queries	SELECT ctg.`id_group` FROM `ps_category_product` cp INNER JOIN `ps_category_group` ctg ON (ctg.`id_category` = cp.`id_category`) WHERE cp.`id_product` = XX AND ctg.`id_group` = XX LIMIT XX
7 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
7 queries	SELECT name FROM ps_category_lang WHERE id_shop = XX AND id_lang = XX AND id_category = XX LIMIT XX
6 queries	SELECT pa.`id_product`, a.`color`, pac.`id_product_attribute`, SUM(IF(stock.`quantity` > XX, XX, XX)) qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by FROM `ps_product_attribute` pa INNER JOIN ps_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = XX) LEFT JOIN ps_stock_available stock ON (stock.id_product = `pa`.id_product AND stock.id_product_attribute = XX AND stock.id_shop = XX AND stock.id_shop_group = XX ) JOIN `ps_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`) JOIN `ps_attribute` a ON (a.`id_attribute` = pac.`id_attribute`) JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = XX) JOIN `ps_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`) WHERE pa.`id_product` IN (XX) AND ag.`is_color_group` = XX GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` HAVING qty > XX ORDER BY a.`position` ASC;
5 queries	SELECT COUNT(p.id_product) FROM `ps_product` p INNER JOIN ps_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = XX) WHERE p.id_product = XX AND DATEDIFF("XX-XX-XX XX:XX:XX", product_shop.`date_add`) < XX LIMIT XX
4 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
4 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
4 queries	SELECT out_of_stock FROM `ps_stock_available` WHERE (id_product = XX) AND (id_product_attribute = XX) AND (id_shop = XX) AND (id_shop_group = XX) LIMIT XX
4 queries	SELECT location FROM `ps_stock_available` WHERE (id_product = XX) AND (id_product_attribute = XX) AND (id_shop = XX) AND (id_shop_group = XX) LIMIT XX
4 queries	SELECT e.*, el.`title`, el.`content` FROM `ps_zproduct_extra_field` e LEFT JOIN `ps_zproduct_extra_field_lang` el ON (el.`id_zproduct_extra_field` = e.`id_zproduct_extra_field` AND el.`id_lang` = XX) WHERE e.`id_shop` = XX AND e.`active` = XX ORDER BY e.position
4 queries	SELECT `id_manufacturer` FROM `ps_product` WHERE `id_product` = XX LIMIT XX
4 queries	SELECT DISTINCT `id_supplier` FROM `ps_product_supplier` WHERE `id_product_attribute` = XX AND `id_product` = XX
4 queries	SELECT DISTINCT `id_feature_value` FROM `ps_feature_product` WHERE `id_product` = 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
2 queries	SELECT `id_country` FROM `ps_country` WHERE `iso_code` = 'US' LIMIT XX
2 queries	SELECT cl.`link_rewrite` FROM `ps_category_lang` cl WHERE `id_lang` = XX AND cl.id_shop = XX AND cl.`id_category` = XX LIMIT XX
2 queries	SELECT * FROM `ps_category` a LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = XX LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = XX WHERE (a.`id_category` = XX) AND (b.`id_shop` = XX) LIMIT XX
2 queries	SELECT * FROM `ps_category` aXX LEFT JOIN `ps_category_lang` `aXX` ON (aXX.`id_category` = aXX.`id_category`) WHERE (aXX.`nleft` < XX) AND (aXX.`nright` > XX) AND (aXX.`id_lang` = XX) AND (aXX.`id_shop` = XX) ORDER BY aXX.`nleft` asc
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 COUNT(*) FROM `ps_orders` o LEFT JOIN `ps_order_cart_rule` ocr ON (ocr.`id_order` = o.`id_order`) WHERE o.`id_customer` = XX AND ocr.`deleted` = XX AND ocr.`id_cart_rule` = XX LIMIT XX

Name	Instances	Source
Product	48	/controllers/front/ProductController.php:149 (__construct) [id: 2954] /src/Adapter/Image/ImageRetriever.php:68 (__construct) [id: 2954] /src/Adapter/Image/ImageRetriever.php:68 (__construct) [id: 4622] /src/Adapter/Image/ImageRetriever.php:68 (__construct) [id: 4473] /src/Adapter/Image/ImageRetriever.php:68 (__construct) [id: 3838] /src/Adapter/Image/ImageRetriever.php:68 (__construct) [id: 90] /src/Adapter/Image/ImageRetriever.php:68 (__construct) [id: 1523] /src/Adapter/Image/ImageRetriever.php:68 (__construct) [id: 4243] /classes/Meta.php:340 (__construct) [id: 2954] /classes/Link.php:114 (__construct) [id: 2954] /src/Adapter/Image/ImageRetriever.php:68 (__construct) [id: 2954] /classes/Link.php:114 (__construct) [id: 2954] /classes/Link.php:114 (__construct) [id: 2954] /classes/Link.php:114 (__construct) [id: 2954] /classes/Link.php:114 (__construct) [id: 2954] /classes/Link.php:114 (__construct) [id: 2954] /classes/Link.php:114 (__construct) [id: 2954] /classes/Link.php:114 (__construct) [id: 2954] /classes/Link.php:114 (__construct) [id: 2954] /modules/htmlboxpro/htmlboxpro.php:3291 (__construct) [id: 2954] /modules/htmlboxpro/htmlboxpro.php:3284 (__construct) [id: 2954] /modules/htmlboxpro/htmlboxpro.php:3291 (__construct) [id: 2954] /classes/Link.php:114 (__construct) [id: 4622] /classes/Link.php:114 (__construct) [id: 4473] /classes/Link.php:114 (__construct) [id: 3838] /classes/Link.php:114 (__construct) [id: 90] /classes/Link.php:114 (__construct) [id: 1523] /classes/Link.php:114 (__construct) [id: 4243] /modules/rcpgtagmanager/src/PSModule/DataModelHandler/ModelBuilder/Product/AbstractProductModelBuilder.php:51 (__construct) [id: 2954] /classes/Link.php:114 (__construct) [id: 4622] /classes/Link.php:114 (__construct) [id: 4622] /modules/rcpgtagmanager/src/PSModule/DataModelHandler/ModelBuilder/Product/AbstractProductModelBuilder.php:51 (__construct) [id: 4622] /classes/Link.php:114 (__construct) [id: 4473] /classes/Link.php:114 (__construct) [id: 4473] /modules/rcpgtagmanager/src/PSModule/DataModelHandler/ModelBuilder/Product/AbstractProductModelBuilder.php:51 (__construct) [id: 4473] /classes/Link.php:114 (__construct) [id: 3838] /classes/Link.php:114 (__construct) [id: 3838] /modules/rcpgtagmanager/src/PSModule/DataModelHandler/ModelBuilder/Product/AbstractProductModelBuilder.php:51 (__construct) [id: 3838] /classes/Link.php:114 (__construct) [id: 90] /classes/Link.php:114 (__construct) [id: 90] /modules/rcpgtagmanager/src/PSModule/DataModelHandler/ModelBuilder/Product/AbstractProductModelBuilder.php:51 (__construct) [id: 90] /classes/Link.php:114 (__construct) [id: 1523] /classes/Link.php:114 (__construct) [id: 1523] /modules/rcpgtagmanager/src/PSModule/DataModelHandler/ModelBuilder/Product/AbstractProductModelBuilder.php:51 (__construct) [id: 1523] /classes/Link.php:114 (__construct) [id: 4243] /classes/Link.php:114 (__construct) [id: 4243] /modules/rcpgtagmanager/src/PSModule/DataModelHandler/ModelBuilder/Product/AbstractProductModelBuilder.php:51 (__construct) [id: 4243] /modules/advancedpopupcreator/classes/AdvancedPopup.php:420 (__construct) [id: 2954]
Currency	19	/src/Adapter/Currency/CurrencyDataProvider.php:101 (__construct) [id: 4] /src/Adapter/Currency/CurrencyDataProvider.php:101 (__construct) [id: 5] /src/Adapter/Currency/CurrencyDataProvider.php:101 (__construct) [id: 7] /src/Adapter/Currency/CurrencyDataProvider.php:101 (__construct) [id: 1] /src/Adapter/Currency/CurrencyDataProvider.php:101 (__construct) [id: 3] /src/Adapter/Currency/CurrencyDataProvider.php:101 (__construct) [id: 6] /src/Adapter/Currency/CurrencyDataProvider.php:101 (__construct) [id: 2] /classes/Tools.php:708 (getCurrencyInstance) [id: 2] /modules/stripe_official/classes/services/StripeDisplayHeaderService.php:73 (__construct) [id: 2] /modules/ps_currencyselector/ps_currencyselector.php:112 (getCurrencies) [id: 4] /modules/ps_currencyselector/ps_currencyselector.php:112 (getCurrencies) [id: 5] /modules/ps_currencyselector/ps_currencyselector.php:112 (getCurrencies) [id: 7] /modules/ps_currencyselector/ps_currencyselector.php:112 (getCurrencies) [id: 1] /modules/ps_currencyselector/ps_currencyselector.php:112 (getCurrencies) [id: 3] /modules/ps_currencyselector/ps_currencyselector.php:112 (getCurrencies) [id: 6] /modules/htmlboxpro/htmlboxpro.php:3306 (__construct) [id: 2] /modules/htmlboxpro/htmlboxpro.php:517 (__construct) [id: 2] /modules/htmlboxpro/htmlboxpro.php:3306 (__construct) [id: 2] /modules/htmlboxpro/htmlboxpro.php:517 (__construct) [id: 2]
Category	15	/controllers/front/ProductController.php:308 (__construct) [id: 15] /controllers/front/ProductController.php:1334 (__construct) [id: 15] /classes/PrestaShopCollection.php:383 (hydrateCollection) [id: ] /classes/PrestaShopCollection.php:383 (hydrateCollection) [id: ] /controllers/front/ProductController.php:1334 (__construct) [id: 15] /classes/PrestaShopCollection.php:383 (hydrateCollection) [id: ] /classes/PrestaShopCollection.php:383 (hydrateCollection) [id: ] /modules/rcpgtagmanager/src/PSModule/DataModelHandler/ModelBuilder/Category/AbstractCategoryModelBuilder.php:39 (__construct) [id: 15] /modules/rcpgtagmanager/src/PSModule/DataModelHandler/ModelBuilder/Category/AbstractCategoryModelBuilder.php:56 (getParentsCategories) [id: 2] /modules/rcpgtagmanager/src/PSModule/DataModelHandler/ModelBuilder/Category/AbstractCategoryModelBuilder.php:39 (__construct) [id: 15] /modules/rcpgtagmanager/src/PSModule/DataModelHandler/ModelBuilder/Category/AbstractCategoryModelBuilder.php:39 (__construct) [id: 15] /modules/rcpgtagmanager/src/PSModule/DataModelHandler/ModelBuilder/Category/AbstractCategoryModelBuilder.php:39 (__construct) [id: 15] /modules/rcpgtagmanager/src/PSModule/DataModelHandler/ModelBuilder/Category/AbstractCategoryModelBuilder.php:39 (__construct) [id: 15] /modules/rcpgtagmanager/src/PSModule/DataModelHandler/ModelBuilder/Category/AbstractCategoryModelBuilder.php:39 (__construct) [id: 15] /modules/rcpgtagmanager/src/PSModule/DataModelHandler/ModelBuilder/Category/AbstractCategoryModelBuilder.php:39 (__construct) [id: 15]
Address	10	/classes/Product.php:723 (__construct) [id: ] /classes/Product.php:6595 (initialize) [id: ] /classes/Product.php:3573 (__construct) [id: ] /controllers/front/ProductController.php:555 (__construct) [id: 0] /classes/Product.php:5723 (__construct) [id: ] /classes/shop/Shop.php:487 (__construct) [id: ] /modules/stripe_official/classes/services/StripeDisplayHeaderService.php:72 (__construct) [id: 0] /classes/Product.php:723 (__construct) [id: ] /classes/Product.php:723 (__construct) [id: ] /classes/Product.php:723 (__construct) [id: ]
Country	5	/config/config.inc.php:154 (__construct) [id: 21] /classes/AddressFormat.php:402 (__construct) [id: 21] /classes/controller/FrontController.php:1739 (__construct) [id: 21] /modules/paypal/paypal.php:398 (__construct) [id: 21] /modules/stripe_official/classes/services/StripeDisplayHeaderService.php:79 (__construct) [id: 21]
Manufacturer	3	/controllers/front/ProductController.php:856 (__construct) [id: 1] /src/Adapter/Presenter/Manufacturer/ManufacturerLazyArray.php:98 (__construct) [id: 1] /classes/Link.php:669 (__construct) [id: 1]
State	2	/classes/AddressFormat.php:402 (__construct) [id: 1] /classes/controller/FrontController.php:1738 (__construct) [id: 1]
Language	2	/config/config.inc.php:219 (__construct) [id: 1] /classes/Tools.php:553 (__construct) [id: 1]
Group	2	/classes/Cart.php:275 (getCurrent) [id: 1] /modules/ets_abandonedcart/classes/EtsAbancartCampaign.php:426 (__construct) [id: 1]
ConnectionsSource	1	/modules/statsdata/statsdata.php:119 (logHttpReferer) [id: ]
Connection	1	/modules/statsdata/statsdata.php:118 (setPageConnection) [id: ]
Guest	1	/modules/statsdata/statsdata.php:82 (setNewGuest) [id: ]
ZManager	1	/modules/zonethememanager/zonethememanager.php:1941 (getSettingsByShop) [id: 1]
Shop	1	/config/config.inc.php:122 (initialize) [id: 1]
AddressFormat	1	/classes/controller/FrontController.php:1733 (generateAddress) [id: ]
Risk	1	/classes/controller/FrontController.php:1659 (__construct) [id: ]
Gender	1	/classes/controller/FrontController.php:1656 (__construct) [id: 0]
Cart	1	/classes/controller/FrontController.php:459 (__construct) [id: ]
Customer	1	/config/config.inc.php:272 (__construct) [id: ]
ShopGroup	1	/classes/shop/Shop.php:562 (__construct) [id: 1]
AdvancedPopup	1	/modules/advancedpopupcreator/advancedpopupcreator.php:251 (__construct) [id: ]

#	Query	Time (ms)	Rows	Filesort	Group By	Location
285	SELECT SQL_NO_CACHE COUNT(*) FROM `ps_advancedpopup_user` WHERE `hash_id` = "bae5b4b18b8624c2cf25efb508131924" LIMIT 1	28.073 ms	172855			/modules/advancedpopupcreator/classes/AdvancedPopup.php:1193 /modules/advancedpopupcreator/classes/AdvancedPopup.php:1150 (generateUniqueHashId) /modules/advancedpopupcreator/classes/AdvancedPopup.php:314 (setApcCookiePopups) /modules/advancedpopupcreator/advancedpopupcreator.php:252 (getPopups) /modules/advancedpopupcreator/advancedpopupcreator.php:199 (hookDisplayFooter) /classes/Hook.php:1237 (hookDisplayBeforeBodyClosingTag) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:454 (coreCallHook) /classes/Hook.php:1128 (callHookOn) /config/smarty.config.inc.php:213 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/prod/smarty/compile/ZOneThemelayouts_layout_full_width_tpl/41/22/27/412227c1898d7fcb8f95dc7cb092ba8dee323539_2.file.layout-both-columns.tpl.php:534 (__call) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/ZOneThemelayouts_layout_full_width_tpl/41/22/27/412227c1898d7fcb8f95dc7cb092ba8dee323539_2.file.layout-both-columns.tpl.php:155 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69fa46dee18ed2_91847339) /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:115 (_subTemplateRender) /var/cache/prod/smarty/compile/ZOneThemelayouts_layout_full_width_tpl/5d/78/7c/5d787caf864fa82876e67ad2e9724f8b2bd753d4_2.file.layout-full-width.tpl.php:42 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69fa46dee06285_92334566) /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:115 (_subTemplateRender) /var/cache/prod/smarty/compile/ZOneThemelayouts_layout_full_width_tpl/f9/22/72/f92272f0fabd5468e790fb9ffe893dff8edf07e0_2.file.product.tpl.php:53 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69fa46dedffd94_55239211) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/controller/FrontController.php:757 (fetch) /classes/controller/FrontController.php:741 (smartyOutputContent) /tools/profiling/Controller.php:111 (display) /tools/profiling/Controller.php:88 (displayProfiling) /classes/Dispatcher.php:488 (run) /index.php:86 (dispatch)
286	SELECT SQL_NO_CACHE `hash_id` FROM `ps_advancedpopup_user` WHERE `hash_id` = "bae5b4b18b8624c2cf25efb508131924" LIMIT 1	26.871 ms	172855			/modules/advancedpopupcreator/classes/AdvancedPopup.php:1165 /modules/advancedpopupcreator/classes/AdvancedPopup.php:314 (setApcCookiePopups) /modules/advancedpopupcreator/advancedpopupcreator.php:252 (getPopups) /modules/advancedpopupcreator/advancedpopupcreator.php:199 (hookDisplayFooter) /classes/Hook.php:1237 (hookDisplayBeforeBodyClosingTag) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:454 (coreCallHook) /classes/Hook.php:1128 (callHookOn) /config/smarty.config.inc.php:213 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/prod/smarty/compile/ZOneThemelayouts_layout_full_width_tpl/41/22/27/412227c1898d7fcb8f95dc7cb092ba8dee323539_2.file.layout-both-columns.tpl.php:534 (__call) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/ZOneThemelayouts_layout_full_width_tpl/41/22/27/412227c1898d7fcb8f95dc7cb092ba8dee323539_2.file.layout-both-columns.tpl.php:155 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69fa46dee18ed2_91847339) /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:115 (_subTemplateRender) /var/cache/prod/smarty/compile/ZOneThemelayouts_layout_full_width_tpl/5d/78/7c/5d787caf864fa82876e67ad2e9724f8b2bd753d4_2.file.layout-full-width.tpl.php:42 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69fa46dee06285_92334566) /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:115 (_subTemplateRender) /var/cache/prod/smarty/compile/ZOneThemelayouts_layout_full_width_tpl/f9/22/72/f92272f0fabd5468e790fb9ffe893dff8edf07e0_2.file.product.tpl.php:53 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69fa46dedffd94_55239211) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/controller/FrontController.php:757 (fetch) /classes/controller/FrontController.php:741 (smartyOutputContent) /tools/profiling/Controller.php:111 (display) /tools/profiling/Controller.php:88 (displayProfiling) /classes/Dispatcher.php:488 (run) /index.php:86 (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`)	6.584 ms	5284			/classes/Configuration.php:182 /classes/Configuration.php:230 (loadConfiguration) /classes/Configuration.php:303 (get) /classes/shop/Shop.php:399 (getMultiShopValues) /config/config.inc.php:122 (initialize) /index.php:40 (require_once)
108	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_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-05-12 00:00:00", INTERVAL 120 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` = 2954 AND product_shop.`active` = 1 AND product_shop.`visibility` != 'none' GROUP BY product_shop.id_product ORDER BY pl.`name`	1.940 ms	6	Yes	Yes	/classes/Product.php:4505 /controllers/front/ProductController.php:379 (getAccessories) /override/controllers/front/ProductController.php:68 (initContent) /tools/profiling/Controller.php:65 (initContent) /classes/Dispatcher.php:488 (run) /index.php:86 (dispatch)
63	SELECT SQL_NO_CACHE `id_hook`, `name` FROM `ps_hook` UNION SELECT `id_hook`, ha.`alias` as name FROM `ps_hook_alias` ha INNER JOIN `ps_hook` h ON ha.name = h.name	1.857 ms	0			/classes/Hook.php:1568 /classes/Hook.php:251 (getAllHookIds) /classes/tax/TaxManagerFactory.php:63 (getIdByName) /classes/tax/TaxManagerFactory.php:42 (execHookTaxManagerFactory) /classes/Product.php:6598 (getManager) /classes/Product.php:723 (getTaxesRate) /controllers/front/ProductController.php:149 (__construct) /tools/profiling/Controller.php:46 (init) /classes/Dispatcher.php:488 (run) /index.php:86 (dispatch)
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) INNER JOIN `ps_hook_module` `hm` ON hm.`id_module` = m.`id_module` INNER JOIN `ps_hook` `h` ON hm.`id_hook` = h.`id_hook` LEFT JOIN `ps_module_group` `mg` ON mg.`id_module` = m.`id_module` WHERE (h.`name` != "paymentOptions") AND (hm.`id_shop` = 1) AND (mg.id_shop = 1 AND mg.`id_group` IN (1)) GROUP BY hm.id_hook, hm.id_module ORDER BY hm.`position`	1.420 ms	244	Yes	Yes	/classes/Hook.php:1500 /classes/Hook.php:809 (getAllHookRegistrations) /classes/Hook.php:952 (getHookModuleExecList) /classes/Dispatcher.php:595 (exec) /classes/Dispatcher.php:253 (loadRoutes) /classes/Dispatcher.php:215 (__construct) /index.php:86 (getInstance)
90	SELECT SQL_NO_CACHE c.*, cl.`id_lang`, cl.`name`, cl.`description`, cl.`additional_description`, cl.`link_rewrite`, cl.`meta_title`, 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` = 15 AND `active` = 1 AND cg.`id_group` =1 GROUP BY c.`id_category` ORDER BY `level_depth` ASC, category_shop.`position` ASC	0.921 ms	1	Yes	Yes	/classes/Category.php:946 /controllers/front/ProductController.php:887 (getSubCategories) /controllers/front/ProductController.php:320 (assignCategory) /override/controllers/front/ProductController.php:68 (initContent) /tools/profiling/Controller.php:65 (initContent) /classes/Dispatcher.php:488 (run) /index.php:86 (dispatch)
64	SELECT SQL_NO_CACHE h.id_hook, h.name as h_name, title, description, h.position, hm.position as hm_position, m.id_module, m.name, m.active FROM `ps_hook_module` hm STRAIGHT_JOIN `ps_hook` h ON (h.id_hook = hm.id_hook AND hm.id_shop = 1) STRAIGHT_JOIN `ps_module` as m ON (m.id_module = hm.id_module) ORDER BY hm.position	0.818 ms	287			/classes/Hook.php:495 /classes/Hook.php:542 (getHookModuleList) /classes/tax/TaxManagerFactory.php:63 (getModulesFromHook) /classes/tax/TaxManagerFactory.php:42 (execHookTaxManagerFactory) /classes/Product.php:6598 (getManager) /classes/Product.php:723 (getTaxesRate) /controllers/front/ProductController.php:149 (__construct) /tools/profiling/Controller.php:46 (init) /classes/Dispatcher.php:488 (run) /index.php:86 (dispatch)
12	SELECT SQL_NO_CACHE lower(name) as name FROM `ps_hook` h WHERE (h.active = 1)	0.817 ms	1411			/classes/Hook.php:1608 /classes/Hook.php:910 (getHookStatusByName) /classes/Dispatcher.php:595 (exec) /classes/Dispatcher.php:253 (loadRoutes) /classes/Dispatcher.php:215 (__construct) /index.php:86 (getInstance)
240	SELECT SQL_NO_CACHE * FROM `ps_hbp_block` AS a INNER JOIN `ps_hbp_block_lang` AS b ON a.id=b.id WHERE a.hook="actionProductOutOfStock" AND active=1 AND b.id_lang=1 ORDER BY a.position	0.743 ms	2	Yes		/modules/htmlboxpro/htmlboxpro.php:771 /modules/htmlboxpro/htmlboxpro.php:3307 (get_blocks) /modules/htmlboxpro/htmlboxpro.php:3432 (generateHookContents) /classes/Hook.php:1237 (hookactionProductOutOfStock) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:454 (coreCallHook) /classes/Hook.php:1128 (callHookOn) /config/smarty.config.inc.php:213 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/prod/smarty/compile/ZOneThemelayouts_layout_full_width_tpl/f9/22/72/f92272f0fabd5468e790fb9ffe893dff8edf07e0_2.file.product.tpl.php:188 (__call) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/ZOneThemelayouts_layout_full_width_tpl/f9/22/72/f92272f0fabd5468e790fb9ffe893dff8edf07e0_2.file.product.tpl.php:248 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/ZOneThemelayouts_layout_full_width_tpl/f9/22/72/f92272f0fabd5468e790fb9ffe893dff8edf07e0_2.file.product.tpl.php:318 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/ZOneThemelayouts_layout_full_width_tpl/f9/22/72/f92272f0fabd5468e790fb9ffe893dff8edf07e0_2.file.product.tpl.php:465 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:186 (process) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/ZOneThemelayouts_layout_full_width_tpl/5d/78/7c/5d787caf864fa82876e67ad2e9724f8b2bd753d4_2.file.layout-full-width.tpl.php:103 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:186 (process) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/ZOneThemelayouts_layout_full_width_tpl/41/22/27/412227c1898d7fcb8f95dc7cb092ba8dee323539_2.file.layout-both-columns.tpl.php:406 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/ZOneThemelayouts_layout_full_width_tpl/41/22/27/412227c1898d7fcb8f95dc7cb092ba8dee323539_2.file.layout-both-columns.tpl.php:106 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69fa46dee18ed2_91847339) /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:115 (_subTemplateRender) /var/cache/prod/smarty/compile/ZOneThemelayouts_layout_full_width_tpl/5d/78/7c/5d787caf864fa82876e67ad2e9724f8b2bd753d4_2.file.layout-full-width.tpl.php:42 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69fa46dee06285_92334566) /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:115 (_subTemplateRender) /var/cache/prod/smarty/compile/ZOneThemelayouts_layout_full_width_tpl/f9/22/72/f92272f0fabd5468e790fb9ffe893dff8edf07e0_2.file.product.tpl.php:53 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69fa46dedffd94_55239211) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/controller/FrontController.php:757 (fetch) /classes/controller/FrontController.php:741 (smartyOutputContent) /tools/profiling/Controller.php:111 (display) /tools/profiling/Controller.php:88 (displayProfiling) /classes/Dispatcher.php:488 (run) /index.php:86 (dispatch)
256	SELECT SQL_NO_CACHE * FROM `ps_hbp_block` AS a INNER JOIN `ps_hbp_block_lang` AS b ON a.id=b.id WHERE a.hook="displayReassurance" AND active=1 AND b.id_lang=1 ORDER BY a.position	0.737 ms	2	Yes		/modules/htmlboxpro/htmlboxpro.php:771 /modules/htmlboxpro/htmlboxpro.php:3307 (get_blocks) /modules/htmlboxpro/htmlboxpro.php:3412 (generateHookContents) /classes/Hook.php:1237 (hookdisplayReassurance) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:454 (coreCallHook) /classes/Hook.php:1128 (callHookOn) /config/smarty.config.inc.php:213 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/prod/smarty/compile/ZOneThemelayouts_layout_full_width_tpl/f9/22/72/f92272f0fabd5468e790fb9ffe893dff8edf07e0_2.file.product.tpl.php:289 (__call) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/ZOneThemelayouts_layout_full_width_tpl/f9/22/72/f92272f0fabd5468e790fb9ffe893dff8edf07e0_2.file.product.tpl.php:324 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/ZOneThemelayouts_layout_full_width_tpl/f9/22/72/f92272f0fabd5468e790fb9ffe893dff8edf07e0_2.file.product.tpl.php:465 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:186 (process) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/ZOneThemelayouts_layout_full_width_tpl/5d/78/7c/5d787caf864fa82876e67ad2e9724f8b2bd753d4_2.file.layout-full-width.tpl.php:103 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:186 (process) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/ZOneThemelayouts_layout_full_width_tpl/41/22/27/412227c1898d7fcb8f95dc7cb092ba8dee323539_2.file.layout-both-columns.tpl.php:406 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/ZOneThemelayouts_layout_full_width_tpl/41/22/27/412227c1898d7fcb8f95dc7cb092ba8dee323539_2.file.layout-both-columns.tpl.php:106 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69fa46dee18ed2_91847339) /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:115 (_subTemplateRender) /var/cache/prod/smarty/compile/ZOneThemelayouts_layout_full_width_tpl/5d/78/7c/5d787caf864fa82876e67ad2e9724f8b2bd753d4_2.file.layout-full-width.tpl.php:42 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69fa46dee06285_92334566) /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:115 (_subTemplateRender) /var/cache/prod/smarty/compile/ZOneThemelayouts_layout_full_width_tpl/f9/22/72/f92272f0fabd5468e790fb9ffe893dff8edf07e0_2.file.product.tpl.php:53 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69fa46dedffd94_55239211) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/controller/FrontController.php:757 (fetch) /classes/controller/FrontController.php:741 (smartyOutputContent) /tools/profiling/Controller.php:111 (display) /tools/profiling/Controller.php:88 (displayProfiling) /classes/Dispatcher.php:488 (run) /index.php:86 (dispatch)
193	SELECT SQL_NO_CACHE 1 FROM `ps_cart_rule` WHERE ((date_to >= "2026-05-12 00:00:00" AND date_to <= "2026-05-12 23:59:59") OR (date_from >= "2026-05-12 00:00:00" AND date_from <= "2026-05-12 23:59:59") OR (date_from < "2026-05-12 00:00:00" AND date_to > "2026-05-12 23:59:59")) AND `id_customer` IN (0,0) LIMIT 1	0.697 ms	509			/classes/CartRule.php:359 /classes/CartRule.php:391 (haveCartRuleToday) /classes/Cart.php:2861 (getCustomerCartRules) /classes/Cart.php:3187 (getDeliveryOptionList) /classes/Cart.php:3260 (getDeliveryOption) /src/Core/Cart/Fees.php:96 (getTotalShippingCost) /src/Core/Cart/Calculator.php:355 (processCalculation) /src/Core/Cart/Calculator.php:156 (calculateFees) /classes/Cart.php:2101 (processCalculation) /modules/stripe_official/classes/services/StripeDisplayHeaderService.php:74 (getOrderTotal) /modules/stripe_official/stripe_official.php:1247 (setHeaders) /classes/Hook.php:1237 (hookDisplayHeader) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:454 (coreCallHook) /classes/Hook.php:1128 (callHookOn) /classes/controller/FrontController.php:621 (exec) /controllers/front/ProductController.php:416 (initContent) /override/controllers/front/ProductController.php:68 (initContent) /tools/profiling/Controller.php:65 (initContent) /classes/Dispatcher.php:488 (run) /index.php:86 (dispatch)
201	SELECT SQL_NO_CACHE 1 FROM `ps_cart_rule` WHERE ((date_to >= "2026-05-12 00:00:00" AND date_to <= "2026-05-12 23:59:59") OR (date_from >= "2026-05-12 00:00:00" AND date_from <= "2026-05-12 23:59:59") OR (date_from < "2026-05-12 00:00:00" AND date_to > "2026-05-12 23:59:59")) AND `id_customer` IN (0,0) LIMIT 1	0.696 ms	509			/classes/CartRule.php:359 /classes/CartRule.php:391 (haveCartRuleToday) /classes/CartRule.php:572 (getCustomerCartRules) /classes/Cart.php:526 (getCustomerHighlightedDiscounts) /src/Adapter/Presenter/Cart/CartLazyArray.php:322 (getDiscounts) /src/Adapter/Presenter/AbstractLazyArray.php:264 (getDiscounts) /src/Adapter/Presenter/AbstractLazyArray.php:124 (offsetGet) :undefined (jsonSerialize) /classes/Smarty/SmartyLazyRegister.php:81 (json_encode) /var/cache/prod/smarty/compile/ZOneThemelayouts_layout_full_width_tpl/82/c8/38/82c838ee5799d7ae47ef6123c01e85db727d53d8_2.file.javascript.tpl.php:35 (__call) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69fa46dee7aa89_75019352) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /var/cache/prod/smarty/compile/ZOneThemelayouts_layout_full_width_tpl/d2/39/22/d23922e39ba3982f4c4d91825ee8192496e0eb67_2.file.head.tpl.php:421 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/ZOneThemelayouts_layout_full_width_tpl/d2/39/22/d23922e39ba3982f4c4d91825ee8192496e0eb67_2.file.head.tpl.php:71 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69fa46dee32095_80489639) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /var/cache/prod/smarty/compile/ZOneThemelayouts_layout_full_width_tpl/41/22/27/412227c1898d7fcb8f95dc7cb092ba8dee323539_2.file.layout-both-columns.tpl.php:174 (_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/prod/smarty/compile/ZOneThemelayouts_layout_full_width_tpl/41/22/27/412227c1898d7fcb8f95dc7cb092ba8dee323539_2.file.layout-both-columns.tpl.php:48 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69fa46dee18ed2_91847339) /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:115 (_subTemplateRender) /var/cache/prod/smarty/compile/ZOneThemelayouts_layout_full_width_tpl/5d/78/7c/5d787caf864fa82876e67ad2e9724f8b2bd753d4_2.file.layout-full-width.tpl.php:42 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69fa46dee06285_92334566) /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:115 (_subTemplateRender) /var/cache/prod/smarty/compile/ZOneThemelayouts_layout_full_width_tpl/f9/22/72/f92272f0fabd5468e790fb9ffe893dff8edf07e0_2.file.product.tpl.php:53 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69fa46dedffd94_55239211) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/controller/FrontController.php:757 (fetch) /classes/controller/FrontController.php:741 (smartyOutputContent) /tools/profiling/Controller.php:111 (display) /tools/profiling/Controller.php:88 (displayProfiling) /classes/Dispatcher.php:488 (run) /index.php:86 (dispatch)
115	SELECT SQL_NO_CACHE p., ps., pl.*, sa.out_of_stock, IFNULL(sa.quantity, 0) as quantity, (DATEDIFF( p.`date_add`, DATE_SUB( '2026-05-12 00:00:00', INTERVAL 120 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 (4622,4473,3838,90,1523,4243)	0.680 ms	6			/classes/ProductAssembler.php:101 /classes/ProductAssembler.php:211 (addMissingProductFieldsForMultipleProducts) /controllers/front/ProductController.php:381 (assembleProducts) /override/controllers/front/ProductController.php:68 (initContent) /tools/profiling/Controller.php:65 (initContent) /classes/Dispatcher.php:488 (run) /index.php:86 (dispatch)
91	SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop` FROM `ps_category` c LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 ) INNER JOIN ps_category_shop category_shop ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1) WHERE `id_lang` = 1 AND c.`id_parent` = 2 AND `active` = 1 GROUP BY c.`id_category` ORDER BY category_shop.`position` ASC	0.651 ms	59	Yes	Yes	/classes/Category.php:1178 /classes/Category.php:1118 (getChildren) /controllers/front/ProductController.php:897 (getHomeCategories) /controllers/front/ProductController.php:320 (assignCategory) /override/controllers/front/ProductController.php:68 (initContent) /tools/profiling/Controller.php:65 (initContent) /classes/Dispatcher.php:488 (run) /index.php:86 (dispatch)
118	SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) + IF (`id_country` = 21, 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, 21) AND `id_group` IN (0, 1) AND `id_product` = 4622 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0 AND (`from` = '0000-00-00 00:00:00' OR '2026-05-12 17:35:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2026-05-12 17:35: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.616 ms	1	Yes		/classes/SpecificPrice.php:583 /classes/Product.php:3595 (getSpecificPrice) /classes/Product.php:3485 (priceCalculation) /classes/Product.php:5479 (getPriceStatic) /classes/ProductAssembler.php:214 (getProductProperties) /controllers/front/ProductController.php:381 (assembleProducts) /override/controllers/front/ProductController.php:68 (initContent) /tools/profiling/Controller.php:65 (initContent) /classes/Dispatcher.php:488 (run) /index.php:86 (dispatch)
136	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` = 3838 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` = 3838 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1	0.601 ms	0			/classes/Cart.php:1450 /classes/Product.php:4152 (getProductQuantity) /classes/Product.php:5585 (getQuantity) /classes/ProductAssembler.php:214 (getProductProperties) /controllers/front/ProductController.php:381 (assembleProducts) /override/controllers/front/ProductController.php:68 (initContent) /tools/profiling/Controller.php:65 (initContent) /classes/Dispatcher.php:488 (run) /index.php:86 (dispatch)
73	SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) + IF (`id_country` = 21, 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, 21) AND `id_group` IN (0, 1) AND `id_product` = 2954 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0 AND (`from` = '0000-00-00 00:00:00' OR '2026-05-12 17:35:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2026-05-12 17:35: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.568 ms	1	Yes		/classes/SpecificPrice.php:583 /classes/Product.php:3595 (getSpecificPrice) /classes/Product.php:3485 (priceCalculation) /classes/Product.php:730 (getPriceStatic) /controllers/front/ProductController.php:149 (__construct) /tools/profiling/Controller.php:46 (init) /classes/Dispatcher.php:488 (run) /index.php:86 (dispatch)
292	SELECT SQL_NO_CACHE * FROM `ps_advancedpopup` INNER JOIN `ps_advancedpopup_lang` ON `ps_advancedpopup`.`id_advancedpopup` = `ps_advancedpopup_lang`.`id_advancedpopup` WHERE `id_shop` = 1 AND `id_lang` = 1 AND `active` = 1 AND (COALESCE(`zones`, '') = '' OR FIND_IN_SET("2", `zones`)) AND (COALESCE(`date_init`, '1970-01-01 01:00:00') <= "2026-05-12 17:35:43" OR COALESCE(`date_init`, '1970-01-01 01:00:00') = "1970-01-01 05:30:00") AND (COALESCE(`date_end`, '1970-01-01 01:00:00') >= "2026-05-12 17:35:43" OR COALESCE(`date_end`, '1970-01-01 01:00:00') = "1970-01-01 05:30:00") AND ((COALESCE(`customers`, '') = '' AND COALESCE(`customers_excluded`, '') = '') OR (0 > 0 AND ((COALESCE(customers, '') = "" OR FIND_IN_SET("0", customers)) AND (COALESCE(customers_excluded, "") = "" OR NOT FIND_IN_SET("0", customers_excluded))))) AND (COALESCE(`languages`, '') = '' OR FIND_IN_SET("1", `languages`)) AND (COALESCE(`display_ip_string`, '') = '' OR FIND_IN_SET("216.73.216.5", `display_ip_string`)) AND (COALESCE(`display_url_string`, '') = '' OR INSTR("www.sewsweetly.com/2954-sweet-lil-baby-lettering-embroidery-design-pattern", `display_url_string`) > 0) AND (COALESCE(`genders`, '') = '') AND (COALESCE(`groups`, '') = '' OR FIND_IN_SET(1, `groups`)) AND `display_desktop` = 1 AND (COALESCE(`cms`, '') = '') AND (COALESCE(`controller_exceptions`, '') = '' OR FIND_IN_SET("product", `controller_exceptions`)) AND (`display_after_cart` = 1 OR ((COALESCE(products, "") = "" AND COALESCE(products_excluded, "") = "") OR ( (COALESCE(products, "") = "" OR FIND_IN_SET("2954", products)) AND NOT FIND_IN_SET("2954", products_excluded) ) )) AND (COALESCE(`categories`, '') = '' OR FIND_IN_SET(15, `categories`) OR FIND_IN_SET(39, `categories`) OR FIND_IN_SET(47, `categories`)) AND (`display_after_cart` = 1 OR (COALESCE(`manufacturers`, '') = '' OR FIND_IN_SET("1", `manufacturers`))) AND (`display_after_cart` = 1 OR (COALESCE(`suppliers`, '') = '' OR FIND_IN_SET("0", `suppliers`))) ORDER BY `priority` ASC;	0.557 ms	1	Yes		/modules/advancedpopupcreator/classes/AdvancedPopup.php:446 /modules/advancedpopupcreator/advancedpopupcreator.php:252 (getPopups) /modules/advancedpopupcreator/advancedpopupcreator.php:199 (hookDisplayFooter) /classes/Hook.php:1237 (hookDisplayBeforeBodyClosingTag) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:454 (coreCallHook) /classes/Hook.php:1128 (callHookOn) /config/smarty.config.inc.php:213 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/prod/smarty/compile/ZOneThemelayouts_layout_full_width_tpl/41/22/27/412227c1898d7fcb8f95dc7cb092ba8dee323539_2.file.layout-both-columns.tpl.php:534 (__call) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/ZOneThemelayouts_layout_full_width_tpl/41/22/27/412227c1898d7fcb8f95dc7cb092ba8dee323539_2.file.layout-both-columns.tpl.php:155 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69fa46dee18ed2_91847339) /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:115 (_subTemplateRender) /var/cache/prod/smarty/compile/ZOneThemelayouts_layout_full_width_tpl/5d/78/7c/5d787caf864fa82876e67ad2e9724f8b2bd753d4_2.file.layout-full-width.tpl.php:42 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69fa46dee06285_92334566) /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:115 (_subTemplateRender) /var/cache/prod/smarty/compile/ZOneThemelayouts_layout_full_width_tpl/f9/22/72/f92272f0fabd5468e790fb9ffe893dff8edf07e0_2.file.product.tpl.php:53 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69fa46dedffd94_55239211) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/controller/FrontController.php:757 (fetch) /classes/controller/FrontController.php:741 (smartyOutputContent) /tools/profiling/Controller.php:111 (display) /tools/profiling/Controller.php:88 (displayProfiling) /classes/Dispatcher.php:488 (run) /index.php:86 (dispatch)
168	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` = 4243) AND (b.`id_shop` = 1) LIMIT 1	0.537 ms	1			/src/Adapter/EntityMapper.php:74 /classes/ObjectModel.php:217 (load) /tools/profiling/ObjectModel.php:32 (__construct) /classes/Product.php:708 (__construct) /src/Adapter/Image/ImageRetriever.php:68 (__construct) /src/Adapter/Presenter/Product/ProductLazyArray.php:941 (getAllProductImages) /src/Adapter/Presenter/Product/ProductLazyArray.php:137 (fillImages) /src/Adapter/Presenter/Product/ProductListingPresenter.php:50 (__construct) /controllers/front/ProductController.php:383 (present) /override/controllers/front/ProductController.php:68 (initContent) /tools/profiling/Controller.php:65 (initContent) /classes/Dispatcher.php:488 (run) /index.php:86 (dispatch)
15	SELECT SQL_NO_CACHE `id_hook`, `name` FROM `ps_hook`	0.525 ms	1411			/classes/Hook.php:1568 /classes/Hook.php:251 (getAllHookIds) /classes/Hook.php:961 (getIdByName) /classes/Dispatcher.php:595 (exec) /classes/Dispatcher.php:253 (loadRoutes) /classes/Dispatcher.php:215 (__construct) /index.php:86 (getInstance)
137	SELECT SQL_NO_CACHE 1 FROM `ps_specific_price` WHERE id_product = 90 LIMIT 1	0.515 ms	1			/classes/SpecificPrice.php:442 /classes/SpecificPrice.php:530 (couldHaveSpecificPrice) /classes/Product.php:3595 (getSpecificPrice) /classes/Product.php:3485 (priceCalculation) /classes/Product.php:5479 (getPriceStatic) /classes/ProductAssembler.php:214 (getProductProperties) /controllers/front/ProductController.php:381 (assembleProducts) /override/controllers/front/ProductController.php:68 (initContent) /tools/profiling/Controller.php:65 (initContent) /classes/Dispatcher.php:488 (run) /index.php:86 (dispatch)
76	SELECT SQL_NO_CACHE `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = 2954 AND `id_group` = 1 LIMIT 1	0.508 ms	0			/classes/GroupReduction.php:146 /classes/Product.php:3759 (getValueForProduct) /classes/Product.php:3485 (priceCalculation) /classes/Product.php:730 (getPriceStatic) /controllers/front/ProductController.php:149 (__construct) /tools/profiling/Controller.php:46 (init) /classes/Dispatcher.php:488 (run) /index.php:86 (dispatch)
190	SELECT SQL_NO_CACHE p., ps., pl.*, sa.out_of_stock, IFNULL(sa.quantity, 0) as quantity, (DATEDIFF( p.`date_add`, DATE_SUB( '2026-05-12 00:00:00', INTERVAL 120 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 (2954)	0.508 ms	1			/classes/ProductAssembler.php:70 /classes/ProductAssembler.php:189 (addMissingProductFields) /modules/stripe_official/classes/factories/StripeProductLazyArrayFactory.php:69 (assembleProduct) /modules/stripe_official/classes/services/StripeDisplayHeaderService.php:60 (createProductLazyArrayFromProductId) /modules/stripe_official/stripe_official.php:1247 (setHeaders) /classes/Hook.php:1237 (hookDisplayHeader) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:454 (coreCallHook) /classes/Hook.php:1128 (callHookOn) /classes/controller/FrontController.php:621 (exec) /controllers/front/ProductController.php:416 (initContent) /override/controllers/front/ProductController.php:68 (initContent) /tools/profiling/Controller.php:65 (initContent) /classes/Dispatcher.php:488 (run) /index.php:86 (dispatch)
96	SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) + IF (`id_country` = 21, 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, 21) AND `id_group` IN (0, 1) AND `id_product` = 2954 AND `id_customer` = 0 AND `id_cart` = 0 AND (`from` = '0000-00-00 00:00:00' OR '2026-05-12 17:35:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2026-05-12 17:35:00' <= `to`) ORDER BY `from_quantity` ASC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC	0.485 ms	1	Yes		/classes/SpecificPrice.php:622 /controllers/front/ProductController.php:568 (getQuantityDiscounts) /controllers/front/ProductController.php:326 (assignPriceAndTax) /override/controllers/front/ProductController.php:68 (initContent) /tools/profiling/Controller.php:65 (initContent) /classes/Dispatcher.php:488 (run) /index.php:86 (dispatch)
139	SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) + IF (`id_country` = 21, 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, 21) AND `id_group` IN (0, 1) AND `id_product` = 90 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0 AND (`from` = '0000-00-00 00:00:00' OR '2026-05-12 17:35:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2026-05-12 17:35: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.480 ms	1	Yes		/classes/SpecificPrice.php:583 /classes/Product.php:3595 (getSpecificPrice) /classes/Product.php:3485 (priceCalculation) /classes/Product.php:5479 (getPriceStatic) /classes/ProductAssembler.php:214 (getProductProperties) /controllers/front/ProductController.php:381 (assembleProducts) /override/controllers/front/ProductController.php:68 (initContent) /tools/profiling/Controller.php:65 (initContent) /classes/Dispatcher.php:488 (run) /index.php:86 (dispatch)
99	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` = 2954 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` = 2954 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1	0.467 ms	0			/classes/Cart.php:1450 /controllers/front/ProductController.php:1194 (getProductQuantity) /controllers/front/ProductController.php:336 (getTemplateVarProduct) /override/controllers/front/ProductController.php:68 (initContent) /tools/profiling/Controller.php:65 (initContent) /classes/Dispatcher.php:488 (run) /index.php:86 (dispatch)
132	SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) + IF (`id_country` = 21, 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, 21) AND `id_group` IN (0, 1) AND `id_product` = 3838 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0 AND (`from` = '0000-00-00 00:00:00' OR '2026-05-12 17:35:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2026-05-12 17:35: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.464 ms	1	Yes		/classes/SpecificPrice.php:583 /classes/Product.php:3595 (getSpecificPrice) /classes/Product.php:3485 (priceCalculation) /classes/Product.php:5479 (getPriceStatic) /classes/ProductAssembler.php:214 (getProductProperties) /controllers/front/ProductController.php:381 (assembleProducts) /override/controllers/front/ProductController.php:68 (initContent) /tools/profiling/Controller.php:65 (initContent) /classes/Dispatcher.php:488 (run) /index.php:86 (dispatch)
273	SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, SUM(IF(stock.`quantity` > 0, 1, 0)) qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by FROM `ps_product_attribute` pa INNER JOIN ps_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) LEFT JOIN ps_stock_available stock ON (stock.id_product = `pa`.id_product AND stock.id_product_attribute = 0 AND stock.id_shop = 1 AND stock.id_shop_group = 0 ) JOIN `ps_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`) JOIN `ps_attribute` a ON (a.`id_attribute` = pac.`id_attribute`) JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1) JOIN `ps_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`) WHERE pa.`id_product` IN (4622) AND ag.`is_color_group` = 1 GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` HAVING qty > 0 ORDER BY a.`position` ASC;	0.458 ms	1	Yes		/classes/Product.php:4304 /src/Adapter/Product/ProductColorsRetriever.php:43 (getAttributesColorList) /src/Adapter/Presenter/Product/ProductLazyArray.php:787 (getColoredVariants) /src/Adapter/Presenter/AbstractLazyArray.php:264 (getMainVariants) /src/Adapter/Presenter/AbstractLazyArray.php:124 (offsetGet) /modules/rcpgtagmanager/src/PSModule/Adapter/Product/AbstractProductAdapter.php:61 (jsonSerialize) /modules/rcpgtagmanager/src/PSModule/Adapter/Product/AbstractProductAdapter.php:47 (normalizeObject) /modules/rcpgtagmanager/src/PSModule/DataModelHandler/DataModelHandler.php:100 (normalizeProduct) /modules/rcpgtagmanager/src/PSModule/Hook/DisplayBeforeBodyClosingTag/AbstractDisplayBeforeBodyClosingTag.php:226 (buildDetailProductModelList) /modules/rcpgtagmanager/src/PSModule/Hook/DisplayBeforeBodyClosingTag/AbstractDisplayBeforeBodyClosingTag.php:72 (processPage) /modules/rcpgtagmanager/rcpgtagmanager.php:229 (exec) /classes/Hook.php:1237 (hookDisplayBeforeBodyClosingTag) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:454 (coreCallHook) /classes/Hook.php:1128 (callHookOn) /config/smarty.config.inc.php:213 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/prod/smarty/compile/ZOneThemelayouts_layout_full_width_tpl/41/22/27/412227c1898d7fcb8f95dc7cb092ba8dee323539_2.file.layout-both-columns.tpl.php:534 (__call) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/ZOneThemelayouts_layout_full_width_tpl/41/22/27/412227c1898d7fcb8f95dc7cb092ba8dee323539_2.file.layout-both-columns.tpl.php:155 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69fa46dee18ed2_91847339) /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:115 (_subTemplateRender) /var/cache/prod/smarty/compile/ZOneThemelayouts_layout_full_width_tpl/5d/78/7c/5d787caf864fa82876e67ad2e9724f8b2bd753d4_2.file.layout-full-width.tpl.php:42 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69fa46dee06285_92334566) /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:115 (_subTemplateRender) /var/cache/prod/smarty/compile/ZOneThemelayouts_layout_full_width_tpl/f9/22/72/f92272f0fabd5468e790fb9ffe893dff8edf07e0_2.file.product.tpl.php:53 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69fa46dedffd94_55239211) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/controller/FrontController.php:757 (fetch) /classes/controller/FrontController.php:741 (smartyOutputContent) /tools/profiling/Controller.php:111 (display) /tools/profiling/Controller.php:88 (displayProfiling) /classes/Dispatcher.php:488 (run) /index.php:86 (dispatch)
97	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` = 2954	0.456 ms	1			/classes/Product.php:7250 /controllers/front/ProductController.php:827 (getAttributesInformationsByProduct) /controllers/front/ProductController.php:329 (assignAttributesCombinations) /override/controllers/front/ProductController.php:68 (initContent) /tools/profiling/Controller.php:65 (initContent) /classes/Dispatcher.php:488 (run) /index.php:86 (dispatch)
157	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` = 4243 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` = 4243 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1	0.435 ms	0			/classes/Cart.php:1450 /classes/Product.php:4152 (getProductQuantity) /classes/Product.php:5585 (getQuantity) /classes/ProductAssembler.php:214 (getProductProperties) /controllers/front/ProductController.php:381 (assembleProducts) /override/controllers/front/ProductController.php:68 (initContent) /tools/profiling/Controller.php:65 (initContent) /classes/Dispatcher.php:488 (run) /index.php:86 (dispatch)
122	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` = 4622 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` = 4622 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1	0.430 ms	0			/classes/Cart.php:1450 /classes/Product.php:4152 (getProductQuantity) /classes/Product.php:5585 (getQuantity) /classes/ProductAssembler.php:214 (getProductProperties) /controllers/front/ProductController.php:381 (assembleProducts) /override/controllers/front/ProductController.php:68 (initContent) /tools/profiling/Controller.php:65 (initContent) /classes/Dispatcher.php:488 (run) /index.php:86 (dispatch)
158	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` = 4622) AND (b.`id_shop` = 1) LIMIT 1	0.406 ms	1			/src/Adapter/EntityMapper.php:74 /classes/ObjectModel.php:217 (load) /tools/profiling/ObjectModel.php:32 (__construct) /classes/Product.php:708 (__construct) /src/Adapter/Image/ImageRetriever.php:68 (__construct) /src/Adapter/Presenter/Product/ProductLazyArray.php:941 (getAllProductImages) /src/Adapter/Presenter/Product/ProductLazyArray.php:137 (fillImages) /src/Adapter/Presenter/Product/ProductListingPresenter.php:50 (__construct) /controllers/front/ProductController.php:383 (present) /override/controllers/front/ProductController.php:68 (initContent) /tools/profiling/Controller.php:65 (initContent) /classes/Dispatcher.php:488 (run) /index.php:86 (dispatch)
198	SELECT SQL_NO_CACHE ac.id_ets_abancart_campaign FROM `ps_ets_abancart_campaign` ac LEFT JOIN `ps_ets_abancart_campaign_country` `cc` ON cc.id_ets_abancart_campaign = ac.id_ets_abancart_campaign LEFT JOIN `ps_ets_abancart_campaign_with_lang` `cl` ON cl.id_ets_abancart_campaign = ac.id_ets_abancart_campaign AND cl.id_lang=1 LEFT JOIN `ps_ets_abancart_campaign_group` `acg` ON ac.id_ets_abancart_campaign = acg.id_ets_abancart_campaign LEFT JOIN `ps_group_shop` `gs` ON gs.id_group = acg.id_group AND gs.id_shop = 1 WHERE (ac.id_shop = 1) AND (ac.enabled = 1 AND ac.deleted = 0) AND (IF(ac.is_all_lang != 1, cl.id_ets_abancart_campaign is NOT NULL AND cl.id_lang=1, 1)) AND (ac.campaign_type != 'email') AND (ac.campaign_type != 'customer') AND (IF(ac.min_total_cart is NOT NULL AND ac.has_product_in_cart = 1, ac.min_total_cart <= 0, 1) AND IF(ac.max_total_cart is NOT NULL AND ac.has_product_in_cart = 1, ac.max_total_cart >= 0, 1)) AND (IF(ac.available_from is NOT NULL, ac.available_from <= '2026-05-12', 1) AND IF(ac.available_to is NOT NULL, ac.available_to >= '2026-05-12', 1)) AND (IF(ac.has_applied_voucher = 'both' OR (ac.has_applied_voucher = 'yes' AND 0 > 0) OR (ac.has_applied_voucher = 'no' AND 0 = 0), 1, 0)) AND (IF(ac.has_product_in_cart = 1, 0, 1)) AND (acg.id_group = 1) AND (ac.is_all_country = 1 OR cc.id_country = -1 OR cc.id_country=21) GROUP BY ac.id_ets_abancart_campaign	0.394 ms	1		Yes	/modules/ets_abandonedcart/classes/EtsAbancartCampaign.php:464 /modules/ets_abandonedcart/ets_abandonedcart.php:964 (getCampaignsFrontEnd) /classes/Hook.php:1237 (hookDisplayHeader) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:454 (coreCallHook) /classes/Hook.php:1128 (callHookOn) /classes/controller/FrontController.php:621 (exec) /controllers/front/ProductController.php:416 (initContent) /override/controllers/front/ProductController.php:68 (initContent) /tools/profiling/Controller.php:65 (initContent) /classes/Dispatcher.php:488 (run) /index.php:86 (dispatch)
125	SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) + IF (`id_country` = 21, 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, 21) AND `id_group` IN (0, 1) AND `id_product` = 4473 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0 AND (`from` = '0000-00-00 00:00:00' OR '2026-05-12 17:35:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2026-05-12 17:35: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.390 ms	1	Yes		/classes/SpecificPrice.php:583 /classes/Product.php:3595 (getSpecificPrice) /classes/Product.php:3485 (priceCalculation) /classes/Product.php:5479 (getPriceStatic) /classes/ProductAssembler.php:214 (getProductProperties) /controllers/front/ProductController.php:381 (assembleProducts) /override/controllers/front/ProductController.php:68 (initContent) /tools/profiling/Controller.php:65 (initContent) /classes/Dispatcher.php:488 (run) /index.php:86 (dispatch)
153	SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) + IF (`id_country` = 21, 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, 21) AND `id_group` IN (0, 1) AND `id_product` = 4243 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0 AND (`from` = '0000-00-00 00:00:00' OR '2026-05-12 17:35:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2026-05-12 17:35: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.388 ms	1	Yes		/classes/SpecificPrice.php:583 /classes/Product.php:3595 (getSpecificPrice) /classes/Product.php:3485 (priceCalculation) /classes/Product.php:5479 (getPriceStatic) /classes/ProductAssembler.php:214 (getProductProperties) /controllers/front/ProductController.php:381 (assembleProducts) /override/controllers/front/ProductController.php:68 (initContent) /tools/profiling/Controller.php:65 (initContent) /classes/Dispatcher.php:488 (run) /index.php:86 (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 = 'www.sewsweetly.com' OR su.domain_ssl = 'www.sewsweetly.com') AND s.active = 1 AND s.deleted = 0 ORDER BY LENGTH(CONCAT(su.physical_uri, su.virtual_uri)) DESC	0.387 ms	1	Yes		/classes/shop/Shop.php:1392 /classes/shop/Shop.php:356 (findShopByHost) /config/config.inc.php:122 (initialize) /index.php:40 (require_once)
275	SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, SUM(IF(stock.`quantity` > 0, 1, 0)) qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by FROM `ps_product_attribute` pa INNER JOIN ps_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) LEFT JOIN ps_stock_available stock ON (stock.id_product = `pa`.id_product AND stock.id_product_attribute = 0 AND stock.id_shop = 1 AND stock.id_shop_group = 0 ) JOIN `ps_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`) JOIN `ps_attribute` a ON (a.`id_attribute` = pac.`id_attribute`) JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1) JOIN `ps_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`) WHERE pa.`id_product` IN (4473) AND ag.`is_color_group` = 1 GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` HAVING qty > 0 ORDER BY a.`position` ASC;	0.380 ms	1	Yes		/classes/Product.php:4304 /src/Adapter/Product/ProductColorsRetriever.php:43 (getAttributesColorList) /src/Adapter/Presenter/Product/ProductLazyArray.php:787 (getColoredVariants) /src/Adapter/Presenter/AbstractLazyArray.php:264 (getMainVariants) /src/Adapter/Presenter/AbstractLazyArray.php:124 (offsetGet) /modules/rcpgtagmanager/src/PSModule/Adapter/Product/AbstractProductAdapter.php:61 (jsonSerialize) /modules/rcpgtagmanager/src/PSModule/Adapter/Product/AbstractProductAdapter.php:47 (normalizeObject) /modules/rcpgtagmanager/src/PSModule/DataModelHandler/DataModelHandler.php:100 (normalizeProduct) /modules/rcpgtagmanager/src/PSModule/Hook/DisplayBeforeBodyClosingTag/AbstractDisplayBeforeBodyClosingTag.php:226 (buildDetailProductModelList) /modules/rcpgtagmanager/src/PSModule/Hook/DisplayBeforeBodyClosingTag/AbstractDisplayBeforeBodyClosingTag.php:72 (processPage) /modules/rcpgtagmanager/rcpgtagmanager.php:229 (exec) /classes/Hook.php:1237 (hookDisplayBeforeBodyClosingTag) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:454 (coreCallHook) /classes/Hook.php:1128 (callHookOn) /config/smarty.config.inc.php:213 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/prod/smarty/compile/ZOneThemelayouts_layout_full_width_tpl/41/22/27/412227c1898d7fcb8f95dc7cb092ba8dee323539_2.file.layout-both-columns.tpl.php:534 (__call) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/ZOneThemelayouts_layout_full_width_tpl/41/22/27/412227c1898d7fcb8f95dc7cb092ba8dee323539_2.file.layout-both-columns.tpl.php:155 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69fa46dee18ed2_91847339) /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:115 (_subTemplateRender) /var/cache/prod/smarty/compile/ZOneThemelayouts_layout_full_width_tpl/5d/78/7c/5d787caf864fa82876e67ad2e9724f8b2bd753d4_2.file.layout-full-width.tpl.php:42 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69fa46dee06285_92334566) /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:115 (_subTemplateRender) /var/cache/prod/smarty/compile/ZOneThemelayouts_layout_full_width_tpl/f9/22/72/f92272f0fabd5468e790fb9ffe893dff8edf07e0_2.file.product.tpl.php:53 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69fa46dedffd94_55239211) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/controller/FrontController.php:757 (fetch) /classes/controller/FrontController.php:741 (smartyOutputContent) /tools/profiling/Controller.php:111 (display) /tools/profiling/Controller.php:88 (displayProfiling) /classes/Dispatcher.php:488 (run) /index.php:86 (dispatch)
164	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` = 90) AND (b.`id_shop` = 1) LIMIT 1	0.376 ms	1			/src/Adapter/EntityMapper.php:74 /classes/ObjectModel.php:217 (load) /tools/profiling/ObjectModel.php:32 (__construct) /classes/Product.php:708 (__construct) /src/Adapter/Image/ImageRetriever.php:68 (__construct) /src/Adapter/Presenter/Product/ProductLazyArray.php:941 (getAllProductImages) /src/Adapter/Presenter/Product/ProductLazyArray.php:137 (fillImages) /src/Adapter/Presenter/Product/ProductListingPresenter.php:50 (__construct) /controllers/front/ProductController.php:383 (present) /override/controllers/front/ProductController.php:68 (initContent) /tools/profiling/Controller.php:65 (initContent) /classes/Dispatcher.php:488 (run) /index.php:86 (dispatch)
281	SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, SUM(IF(stock.`quantity` > 0, 1, 0)) qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by FROM `ps_product_attribute` pa INNER JOIN ps_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) LEFT JOIN ps_stock_available stock ON (stock.id_product = `pa`.id_product AND stock.id_product_attribute = 0 AND stock.id_shop = 1 AND stock.id_shop_group = 0 ) JOIN `ps_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`) JOIN `ps_attribute` a ON (a.`id_attribute` = pac.`id_attribute`) JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1) JOIN `ps_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`) WHERE pa.`id_product` IN (1523) AND ag.`is_color_group` = 1 GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` HAVING qty > 0 ORDER BY a.`position` ASC;	0.368 ms	1	Yes		/classes/Product.php:4304 /src/Adapter/Product/ProductColorsRetriever.php:43 (getAttributesColorList) /src/Adapter/Presenter/Product/ProductLazyArray.php:787 (getColoredVariants) /src/Adapter/Presenter/AbstractLazyArray.php:264 (getMainVariants) /src/Adapter/Presenter/AbstractLazyArray.php:124 (offsetGet) /modules/rcpgtagmanager/src/PSModule/Adapter/Product/AbstractProductAdapter.php:61 (jsonSerialize) /modules/rcpgtagmanager/src/PSModule/Adapter/Product/AbstractProductAdapter.php:47 (normalizeObject) /modules/rcpgtagmanager/src/PSModule/DataModelHandler/DataModelHandler.php:100 (normalizeProduct) /modules/rcpgtagmanager/src/PSModule/Hook/DisplayBeforeBodyClosingTag/AbstractDisplayBeforeBodyClosingTag.php:226 (buildDetailProductModelList) /modules/rcpgtagmanager/src/PSModule/Hook/DisplayBeforeBodyClosingTag/AbstractDisplayBeforeBodyClosingTag.php:72 (processPage) /modules/rcpgtagmanager/rcpgtagmanager.php:229 (exec) /classes/Hook.php:1237 (hookDisplayBeforeBodyClosingTag) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:454 (coreCallHook) /classes/Hook.php:1128 (callHookOn) /config/smarty.config.inc.php:213 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/prod/smarty/compile/ZOneThemelayouts_layout_full_width_tpl/41/22/27/412227c1898d7fcb8f95dc7cb092ba8dee323539_2.file.layout-both-columns.tpl.php:534 (__call) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/ZOneThemelayouts_layout_full_width_tpl/41/22/27/412227c1898d7fcb8f95dc7cb092ba8dee323539_2.file.layout-both-columns.tpl.php:155 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69fa46dee18ed2_91847339) /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:115 (_subTemplateRender) /var/cache/prod/smarty/compile/ZOneThemelayouts_layout_full_width_tpl/5d/78/7c/5d787caf864fa82876e67ad2e9724f8b2bd753d4_2.file.layout-full-width.tpl.php:42 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69fa46dee06285_92334566) /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:115 (_subTemplateRender) /var/cache/prod/smarty/compile/ZOneThemelayouts_layout_full_width_tpl/f9/22/72/f92272f0fabd5468e790fb9ffe893dff8edf07e0_2.file.product.tpl.php:53 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69fa46dedffd94_55239211) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/controller/FrontController.php:757 (fetch) /classes/controller/FrontController.php:741 (smartyOutputContent) /tools/profiling/Controller.php:111 (display) /tools/profiling/Controller.php:88 (displayProfiling) /classes/Dispatcher.php:488 (run) /index.php:86 (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/autoload_static.php
9	/vendor/symfony/deprecation-contracts/function.php
10	/vendor/symfony/polyfill-mbstring/bootstrap.php
11	/vendor/symfony/polyfill-mbstring/bootstrap80.php
12	/vendor/symfony/polyfill-ctype/bootstrap.php
13	/vendor/symfony/polyfill-ctype/bootstrap80.php
14	/vendor/symfony/polyfill-php83/bootstrap.php
15	/vendor/symfony/var-dumper/Resources/functions/dump.php
16	/vendor/symfony/polyfill-intl-normalizer/bootstrap.php
17	/vendor/symfony/polyfill-intl-normalizer/bootstrap80.php
18	/vendor/twig/twig/src/Resources/core.php
19	/vendor/twig/twig/src/Resources/debug.php
20	/vendor/twig/twig/src/Resources/escaper.php
21	/vendor/twig/twig/src/Resources/string_loader.php
22	/vendor/symfony/polyfill-intl-grapheme/bootstrap.php
23	/vendor/symfony/polyfill-intl-grapheme/bootstrap80.php
24	/vendor/symfony/string/Resources/functions.php
25	/vendor/symfony/polyfill-intl-idn/bootstrap.php
26	/vendor/symfony/clock/Resources/now.php
27	/vendor/symfony/polyfill-php80/bootstrap.php
28	/vendor/ezyang/htmlpurifier/library/HTMLPurifier.composer.php
29	/vendor/jakeasmith/http_build_url/src/http_build_url.php
30	/vendor/symfony/polyfill-intl-icu/bootstrap.php
31	/vendor/ircmaxell/password-compat/lib/password.php
32	/vendor/martinlindhe/php-mb-helpers/src/mb_helpers.php
33	/vendor/symfony/polyfill-php73/bootstrap.php
34	/vendor/symfony/translation/Resources/functions.php
35	/src/Core/Version.php
36	/config/alias.php
37	/vendor/prestashop/autoload/src/PrestashopAutoload.php
38	/vendor/prestashop/autoload/src/LegacyClassLoader.php
39	/vendor/symfony/filesystem/Filesystem.php