Костюм "Меридиан" утепленный, с полукомбинезоном, зеленый + черный

SELECT SQL_NO_CACHE fv.id_feature_value,
fv.id_feature,
COUNT(DISTINCT fp.id_product) as nbr,
fl.name as feature_name,
fl.description as feature_description,
fv.position,
fvl.value,
lifl.url_name as name_url_name,
lifl.meta_title as name_meta_title,
lifvl.url_name as value_url_name,
lifvl.meta_title as value_meta_title
FROM ps_feature_product fp
INNER JOIN ps_feature_value fv ON (fv.id_feature_value = fp.id_feature_value)
INNER JOIN ps_feature_lang fl ON (fl.id_feature = fv.id_feature AND fl.id_lang = 3)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = fv.id_feature_value AND fvl.id_lang = 3)
LEFT JOIN ps_layered_indexable_feature_lang_value lifl ON (lifl.id_feature = fv.id_feature AND lifl.id_lang = 3)
LEFT JOIN ps_layered_indexable_feature_value_lang_value lifvl ON (lifvl.id_feature_value = fv.id_feature_value AND lifvl.id_lang = 3)
WHERE fp.id_product IN (
SELECT id_product FROM ps_cat_restriction
)
AND fv.id_feature IN (21,25,26,20,27)
GROUP BY fv.id_feature_value

CREATE TEMPORARY TABLE ps_cat_restriction ENGINE=MEMORY
SELECT DISTINCT 
cp.id_product, 
p.id_manufacturer, 
product_shop.condition, 
p.weight, 
COALESCE(stock.quantity, 0) as orderquant, 
p.extras, 
p.height, 
sp.reduction, 
p.date_add 
FROM ps_category_product cp
INNER JOIN ps_product_shop product_shop ON (
product_shop.id_product = cp.id_product 
AND product_shop.id_shop = 1 
AND product_shop.active = 1 
AND product_shop.visibility IN ("both", "catalog")
)
INNER JOIN ps_product p ON (p.id_product = cp.id_product)
LEFT JOIN ps_specific_price sp ON (
sp.id_product = cp.id_product 
AND sp.id_product_attribute = 0 
AND sp.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  )
WHERE cp.id_category = 2

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-11-21 00:00:00",
INTERVAL 20 DAY
)
) > 0 AS new
FROM `ps_accessory`
LEFT JOIN `ps_product` p ON p.`id_product` = `id_product_2`
INNER JOIN ps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_product_attribute_shop` product_attribute_shop
ON (p.`id_product` = product_attribute_shop.`id_product` AND product_attribute_shop.`default_on` = 1 AND product_attribute_shop.id_shop=1)
LEFT JOIN `ps_product_lang` pl ON (
p.`id_product` = pl.`id_product`
AND pl.`id_lang` = 3 AND pl.id_shop = 1 
)
LEFT JOIN `ps_category_lang` cl ON (
product_shop.`id_category_default` = cl.`id_category`
AND cl.`id_lang` = 3 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` = 3)
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` = 44 AND product_shop.`active` = 1 AND product_shop.`visibility` != 'none'
GROUP BY product_shop.id_product

ALTER TABLE ps_cat_restriction ADD PRIMARY KEY (id_product),
ADD KEY `id_manufacturer` (`id_manufacturer`,`id_product`) USING BTREE,
ADD KEY `condition` (`condition`,`id_product`) USING BTREE,
ADD KEY `weight` (`weight`,`id_product`) USING BTREE,
ADD KEY `height` (`height`,`id_product`) USING BTREE

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`)

SELECT SQL_NO_CACHE i.*,image_shop.`cover`, il.`legend`
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` = 3)
WHERE i.`id_product` = 44
ORDER BY `position`

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` = 3)
LEFT JOIN `ps_zone` z ON (z.`id_zone` = c.`id_zone`)
WHERE 1
ORDER BY cl.name ASC

SELECT SQL_NO_CACHE IFNULL(left_column, default_left_column) as left_column, IFNULL(right_column, default_right_column) as right_column
FROM ps_theme t
LEFT JOIN ps_theme_meta tm ON (t.id_theme = tm.id_theme)
LEFT JOIN ps_meta m ON (m.id_meta = tm.id_meta)
WHERE t.id_theme =2 AND m.page = "product" LIMIT 1

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` = 44
AND al.`id_lang` = 3
AND agl.`id_lang` = 3
GROUP BY id_attribute_group, id_product_attribute
ORDER BY ag.`position` ASC, a.`position` ASC, agl.`name` ASC

SELECT SQL_NO_CACHE p.`id_product`, psi.price_min, psi.price_max 
FROM ps_cat_restriction p
INNER JOIN `ps_layered_price_index` psi
ON (psi.id_product = p.id_product AND psi.id_currency = 1 AND psi.id_shop=1)
WHERE 1

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` = 3)
WHERE `level_depth` = 1

SELECT SQL_NO_CACHE *
FROM `ps_currency` c
INNER JOIN ps_currency_shop currency_shop
ON (currency_shop.id_currency = c.id_currency AND currency_shop.id_shop = 1) WHERE `deleted` = 0 AND c.`active` = 1 ORDER BY `name` ASC

SELECT SQL_NO_CACHE c.*, cl.id_lang, cl.name, cl.description, cl.link_rewrite, cl.meta_title, cl.meta_keywords, cl.meta_description, cl.cus_tags, cl.h1, cl.description_short
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` = 3  AND cl.id_shop = 1 )
LEFT JOIN `ps_category_group` cg ON (cg.`id_category` = c.`id_category`)
WHERE `id_parent` = 40
AND `active` = 1
AND cg.`id_group` =1
GROUP BY c.`id_category`
ORDER BY `level_depth` ASC, category_shop.`position` ASC

INSERT INTO `ps_connections` (`id_guest`, `id_page`, `ip_address`, `http_referer`, `id_shop`, `id_shop_group`, `date_add`) VALUES ('21569959', '403', '3628718218', '', '1', '1', '2025-11-21 19:29:16')

SELECT SQL_NO_CACHE DISTINCT la.`id_attribute`, la.`url_name` as `attribute`, pa.`wholesale_price`
, pa.`price`, sa.`quantity`, pa.`id_product_attribute` as ipa
FROM `ps_attribute` a
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`)
LEFT JOIN `ps_stock_available` sa
ON (pa.`id_product` = sa.`id_product` && pac.`id_product_attribute` = sa.`id_product_attribute`)
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
LEFT JOIN `ps_layered_indexable_attribute_lang_value` la
ON (la.`id_attribute` = a.`id_attribute` AND la.`id_lang` = 3)
WHERE la.`url_name` IS NOT NULL AND la.`url_name` != ''
AND pa.`id_product` = 44 ORDER BY sa.`quantity` = 0, a.`position`

SELECT SQL_NO_CACHE DISTINCT a.`id_attribute`, a.`id_attribute_group`, al.`name` as `attribute`, agl.`name` as `group`, pa.`wholesale_price`
, pa.`price`, sa.`quantity`
FROM `ps_attribute` a
LEFT JOIN `ps_attribute_lang` al
ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 3)
LEFT JOIN `ps_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 3)
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`)
LEFT JOIN `ps_stock_available` sa
ON (pa.`id_product` = sa.`id_product` && pac.`id_product_attribute` = sa.`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` = 44
AND a.`id_attribute` NOT IN(42, 42, 42, 42, 42, 42, 42, 42, 42, 42, 42, 42, 42, 43, 43, 43, 43, 43, 43, 43, 43, 43, 43, 43, 43, 43, 45, 45, 195, 195, 196, 196, 197, 197, 198, 198, 199, 199, 200, 200, 201, 201, 202, 202, 203, 203, 204, 204, 205, 205, 206, 206)

SELECT SQL_NO_CACHE h.`name` as hook, m.`id_module`, h.`id_hook`, m.`name` as module, h.`live_edit`
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` != "displayPayment" AND h.`name` != "displayPaymentEU") 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`

SELECT SQL_NO_CACHE DISTINCT a.`id_attribute`, a.`id_attribute_group`, al.`name` as `attribute`, agl.`name` as `group`, pa.`wholesale_price`
, pa.`price`, sa.`quantity`
FROM `ps_attribute` a
LEFT JOIN `ps_attribute_lang` al
ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 3)
LEFT JOIN `ps_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 3)
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`)
LEFT JOIN `ps_stock_available` sa
ON (pa.`id_product` = sa.`id_product` && pac.`id_product_attribute` = sa.`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` = 400
AND a.`id_attribute` NOT IN(42, 185, 42, 42, 42, 42, 42, 42, 42, 42, 42, 42, 43, 43, 43, 43, 43, 43, 43, 43, 43, 43, 43, 192, 192, 193, 193, 194, 194, 191, 191, 190, 190, 184, 184, 185, 186, 186, 187, 187, 188, 188, 189, 189)

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

SELECT SQL_NO_CACHE h.id_hook, h.name as h_name, title, description, h.position, live_edit, 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

SELECT SQL_NO_CACHE *
FROM `ps_category` c
LEFT JOIN `ps_category_lang` `cl` ON c.id_category = cl.id_category AND id_lang = 3 AND cl.id_shop = 1 
WHERE (c.nleft <= 276 AND c.nright >= 277)
ORDER BY c.nleft

SELECT SQL_NO_CACHE DISTINCT la.`id_attribute`, la.`url_name` as `attribute`, pa.`wholesale_price`
, pa.`price`, sa.`quantity`, pa.`id_product_attribute` as ipa
FROM `ps_attribute` a
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`)
LEFT JOIN `ps_stock_available` sa
ON (pa.`id_product` = sa.`id_product` && pac.`id_product_attribute` = sa.`id_product_attribute`)
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
LEFT JOIN `ps_layered_indexable_attribute_lang_value` la
ON (la.`id_attribute` = a.`id_attribute` AND la.`id_lang` = 3)
WHERE la.`url_name` IS NOT NULL AND la.`url_name` != ''
AND pa.`id_product` = 400 ORDER BY sa.`quantity` = 0, a.`position`

SELECT SQL_NO_CACHE pac4.`id_product_attribute`
FROM `ps_product_attribute` pa
INNER JOIN `ps_product_attribute_combination` pac
ON (pa.`id_product_attribute` = pac.`id_product_attribute` AND pac.`id_attribute` != 42 AND pac.`id_attribute` != 43)
INNER JOIN `ps_product_attribute_combination` pac2
ON (pac.`id_attribute` = pac2.`id_attribute` AND pac2.`id_product_attribute` = 98114)
RIGHT JOIN `ps_product_attribute_combination` pac3
ON (pac3.`id_attribute` = pac2.`id_attribute`)
RIGHT JOIN `ps_product_attribute_combination` pac4
ON (pac3.`id_product_attribute` = pac4.`id_product_attribute` AND pa.`id_product_attribute` = pac4.`id_product_attribute` AND pac4.`id_attribute` = 43)
WHERE pa.`id_product` = (SELECT p2.`id_product` FROM `ps_product_attribute` p2 WHERE p2.`id_product_attribute` = 98114 LIMIT 1)

SELECT SQL_NO_CACHE * FROM `ps_state` ORDER BY `name` ASC

SELECT SQL_NO_CACHE c.id_category, cl.name, cl.link_rewrite, c.notinurl
FROM ps_category c
LEFT JOIN ps_category_lang cl ON (cl.id_category = c.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 c.nleft <= 6
AND c.nright >= 7
AND c.nleft >= 2
AND c.nright <= 583
AND cl.id_lang = 3
AND c.active = 1
AND c.level_depth > 1
ORDER BY c.level_depth ASC

SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 3
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 400) AND (b.`id_shop` = 1) LIMIT 1

SELECT SQL_NO_CACHE pac4.`id_product_attribute`
FROM `ps_product_attribute` pa
INNER JOIN `ps_product_attribute_combination` pac
ON (pa.`id_product_attribute` = pac.`id_product_attribute` AND pac.`id_attribute` != 42 AND pac.`id_attribute` != 43)
INNER JOIN `ps_product_attribute_combination` pac2
ON (pac.`id_attribute` = pac2.`id_attribute` AND pac2.`id_product_attribute` = 97266)
RIGHT JOIN `ps_product_attribute_combination` pac3
ON (pac3.`id_attribute` = pac2.`id_attribute`)
RIGHT JOIN `ps_product_attribute_combination` pac4
ON (pac3.`id_product_attribute` = pac4.`id_product_attribute` AND pa.`id_product_attribute` = pac4.`id_product_attribute` AND pac4.`id_attribute` = 43)
WHERE pa.`id_product` = (SELECT p2.`id_product` FROM `ps_product_attribute` p2 WHERE p2.`id_product_attribute` = 97266 LIMIT 1)

SELECT SQL_NO_CACHE gs.*, s.*, gs.name AS group_name, s.name AS shop_name, s.active, su.domain, su.domain_ssl, su.physical_uri, su.virtual_uri
FROM ps_shop_group gs
LEFT JOIN ps_shop s
ON s.id_shop_group = gs.id_shop_group
LEFT JOIN ps_shop_url su
ON s.id_shop = su.id_shop AND su.main = 1
WHERE s.deleted = 0
AND gs.deleted = 0
ORDER BY gs.name, s.name

SELECT SQL_NO_CACHE `ps_specific_price`.`id_specific_price_rule` as `id_specific_price_rule`,
`ps_specific_price`.`id_specific_price` as `id_specific_price`,
`ps_specific_price`.`id_cart` as `id_cart`,
`ps_specific_price`.`id_product` as `id_product`,
`ps_specific_price`.`id_shop` as `id_shop`,
`ps_specific_price`.`id_shop_group` as `id_shop_group`,
`ps_specific_price`.`id_currency` as `id_currency`,
`ps_specific_price`.`id_country` as `id_country`,
`ps_specific_price`.`id_group` as `id_group`,
`ps_specific_price`.`id_customer` as `id_customer`,
`ps_specific_price`.`id_product_attribute` as 	`id_product_attribute`,
`ps_specific_price`.`price` as `price`,
`ps_specific_price`.`from_quantity` as `from_quantity`,
`ps_specific_price`.`reduction` as `reduction`,
`ps_specific_price`.`reduction_tax` as `reduction_tax`,
`ps_specific_price`.`reduction_type` as `reduction_type`,
`ps_specific_price`.`from` as `from`,
`ps_specific_price`.`to` as `to`,
`ps_specific_price`.`ipa_type` as `ipa_type`,
COUNT(t2.`id_product`) as ipacnt,  ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 177, 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` LEFT JOIN `ps_product_attribute` t2 ON (t2.`id_product_attribute` = 98133 AND (`ps_specific_price`.`ipa_type` IS NULL || `ps_specific_price`.`ipa_type` = 0 || t2.`type` = `ps_specific_price`.`ipa_type`)) WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 177) AND
`id_group` IN (0, 1) AND ps_specific_price.`id_product` = 0 AND ps_specific_price.`id_customer` = 0 AND ps_specific_price.`id_product_attribute` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2025-11-21 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2025-11-21 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 HAVING ipacnt > 0  ORDER BY `ps_specific_price`.`id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1

SELECT SQL_NO_CACHE `ps_specific_price`.`id_specific_price_rule` as `id_specific_price_rule`,
`ps_specific_price`.`id_specific_price` as `id_specific_price`,
`ps_specific_price`.`id_cart` as `id_cart`,
`ps_specific_price`.`id_product` as `id_product`,
`ps_specific_price`.`id_shop` as `id_shop`,
`ps_specific_price`.`id_shop_group` as `id_shop_group`,
`ps_specific_price`.`id_currency` as `id_currency`,
`ps_specific_price`.`id_country` as `id_country`,
`ps_specific_price`.`id_group` as `id_group`,
`ps_specific_price`.`id_customer` as `id_customer`,
`ps_specific_price`.`id_product_attribute` as 	`id_product_attribute`,
`ps_specific_price`.`price` as `price`,
`ps_specific_price`.`from_quantity` as `from_quantity`,
`ps_specific_price`.`reduction` as `reduction`,
`ps_specific_price`.`reduction_tax` as `reduction_tax`,
`ps_specific_price`.`reduction_type` as `reduction_type`,
`ps_specific_price`.`from` as `from`,
`ps_specific_price`.`to` as `to`,
`ps_specific_price`.`ipa_type` as `ipa_type`,
COUNT(t2.`id_product`) as ipacnt,  ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 177, 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` LEFT JOIN `ps_product_attribute` t2 ON (t2.`id_product_attribute` = 98128 AND (`ps_specific_price`.`ipa_type` IS NULL || `ps_specific_price`.`ipa_type` = 0 || t2.`type` = `ps_specific_price`.`ipa_type`)) WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 177) AND
`id_group` IN (0, 1) AND ps_specific_price.`id_product` = 0 AND ps_specific_price.`id_customer` = 0 AND ps_specific_price.`id_product_attribute` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2025-11-21 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2025-11-21 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 HAVING ipacnt > 0  ORDER BY `ps_specific_price`.`id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1

SELECT SQL_NO_CACHE `ps_specific_price`.`id_specific_price_rule` as `id_specific_price_rule`,
`ps_specific_price`.`id_specific_price` as `id_specific_price`,
`ps_specific_price`.`id_cart` as `id_cart`,
`ps_specific_price`.`id_product` as `id_product`,
`ps_specific_price`.`id_shop` as `id_shop`,
`ps_specific_price`.`id_shop_group` as `id_shop_group`,
`ps_specific_price`.`id_currency` as `id_currency`,
`ps_specific_price`.`id_country` as `id_country`,
`ps_specific_price`.`id_group` as `id_group`,
`ps_specific_price`.`id_customer` as `id_customer`,
`ps_specific_price`.`id_product_attribute` as 	`id_product_attribute`,
`ps_specific_price`.`price` as `price`,
`ps_specific_price`.`from_quantity` as `from_quantity`,
`ps_specific_price`.`reduction` as `reduction`,
`ps_specific_price`.`reduction_tax` as `reduction_tax`,
`ps_specific_price`.`reduction_type` as `reduction_type`,
`ps_specific_price`.`from` as `from`,
`ps_specific_price`.`to` as `to`,
`ps_specific_price`.`ipa_type` as `ipa_type`,
COUNT(t2.`id_product`) as ipacnt,  ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 177, 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` LEFT JOIN `ps_product_attribute` t2 ON (t2.`id_product_attribute` = 98123 AND (`ps_specific_price`.`ipa_type` IS NULL || `ps_specific_price`.`ipa_type` = 0 || t2.`type` = `ps_specific_price`.`ipa_type`)) WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 177) AND
`id_group` IN (0, 1) AND ps_specific_price.`id_product` = 0 AND ps_specific_price.`id_customer` = 0 AND ps_specific_price.`id_product_attribute` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2025-11-21 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2025-11-21 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 HAVING ipacnt > 0  ORDER BY `ps_specific_price`.`id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1

SELECT SQL_NO_CACHE `ps_specific_price`.`id_specific_price_rule` as `id_specific_price_rule`,
`ps_specific_price`.`id_specific_price` as `id_specific_price`,
`ps_specific_price`.`id_cart` as `id_cart`,
`ps_specific_price`.`id_product` as `id_product`,
`ps_specific_price`.`id_shop` as `id_shop`,
`ps_specific_price`.`id_shop_group` as `id_shop_group`,
`ps_specific_price`.`id_currency` as `id_currency`,
`ps_specific_price`.`id_country` as `id_country`,
`ps_specific_price`.`id_group` as `id_group`,
`ps_specific_price`.`id_customer` as `id_customer`,
`ps_specific_price`.`id_product_attribute` as 	`id_product_attribute`,
`ps_specific_price`.`price` as `price`,
`ps_specific_price`.`from_quantity` as `from_quantity`,
`ps_specific_price`.`reduction` as `reduction`,
`ps_specific_price`.`reduction_tax` as `reduction_tax`,
`ps_specific_price`.`reduction_type` as `reduction_type`,
`ps_specific_price`.`from` as `from`,
`ps_specific_price`.`to` as `to`,
`ps_specific_price`.`ipa_type` as `ipa_type`,
COUNT(t2.`id_product`) as ipacnt,  ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 177, 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` LEFT JOIN `ps_product_attribute` t2 ON (t2.`id_product_attribute` = 98129 AND (`ps_specific_price`.`ipa_type` IS NULL || `ps_specific_price`.`ipa_type` = 0 || t2.`type` = `ps_specific_price`.`ipa_type`)) WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 177) AND
`id_group` IN (0, 1) AND ps_specific_price.`id_product` = 0 AND ps_specific_price.`id_customer` = 0 AND ps_specific_price.`id_product_attribute` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2025-11-21 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2025-11-21 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 HAVING ipacnt > 0  ORDER BY `ps_specific_price`.`id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1

INSERT INTO `ps_guest` (`id_operating_system`, `id_web_browser`, `id_customer`, `javascript`, `screen_resolution_x`, `screen_resolution_y`, `screen_color`, `sun_java`, `adobe_flash`, `adobe_director`, `apple_quicktime`, `real_player`, `windows_media`, `accept_language`, `mobile_theme`) VALUES ('0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '0')

SELECT SQL_NO_CACHE `ps_specific_price`.`id_specific_price_rule` as `id_specific_price_rule`,
`ps_specific_price`.`id_specific_price` as `id_specific_price`,
`ps_specific_price`.`id_cart` as `id_cart`,
`ps_specific_price`.`id_product` as `id_product`,
`ps_specific_price`.`id_shop` as `id_shop`,
`ps_specific_price`.`id_shop_group` as `id_shop_group`,
`ps_specific_price`.`id_currency` as `id_currency`,
`ps_specific_price`.`id_country` as `id_country`,
`ps_specific_price`.`id_group` as `id_group`,
`ps_specific_price`.`id_customer` as `id_customer`,
`ps_specific_price`.`id_product_attribute` as 	`id_product_attribute`,
`ps_specific_price`.`price` as `price`,
`ps_specific_price`.`from_quantity` as `from_quantity`,
`ps_specific_price`.`reduction` as `reduction`,
`ps_specific_price`.`reduction_tax` as `reduction_tax`,
`ps_specific_price`.`reduction_type` as `reduction_type`,
`ps_specific_price`.`from` as `from`,
`ps_specific_price`.`to` as `to`,
`ps_specific_price`.`ipa_type` as `ipa_type`,
COUNT(t2.`id_product`) as ipacnt,  ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 177, 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` LEFT JOIN `ps_product_attribute` t2 ON (t2.`id_product_attribute` = 98130 AND (`ps_specific_price`.`ipa_type` IS NULL || `ps_specific_price`.`ipa_type` = 0 || t2.`type` = `ps_specific_price`.`ipa_type`)) WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 177) AND
`id_group` IN (0, 1) AND ps_specific_price.`id_product` = 0 AND ps_specific_price.`id_customer` = 0 AND ps_specific_price.`id_product_attribute` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2025-11-21 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2025-11-21 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 HAVING ipacnt > 0  ORDER BY `ps_specific_price`.`id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1

SELECT SQL_NO_CACHE value FROM ps_configuration WHERE name= 'PS_CACHEFS_DIRECTORY_DEPTH' LIMIT 1

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` = 3
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 49) AND (b.`id_shop` = 1) LIMIT 1

SELECT SQL_NO_CACHE `ps_specific_price`.`id_specific_price_rule` as `id_specific_price_rule`,
`ps_specific_price`.`id_specific_price` as `id_specific_price`,
`ps_specific_price`.`id_cart` as `id_cart`,
`ps_specific_price`.`id_product` as `id_product`,
`ps_specific_price`.`id_shop` as `id_shop`,
`ps_specific_price`.`id_shop_group` as `id_shop_group`,
`ps_specific_price`.`id_currency` as `id_currency`,
`ps_specific_price`.`id_country` as `id_country`,
`ps_specific_price`.`id_group` as `id_group`,
`ps_specific_price`.`id_customer` as `id_customer`,
`ps_specific_price`.`id_product_attribute` as 	`id_product_attribute`,
`ps_specific_price`.`price` as `price`,
`ps_specific_price`.`from_quantity` as `from_quantity`,
`ps_specific_price`.`reduction` as `reduction`,
`ps_specific_price`.`reduction_tax` as `reduction_tax`,
`ps_specific_price`.`reduction_type` as `reduction_type`,
`ps_specific_price`.`from` as `from`,
`ps_specific_price`.`to` as `to`,
`ps_specific_price`.`ipa_type` as `ipa_type`,
COUNT(t2.`id_product`) as ipacnt,  ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 177, 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` LEFT JOIN `ps_product_attribute` t2 ON (t2.`id_product_attribute` = 98121 AND (`ps_specific_price`.`ipa_type` IS NULL || `ps_specific_price`.`ipa_type` = 0 || t2.`type` = `ps_specific_price`.`ipa_type`)) WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 177) AND
`id_group` IN (0, 1) AND ps_specific_price.`id_product` = 0 AND ps_specific_price.`id_customer` = 0 AND ps_specific_price.`id_product_attribute` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2025-11-21 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2025-11-21 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 HAVING ipacnt > 0  ORDER BY `ps_specific_price`.`id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1

SELECT SQL_NO_CACHE s.id_shop, CONCAT(su.physical_uri, su.virtual_uri) AS uri, su.domain, su.main
FROM ps_shop_url su
LEFT JOIN ps_shop s ON (s.id_shop = su.id_shop)
WHERE (su.domain = 'formgost.ru' OR su.domain_ssl = 'formgost.ru')
AND s.active = 1
AND s.deleted = 0
ORDER BY LENGTH(CONCAT(su.physical_uri, su.virtual_uri)) DESC

SELECT SQL_NO_CACHE `ps_specific_price`.`id_specific_price_rule` as `id_specific_price_rule`,
`ps_specific_price`.`id_specific_price` as `id_specific_price`,
`ps_specific_price`.`id_cart` as `id_cart`,
`ps_specific_price`.`id_product` as `id_product`,
`ps_specific_price`.`id_shop` as `id_shop`,
`ps_specific_price`.`id_shop_group` as `id_shop_group`,
`ps_specific_price`.`id_currency` as `id_currency`,
`ps_specific_price`.`id_country` as `id_country`,
`ps_specific_price`.`id_group` as `id_group`,
`ps_specific_price`.`id_customer` as `id_customer`,
`ps_specific_price`.`id_product_attribute` as 	`id_product_attribute`,
`ps_specific_price`.`price` as `price`,
`ps_specific_price`.`from_quantity` as `from_quantity`,
`ps_specific_price`.`reduction` as `reduction`,
`ps_specific_price`.`reduction_tax` as `reduction_tax`,
`ps_specific_price`.`reduction_type` as `reduction_type`,
`ps_specific_price`.`from` as `from`,
`ps_specific_price`.`to` as `to`,
`ps_specific_price`.`ipa_type` as `ipa_type`,
COUNT(t2.`id_product`) as ipacnt,  ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 177, 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` LEFT JOIN `ps_product_attribute` t2 ON (t2.`id_product_attribute` = 98117 AND (`ps_specific_price`.`ipa_type` IS NULL || `ps_specific_price`.`ipa_type` = 0 || t2.`type` = `ps_specific_price`.`ipa_type`)) WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 177) AND
`id_group` IN (0, 1) AND ps_specific_price.`id_product` = 0 AND ps_specific_price.`id_customer` = 0 AND ps_specific_price.`id_product_attribute` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2025-11-21 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2025-11-21 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 HAVING ipacnt > 0  ORDER BY `ps_specific_price`.`id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1

SELECT SQL_NO_CACHE pf.`id_product`,
pf.`id_feature`,
fl.`name`,
fvl.`value`,
f.`position` as feature_position,
f.`displayval`
FROM `ps_feature_product` pf
INNER JOIN `ps_feature_lang` fl ON (
fl.`id_feature` = pf.`id_feature` 
AND fl.`id_lang` = 3
)
INNER JOIN `ps_feature_value_lang` fvl ON (
fvl.`id_feature_value` = pf.`id_feature_value` 
AND fvl.`id_lang` = 3
)
INNER JOIN `ps_feature` f ON f.`id_feature` = pf.`id_feature`
INNER JOIN `ps_feature_shop` fs ON (
fs.`id_feature` = f.`id_feature` 
AND fs.`id_shop` = 1
)
WHERE pf.`id_product` IN (44)
ORDER BY pf.`id_product`, f.`position` ASC, fvl.`value` ASC

SELECT SQL_NO_CACHE `ps_specific_price`.`id_specific_price_rule` as `id_specific_price_rule`,
`ps_specific_price`.`id_specific_price` as `id_specific_price`,
`ps_specific_price`.`id_cart` as `id_cart`,
`ps_specific_price`.`id_product` as `id_product`,
`ps_specific_price`.`id_shop` as `id_shop`,
`ps_specific_price`.`id_shop_group` as `id_shop_group`,
`ps_specific_price`.`id_currency` as `id_currency`,
`ps_specific_price`.`id_country` as `id_country`,
`ps_specific_price`.`id_group` as `id_group`,
`ps_specific_price`.`id_customer` as `id_customer`,
`ps_specific_price`.`id_product_attribute` as 	`id_product_attribute`,
`ps_specific_price`.`price` as `price`,
`ps_specific_price`.`from_quantity` as `from_quantity`,
`ps_specific_price`.`reduction` as `reduction`,
`ps_specific_price`.`reduction_tax` as `reduction_tax`,
`ps_specific_price`.`reduction_type` as `reduction_type`,
`ps_specific_price`.`from` as `from`,
`ps_specific_price`.`to` as `to`,
`ps_specific_price`.`ipa_type` as `ipa_type`,
COUNT(t2.`id_product`) as ipacnt,  ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 177, 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` LEFT JOIN `ps_product_attribute` t2 ON (t2.`id_product_attribute` = 98127 AND (`ps_specific_price`.`ipa_type` IS NULL || `ps_specific_price`.`ipa_type` = 0 || t2.`type` = `ps_specific_price`.`ipa_type`)) WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 177) AND
`id_group` IN (0, 1) AND ps_specific_price.`id_product` = 0 AND ps_specific_price.`id_customer` = 0 AND ps_specific_price.`id_product_attribute` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2025-11-21 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2025-11-21 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 HAVING ipacnt > 0  ORDER BY `ps_specific_price`.`id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1

SELECT SQL_NO_CACHE g.`id_attribute_group`, g.`url_name` as `group`
FROM `ps_layered_indexable_attribute_group_lang_value` g
LEFT JOIN `ps_attribute` a
ON (a.`id_attribute_group` = g.`id_attribute_group`)
WHERE a.`id_attribute` = 43
AND g.`id_lang` = 3
AND g.`url_name` IS NOT NULL AND g.`url_name` != ''

SELECT SQL_NO_CACHE m.page, ml.url_rewrite, ml.id_lang
FROM `ps_meta` m
LEFT JOIN `ps_meta_lang` ml ON (m.id_meta = ml.id_meta AND ml.id_shop = 1 )
ORDER BY LENGTH(ml.url_rewrite) DESC

SELECT SQL_NO_CACHE product_attribute_shop.id_product_attribute
FROM ps_product_attribute pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
WHERE product_attribute_shop.default_on = 1  AND pa.id_product = 400 LIMIT 1

SELECT SQL_NO_CACHE `name`, `meta_title`, `meta_description`, `meta_keywords`, `description_short`
FROM `ps_product` p
LEFT JOIN `ps_product_lang` pl ON (pl.`id_product` = p.`id_product` AND pl.id_shop = 1 )
INNER JOIN ps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
WHERE pl.id_lang = 3
AND pl.id_product = 44
AND product_shop.active = 1 LIMIT 1

SELECT SQL_NO_CACHE pf.`id_product`,
pf.`id_feature`,
fl.`name`,
fvl.`value`,
f.`position` as feature_position,
f.`displayval`
FROM `ps_feature_product` pf
INNER JOIN `ps_feature_lang` fl ON (
fl.`id_feature` = pf.`id_feature` 
AND fl.`id_lang` = 3
)
INNER JOIN `ps_feature_value_lang` fvl ON (
fvl.`id_feature_value` = pf.`id_feature_value` 
AND fvl.`id_lang` = 3
)
INNER JOIN `ps_feature` f ON f.`id_feature` = pf.`id_feature`
INNER JOIN `ps_feature_shop` fs ON (
fs.`id_feature` = f.`id_feature` 
AND fs.`id_shop` = 1
)
WHERE pf.`id_product` IN (37)
ORDER BY pf.`id_product`, f.`position` ASC, fvl.`value` ASC

SELECT SQL_NO_CACHE product_attribute_shop.id_product_attribute
FROM ps_product_attribute pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
WHERE product_attribute_shop.default_on = 1  AND pa.id_product = 44 LIMIT 1

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` = 3
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 39) AND (b.`id_shop` = 1) LIMIT 1

SELECT SQL_NO_CACHE `ps_specific_price`.`id_specific_price_rule` as `id_specific_price_rule`,
`ps_specific_price`.`id_specific_price` as `id_specific_price`,
`ps_specific_price`.`id_cart` as `id_cart`,
`ps_specific_price`.`id_product` as `id_product`,
`ps_specific_price`.`id_shop` as `id_shop`,
`ps_specific_price`.`id_shop_group` as `id_shop_group`,
`ps_specific_price`.`id_currency` as `id_currency`,
`ps_specific_price`.`id_country` as `id_country`,
`ps_specific_price`.`id_group` as `id_group`,
`ps_specific_price`.`id_customer` as `id_customer`,
`ps_specific_price`.`id_product_attribute` as 	`id_product_attribute`,
`ps_specific_price`.`price` as `price`,
`ps_specific_price`.`from_quantity` as `from_quantity`,
`ps_specific_price`.`reduction` as `reduction`,
`ps_specific_price`.`reduction_tax` as `reduction_tax`,
`ps_specific_price`.`reduction_type` as `reduction_type`,
`ps_specific_price`.`from` as `from`,
`ps_specific_price`.`to` as `to`,
`ps_specific_price`.`ipa_type` as `ipa_type`,
COUNT(t2.`id_product`) as ipacnt,  ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 177, 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` LEFT JOIN `ps_product_attribute` t2 ON (t2.`id_product_attribute` = 98131 AND (`ps_specific_price`.`ipa_type` IS NULL || `ps_specific_price`.`ipa_type` = 0 || t2.`type` = `ps_specific_price`.`ipa_type`)) WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 177) AND
`id_group` IN (0, 1) AND ps_specific_price.`id_product` = 0 AND ps_specific_price.`id_customer` = 0 AND ps_specific_price.`id_product_attribute` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2025-11-21 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2025-11-21 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 HAVING ipacnt > 0  ORDER BY `ps_specific_price`.`id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1

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` = 3
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 3) AND (b.`id_shop` = 1) LIMIT 1

SELECT SQL_NO_CACHE `ps_specific_price`.`id_specific_price_rule` as `id_specific_price_rule`,
`ps_specific_price`.`id_specific_price` as `id_specific_price`,
`ps_specific_price`.`id_cart` as `id_cart`,
`ps_specific_price`.`id_product` as `id_product`,
`ps_specific_price`.`id_shop` as `id_shop`,
`ps_specific_price`.`id_shop_group` as `id_shop_group`,
`ps_specific_price`.`id_currency` as `id_currency`,
`ps_specific_price`.`id_country` as `id_country`,
`ps_specific_price`.`id_group` as `id_group`,
`ps_specific_price`.`id_customer` as `id_customer`,
`ps_specific_price`.`id_product_attribute` as 	`id_product_attribute`,
`ps_specific_price`.`price` as `price`,
`ps_specific_price`.`from_quantity` as `from_quantity`,
`ps_specific_price`.`reduction` as `reduction`,
`ps_specific_price`.`reduction_tax` as `reduction_tax`,
`ps_specific_price`.`reduction_type` as `reduction_type`,
`ps_specific_price`.`from` as `from`,
`ps_specific_price`.`to` as `to`,
`ps_specific_price`.`ipa_type` as `ipa_type`,
COUNT(t2.`id_product`) as ipacnt,  ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 177, 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` LEFT JOIN `ps_product_attribute` t2 ON (t2.`id_product_attribute` = 97275 AND (`ps_specific_price`.`ipa_type` IS NULL || `ps_specific_price`.`ipa_type` = 0 || t2.`type` = `ps_specific_price`.`ipa_type`)) WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 177) AND
`id_group` IN (0, 1) AND ps_specific_price.`id_product` = 0 AND ps_specific_price.`id_customer` = 0 AND ps_specific_price.`id_product_attribute` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2025-11-21 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2025-11-21 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 HAVING ipacnt > 0  ORDER BY `ps_specific_price`.`id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1

SELECT SQL_NO_CACHE product_attribute_shop.id_product_attribute
FROM ps_product_attribute pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
WHERE pa.id_product = 400 LIMIT 1

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` = 3 AND cl.id_shop = 1 ) WHERE c.`id_category` = 3 LIMIT 1

SELECT SQL_NO_CACHE `ps_specific_price`.`id_specific_price_rule` as `id_specific_price_rule`,
`ps_specific_price`.`id_specific_price` as `id_specific_price`,
`ps_specific_price`.`id_cart` as `id_cart`,
`ps_specific_price`.`id_product` as `id_product`,
`ps_specific_price`.`id_shop` as `id_shop`,
`ps_specific_price`.`id_shop_group` as `id_shop_group`,
`ps_specific_price`.`id_currency` as `id_currency`,
`ps_specific_price`.`id_country` as `id_country`,
`ps_specific_price`.`id_group` as `id_group`,
`ps_specific_price`.`id_customer` as `id_customer`,
`ps_specific_price`.`id_product_attribute` as 	`id_product_attribute`,
`ps_specific_price`.`price` as `price`,
`ps_specific_price`.`from_quantity` as `from_quantity`,
`ps_specific_price`.`reduction` as `reduction`,
`ps_specific_price`.`reduction_tax` as `reduction_tax`,
`ps_specific_price`.`reduction_type` as `reduction_type`,
`ps_specific_price`.`from` as `from`,
`ps_specific_price`.`to` as `to`,
`ps_specific_price`.`ipa_type` as `ipa_type`,
COUNT(t2.`id_product`) as ipacnt,  ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 177, 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` LEFT JOIN `ps_product_attribute` t2 ON (t2.`id_product_attribute` = 98125 AND (`ps_specific_price`.`ipa_type` IS NULL || `ps_specific_price`.`ipa_type` = 0 || t2.`type` = `ps_specific_price`.`ipa_type`)) WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 177) AND
`id_group` IN (0, 1) AND ps_specific_price.`id_product` = 0 AND ps_specific_price.`id_customer` = 0 AND ps_specific_price.`id_product_attribute` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2025-11-21 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2025-11-21 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 HAVING ipacnt > 0  ORDER BY `ps_specific_price`.`id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1

SELECT SQL_NO_CACHE pf.`id_product`,
pf.`id_feature`,
fl.`name`,
fvl.`value`,
f.`position` as feature_position,
f.`displayval`
FROM `ps_feature_product` pf
INNER JOIN `ps_feature_lang` fl ON (
fl.`id_feature` = pf.`id_feature` 
AND fl.`id_lang` = 3
)
INNER JOIN `ps_feature_value_lang` fvl ON (
fvl.`id_feature_value` = pf.`id_feature_value` 
AND fvl.`id_lang` = 3
)
INNER JOIN `ps_feature` f ON f.`id_feature` = pf.`id_feature`
INNER JOIN `ps_feature_shop` fs ON (
fs.`id_feature` = f.`id_feature` 
AND fs.`id_shop` = 1
)
WHERE pf.`id_product` IN (400)
ORDER BY pf.`id_product`, f.`position` ASC, fvl.`value` ASC

SELECT SQL_NO_CACHE pf.`id_product`,
pf.`id_feature`,
fl.`name`,
fvl.`value`,
f.`position` as feature_position,
f.`displayval`
FROM `ps_feature_product` pf
INNER JOIN `ps_feature_lang` fl ON (
fl.`id_feature` = pf.`id_feature` 
AND fl.`id_lang` = 3
)
INNER JOIN `ps_feature_value_lang` fvl ON (
fvl.`id_feature_value` = pf.`id_feature_value` 
AND fvl.`id_lang` = 3
)
INNER JOIN `ps_feature` f ON f.`id_feature` = pf.`id_feature`
INNER JOIN `ps_feature_shop` fs ON (
fs.`id_feature` = f.`id_feature` 
AND fs.`id_shop` = 1
)
WHERE pf.`id_product` IN (43)
ORDER BY pf.`id_product`, f.`position` ASC, fvl.`value` ASC

SELECT SQL_NO_CACHE `ps_specific_price`.`id_specific_price_rule` as `id_specific_price_rule`,
`ps_specific_price`.`id_specific_price` as `id_specific_price`,
`ps_specific_price`.`id_cart` as `id_cart`,
`ps_specific_price`.`id_product` as `id_product`,
`ps_specific_price`.`id_shop` as `id_shop`,
`ps_specific_price`.`id_shop_group` as `id_shop_group`,
`ps_specific_price`.`id_currency` as `id_currency`,
`ps_specific_price`.`id_country` as `id_country`,
`ps_specific_price`.`id_group` as `id_group`,
`ps_specific_price`.`id_customer` as `id_customer`,
`ps_specific_price`.`id_product_attribute` as 	`id_product_attribute`,
`ps_specific_price`.`price` as `price`,
`ps_specific_price`.`from_quantity` as `from_quantity`,
`ps_specific_price`.`reduction` as `reduction`,
`ps_specific_price`.`reduction_tax` as `reduction_tax`,
`ps_specific_price`.`reduction_type` as `reduction_type`,
`ps_specific_price`.`from` as `from`,
`ps_specific_price`.`to` as `to`,
`ps_specific_price`.`ipa_type` as `ipa_type`,
COUNT(t2.`id_product`) as ipacnt,  ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 177, 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` LEFT JOIN `ps_product_attribute` t2 ON (t2.`id_product_attribute` = 98114 AND (`ps_specific_price`.`ipa_type` IS NULL || `ps_specific_price`.`ipa_type` = 0 || t2.`type` = `ps_specific_price`.`ipa_type`)) WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 177) AND
`id_group` IN (0, 1) AND ps_specific_price.`id_product` = 0 AND ps_specific_price.`id_customer` = 0 AND ps_specific_price.`id_product_attribute` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2025-11-21 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2025-11-21 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 HAVING ipacnt > 0  ORDER BY `ps_specific_price`.`id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1

SELECT SQL_NO_CACHE `ps_specific_price`.`id_specific_price_rule` as `id_specific_price_rule`,
`ps_specific_price`.`id_specific_price` as `id_specific_price`,
`ps_specific_price`.`id_cart` as `id_cart`,
`ps_specific_price`.`id_product` as `id_product`,
`ps_specific_price`.`id_shop` as `id_shop`,
`ps_specific_price`.`id_shop_group` as `id_shop_group`,
`ps_specific_price`.`id_currency` as `id_currency`,
`ps_specific_price`.`id_country` as `id_country`,
`ps_specific_price`.`id_group` as `id_group`,
`ps_specific_price`.`id_customer` as `id_customer`,
`ps_specific_price`.`id_product_attribute` as 	`id_product_attribute`,
`ps_specific_price`.`price` as `price`,
`ps_specific_price`.`from_quantity` as `from_quantity`,
`ps_specific_price`.`reduction` as `reduction`,
`ps_specific_price`.`reduction_tax` as `reduction_tax`,
`ps_specific_price`.`reduction_type` as `reduction_type`,
`ps_specific_price`.`from` as `from`,
`ps_specific_price`.`to` as `to`,
`ps_specific_price`.`ipa_type` as `ipa_type`,
COUNT(t2.`id_product`) as ipacnt,  ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 177, 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` LEFT JOIN `ps_product_attribute` t2 ON (t2.`id_product_attribute` = 97266 AND (`ps_specific_price`.`ipa_type` IS NULL || `ps_specific_price`.`ipa_type` = 0 || t2.`type` = `ps_specific_price`.`ipa_type`)) WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 177) AND
`id_group` IN (0, 1) AND ps_specific_price.`id_product` = 0 AND ps_specific_price.`id_customer` = 0 AND ps_specific_price.`id_product_attribute` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2025-11-21 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2025-11-21 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 HAVING ipacnt > 0  ORDER BY `ps_specific_price`.`id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1

SELECT SQL_NO_CACHE COUNT(DISTINCT `id_product`) FROM `ps_specific_price` WHERE `id_product` != 0 LIMIT 1

SELECT SQL_NO_CACHE `ps_specific_price`.`id_specific_price_rule` as `id_specific_price_rule`,
`ps_specific_price`.`id_specific_price` as `id_specific_price`,
`ps_specific_price`.`id_cart` as `id_cart`,
`ps_specific_price`.`id_product` as `id_product`,
`ps_specific_price`.`id_shop` as `id_shop`,
`ps_specific_price`.`id_shop_group` as `id_shop_group`,
`ps_specific_price`.`id_currency` as `id_currency`,
`ps_specific_price`.`id_country` as `id_country`,
`ps_specific_price`.`id_group` as `id_group`,
`ps_specific_price`.`id_customer` as `id_customer`,
`ps_specific_price`.`id_product_attribute` as 	`id_product_attribute`,
`ps_specific_price`.`price` as `price`,
`ps_specific_price`.`from_quantity` as `from_quantity`,
`ps_specific_price`.`reduction` as `reduction`,
`ps_specific_price`.`reduction_tax` as `reduction_tax`,
`ps_specific_price`.`reduction_type` as `reduction_type`,
`ps_specific_price`.`from` as `from`,
`ps_specific_price`.`to` as `to`,
`ps_specific_price`.`ipa_type` as `ipa_type`,
COUNT(t2.`id_product`) as ipacnt,  ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 177, 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` LEFT JOIN `ps_product_attribute` t2 ON (t2.`id_product_attribute` = 97278 AND (`ps_specific_price`.`ipa_type` IS NULL || `ps_specific_price`.`ipa_type` = 0 || t2.`type` = `ps_specific_price`.`ipa_type`)) WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 177) AND
`id_group` IN (0, 1) AND ps_specific_price.`id_product` = 0 AND ps_specific_price.`id_customer` = 0 AND ps_specific_price.`id_product_attribute` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2025-11-21 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2025-11-21 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 HAVING ipacnt > 0  ORDER BY `ps_specific_price`.`id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1

SELECT SQL_NO_CACHE `ps_specific_price`.`id_specific_price_rule` as `id_specific_price_rule`,
`ps_specific_price`.`id_specific_price` as `id_specific_price`,
`ps_specific_price`.`id_cart` as `id_cart`,
`ps_specific_price`.`id_product` as `id_product`,
`ps_specific_price`.`id_shop` as `id_shop`,
`ps_specific_price`.`id_shop_group` as `id_shop_group`,
`ps_specific_price`.`id_currency` as `id_currency`,
`ps_specific_price`.`id_country` as `id_country`,
`ps_specific_price`.`id_group` as `id_group`,
`ps_specific_price`.`id_customer` as `id_customer`,
`ps_specific_price`.`id_product_attribute` as 	`id_product_attribute`,
`ps_specific_price`.`price` as `price`,
`ps_specific_price`.`from_quantity` as `from_quantity`,
`ps_specific_price`.`reduction` as `reduction`,
`ps_specific_price`.`reduction_tax` as `reduction_tax`,
`ps_specific_price`.`reduction_type` as `reduction_type`,
`ps_specific_price`.`from` as `from`,
`ps_specific_price`.`to` as `to`,
`ps_specific_price`.`ipa_type` as `ipa_type`,
COUNT(t2.`id_product`) as ipacnt,  ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 177, 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` LEFT JOIN `ps_product_attribute` t2 ON (t2.`id_product_attribute` = 98111 AND (`ps_specific_price`.`ipa_type` IS NULL || `ps_specific_price`.`ipa_type` = 0 || t2.`type` = `ps_specific_price`.`ipa_type`)) WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 177) AND
`id_group` IN (0, 1) AND ps_specific_price.`id_product` = 0 AND ps_specific_price.`id_customer` = 0 AND ps_specific_price.`id_product_attribute` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2025-11-21 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2025-11-21 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 HAVING ipacnt > 0  ORDER BY `ps_specific_price`.`id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1

SELECT SQL_NO_CACHE `ps_specific_price`.`id_specific_price_rule` as `id_specific_price_rule`,
`ps_specific_price`.`id_specific_price` as `id_specific_price`,
`ps_specific_price`.`id_cart` as `id_cart`,
`ps_specific_price`.`id_product` as `id_product`,
`ps_specific_price`.`id_shop` as `id_shop`,
`ps_specific_price`.`id_shop_group` as `id_shop_group`,
`ps_specific_price`.`id_currency` as `id_currency`,
`ps_specific_price`.`id_country` as `id_country`,
`ps_specific_price`.`id_group` as `id_group`,
`ps_specific_price`.`id_customer` as `id_customer`,
`ps_specific_price`.`id_product_attribute` as 	`id_product_attribute`,
`ps_specific_price`.`price` as `price`,
`ps_specific_price`.`from_quantity` as `from_quantity`,
`ps_specific_price`.`reduction` as `reduction`,
`ps_specific_price`.`reduction_tax` as `reduction_tax`,
`ps_specific_price`.`reduction_type` as `reduction_type`,
`ps_specific_price`.`from` as `from`,
`ps_specific_price`.`to` as `to`,
`ps_specific_price`.`ipa_type` as `ipa_type`,
COUNT(t2.`id_product`) as ipacnt,  ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 177, 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` LEFT JOIN `ps_product_attribute` t2 ON (t2.`id_product_attribute` = 97274 AND (`ps_specific_price`.`ipa_type` IS NULL || `ps_specific_price`.`ipa_type` = 0 || t2.`type` = `ps_specific_price`.`ipa_type`)) WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 177) AND
`id_group` IN (0, 1) AND ps_specific_price.`id_product` = 0 AND ps_specific_price.`id_customer` = 0 AND ps_specific_price.`id_product_attribute` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2025-11-21 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2025-11-21 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 HAVING ipacnt > 0  ORDER BY `ps_specific_price`.`id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1

SELECT SQL_NO_CACHE p.id_product, p.id_category_default, pl.link_rewrite, p.ean13
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_lang` pl ON (p.`id_product` = pl.`id_product`  AND pl.id_shop = 1 )
WHERE pl.`id_lang` = 3 AND p.`assoc` = "meridian" AND product_shop.`visibility` IN ("both", "catalog") AND product_shop.`active` = 1
ORDER BY p.`id_product`;

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` = 3 AND cl.id_shop = 1 ) WHERE c.`id_category` = 49 LIMIT 1

SELECT SQL_NO_CACHE `ps_specific_price`.`id_specific_price_rule` as `id_specific_price_rule`,
`ps_specific_price`.`id_specific_price` as `id_specific_price`,
`ps_specific_price`.`id_cart` as `id_cart`,
`ps_specific_price`.`id_product` as `id_product`,
`ps_specific_price`.`id_shop` as `id_shop`,
`ps_specific_price`.`id_shop_group` as `id_shop_group`,
`ps_specific_price`.`id_currency` as `id_currency`,
`ps_specific_price`.`id_country` as `id_country`,
`ps_specific_price`.`id_group` as `id_group`,
`ps_specific_price`.`id_customer` as `id_customer`,
`ps_specific_price`.`id_product_attribute` as 	`id_product_attribute`,
`ps_specific_price`.`price` as `price`,
`ps_specific_price`.`from_quantity` as `from_quantity`,
`ps_specific_price`.`reduction` as `reduction`,
`ps_specific_price`.`reduction_tax` as `reduction_tax`,
`ps_specific_price`.`reduction_type` as `reduction_type`,
`ps_specific_price`.`from` as `from`,
`ps_specific_price`.`to` as `to`,
`ps_specific_price`.`ipa_type` as `ipa_type`,
COUNT(t2.`id_product`) as ipacnt,  ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 177, 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` LEFT JOIN `ps_product_attribute` t2 ON (t2.`id_product_attribute` = 98122 AND (`ps_specific_price`.`ipa_type` IS NULL || `ps_specific_price`.`ipa_type` = 0 || t2.`type` = `ps_specific_price`.`ipa_type`)) WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 177) AND
`id_group` IN (0, 1) AND ps_specific_price.`id_product` = 0 AND ps_specific_price.`id_customer` = 0 AND ps_specific_price.`id_product_attribute` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2025-11-21 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2025-11-21 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 HAVING ipacnt > 0  ORDER BY `ps_specific_price`.`id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1

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` = 3 AND cl.id_shop = 1 ) WHERE c.`id_category` = 39 LIMIT 1

SELECT SQL_NO_CACHE `ps_specific_price`.`id_specific_price_rule` as `id_specific_price_rule`,
`ps_specific_price`.`id_specific_price` as `id_specific_price`,
`ps_specific_price`.`id_cart` as `id_cart`,
`ps_specific_price`.`id_product` as `id_product`,
`ps_specific_price`.`id_shop` as `id_shop`,
`ps_specific_price`.`id_shop_group` as `id_shop_group`,
`ps_specific_price`.`id_currency` as `id_currency`,
`ps_specific_price`.`id_country` as `id_country`,
`ps_specific_price`.`id_group` as `id_group`,
`ps_specific_price`.`id_customer` as `id_customer`,
`ps_specific_price`.`id_product_attribute` as 	`id_product_attribute`,
`ps_specific_price`.`price` as `price`,
`ps_specific_price`.`from_quantity` as `from_quantity`,
`ps_specific_price`.`reduction` as `reduction`,
`ps_specific_price`.`reduction_tax` as `reduction_tax`,
`ps_specific_price`.`reduction_type` as `reduction_type`,
`ps_specific_price`.`from` as `from`,
`ps_specific_price`.`to` as `to`,
`ps_specific_price`.`ipa_type` as `ipa_type`,
COUNT(t2.`id_product`) as ipacnt,  ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 177, 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` LEFT JOIN `ps_product_attribute` t2 ON (t2.`id_product_attribute` = 97280 AND (`ps_specific_price`.`ipa_type` IS NULL || `ps_specific_price`.`ipa_type` = 0 || t2.`type` = `ps_specific_price`.`ipa_type`)) WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 177) AND
`id_group` IN (0, 1) AND ps_specific_price.`id_product` = 0 AND ps_specific_price.`id_customer` = 0 AND ps_specific_price.`id_product_attribute` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2025-11-21 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2025-11-21 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 HAVING ipacnt > 0  ORDER BY `ps_specific_price`.`id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1

SELECT SQL_NO_CACHE `ps_specific_price`.`id_specific_price_rule` as `id_specific_price_rule`,
`ps_specific_price`.`id_specific_price` as `id_specific_price`,
`ps_specific_price`.`id_cart` as `id_cart`,
`ps_specific_price`.`id_product` as `id_product`,
`ps_specific_price`.`id_shop` as `id_shop`,
`ps_specific_price`.`id_shop_group` as `id_shop_group`,
`ps_specific_price`.`id_currency` as `id_currency`,
`ps_specific_price`.`id_country` as `id_country`,
`ps_specific_price`.`id_group` as `id_group`,
`ps_specific_price`.`id_customer` as `id_customer`,
`ps_specific_price`.`id_product_attribute` as 	`id_product_attribute`,
`ps_specific_price`.`price` as `price`,
`ps_specific_price`.`from_quantity` as `from_quantity`,
`ps_specific_price`.`reduction` as `reduction`,
`ps_specific_price`.`reduction_tax` as `reduction_tax`,
`ps_specific_price`.`reduction_type` as `reduction_type`,
`ps_specific_price`.`from` as `from`,
`ps_specific_price`.`to` as `to`,
`ps_specific_price`.`ipa_type` as `ipa_type`,
COUNT(t2.`id_product`) as ipacnt,  ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 177, 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` LEFT JOIN `ps_product_attribute` t2 ON (t2.`id_product_attribute` = 97282 AND (`ps_specific_price`.`ipa_type` IS NULL || `ps_specific_price`.`ipa_type` = 0 || t2.`type` = `ps_specific_price`.`ipa_type`)) WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 177) AND
`id_group` IN (0, 1) AND ps_specific_price.`id_product` = 0 AND ps_specific_price.`id_customer` = 0 AND ps_specific_price.`id_product_attribute` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2025-11-21 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2025-11-21 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 HAVING ipacnt > 0  ORDER BY `ps_specific_price`.`id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1

SELECT SQL_NO_CACHE `ps_specific_price`.`id_specific_price_rule` as `id_specific_price_rule`,
`ps_specific_price`.`id_specific_price` as `id_specific_price`,
`ps_specific_price`.`id_cart` as `id_cart`,
`ps_specific_price`.`id_product` as `id_product`,
`ps_specific_price`.`id_shop` as `id_shop`,
`ps_specific_price`.`id_shop_group` as `id_shop_group`,
`ps_specific_price`.`id_currency` as `id_currency`,
`ps_specific_price`.`id_country` as `id_country`,
`ps_specific_price`.`id_group` as `id_group`,
`ps_specific_price`.`id_customer` as `id_customer`,
`ps_specific_price`.`id_product_attribute` as 	`id_product_attribute`,
`ps_specific_price`.`price` as `price`,
`ps_specific_price`.`from_quantity` as `from_quantity`,
`ps_specific_price`.`reduction` as `reduction`,
`ps_specific_price`.`reduction_tax` as `reduction_tax`,
`ps_specific_price`.`reduction_type` as `reduction_type`,
`ps_specific_price`.`from` as `from`,
`ps_specific_price`.`to` as `to`,
`ps_specific_price`.`ipa_type` as `ipa_type`,
COUNT(t2.`id_product`) as ipacnt,  ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 177, 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` LEFT JOIN `ps_product_attribute` t2 ON (t2.`id_product_attribute` = 97272 AND (`ps_specific_price`.`ipa_type` IS NULL || `ps_specific_price`.`ipa_type` = 0 || t2.`type` = `ps_specific_price`.`ipa_type`)) WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 177) AND
`id_group` IN (0, 1) AND ps_specific_price.`id_product` = 0 AND ps_specific_price.`id_customer` = 0 AND ps_specific_price.`id_product_attribute` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2025-11-21 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2025-11-21 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 HAVING ipacnt > 0  ORDER BY `ps_specific_price`.`id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1

SELECT SQL_NO_CACHE `ps_specific_price`.`id_specific_price_rule` as `id_specific_price_rule`,
`ps_specific_price`.`id_specific_price` as `id_specific_price`,
`ps_specific_price`.`id_cart` as `id_cart`,
`ps_specific_price`.`id_product` as `id_product`,
`ps_specific_price`.`id_shop` as `id_shop`,
`ps_specific_price`.`id_shop_group` as `id_shop_group`,
`ps_specific_price`.`id_currency` as `id_currency`,
`ps_specific_price`.`id_country` as `id_country`,
`ps_specific_price`.`id_group` as `id_group`,
`ps_specific_price`.`id_customer` as `id_customer`,
`ps_specific_price`.`id_product_attribute` as 	`id_product_attribute`,
`ps_specific_price`.`price` as `price`,
`ps_specific_price`.`from_quantity` as `from_quantity`,
`ps_specific_price`.`reduction` as `reduction`,
`ps_specific_price`.`reduction_tax` as `reduction_tax`,
`ps_specific_price`.`reduction_type` as `reduction_type`,
`ps_specific_price`.`from` as `from`,
`ps_specific_price`.`to` as `to`,
`ps_specific_price`.`ipa_type` as `ipa_type`,
COUNT(t2.`id_product`) as ipacnt,  ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 177, 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` LEFT JOIN `ps_product_attribute` t2 ON (t2.`id_product_attribute` = 97285 AND (`ps_specific_price`.`ipa_type` IS NULL || `ps_specific_price`.`ipa_type` = 0 || t2.`type` = `ps_specific_price`.`ipa_type`)) WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 177) AND
`id_group` IN (0, 1) AND ps_specific_price.`id_product` = 0 AND ps_specific_price.`id_customer` = 0 AND ps_specific_price.`id_product_attribute` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2025-11-21 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2025-11-21 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 HAVING ipacnt > 0  ORDER BY `ps_specific_price`.`id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1

SELECT SQL_NO_CACHE `ps_specific_price`.`id_specific_price_rule` as `id_specific_price_rule`,
`ps_specific_price`.`id_specific_price` as `id_specific_price`,
`ps_specific_price`.`id_cart` as `id_cart`,
`ps_specific_price`.`id_product` as `id_product`,
`ps_specific_price`.`id_shop` as `id_shop`,
`ps_specific_price`.`id_shop_group` as `id_shop_group`,
`ps_specific_price`.`id_currency` as `id_currency`,
`ps_specific_price`.`id_country` as `id_country`,
`ps_specific_price`.`id_group` as `id_group`,
`ps_specific_price`.`id_customer` as `id_customer`,
`ps_specific_price`.`id_product_attribute` as 	`id_product_attribute`,
`ps_specific_price`.`price` as `price`,
`ps_specific_price`.`from_quantity` as `from_quantity`,
`ps_specific_price`.`reduction` as `reduction`,
`ps_specific_price`.`reduction_tax` as `reduction_tax`,
`ps_specific_price`.`reduction_type` as `reduction_type`,
`ps_specific_price`.`from` as `from`,
`ps_specific_price`.`to` as `to`,
`ps_specific_price`.`ipa_type` as `ipa_type`,
COUNT(t2.`id_product`) as ipacnt,  ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 177, 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` LEFT JOIN `ps_product_attribute` t2 ON (t2.`id_product_attribute` = 97283 AND (`ps_specific_price`.`ipa_type` IS NULL || `ps_specific_price`.`ipa_type` = 0 || t2.`type` = `ps_specific_price`.`ipa_type`)) WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 177) AND
`id_group` IN (0, 1) AND ps_specific_price.`id_product` = 0 AND ps_specific_price.`id_customer` = 0 AND ps_specific_price.`id_product_attribute` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2025-11-21 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2025-11-21 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 HAVING ipacnt > 0  ORDER BY `ps_specific_price`.`id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1

SELECT SQL_NO_CACHE `ps_specific_price`.`id_specific_price_rule` as `id_specific_price_rule`,
`ps_specific_price`.`id_specific_price` as `id_specific_price`,
`ps_specific_price`.`id_cart` as `id_cart`,
`ps_specific_price`.`id_product` as `id_product`,
`ps_specific_price`.`id_shop` as `id_shop`,
`ps_specific_price`.`id_shop_group` as `id_shop_group`,
`ps_specific_price`.`id_currency` as `id_currency`,
`ps_specific_price`.`id_country` as `id_country`,
`ps_specific_price`.`id_group` as `id_group`,
`ps_specific_price`.`id_customer` as `id_customer`,
`ps_specific_price`.`id_product_attribute` as 	`id_product_attribute`,
`ps_specific_price`.`price` as `price`,
`ps_specific_price`.`from_quantity` as `from_quantity`,
`ps_specific_price`.`reduction` as `reduction`,
`ps_specific_price`.`reduction_tax` as `reduction_tax`,
`ps_specific_price`.`reduction_type` as `reduction_type`,
`ps_specific_price`.`from` as `from`,
`ps_specific_price`.`to` as `to`,
`ps_specific_price`.`ipa_type` as `ipa_type`,
COUNT(t2.`id_product`) as ipacnt,  ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 177, 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` LEFT JOIN `ps_product_attribute` t2 ON (t2.`id_product_attribute` = 97287 AND (`ps_specific_price`.`ipa_type` IS NULL || `ps_specific_price`.`ipa_type` = 0 || t2.`type` = `ps_specific_price`.`ipa_type`)) WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 177) AND
`id_group` IN (0, 1) AND ps_specific_price.`id_product` = 0 AND ps_specific_price.`id_customer` = 0 AND ps_specific_price.`id_product_attribute` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2025-11-21 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2025-11-21 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 HAVING ipacnt > 0  ORDER BY `ps_specific_price`.`id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1

SELECT SQL_NO_CACHE `ps_specific_price`.`id_specific_price_rule` as `id_specific_price_rule`,
`ps_specific_price`.`id_specific_price` as `id_specific_price`,
`ps_specific_price`.`id_cart` as `id_cart`,
`ps_specific_price`.`id_product` as `id_product`,
`ps_specific_price`.`id_shop` as `id_shop`,
`ps_specific_price`.`id_shop_group` as `id_shop_group`,
`ps_specific_price`.`id_currency` as `id_currency`,
`ps_specific_price`.`id_country` as `id_country`,
`ps_specific_price`.`id_group` as `id_group`,
`ps_specific_price`.`id_customer` as `id_customer`,
`ps_specific_price`.`id_product_attribute` as 	`id_product_attribute`,
`ps_specific_price`.`price` as `price`,
`ps_specific_price`.`from_quantity` as `from_quantity`,
`ps_specific_price`.`reduction` as `reduction`,
`ps_specific_price`.`reduction_tax` as `reduction_tax`,
`ps_specific_price`.`reduction_type` as `reduction_type`,
`ps_specific_price`.`from` as `from`,
`ps_specific_price`.`to` as `to`,
`ps_specific_price`.`ipa_type` as `ipa_type`,
COUNT(t2.`id_product`) as ipacnt,  ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 177, 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` LEFT JOIN `ps_product_attribute` t2 ON (t2.`id_product_attribute` = 98132 AND (`ps_specific_price`.`ipa_type` IS NULL || `ps_specific_price`.`ipa_type` = 0 || t2.`type` = `ps_specific_price`.`ipa_type`)) WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 177) AND
`id_group` IN (0, 1) AND ps_specific_price.`id_product` = 0 AND ps_specific_price.`id_customer` = 0 AND ps_specific_price.`id_product_attribute` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2025-11-21 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2025-11-21 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 HAVING ipacnt > 0  ORDER BY `ps_specific_price`.`id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1

SELECT SQL_NO_CACHE `ps_specific_price`.`id_specific_price_rule` as `id_specific_price_rule`,
`ps_specific_price`.`id_specific_price` as `id_specific_price`,
`ps_specific_price`.`id_cart` as `id_cart`,
`ps_specific_price`.`id_product` as `id_product`,
`ps_specific_price`.`id_shop` as `id_shop`,
`ps_specific_price`.`id_shop_group` as `id_shop_group`,
`ps_specific_price`.`id_currency` as `id_currency`,
`ps_specific_price`.`id_country` as `id_country`,
`ps_specific_price`.`id_group` as `id_group`,
`ps_specific_price`.`id_customer` as `id_customer`,
`ps_specific_price`.`id_product_attribute` as 	`id_product_attribute`,
`ps_specific_price`.`price` as `price`,
`ps_specific_price`.`from_quantity` as `from_quantity`,
`ps_specific_price`.`reduction` as `reduction`,
`ps_specific_price`.`reduction_tax` as `reduction_tax`,
`ps_specific_price`.`reduction_type` as `reduction_type`,
`ps_specific_price`.`from` as `from`,
`ps_specific_price`.`to` as `to`,
`ps_specific_price`.`ipa_type` as `ipa_type`,
COUNT(t2.`id_product`) as ipacnt,  ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 177, 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` LEFT JOIN `ps_product_attribute` t2 ON (t2.`id_product_attribute` = 98115 AND (`ps_specific_price`.`ipa_type` IS NULL || `ps_specific_price`.`ipa_type` = 0 || t2.`type` = `ps_specific_price`.`ipa_type`)) WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 177) AND
`id_group` IN (0, 1) AND ps_specific_price.`id_product` = 0 AND ps_specific_price.`id_customer` = 0 AND ps_specific_price.`id_product_attribute` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2025-11-21 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2025-11-21 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 HAVING ipacnt > 0  ORDER BY `ps_specific_price`.`id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1

SELECT SQL_NO_CACHE pf.`id_product`,
pf.`id_feature`,
fl.`name`,
fvl.`value`,
f.`position` as feature_position,
f.`displayval`
FROM `ps_feature_product` pf
INNER JOIN `ps_feature_lang` fl ON (
fl.`id_feature` = pf.`id_feature` 
AND fl.`id_lang` = 3
)
INNER JOIN `ps_feature_value_lang` fvl ON (
fvl.`id_feature_value` = pf.`id_feature_value` 
AND fvl.`id_lang` = 3
)
INNER JOIN `ps_feature` f ON f.`id_feature` = pf.`id_feature`
INNER JOIN `ps_feature_shop` fs ON (
fs.`id_feature` = f.`id_feature` 
AND fs.`id_shop` = 1
)
WHERE pf.`id_product` IN (38)
ORDER BY pf.`id_product`, f.`position` ASC, fvl.`value` ASC

SELECT SQL_NO_CACHE `ps_specific_price`.`id_specific_price_rule` as `id_specific_price_rule`,
`ps_specific_price`.`id_specific_price` as `id_specific_price`,
`ps_specific_price`.`id_cart` as `id_cart`,
`ps_specific_price`.`id_product` as `id_product`,
`ps_specific_price`.`id_shop` as `id_shop`,
`ps_specific_price`.`id_shop_group` as `id_shop_group`,
`ps_specific_price`.`id_currency` as `id_currency`,
`ps_specific_price`.`id_country` as `id_country`,
`ps_specific_price`.`id_group` as `id_group`,
`ps_specific_price`.`id_customer` as `id_customer`,
`ps_specific_price`.`id_product_attribute` as 	`id_product_attribute`,
`ps_specific_price`.`price` as `price`,
`ps_specific_price`.`from_quantity` as `from_quantity`,
`ps_specific_price`.`reduction` as `reduction`,
`ps_specific_price`.`reduction_tax` as `reduction_tax`,
`ps_specific_price`.`reduction_type` as `reduction_type`,
`ps_specific_price`.`from` as `from`,
`ps_specific_price`.`to` as `to`,
`ps_specific_price`.`ipa_type` as `ipa_type`,
COUNT(t2.`id_product`) as ipacnt,  ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 177, 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` LEFT JOIN `ps_product_attribute` t2 ON (t2.`id_product_attribute` = 98113 AND (`ps_specific_price`.`ipa_type` IS NULL || `ps_specific_price`.`ipa_type` = 0 || t2.`type` = `ps_specific_price`.`ipa_type`)) WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 177) AND
`id_group` IN (0, 1) AND ps_specific_price.`id_product` = 0 AND ps_specific_price.`id_customer` = 0 AND ps_specific_price.`id_product_attribute` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2025-11-21 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2025-11-21 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 HAVING ipacnt > 0  ORDER BY `ps_specific_price`.`id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1

SELECT SQL_NO_CACHE pf.`id_product`,
pf.`id_feature`,
fl.`name`,
fvl.`value`,
f.`position` as feature_position,
f.`displayval`
FROM `ps_feature_product` pf
INNER JOIN `ps_feature_lang` fl ON (
fl.`id_feature` = pf.`id_feature` 
AND fl.`id_lang` = 3
)
INNER JOIN `ps_feature_value_lang` fvl ON (
fvl.`id_feature_value` = pf.`id_feature_value` 
AND fvl.`id_lang` = 3
)
INNER JOIN `ps_feature` f ON f.`id_feature` = pf.`id_feature`
INNER JOIN `ps_feature_shop` fs ON (
fs.`id_feature` = f.`id_feature` 
AND fs.`id_shop` = 1
)
WHERE pf.`id_product` IN (65)
ORDER BY pf.`id_product`, f.`position` ASC, fvl.`value` ASC

SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_flush) as last_flush FROM `ps_smarty_last_flush` WHERE type='compile' LIMIT 1

SELECT SQL_NO_CACHE `ps_specific_price`.`id_specific_price_rule` as `id_specific_price_rule`,
`ps_specific_price`.`id_specific_price` as `id_specific_price`,
`ps_specific_price`.`id_cart` as `id_cart`,
`ps_specific_price`.`id_product` as `id_product`,
`ps_specific_price`.`id_shop` as `id_shop`,
`ps_specific_price`.`id_shop_group` as `id_shop_group`,
`ps_specific_price`.`id_currency` as `id_currency`,
`ps_specific_price`.`id_country` as `id_country`,
`ps_specific_price`.`id_group` as `id_group`,
`ps_specific_price`.`id_customer` as `id_customer`,
`ps_specific_price`.`id_product_attribute` as 	`id_product_attribute`,
`ps_specific_price`.`price` as `price`,
`ps_specific_price`.`from_quantity` as `from_quantity`,
`ps_specific_price`.`reduction` as `reduction`,
`ps_specific_price`.`reduction_tax` as `reduction_tax`,
`ps_specific_price`.`reduction_type` as `reduction_type`,
`ps_specific_price`.`from` as `from`,
`ps_specific_price`.`to` as `to`,
`ps_specific_price`.`ipa_type` as `ipa_type`,
COUNT(t2.`id_product`) as ipacnt,  ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 177, 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` LEFT JOIN `ps_product_attribute` t2 ON (t2.`id_product_attribute` = 97284 AND (`ps_specific_price`.`ipa_type` IS NULL || `ps_specific_price`.`ipa_type` = 0 || t2.`type` = `ps_specific_price`.`ipa_type`)) WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 177) AND
`id_group` IN (0, 1) AND ps_specific_price.`id_product` = 0 AND ps_specific_price.`id_customer` = 0 AND ps_specific_price.`id_product_attribute` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2025-11-21 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2025-11-21 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 HAVING ipacnt > 0  ORDER BY `ps_specific_price`.`id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1

SELECT SQL_NO_CACHE `ps_specific_price`.`id_specific_price_rule` as `id_specific_price_rule`,
`ps_specific_price`.`id_specific_price` as `id_specific_price`,
`ps_specific_price`.`id_cart` as `id_cart`,
`ps_specific_price`.`id_product` as `id_product`,
`ps_specific_price`.`id_shop` as `id_shop`,
`ps_specific_price`.`id_shop_group` as `id_shop_group`,
`ps_specific_price`.`id_currency` as `id_currency`,
`ps_specific_price`.`id_country` as `id_country`,
`ps_specific_price`.`id_group` as `id_group`,
`ps_specific_price`.`id_customer` as `id_customer`,
`ps_specific_price`.`id_product_attribute` as 	`id_product_attribute`,
`ps_specific_price`.`price` as `price`,
`ps_specific_price`.`from_quantity` as `from_quantity`,
`ps_specific_price`.`reduction` as `reduction`,
`ps_specific_price`.`reduction_tax` as `reduction_tax`,
`ps_specific_price`.`reduction_type` as `reduction_type`,
`ps_specific_price`.`from` as `from`,
`ps_specific_price`.`to` as `to`,
`ps_specific_price`.`ipa_type` as `ipa_type`,
COUNT(t2.`id_product`) as ipacnt,  ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 177, 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` LEFT JOIN `ps_product_attribute` t2 ON (t2.`id_product_attribute` = 98108 AND (`ps_specific_price`.`ipa_type` IS NULL || `ps_specific_price`.`ipa_type` = 0 || t2.`type` = `ps_specific_price`.`ipa_type`)) WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 177) AND
`id_group` IN (0, 1) AND ps_specific_price.`id_product` = 0 AND ps_specific_price.`id_customer` = 0 AND ps_specific_price.`id_product_attribute` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2025-11-21 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2025-11-21 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 HAVING ipacnt > 0  ORDER BY `ps_specific_price`.`id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1

SELECT SQL_NO_CACHE `ps_specific_price`.`id_specific_price_rule` as `id_specific_price_rule`,
`ps_specific_price`.`id_specific_price` as `id_specific_price`,
`ps_specific_price`.`id_cart` as `id_cart`,
`ps_specific_price`.`id_product` as `id_product`,
`ps_specific_price`.`id_shop` as `id_shop`,
`ps_specific_price`.`id_shop_group` as `id_shop_group`,
`ps_specific_price`.`id_currency` as `id_currency`,
`ps_specific_price`.`id_country` as `id_country`,
`ps_specific_price`.`id_group` as `id_group`,
`ps_specific_price`.`id_customer` as `id_customer`,
`ps_specific_price`.`id_product_attribute` as 	`id_product_attribute`,
`ps_specific_price`.`price` as `price`,
`ps_specific_price`.`from_quantity` as `from_quantity`,
`ps_specific_price`.`reduction` as `reduction`,
`ps_specific_price`.`reduction_tax` as `reduction_tax`,
`ps_specific_price`.`reduction_type` as `reduction_type`,
`ps_specific_price`.`from` as `from`,
`ps_specific_price`.`to` as `to`,
`ps_specific_price`.`ipa_type` as `ipa_type`,
COUNT(t2.`id_product`) as ipacnt,  ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 177, 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` LEFT JOIN `ps_product_attribute` t2 ON (t2.`id_product_attribute` = 97277 AND (`ps_specific_price`.`ipa_type` IS NULL || `ps_specific_price`.`ipa_type` = 0 || t2.`type` = `ps_specific_price`.`ipa_type`)) WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 177) AND
`id_group` IN (0, 1) AND ps_specific_price.`id_product` = 0 AND ps_specific_price.`id_customer` = 0 AND ps_specific_price.`id_product_attribute` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2025-11-21 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2025-11-21 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 HAVING ipacnt > 0  ORDER BY `ps_specific_price`.`id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1

SELECT SQL_NO_CACHE `ps_specific_price`.`id_specific_price_rule` as `id_specific_price_rule`,
`ps_specific_price`.`id_specific_price` as `id_specific_price`,
`ps_specific_price`.`id_cart` as `id_cart`,
`ps_specific_price`.`id_product` as `id_product`,
`ps_specific_price`.`id_shop` as `id_shop`,
`ps_specific_price`.`id_shop_group` as `id_shop_group`,
`ps_specific_price`.`id_currency` as `id_currency`,
`ps_specific_price`.`id_country` as `id_country`,
`ps_specific_price`.`id_group` as `id_group`,
`ps_specific_price`.`id_customer` as `id_customer`,
`ps_specific_price`.`id_product_attribute` as 	`id_product_attribute`,
`ps_specific_price`.`price` as `price`,
`ps_specific_price`.`from_quantity` as `from_quantity`,
`ps_specific_price`.`reduction` as `reduction`,
`ps_specific_price`.`reduction_tax` as `reduction_tax`,
`ps_specific_price`.`reduction_type` as `reduction_type`,
`ps_specific_price`.`from` as `from`,
`ps_specific_price`.`to` as `to`,
`ps_specific_price`.`ipa_type` as `ipa_type`,
COUNT(t2.`id_product`) as ipacnt,  ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 177, 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` LEFT JOIN `ps_product_attribute` t2 ON (t2.`id_product_attribute` = 97268 AND (`ps_specific_price`.`ipa_type` IS NULL || `ps_specific_price`.`ipa_type` = 0 || t2.`type` = `ps_specific_price`.`ipa_type`)) WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 177) AND
`id_group` IN (0, 1) AND ps_specific_price.`id_product` = 0 AND ps_specific_price.`id_customer` = 0 AND ps_specific_price.`id_product_attribute` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2025-11-21 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2025-11-21 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 HAVING ipacnt > 0  ORDER BY `ps_specific_price`.`id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1

SELECT SQL_NO_CACHE `ps_specific_price`.`id_specific_price_rule` as `id_specific_price_rule`,
`ps_specific_price`.`id_specific_price` as `id_specific_price`,
`ps_specific_price`.`id_cart` as `id_cart`,
`ps_specific_price`.`id_product` as `id_product`,
`ps_specific_price`.`id_shop` as `id_shop`,
`ps_specific_price`.`id_shop_group` as `id_shop_group`,
`ps_specific_price`.`id_currency` as `id_currency`,
`ps_specific_price`.`id_country` as `id_country`,
`ps_specific_price`.`id_group` as `id_group`,
`ps_specific_price`.`id_customer` as `id_customer`,
`ps_specific_price`.`id_product_attribute` as 	`id_product_attribute`,
`ps_specific_price`.`price` as `price`,
`ps_specific_price`.`from_quantity` as `from_quantity`,
`ps_specific_price`.`reduction` as `reduction`,
`ps_specific_price`.`reduction_tax` as `reduction_tax`,
`ps_specific_price`.`reduction_type` as `reduction_type`,
`ps_specific_price`.`from` as `from`,
`ps_specific_price`.`to` as `to`,
`ps_specific_price`.`ipa_type` as `ipa_type`,
COUNT(t2.`id_product`) as ipacnt,  ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 177, 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` LEFT JOIN `ps_product_attribute` t2 ON (t2.`id_product_attribute` = 97270 AND (`ps_specific_price`.`ipa_type` IS NULL || `ps_specific_price`.`ipa_type` = 0 || t2.`type` = `ps_specific_price`.`ipa_type`)) WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 177) AND
`id_group` IN (0, 1) AND ps_specific_price.`id_product` = 0 AND ps_specific_price.`id_customer` = 0 AND ps_specific_price.`id_product_attribute` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2025-11-21 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2025-11-21 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 HAVING ipacnt > 0  ORDER BY `ps_specific_price`.`id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1

SELECT SQL_NO_CACHE `ps_specific_price`.`id_specific_price_rule` as `id_specific_price_rule`,
`ps_specific_price`.`id_specific_price` as `id_specific_price`,
`ps_specific_price`.`id_cart` as `id_cart`,
`ps_specific_price`.`id_product` as `id_product`,
`ps_specific_price`.`id_shop` as `id_shop`,
`ps_specific_price`.`id_shop_group` as `id_shop_group`,
`ps_specific_price`.`id_currency` as `id_currency`,
`ps_specific_price`.`id_country` as `id_country`,
`ps_specific_price`.`id_group` as `id_group`,
`ps_specific_price`.`id_customer` as `id_customer`,
`ps_specific_price`.`id_product_attribute` as 	`id_product_attribute`,
`ps_specific_price`.`price` as `price`,
`ps_specific_price`.`from_quantity` as `from_quantity`,
`ps_specific_price`.`reduction` as `reduction`,
`ps_specific_price`.`reduction_tax` as `reduction_tax`,
`ps_specific_price`.`reduction_type` as `reduction_type`,
`ps_specific_price`.`from` as `from`,
`ps_specific_price`.`to` as `to`,
`ps_specific_price`.`ipa_type` as `ipa_type`,
COUNT(t2.`id_product`) as ipacnt,  ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 177, 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` LEFT JOIN `ps_product_attribute` t2 ON (t2.`id_product_attribute` = 98119 AND (`ps_specific_price`.`ipa_type` IS NULL || `ps_specific_price`.`ipa_type` = 0 || t2.`type` = `ps_specific_price`.`ipa_type`)) WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 177) AND
`id_group` IN (0, 1) AND ps_specific_price.`id_product` = 0 AND ps_specific_price.`id_customer` = 0 AND ps_specific_price.`id_product_attribute` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2025-11-21 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2025-11-21 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 HAVING ipacnt > 0  ORDER BY `ps_specific_price`.`id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1

SELECT SQL_NO_CACHE `ps_specific_price`.`id_specific_price_rule` as `id_specific_price_rule`,
`ps_specific_price`.`id_specific_price` as `id_specific_price`,
`ps_specific_price`.`id_cart` as `id_cart`,
`ps_specific_price`.`id_product` as `id_product`,
`ps_specific_price`.`id_shop` as `id_shop`,
`ps_specific_price`.`id_shop_group` as `id_shop_group`,
`ps_specific_price`.`id_currency` as `id_currency`,
`ps_specific_price`.`id_country` as `id_country`,
`ps_specific_price`.`id_group` as `id_group`,
`ps_specific_price`.`id_customer` as `id_customer`,
`ps_specific_price`.`id_product_attribute` as 	`id_product_attribute`,
`ps_specific_price`.`price` as `price`,
`ps_specific_price`.`from_quantity` as `from_quantity`,
`ps_specific_price`.`reduction` as `reduction`,
`ps_specific_price`.`reduction_tax` as `reduction_tax`,
`ps_specific_price`.`reduction_type` as `reduction_type`,
`ps_specific_price`.`from` as `from`,
`ps_specific_price`.`to` as `to`,
`ps_specific_price`.`ipa_type` as `ipa_type`,
COUNT(t2.`id_product`) as ipacnt,  ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 177, 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` LEFT JOIN `ps_product_attribute` t2 ON (t2.`id_product_attribute` = 98109 AND (`ps_specific_price`.`ipa_type` IS NULL || `ps_specific_price`.`ipa_type` = 0 || t2.`type` = `ps_specific_price`.`ipa_type`)) WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 177) AND
`id_group` IN (0, 1) AND ps_specific_price.`id_product` = 0 AND ps_specific_price.`id_customer` = 0 AND ps_specific_price.`id_product_attribute` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2025-11-21 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2025-11-21 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 HAVING ipacnt > 0  ORDER BY `ps_specific_price`.`id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1

SELECT SQL_NO_CACHE `ps_specific_price`.`id_specific_price_rule` as `id_specific_price_rule`,
`ps_specific_price`.`id_specific_price` as `id_specific_price`,
`ps_specific_price`.`id_cart` as `id_cart`,
`ps_specific_price`.`id_product` as `id_product`,
`ps_specific_price`.`id_shop` as `id_shop`,
`ps_specific_price`.`id_shop_group` as `id_shop_group`,
`ps_specific_price`.`id_currency` as `id_currency`,
`ps_specific_price`.`id_country` as `id_country`,
`ps_specific_price`.`id_group` as `id_group`,
`ps_specific_price`.`id_customer` as `id_customer`,
`ps_specific_price`.`id_product_attribute` as 	`id_product_attribute`,
`ps_specific_price`.`price` as `price`,
`ps_specific_price`.`from_quantity` as `from_quantity`,
`ps_specific_price`.`reduction` as `reduction`,
`ps_specific_price`.`reduction_tax` as `reduction_tax`,
`ps_specific_price`.`reduction_type` as `reduction_type`,
`ps_specific_price`.`from` as `from`,
`ps_specific_price`.`to` as `to`,
`ps_specific_price`.`ipa_type` as `ipa_type`,
COUNT(t2.`id_product`) as ipacnt,  ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 177, 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` LEFT JOIN `ps_product_attribute` t2 ON (t2.`id_product_attribute` = 97273 AND (`ps_specific_price`.`ipa_type` IS NULL || `ps_specific_price`.`ipa_type` = 0 || t2.`type` = `ps_specific_price`.`ipa_type`)) WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 177) AND
`id_group` IN (0, 1) AND ps_specific_price.`id_product` = 0 AND ps_specific_price.`id_customer` = 0 AND ps_specific_price.`id_product_attribute` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2025-11-21 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2025-11-21 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 HAVING ipacnt > 0  ORDER BY `ps_specific_price`.`id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1

SELECT SQL_NO_CACHE `ps_specific_price`.`id_specific_price_rule` as `id_specific_price_rule`,
`ps_specific_price`.`id_specific_price` as `id_specific_price`,
`ps_specific_price`.`id_cart` as `id_cart`,
`ps_specific_price`.`id_product` as `id_product`,
`ps_specific_price`.`id_shop` as `id_shop`,
`ps_specific_price`.`id_shop_group` as `id_shop_group`,
`ps_specific_price`.`id_currency` as `id_currency`,
`ps_specific_price`.`id_country` as `id_country`,
`ps_specific_price`.`id_group` as `id_group`,
`ps_specific_price`.`id_customer` as `id_customer`,
`ps_specific_price`.`id_product_attribute` as 	`id_product_attribute`,
`ps_specific_price`.`price` as `price`,
`ps_specific_price`.`from_quantity` as `from_quantity`,
`ps_specific_price`.`reduction` as `reduction`,
`ps_specific_price`.`reduction_tax` as `reduction_tax`,
`ps_specific_price`.`reduction_type` as `reduction_type`,
`ps_specific_price`.`from` as `from`,
`ps_specific_price`.`to` as `to`,
`ps_specific_price`.`ipa_type` as `ipa_type`,
COUNT(t2.`id_product`) as ipacnt,  ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 177, 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` LEFT JOIN `ps_product_attribute` t2 ON (t2.`id_product_attribute` = 98112 AND (`ps_specific_price`.`ipa_type` IS NULL || `ps_specific_price`.`ipa_type` = 0 || t2.`type` = `ps_specific_price`.`ipa_type`)) WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 177) AND
`id_group` IN (0, 1) AND ps_specific_price.`id_product` = 0 AND ps_specific_price.`id_customer` = 0 AND ps_specific_price.`id_product_attribute` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2025-11-21 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2025-11-21 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 HAVING ipacnt > 0  ORDER BY `ps_specific_price`.`id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1

SELECT SQL_NO_CACHE `ps_specific_price`.`id_specific_price_rule` as `id_specific_price_rule`,
`ps_specific_price`.`id_specific_price` as `id_specific_price`,
`ps_specific_price`.`id_cart` as `id_cart`,
`ps_specific_price`.`id_product` as `id_product`,
`ps_specific_price`.`id_shop` as `id_shop`,
`ps_specific_price`.`id_shop_group` as `id_shop_group`,
`ps_specific_price`.`id_currency` as `id_currency`,
`ps_specific_price`.`id_country` as `id_country`,
`ps_specific_price`.`id_group` as `id_group`,
`ps_specific_price`.`id_customer` as `id_customer`,
`ps_specific_price`.`id_product_attribute` as 	`id_product_attribute`,
`ps_specific_price`.`price` as `price`,
`ps_specific_price`.`from_quantity` as `from_quantity`,
`ps_specific_price`.`reduction` as `reduction`,
`ps_specific_price`.`reduction_tax` as `reduction_tax`,
`ps_specific_price`.`reduction_type` as `reduction_type`,
`ps_specific_price`.`from` as `from`,
`ps_specific_price`.`to` as `to`,
`ps_specific_price`.`ipa_type` as `ipa_type`,
COUNT(t2.`id_product`) as ipacnt,  ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 177, 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` LEFT JOIN `ps_product_attribute` t2 ON (t2.`id_product_attribute` = 97281 AND (`ps_specific_price`.`ipa_type` IS NULL || `ps_specific_price`.`ipa_type` = 0 || t2.`type` = `ps_specific_price`.`ipa_type`)) WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 177) AND
`id_group` IN (0, 1) AND ps_specific_price.`id_product` = 0 AND ps_specific_price.`id_customer` = 0 AND ps_specific_price.`id_product_attribute` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2025-11-21 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2025-11-21 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 HAVING ipacnt > 0  ORDER BY `ps_specific_price`.`id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1

SELECT SQL_NO_CACHE `ps_specific_price`.`id_specific_price_rule` as `id_specific_price_rule`,
`ps_specific_price`.`id_specific_price` as `id_specific_price`,
`ps_specific_price`.`id_cart` as `id_cart`,
`ps_specific_price`.`id_product` as `id_product`,
`ps_specific_price`.`id_shop` as `id_shop`,
`ps_specific_price`.`id_shop_group` as `id_shop_group`,
`ps_specific_price`.`id_currency` as `id_currency`,
`ps_specific_price`.`id_country` as `id_country`,
`ps_specific_price`.`id_group` as `id_group`,
`ps_specific_price`.`id_customer` as `id_customer`,
`ps_specific_price`.`id_product_attribute` as 	`id_product_attribute`,
`ps_specific_price`.`price` as `price`,
`ps_specific_price`.`from_quantity` as `from_quantity`,
`ps_specific_price`.`reduction` as `reduction`,
`ps_specific_price`.`reduction_tax` as `reduction_tax`,
`ps_specific_price`.`reduction_type` as `reduction_type`,
`ps_specific_price`.`from` as `from`,
`ps_specific_price`.`to` as `to`,
`ps_specific_price`.`ipa_type` as `ipa_type`,
COUNT(t2.`id_product`) as ipacnt,  ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 177, 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` LEFT JOIN `ps_product_attribute` t2 ON (t2.`id_product_attribute` = 98116 AND (`ps_specific_price`.`ipa_type` IS NULL || `ps_specific_price`.`ipa_type` = 0 || t2.`type` = `ps_specific_price`.`ipa_type`)) WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 177) AND
`id_group` IN (0, 1) AND ps_specific_price.`id_product` = 0 AND ps_specific_price.`id_customer` = 0 AND ps_specific_price.`id_product_attribute` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2025-11-21 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2025-11-21 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 HAVING ipacnt > 0  ORDER BY `ps_specific_price`.`id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1

SELECT SQL_NO_CACHE `ps_specific_price`.`id_specific_price_rule` as `id_specific_price_rule`,
`ps_specific_price`.`id_specific_price` as `id_specific_price`,
`ps_specific_price`.`id_cart` as `id_cart`,
`ps_specific_price`.`id_product` as `id_product`,
`ps_specific_price`.`id_shop` as `id_shop`,
`ps_specific_price`.`id_shop_group` as `id_shop_group`,
`ps_specific_price`.`id_currency` as `id_currency`,
`ps_specific_price`.`id_country` as `id_country`,
`ps_specific_price`.`id_group` as `id_group`,
`ps_specific_price`.`id_customer` as `id_customer`,
`ps_specific_price`.`id_product_attribute` as 	`id_product_attribute`,
`ps_specific_price`.`price` as `price`,
`ps_specific_price`.`from_quantity` as `from_quantity`,
`ps_specific_price`.`reduction` as `reduction`,
`ps_specific_price`.`reduction_tax` as `reduction_tax`,
`ps_specific_price`.`reduction_type` as `reduction_type`,
`ps_specific_price`.`from` as `from`,
`ps_specific_price`.`to` as `to`,
`ps_specific_price`.`ipa_type` as `ipa_type`,
COUNT(t2.`id_product`) as ipacnt,  ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 177, 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` LEFT JOIN `ps_product_attribute` t2 ON (t2.`id_product_attribute` = 98126 AND (`ps_specific_price`.`ipa_type` IS NULL || `ps_specific_price`.`ipa_type` = 0 || t2.`type` = `ps_specific_price`.`ipa_type`)) WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 177) AND
`id_group` IN (0, 1) AND ps_specific_price.`id_product` = 0 AND ps_specific_price.`id_customer` = 0 AND ps_specific_price.`id_product_attribute` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2025-11-21 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2025-11-21 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 HAVING ipacnt > 0  ORDER BY `ps_specific_price`.`id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1

SELECT SQL_NO_CACHE `ps_specific_price`.`id_specific_price_rule` as `id_specific_price_rule`,
`ps_specific_price`.`id_specific_price` as `id_specific_price`,
`ps_specific_price`.`id_cart` as `id_cart`,
`ps_specific_price`.`id_product` as `id_product`,
`ps_specific_price`.`id_shop` as `id_shop`,
`ps_specific_price`.`id_shop_group` as `id_shop_group`,
`ps_specific_price`.`id_currency` as `id_currency`,
`ps_specific_price`.`id_country` as `id_country`,
`ps_specific_price`.`id_group` as `id_group`,
`ps_specific_price`.`id_customer` as `id_customer`,
`ps_specific_price`.`id_product_attribute` as 	`id_product_attribute`,
`ps_specific_price`.`price` as `price`,
`ps_specific_price`.`from_quantity` as `from_quantity`,
`ps_specific_price`.`reduction` as `reduction`,
`ps_specific_price`.`reduction_tax` as `reduction_tax`,
`ps_specific_price`.`reduction_type` as `reduction_type`,
`ps_specific_price`.`from` as `from`,
`ps_specific_price`.`to` as `to`,
`ps_specific_price`.`ipa_type` as `ipa_type`,
COUNT(t2.`id_product`) as ipacnt,  ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 177, 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` LEFT JOIN `ps_product_attribute` t2 ON (t2.`id_product_attribute` = 98110 AND (`ps_specific_price`.`ipa_type` IS NULL || `ps_specific_price`.`ipa_type` = 0 || t2.`type` = `ps_specific_price`.`ipa_type`)) WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 177) AND
`id_group` IN (0, 1) AND ps_specific_price.`id_product` = 0 AND ps_specific_price.`id_customer` = 0 AND ps_specific_price.`id_product_attribute` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2025-11-21 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2025-11-21 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 HAVING ipacnt > 0  ORDER BY `ps_specific_price`.`id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1

SELECT SQL_NO_CACHE `ps_specific_price`.`id_specific_price_rule` as `id_specific_price_rule`,
`ps_specific_price`.`id_specific_price` as `id_specific_price`,
`ps_specific_price`.`id_cart` as `id_cart`,
`ps_specific_price`.`id_product` as `id_product`,
`ps_specific_price`.`id_shop` as `id_shop`,
`ps_specific_price`.`id_shop_group` as `id_shop_group`,
`ps_specific_price`.`id_currency` as `id_currency`,
`ps_specific_price`.`id_country` as `id_country`,
`ps_specific_price`.`id_group` as `id_group`,
`ps_specific_price`.`id_customer` as `id_customer`,
`ps_specific_price`.`id_product_attribute` as 	`id_product_attribute`,
`ps_specific_price`.`price` as `price`,
`ps_specific_price`.`from_quantity` as `from_quantity`,
`ps_specific_price`.`reduction` as `reduction`,
`ps_specific_price`.`reduction_tax` as `reduction_tax`,
`ps_specific_price`.`reduction_type` as `reduction_type`,
`ps_specific_price`.`from` as `from`,
`ps_specific_price`.`to` as `to`,
`ps_specific_price`.`ipa_type` as `ipa_type`,
COUNT(t2.`id_product`) as ipacnt,  ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 177, 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` LEFT JOIN `ps_product_attribute` t2 ON (t2.`id_product_attribute` = 98118 AND (`ps_specific_price`.`ipa_type` IS NULL || `ps_specific_price`.`ipa_type` = 0 || t2.`type` = `ps_specific_price`.`ipa_type`)) WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 177) AND
`id_group` IN (0, 1) AND ps_specific_price.`id_product` = 0 AND ps_specific_price.`id_customer` = 0 AND ps_specific_price.`id_product_attribute` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2025-11-21 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2025-11-21 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 HAVING ipacnt > 0  ORDER BY `ps_specific_price`.`id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1

SELECT SQL_NO_CACHE `ps_specific_price`.`id_specific_price_rule` as `id_specific_price_rule`,
`ps_specific_price`.`id_specific_price` as `id_specific_price`,
`ps_specific_price`.`id_cart` as `id_cart`,
`ps_specific_price`.`id_product` as `id_product`,
`ps_specific_price`.`id_shop` as `id_shop`,
`ps_specific_price`.`id_shop_group` as `id_shop_group`,
`ps_specific_price`.`id_currency` as `id_currency`,
`ps_specific_price`.`id_country` as `id_country`,
`ps_specific_price`.`id_group` as `id_group`,
`ps_specific_price`.`id_customer` as `id_customer`,
`ps_specific_price`.`id_product_attribute` as 	`id_product_attribute`,
`ps_specific_price`.`price` as `price`,
`ps_specific_price`.`from_quantity` as `from_quantity`,
`ps_specific_price`.`reduction` as `reduction`,
`ps_specific_price`.`reduction_tax` as `reduction_tax`,
`ps_specific_price`.`reduction_type` as `reduction_type`,
`ps_specific_price`.`from` as `from`,
`ps_specific_price`.`to` as `to`,
`ps_specific_price`.`ipa_type` as `ipa_type`,
COUNT(t2.`id_product`) as ipacnt,  ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 177, 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` LEFT JOIN `ps_product_attribute` t2 ON (t2.`id_product_attribute` = 97276 AND (`ps_specific_price`.`ipa_type` IS NULL || `ps_specific_price`.`ipa_type` = 0 || t2.`type` = `ps_specific_price`.`ipa_type`)) WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 177) AND
`id_group` IN (0, 1) AND ps_specific_price.`id_product` = 0 AND ps_specific_price.`id_customer` = 0 AND ps_specific_price.`id_product_attribute` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2025-11-21 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2025-11-21 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 HAVING ipacnt > 0  ORDER BY `ps_specific_price`.`id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1

SELECT SQL_NO_CACHE `ps_specific_price`.`id_specific_price_rule` as `id_specific_price_rule`,
`ps_specific_price`.`id_specific_price` as `id_specific_price`,
`ps_specific_price`.`id_cart` as `id_cart`,
`ps_specific_price`.`id_product` as `id_product`,
`ps_specific_price`.`id_shop` as `id_shop`,
`ps_specific_price`.`id_shop_group` as `id_shop_group`,
`ps_specific_price`.`id_currency` as `id_currency`,
`ps_specific_price`.`id_country` as `id_country`,
`ps_specific_price`.`id_group` as `id_group`,
`ps_specific_price`.`id_customer` as `id_customer`,
`ps_specific_price`.`id_product_attribute` as 	`id_product_attribute`,
`ps_specific_price`.`price` as `price`,
`ps_specific_price`.`from_quantity` as `from_quantity`,
`ps_specific_price`.`reduction` as `reduction`,
`ps_specific_price`.`reduction_tax` as `reduction_tax`,
`ps_specific_price`.`reduction_type` as `reduction_type`,
`ps_specific_price`.`from` as `from`,
`ps_specific_price`.`to` as `to`,
`ps_specific_price`.`ipa_type` as `ipa_type`,
COUNT(t2.`id_product`) as ipacnt,  ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 177, 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` LEFT JOIN `ps_product_attribute` t2 ON (t2.`id_product_attribute` = 97286 AND (`ps_specific_price`.`ipa_type` IS NULL || `ps_specific_price`.`ipa_type` = 0 || t2.`type` = `ps_specific_price`.`ipa_type`)) WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 177) AND
`id_group` IN (0, 1) AND ps_specific_price.`id_product` = 0 AND ps_specific_price.`id_customer` = 0 AND ps_specific_price.`id_product_attribute` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2025-11-21 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2025-11-21 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 HAVING ipacnt > 0  ORDER BY `ps_specific_price`.`id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1

SELECT SQL_NO_CACHE `ps_specific_price`.`id_specific_price_rule` as `id_specific_price_rule`,
`ps_specific_price`.`id_specific_price` as `id_specific_price`,
`ps_specific_price`.`id_cart` as `id_cart`,
`ps_specific_price`.`id_product` as `id_product`,
`ps_specific_price`.`id_shop` as `id_shop`,
`ps_specific_price`.`id_shop_group` as `id_shop_group`,
`ps_specific_price`.`id_currency` as `id_currency`,
`ps_specific_price`.`id_country` as `id_country`,
`ps_specific_price`.`id_group` as `id_group`,
`ps_specific_price`.`id_customer` as `id_customer`,
`ps_specific_price`.`id_product_attribute` as 	`id_product_attribute`,
`ps_specific_price`.`price` as `price`,
`ps_specific_price`.`from_quantity` as `from_quantity`,
`ps_specific_price`.`reduction` as `reduction`,
`ps_specific_price`.`reduction_tax` as `reduction_tax`,
`ps_specific_price`.`reduction_type` as `reduction_type`,
`ps_specific_price`.`from` as `from`,
`ps_specific_price`.`to` as `to`,
`ps_specific_price`.`ipa_type` as `ipa_type`,
COUNT(t2.`id_product`) as ipacnt,  ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 177, 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` LEFT JOIN `ps_product_attribute` t2 ON (t2.`id_product_attribute` = 97269 AND (`ps_specific_price`.`ipa_type` IS NULL || `ps_specific_price`.`ipa_type` = 0 || t2.`type` = `ps_specific_price`.`ipa_type`)) WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 177) AND
`id_group` IN (0, 1) AND ps_specific_price.`id_product` = 0 AND ps_specific_price.`id_customer` = 0 AND ps_specific_price.`id_product_attribute` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2025-11-21 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2025-11-21 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 HAVING ipacnt > 0  ORDER BY `ps_specific_price`.`id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1

SELECT SQL_NO_CACHE `ps_specific_price`.`id_specific_price_rule` as `id_specific_price_rule`,
`ps_specific_price`.`id_specific_price` as `id_specific_price`,
`ps_specific_price`.`id_cart` as `id_cart`,
`ps_specific_price`.`id_product` as `id_product`,
`ps_specific_price`.`id_shop` as `id_shop`,
`ps_specific_price`.`id_shop_group` as `id_shop_group`,
`ps_specific_price`.`id_currency` as `id_currency`,
`ps_specific_price`.`id_country` as `id_country`,
`ps_specific_price`.`id_group` as `id_group`,
`ps_specific_price`.`id_customer` as `id_customer`,
`ps_specific_price`.`id_product_attribute` as 	`id_product_attribute`,
`ps_specific_price`.`price` as `price`,
`ps_specific_price`.`from_quantity` as `from_quantity`,
`ps_specific_price`.`reduction` as `reduction`,
`ps_specific_price`.`reduction_tax` as `reduction_tax`,
`ps_specific_price`.`reduction_type` as `reduction_type`,
`ps_specific_price`.`from` as `from`,
`ps_specific_price`.`to` as `to`,
`ps_specific_price`.`ipa_type` as `ipa_type`,
COUNT(t2.`id_product`) as ipacnt,  ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 177, 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` LEFT JOIN `ps_product_attribute` t2 ON (t2.`id_product_attribute` = 97271 AND (`ps_specific_price`.`ipa_type` IS NULL || `ps_specific_price`.`ipa_type` = 0 || t2.`type` = `ps_specific_price`.`ipa_type`)) WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 177) AND
`id_group` IN (0, 1) AND ps_specific_price.`id_product` = 0 AND ps_specific_price.`id_customer` = 0 AND ps_specific_price.`id_product_attribute` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2025-11-21 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2025-11-21 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 HAVING ipacnt > 0  ORDER BY `ps_specific_price`.`id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1

SELECT SQL_NO_CACHE `ps_specific_price`.`id_specific_price_rule` as `id_specific_price_rule`,
`ps_specific_price`.`id_specific_price` as `id_specific_price`,
`ps_specific_price`.`id_cart` as `id_cart`,
`ps_specific_price`.`id_product` as `id_product`,
`ps_specific_price`.`id_shop` as `id_shop`,
`ps_specific_price`.`id_shop_group` as `id_shop_group`,
`ps_specific_price`.`id_currency` as `id_currency`,
`ps_specific_price`.`id_country` as `id_country`,
`ps_specific_price`.`id_group` as `id_group`,
`ps_specific_price`.`id_customer` as `id_customer`,
`ps_specific_price`.`id_product_attribute` as 	`id_product_attribute`,
`ps_specific_price`.`price` as `price`,
`ps_specific_price`.`from_quantity` as `from_quantity`,
`ps_specific_price`.`reduction` as `reduction`,
`ps_specific_price`.`reduction_tax` as `reduction_tax`,
`ps_specific_price`.`reduction_type` as `reduction_type`,
`ps_specific_price`.`from` as `from`,
`ps_specific_price`.`to` as `to`,
`ps_specific_price`.`ipa_type` as `ipa_type`,
COUNT(t2.`id_product`) as ipacnt,  ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 177, 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` LEFT JOIN `ps_product_attribute` t2 ON (t2.`id_product_attribute` = 97279 AND (`ps_specific_price`.`ipa_type` IS NULL || `ps_specific_price`.`ipa_type` = 0 || t2.`type` = `ps_specific_price`.`ipa_type`)) WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 177) AND
`id_group` IN (0, 1) AND ps_specific_price.`id_product` = 0 AND ps_specific_price.`id_customer` = 0 AND ps_specific_price.`id_product_attribute` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2025-11-21 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2025-11-21 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 HAVING ipacnt > 0  ORDER BY `ps_specific_price`.`id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1

SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 3
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 44) AND (b.`id_shop` = 1) LIMIT 1

SELECT SQL_NO_CACHE `ps_specific_price`.`id_specific_price_rule` as `id_specific_price_rule`,
`ps_specific_price`.`id_specific_price` as `id_specific_price`,
`ps_specific_price`.`id_cart` as `id_cart`,
`ps_specific_price`.`id_product` as `id_product`,
`ps_specific_price`.`id_shop` as `id_shop`,
`ps_specific_price`.`id_shop_group` as `id_shop_group`,
`ps_specific_price`.`id_currency` as `id_currency`,
`ps_specific_price`.`id_country` as `id_country`,
`ps_specific_price`.`id_group` as `id_group`,
`ps_specific_price`.`id_customer` as `id_customer`,
`ps_specific_price`.`id_product_attribute` as 	`id_product_attribute`,
`ps_specific_price`.`price` as `price`,
`ps_specific_price`.`from_quantity` as `from_quantity`,
`ps_specific_price`.`reduction` as `reduction`,
`ps_specific_price`.`reduction_tax` as `reduction_tax`,
`ps_specific_price`.`reduction_type` as `reduction_type`,
`ps_specific_price`.`from` as `from`,
`ps_specific_price`.`to` as `to`,
`ps_specific_price`.`ipa_type` as `ipa_type`,
COUNT(t2.`id_product`) as ipacnt,  ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 177, 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` LEFT JOIN `ps_product_attribute` t2 ON (t2.`id_product_attribute` = 97267 AND (`ps_specific_price`.`ipa_type` IS NULL || `ps_specific_price`.`ipa_type` = 0 || t2.`type` = `ps_specific_price`.`ipa_type`)) WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 177) AND
`id_group` IN (0, 1) AND ps_specific_price.`id_product` = 0 AND ps_specific_price.`id_customer` = 0 AND ps_specific_price.`id_product_attribute` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2025-11-21 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2025-11-21 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 HAVING ipacnt > 0  ORDER BY `ps_specific_price`.`id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1

SELECT SQL_NO_CACHE `ps_specific_price`.`id_specific_price_rule` as `id_specific_price_rule`,
`ps_specific_price`.`id_specific_price` as `id_specific_price`,
`ps_specific_price`.`id_cart` as `id_cart`,
`ps_specific_price`.`id_product` as `id_product`,
`ps_specific_price`.`id_shop` as `id_shop`,
`ps_specific_price`.`id_shop_group` as `id_shop_group`,
`ps_specific_price`.`id_currency` as `id_currency`,
`ps_specific_price`.`id_country` as `id_country`,
`ps_specific_price`.`id_group` as `id_group`,
`ps_specific_price`.`id_customer` as `id_customer`,
`ps_specific_price`.`id_product_attribute` as 	`id_product_attribute`,
`ps_specific_price`.`price` as `price`,
`ps_specific_price`.`from_quantity` as `from_quantity`,
`ps_specific_price`.`reduction` as `reduction`,
`ps_specific_price`.`reduction_tax` as `reduction_tax`,
`ps_specific_price`.`reduction_type` as `reduction_type`,
`ps_specific_price`.`from` as `from`,
`ps_specific_price`.`to` as `to`,
`ps_specific_price`.`ipa_type` as `ipa_type`,
COUNT(t2.`id_product`) as ipacnt,  ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 177, 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` LEFT JOIN `ps_product_attribute` t2 ON (t2.`id_product_attribute` = 98120 AND (`ps_specific_price`.`ipa_type` IS NULL || `ps_specific_price`.`ipa_type` = 0 || t2.`type` = `ps_specific_price`.`ipa_type`)) WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 177) AND
`id_group` IN (0, 1) AND ps_specific_price.`id_product` = 0 AND ps_specific_price.`id_customer` = 0 AND ps_specific_price.`id_product_attribute` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2025-11-21 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2025-11-21 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 HAVING ipacnt > 0  ORDER BY `ps_specific_price`.`id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1

SELECT SQL_NO_CACHE `ps_specific_price`.`id_specific_price_rule` as `id_specific_price_rule`,
`ps_specific_price`.`id_specific_price` as `id_specific_price`,
`ps_specific_price`.`id_cart` as `id_cart`,
`ps_specific_price`.`id_product` as `id_product`,
`ps_specific_price`.`id_shop` as `id_shop`,
`ps_specific_price`.`id_shop_group` as `id_shop_group`,
`ps_specific_price`.`id_currency` as `id_currency`,
`ps_specific_price`.`id_country` as `id_country`,
`ps_specific_price`.`id_group` as `id_group`,
`ps_specific_price`.`id_customer` as `id_customer`,
`ps_specific_price`.`id_product_attribute` as 	`id_product_attribute`,
`ps_specific_price`.`price` as `price`,
`ps_specific_price`.`from_quantity` as `from_quantity`,
`ps_specific_price`.`reduction` as `reduction`,
`ps_specific_price`.`reduction_tax` as `reduction_tax`,
`ps_specific_price`.`reduction_type` as `reduction_type`,
`ps_specific_price`.`from` as `from`,
`ps_specific_price`.`to` as `to`,
`ps_specific_price`.`ipa_type` as `ipa_type`,
COUNT(t2.`id_product`) as ipacnt,  ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 177, 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` LEFT JOIN `ps_product_attribute` t2 ON (t2.`id_product_attribute` = 98124 AND (`ps_specific_price`.`ipa_type` IS NULL || `ps_specific_price`.`ipa_type` = 0 || t2.`type` = `ps_specific_price`.`ipa_type`)) WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 177) AND
`id_group` IN (0, 1) AND ps_specific_price.`id_product` = 0 AND ps_specific_price.`id_customer` = 0 AND ps_specific_price.`id_product_attribute` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2025-11-21 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2025-11-21 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 HAVING ipacnt > 0  ORDER BY `ps_specific_price`.`id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1

SELECT SQL_NO_CACHE *
FROM `ps_category` c
LEFT JOIN `ps_category_lang` `cl` ON c.id_category = cl.id_category AND id_lang = 3 AND cl.id_shop = 1 
WHERE (c.nleft <= 6 AND c.nright >= 7)
ORDER BY c.nleft

SELECT SQL_NO_CACHE nleft, nright, level_depth
FROM ps_category
WHERE id_category = 2 LIMIT 1

SELECT SQL_NO_CACHE *
FROM `ps_category` c
LEFT JOIN `ps_category_lang` `cl` ON c.id_category = cl.id_category AND id_lang = 3 AND cl.id_shop = 1 
WHERE (c.nleft <= 8 AND c.nright >= 9)
ORDER BY c.nleft

SELECT SQL_NO_CACHE *,
( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 177, 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, 177) AND
`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2025-11-21 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2025-11-21 00:00:00' <= `to`)
ORDER BY `from_quantity` ASC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC

SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 3
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 43) AND (b.`id_shop` = 1) LIMIT 1

SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 44) LIMIT 1

SELECT SQL_NO_CACHE `ps_specific_price`.`id_specific_price_rule` as `id_specific_price_rule`,
`ps_specific_price`.`id_specific_price` as `id_specific_price`,
`ps_specific_price`.`id_cart` as `id_cart`,
`ps_specific_price`.`id_product` as `id_product`,
`ps_specific_price`.`id_shop` as `id_shop`,
`ps_specific_price`.`id_shop_group` as `id_shop_group`,
`ps_specific_price`.`id_currency` as `id_currency`,
`ps_specific_price`.`id_country` as `id_country`,
`ps_specific_price`.`id_group` as `id_group`,
`ps_specific_price`.`id_customer` as `id_customer`,
`ps_specific_price`.`id_product_attribute` as 	`id_product_attribute`,
`ps_specific_price`.`price` as `price`,
`ps_specific_price`.`from_quantity` as `from_quantity`,
`ps_specific_price`.`reduction` as `reduction`,
`ps_specific_price`.`reduction_tax` as `reduction_tax`,
`ps_specific_price`.`reduction_type` as `reduction_type`,
`ps_specific_price`.`from` as `from`,
`ps_specific_price`.`to` as `to`,
`ps_specific_price`.`ipa_type` as `ipa_type`,
( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 177, 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, 177) AND
`id_group` IN (0, 1) AND ps_specific_price.`id_product` = 0 AND ps_specific_price.`id_customer` = 0 AND ps_specific_price.`id_product_attribute` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2025-11-21 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2025-11-21 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `ps_specific_price`.`id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1

SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 3
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 37) AND (b.`id_shop` = 1) LIMIT 1

SELECT SQL_NO_CACHE *,
( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 177, 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, 177) AND
`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2025-11-21 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2025-11-21 00:00:00' <= `to`)
ORDER BY `from_quantity` ASC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC

SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 3
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 65) AND (b.`id_shop` = 1) LIMIT 1

SELECT SQL_NO_CACHE id_shop
FROM `ps_category_shop`
WHERE `id_category` = 40
AND id_shop = 1 LIMIT 1

SELECT SQL_NO_CACHE cl.`link_rewrite`
FROM `ps_category_lang` cl
WHERE `id_lang` = 3
AND cl.id_shop = 1 
AND cl.`id_category` = 116 LIMIT 1

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` = 44)

SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 3
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 38) AND (b.`id_shop` = 1) LIMIT 1

SELECT SQL_NO_CACHE m.`id_module`, m.`name`, (
SELECT id_module
FROM `ps_module_shop` ms
WHERE m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 1
LIMIT 1
) as mshop
FROM `ps_module` m

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` = 3
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 40) AND (b.`id_shop` = 1) LIMIT 1

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` = 3
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 2) AND (b.`id_shop` = 1) LIMIT 1

SELECT SQL_NO_CACHE product_attribute_shop.`price`
FROM `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
WHERE pa.`id_product_attribute` = 97266 LIMIT 1

SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 400
ORDER BY `id_specific_price_priority` DESC LIMIT 1

SELECT SQL_NO_CACHE public_name
FROM `ps_attribute_group_lang` agl
LEFT JOIN `ps_layered_indexable_attribute_group` liag
ON liag.id_attribute_group = agl.id_attribute_group
WHERE indexable IS NULL OR indexable = 0
AND id_lang = 3

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` = 3
AND c.`id_parent` = 2
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC

SELECT SQL_NO_CACHE COUNT(DISTINCT l.id_lang) FROM `ps_lang` l
JOIN ps_lang_shop lang_shop ON (lang_shop.id_lang = l.id_lang AND lang_shop.id_shop = 1)
WHERE l.`active` = 1 LIMIT 1

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` = 400)

SELECT SQL_NO_CACHE g.`id_attribute_group`, g.`url_name` as `group`
FROM `ps_layered_indexable_attribute_group_lang_value` g
LEFT JOIN `ps_attribute` a
ON (a.`id_attribute_group` = g.`id_attribute_group`)
WHERE a.`id_attribute` = 45
AND g.`id_lang` = 3
AND g.`url_name` IS NOT NULL AND g.`url_name` != ''

SELECT SQL_NO_CACHE COUNT(DISTINCT c.id_currency) FROM `ps_currency` c
LEFT JOIN ps_currency_shop cs ON (cs.id_currency = c.id_currency AND cs.id_shop = 1)
WHERE c.`active` = 1 LIMIT 1

SELECT SQL_NO_CACHE * FROM ps_layered_filter WHERE COALESCE(`dedicated`,0) = 0 ORDER BY date_add DESC

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` = 177
AND tr.`id_tax_rules_group` = 0
AND tr.`id_state` IN (0, 0)
AND ('0' BETWEEN tr.`zipcode_from` AND tr.`zipcode_to`
OR (tr.`zipcode_to` = 0 AND tr.`zipcode_from` IN(0, '0')))
ORDER BY tr.`zipcode_from` DESC, tr.`zipcode_to` DESC, tr.`id_state` DESC, tr.`id_country` DESC

SELECT SQL_NO_CACHE pl.`id_product`
FROM `ps_product_lang` pl INNER JOIN `ps_product` p ON (pl.`id_product` = p.`id_product`)
WHERE pl.`link_rewrite` = 'kostyum-meridian-utepl-s-p-kzel-chern' AND p.`id_category_default` = 40 AND pl.`id_lang` = 3 LIMIT 1

SELECT SQL_NO_CACHE nleft, nright, level_depth
FROM ps_category
WHERE id_category = 116 LIMIT 1

SELECT SQL_NO_CACHE pai.`id_image`, pai.`id_product_attribute`, il.`legend`
FROM `ps_product_attribute_image` pai
LEFT JOIN `ps_image_lang` il ON (il.`id_image` = pai.`id_image`)
LEFT JOIN `ps_image` i ON (i.`id_image` = pai.`id_image`)
WHERE pai.`id_product_attribute` IN (98108, 98109, 98110, 98111, 98112, 98113, 98114, 98115, 98116, 98117, 98118, 98119, 98120, 98121, 98122, 98123, 98124, 98125, 98126, 98127, 98128, 98129, 98130, 98131, 98132, 98133) AND il.`id_lang` = 3 ORDER by i.`position`

SELECT SQL_NO_CACHE * FROM ps_layered_category
WHERE id_category = 2
AND id_layered_filter = 1
AND id_shop = 1
GROUP BY `type`, id_value ORDER BY position ASC

SELECT SQL_NO_CACHE cmsl.*, cms.*
FROM `ps_cms_lang` cmsl LEFT JOIN `ps_cms` cms ON (cms.`id_cms` = cmsl.`id_cms`) WHERE cmsl.`link_rewrite` = "r1242362011" AND cmsl.`id_lang` = 3 LIMIT 1

SELECT SQL_NO_CACHE `content`
FROM `ps_cms_lang` WHERE `link_rewrite` = "header-mobile" AND `id_lang` = 3 LIMIT 1

SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`
FROM `ps_product` p
INNER JOIN `ps_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1)
WHERE (p.`id_product` = 44)

SELECT SQL_NO_CACHE cmsl.*, cms.*
FROM `ps_cms_lang` cmsl LEFT JOIN `ps_cms` cms ON (cms.`id_cms` = cmsl.`id_cms`) WHERE cmsl.`link_rewrite` = "header-info" AND cmsl.`id_lang` = 3 LIMIT 1

SELECT SQL_NO_CACHE product_attribute_shop.id_product_attribute
FROM ps_product_attribute pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
WHERE pa.id_product = 44 LIMIT 1

SELECT SQL_NO_CACHE *
FROM ps_product_attachment pa
LEFT JOIN ps_attachment a ON a.id_attachment = pa.id_attachment
LEFT JOIN ps_attachment_lang al ON (a.id_attachment = al.id_attachment AND al.id_lang = 3)
WHERE pa.id_product = 44

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` = 3 AND cl.id_shop = 1 ) WHERE c.`id_category` = 2 LIMIT 1

SELECT SQL_NO_CACHE `id_product`
FROM `ps_product_lang`
WHERE `link_rewrite` = 'kostyum-meridian-utepl-s-p-kzel-chern' AND `id_lang` = 3 LIMIT 1

SELECT SQL_NO_CACHE p.id_product
FROM `ps_product` p
INNER JOIN ps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
WHERE p.id_product = 44
AND DATEDIFF(
product_shop.`date_add`,
DATE_SUB(
"2025-11-21 00:00:00",
INTERVAL 20 DAY
)
) > 0

SELECT SQL_NO_CACHE name
FROM `ps_feature_lang` fl
LEFT JOIN  `ps_layered_indexable_feature` lif
ON lif.id_feature = fl.id_feature
WHERE indexable IS NULL OR indexable = 0
AND id_lang = 3

SELECT SQL_NO_CACHE `id_guest`
FROM `ps_connections`
WHERE `id_guest` = 21569959
AND `date_add` > '2025-11-21 18:59:00'
AND id_shop IN (1) 
ORDER BY `date_add` DESC LIMIT 1

SELECT SQL_NO_CACHE c.`id_parent`,cl.`link_rewrite` FROM `ps_category` c INNER JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category`) WHERE c.`id_category` = 40

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` = 3 AND cl.id_shop = 1 ) WHERE c.`id_category` = 40 LIMIT 1

SELECT SQL_NO_CACHE su.physical_uri, su.virtual_uri, su.domain, su.domain_ssl, t.id_theme, t.name, t.directory
FROM ps_shop s
LEFT JOIN ps_shop_url su ON (s.id_shop = su.id_shop)
LEFT JOIN ps_theme t ON (t.id_theme = s.id_theme)
WHERE s.id_shop = 1
AND s.active = 1 AND s.deleted = 0 AND su.main = 1 LIMIT 1

SELECT SQL_NO_CACHE t.`id_lang`, t.`name`
FROM ps_tag t
LEFT JOIN ps_product_tag pt ON (pt.id_tag = t.id_tag)
WHERE pt.`id_product`=44

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` = 44 AND ctg.`id_group` = 1 LIMIT 1

SELECT SQL_NO_CACHE `content`
FROM `ps_cms_lang` WHERE `link_rewrite` = "popup-banner" AND `id_lang` = 3 LIMIT 1

SELECT SQL_NO_CACHE `content`
FROM `ps_cms_lang` WHERE `link_rewrite` = "popups-global" AND `id_lang` = 3 LIMIT 1

SELECT SQL_NO_CACHE *
FROM `ps_country` a
LEFT JOIN `ps_country_lang` `b` ON a.`id_country` = b.`id_country` AND b.`id_lang` = 3
LEFT JOIN `ps_country_shop` `c` ON a.`id_country` = c.`id_country` AND c.`id_shop` = 1
WHERE (a.`id_country` = 177) LIMIT 1

SELECT SQL_NO_CACHE c.`id_parent`,cl.`link_rewrite` FROM `ps_category` c INNER JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category`) WHERE c.`id_category` = 39

SELECT SQL_NO_CACHE DISTINCT `id_product` FROM `ps_specific_price` WHERE `id_product` != 0

SELECT SQL_NO_CACHE * FROM `ps_hook_alias`

SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 400) AND (id_product_attribute = 97266) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1

SELECT SQL_NO_CACHE g.`id_attribute_group`, g.`url_name` as `group`
FROM `ps_layered_indexable_attribute_group_lang_value` g
LEFT JOIN `ps_attribute` a
ON (a.`id_attribute_group` = g.`id_attribute_group`)
WHERE a.`id_attribute` = 206
AND g.`id_lang` = 3
AND g.`url_name` IS NOT NULL AND g.`url_name` != ''

SELECT SQL_NO_CACHE l.*, ls.`id_shop`
FROM `ps_lang` l
LEFT JOIN `ps_lang_shop` ls ON (l.id_lang = ls.id_lang)

SELECT SQL_NO_CACHE *
FROM `ps_themeconfigurator`
WHERE id_shop = 1 AND id_lang = 3
AND hook = 'footer' AND active = 1
ORDER BY item_order ASC

SELECT SQL_NO_CACHE `content`
FROM `ps_cms_lang` WHERE `link_rewrite` = "footer-content" AND `id_lang` = 3 LIMIT 1

SELECT SQL_NO_CACHE *
FROM `ps_module_currency`
WHERE `id_module` = 74
AND `id_shop` = 1

SELECT SQL_NO_CACHE `content`
FROM `ps_cms_lang` WHERE `link_rewrite` = "popups-product" AND `id_lang` = 3 LIMIT 1

SELECT SQL_NO_CACHE *
FROM `ps_product_lang`
WHERE `id_product` = 44 AND `id_shop` = 1

SELECT SQL_NO_CACHE g.`id_attribute_group`, g.`url_name` as `group`
FROM `ps_layered_indexable_attribute_group_lang_value` g
LEFT JOIN `ps_attribute` a
ON (a.`id_attribute_group` = g.`id_attribute_group`)
WHERE a.`id_attribute` = 192
AND g.`id_lang` = 3
AND g.`url_name` IS NOT NULL AND g.`url_name` != ''

SELECT SQL_NO_CACHE `content`
FROM `ps_cms_lang` WHERE `link_rewrite` = "header" AND `id_lang` = 3 LIMIT 1

SELECT SQL_NO_CACHE *
FROM `ps_currency` a
LEFT JOIN `ps_currency_shop` `c` ON a.`id_currency` = c.`id_currency` AND c.`id_shop` = 1
WHERE (a.`id_currency` = 1) LIMIT 1

SELECT SQL_NO_CACHE `content`
FROM `ps_cms_lang` WHERE `link_rewrite` = "global-css" AND `id_lang` = 3 LIMIT 1

SELECT SQL_NO_CACHE `content`
FROM `ps_cms_lang` WHERE `link_rewrite` = "product-price-bubble" AND `id_lang` = 3 LIMIT 1

SELECT SQL_NO_CACHE g.`id_attribute_group`, g.`url_name` as `group`
FROM `ps_layered_indexable_attribute_group_lang_value` g
LEFT JOIN `ps_attribute` a
ON (a.`id_attribute_group` = g.`id_attribute_group`)
WHERE a.`id_attribute` = 186
AND g.`id_lang` = 3
AND g.`url_name` IS NOT NULL AND g.`url_name` != ''

SELECT SQL_NO_CACHE g.`id_attribute_group`, g.`url_name` as `group`
FROM `ps_layered_indexable_attribute_group_lang_value` g
LEFT JOIN `ps_attribute` a
ON (a.`id_attribute_group` = g.`id_attribute_group`)
WHERE a.`id_attribute` = 202
AND g.`id_lang` = 3
AND g.`url_name` IS NOT NULL AND g.`url_name` != ''

SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='513b0b76549d19389a09f4805e9bc521' AND cache_id="blocktopmenu|1|1|1|177|cache|49" AND compile_id="" LIMIT 1

SELECT SQL_NO_CACHE `content`
FROM `ps_cms_lang` WHERE `link_rewrite` = "header-top-list" AND `id_lang` = 3 LIMIT 1

SELECT SQL_NO_CACHE `id_category` FROM `ps_category_lang` 
WHERE `link_rewrite` = 'zimnie-kostyumy' AND `id_lang` = 3

SELECT SQL_NO_CACHE domain, domain_ssl
FROM ps_shop_url
WHERE main = 1
AND id_shop = 1 LIMIT 1

SELECT SQL_NO_CACHE g.`id_attribute_group`, g.`url_name` as `group`
FROM `ps_layered_indexable_attribute_group_lang_value` g
LEFT JOIN `ps_attribute` a
ON (a.`id_attribute_group` = g.`id_attribute_group`)
WHERE a.`id_attribute` = 204
AND g.`id_lang` = 3
AND g.`url_name` IS NOT NULL AND g.`url_name` != ''

SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='df602a080f066329dcca7158e267499c' AND cache_id="blockcms|2|1|1|1|177" AND compile_id="" LIMIT 1

SELECT SQL_NO_CACHE g.`id_attribute_group`, g.`url_name` as `group`
FROM `ps_layered_indexable_attribute_group_lang_value` g
LEFT JOIN `ps_attribute` a
ON (a.`id_attribute_group` = g.`id_attribute_group`)
WHERE a.`id_attribute` = 42
AND g.`id_lang` = 3
AND g.`url_name` IS NOT NULL AND g.`url_name` != ''

SELECT SQL_NO_CACHE g.`id_attribute_group`, g.`url_name` as `group`
FROM `ps_layered_indexable_attribute_group_lang_value` g
LEFT JOIN `ps_attribute` a
ON (a.`id_attribute_group` = g.`id_attribute_group`)
WHERE a.`id_attribute` = 190
AND g.`id_lang` = 3
AND g.`url_name` IS NOT NULL AND g.`url_name` != ''

SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 44) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1

SELECT SQL_NO_CACHE c.`id_parent`,cl.`link_rewrite` FROM `ps_category` c INNER JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category`) WHERE c.`id_category` = 3

SELECT SQL_NO_CACHE g.`id_attribute_group`, g.`url_name` as `group`
FROM `ps_layered_indexable_attribute_group_lang_value` g
LEFT JOIN `ps_attribute` a
ON (a.`id_attribute_group` = g.`id_attribute_group`)
WHERE a.`id_attribute` = 193
AND g.`id_lang` = 3
AND g.`url_name` IS NOT NULL AND g.`url_name` != ''

SELECT SQL_NO_CACHE *
FROM `ps_lang` a
LEFT JOIN `ps_lang_shop` `c` ON a.`id_lang` = c.`id_lang` AND c.`id_shop` = 1
WHERE (a.`id_lang` = 3) LIMIT 1

SELECT SQL_NO_CACHE g.`id_attribute_group`, g.`url_name` as `group`
FROM `ps_layered_indexable_attribute_group_lang_value` g
LEFT JOIN `ps_attribute` a
ON (a.`id_attribute_group` = g.`id_attribute_group`)
WHERE a.`id_attribute` = 188
AND g.`id_lang` = 3
AND g.`url_name` IS NOT NULL AND g.`url_name` != ''

SELECT SQL_NO_CACHE `id_page`
FROM `ps_page`
WHERE `id_page_type` = 4 AND `id_object` = 44 LIMIT 1

SELECT SQL_NO_CACHE `content`
FROM `ps_cms_lang` WHERE `link_rewrite` = "product-special" AND `id_lang` = 3 LIMIT 1

SELECT SQL_NO_CACHE g.`id_attribute_group`, g.`url_name` as `group`
FROM `ps_layered_indexable_attribute_group_lang_value` g
LEFT JOIN `ps_attribute` a
ON (a.`id_attribute_group` = g.`id_attribute_group`)
WHERE a.`id_attribute` = 203
AND g.`id_lang` = 3
AND g.`url_name` IS NOT NULL AND g.`url_name` != ''

SELECT SQL_NO_CACHE 1 FROM `ps_specific_price` WHERE `from` BETWEEN '2025-11-21 00:00:00' AND '2025-11-21 23:59:59' LIMIT 1

SELECT SQL_NO_CACHE g.`id_attribute_group`, g.`url_name` as `group`
FROM `ps_layered_indexable_attribute_group_lang_value` g
LEFT JOIN `ps_attribute` a
ON (a.`id_attribute_group` = g.`id_attribute_group`)
WHERE a.`id_attribute` = 205
AND g.`id_lang` = 3
AND g.`url_name` IS NOT NULL AND g.`url_name` != ''

SELECT SQL_NO_CACHE g.`id_attribute_group`, g.`url_name` as `group`
FROM `ps_layered_indexable_attribute_group_lang_value` g
LEFT JOIN `ps_attribute` a
ON (a.`id_attribute_group` = g.`id_attribute_group`)
WHERE a.`id_attribute` = 185
AND g.`id_lang` = 3
AND g.`url_name` IS NOT NULL AND g.`url_name` != ''

SELECT SQL_NO_CACHE * FROM `ps_hook_module_exceptions`
WHERE `id_shop` IN (1)

SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "yamodule" LIMIT 1

SELECT SQL_NO_CACHE g.`id_attribute_group`, g.`url_name` as `group`
FROM `ps_layered_indexable_attribute_group_lang_value` g
LEFT JOIN `ps_attribute` a
ON (a.`id_attribute_group` = g.`id_attribute_group`)
WHERE a.`id_attribute` = 194
AND g.`id_lang` = 3
AND g.`url_name` IS NOT NULL AND g.`url_name` != ''

SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "blockcategories" LIMIT 1

SELECT SQL_NO_CACHE *
FROM `ps_shop_group` a
WHERE (a.`id_shop_group` = 1) LIMIT 1

SELECT SQL_NO_CACHE *
FROM `ps_group` a
LEFT JOIN `ps_group_shop` `c` ON a.`id_group` = c.`id_group` AND c.`id_shop` = 1
WHERE (a.`id_group` = 1) LIMIT 1

SELECT SQL_NO_CACHE c.`id_parent`,cl.`link_rewrite` FROM `ps_category` c INNER JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category`) WHERE c.`id_category` = 49

SELECT SQL_NO_CACHE g.`id_attribute_group`, g.`url_name` as `group`
FROM `ps_layered_indexable_attribute_group_lang_value` g
LEFT JOIN `ps_attribute` a
ON (a.`id_attribute_group` = g.`id_attribute_group`)
WHERE a.`id_attribute` = 195
AND g.`id_lang` = 3
AND g.`url_name` IS NOT NULL AND g.`url_name` != ''

SELECT SQL_NO_CACHE COUNT(DISTINCT `id_product_attribute`) FROM `ps_specific_price` WHERE `id_product_attribute` != 0 LIMIT 1

SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "blocklayered" LIMIT 1

SELECT SQL_NO_CACHE g.`id_attribute_group`, g.`url_name` as `group`
FROM `ps_layered_indexable_attribute_group_lang_value` g
LEFT JOIN `ps_attribute` a
ON (a.`id_attribute_group` = g.`id_attribute_group`)
WHERE a.`id_attribute` = 184
AND g.`id_lang` = 3
AND g.`url_name` IS NOT NULL AND g.`url_name` != ''

SELECT SQL_NO_CACHE g.`id_attribute_group`, g.`url_name` as `group`
FROM `ps_layered_indexable_attribute_group_lang_value` g
LEFT JOIN `ps_attribute` a
ON (a.`id_attribute_group` = g.`id_attribute_group`)
WHERE a.`id_attribute` = 187
AND g.`id_lang` = 3
AND g.`url_name` IS NOT NULL AND g.`url_name` != ''

SELECT SQL_NO_CACHE g.`id_attribute_group`, g.`url_name` as `group`
FROM `ps_layered_indexable_attribute_group_lang_value` g
LEFT JOIN `ps_attribute` a
ON (a.`id_attribute_group` = g.`id_attribute_group`)
WHERE a.`id_attribute` = 191
AND g.`id_lang` = 3
AND g.`url_name` IS NOT NULL AND g.`url_name` != ''

SELECT SQL_NO_CACHE `id_product_attribute`
FROM `ps_product_attribute`
WHERE `id_product` = 44

SELECT SQL_NO_CACHE data FROM `ps_layered_friendly_url` WHERE `url_key` = 'c839472b591446c5d9af36451d69f7d7' LIMIT 1

SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 400) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1

SELECT SQL_NO_CACHE g.`id_attribute_group`, g.`url_name` as `group`
FROM `ps_layered_indexable_attribute_group_lang_value` g
LEFT JOIN `ps_attribute` a
ON (a.`id_attribute_group` = g.`id_attribute_group`)
WHERE a.`id_attribute` = 200
AND g.`id_lang` = 3
AND g.`url_name` IS NOT NULL AND g.`url_name` != ''

SELECT SQL_NO_CACHE data FROM `ps_layered_friendly_url` WHERE `url_key` = 'a479534486aec7de64eaf0758d588b44' LIMIT 1

SELECT SQL_NO_CACHE g.`id_attribute_group`, g.`url_name` as `group`
FROM `ps_layered_indexable_attribute_group_lang_value` g
LEFT JOIN `ps_attribute` a
ON (a.`id_attribute_group` = g.`id_attribute_group`)
WHERE a.`id_attribute` = 196
AND g.`id_lang` = 3
AND g.`url_name` IS NOT NULL AND g.`url_name` != ''

SELECT SQL_NO_CACHE g.`id_attribute_group`, g.`url_name` as `group`
FROM `ps_layered_indexable_attribute_group_lang_value` g
LEFT JOIN `ps_attribute` a
ON (a.`id_attribute_group` = g.`id_attribute_group`)
WHERE a.`id_attribute` = 189
AND g.`id_lang` = 3
AND g.`url_name` IS NOT NULL AND g.`url_name` != ''

SELECT SQL_NO_CACHE id_page_type
FROM ps_page_type
WHERE name = 'product' LIMIT 1

SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_flush) as last_flush FROM `ps_smarty_last_flush` WHERE type='template' LIMIT 1

SELECT SQL_NO_CACHE g.`id_attribute_group`, g.`url_name` as `group`
FROM `ps_layered_indexable_attribute_group_lang_value` g
LEFT JOIN `ps_attribute` a
ON (a.`id_attribute_group` = g.`id_attribute_group`)
WHERE a.`id_attribute` = 198
AND g.`id_lang` = 3
AND g.`url_name` IS NOT NULL AND g.`url_name` != ''

SELECT SQL_NO_CACHE g.`id_attribute_group`, g.`url_name` as `group`
FROM `ps_layered_indexable_attribute_group_lang_value` g
LEFT JOIN `ps_attribute` a
ON (a.`id_attribute_group` = g.`id_attribute_group`)
WHERE a.`id_attribute` = 197
AND g.`id_lang` = 3
AND g.`url_name` IS NOT NULL AND g.`url_name` != ''

SELECT SQL_NO_CACHE g.`id_attribute_group`, g.`url_name` as `group`
FROM `ps_layered_indexable_attribute_group_lang_value` g
LEFT JOIN `ps_attribute` a
ON (a.`id_attribute_group` = g.`id_attribute_group`)
WHERE a.`id_attribute` = 201
AND g.`id_lang` = 3
AND g.`url_name` IS NOT NULL AND g.`url_name` != ''

SELECT SQL_NO_CACHE g.`id_attribute_group`, g.`url_name` as `group`
FROM `ps_layered_indexable_attribute_group_lang_value` g
LEFT JOIN `ps_attribute` a
ON (a.`id_attribute_group` = g.`id_attribute_group`)
WHERE a.`id_attribute` = 199
AND g.`id_lang` = 3
AND g.`url_name` IS NOT NULL AND g.`url_name` != ''

SELECT SQL_NO_CACHE nleft, nright, level_depth
FROM ps_category
WHERE id_category = 41 LIMIT 1

SELECT SQL_NO_CACHE depends_on_stock
FROM `ps_stock_available`
WHERE (id_product = 44) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1

SELECT SQL_NO_CACHE id_shop
FROM `ps_group_shop`
WHERE `id_group` = 1
AND id_shop = 1 LIMIT 1

SELECT SQL_NO_CACHE cl.`link_rewrite`
FROM `ps_category_lang` cl
WHERE `id_lang` = 0
AND cl.id_shop = 1 
AND cl.`id_category` = 40 LIMIT 1

SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='513b0b76549d19389a09f4805e9bc521' AND cache_id="blocktopmenu|1|1|1|177|cache|50" AND compile_id="" LIMIT 1

SELECT SQL_NO_CACHE cl.`link_rewrite`
FROM `ps_category_lang` cl
WHERE `id_lang` = 3
AND cl.id_shop = 1 
AND cl.`id_category` = 41 LIMIT 1

SELECT SQL_NO_CACHE out_of_stock
FROM `ps_stock_available`
WHERE (id_product = 44) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1

SELECT SQL_NO_CACHE `width`, `height`
FROM ps_image_type
WHERE `name` = 'large_default' LIMIT 1

SELECT SQL_NO_CACHE value FROM `ps_configuration` WHERE `name` = "PS_MULTISHOP_FEATURE_ACTIVE" LIMIT 1

SELECT SQL_NO_CACHE product_attribute_shop.`price`
FROM `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
WHERE pa.`id_product_attribute` = 97277 LIMIT 1

SELECT SQL_NO_CACHE *
FROM `ps_group_lang`
WHERE `id_group` = 1

SELECT SQL_NO_CACHE * FROM `ps_image_type`

SELECT SQL_NO_CACHE id_shop
FROM `ps_product_shop`
WHERE `id_product` = 44
AND id_shop = 1 LIMIT 1

SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 11 AND `id_shop` = 1 LIMIT 1

SELECT SQL_NO_CACHE *
FROM `ps_shop` a
WHERE (a.`id_shop` = 1) LIMIT 1

SELECT SQL_NO_CACHE 1 FROM `ps_specific_price` WHERE `to` BETWEEN '2025-11-21 00:00:00' AND '2025-11-21 23:59:59' LIMIT 1

SELECT SQL_NO_CACHE cl.`link_rewrite`
FROM `ps_category_lang` cl
WHERE `id_lang` = 3
AND cl.id_shop = 1 
AND cl.`id_category` = 40 LIMIT 1

SELECT SQL_NO_CACHE id_shop
FROM `ps_lang_shop`
WHERE `id_lang` = 3
AND id_shop = 1 LIMIT 1

SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 7 AND `id_shop` = 1 LIMIT 1

SELECT SQL_NO_CACHE *
FROM `ps_theme` a
WHERE (a.`id_theme` = 2) LIMIT 1

SELECT SQL_NO_CACHE `reduction`
FROM `ps_group`
WHERE `id_group` = 1 LIMIT 1

SELECT SQL_NO_CACHE `width`, `height`
FROM ps_image_type
WHERE `name` = 'home_default' LIMIT 1

SELECT SQL_NO_CACHE `name`
FROM `ps_manufacturer`
WHERE `id_manufacturer` = 0
AND `active` = 1 LIMIT 1

SELECT SQL_NO_CACHE `width`, `height`
FROM ps_image_type
WHERE `name` = 'medium_default' LIMIT 1

SELECT SQL_NO_CACHE data FROM `ps_layered_friendly_url` WHERE `url_key` = 'fd9de592f87dd725ffa36b2c5349484a' LIMIT 1

SELECT SQL_NO_CACHE `width`, `height`
FROM ps_image_type
WHERE `name` = 'cart_default' LIMIT 1

SELECT SQL_NO_CACHE data FROM `ps_layered_friendly_url` WHERE `url_key` = '4ffd25066fa919ce08ab8a4ac26922ca' LIMIT 1

SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 44
ORDER BY `id_specific_price_priority` DESC LIMIT 1

SELECT SQL_NO_CACHE id_shop
FROM `ps_currency_shop`
WHERE `id_currency` = 1
AND id_shop = 1 LIMIT 1

SELECT SQL_NO_CACHE data FROM `ps_layered_friendly_url` WHERE `url_key` = '97a22366bac15bd0ed8d8410ba18745e' LIMIT 1

SELECT SQL_NO_CACHE `reduction`
FROM `ps_product_group_reduction_cache`
WHERE `id_product` = 400 AND `id_group` = 1 LIMIT 1

SELECT SQL_NO_CACHE nleft, nright, level_depth
FROM ps_category
WHERE id_category = 40 LIMIT 1

SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 44 AND id_shop=1 LIMIT 1

SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 400 AND id_shop=1 LIMIT 1

SELECT SQL_NO_CACHE * FROM ps_layered_filter WHERE `id_layered_filter` = 1

SELECT SQL_NO_CACHE data FROM `ps_layered_friendly_url` WHERE `url_key` = 'bc27c3bd9bd7f06ec148fae408b99b67' LIMIT 1

SELECT SQL_NO_CACHE data FROM `ps_layered_friendly_url` WHERE `url_key` = '9a1e93a222557bc1fb115c6909fd1d39' LIMIT 1

SELECT SQL_NO_CACHE data FROM `ps_layered_friendly_url` WHERE `url_key` = '3030066a411e6777aaebde7608547b69' LIMIT 1

SELECT SQL_NO_CACHE id_required_field, object_name, field_name
FROM ps_required_field

SELECT SQL_NO_CACHE `reduction`
FROM `ps_product_group_reduction_cache`
WHERE `id_product` = 44 AND `id_group` = 1 LIMIT 1

SELECT SQL_NO_CACHE `name` FROM `ps_supplier` WHERE `id_supplier` = 0 LIMIT 1

DROP TEMPORARY TABLE IF EXISTS ps_cat_restriction