Name: Popruh na matraci pro Obojek - 4abies
Brand: 4Abies
SKU: mattstrap/4ab/main/classic/collar
Price: 419 CZK
Availability: InStock

Pro dospělé hrátky nesmí chybět základní prvek soft BDSM — popruh na matraci. Perfektní doplněk ke všem našim produktům, ať už jde o pouta, opasky, obojky nebo postroje. Popruhy jsou dostupné v různých šířkách, vhodné pro matrace od 80 do 180 cm šířky a výšky až 20 cm (na zakázku možné i vyšší). Jsou navrženy tak, aby zajistily pohodlné upoutání, díky kterému se můžete naplno ponořit do vašich hravých zážitků.

Užijte si zábavu s naší soupravou zádržného systému, ať už jste doma, nebo venku.

Tato produktová řada obsahuje vše, co potřebujete pro nezapomenutelné zážitky: pouta na ruce, obojky, popruhy na postel i postroje na celé tělo. Otevřete dveře své fantazii a objevte nové možnosti, jak si hrát a mít vše pod kontrolou, kdykoli a kdekoli.

Nezapomeňte: Propojte vše dohromady

Většina našich produktů je navržena tak, aby se daly jednoduše propojit díky rezervním sponám na stranách (v závislosti na zvolené edici, Locking nebo non-locking). Můžete tak snadno připoutat člověka k posteli, vodítku nebo jinému vybavení. Pokud si zakoupíte diskrétní produkty, tyto spony nebudou součástí. Důležité je vybírat buď z uzamykatelné, nebo neuzamykatelné řady, protože tyto varianty nejsou navzájem kompatibilní.

cm	70	80	90	100	120	140-160	160-180
in	27.6	31.5	35.4	39.4	47.2	55.1-63.0	63.0-70.9

Vítejte ve světě 4abies, kde může vaše vnitřní mini já konečně být samo sebou.

Ve světě plném hraček pro velké děti, ať už ty hodné, které rády navštěvují paní doktorku, nebo ty zlobivé, které si zaslouží pořádnou lekci. Naše celé portfolio je zaměřeno na pohodlí, hravé barvy a nezapomenutelné zážitky. Kdo by odolal být připoután při důkladném vyšetření paní doktorky? Nebo spinkat v bezpečí před pádem z postýlky, aniž by se musel obávat mokrých nehod?

4abies: AB/DL a další sortiment

Pro dospělé mimina, milovníky plen, BDSM mistry a subíky a všechny další, jste u nás vítáni a máme produkty, které bez ostychu oslavují vaše hluboce zakořeněné potřeby. Naše produkty jsou navrženy tak, aby byly téměř na úrovni lékařské kvality, s prémiovým zpracováním, které zajišťuje efektivní a humánní znehybnění. Uzamkněte svého vnitřního regresora.

Bezpečné, ale nezamykatelné: Klasické produkty.

Pro ty, kteří hledají snadné uvolnění a jednoduché upevnění bez nutnosti zamykání, nabízíme naše produkty i v klasických (nezamykatelných) variantách. Ideální pro chvíle, kdy chcete zažít jemnější hru bez zbytečných komplikací. Naše klasické spony poskytují maximální bezpečnost, snadnou manipulaci a flexibilitu, aniž byste museli slevit ze stylu nebo funkčnosti. Perfektní volba pro ty, kteří chtějí mít vše pod kontrolou, ale s možností rychlého úniku.
Varování: Classic a Locking varianty nejsou vzájemně kompatibilní, proto je důležité mít výrobky, které chcete spojit, vždy ve stejné edici.

Značka
Kód

mattstrap/4ab/main/collar/classic/lightgray/custom
MPN

4ab20169909

výrobce

4abies
Spony

základní
Typ

Příslušenství
Typ popruhu

na obojek
Edice

standardní
Použití na

Krk

Mohlo by vás také zajímat

Adaptér na D-kroužek - 4abies

149 Kč

Load Time	955 ms
Querying Time	725 ms
Queries	818
Memory Peak Usage	24.8 Mb
Included Files	1090 files - 11.42 Mb
PrestaShop Cache	- Mb
Global vars	0.03 Mb
- global $_SERVER	7k
- global $smarty	6k
- global $config	5k
- global $context	3k
- global $__composer_autoload_files	3k
- global $exportPhpConfigFile	3k
- global $_COOKIE	2k

PrestaShop Version	9.0.2
PHP Version	8.1.33
MySQL Version	8.0.44-0ubuntu0.24.04.1
Memory Limit	512M
Max Execution Time	300s
Smarty Cache	enabled
Smarty Compilation	never recompile

	Time	Cumulated Time	Memory Usage	Memory Peak Usage
config	24.908 ms	24.908 ms	2.71 Mb	3.0 Mb
__construct	0.017 ms	24.925 ms	- Mb	3.0 Mb
init	28.677 ms	53.602 ms	1.92 Mb	4.6 Mb
checkAccess	0.002 ms	53.604 ms	- Mb	4.6 Mb
setMedia	2.905 ms	56.509 ms	0.14 Mb	4.8 Mb
postProcess	0.006 ms	56.515 ms	0.06 Mb	4.8 Mb
initHeader	0.002 ms	56.517 ms	- Mb	4.8 Mb
initContent	259.407 ms	315.924 ms	9.34 Mb	14.8 Mb
initFooter	0.003 ms	315.927 ms	- Mb	14.8 Mb
display	639.208 ms	955 ms	9.90 Mb	24.8 Mb

Hook	Time	Memory Usage
DisplayBeforeBodyClosingTag	496.106 ms	0.20 Mb
=> statsdata	495.705 ms	0.15 Mb
=> ps_googleanalytics	0.401 ms	0.05 Mb
FilterProductContent	6.104 ms	0.26 Mb
=> productcomments	6.104 ms	0.26 Mb
DisplayFooterProduct	4.834 ms	0.35 Mb
=> productcomments	4.834 ms	0.35 Mb
displayNav2	4.399 ms	0.38 Mb
=> ps_languageselector (widget)	0.608 ms	0.04 Mb
=> ps_currencyselector (widget)	2.612 ms	0.24 Mb
=> ps_customersignin (widget)	0.493 ms	0.04 Mb
=> ps_shoppingcart (widget)	0.686 ms	0.06 Mb
displayProductAdditionalInfo	1.971 ms	0.16 Mb
=> ps_sharebuttons (widget)	0.918 ms	0.09 Mb
=> productcomments (widget)	1.053 ms	0.06 Mb
ActionFrontControllerSetMedia	1.630 ms	0.04 Mb
=> blockreassurance	0.090 ms	- Mb
=> blockwishlist	0.133 ms	- Mb
=> ps_emailsubscription	0.035 ms	- Mb
=> ps_socialfollow	0.030 ms	- Mb
=> ps_emailalerts	0.022 ms	- Mb
=> ps_checkout	1.320 ms	0.03 Mb
displayFooter	1.464 ms	0.14 Mb
=> ps_linklist (widget)	0.542 ms	0.06 Mb
=> ps_customeraccountlinks (widget)	0.532 ms	0.06 Mb
=> ps_contactinfo (widget)	0.390 ms	0.02 Mb
displayFooterBefore	1.265 ms	0.11 Mb
=> ps_emailsubscription (widget)	0.631 ms	0.04 Mb
=> ps_socialfollow (widget)	0.634 ms	0.06 Mb
displayTop	1.210 ms	0.12 Mb
=> ps_mainmenu (widget)	0.757 ms	0.08 Mb
=> ps_searchbar (widget)	0.453 ms	0.04 Mb
DisplayHeader	0.814 ms	0.09 Mb
=> ps_shoppingcart	0.047 ms	- Mb
=> ps_searchbar	0.316 ms	0.01 Mb
=> productcomments	0.085 ms	- Mb
=> ps_googleanalytics	0.306 ms	0.08 Mb
=> ps_imageslider	0.054 ms	- Mb
=> dm_label	0.006 ms	- Mb
displayNav1	0.789 ms	0.06 Mb
=> ps_contactinfo (widget)	0.789 ms	0.06 Mb
DisplayFooter	0.408 ms	0.06 Mb
=> blockwishlist	0.408 ms	0.06 Mb
DisplayProductActions	0.140 ms	0.01 Mb
=> blockwishlist	0.140 ms	0.01 Mb
ActionProductFlagsModifier	0.138 ms	0.01 Mb
=> dm_label	0.006 ms	- Mb
=> dm_label	0.006 ms	- Mb
=> dm_label	0.005 ms	- Mb
=> dm_label	0.006 ms	- Mb
=> dm_label	0.006 ms	- Mb
=> dm_label	0.006 ms	- Mb
=> dm_label	0.005 ms	- Mb
=> dm_label	0.005 ms	- Mb
=> dm_label	0.006 ms	- Mb
=> dm_label	0.006 ms	- Mb
=> dm_label	0.005 ms	- Mb
=> dm_label	0.006 ms	- Mb
=> dm_label	0.006 ms	- Mb
=> dm_label	0.005 ms	- Mb
=> dm_label	0.005 ms	- Mb
=> dm_label	0.006 ms	- Mb
=> dm_label	0.006 ms	- Mb
=> dm_label	0.005 ms	- Mb
=> dm_label	0.006 ms	- Mb
=> dm_label	0.006 ms	- Mb
=> dm_label	0.006 ms	- Mb
=> dm_label	0.006 ms	- Mb
=> dm_label	0.006 ms	- Mb
=> dm_label	0.007 ms	- Mb
DisplayReassurance	0.009 ms	- Mb
=> blockreassurance	0.009 ms	- Mb
ModuleRoutes	0.006 ms	- Mb
=> ps_checkout	0.006 ms	- Mb
DisplayAfterBodyOpeningTag	0.006 ms	- Mb
=> blockreassurance	0.006 ms	- Mb
DisplayFooterAfter	0.006 ms	- Mb
=> blockreassurance	0.006 ms	- Mb
DisplayDmLabel	0.005 ms	- Mb
=> dm_label	0.005 ms	- Mb
DisplayNavFullWidth	0.004 ms	- Mb
=> blockreassurance	0.004 ms	- Mb
20 hook(s)	521.308 ms	1.99 Mb

Module	Time	Memory Usage
ps_checkout	2.611 ms	0.04 Mb
__construct	1.278 ms	- Mb
hookModuleRoutes	0.010 ms	- Mb
hookActionFrontControllerSetMedia	1.323 ms	0.03 Mb
blockreassurance	0.604 ms	0.07 Mb
__construct	0.475 ms	0.06 Mb
hookActionFrontControllerSetMedia	0.094 ms	- Mb
hookDisplayAfterBodyOpeningTag	0.009 ms	- Mb
hookDisplayNavFullWidth	0.007 ms	- Mb
hookDisplayReassurance	0.011 ms	- Mb
hookDisplayFooterAfter	0.008 ms	- Mb
blockwishlist	0.759 ms	0.08 Mb
__construct	0.070 ms	0.01 Mb
hookActionFrontControllerSetMedia	0.136 ms	- Mb
hookDisplayProductActions	0.142 ms	0.01 Mb
hookDisplayFooter	0.411 ms	0.06 Mb
ps_emailsubscription	0.735 ms	0.05 Mb
__construct	0.062 ms	0.01 Mb
hookActionFrontControllerSetMedia	0.038 ms	- Mb
displayFooterBefore	0.635 ms	0.04 Mb
ps_socialfollow	0.721 ms	0.07 Mb
__construct	0.052 ms	0.01 Mb
hookActionFrontControllerSetMedia	0.032 ms	- Mb
displayFooterBefore	0.637 ms	0.07 Mb
ps_emailalerts	0.102 ms	0.01 Mb
__construct	0.078 ms	0.01 Mb
hookActionFrontControllerSetMedia	0.024 ms	- Mb
productcomments	12.151 ms	0.69 Mb
__construct	0.063 ms	0.01 Mb
hookFilterProductContent	6.108 ms	0.26 Mb
hookDisplayHeader	0.087 ms	- Mb
displayProductAdditionalInfo	1.055 ms	0.06 Mb
hookDisplayFooterProduct	4.838 ms	0.35 Mb
ps_shoppingcart	0.821 ms	0.07 Mb
__construct	0.083 ms	0.01 Mb
hookDisplayHeader	0.050 ms	- Mb
displayNav2	0.688 ms	0.06 Mb
ps_searchbar	0.840 ms	0.05 Mb
__construct	0.066 ms	0.01 Mb
hookDisplayHeader	0.319 ms	0.01 Mb
displayTop	0.455 ms	0.04 Mb
ps_googleanalytics	0.794 ms	0.13 Mb
__construct	0.081 ms	0.01 Mb
hookDisplayHeader	0.310 ms	0.08 Mb
hookDisplayBeforeBodyClosingTag	0.403 ms	0.05 Mb
ps_imageslider	0.133 ms	0.01 Mb
__construct	0.077 ms	0.01 Mb
hookDisplayHeader	0.056 ms	- Mb
dm_label	0.379 ms	0.03 Mb
__construct	0.152 ms	0.01 Mb
hookDisplayHeader	0.008 ms	- Mb
hookActionProductFlagsModifier	0.008 ms	- Mb
hookDisplayDmLabel	0.007 ms	- Mb
hookActionProductFlagsModifier	0.009 ms	- Mb
hookActionProductFlagsModifier	0.008 ms	- Mb
hookActionProductFlagsModifier	0.009 ms	- Mb
hookActionProductFlagsModifier	0.009 ms	- Mb
hookActionProductFlagsModifier	0.009 ms	- Mb
hookActionProductFlagsModifier	0.009 ms	- Mb
hookActionProductFlagsModifier	0.009 ms	- Mb
hookActionProductFlagsModifier	0.009 ms	- Mb
hookActionProductFlagsModifier	0.009 ms	- Mb
hookActionProductFlagsModifier	0.008 ms	- Mb
hookActionProductFlagsModifier	0.009 ms	- Mb
hookActionProductFlagsModifier	0.009 ms	- Mb
hookActionProductFlagsModifier	0.008 ms	- Mb
hookActionProductFlagsModifier	0.008 ms	- Mb
hookActionProductFlagsModifier	0.009 ms	- Mb
hookActionProductFlagsModifier	0.010 ms	- Mb
hookActionProductFlagsModifier	0.008 ms	- Mb
hookActionProductFlagsModifier	0.009 ms	- Mb
hookActionProductFlagsModifier	0.009 ms	- Mb
hookActionProductFlagsModifier	0.009 ms	- Mb
hookActionProductFlagsModifier	0.009 ms	- Mb
hookActionProductFlagsModifier	0.009 ms	- Mb
hookActionProductFlagsModifier	0.011 ms	- Mb
ps_contactinfo	1.237 ms	0.09 Mb
__construct	0.053 ms	0.01 Mb
displayNav1	0.792 ms	0.06 Mb
displayFooter	0.392 ms	0.02 Mb
ps_languageselector	0.671 ms	0.05 Mb
__construct	0.060 ms	0.01 Mb
displayNav2	0.611 ms	0.04 Mb
ps_currencyselector	2.662 ms	0.24 Mb
__construct	0.047 ms	0.01 Mb
displayNav2	2.615 ms	0.24 Mb
ps_customersignin	0.546 ms	0.05 Mb
__construct	0.050 ms	0.01 Mb
displayNav2	0.496 ms	0.04 Mb
ps_mainmenu	0.813 ms	0.09 Mb
__construct	0.054 ms	0.01 Mb
displayTop	0.759 ms	0.08 Mb
ps_sharebuttons	1.186 ms	0.14 Mb
__construct	0.266 ms	0.04 Mb
displayProductAdditionalInfo	0.920 ms	0.09 Mb
psgdpr	0.091 ms	0.01 Mb
__construct	0.091 ms	0.01 Mb
ps_linklist	0.714 ms	0.10 Mb
__construct	0.169 ms	0.05 Mb
displayFooter	0.545 ms	0.06 Mb
ps_customeraccountlinks	0.585 ms	0.06 Mb
__construct	0.051 ms	0.01 Mb
displayFooter	0.534 ms	0.06 Mb
statsdata	495.762 ms	0.15 Mb
__construct	0.052 ms	0.01 Mb
hookDisplayBeforeBodyClosingTag	495.710 ms	0.15 Mb
22 module(s)	524.918 ms	2.28 Mb

164 queries	SELECT a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, agl.`public_name` as `public_group`, pa.`reference`, pa.`eanXX`, pa.`isbn`, pa.`upc`, pa.`mpn`, pal.`available_now`, pal.`available_later` FROM `ps_attribute` a LEFT JOIN `ps_attribute_lang` al ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = XX) LEFT JOIN `ps_product_attribute_combination` pac ON (pac.`id_attribute` = a.`id_attribute`) LEFT JOIN `ps_product_attribute` pa ON (pa.`id_product_attribute` = pac.`id_product_attribute`) INNER JOIN ps_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = XX) LEFT JOIN `ps_product_attribute_lang` pal ON (pal.`id_product_attribute` = pac.`id_product_attribute` AND pal.`id_lang` = XX) LEFT JOIN `ps_attribute_group_lang` agl ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = XX) WHERE pa.`id_product` = XX AND pac.`id_product_attribute` = XX AND agl.`id_lang` = XX
119 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
48 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
25 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
25 queries	SELECT pai.`id_image`, pai.`id_product_attribute`, il.`legend` FROM `ps_product_attribute_image` pai LEFT JOIN `ps_image_lang` il ON (il.`id_image` = pai.`id_image`) INNER JOIN `ps_image` i ON (i.`id_image` = pai.`id_image`) WHERE i.`id_product` = XX AND il.`id_lang` = XX ORDER by i.`position`
24 queries	SELECT `id_lang` FROM `ps_lang` WHERE `locale` = 'cs-cz' OR `language_code` = 'cs-cz' LIMIT XX
24 queries	SELECT product_attribute_shop.id_product_attribute FROM ps_product_attribute pa INNER JOIN ps_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = XX) WHERE pa.id_product = XX LIMIT XX
24 queries	SELECT product_attribute_shop.id_product_attribute FROM ps_product_attribute pa INNER JOIN ps_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = XX) WHERE product_attribute_shop.default_on = XX AND pa.id_product = XX LIMIT XX
24 queries	SELECT product_shop.`price`, product_shop.`ecotax`, IFNULL(product_attribute_shop.id_product_attribute,XX) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on, product_attribute_shop.`ecotax` AS attribute_ecotax FROM `ps_product` p INNER JOIN `ps_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = XX) LEFT JOIN `ps_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = XX) WHERE (p.`id_product` = XX)
24 queries	SELECT `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = XX AND `id_group` = XX LIMIT XX
24 queries	SELECT * FROM `ps_product_attribute` a LEFT JOIN `ps_product_attribute_shop` `c` ON a.`id_product_attribute` = c.`id_product_attribute` AND c.`id_shop` = XX WHERE (a.`id_product_attribute` = XX) LIMIT XX
24 queries	SELECT * FROM `ps_product_attribute_lang` WHERE `id_product_attribute` = XX
24 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
24 queries	SELECT pa.`available_date` FROM `ps_product` p LEFT JOIN `ps_product_attribute` pa ON (pa.`id_product` = p.`id_product`) INNER JOIN ps_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = XX) INNER JOIN ps_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = XX) WHERE p.`id_product` = XX AND pa.`id_product` = XX AND pa.`id_product_attribute` = XX LIMIT XX
24 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`
23 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 = IFNULL(`pa`.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;
13 queries	SELECT `id_module` FROM `ps_module_shop` WHERE `id_module` = XX AND `id_shop` = XX LIMIT XX
12 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
5 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
4 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
4 queries	SELECT * FROM `ps_currency_lang` WHERE `id_currency` = XX
3 queries	SELECT pa.id_product_attribute FROM `ps_product_attribute` pa INNER JOIN ps_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = XX) WHERE pa.`id_product` = XX
3 queries	SELECT pa., product_attribute_shop., ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, al.`name` AS attribute_name, a.`id_attribute`, stock.location FROM `ps_product_attribute` pa INNER JOIN ps_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = XX) LEFT JOIN `ps_product_attribute_combination` pac ON pac.`id_product_attribute` = pa.`id_product_attribute` LEFT JOIN `ps_attribute` a ON a.`id_attribute` = pac.`id_attribute` LEFT JOIN `ps_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group` LEFT JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = XX) LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = XX) LEFT JOIN `ps_stock_available` stock ON (stock.id_product = pa.id_product AND stock.id_product_attribute = IFNULL(pa.`id_product_attribute`, XX)) WHERE pa.`id_product` = XX GROUP BY pa.`id_product_attribute`, ag.`id_attribute_group` ORDER BY pa.`id_product_attribute`
3 queries	SELECT ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, agl.`public_name` AS public_group_name, a.`id_attribute`, al.`name` AS attribute_name, a.`color` AS attribute_color, product_attribute_shop.`id_product_attribute`, IFNULL(stock.quantity, XX) as quantity, product_attribute_shop.`price`, product_attribute_shop.`ecotax`, product_attribute_shop.`weight`, product_attribute_shop.`default_on`, pa.`reference`, pa.`eanXX`, pa.`mpn`, pa.`upc`, pa.`isbn`, product_attribute_shop.`unit_price_impact`, product_attribute_shop.`minimal_quantity`, product_attribute_shop.`available_date`, ag.`group_type`, pal.`available_now`, pal.`available_later` FROM `ps_product_attribute` pa INNER JOIN ps_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = XX) LEFT JOIN ps_stock_available stock ON (stock.id_product = `pa`.id_product AND stock.id_product_attribute = IFNULL(`pa`.id_product_attribute, XX) AND stock.id_shop = XX AND stock.id_shop_group = XX ) LEFT JOIN `ps_product_attribute_lang` `pal` ON pa.id_product_attribute = pal.id_product_attribute AND pal.id_lang = XX LEFT JOIN `ps_product_attribute_combination` `pac` ON pac.id_product_attribute = pa.id_product_attribute LEFT JOIN `ps_attribute` `a` ON a.id_attribute = pac.id_attribute LEFT JOIN `ps_attribute_group` `ag` ON ag.id_attribute_group = a.id_attribute_group LEFT JOIN `ps_attribute_lang` `al` ON a.id_attribute = al.id_attribute LEFT JOIN `ps_attribute_group_lang` `agl` ON ag.id_attribute_group = agl.id_attribute_group INNER JOIN ps_attribute_shop attribute_shop ON (attribute_shop.id_attribute = a.id_attribute AND attribute_shop.id_shop = XX) WHERE (pa.id_product = XX) AND (al.id_lang = XX) AND (agl.id_lang = XX) AND (product_attribute_shop.id_product_attribute = XX) GROUP BY id_attribute_group, id_product_attribute ORDER BY ag.position ASC, a.position ASC, agl.name ASC
3 queries	SELECT `need_identification_number` FROM `ps_country` WHERE `id_country` = XX LIMIT XX
2 queries	SELECT * FROM `ps_lang` a LEFT JOIN `ps_lang_shop` `c` ON a.`id_lang` = c.`id_lang` AND c.`id_shop` = XX WHERE (a.`id_lang` = XX) LIMIT XX
2 queries	SELECT id_shop FROM `ps_lang_shop` WHERE `id_lang` = XX AND id_shop = XX LIMIT XX
2 queries	SELECT m.`id_module`, m.`name`, ms.`id_module`as `mshop` FROM `ps_module` m LEFT JOIN `ps_module_shop` ms ON m.`id_module` = ms.`id_module` AND ms.`id_shop` = XX
2 queries	SELECT tr.* FROM `ps_tax_rule` tr JOIN `ps_tax_rules_group` trg ON (tr.`id_tax_rules_group` = trg.`id_tax_rules_group`) WHERE trg.`active` = XX AND tr.`id_country` = XX AND tr.`id_tax_rules_group` = XX AND tr.`id_state` IN (XX, XX) AND ('XX XX' BETWEEN tr.`zipcode_from` AND tr.`zipcode_to` OR (tr.`zipcode_to` = XX AND tr.`zipcode_from` IN(XX, 'XX XX'))) ORDER BY tr.`zipcode_from` DESC, tr.`zipcode_to` DESC, tr.`id_state` DESC, tr.`id_country` DESC
2 queries	SELECT 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
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

Name	Instances	Source
Product	206	/controllers/front/ProductController.php:149 (__construct) [id: 1905] /src/Adapter/Image/ImageRetriever.php:71 (__construct) [id: 1905] /src/Adapter/Image/ImageRetriever.php:71 (__construct) [id: 1830] /src/Adapter/Image/ImageRetriever.php:71 (__construct) [id: 1883] /src/Adapter/Image/ImageRetriever.php:71 (__construct) [id: 1868] /src/Adapter/Image/ImageRetriever.php:71 (__construct) [id: 1835] /src/Adapter/Image/ImageRetriever.php:71 (__construct) [id: 1353] /src/Adapter/Image/ImageRetriever.php:71 (__construct) [id: 1354] /src/Adapter/Image/ImageRetriever.php:71 (__construct) [id: 1903] /src/Adapter/Image/ImageRetriever.php:71 (__construct) [id: 1913] /src/Adapter/Image/ImageRetriever.php:71 (__construct) [id: 1909] /src/Adapter/Image/ImageRetriever.php:71 (__construct) [id: 1907] /src/Adapter/Image/ImageRetriever.php:71 (__construct) [id: 1911] /src/Adapter/Image/ImageRetriever.php:71 (__construct) [id: 1862] /src/Adapter/Image/ImageRetriever.php:71 (__construct) [id: 1849] /src/Adapter/Image/ImageRetriever.php:71 (__construct) [id: 1821] /src/Adapter/Image/ImageRetriever.php:71 (__construct) [id: 1817] /src/Adapter/Image/ImageRetriever.php:71 (__construct) [id: 1893] /src/Adapter/Image/ImageRetriever.php:71 (__construct) [id: 1898] /src/Adapter/Image/ImageRetriever.php:71 (__construct) [id: 1888] /src/Adapter/Image/ImageRetriever.php:71 (__construct) [id: 1873] /src/Adapter/Image/ImageRetriever.php:71 (__construct) [id: 1806] /src/Adapter/Image/ImageRetriever.php:71 (__construct) [id: 1808] /src/Adapter/Image/ImageRetriever.php:71 (__construct) [id: 1840] /src/Adapter/Image/ImageRetriever.php:71 (__construct) [id: 1878] /classes/Meta.php:340 (__construct) [id: 1905] /classes/Link.php:114 (__construct) [id: 1905] /classes/Link.php:114 (__construct) [id: 1905] /classes/Link.php:114 (__construct) [id: 1905] /classes/Link.php:114 (__construct) [id: 1905] /classes/Link.php:114 (__construct) [id: 1905] /classes/Link.php:114 (__construct) [id: 1905] /classes/Link.php:114 (__construct) [id: 1905] /classes/Link.php:114 (__construct) [id: 1905] /classes/Link.php:114 (__construct) [id: 1905] /classes/Link.php:114 (__construct) [id: 1905] /classes/Link.php:114 (__construct) [id: 1830] /classes/Link.php:114 (__construct) [id: 1830] /classes/Link.php:114 (__construct) [id: 1830] /classes/Link.php:114 (__construct) [id: 1830] /classes/Link.php:114 (__construct) [id: 1830] /classes/Link.php:114 (__construct) [id: 1883] /classes/Link.php:114 (__construct) [id: 1883] /classes/Link.php:114 (__construct) [id: 1883] /classes/Link.php:114 (__construct) [id: 1883] /classes/Link.php:114 (__construct) [id: 1883] /classes/Link.php:114 (__construct) [id: 1883] /classes/Link.php:114 (__construct) [id: 1883] /classes/Link.php:114 (__construct) [id: 1883] /classes/Link.php:114 (__construct) [id: 1883] /classes/Link.php:114 (__construct) [id: 1868] /classes/Link.php:114 (__construct) [id: 1868] /classes/Link.php:114 (__construct) [id: 1868] /classes/Link.php:114 (__construct) [id: 1868] /classes/Link.php:114 (__construct) [id: 1868] /classes/Link.php:114 (__construct) [id: 1868] /classes/Link.php:114 (__construct) [id: 1868] /classes/Link.php:114 (__construct) [id: 1868] /classes/Link.php:114 (__construct) [id: 1868] /classes/Link.php:114 (__construct) [id: 1835] /classes/Link.php:114 (__construct) [id: 1835] /classes/Link.php:114 (__construct) [id: 1835] /classes/Link.php:114 (__construct) [id: 1835] /classes/Link.php:114 (__construct) [id: 1835] /classes/Link.php:114 (__construct) [id: 1353] /classes/Link.php:114 (__construct) [id: 1353] /classes/Link.php:114 (__construct) [id: 1353] /classes/Link.php:114 (__construct) [id: 1353] /classes/Link.php:114 (__construct) [id: 1353] /classes/Link.php:114 (__construct) [id: 1353] /classes/Link.php:114 (__construct) [id: 1353] /classes/Link.php:114 (__construct) [id: 1353] /classes/Link.php:114 (__construct) [id: 1353] /classes/Link.php:114 (__construct) [id: 1354] /classes/Link.php:114 (__construct) [id: 1354] /classes/Link.php:114 (__construct) [id: 1354] /classes/Link.php:114 (__construct) [id: 1354] /classes/Link.php:114 (__construct) [id: 1354] /classes/Link.php:114 (__construct) [id: 1354] /classes/Link.php:114 (__construct) [id: 1354] /classes/Link.php:114 (__construct) [id: 1354] /classes/Link.php:114 (__construct) [id: 1354] /classes/Link.php:114 (__construct) [id: 1903] /classes/Link.php:114 (__construct) [id: 1903] /classes/Link.php:114 (__construct) [id: 1903] /classes/Link.php:114 (__construct) [id: 1903] /classes/Link.php:114 (__construct) [id: 1903] /classes/Link.php:114 (__construct) [id: 1903] /classes/Link.php:114 (__construct) [id: 1903] /classes/Link.php:114 (__construct) [id: 1903] /classes/Link.php:114 (__construct) [id: 1913] /classes/Link.php:114 (__construct) [id: 1913] /classes/Link.php:114 (__construct) [id: 1913] /classes/Link.php:114 (__construct) [id: 1913] /classes/Link.php:114 (__construct) [id: 1913] /classes/Link.php:114 (__construct) [id: 1913] /classes/Link.php:114 (__construct) [id: 1913] /classes/Link.php:114 (__construct) [id: 1913] /classes/Link.php:114 (__construct) [id: 1909] /classes/Link.php:114 (__construct) [id: 1909] /classes/Link.php:114 (__construct) [id: 1909] /classes/Link.php:114 (__construct) [id: 1909] /classes/Link.php:114 (__construct) [id: 1909] /classes/Link.php:114 (__construct) [id: 1909] /classes/Link.php:114 (__construct) [id: 1909] /classes/Link.php:114 (__construct) [id: 1909] /classes/Link.php:114 (__construct) [id: 1907] /classes/Link.php:114 (__construct) [id: 1907] /classes/Link.php:114 (__construct) [id: 1907] /classes/Link.php:114 (__construct) [id: 1907] /classes/Link.php:114 (__construct) [id: 1907] /classes/Link.php:114 (__construct) [id: 1907] /classes/Link.php:114 (__construct) [id: 1907] /classes/Link.php:114 (__construct) [id: 1907] /classes/Link.php:114 (__construct) [id: 1911] /classes/Link.php:114 (__construct) [id: 1911] /classes/Link.php:114 (__construct) [id: 1911] /classes/Link.php:114 (__construct) [id: 1911] /classes/Link.php:114 (__construct) [id: 1911] /classes/Link.php:114 (__construct) [id: 1911] /classes/Link.php:114 (__construct) [id: 1911] /classes/Link.php:114 (__construct) [id: 1911] /classes/Link.php:114 (__construct) [id: 1862] /classes/Link.php:114 (__construct) [id: 1862] /classes/Link.php:114 (__construct) [id: 1862] /classes/Link.php:114 (__construct) [id: 1862] /classes/Link.php:114 (__construct) [id: 1862] /classes/Link.php:114 (__construct) [id: 1862] /classes/Link.php:114 (__construct) [id: 1862] /classes/Link.php:114 (__construct) [id: 1862] /classes/Link.php:114 (__construct) [id: 1849] /classes/Link.php:114 (__construct) [id: 1849] /classes/Link.php:114 (__construct) [id: 1849] /classes/Link.php:114 (__construct) [id: 1849] /classes/Link.php:114 (__construct) [id: 1849] /classes/Link.php:114 (__construct) [id: 1849] /classes/Link.php:114 (__construct) [id: 1849] /classes/Link.php:114 (__construct) [id: 1849] /classes/Link.php:114 (__construct) [id: 1821] /classes/Link.php:114 (__construct) [id: 1821] /classes/Link.php:114 (__construct) [id: 1821] /classes/Link.php:114 (__construct) [id: 1821] /classes/Link.php:114 (__construct) [id: 1821] /classes/Link.php:114 (__construct) [id: 1821] /classes/Link.php:114 (__construct) [id: 1821] /classes/Link.php:114 (__construct) [id: 1821] /classes/Link.php:114 (__construct) [id: 1817] /classes/Link.php:114 (__construct) [id: 1817] /classes/Link.php:114 (__construct) [id: 1817] /classes/Link.php:114 (__construct) [id: 1817] /classes/Link.php:114 (__construct) [id: 1817] /classes/Link.php:114 (__construct) [id: 1817] /classes/Link.php:114 (__construct) [id: 1817] /classes/Link.php:114 (__construct) [id: 1817] /classes/Link.php:114 (__construct) [id: 1893] /classes/Link.php:114 (__construct) [id: 1893] /classes/Link.php:114 (__construct) [id: 1893] /classes/Link.php:114 (__construct) [id: 1893] /classes/Link.php:114 (__construct) [id: 1893] /classes/Link.php:114 (__construct) [id: 1893] /classes/Link.php:114 (__construct) [id: 1893] /classes/Link.php:114 (__construct) [id: 1893] /classes/Link.php:114 (__construct) [id: 1893] /classes/Link.php:114 (__construct) [id: 1898] /classes/Link.php:114 (__construct) [id: 1898] /classes/Link.php:114 (__construct) [id: 1898] /classes/Link.php:114 (__construct) [id: 1898] /classes/Link.php:114 (__construct) [id: 1898] /classes/Link.php:114 (__construct) [id: 1898] /classes/Link.php:114 (__construct) [id: 1898] /classes/Link.php:114 (__construct) [id: 1898] /classes/Link.php:114 (__construct) [id: 1898] /classes/Link.php:114 (__construct) [id: 1888] /classes/Link.php:114 (__construct) [id: 1888] /classes/Link.php:114 (__construct) [id: 1888] /classes/Link.php:114 (__construct) [id: 1888] /classes/Link.php:114 (__construct) [id: 1888] /classes/Link.php:114 (__construct) [id: 1888] /classes/Link.php:114 (__construct) [id: 1888] /classes/Link.php:114 (__construct) [id: 1888] /classes/Link.php:114 (__construct) [id: 1888] /classes/Link.php:114 (__construct) [id: 1873] /classes/Link.php:114 (__construct) [id: 1873] /classes/Link.php:114 (__construct) [id: 1873] /classes/Link.php:114 (__construct) [id: 1873] /classes/Link.php:114 (__construct) [id: 1873] /classes/Link.php:114 (__construct) [id: 1806] /classes/Link.php:114 (__construct) [id: 1806] /classes/Link.php:114 (__construct) [id: 1806] /classes/Link.php:114 (__construct) [id: 1806] /classes/Link.php:114 (__construct) [id: 1806] /classes/Link.php:114 (__construct) [id: 1808] /classes/Link.php:114 (__construct) [id: 1808] /classes/Link.php:114 (__construct) [id: 1808] /classes/Link.php:114 (__construct) [id: 1808] /classes/Link.php:114 (__construct) [id: 1808] /classes/Link.php:114 (__construct) [id: 1840] /classes/Link.php:114 (__construct) [id: 1840] /classes/Link.php:114 (__construct) [id: 1840] /classes/Link.php:114 (__construct) [id: 1840] /classes/Link.php:114 (__construct) [id: 1840] /classes/Link.php:114 (__construct) [id: 1878] /classes/Link.php:114 (__construct) [id: 1878] /classes/Link.php:114 (__construct) [id: 1878] /classes/Link.php:114 (__construct) [id: 1878] /classes/Link.php:114 (__construct) [id: 1878]
Combination	25	/controllers/front/ProductController.php:1537 (__construct) [id: 81514] /classes/Product.php:5645 (__construct) [id: 81514] /classes/Product.php:5645 (__construct) [id: 77917] /classes/Product.php:5645 (__construct) [id: 79931] /classes/Product.php:5645 (__construct) [id: 79271] /classes/Product.php:5645 (__construct) [id: 78097] /classes/Product.php:5645 (__construct) [id: 55907] /classes/Product.php:5645 (__construct) [id: 55963] /classes/Product.php:5645 (__construct) [id: 81331] /classes/Product.php:5645 (__construct) [id: 82051] /classes/Product.php:5645 (__construct) [id: 81763] /classes/Product.php:5645 (__construct) [id: 81619] /classes/Product.php:5645 (__construct) [id: 81907] /classes/Product.php:5645 (__construct) [id: 79167] /classes/Product.php:5645 (__construct) [id: 78907] /classes/Product.php:5645 (__construct) [id: 77775] /classes/Product.php:5645 (__construct) [id: 75615] /classes/Product.php:5645 (__construct) [id: 80631] /classes/Product.php:5645 (__construct) [id: 80981] /classes/Product.php:5645 (__construct) [id: 80231] /classes/Product.php:5645 (__construct) [id: 79571] /classes/Product.php:5645 (__construct) [id: 75093] /classes/Product.php:5645 (__construct) [id: 75103] /classes/Product.php:5645 (__construct) [id: 78277] /classes/Product.php:5645 (__construct) [id: 79751]
Currency	16	/src/Adapter/Currency/CurrencyDataProvider.php:101 (__construct) [id: 6] /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: 10] /src/Adapter/Currency/CurrencyDataProvider.php:101 (__construct) [id: 2] /src/Adapter/Currency/CurrencyDataProvider.php:101 (__construct) [id: 4] /src/Adapter/Currency/CurrencyDataProvider.php:101 (__construct) [id: 9] /src/Adapter/Currency/CurrencyDataProvider.php:101 (__construct) [id: 11] /src/Adapter/Currency/CurrencyDataProvider.php:101 (__construct) [id: 12] /src/Adapter/Currency/CurrencyDataProvider.php:101 (__construct) [id: 3] /src/Adapter/Currency/CurrencyDataProvider.php:101 (__construct) [id: 8] /src/Adapter/Currency/CurrencyDataProvider.php:101 (__construct) [id: 5] /classes/Tools.php:680 (getCurrencyInstance) [id: 1] /modules/ps_currencyselector/ps_currencyselector.php:112 (getCurrencies) [id: 6] /modules/ps_currencyselector/ps_currencyselector.php:112 (getCurrencies) [id: 2] /modules/ps_currencyselector/ps_currencyselector.php:112 (getCurrencies) [id: 5]
Country	7	/config/config.inc.php:154 (__construct) [id: 16] /classes/AddressFormat.php:402 (__construct) [id: 16] /classes/controller/FrontController.php:1702 (__construct) [id: 16] /classes/AddressFormat.php:402 (__construct) [id: 16] /modules/ps_contactinfo/ps_contactinfo.php:105 (__construct) [id: 16] /classes/AddressFormat.php:402 (__construct) [id: 16] /modules/ps_contactinfo/ps_contactinfo.php:105 (__construct) [id: 16]
Address	6	/classes/Product.php:723 (__construct) [id: ] /classes/Product.php:6564 (initialize) [id: ] /classes/Product.php:3547 (__construct) [id: ] /controllers/front/ProductController.php:557 (__construct) [id: 0] /classes/Product.php:5697 (__construct) [id: ] /classes/shop/Shop.php:487 (__construct) [id: ]
Category	5	/controllers/front/ProductController.php:308 (__construct) [id: 295] /controllers/front/ProductController.php:1336 (__construct) [id: 295] /classes/PrestaShopCollection.php:383 (hydrateCollection) [id: ] /classes/PrestaShopCollection.php:383 (hydrateCollection) [id: ] /classes/PrestaShopCollection.php:383 (hydrateCollection) [id: ]
Manufacturer	3	/controllers/front/ProductController.php:858 (__construct) [id: 1] /src/Adapter/Presenter/Manufacturer/ManufacturerLazyArray.php:98 (__construct) [id: 1] /classes/Link.php:655 (__construct) [id: 1]
State	3	/classes/controller/FrontController.php:1701 (__construct) [id: 0] /modules/ps_contactinfo/ps_contactinfo.php:94 (__construct) [id: 0] /modules/ps_contactinfo/ps_contactinfo.php:94 (__construct) [id: 0]
Language	3	/config/config.inc.php:219 (__construct) [id: 2] /classes/Tools.php:631 (__construct) [id: 1] /classes/Tools.php:550 (__construct) [id: 1]
AddressFormat	3	/classes/controller/FrontController.php:1696 (generateAddress) [id: ] /modules/ps_contactinfo/ps_contactinfo.php:91 (generateAddress) [id: ] /modules/ps_contactinfo/ps_contactinfo.php:91 (generateAddress) [id: ]
Tax	2	/classes/tax/TaxRulesTaxManager.php:113 (__construct) [id: 1] /classes/tax/TaxRulesTaxManager.php:113 (__construct) [id: 1]
Risk	1	/classes/controller/FrontController.php:1622 (__construct) [id: ]
Gender	1	/classes/controller/FrontController.php:1619 (__construct) [id: 0]
Shop	1	/config/config.inc.php:122 (initialize) [id: 1]
Group	1	/classes/Cart.php:272 (getCurrent) [id: 1]
Cart	1	/classes/controller/FrontController.php:425 (__construct) [id: ]
Customer	1	/config/config.inc.php:272 (__construct) [id: ]
ShopGroup	1	/classes/shop/Shop.php:562 (__construct) [id: 1]
ConnectionsSource	1	/modules/statsdata/statsdata.php:119 (logHttpReferer) [id: ]

#	Query	Time (ms)	Rows	Filesort	Group By	Location
814	SELECT SQL_NO_CACHE `id_date_range`, `time_end` FROM `ps_date_range` WHERE `time_end` = (SELECT MAX(`time_end`) FROM `ps_date_range`) LIMIT 1	483.281 ms	966595720336			/classes/DateRange.php:60 /classes/Page.php:122 (getCurrentRange) /modules/statsdata/statsdata.php:121 (setPageViewed) /modules/statsdata/statsdata.php:74 (getScriptCustomerPagesViews) /classes/Hook.php:1237 (hookDisplayBeforeBodyClosingTag) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:454 (coreCallHook) /classes/Hook.php:1129 (callHookOn) /config/smarty.config.inc.php:213 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/14/fc/a5/14fca50b0aaf6d148e3756d711ec57c6a6a65aa6_2.file.layout-both-columns.tpl.php:430 (__call) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/14/fc/a5/14fca50b0aaf6d148e3756d711ec57c6a6a65aa6_2.file.layout-both-columns.tpl.php:111 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_696d69ac074786_63949425) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/52/90/c3/5290c344b4d07ab96e07f0571e67dcd59554195b_2.file.layout-full-width.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_696d69ac0682e0_59046668) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/b0/6c/17/b06c171e48c9d85ed0ff854f6229786cb32dbffe_2.file.product.tpl.php:54 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_696d6ad31782a6_74072138) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/Smarty/SmartyDev.php:40 (fetch) /classes/controller/FrontController.php:720 (fetch) /classes/controller/FrontController.php:704 (smartyOutputContent) /tools/profiling/Controller.php:111 (display) /tools/profiling/Controller.php:88 (displayProfiling) /classes/Dispatcher.php:488 (run) /index.php:86 (dispatch)
742	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 = IFNULL(`pa`.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 (1817) AND ag.`is_color_group` = 1 GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` HAVING qty > 0 ORDER BY a.`position` ASC;	8.334 ms	25056	Yes		/classes/Product.php:4289 /src/Adapter/Product/ProductColorsRetriever.php:43 (getAttributesColorList) /src/Adapter/Presenter/Product/ProductLazyArray.php:788 (getColoredVariants) /src/Adapter/Presenter/AbstractLazyArray.php:264 (getMainVariants) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/a8/a7/10/a8a710300f7cdde35120cbe16ad19050d30a1441_2.file.product.tpl.php:234 (offsetGet) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/a8/a7/10/a8a710300f7cdde35120cbe16ad19050d30a1441_2.file.product.tpl.php:338 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/a8/a7/10/a8a710300f7cdde35120cbe16ad19050d30a1441_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:156 (process) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/a8/a7/10/a8a710300f7cdde35120cbe16ad19050d30a1441_2.file.product.tpl.php:32 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_696d6ad326bb14_67715724) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:384 (render) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/3f/7d/0d/3f7d0dd85735416bd5b3ce10b4554f5fb578932d_2.file.productlist.tpl.php:39 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_696d6ad3253ca6_70171256) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/11/0a/74/110a7449c58ac8b5c663389783a92499ea1c7ebd_2.file.product-accessories.tpl.php:32 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_696d6ad324e7c8_52865461) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/b0/6c/17/b06c171e48c9d85ed0ff854f6229786cb32dbffe_2.file.product.tpl.php:490 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/b0/6c/17/b06c171e48c9d85ed0ff854f6229786cb32dbffe_2.file.product.tpl.php:687 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:186 (process) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/52/90/c3/5290c344b4d07ab96e07f0571e67dcd59554195b_2.file.layout-full-width.tpl.php:72 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/52/90/c3/5290c344b4d07ab96e07f0571e67dcd59554195b_2.file.layout-full-width.tpl.php:130 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:186 (process) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/14/fc/a5/14fca50b0aaf6d148e3756d711ec57c6a6a65aa6_2.file.layout-both-columns.tpl.php:85 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_696d69ac074786_63949425) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/52/90/c3/5290c344b4d07ab96e07f0571e67dcd59554195b_2.file.layout-full-width.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_696d69ac0682e0_59046668) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/b0/6c/17/b06c171e48c9d85ed0ff854f6229786cb32dbffe_2.file.product.tpl.php:54 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_696d6ad31782a6_74072138) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/Smarty/SmartyDev.php:40 (fetch) /classes/controller/FrontController.php:720 (fetch) /classes/controller/FrontController.php:704 (smartyOutputContent) /tools/profiling/Controller.php:111 (display) /tools/profiling/Controller.php:88 (displayProfiling) /classes/Dispatcher.php:488 (run) /index.php:86 (dispatch)
812	INSERT IGNORE INTO `ps_connections_page` (`id_connections`, `id_page`, `time_start`) VALUES ('5565573', '1157', '2026-01-19 00:32:24')	5.258 ms	1			/classes/Connection.php:122 /modules/statsdata/statsdata.php:118 (setPageConnection) /modules/statsdata/statsdata.php:74 (getScriptCustomerPagesViews) /classes/Hook.php:1237 (hookDisplayBeforeBodyClosingTag) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:454 (coreCallHook) /classes/Hook.php:1129 (callHookOn) /config/smarty.config.inc.php:213 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/14/fc/a5/14fca50b0aaf6d148e3756d711ec57c6a6a65aa6_2.file.layout-both-columns.tpl.php:430 (__call) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/14/fc/a5/14fca50b0aaf6d148e3756d711ec57c6a6a65aa6_2.file.layout-both-columns.tpl.php:111 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_696d69ac074786_63949425) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/52/90/c3/5290c344b4d07ab96e07f0571e67dcd59554195b_2.file.layout-full-width.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_696d69ac0682e0_59046668) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/b0/6c/17/b06c171e48c9d85ed0ff854f6229786cb32dbffe_2.file.product.tpl.php:54 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_696d6ad31782a6_74072138) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/Smarty/SmartyDev.php:40 (fetch) /classes/controller/FrontController.php:720 (fetch) /classes/controller/FrontController.php:704 (smartyOutputContent) /tools/profiling/Controller.php:111 (display) /tools/profiling/Controller.php:88 (displayProfiling) /classes/Dispatcher.php:488 (run) /index.php:86 (dispatch)
586	SELECT SQL_NO_CACHE ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, agl.`public_name` AS public_group_name, a.`id_attribute`, al.`name` AS attribute_name, a.`color` AS attribute_color, product_attribute_shop.`id_product_attribute`, IFNULL(stock.quantity, 0) as quantity, product_attribute_shop.`price`, product_attribute_shop.`ecotax`, product_attribute_shop.`weight`, product_attribute_shop.`default_on`, pa.`reference`, pa.`ean13`, pa.`mpn`, pa.`upc`, pa.`isbn`, product_attribute_shop.`unit_price_impact`, product_attribute_shop.`minimal_quantity`, product_attribute_shop.`available_date`, ag.`group_type`, pal.`available_now`, pal.`available_later` FROM `ps_product_attribute` pa INNER JOIN ps_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) LEFT JOIN ps_stock_available stock ON (stock.id_product = `pa`.id_product AND stock.id_product_attribute = IFNULL(`pa`.id_product_attribute, 0) AND stock.id_shop = 1 AND stock.id_shop_group = 0 ) LEFT JOIN `ps_product_attribute_lang` `pal` ON pa.id_product_attribute = pal.id_product_attribute AND pal.id_lang = 1 LEFT JOIN `ps_product_attribute_combination` `pac` ON pac.id_product_attribute = pa.id_product_attribute LEFT JOIN `ps_attribute` `a` ON a.id_attribute = pac.id_attribute LEFT JOIN `ps_attribute_group` `ag` ON ag.id_attribute_group = a.id_attribute_group LEFT JOIN `ps_attribute_lang` `al` ON a.id_attribute = al.id_attribute LEFT JOIN `ps_attribute_group_lang` `agl` ON ag.id_attribute_group = agl.id_attribute_group INNER JOIN ps_attribute_shop attribute_shop ON (attribute_shop.id_attribute = a.id_attribute AND attribute_shop.id_shop = 1) WHERE (pa.id_product = 1905) AND (al.id_lang = 1) AND (agl.id_lang = 1) GROUP BY id_attribute_group, id_product_attribute ORDER BY ag.position ASC, a.position ASC, agl.name ASC	2.431 ms	144	Yes	Yes	/classes/Product.php:4365 /controllers/front/ProductController.php:607 (getAttributesGroups) /controllers/front/ProductController.php:415 (assignAttributesGroups) /tools/profiling/Controller.php:65 (initContent) /classes/Dispatcher.php:488 (run) /index.php:86 (dispatch)
125	SELECT SQL_NO_CACHE pa., product_attribute_shop., ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, al.`name` AS attribute_name, a.`id_attribute`, stock.location 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_product_attribute_combination` pac ON pac.`id_product_attribute` = pa.`id_product_attribute` LEFT JOIN `ps_attribute` a ON a.`id_attribute` = pac.`id_attribute` LEFT JOIN `ps_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group` LEFT JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1) LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1) LEFT JOIN `ps_stock_available` stock ON (stock.id_product = pa.id_product AND stock.id_product_attribute = IFNULL(pa.`id_product_attribute`, 0)) WHERE pa.`id_product` = 1905 GROUP BY pa.`id_product_attribute`, ag.`id_attribute_group` ORDER BY pa.`id_product_attribute`	2.095 ms	144	Yes	Yes	/classes/Product.php:2576 /controllers/front/ProductController.php:1087 (getAttributeCombinations) /controllers/front/ProductController.php:1071 (tryToGetAvailableIdProductAttribute) /controllers/front/ProductController.php:567 (getIdProductAttributeByGroupOrRequestOrDefault) /controllers/front/ProductController.php:327 (assignPriceAndTax) /tools/profiling/Controller.php:65 (initContent) /classes/Dispatcher.php:488 (run) /index.php:86 (dispatch)
201	SELECT SQL_NO_CACHE pa., product_attribute_shop., ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, al.`name` AS attribute_name, a.`id_attribute`, stock.location 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_product_attribute_combination` pac ON pac.`id_product_attribute` = pa.`id_product_attribute` LEFT JOIN `ps_attribute` a ON a.`id_attribute` = pac.`id_attribute` LEFT JOIN `ps_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group` LEFT JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1) LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1) LEFT JOIN `ps_stock_available` stock ON (stock.id_product = pa.id_product AND stock.id_product_attribute = IFNULL(pa.`id_product_attribute`, 0)) WHERE pa.`id_product` = 1905 GROUP BY pa.`id_product_attribute`, ag.`id_attribute_group` ORDER BY pa.`id_product_attribute`	2.044 ms	144	Yes	Yes	/classes/Product.php:2576 /controllers/front/ProductController.php:1087 (getAttributeCombinations) /controllers/front/ProductController.php:1071 (tryToGetAvailableIdProductAttribute) /controllers/front/ProductController.php:1194 (getIdProductAttributeByGroupOrRequestOrDefault) /controllers/front/ProductController.php:337 (getTemplateVarProduct) /tools/profiling/Controller.php:65 (initContent) /classes/Dispatcher.php:488 (run) /index.php:86 (dispatch)
816	INSERT INTO `ps_page_viewed` (`id_date_range`, `id_page`, `counter`, `id_shop`, `id_shop_group`) VALUES ('1022102', '1157', '1', '1', '1')	1.997 ms	1			/classes/Page.php:142 /modules/statsdata/statsdata.php:121 (setPageViewed) /modules/statsdata/statsdata.php:74 (getScriptCustomerPagesViews) /classes/Hook.php:1237 (hookDisplayBeforeBodyClosingTag) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:454 (coreCallHook) /classes/Hook.php:1129 (callHookOn) /config/smarty.config.inc.php:213 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/14/fc/a5/14fca50b0aaf6d148e3756d711ec57c6a6a65aa6_2.file.layout-both-columns.tpl.php:430 (__call) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/14/fc/a5/14fca50b0aaf6d148e3756d711ec57c6a6a65aa6_2.file.layout-both-columns.tpl.php:111 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_696d69ac074786_63949425) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/52/90/c3/5290c344b4d07ab96e07f0571e67dcd59554195b_2.file.layout-full-width.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_696d69ac0682e0_59046668) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/b0/6c/17/b06c171e48c9d85ed0ff854f6229786cb32dbffe_2.file.product.tpl.php:54 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_696d6ad31782a6_74072138) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/Smarty/SmartyDev.php:40 (fetch) /classes/controller/FrontController.php:720 (fetch) /classes/controller/FrontController.php:704 (smartyOutputContent) /tools/profiling/Controller.php:111 (display) /tools/profiling/Controller.php:88 (displayProfiling) /classes/Dispatcher.php:488 (run) /index.php:86 (dispatch)
813	INSERT INTO `ps_connections_source` (`id_connections`, `http_referer`, `request_uri`, `keywords`, `date_add`) VALUES ('5565573', '', 'shop.4abies.com/cs/do-postylky/1905-81514-popruh-na-matraci-pro-obojek-4abies.html', '', '2026-01-19 00:32:24')	1.985 ms	1			/classes/ObjectModel.php:535 /classes/ConnectionsSource.php:106 (add) /modules/statsdata/statsdata.php:119 (logHttpReferer) /modules/statsdata/statsdata.php:74 (getScriptCustomerPagesViews) /classes/Hook.php:1237 (hookDisplayBeforeBodyClosingTag) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:454 (coreCallHook) /classes/Hook.php:1129 (callHookOn) /config/smarty.config.inc.php:213 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/14/fc/a5/14fca50b0aaf6d148e3756d711ec57c6a6a65aa6_2.file.layout-both-columns.tpl.php:430 (__call) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/14/fc/a5/14fca50b0aaf6d148e3756d711ec57c6a6a65aa6_2.file.layout-both-columns.tpl.php:111 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_696d69ac074786_63949425) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/52/90/c3/5290c344b4d07ab96e07f0571e67dcd59554195b_2.file.layout-full-width.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_696d69ac0682e0_59046668) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/b0/6c/17/b06c171e48c9d85ed0ff854f6229786cb32dbffe_2.file.product.tpl.php:54 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_696d6ad31782a6_74072138) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/Smarty/SmartyDev.php:40 (fetch) /classes/controller/FrontController.php:720 (fetch) /classes/controller/FrontController.php:704 (smartyOutputContent) /tools/profiling/Controller.php:111 (display) /tools/profiling/Controller.php:88 (displayProfiling) /classes/Dispatcher.php:488 (run) /index.php:86 (dispatch)
601	SELECT SQL_NO_CACHE pa., product_attribute_shop., ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, al.`name` AS attribute_name, a.`id_attribute`, stock.location 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_product_attribute_combination` pac ON pac.`id_product_attribute` = pa.`id_product_attribute` LEFT JOIN `ps_attribute` a ON a.`id_attribute` = pac.`id_attribute` LEFT JOIN `ps_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group` LEFT JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1) LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1) LEFT JOIN `ps_stock_available` stock ON (stock.id_product = pa.id_product AND stock.id_product_attribute = IFNULL(pa.`id_product_attribute`, 0)) WHERE pa.`id_product` = 1905 GROUP BY pa.`id_product_attribute`, ag.`id_attribute_group` ORDER BY pa.`id_product_attribute`	1.970 ms	144	Yes	Yes	/classes/Product.php:2576 /controllers/front/ProductController.php:1087 (getAttributeCombinations) /controllers/front/ProductController.php:1040 (tryToGetAvailableIdProductAttribute) /controllers/front/ProductController.php:1358 (getIdProductAttributeByRequest) /classes/controller/FrontController.php:1816 (getBreadcrumbLinks) /classes/controller/FrontController.php:522 (getBreadcrumb) /classes/controller/FrontController.php:580 (assignGeneralPurposeVariables) /controllers/front/ProductController.php:418 (initContent) /tools/profiling/Controller.php:65 (initContent) /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`)	1.764 ms	2132			/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)
768	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 = IFNULL(`pa`.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 (1888) AND ag.`is_color_group` = 1 GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` HAVING qty > 0 ORDER BY a.`position` ASC;	1.676 ms	3712	Yes		/classes/Product.php:4289 /src/Adapter/Product/ProductColorsRetriever.php:43 (getAttributesColorList) /src/Adapter/Presenter/Product/ProductLazyArray.php:788 (getColoredVariants) /src/Adapter/Presenter/AbstractLazyArray.php:264 (getMainVariants) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/a8/a7/10/a8a710300f7cdde35120cbe16ad19050d30a1441_2.file.product.tpl.php:234 (offsetGet) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/a8/a7/10/a8a710300f7cdde35120cbe16ad19050d30a1441_2.file.product.tpl.php:338 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/a8/a7/10/a8a710300f7cdde35120cbe16ad19050d30a1441_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:156 (process) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/a8/a7/10/a8a710300f7cdde35120cbe16ad19050d30a1441_2.file.product.tpl.php:32 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_696d6ad326bb14_67715724) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:384 (render) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/3f/7d/0d/3f7d0dd85735416bd5b3ce10b4554f5fb578932d_2.file.productlist.tpl.php:39 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_696d6ad3253ca6_70171256) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/11/0a/74/110a7449c58ac8b5c663389783a92499ea1c7ebd_2.file.product-accessories.tpl.php:32 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_696d6ad324e7c8_52865461) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/b0/6c/17/b06c171e48c9d85ed0ff854f6229786cb32dbffe_2.file.product.tpl.php:490 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/b0/6c/17/b06c171e48c9d85ed0ff854f6229786cb32dbffe_2.file.product.tpl.php:687 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:186 (process) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/52/90/c3/5290c344b4d07ab96e07f0571e67dcd59554195b_2.file.layout-full-width.tpl.php:72 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/52/90/c3/5290c344b4d07ab96e07f0571e67dcd59554195b_2.file.layout-full-width.tpl.php:130 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:186 (process) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/14/fc/a5/14fca50b0aaf6d148e3756d711ec57c6a6a65aa6_2.file.layout-both-columns.tpl.php:85 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_696d69ac074786_63949425) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/52/90/c3/5290c344b4d07ab96e07f0571e67dcd59554195b_2.file.layout-full-width.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_696d69ac0682e0_59046668) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/b0/6c/17/b06c171e48c9d85ed0ff854f6229786cb32dbffe_2.file.product.tpl.php:54 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_696d6ad31782a6_74072138) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/Smarty/SmartyDev.php:40 (fetch) /classes/controller/FrontController.php:720 (fetch) /classes/controller/FrontController.php:704 (smartyOutputContent) /tools/profiling/Controller.php:111 (display) /tools/profiling/Controller.php:88 (displayProfiling) /classes/Dispatcher.php:488 (run) /index.php:86 (dispatch)
815	UPDATE `ps_page_viewed` SET `counter` = `counter` + 1 WHERE `id_date_range` = 1022102 AND `id_page` = 1157 AND `id_shop` = 1	1.659 ms	1			/classes/Page.php:131 /modules/statsdata/statsdata.php:121 (setPageViewed) /modules/statsdata/statsdata.php:74 (getScriptCustomerPagesViews) /classes/Hook.php:1237 (hookDisplayBeforeBodyClosingTag) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:454 (coreCallHook) /classes/Hook.php:1129 (callHookOn) /config/smarty.config.inc.php:213 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/14/fc/a5/14fca50b0aaf6d148e3756d711ec57c6a6a65aa6_2.file.layout-both-columns.tpl.php:430 (__call) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/14/fc/a5/14fca50b0aaf6d148e3756d711ec57c6a6a65aa6_2.file.layout-both-columns.tpl.php:111 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_696d69ac074786_63949425) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/52/90/c3/5290c344b4d07ab96e07f0571e67dcd59554195b_2.file.layout-full-width.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_696d69ac0682e0_59046668) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/b0/6c/17/b06c171e48c9d85ed0ff854f6229786cb32dbffe_2.file.product.tpl.php:54 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_696d6ad31782a6_74072138) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/Smarty/SmartyDev.php:40 (fetch) /classes/controller/FrontController.php:720 (fetch) /classes/controller/FrontController.php:704 (smartyOutputContent) /tools/profiling/Controller.php:111 (display) /tools/profiling/Controller.php:88 (displayProfiling) /classes/Dispatcher.php:488 (run) /index.php:86 (dispatch)
213	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-01-19 00:00:00", INTERVAL 180 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` = 1905 AND product_shop.`active` = 1 AND product_shop.`visibility` != 'none' GROUP BY product_shop.id_product ORDER BY pl.`name`	1.655 ms	25	Yes	Yes	/classes/Product.php:4479 /controllers/front/ProductController.php:380 (getAccessories) /tools/profiling/Controller.php:65 (initContent) /classes/Dispatcher.php:488 (run) /index.php:86 (dispatch)
651	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 = IFNULL(`pa`.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 (1868) AND ag.`is_color_group` = 1 GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` HAVING qty > 0 ORDER BY a.`position` ASC;	1.523 ms	2784	Yes		/classes/Product.php:4289 /src/Adapter/Product/ProductColorsRetriever.php:43 (getAttributesColorList) /src/Adapter/Presenter/Product/ProductLazyArray.php:788 (getColoredVariants) /src/Adapter/Presenter/AbstractLazyArray.php:264 (getMainVariants) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/a8/a7/10/a8a710300f7cdde35120cbe16ad19050d30a1441_2.file.product.tpl.php:234 (offsetGet) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/a8/a7/10/a8a710300f7cdde35120cbe16ad19050d30a1441_2.file.product.tpl.php:338 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/a8/a7/10/a8a710300f7cdde35120cbe16ad19050d30a1441_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:156 (process) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/a8/a7/10/a8a710300f7cdde35120cbe16ad19050d30a1441_2.file.product.tpl.php:32 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_696d6ad326bb14_67715724) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:384 (render) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/3f/7d/0d/3f7d0dd85735416bd5b3ce10b4554f5fb578932d_2.file.productlist.tpl.php:39 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_696d6ad3253ca6_70171256) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/11/0a/74/110a7449c58ac8b5c663389783a92499ea1c7ebd_2.file.product-accessories.tpl.php:32 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_696d6ad324e7c8_52865461) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/b0/6c/17/b06c171e48c9d85ed0ff854f6229786cb32dbffe_2.file.product.tpl.php:490 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/b0/6c/17/b06c171e48c9d85ed0ff854f6229786cb32dbffe_2.file.product.tpl.php:687 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:186 (process) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/52/90/c3/5290c344b4d07ab96e07f0571e67dcd59554195b_2.file.layout-full-width.tpl.php:72 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/52/90/c3/5290c344b4d07ab96e07f0571e67dcd59554195b_2.file.layout-full-width.tpl.php:130 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:186 (process) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/14/fc/a5/14fca50b0aaf6d148e3756d711ec57c6a6a65aa6_2.file.layout-both-columns.tpl.php:85 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_696d69ac074786_63949425) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/52/90/c3/5290c344b4d07ab96e07f0571e67dcd59554195b_2.file.layout-full-width.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_696d69ac0682e0_59046668) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/b0/6c/17/b06c171e48c9d85ed0ff854f6229786cb32dbffe_2.file.product.tpl.php:54 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_696d6ad31782a6_74072138) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/Smarty/SmartyDev.php:40 (fetch) /classes/controller/FrontController.php:720 (fetch) /classes/controller/FrontController.php:704 (smartyOutputContent) /tools/profiling/Controller.php:111 (display) /tools/profiling/Controller.php:88 (displayProfiling) /classes/Dispatcher.php:488 (run) /index.php:86 (dispatch)
759	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 = IFNULL(`pa`.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 (1898) AND ag.`is_color_group` = 1 GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` HAVING qty > 0 ORDER BY a.`position` ASC;	1.523 ms	3248	Yes		/classes/Product.php:4289 /src/Adapter/Product/ProductColorsRetriever.php:43 (getAttributesColorList) /src/Adapter/Presenter/Product/ProductLazyArray.php:788 (getColoredVariants) /src/Adapter/Presenter/AbstractLazyArray.php:264 (getMainVariants) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/a8/a7/10/a8a710300f7cdde35120cbe16ad19050d30a1441_2.file.product.tpl.php:234 (offsetGet) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/a8/a7/10/a8a710300f7cdde35120cbe16ad19050d30a1441_2.file.product.tpl.php:338 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/a8/a7/10/a8a710300f7cdde35120cbe16ad19050d30a1441_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:156 (process) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/a8/a7/10/a8a710300f7cdde35120cbe16ad19050d30a1441_2.file.product.tpl.php:32 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_696d6ad326bb14_67715724) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:384 (render) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/3f/7d/0d/3f7d0dd85735416bd5b3ce10b4554f5fb578932d_2.file.productlist.tpl.php:39 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_696d6ad3253ca6_70171256) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/11/0a/74/110a7449c58ac8b5c663389783a92499ea1c7ebd_2.file.product-accessories.tpl.php:32 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_696d6ad324e7c8_52865461) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/b0/6c/17/b06c171e48c9d85ed0ff854f6229786cb32dbffe_2.file.product.tpl.php:490 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/b0/6c/17/b06c171e48c9d85ed0ff854f6229786cb32dbffe_2.file.product.tpl.php:687 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:186 (process) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/52/90/c3/5290c344b4d07ab96e07f0571e67dcd59554195b_2.file.layout-full-width.tpl.php:72 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/52/90/c3/5290c344b4d07ab96e07f0571e67dcd59554195b_2.file.layout-full-width.tpl.php:130 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:186 (process) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/14/fc/a5/14fca50b0aaf6d148e3756d711ec57c6a6a65aa6_2.file.layout-both-columns.tpl.php:85 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_696d69ac074786_63949425) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/52/90/c3/5290c344b4d07ab96e07f0571e67dcd59554195b_2.file.layout-full-width.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_696d69ac0682e0_59046668) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/b0/6c/17/b06c171e48c9d85ed0ff854f6229786cb32dbffe_2.file.product.tpl.php:54 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_696d6ad31782a6_74072138) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/Smarty/SmartyDev.php:40 (fetch) /classes/controller/FrontController.php:720 (fetch) /classes/controller/FrontController.php:704 (smartyOutputContent) /tools/profiling/Controller.php:111 (display) /tools/profiling/Controller.php:88 (displayProfiling) /classes/Dispatcher.php:488 (run) /index.php:86 (dispatch)
673	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 = IFNULL(`pa`.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 (1354) AND ag.`is_color_group` = 1 GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` HAVING qty > 0 ORDER BY a.`position` ASC;	1.480 ms	3248	Yes		/classes/Product.php:4289 /src/Adapter/Product/ProductColorsRetriever.php:43 (getAttributesColorList) /src/Adapter/Presenter/Product/ProductLazyArray.php:788 (getColoredVariants) /src/Adapter/Presenter/AbstractLazyArray.php:264 (getMainVariants) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/a8/a7/10/a8a710300f7cdde35120cbe16ad19050d30a1441_2.file.product.tpl.php:234 (offsetGet) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/a8/a7/10/a8a710300f7cdde35120cbe16ad19050d30a1441_2.file.product.tpl.php:338 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/a8/a7/10/a8a710300f7cdde35120cbe16ad19050d30a1441_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:156 (process) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/a8/a7/10/a8a710300f7cdde35120cbe16ad19050d30a1441_2.file.product.tpl.php:32 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_696d6ad326bb14_67715724) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:384 (render) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/3f/7d/0d/3f7d0dd85735416bd5b3ce10b4554f5fb578932d_2.file.productlist.tpl.php:39 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_696d6ad3253ca6_70171256) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/11/0a/74/110a7449c58ac8b5c663389783a92499ea1c7ebd_2.file.product-accessories.tpl.php:32 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_696d6ad324e7c8_52865461) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/b0/6c/17/b06c171e48c9d85ed0ff854f6229786cb32dbffe_2.file.product.tpl.php:490 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/b0/6c/17/b06c171e48c9d85ed0ff854f6229786cb32dbffe_2.file.product.tpl.php:687 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:186 (process) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/52/90/c3/5290c344b4d07ab96e07f0571e67dcd59554195b_2.file.layout-full-width.tpl.php:72 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/52/90/c3/5290c344b4d07ab96e07f0571e67dcd59554195b_2.file.layout-full-width.tpl.php:130 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:186 (process) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/14/fc/a5/14fca50b0aaf6d148e3756d711ec57c6a6a65aa6_2.file.layout-both-columns.tpl.php:85 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_696d69ac074786_63949425) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/52/90/c3/5290c344b4d07ab96e07f0571e67dcd59554195b_2.file.layout-full-width.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_696d69ac0682e0_59046668) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/b0/6c/17/b06c171e48c9d85ed0ff854f6229786cb32dbffe_2.file.product.tpl.php:54 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_696d6ad31782a6_74072138) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/Smarty/SmartyDev.php:40 (fetch) /classes/controller/FrontController.php:720 (fetch) /classes/controller/FrontController.php:704 (smartyOutputContent) /tools/profiling/Controller.php:111 (display) /tools/profiling/Controller.php:88 (displayProfiling) /classes/Dispatcher.php:488 (run) /index.php:86 (dispatch)
750	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 = IFNULL(`pa`.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 (1893) AND ag.`is_color_group` = 1 GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` HAVING qty > 0 ORDER BY a.`position` ASC;	1.476 ms	3248	Yes		/classes/Product.php:4289 /src/Adapter/Product/ProductColorsRetriever.php:43 (getAttributesColorList) /src/Adapter/Presenter/Product/ProductLazyArray.php:788 (getColoredVariants) /src/Adapter/Presenter/AbstractLazyArray.php:264 (getMainVariants) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/a8/a7/10/a8a710300f7cdde35120cbe16ad19050d30a1441_2.file.product.tpl.php:234 (offsetGet) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/a8/a7/10/a8a710300f7cdde35120cbe16ad19050d30a1441_2.file.product.tpl.php:338 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/a8/a7/10/a8a710300f7cdde35120cbe16ad19050d30a1441_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:156 (process) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/a8/a7/10/a8a710300f7cdde35120cbe16ad19050d30a1441_2.file.product.tpl.php:32 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_696d6ad326bb14_67715724) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:384 (render) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/3f/7d/0d/3f7d0dd85735416bd5b3ce10b4554f5fb578932d_2.file.productlist.tpl.php:39 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_696d6ad3253ca6_70171256) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/11/0a/74/110a7449c58ac8b5c663389783a92499ea1c7ebd_2.file.product-accessories.tpl.php:32 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_696d6ad324e7c8_52865461) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/b0/6c/17/b06c171e48c9d85ed0ff854f6229786cb32dbffe_2.file.product.tpl.php:490 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/b0/6c/17/b06c171e48c9d85ed0ff854f6229786cb32dbffe_2.file.product.tpl.php:687 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:186 (process) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/52/90/c3/5290c344b4d07ab96e07f0571e67dcd59554195b_2.file.layout-full-width.tpl.php:72 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/52/90/c3/5290c344b4d07ab96e07f0571e67dcd59554195b_2.file.layout-full-width.tpl.php:130 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:186 (process) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/14/fc/a5/14fca50b0aaf6d148e3756d711ec57c6a6a65aa6_2.file.layout-both-columns.tpl.php:85 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_696d69ac074786_63949425) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/52/90/c3/5290c344b4d07ab96e07f0571e67dcd59554195b_2.file.layout-full-width.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_696d69ac0682e0_59046668) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/b0/6c/17/b06c171e48c9d85ed0ff854f6229786cb32dbffe_2.file.product.tpl.php:54 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_696d6ad31782a6_74072138) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/Smarty/SmartyDev.php:40 (fetch) /classes/controller/FrontController.php:720 (fetch) /classes/controller/FrontController.php:704 (smartyOutputContent) /tools/profiling/Controller.php:111 (display) /tools/profiling/Controller.php:88 (displayProfiling) /classes/Dispatcher.php:488 (run) /index.php:86 (dispatch)
713	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 = IFNULL(`pa`.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 (1911) AND ag.`is_color_group` = 1 GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` HAVING qty > 0 ORDER BY a.`position` ASC;	1.463 ms	4176	Yes		/classes/Product.php:4289 /src/Adapter/Product/ProductColorsRetriever.php:43 (getAttributesColorList) /src/Adapter/Presenter/Product/ProductLazyArray.php:788 (getColoredVariants) /src/Adapter/Presenter/AbstractLazyArray.php:264 (getMainVariants) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/a8/a7/10/a8a710300f7cdde35120cbe16ad19050d30a1441_2.file.product.tpl.php:234 (offsetGet) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/a8/a7/10/a8a710300f7cdde35120cbe16ad19050d30a1441_2.file.product.tpl.php:338 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/a8/a7/10/a8a710300f7cdde35120cbe16ad19050d30a1441_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:156 (process) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/a8/a7/10/a8a710300f7cdde35120cbe16ad19050d30a1441_2.file.product.tpl.php:32 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_696d6ad326bb14_67715724) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:384 (render) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/3f/7d/0d/3f7d0dd85735416bd5b3ce10b4554f5fb578932d_2.file.productlist.tpl.php:39 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_696d6ad3253ca6_70171256) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/11/0a/74/110a7449c58ac8b5c663389783a92499ea1c7ebd_2.file.product-accessories.tpl.php:32 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_696d6ad324e7c8_52865461) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/b0/6c/17/b06c171e48c9d85ed0ff854f6229786cb32dbffe_2.file.product.tpl.php:490 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/b0/6c/17/b06c171e48c9d85ed0ff854f6229786cb32dbffe_2.file.product.tpl.php:687 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:186 (process) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/52/90/c3/5290c344b4d07ab96e07f0571e67dcd59554195b_2.file.layout-full-width.tpl.php:72 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/52/90/c3/5290c344b4d07ab96e07f0571e67dcd59554195b_2.file.layout-full-width.tpl.php:130 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:186 (process) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/14/fc/a5/14fca50b0aaf6d148e3756d711ec57c6a6a65aa6_2.file.layout-both-columns.tpl.php:85 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_696d69ac074786_63949425) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/52/90/c3/5290c344b4d07ab96e07f0571e67dcd59554195b_2.file.layout-full-width.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_696d69ac0682e0_59046668) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/b0/6c/17/b06c171e48c9d85ed0ff854f6229786cb32dbffe_2.file.product.tpl.php:54 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_696d6ad31782a6_74072138) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/Smarty/SmartyDev.php:40 (fetch) /classes/controller/FrontController.php:720 (fetch) /classes/controller/FrontController.php:704 (smartyOutputContent) /tools/profiling/Controller.php:111 (display) /tools/profiling/Controller.php:88 (displayProfiling) /classes/Dispatcher.php:488 (run) /index.php:86 (dispatch)
665	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 = IFNULL(`pa`.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 (1353) AND ag.`is_color_group` = 1 GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` HAVING qty > 0 ORDER BY a.`position` ASC;	1.459 ms	3248	Yes		/classes/Product.php:4289 /src/Adapter/Product/ProductColorsRetriever.php:43 (getAttributesColorList) /src/Adapter/Presenter/Product/ProductLazyArray.php:788 (getColoredVariants) /src/Adapter/Presenter/AbstractLazyArray.php:264 (getMainVariants) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/a8/a7/10/a8a710300f7cdde35120cbe16ad19050d30a1441_2.file.product.tpl.php:234 (offsetGet) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/a8/a7/10/a8a710300f7cdde35120cbe16ad19050d30a1441_2.file.product.tpl.php:338 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/a8/a7/10/a8a710300f7cdde35120cbe16ad19050d30a1441_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:156 (process) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/a8/a7/10/a8a710300f7cdde35120cbe16ad19050d30a1441_2.file.product.tpl.php:32 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_696d6ad326bb14_67715724) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:384 (render) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/3f/7d/0d/3f7d0dd85735416bd5b3ce10b4554f5fb578932d_2.file.productlist.tpl.php:39 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_696d6ad3253ca6_70171256) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/11/0a/74/110a7449c58ac8b5c663389783a92499ea1c7ebd_2.file.product-accessories.tpl.php:32 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_696d6ad324e7c8_52865461) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/b0/6c/17/b06c171e48c9d85ed0ff854f6229786cb32dbffe_2.file.product.tpl.php:490 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/b0/6c/17/b06c171e48c9d85ed0ff854f6229786cb32dbffe_2.file.product.tpl.php:687 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:186 (process) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/52/90/c3/5290c344b4d07ab96e07f0571e67dcd59554195b_2.file.layout-full-width.tpl.php:72 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/52/90/c3/5290c344b4d07ab96e07f0571e67dcd59554195b_2.file.layout-full-width.tpl.php:130 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:186 (process) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/14/fc/a5/14fca50b0aaf6d148e3756d711ec57c6a6a65aa6_2.file.layout-both-columns.tpl.php:85 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_696d69ac074786_63949425) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/52/90/c3/5290c344b4d07ab96e07f0571e67dcd59554195b_2.file.layout-full-width.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_696d69ac0682e0_59046668) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/b0/6c/17/b06c171e48c9d85ed0ff854f6229786cb32dbffe_2.file.product.tpl.php:54 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_696d6ad31782a6_74072138) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/Smarty/SmartyDev.php:40 (fetch) /classes/controller/FrontController.php:720 (fetch) /classes/controller/FrontController.php:704 (smartyOutputContent) /tools/profiling/Controller.php:111 (display) /tools/profiling/Controller.php:88 (displayProfiling) /classes/Dispatcher.php:488 (run) /index.php:86 (dispatch)
705	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 = IFNULL(`pa`.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 (1907) AND ag.`is_color_group` = 1 GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` HAVING qty > 0 ORDER BY a.`position` ASC;	1.435 ms	4176	Yes		/classes/Product.php:4289 /src/Adapter/Product/ProductColorsRetriever.php:43 (getAttributesColorList) /src/Adapter/Presenter/Product/ProductLazyArray.php:788 (getColoredVariants) /src/Adapter/Presenter/AbstractLazyArray.php:264 (getMainVariants) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/a8/a7/10/a8a710300f7cdde35120cbe16ad19050d30a1441_2.file.product.tpl.php:234 (offsetGet) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/a8/a7/10/a8a710300f7cdde35120cbe16ad19050d30a1441_2.file.product.tpl.php:338 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/a8/a7/10/a8a710300f7cdde35120cbe16ad19050d30a1441_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:156 (process) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/a8/a7/10/a8a710300f7cdde35120cbe16ad19050d30a1441_2.file.product.tpl.php:32 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_696d6ad326bb14_67715724) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:384 (render) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/3f/7d/0d/3f7d0dd85735416bd5b3ce10b4554f5fb578932d_2.file.productlist.tpl.php:39 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_696d6ad3253ca6_70171256) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/11/0a/74/110a7449c58ac8b5c663389783a92499ea1c7ebd_2.file.product-accessories.tpl.php:32 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_696d6ad324e7c8_52865461) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/b0/6c/17/b06c171e48c9d85ed0ff854f6229786cb32dbffe_2.file.product.tpl.php:490 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/b0/6c/17/b06c171e48c9d85ed0ff854f6229786cb32dbffe_2.file.product.tpl.php:687 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:186 (process) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/52/90/c3/5290c344b4d07ab96e07f0571e67dcd59554195b_2.file.layout-full-width.tpl.php:72 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/52/90/c3/5290c344b4d07ab96e07f0571e67dcd59554195b_2.file.layout-full-width.tpl.php:130 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:186 (process) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/14/fc/a5/14fca50b0aaf6d148e3756d711ec57c6a6a65aa6_2.file.layout-both-columns.tpl.php:85 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_696d69ac074786_63949425) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/52/90/c3/5290c344b4d07ab96e07f0571e67dcd59554195b_2.file.layout-full-width.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_696d69ac0682e0_59046668) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/b0/6c/17/b06c171e48c9d85ed0ff854f6229786cb32dbffe_2.file.product.tpl.php:54 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_696d6ad31782a6_74072138) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/Smarty/SmartyDev.php:40 (fetch) /classes/controller/FrontController.php:720 (fetch) /classes/controller/FrontController.php:704 (smartyOutputContent) /tools/profiling/Controller.php:111 (display) /tools/profiling/Controller.php:88 (displayProfiling) /classes/Dispatcher.php:488 (run) /index.php:86 (dispatch)
689	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 = IFNULL(`pa`.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 (1913) AND ag.`is_color_group` = 1 GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` HAVING qty > 0 ORDER BY a.`position` ASC;	1.431 ms	4176	Yes		/classes/Product.php:4289 /src/Adapter/Product/ProductColorsRetriever.php:43 (getAttributesColorList) /src/Adapter/Presenter/Product/ProductLazyArray.php:788 (getColoredVariants) /src/Adapter/Presenter/AbstractLazyArray.php:264 (getMainVariants) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/a8/a7/10/a8a710300f7cdde35120cbe16ad19050d30a1441_2.file.product.tpl.php:234 (offsetGet) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/a8/a7/10/a8a710300f7cdde35120cbe16ad19050d30a1441_2.file.product.tpl.php:338 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/a8/a7/10/a8a710300f7cdde35120cbe16ad19050d30a1441_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:156 (process) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/a8/a7/10/a8a710300f7cdde35120cbe16ad19050d30a1441_2.file.product.tpl.php:32 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_696d6ad326bb14_67715724) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:384 (render) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/3f/7d/0d/3f7d0dd85735416bd5b3ce10b4554f5fb578932d_2.file.productlist.tpl.php:39 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_696d6ad3253ca6_70171256) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/11/0a/74/110a7449c58ac8b5c663389783a92499ea1c7ebd_2.file.product-accessories.tpl.php:32 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_696d6ad324e7c8_52865461) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/b0/6c/17/b06c171e48c9d85ed0ff854f6229786cb32dbffe_2.file.product.tpl.php:490 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/b0/6c/17/b06c171e48c9d85ed0ff854f6229786cb32dbffe_2.file.product.tpl.php:687 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:186 (process) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/52/90/c3/5290c344b4d07ab96e07f0571e67dcd59554195b_2.file.layout-full-width.tpl.php:72 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/52/90/c3/5290c344b4d07ab96e07f0571e67dcd59554195b_2.file.layout-full-width.tpl.php:130 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:186 (process) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/14/fc/a5/14fca50b0aaf6d148e3756d711ec57c6a6a65aa6_2.file.layout-both-columns.tpl.php:85 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_696d69ac074786_63949425) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/52/90/c3/5290c344b4d07ab96e07f0571e67dcd59554195b_2.file.layout-full-width.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_696d69ac0682e0_59046668) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/b0/6c/17/b06c171e48c9d85ed0ff854f6229786cb32dbffe_2.file.product.tpl.php:54 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_696d6ad31782a6_74072138) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/Smarty/SmartyDev.php:40 (fetch) /classes/controller/FrontController.php:720 (fetch) /classes/controller/FrontController.php:704 (smartyOutputContent) /tools/profiling/Controller.php:111 (display) /tools/profiling/Controller.php:88 (displayProfiling) /classes/Dispatcher.php:488 (run) /index.php:86 (dispatch)
642	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 = IFNULL(`pa`.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 (1883) AND ag.`is_color_group` = 1 GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` HAVING qty > 0 ORDER BY a.`position` ASC;	1.426 ms	2784	Yes		/classes/Product.php:4289 /src/Adapter/Product/ProductColorsRetriever.php:43 (getAttributesColorList) /src/Adapter/Presenter/Product/ProductLazyArray.php:788 (getColoredVariants) /src/Adapter/Presenter/AbstractLazyArray.php:264 (getMainVariants) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/a8/a7/10/a8a710300f7cdde35120cbe16ad19050d30a1441_2.file.product.tpl.php:234 (offsetGet) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/a8/a7/10/a8a710300f7cdde35120cbe16ad19050d30a1441_2.file.product.tpl.php:338 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/a8/a7/10/a8a710300f7cdde35120cbe16ad19050d30a1441_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:156 (process) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/a8/a7/10/a8a710300f7cdde35120cbe16ad19050d30a1441_2.file.product.tpl.php:32 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_696d6ad326bb14_67715724) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:384 (render) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/3f/7d/0d/3f7d0dd85735416bd5b3ce10b4554f5fb578932d_2.file.productlist.tpl.php:39 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_696d6ad3253ca6_70171256) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/11/0a/74/110a7449c58ac8b5c663389783a92499ea1c7ebd_2.file.product-accessories.tpl.php:32 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_696d6ad324e7c8_52865461) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/b0/6c/17/b06c171e48c9d85ed0ff854f6229786cb32dbffe_2.file.product.tpl.php:490 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/b0/6c/17/b06c171e48c9d85ed0ff854f6229786cb32dbffe_2.file.product.tpl.php:687 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:186 (process) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/52/90/c3/5290c344b4d07ab96e07f0571e67dcd59554195b_2.file.layout-full-width.tpl.php:72 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/52/90/c3/5290c344b4d07ab96e07f0571e67dcd59554195b_2.file.layout-full-width.tpl.php:130 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:186 (process) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/14/fc/a5/14fca50b0aaf6d148e3756d711ec57c6a6a65aa6_2.file.layout-both-columns.tpl.php:85 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_696d69ac074786_63949425) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/52/90/c3/5290c344b4d07ab96e07f0571e67dcd59554195b_2.file.layout-full-width.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_696d69ac0682e0_59046668) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/b0/6c/17/b06c171e48c9d85ed0ff854f6229786cb32dbffe_2.file.product.tpl.php:54 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_696d6ad31782a6_74072138) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/Smarty/SmartyDev.php:40 (fetch) /classes/controller/FrontController.php:720 (fetch) /classes/controller/FrontController.php:704 (smartyOutputContent) /tools/profiling/Controller.php:111 (display) /tools/profiling/Controller.php:88 (displayProfiling) /classes/Dispatcher.php:488 (run) /index.php:86 (dispatch)
697	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 = IFNULL(`pa`.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 (1909) AND ag.`is_color_group` = 1 GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` HAVING qty > 0 ORDER BY a.`position` ASC;	1.423 ms	4176	Yes		/classes/Product.php:4289 /src/Adapter/Product/ProductColorsRetriever.php:43 (getAttributesColorList) /src/Adapter/Presenter/Product/ProductLazyArray.php:788 (getColoredVariants) /src/Adapter/Presenter/AbstractLazyArray.php:264 (getMainVariants) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/a8/a7/10/a8a710300f7cdde35120cbe16ad19050d30a1441_2.file.product.tpl.php:234 (offsetGet) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/a8/a7/10/a8a710300f7cdde35120cbe16ad19050d30a1441_2.file.product.tpl.php:338 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/a8/a7/10/a8a710300f7cdde35120cbe16ad19050d30a1441_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:156 (process) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/a8/a7/10/a8a710300f7cdde35120cbe16ad19050d30a1441_2.file.product.tpl.php:32 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_696d6ad326bb14_67715724) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:384 (render) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/3f/7d/0d/3f7d0dd85735416bd5b3ce10b4554f5fb578932d_2.file.productlist.tpl.php:39 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_696d6ad3253ca6_70171256) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/11/0a/74/110a7449c58ac8b5c663389783a92499ea1c7ebd_2.file.product-accessories.tpl.php:32 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_696d6ad324e7c8_52865461) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/b0/6c/17/b06c171e48c9d85ed0ff854f6229786cb32dbffe_2.file.product.tpl.php:490 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/b0/6c/17/b06c171e48c9d85ed0ff854f6229786cb32dbffe_2.file.product.tpl.php:687 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:186 (process) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/52/90/c3/5290c344b4d07ab96e07f0571e67dcd59554195b_2.file.layout-full-width.tpl.php:72 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/52/90/c3/5290c344b4d07ab96e07f0571e67dcd59554195b_2.file.layout-full-width.tpl.php:130 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:186 (process) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/14/fc/a5/14fca50b0aaf6d148e3756d711ec57c6a6a65aa6_2.file.layout-both-columns.tpl.php:85 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_696d69ac074786_63949425) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/52/90/c3/5290c344b4d07ab96e07f0571e67dcd59554195b_2.file.layout-full-width.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_696d69ac0682e0_59046668) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/b0/6c/17/b06c171e48c9d85ed0ff854f6229786cb32dbffe_2.file.product.tpl.php:54 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_696d6ad31782a6_74072138) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/Smarty/SmartyDev.php:40 (fetch) /classes/controller/FrontController.php:720 (fetch) /classes/controller/FrontController.php:704 (smartyOutputContent) /tools/profiling/Controller.php:111 (display) /tools/profiling/Controller.php:88 (displayProfiling) /classes/Dispatcher.php:488 (run) /index.php:86 (dispatch)
681	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 = IFNULL(`pa`.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 (1903) AND ag.`is_color_group` = 1 GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` HAVING qty > 0 ORDER BY a.`position` ASC;	1.415 ms	4176	Yes		/classes/Product.php:4289 /src/Adapter/Product/ProductColorsRetriever.php:43 (getAttributesColorList) /src/Adapter/Presenter/Product/ProductLazyArray.php:788 (getColoredVariants) /src/Adapter/Presenter/AbstractLazyArray.php:264 (getMainVariants) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/a8/a7/10/a8a710300f7cdde35120cbe16ad19050d30a1441_2.file.product.tpl.php:234 (offsetGet) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/a8/a7/10/a8a710300f7cdde35120cbe16ad19050d30a1441_2.file.product.tpl.php:338 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/a8/a7/10/a8a710300f7cdde35120cbe16ad19050d30a1441_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:156 (process) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/a8/a7/10/a8a710300f7cdde35120cbe16ad19050d30a1441_2.file.product.tpl.php:32 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_696d6ad326bb14_67715724) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:384 (render) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/3f/7d/0d/3f7d0dd85735416bd5b3ce10b4554f5fb578932d_2.file.productlist.tpl.php:39 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_696d6ad3253ca6_70171256) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/11/0a/74/110a7449c58ac8b5c663389783a92499ea1c7ebd_2.file.product-accessories.tpl.php:32 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_696d6ad324e7c8_52865461) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/b0/6c/17/b06c171e48c9d85ed0ff854f6229786cb32dbffe_2.file.product.tpl.php:490 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/b0/6c/17/b06c171e48c9d85ed0ff854f6229786cb32dbffe_2.file.product.tpl.php:687 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:186 (process) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/52/90/c3/5290c344b4d07ab96e07f0571e67dcd59554195b_2.file.layout-full-width.tpl.php:72 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/52/90/c3/5290c344b4d07ab96e07f0571e67dcd59554195b_2.file.layout-full-width.tpl.php:130 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:186 (process) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/14/fc/a5/14fca50b0aaf6d148e3756d711ec57c6a6a65aa6_2.file.layout-both-columns.tpl.php:85 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_696d69ac074786_63949425) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/52/90/c3/5290c344b4d07ab96e07f0571e67dcd59554195b_2.file.layout-full-width.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_696d69ac0682e0_59046668) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/b0/6c/17/b06c171e48c9d85ed0ff854f6229786cb32dbffe_2.file.product.tpl.php:54 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_696d6ad31782a6_74072138) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/Smarty/SmartyDev.php:40 (fetch) /classes/controller/FrontController.php:720 (fetch) /classes/controller/FrontController.php:704 (smartyOutputContent) /tools/profiling/Controller.php:111 (display) /tools/profiling/Controller.php:88 (displayProfiling) /classes/Dispatcher.php:488 (run) /index.php:86 (dispatch)
81	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.382 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:6567 (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)
199	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` = 1905	1.330 ms	144			/classes/Product.php:7232 /controllers/front/ProductController.php:829 (getAttributesInformationsByProduct) /controllers/front/ProductController.php:330 (assignAttributesCombinations) /tools/profiling/Controller.php:65 (initContent) /classes/Dispatcher.php:488 (run) /index.php:86 (dispatch)
16	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.207 ms	3548	Yes	Yes	/classes/Hook.php:1500 /classes/Hook.php:810 (getAllHookRegistrations) /classes/Hook.php:952 (getHookModuleExecList) /classes/Dispatcher.php:588 (exec) /classes/Dispatcher.php:253 (loadRoutes) /classes/Dispatcher.php:215 (__construct) /index.php:86 (getInstance)
283	SELECT SQL_NO_CACHE p., ps., pl.*, sa.out_of_stock, IFNULL(sa.quantity, 0) as quantity, (DATEDIFF( p.`date_add`, DATE_SUB( '2026-01-19 00:00:00', INTERVAL 180 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 (1830,1883,1868,1835,1353,1354,1903,1913,1909,1907,1911,1862,1849,1821,1817,1893,1898,1888,1873,1806,1808,1840,1878)	1.047 ms	23			/classes/ProductAssembler.php:101 /classes/ProductAssembler.php:211 (addMissingProductFieldsForMultipleProducts) /controllers/front/ProductController.php:382 (assembleProducts) /tools/profiling/Controller.php:65 (initContent) /classes/Dispatcher.php:488 (run) /index.php:86 (dispatch)
637	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 = IFNULL(`pa`.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 (1830) 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.900 ms	1160	Yes		/classes/Product.php:4289 /src/Adapter/Product/ProductColorsRetriever.php:43 (getAttributesColorList) /src/Adapter/Presenter/Product/ProductLazyArray.php:788 (getColoredVariants) /src/Adapter/Presenter/AbstractLazyArray.php:264 (getMainVariants) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/a8/a7/10/a8a710300f7cdde35120cbe16ad19050d30a1441_2.file.product.tpl.php:234 (offsetGet) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/a8/a7/10/a8a710300f7cdde35120cbe16ad19050d30a1441_2.file.product.tpl.php:338 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/a8/a7/10/a8a710300f7cdde35120cbe16ad19050d30a1441_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:156 (process) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/a8/a7/10/a8a710300f7cdde35120cbe16ad19050d30a1441_2.file.product.tpl.php:32 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_696d6ad326bb14_67715724) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/3f/7d/0d/3f7d0dd85735416bd5b3ce10b4554f5fb578932d_2.file.productlist.tpl.php:39 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_696d6ad3253ca6_70171256) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/11/0a/74/110a7449c58ac8b5c663389783a92499ea1c7ebd_2.file.product-accessories.tpl.php:32 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_696d6ad324e7c8_52865461) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/b0/6c/17/b06c171e48c9d85ed0ff854f6229786cb32dbffe_2.file.product.tpl.php:490 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/b0/6c/17/b06c171e48c9d85ed0ff854f6229786cb32dbffe_2.file.product.tpl.php:687 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:186 (process) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/52/90/c3/5290c344b4d07ab96e07f0571e67dcd59554195b_2.file.layout-full-width.tpl.php:72 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/52/90/c3/5290c344b4d07ab96e07f0571e67dcd59554195b_2.file.layout-full-width.tpl.php:130 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:186 (process) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/14/fc/a5/14fca50b0aaf6d148e3756d711ec57c6a6a65aa6_2.file.layout-both-columns.tpl.php:85 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_696d69ac074786_63949425) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/52/90/c3/5290c344b4d07ab96e07f0571e67dcd59554195b_2.file.layout-full-width.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_696d69ac0682e0_59046668) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/b0/6c/17/b06c171e48c9d85ed0ff854f6229786cb32dbffe_2.file.product.tpl.php:54 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_696d6ad31782a6_74072138) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/Smarty/SmartyDev.php:40 (fetch) /classes/controller/FrontController.php:720 (fetch) /classes/controller/FrontController.php:704 (smartyOutputContent) /tools/profiling/Controller.php:111 (display) /tools/profiling/Controller.php:88 (displayProfiling) /classes/Dispatcher.php:488 (run) /index.php:86 (dispatch)
82	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.893 ms	344			/classes/Hook.php:507 /classes/Hook.php:542 (getHookModuleList) /classes/tax/TaxManagerFactory.php:63 (getModulesFromHook) /classes/tax/TaxManagerFactory.php:42 (execHookTaxManagerFactory) /classes/Product.php:6567 (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)
790	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 = IFNULL(`pa`.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 (1840) 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.892 ms	1450	Yes		/classes/Product.php:4289 /src/Adapter/Product/ProductColorsRetriever.php:43 (getAttributesColorList) /src/Adapter/Presenter/Product/ProductLazyArray.php:788 (getColoredVariants) /src/Adapter/Presenter/AbstractLazyArray.php:264 (getMainVariants) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/a8/a7/10/a8a710300f7cdde35120cbe16ad19050d30a1441_2.file.product.tpl.php:234 (offsetGet) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/a8/a7/10/a8a710300f7cdde35120cbe16ad19050d30a1441_2.file.product.tpl.php:338 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/a8/a7/10/a8a710300f7cdde35120cbe16ad19050d30a1441_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:156 (process) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/a8/a7/10/a8a710300f7cdde35120cbe16ad19050d30a1441_2.file.product.tpl.php:32 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_696d6ad326bb14_67715724) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:384 (render) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/3f/7d/0d/3f7d0dd85735416bd5b3ce10b4554f5fb578932d_2.file.productlist.tpl.php:39 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_696d6ad3253ca6_70171256) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/11/0a/74/110a7449c58ac8b5c663389783a92499ea1c7ebd_2.file.product-accessories.tpl.php:32 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_696d6ad324e7c8_52865461) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/b0/6c/17/b06c171e48c9d85ed0ff854f6229786cb32dbffe_2.file.product.tpl.php:490 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/b0/6c/17/b06c171e48c9d85ed0ff854f6229786cb32dbffe_2.file.product.tpl.php:687 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:186 (process) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/52/90/c3/5290c344b4d07ab96e07f0571e67dcd59554195b_2.file.layout-full-width.tpl.php:72 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/52/90/c3/5290c344b4d07ab96e07f0571e67dcd59554195b_2.file.layout-full-width.tpl.php:130 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:186 (process) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/14/fc/a5/14fca50b0aaf6d148e3756d711ec57c6a6a65aa6_2.file.layout-both-columns.tpl.php:85 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_696d69ac074786_63949425) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/52/90/c3/5290c344b4d07ab96e07f0571e67dcd59554195b_2.file.layout-full-width.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_696d69ac0682e0_59046668) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/b0/6c/17/b06c171e48c9d85ed0ff854f6229786cb32dbffe_2.file.product.tpl.php:54 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_696d6ad31782a6_74072138) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/Smarty/SmartyDev.php:40 (fetch) /classes/controller/FrontController.php:720 (fetch) /classes/controller/FrontController.php:704 (smartyOutputContent) /tools/profiling/Controller.php:111 (display) /tools/profiling/Controller.php:88 (displayProfiling) /classes/Dispatcher.php:488 (run) /index.php:86 (dispatch)
795	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 = IFNULL(`pa`.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 (1878) 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.840 ms	1160	Yes		/classes/Product.php:4289 /src/Adapter/Product/ProductColorsRetriever.php:43 (getAttributesColorList) /src/Adapter/Presenter/Product/ProductLazyArray.php:788 (getColoredVariants) /src/Adapter/Presenter/AbstractLazyArray.php:264 (getMainVariants) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/a8/a7/10/a8a710300f7cdde35120cbe16ad19050d30a1441_2.file.product.tpl.php:234 (offsetGet) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/a8/a7/10/a8a710300f7cdde35120cbe16ad19050d30a1441_2.file.product.tpl.php:338 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/a8/a7/10/a8a710300f7cdde35120cbe16ad19050d30a1441_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:156 (process) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/a8/a7/10/a8a710300f7cdde35120cbe16ad19050d30a1441_2.file.product.tpl.php:32 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_696d6ad326bb14_67715724) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:384 (render) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/3f/7d/0d/3f7d0dd85735416bd5b3ce10b4554f5fb578932d_2.file.productlist.tpl.php:39 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_696d6ad3253ca6_70171256) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/11/0a/74/110a7449c58ac8b5c663389783a92499ea1c7ebd_2.file.product-accessories.tpl.php:32 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_696d6ad324e7c8_52865461) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/b0/6c/17/b06c171e48c9d85ed0ff854f6229786cb32dbffe_2.file.product.tpl.php:490 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/b0/6c/17/b06c171e48c9d85ed0ff854f6229786cb32dbffe_2.file.product.tpl.php:687 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:186 (process) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/52/90/c3/5290c344b4d07ab96e07f0571e67dcd59554195b_2.file.layout-full-width.tpl.php:72 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/52/90/c3/5290c344b4d07ab96e07f0571e67dcd59554195b_2.file.layout-full-width.tpl.php:130 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:186 (process) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/14/fc/a5/14fca50b0aaf6d148e3756d711ec57c6a6a65aa6_2.file.layout-both-columns.tpl.php:85 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_696d69ac074786_63949425) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/52/90/c3/5290c344b4d07ab96e07f0571e67dcd59554195b_2.file.layout-full-width.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_696d69ac0682e0_59046668) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/b0/6c/17/b06c171e48c9d85ed0ff854f6229786cb32dbffe_2.file.product.tpl.php:54 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_696d6ad31782a6_74072138) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/Smarty/SmartyDev.php:40 (fetch) /classes/controller/FrontController.php:720 (fetch) /classes/controller/FrontController.php:704 (smartyOutputContent) /tools/profiling/Controller.php:111 (display) /tools/profiling/Controller.php:88 (displayProfiling) /classes/Dispatcher.php:488 (run) /index.php:86 (dispatch)
777	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 = IFNULL(`pa`.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 (1873) 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.829 ms	1160	Yes		/classes/Product.php:4289 /src/Adapter/Product/ProductColorsRetriever.php:43 (getAttributesColorList) /src/Adapter/Presenter/Product/ProductLazyArray.php:788 (getColoredVariants) /src/Adapter/Presenter/AbstractLazyArray.php:264 (getMainVariants) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/a8/a7/10/a8a710300f7cdde35120cbe16ad19050d30a1441_2.file.product.tpl.php:234 (offsetGet) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/a8/a7/10/a8a710300f7cdde35120cbe16ad19050d30a1441_2.file.product.tpl.php:338 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/a8/a7/10/a8a710300f7cdde35120cbe16ad19050d30a1441_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:156 (process) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/a8/a7/10/a8a710300f7cdde35120cbe16ad19050d30a1441_2.file.product.tpl.php:32 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_696d6ad326bb14_67715724) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:384 (render) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/3f/7d/0d/3f7d0dd85735416bd5b3ce10b4554f5fb578932d_2.file.productlist.tpl.php:39 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_696d6ad3253ca6_70171256) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/11/0a/74/110a7449c58ac8b5c663389783a92499ea1c7ebd_2.file.product-accessories.tpl.php:32 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_696d6ad324e7c8_52865461) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/b0/6c/17/b06c171e48c9d85ed0ff854f6229786cb32dbffe_2.file.product.tpl.php:490 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/b0/6c/17/b06c171e48c9d85ed0ff854f6229786cb32dbffe_2.file.product.tpl.php:687 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:186 (process) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/52/90/c3/5290c344b4d07ab96e07f0571e67dcd59554195b_2.file.layout-full-width.tpl.php:72 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/52/90/c3/5290c344b4d07ab96e07f0571e67dcd59554195b_2.file.layout-full-width.tpl.php:130 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:186 (process) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/14/fc/a5/14fca50b0aaf6d148e3756d711ec57c6a6a65aa6_2.file.layout-both-columns.tpl.php:85 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_696d69ac074786_63949425) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/52/90/c3/5290c344b4d07ab96e07f0571e67dcd59554195b_2.file.layout-full-width.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_696d69ac0682e0_59046668) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/b0/6c/17/b06c171e48c9d85ed0ff854f6229786cb32dbffe_2.file.product.tpl.php:54 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_696d6ad31782a6_74072138) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/Smarty/SmartyDev.php:40 (fetch) /classes/controller/FrontController.php:720 (fetch) /classes/controller/FrontController.php:704 (smartyOutputContent) /tools/profiling/Controller.php:111 (display) /tools/profiling/Controller.php:88 (displayProfiling) /classes/Dispatcher.php:488 (run) /index.php:86 (dispatch)
424	SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`, IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on, product_attribute_shop.`ecotax` AS attribute_ecotax FROM `ps_product` p INNER JOIN `ps_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1) LEFT JOIN `ps_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1) WHERE (p.`id_product` = 1817)	0.812 ms	432			/classes/Product.php:3603 /classes/Product.php:3460 (priceCalculation) /classes/Product.php:5454 (getPriceStatic) /classes/ProductAssembler.php:217 (getProductProperties) /controllers/front/ProductController.php:382 (assembleProducts) /tools/profiling/Controller.php:65 (initContent) /classes/Dispatcher.php:488 (run) /index.php:86 (dispatch)
660	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 = IFNULL(`pa`.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 (1835) 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.787 ms	1160	Yes		/classes/Product.php:4289 /src/Adapter/Product/ProductColorsRetriever.php:43 (getAttributesColorList) /src/Adapter/Presenter/Product/ProductLazyArray.php:788 (getColoredVariants) /src/Adapter/Presenter/AbstractLazyArray.php:264 (getMainVariants) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/a8/a7/10/a8a710300f7cdde35120cbe16ad19050d30a1441_2.file.product.tpl.php:234 (offsetGet) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/a8/a7/10/a8a710300f7cdde35120cbe16ad19050d30a1441_2.file.product.tpl.php:338 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/a8/a7/10/a8a710300f7cdde35120cbe16ad19050d30a1441_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:156 (process) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/a8/a7/10/a8a710300f7cdde35120cbe16ad19050d30a1441_2.file.product.tpl.php:32 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_696d6ad326bb14_67715724) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:384 (render) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/3f/7d/0d/3f7d0dd85735416bd5b3ce10b4554f5fb578932d_2.file.productlist.tpl.php:39 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_696d6ad3253ca6_70171256) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/11/0a/74/110a7449c58ac8b5c663389783a92499ea1c7ebd_2.file.product-accessories.tpl.php:32 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_696d6ad324e7c8_52865461) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/b0/6c/17/b06c171e48c9d85ed0ff854f6229786cb32dbffe_2.file.product.tpl.php:490 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/b0/6c/17/b06c171e48c9d85ed0ff854f6229786cb32dbffe_2.file.product.tpl.php:687 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:186 (process) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/52/90/c3/5290c344b4d07ab96e07f0571e67dcd59554195b_2.file.layout-full-width.tpl.php:72 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/52/90/c3/5290c344b4d07ab96e07f0571e67dcd59554195b_2.file.layout-full-width.tpl.php:130 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:186 (process) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/14/fc/a5/14fca50b0aaf6d148e3756d711ec57c6a6a65aa6_2.file.layout-both-columns.tpl.php:85 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_696d69ac074786_63949425) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/52/90/c3/5290c344b4d07ab96e07f0571e67dcd59554195b_2.file.layout-full-width.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_696d69ac0682e0_59046668) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/b0/6c/17/b06c171e48c9d85ed0ff854f6229786cb32dbffe_2.file.product.tpl.php:54 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_696d6ad31782a6_74072138) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/Smarty/SmartyDev.php:40 (fetch) /classes/controller/FrontController.php:720 (fetch) /classes/controller/FrontController.php:704 (smartyOutputContent) /tools/profiling/Controller.php:111 (display) /tools/profiling/Controller.php:88 (displayProfiling) /classes/Dispatcher.php:488 (run) /index.php:86 (dispatch)
15	SELECT SQL_NO_CACHE lower(name) as name FROM `ps_hook` h WHERE (h.active = 1)	0.683 ms	1165			/classes/Hook.php:1608 /classes/Hook.php:910 (getHookStatusByName) /classes/Dispatcher.php:588 (exec) /classes/Dispatcher.php:253 (loadRoutes) /classes/Dispatcher.php:215 (__construct) /index.php:86 (getInstance)
721	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 = IFNULL(`pa`.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 (1862) 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.674 ms	32	Yes		/classes/Product.php:4289 /src/Adapter/Product/ProductColorsRetriever.php:43 (getAttributesColorList) /src/Adapter/Presenter/Product/ProductLazyArray.php:788 (getColoredVariants) /src/Adapter/Presenter/AbstractLazyArray.php:264 (getMainVariants) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/a8/a7/10/a8a710300f7cdde35120cbe16ad19050d30a1441_2.file.product.tpl.php:234 (offsetGet) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/a8/a7/10/a8a710300f7cdde35120cbe16ad19050d30a1441_2.file.product.tpl.php:338 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/a8/a7/10/a8a710300f7cdde35120cbe16ad19050d30a1441_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:156 (process) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/a8/a7/10/a8a710300f7cdde35120cbe16ad19050d30a1441_2.file.product.tpl.php:32 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_696d6ad326bb14_67715724) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:384 (render) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/3f/7d/0d/3f7d0dd85735416bd5b3ce10b4554f5fb578932d_2.file.productlist.tpl.php:39 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_696d6ad3253ca6_70171256) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/11/0a/74/110a7449c58ac8b5c663389783a92499ea1c7ebd_2.file.product-accessories.tpl.php:32 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_696d6ad324e7c8_52865461) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/b0/6c/17/b06c171e48c9d85ed0ff854f6229786cb32dbffe_2.file.product.tpl.php:490 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/b0/6c/17/b06c171e48c9d85ed0ff854f6229786cb32dbffe_2.file.product.tpl.php:687 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:186 (process) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/52/90/c3/5290c344b4d07ab96e07f0571e67dcd59554195b_2.file.layout-full-width.tpl.php:72 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/52/90/c3/5290c344b4d07ab96e07f0571e67dcd59554195b_2.file.layout-full-width.tpl.php:130 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:186 (process) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/14/fc/a5/14fca50b0aaf6d148e3756d711ec57c6a6a65aa6_2.file.layout-both-columns.tpl.php:85 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_696d69ac074786_63949425) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/52/90/c3/5290c344b4d07ab96e07f0571e67dcd59554195b_2.file.layout-full-width.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_696d69ac0682e0_59046668) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/b0/6c/17/b06c171e48c9d85ed0ff854f6229786cb32dbffe_2.file.product.tpl.php:54 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_696d6ad31782a6_74072138) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/Smarty/SmartyDev.php:40 (fetch) /classes/controller/FrontController.php:720 (fetch) /classes/controller/FrontController.php:704 (smartyOutputContent) /tools/profiling/Controller.php:111 (display) /tools/profiling/Controller.php:88 (displayProfiling) /classes/Dispatcher.php:488 (run) /index.php:86 (dispatch)
735	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 = IFNULL(`pa`.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 (1821) 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.670 ms	32	Yes		/classes/Product.php:4289 /src/Adapter/Product/ProductColorsRetriever.php:43 (getAttributesColorList) /src/Adapter/Presenter/Product/ProductLazyArray.php:788 (getColoredVariants) /src/Adapter/Presenter/AbstractLazyArray.php:264 (getMainVariants) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/a8/a7/10/a8a710300f7cdde35120cbe16ad19050d30a1441_2.file.product.tpl.php:234 (offsetGet) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/a8/a7/10/a8a710300f7cdde35120cbe16ad19050d30a1441_2.file.product.tpl.php:338 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/a8/a7/10/a8a710300f7cdde35120cbe16ad19050d30a1441_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:156 (process) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/a8/a7/10/a8a710300f7cdde35120cbe16ad19050d30a1441_2.file.product.tpl.php:32 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_696d6ad326bb14_67715724) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:384 (render) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/3f/7d/0d/3f7d0dd85735416bd5b3ce10b4554f5fb578932d_2.file.productlist.tpl.php:39 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_696d6ad3253ca6_70171256) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/11/0a/74/110a7449c58ac8b5c663389783a92499ea1c7ebd_2.file.product-accessories.tpl.php:32 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_696d6ad324e7c8_52865461) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/b0/6c/17/b06c171e48c9d85ed0ff854f6229786cb32dbffe_2.file.product.tpl.php:490 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/b0/6c/17/b06c171e48c9d85ed0ff854f6229786cb32dbffe_2.file.product.tpl.php:687 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:186 (process) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/52/90/c3/5290c344b4d07ab96e07f0571e67dcd59554195b_2.file.layout-full-width.tpl.php:72 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/52/90/c3/5290c344b4d07ab96e07f0571e67dcd59554195b_2.file.layout-full-width.tpl.php:130 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:186 (process) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/14/fc/a5/14fca50b0aaf6d148e3756d711ec57c6a6a65aa6_2.file.layout-both-columns.tpl.php:85 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_696d69ac074786_63949425) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/52/90/c3/5290c344b4d07ab96e07f0571e67dcd59554195b_2.file.layout-full-width.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_696d69ac0682e0_59046668) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/b0/6c/17/b06c171e48c9d85ed0ff854f6229786cb32dbffe_2.file.product.tpl.php:54 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_696d6ad31782a6_74072138) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/Smarty/SmartyDev.php:40 (fetch) /classes/controller/FrontController.php:720 (fetch) /classes/controller/FrontController.php:704 (smartyOutputContent) /tools/profiling/Controller.php:111 (display) /tools/profiling/Controller.php:88 (displayProfiling) /classes/Dispatcher.php:488 (run) /index.php:86 (dispatch)
728	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 = IFNULL(`pa`.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 (1849) 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.666 ms	32	Yes		/classes/Product.php:4289 /src/Adapter/Product/ProductColorsRetriever.php:43 (getAttributesColorList) /src/Adapter/Presenter/Product/ProductLazyArray.php:788 (getColoredVariants) /src/Adapter/Presenter/AbstractLazyArray.php:264 (getMainVariants) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/a8/a7/10/a8a710300f7cdde35120cbe16ad19050d30a1441_2.file.product.tpl.php:234 (offsetGet) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/a8/a7/10/a8a710300f7cdde35120cbe16ad19050d30a1441_2.file.product.tpl.php:338 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/a8/a7/10/a8a710300f7cdde35120cbe16ad19050d30a1441_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:156 (process) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/a8/a7/10/a8a710300f7cdde35120cbe16ad19050d30a1441_2.file.product.tpl.php:32 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_696d6ad326bb14_67715724) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:384 (render) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/3f/7d/0d/3f7d0dd85735416bd5b3ce10b4554f5fb578932d_2.file.productlist.tpl.php:39 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_696d6ad3253ca6_70171256) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/11/0a/74/110a7449c58ac8b5c663389783a92499ea1c7ebd_2.file.product-accessories.tpl.php:32 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_696d6ad324e7c8_52865461) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/b0/6c/17/b06c171e48c9d85ed0ff854f6229786cb32dbffe_2.file.product.tpl.php:490 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/b0/6c/17/b06c171e48c9d85ed0ff854f6229786cb32dbffe_2.file.product.tpl.php:687 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:186 (process) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/52/90/c3/5290c344b4d07ab96e07f0571e67dcd59554195b_2.file.layout-full-width.tpl.php:72 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/52/90/c3/5290c344b4d07ab96e07f0571e67dcd59554195b_2.file.layout-full-width.tpl.php:130 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:186 (process) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/14/fc/a5/14fca50b0aaf6d148e3756d711ec57c6a6a65aa6_2.file.layout-both-columns.tpl.php:85 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_696d69ac074786_63949425) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/52/90/c3/5290c344b4d07ab96e07f0571e67dcd59554195b_2.file.layout-full-width.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_696d69ac0682e0_59046668) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/hummingbirdlayouts_layout_full_width_tpl/b0/6c/17/b06c171e48c9d85ed0ff854f6229786cb32dbffe_2.file.product.tpl.php:54 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_696d6ad31782a6_74072138) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/Smarty/SmartyDev.php:40 (fetch) /classes/controller/FrontController.php:720 (fetch) /classes/controller/FrontController.php:704 (smartyOutputContent) /tools/profiling/Controller.php:111 (display) /tools/profiling/Controller.php:88 (displayProfiling) /classes/Dispatcher.php:488 (run) /index.php:86 (dispatch)
18	SELECT SQL_NO_CACHE `id_hook`, `name` FROM `ps_hook`	0.561 ms	1165			/classes/Hook.php:1568 /classes/Hook.php:251 (getAllHookIds) /classes/Hook.php:961 (getIdByName) /classes/Dispatcher.php:588 (exec) /classes/Dispatcher.php:253 (loadRoutes) /classes/Dispatcher.php:215 (__construct) /index.php:86 (getInstance)

#	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/polyfill-php83/bootstrap81.php
16	/vendor/symfony/var-dumper/Resources/functions/dump.php
17	/vendor/symfony/polyfill-intl-normalizer/bootstrap.php
18	/vendor/symfony/polyfill-intl-normalizer/bootstrap80.php
19	/vendor/twig/twig/src/Resources/core.php
20	/vendor/twig/twig/src/Resources/debug.php
21	/vendor/twig/twig/src/Resources/escaper.php
22	/vendor/twig/twig/src/Resources/string_loader.php
23	/vendor/symfony/polyfill-intl-grapheme/bootstrap.php
24	/vendor/symfony/polyfill-intl-grapheme/bootstrap80.php
25	/vendor/symfony/string/Resources/functions.php
26	/vendor/symfony/polyfill-intl-idn/bootstrap.php
27	/vendor/symfony/clock/Resources/now.php
28	/vendor/symfony/polyfill-php80/bootstrap.php
29	/vendor/ezyang/htmlpurifier/library/HTMLPurifier.composer.php
30	/vendor/jakeasmith/http_build_url/src/http_build_url.php
31	/vendor/symfony/polyfill-intl-icu/bootstrap.php
32	/vendor/ircmaxell/password-compat/lib/password.php
33	/vendor/martinlindhe/php-mb-helpers/src/mb_helpers.php
34	/vendor/symfony/polyfill-php73/bootstrap.php
35	/vendor/symfony/translation/Resources/functions.php
36	/src/Core/Version.php
37	/config/alias.php
38	/vendor/prestashop/autoload/src/PrestashopAutoload.php
39	/vendor/prestashop/autoload/src/LegacyClassLoader.php

Popruh na matraci pro Obojek - 4abies

Popis

Detaily produktu

Parametry

Mohlo by vás také zajímat

Komentáře (0)

Stopwatch SQL - 818 queries

Doubles

Tables stress

ObjectModel instances

Included Files