totoTrimming cutter MICHEL VAILLANT

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

Trimming cutter MICHEL VAILLANT

0/5

Trimming cutter with 4 reversible and interchangeable tungsten carbide

Référence : FRAISEPARERMV
€770.00
€770.00
Declination
En stock
Partager

Partager le lien

Trimming cutter with 4 reversible and interchangeable tungsten carbide heads. Fits to an angle grinder. No vibration. Excellent cut. Diameter 115 mm. Weight 590 g.

Trimming cutter with 4 reversible and interchangeable tungsten carbide heads. Fits to an angle grinder. No vibration. Excellent cut. Diameter 115 mm. Weight 590 g.

Category Trimming cattle Brand Michel Vaillant EAN13 3700044704298

Les avis sur notre produit

Comments (0)

Vous aimerez aussi...

Load Time 807 ms
Querying Time 109 ms
Queries 633
Memory Peak Usage 54.0 Mb
Included Files 1645 files - 20.95 Mb
PrestaShop Cache - Mb
Global vars 1.12 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 17 ms 17 ms 7.27 Mb 9.9 Mb
__construct 0 ms 17 ms - Mb 9.9 Mb
init 23 ms 40 ms 3.18 Mb 10.8 Mb
checkAccess 0 ms 40 ms - Mb 10.8 Mb
setMedia 4 ms 44 ms 0.48 Mb 11.2 Mb
postProcess 0 ms 44 ms - Mb 11.2 Mb
initHeader 0 ms 44 ms - Mb 11.2 Mb
initContent 110 ms 154 ms 8.51 Mb 19.5 Mb
initFooter 0 ms 154 ms - Mb 19.5 Mb
display 652 ms 807 ms 33.59 Mb 54.0 Mb
Hook Time Memory Usage
OverrideLayoutTemplate 625 ms 32.17 Mb
displayNavFullWidth 52 ms 4.03 Mb
DisplayBlock 44 ms 3.44 Mb
DisplayHeader 34 ms 2.95 Mb
ActionOutputHTMLBefore 10 ms - Mb
ModuleRoutes 10 ms 1.58 Mb
DisplayProductPriceBlock 7 ms 0.60 Mb
Header 5 ms 0.23 Mb
displayFooterProduct 4 ms 0.11 Mb
DisplayFooter 4 ms 0.26 Mb
DisplayBeforeBodyClosingTag 3 ms 0.14 Mb
DisplayProductButtons 2 ms 0.27 Mb
FilterProductContent 2 ms 0.38 Mb
displayFlagProduct 2 ms 0.04 Mb
displayGtag 2 ms 0.09 Mb
ActionFrontControllerSetMedia 1 ms - Mb
DisplayGDPRConsent 1 ms 0.04 Mb
ActionGetProductPropertiesAfter 0 ms 0.02 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) 808 ms 46.24 Mb
Module Time Memory Usage
ybc_instagram 4 ms 0.29 Mb
colissimo 1 ms 0.42 Mb
hiupsell 2 ms 0.13 Mb
ets_marketplace 9 ms - Mb
ets_contactform7 11 ms 4.16 Mb
dpdfrance 1 ms - Mb
ets_awesomeurl 1 ms 0.18 Mb
ets_extraoptions 3 ms 0.19 Mb
creativeelements 634 ms 33.09 Mb
blockwishlist 2 ms 0.11 Mb
ps_emailsubscription 2 ms 0.22 Mb
blockreassurance 0 ms 0.03 Mb
allinone_rewards 5 ms 0.57 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 0 ms 0.02 Mb
ps_shoppingcart 0 ms 0.03 Mb
layerslider 3 ms 0.07 Mb
ets_megamenu 101 ms 8.80 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.07 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 15 ms 0.42 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 4 ms 0.15 Mb
lgcookieslaw 1 ms 0.08 Mb
40 module(s) 837 ms 49.17 Mb

Stopwatch SQL - 633 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`)
5569 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`)
5357 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
1701 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`
1649 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
1183 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
915 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
912 ms 0 /classes/Hook.php:1243
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
864 ms 193 Yes /modules/creativeelements/includes/base/widget-category-base.php:146
(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)
858 ms 1 /classes/CartRule.php:444
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` = 1616 AND product_shop.`active` = 1 AND product_shop.`visibility` != 'none'
GROUP BY product_shop.id_product
537 ms 4 Yes /classes/Product.php:4639
SELECT SQL_NO_CACHE ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, agl.`public_name` AS public_group_name,
a.`id_attribute`, al.`name` AS attribute_name, a.`color` AS attribute_color, product_attribute_shop.`id_product_attribute`,
IFNULL(stock.quantity, 0) as quantity, product_attribute_shop.`price`, product_attribute_shop.`ecotax`, product_attribute_shop.`weight`,
product_attribute_shop.`default_on`, pa.`reference`, pa.`ean13`, pa.`mpn`, pa.`upc`, pa.`isbn`, product_attribute_shop.`unit_price_impact`,
product_attribute_shop.`minimal_quantity`, product_attribute_shop.`available_date`, ag.`group_type`
FROM `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
LEFT JOIN ps_stock_available stock
ON (stock.id_product = `pa`.id_product AND stock.id_product_attribute = IFNULL(`pa`.id_product_attribute, 0) AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
LEFT JOIN `ps_product_attribute_combination` pac ON (pac.`id_product_attribute` = pa.`id_product_attribute`)
LEFT JOIN `ps_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
LEFT JOIN `ps_attribute_group` ag ON (ag.`id_attribute_group` = a.`id_attribute_group`)
LEFT JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute`)
LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group`)
INNER JOIN ps_attribute_shop attribute_shop
ON (attribute_shop.id_attribute = a.id_attribute AND attribute_shop.id_shop = 1)
WHERE pa.`id_product` = 1616
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
488 ms 3 Yes Yes /classes/Product.php:4549
DELETE FROM `ps_configuration_lang`
WHERE `id_configuration` IN (
SELECT `id_configuration`
FROM `ps_configuration`
WHERE `name` = "PS_ROUTE_etsmpshops"
)
469 ms 1 /classes/Configuration.php:570
DELETE FROM `ps_configuration_lang`
WHERE `id_configuration` IN (
SELECT `id_configuration`
FROM `ps_configuration`
WHERE `name` = "PS_ROUTE_etsmpshopsseller"
)
444 ms 1 /classes/Configuration.php:570
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="1616")
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="205")  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
441 ms 12 Yes /modules/ets_extraoptions/classes/ets_eto_attribute_class.php:532
SELECT SQL_NO_CACHE lower(name) as name
FROM `ps_hook` h
WHERE (h.active = 1)
433 ms 948 /classes/Hook.php:1283
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
428 ms 3 Yes /modules/ets_megamenu/classes/MM_Block.php:617
SELECT SQL_NO_CACHE * FROM `ps_state` ORDER BY `name` ASC
407 ms 352 Yes /classes/Country.php:154
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 = 1810
LIMIT 1
404 ms 6 /classes/ProductAssembler.php:106
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` = 1616
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
400 ms 3 Yes Yes /classes/Product.php:4549
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="1616")
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="205")  AND (cap.used=1 OR ((cap.used=-1 OR cap.used IS NULL) AND a.used=1))  AND a.id_product="1616" AND a.id_ets_eto_attr_group=1 ORDER BY sort_order ASC
381 ms 3 Yes /modules/ets_extraoptions/classes/ets_eto_attribute_class.php:532
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="1616")
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="205")  AND (cap.used=1 OR ((cap.used=-1 OR cap.used IS NULL) AND a.used=1))  AND a.id_product="1616" AND a.id_ets_eto_attr_group=0 ORDER BY sort_order ASC
362 ms 3 Yes /modules/ets_extraoptions/classes/ets_eto_attribute_class.php:532
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 = 1472
LIMIT 1
352 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=23 
ORDER BY b.sort_order asc,bl.title asc
348 ms 1 Yes /modules/ets_megamenu/classes/MM_Block.php:617
SELECT SQL_NO_CACHE ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, agl.`public_name` AS public_group_name,
a.`id_attribute`, al.`name` AS attribute_name, a.`color` AS attribute_color, product_attribute_shop.`id_product_attribute`,
IFNULL(stock.quantity, 0) as quantity, product_attribute_shop.`price`, product_attribute_shop.`ecotax`, product_attribute_shop.`weight`,
product_attribute_shop.`default_on`, pa.`reference`, pa.`ean13`, pa.`mpn`, pa.`upc`, pa.`isbn`, product_attribute_shop.`unit_price_impact`,
product_attribute_shop.`minimal_quantity`, product_attribute_shop.`available_date`, ag.`group_type`
FROM `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
LEFT JOIN ps_stock_available stock
ON (stock.id_product = `pa`.id_product AND stock.id_product_attribute = IFNULL(`pa`.id_product_attribute, 0) AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
LEFT JOIN `ps_product_attribute_combination` pac ON (pac.`id_product_attribute` = pa.`id_product_attribute`)
LEFT JOIN `ps_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
LEFT JOIN `ps_attribute_group` ag ON (ag.`id_attribute_group` = a.`id_attribute_group`)
LEFT JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute`)
LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group`)
INNER JOIN ps_attribute_shop attribute_shop
ON (attribute_shop.id_attribute = a.id_attribute AND attribute_shop.id_shop = 1)
WHERE pa.`id_product` = 1616
AND al.`id_lang` = 2
AND agl.`id_lang` = 2
AND product_attribute_shop.`id_product_attribute` = 13074 GROUP BY id_attribute_group, id_product_attribute
ORDER BY ag.`position` ASC, a.`position` ASC, agl.`name` ASC
348 ms 1 Yes Yes /classes/Product.php:4549
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="1616")
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="205")  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
344 ms 3 Yes /modules/ets_extraoptions/classes/ets_eto_attribute_class.php:532
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 = 1440
LIMIT 1
344 ms 2 /classes/ProductAssembler.php:106
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` = 205
AND `active` = 1
AND cg.`id_group` =1
GROUP BY c.`id_category`
ORDER BY `level_depth` ASC, category_shop.`position` ASC
342 ms 1 Yes Yes /classes/Category.php:919
SELECT SQL_NO_CACHE `id_hook`, `name` FROM `ps_hook`
337 ms 948 /classes/Hook.php:1243
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` = 1616
AND al.`id_lang` = 2
AND agl.`id_lang` = 2
AND product_attribute_shop.`id_product_attribute` = 13074 GROUP BY id_attribute_group, id_product_attribute
ORDER BY ag.`position` ASC, a.`position` ASC, agl.`name` ASC
336 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
327 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` = 1616
AND al.`id_lang` = 2
AND agl.`id_lang` = 2
AND product_attribute_shop.`id_product_attribute` = 13074 GROUP BY id_attribute_group, id_product_attribute
ORDER BY ag.`position` ASC, a.`position` ASC, agl.`name` ASC
324 ms 1 Yes Yes /classes/Product.php:4549
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` = 1616
321 ms 3 /classes/Product.php:7435
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
310 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=10 
ORDER BY b.sort_order asc,bl.title asc
306 ms 3 Yes /modules/ets_megamenu/classes/MM_Block.php:617
SELECT SQL_NO_CACHE b.*,bl.title,bl.title_link,bl.content,bl.image_link
FROM `ps_ets_mm_block` b
LEFT JOIN `ps_ets_mm_block_lang` bl
ON b.id_block=bl.id_block AND bl.id_lang=2
WHERE 1  AND b.id_column=20 
ORDER BY b.sort_order asc,bl.title asc
304 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=1 
ORDER BY b.sort_order asc,bl.title asc
300 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=8 
ORDER BY b.sort_order asc,bl.title asc
299 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
294 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
293 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=24 
ORDER BY b.sort_order asc,bl.title asc
292 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=17 
ORDER BY b.sort_order asc,bl.title asc
292 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
290 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
290 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
290 ms 1 Yes /modules/ets_megamenu/classes/MM_Block.php:617
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` = 1616
AND pa.`id_product_attribute` = 13076
GROUP BY pa.`id_product_attribute`,ag.`id_attribute_group`
ORDER BY pa.`id_product_attribute`
287 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` = 1616
AND pa.`id_product_attribute` = 13075
GROUP BY pa.`id_product_attribute`,ag.`id_attribute_group`
ORDER BY pa.`id_product_attribute`
285 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(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
284 ms 7 Yes Yes /modules/ets_megamenu/classes/Ets_megamenu_defines.php:178
SELECT SQL_NO_CACHE c.*, cl.name,cl.link_rewrite
FROM `ps_category` c
INNER JOIN `ps_category_shop` cs ON (c.id_category=cs.id_category AND cs.id_shop=1)
LEFT JOIN `ps_category_lang` cl ON c.id_category=cl.id_category AND cl.id_lang=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
278 ms 7 Yes Yes /modules/ets_megamenu/classes/Ets_megamenu_defines.php:178
SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT cp.`quantity` as first_level_quantity, 0 as pack_quantity
FROM `ps_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 1616 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` = 1616 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
278 ms 0 /classes/Cart.php:1429
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
276 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
272 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
270 ms 107 /classes/module/Module.php:340
SELECT SQL_NO_CACHE COUNT(*) FROM (SELECT DISTINCT `id_product_attribute` FROM `ps_specific_price` WHERE `id_product_attribute` != 0 GROUP BY id_product ) AS counted LIMIT 1
268 ms 67731 /classes/SpecificPrice.php:287
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
265 ms 107 /classes/module/Module.php:340
SELECT SQL_NO_CACHE *
FROM `ps_manufacturer` a
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
264 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
263 ms 7 Yes Yes /modules/ets_megamenu/classes/Ets_megamenu_defines.php:178
SELECT SQL_NO_CACHE DISTINCT `id_product_attribute` FROM `ps_specific_price` WHERE `id_product_attribute` != 0
262 ms 212 /classes/SpecificPrice.php:295
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 13170201 AND name = '_elementor_version' LIMIT 1
262 ms 6 /modules/creativeelements/classes/wrappers/Post.php:266
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
262 ms 107 /classes/module/Module.php:340
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
258 ms 1 Yes /classes/shop/Shop.php:1350
(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
256 ms 1 /classes/CartRule.php:383
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 = 2701
LIMIT 1
255 ms 3 /classes/ProductAssembler.php:106
SELECT SQL_NO_CACHE c.*, cl.name,cl.link_rewrite
FROM `ps_category` c
INNER JOIN `ps_category_shop` cs ON (c.id_category=cs.id_category AND cs.id_shop=1)
LEFT JOIN `ps_category_lang` cl ON c.id_category=cl.id_category AND cl.id_lang=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
253 ms 6 Yes Yes /modules/ets_megamenu/classes/Ets_megamenu_defines.php:178
SELECT SQL_NO_CACHE c.*, cl.name,cl.link_rewrite
FROM `ps_category` c
INNER JOIN `ps_category_shop` cs ON (c.id_category=cs.id_category AND cs.id_shop=1)
LEFT JOIN `ps_category_lang` cl ON c.id_category=cl.id_category AND cl.id_lang=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
252 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
249 ms 107 /classes/module/Module.php:340
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
248 ms 4 Yes Yes /modules/ets_megamenu/classes/Ets_megamenu_defines.php:178
SELECT SQL_NO_CACHE DISTINCT `id_product` FROM `ps_specific_price` WHERE `id_product` != 0
248 ms 321 /classes/SpecificPrice.php:295
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` = 1440
ORDER BY `position`
245 ms 3 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(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
244 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(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
242 ms 7 Yes Yes /modules/ets_megamenu/classes/Ets_megamenu_defines.php:178
SELECT SQL_NO_CACHE c.*, cl.name,cl.link_rewrite
FROM `ps_category` c
INNER JOIN `ps_category_shop` cs ON (c.id_category=cs.id_category AND cs.id_shop=1)
LEFT JOIN `ps_category_lang` cl ON c.id_category=cl.id_category AND cl.id_lang=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
239 ms 3 Yes Yes /modules/ets_megamenu/classes/Ets_megamenu_defines.php:178
SELECT SQL_NO_CACHE c.*, cl.name,cl.link_rewrite
FROM `ps_category` c
INNER JOIN `ps_category_shop` cs ON (c.id_category=cs.id_category AND cs.id_shop=1)
LEFT JOIN `ps_category_lang` cl ON c.id_category=cl.id_category AND cl.id_lang=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
239 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(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
238 ms 5 Yes Yes /modules/ets_megamenu/classes/Ets_megamenu_defines.php:178
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
236 ms 1 Yes /classes/shop/Shop.php:711
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 = 1616 AND p.active = 1
236 ms 4 /modules/creativeelements/includes/base/widget-product-base.php:2192
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` = 2701
ORDER BY `position`
233 ms 2 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(36,37,38)
AND cg.`id_group` IN (1)
GROUP BY c.id_category ORDER BY c.position ASC,c.id_category ASC
233 ms 3 Yes Yes /modules/ets_megamenu/classes/Ets_megamenu_defines.php:178
SELECT SQL_NO_CACHE DISTINCT a.`id_attribute`, a.`id_attribute_group`, al.`name` as `attribute`, agl.`name` as `group`,pa.`reference`, pa.`ean13`, pa.`isbn`, pa.`upc`, pa.`mpn`
FROM `ps_attribute` a
LEFT JOIN `ps_attribute_lang` al
ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 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` = 1616
232 ms 3 /classes/Product.php:7435
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
230 ms 4 Yes Yes /modules/ets_megamenu/classes/MM_Menu.php:500
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 13170201 AND name = '_elementor_css' LIMIT 1
228 ms 6 /modules/creativeelements/classes/wrappers/Post.php:266
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` = 1810
ORDER BY `position`
226 ms 2 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` = "hookDisplayWrapperBottom" AND `id_shop` = 1 AND `active` = 1 ORDER BY position DESC;
226 ms 1 Yes /modules/whatsappchat/classes/WhatsappChatBlock.php:130
SELECT SQL_NO_CACHE *
FROM `ps_category` a0
LEFT JOIN `ps_category_lang` `a1` ON (a0.`id_category` = a1.`id_category`)
WHERE (a0.`nleft` < 120) AND (a0.`nright` > 121) AND (a1.`id_lang` = 2)
ORDER BY a0.`nleft` asc
226 ms 193 Yes /classes/PrestaShopCollection.php:381
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
225 ms 103041 /classes/SpecificPrice.php:287
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` = 1616
AND pa.`id_product_attribute` = 13074
GROUP BY pa.`id_product_attribute`,ag.`id_attribute_group`
ORDER BY pa.`id_product_attribute`
225 ms 1 Yes /classes/Product.php:2839
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
224 ms 35 /override/classes/order/OrderState.php:42
(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_%")
224 ms 1 /classes/CartRule.php:444
SELECT SQL_NO_CACHE c.*, cl.name,cl.link_rewrite
FROM `ps_category` c
INNER JOIN `ps_category_shop` cs ON (c.id_category=cs.id_category AND cs.id_shop=1)
LEFT JOIN `ps_category_lang` cl ON c.id_category=cl.id_category AND cl.id_lang=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
223 ms 4 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
221 ms 35 /override/classes/order/OrderState.php:42
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
220 ms 1 /classes/tax/TaxRulesTaxManager.php:109
SELECT SQL_NO_CACHE *
FROM `ps_category` a0
LEFT JOIN `ps_category_lang` `a1` ON (a0.`id_category` = a1.`id_category`)
WHERE (a0.`nleft` < 120) AND (a0.`nright` > 121) AND (a1.`id_lang` = 2)
ORDER BY a0.`nleft` asc
219 ms 193 Yes /classes/PrestaShopCollection.php:381
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 05:00:47" OR date_from = "0000-00-00 00:00:00") AND (date_to >= "2024-10-05 05:00:47" OR date_to = "0000-00-00 00:00:00") ORDER BY c.`priority`, c.`id_minpurchase_configuration` ASC
212 ms 1 Yes /modules/minpurchase/classes/MinpurchaseConfiguration.php:251
SELECT SQL_NO_CACHE id_tab, class_name FROM `ps_tab`
212 ms 291 /classes/Tab.php:359
SELECT SQL_NO_CACHE *
FROM `ps_category` a0
LEFT JOIN `ps_category_lang` `a1` ON (a0.`id_category` = a1.`id_category`)
WHERE (a0.`nleft` < 120) AND (a0.`nright` > 121) AND (a1.`id_lang` = 2)
ORDER BY a0.`nleft` asc
211 ms 193 Yes /classes/PrestaShopCollection.php:381
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;
211 ms 1 Yes /modules/whatsappchat/classes/WhatsappChatBlock.php:130
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` = 1440 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` = 1440 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
211 ms 0 /classes/Cart.php:1429
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;
210 ms 1 Yes /modules/whatsappchat/classes/WhatsappChatBlock.php:130
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;
209 ms 1 Yes /modules/whatsappchat/classes/WhatsappChatBlock.php:130
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` = 1810
AND pa.`id_product_attribute` = 13312
GROUP BY pa.`id_product_attribute`,ag.`id_attribute_group`
ORDER BY pa.`id_product_attribute`
209 ms 1 Yes /classes/Product.php:2839
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` = 1440) LIMIT 1
208 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 05:00:47" OR date_from = "0000-00-00 00:00:00") AND (date_to >= "2024-10-05 05:00:47" OR date_to = "0000-00-00 00:00:00") ORDER BY c.`priority`, c.`id_minpurchase_configuration` ASC
206 ms 1 Yes /modules/minpurchase/classes/MinpurchaseConfiguration.php:251
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` = 2701
AND pa.`id_product_attribute` = 12226
GROUP BY pa.`id_product_attribute`,ag.`id_attribute_group`
ORDER BY pa.`id_product_attribute`
206 ms 1 Yes /classes/Product.php:2839
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
204 ms 1 /src/Adapter/EntityMapper.php:76
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
202 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` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 1472 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` = 1472 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
202 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` = 1616) LIMIT 1
201 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 05:00:47" OR date_from = "0000-00-00 00:00:00") AND (date_to >= "2024-10-05 05:00:47" OR date_to = "0000-00-00 00:00:00") ORDER BY c.`priority`, c.`id_minpurchase_configuration` ASC
199 ms 1 Yes /modules/minpurchase/classes/MinpurchaseConfiguration.php:251
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` = 1810 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` = 1810 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
198 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
198 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` = 2701 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` = 2701 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
198 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` = 13074
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 1616 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` = 13074
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 1616 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
198 ms 0 /classes/Cart.php:1429
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` = 1616)
197 ms 3 /classes/Product.php:3829
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` = 12226
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 2701 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` = 12226
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 2701 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
196 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` = 13312
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 1810 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` = 13312
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 1810 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
195 ms 0 /classes/Cart.php:1429
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
194 ms 1 /src/Adapter/EntityMapper.php:76
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
193 ms 35 /override/classes/order/OrderState.php:42
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` = 2701
AND pac.`id_product_attribute` = 12226
AND agl.`id_lang` = 2
193 ms 1 /classes/Product.php:7406
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
192 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
191 ms 107 /classes/module/Module.php:340
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 1 FROM ps_module_group WHERE id_module = 11 AND id_shop = 1 AND id_group IN (1) LIMIT 1
190 ms 1 /modules/creativeelements/includes/widgets/module.php:174
SELECT SQL_NO_CACHE conf.* FROM `ps_minpurchase_configuration` conf WHERE conf.`id_shop` = 1
AND conf.`active` = 1
189 ms 1 /modules/minpurchase/minpurchase.php:487
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 205) LIMIT 1
189 ms 1 /src/Adapter/EntityMapper.php:76
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
187 ms 35 /override/classes/order/OrderState.php:42
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` = 1440) AND (b.`id_shop` = 1) LIMIT 1
186 ms 1 /src/Adapter/EntityMapper.php:76
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
185 ms 1 Yes /classes/SpecificPrice.php:624
SELECT SQL_NO_CACHE id_registration FROM `ps_ets_mp_registration` WHERE id_customer="0" AND id_shop="1" LIMIT 1
185 ms 1 /modules/ets_marketplace/classes/registration.php:102
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
185 ms 107 /classes/module/Module.php:340
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
181 ms 1 /classes/shop/Shop.php:205
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` = 23) AND (b.`id_shop` = 1) LIMIT 1
181 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 4170201 AND name = '_elementor_edit_mode' LIMIT 1
181 ms 6 /modules/creativeelements/classes/wrappers/Post.php:266
SELECT SQL_NO_CACHE reference FROM ps_product_attribute WHERE id_product_attribute = 13074 LIMIT 1
181 ms 1 /modules/seq_caracs/seq_caracs.php:115
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` = 18) AND (b.`id_shop` = 1) LIMIT 1
180 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` = 2701
ORDER BY `position`
180 ms 2 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` = 2
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 1616) AND (b.`id_shop` = 1) LIMIT 1
178 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` = 1810) AND (b.`id_shop` = 1) LIMIT 1
178 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
177 ms 6 /modules/creativeelements/classes/wrappers/Post.php:266
SELECT SQL_NO_CACHE psgdprl.message FROM `ps_psgdpr_consent` psgdpr
LEFT JOIN ps_psgdpr_consent_lang psgdprl ON (psgdpr.id_gdpr_consent = psgdprl.id_gdpr_consent)
WHERE psgdpr.id_module = 11 AND psgdprl.id_lang =2 LIMIT 1
177 ms 4 /modules/psgdpr/classes/GDPRConsent.php:111
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` = 185) AND (b.`id_shop` = 1) LIMIT 1
176 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
176 ms 2 /modules/sizechart/classes/KbProductChart.php:86
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` = 20) AND (b.`id_shop` = 1) LIMIT 1
176 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 12) LIMIT 1
176 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE *
FROM `ps_manufacturer_lang`
WHERE `id_manufacturer` = 1
176 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` = 22) AND (b.`id_shop` = 1) LIMIT 1
176 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` = 178) AND (b.`id_shop` = 1) LIMIT 1
175 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
175 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` = 1810
ORDER BY `position`
173 ms 2 Yes /classes/Product.php:3517
SELECT SQL_NO_CACHE c.id_contact FROM `ps_ets_ctf_contact` c
INNER JOIN `ps_ets_ctf_contact_shop` cs ON (c.id_contact= cs.id_contact)
LEFT JOIN `ps_ets_ctf_contact_lang` cl on (c.id_contact= cl.id_contact AND cl.id_lang="2")
WHERE c.active=1 AND c.hook like "%header%" AND cs.id_shop="1";
173 ms 1 /modules/ets_contactform7/classes/Contact.php:219
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 15170201 AND name = '_elementor_page_settings' 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` = 9) AND (b.`id_shop` = 1) LIMIT 1
172 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` = 41) AND (b.`id_shop` = 1) LIMIT 1
172 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` = 37) AND (b.`id_shop` = 1) LIMIT 1
171 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` = 29) AND (b.`id_shop` = 1) LIMIT 1
170 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` = 40) AND (b.`id_shop` = 1) LIMIT 1
170 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 15170201 AND name = '_elementor_css' LIMIT 1
170 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` = 11) AND (b.`id_shop` = 1) LIMIT 1
170 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` = 38) AND (b.`id_shop` = 1) LIMIT 1
170 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE value FROM `ps_configuration` WHERE `name` = "PS_MULTISHOP_FEATURE_ACTIVE" LIMIT 1
170 ms 1 /classes/shop/Shop.php:1171
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 13170201 AND name = '_elementor_data' LIMIT 1
169 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` = 15) AND (b.`id_shop` = 1) LIMIT 1
169 ms 1 /src/Adapter/EntityMapper.php:76
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;
169 ms 1 Yes /modules/whatsappchat/classes/WhatsappChatBlock.php:130
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` = 7) AND (b.`id_shop` = 1) LIMIT 1
169 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE id_cache_page,page,date_add,file_cache,id_shop FROM `ps_ets_superspeed_cache_page` WHERE file_cache="286b44de1049653dccf0766c5b4722c3" AND id_shop="1" LIMIT 1
169 ms 1 /modules/ets_superspeed/classes/cache.php:212
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `ps_product_attribute`
WHERE `id_product` = 1440
169 ms 1 /classes/Product.php:2879
SELECT SQL_NO_CACHE *
FROM `ps_category_lang`
WHERE `id_category` = 12 AND `id_shop` = 1
169 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` = 53) AND (b.`id_shop` = 1) LIMIT 1
169 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 4170201 AND name = '_elementor_version' LIMIT 1
168 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` = 10) AND (b.`id_shop` = 1) LIMIT 1
168 ms 1 /src/Adapter/EntityMapper.php:76
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;
168 ms 1 Yes /modules/whatsappchat/classes/WhatsappChatBlock.php:130
SELECT SQL_NO_CACHE id_size_chart from ps_kb_product_chart where id_product = 1616 AND active = 1 and id_shop=1 LIMIT 1
167 ms 1 /modules/sizechart/classes/KbProductChart.php:109
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
167 ms 1 /classes/order/Order.php:857
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` = 1440
AND pa.`id_product_attribute` = 0
GROUP BY pa.`id_product_attribute`,ag.`id_attribute_group`
ORDER BY pa.`id_product_attribute`
167 ms 0 Yes /classes/Product.php:2839
SELECT SQL_NO_CACHE * FROM `ps_rewards_template_config` WHERE `value`=1 AND `name`='RSPONSORSHIP_ACTIVE' LIMIT 1
165 ms 1 /modules/allinone_rewards/models/RewardsTemplateModel.php:138
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 (13075, 13076, 13074) AND il.`id_lang` = 2 ORDER by i.`position`
165 ms 3 Yes /classes/Product.php:2898
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 13170201 AND name = '_elementor_css' LIMIT 1
165 ms 6 /modules/creativeelements/classes/wrappers/Post.php:266
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;
165 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` = 1472
ORDER BY `position`
165 ms 1 Yes /classes/Product.php:3517
SELECT SQL_NO_CACHE * FROM `ps_rewards_template_config` WHERE `value`=1 AND `name`='RSPONSORSHIP_ACTIVE' LIMIT 1
164 ms 1 /modules/allinone_rewards/models/RewardsTemplateModel.php:138
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` = 1440
ORDER BY `position`
164 ms 3 Yes /classes/Product.php:3517
SELECT SQL_NO_CACHE `id_country`
FROM `ps_country`
WHERE `iso_code` = 'US' AND active = 1 LIMIT 1
164 ms 1 /classes/Country.php:193
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
163 ms 11 Yes Yes /classes/Category.php:1146
SELECT SQL_NO_CACHE c.*, cl.name,cl.link_rewrite
FROM `ps_category` c
INNER JOIN `ps_category_shop` cs ON (c.id_category=cs.id_category AND cs.id_shop=1)
LEFT JOIN `ps_category_lang` cl ON c.id_category=cl.id_category AND cl.id_lang=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
163 ms 0 Yes /modules/ets_megamenu/classes/Ets_megamenu_defines.php:178
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 4170201 AND name = '_elementor_css' LIMIT 1
163 ms 6 /modules/creativeelements/classes/wrappers/Post.php:266
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 (12227, 12226) AND il.`id_lang` = 2 ORDER by i.`position`
162 ms 2 Yes /classes/Product.php:2898
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 4170201 AND name = '_elementor_data' LIMIT 1
162 ms 6 /modules/creativeelements/classes/wrappers/Post.php:266
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `ps_product_attribute`
WHERE `id_product` = 2701
162 ms 2 /classes/Product.php:2879
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` = 2701) LIMIT 1
162 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 15170201 AND name = '_elementor_edit_mode' LIMIT 1
161 ms 6 /modules/creativeelements/classes/wrappers/Post.php:266
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 (13313, 13312) AND il.`id_lang` = 2 ORDER by i.`position`
161 ms 2 Yes /classes/Product.php:2898
SELECT SQL_NO_CACHE `type`, `target` FROM `ps_ets_awu_redirect` WHERE `url` = 'trimming-cattle/1616-trimming-cutter-3700044704298.html' AND active = 1 AND `id_shop`=1 LIMIT 1
161 ms 4 /modules/ets_awesomeurl/classes/EtsAwuRedirect.php:124
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` = 1810 AND ctg.`id_group` = 1 LIMIT 1
161 ms 7 /classes/Product.php:6623
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` = 145 LIMIT 1
160 ms 1 /classes/order/Order.php:857
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
160 ms 2 /classes/Currency.php:1126
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` = 1616
AND pac.`id_product_attribute` = 13074
AND agl.`id_lang` = 2
159 ms 1 /classes/Product.php:7406
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 (13313, 13312) AND il.`id_lang` = 2 ORDER by i.`position`
159 ms 2 Yes /classes/Product.php:2898
SELECT SQL_NO_CACHE * FROM `ps_rewards_template_config` WHERE `value`=1 AND `name`='RSPONSORSHIP_ACTIVE' LIMIT 1
159 ms 1 /modules/allinone_rewards/models/RewardsTemplateModel.php:138
SELECT SQL_NO_CACHE psgdpr.active FROM `ps_psgdpr_consent` psgdpr
WHERE psgdpr.id_module = 11 LIMIT 1
159 ms 4 /modules/psgdpr/classes/GDPRConsent.php:132
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` = 1616) AND (b.`id_shop` = 1) LIMIT 1
159 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 4170201 AND name = '_elementor_edit_mode' LIMIT 1
159 ms 6 /modules/creativeelements/classes/wrappers/Post.php:266
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 4170201 AND name = '_elementor_css' LIMIT 1
159 ms 6 /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` = 1810
AND pac.`id_product_attribute` = 13312
AND agl.`id_lang` = 2
159 ms 1 /classes/Product.php:7406
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` = 19) AND (b.`id_shop` = 1) LIMIT 1
159 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 4170201 AND name = '_elementor_edit_mode' LIMIT 1
158 ms 6 /modules/creativeelements/classes/wrappers/Post.php:266
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` = 1472
AND pa.`id_product_attribute` = 0
GROUP BY pa.`id_product_attribute`,ag.`id_attribute_group`
ORDER BY pa.`id_product_attribute`
158 ms 0 Yes /classes/Product.php:2839
SELECT SQL_NO_CACHE * FROM `ps_rewards_template_config` WHERE `value`=1 AND `name`='RSPONSORSHIP_ACTIVE' LIMIT 1
158 ms 1 /modules/allinone_rewards/models/RewardsTemplateModel.php:138
SELECT SQL_NO_CACHE `id_image_type`
FROM `ps_image_type`
WHERE `name` = 'home'
157 ms 1 /classes/ImageType.php:131
SELECT SQL_NO_CACHE *
FROM `ps_product_lang`
WHERE `id_product` = 1440 AND `id_shop` = 1
157 ms 2 /src/Adapter/EntityMapper.php:84
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` = 1616
AND image_shop.`cover` = 1 LIMIT 1
156 ms 3 /classes/Product.php:3542
SELECT SQL_NO_CACHE *
FROM `ps_shop` a
WHERE (a.`id_shop` = 1) LIMIT 1
156 ms 1 /src/Adapter/EntityMapper.php:76
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` = "footer" AND `id_shop` = 1 AND `active` = 1 ORDER BY position DESC;
156 ms 1 Yes /modules/whatsappchat/classes/WhatsappChatBlock.php:130
SELECT SQL_NO_CACHE name, alias FROM `ps_hook_alias`
155 ms 88 /classes/Hook.php:353
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` = 21) AND (b.`id_shop` = 1) LIMIT 1
155 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE * FROM `ps_rewards_template_config` WHERE `value`=1 AND `name`='RSPONSORSHIP_ACTIVE' LIMIT 1
155 ms 1 /modules/allinone_rewards/models/RewardsTemplateModel.php:138
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;
155 ms 1 Yes /modules/whatsappchat/classes/WhatsappChatBlock.php:130
SELECT SQL_NO_CACHE * FROM `ps_rewards_template_config` WHERE `value`=1 AND `name`='RSPONSORSHIP_ACTIVE' LIMIT 1
154 ms 1 /modules/allinone_rewards/models/RewardsTemplateModel.php:138
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` = 1472
ORDER BY `position`
154 ms 1 Yes /classes/Product.php:3517
SELECT SQL_NO_CACHE `id_image_type`
FROM `ps_image_type`
WHERE `name` = 'home'
153 ms 1 /classes/ImageType.php:131
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
153 ms 4 /classes/Language.php:1198
SELECT SQL_NO_CACHE * FROM `ps_currency` c ORDER BY `iso_code` ASC
153 ms 2 Yes /classes/Currency.php:709
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` = 1472) AND (b.`id_shop` = 1) LIMIT 1
152 ms 1 /src/Adapter/EntityMapper.php:76
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
152 ms 1 /classes/Cart.php:4218
SELECT SQL_NO_CACHE * FROM `ps_rewards_template_config` WHERE `value`=1 AND `name`='RSPONSORSHIP_ACTIVE' LIMIT 1
151 ms 1 /modules/allinone_rewards/models/RewardsTemplateModel.php:138
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` = 211) AND (b.`id_shop` = 1) LIMIT 1
151 ms 1 /src/Adapter/EntityMapper.php:76
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
151 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE id_size_chart from ps_kb_category_chart where id_category = 205 AND active = 1 and id_shop=1 LIMIT 1
151 ms 1 /modules/sizechart/classes/KbCategoryChart.php:65
(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_%")
150 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` = 2701) AND (b.`id_shop` = 1) LIMIT 1
150 ms 1 /src/Adapter/EntityMapper.php:76
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 (12227, 12226) AND il.`id_lang` = 2 ORDER by i.`position`
149 ms 2 Yes /classes/Product.php:2898
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 15170201 AND name = '_elementor_version' LIMIT 1
149 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` = 205) AND (b.`id_shop` = 1) LIMIT 1
149 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE `name`, `alias` FROM `ps_hook_alias`
148 ms 88 /classes/Hook.php:301
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
148 ms 1 /src/Adapter/EntityMapper.php:76