totoMaxi plaque neige - Mustad
Previous
Next

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

Maxi plaque neige - Mustad

Mustad
0/5
Référence : PLAQUENEIGMAXIA
€3.72
€3.72
Declination
En stock
Ajouter au panier
Partager
Facebook Twitter

Partager le lien

Brand
Category Horseshoe plates Brand Mustad

Les avis sur notre produit

Comments (0)

Vous aimerez aussi...

Load Time 817 ms
Querying Time 114 ms
Queries 653
Memory Peak Usage 54.3 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 20 ms 37 ms 3.18 Mb 10.8 Mb
checkAccess 0 ms 37 ms - Mb 10.8 Mb
setMedia 4 ms 41 ms 0.48 Mb 11.2 Mb
postProcess 0 ms 41 ms - Mb 11.2 Mb
initHeader 0 ms 41 ms - Mb 11.2 Mb
initContent 114 ms 156 ms 8.69 Mb 19.7 Mb
initFooter 0 ms 156 ms - Mb 19.7 Mb
display 662 ms 817 ms 33.64 Mb 54.3 Mb
Hook Time Memory Usage
OverrideLayoutTemplate 635 ms 32.29 Mb
displayNavFullWidth 53 ms 3.99 Mb
DisplayBlock 44 ms 3.40 Mb
DisplayHeader 34 ms 2.95 Mb
ActionOutputHTMLBefore 10 ms - Mb
ModuleRoutes 10 ms 1.58 Mb
DisplayProductPriceBlock 7 ms 0.59 Mb
Header 5 ms 0.23 Mb
DisplayFooter 4 ms 0.26 Mb
displayFooterProduct 4 ms 0.11 Mb
DisplayBeforeBodyClosingTag 3 ms 0.14 Mb
DisplayProductButtons 2 ms 0.27 Mb
displayFlagProduct 2 ms 0.04 Mb
displayGtag 1 ms 0.09 Mb
FilterProductContent 1 ms 0.38 Mb
ActionFrontControllerSetMedia 1 ms - Mb
DisplayGDPRConsent 1 ms 0.04 Mb
ActionGetProductPropertiesAfter 1 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) 819 ms 46.27 Mb
Module Time Memory Usage
ybc_instagram 3 ms 0.29 Mb
colissimo 1 ms 0.42 Mb
hiupsell 2 ms 0.12 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 643 ms 33.21 Mb
blockwishlist 2 ms 0.11 Mb
ps_emailsubscription 2 ms 0.22 Mb
blockreassurance 0 ms 0.03 Mb
allinone_rewards 4 ms 0.56 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 102 ms 8.73 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 14 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) 845 ms 49.19 Mb
  1. Stopwatch SQL
  2. Doubles
  3. Tables stress
  4. ObjectModel instances
  5. Included Files

Stopwatch SQL - 653 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`)
 5450 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`)
 5304 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
 1708 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`
 1619 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
 1184 ms 1890 Yes /classes/tax/TaxRulesGroup.php:196 
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
 957 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
 911 ms 193 Yes /modules/creativeelements/includes/base/widget-category-base.php:146 
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
 896 ms 241 Yes /classes/Country.php:147 
(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)
 865 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` = 2392 AND product_shop.`active` = 1 AND product_shop.`visibility` != 'none'
GROUP BY product_shop.id_product
 559 ms 4 Yes /classes/Product.php:4639 
DELETE FROM `ps_configuration_lang`
WHERE `id_configuration` IN (
SELECT `id_configuration`
FROM `ps_configuration`
WHERE `name` = "PS_ROUTE_etsmpshops"
)
 461 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="2392")
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="211")  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
 456 ms 12 Yes /modules/ets_extraoptions/classes/ets_eto_attribute_class.php:532 
SELECT SQL_NO_CACHE ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, agl.`public_name` AS public_group_name,
a.`id_attribute`, al.`name` AS attribute_name, a.`color` AS attribute_color, product_attribute_shop.`id_product_attribute`,
IFNULL(stock.quantity, 0) as quantity, product_attribute_shop.`price`, product_attribute_shop.`ecotax`, product_attribute_shop.`weight`,
product_attribute_shop.`default_on`, pa.`reference`, pa.`ean13`, pa.`mpn`, pa.`upc`, pa.`isbn`, product_attribute_shop.`unit_price_impact`,
product_attribute_shop.`minimal_quantity`, product_attribute_shop.`available_date`, ag.`group_type`
FROM `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
LEFT JOIN ps_stock_available stock
ON (stock.id_product = `pa`.id_product AND stock.id_product_attribute = IFNULL(`pa`.id_product_attribute, 0) AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
LEFT JOIN `ps_product_attribute_combination` pac ON (pac.`id_product_attribute` = pa.`id_product_attribute`)
LEFT JOIN `ps_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
LEFT JOIN `ps_attribute_group` ag ON (ag.`id_attribute_group` = a.`id_attribute_group`)
LEFT JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute`)
LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group`)
INNER JOIN ps_attribute_shop attribute_shop
ON (attribute_shop.id_attribute = a.id_attribute AND attribute_shop.id_shop = 1)
WHERE pa.`id_product` = 2392
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
 449 ms 2 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_etsmpshopsseller"
)
 446 ms 1 /classes/Configuration.php:570 
SELECT SQL_NO_CACHE b.*,bl.title,bl.title_link,bl.content,bl.image_link
FROM `ps_ets_mm_block` b
LEFT JOIN `ps_ets_mm_block_lang` bl
ON b.id_block=bl.id_block AND bl.id_lang=2
WHERE 1  AND b.id_column=22 
ORDER BY b.sort_order asc,bl.title asc
 436 ms 3 Yes /modules/ets_megamenu/classes/MM_Block.php:617 
SELECT SQL_NO_CACHE * FROM `ps_state` ORDER BY `name` ASC
 433 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 = 2005
LIMIT 1
 431 ms 4 /classes/ProductAssembler.php:106 
SELECT SQL_NO_CACHE lower(name) as name
FROM `ps_hook` h
WHERE (h.active = 1)
 418 ms 948 /classes/Hook.php:1283 
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` = 2392
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
 389 ms 2 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="2392")
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="211")  AND (cap.used=1 OR ((cap.used=-1 OR cap.used IS NULL) AND a.used=1))  AND a.id_product="2392" AND a.id_ets_eto_attr_group=0 ORDER BY sort_order ASC
 387 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="2392")
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="211")  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
 386 ms 3 Yes /modules/ets_extraoptions/classes/ets_eto_attribute_class.php:532 
SELECT SQL_NO_CACHE ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, agl.`public_name` AS public_group_name,
a.`id_attribute`, al.`name` AS attribute_name, a.`color` AS attribute_color, product_attribute_shop.`id_product_attribute`,
IFNULL(stock.quantity, 0) as quantity, product_attribute_shop.`price`, product_attribute_shop.`ecotax`, product_attribute_shop.`weight`,
product_attribute_shop.`default_on`, pa.`reference`, pa.`ean13`, pa.`mpn`, pa.`upc`, pa.`isbn`, product_attribute_shop.`unit_price_impact`,
product_attribute_shop.`minimal_quantity`, product_attribute_shop.`available_date`, ag.`group_type`
FROM `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
LEFT JOIN ps_stock_available stock
ON (stock.id_product = `pa`.id_product AND stock.id_product_attribute = IFNULL(`pa`.id_product_attribute, 0) AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
LEFT JOIN `ps_product_attribute_combination` pac ON (pac.`id_product_attribute` = pa.`id_product_attribute`)
LEFT JOIN `ps_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
LEFT JOIN `ps_attribute_group` ag ON (ag.`id_attribute_group` = a.`id_attribute_group`)
LEFT JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute`)
LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group`)
INNER JOIN ps_attribute_shop attribute_shop
ON (attribute_shop.id_attribute = a.id_attribute AND attribute_shop.id_shop = 1)
WHERE pa.`id_product` = 2392
AND al.`id_lang` = 2
AND agl.`id_lang` = 2
AND product_attribute_shop.`id_product_attribute` = 14143 GROUP BY id_attribute_group, id_product_attribute
ORDER BY ag.`position` ASC, a.`position` ASC, agl.`name` ASC
 385 ms 1 Yes Yes /classes/Product.php:4549 
SELECT SQL_NO_CACHE p.*,
ps.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2024-10-05 00:00:00',
INTERVAL 0 DAY
)
) > 0) as new
FROM ps_product p
LEFT JOIN ps_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 2
LEFT JOIN ps_stock_available sa   ON sa.id_product = p.id_product
AND sa.id_shop = 1 LEFT JOIN ps_product_shop ps
ON ps.id_product = p.id_product
AND ps.id_shop = 1
WHERE p.id_product = 1654
LIMIT 1
 377 ms 7 /classes/ProductAssembler.php:106 
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 = 1622
LIMIT 1
 371 ms 9 /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` = 211
AND `active` = 1
AND cg.`id_group` =1
GROUP BY c.`id_category`
ORDER BY `level_depth` ASC, category_shop.`position` ASC
 369 ms 1 Yes Yes /classes/Category.php:919 
SELECT SQL_NO_CACHE a.*,al.name,al.description,IFNULL(cap.position,a.position) AS sort_order, IF(cap.used IS NULL,-1,cap.used) AS product_used,IF(cap.price IS NULL,-1,cap.price) AS product_price,IF(cap.type_price is null,-1,cap.type_price) as product_type_price ,IF(cap.required IS NULL,-1,cap.required) AS product_required,IF(cap.checked IS NULL,-1,cap.checked) AS product_checked,IF(cap.use_tax IS NULL,-1,cap.use_tax) AS product_use_tax,IF(cap.use_discount IS NULL,-1,cap.use_discount) AS product_use_discount 
FROM `ps_ets_eto_attr` a
LEFT JOIN `ps_ets_eto_attr_lang` al ON (a.id_ets_eto_attr = al.id_ets_eto_attr AND al.id_lang="2")
LEFT JOIN `ps_ets_eto_attr_product` cap ON (cap.id_ets_eto_attr = a.id_ets_eto_attr AND cap.id_product="2392")
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="211")  AND (cap.used=1 OR ((cap.used=-1 OR cap.used IS NULL) AND a.used=1))  AND a.id_product="2392" AND a.id_ets_eto_attr_group=1 ORDER BY sort_order ASC
 360 ms 3 Yes /modules/ets_extraoptions/classes/ets_eto_attribute_class.php:532 
SELECT SQL_NO_CACHE b.*,bl.title,bl.title_link,bl.content,bl.image_link
FROM `ps_ets_mm_block` b
LEFT JOIN `ps_ets_mm_block_lang` bl
ON b.id_block=bl.id_block AND bl.id_lang=2
WHERE 1  AND b.id_column=21 
ORDER BY b.sort_order asc,bl.title asc
 357 ms 1 Yes /modules/ets_megamenu/classes/MM_Block.php:617 
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
 350 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` = 2392
AND al.`id_lang` = 2
AND agl.`id_lang` = 2
AND product_attribute_shop.`id_product_attribute` = 14143 GROUP BY id_attribute_group, id_product_attribute
ORDER BY ag.`position` ASC, a.`position` ASC, agl.`name` ASC
 346 ms 1 Yes Yes /classes/Product.php:4549 
SELECT SQL_NO_CACHE b.*,bl.title,bl.title_link,bl.content,bl.image_link
FROM `ps_ets_mm_block` b
LEFT JOIN `ps_ets_mm_block_lang` bl
ON b.id_block=bl.id_block AND bl.id_lang=2
WHERE 1  AND b.id_column=19 
ORDER BY b.sort_order asc,bl.title asc
 344 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=23 
ORDER BY b.sort_order asc,bl.title asc
 336 ms 1 Yes /modules/ets_megamenu/classes/MM_Block.php:617 
SELECT SQL_NO_CACHE `id_hook`, `name` FROM `ps_hook`
 335 ms 948 /classes/Hook.php:1243 
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
 334 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` = 1622
AND pa.`id_product_attribute` = 13092
GROUP BY pa.`id_product_attribute`,ag.`id_attribute_group`
ORDER BY pa.`id_product_attribute`
 324 ms 3 Yes /classes/Product.php:2839 
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
 316 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=10 
ORDER BY b.sort_order asc,bl.title asc
 315 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=8 
ORDER BY b.sort_order asc,bl.title asc
 314 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=20 
ORDER BY b.sort_order asc,bl.title asc
 312 ms 2 Yes /modules/ets_megamenu/classes/MM_Block.php:617 
SELECT SQL_NO_CACHE ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, agl.`public_name` AS public_group_name,
a.`id_attribute`, al.`name` AS attribute_name, a.`color` AS attribute_color, product_attribute_shop.`id_product_attribute`,
IFNULL(stock.quantity, 0) as quantity, product_attribute_shop.`price`, product_attribute_shop.`ecotax`, product_attribute_shop.`weight`,
product_attribute_shop.`default_on`, pa.`reference`, pa.`ean13`, pa.`mpn`, pa.`upc`, pa.`isbn`, product_attribute_shop.`unit_price_impact`,
product_attribute_shop.`minimal_quantity`, product_attribute_shop.`available_date`, ag.`group_type`
FROM `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
LEFT JOIN ps_stock_available stock
ON (stock.id_product = `pa`.id_product AND stock.id_product_attribute = IFNULL(`pa`.id_product_attribute, 0) AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
LEFT JOIN `ps_product_attribute_combination` pac ON (pac.`id_product_attribute` = pa.`id_product_attribute`)
LEFT JOIN `ps_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
LEFT JOIN `ps_attribute_group` ag ON (ag.`id_attribute_group` = a.`id_attribute_group`)
LEFT JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute`)
LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group`)
INNER JOIN ps_attribute_shop attribute_shop
ON (attribute_shop.id_attribute = a.id_attribute AND attribute_shop.id_shop = 1)
WHERE pa.`id_product` = 2392
AND al.`id_lang` = 2
AND agl.`id_lang` = 2
AND product_attribute_shop.`id_product_attribute` = 14143 GROUP BY id_attribute_group, id_product_attribute
ORDER BY ag.`position` ASC, a.`position` ASC, agl.`name` ASC
 312 ms 1 Yes Yes /classes/Product.php:4549 
SELECT SQL_NO_CACHE b.*,bl.title,bl.title_link,bl.content,bl.image_link
FROM `ps_ets_mm_block` b
LEFT JOIN `ps_ets_mm_block_lang` bl
ON b.id_block=bl.id_block AND bl.id_lang=2
WHERE 1  AND b.id_column=24 
ORDER BY b.sort_order asc,bl.title asc
 305 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
 302 ms 1 Yes /modules/ets_megamenu/classes/MM_Block.php:617 
SELECT SQL_NO_CACHE b.*,bl.title,bl.title_link,bl.content,bl.image_link
FROM `ps_ets_mm_block` b
LEFT JOIN `ps_ets_mm_block_lang` bl
ON b.id_block=bl.id_block AND bl.id_lang=2
WHERE 1  AND b.id_column=25 
ORDER BY b.sort_order asc,bl.title asc
 301 ms 1 Yes /modules/ets_megamenu/classes/MM_Block.php:617 
SELECT SQL_NO_CACHE 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
 301 ms 1 Yes /modules/ets_megamenu/classes/MM_Block.php:617 
SELECT SQL_NO_CACHE p.*,
ps.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'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 = 2232
LIMIT 1
 300 ms 6 /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=6 
ORDER BY b.sort_order asc,bl.title asc
 299 ms 1 Yes /modules/ets_megamenu/classes/MM_Block.php:617 
(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
 296 ms 1 /classes/CartRule.php:383 
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` = 2392
 287 ms 2 /classes/Product.php:7435 
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` = 2392
 282 ms 2 /classes/Product.php:7435 
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
 279 ms 1 /src/Adapter/EntityMapper.php:76 
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
 275 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(36,37,38)
AND cg.`id_group` IN (1)
GROUP BY c.id_category ORDER BY c.position ASC,c.id_category ASC
 273 ms 3 Yes Yes /modules/ets_megamenu/classes/Ets_megamenu_defines.php:178 
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
 271 ms 4 Yes Yes /modules/ets_megamenu/classes/MM_Menu.php:500 
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 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
 270 ms 3 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
 269 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
 269 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
 267 ms 107 /classes/module/Module.php:340 
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` = 1622
ORDER BY `position`
 267 ms 4 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(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
 266 ms 7 Yes Yes /modules/ets_megamenu/classes/Ets_megamenu_defines.php:178 
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module`as `mshop`
FROM `ps_module` m
LEFT JOIN `ps_module_shop` ms
ON m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 1
 265 ms 107 /classes/module/Module.php:340 
SELECT SQL_NO_CACHE DISTINCT `id_product_attribute` FROM `ps_specific_price` WHERE `id_product_attribute` != 0
 260 ms 212 /classes/SpecificPrice.php:295 
(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_%")
 259 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(18,23,22,20,19,21)
AND cg.`id_group` IN (1)
GROUP BY c.id_category ORDER BY c.position ASC,c.id_category ASC
 258 ms 6 Yes Yes /modules/ets_megamenu/classes/Ets_megamenu_defines.php:178 
SELECT SQL_NO_CACHE COUNT(*) FROM (SELECT DISTINCT `id_product_attribute` FROM `ps_specific_price` WHERE `id_product_attribute` != 0 GROUP BY id_product ) AS counted LIMIT 1
 257 ms 67731 /classes/SpecificPrice.php:287 
SELECT SQL_NO_CACHE c.*, cl.name,cl.link_rewrite
FROM `ps_category` c
INNER JOIN `ps_category_shop` cs ON (c.id_category=cs.id_category AND cs.id_shop=1)
LEFT JOIN `ps_category_lang` cl ON c.id_category=cl.id_category AND cl.id_lang=2
LEFT JOIN `ps_category_group` cg ON c.`id_category` = cg.`id_category` 
WHERE c.active=1 
AND  c.id_category IN(247,56,58,183,60,184)
AND cg.`id_group` IN (1)
GROUP BY c.id_category ORDER BY c.position ASC,c.id_category ASC
 257 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(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
 257 ms 7 Yes Yes /modules/ets_megamenu/classes/Ets_megamenu_defines.php:178 
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` = 2392
AND pa.`id_product_attribute` = 14144
GROUP BY pa.`id_product_attribute`,ag.`id_attribute_group`
ORDER BY pa.`id_product_attribute`
 256 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(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
 254 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(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
 251 ms 5 Yes Yes /modules/ets_megamenu/classes/Ets_megamenu_defines.php:178 
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `ps_image` i
INNER JOIN ps_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `ps_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 2)
WHERE i.`id_product` = 2005
ORDER BY `position`
 250 ms 11 Yes /classes/Product.php:3517 
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
 250 ms 1 Yes /classes/shop/Shop.php:1350 
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
 249 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(51,52,53,55)
AND cg.`id_group` IN (1)
GROUP BY c.id_category ORDER BY c.position ASC,c.id_category ASC
 245 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(226,227,228,229)
AND cg.`id_group` IN (1)
GROUP BY c.id_category ORDER BY c.position ASC,c.id_category ASC
 243 ms 4 Yes Yes /modules/ets_megamenu/classes/Ets_megamenu_defines.php:178 
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `ps_image` i
INNER JOIN ps_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `ps_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 2)
WHERE i.`id_product` = 2005
ORDER BY `position`
 240 ms 11 Yes /classes/Product.php:3517 
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
 240 ms 1 Yes /classes/shop/Shop.php:711 
SELECT SQL_NO_CACHE DISTINCT `id_product` FROM `ps_specific_price` WHERE `id_product` != 0
 239 ms 321 /classes/SpecificPrice.php:295 
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
 235 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` = 1654 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` = 1654 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 235 ms 0 /classes/Cart.php:1429 
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
 234 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 (13712, 13713, 15086, 13711) AND il.`id_lang` = 2 ORDER by i.`position`
 233 ms 11 Yes /classes/Product.php:2898 
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 2
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 2005) AND (b.`id_shop` = 1) LIMIT 1
 232 ms 1 /src/Adapter/EntityMapper.php:76 
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` = 2392 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` = 2392 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 231 ms 0 /classes/Cart.php:1429 
SELECT SQL_NO_CACHE 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
 230 ms 4 Yes Yes /modules/ets_megamenu/classes/Ets_megamenu_defines.php:178 
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 (13092, 13093, 13094, 13095, 13096, 13097, 13098, 13099, 13100, 13101, 13102, 13103, 13104, 13105) AND il.`id_lang` = 2 ORDER by i.`position`
 229 ms 14 Yes /classes/Product.php:2898 
SELECT SQL_NO_CACHE *
FROM `ps_category` a0
LEFT JOIN `ps_category_lang` `a1` ON (a0.`id_category` = a1.`id_category`)
WHERE (a0.`nleft` < 99) AND (a0.`nright` > 100) AND (a1.`id_lang` = 2)
ORDER BY a0.`nleft` asc
 228 ms 193 Yes /classes/PrestaShopCollection.php:381 
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` = 2392
AND pa.`id_product_attribute` = 14143
GROUP BY pa.`id_product_attribute`,ag.`id_attribute_group`
ORDER BY pa.`id_product_attribute`
 227 ms 1 Yes /classes/Product.php:2839 
SELECT SQL_NO_CACHE pai.`id_image`, pai.`id_product_attribute`, il.`legend`
FROM `ps_product_attribute_image` pai
LEFT JOIN `ps_image_lang` il ON (il.`id_image` = pai.`id_image`)
LEFT JOIN `ps_image` i ON (i.`id_image` = pai.`id_image`)
WHERE pai.`id_product_attribute` IN (13712, 13713, 15086, 13711) AND il.`id_lang` = 2 ORDER by i.`position`
 226 ms 11 Yes /classes/Product.php:2898 
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 2
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 2232) AND (b.`id_shop` = 1) LIMIT 1
 226 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` = 1654
ORDER BY `position`
 223 ms 4 Yes /classes/Product.php:3517 
SELECT SQL_NO_CACHE pa.*, product_attribute_shop.*, ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, al.`name` AS attribute_name,
a.`id_attribute`, a.`position`
FROM `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
LEFT JOIN `ps_product_attribute_combination` pac ON pac.`id_product_attribute` = pa.`id_product_attribute`
LEFT JOIN `ps_attribute` a ON a.`id_attribute` = pac.`id_attribute`
LEFT JOIN `ps_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group`
LEFT JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 2)
LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 2)
WHERE pa.`id_product` = 1622
AND pa.`id_product_attribute` = 13092
GROUP BY pa.`id_product_attribute`,ag.`id_attribute_group`
ORDER BY pa.`id_product_attribute`
 222 ms 3 Yes /classes/Product.php:2839 
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
 222 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` < 99) AND (a0.`nright` > 100) AND (a1.`id_lang` = 2)
ORDER BY a0.`nleft` asc
 221 ms 193 Yes /classes/PrestaShopCollection.php:381 
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
 220 ms 35 /override/classes/order/OrderState.php:42 
SELECT SQL_NO_CACHE c.* FROM `ps_minpurchase_configuration` c WHERE c.`id_shop` = 1
AND c.`active` = 1 AND (date_from <= "2024-10-05 06:25:45" OR date_from = "0000-00-00 00:00:00") AND (date_to >= "2024-10-05 06:25:45" OR date_to = "0000-00-00 00:00:00") ORDER BY c.`priority`, c.`id_minpurchase_configuration` ASC
 219 ms 1 Yes /modules/minpurchase/classes/MinpurchaseConfiguration.php:251 
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
 219 ms 35 /override/classes/order/OrderState.php:42 
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
 219 ms 7 Yes Yes /modules/ets_megamenu/classes/Ets_megamenu_defines.php:178 
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` = 1622
AND pa.`id_product_attribute` = 13092
GROUP BY pa.`id_product_attribute`,ag.`id_attribute_group`
ORDER BY pa.`id_product_attribute`
 219 ms 3 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
 218 ms 35 /override/classes/order/OrderState.php:42 
SELECT SQL_NO_CACHE *
FROM `ps_order_state` os
LEFT JOIN `ps_order_state_lang` osl ON (os.`id_order_state` = osl.`id_order_state` AND osl.`id_lang` = 2) WHERE deleted = 0
 217 ms 35 /override/classes/order/OrderState.php:42 
SELECT SQL_NO_CACHE id_tab, class_name FROM `ps_tab`
 216 ms 291 /classes/Tab.php:359 
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` = 2232
ORDER BY `position`
 216 ms 4 Yes /classes/Product.php:3517 
SELECT SQL_NO_CACHE pa.*, product_attribute_shop.*, ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, al.`name` AS attribute_name,
a.`id_attribute`, a.`position`
FROM `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
LEFT JOIN `ps_product_attribute_combination` pac ON pac.`id_product_attribute` = pa.`id_product_attribute`
LEFT JOIN `ps_attribute` a ON a.`id_attribute` = pac.`id_attribute`
LEFT JOIN `ps_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group`
LEFT JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 2)
LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 2)
WHERE pa.`id_product` = 2232
AND pa.`id_product_attribute` = 13936
GROUP BY pa.`id_product_attribute`,ag.`id_attribute_group`
ORDER BY pa.`id_product_attribute`
 212 ms 1 Yes /classes/Product.php:2839 
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` = 1622 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` = 1622 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 212 ms 0 /classes/Cart.php:1429 
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
 211 ms 1 Yes /classes/SpecificPrice.php:624 
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` = 2005
AND pa.`id_product_attribute` = 13711
GROUP BY pa.`id_product_attribute`,ag.`id_attribute_group`
ORDER BY pa.`id_product_attribute`
 210 ms 1 Yes /classes/Product.php:2839 
SELECT SQL_NO_CACHE pai.`id_image`, pai.`id_product_attribute`, il.`legend`
FROM `ps_product_attribute_image` pai
LEFT JOIN `ps_image_lang` il ON (il.`id_image` = pai.`id_image`)
LEFT JOIN `ps_image` i ON (i.`id_image` = pai.`id_image`)
WHERE pai.`id_product_attribute` IN (13092, 13093, 13094, 13095, 13096, 13097, 13098, 13099, 13100, 13101, 13102, 13103, 13104, 13105) AND il.`id_lang` = 2 ORDER by i.`position`
 210 ms 14 Yes /classes/Product.php:2898 
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;
 209 ms 1 Yes /modules/whatsappchat/classes/WhatsappChatBlock.php:130 
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 06:25:45" OR date_from = "0000-00-00 00:00:00") AND (date_to >= "2024-10-05 06:25:45" OR date_to = "0000-00-00 00:00:00") ORDER BY c.`priority`, c.`id_minpurchase_configuration` ASC
 208 ms 1 Yes /modules/minpurchase/classes/MinpurchaseConfiguration.php:251 
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` = 1622
AND pac.`id_product_attribute` = 13092
AND agl.`id_lang` = 2
 206 ms 3 /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 (13184, 13185, 13186, 13187, 13188, 13189, 13190, 13191) AND il.`id_lang` = 2 ORDER by i.`position`
 206 ms 8 Yes /classes/Product.php:2898 
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `ps_image` i
INNER JOIN ps_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `ps_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 2)
WHERE i.`id_product` = 2232
ORDER BY `position`
 206 ms 4 Yes /classes/Product.php:3517 
SELECT SQL_NO_CACHE pa.*, product_attribute_shop.*, ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, al.`name` AS attribute_name,
a.`id_attribute`, a.`position`
FROM `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
LEFT JOIN `ps_product_attribute_combination` pac ON pac.`id_product_attribute` = pa.`id_product_attribute`
LEFT JOIN `ps_attribute` a ON a.`id_attribute` = pac.`id_attribute`
LEFT JOIN `ps_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group`
LEFT JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 2)
LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 2)
WHERE pa.`id_product` = 1654
AND pa.`id_product_attribute` = 13184
GROUP BY pa.`id_product_attribute`,ag.`id_attribute_group`
ORDER BY pa.`id_product_attribute`
 205 ms 1 Yes /classes/Product.php:2839 
SELECT SQL_NO_CACHE * FROM `ps_whatsappchatblock` LEFT JOIN `ps_whatsappchatblock_lang` ON (`ps_whatsappchatblock`.`id_whatsappchatblock` = `ps_whatsappchatblock_lang`.`id_whatsappchatblock` AND `id_lang` = 2) WHERE `id_hook` = "hookDisplayBeforeBodyClosingTag" AND `id_shop` = 1 AND `active` = 1 ORDER BY position DESC;
 205 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` = "bottomWidth" AND `id_shop` = 1 AND `active` = 1 ORDER BY position DESC;
 202 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` = "topWidthSticky" AND `id_shop` = 1 AND `active` = 1 ORDER BY position DESC;
 202 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` = 13184
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 1654 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` = 13184
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 1654 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 201 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` = 13092
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 1622 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` = 13092
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 1622 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 201 ms 0 /classes/Cart.php:1429 
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` = 2392) AND (b.`id_shop` = 1) LIMIT 1
 200 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
 200 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` = 2232 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` = 2232 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 199 ms 0 /classes/Cart.php:1429 
SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT cp.`quantity` as first_level_quantity, 0 as pack_quantity
FROM `ps_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 2005 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` = 2005 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 199 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
 199 ms 1 /classes/CartRule.php:383 
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;
 199 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` = 14143
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 2392 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` = 14143
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 2392 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 197 ms 0 /classes/Cart.php:1429 
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` = 1654
AND pac.`id_product_attribute` = 13184
AND agl.`id_lang` = 2
 196 ms 1 /classes/Product.php:7406 
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
 196 ms 103041 /classes/SpecificPrice.php:287 
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` = 13936
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 2232 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` = 13936
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 2232 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` = 13711
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 2005 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` = 13711
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 2005 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 c.* FROM `ps_minpurchase_configuration` c WHERE c.`id_shop` = 1
AND c.`active` = 1 AND (date_from <= "2024-10-05 06:25:45" OR date_from = "0000-00-00 00:00:00") AND (date_to >= "2024-10-05 06:25:45" OR date_to = "0000-00-00 00:00:00") ORDER BY c.`priority`, c.`id_minpurchase_configuration` ASC
 193 ms 1 Yes /modules/minpurchase/classes/MinpurchaseConfiguration.php:251 
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` = 2392)
 190 ms 2 /classes/Product.php:3829 
SELECT SQL_NO_CACHE pai.`id_image`, pai.`id_product_attribute`, il.`legend`
FROM `ps_product_attribute_image` pai
LEFT JOIN `ps_image_lang` il ON (il.`id_image` = pai.`id_image`)
LEFT JOIN `ps_image` i ON (i.`id_image` = pai.`id_image`)
WHERE pai.`id_product_attribute` IN (13937, 13936) AND il.`id_lang` = 2 ORDER by i.`position`
 190 ms 2 Yes /classes/Product.php:2898 
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
 189 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
 189 ms 107 /classes/module/Module.php:340 
SELECT SQL_NO_CACHE *
FROM `ps_whatsappchatblock_agent` LEFT JOIN `ps_whatsappchatblock_agent_lang` ON (`ps_whatsappchatblock_agent`.`id_whatsappchatblock_agent` = `ps_whatsappchatblock_agent_lang`.`id_whatsappchatblock_agent` AND `id_lang` = 2) WHERE 1 = 1 AND `ps_whatsappchatblock_agent`.`id_whatsappchatblock` = 1 AND `active` = 1 ORDER BY position
 188 ms 1 Yes /modules/whatsappchat/classes/WhatsappChatBlockAgent.php:71 
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` = 1654) AND (b.`id_shop` = 1) LIMIT 1
 187 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
 187 ms 1 /src/Adapter/EntityMapper.php:76 
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` = 2005
AND pac.`id_product_attribute` = 13711
AND agl.`id_lang` = 2
 185 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` = 53) AND (b.`id_shop` = 1) LIMIT 1
 185 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` = 231) AND (b.`id_shop` = 1) LIMIT 1
 184 ms 1 /src/Adapter/EntityMapper.php:76 
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 4170201 AND name = '_elementor_data' LIMIT 1
 184 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 (13937, 13936) AND il.`id_lang` = 2 ORDER by i.`position`
 184 ms 2 Yes /classes/Product.php:2898 
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
 183 ms 107 /classes/module/Module.php:340 
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position
FROM ps_feature_product pf
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 2)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 2)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 2)
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 1622
ORDER BY f.position ASC
 183 ms 1 Yes /classes/Product.php:5905 
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 2
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 11) 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 product_attribute_shop.id_product_attribute
FROM ps_product_attribute pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
WHERE pa.id_product = 2392 LIMIT 1
 181 ms 2 /classes/Product.php:1040 
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 = 2392 AND p.active = 1
 180 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` = 1654
ORDER BY `position`
 180 ms 4 Yes /classes/Product.php:3517 
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 13170201 AND name = '_elementor_version' LIMIT 1
 180 ms 6 /modules/creativeelements/classes/wrappers/Post.php:266 
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";
 180 ms 1 /modules/ets_contactform7/classes/Contact.php:219 
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` = 28) AND (b.`id_shop` = 1) LIMIT 1
 179 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` = 51) AND (b.`id_shop` = 1) LIMIT 1
 179 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` = "hookDisplayWhatsAppProductSocialButtons" AND `id_shop` = 1 AND `active` = 1 ORDER BY position DESC;
 179 ms 1 Yes /modules/whatsappchat/classes/WhatsappChatBlock.php:130 
SELECT SQL_NO_CACHE product_attribute_shop.id_product_attribute
FROM ps_product_attribute pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
WHERE product_attribute_shop.default_on = 1  AND pa.id_product = 2392 LIMIT 1
 179 ms 2 /classes/Product.php:1054 
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
 178 ms 1 /src/Adapter/EntityMapper.php:76 
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 4170201 AND name = '_elementor_data' LIMIT 1
 178 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` = 37) AND (b.`id_shop` = 1) LIMIT 1
 178 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` = 19) AND (b.`id_shop` = 1) LIMIT 1
 177 ms 1 /src/Adapter/EntityMapper.php:76 
SELECT SQL_NO_CACHE *
FROM `ps_manufacturer` a
LEFT JOIN `ps_manufacturer_lang` `b` ON a.`id_manufacturer` = b.`id_manufacturer` AND b.`id_lang` = 2
LEFT JOIN `ps_manufacturer_shop` `c` ON a.`id_manufacturer` = c.`id_manufacturer` AND c.`id_shop` = 1
WHERE (a.`id_manufacturer` = 5) LIMIT 1
 177 ms 1 /src/Adapter/EntityMapper.php:76 
SELECT SQL_NO_CACHE *
FROM `ps_category` a0
LEFT JOIN `ps_category_lang` `a1` ON (a0.`id_category` = a1.`id_category`)
WHERE (a0.`nleft` < 99) AND (a0.`nright` > 100) AND (a1.`id_lang` = 2)
ORDER BY a0.`nleft` asc
 176 ms 193 Yes /classes/PrestaShopCollection.php:381 
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position
FROM ps_feature_product pf
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 2)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 2)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 2)
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 1654
ORDER BY f.position ASC
 176 ms 1 Yes /classes/Product.php:5905 
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;
 176 ms 1 Yes /modules/whatsappchat/classes/WhatsappChatBlock.php:130 
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 2005) LIMIT 1
 176 ms 1 /src/Adapter/EntityMapper.php:76 
SELECT SQL_NO_CACHE psgdpr.active FROM `ps_psgdpr_consent` psgdpr
WHERE psgdpr.id_module = 11 LIMIT 1
 175 ms 4 /modules/psgdpr/classes/GDPRConsent.php:132 
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` = 1622 AND ctg.`id_group` = 1 LIMIT 1
 175 ms 7 /classes/Product.php:6623 
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` = 2392) LIMIT 1
 174 ms 1 /src/Adapter/EntityMapper.php:76 
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 2
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 46) AND (b.`id_shop` = 1) LIMIT 1
 174 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
 174 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;
 174 ms 1 Yes /modules/whatsappchat/classes/WhatsappChatBlock.php:130 
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` = 15) AND (b.`id_shop` = 1) LIMIT 1
 173 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 (13184, 13185, 13186, 13187, 13188, 13189, 13190, 13191) AND il.`id_lang` = 2 ORDER by i.`position`
 173 ms 8 Yes /classes/Product.php:2898 
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 2
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 177) 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` = 213) 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` = 178) AND (b.`id_shop` = 1) LIMIT 1
 172 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 06:25:45" OR date_from = "0000-00-00 00:00:00") AND (date_to >= "2024-10-05 06:25:45" OR date_to = "0000-00-00 00:00:00") ORDER BY c.`priority`, c.`id_minpurchase_configuration` ASC
 171 ms 1 Yes /modules/minpurchase/classes/MinpurchaseConfiguration.php:251 
SELECT SQL_NO_CACHE up.*,
up_l.*
FROM `ps_upsellblock` up
LEFT JOIN `ps_upsellblock_lang` `up_l` ON up_l.`id_upsellblock` = up.`id_upsellblock`
WHERE (up_l.`id_lang` = 2) AND (up.`hook` = 'displayFooter') AND (up.active IN ("1"))
 171 ms 2 /modules/hiupsell/classes/upsellblock.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` = 43) 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` = 49) AND (b.`id_shop` = 1) LIMIT 1
 171 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` = 2392) 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` = 183) 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 = 4170201 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` = 247) 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` = 212) 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 = 15170201 AND name = '_elementor_data' LIMIT 1
 169 ms 6 /modules/creativeelements/classes/wrappers/Post.php:266 
SELECT SQL_NO_CACHE *
FROM `ps_ets_mm_column`
WHERE 1  AND id_menu=3
ORDER BY sort_order asc
 167 ms 14 Yes /modules/ets_megamenu/classes/MM_Column.php:128 
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;
 167 ms 1 Yes /modules/whatsappchat/classes/WhatsappChatBlock.php:130 
SELECT SQL_NO_CACHE COUNT(*) FROM `ps_orders` o
LEFT JOIN `ps_order_cart_rule` ocr ON (ocr.`id_order` = o.`id_order`)
WHERE o.`id_customer` = 0
AND ocr.`deleted` = 0 AND ocr.`id_cart_rule` = 145 LIMIT 1
 166 ms 1 /classes/order/Order.php:857 
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 4170201 AND name = '_elementor_version' LIMIT 1
 166 ms 6 /modules/creativeelements/classes/wrappers/Post.php:266 
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position
FROM ps_feature_product pf
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 2)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 2)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 2)
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 2005
ORDER BY f.position ASC
 166 ms 12 Yes /classes/Product.php:5905 
SELECT SQL_NO_CACHE * FROM `ps_rewards_template_config` WHERE `value`=1 AND `name`='RSPONSORSHIP_ACTIVE' LIMIT 1
 166 ms 1 /modules/allinone_rewards/models/RewardsTemplateModel.php:138 
SELECT SQL_NO_CACHE COUNT(*) FROM `ps_orders` o
LEFT JOIN `ps_order_cart_rule` ocr ON (ocr.`id_order` = o.`id_order`)
WHERE o.`id_customer` = 0
AND ocr.`deleted` = 0 AND ocr.`id_cart_rule` = 93 LIMIT 1
 166 ms 1 /classes/order/Order.php:857 
SELECT SQL_NO_CACHE * FROM `ps_whatsappchatblock` LEFT JOIN `ps_whatsappchatblock_lang` ON (`ps_whatsappchatblock`.`id_whatsappchatblock` = `ps_whatsappchatblock_lang`.`id_whatsappchatblock` AND `id_lang` = 2) WHERE `id_hook` = "hookDisplayProductButtons" 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 *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 2
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 217) AND (b.`id_shop` = 1) LIMIT 1
 165 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;
 165 ms 1 Yes /modules/whatsappchat/classes/WhatsappChatBlock.php:130 
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 (14144, 14143) AND il.`id_lang` = 2 ORDER by i.`position`
 164 ms 2 Yes /classes/Product.php:2898 
SELECT SQL_NO_CACHE *
FROM `ps_country` a
LEFT JOIN `ps_country_lang` `b` ON a.`id_country` = b.`id_country` AND b.`id_lang` = 2
LEFT JOIN `ps_country_shop` `c` ON a.`id_country` = c.`id_country` AND c.`id_shop` = 1
WHERE (a.`id_country` = 8) LIMIT 1
 164 ms 1 /src/Adapter/EntityMapper.php:76 
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
 164 ms 1 /src/Adapter/EntityMapper.php:76 
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 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
 163 ms 4 /modules/psgdpr/classes/GDPRConsent.php:111 
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 15170201 AND name = '_elementor_page_settings' LIMIT 1
 163 ms 6 /modules/creativeelements/classes/wrappers/Post.php:266 
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 0 AND name = 'elementor_fonts_manager_font_types' LIMIT 1
 163 ms 1 /modules/creativeelements/classes/wrappers/Post.php:266 
SELECT SQL_NO_CACHE c.*, cl.name,cl.link_rewrite
FROM `ps_category` c
INNER JOIN `ps_category_shop` cs ON (c.id_category=cs.id_category AND cs.id_shop=1)
LEFT JOIN `ps_category_lang` cl ON c.id_category=cl.id_category AND cl.id_lang=2
LEFT JOIN `ps_category_group` cg ON c.`id_category` = cg.`id_category` 
WHERE c.active=1 
AND  c.id_category IN(297)
AND cg.`id_group` IN (1)
GROUP BY c.id_category ORDER BY cl.name ASC,c.id_category ASC
 162 ms 0 Yes /modules/ets_megamenu/classes/Ets_megamenu_defines.php:178 
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 15170201 AND name = '_elementor_edit_mode' LIMIT 1
 162 ms 6 /modules/creativeelements/classes/wrappers/Post.php:266 
SELECT SQL_NO_CACHE COUNT(*) FROM `ps_orders` o
LEFT JOIN `ps_order_cart_rule` ocr ON (ocr.`id_order` = o.`id_order`)
WHERE o.`id_customer` = 0
AND ocr.`deleted` = 0 AND ocr.`id_cart_rule` = 186 LIMIT 1
 162 ms 1 /classes/order/Order.php:857 
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` = 2392
AND image_shop.`cover` = 1 LIMIT 1
 161 ms 2 /classes/Product.php:3542 
SELECT SQL_NO_CACHE up.*,
up_l.*
FROM `ps_upsellblock` up
LEFT JOIN `ps_upsellblock_lang` `up_l` ON up_l.`id_upsellblock` = up.`id_upsellblock`
WHERE (up_l.`id_lang` = 2) AND (up.`hook` = 'displayFooter') AND (up.active IN ("1"))
 161 ms 2 /modules/hiupsell/classes/upsellblock.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` = 10) AND (b.`id_shop` = 1) LIMIT 1
 160 ms 1 /src/Adapter/EntityMapper.php:76 
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 2392030201 AND name = '_elementor_edit_mode' LIMIT 1
 160 ms 1 /modules/creativeelements/classes/wrappers/Post.php:266 
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
 159 ms 1 /src/Adapter/EntityMapper.php:76 
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `ps_product_attribute`
WHERE `id_product` = 1622
 158 ms 14 /classes/Product.php:2879 
SELECT SQL_NO_CACHE `type`, `target` FROM `ps_ets_awu_redirect` WHERE `url` = 'en/horseshoe-plates/2392-maxi-plaque-neige-mustad.html' AND active = 1 AND `id_shop`=1 LIMIT 1
 158 ms 4 /modules/ets_awesomeurl/classes/EtsAwuRedirect.php:124 
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` = 2232
AND pac.`id_product_attribute` = 13936
AND agl.`id_lang` = 2
 158 ms 1 /classes/Product.php:7406 
SELECT SQL_NO_CACHE *
FROM `ps_product_lang`
WHERE `id_product` = 2005 AND `id_shop` = 1
 157 ms 2 /src/Adapter/EntityMapper.php:84 
SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 12 AND `id_shop` = 1 LIMIT 1
 157 ms 1 /classes/module/Module.php:2328 
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` = 2392
AND pac.`id_product_attribute` = 14143
AND agl.`id_lang` = 2
 157 ms 1 /classes/Product.php:7406 
SELECT SQL_NO_CACHE `name`, `alias` FROM `ps_hook_alias`
 155 ms 88 /classes/Hook.php:301 
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 06:25:45" OR date_from = "0000-00-00 00:00:00") AND (date_to >= "2024-10-05 06:25:45" OR date_to = "0000-00-00 00:00:00") ORDER BY c.`priority`, c.`id_minpurchase_configuration` ASC
 155 ms 1 Yes /modules/minpurchase/classes/MinpurchaseConfiguration.php:251 
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
 154 ms 4 /classes/Language.php:1198 
SELECT SQL_NO_CACHE name, alias FROM `ps_hook_alias`
 154 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` = 215) AND (b.`id_shop` = 1) LIMIT 1
 154 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
 153 ms 6 /modules/creativeelements/classes/wrappers/Post.php:266 
SELECT SQL_NO_CACHE *
FROM `ps_group_lang`
WHERE `id_group` = 1
 153 ms 2 /src/Adapter/EntityMapper.php:84 
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` = 8) LIMIT 1
 153 ms 1 /src/Adapter/EntityMapper.php:76 
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 2392030201 AND name = '_elementor_page_settings' LIMIT 1
 152 ms 1 /modules/creativeelements/classes/wrappers/Post.php:266 
SELECT SQL_NO_CACHE conf.* FROM `ps_minpurchase_configuration` conf WHERE conf.`id_shop` = 1
AND conf.`active` = 1
 152 ms 1 /modules/minpurchase/minpurchase.php:487 
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `ps_product_attribute`
WHERE `id_product` = 2005
 152 ms 4 /classes/Product.php:2879 
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 2
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 29) AND (b.`id_shop` = 1) LIMIT 1
 152 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` = 1622) AND (b.`id_shop` = 1) LIMIT 1
 151 ms 1 /src/Adapter/EntityMapper.php:76 
SELECT SQL_NO_CACHE conf.* FROM `ps_minpurchase_configuration` conf WHERE conf.`id_shop` = 1
AND conf.`active` = 1
 151 ms 1 /modules/minpurchase/minpurchase.php:487 
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 2392030201 AND name = '_wp_page_template' LIMIT 1
 151 ms 1 /modules/creativeelements/classes/wrappers/Post.php:266 
SELECT SQL_NO_CACHE *
FROM `ps_whatsappchatblock_agent` LEFT JOIN `ps_whatsappchatblock_agent_lang` ON (`ps_whatsappchatblock_agent`.`id_whatsappchatblock_agent` = `ps_whatsappchatblock_agent_lang`.`id_whatsappchatblock_agent` AND `id_lang` = 2) WHERE 1 = 1 AND `active` = 1 ORDER BY position
 151 ms 1 Yes