Filtrer par

Prix

Prix

  • 0,00 € - 645,00 €

Rusticité

Rusticité

Couleur de fleur

Couleur de fleur

Exposition

Exposition

Floraison

Floraison

1

Type de feuillage

Type de feuillage

Offrir une carte cadeau

  

Plante jardin japonais

La recherche du bien-être passe par des choses simples, l’aménagement de vos extérieurs par exemple. Ainsi, c’est à travers la demande de plantes pour jardin japonais de type « jardin zen » que la tendance des jardins japonais devient de plus en plus évidente.

Il y a 238 produits.

Affichage 1-30 de 238 article(s)

Filtres actifs

Quelles plantes pour un jardin japonais ?

Dans cette vidéo : découvrez nos Camélias, spécialité des pépinières Roué ! Ils sont disponibles en plusieurs litrages : 4 - 5 - 7.5 - 10 - 15 - 25 - 65 pour répondre à toutes vos envies. En Ophiopogon, nous avons 2 très belles variétés en 2L. Nous disposons d'une grande collection d'Azalées japonaises disponibles en 3 - 5 - 7.5 litres. Il y en a pour tous les goûts : floraison blanche, rose, rouge, violette.. Et même au feuillage panaché. Enfin, découvrez dans cette vidéo notre collection de Nandina en 3 et 5 litres. 

Pour répondre à cette envie commune de profiter d'une ambiance japonisante, nous mettons à votre disposition, via notre catalogue, tout un panel de plantes pour que vous aussi, vous puissiez profiter des bienfaits de nos plantes d’extérieur pour jardin japonais.

 

L’aménagement d’un petit jardin japonais, la nouvelle tendance

Les jardins japonais, communément appelé « jardin zen », proviennent d’un savoir faire venu tout droit du Japon. Car oui, l’Empire du soleil levant voit le jardinage comme une discipline artistique, un art important et respecté. Le principe repose essentiellement sur l’harmonisation des énergies environnementales, des forces censées favoriser la santé et votre bien-être en général. Les japonais appellent ça le « Feng Shui ».

Ainsi, les plantes pour jardin japonais d’extérieur doivent répondre à un besoin minimaliste conditionné par une volonté de mettre en avant les formes. Les plantes pour jardin zen servent à mettre en valeur, ou au contraire à dissimuler certaines parcelles de votre parterre, le tout dans une recherche d’équilibre constant. Nos pépinières Roué vous offrent ainsi un large choix de plantes « pour jardin zen » capables de répondre aux tendances et à vos besoins : élégance, variétés, couleurs et floraison à différentes périodes de l’année, tout est là !

Quelles plantes pour votre jardin japonais d’extérieur ? 

Si vous souhaitez confectionner votre propre jardin japonais « zen », un lieu de repos et de bien-être, il faudra compter sur les Azalea Mollis ou Azalea Japonaise comme l’Azalée japonaise 'Mme Van Hecke'. Entre cailloux et fontaines, ses fleurs roses tendre s’illumineront grâce au soleil tandis que son feuillage changera en fonction des saisons (du vert au bronze). Avec son port arrondi, cette plante typique des jardins zen rime avec simplicité et bien-être.

Vous pourrez d’ailleurs lui associer l’emblématique Érable japonais, connu pour sa diversité de couleurs en automne. La forme particulière de ses feuilles fait de cet arbuste un allié idéal lorsque l’on souhaite travailler à l’aménagement d’un jardin zen (à associer en massif).

Pour finir, chez Roué Pépinières, nous vous proposons également une superbe mousse tapissante : le Scleranthus. Cette plante vivace, s’apparentant à un petit coussin vert, apportera à votre jardin japonais le cachet qui lui manquait, d’autant plus que nous vous assurons une fraîcheur et une qualité constante (il est bon de le signaler !).

Les autres accessoires indispensables à votre jardin japonais

L’aménagement d'un petit jardin zen avec nos plantes japonaises d’extérieur, c’est la priorité lorsque l'on souhaite créer un coin de paradis.

Il existe tout de même certains accessoires qui viendront compléter votre jardin japonais, le but étant toutefois de garder ce côté épuré propre à l’esthétisme Nippon. Cette idéalisation de la nature, représentée en miniature, peut être complétée par des rochers par exemple. Dans ce cas, n’hésitez pas à jouer avec les tailles, les textures ou encore les couleurs.

L’eau est également un élément de décoration essentiel au Japon, un véritable symbole. De ce fait, un ruisseau traversant donnera énormément de crédibilité à votre espace.

C’est ainsi que Roué Pépinières vous accompagne dans votre choix de plantes pour jardin japonais extérieur. N'hésitez pas à utiliser les filtres pour choisir au mieux les plantes qui trouveront racine dans votre jardin japonais. 

Load Time 2142 ms
Querying Time 1499 ms
Queries 2504
Memory Peak Usage 106.4 Mb
Included Files 1150 files - 14.17 Mb
PrestaShop Cache - Mb
Global vars 1.11 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 43 ms 43 ms 7.22 Mb 7.3 Mb
__construct 0 ms 43 ms - Mb 7.3 Mb
init 25 ms 68 ms 2.20 Mb 9.7 Mb
checkAccess 0 ms 68 ms - Mb 9.7 Mb
setMedia 9 ms 77 ms 0.68 Mb 10.1 Mb
postProcess 0 ms 77 ms - Mb 10.1 Mb
initHeader 0 ms 77 ms - Mb 10.1 Mb
initContent 557 ms 634 ms 17.01 Mb 27.2 Mb
initFooter 0 ms 634 ms - Mb 27.2 Mb
display 1508 ms 2142 ms 78.25 Mb 106.4 Mb
Hook Time Memory Usage
DisplayNavFullWidth 1223 ms 60.59 Mb
DisplayBlock 1161 ms 57.28 Mb
DisplayAfterTitle 55 ms 4.82 Mb
DisplayProductPriceBlock 54 ms 3.46 Mb
DisplayHeader 18 ms 1.59 Mb
Header 6 ms 0.24 Mb
displayLeftColumn 5 ms 0.08 Mb
ActionObjectUpdateAfter 3 ms 0.05 Mb
DisplayBeforeBodyClosingTag 3 ms 0.18 Mb
displayFooter 2 ms 0.17 Mb
ProductSearchProvider 2 ms 0.07 Mb
displayTop 2 ms 0.09 Mb
DisplayFooter 2 ms 0.17 Mb
ActionDispatcher 1 ms 0.10 Mb
ActionFrontControllerSetMedia 1 ms 0.01 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
25 hook(s) 2541 ms 129.08 Mb
Module Time Memory Usage
ps_hubspot 2 ms 0.21 Mb
kiliba 5 ms 0.18 Mb
geodisofficiel 65 ms 3.43 Mb
smplredirectionsmanager 2 ms 0.28 Mb
blockwishlist 2 ms 0.15 Mb
ps_emailsubscription 4 ms 0.13 Mb
ps_facebook 7 ms 0.39 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 2 ms 0.08 Mb
ps_accounts 0 ms - Mb
psxmarketingwithgoogle 2 ms 0.10 Mb
ets_megamenu 2396 ms 119.36 Mb
ps_customersignin 0 ms 0.04 Mb
doofinder 1 ms 0.11 Mb
ultimateimagetool 0 ms 0.02 Mb
steavisgarantis 56 ms 3.64 Mb
storeggmap 0 ms 0.03 Mb
paypal 4 ms 0.33 Mb
pm_applepay 0 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 0 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 56 ms 4.99 Mb
pasliderpro3 0 ms 0.04 Mb
pasliderpro4 0 ms 0.04 Mb
ps_facetedsearch 3 ms 0.16 Mb
iziflux 0 ms 0.02 Mb
ps_categorytree 6 ms 0.16 Mb
ps_linklist 2 ms 0.13 Mb
ps_customeraccountlinks 1 ms 0.08 Mb
statsdata 3 ms 0.19 Mb
44 module(s) 2627 ms 135.69 Mb

Stopwatch SQL - 2504 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>=487 AND c.nright<=488 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
97959 ms 52356230010 Yes /modules/ps_facetedsearch/src/Adapter/MySQL.php:86
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>=487 AND c.nright<=488 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
20088 ms 9969096060 Yes /modules/ps_facetedsearch/src/Adapter/MySQL.php:86
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>=487 AND c.nright<=488 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
17617 ms 3383969400 Yes /modules/ps_facetedsearch/src/Adapter/MySQL.php:86
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>=487 AND c.nright<=488 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
14919 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(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
14583 ms 55566 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>=487 AND c.nright<=488 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
14470 ms 3430644840 Yes /modules/ps_facetedsearch/src/Adapter/MySQL.php:86
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>=487 AND c.nright<=488 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
14321 ms 4358319210 Yes /modules/ps_facetedsearch/src/Adapter/MySQL.php:86
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>=487 AND c.nright<=488 GROUP BY p.id_product) p
13488 ms 37822859361 /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(2820,2821,2822,2826)
AND cg.`id_group` IN (1)
GROUP BY c.id_category ORDER BY c.position ASC,c.id_category ASC
11466 ms 15876 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(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
11002 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
10697 ms 51597 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(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
10555 ms 23814 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(2748,2752,2753,2755,2263)
AND cg.`id_group` IN (1)
GROUP BY c.id_category ORDER BY c.position ASC,c.id_category ASC
10552 ms 19845 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
10417 ms 51597 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(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
9066 ms 43659 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(2750,2255,2260,2642,2643,2644,2645,2646,2647,2648)
AND cg.`id_group` IN (1)
GROUP BY c.id_category ORDER BY c.position ASC,c.id_category ASC
8932 ms 39690 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(2750,2255,2260,2642,2643,2644,2645,2646,2647,2648)
AND cg.`id_group` IN (1)
GROUP BY c.id_category ORDER BY c.position ASC,c.id_category ASC
8705 ms 39690 Yes Yes /modules/ets_megamenu/classes/Ets_megamenu_defines.php:178