Mikasa EBEAT-BL електронна съдийска свирка

SELECT SQL_NO_CACHE `id_product`
FROM `ps_product_lang`
WHERE (`link_rewrite` = 'mikasa-ebeat-електронна-съдийска-свирка') AND (`id_lang` = 2) AND (`id_shop` = 6)

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 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 = 6 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` = 6)
GROUP BY hm.id_hook, hm.id_module
ORDER BY hm.`position`

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.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 = 6)
STRAIGHT_JOIN `ps_module` AS m ON (m.id_module = hm.id_module)
ORDER BY hm.position

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 = 6)
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 `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 `id_category`
FROM `ps_category_lang`
WHERE (`link_rewrite` = 'mikasa-ebeat-електронна-съдийска-свирка') AND (`id_lang` = 2) AND (`id_shop` = 6)

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 = 6)
WHERE (s.`active` = 1)
GROUP BY s.id_supplier
ORDER BY  s.`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` = 240) AND (s.`active` = 1)
GROUP BY s.`id_question`, l.`id_lang`
ORDER BY position ASC, s.`id_question` 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 = 6)
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 = 6)
WHERE pa.`id_product` = 240
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 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` = 240) AND (s.`active` = 1)
GROUP BY s.`id_question`, l.`id_lang`
ORDER BY position ASC, s.`id_question` ASC

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 = 6)
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=6)
LEFT JOIN `ps_product_lang` pl ON (
p.`id_product` = pl.`id_product`
AND pl.`id_lang` = 2 AND pl.id_shop = 6 
)
LEFT JOIN `ps_category_lang` cl ON (
product_shop.`id_category_default` = cl.`id_category`
AND cl.`id_lang` = 2 AND cl.id_shop = 6 
)
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=6)
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` = 240 AND product_shop.`active` = 1 AND product_shop.`visibility` != 'none'
GROUP BY product_shop.id_product

SELECT SQL_NO_CACHE DISTINCT p.id_product, pl.name, pl.link_rewrite, p.reference, i.id_image, product_shop.show_price,
cl.link_rewrite category, p.ean13, stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity,
DATEDIFF(product_shop.`date_add`, DATE_SUB(NOW(),
INTERVAL 30
DAY)) > 0 AS new
FROM ps_product p
INNER JOIN ps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 6)LEFT JOIN `ps_product_attribute` pa
ON (p.`id_product` = pa.`id_product`)
LEFT 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 = 6 AND product_attribute_shop.`default_on` = 1)
LEFT JOIN ps_stock_available stock
ON (stock.id_product = p.id_product AND stock.id_product_attribute = IFNULL(`product_attribute_shop`.id_product_attribute, 0) AND stock.id_shop_group = 1  AND stock.id_shop = 0  )
LEFT JOIN ps_product_lang pl ON (pl.id_product = p.id_product AND pl.id_shop = 6 )
LEFT JOIN ps_category_lang cl ON (cl.id_category = product_shop.id_category_default AND cl.id_shop = 6 )
LEFT JOIN ps_image i ON (i.id_product = p.id_product)
WHERE p.id_product IN (331,157,334,332,284,286)
AND pl.id_lang = 2
AND cl.id_lang = 2
AND i.cover = 1
AND product_shop.active = 1
ORDER BY FIELD(p.id_product, 331,157,334,332,284,286)

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 = 6 
ORDER BY LENGTH(ml.`url_rewrite`) DESC

SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 6)
LEFT JOIN `ps_category_lang` cl ON c.`id_category` = cl.`id_category` AND cl.id_shop = 6 
RIGHT JOIN `ps_category` c2 ON c2.`id_category` = 98 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 2
AND category_shop.`active` = 1
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC

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 = 6)
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 c.*, cl.*
FROM `ps_category` c
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 6)
LEFT JOIN `ps_category_lang` cl ON c.`id_category` = cl.`id_category` AND cl.id_shop = 6 
RIGHT JOIN `ps_category` c2 ON c2.`id_category` = 57 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 2
AND category_shop.`active` = 1
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC

SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 6)
LEFT JOIN `ps_category_lang` cl ON c.`id_category` = cl.`id_category` AND cl.id_shop = 6 
RIGHT JOIN `ps_category` c2 ON c2.`id_category` = 35 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 2
AND category_shop.`active` = 1
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC

SELECT SQL_NO_CACHE c.*, cl.id_lang, cl.name, cl.description, cl.link_rewrite, cl.meta_title, cl.meta_keywords, cl.meta_description
FROM `ps_category` c
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 6)
LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND `id_lang` = 2  AND cl.id_shop = 6 )
WHERE `id_parent` = 57
AND category_shop.`active` = 1
GROUP BY c.`id_category`
ORDER BY `level_depth` ASC, category_shop.`position` 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 c.*, cl.*
FROM `ps_category` c
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 6)
LEFT JOIN `ps_category_lang` cl ON c.`id_category` = cl.`id_category` AND cl.id_shop = 6 
RIGHT JOIN `ps_category` c2 ON c2.`id_category` = 152 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 2
AND category_shop.`active` = 1
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC

SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 6)
LEFT JOIN `ps_category_lang` cl ON c.`id_category` = cl.`id_category` AND cl.id_shop = 6 
RIGHT JOIN `ps_category` c2 ON c2.`id_category` = 99 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 2
AND category_shop.`active` = 1
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC

SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 6)
LEFT JOIN `ps_category_lang` cl ON c.`id_category` = cl.`id_category` AND cl.id_shop = 6 
RIGHT JOIN `ps_category` c2 ON c2.`id_category` = 97 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 2
AND category_shop.`active` = 1
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC

SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 6)
LEFT JOIN `ps_category_lang` cl ON c.`id_category` = cl.`id_category` AND cl.id_shop = 6 
RIGHT JOIN `ps_category` c2 ON c2.`id_category` = 63 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 2
AND category_shop.`active` = 1
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC

SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 6)
LEFT JOIN `ps_category_lang` cl ON c.`id_category` = cl.`id_category` AND cl.id_shop = 6 
RIGHT JOIN `ps_category` c2 ON c2.`id_category` = 122 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 2
AND category_shop.`active` = 1
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC

SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 6)
LEFT JOIN `ps_category_lang` cl ON c.`id_category` = cl.`id_category` AND cl.id_shop = 6 
RIGHT JOIN `ps_category` c2 ON c2.`id_category` = 58 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 2
AND category_shop.`active` = 1
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC

SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 6)
LEFT JOIN `ps_category_lang` cl ON c.`id_category` = cl.`id_category` AND cl.id_shop = 6 
RIGHT JOIN `ps_category` c2 ON c2.`id_category` = 70 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 2
AND category_shop.`active` = 1
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC

SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 6)
LEFT JOIN `ps_category_lang` cl ON c.`id_category` = cl.`id_category` AND cl.id_shop = 6 
RIGHT JOIN `ps_category` c2 ON c2.`id_category` = 59 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 2
AND category_shop.`active` = 1
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC

SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 6)
LEFT JOIN `ps_category_lang` cl ON c.`id_category` = cl.`id_category` AND cl.id_shop = 6 
RIGHT JOIN `ps_category` c2 ON c2.`id_category` = 61 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 2
AND category_shop.`active` = 1
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC

SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 6)
LEFT JOIN `ps_category_lang` cl ON c.`id_category` = cl.`id_category` AND cl.id_shop = 6 
RIGHT JOIN `ps_category` c2 ON c2.`id_category` = 60 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 2
AND category_shop.`active` = 1
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC

SELECT SQL_NO_CACHE pa.*, product_attribute_shop.*, ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, al.`name` AS attribute_name,
a.`id_attribute`
FROM `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 6)
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` AND al.`id_lang` = 2)
LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 2)
WHERE pa.`id_product` = 157
GROUP BY pa.`id_product_attribute`,ag.`id_attribute_group`
ORDER BY ag.`position` ASC, a.`position` ASC, a.`id_attribute` ASC, pa.`id_product_attribute` ASC

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 = 6) AND (m.active) AND (ms.enable_device > 0) AND (h.name = "actionDetectMobile")
ORDER BY hm.position

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 = 144)
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 = 6)
WHERE pf.id_product = 144
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 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` = 6

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

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` = 6

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 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` = 6

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` = 6

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 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` = 6

SELECT SQL_NO_CACHE hs.`id_tab` as id_tab, hssl.`title`, hssl.`label`, hssl.`url`,
hss.`position`,  hss.`active_label`, hss.`url_type`, hss.`id_url`, hss.`icon_type`, hss.`icon_class`, hss.`icon`, hss.`legend_icon`,
hss.`new_window`, hss.`float`, hss.`submenu_type`, hss.`submenu_content`, hss.`submenu_width`, hss.`group_access`
FROM ps_iqitmegamenu_tabs_shop hs
LEFT JOIN ps_iqitmegamenu_tabs hss ON (hs.id_tab = hss.id_tab)
LEFT JOIN ps_iqitmegamenu_tabs_lang hssl ON (hss.id_tab = hssl.id_tab)
WHERE id_shop = 6 AND menu_type = 1 AND active = 1
AND hssl.id_lang = 2
ORDER BY hss.position

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` = 6

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` = 6

SELECT SQL_NO_CACHE hs.`id_textbanners_banners` as id_banner,
hss.`position`,
hss.`active`,
hss.`icon`,
hss.`icon_bg`,
hss.`icon_c`,
hss.`title_c`,
hss.`label_c`,
hssl.`title`,
hssl.`url`,
hssl.`legend`
FROM ps_textbanners hs
LEFT JOIN ps_textbanners_banners hss ON (hs.id_textbanners_banners = hss.id_textbanners_banners)
LEFT JOIN ps_textbanners_banners_lang hssl ON (hss.id_textbanners_banners = hssl.id_textbanners_banners)
WHERE (id_shop = 6)
AND hssl.id_lang = 2 AND hss.`active` = 1
ORDER BY hss.position

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 = 157)
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 = 6)
WHERE pf.id_product = 157
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 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 = 240)
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 = 6)
WHERE pf.id_product = 240
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 value FROM `ps_configuration` WHERE `name` = "PS_MULTISHOP_FEATURE_ACTIVE" LIMIT 1

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

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

SELECT SQL_NO_CACHE `id_additionalproductstab` FROM `ps_additionalproductstabs` 
WHERE `id_product` = 240 AND `id_shop` = 6 LIMIT 1

UPDATE `ps_smarty_lazy_cache`
SET filepath='iqitproducttags/1/6/2/4/236/240/28/ed/24/28ed24a1683fd969d4c5a58dbe507c98ac18f293.iqitproducttags.tpl.php'
WHERE `template_hash`='e88995d3a09b58b68501807fdcd2c65f' AND cache_id="iqitproducttags|1|6|2|4|236|240" AND compile_id=""

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 = 6 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 6)
WHERE c.nleft <= 189
AND c.nright >= 190
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

UPDATE `ps_smarty_lazy_cache`
SET filepath='iqitmegamenu/1/6/2/4/236/10/79/2d/1a/792d1aa8e225a0e8be3145d0c8b1c1488871c38a.iqitmegamenu.tpl.php'
WHERE `template_hash`='f18d156c167c6a70b22b8c495bd47f42' AND cache_id="iqitmegamenu|1|6|2|4|236|10" AND compile_id=""

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.sudiiskimagazin.com' OR su.domain_ssl = 'www.sudiiskimagazin.com') AND (s.`active` = 1) AND (s.`deleted` = 0)
ORDER BY LENGTH(CONCAT(su.`physical_uri`, su.`virtual_uri`)) DESC

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

SELECT SQL_NO_CACHE *
FROM `ps_cms` a
LEFT JOIN `ps_cms_lang` `b` ON a.`id_cms` = b.`id_cms` AND b.`id_lang` = 2
LEFT JOIN `ps_cms_shop` `c` ON a.`id_cms` = c.`id_cms` AND c.`id_shop` = 6
WHERE (a.`id_cms` = 1) AND (b.`id_shop` = 6) LIMIT 1

UPDATE `ps_smarty_lazy_cache`
SET filepath='productpaymentlogos/1/6/2/4/236/28/41/2a/28412ac80a7655d77234acb4d039e51501475b51.productpaymentlogos.tpl.php'
WHERE `template_hash`='13dcc4ddb8b38e5124b180c9f7fb844e' AND cache_id="productpaymentlogos|1|6|2|4|236" AND compile_id=""

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` = 6
WHERE (a.`id_product` = 240) AND (b.`id_shop` = 6) LIMIT 1

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

UPDATE `ps_smarty_lazy_cache`
SET filepath='manufacturertab/tab/2/1/6/2/4/236/e8/0c/3f/e80c3f44a0eaf79dc5da2e13edcf13bb2d345fd3.tab.tpl.php'
WHERE `template_hash`='908ed5e67d9daa24232d4df4af4ed347' AND cache_id="manufacturertab|tab|2|1|6|2|4|236" AND compile_id=""

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

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

SELECT SQL_NO_CACHE `id_additionalproductstab` FROM `ps_additionalproductstabs` 
WHERE `id_product` = 240 AND `id_shop` = 6 LIMIT 1

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

SELECT SQL_NO_CACHE 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=240 AND ps.id_shop=6
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=240 AND ps.id_shop=6

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 = 6 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 6)
WHERE c.nleft <= 189
AND c.nright >= 190
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 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 = 6)
WHERE (pa.`id_product` = 240) 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` = 6, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE (`id_shop` IN (0, 6)) 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 *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 236, 4, 0) +  IF (`id_currency` = 4, 8, 0) +  IF (`id_shop` = 6, 16, 0)) AS `score`
FROM `ps_specific_price`
WHERE (`id_shop` IN (0, 6)) 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='footercontent/1/6/2/4/236/87/ee/80/87ee80a6c9f370dc32683324c6675aa2947b15c1.footercontent.tpl.php'
WHERE `template_hash`='78743f6508929c073a39213009df034a' AND cache_id="footercontent|1|6|2|4|236" AND compile_id=""

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 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 = 6)
INNER JOIN ps_attribute_shop attribute_shop
ON (attribute_shop.id_attribute = pac.id_attribute AND attribute_shop.id_shop = 6)
WHERE pa.`id_product` = 240

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 = 6 )
INNER JOIN ps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 6)
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 = 6 )
WHERE p.`id_product` = 240
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` = 6, 16, 0)) AS `score`
FROM `ps_specific_price`
WHERE (`id_shop` IN (0, 6)) 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='product_buttons/240/1/6/2/4/236/e7/5a/45/e75a458812803e16c16cb25076d26b1e32da66cd.product-view.tpl.php'
WHERE `template_hash`='5dcad2aeff6bd8a0c3865614fb76836f' AND cache_id="product_buttons|240|1|6|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` = 6, 16, 0)) AS `score`
FROM `ps_specific_price`
WHERE (`id_shop` IN (0, 6)) 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_product` a
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 6
WHERE (a.`id_product` = 240) 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 = 6) LEFT JOIN ps_shop sh ON (r.entity_type = 'store' AND r.id_entity = sh.id_shop)
WHERE (ps.id_shop=6 OR sh.id_shop=6) AND r.entity_type = 'product' AND r.id_entity = 240 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 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 = 6)
LEFT JOIN `ps_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 2)
WHERE i.`id_product` = 240
ORDER BY `position`

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

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

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

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 = 240 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 = 6
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 = 240)
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` = 6, 16, 0)) AS `score`
FROM `ps_specific_price`
WHERE (`id_shop` IN (0, 6)) 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` = 6, 16, 0)) AS `score`
FROM `ps_specific_price`
WHERE (`id_shop` IN (0, 6)) 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(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` = 6) AND (l.`active` = 1) LIMIT 1

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

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

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 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 `id_product` FROM `ps_gm_omniprice_cache`  WHERE `id_product` = 240 AND `id_product_attribute` > 0 LIMIT 1

INSERT INTO ps_collectlogs_stats(id_collectlogs_logs, dimension, `count`)
VALUES(3642, '2026-06-04', 1)
ON DUPLICATE KEY UPDATE `count` = `count` + 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` = 6, 16, 0)) AS `score`
FROM `ps_specific_price`
WHERE (`id_shop` IN (0, 6)) 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/tab/240/1/6/2/4/236/d3/41/b5/d341b58bbdfaa2f24f77a11664c85ede107024fe.tab.tpl.php'
WHERE `template_hash`='430d6ddf4320df9eefbb9c46c3e4b0b5' AND cache_id="additionalproductstabs|tab|240|1|6|2|4|236" AND compile_id=""

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` = 6
WHERE (a.`id_product` = 331) AND (b.`id_shop` = 6) 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 = 6 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 6)
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 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 = 6
ORDER BY c.id_category ASC

INSERT INTO ps_collectlogs_stats(id_collectlogs_logs, dimension, `count`)
VALUES(3642, '2026-06-04', 1)
ON DUPLICATE KEY UPDATE `count` = `count` + 1

SELECT SQL_NO_CACHE *
FROM `ps_cms` a
LEFT JOIN `ps_cms_lang` `b` ON a.`id_cms` = b.`id_cms` AND b.`id_lang` = 2
LEFT JOIN `ps_cms_shop` `c` ON a.`id_cms` = c.`id_cms` AND c.`id_shop` = 6
WHERE (a.`id_cms` = 2) AND (b.`id_shop` = 6) LIMIT 1

UPDATE `ps_smarty_lazy_cache`
SET filepath='iqitsizeguide/combination/157/1/6/2/4/236/58/dd/84/58dd84fba6af302a262d9f23a0bc64144b29ee71.combinations.tpl.php'
WHERE `template_hash`='c864b28850d2ee57e31ec9fc9bfd77db' AND cache_id="iqitsizeguide|combination|157|1|6|2|4|236" AND compile_id=""

SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) AS last_update,
filepath
FROM `ps_smarty_lazy_cache`
WHERE (template_hash="e88995d3a09b58b68501807fdcd2c65f") AND (cache_id="iqitproducttags|1|6|2|4|236|240") AND (compile_id="") LIMIT 1

INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('e88995d3a09b58b68501807fdcd2c65f',"iqitproducttags|1|6|2|4|236|240","", FROM_UNIXTIME(1780535129))

SELECT SQL_NO_CACHE * FROM `ps_hook_alias`

SELECT SQL_NO_CACHE *
FROM `ps_cms` a
LEFT JOIN `ps_cms_lang` `b` ON a.`id_cms` = b.`id_cms` AND b.`id_lang` = 2
LEFT JOIN `ps_cms_shop` `c` ON a.`id_cms` = c.`id_cms` AND c.`id_shop` = 6
WHERE (a.`id_cms` = 7) AND (b.`id_shop` = 6) LIMIT 1

UPDATE `ps_smarty_lazy_cache`
SET filepath='textbanners/1/6/2/4/236/9b/5b/07/9b5b07329f30796986924687576cd06d352da797.textbanners.tpl.php'
WHERE `template_hash`='5dea1e2707880d6c46ec53fbd3681fdc' AND cache_id="textbanners|1|6|2|4|236" AND compile_id=""

UPDATE `ps_smarty_lazy_cache`
SET filepath='blockmyaccountfooter/1/6/2/4/236/11/97/b3/1197b35992397ccfdf5d05143d49737445462a67.blockmyaccountfooter.tpl.php'
WHERE `template_hash`='c4e1ccf7226c68087dc2fcbccdf6c9de' AND cache_id="blockmyaccountfooter|1|6|2|4|236" AND compile_id=""

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` = 6
WHERE (a.`id_product` = 144) AND (b.`id_shop` = 6) LIMIT 1

INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('253f84de967499d5074b7276aae75237',"additionalproductstabs|tabcontent|240|1|6|2|4|236","", FROM_UNIXTIME(1780535129))

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

SELECT SQL_NO_CACHE *
FROM `ps_cms` a
LEFT JOIN `ps_cms_lang` `b` ON a.`id_cms` = b.`id_cms` AND b.`id_lang` = 2
LEFT JOIN `ps_cms_shop` `c` ON a.`id_cms` = c.`id_cms` AND c.`id_shop` = 6
WHERE (a.`id_cms` = 3) AND (b.`id_shop` = 6) LIMIT 1

SELECT SQL_NO_CACHE id_image FROM ps_image WHERE id_product = 144 AND (cover = 0 or cover IS NULL) ORDER BY `position` LIMIT 1

UPDATE `ps_smarty_lazy_cache`
SET filepath='blockcontactinfos/1/6/2/4/236/9a/1a/26/9a1a26ad9c781d67169bb224330670ec3241a0ba.blockcontactinfos.tpl.php'
WHERE `template_hash`='da8d2affcdbcdfc4d58be7bc6e585c57' AND cache_id="blockcontactinfos|1|6|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` = 6, 16, 0)) AS `score`
FROM `ps_specific_price`
WHERE (`id_shop` IN (0, 6)) 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_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(9, 10, 14, 71))
ORDER BY a0.`position` asc, a0.`id_bp_bulletpoint` asc

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 = 157 AND r.deleted = 0 AND r.validated = 1 LIMIT 1

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

UPDATE `ps_smarty_lazy_cache`
SET filepath='revws/1/6/2/4/236/144/7b/b2/ba/7bb2ba388c08b6f3f9d74c35539ce67ba9b08aef.product_list.tpl.php'
WHERE `template_hash`='ab4a99c5ae8ae5095840570e33c5c084' AND cache_id="revws|1|6|2|4|236|144" AND compile_id=""

INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('78743f6508929c073a39213009df034a',"footercontent|1|6|2|4|236","", FROM_UNIXTIME(1780535129))

INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('77a1ee4a6b2875848522f5aee33e8f75',"gmgapser|240|2|6","", FROM_UNIXTIME(1780535129))

INSERT INTO ps_collectlogs_stats(id_collectlogs_logs, dimension, `count`)
VALUES(3642, '2026-06-04', 1)
ON DUPLICATE KEY UPDATE `count` = `count` + 1

INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('c4e1ccf7226c68087dc2fcbccdf6c9de',"blockmyaccountfooter|1|6|2|4|236","", FROM_UNIXTIME(1780535129))

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

INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('13dcc4ddb8b38e5124b180c9f7fb844e',"productpaymentlogos|1|6|2|4|236","", FROM_UNIXTIME(1780535129))

SELECT SQL_NO_CACHE 1
FROM `ps_product_shop`
WHERE (id_product = 240) AND (id_shop = 6) LIMIT 1

INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('908ed5e67d9daa24232d4df4af4ed347',"manufacturertab|tab|2|1|6|2|4|236","", FROM_UNIXTIME(1780535129))

INSERT INTO ps_collectlogs_stats(id_collectlogs_logs, dimension, `count`)
VALUES(3642, '2026-06-04', 1)
ON DUPLICATE KEY UPDATE `count` = `count` + 1

SELECT SQL_NO_CACHE cp.id_product as id_product
FROM `ps_category_product` as cp
LEFT JOIN `ps_product` as p
ON p.id_product = cp.id_product
LEFT JOIN `ps_product_shop` as ps
ON p.id_product = ps.id_product
WHERE cp.id_category = 57
AND p.active = 1
AND ps.id_shop = 6
AND cp.position < 6 ORDER BY cp.position DESC LIMIT 1

SELECT SQL_NO_CACHE *
FROM `ps_cms` a
LEFT JOIN `ps_cms_lang` `b` ON a.`id_cms` = b.`id_cms` AND b.`id_lang` = 2
LEFT JOIN `ps_cms_shop` `c` ON a.`id_cms` = c.`id_cms` AND c.`id_shop` = 6
WHERE (a.`id_cms` = 5) AND (b.`id_shop` = 6) LIMIT 1

INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('5dea1e2707880d6c46ec53fbd3681fdc',"textbanners|1|6|2|4|236","", FROM_UNIXTIME(1780535129))

SELECT SQL_NO_CACHE cl.`meta_title`, cl.`link_rewrite`
FROM `ps_cms_lang` cl
INNER JOIN `ps_cms` c
ON (cl.`id_cms` = c.`id_cms`)
WHERE cl.`id_cms` = 2
AND (c.`active` = 1 OR c.`id_cms` = 1) AND cl.`id_shop` = 6
AND cl.`id_lang` = 2 LIMIT 1

INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('ab4a99c5ae8ae5095840570e33c5c084',"revws|1|6|2|4|236|144","", FROM_UNIXTIME(1780535129))

INSERT INTO ps_collectlogs_stats(id_collectlogs_logs, dimension, `count`)
VALUES(3642, '2026-06-04', 1)
ON DUPLICATE KEY UPDATE `count` = `count` + 1

SELECT SQL_NO_CACHE id_meta
FROM `ps_meta`
WHERE (page = 'module-faqsnippets-faqs') LIMIT 1

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` = 'PRODUCT') AND (a0.`entity_id` IN(240))
ORDER BY a0.`position` asc, a0.`id_bp_bulletpoint` asc

SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) AS last_update,
filepath
FROM `ps_smarty_lazy_cache`
WHERE (template_hash="13dcc4ddb8b38e5124b180c9f7fb844e") AND (cache_id="productpaymentlogos|1|6|2|4|236") AND (compile_id="") LIMIT 1

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 = 144 AND r.deleted = 0 AND r.validated = 1 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` = 6, 16, 0)) AS `score`
FROM `ps_specific_price`
WHERE (`id_shop` IN (0, 6)) 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 `domain`, `domain_ssl`
FROM `ps_shop_url`
WHERE (`main` = 1) AND (`id_shop` = 6) LIMIT 1

SELECT SQL_NO_CACHE l.id_iqitmenulinks, l.new_window, s.name, ll.link, ll.label
FROM ps_iqitmenulinks l
LEFT JOIN ps_iqitmenulinks_lang ll
ON (l.id_iqitmenulinks = ll.id_iqitmenulinks
AND ll.id_lang = 2
AND ll.id_shop = 6)
LEFT JOIN ps_shop s
ON l.id_shop = s.id_shop
WHERE 1
AND l.id_iqitmenulinks = "19"
AND l.id_shop IN (0, 6)

UPDATE `ps_smarty_lazy_cache`
SET filepath='revws/1/6/2/4/236/157/7b/b2/ba/7bb2ba388c08b6f3f9d74c35539ce67ba9b08aef.product_list.tpl.php'
WHERE `template_hash`='ab4a99c5ae8ae5095840570e33c5c084' AND cache_id="revws|1|6|2|4|236|157" AND compile_id=""

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` = 6) AND (c.`deleted` = 0) AND (c.`active` = 1) LIMIT 1

SELECT SQL_NO_CACHE cl.`meta_title`, cl.`link_rewrite`
FROM `ps_cms_lang` cl
INNER JOIN `ps_cms` c
ON (cl.`id_cms` = c.`id_cms`)
WHERE cl.`id_cms` = 3
AND (c.`active` = 1 OR c.`id_cms` = 1) AND cl.`id_shop` = 6
AND cl.`id_lang` = 2 LIMIT 1

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

SELECT SQL_NO_CACHE IFNULL(`left_column`, `default_left_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