Nauja
Išparduota

M-Tac pants Aggressor Gen.II Vintage, Dark Olive Stilingos, kasdienės kelnės

Name: M-Tac pants Aggressor Gen.II Vintage, Dark Olive Stilingos, kasdienės kelnės
Brand: M-Tac
SKU: 20082
Price: 139.95 EUR
Availability: OutOfStock

€ 139,95

Su mokesčiais

Populiaraus modelio „Aggressor“ kelnės yra pagamintos iš storo medvilninio audinio su nedideliu elastano kiekiu ir „pasendintos“ pramoniniu skalbimu. „Aggressor Vintage“ kelnės - tai stilingos laisvalaikio kelnės, tinkančios tiek lauke, tiek kasdieniam dėvėjimui. Pagrindinė dizainerių užduotis buvo išlaikyti judėjimo patogumą, nes su šia užduotimi jie susidorojo 100 % - kelnės sukuria lengvumo pojūtį, nevaržo judesių, atrodo stilingai ir solidžiai.

Kiekis

Išparduota

Aprašymas
Prekė detaliau

Patogios šoninės kišenės su sustiprintais intarpais. Kelnės skirtos dėvėti su iki 5,5 cm pločio diržu. Diržo priekinėje dalyje įsiūtos sagtys, skirtos bet kam pritvirtinti (naudojant karabinus). Kokybiška YKK kompanijos furnitūra. Kelnės labai patogiai priglunda ir dėvimos, todėl susidaro įspūdis, kad dėvite sportines kelnes.

Ant diržo priekyje prisiūti tvirtinimai - Sagtys, skirtos bet kam pritvirtinti (naudojant karabinus). Kokybiška YKK kompanijos įranga. Kelnės taip patogiai priglunda, kad atrodo, jog dėvite sportines kelnes.

Techninė įranga: YKK

Sudėtis: 98% medvilnė, 2% elastanas

Kišenės:

-2 šoninės kelnių kišenės (su sutvirtinimu apatinėje dalyje peiliui pritvirtinti)

-2 galinės kišenės

-2 klubinės „krovininės“ kišenės su asimetriniu velcro atvartu

Kodas 20082048-28/30

Specifinė nuoroda

ean13: 5903886840560

Jums taip pat gali patikti

M-Tac pants Aggressor Summer Flex Vasarinės kelnės

Greita peržiūra

Nauja

M-Tac Tactical Pants Aggressor Gen.II Flex Taktinės kelnės, Coyote

Greita peržiūra

Load Time	635.944 ms
Querying Time	293 ms
Queries	740
Memory Peak Usage	26.4 Mb
Included Files	888 files - 9.47 Mb
PrestaShop Cache	- Mb
Global vars	0.02 Mb
- global $_SERVER	7k
- global $config	5k
- global $context	3k
- global $exportPhpConfigFile	3k
- global $__composer_autoload_files	2k
- global $smarty	1k

PrestaShop Version	8.2.3
PHP Version	8.2.29
MySQL Version	11.8.3-MariaDB-log
Memory Limit	6144M
Max Execution Time	480s
Smarty Cache	enabled
Smarty Compilation	never recompile

	Time	Cumulated Time	Memory Usage	Memory Peak Usage
config	75.719 ms	75.719 ms	8.22 Mb	9.5 Mb
__construct	0.027 ms	75.746 ms	- Mb	9.5 Mb
init	36.314 ms	112.060 ms	1.58 Mb	9.9 Mb
checkAccess	0.002 ms	112.062 ms	- Mb	9.9 Mb
setMedia	2.639 ms	114.701 ms	0.13 Mb	9.9 Mb
postProcess	0.009 ms	114.710 ms	- Mb	9.9 Mb
initHeader	0.002 ms	114.712 ms	- Mb	9.9 Mb
initContent	325.479 ms	440.191 ms	3.47 Mb	13.4 Mb
initFooter	0.003 ms	440.194 ms	- Mb	13.4 Mb
display	195.750 ms	635.944 ms	12.50 Mb	26.4 Mb

Hook	Time	Memory Usage
DisplayOverrideTemplate	9.365 ms	0.19 Mb
=> ets_seo	9.365 ms	0.19 Mb
DisplaySearch	4.130 ms	0.08 Mb
=> tvcmssearch	4.130 ms	0.08 Mb
DisplayHeader	3.721 ms	0.05 Mb
=> ps_searchbar	0.235 ms	- Mb
=> ps_shoppingcart	0.046 ms	- Mb
=> ps_googleanalytics	0.379 ms	0.01 Mb
=> ps_imageslider	0.126 ms	- Mb
=> ets_seo	2.093 ms	0.02 Mb
=> tvcmscustomsetting	0.645 ms	0.02 Mb
=> tvcmssearch	0.197 ms	- Mb
displayNav2	2.052 ms	0.15 Mb
=> ps_languageselector (widget)	0.464 ms	0.04 Mb
=> ps_customersignin (widget)	0.700 ms	0.05 Mb
=> ps_shoppingcart (widget)	0.888 ms	0.06 Mb
displayNav1	1.492 ms	0.07 Mb
=> ps_contactinfo (widget)	1.492 ms	0.07 Mb
displayTop	1.394 ms	0.15 Mb
=> ps_mainmenu (widget)	1.394 ms	0.15 Mb
displayProductAdditionalInfo	1.146 ms	0.05 Mb
=> ps_sharebuttons (widget)	1.146 ms	0.05 Mb
displayFooterBefore	1.009 ms	0.05 Mb
=> ps_emailsubscription (widget)	1.009 ms	0.05 Mb
ActionDispatcherBefore	0.744 ms	0.06 Mb
=> ets_seo	0.744 ms	0.06 Mb
ActionFrontControllerSetMedia	0.688 ms	0.01 Mb
=> ps_emailsubscription	0.241 ms	- Mb
=> ps_emailalerts	0.049 ms	- Mb
=> blockreassurance	0.106 ms	- Mb
=> blockwishlist	0.229 ms	- Mb
=> ps_socialfollow	0.063 ms	- Mb
DisplayNav1	0.548 ms	0.02 Mb
=> ps_topbanner	0.548 ms	0.02 Mb
DisplayProductActions	0.315 ms	- Mb
=> blockwishlist	0.315 ms	- Mb
DisplayReassurance	0.024 ms	- Mb
=> blockreassurance	0.024 ms	- Mb
DisplayAfterBodyOpeningTag	0.011 ms	- Mb
=> blockreassurance	0.011 ms	- Mb
FilterProductContent	0.010 ms	- Mb
=> ets_seo	0.010 ms	- Mb
DisplayFooterBefore	0.009 ms	- Mb
=> blockreassurance	0.009 ms	- Mb
DisplayNavFullWidth	0.008 ms	- Mb
=> blockreassurance	0.008 ms	- Mb
17 hook(s)	26.666 ms	0.88 Mb

Module	Time	Memory Usage
ets_seo	22.772 ms	1.98 Mb
__construct	10.538 ms	1.71 Mb
hookActionDispatcherBefore	0.751 ms	0.06 Mb
hookDisplayOverrideTemplate	9.370 ms	0.19 Mb
hookFilterProductContent	0.015 ms	- Mb
hookDisplayHeader	2.098 ms	0.02 Mb
ps_emailsubscription	2.184 ms	0.13 Mb
__construct	0.924 ms	0.08 Mb
hookActionFrontControllerSetMedia	0.245 ms	- Mb
displayFooterBefore	1.015 ms	0.05 Mb
ps_emailalerts	0.198 ms	0.01 Mb
__construct	0.147 ms	0.01 Mb
hookActionFrontControllerSetMedia	0.051 ms	- Mb
blockreassurance	0.281 ms	0.02 Mb
__construct	0.111 ms	0.01 Mb
hookActionFrontControllerSetMedia	0.107 ms	- Mb
hookDisplayAfterBodyOpeningTag	0.015 ms	- Mb
hookDisplayNavFullWidth	0.010 ms	- Mb
hookDisplayReassurance	0.027 ms	- Mb
hookDisplayFooterBefore	0.011 ms	- Mb
blockwishlist	0.629 ms	0.01 Mb
__construct	0.078 ms	0.01 Mb
hookActionFrontControllerSetMedia	0.231 ms	- Mb
hookDisplayProductActions	0.320 ms	- Mb
ps_socialfollow	0.139 ms	0.01 Mb
__construct	0.074 ms	0.01 Mb
hookActionFrontControllerSetMedia	0.065 ms	- Mb
ps_searchbar	0.391 ms	0.01 Mb
__construct	0.151 ms	0.01 Mb
hookDisplayHeader	0.240 ms	- Mb
ps_shoppingcart	1.022 ms	0.07 Mb
__construct	0.084 ms	0.01 Mb
hookDisplayHeader	0.048 ms	- Mb
displayNav2	0.890 ms	0.07 Mb
ps_googleanalytics	0.476 ms	0.02 Mb
__construct	0.094 ms	0.01 Mb
hookDisplayHeader	0.382 ms	0.01 Mb
ps_imageslider	0.242 ms	0.01 Mb
__construct	0.114 ms	0.01 Mb
hookDisplayHeader	0.128 ms	- Mb
tvcmscustomsetting	0.829 ms	0.02 Mb
__construct	0.180 ms	0.01 Mb
hookDisplayHeader	0.649 ms	0.02 Mb
tvcmssearch	4.445 ms	0.09 Mb
__construct	0.109 ms	0.01 Mb
hookDisplayHeader	0.199 ms	- Mb
hookDisplaySearch	4.137 ms	0.08 Mb
ps_contactinfo	1.638 ms	0.07 Mb
__construct	0.141 ms	0.01 Mb
displayNav1	1.497 ms	0.07 Mb
ps_topbanner	0.726 ms	0.03 Mb
__construct	0.173 ms	0.01 Mb
hookDisplayNav1	0.553 ms	0.02 Mb
ps_languageselector	0.603 ms	0.05 Mb
__construct	0.136 ms	0.01 Mb
displayNav2	0.467 ms	0.04 Mb
ps_customersignin	0.787 ms	0.05 Mb
__construct	0.084 ms	0.01 Mb
displayNav2	0.703 ms	0.05 Mb
ps_mainmenu	1.510 ms	0.16 Mb
__construct	0.113 ms	0.01 Mb
displayTop	1.397 ms	0.15 Mb
ps_sharebuttons	1.287 ms	0.06 Mb
__construct	0.137 ms	0.01 Mb
displayProductAdditionalInfo	1.150 ms	0.05 Mb
18 module(s)	40.159 ms	2.79 Mb

M-Tac pants Aggressor Gen.II Vintage, Dark Olive Stilingos, kasdienės kelnės

M-Tac Pants Aggressor...

M-Tac Tactical Pants...

M-Tac Shorts Aggressor...

M-Tac Tactical Pants...

M-Tac Tactical Pants...

M-Tac Tactical Pants...

M-Tac Tactical Pants...

M-Tac Tactical Pants...

Tacticalshop

Informacija

Pagalba

Stopwatch SQL - 740 queries

Doubles

Tables stress

ObjectModel instances

Included Files

363 queries	SELECT SUM(quantity) FROM `pbza_stock_available` WHERE (id_product = XX) AND (id_product_attribute = XX) AND (id_shop = XX) AND (id_shop_group = XX) LIMIT XX
18 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 `pbza_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 `pbza_cart_product` cp JOIN `pbza_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `pbza_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
11 queries	SELECT `id_module` FROM `pbza_module_shop` WHERE `id_module` = XX AND `id_shop` = XX LIMIT XX
10 queries	SELECT XX FROM `pbza_specific_price` WHERE id_product = XX LIMIT XX
10 queries	SELECT `id_product_attribute` FROM `pbza_product_attribute` WHERE `id_product` = XX
9 queries	SELECT product_attribute_shop.id_product_attribute FROM pbza_product_attribute pa INNER JOIN pbza_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
9 queries	SELECT product_attribute_shop.id_product_attribute FROM pbza_product_attribute pa INNER JOIN pbza_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
9 queries	SELECT * FROM `pbza_product` a LEFT JOIN `pbza_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = XX LEFT JOIN `pbza_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = XX WHERE (a.`id_product` = XX) AND (b.`id_shop` = XX) LIMIT XX
9 queries	SELECT `priority`, `id_specific_price_priority` FROM `pbza_specific_price_priority` WHERE `id_product` = XX ORDER BY `id_specific_price_priority` DESC LIMIT XX
9 queries	SELECT *, ( IF (`id_group` = XX, XX, XX) + IF (`id_country` = XX, XX, XX) + IF (`id_currency` = XX, XX, XX) + IF (`id_shop` = XX, XX, XX) + IF (`id_customer` = XX, XX, XX)) AS `score` FROM `pbza_specific_price` WHERE `id_shop` IN (XX, XX) AND `id_currency` IN (XX, XX) AND `id_country` IN (XX, XX) AND `id_group` IN (XX, XX) AND `id_product` = XX AND `id_customer` = XX AND `id_product_attribute` = XX AND `id_cart` = XX AND (`from` = 'XX-XX-XX XX:XX:XX' OR 'XX-XX-XX XX:XX:XX' >= `from`) AND (`to` = 'XX-XX-XX XX:XX:XX' OR 'XX-XX-XX XX:XX:XX' <= `to`) AND IF(`from_quantity` > XX, `from_quantity`, XX) <= XX ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT XX
9 queries	SELECT product_shop.`price`, product_shop.`ecotax`, IFNULL(product_attribute_shop.id_product_attribute,XX) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on, product_attribute_shop.`ecotax` AS attribute_ecotax FROM `pbza_product` p INNER JOIN `pbza_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = XX) LEFT JOIN `pbza_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = XX) WHERE (p.`id_product` = XX)
9 queries	SELECT `id_tax_rules_group` FROM `pbza_product_shop` WHERE `id_product` = XX AND id_shop=XX LIMIT XX
9 queries	SELECT * FROM `pbza_product_attribute` a LEFT JOIN `pbza_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
9 queries	SELECT * FROM `pbza_product_attribute_lang` WHERE `id_product_attribute` = XX
9 queries	SELECT image_shop.`cover`, i.`id_image`, il.`legend`, i.`position` FROM `pbza_image` i INNER JOIN pbza_image_shop image_shop ON (image_shop.id_image = i.id_image AND image_shop.id_shop = XX) LEFT JOIN `pbza_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = XX) WHERE i.`id_product` = XX ORDER BY `position`
9 queries	SELECT image_shop.`id_image` FROM `pbza_image` i INNER JOIN pbza_image_shop image_shop ON (image_shop.id_image = i.id_image AND image_shop.id_shop = XX) WHERE i.`id_product` = XX AND image_shop.`cover` = XX LIMIT XX
9 queries	SELECT name FROM pbza_category_lang WHERE id_shop = XX AND id_lang = XX AND id_category = XX LIMIT XX
9 queries	SELECT product_attribute_shop.`price` FROM `pbza_product_attribute` pa INNER JOIN pbza_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = XX) WHERE pa.`id_product_attribute` = XX LIMIT XX
9 queries	SELECT pa.`available_date` FROM `pbza_product` p LEFT JOIN `pbza_product_attribute` pa ON (pa.`id_product` = p.`id_product`) INNER JOIN pbza_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = XX) INNER JOIN pbza_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
9 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 `pbza_attribute` a LEFT JOIN `pbza_attribute_lang` al ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = XX) LEFT JOIN `pbza_product_attribute_combination` pac ON (pac.`id_attribute` = a.`id_attribute`) LEFT JOIN `pbza_product_attribute` pa ON (pa.`id_product_attribute` = pac.`id_product_attribute`) INNER JOIN pbza_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 `pbza_product_attribute_lang` pal ON (pal.`id_product_attribute` = pac.`id_product_attribute` AND pal.`id_lang` = XX) LEFT JOIN `pbza_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
9 queries	SELECT * FROM `pbza_product` a LEFT JOIN `pbza_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = XX WHERE (a.`id_product` = XX) LIMIT XX
9 queries	SELECT * FROM `pbza_product_lang` WHERE `id_product` = XX AND `id_shop` = XX
9 queries	SELECT pa., product_attribute_shop. FROM `pbza_product_attribute` pa INNER JOIN pbza_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = XX) WHERE pa.`id_product` = XX GROUP BY pa.`id_product_attribute` ORDER BY pa.`id_product_attribute`
8 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 `pbza_product_attribute` pa INNER JOIN pbza_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 pbza_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 `pbza_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`) JOIN `pbza_attribute` a ON (a.`id_attribute` = pac.`id_attribute`) JOIN `pbza_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = XX) JOIN `pbza_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;
6 queries	SELECT cl.`link_rewrite` FROM `pbza_category_lang` cl WHERE `id_lang` = XX AND cl.id_shop = XX AND cl.`id_category` = XX LIMIT XX
6 queries	SELECT pai.`id_image`, pai.`id_product_attribute`, il.`legend` FROM `pbza_product_attribute_image` pai LEFT JOIN `pbza_image_lang` il ON (il.`id_image` = pai.`id_image`) LEFT JOIN `pbza_image` i ON (i.`id_image` = pai.`id_image`) WHERE pai.`id_product_attribute` IN (XX, XX, XX, XX, XX, XX, XX, XX, XX, XX, XX, XX, XX, XX, XX, XX, XX, XX, XX, XX, XX, XX, XX, XX, XX, XX, XX, XX, XX, XX, XX, XX, XX, XX) AND il.`id_lang` = XX ORDER by i.`position`
6 queries	SELECT pac.id_product_attribute, GROUP_CONCAT(agl.`name`, ' - ',al.`name` ORDER BY agl.`id_attribute_group` SEPARATOR ', ') as attribute_designation FROM `pbza_product_attribute_combination` pac LEFT JOIN `pbza_attribute` a ON a.`id_attribute` = pac.`id_attribute` LEFT JOIN `pbza_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group` LEFT JOIN `pbza_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = XX) LEFT JOIN `pbza_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = XX) WHERE pac.id_product_attribute IN (XX,XX,XX,XX,XX,XX,XX,XX,XX,XX,XX,XX,XX,XX,XX,XX,XX,XX,XX,XX,XX,XX,XX,XX,XX,XX,XX,XX,XX,XX,XX,XX,XX,XX) GROUP BY pac.id_product_attribute ORDER BY pac.id_product_attribute
4 queries	SELECT `id_lang` FROM `pbza_lang` WHERE `locale` = 'lt-lt' OR `language_code` = 'lt-lt' LIMIT XX
3 queries	SELECT pa.id_product_attribute FROM `pbza_product_attribute` pa INNER JOIN pbza_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 `pbza_product_attribute` pa INNER JOIN pbza_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 `pbza_product_attribute_combination` pac ON pac.`id_product_attribute` = pa.`id_product_attribute` LEFT JOIN `pbza_attribute` a ON a.`id_attribute` = pac.`id_attribute` LEFT JOIN `pbza_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group` LEFT JOIN `pbza_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = XX) LEFT JOIN `pbza_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = XX) LEFT JOIN `pbza_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 `pbza_product_attribute` pa INNER JOIN pbza_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 pbza_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 `pbza_product_attribute_lang` `pal` ON pa.id_product_attribute = pal.id_product_attribute AND pal.id_lang = XX LEFT JOIN `pbza_product_attribute_combination` `pac` ON pac.id_product_attribute = pa.id_product_attribute LEFT JOIN `pbza_attribute` `a` ON a.id_attribute = pac.id_attribute LEFT JOIN `pbza_attribute_group` `ag` ON ag.id_attribute_group = a.id_attribute_group LEFT JOIN `pbza_attribute_lang` `al` ON a.id_attribute = al.id_attribute LEFT JOIN `pbza_attribute_group_lang` `agl` ON ag.id_attribute_group = agl.id_attribute_group INNER JOIN pbza_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
2 queries	SELECT m.`id_module`, m.`name`, ms.`id_module`as `mshop` FROM `pbza_module` m LEFT JOIN `pbza_module_shop` ms ON m.`id_module` = ms.`id_module` AND ms.`id_shop` = XX
2 queries	SELECT `type`, `target` FROM `pbza_ets_seo_redirect` WHERE `url` = 'm-tac-pants-aggressor-genii-vintage-dark-olive-stilingos-kasdienes-kelnes' AND active = XX AND `id_shop`=XX LIMIT XX
2 queries	SELECT `type`, `target` FROM `pbza_ets_seo_redirect` WHERE `url` = 'lt/m-tac-pants-aggressor-genii-vintage-dark-olive-stilingos-kasdienes-kelnes' AND active = XX AND `id_shop`=XX LIMIT XX
2 queries	SELECT `id_meta` FROM `pbza_meta_lang` WHERE `url_rewrite`='m-tac-pants-aggressor-genii-vintage-dark-olive-stilingos-kasdienes-kelnes' AND id_shop=XX AND id_lang=XX LIMIT XX
2 queries	SELECT * FROM `pbza_currency` a LEFT JOIN `pbza_currency_lang` `b` ON a.`id_currency` = b.`id_currency` AND b.`id_lang` = XX LEFT JOIN `pbza_currency_shop` `c` ON a.`id_currency` = c.`id_currency` AND c.`id_shop` = XX WHERE (a.`id_currency` = XX) LIMIT XX
2 queries	SELECT tr.* FROM `pbza_tax_rule` tr JOIN `pbza_tax_rules_group` trg ON (tr.`id_tax_rules_group` = trg.`id_tax_rules_group`) WHERE trg.`active` = XX AND tr.`id_country` = XX AND tr.`id_tax_rules_group` = XX AND tr.`id_state` IN (XX, XX) AND ('XX ' BETWEEN tr.`zipcode_from` AND tr.`zipcode_to` OR (tr.`zipcode_to` = XX AND tr.`zipcode_from` IN(XX, 'XX '))) ORDER BY tr.`zipcode_from` DESC, tr.`zipcode_to` DESC, tr.`id_state` DESC, tr.`id_country` DESC
2 queries	SELECT COUNT(p.id_product) FROM `pbza_product` p INNER JOIN pbza_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 t.`id_lang`, t.`name` FROM pbza_tag t LEFT JOIN pbza_product_tag pt ON (pt.id_tag = t.id_tag) WHERE pt.`id_product`=XX
2 queries	SELECT out_of_stock FROM `pbza_stock_available` WHERE (id_product = XX) AND (id_product_attribute = XX) AND (id_shop = XX) AND (id_shop_group = XX) LIMIT XX
2 queries	SELECT depends_on_stock FROM `pbza_stock_available` WHERE (id_product = XX) AND (id_product_attribute = XX) AND (id_shop = XX) AND (id_shop_group = XX) LIMIT XX
2 queries	SELECT location FROM `pbza_stock_available` WHERE (id_product = XX) AND (id_product_attribute = XX) AND (id_shop = XX) AND (id_shop_group = XX) LIMIT XX
2 queries	SELECT * FROM `pbza_category` a LEFT JOIN `pbza_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = XX LEFT JOIN `pbza_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = XX WHERE (a.`id_category` = XX) AND (b.`id_shop` = XX) LIMIT XX
2 queries	SELECT * FROM `pbza_ets_seo_rating` WHERE page_type = 'product' AND id_page = XX AND id_shop = XX LIMIT XX
2 queries	SELECT pai.`id_image`, pai.`id_product_attribute`, il.`legend` FROM `pbza_product_attribute_image` pai LEFT JOIN `pbza_image_lang` il ON (il.`id_image` = pai.`id_image`) LEFT JOIN `pbza_image` i ON (i.`id_image` = pai.`id_image`) WHERE pai.`id_product_attribute` IN (XX) AND il.`id_lang` = XX ORDER by i.`position`
2 queries	SELECT `need_identification_number` FROM `pbza_country` WHERE `id_country` = XX LIMIT XX
2 queries	SELECT XX FROM `pbza_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	61	/controllers/front/ProductController.php:146 (__construct) [id: 589] /modules/ets_seo/ets_seo.php:2951 (__construct) [id: 589] /modules/ets_seo/ets_seo.php:2562 (__construct) [id: 589] /modules/ets_seo/ets_seo.php:2695 (__construct) [id: 589] /classes/Link.php:113 (__construct) [id: 78] /classes/Link.php:113 (__construct) [id: 96] /classes/Link.php:113 (__construct) [id: 426] /classes/Link.php:113 (__construct) [id: 559] /classes/Link.php:113 (__construct) [id: 560] /classes/Link.php:113 (__construct) [id: 561] /classes/Link.php:113 (__construct) [id: 562] /classes/Link.php:113 (__construct) [id: 563] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 78] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 96] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 426] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 559] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 560] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 561] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 562] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 563] /classes/Link.php:113 (__construct) [id: 589] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 589] /classes/Meta.php:353 (__construct) [id: 589] /classes/Link.php:113 (__construct) [id: 589] /classes/Meta.php:353 (__construct) [id: 589] /classes/Link.php:113 (__construct) [id: 589] /modules/ets_seo/ets_seo.php:2562 (__construct) [id: 589] /modules/ets_seo/ets_seo.php:2695 (__construct) [id: 589] /classes/Link.php:113 (__construct) [id: 589] /src/Adapter/Presenter/Product/ProductLazyArray.php:658 (__construct) [id: 589] /classes/Link.php:113 (__construct) [id: 78] /classes/Link.php:113 (__construct) [id: 78] /classes/Link.php:113 (__construct) [id: 78] /classes/Link.php:113 (__construct) [id: 78] /classes/Link.php:113 (__construct) [id: 78] /src/Adapter/Presenter/Product/ProductLazyArray.php:658 (__construct) [id: 78] /classes/Link.php:113 (__construct) [id: 96] /classes/Link.php:113 (__construct) [id: 96] /src/Adapter/Presenter/Product/ProductLazyArray.php:658 (__construct) [id: 96] /classes/Link.php:113 (__construct) [id: 426] /classes/Link.php:113 (__construct) [id: 426] /classes/Link.php:113 (__construct) [id: 426] /classes/Link.php:113 (__construct) [id: 426] /classes/Link.php:113 (__construct) [id: 426] /classes/Link.php:113 (__construct) [id: 426] /src/Adapter/Presenter/Product/ProductLazyArray.php:658 (__construct) [id: 426] /classes/Link.php:113 (__construct) [id: 559] /classes/Link.php:113 (__construct) [id: 559] /src/Adapter/Presenter/Product/ProductLazyArray.php:658 (__construct) [id: 559] /classes/Link.php:113 (__construct) [id: 560] /classes/Link.php:113 (__construct) [id: 560] /src/Adapter/Presenter/Product/ProductLazyArray.php:658 (__construct) [id: 560] /classes/Link.php:113 (__construct) [id: 561] /classes/Link.php:113 (__construct) [id: 561] /src/Adapter/Presenter/Product/ProductLazyArray.php:658 (__construct) [id: 561] /classes/Link.php:113 (__construct) [id: 562] /classes/Link.php:113 (__construct) [id: 562] /src/Adapter/Presenter/Product/ProductLazyArray.php:658 (__construct) [id: 562] /classes/Link.php:113 (__construct) [id: 563] /classes/Link.php:113 (__construct) [id: 563] /src/Adapter/Presenter/Product/ProductLazyArray.php:658 (__construct) [id: 563]
Combination	10	/controllers/front/ProductController.php:1541 (__construct) [id: 4291] /classes/Product.php:5923 (__construct) [id: 473] /classes/Product.php:5923 (__construct) [id: 629] /classes/Product.php:5923 (__construct) [id: 2542] /classes/Product.php:5923 (__construct) [id: 3165] /classes/Product.php:5923 (__construct) [id: 3368] /classes/Product.php:5923 (__construct) [id: 3576] /classes/Product.php:5923 (__construct) [id: 3778] /classes/Product.php:5923 (__construct) [id: 3983] /classes/Product.php:5923 (__construct) [id: 4291]
Category	9	/modules/ets_seo/ets_seo.php:2570 (__construct) [id: 10] /modules/ets_seo/ets_seo.php:2725 (__construct) [id: 10] /controllers/front/ProductController.php:303 (__construct) [id: 10] /controllers/front/ProductController.php:1344 (__construct) [id: 10] /classes/PrestaShopCollection.php:385 (hydrateCollection) [id: ] /classes/PrestaShopCollection.php:385 (hydrateCollection) [id: ] /modules/ets_seo/ets_seo.php:2570 (__construct) [id: 10] /modules/ets_seo/ets_seo.php:2725 (__construct) [id: 10] /modules/tvcmssearch/tvcmssearch.php:102 (getNestedCategories) [id: 2]
Address	7	/classes/Product.php:741 (__construct) [id: ] /classes/Product.php:6906 (initialize) [id: ] /classes/Product.php:3804 (__construct) [id: ] /classes/Product.php:741 (__construct) [id: ] /controllers/front/ProductController.php:598 (__construct) [id: 0] /classes/Product.php:5975 (__construct) [id: ] /classes/shop/Shop.php:486 (__construct) [id: ]
Country	5	/config/config.inc.php:146 (__construct) [id: 130] /classes/AddressFormat.php:404 (__construct) [id: 130] /classes/controller/FrontController.php:1769 (__construct) [id: 130] /classes/AddressFormat.php:404 (__construct) [id: 130] /modules/ps_contactinfo/ps_contactinfo.php:105 (__construct) [id: 130]
Manufacturer	4	/modules/ets_seo/ets_seo.php:2698 (__construct) [id: 4] /controllers/front/ProductController.php:438 (__construct) [id: 4] /classes/Link.php:657 (__construct) [id: 4] /modules/ets_seo/ets_seo.php:2698 (__construct) [id: 4]
Currency	3	/src/Adapter/Currency/CurrencyDataProvider.php:101 (__construct) [id: 2] /src/Adapter/Currency/CurrencyDataProvider.php:101 (__construct) [id: 1] /classes/Tools.php:691 (getCurrencyInstance) [id: 2]
Group	3	/classes/Cart.php:249 (getCurrent) [id: 1] /modules/ets_seo/ets_seo.php:2717 (__construct) [id: 1] /modules/ets_seo/ets_seo.php:2717 (__construct) [id: 1]
AddressFormat	2	/classes/controller/FrontController.php:1763 (generateAddress) [id: ] /modules/ps_contactinfo/ps_contactinfo.php:91 (generateAddress) [id: ]
Tax	2	/classes/tax/TaxRulesTaxManager.php:116 (__construct) [id: 53] /classes/tax/TaxRulesTaxManager.php:116 (__construct) [id: 53]
State	2	/classes/controller/FrontController.php:1768 (__construct) [id: 0] /modules/ps_contactinfo/ps_contactinfo.php:94 (__construct) [id: 0]
Cart	2	/classes/controller/FrontController.php:467 (__construct) [id: ] /classes/controller/FrontController.php:541 (__construct) [id: ]
Meta	2	/modules/ets_seo/classes/dispatcher/EtsSeoDispatcher.php:558 (__construct) [id: 0] /modules/ets_seo/classes/dispatcher/EtsSeoDispatcher.php:558 (__construct) [id: 0]
Language	2	/config/config.inc.php:211 (__construct) [id: 3] /classes/Tools.php:561 (__construct) [id: 3]
Tab	1	/modules/ets_seo/ets_seo.php:875 (getInstanceFromClassName) [id: 0]
Customer	1	/config/config.inc.php:264 (__construct) [id: ]
Gender	1	/classes/controller/FrontController.php:1692 (__construct) [id: 0]
Risk	1	/classes/controller/FrontController.php:1695 (__construct) [id: ]
ShopGroup	1	/classes/shop/Shop.php:561 (__construct) [id: 1]
Shop	1	/config/config.inc.php:117 (initialize) [id: 1]

#	Query	Time (ms)	Rows	Filesort	Group By	Location
269	SELECT SQL_NO_CACHE pai.`id_image`, pai.`id_product_attribute`, il.`legend` FROM `pbza_product_attribute_image` pai LEFT JOIN `pbza_image_lang` il ON (il.`id_image` = pai.`id_image`) LEFT JOIN `pbza_image` i ON (i.`id_image` = pai.`id_image`) WHERE pai.`id_product_attribute` IN (378, 379, 380, 381, 382, 383, 384, 385, 386, 387, 388, 389, 390, 391, 392, 393, 394, 395, 396, 397, 398, 399, 400, 401, 402, 403, 404, 405, 406, 407, 408, 409, 410, 411, 412, 413, 414, 415, 416, 417, 418, 419, 420, 421, 422, 423, 424, 425, 426, 427, 428, 429, 430, 431, 432, 433, 434, 435, 436, 437, 438, 439, 440, 441, 442, 443, 444, 445, 446, 447, 448, 449, 450, 451, 452, 453, 454, 455, 456, 457, 458, 459, 460, 461, 462, 463, 464, 465, 466, 467, 468, 469, 470, 471, 472, 474, 475, 476, 477, 2034, 2035, 2036, 2037, 2038, 2039, 2040, 2041, 2042, 2043, 2044, 2045, 2046, 2047, 473) AND il.`id_lang` = 3 ORDER by i.`position`	7.033 ms	930	Yes		/classes/Product.php:2915 /src/Adapter/Image/ImageRetriever.php:90 (getCombinationImages) /src/Adapter/Presenter/Product/ProductLazyArray.php:683 (getAllProductImages) /src/Adapter/Presenter/Product/ProductLazyArray.php:126 (fillImages) /src/Adapter/Presenter/Product/ProductListingPresenter.php:49 (__construct) /controllers/front/ProductController.php:408 (present) /tools/profiling/Controller.php:65 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
284	SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position` FROM `pbza_image` i INNER JOIN pbza_image_shop image_shop ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1) LEFT JOIN `pbza_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 3) WHERE i.`id_product` = 561 ORDER BY `position`	6.832 ms	10	Yes		/classes/Product.php:3539 /override/classes/Product.php:87 (getImages) /override/classes/Product.php:52 (coreGetImages) /src/Adapter/Image/ImageRetriever.php:84 (getImages) /src/Adapter/Presenter/Product/ProductLazyArray.php:683 (getAllProductImages) /src/Adapter/Presenter/Product/ProductLazyArray.php:126 (fillImages) /src/Adapter/Presenter/Product/ProductListingPresenter.php:49 (__construct) /controllers/front/ProductController.php:408 (present) /tools/profiling/Controller.php:65 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
2	SELECT SQL_NO_CACHE c.`name`, cl.`id_lang`, IF(cl.`id_lang` IS NULL, c.`value`, cl.`value`) AS value, c.id_shop_group, c.id_shop FROM `pbza_configuration` c LEFT JOIN `pbza_configuration_lang` cl ON (c.`id_configuration` = cl.`id_configuration`)	5.289 ms	1516			/classes/Configuration.php:180 /classes/Configuration.php:229 (loadConfiguration) /classes/Configuration.php:302 (get) /classes/shop/Shop.php:398 (getMultiShopValues) /config/config.inc.php:117 (initialize) /index.php:27 (require)
351	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 `pbza_product_attribute` pa INNER JOIN pbza_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 pbza_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 `pbza_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`) JOIN `pbza_attribute` a ON (a.`id_attribute` = pac.`id_attribute`) JOIN `pbza_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 3) JOIN `pbza_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`) WHERE pa.`id_product` IN (78) AND ag.`is_color_group` = 1 GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` HAVING qty > 0 ORDER BY a.`position` ASC;	3.705 ms	114	Yes		/classes/Product.php:4513 /src/Adapter/Product/ProductColorsRetriever.php:43 (getAttributesColorList) /src/Adapter/Presenter/Product/ProductLazyArray.php:528 (getColoredVariants) /src/Adapter/Presenter/AbstractLazyArray.php:269 (getMainVariants) /var/cache/prod/smarty/compile/tacticalshoplayouts_layout_full_width_tpl/4f/20/74/4f2074cc9a10671087995e5913c0b696f1819436_2.file.product.tpl.php:249 (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/prod/smarty/compile/tacticalshoplayouts_layout_full_width_tpl/4f/20/74/4f2074cc9a10671087995e5913c0b696f1819436_2.file.product.tpl.php:28 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_697127493220a1_87328373) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /var/cache/prod/smarty/compile/tacticalshoplayouts_layout_full_width_tpl/c0/ae/43/c0ae436072faaac2f63ee6b48006dce9c16c1a88_2.file.product.tpl.php:573 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/tacticalshoplayouts_layout_full_width_tpl/c0/ae/43/c0ae436072faaac2f63ee6b48006dce9c16c1a88_2.file.product.tpl.php:597 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/tacticalshoplayouts_layout_full_width_tpl/c0/ae/43/c0ae436072faaac2f63ee6b48006dce9c16c1a88_2.file.product.tpl.php:843 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:186 (process) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/tacticalshoplayouts_layout_full_width_tpl/95/40/98/9540981dd24b2e1ee9e1ab592fab56198d5aba74_2.file.layout-full-width.tpl.php:101 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:186 (process) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/tacticalshoplayouts_layout_full_width_tpl/21/ce/9c/21ce9c4450f61fa801804652aca8224e94280476_2.file.layout-both-columns.tpl.php:94 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_696ff1f69aa703_49129424) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:115 (_subTemplateRender) /var/cache/prod/smarty/compile/tacticalshoplayouts_layout_full_width_tpl/95/40/98/9540981dd24b2e1ee9e1ab592fab56198d5aba74_2.file.layout-full-width.tpl.php:42 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_696ff1f6990274_50389007) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:115 (_subTemplateRender) /var/cache/prod/smarty/compile/tacticalshoplayouts_layout_full_width_tpl/c0/ae/43/c0ae436072faaac2f63ee6b48006dce9c16c1a88_2.file.product.tpl.php:56 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_697114877af8e4_95329253) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:115 (_subTemplateRender) /var/cache/prod/smarty/compile/tacticalshoplayouts_layout_full_width_tpl/75/f7/84/75f78462b4889e75d6c9b8c38f47834b47ec051b_2.file.product.tpl.php:52 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69711487766e19_01379308) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/controller/FrontController.php:771 (fetch) /classes/controller/FrontController.php:753 (smartyOutputContent) /tools/profiling/Controller.php:111 (display) /tools/profiling/Controller.php:88 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
356	SELECT SQL_NO_CACHE pac.id_product_attribute, GROUP_CONCAT(agl.`name`, ' - ',al.`name` ORDER BY agl.`id_attribute_group` SEPARATOR ', ') as attribute_designation FROM `pbza_product_attribute_combination` pac LEFT JOIN `pbza_attribute` a ON a.`id_attribute` = pac.`id_attribute` LEFT JOIN `pbza_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group` LEFT JOIN `pbza_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 3) LEFT JOIN `pbza_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 3) WHERE pac.id_product_attribute IN (378,379,380,381,382,383,384,385,386,387,388,389,390,391,392,393,394,395,396,397,398,399,400,401,402,403,404,405,406,407,408,409,410,411,412,413,414,415,416,417,418,419,420,421,422,423,424,425,426,427,428,429,430,431,432,433,434,435,436,437,438,439,440,441,442,443,444,445,446,447,448,449,450,451,452,453,454,455,456,457,458,459,460,461,462,463,464,465,466,467,468,469,470,471,472,473,474,475,476,477,2034,2035,2036,2037,2038,2039,2040,2041,2042,2043,2044,2045,2046,2047) GROUP BY pac.id_product_attribute ORDER BY pac.id_product_attribute	3.413 ms	228			/classes/Product.php:2746 /src/Adapter/Presenter/Product/ProductLazyArray.php:663 (getAttributesResume) /src/Adapter/Presenter/Product/ProductLazyArray.php:505 (shouldShowOutOfStockLabel) /src/Adapter/Presenter/AbstractLazyArray.php:269 (getFlags) /var/cache/prod/smarty/compile/tacticalshoplayouts_layout_full_width_tpl/58/3a/62/583a6274c50191b39b94bf997b0292afe7d658bf_2.file.product-flags.tpl.php:44 (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/prod/smarty/compile/tacticalshoplayouts_layout_full_width_tpl/58/3a/62/583a6274c50191b39b94bf997b0292afe7d658bf_2.file.product-flags.tpl.php:26 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69711487850046_94775079) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /var/cache/prod/smarty/compile/tacticalshoplayouts_layout_full_width_tpl/4f/20/74/4f2074cc9a10671087995e5913c0b696f1819436_2.file.product.tpl.php:279 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/tacticalshoplayouts_layout_full_width_tpl/4f/20/74/4f2074cc9a10671087995e5913c0b696f1819436_2.file.product.tpl.php:28 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_697127493220a1_87328373) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /var/cache/prod/smarty/compile/tacticalshoplayouts_layout_full_width_tpl/c0/ae/43/c0ae436072faaac2f63ee6b48006dce9c16c1a88_2.file.product.tpl.php:573 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/tacticalshoplayouts_layout_full_width_tpl/c0/ae/43/c0ae436072faaac2f63ee6b48006dce9c16c1a88_2.file.product.tpl.php:597 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/tacticalshoplayouts_layout_full_width_tpl/c0/ae/43/c0ae436072faaac2f63ee6b48006dce9c16c1a88_2.file.product.tpl.php:843 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:186 (process) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/tacticalshoplayouts_layout_full_width_tpl/95/40/98/9540981dd24b2e1ee9e1ab592fab56198d5aba74_2.file.layout-full-width.tpl.php:101 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:186 (process) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/tacticalshoplayouts_layout_full_width_tpl/21/ce/9c/21ce9c4450f61fa801804652aca8224e94280476_2.file.layout-both-columns.tpl.php:94 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_696ff1f69aa703_49129424) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:115 (_subTemplateRender) /var/cache/prod/smarty/compile/tacticalshoplayouts_layout_full_width_tpl/95/40/98/9540981dd24b2e1ee9e1ab592fab56198d5aba74_2.file.layout-full-width.tpl.php:42 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_696ff1f6990274_50389007) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:115 (_subTemplateRender) /var/cache/prod/smarty/compile/tacticalshoplayouts_layout_full_width_tpl/c0/ae/43/c0ae436072faaac2f63ee6b48006dce9c16c1a88_2.file.product.tpl.php:56 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_697114877af8e4_95329253) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:115 (_subTemplateRender) /var/cache/prod/smarty/compile/tacticalshoplayouts_layout_full_width_tpl/75/f7/84/75f78462b4889e75d6c9b8c38f47834b47ec051b_2.file.product.tpl.php:52 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69711487766e19_01379308) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/controller/FrontController.php:771 (fetch) /classes/controller/FrontController.php:753 (smartyOutputContent) /tools/profiling/Controller.php:111 (display) /tools/profiling/Controller.php:88 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
277	SELECT SQL_NO_CACHE pai.`id_image`, pai.`id_product_attribute`, il.`legend` FROM `pbza_product_attribute_image` pai LEFT JOIN `pbza_image_lang` il ON (il.`id_image` = pai.`id_image`) LEFT JOIN `pbza_image` i ON (i.`id_image` = pai.`id_image`) WHERE pai.`id_product_attribute` IN (2525, 2526, 2527, 2528, 2529, 2530, 2531, 2532, 2533, 2534, 2535, 2536, 2537, 2538, 2539, 2540, 2541, 2543, 2544, 2545, 2546, 2547, 2548, 2549, 2550, 2551, 2552, 2553, 2554, 2555, 2556, 2557, 2558, 2559, 2542) AND il.`id_lang` = 3 ORDER by i.`position`	3.210 ms	413	Yes		/classes/Product.php:2915 /src/Adapter/Image/ImageRetriever.php:90 (getCombinationImages) /src/Adapter/Presenter/Product/ProductLazyArray.php:683 (getAllProductImages) /src/Adapter/Presenter/Product/ProductLazyArray.php:126 (fillImages) /src/Adapter/Presenter/Product/ProductListingPresenter.php:49 (__construct) /controllers/front/ProductController.php:408 (present) /tools/profiling/Controller.php:65 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
57	SELECT SQL_NO_CACHE `id_hook`, `name` FROM `pbza_hook` UNION SELECT `id_hook`, ha.`alias` as name FROM `pbza_hook_alias` ha INNER JOIN `pbza_hook` h ON ha.name = h.name	3.097 ms	0			/classes/Hook.php:1348 /classes/Hook.php:228 (getAllHookIds) /classes/tax/TaxManagerFactory.php:67 (getIdByName) /classes/tax/TaxManagerFactory.php:46 (execHookTaxManagerFactory) /classes/Product.php:6909 (getManager) /classes/Product.php:741 (getTaxesRate) /controllers/front/ProductController.php:146 (__construct) /tools/profiling/Controller.php:46 (init) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
289	SELECT SQL_NO_CACHE pai.`id_image`, pai.`id_product_attribute`, il.`legend` FROM `pbza_product_attribute_image` pai LEFT JOIN `pbza_image_lang` il ON (il.`id_image` = pai.`id_image`) LEFT JOIN `pbza_image` i ON (i.`id_image` = pai.`id_image`) WHERE pai.`id_product_attribute` IN (3784, 3790, 3796, 3802, 3808, 3814, 3820, 3826, 3832, 3838, 3844, 3850, 3856, 3862, 3868, 3874, 3880, 3886, 3892, 3898, 3904, 3910, 3916, 3922, 3928, 3934, 3940, 3946, 3952, 3958, 3964, 3970, 3976, 3778) AND il.`id_lang` = 3 ORDER by i.`position`	2.985 ms	374	Yes		/classes/Product.php:2915 /src/Adapter/Image/ImageRetriever.php:90 (getCombinationImages) /src/Adapter/Presenter/Product/ProductLazyArray.php:683 (getAllProductImages) /src/Adapter/Presenter/Product/ProductLazyArray.php:126 (fillImages) /src/Adapter/Presenter/Product/ProductListingPresenter.php:49 (__construct) /controllers/front/ProductController.php:408 (present) /tools/profiling/Controller.php:65 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
286	SELECT SQL_NO_CACHE pai.`id_image`, pai.`id_product_attribute`, il.`legend` FROM `pbza_product_attribute_image` pai LEFT JOIN `pbza_image_lang` il ON (il.`id_image` = pai.`id_image`) LEFT JOIN `pbza_image` i ON (i.`id_image` = pai.`id_image`) WHERE pai.`id_product_attribute` IN (3582, 3588, 3594, 3600, 3606, 3612, 3618, 3624, 3630, 3636, 3642, 3648, 3654, 3660, 3666, 3672, 3678, 3684, 3690, 3696, 3702, 3708, 3714, 3720, 3726, 3732, 3738, 3744, 3750, 3756, 3762, 3768, 3774, 3576) AND il.`id_lang` = 3 ORDER by i.`position`	2.977 ms	339	Yes		/classes/Product.php:2915 /src/Adapter/Image/ImageRetriever.php:90 (getCombinationImages) /src/Adapter/Presenter/Product/ProductLazyArray.php:683 (getAllProductImages) /src/Adapter/Presenter/Product/ProductLazyArray.php:126 (fillImages) /src/Adapter/Presenter/Product/ProductListingPresenter.php:49 (__construct) /controllers/front/ProductController.php:408 (present) /tools/profiling/Controller.php:65 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
58	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 `pbza_hook_module` hm STRAIGHT_JOIN `pbza_hook` h ON (h.id_hook = hm.id_hook AND hm.id_shop = 1) STRAIGHT_JOIN `pbza_module` as m ON (m.id_module = hm.id_module) ORDER BY hm.position	2.939 ms	596			/classes/Hook.php:455 /classes/Hook.php:496 (getHookModuleList) /classes/tax/TaxManagerFactory.php:67 (getModulesFromHook) /classes/tax/TaxManagerFactory.php:46 (execHookTaxManagerFactory) /classes/Product.php:6909 (getManager) /classes/Product.php:741 (getTaxesRate) /controllers/front/ProductController.php:146 (__construct) /tools/profiling/Controller.php:46 (init) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
274	SELECT SQL_NO_CACHE pai.`id_image`, pai.`id_product_attribute`, il.`legend` FROM `pbza_product_attribute_image` pai LEFT JOIN `pbza_image_lang` il ON (il.`id_image` = pai.`id_image`) LEFT JOIN `pbza_image` i ON (i.`id_image` = pai.`id_image`) WHERE pai.`id_product_attribute` IN (635, 641, 647, 653, 659, 665, 671, 677, 683, 689, 695, 701, 707, 713, 719, 725, 731, 737, 743, 749, 755, 761, 767, 773, 779, 785, 791, 797, 803, 809, 815, 821, 827, 629) AND il.`id_lang` = 3 ORDER by i.`position`	2.767 ms	340	Yes		/classes/Product.php:2915 /src/Adapter/Image/ImageRetriever.php:90 (getCombinationImages) /src/Adapter/Presenter/Product/ProductLazyArray.php:683 (getAllProductImages) /src/Adapter/Presenter/Product/ProductLazyArray.php:126 (fillImages) /src/Adapter/Presenter/Product/ProductListingPresenter.php:49 (__construct) /controllers/front/ProductController.php:408 (present) /tools/profiling/Controller.php:65 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
280	SELECT SQL_NO_CACHE pai.`id_image`, pai.`id_product_attribute`, il.`legend` FROM `pbza_product_attribute_image` pai LEFT JOIN `pbza_image_lang` il ON (il.`id_image` = pai.`id_image`) LEFT JOIN `pbza_image` i ON (i.`id_image` = pai.`id_image`) WHERE pai.`id_product_attribute` IN (3171, 3177, 3183, 3189, 3195, 3201, 3207, 3213, 3219, 3225, 3231, 3237, 3243, 3249, 3255, 3261, 3267, 3273, 3279, 3285, 3291, 3297, 3303, 3309, 3315, 3321, 3327, 3333, 3339, 3345, 3351, 3357, 3363, 3165) AND il.`id_lang` = 3 ORDER by i.`position`	2.742 ms	374	Yes		/classes/Product.php:2915 /src/Adapter/Image/ImageRetriever.php:90 (getCombinationImages) /src/Adapter/Presenter/Product/ProductLazyArray.php:683 (getAllProductImages) /src/Adapter/Presenter/Product/ProductLazyArray.php:126 (fillImages) /src/Adapter/Presenter/Product/ProductListingPresenter.php:49 (__construct) /controllers/front/ProductController.php:408 (present) /tools/profiling/Controller.php:65 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
15	SELECT SQL_NO_CACHE h.`name` as hook, m.`id_module`, h.`id_hook`, m.`name` as module FROM `pbza_module` m INNER JOIN pbza_module_shop module_shop ON (module_shop.id_module = m.id_module AND module_shop.id_shop = 1 AND module_shop.enable_device & 1) INNER JOIN `pbza_hook_module` `hm` ON hm.`id_module` = m.`id_module` INNER JOIN `pbza_hook` `h` ON hm.`id_hook` = h.`id_hook` WHERE (h.`name` != "paymentOptions") AND (hm.`id_shop` = 1) GROUP BY hm.id_hook, hm.id_module ORDER BY hm.`position`	2.161 ms	350	Yes	Yes	/classes/Hook.php:1289 /classes/Hook.php:738 (getAllHookRegistrations) /classes/Hook.php:848 (getHookModuleExecList) /classes/Dispatcher.php:606 (exec) /classes/Dispatcher.php:243 (loadRoutes) /override/classes/Dispatcher.php:48 (__construct) /classes/Dispatcher.php:201 (__construct) /index.php:28 (getInstance)
332	SELECT SQL_NO_CACHE c., cl. FROM `pbza_category` c INNER JOIN pbza_category_shop category_shop ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1) LEFT JOIN `pbza_category_lang` cl ON c.`id_category` = cl.`id_category` AND cl.id_shop = 1 WHERE 1 AND `id_lang` = 3 AND c.`active` = 1 ORDER BY c.`level_depth` ASC , category_shop.`position` ASC	2.160 ms	102	Yes		/classes/Category.php:785 /modules/tvcmssearch/tvcmssearch.php:102 (getNestedCategories) /modules/tvcmssearch/tvcmssearch.php:220 (getAllCategories) /classes/Hook.php:1083 (hookdisplaySearch) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:421 (coreCallHook) /classes/Hook.php:989 (callHookOn) /config/smarty.config.inc.php:201 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/prod/smarty/compile/tacticalshoplayouts_layout_full_width_tpl/4a/19/e0/4a19e0059e7ac45c93b4824584fd7854b1ea749c_2.file.header.tpl.php:128 (__call) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/tacticalshoplayouts_layout_full_width_tpl/4a/19/e0/4a19e0059e7ac45c93b4824584fd7854b1ea749c_2.file.header.tpl.php:39 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_696ff1f6ad91c1_62290296) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /var/cache/prod/smarty/compile/tacticalshoplayouts_layout_full_width_tpl/21/ce/9c/21ce9c4450f61fa801804652aca8224e94280476_2.file.layout-both-columns.tpl.php:196 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/tacticalshoplayouts_layout_full_width_tpl/21/ce/9c/21ce9c4450f61fa801804652aca8224e94280476_2.file.layout-both-columns.tpl.php:68 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_696ff1f69aa703_49129424) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:115 (_subTemplateRender) /var/cache/prod/smarty/compile/tacticalshoplayouts_layout_full_width_tpl/95/40/98/9540981dd24b2e1ee9e1ab592fab56198d5aba74_2.file.layout-full-width.tpl.php:42 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_696ff1f6990274_50389007) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:115 (_subTemplateRender) /var/cache/prod/smarty/compile/tacticalshoplayouts_layout_full_width_tpl/c0/ae/43/c0ae436072faaac2f63ee6b48006dce9c16c1a88_2.file.product.tpl.php:56 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_697114877af8e4_95329253) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:115 (_subTemplateRender) /var/cache/prod/smarty/compile/tacticalshoplayouts_layout_full_width_tpl/75/f7/84/75f78462b4889e75d6c9b8c38f47834b47ec051b_2.file.product.tpl.php:52 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69711487766e19_01379308) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/controller/FrontController.php:771 (fetch) /classes/controller/FrontController.php:753 (smartyOutputContent) /tools/profiling/Controller.php:111 (display) /tools/profiling/Controller.php:88 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
292	SELECT SQL_NO_CACHE pai.`id_image`, pai.`id_product_attribute`, il.`legend` FROM `pbza_product_attribute_image` pai LEFT JOIN `pbza_image_lang` il ON (il.`id_image` = pai.`id_image`) LEFT JOIN `pbza_image` i ON (i.`id_image` = pai.`id_image`) WHERE pai.`id_product_attribute` IN (3989, 3995, 4001, 4007, 4013, 4019, 4025, 4031, 4037, 4043, 4049, 4055, 4061, 4067, 4073, 4079, 4085, 4091, 4097, 4103, 4109, 4115, 4121, 4127, 4133, 4139, 4145, 4151, 4157, 4163, 4169, 4175, 4181, 3983) AND il.`id_lang` = 3 ORDER by i.`position`	2.001 ms	203	Yes		/classes/Product.php:2915 /src/Adapter/Image/ImageRetriever.php:90 (getCombinationImages) /src/Adapter/Presenter/Product/ProductLazyArray.php:683 (getAllProductImages) /src/Adapter/Presenter/Product/ProductLazyArray.php:126 (fillImages) /src/Adapter/Presenter/Product/ProductListingPresenter.php:49 (__construct) /controllers/front/ProductController.php:408 (present) /tools/profiling/Controller.php:65 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
700	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 `pbza_product_attribute` pa INNER JOIN pbza_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 pbza_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 `pbza_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`) JOIN `pbza_attribute` a ON (a.`id_attribute` = pac.`id_attribute`) JOIN `pbza_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 3) JOIN `pbza_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`) WHERE pa.`id_product` IN (563) 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.898 ms	34	Yes		/classes/Product.php:4513 /src/Adapter/Product/ProductColorsRetriever.php:43 (getAttributesColorList) /src/Adapter/Presenter/Product/ProductLazyArray.php:528 (getColoredVariants) /src/Adapter/Presenter/AbstractLazyArray.php:269 (getMainVariants) /var/cache/prod/smarty/compile/tacticalshoplayouts_layout_full_width_tpl/4f/20/74/4f2074cc9a10671087995e5913c0b696f1819436_2.file.product.tpl.php:249 (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/prod/smarty/compile/tacticalshoplayouts_layout_full_width_tpl/4f/20/74/4f2074cc9a10671087995e5913c0b696f1819436_2.file.product.tpl.php:28 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_697127493220a1_87328373) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:384 (render) /var/cache/prod/smarty/compile/tacticalshoplayouts_layout_full_width_tpl/c0/ae/43/c0ae436072faaac2f63ee6b48006dce9c16c1a88_2.file.product.tpl.php:573 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/tacticalshoplayouts_layout_full_width_tpl/c0/ae/43/c0ae436072faaac2f63ee6b48006dce9c16c1a88_2.file.product.tpl.php:597 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/tacticalshoplayouts_layout_full_width_tpl/c0/ae/43/c0ae436072faaac2f63ee6b48006dce9c16c1a88_2.file.product.tpl.php:843 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:186 (process) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/tacticalshoplayouts_layout_full_width_tpl/95/40/98/9540981dd24b2e1ee9e1ab592fab56198d5aba74_2.file.layout-full-width.tpl.php:101 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:186 (process) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/tacticalshoplayouts_layout_full_width_tpl/21/ce/9c/21ce9c4450f61fa801804652aca8224e94280476_2.file.layout-both-columns.tpl.php:94 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_696ff1f69aa703_49129424) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:115 (_subTemplateRender) /var/cache/prod/smarty/compile/tacticalshoplayouts_layout_full_width_tpl/95/40/98/9540981dd24b2e1ee9e1ab592fab56198d5aba74_2.file.layout-full-width.tpl.php:42 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_696ff1f6990274_50389007) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:115 (_subTemplateRender) /var/cache/prod/smarty/compile/tacticalshoplayouts_layout_full_width_tpl/c0/ae/43/c0ae436072faaac2f63ee6b48006dce9c16c1a88_2.file.product.tpl.php:56 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_697114877af8e4_95329253) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:115 (_subTemplateRender) /var/cache/prod/smarty/compile/tacticalshoplayouts_layout_full_width_tpl/75/f7/84/75f78462b4889e75d6c9b8c38f47834b47ec051b_2.file.product.tpl.php:52 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69711487766e19_01379308) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/controller/FrontController.php:771 (fetch) /classes/controller/FrontController.php:753 (smartyOutputContent) /tools/profiling/Controller.php:111 (display) /tools/profiling/Controller.php:88 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
662	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 `pbza_product_attribute` pa INNER JOIN pbza_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 pbza_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 `pbza_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`) JOIN `pbza_attribute` a ON (a.`id_attribute` = pac.`id_attribute`) JOIN `pbza_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 3) JOIN `pbza_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`) WHERE pa.`id_product` IN (562) 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.896 ms	34	Yes		/classes/Product.php:4513 /src/Adapter/Product/ProductColorsRetriever.php:43 (getAttributesColorList) /src/Adapter/Presenter/Product/ProductLazyArray.php:528 (getColoredVariants) /src/Adapter/Presenter/AbstractLazyArray.php:269 (getMainVariants) /var/cache/prod/smarty/compile/tacticalshoplayouts_layout_full_width_tpl/4f/20/74/4f2074cc9a10671087995e5913c0b696f1819436_2.file.product.tpl.php:249 (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/prod/smarty/compile/tacticalshoplayouts_layout_full_width_tpl/4f/20/74/4f2074cc9a10671087995e5913c0b696f1819436_2.file.product.tpl.php:28 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_697127493220a1_87328373) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:384 (render) /var/cache/prod/smarty/compile/tacticalshoplayouts_layout_full_width_tpl/c0/ae/43/c0ae436072faaac2f63ee6b48006dce9c16c1a88_2.file.product.tpl.php:573 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/tacticalshoplayouts_layout_full_width_tpl/c0/ae/43/c0ae436072faaac2f63ee6b48006dce9c16c1a88_2.file.product.tpl.php:597 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/tacticalshoplayouts_layout_full_width_tpl/c0/ae/43/c0ae436072faaac2f63ee6b48006dce9c16c1a88_2.file.product.tpl.php:843 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:186 (process) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/tacticalshoplayouts_layout_full_width_tpl/95/40/98/9540981dd24b2e1ee9e1ab592fab56198d5aba74_2.file.layout-full-width.tpl.php:101 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:186 (process) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/tacticalshoplayouts_layout_full_width_tpl/21/ce/9c/21ce9c4450f61fa801804652aca8224e94280476_2.file.layout-both-columns.tpl.php:94 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_696ff1f69aa703_49129424) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:115 (_subTemplateRender) /var/cache/prod/smarty/compile/tacticalshoplayouts_layout_full_width_tpl/95/40/98/9540981dd24b2e1ee9e1ab592fab56198d5aba74_2.file.layout-full-width.tpl.php:42 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_696ff1f6990274_50389007) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:115 (_subTemplateRender) /var/cache/prod/smarty/compile/tacticalshoplayouts_layout_full_width_tpl/c0/ae/43/c0ae436072faaac2f63ee6b48006dce9c16c1a88_2.file.product.tpl.php:56 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_697114877af8e4_95329253) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:115 (_subTemplateRender) /var/cache/prod/smarty/compile/tacticalshoplayouts_layout_full_width_tpl/75/f7/84/75f78462b4889e75d6c9b8c38f47834b47ec051b_2.file.product.tpl.php:52 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69711487766e19_01379308) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/controller/FrontController.php:771 (fetch) /classes/controller/FrontController.php:753 (smartyOutputContent) /tools/profiling/Controller.php:111 (display) /tools/profiling/Controller.php:88 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
111	SELECT SQL_NO_CACHE p., product_shop., stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, pl.`description`, pl.`description_short`, pl.`link_rewrite`, pl.`meta_description`, pl.`meta_keywords`, pl.`meta_title`, pl.`name`, pl.`available_now`, pl.`available_later`, image_shop.`id_image` id_image, il.`legend`, m.`name` as manufacturer_name, cl.`name` AS category_default, IFNULL(product_attribute_shop.id_product_attribute, 0) id_product_attribute, DATEDIFF( p.`date_add`, DATE_SUB( "2026-01-21 00:00:00", INTERVAL 1000 DAY ) ) > 0 AS new FROM `pbza_accessory` LEFT JOIN `pbza_product` p ON p.`id_product` = `id_product_2` INNER JOIN pbza_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) LEFT JOIN `pbza_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 `pbza_product_lang` pl ON ( p.`id_product` = pl.`id_product` AND pl.`id_lang` = 3 AND pl.id_shop = 1 ) LEFT JOIN `pbza_category_lang` cl ON ( product_shop.`id_category_default` = cl.`id_category` AND cl.`id_lang` = 3 AND cl.id_shop = 1 ) LEFT JOIN `pbza_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 `pbza_image_lang` il ON (image_shop.`id_image` = il.`id_image` AND il.`id_lang` = 3) LEFT JOIN `pbza_manufacturer` m ON (p.`id_manufacturer`= m.`id_manufacturer`) LEFT JOIN pbza_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` = 589 AND product_shop.`active` = 1 AND product_shop.`visibility` != 'none' GROUP BY product_shop.id_product	1.855 ms	8		Yes	/classes/Product.php:4713 /controllers/front/ProductController.php:405 (getAccessories) /tools/profiling/Controller.php:65 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
470	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 `pbza_product_attribute` pa INNER JOIN pbza_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 pbza_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 `pbza_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`) JOIN `pbza_attribute` a ON (a.`id_attribute` = pac.`id_attribute`) JOIN `pbza_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 3) JOIN `pbza_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`) WHERE pa.`id_product` IN (96) 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.841 ms	34	Yes		/classes/Product.php:4513 /src/Adapter/Product/ProductColorsRetriever.php:43 (getAttributesColorList) /src/Adapter/Presenter/Product/ProductLazyArray.php:528 (getColoredVariants) /src/Adapter/Presenter/AbstractLazyArray.php:269 (getMainVariants) /var/cache/prod/smarty/compile/tacticalshoplayouts_layout_full_width_tpl/4f/20/74/4f2074cc9a10671087995e5913c0b696f1819436_2.file.product.tpl.php:249 (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/prod/smarty/compile/tacticalshoplayouts_layout_full_width_tpl/4f/20/74/4f2074cc9a10671087995e5913c0b696f1819436_2.file.product.tpl.php:28 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_697127493220a1_87328373) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:384 (render) /var/cache/prod/smarty/compile/tacticalshoplayouts_layout_full_width_tpl/c0/ae/43/c0ae436072faaac2f63ee6b48006dce9c16c1a88_2.file.product.tpl.php:573 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/tacticalshoplayouts_layout_full_width_tpl/c0/ae/43/c0ae436072faaac2f63ee6b48006dce9c16c1a88_2.file.product.tpl.php:597 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/tacticalshoplayouts_layout_full_width_tpl/c0/ae/43/c0ae436072faaac2f63ee6b48006dce9c16c1a88_2.file.product.tpl.php:843 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:186 (process) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/tacticalshoplayouts_layout_full_width_tpl/95/40/98/9540981dd24b2e1ee9e1ab592fab56198d5aba74_2.file.layout-full-width.tpl.php:101 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:186 (process) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/tacticalshoplayouts_layout_full_width_tpl/21/ce/9c/21ce9c4450f61fa801804652aca8224e94280476_2.file.layout-both-columns.tpl.php:94 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_696ff1f69aa703_49129424) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:115 (_subTemplateRender) /var/cache/prod/smarty/compile/tacticalshoplayouts_layout_full_width_tpl/95/40/98/9540981dd24b2e1ee9e1ab592fab56198d5aba74_2.file.layout-full-width.tpl.php:42 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_696ff1f6990274_50389007) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:115 (_subTemplateRender) /var/cache/prod/smarty/compile/tacticalshoplayouts_layout_full_width_tpl/c0/ae/43/c0ae436072faaac2f63ee6b48006dce9c16c1a88_2.file.product.tpl.php:56 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_697114877af8e4_95329253) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:115 (_subTemplateRender) /var/cache/prod/smarty/compile/tacticalshoplayouts_layout_full_width_tpl/75/f7/84/75f78462b4889e75d6c9b8c38f47834b47ec051b_2.file.product.tpl.php:52 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69711487766e19_01379308) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/controller/FrontController.php:771 (fetch) /classes/controller/FrontController.php:753 (smartyOutputContent) /tools/profiling/Controller.php:111 (display) /tools/profiling/Controller.php:88 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
508	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 `pbza_product_attribute` pa INNER JOIN pbza_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 pbza_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 `pbza_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`) JOIN `pbza_attribute` a ON (a.`id_attribute` = pac.`id_attribute`) JOIN `pbza_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 3) JOIN `pbza_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`) WHERE pa.`id_product` IN (426) 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.833 ms	35	Yes		/classes/Product.php:4513 /src/Adapter/Product/ProductColorsRetriever.php:43 (getAttributesColorList) /src/Adapter/Presenter/Product/ProductLazyArray.php:528 (getColoredVariants) /src/Adapter/Presenter/AbstractLazyArray.php:269 (getMainVariants) /var/cache/prod/smarty/compile/tacticalshoplayouts_layout_full_width_tpl/4f/20/74/4f2074cc9a10671087995e5913c0b696f1819436_2.file.product.tpl.php:249 (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/prod/smarty/compile/tacticalshoplayouts_layout_full_width_tpl/4f/20/74/4f2074cc9a10671087995e5913c0b696f1819436_2.file.product.tpl.php:28 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_697127493220a1_87328373) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:384 (render) /var/cache/prod/smarty/compile/tacticalshoplayouts_layout_full_width_tpl/c0/ae/43/c0ae436072faaac2f63ee6b48006dce9c16c1a88_2.file.product.tpl.php:573 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/tacticalshoplayouts_layout_full_width_tpl/c0/ae/43/c0ae436072faaac2f63ee6b48006dce9c16c1a88_2.file.product.tpl.php:597 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/tacticalshoplayouts_layout_full_width_tpl/c0/ae/43/c0ae436072faaac2f63ee6b48006dce9c16c1a88_2.file.product.tpl.php:843 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:186 (process) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/tacticalshoplayouts_layout_full_width_tpl/95/40/98/9540981dd24b2e1ee9e1ab592fab56198d5aba74_2.file.layout-full-width.tpl.php:101 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:186 (process) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/tacticalshoplayouts_layout_full_width_tpl/21/ce/9c/21ce9c4450f61fa801804652aca8224e94280476_2.file.layout-both-columns.tpl.php:94 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_696ff1f69aa703_49129424) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:115 (_subTemplateRender) /var/cache/prod/smarty/compile/tacticalshoplayouts_layout_full_width_tpl/95/40/98/9540981dd24b2e1ee9e1ab592fab56198d5aba74_2.file.layout-full-width.tpl.php:42 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_696ff1f6990274_50389007) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:115 (_subTemplateRender) /var/cache/prod/smarty/compile/tacticalshoplayouts_layout_full_width_tpl/c0/ae/43/c0ae436072faaac2f63ee6b48006dce9c16c1a88_2.file.product.tpl.php:56 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_697114877af8e4_95329253) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:115 (_subTemplateRender) /var/cache/prod/smarty/compile/tacticalshoplayouts_layout_full_width_tpl/75/f7/84/75f78462b4889e75d6c9b8c38f47834b47ec051b_2.file.product.tpl.php:52 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69711487766e19_01379308) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/controller/FrontController.php:771 (fetch) /classes/controller/FrontController.php:753 (smartyOutputContent) /tools/profiling/Controller.php:111 (display) /tools/profiling/Controller.php:88 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
624	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 `pbza_product_attribute` pa INNER JOIN pbza_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 pbza_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 `pbza_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`) JOIN `pbza_attribute` a ON (a.`id_attribute` = pac.`id_attribute`) JOIN `pbza_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 3) JOIN `pbza_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`) WHERE pa.`id_product` IN (561) 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.832 ms	34	Yes		/classes/Product.php:4513 /src/Adapter/Product/ProductColorsRetriever.php:43 (getAttributesColorList) /src/Adapter/Presenter/Product/ProductLazyArray.php:528 (getColoredVariants) /src/Adapter/Presenter/AbstractLazyArray.php:269 (getMainVariants) /var/cache/prod/smarty/compile/tacticalshoplayouts_layout_full_width_tpl/4f/20/74/4f2074cc9a10671087995e5913c0b696f1819436_2.file.product.tpl.php:249 (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/prod/smarty/compile/tacticalshoplayouts_layout_full_width_tpl/4f/20/74/4f2074cc9a10671087995e5913c0b696f1819436_2.file.product.tpl.php:28 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_697127493220a1_87328373) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:384 (render) /var/cache/prod/smarty/compile/tacticalshoplayouts_layout_full_width_tpl/c0/ae/43/c0ae436072faaac2f63ee6b48006dce9c16c1a88_2.file.product.tpl.php:573 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/tacticalshoplayouts_layout_full_width_tpl/c0/ae/43/c0ae436072faaac2f63ee6b48006dce9c16c1a88_2.file.product.tpl.php:597 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/tacticalshoplayouts_layout_full_width_tpl/c0/ae/43/c0ae436072faaac2f63ee6b48006dce9c16c1a88_2.file.product.tpl.php:843 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:186 (process) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/tacticalshoplayouts_layout_full_width_tpl/95/40/98/9540981dd24b2e1ee9e1ab592fab56198d5aba74_2.file.layout-full-width.tpl.php:101 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:186 (process) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/tacticalshoplayouts_layout_full_width_tpl/21/ce/9c/21ce9c4450f61fa801804652aca8224e94280476_2.file.layout-both-columns.tpl.php:94 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_696ff1f69aa703_49129424) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:115 (_subTemplateRender) /var/cache/prod/smarty/compile/tacticalshoplayouts_layout_full_width_tpl/95/40/98/9540981dd24b2e1ee9e1ab592fab56198d5aba74_2.file.layout-full-width.tpl.php:42 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_696ff1f6990274_50389007) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:115 (_subTemplateRender) /var/cache/prod/smarty/compile/tacticalshoplayouts_layout_full_width_tpl/c0/ae/43/c0ae436072faaac2f63ee6b48006dce9c16c1a88_2.file.product.tpl.php:56 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_697114877af8e4_95329253) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:115 (_subTemplateRender) /var/cache/prod/smarty/compile/tacticalshoplayouts_layout_full_width_tpl/75/f7/84/75f78462b4889e75d6c9b8c38f47834b47ec051b_2.file.product.tpl.php:52 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69711487766e19_01379308) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/controller/FrontController.php:771 (fetch) /classes/controller/FrontController.php:753 (smartyOutputContent) /tools/profiling/Controller.php:111 (display) /tools/profiling/Controller.php:88 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
355	SELECT SQL_NO_CACHE pa., product_attribute_shop. FROM `pbza_product_attribute` pa INNER JOIN pbza_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) WHERE pa.`id_product` = 78 GROUP BY pa.`id_product_attribute` ORDER BY pa.`id_product_attribute`	1.817 ms	114	Yes	Yes	/classes/Product.php:2731 /src/Adapter/Presenter/Product/ProductLazyArray.php:663 (getAttributesResume) /src/Adapter/Presenter/Product/ProductLazyArray.php:505 (shouldShowOutOfStockLabel) /src/Adapter/Presenter/AbstractLazyArray.php:269 (getFlags) /var/cache/prod/smarty/compile/tacticalshoplayouts_layout_full_width_tpl/58/3a/62/583a6274c50191b39b94bf997b0292afe7d658bf_2.file.product-flags.tpl.php:44 (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/prod/smarty/compile/tacticalshoplayouts_layout_full_width_tpl/58/3a/62/583a6274c50191b39b94bf997b0292afe7d658bf_2.file.product-flags.tpl.php:26 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69711487850046_94775079) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /var/cache/prod/smarty/compile/tacticalshoplayouts_layout_full_width_tpl/4f/20/74/4f2074cc9a10671087995e5913c0b696f1819436_2.file.product.tpl.php:279 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/tacticalshoplayouts_layout_full_width_tpl/4f/20/74/4f2074cc9a10671087995e5913c0b696f1819436_2.file.product.tpl.php:28 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_697127493220a1_87328373) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /var/cache/prod/smarty/compile/tacticalshoplayouts_layout_full_width_tpl/c0/ae/43/c0ae436072faaac2f63ee6b48006dce9c16c1a88_2.file.product.tpl.php:573 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/tacticalshoplayouts_layout_full_width_tpl/c0/ae/43/c0ae436072faaac2f63ee6b48006dce9c16c1a88_2.file.product.tpl.php:597 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/tacticalshoplayouts_layout_full_width_tpl/c0/ae/43/c0ae436072faaac2f63ee6b48006dce9c16c1a88_2.file.product.tpl.php:843 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:186 (process) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/tacticalshoplayouts_layout_full_width_tpl/95/40/98/9540981dd24b2e1ee9e1ab592fab56198d5aba74_2.file.layout-full-width.tpl.php:101 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:186 (process) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/tacticalshoplayouts_layout_full_width_tpl/21/ce/9c/21ce9c4450f61fa801804652aca8224e94280476_2.file.layout-both-columns.tpl.php:94 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_696ff1f69aa703_49129424) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:115 (_subTemplateRender) /var/cache/prod/smarty/compile/tacticalshoplayouts_layout_full_width_tpl/95/40/98/9540981dd24b2e1ee9e1ab592fab56198d5aba74_2.file.layout-full-width.tpl.php:42 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_696ff1f6990274_50389007) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:115 (_subTemplateRender) /var/cache/prod/smarty/compile/tacticalshoplayouts_layout_full_width_tpl/c0/ae/43/c0ae436072faaac2f63ee6b48006dce9c16c1a88_2.file.product.tpl.php:56 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_697114877af8e4_95329253) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:115 (_subTemplateRender) /var/cache/prod/smarty/compile/tacticalshoplayouts_layout_full_width_tpl/75/f7/84/75f78462b4889e75d6c9b8c38f47834b47ec051b_2.file.product.tpl.php:52 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69711487766e19_01379308) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/controller/FrontController.php:771 (fetch) /classes/controller/FrontController.php:753 (smartyOutputContent) /tools/profiling/Controller.php:111 (display) /tools/profiling/Controller.php:88 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
548	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 `pbza_product_attribute` pa INNER JOIN pbza_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 pbza_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 `pbza_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`) JOIN `pbza_attribute` a ON (a.`id_attribute` = pac.`id_attribute`) JOIN `pbza_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 3) JOIN `pbza_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`) WHERE pa.`id_product` IN (559) 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.749 ms	34	Yes		/classes/Product.php:4513 /src/Adapter/Product/ProductColorsRetriever.php:43 (getAttributesColorList) /src/Adapter/Presenter/Product/ProductLazyArray.php:528 (getColoredVariants) /src/Adapter/Presenter/AbstractLazyArray.php:269 (getMainVariants) /var/cache/prod/smarty/compile/tacticalshoplayouts_layout_full_width_tpl/4f/20/74/4f2074cc9a10671087995e5913c0b696f1819436_2.file.product.tpl.php:249 (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/prod/smarty/compile/tacticalshoplayouts_layout_full_width_tpl/4f/20/74/4f2074cc9a10671087995e5913c0b696f1819436_2.file.product.tpl.php:28 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_697127493220a1_87328373) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:384 (render) /var/cache/prod/smarty/compile/tacticalshoplayouts_layout_full_width_tpl/c0/ae/43/c0ae436072faaac2f63ee6b48006dce9c16c1a88_2.file.product.tpl.php:573 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/tacticalshoplayouts_layout_full_width_tpl/c0/ae/43/c0ae436072faaac2f63ee6b48006dce9c16c1a88_2.file.product.tpl.php:597 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/tacticalshoplayouts_layout_full_width_tpl/c0/ae/43/c0ae436072faaac2f63ee6b48006dce9c16c1a88_2.file.product.tpl.php:843 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:186 (process) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/tacticalshoplayouts_layout_full_width_tpl/95/40/98/9540981dd24b2e1ee9e1ab592fab56198d5aba74_2.file.layout-full-width.tpl.php:101 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:186 (process) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/tacticalshoplayouts_layout_full_width_tpl/21/ce/9c/21ce9c4450f61fa801804652aca8224e94280476_2.file.layout-both-columns.tpl.php:94 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_696ff1f69aa703_49129424) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:115 (_subTemplateRender) /var/cache/prod/smarty/compile/tacticalshoplayouts_layout_full_width_tpl/95/40/98/9540981dd24b2e1ee9e1ab592fab56198d5aba74_2.file.layout-full-width.tpl.php:42 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_696ff1f6990274_50389007) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:115 (_subTemplateRender) /var/cache/prod/smarty/compile/tacticalshoplayouts_layout_full_width_tpl/c0/ae/43/c0ae436072faaac2f63ee6b48006dce9c16c1a88_2.file.product.tpl.php:56 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_697114877af8e4_95329253) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:115 (_subTemplateRender) /var/cache/prod/smarty/compile/tacticalshoplayouts_layout_full_width_tpl/75/f7/84/75f78462b4889e75d6c9b8c38f47834b47ec051b_2.file.product.tpl.php:52 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69711487766e19_01379308) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/controller/FrontController.php:771 (fetch) /classes/controller/FrontController.php:753 (smartyOutputContent) /tools/profiling/Controller.php:111 (display) /tools/profiling/Controller.php:88 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
311	SELECT SQL_NO_CACHE pac2.`id_attribute` FROM `pbza_product_attribute_combination` pac2 INNER JOIN `pbza_stock_available` pa ON pa.id_product_attribute = pac2.id_product_attribute WHERE pa.quantity > 0 AND pac2.`id_product_attribute` IN (0,4291) AND pac2.id_attribute NOT IN (27)	1.735 ms	14816			/controllers/front/ProductController.php:786 /controllers/front/ProductController.php:462 (assignAttributesGroups) /tools/profiling/Controller.php:65 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
103	SELECT SQL_NO_CACHE c.*, cl.`id_lang`, cl.`name`, cl.`description`, cl.`additional_description`, cl.`link_rewrite`, cl.`meta_title`, cl.`meta_keywords`, cl.`meta_description` FROM `pbza_category` c INNER JOIN pbza_category_shop category_shop ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1) LEFT JOIN `pbza_category_lang` cl ON (c.`id_category` = cl.`id_category` AND `id_lang` = 3 AND cl.id_shop = 1 ) WHERE `id_parent` = 10 AND `active` = 1 GROUP BY c.`id_category` ORDER BY `level_depth` ASC, category_shop.`position` ASC	1.699 ms	17	Yes	Yes	/classes/Category.php:916 /controllers/front/ProductController.php:901 (getSubCategories) /controllers/front/ProductController.php:368 (assignCategory) /tools/profiling/Controller.php:65 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
586	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 `pbza_product_attribute` pa INNER JOIN pbza_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 pbza_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 `pbza_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`) JOIN `pbza_attribute` a ON (a.`id_attribute` = pac.`id_attribute`) JOIN `pbza_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 3) JOIN `pbza_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`) WHERE pa.`id_product` IN (560) 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.694 ms	34	Yes		/classes/Product.php:4513 /src/Adapter/Product/ProductColorsRetriever.php:43 (getAttributesColorList) /src/Adapter/Presenter/Product/ProductLazyArray.php:528 (getColoredVariants) /src/Adapter/Presenter/AbstractLazyArray.php:269 (getMainVariants) /var/cache/prod/smarty/compile/tacticalshoplayouts_layout_full_width_tpl/4f/20/74/4f2074cc9a10671087995e5913c0b696f1819436_2.file.product.tpl.php:249 (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/prod/smarty/compile/tacticalshoplayouts_layout_full_width_tpl/4f/20/74/4f2074cc9a10671087995e5913c0b696f1819436_2.file.product.tpl.php:28 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_697127493220a1_87328373) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:384 (render) /var/cache/prod/smarty/compile/tacticalshoplayouts_layout_full_width_tpl/c0/ae/43/c0ae436072faaac2f63ee6b48006dce9c16c1a88_2.file.product.tpl.php:573 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/tacticalshoplayouts_layout_full_width_tpl/c0/ae/43/c0ae436072faaac2f63ee6b48006dce9c16c1a88_2.file.product.tpl.php:597 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/tacticalshoplayouts_layout_full_width_tpl/c0/ae/43/c0ae436072faaac2f63ee6b48006dce9c16c1a88_2.file.product.tpl.php:843 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:186 (process) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/tacticalshoplayouts_layout_full_width_tpl/95/40/98/9540981dd24b2e1ee9e1ab592fab56198d5aba74_2.file.layout-full-width.tpl.php:101 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:186 (process) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/tacticalshoplayouts_layout_full_width_tpl/21/ce/9c/21ce9c4450f61fa801804652aca8224e94280476_2.file.layout-both-columns.tpl.php:94 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_696ff1f69aa703_49129424) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:115 (_subTemplateRender) /var/cache/prod/smarty/compile/tacticalshoplayouts_layout_full_width_tpl/95/40/98/9540981dd24b2e1ee9e1ab592fab56198d5aba74_2.file.layout-full-width.tpl.php:42 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_696ff1f6990274_50389007) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:115 (_subTemplateRender) /var/cache/prod/smarty/compile/tacticalshoplayouts_layout_full_width_tpl/c0/ae/43/c0ae436072faaac2f63ee6b48006dce9c16c1a88_2.file.product.tpl.php:56 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_697114877af8e4_95329253) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:115 (_subTemplateRender) /var/cache/prod/smarty/compile/tacticalshoplayouts_layout_full_width_tpl/75/f7/84/75f78462b4889e75d6c9b8c38f47834b47ec051b_2.file.product.tpl.php:52 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69711487766e19_01379308) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/controller/FrontController.php:771 (fetch) /classes/controller/FrontController.php:753 (smartyOutputContent) /tools/profiling/Controller.php:111 (display) /tools/profiling/Controller.php:88 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
307	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 `pbza_product_attribute` pa INNER JOIN pbza_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 pbza_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 `pbza_product_attribute_lang` `pal` ON pa.id_product_attribute = pal.id_product_attribute AND pal.id_lang = 3 LEFT JOIN `pbza_product_attribute_combination` `pac` ON pac.id_product_attribute = pa.id_product_attribute LEFT JOIN `pbza_attribute` `a` ON a.id_attribute = pac.id_attribute LEFT JOIN `pbza_attribute_group` `ag` ON ag.id_attribute_group = a.id_attribute_group LEFT JOIN `pbza_attribute_lang` `al` ON a.id_attribute = al.id_attribute LEFT JOIN `pbza_attribute_group_lang` `agl` ON ag.id_attribute_group = agl.id_attribute_group INNER JOIN pbza_attribute_shop attribute_shop ON (attribute_shop.id_attribute = a.id_attribute AND attribute_shop.id_shop = 1) WHERE (pa.id_product = 589) AND (al.id_lang = 3) AND (agl.id_lang = 3) GROUP BY id_attribute_group, id_product_attribute ORDER BY ag.position ASC, a.position ASC, agl.name ASC	1.665 ms	1	Yes	Yes	/classes/Product.php:4600 /controllers/front/ProductController.php:648 (getAttributesGroups) /controllers/front/ProductController.php:462 (assignAttributesGroups) /tools/profiling/Controller.php:65 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
344	SELECT SQL_NO_CACHE * FROM `pbza_product` a LEFT JOIN `pbza_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1 WHERE (a.`id_product` = 589) LIMIT 1	1.623 ms	1			/src/Adapter/EntityMapper.php:71 /classes/ObjectModel.php:283 (load) /tools/profiling/ObjectModel.php:32 (__construct) /classes/Product.php:725 (__construct) /src/Adapter/Presenter/Product/ProductLazyArray.php:658 (__construct) /src/Adapter/Presenter/Product/ProductLazyArray.php:505 (shouldShowOutOfStockLabel) /src/Adapter/Presenter/AbstractLazyArray.php:269 (getFlags) /var/cache/prod/smarty/compile/tacticalshoplayouts_layout_full_width_tpl/58/3a/62/583a6274c50191b39b94bf997b0292afe7d658bf_2.file.product-flags.tpl.php:44 (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/prod/smarty/compile/tacticalshoplayouts_layout_full_width_tpl/58/3a/62/583a6274c50191b39b94bf997b0292afe7d658bf_2.file.product-flags.tpl.php:26 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69711487850046_94775079) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /var/cache/prod/smarty/compile/tacticalshoplayouts_layout_full_width_tpl/c0/ae/43/c0ae436072faaac2f63ee6b48006dce9c16c1a88_2.file.product.tpl.php:130 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/tacticalshoplayouts_layout_full_width_tpl/c0/ae/43/c0ae436072faaac2f63ee6b48006dce9c16c1a88_2.file.product.tpl.php:154 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/tacticalshoplayouts_layout_full_width_tpl/c0/ae/43/c0ae436072faaac2f63ee6b48006dce9c16c1a88_2.file.product.tpl.php:790 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:186 (process) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/tacticalshoplayouts_layout_full_width_tpl/95/40/98/9540981dd24b2e1ee9e1ab592fab56198d5aba74_2.file.layout-full-width.tpl.php:101 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:186 (process) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/tacticalshoplayouts_layout_full_width_tpl/21/ce/9c/21ce9c4450f61fa801804652aca8224e94280476_2.file.layout-both-columns.tpl.php:94 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_696ff1f69aa703_49129424) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:115 (_subTemplateRender) /var/cache/prod/smarty/compile/tacticalshoplayouts_layout_full_width_tpl/95/40/98/9540981dd24b2e1ee9e1ab592fab56198d5aba74_2.file.layout-full-width.tpl.php:42 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_696ff1f6990274_50389007) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:115 (_subTemplateRender) /var/cache/prod/smarty/compile/tacticalshoplayouts_layout_full_width_tpl/c0/ae/43/c0ae436072faaac2f63ee6b48006dce9c16c1a88_2.file.product.tpl.php:56 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_697114877af8e4_95329253) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:115 (_subTemplateRender) /var/cache/prod/smarty/compile/tacticalshoplayouts_layout_full_width_tpl/75/f7/84/75f78462b4889e75d6c9b8c38f47834b47ec051b_2.file.product.tpl.php:52 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69711487766e19_01379308) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/controller/FrontController.php:771 (fetch) /classes/controller/FrontController.php:753 (smartyOutputContent) /tools/profiling/Controller.php:111 (display) /tools/profiling/Controller.php:88 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
666	SELECT SQL_NO_CACHE pac.id_product_attribute, GROUP_CONCAT(agl.`name`, ' - ',al.`name` ORDER BY agl.`id_attribute_group` SEPARATOR ', ') as attribute_designation FROM `pbza_product_attribute_combination` pac LEFT JOIN `pbza_attribute` a ON a.`id_attribute` = pac.`id_attribute` LEFT JOIN `pbza_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group` LEFT JOIN `pbza_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 3) LEFT JOIN `pbza_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 3) WHERE pac.id_product_attribute IN (3778,3784,3790,3796,3802,3808,3814,3820,3826,3832,3838,3844,3850,3856,3862,3868,3874,3880,3886,3892,3898,3904,3910,3916,3922,3928,3934,3940,3946,3952,3958,3964,3970,3976) GROUP BY pac.id_product_attribute ORDER BY pac.id_product_attribute	1.596 ms	68			/classes/Product.php:2746 /src/Adapter/Presenter/Product/ProductLazyArray.php:663 (getAttributesResume) /src/Adapter/Presenter/Product/ProductLazyArray.php:505 (shouldShowOutOfStockLabel) /src/Adapter/Presenter/AbstractLazyArray.php:269 (getFlags) /var/cache/prod/smarty/compile/tacticalshoplayouts_layout_full_width_tpl/58/3a/62/583a6274c50191b39b94bf997b0292afe7d658bf_2.file.product-flags.tpl.php:44 (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/prod/smarty/compile/tacticalshoplayouts_layout_full_width_tpl/58/3a/62/583a6274c50191b39b94bf997b0292afe7d658bf_2.file.product-flags.tpl.php:26 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69711487850046_94775079) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:384 (render) /var/cache/prod/smarty/compile/tacticalshoplayouts_layout_full_width_tpl/4f/20/74/4f2074cc9a10671087995e5913c0b696f1819436_2.file.product.tpl.php:279 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/tacticalshoplayouts_layout_full_width_tpl/4f/20/74/4f2074cc9a10671087995e5913c0b696f1819436_2.file.product.tpl.php:28 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_697127493220a1_87328373) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:384 (render) /var/cache/prod/smarty/compile/tacticalshoplayouts_layout_full_width_tpl/c0/ae/43/c0ae436072faaac2f63ee6b48006dce9c16c1a88_2.file.product.tpl.php:573 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/tacticalshoplayouts_layout_full_width_tpl/c0/ae/43/c0ae436072faaac2f63ee6b48006dce9c16c1a88_2.file.product.tpl.php:597 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/tacticalshoplayouts_layout_full_width_tpl/c0/ae/43/c0ae436072faaac2f63ee6b48006dce9c16c1a88_2.file.product.tpl.php:843 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:186 (process) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/tacticalshoplayouts_layout_full_width_tpl/95/40/98/9540981dd24b2e1ee9e1ab592fab56198d5aba74_2.file.layout-full-width.tpl.php:101 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:186 (process) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/tacticalshoplayouts_layout_full_width_tpl/21/ce/9c/21ce9c4450f61fa801804652aca8224e94280476_2.file.layout-both-columns.tpl.php:94 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_696ff1f69aa703_49129424) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:115 (_subTemplateRender) /var/cache/prod/smarty/compile/tacticalshoplayouts_layout_full_width_tpl/95/40/98/9540981dd24b2e1ee9e1ab592fab56198d5aba74_2.file.layout-full-width.tpl.php:42 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_696ff1f6990274_50389007) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:115 (_subTemplateRender) /var/cache/prod/smarty/compile/tacticalshoplayouts_layout_full_width_tpl/c0/ae/43/c0ae436072faaac2f63ee6b48006dce9c16c1a88_2.file.product.tpl.php:56 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_697114877af8e4_95329253) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:115 (_subTemplateRender) /var/cache/prod/smarty/compile/tacticalshoplayouts_layout_full_width_tpl/75/f7/84/75f78462b4889e75d6c9b8c38f47834b47ec051b_2.file.product.tpl.php:52 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69711487766e19_01379308) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/controller/FrontController.php:771 (fetch) /classes/controller/FrontController.php:753 (smartyOutputContent) /tools/profiling/Controller.php:111 (display) /tools/profiling/Controller.php:88 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
267	SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position` FROM `pbza_image` i INNER JOIN pbza_image_shop image_shop ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1) LEFT JOIN `pbza_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 3) WHERE i.`id_product` = 78 ORDER BY `position`	1.520 ms	50	Yes		/classes/Product.php:3539 /override/classes/Product.php:87 (getImages) /override/classes/Product.php:52 (coreGetImages) /src/Adapter/Image/ImageRetriever.php:84 (getImages) /src/Adapter/Presenter/Product/ProductLazyArray.php:683 (getAllProductImages) /src/Adapter/Presenter/Product/ProductLazyArray.php:126 (fillImages) /src/Adapter/Presenter/Product/ProductListingPresenter.php:49 (__construct) /controllers/front/ProductController.php:408 (present) /tools/profiling/Controller.php:65 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
704	SELECT SQL_NO_CACHE pac.id_product_attribute, GROUP_CONCAT(agl.`name`, ' - ',al.`name` ORDER BY agl.`id_attribute_group` SEPARATOR ', ') as attribute_designation FROM `pbza_product_attribute_combination` pac LEFT JOIN `pbza_attribute` a ON a.`id_attribute` = pac.`id_attribute` LEFT JOIN `pbza_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group` LEFT JOIN `pbza_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 3) LEFT JOIN `pbza_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 3) WHERE pac.id_product_attribute IN (3983,3989,3995,4001,4007,4013,4019,4025,4031,4037,4043,4049,4055,4061,4067,4073,4079,4085,4091,4097,4103,4109,4115,4121,4127,4133,4139,4145,4151,4157,4163,4169,4175,4181) GROUP BY pac.id_product_attribute ORDER BY pac.id_product_attribute	1.508 ms	68			/classes/Product.php:2746 /src/Adapter/Presenter/Product/ProductLazyArray.php:663 (getAttributesResume) /src/Adapter/Presenter/Product/ProductLazyArray.php:505 (shouldShowOutOfStockLabel) /src/Adapter/Presenter/AbstractLazyArray.php:269 (getFlags) /var/cache/prod/smarty/compile/tacticalshoplayouts_layout_full_width_tpl/58/3a/62/583a6274c50191b39b94bf997b0292afe7d658bf_2.file.product-flags.tpl.php:44 (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/prod/smarty/compile/tacticalshoplayouts_layout_full_width_tpl/58/3a/62/583a6274c50191b39b94bf997b0292afe7d658bf_2.file.product-flags.tpl.php:26 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69711487850046_94775079) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:384 (render) /var/cache/prod/smarty/compile/tacticalshoplayouts_layout_full_width_tpl/4f/20/74/4f2074cc9a10671087995e5913c0b696f1819436_2.file.product.tpl.php:279 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/tacticalshoplayouts_layout_full_width_tpl/4f/20/74/4f2074cc9a10671087995e5913c0b696f1819436_2.file.product.tpl.php:28 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_697127493220a1_87328373) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:384 (render) /var/cache/prod/smarty/compile/tacticalshoplayouts_layout_full_width_tpl/c0/ae/43/c0ae436072faaac2f63ee6b48006dce9c16c1a88_2.file.product.tpl.php:573 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/tacticalshoplayouts_layout_full_width_tpl/c0/ae/43/c0ae436072faaac2f63ee6b48006dce9c16c1a88_2.file.product.tpl.php:597 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/tacticalshoplayouts_layout_full_width_tpl/c0/ae/43/c0ae436072faaac2f63ee6b48006dce9c16c1a88_2.file.product.tpl.php:843 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:186 (process) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/tacticalshoplayouts_layout_full_width_tpl/95/40/98/9540981dd24b2e1ee9e1ab592fab56198d5aba74_2.file.layout-full-width.tpl.php:101 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:186 (process) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/tacticalshoplayouts_layout_full_width_tpl/21/ce/9c/21ce9c4450f61fa801804652aca8224e94280476_2.file.layout-both-columns.tpl.php:94 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_696ff1f69aa703_49129424) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:115 (_subTemplateRender) /var/cache/prod/smarty/compile/tacticalshoplayouts_layout_full_width_tpl/95/40/98/9540981dd24b2e1ee9e1ab592fab56198d5aba74_2.file.layout-full-width.tpl.php:42 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_696ff1f6990274_50389007) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:115 (_subTemplateRender) /var/cache/prod/smarty/compile/tacticalshoplayouts_layout_full_width_tpl/c0/ae/43/c0ae436072faaac2f63ee6b48006dce9c16c1a88_2.file.product.tpl.php:56 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_697114877af8e4_95329253) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:115 (_subTemplateRender) /var/cache/prod/smarty/compile/tacticalshoplayouts_layout_full_width_tpl/75/f7/84/75f78462b4889e75d6c9b8c38f47834b47ec051b_2.file.product.tpl.php:52 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69711487766e19_01379308) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/controller/FrontController.php:771 (fetch) /classes/controller/FrontController.php:753 (smartyOutputContent) /tools/profiling/Controller.php:111 (display) /tools/profiling/Controller.php:88 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
283	SELECT SQL_NO_CACHE pai.`id_image`, pai.`id_product_attribute`, il.`legend` FROM `pbza_product_attribute_image` pai LEFT JOIN `pbza_image_lang` il ON (il.`id_image` = pai.`id_image`) LEFT JOIN `pbza_image` i ON (i.`id_image` = pai.`id_image`) WHERE pai.`id_product_attribute` IN (3374, 3380, 3386, 3392, 3398, 3404, 3410, 3416, 3422, 3428, 3434, 3440, 3446, 3452, 3458, 3464, 3470, 3476, 3482, 3488, 3494, 3500, 3506, 3512, 3518, 3524, 3530, 3536, 3542, 3548, 3554, 3560, 3566, 3368) AND il.`id_lang` = 3 ORDER by i.`position`	1.504 ms	271	Yes		/classes/Product.php:2915 /src/Adapter/Image/ImageRetriever.php:90 (getCombinationImages) /src/Adapter/Presenter/Product/ProductLazyArray.php:683 (getAllProductImages) /src/Adapter/Presenter/Product/ProductLazyArray.php:126 (fillImages) /src/Adapter/Presenter/Product/ProductListingPresenter.php:49 (__construct) /controllers/front/ProductController.php:408 (present) /tools/profiling/Controller.php:65 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
590	SELECT SQL_NO_CACHE pac.id_product_attribute, GROUP_CONCAT(agl.`name`, ' - ',al.`name` ORDER BY agl.`id_attribute_group` SEPARATOR ', ') as attribute_designation FROM `pbza_product_attribute_combination` pac LEFT JOIN `pbza_attribute` a ON a.`id_attribute` = pac.`id_attribute` LEFT JOIN `pbza_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group` LEFT JOIN `pbza_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 3) LEFT JOIN `pbza_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 3) WHERE pac.id_product_attribute IN (3368,3374,3380,3386,3392,3398,3404,3410,3416,3422,3428,3434,3440,3446,3452,3458,3464,3470,3476,3482,3488,3494,3500,3506,3512,3518,3524,3530,3536,3542,3548,3554,3560,3566) GROUP BY pac.id_product_attribute ORDER BY pac.id_product_attribute	1.477 ms	68			/classes/Product.php:2746 /src/Adapter/Presenter/Product/ProductLazyArray.php:663 (getAttributesResume) /src/Adapter/Presenter/Product/ProductLazyArray.php:505 (shouldShowOutOfStockLabel) /src/Adapter/Presenter/AbstractLazyArray.php:269 (getFlags) /var/cache/prod/smarty/compile/tacticalshoplayouts_layout_full_width_tpl/58/3a/62/583a6274c50191b39b94bf997b0292afe7d658bf_2.file.product-flags.tpl.php:44 (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/prod/smarty/compile/tacticalshoplayouts_layout_full_width_tpl/58/3a/62/583a6274c50191b39b94bf997b0292afe7d658bf_2.file.product-flags.tpl.php:26 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69711487850046_94775079) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:384 (render) /var/cache/prod/smarty/compile/tacticalshoplayouts_layout_full_width_tpl/4f/20/74/4f2074cc9a10671087995e5913c0b696f1819436_2.file.product.tpl.php:279 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/tacticalshoplayouts_layout_full_width_tpl/4f/20/74/4f2074cc9a10671087995e5913c0b696f1819436_2.file.product.tpl.php:28 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_697127493220a1_87328373) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:384 (render) /var/cache/prod/smarty/compile/tacticalshoplayouts_layout_full_width_tpl/c0/ae/43/c0ae436072faaac2f63ee6b48006dce9c16c1a88_2.file.product.tpl.php:573 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/tacticalshoplayouts_layout_full_width_tpl/c0/ae/43/c0ae436072faaac2f63ee6b48006dce9c16c1a88_2.file.product.tpl.php:597 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/tacticalshoplayouts_layout_full_width_tpl/c0/ae/43/c0ae436072faaac2f63ee6b48006dce9c16c1a88_2.file.product.tpl.php:843 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:186 (process) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/tacticalshoplayouts_layout_full_width_tpl/95/40/98/9540981dd24b2e1ee9e1ab592fab56198d5aba74_2.file.layout-full-width.tpl.php:101 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:186 (process) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/tacticalshoplayouts_layout_full_width_tpl/21/ce/9c/21ce9c4450f61fa801804652aca8224e94280476_2.file.layout-both-columns.tpl.php:94 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_696ff1f69aa703_49129424) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:115 (_subTemplateRender) /var/cache/prod/smarty/compile/tacticalshoplayouts_layout_full_width_tpl/95/40/98/9540981dd24b2e1ee9e1ab592fab56198d5aba74_2.file.layout-full-width.tpl.php:42 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_696ff1f6990274_50389007) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:115 (_subTemplateRender) /var/cache/prod/smarty/compile/tacticalshoplayouts_layout_full_width_tpl/c0/ae/43/c0ae436072faaac2f63ee6b48006dce9c16c1a88_2.file.product.tpl.php:56 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_697114877af8e4_95329253) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:115 (_subTemplateRender) /var/cache/prod/smarty/compile/tacticalshoplayouts_layout_full_width_tpl/75/f7/84/75f78462b4889e75d6c9b8c38f47834b47ec051b_2.file.product.tpl.php:52 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69711487766e19_01379308) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/controller/FrontController.php:771 (fetch) /classes/controller/FrontController.php:753 (smartyOutputContent) /tools/profiling/Controller.php:111 (display) /tools/profiling/Controller.php:88 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
474	SELECT SQL_NO_CACHE pac.id_product_attribute, GROUP_CONCAT(agl.`name`, ' - ',al.`name` ORDER BY agl.`id_attribute_group` SEPARATOR ', ') as attribute_designation FROM `pbza_product_attribute_combination` pac LEFT JOIN `pbza_attribute` a ON a.`id_attribute` = pac.`id_attribute` LEFT JOIN `pbza_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group` LEFT JOIN `pbza_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 3) LEFT JOIN `pbza_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 3) WHERE pac.id_product_attribute IN (629,635,641,647,653,659,665,671,677,683,689,695,701,707,713,719,725,731,737,743,749,755,761,767,773,779,785,791,797,803,809,815,821,827) GROUP BY pac.id_product_attribute ORDER BY pac.id_product_attribute	1.468 ms	68			/classes/Product.php:2746 /src/Adapter/Presenter/Product/ProductLazyArray.php:663 (getAttributesResume) /src/Adapter/Presenter/Product/ProductLazyArray.php:505 (shouldShowOutOfStockLabel) /src/Adapter/Presenter/AbstractLazyArray.php:269 (getFlags) /var/cache/prod/smarty/compile/tacticalshoplayouts_layout_full_width_tpl/58/3a/62/583a6274c50191b39b94bf997b0292afe7d658bf_2.file.product-flags.tpl.php:44 (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/prod/smarty/compile/tacticalshoplayouts_layout_full_width_tpl/58/3a/62/583a6274c50191b39b94bf997b0292afe7d658bf_2.file.product-flags.tpl.php:26 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69711487850046_94775079) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:384 (render) /var/cache/prod/smarty/compile/tacticalshoplayouts_layout_full_width_tpl/4f/20/74/4f2074cc9a10671087995e5913c0b696f1819436_2.file.product.tpl.php:279 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/tacticalshoplayouts_layout_full_width_tpl/4f/20/74/4f2074cc9a10671087995e5913c0b696f1819436_2.file.product.tpl.php:28 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_697127493220a1_87328373) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:384 (render) /var/cache/prod/smarty/compile/tacticalshoplayouts_layout_full_width_tpl/c0/ae/43/c0ae436072faaac2f63ee6b48006dce9c16c1a88_2.file.product.tpl.php:573 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/tacticalshoplayouts_layout_full_width_tpl/c0/ae/43/c0ae436072faaac2f63ee6b48006dce9c16c1a88_2.file.product.tpl.php:597 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/tacticalshoplayouts_layout_full_width_tpl/c0/ae/43/c0ae436072faaac2f63ee6b48006dce9c16c1a88_2.file.product.tpl.php:843 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:186 (process) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/tacticalshoplayouts_layout_full_width_tpl/95/40/98/9540981dd24b2e1ee9e1ab592fab56198d5aba74_2.file.layout-full-width.tpl.php:101 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:186 (process) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/tacticalshoplayouts_layout_full_width_tpl/21/ce/9c/21ce9c4450f61fa801804652aca8224e94280476_2.file.layout-both-columns.tpl.php:94 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_696ff1f69aa703_49129424) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:115 (_subTemplateRender) /var/cache/prod/smarty/compile/tacticalshoplayouts_layout_full_width_tpl/95/40/98/9540981dd24b2e1ee9e1ab592fab56198d5aba74_2.file.layout-full-width.tpl.php:42 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_696ff1f6990274_50389007) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:115 (_subTemplateRender) /var/cache/prod/smarty/compile/tacticalshoplayouts_layout_full_width_tpl/c0/ae/43/c0ae436072faaac2f63ee6b48006dce9c16c1a88_2.file.product.tpl.php:56 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_697114877af8e4_95329253) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:115 (_subTemplateRender) /var/cache/prod/smarty/compile/tacticalshoplayouts_layout_full_width_tpl/75/f7/84/75f78462b4889e75d6c9b8c38f47834b47ec051b_2.file.product.tpl.php:52 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69711487766e19_01379308) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/controller/FrontController.php:771 (fetch) /classes/controller/FrontController.php:753 (smartyOutputContent) /tools/profiling/Controller.php:111 (display) /tools/profiling/Controller.php:88 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
513	SELECT SQL_NO_CACHE pac.id_product_attribute, GROUP_CONCAT(agl.`name`, ' - ',al.`name` ORDER BY agl.`id_attribute_group` SEPARATOR ', ') as attribute_designation FROM `pbza_product_attribute_combination` pac LEFT JOIN `pbza_attribute` a ON a.`id_attribute` = pac.`id_attribute` LEFT JOIN `pbza_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group` LEFT JOIN `pbza_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 3) LEFT JOIN `pbza_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 3) WHERE pac.id_product_attribute IN (2525,2526,2527,2528,2529,2530,2531,2532,2533,2534,2535,2536,2537,2538,2539,2540,2541,2542,2543,2544,2545,2546,2547,2548,2549,2550,2551,2552,2553,2554,2555,2556,2557,2558,2559) GROUP BY pac.id_product_attribute ORDER BY pac.id_product_attribute	1.459 ms	70			/classes/Product.php:2746 /src/Adapter/Presenter/Product/ProductLazyArray.php:663 (getAttributesResume) /src/Adapter/Presenter/Product/ProductLazyArray.php:505 (shouldShowOutOfStockLabel) /src/Adapter/Presenter/AbstractLazyArray.php:269 (getFlags) /var/cache/prod/smarty/compile/tacticalshoplayouts_layout_full_width_tpl/58/3a/62/583a6274c50191b39b94bf997b0292afe7d658bf_2.file.product-flags.tpl.php:44 (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/prod/smarty/compile/tacticalshoplayouts_layout_full_width_tpl/58/3a/62/583a6274c50191b39b94bf997b0292afe7d658bf_2.file.product-flags.tpl.php:26 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69711487850046_94775079) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:384 (render) /var/cache/prod/smarty/compile/tacticalshoplayouts_layout_full_width_tpl/4f/20/74/4f2074cc9a10671087995e5913c0b696f1819436_2.file.product.tpl.php:279 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/tacticalshoplayouts_layout_full_width_tpl/4f/20/74/4f2074cc9a10671087995e5913c0b696f1819436_2.file.product.tpl.php:28 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_697127493220a1_87328373) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:384 (render) /var/cache/prod/smarty/compile/tacticalshoplayouts_layout_full_width_tpl/c0/ae/43/c0ae436072faaac2f63ee6b48006dce9c16c1a88_2.file.product.tpl.php:573 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/tacticalshoplayouts_layout_full_width_tpl/c0/ae/43/c0ae436072faaac2f63ee6b48006dce9c16c1a88_2.file.product.tpl.php:597 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/tacticalshoplayouts_layout_full_width_tpl/c0/ae/43/c0ae436072faaac2f63ee6b48006dce9c16c1a88_2.file.product.tpl.php:843 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:186 (process) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/tacticalshoplayouts_layout_full_width_tpl/95/40/98/9540981dd24b2e1ee9e1ab592fab56198d5aba74_2.file.layout-full-width.tpl.php:101 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:186 (process) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/tacticalshoplayouts_layout_full_width_tpl/21/ce/9c/21ce9c4450f61fa801804652aca8224e94280476_2.file.layout-both-columns.tpl.php:94 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_696ff1f69aa703_49129424) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:115 (_subTemplateRender) /var/cache/prod/smarty/compile/tacticalshoplayouts_layout_full_width_tpl/95/40/98/9540981dd24b2e1ee9e1ab592fab56198d5aba74_2.file.layout-full-width.tpl.php:42 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_696ff1f6990274_50389007) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:115 (_subTemplateRender) /var/cache/prod/smarty/compile/tacticalshoplayouts_layout_full_width_tpl/c0/ae/43/c0ae436072faaac2f63ee6b48006dce9c16c1a88_2.file.product.tpl.php:56 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_697114877af8e4_95329253) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:115 (_subTemplateRender) /var/cache/prod/smarty/compile/tacticalshoplayouts_layout_full_width_tpl/75/f7/84/75f78462b4889e75d6c9b8c38f47834b47ec051b_2.file.product.tpl.php:52 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69711487766e19_01379308) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/controller/FrontController.php:771 (fetch) /classes/controller/FrontController.php:753 (smartyOutputContent) /tools/profiling/Controller.php:111 (display) /tools/profiling/Controller.php:88 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
628	SELECT SQL_NO_CACHE pac.id_product_attribute, GROUP_CONCAT(agl.`name`, ' - ',al.`name` ORDER BY agl.`id_attribute_group` SEPARATOR ', ') as attribute_designation FROM `pbza_product_attribute_combination` pac LEFT JOIN `pbza_attribute` a ON a.`id_attribute` = pac.`id_attribute` LEFT JOIN `pbza_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group` LEFT JOIN `pbza_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 3) LEFT JOIN `pbza_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 3) WHERE pac.id_product_attribute IN (3576,3582,3588,3594,3600,3606,3612,3618,3624,3630,3636,3642,3648,3654,3660,3666,3672,3678,3684,3690,3696,3702,3708,3714,3720,3726,3732,3738,3744,3750,3756,3762,3768,3774) GROUP BY pac.id_product_attribute ORDER BY pac.id_product_attribute	1.443 ms	68			/classes/Product.php:2746 /src/Adapter/Presenter/Product/ProductLazyArray.php:663 (getAttributesResume) /src/Adapter/Presenter/Product/ProductLazyArray.php:505 (shouldShowOutOfStockLabel) /src/Adapter/Presenter/AbstractLazyArray.php:269 (getFlags) /var/cache/prod/smarty/compile/tacticalshoplayouts_layout_full_width_tpl/58/3a/62/583a6274c50191b39b94bf997b0292afe7d658bf_2.file.product-flags.tpl.php:44 (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/prod/smarty/compile/tacticalshoplayouts_layout_full_width_tpl/58/3a/62/583a6274c50191b39b94bf997b0292afe7d658bf_2.file.product-flags.tpl.php:26 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69711487850046_94775079) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:384 (render) /var/cache/prod/smarty/compile/tacticalshoplayouts_layout_full_width_tpl/4f/20/74/4f2074cc9a10671087995e5913c0b696f1819436_2.file.product.tpl.php:279 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/tacticalshoplayouts_layout_full_width_tpl/4f/20/74/4f2074cc9a10671087995e5913c0b696f1819436_2.file.product.tpl.php:28 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_697127493220a1_87328373) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:384 (render) /var/cache/prod/smarty/compile/tacticalshoplayouts_layout_full_width_tpl/c0/ae/43/c0ae436072faaac2f63ee6b48006dce9c16c1a88_2.file.product.tpl.php:573 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/tacticalshoplayouts_layout_full_width_tpl/c0/ae/43/c0ae436072faaac2f63ee6b48006dce9c16c1a88_2.file.product.tpl.php:597 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/tacticalshoplayouts_layout_full_width_tpl/c0/ae/43/c0ae436072faaac2f63ee6b48006dce9c16c1a88_2.file.product.tpl.php:843 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:186 (process) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/tacticalshoplayouts_layout_full_width_tpl/95/40/98/9540981dd24b2e1ee9e1ab592fab56198d5aba74_2.file.layout-full-width.tpl.php:101 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:186 (process) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/tacticalshoplayouts_layout_full_width_tpl/21/ce/9c/21ce9c4450f61fa801804652aca8224e94280476_2.file.layout-both-columns.tpl.php:94 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_696ff1f69aa703_49129424) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:115 (_subTemplateRender) /var/cache/prod/smarty/compile/tacticalshoplayouts_layout_full_width_tpl/95/40/98/9540981dd24b2e1ee9e1ab592fab56198d5aba74_2.file.layout-full-width.tpl.php:42 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_696ff1f6990274_50389007) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:115 (_subTemplateRender) /var/cache/prod/smarty/compile/tacticalshoplayouts_layout_full_width_tpl/c0/ae/43/c0ae436072faaac2f63ee6b48006dce9c16c1a88_2.file.product.tpl.php:56 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_697114877af8e4_95329253) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:115 (_subTemplateRender) /var/cache/prod/smarty/compile/tacticalshoplayouts_layout_full_width_tpl/75/f7/84/75f78462b4889e75d6c9b8c38f47834b47ec051b_2.file.product.tpl.php:52 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69711487766e19_01379308) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/controller/FrontController.php:771 (fetch) /classes/controller/FrontController.php:753 (smartyOutputContent) /tools/profiling/Controller.php:111 (display) /tools/profiling/Controller.php:88 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
552	SELECT SQL_NO_CACHE pac.id_product_attribute, GROUP_CONCAT(agl.`name`, ' - ',al.`name` ORDER BY agl.`id_attribute_group` SEPARATOR ', ') as attribute_designation FROM `pbza_product_attribute_combination` pac LEFT JOIN `pbza_attribute` a ON a.`id_attribute` = pac.`id_attribute` LEFT JOIN `pbza_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group` LEFT JOIN `pbza_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 3) LEFT JOIN `pbza_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 3) WHERE pac.id_product_attribute IN (3165,3171,3177,3183,3189,3195,3201,3207,3213,3219,3225,3231,3237,3243,3249,3255,3261,3267,3273,3279,3285,3291,3297,3303,3309,3315,3321,3327,3333,3339,3345,3351,3357,3363) GROUP BY pac.id_product_attribute ORDER BY pac.id_product_attribute	1.411 ms	68			/classes/Product.php:2746 /src/Adapter/Presenter/Product/ProductLazyArray.php:663 (getAttributesResume) /src/Adapter/Presenter/Product/ProductLazyArray.php:505 (shouldShowOutOfStockLabel) /src/Adapter/Presenter/AbstractLazyArray.php:269 (getFlags) /var/cache/prod/smarty/compile/tacticalshoplayouts_layout_full_width_tpl/58/3a/62/583a6274c50191b39b94bf997b0292afe7d658bf_2.file.product-flags.tpl.php:44 (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/prod/smarty/compile/tacticalshoplayouts_layout_full_width_tpl/58/3a/62/583a6274c50191b39b94bf997b0292afe7d658bf_2.file.product-flags.tpl.php:26 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69711487850046_94775079) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:384 (render) /var/cache/prod/smarty/compile/tacticalshoplayouts_layout_full_width_tpl/4f/20/74/4f2074cc9a10671087995e5913c0b696f1819436_2.file.product.tpl.php:279 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/tacticalshoplayouts_layout_full_width_tpl/4f/20/74/4f2074cc9a10671087995e5913c0b696f1819436_2.file.product.tpl.php:28 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_697127493220a1_87328373) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:384 (render) /var/cache/prod/smarty/compile/tacticalshoplayouts_layout_full_width_tpl/c0/ae/43/c0ae436072faaac2f63ee6b48006dce9c16c1a88_2.file.product.tpl.php:573 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/tacticalshoplayouts_layout_full_width_tpl/c0/ae/43/c0ae436072faaac2f63ee6b48006dce9c16c1a88_2.file.product.tpl.php:597 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/tacticalshoplayouts_layout_full_width_tpl/c0/ae/43/c0ae436072faaac2f63ee6b48006dce9c16c1a88_2.file.product.tpl.php:843 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:186 (process) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/tacticalshoplayouts_layout_full_width_tpl/95/40/98/9540981dd24b2e1ee9e1ab592fab56198d5aba74_2.file.layout-full-width.tpl.php:101 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:186 (process) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/tacticalshoplayouts_layout_full_width_tpl/21/ce/9c/21ce9c4450f61fa801804652aca8224e94280476_2.file.layout-both-columns.tpl.php:94 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_696ff1f69aa703_49129424) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:115 (_subTemplateRender) /var/cache/prod/smarty/compile/tacticalshoplayouts_layout_full_width_tpl/95/40/98/9540981dd24b2e1ee9e1ab592fab56198d5aba74_2.file.layout-full-width.tpl.php:42 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_696ff1f6990274_50389007) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:115 (_subTemplateRender) /var/cache/prod/smarty/compile/tacticalshoplayouts_layout_full_width_tpl/c0/ae/43/c0ae436072faaac2f63ee6b48006dce9c16c1a88_2.file.product.tpl.php:56 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_697114877af8e4_95329253) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:115 (_subTemplateRender) /var/cache/prod/smarty/compile/tacticalshoplayouts_layout_full_width_tpl/75/f7/84/75f78462b4889e75d6c9b8c38f47834b47ec051b_2.file.product.tpl.php:52 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69711487766e19_01379308) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/controller/FrontController.php:771 (fetch) /classes/controller/FrontController.php:753 (smartyOutputContent) /tools/profiling/Controller.php:111 (display) /tools/profiling/Controller.php:88 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
107	SELECT SQL_NO_CACHE SUM(quantity) FROM `pbza_stock_available` WHERE (id_product = 589) AND (id_product_attribute = 4291) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1	1.386 ms	1			/classes/stock/StockAvailable.php:453 /classes/Product.php:2824 (getQuantityAvailableByProduct) /controllers/front/ProductController.php:1101 (getAttributeCombinations) /controllers/front/ProductController.php:1085 (tryToGetAvailableIdProductAttribute) /controllers/front/ProductController.php:608 (getIdProductAttributeByGroupOrRequestOrDefault) /controllers/front/ProductController.php:370 (assignPriceAndTax) /tools/profiling/Controller.php:65 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
106	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 `pbza_product_attribute` pa INNER JOIN pbza_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 `pbza_product_attribute_combination` pac ON pac.`id_product_attribute` = pa.`id_product_attribute` LEFT JOIN `pbza_attribute` a ON a.`id_attribute` = pac.`id_attribute` LEFT JOIN `pbza_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group` LEFT JOIN `pbza_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 3) LEFT JOIN `pbza_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 3) LEFT JOIN `pbza_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` = 589 GROUP BY pa.`id_product_attribute`, ag.`id_attribute_group` ORDER BY pa.`id_product_attribute`	1.274 ms	2	Yes	Yes	/classes/Product.php:2815 /controllers/front/ProductController.php:1101 (getAttributeCombinations) /controllers/front/ProductController.php:1085 (tryToGetAvailableIdProductAttribute) /controllers/front/ProductController.php:608 (getIdProductAttributeByGroupOrRequestOrDefault) /controllers/front/ProductController.php:370 (assignPriceAndTax) /tools/profiling/Controller.php:65 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
14	SELECT SQL_NO_CACHE lower(name) as name FROM `pbza_hook` h WHERE (h.active = 1)	1.153 ms	1177			/classes/Hook.php:1388 /classes/Hook.php:817 (getHookStatusByName) /classes/Dispatcher.php:606 (exec) /classes/Dispatcher.php:243 (loadRoutes) /override/classes/Dispatcher.php:48 (__construct) /classes/Dispatcher.php:201 (__construct) /index.php:28 (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/include_paths.php
9	/vendor/composer/autoload_static.php
10	/vendor/symfony/polyfill-php72/bootstrap.php
11	/vendor/symfony/polyfill-mbstring/bootstrap.php
12	/vendor/symfony/polyfill-mbstring/bootstrap80.php
13	/vendor/symfony/polyfill-intl-normalizer/bootstrap.php
14	/vendor/symfony/polyfill-intl-normalizer/bootstrap80.php
15	/vendor/symfony/polyfill-intl-idn/bootstrap.php
16	/vendor/symfony/deprecation-contracts/function.php
17	/vendor/ralouphie/getallheaders/src/getallheaders.php
18	/vendor/symfony/polyfill-ctype/bootstrap.php
19	/vendor/symfony/polyfill-ctype/bootstrap80.php
20	/vendor/symfony/polyfill-php80/bootstrap.php
21	/vendor/guzzlehttp/promises/src/functions_include.php
22	/vendor/guzzlehttp/promises/src/functions.php
23	/vendor/guzzlehttp/guzzle/src/functions_include.php
24	/vendor/guzzlehttp/guzzle/src/functions.php
25	/vendor/symfony/polyfill-iconv/bootstrap.php
26	/vendor/ezyang/htmlpurifier/library/HTMLPurifier.composer.php
27	/vendor/jakeasmith/http_build_url/src/http_build_url.php
28	/vendor/lcobucci/jwt/compat/class-aliases.php
29	/vendor/lcobucci/jwt/src/Token.php
30	/vendor/lcobucci/jwt/src/Signature.php
31	/vendor/lcobucci/jwt/compat/json-exception-polyfill.php
32	/vendor/lcobucci/jwt/compat/lcobucci-clock-polyfill.php
33	/vendor/swiftmailer/swiftmailer/lib/swift_required.php
34	/vendor/swiftmailer/swiftmailer/lib/classes/Swift.php
35	/vendor/symfony/polyfill-intl-icu/bootstrap.php
36	/vendor/symfony/polyfill-php73/bootstrap.php
37	/vendor/symfony/polyfill-php81/bootstrap.php
38	/vendor/api-platform/core/src/deprecation.php
39	/vendor/api-platform/core/src/Api/FilterInterface.php