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°044-sable-dune-pilat-forme-sculpture-tempete-noir-nb : Oeuvre N°044/200, Je li(e) mon destin N°02 _ Dune du Pilat _ Sculpture _ Ligne et Déco (Édition limitée 5 ex.)

Aperçu rapide

Oeuvre N°044/200, Je li(e) mon destin N°02 _ Dune du...

Dès 135,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°017-ocean-etoile-homme : Oeuvre N°017/200, Le gardien du temps _ ex 0/5 _ Océan _ Nuit des étoiles (Édition limitée 5 ex.)

Aperçu rapide

Oeuvre N°017/200, Le gardien du temps _ ex 0/5 _ Océan _...

Dès 135,00 €

Warning

251

Warning

251

Warning

251

Tirage photo d’art – Oeuvre N°oeuvre_n°010-dune-etoile-plage-ocean : Oeuvre N°010/200, Aux portes de l'Univers Nº02 _ Bassin d'Arcachon, Dune du Pilat, Cap Ferret (Édition limitée 5 ex.)

Aperçu rapide

Oeuvre N°010/200, Aux portes de l'Univers Nº02 _ Bassin...

Dès 135,00 €

Warning

251

Warning

251

Warning

251

Tirage photo d’art – Oeuvre N°oeuvre_n°068-regard-montagne-etoile-obscure-homme : Oeuvre N°068/200, Au coeur de la nuit N°01 _ Vallée du Louron _ Loudenvielle (Édition limitée 5 ex.)

Aperçu rapide

Oeuvre N°068/200, Au coeur de la nuit N°01 _ Vallée du...

Dès 135,00 €

Warning

251

Warning

251

Warning

251

Tirage photo d’art – Oeuvre N°oeuvre_n°026-montagne-neige-trace-ski-regard-homme : Oeuvre N°026/200, Suivre sa propre route _ Pyrénéens (Édition limitée 5 ex.)

Aperçu rapide

Oeuvre N°026/200, Suivre sa propre route _ Pyrénéens

Dès 135,00 €

Warning

251

Warning

251

Warning

251

Tirage photo d’art – Oeuvre N°oeuvre_n°192-plage-ocean-aurore-ciel-couleur-basque : Oeuvre N°192/200, Aurore Boréale depuis les cotes du Pays Basque Fin 2018-2024 (Édition limitée 5 ex.)

Aperçu rapide

Oeuvre N°192/200, Aurore Boréale depuis les cotes du Pays...

Dès 135,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	1809 ms
Querying Time	178 ms
Queries	303
Memory Peak Usage	160.2 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 $_COOKIE	2k
- global $_REQUEST	2k

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

	Time	Cumulated Time	Memory Usage	Memory Peak Usage
config	5.816 ms	5.816 ms	17.86 Mb	18.9 Mb
__construct	7.755 ms	13.571 ms	1.90 Mb	21.5 Mb
init	70.314 ms	83.885 ms	9.68 Mb	30.6 Mb
checkAccess	0.002 ms	83.887 ms	- Mb	30.6 Mb
setMedia	173.351 ms	257.238 ms	37.84 Mb	67.8 Mb
postProcess	0.002 ms	257.240 ms	- Mb	67.8 Mb
initHeader	0.002 ms	257.242 ms	- Mb	67.8 Mb
initContent	595.407 ms	853 ms	1.10 Mb	123.0 Mb
initFooter	0.002 ms	853 ms	- Mb	123.0 Mb
display	956 ms	1809 ms	- Mb	160.2 Mb

Hook	Time	Memory Usage
DisplayFooter	185.656 ms	45.73 Mb
=> blockwishlist	185.656 ms	45.73 Mb
ActionFrontControllerSetMedia	74.899 ms	14.23 Mb
=> blockreassurance	1.005 ms	0.11 Mb
=> blockwishlist	0.255 ms	- Mb
=> ps_emailsubscription	0.092 ms	- Mb
=> ps_socialfollow	0.068 ms	- Mb
=> ps_emailalerts	0.079 ms	- Mb
=> ps_checkout	73.400 ms	14.11 Mb
displayNav2	67.811 ms	15.55 Mb
=> ps_languageselector (widget)	0.452 ms	0.04 Mb
=> ps_currencyselector (widget)	0.573 ms	0.07 Mb
=> ps_customersignin (widget)	16.266 ms	3.85 Mb
=> ps_shoppingcart (widget)	17.386 ms	3.88 Mb
=> ps_languageselector (widget)	0.010 ms	- Mb
=> ps_currencyselector (widget)	0.012 ms	- Mb
=> ps_customersignin (widget)	16.349 ms	3.88 Mb
=> ps_shoppingcart (widget)	16.763 ms	3.83 Mb
displayProductListReviews	45.381 ms	4.47 Mb
=> productcomments (widget)	30.339 ms	4.44 Mb
=> productcomments (widget)	6.329 ms	- Mb
=> productcomments (widget)	2.354 ms	- Mb
=> productcomments (widget)	2.013 ms	- Mb
=> productcomments (widget)	2.208 ms	- Mb
=> productcomments (widget)	2.138 ms	- Mb
displayFooter	34.243 ms	7.86 Mb
=> ps_linklist (widget)	0.948 ms	0.13 Mb
=> ps_customeraccountlinks (widget)	0.859 ms	0.07 Mb
=> ps_contactinfo (widget)	32.436 ms	7.66 Mb
displayFooterBefore	32.281 ms	7.84 Mb
=> ps_emailsubscription (widget)	30.776 ms	7.67 Mb
=> ps_socialfollow (widget)	1.505 ms	0.17 Mb
displayContentWrapperTop	16.919 ms	3.83 Mb
=> ps_searchbar (widget)	16.919 ms	3.83 Mb
DisplayHeader	11.361 ms	1.21 Mb
=> ps_shoppingcart	0.070 ms	- Mb
=> ps_searchbar	0.144 ms	- Mb
=> ps_imageslider	0.096 ms	- Mb
=> ps_googleanalytics	10.956 ms	1.21 Mb
=> productcomments	0.095 ms	- Mb
displayNav1	10.420 ms	1.99 Mb
=> ps_contactinfo (widget)	10.420 ms	1.99 Mb
DisplayLeftColumn	8.843 ms	1.98 Mb
=> ps_facetedsearch	8.843 ms	1.98 Mb
displayLeftColumn	7.072 ms	0.22 Mb
=> ps_categorytree (widget)	7.072 ms	0.22 Mb
displayTop	6.918 ms	0.65 Mb
=> ps_mainmenu (widget)	6.918 ms	0.65 Mb
DisplayBeforeBodyClosingTag	4.732 ms	0.26 Mb
=> ps_googleanalytics	4.732 ms	0.26 Mb
ProductSearchProvider	1.926 ms	0.16 Mb
=> ps_facetedsearch	1.926 ms	0.16 Mb
Header	0.084 ms	- Mb
=> customhomeblocks	0.084 ms	- Mb
DisplayAfterBodyOpeningTag	0.011 ms	- Mb
=> blockreassurance	0.011 ms	- Mb
DisplayFooterAfter	0.010 ms	- Mb
=> blockreassurance	0.010 ms	- Mb
DisplayNavFullWidth	0.009 ms	- Mb
=> blockreassurance	0.009 ms	- Mb
ActionDispatcherBefore	0.006 ms	- Mb
=> smartredirect	0.006 ms	- Mb
ModuleRoutes	0.005 ms	- Mb
=> ps_checkout	0.005 ms	- Mb
DisplayFooterBefore	0.005 ms	- Mb
=> blockreassurance	0.005 ms	- Mb
21 hook(s)	508.592 ms	105.99 Mb

Module	Time	Memory Usage
ps_checkout	96.768 ms	18.69 Mb
__construct	23.352 ms	4.58 Mb
hookModuleRoutes	0.010 ms	- Mb
hookActionFrontControllerSetMedia	73.406 ms	14.11 Mb
smartredirect	0.538 ms	0.03 Mb
__construct	0.529 ms	0.03 Mb
hookActionDispatcherBefore	0.009 ms	- Mb
blockreassurance	76.389 ms	- Mb
__construct	25.697 ms	5.84 Mb
hookActionFrontControllerSetMedia	1.009 ms	0.11 Mb
hookDisplayAfterBodyOpeningTag	0.015 ms	- Mb
hookDisplayNavFullWidth	0.011 ms	- Mb
hookDisplayFooterBefore	0.008 ms	- Mb
hookDisplayFooterAfter	49.649 ms	- Mb
blockwishlist	200.810 ms	49.59 Mb
__construct	14.888 ms	3.86 Mb
hookActionFrontControllerSetMedia	0.259 ms	- Mb
hookDisplayFooter	185.663 ms	45.73 Mb
ps_emailsubscription	54.425 ms	13.59 Mb
__construct	23.548 ms	5.92 Mb
hookActionFrontControllerSetMedia	0.095 ms	- Mb
displayFooterBefore	30.782 ms	7.67 Mb
ps_socialfollow	17.575 ms	4.04 Mb
__construct	15.994 ms	3.87 Mb
hookActionFrontControllerSetMedia	0.071 ms	- Mb
displayFooterBefore	1.510 ms	0.17 Mb
ps_emailalerts	17.419 ms	4.11 Mb
__construct	17.335 ms	4.11 Mb
hookActionFrontControllerSetMedia	0.084 ms	- Mb
ps_accounts	31.218 ms	7.84 Mb
__construct	31.218 ms	7.84 Mb
ps_shoppingcart	49.823 ms	11.56 Mb
__construct	15.578 ms	3.84 Mb
hookDisplayHeader	0.074 ms	- Mb
displayNav2	17.402 ms	3.88 Mb
displayNav2	16.769 ms	3.83 Mb
ps_searchbar	32.489 ms	7.66 Mb
__construct	15.416 ms	3.83 Mb
hookDisplayHeader	0.148 ms	- Mb
displayContentWrapperTop	16.925 ms	3.83 Mb
ps_imageslider	16.495 ms	4.02 Mb
__construct	16.394 ms	4.02 Mb
hookDisplayHeader	0.101 ms	- Mb
ps_googleanalytics	38.581 ms	7.22 Mb
__construct	22.883 ms	5.75 Mb
hookDisplayHeader	10.961 ms	1.21 Mb
hookDisplayBeforeBodyClosingTag	4.737 ms	0.26 Mb
productcomments	61.900 ms	8.45 Mb
__construct	16.375 ms	3.98 Mb
hookDisplayHeader	0.099 ms	- Mb
displayProductListReviews	30.344 ms	4.45 Mb
displayProductListReviews	6.339 ms	- Mb
displayProductListReviews	2.363 ms	- Mb
displayProductListReviews	2.019 ms	- Mb
displayProductListReviews	2.216 ms	- Mb
displayProductListReviews	2.146 ms	- Mb
customhomeblocks	20.846 ms	3.85 Mb
__construct	20.757 ms	3.85 Mb
hookHeader	0.089 ms	- Mb
ps_facetedsearch	80.552 ms	19.69 Mb
__construct	69.772 ms	17.55 Mb
hookProductSearchProvider	1.931 ms	0.16 Mb
hookDisplayLeftColumn	8.849 ms	1.98 Mb
ps_contactinfo	57.833 ms	13.49 Mb
__construct	14.964 ms	3.84 Mb
displayNav1	10.427 ms	1.99 Mb
displayFooter	32.442 ms	7.66 Mb
ps_languageselector	14.815 ms	3.87 Mb
__construct	14.346 ms	3.83 Mb
displayNav2	0.457 ms	0.04 Mb
displayNav2	0.012 ms	- Mb
ps_currencyselector	15.178 ms	3.90 Mb
__construct	14.588 ms	3.83 Mb
displayNav2	0.577 ms	0.07 Mb
displayNav2	0.013 ms	- Mb
ps_customersignin	46.838 ms	11.56 Mb
__construct	14.212 ms	3.82 Mb
displayNav2	16.272 ms	3.86 Mb
displayNav2	16.354 ms	3.88 Mb
ps_mainmenu	23.823 ms	4.71 Mb
__construct	16.900 ms	4.06 Mb
displayTop	6.923 ms	0.65 Mb
ps_categorytree	22.475 ms	4.08 Mb
__construct	15.398 ms	3.86 Mb
displayLeftColumn	7.077 ms	0.22 Mb
ps_linklist	30.871 ms	7.84 Mb
__construct	29.919 ms	7.70 Mb
displayFooter	0.952 ms	0.13 Mb
ps_customeraccountlinks	15.880 ms	3.91 Mb
__construct	15.016 ms	3.83 Mb
displayFooter	0.864 ms	0.07 Mb
23 module(s)	1024 ms	118.94 Mb

Collection 2018-2024

Sous-catégories

200 œuvres -...

Oeuvre N°044/200, Je li(e) mon destin N°02 _ Dune du...

Oeuvre N°017/200, Le gardien du temps _ ex 0/5 _ Océan _...

Oeuvre N°010/200, Aux portes de l'Univers Nº02 _ Bassin...

Oeuvre N°068/200, Au coeur de la nuit N°01 _ Vallée du...

Oeuvre N°026/200, Suivre sa propre route _ Pyrénéens

Oeuvre N°192/200, Aurore Boréale depuis les cotes du Pays...

Stopwatch SQL - 303 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 `priority`, `id_specific_price_priority` FROM `fXXoa_specific_price_priority` WHERE `id_product` = XX ORDER BY `id_specific_price_priority` DESC LIMIT XX
6 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
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
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) 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: 46] /classes/Link.php:113 (__construct) [id: 54] /classes/Link.php:113 (__construct) [id: 105] /classes/Link.php:113 (__construct) [id: 109] /classes/Link.php:113 (__construct) [id: 400] /classes/Link.php:113 (__construct) [id: 428] /src/Adapter/Image/ImageRetriever.php:71 (__construct) [id: 46] /src/Adapter/Image/ImageRetriever.php:71 (__construct) [id: 54] /src/Adapter/Image/ImageRetriever.php:71 (__construct) [id: 105] /src/Adapter/Image/ImageRetriever.php:71 (__construct) [id: 109] /src/Adapter/Image/ImageRetriever.php:71 (__construct) [id: 400] /src/Adapter/Image/ImageRetriever.php:71 (__construct) [id: 428] /classes/Link.php:113 (__construct) [id: 46] /classes/Link.php:113 (__construct) [id: 54] /classes/Link.php:113 (__construct) [id: 105] /classes/Link.php:113 (__construct) [id: 109] /classes/Link.php:113 (__construct) [id: 400] /classes/Link.php:113 (__construct) [id: 428]
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: 806] /classes/Product.php:5843 (__construct) [id: 1014] /classes/Product.php:5843 (__construct) [id: 2166] /classes/Product.php:5843 (__construct) [id: 2270] /classes/Product.php:5843 (__construct) [id: 4777] /classes/Product.php:5843 (__construct) [id: 5014]
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=177)) AND ((fp_1.id_feature_value IN (205, 213))) 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=177)) AND ((fp_2.id_feature_value IN (205, 213))) GROUP BY pac.id_attribute	52.055 ms	506250	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 (18, 23))) AND ((fp_1.id_feature_value=177)) 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 (18, 23))) AND ((fp_2.id_feature_value=177)) GROUP BY fp.id_feature_value	25.147 ms	20250	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:808 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:856 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:155 (getFeaturesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:218 (getFilterBlock) /classes/controller/ProductListingFrontController.php:355 (runQuery) /classes/controller/ProductListingFrontController.php:634 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:133 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
95	SELECT SQL_NO_CACHE fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, pa.id_product_attribute, cp.position FROM f1oa_product p LEFT JOIN f1oa_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN f1oa_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN f1oa_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN f1oa_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN f1oa_category_product cp ON (p.id_product = cp.id_product) INNER JOIN f1oa_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN f1oa_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN f1oa_feature_product fp_1 ON (p.id_product = fp_1.id_product) WHERE ((pac.id_attribute IN (18, 23))) AND ((fp_1.id_feature_value IN (205, 213))) 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 (18, 23))) AND ((fp_2.id_feature_value IN (205, 213))) GROUP BY fp.id_feature_value	15.379 ms	24570	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 (18, 23))) AND ((fp_1.id_feature_value=177)) AND ((fp_2.id_feature_value IN (205, 213))) 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 (18, 23))) AND ((fp_2.id_feature_value=177)) AND ((fp_3.id_feature_value IN (205, 213))) GROUP BY fp.id_feature_value	3.585 ms	506250	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:808 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:856 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:155 (getFeaturesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:218 (getFilterBlock) /classes/controller/ProductListingFrontController.php:355 (runQuery) /classes/controller/ProductListingFrontController.php:634 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:133 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
88	SELECT SQL_NO_CACHE fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, pa.id_product_attribute, cp.position FROM f1oa_product p LEFT JOIN f1oa_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN f1oa_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN f1oa_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN f1oa_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN f1oa_category_product cp ON (p.id_product = cp.id_product) INNER JOIN f1oa_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN f1oa_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN f1oa_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN f1oa_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((pac.id_attribute IN (18, 23))) AND ((fp_1.id_feature_value=177)) AND ((fp_2.id_feature_value IN (205, 213))) 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 (18, 23))) AND ((fp_2.id_feature_value=177)) AND ((fp_3.id_feature_value IN (205, 213))) GROUP BY fp.id_feature_value	3.522 ms	506250	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 (18, 23))) AND ((fp_1.id_feature_value=177)) AND ((fp_2.id_feature_value IN (205, 213))) 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 (18, 23))) AND ((fp_2.id_feature_value=177)) AND ((fp_3.id_feature_value IN (205, 213))) GROUP BY fp.id_feature_value	3.324 ms	506250	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 (18, 23))) AND ((fp_1.id_feature_value=177)) AND ((fp_2.id_feature_value IN (205, 213))) 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 (18, 23))) AND ((fp_2.id_feature_value=177)) AND ((fp_3.id_feature_value IN (205, 213))) GROUP BY pac.id_attribute	3.041 ms	506250	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 (18, 23))) AND ((fp_1.id_feature_value=177)) AND ((fp_2.id_feature_value IN (205, 213))) 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 (18, 23))) AND ((fp_1.id_feature_value=177)) AND ((fp_2.id_feature_value IN (205, 213))) AND c.level_depth<=5 AND c.nleft>31 AND c.nright<36 GROUP BY cp.id_category	2.722 ms	1518750	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)
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 (18, 23))) AND ((fp_1.id_feature_value=177)) AND ((fp_2.id_feature_value IN (205, 213))) 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 (18, 23))) AND ((fp_1.id_feature_value=177)) AND ((fp_2.id_feature_value IN (205, 213))) GROUP BY p.id_manufacturer	2.705 ms	506250	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)
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 (18, 23))) AND ((fp_1.id_feature_value=177)) AND ((fp_2.id_feature_value IN (205, 213))) 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	1.652 ms	102515625	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)
108	REPLACE INTO f1oa_layered_filter_block (hash, data) VALUES ("c87cdeb83a1c63b3fe9f0f3e90ad0b5e", "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:135;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:4;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:2:{i:190;a:4:{s:3:\"nbr\";i:4;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:2;s:4:\"name\";s:12:\"Portrait 2:3\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}}s:4:\"name\";s:11:\"Orientation\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";i:0;}i:4;a:10:{s:9:\"type_lite\";s:18:\"id_attribute_group\";s:4:\"type\";s:18:\"id_attribute_group\";s:6:\"id_key\";i:13;s:4:\"name\";s:20:\"Choix des Dimensions\";s:14:\"is_color_group\";b:0;s:6:\"values\";a:11:{i:18;a:5:{s:4:\"name\";s:7:\"40x60cm\";s:3:\"nbr\";i:6;s:8:\"url_name\";N;s:10:\"meta_title\";N;s:7:\"checked\";b:1;}i:19;a:4:{s:4:\"name\";s:7:\"60x90cm\";s:3:\"nbr\";i:6;s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:20;a:4:{s:4:\"name\";s:8:\"80x120cm\";s:3:\"nbr\";i:5;s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:21;a:4:{s:4:\"name\";s:8:\"40x120cm\";s:3:\"nbr\";i:2;s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:22;a:4:{s:4:\"name\";s:27:\"60x180 (triptyque 3x 60x60)\";s:3:\"nbr\";i:2;s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:23;a:5:{s:4:\"name\";s:8:\"50x100cm\";s:3:\"nbr\";i:2;s:8:\"url_name\";N;s:10:\"meta_title\";N;s:7:\"checked\";b:1;}i:24;a:4:{s:4:\"name\";s:20:\"création sur mesure\";s:3:\"nbr\";i:1;s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:25;a:4:{s:4:\"name\";s:7:\"40x80cm\";s:3:\"nbr\";i:1;s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:26;a:4:{s:4:\"name\";s:7:\"80x80cm\";s:3:\"nbr\";i:1;s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:16;a:4:{s:4:\"name\";s:9:\"100x100cm\";s:3:\"nbr\";i:1;s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:15;a:4:{s:4:\"name\";s:7:\"60x60cm\";s:3:\"nbr\";i:1;s:8:\"url_name\";N;s:10:\"meta_title\";N;}}s:8:\"url_name\";N;s:10:\"meta_title\";N;s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";i:0;}i:5;a:9:{s:9:\"type_lite\";s:10:\"id_feature\";s:4:\"type\";s:10:\"id_feature\";s:6:\"id_key\";i:2;s:6:\"values\";a:7:{i:175;a:4:{s:3:\"nbr\";i:5;s:4:\"name\";s:4:\"2018\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:176;a:4:{s:3:\"nbr\";i:11;s:4:\"name\";s:4:\"2019\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:177;a:5:{s:3:\"nbr\";i:6;s:4:\"name\";s:4:\"2020\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:7:\"checked\";b:1;}i:178;a:4:{s:3:\"nbr\";i:12;s:4:\"name\";s:4:\"2021\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:179;a:4:{s:3:\"nbr\";i:7;s:4:\"name\";s:4:\"2022\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:180;a:4:{s:3:\"nbr\";i:2;s:4:\"name\";s:4:\"2023\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:174;a:4:{s:3:\"nbr\";i:2;s:4:\"name\";s:10:\"avant-2018\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}}s:4:\"name\";s:6:\"Année\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";i:0;}i:6;a:10:{s:9:\"type_lite\";s:18:\"id_attribute_group\";s:4:\"type\";s:18:\"id_attribute_group\";s:6:\"id_key\";i:11;s:4:\"name\";s:20:\"Choix de la commande\";s:14:\"is_color_group\";b:0;s:6:\"values\";a:2:{i:2;a:4:{s:4:\"name\";s:38:\"Tirage d\'expo N° 0/5 (numéroté 0/5)\";s:3:\"nbr\";i: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:20:{i:200;a:4:{s:3:\"nbr\";i:9;s:4:\"name\";s:16:\"Ambiance de Nuit\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:209;a:4:{s:3:\"nbr\";i:4;s:4:\"name\";s:17:\"Arbres Solitaires\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:202;a:4:{s:3:\"nbr\";i:2;s:4:\"name\";s:12:\"Architecture\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:205;a:5:{s:3:\"nbr\";i:3;s:4:\"name\";s:17:\"Astrophotographie\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:7:\"checked\";b:1;}i:210;a:4:{s:3:\"nbr\";i:5;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:8;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:6;s:4:\"name\";s:13:\"Dune du Pilat\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:214;a:4:{s:3:\"nbr\";i:10;s:4:\"name\";s:16:\"Emotions du Ciel\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:208;a:4:{s:3:\"nbr\";i:3;s:4:\"name\";s:6:\"Fleurs\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:211;a:4:{s:3:\"nbr\";i:12;s:4:\"name\";s:22:\"Histoires et Aventures\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:215;a:4:{s:3:\"nbr\";i:9;s:4:\"name\";s:14:\"Lacs et Océan\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:218;a:4:{s:3:\"nbr\";i:5;s:4:\"name\";s:8:\"Montagne\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:217;a:4:{s:3:\"nbr\";i:7;s:4:\"name\";s:10:\"Nature Zen\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:201;a:4:{s:3:\"nbr\";i:2;s:4:\"name\";s:13:\"Noir et Blanc\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:204;a:4:{s:3:\"nbr\";i:1;s:4:\"name\";s:13:\"Proxi & Macro\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:213;a:5:{s:3:\"nbr\";i:4;s:4:\"name\";s:16:\"Regards d\'Hommes\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:7:\"checked\";b:1;}i:220;a:4:{s:3:\"nbr\";i:3;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.364 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)
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.157 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)
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 (18, 23))) AND ((fp_1.id_feature_value=177)) AND ((fp_2.id_feature_value IN (205, 213))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND c.nleft>=31 AND c.nright<=36	1.088 ms	3375			/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:57 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:251 (getMinMaxPriceValue) /modules/ps_facetedsearch/src/Filters/Block.php:132 (getPriceRangeBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:218 (getFilterBlock) /classes/controller/ProductListingFrontController.php:355 (runQuery) /classes/controller/ProductListingFrontController.php:634 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:133 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
106	SELECT SQL_NO_CACHE pac.id_attribute, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, pa.id_product_attribute, cp.position FROM f1oa_product p LEFT JOIN f1oa_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN f1oa_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN f1oa_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN f1oa_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN f1oa_category_product cp ON (p.id_product = cp.id_product) INNER JOIN f1oa_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN f1oa_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN f1oa_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN f1oa_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((pac.id_attribute IN (18, 23))) AND ((fp_1.id_feature_value=177)) AND ((fp_2.id_feature_value IN (205, 213))) 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 (18, 23))) AND ((fp_2.id_feature_value=177)) AND ((fp_3.id_feature_value IN (205, 213))) GROUP BY pac.id_attribute	1.014 ms	506250	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)
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.938 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)
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 (18, 23))) AND ((fp_1.id_feature_value=177)) AND ((fp_2.id_feature_value IN (205, 213))) 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 (18, 23))) AND ((fp_2.id_feature_value=177)) AND ((fp_3.id_feature_value IN (205, 213))) GROUP BY fp.id_feature_value	0.869 ms	506250	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)
270	SELECT SQL_NO_CACHE c., cl. FROM `f1oa_category` c INNER JOIN f1oa_category_shop category_shop ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1) LEFT JOIN `f1oa_category_lang` cl ON c.`id_category` = cl.`id_category` AND cl.id_shop = 1 RIGHT JOIN `f1oa_category` c2 ON c2.`id_category` = 8 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright` WHERE 1 AND c.`level_depth` <= 10 AND `id_lang` = 2 AND c.`active` = 1 ORDER BY c.`level_depth` ASC, category_shop.`position` ASC	0.744 ms	16	Yes		/classes/Category.php:782 /modules/ps_categorytree/ps_categorytree.php:141 (getNestedCategories) /modules/ps_categorytree/ps_categorytree.php:298 (getCategories) /modules/ps_categorytree/ps_categorytree.php:266 (getWidgetVariables) /classes/Hook.php:1004 (renderWidget) /tools/profiling/Hook.php:64 (coreRenderWidget) /classes/Hook.php:948 (coreRenderWidget) /config/smarty.config.inc.php:205 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/6d/b0/10/6db010da081764cb9b7ddedbe0282abc1b67e8ac_2.file.layout-both-columns.tpl.php:257 (__call) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/6d/b0/10/6db010da081764cb9b7ddedbe0282abc1b67e8ac_2.file.layout-both-columns.tpl.php:90 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6a5f992fef2193_14207258) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php: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_6a5f992fee2da2_21029119) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php: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_6a5f992feddbd8_89207640) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php: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_6a5f992fecfcb7_22298152) /vendor/smarty/smarty/libs/sysplugins/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)
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.744 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)
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.708 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)
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.631 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)
278	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 (46) 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.610 ms	8	Yes		/classes/Product.php:4486 /src/Adapter/Product/ProductColorsRetriever.php:43 (getAttributesColorList) /src/Adapter/Presenter/Product/ProductLazyArray.php:527 (getColoredVariants) /src/Adapter/Presenter/AbstractLazyArray.php:261 (getMainVariants) /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/c3/8a/d8/c38ad8ef490d26e052942bf124027e01185e4fb4_2.file.product.tpl.php:316 (offsetGet) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/c3/8a/d8/c38ad8ef490d26e052942bf124027e01185e4fb4_2.file.product.tpl.php:40 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6a5f99304db622_10516231) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php: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_6a5f99304b7d99_96947767) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php: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_6a5f99304b2744_15128918) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php: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_6a5f992fef2193_14207258) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php: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_6a5f992fee2da2_21029119) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php: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_6a5f992feddbd8_89207640) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php: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_6a5f992fecfcb7_22298152) /vendor/smarty/smarty/libs/sysplugins/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)
269	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.585 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_6a5f992fef2193_14207258) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php: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_6a5f992fee2da2_21029119) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php: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_6a5f992feddbd8_89207640) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php: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_6a5f992fecfcb7_22298152) /vendor/smarty/smarty/libs/sysplugins/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)
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.570 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)
283	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 (109) 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.540 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_6a5f99304db622_10516231) /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_6a5f99304b7d99_96947767) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php: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_6a5f99304b2744_15128918) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php: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_6a5f992fef2193_14207258) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php: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_6a5f992fee2da2_21029119) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php: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_6a5f992feddbd8_89207640) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php: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_6a5f992fecfcb7_22298152) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/Smarty/SmartyDev.php:40 (fetch) /classes/controller/FrontController.php:715 (fetch) /classes/controller/FrontController.php:697 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
105	SELECT SQL_NO_CACHE DISTINCT a.`id_attribute`, a.`color`, al.`name`, agl.`id_attribute_group`, IF(lialv.`url_name` IS NULL OR lialv.`url_name` = "", NULL, lialv.`url_name`) AS url_name, IF(lialv.`meta_title` IS NULL OR lialv.`meta_title` = "", NULL, lialv.`meta_title`) AS meta_title FROM `f1oa_attribute_group` ag INNER JOIN `f1oa_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 2) INNER JOIN `f1oa_attribute` a ON a.`id_attribute_group` = ag.`id_attribute_group` INNER JOIN `f1oa_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 2) INNER JOIN f1oa_attribute_group_shop attribute_group_shop ON (attribute_group_shop.id_attribute_group = ag.id_attribute_group AND attribute_group_shop.id_shop = 1) INNER JOIN f1oa_attribute_shop attribute_shop ON (attribute_shop.id_attribute = a.id_attribute AND attribute_shop.id_shop = 1) LEFT JOIN `f1oa_layered_indexable_attribute_lang_value` lialv ON (a.`id_attribute` = lialv.`id_attribute` AND lialv.`id_lang` = 2) WHERE ag.id_attribute_group = 14 ORDER BY agl.`name` ASC, a.`position` ASC	0.511 ms	20	Yes		/modules/ps_facetedsearch/src/Filters/DataAccessor.php:77 /modules/ps_facetedsearch/src/Filters/Block.php:732 (getAttributes) /modules/ps_facetedsearch/src/Filters/Block.php:151 (getAttributesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:218 (getFilterBlock) /classes/controller/ProductListingFrontController.php:355 (runQuery) /classes/controller/ProductListingFrontController.php:634 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:133 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
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 (54) 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.499 ms	8	Yes		/classes/Product.php:4486 /src/Adapter/Product/ProductColorsRetriever.php:43 (getAttributesColorList) /src/Adapter/Presenter/Product/ProductLazyArray.php:527 (getColoredVariants) /src/Adapter/Presenter/AbstractLazyArray.php:261 (getMainVariants) /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/c3/8a/d8/c38ad8ef490d26e052942bf124027e01185e4fb4_2.file.product.tpl.php:316 (offsetGet) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/c3/8a/d8/c38ad8ef490d26e052942bf124027e01185e4fb4_2.file.product.tpl.php:40 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6a5f99304db622_10516231) /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_6a5f99304b7d99_96947767) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php: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_6a5f99304b2744_15128918) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php: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_6a5f992fef2193_14207258) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php: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_6a5f992fee2da2_21029119) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php: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_6a5f992feddbd8_89207640) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php: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_6a5f992fecfcb7_22298152) /vendor/smarty/smarty/libs/sysplugins/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)
285	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 (428) 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.497 ms	11	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_6a5f99304db622_10516231) /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_6a5f99304b7d99_96947767) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php: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_6a5f99304b2744_15128918) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php: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_6a5f992fef2193_14207258) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php: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_6a5f992fee2da2_21029119) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php: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_6a5f992feddbd8_89207640) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php: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_6a5f992fecfcb7_22298152) /vendor/smarty/smarty/libs/sysplugins/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)
284	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 (400) 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.497 ms	6	Yes		/classes/Product.php:4486 /src/Adapter/Product/ProductColorsRetriever.php:43 (getAttributesColorList) /src/Adapter/Presenter/Product/ProductLazyArray.php:527 (getColoredVariants) /src/Adapter/Presenter/AbstractLazyArray.php:261 (getMainVariants) /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/c3/8a/d8/c38ad8ef490d26e052942bf124027e01185e4fb4_2.file.product.tpl.php:316 (offsetGet) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/c3/8a/d8/c38ad8ef490d26e052942bf124027e01185e4fb4_2.file.product.tpl.php:40 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6a5f99304db622_10516231) /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_6a5f99304b7d99_96947767) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php: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_6a5f99304b2744_15128918) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php: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_6a5f992fef2193_14207258) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php: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_6a5f992fee2da2_21029119) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php: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_6a5f992feddbd8_89207640) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php: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_6a5f992fecfcb7_22298152) /vendor/smarty/smarty/libs/sysplugins/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)
109	SELECT SQL_NO_CACHE p., ps., pl.*, sa.out_of_stock, IFNULL(sa.quantity, 0) as quantity, (DATEDIFF( p.`date_add`, DATE_SUB( '2026-07-21 00:00:00', INTERVAL 20000 DAY ) ) > 0) as new FROM f1oa_product p LEFT JOIN f1oa_product_lang pl ON pl.id_product = p.id_product AND pl.id_shop = 1 AND pl.id_lang = 2 LEFT JOIN f1oa_stock_available sa ON sa.id_product = p.id_product AND sa.id_product_attribute = 0 AND sa.id_shop = 1 LEFT JOIN f1oa_product_shop ps ON ps.id_product = p.id_product AND ps.id_shop = 1 WHERE p.id_product IN (46,54,105,109,400,428)	0.487 ms	6			/classes/ProductAssembler.php:95 /classes/ProductAssembler.php:203 (addMissingProductFieldsForMultipleProducts) /classes/controller/ProductListingFrontController.php:108 (assembleProducts) /classes/controller/ProductListingFrontController.php:377 (prepareMultipleProductsForTemplate) /classes/controller/ProductListingFrontController.php:634 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:133 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
282	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 (105) AND ag.`is_color_group` = 1 GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` HAVING qty > 0 ORDER BY a.`position` ASC;	0.480 ms	8	Yes		/classes/Product.php:4486 /src/Adapter/Product/ProductColorsRetriever.php:43 (getAttributesColorList) /src/Adapter/Presenter/Product/ProductLazyArray.php:527 (getColoredVariants) /src/Adapter/Presenter/AbstractLazyArray.php:261 (getMainVariants) /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/c3/8a/d8/c38ad8ef490d26e052942bf124027e01185e4fb4_2.file.product.tpl.php:316 (offsetGet) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/c3/8a/d8/c38ad8ef490d26e052942bf124027e01185e4fb4_2.file.product.tpl.php:40 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6a5f99304db622_10516231) /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_6a5f99304b7d99_96947767) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php: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_6a5f99304b2744_15128918) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php: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_6a5f992fef2193_14207258) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php: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_6a5f992fee2da2_21029119) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php: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_6a5f992feddbd8_89207640) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php: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_6a5f992fecfcb7_22298152) /vendor/smarty/smarty/libs/sysplugins/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)
296	SELECT SQL_NO_CACHE cp.`id_category`, cp.`id_product`, cl.`name` FROM `f1oa_category_product` cp LEFT JOIN `f1oa_category` c ON (c.id_category = cp.id_category) LEFT JOIN `f1oa_category_lang` cl ON (cp.`id_category` = cl.`id_category` AND cl.id_shop = 1 ) INNER JOIN f1oa_category_shop category_shop ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1) WHERE cp.`id_product` IN (46,54,105,109,400,428) AND cl.`id_lang` = 2 ORDER BY c.`level_depth` DESC	0.464 ms	53	Yes		/modules/ps_googleanalytics/classes/Wrapper/ProductWrapper.php:103 /modules/ps_googleanalytics/classes/Wrapper/ProductWrapper.php:68 (loadCategories) /modules/ps_googleanalytics/classes/Hook/HookDisplayBeforeBodyClosingTag.php:81 (prepareItemListFromProductList) /modules/ps_googleanalytics/classes/Hook/HookDisplayBeforeBodyClosingTag.php:57 (renderProductListing) /modules/ps_googleanalytics/ps_googleanalytics.php:109 (run) /classes/Hook.php:993 (hookDisplayBeforeBodyClosingTag) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:418 (coreCallHook) /classes/Hook.php:928 (callHookOn) /config/smarty.config.inc.php:205 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/6d/b0/10/6db010da081764cb9b7ddedbe0282abc1b67e8ac_2.file.layout-both-columns.tpl.php:385 (__call) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/6d/b0/10/6db010da081764cb9b7ddedbe0282abc1b67e8ac_2.file.layout-both-columns.tpl.php:126 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6a5f992fef2193_14207258) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php: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_6a5f992fee2da2_21029119) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php: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_6a5f992feddbd8_89207640) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php: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_6a5f992fecfcb7_22298152) /vendor/smarty/smarty/libs/sysplugins/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)
103	SELECT SQL_NO_CACHE m.*, ml.`description`, ml.`short_description` FROM `f1oa_manufacturer` m INNER JOIN f1oa_manufacturer_shop manufacturer_shop ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 1)INNER JOIN `f1oa_manufacturer_lang` ml ON (m.`id_manufacturer` = ml.`id_manufacturer` AND ml.`id_lang` = 2)WHERE 1 AND m.`active` = 1 ORDER BY m.`name` ASC	0.449 ms	1	Yes		/classes/Manufacturer.php:201 /modules/ps_facetedsearch/src/Filters/Block.php:653 (getManufacturers) /modules/ps_facetedsearch/src/Filters/Block.php:147 (getManufacturersBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:218 (getFilterBlock) /classes/controller/ProductListingFrontController.php:355 (runQuery) /classes/controller/ProductListingFrontController.php:634 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:133 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
90	SELECT SQL_NO_CACHE c.`id_category`, cl.`name` FROM `f1oa_category` c INNER JOIN f1oa_category_shop category_shop ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1) LEFT JOIN `f1oa_category_lang` cl ON c.`id_category` = cl.`id_category` AND cl.id_shop = 1 WHERE 1 AND `id_lang` = 2 AND c.`active` = 1 ORDER BY c.nleft, c.position	0.447 ms	66	Yes		/classes/Category.php:707 /modules/ps_facetedsearch/src/Filters/Block.php:980 (getAllCategoriesName) /modules/ps_facetedsearch/src/Filters/Block.php:159 (getCategoriesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:218 (getFilterBlock) /classes/controller/ProductListingFrontController.php:355 (runQuery) /classes/controller/ProductListingFrontController.php:634 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:133 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
78	SELECT SQL_NO_CACHE DISTINCT f.id_feature, f., fl., IF(liflv.`url_name` IS NULL OR liflv.`url_name` = "", NULL, liflv.`url_name`) AS url_name, IF(liflv.`meta_title` IS NULL OR liflv.`meta_title` = "", NULL, liflv.`meta_title`) AS meta_title, lif.indexable FROM `f1oa_feature` f INNER JOIN f1oa_feature_shop feature_shop ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1) LEFT JOIN `f1oa_feature_lang` fl ON (f.`id_feature` = fl.`id_feature` AND fl.`id_lang` = 2) LEFT JOIN `f1oa_layered_indexable_feature` lif ON (f.`id_feature` = lif.`id_feature`) LEFT JOIN `f1oa_layered_indexable_feature_lang_value` liflv ON (f.`id_feature` = liflv.`id_feature` AND liflv.`id_lang` = 2) ORDER BY f.`position` ASC	0.429 ms	289	Yes		/modules/ps_facetedsearch/src/Filters/DataAccessor.php:159 /modules/ps_facetedsearch/src/Filters/Converter.php:388 (getFeatures) /modules/ps_facetedsearch/src/Product/SearchProvider.php:166 (createFacetedSearchFiltersFromQuery) /classes/controller/ProductListingFrontController.php:355 (runQuery) /classes/controller/ProductListingFrontController.php:634 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:133 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
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.427 ms	172	Yes		/classes/Dispatcher.php:633 /classes/Dispatcher.php:243 (loadRoutes) /classes/Dispatcher.php:201 (__construct) /index.php:28 (getInstance)
12	SELECT SQL_NO_CACHE lower(name) as name FROM `f1oa_hook` h WHERE (h.active = 1)	0.425 ms	1025			/classes/Hook.php:1282 /classes/Hook.php:774 (getHookStatusByName) /classes/Dispatcher.php:586 (exec) /classes/Dispatcher.php:243 (loadRoutes) /classes/Dispatcher.php:201 (__construct) /index.php:28 (getInstance)
97	SELECT SQL_NO_CACHE DISTINCT a.`id_attribute`, a.`color`, al.`name`, agl.`id_attribute_group`, IF(lialv.`url_name` IS NULL OR lialv.`url_name` = "", NULL, lialv.`url_name`) AS url_name, IF(lialv.`meta_title` IS NULL OR lialv.`meta_title` = "", NULL, lialv.`meta_title`) AS meta_title FROM `f1oa_attribute_group` ag INNER JOIN `f1oa_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 2) INNER JOIN `f1oa_attribute` a ON a.`id_attribute_group` = ag.`id_attribute_group` INNER JOIN `f1oa_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 2) INNER JOIN f1oa_attribute_group_shop attribute_group_shop ON (attribute_group_shop.id_attribute_group = ag.id_attribute_group AND attribute_group_shop.id_shop = 1) INNER JOIN f1oa_attribute_shop attribute_shop ON (attribute_shop.id_attribute = a.id_attribute AND attribute_shop.id_shop = 1) LEFT JOIN `f1oa_layered_indexable_attribute_lang_value` lialv ON (a.`id_attribute` = lialv.`id_attribute` AND lialv.`id_lang` = 2) WHERE ag.id_attribute_group = 11 ORDER BY agl.`name` ASC, a.`position` ASC	0.398 ms	12	Yes		/modules/ps_facetedsearch/src/Filters/DataAccessor.php:77 /modules/ps_facetedsearch/src/Filters/Block.php:732 (getAttributes) /modules/ps_facetedsearch/src/Filters/Block.php:151 (getAttributesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:218 (getFilterBlock) /classes/controller/ProductListingFrontController.php:355 (runQuery) /classes/controller/ProductListingFrontController.php:634 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:133 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
275	SELECT SQL_NO_CACHE c., cl. FROM `f1oa_category` c LEFT JOIN `f1oa_category_lang` cl ON (c.`id_category` = cl.`id_category` AND `id_lang` = 2 AND cl.id_shop = 1 ) WHERE c.`nleft` <= 31 AND c.`nright` >= 36 AND c.`nleft` >= 2 AND c.`nright` <= 131 ORDER BY `nleft` DESC	0.397 ms	66	Yes		/classes/Category.php:1591 /modules/ps_categorytree/ps_categorytree.php:364 (getParentsCategories) /modules/ps_categorytree/ps_categorytree.php:147 (getIdsOfCategoriesInPathToCurrentCategory) /modules/ps_categorytree/ps_categorytree.php:298 (getCategories) /modules/ps_categorytree/ps_categorytree.php:266 (getWidgetVariables) /classes/Hook.php:1004 (renderWidget) /tools/profiling/Hook.php:64 (coreRenderWidget) /classes/Hook.php:948 (coreRenderWidget) /config/smarty.config.inc.php:205 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/6d/b0/10/6db010da081764cb9b7ddedbe0282abc1b67e8ac_2.file.layout-both-columns.tpl.php:257 (__call) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/6d/b0/10/6db010da081764cb9b7ddedbe0282abc1b67e8ac_2.file.layout-both-columns.tpl.php:90 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6a5f992fef2193_14207258) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php: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_6a5f992fee2da2_21029119) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php: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_6a5f992feddbd8_89207640) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php: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_6a5f992fecfcb7_22298152) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/Smarty/SmartyDev.php:40 (fetch) /classes/controller/FrontController.php:715 (fetch) /classes/controller/FrontController.php:697 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
79	SELECT SQL_NO_CACHE ag.id_attribute_group, agl.public_name as attribute_group_name, is_color_group, IF(liaglv.`url_name` IS NULL OR liaglv.`url_name` = "", NULL, liaglv.`url_name`) AS url_name, IF(liaglv.`meta_title` IS NULL OR liaglv.`meta_title` = "", NULL, liaglv.`meta_title`) AS meta_title, IFNULL(liag.indexable, TRUE) AS indexable FROM `f1oa_attribute_group` ag INNER JOIN f1oa_attribute_group_shop attribute_group_shop ON (attribute_group_shop.id_attribute_group = ag.id_attribute_group AND attribute_group_shop.id_shop = 1) LEFT JOIN `f1oa_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 2) LEFT JOIN `f1oa_layered_indexable_attribute_group` liag ON (ag.`id_attribute_group` = liag.`id_attribute_group`) LEFT JOIN `f1oa_layered_indexable_attribute_group_lang_value` AS liaglv ON (ag.`id_attribute_group` = liaglv.`id_attribute_group` AND agl.`id_lang` = 2) GROUP BY ag.id_attribute_group ORDER BY ag.`position` ASC	0.395 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)
100	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.370 ms	22	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)

#	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