Filtrer par

Prix

Prix

  • 4,00 € - 42,00 €

Rusticité

Rusticité

Couleur de fleur

Couleur de fleur

Exposition

Exposition

Floraison

Floraison

1

Type de feuillage

Type de feuillage

Offrir une carte cadeau

  

Cartes cadeaux   

Plantes pour entrée de maison

Pittosporum, lavande, helichrysum : ils ont tout pour accueillir !

Décorez votre entrée

Pour soigner votre entrée de maison, optez pour des plantations adaptées aux petits espaces ou des cultures en pot. Selon l’exposition, il est possible de réaliser un aménagement de goût, épuré, et parfumé qui rendra votre entrée de maison accueillante. Soyez original dans votre composition, vous saurez épater et susciter l’intérêt de vos visiteurs.

Il y a 101 produits.

Trier par :
Ventes, ordre décroissant Pertinence Nom, A à Z Nom, Z à A Prix, croissant Prix, décroissant
Affichage 1-30 de 101 article(s)

Filtres actifs

Retour en haut

Au fil des saisons…

Pourquoi ne pas composer avec les saisons et choisir des plantes en pot qui vivent au rythme du temps ? Toute l’année vous verrez votre entrée égayée grâce à des variétés qui s’épanouissent au printemps, en été, en automne et même en hiver. A l’époque de Noël, vous pouvez par exemple marier 3 plantes et les accessoiriser pour plus d’authenticité. L’ambiance de Noël sera ainsi bien présente avec le Nandina ‘Blush Pink’, qui imposera sa couleur en hiver. Cette plante persistante apportera de la couleur à votre espace.

Associez à cette simplicité, l’Erica ‘Eva Gold’ qui regorge d’originalité avec sa multitude de superbes clochettes rouges. Son feuillage jaune vert très lumineux tout l'été prend de jolies teintes vert bronze l'hiver. Cette magnifique touche dorée sera d’occasion pour les fêtes. A travers ces deux superbes plantes, viendra se faire une place évidente : le Camélia ‘Yuletide’. Ses feuilles très brillantes vert foncé, seront un merveilleux contraste avec ses petites fleurs très lumineuses rouge vermillon aux étamines d'or ! Ce trio interpelle déjà, séduit et saura se mettre aux couleurs de Noël avec en plus une touche personnalisée à l’aide d’ardoises en forme d’étoiles, de sapin ou de boules de Noël.

Faites évoluer en toute simplicité, votre entrée de maison, selon les saisons et les évènements. C’est à coup sûr un plaisir pour les yeux et une marque d’originalité.

Selon l’exposition…

Votre entrée est exposée au sud ? Alors optez pour l’incontournable et parfumée Lavande. Elle rappelle le doux climat du sud et s’installe idéalement en bord d’allée pour un jardin parfumé. Selon vos envies, 6 variétés vous sont proposées chez Roué : la lavande papillon est par exemple très résistante au froid et à l’humidité. Une nombreuse remontée de fleurs en septembre en fait sa particularité. La Lavande Havanna et son parfum caractéristique, la Lavande Melissa Lilac avec ses fleurs aspect velours…

Pour une odeur plutôt aromatique et une invitation au voyage, l’Helichrysum sera parfait. En plus d’un feuillage argenté qui dégage un parfum de curry dès qu’on le touche, sa floraison est assez atypique avec ses fleurs jaunes en forme de petites boules. L’Helichrysum adore le soleil !
Pour profiter de tous ces parfums et éveiller les sens, ces plantes sont à disposer près d’un passage.

Si votre entrée est orientée plutôt Nord, associez le Pittosporum ‘Golf Ball’ à des Fougères et des Hostas, vous jouerez avec différents types de feuillages. Et oui, le Pittosporum ‘Golf Ball’ est une variété très compacte que l’on peut tailler en boule comme un buis. Son feuillage vert olive, tendre est très décoratif. Mais c’est sans compter sur la particularité des feuilles de l'Hosta, que votre composition prendra tout son sens.

A proximité d’un Pittosporum, l'Hostas sera irrésistible avec ses feuilles ovales ou en formes de coeur. Les nombreux verts de son feuillage si généreux sauront vous ravir. Proche du jaune ou bien du bleu, ou encore vert intense brillant ou tout simplement un panaché… tout ceci donne une explosion de couleurs qui éclairent joliment les coins d’ombre. Petites ou grandes feuilles, elles sont toujours pleines de lumière même en automne ! Cette vivace, qui disparait en hiver, renaît en avril pour offrir des fleurs en clochettes mauve clair.

Quoiqu'on en dise, la première impression est toujours importante. Alors, prenez soin de votre entrée de maison avec nos plantes produites en bretagne. Pensez que votre entrée extérieure fait partie intégrante de votre maison, alors personnalisez-la autant que vous le souhaitez !

Load Time 1936 ms
Querying Time 1325 ms
Queries 2481
Memory Peak Usage 104.9 Mb
Included Files 1151 files - 14.22 Mb
PrestaShop Cache - Mb
Global vars 1.10 Mb
PrestaShop Version 1.7.8.8
PHP Version 7.4.30
MySQL Version 10.3.35-MariaDB-1:10.3.35+maria~stretch
Memory Limit 256M
Max Execution Time 60s
Smarty Cache enabled
Smarty Compilation auto
  Time Cumulated Time Memory Usage Memory Peak Usage
config 42 ms 42 ms 7.23 Mb 7.3 Mb
__construct 0 ms 42 ms - Mb 7.3 Mb
init 28 ms 69 ms 2.20 Mb 9.7 Mb
checkAccess 0 ms 69 ms - Mb 9.7 Mb
setMedia 13 ms 82 ms 0.68 Mb 10.1 Mb
postProcess 0 ms 82 ms - Mb 10.1 Mb
initHeader 0 ms 82 ms - Mb 10.1 Mb
initContent 541 ms 623 ms 18.47 Mb 28.7 Mb
initFooter 0 ms 623 ms - Mb 28.7 Mb
display 1313 ms 1936 ms 75.31 Mb 104.9 Mb
Hook Time Memory Usage
DisplayNavFullWidth 1118 ms 60.75 Mb
DisplayBlock 1049 ms 57.53 Mb
DisplayAfterTitle 58 ms 5.04 Mb
DisplayProductPriceBlock 34 ms 3.41 Mb
ActionGetProductPropertiesAfter 34 ms 1.47 Mb
DisplayHeader 12 ms 1.58 Mb
displayLeftColumn 5 ms 0.19 Mb
ActionObjectUpdateAfter 5 ms 0.05 Mb
Header 4 ms 0.24 Mb
DisplayBeforeBodyClosingTag 3 ms 0.18 Mb
displayTop 2 ms 0.09 Mb
DisplayFooter 2 ms 0.17 Mb
displayFooter 2 ms 0.17 Mb
ActionFrontControllerSetMedia 2 ms 0.01 Mb
ActionDispatcher 1 ms 0.10 Mb
ProductSearchProvider 1 ms 0.07 Mb
DisplayLeftColumn 1 ms 0.07 Mb
ActionObjectAddAfter 0 ms - Mb
DisplayCustomMenu 0 ms 0.03 Mb
DisplayBanner 0 ms 0.03 Mb
DisplayProductListReviews 0 ms 0.03 Mb
DisplayAfterBodyOpeningTag 0 ms 0.01 Mb
DisplayTop 0 ms - Mb
DisplayFooterBefore 0 ms - Mb
DisplayFooterAfter 0 ms - Mb
ModuleRoutes 0 ms - Mb
26 hook(s) 2334 ms 131.23 Mb
Module Time Memory Usage
ps_hubspot 1 ms 0.21 Mb
kiliba 6 ms 0.18 Mb
geodisofficiel 57 ms 3.43 Mb
smplredirectionsmanager 2 ms 0.28 Mb
blockwishlist 3 ms 0.15 Mb
ps_emailsubscription 6 ms 0.13 Mb
ps_facebook 7 ms 0.38 Mb
blockreassurance 0 ms 0.10 Mb
ps_emailalerts 0 ms 0.04 Mb
paybox 2 ms 0.24 Mb
ps_imageslider 0 ms 0.03 Mb
ps_searchbar 0 ms 0.03 Mb
ps_shoppingcart 1 ms 0.08 Mb
ps_accounts 0 ms - Mb
psxmarketingwithgoogle 1 ms 0.10 Mb
ets_megamenu 2175 ms 119.77 Mb
ps_customersignin 0 ms 0.04 Mb
doofinder 1 ms 0.11 Mb
ultimateimagetool 0 ms 0.02 Mb
steavisgarantis 35 ms 3.60 Mb
storeggmap 0 ms 0.03 Mb
paypal 2 ms 0.33 Mb
pm_applepay 1 ms 0.04 Mb
chronopost 0 ms 0.05 Mb
giftcard 1 ms 0.46 Mb
lapostetracking 0 ms 0.01 Mb
pabanniere 1 ms 0.08 Mb
paquisommesnous 1 ms 0.04 Mb
pajardinhome 0 ms 0.04 Mb
pamultiblock 0 ms 0.04 Mb
panewsletter 0 ms 0.04 Mb
paconfiance 0 ms 0.04 Mb
pasliderpro 0 ms 0.04 Mb
pasliderproj 0 ms 0.04 Mb
deliverydate 0 ms 0.03 Mb
cdc_googletagmanager 59 ms 5.21 Mb
pasliderpro3 0 ms 0.04 Mb
pasliderpro4 0 ms 0.04 Mb
ps_facetedsearch 1 ms 0.16 Mb
pm_multiplefeatures 34 ms 1.50 Mb
iziflux 0 ms 0.02 Mb
ps_categorytree 6 ms 0.26 Mb
ps_linklist 1 ms 0.13 Mb
ps_customeraccountlinks 1 ms 0.08 Mb
statsdata 4 ms 0.19 Mb
45 module(s) 2413 ms 137.87 Mb
  1. Stopwatch SQL
  2. Doubles
  3. Tables stress
  4. ObjectModel instances
  5. Included Files

Stopwatch SQL - 2481 queries

Query Time (ms) Rows Filesort Group By Location 
SELECT SQL_NO_CACHE p.id_product, sa.out_of_stock FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, cp.position FROM ps_product p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_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 ps_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='1' AND p.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=452 AND c.nright<=453 GROUP BY p.id_product) p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_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 ) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) GROUP BY p.id_product ORDER BY IFNULL(p.quantity, 0) <= 0, IFNULL(p.quantity, 0) <= 0 AND FIELD(sa.out_of_stock, 1) DESC, p.position ASC, p.id_product DESC LIMIT 0, 30
 34926 ms 52356230010 Yes /modules/ps_facetedsearch/src/Adapter/MySQL.php:86 
SELECT SQL_NO_CACHE p.*,
ps.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2023-12-11 00:00:00',
INTERVAL 30 DAY
)
) > 0) as new
FROM ps_product p
LEFT JOIN ps_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 1
LEFT JOIN ps_stock_available sa   ON sa.id_product = p.id_product
AND sa.id_shop = 1 LEFT JOIN ps_product_shop ps
ON ps.id_product = p.id_product
AND ps.id_shop = 1
WHERE p.id_product = 1258
LIMIT 1
 16946 ms 3 /classes/ProductAssembler.php:106 
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, cp.position FROM ps_product p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_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 ps_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='1' AND p.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=452 AND c.nright<=453 GROUP BY p.id_product) p INNER JOIN ps_feature_product fp ON (p.id_product = fp.id_product) WHERE ((fp.id_feature=8)) GROUP BY fp.id_feature_value
 15047 ms 3383969400 Yes /modules/ps_facetedsearch/src/Adapter/MySQL.php:86 
SELECT SQL_NO_CACHE c.*, cl.name,cl.link_rewrite
FROM `ps_category` c
INNER JOIN `ps_category_shop` cs ON (c.id_category=cs.id_category AND cs.id_shop=1)
LEFT JOIN `ps_category_lang` cl ON c.id_category=cl.id_category AND cl.id_lang=1
LEFT JOIN `ps_category_group` cg ON c.`id_category` = cg.`id_category` 
WHERE c.active=1 
AND  c.id_category IN(2695,2696,2697,2698,2699,2700)
AND cg.`id_group` IN (1)
GROUP BY c.id_category ORDER BY c.position ASC,c.id_category ASC
 14009 ms 23814 Yes Yes /modules/ets_megamenu/classes/Ets_megamenu_defines.php:178 
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, cp.position FROM ps_product p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_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 ps_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='1' AND p.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=452 AND c.nright<=453 GROUP BY p.id_product) p INNER JOIN ps_feature_product fp ON (p.id_product = fp.id_product) WHERE ((fp.id_feature=12)) GROUP BY fp.id_feature_value
 13772 ms 4358319210 Yes /modules/ps_facetedsearch/src/Adapter/MySQL.php:86 
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 2684) AND (b.`id_shop` = 1) LIMIT 1
 13194 ms 1 /src/Adapter/EntityMapper.php:76 
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, cp.position FROM ps_product p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_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 ps_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='1' AND p.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=452 AND c.nright<=453 GROUP BY p.id_product) p INNER JOIN ps_feature_product fp ON (p.id_product = fp.id_product) WHERE ((fp.id_feature=15)) GROUP BY fp.id_feature_value
 12430 ms 9969096060 Yes /modules/ps_facetedsearch/src/Adapter/MySQL.php:86 
SELECT SQL_NO_CACHE pai.`id_image`, pai.`id_product_attribute`, il.`legend`
FROM `ps_product_attribute_image` pai
LEFT JOIN `ps_image_lang` il ON (il.`id_image` = pai.`id_image`)
LEFT JOIN `ps_image` i ON (i.`id_image` = pai.`id_image`)
WHERE pai.`id_product_attribute` IN (7927) AND il.`id_lang` = 1 ORDER by i.`position`
 12153 ms 1 Yes /classes/Product.php:2898 
SELECT SQL_NO_CACHE c.*, cl.name,cl.link_rewrite
FROM `ps_category` c
INNER JOIN `ps_category_shop` cs ON (c.id_category=cs.id_category AND cs.id_shop=1)
LEFT JOIN `ps_category_lang` cl ON c.id_category=cl.id_category AND cl.id_lang=1
LEFT JOIN `ps_category_group` cg ON c.`id_category` = cg.`id_category` 
WHERE c.active=1 
AND  c.id_category IN(2326,2305,2307,2308,2336,2337,2379,2311,2328,2706,2707,2708,2838,2339)
AND cg.`id_group` IN (1)
GROUP BY c.id_category ORDER BY c.position ASC,c.id_category ASC
 10859 ms 55566 Yes Yes /modules/ets_megamenu/classes/Ets_megamenu_defines.php:178 
SELECT SQL_NO_CACHE c.*, cl.name,cl.link_rewrite
FROM `ps_category` c
INNER JOIN `ps_category_shop` cs ON (c.id_category=cs.id_category AND cs.id_shop=1)
LEFT JOIN `ps_category_lang` cl ON c.id_category=cl.id_category AND cl.id_lang=1
LEFT JOIN `ps_category_group` cg ON c.`id_category` = cg.`id_category` 
WHERE c.active=1 
AND  c.id_category IN(2316,2312,2340,2324,2313,2314,2315,2325,2317,2770,2771,2772,2769)
AND cg.`id_group` IN (1)
GROUP BY c.id_category ORDER BY c.position ASC,c.id_category ASC
 10309 ms 51597 Yes Yes /modules/ets_megamenu/classes/Ets_megamenu_defines.php:178 
SELECT SQL_NO_CACHE 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, cp.position FROM ps_product p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_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 ps_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='1' AND p.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=452 AND c.nright<=453 GROUP BY p.id_product) p
 10147 ms 37822859361 /modules/ps_facetedsearch/src/Adapter/MySQL.php:86 
SELECT SQL_NO_CACHE b.*,bl.title,bl.title_link,bl.content,bl.image_link
FROM `ps_ets_mm_block` b
LEFT JOIN `ps_ets_mm_block_lang` bl
ON b.id_block=bl.id_block AND bl.id_lang=1
WHERE 1  AND b.id_column=27 
ORDER BY b.sort_order asc,bl.title asc
 9589 ms 2 Yes /modules/ets_megamenu/classes/MM_Block.php:617 
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, cp.position FROM ps_product p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_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 ps_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='1' AND p.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=452 AND c.nright<=453 GROUP BY p.id_product) p INNER JOIN ps_feature_product fp ON (p.id_product = fp.id_product) WHERE ((fp.id_feature=13)) GROUP BY fp.id_feature_value
 9581 ms 3430644840 Yes /modules/ps_facetedsearch/src/Adapter/MySQL.php:86 
SELECT SQL_NO_CACHE c.*, cl.name,cl.link_rewrite
FROM `ps_category` c
INNER JOIN `ps_category_shop` cs ON (c.id_category=cs.id_category AND cs.id_shop=1)
LEFT JOIN `ps_category_lang` cl ON c.id_category=cl.id_category AND cl.id_lang=1
LEFT JOIN `ps_category_group` cg ON c.`id_category` = cg.`id_category` 
WHERE c.active=1 
AND  c.id_category IN(2725,2726,2727,2728,2729,2730,2731,2732)
AND cg.`id_group` IN (1)
GROUP BY c.id_category ORDER BY c.position ASC,c.id_category ASC
 9499 ms 31752 Yes Yes /modules/ets_megamenu/classes/Ets_megamenu_defines.php:178 
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, cp.position FROM ps_product p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_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 ps_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='1' AND p.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=452 AND c.nright<=453 GROUP BY p.id_product) p INNER JOIN ps_feature_product fp ON (p.id_product = fp.id_product) WHERE ((fp.id_feature=18)) GROUP BY fp.id_feature_value
 9470 ms 3327569910 Yes /modules/ps_facetedsearch/src/Adapter/MySQL.php:86 
SELECT SQL_NO_CACHE c.*, cl.name,cl.link_rewrite
FROM `ps_category` c
INNER JOIN `ps_category_shop` cs ON (c.id_category=cs.id_category AND cs.id_shop=1)
LEFT JOIN `ps_category_lang` cl ON c.id_category=cl.id_category AND cl.id_lang=1
LEFT JOIN `ps_category_group` cg ON c.`id_category` = cg.`id_category` 
WHERE c.active=1 
AND  c.id_category IN(2806,2807,2808,2809,2810,2811,2812,2813,2816,2817,2818)
AND cg.`id_group` IN (1)
GROUP BY c.id_category ORDER BY c.position ASC,c.id_category ASC
 9031 ms 43659 Yes Yes /modules/ets_megamenu/classes/Ets_megamenu_defines.php:178