SELECT SQL_NO_CACHE `id_product`
FROM `ps_product_lang`
WHERE (`link_rewrite` = 'cart') AND (`id_lang` = 3) AND (`id_shop` = 1)

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

SELECT SQL_NO_CACHE `id_category`
FROM `ps_category_lang`
WHERE (`link_rewrite` = 'cart') AND (`id_lang` = 3) AND (`id_shop` = 1)

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

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 = 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_state`
ORDER BY `name` ASC

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 = 3 AND hss.`active` = 1
ORDER BY hss.position

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 `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_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 = 3 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 = 3 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` = 3
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 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 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 = 3 AND hss.`active` = 1
ORDER BY hss.position

UPDATE `ps_configuration` SET `value` = '1762863170',`date_upd` = '2025-11-11 14:12:50' WHERE `name` = 'NEW_PRODUCTS_TIMESTAMP' AND (id_shop_group IS NULL OR id_shop_group = 0) AND (id_shop IS NULL OR id_shop = 0) 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 = 3 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 = 3 AND hss.`active` = 1
ORDER BY hss.position

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

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

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

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 = 3
AND o.active = 1
GROUP BY b.id_block
ORDER BY bh.hook_name, bh.position

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` = 'cart') LIMIT 1

UPDATE `ps_configuration` SET `value` = '1762863170',`date_upd` = '2025-11-11 14:12:50' WHERE `name` = 'PS_BLOCK_BESTSELLERS_TIMESTAMP' AND (id_shop_group IS NULL OR id_shop_group = 0) AND (id_shop IS NULL OR id_shop = 0) 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 = 3 AND hss.`active` = 1
ORDER BY hss.position

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|3|86") AND (compile_id="") LIMIT 1

SELECT SQL_NO_CACHE *
FROM `ps_hook_module_exceptions`
WHERE (`id_shop` IN (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|3|86") AND (compile_id="") 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 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 UNIX_TIMESTAMP(last_update) AS last_update,
filepath
FROM `ps_smarty_lazy_cache`
WHERE (template_hash="ed659e8651e0ff1aaed95f2b31e4da80") AND (cache_id="htmlbanners7|1|1|1|3|86") AND (compile_id="") LIMIT 1

SELECT SQL_NO_CACHE s.`id_shop`, CONCAT(su.`physical_uri`, su.`virtual_uri`) AS `uri`, su.`domain`, su.`main`
FROM `ps_shop_url` su
LEFT JOIN `ps_shop` `s` ON s.`id_shop` = su.`id_shop`
WHERE (su.domain = '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_themeconfigurator`
WHERE (`id_shop` = 1) AND (`id_lang` = 3) AND (`hook` = 'footer') AND (`active` = 1)
ORDER BY `item_order` ASC

SELECT SQL_NO_CACHE *
FROM `ps_meta` m
LEFT JOIN `ps_meta_lang` `ml` ON m.`id_meta` = ml.`id_meta`
WHERE (m.`page` = 'cart' OR m.`page` = 'cart') AND (ml.`id_lang` = 3  AND ml.id_shop = 1 ) LIMIT 1

SELECT SQL_NO_CACHE *
FROM `ps_country` a
LEFT JOIN `ps_country_lang` `b` ON a.`id_country` = b.`id_country` AND b.`id_lang` = 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 * FROM `ps_hook_alias`

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 *
FROM `ps_product` a
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 66171) LIMIT 1

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 UNIX_TIMESTAMP(last_update) AS last_update,
filepath
FROM `ps_smarty_lazy_cache`
WHERE (template_hash="1d06ecc8851e4c0ded8f0f2b7b4f36bd") AND (cache_id="blockcontact|1|1|1|3|86") AND (compile_id="") LIMIT 1

SELECT SQL_NO_CACHE *
FROM `ps_country` a
LEFT JOIN `ps_country_lang` `b` ON a.`id_country` = b.`id_country` AND b.`id_lang` = 3
LEFT JOIN `ps_country_shop` `c` ON a.`id_country` = c.`id_country` AND c.`id_shop` = 1
WHERE (a.`id_country` = 86) 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|3|86") AND (compile_id="") LIMIT 1

SELECT SQL_NO_CACHE *
FROM `ps_theme` a
WHERE (a.`id_theme` = 4) 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 p.`ean13` as `ean`
FROM `ps_product` p WHERE p.`id_product` = 66171
UNION SELECT e.`ean` as `ean` FROM `ps_product_ean` e
where e.`product_id` = 66171

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|3|86") AND (compile_id="") 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 *
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 *
FROM `ps_shop` a
WHERE (a.`id_shop` = 1) LIMIT 1

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

SELECT SQL_NO_CACHE *
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` = 1) LIMIT 1

SELECT SQL_NO_CACHE ctg.`id_group`
FROM `ps_category_product` cp
INNER JOIN `ps_category_group` ctg ON (ctg.`id_category` = cp.`id_category`)
WHERE cp.`id_product` = 66171 AND ctg.`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|3|86") AND (compile_id="") LIMIT 1

DELETE FROM `ps_smarty_lazy_cache`
WHERE template_hash='dbd9bfcfabc8f05128e6c3d42c1f8594' AND cache_id LIKE "blockbestsellers-col%"

SELECT SQL_NO_CACHE `id_lang`
FROM `ps_lang`
WHERE (`iso_code` = 'ru') 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 UNIX_TIMESTAMP(last_update) AS last_update,
filepath
FROM `ps_smarty_lazy_cache`
WHERE (template_hash="e9c3dc07fbfc6972eea91b9c9f7262ea") AND (cache_id="blocktopmenu|1|1|1|3|86|index") AND (compile_id="") LIMIT 1

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

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

SELECT SQL_NO_CACHE *
FROM `ps_product_lang`
WHERE (`id_product` = 66171) AND (`id_shop` = 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|3|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="97916ab939af07ea0acb2ecf4b7c5498") AND (cache_id="blockcms|2|1|1|1|3|86") AND (compile_id="") LIMIT 1

SELECT SQL_NO_CACHE id_required_field, object_name, field_name
FROM ps_required_field

DELETE FROM `ps_smarty_lazy_cache`
WHERE template_hash='3d4bd116ffd2b953dcdf549fb97eea67'

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

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

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

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

SELECT SQL_NO_CACHE id_shop
FROM `ps_currency_shop`
WHERE `id_currency` = 1
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="d87742c64a44cada59e2d0edb0d0b7c5") AND (cache_id="blocksearch-top|1|1|1|3|86") AND (compile_id="") LIMIT 1

DELETE FROM `ps_smarty_lazy_cache`
WHERE template_hash='8bee9b3c34e178657fee3e5a996da556' AND cache_id LIKE "blockbestsellers-tab%"

DELETE FROM `ps_smarty_lazy_cache`
WHERE template_hash='088c0dd0e6a42ae9d243cb07979e3e46' AND cache_id LIKE "blocknewproducts-home%"

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

DELETE FROM `ps_smarty_lazy_cache`
WHERE template_hash='0c7f2e5b99703cde2dba2b0d08a44aa8' AND cache_id LIKE "blocknewproducts-tab%"

DELETE FROM `ps_smarty_lazy_cache`
WHERE template_hash='4da54bbdc603e82a7286f2f40a9d2b99' AND cache_id LIKE "blockbestsellers-home%"