• Prix réduit
Pot de détente BUD HGS KTM SX 65 2009-2015-POT65KT09-RiMotoShop
  • Pot de détente BUD HGS KTM SX 65 2009-2015-POT65KT09-RiMotoShop

Pot de détente BUD HGS KTM SX 65 2009-2015

POT65KT09
Bud Racing
304,90 €
268,31 € Économisez 12%
Quantité
Derniers articles en stock

 

Compatibilité garantie pour le modèle indiqué!

 

60 jours pour le retour et le changement de produit

 

Whatsapp customer support

Description

Expansion d'échappement développée par Bud-racing et construite par Hgs.

Hgs est l'un des fournisseurs de systèmes d'échappement des plus grandes équipes européennes.

Cette détente promet une plus grande reprise à bas régime (suppression des écarts moteur) et un gain de puissance sur toute la plage de régime/régime moteur.

Chaque silencieux est développé en fonction des faiblesses de chaque moto afin de combler les lacunes de l'échappement standard.

Détails du produit
POT65KT09
Nouveau produit

Fiche technique

Marque de moto
KTM
Modèle de moto
SX 65
Année moto
2009
Année moto
2010
Année moto
2011
Année moto
2012
Année moto
2013
Année moto
2014
Année moto
2015
spécialités
cross

Cliquez ici pour laisser un commentaire

Envoyez-nous votre question

Soyez le premier à poser une question sur ce produit !

Consulter, révoquer ou modifier des données

Question sur le produit

* Champs obligatoires
(lis)
6 autres produits dans la même catégorie :
Load Time959 ms - OK... for a shared hosting
Querying Time629 ms
Queries467
Memory Peak Usage22.7 Mb
Included Files771 files - 11.77 Mb
PrestaShop Cache- Mb
Global vars1.24 Mb
PrestaShop Version1.7.5.0
PHP Version7.2.33 (OK)
MySQL Version8.0.32 (OK)
Memory Limit15000M
Max Execution Time3000s
Smarty Cacheenabled
Smarty Compilationnever recompile
 TimeCumulated TimeMemory UsageMemory Peak Usage
config 84 ms 84 ms 5.46 Mb 5.50 Mb
__construct 0 ms 84 ms - Mb 5.50 Mb
init 303 ms 387 ms 2.68 Mb 8.26 Mb
checkAccess 0 ms 387 ms - Mb 8.26 Mb
setMedia 7 ms 394 ms 0.19 Mb 8.46 Mb
postProcess 0 ms 394 ms - Mb 8.46 Mb
initHeader 0 ms 394 ms - Mb 8.46 Mb
initContent 150 ms 544 ms 4.86 Mb 13.20 Mb
initFooter 0 ms 544 ms - Mb 13.20 Mb
display 414 ms 959 ms 8.49 Mb 22.72 Mb
Hook Time Memory Usage
0 hooks - ms - Mb
Module Time Memory Usage
0 modules - ms - Mb
  1. Stopwatch SQL
  2. Doubles
  3. Tables stress
  4. ObjectModel instances
  5. Included Files

Stopwatch SQL - 467 queries

Query Time (ms) Rows Filesort Group By Location 
SELECT SQL_NO_CACHE COUNT(DISTINCT `id_product`) FROM `ps_specific_price` WHERE `id_product` != 0 LIMIT 1
 242.5 31085 /classes/SpecificPrice.php:283 
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("2025-01-16 00:00:00",
INTERVAL 30 DAY)) > 0 AS new, product_shop.price AS orderprice
FROM `ps_category_product` cp
LEFT JOIN `ps_product` p
ON p.`id_product` = cp.`id_product`
INNER JOIN ps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) LEFT JOIN `ps_product_attribute_shop` product_attribute_shop
ON (p.`id_product` = product_attribute_shop.`id_product` AND product_attribute_shop.`default_on` = 1 AND product_attribute_shop.id_shop=1)
LEFT JOIN ps_stock_available stock
ON (stock.id_product = `p`.id_product AND stock.id_product_attribute = 0 AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
LEFT JOIN `ps_category_lang` cl
ON (product_shop.`id_category_default` = cl.`id_category`
AND cl.`id_lang` = 2 AND cl.id_shop = 1 )
LEFT JOIN `ps_product_lang` pl
ON (p.`id_product` = pl.`id_product`
AND pl.`id_lang` = 2 AND pl.id_shop = 1 )
LEFT JOIN `ps_image_shop` image_shop
ON (image_shop.`id_product` = p.`id_product` AND image_shop.cover=1 AND image_shop.id_shop=1)
LEFT JOIN `ps_image_lang` il
ON (image_shop.`id_image` = il.`id_image`
AND il.`id_lang` = 2)
LEFT JOIN `ps_manufacturer` m
ON m.`id_manufacturer` = p.`id_manufacturer`
WHERE product_shop.`id_shop` = 1
AND cp.`id_category` = 202 AND product_shop.`active` = 1 AND product_shop.`visibility` IN ("both", "catalog") ORDER BY RAND() LIMIT 7
 71.2 1572 Yes /classes/Category.php:1010 
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`)
 14 7408 /classes/Configuration.php:160 
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` = 202 AND product_shop.`visibility` IN ("both", "catalog") AND product_shop.`active` = 1 LIMIT 1
 6.9 1572 /classes/Category.php:939 
INSERT IGNORE INTO `ps_ets_superspeed_cache_page_hook` set id_cache_page="117239", hook_name="displayAfterBodyOpeningTag"
 6.1 1 /modules/ets_superspeed/classes/cache.php:389 
SELECT SQL_NO_CACHE h.`name` as hook, m.`id_module`, h.`id_hook`, m.`name` as module
FROM `ps_module` m
INNER JOIN ps_module_shop module_shop
ON (module_shop.id_module = m.id_module AND module_shop.id_shop = 1 AND module_shop.enable_device & 1)
INNER JOIN `ps_module_shop` `ms` ON ms.`id_module` = m.`id_module`
INNER JOIN `ps_hook_module` `hm` ON hm.`id_module` = m.`id_module`
INNER JOIN `ps_hook` `h` ON hm.`id_hook` = h.`id_hook`
LEFT JOIN `ps_module_group` `mg` ON mg.`id_module` = m.`id_module`
WHERE (h.`name` != "paymentOptions") AND (hm.`id_shop` = 1) AND (mg.id_shop = 1 AND  mg.`id_group` IN (1))
GROUP BY hm.id_hook, hm.id_module
ORDER BY hm.`position`
 5.7 1515 Yes Yes /override/classes/Hook.php:155 
INSERT IGNORE INTO `ps_ets_superspeed_cache_page_hook` set id_cache_page="117239", hook_name="displayHeader"
 5.7 1 /modules/ets_superspeed/classes/cache.php:389 
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('ffa1d4adc0c9ac5814180b89d03157e2',"angarcontact|1|1|1|2|1|21","", FROM_UNIXTIME(1736989655))
 4.7 1 /classes/Smarty/SmartyCustom.php:265 
INSERT IGNORE INTO `ps_ets_superspeed_cache_page_hook` set id_cache_page="117239", hook_name="displayFooter"
 4.6 1 /modules/ets_superspeed/classes/cache.php:389 
INSERT INTO `ps_connections` (`id_guest`, `id_page`, `ip_address`, `http_referer`, `id_shop`, `id_shop_group`, `date_add`) VALUES ('222770', '14448', '2890391457', '', '1', '1', '2025-01-16 02:07:35')
 4.4 1 /classes/ObjectModel.php:551 
INSERT IGNORE INTO `ps_ets_superspeed_cache_page_hook` set id_cache_page="117239", hook_name="displayProductListReviews"
 4.4 1 /modules/ets_superspeed/classes/cache.php:389 
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('9dd148274295a11b4e73a2d53e0a5215',"angarcontact|1|1|1|2|1|21","", FROM_UNIXTIME(1736989655))
 4.3 1 /classes/Smarty/SmartyCustom.php:265 
INSERT IGNORE INTO `ps_ets_superspeed_cache_page_hook` set id_cache_page="117239", hook_name="displayFooterAfter"
 4.1 1 /modules/ets_superspeed/classes/cache.php:389 
INSERT IGNORE INTO `ps_ets_superspeed_cache_page_hook` set id_cache_page="117239", hook_name="displayAfterTitleTag"
 4.1 1 /modules/ets_superspeed/classes/cache.php:389 
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, 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
 3.9 558 /classes/Hook.php:413 
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')
 3.7 1 /classes/ObjectModel.php:551 
INSERT IGNORE INTO `ps_ets_superspeed_cache_page_hook` set id_cache_page="117239", hook_name="overrideLayoutTemplate"
 3.6 1 /modules/ets_superspeed/classes/cache.php:389 
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('845666cc9025ff8584ac98c9b4745957',"ps_categoryproducts|8796|202|1|1|1|2|1|21","", FROM_UNIXTIME(1736989655))
 3.6 1 /classes/Smarty/SmartyCustom.php:265 
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('845666cc9025ff8584ac98c9b4745957',"ps_categoryproducts|8796|202|1|1|1|2|1|21","", FROM_UNIXTIME(1736989655))
 3.4 1 /classes/Smarty/SmartyCustom.php:265 
INSERT IGNORE INTO `ps_ets_superspeed_cache_page_hook` set id_cache_page="117239", hook_name="displayNav2"
 3.3 1 /modules/ets_superspeed/classes/cache.php:389 
UPDATE `ps_smarty_lazy_cache`
SET filepath='ps_categoryproducts/8796/202/1/1/1/2/1/21/6b/3b/10/6b3b107aa97049305f39d4012053ba9ddff61c9e.pscategoryproductsviewste.php'
WHERE `template_hash`='845666cc9025ff8584ac98c9b4745957' AND cache_id="ps_categoryproducts|8796|202|1|1|1|2|1|21" AND compile_id=""
 3.3 1 /classes/Smarty/SmartyCustom.php:184 
INSERT INTO `ps_ets_superspeed_cache_page` (`page`, `id_object`, `id_product_attribute`, `ip`, `file_cache`, `request_uri`, `id_shop`, `id_lang`, `id_currency`, `id_country`, `has_customer`, `has_cart`, `click`, `file_size`, `user_agent`, `date_add`, `date_expired`) VALUES ('product', '8796', '0', '172.71.223.161', 'bb0861858abe2196b663958c48650cf5dea32edddf2b81bc28e6f783627314e8', '/fr/expansions-et-collecteurs-rimotoshop/pot-de-d%C3%A9tente-bud-hgs-ktm-sx-65-2009-2015.html', '1', '2', '1', '21', '0', '0', '1', '0', '', '2025-01-16 02:07:35', '2025-01-31 02:07:35')
 3.3 1 /classes/ObjectModel.php:551 
INSERT IGNORE INTO `ps_ets_superspeed_cache_page_hook` set id_cache_page="117239", hook_name="actionObjectAddAfter"
 3.2 1 /modules/ets_superspeed/classes/cache.php:389 
INSERT IGNORE INTO `ps_ets_superspeed_cache_page_hook` set id_cache_page="117239", hook_name="actionOutputHTMLBefore"
 3.2 1 /modules/ets_superspeed/classes/cache.php:389 
INSERT IGNORE INTO `ps_ets_superspeed_cache_page_hook` set id_cache_page="117239", hook_name="displayFooterBefore"
 3.2 1 /modules/ets_superspeed/classes/cache.php:389 
INSERT IGNORE INTO `ps_ets_superspeed_cache_page_hook` set id_cache_page="117239", hook_name="displayProductExtraContent"
 3.2 1 /modules/ets_superspeed/classes/cache.php:389 
INSERT IGNORE INTO `ps_ets_superspeed_cache_page_hook` set id_cache_page="117239", hook_name="moduleRoutes"
 3.1 1 /modules/ets_superspeed/classes/cache.php:389 
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('845666cc9025ff8584ac98c9b4745957',"ps_categoryproducts|8796|202|1|1|1|2|1|21","", FROM_UNIXTIME(1736989655))
 3.1 1 /classes/Smarty/SmartyCustom.php:265 
INSERT IGNORE INTO `ps_ets_superspeed_cache_page_hook` set id_cache_page="117239", hook_name="displayNav1"
 3.1 1 /modules/ets_superspeed/classes/cache.php:389 
INSERT IGNORE INTO `ps_ets_superspeed_cache_page_hook` set id_cache_page="117239", hook_name="displayBeforeBodyClosingTag"
 3 1 /modules/ets_superspeed/classes/cache.php:389 
SELECT SQL_NO_CACHE DISTINCT c.id_lgconsultas, c.*, r.respuesta FROM ps_lgconsultas c LEFT JOIN ps_lgconsultas_respuestas r ON c.id_lgconsultas=r.id_lgconsultas WHERE c.id_producto=8796  AND c.active=1 ORDER BY c.date_add DESC
 2.9 59895 Yes /modules/lgconsultas/lgconsultas.php:281 
INSERT IGNORE INTO `ps_ets_superspeed_cache_page_hook` set id_cache_page="117239", hook_name="DisplayOverrideTemplate"
 2.9 1 /modules/ets_superspeed/classes/cache.php:389 
INSERT IGNORE INTO `ps_ets_superspeed_cache_page_hook` set id_cache_page="117239", hook_name="displayProductPriceBlock"
 2.9 1 /modules/ets_superspeed/classes/cache.php:389 
INSERT IGNORE INTO `ps_ets_superspeed_cache_page_hook` set id_cache_page="117239", hook_name="displayNavFullWidth"
 2.8 1 /modules/ets_superspeed/classes/cache.php:389 
INSERT IGNORE INTO `ps_ets_superspeed_cache_page_hook` set id_cache_page="117239", hook_name="actionFrontControllerAfterInit"
 2.8 1 /modules/ets_superspeed/classes/cache.php:389 
INSERT IGNORE INTO `ps_ets_superspeed_cache_page_hook` set id_cache_page="117239", hook_name="displayReassurance"
 2.7 1 /modules/ets_superspeed/classes/cache.php:389 
INSERT IGNORE INTO `ps_ets_superspeed_cache_page_hook` set id_cache_page="117239", hook_name="actionProductOutOfStock"
 2.5 1 /modules/ets_superspeed/classes/cache.php:389 
INSERT IGNORE INTO `ps_ets_superspeed_cache_page_hook` set id_cache_page="117239", hook_name="actionDispatcherBefore"
 2.5 1 /modules/ets_superspeed/classes/cache.php:389 
INSERT IGNORE INTO `ps_ets_superspeed_cache_page_hook` set id_cache_page="117239", hook_name="displayTop"
 2.5 1 /modules/ets_superspeed/classes/cache.php:389 
INSERT IGNORE INTO `ps_ets_superspeed_cache_page_hook` set id_cache_page="117239", hook_name="displayFooterProduct"
 2.5 1 /modules/ets_superspeed/classes/cache.php:389 
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.4 0 /classes/Hook.php:200 
INSERT IGNORE INTO `ps_ets_superspeed_cache_page_hook` set id_cache_page="117239", hook_name="actionObjectUpdateAfter"
 2.3 1 /modules/ets_superspeed/classes/cache.php:389 
INSERT IGNORE INTO `ps_ets_superspeed_cache_page_hook` set id_cache_page="117239", hook_name="displayProductAdditionalInfo"
 2.3 1 /modules/ets_superspeed/classes/cache.php:389 
UPDATE `ps_ets_superspeed_cache_page` SET `id_cache_page` = '117239',`page` = 'product',`id_object` = '8796',`id_product_attribute` = '0',`ip` = '172.71.223.161',`file_cache` = 'bb0861858abe2196b663958c48650cf5dea32edddf2b81bc28e6f783627314e8',`request_uri` = '/fr/expansions-et-collecteurs-rimotoshop/pot-de-d%C3%A9tente-bud-hgs-ktm-sx-65-2009-2015.html',`id_shop` = '1',`id_lang` = '2',`id_currency` = '1',`id_country` = '21',`has_customer` = '0',`has_cart` = '0',`click` = '1',`file_size` = '171.06',`user_agent` = '',`date_add` = '2025-01-16 02:07:35',`date_expired` = '2025-01-31 02:07:35' WHERE `id_cache_page` = 117239
 2.2 1 /classes/ObjectModel.php:718 
INSERT IGNORE INTO `ps_ets_superspeed_cache_page_hook` set id_cache_page="117239", hook_name="actionDispatcher"
 2.1 1 /modules/ets_superspeed/classes/cache.php:389 
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('9dd148274295a11b4e73a2d53e0a5215',"angarcontact|1|1|1|2|1|21","", FROM_UNIXTIME(1736989655))
 2 1 /classes/Smarty/SmartyCustom.php:265 
INSERT IGNORE INTO `ps_ets_superspeed_cache_page_hook` set id_cache_page="117239", hook_name="actionFrontControllerSetMedia"
 1.9 1 /modules/ets_superspeed/classes/cache.php:389 
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(
"2025-01-16 00:00:00",
INTERVAL 30 DAY
)
) > 0 AS new
FROM `ps_accessory`
LEFT JOIN `ps_product` p ON p.`id_product` = `id_product_2`
INNER JOIN ps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_product_attribute_shop` product_attribute_shop
ON (p.`id_product` = product_attribute_shop.`id_product` AND product_attribute_shop.`default_on` = 1 AND product_attribute_shop.id_shop=1)
LEFT JOIN `ps_product_lang` pl ON (
p.`id_product` = pl.`id_product`
AND pl.`id_lang` = 2 AND pl.id_shop = 1 
)
LEFT JOIN `ps_category_lang` cl ON (
product_shop.`id_category_default` = cl.`id_category`
AND cl.`id_lang` = 2 AND cl.id_shop = 1 
)
LEFT JOIN `ps_image_shop` image_shop
ON (image_shop.`id_product` = p.`id_product` AND image_shop.cover=1 AND image_shop.id_shop=1)
LEFT JOIN `ps_image_lang` il ON (image_shop.`id_image` = il.`id_image` AND il.`id_lang` = 2)
LEFT JOIN `ps_manufacturer` m ON (p.`id_manufacturer`= m.`id_manufacturer`)
LEFT JOIN ps_stock_available stock
ON (stock.id_product = `p`.id_product AND stock.id_product_attribute = 0 AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
WHERE `id_product_1` = 8796 AND product_shop.`active` = 1 AND product_shop.`visibility` != 'none'
GROUP BY product_shop.id_product
 1.7 1 Yes /classes/Product.php:4003 
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('ffa1d4adc0c9ac5814180b89d03157e2',"angarcontact|1|1|1|2|1|21","", FROM_UNIXTIME(1736989655))
 1.6 1 /classes/Smarty/SmartyCustom.php:265 
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.5 231 Yes /classes/Dispatcher.php:634 
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`, product_attribute_shop.`unit_price_impact`,
product_attribute_shop.`minimal_quantity`, product_attribute_shop.`available_date`, ag.`group_type`
FROM `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
LEFT JOIN ps_stock_available stock
ON (stock.id_product = `pa`.id_product AND stock.id_product_attribute = IFNULL(`pa`.id_product_attribute, 0) AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
LEFT JOIN `ps_product_attribute_combination` pac ON (pac.`id_product_attribute` = pa.`id_product_attribute`)
LEFT JOIN `ps_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
LEFT JOIN `ps_attribute_group` ag ON (ag.`id_attribute_group` = a.`id_attribute_group`)
LEFT JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute`)
LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group`)
INNER JOIN ps_attribute_shop attribute_shop
ON (attribute_shop.id_attribute = a.id_attribute AND attribute_shop.id_shop = 1)
WHERE pa.`id_product` = 8796
AND al.`id_lang` = 2
AND agl.`id_lang` = 2
GROUP BY id_attribute_group, id_product_attribute
ORDER BY ag.`position` ASC, a.`position` ASC, agl.`name` ASC
 1.5 1 Yes Yes /classes/Product.php:3915 
(SELECT 1 FROM `ps_cart_rule` WHERE date_to >= "2025-01-16 00:00:00" AND date_to <= "2025-01-16 23:59:59" AND `id_customer` IN (0,0) LIMIT 1)UNION ALL (SELECT 1 FROM `ps_cart_rule` WHERE date_from >= "2025-01-16 00:00:00" AND date_from <= "2025-01-16 23:59:59" AND `id_customer` IN (0,0) LIMIT 1)UNION ALL (SELECT 1 FROM `ps_cart_rule` WHERE date_from < "2025-01-16 00:00:00" AND date_to > "2025-01-16 23:59:59" AND `id_customer` IN (0,0) LIMIT 1) LIMIT 1
 1.3 1 /classes/CartRule.php:341 
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position
FROM ps_feature_product pf
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 2)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 2)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 2)
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 8796
ORDER BY f.position ASC
 1.2 8 Yes /classes/Product.php:4952 
SELECT SQL_NO_CACHE `id_country`
FROM `ps_address`
WHERE `id_customer` = 0
AND `deleted` = 0
 1.2 200 /classes/CartRule.php:467 
SELECT SQL_NO_CACHE `id_country`
FROM `ps_address`
WHERE `id_customer` = 0
AND `deleted` = 0
 1.2 200 /classes/CartRule.php:467 
SELECT SQL_NO_CACHE *,
( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 21, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 21) AND
`id_group` IN (0, 1) AND `id_product` = 8796 AND `id_customer` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2025-01-16 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2025-01-16 00:00:00' <= `to`)
ORDER BY `from_quantity` ASC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC
 1.1 1 Yes /classes/SpecificPrice.php:612 
(SELECT SQL_NO_CACHE * FROM `ps_cart_rule` cr
LEFT JOIN `ps_cart_rule_lang` crl ON (cr.`id_cart_rule` = crl.`id_cart_rule` AND crl.`id_lang` = 2) WHERE cr.`id_customer` = 0  AND NOW() BETWEEN cr.date_from AND cr.date_to
AND cr.`active` = 1
AND free_shipping = 1 AND carrier_restriction = 1) UNION (SELECT * FROM `ps_cart_rule` cr
LEFT JOIN `ps_cart_rule_lang` crl ON (cr.`id_cart_rule` = crl.`id_cart_rule` AND crl.`id_lang` = 2) WHERE cr.`group_restriction` = 1  AND NOW() BETWEEN cr.date_from AND cr.date_to
AND cr.`active` = 1
AND free_shipping = 1 AND carrier_restriction = 1)
 1 1 /classes/CartRule.php:400 
SELECT SQL_NO_CACHE `id_country`
FROM `ps_address`
WHERE `id_customer` = 0
AND `deleted` = 0
 1 200 /classes/CartRule.php:467 
(SELECT SQL_NO_CACHE * FROM `ps_cart_rule` cr
LEFT JOIN `ps_cart_rule_lang` crl ON (cr.`id_cart_rule` = crl.`id_cart_rule` AND crl.`id_lang` = 2) WHERE cr.`id_customer` = 0  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_%") UNION (SELECT * FROM `ps_cart_rule` cr
LEFT JOIN `ps_cart_rule_lang` crl ON (cr.`id_cart_rule` = crl.`id_cart_rule` AND crl.`id_lang` = 2) WHERE cr.`group_restriction` = 1  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 1 /classes/CartRule.php:400 
SELECT SQL_NO_CACHE *
FROM `ps_manufacturer` a
LEFT JOIN `ps_manufacturer_lang` `b` ON a.`id_manufacturer` = b.`id_manufacturer` AND b.`id_lang` = 2
LEFT JOIN `ps_manufacturer_shop` `c` ON a.`id_manufacturer` = c.`id_manufacturer` AND c.`id_shop` = 1
WHERE (a.`id_manufacturer` = 198) LIMIT 1
 1 1 /src/Adapter/EntityMapper.php:75 
SELECT SQL_NO_CACHE a.`id_ce_content` AS id
FROM `ps_ce_content` a
LEFT JOIN `ps_ce_content_lang` `b` ON a.`id_ce_content` = b.`id_ce_content`
LEFT JOIN `ps_ce_content_shop` `c` ON c.`id_ce_content` = a.`id_ce_content` AND c.`id_shop` = b.`id_shop`
WHERE (b.`id_lang` = 2) AND (c.`id_shop` = 1) AND (a.`hook` LIKE "displayFooterProduct") AND (a.`active` = 1) AND (a.`id_product` = 0 OR a.`id_product` = 8796)
ORDER BY a.`id_product` DESC
 1 2 Yes /modules/creativeelements/classes/CEContent.php:138 
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 101 /classes/module/Module.php:305 
SELECT SQL_NO_CACHE COUNT(*) FROM ps_lgconsultas WHERE id_producto = 8796 AND active = 1 LIMIT 1
 1 605 /modules/lgconsultas/lgconsultas.php:301 
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 21, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 21) AND
`id_group` IN (0, 1) AND `id_product` = 9424 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2025-01-16 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2025-01-16 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.9 1 Yes /classes/SpecificPrice.php:549 
SELECT SQL_NO_CACHE `id_country`
FROM `ps_address`
WHERE `id_customer` = 0
AND `deleted` = 0
 0.9 200 /classes/CartRule.php:467 
SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT cp.`quantity` as first_level_quantity, 0 as pack_quantity
FROM `ps_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 8796 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `ps_cart_product` cp JOIN `ps_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `ps_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 8796 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 1 = 1
))) as q LIMIT 1
 0.9 0 /classes/Cart.php:1234 
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.9 101 /classes/module/Module.php:305 
SELECT SQL_NO_CACHE * FROM `ps_psreassurance` pr
LEFT JOIN ps_psreassurance_lang prl ON (pr.id_psreassurance = prl.id_psreassurance)
WHERE prl.id_lang = "2"
AND pr.status = 1
ORDER BY pr.position
 0.9 28 Yes /modules/blockreassurance/classes/ReassuranceActivity.php:159 
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position
FROM ps_feature_product pf
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 2)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 2)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 2)
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 10068260
ORDER BY f.position ASC
 0.9 8 Yes /classes/Product.php:4952 
SELECT SQL_NO_CACHE id_tab, class_name FROM `ps_tab`
 0.9 185 /classes/Tab.php:318 
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.9 101 /classes/module/Module.php:305 
SELECT SQL_NO_CACHE *
FROM `ps_product_lang` t
LEFT JOIN `ps_product_shop` ps ON t.`id_product` = ps.`id_product` AND t.`id_shop` = ps.`id_shop`
WHERE ((t.`link_rewrite` = 'pot-de-détente-bud-hgs-ktm-sx-65-2009-2015' OR t.`link_rewrite` = 'pot-de-d%C3%A9tente-bud-hgs-ktm-sx-65-2009-2015') AND t.`id_lang` = 2 AND ps.`id_shop` = 1 AND ps.`active` = 1) LIMIT 1
 0.8 2 /modules/arseopro/classes/url/ArSeoProURLProduct.php:140 
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.8 101 /classes/module/Module.php:305 
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` = 5
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 8796) AND (b.`id_shop` = 1) LIMIT 1
 0.8 1 /src/Adapter/EntityMapper.php:75 
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` = 61
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.8 1 Yes /classes/tax/TaxRulesTaxManager.php:108 
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 21, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 21) AND
`id_group` IN (0, 1) AND `id_product` = 10016322 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2025-01-16 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2025-01-16 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.8 1 Yes /classes/SpecificPrice.php:549 
SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT cp.`quantity` as first_level_quantity, 0 as pack_quantity
FROM `ps_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 10068260 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `ps_cart_product` cp JOIN `ps_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `ps_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 10068260 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 1 = 1
))) as q LIMIT 1
 0.8 0 /classes/Cart.php:1234 
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`
FROM `ps_attribute` a
LEFT JOIN `ps_attribute_lang` al
ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 2)
LEFT JOIN `ps_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 2)
LEFT JOIN `ps_product_attribute_combination` pac
ON (a.`id_attribute` = pac.`id_attribute`)
LEFT JOIN `ps_product_attribute` pa
ON (pac.`id_product_attribute` = pa.`id_product_attribute`)
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
INNER JOIN ps_attribute_shop attribute_shop
ON (attribute_shop.id_attribute = pac.id_attribute AND attribute_shop.id_shop = 1)
WHERE pa.`id_product` = 8796
 0.8 1 /classes/Product.php:6203 
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 21, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 21) AND
`id_group` IN (0, 1) AND `id_product` = 10068260 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2025-01-16 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2025-01-16 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.8 1 Yes /classes/SpecificPrice.php:549 
(SELECT 1 FROM `ps_cart_rule` WHERE date_to >= "2025-01-16 00:00:00" AND date_to <= "2025-01-16 23:59:59" AND `id_customer` IN (0,0) LIMIT 1)UNION ALL (SELECT 1 FROM `ps_cart_rule` WHERE date_from >= "2025-01-16 00:00:00" AND date_from <= "2025-01-16 23:59:59" AND `id_customer` IN (0,0) LIMIT 1)UNION ALL (SELECT 1 FROM `ps_cart_rule` WHERE date_from < "2025-01-16 00:00:00" AND date_to > "2025-01-16 23:59:59" AND `id_customer` IN (0,0) LIMIT 1) LIMIT 1
 0.8 1 /classes/CartRule.php:341 
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
JOIN `ps_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `ps_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 2)
JOIN `ps_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (10066795) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
 0.8 1 Yes Yes /classes/Product.php:3860 
SELECT SQL_NO_CACHE s.id_shop, CONCAT(su.physical_uri, su.virtual_uri) AS uri, su.domain, su.main
FROM ps_shop_url su
LEFT JOIN ps_shop s ON (s.id_shop = su.id_shop)
WHERE (su.domain = 'www.rimotoshop.com' OR su.domain_ssl = 'www.rimotoshop.com')
AND s.active = 1
AND s.deleted = 0
ORDER BY LENGTH(CONCAT(su.physical_uri, su.virtual_uri)) DESC
 0.8 1 Yes /classes/shop/Shop.php:345 
SELECT SQL_NO_CACHE COUNT(*) FROM ps_lgconsultas WHERE id_producto = 8796 AND active = 1 LIMIT 1
 0.8 605 /modules/lgconsultas/lgconsultas.php:301 
SELECT SQL_NO_CACHE COUNT(DISTINCT c.id_currency) FROM `ps_currency` c
LEFT JOIN ps_currency_shop cs ON (cs.id_currency = c.id_currency AND cs.id_shop = 1)
WHERE c.`active` = 1 LIMIT 1
 0.7 3 /classes/Currency.php:661 
SELECT SQL_NO_CACHE p.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2025-01-16 00:00:00',
INTERVAL 30 DAY
)
) > 0) as new
FROM ps_product p
LEFT JOIN ps_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 2
LEFT JOIN ps_stock_available sa
ON sa.id_product = p.id_product 
AND sa.id_shop = 1
WHERE p.id_product = 10066795
 0.7 1 /classes/ProductAssembler.php:90 
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `ps_image` i
INNER JOIN ps_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `ps_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 2)
WHERE i.`id_product` = 10108494
ORDER BY `position`
 0.7 4 Yes /classes/Product.php:3042 
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`
FROM `ps_attribute` a
LEFT JOIN `ps_attribute_lang` al
ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 2)
LEFT JOIN `ps_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 2)
LEFT JOIN `ps_product_attribute_combination` pac
ON (a.`id_attribute` = pac.`id_attribute`)
LEFT JOIN `ps_product_attribute` pa
ON (pac.`id_product_attribute` = pa.`id_product_attribute`)
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
INNER JOIN ps_attribute_shop attribute_shop
ON (attribute_shop.id_attribute = pac.id_attribute AND attribute_shop.id_shop = 1)
WHERE pa.`id_product` = 8796
 0.7 1 /classes/Product.php:6203 
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
JOIN `ps_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `ps_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 2)
JOIN `ps_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (10001387) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
 0.7 1 Yes Yes /classes/Product.php:3860 
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` = 10) LIMIT 1
 0.7 1 /src/Adapter/EntityMapper.php:75 
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)
 0.7 5 /classes/Language.php:882 
SELECT SQL_NO_CACHE pc.*, CONCAT(c.firstname, ' ', (SUBSTRING(c.lastname,1,1)), '.') as customer,  ROUND( ( pc.stars / 2 ), 1) AS rating FROM ps_lgcomments_productcomments pc LEFT JOIN ps_customer as c ON pc.id_customer = c.id_customer WHERE pc.id_product = 8796  AND pc.active = 1 ORDER BY pc.position DESC
 0.7 1 Yes /modules/lgcomments/classes/LGProductComment.php:125 
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 21, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 21) AND
`id_group` IN (0, 1) AND `id_product` = 8796 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2025-01-16 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2025-01-16 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.7 1 Yes /classes/SpecificPrice.php:549 
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.7 1 Yes /classes/shop/Shop.php:704 
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
JOIN `ps_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `ps_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 2)
JOIN `ps_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (10108494) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
 0.6 1 Yes Yes /classes/Product.php:3860 
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position
FROM ps_feature_product pf
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 2)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 2)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 2)
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 10108494
ORDER BY f.position ASC
 0.6 7 Yes /classes/Product.php:4952 
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 21, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 21) AND
`id_group` IN (0, 1) AND `id_product` = 10108494 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2025-01-16 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2025-01-16 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.6 1 Yes /classes/SpecificPrice.php:549 
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
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` = 10068260)
 0.6 1 /classes/Product.php:3342 
SELECT SQL_NO_CACHE COUNT(*) FROM `ps_orders` o
LEFT JOIN ps_order_cart_rule ocr ON (ocr.id_order = o.id_order)
WHERE o.id_customer = 0
AND ocr.id_cart_rule = 1154 LIMIT 1
 0.6 1 /classes/order/Order.php:822 
SELECT SQL_NO_CACHE c.*, cl.`id_lang`, cl.`name`, cl.`description`, cl.`link_rewrite`, cl.`meta_title`, cl.`meta_keywords`, cl.`meta_description`
FROM `ps_category` c
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND `id_lang` = 2  AND cl.id_shop = 1 )
LEFT JOIN `ps_category_group` cg ON (cg.`id_category` = c.`id_category`)
WHERE `id_parent` = 202
AND `active` = 1
AND cg.`id_group` =1
GROUP BY c.`id_category`
ORDER BY `level_depth` ASC, category_shop.`position` ASC
 0.6 1 Yes Yes /classes/Category.php:872 
SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop`
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE `id_lang` = 2
AND c.`id_parent` = 2
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
 0.6 8 Yes Yes /classes/Category.php:1098 
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` = 8796 AND ctg.`id_group` = 1 LIMIT 1
 0.6 1 /classes/Product.php:5502 
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
JOIN `ps_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `ps_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 2)
JOIN `ps_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (10068260) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
 0.6 1 Yes Yes /classes/Product.php:3860 
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 2
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 9424) AND (b.`id_shop` = 1) LIMIT 1
 0.6 1 /src/Adapter/EntityMapper.php:75 
SELECT SQL_NO_CACHE p.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2025-01-16 00:00:00',
INTERVAL 30 DAY
)
) > 0) as new
FROM ps_product p
LEFT JOIN ps_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 2
LEFT JOIN ps_stock_available sa
ON sa.id_product = p.id_product 
AND sa.id_shop = 1
WHERE p.id_product = 10068260
 0.6 1 /classes/ProductAssembler.php:90 
SELECT SQL_NO_CACHE *
FROM `ps_category` a0
LEFT JOIN `ps_category_lang` `a1` ON (a0.`id_category` = a1.`id_category`)
WHERE (a0.`nleft` < 69) AND (a0.`nright` > 70) AND (a1.`id_lang` = 2)
ORDER BY a0.`nleft` asc
 0.6 144 /classes/PrestaShopCollection.php:373 
SELECT SQL_NO_CACHE p.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2025-01-16 00:00:00',
INTERVAL 30 DAY
)
) > 0) as new
FROM ps_product p
LEFT JOIN ps_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 2
LEFT JOIN ps_stock_available sa
ON sa.id_product = p.id_product 
AND sa.id_shop = 1
WHERE p.id_product = 10001387
 0.6 1 /classes/ProductAssembler.php:90 
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` = 8796) LIMIT 1
 0.6 1 /src/Adapter/EntityMapper.php:75 
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` = 2
LEFT JOIN `ps_cms_shop` `c` ON a.`id_cms` = c.`id_cms` AND c.`id_shop` = 1
WHERE (a.`id_cms` = 3) AND (b.`id_shop` = 1) LIMIT 1
 0.6 1 /src/Adapter/EntityMapper.php:75 
SELECT SQL_NO_CACHE *
FROM `ps_manufacturer` a
LEFT JOIN `ps_manufacturer_lang` `b` ON a.`id_manufacturer` = b.`id_manufacturer` AND b.`id_lang` = 2
LEFT JOIN `ps_manufacturer_shop` `c` ON a.`id_manufacturer` = c.`id_manufacturer` AND c.`id_shop` = 1
WHERE (a.`id_manufacturer` = 7) LIMIT 1
 0.6 1 /src/Adapter/EntityMapper.php:75 
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` = 8796) AND (b.`id_shop` = 1) LIMIT 1
 0.6 1 /src/Adapter/EntityMapper.php:75 
SELECT SQL_NO_CACHE c.*, cl.*  FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 2 AND cl.id_shop = 1 ) WHERE c.`nleft` <= 69 AND c.`nright` >= 70 AND c.`nleft` >= 2 AND c.`nright` <= 1061 ORDER BY `nleft` DESC
 0.6 36 /classes/Category.php:1538 
SELECT SQL_NO_CACHE *
FROM `ps_product_lang` t
LEFT JOIN `ps_product_shop` ps ON t.`id_product` = ps.`id_product` AND t.`id_shop` = ps.`id_shop`
WHERE ((t.`link_rewrite` = 'pot-de-détente-bud-hgs-ktm-sx-65-2009-2015' OR t.`link_rewrite` = 'pot-de-d%C3%A9tente-bud-hgs-ktm-sx-65-2009-2015') AND t.`id_lang` = 2 AND ps.`id_shop` = 1 AND ps.`id_category_default` IN (202) AND ps.`active` = 1) LIMIT 1
 0.6 2 /modules/arseopro/classes/url/ArSeoProURLProduct.php:172 
SELECT SQL_NO_CACHE p.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2025-01-16 00:00:00',
INTERVAL 30 DAY
)
) > 0) as new
FROM ps_product p
LEFT JOIN ps_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 2
LEFT JOIN ps_stock_available sa
ON sa.id_product = p.id_product 
AND sa.id_shop = 1
WHERE p.id_product = 10016322
 0.6 1 /classes/ProductAssembler.php:90 
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `ps_image` i
INNER JOIN ps_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `ps_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 2)
WHERE i.`id_product` = 8796
ORDER BY `position`
 0.6 1 Yes /classes/Product.php:3042 
SELECT SQL_NO_CACHE t.*
FROM `ps_arseopro_meta` t
LEFT JOIN `ps_arseopro_meta_rel` `mr` ON t.id_rule = mr.id_rule
WHERE (mr.rel_object IN (0, '8796') AND t.id_lang IN(0, 2) AND t.rule_type = 'product' AND t.status = 1) LIMIT 1
 0.6 1 /modules/arseopro/classes/meta/models/ArSeoProMetaTable.php:127 
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 = 8796 LIMIT 1
 0.5 1 /classes/Product.php:845 
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 21, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 21) AND
`id_group` IN (0, 1) AND `id_product` = 10068252 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2025-01-16 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2025-01-16 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.5 1 Yes /classes/SpecificPrice.php:549 
SELECT SQL_NO_CACHE p.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2025-01-16 00:00:00',
INTERVAL 30 DAY
)
) > 0) as new
FROM ps_product p
LEFT JOIN ps_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 2
LEFT JOIN ps_stock_available sa
ON sa.id_product = p.id_product 
AND sa.id_shop = 1
WHERE p.id_product = 9424
 0.5 1 /classes/ProductAssembler.php:90 
SELECT SQL_NO_CACHE cl.`id_category` FROM `ps_category_lang` cl LEFT JOIN `ps_category` c ON cl.id_category = c.id_category WHERE cl.`id_shop` = 1 AND cl.`link_rewrite` = "expansions-et-collecteurs-rimotoshop" AND cl.`id_lang` = 2
 0.5 1 /modules/arseopro/classes/url/ArSeoProURLCategory.php:375 
SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT cp.`quantity` as first_level_quantity, 0 as pack_quantity
FROM `ps_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 10016322 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `ps_cart_product` cp JOIN `ps_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `ps_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 10016322 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 1 = 1
))) as q LIMIT 1
 0.5 0 /classes/Cart.php:1234 
SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 316 AND `id_shop` = 1 LIMIT 1
 0.5 1 /classes/module/Module.php:2277 
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.5 1 /src/Adapter/EntityMapper.php:75 
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 21, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 21) AND
`id_group` IN (0, 1) AND `id_product` = 10001387 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2025-01-16 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2025-01-16 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.5 1 Yes /classes/SpecificPrice.php:549 
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 21, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 21) AND
`id_group` IN (0, 1) AND `id_product` = 10066795 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2025-01-16 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2025-01-16 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.5 1 Yes /classes/SpecificPrice.php:549 
SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT cp.`quantity` as first_level_quantity, 0 as pack_quantity
FROM `ps_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 10108494 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `ps_cart_product` cp JOIN `ps_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `ps_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 10108494 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 1 = 1
))) as q LIMIT 1
 0.5 0 /classes/Cart.php:1234 
SELECT SQL_NO_CACHE id_cache_page FROM `ps_ets_superspeed_cache_page`
WHERE page="product" 
AND id_lang="2"
AND id_country = "21"
AND id_currency = "1"
AND id_shop="1"
AND user_agent=""
AND date_add > "2025-01-16 01:52:35"AND id_object="8796" AND has_customer=0 AND has_cart=0 LIMIT 1
 0.5 3 /modules/ets_superspeed/classes/cache.php:273 
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 2
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 8796) AND (b.`id_shop` = 1) LIMIT 1
 0.5 1 /src/Adapter/EntityMapper.php:75 
SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, pa.`reference`, pa.`ean13`, pa.`isbn`,pa.`upc`
FROM `ps_attribute` a
LEFT JOIN `ps_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 2)
LEFT JOIN `ps_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `ps_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
LEFT JOIN `ps_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 2)
WHERE pa.`id_product` = 10068260
AND pac.`id_product_attribute` = 0
AND agl.`id_lang` = 2
 0.5 0 /classes/Product.php:6176 
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.5 1 /src/Adapter/EntityMapper.php:75 
SELECT SQL_NO_CACHE * FROM `ps_hook_alias`
 0.5 83 /classes/Hook.php:244 
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` = 8796
AND image_shop.`cover` = 1 LIMIT 1
 0.5 1 /classes/Product.php:3064 
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` = 2
LEFT JOIN `ps_cms_shop` `c` ON a.`id_cms` = c.`id_cms` AND c.`id_shop` = 1
WHERE (a.`id_cms` = 1) AND (b.`id_shop` = 1) LIMIT 1
 0.5 1 /src/Adapter/EntityMapper.php:75 
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
 0.5 5 /classes/Language.php:1029 
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 2
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 202) AND (b.`id_shop` = 1) LIMIT 1
 0.5 1 /src/Adapter/EntityMapper.php:75 
SELECT SQL_NO_CACHE COUNT(*) FROM ps_lgcomments_productcomments WHERE id_product = 8796   AND active = 1 LIMIT 1
 0.5 1 /modules/lgcomments/classes/LGProductComment.php:72 
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position
FROM ps_feature_product pf
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 2)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 2)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 2)
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 10016322
ORDER BY f.position ASC
 0.5 4 Yes /classes/Product.php:4952 
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `ps_image` i
INNER JOIN ps_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `ps_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 2)
WHERE i.`id_product` = 10001387
ORDER BY `position`
 0.5 2 Yes /classes/Product.php:3042 
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `ps_image` i
INNER JOIN ps_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `ps_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 2)
WHERE i.`id_product` = 10066795
ORDER BY `position`
 0.5 1 Yes /classes/Product.php:3042 
SELECT SQL_NO_CACHE *
FROM `ps_currency` c
INNER JOIN ps_currency_shop currency_shop
ON (currency_shop.id_currency = c.id_currency AND currency_shop.id_shop = 1) WHERE `deleted` = 0 AND c.`active` = 1 ORDER BY `iso_code` ASC
 0.5 3 Yes /classes/Currency.php:302 
SELECT SQL_NO_CACHE crc.id_cart_rule
FROM ps_cart_rule_country crc
WHERE crc.id_cart_rule = 1174
AND crc.id_country = 8 LIMIT 1
 0.5 1 /classes/CartRule.php:477 
SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, pa.`reference`, pa.`ean13`, pa.`isbn`,pa.`upc`
FROM `ps_attribute` a
LEFT JOIN `ps_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 2)
LEFT JOIN `ps_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `ps_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
LEFT JOIN `ps_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 2)
WHERE pa.`id_product` = 10016322
AND pac.`id_product_attribute` = 0
AND agl.`id_lang` = 2
 0.5 0 /classes/Product.php:6176 
SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, pa.`reference`, pa.`ean13`, pa.`isbn`,pa.`upc`
FROM `ps_attribute` a
LEFT JOIN `ps_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 2)
LEFT JOIN `ps_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `ps_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
LEFT JOIN `ps_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 2)
WHERE pa.`id_product` = 10108494
AND pac.`id_product_attribute` = 0
AND agl.`id_lang` = 2
 0.5 0 /classes/Product.php:6176 
SELECT SQL_NO_CACHE COUNT(*) FROM ps_lgcomments_productcomments WHERE id_product = 8796 AND active = 1  AND stars >= 10 AND stars < 11 LIMIT 1
 0.5 1 /modules/lgcomments/classes/LGProductComment.php:183 
SELECT SQL_NO_CACHE cp.`id_product` as id
FROM `ps_category_product` cp
WHERE cp.`id_category` = 0
ORDER BY `position` ASC
 0.5 1 /classes/Category.php:1955 
SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT cp.`quantity` as first_level_quantity, 0 as pack_quantity
FROM `ps_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 9424 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `ps_cart_product` cp JOIN `ps_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `ps_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 9424 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 1 = 1
))) as q LIMIT 1
 0.5 0 /classes/Cart.php:1234 
SELECT SQL_NO_CACHE c.*, cl.*  FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 2 AND cl.id_shop = 1 ) WHERE c.`nleft` <= 69 AND c.`nright` >= 70 AND c.`nleft` >= 2 AND c.`nright` <= 1061 ORDER BY `nleft` DESC
 0.5 36 /classes/Category.php:1538 
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.5 0 /classes/tax/TaxRulesTaxManager.php:108 
SELECT SQL_NO_CACHE ctg.`id_group`
FROM ps_category_group ctg
WHERE ctg.`id_category` = 202 AND ctg.`id_group` = 1 LIMIT 1
 0.4 1 /classes/Category.php:1654 
SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, pa.`reference`, pa.`ean13`, pa.`isbn`,pa.`upc`
FROM `ps_attribute` a
LEFT JOIN `ps_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 2)
LEFT JOIN `ps_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `ps_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
LEFT JOIN `ps_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 2)
WHERE pa.`id_product` = 8796
AND pac.`id_product_attribute` = 0
AND agl.`id_lang` = 2
 0.4 0 /classes/Product.php:6176 
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.4 1 /classes/shop/Shop.php:201 
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.4 1 /classes/Cart.php:4013 
SELECT SQL_NO_CACHE *
FROM `ps_group_lang`
WHERE `id_group` = 1
 0.4 7 /src/Adapter/EntityMapper.php:82 
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position
FROM ps_feature_product pf
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 2)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 2)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 2)
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 9424
ORDER BY f.position ASC
 0.4 8 Yes /classes/Product.php:4952 
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `ps_image` i
INNER JOIN ps_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `ps_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 2)
WHERE i.`id_product` = 9424
ORDER BY `position`
 0.4 1 Yes /classes/Product.php:3042 
SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, pa.`reference`, pa.`ean13`, pa.`isbn`,pa.`upc`
FROM `ps_attribute` a
LEFT JOIN `ps_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 2)
LEFT JOIN `ps_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `ps_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
LEFT JOIN `ps_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 2)
WHERE pa.`id_product` = 9424
AND pac.`id_product_attribute` = 0
AND agl.`id_lang` = 2
 0.4 0 /classes/Product.php:6176 
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
JOIN `ps_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `ps_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 2)
JOIN `ps_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (9424) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
 0.4 1 Yes Yes /classes/Product.php:3860 
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position
FROM ps_feature_product pf
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 2)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 2)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 2)
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 10001387
ORDER BY f.position ASC
 0.4 8 Yes /classes/Product.php:4952 
SELECT SQL_NO_CACHE *
FROM `ps_shop` a
WHERE (a.`id_shop` = 1) LIMIT 1
 0.4 1 /src/Adapter/EntityMapper.php:75 
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "lgcookieslaw" LIMIT 1
 0.4 1 /classes/module/Module.php:2752 
SELECT SQL_NO_CACHE id_shop
FROM `ps_currency_shop`
WHERE `id_currency` = 1
AND id_shop = 1 LIMIT 1
 0.4 1 /classes/ObjectModel.php:1588 
SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT cp.`quantity` as first_level_quantity, 0 as pack_quantity
FROM `ps_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 10068252 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `ps_cart_product` cp JOIN `ps_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `ps_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 10068252 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 1 = 1
))) as q LIMIT 1
 0.4 0 /classes/Cart.php:1234 
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `ps_image` i
INNER JOIN ps_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `ps_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 2)
WHERE i.`id_product` = 10068260
ORDER BY `position`
 0.4 1 Yes /classes/Product.php:3042 
SELECT SQL_NO_CACHE DISTINCT c.*
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.`id_lang` = 2)
WHERE `level_depth` = 1
 0.4 4 /classes/Category.php:2130 
SELECT SQL_NO_CACHE 1 FROM `ps_specific_price` WHERE id_product = 0 LIMIT 1
 0.4 1 /classes/SpecificPrice.php:407 
SELECT SQL_NO_CACHE content FROM ps_lgcookieslaw_lang WHERE id_lang = 2 LIMIT 1
 0.4 1 /modules/lgcookieslaw/lgcookieslaw.php:161 
SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT cp.`quantity` as first_level_quantity, 0 as pack_quantity
FROM `ps_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 10001387 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `ps_cart_product` cp JOIN `ps_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `ps_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 10001387 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 1 = 1
))) as q LIMIT 1
 0.4 0 /classes/Cart.php:1234 
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `ps_image` i
INNER JOIN ps_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `ps_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 2)
WHERE i.`id_product` = 10016322
ORDER BY `position`
 0.4 1 Yes /classes/Product.php:3042 
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` = 202) LIMIT 1
 0.4 1 /src/Adapter/EntityMapper.php:75 
SELECT SQL_NO_CACHE * FROM `ps_image_type` WHERE 1 AND `products` = 1  ORDER BY `width` DESC, `height` DESC, `name`ASC
 0.4 8 Yes /classes/ImageType.php:109 
SELECT SQL_NO_CACHE p.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2025-01-16 00:00:00',
INTERVAL 30 DAY
)
) > 0) as new
FROM ps_product p
LEFT JOIN ps_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 2
LEFT JOIN ps_stock_available sa
ON sa.id_product = p.id_product 
AND sa.id_shop = 1
WHERE p.id_product = 10108494
 0.4 1 /classes/ProductAssembler.php:90 
SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT cp.`quantity` as first_level_quantity, 0 as pack_quantity
FROM `ps_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 10066795 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `ps_cart_product` cp JOIN `ps_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `ps_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 10066795 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 1 = 1
))) as q LIMIT 1
 0.4 0 /classes/Cart.php:1234 
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 9424
ORDER BY `id_specific_price_priority` DESC LIMIT 1
 0.4 0 /classes/SpecificPrice.php:246 
SELECT SQL_NO_CACHE 1 FROM `ps_specific_price` WHERE `from` BETWEEN '2025-01-16 00:00:00' AND '2025-01-16 23:59:59' LIMIT 1
 0.4 1 /classes/SpecificPrice.php:358 
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` = 3
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 8796) AND (b.`id_shop` = 1) LIMIT 1
 0.4 1 /src/Adapter/EntityMapper.php:75 
SELECT SQL_NO_CACHE * FROM `ps_fbpsc_connector_position`
 0.4 7 /modules/facebookpsconnect/lib/module-dao_class.php:366 
SELECT SQL_NO_CACHE domain, domain_ssl
FROM ps_shop_url
WHERE main = 1
AND id_shop = 1 LIMIT 1
 0.4 1 /classes/shop/ShopUrl.php:173 
SELECT SQL_NO_CACHE domain, domain_ssl
FROM ps_shop_url
WHERE main = 1
AND id_shop = 1 LIMIT 1
 0.4 1 /classes/shop/ShopUrl.php:173 
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_flush) as last_flush FROM `ps_smarty_last_flush` WHERE type='compile' LIMIT 1
 0.4 1 /classes/Smarty/SmartyCustom.php:96 
SELECT SQL_NO_CACHE * FROM `ps_hook_module_exceptions`
WHERE `id_shop` IN (1)
 0.4 1 /classes/module/Module.php:2188 
SELECT SQL_NO_CACHE `name`
FROM `ps_manufacturer`
WHERE `id_manufacturer` = 198
AND `active` = 1 LIMIT 1
 0.4 1 /classes/Manufacturer.php:310 
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `ps_product_attribute`
WHERE `id_product` = 10108494
 0.4 1 /classes/Product.php:2465 
SELECT SQL_NO_CACHE *
FROM `ps_product_lang`
WHERE `id_product` = 8796 AND `id_shop` = 1
 0.4 7 /src/Adapter/EntityMapper.php:82 
SELECT SQL_NO_CACHE COUNT(*) FROM `ps_pack` WHERE id_product_pack = 8796 LIMIT 1
 0.4 1 /classes/Pack.php:85 
SELECT SQL_NO_CACHE id_required_field, object_name, field_name
FROM ps_required_field
 0.4 1 /classes/ObjectModel.php:1453 
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='042be9fe6a5a7c11ed5038619a5d89ff' AND cache_id="angarcontact|1|1|1|2|1|21" AND compile_id="" LIMIT 1
 0.4 1 /classes/Smarty/SmartyCustom.php:216 
SELECT SQL_NO_CACHE 1 FROM `ps_specific_price` WHERE id_product = 10108494 LIMIT 1
 0.4 1 /classes/SpecificPrice.php:416 
SELECT SQL_NO_CACHE 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 = 8796
AND DATEDIFF(
product_shop.`date_add`,
DATE_SUB(
"2025-01-16 00:00:00",
INTERVAL 30 DAY
)
) > 0
 0.4 0 /classes/Product.php:1399 
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 2
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 10108494) AND (b.`id_shop` = 1) LIMIT 1
 0.4 1 /src/Adapter/EntityMapper.php:75 
SELECT SQL_NO_CACHE link_rewrite FROM ps_product_lang WHERE id_product = 8796 AND id_lang = 2 LIMIT 1
 0.4 1 /modules/lgconsultas/lgconsultas.php:257 
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` = 10) LIMIT 1
 0.4 1 /src/Adapter/EntityMapper.php:75 
SELECT SQL_NO_CACHE pa.id_product_attribute
FROM `ps_product_attribute` pa
WHERE pa.`id_product` = 8796
 0.4 1 /classes/Product.php:6145 
SELECT SQL_NO_CACHE SUM(stars) FROM ps_lgcomments_productcomments WHERE id_product = 8796   AND active = 1 LIMIT 1
 0.4 1 /modules/lgcomments/classes/LGProductComment.php:93 
SELECT SQL_NO_CACHE *
FROM `ps_state` a
WHERE (a.`id_state` = 130) LIMIT 1
 0.4 1 /src/Adapter/EntityMapper.php:75 
SELECT SQL_NO_CACHE *
FROM `ps_category_lang`
WHERE `id_category` = 12 AND `id_shop` = 1
 0.4 4 /src/Adapter/EntityMapper.php:82 
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='5828388db4bc450c21e463ddcb9b23a2' AND cache_id="stcolorname|1|1|1|2|1|21" AND compile_id="" LIMIT 1
 0.4 1 /classes/Smarty/SmartyCustom.php:216 
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='9dd148274295a11b4e73a2d53e0a5215' AND cache_id="angarcontact|1|1|1|2|1|21" AND compile_id="" LIMIT 1
 0.4 1 /classes/Smarty/SmartyCustom.php:216 
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position
FROM ps_feature_product pf
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 2)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 2)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 2)
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 10066795
ORDER BY f.position ASC
 0.4 4 Yes /classes/Product.php:4952 
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 2
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 10016322) AND (b.`id_shop` = 1) LIMIT 1
 0.4 1 /src/Adapter/EntityMapper.php:75 
SELECT SQL_NO_CACHE *
FROM `ps_category` a0
LEFT JOIN `ps_category_lang` `a1` ON (a0.`id_category` = a1.`id_category`)
WHERE (a0.`nleft` < 69) AND (a0.`nright` > 70) AND (a1.`id_lang` = 2)
ORDER BY a0.`nleft` asc
 0.4 144 /classes/PrestaShopCollection.php:373 
SELECT SQL_NO_CACHE name FROM ps_category_lang WHERE id_shop = 1 AND id_lang = 2 AND id_category = 202 LIMIT 1
 0.4 1 /classes/Product.php:4725 
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='845666cc9025ff8584ac98c9b4745957' AND cache_id="ps_categoryproducts|8796|202|1|1|1|2|1|21" AND compile_id="" LIMIT 1
 0.3 1 /classes/Smarty/SmartyCustom.php:216 
SELECT SQL_NO_CACHE *
FROM `ps_tax` a
WHERE (a.`id_tax` = 53) LIMIT 1
 0.3 1 /src/Adapter/EntityMapper.php:75 
SELECT SQL_NO_CACHE 1 FROM `ps_specific_price` WHERE id_product = 9424 LIMIT 1
 0.3 1 /classes/SpecificPrice.php:416 
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position
FROM ps_feature_product pf
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 2)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 2)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 2)
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 10068252
ORDER BY f.position ASC
 0.3 4 Yes /classes/Product.php:4952 
SELECT SQL_NO_CACHE *
FROM `ps_shop_group` a
WHERE (a.`id_shop_group` = 1) LIMIT 1
 0.3 1 /src/Adapter/EntityMapper.php:75 
SELECT SQL_NO_CACHE *
FROM `ps_tax_lang`
WHERE `id_tax` = 53
 0.3 7 /src/Adapter/EntityMapper.php:82 
SELECT SQL_NO_CACHE * FROM `ps_arseopro_canonical_product` WHERE `id_product`=8796 AND `id_lang`=2 AND `id_shop` = 1 LIMIT 1
 0.3 1 /modules/arseopro/classes/canonical/ArSeoProCanonicalProduct.php:50 
SELECT SQL_NO_CACHE `name` FROM `ps_supplier` WHERE `id_supplier` = 0 LIMIT 1
 0.3 0 /classes/Supplier.php:243 
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 2
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 2) AND (b.`id_shop` = 1) LIMIT 1
 0.3 1 /src/Adapter/EntityMapper.php:75 
SELECT SQL_NO_CACHE *
FROM `ps_country_lang`
WHERE `id_country` = 10
 0.3 4 /src/Adapter/EntityMapper.php:82 
SELECT SQL_NO_CACHE GROUP_CONCAT(a.`id_product_pack`)
FROM `ps_pack` a
WHERE a.`id_product_item` = 8796 LIMIT 1
 0.3 1 /classes/Pack.php:401 
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
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` = 10016322)
 0.3 1 /classes/Product.php:3342 
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 2
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 10068260) AND (b.`id_shop` = 1) LIMIT 1
 0.3 1 /src/Adapter/EntityMapper.php:75 
SELECT SQL_NO_CACHE format
FROM `ps_address_format`
WHERE `id_country` = 10 LIMIT 1
 0.3 1 /classes/AddressFormat.php:618 
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
JOIN `ps_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `ps_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 2)
JOIN `ps_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (10016322) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
 0.3 1 Yes Yes /classes/Product.php:3860 
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 2
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 10066795) AND (b.`id_shop` = 1) LIMIT 1
 0.3 1 /src/Adapter/EntityMapper.php:75 
SELECT SQL_NO_CACHE `id_guest`
FROM `ps_connections`
WHERE `id_guest` = 222770
AND `date_add` > '2025-01-16 01:37:00'
AND id_shop IN (1) 
ORDER BY `date_add` DESC LIMIT 1
 0.3 1 Yes /classes/Connection.php:163 
SELECT SQL_NO_CACHE `value` FROM ps_ce_meta WHERE `id` = 24010000 AND `name` = "_elementor_page_settings" LIMIT 1
 0.3 1 /modules/creativeelements/classes/wrappers/Post.php:273 
SELECT SQL_NO_CACHE name FROM ps_category_lang WHERE id_shop = 1 AND id_lang = 2 AND id_category = 202 LIMIT 1
 0.3 1 /classes/Product.php:4725 
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.3 1 /src/Adapter/EntityMapper.php:75 
SELECT SQL_NO_CACHE COUNT(*) FROM `ps_pack` WHERE id_product_pack = 10068260 LIMIT 1
 0.3 1 /classes/Pack.php:85 
SELECT SQL_NO_CACHE id_module FROM ps_lgcookieslaw;
 0.3 1 /override/classes/Hook.php:42 
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 2
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 10068252) AND (b.`id_shop` = 1) LIMIT 1
 0.3 1 /src/Adapter/EntityMapper.php:75 
SELECT SQL_NO_CACHE m.`id_module` as `active`, ms.`id_module` as `shop_active`
FROM `ps_module` m
LEFT JOIN `ps_module_shop` ms ON m.`id_module` = ms.`id_module`
WHERE `name` = "ps_categorytree"
AND ms.`id_shop` IN (1) LIMIT 1
 0.3 1 /src/Adapter/Module/ModuleDataProvider.php:174 
SELECT SQL_NO_CACHE link_rewrite FROM ps_product_lang WHERE id_product = 8796 AND id_lang = 2 LIMIT 1
 0.3 1 /modules/lgcomments/classes/LGProductComment.php:209 
SELECT SQL_NO_CACHE crc.id_cart_rule
FROM ps_cart_rule_country crc
WHERE crc.id_cart_rule = 1154
AND crc.id_country = 10 LIMIT 1
 0.3 1 /classes/CartRule.php:477 
SELECT SQL_NO_CACHE * FROM `ps_hook_alias`
 0.3 83 /classes/Hook.php:270 
SELECT SQL_NO_CACHE *
FROM `ps_category_lang`
WHERE `id_category` = 202 AND `id_shop` = 1
 0.3 4 /src/Adapter/EntityMapper.php:82 
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 10016322
ORDER BY `id_specific_price_priority` DESC LIMIT 1
 0.3 0 /classes/SpecificPrice.php:246 
SELECT SQL_NO_CACHE *
FROM `ps_country` a
LEFT JOIN `ps_country_lang` `b` ON a.`id_country` = b.`id_country` AND b.`id_lang` = 2
LEFT JOIN `ps_country_shop` `c` ON a.`id_country` = c.`id_country` AND c.`id_shop` = 1
WHERE (a.`id_country` = 21) LIMIT 1
 0.3 1 /src/Adapter/EntityMapper.php:75 
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 10068260 AND id_shop=1 LIMIT 1
 0.3 1 /classes/Product.php:5620 
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "ps_categorytree" LIMIT 1
 0.3 1 /src/Adapter/Module/ModuleDataProvider.php:185 
SELECT SQL_NO_CACHE COUNT(*) FROM `ps_orders` o
LEFT JOIN ps_order_cart_rule ocr ON (ocr.id_order = o.id_order)
WHERE o.id_customer = 0
AND ocr.id_cart_rule = 1174 LIMIT 1
 0.3 1 /classes/order/Order.php:822 
SELECT SQL_NO_CACHE `id_country`
FROM `ps_country`
WHERE `iso_code` = 'US' AND active = 1 LIMIT 1
 0.3 1 /classes/Country.php:192 
SELECT SQL_NO_CACHE `iso_code`
FROM `ps_country`
WHERE `id_country` = 10 LIMIT 1
 0.3 1 /classes/Country.php:272 
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
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` = 9424)
 0.3 1 /classes/Product.php:3342 
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 2
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 10001387) AND (b.`id_shop` = 1) LIMIT 1
 0.3 1 /src/Adapter/EntityMapper.php:75 
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "gformbuilderpro" LIMIT 1
 0.3 1 /classes/module/Module.php:2752 
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `ps_product_attribute`
WHERE `id_product` = 8796
 0.3 1 /classes/Product.php:2465 
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "arseopro" LIMIT 1
 0.3 1 /classes/module/Module.php:2752 
SELECT SQL_NO_CACHE value FROM `ps_configuration` WHERE `name` = "PS_MULTISHOP_FEATURE_ACTIVE" LIMIT 1
 0.3 1 /classes/shop/Shop.php:1160 
SELECT SQL_NO_CACHE id_product_item, id_product_attribute_item, quantity FROM `ps_pack` where id_product_pack = 8796
 0.3 1 /classes/Pack.php:160 
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "ybc_blog" LIMIT 1
 0.3 0 /classes/module/Module.php:2752 
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `ps_product_attribute`
WHERE `id_product` = 10066795
 0.3 1 /classes/Product.php:2465 
SELECT SQL_NO_CACHE name FROM ps_category_lang WHERE id_shop = 1 AND id_lang = 2 AND id_category = 202 LIMIT 1
 0.3 1 /classes/Product.php:4725 
SELECT SQL_NO_CACHE *
FROM `ps_ce_template` a
WHERE (a.`id_ce_template` = 24) LIMIT 1
 0.3 1 /src/Adapter/EntityMapper.php:75 
SELECT SQL_NO_CACHE 1 FROM `ps_specific_price` WHERE id_product = 10068260 LIMIT 1
 0.3 1 /classes/SpecificPrice.php:416 
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 10068260) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
 0.3 1 /classes/stock/StockAvailable.php:441 
SELECT SQL_NO_CACHE crc.id_cart_rule
FROM ps_cart_rule_country crc
WHERE crc.id_cart_rule = 1174
AND crc.id_country = 17 LIMIT 1
 0.3 0 /classes/CartRule.php:477 
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 8796
ORDER BY `id_specific_price_priority` DESC LIMIT 1
 0.3 0 /classes/SpecificPrice.php:246 
SELECT SQL_NO_CACHE id_shop
FROM `ps_product_shop`
WHERE `id_product` = 8796
AND id_shop = 1 LIMIT 1
 0.3 1 /classes/ObjectModel.php:1588 
SELECT SQL_NO_CACHE `reduction`
FROM `ps_product_group_reduction_cache`
WHERE `id_product` = 10068260 AND `id_group` = 1 LIMIT 1
 0.3 0 /classes/GroupReduction.php:151 
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`=8796
 0.3 1 /classes/Tag.php:229 
SELECT SQL_NO_CACHE *
FROM `ps_manufacturer` a
LEFT JOIN `ps_manufacturer_lang` `b` ON a.`id_manufacturer` = b.`id_manufacturer` AND b.`id_lang` = 2
LEFT JOIN `ps_manufacturer_shop` `c` ON a.`id_manufacturer` = c.`id_manufacturer` AND c.`id_shop` = 1
WHERE (a.`id_manufacturer` = 147) LIMIT 1
 0.3 1 /src/Adapter/EntityMapper.php:75 
SELECT SQL_NO_CACHE COUNT(*) FROM ps_lgcomments_productcomments WHERE id_product = 8796 AND active = 1  AND stars >= 6 AND stars < 8 LIMIT 1
 0.3 1 /modules/lgcomments/classes/LGProductComment.php:183 
SELECT SQL_NO_CACHE `name`
FROM `ps_manufacturer`
WHERE `id_manufacturer` = 7
AND `active` = 1 LIMIT 1
 0.3 1 /classes/Manufacturer.php:310 
SELECT SQL_NO_CACHE COUNT(*) FROM ps_lgcomments_productcomments WHERE id_product = 8796 AND active = 1  AND stars >= 8 AND stars < 10 LIMIT 1
 0.3 1 /modules/lgcomments/classes/LGProductComment.php:183 
SELECT SQL_NO_CACHE c.`nleft`, c.`nright`, c.`level_depth`
FROM `ps_category` c
WHERE (c.`id_category` = 2) LIMIT 1
 0.3 1 /classes/Category.php:1870 
SELECT SQL_NO_CACHE `id_country`
FROM `ps_country`
WHERE `iso_code` = 'US' AND active = 1 LIMIT 1
 0.3 1 /classes/Country.php:192 
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
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` = 8796)
 0.3 1 /classes/Product.php:3342 
SELECT SQL_NO_CACHE `id_country`
FROM `ps_country`
WHERE `iso_code` = 'US' AND active = 1 LIMIT 1
 0.3 1 /classes/Country.php:192 
SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, pa.`reference`, pa.`ean13`, pa.`isbn`,pa.`upc`
FROM `ps_attribute` a
LEFT JOIN `ps_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 2)
LEFT JOIN `ps_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `ps_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
LEFT JOIN `ps_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 2)
WHERE pa.`id_product` = 10001387
AND pac.`id_product_attribute` = 0
AND agl.`id_lang` = 2
 0.3 0 /classes/Product.php:6176 
SELECT SQL_NO_CACHE *
FROM `ps_category_lang`
WHERE `id_category` = 24 AND `id_shop` = 1
 0.3 4 /src/Adapter/EntityMapper.php:82 
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
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` = 10001387)
 0.3 1 /classes/Product.php:3342 
SELECT SQL_NO_CACHE `id_lang` FROM `ps_lang` WHERE `iso_code` = 'en' LIMIT 1
 0.3 5 /classes/Language.php:722 
SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 300 AND `id_shop` = 1 LIMIT 1
 0.3 1 /classes/module/Module.php:2277 
SELECT SQL_NO_CACHE 1 FROM `ps_specific_price` WHERE id_product = 8796 LIMIT 1
 0.3 1 /classes/SpecificPrice.php:416 
SELECT SQL_NO_CACHE *
FROM `ps_category_lang`
WHERE `id_category` = 2 AND `id_shop` = 1
 0.3 4 /src/Adapter/EntityMapper.php:82 
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_flush) as last_flush FROM `ps_smarty_last_flush` WHERE type='template' LIMIT 1
 0.3 1 /classes/Smarty/SmartyCustom.php:143 
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "ps_legalcompliance" LIMIT 1
 0.3 0 /classes/module/Module.php:2752 
SELECT SQL_NO_CACHE crc.id_cart_rule
FROM ps_cart_rule_country crc
WHERE crc.id_cart_rule = 1154
AND crc.id_country = 10 LIMIT 1
 0.3 1 /classes/CartRule.php:477 
SELECT SQL_NO_CACHE COUNT(*) FROM ps_lgcomments_productcomments WHERE id_product = 8796 AND active = 1  AND stars >= 0 AND stars < 2 LIMIT 1
 0.3 1 /modules/lgcomments/classes/LGProductComment.php:183 
SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, pa.`reference`, pa.`ean13`, pa.`isbn`,pa.`upc`
FROM `ps_attribute` a
LEFT JOIN `ps_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 2)
LEFT JOIN `ps_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `ps_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
LEFT JOIN `ps_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 2)
WHERE pa.`id_product` = 10066795
AND pac.`id_product_attribute` = 0
AND agl.`id_lang` = 2
 0.3 0 /classes/Product.php:6176 
SELECT SQL_NO_CACHE c.`nleft`, c.`nright`  FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 2 AND cl.id_shop = 1 ) WHERE c.`id_category` = 202 LIMIT 1
 0.3 1 /classes/Category.php:1523 
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "bestkit_opc" LIMIT 1
 0.3 0 /src/Adapter/Module/ModuleDataProvider.php:185 
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "ba_ajax_search" LIMIT 1
 0.3 0 /classes/module/Module.php:2752 
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 8796) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
 0.3 1 /classes/stock/StockAvailable.php:441 
SELECT SQL_NO_CACHE COUNT(*) FROM ps_lgcomments_productcomments WHERE id_product = 8796 AND active = 1  AND stars >= 4 AND stars < 6 LIMIT 1
 0.3 1 /modules/lgcomments/classes/LGProductComment.php:183 
SELECT SQL_NO_CACHE cl.`link_rewrite`
FROM `ps_category_lang` cl
WHERE `id_lang` = 5
AND cl.id_shop = 1 
AND cl.`id_category` = 202 LIMIT 1
 0.3 1 /classes/Category.php:1322 
SELECT SQL_NO_CACHE `id_page`
FROM `ps_page`
WHERE `id_page_type` = 3 AND `id_object` = 8796 LIMIT 1
 0.3 1 /classes/Page.php:80 
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `ps_product_attribute`
WHERE `id_product` = 10068260
 0.3 1 /classes/Product.php:2465 
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` = 2) LIMIT 1
 0.3 1 /src/Adapter/EntityMapper.php:75 
SELECT SQL_NO_CACHE COUNT(*) FROM ps_lgcomments_productcomments WHERE id_product = 8796 AND active = 1  AND stars >= 2 AND stars < 4 LIMIT 1
 0.3 1 /modules/lgcomments/classes/LGProductComment.php:183 
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "ets_superspeed" LIMIT 1
 0.3 1 /classes/module/Module.php:2752 
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 10068260
ORDER BY `id_specific_price_priority` DESC LIMIT 1
 0.3 0 /classes/SpecificPrice.php:246 
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` = 2) LIMIT 1
 0.3 1 /src/Adapter/EntityMapper.php:75 
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.3 1 /src/Adapter/EntityMapper.php:75 
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='4950df2c4bd12d027158e408f16ade3f' AND cache_id="angarcontact|1|1|1|2|1|21" AND compile_id="" LIMIT 1
 0.3 1 /classes/Smarty/SmartyCustom.php:216 
SELECT SQL_NO_CACHE `value` FROM ps_ce_meta WHERE `id` = 24010000 AND `name` = "_elementor_css" LIMIT 1
 0.3 1 /modules/creativeelements/classes/wrappers/Post.php:273 
SELECT SQL_NO_CACHE c.`nleft`, c.`nright`  FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 2 AND cl.id_shop = 1 ) WHERE c.`id_category` = 202 LIMIT 1
 0.2 1 /classes/Category.php:1523 
SELECT SQL_NO_CACHE COUNT(id_productcomment) FROM ps_lgcomments_productcomments WHERE id_customer = 0 AND id_product = 8796 LIMIT 1
 0.2 1 /modules/lgcomments/classes/LGProductComment.php:196 
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` = 24) LIMIT 1
 0.2 1 /src/Adapter/EntityMapper.php:75