Logitech G Pro Raton Inalambrico USB 16000dpi - 5 Botones Programables - Sensor Hero - Tecnologia Lightspeed - Uso Diestro - Color Negro

Logitech G Pro Raton Inalambrico USB 16000dpi - 5 Botones Programables - Sensor Hero - Tecnologia Lightspeed - Uso Diestro - Color Negro

131,76 €
Impuestos incluidos
PRO Wireless está pensado para ser el ratón para gaming definitivo para los profesionales de eSports. Durante un periodo de dos años, Logitech G colaboró con más de 50 jugadores profesionales para decidir la forma, el peso y la sensación perfectos que combinar con nuestras tecnologías LIGHTSPEED inalámbrica y de sensor HERO 16K. El resultado es un ratón para gaming con un rendimiento y una precisión inigualables, que proporciona las herramientas y la confianza necesarias para ganar. Los profesionales de eSports persiguen una velocidad y precisión cada vez mayores, y lo mismo hace Logitech G. Con la invención de HERO 16K, el sensor para gaming de próxima generación, llega un nuevo líder. HERO 16K se ha optimizado para PRO Wireless, con el fin de detectar desenfrenados gestos a velocidades superiores a 400 ips sin perder el control. HERO 16K ofrece un rendimiento máximo con cualquier configuración de sensibilidad, sin suavizado, aceleración ni filtrado, con valores de 100 a 16.000 dpi. Además HERO 16K consume 10 veces menos energía que sus predecesores (por ejemplo PMW3366), lo que permite usar una batería más ligera y de mayor duración. Los profesionales requ
Cantidad
Recíbelo en 24 horas laborales Últimas unidades en stock

ColorNegro
Load Time2023 ms - You'd better run your shop on a toaster
Querying Time1139 ms
Queries1090
Memory Peak Usage35.4 Mb
Included Files950 files - 10.07 Mb
PrestaShop Cache0.01 Mb
Global vars0.62 Mb
PrestaShop Version1.7.6.5
PHP Version7.3.33-24+0~20241224.123+debian12~1.gbp64cad4 (OK)
MySQL Version10.11.6-MariaDB-0+deb12u1 (OK)
Memory Limit1G
Max Execution Time1000s
Smarty Cacheenabled
Smarty Compilationauto
 TimeCumulated TimeMemory UsageMemory Peak Usage
config 21 ms 21 ms 3.31 Mb 3.31 Mb
__construct 0 ms 21 ms - Mb 3.31 Mb
init 44 ms 65 ms 3.56 Mb 7.04 Mb
checkAccess 0 ms 65 ms - Mb 7.04 Mb
setMedia 379 ms 444 ms 0.34 Mb 7.69 Mb
postProcess 0 ms 444 ms - Mb 7.69 Mb
initHeader - ms 444 ms - Mb 7.69 Mb
initContent 73 ms 517 ms 3.00 Mb 10.23 Mb
initFooter 0 ms 517 ms - Mb 10.23 Mb
display 1506 ms 2023 ms 24.87 Mb 35.42 Mb
Hook Time Memory Usage
0 hooks - ms - Mb
Module Time Memory Usage
0 modules - ms - Mb

Stopwatch SQL - 1090 queries

Query Time (ms) Rows Filesort Group By Location
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-02-17 00:00:00",
INTERVAL 35 DAY)) > 0 AS new, product_shop.price AS orderprice
FROM `ps_category_product` cp
LEFT JOIN `ps_product` p
ON p.`id_product` = cp.`id_product`
INNER JOIN ps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) LEFT JOIN `ps_product_attribute_shop` product_attribute_shop
ON (p.`id_product` = product_attribute_shop.`id_product` AND product_attribute_shop.`default_on` = 1 AND product_attribute_shop.id_shop=1)
LEFT JOIN ps_stock_available stock
ON (stock.id_product = `p`.id_product AND stock.id_product_attribute = 0 AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
LEFT JOIN `ps_category_lang` cl
ON (product_shop.`id_category_default` = cl.`id_category`
AND cl.`id_lang` = 1 AND cl.id_shop = 1 )
LEFT JOIN `ps_product_lang` pl
ON (p.`id_product` = pl.`id_product`
AND pl.`id_lang` = 1 AND pl.id_shop = 1 )
LEFT JOIN `ps_image_shop` image_shop
ON (image_shop.`id_product` = p.`id_product` AND image_shop.cover=1 AND image_shop.id_shop=1)
LEFT JOIN `ps_image_lang` il
ON (image_shop.`id_image` = il.`id_image`
AND il.`id_lang` = 1)
LEFT JOIN `ps_manufacturer` m
ON m.`id_manufacturer` = p.`id_manufacturer`
WHERE product_shop.`id_shop` = 1
AND cp.`id_category` = 1019 AND product_shop.`active` = 1 AND product_shop.`visibility` IN ("both", "catalog") ORDER BY RAND() LIMIT 17
842.3 29606 Yes /classes/Category.php:1047
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` = 1019 AND product_shop.`visibility` IN ("both", "catalog") AND product_shop.`active` = 1 LIMIT 1
57.8 29606 /classes/Category.php:976
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-02-17 00:00:00",
INTERVAL 35 DAY
)
) > 0 AS new
FROM `ps_accessory`
LEFT JOIN `ps_product` p ON p.`id_product` = `id_product_2`
INNER JOIN ps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_product_attribute_shop` product_attribute_shop
ON (p.`id_product` = product_attribute_shop.`id_product` AND product_attribute_shop.`default_on` = 1 AND product_attribute_shop.id_shop=1)
LEFT JOIN `ps_product_lang` pl ON (
p.`id_product` = pl.`id_product`
AND pl.`id_lang` = 1 AND pl.id_shop = 1 
)
LEFT JOIN `ps_category_lang` cl ON (
product_shop.`id_category_default` = cl.`id_category`
AND cl.`id_lang` = 1 AND cl.id_shop = 1 
)
LEFT JOIN `ps_image_shop` image_shop
ON (image_shop.`id_product` = p.`id_product` AND image_shop.cover=1 AND image_shop.id_shop=1)
LEFT JOIN `ps_image_lang` il ON (image_shop.`id_image` = il.`id_image` AND il.`id_lang` = 1)
LEFT JOIN `ps_manufacturer` m ON (p.`id_manufacturer`= m.`id_manufacturer`)
LEFT JOIN ps_stock_available stock
ON (stock.id_product = `p`.id_product AND stock.id_product_attribute = 0 AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
WHERE `id_product_1` = 15349 AND product_shop.`active` = 1 AND product_shop.`visibility` != 'none'
GROUP BY product_shop.id_product
6.1 1 Yes /classes/Product.php:4031
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-02-17 00:00:00",
INTERVAL 35 DAY
)
) > 0 AS new
FROM `ps_accessory`
LEFT JOIN `ps_product` p ON p.`id_product` = `id_product_2`
INNER JOIN ps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_product_attribute_shop` product_attribute_shop
ON (p.`id_product` = product_attribute_shop.`id_product` AND product_attribute_shop.`default_on` = 1 AND product_attribute_shop.id_shop=1)
LEFT JOIN `ps_product_lang` pl ON (
p.`id_product` = pl.`id_product`
AND pl.`id_lang` = 1 AND pl.id_shop = 1 
)
LEFT JOIN `ps_category_lang` cl ON (
product_shop.`id_category_default` = cl.`id_category`
AND cl.`id_lang` = 1 AND cl.id_shop = 1 
)
LEFT JOIN `ps_image_shop` image_shop
ON (image_shop.`id_product` = p.`id_product` AND image_shop.cover=1 AND image_shop.id_shop=1)
LEFT JOIN `ps_image_lang` il ON (image_shop.`id_image` = il.`id_image` AND il.`id_lang` = 1)
LEFT JOIN `ps_manufacturer` m ON (p.`id_manufacturer`= m.`id_manufacturer`)
LEFT JOIN ps_stock_available stock
ON (stock.id_product = `p`.id_product AND stock.id_product_attribute = 0 AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
WHERE `id_product_1` = 15349 AND product_shop.`active` = 1 AND product_shop.`visibility` != 'none'
GROUP BY product_shop.id_product
4.6 1 Yes /classes/Product.php:4031
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `ps_image` i
INNER JOIN ps_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `ps_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 1)
WHERE i.`id_product` = 36977
ORDER BY `position`
3.4 1 Yes /classes/Product.php:3059
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` = 1  AND cl.id_shop = 1 )
LEFT JOIN `ps_category_group` cg ON (cg.`id_category` = c.`id_category`)
WHERE `id_parent` = 1019
AND `active` = 1
AND cg.`id_group` =1
GROUP BY c.`id_category`
ORDER BY `level_depth` ASC, category_shop.`position` ASC
2.6 16 Yes Yes /classes/Category.php:909
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` = 1 AND cl.id_shop = 1 ) WHERE c.`nleft` <= 1191 AND c.`nright` >= 1606 AND c.`nleft` >= 2 AND c.`nright` <= 1961 ORDER BY `nleft` DESC
2.1 981 Yes /classes/Category.php:1575
SELECT SQL_NO_CACHE cl.*,c.*, cl.`name` country, z.`name` zone
FROM `ps_country` c  INNER JOIN ps_country_shop country_shop
ON (country_shop.id_country = c.id_country AND country_shop.id_shop = 1)
LEFT JOIN `ps_country_lang` cl ON (c.`id_country` = cl.`id_country` AND cl.`id_lang` = 1)
LEFT JOIN `ps_zone` z ON (z.`id_zone` = c.`id_zone`)
WHERE 1
ORDER BY cl.name ASC
2.1 244 Yes /classes/Country.php:147
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`
2.1 174 Yes Yes /classes/Hook.php:670
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`)
1.9 1210 /classes/Configuration.php:160
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `ps_image` i
INNER JOIN ps_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `ps_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 1)
WHERE i.`id_product` = 15349
ORDER BY `position`
1.8 1 Yes /classes/Product.php:3059
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
1.7 482 /classes/Hook.php:407
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 = 1)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 36977
ORDER BY f.position ASC
1.2 18 Yes /classes/Product.php:5020
SELECT SQL_NO_CACHE *
FROM `ps_category` a0
LEFT JOIN `ps_category_lang` `a1` ON (a0.`id_category` = a1.`id_category`)
WHERE (a0.`nleft` < 1191) AND (a0.`nright` > 1606) AND (a1.`id_lang` = 1)
ORDER BY a0.`nleft` asc
1.2 981 Yes /classes/PrestaShopCollection.php:381
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` = 6
AND tr.`id_tax_rules_group` = 11
AND tr.`id_state` IN (0, 335)
AND ('09006' BETWEEN tr.`zipcode_from` AND tr.`zipcode_to`
OR (tr.`zipcode_to` = 0 AND tr.`zipcode_from` IN(0, '09006')))
ORDER BY tr.`zipcode_from` DESC, tr.`zipcode_to` DESC, tr.`id_state` DESC, tr.`id_country` DESC
1.1 2 /classes/tax/TaxRulesTaxManager.php:108
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` = 1 AND cl.id_shop = 1 ) WHERE c.`nleft` <= 1362 AND c.`nright` >= 1397 AND c.`nleft` >= 2 AND c.`nright` <= 1961 ORDER BY `nleft` DESC
1.1 981 Yes /classes/Category.php:1575
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` = 15349
AND al.`id_lang` = 1
AND agl.`id_lang` = 1
GROUP BY id_attribute_group, id_product_attribute
ORDER BY ag.`position` ASC, a.`position` ASC, agl.`name` ASC
1.1 1 Yes Yes /classes/Product.php:3942
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 = 1)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 15349
ORDER BY f.position ASC
1.1 18 Yes /classes/Product.php:5020
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` = 15349 AND ctg.`id_group` = 1 LIMIT 1
1.1 3 /classes/Product.php:5576
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` = 1 AND cl.id_shop = 1 ) WHERE c.`nleft` <= 1375 AND c.`nright` >= 1376 AND c.`nleft` >= 2 AND c.`nright` <= 1961 ORDER BY `nleft` DESC
1 981 Yes /classes/Category.php:1575
SELECT SQL_NO_CACHE p.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2025-02-17 00:00:00',
INTERVAL 35 DAY
)
) > 0) as new
FROM ps_product p
LEFT JOIN ps_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 1
LEFT JOIN ps_stock_available sa
ON sa.id_product = p.id_product 
AND sa.id_shop = 1
WHERE p.id_product = 15333
0.9 1 /classes/ProductAssembler.php:90
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` = 1)
LEFT JOIN `ps_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
LEFT JOIN `ps_product_attribute_combination` pac
ON (a.`id_attribute` = pac.`id_attribute`)
LEFT JOIN `ps_product_attribute` pa
ON (pac.`id_product_attribute` = pa.`id_product_attribute`)
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
INNER JOIN ps_attribute_shop attribute_shop
ON (attribute_shop.id_attribute = pac.id_attribute AND attribute_shop.id_shop = 1)
WHERE pa.`id_product` = 15349
0.9 1 /classes/Product.php:6285
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` = 6
AND tr.`id_tax_rules_group` = 1
AND tr.`id_state` IN (0, 335)
AND ('09006' BETWEEN tr.`zipcode_from` AND tr.`zipcode_to`
OR (tr.`zipcode_to` = 0 AND tr.`zipcode_from` IN(0, '09006')))
ORDER BY tr.`zipcode_from` DESC, tr.`zipcode_to` DESC, tr.`id_state` DESC, tr.`id_country` DESC
0.9 2 /classes/tax/TaxRulesTaxManager.php:108
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `ps_image` i
INNER JOIN ps_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `ps_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 1)
WHERE i.`id_product` = 19486
ORDER BY `position`
0.9 1 Yes /classes/Product.php:3059
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `ps_image` i
INNER JOIN ps_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `ps_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 1)
WHERE i.`id_product` = 39405
ORDER BY `position`
0.9 1 Yes /classes/Product.php:3059
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `ps_image` i
INNER JOIN ps_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `ps_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 1)
WHERE i.`id_product` = 24381
ORDER BY `position`
0.9 1 Yes /classes/Product.php:3059
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `ps_image` i
INNER JOIN ps_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `ps_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 1)
WHERE i.`id_product` = 13689
ORDER BY `position`
0.9 1 Yes /classes/Product.php:3059
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `ps_image` i
INNER JOIN ps_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `ps_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 1)
WHERE i.`id_product` = 15333
ORDER BY `position`
0.9 1 Yes /classes/Product.php:3059
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` = 36977 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` = 36977 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
0.8 0 /classes/Cart.php:1238
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `ps_image` i
INNER JOIN ps_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `ps_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 1)
WHERE i.`id_product` = 30477
ORDER BY `position`
0.8 1 Yes /classes/Product.php:3059
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `ps_image` i
INNER JOIN ps_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `ps_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 1)
WHERE i.`id_product` = 44181
ORDER BY `position`
0.8 1 Yes /classes/Product.php:3059
SELECT SQL_NO_CACHE *,
( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 6, 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, 6) AND
`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2025-02-17 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2025-02-17 00:00:00' <= `to`)
ORDER BY `from_quantity` ASC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC
0.8 1 Yes /classes/SpecificPrice.php:620
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
0.8 0 /classes/Hook.php:194
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `ps_image` i
INNER JOIN ps_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `ps_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 1)
WHERE i.`id_product` = 49337
ORDER BY `position`
0.8 1 Yes /classes/Product.php:3059
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `ps_image` i
INNER JOIN ps_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `ps_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 1)
WHERE i.`id_product` = 27449
ORDER BY `position`
0.8 1 Yes /classes/Product.php:3059
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` = 15349) AND (b.`id_shop` = 1) LIMIT 1
0.8 1 /src/Adapter/EntityMapper.php:75
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` = 15349 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` = 15349 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
0.8 0 /classes/Cart.php:1238
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `ps_image` i
INNER JOIN ps_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `ps_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 1)
WHERE i.`id_product` = 28336
ORDER BY `position`
0.7 1 Yes /classes/Product.php:3059
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `ps_image` i
INNER JOIN ps_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `ps_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 1)
WHERE i.`id_product` = 42466
ORDER BY `position`
0.7 1 Yes /classes/Product.php:3059
SELECT SQL_NO_CACHE p.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2025-02-17 00:00:00',
INTERVAL 35 DAY
)
) > 0) as new
FROM ps_product p
LEFT JOIN ps_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 1
LEFT JOIN ps_stock_available sa
ON sa.id_product = p.id_product 
AND sa.id_shop = 1
WHERE p.id_product = 13689
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` = 1)
WHERE i.`id_product` = 42923
ORDER BY `position`
0.7 1 Yes /classes/Product.php:3059
SELECT SQL_NO_CACHE *
FROM `ps_advancedpopup`
INNER JOIN `ps_advancedpopup_lang` ON `ps_advancedpopup`.`id_advancedpopup` = `ps_advancedpopup_lang`.`id_advancedpopup`
WHERE `id_shop` = 1 AND `id_lang` = 1 AND `active` = 1
AND (`date_init` <= "2025-02-17 11:18:36" OR `date_init` = "1970-01-01 01:00:00")
AND (`date_end` >= "2025-02-17 11:18:36" OR `date_end` = "1970-01-01 01:00:00")
AND (`customers` = ""
OR `customers` IS NULL
OR FIND_IN_SET("0", `customers`))
AND (`languages` = ""
OR `languages` IS NULL
OR FIND_IN_SET("1", `languages`))
AND (`display_ip_string` = ""
OR `display_ip_string` IS NULL
OR FIND_IN_SET("18.97.9.168", `display_ip_string`))
AND (`genders` = ""
OR `genders` IS NULL) AND (`groups` = ""
OR `groups` IS NULL  OR FIND_IN_SET(1, `groups`)) AND `display_desktop` = 1 AND (`cms` = ""
OR `cms` IS NULL) AND (`controller_exceptions` = ""
OR `controller_exceptions` IS NULL
OR FIND_IN_SET("product", `controller_exceptions`)) AND (`display_after_cart` = 1
OR (`products` = ""
OR `products` IS NULL
OR FIND_IN_SET(15349, `products`))) AND (`categories` = ""
OR `categories` IS NULL  OR FIND_IN_SET(1019, `categories`) OR FIND_IN_SET(2825, `categories`) OR FIND_IN_SET(2947, `categories`)) AND (`display_after_cart` = 1
OR (`manufacturers` = ""
OR `manufacturers` IS NULL
OR FIND_IN_SET("67", `manufacturers`))) AND (`display_after_cart` = 1
OR (`suppliers` = ""
OR `suppliers` IS NULL
OR FIND_IN_SET("0", `suppliers`))) ORDER BY `priority` ASC;
0.7 1 Yes /modules/advancedpopupcreator/classes/AdvancedPopup.php:388
SELECT SQL_NO_CACHE p.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2025-02-17 00:00:00',
INTERVAL 35 DAY
)
) > 0) as new
FROM ps_product p
LEFT JOIN ps_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 1
LEFT JOIN ps_stock_available sa
ON sa.id_product = p.id_product 
AND sa.id_shop = 1
WHERE p.id_product = 26413
0.6 1 /classes/ProductAssembler.php:90
SELECT SQL_NO_CACHE p.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2025-02-17 00:00:00',
INTERVAL 35 DAY
)
) > 0) as new
FROM ps_product p
LEFT JOIN ps_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 1
LEFT JOIN ps_stock_available sa
ON sa.id_product = p.id_product 
AND sa.id_shop = 1
WHERE p.id_product = 24381
0.6 1 /classes/ProductAssembler.php:90
SELECT SQL_NO_CACHE p.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2025-02-17 00:00:00',
INTERVAL 35 DAY
)
) > 0) as new
FROM ps_product p
LEFT JOIN ps_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 1
LEFT JOIN ps_stock_available sa
ON sa.id_product = p.id_product 
AND sa.id_shop = 1
WHERE p.id_product = 19486
0.6 1 /classes/ProductAssembler.php:90
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` = 1
LEFT JOIN `ps_manufacturer_shop` `c` ON a.`id_manufacturer` = c.`id_manufacturer` AND c.`id_shop` = 1
WHERE (a.`id_manufacturer` = 67) 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-02-17 00:00:00',
INTERVAL 35 DAY
)
) > 0) as new
FROM ps_product p
LEFT JOIN ps_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 1
LEFT JOIN ps_stock_available sa
ON sa.id_product = p.id_product 
AND sa.id_shop = 1
WHERE p.id_product = 42466
0.6 1 /classes/ProductAssembler.php:90
SELECT SQL_NO_CACHE p.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2025-02-17 00:00:00',
INTERVAL 35 DAY
)
) > 0) as new
FROM ps_product p
LEFT JOIN ps_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 1
LEFT JOIN ps_stock_available sa
ON sa.id_product = p.id_product 
AND sa.id_shop = 1
WHERE p.id_product = 36977
0.5 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` = 1)
WHERE i.`id_product` = 13680
ORDER BY `position`
0.5 1 Yes /classes/Product.php:3059
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` = 1)
LEFT JOIN `ps_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
LEFT JOIN `ps_product_attribute_combination` pac
ON (a.`id_attribute` = pac.`id_attribute`)
LEFT JOIN `ps_product_attribute` pa
ON (pac.`id_product_attribute` = pa.`id_product_attribute`)
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
INNER JOIN ps_attribute_shop attribute_shop
ON (attribute_shop.id_attribute = pac.id_attribute AND attribute_shop.id_shop = 1)
WHERE pa.`id_product` = 15349
0.5 1 /classes/Product.php:6285
SELECT SQL_NO_CACHE * FROM `ps_state` ORDER BY `name` ASC
0.5 376 Yes /classes/Country.php:154
SELECT SQL_NO_CACHE * FROM ps_beappimagefooter WHERE `id_lang` = "1" and `id_store`="1" LIMIT 1
0.5 1 /modules/beappimagefooter/beappimagefooter.php:778
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `ps_image` i
INNER JOIN ps_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `ps_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 1)
WHERE i.`id_product` = 36330
ORDER BY `position`
0.5 1 Yes /classes/Product.php:3059
SELECT SQL_NO_CACHE 1 FROM `ps_specific_price` WHERE id_product = 0 LIMIT 1
0.5 1 /classes/SpecificPrice.php:407
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
JOIN `ps_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `ps_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1)
JOIN `ps_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (13689) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
0.5 1 Yes Yes /classes/Product.php:3887
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
JOIN `ps_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `ps_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1)
JOIN `ps_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (42923) 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:3887
SELECT SQL_NO_CACHE *
FROM `ps_product_lang`
WHERE `id_product` = 15349 AND `id_shop` = 1
0.4 1 /src/Adapter/EntityMapper.php:82
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
JOIN `ps_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `ps_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1)
JOIN `ps_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (49337) 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:3887
SELECT SQL_NO_CACHE p.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2025-02-17 00:00:00',
INTERVAL 35 DAY
)
) > 0) as new
FROM ps_product p
LEFT JOIN ps_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 1
LEFT JOIN ps_stock_available sa
ON sa.id_product = p.id_product 
AND sa.id_shop = 1
WHERE p.id_product = 49337
0.4 1 /classes/ProductAssembler.php:90
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
JOIN `ps_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `ps_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1)
JOIN `ps_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (15333) 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:3887
SELECT SQL_NO_CACHE p.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2025-02-17 00:00:00',
INTERVAL 35 DAY
)
) > 0) as new
FROM ps_product p
LEFT JOIN ps_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 1
LEFT JOIN ps_stock_available sa
ON sa.id_product = p.id_product 
AND sa.id_shop = 1
WHERE p.id_product = 13680
0.4 1 /classes/ProductAssembler.php:90
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
JOIN `ps_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `ps_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1)
JOIN `ps_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (30477) 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:3887
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
JOIN `ps_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `ps_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1)
JOIN `ps_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (39405) 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:3887
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` = 1)
WHERE `level_depth` = 1
0.4 1 /classes/Category.php:2167
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 13689) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.4 1 /classes/stock/StockAvailable.php:444
SELECT SQL_NO_CACHE p.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2025-02-17 00:00:00',
INTERVAL 35 DAY
)
) > 0) as new
FROM ps_product p
LEFT JOIN ps_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 1
LEFT JOIN ps_stock_available sa
ON sa.id_product = p.id_product 
AND sa.id_shop = 1
WHERE p.id_product = 44181
0.4 1 /classes/ProductAssembler.php:90
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
JOIN `ps_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `ps_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1)
JOIN `ps_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (27449) 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:3887
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
JOIN `ps_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `ps_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1)
JOIN `ps_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (36330) 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:3887
SELECT SQL_NO_CACHE p.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2025-02-17 00:00:00',
INTERVAL 35 DAY
)
) > 0) as new
FROM ps_product p
LEFT JOIN ps_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 1
LEFT JOIN ps_stock_available sa
ON sa.id_product = p.id_product 
AND sa.id_shop = 1
WHERE p.id_product = 36330
0.4 1 /classes/ProductAssembler.php:90
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
JOIN `ps_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `ps_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1)
JOIN `ps_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (44181) 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:3887
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 = 1)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 36330
ORDER BY f.position ASC
0.4 18 Yes /classes/Product.php:5020
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
JOIN `ps_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `ps_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1)
JOIN `ps_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (13680) 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:3887
SELECT SQL_NO_CACHE * FROM `ps_whatsappchatblock` LEFT JOIN `ps_whatsappchatblock_lang` ON (`ps_whatsappchatblock`.`id_whatsappchatblock` = `ps_whatsappchatblock_lang`.`id_whatsappchatblock` AND `id_lang` = 1) WHERE `id_hook` = "badge" AND `id_shop` = 1 AND `active` = 1 ORDER BY position DESC;
0.4 1 Yes /modules/whatsappchat/classes/WhatsappChatBlock.php:130
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position
FROM ps_feature_product pf
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 49337
ORDER BY f.position ASC
0.4 18 Yes /classes/Product.php:5020
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 = 1)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 24381
ORDER BY f.position ASC
0.4 18 Yes /classes/Product.php:5020
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 = 1)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 19486
ORDER BY f.position ASC
0.4 18 Yes /classes/Product.php:5020
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
JOIN `ps_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `ps_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1)
JOIN `ps_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (28336) 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:3887
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 2825) AND (b.`id_shop` = 1) LIMIT 1
0.4 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-02-17 00:00:00',
INTERVAL 35 DAY
)
) > 0) as new
FROM ps_product p
LEFT JOIN ps_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 1
LEFT JOIN ps_stock_available sa
ON sa.id_product = p.id_product 
AND sa.id_shop = 1
WHERE p.id_product = 27449
0.4 1 /classes/ProductAssembler.php:90
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 = 1)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 39405
ORDER BY f.position ASC
0.4 18 Yes /classes/Product.php:5020
SELECT SQL_NO_CACHE p.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2025-02-17 00:00:00',
INTERVAL 35 DAY
)
) > 0) as new
FROM ps_product p
LEFT JOIN ps_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 1
LEFT JOIN ps_stock_available sa
ON sa.id_product = p.id_product 
AND sa.id_shop = 1
WHERE p.id_product = 30477
0.4 1 /classes/ProductAssembler.php:90
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 = 1)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 15333
ORDER BY f.position ASC
0.4 18 Yes /classes/Product.php:5020
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
JOIN `ps_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `ps_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1)
JOIN `ps_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (36977) 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:3887
SELECT SQL_NO_CACHE * FROM ps_beappheadertext WHERE `id_lang` = "1" and `id_store`="1" LIMIT 1
0.4 1 /modules/beappheadertext/beappheadertext.php:775
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 = 1)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 13689
ORDER BY f.position ASC
0.4 18 Yes /classes/Product.php:5020
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
JOIN `ps_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `ps_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1)
JOIN `ps_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (19486) 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:3887
SELECT SQL_NO_CACHE GROUP_CONCAT(a.`id_product_pack`)
FROM `ps_pack` a
WHERE a.`id_product_item` = 15349 LIMIT 1
0.4 1 /classes/Pack.php:401
SELECT SQL_NO_CACHE `id_customer`
FROM `ps_customer`
WHERE `id_customer` = '0'
AND active = 1
AND `deleted` = 0 LIMIT 1
0.4 0 /classes/Customer.php:483
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 = 1)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 42466
ORDER BY f.position ASC
0.4 18 Yes /classes/Product.php:5020
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 = 1)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 23007
ORDER BY f.position ASC
0.4 18 Yes /classes/Product.php:5020
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.4 121 /classes/module/Module.php:307
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` = 42466) AND (b.`id_shop` = 1) LIMIT 1
0.4 1 /src/Adapter/EntityMapper.php:75
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 = 1)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 30477
ORDER BY f.position ASC
0.4 18 Yes /classes/Product.php:5020
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 = 1)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 26413
ORDER BY f.position ASC
0.4 18 Yes /classes/Product.php:5020
SELECT SQL_NO_CACHE 1 FROM `ps_specific_price` WHERE id_product = 36977 LIMIT 1
0.4 1 /classes/SpecificPrice.php:416
SELECT SQL_NO_CACHE gi.* FROM `ps_groupinc_configuration` gi  WHERE (date_from <= "2025-02-17 11:18:36" OR date_from = "0000-00-00 00:00:00") AND (date_to >= "2025-02-17 11:18:36" OR date_to = "0000-00-00 00:00:00") AND gi.`id_shop` = 1 AND gi.`active` = 1  AND (gi.groups = ""  OR FIND_IN_SET(1, REPLACE(gi.groups, ";", ",")) > 0) AND (gi.suppliers = "" ) AND (gi.currencies = "" OR FIND_IN_SET(1, REPLACE(gi.currencies, ";", ",")) > 0) AND (gi.languages = "" OR FIND_IN_SET(1, REPLACE(gi.languages, ";", ",")) > 0)
0.4 1 /modules/groupinc/classes/GroupincConfiguration.php:449
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 26413) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.4 1 /classes/stock/StockAvailable.php:444
SELECT SQL_NO_CACHE gi.* FROM `ps_groupinc_configuration` gi  WHERE (date_from <= "2025-02-17 11:18:36" OR date_from = "0000-00-00 00:00:00") AND (date_to >= "2025-02-17 11:18:36" OR date_to = "0000-00-00 00:00:00") AND gi.`id_shop` = 1 AND gi.`active` = 1  AND (gi.groups = ""  OR FIND_IN_SET(1, REPLACE(gi.groups, ";", ",")) > 0) AND (gi.suppliers = "" ) AND (gi.currencies = "" OR FIND_IN_SET(1, REPLACE(gi.currencies, ";", ",")) > 0) AND (gi.languages = "" OR FIND_IN_SET(1, REPLACE(gi.languages, ";", ",")) > 0)
0.4 1 /modules/groupinc/classes/GroupincConfiguration.php:449
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
JOIN `ps_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `ps_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1)
JOIN `ps_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (24381) 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:3887
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 27449) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.4 1 /classes/stock/StockAvailable.php:444
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 = 1)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 42923
ORDER BY f.position ASC
0.4 18 Yes /classes/Product.php:5020
SELECT SQL_NO_CACHE p.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2025-02-17 00:00:00',
INTERVAL 35 DAY
)
) > 0) as new
FROM ps_product p
LEFT JOIN ps_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 1
LEFT JOIN ps_stock_available sa
ON sa.id_product = p.id_product 
AND sa.id_shop = 1
WHERE p.id_product = 28336
0.4 1 /classes/ProductAssembler.php:90
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 15349) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.4 1 /classes/stock/StockAvailable.php:444
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 15333) AND (b.`id_shop` = 1) LIMIT 1
0.4 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE gi.* FROM `ps_groupinc_configuration` gi  WHERE (date_from <= "2025-02-17 11:18:36" OR date_from = "0000-00-00 00:00:00") AND (date_to >= "2025-02-17 11:18:36" OR date_to = "0000-00-00 00:00:00") AND gi.`id_shop` = 1 AND gi.`active` = 1  AND (gi.groups = ""  OR FIND_IN_SET(1, REPLACE(gi.groups, ";", ",")) > 0) AND (gi.suppliers = "" ) AND (gi.currencies = "" OR FIND_IN_SET(1, REPLACE(gi.currencies, ";", ",")) > 0) AND (gi.languages = "" OR FIND_IN_SET(1, REPLACE(gi.languages, ";", ",")) > 0)
0.4 1 /modules/groupinc/classes/GroupincConfiguration.php:449
SELECT SQL_NO_CACHE gi.* FROM `ps_groupinc_configuration` gi  WHERE (date_from <= "2025-02-17 11:18:36" OR date_from = "0000-00-00 00:00:00") AND (date_to >= "2025-02-17 11:18:36" OR date_to = "0000-00-00 00:00:00") AND gi.`id_shop` = 1 AND gi.`active` = 1  AND (gi.groups = ""  OR FIND_IN_SET(1, REPLACE(gi.groups, ";", ",")) > 0) AND (gi.suppliers = "" ) AND (gi.currencies = "" OR FIND_IN_SET(1, REPLACE(gi.currencies, ";", ",")) > 0) AND (gi.languages = "" OR FIND_IN_SET(1, REPLACE(gi.languages, ";", ",")) > 0)
0.4 1 /modules/groupinc/classes/GroupincConfiguration.php:449
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 = 1)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 44181
ORDER BY f.position ASC
0.4 18 Yes /classes/Product.php:5020
SELECT SQL_NO_CACHE gi.* FROM `ps_groupinc_configuration` gi  WHERE (date_from <= "2025-02-17 11:18:36" OR date_from = "0000-00-00 00:00:00") AND (date_to >= "2025-02-17 11:18:36" OR date_to = "0000-00-00 00:00:00") AND gi.`id_shop` = 1 AND gi.`active` = 1  AND show_on_sale = 1  AND (gi.groups = ""  OR FIND_IN_SET(1, REPLACE(gi.groups, ";", ",")) > 0) AND (gi.suppliers = "" ) AND (gi.currencies = "" OR FIND_IN_SET(1, REPLACE(gi.currencies, ";", ",")) > 0) AND (gi.languages = "" OR FIND_IN_SET(1, REPLACE(gi.languages, ";", ",")) > 0)
0.4 1 /modules/groupinc/classes/GroupincConfiguration.php:449
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 = 1)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 28336
ORDER BY f.position ASC
0.4 18 Yes /classes/Product.php:5020
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
JOIN `ps_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `ps_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1)
JOIN `ps_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (42466) 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:3887
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` = 15349)
0.3 1 /classes/Product.php:3364
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` = 27449 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` = 27449 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
0.3 0 /classes/Cart.php:1238
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` = 24381) AND (b.`id_shop` = 1) LIMIT 1
0.3 1 /src/Adapter/EntityMapper.php:75
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` = 24381 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` = 24381 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
0.3 0 /classes/Cart.php:1238
SELECT SQL_NO_CACHE gi.* FROM `ps_groupinc_configuration` gi  WHERE (date_from <= "2025-02-17 11:18:35" OR date_from = "0000-00-00 00:00:00") AND (date_to >= "2025-02-17 11:18:35" OR date_to = "0000-00-00 00:00:00") AND gi.`id_shop` = 1 AND gi.`active` = 1  AND (gi.groups = ""  OR FIND_IN_SET(1, REPLACE(gi.groups, ";", ",")) > 0) AND (gi.suppliers = "" ) AND (gi.currencies = "" OR FIND_IN_SET(1, REPLACE(gi.currencies, ";", ",")) > 0) AND (gi.languages = "" OR FIND_IN_SET(1, REPLACE(gi.languages, ";", ",")) > 0)
0.3 1 /modules/groupinc/classes/GroupincConfiguration.php:449
SELECT SQL_NO_CACHE gi.* FROM `ps_groupinc_configuration` gi  WHERE (date_from <= "2025-02-17 11:18:35" OR date_from = "0000-00-00 00:00:00") AND (date_to >= "2025-02-17 11:18:35" OR date_to = "0000-00-00 00:00:00") AND gi.`id_shop` = 1 AND gi.`active` = 1  AND (gi.groups = ""  OR FIND_IN_SET(1, REPLACE(gi.groups, ";", ",")) > 0) AND (gi.suppliers = "" ) AND (gi.currencies = "" OR FIND_IN_SET(1, REPLACE(gi.currencies, ";", ",")) > 0) AND (gi.languages = "" OR FIND_IN_SET(1, REPLACE(gi.languages, ";", ",")) > 0)
0.3 1 /modules/groupinc/classes/GroupincConfiguration.php:449
SELECT SQL_NO_CACHE `id_category` FROM `ps_category_product`
WHERE `id_product` = 15349
0.3 3 /classes/Product.php:2948
SELECT SQL_NO_CACHE gi.* FROM `ps_groupinc_configuration` gi  WHERE (date_from <= "2025-02-17 11:18:35" OR date_from = "0000-00-00 00:00:00") AND (date_to >= "2025-02-17 11:18:35" OR date_to = "0000-00-00 00:00:00") AND gi.`id_shop` = 1 AND gi.`active` = 1  AND product_qty > 1  AND (gi.groups = ""  OR FIND_IN_SET(1, REPLACE(gi.groups, ";", ",")) > 0) AND (gi.suppliers = "" ) AND (gi.currencies = "" OR FIND_IN_SET(1, REPLACE(gi.currencies, ";", ",")) > 0) AND (gi.languages = "" OR FIND_IN_SET(1, REPLACE(gi.languages, ";", ",")) > 0)
0.3 1 /modules/groupinc/classes/GroupincConfiguration.php:449
SELECT SQL_NO_CACHE gi.* FROM `ps_groupinc_configuration` gi  WHERE (date_from <= "2025-02-17 11:18:35" OR date_from = "0000-00-00 00:00:00") AND (date_to >= "2025-02-17 11:18:35" OR date_to = "0000-00-00 00:00:00") AND gi.`id_shop` = 1 AND gi.`active` = 1  AND (gi.groups = ""  OR FIND_IN_SET(1, REPLACE(gi.groups, ";", ",")) > 0) AND (gi.suppliers = "" ) AND (gi.currencies = "" OR FIND_IN_SET(1, REPLACE(gi.currencies, ";", ",")) > 0) AND (gi.languages = "" OR FIND_IN_SET(1, REPLACE(gi.languages, ";", ",")) > 0)
0.3 1 /modules/groupinc/classes/GroupincConfiguration.php:449
SELECT SQL_NO_CACHE * FROM `ps_whatsappchatblock` LEFT JOIN `ps_whatsappchatblock_lang` ON (`ps_whatsappchatblock`.`id_whatsappchatblock` = `ps_whatsappchatblock_lang`.`id_whatsappchatblock` AND `id_lang` = 1) WHERE `id_hook` = "hookDisplayFooterProduct" AND `id_shop` = 1 AND `active` = 1 ORDER BY position DESC;
0.3 1 Yes /modules/whatsappchat/classes/WhatsappChatBlock.php:130
SELECT SQL_NO_CACHE *
FROM `ps_product_supplier` a0
WHERE (a0.`id_product` = 15349)
GROUP BY a0.`id_supplier`
0.3 1 Yes Yes /classes/PrestaShopCollection.php:381
SELECT SQL_NO_CACHE id_tab, class_name FROM `ps_tab`
0.3 189 /classes/Tab.php:320
SELECT SQL_NO_CACHE * FROM `ps_image_shop` image_shop
WHERE image_shop.`id_product` = 15349
AND image_shop.`cover`= 1 LIMIT 1
0.3 1 /classes/Image.php:344
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 890) AND (b.`id_shop` = 1) LIMIT 1
0.3 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE module FROM ps_idxcookies WHERE 1  AND (id_cookie_type > 0 AND id_cookie_type NOT IN (select id_cookie_type FROM ps_idxcookies_type WHERE imperative = 1)) AND module IS NOT null AND module != '' GROUP BY module
0.3 52 Yes Yes /modules/idxcookies/classes/module/Functions.php:509
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 15333) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.3 1 /classes/stock/StockAvailable.php:444
SELECT SQL_NO_CACHE gi.* FROM `ps_groupinc_configuration` gi  WHERE (date_from <= "2025-02-17 11:18:35" OR date_from = "0000-00-00 00:00:00") AND (date_to >= "2025-02-17 11:18:35" OR date_to = "0000-00-00 00:00:00") AND gi.`id_shop` = 1 AND gi.`active` = 1  AND (gi.groups = ""  OR FIND_IN_SET(1, REPLACE(gi.groups, ";", ",")) > 0) AND (gi.suppliers = "" ) AND (gi.currencies = "" OR FIND_IN_SET(1, REPLACE(gi.currencies, ";", ",")) > 0) AND (gi.languages = "" OR FIND_IN_SET(1, REPLACE(gi.languages, ";", ",")) > 0)
0.3 1 /modules/groupinc/classes/GroupincConfiguration.php:449
SELECT SQL_NO_CACHE module FROM ps_idxcookies WHERE 1  AND (id_cookie_type > 0 AND id_cookie_type NOT IN (select id_cookie_type FROM ps_idxcookies_type WHERE imperative = 1)) AND module IS NOT null AND module != '' GROUP BY module
0.3 52 Yes Yes /modules/idxcookies/classes/module/Functions.php:509
SELECT SQL_NO_CACHE module FROM ps_idxcookies WHERE 1  AND (id_cookie_type > 0 AND id_cookie_type NOT IN (select id_cookie_type FROM ps_idxcookies_type WHERE imperative = 1)) AND module IS NOT null AND module != '' GROUP BY module
0.3 52 Yes Yes /modules/idxcookies/classes/module/Functions.php:509
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 = 1)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 27449
ORDER BY f.position ASC
0.3 18 Yes /classes/Product.php:5020
SELECT SQL_NO_CACHE module FROM ps_idxcookies WHERE 1  AND (id_cookie_type > 0 AND id_cookie_type NOT IN (select id_cookie_type FROM ps_idxcookies_type WHERE imperative = 1)) AND module IS NOT null AND module != '' GROUP BY module
0.3 52 Yes Yes /modules/idxcookies/classes/module/Functions.php:509
SELECT SQL_NO_CACHE *
FROM `ps_tax_lang`
WHERE `id_tax` = 1
0.3 1 /src/Adapter/EntityMapper.php:82
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
JOIN `ps_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `ps_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1)
JOIN `ps_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (26413) 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:3887
SELECT SQL_NO_CACHE module FROM ps_idxcookies WHERE 1  AND (id_cookie_type > 0 AND id_cookie_type NOT IN (select id_cookie_type FROM ps_idxcookies_type WHERE imperative = 1)) AND module IS NOT null AND module != '' GROUP BY module
0.3 52 Yes Yes /modules/idxcookies/classes/module/Functions.php:509
SELECT SQL_NO_CACHE module FROM ps_idxcookies WHERE 1  AND (id_cookie_type > 0 AND id_cookie_type NOT IN (select id_cookie_type FROM ps_idxcookies_type WHERE imperative = 1)) AND module IS NOT null AND module != '' GROUP BY module
0.3 52 Yes Yes /modules/idxcookies/classes/module/Functions.php:509
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` = 19486) AND (b.`id_shop` = 1) LIMIT 1
0.3 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE module FROM ps_idxcookies WHERE 1  AND (id_cookie_type > 0 AND id_cookie_type NOT IN (select id_cookie_type FROM ps_idxcookies_type WHERE imperative = 1)) AND module IS NOT null AND module != '' GROUP BY module
0.3 52 Yes Yes /modules/idxcookies/classes/module/Functions.php:509
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` = 26413)
0.3 1 /classes/Product.php:3364
SELECT SQL_NO_CACHE module FROM ps_idxcookies WHERE 1  AND (id_cookie_type > 0 AND id_cookie_type NOT IN (select id_cookie_type FROM ps_idxcookies_type WHERE imperative = 1)) AND module IS NOT null AND module != '' GROUP BY module
0.3 52 Yes Yes /modules/idxcookies/classes/module/Functions.php:509
SELECT SQL_NO_CACHE module FROM ps_idxcookies WHERE 1  AND (id_cookie_type > 0 AND id_cookie_type NOT IN (select id_cookie_type FROM ps_idxcookies_type WHERE imperative = 1)) AND module IS NOT null AND module != '' GROUP BY module
0.3 52 Yes Yes /modules/idxcookies/classes/module/Functions.php:509
SELECT SQL_NO_CACHE module FROM ps_idxcookies WHERE 1  AND (id_cookie_type > 0 AND id_cookie_type NOT IN (select id_cookie_type FROM ps_idxcookies_type WHERE imperative = 1)) AND module IS NOT null AND module != '' GROUP BY module
0.3 52 Yes Yes /modules/idxcookies/classes/module/Functions.php:509
SELECT SQL_NO_CACHE psgdprl.message FROM `ps_psgdpr_consent` psgdpr
LEFT JOIN ps_psgdpr_consent_lang psgdprl ON (psgdpr.id_gdpr_consent = psgdprl.id_gdpr_consent)
WHERE psgdpr.id_module = 17 AND psgdprl.id_lang =1 LIMIT 1
0.3 16 /modules/psgdpr/classes/GDPRConsent.php:111
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` = 36330 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` = 36330 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
0.3 0 /classes/Cart.php:1238
SELECT SQL_NO_CACHE module FROM ps_idxcookies WHERE 1  AND (id_cookie_type > 0 AND id_cookie_type NOT IN (select id_cookie_type FROM ps_idxcookies_type WHERE imperative = 1)) AND module IS NOT null AND module != '' GROUP BY module
0.3 52 Yes Yes /modules/idxcookies/classes/module/Functions.php:509
SELECT SQL_NO_CACHE module FROM ps_idxcookies WHERE 1  AND (id_cookie_type > 0 AND id_cookie_type NOT IN (select id_cookie_type FROM ps_idxcookies_type WHERE imperative = 1)) AND module IS NOT null AND module != '' GROUP BY module
0.3 52 Yes Yes /modules/idxcookies/classes/module/Functions.php:509
SELECT SQL_NO_CACHE module FROM ps_idxcookies WHERE 1  AND (id_cookie_type > 0 AND id_cookie_type NOT IN (select id_cookie_type FROM ps_idxcookies_type WHERE imperative = 1)) AND module IS NOT null AND module != '' GROUP BY module
0.3 52 Yes Yes /modules/idxcookies/classes/module/Functions.php:509
SELECT SQL_NO_CACHE gi.* FROM `ps_groupinc_configuration` gi  WHERE (date_from <= "2025-02-17 11:18:36" OR date_from = "0000-00-00 00:00:00") AND (date_to >= "2025-02-17 11:18:36" OR date_to = "0000-00-00 00:00:00") AND gi.`id_shop` = 1 AND gi.`active` = 1  AND show_on_sale = 1  AND (gi.groups = ""  OR FIND_IN_SET(1, REPLACE(gi.groups, ";", ",")) > 0) AND (gi.suppliers = "" ) AND (gi.currencies = "" OR FIND_IN_SET(1, REPLACE(gi.currencies, ";", ",")) > 0) AND (gi.languages = "" OR FIND_IN_SET(1, REPLACE(gi.languages, ";", ",")) > 0)
0.3 1 /modules/groupinc/classes/GroupincConfiguration.php:449
SELECT SQL_NO_CACHE *
FROM `ps_tax` a
WHERE (a.`id_tax` = 1) LIMIT 1
0.3 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE module FROM ps_idxcookies WHERE 1  AND (id_cookie_type > 0 AND id_cookie_type NOT IN (select id_cookie_type FROM ps_idxcookies_type WHERE imperative = 1)) AND module IS NOT null AND module != '' GROUP BY module
0.3 52 Yes Yes /modules/idxcookies/classes/module/Functions.php:509
SELECT SQL_NO_CACHE *
FROM `ps_product_supplier` a0
WHERE (a0.`id_product` = 36977)
GROUP BY a0.`id_supplier`
0.3 1 Yes Yes /classes/PrestaShopCollection.php:381
SELECT SQL_NO_CACHE module FROM ps_idxcookies WHERE 1  AND (id_cookie_type > 0 AND id_cookie_type NOT IN (select id_cookie_type FROM ps_idxcookies_type WHERE imperative = 1)) AND module IS NOT null AND module != '' GROUP BY module
0.3 52 Yes Yes /modules/idxcookies/classes/module/Functions.php:509
SELECT SQL_NO_CACHE module FROM ps_idxcookies WHERE 1  AND (id_cookie_type > 0 AND id_cookie_type NOT IN (select id_cookie_type FROM ps_idxcookies_type WHERE imperative = 1)) AND module IS NOT null AND module != '' GROUP BY module
0.3 52 Yes Yes /modules/idxcookies/classes/module/Functions.php:509
SELECT SQL_NO_CACHE module FROM ps_idxcookies WHERE 1  AND (id_cookie_type > 0 AND id_cookie_type NOT IN (select id_cookie_type FROM ps_idxcookies_type WHERE imperative = 1)) AND module IS NOT null AND module != '' GROUP BY module
0.3 52 Yes Yes /modules/idxcookies/classes/module/Functions.php:509
SELECT SQL_NO_CACHE gi.* FROM `ps_groupinc_configuration` gi  WHERE (date_from <= "2025-02-17 11:18:36" OR date_from = "0000-00-00 00:00:00") AND (date_to >= "2025-02-17 11:18:36" OR date_to = "0000-00-00 00:00:00") AND gi.`id_shop` = 1 AND gi.`active` = 1  AND show_on_sale = 1  AND (gi.groups = ""  OR FIND_IN_SET(1, REPLACE(gi.groups, ";", ",")) > 0) AND (gi.suppliers = "" ) AND (gi.currencies = "" OR FIND_IN_SET(1, REPLACE(gi.currencies, ";", ",")) > 0) AND (gi.languages = "" OR FIND_IN_SET(1, REPLACE(gi.languages, ";", ",")) > 0)
0.3 1 /modules/groupinc/classes/GroupincConfiguration.php:449
SELECT SQL_NO_CACHE module FROM ps_idxcookies WHERE 1  AND (id_cookie_type > 0 AND id_cookie_type NOT IN (select id_cookie_type FROM ps_idxcookies_type WHERE imperative = 1)) AND module IS NOT null AND module != '' GROUP BY module
0.3 52 Yes Yes /modules/idxcookies/classes/module/Functions.php:509
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` = 13689 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` = 13689 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
0.3 0 /classes/Cart.php:1238
SELECT SQL_NO_CACHE DISTINCT `id_product` FROM `ps_specific_price` WHERE `id_product` != 0
0.3 86 /classes/SpecificPrice.php:291
SELECT SQL_NO_CACHE module FROM ps_idxcookies WHERE 1  AND (id_cookie_type > 0 AND id_cookie_type NOT IN (select id_cookie_type FROM ps_idxcookies_type WHERE imperative = 1)) AND module IS NOT null AND module != '' GROUP BY module
0.3 52 Yes Yes /modules/idxcookies/classes/module/Functions.php:509
SELECT SQL_NO_CACHE module FROM ps_idxcookies WHERE 1  AND (id_cookie_type > 0 AND id_cookie_type NOT IN (select id_cookie_type FROM ps_idxcookies_type WHERE imperative = 1)) AND module IS NOT null AND module != '' GROUP BY module
0.3 52 Yes Yes /modules/idxcookies/classes/module/Functions.php:509
SELECT SQL_NO_CACHE module FROM ps_idxcookies WHERE 1  AND (id_cookie_type > 0 AND id_cookie_type NOT IN (select id_cookie_type FROM ps_idxcookies_type WHERE imperative = 1)) AND module IS NOT null AND module != '' GROUP BY module
0.3 52 Yes Yes /modules/idxcookies/classes/module/Functions.php:509
SELECT SQL_NO_CACHE module FROM ps_idxcookies WHERE 1  AND (id_cookie_type > 0 AND id_cookie_type NOT IN (select id_cookie_type FROM ps_idxcookies_type WHERE imperative = 1)) AND module IS NOT null AND module != '' GROUP BY module
0.3 52 Yes Yes /modules/idxcookies/classes/module/Functions.php:509
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` = 30477 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` = 30477 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
0.3 0 /classes/Cart.php:1238
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` = 24381)
0.3 1 /classes/Product.php:3364
SELECT SQL_NO_CACHE module FROM ps_idxcookies WHERE 1  AND (id_cookie_type > 0 AND id_cookie_type NOT IN (select id_cookie_type FROM ps_idxcookies_type WHERE imperative = 1)) AND module IS NOT null AND module != '' GROUP BY module
0.3 52 Yes Yes /modules/idxcookies/classes/module/Functions.php:509
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` = 15333 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` = 15333 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
0.3 0 /classes/Cart.php:1238
SELECT SQL_NO_CACHE module FROM ps_idxcookies WHERE 1  AND (id_cookie_type > 0 AND id_cookie_type NOT IN (select id_cookie_type FROM ps_idxcookies_type WHERE imperative = 1)) AND module IS NOT null AND module != '' GROUP BY module
0.3 52 Yes Yes /modules/idxcookies/classes/module/Functions.php:509
SELECT SQL_NO_CACHE gi.* FROM `ps_groupinc_configuration` gi  WHERE (date_from <= "2025-02-17 11:18:36" OR date_from = "0000-00-00 00:00:00") AND (date_to >= "2025-02-17 11:18:36" OR date_to = "0000-00-00 00:00:00") AND gi.`id_shop` = 1 AND gi.`active` = 1  AND show_on_sale = 1  AND (gi.groups = ""  OR FIND_IN_SET(1, REPLACE(gi.groups, ";", ",")) > 0) AND (gi.suppliers = "" ) AND (gi.currencies = "" OR FIND_IN_SET(1, REPLACE(gi.currencies, ";", ",")) > 0) AND (gi.languages = "" OR FIND_IN_SET(1, REPLACE(gi.languages, ";", ",")) > 0)
0.3 1 /modules/groupinc/classes/GroupincConfiguration.php:449
SELECT SQL_NO_CACHE module FROM ps_idxcookies WHERE 1  AND (id_cookie_type > 0 AND id_cookie_type NOT IN (select id_cookie_type FROM ps_idxcookies_type WHERE imperative = 1)) AND module IS NOT null AND module != '' GROUP BY module
0.3 52 Yes Yes /modules/idxcookies/classes/module/Functions.php:509
SELECT SQL_NO_CACHE module FROM ps_idxcookies WHERE 1  AND (id_cookie_type > 0 AND id_cookie_type NOT IN (select id_cookie_type FROM ps_idxcookies_type WHERE imperative = 1)) AND module IS NOT null AND module != '' GROUP BY module
0.3 52 Yes Yes /modules/idxcookies/classes/module/Functions.php:509
SELECT SQL_NO_CACHE `id_country`
FROM `ps_country`
WHERE `iso_code` = 'US' AND active = 1 LIMIT 1
0.3 1 /classes/Country.php:193
SELECT SQL_NO_CACHE module FROM ps_idxcookies WHERE 1  AND (id_cookie_type > 0 AND id_cookie_type NOT IN (select id_cookie_type FROM ps_idxcookies_type WHERE imperative = 1)) AND module IS NOT null AND module != '' GROUP BY module
0.3 52 Yes Yes /modules/idxcookies/classes/module/Functions.php:509
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` = 39405) AND (b.`id_shop` = 1) LIMIT 1
0.3 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE module FROM ps_idxcookies WHERE 1  AND (id_cookie_type > 0 AND id_cookie_type NOT IN (select id_cookie_type FROM ps_idxcookies_type WHERE imperative = 1)) AND module IS NOT null AND module != '' GROUP BY module
0.3 52 Yes Yes /modules/idxcookies/classes/module/Functions.php:509
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` = 13680 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` = 13680 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
0.3 0 /classes/Cart.php:1238
SELECT SQL_NO_CACHE module FROM ps_idxcookies WHERE 1  AND (id_cookie_type > 0 AND id_cookie_type NOT IN (select id_cookie_type FROM ps_idxcookies_type WHERE imperative = 1)) AND module IS NOT null AND module != '' GROUP BY module
0.3 52 Yes Yes /modules/idxcookies/classes/module/Functions.php:509
SELECT SQL_NO_CACHE gi.* FROM `ps_groupinc_configuration` gi  WHERE (date_from <= "2025-02-17 11:18:35" OR date_from = "0000-00-00 00:00:00") AND (date_to >= "2025-02-17 11:18:35" OR date_to = "0000-00-00 00:00:00") AND gi.`id_shop` = 1 AND gi.`active` = 1  AND product_qty > 1  AND (gi.groups = ""  OR FIND_IN_SET(1, REPLACE(gi.groups, ";", ",")) > 0) AND (gi.suppliers = "" ) AND (gi.currencies = "" OR FIND_IN_SET(1, REPLACE(gi.currencies, ";", ",")) > 0) AND (gi.languages = "" OR FIND_IN_SET(1, REPLACE(gi.languages, ";", ",")) > 0)
0.3 1 /modules/groupinc/classes/GroupincConfiguration.php:449
SELECT SQL_NO_CACHE module FROM ps_idxcookies WHERE 1  AND (id_cookie_type > 0 AND id_cookie_type NOT IN (select id_cookie_type FROM ps_idxcookies_type WHERE imperative = 1)) AND module IS NOT null AND module != '' GROUP BY module
0.3 52 Yes Yes /modules/idxcookies/classes/module/Functions.php:509
SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop`
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE `id_lang` = 1
AND c.`id_parent` = 2
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
0.3 15 Yes Yes /classes/Category.php:1135
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` = 15333)
0.3 1 /classes/Product.php:3364
SELECT SQL_NO_CACHE module FROM ps_idxcookies WHERE 1  AND (id_cookie_type > 0 AND id_cookie_type NOT IN (select id_cookie_type FROM ps_idxcookies_type WHERE imperative = 1)) AND module IS NOT null AND module != '' GROUP BY module
0.3 52 Yes Yes /modules/idxcookies/classes/module/Functions.php:509
SELECT SQL_NO_CACHE gi.* FROM `ps_groupinc_configuration` gi  WHERE (date_from <= "2025-02-17 11:18:36" OR date_from = "0000-00-00 00:00:00") AND (date_to >= "2025-02-17 11:18:36" OR date_to = "0000-00-00 00:00:00") AND gi.`id_shop` = 1 AND gi.`active` = 1  AND (gi.groups = ""  OR FIND_IN_SET(1, REPLACE(gi.groups, ";", ",")) > 0) AND (gi.suppliers = "" ) AND (gi.currencies = "" OR FIND_IN_SET(1, REPLACE(gi.currencies, ";", ",")) > 0) AND (gi.languages = "" OR FIND_IN_SET(1, REPLACE(gi.languages, ";", ",")) > 0)
0.3 1 /modules/groupinc/classes/GroupincConfiguration.php:449
SELECT SQL_NO_CACHE p.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2025-02-17 00:00:00',
INTERVAL 35 DAY
)
) > 0) as new
FROM ps_product p
LEFT JOIN ps_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 1
LEFT JOIN ps_stock_available sa
ON sa.id_product = p.id_product 
AND sa.id_shop = 1
WHERE p.id_product = 39405
0.3 1 /classes/ProductAssembler.php:90
SELECT SQL_NO_CACHE module FROM ps_idxcookies WHERE 1  AND (id_cookie_type > 0 AND id_cookie_type NOT IN (select id_cookie_type FROM ps_idxcookies_type WHERE imperative = 1)) AND module IS NOT null AND module != '' GROUP BY module
0.3 52 Yes Yes /modules/idxcookies/classes/module/Functions.php:509
SELECT SQL_NO_CACHE module FROM ps_idxcookies WHERE 1  AND (id_cookie_type > 0 AND id_cookie_type NOT IN (select id_cookie_type FROM ps_idxcookies_type WHERE imperative = 1)) AND module IS NOT null AND module != '' GROUP BY module
0.3 52 Yes Yes /modules/idxcookies/classes/module/Functions.php:509
SELECT SQL_NO_CACHE module FROM ps_idxcookies WHERE 1  AND (id_cookie_type > 0 AND id_cookie_type NOT IN (select id_cookie_type FROM ps_idxcookies_type WHERE imperative = 1)) AND module IS NOT null AND module != '' GROUP BY module
0.3 52 Yes Yes /modules/idxcookies/classes/module/Functions.php:509
(SELECT 1 FROM `ps_cart_rule` WHERE date_to >= "2025-02-17 00:00:00" AND date_to <= "2025-02-17 23:59:59" AND `id_customer` IN (0,0) LIMIT 1)UNION ALL (SELECT 1 FROM `ps_cart_rule` WHERE date_from >= "2025-02-17 00:00:00" AND date_from <= "2025-02-17 23:59:59" AND `id_customer` IN (0,0) LIMIT 1)UNION ALL (SELECT 1 FROM `ps_cart_rule` WHERE date_from < "2025-02-17 00:00:00" AND date_to > "2025-02-17 23:59:59" AND `id_customer` IN (0,0) LIMIT 1) LIMIT 1
0.3 1 /classes/CartRule.php:342
SELECT SQL_NO_CACHE module FROM ps_idxcookies WHERE 1  AND (id_cookie_type > 0 AND id_cookie_type NOT IN (select id_cookie_type FROM ps_idxcookies_type WHERE imperative = 1)) AND module IS NOT null AND module != '' GROUP BY module
0.3 52 Yes Yes /modules/idxcookies/classes/module/Functions.php:509
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` = 36977) AND (b.`id_shop` = 1) LIMIT 1
0.3 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE COUNT(DISTINCT `id_product`) FROM `ps_specific_price` WHERE `id_product` != 0 LIMIT 1
0.3 86 /classes/SpecificPrice.php:283
SELECT SQL_NO_CACHE module FROM ps_idxcookies WHERE 1  AND (id_cookie_type > 0 AND id_cookie_type NOT IN (select id_cookie_type FROM ps_idxcookies_type WHERE imperative = 1)) AND module IS NOT null AND module != '' GROUP BY module
0.3 52 Yes Yes /modules/idxcookies/classes/module/Functions.php:509
SELECT SQL_NO_CACHE module FROM ps_idxcookies WHERE 1  AND (id_cookie_type > 0 AND id_cookie_type NOT IN (select id_cookie_type FROM ps_idxcookies_type WHERE imperative = 1)) AND module IS NOT null AND module != '' GROUP BY module
0.3 52 Yes Yes /modules/idxcookies/classes/module/Functions.php:509
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` = 27449) AND (b.`id_shop` = 1) LIMIT 1
0.3 1 /src/Adapter/EntityMapper.php:75
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.3 121 /classes/module/Module.php:307
SELECT SQL_NO_CACHE module FROM ps_idxcookies WHERE 1  AND (id_cookie_type > 0 AND id_cookie_type NOT IN (select id_cookie_type FROM ps_idxcookies_type WHERE imperative = 1)) AND module IS NOT null AND module != '' GROUP BY module
0.3 52 Yes Yes /modules/idxcookies/classes/module/Functions.php:509
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` = 23007)
0.3 1 /classes/Product.php:3364
(SELECT 1 FROM `ps_cart_rule` WHERE date_to >= "2025-02-17 00:00:00" AND date_to <= "2025-02-17 23:59:59" AND `id_customer` IN (0,0) LIMIT 1)UNION ALL (SELECT 1 FROM `ps_cart_rule` WHERE date_from >= "2025-02-17 00:00:00" AND date_from <= "2025-02-17 23:59:59" AND `id_customer` IN (0,0) LIMIT 1)UNION ALL (SELECT 1 FROM `ps_cart_rule` WHERE date_from < "2025-02-17 00:00:00" AND date_to > "2025-02-17 23:59:59" AND `id_customer` IN (0,0) LIMIT 1) LIMIT 1
0.3 1 /classes/CartRule.php:342
SELECT SQL_NO_CACHE module FROM ps_idxcookies WHERE 1  AND (id_cookie_type > 0 AND id_cookie_type NOT IN (select id_cookie_type FROM ps_idxcookies_type WHERE imperative = 1)) AND module IS NOT null AND module != '' GROUP BY module
0.3 52 Yes Yes /modules/idxcookies/classes/module/Functions.php:509
SELECT SQL_NO_CACHE a.*, al.*
FROM `ps_idxcookies_templates` a
INNER JOIN `ps_idxcookies_templates_lang` `al` ON (a.id_template=al.id_template AND al.id_lang = 1 AND al.id_shop = 1)
WHERE (a.hook LIKE "%displayBeforeBodyClosingTag%") AND (a.active = "1")
ORDER BY a.id_template asc
0.3 1 /modules/idxcookies/lib/classes/ObjectModel.php:110
SELECT SQL_NO_CACHE module FROM ps_idxcookies WHERE 1  AND (id_cookie_type > 0 AND id_cookie_type NOT IN (select id_cookie_type FROM ps_idxcookies_type WHERE imperative = 1)) AND module IS NOT null AND module != '' GROUP BY module
0.3 52 Yes Yes /modules/idxcookies/classes/module/Functions.php:509
SELECT SQL_NO_CACHE module FROM ps_idxcookies WHERE 1  AND (id_cookie_type > 0 AND id_cookie_type NOT IN (select id_cookie_type FROM ps_idxcookies_type WHERE imperative = 1)) AND module IS NOT null AND module != '' GROUP BY module
0.3 52 Yes Yes /modules/idxcookies/classes/module/Functions.php:509