Continuer sans accepter  →
Avec votre accord, nos partenaires et nous utilisons des cookies ou technologies similaires afin de vous garantir une meilleure expérience de navigation, à des fins de statistiques ou afin de réaliser des actions publicitaires en lien avec vos habitudes et centres d’intérêts ainsi que de partage avec les réseaux sociaux.

Pour plus d'informations sur les cookies, veuillez cliquer sur le lien « En savoir plus ».
En savoir plus  →

Pèse personne Kern MPI - 200 kg

107,50 €
KERN_MPI

Pèse personne polyvalent avec un large plateau pour des pesées jusqu'à un poids maximal de 200 kg.

Utilisable dans le domaine sportif ou médical.

Moyens de paiement sécurisés
  • Visa
  • MasterCard
  • Payzen
  • Carte bancaire
  • Sous réserve d'acceptation par Floa. Vous disposez du délai légal de rétractation.
  • Financéal

Une utilisation on ne peut plus simple : touchez,  montez dessus et lisez le poids qui s'affiche !

CARACTERISTIQUES :

Poids maximal : 200 kg.

Précision du poids : 100 g.

Large plateforme avec revêtement anti-dérapant.

Ecran LCD.

Conversions d’unités entre kg et lb.

1 poignée de transport.

Fonction AUTO-OFF pour économiser les batteries.

Alimentation : 4 piles 1,5V AAA.

Autonomie : 20 h.

DIMENSIONS : 

Longueur : 43 cm.

Largeur : 37 cm.

Hauteur : 5 cm.

KERN_MPI

Références spécifiques

Neuf

Pèse personne Kern MPI -...

107,50 €

Les clients qui ont acheté ce produit ont également acheté :

8 produits parmi ceux de la même catégorie :

Load Time 1528 ms
Querying Time 1028 ms
Queries 820
Memory Peak Usage 84.4 Mb
Included Files 1152 files - 13.40 Mb
PrestaShop Cache - Mb
Global vars 0.70 Mb
PrestaShop Version 8.2.4
PHP Version 8.1.34
MySQL Version 8.0.36
Memory Limit -1
Max Execution Time 50000s
Smarty Cache enabled
Smarty Compilation auto
  Time Cumulated Time Memory Usage Memory Peak Usage
config 362.190 ms 362.190 ms 32.05 Mb 32.5 Mb
__construct 0.029 ms 362.219 ms - Mb 32.5 Mb
init 66.031 ms 428.250 ms 7.77 Mb 40.2 Mb
setMedia 8.867 ms 437.117 ms 1.45 Mb 42.0 Mb
postProcess 0.003 ms 437.120 ms - Mb 42.0 Mb
initHeader 0.002 ms 437.122 ms - Mb 42.0 Mb
initContent 313.314 ms 750.436 ms 11.66 Mb 53.1 Mb
initFooter 0.001 ms 750.437 ms - Mb 53.1 Mb
display 777.784 ms 1528 ms 31.10 Mb 84.4 Mb
Hook Time Memory Usage
DisplayNavFullWidth 366.012 ms 15.03 Mb
displayFooterProduct 309.119 ms 11.58 Mb
DisplayHeader 234.712 ms 2.89 Mb
DisplayBlock 233.769 ms 11.51 Mb
DisplayProductPriceBlock 114.699 ms 3.33 Mb
ModuleRoutes 106.832 ms 0.10 Mb
displayProductListWishlist 32.663 ms 0.89 Mb
DisplayBeforeBodyClosingTag 21.288 ms 0.34 Mb
displayFooter 10.457 ms 0.36 Mb
DisplayGDPRConsent 7.571 ms 0.28 Mb
DisplayFooterProduct 5.854 ms 0.23 Mb
displayFooterLeftBlock 5.640 ms 0.05 Mb
DisplayAfterProductThumbs 3.488 ms 0.03 Mb
displayProductGuarantee 3.344 ms 0.19 Mb
DisplayFooter 2.805 ms 0.13 Mb
displayNav3 2.801 ms 0.20 Mb
DisplayProductExtraContent 2.724 ms 0.02 Mb
displayProductAdditionalInfo 2.329 ms 0.08 Mb
displayFooterLeftBlock2 2.303 ms 0.05 Mb
DisplayBanner 2.229 ms 0.02 Mb
displayProductAdditionalInfo2 2.128 ms 0.05 Mb
displayTop 2.080 ms 0.11 Mb
displayTop2 1.461 ms 0.11 Mb
DisplayNav1 1.099 ms 0.02 Mb
displayLogoHeader 0.968 ms 0.05 Mb
ActionFrontControllerSetMedia 0.933 ms 0.13 Mb
displayCopyrightContainer 0.706 ms 0.04 Mb
ActionFilterDeliveryOptionList 0.363 ms 0.04 Mb
DisplayCustomMenu 0.174 ms 0.02 Mb
Header 0.142 ms - Mb
ActionDispatcherBefore 0.077 ms - Mb
ActionOutputHTMLBefore 0.072 ms - Mb
DisplayProductAdditionalInfo 0.020 ms - Mb
DisplayTop 0.016 ms - Mb
DisplayNav2 0.009 ms - Mb
35 hook(s) 1481 ms 47.89 Mb
Module Time Memory Usage
prestablog 21.577 ms 4.47 Mb
ets_cfultimate 14.421 ms 2.77 Mb
lpsgdpr 331.956 ms 2.16 Mb
ets_abandonedcart 21.070 ms 2.73 Mb
ets_delete_order 2.003 ms 0.21 Mb
vatnumbercleaner 3.924 ms 0.51 Mb
blockreassurance 1.225 ms 0.22 Mb
ps_emailsubscription 11.513 ms 0.63 Mb
ps_emailalerts 1.547 ms 0.25 Mb
chronopost 4.334 ms 0.69 Mb
an_productextratabs 3.604 ms 0.13 Mb
ps_shoppingcart 1.088 ms 0.16 Mb
ps_searchbar 0.463 ms 0.04 Mb
ps_imageslider 1.335 ms 0.22 Mb
anscrolltop 0.874 ms 0.10 Mb
an_productattributes 116.345 ms 3.61 Mb
an_megamenu 6.656 ms 1.21 Mb
an_wishlist 38.133 ms 1.27 Mb
an_stickyaddtocart 5.318 ms 0.35 Mb
an_logo 1.440 ms 0.11 Mb
an_sizeguide 2.841 ms 0.14 Mb
an_trust_badges 5.379 ms 0.35 Mb
an_homeproducts 1.128 ms 0.19 Mb
an_advantages 0.516 ms 0.07 Mb
an_about_us 6.009 ms 0.09 Mb
an_homeslider 0.777 ms 0.13 Mb
an_theme 3.319 ms 0.48 Mb
an_brandslider 1.091 ms 0.17 Mb
ets_countdown 1.257 ms 0.16 Mb
ets_htmlbox 14.052 ms 0.42 Mb
payzen 6.005 ms 1.22 Mb
ets_megamenu 613.985 ms 28.70 Mb
ps_customersignin 0.408 ms 0.04 Mb
upsliverates 1.388 ms 0.17 Mb
floapay 7.120 ms 0.80 Mb
an_hurry_up 1.755 ms 0.12 Mb
itp_catalog_blocks 0.725 ms 0.14 Mb
an_simple_contact 1.201 ms 0.08 Mb
ps_currencyselector 1.307 ms 0.09 Mb
ps_linklist 2.510 ms 0.23 Mb
ps_crossselling 106.371 ms 4.12 Mb
ps_categoryproducts 203.580 ms 7.57 Mb
an_copyright 1.205 ms 0.08 Mb
statsdata 20.835 ms 0.36 Mb
44 module(s) 1594 ms 67.74 Mb

Stopwatch SQL - 820 queries

# Query Time (ms) Rows Filesort Group By Location
134 
SELECT SQL_NO_CACHE lpsgdprc.`id_lpsgdpr_consents`
FROM `ps_lpsgdpr_consents` lpsgdprc
WHERE lpsgdprc.`source` = "cookie_banner"
AND lpsgdprc.`id_shop` =1
AND lpsgdprc.`index_cookie` =0 LIMIT 1
 109.932 ms 113682 /modules/lpsgdpr/classes/lpsgdprconsent.php:134
31 
SELECT SQL_NO_CACHE lpsgdprc.`id_lpsgdpr_consents`
FROM `ps_lpsgdpr_consents` lpsgdprc
WHERE lpsgdprc.`source` = "cookie_banner"
AND lpsgdprc.`id_shop` =1
AND lpsgdprc.`index_cookie` =0 LIMIT 1
 103.507 ms 113682 /modules/lpsgdpr/classes/lpsgdprconsent.php:134
136 
SELECT SQL_NO_CACHE lpsgdprc.`id_lpsgdpr_consents`
FROM `ps_lpsgdpr_consents` lpsgdprc
WHERE lpsgdprc.`source` = "cookie_banner"
AND lpsgdprc.`id_shop` =1
AND lpsgdprc.`index_cookie` =0 LIMIT 1
 90.259 ms 113682 /modules/lpsgdpr/classes/lpsgdprconsent.php:134
4 
SELECT SQL_NO_CACHE COUNT(*) FROM ps_shop LIMIT 1
 40.279 ms 5 /classes/shop/Shop.php:1184
2 
SELECT SQL_NO_CACHE c.`name`, cl.`id_lang`, IF(cl.`id_lang` IS NULL, c.`value`, cl.`value`) AS value, c.id_shop_group, c.id_shop
FROM `ps_configuration` c
LEFT JOIN `ps_configuration_lang` cl ON (c.`id_configuration` = cl.`id_configuration`)
 34.187 ms 28984 /classes/Configuration.php:180
565 
SELECT SQL_NO_CACHE `id_wishlist`
FROM `ps_an_wishlist`
WHERE `id_customer` = 11151973
AND `is_guest` = 1
AND `id_shop` = 1 LIMIT 1
 7.485 ms 117 /modules/an_wishlist/classes/an_wish.php:76
442 
SELECT SQL_NO_CACHE `id_image_type`
FROM `ps_image_type`
WHERE `name` = 'home'
 7.265 ms 1 /classes/ImageType.php:145
579 
SELECT SQL_NO_CACHE p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) AS quantity, IFNULL(product_attribute_shop.id_product_attribute, 0) AS id_product_attribute,
product_attribute_shop.minimal_quantity AS product_attribute_minimal_quantity, pl.`description`, pl.`description_short`, pl.`available_now`,
pl.`available_later`, pl.`link_rewrite`, pl.`meta_description`, pl.`meta_keywords`, pl.`meta_title`, pl.`name`, image_shop.`id_image` id_image,
il.`legend` as legend, m.`name` AS manufacturer_name, cl.`name` AS category_default,
DATEDIFF(product_shop.`date_add`, DATE_SUB("2026-07-10 00:00:00",
INTERVAL 20 DAY)) > 0 AS new, product_shop.price AS orderprice
FROM `ps_category_product` cp
LEFT JOIN `ps_product` p
ON p.`id_product` = cp.`id_product`
INNER JOIN ps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) LEFT JOIN `ps_product_attribute_shop` product_attribute_shop
ON (p.`id_product` = product_attribute_shop.`id_product` AND product_attribute_shop.`default_on` = 1 AND product_attribute_shop.id_shop=1)
LEFT JOIN ps_stock_available stock
ON (stock.id_product = `p`.id_product AND stock.id_product_attribute = 0 AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
LEFT JOIN `ps_category_lang` cl
ON (product_shop.`id_category_default` = cl.`id_category`
AND cl.`id_lang` = 1 AND cl.id_shop = 1 )
LEFT JOIN `ps_product_lang` pl
ON (p.`id_product` = pl.`id_product`
AND pl.`id_lang` = 1 AND pl.id_shop = 1 )
LEFT JOIN `ps_image_shop` image_shop
ON (image_shop.`id_product` = p.`id_product` AND image_shop.cover=1 AND image_shop.id_shop=1)
LEFT JOIN `ps_image_lang` il
ON (image_shop.`id_image` = il.`id_image`
AND il.`id_lang` = 1)
LEFT JOIN `ps_manufacturer` m
ON m.`id_manufacturer` = p.`id_manufacturer`
WHERE product_shop.`id_shop` = 1
AND cp.`id_category` = 168 AND product_shop.`active` = 1 AND product_shop.`visibility` IN ("both", "catalog") ORDER BY RAND() LIMIT 9
 7.009 ms 131 Yes /classes/Category.php:1062
215 
SELECT SQL_NO_CACHE *
FROM `ps_ets_mm_column`
WHERE 1  AND id_menu=58
ORDER BY sort_order asc
 7.002 ms 15 Yes /modules/ets_megamenu/classes/MM_Column.php:126
773 
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 = 1884 LIMIT 1
 6.740 ms 1 /classes/Product.php:1106
778 
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
JOIN `ps_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `ps_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1)
JOIN `ps_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (3415) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
 5.976 ms 2 Yes Yes /classes/Product.php:4524
750 
SELECT SQL_NO_CACHE depends_on_stock
FROM `ps_stock_available`
WHERE (id_product = 3752) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
 5.828 ms 1 /classes/stock/StockAvailable.php:753
539 
SELECT SQL_NO_CACHE location
FROM `ps_stock_available`
WHERE (id_product = 2499) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
 5.403 ms 1 /classes/stock/StockAvailable.php:806
817 
SELECT SQL_NO_CACHE `id_date_range`, `time_end`
FROM `ps_date_range`
WHERE `time_end` = (SELECT MAX(`time_end`) FROM `ps_date_range`) LIMIT 1
 5.310 ms 7056 /classes/DateRange.php:60
197 
SELECT SQL_NO_CACHE b.*,bl.title,bl.title_link,bl.content,bl.image_link,bl.image
FROM `ps_ets_mm_block` b
LEFT JOIN `ps_ets_mm_block_lang` bl
ON b.id_block=bl.id_block AND bl.id_lang=1
WHERE 1  AND b.id_column=660 
ORDER BY b.sort_order asc,bl.title asc
 5.309 ms 3 Yes /modules/ets_megamenu/classes/MM_Block.php:615
17 
SELECT SQL_NO_CACHE h.`name` as hook, m.`id_module`, h.`id_hook`, m.`name` as module
FROM `ps_module` m
INNER JOIN ps_module_shop module_shop
ON (module_shop.id_module = m.id_module AND module_shop.id_shop = 1 AND module_shop.enable_device & 1)
INNER JOIN `ps_hook_module` `hm` ON hm.`id_module` = m.`id_module`
INNER JOIN `ps_hook` `h` ON hm.`id_hook` = h.`id_hook`
LEFT JOIN `ps_module_group` `mg` ON mg.`id_module` = m.`id_module`
WHERE (h.`name` != "paymentOptions") AND (hm.`id_shop` = 1) AND (mg.id_shop = 1 AND  mg.`id_group` IN (1))
GROUP BY hm.id_hook, hm.id_module
ORDER BY hm.`position`
 5.210 ms 106880 Yes Yes /classes/Hook.php:1289
749 
SELECT SQL_NO_CACHE out_of_stock
FROM `ps_stock_available`
WHERE (id_product = 3752) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
 5.153 ms 1 /classes/stock/StockAvailable.php:778
790 
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "an_about_us" LIMIT 1
 5.059 ms 1 /classes/module/Module.php:2664
430 
SELECT SQL_NO_CACHE `id_image_type`
FROM `ps_image_type`
WHERE `name` = 'home'
 4.617 ms 1 /classes/ImageType.php:145
318 
SELECT SQL_NO_CACHE `id_image_type`
FROM `ps_image_type`
WHERE `name` = 'home'
 4.593 ms 1 /classes/ImageType.php:145
537 
SELECT SQL_NO_CACHE out_of_stock
FROM `ps_stock_available`
WHERE (id_product = 2499) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
 4.399 ms 1 /classes/stock/StockAvailable.php:778
562 
SELECT SQL_NO_CACHE ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, agl.`public_name` AS public_group_name, a.`id_attribute`, al.`name` AS attribute_name, a.`color` AS attribute_color, product_attribute_shop.`id_product_attribute`, IFNULL(stock.quantity, 0) as quantity, product_attribute_shop.`price`, product_attribute_shop.`ecotax`, product_attribute_shop.`weight`, product_attribute_shop.`default_on`, pa.`reference`, pa.`ean13`, pa.`mpn`, pa.`upc`, pa.`isbn`, product_attribute_shop.`unit_price_impact`, product_attribute_shop.`minimal_quantity`, product_attribute_shop.`available_date`, ag.`group_type`, pal.`available_now`, pal.`available_later`
FROM `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
LEFT JOIN ps_stock_available stock
ON (stock.id_product = `pa`.id_product AND stock.id_product_attribute = IFNULL(`pa`.id_product_attribute, 0) AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
LEFT JOIN `ps_product_attribute_lang` `pal` ON pa.id_product_attribute = pal.id_product_attribute AND pal.id_lang = 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
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 = 1666) AND (al.id_lang = 1) AND (agl.id_lang = 1)
GROUP BY id_attribute_group, id_product_attribute
ORDER BY ag.position ASC, a.position ASC, agl.name ASC
 3.987 ms 2 Yes Yes /classes/Product.php:4600
287 
SELECT SQL_NO_CACHE b.*,bl.title,bl.title_link,bl.content,bl.image_link,bl.image
FROM `ps_ets_mm_block` b
LEFT JOIN `ps_ets_mm_block_lang` bl
ON b.id_block=bl.id_block AND bl.id_lang=1
WHERE 1  AND b.id_column=717 
ORDER BY b.sort_order asc,bl.title asc
 3.894 ms 1 Yes /modules/ets_megamenu/classes/MM_Block.php:615
709 
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` = 1)
WHERE i.`id_product` = 3415
ORDER BY `position`
 3.642 ms 6 Yes /classes/Product.php:3545
212 
SELECT SQL_NO_CACHE b.*,bl.title,bl.title_link,bl.content,bl.image_link,bl.image
FROM `ps_ets_mm_block` b
LEFT JOIN `ps_ets_mm_block_lang` bl
ON b.id_block=bl.id_block AND bl.id_lang=1
WHERE 1  AND b.id_column=653 
ORDER BY b.sort_order asc,bl.title asc
 3.524 ms 3 Yes /modules/ets_megamenu/classes/MM_Block.php:615
396 
SELECT SQL_NO_CACHE `id_image_type`
FROM `ps_image_type`
WHERE `name` = 'home'
 3.405 ms 1 /classes/ImageType.php:145
720 
SELECT SQL_NO_CACHE ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, agl.`public_name` AS public_group_name, a.`id_attribute`, al.`name` AS attribute_name, a.`color` AS attribute_color, product_attribute_shop.`id_product_attribute`, IFNULL(stock.quantity, 0) as quantity, product_attribute_shop.`price`, product_attribute_shop.`ecotax`, product_attribute_shop.`weight`, product_attribute_shop.`default_on`, pa.`reference`, pa.`ean13`, pa.`mpn`, pa.`upc`, pa.`isbn`, product_attribute_shop.`unit_price_impact`, product_attribute_shop.`minimal_quantity`, product_attribute_shop.`available_date`, ag.`group_type`, pal.`available_now`, pal.`available_later`
FROM `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
LEFT JOIN ps_stock_available stock
ON (stock.id_product = `pa`.id_product AND stock.id_product_attribute = IFNULL(`pa`.id_product_attribute, 0) AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
LEFT JOIN `ps_product_attribute_lang` `pal` ON pa.id_product_attribute = pal.id_product_attribute AND pal.id_lang = 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
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 = 3748) AND (al.id_lang = 1) AND (agl.id_lang = 1)
GROUP BY id_attribute_group, id_product_attribute
ORDER BY ag.position ASC, a.position ASC, agl.name ASC
 3.240 ms 2 Yes Yes /classes/Product.php:4600
39 
SELECT SQL_NO_CACHE c.id_currency
FROM `ps_currency` c
WHERE (iso_code = 'EUR') LIMIT 1
 3.180 ms 1 /classes/Currency.php:893
449 
SELECT SQL_NO_CACHE hbl.html,hb.style,hbl.id_lang
FROM `ps_ets_hb_html_box` hb
LEFT JOIN `ps_ets_hb_html_box_lang` hbl 
ON (hb.`id_ets_hb_html_box` = hbl.`id_ets_hb_html_box` AND hbl.`id_lang` = 1)
JOIN `ps_ets_hb_html_box_position` hbp 
ON (hbp.`id_ets_hb_html_box` = hb.`id_ets_hb_html_box`)
WHERE hb.active = 1
AND hbp.`position` = 9
 3.168 ms 168 /modules/ets_htmlbox/classes/HBHtmlbox.php:255
542 
SELECT SQL_NO_CACHE ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, agl.`public_name` AS public_group_name, a.`id_attribute`, al.`name` AS attribute_name, a.`color` AS attribute_color, product_attribute_shop.`id_product_attribute`, IFNULL(stock.quantity, 0) as quantity, product_attribute_shop.`price`, product_attribute_shop.`ecotax`, product_attribute_shop.`weight`, product_attribute_shop.`default_on`, pa.`reference`, pa.`ean13`, pa.`mpn`, pa.`upc`, pa.`isbn`, product_attribute_shop.`unit_price_impact`, product_attribute_shop.`minimal_quantity`, product_attribute_shop.`available_date`, ag.`group_type`, pal.`available_now`, pal.`available_later`
FROM `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
LEFT JOIN ps_stock_available stock
ON (stock.id_product = `pa`.id_product AND stock.id_product_attribute = IFNULL(`pa`.id_product_attribute, 0) AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
LEFT JOIN `ps_product_attribute_lang` `pal` ON pa.id_product_attribute = pal.id_product_attribute AND pal.id_lang = 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
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 = 2499) AND (al.id_lang = 1) AND (agl.id_lang = 1)
GROUP BY id_attribute_group, id_product_attribute
ORDER BY ag.position ASC, a.position ASC, agl.name ASC
 3.132 ms 2 Yes Yes /classes/Product.php:4600
818 
UPDATE `ps_page_viewed`
SET `counter` = `counter` + 1
WHERE `id_date_range` = 84
AND `id_page` = 1341
AND `id_shop` = 1
 3.103 ms 1 /classes/Page.php:131
320 
SELECT SQL_NO_CACHE `id_image_type`
FROM `ps_image_type`
WHERE `name` = 'home'
 2.983 ms 1 /classes/ImageType.php:145
444 
SELECT SQL_NO_CACHE `id_image_type`
FROM `ps_image_type`
WHERE `name` = 'home'
 2.911 ms 1 /classes/ImageType.php:145
443 
SELECT SQL_NO_CACHE `id_image_type`
FROM `ps_image_type`
WHERE `name` = 'home'
 2.891 ms 1 /classes/ImageType.php:145
7 
SELECT SQL_NO_CACHE l.*, ls.`id_shop`
FROM `ps_lang` l
LEFT JOIN `ps_lang_shop` ls ON (l.id_lang = ls.id_lang)
 2.808 ms 30 /classes/Language.php:1080
811 
INSERT INTO `ps_guest` (`id_operating_system`, `id_web_browser`, `id_customer`, `javascript`, `screen_resolution_x`, `screen_resolution_y`, `screen_color`, `sun_java`, `adobe_flash`, `adobe_director`, `apple_quicktime`, `real_player`, `windows_media`, `accept_language`, `mobile_theme`) VALUES ('0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', 'en', '0')
 2.808 ms 1 /classes/ObjectModel.php:622
268 
SELECT SQL_NO_CACHE b.*,bl.title,bl.title_link,bl.content,bl.image_link,bl.image
FROM `ps_ets_mm_block` b
LEFT JOIN `ps_ets_mm_block_lang` bl
ON b.id_block=bl.id_block AND bl.id_lang=1
WHERE 1  AND b.id_column=700 
ORDER BY b.sort_order asc,bl.title asc
 2.775 ms 1 Yes /modules/ets_megamenu/classes/MM_Block.php:615
365 
SELECT SQL_NO_CACHE `id_image_type`
FROM `ps_image_type`
WHERE `name` = 'home'
 2.745 ms 1 /classes/ImageType.php:145
566 
SELECT SQL_NO_CACHE COUNT(*)
FROM `ps_an_wishlist_products`
WHERE `id_product` = 2506 LIMIT 1
 2.675 ms 334 /modules/an_wishlist/classes/an_wish_products.php:124
205 
SELECT SQL_NO_CACHE b.*,bl.title,bl.title_link,bl.content,bl.image_link,bl.image
FROM `ps_ets_mm_block` b
LEFT JOIN `ps_ets_mm_block_lang` bl
ON b.id_block=bl.id_block AND bl.id_lang=1
WHERE 1  AND b.id_column=648 
ORDER BY b.sort_order asc,bl.title asc
 2.636 ms 5 Yes /modules/ets_megamenu/classes/MM_Block.php:615
815 
INSERT INTO `ps_connections` (`id_guest`, `id_page`, `ip_address`, `http_referer`, `id_shop`, `id_shop_group`, `date_add`) VALUES ('6088128', '1341', '0', '', '1', '1', '2026-07-10 16:18:37')
 2.623 ms 1 /classes/ObjectModel.php:622
775 
SELECT SQL_NO_CACHE ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, agl.`public_name` AS public_group_name, a.`id_attribute`, al.`name` AS attribute_name, a.`color` AS attribute_color, product_attribute_shop.`id_product_attribute`, IFNULL(stock.quantity, 0) as quantity, product_attribute_shop.`price`, product_attribute_shop.`ecotax`, product_attribute_shop.`weight`, product_attribute_shop.`default_on`, pa.`reference`, pa.`ean13`, pa.`mpn`, pa.`upc`, pa.`isbn`, product_attribute_shop.`unit_price_impact`, product_attribute_shop.`minimal_quantity`, product_attribute_shop.`available_date`, ag.`group_type`, pal.`available_now`, pal.`available_later`
FROM `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
LEFT JOIN ps_stock_available stock
ON (stock.id_product = `pa`.id_product AND stock.id_product_attribute = IFNULL(`pa`.id_product_attribute, 0) AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
LEFT JOIN `ps_product_attribute_lang` `pal` ON pa.id_product_attribute = pal.id_product_attribute AND pal.id_lang = 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
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 = 1884) AND (al.id_lang = 1) AND (agl.id_lang = 1)
GROUP BY id_attribute_group, id_product_attribute
ORDER BY ag.position ASC, a.position ASC, agl.name ASC
 2.612 ms 2 Yes Yes /classes/Product.php:4600
402 
SELECT SQL_NO_CACHE `id_image_type`
FROM `ps_image_type`
WHERE `name` = 'home'
 2.545 ms 1 /classes/ImageType.php:145
200 
SELECT SQL_NO_CACHE b.*,bl.title,bl.title_link,bl.content,bl.image_link,bl.image
FROM `ps_ets_mm_block` b
LEFT JOIN `ps_ets_mm_block_lang` bl
ON b.id_block=bl.id_block AND bl.id_lang=1
WHERE 1  AND b.id_column=656 
ORDER BY b.sort_order asc,bl.title asc
 2.544 ms 2 Yes /modules/ets_megamenu/classes/MM_Block.php:615
62 
SELECT SQL_NO_CACHE h.id_hook, h.name as h_name, title, description, h.position, hm.position as hm_position, m.id_module, m.name, m.active
FROM `ps_hook_module` hm
STRAIGHT_JOIN `ps_hook` h ON (h.id_hook = hm.id_hook AND hm.id_shop = 1)
STRAIGHT_JOIN `ps_module` as m ON (m.id_module = hm.id_module)
ORDER BY hm.position
 2.517 ms 604 /classes/Hook.php:459
267 
SELECT SQL_NO_CACHE b.*,bl.title,bl.title_link,bl.content,bl.image_link,bl.image
FROM `ps_ets_mm_block` b
LEFT JOIN `ps_ets_mm_block_lang` bl
ON b.id_block=bl.id_block AND bl.id_lang=1
WHERE 1  AND b.id_column=699 
ORDER BY b.sort_order asc,bl.title asc
 2.475 ms 1 Yes /modules/ets_megamenu/classes/MM_Block.php:615
754 
SELECT SQL_NO_CACHE ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, agl.`public_name` AS public_group_name, a.`id_attribute`, al.`name` AS attribute_name, a.`color` AS attribute_color, product_attribute_shop.`id_product_attribute`, IFNULL(stock.quantity, 0) as quantity, product_attribute_shop.`price`, product_attribute_shop.`ecotax`, product_attribute_shop.`weight`, product_attribute_shop.`default_on`, pa.`reference`, pa.`ean13`, pa.`mpn`, pa.`upc`, pa.`isbn`, product_attribute_shop.`unit_price_impact`, product_attribute_shop.`minimal_quantity`, product_attribute_shop.`available_date`, ag.`group_type`, pal.`available_now`, pal.`available_later`
FROM `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
LEFT JOIN ps_stock_available stock
ON (stock.id_product = `pa`.id_product AND stock.id_product_attribute = IFNULL(`pa`.id_product_attribute, 0) AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
LEFT JOIN `ps_product_attribute_lang` `pal` ON pa.id_product_attribute = pal.id_product_attribute AND pal.id_lang = 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
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 = 3752) AND (al.id_lang = 1) AND (agl.id_lang = 1)
GROUP BY id_attribute_group, id_product_attribute
ORDER BY ag.position ASC, a.position ASC, agl.name ASC
 2.417 ms 2 Yes Yes /classes/Product.php:4600
266 
SELECT SQL_NO_CACHE b.*,bl.title,bl.title_link,bl.content,bl.image_link,bl.image
FROM `ps_ets_mm_block` b
LEFT JOIN `ps_ets_mm_block_lang` bl
ON b.id_block=bl.id_block AND bl.id_lang=1
WHERE 1  AND b.id_column=697 
ORDER BY b.sort_order asc,bl.title asc
 2.410 ms 2 Yes /modules/ets_megamenu/classes/MM_Block.php:615
698 
SELECT SQL_NO_CACHE COUNT(cp.`id_product`) AS total
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_category_product` cp ON p.`id_product` = cp.`id_product`
WHERE cp.`id_category` = 168 AND product_shop.`visibility` IN ("both", "catalog") AND product_shop.`active` = 1 LIMIT 1
 2.403 ms 131 /classes/Category.php:991
746 
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
JOIN `ps_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `ps_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1)
JOIN `ps_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (3752) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
 2.336 ms 2 Yes Yes /classes/Product.php:4524
106 
SELECT SQL_NO_CACHE * FROM `ps_an_productextratabs_relations` szwr, `ps_an_productextratabs` sw
LEFT JOIN `ps_an_productextratabs_lang` sl 
ON (sw.`id_tab` = sl.`id_tab`
AND sl.`id_lang` = 1)
WHERE sw.`active`=1
AND sw.`id_tab` = szwr.`id_tab` AND sw.`relation` = szwr.`type`
AND ((szwr.`type` = 1 AND szwr.`id_type` IN (168)   )
OR (szwr.`type` = 2 AND szwr.`id_type` = 3024)
OR (szwr.`type` = 0 AND szwr.`id_type` = 0)
)
AND sw.`id_tab` IN (
SELECT sa.`id_tab`
FROM `ps_an_productextratabs_shop` sa
WHERE sa.id_shop IN (1)
) GROUP BY sw.`id_tab` ORDER BY sw.`position`
 2.303 ms 2 Yes Yes /modules/an_productextratabs/classes/anProductTabs.php:96
568 
SELECT SQL_NO_CACHE depends_on_stock
FROM `ps_stock_available`
WHERE (id_product = 2506) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
 2.298 ms 1 /classes/stock/StockAvailable.php:753
767 
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
JOIN `ps_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `ps_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1)
JOIN `ps_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (1884) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
 2.267 ms 2 Yes Yes /classes/Product.php:4524
570 
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 = 2506 LIMIT 1
 2.220 ms 1 /classes/Product.php:1106
206 
SELECT SQL_NO_CACHE b.*,bl.title,bl.title_link,bl.content,bl.image_link,bl.image
FROM `ps_ets_mm_block` b
LEFT JOIN `ps_ets_mm_block_lang` bl
ON b.id_block=bl.id_block AND bl.id_lang=1
WHERE 1  AND b.id_column=649 
ORDER BY b.sort_order asc,bl.title asc
 2.191 ms 1 Yes /modules/ets_megamenu/classes/MM_Block.php:615
141 
SELECT SQL_NO_CACHE *
FROM `ps_cms_lang`
WHERE `id_cms` = 2 AND `id_shop` = 1
 2.187 ms 5 /src/Adapter/EntityMapper.php:79
538 
SELECT SQL_NO_CACHE depends_on_stock
FROM `ps_stock_available`
WHERE (id_product = 2499) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
 2.184 ms 1 /classes/stock/StockAvailable.php:753
61 
SELECT SQL_NO_CACHE `id_hook`, `name`
FROM `ps_hook`
UNION
SELECT `id_hook`, ha.`alias` as name
FROM `ps_hook_alias` ha
INNER JOIN `ps_hook` h ON ha.name = h.name
 2.114 ms 0 /classes/Hook.php:1348
74 
SELECT SQL_NO_CACHE *, ( IF (`id_shop` = 1, 2, 0) +  IF (`id_country` = 21, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_group` = 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, 21) AND
`id_group` IN (0, 1) AND `id_product` = 3024 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2026-07-10 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2026-07-10 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
 2.098 ms 1 Yes /classes/SpecificPrice.php:576
764 
SELECT SQL_NO_CACHE ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, agl.`public_name` AS public_group_name, a.`id_attribute`, al.`name` AS attribute_name, a.`color` AS attribute_color, product_attribute_shop.`id_product_attribute`, IFNULL(stock.quantity, 0) as quantity, product_attribute_shop.`price`, product_attribute_shop.`ecotax`, product_attribute_shop.`weight`, product_attribute_shop.`default_on`, pa.`reference`, pa.`ean13`, pa.`mpn`, pa.`upc`, pa.`isbn`, product_attribute_shop.`unit_price_impact`, product_attribute_shop.`minimal_quantity`, product_attribute_shop.`available_date`, ag.`group_type`, pal.`available_now`, pal.`available_later`
FROM `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
LEFT JOIN ps_stock_available stock
ON (stock.id_product = `pa`.id_product AND stock.id_product_attribute = IFNULL(`pa`.id_product_attribute, 0) AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
LEFT JOIN `ps_product_attribute_lang` `pal` ON pa.id_product_attribute = pal.id_product_attribute AND pal.id_lang = 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
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 = 3870) AND (al.id_lang = 1) AND (agl.id_lang = 1)
GROUP BY id_attribute_group, id_product_attribute
ORDER BY ag.position ASC, a.position ASC, agl.name ASC
 2.086 ms 2 Yes Yes /classes/Product.php:4600
816 
INSERT INTO `ps_connections_source` (`id_connections`, `http_referer`, `request_uri`, `keywords`, `date_add`) VALUES ('5694669', '', 'capteurdepuissance.fr/mesures-m%C3%A9dicales/3024-pese-personne-kern-mpi-200-kg.html', '', '2026-07-10 16:18:37')
 2.078 ms 1 /classes/ObjectModel.php:622
774 
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` = 1)
WHERE i.`id_product` = 1884
ORDER BY `position`
 2.012 ms 1 Yes /classes/Product.php:3545
772 
SELECT SQL_NO_CACHE location
FROM `ps_stock_available`
WHERE (id_product = 1884) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
 1.996 ms 1 /classes/stock/StockAvailable.php:806
732 
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `ps_product_attribute`
WHERE `id_product` = 1974
 1.958 ms 1 /classes/Product.php:2902
204 
SELECT SQL_NO_CACHE b.*,bl.title,bl.title_link,bl.content,bl.image_link,bl.image
FROM `ps_ets_mm_block` b
LEFT JOIN `ps_ets_mm_block_lang` bl
ON b.id_block=bl.id_block AND bl.id_lang=1
WHERE 1  AND b.id_column=647 
ORDER BY b.sort_order asc,bl.title asc
 1.920 ms 5 Yes /modules/ets_megamenu/classes/MM_Block.php:615
162 
SELECT SQL_NO_CACHE hbl.html,hb.style,hbl.id_lang
FROM `ps_ets_hb_html_box` hb
LEFT JOIN `ps_ets_hb_html_box_lang` hbl 
ON (hb.`id_ets_hb_html_box` = hbl.`id_ets_hb_html_box` AND hbl.`id_lang` = 1)
JOIN `ps_ets_hb_html_box_position` hbp 
ON (hbp.`id_ets_hb_html_box` = hb.`id_ets_hb_html_box`)
WHERE hb.active = 1
AND hbp.`position` = 2
 1.916 ms 168 /modules/ets_htmlbox/classes/HBHtmlbox.php:255
328 
SELECT SQL_NO_CACHE `id_image_type`
FROM `ps_image_type`
WHERE `name` = 'home'
 1.907 ms 1 /classes/ImageType.php:145
733 
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
JOIN `ps_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `ps_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1)
JOIN `ps_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (3328) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
 1.830 ms 2 Yes Yes /classes/Product.php:4524
541 
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` = 1)
WHERE i.`id_product` = 2499
ORDER BY `position`
 1.805 ms 1 Yes /classes/Product.php:3545
627 
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 3029) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
 1.802 ms 1 /classes/stock/StockAvailable.php:453
283 
SELECT SQL_NO_CACHE b.*,bl.title,bl.title_link,bl.content,bl.image_link,bl.image
FROM `ps_ets_mm_block` b
LEFT JOIN `ps_ets_mm_block_lang` bl
ON b.id_block=bl.id_block AND bl.id_lang=1
WHERE 1  AND b.id_column=714 
ORDER BY b.sort_order asc,bl.title asc
 1.770 ms 1 Yes /modules/ets_megamenu/classes/MM_Block.php:615
699 
SELECT SQL_NO_CACHE p.*,
ps.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2026-07-10 00:00:00',
INTERVAL 20 DAY
)
) > 0) as new
FROM ps_product p
LEFT JOIN ps_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 1
LEFT JOIN ps_stock_available sa   ON sa.id_product = p.id_product
AND sa.id_product_attribute = 0
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 IN (3748,1974,3328,3029,3752,3870,1884,3415,3201)
 1.757 ms 9 /classes/ProductAssembler.php:95
529 
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` = 1666) AND (b.`id_shop` = 1) LIMIT 1
 1.755 ms 1 /src/Adapter/EntityMapper.php:71
34 
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
 1.754 ms 365 Yes /classes/Dispatcher.php:654
731 
SELECT SQL_NO_CACHE ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, agl.`public_name` AS public_group_name, a.`id_attribute`, al.`name` AS attribute_name, a.`color` AS attribute_color, product_attribute_shop.`id_product_attribute`, IFNULL(stock.quantity, 0) as quantity, product_attribute_shop.`price`, product_attribute_shop.`ecotax`, product_attribute_shop.`weight`, product_attribute_shop.`default_on`, pa.`reference`, pa.`ean13`, pa.`mpn`, pa.`upc`, pa.`isbn`, product_attribute_shop.`unit_price_impact`, product_attribute_shop.`minimal_quantity`, product_attribute_shop.`available_date`, ag.`group_type`, pal.`available_now`, pal.`available_later`
FROM `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
LEFT JOIN ps_stock_available stock
ON (stock.id_product = `pa`.id_product AND stock.id_product_attribute = IFNULL(`pa`.id_product_attribute, 0) AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
LEFT JOIN `ps_product_attribute_lang` `pal` ON pa.id_product_attribute = pal.id_product_attribute AND pal.id_lang = 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
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 = 1974) AND (al.id_lang = 1) AND (agl.id_lang = 1)
GROUP BY id_attribute_group, id_product_attribute
ORDER BY ag.position ASC, a.position ASC, agl.name ASC
 1.751 ms 2 Yes Yes /classes/Product.php:4600
533 
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` = 1)
WHERE i.`id_product` = 2506
ORDER BY `position`
 1.701 ms 1 Yes /classes/Product.php:3545
198 
SELECT SQL_NO_CACHE b.*,bl.title,bl.title_link,bl.content,bl.image_link,bl.image
FROM `ps_ets_mm_block` b
LEFT JOIN `ps_ets_mm_block_lang` bl
ON b.id_block=bl.id_block AND bl.id_lang=1
WHERE 1  AND b.id_column=661 
ORDER BY b.sort_order asc,bl.title asc
 1.670 ms 1 Yes /modules/ets_megamenu/classes/MM_Block.php:615
237 
SELECT SQL_NO_CACHE b.*,bl.title,bl.title_link,bl.content,bl.image_link,bl.image
FROM `ps_ets_mm_block` b
LEFT JOIN `ps_ets_mm_block_lang` bl
ON b.id_block=bl.id_block AND bl.id_lang=1
WHERE 1  AND b.id_column=725 
ORDER BY b.sort_order asc,bl.title asc
 1.664 ms 1 Yes /modules/ets_megamenu/classes/MM_Block.php:615
269 
SELECT SQL_NO_CACHE b.*,bl.title,bl.title_link,bl.content,bl.image_link,bl.image
FROM `ps_ets_mm_block` b
LEFT JOIN `ps_ets_mm_block_lang` bl
ON b.id_block=bl.id_block AND bl.id_lang=1
WHERE 1  AND b.id_column=701 
ORDER BY b.sort_order asc,bl.title asc
 1.651 ms 1 Yes /modules/ets_megamenu/classes/MM_Block.php:615
418 
SELECT SQL_NO_CACHE `id_image_type`
FROM `ps_image_type`
WHERE `name` = 'home'
 1.625 ms 1 /classes/ImageType.php:145
769 
SELECT SQL_NO_CACHE COUNT(*)
FROM `ps_an_wishlist_products`
WHERE `id_product` = 1884 LIMIT 1
 1.621 ms 334 /modules/an_wishlist/classes/an_wish_products.php:124
218 
SELECT SQL_NO_CACHE b.*,bl.title,bl.title_link,bl.content,bl.image_link,bl.image
FROM `ps_ets_mm_block` b
LEFT JOIN `ps_ets_mm_block_lang` bl
ON b.id_block=bl.id_block AND bl.id_lang=1
WHERE 1  AND b.id_column=664 
ORDER BY b.sort_order asc,bl.title asc
 1.572 ms 2 Yes /modules/ets_megamenu/classes/MM_Block.php:615
155 
SELECT SQL_NO_CACHE * FROM `ps_cart_rule` cr
LEFT JOIN `ps_cart_rule_lang` crl 
ON (cr.`id_cart_rule` = crl.`id_cart_rule` AND crl.`id_lang` = 1) WHERE (cr.`id_customer` = 0) AND NOW() BETWEEN cr.date_from AND cr.date_to
AND cr.`active` = 1
AND free_shipping = 1 AND carrier_restriction = 1
 1.563 ms 53 /classes/CartRule.php:423
768 
SELECT SQL_NO_CACHE `id_wishlist`
FROM `ps_an_wishlist`
WHERE `id_customer` = 11151973
AND `is_guest` = 1
AND `id_shop` = 1 LIMIT 1
 1.563 ms 117 /modules/an_wishlist/classes/an_wish.php:76
156 
SELECT SQL_NO_CACHE ac.id_ets_abancart_campaign
FROM `ps_ets_abancart_campaign` ac
LEFT JOIN `ps_ets_abancart_campaign_country` `cc` ON cc.id_ets_abancart_campaign = ac.id_ets_abancart_campaign
LEFT JOIN `ps_ets_abancart_campaign_with_lang` `cl` ON cl.id_ets_abancart_campaign = ac.id_ets_abancart_campaign AND cl.id_lang=1
LEFT JOIN `ps_ets_abancart_campaign_group` `acg` ON ac.id_ets_abancart_campaign = acg.id_ets_abancart_campaign
LEFT JOIN `ps_group_shop` `gs` ON gs.id_group = acg.id_group AND gs.id_shop = 1
WHERE (ac.id_shop = 1) AND (ac.enabled = 1 AND ac.deleted = 0) AND (IF(ac.is_all_lang != 1, cl.id_ets_abancart_campaign is NOT NULL AND cl.id_lang=1, 1)) AND (ac.campaign_type != 'email') AND (ac.campaign_type != 'customer') AND (IF(ac.min_total_cart is NOT NULL AND ac.has_product_in_cart = 1, ac.min_total_cart <= 0, 1) AND IF(ac.max_total_cart is NOT NULL AND ac.has_product_in_cart = 1, ac.max_total_cart >= 0, 1)) AND (IF(ac.available_from is NOT NULL, ac.available_from <= '2026-07-10', 1) AND IF(ac.available_to is NOT NULL, ac.available_to >= '2026-07-10', 1)) AND (IF(ac.has_applied_voucher = 'both' OR (ac.has_applied_voucher = 'yes' AND 0 > 0) OR (ac.has_applied_voucher = 'no' AND 0 = 0), 1, 0)) AND (IF(ac.has_product_in_cart = 1, 0, 1)) AND (acg.id_group = 1) AND (ac.is_all_country = 1 OR cc.id_country = -1 OR cc.id_country=21)
GROUP BY ac.id_ets_abancart_campaign
 1.545 ms 1 Yes /modules/ets_abandonedcart/classes/EtsAbancartCampaign.php:464
222 
SELECT SQL_NO_CACHE b.*,bl.title,bl.title_link,bl.content,bl.image_link,bl.image
FROM `ps_ets_mm_block` b
LEFT JOIN `ps_ets_mm_block_lang` bl
ON b.id_block=bl.id_block AND bl.id_lang=1
WHERE 1  AND b.id_column=668 
ORDER BY b.sort_order asc,bl.title asc
 1.535 ms 1 Yes /modules/ets_megamenu/classes/MM_Block.php:615
202 
SELECT SQL_NO_CACHE b.*,bl.title,bl.title_link,bl.content,bl.image_link,bl.image
FROM `ps_ets_mm_block` b
LEFT JOIN `ps_ets_mm_block_lang` bl
ON b.id_block=bl.id_block AND bl.id_lang=1
WHERE 1  AND b.id_column=658 
ORDER BY b.sort_order asc,bl.title asc
 1.513 ms 1 Yes /modules/ets_megamenu/classes/MM_Block.php:615
771 
SELECT SQL_NO_CACHE depends_on_stock
FROM `ps_stock_available`
WHERE (id_product = 1884) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
 1.504 ms 1 /classes/stock/StockAvailable.php:753
741 
SELECT SQL_NO_CACHE ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, agl.`public_name` AS public_group_name, a.`id_attribute`, al.`name` AS attribute_name, a.`color` AS attribute_color, product_attribute_shop.`id_product_attribute`, IFNULL(stock.quantity, 0) as quantity, product_attribute_shop.`price`, product_attribute_shop.`ecotax`, product_attribute_shop.`weight`, product_attribute_shop.`default_on`, pa.`reference`, pa.`ean13`, pa.`mpn`, pa.`upc`, pa.`isbn`, product_attribute_shop.`unit_price_impact`, product_attribute_shop.`minimal_quantity`, product_attribute_shop.`available_date`, ag.`group_type`, pal.`available_now`, pal.`available_later`
FROM `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
LEFT JOIN ps_stock_available stock
ON (stock.id_product = `pa`.id_product AND stock.id_product_attribute = IFNULL(`pa`.id_product_attribute, 0) AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
LEFT JOIN `ps_product_attribute_lang` `pal` ON pa.id_product_attribute = pal.id_product_attribute AND pal.id_lang = 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
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 = 3328) AND (al.id_lang = 1) AND (agl.id_lang = 1)
GROUP BY id_attribute_group, id_product_attribute
ORDER BY ag.position ASC, a.position ASC, agl.name ASC
 1.474 ms 2 Yes Yes /classes/Product.php:4600
210 
SELECT SQL_NO_CACHE b.*,bl.title,bl.title_link,bl.content,bl.image_link,bl.image
FROM `ps_ets_mm_block` b
LEFT JOIN `ps_ets_mm_block_lang` bl
ON b.id_block=bl.id_block AND bl.id_lang=1
WHERE 1  AND b.id_column=652 
ORDER BY b.sort_order asc,bl.title asc
 1.466 ms 1 Yes /modules/ets_megamenu/classes/MM_Block.php:615
13 
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
 1.456 ms 5 /classes/Language.php:1216
158 
SELECT SQL_NO_CACHE 1 FROM `ps_cart_rule` WHERE ((date_to >= "2026-07-10 00:00:00" AND date_to <= "2026-07-10 23:59:59") OR (date_from >= "2026-07-10 00:00:00" AND date_from <= "2026-07-10 23:59:59") OR (date_from < "2026-07-10 00:00:00" AND date_to > "2026-07-10 23:59:59")) AND `id_customer` IN (0,0) LIMIT 1
 1.396 ms 54 /classes/CartRule.php:357
799 
SELECT SQL_NO_CACHE lpsgdprc.*, lpsgdprcl.`message`
FROM `ps_lpsgdpr_compliant` lpsgdprc
LEFT JOIN ps_lpsgdpr_compliant_lang lpsgdprcl
ON (lpsgdprc.`id_lpsgdpr_compliant` = lpsgdprcl.`id_lpsgdpr_compliant`)
WHERE lpsgdprc.`form_name` = "ps_emailsubscriptionlpsform"
AND lpsgdprcl.`id_lang` =1
AND lpsgdprc.`id_shop` =1
 1.391 ms 18 /modules/lpsgdpr/classes/lpsgdprcompliant.php:199
249 
SELECT SQL_NO_CACHE b.*,bl.title,bl.title_link,bl.content,bl.image_link,bl.image
FROM `ps_ets_mm_block` b
LEFT JOIN `ps_ets_mm_block_lang` bl
ON b.id_block=bl.id_block AND bl.id_lang=1
WHERE 1  AND b.id_column=677 
ORDER BY b.sort_order asc,bl.title asc
 1.340 ms 2 Yes /modules/ets_megamenu/classes/MM_Block.php:615
112 
SELECT SQL_NO_CACHE ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, agl.`public_name` AS public_group_name, a.`id_attribute`, al.`name` AS attribute_name, a.`color` AS attribute_color, product_attribute_shop.`id_product_attribute`, IFNULL(stock.quantity, 0) as quantity, product_attribute_shop.`price`, product_attribute_shop.`ecotax`, product_attribute_shop.`weight`, product_attribute_shop.`default_on`, pa.`reference`, pa.`ean13`, pa.`mpn`, pa.`upc`, pa.`isbn`, product_attribute_shop.`unit_price_impact`, product_attribute_shop.`minimal_quantity`, product_attribute_shop.`available_date`, ag.`group_type`, pal.`available_now`, pal.`available_later`
FROM `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
LEFT JOIN ps_stock_available stock
ON (stock.id_product = `pa`.id_product AND stock.id_product_attribute = IFNULL(`pa`.id_product_attribute, 0) AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
LEFT JOIN `ps_product_attribute_lang` `pal` ON pa.id_product_attribute = pal.id_product_attribute AND pal.id_lang = 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
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 = 3024) AND (al.id_lang = 1) AND (agl.id_lang = 1)
GROUP BY id_attribute_group, id_product_attribute
ORDER BY ag.position ASC, a.position ASC, agl.name ASC
 1.335 ms 2 Yes Yes /classes/Product.php:4600
368 
SELECT SQL_NO_CACHE `id_image_type`
FROM `ps_image_type`
WHERE `name` = 'home'
 1.330 ms 1 /classes/ImageType.php:145
786 
SELECT SQL_NO_CACHE ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, agl.`public_name` AS public_group_name, a.`id_attribute`, al.`name` AS attribute_name, a.`color` AS attribute_color, product_attribute_shop.`id_product_attribute`, IFNULL(stock.quantity, 0) as quantity, product_attribute_shop.`price`, product_attribute_shop.`ecotax`, product_attribute_shop.`weight`, product_attribute_shop.`default_on`, pa.`reference`, pa.`ean13`, pa.`mpn`, pa.`upc`, pa.`isbn`, product_attribute_shop.`unit_price_impact`, product_attribute_shop.`minimal_quantity`, product_attribute_shop.`available_date`, ag.`group_type`, pal.`available_now`, pal.`available_later`
FROM `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
LEFT JOIN ps_stock_available stock
ON (stock.id_product = `pa`.id_product AND stock.id_product_attribute = IFNULL(`pa`.id_product_attribute, 0) AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
LEFT JOIN `ps_product_attribute_lang` `pal` ON pa.id_product_attribute = pal.id_product_attribute AND pal.id_lang = 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
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 = 3415) AND (al.id_lang = 1) AND (agl.id_lang = 1)
GROUP BY id_attribute_group, id_product_attribute
ORDER BY ag.position ASC, a.position ASC, agl.name ASC
 1.327 ms 2 Yes Yes /classes/Product.php:4600
270 
SELECT SQL_NO_CACHE b.*,bl.title,bl.title_link,bl.content,bl.image_link,bl.image
FROM `ps_ets_mm_block` b
LEFT JOIN `ps_ets_mm_block_lang` bl
ON b.id_block=bl.id_block AND bl.id_lang=1
WHERE 1  AND b.id_column=702 
ORDER BY b.sort_order asc,bl.title asc
 1.325 ms 1 Yes /modules/ets_megamenu/classes/MM_Block.php:615
745 
SELECT SQL_NO_CACHE COUNT(*)
FROM `ps_an_wishlist_products`
WHERE `id_product` = 3029 LIMIT 1
 1.324 ms 334 /modules/an_wishlist/classes/an_wish_products.php:124
417 
SELECT SQL_NO_CACHE `id_image_type`
FROM `ps_image_type`
WHERE `name` = 'home'
 1.311 ms 1 /classes/ImageType.php:145
780 
SELECT SQL_NO_CACHE COUNT(*)
FROM `ps_an_wishlist_products`
WHERE `id_product` = 3415 LIMIT 1
 1.289 ms 334 /modules/an_wishlist/classes/an_wish_products.php:124
737 
SELECT SQL_NO_CACHE depends_on_stock
FROM `ps_stock_available`
WHERE (id_product = 3328) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
 1.287 ms 1 /classes/stock/StockAvailable.php:753
540 
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 = 2499 LIMIT 1
 1.266 ms 1 /classes/Product.php:1106
472 
SELECT SQL_NO_CACHE DISTINCT od.product_id
FROM ps_order_detail od
LEFT JOIN ps_product p ON (p.id_product = od.product_id)
INNER JOIN ps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_category_product` cp ON (cp.`id_category` = product_shop.id_category_default AND cp.id_product = product_shop.id_product)
LEFT JOIN `ps_category_group` cg ON (cp.`id_category` = cg.`id_category`)
WHERE od.id_order IN (7396,6045)
AND od.product_id NOT IN (3024)
AND product_shop.visibility IN ('both','catalog')
AND product_shop.active = 1
AND cg.`id_group` =1
ORDER BY RAND()
LIMIT 8
 1.250 ms 6 Yes /modules/ps_crossselling/ps_crossselling.php:288
736 
SELECT SQL_NO_CACHE out_of_stock
FROM `ps_stock_available`
WHERE (id_product = 3328) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
 1.245 ms 1 /classes/stock/StockAvailable.php:778
16 
SELECT SQL_NO_CACHE lower(name) as name
FROM `ps_hook` h
WHERE (h.active = 1)
 1.242 ms 1054 /classes/Hook.php:1388
572 
SELECT SQL_NO_CACHE ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, agl.`public_name` AS public_group_name, a.`id_attribute`, al.`name` AS attribute_name, a.`color` AS attribute_color, product_attribute_shop.`id_product_attribute`, IFNULL(stock.quantity, 0) as quantity, product_attribute_shop.`price`, product_attribute_shop.`ecotax`, product_attribute_shop.`weight`, product_attribute_shop.`default_on`, pa.`reference`, pa.`ean13`, pa.`mpn`, pa.`upc`, pa.`isbn`, product_attribute_shop.`unit_price_impact`, product_attribute_shop.`minimal_quantity`, product_attribute_shop.`available_date`, ag.`group_type`, pal.`available_now`, pal.`available_later`
FROM `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
LEFT JOIN ps_stock_available stock
ON (stock.id_product = `pa`.id_product AND stock.id_product_attribute = IFNULL(`pa`.id_product_attribute, 0) AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
LEFT JOIN `ps_product_attribute_lang` `pal` ON pa.id_product_attribute = pal.id_product_attribute AND pal.id_lang = 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
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 = 2506) AND (al.id_lang = 1) AND (agl.id_lang = 1)
GROUP BY id_attribute_group, id_product_attribute
ORDER BY ag.position ASC, a.position ASC, agl.name ASC
 1.221 ms 2 Yes Yes /classes/Product.php:4600
161 
SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 93 AND `id_shop` = 1 LIMIT 1
 1.221 ms 1 /classes/module/Module.php:2137
109 
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 SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity
FROM `ps_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 3024 UNION SELECT 0 as first_level_quantity, SUM(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_cart` = 0 AND p.`id_product_item` = 3024 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 1.210 ms 0 /classes/Cart.php:1430
211 
SELECT SQL_NO_CACHE *
FROM `ps_ets_mm_column`
WHERE 1  AND id_tab=48
ORDER BY sort_order asc
 1.204 ms 3 Yes /modules/ets_megamenu/classes/MM_Column.php:139
770 
SELECT SQL_NO_CACHE out_of_stock
FROM `ps_stock_available`
WHERE (id_product = 1884) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
 1.196 ms 1 /classes/stock/StockAvailable.php:778
214 
SELECT SQL_NO_CACHE b.*,bl.title,bl.title_link,bl.content,bl.image_link,bl.image
FROM `ps_ets_mm_block` b
LEFT JOIN `ps_ets_mm_block_lang` bl
ON b.id_block=bl.id_block AND bl.id_lang=1
WHERE 1  AND b.id_column=655 
ORDER BY b.sort_order asc,bl.title asc
 1.191 ms 3 Yes /modules/ets_megamenu/classes/MM_Block.php:615
747 
SELECT SQL_NO_CACHE `id_wishlist`
FROM `ps_an_wishlist`
WHERE `id_customer` = 11151973
AND `is_guest` = 1
AND `id_shop` = 1 LIMIT 1
 1.184 ms 117 /modules/an_wishlist/classes/an_wish.php:76
102 
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(
"2026-07-10 00:00:00",
INTERVAL 20 DAY
)
) > 0 AS new
FROM `ps_accessory`
LEFT JOIN `ps_product` p ON p.`id_product` = `id_product_2`
INNER JOIN ps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_product_attribute_shop` product_attribute_shop
ON (p.`id_product` = product_attribute_shop.`id_product` AND product_attribute_shop.`default_on` = 1 AND product_attribute_shop.id_shop=1)
LEFT JOIN `ps_product_lang` pl ON (
p.`id_product` = pl.`id_product`
AND pl.`id_lang` = 1 AND pl.id_shop = 1 
)
LEFT JOIN `ps_category_lang` cl ON (
product_shop.`id_category_default` = cl.`id_category`
AND cl.`id_lang` = 1 AND cl.id_shop = 1 
)
LEFT JOIN `ps_image_shop` image_shop
ON (image_shop.`id_product` = p.`id_product` AND image_shop.cover=1 AND image_shop.id_shop=1)
LEFT JOIN `ps_image_lang` il ON (image_shop.`id_image` = il.`id_image` AND il.`id_lang` = 1)
LEFT JOIN `ps_manufacturer` m ON (p.`id_manufacturer`= m.`id_manufacturer`)
LEFT JOIN ps_stock_available stock
ON (stock.id_product = `p`.id_product AND stock.id_product_attribute = 0 AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
WHERE `id_product_1` = 3024 AND product_shop.`active` = 1 AND product_shop.`visibility` != 'none'
GROUP BY product_shop.id_product
 1.178 ms 1 Yes /classes/Product.php:4713
138 
SELECT SQL_NO_CACHE *
FROM `ps_lpsgdpr_config` a
LEFT JOIN `ps_lpsgdpr_config_lang` `b` ON a.`id_lpsgdpr_config` = b.`id_lpsgdpr_config` AND b.`id_lang` = 1
WHERE (a.`id_lpsgdpr_config` = 1) LIMIT 1
 1.178 ms 1 /src/Adapter/EntityMapper.php:71
473 
SELECT SQL_NO_CACHE p.*,
ps.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2026-07-10 00:00:00',
INTERVAL 20 DAY
)
) > 0) as new
FROM ps_product p
LEFT JOIN ps_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 1
LEFT JOIN ps_stock_available sa   ON sa.id_product = p.id_product
AND sa.id_product_attribute = 0
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 IN (2499,2507,1666,2506)
 1.173 ms 4 /classes/ProductAssembler.php:95
394 
SELECT SQL_NO_CACHE `id_image_type`
FROM `ps_image_type`
WHERE `name` = 'home'
 1.148 ms 1 /classes/ImageType.php:145
468 
SELECT SQL_NO_CACHE ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, agl.`public_name` AS public_group_name, a.`id_attribute`, al.`name` AS attribute_name, a.`color` AS attribute_color, product_attribute_shop.`id_product_attribute`, IFNULL(stock.quantity, 0) as quantity, product_attribute_shop.`price`, product_attribute_shop.`ecotax`, product_attribute_shop.`weight`, product_attribute_shop.`default_on`, pa.`reference`, pa.`ean13`, pa.`mpn`, pa.`upc`, pa.`isbn`, product_attribute_shop.`unit_price_impact`, product_attribute_shop.`minimal_quantity`, product_attribute_shop.`available_date`, ag.`group_type`, pal.`available_now`, pal.`available_later`
FROM `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
LEFT JOIN ps_stock_available stock
ON (stock.id_product = `pa`.id_product AND stock.id_product_attribute = IFNULL(`pa`.id_product_attribute, 0) AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
LEFT JOIN `ps_product_attribute_lang` `pal` ON pa.id_product_attribute = pal.id_product_attribute AND pal.id_lang = 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
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 = 3024) AND (al.id_lang = 1) AND (agl.id_lang = 1)
GROUP BY id_attribute_group, id_product_attribute
ORDER BY ag.position ASC, a.position ASC, agl.name ASC
 1.144 ms 2 Yes Yes /classes/Product.php:4600
435 
SELECT SQL_NO_CACHE `id_image_type`
FROM `ps_image_type`
WHERE `name` = 'home'
 1.138 ms 1 /classes/ImageType.php:145
216 
SELECT SQL_NO_CACHE b.*,bl.title,bl.title_link,bl.content,bl.image_link,bl.image
FROM `ps_ets_mm_block` b
LEFT JOIN `ps_ets_mm_block_lang` bl
ON b.id_block=bl.id_block AND bl.id_lang=1
WHERE 1  AND b.id_column=662 
ORDER BY b.sort_order asc,bl.title asc
 1.135 ms 1 Yes /modules/ets_megamenu/classes/MM_Block.php:615
422 
SELECT SQL_NO_CACHE `id_image_type`
FROM `ps_image_type`
WHERE `name` = 'home'
 1.129 ms 1 /classes/ImageType.php:145
744 
SELECT SQL_NO_CACHE `id_wishlist`
FROM `ps_an_wishlist`
WHERE `id_customer` = 11151973
AND `is_guest` = 1
AND `id_shop` = 1 LIMIT 1
 1.128 ms 117 /modules/an_wishlist/classes/an_wish.php:76
321 
SELECT SQL_NO_CACHE `id_image_type`
FROM `ps_image_type`
WHERE `name` = 'home'
 1.127 ms 1 /classes/ImageType.php:145
794 
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "ps_emailsubscription" LIMIT 1
 1.118 ms 1 /classes/module/Module.php:2664
334 
SELECT SQL_NO_CACHE c.*, cl.name,cl.link_rewrite
FROM `ps_category` c
INNER JOIN `ps_category_shop` cs ON (c.id_category =cs.id_category AND cs.id_shop=1)
LEFT JOIN `ps_category_lang` cl ON c.id_category=cl.id_category AND cl.id_lang=1
WHERE c.active=1 AND  c.id_parent=228 AND c.id_category!=228
GROUP BY c.id_category ORDER BY cl.name ASC,c.id_category ASC
 1.110 ms 343 Yes Yes /modules/ets_megamenu/classes/Ets_megamenu_defines.php:147
602 
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 SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity
FROM `ps_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 1974 UNION SELECT 0 as first_level_quantity, SUM(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_cart` = 0 AND p.`id_product_item` = 1974 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 1.107 ms 0 /classes/Cart.php:1430
332 
SELECT SQL_NO_CACHE `id_image_type`
FROM `ps_image_type`
WHERE `name` = 'home'
 1.104 ms 1 /classes/ImageType.php:145
567 
SELECT SQL_NO_CACHE out_of_stock
FROM `ps_stock_available`
WHERE (id_product = 2506) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
 1.103 ms 1 /classes/stock/StockAvailable.php:778
630 
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` = 3752
AND image_shop.`cover` = 1 LIMIT 1
 1.102 ms 1 /classes/Product.php:3570
792 
SELECT SQL_NO_CACHE * FROM `ps_an_trust_badges_widgets` sw
LEFT JOIN `ps_an_trust_badges_widgets_lang` sl 
ON (sw.`id_widget` = sl.`id_widget`
AND sl.`id_lang` = 1)
WHERE sw.`active`=1 
AND sw.`hook`="displayFooterLeftBlock2" AND sw.`id_widget` IN (
SELECT sa.`id_widget`
FROM `ps_an_trust_badges_widgets_shop` sa
WHERE sa.id_shop IN (1)
)
 1.093 ms 6 /modules/an_trust_badges/classes/AnTrustBadgesWidgets.php:86
552 
SELECT SQL_NO_CACHE ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, agl.`public_name` AS public_group_name, a.`id_attribute`, al.`name` AS attribute_name, a.`color` AS attribute_color, product_attribute_shop.`id_product_attribute`, IFNULL(stock.quantity, 0) as quantity, product_attribute_shop.`price`, product_attribute_shop.`ecotax`, product_attribute_shop.`weight`, product_attribute_shop.`default_on`, pa.`reference`, pa.`ean13`, pa.`mpn`, pa.`upc`, pa.`isbn`, product_attribute_shop.`unit_price_impact`, product_attribute_shop.`minimal_quantity`, product_attribute_shop.`available_date`, ag.`group_type`, pal.`available_now`, pal.`available_later`
FROM `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
LEFT JOIN ps_stock_available stock
ON (stock.id_product = `pa`.id_product AND stock.id_product_attribute = IFNULL(`pa`.id_product_attribute, 0) AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
LEFT JOIN `ps_product_attribute_lang` `pal` ON pa.id_product_attribute = pal.id_product_attribute AND pal.id_lang = 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
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 = 2507) AND (al.id_lang = 1) AND (agl.id_lang = 1)
GROUP BY id_attribute_group, id_product_attribute
ORDER BY ag.position ASC, a.position ASC, agl.name ASC
 1.089 ms 2 Yes Yes /classes/Product.php:4600
159 
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` = 0) WHERE (cr.`id_customer` = 0) 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_%"
 1.088 ms 1 /classes/CartRule.php:423
302 
SELECT SQL_NO_CACHE `id_image_type`
FROM `ps_image_type`
WHERE `name` = 'home'
 1.086 ms 1 /classes/ImageType.php:145
797 
SELECT SQL_NO_CACHE lpsgdprc.`id_lpsgdpr_config`
FROM `ps_lpsgdpr_config` lpsgdprc
WHERE lpsgdprc.`id_shop` =1 LIMIT 1
 1.078 ms 5 /modules/lpsgdpr/classes/lpsgdprconfig.php:199
447 
SELECT SQL_NO_CACHE `id_image_type`
FROM `ps_image_type`
WHERE `name` = 'home'
 1.073 ms 1 /classes/ImageType.php:145
734 
SELECT SQL_NO_CACHE `id_wishlist`
FROM `ps_an_wishlist`
WHERE `id_customer` = 11151973
AND `is_guest` = 1
AND `id_shop` = 1 LIMIT 1
 1.071 ms 117 /modules/an_wishlist/classes/an_wish.php:76
19 
SELECT SQL_NO_CACHE `id_hook`, `name` FROM `ps_hook`
 1.058 ms 1054 /classes/Hook.php:1348
36 
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
 1.057 ms 99 /classes/module/Module.php:346
33 
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
 1.049 ms 99 /classes/module/Module.php:346
201 
SELECT SQL_NO_CACHE b.*,bl.title,bl.title_link,bl.content,bl.image_link,bl.image
FROM `ps_ets_mm_block` b
LEFT JOIN `ps_ets_mm_block_lang` bl
ON b.id_block=bl.id_block AND bl.id_lang=1
WHERE 1  AND b.id_column=657 
ORDER BY b.sort_order asc,bl.title asc
 1.041 ms 2 Yes /modules/ets_megamenu/classes/MM_Block.php:615
113 
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "ps_legalcompliance" LIMIT 1
 1.036 ms 0 /classes/module/Module.php:2664
307 
SELECT SQL_NO_CACHE `id_image_type`
FROM `ps_image_type`
WHERE `name` = 'home'
 1.032 ms 1 /classes/ImageType.php:145
638 
SELECT SQL_NO_CACHE product_type FROM `ps_product` WHERE id_product = 3752 LIMIT 1
 1.026 ms 1 /classes/Pack.php:90
275 
SELECT SQL_NO_CACHE b.*,bl.title,bl.title_link,bl.content,bl.image_link,bl.image
FROM `ps_ets_mm_block` b
LEFT JOIN `ps_ets_mm_block_lang` bl
ON b.id_block=bl.id_block AND bl.id_lang=1
WHERE 1  AND b.id_column=707 
ORDER BY b.sort_order asc,bl.title asc
 1.022 ms 1 Yes /modules/ets_megamenu/classes/MM_Block.php:615
454 
SELECT SQL_NO_CACHE * FROM `ps_an_size_guide_widgets_relations` szwr, `ps_an_size_guide_widgets` sw
LEFT JOIN `ps_an_size_guide_widgets_lang` sl 
ON (sw.`id_widget` = sl.`id_widget`
AND sl.`id_lang` = 1)
WHERE sw.`active`=1
AND sw.`id_widget` = szwr.`widget` AND sw.`relation` = szwr.`type`
AND (
(szwr.`type` = 1 AND szwr.`id_type` IN (168)   ) OR 
(szwr.`type` = 2 AND szwr.`id_type` = 3024) OR 
(szwr.`type` = 0 AND szwr.`id_type` = 0)) AND sw.`id_widget` IN (
SELECT sa.`id_widget`
FROM `ps_an_size_guide_widgets_shop` sa
WHERE sa.id_shop IN (1)
)
 1.021 ms 1 /modules/an_sizeguide/classes/AnSizeGuide.php:94
323 
SELECT SQL_NO_CACHE `id_image_type`
FROM `ps_image_type`
WHERE `name` = 'home'
 1.016 ms 1 /classes/ImageType.php:145
233 
SELECT SQL_NO_CACHE b.*,bl.title,bl.title_link,bl.content,bl.image_link,bl.image
FROM `ps_ets_mm_block` b
LEFT JOIN `ps_ets_mm_block_lang` bl
ON b.id_block=bl.id_block AND bl.id_lang=1
WHERE 1  AND b.id_column=736 
ORDER BY b.sort_order asc,bl.title asc
 1.007 ms 3 Yes /modules/ets_megamenu/classes/MM_Block.php:615
432 
SELECT SQL_NO_CACHE `id_image_type`
FROM `ps_image_type`
WHERE `name` = 'home'
 1.007 ms 1 /classes/ImageType.php:145
544 
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
JOIN `ps_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `ps_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1)
JOIN `ps_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (2507) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
 1.006 ms 2 Yes Yes /classes/Product.php:4524
325 
SELECT SQL_NO_CACHE `id_image_type`
FROM `ps_image_type`
WHERE `name` = 'home'
 1.002 ms 1 /classes/ImageType.php:145
730 
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` = 1)
WHERE i.`id_product` = 1974
ORDER BY `position`
 0.997 ms 3 Yes /classes/Product.php:3545
779 
SELECT SQL_NO_CACHE `id_wishlist`
FROM `ps_an_wishlist`
WHERE `id_customer` = 11151973
AND `is_guest` = 1
AND `id_shop` = 1 LIMIT 1
 0.997 ms 117 /modules/an_wishlist/classes/an_wish.php:76
366 
SELECT SQL_NO_CACHE `id_image_type`
FROM `ps_image_type`
WHERE `name` = 'home'
 0.991 ms 1 /classes/ImageType.php:145
213 
SELECT SQL_NO_CACHE b.*,bl.title,bl.title_link,bl.content,bl.image_link,bl.image
FROM `ps_ets_mm_block` b
LEFT JOIN `ps_ets_mm_block_lang` bl
ON b.id_block=bl.id_block AND bl.id_lang=1
WHERE 1  AND b.id_column=654 
ORDER BY b.sort_order asc,bl.title asc
 0.986 ms 1 Yes /modules/ets_megamenu/classes/MM_Block.php:615
96 
SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop`
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE `id_lang` = 1
AND c.`id_parent` = 1
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
 0.985 ms 35 Yes Yes /classes/Category.php:1151
788 
SELECT SQL_NO_CACHE hbl.html,hb.style,hbl.id_lang
FROM `ps_ets_hb_html_box` hb
LEFT JOIN `ps_ets_hb_html_box_lang` hbl 
ON (hb.`id_ets_hb_html_box` = hbl.`id_ets_hb_html_box` AND hbl.`id_lang` = 1)
JOIN `ps_ets_hb_html_box_position` hbp 
ON (hbp.`id_ets_hb_html_box` = hb.`id_ets_hb_html_box`)
WHERE hb.active = 1
AND hbp.`position` = 12
 0.979 ms 168 /modules/ets_htmlbox/classes/HBHtmlbox.php:255
450 
SELECT SQL_NO_CACHE `id_wishlist`
FROM `ps_an_wishlist`
WHERE `id_customer` = 11151973
AND `is_guest` = 1
AND `id_shop` = 1 LIMIT 1
 0.978 ms 117 /modules/an_wishlist/classes/an_wish.php:76
419 
SELECT SQL_NO_CACHE `id_image_type`
FROM `ps_image_type`
WHERE `name` = 'home'
 0.973 ms 1 /classes/ImageType.php:145
14 
SELECT SQL_NO_CACHE `id_lang`, IF(language_code = 'en-us', 0, LENGTH(language_code)) as found
FROM `ps_lang`
WHERE LEFT(`language_code`,2) = 'en'
ORDER BY found ASC LIMIT 1
 0.968 ms 5 Yes /classes/Language.php:1004
645 
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` = 3870) AND (b.`id_shop` = 1) LIMIT 1
 0.967 ms 1 /src/Adapter/EntityMapper.php:71
150 
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` = 3024) LIMIT 1
 0.964 ms 1 /src/Adapter/EntityMapper.php:71
5 
SELECT SQL_NO_CACHE *
FROM `ps_shop` a
WHERE (a.`id_shop` = 1) LIMIT 1
 0.963 ms 1 /src/Adapter/EntityMapper.php:71
22 
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module`as `mshop`
FROM `ps_module` m
LEFT JOIN `ps_module_shop` ms
ON m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 1
 0.954 ms 99 /classes/module/Module.php:346
795 
SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 19 AND `id_shop` = 1 LIMIT 1
 0.928 ms 1 /classes/module/Module.php:2137
729 
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 = 1974 LIMIT 1
 0.925 ms 1 /classes/Product.php:1106
154 
SELECT SQL_NO_CACHE 1 FROM `ps_cart_rule` WHERE ((date_to >= "2026-07-10 00:00:00" AND date_to <= "2026-07-10 23:59:59") OR (date_from >= "2026-07-10 00:00:00" AND date_from <= "2026-07-10 23:59:59") OR (date_from < "2026-07-10 00:00:00" AND date_to > "2026-07-10 23:59:59")) AND `id_customer` IN (0,0) LIMIT 1
 0.924 ms 54 /classes/CartRule.php:357
189 
SELECT SQL_NO_CACHE b.*,bl.title,bl.title_link,bl.content,bl.image_link,bl.image
FROM `ps_ets_mm_block` b
LEFT JOIN `ps_ets_mm_block_lang` bl
ON b.id_block=bl.id_block AND bl.id_lang=1
WHERE 1  AND b.id_column=654 
ORDER BY b.sort_order asc,bl.title asc
 0.921 ms 1 Yes /modules/ets_megamenu/classes/MM_Block.php:615
355 
SELECT SQL_NO_CACHE `id_image_type`
FROM `ps_image_type`
WHERE `name` = 'home'
 0.920 ms 1 /classes/ImageType.php:145
63 
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module`as `mshop`
FROM `ps_module` m
LEFT JOIN `ps_module_shop` ms
ON m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 1
 0.915 ms 99 /classes/module/Module.php:346
107 
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` = 3024
AND image_shop.`cover` = 1 LIMIT 1
 0.911 ms 3 /classes/Product.php:3570
303 
SELECT SQL_NO_CACHE `id_image_type`
FROM `ps_image_type`
WHERE `name` = 'home'
 0.907 ms 1 /classes/ImageType.php:145
285 
SELECT SQL_NO_CACHE b.*,bl.title,bl.title_link,bl.content,bl.image_link,bl.image
FROM `ps_ets_mm_block` b
LEFT JOIN `ps_ets_mm_block_lang` bl
ON b.id_block=bl.id_block AND bl.id_lang=1
WHERE 1  AND b.id_column=716 
ORDER BY b.sort_order asc,bl.title asc
 0.904 ms 1 Yes /modules/ets_megamenu/classes/MM_Block.php:615
160 
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "an_theme" LIMIT 1
 0.903 ms 1 /classes/module/Module.php:2664
513 
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 SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity
FROM `ps_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 1666 UNION SELECT 0 as first_level_quantity, SUM(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_cart` = 0 AND p.`id_product_item` = 1666 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 0.897 ms 0 /classes/Cart.php:1430
333 
SELECT SQL_NO_CACHE c.*, cl.name,cl.link_rewrite
FROM `ps_category` c
INNER JOIN `ps_category_shop` cs ON (c.id_category=cs.id_category AND cs.id_shop=1)
LEFT JOIN `ps_category_lang` cl ON c.id_category=cl.id_category AND cl.id_lang=1
LEFT JOIN `ps_category_group` cg ON c.`id_category` = cg.`id_category` 
WHERE c.active=1 
AND  c.id_category IN(228)
AND cg.`id_group` IN (1)
GROUP BY c.id_category ORDER BY cl.name ASC,c.id_category ASC
 0.897 ms 30 Yes /modules/ets_megamenu/classes/Ets_megamenu_defines.php:176
286 
SELECT SQL_NO_CACHE b.*,bl.title,bl.title_link,bl.content,bl.image_link,bl.image
FROM `ps_ets_mm_block` b
LEFT JOIN `ps_ets_mm_block_lang` bl
ON b.id_block=bl.id_block AND bl.id_lang=1
WHERE 1  AND b.id_column=720 
ORDER BY b.sort_order asc,bl.title asc
 0.896 ms 1 Yes /modules/ets_megamenu/classes/MM_Block.php:615
191 
SELECT SQL_NO_CACHE b.*,bl.title,bl.title_link,bl.content,bl.image_link,bl.image
FROM `ps_ets_mm_block` b
LEFT JOIN `ps_ets_mm_block_lang` bl
ON b.id_block=bl.id_block AND bl.id_lang=1
WHERE 1  AND b.id_column=656 
ORDER BY b.sort_order asc,bl.title asc
 0.895 ms 2 Yes /modules/ets_megamenu/classes/MM_Block.php:615
628 
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 SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity
FROM `ps_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 3029 UNION SELECT 0 as first_level_quantity, SUM(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_cart` = 0 AND p.`id_product_item` = 3029 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 0.893 ms 0 /classes/Cart.php:1430
1 
SELECT SQL_NO_CACHE gs.*, s.*, gs.name AS group_name, s.name AS shop_name, s.active, su.domain, su.domain_ssl, su.physical_uri, su.virtual_uri
FROM ps_shop_group gs
LEFT JOIN ps_shop s
ON s.id_shop_group = gs.id_shop_group
LEFT JOIN ps_shop_url su
ON s.id_shop = su.id_shop AND su.main = 1
WHERE s.deleted = 0
AND gs.deleted = 0
ORDER BY gs.name, s.name
 0.889 ms 30 Yes /classes/shop/Shop.php:715
221 
SELECT SQL_NO_CACHE b.*,bl.title,bl.title_link,bl.content,bl.image_link,bl.image
FROM `ps_ets_mm_block` b
LEFT JOIN `ps_ets_mm_block_lang` bl
ON b.id_block=bl.id_block AND bl.id_lang=1
WHERE 1  AND b.id_column=667 
ORDER BY b.sort_order asc,bl.title asc
 0.886 ms 1 Yes /modules/ets_megamenu/classes/MM_Block.php:615
534 
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
JOIN `ps_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `ps_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1)
JOIN `ps_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (2499) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
 0.884 ms 2 Yes Yes /classes/Product.php:4524
208 
SELECT SQL_NO_CACHE b.*,bl.title,bl.title_link,bl.content,bl.image_link,bl.image
FROM `ps_ets_mm_block` b
LEFT JOIN `ps_ets_mm_block_lang` bl
ON b.id_block=bl.id_block AND bl.id_lang=1
WHERE 1  AND b.id_column=650 
ORDER BY b.sort_order asc,bl.title asc
 0.880 ms 2 Yes /modules/ets_megamenu/classes/MM_Block.php:615
8 
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
 0.876 ms 1 /src/Adapter/EntityMapper.php:71
273 
SELECT SQL_NO_CACHE b.*,bl.title,bl.title_link,bl.content,bl.image_link,bl.image
FROM `ps_ets_mm_block` b
LEFT JOIN `ps_ets_mm_block_lang` bl
ON b.id_block=bl.id_block AND bl.id_lang=1
WHERE 1  AND b.id_column=703 
ORDER BY b.sort_order asc,bl.title asc
 0.875 ms 1 Yes /modules/ets_megamenu/classes/MM_Block.php:615
288 
SELECT SQL_NO_CACHE b.*,bl.title,bl.title_link,bl.content,bl.image_link,bl.image
FROM `ps_ets_mm_block` b
LEFT JOIN `ps_ets_mm_block_lang` bl
ON b.id_block=bl.id_block AND bl.id_lang=1
WHERE 1  AND b.id_column=718 
ORDER BY b.sort_order asc,bl.title asc
 0.875 ms 1 Yes /modules/ets_megamenu/classes/MM_Block.php:615
712 
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
JOIN `ps_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `ps_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1)
JOIN `ps_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (3748) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
 0.872 ms 2 Yes Yes /classes/Product.php:4524
743 
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
JOIN `ps_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `ps_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1)
JOIN `ps_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (3029) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
 0.862 ms 2 Yes Yes /classes/Product.php:4524
765 
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `ps_product_attribute`
WHERE `id_product` = 3870
 0.860 ms 1 /classes/Product.php:2902
265 
SELECT SQL_NO_CACHE b.*,bl.title,bl.title_link,bl.content,bl.image_link,bl.image
FROM `ps_ets_mm_block` b
LEFT JOIN `ps_ets_mm_block_lang` bl
ON b.id_block=bl.id_block AND bl.id_lang=1
WHERE 1  AND b.id_column=698 
ORDER BY b.sort_order asc,bl.title asc
 0.849 ms 2 Yes /modules/ets_megamenu/classes/MM_Block.php:615
190 
SELECT SQL_NO_CACHE b.*,bl.title,bl.title_link,bl.content,bl.image_link,bl.image
FROM `ps_ets_mm_block` b
LEFT JOIN `ps_ets_mm_block_lang` bl
ON b.id_block=bl.id_block AND bl.id_lang=1
WHERE 1  AND b.id_column=655 
ORDER BY b.sort_order asc,bl.title asc
 0.848 ms 3 Yes /modules/ets_megamenu/classes/MM_Block.php:615
410 
SELECT SQL_NO_CACHE `id_image_type`
FROM `ps_image_type`
WHERE `name` = 'home'
 0.840 ms 1 /classes/ImageType.php:145
319 
SELECT SQL_NO_CACHE `id_image_type`
FROM `ps_image_type`
WHERE `name` = 'home'
 0.839 ms 1 /classes/ImageType.php:145
796 
SELECT SQL_NO_CACHE lpsgdprc.`id_lpsgdpr_config`
FROM `ps_lpsgdpr_config` lpsgdprc
WHERE lpsgdprc.`id_shop` =1 LIMIT 1
 0.839 ms 5 /modules/lpsgdpr/classes/lpsgdprconfig.php:199
209 
SELECT SQL_NO_CACHE b.*,bl.title,bl.title_link,bl.content,bl.image_link,bl.image
FROM `ps_ets_mm_block` b
LEFT JOIN `ps_ets_mm_block_lang` bl
ON b.id_block=bl.id_block AND bl.id_lang=1
WHERE 1  AND b.id_column=651 
ORDER BY b.sort_order asc,bl.title asc
 0.838 ms 2 Yes /modules/ets_megamenu/classes/MM_Block.php:615
217 
SELECT SQL_NO_CACHE b.*,bl.title,bl.title_link,bl.content,bl.image_link,bl.image
FROM `ps_ets_mm_block` b
LEFT JOIN `ps_ets_mm_block_lang` bl
ON b.id_block=bl.id_block AND bl.id_lang=1
WHERE 1  AND b.id_column=663 
ORDER BY b.sort_order asc,bl.title asc
 0.833 ms 2 Yes /modules/ets_megamenu/classes/MM_Block.php:615
196 
SELECT SQL_NO_CACHE b.*,bl.title,bl.title_link,bl.content,bl.image_link,bl.image
FROM `ps_ets_mm_block` b
LEFT JOIN `ps_ets_mm_block_lang` bl
ON b.id_block=bl.id_block AND bl.id_lang=1
WHERE 1  AND b.id_column=659 
ORDER BY b.sort_order asc,bl.title asc
 0.830 ms 1 Yes /modules/ets_megamenu/classes/MM_Block.php:615
766 
SELECT SQL_NO_CACHE `name`
FROM `ps_manufacturer`
WHERE `id_manufacturer` = 34
AND `active` = 1 LIMIT 1
 0.828 ms 1 /classes/Manufacturer.php:316
135 
SELECT SQL_NO_CACHE lpsgdprc.`id_lpsgdpr_config`
FROM `ps_lpsgdpr_config` lpsgdprc
WHERE lpsgdprc.`id_shop` =1 LIMIT 1
 0.827 ms 5 /modules/lpsgdpr/classes/lpsgdprconfig.php:199
232 
SELECT SQL_NO_CACHE b.*,bl.title,bl.title_link,bl.content,bl.image_link,bl.image
FROM `ps_ets_mm_block` b
LEFT JOIN `ps_ets_mm_block_lang` bl
ON b.id_block=bl.id_block AND bl.id_lang=1
WHERE 1  AND b.id_column=737 
ORDER BY b.sort_order asc,bl.title asc
 0.822 ms 1 Yes /modules/ets_megamenu/classes/MM_Block.php:615
346 
SELECT SQL_NO_CACHE c.*, cl.name,cl.link_rewrite
FROM `ps_category` c
INNER JOIN `ps_category_shop` cs ON (c.id_category=cs.id_category AND cs.id_shop=1)
LEFT JOIN `ps_category_lang` cl ON c.id_category=cl.id_category AND cl.id_lang=1
LEFT JOIN `ps_category_group` cg ON c.`id_category` = cg.`id_category` 
WHERE c.active=1 
AND  c.id_category IN(228)
AND cg.`id_group` IN (1)
GROUP BY c.id_category ORDER BY cl.name ASC,c.id_category ASC
 0.816 ms 30 Yes /modules/ets_megamenu/classes/Ets_megamenu_defines.php:176
431 
SELECT SQL_NO_CACHE `id_image_type`
FROM `ps_image_type`
WHERE `name` = 'home'
 0.813 ms 1 /classes/ImageType.php:145
582 
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` = 3748) AND (b.`id_shop` = 1) LIMIT 1
 0.812 ms 1 /src/Adapter/EntityMapper.php:71
144 
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "ps_shoppingcart" LIMIT 1
 0.811 ms 1 /classes/module/Module.php:2664
629 
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position, fvl.id_feature_value
FROM ps_feature_product pf
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
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 = 3029
ORDER BY f.position ASC
 0.806 ms 1 Yes /classes/Product.php:6032
564 
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
JOIN `ps_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `ps_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1)
JOIN `ps_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (2506) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
 0.804 ms 2 Yes Yes /classes/Product.php:4524
322 
SELECT SQL_NO_CACHE `id_image_type`
FROM `ps_image_type`
WHERE `name` = 'home'
 0.803 ms 1 /classes/ImageType.php:145
358 
SELECT SQL_NO_CACHE c.*, cl.name,cl.link_rewrite
FROM `ps_category` c
INNER JOIN `ps_category_shop` cs ON (c.id_category =cs.id_category AND cs.id_shop=1)
LEFT JOIN `ps_category_lang` cl ON c.id_category=cl.id_category AND cl.id_lang=1
WHERE c.active=1 AND  c.id_parent=4037 AND c.id_category!=4037
GROUP BY c.id_category ORDER BY cl.name ASC,c.id_category ASC
 0.799 ms 98 Yes Yes /modules/ets_megamenu/classes/Ets_megamenu_defines.php:147
15 
SELECT SQL_NO_CACHE *
FROM `ps_lang` a
LEFT JOIN `ps_lang_shop` `c` ON a.`id_lang` = c.`id_lang` AND c.`id_shop` = 1
WHERE (a.`id_lang` = 2) LIMIT 1
 0.798 ms 1 /src/Adapter/EntityMapper.php:71
244 
SELECT SQL_NO_CACHE b.*,bl.title,bl.title_link,bl.content,bl.image_link,bl.image
FROM `ps_ets_mm_block` b
LEFT JOIN `ps_ets_mm_block_lang` bl
ON b.id_block=bl.id_block AND bl.id_lang=1
WHERE 1  AND b.id_column=728 
ORDER BY b.sort_order asc,bl.title asc
 0.798 ms 1 Yes /modules/ets_megamenu/classes/MM_Block.php:615
177 
SELECT SQL_NO_CACHE m.*,ml.title,ml.link,ml.bubble_text
FROM `ps_ets_mm_menu` m
INNER JOIN `ps_ets_mm_menu_shop` ms ON (m.id_menu =ms.id_menu AND ms.id_shop='1')            
LEFT JOIN `ps_ets_mm_menu_lang` ml
ON m.id_menu=ml.id_menu AND ml.id_lang=1
WHERE 1  AND m.enabled=1 
GROUP BY m.id_menu
ORDER BY m.sort_order asc,ml.title asc
 0.796 ms 69 Yes Yes /modules/ets_megamenu/classes/MM_Menu.php:498
376 
SELECT SQL_NO_CACHE `id_image_type`
FROM `ps_image_type`
WHERE `name` = 'home'
 0.794 ms 1 /classes/ImageType.php:145
95 
SELECT SQL_NO_CACHE c.*, cl.`id_lang`, cl.`name`, cl.`description`, cl.`additional_description`, cl.`link_rewrite`, cl.`meta_title`, cl.`meta_keywords`, cl.`meta_description`
FROM `ps_category` c
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND `id_lang` = 1  AND cl.id_shop = 1 )
LEFT JOIN `ps_category_group` cg ON (cg.`id_category` = c.`id_category`)
WHERE `id_parent` = 168
AND `active` = 1
AND cg.`id_group` =1
GROUP BY c.`id_category`
ORDER BY `level_depth` ASC, category_shop.`position` ASC
 0.793 ms 12 Yes Yes /classes/Category.php:924
220 
SELECT SQL_NO_CACHE b.*,bl.title,bl.title_link,bl.content,bl.image_link,bl.image
FROM `ps_ets_mm_block` b
LEFT JOIN `ps_ets_mm_block_lang` bl
ON b.id_block=bl.id_block AND bl.id_lang=1
WHERE 1  AND b.id_column=666 
ORDER BY b.sort_order asc,bl.title asc
 0.793 ms 1 Yes /modules/ets_megamenu/classes/MM_Block.php:615
571 
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` = 1)
WHERE i.`id_product` = 2506
ORDER BY `position`
 0.784 ms 1 Yes /classes/Product.php:3545
60 
SELECT SQL_NO_CACHE `name` FROM `ps_supplier` WHERE `id_supplier` = 0 LIMIT 1
 0.782 ms 0 /classes/Supplier.php:243
20 
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module`as `mshop`
FROM `ps_module` m
LEFT JOIN `ps_module_shop` ms
ON m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 1
 0.781 ms 99 /classes/module/Module.php:346
672 
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` = 3415) AND (b.`id_shop` = 1) LIMIT 1
 0.780 ms 1 /src/Adapter/EntityMapper.php:71
812 
SELECT SQL_NO_CACHE `id_guest`
FROM `ps_connections`
WHERE `id_guest` = 6088128
AND `date_add` > '2026-07-10 15:48:00'
AND id_shop IN (1) 
ORDER BY `date_add` DESC LIMIT 1
 0.780 ms 1 Yes /classes/Connection.php:168
284 
SELECT SQL_NO_CACHE b.*,bl.title,bl.title_link,bl.content,bl.image_link,bl.image
FROM `ps_ets_mm_block` b
LEFT JOIN `ps_ets_mm_block_lang` bl
ON b.id_block=bl.id_block AND bl.id_lang=1
WHERE 1  AND b.id_column=715 
ORDER BY b.sort_order asc,bl.title asc
 0.779 ms 1 Yes /modules/ets_megamenu/classes/MM_Block.php:615
151 
SELECT SQL_NO_CACHE *
FROM `ps_product_lang`
WHERE `id_product` = 3024 AND `id_shop` = 1
 0.779 ms 5 /src/Adapter/EntityMapper.php:79
276 
SELECT SQL_NO_CACHE b.*,bl.title,bl.title_link,bl.content,bl.image_link,bl.image
FROM `ps_ets_mm_block` b
LEFT JOIN `ps_ets_mm_block_lang` bl
ON b.id_block=bl.id_block AND bl.id_lang=1
WHERE 1  AND b.id_column=708 
ORDER BY b.sort_order asc,bl.title asc
 0.778 ms 1 Yes /modules/ets_megamenu/classes/MM_Block.php:615
748 
SELECT SQL_NO_CACHE COUNT(*)
FROM `ps_an_wishlist_products`
WHERE `id_product` = 3752 LIMIT 1
 0.778 ms 334 /modules/an_wishlist/classes/an_wish_products.php:124
604 
SELECT SQL_NO_CACHE *
FROM ps_product_attachment pa
LEFT JOIN ps_attachment a ON a.id_attachment = pa.id_attachment
LEFT JOIN ps_attachment_lang al ON (a.id_attachment = al.id_attachment AND al.id_lang = 1)
WHERE pa.id_product = 1974
 0.775 ms 1 /classes/Product.php:6063
253 
SELECT SQL_NO_CACHE b.*,bl.title,bl.title_link,bl.content,bl.image_link,bl.image
FROM `ps_ets_mm_block` b
LEFT JOIN `ps_ets_mm_block_lang` bl
ON b.id_block=bl.id_block AND bl.id_lang=1
WHERE 1  AND b.id_column=680 
ORDER BY b.sort_order asc,bl.title asc
 0.772 ms 1 Yes /modules/ets_megamenu/classes/MM_Block.php:615
354 
SELECT SQL_NO_CACHE c.*, cl.name,cl.link_rewrite
FROM `ps_category` c
INNER JOIN `ps_category_shop` cs ON (c.id_category =cs.id_category AND cs.id_shop=1)
LEFT JOIN `ps_category_lang` cl ON c.id_category=cl.id_category AND cl.id_lang=1
WHERE c.active=1 AND  c.id_parent=4038 AND c.id_category!=4038
GROUP BY c.id_category ORDER BY cl.name ASC,c.id_category ASC
 0.772 ms 98 Yes Yes /modules/ets_megamenu/classes/Ets_megamenu_defines.php:147
163 
SELECT SQL_NO_CACHE hbl.html,hb.style,hbl.id_lang
FROM `ps_ets_hb_html_box` hb
LEFT JOIN `ps_ets_hb_html_box_lang` hbl 
ON (hb.`id_ets_hb_html_box` = hbl.`id_ets_hb_html_box` AND hbl.`id_lang` = 1)
JOIN `ps_ets_hb_html_box_position` hbp 
ON (hbp.`id_ets_hb_html_box` = hb.`id_ets_hb_html_box`)
WHERE hb.active = 1
AND hbp.`position` = 1
 0.770 ms 168 /modules/ets_htmlbox/classes/HBHtmlbox.php:255
753 
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` = 1)
WHERE i.`id_product` = 3752
ORDER BY `position`
 0.768 ms 1 Yes /classes/Product.php:3545
357 
SELECT SQL_NO_CACHE c.*, cl.name,cl.link_rewrite
FROM `ps_category` c
INNER JOIN `ps_category_shop` cs ON (c.id_category =cs.id_category AND cs.id_shop=1)
LEFT JOIN `ps_category_lang` cl ON c.id_category=cl.id_category AND cl.id_lang=1
WHERE c.active=1 AND  c.id_parent=228 AND c.id_category!=228
GROUP BY c.id_category ORDER BY cl.name ASC,c.id_category ASC
 0.768 ms 343 Yes Yes /modules/ets_megamenu/classes/Ets_megamenu_defines.php:147
804 
SELECT SQL_NO_CACHE hbl.html,hb.style,hbl.id_lang
FROM `ps_ets_hb_html_box` hb
LEFT JOIN `ps_ets_hb_html_box_lang` hbl 
ON (hb.`id_ets_hb_html_box` = hbl.`id_ets_hb_html_box` AND hbl.`id_lang` = 1)
JOIN `ps_ets_hb_html_box_position` hbp 
ON (hbp.`id_ets_hb_html_box` = hb.`id_ets_hb_html_box`)
WHERE hb.active = 1
AND hbp.`position` = 25
 0.768 ms 168 /modules/ets_htmlbox/classes/HBHtmlbox.php:255
291 
SELECT SQL_NO_CACHE b.*,bl.title,bl.title_link,bl.content,bl.image_link,bl.image
FROM `ps_ets_mm_block` b
LEFT JOIN `ps_ets_mm_block_lang` bl
ON b.id_block=bl.id_block AND bl.id_lang=1
WHERE 1  AND b.id_column=721 
ORDER BY b.sort_order asc,bl.title asc
 0.767 ms 1 Yes /modules/ets_megamenu/classes/MM_Block.php:615
793 
SELECT SQL_NO_CACHE * FROM `ps_an_trust_badges_icons` sw
WHERE sw.`active`=1
AND sw.`icon_id` IN (
SELECT sa.`icon_id`
FROM `ps_an_trust_badges_icons_shop` sa
WHERE sa.id_shop IN (1)
)
 0.767 ms 8 /modules/an_trust_badges/classes/AnTrustBadgesIcons.php:84
386 
SELECT SQL_NO_CACHE `id_image_type`
FROM `ps_image_type`
WHERE `name` = 'home'
 0.764 ms 1 /classes/ImageType.php:145
756 
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
JOIN `ps_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `ps_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1)
JOIN `ps_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (3870) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
 0.763 ms 2 Yes Yes /classes/Product.php:4524
324 
SELECT SQL_NO_CACHE `id_image_type`
FROM `ps_image_type`
WHERE `name` = 'home'
 0.762 ms 1 /classes/ImageType.php:145
98 
SELECT SQL_NO_CACHE *,
( IF (`id_shop` = 1, 2, 0) +  IF (`id_country` = 8, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_group` = 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` = 3024 AND `id_customer` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2026-07-10 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2026-07-10 00:00:00' <= `to`)
ORDER BY `from_quantity` ASC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC
 0.760 ms 1 Yes /classes/SpecificPrice.php:656
561 
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` = 1)
WHERE i.`id_product` = 1666
ORDER BY `position`
 0.758 ms 5 Yes /classes/Product.php:3545
236 
SELECT SQL_NO_CACHE b.*,bl.title,bl.title_link,bl.content,bl.image_link,bl.image
FROM `ps_ets_mm_block` b
LEFT JOIN `ps_ets_mm_block_lang` bl
ON b.id_block=bl.id_block AND bl.id_lang=1
WHERE 1  AND b.id_column=739 
ORDER BY b.sort_order asc,bl.title asc
 0.757 ms 1 Yes /modules/ets_megamenu/classes/MM_Block.php:615
248 
SELECT SQL_NO_CACHE b.*,bl.title,bl.title_link,bl.content,bl.image_link,bl.image
FROM `ps_ets_mm_block` b
LEFT JOIN `ps_ets_mm_block_lang` bl
ON b.id_block=bl.id_block AND bl.id_lang=1
WHERE 1  AND b.id_column=690 
ORDER BY b.sort_order asc,bl.title asc
 0.749 ms 2 Yes /modules/ets_megamenu/classes/MM_Block.php:615
802 
SELECT SQL_NO_CACHE *
FROM `ps_cms` a
LEFT JOIN `ps_cms_lang` `b` ON a.`id_cms` = b.`id_cms` AND b.`id_lang` = 1
LEFT JOIN `ps_cms_shop` `c` ON a.`id_cms` = c.`id_cms` AND c.`id_shop` = 1
WHERE (a.`id_cms` = 9) AND (b.`id_shop` = 1) LIMIT 1
 0.749 ms 1 /src/Adapter/EntityMapper.php:71
110 
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position, fvl.id_feature_value
FROM ps_feature_product pf
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
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 = 3024
ORDER BY f.position ASC
 0.747 ms 1 Yes /classes/Product.php:6032
551 
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` = 1)
WHERE i.`id_product` = 2507
ORDER BY `position`
 0.747 ms 1 Yes /classes/Product.php:3545
458 
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "an_trust_badges" LIMIT 1
 0.746 ms 1 /classes/module/Module.php:2664
619 
SELECT SQL_NO_CACHE name FROM ps_category_lang WHERE id_shop = 1 AND id_lang = 1 AND id_category = 148 LIMIT 1
 0.746 ms 1 /classes/Product.php:5670
0 
SELECT SQL_NO_CACHE s.id_shop, CONCAT(su.physical_uri, su.virtual_uri) AS uri, su.domain, su.main
FROM ps_shop_url su
LEFT JOIN ps_shop s ON (s.id_shop = su.id_shop)
WHERE (su.domain = 'capteurdepuissance.fr' OR su.domain_ssl = 'capteurdepuissance.fr')
AND s.active = 1
AND s.deleted = 0
ORDER BY LENGTH(CONCAT(su.physical_uri, su.virtual_uri)) DESC
 0.745 ms 15 Yes /classes/shop/Shop.php:1364
696 
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 SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity
FROM `ps_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 3201 UNION SELECT 0 as first_level_quantity, SUM(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_cart` = 0 AND p.`id_product_item` = 3201 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 0.744 ms 0 /classes/Cart.php:1430
235 
SELECT SQL_NO_CACHE b.*,bl.title,bl.title_link,bl.content,bl.image_link,bl.image
FROM `ps_ets_mm_block` b
LEFT JOIN `ps_ets_mm_block_lang` bl
ON b.id_block=bl.id_block AND bl.id_lang=1
WHERE 1  AND b.id_column=740 
ORDER BY b.sort_order asc,bl.title asc
 0.742 ms 3 Yes /modules/ets_megamenu/classes/MM_Block.php:615
487 
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` = 2507
AND image_shop.`cover` = 1 LIMIT 1
 0.741 ms 1 /classes/Product.php:3570
272 
SELECT SQL_NO_CACHE b.*,bl.title,bl.title_link,bl.content,bl.image_link,bl.image
FROM `ps_ets_mm_block` b
LEFT JOIN `ps_ets_mm_block_lang` bl
ON b.id_block=bl.id_block AND bl.id_lang=1
WHERE 1  AND b.id_column=705 
ORDER BY b.sort_order asc,bl.title asc
 0.739 ms 1 Yes /modules/ets_megamenu/classes/MM_Block.php:615
6 
SELECT SQL_NO_CACHE su.physical_uri, su.virtual_uri, su.domain, su.domain_ssl
FROM ps_shop s
LEFT JOIN ps_shop_url su ON (s.id_shop = su.id_shop)
WHERE s.id_shop = 1
AND s.active = 1 AND s.deleted = 0 AND su.main = 1 LIMIT 1
 0.738 ms 4 /classes/shop/Shop.php:218
23 
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module`as `mshop`
FROM `ps_module` m
LEFT JOIN `ps_module_shop` ms
ON m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 1
 0.738 ms 99 /classes/module/Module.php:346
121 
SELECT SQL_NO_CACHE *
FROM `ps_category` a0
LEFT JOIN `ps_category_lang` `a1` ON (a0.`id_category` = a1.`id_category`)
WHERE (a0.`nleft` < 97) AND (a0.`nright` > 122) AND (a1.`id_lang` = 1) AND (a1.`id_shop` = 1)
ORDER BY a0.`nleft` asc
 0.736 ms 49 /classes/PrestaShopCollection.php:383
805 
SELECT SQL_NO_CACHE c.id_contact 
FROM `ps_ets_cfu_contact` c
INNER JOIN `ps_ets_cfu_contact_shop` cs ON (c.id_contact= cs.id_contact)
LEFT JOIN `ps_ets_cfu_contact_lang` cl on (c.id_contact= cl.id_contact AND cl.id_lang="1")
WHERE c.active=1 
AND c.button_popup_enabled = 1 
AND cs.id_shop="1"
 0.735 ms 360 /modules/ets_cfultimate/classes/ETS_CFU_Contact.php:382
260 
SELECT SQL_NO_CACHE b.*,bl.title,bl.title_link,bl.content,bl.image_link,bl.image
FROM `ps_ets_mm_block` b
LEFT JOIN `ps_ets_mm_block_lang` bl
ON b.id_block=bl.id_block AND bl.id_lang=1
WHERE 1  AND b.id_column=687 
ORDER BY b.sort_order asc,bl.title asc
 0.729 ms 1 Yes /modules/ets_megamenu/classes/MM_Block.php:615
594 
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` = 1974) AND (b.`id_shop` = 1) LIMIT 1
 0.729 ms 1 /src/Adapter/EntityMapper.php:71
278 
SELECT SQL_NO_CACHE b.*,bl.title,bl.title_link,bl.content,bl.image_link,bl.image
FROM `ps_ets_mm_block` b
LEFT JOIN `ps_ets_mm_block_lang` bl
ON b.id_block=bl.id_block AND bl.id_lang=1
WHERE 1  AND b.id_column=710 
ORDER BY b.sort_order asc,bl.title asc
 0.725 ms 1 Yes /modules/ets_megamenu/classes/MM_Block.php:615
601 
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 1974) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
 0.725 ms 1 /classes/stock/StockAvailable.php:453
3 
SELECT SQL_NO_CACHE value FROM `ps_configuration` WHERE `name` = "PS_MULTISHOP_FEATURE_ACTIVE" LIMIT 1
 0.723 ms 2 /classes/shop/Shop.php:1183
227 
SELECT SQL_NO_CACHE b.*,bl.title,bl.title_link,bl.content,bl.image_link,bl.image
FROM `ps_ets_mm_block` b
LEFT JOIN `ps_ets_mm_block_lang` bl
ON b.id_block=bl.id_block AND bl.id_lang=1
WHERE 1  AND b.id_column=673 
ORDER BY b.sort_order asc,bl.title asc
 0.722 ms 1 Yes /modules/ets_megamenu/classes/MM_Block.php:615
301 
SELECT SQL_NO_CACHE `id_image_type`
FROM `ps_image_type`
WHERE `name` = 'home'
 0.719 ms 1 /classes/ImageType.php:145
467 
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` = 1)
WHERE i.`id_product` = 3024
ORDER BY `position`
 0.713 ms 3 Yes /classes/Product.php:3545
689 
SELECT SQL_NO_CACHE *, ( IF (`id_shop` = 1, 2, 0) +  IF (`id_country` = 21, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_group` = 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, 21) AND
`id_group` IN (0, 1) AND `id_product` = 3201 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2026-07-10 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2026-07-10 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
 0.712 ms 1 Yes /classes/SpecificPrice.php:576
250 
SELECT SQL_NO_CACHE b.*,bl.title,bl.title_link,bl.content,bl.image_link,bl.image
FROM `ps_ets_mm_block` b
LEFT JOIN `ps_ets_mm_block_lang` bl
ON b.id_block=bl.id_block AND bl.id_lang=1
WHERE 1  AND b.id_column=691 
ORDER BY b.sort_order asc,bl.title asc
 0.711 ms 3 Yes /modules/ets_megamenu/classes/MM_Block.php:615
608 
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` = 3328) AND (b.`id_shop` = 1) LIMIT 1
 0.710 ms 1 /src/Adapter/EntityMapper.php:71
738 
SELECT SQL_NO_CACHE location
FROM `ps_stock_available`
WHERE (id_product = 3328) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
 0.709 ms 1 /classes/stock/StockAvailable.php:806
58 
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` = 3024) AND (b.`id_shop` = 1) LIMIT 1
 0.709 ms 1 /src/Adapter/EntityMapper.php:71
277 
SELECT SQL_NO_CACHE b.*,bl.title,bl.title_link,bl.content,bl.image_link,bl.image
FROM `ps_ets_mm_block` b
LEFT JOIN `ps_ets_mm_block_lang` bl
ON b.id_block=bl.id_block AND bl.id_lang=1
WHERE 1  AND b.id_column=709 
ORDER BY b.sort_order asc,bl.title asc
 0.707 ms 1 Yes /modules/ets_megamenu/classes/MM_Block.php:615
252 
SELECT SQL_NO_CACHE b.*,bl.title,bl.title_link,bl.content,bl.image_link,bl.image
FROM `ps_ets_mm_block` b
LEFT JOIN `ps_ets_mm_block_lang` bl
ON b.id_block=bl.id_block AND bl.id_lang=1
WHERE 1  AND b.id_column=679 
ORDER BY b.sort_order asc,bl.title asc
 0.705 ms 1 Yes /modules/ets_megamenu/classes/MM_Block.php:615
490 
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` = 2507) AND (b.`id_shop` = 1) LIMIT 1
 0.705 ms 1 /src/Adapter/EntityMapper.php:71
271 
SELECT SQL_NO_CACHE b.*,bl.title,bl.title_link,bl.content,bl.image_link,bl.image
FROM `ps_ets_mm_block` b
LEFT JOIN `ps_ets_mm_block_lang` bl
ON b.id_block=bl.id_block AND bl.id_lang=1
WHERE 1  AND b.id_column=704 
ORDER BY b.sort_order asc,bl.title asc
 0.704 ms 1 Yes /modules/ets_megamenu/classes/MM_Block.php:615
485 
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 SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity
FROM `ps_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 2499 UNION SELECT 0 as first_level_quantity, SUM(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_cart` = 0 AND p.`id_product_item` = 2499 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 0.703 ms 0 /classes/Cart.php:1430
194 
SELECT SQL_NO_CACHE *
FROM `ps_ets_mm_tab` t
LEFT JOIN `ps_ets_mm_tab_lang` tl on (t.id_tab=tl.id_tab AND tl.id_lang=1)
WHERE 1  AND id_menu=57
ORDER BY sort_order asc
 0.703 ms 5 Yes /modules/ets_megamenu/classes/MM_Tab.php:309
580 
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` = 3748
AND image_shop.`cover` = 1 LIMIT 1
 0.702 ms 1 /classes/Product.php:3570
349 
SELECT SQL_NO_CACHE c.*, cl.name,cl.link_rewrite
FROM `ps_category` c
INNER JOIN `ps_category_shop` cs ON (c.id_category =cs.id_category AND cs.id_shop=1)
LEFT JOIN `ps_category_lang` cl ON c.id_category=cl.id_category AND cl.id_lang=1
WHERE c.active=1 AND  c.id_parent=4038 AND c.id_category!=4038
GROUP BY c.id_category ORDER BY cl.name ASC,c.id_category ASC
 0.701 ms 98 Yes Yes /modules/ets_megamenu/classes/Ets_megamenu_defines.php:147
280 
SELECT SQL_NO_CACHE b.*,bl.title,bl.title_link,bl.content,bl.image_link,bl.image
FROM `ps_ets_mm_block` b
LEFT JOIN `ps_ets_mm_block_lang` bl
ON b.id_block=bl.id_block AND bl.id_lang=1
WHERE 1  AND b.id_column=711 
ORDER BY b.sort_order asc,bl.title asc
 0.700 ms 2 Yes /modules/ets_megamenu/classes/MM_Block.php:615
605 
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` = 3328
AND image_shop.`cover` = 1 LIMIT 1
 0.696 ms 1 /classes/Product.php:3570
813 
SELECT SQL_NO_CACHE id_page_type
FROM ps_page_type
WHERE name = 'product' LIMIT 1
 0.692 ms 1 /classes/Page.php:104
225 
SELECT SQL_NO_CACHE b.*,bl.title,bl.title_link,bl.content,bl.image_link,bl.image
FROM `ps_ets_mm_block` b
LEFT JOIN `ps_ets_mm_block_lang` bl
ON b.id_block=bl.id_block AND bl.id_lang=1
WHERE 1  AND b.id_column=671 
ORDER BY b.sort_order asc,bl.title asc
 0.690 ms 1 Yes /modules/ets_megamenu/classes/MM_Block.php:615
274 
SELECT SQL_NO_CACHE b.*,bl.title,bl.title_link,bl.content,bl.image_link,bl.image
FROM `ps_ets_mm_block` b
LEFT JOIN `ps_ets_mm_block_lang` bl
ON b.id_block=bl.id_block AND bl.id_lang=1
WHERE 1  AND b.id_column=706 
ORDER BY b.sort_order asc,bl.title asc
 0.688 ms 1 Yes /modules/ets_megamenu/classes/MM_Block.php:615
499 
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position, fvl.id_feature_value
FROM ps_feature_product pf
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
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 = 2507
ORDER BY f.position ASC
 0.687 ms 1 Yes /classes/Product.php:6032
735 
SELECT SQL_NO_CACHE COUNT(*)
FROM `ps_an_wishlist_products`
WHERE `id_product` = 3328 LIMIT 1
 0.686 ms 334 /modules/an_wishlist/classes/an_wish_products.php:124
89 
SELECT SQL_NO_CACHE COUNT(*) FROM `ps_pack` WHERE id_product_pack = 3024 LIMIT 1
 0.685 ms 1 /classes/Pack.php:89
182 
SELECT SQL_NO_CACHE b.*,bl.title,bl.title_link,bl.content,bl.image_link,bl.image
FROM `ps_ets_mm_block` b
LEFT JOIN `ps_ets_mm_block_lang` bl
ON b.id_block=bl.id_block AND bl.id_lang=1
WHERE 1  AND b.id_column=647 
ORDER BY b.sort_order asc,bl.title asc
 0.677 ms 5 Yes /modules/ets_megamenu/classes/MM_Block.php:615
584 
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` = 3748)
 0.675 ms 1 /classes/Product.php:3860
223 
SELECT SQL_NO_CACHE b.*,bl.title,bl.title_link,bl.content,bl.image_link,bl.image
FROM `ps_ets_mm_block` b
LEFT JOIN `ps_ets_mm_block_lang` bl
ON b.id_block=bl.id_block AND bl.id_lang=1
WHERE 1  AND b.id_column=669 
ORDER BY b.sort_order asc,bl.title asc
 0.674 ms 1 Yes /modules/ets_megamenu/classes/MM_Block.php:615
506 
SELECT SQL_NO_CACHE *, ( IF (`id_shop` = 1, 2, 0) +  IF (`id_country` = 21, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_group` = 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, 21) AND
`id_group` IN (0, 1) AND `id_product` = 1666 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2026-07-10 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2026-07-10 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
 0.674 ms 5 Yes /classes/SpecificPrice.php:576
446 
SELECT SQL_NO_CACHE `id_image_type`
FROM `ps_image_type`
WHERE `name` = 'home'
 0.673 ms 1 /classes/ImageType.php:145
776 
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `ps_product_attribute`
WHERE `id_product` = 1884
 0.673 ms 1 /classes/Product.php:2902
299 
SELECT SQL_NO_CACHE `id_image_type`
FROM `ps_image_type`
WHERE `name` = 'home'
 0.670 ms 1 /classes/ImageType.php:145
620 
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` = 3029) AND (b.`id_shop` = 1) LIMIT 1
 0.669 ms 1 /src/Adapter/EntityMapper.php:71
123 
SELECT SQL_NO_CACHE hbl.html,hb.style,hbl.id_lang
FROM `ps_ets_hb_html_box` hb
LEFT JOIN `ps_ets_hb_html_box_lang` hbl 
ON (hb.`id_ets_hb_html_box` = hbl.`id_ets_hb_html_box` AND hbl.`id_lang` = 1)
JOIN `ps_ets_hb_html_box_position` hbp 
ON (hbp.`id_ets_hb_html_box` = hb.`id_ets_hb_html_box`)
WHERE hb.active = 1
AND hbp.`position` = 19
 0.667 ms 168 /modules/ets_htmlbox/classes/HBHtmlbox.php:255
139 
SELECT SQL_NO_CACHE lpsgdprc.`id_lpsgdpr_config`
FROM `ps_lpsgdpr_config` lpsgdprc
WHERE lpsgdprc.`id_shop` =1 LIMIT 1
 0.664 ms 5 /modules/lpsgdpr/classes/lpsgdprconfig.php:199
40 
SELECT SQL_NO_CACHE *
FROM `ps_currency` a
LEFT JOIN `ps_currency_lang` `b` ON a.`id_currency` = b.`id_currency` AND b.`id_lang` = 1
LEFT JOIN `ps_currency_shop` `c` ON a.`id_currency` = c.`id_currency` AND c.`id_shop` = 1
WHERE (a.`id_currency` = 1) LIMIT 1
 0.662 ms 1 /src/Adapter/EntityMapper.php:71
297 
SELECT SQL_NO_CACHE b.*,bl.title,bl.title_link,bl.content,bl.image_link,bl.image
FROM `ps_ets_mm_block` b
LEFT JOIN `ps_ets_mm_block_lang` bl
ON b.id_block=bl.id_block AND bl.id_lang=1
WHERE 1  AND b.id_column=694 
ORDER BY b.sort_order asc,bl.title asc
 0.662 ms 1 Yes /modules/ets_megamenu/classes/MM_Block.php:615
79 
SELECT SQL_NO_CACHE t.`id_lang`, t.`name`
FROM ps_tag t
LEFT JOIN ps_product_tag pt ON (pt.id_tag = t.id_tag)
WHERE pt.`id_product`=3024
 0.659 ms 6 /classes/Tag.php:244
751 
SELECT SQL_NO_CACHE location
FROM `ps_stock_available`
WHERE (id_product = 3752) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
 0.659 ms 1 /classes/stock/StockAvailable.php:806
140 
SELECT SQL_NO_CACHE *
FROM `ps_cms` a
LEFT JOIN `ps_cms_shop` `c` ON a.`id_cms` = c.`id_cms` AND c.`id_shop` = 1
WHERE (a.`id_cms` = 2) LIMIT 1
 0.657 ms 1 /src/Adapter/EntityMapper.php:71
371 
SELECT SQL_NO_CACHE `id_image_type`
FROM `ps_image_type`
WHERE `name` = 'home'
 0.654 ms 1 /classes/ImageType.php:145
10 
SELECT SQL_NO_CACHE *
FROM `ps_lang` a
LEFT JOIN `ps_lang_shop` `c` ON a.`id_lang` = c.`id_lang` AND c.`id_shop` = 1
WHERE (a.`id_lang` = 1) LIMIT 1
 0.653 ms 1 /src/Adapter/EntityMapper.php:71
122 
SELECT SQL_NO_CACHE hbl.html,hb.style,hbl.id_lang
FROM `ps_ets_hb_html_box` hb
LEFT JOIN `ps_ets_hb_html_box_lang` hbl 
ON (hb.`id_ets_hb_html_box` = hbl.`id_ets_hb_html_box` AND hbl.`id_lang` = 1)
JOIN `ps_ets_hb_html_box_position` hbp 
ON (hbp.`id_ets_hb_html_box` = hb.`id_ets_hb_html_box`)
WHERE hb.active = 1
AND hbp.`position` = 18
 0.652 ms 168 /modules/ets_htmlbox/classes/HBHtmlbox.php:255
188 
SELECT SQL_NO_CACHE b.*,bl.title,bl.title_link,bl.content,bl.image_link,bl.image
FROM `ps_ets_mm_block` b
LEFT JOIN `ps_ets_mm_block_lang` bl
ON b.id_block=bl.id_block AND bl.id_lang=1
WHERE 1  AND b.id_column=653 
ORDER BY b.sort_order asc,bl.title asc
 0.650 ms 3 Yes /modules/ets_megamenu/classes/MM_Block.php:615
543 
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `ps_product_attribute`
WHERE `id_product` = 2499
 0.650 ms 1 /classes/Product.php:2902
700 
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` = 1)
WHERE i.`id_product` = 3748
ORDER BY `position`
 0.649 ms 1 Yes /classes/Product.php:3545
789 
SELECT SQL_NO_CACHE np.`id_prestablog_news`
FROM `ps_prestablog_news_product` np
LEFT JOIN `ps_prestablog_news` n
ON (np.`id_prestablog_news` = n.`id_prestablog_news`)
WHERE np.`id_product` = 3024
AND np.`id_shop` = 1
ORDER BY n.`date` DESC
 0.649 ms 1 Yes /modules/prestablog/class/news.php:293
798 
SELECT SQL_NO_CACHE `id_module`, `name` FROM `ps_module`
 0.649 ms 99 /classes/module/Module.php:1281
374 
SELECT SQL_NO_CACHE `id_image_type`
FROM `ps_image_type`
WHERE `name` = 'home'
 0.648 ms 1 /classes/ImageType.php:145
669 
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` = 3415
AND image_shop.`cover` = 1 LIMIT 1
 0.647 ms 6 /classes/Product.php:3570
99 
SELECT SQL_NO_CACHE DISTINCT a.`id_attribute`, a.`id_attribute_group`, al.`name` as `attribute`, agl.`name` as `group`,pa.`reference`, pa.`ean13`, pa.`isbn`, pa.`upc`, pa.`mpn`
FROM `ps_attribute` a
LEFT JOIN `ps_attribute_lang` al
ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1)
LEFT JOIN `ps_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
LEFT JOIN `ps_product_attribute_combination` pac
ON (a.`id_attribute` = pac.`id_attribute`)
LEFT JOIN `ps_product_attribute` pa
ON (pac.`id_product_attribute` = pa.`id_product_attribute`)
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
INNER JOIN ps_attribute_shop attribute_shop
ON (attribute_shop.id_attribute = pac.id_attribute AND attribute_shop.id_shop = 1)
WHERE pa.`id_product` = 3024
 0.647 ms 2 /classes/Product.php:7575
12 
SELECT SQL_NO_CACHE domain, domain_ssl
FROM ps_shop_url
WHERE main = 1
AND id_shop = 1 LIMIT 1
 0.646 ms 4 /classes/shop/ShopUrl.php:182
569 
SELECT SQL_NO_CACHE location
FROM `ps_stock_available`
WHERE (id_product = 2506) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
 0.644 ms 1 /classes/stock/StockAvailable.php:806
246 
SELECT SQL_NO_CACHE b.*,bl.title,bl.title_link,bl.content,bl.image_link,bl.image
FROM `ps_ets_mm_block` b
LEFT JOIN `ps_ets_mm_block_lang` bl
ON b.id_block=bl.id_block AND bl.id_lang=1
WHERE 1  AND b.id_column=731 
ORDER BY b.sort_order asc,bl.title asc
 0.643 ms 1 Yes /modules/ets_megamenu/classes/MM_Block.php:615
531 
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `ps_product_attribute`
WHERE `id_product` = 1666
 0.643 ms 1 /classes/Product.php:2902
641 
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position, fvl.id_feature_value
FROM ps_feature_product pf
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
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 = 3752
ORDER BY f.position ASC
 0.640 ms 1 Yes /classes/Product.php:6032
437 
SELECT SQL_NO_CACHE `id_image_type`
FROM `ps_image_type`
WHERE `name` = 'home'
 0.638 ms 1 /classes/ImageType.php:145
199 
SELECT SQL_NO_CACHE *
FROM `ps_ets_mm_column`
WHERE 1  AND id_tab=49
ORDER BY sort_order asc
 0.636 ms 3 Yes /modules/ets_megamenu/classes/MM_Column.php:139
581 
SELECT SQL_NO_CACHE name FROM ps_category_lang WHERE id_shop = 1 AND id_lang = 1 AND id_category = 168 LIMIT 1
 0.636 ms 1 /classes/Product.php:5670
281 
SELECT SQL_NO_CACHE b.*,bl.title,bl.title_link,bl.content,bl.image_link,bl.image
FROM `ps_ets_mm_block` b
LEFT JOIN `ps_ets_mm_block_lang` bl
ON b.id_block=bl.id_block AND bl.id_lang=1
WHERE 1  AND b.id_column=712 
ORDER BY b.sort_order asc,bl.title asc
 0.636 ms 2 Yes /modules/ets_megamenu/classes/MM_Block.php:615
326 
SELECT SQL_NO_CACHE `id_image_type`
FROM `ps_image_type`
WHERE `name` = 'home'
 0.635 ms 1 /classes/ImageType.php:145
111 
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` = 1)
WHERE i.`id_product` = 3024
ORDER BY `position`
 0.634 ms 3 Yes /classes/Product.php:3545
337 
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` = 1
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 4037) AND (b.`id_shop` = 1) LIMIT 1
 0.633 ms 1 /src/Adapter/EntityMapper.php:71
819 
SELECT SQL_NO_CACHE `id_prestablog_popup`
FROM `ps_prestablog_popup`
WHERE `actif_home` = 1
 0.632 ms 1 /modules/prestablog/class/popup.php:389
64 
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` = 12
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
 0.631 ms 1 Yes /override/classes/tax/TaxRulesTaxManager.php:109
616 
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 SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity
FROM `ps_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 3328 UNION SELECT 0 as first_level_quantity, SUM(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_cart` = 0 AND p.`id_product_item` = 3328 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 0.631 ms 0 /classes/Cart.php:1430
32 
SELECT SQL_NO_CACHE lpsgdprc.`id_lpsgdpr_config`
FROM `ps_lpsgdpr_config` lpsgdprc
WHERE lpsgdprc.`id_shop` =1 LIMIT 1
 0.630 ms 5 /modules/lpsgdpr/classes/lpsgdprconfig.php:199
545 
SELECT SQL_NO_CACHE `id_wishlist`
FROM `ps_an_wishlist`
WHERE `id_customer` = 11151973
AND `is_guest` = 1
AND `id_shop` = 1 LIMIT 1
 0.629 ms 117 /modules/an_wishlist/classes/an_wish.php:76
517 
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` = 2506) AND (b.`id_shop` = 1) LIMIT 1
 0.628 ms 1 /src/Adapter/EntityMapper.php:71
525 
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 SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity
FROM `ps_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 2506 UNION SELECT 0 as first_level_quantity, SUM(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_cart` = 0 AND p.`id_product_item` = 2506 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 0.628 ms 0 /classes/Cart.php:1430
137 
SELECT SQL_NO_CACHE lpsgdprc.`id_lpsgdpr_config`
FROM `ps_lpsgdpr_config` lpsgdprc
WHERE lpsgdprc.`id_shop` =1 LIMIT 1
 0.627 ms 5 /modules/lpsgdpr/classes/lpsgdprconfig.php:199
183 
SELECT SQL_NO_CACHE b.*,bl.title,bl.title_link,bl.content,bl.image_link,bl.image
FROM `ps_ets_mm_block` b
LEFT JOIN `ps_ets_mm_block_lang` bl
ON b.id_block=bl.id_block AND bl.id_lang=1
WHERE 1  AND b.id_column=648 
ORDER BY b.sort_order asc,bl.title asc
 0.626 ms 5 Yes /modules/ets_megamenu/classes/MM_Block.php:615
239 
SELECT SQL_NO_CACHE b.*,bl.title,bl.title_link,bl.content,bl.image_link,bl.image
FROM `ps_ets_mm_block` b
LEFT JOIN `ps_ets_mm_block_lang` bl
ON b.id_block=bl.id_block AND bl.id_lang=1
WHERE 1  AND b.id_column=732 
ORDER BY b.sort_order asc,bl.title asc
 0.624 ms 1 Yes /modules/ets_megamenu/classes/MM_Block.php:615
289 
SELECT SQL_NO_CACHE b.*,bl.title,bl.title_link,bl.content,bl.image_link,bl.image
FROM `ps_ets_mm_block` b
LEFT JOIN `ps_ets_mm_block_lang` bl
ON b.id_block=bl.id_block AND bl.id_lang=1
WHERE 1  AND b.id_column=719 
ORDER BY b.sort_order asc,bl.title asc
 0.624 ms 1 Yes /modules/ets_megamenu/classes/MM_Block.php:615
477 
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` = 2499) AND (b.`id_shop` = 1) LIMIT 1
 0.621 ms 1 /src/Adapter/EntityMapper.php:71
590 
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 SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity
FROM `ps_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 3748 UNION SELECT 0 as first_level_quantity, SUM(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_cart` = 0 AND p.`id_product_item` = 3748 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 0.621 ms 0 /classes/Cart.php:1430
716 
SELECT SQL_NO_CACHE depends_on_stock
FROM `ps_stock_available`
WHERE (id_product = 3748) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
 0.619 ms 1 /classes/stock/StockAvailable.php:753
70 
SELECT SQL_NO_CACHE DISTINCT `id_product` FROM `ps_specific_price` WHERE `id_product` != 0
 0.617 ms 505 /classes/SpecificPrice.php:310
451 
SELECT SQL_NO_CACHE COUNT(*)
FROM `ps_an_wishlist_products`
WHERE `id_product` = 3024 LIMIT 1
 0.617 ms 334 /modules/an_wishlist/classes/an_wish_products.php:124
653 
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 SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity
FROM `ps_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 3870 UNION SELECT 0 as first_level_quantity, SUM(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_cart` = 0 AND p.`id_product_item` = 3870 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 0.617 ms 0 /classes/Cart.php:1430
723 
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
JOIN `ps_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `ps_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1)
JOIN `ps_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (1974) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
 0.617 ms 2 Yes Yes /classes/Product.php:4524
261 
SELECT SQL_NO_CACHE b.*,bl.title,bl.title_link,bl.content,bl.image_link,bl.image
FROM `ps_ets_mm_block` b
LEFT JOIN `ps_ets_mm_block_lang` bl
ON b.id_block=bl.id_block AND bl.id_lang=1
WHERE 1  AND b.id_column=689 
ORDER BY b.sort_order asc,bl.title asc
 0.616 ms 1 Yes /modules/ets_megamenu/classes/MM_Block.php:615
359 
SELECT SQL_NO_CACHE c.*, cl.name,cl.link_rewrite
FROM `ps_category` c
INNER JOIN `ps_category_shop` cs ON (c.id_category =cs.id_category AND cs.id_shop=1)
LEFT JOIN `ps_category_lang` cl ON c.id_category=cl.id_category AND cl.id_lang=1
WHERE c.active=1 AND  c.id_parent=4038 AND c.id_category!=4038
GROUP BY c.id_category ORDER BY cl.name ASC,c.id_category ASC
 0.616 ms 98 Yes Yes /modules/ets_megamenu/classes/Ets_megamenu_defines.php:147
367 
SELECT SQL_NO_CACHE `id_image_type`
FROM `ps_image_type`
WHERE `name` = 'home'
 0.615 ms 1 /classes/ImageType.php:145
546 
SELECT SQL_NO_CACHE COUNT(*)
FROM `ps_an_wishlist_products`
WHERE `id_product` = 2507 LIMIT 1
 0.613 ms 334 /modules/an_wishlist/classes/an_wish_products.php:124
87 
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` = 3024 AND ctg.`id_group` = 1 LIMIT 1
 0.613 ms 1 /classes/Product.php:6751
192 
SELECT SQL_NO_CACHE b.*,bl.title,bl.title_link,bl.content,bl.image_link,bl.image
FROM `ps_ets_mm_block` b
LEFT JOIN `ps_ets_mm_block_lang` bl
ON b.id_block=bl.id_block AND bl.id_lang=1
WHERE 1  AND b.id_column=657 
ORDER BY b.sort_order asc,bl.title asc
 0.612 ms 2 Yes /modules/ets_megamenu/classes/MM_Block.php:615
315 
SELECT SQL_NO_CACHE `id_image_type`
FROM `ps_image_type`
WHERE `name` = 'home'
 0.611 ms 1 /classes/ImageType.php:145
373 
SELECT SQL_NO_CACHE `id_image_type`
FROM `ps_image_type`
WHERE `name` = 'home'
 0.611 ms 1 /classes/ImageType.php:145
530 
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` = 1)
WHERE i.`id_product` = 1666
ORDER BY `position`
 0.611 ms 5 Yes /classes/Product.php:3545
583 
SELECT SQL_NO_CACHE 1 FROM `ps_specific_price` WHERE id_product = 3748 LIMIT 1
 0.610 ms 1 /classes/SpecificPrice.php:435
474 
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` = 2499
AND image_shop.`cover` = 1 LIMIT 1
 0.610 ms 1 /classes/Product.php:3570
640 
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 SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity
FROM `ps_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 3752 UNION SELECT 0 as first_level_quantity, SUM(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_cart` = 0 AND p.`id_product_item` = 3752 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 0.609 ms 0 /classes/Cart.php:1430
304 
SELECT SQL_NO_CACHE `id_image_type`
FROM `ps_image_type`
WHERE `name` = 'home'
 0.608 ms 1 /classes/ImageType.php:145
203 
SELECT SQL_NO_CACHE *
FROM `ps_ets_mm_column`
WHERE 1  AND id_tab=46
ORDER BY sort_order asc
 0.605 ms 3 Yes /modules/ets_megamenu/classes/MM_Column.php:139
498 
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 SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity
FROM `ps_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 2507 UNION SELECT 0 as first_level_quantity, SUM(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_cart` = 0 AND p.`id_product_item` = 2507 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 0.603 ms 0 /classes/Cart.php:1430
409 
SELECT SQL_NO_CACHE `id_image_type`
FROM `ps_image_type`
WHERE `name` = 'home'
 0.602 ms 1 /classes/ImageType.php:145
710 
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `ps_product_attribute`
WHERE `id_product` = 3415
 0.602 ms 1 /classes/Product.php:2902
694 
SELECT SQL_NO_CACHE product_type FROM `ps_product` WHERE id_product = 3201 LIMIT 1
 0.602 ms 1 /classes/Pack.php:90
229 
SELECT SQL_NO_CACHE b.*,bl.title,bl.title_link,bl.content,bl.image_link,bl.image
FROM `ps_ets_mm_block` b
LEFT JOIN `ps_ets_mm_block_lang` bl
ON b.id_block=bl.id_block AND bl.id_lang=1
WHERE 1  AND b.id_column=676 
ORDER BY b.sort_order asc,bl.title asc
 0.601 ms 1 Yes /modules/ets_megamenu/classes/MM_Block.php:615
721 
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `ps_product_attribute`
WHERE `id_product` = 3748
 0.597 ms 1 /classes/Product.php:2902
433 
SELECT SQL_NO_CACHE `id_image_type`
FROM `ps_image_type`
WHERE `name` = 'home'
 0.596 ms 1 /classes/ImageType.php:145
228 
SELECT SQL_NO_CACHE b.*,bl.title,bl.title_link,bl.content,bl.image_link,bl.image
FROM `ps_ets_mm_block` b
LEFT JOIN `ps_ets_mm_block_lang` bl
ON b.id_block=bl.id_block AND bl.id_lang=1
WHERE 1  AND b.id_column=674 
ORDER BY b.sort_order asc,bl.title asc
 0.595 ms 1 Yes /modules/ets_megamenu/classes/MM_Block.php:615
752 
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 = 3752 LIMIT 1
 0.595 ms 1 /classes/Product.php:1106
242 
SELECT SQL_NO_CACHE b.*,bl.title,bl.title_link,bl.content,bl.image_link,bl.image
FROM `ps_ets_mm_block` b
LEFT JOIN `ps_ets_mm_block_lang` bl
ON b.id_block=bl.id_block AND bl.id_lang=1
WHERE 1  AND b.id_column=734 
ORDER BY b.sort_order asc,bl.title asc
 0.593 ms 1 Yes /modules/ets_megamenu/classes/MM_Block.php:615
591 
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position, fvl.id_feature_value
FROM ps_feature_product pf
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
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 = 3748
ORDER BY f.position ASC
 0.590 ms 1 Yes /classes/Product.php:6032
479 
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` = 2499)
 0.588 ms 1 /classes/Product.php:3860
347 
SELECT SQL_NO_CACHE c.*, cl.name,cl.link_rewrite
FROM `ps_category` c
INNER JOIN `ps_category_shop` cs ON (c.id_category =cs.id_category AND cs.id_shop=1)
LEFT JOIN `ps_category_lang` cl ON c.id_category=cl.id_category AND cl.id_lang=1
WHERE c.active=1 AND  c.id_parent=228 AND c.id_category!=228
GROUP BY c.id_category ORDER BY cl.name ASC,c.id_category ASC
 0.588 ms 343 Yes Yes /modules/ets_megamenu/classes/Ets_megamenu_defines.php:147
241 
SELECT SQL_NO_CACHE b.*,bl.title,bl.title_link,bl.content,bl.image_link,bl.image
FROM `ps_ets_mm_block` b
LEFT JOIN `ps_ets_mm_block_lang` bl
ON b.id_block=bl.id_block AND bl.id_lang=1
WHERE 1  AND b.id_column=730 
ORDER BY b.sort_order asc,bl.title asc
 0.587 ms 1 Yes /modules/ets_megamenu/classes/MM_Block.php:615
667 
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position, fvl.id_feature_value
FROM ps_feature_product pf
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
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 = 1884
ORDER BY f.position ASC
 0.584 ms 1 Yes /classes/Product.php:6032
680 
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 SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity
FROM `ps_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 3415 UNION SELECT 0 as first_level_quantity, SUM(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_cart` = 0 AND p.`id_product_item` = 3415 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 0.583 ms 0 /classes/Cart.php:1430
245 
SELECT SQL_NO_CACHE b.*,bl.title,bl.title_link,bl.content,bl.image_link,bl.image
FROM `ps_ets_mm_block` b
LEFT JOIN `ps_ets_mm_block_lang` bl
ON b.id_block=bl.id_block AND bl.id_lang=1
WHERE 1  AND b.id_column=735 
ORDER BY b.sort_order asc,bl.title asc
 0.580 ms 1 Yes /modules/ets_megamenu/classes/MM_Block.php:615
351 
SELECT SQL_NO_CACHE c.*, cl.name,cl.link_rewrite
FROM `ps_category` c
INNER JOIN `ps_category_shop` cs ON (c.id_category=cs.id_category AND cs.id_shop=1)
LEFT JOIN `ps_category_lang` cl ON c.id_category=cl.id_category AND cl.id_lang=1
LEFT JOIN `ps_category_group` cg ON c.`id_category` = cg.`id_category` 
WHERE c.active=1 
AND  c.id_category IN(228)
AND cg.`id_group` IN (1)
GROUP BY c.id_category ORDER BY cl.name ASC,c.id_category ASC
 0.579 ms 30 Yes /modules/ets_megamenu/classes/Ets_megamenu_defines.php:176
298 
SELECT SQL_NO_CACHE b.*,bl.title,bl.title_link,bl.content,bl.image_link,bl.image
FROM `ps_ets_mm_block` b
LEFT JOIN `ps_ets_mm_block_lang` bl
ON b.id_block=bl.id_block AND bl.id_lang=1
WHERE 1  AND b.id_column=695 
ORDER BY b.sort_order asc,bl.title asc
 0.579 ms 1 Yes /modules/ets_megamenu/classes/MM_Block.php:615
719 
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` = 1)
WHERE i.`id_product` = 3748
ORDER BY `position`
 0.579 ms 1 Yes /classes/Product.php:3545
554 
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
JOIN `ps_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `ps_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1)
JOIN `ps_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (1666) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
 0.578 ms 2 Yes Yes /classes/Product.php:4524
234 
SELECT SQL_NO_CACHE b.*,bl.title,bl.title_link,bl.content,bl.image_link,bl.image
FROM `ps_ets_mm_block` b
LEFT JOIN `ps_ets_mm_block_lang` bl
ON b.id_block=bl.id_block AND bl.id_lang=1
WHERE 1  AND b.id_column=738 
ORDER BY b.sort_order asc,bl.title asc
 0.577 ms 2 Yes /modules/ets_megamenu/classes/MM_Block.php:615
295 
SELECT SQL_NO_CACHE b.*,bl.title,bl.title_link,bl.content,bl.image_link,bl.image
FROM `ps_ets_mm_block` b
LEFT JOIN `ps_ets_mm_block_lang` bl
ON b.id_block=bl.id_block AND bl.id_lang=1
WHERE 1  AND b.id_column=692 
ORDER BY b.sort_order asc,bl.title asc
 0.576 ms 1 Yes /modules/ets_megamenu/classes/MM_Block.php:615
448 
SELECT SQL_NO_CACHE `id_image_type`
FROM `ps_image_type`
WHERE `name` = 'home'
 0.576 ms 1 /classes/ImageType.php:145
632 
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` = 3752) AND (b.`id_shop` = 1) LIMIT 1
 0.575 ms 1 /src/Adapter/EntityMapper.php:71
181 
SELECT SQL_NO_CACHE b.*,bl.title,bl.title_link,bl.content,bl.image_link,bl.image
FROM `ps_ets_mm_block` b
LEFT JOIN `ps_ets_mm_block_lang` bl
ON b.id_block=bl.id_block AND bl.id_lang=1
WHERE 1  AND b.id_column=661 
ORDER BY b.sort_order asc,bl.title asc
 0.574 ms 1 Yes /modules/ets_megamenu/classes/MM_Block.php:615
282 
SELECT SQL_NO_CACHE b.*,bl.title,bl.title_link,bl.content,bl.image_link,bl.image
FROM `ps_ets_mm_block` b
LEFT JOIN `ps_ets_mm_block_lang` bl
ON b.id_block=bl.id_block AND bl.id_lang=1
WHERE 1  AND b.id_column=713 
ORDER BY b.sort_order asc,bl.title asc
 0.573 ms 1 Yes /modules/ets_megamenu/classes/MM_Block.php:615
445 
SELECT SQL_NO_CACHE `id_image_type`
FROM `ps_image_type`
WHERE `name` = 'home'
 0.570 ms 1 /classes/ImageType.php:145
88 
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` = 1
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 168) AND (b.`id_shop` = 1) LIMIT 1
 0.569 ms 0 /src/Adapter/EntityMapper.php:71
708 
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `ps_product_attribute`
WHERE `id_product` = 1884
 0.568 ms 1 /classes/Product.php:2902
108 
SELECT SQL_NO_CACHE name FROM ps_category_lang WHERE id_shop = 1 AND id_lang = 1 AND id_category = 168 LIMIT 1
 0.564 ms 1 /classes/Product.php:5670
381 
SELECT SQL_NO_CACHE `id_image_type`
FROM `ps_image_type`
WHERE `name` = 'home'
 0.564 ms 1 /classes/ImageType.php:145
104 
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 SUM(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` = 3024 UNION SELECT 0 as first_level_quantity, SUM(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` = 3024 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 0.562 ms 0 /classes/Cart.php:1430
292 
SELECT SQL_NO_CACHE b.*,bl.title,bl.title_link,bl.content,bl.image_link,bl.image
FROM `ps_ets_mm_block` b
LEFT JOIN `ps_ets_mm_block_lang` bl
ON b.id_block=bl.id_block AND bl.id_lang=1
WHERE 1  AND b.id_column=722 
ORDER BY b.sort_order asc,bl.title asc
 0.562 ms 1 Yes /modules/ets_megamenu/classes/MM_Block.php:615
335 
SELECT SQL_NO_CACHE c.*, cl.name,cl.link_rewrite
FROM `ps_category` c
INNER JOIN `ps_category_shop` cs ON (c.id_category =cs.id_category AND cs.id_shop=1)
LEFT JOIN `ps_category_lang` cl ON c.id_category=cl.id_category AND cl.id_lang=1
WHERE c.active=1 AND  c.id_parent=4037 AND c.id_category!=4037
GROUP BY c.id_category ORDER BY cl.name ASC,c.id_category ASC
 0.562 ms 98 Yes Yes /modules/ets_megamenu/classes/Ets_megamenu_defines.php:147
219 
SELECT SQL_NO_CACHE b.*,bl.title,bl.title_link,bl.content,bl.image_link,bl.image
FROM `ps_ets_mm_block` b
LEFT JOIN `ps_ets_mm_block_lang` bl
ON b.id_block=bl.id_block AND bl.id_lang=1
WHERE 1  AND b.id_column=665 
ORDER BY b.sort_order asc,bl.title asc
 0.561 ms 1 Yes /modules/ets_megamenu/classes/MM_Block.php:615
230 
SELECT SQL_NO_CACHE b.*,bl.title,bl.title_link,bl.content,bl.image_link,bl.image
FROM `ps_ets_mm_block` b
LEFT JOIN `ps_ets_mm_block_lang` bl
ON b.id_block=bl.id_block AND bl.id_lang=1
WHERE 1  AND b.id_column=675 
ORDER BY b.sort_order asc,bl.title asc
 0.561 ms 1 Yes /modules/ets_megamenu/classes/MM_Block.php:615
175 
SELECT SQL_NO_CACHE `id_wishlist`
FROM `ps_an_wishlist`
WHERE `id_customer` = 11151973
AND `is_guest` = 1
AND `id_shop` = 1 LIMIT 1
 0.560 ms 117 /modules/an_wishlist/classes/an_wish.php:76
471 
SELECT SQL_NO_CACHE o.id_order
FROM ps_orders o
LEFT JOIN ps_order_detail od ON (od.id_order = o.id_order)
WHERE o.valid = 1
AND od.product_id IN (3024)
ORDER BY o.id_order DESC
LIMIT 400
 0.559 ms 3 Yes /modules/ps_crossselling/ps_crossselling.php:257
251 
SELECT SQL_NO_CACHE b.*,bl.title,bl.title_link,bl.content,bl.image_link,bl.image
FROM `ps_ets_mm_block` b
LEFT JOIN `ps_ets_mm_block_lang` bl
ON b.id_block=bl.id_block AND bl.id_lang=1
WHERE 1  AND b.id_column=678 
ORDER BY b.sort_order asc,bl.title asc
 0.557 ms 1 Yes /modules/ets_megamenu/classes/MM_Block.php:615
193 
SELECT SQL_NO_CACHE b.*,bl.title,bl.title_link,bl.content,bl.image_link,bl.image
FROM `ps_ets_mm_block` b
LEFT JOIN `ps_ets_mm_block_lang` bl
ON b.id_block=bl.id_block AND bl.id_lang=1
WHERE 1  AND b.id_column=658 
ORDER BY b.sort_order asc,bl.title asc
 0.557 ms 1 Yes /modules/ets_megamenu/classes/MM_Block.php:615
329 
SELECT SQL_NO_CACHE `id_image_type`
FROM `ps_image_type`
WHERE `name` = 'home'
 0.555 ms 1 /classes/ImageType.php:145
781 
SELECT SQL_NO_CACHE out_of_stock
FROM `ps_stock_available`
WHERE (id_product = 3415) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
 0.555 ms 1 /classes/stock/StockAvailable.php:778
185 
SELECT SQL_NO_CACHE b.*,bl.title,bl.title_link,bl.content,bl.image_link,bl.image
FROM `ps_ets_mm_block` b
LEFT JOIN `ps_ets_mm_block_lang` bl
ON b.id_block=bl.id_block AND bl.id_lang=1
WHERE 1  AND b.id_column=650 
ORDER BY b.sort_order asc,bl.title asc
 0.554 ms 2 Yes /modules/ets_megamenu/classes/MM_Block.php:615
352 
SELECT SQL_NO_CACHE c.*, cl.name,cl.link_rewrite
FROM `ps_category` c
INNER JOIN `ps_category_shop` cs ON (c.id_category =cs.id_category AND cs.id_shop=1)
LEFT JOIN `ps_category_lang` cl ON c.id_category=cl.id_category AND cl.id_lang=1
WHERE c.active=1 AND  c.id_parent=228 AND c.id_category!=228
GROUP BY c.id_category ORDER BY cl.name ASC,c.id_category ASC
 0.554 ms 343 Yes Yes /modules/ets_megamenu/classes/Ets_megamenu_defines.php:147
37 
SELECT SQL_NO_CACHE * FROM `ps_currency` c ORDER BY `iso_code` ASC
 0.554 ms 3 Yes /classes/Currency.php:709
75 
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` = 3024)
 0.554 ms 1 /classes/Product.php:3860
243 
SELECT SQL_NO_CACHE b.*,bl.title,bl.title_link,bl.content,bl.image_link,bl.image
FROM `ps_ets_mm_block` b
LEFT JOIN `ps_ets_mm_block_lang` bl
ON b.id_block=bl.id_block AND bl.id_lang=1
WHERE 1  AND b.id_column=727 
ORDER BY b.sort_order asc,bl.title asc
 0.552 ms 1 Yes /modules/ets_megamenu/classes/MM_Block.php:615
41 
SELECT SQL_NO_CACHE `id_lang` FROM `ps_lang`
WHERE `locale` = 'fr-fr'
OR `language_code` = 'fr-fr' LIMIT 1
 0.546 ms 5 /classes/Language.php:883
441 
SELECT SQL_NO_CACHE `id_image_type`
FROM `ps_image_type`
WHERE `name` = 'home'
 0.546 ms 1 /classes/ImageType.php:145
356 
SELECT SQL_NO_CACHE c.*, cl.name,cl.link_rewrite
FROM `ps_category` c
INNER JOIN `ps_category_shop` cs ON (c.id_category=cs.id_category AND cs.id_shop=1)
LEFT JOIN `ps_category_lang` cl ON c.id_category=cl.id_category AND cl.id_lang=1
LEFT JOIN `ps_category_group` cg ON c.`id_category` = cg.`id_category` 
WHERE c.active=1 
AND  c.id_category IN(228)
AND cg.`id_group` IN (1)
GROUP BY c.id_category ORDER BY cl.name ASC,c.id_category ASC
 0.544 ms 30 Yes /modules/ets_megamenu/classes/Ets_megamenu_defines.php:176
186 
SELECT SQL_NO_CACHE b.*,bl.title,bl.title_link,bl.content,bl.image_link,bl.image
FROM `ps_ets_mm_block` b
LEFT JOIN `ps_ets_mm_block_lang` bl
ON b.id_block=bl.id_block AND bl.id_lang=1
WHERE 1  AND b.id_column=651 
ORDER BY b.sort_order asc,bl.title asc
 0.542 ms 2 Yes /modules/ets_megamenu/classes/MM_Block.php:615
452 
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "an_sizeguide" LIMIT 1
 0.542 ms 1 /classes/module/Module.php:2664
224 
SELECT SQL_NO_CACHE b.*,bl.title,bl.title_link,bl.content,bl.image_link,bl.image
FROM `ps_ets_mm_block` b
LEFT JOIN `ps_ets_mm_block_lang` bl
ON b.id_block=bl.id_block AND bl.id_lang=1
WHERE 1  AND b.id_column=670 
ORDER BY b.sort_order asc,bl.title asc
 0.538 ms 1 Yes /modules/ets_megamenu/classes/MM_Block.php:615
666 
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 SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity
FROM `ps_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 1884 UNION SELECT 0 as first_level_quantity, SUM(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_cart` = 0 AND p.`id_product_item` = 1884 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 0.537 ms 0 /classes/Cart.php:1430
718 
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 = 3748 LIMIT 1
 0.536 ms 1 /classes/Product.php:1106
254 
SELECT SQL_NO_CACHE b.*,bl.title,bl.title_link,bl.content,bl.image_link,bl.image
FROM `ps_ets_mm_block` b
LEFT JOIN `ps_ets_mm_block_lang` bl
ON b.id_block=bl.id_block AND bl.id_lang=1
WHERE 1  AND b.id_column=681 
ORDER BY b.sort_order asc,bl.title asc
 0.535 ms 1 Yes /modules/ets_megamenu/classes/MM_Block.php:615
263 
SELECT SQL_NO_CACHE *
FROM `ps_ets_mm_column`
WHERE 1  AND id_menu=61
ORDER BY sort_order asc
 0.534 ms 15 Yes /modules/ets_megamenu/classes/MM_Column.php:126
101 
SELECT SQL_NO_CACHE GROUP_CONCAT(a.`id_product_pack`)
FROM `ps_pack` a
WHERE a.`id_product_item` = 3024 LIMIT 1
 0.533 ms 1 /classes/Pack.php:445
238 
SELECT SQL_NO_CACHE b.*,bl.title,bl.title_link,bl.content,bl.image_link,bl.image
FROM `ps_ets_mm_block` b
LEFT JOIN `ps_ets_mm_block_lang` bl
ON b.id_block=bl.id_block AND bl.id_lang=1
WHERE 1  AND b.id_column=733 
ORDER BY b.sort_order asc,bl.title asc
 0.533 ms 1 Yes /modules/ets_megamenu/classes/MM_Block.php:615
256 
SELECT SQL_NO_CACHE b.*,bl.title,bl.title_link,bl.content,bl.image_link,bl.image
FROM `ps_ets_mm_block` b
LEFT JOIN `ps_ets_mm_block_lang` bl
ON b.id_block=bl.id_block AND bl.id_lang=1
WHERE 1  AND b.id_column=683 
ORDER BY b.sort_order asc,bl.title asc
 0.531 ms 1 Yes /modules/ets_megamenu/classes/MM_Block.php:615
389 
SELECT SQL_NO_CACHE `id_image_type`
FROM `ps_image_type`
WHERE `name` = 'home'
 0.531 ms 1 /classes/ImageType.php:145
11 
SELECT SQL_NO_CACHE id_shop
FROM `ps_lang_shop`
WHERE `id_lang` = 1
AND id_shop = 1 LIMIT 1
 0.529 ms 1 /classes/ObjectModel.php:1732
436 
SELECT SQL_NO_CACHE `id_image_type`
FROM `ps_image_type`
WHERE `name` = 'home'
 0.529 ms 1 /classes/ImageType.php:145
180 
SELECT SQL_NO_CACHE b.*,bl.title,bl.title_link,bl.content,bl.image_link,bl.image
FROM `ps_ets_mm_block` b
LEFT JOIN `ps_ets_mm_block_lang` bl
ON b.id_block=bl.id_block AND bl.id_lang=1
WHERE 1  AND b.id_column=660 
ORDER BY b.sort_order asc,bl.title asc
 0.528 ms 3 Yes /modules/ets_megamenu/classes/MM_Block.php:615
85 
SELECT SQL_NO_CACHE pa.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` = 3024
 0.528 ms 1 /classes/Product.php:7508
330 
SELECT SQL_NO_CACHE `id_image_type`
FROM `ps_image_type`
WHERE `name` = 'home'
 0.527 ms 1 /classes/ImageType.php:145
42 
SELECT SQL_NO_CACHE `id_lang` FROM `ps_lang`
WHERE `locale` = 'fr-fr'
OR `language_code` = 'fr-fr' LIMIT 1
 0.526 ms 5 /classes/Language.php:883
9 
SELECT SQL_NO_CACHE *
FROM `ps_shop_group` a
WHERE (a.`id_shop_group` = 1) LIMIT 1
 0.526 ms 1 /src/Adapter/EntityMapper.php:71
94 
SELECT SQL_NO_CACHE c.`nleft`, c.`nright`
FROM `ps_category` c
WHERE (c.`id_category` = 168) LIMIT 1
 0.526 ms 1 /classes/Category.php:2028
65 
SELECT SQL_NO_CACHE COUNT(p.id_product)
FROM `ps_product` p
INNER JOIN ps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
WHERE p.id_product = 3024
AND DATEDIFF("2026-07-10 00:00:00", product_shop.`date_add`) < 20 LIMIT 1
 0.525 ms 0 /classes/Product.php:1732
573 
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `ps_product_attribute`
WHERE `id_product` = 2506
 0.525 ms 1 /classes/Product.php:2902
18 
SELECT SQL_NO_CACHE `name`, `alias` FROM `ps_hook_alias`
 0.523 ms 88 /classes/Hook.php:290
342 
SELECT SQL_NO_CACHE c.*, cl.name,cl.link_rewrite
FROM `ps_category` c
INNER JOIN `ps_category_shop` cs ON (c.id_category =cs.id_category AND cs.id_shop=1)
LEFT JOIN `ps_category_lang` cl ON c.id_category=cl.id_category AND cl.id_lang=1
WHERE c.active=1 AND  c.id_parent=228 AND c.id_category!=228
GROUP BY c.id_category ORDER BY cl.name ASC,c.id_category ASC
 0.523 ms 343 Yes Yes /modules/ets_megamenu/classes/Ets_megamenu_defines.php:147
486 
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position, fvl.id_feature_value
FROM ps_feature_product pf
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
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 = 2499
ORDER BY f.position ASC
 0.522 ms 1 Yes /classes/Product.php:6032
686 
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` = 3201) AND (b.`id_shop` = 1) LIMIT 1
 0.522 ms 1 /src/Adapter/EntityMapper.php:71
293 
SELECT SQL_NO_CACHE b.*,bl.title,bl.title_link,bl.content,bl.image_link,bl.image
FROM `ps_ets_mm_block` b
LEFT JOIN `ps_ets_mm_block_lang` bl
ON b.id_block=bl.id_block AND bl.id_lang=1
WHERE 1  AND b.id_column=723 
ORDER BY b.sort_order asc,bl.title asc
 0.521 ms 1 Yes /modules/ets_megamenu/classes/MM_Block.php:615
114 
SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 0 AND `id_shop` = 1 LIMIT 1
 0.519 ms 0 /classes/module/Module.php:2137
348 
SELECT SQL_NO_CACHE c.*, cl.name,cl.link_rewrite
FROM `ps_category` c
INNER JOIN `ps_category_shop` cs ON (c.id_category =cs.id_category AND cs.id_shop=1)
LEFT JOIN `ps_category_lang` cl ON c.id_category=cl.id_category AND cl.id_lang=1
WHERE c.active=1 AND  c.id_parent=4037 AND c.id_category!=4037
GROUP BY c.id_category ORDER BY cl.name ASC,c.id_category ASC
 0.517 ms 98 Yes Yes /modules/ets_megamenu/classes/Ets_megamenu_defines.php:147
560 
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 = 1666 LIMIT 1
 0.517 ms 1 /classes/Product.php:1106
179 
SELECT SQL_NO_CACHE b.*,bl.title,bl.title_link,bl.content,bl.image_link,bl.image
FROM `ps_ets_mm_block` b
LEFT JOIN `ps_ets_mm_block_lang` bl
ON b.id_block=bl.id_block AND bl.id_lang=1
WHERE 1  AND b.id_column=659 
ORDER BY b.sort_order asc,bl.title asc
 0.516 ms 1 Yes /modules/ets_megamenu/classes/MM_Block.php:615
393 
SELECT SQL_NO_CACHE `id_image_type`
FROM `ps_image_type`
WHERE `name` = 'home'
 0.516 ms 1 /classes/ImageType.php:145
439 
SELECT SQL_NO_CACHE `id_image_type`
FROM `ps_image_type`
WHERE `name` = 'home'
 0.516 ms 1 /classes/ImageType.php:145
801 
SELECT SQL_NO_CACHE lpsgdprc.`id_lpsgdpr_config`
FROM `ps_lpsgdpr_config` lpsgdprc
WHERE lpsgdprc.`id_shop` =1 LIMIT 1
 0.515 ms 5 /modules/lpsgdpr/classes/lpsgdprconfig.php:199
117 
SELECT SQL_NO_CACHE `need_identification_number`
FROM `ps_country`
WHERE `id_country` = 8 LIMIT 1
 0.514 ms 1 /classes/Country.php:405
434 
SELECT SQL_NO_CACHE `id_image_type`
FROM `ps_image_type`
WHERE `name` = 'home'
 0.513 ms 1 /classes/ImageType.php:145
603 
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position, fvl.id_feature_value
FROM ps_feature_product pf
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
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 = 1974
ORDER BY f.position ASC
 0.513 ms 1 Yes /classes/Product.php:6032
52 
SELECT SQL_NO_CACHE *
FROM `ps_currency` a
LEFT JOIN `ps_currency_shop` `c` ON a.`id_currency` = c.`id_currency` AND c.`id_shop` = 1
WHERE (a.`id_currency` = 1) LIMIT 1
 0.512 ms 1 /src/Adapter/EntityMapper.php:71
97 
SELECT SQL_NO_CACHE pa.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` = 3024
 0.510 ms 1 /classes/Product.php:7508
118 
SELECT SQL_NO_CACHE *
FROM `ps_country` a
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
 0.510 ms 1 /src/Adapter/EntityMapper.php:71
255 
SELECT SQL_NO_CACHE b.*,bl.title,bl.title_link,bl.content,bl.image_link,bl.image
FROM `ps_ets_mm_block` b
LEFT JOIN `ps_ets_mm_block_lang` bl
ON b.id_block=bl.id_block AND bl.id_lang=1
WHERE 1  AND b.id_column=682 
ORDER BY b.sort_order asc,bl.title asc
 0.509 ms 1 Yes /modules/ets_megamenu/classes/MM_Block.php:615
682 
SELECT SQL_NO_CACHE *
FROM ps_product_attachment pa
LEFT JOIN ps_attachment a ON a.id_attachment = pa.id_attachment
LEFT JOIN ps_attachment_lang al ON (a.id_attachment = al.id_attachment AND al.id_lang = 1)
WHERE pa.id_product = 3415
 0.509 ms 2 /classes/Product.php:6063
683 
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` = 3201
AND image_shop.`cover` = 1 LIMIT 1
 0.508 ms 15 /classes/Product.php:3570
290 
SELECT SQL_NO_CACHE b.*,bl.title,bl.title_link,bl.content,bl.image_link,bl.image
FROM `ps_ets_mm_block` b
LEFT JOIN `ps_ets_mm_block_lang` bl
ON b.id_block=bl.id_block AND bl.id_lang=1
WHERE 1  AND b.id_column=724 
ORDER BY b.sort_order asc,bl.title asc
 0.507 ms 1 Yes /modules/ets_megamenu/classes/MM_Block.php:615
755 
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `ps_product_attribute`
WHERE `id_product` = 3752
 0.507 ms 1 /classes/Product.php:2902
259 
SELECT SQL_NO_CACHE b.*,bl.title,bl.title_link,bl.content,bl.image_link,bl.image
FROM `ps_ets_mm_block` b
LEFT JOIN `ps_ets_mm_block_lang` bl
ON b.id_block=bl.id_block AND bl.id_lang=1
WHERE 1  AND b.id_column=686 
ORDER BY b.sort_order asc,bl.title asc
 0.507 ms 1 Yes /modules/ets_megamenu/classes/MM_Block.php:615
262 
SELECT SQL_NO_CACHE b.*,bl.title,bl.title_link,bl.content,bl.image_link,bl.image
FROM `ps_ets_mm_block` b
LEFT JOIN `ps_ets_mm_block_lang` bl
ON b.id_block=bl.id_block AND bl.id_lang=1
WHERE 1  AND b.id_column=688 
ORDER BY b.sort_order asc,bl.title asc
 0.506 ms 1 Yes /modules/ets_megamenu/classes/MM_Block.php:615
440 
SELECT SQL_NO_CACHE `id_image_type`
FROM `ps_image_type`
WHERE `name` = 'home'
 0.505 ms 1 /classes/ImageType.php:145
461 
SELECT SQL_NO_CACHE * FROM `ps_an_trust_badges_icons` sw
WHERE sw.`active`=1
AND sw.`icon_id` IN (
SELECT sa.`icon_id`
FROM `ps_an_trust_badges_icons_shop` sa
WHERE sa.id_shop IN (1)
)
 0.504 ms 8 /modules/an_trust_badges/classes/AnTrustBadgesIcons.php:84
585 
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 3748 AND id_shop=1 LIMIT 1
 0.504 ms 1 /classes/Product.php:6887
763 
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` = 1)
WHERE i.`id_product` = 3870
ORDER BY `position`
 0.503 ms 1 Yes /classes/Product.php:3545
125 
SELECT SQL_NO_CACHE hbl.html,hb.style,hbl.id_lang
FROM `ps_ets_hb_html_box` hb
LEFT JOIN `ps_ets_hb_html_box_lang` hbl 
ON (hb.`id_ets_hb_html_box` = hbl.`id_ets_hb_html_box` AND hbl.`id_lang` = 1)
JOIN `ps_ets_hb_html_box_position` hbp 
ON (hbp.`id_ets_hb_html_box` = hb.`id_ets_hb_html_box`)
WHERE hb.active = 1
AND hbp.`position` = 16
 0.502 ms 168 /modules/ets_htmlbox/classes/HBHtmlbox.php:255
240 
SELECT SQL_NO_CACHE b.*,bl.title,bl.title_link,bl.content,bl.image_link,bl.image
FROM `ps_ets_mm_block` b
LEFT JOIN `ps_ets_mm_block_lang` bl
ON b.id_block=bl.id_block AND bl.id_lang=1
WHERE 1  AND b.id_column=726 
ORDER BY b.sort_order asc,bl.title asc
 0.502 ms 1 Yes /modules/ets_megamenu/classes/MM_Block.php:615
654 
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position, fvl.id_feature_value
FROM ps_feature_product pf
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
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 = 3870
ORDER BY f.position ASC
 0.502 ms 1 Yes /classes/Product.php:6032
375 
SELECT SQL_NO_CACHE `id_image_type`
FROM `ps_image_type`
WHERE `name` = 'home'
 0.500 ms 1 /classes/ImageType.php:145
636 
SELECT SQL_NO_CACHE `reduction`
FROM `ps_product_group_reduction_cache`
WHERE `id_product` = 3752 AND `id_group` = 1 LIMIT 1
 0.499 ms 0 /classes/GroupReduction.php:156
740 
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` = 1)
WHERE i.`id_product` = 3328
ORDER BY `position`
 0.498 ms 1 Yes /classes/Product.php:3545
149 
SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 96 AND `id_shop` = 1 LIMIT 1
 0.495 ms 1 /classes/module/Module.php:2137
170 
SELECT SQL_NO_CACHE COUNT(DISTINCT c.id_currency) FROM `ps_currency` c
LEFT JOIN ps_currency_shop cs ON (cs.id_currency = c.id_currency AND cs.id_shop = 1)
WHERE c.`active` = 1 AND c.`deleted` = 0 LIMIT 1
 0.495 ms 3 /classes/Currency.php:1136
514 
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position, fvl.id_feature_value
FROM ps_feature_product pf
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
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 = 1666
ORDER BY f.position ASC
 0.495 ms 1 Yes /classes/Product.php:6032
548 
SELECT SQL_NO_CACHE depends_on_stock
FROM `ps_stock_available`
WHERE (id_product = 2507) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
 0.495 ms 1 /classes/stock/StockAvailable.php:753
800 
SELECT SQL_NO_CACHE lpsgdprc.`id_lpsgdpr_config`
FROM `ps_lpsgdpr_config` lpsgdprc
WHERE lpsgdprc.`id_shop` =1 LIMIT 1
 0.495 ms 5 /modules/lpsgdpr/classes/lpsgdprconfig.php:199
257 
SELECT SQL_NO_CACHE b.*,bl.title,bl.title_link,bl.content,bl.image_link,bl.image
FROM `ps_ets_mm_block` b
LEFT JOIN `ps_ets_mm_block_lang` bl
ON b.id_block=bl.id_block AND bl.id_lang=1
WHERE 1  AND b.id_column=684 
ORDER BY b.sort_order asc,bl.title asc
 0.494 ms 1 Yes /modules/ets_megamenu/classes/MM_Block.php:615
344 
SELECT SQL_NO_CACHE c.*, cl.name,cl.link_rewrite
FROM `ps_category` c
INNER JOIN `ps_category_shop` cs ON (c.id_category =cs.id_category AND cs.id_shop=1)
LEFT JOIN `ps_category_lang` cl ON c.id_category=cl.id_category AND cl.id_lang=1
WHERE c.active=1 AND  c.id_parent=4038 AND c.id_category!=4038
GROUP BY c.id_category ORDER BY cl.name ASC,c.id_category ASC
 0.493 ms 98 Yes Yes /modules/ets_megamenu/classes/Ets_megamenu_defines.php:147
264 
SELECT SQL_NO_CACHE b.*,bl.title,bl.title_link,bl.content,bl.image_link,bl.image
FROM `ps_ets_mm_block` b
LEFT JOIN `ps_ets_mm_block_lang` bl
ON b.id_block=bl.id_block AND bl.id_lang=1
WHERE 1  AND b.id_column=696 
ORDER BY b.sort_order asc,bl.title asc
 0.493 ms 1 Yes /modules/ets_megamenu/classes/MM_Block.php:615
296 
SELECT SQL_NO_CACHE b.*,bl.title,bl.title_link,bl.content,bl.image_link,bl.image
FROM `ps_ets_mm_block` b
LEFT JOIN `ps_ets_mm_block_lang` bl
ON b.id_block=bl.id_block AND bl.id_lang=1
WHERE 1  AND b.id_column=693 
ORDER BY b.sort_order asc,bl.title asc
 0.492 ms 1 Yes /modules/ets_megamenu/classes/MM_Block.php:615
187 
SELECT SQL_NO_CACHE b.*,bl.title,bl.title_link,bl.content,bl.image_link,bl.image
FROM `ps_ets_mm_block` b
LEFT JOIN `ps_ets_mm_block_lang` bl
ON b.id_block=bl.id_block AND bl.id_lang=1
WHERE 1  AND b.id_column=652 
ORDER BY b.sort_order asc,bl.title asc
 0.491 ms 1 Yes /modules/ets_megamenu/classes/MM_Block.php:615
362 
SELECT SQL_NO_CACHE `id_image_type`
FROM `ps_image_type`
WHERE `name` = 'home'
 0.490 ms 1 /classes/ImageType.php:145
610 
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` = 3328)
 0.490 ms 1 /classes/Product.php:3860
124 
SELECT SQL_NO_CACHE hbl.html,hb.style,hbl.id_lang
FROM `ps_ets_hb_html_box` hb
LEFT JOIN `ps_ets_hb_html_box_lang` hbl 
ON (hb.`id_ets_hb_html_box` = hbl.`id_ets_hb_html_box` AND hbl.`id_lang` = 1)
JOIN `ps_ets_hb_html_box_position` hbp 
ON (hbp.`id_ets_hb_html_box` = hb.`id_ets_hb_html_box`)
WHERE hb.active = 1
AND hbp.`position` = 20
 0.488 ms 168 /modules/ets_htmlbox/classes/HBHtmlbox.php:255
701 
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` = 1)
WHERE i.`id_product` = 1974
ORDER BY `position`
 0.487 ms 3 Yes /classes/Product.php:3545
702 
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `ps_product_attribute`
WHERE `id_product` = 1974
 0.486 ms 1 /classes/Product.php:2902
184 
SELECT SQL_NO_CACHE b.*,bl.title,bl.title_link,bl.content,bl.image_link,bl.image
FROM `ps_ets_mm_block` b
LEFT JOIN `ps_ets_mm_block_lang` bl
ON b.id_block=bl.id_block AND bl.id_lang=1
WHERE 1  AND b.id_column=649 
ORDER BY b.sort_order asc,bl.title asc
 0.485 ms 1 Yes /modules/ets_megamenu/classes/MM_Block.php:615
658 
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` = 1884) AND (b.`id_shop` = 1) LIMIT 1
 0.485 ms 1 /src/Adapter/EntityMapper.php:71
327 
SELECT SQL_NO_CACHE `id_image_type`
FROM `ps_image_type`
WHERE `name` = 'home'
 0.484 ms 1 /classes/ImageType.php:145
814 
SELECT SQL_NO_CACHE `id_page`
FROM `ps_page`
WHERE `id_page_type` = 3 AND `id_object` = 3024 LIMIT 1
 0.483 ms 2 /classes/Page.php:83
380 
SELECT SQL_NO_CACHE `id_image_type`
FROM `ps_image_type`
WHERE `name` = 'home'
 0.482 ms 1 /classes/ImageType.php:145
707 
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` = 1)
WHERE i.`id_product` = 1884
ORDER BY `position`
 0.480 ms 1 Yes /classes/Product.php:3545
515 
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` = 2506
AND image_shop.`cover` = 1 LIMIT 1
 0.480 ms 1 /classes/Product.php:3570
28 
SELECT SQL_NO_CACHE *
FROM `ps_lpsgdpr_config_lang`
WHERE `id_lpsgdpr_config` = 1
 0.479 ms 5 /src/Adapter/EntityMapper.php:79
697 
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position, fvl.id_feature_value
FROM ps_feature_product pf
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
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 = 3201
ORDER BY f.position ASC
 0.479 ms 1 Yes /classes/Product.php:6032
341 
SELECT SQL_NO_CACHE c.*, cl.name,cl.link_rewrite
FROM `ps_category` c
INNER JOIN `ps_category_shop` cs ON (c.id_category=cs.id_category AND cs.id_shop=1)
LEFT JOIN `ps_category_lang` cl ON c.id_category=cl.id_category AND cl.id_lang=1
LEFT JOIN `ps_category_group` cg ON c.`id_category` = cg.`id_category` 
WHERE c.active=1 
AND  c.id_category IN(228)
AND cg.`id_group` IN (1)
GROUP BY c.id_category ORDER BY cl.name ASC,c.id_category ASC
 0.478 ms 30 Yes /modules/ets_megamenu/classes/Ets_megamenu_defines.php:176
353 
SELECT SQL_NO_CACHE c.*, cl.name,cl.link_rewrite
FROM `ps_category` c
INNER JOIN `ps_category_shop` cs ON (c.id_category =cs.id_category AND cs.id_shop=1)
LEFT JOIN `ps_category_lang` cl ON c.id_category=cl.id_category AND cl.id_lang=1
WHERE c.active=1 AND  c.id_parent=4037 AND c.id_category!=4037
GROUP BY c.id_category ORDER BY cl.name ASC,c.id_category ASC
 0.477 ms 98 Yes Yes /modules/ets_megamenu/classes/Ets_megamenu_defines.php:147
717 
SELECT SQL_NO_CACHE location
FROM `ps_stock_available`
WHERE (id_product = 3748) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
 0.477 ms 1 /classes/stock/StockAvailable.php:806
343 
SELECT SQL_NO_CACHE c.*, cl.name,cl.link_rewrite
FROM `ps_category` c
INNER JOIN `ps_category_shop` cs ON (c.id_category =cs.id_category AND cs.id_shop=1)
LEFT JOIN `ps_category_lang` cl ON c.id_category=cl.id_category AND cl.id_lang=1
WHERE c.active=1 AND  c.id_parent=4037 AND c.id_category!=4037
GROUP BY c.id_category ORDER BY cl.name ASC,c.id_category ASC
 0.477 ms 98 Yes Yes /modules/ets_megamenu/classes/Ets_megamenu_defines.php:147
492 
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` = 2507)
 0.477 ms 1 /classes/Product.php:3860
642 
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` = 3870
AND image_shop.`cover` = 1 LIMIT 1
 0.475 ms 1 /classes/Product.php:3570
618 
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` = 3029
AND image_shop.`cover` = 1 LIMIT 1
 0.473 ms 4 /classes/Product.php:3570
484 
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 2499) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
 0.472 ms 1 /classes/stock/StockAvailable.php:453
226 
SELECT SQL_NO_CACHE b.*,bl.title,bl.title_link,bl.content,bl.image_link,bl.image
FROM `ps_ets_mm_block` b
LEFT JOIN `ps_ets_mm_block_lang` bl
ON b.id_block=bl.id_block AND bl.id_lang=1
WHERE 1  AND b.id_column=672 
ORDER BY b.sort_order asc,bl.title asc
 0.471 ms 1 Yes /modules/ets_megamenu/classes/MM_Block.php:615
460 
SELECT SQL_NO_CACHE * FROM `ps_an_trust_badges_widgets` sw
LEFT JOIN `ps_an_trust_badges_widgets_lang` sl 
ON (sw.`id_widget` = sl.`id_widget`
AND sl.`id_lang` = 1)
WHERE sw.`active`=1 
AND sw.`hook`="displayProductGuarantee" AND sw.`id_widget` IN (
SELECT sa.`id_widget`
FROM `ps_an_trust_badges_widgets_shop` sa
WHERE sa.id_shop IN (1)
)
 0.471 ms 6 /modules/an_trust_badges/classes/AnTrustBadgesWidgets.php:86
76 
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 3024 AND id_shop=1 LIMIT 1
 0.467 ms 1 /classes/Product.php:6887
142 
SELECT SQL_NO_CACHE id_lang FROM `ps_lang` WHERE is_rtl=0 AND active=1 LIMIT 1
 0.463 ms 5 /modules/ets_megamenu/classes/MM_Obj.php:503
577 
SELECT SQL_NO_CACHE *
FROM `ps_category_lang`
WHERE `id_category` = 168 AND `id_shop` = 1
 0.462 ms 5 /src/Adapter/EntityMapper.php:79
703 
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` = 1)
WHERE i.`id_product` = 3328
ORDER BY `position`
 0.460 ms 1 Yes /classes/Product.php:3545
91 
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` = 0
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
 0.460 ms 0 /override/classes/tax/TaxRulesTaxManager.php:109
143 
SELECT SQL_NO_CACHE id_lang FROM `ps_lang` WHERE is_rtl=1 AND active=1 LIMIT 1
 0.459 ms 5 /modules/ets_megamenu/classes/MM_Obj.php:503
401 
SELECT SQL_NO_CACHE `id_image_type`
FROM `ps_image_type`
WHERE `name` = 'home'
 0.459 ms 1 /classes/ImageType.php:145
785 
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` = 1)
WHERE i.`id_product` = 3415
ORDER BY `position`
 0.458 ms 6 Yes /classes/Product.php:3545
258 
SELECT SQL_NO_CACHE b.*,bl.title,bl.title_link,bl.content,bl.image_link,bl.image
FROM `ps_ets_mm_block` b
LEFT JOIN `ps_ets_mm_block_lang` bl
ON b.id_block=bl.id_block AND bl.id_lang=1
WHERE 1  AND b.id_column=685 
ORDER BY b.sort_order asc,bl.title asc
 0.456 ms 1 Yes /modules/ets_megamenu/classes/MM_Block.php:615
725 
SELECT SQL_NO_CACHE COUNT(*)
FROM `ps_an_wishlist_products`
WHERE `id_product` = 1974 LIMIT 1
 0.455 ms 334 /modules/an_wishlist/classes/an_wish_products.php:124
782 
SELECT SQL_NO_CACHE depends_on_stock
FROM `ps_stock_available`
WHERE (id_product = 3415) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
 0.453 ms 1 /classes/stock/StockAvailable.php:753
758 
SELECT SQL_NO_CACHE COUNT(*)
FROM `ps_an_wishlist_products`
WHERE `id_product` = 3870 LIMIT 1
 0.452 ms 334 /modules/an_wishlist/classes/an_wish_products.php:124
681 
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position, fvl.id_feature_value
FROM ps_feature_product pf
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
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 = 3415
ORDER BY f.position ASC
 0.451 ms 1 Yes /classes/Product.php:6032
336 
SELECT SQL_NO_CACHE c.*, cl.name,cl.link_rewrite
FROM `ps_category` c
INNER JOIN `ps_category_shop` cs ON (c.id_category =cs.id_category AND cs.id_shop=1)
LEFT JOIN `ps_category_lang` cl ON c.id_category=cl.id_category AND cl.id_lang=1
WHERE c.active=1 AND  c.id_parent=4038 AND c.id_category!=4038
GROUP BY c.id_category ORDER BY cl.name ASC,c.id_category ASC
 0.450 ms 98 Yes Yes /modules/ets_megamenu/classes/Ets_megamenu_defines.php:147
397 
SELECT SQL_NO_CACHE `id_image_type`
FROM `ps_image_type`
WHERE `name` = 'home'
 0.450 ms 1 /classes/ImageType.php:145
600 
SELECT SQL_NO_CACHE product_type FROM `ps_product` WHERE id_product = 1974 LIMIT 1
 0.450 ms 1 /classes/Pack.php:90
660 
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` = 1884)
 0.449 ms 1 /classes/Product.php:3860
704 
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` = 1)
WHERE i.`id_product` = 3029
ORDER BY `position`
 0.449 ms 4 Yes /classes/Product.php:3545
157 
SELECT SQL_NO_CACHE `name`
FROM `ps_hook`
WHERE `id_hook` = 906 LIMIT 1
 0.449 ms 1 /classes/Hook.php:247
126 
SELECT SQL_NO_CACHE hbl.html,hb.style,hbl.id_lang
FROM `ps_ets_hb_html_box` hb
LEFT JOIN `ps_ets_hb_html_box_lang` hbl 
ON (hb.`id_ets_hb_html_box` = hbl.`id_ets_hb_html_box` AND hbl.`id_lang` = 1)
JOIN `ps_ets_hb_html_box_position` hbp 
ON (hbp.`id_ets_hb_html_box` = hb.`id_ets_hb_html_box`)
WHERE hb.active = 1
AND hbp.`position` = 17
 0.447 ms 168 /modules/ets_htmlbox/classes/HBHtmlbox.php:255
425 
SELECT SQL_NO_CACHE `id_image_type`
FROM `ps_image_type`
WHERE `name` = 'home'
 0.447 ms 1 /classes/ImageType.php:145
120 
SELECT SQL_NO_CACHE id_required_field, object_name, field_name
FROM ps_required_field
 0.445 ms 1 /classes/ObjectModel.php:1595
153 
SELECT SQL_NO_CACHE 1 FROM ps_cart_product cp INNER JOIN ps_product p
ON (p.id_product = cp.id_product) INNER JOIN ps_product_shop ps
ON (ps.id_shop = cp.id_shop AND ps.id_product = p.id_product) WHERE cp.id_cart=0 LIMIT 1
 0.444 ms 1 /classes/Cart.php:4256
314 
SELECT SQL_NO_CACHE `id_image_type`
FROM `ps_image_type`
WHERE `name` = 'home'
 0.443 ms 1 /classes/ImageType.php:145
317 
SELECT SQL_NO_CACHE `id_image_type`
FROM `ps_image_type`
WHERE `name` = 'home'
 0.443 ms 1 /classes/ImageType.php:145
482 
SELECT SQL_NO_CACHE COUNT(*) FROM `ps_pack` WHERE id_product_pack = 2499 LIMIT 1
 0.443 ms 1 /classes/Pack.php:89
555 
SELECT SQL_NO_CACHE `id_wishlist`
FROM `ps_an_wishlist`
WHERE `id_customer` = 11151973
AND `is_guest` = 1
AND `id_shop` = 1 LIMIT 1
 0.443 ms 117 /modules/an_wishlist/classes/an_wish.php:76
668 
SELECT SQL_NO_CACHE *
FROM ps_product_attachment pa
LEFT JOIN ps_attachment a ON a.id_attachment = pa.id_attachment
LEFT JOIN ps_attachment_lang al ON (a.id_attachment = al.id_attachment AND al.id_lang = 1)
WHERE pa.id_product = 1884
 0.442 ms 1 /classes/Product.php:6063
116 
SELECT SQL_NO_CACHE format
FROM `ps_address_format`
WHERE `id_country` = 8 LIMIT 1
 0.439 ms 1 /classes/AddressFormat.php:656
777 
SELECT SQL_NO_CACHE `name`
FROM `ps_manufacturer`
WHERE `id_manufacturer` = 71
AND `active` = 1 LIMIT 1
 0.439 ms 1 /classes/Manufacturer.php:316
309 
SELECT SQL_NO_CACHE `id_image_type`
FROM `ps_image_type`
WHERE `name` = 'home'
 0.438 ms 1 /classes/ImageType.php:145
378 
SELECT SQL_NO_CACHE `id_image_type`
FROM `ps_image_type`
WHERE `name` = 'home'
 0.437 ms 1 /classes/ImageType.php:145
705 
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` = 1)
WHERE i.`id_product` = 3752
ORDER BY `position`
 0.437 ms 1 Yes /classes/Product.php:3545
55 
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
 0.434 ms 1 /src/Adapter/EntityMapper.php:71
617 
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position, fvl.id_feature_value
FROM ps_feature_product pf
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
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 = 3328
ORDER BY f.position ASC
 0.434 ms 1 Yes /classes/Product.php:6032
130 
SELECT SQL_NO_CACHE lpsgdprc.*, lpsgdprcl.`message`
FROM `ps_lpsgdpr_compliant` lpsgdprc
LEFT JOIN ps_lpsgdpr_compliant_lang lpsgdprcl
ON (lpsgdprc.`id_lpsgdpr_compliant` = lpsgdprcl.`id_lpsgdpr_compliant`)
WHERE lpsgdprc.`form_name` = "oldaccountlpsform"
AND lpsgdprcl.`id_lang` =1
AND lpsgdprc.`id_shop` =1
 0.433 ms 18 /modules/lpsgdpr/classes/lpsgdprcompliant.php:199
21 
SELECT SQL_NO_CACHE name, alias FROM `ps_hook_alias`
 0.433 ms 88 /classes/Hook.php:342
563 
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `ps_product_attribute`
WHERE `id_product` = 1666
 0.433 ms 1 /classes/Product.php:2902
300 
SELECT SQL_NO_CACHE * FROM `ps_image_type`
 0.432 ms 18 /classes/ImageType.php:161
361 
SELECT SQL_NO_CACHE `id_image_type`
FROM `ps_image_type`
WHERE `name` = 'home'
 0.431 ms 1 /classes/ImageType.php:145
528 
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` = 1)
WHERE i.`id_product` = 2507
ORDER BY `position`
 0.431 ms 1 Yes /classes/Product.php:3545
713 
SELECT SQL_NO_CACHE `id_wishlist`
FROM `ps_an_wishlist`
WHERE `id_customer` = 11151973
AND `is_guest` = 1
AND `id_shop` = 1 LIMIT 1
 0.430 ms 117 /modules/an_wishlist/classes/an_wish.php:76
535 
SELECT SQL_NO_CACHE `id_wishlist`
FROM `ps_an_wishlist`
WHERE `id_customer` = 11151973
AND `is_guest` = 1
AND `id_shop` = 1 LIMIT 1
 0.429 ms 117 /modules/an_wishlist/classes/an_wish.php:76
305 
SELECT SQL_NO_CACHE `id_image_type`
FROM `ps_image_type`
WHERE `name` = 'home'
 0.426 ms 1 /classes/ImageType.php:145
391 
SELECT SQL_NO_CACHE `id_image_type`
FROM `ps_image_type`
WHERE `name` = 'home'
 0.426 ms 1 /classes/ImageType.php:145
379 
SELECT SQL_NO_CACHE `id_image_type`
FROM `ps_image_type`
WHERE `name` = 'home'
 0.426 ms 1 /classes/ImageType.php:145
414 
SELECT SQL_NO_CACHE `id_image_type`
FROM `ps_image_type`
WHERE `name` = 'home'
 0.426 ms 1 /classes/ImageType.php:145
44 
SELECT SQL_NO_CACHE *
FROM `ps_currency` a
LEFT JOIN `ps_currency_lang` `b` ON a.`id_currency` = b.`id_currency` AND b.`id_lang` = 1
LEFT JOIN `ps_currency_shop` `c` ON a.`id_currency` = c.`id_currency` AND c.`id_shop` = 1
WHERE (a.`id_currency` = 3) LIMIT 1
 0.425 ms 1 /src/Adapter/EntityMapper.php:71
589 
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 3748) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
 0.425 ms 1 /classes/stock/StockAvailable.php:453
711 
SELECT SQL_NO_CACHE `name`
FROM `ps_manufacturer`
WHERE `id_manufacturer` = 53
AND `active` = 1 LIMIT 1
 0.424 ms 1 /classes/Manufacturer.php:316
500 
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` = 1666
AND image_shop.`cover` = 1 LIMIT 1
 0.424 ms 5 /classes/Product.php:3570
519 
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` = 2506)
 0.423 ms 1 /classes/Product.php:3860
647 
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` = 3870)
 0.422 ms 1 /classes/Product.php:3860
706 
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` = 1)
WHERE i.`id_product` = 3870
ORDER BY `position`
 0.422 ms 1 Yes /classes/Product.php:3545
195 
SELECT SQL_NO_CACHE *
FROM `ps_ets_mm_column`
WHERE 1  AND id_tab=50
ORDER BY sort_order asc
 0.419 ms 3 Yes /modules/ets_megamenu/classes/MM_Column.php:139
622 
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` = 3029)
 0.417 ms 1 /classes/Product.php:3860
465 
SELECT SQL_NO_CACHE depends_on_stock
FROM `ps_stock_available`
WHERE (id_product = 3024) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
 0.416 ms 1 /classes/stock/StockAvailable.php:753
56 
SELECT SQL_NO_CACHE *
FROM `ps_group_lang`
WHERE `id_group` = 1
 0.416 ms 5 /src/Adapter/EntityMapper.php:79
132 
SELECT SQL_NO_CACHE lpsgdprc.*, lpsgdprcl.`message`
FROM `ps_lpsgdpr_compliant` lpsgdprc
LEFT JOIN ps_lpsgdpr_compliant_lang lpsgdprcl
ON (lpsgdprc.`id_lpsgdpr_compliant` = lpsgdprcl.`id_lpsgdpr_compliant`)
WHERE lpsgdprc.`form_name` = "oldaccountlpsform"
AND lpsgdprcl.`id_lang` =1
AND lpsgdprc.`id_shop` =1
 0.415 ms 18 /modules/lpsgdpr/classes/lpsgdprcompliant.php:199
724 
SELECT SQL_NO_CACHE `id_wishlist`
FROM `ps_an_wishlist`
WHERE `id_customer` = 11151973
AND `is_guest` = 1
AND `id_shop` = 1 LIMIT 1
 0.413 ms 117 /modules/an_wishlist/classes/an_wish.php:76
674 
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` = 3415)
 0.412 ms 1 /classes/Product.php:3860
83 
SELECT SQL_NO_CACHE location
FROM `ps_stock_available`
WHERE (id_product = 3024) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
 0.411 ms 1 /classes/stock/StockAvailable.php:806
90 
SELECT SQL_NO_CACHE product_type FROM `ps_product` WHERE id_product = 3024 LIMIT 1
 0.411 ms 1 /classes/Pack.php:90
634 
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` = 3752)
 0.411 ms 1 /classes/Product.php:3860
494 
SELECT SQL_NO_CACHE `reduction`
FROM `ps_product_group_reduction_cache`
WHERE `id_product` = 2507 AND `id_group` = 1 LIMIT 1
 0.410 ms 0 /classes/GroupReduction.php:156
626 
SELECT SQL_NO_CACHE product_type FROM `ps_product` WHERE id_product = 3029 LIMIT 1
 0.410 ms 1 /classes/Pack.php:90
526 
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position, fvl.id_feature_value
FROM ps_feature_product pf
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
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 = 2506
ORDER BY f.position ASC
 0.410 ms 1 Yes /classes/Product.php:6032
48 
SELECT SQL_NO_CACHE *
FROM `ps_currency` a
LEFT JOIN `ps_currency_lang` `b` ON a.`id_currency` = b.`id_currency` AND b.`id_lang` = 1
LEFT JOIN `ps_currency_shop` `c` ON a.`id_currency` = c.`id_currency` AND c.`id_shop` = 1
WHERE (a.`id_currency` = 2) LIMIT 1
 0.408 ms 1 /src/Adapter/EntityMapper.php:71
507 
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` = 1666)
 0.403 ms 1 /classes/Product.php:3860
609 
SELECT SQL_NO_CACHE 1 FROM `ps_specific_price` WHERE id_product = 3328 LIMIT 1
 0.403 ms 1 /classes/SpecificPrice.php:435
384 
SELECT SQL_NO_CACHE `id_image_type`
FROM `ps_image_type`
WHERE `name` = 'home'
 0.400 ms 1 /classes/ImageType.php:145
596 
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` = 1974)
 0.397 ms 1 /classes/Product.php:3860
613 
SELECT SQL_NO_CACHE COUNT(*) FROM `ps_pack` WHERE id_product_pack = 3328 LIMIT 1
 0.396 ms 1 /classes/Pack.php:89
655 
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` = 1884
AND image_shop.`cover` = 1 LIMIT 1
 0.396 ms 1 /classes/Product.php:3570
714 
SELECT SQL_NO_CACHE COUNT(*)
FROM `ps_an_wishlist_products`
WHERE `id_product` = 3748 LIMIT 1
 0.395 ms 334 /modules/an_wishlist/classes/an_wish_products.php:124
553 
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `ps_product_attribute`
WHERE `id_product` = 2507
 0.395 ms 1 /classes/Product.php:2902
438 
SELECT SQL_NO_CACHE `id_image_type`
FROM `ps_image_type`
WHERE `name` = 'home'
 0.393 ms 1 /classes/ImageType.php:145
152 
SELECT SQL_NO_CACHE cl.`link_rewrite`
FROM `ps_category_lang` cl
WHERE `id_lang` = 0
AND cl.id_shop = 1 
AND cl.`id_category` = 168 LIMIT 1
 0.392 ms 0 /classes/Category.php:1378
131 
SELECT SQL_NO_CACHE lpsgdprc.*, lpsgdprcl.`message`
FROM `ps_lpsgdpr_compliant` lpsgdprc
LEFT JOIN ps_lpsgdpr_compliant_lang lpsgdprcl
ON (lpsgdprc.`id_lpsgdpr_compliant` = lpsgdprcl.`id_lpsgdpr_compliant`)
WHERE lpsgdprc.`form_name` = "accountcreationrequestmessage"
AND lpsgdprcl.`id_lang` =1
AND lpsgdprc.`id_shop` =1
 0.387 ms 18 /modules/lpsgdpr/classes/lpsgdprcompliant.php:199
66 
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 = 3024 LIMIT 1
 0.386 ms 1 /classes/Product.php:1106
527 
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` = 1)
WHERE i.`id_product` = 2499
ORDER BY `position`
 0.385 ms 1 Yes /classes/Product.php:3545
803 
SELECT SQL_NO_CACHE lpsgdprc.`id_lpsgdpr_config`
FROM `ps_lpsgdpr_config` lpsgdprc
WHERE lpsgdprc.`id_shop` =1 LIMIT 1
 0.384 ms 5 /modules/lpsgdpr/classes/lpsgdprconfig.php:199
757 
SELECT SQL_NO_CACHE `id_wishlist`
FROM `ps_an_wishlist`
WHERE `id_customer` = 11151973
AND `is_guest` = 1
AND `id_shop` = 1 LIMIT 1
 0.384 ms 117 /modules/an_wishlist/classes/an_wish.php:76
695 
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 3201) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
 0.382 ms 1 /classes/stock/StockAvailable.php:453
93 
SELECT SQL_NO_CACHE id_shop
FROM `ps_category_shop`
WHERE `id_category` = 168
AND id_shop = 1 LIMIT 1
 0.381 ms 0 /classes/ObjectModel.php:1732
576 
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` = 168) LIMIT 1
 0.380 ms 0 /src/Adapter/EntityMapper.php:71
684 
SELECT SQL_NO_CACHE cl.`link_rewrite`
FROM `ps_category_lang` cl
WHERE `id_lang` = 1
AND cl.id_shop = 1 
AND cl.`id_category` = 393 LIMIT 1
 0.378 ms 1 /classes/Category.php:1378
339 
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` = 1
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 228) AND (b.`id_shop` = 1) LIMIT 1
 0.377 ms 1 /src/Adapter/EntityMapper.php:71
587 
SELECT SQL_NO_CACHE COUNT(*) FROM `ps_pack` WHERE id_product_pack = 3748 LIMIT 1
 0.374 ms 1 /classes/Pack.php:89
688 
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 3201
ORDER BY `id_specific_price_priority` DESC LIMIT 1
 0.372 ms 1 /classes/SpecificPrice.php:259
69 
SELECT SQL_NO_CACHE 1 FROM `ps_specific_price` WHERE `id_product` != 0 LIMIT 1
 0.371 ms 505 /classes/SpecificPrice.php:297
311 
SELECT SQL_NO_CACHE `id_image_type`
FROM `ps_image_type`
WHERE `name` = 'home'
 0.371 ms 1 /classes/ImageType.php:145
172 
SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 1 AND `id_shop` = 1 LIMIT 1
 0.370 ms 1 /classes/module/Module.php:2137
338 
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` = 1
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 4038) AND (b.`id_shop` = 1) LIMIT 1
 0.370 ms 1 /src/Adapter/EntityMapper.php:71
536 
SELECT SQL_NO_CACHE COUNT(*)
FROM `ps_an_wishlist_products`
WHERE `id_product` = 2499 LIMIT 1
 0.369 ms 334 /modules/an_wishlist/classes/an_wish_products.php:124
176 
SELECT SQL_NO_CACHE SUM(`quantity`)
FROM `ps_cart_product`
WHERE `id_cart` = 0 LIMIT 1
 0.368 ms 1 /classes/Cart.php:1303
388 
SELECT SQL_NO_CACHE `id_image_type`
FROM `ps_image_type`
WHERE `name` = 'home'
 0.368 ms 1 /classes/ImageType.php:145
372 
SELECT SQL_NO_CACHE `id_image_type`
FROM `ps_image_type`
WHERE `name` = 'home'
 0.368 ms 1 /classes/ImageType.php:145
469 
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "ps_crossselling" LIMIT 1
 0.367 ms 1 /classes/module/Module.php:2664
370 
SELECT SQL_NO_CACHE `id_image_type`
FROM `ps_image_type`
WHERE `name` = 'home'
 0.366 ms 1 /classes/ImageType.php:145
416 
SELECT SQL_NO_CACHE `id_image_type`
FROM `ps_image_type`
WHERE `name` = 'home'
 0.365 ms 1 /classes/ImageType.php:145
476 
SELECT SQL_NO_CACHE name FROM ps_category_lang WHERE id_shop = 1 AND id_lang = 1 AND id_category = 1 LIMIT 1
 0.365 ms 1 /classes/Product.php:5670
127 
SELECT SQL_NO_CACHE COUNT(id_contact)
FROM `ps_ets_cfu_contact`
WHERE (button_popup_enabled > 0) LIMIT 1
 0.364 ms 9 /modules/ets_cfultimate/classes/ETS_CFU_Contact.php:246
382 
SELECT SQL_NO_CACHE `id_image_type`
FROM `ps_image_type`
WHERE `name` = 'home'
 0.364 ms 1 /classes/ImageType.php:145
475 
SELECT SQL_NO_CACHE cl.`link_rewrite`
FROM `ps_category_lang` cl
WHERE `id_lang` = 1
AND cl.id_shop = 1 
AND cl.`id_category` = 1 LIMIT 1
 0.363 ms 1 /classes/Category.php:1378
549 
SELECT SQL_NO_CACHE location
FROM `ps_stock_available`
WHERE (id_product = 2507) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
 0.363 ms 1 /classes/stock/StockAvailable.php:806
557 
SELECT SQL_NO_CACHE out_of_stock
FROM `ps_stock_available`
WHERE (id_product = 1666) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
 0.363 ms 1 /classes/stock/StockAvailable.php:778
313 
SELECT SQL_NO_CACHE `id_image_type`
FROM `ps_image_type`
WHERE `name` = 'home'
 0.362 ms 1 /classes/ImageType.php:145
478 
SELECT SQL_NO_CACHE 1 FROM `ps_specific_price` WHERE id_product = 2499 LIMIT 1
 0.361 ms 1 /classes/SpecificPrice.php:435
787 
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `ps_product_attribute`
WHERE `id_product` = 3415
 0.358 ms 1 /classes/Product.php:2902
129 
SELECT SQL_NO_CACHE lpsgdprc.`id_lpsgdpr_config`
FROM `ps_lpsgdpr_config` lpsgdprc
WHERE lpsgdprc.`id_shop` =1 LIMIT 1
 0.356 ms 5 /modules/lpsgdpr/classes/lpsgdprconfig.php:199
35 
SELECT SQL_NO_CACHE * FROM `ps_hook_module_exceptions`
WHERE `id_shop` IN (1)
 0.354 ms 36 /classes/module/Module.php:2046
405 
SELECT SQL_NO_CACHE `id_image_type`
FROM `ps_image_type`
WHERE `name` = 'home'
 0.353 ms 1 /classes/ImageType.php:145
38 
SELECT SQL_NO_CACHE `id_lang` FROM `ps_lang`
WHERE `locale` = 'fr-fr'
OR `language_code` = 'fr-fr' LIMIT 1
 0.351 ms 5 /classes/Language.php:883
105 
SELECT SQL_NO_CACHE `id_category` FROM `ps_category_product`
WHERE `id_product` = 3024
 0.351 ms 1 /classes/Product.php:3423
308 
SELECT SQL_NO_CACHE `id_image_type`
FROM `ps_image_type`
WHERE `name` = 'home'
 0.351 ms 1 /classes/ImageType.php:145
455 
SELECT SQL_NO_CACHE `name`
FROM `ps_hook`
WHERE `id_hook` = 885 LIMIT 1
 0.351 ms 1 /classes/Hook.php:247
51 
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` = 21) LIMIT 1
 0.349 ms 1 /src/Adapter/EntityMapper.php:71
316 
SELECT SQL_NO_CACHE `id_image_type`
FROM `ps_image_type`
WHERE `name` = 'home'
 0.347 ms 1 /classes/ImageType.php:145
427 
SELECT SQL_NO_CACHE `id_image_type`
FROM `ps_image_type`
WHERE `name` = 'home'
 0.345 ms 1 /classes/ImageType.php:145
639 
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 3752) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
 0.345 ms 1 /classes/stock/StockAvailable.php:453
739 
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 = 3328 LIMIT 1
 0.341 ms 1 /classes/Product.php:1106
174 
SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 79 AND `id_shop` = 1 LIMIT 1
 0.340 ms 1 /classes/module/Module.php:2137
550 
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 = 2507 LIMIT 1
 0.340 ms 1 /classes/Product.php:1106
369 
SELECT SQL_NO_CACHE `id_image_type`
FROM `ps_image_type`
WHERE `name` = 'home'
 0.339 ms 1 /classes/ImageType.php:145
50 
SELECT SQL_NO_CACHE `id_country`
FROM `ps_country`
WHERE `iso_code` = 'US' AND active = 1 LIMIT 1
 0.338 ms 1 /classes/Country.php:194
43 
SELECT SQL_NO_CACHE c.id_currency
FROM `ps_currency` c
WHERE (iso_code = 'GBP') LIMIT 1
 0.337 ms 1 /classes/Currency.php:893
207 
SELECT SQL_NO_CACHE *
FROM `ps_ets_mm_column`
WHERE 1  AND id_tab=47
ORDER BY sort_order asc
 0.336 ms 3 Yes /modules/ets_megamenu/classes/MM_Column.php:139
556 
SELECT SQL_NO_CACHE COUNT(*)
FROM `ps_an_wishlist_products`
WHERE `id_product` = 1666 LIMIT 1
 0.336 ms 334 /modules/an_wishlist/classes/an_wish_products.php:124
592 
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` = 1974
AND image_shop.`cover` = 1 LIMIT 1
 0.334 ms 3 /classes/Product.php:3570
115 
SELECT SQL_NO_CACHE * FROM `ps_image_type` WHERE 1 AND `products` = 1  ORDER BY `width` DESC, `height` DESC, `name`ASC
 0.333 ms 18 Yes /classes/ImageType.php:109
623 
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 3029 AND id_shop=1 LIMIT 1
 0.331 ms 1 /classes/Product.php:6887
387 
SELECT SQL_NO_CACHE `id_image_type`
FROM `ps_image_type`
WHERE `name` = 'home'
 0.329 ms 1 /classes/ImageType.php:145
77 
SELECT SQL_NO_CACHE `reduction`
FROM `ps_product_group_reduction_cache`
WHERE `id_product` = 3024 AND `id_group` = 1 LIMIT 1
 0.326 ms 0 /classes/GroupReduction.php:156
411 
SELECT SQL_NO_CACHE `id_image_type`
FROM `ps_image_type`
WHERE `name` = 'home'
 0.325 ms 1 /classes/ImageType.php:145
178 
SELECT SQL_NO_CACHE *
FROM `ps_ets_mm_column`
WHERE 1  AND id_menu=57
ORDER BY sort_order asc
 0.325 ms 15 Yes /modules/ets_megamenu/classes/MM_Column.php:126
279 
SELECT SQL_NO_CACHE *
FROM `ps_ets_mm_column`
WHERE 1  AND id_menu=62
ORDER BY sort_order asc
 0.324 ms 14 Yes /modules/ets_megamenu/classes/MM_Column.php:126
231 
SELECT SQL_NO_CACHE *
FROM `ps_ets_mm_column`
WHERE 1  AND id_menu=63
ORDER BY sort_order asc
 0.322 ms 15 Yes /modules/ets_megamenu/classes/MM_Column.php:126
247 
SELECT SQL_NO_CACHE *
FROM `ps_ets_mm_column`
WHERE 1  AND id_menu=59
ORDER BY sort_order asc
 0.322 ms 15 Yes /modules/ets_megamenu/classes/MM_Column.php:126
690 
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` = 3201)
 0.322 ms 1 /classes/Product.php:3860
547 
SELECT SQL_NO_CACHE out_of_stock
FROM `ps_stock_available`
WHERE (id_product = 2507) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
 0.320 ms 1 /classes/stock/StockAvailable.php:778
59 
SELECT SQL_NO_CACHE `name`
FROM `ps_manufacturer`
WHERE `id_manufacturer` = 0
AND `active` = 1 LIMIT 1
 0.319 ms 0 /classes/Manufacturer.php:316
595 
SELECT SQL_NO_CACHE 1 FROM `ps_specific_price` WHERE id_product = 1974 LIMIT 1
 0.318 ms 1 /classes/SpecificPrice.php:435
164 
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "an_logo" LIMIT 1
 0.315 ms 1 /classes/module/Module.php:2664
398 
SELECT SQL_NO_CACHE `id_image_type`
FROM `ps_image_type`
WHERE `name` = 'home'
 0.314 ms 1 /classes/ImageType.php:145
586 
SELECT SQL_NO_CACHE `reduction`
FROM `ps_product_group_reduction_cache`
WHERE `id_product` = 3748 AND `id_group` = 1 LIMIT 1
 0.313 ms 0 /classes/GroupReduction.php:156
294 
SELECT SQL_NO_CACHE *
FROM `ps_ets_mm_column`
WHERE 1  AND id_menu=60
ORDER BY sort_order asc
 0.312 ms 4 Yes /modules/ets_megamenu/classes/MM_Column.php:126
459 
SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 87 AND `id_shop` = 1 LIMIT 1
 0.310 ms 1 /classes/module/Module.php:2137
597 
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 1974 AND id_shop=1 LIMIT 1
 0.310 ms 1 /classes/Product.php:6887
128 
SELECT SQL_NO_CACHE lpsgdprc.`id_lpsgdpr_config`
FROM `ps_lpsgdpr_config` lpsgdprc
WHERE lpsgdprc.`id_shop` =1 LIMIT 1
 0.309 ms 5 /modules/lpsgdpr/classes/lpsgdprconfig.php:199
345 
SELECT SQL_NO_CACHE `id_image_type`
FROM `ps_image_type`
WHERE `name` = 'home'
 0.309 ms 1 /classes/ImageType.php:145
574 
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "ps_categoryproducts" LIMIT 1
 0.306 ms 1 /classes/module/Module.php:2664
661 
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 1884 AND id_shop=1 LIMIT 1
 0.306 ms 1 /classes/Product.php:6887
27 
SELECT SQL_NO_CACHE *
FROM `ps_lpsgdpr_config` a
WHERE (a.`id_lpsgdpr_config` = 1) LIMIT 1
 0.304 ms 1 /src/Adapter/EntityMapper.php:71
29 
SELECT SQL_NO_CACHE lpsgdprc.`id_lpsgdpr_config`
FROM `ps_lpsgdpr_config` lpsgdprc
WHERE lpsgdprc.`id_shop` =1 LIMIT 1
 0.303 ms 5 /modules/lpsgdpr/classes/lpsgdprconfig.php:199
103 
SELECT SQL_NO_CACHE pa.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` = 3024
 0.303 ms 1 /classes/Product.php:7508
407 
SELECT SQL_NO_CACHE `id_image_type`
FROM `ps_image_type`
WHERE `name` = 'home'
 0.303 ms 1 /classes/ImageType.php:145
423 
SELECT SQL_NO_CACHE `id_image_type`
FROM `ps_image_type`
WHERE `name` = 'home'
 0.303 ms 1 /classes/ImageType.php:145
656 
SELECT SQL_NO_CACHE cl.`link_rewrite`
FROM `ps_category_lang` cl
WHERE `id_lang` = 1
AND cl.id_shop = 1 
AND cl.`id_category` = 180 LIMIT 1
 0.302 ms 1 /classes/Category.php:1378
456 
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "an_hurry_up" LIMIT 1
 0.300 ms 1 /classes/module/Module.php:2664
360 
SELECT SQL_NO_CACHE `id_image_type`
FROM `ps_image_type`
WHERE `name` = 'home'
 0.300 ms 1 /classes/ImageType.php:145
715 
SELECT SQL_NO_CACHE out_of_stock
FROM `ps_stock_available`
WHERE (id_product = 3748) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
 0.300 ms 1 /classes/stock/StockAvailable.php:778
53 
SELECT SQL_NO_CACHE *
FROM `ps_currency_lang`
WHERE `id_currency` = 1
 0.299 ms 5 /src/Adapter/EntityMapper.php:79
392 
SELECT SQL_NO_CACHE `id_image_type`
FROM `ps_image_type`
WHERE `name` = 'home'
 0.298 ms 1 /classes/ImageType.php:145
532 
SELECT SQL_NO_CACHE state FROM ps_feature_flag WHERE name = 'multiple_image_format' LIMIT 1
 0.298 ms 1 /classes/FeatureFlag.php:105
80 
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 3024) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
 0.295 ms 1 /classes/stock/StockAvailable.php:453
57 
SELECT SQL_NO_CACHE id_shop
FROM `ps_group_shop`
WHERE `id_group` = 1
AND id_shop = 1 LIMIT 1
 0.295 ms 1 /classes/ObjectModel.php:1732
791 
SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 90 AND `id_shop` = 1 LIMIT 1
 0.295 ms 1 /classes/module/Module.php:2137
762 
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 = 3870 LIMIT 1
 0.294 ms 1 /classes/Product.php:1106
424 
SELECT SQL_NO_CACHE `id_image_type`
FROM `ps_image_type`
WHERE `name` = 'home'
 0.293 ms 1 /classes/ImageType.php:145
784 
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 = 3415 LIMIT 1
 0.293 ms 1 /classes/Product.php:1106
67 
SELECT SQL_NO_CACHE 1 FROM `ps_specific_price` WHERE id_product = 0 LIMIT 1
 0.293 ms 1 /classes/SpecificPrice.php:426
726 
SELECT SQL_NO_CACHE out_of_stock
FROM `ps_stock_available`
WHERE (id_product = 1974) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
 0.292 ms 1 /classes/stock/StockAvailable.php:778
453 
SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 86 AND `id_shop` = 1 LIMIT 1
 0.291 ms 1 /classes/module/Module.php:2137
464 
SELECT SQL_NO_CACHE out_of_stock
FROM `ps_stock_available`
WHERE (id_product = 3024) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
 0.291 ms 1