totoTouret à polir DSMV 200PS

Livraison offerte dès 89€ d'achat en point relais

Touret à polir DSMV 200PS

0/5

Puissance 900W

Référence : TOURETDSMV200PS
€260.00
€260.00
Sur commande ou attente de réapprovisionnement
Partager

Partager le lien

Touret à polir DSMV 200PS - 220V Mono, 900W, Holzmann, livré avec 2 frottes (1 coton souple + 1 toile jean).

Possibilité d'y monter 1 ou 2 roues expansibles dia. 200 ou 250mm.

Touret à polir DSMV 200PS - 220V Mono, 900W, Holzmann, livré avec 2 frottes (1 coton souple + 1 toile jean).

Possibilité d'y monter 1 ou 2 roues expansibles dia. 200 ou 250mm.

Category Bench grinder Brand Holzmann

Les avis sur notre produit

Comments (0)

Vous aimerez aussi...

Load Time 829 ms
Querying Time 122 ms
Queries 667
Memory Peak Usage 54.9 Mb
Included Files 1645 files - 20.95 Mb
PrestaShop Cache - Mb
Global vars 1.13 Mb
PrestaShop Version 1.7.8.8
PHP Version 7.4.33
MySQL Version 10.11.6-MariaDB-0+deb12u1-log
Memory Limit 2048M
Max Execution Time 6000s
Smarty Cache enabled
Smarty Compilation auto
  Time Cumulated Time Memory Usage Memory Peak Usage
config 20 ms 20 ms 7.27 Mb 9.9 Mb
__construct 0 ms 20 ms - Mb 9.9 Mb
init 26 ms 46 ms 3.17 Mb 10.8 Mb
checkAccess 0 ms 46 ms - Mb 10.8 Mb
setMedia 5 ms 50 ms 0.48 Mb 11.2 Mb
postProcess 0 ms 50 ms - Mb 11.2 Mb
initHeader 0 ms 50 ms - Mb 11.2 Mb
initContent 126 ms 176 ms 8.84 Mb 19.9 Mb
initFooter 0 ms 176 ms - Mb 19.9 Mb
display 653 ms 829 ms 34.08 Mb 54.9 Mb
Hook Time Memory Usage
OverrideLayoutTemplate 627 ms 32.74 Mb
displayNavFullWidth 53 ms 3.99 Mb
DisplayBlock 44 ms 3.39 Mb
DisplayHeader 36 ms 2.95 Mb
ModuleRoutes 11 ms 1.58 Mb
ActionOutputHTMLBefore 9 ms - Mb
DisplayProductPriceBlock 9 ms 0.79 Mb
Header 5 ms 0.23 Mb
DisplayFooter 4 ms 0.25 Mb
displayFooterProduct 4 ms 0.11 Mb
DisplayBeforeBodyClosingTag 3 ms 0.14 Mb
displayFlagProduct 2 ms 0.04 Mb
FilterProductContent 2 ms 0.38 Mb
DisplayProductButtons 2 ms 0.27 Mb
displayGtag 1 ms 0.09 Mb
ActionFrontControllerSetMedia 1 ms - Mb
ActionGetProductPropertiesAfter 1 ms 0.04 Mb
DisplayGDPRConsent 1 ms 0.04 Mb
displayPriceTaxExcludedProduct 0 ms - Mb
displayStock 0 ms - Mb
DisplayCustomMenu 0 ms 0.01 Mb
DisplayWrapperBottom 0 ms 0.02 Mb
ActionFrontControllerInitAfter 0 ms - Mb
DisplayContentWrapperTop 0 ms - Mb
DisplayAfterBodyOpeningTag 0 ms - Mb
ActionDispatcherBefore 0 ms - Mb
DisplayOverrideTemplate 0 ms - Mb
27 hook(s) 817 ms 46.91 Mb
Module Time Memory Usage
ybc_instagram 4 ms 0.28 Mb
colissimo 1 ms 0.42 Mb
hiupsell 2 ms 0.14 Mb
ets_marketplace 10 ms - Mb
ets_contactform7 12 ms 4.16 Mb
dpdfrance 1 ms - Mb
ets_awesomeurl 1 ms 0.18 Mb
ets_extraoptions 3 ms 0.20 Mb
creativeelements 638 ms 33.65 Mb
blockwishlist 2 ms 0.11 Mb
ps_emailsubscription 2 ms 0.22 Mb
blockreassurance 0 ms 0.03 Mb
allinone_rewards 6 ms 0.75 Mb
mondialrelay 0 ms 0.06 Mb
ps_emailalerts 0 ms 0.04 Mb
productcomments 6 ms 0.52 Mb
ets_superspeed 11 ms - Mb
ps_imageslider 0 ms 0.03 Mb
ps_searchbar 1 ms 0.02 Mb
ps_shoppingcart 0 ms 0.03 Mb
layerslider 3 ms 0.07 Mb
ets_megamenu 102 ms 8.72 Mb
ps_customersignin 0 ms 0.02 Mb
tacartreminder 0 ms 0.16 Mb
creativepopup 2 ms 0.07 Mb
seq_smarty 0 ms 0.04 Mb
upsshipping 1 ms 0.08 Mb
whatsappchat 6 ms 0.48 Mb
sizechart 2 ms 0.24 Mb
giftcard 1 ms 0.38 Mb
psxmarketingwithgoogle 1 ms 0.05 Mb
paypal 4 ms 0.32 Mb
payplug 16 ms 0.43 Mb
estimateshippingcosts 0 ms 0.02 Mb
pdfquotation 0 ms - Mb
minpurchase 2 ms 0.17 Mb
sendinblue 1 ms 0.03 Mb
psgdpr 1 ms 0.07 Mb
seq_caracs 5 ms 0.15 Mb
lgcookieslaw 1 ms 0.08 Mb
40 module(s) 847 ms 49.86 Mb

Stopwatch SQL - 667 queries

Query Time (ms) Rows Filesort Group By Location
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`)
6081 ms 4099 /classes/Configuration.php:160
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`)
5494 ms 4099 /classes/Configuration.php:160
SELECT SQL_NO_CACHE h.id_hook, h.name as h_name, title, description, h.position, hm.position as hm_position, m.id_module, m.name, m.active
FROM `ps_hook_module` hm
STRAIGHT_JOIN `ps_hook` h ON (h.id_hook = hm.id_hook AND hm.id_shop = 1)
STRAIGHT_JOIN `ps_module` as m ON (m.id_module = hm.id_module)
ORDER BY hm.position
1979 ms 838 /classes/Hook.php:504
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`
1919 ms 240 Yes Yes /classes/Hook.php:1183
SELECT SQL_NO_CACHE DISTINCT g.id_tax_rules_group, g.name, g.active, t.rate FROM `ps_tax_rules_group` g
INNER JOIN ps_tax_rule tr
ON g.id_tax_rules_group = tr.id_tax_rules_group
INNER JOIN ps_tax t
ON tr.id_tax = t.id_tax
INNER JOIN ps_tax_rules_group_shop tax_rules_group_shop
ON (tax_rules_group_shop.id_tax_rules_group = g.id_tax_rules_group AND tax_rules_group_shop.id_shop = 1) WHERE g.deleted = 0 AND g.`active` = 1 ORDER BY name ASC
1226 ms 1890 Yes /classes/tax/TaxRulesGroup.php:196
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` = 2)
LEFT JOIN `ps_zone` z ON (z.`id_zone` = c.`id_zone`)
WHERE 1
ORDER BY cl.name ASC
1049 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
1034 ms 0 /classes/Hook.php:1243
(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` = 2)
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)
952 ms 1 /classes/CartRule.php:444
SELECT SQL_NO_CACHE c.id_parent, c.id_category, cl.name, cl.link_rewrite
FROM `ps_category` c
INNER JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.`id_lang` = 2 AND cl.id_shop = 1 )
INNER JOIN `ps_category_shop` cs ON (cs.`id_category` = c.`id_category` AND cs.`id_shop` = 1)
WHERE (c.`active` = 1 OR c.`id_category` = 2)
AND c.`id_category` != 1
AND `level_depth` <= 5
AND nleft >= 2 AND nright <= 385
AND c.id_category IN (
SELECT id_category
FROM `ps_category_group`
WHERE `id_group` IN (1)
)
ORDER BY `level_depth` ASC, cs.`position` ASC
895 ms 193 Yes /modules/creativeelements/includes/base/widget-category-base.php:146
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-10-05 00:00:00",
INTERVAL 0 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` = 2509 AND product_shop.`active` = 1 AND product_shop.`visibility` != 'none'
GROUP BY product_shop.id_product
650 ms 6 Yes /classes/Product.php:4639
DELETE FROM `ps_configuration_lang`
WHERE `id_configuration` IN (
SELECT `id_configuration`
FROM `ps_configuration`
WHERE `name` = "PS_ROUTE_etsmpshops"
)
528 ms 1 /classes/Configuration.php:570
SELECT SQL_NO_CACHE * FROM `ps_state` ORDER BY `name` ASC
470 ms 352 Yes /classes/Country.php:154
SELECT SQL_NO_CACHE lower(name) as name
FROM `ps_hook` h
WHERE (h.active = 1)
458 ms 948 /classes/Hook.php:1283
DELETE FROM `ps_configuration_lang`
WHERE `id_configuration` IN (
SELECT `id_configuration`
FROM `ps_configuration`
WHERE `name` = "PS_ROUTE_etsmpshopsseller"
)
456 ms 1 /classes/Configuration.php:570
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=2
WHERE 1  AND b.id_column=22 
ORDER BY b.sort_order asc,bl.title asc
439 ms 3 Yes /modules/ets_megamenu/classes/MM_Block.php:617
SELECT SQL_NO_CACHE a.*,al.name,al.description,IFNULL(cap.position,a.position) AS sort_order, IF(cap.used IS NULL,-1,cap.used) AS product_used,IF(cap.price IS NULL,-1,cap.price) AS product_price,IF(cap.type_price is null,-1,cap.type_price) as product_type_price ,IF(cap.required IS NULL,-1,cap.required) AS product_required,IF(cap.checked IS NULL,-1,cap.checked) AS product_checked,IF(cap.use_tax IS NULL,-1,cap.use_tax) AS product_use_tax,IF(cap.use_discount IS NULL,-1,cap.use_discount) AS product_use_discount 
FROM `ps_ets_eto_attr` a
LEFT JOIN `ps_ets_eto_attr_lang` al ON (a.id_ets_eto_attr = al.id_ets_eto_attr AND al.id_lang="2")
LEFT JOIN `ps_ets_eto_attr_product` cap ON (cap.id_ets_eto_attr = a.id_ets_eto_attr AND cap.id_product="2509")
LEFT JOIN `ps_ets_eto_attr_category` cac ON (cac.id_ets_eto_attr = a.id_ets_eto_attr)
WHERE a.active=1 AND a.id_shop ="1" AND (cac.id_ets_eto_attr is null OR cac.id_category="58")  AND (cap.used=1 OR ((cap.used=-1 OR cap.used IS NULL) AND a.used=1))  AND a.id_product=0 AND a.id_ets_eto_attr_group=1 ORDER BY sort_order ASC
438 ms 12 Yes /modules/ets_extraoptions/classes/ets_eto_attribute_class.php:532
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` = 2509
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
421 ms 1 Yes Yes /classes/Product.php:4549
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
416 ms 81 Yes /classes/Dispatcher.php:650
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` = 2509
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
394 ms 1 Yes Yes /classes/Product.php:4549
SELECT SQL_NO_CACHE p.*,
ps.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2024-10-05 00:00:00',
INTERVAL 0 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 = 2
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 = 1741
LIMIT 1
392 ms 4 /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=2
WHERE 1  AND b.id_column=23 
ORDER BY b.sort_order asc,bl.title asc
384 ms 1 Yes /modules/ets_megamenu/classes/MM_Block.php:617
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` = 2  AND cl.id_shop = 1 )
LEFT JOIN `ps_category_group` cg ON (cg.`id_category` = c.`id_category`)
WHERE `id_parent` = 58
AND `active` = 1
AND cg.`id_group` =1
GROUP BY c.`id_category`
ORDER BY `level_depth` ASC, category_shop.`position` ASC
384 ms 1 Yes Yes /classes/Category.php:919
SELECT SQL_NO_CACHE a.*,al.name,al.description,IFNULL(cap.position,a.position) AS sort_order, IF(cap.used IS NULL,-1,cap.used) AS product_used,IF(cap.price IS NULL,-1,cap.price) AS product_price,IF(cap.type_price is null,-1,cap.type_price) as product_type_price ,IF(cap.required IS NULL,-1,cap.required) AS product_required,IF(cap.checked IS NULL,-1,cap.checked) AS product_checked,IF(cap.use_tax IS NULL,-1,cap.use_tax) AS product_use_tax,IF(cap.use_discount IS NULL,-1,cap.use_discount) AS product_use_discount 
FROM `ps_ets_eto_attr` a
LEFT JOIN `ps_ets_eto_attr_lang` al ON (a.id_ets_eto_attr = al.id_ets_eto_attr AND al.id_lang="2")
LEFT JOIN `ps_ets_eto_attr_product` cap ON (cap.id_ets_eto_attr = a.id_ets_eto_attr AND cap.id_product="2509")
LEFT JOIN `ps_ets_eto_attr_category` cac ON (cac.id_ets_eto_attr = a.id_ets_eto_attr)
WHERE a.active=1 AND a.id_shop ="1" AND (cac.id_ets_eto_attr is null OR cac.id_category="58")  AND (cap.used=1 OR ((cap.used=-1 OR cap.used IS NULL) AND a.used=1))  AND a.id_product="2509" AND a.id_ets_eto_attr_group=1 ORDER BY sort_order ASC
374 ms 3 Yes /modules/ets_extraoptions/classes/ets_eto_attribute_class.php:532
SELECT SQL_NO_CACHE `id_hook`, `name` FROM `ps_hook`
372 ms 948 /classes/Hook.php:1243
SELECT SQL_NO_CACHE a.*,al.name,al.description,IFNULL(cap.position,a.position) AS sort_order, IF(cap.used IS NULL,-1,cap.used) AS product_used,IF(cap.price IS NULL,-1,cap.price) AS product_price,IF(cap.type_price is null,-1,cap.type_price) as product_type_price ,IF(cap.required IS NULL,-1,cap.required) AS product_required,IF(cap.checked IS NULL,-1,cap.checked) AS product_checked,IF(cap.use_tax IS NULL,-1,cap.use_tax) AS product_use_tax,IF(cap.use_discount IS NULL,-1,cap.use_discount) AS product_use_discount 
FROM `ps_ets_eto_attr` a
LEFT JOIN `ps_ets_eto_attr_lang` al ON (a.id_ets_eto_attr = al.id_ets_eto_attr AND al.id_lang="2")
LEFT JOIN `ps_ets_eto_attr_product` cap ON (cap.id_ets_eto_attr = a.id_ets_eto_attr AND cap.id_product="2509")
LEFT JOIN `ps_ets_eto_attr_category` cac ON (cac.id_ets_eto_attr = a.id_ets_eto_attr)
WHERE a.active=1 AND a.id_shop ="1" AND (cac.id_ets_eto_attr is null OR cac.id_category="58")  AND (cap.used=1 OR ((cap.used=-1 OR cap.used IS NULL) AND a.used=1))  AND a.id_product="2509" AND a.id_ets_eto_attr_group=0 ORDER BY sort_order ASC
363 ms 3 Yes /modules/ets_extraoptions/classes/ets_eto_attribute_class.php:532
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=2
WHERE 1  AND b.id_column=19 
ORDER BY b.sort_order asc,bl.title asc
359 ms 1 Yes /modules/ets_megamenu/classes/MM_Block.php:617
SELECT SQL_NO_CACHE a.*,al.name,al.description,IFNULL(cap.position,a.position) AS sort_order, IF(cap.used IS NULL,-1,cap.used) AS product_used,IF(cap.price IS NULL,-1,cap.price) AS product_price,IF(cap.type_price is null,-1,cap.type_price) as product_type_price ,IF(cap.required IS NULL,-1,cap.required) AS product_required,IF(cap.checked IS NULL,-1,cap.checked) AS product_checked,IF(cap.use_tax IS NULL,-1,cap.use_tax) AS product_use_tax,IF(cap.use_discount IS NULL,-1,cap.use_discount) AS product_use_discount 
FROM `ps_ets_eto_attr` a
LEFT JOIN `ps_ets_eto_attr_lang` al ON (a.id_ets_eto_attr = al.id_ets_eto_attr AND al.id_lang="2")
LEFT JOIN `ps_ets_eto_attr_product` cap ON (cap.id_ets_eto_attr = a.id_ets_eto_attr AND cap.id_product="2509")
LEFT JOIN `ps_ets_eto_attr_category` cac ON (cac.id_ets_eto_attr = a.id_ets_eto_attr)
WHERE a.active=1 AND a.id_shop ="1" AND (cac.id_ets_eto_attr is null OR cac.id_category="58")  AND (cap.used=1 OR ((cap.used=-1 OR cap.used IS NULL) AND a.used=1))  AND a.id_product=0 AND a.id_ets_eto_attr_group=0 ORDER BY sort_order ASC
356 ms 3 Yes /modules/ets_extraoptions/classes/ets_eto_attribute_class.php:532
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` = 2509 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` = 2509 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
327 ms 0 /classes/Cart.php:1429
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=2
WHERE 1  AND b.id_column=10 
ORDER BY b.sort_order asc,bl.title asc
321 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(
'2024-10-05 00:00:00',
INTERVAL 0 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 = 2
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 = 2512
LIMIT 1
315 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=2
WHERE 1  AND b.id_column=20 
ORDER BY b.sort_order asc,bl.title asc
313 ms 2 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
313 ms 107 /classes/module/Module.php:340
SELECT SQL_NO_CACHE p.*,
ps.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2024-10-05 00:00:00',
INTERVAL 0 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 = 2
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 = 2139
LIMIT 1
312 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=2
WHERE 1  AND b.id_column=1 
ORDER BY b.sort_order asc,bl.title asc
310 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(
'2024-10-05 00:00:00',
INTERVAL 0 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 = 2
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 = 2138
LIMIT 1
309 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=2
WHERE 1  AND b.id_column=8 
ORDER BY b.sort_order asc,bl.title asc
308 ms 2 Yes /modules/ets_megamenu/classes/MM_Block.php:617
SELECT SQL_NO_CACHE b.*,bl.title,bl.title_link,bl.content,bl.image_link
FROM `ps_ets_mm_block` b
LEFT JOIN `ps_ets_mm_block_lang` bl
ON b.id_block=bl.id_block AND bl.id_lang=2
WHERE 1  AND b.id_column=21 
ORDER BY b.sort_order asc,bl.title asc
307 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
307 ms 107 /classes/module/Module.php:340
SELECT SQL_NO_CACHE p.*,
ps.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2024-10-05 00:00:00',
INTERVAL 0 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 = 2
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 = 2513
LIMIT 1
306 ms 2 /classes/ProductAssembler.php:106
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
306 ms 107 /classes/module/Module.php:340
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
304 ms 107 /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=2
WHERE 1  AND b.id_column=24 
ORDER BY b.sort_order asc,bl.title asc
302 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=2
WHERE 1  AND b.id_column=25 
ORDER BY b.sort_order asc,bl.title asc
301 ms 1 Yes /modules/ets_megamenu/classes/MM_Block.php:617
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` = 2) AND (b.`id_shop` = 1) LIMIT 1
301 ms 1 /src/Adapter/EntityMapper.php:76
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` = 2509
301 ms 1 /classes/Product.php:7435
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
300 ms 107 /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=2
WHERE 1  AND b.id_column=17 
ORDER BY b.sort_order asc,bl.title asc
299 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=2
WHERE 1  AND b.id_column=6 
ORDER BY b.sort_order asc,bl.title asc
298 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=2
WHERE 1  AND b.id_column=7 
ORDER BY b.sort_order asc,bl.title asc
298 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=2
WHERE 1  AND b.id_column=9 
ORDER BY b.sort_order asc,bl.title asc
297 ms 1 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` = 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` = 2509
295 ms 1 /classes/Product.php:7435
(SELECT 1 FROM `ps_cart_rule` WHERE date_to >= "2024-10-05 00:00:00" AND date_to <= "2024-10-05 23:59:59" AND `id_customer` IN (0,0) LIMIT 1)UNION ALL (SELECT 1 FROM `ps_cart_rule` WHERE date_from >= "2024-10-05 00:00:00" AND date_from <= "2024-10-05 23:59:59" AND `id_customer` IN (0,0) LIMIT 1)UNION ALL (SELECT 1 FROM `ps_cart_rule` WHERE date_from < "2024-10-05 00:00:00" AND date_to > "2024-10-05 23:59:59" AND `id_customer` IN (0,0) LIMIT 1) LIMIT 1
289 ms 1 /classes/CartRule.php:383
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` = 2513 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` = 2513 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
288 ms 0 /classes/Cart.php:1429
SELECT SQL_NO_CACHE c.*, cl.name,cl.link_rewrite
FROM `ps_category` c
INNER JOIN `ps_category_shop` cs ON (c.id_category=cs.id_category AND cs.id_shop=1)
LEFT JOIN `ps_category_lang` cl ON c.id_category=cl.id_category AND cl.id_lang=2
LEFT JOIN `ps_category_group` cg ON c.`id_category` = cg.`id_category` 
WHERE c.active=1 
AND  c.id_category IN(226,227,228,229)
AND cg.`id_group` IN (1)
GROUP BY c.id_category ORDER BY c.position ASC,c.id_category ASC
284 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=2
LEFT JOIN `ps_category_group` cg ON c.`id_category` = cg.`id_category` 
WHERE c.active=1 
AND  c.id_category IN(39,40,41,42,43)
AND cg.`id_group` IN (1)
GROUP BY c.id_category ORDER BY c.position ASC,c.id_category ASC
282 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=2
LEFT JOIN `ps_category_group` cg ON c.`id_category` = cg.`id_category` 
WHERE c.active=1 
AND  c.id_category IN(217,218,219,220)
AND cg.`id_group` IN (1)
GROUP BY c.id_category ORDER BY c.position ASC,c.id_category ASC
278 ms 4 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(
'2024-10-05 00:00:00',
INTERVAL 0 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 = 2
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 = 2508
LIMIT 1
276 ms 6 /classes/ProductAssembler.php:106
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
274 ms 107 /classes/module/Module.php:340
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=2
WHERE 1  AND m.enabled=1 
GROUP BY m.id_menu
ORDER BY m.sort_order asc,ml.title asc
272 ms 4 Yes Yes /modules/ets_megamenu/classes/MM_Menu.php:500
SELECT SQL_NO_CACHE pa.*, product_attribute_shop.*, ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, al.`name` AS attribute_name,
a.`id_attribute`, a.`position`
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_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` AND al.`id_lang` = 2)
LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 2)
WHERE pa.`id_product` = 2513
AND pa.`id_product_attribute` = 0
GROUP BY pa.`id_product_attribute`,ag.`id_attribute_group`
ORDER BY pa.`id_product_attribute`
270 ms 0 Yes /classes/Product.php:2839
(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` = 2)
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 cr.`quantity` > 0 AND highlight = 1 AND code NOT LIKE "BO_ORDER_%")
270 ms 1 /classes/CartRule.php:444
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` = 2513) AND (b.`id_shop` = 1) LIMIT 1
267 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=2
LEFT JOIN `ps_category_group` cg ON c.`id_category` = cg.`id_category` 
WHERE c.active=1 
AND  c.id_category IN(51,52,53,55)
AND cg.`id_group` IN (1)
GROUP BY c.id_category ORDER BY c.position ASC,c.id_category ASC
266 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=2
LEFT JOIN `ps_category_group` cg ON c.`id_category` = cg.`id_category` 
WHERE c.active=1 
AND  c.id_category IN(44,45,46,47,48,49,50)
AND cg.`id_group` IN (1)
GROUP BY c.id_category ORDER BY c.position ASC,c.id_category ASC
263 ms 7 Yes Yes /modules/ets_megamenu/classes/Ets_megamenu_defines.php:178
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 = 'www.michel-vaillant.com' OR su.domain_ssl = 'www.michel-vaillant.com')
AND s.active = 1
AND s.deleted = 0
ORDER BY LENGTH(CONCAT(su.physical_uri, su.virtual_uri)) DESC
259 ms 1 Yes /classes/shop/Shop.php:1350
SELECT SQL_NO_CACHE tr.*
FROM `ps_tax_rule` tr
JOIN `ps_tax_rules_group` trg ON (tr.`id_tax_rules_group` = trg.`id_tax_rules_group`)
WHERE trg.`active` = 1
AND tr.`id_country` = 21
AND tr.`id_tax_rules_group` = 22
AND tr.`id_state` IN (0, 0)
AND ('0' BETWEEN tr.`zipcode_from` AND tr.`zipcode_to`
OR (tr.`zipcode_to` = 0 AND tr.`zipcode_from` IN(0, '0')))
ORDER BY tr.`zipcode_from` DESC, tr.`zipcode_to` DESC, tr.`id_state` DESC, tr.`id_country` DESC
258 ms 1 /classes/tax/TaxRulesTaxManager.php:109
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=2
LEFT JOIN `ps_category_group` cg ON c.`id_category` = cg.`id_category` 
WHERE c.active=1 
AND  c.id_category IN(18,23,22,20,19,21)
AND cg.`id_group` IN (1)
GROUP BY c.id_category ORDER BY c.position ASC,c.id_category ASC
258 ms 6 Yes Yes /modules/ets_megamenu/classes/Ets_megamenu_defines.php:178
SELECT SQL_NO_CACHE COUNT(*) FROM (SELECT DISTINCT `id_product` FROM `ps_specific_price` WHERE `id_product` != 0 GROUP BY id_product ) AS counted LIMIT 1
258 ms 103041 /classes/SpecificPrice.php:287
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=2
LEFT JOIN `ps_category_group` cg ON c.`id_category` = cg.`id_category` 
WHERE c.active=1 
AND  c.id_category IN(247,56,58,183,60,184)
AND cg.`id_group` IN (1)
GROUP BY c.id_category ORDER BY c.position ASC,c.id_category ASC
256 ms 6 Yes Yes /modules/ets_megamenu/classes/Ets_megamenu_defines.php:178
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
255 ms 107 /classes/module/Module.php:340
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
253 ms 107 /classes/module/Module.php:340
SELECT SQL_NO_CACHE pa.*, product_attribute_shop.*, ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, al.`name` AS attribute_name,
a.`id_attribute`, a.`position`
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_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` AND al.`id_lang` = 2)
LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 2)
WHERE pa.`id_product` = 1741
AND pa.`id_product_attribute` = 13272
GROUP BY pa.`id_product_attribute`,ag.`id_attribute_group`
ORDER BY pa.`id_product_attribute`
251 ms 1 Yes /classes/Product.php:2839
SELECT SQL_NO_CACHE pa.*, product_attribute_shop.*, ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, al.`name` AS attribute_name,
a.`id_attribute`, a.`position`
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_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` AND al.`id_lang` = 2)
LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 2)
WHERE pa.`id_product` = 2508
AND pa.`id_product_attribute` = 14233
GROUP BY pa.`id_product_attribute`,ag.`id_attribute_group`
ORDER BY pa.`id_product_attribute`
251 ms 1 Yes /classes/Product.php:2839
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=2
LEFT JOIN `ps_category_group` cg ON c.`id_category` = cg.`id_category` 
WHERE c.active=1 
AND  c.id_category IN(7,28,177,178,185,29,211)
AND cg.`id_group` IN (1)
GROUP BY c.id_category ORDER BY c.position ASC,c.id_category ASC
251 ms 7 Yes Yes /modules/ets_megamenu/classes/Ets_megamenu_defines.php:178
SELECT SQL_NO_CACHE *,
( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 8, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 8) AND
`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2024-10-05 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-10-05 00:00:00' <= `to`)
ORDER BY `from_quantity` ASC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC
250 ms 1 Yes /classes/SpecificPrice.php:624
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` = 1741 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` = 1741 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
248 ms 0 /classes/Cart.php:1429
SELECT SQL_NO_CACHE c.*, cl.name,cl.link_rewrite
FROM `ps_category` c
INNER JOIN `ps_category_shop` cs ON (c.id_category=cs.id_category AND cs.id_shop=1)
LEFT JOIN `ps_category_lang` cl ON c.id_category=cl.id_category AND cl.id_lang=2
LEFT JOIN `ps_category_group` cg ON c.`id_category` = cg.`id_category` 
WHERE c.active=1 
AND  c.id_category IN(9,11,10,118,208)
AND cg.`id_group` IN (1)
GROUP BY c.id_category ORDER BY c.position ASC,c.id_category ASC
246 ms 5 Yes Yes /modules/ets_megamenu/classes/Ets_megamenu_defines.php:178
SELECT SQL_NO_CACHE * FROM `ps_whatsappchatblock` LEFT JOIN `ps_whatsappchatblock_lang` ON (`ps_whatsappchatblock`.`id_whatsappchatblock` = `ps_whatsappchatblock_lang`.`id_whatsappchatblock` AND `id_lang` = 2) WHERE `id_hook` = "topWidthSticky" AND `id_shop` = 1 AND `active` = 1 ORDER BY position DESC;
244 ms 1 Yes /modules/whatsappchat/classes/WhatsappChatBlock.php:130
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position
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 = 2509
ORDER BY f.position ASC
242 ms 1 Yes /classes/Product.php:5905
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` = 2138
ORDER BY `position`
241 ms 3 Yes /classes/Product.php:3517
SELECT SQL_NO_CACHE pa.*, product_attribute_shop.*, ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, al.`name` AS attribute_name,
a.`id_attribute`, a.`position`
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_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` AND al.`id_lang` = 2)
LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 2)
WHERE pa.`id_product` = 2509
AND pa.`id_product_attribute` = 0
GROUP BY pa.`id_product_attribute`,ag.`id_attribute_group`
ORDER BY pa.`id_product_attribute`
240 ms 0 Yes /classes/Product.php:2839
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` = 1741
ORDER BY `position`
240 ms 1 Yes /classes/Product.php:3517
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` = 2509) AND (b.`id_shop` = 1) LIMIT 1
238 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=2
LEFT JOIN `ps_category_group` cg ON c.`id_category` = cg.`id_category` 
WHERE c.active=1 
AND  c.id_category IN(36,37,38)
AND cg.`id_group` IN (1)
GROUP BY c.id_category ORDER BY c.position ASC,c.id_category ASC
237 ms 3 Yes Yes /modules/ets_megamenu/classes/Ets_megamenu_defines.php:178
SELECT SQL_NO_CACHE *
FROM `ps_order_state` os
LEFT JOIN `ps_order_state_lang` osl ON (os.`id_order_state` = osl.`id_order_state` AND osl.`id_lang` = 2) WHERE deleted = 0
237 ms 35 /override/classes/order/OrderState.php:42
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
235 ms 1 Yes /classes/shop/Shop.php:711
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` = 2509
ORDER BY `position`
234 ms 3 Yes /classes/Product.php:3517
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` = 2138 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` = 2138 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
234 ms 0 /classes/Cart.php:1429
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` = 2139 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` = 2139 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
234 ms 0 /classes/Cart.php:1429
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 2509) LIMIT 1
234 ms 1 /src/Adapter/EntityMapper.php:76
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` = 2513
ORDER BY `position`
233 ms 1 Yes /classes/Product.php:3517
SELECT SQL_NO_CACHE pa.*, product_attribute_shop.*, ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, al.`name` AS attribute_name,
a.`id_attribute`, a.`position`
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_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` AND al.`id_lang` = 2)
LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 2)
WHERE pa.`id_product` = 2512
AND pa.`id_product_attribute` = 0
GROUP BY pa.`id_product_attribute`,ag.`id_attribute_group`
ORDER BY pa.`id_product_attribute`
232 ms 0 Yes /classes/Product.php:2839
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` = 1741
ORDER BY `position`
232 ms 1 Yes /classes/Product.php:3517
SELECT SQL_NO_CACHE *
FROM `ps_category` a0
LEFT JOIN `ps_category_lang` `a1` ON (a0.`id_category` = a1.`id_category`)
WHERE (a0.`nleft` < 321) AND (a0.`nright` > 322) AND (a1.`id_lang` = 2)
ORDER BY a0.`nleft` asc
232 ms 34 Yes /classes/PrestaShopCollection.php:381
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` = 13272
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 1741 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` = 13272
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 1741 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
232 ms 0 /classes/Cart.php:1429
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` = 2512 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` = 2512 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
231 ms 0 /classes/Cart.php:1429
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` = 2508 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` = 2508 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
231 ms 0 /classes/Cart.php:1429
SELECT SQL_NO_CACHE *
FROM `ps_order_state` os
LEFT JOIN `ps_order_state_lang` osl ON (os.`id_order_state` = osl.`id_order_state` AND osl.`id_lang` = 2) WHERE deleted = 0
230 ms 35 /override/classes/order/OrderState.php:42
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` = 14233
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 2508 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` = 14233
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 2508 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
230 ms 0 /classes/Cart.php:1429
(SELECT 1 FROM `ps_cart_rule` WHERE date_to >= "2024-10-05 00:00:00" AND date_to <= "2024-10-05 23:59:59" AND `id_customer` IN (0,0) LIMIT 1)UNION ALL (SELECT 1 FROM `ps_cart_rule` WHERE date_from >= "2024-10-05 00:00:00" AND date_from <= "2024-10-05 23:59:59" AND `id_customer` IN (0,0) LIMIT 1)UNION ALL (SELECT 1 FROM `ps_cart_rule` WHERE date_from < "2024-10-05 00:00:00" AND date_to > "2024-10-05 23:59:59" AND `id_customer` IN (0,0) LIMIT 1) LIMIT 1
229 ms 1 /classes/CartRule.php:383
SELECT SQL_NO_CACHE *
FROM `ps_order_state` os
LEFT JOIN `ps_order_state_lang` osl ON (os.`id_order_state` = osl.`id_order_state` AND osl.`id_lang` = 2) WHERE deleted = 0
228 ms 35 /override/classes/order/OrderState.php:42
SELECT SQL_NO_CACHE c.* FROM `ps_minpurchase_configuration` c WHERE c.`id_shop` = 1
AND c.`active` = 1 AND (date_from <= "2024-10-05 04:40:31" OR date_from = "0000-00-00 00:00:00") AND (date_to >= "2024-10-05 04:40:31" OR date_to = "0000-00-00 00:00:00") ORDER BY c.`priority`, c.`id_minpurchase_configuration` ASC
228 ms 1 Yes /modules/minpurchase/classes/MinpurchaseConfiguration.php:251
SELECT SQL_NO_CACHE pai.`id_image`, pai.`id_product_attribute`, il.`legend`
FROM `ps_product_attribute_image` pai
LEFT JOIN `ps_image_lang` il ON (il.`id_image` = pai.`id_image`)
LEFT JOIN `ps_image` i ON (i.`id_image` = pai.`id_image`)
WHERE pai.`id_product_attribute` IN (13271, 13273, 13274, 13272) AND il.`id_lang` = 2 ORDER by i.`position`
227 ms 4 Yes /classes/Product.php:2898
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` = 2512
ORDER BY `position`
226 ms 1 Yes /classes/Product.php:3517
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=2
LEFT JOIN `ps_category_group` cg ON c.`id_category` = cg.`id_category` 
WHERE c.active=1 
AND  c.id_category IN(231,232,233)
AND cg.`id_group` IN (1)
GROUP BY c.id_category ORDER BY c.position ASC,c.id_category ASC
225 ms 3 Yes Yes /modules/ets_megamenu/classes/Ets_megamenu_defines.php:178
SELECT SQL_NO_CACHE * FROM `ps_whatsappchatblock` LEFT JOIN `ps_whatsappchatblock_lang` ON (`ps_whatsappchatblock`.`id_whatsappchatblock` = `ps_whatsappchatblock_lang`.`id_whatsappchatblock` AND `id_lang` = 2) WHERE `id_hook` = "floating" AND `id_shop` = 1 AND `active` = 1 ORDER BY position DESC;
225 ms 1 Yes /modules/whatsappchat/classes/WhatsappChatBlock.php:130
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=2
LEFT JOIN `ps_category_group` cg ON c.`id_category` = cg.`id_category` 
WHERE c.active=1 
AND  c.id_category IN(12,13,264,266,212,15,182)
AND cg.`id_group` IN (1)
GROUP BY c.id_category ORDER BY c.position ASC,c.id_category ASC
224 ms 7 Yes Yes /modules/ets_megamenu/classes/Ets_megamenu_defines.php:178
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
221 ms 107 /classes/module/Module.php:340
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position
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 = 2513
ORDER BY f.position ASC
218 ms 1 Yes /classes/Product.php:5905
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` = 2139
ORDER BY `position`
217 ms 1 Yes /classes/Product.php:3517
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` = 2513
ORDER BY `position`
217 ms 1 Yes /classes/Product.php:3517
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 2512) LIMIT 1
215 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=2
LEFT JOIN `ps_category_group` cg ON c.`id_category` = cg.`id_category` 
WHERE c.active=1 
AND  c.id_category IN(213,294,214,215,247,170,296)
AND cg.`id_group` IN (1)
GROUP BY c.id_category ORDER BY c.position ASC,c.id_category ASC
214 ms 7 Yes Yes /modules/ets_megamenu/classes/Ets_megamenu_defines.php:178
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` = 2138
ORDER BY `position`
213 ms 3 Yes /classes/Product.php:3517
SELECT SQL_NO_CACHE pa.*, product_attribute_shop.*, ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, al.`name` AS attribute_name,
a.`id_attribute`, a.`position`
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_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` AND al.`id_lang` = 2)
LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 2)
WHERE pa.`id_product` = 2138
AND pa.`id_product_attribute` = 0
GROUP BY pa.`id_product_attribute`,ag.`id_attribute_group`
ORDER BY pa.`id_product_attribute`
213 ms 0 Yes /classes/Product.php:2839
SELECT SQL_NO_CACHE * FROM `ps_whatsappchatblock` LEFT JOIN `ps_whatsappchatblock_lang` ON (`ps_whatsappchatblock`.`id_whatsappchatblock` = `ps_whatsappchatblock_lang`.`id_whatsappchatblock` AND `id_lang` = 2) WHERE `id_hook` = "hookDisplayBeforeBodyClosingTag" AND `id_shop` = 1 AND `active` = 1 ORDER BY position DESC;
213 ms 1 Yes /modules/whatsappchat/classes/WhatsappChatBlock.php:130
SELECT SQL_NO_CACHE COUNT(*) FROM `ps_orders` o
LEFT JOIN `ps_order_cart_rule` ocr ON (ocr.`id_order` = o.`id_order`)
WHERE o.`id_customer` = 0
AND ocr.`deleted` = 0 AND ocr.`id_cart_rule` = 186 LIMIT 1
212 ms 1 /classes/order/Order.php:857
SELECT SQL_NO_CACHE id_tab, class_name FROM `ps_tab`
212 ms 291 /classes/Tab.php:359
SELECT SQL_NO_CACHE * FROM `ps_whatsappchatblock` LEFT JOIN `ps_whatsappchatblock_lang` ON (`ps_whatsappchatblock`.`id_whatsappchatblock` = `ps_whatsappchatblock_lang`.`id_whatsappchatblock` AND `id_lang` = 2) WHERE `id_hook` = "topWidth" AND `id_shop` = 1 AND `active` = 1 ORDER BY position DESC;
212 ms 1 Yes /modules/whatsappchat/classes/WhatsappChatBlock.php:130
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` = 2512
ORDER BY `position`
209 ms 1 Yes /classes/Product.php:3517
SELECT SQL_NO_CACHE pai.`id_image`, pai.`id_product_attribute`, il.`legend`
FROM `ps_product_attribute_image` pai
LEFT JOIN `ps_image_lang` il ON (il.`id_image` = pai.`id_image`)
LEFT JOIN `ps_image` i ON (i.`id_image` = pai.`id_image`)
WHERE pai.`id_product_attribute` IN (14234, 14233) AND il.`id_lang` = 2 ORDER by i.`position`
209 ms 2 Yes /classes/Product.php:2898
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` = 2139) AND (b.`id_shop` = 1) LIMIT 1
208 ms 1 /src/Adapter/EntityMapper.php:76
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` = 2508
ORDER BY `position`
207 ms 4 Yes /classes/Product.php:3517
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` = 2139
ORDER BY `position`
203 ms 1 Yes /classes/Product.php:3517
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` = 58) AND (b.`id_shop` = 1) LIMIT 1
202 ms 1 /src/Adapter/EntityMapper.php:76
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` = 2509) AND (b.`id_shop` = 1) LIMIT 1
202 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE *
FROM `ps_category` a0
LEFT JOIN `ps_category_lang` `a1` ON (a0.`id_category` = a1.`id_category`)
WHERE (a0.`nleft` < 321) AND (a0.`nright` > 322) AND (a1.`id_lang` = 2)
ORDER BY a0.`nleft` asc
201 ms 34 Yes /classes/PrestaShopCollection.php:381
SELECT SQL_NO_CACHE DISTINCT `id_product` FROM `ps_specific_price` WHERE `id_product` != 0
199 ms 321 /classes/SpecificPrice.php:295
SELECT SQL_NO_CACHE *
FROM `ps_whatsappchatblock_agent` LEFT JOIN `ps_whatsappchatblock_agent_lang` ON (`ps_whatsappchatblock_agent`.`id_whatsappchatblock_agent` = `ps_whatsappchatblock_agent_lang`.`id_whatsappchatblock_agent` AND `id_lang` = 2) WHERE 1 = 1 AND `ps_whatsappchatblock_agent`.`id_whatsappchatblock` = 1 AND `active` = 1 ORDER BY position
198 ms 1 Yes /modules/whatsappchat/classes/WhatsappChatBlockAgent.php:71
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 13170201 AND name = '_elementor_version' LIMIT 1
196 ms 6 /modules/creativeelements/classes/wrappers/Post.php:266
SELECT SQL_NO_CACHE *
FROM `ps_order_state` os
LEFT JOIN `ps_order_state_lang` osl ON (os.`id_order_state` = osl.`id_order_state` AND osl.`id_lang` = 2) WHERE deleted = 0
196 ms 35 /override/classes/order/OrderState.php:42
SELECT SQL_NO_CACHE *
FROM `ps_order_state` os
LEFT JOIN `ps_order_state_lang` osl ON (os.`id_order_state` = osl.`id_order_state` AND osl.`id_lang` = 2) WHERE deleted = 0
195 ms 35 /override/classes/order/OrderState.php:42
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 2513) LIMIT 1
195 ms 1 /src/Adapter/EntityMapper.php:76
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` = 183) AND (b.`id_shop` = 1) LIMIT 1
194 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE c.* FROM `ps_minpurchase_configuration` c WHERE c.`id_shop` = 1
AND c.`active` = 1 AND (date_from <= "2024-10-05 04:40:31" OR date_from = "0000-00-00 00:00:00") AND (date_to >= "2024-10-05 04:40:31" OR date_to = "0000-00-00 00:00:00") ORDER BY c.`priority`, c.`id_minpurchase_configuration` ASC
194 ms 1 Yes /modules/minpurchase/classes/MinpurchaseConfiguration.php:251
SELECT SQL_NO_CACHE ctg.`id_group`
FROM `ps_category_product` cp
INNER JOIN `ps_category_group` ctg ON (ctg.`id_category` = cp.`id_category`)
WHERE cp.`id_product` = 1741 AND ctg.`id_group` = 1 LIMIT 1
194 ms 5 /classes/Product.php:6623
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 4170201 AND name = '_elementor_data' LIMIT 1
192 ms 6 /modules/creativeelements/classes/wrappers/Post.php:266
SELECT SQL_NO_CACHE *
FROM `ps_order_state` os
LEFT JOIN `ps_order_state_lang` osl ON (os.`id_order_state` = osl.`id_order_state` AND osl.`id_lang` = 2) WHERE deleted = 0
190 ms 35 /override/classes/order/OrderState.php:42
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` = 2
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
190 ms 11 Yes Yes /classes/Category.php:1146
SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, 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 (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 2)
LEFT JOIN `ps_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `ps_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`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)
LEFT JOIN `ps_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 2)
WHERE pa.`id_product` = 1741
AND pac.`id_product_attribute` = 13272
AND agl.`id_lang` = 2
189 ms 1 /classes/Product.php:7406
SELECT SQL_NO_CACHE *
FROM `ps_manufacturer` a
LEFT JOIN `ps_manufacturer_lang` `b` ON a.`id_manufacturer` = b.`id_manufacturer` AND b.`id_lang` = 2
LEFT JOIN `ps_manufacturer_shop` `c` ON a.`id_manufacturer` = c.`id_manufacturer` AND c.`id_shop` = 1
WHERE (a.`id_manufacturer` = 1) LIMIT 1
188 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 15170201 AND name = '_elementor_data' LIMIT 1
188 ms 6 /modules/creativeelements/classes/wrappers/Post.php:266
SELECT SQL_NO_CACHE *
FROM `ps_currency` a
LEFT JOIN `ps_currency_lang` `b` ON a.`id_currency` = b.`id_currency` AND b.`id_lang` = 2
LEFT JOIN `ps_currency_shop` `c` ON a.`id_currency` = c.`id_currency` AND c.`id_shop` = 1
WHERE (a.`id_currency` = 2) LIMIT 1
187 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE *
FROM `ps_country` a
LEFT JOIN `ps_country_lang` `b` ON a.`id_country` = b.`id_country` AND b.`id_lang` = 1
LEFT JOIN `ps_country_shop` `c` ON a.`id_country` = c.`id_country` AND c.`id_shop` = 1
WHERE (a.`id_country` = 8) LIMIT 1
187 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 2509030201 AND name = '_elementor_edit_mode' LIMIT 1
186 ms 1 /modules/creativeelements/classes/wrappers/Post.php:266
SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, 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 (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 2)
LEFT JOIN `ps_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `ps_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`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)
LEFT JOIN `ps_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 2)
WHERE pa.`id_product` = 2508
AND pac.`id_product_attribute` = 14233
AND agl.`id_lang` = 2
186 ms 1 /classes/Product.php:7406
SELECT SQL_NO_CACHE product_attribute_shop.id_product_attribute
FROM ps_product_attribute pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
WHERE pa.id_product = 1741 LIMIT 1
186 ms 4 /classes/Product.php:1040
SELECT SQL_NO_CACHE *
FROM `ps_group` a
LEFT JOIN `ps_group_shop` `c` ON a.`id_group` = c.`id_group` AND c.`id_shop` = 1
WHERE (a.`id_group` = 1) LIMIT 1
185 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on, product_attribute_shop.`ecotax` AS attribute_ecotax
FROM `ps_product` p
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 (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1)
WHERE (p.`id_product` = 2509)
183 ms 1 /classes/Product.php:3829
SELECT SQL_NO_CACHE product_attribute_shop.id_product_attribute
FROM ps_product_attribute pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
WHERE pa.id_product = 2509 LIMIT 1
183 ms 1 /classes/Product.php:1040
SELECT SQL_NO_CACHE pa.*, product_attribute_shop.*, ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, al.`name` AS attribute_name,
a.`id_attribute`, a.`position`
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_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` AND al.`id_lang` = 2)
LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 2)
WHERE pa.`id_product` = 2139
AND pa.`id_product_attribute` = 0
GROUP BY pa.`id_product_attribute`,ag.`id_attribute_group`
ORDER BY pa.`id_product_attribute`
183 ms 0 Yes /classes/Product.php:2839
SELECT SQL_NO_CACHE pai.`id_image`, pai.`id_product_attribute`, il.`legend`
FROM `ps_product_attribute_image` pai
LEFT JOIN `ps_image_lang` il ON (il.`id_image` = pai.`id_image`)
LEFT JOIN `ps_image` i ON (i.`id_image` = pai.`id_image`)
WHERE pai.`id_product_attribute` IN (14234, 14233) AND il.`id_lang` = 2 ORDER by i.`position`
182 ms 2 Yes /classes/Product.php:2898
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` = 217) AND (b.`id_shop` = 1) LIMIT 1
182 ms 1 /src/Adapter/EntityMapper.php:76
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` = 2512) AND (b.`id_shop` = 1) LIMIT 1
182 ms 1 /src/Adapter/EntityMapper.php:76
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` = 218) AND (b.`id_shop` = 1) LIMIT 1
181 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE *
FROM `ps_product_lang`
WHERE `id_product` = 2509 AND `id_shop` = 1
181 ms 2 /src/Adapter/EntityMapper.php:84
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` = 43) AND (b.`id_shop` = 1) LIMIT 1
181 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE * from ps_kb_global_size_chart where 1 AND active = 1 AND id_shop=1
181 ms 2 /modules/sizechart/classes/KbProductChart.php:86
SELECT SQL_NO_CACHE fp.id_feature, fp.id_product, fp.id_feature_value, custom
FROM `ps_feature_product` fp
LEFT JOIN `ps_feature_value` fv ON (fp.id_feature_value = fv.id_feature_value)
WHERE `id_product` = 2513
181 ms 1 /classes/Product.php:4774
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` = 219) AND (b.`id_shop` = 1) LIMIT 1
181 ms 1 /src/Adapter/EntityMapper.php:76
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` = 49) AND (b.`id_shop` = 1) LIMIT 1
181 ms 1 /src/Adapter/EntityMapper.php:76
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` = 208) AND (b.`id_shop` = 1) LIMIT 1
181 ms 1 /src/Adapter/EntityMapper.php:76
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` = 60) AND (b.`id_shop` = 1) LIMIT 1
180 ms 1 /src/Adapter/EntityMapper.php:76
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` = 46) AND (b.`id_shop` = 1) LIMIT 1
180 ms 1 /src/Adapter/EntityMapper.php:76
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` = 47) AND (b.`id_shop` = 1) LIMIT 1
180 ms 1 /src/Adapter/EntityMapper.php:76
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` = 184) AND (b.`id_shop` = 1) LIMIT 1
180 ms 1 /src/Adapter/EntityMapper.php:76
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` = 226) AND (b.`id_shop` = 1) LIMIT 1
180 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE COUNT(p.id_product)
FROM `ps_product` p
INNER JOIN ps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
WHERE p.id_product = 2509
AND DATEDIFF("2024-10-05 00:00:00", product_shop.`date_add`) < 0 LIMIT 1
180 ms 0 /classes/Product.php:1651
SELECT SQL_NO_CACHE su.physical_uri, su.virtual_uri, su.domain, su.domain_ssl
FROM ps_shop s
LEFT JOIN ps_shop_url su ON (s.id_shop = su.id_shop)
WHERE s.id_shop = 1
AND s.active = 1 AND s.deleted = 0 AND su.main = 1 LIMIT 1
179 ms 1 /classes/shop/Shop.php:205
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` = 1741) AND (b.`id_shop` = 1) LIMIT 1
179 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE fp.id_feature, fp.id_product, fp.id_feature_value, custom
FROM `ps_feature_product` fp
LEFT JOIN `ps_feature_value` fv ON (fp.id_feature_value = fv.id_feature_value)
WHERE `id_product` = 2512
179 ms 1 /classes/Product.php:4774
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` = 2508) AND (b.`id_shop` = 1) LIMIT 1
178 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE p.`id_product` 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)
WHERE id_product_1 = 2509 AND p.active = 1
178 ms 6 /modules/creativeelements/includes/base/widget-product-base.php:2192
SELECT SQL_NO_CACHE l.*, ls.`id_shop`
FROM `ps_lang` l
LEFT JOIN `ps_lang_shop` ls ON (l.id_lang = ls.id_lang)
178 ms 2 /classes/Language.php:1049
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 1741) LIMIT 1
177 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 4170201 AND name = '_elementor_css' LIMIT 1
177 ms 6 /modules/creativeelements/classes/wrappers/Post.php:266
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` = 2138) AND (b.`id_shop` = 1) LIMIT 1
176 ms 1 /src/Adapter/EntityMapper.php:76
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` = 2508
ORDER BY `position`
176 ms 4 Yes /classes/Product.php:3517
SELECT SQL_NO_CACHE * FROM `ps_whatsappchatblock` LEFT JOIN `ps_whatsappchatblock_lang` ON (`ps_whatsappchatblock`.`id_whatsappchatblock` = `ps_whatsappchatblock_lang`.`id_whatsappchatblock` AND `id_lang` = 2) WHERE `id_hook` = "header" AND `id_shop` = 1 AND `active` = 1 ORDER BY position DESC;
176 ms 1 Yes /modules/whatsappchat/classes/WhatsappChatBlock.php:130
SELECT SQL_NO_CACHE COUNT(DISTINCT l.id_lang) FROM `ps_lang` l
JOIN ps_lang_shop lang_shop ON (lang_shop.id_lang = l.id_lang AND lang_shop.id_shop = 1)
WHERE l.`active` = 1 LIMIT 1
176 ms 4 /classes/Language.php:1198
SELECT SQL_NO_CACHE * FROM `ps_whatsappchatblock` LEFT JOIN `ps_whatsappchatblock_lang` ON (`ps_whatsappchatblock`.`id_whatsappchatblock` = `ps_whatsappchatblock_lang`.`id_whatsappchatblock` AND `id_lang` = 2) WHERE `id_hook` = "bottomWidth" AND `id_shop` = 1 AND `active` = 1 ORDER BY position DESC;
176 ms 1 Yes /modules/whatsappchat/classes/WhatsappChatBlock.php:130
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 2138) LIMIT 1
175 ms 1 /src/Adapter/EntityMapper.php:76
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` = 229) AND (b.`id_shop` = 1) LIMIT 1
174 ms 1 /src/Adapter/EntityMapper.php:76
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` = 39) AND (b.`id_shop` = 1) LIMIT 1
174 ms 1 /src/Adapter/EntityMapper.php:76
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` = 227) AND (b.`id_shop` = 1) LIMIT 1
174 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE id_size_chart from ps_kb_product_chart where id_product = 2509 AND active = 1 and id_shop=1 LIMIT 1
174 ms 1 /modules/sizechart/classes/KbProductChart.php:109
(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` = 2)
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 cr.`quantity` > 0 AND highlight = 1 AND code NOT LIKE "BO_ORDER_%")
173 ms 1 /classes/CartRule.php:444
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` = 228) AND (b.`id_shop` = 1) LIMIT 1
173 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE `id_country`
FROM `ps_country`
WHERE `iso_code` = 'US' AND active = 1 LIMIT 1
173 ms 1 /classes/Country.php:193
SELECT SQL_NO_CACHE product_attribute_shop.id_product_attribute
FROM ps_product_attribute pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
WHERE product_attribute_shop.default_on = 1  AND pa.id_product = 1741 LIMIT 1
173 ms 4 /classes/Product.php:1054
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 4170201 AND name = '_elementor_css' LIMIT 1
173 ms 6 /modules/creativeelements/classes/wrappers/Post.php:266
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` = 231) AND (b.`id_shop` = 1) LIMIT 1
172 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE *
FROM `ps_ets_mm_column`
WHERE 1  AND id_menu=3
ORDER BY sort_order asc
172 ms 14 Yes /modules/ets_megamenu/classes/MM_Column.php:128
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 4170201 AND name = '_elementor_edit_mode' LIMIT 1
172 ms 6 /modules/creativeelements/classes/wrappers/Post.php:266
SELECT SQL_NO_CACHE name, alias FROM `ps_hook_alias`
171 ms 88 /classes/Hook.php:353
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on, product_attribute_shop.`ecotax` AS attribute_ecotax
FROM `ps_product` p
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 (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1)
WHERE (p.`id_product` = 2513)
171 ms 1 /classes/Product.php:3829
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `ps_product_attribute`
WHERE `id_product` = 2508
171 ms 2 /classes/Product.php:2879
SELECT SQL_NO_CACHE image_shop.`id_image`
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)
WHERE i.`id_product` = 2509
AND image_shop.`cover` = 1 LIMIT 1
170 ms 3 /classes/Product.php:3542
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 4170201 AND name = '_elementor_data' LIMIT 1
169 ms 6 /modules/creativeelements/classes/wrappers/Post.php:266
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `ps_product_attribute`
WHERE `id_product` = 1741
169 ms 4 /classes/Product.php:2879
SELECT SQL_NO_CACHE 1 FROM ps_cart_product cp INNER JOIN ps_product p
ON (p.id_product = cp.id_product) INNER JOIN ps_product_shop ps
ON (ps.id_shop = cp.id_shop AND ps.id_product = p.id_product) WHERE cp.id_cart=0 LIMIT 1
168 ms 1 /classes/Cart.php:4218
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `ps_product_attribute`
WHERE `id_product` = 2138
168 ms 1 /classes/Product.php:2879
SELECT SQL_NO_CACHE * FROM `ps_whatsappchatblock` LEFT JOIN `ps_whatsappchatblock_lang` ON (`ps_whatsappchatblock`.`id_whatsappchatblock` = `ps_whatsappchatblock_lang`.`id_whatsappchatblock` AND `id_lang` = 2) WHERE `id_hook` = "hookDisplayWrapperBottom" AND `id_shop` = 1 AND `active` = 1 ORDER BY position DESC;
168 ms 1 Yes /modules/whatsappchat/classes/WhatsappChatBlock.php:130
SELECT SQL_NO_CACHE `id_order`
FROM `ps_orders`
WHERE `id_cart` = 0 AND id_shop IN (1) LIMIT 1
167 ms 1 /classes/order/Order.php:1203
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 4170201 AND name = '_elementor_edit_mode' LIMIT 1
166 ms 6 /modules/creativeelements/classes/wrappers/Post.php:266
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=2
LEFT JOIN `ps_category_group` cg ON c.`id_category` = cg.`id_category` 
WHERE c.active=1 
AND  c.id_category IN(303)
AND cg.`id_group` IN (1)
GROUP BY c.id_category ORDER BY cl.name ASC,c.id_category ASC
166 ms 0 Yes /modules/ets_megamenu/classes/Ets_megamenu_defines.php:178
SELECT SQL_NO_CACHE COUNT(*) FROM `ps_orders` o
LEFT JOIN `ps_order_cart_rule` ocr ON (ocr.`id_order` = o.`id_order`)
WHERE o.`id_customer` = 0
AND ocr.`deleted` = 0 AND ocr.`id_cart_rule` = 93 LIMIT 1
166 ms 1 /classes/order/Order.php:857
SELECT SQL_NO_CACHE *
FROM `ps_ce_theme` a
LEFT JOIN `ps_ce_theme_lang` `b` ON a.`id_ce_theme` = b.`id_ce_theme` AND b.`id_lang` = 2
LEFT JOIN `ps_ce_theme_shop` `c` ON a.`id_ce_theme` = c.`id_ce_theme` AND c.`id_shop` = 1
WHERE (a.`id_ce_theme` = 4) AND (b.`id_shop` = 1) LIMIT 1
166 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position
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 = 1741
ORDER BY f.position ASC
166 ms 1 Yes /classes/Product.php:5905
SELECT SQL_NO_CACHE COUNT(DISTINCT c.id_currency) FROM `ps_currency` c
LEFT JOIN ps_currency_shop cs ON (cs.id_currency = c.id_currency AND cs.id_shop = 1)
WHERE c.`active` = 1 LIMIT 1
166 ms 2 /classes/Currency.php:1126
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on, product_attribute_shop.`ecotax` AS attribute_ecotax
FROM `ps_product` p
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 (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1)
WHERE (p.`id_product` = 2512)
165 ms 1 /classes/Product.php:3829
SELECT SQL_NO_CACHE *
FROM `ps_country` a
LEFT JOIN `ps_country_lang` `b` ON a.`id_country` = b.`id_country` AND b.`id_lang` = 2
LEFT JOIN `ps_country_shop` `c` ON a.`id_country` = c.`id_country` AND c.`id_shop` = 1
WHERE (a.`id_country` = 8) LIMIT 1
165 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 15170201 AND name = '_elementor_page_settings' LIMIT 1
165 ms 6 /modules/creativeelements/classes/wrappers/Post.php:266
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on, product_attribute_shop.`ecotax` AS attribute_ecotax
FROM `ps_product` p
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 (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1)
WHERE (p.`id_product` = 2138)
165 ms 1 /classes/Product.php:3829
SELECT SQL_NO_CACHE pai.`id_image`, pai.`id_product_attribute`, il.`legend`
FROM `ps_product_attribute_image` pai
LEFT JOIN `ps_image_lang` il ON (il.`id_image` = pai.`id_image`)
LEFT JOIN `ps_image` i ON (i.`id_image` = pai.`id_image`)
WHERE pai.`id_product_attribute` IN (13271, 13273, 13274, 13272) AND il.`id_lang` = 2 ORDER by i.`position`
164 ms 4 Yes /classes/Product.php:2898
SELECT SQL_NO_CACHE m.`id_module` as `active`, ms.`id_module` as `shop_active`
FROM `ps_module` m
LEFT JOIN `ps_module_shop` ms ON m.`id_module` = ms.`id_module`
WHERE `name` = "ps_categorytree"
AND ms.`id_shop` IN (1) LIMIT 1
164 ms 1 /src/Adapter/Module/ModuleDataProvider.php:174
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position
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 = 2138
ORDER BY f.position ASC
164 ms 1 Yes /classes/Product.php:5905
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` = 50) AND (b.`id_shop` = 1) LIMIT 1
164 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE *
FROM `ps_group_lang`
WHERE `id_group` = 1
164 ms 2 /src/Adapter/EntityMapper.php:84
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `ps_product_attribute`
WHERE `id_product` = 1741
163 ms 4 /classes/Product.php:2879
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` = 48) AND (b.`id_shop` = 1) LIMIT 1
163 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE *
FROM `ps_hiupsell_cart`
WHERE `id_product` = 2509
AND id_cart = 0 LIMIT 1
163 ms 1 /modules/hiupsell/hiupsell.php:356
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` = 11) AND (b.`id_shop` = 1) LIMIT 1
163 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=2
LEFT JOIN `ps_category_group` cg ON c.`id_category` = cg.`id_category` 
WHERE c.active=1 
AND  c.id_category IN(297)
AND cg.`id_group` IN (1)
GROUP BY c.id_category ORDER BY cl.name ASC,c.id_category ASC
162 ms 0 Yes /modules/ets_megamenu/classes/Ets_megamenu_defines.php:178
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position
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 = 2139
ORDER BY f.position ASC
162 ms 1 Yes /classes/Product.php:5905
SELECT SQL_NO_CACHE *
FROM `ps_manufacturer` a
LEFT JOIN `ps_manufacturer_lang` `b` ON a.`id_manufacturer` = b.`id_manufacturer` AND b.`id_lang` = 2
LEFT JOIN `ps_manufacturer_shop` `c` ON a.`id_manufacturer` = c.`id_manufacturer` AND c.`id_shop` = 1
WHERE (a.`id_manufacturer` = 56) LIMIT 1
162 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE ctg.`id_group`
FROM `ps_category_product` cp
INNER JOIN `ps_category_group` ctg ON (ctg.`id_category` = cp.`id_category`)
WHERE cp.`id_product` = 2509 AND ctg.`id_group` = 1 LIMIT 1
162 ms 10 /classes/Product.php:6623
SELECT SQL_NO_CACHE * FROM `ps_whatsappchatblock` LEFT JOIN `ps_whatsappchatblock_lang` ON (`ps_whatsappchatblock`.`id_whatsappchatblock` = `ps_whatsappchatblock_lang`.`id_whatsappchatblock` AND `id_lang` = 2) WHERE `id_hook` = "badge" AND `id_shop` = 1 AND `active` = 1 ORDER BY position DESC;
162 ms 1 Yes /modules/whatsappchat/classes/WhatsappChatBlock.php:130
SELECT SQL_NO_CACHE id_registration FROM `ps_ets_mp_registration` WHERE id_customer="0" AND id_shop="1" LIMIT 1
162 ms 1 /modules/ets_marketplace/classes/registration.php:102
SELECT SQL_NO_CACHE * FROM `ps_rewards_template_config` WHERE `value`=1 AND `name`='RSPONSORSHIP_ACTIVE' LIMIT 1
162 ms 1 /modules/allinone_rewards/models/RewardsTemplateModel.php:138