Rhododendron 'Gomer Waterer'

Rhododendron à fleur blanc rosé

Taille plante
1.20 m
Saisonnalite
Mai à Juin
Mi ombre
Mi-ombre
Température
-10°c à -15°c
29,00 € TTC
Taille du Pot i
Quantité
En cours de production

Cette variété de Rhododendron nous emporte dans un élan de tendresse. Orné de boutons rose lilas, c’est en mai que l’on voit apparaître de jolis bouquets ronds, très denses, d’un

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

Rhododendron hybride 'Gomer Waterer'

Cette variété de Rhododendron nous emporte dans un élan de tendresse. Orné de boutons rose lilas, c’est en mai que l’on voit apparaître de jolis bouquets ronds, très denses, d’un blanc rosé très doux. Avec un cœur jaune brun appelé l’impériale, il se distingue par sa douceur. Les massifs de Rhododendrons proposent de multiples associations possibles. Une fois installés, ils sont des points de mire au moment de la floraison et, tout au long de l’année un beau fond de feuillage. Le Rhododendron Gomer Waterer, compact et buissonnant, apporte de la délicatesse à la composition et permet des contrastes intéressants.

RHO0003-5L

Fiche technique

Hauteur
1.20
Largeur
1
Couleur de fleur
Rose
Couleur de feuillage
Vert
Utilisation
Massif
Au top au mois de
Mai, Juin
Floraison
Mai, Juin
Exposition
Mi-ombre
Rusticité
-10°c à -15°c
Sol
Humifère, Acide, Frais, Drainé
Type de feuillage
Persistant
Facilité entretien
1

Références spécifiques

ean13
3565240121900
mpn
12190
Caractéristiques
Taille plante
Hauteur : 1.20 m
Largeur plante
Largeur : 1 m
Mi ombre
Exposition :
Mi-ombre
Température
Rusticité :
-10°c à -15°c
Sol
Sol :
Humifère, Acide, Frais, Drainé
Feuillage
Feuillage :
Garde ses feuilles
Floraison
J
F
M
A
M
J
J
A
S
O
N
D

Votre plante aimera aussi...

Ardoise rectangle
En Stock
Dès 2,15 €
(1 avis)
Load Time 694 ms
Querying Time 356 ms
Queries 1748
Memory Peak Usage 94.4 Mb
Included Files 1142 files - 14.34 Mb
PrestaShop Cache 0.01 Mb
Global vars 1.17 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 22 ms 22 ms 7.20 Mb 7.3 Mb
__construct 0 ms 22 ms - Mb 7.3 Mb
init 22 ms 44 ms 4.59 Mb 11.9 Mb
checkAccess 0 ms 44 ms - Mb 11.9 Mb
setMedia 5 ms 50 ms 0.67 Mb 12.5 Mb
postProcess 0 ms 50 ms - Mb 12.5 Mb
initHeader 0 ms 50 ms - Mb 12.5 Mb
initContent 52 ms 102 ms 5.40 Mb 18.0 Mb
initFooter 0 ms 102 ms - Mb 18.0 Mb
display 592 ms 694 ms 75.56 Mb 94.4 Mb
Hook Time Memory Usage
DisplayNavFullWidth 469 ms 54.73 Mb
DisplayBlock 426 ms 51.72 Mb
displayFooterProduct 52 ms 5.59 Mb
DisplayProductPriceBlock 12 ms 1.65 Mb
DisplaySpecifVal 9 ms 1.06 Mb
DisplayHeader 7 ms 1.51 Mb
ActionGetProductPropertiesAfter 5 ms 0.49 Mb
DisplayAfterTitle 4 ms 0.14 Mb
DisplayBeforeBodyClosingTag 3 ms 0.17 Mb
Header 2 ms 0.17 Mb
ActionObjectUpdateAfter 2 ms 0.05 Mb
displayTop 1 ms 0.09 Mb
ActionDispatcher 1 ms 0.39 Mb
displayFooter 1 ms 0.13 Mb
DisplayProductAdditionalInfo 1 ms 0.17 Mb
DisplayFooter 1 ms 0.15 Mb
displayProductAdditionalInfo 1 ms 0.06 Mb
DisplayProductActions 1 ms 0.01 Mb
DisplayProductExtraContent 0 ms 0.01 Mb
ProductActions 0 ms 0.05 Mb
DisplayBanner 0 ms 0.04 Mb
ActionObjectAddAfter 0 ms - Mb
DisplayCustomMenu 0 ms 0.04 Mb
ActionFrontControllerSetMedia 0 ms 0.01 Mb
DisplayGDPRConsent 0 ms 0.04 Mb
DisplayAfterBodyOpeningTag 0 ms 0.02 Mb
DisplayProductListReviews 0 ms 0.02 Mb
DisplayReassurance 0 ms - Mb
DisplayFooterProduct 0 ms - Mb
DisplayTop 0 ms - Mb
DisplayAfterProductThumbs 0 ms - Mb
DisplayFooterBefore 0 ms - Mb
DisplayFooterAfter 0 ms - Mb
ModuleRoutes 0 ms - Mb
34 hook(s) 999 ms 118.52 Mb
Module Time Memory Usage
ps_hubspot 1 ms 0.21 Mb
kiliba 3 ms 0.18 Mb
geodisofficiel 29 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 3 ms 0.30 Mb
blockreassurance 0 ms 0.03 Mb
ps_emailalerts 1 ms 0.16 Mb
paybox 1 ms 0.29 Mb
pm_multiplefeatures 5 ms 0.63 Mb
steavisgarantis 13 ms 1.83 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 0 ms 0.20 Mb
ets_megamenu 899 ms 107.84 Mb
ps_customersignin 0 ms 0.04 Mb
doofinder 0 ms 0.04 Mb
ultimateimagetool 0 ms 0.07 Mb
storeggmap 0 ms 0.03 Mb
paypal 2 ms 0.36 Mb
pm_applepay 0 ms 0.03 Mb
chronopost 0 ms 0.04 Mb
lapostetracking 0 ms 0.11 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 9 ms 1.09 Mb
cdc_googletagmanager 4 ms 0.31 Mb
pasliderpro3 0 ms 0.04 Mb
pasliderpro4 0 ms 0.08 Mb
iziflux 0 ms 0.02 Mb
psgdpr 0 ms 0.09 Mb
ps_sharebuttons 1 ms 0.08 Mb
ps_categoryproducts 52 ms 5.71 Mb
ps_linklist 1 ms 0.10 Mb
ps_customeraccountlinks 1 ms 0.08 Mb
statsdata 3 ms 0.18 Mb
46 module(s) 1040 ms 125.45 Mb

Stopwatch SQL - 1748 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` = 2248 AND product_shop.`active` = 1 AND product_shop.`visibility` IN ("both", "catalog") ORDER BY RAND() LIMIT 5
2694 ms 55 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`)
2571 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`
2220 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
2070 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
1999 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
1892 ms 0 /classes/Hook.php:1243
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` = 333 AND product_shop.`active` = 1 AND product_shop.`visibility` != 'none'
GROUP BY product_shop.id_product
923 ms 4 Yes /classes/Product.php:4639
SELECT SQL_NO_CACHE * FROM `ps_state` ORDER BY `name` ASC
851 ms 352 Yes /classes/Country.php:154
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` = 2248
AND `active` = 1
AND cg.`id_group` =1
GROUP BY c.`id_category`
ORDER BY `level_depth` ASC, category_shop.`position` ASC
800 ms 7 Yes Yes /classes/Category.php:919
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')
672 ms 1 /classes/ObjectModel.php:578
SELECT SQL_NO_CACHE `id_hook`, `name` FROM `ps_hook`
602 ms 911 /classes/Hook.php:1243
SELECT SQL_NO_CACHE lower(name) as name
FROM `ps_hook` h
WHERE (h.active = 1)
599 ms 911 /classes/Hook.php:1283
(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)
579 ms 1 /classes/CartRule.php:444
INSERT INTO `ps_connections` (`id_guest`, `id_page`, `ip_address`, `http_referer`, `id_shop`, `id_shop_group`, `date_add`) VALUES ('4226001', '1497', '752679309', '', '1', '1', '2023-12-11 16:41:01')
567 ms 1 /classes/ObjectModel.php:578
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
560 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(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
532 ms 14 Yes Yes /modules/ets_megamenu/classes/Ets_megamenu_defines.php:178
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
506 ms 49 Yes Yes /classes/Category.php:1146
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` = 333
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
506 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(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
499 ms 13 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
484 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(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
478 ms 11 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
476 ms 14 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=11 
ORDER BY b.sort_order asc,bl.title asc
474 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(2280,2282,2283,2281)
AND cg.`id_group` IN (1)
GROUP BY c.id_category ORDER BY c.position ASC,c.id_category ASC
471 ms 4 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
469 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=10 
ORDER BY b.sort_order asc,bl.title asc
467 ms 3 Yes /modules/ets_megamenu/classes/MM_Block.php:617
SELECT SQL_NO_CACHE DISTINCT a.`id_attribute`, a.`id_attribute_group`, al.`name` as `attribute`, agl.`name` as `group`,pa.`reference`, pa.`ean13`, pa.`isbn`, pa.`upc`, pa.`mpn`
FROM `ps_attribute` a
LEFT JOIN `ps_attribute_lang` al
ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1)
LEFT JOIN `ps_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
LEFT JOIN `ps_product_attribute_combination` pac
ON (a.`id_attribute` = pac.`id_attribute`)
LEFT JOIN `ps_product_attribute` pa
ON (pac.`id_product_attribute` = pa.`id_product_attribute`)
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)
INNER JOIN ps_attribute_shop attribute_shop
ON (attribute_shop.id_attribute = pac.id_attribute AND attribute_shop.id_shop = 1)
WHERE pa.`id_product` = 333
462 ms 1 /classes/Product.php:7435
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
460 ms 13 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=31 
ORDER BY b.sort_order asc,bl.title asc
460 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
WHERE c.active=1 AND  c.id_parent=2369 AND c.id_category!=2369
GROUP BY c.id_category ORDER BY c.position ASC,c.id_category ASC
455 ms 2 Yes Yes /modules/ets_megamenu/classes/Ets_megamenu_defines.php:149
SELECT SQL_NO_CACHE *
FROM `ps_category` a0
LEFT JOIN `ps_category_lang` `a1` ON (a0.`id_category` = a1.`id_category`)
WHERE (a0.`nleft` < 102) AND (a0.`nright` > 117) AND (a1.`id_lang` = 1)
ORDER BY a0.`nleft` asc
455 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(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
452 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(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,2698,2699,2700)
AND cg.`id_group` IN (1)
GROUP BY c.id_category ORDER BY c.position ASC,c.id_category ASC
448 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(2681,2684,2842,2843)
AND cg.`id_group` IN (1)
GROUP BY c.id_category ORDER BY c.position ASC,c.id_category ASC
447 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=30 
ORDER BY b.sort_order asc,bl.title asc
447 ms 1 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` = 333
AND al.`id_lang` = 1
AND agl.`id_lang` = 1
AND product_attribute_shop.`id_product_attribute` = 1599 GROUP BY id_attribute_group, id_product_attribute
ORDER BY ag.`position` ASC, a.`position` ASC, agl.`name` ASC
446 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(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
445 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 = 2711
LIMIT 1
444 ms 2 /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=10 
ORDER BY b.sort_order asc,bl.title asc
443 ms 3 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 = 2716
LIMIT 1
442 ms 2 /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(2302,2672,2673,2674,2675,2676,2677)
AND cg.`id_group` IN (1)
GROUP BY c.id_category ORDER BY c.position ASC,c.id_category ASC
441 ms 7 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
440 ms 9 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` = 333
AND al.`id_lang` = 1
AND agl.`id_lang` = 1
AND product_attribute_shop.`id_product_attribute` = 1599 GROUP BY id_attribute_group, id_product_attribute
ORDER BY ag.`position` ASC, a.`position` ASC, agl.`name` ASC
438 ms 1 Yes Yes /classes/Product.php:4549
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
437 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
436 ms 10 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=11 
ORDER BY b.sort_order asc,bl.title asc
435 ms 4 Yes /modules/ets_megamenu/classes/MM_Block.php:617
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 2118) AND (b.`id_shop` = 1) LIMIT 1
434 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(2652,2653,2654)
AND cg.`id_group` IN (1)
GROUP BY c.id_category ORDER BY c.position ASC,c.id_category ASC
433 ms 3 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=5 
ORDER BY b.sort_order asc,bl.title asc
430 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(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
427 ms 5 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=1 
ORDER BY b.sort_order asc,bl.title asc
427 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=44 
ORDER BY b.sort_order asc,bl.title asc
424 ms 1 Yes /modules/ets_megamenu/classes/MM_Block.php:617
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module`as `mshop`
FROM `ps_module` m
LEFT JOIN `ps_module_shop` ms
ON m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 1
421 ms 108 /classes/module/Module.php:340
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
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=16 
ORDER BY b.sort_order asc,bl.title asc
414 ms 1 Yes /modules/ets_megamenu/classes/MM_Block.php:617
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
414 ms 9 Yes Yes /modules/ets_megamenu/classes/MM_Menu.php:500
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=62 
ORDER BY b.sort_order asc,bl.title asc
413 ms 2 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 = 1545
LIMIT 1
411 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=29 
ORDER BY b.sort_order asc,bl.title asc
410 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(2652,2653,2654)
AND cg.`id_group` IN (1)
GROUP BY c.id_category ORDER BY c.position ASC,c.id_category ASC
409 ms 3 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
409 ms 2 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 = 342
LIMIT 1
409 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=1 
ORDER BY b.sort_order asc,bl.title asc
407 ms 3 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
406 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(2751,2650)
AND cg.`id_group` IN (1)
GROUP BY c.id_category ORDER BY c.position ASC,c.id_category ASC
403 ms 2 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=40 
ORDER BY b.sort_order asc,bl.title asc
401 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(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
400 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=5 
ORDER BY b.sort_order asc,bl.title asc
399 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=37 
ORDER BY b.sort_order asc,bl.title asc
398 ms 2 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(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
397 ms 6 Yes Yes /modules/ets_megamenu/classes/Ets_megamenu_defines.php:178
SELECT SQL_NO_CACHE DISTINCT a.`id_attribute`, a.`id_attribute_group`, al.`name` as `attribute`, agl.`name` as `group`,pa.`reference`, pa.`ean13`, pa.`isbn`, pa.`upc`, pa.`mpn`
FROM `ps_attribute` a
LEFT JOIN `ps_attribute_lang` al
ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1)
LEFT JOIN `ps_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
LEFT JOIN `ps_product_attribute_combination` pac
ON (a.`id_attribute` = pac.`id_attribute`)
LEFT JOIN `ps_product_attribute` pa
ON (pac.`id_product_attribute` = pa.`id_product_attribute`)
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)
INNER JOIN ps_attribute_shop attribute_shop
ON (attribute_shop.id_attribute = pac.id_attribute AND attribute_shop.id_shop = 1)
WHERE pa.`id_product` = 333
397 ms 1 /classes/Product.php:7435
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` = 333
AND al.`id_lang` = 1
AND agl.`id_lang` = 1
AND product_attribute_shop.`id_product_attribute` = 1599 GROUP BY id_attribute_group, id_product_attribute
ORDER BY ag.`position` ASC, a.`position` ASC, agl.`name` ASC
396 ms 1 Yes Yes /classes/Product.php:4549
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')
396 ms 233 /classes/PrestaShopCollection.php:381
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')
395 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 = 1328
LIMIT 1
393 ms 6 /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` = 'AdminParentOrders')
393 ms 233 /classes/PrestaShopCollection.php:381
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=51 
ORDER BY b.sort_order asc,bl.title asc
393 ms 2 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(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
393 ms 5 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(2681,2684,2842,2843)
AND cg.`id_group` IN (1)
GROUP BY c.id_category ORDER BY c.position ASC,c.id_category ASC
392 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=9 
ORDER BY b.sort_order asc,bl.title asc
392 ms 2 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 = 1545
LIMIT 1
392 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(2323,2322,2321,2320,2777,2778,2780)
AND cg.`id_group` IN (1)
GROUP BY c.id_category ORDER BY c.position ASC,c.id_category ASC
391 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=13 
ORDER BY b.sort_order asc,bl.title asc
390 ms 3 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(2695,2696,2697)
AND cg.`id_group` IN (1)
GROUP BY c.id_category ORDER BY c.position ASC,c.id_category ASC
388 ms 3 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
385 ms 9 Yes Yes /modules/ets_megamenu/classes/Ets_megamenu_defines.php:178