Camélias

Vous êtes séduits par la noblesse et le charme du Camélia ? C'est normal ! Ils sont capables de fédérer au travers le monde des associations de passionnés toujours à la recherche de nouvelles fleurs. Nous recherchons chaque année des nouvelles variétés à multiplier et mettre en production.

Il y a 200 produits.

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

Filtres actifs

Retour en haut

Spécialistes passionnés du Camélia

Nous sommes à la tête d'une collection de plus de 150 variétés de Camélias produits dans notre pépinière en Bretagne.

La réputation du Camélia n'est plus à faire... Il est connu à travers des références littéraires, telles que « La Dame aux Camélias » ou encore de grands noms comme Coco Chanel. Ce dernier le met en avant en l’accrochant aux boutonnières des messieurs ou dans les cheveux pour les dames.

Appréciés pour leurs longues floraisons, les Camélias restent des arbres ou arbustes persistants fascinants. Leur évolution, leur diversité, leurs formes de fleurs, leurs nuances de couleurs... Les fleurs vont du blanc pur au rouge sombre en passant par tous les roses et panachures diverses et parfois très étonnantes.Un Camélia en haie ? C'est possible !! Le camélia hybride ou sasanqua apporte de la fleur en hiver contrairement à beaucoup d'autres arbustes. Mais le plus souvent, c'est en isolé ou dans un massif qu'il est utilisé. Il s'associe parfaitement avec les couvre-sol. Vous n'avez qu'un balcon, pas de panique ! Les variétés à plus petit développement se plaisent parfaitement en pot. Le Camélia Olé, le Camélia Botanyuki,le Camélia Dahlohnega...

Vous ne savez pas où, quand et comment planter un Camélia ? Retrouvez toutes les informations pour vous aider à planter votre Camélia sur notre blog.Aussi très connu, le Camélia sinensis, autrement appelé Théier. C'est un arbuste qui se couvre d’une multitude de petites fleurs blanches parfumées de novembre à avril. C’est à partir de ce Camélia que l’on obtient le fameux thé vert et ses vertus intellectuelles, musculaires, cardiorespiratoires et diurétiques.
Vous voyez, le camélia ne peut qu’apporter du bien à votre jardin …

Load Time 1805 ms
Querying Time 1204 ms
Queries 2527
Memory Peak Usage 107.8 Mb
Included Files 1152 files - 14.24 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 31 ms 31 ms 7.23 Mb 7.3 Mb
__construct 0 ms 31 ms - Mb 7.3 Mb
init 27 ms 57 ms 2.32 Mb 9.7 Mb
checkAccess 0 ms 57 ms - Mb 9.7 Mb
setMedia 5 ms 62 ms 0.68 Mb 10.2 Mb
postProcess 0 ms 62 ms - Mb 10.2 Mb
initHeader 0 ms 62 ms - Mb 10.2 Mb
initContent 451 ms 513 ms 17.90 Mb 28.3 Mb
initFooter 0 ms 513 ms - Mb 28.3 Mb
display 1292 ms 1805 ms 78.64 Mb 107.8 Mb
Hook Time Memory Usage
DisplayNavFullWidth 1060 ms 60.53 Mb
DisplayBlock 1001 ms 57.37 Mb
DisplayAfterTitle 55 ms 4.83 Mb
DisplayProductPriceBlock 34 ms 3.39 Mb
ActionGetProductPropertiesAfter 21 ms 1.41 Mb
DisplayHeader 8 ms 1.58 Mb
displayLeftColumn 7 ms 0.22 Mb
Header 4 ms 0.24 Mb
ActionObjectUpdateAfter 3 ms 0.05 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
ActionDispatcher 1 ms 0.09 Mb
DisplayLeftColumn 0 ms 0.06 Mb
ProductSearchProvider 0 ms - Mb
DisplayBanner 0 ms 0.03 Mb
DisplayCustomMenu 0 ms 0.03 Mb
ActionObjectAddAfter 0 ms - Mb
ActionFrontControllerSetMedia 0 ms 0.01 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) 2203 ms 130.50 Mb
Module Time Memory Usage
ps_hubspot 1 ms 0.21 Mb
kiliba 4 ms 0.18 Mb
geodisofficiel 39 ms 3.43 Mb
smplredirectionsmanager 2 ms 0.27 Mb
blockwishlist 1 ms 0.15 Mb
ps_emailsubscription 3 ms 0.13 Mb
ps_facebook 3 ms 0.39 Mb
blockreassurance 0 ms 0.10 Mb
ps_emailalerts 0 ms 0.04 Mb
paybox 1 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 0 ms 0.10 Mb
ets_megamenu 2066 ms 119.37 Mb
ps_customersignin 0 ms 0.04 Mb
doofinder 0 ms 0.11 Mb
ultimateimagetool 0 ms 0.02 Mb
steavisgarantis 35 ms 3.57 Mb
storeggmap 0 ms 0.03 Mb
paypal 2 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 1 ms 0.09 Mb
pm_multiplefeatures 21 ms 1.45 Mb
iziflux 0 ms 0.02 Mb
ps_categorytree 7 ms 0.29 Mb
ps_linklist 1 ms 0.13 Mb
ps_customeraccountlinks 1 ms 0.08 Mb
statsdata 3 ms 0.19 Mb
45 module(s) 2256 ms 137.14 Mb
  1. Stopwatch SQL
  2. Doubles
  3. Tables stress
  4. ObjectModel instances
  5. Included Files

Stopwatch SQL - 2527 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>=265 AND c.nright<=318 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
 95987 ms 52356230010 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>=265 AND c.nright<=318 GROUP BY p.id_product) p
 28735 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(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
 11074 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(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
 9451 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(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
 9136 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
 8529 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
 8434 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(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
 8402 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
 7934 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(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
 7834 ms 55566 Yes Yes /modules/ets_megamenu/classes/Ets_megamenu_defines.php:178 
SELECT SQL_NO_CACHE c.*, cl.`id_lang`, cl.`name`, cl.`description`, cl.`link_rewrite`, cl.`meta_title`, cl.`meta_keywords`, cl.`meta_description`
FROM `ps_category` c
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND `id_lang` = 1  AND cl.id_shop = 1 )
LEFT JOIN `ps_category_group` cg ON (cg.`id_category` = c.`id_category`)
WHERE `id_parent` = 1974
AND `active` = 1
AND cg.`id_group` =1
GROUP BY c.`id_category`
ORDER BY `level_depth` ASC, category_shop.`position` ASC
 7590 ms 23814 Yes Yes /classes/Category.php:919 
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
 7552 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
 7510 ms 35721 Yes Yes /modules/ets_megamenu/classes/Ets_megamenu_defines.php:178