Μαυροσίσαμο εισαγωγής 500 γρ.

6,00 €
Με ΦΠΑ

ΜΑΥΡΟΣΟΥΣΑΜΟ

Ποσότητα

To Μαυροσούσαμο ή μαυροκούκι έχει ιδιότητες που βοηθούν τον οργανισμό να αμύνεται σε παθήσεις σαν το κρυολόγημα. Επιπλέον ενεργοποιεί το ανοσοποιητικό σύστημα και προλαμβάνει λοιμώξεις. Χρησιμοποιείται στην αρτοποιία, τη ζαχαροπλαστική, & τη μαγειρική. Το μαυροσούσαμο ή μαυροκούκι περιέχει πάνω από 100 θρεπτικά συστατικά, βιταμίνες, ιχνοστοιχεία και λιπαρά οξέα που είναι απαραίτητα για τον οργανισμό.

Δράσεις:

  • Αντιμικροβιακή δράση
  • Καταπολεμά τους μύκητες
  • Ρυθμίζει το σάκχαρο
  • Αντιφλεγμονώδης και αντιαλλεργική δράση
  • Σύμμαχος κατά του καρκίνου
  • Φίλος του πεπτικού συστήματος
  • Αγχολυτικές ιδιότητες

Product Details

SE-9500
20 αντικείμενα

Χαρακτηριστικά

Προέλευση
ΤΟΥΡΚΙΑ
Νέο
chat Σχόλια (0)
Δεν υπάρχουν κριτικές πελατών προς το παρόν.

Σχετικά Προϊόντα

Load Time 3021 ms
Querying Time 420 ms
Queries 1361
Memory Peak Usage 92.0 Mb
Included Files 1326 files - 15.48 Mb
PrestaShop Cache - Mb
Global vars 0.30 Mb
PrestaShop Version 8.1.4
PHP Version 7.4.33
MySQL Version 5.7.44
Memory Limit 8G
Max Execution Time 10000s
Smarty Cache disabled
Smarty Compilation force compile
  Time Cumulated Time Memory Usage Memory Peak Usage
config 79.741 ms 79.741 ms 24.64 Mb 25.0 Mb
__construct 0.041 ms 79.782 ms - Mb 25.0 Mb
init 109.402 ms 189.184 ms 9.55 Mb 34.2 Mb
checkAccess 0.001 ms 189.185 ms - Mb 34.2 Mb
setMedia 13.680 ms 202.865 ms 0.93 Mb 35.3 Mb
postProcess 0.003 ms 202.868 ms - Mb 35.3 Mb
initHeader 0.002 ms 202.870 ms - Mb 35.3 Mb
initContent 1026 ms 1229 ms 17.33 Mb 52.5 Mb
initFooter 0.003 ms 1229 ms - Mb 52.5 Mb
display 1792 ms 3021 ms 39.28 Mb 92.0 Mb
Hook Time Memory Usage
DorRelatedProduct 1106 ms 21.47 Mb
DisplayHeader 701.824 ms 5.90 Mb
DorFlipImages 505.043 ms 1.28 Mb
DisplayFooterProduct 191.554 ms 3.34 Mb
DorHeaderSearch 164.200 ms 11.22 Mb
displayProductListReviews 160.534 ms 0.28 Mb
DorCompare 116.154 ms 0.70 Mb
DisplayProductPriceBlock 79.191 ms 4.44 Mb
DisplayBeforeBodyClosingTag 61.492 ms 0.37 Mb
Dorwishlist 59.291 ms 0.12 Mb
displayNav2 16.931 ms 0.17 Mb
Header 10.886 ms 0.11 Mb
DorMegamenu 4.092 ms 0.05 Mb
DoradoFooter1 3.924 ms 0.11 Mb
DorVideoProduct 3.041 ms 0.06 Mb
DorCompareLink 1.958 ms 0.01 Mb
ActionFrontControllerSetMedia 1.949 ms 0.13 Mb
Dorwishlisttotal 1.945 ms 0.01 Mb
DoradoFooterAdv 1.937 ms 0.01 Mb
DorOrderTrackingTop 1.936 ms 0.01 Mb
Dorwishlistlink 1.883 ms 0.01 Mb
DorCompareTotal 1.687 ms 0.02 Mb
ActionDispatcherBefore 1.104 ms 0.09 Mb
DisplayAfterBodyOpeningTag 0.983 ms 0.01 Mb
DisplayAfterProductThumbs 0.714 ms 0.02 Mb
displayNav1 0.674 ms 0.09 Mb
DorTags 0.528 ms 0.01 Mb
DorTabVideoProduct 0.372 ms 0.02 Mb
DisplayNav2 0.285 ms 0.02 Mb
DorProductTags 0.248 ms 0.02 Mb
TabDorProductTags 0.211 ms 0.02 Mb
ActionOutputHTMLBefore 0.047 ms - Mb
ModuleRoutes 0.041 ms 0.01 Mb
DorRelatedProductByBrand 0.005 ms - Mb
34 hook(s) 3203 ms 50.17 Mb
Module Time Memory Usage
smartblog 22.662 ms 3.64 Mb
customfields 28.925 ms 0.46 Mb
ets_cfultimate 31.046 ms 1.96 Mb
g_cartreminder 4.446 ms 0.37 Mb
psxdesign 13.995 ms 3.20 Mb
ps_mbo 8.693 ms 1.75 Mb
ps_emailalerts 7.136 ms 0.39 Mb
b2bmarkt 2.346 ms 0.22 Mb
ps_facebook 615.304 ms 4.07 Mb
dor_themeoptions 540.454 ms 2.94 Mb
dorgallery 3.054 ms 1.53 Mb
dor_imageslider 3.301 ms 0.37 Mb
dor_managerblocks 7.429 ms 0.31 Mb
dor_megamenu 6.955 ms 0.46 Mb
dor_ajaxtabproductcategory 4.609 ms 0.53 Mb
dor_ajaxtabsidebar_product 2.722 ms 0.29 Mb
dor_videoproducts 4.109 ms 0.14 Mb
dor_instagram 0.726 ms 0.07 Mb
dorcompare 120.882 ms 0.93 Mb
dorverticalmenu 3.168 ms 0.32 Mb
dor_sourcetabproductcategory 3.687 ms 0.36 Mb
dor_advanceproduct 8.351 ms 0.78 Mb
dor_viewedproducts 0.955 ms 0.09 Mb
ets_manufacturerslider 1.310 ms 0.17 Mb
ets_cookie_banner 2.998 ms 0.13 Mb
restrictpaymentmethods 1.068 ms 0.11 Mb
lggoogleanalytics 15.432 ms 0.48 Mb
phgoogletagmanager 33.150 ms 0.71 Mb
ps_accounts 1.226 ms 0.10 Mb
productcomments 353.606 ms 3.89 Mb
ps_shoppingcart 6.537 ms 0.12 Mb
dor_searchcategories 164.771 ms 11.30 Mb
dor_ordertracking 2.606 ms 0.09 Mb
dorblocktags 1.724 ms 0.16 Mb
dor_productsamecategory 1107 ms 21.60 Mb
dorblockwishlist 69.575 ms 0.36 Mb
dor_dailydeals 1.975 ms 0.18 Mb
dor_bizproduct 1.691 ms 0.17 Mb
dor_testimonials 1.348 ms 0.21 Mb
smartbloghomelatestnews 0.901 ms 0.09 Mb
bestpriceanalytics 2.282 ms 0.06 Mb
productlabel 83.111 ms 4.77 Mb
freega4 3.139 ms 0.05 Mb
vivawalletsmartcheckout 7.069 ms 0.64 Mb
ps_languageselector 0.573 ms 0.13 Mb
ps_currencyselector 0.522 ms 0.07 Mb
ps_customersignin 10.979 ms 0.13 Mb
statsdata 59.898 ms 0.40 Mb
48 module(s) 3380 ms 71.31 Mb

Stopwatch SQL - 1361 queries

# Query Time (ms) Rows Filesort Group By Location
1357
INSERT INTO `ps_connections_source` (`id_connections`, `http_referer`, `request_uri`, `keywords`, `date_add`) VALUES ('3636363', '', 'farmadeals.com/3184-mayrosisamo-eisagogis-500-gr.html', '', '2024-02-29 09:33:15')
12.108 ms 1 /classes/ObjectModel.php:622
1356
INSERT IGNORE INTO `ps_connections_page` (`id_connections`, `id_page`, `time_start`) VALUES ('3636363', '597', '2024-02-29 09:33:15')
11.816 ms 1 /classes/Connection.php:122
1192
SELECT SQL_NO_CACHE p.id_product_label, p.id_type, p.priority, p.id_shop, IFNULL(p.start_date, "") as start_date, IFNULL(p.end_date, "") as end_date,
IFNULL(lt.text_content, IFNULL(lt2.text_content, NULL)) as label_text_content,
l.bg_color as label_bg_color, l.text_font as label_text_font, l.text_color as label_text_color,
l.text_size as label_text_size, l.position as label_position, l.is_resize as label_is_resize,
IFNULL(ba.id_background, IFNULL(ba2.id_background, NULL)) as id_background,
IFNULL(ba.image, IFNULL(ba2.image, NULL)) as image,
IFNULL(ba.is_perso, IFNULL(ba2.is_perso, NULL)) as is_perso,
IFNULL(ba.id_lang, IFNULL(ba2.id_lang, NULL)) as id_lang , bt.id_lang, IFNULL(bt.text_content, IFNULL(bt2.text_content, NULL)) as banner_text_content,
b.text_color as banner_text_color, b.bg_color as banner_bg_color FROM ps_productlabel as p LEFT JOIN ps_productlabel_banner as b ON b.id_product_label = p.id_product_label
LEFT JOIN ps_productlabel_banner_text as bt ON (bt.id_banner = b.id_banner AND bt.id_lang = 2)
LEFT JOIN ps_productlabel_banner_text as bt2 ON (bt2.id_banner = b.id_banner AND bt2.id_lang = 2) LEFT JOIN ps_productlabel_item as i ON i.id_product_label = p.id_product_label
LEFT JOIN ps_productlabel_label as l ON l.id_product_label = p.id_product_label
LEFT JOIN ps_productlabel_label_text as lt ON (lt.id_label = l.id_label AND lt.id_lang = 2)
LEFT JOIN ps_productlabel_label_text as lt2 ON (lt2.id_label = l.id_label AND lt2.id_lang = 2)
LEFT JOIN ps_productlabel_background as ba ON (ba.id_label = l.id_label AND ba.id_lang = 2)
LEFT JOIN ps_productlabel_background as ba2 ON (ba2.id_label = l.id_label AND ba2.id_lang = 2)
WHERE ((i.id_item = 2880 AND i.type_item = "Product") OR
(i.id_item = 275 AND i.type_item = "Category") OR
(i.type_item = "Category" AND i.id_item = (SELECT DISTINCT(cp.id_category) FROM ps_category_product as cp
WHERE cp.id_category = i.id_item AND cp.id_product = 2880)))
AND p.status = 1
AND p.id_shop = 1
AND ((start_date <= "2024-02-29" OR start_date = "0000-00-00")
AND (end_date >= "2024-02-29" OR end_date = "0000-00-00"))
ORDER BY p.priority ASC LIMIT 1
11.061 ms 2 Yes /modules/productlabel/classes/ProductLabelDAO.php:731
1355
INSERT INTO `ps_connections` (`id_guest`, `id_page`, `ip_address`, `http_referer`, `id_shop`, `id_shop_group`, `date_add`) VALUES ('4349139', '597', '586128073', '', '1', '1', '2024-02-29 09:33:14')
10.389 ms 1 /classes/ObjectModel.php:622
1360
INSERT INTO `ps_page_viewed` (`id_date_range`, `id_page`, `counter`, `id_shop`, `id_shop_group`) VALUES ('1354', '597', '1', '1', '1')
7.823 ms 1 /classes/Page.php:142
1359
UPDATE `ps_page_viewed`
SET `counter` = `counter` + 1
WHERE `id_date_range` = 1354
AND `id_page` = 597
AND `id_shop` = 1
7.166 ms 1 /classes/Page.php:131
1351
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')
6.554 ms 1 /classes/ObjectModel.php:622
2
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`)
5.918 ms 2354 /classes/Configuration.php:180
125
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "productcomments" LIMIT 1
4.700 ms 1 /classes/module/Module.php:2636
80
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` = 2)
LEFT JOIN `ps_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 2)
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` = 3184
4.258 ms 1 /classes/Product.php:7544
390
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 2
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 320) AND (b.`id_shop` = 1) LIMIT 1
4.187 ms 1 /src/Adapter/EntityMapper.php:71
391
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` = 2
AND c.`id_parent` = 320
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
3.811 ms 1 Yes Yes /classes/Category.php:1151
21
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
3.452 ms 131 /classes/module/Module.php:345
133
SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 18 AND `id_shop` = 1 LIMIT 1
3.227 ms 1 /classes/module/Module.php:2109
1
SELECT SQL_NO_CACHE gs.*, s.*, gs.name AS group_name, s.name AS shop_name, s.active, su.domain, su.domain_ssl, su.physical_uri, su.virtual_uri
FROM ps_shop_group gs
LEFT JOIN ps_shop s
ON s.id_shop_group = gs.id_shop_group
LEFT JOIN ps_shop_url su
ON s.id_shop = su.id_shop AND su.main = 1
WHERE s.deleted = 0
AND gs.deleted = 0
ORDER BY gs.name, s.name
2.926 ms 1 Yes /classes/shop/Shop.php:715
105
SELECT SQL_NO_CACHE COUNT(id_contact)
FROM `ps_ets_cfu_contact`
WHERE (button_popup_enabled > 0) LIMIT 1
2.881 ms 2 /modules/ets_cfultimate/classes/ETS_CFU_Contact.php:238
47
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
2.659 ms 660 /classes/Hook.php:456
32
SELECT SQL_NO_CACHE `id_lang` FROM `ps_lang`
WHERE `locale` = 'el-gr'
OR `language_code` = 'el-gr' LIMIT 1
2.647 ms 2 /classes/Language.php:883
46
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
2.522 ms 0 /classes/Hook.php:1292
31
SELECT SQL_NO_CACHE * FROM `ps_currency` c ORDER BY `iso_code` ASC
2.509 ms 1 Yes /classes/Currency.php:709
0
SELECT SQL_NO_CACHE s.id_shop, CONCAT(su.physical_uri, su.virtual_uri) AS uri, su.domain, su.main
FROM ps_shop_url su
LEFT JOIN ps_shop s ON (s.id_shop = su.id_shop)
WHERE (su.domain = 'farmadeals.com' OR su.domain_ssl = 'farmadeals.com')
AND s.active = 1
AND s.deleted = 0
ORDER BY LENGTH(CONCAT(su.physical_uri, su.virtual_uri)) DESC
2.206 ms 1 Yes /classes/shop/Shop.php:1364
13
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_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`
2.128 ms 1965 Yes Yes /classes/Hook.php:1233
591
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("2024-02-29 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` = 2 AND cl.id_shop = 1 )
LEFT JOIN `ps_product_lang` pl
ON (p.`id_product` = pl.`id_product`
AND pl.`id_lang` = 2 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` = 2)
LEFT JOIN `ps_manufacturer` m
ON m.`id_manufacturer` = p.`id_manufacturer`
WHERE product_shop.`id_shop` = 1
AND cp.`id_category` = 202 AND product_shop.`active` = 1 AND product_shop.`visibility` IN ("both", "catalog") ORDER BY cp.`position` ASC
LIMIT 0,30
1.965 ms 212 /classes/Category.php:1062
336
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 2
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 337) AND (b.`id_shop` = 1) LIMIT 1
1.928 ms 1 /src/Adapter/EntityMapper.php:71
218
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 2
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 310) AND (b.`id_shop` = 1) LIMIT 1
1.832 ms 1 /src/Adapter/EntityMapper.php:71
118
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `ps_image` i
INNER JOIN ps_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `ps_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 2)
WHERE i.`id_product` = 3184
ORDER BY `position`
1.805 ms 1 Yes /classes/Product.php:3545
575
SELECT SQL_NO_CACHE p.id_product_label, p.id_type, p.priority, p.id_shop, IFNULL(p.start_date, "") as start_date, IFNULL(p.end_date, "") as end_date,
IFNULL(lt.text_content, IFNULL(lt2.text_content, NULL)) as label_text_content,
l.bg_color as label_bg_color, l.text_font as label_text_font, l.text_color as label_text_color,
l.text_size as label_text_size, l.position as label_position, l.is_resize as label_is_resize,
IFNULL(ba.id_background, IFNULL(ba2.id_background, NULL)) as id_background,
IFNULL(ba.image, IFNULL(ba2.image, NULL)) as image,
IFNULL(ba.is_perso, IFNULL(ba2.is_perso, NULL)) as is_perso,
IFNULL(ba.id_lang, IFNULL(ba2.id_lang, NULL)) as id_lang , bt.id_lang, IFNULL(bt.text_content, IFNULL(bt2.text_content, NULL)) as banner_text_content,
b.text_color as banner_text_color, b.bg_color as banner_bg_color FROM ps_productlabel as p LEFT JOIN ps_productlabel_banner as b ON b.id_product_label = p.id_product_label
LEFT JOIN ps_productlabel_banner_text as bt ON (bt.id_banner = b.id_banner AND bt.id_lang = 2)
LEFT JOIN ps_productlabel_banner_text as bt2 ON (bt2.id_banner = b.id_banner AND bt2.id_lang = 2) LEFT JOIN ps_productlabel_item as i ON i.id_product_label = p.id_product_label
LEFT JOIN ps_productlabel_label as l ON l.id_product_label = p.id_product_label
LEFT JOIN ps_productlabel_label_text as lt ON (lt.id_label = l.id_label AND lt.id_lang = 2)
LEFT JOIN ps_productlabel_label_text as lt2 ON (lt2.id_label = l.id_label AND lt2.id_lang = 2)
LEFT JOIN ps_productlabel_background as ba ON (ba.id_label = l.id_label AND ba.id_lang = 2)
LEFT JOIN ps_productlabel_background as ba2 ON (ba2.id_label = l.id_label AND ba2.id_lang = 2)
WHERE ((i.id_item = 3184 AND i.type_item = "Product") OR
(i.id_item = 202 AND i.type_item = "Category") OR
(i.type_item = "Category" AND i.id_item = (SELECT DISTINCT(cp.id_category) FROM ps_category_product as cp
WHERE cp.id_category = i.id_item AND cp.id_product = 3184)))
AND p.status = 1
AND p.id_shop = 1
AND ((start_date <= "2024-02-29" OR start_date = "0000-00-00")
AND (end_date >= "2024-02-29" OR end_date = "0000-00-00"))
ORDER BY p.priority ASC LIMIT 1
1.753 ms 2 Yes /modules/productlabel/classes/ProductLabelDAO.php:731
793
SELECT SQL_NO_CACHE `reduction`
FROM `ps_product_group_reduction_cache`
WHERE `id_product` = 3041 AND `id_group` = 1 LIMIT 1
1.752 ms 0 /classes/GroupReduction.php:156
43
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` = 2
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 3184) AND (b.`id_shop` = 1) LIMIT 1
1.464 ms 1 /src/Adapter/EntityMapper.php:71
81
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(
"2024-02-29 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` = 2 AND pl.id_shop = 1 
)
LEFT JOIN `ps_category_lang` cl ON (
product_shop.`id_category_default` = cl.`id_category`
AND cl.`id_lang` = 2 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` = 2)
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` = 3184 AND product_shop.`active` = 1 AND product_shop.`visibility` != 'none'
GROUP BY product_shop.id_product
1.455 ms 1 Yes Yes /classes/Product.php:4685
12
SELECT SQL_NO_CACHE lower(name) as name
FROM `ps_hook` h
WHERE (h.active = 1)
1.276 ms 921 /classes/Hook.php:1332
1239
SELECT SQL_NO_CACHE p.id_product_label, p.id_type, a.attribute, a.attribute_value, p.priority, p.id_shop,
IFNULL(lt.text_content, IFNULL(lt2.text_content, NULL)) as label_text_content,
l.bg_color as label_bg_color, l.text_font as label_text_font, l.text_color as label_text_color,
l.text_size as label_text_size, l.position as label_position, l.is_resize as label_is_resize,
IFNULL(ba.id_background, IFNULL(ba2.id_background, NULL)) as id_background,
IFNULL(ba.image, IFNULL(ba2.image, NULL)) as image,
IFNULL(ba.is_perso, IFNULL(ba2.is_perso, NULL)) as is_perso,
IFNULL(ba.id_lang, IFNULL(ba2.id_lang, NULL)) as id_lang , bt.id_lang, IFNULL(bt.text_content, IFNULL(bt2.text_content, NULL)) as banner_text_content,
b.text_color as banner_text_color, b.bg_color as banner_bg_color
FROM ps_productlabel as p
LEFT JOIN ps_productlabel_banner as b ON b.id_product_label = p.id_product_label
LEFT JOIN ps_productlabel_banner_text as bt ON (bt.id_banner = b.id_banner AND bt.id_lang = 2)
LEFT JOIN ps_productlabel_banner_text as bt2 ON (bt2.id_banner = b.id_banner AND bt2.id_lang = 2) RIGHT JOIN ps_productlabel_attribute as a ON a.id_product_label = p.id_product_label
LEFT JOIN ps_productlabel_label as l ON l.id_product_label = p.id_product_label
LEFT JOIN ps_productlabel_label_text as lt ON (lt.id_label = l.id_label AND lt.id_lang = 2)
LEFT JOIN ps_productlabel_label_text as lt2 ON (lt2.id_label = l.id_label AND lt2.id_lang = 2)
LEFT JOIN ps_productlabel_background as ba ON (ba.id_label = l.id_label AND ba.id_lang = 2)
LEFT JOIN ps_productlabel_background as ba2 ON (ba2.id_label = l.id_label AND ba2.id_lang = 2)
WHERE p.id_type = 5
AND p.status = 1
AND p.id_shop = 1
ORDER BY p.priority ASC LIMIT 1
0.939 ms 1 Yes /modules/productlabel/classes/ProductLabelDAO.php:845
1277
SELECT SQL_NO_CACHE p.id_product_label, p.id_type, p.priority, p.id_shop, IFNULL(p.start_date, "") as start_date, IFNULL(p.end_date, "") as end_date,
IFNULL(lt.text_content, IFNULL(lt2.text_content, NULL)) as label_text_content,
l.bg_color as label_bg_color, l.text_font as label_text_font, l.text_color as label_text_color,
l.text_size as label_text_size, l.position as label_position, l.is_resize as label_is_resize,
IFNULL(ba.id_background, IFNULL(ba2.id_background, NULL)) as id_background,
IFNULL(ba.image, IFNULL(ba2.image, NULL)) as image,
IFNULL(ba.is_perso, IFNULL(ba2.is_perso, NULL)) as is_perso,
IFNULL(ba.id_lang, IFNULL(ba2.id_lang, NULL)) as id_lang , bt.id_lang, IFNULL(bt.text_content, IFNULL(bt2.text_content, NULL)) as banner_text_content,
b.text_color as banner_text_color, b.bg_color as banner_bg_color FROM ps_productlabel as p LEFT JOIN ps_productlabel_banner as b ON b.id_product_label = p.id_product_label
LEFT JOIN ps_productlabel_banner_text as bt ON (bt.id_banner = b.id_banner AND bt.id_lang = 2)
LEFT JOIN ps_productlabel_banner_text as bt2 ON (bt2.id_banner = b.id_banner AND bt2.id_lang = 2) LEFT JOIN ps_productlabel_item as i ON i.id_product_label = p.id_product_label
LEFT JOIN ps_productlabel_label as l ON l.id_product_label = p.id_product_label
LEFT JOIN ps_productlabel_label_text as lt ON (lt.id_label = l.id_label AND lt.id_lang = 2)
LEFT JOIN ps_productlabel_label_text as lt2 ON (lt2.id_label = l.id_label AND lt2.id_lang = 2)
LEFT JOIN ps_productlabel_background as ba ON (ba.id_label = l.id_label AND ba.id_lang = 2)
LEFT JOIN ps_productlabel_background as ba2 ON (ba2.id_label = l.id_label AND ba2.id_lang = 2)
WHERE ((i.id_item = 3150 AND i.type_item = "Product") OR
(i.id_item = 310 AND i.type_item = "Category") OR
(i.type_item = "Category" AND i.id_item = (SELECT DISTINCT(cp.id_category) FROM ps_category_product as cp
WHERE cp.id_category = i.id_item AND cp.id_product = 3150)))
AND p.status = 1
AND p.id_shop = 1
AND ((start_date <= "2024-02-29" OR start_date = "0000-00-00")
AND (end_date >= "2024-02-29" OR end_date = "0000-00-00"))
ORDER BY p.priority ASC LIMIT 1
0.867 ms 2 Yes /modules/productlabel/classes/ProductLabelDAO.php:731
1234
SELECT SQL_NO_CACHE p.id_product_label, p.id_type, p.priority, p.id_shop, IFNULL(p.start_date, "") as start_date, IFNULL(p.end_date, "") as end_date,
IFNULL(lt.text_content, IFNULL(lt2.text_content, NULL)) as label_text_content,
l.bg_color as label_bg_color, l.text_font as label_text_font, l.text_color as label_text_color,
l.text_size as label_text_size, l.position as label_position, l.is_resize as label_is_resize,
IFNULL(ba.id_background, IFNULL(ba2.id_background, NULL)) as id_background,
IFNULL(ba.image, IFNULL(ba2.image, NULL)) as image,
IFNULL(ba.is_perso, IFNULL(ba2.is_perso, NULL)) as is_perso,
IFNULL(ba.id_lang, IFNULL(ba2.id_lang, NULL)) as id_lang , bt.id_lang, IFNULL(bt.text_content, IFNULL(bt2.text_content, NULL)) as banner_text_content,
b.text_color as banner_text_color, b.bg_color as banner_bg_color FROM ps_productlabel as p LEFT JOIN ps_productlabel_banner as b ON b.id_product_label = p.id_product_label
LEFT JOIN ps_productlabel_banner_text as bt ON (bt.id_banner = b.id_banner AND bt.id_lang = 2)
LEFT JOIN ps_productlabel_banner_text as bt2 ON (bt2.id_banner = b.id_banner AND bt2.id_lang = 2) LEFT JOIN ps_productlabel_item as i ON i.id_product_label = p.id_product_label
LEFT JOIN ps_productlabel_label as l ON l.id_product_label = p.id_product_label
LEFT JOIN ps_productlabel_label_text as lt ON (lt.id_label = l.id_label AND lt.id_lang = 2)
LEFT JOIN ps_productlabel_label_text as lt2 ON (lt2.id_label = l.id_label AND lt2.id_lang = 2)
LEFT JOIN ps_productlabel_background as ba ON (ba.id_label = l.id_label AND ba.id_lang = 2)
LEFT JOIN ps_productlabel_background as ba2 ON (ba2.id_label = l.id_label AND ba2.id_lang = 2)
WHERE ((i.id_item = 3045 AND i.type_item = "Product") OR
(i.id_item = 311 AND i.type_item = "Category") OR
(i.type_item = "Category" AND i.id_item = (SELECT DISTINCT(cp.id_category) FROM ps_category_product as cp
WHERE cp.id_category = i.id_item AND cp.id_product = 3045)))
AND p.status = 1
AND p.id_shop = 1
AND ((start_date <= "2024-02-29" OR start_date = "0000-00-00")
AND (end_date >= "2024-02-29" OR end_date = "0000-00-00"))
ORDER BY p.priority ASC LIMIT 1
0.859 ms 2 Yes /modules/productlabel/classes/ProductLabelDAO.php:731
85
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position, fvl.id_feature_value
FROM ps_feature_product pf
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 2)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 2)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 2)
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 3184
ORDER BY f.position ASC
0.846 ms 3 Yes /classes/Product.php:6002
1088
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` = 2)
JOIN `ps_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (1582) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
0.842 ms 4 Yes Yes /classes/Product.php:4507
91
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`,
pal.`available_now`, pal.`available_later`
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_lang` pal
ON (
pa.`id_product_attribute` = pal.`id_product_attribute` AND
pal.`id_lang` = 2)
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` = 3184
AND al.`id_lang` = 2
AND agl.`id_lang` = 2
GROUP BY id_attribute_group, id_product_attribute
ORDER BY ag.`position` ASC, a.`position` ASC, agl.`name` ASC
0.828 ms 1 Yes Yes /classes/Product.php:4581
1174
SELECT SQL_NO_CACHE p.id_product_label, p.id_type, GROUP_CONCAT(CONCAT(a.attribute, ",", a.attribute_value) separator ";") as attr, p.priority, p.id_shop,
IFNULL(lt.text_content, IFNULL(lt2.text_content, NULL)) as label_text_content,
l.bg_color as label_bg_color, l.text_font as label_text_font, l.text_color as label_text_color,
l.text_size as label_text_size, l.position as label_position, l.is_resize as label_is_resize,
IFNULL(ba.id_background, IFNULL(ba2.id_background, NULL)) as id_background,
IFNULL(ba.image, IFNULL(ba2.image, NULL)) as image,
IFNULL(ba.is_perso, IFNULL(ba2.is_perso, NULL)) as is_perso,
IFNULL(ba.id_lang, IFNULL(ba2.id_lang, NULL)) as id_lang , bt.id_lang, IFNULL(bt.text_content, IFNULL(bt2.text_content, NULL)) as banner_text_content,
b.text_color as banner_text_color, b.bg_color as banner_bg_color FROM ps_productlabel as p LEFT JOIN ps_productlabel_banner as b ON b.id_product_label = p.id_product_label
LEFT JOIN ps_productlabel_banner_text as bt ON (bt.id_banner = b.id_banner AND bt.id_lang = 2)
LEFT JOIN ps_productlabel_banner_text as bt2 ON (bt2.id_banner = b.id_banner AND bt2.id_lang = 2) RIGHT JOIN ps_productlabel_attribute as a ON a.id_product_label = p.id_product_label
LEFT JOIN ps_productlabel_label as l ON l.id_product_label = p.id_product_label
LEFT JOIN ps_productlabel_label_text as lt ON (lt.id_label = l.id_label AND lt.id_lang = 2)
LEFT JOIN ps_productlabel_label_text as lt2 ON (lt2.id_label = l.id_label AND lt2.id_lang = 2)
LEFT JOIN ps_productlabel_background as ba ON (ba.id_label = l.id_label AND ba.id_lang = 2)
LEFT JOIN ps_productlabel_background as ba2 ON (ba2.id_label = l.id_label AND ba2.id_lang = 2)
WHERE p.id_type = 3
AND p.status = 1
AND p.id_shop = 1
GROUP BY p.id_product_label
ORDER BY p.priority ASC, p.id_product_label DESC LIMIT 1
0.826 ms 1 Yes /modules/productlabel/classes/ProductLabelDAO.php:908
197
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` = 2
AND c.`id_parent` = 295
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
0.818 ms 1 Yes Yes /classes/Category.php:1151
106
SELECT SQL_NO_CACHE c.id_contact FROM `ps_ets_cfu_contact` c
INNER JOIN `ps_ets_cfu_contact_shop` cs ON (c.id_contact= cs.id_contact)
LEFT JOIN `ps_ets_cfu_contact_lang` cl on (c.id_contact= cl.id_contact AND cl.id_lang="2")
WHERE c.active=1 AND c.hook like "%header%" AND cs.id_shop="1";
0.785 ms 8 /modules/ets_cfultimate/ets_cfultimate.php:1335
1358
SELECT SQL_NO_CACHE `id_date_range`, `time_end`
FROM `ps_date_range`
WHERE `time_end` = (SELECT MAX(`time_end`) FROM `ps_date_range`) LIMIT 1
0.771 ms 1716100 /classes/DateRange.php:60
84
SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT cp.`quantity` as first_level_quantity, 0 as pack_quantity
FROM `ps_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 3184 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `ps_cart_product` cp JOIN `ps_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `ps_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 3184 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
0.765 ms 0 /classes/Cart.php:1410
215
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` = 2
AND c.`id_parent` = 284
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
0.732 ms 3 Yes Yes /classes/Category.php:1151
72
SELECT SQL_NO_CACHE c.*, cl.`id_lang`, cl.`name`, cl.`description`, cl.`additional_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` = 2  AND cl.id_shop = 1 )
LEFT JOIN `ps_category_group` cg ON (cg.`id_category` = c.`id_category`)
WHERE `id_parent` = 202
AND `active` = 1
AND cg.`id_group` =1
GROUP BY c.`id_category`
ORDER BY `level_depth` ASC, category_shop.`position` ASC
0.732 ms 10 Yes Yes /classes/Category.php:924
392
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 2
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 321) AND (b.`id_shop` = 1) LIMIT 1
0.713 ms 1 /src/Adapter/EntityMapper.php:71
1097
SELECT SQL_NO_CACHE p.id_product_label, p.id_type, p.priority, p.id_shop, IFNULL(p.start_date, "") as start_date, IFNULL(p.end_date, "") as end_date,
IFNULL(lt.text_content, IFNULL(lt2.text_content, NULL)) as label_text_content,
l.bg_color as label_bg_color, l.text_font as label_text_font, l.text_color as label_text_color,
l.text_size as label_text_size, l.position as label_position, l.is_resize as label_is_resize,
IFNULL(ba.id_background, IFNULL(ba2.id_background, NULL)) as id_background,
IFNULL(ba.image, IFNULL(ba2.image, NULL)) as image,
IFNULL(ba.is_perso, IFNULL(ba2.is_perso, NULL)) as is_perso,
IFNULL(ba.id_lang, IFNULL(ba2.id_lang, NULL)) as id_lang , bt.id_lang, IFNULL(bt.text_content, IFNULL(bt2.text_content, NULL)) as banner_text_content,
b.text_color as banner_text_color, b.bg_color as banner_bg_color FROM ps_productlabel as p LEFT JOIN ps_productlabel_banner as b ON b.id_product_label = p.id_product_label
LEFT JOIN ps_productlabel_banner_text as bt ON (bt.id_banner = b.id_banner AND bt.id_lang = 2)
LEFT JOIN ps_productlabel_banner_text as bt2 ON (bt2.id_banner = b.id_banner AND bt2.id_lang = 2) LEFT JOIN ps_productlabel_item as i ON i.id_product_label = p.id_product_label
LEFT JOIN ps_productlabel_label as l ON l.id_product_label = p.id_product_label
LEFT JOIN ps_productlabel_label_text as lt ON (lt.id_label = l.id_label AND lt.id_lang = 2)
LEFT JOIN ps_productlabel_label_text as lt2 ON (lt2.id_label = l.id_label AND lt2.id_lang = 2)
LEFT JOIN ps_productlabel_background as ba ON (ba.id_label = l.id_label AND ba.id_lang = 2)
LEFT JOIN ps_productlabel_background as ba2 ON (ba2.id_label = l.id_label AND ba2.id_lang = 2)
WHERE ((i.id_item = 2060 AND i.type_item = "Product") OR
(i.id_item = 275 AND i.type_item = "Category") OR
(i.type_item = "Category" AND i.id_item = (SELECT DISTINCT(cp.id_category) FROM ps_category_product as cp
WHERE cp.id_category = i.id_item AND cp.id_product = 2060)))
AND p.status = 1
AND p.id_shop = 1
AND ((start_date <= "2024-02-29" OR start_date = "0000-00-00")
AND (end_date >= "2024-02-29" OR end_date = "0000-00-00"))
ORDER BY p.priority ASC LIMIT 1
0.692 ms 2 Yes /modules/productlabel/classes/ProductLabelDAO.php:731
1238
SELECT SQL_NO_CACHE p.id_product_label, p.id_type, GROUP_CONCAT(CONCAT(a.attribute, ",", a.attribute_value) separator ";") as attr, p.priority, p.id_shop,
IFNULL(lt.text_content, IFNULL(lt2.text_content, NULL)) as label_text_content,
l.bg_color as label_bg_color, l.text_font as label_text_font, l.text_color as label_text_color,
l.text_size as label_text_size, l.position as label_position, l.is_resize as label_is_resize,
IFNULL(ba.id_background, IFNULL(ba2.id_background, NULL)) as id_background,
IFNULL(ba.image, IFNULL(ba2.image, NULL)) as image,
IFNULL(ba.is_perso, IFNULL(ba2.is_perso, NULL)) as is_perso,
IFNULL(ba.id_lang, IFNULL(ba2.id_lang, NULL)) as id_lang , bt.id_lang, IFNULL(bt.text_content, IFNULL(bt2.text_content, NULL)) as banner_text_content,
b.text_color as banner_text_color, b.bg_color as banner_bg_color FROM ps_productlabel as p LEFT JOIN ps_productlabel_banner as b ON b.id_product_label = p.id_product_label
LEFT JOIN ps_productlabel_banner_text as bt ON (bt.id_banner = b.id_banner AND bt.id_lang = 2)
LEFT JOIN ps_productlabel_banner_text as bt2 ON (bt2.id_banner = b.id_banner AND bt2.id_lang = 2) RIGHT JOIN ps_productlabel_attribute as a ON a.id_product_label = p.id_product_label
LEFT JOIN ps_productlabel_label as l ON l.id_product_label = p.id_product_label
LEFT JOIN ps_productlabel_label_text as lt ON (lt.id_label = l.id_label AND lt.id_lang = 2)
LEFT JOIN ps_productlabel_label_text as lt2 ON (lt2.id_label = l.id_label AND lt2.id_lang = 2)
LEFT JOIN ps_productlabel_background as ba ON (ba.id_label = l.id_label AND ba.id_lang = 2)
LEFT JOIN ps_productlabel_background as ba2 ON (ba2.id_label = l.id_label AND ba2.id_lang = 2)
WHERE p.id_type = 3
AND p.status = 1
AND p.id_shop = 1
GROUP BY p.id_product_label
ORDER BY p.priority ASC, p.id_product_label DESC LIMIT 1
0.691 ms 1 Yes /modules/productlabel/classes/ProductLabelDAO.php:908
576
SELECT SQL_NO_CACHE p.id_product_label, p.id_type, a.attribute, a.attribute_value, p.priority, p.id_shop,
IFNULL(lt.text_content, IFNULL(lt2.text_content, NULL)) as label_text_content,
l.bg_color as label_bg_color, l.text_font as label_text_font, l.text_color as label_text_color,
l.text_size as label_text_size, l.position as label_position, l.is_resize as label_is_resize,
IFNULL(ba.id_background, IFNULL(ba2.id_background, NULL)) as id_background,
IFNULL(ba.image, IFNULL(ba2.image, NULL)) as image,
IFNULL(ba.is_perso, IFNULL(ba2.is_perso, NULL)) as is_perso,
IFNULL(ba.id_lang, IFNULL(ba2.id_lang, NULL)) as id_lang , bt.id_lang, IFNULL(bt.text_content, IFNULL(bt2.text_content, NULL)) as banner_text_content,
b.text_color as banner_text_color, b.bg_color as banner_bg_color FROM ps_productlabel as p LEFT JOIN ps_productlabel_banner as b ON b.id_product_label = p.id_product_label
LEFT JOIN ps_productlabel_banner_text as bt ON (bt.id_banner = b.id_banner AND bt.id_lang = 2)
LEFT JOIN ps_productlabel_banner_text as bt2 ON (bt2.id_banner = b.id_banner AND bt2.id_lang = 2) RIGHT JOIN ps_productlabel_attribute as a ON a.id_product_label = p.id_product_label
LEFT JOIN ps_productlabel_label as l ON l.id_product_label = p.id_product_label
LEFT JOIN ps_productlabel_label_text as lt ON (lt.id_label = l.id_label AND lt.id_lang = 2)
LEFT JOIN ps_productlabel_label_text as lt2 ON (lt2.id_label = l.id_label AND lt2.id_lang = 2)
LEFT JOIN ps_productlabel_background as ba ON (ba.id_label = l.id_label AND ba.id_lang = 2)
LEFT JOIN ps_productlabel_background as ba2 ON (ba2.id_label = l.id_label AND ba2.id_lang = 2)
WHERE p.id_type = 2
AND p.status = 1
AND p.id_shop = 1
ORDER BY p.priority ASC LIMIT 1
0.676 ms 1 Yes /modules/productlabel/classes/ProductLabelDAO.php:780
1226
SELECT SQL_NO_CACHE p.id_product_label, p.id_type, p.priority, p.id_shop, IFNULL(p.start_date, "") as start_date, IFNULL(p.end_date, "") as end_date,
IFNULL(lt.text_content, IFNULL(lt2.text_content, NULL)) as label_text_content,
l.bg_color as label_bg_color, l.text_font as label_text_font, l.text_color as label_text_color,
l.text_size as label_text_size, l.position as label_position, l.is_resize as label_is_resize,
IFNULL(ba.id_background, IFNULL(ba2.id_background, NULL)) as id_background,
IFNULL(ba.image, IFNULL(ba2.image, NULL)) as image,
IFNULL(ba.is_perso, IFNULL(ba2.is_perso, NULL)) as is_perso,
IFNULL(ba.id_lang, IFNULL(ba2.id_lang, NULL)) as id_lang , bt.id_lang, IFNULL(bt.text_content, IFNULL(bt2.text_content, NULL)) as banner_text_content,
b.text_color as banner_text_color, b.bg_color as banner_bg_color FROM ps_productlabel as p LEFT JOIN ps_productlabel_banner as b ON b.id_product_label = p.id_product_label
LEFT JOIN ps_productlabel_banner_text as bt ON (bt.id_banner = b.id_banner AND bt.id_lang = 2)
LEFT JOIN ps_productlabel_banner_text as bt2 ON (bt2.id_banner = b.id_banner AND bt2.id_lang = 2) LEFT JOIN ps_productlabel_item as i ON i.id_product_label = p.id_product_label
LEFT JOIN ps_productlabel_label as l ON l.id_product_label = p.id_product_label
LEFT JOIN ps_productlabel_label_text as lt ON (lt.id_label = l.id_label AND lt.id_lang = 2)
LEFT JOIN ps_productlabel_label_text as lt2 ON (lt2.id_label = l.id_label AND lt2.id_lang = 2)
LEFT JOIN ps_productlabel_background as ba ON (ba.id_label = l.id_label AND ba.id_lang = 2)
LEFT JOIN ps_productlabel_background as ba2 ON (ba2.id_label = l.id_label AND ba2.id_lang = 2)
WHERE ((i.id_item = 3044 AND i.type_item = "Product") OR
(i.id_item = 311 AND i.type_item = "Category") OR
(i.type_item = "Category" AND i.id_item = (SELECT DISTINCT(cp.id_category) FROM ps_category_product as cp
WHERE cp.id_category = i.id_item AND cp.id_product = 3044)))
AND p.status = 1
AND p.id_shop = 1
AND ((start_date <= "2024-02-29" OR start_date = "0000-00-00")
AND (end_date >= "2024-02-29" OR end_date = "0000-00-00"))
ORDER BY p.priority ASC LIMIT 1
0.675 ms 2 Yes /modules/productlabel/classes/ProductLabelDAO.php:731
1204
SELECT SQL_NO_CACHE p.id_product_label, p.id_type, p.priority, p.id_shop, IFNULL(p.start_date, "") as start_date, IFNULL(p.end_date, "") as end_date,
IFNULL(lt.text_content, IFNULL(lt2.text_content, NULL)) as label_text_content,
l.bg_color as label_bg_color, l.text_font as label_text_font, l.text_color as label_text_color,
l.text_size as label_text_size, l.position as label_position, l.is_resize as label_is_resize,
IFNULL(ba.id_background, IFNULL(ba2.id_background, NULL)) as id_background,
IFNULL(ba.image, IFNULL(ba2.image, NULL)) as image,
IFNULL(ba.is_perso, IFNULL(ba2.is_perso, NULL)) as is_perso,
IFNULL(ba.id_lang, IFNULL(ba2.id_lang, NULL)) as id_lang , bt.id_lang, IFNULL(bt.text_content, IFNULL(bt2.text_content, NULL)) as banner_text_content,
b.text_color as banner_text_color, b.bg_color as banner_bg_color FROM ps_productlabel as p LEFT JOIN ps_productlabel_banner as b ON b.id_product_label = p.id_product_label
LEFT JOIN ps_productlabel_banner_text as bt ON (bt.id_banner = b.id_banner AND bt.id_lang = 2)
LEFT JOIN ps_productlabel_banner_text as bt2 ON (bt2.id_banner = b.id_banner AND bt2.id_lang = 2) LEFT JOIN ps_productlabel_item as i ON i.id_product_label = p.id_product_label
LEFT JOIN ps_productlabel_label as l ON l.id_product_label = p.id_product_label
LEFT JOIN ps_productlabel_label_text as lt ON (lt.id_label = l.id_label AND lt.id_lang = 2)
LEFT JOIN ps_productlabel_label_text as lt2 ON (lt2.id_label = l.id_label AND lt2.id_lang = 2)
LEFT JOIN ps_productlabel_background as ba ON (ba.id_label = l.id_label AND ba.id_lang = 2)
LEFT JOIN ps_productlabel_background as ba2 ON (ba2.id_label = l.id_label AND ba2.id_lang = 2)
WHERE ((i.id_item = 3009 AND i.type_item = "Product") OR
(i.id_item = 275 AND i.type_item = "Category") OR
(i.type_item = "Category" AND i.id_item = (SELECT DISTINCT(cp.id_category) FROM ps_category_product as cp
WHERE cp.id_category = i.id_item AND cp.id_product = 3009)))
AND p.status = 1
AND p.id_shop = 1
AND ((start_date <= "2024-02-29" OR start_date = "0000-00-00")
AND (end_date >= "2024-02-29" OR end_date = "0000-00-00"))
ORDER BY p.priority ASC LIMIT 1
0.658 ms 2 Yes /modules/productlabel/classes/ProductLabelDAO.php:731
23
SELECT SQL_NO_CACHE m.page, ml.url_rewrite, ml.id_lang
FROM `ps_meta` m
LEFT JOIN `ps_meta_lang` ml ON (m.id_meta = ml.id_meta AND ml.id_shop = 1 )
ORDER BY LENGTH(ml.url_rewrite) DESC
0.640 ms 154 Yes /classes/Dispatcher.php:654
1219
SELECT SQL_NO_CACHE p.id_product_label, p.id_type, p.priority, p.id_shop, IFNULL(p.start_date, "") as start_date, IFNULL(p.end_date, "") as end_date,
IFNULL(lt.text_content, IFNULL(lt2.text_content, NULL)) as label_text_content,
l.bg_color as label_bg_color, l.text_font as label_text_font, l.text_color as label_text_color,
l.text_size as label_text_size, l.position as label_position, l.is_resize as label_is_resize,
IFNULL(ba.id_background, IFNULL(ba2.id_background, NULL)) as id_background,
IFNULL(ba.image, IFNULL(ba2.image, NULL)) as image,
IFNULL(ba.is_perso, IFNULL(ba2.is_perso, NULL)) as is_perso,
IFNULL(ba.id_lang, IFNULL(ba2.id_lang, NULL)) as id_lang , bt.id_lang, IFNULL(bt.text_content, IFNULL(bt2.text_content, NULL)) as banner_text_content,
b.text_color as banner_text_color, b.bg_color as banner_bg_color FROM ps_productlabel as p LEFT JOIN ps_productlabel_banner as b ON b.id_product_label = p.id_product_label
LEFT JOIN ps_productlabel_banner_text as bt ON (bt.id_banner = b.id_banner AND bt.id_lang = 2)
LEFT JOIN ps_productlabel_banner_text as bt2 ON (bt2.id_banner = b.id_banner AND bt2.id_lang = 2) LEFT JOIN ps_productlabel_item as i ON i.id_product_label = p.id_product_label
LEFT JOIN ps_productlabel_label as l ON l.id_product_label = p.id_product_label
LEFT JOIN ps_productlabel_label_text as lt ON (lt.id_label = l.id_label AND lt.id_lang = 2)
LEFT JOIN ps_productlabel_label_text as lt2 ON (lt2.id_label = l.id_label AND lt2.id_lang = 2)
LEFT JOIN ps_productlabel_background as ba ON (ba.id_label = l.id_label AND ba.id_lang = 2)
LEFT JOIN ps_productlabel_background as ba2 ON (ba2.id_label = l.id_label AND ba2.id_lang = 2)
WHERE ((i.id_item = 3043 AND i.type_item = "Product") OR
(i.id_item = 310 AND i.type_item = "Category") OR
(i.type_item = "Category" AND i.id_item = (SELECT DISTINCT(cp.id_category) FROM ps_category_product as cp
WHERE cp.id_category = i.id_item AND cp.id_product = 3043)))
AND p.status = 1
AND p.id_shop = 1
AND ((start_date <= "2024-02-29" OR start_date = "0000-00-00")
AND (end_date >= "2024-02-29" OR end_date = "0000-00-00"))
ORDER BY p.priority ASC LIMIT 1
0.629 ms 2 Yes /modules/productlabel/classes/ProductLabelDAO.php:731
120
SELECT SQL_NO_CACHE c.id_category, cl.name, c.id_parent
FROM `ps_category` c
LEFT JOIN `ps_category_lang` `cl` ON cl.id_category = c.id_category AND cl.id_shop = 1
WHERE (cl.id_lang = 2)
ORDER BY cl.id_category
0.621 ms 300 /modules/ps_facebook/classes/Repository/GoogleCategoryRepository.php:309
1256
SELECT SQL_NO_CACHE p.id_product_label, p.id_type, p.priority, p.id_shop, IFNULL(p.start_date, "") as start_date, IFNULL(p.end_date, "") as end_date,
IFNULL(lt.text_content, IFNULL(lt2.text_content, NULL)) as label_text_content,
l.bg_color as label_bg_color, l.text_font as label_text_font, l.text_color as label_text_color,
l.text_size as label_text_size, l.position as label_position, l.is_resize as label_is_resize,
IFNULL(ba.id_background, IFNULL(ba2.id_background, NULL)) as id_background,
IFNULL(ba.image, IFNULL(ba2.image, NULL)) as image,
IFNULL(ba.is_perso, IFNULL(ba2.is_perso, NULL)) as is_perso,
IFNULL(ba.id_lang, IFNULL(ba2.id_lang, NULL)) as id_lang , bt.id_lang, IFNULL(bt.text_content, IFNULL(bt2.text_content, NULL)) as banner_text_content,
b.text_color as banner_text_color, b.bg_color as banner_bg_color FROM ps_productlabel as p LEFT JOIN ps_productlabel_banner as b ON b.id_product_label = p.id_product_label
LEFT JOIN ps_productlabel_banner_text as bt ON (bt.id_banner = b.id_banner AND bt.id_lang = 2)
LEFT JOIN ps_productlabel_banner_text as bt2 ON (bt2.id_banner = b.id_banner AND bt2.id_lang = 2) LEFT JOIN ps_productlabel_item as i ON i.id_product_label = p.id_product_label
LEFT JOIN ps_productlabel_label as l ON l.id_product_label = p.id_product_label
LEFT JOIN ps_productlabel_label_text as lt ON (lt.id_label = l.id_label AND lt.id_lang = 2)
LEFT JOIN ps_productlabel_label_text as lt2 ON (lt2.id_label = l.id_label AND lt2.id_lang = 2)
LEFT JOIN ps_productlabel_background as ba ON (ba.id_label = l.id_label AND ba.id_lang = 2)
LEFT JOIN ps_productlabel_background as ba2 ON (ba2.id_label = l.id_label AND ba2.id_lang = 2)
WHERE ((i.id_item = 3139 AND i.type_item = "Product") OR
(i.id_item = 388 AND i.type_item = "Category") OR
(i.type_item = "Category" AND i.id_item = (SELECT DISTINCT(cp.id_category) FROM ps_category_product as cp
WHERE cp.id_category = i.id_item AND cp.id_product = 3139)))
AND p.status = 1
AND p.id_shop = 1
AND ((start_date <= "2024-02-29" OR start_date = "0000-00-00")
AND (end_date >= "2024-02-29" OR end_date = "0000-00-00"))
ORDER BY p.priority ASC LIMIT 1
0.618 ms 2 Yes /modules/productlabel/classes/ProductLabelDAO.php:731
574
SELECT SQL_NO_CACHE c.id_contact FROM `ps_ets_cfu_contact` c
INNER JOIN `ps_ets_cfu_contact_shop` cs ON (c.id_contact= cs.id_contact)
LEFT JOIN `ps_ets_cfu_contact_lang` cl on (c.id_contact= cl.id_contact AND cl.id_lang="2")
WHERE c.active=1 AND c.hook like "%product_thumbs%" AND cs.id_shop="1";
0.614 ms 8 /modules/ets_cfultimate/ets_cfultimate.php:1335
69
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
0.610 ms 131 /classes/module/Module.php:345
1270
SELECT SQL_NO_CACHE p.id_product_label, p.id_type, p.priority, p.id_shop, IFNULL(p.start_date, "") as start_date, IFNULL(p.end_date, "") as end_date,
IFNULL(lt.text_content, IFNULL(lt2.text_content, NULL)) as label_text_content,
l.bg_color as label_bg_color, l.text_font as label_text_font, l.text_color as label_text_color,
l.text_size as label_text_size, l.position as label_position, l.is_resize as label_is_resize,
IFNULL(ba.id_background, IFNULL(ba2.id_background, NULL)) as id_background,
IFNULL(ba.image, IFNULL(ba2.image, NULL)) as image,
IFNULL(ba.is_perso, IFNULL(ba2.is_perso, NULL)) as is_perso,
IFNULL(ba.id_lang, IFNULL(ba2.id_lang, NULL)) as id_lang , bt.id_lang, IFNULL(bt.text_content, IFNULL(bt2.text_content, NULL)) as banner_text_content,
b.text_color as banner_text_color, b.bg_color as banner_bg_color FROM ps_productlabel as p LEFT JOIN ps_productlabel_banner as b ON b.id_product_label = p.id_product_label
LEFT JOIN ps_productlabel_banner_text as bt ON (bt.id_banner = b.id_banner AND bt.id_lang = 2)
LEFT JOIN ps_productlabel_banner_text as bt2 ON (bt2.id_banner = b.id_banner AND bt2.id_lang = 2) LEFT JOIN ps_productlabel_item as i ON i.id_product_label = p.id_product_label
LEFT JOIN ps_productlabel_label as l ON l.id_product_label = p.id_product_label
LEFT JOIN ps_productlabel_label_text as lt ON (lt.id_label = l.id_label AND lt.id_lang = 2)
LEFT JOIN ps_productlabel_label_text as lt2 ON (lt2.id_label = l.id_label AND lt2.id_lang = 2)
LEFT JOIN ps_productlabel_background as ba ON (ba.id_label = l.id_label AND ba.id_lang = 2)
LEFT JOIN ps_productlabel_background as ba2 ON (ba2.id_label = l.id_label AND ba2.id_lang = 2)
WHERE ((i.id_item = 3149 AND i.type_item = "Product") OR
(i.id_item = 388 AND i.type_item = "Category") OR
(i.type_item = "Category" AND i.id_item = (SELECT DISTINCT(cp.id_category) FROM ps_category_product as cp
WHERE cp.id_category = i.id_item AND cp.id_product = 3149)))
AND p.status = 1
AND p.id_shop = 1
AND ((start_date <= "2024-02-29" OR start_date = "0000-00-00")
AND (end_date >= "2024-02-29" OR end_date = "0000-00-00"))
ORDER BY p.priority ASC LIMIT 1
0.609 ms 2 Yes /modules/productlabel/classes/ProductLabelDAO.php:731
1284
SELECT SQL_NO_CACHE p.id_product_label, p.id_type, p.priority, p.id_shop, IFNULL(p.start_date, "") as start_date, IFNULL(p.end_date, "") as end_date,
IFNULL(lt.text_content, IFNULL(lt2.text_content, NULL)) as label_text_content,
l.bg_color as label_bg_color, l.text_font as label_text_font, l.text_color as label_text_color,
l.text_size as label_text_size, l.position as label_position, l.is_resize as label_is_resize,
IFNULL(ba.id_background, IFNULL(ba2.id_background, NULL)) as id_background,
IFNULL(ba.image, IFNULL(ba2.image, NULL)) as image,
IFNULL(ba.is_perso, IFNULL(ba2.is_perso, NULL)) as is_perso,
IFNULL(ba.id_lang, IFNULL(ba2.id_lang, NULL)) as id_lang , bt.id_lang, IFNULL(bt.text_content, IFNULL(bt2.text_content, NULL)) as banner_text_content,
b.text_color as banner_text_color, b.bg_color as banner_bg_color FROM ps_productlabel as p LEFT JOIN ps_productlabel_banner as b ON b.id_product_label = p.id_product_label
LEFT JOIN ps_productlabel_banner_text as bt ON (bt.id_banner = b.id_banner AND bt.id_lang = 2)
LEFT JOIN ps_productlabel_banner_text as bt2 ON (bt2.id_banner = b.id_banner AND bt2.id_lang = 2) LEFT JOIN ps_productlabel_item as i ON i.id_product_label = p.id_product_label
LEFT JOIN ps_productlabel_label as l ON l.id_product_label = p.id_product_label
LEFT JOIN ps_productlabel_label_text as lt ON (lt.id_label = l.id_label AND lt.id_lang = 2)
LEFT JOIN ps_productlabel_label_text as lt2 ON (lt2.id_label = l.id_label AND lt2.id_lang = 2)
LEFT JOIN ps_productlabel_background as ba ON (ba.id_label = l.id_label AND ba.id_lang = 2)
LEFT JOIN ps_productlabel_background as ba2 ON (ba2.id_label = l.id_label AND ba2.id_lang = 2)
WHERE ((i.id_item = 3151 AND i.type_item = "Product") OR
(i.id_item = 310 AND i.type_item = "Category") OR
(i.type_item = "Category" AND i.id_item = (SELECT DISTINCT(cp.id_category) FROM ps_category_product as cp
WHERE cp.id_category = i.id_item AND cp.id_product = 3151)))
AND p.status = 1
AND p.id_shop = 1
AND ((start_date <= "2024-02-29" OR start_date = "0000-00-00")
AND (end_date >= "2024-02-29" OR end_date = "0000-00-00"))
ORDER BY p.priority ASC LIMIT 1
0.607 ms 2 Yes /modules/productlabel/classes/ProductLabelDAO.php:731
1212
SELECT SQL_NO_CACHE p.id_product_label, p.id_type, p.priority, p.id_shop, IFNULL(p.start_date, "") as start_date, IFNULL(p.end_date, "") as end_date,
IFNULL(lt.text_content, IFNULL(lt2.text_content, NULL)) as label_text_content,
l.bg_color as label_bg_color, l.text_font as label_text_font, l.text_color as label_text_color,
l.text_size as label_text_size, l.position as label_position, l.is_resize as label_is_resize,
IFNULL(ba.id_background, IFNULL(ba2.id_background, NULL)) as id_background,
IFNULL(ba.image, IFNULL(ba2.image, NULL)) as image,
IFNULL(ba.is_perso, IFNULL(ba2.is_perso, NULL)) as is_perso,
IFNULL(ba.id_lang, IFNULL(ba2.id_lang, NULL)) as id_lang , bt.id_lang, IFNULL(bt.text_content, IFNULL(bt2.text_content, NULL)) as banner_text_content,
b.text_color as banner_text_color, b.bg_color as banner_bg_color FROM ps_productlabel as p LEFT JOIN ps_productlabel_banner as b ON b.id_product_label = p.id_product_label
LEFT JOIN ps_productlabel_banner_text as bt ON (bt.id_banner = b.id_banner AND bt.id_lang = 2)
LEFT JOIN ps_productlabel_banner_text as bt2 ON (bt2.id_banner = b.id_banner AND bt2.id_lang = 2) LEFT JOIN ps_productlabel_item as i ON i.id_product_label = p.id_product_label
LEFT JOIN ps_productlabel_label as l ON l.id_product_label = p.id_product_label
LEFT JOIN ps_productlabel_label_text as lt ON (lt.id_label = l.id_label AND lt.id_lang = 2)
LEFT JOIN ps_productlabel_label_text as lt2 ON (lt2.id_label = l.id_label AND lt2.id_lang = 2)
LEFT JOIN ps_productlabel_background as ba ON (ba.id_label = l.id_label AND ba.id_lang = 2)
LEFT JOIN ps_productlabel_background as ba2 ON (ba2.id_label = l.id_label AND ba2.id_lang = 2)
WHERE ((i.id_item = 3041 AND i.type_item = "Product") OR
(i.id_item = 310 AND i.type_item = "Category") OR
(i.type_item = "Category" AND i.id_item = (SELECT DISTINCT(cp.id_category) FROM ps_category_product as cp
WHERE cp.id_category = i.id_item AND cp.id_product = 3041)))
AND p.status = 1
AND p.id_shop = 1
AND ((start_date <= "2024-02-29" OR start_date = "0000-00-00")
AND (end_date >= "2024-02-29" OR end_date = "0000-00-00"))
ORDER BY p.priority ASC LIMIT 1
0.605 ms 2 Yes /modules/productlabel/classes/ProductLabelDAO.php:731
1345
SELECT SQL_NO_CACHE p.id_product_label, p.id_type, p.priority, p.id_shop, IFNULL(p.start_date, "") as start_date, IFNULL(p.end_date, "") as end_date,
IFNULL(lt.text_content, IFNULL(lt2.text_content, NULL)) as label_text_content,
l.bg_color as label_bg_color, l.text_font as label_text_font, l.text_color as label_text_color,
l.text_size as label_text_size, l.position as label_position, l.is_resize as label_is_resize,
IFNULL(ba.id_background, IFNULL(ba2.id_background, NULL)) as id_background,
IFNULL(ba.image, IFNULL(ba2.image, NULL)) as image,
IFNULL(ba.is_perso, IFNULL(ba2.is_perso, NULL)) as is_perso,
IFNULL(ba.id_lang, IFNULL(ba2.id_lang, NULL)) as id_lang , bt.id_lang, IFNULL(bt.text_content, IFNULL(bt2.text_content, NULL)) as banner_text_content,
b.text_color as banner_text_color, b.bg_color as banner_bg_color FROM ps_productlabel as p LEFT JOIN ps_productlabel_banner as b ON b.id_product_label = p.id_product_label
LEFT JOIN ps_productlabel_banner_text as bt ON (bt.id_banner = b.id_banner AND bt.id_lang = 2)
LEFT JOIN ps_productlabel_banner_text as bt2 ON (bt2.id_banner = b.id_banner AND bt2.id_lang = 2) LEFT JOIN ps_productlabel_item as i ON i.id_product_label = p.id_product_label
LEFT JOIN ps_productlabel_label as l ON l.id_product_label = p.id_product_label
LEFT JOIN ps_productlabel_label_text as lt ON (lt.id_label = l.id_label AND lt.id_lang = 2)
LEFT JOIN ps_productlabel_label_text as lt2 ON (lt2.id_label = l.id_label AND lt2.id_lang = 2)
LEFT JOIN ps_productlabel_background as ba ON (ba.id_label = l.id_label AND ba.id_lang = 2)
LEFT JOIN ps_productlabel_background as ba2 ON (ba2.id_label = l.id_label AND ba2.id_lang = 2)
WHERE ((i.id_item = 3186 AND i.type_item = "Product") OR
(i.id_item = 292 AND i.type_item = "Category") OR
(i.type_item = "Category" AND i.id_item = (SELECT DISTINCT(cp.id_category) FROM ps_category_product as cp
WHERE cp.id_category = i.id_item AND cp.id_product = 3186)))
AND p.status = 1
AND p.id_shop = 1
AND ((start_date <= "2024-02-29" OR start_date = "0000-00-00")
AND (end_date >= "2024-02-29" OR end_date = "0000-00-00"))
ORDER BY p.priority ASC LIMIT 1
0.599 ms 2 Yes /modules/productlabel/classes/ProductLabelDAO.php:731
149
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` = 2
AND c.`id_parent` = 299
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
0.596 ms 1 Yes Yes /classes/Category.php:1151
24
SELECT SQL_NO_CACHE * FROM `ps_hook_module_exceptions`
WHERE `id_shop` IN (1)
0.593 ms 235 /classes/module/Module.php:2018
18
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
0.591 ms 131 /classes/module/Module.php:345
1242
SELECT SQL_NO_CACHE p.id_product_label, p.id_type, p.priority, p.id_shop, IFNULL(p.start_date, "") as start_date, IFNULL(p.end_date, "") as end_date,
IFNULL(lt.text_content, IFNULL(lt2.text_content, NULL)) as label_text_content,
l.bg_color as label_bg_color, l.text_font as label_text_font, l.text_color as label_text_color,
l.text_size as label_text_size, l.position as label_position, l.is_resize as label_is_resize,
IFNULL(ba.id_background, IFNULL(ba2.id_background, NULL)) as id_background,
IFNULL(ba.image, IFNULL(ba2.image, NULL)) as image,
IFNULL(ba.is_perso, IFNULL(ba2.is_perso, NULL)) as is_perso,
IFNULL(ba.id_lang, IFNULL(ba2.id_lang, NULL)) as id_lang , bt.id_lang, IFNULL(bt.text_content, IFNULL(bt2.text_content, NULL)) as banner_text_content,
b.text_color as banner_text_color, b.bg_color as banner_bg_color FROM ps_productlabel as p LEFT JOIN ps_productlabel_banner as b ON b.id_product_label = p.id_product_label
LEFT JOIN ps_productlabel_banner_text as bt ON (bt.id_banner = b.id_banner AND bt.id_lang = 2)
LEFT JOIN ps_productlabel_banner_text as bt2 ON (bt2.id_banner = b.id_banner AND bt2.id_lang = 2) LEFT JOIN ps_productlabel_item as i ON i.id_product_label = p.id_product_label
LEFT JOIN ps_productlabel_label as l ON l.id_product_label = p.id_product_label
LEFT JOIN ps_productlabel_label_text as lt ON (lt.id_label = l.id_label AND lt.id_lang = 2)
LEFT JOIN ps_productlabel_label_text as lt2 ON (lt2.id_label = l.id_label AND lt2.id_lang = 2)
LEFT JOIN ps_productlabel_background as ba ON (ba.id_label = l.id_label AND ba.id_lang = 2)
LEFT JOIN ps_productlabel_background as ba2 ON (ba2.id_label = l.id_label AND ba2.id_lang = 2)
WHERE ((i.id_item = 3137 AND i.type_item = "Product") OR
(i.id_item = 388 AND i.type_item = "Category") OR
(i.type_item = "Category" AND i.id_item = (SELECT DISTINCT(cp.id_category) FROM ps_category_product as cp
WHERE cp.id_category = i.id_item AND cp.id_product = 3137)))
AND p.status = 1
AND p.id_shop = 1
AND ((start_date <= "2024-02-29" OR start_date = "0000-00-00")
AND (end_date >= "2024-02-29" OR end_date = "0000-00-00"))
ORDER BY p.priority ASC LIMIT 1
0.591 ms 2 Yes /modules/productlabel/classes/ProductLabelDAO.php:731
1249
SELECT SQL_NO_CACHE p.id_product_label, p.id_type, p.priority, p.id_shop, IFNULL(p.start_date, "") as start_date, IFNULL(p.end_date, "") as end_date,
IFNULL(lt.text_content, IFNULL(lt2.text_content, NULL)) as label_text_content,
l.bg_color as label_bg_color, l.text_font as label_text_font, l.text_color as label_text_color,
l.text_size as label_text_size, l.position as label_position, l.is_resize as label_is_resize,
IFNULL(ba.id_background, IFNULL(ba2.id_background, NULL)) as id_background,
IFNULL(ba.image, IFNULL(ba2.image, NULL)) as image,
IFNULL(ba.is_perso, IFNULL(ba2.is_perso, NULL)) as is_perso,
IFNULL(ba.id_lang, IFNULL(ba2.id_lang, NULL)) as id_lang , bt.id_lang, IFNULL(bt.text_content, IFNULL(bt2.text_content, NULL)) as banner_text_content,
b.text_color as banner_text_color, b.bg_color as banner_bg_color FROM ps_productlabel as p LEFT JOIN ps_productlabel_banner as b ON b.id_product_label = p.id_product_label
LEFT JOIN ps_productlabel_banner_text as bt ON (bt.id_banner = b.id_banner AND bt.id_lang = 2)
LEFT JOIN ps_productlabel_banner_text as bt2 ON (bt2.id_banner = b.id_banner AND bt2.id_lang = 2) LEFT JOIN ps_productlabel_item as i ON i.id_product_label = p.id_product_label
LEFT JOIN ps_productlabel_label as l ON l.id_product_label = p.id_product_label
LEFT JOIN ps_productlabel_label_text as lt ON (lt.id_label = l.id_label AND lt.id_lang = 2)
LEFT JOIN ps_productlabel_label_text as lt2 ON (lt2.id_label = l.id_label AND lt2.id_lang = 2)
LEFT JOIN ps_productlabel_background as ba ON (ba.id_label = l.id_label AND ba.id_lang = 2)
LEFT JOIN ps_productlabel_background as ba2 ON (ba2.id_label = l.id_label AND ba2.id_lang = 2)
WHERE ((i.id_item = 3138 AND i.type_item = "Product") OR
(i.id_item = 388 AND i.type_item = "Category") OR
(i.type_item = "Category" AND i.id_item = (SELECT DISTINCT(cp.id_category) FROM ps_category_product as cp
WHERE cp.id_category = i.id_item AND cp.id_product = 3138)))
AND p.status = 1
AND p.id_shop = 1
AND ((start_date <= "2024-02-29" OR start_date = "0000-00-00")
AND (end_date >= "2024-02-29" OR end_date = "0000-00-00"))
ORDER BY p.priority ASC LIMIT 1
0.590 ms 2 Yes /modules/productlabel/classes/ProductLabelDAO.php:731
1171
SELECT SQL_NO_CACHE p.id_product_label, p.id_type, p.priority, p.id_shop, IFNULL(p.start_date, "") as start_date, IFNULL(p.end_date, "") as end_date,
IFNULL(lt.text_content, IFNULL(lt2.text_content, NULL)) as label_text_content,
l.bg_color as label_bg_color, l.text_font as label_text_font, l.text_color as label_text_color,
l.text_size as label_text_size, l.position as label_position, l.is_resize as label_is_resize,
IFNULL(ba.id_background, IFNULL(ba2.id_background, NULL)) as id_background,
IFNULL(ba.image, IFNULL(ba2.image, NULL)) as image,
IFNULL(ba.is_perso, IFNULL(ba2.is_perso, NULL)) as is_perso,
IFNULL(ba.id_lang, IFNULL(ba2.id_lang, NULL)) as id_lang , bt.id_lang, IFNULL(bt.text_content, IFNULL(bt2.text_content, NULL)) as banner_text_content,
b.text_color as banner_text_color, b.bg_color as banner_bg_color FROM ps_productlabel as p LEFT JOIN ps_productlabel_banner as b ON b.id_product_label = p.id_product_label
LEFT JOIN ps_productlabel_banner_text as bt ON (bt.id_banner = b.id_banner AND bt.id_lang = 2)
LEFT JOIN ps_productlabel_banner_text as bt2 ON (bt2.id_banner = b.id_banner AND bt2.id_lang = 2) LEFT JOIN ps_productlabel_item as i ON i.id_product_label = p.id_product_label
LEFT JOIN ps_productlabel_label as l ON l.id_product_label = p.id_product_label
LEFT JOIN ps_productlabel_label_text as lt ON (lt.id_label = l.id_label AND lt.id_lang = 2)
LEFT JOIN ps_productlabel_label_text as lt2 ON (lt2.id_label = l.id_label AND lt2.id_lang = 2)
LEFT JOIN ps_productlabel_background as ba ON (ba.id_label = l.id_label AND ba.id_lang = 2)
LEFT JOIN ps_productlabel_background as ba2 ON (ba2.id_label = l.id_label AND ba2.id_lang = 2)
WHERE ((i.id_item = 2494 AND i.type_item = "Product") OR
(i.id_item = 274 AND i.type_item = "Category") OR
(i.type_item = "Category" AND i.id_item = (SELECT DISTINCT(cp.id_category) FROM ps_category_product as cp
WHERE cp.id_category = i.id_item AND cp.id_product = 2494)))
AND p.status = 1
AND p.id_shop = 1
AND ((start_date <= "2024-02-29" OR start_date = "0000-00-00")
AND (end_date >= "2024-02-29" OR end_date = "0000-00-00"))
ORDER BY p.priority ASC LIMIT 1
0.588 ms 2 Yes /modules/productlabel/classes/ProductLabelDAO.php:731
1178
SELECT SQL_NO_CACHE p.id_product_label, p.id_type, p.priority, p.id_shop, IFNULL(p.start_date, "") as start_date, IFNULL(p.end_date, "") as end_date,
IFNULL(lt.text_content, IFNULL(lt2.text_content, NULL)) as label_text_content,
l.bg_color as label_bg_color, l.text_font as label_text_font, l.text_color as label_text_color,
l.text_size as label_text_size, l.position as label_position, l.is_resize as label_is_resize,
IFNULL(ba.id_background, IFNULL(ba2.id_background, NULL)) as id_background,
IFNULL(ba.image, IFNULL(ba2.image, NULL)) as image,
IFNULL(ba.is_perso, IFNULL(ba2.is_perso, NULL)) as is_perso,
IFNULL(ba.id_lang, IFNULL(ba2.id_lang, NULL)) as id_lang , bt.id_lang, IFNULL(bt.text_content, IFNULL(bt2.text_content, NULL)) as banner_text_content,
b.text_color as banner_text_color, b.bg_color as banner_bg_color FROM ps_productlabel as p LEFT JOIN ps_productlabel_banner as b ON b.id_product_label = p.id_product_label
LEFT JOIN ps_productlabel_banner_text as bt ON (bt.id_banner = b.id_banner AND bt.id_lang = 2)
LEFT JOIN ps_productlabel_banner_text as bt2 ON (bt2.id_banner = b.id_banner AND bt2.id_lang = 2) LEFT JOIN ps_productlabel_item as i ON i.id_product_label = p.id_product_label
LEFT JOIN ps_productlabel_label as l ON l.id_product_label = p.id_product_label
LEFT JOIN ps_productlabel_label_text as lt ON (lt.id_label = l.id_label AND lt.id_lang = 2)
LEFT JOIN ps_productlabel_label_text as lt2 ON (lt2.id_label = l.id_label AND lt2.id_lang = 2)
LEFT JOIN ps_productlabel_background as ba ON (ba.id_label = l.id_label AND ba.id_lang = 2)
LEFT JOIN ps_productlabel_background as ba2 ON (ba2.id_label = l.id_label AND ba2.id_lang = 2)
WHERE ((i.id_item = 2553 AND i.type_item = "Product") OR
(i.id_item = 377 AND i.type_item = "Category") OR
(i.type_item = "Category" AND i.id_item = (SELECT DISTINCT(cp.id_category) FROM ps_category_product as cp
WHERE cp.id_category = i.id_item AND cp.id_product = 2553)))
AND p.status = 1
AND p.id_shop = 1
AND ((start_date <= "2024-02-29" OR start_date = "0000-00-00")
AND (end_date >= "2024-02-29" OR end_date = "0000-00-00"))
ORDER BY p.priority ASC LIMIT 1
0.585 ms 2 Yes /modules/productlabel/classes/ProductLabelDAO.php:731
1263
SELECT SQL_NO_CACHE p.id_product_label, p.id_type, p.priority, p.id_shop, IFNULL(p.start_date, "") as start_date, IFNULL(p.end_date, "") as end_date,
IFNULL(lt.text_content, IFNULL(lt2.text_content, NULL)) as label_text_content,
l.bg_color as label_bg_color, l.text_font as label_text_font, l.text_color as label_text_color,
l.text_size as label_text_size, l.position as label_position, l.is_resize as label_is_resize,
IFNULL(ba.id_background, IFNULL(ba2.id_background, NULL)) as id_background,
IFNULL(ba.image, IFNULL(ba2.image, NULL)) as image,
IFNULL(ba.is_perso, IFNULL(ba2.is_perso, NULL)) as is_perso,
IFNULL(ba.id_lang, IFNULL(ba2.id_lang, NULL)) as id_lang , bt.id_lang, IFNULL(bt.text_content, IFNULL(bt2.text_content, NULL)) as banner_text_content,
b.text_color as banner_text_color, b.bg_color as banner_bg_color FROM ps_productlabel as p LEFT JOIN ps_productlabel_banner as b ON b.id_product_label = p.id_product_label
LEFT JOIN ps_productlabel_banner_text as bt ON (bt.id_banner = b.id_banner AND bt.id_lang = 2)
LEFT JOIN ps_productlabel_banner_text as bt2 ON (bt2.id_banner = b.id_banner AND bt2.id_lang = 2) LEFT JOIN ps_productlabel_item as i ON i.id_product_label = p.id_product_label
LEFT JOIN ps_productlabel_label as l ON l.id_product_label = p.id_product_label
LEFT JOIN ps_productlabel_label_text as lt ON (lt.id_label = l.id_label AND lt.id_lang = 2)
LEFT JOIN ps_productlabel_label_text as lt2 ON (lt2.id_label = l.id_label AND lt2.id_lang = 2)
LEFT JOIN ps_productlabel_background as ba ON (ba.id_label = l.id_label AND ba.id_lang = 2)
LEFT JOIN ps_productlabel_background as ba2 ON (ba2.id_label = l.id_label AND ba2.id_lang = 2)
WHERE ((i.id_item = 3148 AND i.type_item = "Product") OR
(i.id_item = 388 AND i.type_item = "Category") OR
(i.type_item = "Category" AND i.id_item = (SELECT DISTINCT(cp.id_category) FROM ps_category_product as cp
WHERE cp.id_category = i.id_item AND cp.id_product = 3148)))
AND p.status = 1
AND p.id_shop = 1
AND ((start_date <= "2024-02-29" OR start_date = "0000-00-00")
AND (end_date >= "2024-02-29" OR end_date = "0000-00-00"))
ORDER BY p.priority ASC LIMIT 1
0.579 ms 2 Yes /modules/productlabel/classes/ProductLabelDAO.php:731
1338
SELECT SQL_NO_CACHE p.id_product_label, p.id_type, p.priority, p.id_shop, IFNULL(p.start_date, "") as start_date, IFNULL(p.end_date, "") as end_date,
IFNULL(lt.text_content, IFNULL(lt2.text_content, NULL)) as label_text_content,
l.bg_color as label_bg_color, l.text_font as label_text_font, l.text_color as label_text_color,
l.text_size as label_text_size, l.position as label_position, l.is_resize as label_is_resize,
IFNULL(ba.id_background, IFNULL(ba2.id_background, NULL)) as id_background,
IFNULL(ba.image, IFNULL(ba2.image, NULL)) as image,
IFNULL(ba.is_perso, IFNULL(ba2.is_perso, NULL)) as is_perso,
IFNULL(ba.id_lang, IFNULL(ba2.id_lang, NULL)) as id_lang , bt.id_lang, IFNULL(bt.text_content, IFNULL(bt2.text_content, NULL)) as banner_text_content,
b.text_color as banner_text_color, b.bg_color as banner_bg_color FROM ps_productlabel as p LEFT JOIN ps_productlabel_banner as b ON b.id_product_label = p.id_product_label
LEFT JOIN ps_productlabel_banner_text as bt ON (bt.id_banner = b.id_banner AND bt.id_lang = 2)
LEFT JOIN ps_productlabel_banner_text as bt2 ON (bt2.id_banner = b.id_banner AND bt2.id_lang = 2) LEFT JOIN ps_productlabel_item as i ON i.id_product_label = p.id_product_label
LEFT JOIN ps_productlabel_label as l ON l.id_product_label = p.id_product_label
LEFT JOIN ps_productlabel_label_text as lt ON (lt.id_label = l.id_label AND lt.id_lang = 2)
LEFT JOIN ps_productlabel_label_text as lt2 ON (lt2.id_label = l.id_label AND lt2.id_lang = 2)
LEFT JOIN ps_productlabel_background as ba ON (ba.id_label = l.id_label AND ba.id_lang = 2)
LEFT JOIN ps_productlabel_background as ba2 ON (ba2.id_label = l.id_label AND ba2.id_lang = 2)
WHERE ((i.id_item = 3185 AND i.type_item = "Product") OR
(i.id_item = 292 AND i.type_item = "Category") OR
(i.type_item = "Category" AND i.id_item = (SELECT DISTINCT(cp.id_category) FROM ps_category_product as cp
WHERE cp.id_category = i.id_item AND cp.id_product = 3185)))
AND p.status = 1
AND p.id_shop = 1
AND ((start_date <= "2024-02-29" OR start_date = "0000-00-00")
AND (end_date >= "2024-02-29" OR end_date = "0000-00-00"))
ORDER BY p.priority ASC LIMIT 1
0.574 ms 2 Yes /modules/productlabel/classes/ProductLabelDAO.php:731
399
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` = 2
AND c.`id_parent` = 259
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
0.568 ms 1 Yes Yes /classes/Category.php:1151
1280
SELECT SQL_NO_CACHE p.id_product_label, p.id_type, GROUP_CONCAT(CONCAT(a.attribute, ",", a.attribute_value) separator ";") as attr, p.priority, p.id_shop,
IFNULL(lt.text_content, IFNULL(lt2.text_content, NULL)) as label_text_content,
l.bg_color as label_bg_color, l.text_font as label_text_font, l.text_color as label_text_color,
l.text_size as label_text_size, l.position as label_position, l.is_resize as label_is_resize,
IFNULL(ba.id_background, IFNULL(ba2.id_background, NULL)) as id_background,
IFNULL(ba.image, IFNULL(ba2.image, NULL)) as image,
IFNULL(ba.is_perso, IFNULL(ba2.is_perso, NULL)) as is_perso,
IFNULL(ba.id_lang, IFNULL(ba2.id_lang, NULL)) as id_lang , bt.id_lang, IFNULL(bt.text_content, IFNULL(bt2.text_content, NULL)) as banner_text_content,
b.text_color as banner_text_color, b.bg_color as banner_bg_color FROM ps_productlabel as p LEFT JOIN ps_productlabel_banner as b ON b.id_product_label = p.id_product_label
LEFT JOIN ps_productlabel_banner_text as bt ON (bt.id_banner = b.id_banner AND bt.id_lang = 2)
LEFT JOIN ps_productlabel_banner_text as bt2 ON (bt2.id_banner = b.id_banner AND bt2.id_lang = 2) RIGHT JOIN ps_productlabel_attribute as a ON a.id_product_label = p.id_product_label
LEFT JOIN ps_productlabel_label as l ON l.id_product_label = p.id_product_label
LEFT JOIN ps_productlabel_label_text as lt ON (lt.id_label = l.id_label AND lt.id_lang = 2)
LEFT JOIN ps_productlabel_label_text as lt2 ON (lt2.id_label = l.id_label AND lt2.id_lang = 2)
LEFT JOIN ps_productlabel_background as ba ON (ba.id_label = l.id_label AND ba.id_lang = 2)
LEFT JOIN ps_productlabel_background as ba2 ON (ba2.id_label = l.id_label AND ba2.id_lang = 2)
WHERE p.id_type = 3
AND p.status = 1
AND p.id_shop = 1
GROUP BY p.id_product_label
ORDER BY p.priority ASC, p.id_product_label DESC LIMIT 1
0.566 ms 1 Yes /modules/productlabel/classes/ProductLabelDAO.php:908
1110
SELECT SQL_NO_CACHE p.id_product_label, p.id_type, p.priority, p.id_shop, IFNULL(p.start_date, "") as start_date, IFNULL(p.end_date, "") as end_date,
IFNULL(lt.text_content, IFNULL(lt2.text_content, NULL)) as label_text_content,
l.bg_color as label_bg_color, l.text_font as label_text_font, l.text_color as label_text_color,
l.text_size as label_text_size, l.position as label_position, l.is_resize as label_is_resize,
IFNULL(ba.id_background, IFNULL(ba2.id_background, NULL)) as id_background,
IFNULL(ba.image, IFNULL(ba2.image, NULL)) as image,
IFNULL(ba.is_perso, IFNULL(ba2.is_perso, NULL)) as is_perso,
IFNULL(ba.id_lang, IFNULL(ba2.id_lang, NULL)) as id_lang , bt.id_lang, IFNULL(bt.text_content, IFNULL(bt2.text_content, NULL)) as banner_text_content,
b.text_color as banner_text_color, b.bg_color as banner_bg_color FROM ps_productlabel as p LEFT JOIN ps_productlabel_banner as b ON b.id_product_label = p.id_product_label
LEFT JOIN ps_productlabel_banner_text as bt ON (bt.id_banner = b.id_banner AND bt.id_lang = 2)
LEFT JOIN ps_productlabel_banner_text as bt2 ON (bt2.id_banner = b.id_banner AND bt2.id_lang = 2) LEFT JOIN ps_productlabel_item as i ON i.id_product_label = p.id_product_label
LEFT JOIN ps_productlabel_label as l ON l.id_product_label = p.id_product_label
LEFT JOIN ps_productlabel_label_text as lt ON (lt.id_label = l.id_label AND lt.id_lang = 2)
LEFT JOIN ps_productlabel_label_text as lt2 ON (lt2.id_label = l.id_label AND lt2.id_lang = 2)
LEFT JOIN ps_productlabel_background as ba ON (ba.id_label = l.id_label AND ba.id_lang = 2)
LEFT JOIN ps_productlabel_background as ba2 ON (ba2.id_label = l.id_label AND ba2.id_lang = 2)
WHERE ((i.id_item = 2066 AND i.type_item = "Product") OR
(i.id_item = 294 AND i.type_item = "Category") OR
(i.type_item = "Category" AND i.id_item = (SELECT DISTINCT(cp.id_category) FROM ps_category_product as cp
WHERE cp.id_category = i.id_item AND cp.id_product = 2066)))
AND p.status = 1
AND p.id_shop = 1
AND ((start_date <= "2024-02-29" OR start_date = "0000-00-00")
AND (end_date >= "2024-02-29" OR end_date = "0000-00-00"))
ORDER BY p.priority ASC LIMIT 1
0.564 ms 2 Yes /modules/productlabel/classes/ProductLabelDAO.php:731
15
SELECT SQL_NO_CACHE `id_hook`, `name` FROM `ps_hook`
0.564 ms 921 /classes/Hook.php:1292
173
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` = 2
AND c.`id_parent` = 306
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
0.563 ms 1 Yes Yes /classes/Category.php:1151
75
SELECT SQL_NO_CACHE DISTINCT `id_product` FROM `ps_specific_price` WHERE `id_product` != 0
0.563 ms 415 /classes/SpecificPrice.php:310
1143
SELECT SQL_NO_CACHE p.id_product_label, p.id_type, p.priority, p.id_shop, IFNULL(p.start_date, "") as start_date, IFNULL(p.end_date, "") as end_date,
IFNULL(lt.text_content, IFNULL(lt2.text_content, NULL)) as label_text_content,
l.bg_color as label_bg_color, l.text_font as label_text_font, l.text_color as label_text_color,
l.text_size as label_text_size, l.position as label_position, l.is_resize as label_is_resize,
IFNULL(ba.id_background, IFNULL(ba2.id_background, NULL)) as id_background,
IFNULL(ba.image, IFNULL(ba2.image, NULL)) as image,
IFNULL(ba.is_perso, IFNULL(ba2.is_perso, NULL)) as is_perso,
IFNULL(ba.id_lang, IFNULL(ba2.id_lang, NULL)) as id_lang , bt.id_lang, IFNULL(bt.text_content, IFNULL(bt2.te