Mizuno Nara тениска

SELECT SQL_NO_CACHE c.`name`, cl.`id_lang`, IFNULL(cl.`value`, c.`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 `id_product`
FROM `ps_product_lang`
WHERE (`link_rewrite` = 'mizuno-nara-тениска') AND (`id_lang` = 2) AND (`id_shop` = 7)

SELECT SQL_NO_CACHE h.name, h.title
FROM `ps_hook` h
LEFT JOIN `ps_hook_alias` `ha` ON ha.name = h.name
WHERE (h.name LIKE 'display%' OR h.name IN ("displayHeader","displayLeftColumn","displayRightColumn","displayHome","displayTop","displayFooter","displayFooterProduct","displayMyAccountBlock","displayBackOfficeFooter","displayBackOfficeHeader","displayBackOfficeHome","displayBackOfficeTop","displayBackOfficeCategory","displayAdminOrder","displayAdminCustomers","displayBeforeCarrier","displayBeforePayment","displayCustomerAccount","displayCustomerAccountForm","displayCustomerAccountFormTop","displayLeftColumnProduct","displayMaintenance","displayRightColumnProduct","displayProductTab","displayProductTabContent","displayPaymentReturn","displayPaymentTop","displayProductButtons","displayProductComparison","displayShoppingCart","displayShoppingCartFooter","displayTopColumn","displayProductListFunctionalButtons","displayPDFInvoice","displayInvoice","displayNav","displayMyAccountBlockFooter","displayHomeTab","displayHomeTabContent","displayPricesDropTop","displayPricesDropBelow","displayNewProductsTop","displayNewProductsBelow","displayBestSalesTop","displayBestSalesBelow") or ha.alias IN ("displayHeader","displayLeftColumn","displayRightColumn","displayHome","displayTop","displayFooter","displayFooterProduct","displayMyAccountBlock","displayBackOfficeFooter","displayBackOfficeHeader","displayBackOfficeHome","displayBackOfficeTop","displayBackOfficeCategory","displayAdminOrder","displayAdminCustomers","displayBeforeCarrier","displayBeforePayment","displayCustomerAccount","displayCustomerAccountForm","displayCustomerAccountFormTop","displayLeftColumnProduct","displayMaintenance","displayRightColumnProduct","displayProductTab","displayProductTabContent","displayPaymentReturn","displayPaymentTop","displayProductButtons","displayProductComparison","displayShoppingCart","displayShoppingCartFooter","displayTopColumn","displayProductListFunctionalButtons","displayPDFInvoice","displayInvoice","displayNav","displayMyAccountBlockFooter","displayHomeTab","displayHomeTabContent","displayPricesDropTop","displayPricesDropBelow","displayNewProductsTop","displayNewProductsBelow","displayBestSalesTop","displayBestSalesBelow"))
ORDER BY h.name, h.title

SELECT SQL_NO_CACHE h.`name` as hook, m.`id_module`, h.`id_hook`, m.`name` as module, h.`live_edit`
FROM `ps_module` m
INNER JOIN ps_module_shop module_shop
ON (module_shop.id_module = m.id_module AND module_shop.id_shop = 7 AND module_shop.enable_device & 1)
INNER JOIN `ps_module_shop` ms ON ms.`id_module` = m.`id_module`
INNER JOIN `ps_hook_module` hm ON hm.`id_module` = m.`id_module`
INNER JOIN `ps_hook` h ON hm.`id_hook` = h.`id_hook`
WHERE (h.`name` != "displayPayment" AND h.`name` != "displayPaymentEU") AND (hm.`id_shop` = 7)
GROUP BY hm.id_hook, hm.id_module
ORDER BY hm.`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`, pa.`ean13`, pa.`upc`, product_attribute_shop.`unit_price_impact`,
product_attribute_shop.`minimal_quantity`, product_attribute_shop.`available_date`, ag.`group_type`,
product_attribute_shop.`width`, product_attribute_shop.`height`, product_attribute_shop.`depth`
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 = 7)
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_group = 1  AND stock.id_shop = 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 = 7)
WHERE pa.`id_product` = 588
AND al.`id_lang` = 2
AND agl.`id_lang` = 2
GROUP BY id_attribute_group, id_product_attribute
ORDER BY ag.`position` ASC, a.`position` ASC, agl.`name` ASC

SELECT SQL_NO_CACHE ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, agl.`public_name` AS public_group_name,
a.`id_attribute`, al.`name` AS attribute_name, a.`color` AS attribute_color, product_attribute_shop.`id_product_attribute`,
IFNULL(stock.quantity, 0) AS quantity, product_attribute_shop.`price`, product_attribute_shop.`ecotax`, product_attribute_shop.`weight`,
product_attribute_shop.`default_on`, pa.`reference`, pa.`ean13`, pa.`upc`, product_attribute_shop.`unit_price_impact`,
product_attribute_shop.`minimal_quantity`, product_attribute_shop.`available_date`, ag.`group_type`,
product_attribute_shop.`width`, product_attribute_shop.`height`, product_attribute_shop.`depth`
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 = 7)
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_group = 1  AND stock.id_shop = 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 = 7)
WHERE pa.`id_product` = 588
AND al.`id_lang` = 2
AND agl.`id_lang` = 2
GROUP BY id_attribute_group, id_product_attribute
ORDER BY ag.`position` ASC, a.`position` ASC, agl.`name` ASC

SELECT SQL_NO_CACHE DISTINCT a.`id_attribute`, a.`id_attribute_group`, al.`name` AS `attribute`, agl.`name` AS `group`, pa.`ean13`, pa.`upc`
FROM `ps_attribute` a
LEFT JOIN `ps_attribute_lang` al
ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 2)
LEFT JOIN `ps_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 2)
LEFT JOIN `ps_product_attribute_combination` pac
ON (a.`id_attribute` = pac.`id_attribute`)
LEFT JOIN `ps_product_attribute` pa
ON (pac.`id_product_attribute` = pa.`id_product_attribute`)
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 7)
INNER JOIN ps_attribute_shop attribute_shop
ON (attribute_shop.id_attribute = pac.id_attribute AND attribute_shop.id_shop = 7)
WHERE pa.`id_product` = 588

SELECT SQL_NO_CACHE h.id_hook, h.name AS h_name, h.title, h.description, h.position, h.live_edit, hm.position AS hm_position, m.id_module, m.name, m.active
FROM `ps_hook_module` hm
STRAIGHT_JOIN `ps_hook` h ON (h.id_hook = hm.id_hook AND hm.id_shop = 7)
STRAIGHT_JOIN `ps_module` AS m ON (m.id_module = hm.id_module)
ORDER BY hm.position

SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 236, 4, 0) +  IF (`id_currency` = 4, 8, 0) +  IF (`id_shop` = 7, 16, 0)) AS `score`
FROM `ps_specific_price`
WHERE (`id_shop` IN (0, 7)) AND (`id_currency` IN (0, 4)) AND (`id_country` IN (0, 236)) AND (`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2026-06-04 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2026-06-04 00:00:00' <= `to`)) AND (IF(`from_quantity` > 1, `from_quantity`, 0) <= 1)
ORDER BY `id_cart` DESC, `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1

SELECT SQL_NO_CACHE m.*, ml.`description`, ml.`short_description`
FROM `ps_manufacturer` m
INNER JOIN ps_manufacturer_shop manufacturer_shop
ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 7)
INNER JOIN `ps_manufacturer_lang` ml ON m.`id_manufacturer` = ml.`id_manufacturer`
WHERE (ml.`id_lang` = 2) AND (m.`active` = 1)
GROUP BY m.`id_manufacturer`
ORDER BY m.`name` ASC

SELECT SQL_NO_CACHE s.`id_question`, l.`id_lang`, l.`question`, l.`answer`, MIN(qa.`position`) AS position,
(SELECT qr.`customer_name` FROM `ps_faq_snippets_question_request` qr WHERE qr.`id_question` = s.`id_question` AND qr.`status` = "answered" ORDER BY qr.`date_add` ASC LIMIT 1) AS asked_by_name, (SELECT qr.`date_add` FROM `ps_faq_snippets_question_request` qr WHERE qr.`id_question` = s.`id_question` AND qr.`status` = "answered" ORDER BY qr.`date_add` ASC LIMIT 1) AS asked_at
FROM `ps_faq_snippets_question` s
INNER JOIN `ps_faq_snippets_question_association` qa ON qa.id_question = s.id_question
INNER JOIN `ps_faq_snippets_question_lang` l ON l.id_question = s.id_question
WHERE (qa.`entity_type` = "product") AND (qa.`entity_id` = 588) AND (s.`active` = 1)
GROUP BY s.`id_question`, l.`id_lang`
ORDER BY position ASC, s.`id_question` ASC

SELECT SQL_NO_CACHE b.content, bh.hook_name
FROM ps_tbhtmlblock_lang b
LEFT JOIN ps_tbhtmlblock_hook bh ON (bh.id_block = b.id_block)
LEFT JOIN ps_tbhtmlblock o ON (o.id_block = b.id_block)
WHERE id_lang = 2
AND o.active = 1
GROUP BY b.id_block
ORDER BY bh.hook_name, bh.position

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 p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, pl.`description`, pl.`description_short`, pl.`link_rewrite`,
pl.`meta_description`, pl.`meta_keywords`, pl.`meta_title`, pl.`name`, pl.`available_now`, pl.`available_later`,
image_shop.`id_image` id_image, il.`legend`, m.`name` as manufacturer_name, cl.`name` AS category_default, IFNULL(product_attribute_shop.id_product_attribute, 0) id_product_attribute,
DATEDIFF(
p.`date_add`,
DATE_SUB(
"2026-06-04 00:00:00",
INTERVAL 30 DAY
)
) > 0 AS new
FROM `ps_accessory`
LEFT JOIN `ps_product` p ON p.`id_product` = `id_product_2`
INNER JOIN ps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 7)
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=7)
LEFT JOIN `ps_product_lang` pl ON (
p.`id_product` = pl.`id_product`
AND pl.`id_lang` = 2 AND pl.id_shop = 7 
)
LEFT JOIN `ps_category_lang` cl ON (
product_shop.`id_category_default` = cl.`id_category`
AND cl.`id_lang` = 2 AND cl.id_shop = 7 
)
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=7)
LEFT JOIN `ps_image_lang` il ON (image_shop.`id_image` = il.`id_image` AND il.`id_lang` = 2)
LEFT JOIN `ps_manufacturer` m ON (p.`id_manufacturer`= m.`id_manufacturer`)
LEFT JOIN ps_stock_available stock
ON (stock.id_product = p.id_product AND stock.id_product_attribute = 0 AND stock.id_shop_group = 1  AND stock.id_shop = 0  )
WHERE `id_product_1` = 588 AND product_shop.`active` = 1 AND product_shop.`visibility` != 'none'
GROUP BY product_shop.id_product

SELECT SQL_NO_CACHE `id_category`
FROM `ps_category_lang`
WHERE (`link_rewrite` = 'mizuno-nara-тениска') AND (`id_lang` = 2) AND (`id_shop` = 7)

SELECT SQL_NO_CACHE c.*, cl.id_lang, cl.name, cl.description, cl.link_rewrite, cl.meta_title, cl.meta_keywords, cl.meta_description
FROM `ps_category` c
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 7)
LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND `id_lang` = 2  AND cl.id_shop = 7 )
WHERE `id_parent` = 89
AND category_shop.`active` = 1
GROUP BY c.`id_category`
ORDER BY `level_depth` ASC, category_shop.`position` ASC

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

SELECT SQL_NO_CACHE s.*, sl.`description`
FROM `ps_supplier` s
LEFT JOIN `ps_supplier_lang` `sl` ON s.`id_supplier` = sl.`id_supplier` AND sl.`id_lang` = 2
INNER JOIN ps_supplier_shop supplier_shop
ON (supplier_shop.id_supplier = s.id_supplier AND supplier_shop.id_shop = 7)
WHERE (s.`active` = 1)
GROUP BY s.id_supplier
ORDER BY  s.`name` ASC

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

SELECT SQL_NO_CACHE id_review, id_criterion, grade FROM ps_revws_review_grade WHERE id_review IN (119, 118, 116, 114, 111, 106, 104, 102, 98, 96, 94, 93, 92, 91, 89, 88, 86, 85, 81, 80, 78, 76, 74, 73, 72, 71, 68, 65, 63, 62, 61, 60, 59, 58, 56, 52, 51, 49, 48, 47, 46, 43, 42, 40, 38, 36, 30, 29, 24, 23, 22, 21, 20, 19, 18, 17, 16, 15, 13, 12, 11, 9, 7, 6) ORDER by id_review, id_criterion

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 (8128, 8129, 8130, 8131, 8132, 8133, 8134, 8135, 8136, 8137, 8138, 8139, 8140, 8141, 8142, 8143, 8144, 8145, 8146, 8147, 8148, 8149, 8150, 8151, 8152, 8153, 8154, 8155, 8156, 8157, 8158, 8159, 8160, 8161, 8162, 8163, 8164, 8165, 8166, 8167, 8168, 8169, 8170, 8171, 8172, 8173, 8174, 8175, 8176, 8177, 8178, 8179, 8180, 8181, 8182, 8183, 8184, 8185, 8186, 8187, 8188, 8189, 8190, 8191, 8192, 8193, 8194, 8195, 8196, 8197, 8198, 8199, 8200, 8201, 8202, 8203, 8204, 8205, 8206, 8207, 8208, 8209, 8210, 8211) AND il.`id_lang` = 2 ORDER BY i.`position`

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

SELECT SQL_NO_CACHE s.`id_question`, l.`id_lang`, l.`question`, l.`answer`, MIN(qa.`position`) AS position,
(SELECT qr.`customer_name` FROM `ps_faq_snippets_question_request` qr WHERE qr.`id_question` = s.`id_question` AND qr.`status` = "answered" ORDER BY qr.`date_add` ASC LIMIT 1) AS asked_by_name, (SELECT qr.`date_add` FROM `ps_faq_snippets_question_request` qr WHERE qr.`id_question` = s.`id_question` AND qr.`status` = "answered" ORDER BY qr.`date_add` ASC LIMIT 1) AS asked_at
FROM `ps_faq_snippets_question` s
INNER JOIN `ps_faq_snippets_question_association` qa ON qa.id_question = s.id_question
INNER JOIN `ps_faq_snippets_question_lang` l ON l.id_question = s.id_question
WHERE (qa.`entity_type` = "product") AND (qa.`entity_id` = 588) AND (s.`active` = 1)
GROUP BY s.`id_question`, l.`id_lang`
ORDER BY position ASC, s.`id_question` ASC

SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 236, 4, 0) +  IF (`id_currency` = 4, 8, 0) +  IF (`id_shop` = 7, 16, 0)) AS `score`
FROM `ps_specific_price`
WHERE (`id_shop` IN (0, 7)) AND (`id_currency` IN (0, 4)) AND (`id_country` IN (0, 236)) AND (`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2026-06-04 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2026-06-04 00:00:00' <= `to`)) AND (IF(`from_quantity` > 1, `from_quantity`, 0) <= 1)
ORDER BY `id_cart` DESC, `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1

SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 236, 4, 0) +  IF (`id_currency` = 4, 8, 0) +  IF (`id_shop` = 7, 16, 0)) AS `score`
FROM `ps_specific_price`
WHERE (`id_shop` IN (0, 7)) AND (`id_currency` IN (0, 4)) AND (`id_country` IN (0, 236)) AND (`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2026-06-04 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2026-06-04 00:00:00' <= `to`)) AND (IF(`from_quantity` > 1, `from_quantity`, 0) <= 1)
ORDER BY `id_cart` DESC, `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_criterion AS id
FROM ps_revws_criterion c WHERE c.active=1 AND c.global=1 AND c.entity_type='product'
UNION
SELECT DISTINCT c.id_criterion
FROM ps_product_shop ps
INNER JOIN ps_revws_criterion_category cc ON (cc.id_category = ps.id_category_default)
INNER JOIN ps_revws_criterion c ON (cc.id_criterion = c.id_criterion)
WHERE c.active=1 AND ps.id_product=588 AND ps.id_shop=7
UNION
SELECT DISTINCT c.id_criterion
FROM ps_product_shop ps
INNER JOIN ps_revws_criterion_product cp ON (cp.id_product = ps.id_product)
INNER JOIN ps_revws_criterion c ON (cp.id_criterion = c.id_criterion)
WHERE c.active=1 AND ps.id_product=588 AND ps.id_shop=7

SELECT SQL_NO_CACHE DISTINCT m.name
FROM `ps_module` m
INNER JOIN `ps_module_shop` ms ON ms.`id_module` = m.`id_module`
INNER JOIN `ps_hook_module` hm ON hm.`id_module` = m.`id_module` AND hm.`id_shop` = ms.`id_shop`
INNER JOIN `ps_hook` h ON hm.`id_hook` = h.`id_hook`
WHERE (ms.id_shop = 7) AND (m.active) AND (ms.enable_device > 0) AND (h.name = "actionDetectMobile")
ORDER BY hm.position

SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 236, 4, 0) +  IF (`id_currency` = 4, 8, 0) +  IF (`id_shop` = 7, 16, 0)) AS `score`
FROM `ps_specific_price`
WHERE (`id_shop` IN (0, 7)) AND (`id_currency` IN (0, 4)) AND (`id_country` IN (0, 236)) AND (`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2026-06-04 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2026-06-04 00:00:00' <= `to`)) AND (IF(`from_quantity` > 1, `from_quantity`, 0) <= 1)
ORDER BY `id_cart` DESC, `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1

SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` AS `group`
FROM `ps_attribute` a
LEFT JOIN `ps_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 2)
LEFT JOIN `ps_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `ps_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 7)
LEFT JOIN `ps_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 2)
WHERE pa.`id_product` = 588
AND pac.`id_product_attribute` = 8179
AND agl.`id_lang` = 2

SELECT SQL_NO_CACHE COALESCE(NULLIF(fl.public_name, ''), fl.name) AS name, fvl.value, IFNULL(pfl.displayable, fvl.displayable) AS displayable, fl.multiple_schema, fl.multiple_separator, pf.id_feature, f.allows_multiple_values
FROM ps_feature_product pf
LEFT JOIN ps_feature_product_lang pfl ON (pfl.id_feature_value = pf.id_feature_value AND pfl.id_lang = 2 AND pfl.id_product = 588)
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 2)
LEFT JOIN ps_feature_value fv ON (fv.id_feature_value = pf.id_feature_value)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 2)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 2)
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 7)
WHERE pf.id_product = 588
ORDER BY f.position ASC,
(CASE WHEN f.sorting=0 THEN fvl.value END) ASC,
(CASE WHEN f.sorting=1 THEN fvl.value END) DESC,
(CASE WHEN f.sorting=2 THEN fv.position END) ASC

SELECT SQL_NO_CACHE product_shop.`price`,
product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) AS id_product_attribute,
product_attribute_shop.`price` AS attribute_price,
product_attribute_shop.default_on,
product_attribute_shop.`ecotax` AS attribute_ecotax
FROM `ps_product` p
INNER JOIN `ps_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 7)
LEFT JOIN `ps_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 7)
WHERE (p.`id_product` = 588)

SELECT SQL_NO_CACHE *
FROM `ps_bp_bulletpoint` a0
LEFT JOIN `ps_bp_bulletpoint_lang` `a1` ON (a0.`id_bp_bulletpoint` = a1.`id_bp_bulletpoint`)
WHERE (a0.`entity_type` = 'ATTRIBUTE') AND (a0.`entity_id` IN(4, 5))
ORDER BY a0.`position` asc, a0.`id_bp_bulletpoint` asc

SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 236, 4, 0) +  IF (`id_currency` = 4, 8, 0) +  IF (`id_shop` = 7, 16, 0)) AS `score`
FROM `ps_specific_price`
WHERE (`id_shop` IN (0, 7)) AND (`id_currency` IN (0, 4)) AND (`id_country` IN (0, 236)) AND (`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2026-06-04 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2026-06-04 00:00:00' <= `to`)) AND (IF(`from_quantity` > 1, `from_quantity`, 0) <= 1)
ORDER BY `id_cart` DESC, `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1

SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 236, 4, 0) +  IF (`id_currency` = 4, 8, 0) +  IF (`id_shop` = 7, 16, 0)) AS `score`
FROM `ps_specific_price`
WHERE (`id_shop` IN (0, 7)) AND (`id_currency` IN (0, 4)) AND (`id_country` IN (0, 236)) AND (`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2026-06-04 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2026-06-04 00:00:00' <= `to`)) AND (IF(`from_quantity` > 1, `from_quantity`, 0) <= 1)
ORDER BY `id_cart` DESC, `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1

SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 236, 4, 0) +  IF (`id_currency` = 4, 8, 0) +  IF (`id_shop` = 7, 16, 0)) AS `score`
FROM `ps_specific_price`
WHERE (`id_shop` IN (0, 7)) AND (`id_currency` IN (0, 4)) AND (`id_country` IN (0, 236)) AND (`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2026-06-04 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2026-06-04 00:00:00' <= `to`)) AND (IF(`from_quantity` > 1, `from_quantity`, 0) <= 1)
ORDER BY `id_cart` DESC, `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1

SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 236, 4, 0) +  IF (`id_currency` = 4, 8, 0) +  IF (`id_shop` = 7, 16, 0)) AS `score`
FROM `ps_specific_price`
WHERE (`id_shop` IN (0, 7)) AND (`id_currency` IN (0, 4)) AND (`id_country` IN (0, 236)) AND (`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2026-06-04 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2026-06-04 00:00:00' <= `to`)) AND (IF(`from_quantity` > 1, `from_quantity`, 0) <= 1)
ORDER BY `id_cart` DESC, `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1

SELECT SQL_NO_CACHE r.id_review AS `id_review`, r.id_guest AS `id_guest`, r.id_customer AS `id_customer`, r.entity_type AS `entity_type`, r.id_entity AS `id_entity`, r.id_lang AS `id_lang`, r.display_name AS `display_name`, r.email AS `email`, r.title AS `title`, r.content AS `content`, r.reply AS `reply`, r.date_add AS `date_add`, r.date_upd AS `date_upd`, r.validated AS `validated`, r.deleted AS `deleted`, r.verified_buyer AS `verified_buyer`
FROM ps_revws_review r
WHERE r.id_guest = 0 AND r.deleted = 0
ORDER BY r.id_review DESC, r.id_review DESC

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

SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 236, 4, 0) +  IF (`id_currency` = 4, 8, 0) +  IF (`id_shop` = 7, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE (`id_shop` IN (0, 7)) AND (`id_currency` IN (0, 4)) AND (`id_country` IN (0, 236)) AND (`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2026-06-04 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2026-06-04 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_MULTISHOP_FEATURE_ACTIVE" LIMIT 1

SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `ps_image` i
INNER JOIN ps_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 7)
LEFT JOIN `ps_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 2)
WHERE i.`id_product` = 588
ORDER BY `position`

SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 236, 4, 0) +  IF (`id_currency` = 4, 8, 0) +  IF (`id_shop` = 7, 16, 0)) AS `score`
FROM `ps_specific_price`
WHERE (`id_shop` IN (0, 7)) AND (`id_currency` IN (0, 4)) AND (`id_country` IN (0, 236)) AND (`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2026-06-04 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2026-06-04 00:00:00' <= `to`)) AND (IF(`from_quantity` > 1, `from_quantity`, 0) <= 1)
ORDER BY `id_cart` DESC, `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1

SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` AS `group`
FROM `ps_attribute` a
LEFT JOIN `ps_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 2)
LEFT JOIN `ps_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `ps_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 7)
LEFT JOIN `ps_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 2)
WHERE pa.`id_product` = 588
AND pac.`id_product_attribute` = 8203
AND agl.`id_lang` = 2

SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 236, 4, 0) +  IF (`id_currency` = 4, 8, 0) +  IF (`id_shop` = 7, 16, 0)) AS `score`
FROM `ps_specific_price`
WHERE (`id_shop` IN (0, 7)) AND (`id_currency` IN (0, 4)) AND (`id_country` IN (0, 236)) AND (`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2026-06-04 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2026-06-04 00:00:00' <= `to`)) AND (IF(`from_quantity` > 1, `from_quantity`, 0) <= 1)
ORDER BY `id_cart` DESC, `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1

SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module` AS `mshop`
FROM `ps_module` m
LEFT JOIN `ps_module_shop` `ms` ON ms.`id_module` = m.`id_module` AND ms.`id_shop` = 7

SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 236, 4, 0) +  IF (`id_currency` = 4, 8, 0) +  IF (`id_shop` = 7, 16, 0)) AS `score`
FROM `ps_specific_price`
WHERE (`id_shop` IN (0, 7)) AND (`id_currency` IN (0, 4)) AND (`id_country` IN (0, 236)) AND (`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2026-06-04 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2026-06-04 00:00:00' <= `to`)) AND (IF(`from_quantity` > 1, `from_quantity`, 0) <= 1)
ORDER BY `id_cart` DESC, `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1

SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module` AS `mshop`
FROM `ps_module` m
LEFT JOIN `ps_module_shop` `ms` ON ms.`id_module` = m.`id_module` AND ms.`id_shop` = 7

SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` AS `group`
FROM `ps_attribute` a
LEFT JOIN `ps_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 2)
LEFT JOIN `ps_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `ps_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 7)
LEFT JOIN `ps_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 2)
WHERE pa.`id_product` = 588
AND pac.`id_product_attribute` = 8156
AND agl.`id_lang` = 2

SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 236, 4, 0) +  IF (`id_currency` = 4, 8, 0) +  IF (`id_shop` = 7, 16, 0)) AS `score`
FROM `ps_specific_price`
WHERE (`id_shop` IN (0, 7)) AND (`id_currency` IN (0, 4)) AND (`id_country` IN (0, 236)) AND (`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2026-06-04 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2026-06-04 00:00:00' <= `to`)) AND (IF(`from_quantity` > 1, `from_quantity`, 0) <= 1)
ORDER BY `id_cart` DESC, `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1

SELECT SQL_NO_CACHE COUNT(*)
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 = 7)
WHERE (pa.`id_product` = 588) LIMIT 1

SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` AS `group`
FROM `ps_attribute` a
LEFT JOIN `ps_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 2)
LEFT JOIN `ps_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `ps_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 7)
LEFT JOIN `ps_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 2)
WHERE pa.`id_product` = 588
AND pac.`id_product_attribute` = 8131
AND agl.`id_lang` = 2

SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 236, 4, 0) +  IF (`id_currency` = 4, 8, 0) +  IF (`id_shop` = 7, 16, 0)) AS `score`
FROM `ps_specific_price`
WHERE (`id_shop` IN (0, 7)) AND (`id_currency` IN (0, 4)) AND (`id_country` IN (0, 236)) AND (`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2026-06-04 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2026-06-04 00:00:00' <= `to`)) AND (IF(`from_quantity` > 1, `from_quantity`, 0) <= 1)
ORDER BY `id_cart` DESC, `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1

SELECT SQL_NO_CACHE r.id_review AS `id_review`, r.id_guest AS `id_guest`, r.id_customer AS `id_customer`, r.entity_type AS `entity_type`, r.id_entity AS `id_entity`, r.id_lang AS `id_lang`, r.display_name AS `display_name`, r.email AS `email`, r.title AS `title`, r.content AS `content`, r.reply AS `reply`, r.date_add AS `date_add`, r.date_upd AS `date_upd`, r.validated AS `validated`, r.deleted AS `deleted`, r.verified_buyer AS `verified_buyer`
FROM ps_revws_review r LEFT JOIN ps_product_shop ps ON (r.entity_type = 'product' AND r.id_entity = ps.id_product AND ps.id_shop = 7) LEFT JOIN ps_shop sh ON (r.entity_type = 'store' AND r.id_entity = sh.id_shop)
WHERE (ps.id_shop=7 OR sh.id_shop=7) AND r.entity_type = 'product' AND r.id_entity = 588 AND r.deleted = 0 AND (r.validated = 1 OR r.id_guest = 0)
ORDER BY r.date_add DESC, r.id_review DESC
LIMIT 5 OFFSET 0

SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 236, 4, 0) +  IF (`id_currency` = 4, 8, 0) +  IF (`id_shop` = 7, 16, 0)) AS `score`
FROM `ps_specific_price`
WHERE (`id_shop` IN (0, 7)) AND (`id_currency` IN (0, 4)) AND (`id_country` IN (0, 236)) AND (`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2026-06-04 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2026-06-04 00:00:00' <= `to`)) AND (IF(`from_quantity` > 1, `from_quantity`, 0) <= 1)
ORDER BY `id_cart` DESC, `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1

SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module` AS `mshop`
FROM `ps_module` m
LEFT JOIN `ps_module_shop` `ms` ON ms.`id_module` = m.`id_module` AND ms.`id_shop` = 7

SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` AS `group`
FROM `ps_attribute` a
LEFT JOIN `ps_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 2)
LEFT JOIN `ps_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `ps_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 7)
LEFT JOIN `ps_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 2)
WHERE pa.`id_product` = 588
AND pac.`id_product_attribute` = 8200
AND agl.`id_lang` = 2

SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module` AS `mshop`
FROM `ps_module` m
LEFT JOIN `ps_module_shop` `ms` ON ms.`id_module` = m.`id_module` AND ms.`id_shop` = 7

SELECT SQL_NO_CACHE c.id_category, cl.name, cl.link_rewrite
FROM ps_category c
LEFT JOIN ps_category_lang cl ON (cl.id_category = c.id_category AND cl.id_shop = 7 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 7)
WHERE c.nleft <= 117
AND c.nright >= 118
AND c.nleft >= 2
AND c.nright <= 255
AND cl.id_lang = 2
AND category_shop.active = 1
AND c.level_depth > 1
ORDER BY c.level_depth ASC

SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 236, 4, 0) +  IF (`id_currency` = 4, 8, 0) +  IF (`id_shop` = 7, 16, 0)) AS `score`
FROM `ps_specific_price`
WHERE (`id_shop` IN (0, 7)) AND (`id_currency` IN (0, 4)) AND (`id_country` IN (0, 236)) AND (`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2026-06-04 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2026-06-04 00:00:00' <= `to`)) AND (IF(`from_quantity` > 1, `from_quantity`, 0) <= 1)
ORDER BY `id_cart` DESC, `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1

SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 236, 4, 0) +  IF (`id_currency` = 4, 8, 0) +  IF (`id_shop` = 7, 16, 0)) AS `score`
FROM `ps_specific_price`
WHERE (`id_shop` IN (0, 7)) AND (`id_currency` IN (0, 4)) AND (`id_country` IN (0, 236)) AND (`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2026-06-04 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2026-06-04 00:00:00' <= `to`)) AND (IF(`from_quantity` > 1, `from_quantity`, 0) <= 1)
ORDER BY `id_cart` DESC, `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1

SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 236, 4, 0) +  IF (`id_currency` = 4, 8, 0) +  IF (`id_shop` = 7, 16, 0)) AS `score`
FROM `ps_specific_price`
WHERE (`id_shop` IN (0, 7)) AND (`id_currency` IN (0, 4)) AND (`id_country` IN (0, 236)) AND (`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2026-06-04 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2026-06-04 00:00:00' <= `to`)) AND (IF(`from_quantity` > 1, `from_quantity`, 0) <= 1)
ORDER BY `id_cart` DESC, `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1

SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 236, 4, 0) +  IF (`id_currency` = 4, 8, 0) +  IF (`id_shop` = 7, 16, 0)) AS `score`
FROM `ps_specific_price`
WHERE (`id_shop` IN (0, 7)) AND (`id_currency` IN (0, 4)) AND (`id_country` IN (0, 236)) AND (`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2026-06-04 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2026-06-04 00:00:00' <= `to`)) AND (IF(`from_quantity` > 1, `from_quantity`, 0) <= 1)
ORDER BY `id_cart` DESC, `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1

SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 236, 4, 0) +  IF (`id_currency` = 4, 8, 0) +  IF (`id_shop` = 7, 16, 0)) AS `score`
FROM `ps_specific_price`
WHERE (`id_shop` IN (0, 7)) AND (`id_currency` IN (0, 4)) AND (`id_country` IN (0, 236)) AND (`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2026-06-04 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2026-06-04 00:00:00' <= `to`)) AND (IF(`from_quantity` > 1, `from_quantity`, 0) <= 1)
ORDER BY `id_cart` DESC, `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1

SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 236, 4, 0) +  IF (`id_currency` = 4, 8, 0) +  IF (`id_shop` = 7, 16, 0)) AS `score`
FROM `ps_specific_price`
WHERE (`id_shop` IN (0, 7)) AND (`id_currency` IN (0, 4)) AND (`id_country` IN (0, 236)) AND (`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2026-06-04 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2026-06-04 00:00:00' <= `to`)) AND (IF(`from_quantity` > 1, `from_quantity`, 0) <= 1)
ORDER BY `id_cart` DESC, `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
FROM ps_category c
LEFT JOIN ps_category_lang cl ON (cl.id_category = c.id_category AND cl.id_shop = 7 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 7)
WHERE c.nleft <= 117
AND c.nright >= 118
AND c.nleft >= 2
AND c.nright <= 255
AND cl.id_lang = 2
AND c.active = 1
AND c.level_depth > 1
ORDER BY c.level_depth ASC

SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 236, 4, 0) +  IF (`id_currency` = 4, 8, 0) +  IF (`id_shop` = 7, 16, 0)) AS `score`
FROM `ps_specific_price`
WHERE (`id_shop` IN (0, 7)) AND (`id_currency` IN (0, 4)) AND (`id_country` IN (0, 236)) AND (`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2026-06-04 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2026-06-04 00:00:00' <= `to`)) AND (IF(`from_quantity` > 1, `from_quantity`, 0) <= 1)
ORDER BY `id_cart` DESC, `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1

SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 236, 4, 0) +  IF (`id_currency` = 4, 8, 0) +  IF (`id_shop` = 7, 16, 0)) AS `score`
FROM `ps_specific_price`
WHERE (`id_shop` IN (0, 7)) AND (`id_currency` IN (0, 4)) AND (`id_country` IN (0, 236)) AND (`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2026-06-04 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2026-06-04 00:00:00' <= `to`)) AND (IF(`from_quantity` > 1, `from_quantity`, 0) <= 1)
ORDER BY `id_cart` DESC, `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1

SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 236, 4, 0) +  IF (`id_currency` = 4, 8, 0) +  IF (`id_shop` = 7, 16, 0)) AS `score`
FROM `ps_specific_price`
WHERE (`id_shop` IN (0, 7)) AND (`id_currency` IN (0, 4)) AND (`id_country` IN (0, 236)) AND (`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2026-06-04 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2026-06-04 00:00:00' <= `to`)) AND (IF(`from_quantity` > 1, `from_quantity`, 0) <= 1)
ORDER BY `id_cart` DESC, `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_lang`, pl.`link_rewrite`, p.`ean13`, cl.`link_rewrite` AS category_rewrite
FROM `ps_product` p
LEFT JOIN `ps_product_lang` pl ON (p.`id_product` = pl.`id_product` AND pl.id_shop = 7 )
INNER JOIN ps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 7)
LEFT JOIN `ps_lang` l ON (pl.`id_lang` = l.`id_lang`)
LEFT JOIN `ps_category_lang` cl ON (cl.`id_category` = product_shop.`id_category_default`  AND cl.`id_lang` = pl.`id_lang` AND cl.id_shop = 7 )
WHERE p.`id_product` = 588
AND l.`active` = 1

SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 236, 4, 0) +  IF (`id_currency` = 4, 8, 0) +  IF (`id_shop` = 7, 16, 0)) AS `score`
FROM `ps_specific_price`
WHERE (`id_shop` IN (0, 7)) AND (`id_currency` IN (0, 4)) AND (`id_country` IN (0, 236)) AND (`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2026-06-04 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2026-06-04 00:00:00' <= `to`)) AND (IF(`from_quantity` > 1, `from_quantity`, 0) <= 1)
ORDER BY `id_cart` DESC, `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1

SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 236, 4, 0) +  IF (`id_currency` = 4, 8, 0) +  IF (`id_shop` = 7, 16, 0)) AS `score`
FROM `ps_specific_price`
WHERE (`id_shop` IN (0, 7)) AND (`id_currency` IN (0, 4)) AND (`id_country` IN (0, 236)) AND (`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2026-06-04 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2026-06-04 00:00:00' <= `to`)) AND (IF(`from_quantity` > 1, `from_quantity`, 0) <= 1)
ORDER BY `id_cart` DESC, `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1

SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 236, 4, 0) +  IF (`id_currency` = 4, 8, 0) +  IF (`id_shop` = 7, 16, 0)) AS `score`
FROM `ps_specific_price`
WHERE (`id_shop` IN (0, 7)) AND (`id_currency` IN (0, 4)) AND (`id_country` IN (0, 236)) AND (`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2026-06-04 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2026-06-04 00:00:00' <= `to`)) AND (IF(`from_quantity` > 1, `from_quantity`, 0) <= 1)
ORDER BY `id_cart` DESC, `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_order_state` os
LEFT JOIN `ps_order_state_lang` `osl` ON os.`id_order_state` = osl.`id_order_state`
WHERE (osl.`id_lang` = 2) AND (`deleted` = 0) AND (`active` = 1)
ORDER BY `name` ASC

SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 236, 4, 0) +  IF (`id_currency` = 4, 8, 0) +  IF (`id_shop` = 7, 16, 0)) AS `score`
FROM `ps_specific_price`
WHERE (`id_shop` IN (0, 7)) AND (`id_currency` IN (0, 4)) AND (`id_country` IN (0, 236)) AND (`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2026-06-04 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2026-06-04 00:00:00' <= `to`)) AND (IF(`from_quantity` > 1, `from_quantity`, 0) <= 1)
ORDER BY `id_cart` DESC, `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1

SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 236, 4, 0) +  IF (`id_currency` = 4, 8, 0) +  IF (`id_shop` = 7, 16, 0)) AS `score`
FROM `ps_specific_price`
WHERE (`id_shop` IN (0, 7)) AND (`id_currency` IN (0, 4)) AND (`id_country` IN (0, 236)) AND (`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2026-06-04 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2026-06-04 00:00:00' <= `to`)) AND (IF(`from_quantity` > 1, `from_quantity`, 0) <= 1)
ORDER BY `id_cart` DESC, `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1

SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 236, 4, 0) +  IF (`id_currency` = 4, 8, 0) +  IF (`id_shop` = 7, 16, 0)) AS `score`
FROM `ps_specific_price`
WHERE (`id_shop` IN (0, 7)) AND (`id_currency` IN (0, 4)) AND (`id_country` IN (0, 236)) AND (`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2026-06-04 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2026-06-04 00:00:00' <= `to`)) AND (IF(`from_quantity` > 1, `from_quantity`, 0) <= 1)
ORDER BY `id_cart` DESC, `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`, category_shop.`id_shop`
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 7 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 7)
WHERE `id_lang` = 2
AND c.`id_parent` = 2
AND category_shop.`active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC

SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` AS `group`
FROM `ps_attribute` a
LEFT JOIN `ps_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 2)
LEFT JOIN `ps_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `ps_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 7)
LEFT JOIN `ps_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 2)
WHERE pa.`id_product` = 588
AND pac.`id_product_attribute` = 8128
AND agl.`id_lang` = 2

SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 236, 4, 0) +  IF (`id_currency` = 4, 8, 0) +  IF (`id_shop` = 7, 16, 0)) AS `score`
FROM `ps_specific_price`
WHERE (`id_shop` IN (0, 7)) AND (`id_currency` IN (0, 4)) AND (`id_country` IN (0, 236)) AND (`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2026-06-04 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2026-06-04 00:00:00' <= `to`)) AND (IF(`from_quantity` > 1, `from_quantity`, 0) <= 1)
ORDER BY `id_cart` DESC, `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1

SELECT SQL_NO_CACHE `id_additionalproductstab` FROM `ps_additionalproductstabs` 
WHERE `id_product` = 588 AND `id_shop` = 7 LIMIT 1

SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` AS `group`
FROM `ps_attribute` a
LEFT JOIN `ps_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 2)
LEFT JOIN `ps_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `ps_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 7)
LEFT JOIN `ps_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 2)
WHERE pa.`id_product` = 588
AND pac.`id_product_attribute` = 8191
AND agl.`id_lang` = 2

SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module` AS `mshop`
FROM `ps_module` m
LEFT JOIN `ps_module_shop` `ms` ON ms.`id_module` = m.`id_module` AND ms.`id_shop` = 7

SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` AS `group`
FROM `ps_attribute` a
LEFT JOIN `ps_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 2)
LEFT JOIN `ps_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `ps_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 7)
LEFT JOIN `ps_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 2)
WHERE pa.`id_product` = 588
AND pac.`id_product_attribute` = 8165
AND agl.`id_lang` = 2

SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` AS `group`
FROM `ps_attribute` a
LEFT JOIN `ps_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 2)
LEFT JOIN `ps_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `ps_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 7)
LEFT JOIN `ps_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 2)
WHERE pa.`id_product` = 588
AND pac.`id_product_attribute` = 8129
AND agl.`id_lang` = 2

SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` AS `group`
FROM `ps_attribute` a
LEFT JOIN `ps_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 2)
LEFT JOIN `ps_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `ps_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 7)
LEFT JOIN `ps_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 2)
WHERE pa.`id_product` = 588
AND pac.`id_product_attribute` = 8140
AND agl.`id_lang` = 2

SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 236, 4, 0) +  IF (`id_currency` = 4, 8, 0) +  IF (`id_shop` = 7, 16, 0)) AS `score`
FROM `ps_specific_price`
WHERE (`id_shop` IN (0, 7)) AND (`id_currency` IN (0, 4)) AND (`id_country` IN (0, 236)) AND (`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2026-06-04 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2026-06-04 00:00:00' <= `to`)) AND (IF(`from_quantity` > 1, `from_quantity`, 0) <= 1)
ORDER BY `id_cart` DESC, `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1

SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 236, 4, 0) +  IF (`id_currency` = 4, 8, 0) +  IF (`id_shop` = 7, 16, 0)) AS `score`
FROM `ps_specific_price`
WHERE (`id_shop` IN (0, 7)) AND (`id_currency` IN (0, 4)) AND (`id_country` IN (0, 236)) AND (`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2026-06-04 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2026-06-04 00:00:00' <= `to`)) AND (IF(`from_quantity` > 1, `from_quantity`, 0) <= 1)
ORDER BY `id_cart` DESC, `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1

SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` AS `group`
FROM `ps_attribute` a
LEFT JOIN `ps_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 2)
LEFT JOIN `ps_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `ps_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 7)
LEFT JOIN `ps_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 2)
WHERE pa.`id_product` = 588
AND pac.`id_product_attribute` = 8152
AND agl.`id_lang` = 2

SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` AS `group`
FROM `ps_attribute` a
LEFT JOIN `ps_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 2)
LEFT JOIN `ps_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `ps_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 7)
LEFT JOIN `ps_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 2)
WHERE pa.`id_product` = 588
AND pac.`id_product_attribute` = 8178
AND agl.`id_lang` = 2

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

SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` AS `group`
FROM `ps_attribute` a
LEFT JOIN `ps_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 2)
LEFT JOIN `ps_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `ps_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 7)
LEFT JOIN `ps_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 2)
WHERE pa.`id_product` = 588
AND pac.`id_product_attribute` = 8142
AND agl.`id_lang` = 2

SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 236, 4, 0) +  IF (`id_currency` = 4, 8, 0) +  IF (`id_shop` = 7, 16, 0)) AS `score`
FROM `ps_specific_price`
WHERE (`id_shop` IN (0, 7)) AND (`id_currency` IN (0, 4)) AND (`id_country` IN (0, 236)) AND (`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2026-06-04 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2026-06-04 00:00:00' <= `to`)) AND (IF(`from_quantity` > 1, `from_quantity`, 0) <= 1)
ORDER BY `id_cart` DESC, `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1

SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` AS `group`
FROM `ps_attribute` a
LEFT JOIN `ps_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 2)
LEFT JOIN `ps_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `ps_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 7)
LEFT JOIN `ps_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 2)
WHERE pa.`id_product` = 588
AND pac.`id_product_attribute` = 8176
AND agl.`id_lang` = 2

SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 236, 4, 0) +  IF (`id_currency` = 4, 8, 0) +  IF (`id_shop` = 7, 16, 0)) AS `score`
FROM `ps_specific_price`
WHERE (`id_shop` IN (0, 7)) AND (`id_currency` IN (0, 4)) AND (`id_country` IN (0, 236)) AND (`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2026-06-04 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2026-06-04 00:00:00' <= `to`)) AND (IF(`from_quantity` > 1, `from_quantity`, 0) <= 1)
ORDER BY `id_cart` DESC, `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1

SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` AS `group`
FROM `ps_attribute` a
LEFT JOIN `ps_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 2)
LEFT JOIN `ps_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `ps_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 7)
LEFT JOIN `ps_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 2)
WHERE pa.`id_product` = 588
AND pac.`id_product_attribute` = 8193
AND agl.`id_lang` = 2

SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` AS `group`
FROM `ps_attribute` a
LEFT JOIN `ps_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 2)
LEFT JOIN `ps_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `ps_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 7)
LEFT JOIN `ps_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 2)
WHERE pa.`id_product` = 588
AND pac.`id_product_attribute` = 8143
AND agl.`id_lang` = 2

SELECT SQL_NO_CACHE DISTINCT ag.id_attribute_group
FROM `ps_product_attribute_shop` pas
INNER JOIN `ps_product_attribute_combination` pac ON pac.id_product_attribute = pas.id_product_attribute
INNER JOIN `ps_attribute_shop` a ON a.id_shop = pas.id_shop AND a.id_attribute = pac.id_attribute
INNER JOIN `ps_attribute` at ON a.id_attribute = at.id_attribute
INNER JOIN `ps_attribute_group` ag ON ag.id_attribute_group = at.id_attribute_group
WHERE (pas.id_shop = 7) AND (pas.id_product = 588) AND (pas.id_product_attribute = 8180)
ORDER BY ag.id_attribute_group

SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` AS `group`
FROM `ps_attribute` a
LEFT JOIN `ps_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 2)
LEFT JOIN `ps_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `ps_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 7)
LEFT JOIN `ps_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 2)
WHERE pa.`id_product` = 588
AND pac.`id_product_attribute` = 8164
AND agl.`id_lang` = 2

SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` AS `group`
FROM `ps_attribute` a
LEFT JOIN `ps_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 2)
LEFT JOIN `ps_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `ps_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 7)
LEFT JOIN `ps_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 2)
WHERE pa.`id_product` = 588
AND pac.`id_product_attribute` = 8155
AND agl.`id_lang` = 2

SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` AS `group`
FROM `ps_attribute` a
LEFT JOIN `ps_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 2)
LEFT JOIN `ps_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `ps_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 7)
LEFT JOIN `ps_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 2)
WHERE pa.`id_product` = 588
AND pac.`id_product_attribute` = 8190
AND agl.`id_lang` = 2

SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` AS `group`
FROM `ps_attribute` a
LEFT JOIN `ps_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 2)
LEFT JOIN `ps_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `ps_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 7)
LEFT JOIN `ps_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 2)
WHERE pa.`id_product` = 588
AND pac.`id_product_attribute` = 8130
AND agl.`id_lang` = 2

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

SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` AS `group`
FROM `ps_attribute` a
LEFT JOIN `ps_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 2)
LEFT JOIN `ps_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `ps_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 7)
LEFT JOIN `ps_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 2)
WHERE pa.`id_product` = 588
AND pac.`id_product_attribute` = 8202
AND agl.`id_lang` = 2

SELECT SQL_NO_CACHE DISTINCT fv.id_feature_value
FROM `ps_feature_product` fp
INNER JOIN `ps_feature_shop` f ON f.id_feature = fp.id_feature AND f.id_shop = 7
INNER JOIN `ps_feature_value` fv ON fv.id_feature_value = fp.id_feature_value and fv.id_feature = f.id_feature
WHERE (fp.id_product = 588)
ORDER BY fv.id_feature_value, fv.position

SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 236, 4, 0) +  IF (`id_currency` = 4, 8, 0) +  IF (`id_shop` = 7, 16, 0)) AS `score`
FROM `ps_specific_price`
WHERE (`id_shop` IN (0, 7)) AND (`id_currency` IN (0, 4)) AND (`id_country` IN (0, 236)) AND (`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2026-06-04 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2026-06-04 00:00:00' <= `to`)) AND (IF(`from_quantity` > 1, `from_quantity`, 0) <= 1)
ORDER BY `id_cart` DESC, `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1

SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 236, 4, 0) +  IF (`id_currency` = 4, 8, 0) +  IF (`id_shop` = 7, 16, 0)) AS `score`
FROM `ps_specific_price`
WHERE (`id_shop` IN (0, 7)) AND (`id_currency` IN (0, 4)) AND (`id_country` IN (0, 236)) AND (`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2026-06-04 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2026-06-04 00:00:00' <= `to`)) AND (IF(`from_quantity` > 1, `from_quantity`, 0) <= 1)
ORDER BY `id_cart` DESC, `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1

SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` AS `group`
FROM `ps_attribute` a
LEFT JOIN `ps_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 2)
LEFT JOIN `ps_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `ps_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 7)
LEFT JOIN `ps_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 2)
WHERE pa.`id_product` = 588
AND pac.`id_product_attribute` = 8189
AND agl.`id_lang` = 2

SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` AS `group`
FROM `ps_attribute` a
LEFT JOIN `ps_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 2)
LEFT JOIN `ps_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `ps_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 7)
LEFT JOIN `ps_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 2)
WHERE pa.`id_product` = 588
AND pac.`id_product_attribute` = 8166
AND agl.`id_lang` = 2

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` = 4
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 7
WHERE (a.`id_product` = 588) AND (b.`id_shop` = 7) LIMIT 1

SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` AS `group`
FROM `ps_attribute` a
LEFT JOIN `ps_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 2)
LEFT JOIN `ps_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `ps_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 7)
LEFT JOIN `ps_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 2)
WHERE pa.`id_product` = 588
AND pac.`id_product_attribute` = 8153
AND agl.`id_lang` = 2

SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` AS `group`
FROM `ps_attribute` a
LEFT JOIN `ps_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 2)
LEFT JOIN `ps_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `ps_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 7)
LEFT JOIN `ps_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 2)
WHERE pa.`id_product` = 588
AND pac.`id_product_attribute` = 8167
AND agl.`id_lang` = 2

SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 236, 4, 0) +  IF (`id_currency` = 4, 8, 0) +  IF (`id_shop` = 7, 16, 0)) AS `score`
FROM `ps_specific_price`
WHERE (`id_shop` IN (0, 7)) AND (`id_currency` IN (0, 4)) AND (`id_country` IN (0, 236)) AND (`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2026-06-04 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2026-06-04 00:00:00' <= `to`)) AND (IF(`from_quantity` > 1, `from_quantity`, 0) <= 1)
ORDER BY `id_cart` DESC, `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1

SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` AS `group`
FROM `ps_attribute` a
LEFT JOIN `ps_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 2)
LEFT JOIN `ps_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `ps_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 7)
LEFT JOIN `ps_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 2)
WHERE pa.`id_product` = 588
AND pac.`id_product_attribute` = 8201
AND agl.`id_lang` = 2

SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 236, 4, 0) +  IF (`id_currency` = 4, 8, 0) +  IF (`id_shop` = 7, 16, 0)) AS `score`
FROM `ps_specific_price`
WHERE (`id_shop` IN (0, 7)) AND (`id_currency` IN (0, 4)) AND (`id_country` IN (0, 236)) AND (`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2026-06-04 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2026-06-04 00:00:00' <= `to`)) AND (IF(`from_quantity` > 1, `from_quantity`, 0) <= 1)
ORDER BY `id_cart` DESC, `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 ag.id_attribute_group
FROM `ps_product_attribute_shop` pas
INNER JOIN `ps_product_attribute_combination` pac ON pac.id_product_attribute = pas.id_product_attribute
INNER JOIN `ps_attribute_shop` a ON a.id_shop = pas.id_shop AND a.id_attribute = pac.id_attribute
INNER JOIN `ps_attribute` at ON a.id_attribute = at.id_attribute
INNER JOIN `ps_attribute_group` ag ON ag.id_attribute_group = at.id_attribute_group
WHERE (pas.id_shop = 7) AND (pas.id_product = 588) AND (pas.id_product_attribute = 8191)
ORDER BY ag.id_attribute_group

SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` AS `group`
FROM `ps_attribute` a
LEFT JOIN `ps_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 2)
LEFT JOIN `ps_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `ps_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 7)
LEFT JOIN `ps_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 2)
WHERE pa.`id_product` = 588
AND pac.`id_product_attribute` = 8154
AND agl.`id_lang` = 2

SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 236, 4, 0) +  IF (`id_currency` = 4, 8, 0) +  IF (`id_shop` = 7, 16, 0)) AS `score`
FROM `ps_specific_price`
WHERE (`id_shop` IN (0, 7)) AND (`id_currency` IN (0, 4)) AND (`id_country` IN (0, 236)) AND (`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2026-06-04 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2026-06-04 00:00:00' <= `to`)) AND (IF(`from_quantity` > 1, `from_quantity`, 0) <= 1)
ORDER BY `id_cart` DESC, `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 fv.id_feature_value
FROM `ps_feature_product` fp
INNER JOIN `ps_feature_shop` f ON f.id_feature = fp.id_feature AND f.id_shop = 7
INNER JOIN `ps_feature_value` fv ON fv.id_feature_value = fp.id_feature_value and fv.id_feature = f.id_feature
WHERE (fp.id_product = 588)
ORDER BY fv.id_feature_value, fv.position

SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` AS `group`
FROM `ps_attribute` a
LEFT JOIN `ps_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 2)
LEFT JOIN `ps_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `ps_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 7)
LEFT JOIN `ps_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 2)
WHERE pa.`id_product` = 588
AND pac.`id_product_attribute` = 8188
AND agl.`id_lang` = 2

SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 236, 4, 0) +  IF (`id_currency` = 4, 8, 0) +  IF (`id_shop` = 7, 16, 0)) AS `score`
FROM `ps_specific_price`
WHERE (`id_shop` IN (0, 7)) AND (`id_currency` IN (0, 4)) AND (`id_country` IN (0, 236)) AND (`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2026-06-04 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2026-06-04 00:00:00' <= `to`)) AND (IF(`from_quantity` > 1, `from_quantity`, 0) <= 1)
ORDER BY `id_cart` DESC, `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1

SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 236, 4, 0) +  IF (`id_currency` = 4, 8, 0) +  IF (`id_shop` = 7, 16, 0)) AS `score`
FROM `ps_specific_price`
WHERE (`id_shop` IN (0, 7)) AND (`id_currency` IN (0, 4)) AND (`id_country` IN (0, 236)) AND (`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2026-06-04 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2026-06-04 00:00:00' <= `to`)) AND (IF(`from_quantity` > 1, `from_quantity`, 0) <= 1)
ORDER BY `id_cart` DESC, `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1

SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` AS `group`
FROM `ps_attribute` a
LEFT JOIN `ps_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 2)
LEFT JOIN `ps_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `ps_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 7)
LEFT JOIN `ps_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 2)
WHERE pa.`id_product` = 588
AND pac.`id_product_attribute` = 8177
AND agl.`id_lang` = 2

SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 236, 4, 0) +  IF (`id_currency` = 4, 8, 0) +  IF (`id_shop` = 7, 16, 0)) AS `score`
FROM `ps_specific_price`
WHERE (`id_shop` IN (0, 7)) AND (`id_currency` IN (0, 4)) AND (`id_country` IN (0, 236)) AND (`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2026-06-04 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2026-06-04 00:00:00' <= `to`)) AND (IF(`from_quantity` > 1, `from_quantity`, 0) <= 1)
ORDER BY `id_cart` DESC, `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1

SELECT SQL_NO_CACHE tr.*
FROM `ps_tax_rule` tr
JOIN `ps_tax_rules_group` trg ON (tr.`id_tax_rules_group` = trg.`id_tax_rules_group`)
WHERE trg.`active` = 1
AND tr.`id_country` = 236
AND tr.`id_tax_rules_group` = 6
AND tr.`id_state` IN (0, 0)
AND ('0' BETWEEN tr.`zipcode_from` AND tr.`zipcode_to`
OR (tr.`zipcode_to` = 0 AND tr.`zipcode_from` IN(0, '0')))
ORDER BY tr.`zipcode_from` DESC, tr.`zipcode_to` DESC, tr.`id_state` DESC, tr.`id_country` DESC

SELECT SQL_NO_CACHE COUNT(1) AS `cnt`
FROM ps_revws_review r LEFT JOIN ps_product_shop ps ON (r.entity_type = 'product' AND r.id_entity = ps.id_product AND ps.id_shop = 7) LEFT JOIN ps_shop sh ON (r.entity_type = 'store' AND r.id_entity = sh.id_shop)
WHERE (ps.id_shop=7 OR sh.id_shop=7) AND r.entity_type = 'product' AND r.id_entity = 588 AND r.deleted = 0 AND (r.validated = 1 OR r.id_guest = 0) LIMIT 1

SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 236, 4, 0) +  IF (`id_currency` = 4, 8, 0) +  IF (`id_shop` = 7, 16, 0)) AS `score`
FROM `ps_specific_price`
WHERE (`id_shop` IN (0, 7)) AND (`id_currency` IN (0, 4)) AND (`id_country` IN (0, 236)) AND (`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2026-06-04 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2026-06-04 00:00:00' <= `to`)) AND (IF(`from_quantity` > 1, `from_quantity`, 0) <= 1)
ORDER BY `id_cart` DESC, `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 ag.id_attribute_group
FROM `ps_product_attribute_shop` pas
INNER JOIN `ps_product_attribute_combination` pac ON pac.id_product_attribute = pas.id_product_attribute
INNER JOIN `ps_attribute_shop` a ON a.id_shop = pas.id_shop AND a.id_attribute = pac.id_attribute
INNER JOIN `ps_attribute` at ON a.id_attribute = at.id_attribute
INNER JOIN `ps_attribute_group` ag ON ag.id_attribute_group = at.id_attribute_group
WHERE (pas.id_shop = 7) AND (pas.id_product = 588) AND (pas.id_product_attribute = 8152)
ORDER BY ag.id_attribute_group

SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 236, 4, 0) +  IF (`id_currency` = 4, 8, 0) +  IF (`id_shop` = 7, 16, 0)) AS `score`
FROM `ps_specific_price`
WHERE (`id_shop` IN (0, 7)) AND (`id_currency` IN (0, 4)) AND (`id_country` IN (0, 236)) AND (`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2026-06-04 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2026-06-04 00:00:00' <= `to`)) AND (IF(`from_quantity` > 1, `from_quantity`, 0) <= 1)
ORDER BY `id_cart` DESC, `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1

UPDATE `ps_smarty_lazy_cache`
SET filepath='additionalproductstabs/tabcontent/588/1/7/2/4/236/71/47/62/714762813b3481bc15c270a6a7cdc93894a135b9.additionaltab.tpl.php'
WHERE `template_hash`='253f84de967499d5074b7276aae75237' AND cache_id="additionalproductstabs|tabcontent|588|1|7|2|4|236" AND compile_id=""

SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 236, 4, 0) +  IF (`id_currency` = 4, 8, 0) +  IF (`id_shop` = 7, 16, 0)) AS `score`
FROM `ps_specific_price`
WHERE (`id_shop` IN (0, 7)) AND (`id_currency` IN (0, 4)) AND (`id_country` IN (0, 236)) AND (`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2026-06-04 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2026-06-04 00:00:00' <= `to`)) AND (IF(`from_quantity` > 1, `from_quantity`, 0) <= 1)
ORDER BY `id_cart` DESC, `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 ag.id_attribute_group
FROM `ps_product_attribute_shop` pas
INNER JOIN `ps_product_attribute_combination` pac ON pac.id_product_attribute = pas.id_product_attribute
INNER JOIN `ps_attribute_shop` a ON a.id_shop = pas.id_shop AND a.id_attribute = pac.id_attribute
INNER JOIN `ps_attribute` at ON a.id_attribute = at.id_attribute
INNER JOIN `ps_attribute_group` ag ON ag.id_attribute_group = at.id_attribute_group
WHERE (pas.id_shop = 7) AND (pas.id_product = 588) AND (pas.id_product_attribute = 8193)
ORDER BY ag.id_attribute_group

SELECT SQL_NO_CACHE DISTINCT ag.id_attribute_group
FROM `ps_product_attribute_shop` pas
INNER JOIN `ps_product_attribute_combination` pac ON pac.id_product_attribute = pas.id_product_attribute
INNER JOIN `ps_attribute_shop` a ON a.id_shop = pas.id_shop AND a.id_attribute = pac.id_attribute
INNER JOIN `ps_attribute` at ON a.id_attribute = at.id_attribute
INNER JOIN `ps_attribute_group` ag ON ag.id_attribute_group = at.id_attribute_group
WHERE (pas.id_shop = 7) AND (pas.id_product = 588) AND (pas.id_product_attribute = 8153)
ORDER BY ag.id_attribute_group

SELECT SQL_NO_CACHE DISTINCT ag.id_attribute_group
FROM `ps_product_attribute_shop` pas
INNER JOIN `ps_product_attribute_combination` pac ON pac.id_product_attribute = pas.id_product_attribute
INNER JOIN `ps_attribute_shop` a ON a.id_shop = pas.id_shop AND a.id_attribute = pac.id_attribute
INNER JOIN `ps_attribute` at ON a.id_attribute = at.id_attribute
INNER JOIN `ps_attribute_group` ag ON ag.id_attribute_group = at.id_attribute_group
WHERE (pas.id_shop = 7) AND (pas.id_product = 588) AND (pas.id_product_attribute = 8155)
ORDER BY ag.id_attribute_group

SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module` AS `mshop`
FROM `ps_module` m
LEFT JOIN `ps_module_shop` `ms` ON ms.`id_module` = m.`id_module` AND ms.`id_shop` = 7

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

SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 236, 4, 0) +  IF (`id_currency` = 4, 8, 0) +  IF (`id_shop` = 7, 16, 0)) AS `score`
FROM `ps_specific_price`
WHERE (`id_shop` IN (0, 7)) AND (`id_currency` IN (0, 4)) AND (`id_country` IN (0, 236)) AND (`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2026-06-04 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2026-06-04 00:00:00' <= `to`)) AND (IF(`from_quantity` > 1, `from_quantity`, 0) <= 1)
ORDER BY `id_cart` DESC, `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1

SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 236, 4, 0) +  IF (`id_currency` = 4, 8, 0) +  IF (`id_shop` = 7, 16, 0)) AS `score`
FROM `ps_specific_price`
WHERE (`id_shop` IN (0, 7)) AND (`id_currency` IN (0, 4)) AND (`id_country` IN (0, 236)) AND (`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2026-06-04 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2026-06-04 00:00:00' <= `to`)) AND (IF(`from_quantity` > 1, `from_quantity`, 0) <= 1)
ORDER BY `id_cart` DESC, `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.description, cl.meta_title
FROM ps_category c
INNER JOIN ps_category_lang cl ON c.id_category = cl.id_category
WHERE c.id_category IN (107,108,109,110,111,112,113,114,115,116)
AND cl.id_lang = 2
AND cl.id_shop = 7
ORDER BY c.id_category ASC

SELECT SQL_NO_CACHE *
FROM `ps_bp_bulletpoint` a0
LEFT JOIN `ps_bp_bulletpoint_lang` `a1` ON (a0.`id_bp_bulletpoint` = a1.`id_bp_bulletpoint`)
WHERE (a0.`entity_type` = 'CATEGORY') AND (a0.`entity_id` IN(89))
ORDER BY a0.`position` asc, a0.`id_bp_bulletpoint` asc

INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('77a1ee4a6b2875848522f5aee33e8f75',"gmgapser|588|2|7","", FROM_UNIXTIME(1780535109))

SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 236, 4, 0) +  IF (`id_currency` = 4, 8, 0) +  IF (`id_shop` = 7, 16, 0)) AS `score`
FROM `ps_specific_price`
WHERE (`id_shop` IN (0, 7)) AND (`id_currency` IN (0, 4)) AND (`id_country` IN (0, 236)) AND (`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2026-06-04 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2026-06-04 00:00:00' <= `to`)) AND (IF(`from_quantity` > 1, `from_quantity`, 0) <= 1)
ORDER BY `id_cart` DESC, `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1

UPDATE `ps_smarty_lazy_cache`
SET filepath='gmgapser/588/2/7/e8/71/5c/e8715cc80853c99b5f18ab8189f119fa3f7d80eb.gmgapser.tpl.php'
WHERE `template_hash`='77a1ee4a6b2875848522f5aee33e8f75' AND cache_id="gmgapser|588|2|7" AND compile_id=""

SELECT SQL_NO_CACHE DISTINCT ag.id_attribute_group
FROM `ps_product_attribute_shop` pas
INNER JOIN `ps_product_attribute_combination` pac ON pac.id_product_attribute = pas.id_product_attribute
INNER JOIN `ps_attribute_shop` a ON a.id_shop = pas.id_shop AND a.id_attribute = pac.id_attribute
INNER JOIN `ps_attribute` at ON a.id_attribute = at.id_attribute
INNER JOIN `ps_attribute_group` ag ON ag.id_attribute_group = at.id_attribute_group
WHERE (pas.id_shop = 7) AND (pas.id_product = 588) AND (pas.id_product_attribute = 8200)
ORDER BY ag.id_attribute_group

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

SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module` AS `mshop`
FROM `ps_module` m
LEFT JOIN `ps_module_shop` `ms` ON ms.`id_module` = m.`id_module` AND ms.`id_shop` = 7

SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` AS `group`
FROM `ps_attribute` a
LEFT JOIN `ps_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 2)
LEFT JOIN `ps_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `ps_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 7)
LEFT JOIN `ps_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 2)
WHERE pa.`id_product` = 588
AND pac.`id_product_attribute` = 8141
AND agl.`id_lang` = 2

SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 236, 4, 0) +  IF (`id_currency` = 4, 8, 0) +  IF (`id_shop` = 7, 16, 0)) AS `score`
FROM `ps_specific_price`
WHERE (`id_shop` IN (0, 7)) AND (`id_currency` IN (0, 4)) AND (`id_country` IN (0, 236)) AND (`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2026-06-04 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2026-06-04 00:00:00' <= `to`)) AND (IF(`from_quantity` > 1, `from_quantity`, 0) <= 1)
ORDER BY `id_cart` DESC, `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 ag.id_attribute_group
FROM `ps_product_attribute_shop` pas
INNER JOIN `ps_product_attribute_combination` pac ON pac.id_product_attribute = pas.id_product_attribute
INNER JOIN `ps_attribute_shop` a ON a.id_shop = pas.id_shop AND a.id_attribute = pac.id_attribute
INNER JOIN `ps_attribute` at ON a.id_attribute = at.id_attribute
INNER JOIN `ps_attribute_group` ag ON ag.id_attribute_group = at.id_attribute_group
WHERE (pas.id_shop = 7) AND (pas.id_product = 588) AND (pas.id_product_attribute = 8128)
ORDER BY ag.id_attribute_group

SELECT SQL_NO_CACHE DISTINCT ag.id_attribute_group
FROM `ps_product_attribute_shop` pas
INNER JOIN `ps_product_attribute_combination` pac ON pac.id_product_attribute = pas.id_product_attribute
INNER JOIN `ps_attribute_shop` a ON a.id_shop = pas.id_shop AND a.id_attribute = pac.id_attribute
INNER JOIN `ps_attribute` at ON a.id_attribute = at.id_attribute
INNER JOIN `ps_attribute_group` ag ON ag.id_attribute_group = at.id_attribute_group
WHERE (pas.id_shop = 7) AND (pas.id_product = 588) AND (pas.id_product_attribute = 8162)
ORDER BY ag.id_attribute_group

SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 236, 4, 0) +  IF (`id_currency` = 4, 8, 0) +  IF (`id_shop` = 7, 16, 0)) AS `score`
FROM `ps_specific_price`
WHERE (`id_shop` IN (0, 7)) AND (`id_currency` IN (0, 4)) AND (`id_country` IN (0, 236)) AND (`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2026-06-04 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2026-06-04 00:00:00' <= `to`)) AND (IF(`from_quantity` > 1, `from_quantity`, 0) <= 1)
ORDER BY `id_cart` DESC, `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 ag.id_attribute_group
FROM `ps_product_attribute_shop` pas
INNER JOIN `ps_product_attribute_combination` pac ON pac.id_product_attribute = pas.id_product_attribute
INNER JOIN `ps_attribute_shop` a ON a.id_shop = pas.id_shop AND a.id_attribute = pac.id_attribute
INNER JOIN `ps_attribute` at ON a.id_attribute = at.id_attribute
INNER JOIN `ps_attribute_group` ag ON ag.id_attribute_group = at.id_attribute_group
WHERE (pas.id_shop = 7) AND (pas.id_product = 588) AND (pas.id_product_attribute = 8198)
ORDER BY ag.id_attribute_group

SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 236, 4, 0) +  IF (`id_currency` = 4, 8, 0) +  IF (`id_shop` = 7, 16, 0)) AS `score`
FROM `ps_specific_price`
WHERE (`id_shop` IN (0, 7)) AND (`id_currency` IN (0, 4)) AND (`id_country` IN (0, 236)) AND (`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2026-06-04 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2026-06-04 00:00:00' <= `to`)) AND (IF(`from_quantity` > 1, `from_quantity`, 0) <= 1)
ORDER BY `id_cart` DESC, `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1

SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` AS `group`
FROM `ps_attribute` a
LEFT JOIN `ps_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 2)
LEFT JOIN `ps_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `ps_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 7)
LEFT JOIN `ps_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 2)
WHERE pa.`id_product` = 588
AND pac.`id_product_attribute` = 8174
AND agl.`id_lang` = 2

SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` AS `group`
FROM `ps_attribute` a
LEFT JOIN `ps_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 2)
LEFT JOIN `ps_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `ps_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 7)
LEFT JOIN `ps_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 2)
WHERE pa.`id_product` = 588
AND pac.`id_product_attribute` = 8138
AND agl.`id_lang` = 2

SELECT SQL_NO_CACHE DISTINCT ag.id_attribute_group
FROM `ps_product_attribute_shop` pas
INNER JOIN `ps_product_attribute_combination` pac ON pac.id_product_attribute = pas.id_product_attribute
INNER JOIN `ps_attribute_shop` a ON a.id_shop = pas.id_shop AND a.id_attribute = pac.id_attribute
INNER JOIN `ps_attribute` at ON a.id_attribute = at.id_attribute
INNER JOIN `ps_attribute_group` ag ON ag.id_attribute_group = at.id_attribute_group
WHERE (pas.id_shop = 7) AND (pas.id_product = 588) AND (pas.id_product_attribute = 8141)
ORDER BY ag.id_attribute_group

SELECT SQL_NO_CACHE DISTINCT ag.id_attribute_group
FROM `ps_product_attribute_shop` pas
INNER JOIN `ps_product_attribute_combination` pac ON pac.id_product_attribute = pas.id_product_attribute
INNER JOIN `ps_attribute_shop` a ON a.id_shop = pas.id_shop AND a.id_attribute = pac.id_attribute
INNER JOIN `ps_attribute` at ON a.id_attribute = at.id_attribute
INNER JOIN `ps_attribute_group` ag ON ag.id_attribute_group = at.id_attribute_group
WHERE (pas.id_shop = 7) AND (pas.id_product = 588) AND (pas.id_product_attribute = 8151)
ORDER BY ag.id_attribute_group

SELECT SQL_NO_CACHE DISTINCT ag.id_attribute_group
FROM `ps_product_attribute_shop` pas
INNER JOIN `ps_product_attribute_combination` pac ON pac.id_product_attribute = pas.id_product_attribute
INNER JOIN `ps_attribute_shop` a ON a.id_shop = pas.id_shop AND a.id_attribute = pac.id_attribute
INNER JOIN `ps_attribute` at ON a.id_attribute = at.id_attribute
INNER JOIN `ps_attribute_group` ag ON ag.id_attribute_group = at.id_attribute_group
WHERE (pas.id_shop = 7) AND (pas.id_product = 588) AND (pas.id_product_attribute = 8190)
ORDER BY ag.id_attribute_group

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

SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 236, 4, 0) +  IF (`id_currency` = 4, 8, 0) +  IF (`id_shop` = 7, 16, 0)) AS `score`
FROM `ps_specific_price`
WHERE (`id_shop` IN (0, 7)) AND (`id_currency` IN (0, 4)) AND (`id_country` IN (0, 236)) AND (`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2026-06-04 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2026-06-04 00:00:00' <= `to`)) AND (IF(`from_quantity` > 1, `from_quantity`, 0) <= 1)
ORDER BY `id_cart` DESC, `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1

SELECT SQL_NO_CACHE `id_additionalproductstab` FROM `ps_additionalproductstabs` 
WHERE `id_product` = 588 AND `id_shop` = 7 LIMIT 1

SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 236, 4, 0) +  IF (`id_currency` = 4, 8, 0) +  IF (`id_shop` = 7, 16, 0)) AS `score`
FROM `ps_specific_price`
WHERE (`id_shop` IN (0, 7)) AND (`id_currency` IN (0, 4)) AND (`id_country` IN (0, 236)) AND (`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2026-06-04 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2026-06-04 00:00:00' <= `to`)) AND (IF(`from_quantity` > 1, `from_quantity`, 0) <= 1)
ORDER BY `id_cart` DESC, `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1

SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` AS `group`
FROM `ps_attribute` a
LEFT JOIN `ps_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 2)
LEFT JOIN `ps_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `ps_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 7)
LEFT JOIN `ps_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 2)
WHERE pa.`id_product` = 588
AND pac.`id_product_attribute` = 8168
AND agl.`id_lang` = 2

SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` AS `group`
FROM `ps_attribute` a
LEFT JOIN `ps_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 2)
LEFT JOIN `ps_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `ps_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 7)
LEFT JOIN `ps_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 2)
WHERE pa.`id_product` = 588
AND pac.`id_product_attribute` = 8157
AND agl.`id_lang` = 2

SELECT SQL_NO_CACHE DISTINCT ag.id_attribute_group
FROM `ps_product_attribute_shop` pas
INNER JOIN `ps_product_attribute_combination` pac ON pac.id_product_attribute = pas.id_product_attribute
INNER JOIN `ps_attribute_shop` a ON a.id_shop = pas.id_shop AND a.id_attribute = pac.id_attribute
INNER JOIN `ps_attribute` at ON a.id_attribute = at.id_attribute
INNER JOIN `ps_attribute_group` ag ON ag.id_attribute_group = at.id_attribute_group
WHERE (pas.id_shop = 7) AND (pas.id_product = 588) AND (pas.id_product_attribute = 8192)
ORDER BY ag.id_attribute_group

SELECT SQL_NO_CACHE *
FROM `ps_bp_bulletpoint` a0
LEFT JOIN `ps_bp_bulletpoint_lang` `a1` ON (a0.`id_bp_bulletpoint` = a1.`id_bp_bulletpoint`)
WHERE (a0.`entity_type` = 'FEATURE_VALUE') AND (a0.`entity_id` IN(28, 29, 31, 32, 34, 39, 40))
ORDER BY a0.`position` asc, a0.`id_bp_bulletpoint` asc

SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` AS `group`
FROM `ps_attribute` a
LEFT JOIN `ps_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 2)
LEFT JOIN `ps_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `ps_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 7)
LEFT JOIN `ps_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 2)
WHERE pa.`id_product` = 588
AND pac.`id_product_attribute` = 8162
AND agl.`id_lang` = 2

SELECT SQL_NO_CACHE DISTINCT ag.id_attribute_group
FROM `ps_product_attribute_shop` pas
INNER JOIN `ps_product_attribute_combination` pac ON pac.id_product_attribute = pas.id_product_attribute
INNER JOIN `ps_attribute_shop` a ON a.id_shop = pas.id_shop AND a.id_attribute = pac.id_attribute
INNER JOIN `ps_attribute` at ON a.id_attribute = at.id_attribute
INNER JOIN `ps_attribute_group` ag ON ag.id_attribute_group = at.id_attribute_group
WHERE (pas.id_shop = 7) AND (pas.id_product = 588) AND (pas.id_product_attribute = 8188)
ORDER BY ag.id_attribute_group

SELECT SQL_NO_CACHE DISTINCT ag.id_attribute_group
FROM `ps_product_attribute_shop` pas
INNER JOIN `ps_product_attribute_combination` pac ON pac.id_product_attribute = pas.id_product_attribute
INNER JOIN `ps_attribute_shop` a ON a.id_shop = pas.id_shop AND a.id_attribute = pac.id_attribute
INNER JOIN `ps_attribute` at ON a.id_attribute = at.id_attribute
INNER JOIN `ps_attribute_group` ag ON ag.id_attribute_group = at.id_attribute_group
WHERE (pas.id_shop = 7) AND (pas.id_product = 588) AND (pas.id_product_attribute = 8159)
ORDER BY ag.id_attribute_group

SELECT SQL_NO_CACHE DISTINCT fv.id_feature_value
FROM `ps_feature_product` fp
INNER JOIN `ps_feature_shop` f ON f.id_feature = fp.id_feature AND f.id_shop = 7
INNER JOIN `ps_feature_value` fv ON fv.id_feature_value = fp.id_feature_value and fv.id_feature = f.id_feature
WHERE (fp.id_product = 588)
ORDER BY fv.id_feature_value, fv.position

SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` AS `group`
FROM `ps_attribute` a
LEFT JOIN `ps_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 2)
LEFT JOIN `ps_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `ps_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 7)
LEFT JOIN `ps_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 2)
WHERE pa.`id_product` = 588
AND pac.`id_product_attribute` = 8150
AND agl.`id_lang` = 2

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

SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 236, 4, 0) +  IF (`id_currency` = 4, 8, 0) +  IF (`id_shop` = 7, 16, 0)) AS `score`
FROM `ps_specific_price`
WHERE (`id_shop` IN (0, 7)) AND (`id_currency` IN (0, 4)) AND (`id_country` IN (0, 236)) AND (`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2026-06-04 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2026-06-04 00:00:00' <= `to`)) AND (IF(`from_quantity` > 1, `from_quantity`, 0) <= 1)
ORDER BY `id_cart` DESC, `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1

UPDATE `ps_smarty_lazy_cache`
SET filepath='manufacturertab/tabcontent/7/1/7/2/4/236/89/3d/c8/893dc8364b9ad2e85a216d26ea10c193f5c15022.manufacturertab.tpl.php'
WHERE `template_hash`='a99f92a3a7ad435ca3d0eac3fca7ae66' AND cache_id="manufacturertab|tabcontent|7|1|7|2|4|236" AND compile_id=""

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

SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` AS `group`
FROM `ps_attribute` a
LEFT JOIN `ps_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 2)
LEFT JOIN `ps_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `ps_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 7)
LEFT JOIN `ps_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 2)
WHERE pa.`id_product` = 588
AND pac.`id_product_attribute` = 8146
AND agl.`id_lang` = 2

SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` AS `group`
FROM `ps_attribute` a
LEFT JOIN `ps_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 2)
LEFT JOIN `ps_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `ps_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 7)
LEFT JOIN `ps_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 2)
WHERE pa.`id_product` = 588
AND pac.`id_product_attribute` = 8210
AND agl.`id_lang` = 2

SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` AS `group`
FROM `ps_attribute` a
LEFT JOIN `ps_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 2)
LEFT JOIN `ps_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `ps_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 7)
LEFT JOIN `ps_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 2)
WHERE pa.`id_product` = 588
AND pac.`id_product_attribute` = 8204
AND agl.`id_lang` = 2

SELECT SQL_NO_CACHE (SUM(ra.grade) / COUNT(1)) AS grade, COUNT(distinct r.id_review) as cnt
FROM ps_revws_review r
LEFT JOIN ps_revws_review_grade ra ON (r.id_review = ra.id_review)
WHERE r.entity_type = 'product' AND r.id_entity = 588 AND r.deleted = 0 AND r.validated = 1 LIMIT 1

SELECT SQL_NO_CACHE DISTINCT fv.id_feature_value
FROM `ps_feature_product` fp
INNER JOIN `ps_feature_shop` f ON f.id_feature = fp.id_feature AND f.id_shop = 7
INNER JOIN `ps_feature_value` fv ON fv.id_feature_value = fp.id_feature_value and fv.id_feature = f.id_feature
WHERE (fp.id_product = 588)
ORDER BY fv.id_feature_value, fv.position

SELECT SQL_NO_CACHE DISTINCT fv.id_feature_value
FROM `ps_feature_product` fp
INNER JOIN `ps_feature_shop` f ON f.id_feature = fp.id_feature AND f.id_shop = 7
INNER JOIN `ps_feature_value` fv ON fv.id_feature_value = fp.id_feature_value and fv.id_feature = f.id_feature
WHERE (fp.id_product = 588)
ORDER BY fv.id_feature_value, fv.position

SELECT SQL_NO_CACHE DISTINCT fv.id_feature_value
FROM `ps_feature_product` fp
INNER JOIN `ps_feature_shop` f ON f.id_feature = fp.id_feature AND f.id_shop = 7
INNER JOIN `ps_feature_value` fv ON fv.id_feature_value = fp.id_feature_value and fv.id_feature = f.id_feature
WHERE (fp.id_product = 588)
ORDER BY fv.id_feature_value, fv.position

SELECT SQL_NO_CACHE DISTINCT g.`id_group`, g.`reduction`, g.`price_display_method`, gl.`name`
FROM `ps_group` g
LEFT JOIN `ps_group_lang` `gl` ON g.`id_group` = gl.`id_group` AND gl.`id_lang` = 2
ORDER BY g.`id_group` ASC

SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` AS `group`
FROM `ps_attribute` a
LEFT JOIN `ps_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 2)
LEFT JOIN `ps_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `ps_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 7)
LEFT JOIN `ps_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 2)
WHERE pa.`id_product` = 588
AND pac.`id_product_attribute` = 8147
AND agl.`id_lang` = 2

SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 236, 4, 0) +  IF (`id_currency` = 4, 8, 0) +  IF (`id_shop` = 7, 16, 0)) AS `score`
FROM `ps_specific_price`
WHERE (`id_shop` IN (0, 7)) AND (`id_currency` IN (0, 4)) AND (`id_country` IN (0, 236)) AND (`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2026-06-04 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2026-06-04 00:00:00' <= `to`)) AND (IF(`from_quantity` > 1, `from_quantity`, 0) <= 1)
ORDER BY `id_cart` DESC, `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1

SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` AS `group`
FROM `ps_attribute` a
LEFT JOIN `ps_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 2)
LEFT JOIN `ps_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `ps_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 7)
LEFT JOIN `ps_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 2)
WHERE pa.`id_product` = 588
AND pac.`id_product_attribute` = 8133
AND agl.`id_lang` = 2

SELECT SQL_NO_CACHE DISTINCT ag.id_attribute_group
FROM `ps_product_attribute_shop` pas
INNER JOIN `ps_product_attribute_combination` pac ON pac.id_product_attribute = pas.id_product_attribute
INNER JOIN `ps_attribute_shop` a ON a.id_shop = pas.id_shop AND a.id_attribute = pac.id_attribute
INNER JOIN `ps_attribute` at ON a.id_attribute = at.id_attribute
INNER JOIN `ps_attribute_group` ag ON ag.id_attribute_group = at.id_attribute_group
WHERE (pas.id_shop = 7) AND (pas.id_product = 588) AND (pas.id_product_attribute = 8136)
ORDER BY ag.id_attribute_group

SELECT SQL_NO_CACHE DISTINCT fv.id_feature_value
FROM `ps_feature_product` fp
INNER JOIN `ps_feature_shop` f ON f.id_feature = fp.id_feature AND f.id_shop = 7
INNER JOIN `ps_feature_value` fv ON fv.id_feature_value = fp.id_feature_value and fv.id_feature = f.id_feature
WHERE (fp.id_product = 588)
ORDER BY fv.id_feature_value, fv.position