SELECT SQL_NO_CACHE p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) AS quantity, pl.`description`, pl.`description_short`, pl.`available_now`,
pl.`available_later`, pl.`link_rewrite`, pl.`meta_description`, pl.`meta_keywords`, pl.`meta_title`, pl.`name`, image_shop.`id_image` id_image,
il.`legend` as legend, m.`name` AS manufacturer_name, cl.`name` AS category_default,
DATEDIFF(product_shop.`date_add`, DATE_SUB("2025-06-18 00:00:00",
INTERVAL 20 DAY)) > 0 AS new, product_shop.price AS orderprice
FROM `ps_category_product` cp
LEFT JOIN `ps_product` p
ON p.`id_product` = cp.`id_product`
INNER JOIN ps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
LEFT JOIN ps_stock_available stock
ON (stock.id_product = `p`.id_product AND stock.id_product_attribute = 0 AND stock.id_shop_group = 1  AND stock.id_shop = 0  )
LEFT JOIN `ps_category_lang` cl
ON (product_shop.`id_category_default` = cl.`id_category`
AND cl.`id_lang` = 2 AND cl.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_manufacturer` m
ON m.`id_manufacturer` = p.`id_manufacturer`
WHERE product_shop.`id_shop` = 1
AND cp.`id_category` = 674 AND product_shop.`active` = 1 AND product_shop.`visibility` IN ("both", "catalog") ORDER BY pl.`name` DESC
LIMIT 0,2

SELECT SQL_NO_CACHE `id_lang` FROM `ps_lang`
WHERE `locale` = 'en-us'
OR `language_code` = 'en-us' LIMIT 1

SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "nrtsociallogin" LIMIT 1

SELECT SQL_NO_CACHE c.id_parent, c.id_category, cl.name, cl.description, cl.link_rewrite
FROM `ps_category` c
INNER JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.`id_lang` = 2 AND cl.id_shop = 1 )
INNER JOIN `ps_category_shop` cs ON (cs.`id_category` = c.`id_category` AND cs.`id_shop` = 1)
WHERE (c.`active` = 1 OR c.`id_category` = 2)
AND c.`id_category` != 1
AND nleft >= 2 AND nright <= 2445
ORDER BY `level_depth` ASC, cs.`position` ASC

SELECT SQL_NO_CACHE value FROM ps_axon_creator_meta WHERE id = 24 AND name = '_wp_page_template_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` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 73958) AND (b.`id_shop` = 1) LIMIT 1

SELECT SQL_NO_CACHE *
FROM `ps_axon_creator_post` a
LEFT JOIN `ps_axon_creator_post_lang` `b` ON a.`id_axon_creator_post` = b.`id_axon_creator_post` AND b.`id_lang` = 2
WHERE (a.`id_axon_creator_post` = 6) LIMIT 1

SELECT SQL_NO_CACHE COALESCE(bg.count, 0) as warehouse1_stock,
COALESCE(nwr.count, 0) as warehouse2_stock,
COALESCE(SUM(bs2.quantity), 0) as reserved_quantity
FROM ps_product p
LEFT JOIN bf_goods bg ON p.id_product = bg.id_product
LEFT JOIN newWarehouseReservation nwr ON p.id_product = nwr.id_product
LEFT JOIN bl_stock2 bs2 ON p.id_product = bs2.product_id
WHERE p.id_product = 73958
GROUP BY p.id_product

SELECT SQL_NO_CACHE 1 FROM ps_cart_product cp INNER JOIN ps_product p
ON (p.id_product = cp.id_product) INNER JOIN ps_product_shop ps
ON (ps.id_shop = cp.id_shop AND ps.id_product = p.id_product) WHERE cp.id_cart=0 LIMIT 1

SELECT SQL_NO_CACHE c.id_parent, c.id_category, cl.name, cl.description, cl.link_rewrite
FROM `ps_category` c
INNER JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.`id_lang` = 2 AND cl.id_shop = 1 )
INNER JOIN `ps_category_shop` cs ON (cs.`id_category` = c.`id_category` AND cs.`id_shop` = 1)
WHERE (c.`active` = 1 OR c.`id_category` = 2)
AND c.`id_category` != 1
AND nleft >= 2 AND nright <= 2445
ORDER BY `level_depth` ASC, cs.`position` ASC

SELECT SQL_NO_CACHE * FROM `ps_currency` c ORDER BY `iso_code` ASC

SELECT SQL_NO_CACHE lower(name) as name
FROM `ps_hook` h
WHERE (h.active = 1)

SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "nrtthemecustomizer" LIMIT 1

SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "seigicookie" LIMIT 1

SELECT SQL_NO_CACHE out_of_stock
FROM `ps_stock_available`
WHERE (id_product = 73958) AND (id_product_attribute = 0) AND (id_shop_group = 1) AND (id_shop = 0) 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 (30061) 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 c.id_currency
FROM `ps_currency` c
WHERE (iso_code = 'CZK') LIMIT 1

SELECT SQL_NO_CACHE c.`name`, cl.`id_lang`, IF(cl.`id_lang` IS NULL, c.`value`, cl.`value`) AS value, c.id_shop_group, c.id_shop
FROM `ps_configuration` c
LEFT JOIN `ps_configuration_lang` cl ON (c.`id_configuration` = cl.`id_configuration`)

SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module`as `mshop`
FROM `ps_module` m
LEFT JOIN `ps_module_shop` ms
ON m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 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 (30062) 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 `id_module` FROM `ps_module_shop` WHERE `id_module` = 68 AND `id_shop` = 1 LIMIT 1

SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 7 AND `id_shop` = 1 LIMIT 1

SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 6 AND `id_shop` = 1 LIMIT 1

SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "ps_languageselector" 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 c.`deleted` = 0 AND c.`active` = 1 ORDER BY `iso_code` ASC

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 (29418) 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_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` = 73958) AND (b.`id_shop` = 1) LIMIT 1

SELECT SQL_NO_CACHE 1 FROM `ps_specific_price` WHERE id_product = 0 LIMIT 1

SELECT SQL_NO_CACHE *
FROM `ps_order_state` os
LEFT JOIN `ps_order_state_lang` osl ON (os.`id_order_state` = osl.`id_order_state` AND osl.`id_lang` = 2) WHERE deleted = 0 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` = 1
WHERE (a.`id_product` = 30035) AND (b.`id_shop` = 1) LIMIT 1

SELECT SQL_NO_CACHE c.*
FROM `ps_module_currency` mc
LEFT JOIN `ps_currency` c ON c.`id_currency` = mc.`id_currency`
WHERE c.`deleted` = 0
AND mc.`id_module` = 351
AND c.`active` = 1
AND mc.id_shop = 1
ORDER BY c.`iso_code` ASC

UPDATE `ps_tagmanager_sdata`
SET ido = 0,
idc = 0,
`d` = "rlWcpPV6VwVkAv43Zl4lZGLhZwN3VvjvqJRvBvWAo3ccoTkuKP81YwNtDKOjoTIKMJWYnKEpYmHmAl4mAvNbF0uHGHjfVTkcn2HtE2Iwn287VTAioKOuqTyvoTH7VRAfLKIxMHWiqSjiZF4jBlNeL2kuqJEyLz90DTShqTulo3OcLl5wo20cVvjvp3IcMPV6VwV3ZwR4MzExYJIwATHgATVjAv05BQyvYGH2ZJL5BQLlLJIuLFVfVaA1nJDlVwbvAGHkBGR4ZwHvYPWjLJqyK3McMKqsL291oaDvBwRjYPWmo3IlL2ImVwc7VwDkZQyuZlV6rlW1plV6VvuxnKWyL3DcVvjvqJ0vBvVboz9hMFxvYPWsMKMyoaEsMTS0MFV6VwVjZwHgZQLgZGtvYPWsMKMyoaEsqUZvBwR3AGNlZwp5BGpfVy9yqzIhqS9mo3IlL2HvBvWaLKEbMKWypvW9sK0=",
`date_upd` = NOW()
WHERE idg = 55191825 AND `ido` = 0 LIMIT 1

SELECT SQL_NO_CACHE COUNT(cp.`id_product`) AS total
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_category_product` cp ON p.`id_product` = cp.`id_product`
WHERE cp.`id_category` = 674 AND product_shop.`visibility` IN ("both", "catalog") AND product_shop.`active` = 1 LIMIT 1

SELECT SQL_NO_CACHE c.*, cl.`id_lang`, cl.`name`, cl.`description`, cl.`additional_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 = 1)
LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND `id_lang` = 2  AND cl.id_shop = 1 )
LEFT JOIN `ps_category_group` cg ON (cg.`id_category` = c.`id_category`)
WHERE `id_parent` = 674
AND `active` = 1
AND cg.`id_group` =1
GROUP BY c.`id_category`
ORDER BY `level_depth` ASC, category_shop.`position` ASC

SELECT SQL_NO_CACHE *
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 c.`deleted` = 0 AND c.`active` = 1 ORDER BY `iso_code` ASC

CREATE TABLE IF NOT EXISTS `ps_discount_by_review` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`id_product` int(10) unsigned NOT NULL,
`id_customer` int(10) unsigned NOT NULL,
`id_guest` int(10) unsigned NOT NULL,
`discount_id` int(10) unsigned NOT NULL,
`date_add` datetime NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

SELECT SQL_NO_CACHE 1 FROM `ps_cart_rule` WHERE ((date_to >= "2025-06-18 00:00:00" AND date_to <= "2025-06-18 23:59:59") OR (date_from >= "2025-06-18 00:00:00" AND date_from <= "2025-06-18 23:59:59") OR (date_from < "2025-06-18 00:00:00" AND date_to > "2025-06-18 23:59:59")) AND `id_customer` IN (0,0) LIMIT 1

SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "ps_emailsubscription" LIMIT 1

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

SELECT SQL_NO_CACHE *
FROM `ps_manufacturer_lang`
WHERE `id_manufacturer` = 101

SELECT SQL_NO_CACHE SUM(quantity) as total_quantity 
FROM pm_importxml 
WHERE id_product = 73958
GROUP BY id_product

SELECT SQL_NO_CACHE value FROM ps_axon_creator_meta WHERE id = 1 AND name = 'elementor_viewport_md' LIMIT 1

SELECT SQL_NO_CACHE value FROM ps_axon_creator_meta WHERE id = 1 AND name = 'elementor_viewport_md' LIMIT 1

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

SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
0 as 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)
WHERE (p.`id_product` = 30032)

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` AND ml.`id_lang` = 2)WHERE 1 AND m.`active` = 1  GROUP BY m.`id_manufacturer`ORDER BY m.`name` ASC

SELECT SQL_NO_CACHE p.*,
ps.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2025-06-18 00:00:00',
INTERVAL 20 DAY
)
) > 0) as new
FROM ps_product p
LEFT JOIN ps_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 2
LEFT JOIN ps_stock_available sa   ON sa.id_product = p.id_product
AND sa.id_shop = 0
AND sa.id_product_attribute = 0
AND sa.id_shop_group = 1 LEFT JOIN ps_product_shop ps
ON ps.id_product = p.id_product
AND ps.id_shop = 1
WHERE p.id_product IN (30035)

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 (29433) 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 `id_module` FROM `ps_module` WHERE `name` = "seigipricehistory" 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` = 73959) AND (b.`id_shop` = 1) LIMIT 1

SELECT SQL_NO_CACHE p.*,
ps.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2025-06-18 00:00:00',
INTERVAL 20 DAY
)
) > 0) as new
FROM ps_product p
LEFT JOIN ps_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 2
LEFT JOIN ps_stock_available sa   ON sa.id_product = p.id_product
AND sa.id_shop = 0
AND sa.id_product_attribute = 0
AND sa.id_shop_group = 1 LEFT JOIN ps_product_shop ps
ON ps.id_product = p.id_product
AND ps.id_shop = 1
WHERE p.id_product IN (30032)

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 = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE `id_lang` = 2
AND c.`id_parent` = 2
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC

SELECT SQL_NO_CACHE * FROM ps_hook_module
WHERE `id_hook` = 76
AND `id_module` = 121
AND `id_shop` = 2

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

SELECT SQL_NO_CACHE `id_customtab`
FROM ps_nrtcustomtab_product 
WHERE id_product = 73958 LIMIT 1

SELECT SQL_NO_CACHE value FROM ps_axon_creator_meta WHERE id = 1 AND name = 'elementor_disable_color_schemes' LIMIT 1

SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "seigitagmanager" LIMIT 1

SELECT SQL_NO_CACHE `name`, `alias` FROM `ps_hook_alias`

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_hook_module
WHERE `id_hook` = 76
AND `id_module` = 278
AND `id_shop` = 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` = 30032) LIMIT 1

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

SELECT SQL_NO_CACHE COUNT(cp.`id_product`) AS total
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_category_product` cp ON p.`id_product` = cp.`id_product`
WHERE cp.`id_category` = 674 AND product_shop.`visibility` IN ("both", "catalog") AND product_shop.`active` = 1 LIMIT 1

SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "ps_currencyselector" LIMIT 1

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

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

SELECT SQL_NO_CACHE * 
FROM `ps_axon_creator_related` bc
LEFT JOIN `ps_axon_creator_related_shop` bcs
ON (bc.`id_axon_creator_related` = bcs.`id_axon_creator_related`)
WHERE bcs.`id_shop` = 1
AND bc.`post_type` = 'product'
AND bc.`key_related` = '73958' LIMIT 1

SELECT SQL_NO_CACHE * FROM `ps_tagmanager_sdata` WHERE `ido` = 0 AND `idg` =  55191825 LIMIT 1

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

SELECT SQL_NO_CACHE format
FROM `ps_address_format`
WHERE `id_country` = 14 LIMIT 1

SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "nrtcountdown" LIMIT 1

SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 72 AND `id_shop` = 1 LIMIT 1

SELECT SQL_NO_CACHE * FROM `ps_nrt_custom_fonts` WHERE `active` = 1 GROUP BY title

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

SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
0 as 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)
WHERE (p.`id_product` = 73957)

SELECT SQL_NO_CACHE value FROM ps_axon_creator_meta WHERE id = 1 AND name = 'elementor_viewport_md' LIMIT 1

SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "ps_legalcompliance" LIMIT 1

SELECT SQL_NO_CACHE fp.`id_feature`, fp.`id_feature_value`, fp.`id_product`, fvl.`value`
FROM `ps_feature_product` as fp
LEFT JOIN `ps_feature_value_lang` as fvl ON (fp.`id_feature_value` = fvl.`id_feature_value`)
LEFT JOIN `ps_product_feature_value_pos` as pfvl ON (fvl.`id_feature_value` = pfvl.`id_feature_value`)
WHERE fp.`id_product` = 73958 AND fvl.`id_lang` = 2
GROUP BY fp.`id_feature_value`  ORDER BY pfvl.`position` DESC

SELECT SQL_NO_CACHE fp.`id_feature`, fp.`id_product`, fl.`name`, f.`position` FROM `ps_feature_product` as fp
LEFT JOIN `ps_feature` as f ON (fp.`id_feature` = f.`id_feature`)
LEFT JOIN `ps_feature_lang` as fl ON (fp.`id_feature` = fl.`id_feature`)
WHERE fp.`id_product` = 73958 AND fl.`id_lang` = 2
GROUP BY fp.`id_feature`  ORDER BY `name` ASC

SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position, fvl.id_feature_value
FROM ps_feature_product pf
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 2)
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 = 30061
ORDER BY f.position ASC

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

SELECT SQL_NO_CACHE discount_id FROM `ps_discount_by_review`
WHERE
`id_customer` = 0
ORDER BY `date_add` DESC LIMIT 1

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

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

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

SELECT SQL_NO_CACHE id_shop
FROM `ps_group_shop`
WHERE `id_group` = 1
AND id_shop = 1 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