Filtrer par

Prix

Prix

  • 0,00 € - 119,00 €

Rusticité

Rusticité

Couleur de fleur

Couleur de fleur

Exposition

Exposition

Floraison

Floraison

1

Type de feuillage

Type de feuillage

Offrir une carte cadeau

  

Cartes cadeaux   

Mon jardin parfumé

Les plantes pour composer le jardin parfumé idéal : l’arbuste parfumé, le camélia d’automne, la sauge…

Camelia parfumé Koto-No-Kaori

Nos plantes servent vos yeux… mais aussi votre odorat ! Un jardin parfumé grâce aux effluves raffinés de végétaux soigneusement sélectionnés, c’est ce que nous vous proposons. Choisissez parmi près de 80 variétés de plantes parfumées pour créer un espace dédié aux sens, un parterre de vie à votre mesure.

Il y a 97 produits.

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

Filtres actifs

Retour en haut

Automne, hiver : un jardin parfumé pour affronter le froid

Ce n’est pas parce que le temps n’est pas bon qu’il faut se priver de son extérieur. Terrasse cosy, grand espace chauffé, un nombre incalculables de plantes parfumées offrent à cette période de l’année une magnifique floraison. Chez Roué Pépinières, nous avons pris soin de sélectionner les meilleures variétés pour vos futurs jardins parfumés et colorés.

Comme son nom l’indique, le Camélia à floraison d’automne propose une super floraison durant cette saison, plus précisément en octobre. Associée à ses feuilles brillantes, cette plante parfumée dégage une petite note boisée subtile et agréable. Une effluve qui perdurera pendant toute la saison.

En hiver, ce sont les Camélia champêtres qui prennent la relève. Camélia 'Transnokoensis', Camélia 'Koto-No-Kaori', Camélia 'Festival of Light' ou encore Camélia 'Fairy Blush' : dès le premier jour de l’an et jusqu’à mars, ces plantes parfumées offriront à vos jardins un parfum sucré et doux, grâce notamment à leur multitude de petites fleurs coupées.

Des plantes parfumées pour exhaler votre printemps

Pour la saison du printemps, Roué pépinières a sélectionné deux arbustes singuliers, deux plantes parfumées aux fleurs blanches et étoilées :

- L’Eriostemon : cet arbuste au subtile parfum de miel possède notamment un feuillage vert foncé et pourvu de glandes aromatiques. Au programme, notes sucrées et jardins parfumés !

- Le Choisya (Oranger du Mexique) : avec son feuillage persistant et capable de parfumer vos espaces toute l’année, cet espèce de buisson aromatique possède des fleurs en abondance qui dévoileront une senteur poivrée et abondante. Allant de 1 à 3 mètres de hauteur, cette plante parfumée apparaît comme la solution idéale pour les personnes souhaitant égayer de belles terrasses spacieuses.

Jardins parfumés et période estivale 

Communément nommée « la Plante curry », l’Helichrysum serotinum propose également un feuillage qui a pour caractéristique d’exhaler son environnement d’effluves épicés, et ce de manière annuelle. Cet arbuste possède une floraison qui s’étend d'août à octobre, le moment que choisissent ses belles fleurs jaunes pour faire leur apparition. Un timing idéal quand on souhaite garnir nos terrasses et jardins pour les vacances !

Vous préférez les senteurs citronnées, privilégiez la fameuse Sauge, très florifère dès le mois de juin.

Printemps et été riment souvent avec senteurs enivrantes, et pour cause, la chaleur du soleil permet aux plantes parfumées de multiplier la puissance de leurs effluves, créant ainsi un mélange de plaisirs sensitifs remarquables.

Camélia Transnokoensis, Choisya et Sauge pour un cocktail attractif et enivrant toute l’année ; Helichrysum et Eriostemon pour des notes plus raffinées d’épices.

Load Time 1103 ms
Querying Time 593 ms
Queries 2515
Memory Peak Usage 106.5 Mb
Included Files 1151 files - 14.22 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 27 ms 27 ms 7.23 Mb 7.3 Mb
__construct 0 ms 27 ms - Mb 7.3 Mb
init 16 ms 43 ms 2.20 Mb 9.7 Mb
checkAccess 0 ms 43 ms - Mb 9.7 Mb
setMedia 7 ms 50 ms 0.68 Mb 10.1 Mb
postProcess 0 ms 50 ms - Mb 10.1 Mb
initHeader 0 ms 50 ms - Mb 10.1 Mb
initContent 374 ms 425 ms 18.46 Mb 28.7 Mb
initFooter 0 ms 425 ms - Mb 28.7 Mb
display 679 ms 1103 ms 76.83 Mb 106.5 Mb
Hook Time Memory Usage
DisplayNavFullWidth 530 ms 60.67 Mb
DisplayBlock 478 ms 57.46 Mb
DisplayAfterTitle 40 ms 4.99 Mb
DisplayProductPriceBlock 26 ms 3.44 Mb
ActionGetProductPropertiesAfter 22 ms 1.47 Mb
DisplayHeader 9 ms 1.56 Mb
DisplayBeforeBodyClosingTag 3 ms 0.18 Mb
Header 3 ms 0.24 Mb
ActionObjectUpdateAfter 3 ms 0.05 Mb
displayLeftColumn 1 ms 0.19 Mb
displayTop 1 ms 0.09 Mb
displayFooter 1 ms 0.17 Mb
DisplayFooter 1 ms 0.17 Mb
ActionDispatcher 1 ms 0.10 Mb
ProductSearchProvider 1 ms 0.07 Mb
ActionFrontControllerSetMedia 1 ms 0.01 Mb
DisplayBanner 0 ms 0.03 Mb
DisplayLeftColumn 0 ms 0.07 Mb
ActionObjectAddAfter 0 ms - Mb
DisplayCustomMenu 0 ms 0.03 Mb
DisplayProductListReviews 0 ms 0.03 Mb
DisplayAfterBodyOpeningTag 0 ms 0.01 Mb
DisplayTop 0 ms - Mb
DisplayFooterBefore 0 ms - Mb
DisplayFooterAfter 0 ms - Mb
ModuleRoutes 0 ms - Mb
26 hook(s) 1123 ms 131.04 Mb
Module Time Memory Usage
ps_hubspot 1 ms 0.21 Mb
kiliba 4 ms 0.18 Mb
geodisofficiel 40 ms 3.43 Mb
smplredirectionsmanager 2 ms 0.28 Mb
blockwishlist 1 ms 0.15 Mb
ps_emailsubscription 3 ms 0.13 Mb
ps_facebook 4 ms 0.37 Mb
blockreassurance 0 ms 0.10 Mb
ps_emailalerts 0 ms 0.04 Mb
paybox 2 ms 0.24 Mb
ps_imageslider 0 ms 0.03 Mb
ps_searchbar 0 ms 0.03 Mb
ps_shoppingcart 1 ms 0.08 Mb
ps_accounts 0 ms - Mb
psxmarketingwithgoogle 1 ms 0.10 Mb
ets_megamenu 1013 ms 119.62 Mb
ps_customersignin 0 ms 0.04 Mb
doofinder 1 ms 0.11 Mb
ultimateimagetool 0 ms 0.02 Mb
steavisgarantis 27 ms 3.62 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 41 ms 5.15 Mb
pasliderpro3 0 ms 0.04 Mb
pasliderpro4 0 ms 0.04 Mb
ps_facetedsearch 2 ms 0.16 Mb
pm_multiplefeatures 22 ms 1.51 Mb
iziflux 0 ms 0.02 Mb
ps_categorytree 2 ms 0.26 Mb
ps_linklist 1 ms 0.13 Mb
ps_customeraccountlinks 1 ms 0.08 Mb
statsdata 4 ms 0.19 Mb
45 module(s) 1179 ms 137.68 Mb
  1. Stopwatch SQL
  2. Doubles
  3. Tables stress
  4. ObjectModel instances
  5. Included Files

Stopwatch SQL - 2515 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, SUM(sa.quantity) as quantity, 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 ) 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>=468 AND c.nright<=469 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
 11636 ms 124597494 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, SUM(sa.quantity) as quantity, 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 ) 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>=468 AND c.nright<=469 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
 5238 ms 102122370 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, SUM(sa.quantity) as quantity, 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 ) 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>=468 AND c.nright<=469 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
 5054 ms 80385480 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, SUM(sa.quantity) as quantity, 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 ) 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>=468 AND c.nright<=469 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
 4691 ms 77970270 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, SUM(sa.quantity) as quantity, 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 ) 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>=468 AND c.nright<=469 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
 4097 ms 79291800 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, SUM(sa.quantity) as quantity, 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 ) 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>=468 AND c.nright<=469 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
 4021 ms 20766249 Yes /modules/ps_facetedsearch/src/Adapter/MySQL.php:86 
SELECT SQL_NO_CACHE COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, SUM(sa.quantity) as quantity, 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 ) 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>=468 AND c.nright<=469 GROUP BY p.id_product) p
 3505 ms 20766249 /modules/ps_facetedsearch/src/Adapter/MySQL.php:86 
SELECT SQL_NO_CACHE h.`name` as hook, m.`id_module`, h.`id_hook`, m.`name` as module
FROM `ps_module` m
INNER JOIN ps_module_shop module_shop
ON (module_shop.id_module = m.id_module AND module_shop.id_shop = 1 AND module_shop.enable_device & 1)
INNER JOIN `ps_module_shop` `ms` ON ms.`id_module` = m.`id_module`
INNER JOIN `ps_hook_module` `hm` ON hm.`id_module` = m.`id_module`
INNER JOIN `ps_hook` `h` ON hm.`id_hook` = h.`id_hook`
LEFT JOIN `ps_module_group` `mg` ON mg.`id_module` = m.`id_module`
WHERE (h.`name` != "paymentOptions") AND (hm.`id_shop` = 1) AND (mg.id_shop = 1 AND  mg.`id_group` IN (1))
GROUP BY hm.id_hook, hm.id_module
ORDER BY hm.`position`
 2816 ms 200 Yes Yes /classes/Hook.php:1183 
SELECT SQL_NO_CACHE c.`name`, cl.`id_lang`, IF(cl.`id_lang` IS NULL, c.`value`, cl.`value`) AS value, c.id_shop_group, c.id_shop
FROM `ps_configuration` c
LEFT JOIN `ps_configuration_lang` cl ON (c.`id_configuration` = cl.`id_configuration`)
 2344 ms 1169 /classes/Configuration.php:160 
SELECT SQL_NO_CACHE h.id_hook, h.name as h_name, title, description, h.position, hm.position as hm_position, m.id_module, m.name, m.active
FROM `ps_hook_module` hm
STRAIGHT_JOIN `ps_hook` h ON (h.id_hook = hm.id_hook AND hm.id_shop = 1)
STRAIGHT_JOIN `ps_module` as m ON (m.id_module = hm.id_module)
ORDER BY hm.position
 2302 ms 542 /classes/Hook.php:504 
SELECT SQL_NO_CACHE `id_hook`, `name`
FROM `ps_hook`
UNION
SELECT `id_hook`, ha.`alias` as name
FROM `ps_hook_alias` ha
INNER JOIN `ps_hook` h ON ha.name = h.name
 2103 ms 0 /classes/Hook.php:1243 
SELECT SQL_NO_CACHE `reduction`
FROM `ps_product_group_reduction_cache`
WHERE `id_product` = 235 AND `id_group` = 1 LIMIT 1
 1799 ms 0 /classes/GroupReduction.php:156 
SELECT SQL_NO_CACHE location
FROM `ps_stock_available`
WHERE (id_product = 233) AND (id_product_attribute = 856) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
 1539 ms 1 /classes/stock/StockAvailable.php:797 
SELECT SQL_NO_CACHE cl.*,c.*, cl.`name` country, z.`name` zone
FROM `ps_country` c  INNER JOIN ps_country_shop country_shop
ON (country_shop.id_country = c.id_country AND country_shop.id_shop = 1)
LEFT JOIN `ps_country_lang` cl ON (c.`id_country` = cl.`id_country` AND cl.`id_lang` = 1)
LEFT JOIN `ps_zone` z ON (z.`id_zone` = c.`id_zone`)
WHERE 1
ORDER BY cl.name ASC
 1509 ms 241 Yes /classes/Country.php:147 
SELECT SQL_NO_CACHE `id_order`
FROM `ps_orders`
WHERE `id_cart` = 0 AND id_shop IN (1) LIMIT 1
 1374 ms 1 /classes/order/Order.php:1203 
SELECT SQL_NO_CACHE psi.price_min, MIN(price_min) as min, MAX(price_max) as max FROM ps_product p INNER JOIN ps_layered_price_index psi ON (psi.id_product = p.id_product AND psi.id_shop = 1 AND psi.id_currency = 1 AND psi.id_country = 8) 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_product cp ON (p.id_product = cp.id_product) 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>=468 AND c.nright<=469
 1295 ms 4557 /modules/ps_facetedsearch/src/Adapter/MySQL.php:86 
SELECT SQL_NO_CACHE fp.id_feature, vl.value, fl.name, mfel.*, v.id_feature_value
FROM `ps_feature_product` fp
LEFT JOIN `ps_feature_value` v ON (fp.`id_feature_value` = v.`id_feature_value`)
LEFT JOIN `ps_feature_value_lang` vl ON (v.`id_feature_value` = vl.`id_feature_value` AND vl.`id_lang` = 1)
LEFT JOIN `ps_pm_mf_extra_lang` mfel ON (v.`id_feature_value` = mfel.`id_feature_value` AND mfel.`id_lang` = 1)
LEFT JOIN `ps_feature` f ON (f.`id_feature` = v.`id_feature`)
LEFT JOIN `ps_feature_lang` fl ON (fl.`id_feature` = f.`id_feature` AND fl.`id_lang` = 1)
WHERE fp.`id_product` = 466 ORDER BY f.`position` ASC, fp.`position` ASC
 1288 ms 23 Yes /modules/pm_multiplefeatures/pm_multiplefeatures.php:220 
SELECT SQL_NO_CACHE fp.id_feature, vl.value, fl.name, mfel.*, v.id_feature_value
FROM `ps_feature_product` fp
LEFT JOIN `ps_feature_value` v ON (fp.`id_feature_value` = v.`id_feature_value`)
LEFT JOIN `ps_feature_value_lang` vl ON (v.`id_feature_value` = vl.`id_feature_value` AND vl.`id_lang` = 1)
LEFT JOIN `ps_pm_mf_extra_lang` mfel ON (v.`id_feature_value` = mfel.`id_feature_value` AND mfel.`id_lang` = 1)
LEFT JOIN `ps_feature` f ON (f.`id_feature` = v.`id_feature`)
LEFT JOIN `ps_feature_lang` fl ON (fl.`id_feature` = f.`id_feature` AND fl.`id_lang` = 1)
WHERE fp.`id_product` = 239 ORDER BY f.`position` ASC, fp.`position` ASC
 934 ms 20 Yes /modules/pm_multiplefeatures/pm_multiplefeatures.php:220 
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
 848 ms 3 Yes Yes /modules/ets_megamenu/classes/Ets_megamenu_defines.php:178 
SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT cp.`quantity` as first_level_quantity, 0 as pack_quantity
FROM `ps_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 1019 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `ps_cart_product` cp JOIN `ps_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `ps_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 1019 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 847 ms 0 /classes/Cart.php:1429 
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=2261 AND c.id_category!=2261
GROUP BY c.id_category ORDER BY c.position ASC,c.id_category ASC
 842 ms 2 Yes Yes /modules/ets_megamenu/classes/Ets_megamenu_defines.php:149 
SELECT SQL_NO_CACHE 1 FROM `ps_specific_price` WHERE id_product = 393 LIMIT 1
 808 ms 1 /classes/SpecificPrice.php:420 
SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT cp.`quantity` as first_level_quantity, 0 as pack_quantity
FROM `ps_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 1052 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `ps_cart_product` cp JOIN `ps_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `ps_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 1052 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 805 ms 0 /classes/Cart.php:1429 
INSERT INTO `ps_guest` (`id_operating_system`, `id_web_browser`, `id_customer`, `javascript`, `screen_resolution_x`, `screen_resolution_y`, `screen_color`, `sun_java`, `adobe_flash`, `adobe_director`, `apple_quicktime`, `real_player`, `windows_media`, `accept_language`, `mobile_theme`) VALUES ('0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', 'en', '0')
 769 ms 1 /classes/ObjectModel.php:578