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

  

Érables

Les Érables ou Acer sont les arbres caducs stars du jardin. Ils se donnent en spectacle dès l'apparition des nouvelles feuilles au printemps jusqu'à ce qu'elles tombent à la veille de l'hiver. Que vous ayez un grand jardin ou une petite terrasse, l'Érable y trouvera sa place. Ils aiment les coins ombragés et à l'abri des vents froids. Ces arbustes se plaisent autant en jardin qu'en pot vous n'avez plus qu'à choisir le feuillage qui vous fait craquer. Des feuilles très fines ciselées aux feuilles palmées, vous trouverez forcément votre bonheur dans notre collection d'Érable. L'Acer est aussi l'arbre symbolique du jardin japonais et du jardin zen, découvrez notre collection d'Érables parmi plus de 20 variétés !

Il y a 51 produits.

Affichage 1-30 de 51 article(s)

Filtres actifs

L'érable, un arbre élégant au feuillage somptueux

Comment de ne pas tomber sous le charme d'un érable au feuillage d'une élégance et d'une finesse si remarquables ? Les érables (Acer), aujourd'hui membre de la famille des Sapindacées, puisent leurs origines en Asie, au Japon, en Chine ou en Corée. Ils se décomposent en deux grandes espèces : Acer palmatum et Acer japonicum, tout aussi magnifiques l'une que l'autre. Dotés d'une croissance plutôt lente, les érables ne peuvent avoir qu'une place de choix au jardin. Il faut dire qu'ils cumulent les atouts charme :

  • Une silhouette très graphique au port le plus souvent arrondi. Cette architecture esthétique en fait des candidats parfaits pour les bonsaïs
  • Un feuillage fin, très palmé et découpé en lobes ciselés
  • Un feuillage évolutif qui change de teintes au fil des saisons. Et la palette des couleurs semble presque infinie...jusqu'à l'apothéose automnale où les feuilles s'embrasent littéralement de couleurs flamboyantes
  • Une floraison discrète mais agréable, suivie d'une fructification en samares (deux graines collées à deux ailes) d'un joli rouge foncé
  • Une hauteur et une envergure qui atteignent au maximum 10 m. Ce sont des arbres parfaits pour les petits jardins urbains, ou les jardins d'inspiration zen
  • Une grande facilité à pousser en bac (qui doit être assez large car l'érable est doté d'un système racinaire superficiel).

Les variétés d'érables pour une explosion de couleurs

L'érable affiche une diversité de couleurs assez impressionnante d'une variété à une autre. Au-delà de cette palette riche, le feuillage de l'érable évolue au fil des saisons. Et du printemps à l'automne, il offre un arc-en-ciel de couleurs assez varié, passant de teintes douces à des tons totalement flamboyants en automne. Certains comme l'Acer palmatum ‘Dissectum’ et ‘Seiryu’ offrent un feuillage vert tendre de dentelle, ‘Shishigashira’ surprend par son feuillage crispé et dense d'un vert assez foncé. Tandis que ‘Koto-No-Ito’ se revêt de très fines feuilles retombantes qui lui donnent un aspect pleureur. ‘Aureum’ , ‘Okushimo’ et ‘Summer Gold’ annoncent le printemps avec un feuillage vert jaune très lumineux. D'autres s'affichent d'emblée dans des parures flamboyantes : ‘Bloodgood’ offre un feuillage pourpre foncé qui devient rouge orangé en automne, ‘Starfish’ se pare de feuilles en étoiles de mer rouges, et ‘Fujinami Nishiki’ propose, en trois saisons, toutes les nuances de rouge. Certains affichent même des feuillages panachés comme l'érable à feuilles de frêne ‘Flamingo’, ou carrément teintés en différentes couleurs comme ‘Manyo no Sato’ aux feuilles indifféremment vert citron ou violet pourpre. En bref, avec les érables, on ne fait jamais dans la monotonie ! À vous de choisir dans notre vaste gamme celui qui saura vous séduire...

La plantation des érables

De croissance assez lente, l'érable a quelques exigences en matière de plantation. Il lui faut d'abord un sol riche en matières organiques, frais, parfaitement drainé, et à tendance acide. En plaine terre, il peut se plaire en compagnie des camélias, des rhododendrons, des pieris. Mais pas trop près non plus ! Enfin, le caprice de l'érable réside dans son isolement. En effet, il n'aime guère la concurrence des systèmes racinaires des autres arbres et arbustes. Quant à l'exposition idéale, elle est mi-ombragée, et surtout abritée des vents froids. En pot, le substrat idéal pour l'érable est composé de terre de jardin, de compost bien décomposé, d'écorces de pin et de graviers (ou des billes d'argile). Un pot plus large que haut fera son bonheur.

Quel entretien pour l'érable?

L'érable peut se montrer fragile et sujet aux maladies si ses conditions culturales ne sont pas respectées. C'est pourquoi, il est essentiel de :

  • Faire un apport de compost une fois par an
  • Rempoter votre érable en pot tous les 2 à 3 ans en fin d'hiver
  • Arroser régulièrement surtout au printemps et en été (l'érable aime les sols frais)
  • Pailler le pied de l'érable en début d'hiver pour le protéger du froid et éventuellement le recouvrir d'un voile d'hivernage dans les régions les plus froides (même si l'érable est rustique jusqu'à – 15 °C)
Load Time 1797 ms
Querying Time 1211 ms
Queries 2462
Memory Peak Usage 104.5 Mb
Included Files 1152 files - 14.24 Mb
PrestaShop Cache - Mb
Global vars 1.09 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 30 ms 30 ms 7.23 Mb 7.3 Mb
__construct 0 ms 30 ms - Mb 7.3 Mb
init 28 ms 58 ms 2.29 Mb 9.7 Mb
checkAccess 0 ms 58 ms - Mb 9.7 Mb
setMedia 9 ms 67 ms 0.67 Mb 10.2 Mb
postProcess 0 ms 67 ms - Mb 10.2 Mb
initHeader 0 ms 67 ms - Mb 10.2 Mb
initContent 414 ms 481 ms 18.02 Mb 28.4 Mb
initFooter 0 ms 481 ms - Mb 28.4 Mb
display 1315 ms 1797 ms 75.30 Mb 104.5 Mb
Hook Time Memory Usage
DisplayNavFullWidth 1123 ms 60.50 Mb
DisplayBlock 1070 ms 57.30 Mb
DisplayAfterTitle 50 ms 4.86 Mb
DisplayProductPriceBlock 30 ms 3.37 Mb
ActionGetProductPropertiesAfter 20 ms 1.31 Mb
DisplayHeader 13 ms 1.55 Mb
displayLeftColumn 5 ms 0.20 Mb
Header 4 ms 0.24 Mb
DisplayFooter 3 ms 0.17 Mb
displayTop 3 ms 0.09 Mb
ActionObjectUpdateAfter 2 ms 0.05 Mb
DisplayBeforeBodyClosingTag 2 ms 0.18 Mb
displayFooter 2 ms 0.17 Mb
ActionDispatcher 1 ms 0.09 Mb
DisplayBanner 1 ms 0.03 Mb
DisplayCustomMenu 1 ms 0.03 Mb
ActionFrontControllerSetMedia 1 ms 0.01 Mb
DisplayLeftColumn 0 ms 0.05 Mb
ProductSearchProvider 0 ms - Mb
ActionObjectAddAfter 0 ms - Mb
DisplayAfterBodyOpeningTag 0 ms 0.01 Mb
DisplayProductListReviews 0 ms 0.03 Mb
DisplayTop 0 ms - Mb
DisplayFooterBefore 0 ms - Mb
DisplayFooterAfter 0 ms - Mb
ModuleRoutes 0 ms - Mb
26 hook(s) 2331 ms 130.25 Mb
Module Time Memory Usage
ps_hubspot 1 ms 0.21 Mb
kiliba 4 ms 0.18 Mb
geodisofficiel 42 ms 3.43 Mb
smplredirectionsmanager 2 ms 0.27 Mb
blockwishlist 3 ms 0.15 Mb
ps_emailsubscription 4 ms 0.13 Mb
ps_facebook 7 ms 0.36 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 1 ms 0.03 Mb
ps_shoppingcart 2 ms 0.08 Mb
ps_accounts 0 ms - Mb
psxmarketingwithgoogle 1 ms 0.10 Mb
ets_megamenu 2199 ms 119.28 Mb
ps_customersignin 1 ms 0.04 Mb
doofinder 1 ms 0.11 Mb
ultimateimagetool 0 ms 0.02 Mb
steavisgarantis 32 ms 3.56 Mb
storeggmap 0 ms 0.03 Mb
paypal 3 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 50 ms 5.02 Mb
pasliderpro3 0 ms 0.04 Mb
pasliderpro4 0 ms 0.04 Mb
ps_facetedsearch 1 ms 0.08 Mb
pm_multiplefeatures 20 ms 1.34 Mb
iziflux 0 ms 0.02 Mb
ps_categorytree 5 ms 0.27 Mb
ps_linklist 2 ms 0.13 Mb
ps_customeraccountlinks 1 ms 0.08 Mb
statsdata 2 ms 0.19 Mb
45 module(s) 2392 ms 136.88 Mb

Stopwatch SQL - 2462 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>=46 AND c.nright<=57 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
32498 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>=46 AND c.nright<=57 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
13264 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>=46 AND c.nright<=57 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
11785 ms 4358319210 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>=46 AND c.nright<=57 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
11698 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(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
11109 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(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
10946 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>=46 AND c.nright<=57 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
10820 ms 3327569910 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>=46 AND c.nright<=57 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
10653 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(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
10535 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(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
10416 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
9568 ms 43659 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>=46 AND c.nright<=57 GROUP BY p.id_product) p
9502 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(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
8878 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
8653 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(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
7903 ms 31752 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(2829,2830,2831)
AND cg.`id_group` IN (1)
GROUP BY c.id_category ORDER BY c.position ASC,c.id_category ASC
7810 ms 11907 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(2292,2294,2369,2370,2685,2686,2687,2689)
AND cg.`id_group` IN (1)
GROUP BY c.id_category ORDER BY c.position ASC,c.id_category ASC
7784 ms 31752 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(2292,2294,2369,2370,2685,2686,2687,2689)
AND cg.`id_group` IN (1)
GROUP BY c.id_category ORDER BY c.position ASC,c.id_category ASC
7745 ms 31752 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(2256,2733,2734,2735,2736,2737,2738,2739,2740)
AND cg.`id_group` IN (1)
GROUP BY c.id_category ORDER BY c.position ASC,c.id_category ASC
7736 ms 35721 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(2261,2792,2793,2794,2795,2796,2797,2798)
AND cg.`id_group` IN (1)
GROUP BY c.id_category ORDER BY c.position ASC,c.id_category ASC
7678 ms 31752 Yes Yes /modules/ets_megamenu/classes/Ets_megamenu_defines.php:178