play_arrow
play_arrow

Stipa 'Pony Tails'

Graminée aux cheveux d'ange

Taille plante
0.50 m
Saisonnalite
Juillet à Août
Plein soleil
Plein soleil
Température
-10°c à -15°c
16,95 € TTC
Taille du Pot i
Quantité
En stock

local_shipping Livraison prévue à partir du 14/12/2023

Très décorative, cette graminée s’agite avec grâce au gré du vent. Cette belle touffe ornementale vert foncé présente des extrémités joliment teintées de rose en été.

En savoir plus
Frais de port offerts*
Dès 69€ d'achat
Paiement 100% sécurisé
Possible en 3 ou 4 fois sans frais
Livraison à domicile
en point relais ou drive
Détails du produit

Stipa tenuissima 'Pony Tails'

Très décorative, cette graminée s’agite avec grâce au gré du vent. Cette belle touffe ornementale vert foncé présente des extrémités joliment teintées de rose en été. Elle devient plus orangée en automne et en hiver. Pour un effet de légèreté, dans un jardin sauvage, contemporain… cette graminée trouve naturellement sa place.

STI0003-3L
523 Produits

Fiche technique

Hauteur
0.50
Largeur
0.30
Utilisation
Pot, Massif
Au top au mois de
Avril, Mai, Juin, Juillet, Août, Septembre, Octobre
Floraison
Juillet, Août
Exposition
Plein soleil
Rusticité
-10°c à -15°c
Sol
Calcaire
Type de feuillage
Caduc
Facilité entretien
2

Références spécifiques

ean13
3565240127759
mpn
12775
Caractéristiques
Taille plante
Hauteur : 0.50 m
Largeur plante
Largeur : 0.30 m
Plein soleil
Exposition :
Plein soleil
Température
Rusticité :
-10°c à -15°c
Sol
Sol :
Calcaire
Feuillage""
Feuillage :
Perd ses feuilles
Floraison
J
F
M
A
M
J
J
A
S
O
N
D
Stipa 'Pony Tails'
Avis à propos du produit
0
1★
0
2★
0
3★
0
4★
7
5★
10/10


Basé sur 7 avis

  • 5

    Très beau spécimen. A l'air d'apprécier le pot dans lequel elle a été installée. Exactement comme sur la photo.

  • 5

    Plante vigoureuse.

    Réponse du marchand

    Bonjour Patrick, merci pour votre message. Nous espérons que le Stipa se plaira dans son nouvel environnement. À bientôt sur notre site internet. Natacha

  • 5

    belle graminée

  • 5

    Excellente

  • 5

    Commande reçue en moins d’une semaine malgré le confinement et un jour férié, nickel! Plante très bien emballée.



Load Time 674 ms
Querying Time 359 ms
Queries 1632
Memory Peak Usage 92.8 Mb
Included Files 1140 files - 14.26 Mb
PrestaShop Cache - Mb
Global vars 1.06 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 26 ms 26 ms 7.20 Mb 7.3 Mb
__construct 0 ms 26 ms - Mb 7.3 Mb
init 25 ms 51 ms 4.58 Mb 11.9 Mb
checkAccess 0 ms 51 ms - Mb 11.9 Mb
setMedia 6 ms 57 ms 0.67 Mb 12.5 Mb
postProcess 0 ms 57 ms - Mb 12.5 Mb
initHeader 0 ms 57 ms - Mb 12.5 Mb
initContent 40 ms 96 ms 4.55 Mb 17.1 Mb
initFooter 0 ms 96 ms - Mb 17.1 Mb
display 578 ms 674 ms 74.71 Mb 92.8 Mb
Hook Time Memory Usage
DisplayNavFullWidth 473 ms 54.84 Mb
DisplayBlock 432 ms 51.83 Mb
displayFooterProduct 48 ms 5.62 Mb
DisplayProductPriceBlock 10 ms 1.44 Mb
DisplayHeader 9 ms 1.72 Mb
DisplaySpecifVal 8 ms 1.06 Mb
DisplayAfterTitle 4 ms 0.14 Mb
ActionGetProductPropertiesAfter 4 ms 0.46 Mb
Header 3 ms 0.18 Mb
DisplayBeforeBodyClosingTag 2 ms 0.17 Mb
ActionObjectUpdateAfter 2 ms 0.05 Mb
DisplayProductExtraContent 2 ms 0.16 Mb
ActionDispatcher 2 ms 0.39 Mb
displayTop 1 ms 0.09 Mb
displayFooter 1 ms 0.13 Mb
DisplayFooter 1 ms 0.15 Mb
ProductActions 1 ms 0.08 Mb
displayProductAdditionalInfo 1 ms 0.06 Mb
DisplayProductActions 0 ms 0.01 Mb
DisplayProductAdditionalInfo 0 ms 0.05 Mb
DisplayBanner 0 ms 0.04 Mb
ActionFrontControllerSetMedia 0 ms 0.01 Mb
ActionObjectAddAfter 0 ms - Mb
DisplayCustomMenu 0 ms 0.04 Mb
DisplayAfterBodyOpeningTag 0 ms 0.02 Mb
DisplayProductListReviews 0 ms 0.01 Mb
DisplayReassurance 0 ms - Mb
DisplayFooterProduct 0 ms - Mb
DisplayTop 0 ms - Mb
DisplayFooterBefore 0 ms - Mb
DisplayAfterProductThumbs 0 ms - Mb
DisplayFooterAfter 0 ms - Mb
ModuleRoutes 0 ms - Mb
33 hook(s) 1005 ms 118.77 Mb
Module Time Memory Usage
ps_hubspot 1 ms 0.21 Mb
kiliba 3 ms 0.18 Mb
geodisofficiel 34 ms 3.42 Mb
smplredirectionsmanager 2 ms 0.57 Mb
giftcard 0 ms 0.47 Mb
blockwishlist 1 ms 0.14 Mb
ps_emailsubscription 3 ms 0.14 Mb
ps_facebook 4 ms 0.41 Mb
blockreassurance 0 ms 0.03 Mb
ps_emailalerts 0 ms 0.04 Mb
paybox 1 ms 0.29 Mb
steavisgarantis 14 ms 1.78 Mb
pm_multiplefeatures 4 ms 0.49 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 0.01 Mb
psxmarketingwithgoogle 1 ms 0.09 Mb
ets_megamenu 911 ms 108.06 Mb
ps_customersignin 0 ms 0.04 Mb
doofinder 0 ms 0.04 Mb
ultimateimagetool 0 ms 0.18 Mb
storeggmap 0 ms 0.03 Mb
paypal 2 ms 0.26 Mb
pm_applepay 0 ms 0.13 Mb
chronopost 0 ms 0.04 Mb
lapostetracking 0 ms - 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.05 Mb
pasliderproj 0 ms 0.04 Mb
deliverydate 8 ms 1.20 Mb
cdc_googletagmanager 4 ms 0.20 Mb
pasliderpro3 0 ms 0.08 Mb
pasliderpro4 0 ms 0.04 Mb
iziflux 0 ms 0.02 Mb
ps_sharebuttons 1 ms 0.08 Mb
ps_categoryproducts 48 ms 5.63 Mb
ps_linklist 1 ms 0.10 Mb
ps_customeraccountlinks 0 ms 0.08 Mb
statsdata 2 ms 0.18 Mb
45 module(s) 1052 ms 125.22 Mb

Stopwatch SQL - 1632 queries

Query Time (ms) Rows Filesort Group By Location
SELECT SQL_NO_CACHE p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) AS quantity, IFNULL(product_attribute_shop.id_product_attribute, 0) AS id_product_attribute,
product_attribute_shop.minimal_quantity AS product_attribute_minimal_quantity, pl.`description`, pl.`description_short`, pl.`available_now`,
pl.`available_later`, pl.`link_rewrite`, pl.`meta_description`, pl.`meta_keywords`, pl.`meta_title`, pl.`name`, image_shop.`id_image` id_image,
il.`legend` as legend, m.`name` AS manufacturer_name, cl.`name` AS category_default,
DATEDIFF(product_shop.`date_add`, DATE_SUB("2023-12-11 00:00:00",
INTERVAL 30 DAY)) > 0 AS new, product_shop.price AS orderprice
FROM `ps_category_product` cp
LEFT JOIN `ps_product` p
ON p.`id_product` = cp.`id_product`
INNER JOIN ps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) LEFT JOIN `ps_product_attribute_shop` product_attribute_shop
ON (p.`id_product` = product_attribute_shop.`id_product` AND product_attribute_shop.`default_on` = 1 AND product_attribute_shop.id_shop=1)
LEFT JOIN ps_stock_available stock
ON (stock.id_product = `p`.id_product AND stock.id_product_attribute = 0 AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
LEFT JOIN `ps_category_lang` cl
ON (product_shop.`id_category_default` = cl.`id_category`
AND cl.`id_lang` = 1 AND cl.id_shop = 1 )
LEFT JOIN `ps_product_lang` pl
ON (p.`id_product` = pl.`id_product`
AND pl.`id_lang` = 1 AND pl.id_shop = 1 )
LEFT JOIN `ps_image_shop` image_shop
ON (image_shop.`id_product` = p.`id_product` AND image_shop.cover=1 AND image_shop.id_shop=1)
LEFT JOIN `ps_image_lang` il
ON (image_shop.`id_image` = il.`id_image`
AND il.`id_lang` = 1)
LEFT JOIN `ps_manufacturer` m
ON m.`id_manufacturer` = p.`id_manufacturer`
WHERE product_shop.`id_shop` = 1
AND cp.`id_category` = 2776 AND product_shop.`active` = 1 AND product_shop.`visibility` IN ("both", "catalog") ORDER BY RAND() LIMIT 5
2688 ms 58 Yes /classes/Category.php:1057
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`)
2112 ms 1169 /classes/Configuration.php:160
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`
1985 ms 200 Yes Yes /classes/Hook.php:1183
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
1921 ms 542 /classes/Hook.php:504
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
1694 ms 241 Yes /classes/Country.php:147
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
1574 ms 0 /classes/Hook.php:1243
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` = 2776
AND `active` = 1
AND cg.`id_group` =1
GROUP BY c.`id_category`
ORDER BY `level_depth` ASC, category_shop.`position` ASC
844 ms 12 Yes Yes /classes/Category.php:919
SELECT SQL_NO_CACHE * FROM `ps_state` ORDER BY `name` ASC
716 ms 352 Yes /classes/Country.php:154
(SELECT SQL_NO_CACHE * FROM `ps_cart_rule` cr
LEFT JOIN `ps_cart_rule_lang` crl ON (cr.`id_cart_rule` = crl.`id_cart_rule` AND crl.`id_lang` = 1)
WHERE (cr.`id_customer` = 0
OR (cr.`id_customer` = 0 AND (cr.`highlight` = 1 OR cr.`code` = "")))
AND NOW() BETWEEN cr.date_from AND cr.date_to
AND cr.`active` = 1
AND free_shipping = 1 AND carrier_restriction = 1)
705 ms 1 /classes/CartRule.php:444
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(2785,2786,2787,2788,2789,2790,2791)
AND cg.`id_group` IN (1)
GROUP BY c.id_category ORDER BY c.position ASC,c.id_category ASC
672 ms 7 Yes Yes /modules/ets_megamenu/classes/Ets_megamenu_defines.php:178
SELECT SQL_NO_CACHE b.*,bl.title,bl.title_link,bl.content,bl.image_link
FROM `ps_ets_mm_block` b
LEFT JOIN `ps_ets_mm_block_lang` bl
ON b.id_block=bl.id_block AND bl.id_lang=1
WHERE 1  AND b.id_column=44 
ORDER BY b.sort_order asc,bl.title asc
648 ms 1 Yes /modules/ets_megamenu/classes/MM_Block.php:617
SELECT SQL_NO_CACHE p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, pl.`description`, pl.`description_short`, pl.`link_rewrite`,
pl.`meta_description`, pl.`meta_keywords`, pl.`meta_title`, pl.`name`, pl.`available_now`, pl.`available_later`,
image_shop.`id_image` id_image, il.`legend`, m.`name` as manufacturer_name, cl.`name` AS category_default, IFNULL(product_attribute_shop.id_product_attribute, 0) id_product_attribute,
DATEDIFF(
p.`date_add`,
DATE_SUB(
"2023-12-11 00:00:00",
INTERVAL 30 DAY
)
) > 0 AS new
FROM `ps_accessory`
LEFT JOIN `ps_product` p ON p.`id_product` = `id_product_2`
INNER JOIN ps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_product_attribute_shop` product_attribute_shop
ON (p.`id_product` = product_attribute_shop.`id_product` AND product_attribute_shop.`default_on` = 1 AND product_attribute_shop.id_shop=1)
LEFT JOIN `ps_product_lang` pl ON (
p.`id_product` = pl.`id_product`
AND pl.`id_lang` = 1 AND pl.id_shop = 1 
)
LEFT JOIN `ps_category_lang` cl ON (
product_shop.`id_category_default` = cl.`id_category`
AND cl.`id_lang` = 1 AND cl.id_shop = 1 
)
LEFT JOIN `ps_image_shop` image_shop
ON (image_shop.`id_product` = p.`id_product` AND image_shop.cover=1 AND image_shop.id_shop=1)
LEFT JOIN `ps_image_lang` il ON (image_shop.`id_image` = il.`id_image` AND il.`id_lang` = 1)
LEFT JOIN `ps_manufacturer` m ON (p.`id_manufacturer`= m.`id_manufacturer`)
LEFT JOIN ps_stock_available stock
ON (stock.id_product = `p`.id_product AND stock.id_product_attribute = 0 AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
WHERE `id_product_1` = 1014 AND product_shop.`active` = 1 AND product_shop.`visibility` != 'none'
GROUP BY product_shop.id_product
646 ms 1 Yes /classes/Product.php:4639
SELECT SQL_NO_CACHE ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, agl.`public_name` AS public_group_name,
a.`id_attribute`, al.`name` AS attribute_name, a.`color` AS attribute_color, product_attribute_shop.`id_product_attribute`,
IFNULL(stock.quantity, 0) as quantity, product_attribute_shop.`price`, product_attribute_shop.`ecotax`, product_attribute_shop.`weight`,
product_attribute_shop.`default_on`, pa.`reference`, pa.`ean13`, pa.`mpn`, pa.`upc`, pa.`isbn`, product_attribute_shop.`unit_price_impact`,
product_attribute_shop.`minimal_quantity`, product_attribute_shop.`available_date`, ag.`group_type`
FROM `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
LEFT JOIN ps_stock_available stock
ON (stock.id_product = `pa`.id_product AND stock.id_product_attribute = IFNULL(`pa`.id_product_attribute, 0) AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
LEFT JOIN `ps_product_attribute_combination` pac ON (pac.`id_product_attribute` = pa.`id_product_attribute`)
LEFT JOIN `ps_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
LEFT JOIN `ps_attribute_group` ag ON (ag.`id_attribute_group` = a.`id_attribute_group`)
LEFT JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute`)
LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group`)
INNER JOIN ps_attribute_shop attribute_shop
ON (attribute_shop.id_attribute = a.id_attribute AND attribute_shop.id_shop = 1)
WHERE pa.`id_product` = 1014
AND al.`id_lang` = 1
AND agl.`id_lang` = 1
GROUP BY id_attribute_group, id_product_attribute
ORDER BY ag.`position` ASC, a.`position` ASC, agl.`name` ASC
645 ms 2 Yes Yes /classes/Product.php:4549
SELECT SQL_NO_CACHE `id_hook`, `name` FROM `ps_hook`
582 ms 911 /classes/Hook.php:1243
SELECT SQL_NO_CACHE p.*,
ps.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2023-12-11 00:00:00',
INTERVAL 30 DAY
)
) > 0) as new
FROM ps_product p
LEFT JOIN ps_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 1
LEFT JOIN ps_stock_available sa   ON sa.id_product = p.id_product
AND sa.id_shop = 1 LEFT JOIN ps_product_shop ps
ON ps.id_product = p.id_product
AND ps.id_shop = 1
WHERE p.id_product = 1545
LIMIT 1
579 ms 3 /classes/ProductAssembler.php:106
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
566 ms 3 Yes Yes /modules/ets_megamenu/classes/Ets_megamenu_defines.php:178
SELECT SQL_NO_CACHE p.*,
ps.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2023-12-11 00:00:00',
INTERVAL 30 DAY
)
) > 0) as new
FROM ps_product p
LEFT JOIN ps_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 1
LEFT JOIN ps_stock_available sa   ON sa.id_product = p.id_product
AND sa.id_shop = 1 LEFT JOIN ps_product_shop ps
ON ps.id_product = p.id_product
AND ps.id_shop = 1
WHERE p.id_product = 1328
LIMIT 1
557 ms 6 /classes/ProductAssembler.php:106
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
556 ms 11 Yes Yes /modules/ets_megamenu/classes/Ets_megamenu_defines.php:178
SELECT SQL_NO_CACHE *
FROM `ps_category` a0
LEFT JOIN `ps_category_lang` `a1` ON (a0.`id_category` = a1.`id_category`)
WHERE (a0.`nleft` < 376) AND (a0.`nright` > 401) AND (a1.`id_lang` = 1)
ORDER BY a0.`nleft` asc
552 ms 372 Yes /classes/PrestaShopCollection.php:381
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
550 ms 14 Yes Yes /modules/ets_megamenu/classes/Ets_megamenu_defines.php:178
SELECT SQL_NO_CACHE p.*,
ps.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2023-12-11 00:00:00',
INTERVAL 30 DAY
)
) > 0) as new
FROM ps_product p
LEFT JOIN ps_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 1
LEFT JOIN ps_stock_available sa   ON sa.id_product = p.id_product
AND sa.id_shop = 1 LEFT JOIN ps_product_shop ps
ON ps.id_product = p.id_product
AND ps.id_shop = 1
WHERE p.id_product = 1545
LIMIT 1
541 ms 3 /classes/ProductAssembler.php:106
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
JOIN `ps_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `ps_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1)
JOIN `ps_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (1328) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
532 ms 5 Yes Yes /classes/Product.php:4487
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')
529 ms 1 /classes/ObjectModel.php:578
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
528 ms 6 Yes Yes /modules/ets_megamenu/classes/Ets_megamenu_defines.php:178
SELECT SQL_NO_CACHE p.*,
ps.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2023-12-11 00:00:00',
INTERVAL 30 DAY
)
) > 0) as new
FROM ps_product p
LEFT JOIN ps_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 1
LEFT JOIN ps_stock_available sa   ON sa.id_product = p.id_product
AND sa.id_shop = 1 LEFT JOIN ps_product_shop ps
ON ps.id_product = p.id_product
AND ps.id_shop = 1
WHERE p.id_product = 1545
LIMIT 1
526 ms 3 /classes/ProductAssembler.php:106
SELECT SQL_NO_CACHE lower(name) as name
FROM `ps_hook` h
WHERE (h.active = 1)
521 ms 911 /classes/Hook.php:1283
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
505 ms 8 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
496 ms 6 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
496 ms 13 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
482 ms 13 Yes Yes /modules/ets_megamenu/classes/Ets_megamenu_defines.php:178
SELECT SQL_NO_CACHE ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, agl.`public_name` AS public_group_name,
a.`id_attribute`, al.`name` AS attribute_name, a.`color` AS attribute_color, product_attribute_shop.`id_product_attribute`,
IFNULL(stock.quantity, 0) as quantity, product_attribute_shop.`price`, product_attribute_shop.`ecotax`, product_attribute_shop.`weight`,
product_attribute_shop.`default_on`, pa.`reference`, pa.`ean13`, pa.`mpn`, pa.`upc`, pa.`isbn`, product_attribute_shop.`unit_price_impact`,
product_attribute_shop.`minimal_quantity`, product_attribute_shop.`available_date`, ag.`group_type`
FROM `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
LEFT JOIN ps_stock_available stock
ON (stock.id_product = `pa`.id_product AND stock.id_product_attribute = IFNULL(`pa`.id_product_attribute, 0) AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
LEFT JOIN `ps_product_attribute_combination` pac ON (pac.`id_product_attribute` = pa.`id_product_attribute`)
LEFT JOIN `ps_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
LEFT JOIN `ps_attribute_group` ag ON (ag.`id_attribute_group` = a.`id_attribute_group`)
LEFT JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute`)
LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group`)
INNER JOIN ps_attribute_shop attribute_shop
ON (attribute_shop.id_attribute = a.id_attribute AND attribute_shop.id_shop = 1)
WHERE pa.`id_product` = 1014
AND al.`id_lang` = 1
AND agl.`id_lang` = 1
AND product_attribute_shop.`id_product_attribute` = 2310 GROUP BY id_attribute_group, id_product_attribute
ORDER BY ag.`position` ASC, a.`position` ASC, agl.`name` ASC
479 ms 1 Yes Yes /classes/Product.php:4549
SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop`
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE `id_lang` = 1
AND c.`id_parent` = 2
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
478 ms 49 Yes Yes /classes/Category.php:1146
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
477 ms 5 Yes Yes /modules/ets_megamenu/classes/Ets_megamenu_defines.php:178
SELECT SQL_NO_CACHE ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, agl.`public_name` AS public_group_name,
a.`id_attribute`, al.`name` AS attribute_name, a.`color` AS attribute_color, product_attribute_shop.`id_product_attribute`,
IFNULL(stock.quantity, 0) as quantity, product_attribute_shop.`price`, product_attribute_shop.`ecotax`, product_attribute_shop.`weight`,
product_attribute_shop.`default_on`, pa.`reference`, pa.`ean13`, pa.`mpn`, pa.`upc`, pa.`isbn`, product_attribute_shop.`unit_price_impact`,
product_attribute_shop.`minimal_quantity`, product_attribute_shop.`available_date`, ag.`group_type`
FROM `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
LEFT JOIN ps_stock_available stock
ON (stock.id_product = `pa`.id_product AND stock.id_product_attribute = IFNULL(`pa`.id_product_attribute, 0) AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
LEFT JOIN `ps_product_attribute_combination` pac ON (pac.`id_product_attribute` = pa.`id_product_attribute`)
LEFT JOIN `ps_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
LEFT JOIN `ps_attribute_group` ag ON (ag.`id_attribute_group` = a.`id_attribute_group`)
LEFT JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute`)
LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group`)
INNER JOIN ps_attribute_shop attribute_shop
ON (attribute_shop.id_attribute = a.id_attribute AND attribute_shop.id_shop = 1)
WHERE pa.`id_product` = 1014
AND al.`id_lang` = 1
AND agl.`id_lang` = 1
AND product_attribute_shop.`id_product_attribute` = 2310 GROUP BY id_attribute_group, id_product_attribute
ORDER BY ag.`position` ASC, a.`position` ASC, agl.`name` ASC
472 ms 1 Yes Yes /classes/Product.php:4549
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
470 ms 14 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(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
465 ms 6 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
463 ms 11 Yes Yes /modules/ets_megamenu/classes/Ets_megamenu_defines.php:178
SELECT SQL_NO_CACHE b.*,bl.title,bl.title_link,bl.content,bl.image_link
FROM `ps_ets_mm_block` b
LEFT JOIN `ps_ets_mm_block_lang` bl
ON b.id_block=bl.id_block AND bl.id_lang=1
WHERE 1  AND b.id_column=37 
ORDER BY b.sort_order asc,bl.title asc
463 ms 2 Yes /modules/ets_megamenu/classes/MM_Block.php:617
SELECT SQL_NO_CACHE b.*,bl.title,bl.title_link,bl.content,bl.image_link
FROM `ps_ets_mm_block` b
LEFT JOIN `ps_ets_mm_block_lang` bl
ON b.id_block=bl.id_block AND bl.id_lang=1
WHERE 1  AND b.id_column=44 
ORDER BY b.sort_order asc,bl.title asc
459 ms 1 Yes /modules/ets_megamenu/classes/MM_Block.php:617
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
457 ms 10 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,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
457 ms 6 Yes Yes /modules/ets_megamenu/classes/Ets_megamenu_defines.php:178
SELECT SQL_NO_CACHE b.*,bl.title,bl.title_link,bl.content,bl.image_link
FROM `ps_ets_mm_block` b
LEFT JOIN `ps_ets_mm_block_lang` bl
ON b.id_block=bl.id_block AND bl.id_lang=1
WHERE 1  AND b.id_column=25 
ORDER BY b.sort_order asc,bl.title asc
456 ms 1 Yes /modules/ets_megamenu/classes/MM_Block.php:617
SELECT SQL_NO_CACHE b.*,bl.title,bl.title_link,bl.content,bl.image_link
FROM `ps_ets_mm_block` b
LEFT JOIN `ps_ets_mm_block_lang` bl
ON b.id_block=bl.id_block AND bl.id_lang=1
WHERE 1  AND b.id_column=1 
ORDER BY b.sort_order asc,bl.title asc
455 ms 3 Yes /modules/ets_megamenu/classes/MM_Block.php:617
SELECT SQL_NO_CACHE b.*,bl.title,bl.title_link,bl.content,bl.image_link
FROM `ps_ets_mm_block` b
LEFT JOIN `ps_ets_mm_block_lang` bl
ON b.id_block=bl.id_block AND bl.id_lang=1
WHERE 1  AND b.id_column=37 
ORDER BY b.sort_order asc,bl.title asc
454 ms 2 Yes /modules/ets_megamenu/classes/MM_Block.php:617
SELECT SQL_NO_CACHE ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, agl.`public_name` AS public_group_name,
a.`id_attribute`, al.`name` AS attribute_name, a.`color` AS attribute_color, product_attribute_shop.`id_product_attribute`,
IFNULL(stock.quantity, 0) as quantity, product_attribute_shop.`price`, product_attribute_shop.`ecotax`, product_attribute_shop.`weight`,
product_attribute_shop.`default_on`, pa.`reference`, pa.`ean13`, pa.`mpn`, pa.`upc`, pa.`isbn`, product_attribute_shop.`unit_price_impact`,
product_attribute_shop.`minimal_quantity`, product_attribute_shop.`available_date`, ag.`group_type`
FROM `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
LEFT JOIN ps_stock_available stock
ON (stock.id_product = `pa`.id_product AND stock.id_product_attribute = IFNULL(`pa`.id_product_attribute, 0) AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
LEFT JOIN `ps_product_attribute_combination` pac ON (pac.`id_product_attribute` = pa.`id_product_attribute`)
LEFT JOIN `ps_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
LEFT JOIN `ps_attribute_group` ag ON (ag.`id_attribute_group` = a.`id_attribute_group`)
LEFT JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute`)
LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group`)
INNER JOIN ps_attribute_shop attribute_shop
ON (attribute_shop.id_attribute = a.id_attribute AND attribute_shop.id_shop = 1)
WHERE pa.`id_product` = 1014
AND al.`id_lang` = 1
AND agl.`id_lang` = 1
AND product_attribute_shop.`id_product_attribute` = 2310 GROUP BY id_attribute_group, id_product_attribute
ORDER BY ag.`position` ASC, a.`position` ASC, agl.`name` ASC
451 ms 1 Yes Yes /classes/Product.php:4549
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
450 ms 6 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(2720,2721,2722,2723,2724)
AND cg.`id_group` IN (1)
GROUP BY c.id_category ORDER BY c.position ASC,c.id_category ASC
450 ms 5 Yes Yes /modules/ets_megamenu/classes/Ets_megamenu_defines.php:178
SELECT SQL_NO_CACHE p.*,
ps.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2023-12-11 00:00:00',
INTERVAL 30 DAY
)
) > 0) as new
FROM ps_product p
LEFT JOIN ps_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 1
LEFT JOIN ps_stock_available sa   ON sa.id_product = p.id_product
AND sa.id_shop = 1 LEFT JOIN ps_product_shop ps
ON ps.id_product = p.id_product
AND ps.id_shop = 1
WHERE p.id_product = 1293
LIMIT 1
449 ms 3 /classes/ProductAssembler.php:106
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
449 ms 8 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)
AND cg.`id_group` IN (1)
GROUP BY c.id_category ORDER BY c.position ASC,c.id_category ASC
447 ms 3 Yes Yes /modules/ets_megamenu/classes/Ets_megamenu_defines.php:178
SELECT SQL_NO_CACHE p.*,
ps.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2023-12-11 00:00:00',
INTERVAL 30 DAY
)
) > 0) as new
FROM ps_product p
LEFT JOIN ps_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 1
LEFT JOIN ps_stock_available sa   ON sa.id_product = p.id_product
AND sa.id_shop = 1 LEFT JOIN ps_product_shop ps
ON ps.id_product = p.id_product
AND ps.id_shop = 1
WHERE p.id_product = 1545
LIMIT 1
446 ms 3 /classes/ProductAssembler.php:106
SELECT SQL_NO_CACHE *
FROM `ps_tab` a0
LEFT JOIN `ps_tab_lang` `a1` ON (a0.`id_tab` = a1.`id_tab`)
WHERE (a0.`class_name` = 'AdminGeodisShipmentsGridPrint')
445 ms 233 /classes/PrestaShopCollection.php:381
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
443 ms 8 Yes Yes /modules/ets_megamenu/classes/Ets_megamenu_defines.php:178
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
JOIN `ps_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `ps_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1)
JOIN `ps_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (1545) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
439 ms 2 Yes Yes /classes/Product.php:4487
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` = 1545 ORDER BY f.`position` ASC, fp.`position` ASC
434 ms 25 Yes /modules/pm_multiplefeatures/pm_multiplefeatures.php:220
SELECT SQL_NO_CACHE c.*, cl.delay
FROM `ps_carrier` c
LEFT JOIN `ps_carrier_lang` cl ON (c.`id_carrier` = cl.`id_carrier` AND cl.`id_lang` = 1 AND cl.id_shop = 1 )
LEFT JOIN `ps_carrier_zone` cz ON (cz.`id_carrier` = c.`id_carrier`)LEFT JOIN `ps_zone` z ON (z.`id_zone` = 9)
INNER JOIN ps_carrier_shop carrier_shop
ON (carrier_shop.id_carrier = c.id_carrier AND carrier_shop.id_shop = 1)
WHERE c.`deleted` = 0 AND c.`active` = 1  AND cz.`id_zone` = 9 AND z.`active` = 1  AND EXISTS (SELECT 1 FROM ps_carrier_group
WHERE ps_carrier_group.id_carrier = c.id_carrier
AND id_group IN (1))  AND (c.is_module = 0 OR c.need_range = 1)  GROUP BY c.`id_carrier` ORDER BY c.`position` ASC
432 ms 6 Yes Yes /classes/Carrier.php:578
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(2709,2710,2711,2712,2714,2718)
AND cg.`id_group` IN (1)
GROUP BY c.id_category ORDER BY c.position ASC,c.id_category ASC
430 ms 6 Yes Yes /modules/ets_megamenu/classes/Ets_megamenu_defines.php:178
SELECT SQL_NO_CACHE *
FROM `ps_tab` a0
LEFT JOIN `ps_tab_lang` `a1` ON (a0.`id_tab` = a1.`id_tab`)
WHERE (a0.`class_name` = 'AdminParentOrders')
430 ms 233 /classes/PrestaShopCollection.php:381
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
430 ms 3 Yes Yes /modules/ets_megamenu/classes/Ets_megamenu_defines.php:178
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` = 1014 ORDER BY f.`position` ASC, fp.`position` ASC
429 ms 18 Yes /modules/pm_multiplefeatures/pm_multiplefeatures.php:220
SELECT SQL_NO_CACHE m.*,ml.title,ml.link,ml.bubble_text
FROM `ps_ets_mm_menu` m
INNER JOIN `ps_ets_mm_menu_shop` ms ON (m.id_menu =ms.id_menu AND ms.id_shop='1')            
LEFT JOIN `ps_ets_mm_menu_lang` ml
ON m.id_menu=ml.id_menu AND ml.id_lang=1
WHERE 1  AND m.enabled=1 
GROUP BY m.id_menu
ORDER BY m.sort_order asc,ml.title asc
427 ms 9 Yes Yes /modules/ets_megamenu/classes/MM_Menu.php:500
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
427 ms 6 Yes Yes /modules/ets_megamenu/classes/Ets_megamenu_defines.php:178
SELECT SQL_NO_CACHE b.*,bl.title,bl.title_link,bl.content,bl.image_link
FROM `ps_ets_mm_block` b
LEFT JOIN `ps_ets_mm_block_lang` bl
ON b.id_block=bl.id_block AND bl.id_lang=1
WHERE 1  AND b.id_column=12 
ORDER BY b.sort_order asc,bl.title asc
426 ms 3 Yes /modules/ets_megamenu/classes/MM_Block.php:617
SELECT SQL_NO_CACHE b.*,bl.title,bl.title_link,bl.content,bl.image_link
FROM `ps_ets_mm_block` b
LEFT JOIN `ps_ets_mm_block_lang` bl
ON b.id_block=bl.id_block AND bl.id_lang=1
WHERE 1  AND b.id_column=5 
ORDER BY b.sort_order asc,bl.title asc
425 ms 1 Yes /modules/ets_megamenu/classes/MM_Block.php:617
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
422 ms 6 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(2820,2821,2822,2826)
AND cg.`id_group` IN (1)
GROUP BY c.id_category ORDER BY c.position ASC,c.id_category ASC
419 ms 4 Yes Yes /modules/ets_megamenu/classes/Ets_megamenu_defines.php:178
SELECT SQL_NO_CACHE b.*,bl.title,bl.title_link,bl.content,bl.image_link
FROM `ps_ets_mm_block` b
LEFT JOIN `ps_ets_mm_block_lang` bl
ON b.id_block=bl.id_block AND bl.id_lang=1
WHERE 1  AND b.id_column=13 
ORDER BY b.sort_order asc,bl.title asc
418 ms 3 Yes /modules/ets_megamenu/classes/MM_Block.php:617
SELECT SQL_NO_CACHE b.*,bl.title,bl.title_link,bl.content,bl.image_link
FROM `ps_ets_mm_block` b
LEFT JOIN `ps_ets_mm_block_lang` bl
ON b.id_block=bl.id_block AND bl.id_lang=1
WHERE 1  AND b.id_column=20 
ORDER BY b.sort_order asc,bl.title asc
418 ms 1 Yes /modules/ets_megamenu/classes/MM_Block.php:617
SELECT SQL_NO_CACHE pa.*, product_attribute_shop.*
FROM `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
WHERE pa.`id_product` = 1328
GROUP BY pa.`id_product_attribute`
ORDER BY pa.`id_product_attribute`
416 ms 5 Yes Yes /classes/Product.php:2711
SELECT SQL_NO_CACHE *
FROM `ps_tab` a0
LEFT JOIN `ps_tab_lang` `a1` ON (a0.`id_tab` = a1.`id_tab`)
WHERE (a0.`class_name` = 'AdminGeodisInformation')
416 ms 233 /classes/PrestaShopCollection.php:381
SELECT SQL_NO_CACHE p.*,
ps.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2023-12-11 00:00:00',
INTERVAL 30 DAY
)
) > 0) as new
FROM ps_product p
LEFT JOIN ps_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 1
LEFT JOIN ps_stock_available sa   ON sa.id_product = p.id_product
AND sa.id_shop = 1 LEFT JOIN ps_product_shop ps
ON ps.id_product = p.id_product
AND ps.id_shop = 1
WHERE p.id_product = 1545
LIMIT 1
415 ms 3 /classes/ProductAssembler.php:106
SELECT SQL_NO_CACHE b.*,bl.title,bl.title_link,bl.content,bl.image_link
FROM `ps_ets_mm_block` b
LEFT JOIN `ps_ets_mm_block_lang` bl
ON b.id_block=bl.id_block AND bl.id_lang=1
WHERE 1  AND b.id_column=5 
ORDER BY b.sort_order asc,bl.title asc
413 ms 1 Yes /modules/ets_megamenu/classes/MM_Block.php:617
SELECT SQL_NO_CACHE p.*,
ps.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2023-12-11 00:00:00',
INTERVAL 30 DAY
)
) > 0) as new
FROM ps_product p
LEFT JOIN ps_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 1
LEFT JOIN ps_stock_available sa   ON sa.id_product = p.id_product
AND sa.id_shop = 1 LEFT JOIN ps_product_shop ps
ON ps.id_product = p.id_product
AND ps.id_shop = 1
WHERE p.id_product = 1328
LIMIT 1
412 ms 6 /classes/ProductAssembler.php:106
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
410 ms 8 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
409 ms 9 Yes Yes /modules/ets_megamenu/classes/Ets_megamenu_defines.php:178
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` = 941 ORDER BY f.`position` ASC, fp.`position` ASC
409 ms 28 Yes /modules/pm_multiplefeatures/pm_multiplefeatures.php:220
SELECT SQL_NO_CACHE b.*,bl.title,bl.title_link,bl.content,bl.image_link
FROM `ps_ets_mm_block` b
LEFT JOIN `ps_ets_mm_block_lang` bl
ON b.id_block=bl.id_block AND bl.id_lang=1
WHERE 1  AND b.id_column=10 
ORDER BY b.sort_order asc,bl.title asc
408 ms 3 Yes /modules/ets_megamenu/classes/MM_Block.php:617
SELECT SQL_NO_CACHE b.*,bl.title,bl.title_link,bl.content,bl.image_link
FROM `ps_ets_mm_block` b
LEFT JOIN `ps_ets_mm_block_lang` bl
ON b.id_block=bl.id_block AND bl.id_lang=1
WHERE 1  AND b.id_column=11 
ORDER BY b.sort_order asc,bl.title asc
408 ms 4 Yes /modules/ets_megamenu/classes/MM_Block.php:617
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(2709,2710,2711,2712,2714,2718)
AND cg.`id_group` IN (1)
GROUP BY c.id_category ORDER BY c.position ASC,c.id_category ASC
407 ms 6 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
407 ms 9 Yes Yes