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°001 : Oeuvre N°001/200, Entre eux deux _ Océan Arcachon Biscarrosse Surf _ Ligne et Déco (Édition limitée 5 ex.)

Aperçu rapide

Oeuvre N°001/200, Entre eux deux _ Océan Arcachon...

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°042-campagne-ancien-couleur-paysage-pano : Oeuvre N°042/200, A l'or des Anciens _ Monségur _ Bordeaux _ Lot et Garonne _ campagne et agriculture (Édition limitée 5 ex.)

Aperçu rapide

Oeuvre N°042/200, A l'or des Anciens _ Monségur _...

Dès 180,00 €

Warning

251

Warning

251

Warning

251

Tirage photo d’art – Oeuvre N°oeuvre_n°075 : Oeuvre N°075/200, L'or noir _ Médoc Atlantique Sud _ Bassin d'Arcachon (Édition limitée 5 ex.)

Aperçu rapide

Oeuvre N°075/200, L'or noir _ Médoc Atlantique Sud _...

Dès 180,00 €

Warning

251

Warning

251

Warning

251

Tirage photo d’art – Oeuvre N°oeuvre_n°012-carrelet-garonne : Oeuvre N°012/200 _ Instant entre amis _ Cadaujac _ Garonne _ Carrelet du port de Grima (Édition limitée 5 ex.)

Aperçu rapide

Oeuvre N°012/200 _ Instant entre amis _ Cadaujac _...

Dès 180,00 €

Warning

251

Warning

251

Warning

251

Tirage photo d’art – Oeuvre N°oeuvre_n°095 : Oeuvre N°095, Port de Grima N°02 _ ex 0/5 _ Carrelet de la Garonne _ Cadaujac, Bègles (Édition limitée 5 ex.)

Aperçu rapide

Oeuvre N°095, Port de Grima N°02 _ ex 0/5 _ Carrelet de...

Dès 180,00 €

Warning

251

Warning

251

Warning

251

Tirage photo d’art – Oeuvre N°oeuvre_n°097 : Oeuvre N°097/200, A mon étoile _ Dune du Pilat _ Plage du petit Nice (Édition limitée 5 ex.)

Aperçu rapide

Oeuvre N°097/200, A mon étoile _ Dune du Pilat _ Plage du...

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	2947 ms
Querying Time	646 ms
Queries	301
Memory Peak Usage	160.3 Mb
Included Files	1120 files - 11.08 Mb
PrestaShop Cache	- Mb
Global vars	0.05 Mb
- global $_ENV	13k
- global $_SERVER	13k
- global $__composer_autoload_files	5k
- global $config	5k
- global $_MODULES	4k
- global $_MODULE	4k
- global $context	3k
- global $exportPhpConfigFile	3k
- global $_REQUEST	2k
- global $_COOKIE	1k

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	9.846 ms	9.846 ms	17.86 Mb	18.9 Mb
__construct	13.253 ms	23.099 ms	1.90 Mb	21.5 Mb
init	124.063 ms	147.162 ms	9.68 Mb	30.6 Mb
checkAccess	0.002 ms	147.164 ms	- Mb	30.6 Mb
setMedia	245.271 ms	392.435 ms	37.84 Mb	67.8 Mb
postProcess	0.001 ms	392.436 ms	- Mb	67.8 Mb
initHeader	0.002 ms	392.438 ms	- Mb	67.8 Mb
initContent	1256 ms	1648 ms	1.19 Mb	123.0 Mb
initFooter	0.004 ms	1648 ms	- Mb	123.0 Mb
display	1298 ms	2947 ms	- Mb	160.3 Mb

Hook	Time	Memory Usage
DisplayFooter	296.895 ms	- Mb
=> blockwishlist	296.895 ms	- Mb
ActionFrontControllerSetMedia	111.863 ms	14.23 Mb
=> blockreassurance	1.056 ms	0.11 Mb
=> blockwishlist	0.311 ms	- Mb
=> ps_emailsubscription	0.118 ms	- Mb
=> ps_socialfollow	0.085 ms	- Mb
=> ps_emailalerts	0.109 ms	- Mb
=> ps_checkout	110.184 ms	14.11 Mb
displayNav2	79.295 ms	15.55 Mb
=> ps_languageselector (widget)	0.410 ms	0.04 Mb
=> ps_currencyselector (widget)	0.652 ms	0.07 Mb
=> ps_customersignin (widget)	25.160 ms	3.85 Mb
=> ps_shoppingcart (widget)	19.619 ms	3.94 Mb
=> ps_languageselector (widget)	0.011 ms	- Mb
=> ps_currencyselector (widget)	0.013 ms	- Mb
=> ps_customersignin (widget)	16.141 ms	3.81 Mb
=> ps_shoppingcart (widget)	17.289 ms	3.83 Mb
displayProductListReviews	63.791 ms	4.47 Mb
=> productcomments (widget)	47.499 ms	4.44 Mb
=> productcomments (widget)	2.276 ms	- Mb
=> productcomments (widget)	1.731 ms	- Mb
=> productcomments (widget)	7.917 ms	- Mb
=> productcomments (widget)	1.832 ms	- Mb
=> productcomments (widget)	2.536 ms	- Mb
displayFooterBefore	56.589 ms	7.84 Mb
=> ps_emailsubscription (widget)	54.551 ms	7.67 Mb
=> ps_socialfollow (widget)	2.038 ms	0.17 Mb
displayFooter	36.280 ms	7.86 Mb
=> ps_linklist (widget)	2.424 ms	0.13 Mb
=> ps_customeraccountlinks (widget)	0.814 ms	0.07 Mb
=> ps_contactinfo (widget)	33.042 ms	7.66 Mb
displayContentWrapperTop	32.400 ms	3.83 Mb
=> ps_searchbar (widget)	32.400 ms	3.83 Mb
DisplayHeader	18.227 ms	1.21 Mb
=> ps_shoppingcart	0.090 ms	- Mb
=> ps_searchbar	0.203 ms	- Mb
=> ps_imageslider	0.132 ms	- Mb
=> ps_googleanalytics	17.663 ms	1.21 Mb
=> productcomments	0.139 ms	- Mb
displayNav1	10.595 ms	1.99 Mb
=> ps_contactinfo (widget)	10.595 ms	1.99 Mb
DisplayLeftColumn	8.804 ms	1.98 Mb
=> ps_facetedsearch	8.804 ms	1.98 Mb
displayTop	6.931 ms	0.65 Mb
=> ps_mainmenu (widget)	6.931 ms	0.65 Mb
displayLeftColumn	6.494 ms	0.22 Mb
=> ps_categorytree (widget)	6.494 ms	0.22 Mb
DisplayBeforeBodyClosingTag	4.833 ms	0.26 Mb
=> ps_googleanalytics	4.833 ms	0.26 Mb
ProductSearchProvider	1.946 ms	0.16 Mb
=> ps_facetedsearch	1.946 ms	0.16 Mb
Header	0.091 ms	- Mb
=> customhomeblocks	0.091 ms	- Mb
DisplayAfterBodyOpeningTag	0.011 ms	- Mb
=> blockreassurance	0.011 ms	- Mb
ActionDispatcherBefore	0.010 ms	- Mb
=> smartredirect	0.010 ms	- Mb
DisplayNavFullWidth	0.010 ms	- Mb
=> blockreassurance	0.010 ms	- Mb
DisplayFooterAfter	0.009 ms	- Mb
=> blockreassurance	0.009 ms	- Mb
DisplayFooterBefore	0.007 ms	- Mb
=> blockreassurance	0.007 ms	- Mb
ModuleRoutes	0.006 ms	- Mb
=> ps_checkout	0.006 ms	- Mb
21 hook(s)	735.087 ms	7.17 Mb

Module	Time	Memory Usage
ps_checkout	138.040 ms	18.69 Mb
__construct	27.840 ms	4.58 Mb
hookModuleRoutes	0.011 ms	- Mb
hookActionFrontControllerSetMedia	110.189 ms	14.11 Mb
smartredirect	1.394 ms	0.03 Mb
__construct	1.378 ms	0.03 Mb
hookActionDispatcherBefore	0.016 ms	- Mb
blockreassurance	29.803 ms	5.97 Mb
__construct	28.692 ms	5.84 Mb
hookActionFrontControllerSetMedia	1.060 ms	0.11 Mb
hookDisplayAfterBodyOpeningTag	0.016 ms	- Mb
hookDisplayNavFullWidth	0.012 ms	- Mb
hookDisplayFooterBefore	0.011 ms	- Mb
hookDisplayFooterAfter	0.012 ms	- Mb
blockwishlist	314.159 ms	- Mb
__construct	16.942 ms	3.86 Mb
hookActionFrontControllerSetMedia	0.316 ms	- Mb
hookDisplayFooter	296.901 ms	- Mb
ps_emailsubscription	85.051 ms	13.59 Mb
__construct	30.369 ms	5.92 Mb
hookActionFrontControllerSetMedia	0.124 ms	- Mb
displayFooterBefore	54.558 ms	7.67 Mb
ps_socialfollow	29.019 ms	4.04 Mb
__construct	26.884 ms	3.87 Mb
hookActionFrontControllerSetMedia	0.090 ms	- Mb
displayFooterBefore	2.045 ms	0.17 Mb
ps_emailalerts	29.731 ms	4.11 Mb
__construct	29.616 ms	4.11 Mb
hookActionFrontControllerSetMedia	0.115 ms	- Mb
ps_accounts	45.905 ms	7.84 Mb
__construct	45.905 ms	7.84 Mb
ps_shoppingcart	57.649 ms	11.62 Mb
__construct	20.632 ms	3.84 Mb
hookDisplayHeader	0.096 ms	- Mb
displayNav2	19.625 ms	3.94 Mb
displayNav2	17.296 ms	3.83 Mb
ps_searchbar	59.045 ms	7.66 Mb
__construct	26.427 ms	3.83 Mb
hookDisplayHeader	0.209 ms	- Mb
displayContentWrapperTop	32.409 ms	3.83 Mb
ps_imageslider	29.139 ms	4.02 Mb
__construct	29.002 ms	4.02 Mb
hookDisplayHeader	0.137 ms	- Mb
ps_googleanalytics	62.319 ms	7.22 Mb
__construct	39.811 ms	5.75 Mb
hookDisplayHeader	17.670 ms	1.21 Mb
hookDisplayBeforeBodyClosingTag	4.838 ms	0.26 Mb
productcomments	92.568 ms	8.45 Mb
__construct	28.595 ms	3.98 Mb
hookDisplayHeader	0.144 ms	- Mb
displayProductListReviews	47.506 ms	4.45 Mb
displayProductListReviews	2.282 ms	- Mb
displayProductListReviews	1.737 ms	- Mb
displayProductListReviews	7.924 ms	- Mb
displayProductListReviews	1.837 ms	- Mb
displayProductListReviews	2.543 ms	- Mb
customhomeblocks	26.980 ms	3.85 Mb
__construct	26.884 ms	3.85 Mb
hookHeader	0.096 ms	- Mb
ps_facetedsearch	122.404 ms	19.69 Mb
__construct	111.643 ms	17.55 Mb
hookProductSearchProvider	1.951 ms	0.16 Mb
hookDisplayLeftColumn	8.810 ms	1.98 Mb
ps_contactinfo	58.765 ms	13.49 Mb
__construct	15.115 ms	3.84 Mb
displayNav1	10.602 ms	1.99 Mb
displayFooter	33.048 ms	7.66 Mb
ps_languageselector	15.956 ms	3.87 Mb
__construct	15.528 ms	3.83 Mb
displayNav2	0.416 ms	0.04 Mb
displayNav2	0.012 ms	- Mb
ps_currencyselector	16.622 ms	3.90 Mb
__construct	15.949 ms	3.83 Mb
displayNav2	0.659 ms	0.07 Mb
displayNav2	0.014 ms	- Mb
ps_customersignin	67.094 ms	11.49 Mb
__construct	25.779 ms	3.82 Mb
displayNav2	25.168 ms	3.86 Mb
displayNav2	16.147 ms	3.81 Mb
ps_mainmenu	24.009 ms	4.71 Mb
__construct	17.073 ms	4.06 Mb
displayTop	6.936 ms	0.65 Mb
ps_categorytree	22.116 ms	4.08 Mb
__construct	15.566 ms	3.86 Mb
displayLeftColumn	6.550 ms	0.22 Mb
ps_linklist	54.407 ms	7.84 Mb
__construct	51.976 ms	7.70 Mb
displayFooter	2.431 ms	0.13 Mb
ps_customeraccountlinks	20.269 ms	3.91 Mb
__construct	19.450 ms	3.83 Mb
displayFooter	0.819 ms	0.07 Mb
23 module(s)	1402 ms	120.84 Mb

Collection 2018-2024

Sous-catégories

200 œuvres -...

Oeuvre N°001/200, Entre eux deux _ Océan Arcachon...

Oeuvre N°042/200, A l'or des Anciens _ Monségur _...

Oeuvre N°075/200, L'or noir _ Médoc Atlantique Sud _...

Oeuvre N°012/200 _ Instant entre amis _ Cadaujac _...

Oeuvre N°095, Port de Grima N°02 _ ex 0/5 _ Carrelet de...

Oeuvre N°097/200, A mon étoile _ Dune du Pilat _ Plage du...

Stopwatch SQL - 301 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
12 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
12 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
7 queries	SELECT state FROM fXXoa_feature_flag WHERE name = 'multiple_image_format' LIMIT XX
7 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
7 queries	SELECT XX FROM `fXXoa_specific_price` WHERE id_product = XX LIMIT XX
6 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
6 queries	SELECT name FROM fXXoa_category_lang WHERE id_shop = XX AND id_lang = XX AND id_category = XX LIMIT XX
6 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
6 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
6 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)
6 queries	SELECT `id_tax_rules_group` FROM `fXXoa_product_shop` WHERE `id_product` = XX AND id_shop=XX LIMIT XX
6 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
6 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
6 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
6 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
6 queries	SELECT * FROM `fXXoa_product_attribute_lang` WHERE `id_product_attribute` = XX
6 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`
6 queries	SELECT `id_product_attribute` FROM `fXXoa_product_attribute` WHERE `id_product` = XX
6 queries	SELECT pa.`id_product`, a.`color`, pac.`id_product_attribute`, SUM(IF(stock.`quantity` > XX, XX, XX)) qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by FROM `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;
6 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=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=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
3 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, XX, XX, XX, XX, XX, XX, XX, XX, XX, XX, XX, XX, XX, XX, XX, XX, XX, XX) AND il.`id_lang` = XX ORDER by i.`position`
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=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=XX)) AND ((fp_XX.id_feature_value IN (XX, XX))) GROUP BY pac.id_attribute
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

Name	Instances	Source
Product	18	/classes/Link.php:113 (__construct) [id: 3] /classes/Link.php:113 (__construct) [id: 44] /classes/Link.php:113 (__construct) [id: 60] /classes/Link.php:113 (__construct) [id: 61] /classes/Link.php:113 (__construct) [id: 63] /classes/Link.php:113 (__construct) [id: 66] /src/Adapter/Image/ImageRetriever.php:71 (__construct) [id: 3] /src/Adapter/Image/ImageRetriever.php:71 (__construct) [id: 44] /src/Adapter/Image/ImageRetriever.php:71 (__construct) [id: 60] /src/Adapter/Image/ImageRetriever.php:71 (__construct) [id: 61] /src/Adapter/Image/ImageRetriever.php:71 (__construct) [id: 63] /src/Adapter/Image/ImageRetriever.php:71 (__construct) [id: 66] /classes/Link.php:113 (__construct) [id: 3] /classes/Link.php:113 (__construct) [id: 44] /classes/Link.php:113 (__construct) [id: 60] /classes/Link.php:113 (__construct) [id: 61] /classes/Link.php:113 (__construct) [id: 63] /classes/Link.php:113 (__construct) [id: 66]
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]
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]
Combination	6	/classes/Product.php:5843 (__construct) [id: 54] /classes/Product.php:5843 (__construct) [id: 753] /classes/Product.php:5843 (__construct) [id: 1169] /classes/Product.php:5843 (__construct) [id: 1195] /classes/Product.php:5843 (__construct) [id: 1247] /classes/Product.php:5843 (__construct) [id: 1325]
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:684 (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=178)) AND ((fp_1.id_feature_value IN (211, 215))) 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=178)) AND ((fp_2.id_feature_value IN (211, 215))) GROUP BY pac.id_attribute	454.604 ms	857250	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 (21, 25))) AND ((fp_1.id_feature_value=178)) 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 (21, 25))) AND ((fp_2.id_feature_value=178)) GROUP BY fp.id_feature_value	23.170 ms	182880	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 (21, 25))) AND ((fp_1.id_feature_value=178)) AND ((fp_2.id_feature_value IN (211, 215))) 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 (21, 25))) AND ((fp_2.id_feature_value=178)) AND ((fp_3.id_feature_value IN (211, 215))) GROUP BY fp.id_feature_value	13.965 ms	4572000	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)
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 (21, 25))) AND ((fp_1.id_feature_value=178)) AND ((fp_2.id_feature_value IN (211, 215))) 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 (21, 25))) AND ((fp_2.id_feature_value=178)) AND ((fp_3.id_feature_value IN (211, 215))) GROUP BY fp.id_feature_value	8.193 ms	4572000	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)
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 (21, 25))) AND ((fp_1.id_feature_value=178)) AND ((fp_2.id_feature_value IN (211, 215))) 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 (21, 25))) AND ((fp_2.id_feature_value=178)) AND ((fp_3.id_feature_value IN (211, 215))) GROUP BY pac.id_attribute	7.550 ms	4572000	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)
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 (21, 25))) AND ((fp_1.id_feature_value=178)) AND ((fp_2.id_feature_value IN (211, 215))) 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 (21, 25))) AND ((fp_1.id_feature_value=178)) AND ((fp_2.id_feature_value IN (211, 215))) AND c.level_depth<=5 AND c.nleft>31 AND c.nright<36 GROUP BY cp.id_category	7.273 ms	100800000	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)
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 (21, 25))) AND ((fp_1.id_feature_value=178)) AND ((fp_2.id_feature_value IN (211, 215))) 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	6.978 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)
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 (21, 25))) AND ((fp_1.id_feature_value=178)) AND ((fp_2.id_feature_value IN (211, 215))) 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 (21, 25))) AND ((fp_2.id_feature_value=178)) AND ((fp_3.id_feature_value IN (211, 215))) GROUP BY fp.id_feature_value	6.912 ms	4572000	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 (21, 25))) AND ((fp_1.id_feature_value=178)) AND ((fp_2.id_feature_value IN (211, 215))) 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 (21, 25))) AND ((fp_1.id_feature_value=178)) AND ((fp_2.id_feature_value IN (211, 215))) GROUP BY p.id_manufacturer	6.223 ms	4572000	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)
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 (21, 25))) AND ((fp_1.id_feature_value IN (211, 215))) 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 (21, 25))) AND ((fp_2.id_feature_value IN (211, 215))) GROUP BY fp.id_feature_value	5.630 ms	13608000	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)
58	SELECT SQL_NO_CACHE `id_configuration` FROM `f1oa_configuration` WHERE name = 'PS_ACCOUNTS_SHOP_STATUS' AND (id_shop_group IS NULL OR id_shop_group = 0) AND (id_shop IS NULL OR id_shop = 0) LIMIT 1	5.220 ms	1			/classes/Configuration.php:133 /classes/Configuration.php:116 (getIdByNameFromGivenContext) /modules/ps_accounts/src/Adapter/Configuration.php:230 (getIdByName) /modules/ps_accounts/src/Adapter/Configuration.php:208 (getUncachedConfiguration) /modules/ps_accounts/src/Adapter/Configuration.php:129 (getUncached) /modules/ps_accounts/src/Repository/ConfigurationRepository.php:450 (get) /modules/ps_accounts/src/Account/StatusManager.php:370 (getCachedShopStatus) /modules/ps_accounts/src/Account/StatusManager.php:173 (getCachedStatus) /modules/ps_accounts/src/Account/StatusManager.php:118 (getStatus) /modules/ps_accounts/src/Service/PsAccountsService.php:217 (identityVerified) /modules/ps_checkout/vendor/invertus/infrastructure/src/Repository/PsAccountRepository.php:82 (isAccountLinked) /modules/ps_checkout/vendor/invertus/infrastructure/src/Validator/MerchantValidator.php:55 (isAccountLinked) /modules/ps_checkout/ps_checkout.php:1291 (isValid) /modules/ps_checkout/ps_checkout.php:327 (merchantIsValid) /classes/Hook.php:993 (hookActionFrontControllerSetMedia) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:418 (coreCallHook) /classes/Hook.php:928 (callHookOn) /classes/controller/FrontController.php:948 (exec) /tools/profiling/Controller.php:48 (setMedia) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
33	SELECT SQL_NO_CACHE `id_lang` FROM `f1oa_lang` WHERE `locale` = 'fr-fr' OR `language_code` = 'fr-fr' LIMIT 1	4.215 ms	8			/classes/Language.php:849 /src/Adapter/Currency/CurrencyDataProvider.php:112 (getIdByLocale) /src/Core/Localization/Currency/DataLayer/CurrencyDatabase.php:102 (getCurrencyByIsoCodeAndLocale) /src/Core/Data/Layer/AbstractDataLayer.php:91 (doRead) /src/Core/Data/Layer/AbstractDataLayer.php:150 (read) /src/Core/Data/Layer/AbstractDataLayer.php:95 (propagateRead) /src/Core/Localization/Currency/CurrencyDataSource.php:67 (read) /src/Core/Localization/Currency/CurrencyDataSource.php:109 (getLocalizedCurrencyData) /src/Core/Localization/Currency/CurrencyDataSource.php:96 (formatCurrenciesData) /src/Core/Localization/Currency/Repository.php:87 (getAllInstalledCurrenciesData) /src/Core/Localization/Locale/Repository.php:207 (getAllInstalledCurrencies) /src/Core/Localization/Locale/Repository.php:150 (getPriceSpecifications) /classes/controller/Controller.php:208 (getLocale) /classes/controller/FrontController.php:282 (init) /controllers/front/listing/CategoryController.php:81 (init) /tools/profiling/Controller.php:41 (init) /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 (21, 25))) AND ((fp_1.id_feature_value=178)) AND ((fp_2.id_feature_value IN (211, 215))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND c.nleft>=31 AND c.nright<=36	3.712 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)
14	SELECT SQL_NO_CACHE `name`, `alias` FROM `f1oa_hook_alias`	3.625 ms	88			/classes/Hook.php:287 /classes/Hook.php:318 (getAllHookAliases) /classes/Hook.php:710 (getHookAliasesFor) /classes/Hook.php:803 (getHookModuleExecList) /classes/Dispatcher.php:586 (exec) /classes/Dispatcher.php:243 (loadRoutes) /classes/Dispatcher.php:201 (__construct) /index.php:28 (getInstance)
26	SELECT SQL_NO_CACHE c.id_currency FROM `f1oa_currency` c WHERE (iso_code = 'CHF') LIMIT 1	3.551 ms	1			/classes/Currency.php:895 /src/Adapter/Currency/CurrencyDataProvider.php:92 (getIdByIsoCode) /src/Adapter/Currency/CurrencyDataProvider.php:114 (getCurrencyByIsoCode) /src/Core/Localization/Currency/DataLayer/CurrencyDatabase.php:102 (getCurrencyByIsoCodeAndLocale) /src/Core/Data/Layer/AbstractDataLayer.php:91 (doRead) /src/Core/Data/Layer/AbstractDataLayer.php:150 (read) /src/Core/Data/Layer/AbstractDataLayer.php:95 (propagateRead) /src/Core/Localization/Currency/CurrencyDataSource.php:67 (read) /src/Core/Localization/Currency/CurrencyDataSource.php:109 (getLocalizedCurrencyData) /src/Core/Localization/Currency/CurrencyDataSource.php:96 (formatCurrenciesData) /src/Core/Localization/Currency/Repository.php:87 (getAllInstalledCurrenciesData) /src/Core/Localization/Locale/Repository.php:207 (getAllInstalledCurrencies) /src/Core/Localization/Locale/Repository.php:150 (getPriceSpecifications) /classes/controller/Controller.php:208 (getLocale) /classes/controller/FrontController.php:282 (init) /controllers/front/listing/CategoryController.php:81 (init) /tools/profiling/Controller.php:41 (init) /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 (21, 25))) AND ((fp_1.id_feature_value=178)) AND ((fp_2.id_feature_value IN (211, 215))) 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 (21, 25))) AND ((fp_2.id_feature_value=178)) AND ((fp_3.id_feature_value IN (211, 215))) GROUP BY pac.id_attribute	2.759 ms	4572000	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)
44	SELECT SQL_NO_CACHE * FROM `f1oa_group` a LEFT JOIN `f1oa_group_shop` `c` ON a.`id_group` = c.`id_group` AND c.`id_shop` = 1 WHERE (a.`id_group` = 1) LIMIT 1	2.017 ms	1			/src/Adapter/EntityMapper.php:71 /classes/ObjectModel.php:282 (load) /tools/profiling/ObjectModel.php:32 (__construct) /classes/Group.php:81 (__construct) /classes/Group.php:397 (__construct) /classes/Cart.php:249 (getCurrent) /classes/Cart.php:222 (setTaxCalculationMethod) /classes/controller/FrontController.php:427 (__construct) /controllers/front/listing/CategoryController.php:81 (init) /tools/profiling/Controller.php:41 (init) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
108	REPLACE INTO f1oa_layered_filter_block (hash, data) VALUES ("ce3c7e09e8dbbebe74d6a3e736c713eb", "a:1:{s:7:\"filters\";a:10:{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:6;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:6;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:6;}}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:5:{i:192;a:4:{s:3:\"nbr\";i:1;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:4;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:2;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:1;s:4:\"name\";s:12:\"Portrait 2:3\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:194;a:4:{s:3:\"nbr\";i:2;s:4:\"name\";s:13:\"Triptyque 3:1\";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:11:{i:18;a:4:{s:4:\"name\";s:7:\"40x60cm\";s:3:\"nbr\";i:24;s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:19;a:4:{s:4:\"name\";s:7:\"60x90cm\";s:3:\"nbr\";i:25;s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:20;a:4:{s:4:\"name\";s:8:\"80x120cm\";s:3:\"nbr\";i:19;s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:21;a:5:{s:4:\"name\";s:8:\"40x120cm\";s:3:\"nbr\";i:6;s:8:\"url_name\";N;s:10:\"meta_title\";N;s:7:\"checked\";b:1;}i:22;a:4:{s:4:\"name\";s:27:\"60x180 (triptyque 3x 60x60)\";s:3:\"nbr\";i:7;s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:23;a:4:{s:4:\"name\";s:8:\"50x100cm\";s:3:\"nbr\";i:13;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:6;s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:25;a:5:{s:4:\"name\";s:7:\"40x80cm\";s:3:\"nbr\";i:5;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:5;s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:15;a:4:{s:4:\"name\";s:7:\"60x60cm\";s:3:\"nbr\";i:5;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:5:{i:175;a:4:{s:3:\"nbr\";i:3;s:4:\"name\";s:4:\"2018\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:176;a:4:{s:3:\"nbr\";i:6;s:4:\"name\";s:4:\"2019\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:177;a:4:{s:3:\"nbr\";i:2;s:4:\"name\";s:4:\"2020\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:178;a:5:{s:3:\"nbr\";i:6;s:4:\"name\";s:4:\"2021\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:7:\"checked\";b:1;}i:180;a:4:{s:3:\"nbr\";i:1;s:4:\"name\";s:4:\"2023\";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:6;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:6;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:15:{i:200;a:4:{s:3:\"nbr\";i:4;s:4:\"name\";s:16:\"Ambiance de Nuit\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:202;a:4:{s:3:\"nbr\";i:1;s:4:\"name\";s:12:\"Architecture\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:205;a:4:{s:3:\"nbr\";i:1;s:4:\"name\";s:17:\"Astrophotographie\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:210;a:4:{s:3:\"nbr\";i:4;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:1;s:4:\"name\";s:17:\"Bassin d\'Arcachon\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:207;a:4:{s:3:\"nbr\";i:2;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:3;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:2;s:4:\"name\";s:16:\"Emotions du Ciel\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:211;a:5:{s:3:\"nbr\";i:3;s:4:\"name\";s:22:\"Histoires et Aventures\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:7:\"checked\";b:1;}i:215;a:5:{s:3:\"nbr\";i:4;s:4:\"name\";s:14:\"Lacs et Océan\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:7:\"checked\";b:1;}i:217;a:4:{s:3:\"nbr\";i:2;s:4:\"name\";s:10:\"Nature Zen\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:213;a:4:{s:3:\"nbr\";i:1;s:4:\"name\";s:16:\"Regards d\'Hommes\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:220;a:4:{s:3:\"nbr\";i:1;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:1;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:1;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:6;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:6;}}s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";i:0;}}}")	1.456 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)
288	SELECT SQL_NO_CACHE `id_module` FROM `f1oa_module` WHERE `name` = "ps_linklist" LIMIT 1	1.383 ms	1			/classes/module/Module.php:2633 /classes/module/Module.php:2105 (getModuleIdByName) /classes/Hook.php:999 (isEnabled) /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/d1/ca/8a/d1ca8ac15d922562f74c29782ee71559a53528ef_2.file.footer.tpl.php:132 (__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/d1/ca/8a/d1ca8ac15d922562f74c29782ee71559a53528ef_2.file.footer.tpl.php:78 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6a5f98741f6e23_05467366) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php: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/6d/b0/10/6db010da081764cb9b7ddedbe0282abc1b67e8ac_2.file.layout-both-columns.tpl.php:343 (_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/6d/b0/10/6db010da081764cb9b7ddedbe0282abc1b67e8ac_2.file.layout-both-columns.tpl.php:111 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6a5f987352a8f3_73007425) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php: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_6a5f98735136e3_15493887) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php: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_6a5f987350bc36_17432709) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php: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_6a5f98734f5d40_75572826) /vendor/smarty/smarty/libs/sysplugins/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)
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 (21, 25))) AND ((fp_1.id_feature_value=178)) AND ((fp_2.id_feature_value IN (211, 215))) 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 (21, 25))) AND ((fp_2.id_feature_value=178)) AND ((fp_3.id_feature_value IN (211, 215))) GROUP BY fp.id_feature_value	1.321 ms	4572000	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)
128	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.320 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)
49	SELECT SQL_NO_CACHE * FROM `f1oa_category` a LEFT JOIN `f1oa_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 2 LEFT JOIN `f1oa_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1 WHERE (a.`id_category` = 5) AND (b.`id_shop` = 1) LIMIT 1	1.275 ms	1			/src/Adapter/EntityMapper.php:71 /classes/ObjectModel.php:282 (load) /tools/profiling/ObjectModel.php:32 (__construct) /classes/Category.php:164 (__construct) /controllers/front/listing/CategoryController.php:207 (__construct) :undefined ({closure:CategoryControllerCore::getTemplateVarSubCategories():206}) /controllers/front/listing/CategoryController.php:206 (array_map) /controllers/front/listing/CategoryController.php:117 (getTemplateVarSubCategories) /tools/profiling/Controller.php:41 (init) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
31	SELECT SQL_NO_CACHE * FROM `f1oa_currency` a LEFT JOIN `f1oa_currency_lang` `b` ON a.`id_currency` = b.`id_currency` AND b.`id_lang` = 2 LEFT JOIN `f1oa_currency_shop` `c` ON a.`id_currency` = c.`id_currency` AND c.`id_shop` = 1 WHERE (a.`id_currency` = 1) LIMIT 1	1.173 ms	1			/src/Adapter/EntityMapper.php:71 /classes/ObjectModel.php:282 (load) /tools/profiling/ObjectModel.php:32 (__construct) /classes/Currency.php:246 (__construct) /src/Adapter/Currency/CurrencyDataProvider.php:101 (__construct) /src/Adapter/Currency/CurrencyDataProvider.php:114 (getCurrencyByIsoCode) /src/Core/Localization/Currency/DataLayer/CurrencyDatabase.php:102 (getCurrencyByIsoCodeAndLocale) /src/Core/Data/Layer/AbstractDataLayer.php:91 (doRead) /src/Core/Data/Layer/AbstractDataLayer.php:150 (read) /src/Core/Data/Layer/AbstractDataLayer.php:95 (propagateRead) /src/Core/Localization/Currency/CurrencyDataSource.php:67 (read) /src/Core/Localization/Currency/CurrencyDataSource.php:109 (getLocalizedCurrencyData) /src/Core/Localization/Currency/CurrencyDataSource.php:96 (formatCurrenciesData) /src/Core/Localization/Currency/Repository.php:87 (getAllInstalledCurrenciesData) /src/Core/Localization/Locale/Repository.php:207 (getAllInstalledCurrencies) /src/Core/Localization/Locale/Repository.php:150 (getPriceSpecifications) /classes/controller/Controller.php:208 (getLocale) /classes/controller/FrontController.php:282 (init) /controllers/front/listing/CategoryController.php:81 (init) /tools/profiling/Controller.php:41 (init) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
120	SELECT SQL_NO_CACHE 1 FROM `f1oa_specific_price` WHERE `id_product_attribute` != 0 LIMIT 1	1.044 ms	238			/classes/SpecificPrice.php:297 /classes/SpecificPrice.php:368 (filterOutField) /classes/SpecificPrice.php:548 (computeExtraConditions) /classes/Product.php:3816 (getSpecificPrice) /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)
16	SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module`as `mshop` FROM `f1oa_module` m LEFT JOIN `f1oa_module_shop` ms ON m.`id_module` = ms.`id_module` AND ms.`id_shop` = 1	0.987 ms	79			/classes/module/Module.php:340 /modules/ps_checkout/ps_checkout.php:118 (__construct) :undefined (__construct) /src/Core/Foundation/IoC/Container.php:123 (newInstance) /src/Core/Foundation/IoC/Container.php:153 (makeInstanceFromClassName) /src/Core/Foundation/IoC/Container.php:166 (doMake) /src/Adapter/ServiceLocator.php:70 (make) /classes/module/Module.php:1232 (get) /tools/profiling/Module.php:35 (coreLoadModule) /classes/module/Module.php:1211 (coreLoadModule) /classes/Hook.php:913 (getInstanceByName) /classes/Dispatcher.php:586 (exec) /classes/Dispatcher.php:243 (loadRoutes) /classes/Dispatcher.php:201 (__construct) /index.php:28 (getInstance)
77	SELECT SQL_NO_CACHE type, id_value, filter_show_limit, filter_type FROM f1oa_layered_category WHERE controller = 'category' AND id_category = 8 AND id_shop = 1 GROUP BY `type`, id_value ORDER BY position ASC	0.979 ms	12	Yes	Yes	/modules/ps_facetedsearch/src/Filters/Provider.php:57 /modules/ps_facetedsearch/src/Filters/Converter.php:263 (getFiltersForQuery) /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)
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.968 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)
20	SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module`as `mshop` FROM `f1oa_module` m LEFT JOIN `f1oa_module_shop` ms ON m.`id_module` = ms.`id_module` AND ms.`id_shop` = 1	0.900 ms	79			/classes/module/Module.php:340 /modules/smartredirect/smartredirect.php:16 (__construct) :undefined (__construct) /src/Core/Foundation/IoC/Container.php:123 (newInstance) /src/Core/Foundation/IoC/Container.php:153 (makeInstanceFromClassName) /src/Core/Foundation/IoC/Container.php:166 (doMake) /src/Adapter/ServiceLocator.php:70 (make) /classes/module/Module.php:1232 (get) /tools/profiling/Module.php:35 (coreLoadModule) /classes/module/Module.php:1211 (coreLoadModule) /classes/Hook.php:913 (getInstanceByName) /classes/Dispatcher.php:351 (exec) /index.php:28 (dispatch)
129	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.834 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)
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.828 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)
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.823 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)
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.792 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)
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.792 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)
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.756 ms	172	Yes		/classes/Dispatcher.php:633 /classes/Dispatcher.php:243 (loadRoutes) /classes/Dispatcher.php:201 (__construct) /index.php:28 (getInstance)
82	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` = 7 ORDER BY vl.`value` ASC	0.679 ms	22	Yes		/modules/ps_facetedsearch/src/Filters/DataAccessor.php:194 /modules/ps_facetedsearch/src/Filters/Converter.php:402 (getFeatureValues) /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)
267	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.661 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_6a5f987352a8f3_73007425) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php: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_6a5f98735136e3_15493887) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php: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_6a5f987350bc36_17432709) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php: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_6a5f98734f5d40_75572826) /vendor/smarty/smarty/libs/sysplugins/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)
281	SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, SUM(IF(stock.`quantity` > 0, 1, 0)) qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by FROM `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 (61) 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.655 ms	27	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_6a5f9873ce2c61_24071098) /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_6a5f9873c9ec58_93359404) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php: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_6a5f9873c95596_23831154) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php: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_6a5f987352a8f3_73007425) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php: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_6a5f98735136e3_15493887) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php: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_6a5f987350bc36_17432709) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php: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_6a5f98734f5d40_75572826) /vendor/smarty/smarty/libs/sysplugins/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)
80	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 = 13 ORDER BY agl.`name` ASC, a.`position` ASC	0.622 ms	13	Yes		/modules/ps_facetedsearch/src/Filters/DataAccessor.php:77 /modules/ps_facetedsearch/src/Filters/Converter.php:427 (getAttributes) /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)
280	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 (60) 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.619 ms	26	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_6a5f9873ce2c61_24071098) /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_6a5f9873c9ec58_93359404) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php: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_6a5f9873c95596_23831154) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php: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_6a5f987352a8f3_73007425) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php: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_6a5f98735136e3_15493887) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php: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_6a5f987350bc36_17432709) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php: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_6a5f98734f5d40_75572826) /vendor/smarty/smarty/libs/sysplugins/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)
276	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 (3) 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.612 ms	16	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_6a5f9873ce2c61_24071098) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php: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_6a5f9873c9ec58_93359404) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php: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_6a5f9873c95596_23831154) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php: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_6a5f987352a8f3_73007425) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php: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_6a5f98735136e3_15493887) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php: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_6a5f987350bc36_17432709) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php: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_6a5f98734f5d40_75572826) /vendor/smarty/smarty/libs/sysplugins/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)

#	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