List of products by supplier: ACTION S.A.

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`,
image_shop.`id_image` id_image,
il.`legend`,
s.`name` AS supplier_name,
DATEDIFF(p.`date_add`, DATE_SUB("2025-11-11 00:00:00", INTERVAL 20 DAY)) > 0 AS new,
m.`name` AS manufacturer_name, product_attribute_shop.minimal_quantity AS product_attribute_minimal_quantity, IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute
FROM `ps_product` p
INNER JOIN ps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
JOIN `ps_product_supplier` ps ON (ps.id_product = p.id_product
AND ps.id_product_attribute = 0) LEFT JOIN `ps_product_attribute_shop` product_attribute_shop
ON (p.`id_product` = product_attribute_shop.`id_product` AND product_attribute_shop.`default_on` = 1 AND product_attribute_shop.id_shop=1)
LEFT JOIN `ps_product_lang` pl ON (p.`id_product` = pl.`id_product`
AND pl.`id_lang` = 2 AND pl.id_shop = 1 )
LEFT JOIN `ps_image_shop` image_shop
ON (image_shop.`id_product` = p.`id_product` AND image_shop.cover=1 AND image_shop.id_shop=1)
LEFT JOIN `ps_image_lang` il ON (image_shop.`id_image` = il.`id_image`
AND il.`id_lang` = 2)
LEFT JOIN `ps_supplier` s ON s.`id_supplier` = p.`id_supplier`
LEFT JOIN `ps_manufacturer` m ON m.`id_manufacturer` = p.`id_manufacturer`
LEFT JOIN ps_stock_available stock
ON (stock.id_product = p.id_product AND stock.id_product_attribute = 0 AND stock.id_shop = 1  AND stock.id_shop_group = 0  )JOIN `ps_category_product` cp ON (p.id_product = cp.id_product)JOIN `ps_category_group` cg ON (cp.`id_category` = cg.`id_category` AND cg.`id_group` = 1)JOIN `ps_category` ca ON cp.`id_category` = ca.`id_category` AND ca.`active` = 1
WHERE ps.`id_supplier` = 1
AND product_shop.`active` = 1
AND product_shop.`visibility` IN ("both", "catalog")
GROUP BY ps.id_product
ORDER BY name asc
LIMIT 45132,12

SELECT SQL_NO_CACHE COUNT(DISTINCT ps.`id_product`)
FROM `ps_product_supplier` ps
INNER JOIN `ps_product` p ON ps.`id_product` = p.`id_product`
INNER JOIN ps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
WHERE (ps.`id_supplier` = 1) AND (ps.`id_product_attribute` = 0) AND (product_shop.`active` = 1) AND (product_shop.`visibility` IN ("both", "catalog")) AND (p.`id_product` IN (SELECT cp.`id_product`
FROM `ps_category_product` cp
LEFT JOIN `ps_category_group` `cg` ON cp.`id_category` = cg.`id_category`
INNER JOIN `ps_category` ca ON cp.`id_category` = ca.`id_category` AND ca.`active` = 1
WHERE (cg.`id_group` = 1)
)) LIMIT 1

SELECT SQL_NO_CACHE COUNT(DISTINCT ps.`id_product`)
FROM `ps_product_supplier` ps
INNER JOIN `ps_product` p ON ps.`id_product` = p.`id_product`
INNER JOIN ps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
WHERE (ps.`id_supplier` = 1) AND (ps.`id_product_attribute` = 0) AND (product_shop.`active` = 1) AND (product_shop.`visibility` IN ("both", "catalog")) AND (p.`id_product` IN (SELECT cp.`id_product`
FROM `ps_category_product` cp
LEFT JOIN `ps_category_group` `cg` ON cp.`id_category` = cg.`id_category`
INNER JOIN `ps_category` ca ON cp.`id_category` = ca.`id_category` AND ca.`active` = 1
WHERE (cg.`id_group` = 1)
)) LIMIT 1

SELECT SQL_NO_CACHE h.`name` as hook, m.`id_module`, h.`id_hook`, m.`name` as module, h.`live_edit`
FROM `ps_module` m
INNER JOIN ps_module_shop module_shop
ON (module_shop.id_module = m.id_module AND module_shop.id_shop = 1 AND module_shop.enable_device & 1)
INNER JOIN `ps_module_shop` ms ON ms.`id_module` = m.`id_module`
INNER JOIN `ps_hook_module` hm ON hm.`id_module` = m.`id_module`
INNER JOIN `ps_hook` h ON hm.`id_hook` = h.`id_hook`
LEFT JOIN `ps_module_group` `mg` ON mg.`id_module` = m.`id_module`
WHERE (h.`name` != "displayPayment" AND h.`name` != "displayPaymentEU") AND (hm.`id_shop` = 1) AND (mg.`id_shop` = 1 AND  mg.`id_group` IN (1))
GROUP BY hm.id_hook, hm.id_module
ORDER BY hm.`position`

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

SELECT SQL_NO_CACHE cl.*, c.*, cl.`name` AS `country`, z.`name` AS `zone`
FROM `ps_country` c
INNER JOIN ps_country_shop country_shop
ON (country_shop.id_country = c.id_country AND country_shop.id_shop = 1)
LEFT JOIN `ps_country_lang` `cl` ON c.`id_country` = cl.`id_country` AND cl.`id_lang` = 2
LEFT JOIN `ps_zone` `z` ON z.`id_zone` = c.`id_zone`
ORDER BY cl.`name` ASC

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

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

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

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

SELECT SQL_NO_CACHE *
FROM `ps_state`
ORDER BY `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 hs.`id_htmlbanners7_slides` as id_slide, hss.`position`, hss.`active`, hssl.`title`,
hssl.`url`, hssl.`legend`, hssl.`customclass`, hssl.`description`, hssl.`image`
FROM ps_htmlbanners7 hs
LEFT JOIN ps_htmlbanners7_slides hss ON (hs.id_htmlbanners7_slides = hss.id_htmlbanners7_slides)
LEFT JOIN ps_htmlbanners7_slides_lang hssl ON (hss.id_htmlbanners7_slides = hssl.id_htmlbanners7_slides)
WHERE id_shop = 1
AND hssl.id_lang = 2 AND hss.`active` = 1
ORDER BY hss.position

SELECT SQL_NO_CACHE hs.`id_htmlbanners10_slides` as id_slide, hss.`position`, hss.`active`, hssl.`title`,
hssl.`url`, hssl.`legend`, hssl.`customclass`, hssl.`description`, hssl.`image`
FROM ps_htmlbanners10 hs
LEFT JOIN ps_htmlbanners10_slides hss ON (hs.id_htmlbanners10_slides = hss.id_htmlbanners10_slides)
LEFT JOIN ps_htmlbanners10_slides_lang hssl ON (hss.id_htmlbanners10_slides = hssl.id_htmlbanners10_slides)
WHERE id_shop = 1
AND hssl.id_lang = 2 AND hss.`active` = 1
ORDER BY hss.position

SELECT SQL_NO_CACHE hs.`id_htmlbanners5_slides` as id_slide, hss.`position`, hss.`active`, hssl.`title`,
hssl.`url`, hssl.`legend`, hssl.`customclass`, hssl.`description`, hssl.`image`
FROM ps_htmlbanners5 hs
LEFT JOIN ps_htmlbanners5_slides hss ON (hs.id_htmlbanners5_slides = hss.id_htmlbanners5_slides)
LEFT JOIN ps_htmlbanners5_slides_lang hssl ON (hss.id_htmlbanners5_slides = hssl.id_htmlbanners5_slides)
WHERE id_shop = 1
AND hssl.id_lang = 2 AND hss.`active` = 1
ORDER BY hss.position

SELECT SQL_NO_CACHE hs.`id_htmlbanners8_slides` as id_slide, hss.`position`, hss.`active`, hssl.`title`,
hssl.`url`, hssl.`legend`, hssl.`customclass`, hssl.`category`, hssl.`description`, hssl.`image`
FROM ps_htmlbanners8 hs
LEFT JOIN ps_htmlbanners8_slides hss ON (hs.id_htmlbanners8_slides = hss.id_htmlbanners8_slides)
LEFT JOIN ps_htmlbanners8_slides_lang hssl ON (hss.id_htmlbanners8_slides = hssl.id_htmlbanners8_slides)
WHERE id_shop = 1
AND hssl.id_lang = 2 AND hss.`active` = 1
ORDER BY hss.position

SELECT SQL_NO_CACHE hs.`id_htmlbanners11_slides` as id_slide, hss.`position`, hss.`active`, hssl.`title`,
hssl.`url`, hssl.`legend`, hssl.`customclass`, hssl.`category`, hssl.`description`, hssl.`image`
FROM ps_htmlbanners11 hs
LEFT JOIN ps_htmlbanners11_slides hss ON (hs.id_htmlbanners11_slides = hss.id_htmlbanners11_slides)
LEFT JOIN ps_htmlbanners11_slides_lang hssl ON (hss.id_htmlbanners11_slides = hssl.id_htmlbanners11_slides)
WHERE id_shop = 1
AND hssl.id_lang = 2 AND hss.`active` = 1
ORDER BY hss.position

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 = 1)
WHERE (s.`active` = 1)
GROUP BY s.id_supplier
ORDER BY  s.`name` ASC

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

SELECT SQL_NO_CACHE 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 value FROM `ps_configuration` WHERE `name` = "PS_MULTISHOP_FEATURE_ACTIVE" LIMIT 1

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

SELECT SQL_NO_CACHE fl.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 = 51009)
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 = 1)
WHERE pf.id_product = 51009
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 fl.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 = 42517)
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 = 1)
WHERE pf.id_product = 42517
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 fl.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 = 24799)
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 = 1)
WHERE pf.id_product = 24799
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 fl.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 = 15729)
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 = 1)
WHERE pf.id_product = 15729
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 *
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` = 1
WHERE (a.`id_product` = 24799) AND (b.`id_shop` = 1) LIMIT 1

SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
JOIN `ps_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `ps_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 2)
JOIN `ps_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (42517,15729,51009,24799) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;

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

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

SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 2
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 42517) AND (b.`id_shop` = 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` = 1
WHERE (a.`id_product` = 15729) AND (b.`id_shop` = 1) LIMIT 1

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

SELECT SQL_NO_CACHE hs.`id_htmlbanners4_slides` as id_slide, hss.`position`, hss.`active`, hssl.`title`,
hssl.`url`, hssl.`legend`, hssl.`customclass`, hssl.`description`, hssl.`image`
FROM ps_htmlbanners4 hs
LEFT JOIN ps_htmlbanners4_slides hss ON (hs.id_htmlbanners4_slides = hss.id_htmlbanners4_slides)
LEFT JOIN ps_htmlbanners4_slides_lang hssl ON (hss.id_htmlbanners4_slides = hssl.id_htmlbanners4_slides)
WHERE id_shop = 1
AND hssl.id_lang = 2 AND hss.`active` = 1
ORDER BY hss.position

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` = 1
WHERE (a.`id_product` = 51009) AND (b.`id_shop` = 1) 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 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` = 4) AND (m.`page` = 'supplier') LIMIT 1

SELECT SQL_NO_CACHE hs.`id_htmlbanners6_slides` as id_slide, hss.`position`, hss.`active`, hssl.`title`,
hssl.`customclass`, hssl.`image`
FROM ps_htmlbanners6 hs
LEFT JOIN ps_htmlbanners6_slides hss ON (hs.id_htmlbanners6_slides = hss.id_htmlbanners6_slides)
LEFT JOIN ps_htmlbanners6_slides_lang hssl ON (hss.id_htmlbanners6_slides = hssl.id_htmlbanners6_slides)
WHERE id_shop = 1
AND hssl.id_lang = 2 AND hss.`active` = 1
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` = 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` = 86
AND tr.`id_tax_rules_group` = 1
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 UNIX_TIMESTAMP(last_update) AS last_update,
filepath
FROM `ps_smarty_lazy_cache`
WHERE (template_hash="d87742c64a44cada59e2d0edb0d0b7c5") AND (cache_id="blocksearch-top|1|1|1|2|86") AND (compile_id="") LIMIT 1

SELECT SQL_NO_CACHE *
FROM `ps_supplier` a
LEFT JOIN `ps_supplier_lang` `b` ON a.`id_supplier` = b.`id_supplier` AND b.`id_lang` = 2
LEFT JOIN `ps_supplier_shop` `c` ON a.`id_supplier` = c.`id_supplier` AND c.`id_shop` = 1
WHERE (a.`id_supplier` = 1) LIMIT 1

SELECT SQL_NO_CACHE p.`ean13` as `ean`
FROM `ps_product` p WHERE p.`id_product` = 24799
UNION SELECT e.`ean` as `ean` FROM `ps_product_ean` e
where e.`product_id` = 24799

SELECT SQL_NO_CACHE `id_image` FROM `ps_image` WHERE `id_product` = 42517 ORDER BY position ASC LIMIT 1, 2

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

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

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

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

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

SELECT SQL_NO_CACHE p.`ean13` as `ean`
FROM `ps_product` p WHERE p.`id_product` = 51009
UNION SELECT e.`ean` as `ean` FROM `ps_product_ean` e
where e.`product_id` = 51009

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

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

SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) AS last_update,
filepath
FROM `ps_smarty_lazy_cache`
WHERE (template_hash="1d06ecc8851e4c0ded8f0f2b7b4f36bd") AND (cache_id="blockcontact|1|1|1|2|86") AND (compile_id="") LIMIT 1

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

SELECT SQL_NO_CACHE hs.`id_htmlbanners6_slides` as id_slide, hss.`position`, hss.`active`, hssl.`title`,
hssl.`customclass`, hssl.`image`
FROM ps_htmlbanners6 hs
LEFT JOIN ps_htmlbanners6_slides hss ON (hs.id_htmlbanners6_slides = hss.id_htmlbanners6_slides)
LEFT JOIN ps_htmlbanners6_slides_lang hssl ON (hss.id_htmlbanners6_slides = hssl.id_htmlbanners6_slides)
WHERE id_shop = 1
AND hssl.id_lang = 2 AND hss.`active` = 1
ORDER BY hss.position

SELECT SQL_NO_CACHE `id_image` FROM `ps_image` WHERE `id_product` = 15729 ORDER BY position ASC LIMIT 1, 2

SELECT SQL_NO_CACHE p.`ean13` as `ean`
FROM `ps_product` p WHERE p.`id_product` = 42517
UNION SELECT e.`ean` as `ean` FROM `ps_product_ean` e
where e.`product_id` = 42517

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

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

SELECT SQL_NO_CACHE p.`ean13` as `ean`
FROM `ps_product` p WHERE p.`id_product` = 15729
UNION SELECT e.`ean` as `ean` FROM `ps_product_ean` e
where e.`product_id` = 15729

SELECT SQL_NO_CACHE *
FROM `ps_supplier` a
LEFT JOIN `ps_supplier_lang` `b` ON a.`id_supplier` = b.`id_supplier` AND b.`id_lang` = 1
LEFT JOIN `ps_supplier_shop` `c` ON a.`id_supplier` = c.`id_supplier` AND c.`id_shop` = 1
WHERE (a.`id_supplier` = 1) LIMIT 1

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

SELECT SQL_NO_CACHE *
FROM `ps_supplier` a
LEFT JOIN `ps_supplier_shop` `c` ON a.`id_supplier` = c.`id_supplier` AND c.`id_shop` = 1
WHERE (a.`id_supplier` = 1) LIMIT 1

SELECT SQL_NO_CACHE `id_image` FROM `ps_image` WHERE `id_product` = 51009 ORDER BY position ASC LIMIT 1, 2

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

SELECT SQL_NO_CACHE 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` = 1) AND (l.`active` = 1) LIMIT 1

SELECT SQL_NO_CACHE `name`, `meta_title`, `meta_description`, `meta_keywords`
FROM `ps_supplier_lang` sl
LEFT JOIN `ps_supplier` `s` ON sl.`id_supplier` = s.`id_supplier`
WHERE (sl.`id_lang` = 2) AND (sl.`id_supplier` = 1) LIMIT 1

SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) AS last_update,
filepath
FROM `ps_smarty_lazy_cache`
WHERE (template_hash="db63915b4c6276b3a7144c14b8ae9a5b") AND (cache_id="htmlbanners11|1|1|1|2|86") AND (compile_id="") LIMIT 1

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

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

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

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

SELECT SQL_NO_CACHE `id_module`, `name`
FROM `ps_module`

SELECT SQL_NO_CACHE `id_image` FROM `ps_image` WHERE `id_product` = 24799 ORDER BY position ASC LIMIT 1, 2

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` = 86
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_hook_module_exceptions`
WHERE (`id_shop` IN (1))

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

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

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

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

SELECT SQL_NO_CACHE `name`
FROM `ps_image_type`

SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) AS last_update,
filepath
FROM `ps_smarty_lazy_cache`
WHERE (template_hash="e3c5fe8ee5b91b02ba613ee2557e1e8a") AND (cache_id="productlist_colors|15729|1|2") AND (compile_id="") LIMIT 1

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

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

SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) AS last_update,
filepath
FROM `ps_smarty_lazy_cache`
WHERE (template_hash="e3c5fe8ee5b91b02ba613ee2557e1e8a") AND (cache_id="productlist_colors|51009|1|2") AND (compile_id="") LIMIT 1

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

SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) AS last_update,
filepath
FROM `ps_smarty_lazy_cache`
WHERE (template_hash="e96a97cc9068df52ab3605800f451556") AND (cache_id="htmlbanners8|1|1|1|2|86") AND (compile_id="") LIMIT 1

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

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

SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) AS last_update,
filepath
FROM `ps_smarty_lazy_cache`
WHERE (template_hash="e3c5fe8ee5b91b02ba613ee2557e1e8a") AND (cache_id="productlist_colors|42517|1|2") AND (compile_id="") LIMIT 1

INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('e3c5fe8ee5b91b02ba613ee2557e1e8a',"productlist_colors|15729|1|2","", FROM_UNIXTIME(1762863176))

SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) AS last_update,
filepath
FROM `ps_smarty_lazy_cache`
WHERE (template_hash="ed659e8651e0ff1aaed95f2b31e4da80") AND (cache_id="htmlbanners7|1|1|1|2|86") AND (compile_id="") LIMIT 1

SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) AS last_update,
filepath
FROM `ps_smarty_lazy_cache`
WHERE (template_hash="474a69f78a163a0ed295839444823472") AND (cache_id="htmlbanners6|1|1|1|2|86") AND (compile_id="") LIMIT 1

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

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

SELECT SQL_NO_CACHE `reduction`
FROM `ps_product_group_reduction_cache`
WHERE (`id_product` = 24799) AND (`id_group` = 1) LIMIT 1

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

SELECT SQL_NO_CACHE * FROM `ps_hook_alias`

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

SELECT SQL_NO_CACHE *
FROM `ps_supplier_lang`
WHERE (`id_supplier` = 1)

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

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

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

SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) AS last_update,
filepath
FROM `ps_smarty_lazy_cache`
WHERE (template_hash="464a9a36a0645b3a54c55229b618f18c") AND (cache_id="blockpaymentlogo|1|1|1|2|86") AND (compile_id="") LIMIT 1

SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) AS last_update,
filepath
FROM `ps_smarty_lazy_cache`
WHERE (template_hash="e3c5fe8ee5b91b02ba613ee2557e1e8a") AND (cache_id="productlist_colors|24799|1|2") AND (compile_id="") LIMIT 1

INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('e3c5fe8ee5b91b02ba613ee2557e1e8a',"productlist_colors|42517|1|2","", FROM_UNIXTIME(1762863176))

SELECT SQL_NO_CACHE `nleft`, `nright`, `level_depth`
FROM `ps_category`
WHERE (`id_category` = 2911) LIMIT 1

SELECT SQL_NO_CACHE `reduction`
FROM `ps_product_group_reduction_cache`
WHERE (`id_product` = 42517) AND (`id_group` = 1) LIMIT 1

INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('e3c5fe8ee5b91b02ba613ee2557e1e8a',"productlist_colors|51009|1|2","", FROM_UNIXTIME(1762863176))

SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) AS last_update,
filepath
FROM `ps_smarty_lazy_cache`
WHERE (template_hash="5bd4080c91e7df4b3c85646a2da3a1a8") AND (cache_id="blockcontactinfos|1|1|1|2|86") AND (compile_id="") LIMIT 1

SELECT SQL_NO_CACHE *
FROM `ps_tax` a
WHERE (a.`id_tax` = 1) LIMIT 1

SELECT SQL_NO_CACHE `reduction`
FROM `ps_product_group_reduction_cache`
WHERE (`id_product` = 51009) AND (`id_group` = 1) LIMIT 1

INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('e3c5fe8ee5b91b02ba613ee2557e1e8a',"productlist_colors|42517|1|2","", FROM_UNIXTIME(1762863176))

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

SELECT SQL_NO_CACHE `id_module`
FROM `ps_module_shop`
WHERE (`id_module` = 47) AND (`id_shop` = 1) LIMIT 1

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

INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('e3c5fe8ee5b91b02ba613ee2557e1e8a',"productlist_colors|24799|1|2","", FROM_UNIXTIME(1762863176))

SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) AS last_update,
filepath
FROM `ps_smarty_lazy_cache`
WHERE (template_hash="e9c3dc07fbfc6972eea91b9c9f7262ea") AND (cache_id="blocktopmenu|1|1|1|2|86|supplier|1") AND (compile_id="") LIMIT 1

INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('e3c5fe8ee5b91b02ba613ee2557e1e8a',"productlist_colors|51009|1|2","", FROM_UNIXTIME(1762863176))

SELECT SQL_NO_CACHE *
FROM `ps_tax_lang`
WHERE (`id_tax` = 1)

SELECT SQL_NO_CACHE `reduction`
FROM `ps_product_group_reduction_cache`
WHERE (`id_product` = 15729) AND (`id_group` = 1) LIMIT 1

SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) AS last_update,
filepath
FROM `ps_smarty_lazy_cache`
WHERE (template_hash="df1ec426c39b272351fd12dd6d1ba2c5") AND (cache_id="htmlbanners4|1|1|1|2|86") AND (compile_id="") LIMIT 1

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

SELECT SQL_NO_CACHE *
FROM `ps_supplier` a
LEFT JOIN `ps_supplier_lang` `b` ON a.`id_supplier` = b.`id_supplier` AND b.`id_lang` = 3
LEFT JOIN `ps_supplier_shop` `c` ON a.`id_supplier` = c.`id_supplier` AND c.`id_shop` = 1
WHERE (a.`id_supplier` = 1) LIMIT 1

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

INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('e3c5fe8ee5b91b02ba613ee2557e1e8a',"productlist_colors|15729|1|2","", FROM_UNIXTIME(1762863176))

SELECT SQL_NO_CACHE id_shop
FROM `ps_supplier_shop`
WHERE `id_supplier` = 1
AND id_shop = 1 LIMIT 1

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

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

INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('e3c5fe8ee5b91b02ba613ee2557e1e8a',"productlist_colors|24799|1|2","", FROM_UNIXTIME(1762863176))

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

SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) AS last_update,
filepath
FROM `ps_smarty_lazy_cache`
WHERE (template_hash="97916ab939af07ea0acb2ecf4b7c5498") AND (cache_id="blockcms|2|1|1|1|2|86") AND (compile_id="") LIMIT 1

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

SELECT SQL_NO_CACHE `id_lang`
FROM `ps_lang`
WHERE (`iso_code` = 'et') LIMIT 1

SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) AS last_update,
filepath
FROM `ps_smarty_lazy_cache`
WHERE (template_hash="72c877bed0b8dce360b8cb56e54fa337") AND (cache_id="blockmyaccountfooter|1|1|1|2|86") AND (compile_id="") LIMIT 1

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

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