Collection 2018-2024

Collection de 200 poèmes et d'œuvres photographiques écrits et réalisées par Aurélien Lavignac entre 2018 et 2024.
L'ensemble de cette collection, une fois les avoir lu et observé pourra alors être remis dans l'ordre pour former une toute autre histoire, la mienne; celle que je découvrirais et vivrais durant plusieurs années sans me rendre compte que ces œuvres, ces poèmes m'étaient destinés pour mieux comprendre mon avenir et les différentes étapes de vie, de santé et de cœur que j'allais devoir surmonter avant de retrouver le chemin de la Lumière.
Chaque poème est en fait un écrit, un message bien souvent médiumnique, me permettant aujourd'hui d'en comprendre le sens.
Deuil, Rupture, Combat de père, Déchirement, Solitude, Silence, Amour, Foi, Vibration énergétique,

Sous-catégories

200 œuvres -...

Collection de 200 poèmes et d'œuvres photographiques écrits et réalisées par Aurélien Lavignac entre 2018 et 2024.

Vous trouverez ici mes oeuvres photographiques, mes textes et mes poèmes

Au delà de la photographie, au delà des mots, au delà des expériences que je vous propose, c'est avant tout avec mon coeur et mes sentiments que je vous invite par mon regard et mes mots à prendre le temps, à accepter la perte, un deuil, à également respecter, comprendre, découvrir et transmettre tout ce qui est là, présent et essentiel.

Au travers la magie des anciens, je vous ouvre les portes de mon univers et vous emmène à la découverte de soi même, de la région et de toute l'énergie et de l'amour qui nous entoure.

Chaque photographie est un travail unique de plusieurs dizaines et parfois centaines d'heures que ça soit dans l'organisation et la recherche du lieu, de l'instant, de la météo et de l'accord parfait.
Loin des clichés actuelles, mon travail se veut le plus près de la Nature et de mes valeurs et le plus loin de l'image, de l'irréel.
"Il faut savoir rêver à partir de n'importe quoi, il faut savoir aussi différencier la magie, de l'illusion et du mensonge."

Acquérir une photographie d'art - Ces Poésies et ces Photographies traverseront le temps - Patrimoine, défiscalisation, leasing (aurelien-lavignac-photographies.com)

Un rendu moderne et des formats géants

1-Choix du formats / 2-Choix des dimensions / 3-Choix de l'encadrement

Oeuvre d'art
Tirages originaux sur aluminium en édition Limitée, certifiés, numérotés et signés
--- en 5 exemplaires ---
Disponible en finition mat avec ou sans encadrement de type "caisse américaine".
Autre option possible sur demande.

Remis avec certificat d'authenticité numérique de l'auteur et accompagnée d'un texte ou d'un poème de l'artiste.

Tarifs: à partir de 350 euros, voir prix fiche produits

Tirage d'exposition
Impression direct sur support aluminium pour une qualité professionnelle. Tirage d'exposition pouvant comporter des defaults et de l'usure.

--- exemplaire numéroté 0/5 ---
Tarifs: Entre 135 et 250 euros
(40x60cm, 50x100cm, 40x80cm, 60x90cm, 60x180cm )

La qualité du support et de l'impression vous assure un affichage léger, discret, et résistant au temps, aux UV et á la pluie.

Idéal en extérieur, comme en intérieur, cela vous assure une excellent choix pour une exposition court et long terme et pour transmettre un oeuvre au sein d'une collection d'art et de son patrimoine au fil des décennies et des générations .
C'est le support que j'ai choisi pour ma galerie et les divers expositions extérieures.
C'est celui que je vous recommande.

Reproduction des œuvres originales disponible aussi sur papier

Disponible en Affiche, poster et en Encadré en petit et moyen format
(30x40cm, 40x60cm, 40x80cm, 60x90cm)

Tarifs des reproductions sur papier

Format 2:3 (paysage ou portrait) á partir de 80 euros

40 x 60 cm / 50 x 70 cm / 60 x 90 cm / 80 x 120 cm

Format Carrée 1:1 á partir de 100 euros

60 x 60 cm / 80 x 80 cm / 100 x 100 cm

Format Double 2:1 á partir de 100 euros

40 x 70 cm / 40 x 80 cm / 50 x 100 cm

Format 3:1 ;a partir de 80 euros

30 x 90 cm / 40 x 120 cm / 50 x 150 cm

Format 4:1 á partir de 250 euros

50 x 200 / 40 x 160 cm

**autres dimensions possible sur demande

5- Délai

Délai: en stock, ou 2 á 3 semaines, á partir de la confirmation de la commande et du paiement
Un message de confirmation est envoyé par mail et/ou téléphone
Si vous n'avez pas de nouvelle, vérifier vos courriers indésirables ou contacter moi directement.

6- Livraison:
Livraison offerte: á récupérer á la galerie
Pour la livraison á domicile.
Livraison offerte sur la CUB si délai et dispo possible. C'est toujours le cas ;)

Livraison possible hors CUB, en France et á l'étranger, frais supplémentaire, merci de prendre directement contact pour mettre en place la meilleure solution (cout / délai).

Pour toute autres demandes, photos, dimensions, supports, n'hésitez pas á me contacter.

Référence: CATÉGORIE_TIRAGE_D_ART_galerie_bordeaux_cadaujac_pessac-leognan

Tirage photo d’art – Oeuvre N°oeuvre_n°011-fleur-rires-grimaces : Oeuvre N°011/200, Orchidée ex.3/5 _ Fleurs de Gironde - Rires et Grimaces (Édition limitée 5 ex.)

Aperçu rapide

Oeuvre N°011/200, Orchidée ex.3/5 _ Fleurs de Gironde -...

Dès 180,00 €

Warning

/homepages/23/d824122604/htdocs/clickandbuilds/stagephoto/var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/c3/8a/d8/c38ad8ef490d26e052942bf124027e01185e4fb4_2.file.product.tpl.php

251

Warning

251

Warning

251

Tirage photo d’art – Oeuvre N°oeuvre_n°077-fleur-lightpainting-art : Oeuvre N°077/200, Danseuse florale _ Bordeaux _ Lightpainting (Édition limitée 5 ex.)

Aperçu rapide

Oeuvre N°077/200, Danseuse florale _ Bordeaux _...

Dès 180,00 €

Warning

251

Warning

251

Warning

251

Tirage photo d’art – Oeuvre N°oeuvre_n°106-cigogne-etoile-nuit : Oeuvre N°106/200, Le commencement N°1/2 _ Ex.3/5 _ Cigogne sous les étoiles (Édition limitée 5 ex.)

Aperçu rapide

Oeuvre N°106/200, Le commencement N°1/2 _ Ex.3/5 _...

Dès 180,00 €

Warning

251

Warning

251

Warning

251

Tirage photo d’art – Oeuvre N°oeuvre_n°021-fleur-cosmos : Oeuvre N°021/200, Double Cosmos (Édition limitée 5 ex.)

Aperçu rapide

Oeuvre N°021/200, Double Cosmos

Dès 180,00 €

Warning

251

Warning

251

Warning

251

Tirage photo d’art – Oeuvre N°oeuvre_n°178-tournesol-fleur-soleil : Oeuvre N°178/200, Tournesol _ Terre de Charentes et de Gironde (Édition limitée 5 ex.)

Aperçu rapide

Oeuvre N°178/200, Tournesol _ Terre de Charentes et de...

Dès 180,00 €

Warning

251

Warning

251

Warning

251

Tirage photo d’art – Oeuvre N°oeuvre_n°189-martin-animaux-pecheur-branche : Oeuvre N°189/200, Martin pêcheur _ Sud Gironde (Édition limitée 5 ex.)

Aperçu rapide

Oeuvre N°189/200, Martin pêcheur _ Sud Gironde

Dès 180,00 €

Warning

251

Warning

251

Warning

251

Tirage photo d’art – Oeuvre N°oeuvre_n°183-chouette-regard-animaux : Oeuvre N°183/200, Regard _ Chouette Chevêche, tuile de Gironde (Édition limitée 5 ex.)

Aperçu rapide

Oeuvre N°183/200, Regard _ Chouette Chevêche, tuile de...

Dès 180,00 €

Warning

251

Warning

251

Warning

251

Retour en haut

Collection 2018-2024 - En savoir plus

ou

Voir l'ensemble de la Collection

Voir d'autres collections

Collection de 200 poèmes et d'œuvres photographiques écrits et réalisées par Aurélien Lavignac.
L'ensemble de cette collection, une fois les avoir lu et observé pourra alors être remis dans l'ordre pour former une toute autre histoire, la mienne; celle que je découvrirais et vivrais durant plusieurs années sans me rendre compte que ces œuvres, ces poèmes m'étaient destinés pour mieux comprendre mon avenir et les différentes étapes de vie, de santé et de cœur que j'allais devoir surmonter avant de retrouver le chemin de la Lumière.
Chaque poème est en fait un écrit, un message bien souvent médiumnique, me permettant aujourd'hui d'en comprendre le sens.
Deuil, Rupture, Combat de père, Déchirement, Solitude, Silence, Amour, Foi, Vibration énergétique,

Load Time	1919 ms
Querying Time	222 ms
Queries	324
Memory Peak Usage	160.6 Mb
Included Files	1120 files - 11.08 Mb
PrestaShop Cache	- Mb
Global vars	0.05 Mb
- global $_SERVER	12k
- global $_ENV	11k
- global $__composer_autoload_files	5k
- global $config	5k
- global $_MODULES	4k
- global $_MODULE	4k
- global $context	3k
- global $exportPhpConfigFile	3k

PrestaShop Version	8.1.1
PHP Version	8.4.23
MySQL Version	10.11.18-MariaDB-log
Memory Limit	-1
Max Execution Time	50000s
Smarty Cache	enabled
Smarty Compilation	force compile

	Time	Cumulated Time	Memory Usage	Memory Peak Usage
config	5.970 ms	5.970 ms	17.77 Mb	18.8 Mb
__construct	7.852 ms	13.822 ms	1.90 Mb	21.4 Mb
init	75.988 ms	89.810 ms	9.62 Mb	30.6 Mb
checkAccess	0.003 ms	89.813 ms	- Mb	30.6 Mb
setMedia	175.010 ms	264.823 ms	37.90 Mb	67.6 Mb
postProcess	0.001 ms	264.824 ms	- Mb	67.6 Mb
initHeader	0.002 ms	264.826 ms	- Mb	67.6 Mb
initContent	655.217 ms	920 ms	5.23 Mb	122.8 Mb
initFooter	0.002 ms	920 ms	- Mb	122.8 Mb
display	999 ms	1919 ms	3.03 Mb	160.6 Mb

Hook	Time	Memory Usage
DisplayFooter	238.156 ms	- Mb
=> blockwishlist	238.156 ms	- Mb
ActionFrontControllerSetMedia	71.718 ms	14.29 Mb
=> blockreassurance	1.046 ms	0.11 Mb
=> blockwishlist	0.280 ms	- Mb
=> ps_emailsubscription	0.087 ms	- Mb
=> ps_socialfollow	0.076 ms	- Mb
=> ps_emailalerts	0.073 ms	- Mb
=> ps_checkout	70.155 ms	14.17 Mb
displayProductListReviews	65.842 ms	4.47 Mb
=> productcomments (widget)	29.391 ms	4.44 Mb
=> productcomments (widget)	4.167 ms	- Mb
=> productcomments (widget)	2.290 ms	- Mb
=> productcomments (widget)	2.523 ms	- Mb
=> productcomments (widget)	2.668 ms	- Mb
=> productcomments (widget)	22.141 ms	- Mb
=> productcomments (widget)	2.662 ms	- Mb
displayNav2	63.797 ms	15.56 Mb
=> ps_languageselector (widget)	0.743 ms	0.04 Mb
=> ps_currencyselector (widget)	0.635 ms	0.06 Mb
=> ps_customersignin (widget)	15.998 ms	3.85 Mb
=> ps_shoppingcart (widget)	16.253 ms	3.94 Mb
=> ps_languageselector (widget)	0.010 ms	- Mb
=> ps_currencyselector (widget)	0.012 ms	- Mb
=> ps_customersignin (widget)	14.842 ms	3.81 Mb
=> ps_shoppingcart (widget)	15.304 ms	3.85 Mb
displayFooter	34.291 ms	7.87 Mb
=> ps_linklist (widget)	1.102 ms	0.13 Mb
=> ps_customeraccountlinks (widget)	0.781 ms	0.08 Mb
=> ps_contactinfo (widget)	32.408 ms	7.66 Mb
displayFooterBefore	32.193 ms	7.84 Mb
=> ps_emailsubscription (widget)	30.571 ms	7.67 Mb
=> ps_socialfollow (widget)	1.622 ms	0.17 Mb
displayContentWrapperTop	15.071 ms	3.83 Mb
=> ps_searchbar (widget)	15.071 ms	3.83 Mb
DisplayHeader	11.527 ms	1.21 Mb
=> ps_shoppingcart	0.066 ms	- Mb
=> ps_searchbar	0.143 ms	- Mb
=> ps_imageslider	0.100 ms	- Mb
=> ps_googleanalytics	11.114 ms	1.21 Mb
=> productcomments	0.104 ms	- Mb
displayNav1	9.586 ms	1.99 Mb
=> ps_contactinfo (widget)	9.586 ms	1.99 Mb
DisplayLeftColumn	8.067 ms	1.99 Mb
=> ps_facetedsearch	8.067 ms	1.99 Mb
displayLeftColumn	7.052 ms	0.22 Mb
=> ps_categorytree (widget)	7.052 ms	0.22 Mb
displayTop	6.285 ms	0.64 Mb
=> ps_mainmenu (widget)	6.285 ms	0.64 Mb
DisplayBeforeBodyClosingTag	4.702 ms	0.28 Mb
=> ps_googleanalytics	4.702 ms	0.28 Mb
ProductSearchProvider	1.894 ms	0.16 Mb
=> ps_facetedsearch	1.894 ms	0.16 Mb
Header	0.065 ms	- Mb
=> customhomeblocks	0.065 ms	- Mb
DisplayAfterBodyOpeningTag	0.010 ms	- Mb
=> blockreassurance	0.010 ms	- Mb
DisplayFooterBefore	0.010 ms	- Mb
=> blockreassurance	0.010 ms	- Mb
DisplayFooterAfter	0.008 ms	- Mb
=> blockreassurance	0.008 ms	- Mb
DisplayNavFullWidth	0.007 ms	- Mb
=> blockreassurance	0.007 ms	- Mb
ModuleRoutes	0.006 ms	- Mb
=> ps_checkout	0.006 ms	- Mb
ActionDispatcherBefore	0.006 ms	- Mb
=> smartredirect	0.006 ms	- Mb
21 hook(s)	570.293 ms	7.26 Mb

Module	Time	Memory Usage
ps_checkout	106.106 ms	18.75 Mb
__construct	35.936 ms	4.58 Mb
hookModuleRoutes	0.010 ms	- Mb
hookActionFrontControllerSetMedia	70.160 ms	14.17 Mb
smartredirect	0.645 ms	0.03 Mb
__construct	0.635 ms	0.03 Mb
hookActionDispatcherBefore	0.010 ms	- Mb
blockreassurance	30.339 ms	6.03 Mb
__construct	29.244 ms	5.91 Mb
hookActionFrontControllerSetMedia	1.050 ms	0.11 Mb
hookDisplayAfterBodyOpeningTag	0.014 ms	- Mb
hookDisplayNavFullWidth	0.009 ms	- Mb
hookDisplayFooterBefore	0.012 ms	- Mb
hookDisplayFooterAfter	0.010 ms	- Mb
blockwishlist	254.183 ms	- Mb
__construct	15.739 ms	3.86 Mb
hookActionFrontControllerSetMedia	0.283 ms	- Mb
hookDisplayFooter	238.161 ms	- Mb
ps_emailsubscription	55.095 ms	13.59 Mb
__construct	24.428 ms	5.92 Mb
hookActionFrontControllerSetMedia	0.091 ms	- Mb
displayFooterBefore	30.576 ms	7.67 Mb
ps_socialfollow	17.436 ms	4.04 Mb
__construct	15.731 ms	3.87 Mb
hookActionFrontControllerSetMedia	0.080 ms	- Mb
displayFooterBefore	1.625 ms	0.17 Mb
ps_emailalerts	16.639 ms	4.05 Mb
__construct	16.561 ms	4.05 Mb
hookActionFrontControllerSetMedia	0.078 ms	- Mb
ps_accounts	31.997 ms	7.78 Mb
__construct	31.997 ms	7.78 Mb
ps_shoppingcart	48.307 ms	11.64 Mb
__construct	16.669 ms	3.84 Mb
hookDisplayHeader	0.070 ms	- Mb
displayNav2	16.258 ms	3.94 Mb
displayNav2	15.310 ms	3.85 Mb
ps_searchbar	31.019 ms	7.66 Mb
__construct	15.795 ms	3.83 Mb
hookDisplayHeader	0.147 ms	- Mb
displayContentWrapperTop	15.077 ms	3.83 Mb
ps_imageslider	17.333 ms	4.02 Mb
__construct	17.229 ms	4.02 Mb
hookDisplayHeader	0.104 ms	- Mb
ps_googleanalytics	39.194 ms	7.24 Mb
__construct	23.369 ms	5.75 Mb
hookDisplayHeader	11.119 ms	1.21 Mb
hookDisplayBeforeBodyClosingTag	4.706 ms	0.28 Mb
productcomments	83.095 ms	8.46 Mb
__construct	17.089 ms	3.98 Mb
hookDisplayHeader	0.108 ms	- Mb
displayProductListReviews	29.395 ms	4.45 Mb
displayProductListReviews	4.176 ms	- Mb
displayProductListReviews	2.297 ms	- Mb
displayProductListReviews	2.532 ms	- Mb
displayProductListReviews	2.677 ms	- Mb
displayProductListReviews	22.150 ms	- Mb
displayProductListReviews	2.671 ms	- Mb
customhomeblocks	15.731 ms	3.85 Mb
__construct	15.662 ms	3.85 Mb
hookHeader	0.069 ms	- Mb
ps_facetedsearch	81.557 ms	19.71 Mb
__construct	71.587 ms	17.55 Mb
hookProductSearchProvider	1.899 ms	0.16 Mb
hookDisplayLeftColumn	8.071 ms	1.99 Mb
ps_contactinfo	57.144 ms	13.49 Mb
__construct	15.138 ms	3.84 Mb
displayNav1	9.592 ms	1.99 Mb
displayFooter	32.414 ms	7.66 Mb
ps_languageselector	14.720 ms	3.87 Mb
__construct	13.956 ms	3.83 Mb
displayNav2	0.753 ms	0.04 Mb
displayNav2	0.011 ms	- Mb
ps_currencyselector	24.328 ms	3.89 Mb
__construct	23.677 ms	3.83 Mb
displayNav2	0.638 ms	0.06 Mb
displayNav2	0.013 ms	- Mb
ps_customersignin	44.426 ms	11.49 Mb
__construct	13.575 ms	3.82 Mb
displayNav2	16.004 ms	3.86 Mb
displayNav2	14.847 ms	3.81 Mb
ps_mainmenu	21.359 ms	4.70 Mb
__construct	15.070 ms	4.06 Mb
displayTop	6.289 ms	0.64 Mb
ps_categorytree	21.529 ms	4.08 Mb
__construct	14.473 ms	3.86 Mb
displayLeftColumn	7.056 ms	0.22 Mb
ps_linklist	35.957 ms	7.84 Mb
__construct	34.851 ms	7.70 Mb
displayFooter	1.106 ms	0.13 Mb
ps_customeraccountlinks	16.593 ms	3.91 Mb
__construct	15.807 ms	3.83 Mb
displayFooter	0.786 ms	0.08 Mb
23 module(s)	1065 ms	120.87 Mb

Collection 2018-2024

Sous-catégories

200 œuvres -...

Oeuvre N°011/200, Orchidée ex.3/5 _ Fleurs de Gironde -...

Oeuvre N°077/200, Danseuse florale _ Bordeaux _...

Oeuvre N°106/200, Le commencement N°1/2 _ Ex.3/5 _...

Oeuvre N°021/200, Double Cosmos

Oeuvre N°178/200, Tournesol _ Terre de Charentes et de...

Oeuvre N°189/200, Martin pêcheur _ Sud Gironde

Oeuvre N°183/200, Regard _ Chouette Chevêche, tuile de...

Stopwatch SQL - 324 queries

Doubles

Tables stress

ObjectModel instances

Included Files

14 queries	SELECT `id_module` FROM `fXXoa_module_shop` WHERE `id_module` = XX AND `id_shop` = XX LIMIT XX
14 queries	SELECT SUM(quantity) FROM `fXXoa_stock_available` WHERE (id_product = XX) AND (id_product_attribute = XX) AND (id_shop = XX) AND (id_shop_group = XX) LIMIT XX
14 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 `fXXoa_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 `fXXoa_cart_product` cp JOIN `fXXoa_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `fXXoa_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
8 queries	SELECT `id_lang` FROM `fXXoa_lang` WHERE `locale` = 'fr-fr' OR `language_code` = 'fr-fr' LIMIT XX
8 queries	SELECT v., vl., IF(lifvlv.`url_name` IS NULL OR lifvlv.`url_name` = "", NULL, lifvlv.`url_name`) AS url_name, IF(lifvlv.`meta_title` IS NULL OR lifvlv.`meta_title` = "", NULL, lifvlv.`meta_title`) AS meta_title FROM `fXXoa_feature_value` v LEFT JOIN `fXXoa_feature_value_lang` vl ON (v.`id_feature_value` = vl.`id_feature_value` AND vl.`id_lang` = XX) LEFT JOIN `fXXoa_layered_indexable_feature_value_lang_value` lifvlv ON (v.`id_feature_value` = lifvlv.`id_feature_value` AND lifvlv.`id_lang` = XX) WHERE v.`id_feature` = XX ORDER BY vl.`value` ASC
8 queries	SELECT XX FROM `fXXoa_specific_price` WHERE id_product = XX LIMIT XX
7 queries	SELECT state FROM fXXoa_feature_flag WHERE name = 'multiple_image_format' LIMIT XX
7 queries	SELECT image_shop.`id_image` FROM `fXXoa_image` i INNER JOIN fXXoa_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
7 queries	SELECT name FROM fXXoa_category_lang WHERE id_shop = XX AND id_lang = XX AND id_category = XX LIMIT XX
7 queries	SELECT * FROM `fXXoa_product` a LEFT JOIN `fXXoa_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = XX LEFT JOIN `fXXoa_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = XX WHERE (a.`id_product` = XX) AND (b.`id_shop` = XX) LIMIT XX
7 queries	SELECT product_attribute_shop.`price` FROM `fXXoa_product_attribute` pa INNER JOIN fXXoa_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
7 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 `fXXoa_product` p INNER JOIN `fXXoa_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = XX) LEFT JOIN `fXXoa_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)
7 queries	SELECT `id_tax_rules_group` FROM `fXXoa_product_shop` WHERE `id_product` = XX AND id_shop=XX LIMIT XX
7 queries	SELECT pa.`available_date` FROM `fXXoa_product` p LEFT JOIN `fXXoa_product_attribute` pa ON (pa.`id_product` = p.`id_product`) INNER JOIN fXXoa_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = XX) INNER JOIN fXXoa_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
7 queries	SELECT name, value, pf.id_feature, f.position, fvl.id_feature_value FROM fXXoa_feature_product pf LEFT JOIN fXXoa_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = XX) LEFT JOIN fXXoa_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = XX) LEFT JOIN fXXoa_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = XX) INNER JOIN fXXoa_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
7 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 `fXXoa_attribute` a LEFT JOIN `fXXoa_attribute_lang` al ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = XX) LEFT JOIN `fXXoa_product_attribute_combination` pac ON (pac.`id_attribute` = a.`id_attribute`) LEFT JOIN `fXXoa_product_attribute` pa ON (pa.`id_product_attribute` = pac.`id_product_attribute`) INNER JOIN fXXoa_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 `fXXoa_product_attribute_lang` pal ON (pal.`id_product_attribute` = pac.`id_product_attribute` AND pal.`id_lang` = XX) LEFT JOIN `fXXoa_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
7 queries	SELECT * FROM `fXXoa_product_attribute` a LEFT JOIN `fXXoa_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
7 queries	SELECT * FROM `fXXoa_product_attribute_lang` WHERE `id_product_attribute` = XX
7 queries	SELECT image_shop.`cover`, i.`id_image`, il.`legend`, i.`position` FROM `fXXoa_image` i INNER JOIN fXXoa_image_shop image_shop ON (image_shop.id_image = i.id_image AND image_shop.id_shop = XX) LEFT JOIN `fXXoa_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = XX) WHERE i.`id_product` = XX ORDER BY `position`
7 queries	SELECT `id_product_attribute` FROM `fXXoa_product_attribute` WHERE `id_product` = XX
7 queries	SELECT pa.`id_product`, a.`color`, pac.`id_product_attribute`, SUM(IF(stock.`quantity` > XX, XX, XX)) qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by FROM `fXXoa_product_attribute` pa INNER JOIN fXXoa_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 fXXoa_stock_available stock ON (stock.id_product = `pa`.id_product AND stock.id_product_attribute = IFNULL(`pa`.id_product_attribute, XX) AND stock.id_shop = XX AND stock.id_shop_group = XX ) JOIN `fXXoa_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`) JOIN `fXXoa_attribute` a ON (a.`id_attribute` = pac.`id_attribute`) JOIN `fXXoa_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = XX) JOIN `fXXoa_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`) WHERE pa.`id_product` IN (XX) AND ag.`is_color_group` = XX GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` HAVING qty > XX ORDER BY a.`position` ASC;
7 queries	SELECT al.`name` AS attribute_name FROM `fXXoa_product_attribute_combination` pac LEFT JOIN `fXXoa_attribute` a ON a.`id_attribute` = pac.`id_attribute` LEFT JOIN `fXXoa_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group` LEFT JOIN `fXXoa_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
5 queries	SELECT `priority`, `id_specific_price_priority` FROM `fXXoa_specific_price_priority` WHERE `id_product` = XX ORDER BY `id_specific_price_priority` DESC LIMIT XX
5 queries	SELECT *, ( IF (`id_shop` = XX, XX, XX) + IF (`id_country` = XX, XX, XX) + IF (`id_currency` = XX, XX, XX) + IF (`id_group` = XX, XX, XX) + IF (`id_customer` = XX, XX, XX)) AS `score` FROM `fXXoa_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
4 queries	SELECT value FROM `fXXoa_configuration` WHERE `name` = "PS_MULTISHOP_FEATURE_ACTIVE" LIMIT XX
4 queries	SELECT * FROM `fXXoa_currency` a LEFT JOIN `fXXoa_currency_lang` `b` ON a.`id_currency` = b.`id_currency` AND b.`id_lang` = XX LEFT JOIN `fXXoa_currency_shop` `c` ON a.`id_currency` = c.`id_currency` AND c.`id_shop` = XX WHERE (a.`id_currency` = XX) LIMIT XX
4 queries	SELECT 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, cp.position FROM fXXoa_product p LEFT JOIN fXXoa_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN fXXoa_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN fXXoa_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, XX) = sa.id_product_attribute AND sa.id_shop = XX AND sa.id_shop_group = XX ) LEFT JOIN fXXoa_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN fXXoa_category_product cp ON (p.id_product = cp.id_product) INNER JOIN fXXoa_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = XX AND ps.active = TRUE) INNER JOIN fXXoa_category c ON (cp.id_category = c.id_category AND c.active=XX) LEFT JOIN fXXoa_feature_product fp_XX ON (p.id_product = fp_XX.id_product) LEFT JOIN fXXoa_feature_product fp_XX ON (p.id_product = fp_XX.id_product) WHERE ((pac.id_attribute IN (XX, XX))) AND ((fp_XX.id_feature_value IN (XX, XX, XX, XX, XX))) AND ((fp_XX.id_feature_value IN (XX, XX))) AND ps.id_shop='XX' AND ps.visibility IN ('both', 'catalog') AND c.nleft>=XX AND c.nright<=XX GROUP BY p.id_product) p INNER JOIN fXXoa_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN fXXoa_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN fXXoa_product_attribute_combination pac_XX ON (pa.id_product_attribute = pac_XX.id_product_attribute) LEFT JOIN fXXoa_feature_product fp_XX ON (p.id_product = fp_XX.id_product) LEFT JOIN fXXoa_feature_product fp_XX ON (p.id_product = fp_XX.id_product) WHERE ((fp.id_feature=XX)) AND ((pac_XX.id_attribute IN (XX, XX))) AND ((fp_XX.id_feature_value IN (XX, XX, XX, XX, XX))) AND ((fp_XX.id_feature_value IN (XX, XX))) GROUP BY fp.id_feature_value
3 queries	SELECT m.`id_module`, m.`name`, ms.`id_module`as `mshop` FROM `fXXoa_module` m LEFT JOIN `fXXoa_module_shop` ms ON m.`id_module` = ms.`id_module` AND ms.`id_shop` = XX
3 queries	SELECT * FROM `fXXoa_category` a LEFT JOIN `fXXoa_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = XX LEFT JOIN `fXXoa_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
3 queries	SELECT `id_configuration` FROM `fXXoa_configuration` WHERE name = 'PS_ACCOUNTS_SHOP_STATUS' AND (id_shop_group IS NULL OR id_shop_group = XX) AND (id_shop IS NULL OR id_shop = XX) LIMIT XX
3 queries	SELECT * FROM `fXXoa_configuration` a WHERE (a.`id_configuration` = XX) LIMIT XX
3 queries	SELECT * FROM `fXXoa_configuration_lang` WHERE `id_configuration` = XX
3 queries	SELECT `need_identification_number` FROM `fXXoa_country` WHERE `id_country` = XX LIMIT XX
3 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 `fXXoa_attribute_group` ag INNER JOIN `fXXoa_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = XX) INNER JOIN `fXXoa_attribute` a ON a.`id_attribute_group` = ag.`id_attribute_group` INNER JOIN `fXXoa_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = XX) INNER JOIN fXXoa_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 fXXoa_attribute_shop attribute_shop ON (attribute_shop.id_attribute = a.id_attribute AND attribute_shop.id_shop = XX) LEFT JOIN `fXXoa_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 c.*, cl.`id_lang`, cl.`name`, cl.`description`, cl.`additional_description`, cl.`link_rewrite`, cl.`meta_title`, cl.`meta_keywords`, cl.`meta_description` FROM `fXXoa_category` c INNER JOIN fXXoa_category_shop category_shop ON (category_shop.id_category = c.id_category AND category_shop.id_shop = XX) LEFT JOIN `fXXoa_category_lang` cl ON (c.`id_category` = cl.`id_category` AND `id_lang` = XX AND cl.id_shop = XX ) WHERE `id_parent` = XX AND `active` = XX GROUP BY c.`id_category` ORDER BY `level_depth` ASC, category_shop.`position` ASC
2 queries	SELECT 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, cp.position FROM fXXoa_product p LEFT JOIN fXXoa_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN fXXoa_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN fXXoa_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, XX) = sa.id_product_attribute AND sa.id_shop = XX AND sa.id_shop_group = XX ) LEFT JOIN fXXoa_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN fXXoa_category_product cp ON (p.id_product = cp.id_product) INNER JOIN fXXoa_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = XX AND ps.active = TRUE) INNER JOIN fXXoa_category c ON (cp.id_category = c.id_category AND c.active=XX) LEFT JOIN fXXoa_feature_product fp_XX ON (p.id_product = fp_XX.id_product) LEFT JOIN fXXoa_feature_product fp_XX ON (p.id_product = fp_XX.id_product) WHERE ((pac.id_attribute IN (XX, XX))) AND ((fp_XX.id_feature_value IN (XX, XX, XX, XX, XX))) AND ((fp_XX.id_feature_value IN (XX, XX))) AND ps.id_shop='XX' AND ps.visibility IN ('both', 'catalog') AND c.nleft>=XX AND c.nright<=XX GROUP BY p.id_product) p LEFT JOIN fXXoa_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN fXXoa_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) INNER JOIN fXXoa_attribute a ON (a.id_attribute = pac.id_attribute) LEFT JOIN fXXoa_product_attribute_combination pac_XX ON (pa.id_product_attribute = pac_XX.id_product_attribute) LEFT JOIN fXXoa_feature_product fp_XX ON (p.id_product = fp_XX.id_product) LEFT JOIN fXXoa_feature_product fp_XX ON (p.id_product = fp_XX.id_product) WHERE ((a.id_attribute_group=XX)) AND ((pac_XX.id_attribute IN (XX, XX))) AND ((fp_XX.id_feature_value IN (XX, XX, XX, XX, XX))) AND ((fp_XX.id_feature_value IN (XX, XX))) GROUP BY pac.id_attribute
2 queries	SELECT cl.`link_rewrite` FROM `fXXoa_category_lang` cl WHERE `id_lang` = XX AND cl.id_shop = XX AND cl.`id_category` = XX LIMIT XX
2 queries	SELECT tr.* FROM `fXXoa_tax_rule` tr JOIN `fXXoa_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 pai.`id_image`, pai.`id_product_attribute`, il.`legend` FROM `fXXoa_product_attribute_image` pai LEFT JOIN `fXXoa_image_lang` il ON (il.`id_image` = pai.`id_image`) LEFT JOIN `fXXoa_image` i ON (i.`id_image` = pai.`id_image`) WHERE pai.`id_product_attribute` IN (XX, XX, XX, XX, XX, XX, XX, XX) AND il.`id_lang` = XX ORDER by i.`position`

Name	Instances	Source
Product	21	/classes/Link.php:113 (__construct) [id: 16] /classes/Link.php:113 (__construct) [id: 41] /classes/Link.php:113 (__construct) [id: 42] /classes/Link.php:113 (__construct) [id: 53] /classes/Link.php:113 (__construct) [id: 89] /classes/Link.php:113 (__construct) [id: 121] /classes/Link.php:113 (__construct) [id: 124] /src/Adapter/Image/ImageRetriever.php:71 (__construct) [id: 16] /src/Adapter/Image/ImageRetriever.php:71 (__construct) [id: 41] /src/Adapter/Image/ImageRetriever.php:71 (__construct) [id: 42] /src/Adapter/Image/ImageRetriever.php:71 (__construct) [id: 53] /src/Adapter/Image/ImageRetriever.php:71 (__construct) [id: 89] /src/Adapter/Image/ImageRetriever.php:71 (__construct) [id: 121] /src/Adapter/Image/ImageRetriever.php:71 (__construct) [id: 124] /classes/Link.php:113 (__construct) [id: 16] /classes/Link.php:113 (__construct) [id: 41] /classes/Link.php:113 (__construct) [id: 42] /classes/Link.php:113 (__construct) [id: 53] /classes/Link.php:113 (__construct) [id: 89] /classes/Link.php:113 (__construct) [id: 121] /classes/Link.php:113 (__construct) [id: 124]
Category	10	/controllers/front/listing/CategoryController.php:76 (__construct) [id: 8] /controllers/front/listing/CategoryController.php:207 (__construct) [id: 5] /classes/Meta.php:380 (__construct) [id: 8] /classes/PrestaShopCollection.php:385 (hydrateCollection) [id: ] /classes/PrestaShopCollection.php:385 (hydrateCollection) [id: ] /classes/PrestaShopCollection.php:385 (hydrateCollection) [id: ] /classes/PrestaShopCollection.php:385 (hydrateCollection) [id: ] /modules/ps_facetedsearch/src/Product/Search.php:365 (__construct) [id: 8] /modules/ps_facetedsearch/src/Filters/Block.php:158 (__construct) [id: 8] /modules/ps_categorytree/ps_categorytree.php:364 (getParentsCategories) [id: 2]
Combination	7	/classes/Product.php:5843 (__construct) [id: 394] /classes/Product.php:5843 (__construct) [id: 677] /classes/Product.php:5843 (__construct) [id: 703] /classes/Product.php:5843 (__construct) [id: 989] /classes/Product.php:5843 (__construct) [id: 1803] /classes/Product.php:5843 (__construct) [id: 2585] /classes/Product.php:5843 (__construct) [id: 2663]
Country	7	/config/config.inc.php:146 (__construct) [id: 8] /classes/AddressFormat.php:404 (__construct) [id: 8] /classes/controller/FrontController.php:1722 (__construct) [id: 8] /classes/AddressFormat.php:404 (__construct) [id: 8] /modules/ps_contactinfo/ps_contactinfo.php:105 (__construct) [id: 8] /classes/AddressFormat.php:404 (__construct) [id: 8] /modules/ps_contactinfo/ps_contactinfo.php:105 (__construct) [id: 8]
Currency	5	/src/Adapter/Currency/CurrencyDataProvider.php:101 (__construct) [id: 2] /src/Adapter/Currency/CurrencyDataProvider.php:101 (__construct) [id: 1] /src/Adapter/Currency/CurrencyDataProvider.php:101 (__construct) [id: 3] /src/Adapter/Currency/CurrencyDataProvider.php:101 (__construct) [id: 4] /classes/Tools.php:687 (getCurrencyInstance) [id: 1]
Address	4	/classes/shop/Shop.php:486 (__construct) [id: ] /classes/Product.php:3684 (initialize) [id: ] /classes/Product.php:3794 (__construct) [id: ] /classes/Product.php:5897 (__construct) [id: ]
State	3	/classes/controller/FrontController.php:1721 (__construct) [id: 0] /modules/ps_contactinfo/ps_contactinfo.php:94 (__construct) [id: 0] /modules/ps_contactinfo/ps_contactinfo.php:94 (__construct) [id: 0]
Configuration	3	/modules/ps_accounts/src/Adapter/Configuration.php:239 (__construct) [id: 705] /modules/ps_accounts/src/Adapter/Configuration.php:239 (__construct) [id: 705] /modules/ps_accounts/src/Adapter/Configuration.php:239 (__construct) [id: 705]
AddressFormat	3	/classes/controller/FrontController.php:1716 (generateAddress) [id: ] /modules/ps_contactinfo/ps_contactinfo.php:91 (generateAddress) [id: ] /modules/ps_contactinfo/ps_contactinfo.php:91 (generateAddress) [id: ]
Language	2	/config/config.inc.php:211 (__construct) [id: 2] /classes/Tools.php:559 (__construct) [id: 2]
Cart	2	/classes/controller/FrontController.php:427 (__construct) [id: ] /classes/controller/FrontController.php:497 (__construct) [id: ]
Shop	1	/config/config.inc.php:117 (initialize) [id: 1]
Risk	1	/classes/controller/FrontController.php:1649 (__construct) [id: ]
Gender	1	/classes/controller/FrontController.php:1646 (__construct) [id: 0]
Customer	1	/config/config.inc.php:264 (__construct) [id: ]
ShopGroup	1	/classes/shop/Shop.php:561 (__construct) [id: 1]
Group	1	/classes/Cart.php:249 (getCurrent) [id: 1]

#	Query	Time (ms)	Rows	Filesort	Group By	Location
94	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, cp.position FROM f1oa_product p LEFT JOIN f1oa_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN f1oa_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN f1oa_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 f1oa_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN f1oa_category_product cp ON (p.id_product = cp.id_product) INNER JOIN f1oa_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN f1oa_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN f1oa_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN f1oa_feature_product fp_1 ON (p.id_product = fp_1.id_product) WHERE ((fp.id_feature_value IN (177, 179, 419, 181, 417))) AND ((fp_1.id_feature_value IN (208, 216))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND c.nleft>=31 AND c.nright<=36 GROUP BY p.id_product) p LEFT JOIN f1oa_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN f1oa_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) INNER JOIN f1oa_attribute a ON (a.id_attribute = pac.id_attribute) LEFT JOIN f1oa_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN f1oa_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((a.id_attribute_group=13)) AND ((fp_1.id_feature_value IN (177, 179, 419, 181, 417))) AND ((fp_2.id_feature_value IN (208, 216))) GROUP BY pac.id_attribute	100.083 ms	742500	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:808 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:738 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:151 (getAttributesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:218 (getFilterBlock) /classes/controller/ProductListingFrontController.php:355 (runQuery) /classes/controller/ProductListingFrontController.php:634 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:133 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
99	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, cp.position FROM f1oa_product p LEFT JOIN f1oa_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN f1oa_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN f1oa_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 f1oa_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN f1oa_category_product cp ON (p.id_product = cp.id_product) INNER JOIN f1oa_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN f1oa_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN f1oa_feature_product fp_1 ON (p.id_product = fp_1.id_product) WHERE ((pac.id_attribute IN (19, 25))) AND ((fp_1.id_feature_value IN (177, 179, 419, 181, 417))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND c.nleft>=31 AND c.nright<=36 GROUP BY p.id_product) p INNER JOIN f1oa_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN f1oa_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN f1oa_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) LEFT JOIN f1oa_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((fp.id_feature=7)) AND ((pac_1.id_attribute IN (19, 25))) AND ((fp_2.id_feature_value IN (177, 179, 419, 181, 417))) GROUP BY fp.id_feature_value	7.560 ms	9072000	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:808 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:856 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:155 (getFeaturesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:218 (getFilterBlock) /classes/controller/ProductListingFrontController.php:355 (runQuery) /classes/controller/ProductListingFrontController.php:634 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:133 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
92	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, cp.position FROM f1oa_product p LEFT JOIN f1oa_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN f1oa_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN f1oa_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 f1oa_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN f1oa_category_product cp ON (p.id_product = cp.id_product) INNER JOIN f1oa_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN f1oa_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN f1oa_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN f1oa_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((pac.id_attribute IN (19, 25))) AND ((fp_1.id_feature_value IN (177, 179, 419, 181, 417))) AND ((fp_2.id_feature_value IN (208, 216))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND c.nleft>=31 AND c.nright<=36 GROUP BY p.id_product) p INNER JOIN f1oa_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN f1oa_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN f1oa_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) LEFT JOIN f1oa_feature_product fp_2 ON (p.id_product = fp_2.id_product) LEFT JOIN f1oa_feature_product fp_3 ON (p.id_product = fp_3.id_product) WHERE ((fp.id_feature=3)) AND ((pac_1.id_attribute IN (19, 25))) AND ((fp_2.id_feature_value IN (177, 179, 419, 181, 417))) AND ((fp_3.id_feature_value IN (208, 216))) GROUP BY fp.id_feature_value	6.478 ms	742500	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:808 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:856 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:155 (getFeaturesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:218 (getFilterBlock) /classes/controller/ProductListingFrontController.php:355 (runQuery) /classes/controller/ProductListingFrontController.php:634 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:133 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
104	SELECT SQL_NO_CACHE p.id_manufacturer, 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, cp.position FROM f1oa_product p LEFT JOIN f1oa_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN f1oa_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN f1oa_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 f1oa_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN f1oa_category_product cp ON (p.id_product = cp.id_product) INNER JOIN f1oa_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN f1oa_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN f1oa_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN f1oa_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((pac.id_attribute IN (19, 25))) AND ((fp_1.id_feature_value IN (177, 179, 419, 181, 417))) AND ((fp_2.id_feature_value IN (208, 216))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND c.nleft>=31 AND c.nright<=36 GROUP BY p.id_product) p LEFT JOIN f1oa_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN f1oa_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN f1oa_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN f1oa_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((pac.id_attribute IN (19, 25))) AND ((fp_1.id_feature_value IN (177, 179, 419, 181, 417))) AND ((fp_2.id_feature_value IN (208, 216))) GROUP BY p.id_manufacturer	4.771 ms	742500	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:808 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:662 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:147 (getManufacturersBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:218 (getFilterBlock) /classes/controller/ProductListingFrontController.php:355 (runQuery) /classes/controller/ProductListingFrontController.php:634 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:133 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
98	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, cp.position FROM f1oa_product p LEFT JOIN f1oa_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN f1oa_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN f1oa_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 f1oa_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN f1oa_category_product cp ON (p.id_product = cp.id_product) INNER JOIN f1oa_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN f1oa_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN f1oa_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN f1oa_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((pac.id_attribute IN (19, 25))) AND ((fp_1.id_feature_value IN (177, 179, 419, 181, 417))) AND ((fp_2.id_feature_value IN (208, 216))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND c.nleft>=31 AND c.nright<=36 GROUP BY p.id_product) p LEFT JOIN f1oa_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN f1oa_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) INNER JOIN f1oa_attribute a ON (a.id_attribute = pac.id_attribute) LEFT JOIN f1oa_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) LEFT JOIN f1oa_feature_product fp_2 ON (p.id_product = fp_2.id_product) LEFT JOIN f1oa_feature_product fp_3 ON (p.id_product = fp_3.id_product) WHERE ((a.id_attribute_group=11)) AND ((pac_1.id_attribute IN (19, 25))) AND ((fp_2.id_feature_value IN (177, 179, 419, 181, 417))) AND ((fp_3.id_feature_value IN (208, 216))) GROUP BY pac.id_attribute	4.673 ms	742500	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:808 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:738 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:151 (getAttributesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:218 (getFilterBlock) /classes/controller/ProductListingFrontController.php:355 (runQuery) /classes/controller/ProductListingFrontController.php:634 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:133 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
101	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, cp.position FROM f1oa_product p LEFT JOIN f1oa_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN f1oa_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN f1oa_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 f1oa_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN f1oa_category_product cp ON (p.id_product = cp.id_product) INNER JOIN f1oa_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN f1oa_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN f1oa_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN f1oa_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((pac.id_attribute IN (19, 25))) AND ((fp_1.id_feature_value IN (177, 179, 419, 181, 417))) AND ((fp_2.id_feature_value IN (208, 216))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND c.nleft>=31 AND c.nright<=36 GROUP BY p.id_product) p INNER JOIN f1oa_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN f1oa_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN f1oa_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) LEFT JOIN f1oa_feature_product fp_2 ON (p.id_product = fp_2.id_product) LEFT JOIN f1oa_feature_product fp_3 ON (p.id_product = fp_3.id_product) WHERE ((fp.id_feature=8)) AND ((pac_1.id_attribute IN (19, 25))) AND ((fp_2.id_feature_value IN (177, 179, 419, 181, 417))) AND ((fp_3.id_feature_value IN (208, 216))) GROUP BY fp.id_feature_value	4.560 ms	742500	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:808 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:856 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:155 (getFeaturesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:218 (getFilterBlock) /classes/controller/ProductListingFrontController.php:355 (runQuery) /classes/controller/ProductListingFrontController.php:634 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:133 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /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, cp.position FROM f1oa_product p LEFT JOIN f1oa_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN f1oa_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN f1oa_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 f1oa_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN f1oa_category_product cp ON (p.id_product = cp.id_product) INNER JOIN f1oa_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN f1oa_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN f1oa_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN f1oa_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((pac.id_attribute IN (19, 25))) AND ((fp_1.id_feature_value IN (177, 179, 419, 181, 417))) AND ((fp_2.id_feature_value IN (208, 216))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND c.nleft>=31 AND c.nright<=36 GROUP BY p.id_product) p INNER JOIN f1oa_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN f1oa_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN f1oa_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) LEFT JOIN f1oa_feature_product fp_2 ON (p.id_product = fp_2.id_product) LEFT JOIN f1oa_feature_product fp_3 ON (p.id_product = fp_3.id_product) WHERE ((fp.id_feature=5)) AND ((pac_1.id_attribute IN (19, 25))) AND ((fp_2.id_feature_value IN (177, 179, 419, 181, 417))) AND ((fp_3.id_feature_value IN (208, 216))) GROUP BY fp.id_feature_value	4.330 ms	742500	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:808 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:856 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:155 (getFeaturesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:218 (getFilterBlock) /classes/controller/ProductListingFrontController.php:355 (runQuery) /classes/controller/ProductListingFrontController.php:634 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:133 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
107	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, cp.position FROM f1oa_product p LEFT JOIN f1oa_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN f1oa_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN f1oa_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 f1oa_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN f1oa_category_product cp ON (p.id_product = cp.id_product) INNER JOIN f1oa_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN f1oa_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN f1oa_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN f1oa_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((pac.id_attribute IN (19, 25))) AND ((fp_1.id_feature_value IN (177, 179, 419, 181, 417))) AND ((fp_2.id_feature_value IN (208, 216))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND c.nleft>=31 AND c.nright<=36 GROUP BY p.id_product) p INNER JOIN f1oa_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN f1oa_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN f1oa_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) LEFT JOIN f1oa_feature_product fp_2 ON (p.id_product = fp_2.id_product) LEFT JOIN f1oa_feature_product fp_3 ON (p.id_product = fp_3.id_product) WHERE ((fp.id_feature=14)) AND ((pac_1.id_attribute IN (19, 25))) AND ((fp_2.id_feature_value IN (177, 179, 419, 181, 417))) AND ((fp_3.id_feature_value IN (208, 216))) GROUP BY fp.id_feature_value	3.359 ms	742500	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:808 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:856 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:155 (getFeaturesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:218 (getFilterBlock) /classes/controller/ProductListingFrontController.php:355 (runQuery) /classes/controller/ProductListingFrontController.php:634 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:133 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
95	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, cp.position FROM f1oa_product p LEFT JOIN f1oa_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN f1oa_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN f1oa_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 f1oa_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN f1oa_category_product cp ON (p.id_product = cp.id_product) INNER JOIN f1oa_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN f1oa_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN f1oa_feature_product fp_1 ON (p.id_product = fp_1.id_product) WHERE ((pac.id_attribute IN (19, 25))) AND ((fp_1.id_feature_value IN (208, 216))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND c.nleft>=31 AND c.nright<=36 GROUP BY p.id_product) p INNER JOIN f1oa_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN f1oa_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN f1oa_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) LEFT JOIN f1oa_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((fp.id_feature=2)) AND ((pac_1.id_attribute IN (19, 25))) AND ((fp_2.id_feature_value IN (208, 216))) GROUP BY fp.id_feature_value	3.317 ms	5544000	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:808 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:856 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:155 (getFeaturesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:218 (getFilterBlock) /classes/controller/ProductListingFrontController.php:355 (runQuery) /classes/controller/ProductListingFrontController.php:634 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:133 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
85	SELECT SQL_NO_CACHE p.id_product, p.id_product_attribute 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, cp.position FROM f1oa_product p LEFT JOIN f1oa_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN f1oa_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN f1oa_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 f1oa_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN f1oa_category_product cp ON (p.id_product = cp.id_product) INNER JOIN f1oa_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN f1oa_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN f1oa_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN f1oa_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((pac.id_attribute IN (19, 25))) AND ((fp_1.id_feature_value IN (177, 179, 419, 181, 417))) AND ((fp_2.id_feature_value IN (208, 216))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND c.nleft>=31 AND c.nright<=36 GROUP BY p.id_product) p LEFT JOIN f1oa_product_attribute pa ON (p.id_product = pa.id_product) INNER JOIN f1oa_category_product cp ON (p.id_product = cp.id_product) GROUP BY p.id_product ORDER BY p.position ASC, p.id_product DESC	3.085 ms	1094688000	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:189 (getProductByFilters) /classes/controller/ProductListingFrontController.php:355 (runQuery) /classes/controller/ProductListingFrontController.php:634 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:133 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
91	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, cp.position FROM f1oa_product p LEFT JOIN f1oa_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN f1oa_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN f1oa_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 f1oa_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN f1oa_category_product cp ON (p.id_product = cp.id_product) INNER JOIN f1oa_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN f1oa_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN f1oa_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN f1oa_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((pac.id_attribute IN (19, 25))) AND ((fp_1.id_feature_value IN (177, 179, 419, 181, 417))) AND ((fp_2.id_feature_value IN (208, 216))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND c.nleft>=31 AND c.nright<=36 GROUP BY p.id_product) p INNER JOIN f1oa_category_product cp ON (p.id_product = cp.id_product) INNER JOIN f1oa_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN f1oa_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN f1oa_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN f1oa_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN f1oa_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((pac.id_attribute IN (19, 25))) AND ((fp_1.id_feature_value IN (177, 179, 419, 181, 417))) AND ((fp_2.id_feature_value IN (208, 216))) AND c.level_depth<=5 AND c.nleft>31 AND c.nright<36 GROUP BY cp.id_category	2.933 ms	18900000	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:808 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:993 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:159 (getCategoriesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:218 (getFilterBlock) /classes/controller/ProductListingFrontController.php:355 (runQuery) /classes/controller/ProductListingFrontController.php:634 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:133 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
87	SELECT SQL_NO_CACHE psi.price_min, MIN(price_min) as min, MAX(price_max) as max FROM f1oa_product p INNER JOIN f1oa_layered_price_index psi ON (psi.id_product = p.id_product AND psi.id_shop = 1 AND psi.id_currency = 1 AND psi.id_country = 8) INNER JOIN f1oa_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN f1oa_category_product cp ON (p.id_product = cp.id_product) INNER JOIN f1oa_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN f1oa_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN f1oa_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN f1oa_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN f1oa_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((pac.id_attribute IN (19, 25))) AND ((fp_1.id_feature_value IN (177, 179, 419, 181, 417))) AND ((fp_2.id_feature_value IN (208, 216))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND c.nleft>=31 AND c.nright<=36	2.379 ms	42000			/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:57 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:251 (getMinMaxPriceValue) /modules/ps_facetedsearch/src/Filters/Block.php:132 (getPriceRangeBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:218 (getFilterBlock) /classes/controller/ProductListingFrontController.php:355 (runQuery) /classes/controller/ProductListingFrontController.php:634 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:133 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
106	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, cp.position FROM f1oa_product p LEFT JOIN f1oa_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN f1oa_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN f1oa_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 f1oa_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN f1oa_category_product cp ON (p.id_product = cp.id_product) INNER JOIN f1oa_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN f1oa_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN f1oa_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN f1oa_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((pac.id_attribute IN (19, 25))) AND ((fp_1.id_feature_value IN (177, 179, 419, 181, 417))) AND ((fp_2.id_feature_value IN (208, 216))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND c.nleft>=31 AND c.nright<=36 GROUP BY p.id_product) p LEFT JOIN f1oa_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN f1oa_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) INNER JOIN f1oa_attribute a ON (a.id_attribute = pac.id_attribute) LEFT JOIN f1oa_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) LEFT JOIN f1oa_feature_product fp_2 ON (p.id_product = fp_2.id_product) LEFT JOIN f1oa_feature_product fp_3 ON (p.id_product = fp_3.id_product) WHERE ((a.id_attribute_group=14)) AND ((pac_1.id_attribute IN (19, 25))) AND ((fp_2.id_feature_value IN (177, 179, 419, 181, 417))) AND ((fp_3.id_feature_value IN (208, 216))) GROUP BY pac.id_attribute	1.677 ms	742500	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:808 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:738 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:151 (getAttributesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:218 (getFilterBlock) /classes/controller/ProductListingFrontController.php:355 (runQuery) /classes/controller/ProductListingFrontController.php:634 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:133 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
129	SELECT SQL_NO_CACHE `id_hook`, `name` FROM `f1oa_hook` UNION SELECT `id_hook`, ha.`alias` as name FROM `f1oa_hook_alias` ha INNER JOIN `f1oa_hook` h ON ha.name = h.name	1.448 ms	0			/classes/Hook.php:1242 /classes/Hook.php:225 (getAllHookIds) /classes/tax/TaxManagerFactory.php:67 (getIdByName) /classes/tax/TaxManagerFactory.php:46 (execHookTaxManagerFactory) /classes/Product.php:3915 (getManager) /classes/Product.php:3706 (priceCalculation) /classes/Product.php:5637 (getPriceStatic) /classes/ProductAssembler.php:206 (getProductProperties) /classes/controller/ProductListingFrontController.php:108 (assembleProducts) /classes/controller/ProductListingFrontController.php:377 (prepareMultipleProductsForTemplate) /classes/controller/ProductListingFrontController.php:634 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:133 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
109	REPLACE INTO f1oa_layered_filter_block (hash, data) VALUES ("2319a5c7859a114308a282927c3f3482", "a:1:{s:7:\"filters\";a:11:{i:0;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:180;s:3:\"min\";d:135;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:7;s:5:\"value\";N;}i:1;a:9:{s:9:\"type_lite\";s:10:\"id_feature\";s:4:\"type\";s:10:\"id_feature\";s:6:\"id_key\";i:5;s:6:\"values\";a:2:{i:195;a:4:{s:3:\"nbr\";i:7;s:4:\"name\";s:12:\"Sur commande\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:197;a:4:{s:3:\"nbr\";i:2;s:4:\"name\";s:26:\"Tirage d\'expo N°0/5 dispo\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}}s:4:\"name\";s:5:\"Stock\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";i:0;}i:2;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:1:{i:5;a:2:{s:4:\"name\";s:70:\"200 œuvres - Photographies et Poèmes - Tirage d\'art et Tirage d\'expo\";s:3:\"nbr\";i:7;}}s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";i:0;}i:3;a:9:{s:9:\"type_lite\";s:10:\"id_feature\";s:4:\"type\";s:10:\"id_feature\";s:6:\"id_key\";i:3;s:6:\"values\";a:4:{i:192;a:4:{s:3:\"nbr\";i:4;s:4:\"name\";s:10:\"Carré 1:1\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:193;a:4:{s:3:\"nbr\";i:2;s:4:\"name\";s:12:\"Panorama 2:1\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:190;a:4:{s:3:\"nbr\";i:3;s:4:\"name\";s:11:\"Paysage 3:2\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:191;a:4:{s:3:\"nbr\";i:6;s:4:\"name\";s:12:\"Portrait 2:3\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}}s:4:\"name\";s:11:\"Orientation\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";i:0;}i:4;a:10:{s:9:\"type_lite\";s:18:\"id_attribute_group\";s:4:\"type\";s:18:\"id_attribute_group\";s:6:\"id_key\";i:13;s:4:\"name\";s:20:\"Choix des Dimensions\";s:14:\"is_color_group\";b:0;s:6:\"values\";a:10:{i:18;a:4:{s:4:\"name\";s:7:\"40x60cm\";s:3:\"nbr\";i:5;s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:19;a:5:{s:4:\"name\";s:7:\"60x90cm\";s:3:\"nbr\";i:7;s:8:\"url_name\";N;s:10:\"meta_title\";N;s:7:\"checked\";b:1;}i:20;a:4:{s:4:\"name\";s:8:\"80x120cm\";s:3:\"nbr\";i:6;s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:21;a:4:{s:4:\"name\";s:8:\"40x120cm\";s:3:\"nbr\";i:2;s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:23;a:4:{s:4:\"name\";s:8:\"50x100cm\";s:3:\"nbr\";i:4;s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:24;a:4:{s:4:\"name\";s:20:\"création sur mesure\";s:3:\"nbr\";i:2;s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:25;a:5:{s:4:\"name\";s:7:\"40x80cm\";s:3:\"nbr\";i:1;s:8:\"url_name\";N;s:10:\"meta_title\";N;s:7:\"checked\";b:1;}i:26;a:4:{s:4:\"name\";s:7:\"80x80cm\";s:3:\"nbr\";i:4;s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:16;a:4:{s:4:\"name\";s:9:\"100x100cm\";s:3:\"nbr\";i:4;s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:15;a:4:{s:4:\"name\";s:7:\"60x60cm\";s:3:\"nbr\";i:4;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;}i:5;a:9:{s:9:\"type_lite\";s:10:\"id_feature\";s:4:\"type\";s:10:\"id_feature\";s:6:\"id_key\";i:2;s:6:\"values\";a:7:{i:175;a:4:{s:3:\"nbr\";i:1;s:4:\"name\";s:4:\"2018\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:177;a:5:{s:3:\"nbr\";i:3;s:4:\"name\";s:4:\"2020\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:7:\"checked\";b:1;}i:179;a:5:{s:3:\"nbr\";i:3;s:4:\"name\";s:4:\"2022\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:7:\"checked\";b:1;}i:180;a:4:{s:3:\"nbr\";i:5;s:4:\"name\";s:4:\"2023\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:181;a:5:{s:3:\"nbr\";i:2;s:4:\"name\";s:4:\"2024\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:7:\"checked\";b:1;}i:292;a:4:{s:3:\"nbr\";i:1;s:4:\"name\";s:4:\"2025\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:174;a:4:{s:3:\"nbr\";i:1;s:4:\"name\";s:10:\"avant-2018\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}}s:4:\"name\";s:6:\"Année\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";i:0;}i:6;a:10:{s:9:\"type_lite\";s:18:\"id_attribute_group\";s:4:\"type\";s:18:\"id_attribute_group\";s:6:\"id_key\";i:11;s:4:\"name\";s:20:\"Choix de la commande\";s:14:\"is_color_group\";b:0;s:6:\"values\";a:2:{i:2;a:4:{s:4:\"name\";s:38:\"Tirage d\'expo N° 0/5 (numéroté 0/5)\";s:3:\"nbr\";i:7;s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:3;a:4:{s:4:\"name\";s:47:\"Oeuvre originale N° x/5 (certifiée, signée)\";s:3:\"nbr\";i:7;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;}i:7;a:9:{s:9:\"type_lite\";s:10:\"id_feature\";s:4:\"type\";s:10:\"id_feature\";s:6:\"id_key\";i:7;s:6:\"values\";a:22:{i:200;a:4:{s:3:\"nbr\";i:9;s:4:\"name\";s:16:\"Ambiance de Nuit\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:209;a:4:{s:3:\"nbr\";i:11;s:4:\"name\";s:17:\"Arbres Solitaires\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:202;a:4:{s:3:\"nbr\";i:2;s:4:\"name\";s:12:\"Architecture\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:205;a:4:{s:3:\"nbr\";i:8;s:4:\"name\";s:17:\"Astrophotographie\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:210;a:4:{s:3:\"nbr\";i:12;s:4:\"name\";s:23:\"Aux portes de l\'univers\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:221;a:4:{s:3:\"nbr\";i:9;s:4:\"name\";s:17:\"Bassin d\'Arcachon\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:212;a:4:{s:3:\"nbr\";i:1;s:4:\"name\";s:10:\"Blockhauss\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:207;a:4:{s:3:\"nbr\";i:1;s:4:\"name\";s:22:\"Cabane, Pont et ponton\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:222;a:4:{s:3:\"nbr\";i:8;s:4:\"name\";s:13:\"Dune du Pilat\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:214;a:4:{s:3:\"nbr\";i:10;s:4:\"name\";s:16:\"Emotions du Ciel\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:208;a:5:{s:3:\"nbr\";i:4;s:4:\"name\";s:6:\"Fleurs\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:7:\"checked\";b:1;}i:211;a:4:{s:3:\"nbr\";i:15;s:4:\"name\";s:22:\"Histoires et Aventures\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:215;a:4:{s:3:\"nbr\";i:8;s:4:\"name\";s:14:\"Lacs et Océan\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:218;a:4:{s:3:\"nbr\";i:4;s:4:\"name\";s:8:\"Montagne\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:217;a:4:{s:3:\"nbr\";i:14;s:4:\"name\";s:10:\"Nature Zen\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:201;a:4:{s:3:\"nbr\";i:2;s:4:\"name\";s:13:\"Noir et Blanc\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:204;a:4:{s:3:\"nbr\";i:1;s:4:\"name\";s:13:\"Proxi & Macro\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:213;a:4:{s:3:\"nbr\";i:7;s:4:\"name\";s:16:\"Regards d\'Hommes\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:216;a:5:{s:3:\"nbr\";i:3;s:4:\"name\";s:19:\"Rencontres sauvages\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:7:\"checked\";b:1;}i:220;a:4:{s:3:\"nbr\";i:8;s:4:\"name\";s:26:\"Vestige et traces du Temps\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:219;a:4:{s:3:\"nbr\";i:4;s:4:\"name\";s:37:\"Vignes, Châteaux, Moulins et Eglises\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:206;a:4:{s:3:\"nbr\";i:2;s:4:\"name\";s:6:\"Villes\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}}s:4:\"name\";s:7:\"Thèmes\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";i:0;}i:8;a:9:{s:9:\"type_lite\";s:10:\"id_feature\";s:4:\"type\";s:10:\"id_feature\";s:6:\"id_key\";i:8;s:6:\"values\";a:2:{i:188;a:4:{s:3:\"nbr\";i:7;s:4:\"name\";s:45:\"5 exemplaires ( Tirage d\'art x/5 uniquement )\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:186;a:4:{s:3:\"nbr\";i:1;s:4:\"name\";s:46:\"Tirage d\'expo 0/5 ( Tirage d\'expo uniquement )\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}}s:4:\"name\";s:18:\"Tirage Limitée á\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";i:0;}i:9;a:7:{s:9:\"type_lite\";s:12:\"manufacturer\";s:4:\"type\";s:12:\"manufacturer\";s:6:\"id_key\";i:0;s:4:\"name\";s:6:\"Marque\";s:6:\"values\";a:1:{i:1;a:2:{s:4:\"name\";s:18:\"Aurélien Lavignac\";s:3:\"nbr\";i:7;}}s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";i:0;}i:10;a:9:{s:9:\"type_lite\";s:10:\"id_feature\";s:4:\"type\";s:10:\"id_feature\";s:6:\"id_key\";i:14;s:6:\"values\";a:3:{i:306;a:4:{s:3:\"nbr\";i:2;s:4:\"name\";s:26:\"Autour de Bordeaux (33-47)\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:305;a:4:{s:3:\"nbr\";i:1;s:4:\"name\";s:13:\"Bordeaux (33)\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:303;a:4:{s:3:\"nbr\";i:1;s:4:\"name\";s:15:\"Charentes 16-17\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}}s:4:\"name\";s:19:\"Lieu du Stage Photo\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";i:0;}}}")	1.288 ms	1			/modules/ps_facetedsearch/src/Filters/Block.php:210 /modules/ps_facetedsearch/src/Product/SearchProvider.php:220 (insertIntoCache) /classes/controller/ProductListingFrontController.php:355 (runQuery) /classes/controller/ProductListingFrontController.php:634 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:133 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
289	SELECT SQL_NO_CACHE c., cl. FROM `f1oa_category` c INNER JOIN f1oa_category_shop category_shop ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1) LEFT JOIN `f1oa_category_lang` cl ON c.`id_category` = cl.`id_category` AND cl.id_shop = 1 RIGHT JOIN `f1oa_category` c2 ON c2.`id_category` = 8 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright` WHERE 1 AND c.`level_depth` <= 10 AND `id_lang` = 2 AND c.`active` = 1 ORDER BY c.`level_depth` ASC, category_shop.`position` ASC	1.136 ms	16	Yes		/classes/Category.php:782 /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:1004 (renderWidget) /tools/profiling/Hook.php:64 (coreRenderWidget) /classes/Hook.php:948 (coreRenderWidget) /config/smarty.config.inc.php:205 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/6d/b0/10/6db010da081764cb9b7ddedbe0282abc1b67e8ac_2.file.layout-both-columns.tpl.php:257 (__call) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/6d/b0/10/6db010da081764cb9b7ddedbe0282abc1b67e8ac_2.file.layout-both-columns.tpl.php:90 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6a5f9732044ca3_39066569) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:115 (_subTemplateRender) /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/fa/8c/e6/fa8ce6c3d91e09e3e88afbf6f791fc939c6ae143_2.file.layout-left-column.tpl.php:39 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6a5f9732035ce7_65544955) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:115 (_subTemplateRender) /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/dd/43/81/dd4381a43365b08e141df9c928b8b566eb89fce9_2.file.product-list.tpl.php:45 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6a5f9732030c92_48144070) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:115 (_subTemplateRender) /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/e0/24/30/e024303655cfdd7b88d1ed58318733a39c8e773c_2.file.category.tpl.php:44 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6a5f9732022db2_04163810) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/Smarty/SmartyDev.php:40 (fetch) /classes/controller/FrontController.php:715 (fetch) /classes/controller/FrontController.php:697 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
102	SELECT SQL_NO_CACHE v., vl., IF(lifvlv.`url_name` IS NULL OR lifvlv.`url_name` = "", NULL, lifvlv.`url_name`) AS url_name, IF(lifvlv.`meta_title` IS NULL OR lifvlv.`meta_title` = "", NULL, lifvlv.`meta_title`) AS meta_title FROM `f1oa_feature_value` v LEFT JOIN `f1oa_feature_value_lang` vl ON (v.`id_feature_value` = vl.`id_feature_value` AND vl.`id_lang` = 2) LEFT JOIN `f1oa_layered_indexable_feature_value_lang_value` lifvlv ON (v.`id_feature_value` = lifvlv.`id_feature_value` AND lifvlv.`id_lang` = 2) WHERE v.`id_feature` = 8 ORDER BY vl.`value` ASC	0.928 ms	808	Yes		/modules/ps_facetedsearch/src/Filters/DataAccessor.php:194 /modules/ps_facetedsearch/src/Filters/Block.php:865 (getFeatureValues) /modules/ps_facetedsearch/src/Filters/Block.php:155 (getFeaturesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:218 (getFilterBlock) /classes/controller/ProductListingFrontController.php:355 (runQuery) /classes/controller/ProductListingFrontController.php:634 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:133 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
130	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 `f1oa_hook_module` hm STRAIGHT_JOIN `f1oa_hook` h ON (h.id_hook = hm.id_hook AND hm.id_shop = 1) STRAIGHT_JOIN `f1oa_module` as m ON (m.id_module = hm.id_module) ORDER BY hm.position	0.885 ms	378			/classes/Hook.php:452 /classes/Hook.php:493 (getHookModuleList) /classes/tax/TaxManagerFactory.php:67 (getModulesFromHook) /classes/tax/TaxManagerFactory.php:46 (execHookTaxManagerFactory) /classes/Product.php:3915 (getManager) /classes/Product.php:3706 (priceCalculation) /classes/Product.php:5637 (getPriceStatic) /classes/ProductAssembler.php:206 (getProductProperties) /classes/controller/ProductListingFrontController.php:108 (assembleProducts) /classes/controller/ProductListingFrontController.php:377 (prepareMultipleProductsForTemplate) /classes/controller/ProductListingFrontController.php:634 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:133 (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 `f1oa_configuration` c LEFT JOIN `f1oa_configuration_lang` cl ON (c.`id_configuration` = cl.`id_configuration`)	0.863 ms	2584			/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)
48	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 `f1oa_category` c INNER JOIN f1oa_category_shop category_shop ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1) LEFT JOIN `f1oa_category_lang` cl ON (c.`id_category` = cl.`id_category` AND `id_lang` = 2 AND cl.id_shop = 1 ) WHERE `id_parent` = 8 AND `active` = 1 GROUP BY c.`id_category` ORDER BY `level_depth` ASC, category_shop.`position` ASC	0.778 ms	1	Yes	Yes	/classes/Category.php:913 /controllers/front/listing/CategoryController.php:223 (getSubCategories) /controllers/front/listing/CategoryController.php:117 (getTemplateVarSubCategories) /tools/profiling/Controller.php:41 (init) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
103	SELECT SQL_NO_CACHE m.*, ml.`description`, ml.`short_description` FROM `f1oa_manufacturer` m INNER JOIN f1oa_manufacturer_shop manufacturer_shop ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 1)INNER JOIN `f1oa_manufacturer_lang` ml ON (m.`id_manufacturer` = ml.`id_manufacturer` AND ml.`id_lang` = 2)WHERE 1 AND m.`active` = 1 ORDER BY m.`name` ASC	0.752 ms	1	Yes		/classes/Manufacturer.php:201 /modules/ps_facetedsearch/src/Filters/Block.php:653 (getManufacturers) /modules/ps_facetedsearch/src/Filters/Block.php:147 (getManufacturersBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:218 (getFilterBlock) /classes/controller/ProductListingFrontController.php:355 (runQuery) /classes/controller/ProductListingFrontController.php:634 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:133 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
297	SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, SUM(IF(stock.`quantity` > 0, 1, 0)) qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by FROM `f1oa_product_attribute` pa INNER JOIN f1oa_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) LEFT JOIN f1oa_stock_available stock ON (stock.id_product = `pa`.id_product AND stock.id_product_attribute = IFNULL(`pa`.id_product_attribute, 0) AND stock.id_shop = 1 AND stock.id_shop_group = 0 ) JOIN `f1oa_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`) JOIN `f1oa_attribute` a ON (a.`id_attribute` = pac.`id_attribute`) JOIN `f1oa_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 2) JOIN `f1oa_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`) WHERE pa.`id_product` IN (16) AND ag.`is_color_group` = 1 GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` HAVING qty > 0 ORDER BY a.`position` ASC;	0.716 ms	25	Yes		/classes/Product.php:4486 /src/Adapter/Product/ProductColorsRetriever.php:43 (getAttributesColorList) /src/Adapter/Presenter/Product/ProductLazyArray.php:527 (getColoredVariants) /src/Adapter/Presenter/AbstractLazyArray.php:261 (getMainVariants) /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/c3/8a/d8/c38ad8ef490d26e052942bf124027e01185e4fb4_2.file.product.tpl.php:316 (offsetGet) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/c3/8a/d8/c38ad8ef490d26e052942bf124027e01185e4fb4_2.file.product.tpl.php:40 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6a5f97325407a6_20421531) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/ac/d6/58/acd65854af8df607812b56f6f13251579d1a6572_2.file.productlist.tpl.php:39 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6a5f973251db14_76287216) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/00/c0/8a/00c08a3f6d8f60c9ecb82fec22f16440a729f0a9_2.file.products.tpl.php:32 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6a5f97325189e6_92201126) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/dd/43/81/dd4381a43365b08e141df9c928b8b566eb89fce9_2.file.product-list.tpl.php:122 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/dd/43/81/dd4381a43365b08e141df9c928b8b566eb89fce9_2.file.product-list.tpl.php:231 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:186 (process) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/fa/8c/e6/fa8ce6c3d91e09e3e88afbf6f791fc939c6ae143_2.file.layout-left-column.tpl.php:85 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:186 (process) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/6d/b0/10/6db010da081764cb9b7ddedbe0282abc1b67e8ac_2.file.layout-both-columns.tpl.php:95 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6a5f9732044ca3_39066569) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:115 (_subTemplateRender) /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/fa/8c/e6/fa8ce6c3d91e09e3e88afbf6f791fc939c6ae143_2.file.layout-left-column.tpl.php:39 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6a5f9732035ce7_65544955) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:115 (_subTemplateRender) /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/dd/43/81/dd4381a43365b08e141df9c928b8b566eb89fce9_2.file.product-list.tpl.php:45 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6a5f9732030c92_48144070) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:115 (_subTemplateRender) /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/e0/24/30/e024303655cfdd7b88d1ed58318733a39c8e773c_2.file.category.tpl.php:44 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6a5f9732022db2_04163810) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/Smarty/SmartyDev.php:40 (fetch) /classes/controller/FrontController.php:715 (fetch) /classes/controller/FrontController.php:697 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
13	SELECT SQL_NO_CACHE h.`name` as hook, m.`id_module`, h.`id_hook`, m.`name` as module FROM `f1oa_module` m INNER JOIN f1oa_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 `f1oa_hook_module` `hm` ON hm.`id_module` = m.`id_module` INNER JOIN `f1oa_hook` `h` ON hm.`id_hook` = h.`id_hook` WHERE (h.`name` != "paymentOptions") AND (hm.`id_shop` = 1) GROUP BY hm.id_hook, hm.id_module ORDER BY hm.`position`	0.712 ms	104	Yes	Yes	/classes/Hook.php:1183 /classes/Hook.php:699 (getAllHookRegistrations) /classes/Hook.php:803 (getHookModuleExecList) /classes/Dispatcher.php:586 (exec) /classes/Dispatcher.php:243 (loadRoutes) /classes/Dispatcher.php:201 (__construct) /index.php:28 (getInstance)
302	SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, SUM(IF(stock.`quantity` > 0, 1, 0)) qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by FROM `f1oa_product_attribute` pa INNER JOIN f1oa_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) LEFT JOIN f1oa_stock_available stock ON (stock.id_product = `pa`.id_product AND stock.id_product_attribute = IFNULL(`pa`.id_product_attribute, 0) AND stock.id_shop = 1 AND stock.id_shop_group = 0 ) JOIN `f1oa_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`) JOIN `f1oa_attribute` a ON (a.`id_attribute` = pac.`id_attribute`) JOIN `f1oa_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 2) JOIN `f1oa_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`) WHERE pa.`id_product` IN (53) AND ag.`is_color_group` = 1 GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` HAVING qty > 0 ORDER BY a.`position` ASC;	0.704 ms	19	Yes		/classes/Product.php:4486 /src/Adapter/Product/ProductColorsRetriever.php:43 (getAttributesColorList) /src/Adapter/Presenter/Product/ProductLazyArray.php:527 (getColoredVariants) /src/Adapter/Presenter/AbstractLazyArray.php:261 (getMainVariants) /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/c3/8a/d8/c38ad8ef490d26e052942bf124027e01185e4fb4_2.file.product.tpl.php:316 (offsetGet) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/c3/8a/d8/c38ad8ef490d26e052942bf124027e01185e4fb4_2.file.product.tpl.php:40 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6a5f97325407a6_20421531) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:384 (render) /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/ac/d6/58/acd65854af8df607812b56f6f13251579d1a6572_2.file.productlist.tpl.php:39 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6a5f973251db14_76287216) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/00/c0/8a/00c08a3f6d8f60c9ecb82fec22f16440a729f0a9_2.file.products.tpl.php:32 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6a5f97325189e6_92201126) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/dd/43/81/dd4381a43365b08e141df9c928b8b566eb89fce9_2.file.product-list.tpl.php:122 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/dd/43/81/dd4381a43365b08e141df9c928b8b566eb89fce9_2.file.product-list.tpl.php:231 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:186 (process) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/fa/8c/e6/fa8ce6c3d91e09e3e88afbf6f791fc939c6ae143_2.file.layout-left-column.tpl.php:85 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:186 (process) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/6d/b0/10/6db010da081764cb9b7ddedbe0282abc1b67e8ac_2.file.layout-both-columns.tpl.php:95 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6a5f9732044ca3_39066569) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:115 (_subTemplateRender) /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/fa/8c/e6/fa8ce6c3d91e09e3e88afbf6f791fc939c6ae143_2.file.layout-left-column.tpl.php:39 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6a5f9732035ce7_65544955) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:115 (_subTemplateRender) /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/dd/43/81/dd4381a43365b08e141df9c928b8b566eb89fce9_2.file.product-list.tpl.php:45 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6a5f9732030c92_48144070) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:115 (_subTemplateRender) /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/e0/24/30/e024303655cfdd7b88d1ed58318733a39c8e773c_2.file.category.tpl.php:44 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6a5f9732022db2_04163810) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/Smarty/SmartyDev.php:40 (fetch) /classes/controller/FrontController.php:715 (fetch) /classes/controller/FrontController.php:697 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
105	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 `f1oa_attribute_group` ag INNER JOIN `f1oa_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 2) INNER JOIN `f1oa_attribute` a ON a.`id_attribute_group` = ag.`id_attribute_group` INNER JOIN `f1oa_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 2) INNER JOIN f1oa_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 f1oa_attribute_shop attribute_shop ON (attribute_shop.id_attribute = a.id_attribute AND attribute_shop.id_shop = 1) LEFT JOIN `f1oa_layered_indexable_attribute_lang_value` lialv ON (a.`id_attribute` = lialv.`id_attribute` AND lialv.`id_lang` = 2) WHERE ag.id_attribute_group = 14 ORDER BY agl.`name` ASC, a.`position` ASC	0.632 ms	20	Yes		/modules/ps_facetedsearch/src/Filters/DataAccessor.php:77 /modules/ps_facetedsearch/src/Filters/Block.php:732 (getAttributes) /modules/ps_facetedsearch/src/Filters/Block.php:151 (getAttributesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:218 (getFilterBlock) /classes/controller/ProductListingFrontController.php:355 (runQuery) /classes/controller/ProductListingFrontController.php:634 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:133 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
300	SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, SUM(IF(stock.`quantity` > 0, 1, 0)) qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by FROM `f1oa_product_attribute` pa INNER JOIN f1oa_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) LEFT JOIN f1oa_stock_available stock ON (stock.id_product = `pa`.id_product AND stock.id_product_attribute = IFNULL(`pa`.id_product_attribute, 0) AND stock.id_shop = 1 AND stock.id_shop_group = 0 ) JOIN `f1oa_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`) JOIN `f1oa_attribute` a ON (a.`id_attribute` = pac.`id_attribute`) JOIN `f1oa_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 2) JOIN `f1oa_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`) WHERE pa.`id_product` IN (41) AND ag.`is_color_group` = 1 GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` HAVING qty > 0 ORDER BY a.`position` ASC;	0.592 ms	15	Yes		/classes/Product.php:4486 /src/Adapter/Product/ProductColorsRetriever.php:43 (getAttributesColorList) /src/Adapter/Presenter/Product/ProductLazyArray.php:527 (getColoredVariants) /src/Adapter/Presenter/AbstractLazyArray.php:261 (getMainVariants) /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/c3/8a/d8/c38ad8ef490d26e052942bf124027e01185e4fb4_2.file.product.tpl.php:316 (offsetGet) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/c3/8a/d8/c38ad8ef490d26e052942bf124027e01185e4fb4_2.file.product.tpl.php:40 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6a5f97325407a6_20421531) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:384 (render) /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/ac/d6/58/acd65854af8df607812b56f6f13251579d1a6572_2.file.productlist.tpl.php:39 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6a5f973251db14_76287216) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/00/c0/8a/00c08a3f6d8f60c9ecb82fec22f16440a729f0a9_2.file.products.tpl.php:32 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6a5f97325189e6_92201126) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/dd/43/81/dd4381a43365b08e141df9c928b8b566eb89fce9_2.file.product-list.tpl.php:122 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/dd/43/81/dd4381a43365b08e141df9c928b8b566eb89fce9_2.file.product-list.tpl.php:231 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:186 (process) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/fa/8c/e6/fa8ce6c3d91e09e3e88afbf6f791fc939c6ae143_2.file.layout-left-column.tpl.php:85 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:186 (process) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/6d/b0/10/6db010da081764cb9b7ddedbe0282abc1b67e8ac_2.file.layout-both-columns.tpl.php:95 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6a5f9732044ca3_39066569) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:115 (_subTemplateRender) /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/fa/8c/e6/fa8ce6c3d91e09e3e88afbf6f791fc939c6ae143_2.file.layout-left-column.tpl.php:39 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6a5f9732035ce7_65544955) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:115 (_subTemplateRender) /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/dd/43/81/dd4381a43365b08e141df9c928b8b566eb89fce9_2.file.product-list.tpl.php:45 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6a5f9732030c92_48144070) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:115 (_subTemplateRender) /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/e0/24/30/e024303655cfdd7b88d1ed58318733a39c8e773c_2.file.category.tpl.php:44 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6a5f9732022db2_04163810) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/Smarty/SmartyDev.php:40 (fetch) /classes/controller/FrontController.php:715 (fetch) /classes/controller/FrontController.php:697 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
288	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 `f1oa_category` c INNER JOIN f1oa_category_shop category_shop ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1) LEFT JOIN `f1oa_category_lang` cl ON (c.`id_category` = cl.`id_category` AND `id_lang` = 8 AND cl.id_shop = 1 ) WHERE `id_parent` = 8 AND `active` = 1 GROUP BY c.`id_category` ORDER BY `level_depth` ASC, category_shop.`position` ASC	0.578 ms	1	Yes	Yes	/classes/Category.php:913 /modules/ps_categorytree/ps_categorytree.php:289 (getSubCategories) /modules/ps_categorytree/ps_categorytree.php:266 (getWidgetVariables) /classes/Hook.php:1004 (renderWidget) /tools/profiling/Hook.php:64 (coreRenderWidget) /classes/Hook.php:948 (coreRenderWidget) /config/smarty.config.inc.php:205 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/6d/b0/10/6db010da081764cb9b7ddedbe0282abc1b67e8ac_2.file.layout-both-columns.tpl.php:257 (__call) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/6d/b0/10/6db010da081764cb9b7ddedbe0282abc1b67e8ac_2.file.layout-both-columns.tpl.php:90 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6a5f9732044ca3_39066569) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:115 (_subTemplateRender) /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/fa/8c/e6/fa8ce6c3d91e09e3e88afbf6f791fc939c6ae143_2.file.layout-left-column.tpl.php:39 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6a5f9732035ce7_65544955) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:115 (_subTemplateRender) /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/dd/43/81/dd4381a43365b08e141df9c928b8b566eb89fce9_2.file.product-list.tpl.php:45 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6a5f9732030c92_48144070) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:115 (_subTemplateRender) /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/e0/24/30/e024303655cfdd7b88d1ed58318733a39c8e773c_2.file.category.tpl.php:44 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6a5f9732022db2_04163810) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/Smarty/SmartyDev.php:40 (fetch) /classes/controller/FrontController.php:715 (fetch) /classes/controller/FrontController.php:697 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
110	SELECT SQL_NO_CACHE p., ps., pl.*, sa.out_of_stock, IFNULL(sa.quantity, 0) as quantity, (DATEDIFF( p.`date_add`, DATE_SUB( '2026-07-21 00:00:00', INTERVAL 20000 DAY ) ) > 0) as new FROM f1oa_product p LEFT JOIN f1oa_product_lang pl ON pl.id_product = p.id_product AND pl.id_shop = 1 AND pl.id_lang = 2 LEFT JOIN f1oa_stock_available sa ON sa.id_product = p.id_product AND sa.id_product_attribute = 0 AND sa.id_shop = 1 LEFT JOIN f1oa_product_shop ps ON ps.id_product = p.id_product AND ps.id_shop = 1 WHERE p.id_product IN (16,41,42,53,89,121,124)	0.557 ms	7			/classes/ProductAssembler.php:95 /classes/ProductAssembler.php:203 (addMissingProductFieldsForMultipleProducts) /classes/controller/ProductListingFrontController.php:108 (assembleProducts) /classes/controller/ProductListingFrontController.php:377 (prepareMultipleProductsForTemplate) /classes/controller/ProductListingFrontController.php:634 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:133 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
305	SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, SUM(IF(stock.`quantity` > 0, 1, 0)) qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by FROM `f1oa_product_attribute` pa INNER JOIN f1oa_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) LEFT JOIN f1oa_stock_available stock ON (stock.id_product = `pa`.id_product AND stock.id_product_attribute = IFNULL(`pa`.id_product_attribute, 0) AND stock.id_shop = 1 AND stock.id_shop_group = 0 ) JOIN `f1oa_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`) JOIN `f1oa_attribute` a ON (a.`id_attribute` = pac.`id_attribute`) JOIN `f1oa_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 2) JOIN `f1oa_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`) WHERE pa.`id_product` IN (124) AND ag.`is_color_group` = 1 GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` HAVING qty > 0 ORDER BY a.`position` ASC;	0.549 ms	8	Yes		/classes/Product.php:4486 /src/Adapter/Product/ProductColorsRetriever.php:43 (getAttributesColorList) /src/Adapter/Presenter/Product/ProductLazyArray.php:527 (getColoredVariants) /src/Adapter/Presenter/AbstractLazyArray.php:261 (getMainVariants) /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/c3/8a/d8/c38ad8ef490d26e052942bf124027e01185e4fb4_2.file.product.tpl.php:316 (offsetGet) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/c3/8a/d8/c38ad8ef490d26e052942bf124027e01185e4fb4_2.file.product.tpl.php:40 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6a5f97325407a6_20421531) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:384 (render) /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/ac/d6/58/acd65854af8df607812b56f6f13251579d1a6572_2.file.productlist.tpl.php:39 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6a5f973251db14_76287216) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/00/c0/8a/00c08a3f6d8f60c9ecb82fec22f16440a729f0a9_2.file.products.tpl.php:32 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6a5f97325189e6_92201126) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/dd/43/81/dd4381a43365b08e141df9c928b8b566eb89fce9_2.file.product-list.tpl.php:122 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/dd/43/81/dd4381a43365b08e141df9c928b8b566eb89fce9_2.file.product-list.tpl.php:231 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:186 (process) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/fa/8c/e6/fa8ce6c3d91e09e3e88afbf6f791fc939c6ae143_2.file.layout-left-column.tpl.php:85 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:186 (process) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/6d/b0/10/6db010da081764cb9b7ddedbe0282abc1b67e8ac_2.file.layout-both-columns.tpl.php:95 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6a5f9732044ca3_39066569) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:115 (_subTemplateRender) /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/fa/8c/e6/fa8ce6c3d91e09e3e88afbf6f791fc939c6ae143_2.file.layout-left-column.tpl.php:39 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6a5f9732035ce7_65544955) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:115 (_subTemplateRender) /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/dd/43/81/dd4381a43365b08e141df9c928b8b566eb89fce9_2.file.product-list.tpl.php:45 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6a5f9732030c92_48144070) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:115 (_subTemplateRender) /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/e0/24/30/e024303655cfdd7b88d1ed58318733a39c8e773c_2.file.category.tpl.php:44 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6a5f9732022db2_04163810) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/Smarty/SmartyDev.php:40 (fetch) /classes/controller/FrontController.php:715 (fetch) /classes/controller/FrontController.php:697 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
76	SELECT SQL_NO_CACHE `name` FROM `f1oa_hook` WHERE `id_hook` = 949 LIMIT 1	0.522 ms	1			/classes/Hook.php:241 /classes/Hook.php:867 (getNameById) /classes/controller/FrontController.php:577 (exec) /controllers/front/listing/CategoryController.php:126 (initContent) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
304	SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, SUM(IF(stock.`quantity` > 0, 1, 0)) qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by FROM `f1oa_product_attribute` pa INNER JOIN f1oa_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) LEFT JOIN f1oa_stock_available stock ON (stock.id_product = `pa`.id_product AND stock.id_product_attribute = IFNULL(`pa`.id_product_attribute, 0) AND stock.id_shop = 1 AND stock.id_shop_group = 0 ) JOIN `f1oa_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`) JOIN `f1oa_attribute` a ON (a.`id_attribute` = pac.`id_attribute`) JOIN `f1oa_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 2) JOIN `f1oa_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`) WHERE pa.`id_product` IN (121) AND ag.`is_color_group` = 1 GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` HAVING qty > 0 ORDER BY a.`position` ASC;	0.516 ms	17	Yes		/classes/Product.php:4486 /src/Adapter/Product/ProductColorsRetriever.php:43 (getAttributesColorList) /src/Adapter/Presenter/Product/ProductLazyArray.php:527 (getColoredVariants) /src/Adapter/Presenter/AbstractLazyArray.php:261 (getMainVariants) /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/c3/8a/d8/c38ad8ef490d26e052942bf124027e01185e4fb4_2.file.product.tpl.php:316 (offsetGet) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/c3/8a/d8/c38ad8ef490d26e052942bf124027e01185e4fb4_2.file.product.tpl.php:40 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6a5f97325407a6_20421531) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:384 (render) /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/ac/d6/58/acd65854af8df607812b56f6f13251579d1a6572_2.file.productlist.tpl.php:39 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6a5f973251db14_76287216) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/00/c0/8a/00c08a3f6d8f60c9ecb82fec22f16440a729f0a9_2.file.products.tpl.php:32 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6a5f97325189e6_92201126) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/dd/43/81/dd4381a43365b08e141df9c928b8b566eb89fce9_2.file.product-list.tpl.php:122 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/dd/43/81/dd4381a43365b08e141df9c928b8b566eb89fce9_2.file.product-list.tpl.php:231 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:186 (process) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/fa/8c/e6/fa8ce6c3d91e09e3e88afbf6f791fc939c6ae143_2.file.layout-left-column.tpl.php:85 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:186 (process) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/6d/b0/10/6db010da081764cb9b7ddedbe0282abc1b67e8ac_2.file.layout-both-columns.tpl.php:95 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6a5f9732044ca3_39066569) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:115 (_subTemplateRender) /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/fa/8c/e6/fa8ce6c3d91e09e3e88afbf6f791fc939c6ae143_2.file.layout-left-column.tpl.php:39 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6a5f9732035ce7_65544955) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:115 (_subTemplateRender) /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/dd/43/81/dd4381a43365b08e141df9c928b8b566eb89fce9_2.file.product-list.tpl.php:45 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6a5f9732030c92_48144070) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:115 (_subTemplateRender) /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/e0/24/30/e024303655cfdd7b88d1ed58318733a39c8e773c_2.file.category.tpl.php:44 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6a5f9732022db2_04163810) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/Smarty/SmartyDev.php:40 (fetch) /classes/controller/FrontController.php:715 (fetch) /classes/controller/FrontController.php:697 (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 c.`id_category`, cl.`name` FROM `f1oa_category` c INNER JOIN f1oa_category_shop category_shop ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1) LEFT JOIN `f1oa_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.505 ms	66	Yes		/classes/Category.php:707 /modules/ps_facetedsearch/src/Filters/Block.php:980 (getAllCategoriesName) /modules/ps_facetedsearch/src/Filters/Block.php:159 (getCategoriesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:218 (getFilterBlock) /classes/controller/ProductListingFrontController.php:355 (runQuery) /classes/controller/ProductListingFrontController.php:634 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:133 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
316	SELECT SQL_NO_CACHE cp.`id_category`, cp.`id_product`, cl.`name` FROM `f1oa_category_product` cp LEFT JOIN `f1oa_category` c ON (c.id_category = cp.id_category) LEFT JOIN `f1oa_category_lang` cl ON (cp.`id_category` = cl.`id_category` AND cl.id_shop = 1 ) INNER JOIN f1oa_category_shop category_shop ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1) WHERE cp.`id_product` IN (16,41,42,53,89,121,124) AND cl.`id_lang` = 2 ORDER BY c.`level_depth` DESC	0.491 ms	47	Yes		/modules/ps_googleanalytics/classes/Wrapper/ProductWrapper.php:103 /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:993 (hookDisplayBeforeBodyClosingTag) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:418 (coreCallHook) /classes/Hook.php:928 (callHookOn) /config/smarty.config.inc.php:205 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/6d/b0/10/6db010da081764cb9b7ddedbe0282abc1b67e8ac_2.file.layout-both-columns.tpl.php:385 (__call) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/6d/b0/10/6db010da081764cb9b7ddedbe0282abc1b67e8ac_2.file.layout-both-columns.tpl.php:126 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6a5f9732044ca3_39066569) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:115 (_subTemplateRender) /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/fa/8c/e6/fa8ce6c3d91e09e3e88afbf6f791fc939c6ae143_2.file.layout-left-column.tpl.php:39 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6a5f9732035ce7_65544955) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:115 (_subTemplateRender) /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/dd/43/81/dd4381a43365b08e141df9c928b8b566eb89fce9_2.file.product-list.tpl.php:45 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6a5f9732030c92_48144070) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:115 (_subTemplateRender) /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/e0/24/30/e024303655cfdd7b88d1ed58318733a39c8e773c_2.file.category.tpl.php:44 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6a5f9732022db2_04163810) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/Smarty/SmartyDev.php:40 (fetch) /classes/controller/FrontController.php:715 (fetch) /classes/controller/FrontController.php:697 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
303	SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, SUM(IF(stock.`quantity` > 0, 1, 0)) qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by FROM `f1oa_product_attribute` pa INNER JOIN f1oa_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) LEFT JOIN f1oa_stock_available stock ON (stock.id_product = `pa`.id_product AND stock.id_product_attribute = IFNULL(`pa`.id_product_attribute, 0) AND stock.id_shop = 1 AND stock.id_shop_group = 0 ) JOIN `f1oa_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`) JOIN `f1oa_attribute` a ON (a.`id_attribute` = pac.`id_attribute`) JOIN `f1oa_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 2) JOIN `f1oa_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`) WHERE pa.`id_product` IN (89) AND ag.`is_color_group` = 1 GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` HAVING qty > 0 ORDER BY a.`position` ASC;	0.488 ms	8	Yes		/classes/Product.php:4486 /src/Adapter/Product/ProductColorsRetriever.php:43 (getAttributesColorList) /src/Adapter/Presenter/Product/ProductLazyArray.php:527 (getColoredVariants) /src/Adapter/Presenter/AbstractLazyArray.php:261 (getMainVariants) /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/c3/8a/d8/c38ad8ef490d26e052942bf124027e01185e4fb4_2.file.product.tpl.php:316 (offsetGet) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/c3/8a/d8/c38ad8ef490d26e052942bf124027e01185e4fb4_2.file.product.tpl.php:40 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6a5f97325407a6_20421531) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:384 (render) /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/ac/d6/58/acd65854af8df607812b56f6f13251579d1a6572_2.file.productlist.tpl.php:39 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6a5f973251db14_76287216) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/00/c0/8a/00c08a3f6d8f60c9ecb82fec22f16440a729f0a9_2.file.products.tpl.php:32 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6a5f97325189e6_92201126) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/dd/43/81/dd4381a43365b08e141df9c928b8b566eb89fce9_2.file.product-list.tpl.php:122 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/dd/43/81/dd4381a43365b08e141df9c928b8b566eb89fce9_2.file.product-list.tpl.php:231 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:186 (process) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/fa/8c/e6/fa8ce6c3d91e09e3e88afbf6f791fc939c6ae143_2.file.layout-left-column.tpl.php:85 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:186 (process) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/6d/b0/10/6db010da081764cb9b7ddedbe0282abc1b67e8ac_2.file.layout-both-columns.tpl.php:95 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6a5f9732044ca3_39066569) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:115 (_subTemplateRender) /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/fa/8c/e6/fa8ce6c3d91e09e3e88afbf6f791fc939c6ae143_2.file.layout-left-column.tpl.php:39 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6a5f9732035ce7_65544955) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:115 (_subTemplateRender) /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/dd/43/81/dd4381a43365b08e141df9c928b8b566eb89fce9_2.file.product-list.tpl.php:45 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6a5f9732030c92_48144070) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:115 (_subTemplateRender) /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/e0/24/30/e024303655cfdd7b88d1ed58318733a39c8e773c_2.file.category.tpl.php:44 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6a5f9732022db2_04163810) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/Smarty/SmartyDev.php:40 (fetch) /classes/controller/FrontController.php:715 (fetch) /classes/controller/FrontController.php:697 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
301	SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, SUM(IF(stock.`quantity` > 0, 1, 0)) qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by FROM `f1oa_product_attribute` pa INNER JOIN f1oa_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) LEFT JOIN f1oa_stock_available stock ON (stock.id_product = `pa`.id_product AND stock.id_product_attribute = IFNULL(`pa`.id_product_attribute, 0) AND stock.id_shop = 1 AND stock.id_shop_group = 0 ) JOIN `f1oa_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`) JOIN `f1oa_attribute` a ON (a.`id_attribute` = pac.`id_attribute`) JOIN `f1oa_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 2) JOIN `f1oa_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`) WHERE pa.`id_product` IN (42) AND ag.`is_color_group` = 1 GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` HAVING qty > 0 ORDER BY a.`position` ASC;	0.480 ms	6	Yes		/classes/Product.php:4486 /src/Adapter/Product/ProductColorsRetriever.php:43 (getAttributesColorList) /src/Adapter/Presenter/Product/ProductLazyArray.php:527 (getColoredVariants) /src/Adapter/Presenter/AbstractLazyArray.php:261 (getMainVariants) /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/c3/8a/d8/c38ad8ef490d26e052942bf124027e01185e4fb4_2.file.product.tpl.php:316 (offsetGet) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/c3/8a/d8/c38ad8ef490d26e052942bf124027e01185e4fb4_2.file.product.tpl.php:40 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6a5f97325407a6_20421531) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:384 (render) /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/ac/d6/58/acd65854af8df607812b56f6f13251579d1a6572_2.file.productlist.tpl.php:39 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6a5f973251db14_76287216) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/00/c0/8a/00c08a3f6d8f60c9ecb82fec22f16440a729f0a9_2.file.products.tpl.php:32 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6a5f97325189e6_92201126) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/dd/43/81/dd4381a43365b08e141df9c928b8b566eb89fce9_2.file.product-list.tpl.php:122 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/dd/43/81/dd4381a43365b08e141df9c928b8b566eb89fce9_2.file.product-list.tpl.php:231 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:186 (process) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/fa/8c/e6/fa8ce6c3d91e09e3e88afbf6f791fc939c6ae143_2.file.layout-left-column.tpl.php:85 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:186 (process) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/6d/b0/10/6db010da081764cb9b7ddedbe0282abc1b67e8ac_2.file.layout-both-columns.tpl.php:95 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6a5f9732044ca3_39066569) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:115 (_subTemplateRender) /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/fa/8c/e6/fa8ce6c3d91e09e3e88afbf6f791fc939c6ae143_2.file.layout-left-column.tpl.php:39 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6a5f9732035ce7_65544955) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:115 (_subTemplateRender) /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/dd/43/81/dd4381a43365b08e141df9c928b8b566eb89fce9_2.file.product-list.tpl.php:45 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6a5f9732030c92_48144070) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:115 (_subTemplateRender) /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/e0/24/30/e024303655cfdd7b88d1ed58318733a39c8e773c_2.file.category.tpl.php:44 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6a5f9732022db2_04163810) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/Smarty/SmartyDev.php:40 (fetch) /classes/controller/FrontController.php:715 (fetch) /classes/controller/FrontController.php:697 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
79	SELECT SQL_NO_CACHE ag.id_attribute_group, agl.public_name as attribute_group_name, is_color_group, IF(liaglv.`url_name` IS NULL OR liaglv.`url_name` = "", NULL, liaglv.`url_name`) AS url_name, IF(liaglv.`meta_title` IS NULL OR liaglv.`meta_title` = "", NULL, liaglv.`meta_title`) AS meta_title, IFNULL(liag.indexable, TRUE) AS indexable FROM `f1oa_attribute_group` ag INNER JOIN f1oa_attribute_group_shop attribute_group_shop ON (attribute_group_shop.id_attribute_group = ag.id_attribute_group AND attribute_group_shop.id_shop = 1) LEFT JOIN `f1oa_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 2) LEFT JOIN `f1oa_layered_indexable_attribute_group` liag ON (ag.`id_attribute_group` = liag.`id_attribute_group`) LEFT JOIN `f1oa_layered_indexable_attribute_group_lang_value` AS liaglv ON (ag.`id_attribute_group` = liaglv.`id_attribute_group` AND agl.`id_lang` = 2) GROUP BY ag.id_attribute_group ORDER BY ag.`position` ASC	0.445 ms	13	Yes	Yes	/modules/ps_facetedsearch/src/Filters/DataAccessor.php:122 /modules/ps_facetedsearch/src/Filters/Converter.php:413 (getAttributesGroups) /modules/ps_facetedsearch/src/Product/SearchProvider.php:166 (createFacetedSearchFiltersFromQuery) /classes/controller/ProductListingFrontController.php:355 (runQuery) /classes/controller/ProductListingFrontController.php:634 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:133 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
18	SELECT SQL_NO_CACHE m.page, ml.url_rewrite, ml.id_lang FROM `f1oa_meta` m LEFT JOIN `f1oa_meta_lang` ml ON (m.id_meta = ml.id_meta AND ml.id_shop = 1 ) ORDER BY LENGTH(ml.url_rewrite) DESC	0.443 ms	172	Yes		/classes/Dispatcher.php:633 /classes/Dispatcher.php:243 (loadRoutes) /classes/Dispatcher.php:201 (__construct) /index.php:28 (getInstance)
12	SELECT SQL_NO_CACHE lower(name) as name FROM `f1oa_hook` h WHERE (h.active = 1)	0.435 ms	1025			/classes/Hook.php:1282 /classes/Hook.php:774 (getHookStatusByName) /classes/Dispatcher.php:586 (exec) /classes/Dispatcher.php:243 (loadRoutes) /classes/Dispatcher.php:201 (__construct) /index.php:28 (getInstance)
78	SELECT SQL_NO_CACHE DISTINCT f.id_feature, f., fl., IF(liflv.`url_name` IS NULL OR liflv.`url_name` = "", NULL, liflv.`url_name`) AS url_name, IF(liflv.`meta_title` IS NULL OR liflv.`meta_title` = "", NULL, liflv.`meta_title`) AS meta_title, lif.indexable FROM `f1oa_feature` f INNER JOIN f1oa_feature_shop feature_shop ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1) LEFT JOIN `f1oa_feature_lang` fl ON (f.`id_feature` = fl.`id_feature` AND fl.`id_lang` = 2) LEFT JOIN `f1oa_layered_indexable_feature` lif ON (f.`id_feature` = lif.`id_feature`) LEFT JOIN `f1oa_layered_indexable_feature_lang_value` liflv ON (f.`id_feature` = liflv.`id_feature` AND liflv.`id_lang` = 2) ORDER BY f.`position` ASC	0.427 ms	289	Yes		/modules/ps_facetedsearch/src/Filters/DataAccessor.php:159 /modules/ps_facetedsearch/src/Filters/Converter.php:388 (getFeatures) /modules/ps_facetedsearch/src/Product/SearchProvider.php:166 (createFacetedSearchFiltersFromQuery) /classes/controller/ProductListingFrontController.php:355 (runQuery) /classes/controller/ProductListingFrontController.php:634 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:133 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
97	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 `f1oa_attribute_group` ag INNER JOIN `f1oa_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 2) INNER JOIN `f1oa_attribute` a ON a.`id_attribute_group` = ag.`id_attribute_group` INNER JOIN `f1oa_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 2) INNER JOIN f1oa_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 f1oa_attribute_shop attribute_shop ON (attribute_shop.id_attribute = a.id_attribute AND attribute_shop.id_shop = 1) LEFT JOIN `f1oa_layered_indexable_attribute_lang_value` lialv ON (a.`id_attribute` = lialv.`id_attribute` AND lialv.`id_lang` = 2) WHERE ag.id_attribute_group = 11 ORDER BY agl.`name` ASC, a.`position` ASC	0.400 ms	12	Yes		/modules/ps_facetedsearch/src/Filters/DataAccessor.php:77 /modules/ps_facetedsearch/src/Filters/Block.php:732 (getAttributes) /modules/ps_facetedsearch/src/Filters/Block.php:151 (getAttributesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:218 (getFilterBlock) /classes/controller/ProductListingFrontController.php:355 (runQuery) /classes/controller/ProductListingFrontController.php:634 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:133 (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-mbstring/bootstrap.php
12	/vendor/symfony/polyfill-mbstring/bootstrap80.php
13	/vendor/symfony/polyfill-intl-normalizer/bootstrap.php
14	/vendor/symfony/polyfill-intl-normalizer/bootstrap80.php
15	/vendor/symfony/polyfill-intl-idn/bootstrap.php
16	/vendor/symfony/deprecation-contracts/function.php
17	/vendor/ralouphie/getallheaders/src/getallheaders.php
18	/vendor/symfony/polyfill-ctype/bootstrap.php
19	/vendor/symfony/polyfill-ctype/bootstrap80.php
20	/vendor/symfony/polyfill-php80/bootstrap.php
21	/vendor/guzzlehttp/promises/src/functions_include.php
22	/vendor/guzzlehttp/promises/src/functions.php
23	/vendor/guzzlehttp/guzzle/src/functions_include.php
24	/vendor/guzzlehttp/guzzle/src/functions.php
25	/vendor/symfony/polyfill-iconv/bootstrap.php
26	/vendor/ezyang/htmlpurifier/library/HTMLPurifier.composer.php
27	/vendor/jakeasmith/http_build_url/src/http_build_url.php
28	/vendor/lcobucci/jwt/compat/class-aliases.php
29	/vendor/lcobucci/jwt/src/Token.php
30	/vendor/lcobucci/jwt/src/Signature.php
31	/vendor/lcobucci/jwt/compat/json-exception-polyfill.php
32	/vendor/lcobucci/jwt/compat/lcobucci-clock-polyfill.php
33	/vendor/swiftmailer/swiftmailer/lib/swift_required.php
34	/vendor/swiftmailer/swiftmailer/lib/classes/Swift.php
35	/vendor/symfony/polyfill-intl-icu/bootstrap.php
36	/vendor/symfony/polyfill-php73/bootstrap.php
37	/vendor/symfony/polyfill-php81/bootstrap.php
38	/vendor/api-platform/core/src/deprecation.php
39	/vendor/api-platform/core/src/Api/FilterInterface.php