Femme

Trier par :

Vue

Il y a 11 produits.

PENTALON PLUIE MIXTE

Produit disponible avec d'autres options

Ce pantalon taille haute unisexe est fabriqué dans un matériau imperméable, extensible et respirant qui offre une protection confortable contre le vent et les intempéries.

117,00 €

Détails Voir les détails

VESTE DE PLUIE MIXTE

Cette veste de pluie unisexe est fabriquée dans un matériau imperméable, extensible et respirant qui offre une protection confortable contre le vent et les intempéries.

170,00 €

CHEMISE KANSAS

Produit disponible avec d'autres options

Une chemise à carreaux audacieuse digne d’une audacieuse entreprise de motos américaine.

123,00 €

Détails Voir les détails

CHEMISE EN JEAN ALEX

Derniers articles en stock

Cette veste en jean vous offre un style décontracté avec la protection d'une veste de moto.

352,00 €

VESTE MATELASSE

Derniers articles en stock

Un gilet matelassé léger avec des panneaux latéraux extensibles et une grande marque au dos.

115,00 €

CHEMISE A CARREAUX GREY

Derniers articles en stock

Décontracté, confortable et fier d'Indian Motorcycle.

93,00 €

CHEMISE A CARREAUX

Produit disponible avec d'autres options

Si vous pensez qu'il n'y a aucun moyen d'améliorer une chemise à carreaux classique, vous n'avez jamais porté de chemise à carreaux classique arborant le logo de la première entreprise de motos d'Amérique.

101,00 €

Détails Voir les détails

VESTE CUIR LINDY

Lors d'une promenade par temps chaud, les gilets offrent une protection sans ajouter trop de chaleur ou d'encombrement. Et avec un logo audacieux comme celui-ci, ils permettent à tout le monde de savoir où se trouve votre allégeance.

290,00 €

VESTE DE PLUIE

Rupture de stock, appelez nous : 02 41 69 93 54

Si vous faites de la moto depuis plus de quelques mois, vous avez déjà pu en faire l’expérience : même la pluie ne saurait vous priver du plaisir de rouler. Surtout quand vous avez le bon équipement.

164,00 €

Détails Voir les détails

CHEMISE ICON PLAID SHIRT

Produit disponible avec d'autres options

Restez au chaud, restez fier.

93,00 €

Détails Voir les détails

PANTALON PLUIE MIXTE, NOIR

Produit disponible avec d'autres options

Une bonne balade même par mauvais temps ? Facile quand vous avez le bon équipement.

122,00 €

Détails Voir les détails

Load Time	599.367 ms
Querying Time	259 ms
Queries	390
Memory Peak Usage	12.0 Mb
Included Files	1237 files - 11.70 Mb
PrestaShop Cache	- Mb
Global vars	0.31 Mb
- global $_MODULES	282k
- global $_SERVER	7k
- global $config	5k
- global $_MODULE	5k
- global $context	3k
- global $__composer_autoload_files	3k
- global $exportPhpConfigFile	3k
- global $_COOKIE	2k
- global $smarty	1k

PrestaShop Version	8.1.2
PHP Version	8.1.32
MySQL Version	10.3.39-MariaDB-0+deb10u2
Memory Limit	1024M
Max Execution Time	0s
Smarty Cache	enabled
Smarty Compilation	force compile

	Time	Cumulated Time	Memory Usage	Memory Peak Usage
config	0.975 ms	0.975 ms	2.65 Mb	2.6 Mb
__construct	0.854 ms	1.829 ms	- Mb	3.2 Mb
init	13.569 ms	15.398 ms	0.68 Mb	3.7 Mb
checkAccess	0.001 ms	15.399 ms	- Mb	3.7 Mb
setMedia	2.020 ms	17.419 ms	0.28 Mb	3.7 Mb
postProcess	0.001 ms	17.420 ms	- Mb	3.7 Mb
initHeader	0.000 ms	17.420 ms	- Mb	3.7 Mb
initContent	275.934 ms	293.354 ms	4.91 Mb	8.7 Mb
initFooter	0.002 ms	293.356 ms	- Mb	8.7 Mb
display	306.011 ms	599.367 ms	3.14 Mb	12.0 Mb

Hook	Time	Memory Usage
displayProductListReviews	161.765 ms	0.34 Mb
=> productcomments (widget)	9.781 ms	0.29 Mb
=> productcomments (widget)	12.760 ms	0.01 Mb
=> productcomments (widget)	1.466 ms	- Mb
=> productcomments (widget)	61.193 ms	- Mb
=> productcomments (widget)	1.470 ms	- Mb
=> productcomments (widget)	69.979 ms	- Mb
=> productcomments (widget)	1.454 ms	- Mb
=> productcomments (widget)	1.422 ms	- Mb
=> productcomments (widget)	0.764 ms	- Mb
=> productcomments (widget)	0.748 ms	- Mb
=> productcomments (widget)	0.728 ms	- Mb
displayTop	5.318 ms	0.20 Mb
=> ps_searchbar (widget)	0.638 ms	0.05 Mb
=> ps_customersignin (widget)	1.058 ms	0.06 Mb
=> ps_shoppingcart (widget)	3.622 ms	0.08 Mb
DisplayBeforeBodyClosingTag	4.937 ms	0.36 Mb
=> statsdata	0.602 ms	0.05 Mb
=> ps_googleanalytics	4.335 ms	0.31 Mb
DisplayFooter	4.147 ms	0.11 Mb
=> blockwishlist	4.147 ms	0.11 Mb
DisplayHeader	3.759 ms	0.25 Mb
=> seoexpert	0.064 ms	0.02 Mb
=> ps_googleanalytics	2.291 ms	0.12 Mb
=> ps_shoppingcart	0.032 ms	- Mb
=> productcomments	0.066 ms	- Mb
=> chronopost	0.004 ms	- Mb
=> colissimo	0.003 ms	- Mb
=> ps_searchbar	0.123 ms	- Mb
=> zonecolorsfonts	0.515 ms	0.04 Mb
=> zonethememanager	0.661 ms	0.07 Mb
displayLeftColumn	3.666 ms	0.36 Mb
=> ps_categorytree (widget)	3.666 ms	0.36 Mb
displayFooterRight	1.364 ms	0.07 Mb
=> ps_emailsubscription (widget)	1.364 ms	0.07 Mb
DisplayLeftColumn	0.717 ms	0.06 Mb
=> ps_facetedsearch	0.471 ms	0.03 Mb
=> zonecolumnblocks	0.246 ms	0.03 Mb
DisplayOutsideMainPage	0.499 ms	0.03 Mb
=> zonepopupnewsletter	0.174 ms	0.01 Mb
=> zonecolorsfonts	0.170 ms	0.01 Mb
=> zonethememanager	0.155 ms	0.01 Mb
ActionFrontControllerSetMedia	0.437 ms	0.01 Mb
=> ps_emailsubscription	0.102 ms	- Mb
=> blockreassurance	0.058 ms	- Mb
=> psrecaptcha	0.044 ms	- Mb
=> ps_emailalerts	0.018 ms	- Mb
=> blockwishlist	0.130 ms	- Mb
=> ps_socialfollow	0.036 ms	- Mb
=> chronopost	0.049 ms	- Mb
displayFooterLeft	0.347 ms	0.06 Mb
=> ps_socialfollow (widget)	0.347 ms	0.06 Mb
displayNav2	0.337 ms	0.08 Mb
=> ps_languageselector (widget)	0.192 ms	0.04 Mb
=> ps_currencyselector (widget)	0.145 ms	0.04 Mb
DisplayFooterLeft	0.210 ms	0.01 Mb
=> zonethememanager	0.210 ms	0.01 Mb
DisplaySidebarNavigation	0.207 ms	0.01 Mb
=> zonethememanager	0.207 ms	0.01 Mb
ProductSearchProvider	0.197 ms	- Mb
=> ps_facetedsearch	0.197 ms	- Mb
DisplayNavFullWidth	0.195 ms	0.02 Mb
=> zonemegamenu	0.195 ms	0.02 Mb
DisplayFooterRight	0.195 ms	0.01 Mb
=> zonethememanager	0.195 ms	0.01 Mb
DisplayBanner	0.193 ms	0.01 Mb
=> zonethememanager	0.193 ms	0.01 Mb
DisplayFooterAfter	0.192 ms	0.01 Mb
=> zonethememanager	0.192 ms	0.01 Mb
DisplayNav1	0.157 ms	0.01 Mb
=> zonethememanager	0.157 ms	0.01 Mb
DisplayAfterBodyOpeningTag	0.005 ms	- Mb
=> blockreassurance	0.005 ms	- Mb
DisplayFooterBefore	0.005 ms	- Mb
=> blockreassurance	0.005 ms	- Mb
ModuleRoutes	0.003 ms	- Mb
=> colissimo	0.003 ms	- Mb
23 hook(s)	188.852 ms	2.00 Mb

Module	Time	Memory Usage
colissimo	1.668 ms	0.14 Mb
__construct	1.659 ms	0.14 Mb
hookModuleRoutes	0.006 ms	- Mb
hookDisplayHeader	0.003 ms	- Mb
ps_emailsubscription	1.984 ms	0.13 Mb
__construct	0.515 ms	0.06 Mb
hookActionFrontControllerSetMedia	0.104 ms	- Mb
displayFooterRight	1.365 ms	0.07 Mb
blockreassurance	0.154 ms	0.02 Mb
__construct	0.081 ms	0.01 Mb
hookActionFrontControllerSetMedia	0.059 ms	- Mb
hookDisplayAfterBodyOpeningTag	0.008 ms	- Mb
hookDisplayFooterBefore	0.006 ms	- Mb
psrecaptcha	0.173 ms	0.01 Mb
__construct	0.128 ms	0.01 Mb
hookActionFrontControllerSetMedia	0.045 ms	- Mb
ps_emailalerts	0.123 ms	0.01 Mb
__construct	0.104 ms	0.01 Mb
hookActionFrontControllerSetMedia	0.019 ms	- Mb
blockwishlist	4.337 ms	0.12 Mb
__construct	0.057 ms	0.01 Mb
hookActionFrontControllerSetMedia	0.131 ms	- Mb
hookDisplayFooter	4.149 ms	0.11 Mb
ps_socialfollow	0.441 ms	0.07 Mb
__construct	0.056 ms	0.01 Mb
hookActionFrontControllerSetMedia	0.037 ms	- Mb
displayFooterLeft	0.348 ms	0.06 Mb
chronopost	0.347 ms	0.15 Mb
__construct	0.292 ms	0.15 Mb
hookActionFrontControllerSetMedia	0.050 ms	- Mb
hookDisplayHeader	0.005 ms	- Mb
seoexpert	0.671 ms	0.02 Mb
__construct	0.606 ms	0.01 Mb
hookDisplayHeader	0.065 ms	0.02 Mb
ps_googleanalytics	6.760 ms	0.44 Mb
__construct	0.128 ms	0.01 Mb
hookDisplayHeader	2.294 ms	0.12 Mb
hookDisplayBeforeBodyClosingTag	4.338 ms	0.31 Mb
ps_shoppingcart	3.729 ms	0.09 Mb
__construct	0.073 ms	0.01 Mb
hookDisplayHeader	0.033 ms	- Mb
displayTop	3.623 ms	0.08 Mb
productcomments	161.923 ms	0.35 Mb
__construct	0.063 ms	0.01 Mb
hookDisplayHeader	0.067 ms	- Mb
displayProductListReviews	9.784 ms	0.29 Mb
displayProductListReviews	12.762 ms	0.01 Mb
displayProductListReviews	1.469 ms	0.01 Mb
displayProductListReviews	61.197 ms	0.01 Mb
displayProductListReviews	1.473 ms	0.01 Mb
displayProductListReviews	69.982 ms	0.01 Mb
displayProductListReviews	1.457 ms	0.01 Mb
displayProductListReviews	1.425 ms	0.01 Mb
displayProductListReviews	0.765 ms	0.01 Mb
displayProductListReviews	0.749 ms	0.01 Mb
displayProductListReviews	0.730 ms	0.01 Mb
ps_searchbar	0.841 ms	0.06 Mb
__construct	0.078 ms	0.01 Mb
hookDisplayHeader	0.124 ms	- Mb
displayTop	0.639 ms	0.05 Mb
zonecolorsfonts	0.919 ms	0.07 Mb
__construct	0.232 ms	0.02 Mb
hookDisplayHeader	0.516 ms	0.04 Mb
hookDisplayOutsideMainPage	0.171 ms	0.01 Mb
zonethememanager	2.091 ms	0.17 Mb
__construct	0.113 ms	0.01 Mb
hookDisplayHeader	0.662 ms	0.07 Mb
hookDisplaySidebarNavigation	0.208 ms	0.01 Mb
hookDisplayBanner	0.194 ms	0.01 Mb
hookDisplayNav1	0.158 ms	0.01 Mb
hookDisplayFooterLeft	0.211 ms	0.01 Mb
hookDisplayFooterRight	0.196 ms	0.02 Mb
hookDisplayFooterAfter	0.193 ms	0.01 Mb
hookDisplayOutsideMainPage	0.156 ms	0.01 Mb
ps_facetedsearch	0.989 ms	0.04 Mb
__construct	0.319 ms	0.01 Mb
hookProductSearchProvider	0.198 ms	- Mb
hookDisplayLeftColumn	0.472 ms	0.03 Mb
ps_languageselector	0.257 ms	0.09 Mb
__construct	0.064 ms	0.05 Mb
displayNav2	0.193 ms	0.04 Mb
ps_currencyselector	0.188 ms	0.05 Mb
__construct	0.042 ms	0.01 Mb
displayNav2	0.146 ms	0.04 Mb
ps_customersignin	1.106 ms	0.06 Mb
__construct	0.047 ms	0.01 Mb
displayTop	1.059 ms	0.06 Mb
zonemegamenu	0.338 ms	0.02 Mb
__construct	0.142 ms	0.01 Mb
hookDisplayNavFullWidth	0.196 ms	0.02 Mb
ps_categorytree	3.717 ms	0.36 Mb
__construct	0.050 ms	0.01 Mb
displayLeftColumn	3.667 ms	0.36 Mb
zonecolumnblocks	0.357 ms	0.03 Mb
__construct	0.110 ms	- Mb
hookDisplayLeftColumn	0.247 ms	0.03 Mb
zonepopupnewsletter	0.306 ms	0.02 Mb
__construct	0.131 ms	- Mb
hookDisplayOutsideMainPage	0.175 ms	0.01 Mb
statsdata	0.653 ms	0.05 Mb
__construct	0.048 ms	0.01 Mb
hookDisplayBeforeBodyClosingTag	0.605 ms	0.05 Mb
24 module(s)	194.072 ms	2.59 Mb

Catégories

Prix

Taille Textile

Femme

PENTALON PLUIE MIXTE

VESTE DE PLUIE MIXTE

CHEMISE KANSAS

CHEMISE EN JEAN ALEX

VESTE MATELASSE

CHEMISE A CARREAUX GREY

CHEMISE A CARREAUX

VESTE CUIR LINDY

VESTE DE PLUIE

CHEMISE ICON PLAID SHIRT

PANTALON PLUIE MIXTE, NOIR

Stopwatch SQL - 390 queries

Doubles

Tables stress

ObjectModel instances

Included Files

22 queries	SELECT SUM(quantity) FROM `amc_stock_available` WHERE (id_product = XX) AND (id_product_attribute = XX) AND (id_shop = XX) AND (id_shop_group = XX) LIMIT XX
22 queries	SELECT COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), XX) as deep_quantity, COALESCE(SUM(first_level_quantity), XX) as quantity FROM (SELECT cp.`quantity` as first_level_quantity, XX as pack_quantity FROM `amc_cart_product` cp WHERE cp.`id_product_attribute` = XX AND cp.`id_customization` = XX AND cp.`id_cart` = XX AND cp.`id_product` = XX UNION SELECT XX as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity FROM `amc_cart_product` cp JOIN `amc_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `amc_product` pr ON p.`id_product_pack` = pr.`id_product` WHERE cp.`id_product_attribute` = XX AND cp.`id_customization` = 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
12 queries	SELECT XX FROM `amc_specific_price` WHERE id_product = XX LIMIT XX
11 queries	SELECT `id_module` FROM `amc_module_shop` WHERE `id_module` = XX AND `id_shop` = XX LIMIT XX
11 queries	SELECT image_shop.`id_image` FROM `amc_image` i INNER JOIN amc_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
11 queries	SELECT name FROM amc_category_lang WHERE id_shop = XX AND id_lang = XX AND id_category = XX LIMIT XX
11 queries	SELECT * FROM `amc_product` a LEFT JOIN `amc_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = XX LEFT JOIN `amc_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
11 queries	SELECT product_attribute_shop.`price` FROM `amc_product_attribute` pa INNER JOIN amc_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
11 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 `amc_product` p INNER JOIN `amc_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = XX) LEFT JOIN `amc_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)
11 queries	SELECT `id_tax_rules_group` FROM `amc_product_shop` WHERE `id_product` = XX AND id_shop=XX LIMIT XX
11 queries	SELECT `reduction` FROM `amc_product_group_reduction_cache` WHERE `id_product` = XX AND `id_group` = XX LIMIT XX
11 queries	SELECT pa.`available_date` FROM `amc_product` p LEFT JOIN `amc_product_attribute` pa ON (pa.`id_product` = p.`id_product`) INNER JOIN amc_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = XX) INNER JOIN amc_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
11 queries	SELECT name, value, pf.id_feature, f.position, fvl.id_feature_value FROM amc_feature_product pf LEFT JOIN amc_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = XX) LEFT JOIN amc_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = XX) LEFT JOIN amc_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = XX) INNER JOIN amc_feature_shop feature_shop ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = XX) WHERE pf.id_product = XX ORDER BY f.position ASC
11 queries	SELECT a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, pa.`reference`, pa.`eanXX`, pa.`isbn`, pa.`upc`, pa.`mpn`, pal.`available_now`, pal.`available_later` FROM `amc_attribute` a LEFT JOIN `amc_attribute_lang` al ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = XX) LEFT JOIN `amc_product_attribute_combination` pac ON (pac.`id_attribute` = a.`id_attribute`) LEFT JOIN `amc_product_attribute` pa ON (pa.`id_product_attribute` = pac.`id_product_attribute`) INNER JOIN amc_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 `amc_product_attribute_lang` pal ON (pal.`id_product_attribute` = pac.`id_product_attribute` AND pal.`id_lang` = XX) LEFT JOIN `amc_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
11 queries	SELECT * FROM `amc_product_attribute` a LEFT JOIN `amc_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
11 queries	SELECT * FROM `amc_product_attribute_lang` WHERE `id_product_attribute` = XX
11 queries	SELECT image_shop.`cover`, i.`id_image`, il.`legend`, i.`position` FROM `amc_image` i INNER JOIN amc_image_shop image_shop ON (image_shop.id_image = i.id_image AND image_shop.id_shop = XX) LEFT JOIN `amc_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = XX) WHERE i.`id_product` = XX ORDER BY `position`
11 queries	SELECT `id_product_attribute` FROM `amc_product_attribute` WHERE `id_product` = XX
11 queries	SELECT pa.`id_product`, a.`color`, pac.`id_product_attribute`, XX qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by FROM `amc_product_attribute` pa INNER JOIN amc_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = XX) JOIN `amc_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`) JOIN `amc_attribute` a ON (a.`id_attribute` = pac.`id_attribute`) JOIN `amc_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = XX) JOIN `amc_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`) WHERE pa.`id_product` IN (XX) AND ag.`is_color_group` = XX GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` ORDER BY a.`position` ASC;
11 queries	SELECT al.`name` AS attribute_name FROM `amc_product_attribute_combination` pac LEFT JOIN `amc_attribute` a ON a.`id_attribute` = pac.`id_attribute` LEFT JOIN `amc_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group` LEFT JOIN `amc_attribute_lang` al ON ( a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = XX ) WHERE pac.`id_product_attribute` = XX ORDER BY ag.`position` ASC, a.`position` ASC
9 queries	SELECT * FROM `amc_category` a LEFT JOIN `amc_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = XX LEFT JOIN `amc_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
5 queries	SELECT cl.`link_rewrite` FROM `amc_category_lang` cl WHERE `id_lang` = XX AND cl.id_shop = XX AND cl.`id_category` = XX LIMIT XX
4 queries	SELECT `id_lang` FROM `amc_lang` WHERE `locale` = 'fr-fr' OR `language_code` = 'fr-fr' LIMIT XX
4 queries	SELECT pai.`id_image`, pai.`id_product_attribute`, il.`legend` FROM `amc_product_attribute_image` pai LEFT JOIN `amc_image_lang` il ON (il.`id_image` = pai.`id_image`) LEFT JOIN `amc_image` i ON (i.`id_image` = pai.`id_image`) WHERE pai.`id_product_attribute` IN (XX, XX, XX, XX, XX, XX, XX) AND il.`id_lang` = XX ORDER by i.`position`
4 queries	SELECT pai.`id_image`, pai.`id_product_attribute`, il.`legend` FROM `amc_product_attribute_image` pai LEFT JOIN `amc_image_lang` il ON (il.`id_image` = pai.`id_image`) LEFT JOIN `amc_image` i ON (i.`id_image` = pai.`id_image`) WHERE pai.`id_product_attribute` IN (XX, XX, XX, XX, XX, XX) AND il.`id_lang` = XX ORDER by i.`position`
3 queries	SELECT `priority`, `id_specific_price_priority` FROM `amc_specific_price_priority` WHERE `id_product` = XX ORDER BY `id_specific_price_priority` DESC LIMIT XX
3 queries	SELECT *, ( IF (`id_currency` = XX, XX, XX) + IF (`id_country` = XX, XX, XX) + IF (`id_shop` = XX, XX, XX) + IF (`id_group` = XX, XX, XX) + IF (`id_customer` = XX, XX, XX)) AS `score` FROM `amc_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
3 queries	SELECT tr.* FROM `amc_tax_rule` tr JOIN `amc_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 m.`id_module`, m.`name`, ms.`id_module`as `mshop` FROM `amc_module` m LEFT JOIN `amc_module_shop` ms ON m.`id_module` = ms.`id_module` AND ms.`id_shop` = XX
2 queries	SELECT * FROM `amc_currency` a LEFT JOIN `amc_currency_lang` `b` ON a.`id_currency` = b.`id_currency` AND b.`id_lang` = XX LEFT JOIN `amc_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 XX FROM `amc_cart_rule` WHERE ((date_to >= "XX-XX-XX XX:XX:XX" AND date_to <= "XX-XX-XX XX:XX:XX") OR (date_from >= "XX-XX-XX XX:XX:XX" AND date_from <= "XX-XX-XX XX:XX:XX") OR (date_from < "XX-XX-XX XX:XX:XX" AND date_to > "XX-XX-XX XX:XX:XX")) AND `id_customer` IN (XX,XX) LIMIT XX
2 queries	SELECT DISTINCT a.`id_attribute`, a.`color`, al.`name`, agl.`id_attribute_group`, IF(lialv.`url_name` IS NULL OR lialv.`url_name` = "", NULL, lialv.`url_name`) AS url_name, IF(lialv.`meta_title` IS NULL OR lialv.`meta_title` = "", NULL, lialv.`meta_title`) AS meta_title FROM `amc_attribute_group` ag INNER JOIN `amc_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = XX) INNER JOIN `amc_attribute` a ON a.`id_attribute_group` = ag.`id_attribute_group` INNER JOIN `amc_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = XX) INNER JOIN amc_attribute_group_shop attribute_group_shop ON (attribute_group_shop.id_attribute_group = ag.id_attribute_group AND attribute_group_shop.id_shop = XX) INNER JOIN amc_attribute_shop attribute_shop ON (attribute_shop.id_attribute = a.id_attribute AND attribute_shop.id_shop = XX) LEFT JOIN `amc_layered_indexable_attribute_lang_value` lialv ON (a.`id_attribute` = lialv.`id_attribute` AND lialv.`id_lang` = XX) WHERE ag.id_attribute_group = XX ORDER BY agl.`name` ASC, a.`position` ASC
2 queries	SELECT pai.`id_image`, pai.`id_product_attribute`, il.`legend` FROM `amc_product_attribute_image` pai LEFT JOIN `amc_image_lang` il ON (il.`id_image` = pai.`id_image`) LEFT JOIN `amc_image` i ON (i.`id_image` = pai.`id_image`) WHERE pai.`id_product_attribute` IN (XX, XX, XX, XX) AND il.`id_lang` = XX ORDER by i.`position`

Name	Instances	Source
Product	45	/modules/seoexpert/seoexpert.php:1388 (__construct) [id: ] /classes/Link.php:113 (__construct) [id: 4643] /classes/Link.php:113 (__construct) [id: 4592] /classes/Link.php:113 (__construct) [id: 4305] /classes/Link.php:113 (__construct) [id: 4269] /classes/Link.php:113 (__construct) [id: 4242] /classes/Link.php:113 (__construct) [id: 4094] /classes/Link.php:113 (__construct) [id: 4091] /classes/Link.php:113 (__construct) [id: 4000] /classes/Link.php:113 (__construct) [id: 4580] /classes/Link.php:113 (__construct) [id: 4083] /classes/Link.php:113 (__construct) [id: 3990] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 4643] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 4592] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 4305] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 4269] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 4242] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 4094] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 4091] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 4000] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 4580] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 4083] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 3990] /classes/Link.php:113 (__construct) [id: 4643] /classes/Link.php:113 (__construct) [id: 4643] /classes/Link.php:113 (__construct) [id: 4592] /classes/Link.php:113 (__construct) [id: 4592] /classes/Link.php:113 (__construct) [id: 4305] /classes/Link.php:113 (__construct) [id: 4305] /classes/Link.php:113 (__construct) [id: 4269] /classes/Link.php:113 (__construct) [id: 4269] /classes/Link.php:113 (__construct) [id: 4242] /classes/Link.php:113 (__construct) [id: 4242] /classes/Link.php:113 (__construct) [id: 4094] /classes/Link.php:113 (__construct) [id: 4094] /classes/Link.php:113 (__construct) [id: 4091] /classes/Link.php:113 (__construct) [id: 4091] /classes/Link.php:113 (__construct) [id: 4000] /classes/Link.php:113 (__construct) [id: 4000] /classes/Link.php:113 (__construct) [id: 4580] /classes/Link.php:113 (__construct) [id: 4580] /classes/Link.php:113 (__construct) [id: 4083] /classes/Link.php:113 (__construct) [id: 4083] /classes/Link.php:113 (__construct) [id: 3990] /classes/Link.php:113 (__construct) [id: 3990]
Category	15	/controllers/front/listing/CategoryController.php:78 (__construct) [id: 13] /controllers/front/listing/CategoryController.php:215 (__construct) [id: 14] /controllers/front/listing/CategoryController.php:215 (__construct) [id: 15] /controllers/front/listing/CategoryController.php:215 (__construct) [id: 16] /controllers/front/listing/CategoryController.php:215 (__construct) [id: 17] /controllers/front/listing/CategoryController.php:215 (__construct) [id: 18] /controllers/front/listing/CategoryController.php:215 (__construct) [id: 19] /controllers/front/listing/CategoryController.php:215 (__construct) [id: 20] /classes/Meta.php:380 (__construct) [id: 13] /classes/PrestaShopCollection.php:385 (hydrateCollection) [id: ] /classes/PrestaShopCollection.php:385 (hydrateCollection) [id: ] /classes/PrestaShopCollection.php:385 (hydrateCollection) [id: ] /modules/ps_facetedsearch/src/Filters/Block.php:157 (__construct) [id: 13] /modules/ps_categorytree/ps_categorytree.php:371 (__construct) [id: 2] /modules/ps_categorytree/ps_categorytree.php:364 (getParentsCategories) [id: 2]
Combination	11	/classes/Product.php:5882 (__construct) [id: 3817] /classes/Product.php:5882 (__construct) [id: 3714] /classes/Product.php:5882 (__construct) [id: 3451] /classes/Product.php:5882 (__construct) [id: 3301] /classes/Product.php:5882 (__construct) [id: 3155] /classes/Product.php:5882 (__construct) [id: 3061] /classes/Product.php:5882 (__construct) [id: 3040] /classes/Product.php:5882 (__construct) [id: 2526] /classes/Product.php:5882 (__construct) [id: 3680] /classes/Product.php:5882 (__construct) [id: 3033] /classes/Product.php:5882 (__construct) [id: 3132]
Address	4	/classes/shop/Shop.php:486 (__construct) [id: ] /classes/Product.php:3691 (initialize) [id: ] /classes/Product.php:3801 (__construct) [id: ] /classes/Product.php:5936 (__construct) [id: ]
Currency	3	/src/Adapter/Currency/CurrencyDataProvider.php:101 (__construct) [id: 2] /src/Adapter/Currency/CurrencyDataProvider.php:101 (__construct) [id: 1] /classes/Tools.php:684 (getCurrencyInstance) [id: 2]
Country	3	/config/config.inc.php:146 (__construct) [id: 8] /classes/AddressFormat.php:404 (__construct) [id: 8] /classes/controller/FrontController.php:1725 (__construct) [id: 8]
Language	2	/config/config.inc.php:211 (__construct) [id: 2] /classes/Tools.php:559 (__construct) [id: 2]
Tax	2	/classes/tax/TaxRulesTaxManager.php:116 (__construct) [id: 53] /classes/tax/TaxRulesTaxManager.php:116 (__construct) [id: 53]
Cart	2	/classes/controller/FrontController.php:429 (__construct) [id: ] /classes/controller/FrontController.php:499 (__construct) [id: ]
Shop	1	/config/config.inc.php:117 (initialize) [id: 1]
State	1	/classes/controller/FrontController.php:1724 (__construct) [id: 0]
ZManager	1	/modules/zonethememanager/zonethememanager.php:1915 (getSettingsByShop) [id: 1]
Gender	1	/classes/controller/FrontController.php:1649 (__construct) [id: 0]
AddressFormat	1	/classes/controller/FrontController.php:1719 (generateAddress) [id: ]
Risk	1	/classes/controller/FrontController.php:1652 (__construct) [id: ]
Group	1	/classes/Cart.php:249 (getCurrent) [id: 1]
Customer	1	/config/config.inc.php:264 (__construct) [id: ]
ShopGroup	1	/classes/shop/Shop.php:561 (__construct) [id: 1]
ConnectionsSource	1	/modules/statsdata/statsdata.php:119 (logHttpReferer) [id: ]

#	Query	Time (ms)	Rows	Filesort	Group By	Location
93	REPLACE INTO amc_layered_filter_block (hash, data) VALUES ("75e1424a58ed58f5b3aa87f53ee50de6", "a:1:{s:7:\"filters\";a:3:{i:0;a:7:{s:9:\"type_lite\";s:8:\"category\";s:4:\"type\";s:8:\"category\";s:6:\"id_key\";i:0;s:4:\"name\";s:11:\"Catégories\";s:6:\"values\";a:6:{i:14;a:2:{s:4:\"name\";s:8:\"Blousons\";s:3:\"nbr\";i:12;}i:15;a:3:{s:4:\"name\";s:6:\"Vestes\";s:3:\"nbr\";i:5;s:7:\"checked\";b:1;}i:16;a:2:{s:4:\"name\";s:14:\"Pulls & Sweats\";s:3:\"nbr\";i:4;}i:17;a:3:{s:4:\"name\";s:8:\"Chemises\";s:3:\"nbr\";i:4;s:7:\"checked\";b:1;}i:18;a:2:{s:4:\"name\";s:8:\"T-shirts\";s:3:\"nbr\";i:31;}i:19;a:3:{s:4:\"name\";s:9:\"Pantalons\";s:3:\"nbr\";i:2;s:7:\"checked\";b:1;}}s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";i:0;}i:1;a:12:{s:9:\"type_lite\";s:5:\"price\";s:4:\"type\";s:5:\"price\";s:6:\"id_key\";i:0;s:4:\"name\";s:4:\"Prix\";s:3:\"max\";d:352;s:3:\"min\";d:93;s:4:\"unit\";s:3:\"€\";s:14:\"specifications\";a:11:{s:6:\"symbol\";a:11:{i:0;s:1:\",\";i:1;s:3:\" \";i:2;s:1:\";\";i:3;s:1:\"%\";i:4;s:1:\"-\";i:5;s:1:\"+\";i:6;s:1:\"E\";i:7;s:2:\"×\";i:8;s:3:\"‰\";i:9;s:3:\"∞\";i:10;s:3:\"NaN\";}s:12:\"currencyCode\";s:3:\"EUR\";s:14:\"currencySymbol\";s:3:\"€\";s:13:\"numberSymbols\";a:11:{i:0;s:1:\",\";i:1;s:3:\" \";i:2;s:1:\";\";i:3;s:1:\"%\";i:4;s:1:\"-\";i:5;s:1:\"+\";i:6;s:1:\"E\";i:7;s:2:\"×\";i:8;s:3:\"‰\";i:9;s:3:\"∞\";i:10;s:3:\"NaN\";}s:15:\"positivePattern\";s:12:\"#,##0.00 ¤\";s:15:\"negativePattern\";s:13:\"-#,##0.00 ¤\";s:17:\"maxFractionDigits\";i:2;s:17:\"minFractionDigits\";i:2;s:12:\"groupingUsed\";b:1;s:16:\"primaryGroupSize\";i:3;s:18:\"secondaryGroupSize\";i:3;}s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";i:3;s:3:\"nbr\";i:11;s:5:\"value\";N;}i:2;a:10:{s:9:\"type_lite\";s:18:\"id_attribute_group\";s:4:\"type\";s:18:\"id_attribute_group\";s:6:\"id_key\";i:1;s:4:\"name\";s:14:\"Taille Textile\";s:14:\"is_color_group\";b:0;s:6:\"values\";a:11:{i:1;a:4:{s:4:\"name\";s:2:\"XS\";s:3:\"nbr\";i:8;s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:2;a:5:{s:4:\"name\";s:1:\"S\";s:3:\"nbr\";i:9;s:8:\"url_name\";N;s:10:\"meta_title\";N;s:7:\"checked\";b:1;}i:3;a:5:{s:4:\"name\";s:1:\"M\";s:3:\"nbr\";i:9;s:8:\"url_name\";N;s:10:\"meta_title\";N;s:7:\"checked\";b:1;}i:4;a:5:{s:4:\"name\";s:1:\"L\";s:3:\"nbr\";i:9;s:8:\"url_name\";N;s:10:\"meta_title\";N;s:7:\"checked\";b:1;}i:5;a:5:{s:4:\"name\";s:2:\"XL\";s:3:\"nbr\";i:9;s:8:\"url_name\";N;s:10:\"meta_title\";N;s:7:\"checked\";b:1;}i:6;a:4:{s:4:\"name\";s:3:\"2XL\";s:3:\"nbr\";i:8;s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:7;a:4:{s:4:\"name\";s:3:\"3XL\";s:3:\"nbr\";i:5;s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:88;a:5:{s:4:\"name\";s:8:\"XXXS/XXS\";s:3:\"nbr\";i:2;s:8:\"url_name\";N;s:10:\"meta_title\";N;s:7:\"checked\";b:1;}i:89;a:4:{s:4:\"name\";s:4:\"XS/S\";s:3:\"nbr\";i:2;s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:90;a:4:{s:4:\"name\";s:3:\"M/L\";s:3:\"nbr\";i:2;s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:91;a:4:{s:4:\"name\";s:6:\"XL/2XL\";s:3:\"nbr\";i:2;s:8:\"url_name\";N;s:10:\"meta_title\";N;}}s:8:\"url_name\";N;s:10:\"meta_title\";N;s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";i:0;}}}")	92.663 ms	1			/modules/ps_facetedsearch/src/Filters/Block.php:211 /modules/ps_facetedsearch/src/Product/SearchProvider.php:217 (insertIntoCache) /classes/controller/ProductListingFrontController.php:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:138 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
85	SELECT SQL_NO_CACHE data FROM amc_layered_filter_block WHERE hash="75e1424a58ed58f5b3aa87f53ee50de6" LIMIT 1	75.144 ms	1			/modules/ps_facetedsearch/src/Filters/Block.php:186 /modules/ps_facetedsearch/src/Product/SearchProvider.php:210 (getFromCache) /classes/controller/ProductListingFrontController.php:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:138 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
87	SELECT SQL_NO_CACHE cp.id_category, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, pa.id_product_attribute FROM amc_product p LEFT JOIN amc_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN amc_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN amc_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN amc_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN amc_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN amc_category_product cp ON (p.id_product = cp.id_product) INNER JOIN amc_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN amc_category_group cg ON (cg.id_category = c.id_category) WHERE ((pac.id_attribute IN (2, 3, 4, 5, 88))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' GROUP BY p.id_product) p INNER JOIN amc_category_product cp ON (p.id_product = cp.id_product) INNER JOIN amc_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN amc_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN amc_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN amc_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) WHERE ((pac.id_attribute IN (2, 3, 4, 5, 88))) AND cg.id_group='1' AND c.nleft>22 AND c.nright<37 GROUP BY cp.id_category	22.056 ms	8736			/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:778 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:992 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:158 (getCategoriesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:138 (doProductSearch) /tools/profiling/Controller.php:60 (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 `amc_configuration` c LEFT JOIN `amc_configuration_lang` cl ON (c.`id_configuration` = cl.`id_configuration`)	3.387 ms	1459			/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)
111	SELECT SQL_NO_CACHE `id_hook`, `name` FROM `amc_hook` UNION SELECT `id_hook`, ha.`alias` as name FROM `amc_hook_alias` ha INNER JOIN `amc_hook` h ON ha.name = h.name	1.886 ms	0			/classes/Hook.php:1292 /classes/Hook.php:225 (getAllHookIds) /classes/tax/TaxManagerFactory.php:67 (getIdByName) /classes/tax/TaxManagerFactory.php:46 (execHookTaxManagerFactory) /classes/Product.php:3922 (getManager) /override/classes/Product.php:61 (priceCalculation) /classes/Product.php:3734 (priceCalculation) /classes/Product.php:5664 (getPriceStatic) /classes/ProductAssembler.php:209 (getProductProperties) /classes/controller/ProductListingFrontController.php:108 (assembleProducts) /classes/controller/ProductListingFrontController.php:379 (prepareMultipleProductsForTemplate) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:138 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
84	SELECT SQL_NO_CACHE p.id_product, p.id_product_attribute, sa.out_of_stock FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, pa.id_product_attribute FROM amc_product p LEFT JOIN amc_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN amc_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN amc_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN amc_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN amc_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN amc_category_product cp ON (p.id_product = cp.id_product) INNER JOIN amc_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN amc_category_group cg ON (cg.id_category = c.id_category) WHERE ((pac.id_attribute IN (2, 3, 4, 5, 88))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND cp.id_category IN (17, 19, 15) GROUP BY p.id_product) p LEFT JOIN amc_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN amc_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN amc_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) GROUP BY p.id_product ORDER BY IFNULL(p.quantity, 0) <= 0, IFNULL(p.quantity, 0) <= 0 AND FIELD(sa.out_of_stock, 1) DESC, p.date_add DESC, p.id_product DESC	1.776 ms	2048	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Filters/Products.php:87 (execute) /modules/ps_facetedsearch/src/Product/SearchProvider.php:187 (getProductByFilters) /classes/controller/ProductListingFrontController.php:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:138 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
112	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 `amc_hook_module` hm STRAIGHT_JOIN `amc_hook` h ON (h.id_hook = hm.id_hook AND hm.id_shop = 1) STRAIGHT_JOIN `amc_module` as m ON (m.id_module = hm.id_module) ORDER BY hm.position	1.559 ms	494			/classes/Hook.php:456 /classes/Hook.php:493 (getHookModuleList) /classes/tax/TaxManagerFactory.php:67 (getModulesFromHook) /classes/tax/TaxManagerFactory.php:46 (execHookTaxManagerFactory) /classes/Product.php:3922 (getManager) /override/classes/Product.php:61 (priceCalculation) /classes/Product.php:3734 (priceCalculation) /classes/Product.php:5664 (getPriceStatic) /classes/ProductAssembler.php:209 (getProductProperties) /classes/controller/ProductListingFrontController.php:108 (assembleProducts) /classes/controller/ProductListingFrontController.php:379 (prepareMultipleProductsForTemplate) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:138 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
15	SELECT SQL_NO_CACHE h.`name` as hook, m.`id_module`, h.`id_hook`, m.`name` as module FROM `amc_module` m INNER JOIN amc_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 `amc_hook_module` `hm` ON hm.`id_module` = m.`id_module` INNER JOIN `amc_hook` `h` ON hm.`id_hook` = h.`id_hook` LEFT JOIN `amc_module_group` `mg` ON mg.`id_module` = m.`id_module` WHERE (h.`name` != "paymentOptions") AND (hm.`id_shop` = 1) AND (mg.id_shop = 1 AND mg.`id_group` IN (1)) GROUP BY hm.id_hook, hm.id_module ORDER BY hm.`position`	1.530 ms	370	Yes	Yes	/classes/Hook.php:1233 /classes/Hook.php:735 (getAllHookRegistrations) /classes/Hook.php:842 (getHookModuleExecList) /classes/Dispatcher.php:606 (exec) /classes/Dispatcher.php:243 (loadRoutes) /classes/Dispatcher.php:201 (__construct) /index.php:28 (getInstance)
14	SELECT SQL_NO_CACHE lower(name) as name FROM `amc_hook` h WHERE (h.active = 1)	0.949 ms	942			/classes/Hook.php:1332 /classes/Hook.php:811 (getHookStatusByName) /classes/Dispatcher.php:606 (exec) /classes/Dispatcher.php:243 (loadRoutes) /classes/Dispatcher.php:201 (__construct) /index.php:28 (getInstance)
92	SELECT SQL_NO_CACHE pac.id_attribute, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, pa.id_product_attribute FROM amc_product p LEFT JOIN amc_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN amc_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN amc_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN amc_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN amc_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN amc_category_product cp ON (p.id_product = cp.id_product) INNER JOIN amc_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN amc_category_group cg ON (cg.id_category = c.id_category) WHERE ((pac.id_attribute IN (2, 3, 4, 5, 88))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND cp.id_category IN (17, 19, 15) GROUP BY p.id_product) p LEFT JOIN amc_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN amc_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) INNER JOIN amc_attribute a ON (a.id_attribute = pac.id_attribute) LEFT JOIN amc_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) WHERE ((a.id_attribute_group=4)) AND ((pac_1.id_attribute IN (2, 3, 4, 5, 88))) GROUP BY pac.id_attribute	0.875 ms	2048	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:778 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:737 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:150 (getAttributesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:138 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
353	SELECT SQL_NO_CACHE c., cl. FROM `amc_category` c INNER JOIN amc_category_shop category_shop ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1) LEFT JOIN `amc_category_lang` cl ON c.`id_category` = cl.`id_category` AND cl.id_shop = 1 LEFT JOIN `amc_category_group` cg ON c.`id_category` = cg.`id_category` RIGHT JOIN `amc_category` c2 ON c2.`id_category` = 2 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright` WHERE 1 AND c.`level_depth` <= 5 AND `id_lang` = 2 AND c.`active` = 1 AND cg.`id_group` IN (1) GROUP BY c.`id_category` ORDER BY c.`level_depth` ASC, category_shop.`position` ASC	0.845 ms	39	Yes	Yes	/classes/Category.php:796 /modules/ps_categorytree/ps_categorytree.php:141 (getNestedCategories) /modules/ps_categorytree/ps_categorytree.php:298 (getCategories) /modules/ps_categorytree/ps_categorytree.php:266 (getWidgetVariables) /classes/Hook.php:1054 (renderWidget) /tools/profiling/Hook.php:64 (coreRenderWidget) /classes/Hook.php:1000 (coreRenderWidget) /config/smarty.config.inc.php:198 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/prod/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/b7/ba/b6/b7bab654b3ff4cc4fe82a5f21498eaf97ded45b9_2.file.layout-both-columns.tpl.php:302 (__call) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/b7/ba/b6/b7bab654b3ff4cc4fe82a5f21498eaf97ded45b9_2.file.layout-both-columns.tpl.php:394 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/b7/ba/b6/b7bab654b3ff4cc4fe82a5f21498eaf97ded45b9_2.file.layout-both-columns.tpl.php:99 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67f4cf31c326c6_14919996) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/30/b7/02/30b702b72f9d88a8923d059cad1c5196ef4d44a5_2.file.layout-left-column.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67f4cf31c268b7_43790744) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/46/7d/f4/467df4f41ea4076c692a9f41a29d84d00a4d595a_2.file.product-list.tpl.php:42 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67f4cf31c24856_23122598) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/f5/22/70/f52270fd147ef515e89149292aec9df4cac568b9_2.file.category.tpl.php:34 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67f4cf31c1edb7_92348992) /vendor/smarty/smarty/libs/sysplugins/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:718 (fetch) /classes/controller/FrontController.php:700 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
90	SELECT SQL_NO_CACHE pac.id_attribute, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, pa.id_product_attribute FROM amc_product p LEFT JOIN amc_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN amc_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN amc_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN amc_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN amc_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN amc_category_product cp ON (p.id_product = cp.id_product) INNER JOIN amc_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN amc_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND cp.id_category IN (17, 19, 15) GROUP BY p.id_product) p LEFT JOIN amc_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN amc_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) INNER JOIN amc_attribute a ON (a.id_attribute = pac.id_attribute) WHERE ((a.id_attribute_group=1)) GROUP BY pac.id_attribute	0.743 ms	2048	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:778 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:737 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:150 (getAttributesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:138 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
83	SELECT SQL_NO_CACHE DISTINCT a.`id_attribute`, a.`color`, al.`name`, agl.`id_attribute_group`, IF(lialv.`url_name` IS NULL OR lialv.`url_name` = "", NULL, lialv.`url_name`) AS url_name, IF(lialv.`meta_title` IS NULL OR lialv.`meta_title` = "", NULL, lialv.`meta_title`) AS meta_title FROM `amc_attribute_group` ag INNER JOIN `amc_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 2) INNER JOIN `amc_attribute` a ON a.`id_attribute_group` = ag.`id_attribute_group` INNER JOIN `amc_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 2) INNER JOIN amc_attribute_group_shop attribute_group_shop ON (attribute_group_shop.id_attribute_group = ag.id_attribute_group AND attribute_group_shop.id_shop = 1) INNER JOIN amc_attribute_shop attribute_shop ON (attribute_shop.id_attribute = a.id_attribute AND attribute_shop.id_shop = 1) LEFT JOIN `amc_layered_indexable_attribute_lang_value` lialv ON (a.`id_attribute` = lialv.`id_attribute` AND lialv.`id_lang` = 2) WHERE ag.id_attribute_group = 1 ORDER BY agl.`name` ASC, a.`position` ASC	0.743 ms	86	Yes		/modules/ps_facetedsearch/src/Filters/DataAccessor.php:96 /modules/ps_facetedsearch/src/Filters/Converter.php:427 (getAttributes) /modules/ps_facetedsearch/src/Product/SearchProvider.php:163 (createFacetedSearchFiltersFromQuery) /classes/controller/ProductListingFrontController.php:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:138 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
94	SELECT SQL_NO_CACHE p., ps., pl.*, sa.out_of_stock, IFNULL(sa.quantity, 0) as quantity, (DATEDIFF( p.`date_add`, DATE_SUB( '2025-04-08 00:00:00', INTERVAL 120 DAY ) ) > 0) as new FROM amc_product p LEFT JOIN amc_product_lang pl ON pl.id_product = p.id_product AND pl.id_shop = 1 AND pl.id_lang = 2 LEFT JOIN amc_stock_available sa ON sa.id_product = p.id_product AND sa.id_product_attribute = 0 AND sa.id_shop = 1 LEFT JOIN amc_product_shop ps ON ps.id_product = p.id_product AND ps.id_shop = 1 WHERE p.id_product IN (4643,4592,4305,4269,4242,4094,4091,4000,4580,4083,3990)	0.730 ms	11			/classes/ProductAssembler.php:95 /classes/ProductAssembler.php:203 (addMissingProductFieldsForMultipleProducts) /classes/controller/ProductListingFrontController.php:108 (assembleProducts) /classes/controller/ProductListingFrontController.php:379 (prepareMultipleProductsForTemplate) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:138 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
369	SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by FROM `amc_product_attribute` pa INNER JOIN amc_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) JOIN `amc_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`) JOIN `amc_attribute` a ON (a.`id_attribute` = pac.`id_attribute`) JOIN `amc_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 2) JOIN `amc_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`) WHERE pa.`id_product` IN (4083) AND ag.`is_color_group` = 1 GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` ORDER BY a.`position` ASC;	0.575 ms	12	Yes	Yes	/classes/Product.php:4504 /src/Adapter/Product/ProductColorsRetriever.php:43 (getAttributesColorList) /src/Adapter/Presenter/Product/ProductLazyArray.php:527 (getColoredVariants) /src/Adapter/Presenter/AbstractLazyArray.php:261 (getMainVariants) /var/cache/prod/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/85/52/b8/8552b87f517cecce52c3b20b1a01672b0f265f87_2.file.product.tpl.php:128 (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/ZOneThemelayouts_layout_left_column_tpl/85/52/b8/8552b87f517cecce52c3b20b1a01672b0f265f87_2.file.product.tpl.php:288 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/85/52/b8/8552b87f517cecce52c3b20b1a01672b0f265f87_2.file.product.tpl.php:35 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67f4cf31d6bef4_55800601) /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/ZOneThemelayouts_layout_left_column_tpl/2b/d2/74/2bd2748b495eece467aab7865debd262e1705dd3_2.file.products.tpl.php:70 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/2b/d2/74/2bd2748b495eece467aab7865debd262e1705dd3_2.file.products.tpl.php:43 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67f4cf31ca9db5_26964322) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /var/cache/prod/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/46/7d/f4/467df4f41ea4076c692a9f41a29d84d00a4d595a_2.file.product-list.tpl.php:97 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/46/7d/f4/467df4f41ea4076c692a9f41a29d84d00a4d595a_2.file.product-list.tpl.php:191 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:186 (process) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/b7/ba/b6/b7bab654b3ff4cc4fe82a5f21498eaf97ded45b9_2.file.layout-both-columns.tpl.php:333 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/b7/ba/b6/b7bab654b3ff4cc4fe82a5f21498eaf97ded45b9_2.file.layout-both-columns.tpl.php:399 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/b7/ba/b6/b7bab654b3ff4cc4fe82a5f21498eaf97ded45b9_2.file.layout-both-columns.tpl.php:99 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67f4cf31c326c6_14919996) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/30/b7/02/30b702b72f9d88a8923d059cad1c5196ef4d44a5_2.file.layout-left-column.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67f4cf31c268b7_43790744) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/46/7d/f4/467df4f41ea4076c692a9f41a29d84d00a4d595a_2.file.product-list.tpl.php:42 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67f4cf31c24856_23122598) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/f5/22/70/f52270fd147ef515e89149292aec9df4cac568b9_2.file.category.tpl.php:34 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67f4cf31c1edb7_92348992) /vendor/smarty/smarty/libs/sysplugins/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:718 (fetch) /classes/controller/FrontController.php:700 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
41	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 `amc_category` c INNER JOIN amc_category_shop category_shop ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1) LEFT JOIN `amc_category_lang` cl ON (c.`id_category` = cl.`id_category` AND `id_lang` = 2 AND cl.id_shop = 1 ) LEFT JOIN `amc_category_group` cg ON (cg.`id_category` = c.`id_category`) WHERE `id_parent` = 13 AND `active` = 1 AND cg.`id_group` =1 GROUP BY c.`id_category` ORDER BY `level_depth` ASC, category_shop.`position` ASC	0.569 ms	7	Yes	Yes	/classes/Category.php:921 /controllers/front/listing/CategoryController.php:229 (getSubCategories) /controllers/front/listing/CategoryController.php:118 (getTemplateVarSubCategories) /tools/profiling/Controller.php:41 (init) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
88	SELECT SQL_NO_CACHE fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, pa.id_product_attribute FROM amc_product p LEFT JOIN amc_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN amc_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN amc_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN amc_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN amc_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN amc_category_product cp ON (p.id_product = cp.id_product) INNER JOIN amc_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN amc_category_group cg ON (cg.id_category = c.id_category) WHERE ((pac.id_attribute IN (2, 3, 4, 5, 88))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND cp.id_category IN (17, 19, 15) GROUP BY p.id_product) p INNER JOIN amc_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN amc_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN amc_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) WHERE ((fp.id_feature=1)) AND ((pac_1.id_attribute IN (2, 3, 4, 5, 88))) GROUP BY fp.id_feature_value	0.535 ms	8	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:778 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:855 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:154 (getFeaturesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:138 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
361	SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by FROM `amc_product_attribute` pa INNER JOIN amc_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) JOIN `amc_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`) JOIN `amc_attribute` a ON (a.`id_attribute` = pac.`id_attribute`) JOIN `amc_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 2) JOIN `amc_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`) WHERE pa.`id_product` IN (4592) AND ag.`is_color_group` = 1 GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` ORDER BY a.`position` ASC;	0.535 ms	14	Yes	Yes	/classes/Product.php:4504 /src/Adapter/Product/ProductColorsRetriever.php:43 (getAttributesColorList) /src/Adapter/Presenter/Product/ProductLazyArray.php:527 (getColoredVariants) /src/Adapter/Presenter/AbstractLazyArray.php:261 (getMainVariants) /var/cache/prod/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/85/52/b8/8552b87f517cecce52c3b20b1a01672b0f265f87_2.file.product.tpl.php:128 (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/ZOneThemelayouts_layout_left_column_tpl/85/52/b8/8552b87f517cecce52c3b20b1a01672b0f265f87_2.file.product.tpl.php:288 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/85/52/b8/8552b87f517cecce52c3b20b1a01672b0f265f87_2.file.product.tpl.php:35 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67f4cf31d6bef4_55800601) /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/ZOneThemelayouts_layout_left_column_tpl/2b/d2/74/2bd2748b495eece467aab7865debd262e1705dd3_2.file.products.tpl.php:70 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/2b/d2/74/2bd2748b495eece467aab7865debd262e1705dd3_2.file.products.tpl.php:43 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67f4cf31ca9db5_26964322) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /var/cache/prod/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/46/7d/f4/467df4f41ea4076c692a9f41a29d84d00a4d595a_2.file.product-list.tpl.php:97 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/46/7d/f4/467df4f41ea4076c692a9f41a29d84d00a4d595a_2.file.product-list.tpl.php:191 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:186 (process) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/b7/ba/b6/b7bab654b3ff4cc4fe82a5f21498eaf97ded45b9_2.file.layout-both-columns.tpl.php:333 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/b7/ba/b6/b7bab654b3ff4cc4fe82a5f21498eaf97ded45b9_2.file.layout-both-columns.tpl.php:399 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/b7/ba/b6/b7bab654b3ff4cc4fe82a5f21498eaf97ded45b9_2.file.layout-both-columns.tpl.php:99 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67f4cf31c326c6_14919996) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/30/b7/02/30b702b72f9d88a8923d059cad1c5196ef4d44a5_2.file.layout-left-column.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67f4cf31c268b7_43790744) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/46/7d/f4/467df4f41ea4076c692a9f41a29d84d00a4d595a_2.file.product-list.tpl.php:42 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67f4cf31c24856_23122598) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/f5/22/70/f52270fd147ef515e89149292aec9df4cac568b9_2.file.category.tpl.php:34 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67f4cf31c1edb7_92348992) /vendor/smarty/smarty/libs/sysplugins/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:718 (fetch) /classes/controller/FrontController.php:700 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
368	SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by FROM `amc_product_attribute` pa INNER JOIN amc_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) JOIN `amc_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`) JOIN `amc_attribute` a ON (a.`id_attribute` = pac.`id_attribute`) JOIN `amc_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 2) JOIN `amc_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`) WHERE pa.`id_product` IN (4580) AND ag.`is_color_group` = 1 GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` ORDER BY a.`position` ASC;	0.519 ms	8	Yes	Yes	/classes/Product.php:4504 /src/Adapter/Product/ProductColorsRetriever.php:43 (getAttributesColorList) /src/Adapter/Presenter/Product/ProductLazyArray.php:527 (getColoredVariants) /src/Adapter/Presenter/AbstractLazyArray.php:261 (getMainVariants) /var/cache/prod/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/85/52/b8/8552b87f517cecce52c3b20b1a01672b0f265f87_2.file.product.tpl.php:128 (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/ZOneThemelayouts_layout_left_column_tpl/85/52/b8/8552b87f517cecce52c3b20b1a01672b0f265f87_2.file.product.tpl.php:288 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/85/52/b8/8552b87f517cecce52c3b20b1a01672b0f265f87_2.file.product.tpl.php:35 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67f4cf31d6bef4_55800601) /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/ZOneThemelayouts_layout_left_column_tpl/2b/d2/74/2bd2748b495eece467aab7865debd262e1705dd3_2.file.products.tpl.php:70 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/2b/d2/74/2bd2748b495eece467aab7865debd262e1705dd3_2.file.products.tpl.php:43 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67f4cf31ca9db5_26964322) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /var/cache/prod/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/46/7d/f4/467df4f41ea4076c692a9f41a29d84d00a4d595a_2.file.product-list.tpl.php:97 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/46/7d/f4/467df4f41ea4076c692a9f41a29d84d00a4d595a_2.file.product-list.tpl.php:191 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:186 (process) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/b7/ba/b6/b7bab654b3ff4cc4fe82a5f21498eaf97ded45b9_2.file.layout-both-columns.tpl.php:333 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/b7/ba/b6/b7bab654b3ff4cc4fe82a5f21498eaf97ded45b9_2.file.layout-both-columns.tpl.php:399 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/b7/ba/b6/b7bab654b3ff4cc4fe82a5f21498eaf97ded45b9_2.file.layout-both-columns.tpl.php:99 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67f4cf31c326c6_14919996) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/30/b7/02/30b702b72f9d88a8923d059cad1c5196ef4d44a5_2.file.layout-left-column.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67f4cf31c268b7_43790744) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/46/7d/f4/467df4f41ea4076c692a9f41a29d84d00a4d595a_2.file.product-list.tpl.php:42 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67f4cf31c24856_23122598) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/f5/22/70/f52270fd147ef515e89149292aec9df4cac568b9_2.file.category.tpl.php:34 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67f4cf31c1edb7_92348992) /vendor/smarty/smarty/libs/sysplugins/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:718 (fetch) /classes/controller/FrontController.php:700 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
378	SELECT SQL_NO_CACHE cp.`id_category`, cp.`id_product`, cl.`name` FROM `amc_category_product` cp LEFT JOIN `amc_category` c ON (c.id_category = cp.id_category) LEFT JOIN `amc_category_lang` cl ON (cp.`id_category` = cl.`id_category` AND cl.id_shop = 1 ) INNER JOIN amc_category_shop category_shop ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1) WHERE cp.`id_product` IN (4643,4592,4305,4269,4242,4094,4091,4000,4580,4083,3990) AND cl.`id_lang` = 2 ORDER BY c.`level_depth` DESC	0.498 ms	56	Yes		/modules/ps_googleanalytics/classes/Wrapper/ProductWrapper.php:109 /modules/ps_googleanalytics/classes/Wrapper/ProductWrapper.php:68 (loadCategories) /modules/ps_googleanalytics/classes/Hook/HookDisplayBeforeBodyClosingTag.php:81 (prepareItemListFromProductList) /modules/ps_googleanalytics/classes/Hook/HookDisplayBeforeBodyClosingTag.php:57 (renderProductListing) /modules/ps_googleanalytics/ps_googleanalytics.php:109 (run) /classes/Hook.php:1043 (hookDisplayBeforeBodyClosingTag) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:418 (coreCallHook) /classes/Hook.php:981 (callHookOn) /config/smarty.config.inc.php:198 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/prod/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/b7/ba/b6/b7bab654b3ff4cc4fe82a5f21498eaf97ded45b9_2.file.layout-both-columns.tpl.php:525 (__call) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/b7/ba/b6/b7bab654b3ff4cc4fe82a5f21498eaf97ded45b9_2.file.layout-both-columns.tpl.php:148 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67f4cf31c326c6_14919996) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/30/b7/02/30b702b72f9d88a8923d059cad1c5196ef4d44a5_2.file.layout-left-column.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67f4cf31c268b7_43790744) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/46/7d/f4/467df4f41ea4076c692a9f41a29d84d00a4d595a_2.file.product-list.tpl.php:42 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67f4cf31c24856_23122598) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/f5/22/70/f52270fd147ef515e89149292aec9df4cac568b9_2.file.category.tpl.php:34 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67f4cf31c1edb7_92348992) /vendor/smarty/smarty/libs/sysplugins/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:718 (fetch) /classes/controller/FrontController.php:700 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
366	SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by FROM `amc_product_attribute` pa INNER JOIN amc_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) JOIN `amc_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`) JOIN `amc_attribute` a ON (a.`id_attribute` = pac.`id_attribute`) JOIN `amc_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 2) JOIN `amc_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`) WHERE pa.`id_product` IN (4091) AND ag.`is_color_group` = 1 GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` ORDER BY a.`position` ASC;	0.494 ms	14	Yes	Yes	/classes/Product.php:4504 /src/Adapter/Product/ProductColorsRetriever.php:43 (getAttributesColorList) /src/Adapter/Presenter/Product/ProductLazyArray.php:527 (getColoredVariants) /src/Adapter/Presenter/AbstractLazyArray.php:261 (getMainVariants) /var/cache/prod/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/85/52/b8/8552b87f517cecce52c3b20b1a01672b0f265f87_2.file.product.tpl.php:128 (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/ZOneThemelayouts_layout_left_column_tpl/85/52/b8/8552b87f517cecce52c3b20b1a01672b0f265f87_2.file.product.tpl.php:288 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/85/52/b8/8552b87f517cecce52c3b20b1a01672b0f265f87_2.file.product.tpl.php:35 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67f4cf31d6bef4_55800601) /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/ZOneThemelayouts_layout_left_column_tpl/2b/d2/74/2bd2748b495eece467aab7865debd262e1705dd3_2.file.products.tpl.php:70 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/2b/d2/74/2bd2748b495eece467aab7865debd262e1705dd3_2.file.products.tpl.php:43 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67f4cf31ca9db5_26964322) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /var/cache/prod/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/46/7d/f4/467df4f41ea4076c692a9f41a29d84d00a4d595a_2.file.product-list.tpl.php:97 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/46/7d/f4/467df4f41ea4076c692a9f41a29d84d00a4d595a_2.file.product-list.tpl.php:191 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:186 (process) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/b7/ba/b6/b7bab654b3ff4cc4fe82a5f21498eaf97ded45b9_2.file.layout-both-columns.tpl.php:333 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/b7/ba/b6/b7bab654b3ff4cc4fe82a5f21498eaf97ded45b9_2.file.layout-both-columns.tpl.php:399 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/b7/ba/b6/b7bab654b3ff4cc4fe82a5f21498eaf97ded45b9_2.file.layout-both-columns.tpl.php:99 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67f4cf31c326c6_14919996) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/30/b7/02/30b702b72f9d88a8923d059cad1c5196ef4d44a5_2.file.layout-left-column.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67f4cf31c268b7_43790744) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/46/7d/f4/467df4f41ea4076c692a9f41a29d84d00a4d595a_2.file.product-list.tpl.php:42 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67f4cf31c24856_23122598) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/f5/22/70/f52270fd147ef515e89149292aec9df4cac568b9_2.file.category.tpl.php:34 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67f4cf31c1edb7_92348992) /vendor/smarty/smarty/libs/sysplugins/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:718 (fetch) /classes/controller/FrontController.php:700 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
358	SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by FROM `amc_product_attribute` pa INNER JOIN amc_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) JOIN `amc_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`) JOIN `amc_attribute` a ON (a.`id_attribute` = pac.`id_attribute`) JOIN `amc_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 2) JOIN `amc_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`) WHERE pa.`id_product` IN (4643) AND ag.`is_color_group` = 1 GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` ORDER BY a.`position` ASC;	0.486 ms	10	Yes	Yes	/classes/Product.php:4504 /src/Adapter/Product/ProductColorsRetriever.php:43 (getAttributesColorList) /src/Adapter/Presenter/Product/ProductLazyArray.php:527 (getColoredVariants) /src/Adapter/Presenter/AbstractLazyArray.php:261 (getMainVariants) /var/cache/prod/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/85/52/b8/8552b87f517cecce52c3b20b1a01672b0f265f87_2.file.product.tpl.php:128 (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/ZOneThemelayouts_layout_left_column_tpl/85/52/b8/8552b87f517cecce52c3b20b1a01672b0f265f87_2.file.product.tpl.php:288 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/85/52/b8/8552b87f517cecce52c3b20b1a01672b0f265f87_2.file.product.tpl.php:35 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67f4cf31d6bef4_55800601) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /var/cache/prod/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/2b/d2/74/2bd2748b495eece467aab7865debd262e1705dd3_2.file.products.tpl.php:70 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/2b/d2/74/2bd2748b495eece467aab7865debd262e1705dd3_2.file.products.tpl.php:43 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67f4cf31ca9db5_26964322) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /var/cache/prod/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/46/7d/f4/467df4f41ea4076c692a9f41a29d84d00a4d595a_2.file.product-list.tpl.php:97 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/46/7d/f4/467df4f41ea4076c692a9f41a29d84d00a4d595a_2.file.product-list.tpl.php:191 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:186 (process) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/b7/ba/b6/b7bab654b3ff4cc4fe82a5f21498eaf97ded45b9_2.file.layout-both-columns.tpl.php:333 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/b7/ba/b6/b7bab654b3ff4cc4fe82a5f21498eaf97ded45b9_2.file.layout-both-columns.tpl.php:399 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/b7/ba/b6/b7bab654b3ff4cc4fe82a5f21498eaf97ded45b9_2.file.layout-both-columns.tpl.php:99 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67f4cf31c326c6_14919996) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/30/b7/02/30b702b72f9d88a8923d059cad1c5196ef4d44a5_2.file.layout-left-column.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67f4cf31c268b7_43790744) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/46/7d/f4/467df4f41ea4076c692a9f41a29d84d00a4d595a_2.file.product-list.tpl.php:42 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67f4cf31c24856_23122598) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/f5/22/70/f52270fd147ef515e89149292aec9df4cac568b9_2.file.category.tpl.php:34 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67f4cf31c1edb7_92348992) /vendor/smarty/smarty/libs/sysplugins/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:718 (fetch) /classes/controller/FrontController.php:700 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
362	SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by FROM `amc_product_attribute` pa INNER JOIN amc_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) JOIN `amc_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`) JOIN `amc_attribute` a ON (a.`id_attribute` = pac.`id_attribute`) JOIN `amc_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 2) JOIN `amc_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`) WHERE pa.`id_product` IN (4305) AND ag.`is_color_group` = 1 GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` ORDER BY a.`position` ASC;	0.464 ms	12	Yes	Yes	/classes/Product.php:4504 /src/Adapter/Product/ProductColorsRetriever.php:43 (getAttributesColorList) /src/Adapter/Presenter/Product/ProductLazyArray.php:527 (getColoredVariants) /src/Adapter/Presenter/AbstractLazyArray.php:261 (getMainVariants) /var/cache/prod/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/85/52/b8/8552b87f517cecce52c3b20b1a01672b0f265f87_2.file.product.tpl.php:128 (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/ZOneThemelayouts_layout_left_column_tpl/85/52/b8/8552b87f517cecce52c3b20b1a01672b0f265f87_2.file.product.tpl.php:288 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/85/52/b8/8552b87f517cecce52c3b20b1a01672b0f265f87_2.file.product.tpl.php:35 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67f4cf31d6bef4_55800601) /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/ZOneThemelayouts_layout_left_column_tpl/2b/d2/74/2bd2748b495eece467aab7865debd262e1705dd3_2.file.products.tpl.php:70 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/2b/d2/74/2bd2748b495eece467aab7865debd262e1705dd3_2.file.products.tpl.php:43 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67f4cf31ca9db5_26964322) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /var/cache/prod/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/46/7d/f4/467df4f41ea4076c692a9f41a29d84d00a4d595a_2.file.product-list.tpl.php:97 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/46/7d/f4/467df4f41ea4076c692a9f41a29d84d00a4d595a_2.file.product-list.tpl.php:191 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:186 (process) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/b7/ba/b6/b7bab654b3ff4cc4fe82a5f21498eaf97ded45b9_2.file.layout-both-columns.tpl.php:333 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/b7/ba/b6/b7bab654b3ff4cc4fe82a5f21498eaf97ded45b9_2.file.layout-both-columns.tpl.php:399 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/b7/ba/b6/b7bab654b3ff4cc4fe82a5f21498eaf97ded45b9_2.file.layout-both-columns.tpl.php:99 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67f4cf31c326c6_14919996) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/30/b7/02/30b702b72f9d88a8923d059cad1c5196ef4d44a5_2.file.layout-left-column.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67f4cf31c268b7_43790744) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/46/7d/f4/467df4f41ea4076c692a9f41a29d84d00a4d595a_2.file.product-list.tpl.php:42 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67f4cf31c24856_23122598) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/f5/22/70/f52270fd147ef515e89149292aec9df4cac568b9_2.file.category.tpl.php:34 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67f4cf31c1edb7_92348992) /vendor/smarty/smarty/libs/sysplugins/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:718 (fetch) /classes/controller/FrontController.php:700 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
108	SELECT SQL_NO_CACHE *, ( IF (`id_currency` = 2, 2, 0) + IF (`id_country` = 8, 4, 0) + IF (`id_shop` = 1, 8, 0) + IF (`id_group` = 1, 16, 0) + IF (`id_customer` = 0, 32, 0)) AS `score` FROM `amc_specific_price` WHERE `id_shop` IN (0, 1) AND `id_currency` IN (0, 2) AND `id_country` IN (0, 8) AND `id_group` IN (0, 1) AND `id_product` = 4643 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0 AND (`from` = '0000-00-00 00:00:00' OR '2025-04-08 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2025-04-08 00:00:00' <= `to`) AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1	0.449 ms	2	Yes		/classes/SpecificPrice.php:576 /classes/Product.php:3824 (getSpecificPrice) /override/classes/Product.php:61 (priceCalculation) /classes/Product.php:3734 (priceCalculation) /classes/Product.php:5664 (getPriceStatic) /classes/ProductAssembler.php:209 (getProductProperties) /classes/controller/ProductListingFrontController.php:108 (assembleProducts) /classes/controller/ProductListingFrontController.php:379 (prepareMultipleProductsForTemplate) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:138 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
364	SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by FROM `amc_product_attribute` pa INNER JOIN amc_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) JOIN `amc_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`) JOIN `amc_attribute` a ON (a.`id_attribute` = pac.`id_attribute`) JOIN `amc_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 2) JOIN `amc_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`) WHERE pa.`id_product` IN (4242) AND ag.`is_color_group` = 1 GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` ORDER BY a.`position` ASC;	0.437 ms	12	Yes	Yes	/classes/Product.php:4504 /src/Adapter/Product/ProductColorsRetriever.php:43 (getAttributesColorList) /src/Adapter/Presenter/Product/ProductLazyArray.php:527 (getColoredVariants) /src/Adapter/Presenter/AbstractLazyArray.php:261 (getMainVariants) /var/cache/prod/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/85/52/b8/8552b87f517cecce52c3b20b1a01672b0f265f87_2.file.product.tpl.php:128 (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/ZOneThemelayouts_layout_left_column_tpl/85/52/b8/8552b87f517cecce52c3b20b1a01672b0f265f87_2.file.product.tpl.php:288 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/85/52/b8/8552b87f517cecce52c3b20b1a01672b0f265f87_2.file.product.tpl.php:35 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67f4cf31d6bef4_55800601) /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/ZOneThemelayouts_layout_left_column_tpl/2b/d2/74/2bd2748b495eece467aab7865debd262e1705dd3_2.file.products.tpl.php:70 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/2b/d2/74/2bd2748b495eece467aab7865debd262e1705dd3_2.file.products.tpl.php:43 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67f4cf31ca9db5_26964322) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /var/cache/prod/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/46/7d/f4/467df4f41ea4076c692a9f41a29d84d00a4d595a_2.file.product-list.tpl.php:97 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/46/7d/f4/467df4f41ea4076c692a9f41a29d84d00a4d595a_2.file.product-list.tpl.php:191 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:186 (process) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/b7/ba/b6/b7bab654b3ff4cc4fe82a5f21498eaf97ded45b9_2.file.layout-both-columns.tpl.php:333 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/b7/ba/b6/b7bab654b3ff4cc4fe82a5f21498eaf97ded45b9_2.file.layout-both-columns.tpl.php:399 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/b7/ba/b6/b7bab654b3ff4cc4fe82a5f21498eaf97ded45b9_2.file.layout-both-columns.tpl.php:99 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67f4cf31c326c6_14919996) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/30/b7/02/30b702b72f9d88a8923d059cad1c5196ef4d44a5_2.file.layout-left-column.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67f4cf31c268b7_43790744) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/46/7d/f4/467df4f41ea4076c692a9f41a29d84d00a4d595a_2.file.product-list.tpl.php:42 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67f4cf31c24856_23122598) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/f5/22/70/f52270fd147ef515e89149292aec9df4cac568b9_2.file.category.tpl.php:34 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67f4cf31c1edb7_92348992) /vendor/smarty/smarty/libs/sysplugins/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:718 (fetch) /classes/controller/FrontController.php:700 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
367	SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by FROM `amc_product_attribute` pa INNER JOIN amc_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) JOIN `amc_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`) JOIN `amc_attribute` a ON (a.`id_attribute` = pac.`id_attribute`) JOIN `amc_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 2) JOIN `amc_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`) WHERE pa.`id_product` IN (4000) AND ag.`is_color_group` = 1 GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` ORDER BY a.`position` ASC;	0.433 ms	14	Yes	Yes	/classes/Product.php:4504 /src/Adapter/Product/ProductColorsRetriever.php:43 (getAttributesColorList) /src/Adapter/Presenter/Product/ProductLazyArray.php:527 (getColoredVariants) /src/Adapter/Presenter/AbstractLazyArray.php:261 (getMainVariants) /var/cache/prod/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/85/52/b8/8552b87f517cecce52c3b20b1a01672b0f265f87_2.file.product.tpl.php:128 (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/ZOneThemelayouts_layout_left_column_tpl/85/52/b8/8552b87f517cecce52c3b20b1a01672b0f265f87_2.file.product.tpl.php:288 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/85/52/b8/8552b87f517cecce52c3b20b1a01672b0f265f87_2.file.product.tpl.php:35 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67f4cf31d6bef4_55800601) /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/ZOneThemelayouts_layout_left_column_tpl/2b/d2/74/2bd2748b495eece467aab7865debd262e1705dd3_2.file.products.tpl.php:70 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/2b/d2/74/2bd2748b495eece467aab7865debd262e1705dd3_2.file.products.tpl.php:43 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67f4cf31ca9db5_26964322) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /var/cache/prod/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/46/7d/f4/467df4f41ea4076c692a9f41a29d84d00a4d595a_2.file.product-list.tpl.php:97 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/46/7d/f4/467df4f41ea4076c692a9f41a29d84d00a4d595a_2.file.product-list.tpl.php:191 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:186 (process) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/b7/ba/b6/b7bab654b3ff4cc4fe82a5f21498eaf97ded45b9_2.file.layout-both-columns.tpl.php:333 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/b7/ba/b6/b7bab654b3ff4cc4fe82a5f21498eaf97ded45b9_2.file.layout-both-columns.tpl.php:399 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/b7/ba/b6/b7bab654b3ff4cc4fe82a5f21498eaf97ded45b9_2.file.layout-both-columns.tpl.php:99 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67f4cf31c326c6_14919996) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/30/b7/02/30b702b72f9d88a8923d059cad1c5196ef4d44a5_2.file.layout-left-column.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67f4cf31c268b7_43790744) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/46/7d/f4/467df4f41ea4076c692a9f41a29d84d00a4d595a_2.file.product-list.tpl.php:42 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67f4cf31c24856_23122598) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/f5/22/70/f52270fd147ef515e89149292aec9df4cac568b9_2.file.category.tpl.php:34 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67f4cf31c1edb7_92348992) /vendor/smarty/smarty/libs/sysplugins/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:718 (fetch) /classes/controller/FrontController.php:700 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
363	SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by FROM `amc_product_attribute` pa INNER JOIN amc_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) JOIN `amc_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`) JOIN `amc_attribute` a ON (a.`id_attribute` = pac.`id_attribute`) JOIN `amc_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 2) JOIN `amc_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`) WHERE pa.`id_product` IN (4269) AND ag.`is_color_group` = 1 GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` ORDER BY a.`position` ASC;	0.423 ms	12	Yes	Yes	/classes/Product.php:4504 /src/Adapter/Product/ProductColorsRetriever.php:43 (getAttributesColorList) /src/Adapter/Presenter/Product/ProductLazyArray.php:527 (getColoredVariants) /src/Adapter/Presenter/AbstractLazyArray.php:261 (getMainVariants) /var/cache/prod/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/85/52/b8/8552b87f517cecce52c3b20b1a01672b0f265f87_2.file.product.tpl.php:128 (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/ZOneThemelayouts_layout_left_column_tpl/85/52/b8/8552b87f517cecce52c3b20b1a01672b0f265f87_2.file.product.tpl.php:288 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/85/52/b8/8552b87f517cecce52c3b20b1a01672b0f265f87_2.file.product.tpl.php:35 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67f4cf31d6bef4_55800601) /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/ZOneThemelayouts_layout_left_column_tpl/2b/d2/74/2bd2748b495eece467aab7865debd262e1705dd3_2.file.products.tpl.php:70 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/2b/d2/74/2bd2748b495eece467aab7865debd262e1705dd3_2.file.products.tpl.php:43 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67f4cf31ca9db5_26964322) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /var/cache/prod/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/46/7d/f4/467df4f41ea4076c692a9f41a29d84d00a4d595a_2.file.product-list.tpl.php:97 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/46/7d/f4/467df4f41ea4076c692a9f41a29d84d00a4d595a_2.file.product-list.tpl.php:191 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:186 (process) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/b7/ba/b6/b7bab654b3ff4cc4fe82a5f21498eaf97ded45b9_2.file.layout-both-columns.tpl.php:333 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/b7/ba/b6/b7bab654b3ff4cc4fe82a5f21498eaf97ded45b9_2.file.layout-both-columns.tpl.php:399 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/b7/ba/b6/b7bab654b3ff4cc4fe82a5f21498eaf97ded45b9_2.file.layout-both-columns.tpl.php:99 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67f4cf31c326c6_14919996) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/30/b7/02/30b702b72f9d88a8923d059cad1c5196ef4d44a5_2.file.layout-left-column.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67f4cf31c268b7_43790744) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/46/7d/f4/467df4f41ea4076c692a9f41a29d84d00a4d595a_2.file.product-list.tpl.php:42 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67f4cf31c24856_23122598) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/f5/22/70/f52270fd147ef515e89149292aec9df4cac568b9_2.file.category.tpl.php:34 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67f4cf31c1edb7_92348992) /vendor/smarty/smarty/libs/sysplugins/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:718 (fetch) /classes/controller/FrontController.php:700 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
365	SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by FROM `amc_product_attribute` pa INNER JOIN amc_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) JOIN `amc_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`) JOIN `amc_attribute` a ON (a.`id_attribute` = pac.`id_attribute`) JOIN `amc_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 2) JOIN `amc_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`) WHERE pa.`id_product` IN (4094) AND ag.`is_color_group` = 1 GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` ORDER BY a.`position` ASC;	0.417 ms	14	Yes	Yes	/classes/Product.php:4504 /src/Adapter/Product/ProductColorsRetriever.php:43 (getAttributesColorList) /src/Adapter/Presenter/Product/ProductLazyArray.php:527 (getColoredVariants) /src/Adapter/Presenter/AbstractLazyArray.php:261 (getMainVariants) /var/cache/prod/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/85/52/b8/8552b87f517cecce52c3b20b1a01672b0f265f87_2.file.product.tpl.php:128 (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/ZOneThemelayouts_layout_left_column_tpl/85/52/b8/8552b87f517cecce52c3b20b1a01672b0f265f87_2.file.product.tpl.php:288 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/85/52/b8/8552b87f517cecce52c3b20b1a01672b0f265f87_2.file.product.tpl.php:35 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67f4cf31d6bef4_55800601) /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/ZOneThemelayouts_layout_left_column_tpl/2b/d2/74/2bd2748b495eece467aab7865debd262e1705dd3_2.file.products.tpl.php:70 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/2b/d2/74/2bd2748b495eece467aab7865debd262e1705dd3_2.file.products.tpl.php:43 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67f4cf31ca9db5_26964322) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /var/cache/prod/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/46/7d/f4/467df4f41ea4076c692a9f41a29d84d00a4d595a_2.file.product-list.tpl.php:97 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/46/7d/f4/467df4f41ea4076c692a9f41a29d84d00a4d595a_2.file.product-list.tpl.php:191 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:186 (process) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/b7/ba/b6/b7bab654b3ff4cc4fe82a5f21498eaf97ded45b9_2.file.layout-both-columns.tpl.php:333 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/b7/ba/b6/b7bab654b3ff4cc4fe82a5f21498eaf97ded45b9_2.file.layout-both-columns.tpl.php:399 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/b7/ba/b6/b7bab654b3ff4cc4fe82a5f21498eaf97ded45b9_2.file.layout-both-columns.tpl.php:99 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67f4cf31c326c6_14919996) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/30/b7/02/30b702b72f9d88a8923d059cad1c5196ef4d44a5_2.file.layout-left-column.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67f4cf31c268b7_43790744) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/46/7d/f4/467df4f41ea4076c692a9f41a29d84d00a4d595a_2.file.product-list.tpl.php:42 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67f4cf31c24856_23122598) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/f5/22/70/f52270fd147ef515e89149292aec9df4cac568b9_2.file.category.tpl.php:34 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67f4cf31c1edb7_92348992) /vendor/smarty/smarty/libs/sysplugins/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:718 (fetch) /classes/controller/FrontController.php:700 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
17	SELECT SQL_NO_CACHE `id_hook`, `name` FROM `amc_hook`	0.413 ms	942			/classes/Hook.php:1292 /classes/Hook.php:225 (getAllHookIds) /classes/Hook.php:851 (getIdByName) /classes/Dispatcher.php:606 (exec) /classes/Dispatcher.php:243 (loadRoutes) /classes/Dispatcher.php:201 (__construct) /index.php:28 (getInstance)
370	SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by FROM `amc_product_attribute` pa INNER JOIN amc_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) JOIN `amc_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`) JOIN `amc_attribute` a ON (a.`id_attribute` = pac.`id_attribute`) JOIN `amc_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 2) JOIN `amc_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`) WHERE pa.`id_product` IN (3990) AND ag.`is_color_group` = 1 GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` ORDER BY a.`position` ASC;	0.408 ms	8	Yes	Yes	/classes/Product.php:4504 /src/Adapter/Product/ProductColorsRetriever.php:43 (getAttributesColorList) /src/Adapter/Presenter/Product/ProductLazyArray.php:527 (getColoredVariants) /src/Adapter/Presenter/AbstractLazyArray.php:261 (getMainVariants) /var/cache/prod/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/85/52/b8/8552b87f517cecce52c3b20b1a01672b0f265f87_2.file.product.tpl.php:128 (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/ZOneThemelayouts_layout_left_column_tpl/85/52/b8/8552b87f517cecce52c3b20b1a01672b0f265f87_2.file.product.tpl.php:288 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/85/52/b8/8552b87f517cecce52c3b20b1a01672b0f265f87_2.file.product.tpl.php:35 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67f4cf31d6bef4_55800601) /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/ZOneThemelayouts_layout_left_column_tpl/2b/d2/74/2bd2748b495eece467aab7865debd262e1705dd3_2.file.products.tpl.php:70 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/2b/d2/74/2bd2748b495eece467aab7865debd262e1705dd3_2.file.products.tpl.php:43 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67f4cf31ca9db5_26964322) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /var/cache/prod/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/46/7d/f4/467df4f41ea4076c692a9f41a29d84d00a4d595a_2.file.product-list.tpl.php:97 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/46/7d/f4/467df4f41ea4076c692a9f41a29d84d00a4d595a_2.file.product-list.tpl.php:191 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:186 (process) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/b7/ba/b6/b7bab654b3ff4cc4fe82a5f21498eaf97ded45b9_2.file.layout-both-columns.tpl.php:333 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/b7/ba/b6/b7bab654b3ff4cc4fe82a5f21498eaf97ded45b9_2.file.layout-both-columns.tpl.php:399 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/b7/ba/b6/b7bab654b3ff4cc4fe82a5f21498eaf97ded45b9_2.file.layout-both-columns.tpl.php:99 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67f4cf31c326c6_14919996) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/30/b7/02/30b702b72f9d88a8923d059cad1c5196ef4d44a5_2.file.layout-left-column.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67f4cf31c268b7_43790744) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/46/7d/f4/467df4f41ea4076c692a9f41a29d84d00a4d595a_2.file.product-list.tpl.php:42 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67f4cf31c24856_23122598) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/f5/22/70/f52270fd147ef515e89149292aec9df4cac568b9_2.file.category.tpl.php:34 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67f4cf31c1edb7_92348992) /vendor/smarty/smarty/libs/sysplugins/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:718 (fetch) /classes/controller/FrontController.php:700 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
89	SELECT SQL_NO_CACHE psi.price_min, MIN(price_min) as min, MAX(price_max) as max FROM amc_product p INNER JOIN amc_layered_price_index psi ON (psi.id_product = p.id_product AND psi.id_shop = 1 AND psi.id_currency = 2 AND psi.id_country = 8) INNER JOIN amc_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN amc_category_product cp ON (p.id_product = cp.id_product) INNER JOIN amc_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN amc_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN amc_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN amc_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) WHERE ((pac.id_attribute IN (2, 3, 4, 5, 88))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND cp.id_category IN (17, 19, 15)	0.401 ms	32			/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:57 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:250 (getMinMaxPriceValue) /modules/ps_facetedsearch/src/Filters/Block.php:131 (getPriceRangeBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:138 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
135	SELECT SQL_NO_CACHE *, ( IF (`id_currency` = 2, 2, 0) + IF (`id_country` = 8, 4, 0) + IF (`id_shop` = 1, 8, 0) + IF (`id_group` = 1, 16, 0) + IF (`id_customer` = 0, 32, 0)) AS `score` FROM `amc_specific_price` WHERE `id_shop` IN (0, 1) AND `id_currency` IN (0, 2) AND `id_country` IN (0, 8) AND `id_group` IN (0, 1) AND `id_product` = 4592 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0 AND (`from` = '0000-00-00 00:00:00' OR '2025-04-08 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2025-04-08 00:00:00' <= `to`) AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1	0.337 ms	2	Yes		/classes/SpecificPrice.php:576 /classes/Product.php:3824 (getSpecificPrice) /override/classes/Product.php:61 (priceCalculation) /classes/Product.php:3734 (priceCalculation) /classes/Product.php:5664 (getPriceStatic) /classes/ProductAssembler.php:209 (getProductProperties) /classes/controller/ProductListingFrontController.php:108 (assembleProducts) /classes/controller/ProductListingFrontController.php:379 (prepareMultipleProductsForTemplate) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:138 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
50	SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module`as `mshop` FROM `amc_module` m LEFT JOIN `amc_module_shop` ms ON m.`id_module` = ms.`id_module` AND ms.`id_shop` = 1	0.329 ms	97			/classes/module/Module.php:345 /modules/ps_emailsubscription/ps_emailsubscription.php:96 (__construct) :undefined (__construct) /src/Core/Foundation/IoC/Container.php:123 (newInstance) /src/Core/Foundation/IoC/Container.php:153 (makeInstanceFromClassName) /src/Core/Foundation/IoC/Container.php:166 (doMake) /src/Adapter/ServiceLocator.php:70 (make) /classes/module/Module.php:1235 (get) /tools/profiling/Module.php:35 (coreLoadModule) /classes/module/Module.php:1214 (coreLoadModule) /classes/Hook.php:966 (getInstanceByName) /classes/controller/FrontController.php:951 (exec) /tools/profiling/Controller.php:48 (setMedia) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
56	SELECT SQL_NO_CACHE 1 FROM `amc_cart_rule` WHERE ((date_to >= "2025-04-08 00:00:00" AND date_to <= "2025-04-08 23:59:59") OR (date_from >= "2025-04-08 00:00:00" AND date_from <= "2025-04-08 23:59:59") OR (date_from < "2025-04-08 00:00:00" AND date_to > "2025-04-08 23:59:59")) AND `id_customer` IN (0,0) LIMIT 1	0.329 ms	2			/classes/CartRule.php:357 /classes/CartRule.php:389 (haveCartRuleToday) /classes/CartRule.php:564 (getCustomerCartRules) /classes/Cart.php:522 (getCustomerHighlightedDiscounts) /src/Adapter/Presenter/Cart/CartPresenter.php:444 (getDiscounts) /classes/controller/FrontController.php:503 (present) /classes/controller/FrontController.php:572 (assignGeneralPurposeVariables) /controllers/front/listing/CategoryController.php:127 (initContent) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
54	SELECT SQL_NO_CACHE 1 FROM `amc_cart_rule` WHERE ((date_to >= "2025-04-08 00:00:00" AND date_to <= "2025-04-08 23:59:59") OR (date_from >= "2025-04-08 00:00:00" AND date_from <= "2025-04-08 23:59:59") OR (date_from < "2025-04-08 00:00:00" AND date_to > "2025-04-08 23:59:59")) AND `id_customer` IN (0,0) LIMIT 1	0.301 ms	2			/classes/CartRule.php:357 /classes/CartRule.php:389 (haveCartRuleToday) /classes/Cart.php:3021 (getCustomerCartRules) /classes/Cart.php:3405 (getDeliveryOptionList) /classes/Cart.php:3478 (getDeliveryOption) /src/Core/Cart/Fees.php:96 (getTotalShippingCost) /src/Core/Cart/Calculator.php:354 (processCalculation) /src/Core/Cart/Calculator.php:155 (calculateFees) /classes/Cart.php:2173 (processCalculation) /src/Adapter/Presenter/Cart/CartPresenter.php:334 (getOrderTotal) /classes/controller/FrontController.php:503 (present) /classes/controller/FrontController.php:572 (assignGeneralPurposeVariables) /controllers/front/listing/CategoryController.php:127 (initContent) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
0	SELECT SQL_NO_CACHE s.id_shop, CONCAT(su.physical_uri, su.virtual_uri) AS uri, su.domain, su.main FROM amc_shop_url su LEFT JOIN amc_shop s ON (s.id_shop = su.id_shop) WHERE (su.domain = 'shopindianangers.com' OR su.domain_ssl = 'shopindianangers.com') AND s.active = 1 AND s.deleted = 0 ORDER BY LENGTH(CONCAT(su.physical_uri, su.virtual_uri)) DESC	0.289 ms	1	Yes		/classes/shop/Shop.php:1364 /classes/shop/Shop.php:355 (findShopByHost) /config/config.inc.php:117 (initialize) /index.php:27 (require)
120	SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity, COALESCE(SUM(first_level_quantity), 0) as quantity FROM (SELECT cp.`quantity` as first_level_quantity, 0 as pack_quantity FROM `amc_cart_product` cp WHERE cp.`id_product_attribute` = 0 AND cp.`id_customization` = 0 AND cp.`id_cart` = 0 AND cp.`id_product` = 4643 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity FROM `amc_cart_product` cp JOIN `amc_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `amc_product` pr ON p.`id_product_pack` = pr.`id_product` WHERE cp.`id_product_attribute` = 0 AND cp.`id_customization` = 0 AND cp.`id_cart` = 0 AND p.`id_product_item` = 4643 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 1 = 1 ))) as q LIMIT 1	0.288 ms	0			/classes/Cart.php:1410 /classes/Product.php:4339 (getProductQuantity) /classes/Product.php:5773 (getQuantity) /classes/ProductAssembler.php:209 (getProductProperties) /classes/controller/ProductListingFrontController.php:108 (assembleProducts) /classes/controller/ProductListingFrontController.php:379 (prepareMultipleProductsForTemplate) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:138 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
173	SELECT SQL_NO_CACHE *, ( IF (`id_currency` = 2, 2, 0) + IF (`id_country` = 8, 4, 0) + IF (`id_shop` = 1, 8, 0) + IF (`id_group` = 1, 16, 0) + IF (`id_customer` = 0, 32, 0)) AS `score` FROM `amc_specific_price` WHERE `id_shop` IN (0, 1) AND `id_currency` IN (0, 2) AND `id_country` IN (0, 8) AND `id_group` IN (0, 1) AND `id_product` = 4269 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0 AND (`from` = '0000-00-00 00:00:00' OR '2025-04-08 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2025-04-08 00:00:00' <= `to`) AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1	0.286 ms	1	Yes		/classes/SpecificPrice.php:576 /classes/Product.php:3824 (getSpecificPrice) /override/classes/Product.php:61 (priceCalculation) /classes/Product.php:3734 (priceCalculation) /classes/Product.php:5664 (getPriceStatic) /classes/ProductAssembler.php:209 (getProductProperties) /classes/controller/ProductListingFrontController.php:108 (assembleProducts) /classes/controller/ProductListingFrontController.php:379 (prepareMultipleProductsForTemplate) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:138 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
86	SELECT SQL_NO_CACHE c.`id_category`, cl.`name` FROM `amc_category` c INNER JOIN amc_category_shop category_shop ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1) LEFT JOIN `amc_category_lang` cl ON c.`id_category` = cl.`id_category` AND cl.id_shop = 1 WHERE 1 AND `id_lang` = 2 AND c.`active` = 1 ORDER BY c.nleft, c.position	0.285 ms	39	Yes		/classes/Category.php:721 /modules/ps_facetedsearch/src/Filters/Block.php:986 (getAllCategoriesName) /modules/ps_facetedsearch/src/Filters/Block.php:158 (getCategoriesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:138 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
213	SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity, COALESCE(SUM(first_level_quantity), 0) as quantity FROM (SELECT cp.`quantity` as first_level_quantity, 0 as pack_quantity FROM `amc_cart_product` cp WHERE cp.`id_product_attribute` = 0 AND cp.`id_customization` = 0 AND cp.`id_cart` = 0 AND cp.`id_product` = 4094 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity FROM `amc_cart_product` cp JOIN `amc_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `amc_product` pr ON p.`id_product_pack` = pr.`id_product` WHERE cp.`id_product_attribute` = 0 AND cp.`id_customization` = 0 AND cp.`id_cart` = 0 AND p.`id_product_item` = 4094 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 1 = 1 ))) as q LIMIT 1	0.275 ms	0			/classes/Cart.php:1410 /classes/Product.php:4339 (getProductQuantity) /classes/Product.php:5773 (getQuantity) /classes/ProductAssembler.php:209 (getProductProperties) /classes/controller/ProductListingFrontController.php:108 (assembleProducts) /classes/controller/ProductListingFrontController.php:379 (prepareMultipleProductsForTemplate) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:138 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)

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