Костюм "Флагман" с брюками, синий + василек

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 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` = 823
ORDER BY `position`

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 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` = 823 AND product_shop.`active` = 1 AND product_shop.`visibility` != 'none'
GROUP BY product_shop.id_product

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` = 823
AND a.`id_attribute` NOT IN(42, 42, 42, 42, 42, 42, 42, 42, 42, 42, 42, 42, 43, 43, 43, 43, 43, 43, 43, 43, 43, 43, 43, 43, 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 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` = 823 ORDER BY sa.`quantity` = 0, a.`position`

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` = 823
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 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` = 826
AND a.`id_attribute` NOT IN(42, 42, 42, 42, 42, 42, 193, 191, 190, 185, 188, 189, 42, 42, 42, 43, 43, 43, 43, 43, 43, 43, 43, 43, 192, 192, 193, 194, 194, 191, 190, 184, 184, 185, 188, 189)

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` = 95216 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 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` = 346 ORDER BY sa.`quantity` = 0, a.`position`

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` = 91482 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 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` = 826 ORDER BY sa.`quantity` = 0, a.`position`

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` = 91497 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 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` = 346
AND a.`id_attribute` NOT IN(42, 42, 42, 42, 42, 208, 209, 210, 211, 212, 42, 42, 43, 43, 43, 43, 43, 43, 43, 45, 45, 207, 207, 208, 209, 210, 211, 212)

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` = 32
AND `active` = 1
AND cg.`id_group` =1
GROUP BY c.`id_category`
ORDER BY `level_depth` ASC, category_shop.`position` ASC

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 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` = 80426)
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` = 80426 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` = 80437 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` = 80431 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.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` = 316
AND `active` = 1
AND cg.`id_group` =1
GROUP BY c.`id_category`
ORDER BY `level_depth` ASC, category_shop.`position` ASC

SELECT SQL_NO_CACHE `id_product`
FROM `ps_product_lang`
WHERE `link_rewrite` = 'kostyum-flagman-s-br-sin-vas' AND `id_lang` = 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` = 80436 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` = 91492 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` = 80439 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 (346)
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` = 95218 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` = 91491 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` = 80429 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` = 80434 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` = 95213 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 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` = 91482)
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` = 91482 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` = 91483 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` = 91488 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` = 91487 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` = 91489 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` = 91493 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` = 91504 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` = 80428 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` = 95222 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` = 91486 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 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` = 95210)
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` = 95210 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` = 80430 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` = 95211 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` = 95210 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.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 <= 26
AND c.nright >= 29
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 `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` = 91503 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` = 91501 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` = 91490 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` = 80427 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` = 91502 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` = 91485 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` = 80433 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` = 80432 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` = 95221 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` = 80438 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` = 95225 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` = 91495 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` = 91484 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` = 80435 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 (823)
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` = 95220 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_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` = 823)

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` = 95212 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` = 95224 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` = 91494 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 SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 346) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 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` = 95214 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 <= 260 AND c.nright >= 311)
ORDER BY c.nleft

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` = 91505 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` = 95215 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` = 95217 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` = 95227 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` = 91496 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` = 91498 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` = 95226 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` = 91499 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` = 91500 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 (826)
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` = 95223 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 nleft, nright, level_depth
FROM ps_category
WHERE id_category = 15 LIMIT 1

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` = "tr-ts-0192011" AND cmsl.`id_lang` = 3 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 (91482, 91483, 91484, 91485, 91486, 91487, 91488, 91489, 91490, 91491, 91492, 91493, 91494, 91495, 91496, 91497, 91498, 91499, 91500, 91501, 91502, 91503, 91504, 91505) AND il.`id_lang` = 3 ORDER by i.`position`

INSERT INTO `ps_connections` (`id_guest`, `id_page`, `ip_address`, `http_referer`, `id_shop`, `id_shop_group`, `date_add`) VALUES ('21568150', '1149', '3628718218', '', '1', '1', '2025-11-21 13:10:26')

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` = 95219 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 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 = 826 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` = 826) 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` = 80426 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 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-flagman-s-br-sin-vas' AND p.`id_category_default` = 32 AND pl.`id_lang` = 3 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` = 823) AND (b.`id_shop` = 1) LIMIT 1

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

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` = 346) AND (b.`id_shop` = 1) 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 = 826 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 product_attribute_shop.default_on = 1  AND pa.id_product = 823 LIMIT 1

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` = "1242802014" AND cmsl.`id_lang` = 3 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` = 14) 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 value FROM ps_configuration WHERE name= 'PS_CACHEFS_DIRECTORY_DEPTH' 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` = 14 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` = 346)

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` = 80433 LIMIT 1

SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 823 AND id_shop=1 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 = 346 LIMIT 1

SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 346) AND (id_product_attribute = 80426) AND (id_shop = 1) AND (id_shop_group = 0) 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` = 15 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 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 = 346 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` = 826)

SELECT SQL_NO_CACHE data FROM `ps_layered_friendly_url` WHERE `url_key` = 'e692a7c3bb4121f5f02c759d5439fead' 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` = 32) AND (b.`id_shop` = 1) 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 = 823
AND DATEDIFF(
product_shop.`date_add`,
DATE_SUB(
"2025-11-21 00:00:00",
INTERVAL 20 DAY
)
) > 0

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` = 823) 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 = 823
AND product_shop.active = 1 LIMIT 1

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

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

SELECT SQL_NO_CACHE data FROM `ps_layered_friendly_url` WHERE `url_key` = '271118b6ca7e51ba85b6fc55f990a3c6' 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` = 32 LIMIT 1

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

SELECT SQL_NO_CACHE data FROM `ps_layered_friendly_url` WHERE `url_key` = 'a479534486aec7de64eaf0758d588b44' 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` = 14

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` = 823 AND ctg.`id_group` = 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`=823

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 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` = 80426 LIMIT 1

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

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

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` = 95210 LIMIT 1

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

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

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

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

SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 823) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) 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 UNIX_TIMESTAMP(last_flush) as last_flush FROM `ps_smarty_last_flush` WHERE type='compile' 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` = 95219 LIMIT 1

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

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

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

SELECT SQL_NO_CACHE data FROM `ps_layered_friendly_url` WHERE `url_key` = 'de25c13f7a0e6bc33f7b6f6f3c43133b' 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` = 823)

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

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

SELECT SQL_NO_CACHE `reduction`
FROM `ps_product_group_reduction_cache`
WHERE `id_product` = 826 AND `id_group` = 1 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 = 823 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 `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 346 AND id_shop=1 LIMIT 1

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

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

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

DROP TEMPORARY TABLE IF EXISTS ps_cat_restriction

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

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 cl.`link_rewrite`
FROM `ps_category_lang` cl
WHERE `id_lang` = 0
AND cl.id_shop = 1 
AND cl.`id_category` = 32 LIMIT 1