Filtrer par

Prix

Prix

  • 9,00 € - 45,00 €

Rusticité

Rusticité

Couleur de fleur

Couleur de fleur

Floraison

Floraison

1

Offrir une carte cadeau

  

Cartes cadeaux   

Cordylines

Donnez un esprit graphique et exotique à votre jardon grâce aux Cordylines. Avec ses longues feuilles aux multiples coloris parfois des plus surprenants, sublimez votre jardin. 

Il y a 18 produits.

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

Filtres actifs

Retour en haut

La cordyline, une plante graphique au faux air de palmier

Indéniablement, avec sa rosette dense de longues feuilles linéaires ou lancéolées dressées vers le ciel, la cordyline a des airs de ressemblance avec le palmier. La même silhouette graphique, un rien exotique ! Surtout pour la Cordyline indivisa qui forme un tronc à tige épaisse, proche du stipe des palmiers. Pour autant, la cordyline n'est pas un palmier puisqu'elle est de la famille des agavacées (comme les agaves et les yuccas, ses cousins).

C'est une plante arbustive originaire d'Asie du sud-est, de Nouvelle-Zélande et du Pacifique. Autant dire qu'elle est un brin frileuse car rustique jusqu'à – 5 à – 10 °C. Elle sera donc cultivée en pleine terre sur les littoraux méditerranéen et atlantique, en pot ailleurs pour les plus petits sujets. En effet, sous nos latitudes, la cordyline peut atteindre une hauteur jusqu'à 10 m pour une envergure de 4 m.

L'espèce Cordyline australis (parfois appelé Dracaena australis) mérite une large place dans les jardins avant tout pour son feuillage rubané persistant, particulièrement dense, à plusieurs titres décoratif : les nombreux cultivars offrent des coloris variés, souvent rehaussés de panachures ou de stries, aux feuilles coriaces, en forme d'épées, plus ou moins arquées. À l'âge adulte (mais rarement en pot), la cordyline peut vous honorer d'une floraison estivale en longues panicules blanc crème.

Différentes variétés de cordyline pour un festival de couleurs

Avec les cordylines, on en voit de toutes les couleurs au jardin. Et même les plus improbables pour du feuillage. En effet, les cordylines ne font pas dans la demi-mesure et affichent haut leur(s) couleur(s).

La moins colorée, la cordyline ‘Peko’ offre tout de même des feuilles vertes parcourues d'une nervure centrale jaune. ‘Pink Champagne’ propose un feuillage vert gris joliment panaché de blanc et de rose pâle à la base. Tout comme ‘Torbay Dazzler’ qui dégage une douce odeur de vanille.

D'autres cordylines se la jouent moins sages et laissent exploser leurs teintes éclatantes : les variétés ‘Electric Pink’, ‘Charlie Boy’, ‘Pink Passion®’, ‘Pink Star®’ et ‘Cherry Sensation’ déploient leurs plus beaux atours dans les tons de rose plus ou moins vif. Tandis que ‘Electric Flash’, ‘Renegade Tana’ et ‘Red Star’ font plus dans l'élégance et la discrétion assumée en arborant des teintes chocolat veiné de crème, ou pourpre plus ou moins foncé.

La plantation de la cordyline

Pour faire le bonheur des cordylines, il faut leur offrir une situation très ensoleillée. Pour autant, elles aiment avoir les pieds au frais. C'est pourquoi elle se plaît dans un sol essentiellement bien drainé mais qui reste frais, surtout en été. Attention, sol frais ne veut pas dire détrempé ou saturé d'humidité, une caractéristique qu'elle redoute en hiver.

Très résistante à la sécheresse (dans un sol frais), à la forte chaleur et aux embruns, la cordyline craint les vents froids. Tout comme les températures inférieures à – 10 °C au maximum. Elle a donc toute sa place dans les jardins des côtes méditerranéenne et atlantique, sur un talus ou une rocaille, ou au sein d'un massif d'allure exotique. Elle pourra y être associée avec des gaves, des yuccas, des palmiers...

Ailleurs, les plus petites variétés de cordyline (‘Electric Pink‘, ‘Peko’,‘Can Can’, ‘Electric Star’...) se cultivent en pot bien drainé rempli d'un terreau léger, qui sera remisé en hiver dans une véranda.

Quel entretien pour les cordylines ?

Dans les régions au climat doux, la cordyline est assez facile à entretenir. Et pot, elle demande un peu plus d'attention :

  • Arroser une à deux fois par semaine en été en cas de forte chaleur ou de sécheresse
  • Apporter un peu de compost au printemps et en automne
  • Faire des apports d'engrais liquide une fois par mois pendant la période de croissance
  • Protéger les cordylines extérieures d'un voile d'hivernage et d'un bon paillage les premières années après sa plantation. Celles plantées en pot seront remisées dans une pièce lumineuse à la température comprise entre 10 et 15 °C
  • Éliminez les feuilles inférieures sèches
Load Time 2599 ms
Querying Time 2035 ms
Queries 1994
Memory Peak Usage 93.3 Mb
Included Files 1150 files - 14.19 Mb
PrestaShop Cache - Mb
Global vars 1.05 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 36 ms 36 ms 7.22 Mb 7.3 Mb
__construct 0 ms 36 ms - Mb 7.3 Mb
init 22 ms 58 ms 2.19 Mb 9.7 Mb
checkAccess 0 ms 58 ms - Mb 9.7 Mb
setMedia 9 ms 67 ms 0.68 Mb 10.1 Mb
postProcess 0 ms 67 ms - Mb 10.1 Mb
initHeader 0 ms 67 ms - Mb 10.1 Mb
initContent 475 ms 542 ms 12.83 Mb 23.1 Mb
initFooter 0 ms 542 ms - Mb 23.1 Mb
display 2057 ms 2599 ms 69.62 Mb 93.3 Mb
Hook Time Memory Usage
DisplayNavFullWidth 1862 ms 60.62 Mb
DisplayBlock 1802 ms 57.32 Mb
DisplayAfterTitle 66 ms 2.88 Mb
DisplayProductPriceBlock 29 ms 2.45 Mb
DisplayHeader 21 ms 1.55 Mb
displayTop 13 ms 0.11 Mb
Header 11 ms 0.24 Mb
displayLeftColumn 8 ms 0.08 Mb
DisplayBeforeBodyClosingTag 6 ms 0.18 Mb
ActionObjectUpdateAfter 3 ms 0.05 Mb
displayFooter 3 ms 0.17 Mb
DisplayFooter 2 ms 0.17 Mb
ActionDispatcher 1 ms 0.09 Mb
ProductSearchProvider 1 ms 0.07 Mb
ActionFrontControllerSetMedia 1 ms 0.01 Mb
DisplayBanner 1 ms 0.03 Mb
DisplayLeftColumn 0 ms 0.03 Mb
DisplayCustomMenu 0 ms 0.03 Mb
ActionObjectAddAfter 0 ms - Mb
DisplayAfterBodyOpeningTag 0 ms 0.01 Mb
DisplayProductListReviews 0 ms 0.02 Mb
DisplayTop 0 ms - Mb
DisplayFooterBefore 0 ms - Mb
DisplayFooterAfter 0 ms - Mb
ModuleRoutes 0 ms - Mb
25 hook(s) 3831 ms 126.13 Mb
Module Time Memory Usage
ps_hubspot 1 ms 0.21 Mb
kiliba 5 ms 0.18 Mb
geodisofficiel 50 ms 3.43 Mb
smplredirectionsmanager 3 ms 0.27 Mb
blockwishlist 2 ms 0.15 Mb
ps_emailsubscription 4 ms 0.13 Mb
ps_facebook 16 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 13 ms 0.10 Mb
ps_accounts 0 ms - Mb
psxmarketingwithgoogle 1 ms 0.10 Mb
ets_megamenu 3670 ms 119.43 Mb
ps_customersignin 0 ms 0.04 Mb
doofinder 1 ms 0.11 Mb
ultimateimagetool 0 ms 0.02 Mb
steavisgarantis 30 ms 2.61 Mb
storeggmap 0 ms 0.03 Mb
paypal 2 ms 0.33 Mb
pm_applepay 0 ms 0.03 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 1 ms 0.04 Mb
pamultiblock 0 ms 0.04 Mb
panewsletter 0 ms 0.04 Mb
paconfiance 4 ms 0.04 Mb
pasliderpro 1 ms 0.04 Mb
pasliderproj 2 ms 0.04 Mb
deliverydate 0 ms 0.03 Mb
cdc_googletagmanager 66 ms 3.05 Mb
pasliderpro3 1 ms 0.04 Mb
pasliderpro4 2 ms 0.04 Mb
ps_facetedsearch 1 ms 0.13 Mb
iziflux 0 ms 0.02 Mb
ps_categorytree 8 ms 0.16 Mb
ps_linklist 2 ms 0.13 Mb
ps_customeraccountlinks 1 ms 0.08 Mb
statsdata 6 ms 0.19 Mb
44 module(s) 3900 ms 132.70 Mb
  1. Stopwatch SQL
  2. Doubles
  3. Tables stress
  4. ObjectModel instances
  5. Included Files

Stopwatch SQL - 1994 queries

Query Time (ms) Rows Filesort Group By Location 
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
 30449 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>=44 AND c.nright<=45 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
 28460 ms 4358319210 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(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
 23142 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(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
 20762 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
WHERE c.active=1 AND  c.id_parent=2826 AND c.id_category!=2826
GROUP BY c.id_category ORDER BY c.position ASC,c.id_category ASC
 20047 ms 2 Yes Yes /modules/ets_megamenu/classes/Ets_megamenu_defines.php:149 
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
WHERE c.active=1 AND  c.id_parent=2748 AND c.id_category!=2748
GROUP BY c.id_category ORDER BY c.position ASC,c.id_category ASC
 19885 ms 2 Yes Yes /modules/ets_megamenu/classes/Ets_megamenu_defines.php:149 
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
WHERE c.active=1 AND  c.id_parent=2323 AND c.id_category!=2323
GROUP BY c.id_category ORDER BY c.position ASC,c.id_category ASC
 19877 ms 2 Yes Yes /modules/ets_megamenu/classes/Ets_megamenu_defines.php:149 
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)
AND cg.`id_group` IN (1)
GROUP BY c.id_category ORDER BY c.position ASC,c.id_category ASC
 19535 ms 23814 Yes Yes /modules/ets_megamenu/classes/Ets_megamenu_defines.php:178 
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>=44 AND c.nright<=45 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
 18380 ms 52356230010 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(2760,2762,2763,2764,2765)
AND cg.`id_group` IN (1)
GROUP BY c.id_category ORDER BY c.position ASC,c.id_category ASC
 17119 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(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
 16609 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(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
 16559 ms 51597 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>=44 AND c.nright<=45 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
 16337 ms 9969096060 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(2748,2749,2752,2753,2755,2263)
AND cg.`id_group` IN (1)
GROUP BY c.id_category ORDER BY c.position ASC,c.id_category ASC
 16249 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(2652,2653,2654)
AND cg.`id_group` IN (1)
GROUP BY c.id_category ORDER BY c.position ASC,c.id_category ASC
 16224 ms 11907 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>=44 AND c.nright<=45 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
 16174 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
WHERE c.active=1 AND  c.id_parent=2720 AND c.id_category!=2720
GROUP BY c.id_category ORDER BY c.position ASC,c.id_category ASC
 15674 ms 2 Yes Yes /modules/ets_megamenu/classes/Ets_megamenu_defines.php:149 
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,2824,2825,2826)
AND cg.`id_group` IN (1)
GROUP BY c.id_category ORDER BY c.position ASC,c.id_category ASC
 15575 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(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
 15517 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
WHERE c.active=1 AND  c.id_parent=2709 AND c.id_category!=2709
GROUP BY c.id_category ORDER BY c.position ASC,c.id_category ASC
 15333 ms 2 Yes Yes /modules/ets_megamenu/classes/Ets_megamenu_defines.php:149 
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
 14477 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(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
 14357 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
WHERE c.active=1 AND  c.id_parent=2701 AND c.id_category!=2701
GROUP BY c.id_category ORDER BY c.position ASC,c.id_category ASC
 14146 ms 2 Yes Yes /modules/ets_megamenu/classes/Ets_megamenu_defines.php:149 
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(2832)
AND cg.`id_group` IN (1)
GROUP BY c.id_category ORDER BY c.position ASC,c.id_category ASC
 14125 ms 3969 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(2274,2275,2380,2276,2277,2278)
AND cg.`id_group` IN (1)
GROUP BY c.id_category ORDER BY c.position ASC,c.id_category ASC
 14001 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(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
 13654 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(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
 13644 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
WHERE c.active=1 AND  c.id_parent=2326 AND c.id_category!=2326
GROUP BY c.id_category ORDER BY c.position ASC,c.id_category ASC
 13485 ms 2 Yes Yes /modules/ets_megamenu/classes/Ets_megamenu_defines.php:149 
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>=44 AND c.nright<=45 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
 12841 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
WHERE c.active=1 AND  c.id_parent=2274 AND c.id_category!=2274
GROUP BY c.id_category ORDER BY c.position ASC,c.id_category ASC
 12634 ms 2 Yes Yes /modules/ets_megamenu/classes/Ets_megamenu_defines.php:149 
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
 12425 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
WHERE c.active=1 AND  c.id_parent=2748 AND c.id_category!=2748
GROUP BY c.id_category ORDER BY c.position ASC,c.id_category ASC
 12365 ms 2 Yes Yes /modules/ets_megamenu/classes/Ets_megamenu_defines.php:149 
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)
AND cg.`id_group` IN (1)
GROUP BY c.id_category ORDER BY c.position ASC,c.id_category ASC
 12119 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(2760,2762,2763,2764,2765)
AND cg.`id_group` IN (1)
GROUP BY c.id_category ORDER BY c.position ASC,c.id_category ASC
 12010 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
WHERE c.active=1 AND  c.id_parent=2322 AND c.id_category!=2322
GROUP BY c.id_category ORDER BY c.position ASC,c.id_category ASC
 11794 ms 2 Yes Yes /modules/ets_megamenu/classes/Ets_megamenu_defines.php:149 
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(2701,2703,2705)
AND cg.`id_group` IN (1)
GROUP BY c.id_category ORDER BY c.position ASC,c.id_category ASC
 11265 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(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
 11232 ms 55566 Yes Yes /modules/ets_megamenu/classes/Ets_megamenu_defines.php:178 
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 1604) AND (id_product_attribute = 7873) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
 10957 ms 1 /classes/stock/StockAvailable.php:453 
SELECT SQL_NO_CACHE *
FROM `ps_shop` a
WHERE (a.`id_shop` = 1) LIMIT 1
 10844 ms 1 /src/Adapter/EntityMapper.php:76 
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(2267,2268,2639,2640,2839)
AND cg.`id_group` IN (1)
GROUP BY c.id_category ORDER BY c.position ASC,c.id_category ASC
 10790 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
WHERE c.active=1 AND  c.id_parent=2255 AND c.id_category!=2255
GROUP BY c.id_category ORDER BY c.position ASC,c.id_category ASC
 10681 ms 4 Yes Yes /modules/ets_megamenu/classes/Ets_megamenu_defines.php:149 
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(2760,2761,2762,2763,2764,2765)
AND cg.`id_group` IN (1)
GROUP BY c.id_category ORDER BY c.position ASC,c.id_category ASC
 10667 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
WHERE c.active=1 AND  c.id_parent=2807 AND c.id_category!=2807
GROUP BY c.id_category ORDER BY c.position ASC,c.id_category ASC
 10392 ms 2 Yes Yes /modules/ets_megamenu/classes/Ets_megamenu_defines.php:149 
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(2801,2802,2803)
AND cg.`id_group` IN (1)
GROUP BY c.id_category ORDER BY c.position ASC,c.id_category ASC
 10315 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(2829,2830,2831)
AND cg.`id_group` IN (1)
GROUP BY c.id_category ORDER BY c.position ASC,c.id_category ASC
 10236 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(2690,2691,2692,2693,2694,2309)
AND cg.`id_group` IN (1)
GROUP BY c.id_category ORDER BY c.position ASC,c.id_category ASC
 10189 ms 23814 Yes Yes /modules/ets_megamenu/classes/Ets_megamenu_defines.php:178